Completed
Push — master ( 7e6804...36d2e6 )
by Laurent
05:20 queued 03:07
created
lib/flightLog.lib.php 1 patch
Doc Comments   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -149,9 +149,9 @@
 block discarded – undo
149 149
 }
150 150
 
151 151
 /**
152
- * @param null $year
153
- * @param null $pilotId
154
- * @param null $quarter
152
+ * @param integer $year
153
+ * @param integer $pilotId
154
+ * @param integer $quarter
155 155
  * @param bool $groupBy
156 156
  *
157 157
  * @return string
Please login to merge, or discard this patch.
card.php 1 patch
Spacing   +20 added lines, -20 removed lines patch added patch discarded remove patch
@@ -56,7 +56,7 @@  discard block
 block discarded – undo
56 56
 $langs->load("other");
57 57
 
58 58
 // Get parameters
59
-$id = GETPOST('id', 'int')?: GETPOST('idBBC_vols', 'int');
59
+$id = GETPOST('id', 'int') ?: GETPOST('idBBC_vols', 'int');
60 60
 $action = GETPOST('action', 'alpha');
61 61
 $cancel = GETPOST('cancel');
62 62
 $backtopage = GETPOST('backtopage');
@@ -106,7 +106,7 @@  discard block
 block discarded – undo
106 106
 $extralabels = $extrafields->fetch_name_optionals_label($object->table_element);
107 107
 
108 108
 // Load object
109
-include DOL_DOCUMENT_ROOT . '/core/actions_fetchobject.inc.php';  // Must be include, not include_once  // Must be include, not include_once. Include fetch and fetch_thirdparty but not fetch_optionals
109
+include DOL_DOCUMENT_ROOT . '/core/actions_fetchobject.inc.php'; // Must be include, not include_once  // Must be include, not include_once. Include fetch and fetch_thirdparty but not fetch_optionals
110 110
 
111 111
 // Initialize technical object to manage hooks of modules. Note that conf->hooks_modules contains array array
112 112
 $hookmanager->initHooks(array('bbcvols'));
@@ -125,7 +125,7 @@  discard block
 block discarded – undo
125 125
 
126 126
 $parameters = array();
127 127
 $reshook = $hookmanager->executeHooks('doActions', $parameters, $object,
128
-    $action);    // Note that $action and $object may have been modified by some hooks
128
+    $action); // Note that $action and $object may have been modified by some hooks
129 129
 if ($reshook < 0) {
130 130
     setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
131 131
 }
@@ -214,8 +214,8 @@  discard block
 block discarded – undo
214 214
         $object->id = $object->idBBC_vols;
215 215
         $object->lieuD = GETPOST('lieuD', 'alpha');
216 216
         $object->lieuA = GETPOST('lieuA', 'alpha');
217
-        $object->heureD = GETPOST('heureD_h', 'int').":".GETPOST('heureD_m', 'int').":00";
218
-        $object->heureA = GETPOST('heureA_h', 'int').":".GETPOST('heureA_m', 'int').":00";
217
+        $object->heureD = GETPOST('heureD_h', 'int') . ":" . GETPOST('heureD_m', 'int') . ":00";
218
+        $object->heureA = GETPOST('heureA_h', 'int') . ":" . GETPOST('heureA_m', 'int') . ":00";
219 219
         $object->BBC_ballons_idBBC_ballons = GETPOST('BBC_ballons_idBBC_ballons', 'int');
220 220
         $object->nbrPax = GETPOST('nbrPax', 'alpha');
221 221
         $object->remarque = GETPOST('remarque', 'alpha');
@@ -236,12 +236,12 @@  discard block
 block discarded – undo
236 236
                 null, 'errors');
237 237
         }
238 238
 
239
-        if(!dol_validElement($object->lieuD)){
239
+        if (!dol_validElement($object->lieuD)) {
240 240
             $error++;
241 241
             setEventMessage("Erreur le champ : lieu de décollage", 'errors');
242 242
         }
243 243
 
244
-        if(!dol_validElement($object->lieuA)){
244
+        if (!dol_validElement($object->lieuA)) {
245 245
             $error++;
246 246
             setEventMessage("Erreur le champ : lieu d'atterissage", 'errors');
247 247
         }
@@ -253,12 +253,12 @@  discard block
 block discarded – undo
253 253
             setEventMessage("Erreur avec les heures de vol", 'errors');
254 254
         }
255 255
 
256
-        if(!is_numeric($object->nbrPax) || $object->nbrPax < 0 ){
256
+        if (!is_numeric($object->nbrPax) || $object->nbrPax < 0) {
257 257
             $error++;
258 258
             setEventMessage("Erreur le champ : nombre de passagers", 'errors');
259 259
         }
260 260
 
261
-        if(!$pilotService->isPilot($object->fk_pilot)){
261
+        if (!$pilotService->isPilot($object->fk_pilot)) {
262 262
             $error++;
263 263
             setEventMessage("Le pilote selectionne n'est pas pilote", 'errors');
264 264
         }
@@ -399,18 +399,18 @@  discard block
 block discarded – undo
399 399
         select_balloons($object->BBC_ballons_idBBC_ballons, "BBC_ballons_idBBC_ballons");
400 400
     print "</td></tr>";
401 401
     print "<tr><td class=\"fieldrequired\">" . $langs->trans("FieldnbrPax") . "</td><td><input class=\"flat\" type=\"number\" name=\"nbrPax\" value=\"" . $object->nbrPax . "\"></td></tr>";
402
-    print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldremarque") . "</td><td><textarea class=\"flat\" name=\"remarque\">".$object->remarque."</textarea></td></tr>";
403
-    print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldincidents") . "</td><td><textarea class=\"flat\" name=\"incidents\">".$object->incidents."</textarea></td></tr>";
402
+    print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldremarque") . "</td><td><textarea class=\"flat\" name=\"remarque\">" . $object->remarque . "</textarea></td></tr>";
403
+    print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldincidents") . "</td><td><textarea class=\"flat\" name=\"incidents\">" . $object->incidents . "</textarea></td></tr>";
404 404
     print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldfk_type") . "</td><td>";
405 405
         select_flight_type($object->fk_type, "fk_type");
406 406
     print "</td></tr>";
407
-    print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldfk_pilot") . "</td><td>".$form->select_dolusers($object->fk_pilot, "fk_pilot", 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', 1)."</td></tr>";
408
-    print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldfk_organisateur") . "</td><td>".$form->select_dolusers($object->fk_organisateur, "fk_organisateur")."</td></tr>";
407
+    print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldfk_pilot") . "</td><td>" . $form->select_dolusers($object->fk_pilot, "fk_pilot", 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', 1) . "</td></tr>";
408
+    print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldfk_organisateur") . "</td><td>" . $form->select_dolusers($object->fk_organisateur, "fk_organisateur") . "</td></tr>";
409 409
 
410
-    if($user->rights->flightLog->vol->financial || $user->id == $object->fk_pilot) {
410
+    if ($user->rights->flightLog->vol->financial || $user->id == $object->fk_pilot) {
411 411
         print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldkilometers") . "</td><td><input class=\"flat\" type=\"number\" name=\"kilometers\" value=\"" . $object->kilometers . "\"></td></tr>";
412 412
         print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldcost") . "</td><td><input class=\"flat\" type=\"number\" name=\"cost\" value=\"" . $object->cost . "\"></td></tr>";
413
-        print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldfk_receiver") . "</td><td>" . $form->select_dolusers($object->fk_receiver,"fk_receiver", true ) . "</td></tr>";
413
+        print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldfk_receiver") . "</td><td>" . $form->select_dolusers($object->fk_receiver, "fk_receiver", true) . "</td></tr>";
414 414
         print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldjustif_kilometers") . "</td><td><textarea class=\"flat\" name=\"justif_kilometers\">" . $object->justif_kilometers . "</textarea></td></tr>";
415 415
     }
416 416
     print '</table>';
@@ -432,7 +432,7 @@  discard block
 block discarded – undo
432 432
 
433 433
     print load_fiche_titre($langs->trans($pageTitle));
434 434
 
435
-    $linkback = '<a href="'.DOL_URL_ROOT.'/flightLog/list.php">'.$langs->trans("BackToList").'</a>';
435
+    $linkback = '<a href="' . DOL_URL_ROOT . '/flightLog/list.php">' . $langs->trans("BackToList") . '</a>';
436 436
     print $form->showrefnav($object, "idBBC_vols", $linkback, true, "idBBC_vols");
437 437
     dol_fiche_head();
438 438
 
@@ -459,13 +459,13 @@  discard block
 block discarded – undo
459 459
     print '<tr><td class="fieldrequired">' . $langs->trans("Fieldfk_pilot") . '</td><td>' . $pilot->getNomUrl(1) . '</td></tr>';
460 460
     print '<tr><td class="fieldrequired">' . $langs->trans("Fieldfk_organisateur") . '</td><td>' . $organisator->getNomUrl(1) . '</td></tr>';
461 461
 
462
-    if($user->rights->flightLog->vol->financial){
462
+    if ($user->rights->flightLog->vol->financial) {
463 463
         print '<tr><td class="fieldrequired">' . $langs->trans("Fieldis_facture") . '</td><td>' . $object->is_facture . '</td></tr>';
464 464
     }
465 465
 
466
-    if($user->rights->flightLog->vol->financial || $user->id == $object->fk_pilot) {
466
+    if ($user->rights->flightLog->vol->financial || $user->id == $object->fk_pilot) {
467 467
         print '<tr><td class="fieldrequired">' . $langs->trans("Fieldkilometers") . '</td><td>' . $object->kilometers . ' KM</td></tr>';
468
-        print '<tr><td class="fieldrequired">' . $langs->trans("Fieldcost") . '</td><td>' . $object->cost ." ". $langs->getCurrencySymbol($conf->currency).'</td></tr>';
468
+        print '<tr><td class="fieldrequired">' . $langs->trans("Fieldcost") . '</td><td>' . $object->cost . " " . $langs->getCurrencySymbol($conf->currency) . '</td></tr>';
469 469
         print '<tr><td class="fieldrequired">' . $langs->trans("Fieldfk_receiver") . '</td><td>' . $receiver->getNomUrl(1) . '</td></tr>';
470 470
         print '<tr><td class="fieldrequired">' . $langs->trans("Fieldjustif_kilometers") . '</td><td>' . $object->justif_kilometers . '</td></tr>';
471 471
     }
@@ -478,7 +478,7 @@  discard block
 block discarded – undo
478 478
     print '<div class="tabsAction">' . "\n";
479 479
     $parameters = array();
480 480
     $reshook = $hookmanager->executeHooks('addMoreActionsButtons', $parameters, $object,
481
-        $action);    // Note that $action and $object may have been modified by hook
481
+        $action); // Note that $action and $object may have been modified by hook
482 482
     if ($reshook < 0) {
483 483
         setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
484 484
     }
Please login to merge, or discard this patch.
class/bbctypes.class.php 3 patches
Indentation   +491 added lines, -491 removed lines patch added patch discarded remove patch
@@ -41,211 +41,211 @@  discard block
 block discarded – undo
41 41
  */
