/** * Create a QueryBuilder instance for getFistOpenOrderDate() * * @return \Doctrine\ORM\QueryBuilder */ protected function defineGetFistOpenOrderDateQuery() { $qb = $this->createQueryBuilder()->select('MIN(o.date) as order_date'); $this->prepareCndPaymentStatus($qb, \XLite\Model\Order\Status\Payment::getOpenStatuses()); return $qb; }
/** * Get search condition * * @return \XLite\Core\CommonCell */ protected function getSearchCondition() { $cnd = new \XLite\Core\CommonCell(); $cnd->{\XLite\Model\Repo\Order::P_ORDER_BY} = array(array('o.date', 'o.order_id'), array('DESC', 'DESC')); $cnd->{\XLite\Model\Repo\Order::P_PAYMENT_STATUS} = \XLite\Model\Order\Status\Payment::getOpenStatuses(); return $cnd; }