alxarafe / alixar

Dolibarr/Code/Contact/Classes/Contact.php

Spacing +41 added lines, -41 removed lines

@@ -213,8 +213,8 @@ 
     /**
      * @var int Thirdparty ID
      */
-    public $socid;      // both socid and fk_soc are used
-    public $fk_soc;     // both socid and fk_soc are used
+    public $socid; // both socid and fk_soc are used
+    public $fk_soc; // both socid and fk_soc are used
 
     /**
      * @var string Thirdparty name
@@ -447,13 +447,13 @@ 
         if (!$user->hasRight('societe', 'client', 'voir')) {
             $sql .= ", " . MAIN_DB_PREFIX . "societe as s";
             $sql .= ", " . MAIN_DB_PREFIX . "societe_commerciaux as sc";
-            $sql .= " WHERE sp.fk_soc = s.rowid AND s.rowid = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " WHERE sp.fk_soc = s.rowid AND s.rowid = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
             $clause = "AND";
         }
         $sql .= " " . $clause . " sp.entity IN (" . getEntity($this->element) . ")";
-        $sql .= " AND (sp.priv='0' OR (sp.priv='1' AND sp.fk_user_creat = " . ((int)$user->id) . "))";
+        $sql .= " AND (sp.priv='0' OR (sp.priv='1' AND sp.fk_user_creat = " . ((int) $user->id) . "))";
         if ($user->socid > 0) {
-            $sql .= " AND sp.fk_soc = " . ((int)$user->socid);
+            $sql .= " AND sp.fk_soc = " . ((int) $user->socid);
         }
         // Add where from hooks
         if (is_object($hookmanager)) {
@@ -526,19 +526,19 @@ 
         $sql .= ") VALUES (";
         $sql .= "'" . $this->db->idate($now) . "',";
         if ($this->socid > 0) {
-            $sql .= " " . ((int)$this->socid) . ",";
+            $sql .= " " . ((int) $this->socid) . ",";
         } else {
             $sql .= "null,";
         }
         $sql .= "'" . $this->db->escape($this->name_alias) . "',";
         $sql .= "'" . $this->db->escape($this->lastname) . "',";
         $sql .= "'" . $this->db->escape($this->firstname) . "',";
-        $sql .= " " . ($user->id > 0 ? ((int)$user->id) : "null") . ",";
-        $sql .= " " . ((int)$this->priv) . ",";
+        $sql .= " " . ($user->id > 0 ? ((int) $user->id) : "null") . ",";
+        $sql .= " " . ((int) $this->priv) . ",";
         $sql .= " 0,";
-        $sql .= " " . ((int)$this->statut) . ",";
+        $sql .= " " . ((int) $this->statut) . ",";
         $sql .= " " . (!empty($this->canvas) ? "'" . $this->db->escape($this->canvas) . "'" : "null") . ",";
-        $sql .= " " . ((int)$this->entity) . ",";
+        $sql .= " " . ((int) $this->entity) . ",";
         $sql .= "'" . $this->db->escape($this->ref_ext) . "',";
         $sql .= " " . (!empty($this->import_key) ? "'" . $this->db->escape($this->import_key) . "'" : "null");
         $sql .= ")";
@@ -640,7 +640,7 @@ 
 
         $sql = "UPDATE " . MAIN_DB_PREFIX . "socpeople SET";
         if ($this->socid > 0) {
-            $sql .= " fk_soc = " . ((int)$this->socid) . ",";
+            $sql .= " fk_soc = " . ((int) $this->socid) . ",";
         } elseif ($this->socid == -1) {
             $sql .= " fk_soc = NULL,";
         }
@@ -670,11 +670,11 @@ 
         if (isset($this->stcomm_id)) {
             $sql .= ", fk_stcommcontact = " . ($this->stcomm_id > 0 || $this->stcomm_id == -1 ? $this->stcomm_id : "0");
         }
-        $sql .= ", statut = " . ((int)$this->statut);
+        $sql .= ", statut = " . ((int) $this->statut);
         $sql .= ", fk_user_modif=" . ($user->id > 0 ? "'" . $this->db->escape($user->id) . "'" : "NULL");
         $sql .= ", default_lang=" . ($this->default_lang ? "'" . $this->db->escape($this->default_lang) . "'" : "NULL");
-        $sql .= ", entity = " . ((int)$this->entity);
-        $sql .= " WHERE rowid = " . ((int)$id);
+        $sql .= ", entity = " . ((int) $this->entity);
+        $sql .= " WHERE rowid = " . ((int) $id);
 
         dol_syslog(get_only_class($this) . "::update", LOG_DEBUG);
         $result = $this->db->query($sql);
@@ -792,12 +792,12 @@ 
         $error = 0;
 
         if (!isset($this->roles)) {
-            return 0;   // Avoid to loose roles when property not set
+            return 0; // Avoid to loose roles when property not set
         }
 
         $this->db->begin();
 
-        $sql = "DELETE FROM " . MAIN_DB_PREFIX . "societe_contacts WHERE fk_socpeople=" . ((int)$this->id) . " AND entity IN (" . getEntity("contact") . ")";
+        $sql = "DELETE FROM " . MAIN_DB_PREFIX . "societe_contacts WHERE fk_socpeople=" . ((int) $this->id) . " AND entity IN (" . getEntity("contact") . ")";
 
         $result = $this->db->query($sql);
         if (!$result) {
@@ -902,7 +902,7 @@ 
         $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "societe as s ON c.fk_soc = s.rowid";
         $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_stcommcontact as st ON c.fk_stcommcontact = st.id';
         if ($id) {
-            $sql .= " WHERE c.rowid = " . ((int)$id);
+            $sql .= " WHERE c.rowid = " . ((int) $id);
         } else {
             $sql .= " WHERE c.entity IN (" . getEntity($this->element) . ")";
             if ($ref_ext) {
@@ -950,8 +950,8 @@ 
                 $this->country_code = $obj->country_id ? $obj->country_code : '';
                 $this->country = $obj->country_id ? ($langs->trans('Country' . $obj->country_code) != 'Country' . $obj->country_code ? $langs->transnoentities('Country' . $obj->country_code) : $obj->country) : '';
 
-                $this->fk_soc = $obj->fk_soc;     // Both fk_soc and socid are used
-                $this->socid = $obj->fk_soc;     // Both fk_soc and socid are used
+                $this->fk_soc = $obj->fk_soc; // Both fk_soc and socid are used
+                $this->socid = $obj->fk_soc; // Both fk_soc and socid are used
                 $this->socname = $obj->socname;
                 $this->poste = $obj->poste;
                 $this->statut = $obj->statut;
@@ -970,7 +970,7 @@ 
                 $this->phone_mobile = trim($obj->phone_mobile);
 
                 $this->email = $obj->email;
-                $this->socialnetworks = ($obj->socialnetworks ? (array)json_decode($obj->socialnetworks, true) : array());
+                $this->socialnetworks = ($obj->socialnetworks ? (array) json_decode($obj->socialnetworks, true) : array());
                 $this->photo = $obj->photo;
                 $this->priv = $obj->priv;
                 $this->mail = $obj->email;
@@ -992,7 +992,7 @@ 
                 // Search Dolibarr user linked to this contact
                 $sql = "SELECT u.rowid ";
                 $sql .= " FROM " . MAIN_DB_PREFIX . "user as u";
-                $sql .= " WHERE u.fk_socpeople = " . ((int)$this->id);
+                $sql .= " WHERE u.fk_socpeople = " . ((int) $this->id);
 
                 $resql = $this->db->query($sql);
                 if ($resql) {
@@ -1015,7 +1015,7 @@ 
                 if ($user) {
                     $sql = "SELECT fk_user";
                     $sql .= " FROM " . MAIN_DB_PREFIX . "user_alert";
-                    $sql .= " WHERE fk_user = " . ((int)$user->id) . " AND fk_contact = " . ((int)$id);
+                    $sql .= " WHERE fk_user = " . ((int) $user->id) . " AND fk_contact = " . ((int) $id);
 
                     $resql = $this->db->query($sql);
                     if ($resql) {
@@ -1084,7 +1084,7 @@ 
         $sql .= " FROM " . MAIN_DB_PREFIX . "societe_contacts as sc, " . MAIN_DB_PREFIX . "c_type_contact as tc";
         $sql .= " WHERE tc.rowid = sc.fk_c_type_contact";
         $sql .= " AND tc.source = 'external' AND tc.active=1";
-        $sql .= " AND sc.fk_socpeople = " . ((int)$this->id);
+        $sql .= " AND sc.fk_socpeople = " . ((int) $this->id);
         $sql .= " AND sc.entity IN (" . getEntity('societe') . ')';
 
         $resql = $this->db->query($sql);
@@ -1135,9 +1135,9 @@ 
         $sql .= " birthday = " . ($this->birthday ? "'" . $this->db->idate($this->birthday) . "'" : "null");
         $sql .= ", photo = " . ($this->photo ? "'" . $this->db->escape($this->photo) . "'" : "null");
         if ($user) {
-            $sql .= ", fk_user_modif = " . ((int)$user->id);
+            $sql .= ", fk_user_modif = " . ((int) $user->id);
         }
-        $sql .= " WHERE rowid = " . ((int)$id);
+        $sql .= " WHERE rowid = " . ((int) $id);
 
         dol_syslog(get_only_class($this) . "::update_perso this->birthday=" . $this->birthday . " -", LOG_DEBUG);
         $resql = $this->db->query($sql);
@@ -1150,12 +1150,12 @@ 
             // Update birthday alert
             if (!empty($this->birthday_alert)) {
                 //check existing
-                $sql_check = "SELECT rowid FROM " . MAIN_DB_PREFIX . "user_alert WHERE type = 1 AND fk_contact = " . ((int)$id) . " AND fk_user = " . ((int)$user->id);
+                $sql_check = "SELECT rowid FROM " . MAIN_DB_PREFIX . "user_alert WHERE type = 1 AND fk_contact = " . ((int) $id) . " AND fk_user = " . ((int) $user->id);
                 $result_check = $this->db->query($sql_check);
                 if (!$result_check || ($this->db->num_rows($result_check) < 1)) {
                     //insert
                     $sql = "INSERT INTO " . MAIN_DB_PREFIX . "user_alert(type, fk_contact, fk_user) ";
-                    $sql .= "VALUES (1," . ((int)$id) . "," . ((int)$user->id) . ")";
+                    $sql .= "VALUES (1," . ((int) $id) . "," . ((int) $user->id) . ")";
                     $result = $this->db->query($sql);
                     if (!$result) {
                         $error++;
@@ -1166,7 +1166,7 @@ 
                 }
             } else {
                 $sql = "DELETE FROM " . MAIN_DB_PREFIX . "user_alert ";
-                $sql .= "WHERE type=1 AND fk_contact=" . ((int)$id) . " AND fk_user=" . ((int)$user->id);
+                $sql .= "WHERE type=1 AND fk_contact=" . ((int) $id) . " AND fk_user=" . ((int) $user->id);
                 $result = $this->db->query($sql);
                 if (!$result) {
                     $error++;
@@ -1343,7 +1343,7 @@ 
         $sql = "SELECT tc.element, count(ec.rowid) as nb";
         $sql .= " FROM " . MAIN_DB_PREFIX . "element_contact as ec, " . MAIN_DB_PREFIX . "c_type_contact as tc";
         $sql .= " WHERE ec.fk_c_type_contact = tc.rowid";
-        $sql .= " AND fk_socpeople = " . ((int)$this->id);
+        $sql .= " AND fk_socpeople = " . ((int) $this->id);
         $sql .= " AND tc.source = 'external'";
         $sql .= " GROUP BY tc.element";
 
@@ -1399,7 +1399,7 @@ 
             $sql = "SELECT ec.rowid";
             $sql .= " FROM " . MAIN_DB_PREFIX . "element_contact ec,";
             $sql .= " " . MAIN_DB_PREFIX . "c_type_contact tc";
-            $sql .= " WHERE ec.fk_socpeople=" . ((int)$this->id);
+            $sql .= " WHERE ec.fk_socpeople=" . ((int) $this->id);
             $sql .= " AND ec.fk_c_type_contact=tc.rowid";
             $sql .= " AND tc.source='external'";
             dol_syslog(__METHOD__, LOG_DEBUG);
@@ -1412,7 +1412,7 @@ 
                     $obj = $this->db->fetch_object($resql);
 
                     $sqldel = "DELETE FROM " . MAIN_DB_PREFIX . "element_contact";
-                    $sqldel .= " WHERE rowid = " . ((int)$obj->rowid);
+                    $sqldel .= " WHERE rowid = " . ((int) $obj->rowid);
                     dol_syslog(__METHOD__, LOG_DEBUG);
                     $result = $this->db->query($sqldel);
                     if (!$result) {
@@ -1430,7 +1430,7 @@ 
 
         if (!$error) {
             // Remove Roles
-            $sql = "DELETE FROM " . MAIN_DB_PREFIX . "societe_contacts WHERE fk_socpeople = " . ((int)$this->id);
+            $sql = "DELETE FROM " . MAIN_DB_PREFIX . "societe_contacts WHERE fk_socpeople = " . ((int) $this->id);
             dol_syslog(__METHOD__, LOG_DEBUG);
             $resql = $this->db->query($sql);
             if (!$resql) {
@@ -1442,7 +1442,7 @@ 
 
         if (!$error) {
             // Remove Notifications
-            $sql = "DELETE FROM " . MAIN_DB_PREFIX . "notify_def WHERE fk_contact = " . ((int)$this->id);
+            $sql = "DELETE FROM " . MAIN_DB_PREFIX . "notify_def WHERE fk_contact = " . ((int) $this->id);
             dol_syslog(__METHOD__, LOG_DEBUG);
             $resql = $this->db->query($sql);
             if (!$resql) {
@@ -1454,7 +1454,7 @@ 
 
         if (!$error) {
             // Remove category
-            $sql = "DELETE FROM " . MAIN_DB_PREFIX . "categorie_contact WHERE fk_socpeople = " . ((int)$this->id);
+            $sql = "DELETE FROM " . MAIN_DB_PREFIX . "categorie_contact WHERE fk_socpeople = " . ((int) $this->id);
             dol_syslog(__METHOD__, LOG_DEBUG);
             $resql = $this->db->query($sql);
             if (!$resql) {
@@ -1466,7 +1466,7 @@ 
 
         if (!$error) {
             $sql = "DELETE FROM " . MAIN_DB_PREFIX . "socpeople";
-            $sql .= " WHERE rowid = " . ((int)$this->id);
+            $sql .= " WHERE rowid = " . ((int) $this->id);
             dol_syslog(__METHOD__, LOG_DEBUG);
             $result = $this->db->query($sql);
             if (!$result) {
@@ -1505,7 +1505,7 @@ 
         $sql = "SELECT c.rowid, c.datec as datec, c.fk_user_creat,";
         $sql .= " c.tms as tms, c.fk_user_modif";
         $sql .= " FROM " . MAIN_DB_PREFIX . "socpeople as c";
-        $sql .= " WHERE c.rowid = " . ((int)$id);
+        $sql .= " WHERE c.rowid = " . ((int) $id);
 
         $resql = $this->db->query($sql);
         if ($resql) {
@@ -1666,9 +1666,9 @@ 
 
         // User disable
         $sql = "UPDATE " . MAIN_DB_PREFIX . "socpeople";
-        $sql .= " SET statut = " . ((int)$this->statut);
-        $sql .= ", fk_user_modif = " . ((int)$user->id);
-        $sql .= " WHERE rowid = " . ((int)$this->id);
+        $sql .= " SET statut = " . ((int) $this->statut);
+        $sql .= ", fk_user_modif = " . ((int) $user->id);
+        $sql .= " WHERE rowid = " . ((int) $this->id);
         $result = $this->db->query($sql);
 
         dol_syslog(get_only_class($this) . "::setstatus", LOG_DEBUG);
@@ -1725,7 +1725,7 @@ 
         $sql .= ", " . MAIN_DB_PREFIX . "societe_contacts sc";
         $sql .= " INNER JOIN " . MAIN_DB_PREFIX . "socpeople sp";
         $sql .= " ON sc.fk_socpeople = sp.rowid AND sp.statut = 1";
-        $sql .= " WHERE sc.fk_soc =" . ((int)$this->socid);
+        $sql .= " WHERE sc.fk_soc =" . ((int) $this->socid);
         $sql .= " AND sc.fk_c_type_contact=tc.rowid";
         $sql .= " AND tc.element = '" . $this->db->escape($element) . "'";
         $sql .= " AND sp.entity IN (" . getEntity('contact') . ")";
@@ -1763,7 +1763,7 @@ 
 
         $sql = "SELECT id, code, libelle as label, picto FROM " . MAIN_DB_PREFIX . "c_stcommcontact";
         if ($active >= 0) {
-            $sql .= " WHERE active = " . ((int)$active);
+            $sql .= " WHERE active = " . ((int) $active);
         }
         $resql = $this->db->query($sql);
         $num = $this->db->num_rows($resql);

Dolibarr/Code/Societe/Classes/Societe.php

Spacing +102 added lines, -102 removed lines

@@ -842,8 +842,8 @@ 
                 $newclient = 3; //If prospect, we keep prospect tag
             }
             $sql = "UPDATE " . MAIN_DB_PREFIX . $this->table_element;
-            $sql .= " SET client = " . ((int)$newclient);
-            $sql .= " WHERE rowid = " . ((int)$this->id);
+            $sql .= " SET client = " . ((int) $newclient);
+            $sql .= " WHERE rowid = " . ((int) $this->id);
 
             $resql = $this->db->query($sql);
             if ($resql) {
@@ -886,7 +886,7 @@ 
             // Position current discount
             $sql = "UPDATE " . MAIN_DB_PREFIX . "societe ";
             $sql .= " SET remise_client = '" . $this->db->escape($remise) . "'";
-            $sql .= " WHERE rowid = " . ((int)$this->id);
+            $sql .= " WHERE rowid = " . ((int) $this->id);
             $resql = $this->db->query($sql);
             if (!$resql) {
                 $this->db->rollback();
@@ -897,9 +897,9 @@ 
             // Writes trace in discount history
             $sql = "INSERT INTO " . MAIN_DB_PREFIX . "societe_remise";
             $sql .= " (entity, datec, fk_soc, remise_client, note, fk_user_author)";
-            $sql .= " VALUES (" . $conf->entity . ", '" . $this->db->idate($now) . "', " . ((int)$this->id) . ", '" . $this->db->escape($remise) . "',";
+            $sql .= " VALUES (" . $conf->entity . ", '" . $this->db->idate($now) . "', " . ((int) $this->id) . ", '" . $this->db->escape($remise) . "',";
             $sql .= " '" . $this->db->escape($note) . "',";
-            $sql .= " " . ((int)$user->id);
+            $sql .= " " . ((int) $user->id);
             $sql .= ")";
 
             $resql = $this->db->query($sql);
@@ -946,7 +946,7 @@ 
             // Position current discount
             $sql = "UPDATE " . MAIN_DB_PREFIX . "societe ";
             $sql .= " SET remise_supplier = '" . $this->db->escape($remise) . "'";
-            $sql .= " WHERE rowid = " . ((int)$this->id);
+            $sql .= " WHERE rowid = " . ((int) $this->id);
             $resql = $this->db->query($sql);
             if (!$resql) {
                 $this->db->rollback();
@@ -957,9 +957,9 @@ 
             // Writes trace in discount history
             $sql = "INSERT INTO " . MAIN_DB_PREFIX . "societe_remise_supplier";
             $sql .= " (entity, datec, fk_soc, remise_supplier, note, fk_user_author)";
-            $sql .= " VALUES (" . $conf->entity . ", '" . $this->db->idate($now) . "', " . ((int)$this->id) . ", '" . $this->db->escape($remise) . "',";
+            $sql .= " VALUES (" . $conf->entity . ", '" . $this->db->idate($now) . "', " . ((int) $this->id) . ", '" . $this->db->escape($remise) . "',";
             $sql .= " '" . $this->db->escape($note) . "',";
-            $sql .= " " . ((int)$user->id);
+            $sql .= " " . ((int) $user->id);
             $sql .= ")";
 
             $resql = $this->db->query($sql);
@@ -1024,15 +1024,15 @@ 
 
             if ($price_base_type == 'TTC') {
                 $discount->amount_ttc = $discount->multicurrency_amount_ttc = price2num($remise, 'MT');
-                $discount->amount_ht = $discount->multicurrency_amount_ht = price2num((float)$remise / (1 + (float)$vatrate / 100), 'MT');
-                $discount->amount_tva = $discount->multicurrency_amount_tva = price2num((float)$discount->amount_ttc - (float)$discount->amount_ht, 'MT');
+                $discount->amount_ht = $discount->multicurrency_amount_ht = price2num((float) $remise / (1 + (float) $vatrate / 100), 'MT');
+                $discount->amount_tva = $discount->multicurrency_amount_tva = price2num((float) $discount->amount_ttc - (float) $discount->amount_ht, 'MT');
             } else {
                 $discount->amount_ht = $discount->multicurrency_amount_ht = price2num($remise, 'MT');
-                $discount->amount_tva = $discount->multicurrency_amount_tva = price2num((float)$remise * (float)$vatrate / 100, 'MT');
-                $discount->amount_ttc = $discount->multicurrency_amount_ttc = price2num((float)$discount->amount_ht + (float)$discount->amount_tva, 'MT');
+                $discount->amount_tva = $discount->multicurrency_amount_tva = price2num((float) $remise * (float) $vatrate / 100, 'MT');
+                $discount->amount_ttc = $discount->multicurrency_amount_ttc = price2num((float) $discount->amount_ht + (float) $discount->amount_tva, 'MT');
             }
 
-            $discount->tva_tx = (float)price2num($vatrate);
+            $discount->tva_tx = (float) price2num($vatrate);
             $discount->vat_src_code = $vat_src_code;
 
             $discount->description = $desc;
@@ -1067,7 +1067,7 @@ 
         if (empty($this->status)) {
             $this->status = 0;
         }
-        $this->name = $this->name ? trim($this->name) : trim((string)$this->nom);
+        $this->name = $this->name ? trim($this->name) : trim((string) $this->nom);
         $this->setUpperOrLowerCase();
         $this->nom = $this->name; // For backward compatibility
         if (empty($this->client)) {
@@ -1076,12 +1076,12 @@ 
         if (empty($this->fournisseur)) {
             $this->fournisseur = 0;
         }
-        $this->import_key = trim((string)$this->import_key);
+        $this->import_key = trim((string) $this->import_key);
 
-        $this->accountancy_code_customer = trim((string)$this->code_compta);
-        $this->accountancy_code_supplier = trim((string)$this->code_compta_fournisseur);
-        $this->accountancy_code_buy = trim((string)$this->accountancy_code_buy);
-        $this->accountancy_code_sell = trim((string)$this->accountancy_code_sell);
+        $this->accountancy_code_customer = trim((string) $this->code_compta);
+        $this->accountancy_code_supplier = trim((string) $this->code_compta_fournisseur);
+        $this->accountancy_code_buy = trim((string) $this->accountancy_code_buy);
+        $this->accountancy_code_sell = trim((string) $this->accountancy_code_sell);
 
         if (!empty($this->multicurrency_code)) {
             $this->fk_multicurrency = MultiCurrency::getIdFromCode($this->db, $this->multicurrency_code);
@@ -1139,18 +1139,18 @@ 
             }
             $sql .= ") VALUES ('" . $this->db->escape($this->name) . "',";
             $sql .= " '" . $this->db->escape($this->name_alias) . "',";
-            $sql .= " " . ((int)$this->entity) . ",";
+            $sql .= " " . ((int) $this->entity) . ",";
             $sql .= " '" . $this->db->idate($this->date_creation) . "'";
-            $sql .= ", " . (!empty($user->id) ? ((int)$user->id) : "null");
-            $sql .= ", " . (!empty($this->typent_id) ? ((int)$this->typent_id) : "null");
+            $sql .= ", " . (!empty($user->id) ? ((int) $user->id) : "null");
+            $sql .= ", " . (!empty($this->typent_id) ? ((int) $this->typent_id) : "null");
             $sql .= ", " . (!empty($this->canvas) ? "'" . $this->db->escape($this->canvas) . "'" : "null");
-            $sql .= ", " . ((int)$this->status);
+            $sql .= ", " . ((int) $this->status);
             $sql .= ", " . (!empty($this->ref_ext) ? "'" . $this->db->escape($this->ref_ext) . "'" : "null");
             $sql .= ", 0";
-            $sql .= ", " . (int)$this->fk_incoterms;
+            $sql .= ", " . (int) $this->fk_incoterms;
             $sql .= ", '" . $this->db->escape($this->location_incoterms) . "'";
             $sql .= ", " . (!empty($this->import_key) ? "'" . $this->db->escape($this->import_key) . "'" : "null");
-            $sql .= ", " . (int)$this->fk_multicurrency;
+            $sql .= ", " . (int) $this->fk_multicurrency;
             $sql .= ", '" . $this->db->escape($this->multicurrency_code) . "'";
             if (!getDolGlobalString('MAIN_COMPANY_PERENTITY_SHARED')) {
                 $sql .= ", " . (empty($this->vat_reverse_charge) ? '0' : '1');
@@ -1169,7 +1169,7 @@ 
 
                 // update accountancy for this entity
                 if (!$error && getDolGlobalString('MAIN_COMPANY_PERENTITY_SHARED')) {
-                    $this->db->query("DELETE FROM " . MAIN_DB_PREFIX . "societe_perentity WHERE fk_soc = " . ((int)$this->id) . " AND entity = " . ((int)$conf->entity));
+                    $this->db->query("DELETE FROM " . MAIN_DB_PREFIX . "societe_perentity WHERE fk_soc = " . ((int) $this->id) . " AND entity = " . ((int) $conf->entity));
 
                     $sql = "INSERT INTO " . MAIN_DB_PREFIX . "societe_perentity (";
                     $sql .= " fk_soc";
@@ -1181,7 +1181,7 @@ 
                     $sql .= ", accountancy_code_sell";
                     $sql .= ") VALUES (";
                     $sql .= $this->id;
-                    $sql .= ", " . ((int)$conf->entity);
+                    $sql .= ", " . ((int) $conf->entity);
                     $sql .= ", " . (empty($this->vat_reverse_charge) ? '0' : '1');
                     $sql .= ", '" . $this->db->escape($this->accountancy_code_customer) . "'";
                     $sql .= ", '" . $this->db->escape($this->accountancy_code_supplier) . "'";
@@ -1378,7 +1378,7 @@ 
             } elseif ($key == 'ACCOUNTANCY_CODE_SUPPLIER') {
                 $keymin = 'code_compta_fournisseur';
             }
-            $i = (int)preg_replace('/[^0-9]/', '', $key);
+            $i = (int) preg_replace('/[^0-9]/', '', $key);
             $vallabel = $this->$keymin;
 
             if ($i > 0) {
@@ -1585,7 +1585,7 @@ 
             }
         }
 
-        return (bool)$isACompany;
+        return (bool) $isACompany;
     }
 
     /**
@@ -1718,40 +1718,40 @@ 
         // Clean parameters
         $this->id = $id;
         $this->entity = ((isset($this->entity) && is_numeric($this->entity)) ? $this->entity : $conf->entity);
-        $this->name = $this->name ? trim($this->name) : trim((string)$this->nom);
+        $this->name = $this->name ? trim($this->name) : trim((string) $this->nom);
         $this->nom = $this->name; // For backward compatibility
-        $this->name_alias = trim((string)$this->name_alias);
+        $this->name_alias = trim((string) $this->name_alias);
         $this->ref_ext = (empty($this->ref_ext) ? '' : trim($this->ref_ext));
-        $this->address = trim((string)$this->address);
-        $this->zip = trim((string)$this->zip);
-        $this->town = trim((string)$this->town);
-        $this->state_id = (is_numeric($this->state_id)) ? (int)trim((string)$this->state_id) : 0;
+        $this->address = trim((string) $this->address);
+        $this->zip = trim((string) $this->zip);
+        $this->town = trim((string) $this->town);
+        $this->state_id = (is_numeric($this->state_id)) ? (int) trim((string) $this->state_id) : 0;
         $this->country_id = ($this->country_id > 0) ? $this->country_id : 0;
-        $this->phone = trim((string)$this->phone);
+        $this->phone = trim((string) $this->phone);
         $this->phone = preg_replace("/\s/", "", $this->phone);
         $this->phone = preg_replace("/\./", "", $this->phone);
-        $this->phone_mobile = trim((string)$this->phone_mobile);
+        $this->phone_mobile = trim((string) $this->phone_mobile);
         $this->phone_mobile = preg_replace("/\s/", "", $this->phone_mobile);
         $this->phone_mobile = preg_replace("/\./", "", $this->phone_mobile);
-        $this->fax = trim((string)$this->fax);
+        $this->fax = trim((string) $this->fax);
         $this->fax = preg_replace("/\s/", "", $this->fax);
         $this->fax = preg_replace("/\./", "", $this->fax);
-        $this->email = trim((string)$this->email);
+        $this->email = trim((string) $this->email);
         $this->url = $this->url ? clean_url($this->url, 0) : '';
         $this->note_private = (empty($this->note_private) ? '' : trim($this->note_private));
         $this->note_public = (empty($this->note_public) ? '' : trim($this->note_public));
-        $this->idprof1 = trim((string)$this->idprof1);
-        $this->idprof2 = trim((string)$this->idprof2);
-        $this->idprof3 = trim((string)$this->idprof3);
-        $this->idprof4 = trim((string)$this->idprof4);
+        $this->idprof1 = trim((string) $this->idprof1);
+        $this->idprof2 = trim((string) $this->idprof2);
+        $this->idprof3 = trim((string) $this->idprof3);
+        $this->idprof4 = trim((string) $this->idprof4);
         $this->idprof5 = (!empty($this->idprof5) ? trim($this->idprof5) : '');
         $this->idprof6 = (!empty($this->idprof6) ? trim($this->idprof6) : '');
-        $this->prefix_comm = trim((string)$this->prefix_comm);
+        $this->prefix_comm = trim((string) $this->prefix_comm);
         $this->outstanding_limit = price2num($this->outstanding_limit);
         $this->order_min_amount = price2num($this->order_min_amount);
         $this->supplier_order_min_amount = price2num($this->supplier_order_min_amount);
 
-        $this->tva_assuj = (is_numeric($this->tva_assuj)) ? (int)trim((string)$this->tva_assuj) : 0;
+        $this->tva_assuj = (is_numeric($this->tva_assuj)) ? (int) trim((string) $this->tva_assuj) : 0;
         $this->tva_intra = dol_sanitizeFileName($this->tva_intra, '');
         $this->vat_reverse_charge = empty($this->vat_reverse_charge) ? 0 : 1;
         if (empty($this->status)) {
@@ -1773,10 +1773,10 @@ 
         $this->localtax1_value = trim($this->localtax1_value);
         $this->localtax2_value = trim($this->localtax2_value);
 
-        $this->capital = ($this->capital != '') ? (float)price2num(trim((string)$this->capital)) : null;
+        $this->capital = ($this->capital != '') ? (float) price2num(trim((string) $this->capital)) : null;
 
-        $this->effectif_id = trim((string)$this->effectif_id);
-        $this->forme_juridique_code = trim((string)$this->forme_juridique_code);
+        $this->effectif_id = trim((string) $this->effectif_id);
+        $this->forme_juridique_code = trim((string) $this->forme_juridique_code);
 
         //Gencod
         $this->barcode = trim($this->barcode);
@@ -1834,7 +1834,7 @@ 
         $this->accountancy_code_sell = (empty($this->accountancy_code_sell) ? '' : trim($this->accountancy_code_sell));
 
         //Incoterms
-        $this->fk_incoterms = (int)$this->fk_incoterms;
+        $this->fk_incoterms = (int) $this->fk_incoterms;
         $this->location_incoterms = trim($this->location_incoterms);
 
         $this->db->begin();
@@ -1879,8 +1879,8 @@ 
             $sql .= ",zip = " . (!empty($this->zip) ? "'" . $this->db->escape($this->zip) . "'" : "null");
             $sql .= ",town = " . (!empty($this->town) ? "'" . $this->db->escape($this->town) . "'" : "null");
 
-            $sql .= ",fk_departement = " . ((!empty($this->state_id) && $this->state_id > 0) ? ((int)$this->state_id) : 'null');
-            $sql .= ",fk_pays = " . ((!empty($this->country_id) && $this->country_id > 0) ? ((int)$this->country_id) : 'null');
+            $sql .= ",fk_departement = " . ((!empty($this->state_id) && $this->state_id > 0) ? ((int) $this->state_id) : 'null');
+            $sql .= ",fk_pays = " . ((!empty($this->country_id) && $this->country_id > 0) ? ((int) $this->country_id) : 'null');
 
             $sql .= ",phone = " . (!empty($this->phone) ? "'" . $this->db->escape($this->phone) . "'" : "null");
             $sql .= ",phone_mobile = " . (!empty($this->phone_mobile) ? "'" . $this->db->escape($this->phone_mobile) . "'" : "null");
@@ -1906,7 +1906,7 @@ 
             if (!getDolGlobalString('MAIN_COMPANY_PERENTITY_SHARED')) {
                 $sql .= ",vat_reverse_charge = " . ($this->vat_reverse_charge != '' ? "'" . $this->db->escape($this->vat_reverse_charge) . "'" : 0);
             }
-            $sql .= ",status = " . ((int)$this->status);
+            $sql .= ",status = " . ((int) $this->status);
 
             // Local taxes
             $sql .= ",localtax1_assuj = " . ($this->localtax1_assuj != '' ? "'" . $this->db->escape($this->localtax1_assuj) . "'" : "null");
@@ -1935,12 +1935,12 @@ 
 
             $sql .= ",prefix_comm = " . (!empty($this->prefix_comm) ? "'" . $this->db->escape($this->prefix_comm) . "'" : "null");
 
-            $sql .= ",fk_effectif = " . ($this->effectif_id > 0 ? ((int)$this->effectif_id) : "null");
+            $sql .= ",fk_effectif = " . ($this->effectif_id > 0 ? ((int) $this->effectif_id) : "null");
             if (isset($this->stcomm_id)) {
-                $sql .= ",fk_stcomm=" . (int)$this->stcomm_id;
+                $sql .= ",fk_stcomm=" . (int) $this->stcomm_id;
             }
             if (isset($this->typent_id)) {
-                $sql .= ",fk_typent = " . ($this->typent_id > 0 ? ((int)$this->typent_id) : "0");
+                $sql .= ",fk_typent = " . ($this->typent_id > 0 ? ((int) $this->typent_id) : "0");
             }
 
             $sql .= ",fk_forme_juridique = " . (!empty($this->forme_juridique_code) ? "'" . $this->db->escape($this->forme_juridique_code) . "'" : "null");
@@ -1979,7 +1979,7 @@ 
             $sql .= ",webservices_key = " . (!empty($this->webservices_key) ? "'" . $this->db->escape($this->webservices_key) . "'" : "null");
 
             //Incoterms
-            $sql .= ", fk_incoterms = " . ((int)$this->fk_incoterms);
+            $sql .= ", fk_incoterms = " . ((int) $this->fk_incoterms);
             $sql .= ", location_incoterms = " . (!empty($this->location_incoterms) ? "'" . $this->db->escape($this->location_incoterms) . "'" : "null");
 
             if ($customer) {
@@ -1990,10 +1990,10 @@ 
                 $sql .= ", code_fournisseur = " . (!empty($this->code_fournisseur) ? "'" . $this->db->escape($this->code_fournisseur) . "'" : "null");
             }
             $sql .= ", fk_user_modif = " . ($user->id > 0 ? $user->id : "null");
-            $sql .= ", fk_multicurrency = " . (int)$this->fk_multicurrency;
+            $sql .= ", fk_multicurrency = " . (int) $this->fk_multicurrency;
             $sql .= ", multicurrency_code = '" . $this->db->escape($this->multicurrency_code) . "'";
             $sql .= ", model_pdf = '" . $this->db->escape($this->model_pdf) . "'";
-            $sql .= " WHERE rowid = " . (int)$id;
+            $sql .= " WHERE rowid = " . (int) $id;
 
             $resql = $this->db->query($sql);
             if ($resql) {
@@ -2055,7 +2055,7 @@ 
 
                 // update accountancy for this entity
                 if (!$error && getDolGlobalString('MAIN_COMPANY_PERENTITY_SHARED')) {
-                    $this->db->query("DELETE FROM " . MAIN_DB_PREFIX . "societe_perentity WHERE fk_soc = " . ((int)$this->id) . " AND entity = " . ((int)$conf->entity));
+                    $this->db->query("DELETE FROM " . MAIN_DB_PREFIX . "societe_perentity WHERE fk_soc = " . ((int) $this->id) . " AND entity = " . ((int) $conf->entity));
 
                     $sql = "INSERT INTO " . MAIN_DB_PREFIX . "societe_perentity (";
                     $sql .= " fk_soc";
@@ -2260,7 +2260,7 @@ 
         }
         $sql .= ' FROM ' . MAIN_DB_PREFIX . 'societe as s';
         if (getDolGlobalString('MAIN_COMPANY_PERENTITY_SHARED')) {
-            $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "societe_perentity as spe ON spe.fk_soc = s.rowid AND spe.entity = " . ((int)$conf->entity);
+            $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "societe_perentity as spe ON spe.fk_soc = s.rowid AND spe.entity = " . ((int) $conf->entity);
         }
         $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_effectif as e ON s.fk_effectif = e.id';
         $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_country as c ON s.fk_pays = c.rowid';
@@ -2287,7 +2287,7 @@ 
         } // if both false, no test (the thirdparty can be client and/or supplier)
 
         if ($rowid) {
-            $sql .= ' AND s.rowid = ' . ((int)$rowid);
+            $sql .= ' AND s.rowid = ' . ((int) $rowid);
         }
         if ($ref) {
             $sql .= " AND s.nom = '" . $this->db->escape($ref) . "'";
@@ -2369,7 +2369,7 @@ 
                 $this->stcomm_picto = $obj->stcomm_picto; // picto statut commercial
 
                 $this->email = $obj->email;
-                $this->socialnetworks = ($obj->socialnetworks ? (array)json_decode($obj->socialnetworks, true) : array());
+                $this->socialnetworks = ($obj->socialnetworks ? (array) json_decode($obj->socialnetworks, true) : array());
 
                 $this->url = $obj->url;
                 $this->phone = $obj->phone;
@@ -2390,7 +2390,7 @@ 
                 $this->code_client = $obj->code_client;
                 $this->code_fournisseur = $obj->code_fournisseur;
 
-                $this->code_compta = $obj->code_compta;         // For backward compatibility
+                $this->code_compta = $obj->code_compta; // For backward compatibility
                 $this->code_compta_client = $obj->code_compta;
                 $this->code_compta_fournisseur = $obj->code_compta_fournisseur;
 
@@ -2524,7 +2524,7 @@ 
 
             if (!$error) {
                 $sql = "DELETE FROM  " . MAIN_DB_PREFIX . "societe_commerciaux";
-                $sql .= " WHERE fk_soc = " . ((int)$this->id) . " AND fk_user = " . ((int)$commid);
+                $sql .= " WHERE fk_soc = " . ((int) $this->id) . " AND fk_user = " . ((int) $commid);
 
                 $resql = $this->db->query($sql);
                 if (!$resql) {
@@ -2536,7 +2536,7 @@ 
             if (!$error) {
                 $sql = "INSERT INTO " . MAIN_DB_PREFIX . "societe_commerciaux";
                 $sql .= " (fk_soc, fk_user)";
-                $sql .= " VALUES (" . ((int)$this->id) . ", " . ((int)$commid) . ")";
+                $sql .= " VALUES (" . ((int) $this->id) . ", " . ((int) $commid) . ")";
 
                 $resql = $this->db->query($sql);
                 if (!$resql) {
@@ -2601,8 +2601,8 @@ 
             $now = dol_now();
 
             $sql = "UPDATE " . MAIN_DB_PREFIX . "societe";
-            $sql .= " SET price_level = " . ((int)$price_level);
-            $sql .= " WHERE rowid = " . ((int)$this->id);
+            $sql .= " SET price_level = " . ((int) $price_level);
+            $sql .= " WHERE rowid = " . ((int) $this->id);
 
             if (!$this->db->query($sql)) {
                 dol_print_error($this->db);
@@ -2611,7 +2611,7 @@ 
 
             $sql = "INSERT INTO " . MAIN_DB_PREFIX . "societe_prices";
             $sql .= " (datec, fk_soc, price_level, fk_user_author)";
-            $sql .= " VALUES ('" . $this->db->idate($now) . "', " . ((int)$this->id) . ", " . ((int)$price_level) . ", " . ((int)$user->id) . ")";
+            $sql .= " VALUES ('" . $this->db->idate($now) . "', " . ((int) $this->id) . ", " . ((int) $price_level) . ", " . ((int) $user->id) . ")";
 
             if (!$this->db->query($sql)) {
                 dol_print_error($this->db);
@@ -2667,7 +2667,7 @@ 
 
         $sql = "SELECT rowid, email, statut as status, phone_mobile, lastname, poste, firstname";
         $sql .= " FROM " . MAIN_DB_PREFIX . "socpeople";
-        $sql .= " WHERE fk_soc = " . ((int)$this->id);
+        $sql .= " WHERE fk_soc = " . ((int) $this->id);
         $sql .= " AND entity IN (" . getEntity($this->element) . ")";
         $sql .= " ORDER BY lastname, firstname";
 
@@ -2754,7 +2754,7 @@ 
         // phpcs:enable
         $contacts = array();
 
-        $sql = "SELECT rowid, lastname, firstname FROM " . MAIN_DB_PREFIX . "socpeople WHERE fk_soc = " . ((int)$this->id);
+        $sql = "SELECT rowid, lastname, firstname FROM " . MAIN_DB_PREFIX . "socpeople WHERE fk_soc = " . ((int) $this->id);
         $resql = $this->db->query($sql);
         if ($resql) {
             $nump = $this->db->num_rows($resql);
@@ -2784,7 +2784,7 @@ 
     {
         $contacts = array();
 
-        $sql = "SELECT rowid FROM " . MAIN_DB_PREFIX . "socpeople WHERE fk_soc = " . ((int)$this->id);
+        $sql = "SELECT rowid FROM " . MAIN_DB_PREFIX . "socpeople WHERE fk_soc = " . ((int) $this->id);
         $resql = $this->db->query($sql);
         if ($resql) {
             $nump = $this->db->num_rows($resql);
@@ -2824,7 +2824,7 @@ 
 
         $sql = "SELECT rowid, email, phone_mobile, lastname, firstname";
         $sql .= " FROM " . MAIN_DB_PREFIX . "socpeople";
-        $sql .= " WHERE rowid = " . ((int)$rowid);
+        $sql .= " WHERE rowid = " . ((int) $rowid);
 
         $resql = $this->db->query($sql);
         if ($resql) {
@@ -2894,7 +2894,7 @@ 
     public function get_all_rib()
     {
         // phpcs:enable
-        $sql = "SELECT rowid FROM " . MAIN_DB_PREFIX . "societe_rib WHERE type='ban' AND fk_soc = " . ((int)$this->id);
+        $sql = "SELECT rowid FROM " . MAIN_DB_PREFIX . "societe_rib WHERE type='ban' AND fk_soc = " . ((int) $this->id);
         $result = $this->db->query($sql);
         if (!$result) {
             $this->error++;
@@ -3020,7 +3020,7 @@ 
                 }
             }
 
-            $sql = 'UPDATE ' . MAIN_DB_PREFIX . 'societe SET parent = ' . ($id > 0 ? $id : 'null') . ' WHERE rowid = ' . ((int)$this->id);
+            $sql = 'UPDATE ' . MAIN_DB_PREFIX . 'societe SET parent = ' . ($id > 0 ? $id : 'null') . ' WHERE rowid = ' . ((int) $this->id);
 
             $resql = $this->db->query($sql);
             if ($resql) {
@@ -3052,7 +3052,7 @@ 
 
         $sql = 'SELECT s.parent';
         $sql .= ' FROM ' . MAIN_DB_PREFIX . 'societe as s';
-        $sql .= ' WHERE rowid = ' . ((int)$idparent);
+        $sql .= ' WHERE rowid = ' . ((int) $idparent);
         $resql = $this->db->query($sql);
         if ($resql) {
             $obj = $this->db->fetch_object($resql);
@@ -3085,7 +3085,7 @@ 
         global $langs;
 
         if ($company_id > 0) {
-            $sql = "SELECT parent FROM " . MAIN_DB_PREFIX . "societe WHERE rowid = " . ((int)$company_id);
+            $sql = "SELECT parent FROM " . MAIN_DB_PREFIX . "societe WHERE rowid = " . ((int) $company_id);
             $resql = $this->db->query($sql);
             if ($resql) {
                 if ($obj = $this->db->fetch_object($resql)) {
@@ -3231,7 +3231,7 @@ 
     public function has_projects()
     {
         // phpcs:enable
-        $sql = "SELECT COUNT(*) as numproj FROM " . MAIN_DB_PREFIX . "projet WHERE fk_soc = " . ((int)$this->id);
+        $sql = "SELECT COUNT(*) as numproj FROM " . MAIN_DB_PREFIX . "projet WHERE fk_soc = " . ((int) $this->id);
         $resql = $this->db->query($sql);
         if ($resql) {
             $obj = $this->db->fetch_object($resql);
@@ -3255,7 +3255,7 @@ 
         $sql = "SELECT s.rowid, s.nom as name, s.datec, tms as datem,";
         $sql .= " fk_user_creat, fk_user_modif";
         $sql .= " FROM " . MAIN_DB_PREFIX . "societe as s";
-        $sql .= " WHERE s.rowid = " . ((int)$id);
+        $sql .= " WHERE s.rowid = " . ((int) $id);
 
         $result = $this->db->query($sql);
         if ($result) {
@@ -3326,7 +3326,7 @@ 
         // phpcs:enable
         if ($categorie_id > 0 && $this->id > 0) {
             $sql = "INSERT INTO " . MAIN_DB_PREFIX . "categorie_fournisseur (fk_categorie, fk_soc) ";
-            $sql .= " VALUES (" . ((int)$categorie_id) . ", " . ((int)$this->id) . ")";
+            $sql .= " VALUES (" . ((int) $categorie_id) . ", " . ((int) $this->id) . ")";
 
             if ($resql = $this->db->query($sql)) {
                 return 0;
@@ -3446,8 +3446,8 @@ 
             }
 
             $sql = "UPDATE " . MAIN_DB_PREFIX . "adherent";
-            $sql .= " SET fk_soc = " . ((int)$this->id);
-            $sql .= " WHERE rowid = " . ((int)$member->id);
+            $sql .= " SET fk_soc = " . ((int) $this->id);
+            $sql .= " WHERE rowid = " . ((int) $member->id);
 
             $resql = $this->db->query($sql);
             if ($resql) {
@@ -3596,7 +3596,7 @@ 
         $country_code = $country_label = '';
         if (getDolGlobalString('MAIN_INFO_SOCIETE_COUNTRY')) {
             $tmp = explode(':', getDolGlobalString('MAIN_INFO_SOCIETE_COUNTRY'));
-            $country_id = (is_numeric($tmp[0])) ? (int)$tmp[0] : 0;
+            $country_id = (is_numeric($tmp[0])) ? (int) $tmp[0] : 0;
             if (!empty($tmp[1])) {   // If $conf->global->MAIN_INFO_SOCIETE_COUNTRY is "id:code:label"
                 $country_code = $tmp[1];
                 $country_label = $tmp[2];
@@ -3680,7 +3680,7 @@ 
         $this->idprof6 = getDolGlobalString('MAIN_INFO_PROFID6');
         $this->tva_intra = getDolGlobalString('MAIN_INFO_TVAINTRA'); // VAT number, not necessarily INTRA.
         $this->managers = getDolGlobalString('MAIN_INFO_SOCIETE_MANAGERS');
-        $this->capital = is_numeric(getDolGlobalString('MAIN_INFO_CAPITAL')) ? (float)price2num(getDolGlobalString('MAIN_INFO_CAPITAL')) : 0;
+        $this->capital = is_numeric(getDolGlobalString('MAIN_INFO_CAPITAL')) ? (float) price2num(getDolGlobalString('MAIN_INFO_CAPITAL')) : 0;
         $this->forme_juridique_code = getDolGlobalString('MAIN_INFO_SOCIETE_FORME_JURIDIQUE');
         $this->email = getDolGlobalString('MAIN_INFO_SOCIETE_MAIL');
         $this->default_lang = getDolGlobalString('MAIN_LANG_DEFAULT', 'auto');
@@ -3966,14 +3966,14 @@ 
         }
 
         $sql = "SELECT rowid, ref, total_ht, total_ttc, fk_statut as status FROM " . MAIN_DB_PREFIX . $table . " as f";
-        $sql .= " WHERE fk_soc = " . ((int)$this->id);
+        $sql .= " WHERE fk_soc = " . ((int) $this->id);
         if ($mode == 'supplier') {
             $sql .= " AND entity IN (" . getEntity('supplier_proposal') . ")";
         } else {
             $sql .= " AND entity IN (" . getEntity('propal') . ")";
         }
 
-        dol_syslog("getOutstandingProposals for fk_soc = " . ((int)$this->id), LOG_DEBUG);
+        dol_syslog("getOutstandingProposals for fk_soc = " . ((int) $this->id), LOG_DEBUG);
 
         $resql = $this->db->query($sql);
         if ($resql) {
@@ -4010,7 +4010,7 @@ 
         }
 
         $sql = "SELECT rowid, ref, total_ht, total_ttc, fk_statut as status FROM " . MAIN_DB_PREFIX . $table . " as f";
-        $sql .= " WHERE fk_soc = " . ((int)$this->id);
+        $sql .= " WHERE fk_soc = " . ((int) $this->id);
         if ($mode == 'supplier') {
             $sql .= " AND entity IN (" . getEntity('supplier_order') . ")";
         } else {
@@ -4061,7 +4061,7 @@ 
          $remaintopay=price2num($invoice->total_ttc - $paiement - $creditnotes - $deposits,'MT');
          */
         $sql = "SELECT rowid, ref, total_ht, total_ttc, paye, type, fk_statut as status, close_code FROM " . MAIN_DB_PREFIX . $table . " as f";
