while ($i < count($detalles)) {
//------------------Producto----------------//
$id_producto = 0;
$this->container['logger']->info("entro del while");
$label = $_POST['label'];
$sqlEF = "SELECT rowid as id FROM llx_product where label like '" . $detalles[$i]['label']."'";
$this->container['logger']->info("entro a la consulta");
$sqlresPro = $obj_con->db->query($sqlEF);
if ($sqlresPro->num_rows > 0) {
$this->container['logger']->info("entro al primer if");
$this->container['logger']->info($sqlresPro);
$resuEF = $sqlresPro->fetch_object();
$id_producto = $sqlresPro->rowid;
}
else {
$this->container['logger']->info("prueba else");
if ($resuEF->id == 0) { //no existe producto con el secuencial ingresado
$this->container['logger']->info("if no existe");
///---------Variables del Producto---------/////
$label = $detalles[$i]["label"];
$datec = $detalles[$i]["datec"];
$description = $detalles[$i]["description"];
$customcode = $detalles[$i]["customcode"];
$price = $detalles[$i]["price"]; // Valor o precio sin IVA
$price_ttc = $detalles[$i]["price_ttc"]; //Valor total con IVA
$mrk_up = $detalles[$i]["mrk_up"];
$ice_tx_c = $detalles[$i]["ice_tx_c"];
$localtax1_tx = $detalles[$i]["localtax1_tx"];
$localtax2_tx = $detalles[$i]["localtax2_tx"];
$tosell = $detalles[$i]["tosell"];
$tobuy = $detalles[$i]["tobuy"];
$toaf = $detalles[$i]["toaf"];
$toinv = $detalles[$i]["toinv"];
//$fk_barcode_type = $detalles[$i]["fk_barcode_type"];
$weight_units = $detalles[$i]["weight_units"]; //Unidades del peso
$pmp = $detalles[$i]["pmp"];
$finished = $detalles[$i]["finished"]; //tipo
$costo = $detalles[$i]["costo"];
$costoi = $detalles[$i]["costoi"];
$costomaximo = $detalles[$i]["costomaximo"];
//$fk_account = $body["fk_account"];
//$fk_account_ventas = $body["fk_account_ventas"];
$um_control = $detalles[$i]["um_control"]; //Unidades del peso
$porciento_decuento = $detalles[$i]["porciento_decuento"];
$total_descuento = $detalles[$i]["total_descuento"];
$irbpnr = $detalles[$i]["irbpnr"];
$irbpnr_c = $detalles[$i]["irbpnr_c"];
$prev_min = $detalles[$i]["prev_min"];
$produc = $detalles[$i]["produc"];
$price2 = $detalles[$i]["price2"];
$price_ttc2 = $detalles[$i]["price_ttc2"];
$mrk_up2 = $detalles[$i]["mrk_up2"];
$price_min = $detalles[$i]["price_min"];
$price_min_ttc = $detalles[$i]["price_min_ttc"];
$price_min2 = $detalles[$i]["price_min2"];
$price_min_ttc2 = $detalles[$i]["price_min_ttc2 "];
//------------Valores quemados en Base----------//
$virtual = 0;
$fk_parent = 0;
$recuperableonly = 0;
$seuil_stock_alerte = 0;
$weight = 1;
$hidden = 0;
$acceso = 0;
$min_alert = 0;
$max_alert = 0;
$variable = 0;
$bi_sync = 0;
$def_rir = -1;
$def_riva = -1;
$def_rir_v = -1;
$def_riva_v = -1;
$prev_dias = 0;
$serv_10 = 0;
$c_import = 0;
$c_local = 0;
//--------------INSERTO PRODUCTO-----------------//
$sql = "INSERT INTO llx_product (";
$this->container['logger']->info("entity");
$sql .= " entity";
$sql .= ", datec";
$sql .= ", virtual";
$sql .= ", fk_parent";
$sql .= ", label";
$sql .= ", description";
$sql .= ", customcode";
$sql .= ", price";
$sql .= ", price_ttc";
$sql .= ", mrk_up";
$sql .= ", tva_tx";
$sql .= ", ice_tx";
$sql .= ", ice_tx_c";
$sql .= ", recuperableonly";
$sql .= ", localtax1_tx";
$sql .= ", localtax2_tx";
$sql .= ", fk_user_author";
$sql .= ", tosell"; //Vender
$sql .= ", tobuy"; //compra
$sql .= ", toaf"; //Activo Fijo
$sql .= ", toinv"; //Inventario
//$sql .= ", fk_product_type";
$sql .= ", seuil_stock_alerte";
//$sql .= ", fk_barcode_type";
$sql .= ", weight";
$sql .= ", weight_units";
$sql .= ", pmp";
$sql .= ", finished";
$sql .= ", hidden";
$sql .= ", costo";
$sql .= ", costoi";
$sql .= ", costomaximo";
$sql .= ", fk_cat";
$sql .= ", fk_subcat";
$sql .= ", acceso";
//$sql .= ", fk_account";
//$sql .= ", fk_account_ventas";
$sql .= ", um_control";
$sql .= ", min_alert";
$sql .= ", max_alert";
$sql .= ", porciento_decuento";
$sql .= ", total_descuento";
$sql .= ", irbpnr";
$sql .= ", irbpnr_c";
$sql .= ", variable";
$sql .= ", bi_sync";
$sql .= ", def_rir";
$sql .= ", def_riva";
$sql .= ", def_rir_v";
$sql .= ", def_riva_v";
$sql .= ", prev_dias";
$sql .= ", prev_min";
$sql .= ", produc";
$sql .= ", price2";
$sql .= ", price_ttc2";
$sql .= ", mrk_up2";
$sql .= ", serv_10";
$sql .= ", c_import";
$sql .= ", c_local";
$sql .= ", price_min";
$sql .= ", price_min_ttc";
$sql .= ", price_min2";
$sql .= ", price_min_ttc2";
$sql .= ", estado";
$sql .= ")";
$sql .= " VALUES (";
$this->container['logger']->info($entity);
$sql .= "'" . $entity . "'";
$sql .= ", '" . $datec . "'";
$sql .= ", $virtual";
$sql .= ", $fk_parent";
$sql .= ", '" . $detalles[$i]["label"] . "'";
$this->container['logger']->info($label);
$sql .= ", '" . $description . "'";
$sql .= ", '" . $customcode . "'";
$sql .= ", '" . $price . "'";
$sql .= ", '" . $price_ttc . "'";
$sql .= ", '" . $mrk_up . "'";
$sql .= ", '" . $detalles[$i]["tva_tx"] . "'";
$sql .= ", '" . $detalles[$i]["ice_tx"] . "'";
$sql .= ", '" . $ice_tx_c . "'";
$sql .= ", $recuperableonly";
$sql .= ", '" . $localtax1_tx . "'";
$sql .= ", '" . $localtax2_tx . "'";
$sql .= ", '" . $detalles[$i]["fk_user_author"] . "'";
$sql .= ", '" . $tosell . "'";
$sql .= ", '" . $tobuy . "'";
$sql .= ", '" . $toaf . "'";
$sql .= ", '" . $toinv . "'";
//$sql .= ", '" . $detalles[$i]["fk_product_type"] . "'";
$sql .= ", $seuil_stock_alerte";
//$sql .= ", $fk_barcode_type";
$sql .= ", $weight";
$sql .= ", '" . $weight_units . "'";
$sql .= ", '" . $pmp . "'";
$sql .= ", '" . $finished . "'";
$sql .= ", $hidden";
$sql .= ", '" . $costo . "'";
$sql .= ", '" . $costoi . "'";
$sql .= ", '" . $costomaximo . "'";
$sql .= ", '" . $detalles[$i]["fk_cat"] . "'";
$sql .= ", '" . $detalles[$i]["fk_subcat"] . "'";
$sql .= ", $acceso";
//$sql .= ", '" . $fk_account. "'";
//$sql .= ", '" . $fk_account_ventas. "'";
$sql .= ", '" . $um_control . "'";
$sql .= ", $min_alert";
$sql .= ", $max_alert";
$sql .= ", '" . $porciento_decuento . "'";
$sql .= ", '" . $total_descuento . "'";
$sql .= ", '" . $irbpnr . "'";
$sql .= ", '" . $irbpnr_c . "'";
$sql .= ", $variable";
$sql .= ", $bi_sync";
$sql .= ", $def_rir";
$sql .= ", $def_riva";
$sql .= ", $def_rir_v";
$sql .= ", $def_riva_v";
$sql .= ", $prev_dias";
$sql .= ", '" . $prev_min . "'";
$sql .= ", '" . $produc . "'";
$sql .= ", '" . $price2 . "'";
$sql .= ", '" . $price_ttc2 . "'";
$sql .= ", '" . $mrk_up2 . "'";
$sql .= ", $serv_10";
$sql .= ", $c_import";
$sql .= ", $c_local";
$sql .= ", '" . $price_min . "'";
$sql .= ", '" . $price_min_ttc . "'";
$sql .= ", '" . $price_min2 . "'";
$sql .= ", '" . $price_min_ttc2. "'";
$sql .= ", 'A'";
$this->container['logger']->info("final del insert");
$sql .= ")";
$this->container['logger']->info($sql);
//$resql = $obj_con->db->query($sql);
$resul = $obj_con->db->query($sql);
if ($resul) {
} else {
}