Dev-Int /
glsr
| @@ 52-61 (lines=10) @@ | ||
| 49 | * |
|
| 50 | * @return \Doctrine\ORM\QueryBuilder |
|
| 51 | */ |
|
| 52 | public function findOrders() |
|
| 53 | { |
|
| 54 | $query = $this->createQueryBuilder('o') |
|
| 55 | ->orderBy('o.id', 'DESC') |
|
| 56 | ->where('o.delivdate > :date') |
|
| 57 | ->andWhere('o.status = :status') |
|
| 58 | ->setParameters(new ArrayCollection([new Parameter('date', date('Y-m-d')), new Parameter('status', 1)])); |
|
| 59 | ||
| 60 | return $query; |
|
| 61 | } |
|
| 62 | ||
| 63 | /** |
|
| 64 | * Find Orders for delivering. |
|
| @@ 68-77 (lines=10) @@ | ||
| 65 | * |
|
| 66 | * @return \Doctrine\ORM\QueryBuilder |
|
| 67 | */ |
|
| 68 | public function findDeliveries() |
|
| 69 | { |
|
| 70 | $query = $this->createQueryBuilder('o') |
|
| 71 | ->orderBy('o.id', 'DESC') |
|
| 72 | ->where('o.delivdate <= :date') |
|
| 73 | ->andWhere('o.status = :status') |
|
| 74 | ->setParameters(new ArrayCollection([new Parameter('date', date('Y-m-d')), new Parameter('status', 1)])); |
|
| 75 | ||
| 76 | return $query; |
|
| 77 | } |
|
| 78 | ||
| 79 | /** |
|
| 80 | * Find Orders for billing. |
|
| @@ 84-93 (lines=10) @@ | ||
| 81 | * |
|
| 82 | * @return \Doctrine\ORM\QueryBuilder |
|
| 83 | */ |
|
| 84 | public function findInvoices() |
|
| 85 | { |
|
| 86 | $query = $this->createQueryBuilder('o') |
|
| 87 | ->orderBy('o.id', 'DESC') |
|
| 88 | ->where('o.delivdate < :date') |
|
| 89 | ->andWhere('o.status > :status') |
|
| 90 | ->setParameters(new ArrayCollection([new Parameter('date', date('Y-m-d')), new Parameter('status', 1)])); |
|
| 91 | ||
| 92 | return $query; |
|
| 93 | } |
|
| 94 | } |
|
| 95 | ||
