| @@ 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"; |
|