alxarafe / alixar

Dolibarr/Code/EmailCollector/Classes/EmailCollector.php

Spacing +30 added lines, -30 removed lines

@@ -354,7 +354,7 @@ 
 
         $sql = 'SELECT rowid, type, rulevalue, status';
         $sql .= ' FROM ' . MAIN_DB_PREFIX . 'emailcollector_emailcollectorfilter';
-        $sql .= ' WHERE fk_emailcollector = ' . ((int)$this->id);
+        $sql .= ' WHERE fk_emailcollector = ' . ((int) $this->id);
         //$sql.= ' ORDER BY position';
 
         $resql = $this->db->query($sql);
@@ -386,7 +386,7 @@ 
 
         $sql = 'SELECT rowid, type, actionparam, status';
         $sql .= ' FROM ' . MAIN_DB_PREFIX . 'emailcollector_emailcollectoraction';
-        $sql .= ' WHERE fk_emailcollector = ' . ((int)$this->id);
+        $sql .= ' WHERE fk_emailcollector = ' . ((int) $this->id);
         $sql .= ' ORDER BY position';
 
         $resql = $this->db->query($sql);
@@ -617,7 +617,7 @@ 
         $sql = 'SELECT rowid, date_creation as datec, tms as datem,';
         $sql .= ' fk_user_creat, fk_user_modif';
         $sql .= ' FROM ' . MAIN_DB_PREFIX . $this->table_element . ' as t';
