EC-CUBE /
ec-cube
| @@ 173-182 (lines=10) @@ | ||
| 170 | } |
|
| 171 | ||
| 172 | // payment |
|
| 173 | if (!empty($searchData['payment']) && count($searchData['payment'])) { |
|
| 174 | $payments = array(); |
|
| 175 | foreach ($searchData['payment'] as $payment) { |
|
| 176 | $payments[] = $payment->getId(); |
|
| 177 | } |
|
| 178 | $qb |
|
| 179 | ->leftJoin('o.Payment', 'p') |
|
| 180 | ->andWhere($qb->expr()->in('p.id', ':payments')) |
|
| 181 | ->setParameter('payments', $payments); |
|
| 182 | } |
|
| 183 | ||
| 184 | // oreder_date |
|
| 185 | if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) { |
|
| @@ 334-343 (lines=10) @@ | ||
| 331 | } |
|
| 332 | ||
| 333 | // payment |
|
| 334 | if (!empty($searchData['payment']) && count($searchData['payment'])) { |
|
| 335 | $payments = array(); |
|
| 336 | foreach ($searchData['payment'] as $payment) { |
|
| 337 | $payments[] = $payment->getId(); |
|
| 338 | } |
|
| 339 | $qb |
|
| 340 | ->leftJoin('o.Payment', 'p') |
|
| 341 | ->andWhere($qb->expr()->in('p.id', ':payments')) |
|
| 342 | ->setParameter('payments', $payments); |
|
| 343 | } |
|
| 344 | ||
| 345 | // oreder_date |
|
| 346 | if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) { |
|
| @@ 105-114 (lines=10) @@ | ||
| 102 | } |
|
| 103 | ||
| 104 | // payment |
|
| 105 | if (!empty($searchData['payment']) && count($searchData['payment'])) { |
|
| 106 | $payments = array(); |
|
| 107 | foreach ($searchData['payment'] as $payment) { |
|
| 108 | $payments[] = $payment->getId(); |
|
| 109 | } |
|
| 110 | $qb |
|
| 111 | ->leftJoin('o.Payment', 'p') |
|
| 112 | ->andWhere($qb->expr()->in('p.id', ':payments')) |
|
| 113 | ->setParameter('payments', $payments); |
|
| 114 | } |
|
| 115 | ||
| 116 | // oreder_date |
|
| 117 | if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) { |
|
