Subversion-Projekte lars-tiefland.ci

Revision

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

Revision 1406 Revision 1407
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: 1406 $
 8 
 * @version $Rev: 1407 $
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 19... Zeile 19...
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 
		$filter = $this->input->post('filter');
- 
 
 24 
    switch ( $filter['versandstatus'] )
- 
 
 25 
    {
- 
 
 26 
        case 1:
- 
 
 27 
            $versandstatus_filter = " ab.status = 'offen' ";
- 
 
 28 
            break;
- 
 
 29 
        case 2:
- 
 
 30 
            $versandstatus_filter = " ab.status = 'freigegeben' ";
- 
 
 31 
            break;
- 
 
 32 
        case 3:
- 
 
 33 
            $versandstatus_filter = " ab.status = 'versand' ";
- 
 
 34 
            break;
- 
 
 35 
        case 4:
- 
 
 36 
            $versandstatus_filter = " ab.status = '' ";
- 
 
 37 
            break;
- 
 
 38 
        case 5:
- 
 
 39 
            $versandstatus_filter = " ab.status = '' or ab.status = 'offen' ";
- 
 
 40 
            break;
- 
 
 41 
        default:
- 
 
 42 
            $versandstatus_filter = "";
- 
 
 43 
            break;
- 
 
 44 
    }
- 
 
 45 
 
- 
 
 46 
    switch ( $filter["status"] )
- 
 
 47 
    {
- 
 
 48 
        case "op": // offene Posten
- 
 
 49 
            $status_filter = " ab.status IN ('offen')";
- 
 
 50 
            break;
- 
 
 51 
        case "ib": // in Bearbeitung
- 
 
 52 
            $status_filter = " ab.status IN ('in Bearbeitung')";
- 
 
 53 
            break;
- 
 
 54 
        case "re": // reserviert
- 
 
 55 
            $status_filter = " ab.status IN ('reserviert')";
- 
 
 56 
            break;
- 
 
 57 
        case "op_ib": // offene Posten & in Bearbeitung
- 
 
 58 
            $status_filter = " ab.status IN ('offen','in Bearbeitung')";
- 
 
 59 
            break;
- 
 
 60 
        case "op_ib_re": // offene Posten & in Bearbeitung
- 
 
 61 
            $status_filter =
- 
 
 62 
                " ab.status IN ('offen', 'in Bearbeitung','reserviert')";
- 
 
 63 
            break;
- 
 
 64 
        case "er": // erledigt
- 
 
 65 
            $status_filter = " ab.status IN ('erledigt')";
- 
 
 66 
            break;
- 
 
 67 
        case "ab": // erledigt
- 
 
 68 
            $status_filter = " ab.status IN ('abgeschlossen')";
- 
 
 69 
            break;
- 
 
 70 
        default: // alle
- 
 
 71 
            $status_filter = "";
- 
 
 72 
            break;
- 
 
 73 
    }
- 
 
 74 
 
- 
 
 75 
    if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["bestellStatus"] ) )
- 
 
 76 
    {
- 
 
 77 
        switch ( $filter["bStatus"] )
- 
 
 78 
        {
- 
 
 79 
            case "of_fr_ve":
- 
 
 80 
                $bStatus_filter =
- 
 
 81 
                    "b.status IN ('offen','freigegeben','versand')";
- 
 
 82 
                break;
- 
 
 83 
            case "offen":
- 
 
 84 
            case "wartend":
- 
 
 85 
            case "storniert":
- 
 
 86 
            case "freigegeben":
- 
 
 87 
            case "versand":
- 
 
 88 
                $bStatus_filter = " b.status='" . $filter["bStatus"] . "'";
- 
 
 89 
                break;
- 
 
 90 
            case "alle":
- 
 
 91 
                $bStatus_filter = "";
- 
 
 92 
                break;
- 
 
 93 
        }
- 
 
 94 
    }
- 
 
 95 
 
- 
 
 96 
    switch ( $filter['bezahlstatus'] )
- 
 
 97 
    {
- 
 
 98 
        case 1:
- 
 
 99 
            $bezahlstatus_filter = " b.bezahlt=0 ";
- 
 
 100 
            break;
- 
 
 101 
        case 2:
- 
 
 102 
            $bezahlstatus_filter = " b.bezahlt=1 ";
- 
 
 103 
            break;
- 
 
 104 
        case 3:
- 
 
 105 
            $bezahlstatus_filter = " b.bezahlt=2 ";
- 
 
 106 
            break;
- 
 
 107 
        case 4:
- 
 
 108 
            $bezahlstatus_filter = " b.bezahlt IN (1,2) ";
- 
 
 109 
            break;
- 
 
 110 
        default:
- 
 
 111 
            $bezahlstatus_filter = "";
- 
 
 112 
            break;
- 
 
 113 
    }
23 
		$filter = $this->input->post('filter');
 114 
 
24 
		if (isset($GLOBALS["web_rechte"]["Warenwirtschaft"]["bestellung"]["bestellStatus"]))
 115 
		if (isset($GLOBALS["web_rechte"]["Warenwirtschaft"]["bestellung"]["bestellStatus"]))
25 
		{
 116 
		{
26 
			switch ($filter["bStatus"])
 117 
			switch ($filter["bStatus"])
27 
			{
 118 
			{