|
@@ 107-110 (lines=4) @@
|
| 104 |
|
$where[] = " UNIX_TIMESTAMP({$bt}Order{$bt}.{$bt}Created{$bt}) <= '".$exactTime."'"; |
| 105 |
|
$humanWhere[] = ' Order before or on '.Date("r", $exactTime);//r = Example: Thu, 21 Dec 2000 16:01:07 +0200 // also consider: l jS \of F Y H:i Z(e) |
| 106 |
|
break; |
| 107 |
|
case "Email": |
| 108 |
|
$where[] = " {$bt}Member{$bt}.{$bt}Email{$bt} = '".$value."'"; |
| 109 |
|
$humanWhere[] = ' Customer Email equals "'.$value.'"'; |
| 110 |
|
break; |
| 111 |
|
case "FirstName": |
| 112 |
|
$where[] = " {$bt}Member{$bt}.{$bt}FirstName{$bt} LIKE '%".$value."%'"; |
| 113 |
|
$humanWhere[] = ' Customer First Name equals '.$value.'"'; |
|
@@ 111-114 (lines=4) @@
|
| 108 |
|
$where[] = " {$bt}Member{$bt}.{$bt}Email{$bt} = '".$value."'"; |
| 109 |
|
$humanWhere[] = ' Customer Email equals "'.$value.'"'; |
| 110 |
|
break; |
| 111 |
|
case "FirstName": |
| 112 |
|
$where[] = " {$bt}Member{$bt}.{$bt}FirstName{$bt} LIKE '%".$value."%'"; |
| 113 |
|
$humanWhere[] = ' Customer First Name equals '.$value.'"'; |
| 114 |
|
break; |
| 115 |
|
case "Surname": |
| 116 |
|
$where[] = " {$bt}Member{$bt}.{$bt}Surname{$bt} LIKE '%".$value."%'"; |
| 117 |
|
$humanWhere[] = ' Customer Surname equals "'.$value.'"'; |
|
@@ 115-118 (lines=4) @@
|
| 112 |
|
$where[] = " {$bt}Member{$bt}.{$bt}FirstName{$bt} LIKE '%".$value."%'"; |
| 113 |
|
$humanWhere[] = ' Customer First Name equals '.$value.'"'; |
| 114 |
|
break; |
| 115 |
|
case "Surname": |
| 116 |
|
$where[] = " {$bt}Member{$bt}.{$bt}Surname{$bt} LIKE '%".$value."%'"; |
| 117 |
|
$humanWhere[] = ' Customer Surname equals "'.$value.'"'; |
| 118 |
|
break; |
| 119 |
|
case "Status": |
| 120 |
|
$subWhere = array(); |
| 121 |
|
foreach ($value as $item) { |