[Dolibarr-dev] interface dolibarr osc

[jean]

correction sur la partie serveur OSC :

gestion des catégories OSC

diff -Naur --exclude=CVS --exclude='.#*' --exclude='*~' --exclude=documents 
/home/jean/projets/dolidev/sources/dolibarr_devref/dolibarr/htdocs/oscommerce_ws/ws_server/ws_articles.php
 
/home/jean/projets/dolidev/sources/dolibarr/htdocs/oscommerce_ws/ws_server/ws_articles.php
--- 
/home/jean/projets/dolidev/sources/dolibarr_devref/dolibarr/htdocs/oscommerce_ws/ws_server/ws_articles.php
  2007-10-03 22:44:11.000000000 +0200
+++ 
/home/jean/projets/dolidev/sources/dolibarr/htdocs/oscommerce_ws/ws_server/ws_articles.php
  2007-10-06 08:14:25.000000000 +0200
@@ -16,7 +16,7 @@
  * along with this program; if not, write to the Free Software
  * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  *
- * $Source: 
/sources/dolibarr/dolibarr/htdocs/oscommerce_ws/ws_server/ws_articles.php,v $
+ * $Source: 
/cvsroot/dolibarr/dolibarr/htdocs/oscommerce_ws/ws_server/ws_articles.php,v $
  *
  */
 
@@ -52,7 +52,7 @@
 $s->register('get_article');
 $s->register('get_listearticles');
 $s->register('create_article');
-
+$s->register('get_categorylist');
 
 
 function create_article($prod)
@@ -171,6 +171,37 @@
        return $name.' enregistré';
 }
 
+// OSC categories list from $catid 
+
+function get_categorylist($catid)
+{
+//on se connecte
+       if (!($connexion = mysql_connect(DB_SERVER, DB_SERVER_USERNAME, 
DB_SERVER_PASSWORD)))   return new soap_fault("Server", "MySQL 1", "connexion 
impossible");
+       if (!($db = mysql_select_db(DB_DATABASE, $connexion)))  return new 
soap_fault("Server", "MySQL 2", mysql_error());
+
+       $sql = "select c.categories_id, cd.categories_name, c.parent_id ";
+       $sql .= " FROM categories c, categories_description cd ";
+       $sql .= " WHERE c.parent_id = '".$catid."' and c.categories_id = 
cd.categories_id and cd.language_id='" . OSC_LANGUAGE_ID ."' order by 
sort_order, cd.categories_name";
+
+       if (!($resquer = mysql_query($sql,$connexion)))  return new 
soap_fault("Server", "MySQL gey_categorylist ".$sql, mysql_error());
+
+               switch ($numrows = mysql_numrows($resquer)) {
+               case 0 : 
+                       return new soap_fault("Server", "MySQL 
gey_categorylist", "pas de categories");
+                       break;
+               default : 
+                       $i = 0;
+                       while ( $i < $numrows)  
+                       {
+                               $liste_cat[$i] =  mysql_fetch_array($resquer, 
MYSQL_ASSOC);
+                               $i++;
+                       }
+               }               
+       mysql_close($connexion);
+ /* Sends the results to the client */
+return $liste_cat;             
+}
+
 // Return the results.
 $s->service($HTTP_RAW_POST_DATA);
 
diff -Naur --exclude=CVS --exclude='.#*' --exclude='*~' --exclude=documents 
/home/jean/projets/dolidev/sources/dolibarr_devref/dolibarr/htdocs/oscommerce_ws/ws_server/ws_customers.php
 
/home/jean/projets/dolidev/sources/dolibarr/htdocs/oscommerce_ws/ws_server/ws_customers.php
--- 
/home/jean/projets/dolidev/sources/dolibarr_devref/dolibarr/htdocs/oscommerce_ws/ws_server/ws_customers.php
 2007-10-03 22:44:11.000000000 +0200
+++ 
/home/jean/projets/dolidev/sources/dolibarr/htdocs/oscommerce_ws/ws_server/ws_customers.php
 2007-10-03 22:45:23.000000000 +0200
@@ -16,7 +16,7 @@
  * along with this program; if not, write to the Free Software
  * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  *
- * $Source: 
/sources/dolibarr/dolibarr/htdocs/oscommerce_ws/ws_server/ws_customers.php,v $
+ * $Source: 
/cvsroot/dolibarr/dolibarr/htdocs/oscommerce_ws/ws_server/ws_customers.php,v $
  *
  */
 
diff -Naur --exclude=CVS --exclude='.#*' --exclude='*~' --exclude=documents 
/home/jean/projets/dolidev/sources/dolibarr_devref/dolibarr/htdocs/oscommerce_ws/ws_server/ws_orders.php
 
/home/jean/projets/dolidev/sources/dolibarr/htdocs/oscommerce_ws/ws_server/ws_orders.php
--- 
/home/jean/projets/dolidev/sources/dolibarr_devref/dolibarr/htdocs/oscommerce_ws/ws_server/ws_orders.php
    2007-10-03 22:44:11.000000000 +0200
+++ 
/home/jean/projets/dolidev/sources/dolibarr/htdocs/oscommerce_ws/ws_server/ws_orders.php
    2007-10-03 22:45:23.000000000 +0200
@@ -16,7 +16,7 @@
  * along with this program; if not, write to the Free Software
  * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  *
- * $Source: 
/sources/dolibarr/dolibarr/htdocs/oscommerce_ws/ws_server/ws_orders.php,v $
+ * $Source: 
/cvsroot/dolibarr/dolibarr/htdocs/oscommerce_ws/ws_server/ws_orders.php,v $
  *
  */
 set_magic_quotes_runtime(0);