-        $sql .= ' WHERE t.rowid = ' . ((int)$id);
+        $sql .= ' WHERE t.rowid = ' . ((int) $id);
         $result = $this->db->query($sql);
         if ($result) {
             if ($this->db->num_rows($result)) {
@@ -1125,7 +1125,7 @@ 
                 }
 
                 if ($rule['type'] == 'from') {
-                    $tmprulevaluearray = explode('*', $rule['rulevalue']);  // Search on abc*def means searching on 'abc' and on 'def'
+                    $tmprulevaluearray = explode('*', $rule['rulevalue']); // Search on abc*def means searching on 'abc' and on 'def'
                     if (count($tmprulevaluearray) >= 2) {
                         foreach ($tmprulevaluearray as $tmprulevalue) {
                             $search .= ($search ? ' ' : '') . $not . 'FROM "' . str_replace('"', '', $tmprulevalue) . '"';
@@ -1135,7 +1135,7 @@ 
                     }
                 }
                 if ($rule['type'] == 'to') {
-                    $tmprulevaluearray = explode('*', $rule['rulevalue']);  // Search on abc*def means searching on 'abc' and on 'def'
+                    $tmprulevaluearray = explode('*', $rule['rulevalue']); // Search on abc*def means searching on 'abc' and on 'def'
                     if (count($tmprulevaluearray) >= 2) {
                         foreach ($tmprulevaluearray as $tmprulevalue) {
                             $search .= ($search ? ' ' : '') . $not . 'TO "' . str_replace('"', '', $tmprulevalue) . '"';
@@ -1322,7 +1322,7 @@ 
             }
         }
 
-        $arrayofemailtodelete = array();    // Track email to delete to make the deletion at end.
+        $arrayofemailtodelete = array(); // Track email to delete to make the deletion at end.
 
         // Loop on each email found
         if (!$error && !empty($arrayofemail) && count($arrayofemail) > 0) {
@@ -1392,7 +1392,7 @@ 
                     // $operationslog .= " - ".dol_escape_htmltag((string) $imapemail);
                     $msgid = str_replace(array('<', '>'), '', $overview['message_id']);
                 } else {
-                    $operationslog .= " - " . dol_escape_htmltag((string)$imapemail);
+                    $operationslog .= " - " . dol_escape_htmltag((string) $imapemail);
                     $msgid = str_replace(array('<', '>'), '', $overview[0]->message_id);
                 }
                 $operationslog .= " - MsgId: " . $msgid . " - References: " . dol_escape_htmltag($headers['References'] ?? '') . " - Subject: " . dol_escape_htmltag($headers['Subject']);
@@ -1654,15 +1654,15 @@ 
                     $tmpdate = $overview['date']->toDate();
                     $tmptimezone = $tmpdate->getTimezone()->getName();
 
-                    $dateemail = dol_stringtotime((string)$overview['date'], 'gmt');    // if $overview['timezone'] is "+00:00"
+                    $dateemail = dol_stringtotime((string) $overview['date'], 'gmt'); // if $overview['timezone'] is "+00:00"
                     if (preg_match('/^([+\-])(\d\d):(\d\d)/', $tmptimezone, $reg)) {
                         if ($reg[1] == '+' && ($reg[2] != '00' || $reg[3] != '00')) {
-                            $dateemail -= (3600 * (int)$reg[2]);
-                            $dateemail -= (60 * (int)$reg[3]);
+                            $dateemail -= (3600 * (int) $reg[2]);
+                            $dateemail -= (60 * (int) $reg[3]);
                         }
                         if ($reg[1] == '-' && ($reg[2] != '00' || $reg[3] != '00')) {
-                            $dateemail += (3600 * (int)$reg[2]);
-                            $dateemail += (60 * (int)$reg[3]);
+                            $dateemail += (3600 * (int) $reg[2]);
+                            $dateemail += (60 * (int) $reg[3]);
                         }
                     }
                     $subject = $overview['subject'];
@@ -1674,7 +1674,7 @@ 
                     $to = $overview[0]->to;
                     $sendtocc = !empty($overview[0]->cc) ? $overview[0]->cc : '';
                     $sendtobcc = !empty($overview[0]->bcc) ? $overview[0]->bcc : '';
-                    $dateemail = dol_stringtotime((string)$overview[0]->udate, 'gmt');
+                    $dateemail = dol_stringtotime((string) $overview[0]->udate, 'gmt');
                     $subject = $overview[0]->subject;
                     //var_dump($msgid);exit;
                 }
@@ -1739,15 +1739,15 @@ 
                 foreach ($arrayofreferences as $reference) {
                     //print "Process mail ".$iforemailloop." email_msgid ".$msgid.", date ".dol_print_date($dateemail, 'dayhour', 'gmt').", subject ".$subject.", reference ".dol_escape_htmltag($reference)."<br>\n";
                     if (!empty($trackidfoundintorecipienttype)) {
-                        $resultsearchtrackid = -1;      // trackid found
+                        $resultsearchtrackid = -1; // trackid found
                         $reg[1] = $trackidfoundintorecipienttype;
                         $reg[2] = $trackidfoundintorecipientid;
                     } elseif (!empty($trackidfoundintomsgidtype)) {
-                        $resultsearchtrackid = -1;      // trackid found
+                        $resultsearchtrackid = -1; // trackid found
                         $reg[1] = $trackidfoundintomsgidtype;
                         $reg[2] = $trackidfoundintomsgidid;
                     } else {
-                        $resultsearchtrackid = preg_match('/dolibarr-([a-z]+)([0-9]+)@' . preg_quote($host, '/') . '/', $reference, $reg);  // trackid found or not
+                        $resultsearchtrackid = preg_match('/dolibarr-([a-z]+)([0-9]+)@' . preg_quote($host, '/') . '/', $reference, $reg); // trackid found or not
                         if (empty($resultsearchtrackid) && getDolGlobalString('EMAIL_ALTERNATIVE_HOST_SIGNATURE')) {
                             $resultsearchtrackid = preg_match('/dolibarr-([a-z]+)([0-9]+)@' . preg_quote(getDolGlobalString('EMAIL_ALTERNATIVE_HOST_SIGNATURE'), '/') . '/', $reference, $reg); // trackid found
                         }
@@ -2045,7 +2045,7 @@ 
 
                         // Make Operation
                         dol_syslog("Execute action " . $operation['type'] . " actionparam=" . $operation['actionparam'] . ' thirdpartystatic->id=' . $thirdpartystatic->id . ' contactstatic->id=' . $contactstatic->id . ' projectstatic->id=' . $projectstatic->id);
-                        dol_syslog("Execute action fk_element_id=" . $fk_element_id . " fk_element_type=" . $fk_element_type);    // If a Dolibarr tracker id is found, we should now the id of object
+                        dol_syslog("Execute action fk_element_id=" . $fk_element_id . " fk_element_type=" . $fk_element_type); // If a Dolibarr tracker id is found, we should now the id of object
 
                         // Try to guess if this is an email in or out.
                         $actioncode = 'EMAIL_IN';
@@ -2098,7 +2098,7 @@ 
                                     $operationslog .= '<br>Ticket not found using trackid=' . $trackid . ' or msgid=' . $msgid;
                                     $ticketalreadyexists = 0;
                                 } else {
-                                    $operationslog .= '<br>Ticket already found using trackid=' . $trackid . ' or msgid=' . $msgid;   // We change the operation type to do
+                                    $operationslog .= '<br>Ticket already found using trackid=' . $trackid . ' or msgid=' . $msgid; // We change the operation type to do
                                     $ticketalreadyexists = 1;
                                     $operation['type'] = 'recordevent';
                                 }
@@ -2472,8 +2472,8 @@ 
                                 $actioncomm->label = $langs->trans("ActionAC_" . $actioncode) . ' - ' . $langs->trans("MailFrom") . ' ' . $from;
                                 $actioncomm->note_private = $descriptionfull;
                                 $actioncomm->fk_project = $projectstatic->id;
-                                $actioncomm->datep = $dateemail;  // date of email
-                                $actioncomm->datef = $dateemail;  // date of email
+                                $actioncomm->datep = $dateemail; // date of email
+                                $actioncomm->datef = $dateemail; // date of email
                                 $actioncomm->percentage = -1; // Not applicable
                                 $actioncomm->socid = $thirdpartystatic->id;
                                 $actioncomm->contact_id = $contactstatic->id;
@@ -2671,7 +2671,7 @@ 
                                 }
                                 $hookmanager->initHooks(array('emailcolector'));
                                 $parameters = array('arrayobject' => $arrayobject);
-                                $reshook = $hookmanager->executeHooks('addmoduletoeamailcollectorjoinpiece', $parameters);    // Note that $action and $object may have been modified by some hooks
+                                $reshook = $hookmanager->executeHooks('addmoduletoeamailcollectorjoinpiece', $parameters); // Note that $action and $object may have been modified by some hooks
                                 if ($reshook > 0) {
                                     $arrayobject = $hookmanager->resArray;
                                 }
@@ -2760,7 +2760,7 @@ 
                                 $percent_opp_status = dol_getIdFromCode($this->db, 'PROSP', 'c_lead_status', 'code', 'percent');
 
                                 $projecttocreate->title = $subject;
-                                $projecttocreate->date_start = $date;   // date of email
+                                $projecttocreate->date_start = $date; // date of email
                                 $projecttocreate->date_end = 0;
                                 $projecttocreate->opp_status = $id_opp_status;
                                 $projecttocreate->opp_percent = $percent_opp_status;
@@ -2785,7 +2785,7 @@ 
                                     $file = '';
                                     $classname = '';
                                     $reldir = '';
-                                    $dirmodels = array_merge(array('/'), (array)$conf->modules_parts['models']);
+                                    $dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
                                     foreach ($dirmodels as $reldir) {
                                         $file = dol_buildpath($reldir . "core/modules/project/" . $modele . '.php', 0);
                                         if (file_exists($file)) {
@@ -2840,7 +2840,7 @@ 
                                                 if (getDolGlobalString('MAIN_IMAP_USE_PHPIMAP')) {
                                                     foreach ($attachments as $attachment) {
                                                         // $attachment->save($destdir.'/');
-                                                        $typeattachment = (string)$attachment->getDisposition();
+                                                        $typeattachment = (string) $attachment->getDisposition();
                                                         $filename = $attachment->getFilename();
                                                         $content = $attachment->getContent();
                                                         $this->saveAttachment($destdir, $filename, $content);
@@ -2925,7 +2925,7 @@ 
                                     $file = '';
                                     $classname = '';
                                     $reldir = '';
-                                    $dirmodels = array_merge(array('/'), (array)$conf->modules_parts['models']);
+                                    $dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
                                     foreach ($dirmodels as $reldir) {
                                         $file = dol_buildpath($reldir . "core/modules/ticket/" . $modele . '.php', 0);
                                         if (file_exists($file)) {
@@ -2975,7 +2975,7 @@ 
                                                 if (getDolGlobalString('MAIN_IMAP_USE_PHPIMAP')) {
                                                     foreach ($attachments as $attachment) {
                                                         // $attachment->save($destdir.'/');
-                                                        $typeattachment = (string)$attachment->getDisposition();
+                                                        $typeattachment = (string) $attachment->getDisposition();
                                                         $filename = $attachment->getFilename();
                                                         $content = $attachment->getContent();
                                                         $this->saveAttachment($destdir, $filename, $content);
@@ -3022,7 +3022,7 @@ 
                                 $candidaturetocreate->note_private = $descriptionfull;
                                 $candidaturetocreate->entity = $conf->entity;
                                 $candidaturetocreate->email_msgid = $msgid;
-                                $candidaturetocreate->email_date = $date;       // date of email
+                                $candidaturetocreate->email_date = $date; // date of email
                                 $candidaturetocreate->status = $candidaturetocreate::STATUS_DRAFT;
                                 //$candidaturetocreate->fk_contact = $contactstatic->id;
 
@@ -3324,8 +3324,8 @@ 
     {
         if (function_exists('mb_convert_encoding')) {
             // change spaces by entropy because mb_convert fail with spaces
-            $str = preg_replace("/ /", "xxxSPACExxx", $str);        // the replacement string must be valid in utf7 so _ can't be used
-            $str = preg_replace("/\[Gmail\]/", "xxxGMAILxxx", $str);    // the replacement string must be valid in utf7 so _ can't be used
+            $str = preg_replace("/ /", "xxxSPACExxx", $str); // the replacement string must be valid in utf7 so _ can't be used
+            $str = preg_replace("/\[Gmail\]/", "xxxGMAILxxx", $str); // the replacement string must be valid in utf7 so _ can't be used
             // if mb_convert work
             if ($str = mb_convert_encoding($str, "UTF-7")) {
                 // change characters
@@ -3851,7 +3851,7 @@ 
         if (is_object($imapemail)) {
             return $imapemail->getAttributes()["uid"];
         } else {
-            return (string)$imapemail;
+            return (string) $imapemail;
         }
     }
 }

Dolibarr/Code/Compta/Api/Invoices.php

Indentation +16 added lines, -16 removed lines

@@ -367,18 +367,18 @@ 
     }
 
     /**
-    * Create an invoice using a contract.
-    *
-    * @param int   $contractid       Id of the contract
-    * @return     Object                          Object with cleaned properties
-    *
-    * @url     POST /createfromcontract/{contractid}
-    *
-    * @throws RestException 400
-    * @throws RestException 401
-    * @throws RestException 404
-    * @throws RestException 405
-    */
+     * Create an invoice using a contract.
+     *
+     * @param int   $contractid       Id of the contract
+     * @return     Object                          Object with cleaned properties
+     *
+     * @url     POST /createfromcontract/{contractid}
+     *
+     * @throws RestException 400
+     * @throws RestException 401
+     * @throws RestException 404
+     * @throws RestException 405
+     */
     public function createInvoiceFromContract($contractid)
     {
     
@@ -1727,7 +1727,7 @@ 
         ];
     }
 
-	// phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
+    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
     /**
      * Clean sensible object datas
      *
@@ -1736,7 +1736,7 @@ 
      */
     protected function _cleanObjectDatas($object)
     {
-		// phpcs:enable
+        // phpcs:enable
         $object = parent::_cleanObjectDatas($object);
 
         unset($object->note);
@@ -1830,7 +1830,7 @@ 
     }
 
 
-	// phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
+    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.PublicUnderscore
     /**
      * Clean sensible object datas
      *
@@ -1839,7 +1839,7 @@ 
      */
     protected function _cleanTemplateObjectDatas($object)
     {
-		// phpcs:enable
+        // phpcs:enable
         $object = parent::_cleanObjectDatas($object);
 
         unset($object->note);

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_class() . "::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_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();
@@ -1741,7 +1741,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) {
@@ -1750,18 +1750,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";
 
@@ -1889,9 +1889,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);
@@ -1978,7 +1978,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++;
@@ -1990,7 +1990,7 @@ 
             dol_syslog(get_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) {
@@ -2039,7 +2039,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_class($this) . "::delete_linked_contact", LOG_DEBUG);
@@ -2126,7 +2126,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) . "'";
 
@@ -2163,12 +2163,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;
@@ -2302,7 +2302,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') . ")";
@@ -2318,7 +2318,7 @@ 
         }
         $sql .= " AND tc.active = 1";
         if ($status) {
-            $sql .= " AND ec.statut = " . ((int)$status);
+            $sql .= " AND ec.statut = " . ((int) $status);
         }
 
         dol_syslog(get_class($this) . "::getIdContact", LOG_DEBUG);
@@ -2467,7 +2467,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_class($this) . '::fetch_barcode', LOG_DEBUG);
                 $resql = $this->db->query($sql);
                 if ($resql) {
@@ -2586,7 +2586,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_class($this) . '::fetchObjectFrom', LOG_DEBUG);
@@ -2622,7 +2622,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_class($this) . '::getValueFrom', LOG_DEBUG);
             $resql = $this->db->query($sql);
@@ -2683,7 +2683,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) {
@@ -2711,7 +2711,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') {
@@ -2720,13 +2720,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) {
@@ -2795,7 +2795,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 {
@@ -2882,17 +2882,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;
                         }
@@ -2903,11 +2903,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;
                     }
@@ -2919,7 +2919,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;
         }
     }
 
@@ -3063,7 +3063,7 @@ 
                 }
             }
             $sql .= " FROM " . $this->db->prefix() . $table_element . "_extrafields";
