Subversion-Projekte lars-tiefland.ci

<?php

/**
 * @author Lars Tiefland
 * @copyright 2016
 */

class Artikel_model extends CI_Model
{
        public function list_artikel($father)
        {
                $query = $this->db->get_where('artikel', array(
                        "father" => $father,
                        "language" => "DE",
                        ));
                while ($row = $query->unbuffered_row('array'))
                {
                        $row["itemLink"] = $this->getLink($row["ID"]);
                        $artikel[] = $row;
                }
                return $artikel;
        }
        public function get_artikel($id)
        {
                if (is_numeric($id))
                {
                        $query = $this->db->get_where('artikel', array(
                                'id' => $id,
                                "language" => "DE",
                                ));
                }
        else
        {
            $query=$this->db->get_where('alias',array("alias"=>$id,"type_id"=>1,));
            $row = $query->row_array();
            $id=$row["id"];
                        $query = $this->db->get_where('artikel', array(
                                'id' => $id,
                                "language" => "DE",
                                ));
        }
                return $query->row_array();
        }

        private function getLink($id)
        {
                $res = $this->db->get_where('alias', array(
                        'id' => $id,
                        "type_id" => 1,
                        ));
                $row = $res->row_array();
                return "/artikel/view/".$row["alias"];
        }
}

?>