Subversion-Projekte lars-tiefland.ci

Revision

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

Revision 1409 Revision 1410
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: 1409 $
 8 
 * @version $Rev: 1410 $
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 135... Zeile 135...
135 
			{
 135 
			{
136 
				case 0: //alle
 136 
				case 0: //alle
137 
					$sql_filter[] = "";
 137 
					$sql_filter[] = "";
138 
					break;
 138 
					break;
139 
				case 1:
 139 
				case 1:
140 
					if (isset($GLOBALS["web_rechte"]["Warenwirtschaft"]["bestellung"]["adressbuch"]))
 140 
					if (isset($GLOBALS["web_rechte"]["general"]["laenderzuordnung"]["global"]))
141 
					{
 141 
					{
142 
						$coFeld = "co.country";
 - 
 
143 
						if (isset($GLOBALS["web_rechte"]["general"]["laenderzuordnung"]["global"]))
 142 
						if ($GLOBALS["web_rechte"]["online_shop"]["language"]["standardsprache"] == "UK")
144 
						{
 143 
						{
145 
							if ($GLOBALS["web_rechte"]["online_shop"]["language"]["standardsprache"] == "UK")
 - 
 
146 
							{
 - 
 
147 
								$coFeld = "co.`name-en`";
 144 
							$coFeld = "co.`name-en`";
148 
								$coFeldSip = "coShip.`name-en`";
 145 
							$coFeldSip = "coShip.`name-en`";
149 
								$coFeldBill = "coBill.`name-en`";
 146 
							$coFeldBill = "coBill.`name-en`";
150 
							}
 147 
						}
151 
							else
 148 
						else
152 
							{
 149 
						{
153 
								$coFeld = "co.`name-ger`";
 150 
							$coFeld = "co.`name-ger`";
154 
								$coFeldShip = "coShip.`name-ger`";
 151 
							$coFeldShip = "coShip.`name-ger`";
155 
								$coFeldBill = "coBill.`name-ger`";
 152 
							$coFeldBill = "coBill.`name-ger`";
156 
							}
 - 
 
157 
						}
 153 
						}
158 
						$sql_filter[] = $coFeldShip." NOT LIKE '%Deutschland%'";
 - 
 
159 
						$sql_filter[] = $coFeldShip." NOT LIKE '%Germany%'";
 - 
 
160 
						$sql_filter[] = $coFeldBill." NOT LIKE '%Deutschland%'";
 - 
 
161 
						$sql_filter[] = $coFeldBill." NOT LIKE '%Germany%'";
 - 
 
162 
					}
 - 
 
163 
					else
 - 
 
164 
					{
 - 
 
165 
						$sql_filter[] = " b.liefer_Land NOT LIKE '%Deutschland%'";
 - 
 
166 
						$sql_filter[] = " l.Land NOT LIKE '%Deutschland%'";
 - 
 
167 
						$sql_filter[] = " b.liefer_Land NOT LIKE '%Germany%'";
 - 
 
168 
						$sql_filter[] = " l.Land NOT LIKE '%Germany%'";
 - 
 
169 
					}
 154 
					}
- 
 
 155 
					$sql_filter[] = $coFeldShip." NOT LIKE '%Deutschland%'";
- 
 
 156 
					$sql_filter[] = $coFeldShip." NOT LIKE '%Germany%'";
- 
 
 157 
					$sql_filter[] = $coFeldBill." NOT LIKE '%Deutschland%'";
- 
 
 158 
					$sql_filter[] = $coFeldBill." NOT LIKE '%Germany%'";
170 
					break;
 159 
					break;
171 
				default:
 160 
				default:
Zeile 172... Zeile 161...
172 
 
 161 
 
173 
					if (isset($GLOBALS["web_rechte"]["Warenwirtschaft"]["bestellung"]["adressbuch"]))
 162 
					if ($GLOBALS["web_rechte"]["online_shop"]["language"]["standardsprache"] == "UK")
174 
					{
 - 
 
175 
						$coFeld = "co.country";
 - 
 
176 
						if (isset($GLOBALS["web_rechte"]["general"]["laenderzuordnung"]["global"]))
 - 
 
177 
						{
 - 
 
178 
							if ($GLOBALS["web_rechte"]["online_shop"]["language"]["standardsprache"] == "UK")
 - 
 
179 
							{
 163 
					{
180 
								$coFeld = "co.`name-en`";
 164 
						$coFeld = "co.`name-en`";
181 
								$coFeldSip = "coShip.`name-en`";
 165 
						$coFeldSip = "coShip.`name-en`";
182 
								$coFeldBill = "coBill.`name-en`";
 - 
 
183 
							}
 - 
 
184 
							else
 - 
 
185 
							{
 - 
 
186 
								$coFeld = "co.`name-ger`";
 - 
 
187 
								$coFeldShip = "coShip.`name-ger`";
 - 
 
188 
								$coFeldBill = "coBill.`name-ger`";
 - 
 
189 
							}
 - 
 
190 
						}
 - 
 
191 
						$sql_filter[] = $coFeldShip." LIKE '%".$laender_filter[$filter["laender"]]."%'";
 - 
 
192 
						$sql_filter[] = $coFeldBill." LIKE '%".$laender_filter[$filter["laender"]]."%'";
 166 
						$coFeldBill = "coBill.`name-en`";
193 
					}
 167 
					}
194 
					else
 168 
					else
195 
					{
 - 
 
196 
						//Diese Wenn das Recht nicht gesetzt ist, dann müssen die Länder wieder decodiert werden, damit das SQL keine falschen Daten liefert
 - 
 
197 
						if (!isset($GLOBALS["web_rechte"]["general"]["zeichenkodierung"]["utf-8"]))
 - 
 
198 
						{
 - 
 
199 
							$suchland = html_entity_decode($laender_filter[$filter["laender"]], ENT_COMPAT,
 169 
					{
200 
								"ISO-8859-15");
 - 
 
201 
						}
 - 
 
202 
						else
 - 
 
203 
						{
 170 
						$coFeld = "co.`name-ger`";
204 
							$suchland = $laender_filter[$filter["laender"]];
 - 
 
205 
						}
 171 
						$coFeldShip = "coShip.`name-ger`";
206 
						$sql_filter[] = " (b.liefer_Land LIKE '%".$suchland."%' OR l.Land LIKE '%".$suchland.
 - 
 
207 
							"%')";
 172 
						$coFeldBill = "coBill.`name-ger`";
- 
 
 173 
					}
- 
 
 174 
					$sql_filter[] = $coFeldShip." LIKE '%".$laender_filter[$filter["laender"]]."%'";
208 
					}
 175 
					$sql_filter[] = $coFeldBill." LIKE '%".$laender_filter[$filter["laender"]]."%'";
209 
					break;
 176 
					break;
210 
			}
 177 
			}
