Subversion-Projekte lars-tiefland.ci

Revision

Revision 1239 | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1239 Revision 2236
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: 1239 $
 8 
 * @version $Rev: 2236 $
9 
 */
 9 
 */
Zeile 10... Zeile 10...
10 
 
 10 
 
11 
class Termine_model extends CI_Model
 11 
class Termine_model extends CI_Model
12 
{
 12 
{
Zeile 21... Zeile 21...
21 
		$sql = "SELECT
 21 
		$sql = "SELECT
22 
				id
 22 
				id
23 
			FROM
 23 
			FROM
24 
				systemtermine
 24 
				systemtermine
25 
			WHERE
 25 
			WHERE
26 
				zielgruppe=".$this->session->user_data['ID']."
 26 
				zielgruppe=" . $this->session->user_data['ID'] . "
27 
			ORDER BY
 27 
			ORDER BY
28 
				faelligkeit DESC,
 28 
				faelligkeit DESC,
29 
				prioritaet DESC
 29 
				prioritaet DESC
30 
		";
 30 
		";
31 
		$res = $this->db->query($sql);
 31 
		$res = $this->db->query($sql);
32 
		$termine["anz"] = $res->num_rows();
 32 
		$termine["anz"] = $res->num_rows();
- 
 
 33 
		$termine["abgelaufen"] = array();
- 
 
 34 
		$termine["kommend"] = array();
33 
		while ($termin = $res->unbuffered_row('array'))
 35 
		while ($termin = $res->unbuffered_row('array')) {
34 
		{
 - 
 
35 
			$termin = $this->get($termin['id']);
 36 
			$termin = $this->get($termin['id']);
36 
			if ($termin["abgelaufen"] == "true")
 37 
			if ($termin["abgelaufen"] == "true") {
37 
			{
 - 
 
38 
				$status = "abgelaufen";
 38 
				$status = "abgelaufen";
39 
			}
 - 
 
40 
			else
 39 
			} else {
41 
			{
 - 
 
42 
				$status = "kommend";
 40 
				$status = "kommend";
43 
			}
 41 
			}
44 
			$termine[$status][] = $termin;
 42 
			$termine[$status][] = $termin;
45 
		}
 43 
		}
46 
		return $termine;
 44 
		return $termine;
Zeile 62... Zeile 60...
62 
				letzte_aenderung_von,
 60 
				letzte_aenderung_von,
63 
				if (faelligkeit < NOW(), 'true', 'false') as abgelaufen
 61 
				if (faelligkeit < NOW(), 'true', 'false') as abgelaufen
64 
			FROM
 62 
			FROM
65 
				systemtermine
 63 
				systemtermine
66 
			WHERE
 64 
			WHERE
67 
				id=".$id."
 65 
				id=" . $id . "
68 
		";
 66 
		";
69 
		$res = $this->db->query($sql);
 67 
		$res = $this->db->query($sql);
70 
		$termin = $res->unbuffered_row('array');
 68 
		$termin = $res->unbuffered_row('array');
71 
		$termin["prioritaet"] = chr($termin["prioritaet"] + 65);
 69 
		$termin["prioritaet"] = chr($termin["prioritaet"] + 65);
72 
		return $termin;
 70 
		return $termin;