Zeoslib Portal

Code: Select all

2014-02-13 12:30:14 cat: Execute, proto: mysql-5, msg: Native SetAutoCommit Falsecall
2014-02-13 12:30:14 cat: Execute, proto: mysql-5, msg: Statement 80 : SELECT product_id, geo_zone_id FROM fw_product_to_geozone WHERE product_id = 68 AND geo_zone_id = 14 
2014-02-13 12:30:15 cat: Execute, proto: mysql-5, msg: Statement 82 : INSERT INTO fw_product_to_geozone (product_id, geo_zone_id, date_added, date_modified, user_modified) VALUES (68, 14, '2014-02-13 12:30:15', '2014-02-13 12:30:15', 'dfuma_000')
2014-02-13 12:30:16 cat: Execute, proto: mysql-5, msg: Native Commit call
2014-02-13 12:30:16 cat: Execute, proto: mysql-5, msg: Native SetAutoCommit Truecall
2014-02-13 12:30:16 cat: Execute, proto: mysql-5, msg: Statement 84 : SELECT dz.delivery_zone_id AS delivery_zone_id, dz.geo_zone_id AS geo_zone_id, dz.status AS status, lc.name AS name FROM fw_delivery_zone dz LEFT JOIN fw_localized_country lc ON (dz.visual_country_id = lc.country_id AND lc.language_id = 2) ORDER BY lc.name
2014-02-13 12:30:16 cat: Execute, proto: mysql-5, msg: Statement 85 : SHOW TABLES FROM xc_7614s LIKE 'fw_delivery_zone'
2014-02-13 12:30:17 cat: Execute, proto: mysql-5, msg: Statement 86 : SHOW FULL COLUMNS FROM xc_7614s.fw_delivery_zone LIKE '%'
2014-02-13 12:30:17 cat: Execute, proto: mysql-5, msg: Statement 87 : SHOW TABLES FROM xc_7614s LIKE 'fw_localized_country'
2014-02-13 12:30:17 cat: Execute, proto: mysql-5, msg: Statement 88 : SHOW FULL COLUMNS FROM xc_7614s.fw_localized_country LIKE '%'

Code: Select all

SELECT
  pr.product_id AS product_id,
  pr.model AS model,
  pd.name AS name,
  pr.image AS image,
  pr.status AS status,
  pr.date_added AS date_added,
  pr.date_modified AS date_modified

FROM oc_product pr
LEFT JOIN oc_product_description pd ON pr.product_id = pd.product_id AND pd.language_id = :language_id
-- WHERE
--  pr.status = 1
ORDER BY
  pd.name

Code: Select all

SELECT *
FROM oc_product_option

Code: Select all

SELECT
  option_id,
  type,
  sort_order

FROM oc_option
ORDER BY
  sort_order

Code: Select all

SELECT *
FROM oc_option_description
WHERE language_id = :language_id

Code: Select all

SELECT *
FROM oc_option_value
ORDER BY sort_order

Code: Select all

SELECT *
FROM oc_option_value_description
WHERE language_id = :language_id

Code: Select all

SELECT
po.product_id AS product_id,
po.option_id AS option_id,
od.name AS name,
op.sort_order AS sort_order

FROM oc_product_option po
INNER JOIN oc_option_description od ON (po.option_id = od.option_id)
INNER JOIN oc_option op ON (po.option_id = op.option_id)
WHERE (po.product_id = :product_id) AND (od.language_id = :language_id)
ORDER BY op.sort_order

Code: Select all

SELECT
pov.product_id AS product_id,
pov.option_id AS option_id,
pov.option_value_id AS option_value_id,
ovd.name AS name,
ov.sort_order AS sort_order

FROM oc_product_option_value pov
INNER JOIN oc_option_value ov ON (ov.option_id = pov.option_id AND ov.option_value_id = pov.option_value_id)
INNER JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE (ov.option_id = :option_id) AND (ovd.language_id = :language_id) AND (pov.product_id = :product_id)
ORDER BY ov.sort_order

Code: Select all

SELECT
  dz.delivery_zone_id AS delivery_zone_id,
  dz.geo_zone_id AS geo_zone_id,
  dz.status AS status,
  lc.name AS name

FROM fw_delivery_zone dz
LEFT JOIN fw_localized_country lc ON (dz.visual_country_id = lc.country_id AND lc.language_id = :language_id)

ORDER BY lc.name

Code: Select all

SELECT
  pr.product_id AS product_id,
  ptg.geo_zone_id AS geo_zone_id,
  99 AS associated,
  pr.model AS model,
  pd.name AS name,
  pr.image AS image,
  pr.status AS status,
  ptg.date_added AS date_added,
  ptg.date_modified AS date_modified,
  ptg.user_modified AS user_modified

FROM oc_product pr
LEFT JOIN oc_product_description pd ON pr.product_id = pd.product_id AND pd.language_id = :language_id
LEFT JOIN fw_product_to_geozone ptg ON pr.product_id = ptg.product_id AND ptg.geo_zone_id = :geo_zone_id
-- WHERE
--  pr.status = 1
ORDER BY
  pd.name

Code: Select all

SELECT
po.product_option_id AS product_option_id,
po.product_id AS product_id,
po.option_id AS option_id,
od.name AS name,
op.sort_order AS sort_order

FROM oc_product_option po
INNER JOIN oc_option_description od ON (po.option_id = od.option_id)
INNER JOIN oc_option op ON (po.option_id = op.option_id)
WHERE (po.product_id = :product_id) AND (od.language_id = :language_id) AND
((po.option_id = :allowed_option_id_1) OR (po.option_id = :allowed_option_id_2))
ORDER BY op.sort_order

Code: Select all

SELECT
99 AS first_row,
pov.product_id AS product_id,
lpo.geo_zone_id AS geo_zone_id,
lpo.quantity AS quantity,
lpo.subtract AS subtract,
lpo.price AS price,
lpo.price_prefix AS price_prefix,
lpo.points AS points,
lpo.points_prefix AS points_prefix,
lpo.weight AS weight,
lpo.weight_prefix AS weight_prefix,
lpo.date_added AS date_added,
lpo.date_modified AS date_modified,
lpo.user_modified AS user_modified,
pov.product_option_value_id AS product_option_value_id,
pov.option_id AS option_id,
pov.option_value_id AS option_value_id,
ovd.name AS name,
ov.sort_order AS sort_order

FROM oc_product_option_value pov
INNER JOIN oc_option_value ov ON (ov.option_id = pov.option_id AND ov.option_value_id = pov.option_value_id)
INNER JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
LEFT JOIN fw_local_product_option_value lpo ON (lpo.option_id = pov.option_id AND lpo.option_value_id = pov.option_value_id) AND (lpo.product_id = :product_id) AND (lpo.geo_zone_id = :geo_zone_id)

WHERE
(pov.product_id = :product_id) AND
(ov.option_id = :option_id) AND
(ovd.language_id = :language_id)

ORDER BY ov.sort_order