Subversion-Projekte lars-tiefland.ci

Revision

Revision 2280 | Revision 2285 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
2243 lars 1 
<?php
2 
 
3 
/**
4 
 *
5 
 * @package WebanOS CI
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
7 
 * @copyright 2016
8 
 * @version $Rev: 2283 $
9 
 */
10 
 
11 
class Logistiker_model extends CI_Model
12 
{
13 
	public function __construct()
14 
	{
15 
		parent::__construct();
16 
	}
17 
 
18 
	public function get_list($start = 0)
19 
	{
2244 lars 20 
		$sql = "SELECT
21 
				*
22 
			FROM
23 
				logistiker
24 
		";
2247 lars 25 
		$res = $this->db->query($sql);
2244 lars 26 
		while ($row = $res->unbuffered_row('array')) {
27 
			$logistiker[] = $row;
28 
		}
29 
		return $logistiker;
2243 lars 30 
	}
31 
 
32 
	public function get($id)
33 
	{
2244 lars 34 
		$sql = "SELECT
35 
				*
36 
			FROM
37 
				logistiker
38 
			WHERE
39 
				id=" . $id . "
40 
		";
2247 lars 41 
		$res = $this->db->query($sql);
2244 lars 42 
		$logistiker = $res->unbuffered_row('array');
43 
		return $logistiker;
2243 lars 44 
	}
45 
 
46 
	public function save()
47 
	{
48 
	}
2283 lars 49 
 
2280 lars 50 
	public function export($id)
51 
	{
2283 lars 52 
 
2280 lars 53 
	}
2283 lars 54 
 
2280 lars 55 
	public function tracking($id)
56 
	{
2283 lars 57 
		$sql = "
2280 lars 58 
			SELECT
59 
				*
60 
			FROM
61 
				bestellung_paketnummern
62 
			WHERE
2283 lars 63 
				logistiker=" . $id . "
2280 lars 64 
			ORDER BY
65 
				datum DESC
66 
		";
67 
		$res = $this->db->query($sql);
68 
		while ($row = $res->unbuffered_row('array')) {
2283 lars 69 
			$trackingNr["aaData"][] = $row;
2280 lars 70 
		}
2283 lars 71 
		$trackingNr = json_encode($trackingNr);
2280 lars 72 
		return $trackingNr;
73 
	}
2243 lars 74 
}
75 
 
76 
?>