-            $sql .= " WHERE fk_object = " . ((int)$rowid);
+            $sql .= " WHERE fk_object = " . ((int) $rowid);
 
             //dol_syslog(get_class($this)."::fetch_optionals get extrafields data for ".$this->table_element, LOG_DEBUG);       // Too verbose
             $resql = $this->db->query($sql);
@@ -3110,8 +3110,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');
                             }
                         }
@@ -3188,15 +3188,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;
@@ -3235,13 +3235,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>";
 
@@ -3267,12 +3267,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)) . ")";
@@ -3280,7 +3280,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;
@@ -3321,13 +3321,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
@@ -3392,32 +3392,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_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++;
@@ -3477,8 +3477,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;
@@ -3528,7 +3528,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;
@@ -3565,8 +3565,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;
@@ -3788,7 +3788,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) {
@@ -3796,11 +3796,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;
@@ -3842,8 +3842,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;
@@ -3877,8 +3877,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;
@@ -3909,8 +3909,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;
@@ -3953,8 +3953,8 @@ 
         dol_syslog(get_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_class($this) . '::setShippingMethod Error ', LOG_DEBUG);
@@ -4001,8 +4001,8 @@ 
         dol_syslog(get_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;
@@ -4034,7 +4034,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_class($this) . "::setDocModel", LOG_DEBUG);
         $resql = $this->db->query($sql);
@@ -4079,8 +4079,8 @@ 
         dol_syslog(get_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) {
@@ -4165,7 +4165,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";
         }
@@ -4187,7 +4187,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';
             }
