Subversion-Projekte lars-tiefland.ci

Revision

Revision 1351 | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1308 lars 1 
<?php
2 
 
3 
/**
4 
 *
5 
 * @package WebanOS CI
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
7 
 * @copyright 2016
8 
 * @version $Rev: 1352 $
9 
 */
10 
 
11 
class Dokumente_model extends CI_Model
12 
{
13 
	public function get_list($id, $spalte = 'ID', $table = 'Bestellung')
14 
	{
15 
		$sql = "SELECT
16 
				id
17 
			FROM
18 
				dokumente
19 
			WHERE
1310 lars 20 
				table_foreign='".$table."'
1308 lars 21 
			AND
22 
				row_foreign='".$spalte."'
23 
			AND
24 
				data_foreign='".$id."'
25 
		";
26 
		$res = $this->db->query($sql);
27 
		while ($row = $res->unbuffered_row('array'))
28 
		{
29 
			$dokumente[] = $this->get_document($row['id']);
30 
		}
31 
		return $dokumente;
32 
	}
1350 lars 33 
 
1337 lars 34 
	public function get_all()
35 
	{
36 
		$dokumente = array();
1350 lars 37 
		$sql = "SELECT
1337 lars 38 
				id
39 
			FROM
40 
				dokumente
1345 lars 41 
			ORDER BY
42 
				letzte_aenderung_am DESC
1339 lars 43 
			LIMIT
44 
				100
1337 lars 45 
		";
46 
		$res = $this->db->query($sql);
47 
		while ($row = $res->unbuffered_row('array'))
48 
		{
49 
			$dokumente[] = $this->get_document($row['id']);
50 
		}
51 
		return $dokumente;
52 
	}
1308 lars 53 
 
54 
	public function get_document($id)
55 
	{
56 
		$sql = "SELECT
1317 lars 57 
				id,
1352 lars 58 
				table_foreign,
59 
				data_foreign,
60 
				row_foreign,
1317 lars 61 
				document as name,
62 
				letzte_aenderung_am AS date,
63 
				letzte_aenderung_von AS author
1308 lars 64 
			FROM
65 
				dokumente
66 
			WHERE
67 
				id=".$id."
68 
		";
69 
		$res = $this->db->query($sql);
70 
		$row = $res->unbuffered_row('array');
1350 lars 71 
		switch ($row["name"][0])
72 
		{
73 
			case "A":
74 
				$row["docu_type"] = "Auftrag";
75 
				$row["deletable"] = false;
76 
				break;
77 
			case "L":
78 
				$row["docu_type"] = "Lieferschein";
79 
				$row["deletable"] = false;
80 
				break;
81 
			case "R":
82 
				$row["docu_type"] = "Rechnung";
83 
				$row["deletable"] = false;
84 
				break;
85 
			case "G":
86 
				$row["docu_type"] = "Gutschein";
87 
				$row["deletable"] = true;
88 
				break;
89 
			case "a":
90 
				$row["docu_type"] = "Link";
91 
				$row["deletable"] = true;
92 
				break;
93 
			default:
94 
				$row["docu_type"] = "E-Mail";
95 
				$row["deletable"] = true;
96 
				break;
97 
		}
1352 lars 98 
		$row["valid"]=($row["data_foreign"]);
99 
		if ($linkData = unserialize($row["document"]))
100 
		{
101 
			$row["document"] = $linkData["title"];
102 
			if ($linkData["bestellID"])
103 
			{
104 
				$row["document"] .= "_".$linkData["bestellID"];
105 
			}
106 
			$row["link"] = $linkData["link"];
107 
			$row["target"] = $linkData["target"];
108 
		}
1351 lars 109 
		return $row;
1308 lars 110 
	}
1351 lars 111 
}
1308 lars 112 
 
113 
?>