42 42
 class Bbctypes extends CommonObject
43 43
 {
44
-	/**
45
-	 * @var string Id to identify managed objects
46
-	 */
47
-	public $element = 'bbctypes';
48
-	/**
49
-	 * @var string Name of table without prefix where object is stored
50
-	 */
51
-	public $table_element = 'bbc_types';
52
-
53
-	/**
54
-	 * @var BbctypesLine[] Lines
55
-	 */
56
-	public $lines = array();
57
-
58
-	/**
59
-	 */
44
+    /**
45
+     * @var string Id to identify managed objects
46
+     */
47
+    public $element = 'bbctypes';
48
+    /**
49
+     * @var string Name of table without prefix where object is stored
50
+     */
51
+    public $table_element = 'bbc_types';
52
+
53
+    /**
54
+     * @var BbctypesLine[] Lines
55
+     */
56
+    public $lines = array();
57
+
58
+    /**
59
+     */
60 60
 	
61
-	public $idType;
62
-	public $numero;
63
-	public $nom;
64
-	public $active;
65
-
66
-	/**
67
-	 * Constructor
68
-	 *
69
-	 * @param DoliDb $db Database handler
70
-	 */
71
-	public function __construct(DoliDB $db)
72
-	{
73
-		$this->db = $db;
74
-	}
75
-
76
-	/**
77
-	 * Create object into database
78
-	 *
79
-	 * @param  User $user      User that creates
80
-	 * @param  bool $notrigger false=launch triggers after, true=disable triggers
81
-	 *
82
-	 * @return int <0 if KO, Id of created object if OK
83
-	 */
84
-	public function create(User $user, $notrigger = false)
85
-	{
86
-		dol_syslog(__METHOD__, LOG_DEBUG);
87
-
88
-		$error = 0;
89
-
90
-		// Clean parameters
61
+    public $idType;
62
+    public $numero;
63
+    public $nom;
64
+    public $active;
65
+
66
+    /**
67
+     * Constructor
68
+     *
69
+     * @param DoliDb $db Database handler
70
+     */
71
+    public function __construct(DoliDB $db)
72
+    {
73
+        $this->db = $db;
74
+    }
75
+
76
+    /**
77
+     * Create object into database
78
+     *
79
+     * @param  User $user      User that creates
80
+     * @param  bool $notrigger false=launch triggers after, true=disable triggers
81
+     *
82
+     * @return int <0 if KO, Id of created object if OK
83
+     */
84
+    public function create(User $user, $notrigger = false)
85
+    {
86
+        dol_syslog(__METHOD__, LOG_DEBUG);
87
+
88
+        $error = 0;
89
+
90
+        // Clean parameters
91 91
 		
92
-		if (isset($this->idType)) {
93
-			 $this->idType = trim($this->idType);
94
-		}
95
-		if (isset($this->numero)) {
96
-			 $this->numero = trim($this->numero);
97
-		}
98
-		if (isset($this->nom)) {
99
-			 $this->nom = trim($this->nom);
100
-		}
101
-		if (isset($this->active)) {
102
-			 $this->active = trim($this->active);
103
-		}
104
-
105
-
106
-
107
-		// Check parameters
108
-		// Put here code to add control on parameters values
109
-
110
-		// Insert request
111
-		$sql = 'INSERT INTO ' . MAIN_DB_PREFIX . $this->table_element . '(';
92
+        if (isset($this->idType)) {
93
+                $this->idType = trim($this->idType);
94
+        }
95
+        if (isset($this->numero)) {
96
+                $this->numero = trim($this->numero);
97
+        }
98
+        if (isset($this->nom)) {
99
+                $this->nom = trim($this->nom);
100
+        }
101
+        if (isset($this->active)) {
102
+                $this->active = trim($this->active);
103
+        }
104
+
105
+
106
+
107
+        // Check parameters
108
+        // Put here code to add control on parameters values
109
+
110
+        // Insert request
111
+        $sql = 'INSERT INTO ' . MAIN_DB_PREFIX . $this->table_element . '(';
112 112
 		
113
-		$sql.= 'numero,';
114
-		$sql.= 'nom';
115
-		$sql.= 'active';
113
+        $sql.= 'numero,';
114
+        $sql.= 'nom';
115
+        $sql.= 'active';
116 116
 
117 117
 		
118
-		$sql .= ') VALUES (';
118
+        $sql .= ') VALUES (';
119 119
 		
120
-		$sql .= ' '.(! isset($this->numero)?'NULL':$this->numero).',';
121
-		$sql .= ' '.(! isset($this->nom)?'NULL':"'".$this->db->escape($this->nom)."'").',';
122
-		$sql .= ' '.(! isset($this->active)?'NULL':$this->active);
120
+        $sql .= ' '.(! isset($this->numero)?'NULL':$this->numero).',';
121
+        $sql .= ' '.(! isset($this->nom)?'NULL':"'".$this->db->escape($this->nom)."'").',';
122
+        $sql .= ' '.(! isset($this->active)?'NULL':$this->active);
123 123
 
124 124
 		
125
-		$sql .= ')';
126
-
127
-		$this->db->begin();
128
-
129
-		$resql = $this->db->query($sql);
130
-		if (!$resql) {
131
-			$error ++;
132
-			$this->errors[] = 'Error ' . $this->db->lasterror();
133
-			dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
134
-		}
135
-
136
-		if (!$error) {
137
-			$this->id = $this->db->last_insert_id(MAIN_DB_PREFIX . $this->table_element);
138
-
139
-			if (!$notrigger) {
140
-				// Uncomment this and change MYOBJECT to your own tag if you
141
-				// want this action to call a trigger.
142
-
143
-				//// Call triggers
144
-				//$result=$this->call_trigger('MYOBJECT_CREATE',$user);
145
-				//if ($result < 0) $error++;
146
-				//// End call triggers
147
-			}
148
-		}
149
-
150
-		// Commit or rollback
151
-		if ($error) {
152
-			$this->db->rollback();
153
-
154
-			return - 1 * $error;
155
-		} else {
156
-			$this->db->commit();
157
-
158
-			return $this->id;
159
-		}
160
-	}
161
-
162
-	/**
163
-	 * Load object in memory from the database
164
-	 *
165
-	 * @param int    $id  Id object
166
-	 * @param string $ref Ref
167
-	 *
168
-	 * @return int <0 if KO, 0 if not found, >0 if OK
169
-	 */
170
-	public function fetch($id, $ref = null)
171
-	{
172
-		dol_syslog(__METHOD__, LOG_DEBUG);
173
-
174
-		$sql = 'SELECT';
175
-		$sql .= ' t.idType,';
125
+        $sql .= ')';
126
+
127
+        $this->db->begin();
128
+
129
+        $resql = $this->db->query($sql);
130
+        if (!$resql) {
131
+            $error ++;
132
+            $this->errors[] = 'Error ' . $this->db->lasterror();
133
+            dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
134
+        }
135
+
136
+        if (!$error) {
137
+            $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX . $this->table_element);
138
+
139
+            if (!$notrigger) {
140
+                // Uncomment this and change MYOBJECT to your own tag if you
141
+                // want this action to call a trigger.
142
+
143
+                //// Call triggers
144
+                //$result=$this->call_trigger('MYOBJECT_CREATE',$user);
145
+                //if ($result < 0) $error++;
146
+                //// End call triggers
147
+            }
148
+        }
149
+
150
+        // Commit or rollback
151
+        if ($error) {
152
+            $this->db->rollback();
153
+
154
+            return - 1 * $error;
155
+        } else {
156
+            $this->db->commit();
157
+
158
+            return $this->id;
159
+        }
160
+    }
161
+
162
+    /**
163
+     * Load object in memory from the database
164
+     *
165
+     * @param int    $id  Id object
166
+     * @param string $ref Ref
167
+     *
168
+     * @return int <0 if KO, 0 if not found, >0 if OK
169
+     */
170
+    public function fetch($id, $ref = null)
171
+    {
172
+        dol_syslog(__METHOD__, LOG_DEBUG);
173
+
174
+        $sql = 'SELECT';
175
+        $sql .= ' t.idType,';
176 176
 		
177
-		$sql .= " t.numero,";
178
-		$sql .= " t.nom,";
179
-		$sql .= " t.active";
177
+        $sql .= " t.numero,";
178
+        $sql .= " t.nom,";
179
+        $sql .= " t.active";
180 180
 
181 181
 		
182
-		$sql .= ' FROM ' . MAIN_DB_PREFIX . $this->table_element . ' as t';
183
-		if (null !== $ref) {
184
-			$sql .= ' WHERE t.ref = ' . '\'' . $ref . '\'';
185
-		} else {
186
-			$sql .= ' WHERE t.idType = ' . $id;
187
-		}
188
-
189
-		$resql = $this->db->query($sql);
190
-		if ($resql) {
191
-			$numrows = $this->db->num_rows($resql);
192
-			if ($numrows) {
193
-				$obj = $this->db->fetch_object($resql);
194
-
195
-				$this->id = $obj->idType;
182
+        $sql .= ' FROM ' . MAIN_DB_PREFIX . $this->table_element . ' as t';
183
+        if (null !== $ref) {
184
+            $sql .= ' WHERE t.ref = ' . '\'' . $ref . '\'';
185
+        } else {
186
+            $sql .= ' WHERE t.idType = ' . $id;
187
+        }
188
+
189
+        $resql = $this->db->query($sql);
190
+        if ($resql) {
191
+            $numrows = $this->db->num_rows($resql);
192
+            if ($numrows) {
193
+                $obj = $this->db->fetch_object($resql);
194
+
195
+                $this->id = $obj->idType;
196 196
 				
197
-				$this->idType = $obj->idType;
198
-				$this->numero = $obj->numero;
199
-				$this->nom = $obj->nom;
200
-				$this->active = $obj->active;
197
+                $this->idType = $obj->idType;
198
+                $this->numero = $obj->numero;
199
+                $this->nom = $obj->nom;
200
+                $this->active = $obj->active;
201 201
 
202 202
 				
203
-			}
204
-			$this->db->free($resql);
205
-
206
-			if ($numrows) {
207
-				return 1;
208
-			} else {
209
-				return 0;
210
-			}
211
-		} else {
212
-			$this->errors[] = 'Error ' . $this->db->lasterror();
213
-			dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
214
-
215
-			return - 1;
216
-		}
217
-	}
218
-
219
-	/**
220
-	 * Load object in memory from the database
221
-	 *
222
-	 * @param string $sortorder Sort Order
223
-	 * @param string $sortfield Sort field
224
-	 * @param int    $limit     offset limit
225
-	 * @param int    $offset    offset limit
226
-	 * @param array  $filter    filter array
227
-	 * @param string $filtermode filter mode (AND or OR)
228
-	 *
229
-	 * @return int <0 if KO, >0 if OK
230
-	 */
231
-	public function fetchAll($sortorder='', $sortfield='', $limit=0, $offset=0, array $filter = array(), $filtermode='AND')
232
-	{
233
-		dol_syslog(__METHOD__, LOG_DEBUG);
234
-
235
-		$sql = 'SELECT';
236
-		$sql .= " t.idType,";
237
-		$sql .= " t.numero,";
238
-		$sql .= " t.nom,";
239
-		$sql .= " t.active";
203
+            }
204
+            $this->db->free($resql);
205
+
206
+            if ($numrows) {
207
+                return 1;
208
+            } else {
209
+                return 0;
210
+            }
211
+        } else {
212
+            $this->errors[] = 'Error ' . $this->db->lasterror();
213
+            dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
214
+
215
+            return - 1;
216
+        }
217
+    }
218
+
219
+    /**
220
+     * Load object in memory from the database
221
+     *
222
+     * @param string $sortorder Sort Order
223
+     * @param string $sortfield Sort field
224
+     * @param int    $limit     offset limit
225
+     * @param int    $offset    offset limit
226
+     * @param array  $filter    filter array
227
+     * @param string $filtermode filter mode (AND or OR)
228
+     *
229
+     * @return int <0 if KO, >0 if OK
230
+     */
231
+    public function fetchAll($sortorder='', $sortfield='', $limit=0, $offset=0, array $filter = array(), $filtermode='AND')
232
+    {
233
+        dol_syslog(__METHOD__, LOG_DEBUG);
234
+
235
+        $sql = 'SELECT';
236
+        $sql .= " t.idType,";
237
+        $sql .= " t.numero,";
238
+        $sql .= " t.nom,";
239
+        $sql .= " t.active";
240 240
 
241 241
 		
242
-		$sql .= ' FROM ' . MAIN_DB_PREFIX . $this->table_element. ' as t';
242
+        $sql .= ' FROM ' . MAIN_DB_PREFIX . $this->table_element. ' as t';
243 243
 
244
-		// Manage filter
245
-		$sqlwhere = array();
244
+        // Manage filter
245
+        $sqlwhere = array();
246 246
 
247
-		foreach ($filter as $key => $value) {
248
-		    if(is_string($value)){
247
+        foreach ($filter as $key => $value) {
248
+            if(is_string($value)){
249 249
                 $sqlwhere [] = $key . ' LIKE \'%' . $this->db->escape($value) . '%\'';
250 250
                 continue;
251 251
             }
@@ -256,232 +256,232 @@  discard block
 block discarded – undo
256 256
             }
257 257
         }
258 258
 
259
-		if (count($sqlwhere) > 0) {
260
-			$sql .= ' WHERE ' . implode(' '.$filtermode.' ', $sqlwhere);
261
-		}
259
+        if (count($sqlwhere) > 0) {
260
+            $sql .= ' WHERE ' . implode(' '.$filtermode.' ', $sqlwhere);
261
+        }
262 262
 		
263
-		if (!empty($sortfield)) {
264
-			$sql .= $this->db->order($sortfield,$sortorder);
265
-		}
266
-		if (!empty($limit)) {
267
-		 $sql .=  ' ' . $this->db->plimit($limit + 1, $offset);
268
-		}
269
-		$this->lines = array();
270
-
271
-		$resql = $this->db->query($sql);
272
-		if ($resql) {
273
-			$num = $this->db->num_rows($resql);
274
-
275
-			while ($obj = $this->db->fetch_object($resql)) {
276
-				$line = new BbctypesLine();
277
-
278
-				$line->id = $obj->idType;
279
-				$line->idType = $obj->idType;
280
-				$line->numero = $obj->numero;
281
-				$line->nom = $obj->nom;
282
-				$line->active = $obj->active;
283
-
284
-				$this->lines[$line->id] = $line;
285
-			}
286
-			$this->db->free($resql);
287
-
288
-			return $num;
289
-		} else {
290
-			$this->errors[] = 'Error ' . $this->db->lasterror();
291
-			dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
292
-
293
-			return - 1;
294
-		}
295
-	}
296
-
297
-	/**
298
-	 * Update object into database
299
-	 *
300
-	 * @param  User $user      User that modifies
301
-	 * @param  bool $notrigger false=launch triggers after, true=disable triggers
302
-	 *
303
-	 * @return int <0 if KO, >0 if OK
304
-	 */
305
-	public function update(User $user, $notrigger = false)
306
-	{
307
-		$error = 0;
308
-
309
-		dol_syslog(__METHOD__, LOG_DEBUG);
310
-
311
-		// Clean parameters
263
+        if (!empty($sortfield)) {
264
+            $sql .= $this->db->order($sortfield,$sortorder);
265
+        }
266
+        if (!empty($limit)) {
267
+            $sql .=  ' ' . $this->db->plimit($limit + 1, $offset);
268
+        }
269
+        $this->lines = array();
270
+
271
+        $resql = $this->db->query($sql);
272
+        if ($resql) {
273
+            $num = $this->db->num_rows($resql);
274
+
275
+            while ($obj = $this->db->fetch_object($resql)) {
276
+                $line = new BbctypesLine();
277
+
278
+                $line->id = $obj->idType;
279
+                $line->idType = $obj->idType;
280
+                $line->numero = $obj->numero;
281
+                $line->nom = $obj->nom;
282
+                $line->active = $obj->active;
283
+
284
+                $this->lines[$line->id] = $line;
285
+            }
286
+            $this->db->free($resql);
287
+
288
+            return $num;
289
+        } else {
290
+            $this->errors[] = 'Error ' . $this->db->lasterror();
291
+            dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
292
+
293
+            return - 1;
294
+        }
295
+    }
296
+
297
+    /**
298
+     * Update object into database
299
+     *
300
+     * @param  User $user      User that modifies
301
+     * @param  bool $notrigger false=launch triggers after, true=disable triggers
302
+     *
303
+     * @return int <0 if KO, >0 if OK
304
+     */
305
+    public function update(User $user, $notrigger = false)
306
+    {
307
+        $error = 0;
308
+
309
+        dol_syslog(__METHOD__, LOG_DEBUG);
310
+
311
+        // Clean parameters
312 312
 		
313
-		if (isset($this->idType)) {
314
-			 $this->idType = trim($this->idType);
315
-		}
316
-		if (isset($this->numero)) {
317
-			 $this->numero = trim($this->numero);
318
-		}
319
-		if (isset($this->nom)) {
320
-			 $this->nom = trim($this->nom);
321
-		}
322
-		if (isset($this->active)) {
323
-			 $this->active = trim($this->active);
324
-		}
313
+        if (isset($this->idType)) {
314
+                $this->idType = trim($this->idType);
315
+        }
316
+        if (isset($this->numero)) {
317
+                $this->numero = trim($this->numero);
318
+        }
319
+        if (isset($this->nom)) {
320
+                $this->nom = trim($this->nom);
321
+        }
322
+        if (isset($this->active)) {
323
+                $this->active = trim($this->active);
324
+        }
325 325
 
326 326
 		
327 327
 
328
-		// Check parameters
329
-		// Put here code to add a control on parameters values
328
+        // Check parameters
329
+        // Put here code to add a control on parameters values
330 330
 
331
-		// Update request
332
-		$sql = 'UPDATE ' . MAIN_DB_PREFIX . $this->table_element . ' SET';
331
+        // Update request
332
+        $sql = 'UPDATE ' . MAIN_DB_PREFIX . $this->table_element . ' SET';
333 333
 		
334
-		$sql .= ' numero = '.(isset($this->numero)?$this->numero:"null").',';
335
-		$sql .= ' nom = '.(isset($this->nom)?"'".$this->db->escape($this->nom)."'":"null").',';
336
-		$sql .= ' active = '.(isset($this->active)?$this->active:"null");
334
+        $sql .= ' numero = '.(isset($this->numero)?$this->numero:"null").',';
335
+        $sql .= ' nom = '.(isset($this->nom)?"'".$this->db->escape($this->nom)."'":"null").',';
336
+        $sql .= ' active = '.(isset($this->active)?$this->active:"null");
337 337
 
338 338
         
339
-		$sql .= ' WHERE idType=' . $this->id;
340
-
341
-		$this->db->begin();
342
-
343
-		$resql = $this->db->query($sql);
344
-		if (!$resql) {
345
-			$error ++;
346
-			$this->errors[] = 'Error ' . $this->db->lasterror();
347
-			dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
348
-		}
349
-
350
-		if (!$error && !$notrigger) {
351
-			// Uncomment this and change MYOBJECT to your own tag if you
352
-			// want this action calls a trigger.
353
-
354
-			//// Call triggers
355
-			//$result=$this->call_trigger('MYOBJECT_MODIFY',$user);
356
-			//if ($result < 0) { $error++; //Do also what you must do to rollback action if trigger fail}
357
-			//// End call triggers
358
-		}
359
-
360
-		// Commit or rollback
361
-		if ($error) {
362
-			$this->db->rollback();
363
-
364
-			return - 1 * $error;
365
-		} else {
366
-			$this->db->commit();
367
-
368
-			return 1;
369
-		}
370
-	}
371
-
372
-	/**
373
-	 * Delete object in database
374
-	 *
375
-	 * @param User $user      User that deletes
376
-	 * @param bool $notrigger false=launch triggers after, true=disable triggers
377
-	 *
378
-	 * @return int <0 if KO, >0 if OK
379
-	 */
380
-	public function delete(User $user, $notrigger = false)
381
-	{
382
-		dol_syslog(__METHOD__, LOG_DEBUG);
383
-
384
-		$error = 0;
385
-
386
-		$this->db->begin();
387
-
388
-		if (!$error) {
389
-			if (!$notrigger) {
390
-				// Uncomment this and change MYOBJECT to your own tag if you
391
-				// want this action calls a trigger.
392
-
393
-				//// Call triggers
394
-				//$result=$this->call_trigger('MYOBJECT_DELETE',$user);
395
-				//if ($result < 0) { $error++; //Do also what you must do to rollback action if trigger fail}
396
-				//// End call triggers
397
-			}
398
-		}
399
-
400
-		if (!$error) {
401
-			$sql = 'DELETE FROM ' . MAIN_DB_PREFIX . $this->table_element;
402
-			$sql .= ' WHERE idType=' . $this->id;
403
-
404
-			$resql = $this->db->query($sql);
405
-			if (!$resql) {
406
-				$error ++;
407
-				$this->errors[] = 'Error ' . $this->db->lasterror();
408
-				dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
409
-			}
410
-		}
411
-
412
-		// Commit or rollback
413
-		if ($error) {
414
-			$this->db->rollback();
415
-
416
-			return - 1 * $error;
417
-		} else {
418
-			$this->db->commit();
419
-
420
-			return 1;
421
-		}
422
-	}
423
-
424
-	/**
425
-	 * Load an object from its id and create a new one in database
426
-	 *
427
-	 * @param int $fromid Id of object to clone
428
-	 *
429
-	 * @return int New id of clone
430
-	 */
431
-	public function createFromClone($fromid)
432
-	{
433
-		dol_syslog(__METHOD__, LOG_DEBUG);
434
-
435
-		global $user;
436
-		$error = 0;
437
-		$object = new Bbctypes($this->db);
438
-
439
-		$this->db->begin();
440
-
441
-		// Load source object
442
-		$object->fetch($fromid);
443
-		// Reset object
444
-		$object->id = 0;
445
-
446
-		// Clear fields
447
-		// ...
448
-
449
-		// Create clone
450
-		$result = $object->create($user);
451
-
452
-		// Other options
453
-		if ($result < 0) {
454
-			$error ++;
455
-			$this->errors = $object->errors;
456
-			dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
457
-		}
458
-
459
-		// End
460
-		if (!$error) {
461
-			$this->db->commit();
462
-
463
-			return $object->id;
464
-		} else {
465
-			$this->db->rollback();
466
-
467
-			return - 1;
468
-		}
469
-	}
470
-
471
-	/**
472
-	 *  Return a link to the user card (with optionaly the picto)
473
-	 * 	Use this->id,this->lastname, this->firstname
474
-	 *
475
-	 *	@param	int		$withpicto			Include picto in link (0=No picto, 1=Include picto into link, 2=Only picto)
476
-	 *	@param	string	$option				On what the link point to
339
+        $sql .= ' WHERE idType=' . $this->id;
340
+
341
+        $this->db->begin();
342
+
343
+        $resql = $this->db->query($sql);
344
+        if (!$resql) {
345
+            $error ++;
346
+            $this->errors[] = 'Error ' . $this->db->lasterror();
347
+            dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
348
+        }
349
+
350
+        if (!$error && !$notrigger) {
351
+            // Uncomment this and change MYOBJECT to your own tag if you
352
+            // want this action calls a trigger.
353
+
354
+            //// Call triggers
355
+            //$result=$this->call_trigger('MYOBJECT_MODIFY',$user);
356
+            //if ($result < 0) { $error++; //Do also what you must do to rollback action if trigger fail}
357
+            //// End call triggers
358
+        }
359
+
360
+        // Commit or rollback
361
+        if ($error) {
362
+            $this->db->rollback();
363
+
364
+            return - 1 * $error;
365
+        } else {
366
+            $this->db->commit();
367
+
368
+            return 1;
369
+        }
370
+    }
371
+
372
+    /**
373
+     * Delete object in database
374
+     *
375
+     * @param User $user      User that deletes
376
+     * @param bool $notrigger false=launch triggers after, true=disable triggers
377
+     *
378
+     * @return int <0 if KO, >0 if OK
379
+     */
380
+    public function delete(User $user, $notrigger = false)
381
+    {
382
+        dol_syslog(__METHOD__, LOG_DEBUG);
383
+
384
+        $error = 0;
385
+
386
+        $this->db->begin();
387
+
388
+        if (!$error) {
389
+            if (!$notrigger) {
390
+                // Uncomment this and change MYOBJECT to your own tag if you
391
+                // want this action calls a trigger.
392
+
393
+                //// Call triggers
394
+                //$result=$this->call_trigger('MYOBJECT_DELETE',$user);
395
+                //if ($result < 0) { $error++; //Do also what you must do to rollback action if trigger fail}
396
+                //// End call triggers
397
+            }
398
+        }
399
+
400
+        if (!$error) {
401
+            $sql = 'DELETE FROM ' . MAIN_DB_PREFIX . $this->table_element;
402
+            $sql .= ' WHERE idType=' . $this->id;
403
+
404
+            $resql = $this->db->query($sql);
405
+            if (!$resql) {
406
+                $error ++;
407
+                $this->errors[] = 'Error ' . $this->db->lasterror();
408
+                dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
409
+            }
410
+        }
411
+
412
+        // Commit or rollback
413
+        if ($error) {
414
+            $this->db->rollback();
415
+
416
+            return - 1 * $error;
417
+        } else {
418
+            $this->db->commit();
419
+
420
+            return 1;
421
+        }
422
+    }
423
+
424
+    /**
425
+     * Load an object from its id and create a new one in database
426
+     *
427
+     * @param int $fromid Id of object to clone
428
+     *
429
+     * @return int New id of clone
430
+     */
431
+    public function createFromClone($fromid)
432
+    {
433
+        dol_syslog(__METHOD__, LOG_DEBUG);
434
+
435
+        global $user;
436
+        $error = 0;
437
+        $object = new Bbctypes($this->db);
438
+
439
+        $this->db->begin();
440
+
441
+        // Load source object
442
+        $object->fetch($fromid);
443
+        // Reset object
444
+        $object->id = 0;
445
+
446
+        // Clear fields
447
+        // ...
448
+
449
+        // Create clone
450
+        $result = $object->create($user);
451
+
452
+        // Other options
453
+        if ($result < 0) {
454
+            $error ++;
455
+            $this->errors = $object->errors;
456
+            dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
457
+        }
458
+
459
+        // End
460
+        if (!$error) {
461
+            $this->db->commit();
462
+
463
+            return $object->id;
464
+        } else {
465
+            $this->db->rollback();
466
+
467
+            return - 1;
468
+        }
469
+    }
470
+
471
+    /**
472
+     *  Return a link to the user card (with optionaly the picto)
473
+     * 	Use this->id,this->lastname, this->firstname
474
+     *
475
+     *	@param	int		$withpicto			Include picto in link (0=No picto, 1=Include picto into link, 2=Only picto)
476
+     *	@param	string	$option				On what the link point to
477 477
      *  @param	integer	$notooltip			1=Disable tooltip
478 478
      *  @param	int		$maxlen				Max length of visible user name
479 479
      *  @param  string  $morecss            Add more css on link
480
-	 *	@return	string						String with URL
481
-	 */
482
-	function getNomUrl($withpicto=0, $option='', $notooltip=0, $maxlen=24, $morecss='')
483
-	{
484
-		global $langs, $conf, $db;
480
+     *	@return	string						String with URL
481
+     */
482
+    function getNomUrl($withpicto=0, $option='', $notooltip=0, $maxlen=24, $morecss='')
483
+    {
484
+        global $langs, $conf, $db;
485 485
         global $dolibarr_main_authentication, $dolibarr_main_demo;
486 486
         global $menumanager;
487 487
 
@@ -496,92 +496,92 @@  discard block
 block discarded – undo
496 496
         $link = '<a href="'.DOL_URL_ROOT.'/flightLog/card.php?id='.$this->id.'"';
497 497
         $link.= ($notooltip?'':' title="'.dol_escape_htmltag($label, 1).'" class="classfortooltip'.($morecss?' '.$morecss:'').'"');
498 498
         $link.= '>';
499
-		$linkend='</a>';
499
+        $linkend='</a>';
500 500
 
501 501
         if ($withpicto)
502 502
         {
503 503
             $result.=($link.img_object(($notooltip?'':$label), 'label', ($notooltip?'':'class="classfortooltip"')).$linkend);
504 504
             if ($withpicto != 2) $result.=' ';
505
-		}
506
-		$result.= $link . $this->ref . $linkend;
507
-		return $result;
508
-	}
505
+        }
506
+        $result.= $link . $this->ref . $linkend;
507
+        return $result;
508
+    }
509 509
 	
510
-	/**
511
-	 *  Retourne le libelle du status d'un user (actif, inactif)
512
-	 *
513
-	 *  @param	int		$mode          0=libelle long, 1=libelle court, 2=Picto + Libelle court, 3=Picto, 4=Picto + Libelle long, 5=Libelle court + Picto
514
-	 *  @return	string 			       Label of status
515
-	 */
516
-	function getLibStatut($mode=0)
517
-	{
518
-		return $this->LibStatut($this->status,$mode);
519
-	}
520
-
521
-	/**
522
-	 *  Renvoi le libelle d'un status donne
523
-	 *
524
-	 *  @param	int		$status        	Id status
525
-	 *  @param  int		$mode          	0=libelle long, 1=libelle court, 2=Picto + Libelle court, 3=Picto, 4=Picto + Libelle long, 5=Libelle court + Picto
526
-	 *  @return string 			       	Label of status
527
-	 */
528
-	function LibStatut($status,$mode=0)
529
-	{
530
-		global $langs;
531
-
532
-		if ($mode == 0)
533
-		{
534
-			$prefix='';
535
-			if ($status == 1) return $langs->trans('Enabled');
536
-			if ($status == 0) return $langs->trans('Disabled');
537
-		}
538
-		if ($mode == 1)
539
-		{
540
-			if ($status == 1) return $langs->trans('Enabled');
541
-			if ($status == 0) return $langs->trans('Disabled');
542
-		}
543
-		if ($mode == 2)
544
-		{
545
-			if ($status == 1) return img_picto($langs->trans('Enabled'),'statut4').' '.$langs->trans('Enabled');
546
-			if ($status == 0) return img_picto($langs->trans('Disabled'),'statut5').' '.$langs->trans('Disabled');
547
-		}
548
-		if ($mode == 3)
549
-		{
550
-			if ($status == 1) return img_picto($langs->trans('Enabled'),'statut4');
551
-			if ($status == 0) return img_picto($langs->trans('Disabled'),'statut5');
552
-		}
553
-		if ($mode == 4)
554
-		{
555
-			if ($status == 1) return img_picto($langs->trans('Enabled'),'statut4').' '.$langs->trans('Enabled');
556
-			if ($status == 0) return img_picto($langs->trans('Disabled'),'statut5').' '.$langs->trans('Disabled');
557
-		}
558
-		if ($mode == 5)
559
-		{
560
-			if ($status == 1) return $langs->trans('Enabled').' '.img_picto($langs->trans('Enabled'),'statut4');
561
-			if ($status == 0) return $langs->trans('Disabled').' '.img_picto($langs->trans('Disabled'),'statut5');
562
-		}
563
-
564
-		return "";
565
-	}
510
+    /**
511
+     *  Retourne le libelle du status d'un user (actif, inactif)
512
+     *
513
+     *  @param	int		$mode          0=libelle long, 1=libelle court, 2=Picto + Libelle court, 3=Picto, 4=Picto + Libelle long, 5=Libelle court + Picto
514
+     *  @return	string 			       Label of status
515
+     */
516
+    function getLibStatut($mode=0)
517
+    {
518
+        return $this->LibStatut($this->status,$mode);
519
+    }
520
+
521
+    /**
522
+     *  Renvoi le libelle d'un status donne
523
+     *
524
+     *  @param	int		$status        	Id status
525
+     *  @param  int		$mode          	0=libelle long, 1=libelle court, 2=Picto + Libelle court, 3=Picto, 4=Picto + Libelle long, 5=Libelle court + Picto
526
+     *  @return string 			       	Label of status
527
+     */
528
+    function LibStatut($status,$mode=0)
529
+    {
530
+        global $langs;
531
+
532
+        if ($mode == 0)
533
+        {
534
+            $prefix='';
535
+            if ($status == 1) return $langs->trans('Enabled');
536
+            if ($status == 0) return $langs->trans('Disabled');
537
+        }
538
+        if ($mode == 1)
539
+        {
540
+            if ($status == 1) return $langs->trans('Enabled');
541
+            if ($status == 0) return $langs->trans('Disabled');
542
+        }
543
+        if ($mode == 2)
544
+        {
545
+            if ($status == 1) return img_picto($langs->trans('Enabled'),'statut4').' '.$langs->trans('Enabled');
546
+            if ($status == 0) return img_picto($langs->trans('Disabled'),'statut5').' '.$langs->trans('Disabled');
547
+        }
548
+        if ($mode == 3)
549
+        {
550
+            if ($status == 1) return img_picto($langs->trans('Enabled'),'statut4');
551
+            if ($status == 0) return img_picto($langs->trans('Disabled'),'statut5');
552
+        }
553
+        if ($mode == 4)
554
+        {
555
+            if ($status == 1) return img_picto($langs->trans('Enabled'),'statut4').' '.$langs->trans('Enabled');
556
+            if ($status == 0) return img_picto($langs->trans('Disabled'),'statut5').' '.$langs->trans('Disabled');
557
+        }
558
+        if ($mode == 5)
559
+        {
560
+            if ($status == 1) return $langs->trans('Enabled').' '.img_picto($langs->trans('Enabled'),'statut4');
561
+            if ($status == 0) return $langs->trans('Disabled').' '.img_picto($langs->trans('Disabled'),'statut5');
562
+        }
563
+
564
+        return "";
565
+    }
566 566
 	
567 567
 	
568
-	/**
569
-	 * Initialise object with example values
570
-	 * Id must be 0 if object instance is a specimen
571
-	 *
572
-	 * @return void
573
-	 */
574
-	public function initAsSpecimen()
575
-	{
576
-		$this->id = 0;
568
+    /**
569
+     * Initialise object with example values
570
+     * Id must be 0 if object instance is a specimen
571
+     *
572
+     * @return void
573
+     */
574
+    public function initAsSpecimen()
575
+    {
576
+        $this->id = 0;
577 577
 		
578
-		$this->idType = '';
579
-		$this->numero = '';
580
-		$this->nom = '';
581
-		$this->active = '';
578
+        $this->idType = '';
579
+        $this->numero = '';
580
+        $this->nom = '';
581
+        $this->active = '';
582 582
 
583 583
 		
584
-	}
584
+    }
585 585
 
586 586
 }
