$id_categ_parent = $creer['id_parent'];
if ($id_categ_parent == "1") {
$id_categ_parent = "0";
}
$visible = $creer['active'];
if ($visible == "0") {
$id_categ_parent = "1";
}
$donnees_creer_category_lang = Db::getInstance()->GetRow("select * from " . $prefix_presta . "category_lang where id_category='" . $id_categ . "' and id_lang='{$lang}'");
$label_creer_category = $donnees_creer_category_lang['name'];
$chaine = $label_creer_category;
$chaine = produits_caract("{$chaine}");
$label_creer_category = $chaine;
$description_creer_category = $donnees_creer_category_lang['description'];
$chaine = $description_creer_category;
$chaine = produits_caract("{$chaine}");
$description_creer_category = $chaine;
$link_rewrite_creer_category = $donnees_creer_category_lang['link_rewrite'];
mysql_connect("{$serveur_doli}", "{$admin_doli}", "{$mdp_doli}");
mysql_select_db("{$base_doli}");
mysql_query("SET NAMES UTF8");
// RECUPERATION DE LA VERSION DE DOLIBARR **************************************************
$sql_recup_version_dolibarr = "select * from " . $prefix_doli . "const where name='MAIN_VERSION_LAST_UPGRADE'";
$result_version_dolibarr = mysql_query($sql_recup_version_dolibarr) or die($sql_recup_version_dolibarr . "<br />\n" . mysql_error());
$donnees_version_dolibarr = mysql_fetch_array($result_version_dolibarr);
$version_dolibarr = $donnees_version_dolibarr['value'];
$version_dolibarr = substr($version_dolibarr, 0, 3);
if ($version_dolibarr == "") {
$sql_recup_version_dolibarr = "select * from " . $prefix_doli . "const where name='MAIN_VERSION_LAST_INSTALL'";
$result_version_dolibarr = mysql_query($sql_recup_version_dolibarr) or die($sql_recup_version_dolibarr . "<br />\n" . mysql_error());
$donnees_version_dolibarr = mysql_fetch_array($result_version_dolibarr);
function synchroProduct($id_product)
{
echo "<br/>Synchronize product : {$id_product}<br>";
$product_description = Configuration::get('product_description');
$use_barcode = Configuration::get('use_barcode');
if ($product = Db::getInstance()->GetRow("select * from " . _DB_PREFIX_ . "product where id_product = '" . $id_product . "'")) {
// retrieve params
$prefix_ref_product = Configuration::get('prefix_ref_product');
$prefix_ref_product = accents_sans("{$prefix_ref_product}");
//retrieve product data
$prix_produit_normal_HT = $product['price'];
$active = $product['active'];
$reference = $product['reference'];
$reference = produits_caract("{$reference}");
$en_vente = $product['active'];
$barcode = $product['ean13'];
//$datec=$product['date_add'];
//$tms=$product['date_upd'];
//$weight=$product['weight'];
// find tva rate
$id_tax_rules_group = $product['id_tax_rules_group'];
//var_dump($id_tax_rules_group);
$donnees_id_tax_rules_group = Db::getInstance()->GetRow("select * from " . _DB_PREFIX_ . "tax_rule where id_tax_rules_group = '" . $id_tax_rules_group . "'");
//var_dump($donnees_id_tax_rules_group);
$id_tax = $donnees_id_tax_rules_group['id_tax'];
//var_dump($id_tax);
$donnees_tax = Db::getInstance()->GetRow("select * from " . _DB_PREFIX_ . "tax where id_tax = '" . $id_tax . "'");
$vat_rate = $donnees_tax['rate'];
$prix_produit_normal_HT = sprintf("%.5f", $prix_produit_normal_HT);
//find description
$product_data = Db::getInstance()->GetRow("select * from " . _DB_PREFIX_ . "product_lang where id_product = '" . $id_product . "' AND id_lang = '" . Context::getContext()->language->id . "'");
if ($product_description == '0') {
$description = $product_data['description_short'];
} else {
$description = $product_data['description'];
}
$label = $product_data['name'];
// RECUPERATION DES DONNEES DU PRODUIT DANS LA BASE ARTICLES *********************************************
// RECUPERATION ID IMAGE ****************************************************
//$donnees_id_image = Db::getInstance()->GetRow("select * from ".$prefix_presta."image where id_product='".$product_id."'");
//$id_image=$donnees_id_image['id_image'];
// FIN RECUPERATION ID IMAGE ****************************************************
$dolibarr = Dolibarr::getInstance();
$product = new DolibarrProduct();
$product->ref_ext = $prefix_ref_product . $id_product;
$product->ref = $reference;
$product->label = $label;
$product->description = $description;
$product->price_net = $prix_produit_normal_HT;
$product->vat_rate = $vat_rate;
if ($use_barcode == '1') {
$product->barcode = $barcode;
$product->barcode_type = '2';
// 2 = ean13
}
// Check if already exists in Dolibarr
$exists = $dolibarr->getProduct($prefix_ref_product . $id_product);
if ($exists["result"]->result_code == 'NOT_FOUND') {
// Create new product
echo "Create new product : ";
$result = $dolibarr->createProduct($product);
echo $result["result"]->result_code . "<br/>";
if ($result["result"]->result_code != 'OK') {
echo "Erreur de synchronisation : " . $result["result"]->result_label;
echo "<br>product : ";
var_dump($product);
echo "<br>result : ";
var_dump($result);
return FALSE;
}
} else {
if ($exists["result"]->result_code == 'OK') {
// Update product
echo "update product : ";
$oldProduct = $exists["product"];
$product->id = $oldProduct->id;
$result = $dolibarr->updateProduct($product);
echo $result["result"]->result_code . "<br/>";
if ($result["result"]->result_code != 'OK') {
if (strpos($result["result"]->result_label, 'CONSTRAINT `fk_product_barcode_type') !== FALSE) {
echo "Synchronisation Error : Looks like you have enabled barcode in this module but not in your Dolibarr installation.";
} else {
echo "Erreur de synchronisation : " . $result["result"]->result_label;
echo "<br>product : ";
var_dump($product);
echo "<br>result : ";
var_dump($result);
return FALSE;
}
}
} else {
if (strpos($result["result"]->result_label, 'CONSTRAINT `fk_product_barcode_type') !== FALSE) {
echo "Synchronisation Error : Looks like you have enabled barcode in this module but not in your Dolibarr installation.";
} else {
echo "Erreur de synchronisation : " . $result["result"]->result_label;
echo "<br>product : ";
var_dump($product);
echo "<br>result : ";
var_dump($result);
return FALSE;
}
}
}
}
return TRUE;
}
