@@ 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) { |