587 587
 
@@ -590,21 +590,21 @@  discard block
 block discarded – undo
590 590
  */
591 591
 class BbctypesLine
592 592
 {
593
-	/**
594
-	 * @var int ID
595
-	 */
596
-	public $id;
597
-	/**
598
-	 * @var mixed Sample line property 1
599
-	 */
593
+    /**
594
+     * @var int ID
595
+     */
596
+    public $id;
597
+    /**
598
+     * @var mixed Sample line property 1
599
+     */
600 600
 	
601
-	public $idType;
602
-	public $numero;
603
-	public $nom;
604
-	public $active;
605
-
606
-	/**
607
-	 * @var mixed Sample line property 2
608
-	 */
601
+    public $idType;
602
+    public $numero;
603
+    public $nom;
604
+    public $active;
605
+
606
+    /**
607
+     * @var mixed Sample line property 2
608
+     */
609 609
 	
610 610
 }
Please login to merge, or discard this patch.
Spacing   +49 added lines, -49 removed lines patch added patch discarded remove patch
@@ -110,16 +110,16 @@  discard block
 block discarded – undo
110 110
 		// Insert request
111 111
 		$sql = 'INSERT INTO ' . MAIN_DB_PREFIX . $this->table_element . '(';
112 112
 		
113
-		$sql.= 'numero,';
114
-		$sql.= 'nom';
115
-		$sql.= 'active';
113
+		$sql .= 'numero,';
114
+		$sql .= 'nom';
115
+		$sql .= 'active';
116 116
 
