@@ -73,7 +73,7 @@ discard block |
||
73 | 73 | public $justif_kilometers; |
74 | 74 | |
75 | 75 | /** |
76 | - * @return int |
|
76 | + * @return string |
|
77 | 77 | */ |
78 | 78 | public function getIdBBCVols() |
79 | 79 | { |
@@ -81,7 +81,7 @@ discard block |
||
81 | 81 | } |
82 | 82 | |
83 | 83 | /** |
84 | - * @return int |
|
84 | + * @return string |
|
85 | 85 | */ |
86 | 86 | public function getId() |
87 | 87 | { |
@@ -701,7 +701,7 @@ |
||
701 | 701 | |
702 | 702 | $label = '<u>' . $langs->trans("MyModule") . '</u>'; |
703 | 703 | $label .= '<div width="100%">'; |
704 | - $label .= '<b>' . $langs->trans('Ref') . ':</b> ' . $this->ref.'<br>'; |
|
704 | + $label .= '<b>' . $langs->trans('Ref') . ':</b> ' . $this->ref . '<br>'; |
|
705 | 705 | $label .= '<b>' . $langs->trans('Date') . ':</b> ' . $this->date; |
706 | 706 | $label .= '</div>'; |
707 | 707 |
@@ -100,9 +100,9 @@ discard block |
||
100 | 100 | * |
101 | 101 | * @param int|string $selected Preselected Balloon |
102 | 102 | * @param string $htmlname Name of field in form |
103 | - * @param bool $showempty Add an empty field |
|
104 | - * @param bool $showimmat |
|
105 | - * @param bool $showDeclasse |
|
103 | + * @param integer $showempty Add an empty field |
|
104 | + * @param integer $showimmat |
|
105 | + * @param integer $showDeclasse |
|
106 | 106 | */ |
107 | 107 | function select_balloons($selected = '', $htmlname = 'ballon', $showempty = 0, $showimmat = 0, $showDeclasse = 1) |
108 | 108 | { |
@@ -158,7 +158,7 @@ discard block |
||
158 | 158 | * |
159 | 159 | * @param int $quarter |
160 | 160 | * |
161 | - * @param bool $goupBy |
|
161 | + * @param bool $groupBy |
|
162 | 162 | * |
163 | 163 | * @return string |
164 | 164 | */ |
@@ -54,7 +54,7 @@ discard block |
||
54 | 54 | |
55 | 55 | $bbcTypes = new Bbctypes($db); |
56 | 56 | |
57 | - $bbcTypes->fetchAll('','',0,0, [ |
|
57 | + $bbcTypes->fetchAll('', '', 0, 0, [ |
|
58 | 58 | "active" => $active |
59 | 59 | ]); |
60 | 60 | |
@@ -78,7 +78,7 @@ discard block |
||
78 | 78 | |
79 | 79 | print '<select class="flat" name="' . $htmlname . '">'; |
80 | 80 | |
81 | - if($showempty){ |
|
81 | + if ($showempty) { |
|
82 | 82 | print sprintf('<option selected="%s" value=""></option>', (($selected == "" || $selected = 0 || $selected == -1) ? "selected" : "")); |
83 | 83 | } |
84 | 84 | |
@@ -88,7 +88,7 @@ discard block |
||
88 | 88 | print ' selected="selected"'; |
89 | 89 | } |
90 | 90 | print '>'; |
91 | - echo "T".$flightType->numero . '-' . $flightType->nom; |
|
91 | + echo "T" . $flightType->numero . '-' . $flightType->nom; |
|
92 | 92 | print "</option>"; |
93 | 93 | } |
94 | 94 | |
@@ -113,7 +113,7 @@ discard block |
||
113 | 113 | print '<select class="flat" name="' . $htmlname . '">'; |
114 | 114 | |
115 | 115 | print '<option value=""'; |
116 | - if ($selected == -1 || $selected == ''|| $selected == 0) { |
|
116 | + if ($selected == -1 || $selected == '' || $selected == 0) { |
|
117 | 117 | print ' selected="selected"'; |
118 | 118 | } |
119 | 119 | print '> </option>'; |
@@ -162,17 +162,17 @@ discard block |
||
162 | 162 | * |
163 | 163 | * @return string |
164 | 164 | */ |
165 | -function generateQuarterQuery($year = null, $pilotId = null, $quarter = null, $groupBy = true){ |
|
165 | +function generateQuarterQuery($year = null, $pilotId = null, $quarter = null, $groupBy = true) { |
|
166 | 166 | |
167 | 167 | global $db; |
168 | 168 | |
169 | 169 | $sql = "SELECT USR.rowid, USR.lastname, USR.firstname, QUARTER(VOL.date) as quartil "; |
170 | 170 | |
171 | - if($groupBy){ |
|
172 | - $sql.= " , SUM(VOL.kilometers) as SUM"; |
|
173 | - $sql.= " , COUNT(VOL.idBBC_vols) as nbrFlight"; |
|
174 | - }else{ |
|
175 | - $sql.= " , VOL.*"; |
|
171 | + if ($groupBy) { |
|
172 | + $sql .= " , SUM(VOL.kilometers) as SUM"; |
|
173 | + $sql .= " , COUNT(VOL.idBBC_vols) as nbrFlight"; |
|
174 | + } else { |
|
175 | + $sql .= " , VOL.*"; |
|
176 | 176 | } |
177 | 177 | |
178 | 178 | $sql .= " FROM llx_bbc_vols as VOL"; |
@@ -182,15 +182,15 @@ discard block |
||
182 | 182 | $sql .= " AND YEAR(VOL.date) = " . ($year ?: 'YEAR(NOW())'); |
183 | 183 | $sql .= " AND ( VOL.fk_type = 1 OR VOL.fk_type = 2 ) "; |
184 | 184 | |
185 | - if($pilotId){ |
|
186 | - $sql .= " AND USR.rowid = ".$pilotId; |
|
185 | + if ($pilotId) { |
|
186 | + $sql .= " AND USR.rowid = " . $pilotId; |
|
187 | 187 | } |
188 | 188 | |
189 | - if($quarter){ |
|
190 | - $sql .= " AND QUARTER(VOL.date) = ".$quarter; |
|
189 | + if ($quarter) { |
|
190 | + $sql .= " AND QUARTER(VOL.date) = " . $quarter; |
|
191 | 191 | } |
192 | 192 | |
193 | - if($groupBy){ |
|
193 | + if ($groupBy) { |
|
194 | 194 | $sql .= " GROUP BY QUARTER(VOL.date), VOL.fk_pilot"; |
195 | 195 | } |
196 | 196 | $sql .= " ORDER BY QUARTER(VOL.date), VOL.fk_pilot"; |
@@ -205,7 +205,7 @@ discard block |
||
205 | 205 | * |
206 | 206 | * @return array |
207 | 207 | */ |
208 | -function findFlightByPilotAndQuarter($pilotId, $year, $quarter){ |
|
208 | +function findFlightByPilotAndQuarter($pilotId, $year, $quarter) { |
|
209 | 209 | global $db; |
210 | 210 | |
211 | 211 | $sql = generateQuarterQuery($year, $pilotId, $quarter, false); |
@@ -329,7 +329,7 @@ discard block |
||
329 | 329 | print '</tr>'; |
330 | 330 | |
331 | 331 | foreach ($kmByQuartil as $id => $rembKm) { |
332 | - if(!$user->rights->flightLog->vol->detail && $id != $user->id){ |
|
332 | + if (!$user->rights->flightLog->vol->detail && $id != $user->id) { |
|
333 | 333 | continue; |
334 | 334 | } |
335 | 335 | |
@@ -481,10 +481,10 @@ discard block |
||
481 | 481 | |
482 | 482 | $graphData = new GraphicalData(); |
483 | 483 | |
484 | - foreach(getFlightYears() as $flightYear){ |
|
484 | + foreach (getFlightYears() as $flightYear) { |
|
485 | 485 | $pieceData = new YearGraphicalData($flightYear); |
486 | 486 | |
487 | - foreach($flightTypes as $flightType){ |
|
487 | + foreach ($flightTypes as $flightType) { |
|
488 | 488 | $pieceData->addType(new GraphicalType($flightType->id, $flightType->nom)); |
489 | 489 | } |
490 | 490 |
@@ -171,7 +171,7 @@ |
||
171 | 171 | if($groupBy){ |
172 | 172 | $sql.= " , SUM(VOL.kilometers) as SUM"; |
173 | 173 | $sql.= " , COUNT(VOL.idBBC_vols) as nbrFlight"; |
174 | - }else{ |
|
174 | + } else{ |
|
175 | 175 | $sql.= " , VOL.*"; |
176 | 176 | } |
177 | 177 |
@@ -61,8 +61,8 @@ |
||
61 | 61 | $form = new Form($db); |
62 | 62 | print '<!-- debut cartouche rapport --> |
63 | 63 | <div class="tabs"> |
64 | - <a id="'.($viewSelection == 1 ? 'active' : '').'" class="tab" href="listFact.php?view=1">Facturation</a> |
|
65 | - <a id="'.($viewSelection == 2 ? 'active' : '').'" class="tab" href="listFact.php?view=2">AVIABEL</a> |
|
64 | + <a id="'.($viewSelection == 1 ? 'active' : '') . '" class="tab" href="listFact.php?view=1">Facturation</a> |
|
65 | + <a id="'.($viewSelection == 2 ? 'active' : '') . '" class="tab" href="listFact.php?view=2">AVIABEL</a> |
|
66 | 66 | </div>'; |
67 | 67 | print '<div class="tabBar">'; |
68 | 68 | print "<form name='listFact' action=\"listFact.php\" method=\"get\">\n"; |
@@ -45,8 +45,8 @@ discard block |
||
45 | 45 | //il est titulaire d'un ballon |
46 | 46 | $query = 'SELECT * FROM llx_bbc_ballons'; |
47 | 47 | if (!$user->rights->flightLog->vol->detail) { |
48 | - $query.= ' WHERE `fk_responsable` = ' . $user->id; |
|
49 | - $query.= ' OR `fk_co_responsable` = ' . $user->id; |
|
48 | + $query .= ' WHERE `fk_responsable` = ' . $user->id; |
|
49 | + $query .= ' OR `fk_co_responsable` = ' . $user->id; |
|
50 | 50 | } |
51 | 51 | $resql = $db->query($query); |
52 | 52 | if ($resql) { |
@@ -85,15 +85,15 @@ discard block |
||
85 | 85 | $titulaire->fetch($ballon->fk_responsable); |
86 | 86 | //flight with balloon ID |
87 | 87 | $query = 'SELECT *, TIMEDIFF(heureA,heureD) AS time FROM llx_bbc_vols'; |
88 | - $query.= ' WHERE `BBC_ballons_idBBC_ballons` = ' . $ballon->id; |
|
88 | + $query .= ' WHERE `BBC_ballons_idBBC_ballons` = ' . $ballon->id; |
|
89 | 89 | if ($datep) { |
90 | - $query.= ' AND date >= \'' . dol_print_date($datep, 'dayrfc') . '\''; |
|
90 | + $query .= ' AND date >= \'' . dol_print_date($datep, 'dayrfc') . '\''; |
|
91 | 91 | } |
92 | 92 | if ($datef) { |
93 | - $query.= ' AND date <= \'' . dol_print_date($datef, 'dayrfc') . '\''; |
|
93 | + $query .= ' AND date <= \'' . dol_print_date($datef, 'dayrfc') . '\''; |
|
94 | 94 | } |
95 | 95 | |
96 | - $query.= ' ORDER BY date'; |
|
96 | + $query .= ' ORDER BY date'; |
|
97 | 97 | |
98 | 98 | $resql = $db->query($query); |
99 | 99 | } |
@@ -126,8 +126,8 @@ discard block |
||
126 | 126 | select_balloons($idBallon); |
127 | 127 | } else { |
128 | 128 | $query2 = 'SELECT * FROM llx_bbc_ballons'; |
129 | - $query2.= ' WHERE `fk_responsable` = ' . $user->id; |
|
130 | - $query2.= ' OR `fk_co_responsable` = ' . $user->id; |
|
129 | + $query2 .= ' WHERE `fk_responsable` = ' . $user->id; |
|
130 | + $query2 .= ' OR `fk_co_responsable` = ' . $user->id; |
|
131 | 131 | $resql2 = $db->query($query2); |
132 | 132 | if ($resql2) { |
133 | 133 | $num = $db->num_rows($resql2); |
@@ -217,7 +217,7 @@ discard block |
||
217 | 217 | print '<td>' . $obj->fk_type . '</td>'; |
218 | 218 | print '<td>' . $obj->date . '</td>'; |
219 | 219 | print '<td>' . $ballon->immat . '</td>'; |
220 | - print '<td>' . $pilot->getNomUrl(). '</td>'; |
|
220 | + print '<td>' . $pilot->getNomUrl() . '</td>'; |
|
221 | 221 | print '<td>' . $obj->lieuD . '</td>'; |
222 | 222 | print '<td>' . $obj->lieuA . '</td>'; |
223 | 223 | print '<td>' . $obj->heureD . '</td>'; |
@@ -231,7 +231,7 @@ discard block |
||
231 | 231 | if ($user->rights->flightLog->vol->status) { |
232 | 232 | $vol = new Bbcvols($db); |
233 | 233 | $vol->fetch($obj->idBBC_vols); |
234 | - print '<td>' . $vol->getStatus().'</td>'; |
|
234 | + print '<td>' . $vol->getStatus() . '</td>'; |
|
235 | 235 | } |
236 | 236 | } |
237 | 237 | print'</tr>'; |
@@ -169,15 +169,17 @@ |
||
169 | 169 | print '</tr>'; |
170 | 170 | } |
171 | 171 | // Date start |
172 | - if (GETPOST('datep', 'int', 1)) |
|
173 | - $datep = dol_stringtotime(GETPOST('datep', 'int', 1), 0); |
|
172 | + if (GETPOST('datep', 'int', 1)) { |
|
173 | + $datep = dol_stringtotime(GETPOST('datep', 'int', 1), 0); |
|
174 | + } |
|
174 | 175 | print '<tr><td width="30%" nowrap="nowrap"><span>Debut</span></td><td>'; |
175 | 176 | $form->select_date($datep, 'ap', 0, 0, 1, "readBalloon", 1, 1, 0, 0); |
176 | 177 | print '</td></tr>'; |
177 | 178 | |
178 | 179 | // Date end |
179 | - if (GETPOST('datef', 'int', 1)) |
|
180 | - $datef = dol_stringtotime(GETPOST('datef', 'int', 1), 0); |
|
180 | + if (GETPOST('datef', 'int', 1)) { |
|
181 | + $datef = dol_stringtotime(GETPOST('datef', 'int', 1), 0); |
|
182 | + } |
|
181 | 183 | print '<tr><td>Fin</span></td><td>'; |
182 | 184 | $form->select_date($datef, 'p2', 0, 0, 1, "readBalloon", 1, 1, 0, 0); |
183 | 185 | print '</td></tr>'; |
@@ -60,10 +60,10 @@ |
||
60 | 60 | $query = 'SELECT *,TIMEDIFF(heureA,heureD) AS time FROM llx_bbc_vols WHERE 1=1'; |
61 | 61 | |
62 | 62 | if ($datep) { |
63 | - $query .= ' AND date >= \'' . dol_print_date($datep, 'dayrfc'). '\''; |
|
63 | + $query .= ' AND date >= \'' . dol_print_date($datep, 'dayrfc') . '\''; |
|
64 | 64 | } |
65 | 65 | if ($datef) { |
66 | - $query .= ' AND date <= \'' . dol_print_date($datef, 'dayrfc'). '\''; |
|
66 | + $query .= ' AND date <= \'' . dol_print_date($datef, 'dayrfc') . '\''; |
|
67 | 67 | } |
68 | 68 | |
69 | 69 | $query .= ' AND `fk_pilot` = ' . $bbcUser->id; |
@@ -68,7 +68,7 @@ discard block |
||
68 | 68 | $langs->load("other"); |
69 | 69 | |
70 | 70 | // Get parameters |
71 | -$id = GETPOST('id', 'int')?: GETPOST('idBBC_vols', 'int'); |
|
71 | +$id = GETPOST('id', 'int') ?: GETPOST('idBBC_vols', 'int'); |
|
72 | 72 | $action = GETPOST('action', 'alpha'); |
73 | 73 | $cancel = GETPOST('cancel'); |
74 | 74 | $backtopage = GETPOST('backtopage'); |
@@ -123,7 +123,7 @@ discard block |
||
123 | 123 | $extralabels = $extrafields->fetch_name_optionals_label($object->table_element); |
124 | 124 | |
125 | 125 | // Load object |
126 | -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 |
|
126 | +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 |
|
127 | 127 | |
128 | 128 | // Initialize technical object to manage hooks of modules. Note that conf->hooks_modules contains array array |
129 | 129 | $hookmanager->initHooks(array('bbcvols')); |
@@ -142,7 +142,7 @@ discard block |
||
142 | 142 | |
143 | 143 | $parameters = array(); |
144 | 144 | $reshook = $hookmanager->executeHooks('doActions', $parameters, $object, |
145 | - $action); // Note that $action and $object may have been modified by some hooks |
|
145 | + $action); // Note that $action and $object may have been modified by some hooks |
|
146 | 146 | if ($reshook < 0) { |
147 | 147 | setEventMessages($hookmanager->error, $hookmanager->errors, 'errors'); |
148 | 148 | } |
@@ -231,8 +231,8 @@ discard block |
||
231 | 231 | $object->id = $object->idBBC_vols; |
232 | 232 | $object->lieuD = GETPOST('lieuD', 'alpha'); |
233 | 233 | $object->lieuA = GETPOST('lieuA', 'alpha'); |
234 | - $object->heureD = GETPOST('heureD_h', 'int').":".GETPOST('heureD_m', 'int').":00"; |
|
235 | - $object->heureA = GETPOST('heureA_h', 'int').":".GETPOST('heureA_m', 'int').":00"; |
|
234 | + $object->heureD = GETPOST('heureD_h', 'int') . ":" . GETPOST('heureD_m', 'int') . ":00"; |
|
235 | + $object->heureA = GETPOST('heureA_h', 'int') . ":" . GETPOST('heureA_m', 'int') . ":00"; |
|
236 | 236 | $object->BBC_ballons_idBBC_ballons = GETPOST('BBC_ballons_idBBC_ballons', 'int'); |
237 | 237 | $object->nbrPax = GETPOST('nbrPax', 'alpha'); |
238 | 238 | $object->remarque = GETPOST('remarque', 'alpha'); |
@@ -254,12 +254,12 @@ discard block |
||
254 | 254 | null, 'errors'); |
255 | 255 | } |
256 | 256 | |
257 | - if(!dol_validElement($object->lieuD)){ |
|
257 | + if (!dol_validElement($object->lieuD)) { |
|
258 | 258 | $error++; |
259 | 259 | setEventMessage("Erreur le champ : lieu de décollage", 'errors'); |
260 | 260 | } |
261 | 261 | |
262 | - if(!dol_validElement($object->lieuA)){ |
|
262 | + if (!dol_validElement($object->lieuA)) { |
|
263 | 263 | $error++; |
264 | 264 | setEventMessage("Erreur le champ : lieu d'atterissage", 'errors'); |
265 | 265 | } |
@@ -271,12 +271,12 @@ discard block |
||
271 | 271 | setEventMessage("Erreur avec les heures de vol", 'errors'); |
272 | 272 | } |
273 | 273 | |
274 | - if(!is_numeric($object->nbrPax) || $object->nbrPax < 0 ){ |
|
274 | + if (!is_numeric($object->nbrPax) || $object->nbrPax < 0) { |
|
275 | 275 | $error++; |
276 | 276 | setEventMessage("Erreur le champ : nombre de passagers", 'errors'); |
277 | 277 | } |
278 | 278 | |
279 | - if(!$pilotService->isPilot($object->fk_pilot)){ |
|
279 | + if (!$pilotService->isPilot($object->fk_pilot)) { |
|
280 | 280 | $error++; |
281 | 281 | setEventMessage("Le pilote selectionne n'est pas pilote", 'errors'); |
282 | 282 | } |
@@ -420,18 +420,18 @@ discard block |
||
420 | 420 | select_balloons($object->BBC_ballons_idBBC_ballons, "BBC_ballons_idBBC_ballons"); |
421 | 421 | print "</td></tr>"; |
422 | 422 | print "<tr><td class=\"fieldrequired\">" . $langs->trans("FieldnbrPax") . "</td><td><input class=\"flat\" type=\"number\" name=\"nbrPax\" value=\"" . $object->nbrPax . "\"></td></tr>"; |
423 | - print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldremarque") . "</td><td><textarea class=\"flat\" name=\"remarque\">".$object->remarque."</textarea></td></tr>"; |
|
424 | - print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldincidents") . "</td><td><textarea class=\"flat\" name=\"incidents\">".$object->incidents."</textarea></td></tr>"; |
|
423 | + print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldremarque") . "</td><td><textarea class=\"flat\" name=\"remarque\">" . $object->remarque . "</textarea></td></tr>"; |
|
424 | + print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldincidents") . "</td><td><textarea class=\"flat\" name=\"incidents\">" . $object->incidents . "</textarea></td></tr>"; |
|
425 | 425 | print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldfk_type") . "</td><td>"; |
426 | 426 | select_flight_type($object->fk_type, "fk_type"); |
427 | 427 | print "</td></tr>"; |
428 | - 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>"; |
|
429 | - print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldfk_organisateur") . "</td><td>".$form->select_dolusers($object->fk_organisateur, "fk_organisateur")."</td></tr>"; |
|
428 | + 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>"; |
|
429 | + print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldfk_organisateur") . "</td><td>" . $form->select_dolusers($object->fk_organisateur, "fk_organisateur") . "</td></tr>"; |
|
430 | 430 | |
431 | - if($user->rights->flightLog->vol->financial || $user->id == $object->fk_pilot) { |
|
431 | + if ($user->rights->flightLog->vol->financial || $user->id == $object->fk_pilot) { |
|
432 | 432 | print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldkilometers") . "</td><td><input class=\"flat\" type=\"number\" name=\"kilometers\" value=\"" . $object->kilometers . "\"></td></tr>"; |
433 | 433 | print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldcost") . "</td><td><input class=\"flat\" type=\"number\" name=\"cost\" value=\"" . $object->cost . "\"></td></tr>"; |
434 | - print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldfk_receiver") . "</td><td>" . $form->select_dolusers($object->fk_receiver,"fk_receiver", true ) . "</td></tr>"; |
|
434 | + print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldfk_receiver") . "</td><td>" . $form->select_dolusers($object->fk_receiver, "fk_receiver", true) . "</td></tr>"; |
|
435 | 435 | print "<tr><td class=\"fieldrequired\">" . $langs->trans("Fieldjustif_kilometers") . "</td><td><textarea class=\"flat\" name=\"justif_kilometers\">" . $object->justif_kilometers . "</textarea></td></tr>"; |
436 | 436 | } |
437 | 437 | print '</table>'; |
@@ -453,7 +453,7 @@ discard block |
||
453 | 453 | |
454 | 454 | print load_fiche_titre($langs->trans($pageTitle)); |
455 | 455 | |
456 | - $linkback = '<a href="'.DOL_URL_ROOT.'/flightLog/list.php">'.$langs->trans("BackToList").'</a>'; |
|
456 | + $linkback = '<a href="' . DOL_URL_ROOT . '/flightLog/list.php">' . $langs->trans("BackToList") . '</a>'; |
|
457 | 457 | //dol_banner_tab($object, 'idBBC_vols', $linkback); |
458 | 458 | print $form->showrefnav($object, "idBBC_vols", $linkback, true, "idBBC_vols"); |
459 | 459 | dol_fiche_head(); |
@@ -481,13 +481,13 @@ discard block |
||
481 | 481 | print '<tr><td class="fieldrequired">' . $langs->trans("Fieldfk_pilot") . '</td><td>' . $pilot->getNomUrl(1) . '</td></tr>'; |
482 | 482 | print '<tr><td class="fieldrequired">' . $langs->trans("Fieldfk_organisateur") . '</td><td>' . $organisator->getNomUrl(1) . '</td></tr>'; |
483 | 483 | |
484 | - if($user->rights->flightLog->vol->financial){ |
|
484 | + if ($user->rights->flightLog->vol->financial) { |
|
485 | 485 | print '<tr><td class="fieldrequired">' . $langs->trans("Fieldis_facture") . '</td><td>' . $object->is_facture . '</td></tr>'; |
486 | 486 | } |
487 | 487 | |
488 | - if($user->rights->flightLog->vol->financial || $user->id == $object->fk_pilot) { |
|
488 | + if ($user->rights->flightLog->vol->financial || $user->id == $object->fk_pilot) { |
|
489 | 489 | print '<tr><td class="fieldrequired">' . $langs->trans("Fieldkilometers") . '</td><td>' . $object->kilometers . ' KM</td></tr>'; |
490 | - print '<tr><td class="fieldrequired">' . $langs->trans("Fieldcost") . '</td><td>' . $object->cost ." ". $langs->getCurrencySymbol($conf->currency).'</td></tr>'; |
|
490 | + print '<tr><td class="fieldrequired">' . $langs->trans("Fieldcost") . '</td><td>' . $object->cost . " " . $langs->getCurrencySymbol($conf->currency) . '</td></tr>'; |
|
491 | 491 | print '<tr><td class="fieldrequired">' . $langs->trans("Fieldfk_receiver") . '</td><td>' . $receiver->getNomUrl(1) . '</td></tr>'; |
492 | 492 | print '<tr><td class="fieldrequired">' . $langs->trans("Fieldjustif_kilometers") . '</td><td>' . $object->justif_kilometers . '</td></tr>'; |
493 | 493 | } |
@@ -500,7 +500,7 @@ discard block |
||
500 | 500 | print '<div class="tabsAction">' . "\n"; |
501 | 501 | $parameters = array(); |
502 | 502 | $reshook = $hookmanager->executeHooks('addMoreActionsButtons', $parameters, $object, |
503 | - $action); // Note that $action and $object may have been modified by hook |
|
503 | + $action); // Note that $action and $object may have been modified by hook |
|
504 | 504 | if ($reshook < 0) { |
505 | 505 | setEventMessages($hookmanager->error, $hookmanager->errors, 'errors'); |
506 | 506 | } |
@@ -81,9 +81,9 @@ discard block |
||
81 | 81 | |
82 | 82 | $missions = bbcKilometersByQuartil($year); |
83 | 83 | |
84 | - foreach($missions as $currentMissionUserId => $currentMission){ |
|
84 | + foreach ($missions as $currentMissionUserId => $currentMission) { |
|
85 | 85 | |
86 | - if($currentMission["quartil"][$quarter]["km"] == 0 && $currentMission["quartil"][$quarter]["flight"] == 0){ |
|
86 | + if ($currentMission["quartil"][$quarter]["km"] == 0 && $currentMission["quartil"][$quarter]["flight"] == 0) { |
|
87 | 87 | continue; |
88 | 88 | } |
89 | 89 | |
@@ -97,18 +97,18 @@ discard block |
||
97 | 97 | $object->fk_statut = 1; |
98 | 98 | $object->fk_user_validator = GETPOST("fk_user_validator", 'int'); |
99 | 99 | $object->note_public = GETPOST('public_note', 'alpha'); |
100 | - $object->note_private = GETPOST('private_note','alpha'); |
|
100 | + $object->note_private = GETPOST('private_note', 'alpha'); |
|
101 | 101 | |
102 | 102 | $expenseNoteId = $object->create($expenseNoteUser); |
103 | - if($expenseNoteId < 0){ |
|
104 | - dol_htmloutput_errors("Erreur lors de la création de la note de frais" , $object->errors); |
|
103 | + if ($expenseNoteId < 0) { |
|
104 | + dol_htmloutput_errors("Erreur lors de la création de la note de frais", $object->errors); |
|
105 | 105 | continue; |
106 | 106 | } |
107 | 107 | |
108 | 108 | |
109 | 109 | $flightsForQuarter = findFlightByPilotAndQuarter($currentMissionUserId, $year, $quarter); |
110 | 110 | |
111 | - foreach($flightsForQuarter as $currentFlightForQuarter) { |
|
111 | + foreach ($flightsForQuarter as $currentFlightForQuarter) { |
|
112 | 112 | |
113 | 113 | // Kilometers |
114 | 114 | $object_ligne = new ExpenseReportLine($db); |
@@ -168,7 +168,7 @@ discard block |
||
168 | 168 | |
169 | 169 | if ($result > 0) { |
170 | 170 | dol_htmloutput_mesg("Notes de frais créées"); |
171 | - }else{ |
|
171 | + } else { |
|
172 | 172 | dol_htmloutput_errors("Note de frais non créée"); |
173 | 173 | } |
174 | 174 | } else { |
@@ -187,15 +187,15 @@ discard block |
||
187 | 187 | $form = new Form($db); |
188 | 188 | |
189 | 189 | $tabLinks = []; |
190 | -foreach($flightYears as $currentFlightYear){ |
|
190 | +foreach ($flightYears as $currentFlightYear) { |
|
191 | 191 | $tabLinks[] = [ |
192 | - DOL_URL_ROOT."/flightLog/generateExpenseNote.php?year=".$currentFlightYear, |
|
192 | + DOL_URL_ROOT . "/flightLog/generateExpenseNote.php?year=" . $currentFlightYear, |
|
193 | 193 | $currentFlightYear, |
194 | - "tab_".$currentFlightYear |
|
194 | + "tab_" . $currentFlightYear |
|
195 | 195 | ]; |
196 | 196 | } |
197 | 197 | |
198 | -dol_fiche_head($tabLinks, "tab_".$year); |
|
198 | +dol_fiche_head($tabLinks, "tab_" . $year); |
|
199 | 199 | |
200 | 200 | ?> |
201 | 201 | <form method="POST"> |
@@ -211,7 +211,7 @@ discard block |
||
211 | 211 | <select name="quarter" id="field_quarter"> |
212 | 212 | <option value="1" <?= ($year == $currentYear && $currentQuarter <= 1) ? 'disabled="disabled"' : "" ?>>1</option> |
213 | 213 | <option value="2" <?= ($year == $currentYear && $currentQuarter <= 2) ? 'disabled="disabled"' : "" ?>>2</option> |
214 | - <option value="3" <?= ($year == $currentYear && $currentQuarter <= 3) ? 'disabled="disabled"': "" ?>>3</option> |
|
214 | + <option value="3" <?= ($year == $currentYear && $currentQuarter <= 3) ? 'disabled="disabled"' : "" ?>>3</option> |
|
215 | 215 | <option value="4" <?= ($year == $currentYear && $currentQuarter <= 4) ? 'disabled="disabled"' : "" ?>>4</option> |
216 | 216 | </select> |
217 | 217 | <br/> |
@@ -220,7 +220,7 @@ discard block |
||
220 | 220 | <label><?= $langs->trans("Validateur de la note de frais")?></label><br/> |
221 | 221 | <?php |
222 | 222 | $include_users = $object->fetch_users_approver_expensereport(); |
223 | - print $form->select_dolusers($user->id,"fk_user_validator",1,"",0,$include_users); |
|
223 | + print $form->select_dolusers($user->id, "fk_user_validator", 1, "", 0, $include_users); |
|
224 | 224 | ?> |
225 | 225 | <br/> |
226 | 226 |
@@ -168,7 +168,7 @@ |
||
168 | 168 | |
169 | 169 | if ($result > 0) { |
170 | 170 | dol_htmloutput_mesg("Notes de frais créées"); |
171 | - }else{ |
|
171 | + } else{ |
|
172 | 172 | dol_htmloutput_errors("Note de frais non créée"); |
173 | 173 | } |
174 | 174 | } else { |
@@ -69,7 +69,7 @@ |
||
69 | 69 | $result = [$this->year]; |
70 | 70 | |
71 | 71 | foreach ($this->graphData as $typeId => $data) { |
72 | - if(!in_array($typeId, [1,2,3,6])){ |
|
72 | + if (!in_array($typeId, [1, 2, 3, 6])) { |
|
73 | 73 | continue; |
74 | 74 | } |
75 | 75 |
@@ -41,211 +41,211 @@ discard block |
||
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 |
||
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,90 +496,90 @@ discard block |
||
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 | - } |
|
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 | 564 | |
565 | 565 | |
566 | - /** |
|
567 | - * Initialise object with example values |
|
568 | - * Id must be 0 if object instance is a specimen |
|
569 | - * |
|
570 | - * @return void |
|
571 | - */ |
|
572 | - public function initAsSpecimen() |
|
573 | - { |
|
574 | - $this->id = 0; |
|
566 | + /** |
|
567 | + * Initialise object with example values |
|
568 | + * Id must be 0 if object instance is a specimen |
|
569 | + * |
|
570 | + * @return void |
|
571 | + */ |
|
572 | + public function initAsSpecimen() |
|
573 | + { |
|
574 | + $this->id = 0; |
|
575 | 575 | |
576 | - $this->idType = ''; |
|
577 | - $this->numero = ''; |
|
578 | - $this->nom = ''; |
|
579 | - $this->active = ''; |
|
576 | + $this->idType = ''; |
|
577 | + $this->numero = ''; |
|
578 | + $this->nom = ''; |
|
579 | + $this->active = ''; |
|
580 | 580 | |
581 | 581 | |
582 | - } |
|
582 | + } |
|
583 | 583 | |
584 | 584 | } |
585 | 585 | |
@@ -588,21 +588,21 @@ discard block |
||
588 | 588 | */ |
589 | 589 | class BbctypesLine |
590 | 590 | { |
591 | - /** |
|
592 | - * @var int ID |
|
593 | - */ |
|
594 | - public $id; |
|
595 | - /** |
|
596 | - * @var mixed Sample line property 1 |
|
597 | - */ |
|
591 | + /** |
|
592 | + * @var int ID |
|
593 | + */ |
|
594 | + public $id; |
|
595 | + /** |
|
596 | + * @var mixed Sample line property 1 |
|
597 | + */ |
|
598 | 598 | |
599 | - public $idType; |
|
600 | - public $numero; |
|
601 | - public $nom; |
|
602 | - public $active; |
|
603 | - |
|
604 | - /** |
|
605 | - * @var mixed Sample line property 2 |
|
606 | - */ |
|
599 | + public $idType; |
|
600 | + public $numero; |
|
601 | + public $nom; |
|
602 | + public $active; |
|
603 | + |
|
604 | + /** |
|
605 | + * @var mixed Sample line property 2 |
|
606 | + */ |
|
607 | 607 | |
608 | 608 | } |
@@ -110,16 +110,16 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
@@ -501,7 +501,9 @@ discard block |
||
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 |
||
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 |