@@ -4242,8 +4242,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_class($this) . "::getChildrenOfLine search children lines for line " . $id, LOG_DEBUG);
@@ -4276,8 +4276,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_class($this) . "::updateRangOfLine", LOG_DEBUG);
         if (!$this->db->query($sql)) {
@@ -4305,7 +4305,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_class($this) . "::getRangOfLine", LOG_DEBUG);
         $resql = $this->db->query($sql);
@@ -4332,12 +4332,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);
                 }
@@ -4386,8 +4386,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_class($this) . "::line_max", LOG_DEBUG);
             $resql = $this->db->query($sql);
@@ -4402,7 +4402,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_class($this) . "::line_max", LOG_DEBUG);
             $resql = $this->db->query($sql);
@@ -4431,12 +4431,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);
                 }
@@ -4475,8 +4475,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);
@@ -4502,7 +4502,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_class($this) . "::update_ref_ext", LOG_DEBUG);
         if ($this->db->query($sql)) {
@@ -4567,8 +4567,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_class($this) . "::update_note", LOG_DEBUG);
         if ($this->db->query($sql)) {
@@ -4711,7 +4711,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') {
@@ -4762,7 +4762,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) {
@@ -4773,7 +4773,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) {
@@ -4812,10 +4812,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);
@@ -4824,10 +4824,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);
                         }
 
