fichier ws_server/ws_articles.php
Modification des requêtes pour prendre aussi en compte les articles en
vente sur le site OSC mais sans fournisseur défini.
--- /home/jean/projets/dolibarr_devref/dolibarr/htdocs/oscommerce_ws/ws_server/ws_articles.php 2007-04-16 09:37:37.000000000 -1000
+++ /home/jean/projets/dolibarr/htdocs/oscommerce_ws/ws_server/ws_articles.php 2007-04-17 14:22:46.407751936 -1000
@@ -47,9 +47,9 @@
//on recherche
$sql = "SELECT p.products_id, p.products_model, p.products_quantity, p.products_status, p.products_price, d.products_name, d.products_description, m.manufacturers_name, m.manufacturers_id";
- $sql .= " FROM products as p, products_description as d, manufacturers as m";
- $sql .= " WHERE p.products_id = d.products_id AND d.language_id =" . OSC_LANGUAGE_ID;
- $sql .= " AND p.manufacturers_id=m.manufacturers_id";
+ $sql .= " FROM products as p ";
+ $sql .= " JOIN products_description as d ON p.products_id = d.products_id "; $sql .= " LEFT JOIN manufacturers as m ON p.manufacturers_id=m.manufacturers_id";
+ $sql .= " WHERE d.language_id =" . OSC_LANGUAGE_ID;
if ($id) $sql.= " AND p.products_id = ".$id;
if ($ref) $sql.= " AND p.products_model = '".addslashes($ref)."'";
@@ -79,9 +79,9 @@
//on recherche
$sql = "SELECT p.products_id as OSC_id, p.products_model as model, p.products_quantity as quantity, p.products_status as status, d.products_name as name, m.manufacturers_name as manufacturer, m.manufacturers_id";
- $sql .= " FROM products as p, products_description as d, manufacturers as m";
- $sql .= " WHERE p.products_id = d.products_id AND d.language_id =" . OSC_LANGUAGE_ID;
- $sql .= " AND p.manufacturers_id=m.manufacturers_id";
+ $sql .= " FROM products as p";
+ $sql .= " JOIN products_description as d ON p.products_id = d.products_id "; $sql .= " LEFT JOIN manufacturers as m ON p.manufacturers_id=m.manufacturers_id";
+ $sql .= " WHERE d.language_id =" . OSC_LANGUAGE_ID;
if (!($resquer = mysql_query($sql,$connexion))) return new soap_fault("Server", "MySQL 3 ".$sql, mysql_error());
_______________________________________________
Dolibarr-dev mailing list
[email protected]
http://lists.nongnu.org/mailman/listinfo/dolibarr-dev
