/**
* @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();
}