@@ -4837,14 +4837,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);
                         }
                     }
                 }
@@ -4877,11 +4877,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);
 
@@ -4898,15 +4898,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_class($this) . "::update_price", LOG_DEBUG);
                 $resql = $this->db->query($sql);
@@ -4984,9 +4984,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 .= ")";
 
@@ -5119,19 +5119,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;
             }
@@ -5250,14 +5250,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) . "'";
         }
 
@@ -5340,11 +5340,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()) . "'";
@@ -5352,15 +5352,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_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)) {
@@ -5405,7 +5405,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;
                     }
@@ -5449,7 +5449,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) . "'";
@@ -5482,7 +5482,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);
@@ -5542,7 +5542,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_class($this) . '::getTotalDiscount', LOG_DEBUG);
             $resql = $this->db->query($sql);
@@ -5556,7 +5556,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++;
@@ -5564,7 +5564,7 @@ 
             }
 
             //print $total_discount; exit;
-            return (float)price2num($total_discount);
+            return (float) price2num($total_discount);
         }
 
         return null;
@@ -5687,7 +5687,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_class($this) . "::setExtraParameters", LOG_DEBUG);
         $resql = $this->db->query($sql);
@@ -6239,7 +6239,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) . "'";
@@ -6277,7 +6277,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_class($this) . "::delete_resource", LOG_DEBUG);
 
