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