Subversion-Projekte lars-tiefland.ci

<?php

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

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

        public function get_list($start = 0)
        {
                $sql = "SELECT
                                *
                        FROM
                                logistiker
                ";
                $res = $this->db->query($sql);
                while ($row = $res->unbuffered_row('array')) {
                        $logistiker[] = $row;
                }
                return $logistiker;
        }

        public function get($id)
        {
                $sql = "SELECT
                                *
                        FROM
                                logistiker
                        WHERE
                                id=" . $id . "
                ";
                $res = $this->db->query($sql);
                $logistiker = $res->unbuffered_row('array');
                return $logistiker;
        }

        public function save()
        {
        }
        
        public function export($id)
        {
                
        }
        
        public function tracking($id)
        {
                $sql="
                        SELECT
                                *
                        FROM
                                bestellung_paketnummern
                        WHERE
                                logistiker=".$id."
                        ORDER BY
                                datum DESC
                ";
                $res = $this->db->query($sql);
                while ($row = $res->unbuffered_row('array')) {
                        $trackingNr[] = $row;
                }
                return $trackingNr;
        }
}

?>