@@ -6339,7 +6339,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
@@ -6445,7 +6445,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_class($this)."::fetch_optionals get extrafields data for ".$this->table_element, LOG_DEBUG);       // Too verbose
         $resql = $this->db->query($sql);
@@ -6515,7 +6515,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']))
@@ -6662,7 +6662,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);
 
@@ -6830,7 +6830,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
                                         }
@@ -6850,7 +6850,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
                                 }
@@ -6950,7 +6950,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);
@@ -6966,7 +6966,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) {
@@ -7135,7 +7135,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
                                             }
@@ -7146,7 +7146,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
                                             }
@@ -7158,7 +7158,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
                                     }
@@ -7234,7 +7234,7 @@ 
 
             dol_syslog(get_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";
@@ -7705,7 +7705,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;
@@ -7713,12 +7713,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))) {
@@ -8104,16 +8104,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';
@@ -8158,11 +8158,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.
@@ -8212,14 +8212,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 : '') . '>';
             }
@@ -8236,7 +8236,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);
             }
@@ -8251,7 +8251,7 @@ 
             $tmpselect = '';
             $nbchoice = 0;
             foreach ($param['options'] as $keyb => $valb) {
-                if ((string)$keyb == '') {
+                if ((string) $keyb == '') {
                     continue;
                 }
                 if (strpos($valb, "|") !== false) {
@@ -8259,7 +8259,7 @@ 
                 }
                 $nbchoice++;
                 $tmpselect .= '<option value="' . $keyb . '"';
-                $tmpselect .= (((string)$value == (string)$keyb) ? ' selected' : '');
+                $tmpselect .= (((string) $value == (string) $keyb) ? ' selected' : '');
                 if (!empty($parent)) {
                     $isDependList = 1;
                 }
@@ -8355,7 +8355,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]);
                         }
@@ -8374,7 +8374,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;
@@ -8535,7 +8535,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]);
                         }
@@ -8552,7 +8552,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;
@@ -9257,7 +9257,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';
                 }
@@ -9276,7 +9276,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) {
@@ -9297,7 +9297,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) {
@@ -9326,7 +9326,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;
@@ -9394,23 +9394,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;
@@ -9445,9 +9445,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';
@@ -9479,7 +9479,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;
         }
@@ -9588,7 +9588,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();
 
@@ -9602,7 +9602,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++;
             }
@@ -9646,7 +9646,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();
@@ -9700,7 +9700,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) {
@@ -9746,7 +9746,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) {
@@ -9787,7 +9787,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])) {
@@ -9805,9 +9805,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";
@@ -9817,9 +9817,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);
                 }
             }
 
@@ -9874,7 +9874,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 = '';
@@ -9891,7 +9891,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;
@@ -9968,7 +9968,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)) {
@@ -9980,7 +9980,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();
@@ -9992,7 +9992,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();
@@ -10001,7 +10001,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();
@@ -10065,18 +10065,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) . "')";
                 }
             }
 
@@ -10120,7 +10120,7 @@ 
 
         dol_syslog(get_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) {
@@ -10159,7 +10159,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) {
@@ -10213,8 +10213,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) {
@@ -10265,8 +10265,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) {
@@ -10323,7 +10323,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
             }
         }
 