-        $sql .= " WHERE fk_soc = " . ((int)$this->id);
+        $sql .= " WHERE fk_soc = " . ((int) $this->id);
         if (!empty($late)) {
             $sql .= " AND date_lim_reglement < '" . $this->db->idate(dol_now()) . "'";
         }
@@ -4297,7 +4297,7 @@ 
             $sql .= " WHERE entity IN (0, " . $this->db->sanitize($conf->entity) . ")";
         }
 
-        $sql .= " AND u.rowid = sc.fk_user AND sc.fk_soc = " . ((int)$this->id);
+        $sql .= " AND u.rowid = sc.fk_user AND sc.fk_soc = " . ((int) $this->id);
         if (empty($sortfield) && empty($sortorder)) {
             $sortfield = 'u.lastname,u.firstname';
             $sortorder = 'ASC,ASC';
@@ -4317,10 +4317,10 @@ 
                     $reparray[$i]['firstname'] = $obj->firstname;
                     $reparray[$i]['email'] = $obj->email;
                     $reparray[$i]['phone'] = $obj->office_phone;
-                    $reparray[$i]['office_phone'] = $obj->office_phone;         // Pro phone
+                    $reparray[$i]['office_phone'] = $obj->office_phone; // Pro phone
                     $reparray[$i]['office_fax'] = $obj->office_fax;
-                    $reparray[$i]['user_mobile'] = $obj->user_mobile;           // Pro mobile
-                    $reparray[$i]['personal_mobile'] = $obj->personal_mobile;   // Personal mobile
+                    $reparray[$i]['user_mobile'] = $obj->user_mobile; // Pro mobile
+                    $reparray[$i]['personal_mobile'] = $obj->personal_mobile; // Personal mobile
                     $reparray[$i]['job'] = $obj->job;
                     $reparray[$i]['statut'] = $obj->status; // deprecated
                     $reparray[$i]['status'] = $obj->status;
@@ -4362,7 +4362,7 @@ 
 
         if ($this->id > 0 && $commid > 0) {
             $sql = "DELETE FROM  " . MAIN_DB_PREFIX . "societe_commerciaux ";
-            $sql .= " WHERE fk_soc = " . ((int)$this->id) . " AND fk_user = " . ((int)$commid);
+            $sql .= " WHERE fk_soc = " . ((int) $this->id) . " AND fk_user = " . ((int) $commid);
 
             if (!$this->db->query($sql)) {
                 $error++;
@@ -4428,7 +4428,7 @@ 
 
         $sql = "UPDATE " . MAIN_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(get_only_class($this) . "::" . __FUNCTION__, LOG_DEBUG);
         $resql = $this->db->query($sql);
@@ -4916,7 +4916,7 @@ 
         $sql .= " FROM " . $this->db->prefix() . "c_type_contact tc";
         $sql .= ", " . $this->db->prefix() . "societe_contacts sc";
         $sql .= " LEFT JOIN " . $this->db->prefix() . "socpeople t on sc.fk_socpeople = t.rowid";
-        $sql .= " WHERE sc.fk_soc = " . ((int)$this->id);
+        $sql .= " WHERE sc.fk_soc = " . ((int) $this->id);
         $sql .= " AND sc.fk_c_type_contact = tc.rowid";
         if (!empty($element)) {
             $sql .= " AND tc.element = '" . $this->db->escape($element) . "'";
@@ -4990,7 +4990,7 @@ 
         global $conf, $langs, $hookmanager, $user, $action;
 
         $error = 0;
-        $soc_origin = new Societe($this->db);       // The thirdparty that we will delete
+        $soc_origin = new Societe($this->db); // The thirdparty that we will delete
 
         dol_syslog("mergeCompany merge thirdparty id=" . $soc_origin_id . " (will be deleted) into the thirdparty id=" . $this->id);
 
@@ -5230,14 +5230,14 @@ 
         // Sales representationves cannot be twice in the same thirdparties so we look for them and remove the one that are common some to avoid duplicate.
         // Because this function is meant to be executed within a transaction, we won't take care of begin/commit.
         $sql = 'SELECT rowid FROM ' . MAIN_DB_PREFIX . 'societe_commerciaux ';
-        $sql .= ' WHERE fk_soc = ' . (int)$dest_id . ' AND fk_user IN ( ';
+        $sql .= ' WHERE fk_soc = ' . (int) $dest_id . ' AND fk_user IN ( ';
         $sql .= ' SELECT fk_user ';
         $sql .= ' FROM ' . MAIN_DB_PREFIX . 'societe_commerciaux ';
-        $sql .= ' WHERE fk_soc = ' . (int)$origin_id . ') ';
+        $sql .= ' WHERE fk_soc = ' . (int) $origin_id . ') ';
 
         $resql = $dbs->query($sql);
         while ($obj = $dbs->fetch_object($resql)) {
-            $dbs->query('DELETE FROM ' . MAIN_DB_PREFIX . 'societe_commerciaux WHERE rowid = ' . ((int)$obj->rowid));
+            $dbs->query('DELETE FROM ' . MAIN_DB_PREFIX . 'societe_commerciaux WHERE rowid = ' . ((int) $obj->rowid));
         }
 
         // llx_societe_extrafields table must not be here because we don't care about the old thirdparty extrafields that are managed directly into mergeCompany.
@@ -5330,7 +5330,7 @@ 
                         }
                     } else {
                         $sql = "DELETE FROM " . MAIN_DB_PREFIX . $tabletodelete;
-                        $sql .= " WHERE fk_soc = " . ((int)$id);
+                        $sql .= " WHERE fk_soc = " . ((int) $id);
                         if (!$this->db->query($sql)) {
                             $error++;
                             $this->errors[] = $this->db->lasterror();
@@ -5353,7 +5353,7 @@ 
             if (!$error) {
                 $sql = "UPDATE " . MAIN_DB_PREFIX . "societe";
                 $sql .= " SET parent = NULL";
-                $sql .= " WHERE parent = " . ((int)$id);
+                $sql .= " WHERE parent = " . ((int) $id);
                 if (!$this->db->query($sql)) {
                     $error++;
                     $this->errors[] = $this->db->lasterror();
@@ -5364,7 +5364,7 @@ 
             if (!$error) {
                 if (getDolGlobalString('MAIN_COMPANY_PERENTITY_SHARED')) {
                     $sql = "DELETE FROM " . MAIN_DB_PREFIX . "societe_perentity";
-                    $sql .= " WHERE fk_soc = " . ((int)$id);
+                    $sql .= " WHERE fk_soc = " . ((int) $id);
                     if (!$this->db->query($sql)) {
                         $error++;
                         $this->errors[] = $this->db->lasterror();
@@ -5372,7 +5372,7 @@ 
                 }
 
                 $sql = "DELETE FROM " . MAIN_DB_PREFIX . "societe";
-                $sql .= " WHERE rowid = " . ((int)$id);
+                $sql .= " WHERE rowid = " . ((int) $id);
                 if (!$this->db->query($sql)) {
                     $error++;
                     $this->errors[] = $this->db->lasterror();

Dolibarr/Core/Base/CommonObject.php

Spacing +246 added lines, -246 removed lines

@@ -416,11 +416,11 @@ 
     /**
      * @var float       Multicurrency total VAT amount (TVA = "Taxe sur la Valeur Ajoutée" in French)
      */
-    public $multicurrency_total_tva;  // Private to call DolDeprecationHandler
+    public $multicurrency_total_tva; // Private to call DolDeprecationHandler
     /**
      * @var float       Multicurrency total amount including taxes (TTC = "Toutes Taxes Comprises" in French)
      */
-    public $multicurrency_total_ttc;  // Internal value for deprecation
+    public $multicurrency_total_ttc; // Internal value for deprecation
     /**
      * @var float Multicurrency total localta1
      */
@@ -472,12 +472,12 @@ 
      * @var float       Total amount excluding taxes (HT = "Hors Taxe" in French)
      * @see update_price()
      */
-    public $total_ht;  // not in database
+    public $total_ht; // not in database
     /**
      * @var float       Total VAT amount (TVA = "Taxe sur la Valeur Ajoutée" in French)
      * @see update_price()
      */
-    public $total_tva;  // not in database
+    public $total_tva; // not in database
     /**
      * @var float       Total local tax 1 amount
      * @see update_price()
@@ -767,7 +767,7 @@ 
         $sql .= " WHERE entity IN (" . getEntity($element) . ")";
 
         if ($id > 0) {
-            $sql .= " AND rowid = " . ((int)$id);
+            $sql .= " AND rowid = " . ((int) $id);
         } elseif ($ref) {
             $sql .= " AND ref = '" . $db->escape($ref) . "'";
         } elseif ($ref_ext) {
@@ -778,7 +778,7 @@ 
             return -1;
         }
         if ($ref || $ref_ext) {     // Because the same ref can exists in 2 different entities, we force the current one in priority
-            $sql .= " AND entity = " . ((int)$conf->entity);
+            $sql .= " AND entity = " . ((int) $conf->entity);
         }
 
         dol_syslog(get_only_class($this) . "::isExistingObject", LOG_DEBUG);
@@ -814,7 +814,7 @@ 
 
         global $db;
 
-        $sql = "SELECT " . $field_select . " FROM " . $db->prefix() . $table_element . " WHERE " . $field_where . " = " . ((int)$fk_object_where);
+        $sql = "SELECT " . $field_select . " FROM " . $db->prefix() . $table_element . " WHERE " . $field_where . " = " . ((int) $fk_object_where);
         $resql = $db->query($sql);
 
         $TRes = array();
@@ -843,7 +843,7 @@ 
 
         global $db;
 
-        $sql = "SELECT COUNT(*) as nb FROM " . $db->prefix() . $table_element . " WHERE " . $field_where . " = " . ((int)$fk_object_where);
+        $sql = "SELECT COUNT(*) as nb FROM " . $db->prefix() . $table_element . " WHERE " . $field_where . " = " . ((int) $fk_object_where);
         $resql = $db->query($sql);
         $n = 0;
         if ($resql) {
@@ -872,7 +872,7 @@ 
 
         global $db;
 
-        $sql = "DELETE FROM " . $db->prefix() . $table_element . " WHERE " . $field_where . " = " . ((int)$fk_object_where);
+        $sql = "DELETE FROM " . $db->prefix() . $table_element . " WHERE " . $field_where . " = " . ((int) $fk_object_where);
         $resql = $db->query($sql);
 
         if (empty($resql)) {
@@ -897,7 +897,7 @@ 
     public static function commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors = 0)
     {
         foreach ($tables as $table) {
-            $sql = 'UPDATE ' . $dbs->prefix() . $table . ' SET fk_soc = ' . ((int)$dest_id) . ' WHERE fk_soc = ' . ((int)$origin_id);
+            $sql = 'UPDATE ' . $dbs->prefix() . $table . ' SET fk_soc = ' . ((int) $dest_id) . ' WHERE fk_soc = ' . ((int) $origin_id);
 
             if (!$dbs->query($sql)) {
                 if ($ignoreerrors) {
@@ -926,7 +926,7 @@ 
     public static function commonReplaceProduct(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors = 0)
     {
         foreach ($tables as $table) {
-            $sql = 'UPDATE ' . MAIN_DB_PREFIX . $table . ' SET fk_product = ' . ((int)$dest_id) . ' WHERE fk_product = ' . ((int)$origin_id);
+            $sql = 'UPDATE ' . MAIN_DB_PREFIX . $table . ' SET fk_product = ' . ((int) $dest_id) . ' WHERE fk_product = ' . ((int) $origin_id);
 
             if (!$dbs->query($sql)) {
                 if ($ignoreerrors) {
@@ -996,14 +996,14 @@ 
                 }
                 $enabled = 1;
                 if ($enabled && isset($extrafields->attributes[$this->table_element]['enabled'][$key])) {
-                    $enabled = (int)dol_eval($extrafields->attributes[$this->table_element]['enabled'][$key], 1, 1, '2');
+                    $enabled = (int) dol_eval($extrafields->attributes[$this->table_element]['enabled'][$key], 1, 1, '2');
                 }
                 if ($enabled && isset($extrafields->attributes[$this->table_element]['list'][$key])) {
-                    $enabled = (int)dol_eval($extrafields->attributes[$this->table_element]['list'][$key], 1, 1, '2');
+                    $enabled = (int) dol_eval($extrafields->attributes[$this->table_element]['list'][$key], 1, 1, '2');
                 }
                 $perms = 1;
                 if ($perms && isset($extrafields->attributes[$this->table_element]['perms'][$key])) {
-                    $perms = (int)dol_eval($extrafields->attributes[$this->table_element]['perms'][$key], 1, 1, '2');
+                    $perms = (int) dol_eval($extrafields->attributes[$this->table_element]['perms'][$key], 1, 1, '2');
                 }
                 if (empty($enabled)) {
                     continue; // 0 = Never visible field
@@ -1017,7 +1017,7 @@ 
                 if (!empty($extrafields->attributes[$this->table_element]['langfile'][$key])) {
                     $langs->load($extrafields->attributes[$this->table_element]['langfile'][$key]);
                 }
-                $labelextra = $langs->trans((string)$extrafields->attributes[$this->table_element]['label'][$key]);
+                $labelextra = $langs->trans((string) $extrafields->attributes[$this->table_element]['label'][$key]);
                 if ($extrafields->attributes[$this->table_element]['type'][$key] == 'separate') {
                     $data[$key] = '<br><b><u>' . $labelextra . '</u></b>';
                 } else {
@@ -1157,9 +1157,9 @@ 
             } elseif ($type == 'boolean') {
                 $morecss = '';
             } else {
-                if (is_numeric($size) && round((float)$size) < 12) {
+                if (is_numeric($size) && round((float) $size) < 12) {
                     $morecss = 'minwidth100';
-                } elseif (is_numeric($size) && round((float)$size) <= 48) {
+                } elseif (is_numeric($size) && round((float) $size) <= 48) {
                     $morecss = 'minwidth200';
                 } else {
                     $morecss = 'minwidth400';
@@ -1218,7 +1218,7 @@ 
                 $value = price($value, 0, $langs, 0, 0, -1, $conf->currency);
             }
         } elseif ($type == 'select') {
-            $value = isset($param['options'][(string)$value]) ? $param['options'][(string)$value] : '';
+            $value = isset($param['options'][(string) $value]) ? $param['options'][(string) $value] : '';
             if (strpos($value, "|") !== false) {
                 $value = $langs->trans(explode('|', $value)[0]);
             } elseif (!is_numeric($value)) {
@@ -1257,7 +1257,7 @@ 
             if ($selectkey == 'rowid' && empty($value)) {
                 $sql .= " WHERE " . $selectkey . " = 0";
             } elseif ($selectkey == 'rowid') {
-                $sql .= " WHERE " . $selectkey . " = " . ((int)$value);
+                $sql .= " WHERE " . $selectkey . " = " . ((int) $value);
             } else {
                 $sql .= " WHERE " . $selectkey . " = '" . $this->db->escape($value) . "'";
             }
@@ -1315,9 +1315,9 @@ 
                 dol_syslog(get_only_class($this) . '::showOutputField error ' . $this->db->lasterror(), LOG_WARNING);
             }
         } elseif ($type == 'radio') {
-            $value = $param['options'][(string)$value];
+            $value = $param['options'][(string) $value];
         } elseif ($type == 'checkbox') {
-            $value_arr = explode(',', (string)$value);
+            $value_arr = explode(',', (string) $value);
             $value = '';
             if (is_array($value_arr) && count($value_arr) > 0) {
                 $toprint = array();
@@ -1740,7 +1740,7 @@ 
         if ($source == 'external' || $source == 'thirdparty') { // external contact (socpeople)
             $sql .= " LEFT JOIN " . $this->db->prefix() . "socpeople t on ec.fk_socpeople = t.rowid";
         }
-        $sql .= " WHERE ec.element_id = " . ((int)$this->id);
+        $sql .= " WHERE ec.element_id = " . ((int) $this->id);
         $sql .= " AND ec.fk_c_type_contact = tc.rowid";
         $sql .= " AND tc.element = '" . $this->db->escape($this->element) . "'";
         if ($code) {
@@ -1749,18 +1749,18 @@ 
         if ($source == 'internal') {
             $sql .= " AND tc.source = 'internal'";
             if ($status >= 0) {
-                $sql .= " AND t.statut = " . ((int)$status);
+                $sql .= " AND t.statut = " . ((int) $status);
             }
         }
         if ($source == 'external' || $source == 'thirdparty') {
             $sql .= " AND tc.source = 'external'";
             if ($status >= 0) {
-                $sql .= " AND t.statut = " . ((int)$status); // t is llx_socpeople
+                $sql .= " AND t.statut = " . ((int) $status); // t is llx_socpeople
             }
         }
         $sql .= " AND tc.active = 1";
         if ($statusoflink >= 0) {
-            $sql .= " AND ec.statut = " . ((int)$statusoflink);
+            $sql .= " AND ec.statut = " . ((int) $statusoflink);
         }
         $sql .= " ORDER BY t.lastname ASC";
 
@@ -1888,9 +1888,9 @@ 
             // Insert into database
             $sql = "INSERT INTO " . $this->db->prefix() . "element_contact";
             $sql .= " (element_id, fk_socpeople, datecreate, statut, fk_c_type_contact) ";
-            $sql .= " VALUES (" . $this->id . ", " . ((int)$fk_socpeople) . " , ";
+            $sql .= " VALUES (" . $this->id . ", " . ((int) $fk_socpeople) . " , ";
             $sql .= "'" . $this->db->idate($datecreate) . "'";
-            $sql .= ", 4, " . ((int)$id_type_contact);
+            $sql .= ", 4, " . ((int) $id_type_contact);
             $sql .= ")";
 
             $resql = $this->db->query($sql);
@@ -1976,7 +1976,7 @@ 
 
         if (!$error && empty($notrigger)) {
             // Call trigger
-            $this->context['contact_id'] = ((int)$rowid);
+            $this->context['contact_id'] = ((int) $rowid);
             $result = $this->call_trigger(strtoupper($this->element) . '_DELETE_CONTACT', $user);
             if ($result < 0) {
                 $error++;
@@ -1988,7 +1988,7 @@ 
             dol_syslog(get_only_class($this) . "::delete_contact", LOG_DEBUG);
 
             $sql = "DELETE FROM " . MAIN_DB_PREFIX . "element_contact";
-            $sql .= " WHERE rowid = " . ((int)$rowid);
+            $sql .= " WHERE rowid = " . ((int) $rowid);
 
             $result = $this->db->query($sql);
             if (!$result) {
@@ -2037,7 +2037,7 @@ 
         }
 
         $sql = "DELETE FROM " . $this->db->prefix() . "element_contact";
-        $sql .= " WHERE element_id = " . ((int)$this->id);
+        $sql .= " WHERE element_id = " . ((int) $this->id);
         $sql .= " AND fk_c_type_contact IN (" . $this->db->sanitize($listId) . ")";
 
         dol_syslog(get_only_class($this) . "::delete_linked_contact", LOG_DEBUG);
@@ -2124,7 +2124,7 @@ 
         $sql = "SELECT ec.datecreate, ec.statut, ec.fk_socpeople, ec.fk_c_type_contact,";
         $sql .= " tc.code, tc.libelle as type_label";
         $sql .= " FROM (" . $this->db->prefix() . "element_contact as ec, " . $this->db->prefix() . "c_type_contact as tc)";
-        $sql .= " WHERE ec.rowid =" . ((int)$rowid);
+        $sql .= " WHERE ec.rowid =" . ((int) $rowid);
         $sql .= " AND ec.fk_c_type_contact = tc.rowid";
         $sql .= " AND tc.element = '" . $this->db->escape($this->element) . "'";
 
@@ -2161,12 +2161,12 @@ 
         $sql = "UPDATE " . $this->db->prefix() . "element_contact set";
         $sql .= " statut = " . $statut;
         if ($type_contact_id) {
-            $sql .= ", fk_c_type_contact = " . ((int)$type_contact_id);
+            $sql .= ", fk_c_type_contact = " . ((int) $type_contact_id);
         }
         if ($fk_socpeople) {
-            $sql .= ", fk_socpeople = " . ((int)$fk_socpeople);
+            $sql .= ", fk_socpeople = " . ((int) $fk_socpeople);
         }
-        $sql .= " where rowid = " . ((int)$rowid);
+        $sql .= " where rowid = " . ((int) $rowid);
         $resql = $this->db->query($sql);
         if ($resql) {
             return 0;
@@ -2300,7 +2300,7 @@ 
             $sql .= " " . $this->db->prefix() . "socpeople as c,";
         }
         $sql .= " " . $this->db->prefix() . "c_type_contact as tc";
-        $sql .= " WHERE ec.element_id = " . ((int)$id);
+        $sql .= " WHERE ec.element_id = " . ((int) $id);
         $sql .= " AND ec.fk_socpeople = c.rowid";
         if ($source == 'internal') {
             $sql .= " AND c.entity IN (" . getEntity('user') . ")";
@@ -2316,7 +2316,7 @@ 
         }
         $sql .= " AND tc.active = 1";
         if ($status) {
-            $sql .= " AND ec.statut = " . ((int)$status);
+            $sql .= " AND ec.statut = " . ((int) $status);
         }
 
         dol_syslog(get_only_class($this) . "::getIdContact", LOG_DEBUG);
@@ -2465,7 +2465,7 @@ 
             if (empty($this->barcode_type) || empty($this->barcode_type_code) || empty($this->barcode_type_label) || empty($this->barcode_type_coder)) {    // If data not already loaded
                 $sql = "SELECT rowid, code, libelle as label, coder";
                 $sql .= " FROM " . $this->db->prefix() . "c_barcode_type";
-                $sql .= " WHERE rowid = " . ((int)$idtype);
+                $sql .= " WHERE rowid = " . ((int) $idtype);
                 dol_syslog(get_only_class($this) . '::fetch_barcode', LOG_DEBUG);
                 $resql = $this->db->query($sql);
                 if ($resql) {
@@ -2584,7 +2584,7 @@ 
         if (!empty($element)) {
             $sql .= " AND entity IN (" . getEntity($element) . ")";
         } else {
-            $sql .= " AND entity = " . ((int)$conf->entity);
+            $sql .= " AND entity = " . ((int) $conf->entity);
         }
 
         dol_syslog(get_only_class($this) . '::fetchObjectFrom', LOG_DEBUG);
@@ -2620,7 +2620,7 @@ 
         $result = false;
         if (!empty($id) && !empty($field) && !empty($table)) {
             $sql = "SELECT " . $field . " FROM " . $this->db->prefix() . $table;
-            $sql .= " WHERE rowid = " . ((int)$id);
+            $sql .= " WHERE rowid = " . ((int) $id);
 
             dol_syslog(get_only_class($this) . '::getValueFrom', LOG_DEBUG);
             $resql = $this->db->query($sql);
@@ -2681,7 +2681,7 @@ 
         if ($trigkey) {
             $sql = "SELECT " . $field;
             $sql .= " FROM " . MAIN_DB_PREFIX . $table;
-            $sql .= " WHERE " . $id_field . " = " . ((int)$id);
+            $sql .= " WHERE " . $id_field . " = " . ((int) $id);
 
             $resql = $this->db->query($sql);
             if ($resql) {
@@ -2709,7 +2709,7 @@ 
         if ($format == 'text') {
             $sql .= $field . " = '" . $this->db->escape($value) . "'";
         } elseif ($format == 'int') {
-            $sql .= $field . " = " . ((int)$value);
+            $sql .= $field . " = " . ((int) $value);
         } elseif ($format == 'date') {
             $sql .= $field . " = " . ($value ? "'" . $this->db->idate($value) . "'" : "null");
         } elseif ($format == 'dategmt') {
@@ -2718,13 +2718,13 @@ 
 
         if ($fk_user_field) {
             if (!empty($fuser) && is_object($fuser)) {
-                $sql .= ", " . $fk_user_field . " = " . ((int)$fuser->id);
+                $sql .= ", " . $fk_user_field . " = " . ((int) $fuser->id);
             } elseif (empty($fuser) || $fuser != 'none') {
-                $sql .= ", " . $fk_user_field . " = " . ((int)$user->id);
+                $sql .= ", " . $fk_user_field . " = " . ((int) $user->id);
             }
         }
 
-        $sql .= " WHERE " . $id_field . " = " . ((int)$id);
+        $sql .= " WHERE " . $id_field . " = " . ((int) $id);
 
         $resql = $this->db->query($sql);
         if ($resql) {
@@ -2793,7 +2793,7 @@ 
         $sql .= " FROM " . $this->db->prefix() . $this->table_element . ' as t';
 
         if (!empty($id)) {
-            $sql .= ' WHERE t.rowid = ' . ((int)$id);
+            $sql .= ' WHERE t.rowid = ' . ((int) $id);
         } elseif (!empty($ref)) {
             $sql .= " WHERE t.ref = '" . $this->db->escape($ref) . "'";
         } else {
@@ -2880,17 +2880,17 @@ 
                 }
             } elseif ($this->isInt($info)) {
                 if ($field == 'rowid') {
-                    $this->id = (int)$obj->$field;
+                    $this->id = (int) $obj->$field;
                 } else {
                     if ($this->isForcedToNullIfZero($info)) {
                         if (empty($obj->$field)) {
                             $this->$field = null;
                         } else {
-                            $this->$field = (int)$obj->$field;
+                            $this->$field = (int) $obj->$field;
                         }
                     } else {
                         if (isset($obj->$field) && (!is_null($obj->$field) || (array_key_exists('notnull', $info) && $info['notnull'] == 1))) {
-                            $this->$field = (int)$obj->$field;
+                            $this->$field = (int) $obj->$field;
                         } else {
                             $this->$field = null;
                         }
@@ -2901,11 +2901,11 @@ 
                     if (empty($obj->$field)) {
                         $this->$field = null;
                     } else {
-                        $this->$field = (float)$obj->$field;
+                        $this->$field = (float) $obj->$field;
                     }
                 } else {
                     if (isset($obj->$field) && (!is_null($obj->$field) || (array_key_exists('notnull', $info) && $info['notnull'] == 1))) {
-                        $this->$field = (float)$obj->$field;
+                        $this->$field = (float) $obj->$field;
                     } else {
                         $this->$field = null;
                     }
@@ -2917,7 +2917,7 @@ 
 
         // If there is no 'ref' field, we force property ->ref to ->id for a better compatibility with common functions.
         if (!isset($this->fields['ref']) && isset($this->id)) {
-            $this->ref = (string)$this->id;
+            $this->ref = (string) $this->id;
         }
     }
 
@@ -3061,7 +3061,7 @@ 
                 }
             }
             $sql .= " FROM " . $this->db->prefix() . $table_element . "_extrafields";
-            $sql .= " WHERE fk_object = " . ((int)$rowid);
+            $sql .= " WHERE fk_object = " . ((int) $rowid);
 
             //dol_syslog(get_only_class($this)."::fetch_optionals get extrafields data for ".$this->table_element, LOG_DEBUG);       // Too verbose
             $resql = $this->db->query($sql);
@@ -3108,8 +3108,8 @@ 
                         if (!empty($extrafields->attributes[$this->table_element]) && !empty($extrafields->attributes[$this->table_element]['computed'][$key])) {
                             //var_dump($conf->disable_compute);
                             if (empty($conf->disable_compute)) {
-                                global $objectoffield;        // We set a global variable to $objectoffield so
-                                $objectoffield = $this;        // we can use it inside computed formula
+                                global $objectoffield; // We set a global variable to $objectoffield so
+                                $objectoffield = $this; // we can use it inside computed formula
                                 $this->array_options['options_' . $key] = dol_eval($extrafields->attributes[$this->table_element]['computed'][$key], 1, 0, '2');
                             }
                         }
@@ -3186,15 +3186,15 @@ 
             $sql .= " LEFT JOIN " . $this->db->prefix() . "societe_commerciaux as sc ON " . $aliastablesociete . ".rowid = sc.fk_soc";
         }
         if ($fieldid == 'rowid') {
-            $sql .= " WHERE te." . $fieldid . " < " . ((int)$this->id);
+            $sql .= " WHERE te." . $fieldid . " < " . ((int) $this->id);
         } else {
             $sql .= " WHERE te." . $fieldid . " < '" . $this->db->escape($this->ref) . "'"; // ->ref must always be defined (set to id if field does not exists)
         }
         if ($restrictiononfksoc == 1 && !$user->hasRight('societe', 'client', 'voir') && !$socid) {
-            $sql .= " AND sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND sc.fk_user = " . ((int) $user->id);
         }
         if ($restrictiononfksoc == 2 && !$user->hasRight('societe', 'client', 'voir') && !$socid) {
-            $sql .= " AND (sc.fk_user = " . ((int)$user->id) . ' OR te.fk_soc IS NULL)';
+            $sql .= " AND (sc.fk_user = " . ((int) $user->id) . ' OR te.fk_soc IS NULL)';
         }
 
         $filtermax = $filter;
@@ -3233,13 +3233,13 @@ 
             $sql .= ' AND parenttable.entity IN (' . getEntity($tmparray[1]) . ')';
         }
         if ($restrictiononfksoc == 1 && $socid && $this->element != 'societe') {
-            $sql .= ' AND te.fk_soc = ' . ((int)$socid);
+            $sql .= ' AND te.fk_soc = ' . ((int) $socid);
         }
         if ($restrictiononfksoc == 2 && $socid && $this->element != 'societe') {
-            $sql .= ' AND (te.fk_soc = ' . ((int)$socid) . ' OR te.fk_soc IS NULL)';
+            $sql .= ' AND (te.fk_soc = ' . ((int) $socid) . ' OR te.fk_soc IS NULL)';
         }
         if ($restrictiononfksoc && $socid && $this->element == 'societe') {
-            $sql .= ' AND te.rowid = ' . ((int)$socid);
+            $sql .= ' AND te.rowid = ' . ((int) $socid);
         }
         //print 'socid='.$socid.' restrictiononfksoc='.$restrictiononfksoc.' ismultientitymanaged = '.$this->ismultientitymanaged.' filter = '.$filter.' -> '.$sql."<br>";
 
@@ -3265,12 +3265,12 @@ 
             $sql .= " LEFT JOIN " . $this->db->prefix() . "societe_commerciaux as sc ON " . $aliastablesociete . ".rowid = sc.fk_soc";
         }
         if ($fieldid == 'rowid') {
-            $sql .= " WHERE te." . $fieldid . " > " . ((int)$this->id);
+            $sql .= " WHERE te." . $fieldid . " > " . ((int) $this->id);
         } else {
             $sql .= " WHERE te." . $fieldid . " > '" . $this->db->escape($this->ref) . "'"; // ->ref must always be defined (set to id if field does not exists)
         }
         if ($restrictiononfksoc == 1 && !$user->hasRight('societe', 'client', 'voir') && !$socid) {
-            $sql .= " AND (sc.fk_user = " . ((int)$user->id);
+            $sql .= " AND (sc.fk_user = " . ((int) $user->id);
             if (getDolGlobalInt('MAIN_SEE_SUBORDINATES')) {
                 $userschilds = $user->getAllChildIds();
                 $sql .= " OR sc.fk_user IN (" . $this->db->sanitize(implode(',', $userschilds)) . ")";
@@ -3278,7 +3278,7 @@ 
             $sql .= ')';
         }
         if ($restrictiononfksoc == 2 && !$user->hasRight('societe', 'client', 'voir') && !$socid) {
-            $sql .= " AND (sc.fk_user = " . ((int)$user->id) . ' OR te.fk_soc IS NULL)';
+            $sql .= " AND (sc.fk_user = " . ((int) $user->id) . ' OR te.fk_soc IS NULL)';
         }
 
         $filtermin = $filter;
@@ -3319,13 +3319,13 @@ 
             $sql .= ' AND parenttable.entity IN (' . getEntity($tmparray[1]) . ')';
         }
         if ($restrictiononfksoc == 1 && $socid && $this->element != 'societe') {
-            $sql .= ' AND te.fk_soc = ' . ((int)$socid);
+            $sql .= ' AND te.fk_soc = ' . ((int) $socid);
         }
         if ($restrictiononfksoc == 2 && $socid && $this->element != 'societe') {
-            $sql .= ' AND (te.fk_soc = ' . ((int)$socid) . ' OR te.fk_soc IS NULL)';
+            $sql .= ' AND (te.fk_soc = ' . ((int) $socid) . ' OR te.fk_soc IS NULL)';
         }
         if ($restrictiononfksoc && $socid && $this->element == 'societe') {
-            $sql .= ' AND te.rowid = ' . ((int)$socid);
+            $sql .= ' AND te.rowid = ' . ((int) $socid);
         }
         //print 'socid='.$socid.' restrictiononfksoc='.$restrictiononfksoc.' ismultientitymanaged = '.$this->ismultientitymanaged.' filter = '.$filter.' -> '.$sql."<br>";
         // Rem: Bug in some mysql version: SELECT MIN(rowid) FROM llx_socpeople WHERE rowid > 1 when one row in database with rowid=1, returns 1 instead of null
@@ -3390,32 +3390,32 @@ 
         $sql = "UPDATE " . $this->db->prefix() . $this->table_element;
         if (!empty($this->fields['fk_project'])) {      // Common case
             if ($projectid) {
-                $sql .= " SET fk_project = " . ((int)$projectid);
+                $sql .= " SET fk_project = " . ((int) $projectid);
             } else {
                 $sql .= " SET fk_project = NULL";
             }
-            $sql .= ' WHERE rowid = ' . ((int)$this->id);
+            $sql .= ' WHERE rowid = ' . ((int) $this->id);
         } elseif ($this->table_element == 'actioncomm') {   // Special case for actioncomm
             if ($projectid) {
-                $sql .= " SET fk_project = " . ((int)$projectid);
+                $sql .= " SET fk_project = " . ((int) $projectid);
             } else {
                 $sql .= " SET fk_project = NULL";
             }
-            $sql .= ' WHERE id = ' . ((int)$this->id);
+            $sql .= ' WHERE id = ' . ((int) $this->id);
         } else { // Special case for old architecture objects
             if ($projectid) {
-                $sql .= ' SET fk_projet = ' . ((int)$projectid);
+                $sql .= ' SET fk_projet = ' . ((int) $projectid);
             } else {
                 $sql .= ' SET fk_projet = NULL';
             }
-            $sql .= " WHERE rowid = " . ((int)$this->id);
+            $sql .= " WHERE rowid = " . ((int) $this->id);
         }
 
         $this->db->begin();
 
         dol_syslog(get_only_class($this) . "::setProject", LOG_DEBUG);
         if ($this->db->query($sql)) {
-            $this->fk_project = ((int)$projectid);
+            $this->fk_project = ((int) $projectid);
         } else {
             dol_print_error($this->db);
             $error++;
@@ -3475,8 +3475,8 @@ 
             }
 
             $sql = "UPDATE " . $this->db->prefix() . $this->table_element;
-            $sql .= " SET " . $fieldname . " = " . (($id > 0 || $id == '0') ? ((int)$id) : 'NULL');
-            $sql .= ' WHERE rowid=' . ((int)$this->id);
+            $sql .= " SET " . $fieldname . " = " . (($id > 0 || $id == '0') ? ((int) $id) : 'NULL');
+            $sql .= ' WHERE rowid=' . ((int) $this->id);
 
             if ($this->db->query($sql)) {
                 $this->mode_reglement_id = $id;
@@ -3526,7 +3526,7 @@ 
 
             $sql = 'UPDATE ' . $this->db->prefix() . $this->table_element;
             $sql .= " SET " . $fieldname . " = '" . $this->db->escape($code) . "'";
-            $sql .= ' WHERE rowid=' . ((int)$this->id);
+            $sql .= ' WHERE rowid=' . ((int) $this->id);
 
             if ($this->db->query($sql)) {
                 $this->multicurrency_code = $code;
@@ -3563,8 +3563,8 @@ 
             $fieldname = 'multicurrency_tx';
 
             $sql = 'UPDATE ' . $this->db->prefix() . $this->table_element;
-            $sql .= " SET " . $fieldname . " = " . ((float)$rate);
-            $sql .= ' WHERE rowid=' . ((int)$this->id);
+            $sql .= " SET " . $fieldname . " = " . ((float) $rate);
+            $sql .= ' WHERE rowid=' . ((int) $this->id);
 
             if ($this->db->query($sql)) {
                 $this->multicurrency_tx = $rate;
@@ -3786,7 +3786,7 @@ 
             }
 
             if (empty($deposit_percent) || $deposit_percent < 0) {
-                $deposit_percent = (float)getDictionaryValue('c_payment_term', 'deposit_percent', $id);
+                $deposit_percent = (float) getDictionaryValue('c_payment_term', 'deposit_percent', $id);
             }
 
             if ($deposit_percent > 100) {
@@ -3794,11 +3794,11 @@ 
             }
 
             $sql = 'UPDATE ' . $this->db->prefix() . $this->table_element;
-            $sql .= " SET " . $fieldname . " = " . (($id > 0 || $id == '0') ? ((int)$id) : 'NULL');
+            $sql .= " SET " . $fieldname . " = " . (($id > 0 || $id == '0') ? ((int) $id) : 'NULL');
             if (in_array($this->table_element, array('propal', 'commande', 'societe'))) {
                 $sql .= " , deposit_percent = " . (empty($deposit_percent) ? 'NULL' : "'" . $this->db->escape($deposit_percent) . "'");
             }
-            $sql .= ' WHERE rowid=' . ((int)$this->id);
+            $sql .= ' WHERE rowid=' . ((int) $this->id);
 
             if ($this->db->query($sql)) {
                 $this->cond_reglement_id = $id;
@@ -3840,8 +3840,8 @@ 
             }
 
             $sql = 'UPDATE ' . $this->db->prefix() . $this->table_element;
-            $sql .= " SET " . $fieldname . " = " . (($id > 0 || $id == '0') ? ((int)$id) : 'NULL');
-            $sql .= ' WHERE rowid=' . ((int)$this->id);
+            $sql .= " SET " . $fieldname . " = " . (($id > 0 || $id == '0') ? ((int) $id) : 'NULL');
+            $sql .= ' WHERE rowid=' . ((int) $this->id);
 
             if ($this->db->query($sql)) {
                 $this->transport_mode_id = $id;
@@ -3875,8 +3875,8 @@ 
             $fieldname = 'retained_warranty_fk_cond_reglement';
 
             $sql = 'UPDATE ' . $this->db->prefix() . $this->table_element;
-            $sql .= " SET " . $fieldname . " = " . ((int)$id);
-            $sql .= ' WHERE rowid=' . ((int)$this->id);
+            $sql .= " SET " . $fieldname . " = " . ((int) $id);
+            $sql .= ' WHERE rowid=' . ((int) $this->id);
 
             if ($this->db->query($sql)) {
                 $this->retained_warranty_fk_cond_reglement = $id;
@@ -3907,8 +3907,8 @@ 
             $fieldname = 'fk_address';
         }
 
-        $sql = "UPDATE " . $this->db->prefix() . $this->table_element . " SET " . $fieldname . " = " . ((int)$id);
-        $sql .= " WHERE rowid = " . ((int)$this->id) . " AND fk_statut = 0";
+        $sql = "UPDATE " . $this->db->prefix() . $this->table_element . " SET " . $fieldname . " = " . ((int) $id);
+        $sql .= " WHERE rowid = " . ((int) $this->id) . " AND fk_statut = 0";
 
         if ($this->db->query($sql)) {
             $this->fk_delivery_address = $id;
@@ -3951,8 +3951,8 @@ 
         dol_syslog(get_only_class($this) . '::setShippingMethod(' . $shipping_method_id . ')');
 
         $sql = "UPDATE " . $this->db->prefix() . $this->table_element;
-        $sql .= " SET fk_shipping_method = " . ((int)$shipping_method_id);
-        $sql .= " WHERE rowid=" . ((int)$this->id);
+        $sql .= " SET fk_shipping_method = " . ((int) $shipping_method_id);
+        $sql .= " WHERE rowid=" . ((int) $this->id);
         $resql = $this->db->query($sql);
         if (!$resql) {
             dol_syslog(get_only_class($this) . '::setShippingMethod Error ', LOG_DEBUG);
@@ -3999,8 +3999,8 @@ 
         dol_syslog(get_only_class($this) . '::setWarehouse(' . $warehouse_id . ')');
 
         $sql = "UPDATE " . $this->db->prefix() . $this->table_element;
-        $sql .= " SET fk_warehouse = " . ((int)$warehouse_id);
-        $sql .= " WHERE rowid=" . ((int)$this->id);
+        $sql .= " SET fk_warehouse = " . ((int) $warehouse_id);
+        $sql .= " WHERE rowid=" . ((int) $this->id);
 
         if ($this->db->query($sql)) {
             $this->warehouse_id = ($warehouse_id == 'NULL') ? null : $warehouse_id;
@@ -4032,7 +4032,7 @@ 
 
         $sql = "UPDATE " . $this->db->prefix() . $this->table_element;
         $sql .= " SET model_pdf = '" . $this->db->escape($newmodelpdf) . "'";
-        $sql .= " WHERE rowid = " . ((int)$this->id);
+        $sql .= " WHERE rowid = " . ((int) $this->id);
 
         dol_syslog(get_only_class($this) . "::setDocModel", LOG_DEBUG);
         $resql = $this->db->query($sql);
@@ -4077,8 +4077,8 @@ 
         dol_syslog(get_only_class($this) . '::setBankAccount(' . $fk_account . ')');
 
         $sql = "UPDATE " . $this->db->prefix() . $this->table_element;
-        $sql .= " SET fk_account = " . ((int)$fk_account);
-        $sql .= " WHERE rowid=" . ((int)$this->id);
+        $sql .= " SET fk_account = " . ((int) $fk_account);
+        $sql .= " WHERE rowid=" . ((int) $this->id);
 
         $resql = $this->db->query($sql);
         if (!$resql) {
@@ -4163,7 +4163,7 @@ 
         // Count number of lines to reorder (according to choice $renum)
         $nl = 0;
         $sql = "SELECT count(rowid) FROM " . $this->db->prefix() . $this->table_element_line;
-        $sql .= " WHERE " . $this->fk_element . " = " . ((int)$this->id);
+        $sql .= " WHERE " . $this->fk_element . " = " . ((int) $this->id);
         if (!$renum) {
             $sql .= " AND " . $fieldposition . " = 0";
         }
@@ -4185,7 +4185,7 @@ 
 
             // We first search all lines that are parent lines (for multilevel details lines)
             $sql = "SELECT rowid FROM " . $this->db->prefix() . $this->table_element_line;
-            $sql .= " WHERE " . $this->fk_element . " = " . ((int)$this->id);
+            $sql .= " WHERE " . $this->fk_element . " = " . ((int) $this->id);
             if ($fk_parent_line) {
                 $sql .= ' AND fk_parent_line IS NULL';
             }
@@ -4240,8 +4240,8 @@ 
         $rows = array();
 
         $sql = "SELECT rowid FROM " . $this->db->prefix() . $this->table_element_line;
-        $sql .= " WHERE " . $this->fk_element . " = " . ((int)$this->id);
-        $sql .= ' AND fk_parent_line = ' . ((int)$id);
+        $sql .= " WHERE " . $this->fk_element . " = " . ((int) $this->id);
+        $sql .= ' AND fk_parent_line = ' . ((int) $id);
         $sql .= " ORDER BY " . $fieldposition . " ASC";
 
         dol_syslog(get_only_class($this) . "::getChildrenOfLine search children lines for line " . $id, LOG_DEBUG);
@@ -4274,8 +4274,8 @@ 
             $fieldposition = 'position';
         }
 
-        $sql = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldposition . " = " . ((int)$rang);
-        $sql .= ' WHERE rowid = ' . ((int)$rowid);
+        $sql = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldposition . " = " . ((int) $rang);
+        $sql .= ' WHERE rowid = ' . ((int) $rowid);
 
         dol_syslog(get_only_class($this) . "::updateRangOfLine", LOG_DEBUG);
         if (!$this->db->query($sql)) {
@@ -4303,7 +4303,7 @@ 
         }
 
         $sql = "SELECT " . $fieldposition . " FROM " . $this->db->prefix() . $this->table_element_line;
-        $sql .= " WHERE rowid = " . ((int)$rowid);
+        $sql .= " WHERE rowid = " . ((int) $rowid);
 
         dol_syslog(get_only_class($this) . "::getRangOfLine", LOG_DEBUG);
         $resql = $this->db->query($sql);
@@ -4330,12 +4330,12 @@ 
                 $fieldposition = 'position';
             }
 
-            $sql = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldposition . " = " . ((int)$rang);
-            $sql .= " WHERE " . $this->fk_element . " = " . ((int)$this->id);
-            $sql .= " AND " . $fieldposition . " = " . ((int)($rang - 1));
+            $sql = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldposition . " = " . ((int) $rang);
+            $sql .= " WHERE " . $this->fk_element . " = " . ((int) $this->id);
+            $sql .= " AND " . $fieldposition . " = " . ((int) ($rang - 1));
             if ($this->db->query($sql)) {
-                $sql = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldposition . " = " . ((int)($rang - 1));
-                $sql .= ' WHERE rowid = ' . ((int)$rowid);
+                $sql = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldposition . " = " . ((int) ($rang - 1));
+                $sql .= ' WHERE rowid = ' . ((int) $rowid);
                 if (!$this->db->query($sql)) {
                     dol_print_error($this->db);
                 }
@@ -4384,8 +4384,8 @@ 
         // Search the last rang with fk_parent_line
         if ($fk_parent_line) {
             $sql = "SELECT max(" . $positionfield . ") FROM " . $this->db->prefix() . $this->table_element_line;
-            $sql .= " WHERE " . $this->fk_element . " = " . ((int)$this->id);
-            $sql .= " AND fk_parent_line = " . ((int)$fk_parent_line);
+            $sql .= " WHERE " . $this->fk_element . " = " . ((int) $this->id);
+            $sql .= " AND fk_parent_line = " . ((int) $fk_parent_line);
 
             dol_syslog(get_only_class($this) . "::line_max", LOG_DEBUG);
             $resql = $this->db->query($sql);
@@ -4400,7 +4400,7 @@ 
         } else {
             // If not, search the last rang of element
             $sql = "SELECT max(" . $positionfield . ") FROM " . $this->db->prefix() . $this->table_element_line;
-            $sql .= " WHERE " . $this->fk_element . " = " . ((int)$this->id);
+            $sql .= " WHERE " . $this->fk_element . " = " . ((int) $this->id);
 
             dol_syslog(get_only_class($this) . "::line_max", LOG_DEBUG);
             $resql = $this->db->query($sql);
@@ -4429,12 +4429,12 @@ 
                 $fieldposition = 'position';
             }
 
-            $sql = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldposition . " = " . ((int)$rang);
-            $sql .= " WHERE " . $this->fk_element . " = " . ((int)$this->id);
-            $sql .= " AND " . $fieldposition . " = " . ((int)($rang + 1));
+            $sql = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldposition . " = " . ((int) $rang);
+            $sql .= " WHERE " . $this->fk_element . " = " . ((int) $this->id);
+            $sql .= " AND " . $fieldposition . " = " . ((int) ($rang + 1));
             if ($this->db->query($sql)) {
-                $sql = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldposition . " = " . ((int)($rang + 1));
-                $sql .= ' WHERE rowid = ' . ((int)$rowid);
+                $sql = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldposition . " = " . ((int) ($rang + 1));
+                $sql .= ' WHERE rowid = ' . ((int) $rowid);
                 if (!$this->db->query($sql)) {
                     dol_print_error($this->db);
                 }
@@ -4473,8 +4473,8 @@ 
         }
 
         $sql = "SELECT rowid FROM " . $this->db->prefix() . $this->table_element_line;
-        $sql .= " WHERE " . $this->fk_element . " = " . ((int)$this->id);
-        $sql .= " AND " . $fieldposition . " = " . ((int)$rang);
+        $sql .= " WHERE " . $this->fk_element . " = " . ((int) $this->id);
+        $sql .= " AND " . $fieldposition . " = " . ((int) $rang);
         $resql = $this->db->query($sql);
         if ($resql) {
             $row = $this->db->fetch_row($resql);
@@ -4500,7 +4500,7 @@ 
 
         $sql = "UPDATE " . $this->db->prefix() . $this->table_element;
         $sql .= " SET ref_ext = '" . $this->db->escape($ref_ext) . "'";
-        $sql .= " WHERE " . (isset($this->table_rowid) ? $this->table_rowid : 'rowid') . " = " . ((int)$this->id);
+        $sql .= " WHERE " . (isset($this->table_rowid) ? $this->table_rowid : 'rowid') . " = " . ((int) $this->id);
 
         dol_syslog(get_only_class($this) . "::update_ref_ext", LOG_DEBUG);
         if ($this->db->query($sql)) {
@@ -4565,8 +4565,8 @@ 
         }
         $sql = "UPDATE " . $this->db->prefix() . $this->table_element;
         $sql .= " SET note" . $newsuffix . " = " . (!empty($note) ? ("'" . $this->db->escape($note) . "'") : "NULL");
-        $sql .= ", " . $fieldusermod . " = " . ((int)$user->id);
-        $sql .= " WHERE rowid = " . ((int)$this->id);
+        $sql .= ", " . $fieldusermod . " = " . ((int) $user->id);
+        $sql .= " WHERE rowid = " . ((int) $this->id);
 
         dol_syslog(get_only_class($this) . "::update_note", LOG_DEBUG);
         if ($this->db->query($sql)) {
@@ -4709,7 +4709,7 @@ 
         }
         $sql .= ', multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc';
         $sql .= " FROM " . $this->db->prefix() . $this->table_element_line;
-        $sql .= " WHERE " . $this->fk_element . " = " . ((int)$this->id);
+        $sql .= " WHERE " . $this->fk_element . " = " . ((int) $this->id);
         if ($exclspec) {
             $product_field = 'product_type';
             if ($this->table_element_line == 'contratdet') {
@@ -4760,7 +4760,7 @@ 
 
                     if ($diff_on_current_total) {
                         // This should not happen, we should always have in table: total_ttc = total_ht + total_vat + total_localtax1 + total_localtax2
-                        $sqlfix = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldtva . " = " . price2num((float)$tmpcal[1]) . ", total_ttc = " . price2num((float)$tmpcal[2]) . " WHERE rowid = " . ((int)$obj->rowid);
+                        $sqlfix = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldtva . " = " . price2num((float) $tmpcal[1]) . ", total_ttc = " . price2num((float) $tmpcal[2]) . " WHERE rowid = " . ((int) $obj->rowid);
                         dol_syslog('We found inconsistent data into detailed line (diff_on_current_total = ' . $diff_on_current_total . ') for line rowid = ' . $obj->rowid . " (ht=" . $obj->total_ht . " vat=" . $obj->total_tva . " tax1=" . $obj->total_localtax1 . " tax2=" . $obj->total_localtax2 . " ttc=" . $obj->total_ttc . "). We fix the total_vat and total_ttc of line by running sqlfix = " . $sqlfix, LOG_WARNING);
                         $resqlfix = $this->db->query($sqlfix);
                         if (!$resqlfix) {
@@ -4771,7 +4771,7 @@ 
                     } elseif ($diff_when_using_price_ht) {
                         // After calculation from HT, total is consistent but we have found a difference between VAT part in calculation and into database and
                         // we ask to force the use of rounding on line (like done on calculation) so we force update of line
-                        $sqlfix = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldtva . " = " . price2num((float)$tmpcal[1]) . ", total_ttc = " . price2num((float)$tmpcal[2]) . " WHERE rowid = " . ((int)$obj->rowid);
+                        $sqlfix = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldtva . " = " . price2num((float) $tmpcal[1]) . ", total_ttc = " . price2num((float) $tmpcal[2]) . " WHERE rowid = " . ((int) $obj->rowid);
                         dol_syslog('We found a line with different rounding data into detailed line (diff_when_using_price_ht = ' . $diff_when_using_price_ht . ' and diff_on_current_total = ' . $diff_on_current_total . ') for line rowid = ' . $obj->rowid . " (total vat of line calculated=" . $tmpcal[1] . ", database=" . $obj->total_tva . "). We fix the total_vat and total_ttc of line by running sqlfix = " . $sqlfix);
                         $resqlfix = $this->db->query($sqlfix);
                         if (!$resqlfix) {
@@ -4810,10 +4810,10 @@ 
                     } else {
                         $tmpvat = price2num($total_ht_by_vats[$obj->vatrate] * $obj->vatrate / 100, 'MT', 1);
                     }
-                    $diff = price2num($total_tva_by_vats[$obj->vatrate] - (float)$tmpvat, 'MT', 1);
+                    $diff = price2num($total_tva_by_vats[$obj->vatrate] - (float) $tmpvat, 'MT', 1);
                     //print 'Line '.$i.' rowid='.$obj->rowid.' vat_rate='.$obj->vatrate.' total_ht='.$obj->total_ht.' total_tva='.$obj->total_tva.' total_ttc='.$obj->total_ttc.' total_ht_by_vats='.$total_ht_by_vats[$obj->vatrate].' total_tva_by_vats='.$total_tva_by_vats[$obj->vatrate].' (new calculation = '.$tmpvat.') total_ttc_by_vats='.$total_ttc_by_vats[$obj->vatrate].($diff?" => DIFF":"")."<br>\n";
                     if ($diff) {
-                        if (abs((float)$diff) > (10 * pow(10, -1 * getDolGlobalInt('MAIN_MAX_DECIMALS_TOT', 0)))) {
+                        if (abs((float) $diff) > (10 * pow(10, -1 * getDolGlobalInt('MAIN_MAX_DECIMALS_TOT', 0)))) {
                             // If error is more than 10 times the accuracy of rounding. This should not happen.
                             $errmsg = 'A rounding difference was detected into TOTAL but is too high to be corrected. Some data in your lines may be corrupted. Try to edit each line manually to fix this before restarting.';
                             dol_syslog($errmsg, LOG_WARNING);
@@ -4822,10 +4822,10 @@ 
                             break;
                         }
                         if ($base_price_type == 'TTC') {
-                            $sqlfix = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldtva . " = " . price2num($obj->total_tva - (float)$diff) . ", total_ht = " . price2num($obj->total_ht + (float)$diff) . " WHERE rowid = " . ((int)$obj->rowid);
+                            $sqlfix = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldtva . " = " . price2num($obj->total_tva - (float) $diff) . ", total_ht = " . price2num($obj->total_ht + (float) $diff) . " WHERE rowid = " . ((int) $obj->rowid);
                             dol_syslog('We found a difference of ' . $diff . ' for line rowid = ' . $obj->rowid . ". We fix the total_vat and total_ht of line by running sqlfix = " . $sqlfix);
                         } else {
-                            $sqlfix = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldtva . " = " . price2num($obj->total_tva - (float)$diff) . ", total_ttc = " . price2num($obj->total_ttc - (float)$diff) . " WHERE rowid = " . ((int)$obj->rowid);
+                            $sqlfix = "UPDATE " . $this->db->prefix() . $this->table_element_line . " SET " . $fieldtva . " = " . price2num($obj->total_tva - (float) $diff) . ", total_ttc = " . price2num($obj->total_ttc - (float) $diff) . " WHERE rowid = " . ((int) $obj->rowid);
                             dol_syslog('We found a difference of ' . $diff . ' for line rowid = ' . $obj->rowid . ". We fix the total_vat and total_ttc of line by running sqlfix = " . $sqlfix);
                         }
 
@@ -4835,14 +4835,14 @@ 
                             dol_print_error($this->db, 'Failed to update line');
                         }
 
-                        $this->total_tva = (float)price2num($this->total_tva - (float)$diff, '', 1);
-                        $total_tva_by_vats[$obj->vatrate] = (float)price2num($total_tva_by_vats[$obj->vatrate] - (float)$diff, '', 1);
+                        $this->total_tva = (float) price2num($this->total_tva - (float) $diff, '', 1);
+                        $total_tva_by_vats[$obj->vatrate] = (float) price2num($total_tva_by_vats[$obj->vatrate] - (float) $diff, '', 1);
                         if ($base_price_type == 'TTC') {
-                            $this->total_ht = (float)price2num($this->total_ht + (float)$diff, '', 1);
-                            $total_ht_by_vats[$obj->vatrate] = (float)price2num($total_ht_by_vats[$obj->vatrate] + (float)$diff, '', 1);
+                            $this->total_ht = (float) price2num($this->total_ht + (float) $diff, '', 1);
+                            $total_ht_by_vats[$obj->vatrate] = (float) price2num($total_ht_by_vats[$obj->vatrate] + (float) $diff, '', 1);
                         } else {
-                            $this->total_ttc = (float)price2num($this->total_ttc - (float)$diff, '', 1);
-                            $total_ttc_by_vats[$obj->vatrate] = (float)price2num($total_ttc_by_vats[$obj->vatrate] - (float)$diff, '', 1);
+                            $this->total_ttc = (float) price2num($this->total_ttc - (float) $diff, '', 1);
+                            $total_ttc_by_vats[$obj->vatrate] = (float) price2num($total_ttc_by_vats[$obj->vatrate] - (float) $diff, '', 1);
                         }
                     }
                 }
@@ -4875,11 +4875,11 @@ 
             }
 
             // Clean total
-            $this->total_ht = (float)price2num($this->total_ht);
-            $this->total_tva = (float)price2num($this->total_tva);
-            $this->total_localtax1 = (float)price2num($this->total_localtax1);
-            $this->total_localtax2 = (float)price2num($this->total_localtax2);
-            $this->total_ttc = (float)price2num($this->total_ttc);
+            $this->total_ht = (float) price2num($this->total_ht);
+            $this->total_tva = (float) price2num($this->total_tva);
+            $this->total_localtax1 = (float) price2num($this->total_localtax1);
+            $this->total_localtax2 = (float) price2num($this->total_localtax2);
+            $this->total_ttc = (float) price2num($this->total_ttc);
 
             $this->db->free($resql);
 
@@ -4896,15 +4896,15 @@ 
 
             if (!$error && empty($nodatabaseupdate)) {
                 $sql = "UPDATE " . $this->db->prefix() . $this->table_element . ' SET';
-                $sql .= " " . $fieldht . " = " . ((float)price2num($this->total_ht, 'MT', 1)) . ",";
-                $sql .= " " . $fieldtva . " = " . ((float)price2num($this->total_tva, 'MT', 1)) . ",";
-                $sql .= " " . $fieldlocaltax1 . " = " . ((float)price2num($this->total_localtax1, 'MT', 1)) . ",";
-                $sql .= " " . $fieldlocaltax2 . " = " . ((float)price2num($this->total_localtax2, 'MT', 1)) . ",";
-                $sql .= " " . $fieldttc . " = " . ((float)price2num($this->total_ttc, 'MT', 1));
-                $sql .= ", multicurrency_total_ht = " . ((float)price2num($this->multicurrency_total_ht, 'MT', 1));
-                $sql .= ", multicurrency_total_tva = " . ((float)price2num($this->multicurrency_total_tva, 'MT', 1));
-                $sql .= ", multicurrency_total_ttc = " . ((float)price2num($this->multicurrency_total_ttc, 'MT', 1));
-                $sql .= " WHERE rowid = " . ((int)$this->id);
+                $sql .= " " . $fieldht . " = " . ((float) price2num($this->total_ht, 'MT', 1)) . ",";
+                $sql .= " " . $fieldtva . " = " . ((float) price2num($this->total_tva, 'MT', 1)) . ",";
+                $sql .= " " . $fieldlocaltax1 . " = " . ((float) price2num($this->total_localtax1, 'MT', 1)) . ",";
+                $sql .= " " . $fieldlocaltax2 . " = " . ((float) price2num($this->total_localtax2, 'MT', 1)) . ",";
+                $sql .= " " . $fieldttc . " = " . ((float) price2num($this->total_ttc, 'MT', 1));
+                $sql .= ", multicurrency_total_ht = " . ((float) price2num($this->multicurrency_total_ht, 'MT', 1));
+                $sql .= ", multicurrency_total_tva = " . ((float) price2num($this->multicurrency_total_tva, 'MT', 1));
+                $sql .= ", multicurrency_total_ttc = " . ((float) price2num($this->multicurrency_total_ttc, 'MT', 1));
+                $sql .= " WHERE rowid = " . ((int) $this->id);
 
                 dol_syslog(get_only_class($this) . "::update_price", LOG_DEBUG);
                 $resql = $this->db->query($sql);
@@ -4982,9 +4982,9 @@ 
         $sql .= ", fk_target";
         $sql .= ", targettype";
         $sql .= ") VALUES (";
-        $sql .= ((int)$origin_id);
+        $sql .= ((int) $origin_id);
         $sql .= ", '" . $this->db->escape($origin) . "'";
-        $sql .= ", " . ((int)$this->id);
+        $sql .= ", " . ((int) $this->id);
         $sql .= ", '" . $this->db->escape($targettype) . "'";
         $sql .= ")";
 
@@ -5117,19 +5117,19 @@ 
         $sql .= " WHERE ";
         if ($justsource || $justtarget) {
             if ($justsource) {
-                $sql .= "fk_source = " . ((int)$sourceid) . " AND sourcetype = '" . $this->db->escape($sourcetype) . "'";
+                $sql .= "fk_source = " . ((int) $sourceid) . " AND sourcetype = '" . $this->db->escape($sourcetype) . "'";
                 if ($withtargettype) {
                     $sql .= " AND targettype = '" . $this->db->escape($targettype) . "'";
                 }
             } elseif ($justtarget) {
-                $sql .= "fk_target = " . ((int)$targetid) . " AND targettype = '" . $this->db->escape($targettype) . "'";
+                $sql .= "fk_target = " . ((int) $targetid) . " AND targettype = '" . $this->db->escape($targettype) . "'";
                 if ($withsourcetype) {
                     $sql .= " AND sourcetype = '" . $this->db->escape($sourcetype) . "'";
                 }
             }
         } else {
-            $sql .= "(fk_source = " . ((int)$sourceid) . " AND sourcetype = '" . $this->db->escape($sourcetype) . "')";
-            $sql .= " " . $clause . " (fk_target = " . ((int)$targetid) . " AND targettype = '" . $this->db->escape($targettype) . "')";
+            $sql .= "(fk_source = " . ((int) $sourceid) . " AND sourcetype = '" . $this->db->escape($sourcetype) . "')";
+            $sql .= " " . $clause . " (fk_target = " . ((int) $targetid) . " AND targettype = '" . $this->db->escape($targettype) . "')";
             if ($loadalsoobjects && $this->id > 0 && $sourceid == $this->id && $sourcetype == $this->element && $targetid == $this->id && $targettype == $this->element && $clause == 'OR') {
                 $this->linkedObjectsFullLoaded[$this->id] = true;
             }
@@ -5248,14 +5248,14 @@ 
 
         $sql = "UPDATE " . $this->db->prefix() . "element_element SET ";
         if ($updatesource) {
-            $sql .= "fk_source = " . ((int)$sourceid);
+            $sql .= "fk_source = " . ((int) $sourceid);
             $sql .= ", sourcetype = '" . $this->db->escape($sourcetype) . "'";
-            $sql .= " WHERE fk_target = " . ((int)$this->id);
+            $sql .= " WHERE fk_target = " . ((int) $this->id);
             $sql .= " AND targettype = '" . $this->db->escape($this->element) . "'";
         } elseif ($updatetarget) {
-            $sql .= "fk_target = " . ((int)$targetid);
+            $sql .= "fk_target = " . ((int) $targetid);
             $sql .= ", targettype = '" . $this->db->escape($targettype) . "'";
-            $sql .= " WHERE fk_source = " . ((int)$this->id);
+            $sql .= " WHERE fk_source = " . ((int) $this->id);
             $sql .= " AND sourcetype = '" . $this->db->escape($this->element) . "'";
         }
 
@@ -5338,11 +5338,11 @@ 
         }
 
         $sql = "UPDATE " . $this->db->prefix() . $elementTable;
-        $sql .= " SET " . $fieldstatus . " = " . ((int)$status);
+        $sql .= " SET " . $fieldstatus . " = " . ((int) $status);
         // If status = 1 = validated, update also fk_user_valid
         // TODO Replace the test on $elementTable by doing a test on existence of the field in $this->fields
         if ($status == 1 && in_array($elementTable, array('expensereport', 'inventory'))) {
-            $sql .= ", fk_user_valid = " . ((int)$user->id);
+            $sql .= ", fk_user_valid = " . ((int) $user->id);
         }
         if ($status == 1 && in_array($elementTable, array('expensereport'))) {
             $sql .= ", date_valid = '" . $this->db->idate(dol_now()) . "'";
@@ -5350,15 +5350,15 @@ 
         if ($status == 1 && in_array($elementTable, array('inventory'))) {
             $sql .= ", date_validation = '" . $this->db->idate(dol_now()) . "'";
         }
-        $sql .= " WHERE rowid = " . ((int)$elementId);
-        $sql .= " AND " . $fieldstatus . " <> " . ((int)$status);    // We avoid update if status already correct
+        $sql .= " WHERE rowid = " . ((int) $elementId);
+        $sql .= " AND " . $fieldstatus . " <> " . ((int) $status); // We avoid update if status already correct
 
         dol_syslog(get_only_class($this) . "::setStatut", LOG_DEBUG);
         $resql = $this->db->query($sql);
         if ($resql) {
             $error = 0;
 
-            $nb_rows_affected = $this->db->affected_rows($resql);   // should be 1 or 0 if status was already correct
+            $nb_rows_affected = $this->db->affected_rows($resql); // should be 1 or 0 if status was already correct
 
             if ($nb_rows_affected > 0) {
                 if (empty($trigkey)) {
@@ -5403,7 +5403,7 @@ 
                     if ($fieldstatus == 'tosell') {
                         $this->status = $status;
                     } elseif ($fieldstatus == 'tobuy') {
-                        $this->status_buy = $status;    // @phpstan-ignore-line
+                        $this->status_buy = $status; // @phpstan-ignore-line
                     } else {
                         $this->status = $status;
                     }
@@ -5447,7 +5447,7 @@ 
         $sql .= " FROM " . $this->db->prefix() . $this->table_element;
         $sql .= " WHERE entity IN (" . getEntity($this->element) . ")";
         if (!empty($id)) {
-            $sql .= " AND rowid = " . ((int)$id);
+            $sql .= " AND rowid = " . ((int) $id);
         }
         if (!empty($ref)) {
             $sql .= " AND ref = '" . $this->db->escape($ref) . "'";
@@ -5480,7 +5480,7 @@ 
     public function getSpecialCode($lineid)
     {
         $sql = "SELECT special_code FROM " . $this->db->prefix() . $this->table_element_line;
-        $sql .= " WHERE rowid = " . ((int)$lineid);
+        $sql .= " WHERE rowid = " . ((int) $lineid);
         $resql = $this->db->query($sql);
         if ($resql) {
             $row = $this->db->fetch_row($resql);
@@ -5540,7 +5540,7 @@ 
 
             $sql = "SELECT subprice as pu_ht, qty, remise_percent, total_ht";
             $sql .= " FROM " . $this->db->prefix() . $this->table_element_line;
-            $sql .= " WHERE " . $this->fk_element . " = " . ((int)$this->id);
+            $sql .= " WHERE " . $this->fk_element . " = " . ((int) $this->id);
 
             dol_syslog(get_only_class($this) . '::getTotalDiscount', LOG_DEBUG);
             $resql = $this->db->query($sql);
@@ -5554,7 +5554,7 @@ 
                     $qty = $obj->qty;
                     $total_ht = $obj->total_ht;
 
-                    $total_discount_line = (float)price2num(($pu_ht * $qty) - $total_ht, 'MT');
+                    $total_discount_line = (float) price2num(($pu_ht * $qty) - $total_ht, 'MT');
                     $total_discount += $total_discount_line;
 
                     $i++;
@@ -5562,7 +5562,7 @@ 
             }
 
             //print $total_discount; exit;
-            return (float)price2num($total_discount);
+            return (float) price2num($total_discount);
         }
 
         return null;
@@ -5685,7 +5685,7 @@ 
 
         $sql = "UPDATE " . $this->db->prefix() . $this->table_element;
         $sql .= " SET extraparams = " . (!empty($extraparams) ? "'" . $this->db->escape($extraparams) . "'" : "null");
-        $sql .= " WHERE rowid = " . ((int)$this->id);
+        $sql .= " WHERE rowid = " . ((int) $this->id);
 
         dol_syslog(get_only_class($this) . "::setExtraParameters", LOG_DEBUG);
         $resql = $this->db->query($sql);
@@ -6237,7 +6237,7 @@ 
         $sql .= ", busy";
         $sql .= ", mandatory";
         $sql .= ") VALUES (";
-        $sql .= ((int)$resource_id);
+        $sql .= ((int) $resource_id);
         $sql .= ", '" . $this->db->escape($resource_type) . "'";
         $sql .= ", '" . $this->db->escape($this->id) . "'";
         $sql .= ", '" . $this->db->escape($this->element) . "'";
@@ -6275,7 +6275,7 @@ 
         $this->db->begin();
 
         $sql = "DELETE FROM " . $this->db->prefix() . "element_resources";
-        $sql .= " WHERE rowid = " . ((int)$rowid);
+        $sql .= " WHERE rowid = " . ((int) $rowid);
 
         dol_syslog(get_only_class($this) . "::delete_resource", LOG_DEBUG);
 
@@ -6337,7 +6337,7 @@ 
             $maxwidthmini = $tmparraysize['maxwidthmini'];
             $maxheightmini = $tmparraysize['maxheightmini'];
             //$quality = $tmparraysize['quality'];
-            $quality = 50;  // For thumbs, we force quality to 50
+            $quality = 50; // For thumbs, we force quality to 50
 
             // Create small thumbs for company (Ratio is near 16/9)
             // Used on logon for example
@@ -6443,7 +6443,7 @@ 
         $sql = "SELECT rowid, property, lang , value";
         $sql .= " FROM " . $this->db->prefix() . "object_lang";
         $sql .= " WHERE type_object = '" . $this->db->escape($element) . "'";
-        $sql .= " AND fk_object = " . ((int)$this->id);
+        $sql .= " AND fk_object = " . ((int) $this->id);
 
         //dol_syslog(get_only_class($this)."::fetch_optionals get extrafields data for ".$this->table_element, LOG_DEBUG);       // Too verbose
         $resql = $this->db->query($sql);
@@ -6513,7 +6513,7 @@ 
 
             $enabled = 1;
             if (isset($this->fields[$key]['enabled'])) {
-                $enabled = (int)dol_eval($this->fields[$key]['enabled'], 1, 1, '1');
+                $enabled = (int) dol_eval($this->fields[$key]['enabled'], 1, 1, '1');
             }
             /*$perms = 1;
             if (isset($this->fields[$key]['perms']))
@@ -6660,7 +6660,7 @@ 
             foreach ($new_array_languages as $key => $langcodearray) {  // $key = 'name', 'town', ...
                 foreach ($langcodearray as $langcode => $value) {
                     $sql_del = "DELETE FROM " . $this->db->prefix() . "object_lang";
-                    $sql_del .= " WHERE fk_object = " . ((int)$this->id) . " AND property = '" . $this->db->escape($key) . "' AND type_object = '" . $this->db->escape($table_element) . "'";
+                    $sql_del .= " WHERE fk_object = " . ((int) $this->id) . " AND property = '" . $this->db->escape($key) . "' AND type_object = '" . $this->db->escape($table_element) . "'";
                     $sql_del .= " AND lang = '" . $this->db->escape($langcode) . "'";
                     $this->db->query($sql_del);
 
@@ -6828,7 +6828,7 @@ 
                                 if (isset($this->oldcopy->array_options["options_" . $key]) && $this->array_options["options_" . $key] == $this->oldcopy->array_options["options_" . $key]) { // If old value encrypted in database is same than submitted new value, it means we don't change it, so we don't update.
                                     if ($algo == 'dolcrypt') {  // dolibarr reversible encryption
                                         if (!preg_match('/^dolcrypt:/', $this->array_options["options_" . $key])) {
-                                            $new_array_options["options_" . $key] = dolEncrypt($this->array_options["options_" . $key]);    // warning, must be called when on the master
+                                            $new_array_options["options_" . $key] = dolEncrypt($this->array_options["options_" . $key]); // warning, must be called when on the master
                                         } else {
                                             $new_array_options["options_" . $key] = $this->array_options["options_" . $key]; // Value is kept
                                         }
@@ -6848,7 +6848,7 @@ 
                                 }
                             } else {
                                 if ($algo == 'dolcrypt' && !preg_match('/^dolcrypt:/', $this->array_options["options_" . $key])) {    // dolibarr reversible encryption
-                                    $new_array_options["options_" . $key] = dolEncrypt($this->array_options["options_" . $key]);    // warning, must be called when on the master
+                                    $new_array_options["options_" . $key] = dolEncrypt($this->array_options["options_" . $key]); // warning, must be called when on the master
                                 } else {
                                     $new_array_options["options_" . $key] = $this->array_options["options_" . $key]; // Value is kept
                                 }
@@ -6948,7 +6948,7 @@ 
                 $table_element = 'categories'; // For compatibility
             }
 
-            $sql = "SELECT COUNT(rowid) as nb FROM " . $this->db->prefix() . $table_element . "_extrafields WHERE fk_object = " . ((int)$this->id);
+            $sql = "SELECT COUNT(rowid) as nb FROM " . $this->db->prefix() . $table_element . "_extrafields WHERE fk_object = " . ((int) $this->id);
             $resql = $this->db->query($sql);
             if ($resql) {
                 $tmpobj = $this->db->fetch_object($resql);
@@ -6964,7 +6964,7 @@ 
                 } else {
                     $sql = "UPDATE " . $this->db->prefix() . $this->table_element . "_extrafields SET " . $key . " = '" . $this->db->escape($new_array_options["options_" . $key]) . "'";
                 }
-                $sql .= " WHERE fk_object = " . ((int)$this->id);
+                $sql .= " WHERE fk_object = " . ((int) $this->id);
 
                 $resql = $this->db->query($sql);
                 if (!$resql) {
@@ -7133,7 +7133,7 @@ 
                                         // If old value encrypted in database is same than submitted new value, it means we don't change it, so we don't update.
                                         if ($algo == 'dolcrypt') {  // dolibarr reversible encryption
                                             if (!preg_match('/^dolcrypt:/', $this->array_options[$key])) {
-                                                $new_array_options[$key] = dolEncrypt($this->array_options[$key]);  // warning, must be called when on the master
+                                                $new_array_options[$key] = dolEncrypt($this->array_options[$key]); // warning, must be called when on the master
                                             } else {
                                                 $new_array_options[$key] = $this->array_options[$key]; // Value is kept
                                             }
@@ -7144,7 +7144,7 @@ 
                                         // If value has changed
                                         if ($algo == 'dolcrypt') {  // dolibarr reversible encryption
                                             if (!preg_match('/^dolcrypt:/', $this->array_options[$key])) {
-                                                $new_array_options[$key] = dolEncrypt($this->array_options[$key]);  // warning, must be called when on the master
+                                                $new_array_options[$key] = dolEncrypt($this->array_options[$key]); // warning, must be called when on the master
                                             } else {
                                                 $new_array_options[$key] = $this->array_options[$key]; // Value is kept
                                             }
@@ -7156,7 +7156,7 @@ 
                                     //var_dump('jjj'.$algo.' '.$this->oldcopy->array_options[$key].' -> '.$this->array_options[$key]);
                                     // If this->oldcopy is not defined, we can't know if we change attribute or not, so we must keep value
                                     if ($algo == 'dolcrypt' && !preg_match('/^dolcrypt:/', $this->array_options[$key])) {   // dolibarr reversible encryption
-                                        $new_array_options[$key] = dolEncrypt($this->array_options[$key]);  // warning, must be called when on the master
+                                        $new_array_options[$key] = dolEncrypt($this->array_options[$key]); // warning, must be called when on the master
                                     } else {
                                         $new_array_options[$key] = $this->array_options[$key]; // Value is kept
                                     }
@@ -7232,7 +7232,7 @@ 
 
             dol_syslog(get_only_class($this) . "::insertExtraFields delete then insert", LOG_DEBUG);
 
-            $sql_del = "DELETE FROM " . $this->db->prefix() . $table_element . "_extrafields WHERE fk_object = " . ((int)$this->id);
+            $sql_del = "DELETE FROM " . $this->db->prefix() . $table_element . "_extrafields WHERE fk_object = " . ((int) $this->id);
             $this->db->query($sql_del);
 
             $sql = "INSERT INTO " . $this->db->prefix() . $table_element . "_extrafields (fk_object";
@@ -7703,7 +7703,7 @@ 
                     // Test on 'enabled' ('enabled' is different than 'list' = 'visibility')
                     $enabled = 1;
                     if ($enabled && isset($extrafields->attributes[$this->table_element]['enabled'][$key])) {
-                        $enabled = (int)dol_eval($extrafields->attributes[$this->table_element]['enabled'][$key], 1, 1, '2');
+                        $enabled = (int) dol_eval($extrafields->attributes[$this->table_element]['enabled'][$key], 1, 1, '2');
                     }
                     if (empty($enabled)) {
                         continue;
@@ -7711,12 +7711,12 @@ 
 
                     $visibility = 1;
                     if (isset($extrafields->attributes[$this->table_element]['list'][$key])) {
-                        $visibility = (int)dol_eval($extrafields->attributes[$this->table_element]['list'][$key], 1, 1, '2');
+                        $visibility = (int) dol_eval($extrafields->attributes[$this->table_element]['list'][$key], 1, 1, '2');
                     }
 
                     $perms = 1;
                     if ($perms && isset($extrafields->attributes[$this->table_element]['perms'][$key])) {
-                        $perms = (int)dol_eval($extrafields->attributes[$this->table_element]['perms'][$key], 1, 1, '2');
+                        $perms = (int) dol_eval($extrafields->attributes[$this->table_element]['perms'][$key], 1, 1, '2');
                     }
 
                     if (($mode == 'create') && !in_array(abs($visibility), array(1, 3))) {
@@ -8102,16 +8102,16 @@ 
                 $morecss = 'minwidth100imp';
             } elseif ($type == 'datetime' || $type == 'link') { // link means an foreign key to another primary id
                 $morecss = 'minwidth200imp';
-            } elseif (in_array($type, array('int', 'integer', 'price')) || preg_match('/^double(\([0-9],[0-9]\)){0,1}/', (string)$type)) {
+            } elseif (in_array($type, array('int', 'integer', 'price')) || preg_match('/^double(\([0-9],[0-9]\)){0,1}/', (string) $type)) {
                 $morecss = 'maxwidth75';
             } elseif ($type == 'url') {
                 $morecss = 'minwidth400';
             } elseif ($type == 'boolean') {
                 $morecss = '';
             } else {
-                if (is_numeric($size) && round((float)$size) < 12) {
+                if (is_numeric($size) && round((float) $size) < 12) {
                     $morecss = 'minwidth100';
-                } elseif (is_numeric($size) && round((float)$size) <= 48) {
+                } elseif (is_numeric($size) && round((float) $size) <= 48) {
                     $morecss = 'minwidth200';
                 } else {
                     $morecss = 'minwidth400';
@@ -8156,11 +8156,11 @@ 
             $out = '<input type="text" class="flat ' . $morecss . '" name="' . $keyprefix . $key . $keysuffix . '" id="' . $keyprefix . $key . $keysuffix . '"' . ($newsize > 0 ? ' maxlength="' . $newsize . '"' : '') . ' value="' . dol_escape_htmltag($value) . '"' . ($moreparam ? $moreparam : '') . ($autofocusoncreate ? ' autofocus' : '') . '>';
         } elseif (in_array($type, array('real'))) {
             $out = '<input type="text" class="flat ' . $morecss . '" name="' . $keyprefix . $key . $keysuffix . '" id="' . $keyprefix . $key . $keysuffix . '" value="' . dol_escape_htmltag($value) . '"' . ($moreparam ? $moreparam : '') . ($autofocusoncreate ? ' autofocus' : '') . '>';
-        } elseif (preg_match('/varchar/', (string)$type)) {
+        } elseif (preg_match('/varchar/', (string) $type)) {
             $out = '<input type="text" class="flat ' . $morecss . '" name="' . $keyprefix . $key . $keysuffix . '" id="' . $keyprefix . $key . $keysuffix . '"' . ($size > 0 ? ' maxlength="' . $size . '"' : '') . ' value="' . dol_escape_htmltag($value) . '"' . ($moreparam ? $moreparam : '') . ($autofocusoncreate ? ' autofocus' : '') . '>';
         } elseif (in_array($type, array('email', 'mail', 'phone', 'url', 'ip'))) {
             $out = '<input type="text" class="flat ' . $morecss . '" name="' . $keyprefix . $key . $keysuffix . '" id="' . $keyprefix . $key . $keysuffix . '" value="' . dol_escape_htmltag($value) . '" ' . ($moreparam ? $moreparam : '') . ($autofocusoncreate ? ' autofocus' : '') . '>';
-        } elseif (preg_match('/^text/', (string)$type)) {
+        } elseif (preg_match('/^text/', (string) $type)) {
             if (!preg_match('/search_/', $keyprefix)) {     // If keyprefix is search_ or search_options_, we must just use a simple text field
                 if (!empty($param['options'])) {
                     // If the textarea field has a list of arrayofkeyval into its definition, we suggest a combo with possible values to fill the textarea.
@@ -8210,14 +8210,14 @@ 
                     $out .= "</script>";
                 }
                 $doleditor = new DolEditor($keyprefix . $key . $keysuffix, $value, '', 200, 'dolibarr_notes', 'In', false, false, false, ROWS_5, '90%');
-                $out .= (string)$doleditor->Create(1, '', true, '', '', '', $morecss);
+                $out .= (string) $doleditor->Create(1, '', true, '', '', '', $morecss);
             } else {
                 $out = '<input type="text" class="flat ' . $morecss . ' maxwidthonsmartphone" name="' . $keyprefix . $key . $keysuffix . '" id="' . $keyprefix . $key . $keysuffix . '" value="' . dol_escape_htmltag($value) . '" ' . ($moreparam ? $moreparam : '') . '>';
             }
-        } elseif (preg_match('/^html/', (string)$type)) {
+        } elseif (preg_match('/^html/', (string) $type)) {
             if (!preg_match('/search_/', $keyprefix)) {     // If keyprefix is search_ or search_options_, we must just use a simple text field
                 $doleditor = new DolEditor($keyprefix . $key . $keysuffix, $value, '', 200, 'dolibarr_notes', 'In', false, false, isModEnabled('fckeditor') && getDolGlobalInt('FCKEDITOR_ENABLE_SOCIETE'), ROWS_5, '90%');
-                $out = (string)$doleditor->Create(1, '', true, '', '', $moreparam, $morecss);
+                $out = (string) $doleditor->Create(1, '', true, '', '', $moreparam, $morecss);
             } else {
                 $out = '<input type="text" class="flat ' . $morecss . ' maxwidthonsmartphone" name="' . $keyprefix . $key . $keysuffix . '" id="' . $keyprefix . $key . $keysuffix . '" value="' . dol_escape_htmltag($value) . '" ' . ($moreparam ? $moreparam : '') . '>';
             }
@@ -8234,7 +8234,7 @@ 
                 $value = price($value);
             }
             $out = '<input type="text" class="flat ' . $morecss . ' maxwidthonsmartphone" name="' . $keyprefix . $key . $keysuffix . '" id="' . $keyprefix . $key . $keysuffix . '" value="' . $value . '" ' . ($moreparam ? $moreparam : '') . '> ' . $langs->getCurrencySymbol($conf->currency);
-        } elseif (preg_match('/^double(\([0-9],[0-9]\)){0,1}/', (string)$type)) {
+        } elseif (preg_match('/^double(\([0-9],[0-9]\)){0,1}/', (string) $type)) {
             if (!empty($value)) {       // $value in memory is a php numeric, we format it into user number format.
                 $value = price($value);
             }
@@ -8249,7 +8249,7 @@ 
             $tmpselect = '';
             $nbchoice = 0;
             foreach ($param['options'] as $keyb => $valb) {
-                if ((string)$keyb == '') {
+                if ((string) $keyb == '') {
                     continue;
                 }
                 if (strpos($valb, "|") !== false) {
@@ -8257,7 +8257,7 @@ 
                 }
                 $nbchoice++;
                 $tmpselect .= '<option value="' . $keyb . '"';
-                $tmpselect .= (((string)$value == (string)$keyb) ? ' selected' : '');
+                $tmpselect .= (((string) $value == (string) $keyb) ? ' selected' : '');
                 if (!empty($parent)) {
                     $isDependList = 1;
                 }
@@ -8353,7 +8353,7 @@ 
 
                         // current object id can be use into filter
                         if (strpos($InfoFieldList[4], '$ID$') !== false && !empty($objectid)) {
-                            $InfoFieldList[4] = str_replace('$ID$', (string)$objectid, $InfoFieldList[4]);
+                            $InfoFieldList[4] = str_replace('$ID$', (string) $objectid, $InfoFieldList[4]);
                         } else {
                             $InfoFieldList[4] = str_replace('$ID$', '0', $InfoFieldList[4]);
                         }
@@ -8372,7 +8372,7 @@ 
                     }
                     // Some tables may have field, some other not. For the moment we disable it.
                     if (in_array($InfoFieldList[0], array('tablewithentity'))) {
-                        $sqlwhere .= " AND entity = " . ((int)$conf->entity);
+                        $sqlwhere .= " AND entity = " . ((int) $conf->entity);
                     }
                     $sql .= $sqlwhere;
                     //print $sql;
@@ -8533,7 +8533,7 @@ 
 
                         // current object id can be use into filter
                         if (strpos($InfoFieldList[4], '$ID$') !== false && !empty($objectid)) {
-                            $InfoFieldList[4] = str_replace('$ID$', (string)$objectid, $InfoFieldList[4]);
+                            $InfoFieldList[4] = str_replace('$ID$', (string) $objectid, $InfoFieldList[4]);
                         } else {
                             $InfoFieldList[4] = str_replace('$ID$', '0', $InfoFieldList[4]);
                         }
@@ -8550,7 +8550,7 @@ 
                     }
                     // Some tables may have field, some other not. For the moment we disable it.
                     if (in_array($InfoFieldList[0], array('tablewithentity'))) {
-                        $sqlwhere .= " AND entity = " . ((int)$conf->entity);
+                        $sqlwhere .= " AND entity = " . ((int) $conf->entity);
                     }
                     // $sql.=preg_replace('/^ AND /','',$sqlwhere);
                     // print $sql;
@@ -9255,7 +9255,7 @@ 
             // If field is an implicit foreign key field (so type = 'integer:...')
             if (isset($key_fields['type']) && preg_match('/^integer:/i', $key_fields['type']) && empty($values[$key])) {
                 if (isset($key_fields['default'])) {
-                    $values[$key] = ((int)$key_fields['default']);
+                    $values[$key] = ((int) $key_fields['default']);
                 } else {
                     $values[$key] = 'null';
                 }
@@ -9274,7 +9274,7 @@ 
         if (!$error) {
             $sql = "INSERT INTO " . $this->db->prefix() . $this->table_element;
             $sql .= " (" . implode(", ", $keys) . ')';
-            $sql .= " VALUES (" . implode(", ", $values) . ")";     // $values can contains 'abc' or 123
+            $sql .= " VALUES (" . implode(", ", $values) . ")"; // $values can contains 'abc' or 123
 
             $res = $this->db->query($sql);
             if (!$res) {
@@ -9295,7 +9295,7 @@ 
         if (!$error) {
             // @phan-suppress-next-line PhanTypePossiblyInvalidDimOffset
             if (array_key_exists('ref', $this->fields) && array_key_exists('notnull', $this->fields['ref']) && $this->fields['ref']['notnull'] > 0 && array_key_exists('default', $this->fields['ref']) && $this->fields['ref']['default'] == '(PROV)') {
-                $sql = "UPDATE " . $this->db->prefix() . $this->table_element . " SET ref = '(PROV" . ((int)$this->id) . ")' WHERE (ref = '(PROV)' OR ref = '') AND rowid = " . ((int)$this->id);
+                $sql = "UPDATE " . $this->db->prefix() . $this->table_element . " SET ref = '(PROV" . ((int) $this->id) . ")' WHERE (ref = '(PROV)' OR ref = '') AND rowid = " . ((int) $this->id);
                 $resqlupdate = $this->db->query($sql);
 
                 if ($resqlupdate === false) {
@@ -9324,7 +9324,7 @@ 
                 // Test and convert into object this->lines[$i]. When coming from REST API, we may still have an array
                 //if (! is_object($line)) $line=json_decode(json_encode($line), false);  // convert recursively array into object.
                 if (!is_object($line)) {
-                    $line = (object)$line;
+                    $line = (object) $line;
                 }
 
                 $result = 0;
@@ -9392,23 +9392,23 @@ 
                             $queryarray[$field] = 0;
                         }
                     } else {
-                        $queryarray[$field] = (int)$this->{$field};        // If '0', it may be set to null later if $info['notnull'] == -1
+                        $queryarray[$field] = (int) $this->{$field};        // If '0', it may be set to null later if $info['notnull'] == -1
                     }
                 } else {
                     $queryarray[$field] = null;
                 }
             } elseif ($this->isInt($info) || $this->isFloat($info)) {
                 if ($field == 'entity' && is_null($this->{$field})) {
-                    $queryarray[$field] = ((int)$conf->entity);
+                    $queryarray[$field] = ((int) $conf->entity);
                 } else {
                     // $this->{$field} may be null, '', 0, '0', 123, '123'
-                    if ((isset($this->{$field}) && ((string)$this->{$field}) != '') || !empty($info['notnull'])) {
+                    if ((isset($this->{$field}) && ((string) $this->{$field}) != '') || !empty($info['notnull'])) {
                         if (!isset($this->{$field})) {
                             $queryarray[$field] = 0;
                         } elseif ($this->isInt($info)) {
-                            $queryarray[$field] = (int)$this->{$field};    // If '0', it may be set to null later if $info['notnull'] == -1
+                            $queryarray[$field] = (int) $this->{$field};    // If '0', it may be set to null later if $info['notnull'] == -1
                         } elseif ($this->isFloat($info)) {
-                            $queryarray[$field] = (float)$this->{$field};  // If '0', it may be set to null later if $info['notnull'] == -1
+                            $queryarray[$field] = (float) $this->{$field};  // If '0', it may be set to null later if $info['notnull'] == -1
                         }
                     } else {
                         $queryarray[$field] = null;
@@ -9443,9 +9443,9 @@ 
         if (is_null($value)) {
             return 'NULL';
         } elseif (preg_match('/^(int|double|real|price)/i', $fieldsentry['type'])) {
-            return price2num((string)$value);
+            return price2num((string) $value);
         } elseif (preg_match('/int$/i', $fieldsentry['type'])) {
-            return (int)$value;
+            return (int) $value;
         } elseif ($fieldsentry['type'] == 'boolean') {
             if ($value) {
                 return 'true';
@@ -9477,7 +9477,7 @@ 
 
         $sql = "SELECT " . $objectline->getFieldList('l');
         $sql .= " FROM " . $this->db->prefix() . $objectline->table_element . " as l";
-        $sql .= " WHERE l.fk_" . $this->db->escape($this->element) . " = " . ((int)$this->id);
+        $sql .= " WHERE l.fk_" . $this->db->escape($this->element) . " = " . ((int) $this->id);
         if ($morewhere) {
             $sql .= $morewhere;
         }
@@ -9586,7 +9586,7 @@ 
             }*/
         }
 
-        $sql = 'UPDATE ' . $this->db->prefix() . $this->table_element . ' SET ' . implode(', ', $tmp) . ' WHERE rowid=' . ((int)$this->id);
+        $sql = 'UPDATE ' . $this->db->prefix() . $this->table_element . ' SET ' . implode(', ', $tmp) . ' WHERE rowid=' . ((int) $this->id);
 
         $this->db->begin();
 
@@ -9600,7 +9600,7 @@ 
 
         // Update extrafield
         if (!$error) {
-            $result = $this->insertExtraFields();   // This delete and reinsert extrafields
+            $result = $this->insertExtraFields(); // This delete and reinsert extrafields
             if ($result < 0) {
                 $error++;
             }
@@ -9644,7 +9644,7 @@ 
 
         if ($forcechilddeletion) {  // Force also delete of childtables that should lock deletion in standard case when option force is off
             foreach ($this->childtables as $table) {
-                $sql = "DELETE FROM " . $this->db->prefix() . $table . " WHERE " . $this->fk_element . " = " . ((int)$this->id);
+                $sql = "DELETE FROM " . $this->db->prefix() . $table . " WHERE " . $this->fk_element . " = " . ((int) $this->id);
                 $resql = $this->db->query($sql);
                 if (!$resql) {
                     $this->error = $this->db->lasterror();
@@ -9698,7 +9698,7 @@ 
                     }
                 } else {
                     // Delete record in child table
-                    $sql = "DELETE FROM " . $this->db->prefix() . $tabletodelete . " WHERE " . $this->fk_element . " = " . ((int)$this->id);
+                    $sql = "DELETE FROM " . $this->db->prefix() . $tabletodelete . " WHERE " . $this->fk_element . " = " . ((int) $this->id);
 
                     $resql = $this->db->query($sql);
                     if (!$resql) {
@@ -9744,7 +9744,7 @@ 
         }
 
         if (!$error) {
-            $sql = 'DELETE FROM ' . $this->db->prefix() . $this->table_element . ' WHERE rowid=' . ((int)$this->id);
+            $sql = 'DELETE FROM ' . $this->db->prefix() . $this->table_element . ' WHERE rowid=' . ((int) $this->id);
 
             $resql = $this->db->query($sql);
             if (!$resql) {
@@ -9785,7 +9785,7 @@ 
             return -1;
         }
 
-        $arraytoscan = $this->childtables;      // array('tablename'=>array('fk_element'=>'parentfield'), ...) or array('tablename'=>array('parent'=>table_parent, 'parentkey'=>'nameoffieldforparentfkkey'), ...)
+        $arraytoscan = $this->childtables; // array('tablename'=>array('fk_element'=>'parentfield'), ...) or array('tablename'=>array('parent'=>table_parent, 'parentkey'=>'nameoffieldforparentfkkey'), ...)
         // For backward compatibility, we check if array is old format array('tablename1', 'tablename2', ...)
         $tmparray = array_keys($this->childtables);
         if (is_numeric($tmparray[0])) {
@@ -9803,9 +9803,9 @@ 
                 $sql .= ", " . $this->db->prefix() . $element['parent'] . " as p";
             }
             if (!empty($element['fk_element'])) {
-                $sql .= " WHERE c." . $element['fk_element'] . " = " . ((int)$id);
+                $sql .= " WHERE c." . $element['fk_element'] . " = " . ((int) $id);
             } else {
-                $sql .= " WHERE c." . $this->fk_element . " = " . ((int)$id);
+                $sql .= " WHERE c." . $this->fk_element . " = " . ((int) $id);
             }
             if (!empty($element['parent']) && !empty($element['parentkey'])) {
                 $sql .= " AND c." . $element['parentkey'] . " = p.rowid";
@@ -9815,9 +9815,9 @@ 
             }
             if (!empty($entity)) {
                 if (!empty($element['parent']) && !empty($element['parentkey'])) {
-                    $sql .= " AND p.entity = " . ((int)$entity);
+                    $sql .= " AND p.entity = " . ((int) $entity);
                 } else {
-                    $sql .= " AND c.entity = " . ((int)$entity);
+                    $sql .= " AND c.entity = " . ((int) $entity);
                 }
             }
 
@@ -9872,7 +9872,7 @@ 
             $this->db->begin();
 
             $sql = "SELECT rowid FROM " . $this->db->prefix() . $this->table_element;
-            $sql .= " WHERE " . $this->db->sanitize($parentField) . " = " . (int)$parentId;
+            $sql .= " WHERE " . $this->db->sanitize($parentField) . " = " . (int) $parentId;
 
             // Manage filter
             $errormessage = '';
@@ -9889,7 +9889,7 @@ 
                 $error++;
             } else {
                 while ($obj = $this->db->fetch_object($resql)) {
-                    $result = $this->fetch($obj->rowid);    // @phpstan-ignore-line
+                    $result = $this->fetch($obj->rowid); // @phpstan-ignore-line
                     if ($result < 0) {
                         $error++;
                         $this->errors[] = $this->error;
@@ -9966,7 +9966,7 @@ 
             // Delete ecm_files_extrafields with mode 0 (using name)
             $sql = "DELETE FROM " . $this->db->prefix() . "ecm_files_extrafields WHERE fk_object IN (";
             $sql .= " SELECT rowid FROM " . $this->db->prefix() . "ecm_files WHERE filename LIKE '" . $this->db->escape($this->ref) . "%'";
-            $sql .= " AND filepath = '" . $this->db->escape($element) . "/" . $this->db->escape($this->ref) . "' AND entity = " . ((int)$conf->entity); // No need of getEntity here
+            $sql .= " AND filepath = '" . $this->db->escape($element) . "/" . $this->db->escape($this->ref) . "' AND entity = " . ((int) $conf->entity); // No need of getEntity here
             $sql .= ")";
 
             if (!$this->db->query($sql)) {
@@ -9978,7 +9978,7 @@ 
             // Delete ecm_files with mode 0 (using name)
             $sql = "DELETE FROM " . $this->db->prefix() . "ecm_files";
             $sql .= " WHERE filename LIKE '" . $this->db->escape($this->ref) . "%'";
-            $sql .= " AND filepath = '" . $this->db->escape($element) . "/" . $this->db->escape($this->ref) . "' AND entity = " . ((int)$conf->entity); // No need of getEntity here
+            $sql .= " AND filepath = '" . $this->db->escape($element) . "/" . $this->db->escape($this->ref) . "' AND entity = " . ((int) $conf->entity); // No need of getEntity here
 
             if (!$this->db->query($sql)) {
                 $this->error = $this->db->lasterror();
@@ -9990,7 +9990,7 @@ 
         // Delete in database with mode 1
         if ($mode == 1) {
             $sql = 'DELETE FROM ' . $this->db->prefix() . "ecm_files_extrafields";
-            $sql .= " WHERE fk_object IN (SELECT rowid FROM " . $this->db->prefix() . "ecm_files WHERE src_object_type = '" . $this->db->escape($this->table_element . (empty($this->module) ? "" : "@" . $this->module)) . "' AND src_object_id = " . ((int)$this->id) . ")";
+            $sql .= " WHERE fk_object IN (SELECT rowid FROM " . $this->db->prefix() . "ecm_files WHERE src_object_type = '" . $this->db->escape($this->table_element . (empty($this->module) ? "" : "@" . $this->module)) . "' AND src_object_id = " . ((int) $this->id) . ")";
             $resql = $this->db->query($sql);
             if (!$resql) {
                 $this->error = $this->db->lasterror();
@@ -9999,7 +9999,7 @@ 
             }
 
             $sql = 'DELETE FROM ' . $this->db->prefix() . "ecm_files";
-            $sql .= " WHERE src_object_type = '" . $this->db->escape($this->table_element . (empty($this->module) ? "" : "@" . $this->module)) . "' AND src_object_id = " . ((int)$this->id);
+            $sql .= " WHERE src_object_type = '" . $this->db->escape($this->table_element . (empty($this->module) ? "" : "@" . $this->module)) . "' AND src_object_id = " . ((int) $this->id);
             $resql = $this->db->query($sql);
             if (!$resql) {
                 $this->error = $this->db->lasterror();
@@ -10063,18 +10063,18 @@ 
             $sql = "DELETE FROM " . $this->db->prefix() . "element_element";
             $sql .= " WHERE";
             if ($rowid > 0) {
-                $sql .= " rowid = " . ((int)$rowid);
+                $sql .= " rowid = " . ((int) $rowid);
             } else {
                 if ($deletesource) {
-                    $sql .= " fk_source = " . ((int)$sourceid) . " AND sourcetype = '" . $this->db->escape($sourcetype) . "'";
-                    $sql .= " AND fk_target = " . ((int)$this->id) . " AND targettype = '" . $this->db->escape($this->element) . "'";
+                    $sql .= " fk_source = " . ((int) $sourceid) . " AND sourcetype = '" . $this->db->escape($sourcetype) . "'";
+                    $sql .= " AND fk_target = " . ((int) $this->id) . " AND targettype = '" . $this->db->escape($this->element) . "'";
                 } elseif ($deletetarget) {
-                    $sql .= " fk_target = " . ((int)$targetid) . " AND targettype = '" . $this->db->escape($targettype) . "'";
-                    $sql .= " AND fk_source = " . ((int)$this->id) . " AND sourcetype = '" . $this->db->escape($this->element) . "'";
+                    $sql .= " fk_target = " . ((int) $targetid) . " AND targettype = '" . $this->db->escape($targettype) . "'";
+                    $sql .= " AND fk_source = " . ((int) $this->id) . " AND sourcetype = '" . $this->db->escape($this->element) . "'";
                 } else {
-                    $sql .= " (fk_source = " . ((int)$this->id) . " AND sourcetype = '" . $this->db->escape($this->element) . "')";
+                    $sql .= " (fk_source = " . ((int) $this->id) . " AND sourcetype = '" . $this->db->escape($this->element) . "')";
                     $sql .= " OR";
-                    $sql .= " (fk_target = " . ((int)$this->id) . " AND targettype = '" . $this->db->escape($this->element) . "')";
+                    $sql .= " (fk_target = " . ((int) $this->id) . " AND targettype = '" . $this->db->escape($this->element) . "')";
                 }
             }
 
@@ -10118,7 +10118,7 @@ 
 
         dol_syslog(get_only_class($this) . "::deleteExtraFields delete", LOG_DEBUG);
 
-        $sql_del = "DELETE FROM " . $this->db->prefix() . $table_element . "_extrafields WHERE fk_object = " . ((int)$this->id);
+        $sql_del = "DELETE FROM " . $this->db->prefix() . $table_element . "_extrafields WHERE fk_object = " . ((int) $this->id);
 
         $resql = $this->db->query($sql_del);
         if (!$resql) {
@@ -10157,7 +10157,7 @@ 
 
         if (empty($error)) {
             $sql = "DELETE FROM " . $this->db->prefix() . $this->table_element_line;
-            $sql .= " WHERE rowid = " . ((int)$idline);
+            $sql .= " WHERE rowid = " . ((int) $idline);
 
             $resql = $this->db->query($sql);
             if (!$resql) {
@@ -10211,8 +10211,8 @@ 
         }
 
         $sql = "UPDATE " . $this->db->prefix() . $this->table_element;
-        $sql .= " SET " . $statusfield . " = " . ((int)$status);
-        $sql .= " WHERE rowid = " . ((int)$this->id);
+        $sql .= " SET " . $statusfield . " = " . ((int) $status);
+        $sql .= " WHERE rowid = " . ((int) $this->id);
 
         if ($this->db->query($sql)) {
             if (!$error) {
@@ -10263,8 +10263,8 @@ 
         $statusfield = 'signed_status';
 
         $sql = "UPDATE " . $this->db->prefix() . $this->table_element;
-        $sql .= " SET " . $statusfield . " = " . ((int)$status);
-        $sql .= " WHERE rowid = " . ((int)$this->id);
+        $sql .= " SET " . $statusfield . " = " . ((int) $status);
+        $sql .= " WHERE rowid = " . ((int) $this->id);
 
         if ($this->db->query($sql)) {
             if (!$error) {
@@ -10321,7 +10321,7 @@ 
         );
         foreach ($fields as $key => $value) {
             if (array_key_exists($key, $this->fields)) {
-                $this->{$key} = $value;     // @phpstan-ignore-line
+                $this->{$key} = $value; // @phpstan-ignore-line
             }
         }
 
@@ -10508,7 +10508,7 @@ 
 
         $sql = "INSERT INTO " . $this->db->prefix() . "categorie_" . (empty($categorystatic->MAP_CAT_TABLE[$type]) ? $type : $categorystatic->MAP_CAT_TABLE[$type]) . " (fk_categorie, fk_product)";
         $sql .= " SELECT fk_categorie, $toId FROM " . $this->db->prefix() . "categorie_" . (empty($categorystatic->MAP_CAT_TABLE[$type]) ? $type : $categorystatic->MAP_CAT_TABLE[$type]);
-        $sql .= " WHERE fk_product = " . ((int)$fromId);
+        $sql .= " WHERE fk_product = " . ((int) $fromId);
 
         if (!$this->db->query($sql)) {
             $this->error = $this->db->lasterror();
@@ -10769,7 +10769,7 @@ 
             $setsharekey = false;
             if ($this->element == 'propal' || $this->element == 'proposal') {
                 if (getDolGlobalInt("PROPOSAL_ALLOW_ONLINESIGN")) {
-                    $setsharekey = true;    // feature to make online signature is not set or set to on (default)
+                    $setsharekey = true; // feature to make online signature is not set or set to on (default)
                 }
                 if (getDolGlobalInt("PROPOSAL_ALLOW_EXTERNAL_DOWNLOAD")) {
                     $setsharekey = true;
@@ -10827,7 +10827,7 @@ 
                 $ecmfile->gen_or_uploaded = 'generated';
                 $ecmfile->description = ''; // indexed content
                 $ecmfile->keywords = ''; // keyword content
-                $ecmfile->src_object_type = $this->table_element;   // $this->table_name is 'myobject' or 'mymodule_myobject'.
+                $ecmfile->src_object_type = $this->table_element; // $this->table_name is 'myobject' or 'mymodule_myobject'.
                 $ecmfile->src_object_id = $this->id;
 
                 $result = $ecmfile->create($user);
@@ -10844,7 +10844,7 @@ 
 
             if ($update_main_doc_field && !empty($this->table_element)) {
                 $sql = "UPDATE " . $this->db->prefix() . $this->table_element . " SET last_main_doc = '" . $this->db->escape($ecmfile->filepath . "/" . $ecmfile->filename) . "'";
-                $sql .= " WHERE rowid = " . ((int)$this->id);
+                $sql .= " WHERE rowid = " . ((int) $this->id);
 
                 $resql = $this->db->query($sql);
                 if (!$resql) {