Subversion-Projekte lars-tiefland.ci

Revision

Revision 2313 | Revision 2315 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 2313 Revision 2314
Zeile 3... Zeile 3...
3 
/**
 3 
/**
4 
 *
 4 
 *
5 
 * @package WebanOS CI
 5 
 * @package WebanOS CI
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
7 
 * @copyright 2016
 7 
 * @copyright 2016
8 
 * @version $Rev: 2313 $
 8 
 * @version $Rev: 2314 $
9 
 */
 9 
 */
Zeile 10... Zeile 10...
10 
 
 10 
 
11 
class Logistiker_model extends CI_Model
 11 
class Logistiker_model extends CI_Model
12 
{
 12 
{
Zeile 48... Zeile 48...
48 
	}
 48 
	}
Zeile 49... Zeile 49...
49 
 
 49 
 
50 
	public function export($id)
 50 
	public function export($id)
51 
	{
 51 
	{
52 
		$aColumns = array("exported");
 52 
		$aColumns = array("exported");
53 
		$sIndexColumn="exported";
 53 
		$sIndexColumn = "exported";
54 
		$sLimit = $this->input->get('iDisplayStart') . "," . $this->input->get('iDisplayLength');
 54 
		$sLimit = $this->input->get('iDisplayStart') . "," . $this->input->get('iDisplayLength');
55 
		$sQuery = "SELECT DISTINCT
 55 
		$sQuery = "SELECT DISTINCT
56 
                    exported
 56 
                    exported
57 
                FROM
 57 
                FROM
Zeile 63... Zeile 63...
63 
                AND
 63 
                AND
64 
                    bl.bestellung = ab.Bestellung
 64 
                    bl.bestellung = ab.Bestellung
65 
                WHERE
 65 
                WHERE
66 
                    exported
 66 
                    exported
Zeile 67... Zeile 67...
67 
 
 67 
 
68 
                $sWhere
 68 
                " . $sWhere . "
69 
                $sOrder
 69 
                " . $sOrder . "
70 
                $sLimit
 70 
                LIMIT " . $sLimit . "
71 
            ";
 71 
            ";
72 
		trigger_error($sQuery);
 72 
		trigger_error($sQuery);
Zeile 73... Zeile 73...
73 
		$rResult = $GLOBALS['order_db']->query($sQuery);
 73 
		$rResult = $GLOBALS['order_db']->query($sQuery);