Subversion-Projekte lars-tiefland.ci

Revision

Revision 1345 | Revision 1351 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1345 Revision 1350
Zeile 3... Zeile 3...
3 
/**
 3 
/**
4 
 *
 4 
 *
5 
 * @package WebanOS CI
 5 
 * @package WebanOS CI
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
7 
 * @copyright 2016
 7 
 * @copyright 2016
8 
 * @version $Rev: 1345 $
 8 
 * @version $Rev: 1350 $
9 
 */
 9 
 */
Zeile 10... Zeile 10...
10 
 
 10 
 
11 
class Dokumente_model extends CI_Model
 11 
class Dokumente_model extends CI_Model
12 
{
 12 
{
Zeile 28... Zeile 28...
28 
		{
 28 
		{
29 
			$dokumente[] = $this->get_document($row['id']);
 29 
			$dokumente[] = $this->get_document($row['id']);
30 
		}
 30 
		}
31 
		return $dokumente;
 31 
		return $dokumente;
32 
	}
 32 
	}
33
33 
 
34 
	public function get_all()
 34 
	public function get_all()
35 
	{
 35 
	{
36 
		$dokumente = array();
 36 
		$dokumente = array();
37 
		$sql="SELECT
 37 
		$sql = "SELECT
38 
				id
 38 
				id
39 
			FROM
 39 
			FROM
40 
				dokumente
 40 
				dokumente
41 
			ORDER BY
 41 
			ORDER BY
42 
				letzte_aenderung_am DESC
 42 
				letzte_aenderung_am DESC
Zeile 63... Zeile 63...
63 
			WHERE
 63 
			WHERE
64 
				id=".$id."
 64 
				id=".$id."
65 
		";
 65 
		";
66 
		$res = $this->db->query($sql);
 66 
		$res = $this->db->query($sql);
67 
		$row = $res->unbuffered_row('array');
 67 
		$row = $res->unbuffered_row('array');
- 
 
 68 
		switch ($row["name"][0])
- 
 
 69 
		{
- 
 
 70 
			case "A":
- 
 
 71 
				$row["docu_type"] = "Auftrag";
- 
 
 72 
				$row["deletable"] = false;
- 
 
 73 
				break;
- 
 
 74 
			case "L":
- 
 
 75 
				$row["docu_type"] = "Lieferschein";
- 
 
 76 
				$row["deletable"] = false;
- 
 
 77 
				break;
- 
 
 78 
			case "R":
- 
 
 79 
				$row["docu_type"] = "Rechnung";
- 
 
 80 
				$row["deletable"] = false;
- 
 
 81 
				break;
- 
 
 82 
			case "G":
- 
 
 83 
				$row["docu_type"] = "Gutschein";
- 
 
 84 
				$row["deletable"] = true;
- 
 
 85 
				break;
- 
 
 86 
			case "a":
- 
 
 87 
				$row["docu_type"] = "Link";
- 
 
 88 
				$row["deletable"] = true;
- 
 
 89 
				break;
- 
 
 90 
			default:
- 
 
 91 
				$row["docu_type"] = "E-Mail";
- 
 
 92 
				$row["deletable"] = true;
- 
 
 93 
				break;
68 
		return $row;
 94 
				return $row;
- 
 
 95 
		}
69 
	}
 96 
	}
70 
}
 - 
 
Zeile 71... Zeile 97...
71 
 
 97 
 
72 
?>
 98 
?>