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;