Zeile 211... Zeile 178...
211 
		}
 178 
		}
Zeile 412... Zeile 379...
412 
					$kundensuche_filter .= ($elem + 1 == count($fields)) ? "" : " or ";
 379 
					$kundensuche_filter .= ($elem + 1 == count($fields)) ? "" : " or ";
Zeile 413... Zeile 380...
413 
 
 380 
 
414 
				}
 381 
				}
Zeile 415... Zeile 382...
415 
				$kundensuche_filter .= "OR (b.erstellt_von LIKE '".$filter["kundensuche"]."')";
 382 
				$kundensuche_filter .= "OR (b.erstellt_von LIKE '".$filter["kundensuche"]."')";
416 
 
 383 
 
417 
				if (isset($GLOBALS["web_rechte"]["Warenwirtschaft"]["bestellung"]["adressbuch"]))
 - 
 
418 
				{
 - 
 
419 
					$coFeld = "co.country";
 - 
 
Zeile 420... Zeile 384...
420 
					if (isset($GLOBALS["web_rechte"]["general"]["laenderzuordnung"]["global"]))
 384 
				if (isset($GLOBALS["web_rechte"]["general"]["laenderzuordnung"]["global"]))
421 
					{
 385 
				{
Zeile 422... Zeile 386...
422 
 
 386 
 
423 
						if ($GLOBALS["web_rechte"]["online_shop"]["language"]["standardsprache"] == "UK")
 387 
					if ($GLOBALS["web_rechte"]["online_shop"]["language"]["standardsprache"] == "UK")
424 
						{
 388 
					{
425 
 
 389 
 
426 
							$coFeld = "co.`name-en`";
 390 
						$coFeld = "co.`name-en`";
427 
							$coFeldSip = "coShip.`name-en`";
 391 
						$coFeldSip = "coShip.`name-en`";
428 
							$coFeldBill = "coBill.`name-en`";
 392 
						$coFeldBill = "coBill.`name-en`";
429 
						}
 393 
					}
430 
						else
 394 
					else
431 
						{
 - 
 
432 
							$coFeld = "co.`name-ger`";
 395 
					{
433 
							$coFeldShip = "coShip.`name-ger`";
 - 
 
434 
							$coFeldBill = "coBill.`name-ger`";
 - 
 
435 
						}
 - 
 
436 
					}
 - 
 
437 
					$kundensuche_filter .= " or ( ".$coFeldShip." LIKE  '%".$filter["kundensuche"].
 - 
 
438 
						"%' )";
 - 
 
439 
					$kundensuche_filter .= " or ( ".$coFeldBill." LIKE  '%".$filter["kundensuche"].
 - 
 
440 
						"%' )";
 - 
 
441 
				}
 - 
 
442 
				else
 - 
 
443 
				{
 396 
						$coFeld = "co.`name-ger`";
- 
 
 397 
						$coFeldShip = "coShip.`name-ger`";
- 
 
 398 
						$coFeldBill = "coBill.`name-ger`";
- 
 
 399 
					}
- 
 
 400 
				}
Zeile 444... Zeile 401...
444 
					//MK: Lieferland auch abfragen
 401 
				$kundensuche_filter .= " or ( ".$coFeldShip." LIKE  '%".$filter["kundensuche"].
445 
					$kundensuche_filter .= " or ( b.liefer_Land like '%".$filter["kundensuche"].
 402 
					"%' )";
446 
						"%' )";
 403 
				$kundensuche_filter .= " or ( ".$coFeldBill." LIKE  '%".$filter["kundensuche"].
447 
				}
 404 
					"%' )";
