Subversion-Projekte lars-tiefland.ci

Revision

Revision 1337 | Revision 1345 | Zur aktuellen Revision | 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: 1339 $
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 
	}
1337 lars 33 
 
34 
	public function get_all()
35 
	{
36 
		$dokumente = array();
37 
		$sql="SELECT
38 
				id
39 
			FROM
40 
				dokumente
1339 lars 41 
			LIMIT
42 
				100
1337 lars 43 
		";
44 
		$res = $this->db->query($sql);
45 
		while ($row = $res->unbuffered_row('array'))
46 
		{
47 
			$dokumente[] = $this->get_document($row['id']);
48 
		}
49 
		return $dokumente;
50 
	}
1308 lars 51 
 
52 
	public function get_document($id)
53 
	{
54 
		$sql = "SELECT
1317 lars 55 
				id,
56 
				document as name,
57 
				letzte_aenderung_am AS date,
58 
				letzte_aenderung_von AS author
1308 lars 59 
			FROM
60 
				dokumente
61 
			WHERE
62 
				id=".$id."
63 
		";
64 
		$res = $this->db->query($sql);
65 
		$row = $res->unbuffered_row('array');
66 
		return $row;
67 
	}
68 
}
69 
 
70 
?>