117 117
 		
118 118
 		$sql .= ') VALUES (';
119 119
 		
120
-		$sql .= ' '.(! isset($this->numero)?'NULL':$this->numero).',';
121
-		$sql .= ' '.(! isset($this->nom)?'NULL':"'".$this->db->escape($this->nom)."'").',';
122
-		$sql .= ' '.(! isset($this->active)?'NULL':$this->active);
120
+		$sql .= ' ' . (!isset($this->numero) ? 'NULL' : $this->numero) . ',';
121
+		$sql .= ' ' . (!isset($this->nom) ? 'NULL' : "'" . $this->db->escape($this->nom) . "'") . ',';
122
+		$sql .= ' ' . (!isset($this->active) ? 'NULL' : $this->active);
123 123
 
124 124
 		
125 125
 		$sql .= ')';
@@ -128,7 +128,7 @@  discard block
 block discarded – undo
128 128
 
129 129
 		$resql = $this->db->query($sql);
130 130
 		if (!$resql) {
131
-			$error ++;
131
+			$error++;
132 132
 			$this->errors[] = 'Error ' . $this->db->lasterror();
133 133
 			dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
134 134
 		}
@@ -151,7 +151,7 @@  discard block
 block discarded – undo
151 151
 		if ($error) {
152 152
 			$this->db->rollback();
153 153
 
154
-			return - 1 * $error;
154
+			return -1 * $error;
155 155
 		} else {
156 156
 			$this->db->commit();
157 157
 
@@ -212,7 +212,7 @@  discard block
 block discarded – undo
212 212
 			$this->errors[] = 'Error ' . $this->db->lasterror();
213 213
 			dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
214 214
 
215
-			return - 1;
215
+			return -1;
216 216
 		}
