Subversion-Projekte lars-tiefland.ci

Revision

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

Revision 1441 Revision 1442
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: 1441 $
 8 
 * @version $Rev: 1442 $
9 
 */
 9 
 */
Zeile 10... Zeile 10...
10 
 
 10 
 
11 
class Order_model extends CI_Model
 11 
class Order_model extends CI_Model
12 
{
 12 
{
Zeile 18... Zeile 18...
18 
		$this->load->model('dokumente_model', 'dokumente');
 18 
		$this->load->model('dokumente_model', 'dokumente');
19 
	}
 19 
	}
Zeile 20... Zeile 20...
20 
 
 20 
 
21 
	public function get_list($start = 0)
 21 
	public function get_list($start = 0)
- 
 
 22 
	{
22 
	{
 23 
		$sort = "b.id DESC";
23 
		$update = $this->input->post('update');
 24 
		$update = $this->input->post('update');
24 
		$filter = $this->session->filter;
 25 
		$filter = $this->session->filter;
25 
		switch ($filter['versandstatus'])
 26 
		switch ($filter['versandstatus'])
26 
		{
 27 
		{
Zeile 505... Zeile 506...
505 
		{
 506 
		{
506 
			$limit = "";
 507 
			$limit = "";
507 
		}
 508 
		}
508 
		elseif ($update["next"] || $update["prev"])
 509 
		elseif ($update["next"] || $update["prev"])
509 
		{
 510 
		{
- 
 
 511 
			$sort = "b.id ASC";
510 
			if ($update["next"])
 512 
			if ($update["next"])
511 
			{
 513 
			{
512 
				$sql_filter[] = " b.id > ".$this->input->post('Bestellung');
 514 
				$sql_filter[] = " b.id > ".$this->input->post('Bestellung');
513 
			}
 515 
			}
514 
			else
 516 
			else
Zeile 585... Zeile 587...
585 
			ON
 587 
			ON
586 
				ba.id=b.bestellart_id
 588 
				ba.id=b.bestellart_id
587 
			WHERE
 589 
			WHERE
588 
				".implode(" AND ", $sql_filter)."
 590 
				".implode(" AND ", $sql_filter)."
589 
			ORDER BY
 591 
			ORDER BY
590 
				b.id DESC
 592 
				".$sort."
591 
			".$limit."
 593 
			".$limit."
592 
		";
 594 
		";
593 
		$res = $GLOBALS['order_db']->query($sql);
 595 
		$res = $GLOBALS['order_db']->query($sql);
594 
		//echo $sql;
 596 
		//echo $sql;
595 
		$sql_anz = "SELECT
 597 
		$sql_anz = "SELECT