/** * Test sql aware. * * @todo create reliable test data */ public function testSQLAware() { $resultList = new ZMResultList(); $resultSource = new ZMObjectResultSource('ZenMagick\\StoreBundle\\Entity\\Order\\Order', 'orderService', 'getAllOrders', array(1)); $resultList->setResultSource($resultSource); $sorter = new ZMOrderSorter(); $sorter->setSortId('date'); $sorter->setDescending(true); $queryDetails = $sorter->getQueryDetails(); $resultList->addSorter($sorter); $filter = new ZMOrderStatusIdFilter(); $resultList->addFilter($filter); $resultList->setPageNumber(3); $orders = $resultList->getResults(); echo 'is final source: ' . $resultSource->isFinal() . "<BR>"; echo "# of pages: " . $resultList->getNumberOfPages() . "<BR>"; $locale = $this->get('localeService'); foreach ($orders as $order) { echo $order->getId() . ' ' . $locale->longDate($order->getOrderDate()) . "<BR>"; } }