authenticate(); break; case 'checkauth': checkauthentication(); break; case 'userinfo': getuserinformation(); break; case 'getprivilages': getprivilages(); break; case 'getquota': getquota(); break; case 'getitems': getitems($_POST['playlistid']); break; case 'uploaditemfile': uploaditemfile($_FILES['file'], $_POST['playlistid']); break; case 'createitementry': createitementry($_POST['name'], $_POST['title'], $_POST['description'], $_POST['type'], $_POST['playlistid']); break; case 'deleteitem': deleteitem($_POST['itemid']); break; case 'getplaylistitems': getplaylistitems(); break; case 'uploadplaylistfile': uploadplaylistfile($_POST['playlistid'], $_FILES['file']);
$val["price"] = round($val["price"] * 100) / 100; $val["barcode"] = $objp->barcode; $val["type"] = "pro"; echo "INSERT INTO products values (" . $val["id"] . ", " . $id . ", '" . $val["label"] . "', " . $val["price"] . ")@@"; //echo "<br>"; $i++; } } } $objCat = new Categorie($db); $cats = $objCat->get_full_arbo(0); $retarray = array(); foreach ($cats as $key => $val) { echo "INSERT INTO cats values (" . $val["rowid"] . ", " . $val["fk_parent"] . ", '" . $val["label"] . "')@@"; //echo "<br>"; getitems($val["rowid"]); } $resql = $db->query("SELECT DISTINCT p.rowid as id, p.price_ttc as price, p.label as label, p.barcode as barcode FROM " . MAIN_DB_PREFIX . "product as p LEFT JOIN llx_categorie_product as cp ON p.rowid = cp.fk_product LEFT JOIN llx_product_fournisseur_price as pfp ON p.rowid = pfp.fk_product WHERE p.entity IN ({$entity}) AND p.fk_product_type <> '1' AND cp.fk_categorie IS NULL GROUP BY p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.fk_product_type, p.tms, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock ORDER BY p.ref"); if ($resql) { $num = $db->num_rows($resql); $i = 0; while ($i < $num) { $objp = $db->fetch_object($resql); $val["id"] = $objp->id; $val["label"] = $objp->label; $val["price"] = $objp->price; $val["barcode"] = $objp->barcode; $val["type"] = "pro"; echo "INSERT INTO products values (" . $val["id"] . ", 0, '" . $val["label"] . "', " . $val["price"] . ")@@"; $i++; }