/**
* @param string $key
* @return string
* @throws \Exception
*/
public function getItemRequest($key = '')
{
$sql = "\n SELECT\n op.order_product_id,\n op.order_id,\n p.product_ring_id,\n op.quantity,\n op.total,\n op.date_added\n FROM\n order_product as op\n LEFT JOIN product as p\n \tON op.product_id = p.product_id\n WHERE\n op.order_product_id = " . $key . "\n LIMIT 0,1\n ";
$this->item = $sql;
return parent::getItemRequest($key);
}
/**
* @param string $key
* @return string
* @throws \Exception
*/
public function getItemRequest($key = '')
{
$sql = "\n SELECT\n c.customer_id,\n c.firstname as lastname,\n c.lastname as firstname,\n c.email,\n c.date_added,\n cg.name as customer_group,\n a.company,\n a.city,\n co.name as country\n FROM\n customer as c\n LEFT JOIN customer_group as cg\n ON c.customer_group_id = cg.customer_group_id\n LEFT JOIN address as a\n ON c.address_id = a.address_id\n LEFT JOIN country as co\n ON a.country_id = co.country_id\n WHERE\n c.customer_id = " . $key . "\n LIMIT 0,1\n ";
$this->item = $sql;
return parent::getItemRequest($key);
}
/**
* @param string $key
* @return string
* @throws \Exception
*/
public function getItemRequest($key = '')
{
$this->item = '';
return parent::getItemRequest($key);
}
