/** * @param array $keys * @return string * @throws \Exception */ public function getItemPackageRequest(array $keys) { $sql = "\n SELECT\n o.order_id,\n o.customer_id,\n o.shipping_method,\n o.payment_method,\n o.currency,\n o.date_added\n FROM\n `order` as o\n WHERE\n o.order_id IN (" . join(', ', $keys) . ")\n ORDER BY o.order_id ASC\n "; $this->itemPackage = $sql; return parent::getItemPackageRequest($keys); }
/** * @param array $keys * @return string * @throws \Exception */ public function getItemPackageRequest(array $keys) { $sql = "\n SELECT\n p.product_id,\n p.sku,\n p.image,\n p.status,\n pd.name,\n m.name as manufacturer,\n p.date_added,\n p.date_available,\n IF (LENGTH(pd.short_description) > 0 OR LENGTH(pd.description) > 0,1,0) as is_description,\n (\n SELECT keyword\n FROM url_alias\n WHERE query = CONCAT('product_id=', p.product_id) LIMIT 0,1\n ) AS url,\n (\n SELECT c.category_id\n FROM product_to_category as ptc\n LEFT JOIN category as c\n ON ptc.category_id = c.category_id\n WHERE\n ptc.product_id = p.product_id\n AND c.status = 1\n ORDER BY c.sort_order ASC, c.category_id DESC\n LIMIT 0,1\n ) AS category_id,\n (\n SELECT cd.name\n FROM product_to_category as ptc\n LEFT JOIN category as c\n ON ptc.category_id = c.category_id\n LEFT JOIN category_description as cd\n ON ptc.category_id = cd.category_id\n WHERE\n ptc.product_id = p.product_id\n AND cd.language_id = " . $this->languageOuterId . "\n AND c.status = 1\n ORDER BY c.sort_order ASC, c.category_id DESC\n LIMIT 0,1\n ) AS category\n FROM\n product as p\n LEFT JOIN product_description as pd\n ON p.product_id = pd.product_id AND pd.language_id = " . $this->languageOuterId . "\n LEFT JOIN manufacturer as m\n ON p.manufacturer_id = m.manufacturer_id\n WHERE\n p.product_id IN (" . join(', ', $keys) . ")\n ORDER BY p.product_id ASC\n "; $this->itemPackage = $sql; return parent::getItemPackageRequest($keys); }
/** * @param array $keys * @return string * @throws \Exception */ public function getItemPackageRequest(array $keys) { $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 IN (" . join(', ', $keys) . ")\n ORDER BY c.customer_id ASC\n "; $this->itemPackage = $sql; return parent::getItemPackageRequest($keys); }
/** * @param array $keys * @return string * @throws \Exception */ public function getItemPackageRequest(array $keys) { $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 IN (" . join(', ', $keys) . ")\n ORDER BY op.order_product_id ASC\n "; $this->itemPackage = $sql; return parent::getItemPackageRequest($keys); }