Dev-Int /
glsr
| @@ 68-77 (lines=10) @@ | ||
| 65 | * |
|
| 66 | * @return \Doctrine\ORM\QueryBuilder |
|
| 67 | */ |
|
| 68 | public function findOrders() |
|
| 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 delivering. |
|
| @@ 84-93 (lines=10) @@ | ||
| 81 | * |
|
| 82 | * @return \Doctrine\ORM\QueryBuilder |
|
| 83 | */ |
|
| 84 | public function findDeliveries() |
|
| 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 | /** |
|
| 96 | * Find Orders for billing. |
|
| @@ 100-109 (lines=10) @@ | ||
| 97 | * |
|
| 98 | * @return \Doctrine\ORM\QueryBuilder |
|
| 99 | */ |
|
| 100 | public function findInvoices() |
|
| 101 | { |
|
| 102 | $query = $this->createQueryBuilder('o') |
|
| 103 | ->orderBy('o.id', 'DESC') |
|
| 104 | ->where('o.delivdate < :date') |
|
| 105 | ->andWhere('o.status > :status') |
|
| 106 | ->setParameters(new ArrayCollection([new Parameter('date', date('Y-m-d')), new Parameter('status', 1)])); |
|
| 107 | ||
| 108 | return $query; |
|
| 109 | } |
|
| 110 | } |
|
| 111 | ||
