Subversion-Projekte lars-tiefland.ci

Revision

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

Revision 2316 Revision 2317
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: 2316 $
8
 * @version $Rev: 2317 $
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 50... Zeile 50...
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
		if (isset($_GET['iSortCol_0'])) {
-
 
56
			$sOrder = "ORDER BY  ";
-
 
57
			for ($i = 0; $i < intval($this->input->get('iSortingCols')); $i++) {
-
 
58
				if ($this->input->get('bSortable_' . intval($this->input->get('iSortCol_' . $i))) ==
-
 
59
					"true") {
-
 
60
					$sOrder .= $aColumns[intval($this->input->get('iSortCol_' . $i))] . "
-
 
61
                                    " . $this->input->get('sSortDir_' . $i) .
-
 
62
						", ";
-
 
63
				}
-
 
64
			}
-
 
65
 
-
 
66
			$sOrder = substr_replace($sOrder, "", -2);
-
 
67
			if ($sOrder == "ORDER BY") {
-
 
68
				$sOrder = "";
-
 
69
			}
-
 
70
		}
55
		$sQuery = "SELECT DISTINCT
71
		$sQuery = "SELECT DISTINCT
56
                    exported
72
                    exported
57
                FROM
73
                FROM
58
                    artikel_to_Bestellung ab
74
                    artikel_to_Bestellung ab
59
                JOIN
75
                JOIN