[Dolibarr-dev] correction webservice Dolibarr - Oscommerce

[Jean]

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());