Subversion-Projekte lars-tiefland.ci

<?php

/**
 *
 * @package WebanOS CI
 * @author Lars Tiefland <ltiefland@gmail.com> 
 * @copyright 2016
 * @version $Rev: 1224 $
 */

class Termine_model extends CI_Model
{
        public function __construct()
        {
                parent::__construct();
        }

        public function get_list()
        {
                $termine = array();
                $sql = "SELECT
                                id
                        FROM
                                systemtermine
                        WHERE
                                cms_access_id=".$this->session->user_data['ID']."
                        ORDER BY
                                prioritaet,
                                faelligkeit DESC
                ";
                $res = $this->db->query($sql);
                while ($termin = $res->unbuffered_row('array'))
                {
                        $termin = $this->get($termin['id']);
                        $termine[] = $termin;
                }
                return $termine;
        }

        public function get($id)
        {
                $orders = array();
                $sql = "SELECT
                                id,
                                faelligkeit,
                                prioritaet,
                                ueberschrift,
                                nachricht,
                                deeplink,
                                erstellt_am,
                                erstellt_von,
                                letzte_aenderung_am,
                                letzte_aenderung_von
                        FROM
                                systemtermine
                        WHERE
                                id=".$id."
                ";
                $res = $this->db->query($sql);
                $termin = $res->unbuffered_row('array');
                return $termin;
        }
}

?>