Zeile 550... Zeile 507...
550 
		else
 507 
		else
551 
		{
 508 
		{
552 
			$limit = "LIMIT ".$start.", 100";
 509 
			$limit = "LIMIT ".$start.", 100";
553 
		}
 510 
		}
Zeile 554... Zeile -...
554 
 
 - 
 
555 
		if (isset($GLOBALS["web_rechte"]["Warenwirtschaft"]["bestellung"]["adressbuch"]) ||
 - 
 
556 
			column_exists("Bestellung", "ship_addr_id", $webs["datenbank"], $remoteServer_dbh))
 - 
 
557 
		{
 - 
 
558 
 
 511 
 
559 
			$countryTable = "countries co";
 - 
 
560 
			if (isset($GLOBALS["web_rechte"]["general"]["laenderzuordnung"]["global"]))
 - 
 
561 
			{
 - 
 
562 
				$countryTable = "content_management.".$countryTable;
 - 
 
563 
			}
 - 
 
564 
			elseif (!isset($GLOBALS["web_rechte"]["logins"]['admin']['adressverwaltung']) &&
 - 
 
565 
				column_exists("Bestellung", "ship_addr_id", $webs["datenbank"], $remoteServer_dbh))
 - 
 
566 
			{
 512 
		$countryTable = "countries co";
567 
				$countryTable = "content_management.".$countryTable;
 513 
		$countryTable = "content_management.".$countryTable;
568 
				$coFeld = "co.`name-ger`";
 514 
		$coFeld = "co.`name-ger`";
- 
 
 515 
 
569 
 
 516 
		$adresse_join = "
570 
			}
 - 
 
571 
 
 517 
			LEFT JOIN
- 
 
 518 
				bestelladresse baShip
572 
			$adresse_join = "LEFT JOIN bestelladresse baShip
 519 
			ON
- 
 
 520 
				b.ship_addr_id = baShip.id
573 
                         ON   b.ship_addr_id = baShip.id
 521 
			LEFT JOIN
- 
 
 522 
				bestelladresse baBill
574 
                         LEFT JOIN bestelladresse baBill
 523 
			ON
- 
 
 524 
				b.bill_addr_id = baBill.id
575 
                         ON   b.bill_addr_id = baBill.id
 525 
			LEFT JOIN
- 
 
 526 
				".$countryTable."Ship
576 
                         LEFT JOIN ".$countryTable."Ship
 527 
			ON
- 
 
 528 
				coShip.id = baShip.land
577 
                         ON   coShip.id = baShip.land
 529 
			LEFT
- 
 
 530 
				JOIN ".$countryTable."Bill
578 
                         LEFT JOIN ".$countryTable."Bill
 531 
			ON
579 
                         ON   coBill.id = baBill.land
 - 
 
580 
        ";
 532 
				coBill.id = baBill.land
Zeile 581... Zeile 533...
581 
		}
 533 
		";
