Subversion-Projekte lars-tiefland.ci

<?php

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

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
                        ORDER BY
                                letzte_aenderung_am DESC
                        LIMIT
                                100
                ";
                $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');
                switch ($row["name"][0])
                {
                        case "A":
                                $row["docu_type"] = "Auftrag";
                                $row["deletable"] = false;
                                break;
                        case "L":
                                $row["docu_type"] = "Lieferschein";
                                $row["deletable"] = false;
                                break;
                        case "R":
                                $row["docu_type"] = "Rechnung";
                                $row["deletable"] = false;
                                break;
                        case "G":
                                $row["docu_type"] = "Gutschein";
                                $row["deletable"] = true;
                                break;
                        case "a":
                                $row["docu_type"] = "Link";
                                $row["deletable"] = true;
                                break;
                        default:
                                $row["docu_type"] = "E-Mail";
                                $row["deletable"] = true;
                                break;
                }
                return $row;
        }
}

?>