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);