/** * @return string * @throws \Exception */ public function getCollectionRequest() { $this->collection = array('dimensions' => $this->dimensions, 'metrics' => $this->metrics, 'sorts' => $this->sorts, 'filters' => $this->filters); if ($this->startDate) { $this->collection['startDate'] = $this->startDate; } if ($this->finishDate) { $this->collection['finishDate'] = $this->finishDate; } return parent::getCollectionRequest(); }
/** * @return string * @throws \Exception */ public function getCollectionRequest() { $sql = "\n SELECT\n o.order_id\n FROM\n `order` as o\n WHERE\n (\n o.date_added > '0000-00-00 00:00:00'\n OR o.date_modified > '0000-00-00 00:00:00'\n )\n AND o.order_status_id != 0\n ORDER BY o.order_id ASC\n "; $this->collection = $sql; return parent::getCollectionRequest(); }
/** * @return string * @throws \Exception */ public function getCollectionRequest() { $sql = "\n SELECT\n c.customer_id\n FROM\n customer as c\n WHERE\n (\n c.date_added > '0000-00-00 00:00:00'\n OR c.date_modified > '0000-00-00 00:00:00'\n )\n AND c.status = 1\n ORDER BY c.customer_id ASC\n "; $this->collection = $sql; return parent::getCollectionRequest(); }
/** * @return string * @throws \Exception */ public function getCollectionRequest() { $sql = "\n SELECT\n p.product_id\n FROM\n product as p\n WHERE\n (\n p.date_added > '0000-00-00 00:00:00'\n OR p.date_modified > '0000-00-00 00:00:00'\n )\n AND p.date_available <= NOW()\n AND product_id = product_ring_id\n ORDER BY p.product_id ASC\n "; $this->collection = $sql; return parent::getCollectionRequest(); }