@@ 228-234 (lines=7) @@ | ||
225 | "// |
|
226 | ); |
|
227 | $fieldArray = $this->getExportFields(); |
|
228 | if (is_array($fieldArray)) { |
|
229 | if (count($fieldArray)) { |
|
230 | foreach ($fieldArray as $key => $field) { |
|
231 | $query->select[] = $key; |
|
232 | } |
|
233 | } |
|
234 | } |
|
235 | foreach ($query->select as $key=>$value) { |
|
236 | if ($value == "RealPayments") { |
|
237 | $query->select[$key] = "SUM(IF(Payment.Status = 'Success',{$bt}Payment{$bt}.{$bt}Amount{$bt}, 0)) RealPayments"; |
@@ 195-201 (lines=7) @@ | ||
192 | $join = " INNER JOIN {$bt}Order{$bt} on {$bt}Order{$bt}.{$bt}ID{$bt} = {$bt}Payment{$bt}.{$bt}OrderID{$bt}" |
|
193 | ); |
|
194 | $fieldArray = $this->getExportFields(); |
|
195 | if (is_array($fieldArray)) { |
|
196 | if (count($fieldArray)) { |
|
197 | foreach ($fieldArray as $key => $field) { |
|
198 | $query->select[] = $key; |
|
199 | } |
|
200 | } |
|
201 | } |
|
202 | foreach ($query->select as $key=>$value) { |
|
203 | if ($value == "OrderSummary") { |
|
204 | $query->select[$key] = "CONCAT({$bt}Order{$bt}.{$bt}ID{$bt}, ' :: ', {$bt}Order{$bt}.{$bt}Created{$bt}, ' :: ', {$bt}Order{$bt}.{$bt}Status{$bt}) AS OrderSummary"; |