/** * @inheritDoc */ protected function prepareData(TableConfiguration $config) { $idOrder = $this->getIdOrder(); $query = $this->omsQueryContainer->queryLogByIdOrder($idOrder, false); $result = $this->runQuery($query, $config); foreach ($result as $i => $row) { $row = $this->formatEmptyValues($row, SpyOmsTransitionLogTableMap::COL_EVENT); $row = $this->formatEmptyValues($row, SpyOmsTransitionLogTableMap::COL_CONDITION); $row = $this->formatEmptyValues($row, SpyOmsTransitionLogTableMap::COL_COMMAND); $result[$i] = $row; } return $result; }
/** * @return array */ protected function getStateBlacklist() { $blacklist = $this->config->getStateBlacklist(); $result = $this->queryContainer->querySalesOrderItemStatesByName($blacklist)->find(); $blacklist = []; foreach ($result as $row) { $blacklist[] = $row->getIdOmsOrderItemState(); } return $blacklist; }
/** * @param array $states * @param \Spryker\Zed\Oms\Business\Process\ProcessInterface $process * * @return \Orm\Zed\Sales\Persistence\SpySalesOrderItem[] */ protected function getOrderItemsByState(array $states, ProcessInterface $process) { return $this->queryContainer->querySalesOrderItemsByState($states, $process->getName())->find()->getData(); }
/** * @return void */ public function clearLocks() { $this->queryContainer->queryLockedItemsByExpirationDate(new \DateTime('now'))->delete(); }
/** * @param \Spryker\Zed\Oms\Business\Process\StateInterface[] $states * @param string $sku * @param bool $returnTest * * @return \Orm\Zed\Sales\Persistence\SpySalesOrderItem */ protected function countOrderItemsForSku(array $states, $sku, $returnTest = true) { return $this->queryContainer->countSalesOrderItemsForSku($states, $sku, $returnTest)->findOne(); }
/** * @param \Orm\Zed\Sales\Persistence\SpySalesOrder $order * * @return \Orm\Zed\Oms\Persistence\SpyOmsTransitionLog[] */ public function getLogForOrder(SpySalesOrder $order) { return $this->queryContainer->queryLogForOrder($order)->find(); }
/** * @return \Propel\Runtime\Collection\ObjectCollection */ protected function findItemsWithExpiredTimeouts() { $now = new DateTime('now'); return $this->queryContainer->querySalesOrderItemsWithExpiredTimeouts($now)->find(); }