217 217
 	}
218 218
 
@@ -228,7 +228,7 @@  discard block
 block discarded – undo
228 228
 	 *
229 229
 	 * @return int <0 if KO, >0 if OK
230 230
 	 */
231
-	public function fetchAll($sortorder='', $sortfield='', $limit=0, $offset=0, array $filter = array(), $filtermode='AND')
231
+	public function fetchAll($sortorder = '', $sortfield = '', $limit = 0, $offset = 0, array $filter = array(), $filtermode = 'AND')
232 232
 	{
233 233
 		dol_syslog(__METHOD__, LOG_DEBUG);
234 234
 
@@ -239,32 +239,32 @@  discard block
 block discarded – undo
239 239
 		$sql .= " t.active";
240 240
 
241 241
 		
242
-		$sql .= ' FROM ' . MAIN_DB_PREFIX . $this->table_element. ' as t';
242
+		$sql .= ' FROM ' . MAIN_DB_PREFIX . $this->table_element . ' as t';
243 243
 
244 244
 		// Manage filter
245 245
 		$sqlwhere = array();
246 246
 
247 247
 		foreach ($filter as $key => $value) {
248
-		    if(is_string($value)){
248
+		    if (is_string($value)) {
249 249
                 $sqlwhere [] = $key . ' LIKE \'%' . $this->db->escape($value) . '%\'';
250 250
                 continue;
251 251
             }
252 252
 
253
-            if(is_int($value)){
254
-                $sqlwhere [] = $key . ' = ' .(int)$value;
253
+            if (is_int($value)) {
254
+                $sqlwhere [] = $key . ' = ' . (int) $value;
255 255
                 continue;
256 256
             }
257 257
         }
258 258
 
259 259
 		if (count($sqlwhere) > 0) {
260
-			$sql .= ' WHERE ' . implode(' '.$filtermode.' ', $sqlwhere);
260
+			$sql .= ' WHERE ' . implode(' ' . $filtermode . ' ', $sqlwhere);
261 261
 		}
262 262
 		
263 263
 		if (!empty($sortfield)) {
264
-			$sql .= $this->db->order($sortfield,$sortorder);
264
+			$sql .= $this->db->order($sortfield, $sortorder);
265 265
 		}
266 266
 		if (!empty($limit)) {
267
-		 $sql .=  ' ' . $this->db->plimit($limit + 1, $offset);
267
+		 $sql .= ' ' . $this->db->plimit($limit + 1, $offset);
268 268
 		}
269 269
 		$this->lines = array();
270 270
 
@@ -290,7 +290,7 @@  discard block
 block discarded – undo
290 290
 			$this->errors[] = 'Error ' . $this->db->lasterror();
291 291
 			dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
292 292
 
293
-			return - 1;
293
+			return -1;
294 294
 		}
295 295
 	}
296 296
 
@@ -331,9 +331,9 @@  discard block
 block discarded – undo
331 331
 		// Update request
332 332
 		$sql = 'UPDATE ' . MAIN_DB_PREFIX . $this->table_element . ' SET';
333 333
 		
334
-		$sql .= ' numero = '.(isset($this->numero)?$this->numero:"null").',';
335
-		$sql .= ' nom = '.(isset($this->nom)?"'".$this->db->escape($this->nom)."'":"null").',';
336
-		$sql .= ' active = '.(isset($this->active)?$this->active:"null");
334
+		$sql .= ' numero = ' . (isset($this->numero) ? $this->numero : "null") . ',';
335
+		$sql .= ' nom = ' . (isset($this->nom) ? "'" . $this->db->escape($this->nom) . "'" : "null") . ',';
336
+		$sql .= ' active = ' . (isset($this->active) ? $this->active : "null");
337 337
 
338 338
         
339 339
 		$sql .= ' WHERE idType=' . $this->id;
@@ -342,7 +342,7 @@  discard block
 block discarded – undo
342 342
 
343 343
 		$resql = $this->db->query($sql);
344 344
 		if (!$resql) {
345
-			$error ++;
345
+			$error++;
346 346
 			$this->errors[] = 'Error ' . $this->db->lasterror();
347 347
 			dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
348 348
 		}
@@ -361,7 +361,7 @@  discard block
 block discarded – undo
361 361
 		if ($error) {
362 362
 			$this->db->rollback();
363 363
 
364
-			return - 1 * $error;
364
+			return -1 * $error;
365 365
 		} else {
366 366
 			$this->db->commit();
367 367
 
@@ -403,7 +403,7 @@  discard block
 block discarded – undo
403 403
 
404 404
 			$resql = $this->db->query($sql);
405 405
 			if (!$resql) {
406
-				$error ++;
406
+				$error++;
407 407
 				$this->errors[] = 'Error ' . $this->db->lasterror();
408 408
 				dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
409 409
 			}
@@ -413,7 +413,7 @@  discard block
 block discarded – undo
413 413
 		if ($error) {
414 414
 			$this->db->rollback();
415 415
 
416
-			return - 1 * $error;
416
+			return -1 * $error;
417 417
 		} else {
418 418
 			$this->db->commit();
419 419
 
@@ -451,7 +451,7 @@  discard block
 block discarded – undo
451 451
 
452 452
 		// Other options
453 453
 		if ($result < 0) {
454
-			$error ++;
454
+			$error++;
455 455
 			$this->errors = $object->errors;
456 456
 			dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
457 457
 		}
@@ -464,7 +464,7 @@  discard block
 block discarded – undo
464 464
 		} else {
465 465
 			$this->db->rollback();
466 466
 
467
-			return - 1;
467
+			return -1;
468 468
 		}
469 469
 	}
470 470
 
@@ -479,7 +479,7 @@  discard block
 block discarded – undo
479 479
      *  @param  string  $morecss            Add more css on link
480 480
 	 *	@return	string						String with URL
481 481
 	 */
482
-	function getNomUrl($withpicto=0, $option='', $notooltip=0, $maxlen=24, $morecss='')
482
+	function getNomUrl($withpicto = 0, $option = '', $notooltip = 0, $maxlen = 24, $morecss = '')
483 483
 	{
484 484
 		global $langs, $conf, $db;
485 485
         global $dolibarr_main_authentication, $dolibarr_main_demo;
@@ -490,20 +490,20 @@  discard block
 block discarded – undo
490 490
         $companylink = '';
491 491
 
492 492
         $label = '<u>' . $langs->trans("MyModule") . '</u>';
493
-        $label.= '<div width="100%">';
494
-        $label.= '<b>' . $langs->trans('Ref') . ':</b> ' . $this->ref;
493
+        $label .= '<div width="100%">';
494
+        $label .= '<b>' . $langs->trans('Ref') . ':</b> ' . $this->ref;
495 495
 
496
-        $link = '<a href="'.DOL_URL_ROOT.'/flightLog/card.php?id='.$this->id.'"';
497
-        $link.= ($notooltip?'':' title="'.dol_escape_htmltag($label, 1).'" class="classfortooltip'.($morecss?' '.$morecss:'').'"');
498
-        $link.= '>';
499
-		$linkend='</a>';
496
+        $link = '<a href="' . DOL_URL_ROOT . '/flightLog/card.php?id=' . $this->id . '"';
497
+        $link .= ($notooltip ? '' : ' title="' . dol_escape_htmltag($label, 1) . '" class="classfortooltip' . ($morecss ? ' ' . $morecss : '') . '"');
498
+        $link .= '>';
499
+		$linkend = '</a>';
500 500
 
501 501
         if ($withpicto)
502 502
         {
503
-            $result.=($link.img_object(($notooltip?'':$label), 'label', ($notooltip?'':'class="classfortooltip"')).$linkend);
504
-            if ($withpicto != 2) $result.=' ';
503
+            $result .= ($link . img_object(($notooltip ? '' : $label), 'label', ($notooltip ? '' : 'class="classfortooltip"')) . $linkend);
504
+            if ($withpicto != 2) $result .= ' ';
505 505
 		}
506
-		$result.= $link . $this->ref . $linkend;
506
+		$result .= $link . $this->ref . $linkend;
507 507
 		return $result;
508 508
 	}
509 509
 	
@@ -513,9 +513,9 @@  discard block
 block discarded – undo
513 513
 	 *  @param	int		$mode          0=libelle long, 1=libelle court, 2=Picto + Libelle court, 3=Picto, 4=Picto + Libelle long, 5=Libelle court + Picto
514 514
 	 *  @return	string 			       Label of status
515 515
 	 */
516
-	function getLibStatut($mode=0)
516
+	function getLibStatut($mode = 0)
517 517
 	{
518
-		return $this->LibStatut($this->status,$mode);
518
+		return $this->LibStatut($this->status, $mode);
519 519
 	}
520 520
 
521 521
 	/**
@@ -525,13 +525,13 @@  discard block
 block discarded – undo
525 525
 	 *  @param  int		$mode          	0=libelle long, 1=libelle court, 2=Picto + Libelle court, 3=Picto, 4=Picto + Libelle long, 5=Libelle court + Picto
526 526
 	 *  @return string 			       	Label of status
527 527
 	 */
528
-	function LibStatut($status,$mode=0)
528
+	function LibStatut($status, $mode = 0)
529 529
 	{
530 530
 		global $langs;
531 531
 
532 532
 		if ($mode == 0)
533 533
 		{
534
-			$prefix='';
534
+			$prefix = '';
535 535
 			if ($status == 1) return $langs->trans('Enabled');
536 536
 			if ($status == 0) return $langs->trans('Disabled');
537 537
 		}
@@ -542,23 +542,23 @@  discard block
 block discarded – undo
542 542
 		}
543 543
 		if ($mode == 2)
544 544
 		{
545
-			if ($status == 1) return img_picto($langs->trans('Enabled'),'statut4').' '.$langs->trans('Enabled');
546
-			if ($status == 0) return img_picto($langs->trans('Disabled'),'statut5').' '.$langs->trans('Disabled');
545
+			if ($status == 1) return img_picto($langs->trans('Enabled'), 'statut4') . ' ' . $langs->trans('Enabled');
546
+			if ($status == 0) return img_picto($langs->trans('Disabled'), 'statut5') . ' ' . $langs->trans('Disabled');
547 547
 		}
548 548
 		if ($mode == 3)
549 549
 		{
550
-			if ($status == 1) return img_picto($langs->trans('Enabled'),'statut4');
551
-			if ($status == 0) return img_picto($langs->trans('Disabled'),'statut5');
550
+			if ($status == 1) return img_picto($langs->trans('Enabled'), 'statut4');
551
+			if ($status == 0) return img_picto($langs->trans('Disabled'), 'statut5');
552 552
 		}
553 553
 		if ($mode == 4)
554 554
 		{
555
-			if ($status == 1) return img_picto($langs->trans('Enabled'),'statut4').' '.$langs->trans('Enabled');
556
-			if ($status == 0) return img_picto($langs->trans('Disabled'),'statut5').' '.$langs->trans('Disabled');
555
+			if ($status == 1) return img_picto($langs->trans('Enabled'), 'statut4') . ' ' . $langs->trans('Enabled');
556
+			if ($status == 0) return img_picto($langs->trans('Disabled'), 'statut5') . ' ' . $langs->trans('Disabled');
557 557
 		}
558 558
 		if ($mode == 5)
559 559
 		{
560
-			if ($status == 1) return $langs->trans('Enabled').' '.img_picto($langs->trans('Enabled'),'statut4');
561
-			if ($status == 0) return $langs->trans('Disabled').' '.img_picto($langs->trans('Disabled'),'statut5');
560
+			if ($status == 1) return $langs->trans('Enabled') . ' ' . img_picto($langs->trans('Enabled'), 'statut4');
561
+			if ($status == 0) return $langs->trans('Disabled') . ' ' . img_picto($langs->trans('Disabled'), 'statut5');
562 562
 		}
563 563
 
564 564
 		return "";
Please login to merge, or discard this patch.
Braces   +39 added lines, -13 removed lines patch added patch discarded remove patch
@@ -501,7 +501,9 @@  discard block
 block discarded – undo
501 501
         if ($withpicto)
502 502
         {
503 503
             $result.=($link.img_object(($notooltip?'':$label), 'label', ($notooltip?'':'class="classfortooltip"')).$linkend);
504
-            if ($withpicto != 2) $result.=' ';
504
+            if ($withpicto != 2) {
505
+                $result.=' ';
506
+            }
505 507
 		}
506 508
 		$result.= $link . $this->ref . $linkend;
507 509
 		return $result;
@@ -532,33 +534,57 @@  discard block
 block discarded – undo
532 534
 		if ($mode == 0)
533 535
 		{
534 536
 			$prefix='';
535
-			if ($status == 1) return $langs->trans('Enabled');
536
-			if ($status == 0) return $langs->trans('Disabled');
537
+			if ($status == 1) {
538
+			    return $langs->trans('Enabled');
539
+			}
540
+			if ($status == 0) {
541
+			    return $langs->trans('Disabled');
542
+			}
537 543
 		}
538 544
 		if ($mode == 1)
539 545
 		{
540
-			if ($status == 1) return $langs->trans('Enabled');
541
-			if ($status == 0) return $langs->trans('Disabled');
546
+			if ($status == 1) {
547
+			    return $langs->trans('Enabled');
548
+			}
549
+			if ($status == 0) {
550
+			    return $langs->trans('Disabled');
551
+			}
542 552
 		}
543 553
 		if ($mode == 2)
544 554
 		{
545
-			if ($status == 1) return img_picto($langs->trans('Enabled'),'statut4').' '.$langs->trans('Enabled');
546
-			if ($status == 0) return img_picto($langs->trans('Disabled'),'statut5').' '.$langs->trans('Disabled');
555
+			if ($status == 1) {
556
+			    return img_picto($langs->trans('Enabled'),'statut4').' '.$langs->trans('Enabled');
557
+			}
558
+			if ($status == 0) {
559
+			    return img_picto($langs->trans('Disabled'),'statut5').' '.$langs->trans('Disabled');
560
+			}
547 561
 		}
548 562
 		if ($mode == 3)
549 563
 		{
550
-			if ($status == 1) return img_picto($langs->trans('Enabled'),'statut4');
551
-			if ($status == 0) return img_picto($langs->trans('Disabled'),'statut5');
564
+			if ($status == 1) {
565
+			    return img_picto($langs->trans('Enabled'),'statut4');
566
+			}
567
+			if ($status == 0) {
568
+			    return img_picto($langs->trans('Disabled'),'statut5');
569
+			}
552 570
 		}
553 571
 		if ($mode == 4)
554 572
 		{
555
-			if ($status == 1) return img_picto($langs->trans('Enabled'),'statut4').' '.$langs->trans('Enabled');
556
-			if ($status == 0) return img_picto($langs->trans('Disabled'),'statut5').' '.$langs->trans('Disabled');
573
+			if ($status == 1) {
574
+			    return img_picto($langs->trans('Enabled'),'statut4').' '.$langs->trans('Enabled');
575
+			}
576
+			if ($status == 0) {
577
+			    return img_picto($langs->trans('Disabled'),'statut5').' '.$langs->trans('Disabled');
578
+			}
557 579
 		}
558 580
 		if ($mode == 5)
559 581
 		{
560
-			if ($status == 1) return $langs->trans('Enabled').' '.img_picto($langs->trans('Enabled'),'statut4');
561
-			if ($status == 0) return $langs->trans('Disabled').' '.img_picto($langs->trans('Disabled'),'statut5');
582
+			if ($status == 1) {
583
+			    return $langs->trans('Enabled').' '.img_picto($langs->trans('Enabled'),'statut4');
584
+			}
585
+			if ($status == 0) {
586
+			    return $langs->trans('Disabled').' '.img_picto($langs->trans('Disabled'),'statut5');
587
+			}
562 588
 		}
563 589
 
564 590
 		return "";
Please login to merge, or discard this patch.