Subversion-Projekte lars-tiefland.ci

Revision

Revision 1587 | Zur aktuellen Revision | Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1583 lars 1 
<?php
2 
 
3 
/**
4 
 * @author Lars Tiefland
5 
 * @copyright 2016
6 
 */
7 
 
8 
/**
9 
 * Herstellerkatalog_model
10 
 *
11 
 * @package WebanOS CI
12 
 * @author Lars Tiefland
13 
 * @copyright 2016
14 
 * @version $Id: Herstellerkatalog_model.php 1583 2016-11-19 20:44:21Z lars $
15 
 * @access public
16 
 */
17 
class Herstellerkatalog_model extends CI_Model
18 
{
19 
	/**
20 
	 * Herstellerkatalog_model::__construct()
21 
	 *
22 
	 * @return
23 
	 */
24 
	public function __construct()
25 
	{
26 
		parent::__construct();
27 
		$this->load->model('artikel_model', 'artikel');
28 
		$this->load->model('alias_model', 'alias');
29 
		$this->load->model('preise_model', 'preise');
30 
	}
31 
 
32 
	/**
33 
	 * Herstellerkatalog_model::get_info()
34 
	 *
35 
	 * Infos zu einem Hersteller
36 
	 *
37 
	 * @param mixed $hId
38 
	 * @return
39 
	 */
40 
	public function get_list($mode = 'list')
41 
	{
42 
		switch ($mode)
43 
		{
44 
			case "list":
45 
				$sql = "SELECT
46 
						id,
47 
						name
48 
					FROM
49 
						Herstellerkatalog
50 
				";
51 
				$res = $this->db->query($sql);
52 
				$result = $res->result_array();
53 
				break;
54 
			case "dropdown":
55 
				$sql = "SELECT
56 
						id,
57 
						name
58 
					FROM
59 
						Herstellerkatalog
60 
				";
61 
				$res = $this->db->query($sql);
62 
				while ($row = $res->unbuffered_row('array'))
63 
				{
64 
					$result[$row["id"]] = $row["name"];
65 
				}
66 
				break;
67 
		}
68 
		return $result;
69 
	}
70 
}
71 
 
72 
?>