@@ -10511,7 +10511,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();
@@ -10773,7 +10773,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;
@@ -10831,7 +10831,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);
@@ -10848,7 +10848,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) {

public/htdocs/contrat/ticket.php

Spacing +3 added lines, -3 removed lines

@@ -73,7 +73,7 @@ 
 
 dol_get_fiche_head($head, 'ticket', $langs->trans("Contract"), -1, 'contract');
 
-$linkback = '<a href="' . constant('BASE_URL') . '/contrat/list.php' . (! empty($socid) ? '?socid=' . $socid : '') . '">';
+$linkback = '<a href="' . constant('BASE_URL') . '/contrat/list.php' . (!empty($socid) ? '?socid=' . $socid : '') . '">';
 $linkback .= $langs->trans("BackToList") . '</a>';
 
 $morehtmlref = '';
@@ -134,11 +134,11 @@ 
 // Thirdparty
 $morehtmlref .= '<br>' . $langs->trans('ThirdParty') . ' : ' . $object->thirdparty->getNomUrl(1);
 // Project
-if (! empty($conf->projet->enabled)) {
+if (!empty($conf->projet->enabled)) {
     
     $langs->load("projects");
     $morehtmlref .= '<br>' . $langs->trans('Project') . ' : ';
-    if (! empty($object->fk_project)) {
+    if (!empty($object->fk_project)) {
         $proj = new Project($db);
         $proj->fetch($object->fk_project);
         $morehtmlref .= '<a href="' . constant('BASE_URL') . '/projet/card.php?id=';

public/htdocs/install/upgrade2.php

Spacing +2 added lines, -2 removed lines

@@ -4207,7 +4207,7 @@ 
     }
 
     if (!is_object($user)) {
-        $user = new User($db);  // To avoid error during migration
+        $user = new User($db); // To avoid error during migration
     }
 
     dolibarr_install_syslog("upgrade2::migrate_reload_modules force=" . $force . ", listofmodule=" . implode(',', array_keys($listofmodule)));
@@ -5038,7 +5038,7 @@ 
                 $error++;
             }
 
-            $current_contract =  $obj->cid;
+            $current_contract = $obj->cid;
         }
     } else {
         $error++;

public/htdocs/core/modules/user/modules_user.class.php

Indentation +2 added lines, -2 removed lines

@@ -45,7 +45,7 @@ 
     public $error = '';
 
 
-	// phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
+    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
     /**
      *  Return list of active generation modules
      *
@@ -55,7 +55,7 @@ 
      */
     public static function liste_modeles($db, $maxfilenamelength = 0)
     {
-		// phpcs:enable
+        // phpcs:enable
         $type = 'user';
         $list = array();
 

public/htdocs/core/triggers/interface_50_modAgenda_ActionsAuto.class.php

Spacing +2 added lines, -2 removed lines

@@ -1504,8 +1504,8 @@
                 $actioncomm = new ActionComm($this->db);
         $actioncomm->type_code   = $object->actiontypecode; // Type of event ('AC_OTH', 'AC_OTH_AUTO', 'AC_XXX'...)
         $actioncomm->code        = 'AC_' . $action;
-        $actioncomm->label       = $object->actionmsg2;     // Label of event
-        $actioncomm->note_private = $object->actionmsg;     // Description
+        $actioncomm->label       = $object->actionmsg2; // Label of event
+        $actioncomm->note_private = $object->actionmsg; // Description
         $actioncomm->fk_project  = $projectid;
         $actioncomm->datep       = $now;
         $actioncomm->datef       = $now;

public/htdocs/user/virtualcard.php

Spacing +1 added lines, -1 removed lines

@@ -287,7 +287,7 @@
     print '<tr class="oddeven" id="tredit"><td>';
     print $langs->trans("Text");
     print '</td><td>';
-    $extendededitor = 0;    // We force no WYSIWYG editor
+    $extendededitor = 0; // We force no WYSIWYG editor
     $doleditor = new DolEditor('USER_PUBLIC_MORE', getDolUserString('USER_PUBLIC_MORE', '', $object), '', 160, 'dolibarr_notes', '', false, false, $extendededitor, ROWS_5, '90%');
     $doleditor->Create();
     print "</td></tr>\n";