582 
 
 534 
 
583 
		if (isset($GLOBALS["web_rechte"]["Warenwirtschaft"]["logistiker"]["logistiker"]) &&
 535 
		if (isset($GLOBALS["web_rechte"]["Warenwirtschaft"]["logistiker"]["logistiker"]) &&
584 
			$logistiker_filter != "")
 536 
			$logistiker_filter != "")
Zeile 593... Zeile 545...
593 
			"orders" => array(),
 545 
			"orders" => array(),
594 
			"orderAnz" => 0,
 546 
			"orderAnz" => 0,
595 
			);
 547 
			);
596 
		$sql = "SELECT SQL_CALC_FOUND_ROWS
 548 
		$sql = "SELECT SQL_CALC_FOUND_ROWS
597 
				DISTINCT
 549 
				DISTINCT
- 
 
 550 
				".$r_status_select."
598 
				b.id
 551 
				b.id
599 
			FROM
 552 
			FROM
- 
 
 553 
				artikel_to_Bestellung AS ab
- 
 
 554 
			JOIN
600 
				bestellart ba,
 555 
				Bestellung AS b
- 
 
 556 
			ON
- 
 
 557 
				b.ID=ab.Bestellung
- 
 
 558 
			JOIN
601 
				Logins AS l,
 559 
				Logins AS l
- 
 
 560 
			ON
- 
 
 561 
				l.ID=b.Login
- 
 
 562 
			".$doc_join."
- 
 
 563 
			".$bp_join."
- 
 
 564 
			JOIN
602 
				shops AS s,
 565 
				shops s
- 
 
 566 
			ON
603 
				artikel_to_Bestellung ab,
 567 
				s.id=b.shops_id
- 
 
 568 
			JOIN
604 
				Bestellung b
 569 
				bestellart ba
- 
 
 570 
			ON
- 
 
 571 
				ba.id=b.bestellart_id
605 
			WHERE
 572 
			WHERE
606 
				".implode(" AND ", $sql_filter)."
 573 
				".implode(" AND ", $sql_filter)."
607 
			AND
 - 
 
608 
				l.ID = b.Login
 - 
 
609 
			AND
 - 
 
610 
				s.ID = b.shops_ID
 - 
 
611 
			AND
 - 
 
612 
				ab.bestellung=b.id
 - 
 
613 
			AND
 - 
 
614 
				ba.id=b.bestellart_id
 - 
 
615 
			ORDER BY
 574 
			ORDER BY
616 
				b.id DESC
 575 
				b.id DESC
617 
			LIMIT
 576 
			LIMIT
618 
				100
 577 
				100
619 
		";
 578 
		";