/** * @param IOrderList $orderList * * @return IOrderListFilter */ public function apply(IOrderList $orderList) { // init $orderList->joinOrderItemObjects(); // quote $types = []; foreach ($this->getTypes() as $t) { $types[] = $orderList->getQuery()->getAdapter()->quote($t); } $orderList->getQuery()->where(sprintf('orderItemObjects.o_className in("%s")', implode('","', $types))); }
/** * @param IOrderList $orderList * * @return IOrderListFilter */ public function apply(IOrderList $orderList) { // init $query = $orderList->getQuery(); if ($this->getKeyword()) { $condition = <<<'SQL' 0 OR `order`.ordernumber like ? OR `order`.comment like ? OR `order`.customerName like ? OR `order`.customerCompany like ? OR `order`.customerStreet like ? OR `order`.customerZip like ? OR `order`.customerCity like ? OR `order`.customerCountry like ? OR `order`.deliveryName like ? OR `order`.deliveryCompany like ? OR `order`.deliveryStreet like ? OR `order`.deliveryZip like ? OR `order`.deliveryCity like ? OR `order`.deliveryCountry like ? SQL; $query->where($condition, '%' . $this->getKeyword() . '%'); } }
/** * @param IOrderList $orderList * * @return IOrderListFilter */ public function apply(IOrderList $orderList) { // init $query = $orderList->getQuery(); if ($this->getFrom()) { $query->where('order.orderDate >= ?', $this->getFrom()->getTimestamp()); } if ($this->getTill()) { $query->where('order.orderDate <= ?', $this->getTill()->getTimestamp()); } }