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