Subversion-Projekte lars-tiefland.ci

<?php

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

class Dokumente_model extends CI_Model
{
        public function get_list($id, $spalte = 'ID', $table = 'Bestellung')
        {
                $sql = "SELECT
                                id
                        FROM
                                dokumente
                        WHERE
                                table_foreign='".$table."'
                        AND
                                row_foreign='".$spalte."'
                        AND
                                data_foreign='".$id."'
                ";
                $res = $this->db->query($sql);
                while ($row = $res->unbuffered_row('array'))
                {
                        $dokumente[] = $this->get_document($row['id']);
                }
                return $dokumente;
        }
        
        public function get_all()
        {
                $dokumente = array();
                $sql="SELECT
                                id
                        FROM
                                dokumente
                ";
                $res = $this->db->query($sql);
                while ($row = $res->unbuffered_row('array'))
                {
                        $dokumente[] = $this->get_document($row['id']);
                }
                return $dokumente;
        }

        public function get_document($id)
        {
                $sql = "SELECT
                                id,
                                document as name,
                                letzte_aenderung_am AS date,
                                letzte_aenderung_von AS author
                        FROM
                                dokumente
                        WHERE
                                id=".$id."
                ";
                $res = $this->db->query($sql);
                $row = $res->unbuffered_row('array');
                return $row;
        }
}

?>