Subversion-Projekte lars-tiefland.ci

<?php

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

class Herstellerkatalog_model extends CI_Model
{
        public function __construct()
        {
                parent::__construct();
                $this->load->model('artikel_model', 'artikel');
                $this->load->model('alias_model', 'alias');
                $this->load->model('preise_model', 'preise');
        }

        public function list_hersteller($begin='')
        {
                $where = " EXISTS (SELECT 1 FROM artikel a WHERE a.hersteller=h.id AND a.father > 0 AND a.status=0)";
                if ($begin)
                {
                        $where .= " AND name LIKE '".$begin."%'";
                }
                $this->db->distinct();
                $this->db->order_by('name','ASC');
                $res = $this->db->get_where('Herstellerkatalog h', $where);
                echo $this->db->last_query();
                $rows = $res->result_array();
                return $rows;
        }
}

?>