alxarafe / alixar

Dolibarr/Code/Product/Classes/Product.php

Spacing +232 added lines, -232 removed lines

@@ -134,7 +134,7 @@ 
      */
     public $price;
 
-    public $price_formated;         // used by takepos/ajax/ajax.php
+    public $price_formated; // used by takepos/ajax/ajax.php
 
     /**
      * Selling price with tax
@@ -143,7 +143,7 @@ 
      */
     public $price_ttc;
 
-    public $price_ttc_formated;     // used by takepos/ajax/ajax.php
+    public $price_ttc_formated; // used by takepos/ajax/ajax.php
 
     /**
      * Minimum price net
@@ -396,20 +396,20 @@ 
 
     //! Metric of products
     public $weight;
-    public $weight_units;   // scale -3, 0, 3, 6
+    public $weight_units; // scale -3, 0, 3, 6
     public $length;
-    public $length_units;   // scale -3, 0, 3, 6
+    public $length_units; // scale -3, 0, 3, 6
     public $width;
-    public $width_units;    // scale -3, 0, 3, 6
+    public $width_units; // scale -3, 0, 3, 6
     public $height;
-    public $height_units;   // scale -3, 0, 3, 6
+    public $height_units; // scale -3, 0, 3, 6
     public $surface;
-    public $surface_units;  // scale -3, 0, 3, 6
+    public $surface_units; // scale -3, 0, 3, 6
     public $volume;
-    public $volume_units;   // scale -3, 0, 3, 6
+    public $volume_units; // scale -3, 0, 3, 6
 
     public $net_measure;
-    public $net_measure_units;  // scale -3, 0, 3, 6
+    public $net_measure_units; // scale -3, 0, 3, 6
 
     public $accountancy_code_sell;
     public $accountancy_code_sell_intra;
@@ -723,10 +723,10 @@ 
             $this->ref = dol_sanitizeFileName(dol_string_nospecial(trim($this->ref)));
         }
         $this->label = trim($this->label);
-        $this->price_ttc = (float)price2num($this->price_ttc);
-        $this->price = (float)price2num($this->price);
-        $this->price_min_ttc = (float)price2num($this->price_min_ttc);
-        $this->price_min = (float)price2num($this->price_min);
+        $this->price_ttc = (float) price2num($this->price_ttc);
+        $this->price = (float) price2num($this->price);
+        $this->price_min_ttc = (float) price2num($this->price_min_ttc);
+        $this->price_min = (float) price2num($this->price_min);
         $this->price_label = trim($this->price_label);
         if (empty($this->tva_tx)) {
             $this->tva_tx = 0;
@@ -895,20 +895,20 @@ 
                     $sql .= ", mandatory_period";
                     $sql .= ") VALUES (";
                     $sql .= "'" . $this->db->idate($this->date_creation) . "'";
-                    $sql .= ", " . (!empty($this->entity) ? (int)$this->entity : (int)$conf->entity);
+                    $sql .= ", " . (!empty($this->entity) ? (int) $this->entity : (int) $conf->entity);
                     $sql .= ", '" . $this->db->escape($this->ref) . "'";
                     $sql .= ", " . (!empty($this->ref_ext) ? "'" . $this->db->escape($this->ref_ext) . "'" : "null");
                     $sql .= ", " . price2num($price_min_ht);
                     $sql .= ", " . price2num($price_min_ttc);
                     $sql .= ", " . (!empty($this->label) ? "'" . $this->db->escape($this->label) . "'" : "null");
-                    $sql .= ", " . ((int)$user->id);
-                    $sql .= ", " . ((int)$this->type);
+                    $sql .= ", " . ((int) $user->id);
+                    $sql .= ", " . ((int) $this->type);
                     $sql .= ", " . price2num($price_ht, 'MT');
                     $sql .= ", " . price2num($price_ttc, 'MT');
                     $sql .= ", '" . $this->db->escape($this->price_base_type) . "'";
                     $sql .= ", " . (!empty($this->price_label) ? "'" . $this->db->escape($this->price_label) . "'" : "null");
-                    $sql .= ", " . ((int)$this->status);
-                    $sql .= ", " . ((int)$this->status_buy);
+                    $sql .= ", " . ((int) $this->status);
+                    $sql .= ", " . ((int) $this->status_buy);
                     if (!getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
                         $sql .= ", '" . $this->db->escape($this->accountancy_code_buy) . "'";
                         $sql .= ", '" . $this->db->escape($this->accountancy_code_buy_intra) . "'";
@@ -918,11 +918,11 @@ 
                         $sql .= ", '" . $this->db->escape($this->accountancy_code_sell_export) . "'";
                     }
                     $sql .= ", '" . $this->db->escape($this->canvas) . "'";
-                    $sql .= ", " . ((!isset($this->finished) || $this->finished < 0 || $this->finished == '') ? 'NULL' : (int)$this->finished);
-                    $sql .= ", " . ((empty($this->status_batch) || $this->status_batch < 0) ? '0' : ((int)$this->status_batch));
-                    $sql .= ", " . ((empty($this->sell_or_eat_by_mandatory) || $this->sell_or_eat_by_mandatory < 0) ? 0 : ((int)$this->sell_or_eat_by_mandatory));
+                    $sql .= ", " . ((!isset($this->finished) || $this->finished < 0 || $this->finished == '') ? 'NULL' : (int) $this->finished);
+                    $sql .= ", " . ((empty($this->status_batch) || $this->status_batch < 0) ? '0' : ((int) $this->status_batch));
+                    $sql .= ", " . ((empty($this->sell_or_eat_by_mandatory) || $this->sell_or_eat_by_mandatory < 0) ? 0 : ((int) $this->sell_or_eat_by_mandatory));
                     $sql .= ", '" . $this->db->escape($this->batch_mask) . "'";
-                    $sql .= ", " . ($this->fk_unit > 0 ? ((int)$this->fk_unit) : 'NULL');
+                    $sql .= ", " . ($this->fk_unit > 0 ? ((int) $this->fk_unit) : 'NULL');
                     $sql .= ", '" . $this->db->escape($this->mandatory_period) . "'";
                     $sql .= ")";
 
@@ -951,7 +951,7 @@ 
 
                             // update accountancy for this entity
                             if (!$error && getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
-                                $this->db->query("DELETE FROM " . $this->db->prefix() . "product_perentity WHERE fk_product = " . ((int)$this->id) . " AND entity = " . ((int)$conf->entity));
+                                $this->db->query("DELETE FROM " . $this->db->prefix() . "product_perentity WHERE fk_product = " . ((int) $this->id) . " AND entity = " . ((int) $conf->entity));
 
                                 $sql = "INSERT INTO " . $this->db->prefix() . "product_perentity (";
                                 $sql .= " fk_product";
@@ -1161,8 +1161,8 @@ 
         // Add new price
         $sql = "INSERT INTO " . $this->db->prefix() . "product_price(price_level,date_price, fk_product, fk_user_author, price_label, price, price_ttc, price_base_type,tosell, tva_tx, default_vat_code, recuperableonly,";
         $sql .= " localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, price_min,price_min_ttc,price_by_qty,entity,fk_price_expression) ";
-        $sql .= " VALUES(" . ($level ? ((int)$level) : 1) . ", '" . $this->db->idate($now) . "', " . ((int)$this->id) . ", " . ((int)$user->id) . ", " . (empty($this->price_label) ? "null" : "'" . $this->db->escape($this->price_label) . "'") . ", " . ((float)price2num($this->price)) . ", " . ((float)price2num($this->price_ttc)) . ",'" . $this->db->escape($this->price_base_type) . "'," . ((int)$this->status) . ", " . ((float)price2num($this->tva_tx)) . ", " . ($this->default_vat_code ? ("'" . $this->db->escape($this->default_vat_code) . "'") : "null") . ", " . ((int)$this->tva_npr) . ",";
-        $sql .= " " . price2num($this->localtax1_tx) . ", " . price2num($this->localtax2_tx) . ", '" . $this->db->escape($this->localtax1_type) . "', '" . $this->db->escape($this->localtax2_type) . "', " . price2num($this->price_min) . ", " . price2num($this->price_min_ttc) . ", " . price2num($this->price_by_qty) . ", " . ((int)$conf->entity) . "," . ($this->fk_price_expression > 0 ? ((int)$this->fk_price_expression) : 'null');
+        $sql .= " VALUES(" . ($level ? ((int) $level) : 1) . ", '" . $this->db->idate($now) . "', " . ((int) $this->id) . ", " . ((int) $user->id) . ", " . (empty($this->price_label) ? "null" : "'" . $this->db->escape($this->price_label) . "'") . ", " . ((float) price2num($this->price)) . ", " . ((float) price2num($this->price_ttc)) . ",'" . $this->db->escape($this->price_base_type) . "'," . ((int) $this->status) . ", " . ((float) price2num($this->tva_tx)) . ", " . ($this->default_vat_code ? ("'" . $this->db->escape($this->default_vat_code) . "'") : "null") . ", " . ((int) $this->tva_npr) . ",";
+        $sql .= " " . price2num($this->localtax1_tx) . ", " . price2num($this->localtax2_tx) . ", '" . $this->db->escape($this->localtax1_type) . "', '" . $this->db->escape($this->localtax2_type) . "', " . price2num($this->price_min) . ", " . price2num($this->price_min_ttc) . ", " . price2num($this->price_by_qty) . ", " . ((int) $conf->entity) . "," . ($this->fk_price_expression > 0 ? ((int) $this->fk_price_expression) : 'null');
         $sql .= ")";
 
         dol_syslog(get_only_class($this) . "::_log_price", LOG_DEBUG);
@@ -1233,11 +1233,11 @@ 
 
         // Automated compute surface and volume if not filled
         if (empty($this->surface) && !empty($this->length) && !empty($this->width) && $this->length_units == $this->width_units) {
-            $this->surface = (float)$this->length * (float)$this->width;
+            $this->surface = (float) $this->length * (float) $this->width;
             $this->surface_units = measuring_units_squared($this->length_units);
         }
         if (empty($this->volume) && !empty($this->surface) && !empty($this->height) && $this->length_units == $this->height_units) {
-            $this->volume = $this->surface * (float)$this->height;
+            $this->volume = $this->surface * (float) $this->height;
             $this->volume_units = measuring_units_cubed($this->height_units);
         }
 
@@ -1318,7 +1318,7 @@ 
                     foreach ($ObjW->detail_batch as $detail) {    // Each lines of detail in product_batch of the current $ObjW = product_stock
                         if ($detail->batch == $valueforundefinedlot || $detail->batch == 'Undefined') {
                             // We discard this line, we will create it later
-                            $sqlclean = "DELETE FROM " . $this->db->prefix() . "product_batch WHERE batch in('Undefined', '" . $this->db->escape($valueforundefinedlot) . "') AND fk_product_stock = " . ((int)$ObjW->id);
+                            $sqlclean = "DELETE FROM " . $this->db->prefix() . "product_batch WHERE batch in('Undefined', '" . $this->db->escape($valueforundefinedlot) . "') AND fk_product_stock = " . ((int) $ObjW->id);
                             $result = $this->db->query($sqlclean);
                             if (!$result) {
                                 dol_print_error($this->db);
@@ -1368,30 +1368,30 @@ 
             $sql .= " SET label = '" . $this->db->escape($this->label) . "'";
 
             if ($updatetype && ($this->isProduct() || $this->isService())) {
-                $sql .= ", fk_product_type = " . ((int)$this->type);
+                $sql .= ", fk_product_type = " . ((int) $this->type);
             }
 
             $sql .= ", ref = '" . $this->db->escape($this->ref) . "'";
             $sql .= ", ref_ext = " . (!empty($this->ref_ext) ? "'" . $this->db->escape($this->ref_ext) . "'" : "null");
             $sql .= ", default_vat_code = " . ($this->default_vat_code ? "'" . $this->db->escape($this->default_vat_code) . "'" : "null");
-            $sql .= ", tva_tx = " . ((float)$this->tva_tx);
-            $sql .= ", recuperableonly = " . ((int)$this->tva_npr);
-            $sql .= ", localtax1_tx = " . ((float)$this->localtax1_tx);
-            $sql .= ", localtax2_tx = " . ((float)$this->localtax2_tx);
+            $sql .= ", tva_tx = " . ((float) $this->tva_tx);
+            $sql .= ", recuperableonly = " . ((int) $this->tva_npr);
+            $sql .= ", localtax1_tx = " . ((float) $this->localtax1_tx);
+            $sql .= ", localtax2_tx = " . ((float) $this->localtax2_tx);
             $sql .= ", localtax1_type = " . ($this->localtax1_type != '' ? "'" . $this->db->escape($this->localtax1_type) . "'" : "'0'");
             $sql .= ", localtax2_type = " . ($this->localtax2_type != '' ? "'" . $this->db->escape($this->localtax2_type) . "'" : "'0'");
 
             $sql .= ", barcode = " . (empty($this->barcode) ? "null" : "'" . $this->db->escape($this->barcode) . "'");
             $sql .= ", fk_barcode_type = " . (empty($this->barcode_type) ? "null" : $this->db->escape($this->barcode_type));
 
-            $sql .= ", tosell = " . (int)$this->status;
-            $sql .= ", tobuy = " . (int)$this->status_buy;
-            $sql .= ", tobatch = " . ((empty($this->status_batch) || $this->status_batch < 0) ? '0' : (int)$this->status_batch);
-            $sql .= ", sell_or_eat_by_mandatory = " . ((empty($this->sell_or_eat_by_mandatory) || $this->sell_or_eat_by_mandatory < 0) ? 0 : (int)$this->sell_or_eat_by_mandatory);
+            $sql .= ", tosell = " . (int) $this->status;
+            $sql .= ", tobuy = " . (int) $this->status_buy;
+            $sql .= ", tobatch = " . ((empty($this->status_batch) || $this->status_batch < 0) ? '0' : (int) $this->status_batch);
+            $sql .= ", sell_or_eat_by_mandatory = " . ((empty($this->sell_or_eat_by_mandatory) || $this->sell_or_eat_by_mandatory < 0) ? 0 : (int) $this->sell_or_eat_by_mandatory);
             $sql .= ", batch_mask = '" . $this->db->escape($this->batch_mask) . "'";
 
-            $sql .= ", finished = " . ((!isset($this->finished) || $this->finished < 0 || $this->finished == '') ? "null" : (int)$this->finished);
-            $sql .= ", fk_default_bom = " . ((!isset($this->fk_default_bom) || $this->fk_default_bom < 0 || $this->fk_default_bom == '') ? "null" : (int)$this->fk_default_bom);
+            $sql .= ", finished = " . ((!isset($this->finished) || $this->finished < 0 || $this->finished == '') ? "null" : (int) $this->finished);
+            $sql .= ", fk_default_bom = " . ((!isset($this->fk_default_bom) || $this->fk_default_bom < 0 || $this->fk_default_bom == '') ? "null" : (int) $this->fk_default_bom);
             $sql .= ", net_measure = " . ($this->net_measure != '' ? "'" . $this->db->escape($this->net_measure) . "'" : 'null');
             $sql .= ", net_measure_units = " . ($this->net_measure_units != '' ? "'" . $this->db->escape($this->net_measure_units) . "'" : 'null');
             $sql .= ", weight = " . ($this->weight != '' ? "'" . $this->db->escape($this->weight) . "'" : 'null');
@@ -1406,16 +1406,16 @@ 
             $sql .= ", surface_units = " . ($this->surface_units != '' ? "'" . $this->db->escape($this->surface_units) . "'" : 'null');
             $sql .= ", volume = " . ($this->volume != '' ? "'" . $this->db->escape($this->volume) . "'" : 'null');
             $sql .= ", volume_units = " . ($this->volume_units != '' ? "'" . $this->db->escape($this->volume_units) . "'" : 'null');
-            $sql .= ", fk_default_warehouse = " . ($this->fk_default_warehouse > 0 ? ((int)$this->fk_default_warehouse) : 'null');
-            $sql .= ", fk_default_workstation = " . ($this->fk_default_workstation > 0 ? ((int)$this->fk_default_workstation) : 'null');
-            $sql .= ", seuil_stock_alerte = " . ((isset($this->seuil_stock_alerte) && is_numeric($this->seuil_stock_alerte)) ? (float)$this->seuil_stock_alerte : 'null');
+            $sql .= ", fk_default_warehouse = " . ($this->fk_default_warehouse > 0 ? ((int) $this->fk_default_warehouse) : 'null');
+            $sql .= ", fk_default_workstation = " . ($this->fk_default_workstation > 0 ? ((int) $this->fk_default_workstation) : 'null');
+            $sql .= ", seuil_stock_alerte = " . ((isset($this->seuil_stock_alerte) && is_numeric($this->seuil_stock_alerte)) ? (float) $this->seuil_stock_alerte : 'null');
             $sql .= ", description = '" . $this->db->escape($this->description) . "'";
             $sql .= ", url = " . ($this->url ? "'" . $this->db->escape($this->url) . "'" : 'null');
             $sql .= ", customcode = '" . $this->db->escape($this->customcode) . "'";
-            $sql .= ", fk_country = " . ($this->country_id > 0 ? (int)$this->country_id : 'null');
-            $sql .= ", fk_state = " . ($this->state_id > 0 ? (int)$this->state_id : 'null');
-            $sql .= ", lifetime = " . ($this->lifetime > 0 ? (int)$this->lifetime : 'null');
-            $sql .= ", qc_frequency = " . ($this->qc_frequency > 0 ? (int)$this->qc_frequency : 'null');
+            $sql .= ", fk_country = " . ($this->country_id > 0 ? (int) $this->country_id : 'null');
+            $sql .= ", fk_state = " . ($this->state_id > 0 ? (int) $this->state_id : 'null');
+            $sql .= ", lifetime = " . ($this->lifetime > 0 ? (int) $this->lifetime : 'null');
+            $sql .= ", qc_frequency = " . ($this->qc_frequency > 0 ? (int) $this->qc_frequency : 'null');
             $sql .= ", note = " . (isset($this->note_private) ? "'" . $this->db->escape($this->note_private) . "'" : 'null');
             $sql .= ", note_public = " . (isset($this->note_public) ? "'" . $this->db->escape($this->note_public) . "'" : 'null');
             $sql .= ", duration = '" . $this->db->escape($this->duration_value . $this->duration_unit) . "'";
@@ -1427,15 +1427,15 @@ 
                 $sql .= ", accountancy_code_sell_intra= '" . $this->db->escape($this->accountancy_code_sell_intra) . "'";
                 $sql .= ", accountancy_code_sell_export= '" . $this->db->escape($this->accountancy_code_sell_export) . "'";
             }
-            $sql .= ", desiredstock = " . ((isset($this->desiredstock) && is_numeric($this->desiredstock)) ? (float)$this->desiredstock : "null");
+            $sql .= ", desiredstock = " . ((isset($this->desiredstock) && is_numeric($this->desiredstock)) ? (float) $this->desiredstock : "null");
             $sql .= ", cost_price = " . ($this->cost_price != '' ? $this->db->escape($this->cost_price) : 'null');
-            $sql .= ", fk_unit= " . (!$this->fk_unit ? 'NULL' : (int)$this->fk_unit);
+            $sql .= ", fk_unit= " . (!$this->fk_unit ? 'NULL' : (int) $this->fk_unit);
             $sql .= ", price_autogen = " . (!$this->price_autogen ? 0 : 1);
-            $sql .= ", fk_price_expression = " . ($this->fk_price_expression != 0 ? (int)$this->fk_price_expression : 'NULL');
+            $sql .= ", fk_price_expression = " . ($this->fk_price_expression != 0 ? (int) $this->fk_price_expression : 'NULL');
             $sql .= ", fk_user_modif = " . ($user->id > 0 ? $user->id : 'NULL');
             $sql .= ", mandatory_period = " . ($this->mandatory_period);
             // stock field is not here because it is a denormalized value from product_stock.
-            $sql .= " WHERE rowid = " . ((int)$id);
+            $sql .= " WHERE rowid = " . ((int) $id);
 
             dol_syslog(get_only_class($this) . "::update", LOG_DEBUG);
 
@@ -1456,7 +1456,7 @@ 
 
                 // update accountancy for this entity
                 if (!$error && getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
-                    $this->db->query("DELETE FROM " . $this->db->prefix() . "product_perentity WHERE fk_product = " . ((int)$this->id) . " AND entity = " . ((int)$conf->entity));
+                    $this->db->query("DELETE FROM " . $this->db->prefix() . "product_perentity WHERE fk_product = " . ((int) $this->id) . " AND entity = " . ((int) $conf->entity));
 
                     $sql = "INSERT INTO " . $this->db->prefix() . "product_perentity (";
                     $sql .= " fk_product";
@@ -1488,7 +1488,7 @@ 
                     // Selection of all product stock movements that contains batchs
                     $sql = 'SELECT pb.qty, ps.fk_entrepot, pb.batch FROM ' . MAIN_DB_PREFIX . 'product_batch as pb';
                     $sql .= ' INNER JOIN ' . MAIN_DB_PREFIX . 'product_stock as ps ON (ps.rowid = pb.fk_product_stock)';
-                    $sql .= ' WHERE ps.fk_product = ' . (int)$this->id;
+                    $sql .= ' WHERE ps.fk_product = ' . (int) $this->id;
 
                     $resql = $this->db->query($sql);
                     if ($resql) {
@@ -1509,7 +1509,7 @@ 
 
                             if ($res > 0) {
                                 $label = $langs->trans('BatchStockMouvementAddInGlobal');
-                                $res = $this->correct_stock($user, $fk_entrepot, abs($value), (int)empty($addOremove), $label, $price, $inventorycode, '', null, 0);
+                                $res = $this->correct_stock($user, $fk_entrepot, abs($value), (int) empty($addOremove), $label, $price, $inventorycode, '', null, 0);
                                 if ($res < 0) {
                                     $error++;
                                 }
@@ -1648,7 +1648,7 @@ 
         $sql .= ", " . $this->db->prefix() . "entrepot as w";
         $sql .= " WHERE w.entity IN (" . getEntity('stock') . ")";
         $sql .= " AND w.rowid = ps.fk_entrepot";
-        $sql .= " AND ps.fk_product = " . ((int)$this->id);
+        $sql .= " AND ps.fk_product = " . ((int) $this->id);
         if (count($warehouseStatus)) {
             $sql .= " AND w.statut IN (" . $this->db->sanitize(implode(',', $warehouseStatus)) . ")";
         }
@@ -1846,12 +1846,12 @@ 
         $sql .= " WHERE c.rowid = cd.fk_commande";
         $sql .= " AND c.fk_soc = s.rowid";
         $sql .= " AND c.entity IN (" . getEntity($forVirtualStock && getDolGlobalString('STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE') ? 'stock' : 'commande') . ")";
-        $sql .= " AND cd.fk_product = " . ((int)$this->id);
+        $sql .= " AND cd.fk_product = " . ((int) $this->id);
         if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
-            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
-            $sql .= " AND c.fk_soc = " . ((int)$socid);
+            $sql .= " AND c.fk_soc = " . ((int) $socid);
         }
         if ($filtrestatut != '') {
             $sql .= " AND c.fk_statut in (" . $this->db->sanitize($filtrestatut) . ")";
@@ -1896,7 +1896,7 @@ 
                     $sql .= " JOIN " . $this->db->prefix() . "facture as f ON fd.fk_facture = f.rowid";
                     $sql .= " JOIN " . $this->db->prefix() . "element_element as el ON ((el.fk_target = f.rowid AND el.targettype = 'facture' AND sourcetype = 'commande') OR (el.fk_source = f.rowid AND el.targettype = 'commande' AND sourcetype = 'facture'))";
                     $sql .= " JOIN " . $this->db->prefix() . "commande as c ON el.fk_source = c.rowid";
-                    $sql .= " WHERE c.fk_statut IN (" . $this->db->sanitize($filtrestatut) . ") AND c.facture = 0 AND fd.fk_product = " . ((int)$this->id);
+                    $sql .= " WHERE c.fk_statut IN (" . $this->db->sanitize($filtrestatut) . ") AND c.facture = 0 AND fd.fk_product = " . ((int) $this->id);
 
                     dol_syslog(__METHOD__ . ":: sql $sql", LOG_NOTICE);
                     $resql = $this->db->query($sql);
@@ -1917,7 +1917,7 @@ 
                     $sql .= " JOIN " . MAIN_DB_PREFIX . "facture as f ON fd.fk_facture = f.rowid";
                     $sql .= " JOIN " . MAIN_DB_PREFIX . "element_element as el ON ((el.fk_target = f.rowid AND el.targettype = 'facture' AND sourcetype = 'commande') OR (el.fk_source = f.rowid AND el.targettype = 'commande' AND sourcetype = 'facture'))";
                     $sql .= " JOIN " . MAIN_DB_PREFIX . "commande as c ON el.fk_source = c.rowid";
-                    $sql .= " WHERE c.fk_statut IN (" . $this->db->sanitize($filtrestatut) . ") AND f.fk_statut > " . Facture::STATUS_DRAFT . " AND fd.fk_product = " . ((int)$this->id);
+                    $sql .= " WHERE c.fk_statut IN (" . $this->db->sanitize($filtrestatut) . ") AND f.fk_statut > " . Facture::STATUS_DRAFT . " AND fd.fk_product = " . ((int) $this->id);
 
                     dol_syslog(__METHOD__ . ":: sql $sql", LOG_NOTICE);
                     $resql = $this->db->query($sql);
@@ -1960,7 +1960,7 @@ 
         $sql .= " FROM " . $this->db->prefix() . "product_association as pa,";
         $sql .= " " . $this->db->prefix() . "product as p";
         $sql .= " WHERE p.rowid = pa.fk_product_pere";
-        $sql .= " AND pa.fk_product_fils = " . ((int)$this->id);
+        $sql .= " AND pa.fk_product_fils = " . ((int) $this->id);
 
         $res = $this->db->query($sql);
         if ($res) {
@@ -2016,12 +2016,12 @@ 
         $sql .= " AND e.fk_soc = s.rowid";
         $sql .= " AND e.entity IN (" . getEntity($forVirtualStock && getDolGlobalString('STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE') ? 'stock' : 'expedition') . ")";
         $sql .= " AND ed.fk_elementdet = cd.rowid";
-        $sql .= " AND cd.fk_product = " . ((int)$this->id);
+        $sql .= " AND cd.fk_product = " . ((int) $this->id);
         if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
-            $sql .= " AND e.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND e.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
-            $sql .= " AND e.fk_soc = " . ((int)$socid);
+            $sql .= " AND e.fk_soc = " . ((int) $socid);
         }
         if ($filtrestatut != '') {
             $sql .= " AND c.fk_statut IN (" . $this->db->sanitize($filtrestatut) . ")";
@@ -2100,12 +2100,12 @@ 
         $sql .= " WHERE c.rowid = cd.fk_commande";
         $sql .= " AND c.fk_soc = s.rowid";
         $sql .= " AND c.entity IN (" . getEntity($forVirtualStock && getDolGlobalString('STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE') ? 'stock' : 'supplier_order') . ")";
-        $sql .= " AND cd.fk_product = " . ((int)$this->id);
+        $sql .= " AND cd.fk_product = " . ((int) $this->id);
         if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
-            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
-            $sql .= " AND c.fk_soc = " . ((int)$socid);
+            $sql .= " AND c.fk_soc = " . ((int) $socid);
         }
         if ($filtrestatut != '') {
             $sql .= " AND c.fk_statut in (" . $this->db->sanitize($filtrestatut) . ")"; // Peut valoir 0
@@ -2160,12 +2160,12 @@ 
         $sql .= " WHERE cf.rowid = fd.fk_element";
         $sql .= " AND cf.fk_soc = s.rowid";
         $sql .= " AND cf.entity IN (" . getEntity($forVirtualStock && getDolGlobalString('STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE') ? 'stock' : 'supplier_order') . ")";
-        $sql .= " AND fd.fk_product = " . ((int)$this->id);
+        $sql .= " AND fd.fk_product = " . ((int) $this->id);
         if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
-            $sql .= " AND cf.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND cf.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
-            $sql .= " AND cf.fk_soc = " . ((int)$socid);
+            $sql .= " AND cf.fk_soc = " . ((int) $socid);
         }
         if ($filtrestatut != '') {
             $sql .= " AND cf.fk_statut IN (" . $this->db->sanitize($filtrestatut) . ")";
@@ -2224,13 +2224,13 @@ 
         }
         $sql .= " WHERE m.rowid = mp.fk_mo";
         $sql .= " AND m.entity IN (" . getEntity(($forVirtualStock && getDolGlobalString('STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE')) ? 'stock' : 'mrp') . ")";
-        $sql .= " AND mp.fk_product = " . ((int)$this->id);
+        $sql .= " AND mp.fk_product = " . ((int) $this->id);
         $sql .= " AND (mp.disable_stock_change IN (0) OR mp.disable_stock_change IS NULL)";
         if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
-            $sql .= " AND m.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND m.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
-            $sql .= " AND m.fk_soc = " . ((int)$socid);
+            $sql .= " AND m.fk_soc = " . ((int) $socid);
         }
         if ($filtrestatut != '') {
             $sql .= " AND m.status IN (" . $this->db->sanitize($filtrestatut) . ")";
@@ -2239,10 +2239,10 @@ 
             $sql .= " AND m.date_valid <= '" . $this->db->idate($dateofvirtualstock) . "'"; // better date to code ? end of production ?
         }
         if (!$serviceStockIsEnabled) {
-            $sql .= "AND EXISTS (SELECT p.rowid FROM " . $this->db->prefix() . "product AS p WHERE p.rowid = " . ((int)$this->id) . " AND p.fk_product_type IN (0))";
+            $sql .= "AND EXISTS (SELECT p.rowid FROM " . $this->db->prefix() . "product AS p WHERE p.rowid = " . ((int) $this->id) . " AND p.fk_product_type IN (0))";
         }
         if (!empty($warehouseid)) {
-            $sql .= " AND m.fk_warehouse = " . ((int)$warehouseid);
+            $sql .= " AND m.fk_warehouse = " . ((int) $warehouseid);
         }
         $sql .= " GROUP BY role";
 
@@ -2363,12 +2363,12 @@ 
 
         //For MultiCompany
         //PMP per entity & Stocks Sharings stock_reel includes only stocks shared with this entity
-        $separatedEntityPMP = false;    // Set to true to get the AWP from table llx_product_perentity instead of field 'pmp' into llx_product.
-        $separatedStock = false;        // Set to true will count stock from subtable llx_product_stock. It is slower than using denormalized field 'stock', but it is required when using multientity and shared warehouses.
+        $separatedEntityPMP = false; // Set to true to get the AWP from table llx_product_perentity instead of field 'pmp' into llx_product.
+        $separatedStock = false; // Set to true will count stock from subtable llx_product_stock. It is slower than using denormalized field 'stock', but it is required when using multientity and shared warehouses.
         $visibleWarehousesEntities = $conf->entity;
         if (getDolGlobalString('MULTICOMPANY_PRODUCT_SHARING_ENABLED')) {
             if (getDolGlobalString('MULTICOMPANY_PMP_PER_ENTITY_ENABLED')) {
-                $checkPMPPerEntity = $this->db->query("SELECT pmp FROM " . $this->db->prefix() . "product_perentity WHERE fk_product = " . ((int)$id) . " AND entity = " . (int)$conf->entity);
+                $checkPMPPerEntity = $this->db->query("SELECT pmp FROM " . $this->db->prefix() . "product_perentity WHERE fk_product = " . ((int) $id) . " AND entity = " . (int) $conf->entity);
                 if ($this->db->num_rows($checkPMPPerEntity) > 0) {
                     $separatedEntityPMP = true;
                 }
@@ -2394,14 +2394,14 @@ 
         }
         $sql .= " FROM " . $this->db->prefix() . "product as p";
         if (getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED') || $separatedEntityPMP) {
-            $sql .= " LEFT JOIN " . $this->db->prefix() . "product_perentity as ppe ON ppe.fk_product = p.rowid AND ppe.entity = " . ((int)$conf->entity);
+            $sql .= " LEFT JOIN " . $this->db->prefix() . "product_perentity as ppe ON ppe.fk_product = p.rowid AND ppe.entity = " . ((int) $conf->entity);
         }
         if ($separatedStock) {
             $sql .= " LEFT JOIN " . $this->db->prefix() . "product_stock as sp ON sp.fk_product = p.rowid AND sp.fk_entrepot IN (SELECT rowid FROM " . $this->db->prefix() . "entrepot WHERE entity IN (" . $this->db->sanitize($visibleWarehousesEntities) . "))";
         }
 
         if ($id) {
-            $sql .= " WHERE p.rowid = " . ((int)$id);
+            $sql .= " WHERE p.rowid = " . ((int) $id);
         } else {
             $sql .= " WHERE p.entity IN (" . getEntity($this->element) . ")";
             if ($ref) {
@@ -2555,10 +2555,10 @@ 
                         $sql .= " ,price_label";
                         $sql .= " FROM " . $this->db->prefix() . "product_price";
                         $sql .= " WHERE entity IN (" . getEntity('productprice') . ")";
-                        $sql .= " AND price_level=" . ((int)$i);
-                        $sql .= " AND fk_product = " . ((int)$this->id);
-                        $sql .= " ORDER BY date_price DESC, rowid DESC";    // Get the most recent line
-                        $sql .= " LIMIT 1";                                 // Only the first one
+                        $sql .= " AND price_level=" . ((int) $i);
+                        $sql .= " AND fk_product = " . ((int) $this->id);
+                        $sql .= " ORDER BY date_price DESC, rowid DESC"; // Get the most recent line
+                        $sql .= " LIMIT 1"; // Only the first one
                         $resql = $this->db->query($sql);
                         if ($resql) {
                             $result = $this->db->fetch_array($resql);
@@ -2619,7 +2619,7 @@ 
                     $sql = "SELECT price, price_ttc, price_min, price_min_ttc,";
                     $sql .= " price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid";
                     $sql .= " FROM " . $this->db->prefix() . "product_price";
-                    $sql .= " WHERE fk_product = " . ((int)$this->id);
+                    $sql .= " WHERE fk_product = " . ((int) $this->id);
                     $sql .= " ORDER BY date_price DESC, rowid DESC";
                     $sql .= " LIMIT 1";
 
@@ -2635,7 +2635,7 @@ 
                             if ($this->prices_by_qty[0] == 1) {
                                 $sql = "SELECT rowid,price, unitprice, quantity, remise_percent, remise, remise, price_base_type";
                                 $sql .= " FROM " . $this->db->prefix() . "product_price_by_qty";
-                                $sql .= " WHERE fk_product_price = " . ((int)$this->prices_by_qty_id[0]);
+                                $sql .= " WHERE fk_product_price = " . ((int) $this->prices_by_qty_id[0]);
                                 $sql .= " ORDER BY quantity ASC";
 
                                 $resql = $this->db->query($sql);
@@ -2671,8 +2671,8 @@ 
                         $sql .= " price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly";
                         $sql .= " FROM " . $this->db->prefix() . "product_price";
                         $sql .= " WHERE entity IN (" . getEntity('productprice') . ")";
-                        $sql .= " AND price_level=" . ((int)$i);
-                        $sql .= " AND fk_product = " . ((int)$this->id);
+                        $sql .= " AND price_level=" . ((int) $i);
+                        $sql .= " AND fk_product = " . ((int) $this->id);
                         $sql .= " ORDER BY date_price DESC, rowid DESC";
                         $sql .= " LIMIT 1";
                         $resql = $this->db->query($sql);
@@ -2696,7 +2696,7 @@ 
                             if ($this->prices_by_qty[$i] == 1) {
                                 $sql = "SELECT rowid, price, unitprice, quantity, remise_percent, remise, price_base_type";
                                 $sql .= " FROM " . $this->db->prefix() . "product_price_by_qty";
-                                $sql .= " WHERE fk_product_price = " . ((int)$this->prices_by_qty_id[$i]);
+                                $sql .= " WHERE fk_product_price = " . ((int) $this->prices_by_qty_id[$i]);
                                 $sql .= " ORDER BY quantity ASC";
 
                                 $resql = $this->db->query($sql);
@@ -2731,8 +2731,8 @@ 
                     if ($price_result >= 0) {
                         $this->price = $price_result;
                         // Calculate the VAT
-                        $this->price_ttc = (float)price2num($this->price) * (1 + ($this->tva_tx / 100));
-                        $this->price_ttc = (float)price2num($this->price_ttc, 'MU');
+                        $this->price_ttc = (float) price2num($this->price) * (1 + ($this->tva_tx / 100));
+                        $this->price_ttc = (float) price2num($this->price_ttc, 'MU');
                     }
                 }
 
@@ -2763,7 +2763,7 @@ 
 
         $sql = "SELECT lang, label, description, note as other";
         $sql .= " FROM " . $this->db->prefix() . "product_lang";
-        $sql .= " WHERE fk_product = " . ((int)$this->id);
+        $sql .= " WHERE fk_product = " . ((int) $this->id);
 
         $result = $this->db->query($sql);
         if ($result) {
@@ -2774,9 +2774,9 @@ 
                     $this->description = $obj->description;
                     $this->other = $obj->other;
                 }
-                $this->multilangs[(string)$obj->lang]["label"] = $obj->label;
-                $this->multilangs[(string)$obj->lang]["description"] = $obj->description;
-                $this->multilangs[(string)$obj->lang]["other"] = $obj->other;
+                $this->multilangs[(string) $obj->lang]["label"] = $obj->label;
+                $this->multilangs[(string) $obj->lang]["description"] = $obj->description;
+                $this->multilangs[(string) $obj->lang]["other"] = $obj->other;
             }
             return 1;
         } else {
@@ -2802,7 +2802,7 @@ 
             if ($key == $current_lang) {
                 $sql = "SELECT rowid";
                 $sql .= " FROM " . $this->db->prefix() . "product_lang";
-                $sql .= " WHERE fk_product = " . ((int)$this->id);
+                $sql .= " WHERE fk_product = " . ((int) $this->id);
                 $sql .= " AND lang = '" . $this->db->escape($key) . "'";
 
                 $result = $this->db->query($sql);
@@ -2815,14 +2815,14 @@ 
                     if (getDolGlobalString('PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION')) {
                         $sql2 .= ", note='" . $this->db->escape($this->other) . "'";
                     }
-                    $sql2 .= " WHERE fk_product = " . ((int)$this->id) . " AND lang = '" . $this->db->escape($key) . "'";
+                    $sql2 .= " WHERE fk_product = " . ((int) $this->id) . " AND lang = '" . $this->db->escape($key) . "'";
                 } else {
                     $sql2 = "INSERT INTO " . $this->db->prefix() . "product_lang (fk_product, lang, label, description";
                     if (getDolGlobalString('PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION')) {
                         $sql2 .= ", note";
                     }
                     $sql2 .= ")";
-                    $sql2 .= " VALUES(" . ((int)$this->id) . ",'" . $this->db->escape($key) . "','" . $this->db->escape($this->label) . "',";
+                    $sql2 .= " VALUES(" . ((int) $this->id) . ",'" . $this->db->escape($key) . "','" . $this->db->escape($this->label) . "',";
                     $sql2 .= " '" . $this->db->escape($this->description) . "'";
                     if (getDolGlobalString('PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION')) {
                         $sql2 .= ", '" . $this->db->escape($this->other) . "'";
@@ -2842,7 +2842,7 @@ 
 
                 $sql = "SELECT rowid";
                 $sql .= " FROM " . $this->db->prefix() . "product_lang";
-                $sql .= " WHERE fk_product = " . ((int)$this->id);
+                $sql .= " WHERE fk_product = " . ((int) $this->id);
                 $sql .= " AND lang = '" . $this->db->escape($key) . "'";
 
                 $result = $this->db->query($sql);
@@ -2855,14 +2855,14 @@ 
                     if (getDolGlobalString('PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION')) {
                         $sql2 .= ", note = '" . $this->db->escape($this->multilangs["$key"]["other"]) . "'";
                     }
-                    $sql2 .= " WHERE fk_product = " . ((int)$this->id) . " AND lang = '" . $this->db->escape($key) . "'";
+                    $sql2 .= " WHERE fk_product = " . ((int) $this->id) . " AND lang = '" . $this->db->escape($key) . "'";
                 } else {
                     $sql2 = "INSERT INTO " . $this->db->prefix() . "product_lang (fk_product, lang, label, description";
                     if (getDolGlobalString('PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION')) {
                         $sql2 .= ", note";
                     }
                     $sql2 .= ")";
-                    $sql2 .= " VALUES(" . ((int)$this->id) . ",'" . $this->db->escape($key) . "','" . $this->db->escape($this->multilangs["$key"]["label"]) . "',";
+                    $sql2 .= " VALUES(" . ((int) $this->id) . ",'" . $this->db->escape($key) . "','" . $this->db->escape($this->multilangs["$key"]["label"]) . "',";
                     $sql2 .= " '" . $this->db->escape($this->multilangs["$key"]["description"]) . "'";
                     if (getDolGlobalString('PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION')) {
                         $sql2 .= ", '" . $this->db->escape($this->multilangs["$key"]["other"]) . "'";
@@ -2955,8 +2955,8 @@ 
             }
 
             $op = array();
-            $op[0] = "+" . trim((string)$nbpiece);
-            $op[1] = "-" . trim((string)$nbpiece);
+            $op[0] = "+" . trim((string) $nbpiece);
+            $op[1] = "-" . trim((string) $nbpiece);
 
             $movementstock = new MouvementStock($this->db);
             $movementstock->setOrigin($origin_element, $origin_id); // Set ->origin_type and ->fk_origin
@@ -3015,8 +3015,8 @@ 
                 $nbpiece = abs($nbpiece);
             }
             $op = array();
-            $op[0] = "+" . trim((string)$nbpiece);
-            $op[1] = "-" . trim((string)$nbpiece);
+            $op[0] = "+" . trim((string) $nbpiece);
+            $op[1] = "-" . trim((string) $nbpiece);
 
             $movementstock = new MouvementStock($this->db);
             $movementstock->setOrigin($origin_element, $origin_id); // Set ->origin_type and ->origin_id
@@ -3087,7 +3087,7 @@ 
                 $sql = "DELETE FROM " . $this->db->prefix() . 'product_batch';
                 $sql .= " WHERE fk_product_stock IN (";
                 $sql .= "SELECT rowid FROM " . $this->db->prefix() . 'product_stock';
-                $sql .= " WHERE fk_product = " . ((int)$this->id) . ")";
+                $sql .= " WHERE fk_product = " . ((int) $this->id) . ")";
 
                 $result = $this->db->query($sql);
                 if (!$result) {
@@ -3102,7 +3102,7 @@ 
                 foreach ($elements as $table) {
                     if (!$error) {
                         $sql = "DELETE FROM " . $this->db->prefix() . $table;
-                        $sql .= " WHERE fk_product = " . (int)$this->id;
+                        $sql .= " WHERE fk_product = " . (int) $this->id;
 
                         $result = $this->db->query($sql);
                         if (!$result) {
@@ -3132,7 +3132,7 @@ 
             // Delete from product_association
             if (!$error) {
                 $sql = "DELETE FROM " . $this->db->prefix() . "product_association";
-                $sql .= " WHERE fk_product_pere = " . (int)$this->id . " OR fk_product_fils = " . (int)$this->id;
+                $sql .= " WHERE fk_product_pere = " . (int) $this->id . " OR fk_product_fils = " . (int) $this->id;
 
                 $result = $this->db->query($sql);
                 if (!$result) {
@@ -3153,7 +3153,7 @@ 
             // Delete product
             if (!$error) {
                 $sqlz = "DELETE FROM " . $this->db->prefix() . "product";
-                $sqlz .= " WHERE rowid = " . (int)$this->id;
+                $sqlz .= " WHERE rowid = " . (int) $this->id;
 
                 $resultz = $this->db->query($sqlz);
                 if (!$resultz) {
@@ -3256,7 +3256,7 @@ 
     public function delMultiLangs($langtodelete, $user)
     {
         $sql = "DELETE FROM " . $this->db->prefix() . "product_lang";
-        $sql .= " WHERE fk_product = " . ((int)$this->id) . " AND lang = '" . $this->db->escape($langtodelete) . "'";
+        $sql .= " WHERE fk_product = " . ((int) $this->id) . " AND lang = '" . $this->db->escape($langtodelete) . "'";
 
         dol_syslog(get_only_class($this) . '::delMultiLangs', LOG_DEBUG);
         $result = $this->db->query($sql);
@@ -3313,7 +3313,7 @@ 
 
         $sql = "UPDATE " . $this->db->prefix() . $this->table_element . " SET ";
         $sql .= "$field = '" . $this->db->escape($value) . "'";
-        $sql .= " WHERE rowid = " . ((int)$this->id);
+        $sql .= " WHERE rowid = " . ((int) $this->id);
 
         dol_syslog(__METHOD__, LOG_DEBUG);
         $resql = $this->db->query($sql);
@@ -3355,11 +3355,11 @@ 
     {
         // phpcs:enable
         $sql = "DELETE FROM " . $this->db->prefix() . "product_price_by_qty";
-        $sql .= " WHERE fk_product_price = " . ((int)$rowid);
+        $sql .= " WHERE fk_product_price = " . ((int) $rowid);
         $resql = $this->db->query($sql);
 
         $sql = "DELETE FROM " . $this->db->prefix() . "product_price";
-        $sql .= " WHERE rowid=" . ((int)$rowid);
+        $sql .= " WHERE rowid=" . ((int) $rowid);
         $resql = $this->db->query($sql);
         if ($resql) {
             return 1;
@@ -3534,9 +3534,9 @@ 
         $sql .= " pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code,";
         $sql .= " pfp.packaging";
         $sql .= " FROM " . $this->db->prefix() . "product_fournisseur_price as pfp";
-        $sql .= " WHERE pfp.rowid = " . ((int)$prodfournprice);
+        $sql .= " WHERE pfp.rowid = " . ((int) $prodfournprice);
         if ($qty > 0) {
-            $sql .= " AND pfp.quantity <= " . ((float)$qty);
+            $sql .= " AND pfp.quantity <= " . ((float) $qty);
         }
         $sql .= " ORDER BY pfp.quantity DESC";
 
@@ -3590,16 +3590,16 @@ 
                 $sql .= " FROM " . $this->db->prefix() . "product_fournisseur_price as pfp";
                 $sql .= " WHERE 1 = 1";
                 if ($product_id > 0) {
-                    $sql .= " AND pfp.fk_product = " . ((int)$product_id);
+                    $sql .= " AND pfp.fk_product = " . ((int) $product_id);
                 }
                 if ($fourn_ref != 'none') {
                     $sql .= " AND pfp.ref_fourn = '" . $this->db->escape($fourn_ref) . "'";
                 }
                 if ($fk_soc > 0) {
-                    $sql .= " AND pfp.fk_soc = " . ((int)$fk_soc);
+                    $sql .= " AND pfp.fk_soc = " . ((int) $fk_soc);
                 }
                 if ($qty > 0) {
-                    $sql .= " AND pfp.quantity <= " . ((float)$qty);
+                    $sql .= " AND pfp.quantity <= " . ((float) $qty);
                 }
                 $sql .= " ORDER BY pfp.quantity DESC";
                 $sql .= " LIMIT 1";
@@ -3720,25 +3720,25 @@ 
         if ($newprice !== '' || $newprice === 0) {
             if ($newpricebase == 'TTC') {
                 $price_ttc = price2num($newprice, 'MU');
-                $price = (float)price2num($newprice) / (1 + ((float)$newvat / 100));
+                $price = (float) price2num($newprice) / (1 + ((float) $newvat / 100));
                 $price = price2num($price, 'MU');
 
                 if ($newminprice != '' || $newminprice == 0) {
                     $price_min_ttc = price2num($newminprice, 'MU');
-                    $price_min = (float)price2num($newminprice) / (1 + ($newvat / 100));
+                    $price_min = (float) price2num($newminprice) / (1 + ($newvat / 100));
                     $price_min = price2num($price_min, 'MU');
                 } else {
                     $price_min = 0;
                     $price_min_ttc = 0;
                 }
             } else {
-                $price = (float)price2num($newprice, 'MU');
+                $price = (float) price2num($newprice, 'MU');
                 $price_ttc = ($newnpr != 1) ? price2num($newprice) * (1 + ($newvat / 100)) : $price;
-                $price_ttc = (float)price2num($price_ttc, 'MU');
+                $price_ttc = (float) price2num($price_ttc, 'MU');
 
                 if ($newminprice !== '' || $newminprice === 0) {
                     $price_min = price2num($newminprice, 'MU');
-                    $price_min_ttc = (float)price2num($newminprice) * (1 + ($newvat / 100));
+                    $price_min_ttc = (float) price2num($newminprice) * (1 + ($newvat / 100));
                     $price_min_ttc = price2num($price_min_ttc, 'MU');
                     //print 'X'.$newminprice.'-'.$price_min;
                 } else {
@@ -3761,7 +3761,7 @@ 
                     $sql = "SELECT t.rowid, t.code, t.recuperableonly as tva_npr, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
                     $sql .= " FROM " . MAIN_DB_PREFIX . "c_tva as t, " . MAIN_DB_PREFIX . "c_country as c";
                     $sql .= " WHERE t.fk_pays = c.rowid AND c.code = '" . $this->db->escape($mysoc->country_code) . "'";
-                    $sql .= " AND t.taux = " . ((float)$newdefaultvatcode) . " AND t.active = 1";
+                    $sql .= " AND t.taux = " . ((float) $newdefaultvatcode) . " AND t.active = 1";
                     $sql .= " AND t.code = '" . $this->db->escape($newdefaultvatcode) . "'";
                     $resql = $this->db->query($sql);
                     if ($resql) {
@@ -3795,19 +3795,19 @@ 
             // Ceci provoque des stockages avec arrondis en base au lieu des valeurs exactes.
             $sql = "UPDATE " . $this->db->prefix() . "product SET";
             $sql .= " price_base_type = '" . $this->db->escape($newpricebase) . "',";
-            $sql .= " price = " . (float)$price . ",";
-            $sql .= " price_ttc = " . (float)$price_ttc . ",";
-            $sql .= " price_min = " . (float)$price_min . ",";
-            $sql .= " price_min_ttc = " . (float)$price_min_ttc . ",";
-            $sql .= " localtax1_tx = " . ($localtax1 >= 0 ? (float)$localtax1 : 'NULL') . ",";
-            $sql .= " localtax2_tx = " . ($localtax2 >= 0 ? (float)$localtax2 : 'NULL') . ",";
+            $sql .= " price = " . (float) $price . ",";
+            $sql .= " price_ttc = " . (float) $price_ttc . ",";
+            $sql .= " price_min = " . (float) $price_min . ",";
+            $sql .= " price_min_ttc = " . (float) $price_min_ttc . ",";
+            $sql .= " localtax1_tx = " . ($localtax1 >= 0 ? (float) $localtax1 : 'NULL') . ",";
+            $sql .= " localtax2_tx = " . ($localtax2 >= 0 ? (float) $localtax2 : 'NULL') . ",";
             $sql .= " localtax1_type = " . ($localtaxtype1 != '' ? "'" . $this->db->escape($localtaxtype1) . "'" : "'0'") . ",";
             $sql .= " localtax2_type = " . ($localtaxtype2 != '' ? "'" . $this->db->escape($localtaxtype2) . "'" : "'0'") . ",";
             $sql .= " default_vat_code = " . ($newdefaultvatcode ? "'" . $this->db->escape($newdefaultvatcode) . "'" : "null") . ",";
             $sql .= " price_label = " . (!empty($price_label) ? "'" . $this->db->escape($price_label) . "'" : "null") . ",";
-            $sql .= " tva_tx = " . (float)price2num($newvat) . ",";
+            $sql .= " tva_tx = " . (float) price2num($newvat) . ",";
             $sql .= " recuperableonly = '" . $this->db->escape($newnpr) . "'";
-            $sql .= " WHERE rowid = " . ((int)$id);
+            $sql .= " WHERE rowid = " . ((int) $id);
 
             dol_syslog(get_only_class($this) . "::update_price", LOG_DEBUG);
             $resql = $this->db->query($sql);
@@ -3893,13 +3893,13 @@ 
 
         $lastPrice = array(
             'level' => $level ? $level : 1,
-            'multiprices' => (float)$this->multiprices[$level],
-            'multiprices_ttc' => (float)$this->multiprices_ttc[$level],
+            'multiprices' => (float) $this->multiprices[$level],
+            'multiprices_ttc' => (float) $this->multiprices_ttc[$level],
             'multiprices_base_type' => $this->multiprices_base_type[$level],
-            'multiprices_min' => (float)$this->multiprices_min[$level],
-            'multiprices_min_ttc' => (float)$this->multiprices_min_ttc[$level],
-            'multiprices_tva_tx' => (float)$this->multiprices_tva_tx[$level],
-            'multiprices_recuperableonly' => (float)$this->multiprices_recuperableonly[$level],
+            'multiprices_min' => (float) $this->multiprices_min[$level],
+            'multiprices_min_ttc' => (float) $this->multiprices_min_ttc[$level],
+            'multiprices_tva_tx' => (float) $this->multiprices_tva_tx[$level],
+            'multiprices_recuperableonly' => (float) $this->multiprices_recuperableonly[$level],
         );
 
         return $lastPrice;
@@ -4015,15 +4015,15 @@ 
             $sql .= " FROM " . $this->db->prefix() . "mrp_mo as c";
             $sql .= " INNER JOIN " . $this->db->prefix() . "mrp_production as mp ON mp.fk_mo=c.rowid";
             if (!$user->hasRight('societe', 'client', 'voir')) {
-                $sql .= " INNER JOIN " . $this->db->prefix() . "societe_commerciaux as sc ON sc.fk_soc=c.fk_soc AND sc.fk_user = " . ((int)$user->id);
+                $sql .= " INNER JOIN " . $this->db->prefix() . "societe_commerciaux as sc ON sc.fk_soc=c.fk_soc AND sc.fk_user = " . ((int) $user->id);
             }
             $sql .= " WHERE ";
             $sql .= " c.entity IN (" . getEntity('mo') . ")";
 
-            $sql .= " AND mp.fk_product = " . ((int)$this->id);
+            $sql .= " AND mp.fk_product = " . ((int) $this->id);
             $sql .= " AND mp.role ='" . $this->db->escape($role) . "'";
             if ($socid > 0) {
-                $sql .= " AND c.fk_soc = " . ((int)$socid);
+                $sql .= " AND c.fk_soc = " . ((int) $socid);
             }
 
             $result = $this->db->query($sql);
@@ -4031,7 +4031,7 @@ 
                 $obj = $this->db->fetch_object($result);
                 $this->stats_mo['customers_' . $role] = $obj->nb_customers ? $obj->nb_customers : 0;
                 $this->stats_mo['nb_' . $role] = $obj->nb ? $obj->nb : 0;
-                $this->stats_mo['qty_' . $role] = $obj->qty ? price2num($obj->qty, 'MS') : 0;     // qty may be a float due to the SUM()
+                $this->stats_mo['qty_' . $role] = $obj->qty ? price2num($obj->qty, 'MS') : 0; // qty may be a float due to the SUM()
             } else {
                 $this->error = $this->db->error();
                 $error++;
@@ -4077,7 +4077,7 @@ 
         $sql .= " INNER JOIN " . $this->db->prefix() . "bom_bomline as bl ON bl.fk_bom=b.rowid";
         $sql .= " WHERE ";
         $sql .= " b.entity IN (" . getEntity('bom') . ")";
-        $sql .= " AND b.fk_product =" . ((int)$this->id);
+        $sql .= " AND b.fk_product =" . ((int) $this->id);
         $sql .= " GROUP BY b.rowid";
 
         $result = $this->db->query($sql);
@@ -4096,7 +4096,7 @@ 
         $sql .= " INNER JOIN " . $this->db->prefix() . "bom_bomline as bl ON bl.fk_bom=b.rowid";
         $sql .= " WHERE ";
         $sql .= " b.entity IN (" . getEntity('bom') . ")";
-        $sql .= " AND bl.fk_product =" . ((int)$this->id);
+        $sql .= " AND bl.fk_product =" . ((int) $this->id);
 
         $result = $this->db->query($sql);
         if ($result) {
@@ -4145,13 +4145,13 @@ 
         $sql .= " WHERE p.rowid = pd.fk_propal";
         $sql .= " AND p.fk_soc = s.rowid";
         $sql .= " AND p.entity IN (" . getEntity('propal') . ")";
-        $sql .= " AND pd.fk_product = " . ((int)$this->id);
+        $sql .= " AND pd.fk_product = " . ((int) $this->id);
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND p.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND p.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         //$sql.= " AND pr.fk_statut != 0";
         if ($socid > 0) {
-            $sql .= " AND p.fk_soc = " . ((int)$socid);
+            $sql .= " AND p.fk_soc = " . ((int) $socid);
         }
 
         $result = $this->db->query($sql);
@@ -4220,13 +4220,13 @@ 
         $sql .= " WHERE p.rowid = pd.fk_supplier_proposal";
         $sql .= " AND p.fk_soc = s.rowid";
         $sql .= " AND p.entity IN (" . getEntity('supplier_proposal') . ")";
-        $sql .= " AND pd.fk_product = " . ((int)$this->id);
+        $sql .= " AND pd.fk_product = " . ((int) $this->id);
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND p.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND p.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         //$sql.= " AND pr.fk_statut != 0";
         if ($socid > 0) {
-            $sql .= " AND p.fk_soc = " . ((int)$socid);
+            $sql .= " AND p.fk_soc = " . ((int) $socid);
         }
 
         $result = $this->db->query($sql);
@@ -4274,13 +4274,13 @@ 
         $sql .= " WHERE c.rowid = cd.fk_contrat";
         $sql .= " AND c.fk_soc = s.rowid";
         $sql .= " AND c.entity IN (" . getEntity('contract') . ")";
-        $sql .= " AND cd.fk_product = " . ((int)$this->id);
+        $sql .= " AND cd.fk_product = " . ((int) $this->id);
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         //$sql.= " AND c.statut != 0";
         if ($socid > 0) {
-            $sql .= " AND c.fk_soc = " . ((int)$socid);
+            $sql .= " AND c.fk_soc = " . ((int) $socid);
         }
 
         $result = $this->db->query($sql);
@@ -4349,13 +4349,13 @@ 
         $sql .= " WHERE f.rowid = fd.fk_facture";
         $sql .= " AND f.fk_soc = s.rowid";
         $sql .= " AND f.entity IN (" . getEntity('invoice') . ")";
-        $sql .= " AND fd.fk_product = " . ((int)$this->id);
+        $sql .= " AND fd.fk_product = " . ((int) $this->id);
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         //$sql.= " AND f.fk_statut != 0";
         if ($socid > 0) {
-            $sql .= " AND f.fk_soc = " . ((int)$socid);
+            $sql .= " AND f.fk_soc = " . ((int) $socid);
         }
 
         $result = $this->db->query($sql);
@@ -4424,13 +4424,13 @@ 
         $sql .= " WHERE f.rowid = fd.fk_facture";
         $sql .= " AND f.fk_soc = s.rowid";
         $sql .= " AND f.entity IN (" . getEntity('invoice') . ")";
-        $sql .= " AND fd.fk_product = " . ((int)$this->id);
+        $sql .= " AND fd.fk_product = " . ((int) $this->id);
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         //$sql.= " AND f.fk_statut != 0";
         if ($socid > 0) {
-            $sql .= " AND f.fk_soc = " . ((int)$socid);
+            $sql .= " AND f.fk_soc = " . ((int) $socid);
         }
 
         $result = $this->db->query($sql);
@@ -4499,13 +4499,13 @@ 
         $sql .= " WHERE f.rowid = fd.fk_facture_fourn";
         $sql .= " AND f.fk_soc = s.rowid";
         $sql .= " AND f.entity IN (" . getEntity('facture_fourn') . ")";
-        $sql .= " AND fd.fk_product = " . ((int)$this->id);
+        $sql .= " AND fd.fk_product = " . ((int) $this->id);
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         //$sql.= " AND f.fk_statut != 0";
         if ($socid > 0) {
-            $sql .= " AND f.fk_soc = " . ((int)$socid);
+            $sql .= " AND f.fk_soc = " . ((int) $socid);
         }
 
         $result = $this->db->query($sql);
@@ -4561,17 +4561,17 @@ 
         }
         $sql .= " WHERE f.rowid = d.fk_facture";
         if ($this->id > 0) {
-            $sql .= " AND d.fk_product = " . ((int)$this->id);
+            $sql .= " AND d.fk_product = " . ((int) $this->id);
         } else {
             $sql .= " AND d.fk_product > 0";
         }
         if ($filteronproducttype >= 0) {
-            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int)$filteronproducttype);
+            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int) $filteronproducttype);
         }
         $sql .= " AND f.fk_soc = s.rowid";
         $sql .= " AND f.entity IN (" . getEntity('invoice') . ")";
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
             $sql .= " AND f.fk_soc = $socid";
@@ -4605,7 +4605,7 @@ 
             while ($i < $num) {
                 $arr = $this->db->fetch_array($resql);
                 if (is_array($arr)) {
-                    $keyfortab = (string)$arr[1];
+                    $keyfortab = (string) $arr[1];
                     if ($year == -1) {
                         $keyfortab = substr($keyfortab, -2);
                     }
@@ -4694,17 +4694,17 @@ 
         }
         $sql .= " WHERE f.rowid = d.fk_facture_fourn";
         if ($this->id > 0) {
-            $sql .= " AND d.fk_product = " . ((int)$this->id);
+            $sql .= " AND d.fk_product = " . ((int) $this->id);
         } else {
             $sql .= " AND d.fk_product > 0";
         }
         if ($filteronproducttype >= 0) {
-            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int)$filteronproducttype);
+            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int) $filteronproducttype);
         }
         $sql .= " AND f.fk_soc = s.rowid";
         $sql .= " AND f.entity IN (" . getEntity('facture_fourn') . ")";
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
             $sql .= " AND f.fk_soc = $socid";
@@ -4748,20 +4748,20 @@ 
         }
         $sql .= " WHERE p.rowid = d.fk_propal";
         if ($this->id > 0) {
-            $sql .= " AND d.fk_product = " . ((int)$this->id);
+            $sql .= " AND d.fk_product = " . ((int) $this->id);
         } else {
             $sql .= " AND d.fk_product > 0";
         }
         if ($filteronproducttype >= 0) {
-            $sql .= " AND prod.rowid = d.fk_product AND prod.fk_product_type = " . ((int)$filteronproducttype);
+            $sql .= " AND prod.rowid = d.fk_product AND prod.fk_product_type = " . ((int) $filteronproducttype);
         }
         $sql .= " AND p.fk_soc = s.rowid";
         $sql .= " AND p.entity IN (" . getEntity('propal') . ")";
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND p.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND p.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
-            $sql .= " AND p.fk_soc = " . ((int)$socid);
+            $sql .= " AND p.fk_soc = " . ((int) $socid);
         }
         $sql .= $morefilter;
         $sql .= " GROUP BY date_format(p.datep,'%Y%m')";
@@ -4802,20 +4802,20 @@ 
         }
         $sql .= " WHERE p.rowid = d.fk_supplier_proposal";
         if ($this->id > 0) {
-            $sql .= " AND d.fk_product = " . ((int)$this->id);
+            $sql .= " AND d.fk_product = " . ((int) $this->id);
         } else {
             $sql .= " AND d.fk_product > 0";
         }
         if ($filteronproducttype >= 0) {
-            $sql .= " AND prod.rowid = d.fk_product AND prod.fk_product_type = " . ((int)$filteronproducttype);
+            $sql .= " AND prod.rowid = d.fk_product AND prod.fk_product_type = " . ((int) $filteronproducttype);
         }
         $sql .= " AND p.fk_soc = s.rowid";
         $sql .= " AND p.entity IN (" . getEntity('supplier_proposal') . ")";
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND p.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND p.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
-            $sql .= " AND p.fk_soc = " . ((int)$socid);
+            $sql .= " AND p.fk_soc = " . ((int) $socid);
         }
         $sql .= $morefilter;
         $sql .= " GROUP BY date_format(p.date_valid,'%Y%m')";
@@ -4855,20 +4855,20 @@ 
         }
         $sql .= " WHERE c.rowid = d.fk_commande";
         if ($this->id > 0) {
-            $sql .= " AND d.fk_product = " . ((int)$this->id);
+            $sql .= " AND d.fk_product = " . ((int) $this->id);
         } else {
             $sql .= " AND d.fk_product > 0";
         }
         if ($filteronproducttype >= 0) {
-            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int)$filteronproducttype);
+            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int) $filteronproducttype);
         }
         $sql .= " AND c.fk_soc = s.rowid";
         $sql .= " AND c.entity IN (" . getEntity('commande') . ")";
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
-            $sql .= " AND c.fk_soc = " . ((int)$socid);
+            $sql .= " AND c.fk_soc = " . ((int) $socid);
         }
         $sql .= $morefilter;
         $sql .= " GROUP BY date_format(c.date_commande,'%Y%m')";
@@ -4908,20 +4908,20 @@ 
         }
         $sql .= " WHERE c.rowid = d.fk_commande";
         if ($this->id > 0) {
-            $sql .= " AND d.fk_product = " . ((int)$this->id);
+            $sql .= " AND d.fk_product = " . ((int) $this->id);
         } else {
             $sql .= " AND d.fk_product > 0";
         }
         if ($filteronproducttype >= 0) {
-            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int)$filteronproducttype);
+            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int) $filteronproducttype);
         }
         $sql .= " AND c.fk_soc = s.rowid";
         $sql .= " AND c.entity IN (" . getEntity('supplier_order') . ")";
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
-            $sql .= " AND c.fk_soc = " . ((int)$socid);
+            $sql .= " AND c.fk_soc = " . ((int) $socid);
         }
         $sql .= $morefilter;
         $sql .= " GROUP BY date_format(c.date_commande,'%Y%m')";
@@ -4963,20 +4963,20 @@ 
         $sql .= " AND c.rowid = d.fk_contrat";
 
         if ($this->id > 0) {
-            $sql .= " AND d.fk_product = " . ((int)$this->id);
+            $sql .= " AND d.fk_product = " . ((int) $this->id);
         } else {
             $sql .= " AND d.fk_product > 0";
         }
         if ($filteronproducttype >= 0) {
-            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int)$filteronproducttype);
+            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int) $filteronproducttype);
         }
         $sql .= " AND c.fk_soc = s.rowid";
 
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
-            $sql .= " AND c.fk_soc = " . ((int)$socid);
+            $sql .= " AND c.fk_soc = " . ((int) $socid);
         }
         $sql .= $morefilter;
         $sql .= " GROUP BY date_format(c.date_contrat,'%Y%m')";
@@ -5018,19 +5018,19 @@ 
         $sql .= " AND d.status > 0";
 
         if ($this->id > 0) {
-            $sql .= " AND d.fk_product = " . ((int)$this->id);
+            $sql .= " AND d.fk_product = " . ((int) $this->id);
         } else {
             $sql .= " AND d.fk_product > 0";
         }
         if ($filteronproducttype >= 0) {
-            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int)$filteronproducttype);
+            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int) $filteronproducttype);
         }
 
         if (!$user->hasRight('societe', 'client', 'voir')) {
-            $sql .= " AND d.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND d.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
         }
         if ($socid > 0) {
-            $sql .= " AND d.fk_soc = " . ((int)$socid);
+            $sql .= " AND d.fk_soc = " . ((int) $socid);
         }
         $sql .= $morefilter;
         $sql .= " GROUP BY date_format(d.date_valid,'%Y%m')";
@@ -5072,21 +5072,21 @@ 
 
         // Check not already father of id_pere (to avoid father -> child -> father links)
         $sql = "SELECT fk_product_pere from " . $this->db->prefix() . "product_association";
-        $sql .= " WHERE fk_product_pere = " . ((int)$id_fils) . " AND fk_product_fils = " . ((int)$id_pere);
+        $sql .= " WHERE fk_product_pere = " . ((int) $id_fils) . " AND fk_product_fils = " . ((int) $id_pere);
         if (!$this->db->query($sql)) {
             dol_print_error($this->db);
             return -1;
         } else {
             //Selection of the highest row
             $sql = "SELECT MAX(rang) as max_rank FROM " . $this->db->prefix() . "product_association";
-            $sql .= " WHERE fk_product_pere  = " . ((int)$id_pere);
+            $sql .= " WHERE fk_product_pere  = " . ((int) $id_pere);
             $resql = $this->db->query($sql);
             if ($resql) {
                 $obj = $this->db->fetch_object($resql);
                 $rank = $obj->max_rank + 1;
                 //Addition of a product with the highest rank +1
                 $sql = "INSERT INTO " . $this->db->prefix() . "product_association(fk_product_pere,fk_product_fils,qty,incdec,rang)";
-                $sql .= " VALUES (" . ((int)$id_pere) . ", " . ((int)$id_fils) . ", " . price2num($qty, 'MS') . ", " . ((int)$incdec) . ", " . ((int)$rank) . ")";
+                $sql .= " VALUES (" . ((int) $id_pere) . ", " . ((int) $id_fils) . ", " . price2num($qty, 'MS') . ", " . ((int) $incdec) . ", " . ((int) $rank) . ")";
                 if (!$this->db->query($sql)) {
                     dol_print_error($this->db);
                     return -1;
@@ -5132,8 +5132,8 @@ 
         }
 
         $sql = "DELETE FROM " . $this->db->prefix() . "product_association";
-        $sql .= " WHERE fk_product_pere  = " . ((int)$fk_parent);
-        $sql .= " AND fk_product_fils = " . ((int)$fk_child);
+        $sql .= " WHERE fk_product_pere  = " . ((int) $fk_parent);
+        $sql .= " AND fk_product_fils = " . ((int) $fk_child);
 
         dol_syslog(get_only_class($this) . '::del_sousproduit', LOG_DEBUG);
         if (!$this->db->query($sql)) {
@@ -5143,7 +5143,7 @@ 
 
         // Updated ranks so that none are missing
         $sqlrank = "SELECT rowid, rang FROM " . $this->db->prefix() . "product_association";
-        $sqlrank .= " WHERE fk_product_pere = " . ((int)$fk_parent);
+        $sqlrank .= " WHERE fk_product_pere = " . ((int) $fk_parent);
         $sqlrank .= " ORDER BY rang";
         $resqlrank = $this->db->query($sqlrank);
         if ($resqlrank) {
@@ -5151,8 +5151,8 @@ 
             while ($objrank = $this->db->fetch_object($resqlrank)) {
                 $cpt++;
                 $sql = "UPDATE " . $this->db->prefix() . "product_association";
-                $sql .= " SET rang = " . ((int)$cpt);
-                $sql .= " WHERE rowid = " . ((int)$objrank->rowid);
+                $sql .= " SET rang = " . ((int) $cpt);
+                $sql .= " WHERE rowid = " . ((int) $objrank->rowid);
                 if (!$this->db->query($sql)) {
                     dol_print_error($this->db);
                     return -1;
@@ -5205,8 +5205,8 @@ 
 
         $sql = 'UPDATE ' . $this->db->prefix() . 'product_association SET ';
         $sql .= 'qty = ' . price2num($qty, 'MS');
-        $sql .= ',incdec = ' . ((int)$incdec);
-        $sql .= ' WHERE fk_product_pere = ' . ((int)$id_pere) . ' AND fk_product_fils = ' . ((int)$id_fils);
+        $sql .= ',incdec = ' . ((int) $incdec);
+        $sql .= ' WHERE fk_product_pere = ' . ((int) $id_pere) . ' AND fk_product_fils = ' . ((int) $id_fils);
 
         if (!$this->db->query($sql)) {
             dol_print_error($this->db);
@@ -5239,8 +5239,8 @@ 
         // phpcs:enable
         $sql = "SELECT fk_product_pere, qty, incdec";
         $sql .= " FROM " . $this->db->prefix() . "product_association";
-        $sql .= " WHERE fk_product_pere  = " . ((int)$fk_parent);
-        $sql .= " AND fk_product_fils = " . ((int)$fk_child);
+        $sql .= " WHERE fk_product_pere  = " . ((int) $fk_parent);
+        $sql .= " AND fk_product_fils = " . ((int) $fk_child);
 
         $result = $this->db->query($sql);
         if ($result) {
@@ -5288,9 +5288,9 @@ 
             // Check if ref is not already used
             $sql = "SELECT rowid, fk_product";
             $sql .= " FROM " . $this->db->prefix() . "product_fournisseur_price";
-            $sql .= " WHERE fk_soc = " . ((int)$id_fourn);
+            $sql .= " WHERE fk_soc = " . ((int) $id_fourn);
             $sql .= " AND ref_fourn = '" . $this->db->escape($ref_fourn) . "'";
-            $sql .= " AND fk_product <> " . ((int)$this->id);
+            $sql .= " AND fk_product <> " . ((int) $this->id);
             $sql .= " AND entity IN (" . getEntity('productsupplierprice') . ")";
 
             $resql = $this->db->query($sql);
@@ -5307,14 +5307,14 @@ 
 
         $sql = "SELECT rowid";
         $sql .= " FROM " . $this->db->prefix() . "product_fournisseur_price";
-        $sql .= " WHERE fk_soc = " . ((int)$id_fourn);
+        $sql .= " WHERE fk_soc = " . ((int) $id_fourn);
         if ($ref_fourn) {
             $sql .= " AND ref_fourn = '" . $this->db->escape($ref_fourn) . "'";
         } else {
             $sql .= " AND (ref_fourn = '' OR ref_fourn IS NULL)";
         }
-        $sql .= " AND quantity = " . ((float)$quantity);
-        $sql .= " AND fk_product = " . ((int)$this->id);
+        $sql .= " AND quantity = " . ((float) $quantity);
+        $sql .= " AND fk_product = " . ((int) $this->id);
         $sql .= " AND entity IN (" . getEntity('productsupplierprice') . ")";
 
         $resql = $this->db->query($sql);
@@ -5334,12 +5334,12 @@ 
                 $sql .= ", tva_tx";
                 $sql .= ") VALUES (";
                 $sql .= "'" . $this->db->idate($now) . "'";
-                $sql .= ", " . ((int)$conf->entity);
-                $sql .= ", " . ((int)$this->id);
-                $sql .= ", " . ((int)$id_fourn);
+                $sql .= ", " . ((int) $conf->entity);
+                $sql .= ", " . ((int) $this->id);
+                $sql .= ", " . ((int) $id_fourn);
                 $sql .= ", '" . $this->db->escape($ref_fourn) . "'";
-                $sql .= ", " . ((float)$quantity);
-                $sql .= ", " . ((int)$user->id);
+                $sql .= ", " . ((float) $quantity);
+                $sql .= ", " . ((int) $user->id);
                 $sql .= ", 0";
                 $sql .= ")";
 
@@ -5377,8 +5377,8 @@ 
 
         $sql = "SELECT DISTINCT p.fk_soc";
         $sql .= " FROM " . $this->db->prefix() . "product_fournisseur_price as p";
-        $sql .= " WHERE p.fk_product = " . ((int)$this->id);
-        $sql .= " AND p.entity = " . ((int)$conf->entity);
+        $sql .= " WHERE p.fk_product = " . ((int) $this->id);
+        $sql .= " AND p.entity = " . ((int) $conf->entity);
 
         $result = $this->db->query($sql);
         if ($result) {
@@ -5466,8 +5466,8 @@ 
         $sql .= ", multicurrency_price";
         $sql .= ", multicurrency_price_ttc";
         $sql .= " FROM " . $this->db->prefix() . "product_price ps";
-        $sql .= " WHERE fk_product = " . ((int)$fromId);
-        $sql .= " AND date_price IN (SELECT MAX(pd.date_price) FROM " . $this->db->prefix() . "product_price pd WHERE pd.fk_product = " . ((int)$fromId) . " AND pd.price_level = ps.price_level)";
+        $sql .= " WHERE fk_product = " . ((int) $fromId);
+        $sql .= " AND date_price IN (SELECT MAX(pd.date_price) FROM " . $this->db->prefix() . "product_price pd WHERE pd.fk_product = " . ((int) $fromId) . " AND pd.price_level = ps.price_level)";
         $sql .= " ORDER BY date_price DESC";
 
         dol_syslog(__METHOD__, LOG_DEBUG);
@@ -5495,7 +5495,7 @@ 
 
         $sql = 'INSERT INTO ' . $this->db->prefix() . 'product_association (fk_product_pere, fk_product_fils, qty, incdec)';
         $sql .= " SELECT " . $toId . ", fk_product_fils, qty, incdec FROM " . $this->db->prefix() . "product_association";
-        $sql .= " WHERE fk_product_pere = " . ((int)$fromId);
+        $sql .= " WHERE fk_product_pere = " . ((int) $fromId);
 
         dol_syslog(get_only_class($this) . '::clone_association', LOG_DEBUG);
         if (!$this->db->query($sql)) {
@@ -5537,9 +5537,9 @@ 
         // les prix de fournisseurs.
         $sql = "INSERT " . $this->db->prefix() . "product_fournisseur_price (";
         $sql .= " datec, fk_product, fk_soc, price, quantity, fk_user, tva_tx)";
-        $sql .= " SELECT '" . $this->db->idate($now) . "', " . ((int)$toId) . ", fk_soc, price, quantity, fk_user, tva_tx";
+        $sql .= " SELECT '" . $this->db->idate($now) . "', " . ((int) $toId) . ", fk_soc, price, quantity, fk_user, tva_tx";
         $sql .= " FROM " . $this->db->prefix() . "product_fournisseur_price";
-        $sql .= " WHERE fk_product = " . ((int)$fromId);
+        $sql .= " WHERE fk_product = " . ((int) $fromId);
 
         dol_syslog(get_only_class($this) . '::clone_fournisseurs', LOG_DEBUG);
         $resql = $this->db->query($sql);
@@ -5658,11 +5658,11 @@ 
         $sql = "SELECT COUNT(pa.rowid) as nb";
         $sql .= " FROM " . $this->db->prefix() . "product_association as pa";
         if ($mode == 0) {
-            $sql .= " WHERE pa.fk_product_fils = " . ((int)$this->id) . " OR pa.fk_product_pere = " . ((int)$this->id);
+            $sql .= " WHERE pa.fk_product_fils = " . ((int) $this->id) . " OR pa.fk_product_pere = " . ((int) $this->id);
         } elseif ($mode == -1) {
-            $sql .= " WHERE pa.fk_product_fils = " . ((int)$this->id); // We are a child, so we found lines that link to parents (can have several parents)
+            $sql .= " WHERE pa.fk_product_fils = " . ((int) $this->id); // We are a child, so we found lines that link to parents (can have several parents)
         } elseif ($mode == 1) {
-            $sql .= " WHERE pa.fk_product_pere = " . ((int)$this->id); // We are a parent, so we found lines that link to children (can have several children)
+            $sql .= " WHERE pa.fk_product_pere = " . ((int) $this->id); // We are a parent, so we found lines that link to children (can have several children)
         }
 
         $resql = $this->db->query($sql);
@@ -5689,7 +5689,7 @@ 
     public function hasVariants()
     {
         $nb = 0;
-        $sql = "SELECT count(rowid) as nb FROM " . $this->db->prefix() . "product_attribute_combination WHERE fk_product_parent = " . ((int)$this->id);
+        $sql = "SELECT count(rowid) as nb FROM " . $this->db->prefix() . "product_attribute_combination WHERE fk_product_parent = " . ((int) $this->id);
         $sql .= " AND entity IN (" . getEntity('product') . ")";
 
         $resql = $this->db->query($sql);
@@ -5714,7 +5714,7 @@ 
     {
         global $conf;
         if (isModEnabled('variants')) {
-            $sql = "SELECT rowid FROM " . $this->db->prefix() . "product_attribute_combination WHERE fk_product_child = " . ((int)$this->id) . " AND entity IN (" . getEntity('product') . ")";
+            $sql = "SELECT rowid FROM " . $this->db->prefix() . "product_attribute_combination WHERE fk_product_child = " . ((int) $this->id) . " AND entity IN (" . getEntity('product') . ")";
 
             $query = $this->db->query($sql);
 
@@ -5779,8 +5779,8 @@ 
         $sql .= " FROM " . $this->db->prefix() . "product as p,";
         $sql .= " " . $this->db->prefix() . "product_association as pa";
         $sql .= " WHERE p.rowid = pa.fk_product_fils";
-        $sql .= " AND pa.fk_product_pere = " . ((int)$id);
-        $sql .= " AND pa.fk_product_fils <> " . ((int)$id); // This should not happens, it is to avoid infinite loop if it happens
+        $sql .= " AND pa.fk_product_pere = " . ((int) $id);
+        $sql .= " AND pa.fk_product_fils <> " . ((int) $id); // This should not happens, it is to avoid infinite loop if it happens
         $sql .= " ORDER BY pa.rang";
 
         dol_syslog(get_only_class($this) . '::getChildsArbo id=' . $id . ' level=' . $level . ' parents=' . (is_array($parents) ? implode(',', $parents) : $parents), LOG_DEBUG);
@@ -5873,7 +5873,7 @@ 
         $label = '';
 
         if (isset($this->finished) && $this->finished >= 0) {
-            $sql = "SELECT label, code FROM " . $this->db->prefix() . "c_product_nature where code = " . ((int)$this->finished) . " AND active=1";
+            $sql = "SELECT label, code FROM " . $this->db->prefix() . "c_product_nature where code = " . ((int) $this->finished) . " AND active=1";
             $resql = $this->db->query($sql);
             if (!$resql) {
                 $this->error = $this->db->error() . ' sql=' . $sql;
@@ -5902,7 +5902,7 @@ 
         $result = array();
 
         $sql = "SELECT pb.batch, pb.eatby, pb.sellby, SUM(pb.qty) AS qty FROM " . $this->db->prefix() . "product_batch as pb, " . $this->db->prefix() . "product_stock as ps";
-        $sql .= " WHERE pb.fk_product_stock = ps.rowid AND ps.fk_product = " . ((int)$this->id) . " AND pb.batch = '" . $this->db->escape($batch) . "'";
+        $sql .= " WHERE pb.fk_product_stock = ps.rowid AND ps.fk_product = " . ((int) $this->id) . " AND pb.batch = '" . $this->db->escape($batch) . "'";
         $sql .= " GROUP BY pb.batch, pb.eatby, pb.sellby";
         dol_syslog(get_only_class($this) . "::loadBatchInfo load first entry found for lot/serial = " . $batch, LOG_DEBUG);
         $resql = $this->db->query($sql);
@@ -6211,7 +6211,7 @@ 
             $label_type = 'short_label';
         }
 
-        $sql = "SELECT " . $label_type . ", code from " . $this->db->prefix() . "c_units where rowid = " . ((int)$this->fk_unit);
+        $sql = "SELECT " . $label_type . ", code from " . $this->db->prefix() . "c_units where rowid = " . ((int) $this->fk_unit);
 
         $resql = $this->db->query($sql);
         if (!$resql) {
@@ -6286,7 +6286,7 @@ 
         $sql = "SELECT p.rowid, p.ref, p.datec as date_creation, p.tms as date_modification,";
         $sql .= " p.fk_user_author, p.fk_user_modif";
         $sql .= " FROM " . $this->db->prefix() . $this->table_element . " as p";
-        $sql .= " WHERE p.rowid = " . ((int)$id);
+        $sql .= " WHERE p.rowid = " . ((int) $id);
 
         $result = $this->db->query($sql);
         if ($result) {

public/htdocs/product/card.php

Spacing +7 added lines, -7 removed lines

@@ -542,7 +542,7 @@ 
                 $sql = "SELECT t.rowid, t.code, t.recuperableonly, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
                 $sql .= " FROM " . MAIN_DB_PREFIX . "c_tva as t, " . MAIN_DB_PREFIX . "c_country as c";
                 $sql .= " WHERE t.fk_pays = c.rowid AND c.code = '" . $db->escape($mysoc->country_code) . "'";
-                $sql .= " AND t.taux = " . ((float)$tva_tx) . " AND t.active = 1";
+                $sql .= " AND t.taux = " . ((float) $tva_tx) . " AND t.active = 1";
                 $sql .= " AND t.code = '" . $db->escape($vatratecode) . "'";
                 $sql .= " AND t.entity IN (" . getEntity('c_tva') . ")";
                 $resql = $db->query($sql);
@@ -702,8 +702,8 @@ 
                 $object->setCategories($categories);
 
                 if (!empty($backtopage)) {
-                    $backtopage = preg_replace('/__ID__/', (string)$object->id, $backtopage); // New method to autoselect parent project after a New on another form object creation
-                    $backtopage = preg_replace('/--IDFORBACKTOPAGE--/', (string)$object->id, $backtopage); // New method to autoselect parent after a New on another form object creation
+                    $backtopage = preg_replace('/__ID__/', (string) $object->id, $backtopage); // New method to autoselect parent project after a New on another form object creation
+                    $backtopage = preg_replace('/--IDFORBACKTOPAGE--/', (string) $object->id, $backtopage); // New method to autoselect parent after a New on another form object creation
                     if (preg_match('/\?/', $backtopage)) {
                         $backtopage .= '&productid=' . $object->id; // Old method
                     }
@@ -1177,7 +1177,7 @@ 
                 );
 
                 if ($result > 0) {
-                    header("Location: " . constant('BASE_URL') . "/commande/card.php?id=" . urlencode((string)($commande->id)));
+                    header("Location: " . constant('BASE_URL') . "/commande/card.php?id=" . urlencode((string) ($commande->id)));
                     exit;
                 }
             } elseif (GETPOST('factureid') > 0) {
@@ -2131,7 +2131,7 @@ 
                     print '<tr><td>' . $langs->trans("DefaultWarehouse") . '</td><td>';
                     print img_picto($langs->trans("DefaultWarehouse"), 'stock', 'class="pictofixedwidth"');
                     print $formproduct->selectWarehouses((GETPOSTISSET('fk_default_warehouse') ? GETPOST('fk_default_warehouse') : $object->fk_default_warehouse), 'fk_default_warehouse', 'warehouseopen', 1, 0, 0, '', 0, 0, array(), 'maxwidth500 widthcentpercentminusxx');
-                    print ' <a href="' . constant('BASE_URL') . '/product/stock/card.php?action=create&amp;backtopage=' . urlencode($_SERVER['PHP_SELF'] . '?action=edit&id=' . ((int)$object->id)) . '">';
+                    print ' <a href="' . constant('BASE_URL') . '/product/stock/card.php?action=create&amp;backtopage=' . urlencode($_SERVER['PHP_SELF'] . '?action=edit&id=' . ((int) $object->id)) . '">';
                     print '<span class="fa fa-plus-circle valignmiddle paddingleft" title="' . $langs->trans("AddWarehouse") . '"></span></a>';
                     print '</td></tr>';
                     /*
@@ -2186,7 +2186,7 @@ 
 
                 if (!$object->isService() && isModEnabled('bom')) {
                     print '<tr><td>' . $form->textwithpicto($langs->trans("DefaultBOM"), $langs->trans("DefaultBOMDesc", $langs->transnoentitiesnoconv("Finished"))) . '</td><td>';
-                    $bomkey = "BOM:bom/class/bom.class.php:0:(t.status:=:1) AND (t.fk_product:=:" . ((int)$object->id) . ')';
+                    $bomkey = "BOM:bom/class/bom.class.php:0:(t.status:=:1) AND (t.fk_product:=:" . ((int) $object->id) . ')';
                     print $form->selectForForms($bomkey, 'fk_default_bom', (GETPOSTISSET('fk_default_bom') ? GETPOST('fk_default_bom') : $object->fk_default_bom), 1);
                     print '</td></tr>';
                 }
@@ -2421,7 +2421,7 @@ 
             print dol_get_fiche_head($head, 'card', $titre, -1, $picto);
 
             $linkback = '<a href="' . constant('BASE_URL') . '/product/list.php?restore_lastsearch_values=1&type=' . $object->type . '">' . $langs->trans("BackToList") . '</a>';
-            $object->next_prev_filter = "fk_product_type:=:" . ((int)$object->type);
+            $object->next_prev_filter = "fk_product_type:=:" . ((int) $object->type);
 
             $shownav = 1;
             if ($user->socid && !in_array('product', explode(',', getDolGlobalString('MAIN_MODULES_FOR_EXTERNAL')))) {