@@ -31,15 +31,15 @@ |
||
| 31 | 31 | public function __invoke($flightId) |
| 32 | 32 | { |
| 33 | 33 | $sql = 'SELECT damage.author_id as author_id, damage.rowid as id, damage.amount, damage.label, CONCAT(author.firstname, " " , author.lastname) as author_name, damage.billed as invoiced'; |
| 34 | - $sql.=' FROM '.MAIN_DB_PREFIX.'bbc_flight_damages as damage'; |
|
| 35 | - $sql.=' INNER JOIN '.MAIN_DB_PREFIX.'user as author ON author.rowid = damage.author_id'; |
|
| 36 | - $sql.=' WHERE damage.flight_id = '.$this->db->escape($flightId); |
|
| 34 | + $sql .= ' FROM ' . MAIN_DB_PREFIX . 'bbc_flight_damages as damage'; |
|
| 35 | + $sql .= ' INNER JOIN ' . MAIN_DB_PREFIX . 'user as author ON author.rowid = damage.author_id'; |
|
| 36 | + $sql .= ' WHERE damage.flight_id = ' . $this->db->escape($flightId); |
|
| 37 | 37 | |
| 38 | 38 | $resql = $this->db->query($sql); |
| 39 | 39 | if ($resql) { |
| 40 | 40 | $num = $this->db->num_rows($resql); |
| 41 | 41 | if ($num) { |
| 42 | - for($i = 0; $i < $num ; $i++) { |
|
| 42 | + for ($i = 0; $i < $num; $i++) { |
|
| 43 | 43 | $properties = $this->db->fetch_array($resql); |
| 44 | 44 | yield Damage::fromArray($properties); |
| 45 | 45 | } |
@@ -37,7 +37,7 @@ discard block |
||
| 37 | 37 | 'label' => $flightDamage->getLabel()->value(), |
| 38 | 38 | ]; |
| 39 | 39 | |
| 40 | - if($flightDamage->getId()){ |
|
| 40 | + if ($flightDamage->getId()) { |
|
| 41 | 41 | $this->update($flightDamage->getId()->getId(), $fields); |
| 42 | 42 | return $flightDamage->getId()->getId(); |
| 43 | 43 | } |
@@ -52,10 +52,10 @@ discard block |
||
| 52 | 52 | * |
| 53 | 53 | * @throws \Exception |
| 54 | 54 | */ |
| 55 | - public function getById(DamageId $id){ |
|
| 55 | + public function getById(DamageId $id) { |
|
| 56 | 56 | $damage = $this->get($id->getId()); |
| 57 | 57 | |
| 58 | - if(null === $damage){ |
|
| 58 | + if (null === $damage) { |
|
| 59 | 59 | throw new \Exception('Damage not found'); |
| 60 | 60 | } |
| 61 | 61 | |
@@ -23,7 +23,7 @@ discard block |
||
| 23 | 23 | public function __construct(\DoliDB $db, $tableName) |
| 24 | 24 | { |
| 25 | 25 | $this->db = $db; |
| 26 | - $this->tableName = strpos($tableName, MAIN_DB_PREFIX) === 0 ? $tableName : MAIN_DB_PREFIX.$tableName; |
|
| 26 | + $this->tableName = strpos($tableName, MAIN_DB_PREFIX) === 0 ? $tableName : MAIN_DB_PREFIX . $tableName; |
|
| 27 | 27 | } |
| 28 | 28 | |
| 29 | 29 | /** |
@@ -33,7 +33,7 @@ discard block |
||
| 33 | 33 | * |
| 34 | 34 | * @throws \Exception |
| 35 | 35 | */ |
| 36 | - protected function write(array $elements){ |
|
| 36 | + protected function write(array $elements) { |
|
| 37 | 37 | $columns = join(',', array_keys($elements)); |
| 38 | 38 | $values = join(',', array_map([$this, 'escape'], array_values($elements))); |
| 39 | 39 | |
@@ -44,7 +44,7 @@ discard block |
||
| 44 | 44 | $lasterror = $this->db->lasterror(); |
| 45 | 45 | dol_syslog(__METHOD__ . ' ' . $lasterror, LOG_ERR); |
| 46 | 46 | $this->db->rollback(); |
| 47 | - throw new \Exception("Repository error - ".$lasterror); |
|
| 47 | + throw new \Exception("Repository error - " . $lasterror); |
|
| 48 | 48 | } |
| 49 | 49 | |
| 50 | 50 | $id = $this->db->last_insert_id($this->tableName); |
@@ -57,16 +57,16 @@ discard block |
||
| 57 | 57 | * |
| 58 | 58 | * @return int|string|null |
| 59 | 59 | */ |
| 60 | - private function escape($value){ |
|
| 61 | - if(is_null($value)){ |
|
| 60 | + private function escape($value) { |
|
| 61 | + if (is_null($value)) { |
|
| 62 | 62 | return null; |
| 63 | 63 | } |
| 64 | 64 | |
| 65 | - if(is_bool($value)){ |
|
| 66 | - return (int)$value; |
|
| 65 | + if (is_bool($value)) { |
|
| 66 | + return (int) $value; |
|
| 67 | 67 | } |
| 68 | 68 | |
| 69 | - return is_string($value) ? "'".$this->db->escape($value)."'" : $value ; |
|
| 69 | + return is_string($value) ? "'" . $this->db->escape($value) . "'" : $value; |
|
| 70 | 70 | } |
| 71 | 71 | |
| 72 | 72 | /** |
@@ -79,18 +79,18 @@ discard block |
||
| 79 | 79 | { |
| 80 | 80 | $sqlModifications = []; |
| 81 | 81 | |
| 82 | - foreach($elements as $field => $value){ |
|
| 82 | + foreach ($elements as $field => $value) { |
|
| 83 | 83 | $sqlModifications[] = sprintf('%s=%s', $field, $this->escape($value)); |
| 84 | 84 | } |
| 85 | 85 | |
| 86 | 86 | $this->db->begin(); |
| 87 | - $resql = $this->db->query(sprintf('UPDATE %s SET %s WHERE rowid = %s ', $this->tableName, join(',',$sqlModifications), $id)); |
|
| 87 | + $resql = $this->db->query(sprintf('UPDATE %s SET %s WHERE rowid = %s ', $this->tableName, join(',', $sqlModifications), $id)); |
|
| 88 | 88 | |
| 89 | 89 | if (!$resql) { |
| 90 | 90 | $lasterror = $this->db->lasterror(); |
| 91 | 91 | dol_syslog(__METHOD__ . ' ' . $lasterror, LOG_ERR); |
| 92 | 92 | $this->db->rollback(); |
| 93 | - throw new \Exception("Repository error - ".$lasterror); |
|
| 93 | + throw new \Exception("Repository error - " . $lasterror); |
|
| 94 | 94 | } |
| 95 | 95 | |
| 96 | 96 | $this->db->commit(); |
@@ -103,8 +103,8 @@ discard block |
||
| 103 | 103 | * |
| 104 | 104 | * @return array|null |
| 105 | 105 | */ |
| 106 | - protected function get($id){ |
|
| 107 | - $sql = sprintf('SELECT * FROM %s WHERE rowid = %s', $this->tableName, $id ); |
|
| 106 | + protected function get($id) { |
|
| 107 | + $sql = sprintf('SELECT * FROM %s WHERE rowid = %s', $this->tableName, $id); |
|
| 108 | 108 | |
| 109 | 109 | $resql = $this->db->query($sql); |
| 110 | 110 | if (!$resql) { |
@@ -116,7 +116,7 @@ discard block |
||
| 116 | 116 | return null; |
| 117 | 117 | } |
| 118 | 118 | |
| 119 | - for($i = 0; $i < $num ; $i++) { |
|
| 119 | + for ($i = 0; $i < $num; $i++) { |
|
| 120 | 120 | return $this->db->fetch_array($resql); |
| 121 | 121 | } |
| 122 | 122 | |
@@ -72,14 +72,14 @@ |
||
| 72 | 72 | * |
| 73 | 73 | * @return Damage |
| 74 | 74 | */ |
| 75 | - public static function fromArray(array $properties){ |
|
| 75 | + public static function fromArray(array $properties) { |
|
| 76 | 76 | $authorId = $properties['author_id']; |
| 77 | 77 | $author = $properties['author_name']; |
| 78 | 78 | $label = $properties['label']; |
| 79 | 79 | $amount = $properties['amount']; |
| 80 | 80 | $id = $properties['id']; |
| 81 | 81 | $flightId = isset($properties['flight_id']) ? $properties['flight_id'] : null; |
| 82 | - $invoiced = (bool)$properties['invoiced']; |
|
| 82 | + $invoiced = (bool) $properties['invoiced']; |
|
| 83 | 83 | |
| 84 | 84 | return new self($authorId, $author, $amount, $id, $invoiced, $flightId, $label); |
| 85 | 85 | } |
@@ -42,7 +42,7 @@ discard block |
||
| 42 | 42 | public function __invoke(CreateDamageCommand $command) |
| 43 | 43 | { |
| 44 | 44 | $damage = FlightDamage::waiting(new DamageAmount($command->getAmount()), AuthorId::create($command->getAuthorId()), new DamageLabel($command->getLabel())); |
| 45 | - if(null !== $command->getFlightId()){ |
|
| 45 | + if (null !== $command->getFlightId()) { |
|
| 46 | 46 | $damage = FlightDamage::damage(FlightId::create($command->getFlightId()), new DamageLabel($command->getLabel()), new DamageAmount($command->getAmount()), AuthorId::create($command->getAuthorId())); |
| 47 | 47 | } |
| 48 | 48 | |
@@ -60,7 +60,7 @@ discard block |
||
| 60 | 60 | */ |
| 61 | 61 | private function linkSupplierInvoice($damageId, $invoiceId) |
| 62 | 62 | { |
| 63 | - if($invoiceId <= 0){ |
|
| 63 | + if ($invoiceId <= 0) { |
|
| 64 | 64 | return; |
| 65 | 65 | } |
| 66 | 66 | |
@@ -81,8 +81,8 @@ discard block |
||
| 81 | 81 | * @param int $targetId |
| 82 | 82 | * @param string $targetType |
| 83 | 83 | */ |
| 84 | - private function insertLinks($damageId, $targetId, $targetType){ |
|
| 85 | - $sql = "INSERT INTO ".MAIN_DB_PREFIX."element_element ("; |
|
| 84 | + private function insertLinks($damageId, $targetId, $targetType) { |
|
| 85 | + $sql = "INSERT INTO " . MAIN_DB_PREFIX . "element_element ("; |
|
| 86 | 86 | $sql .= "fk_source"; |
| 87 | 87 | $sql .= ", sourcetype"; |
| 88 | 88 | $sql .= ", fk_target"; |
@@ -90,8 +90,8 @@ discard block |
||
| 90 | 90 | $sql .= ") VALUES ("; |
| 91 | 91 | $sql .= $damageId; |
| 92 | 92 | $sql .= ", 'flightlog_damage'"; |
| 93 | - $sql .= ", ".$targetId; |
|
| 94 | - $sql .= ", '".$targetType."'"; |
|
| 93 | + $sql .= ", " . $targetId; |
|
| 94 | + $sql .= ", '" . $targetType . "'"; |
|
| 95 | 95 | $sql .= ")"; |
| 96 | 96 | |
| 97 | 97 | if ($this->db->query($sql)) |
@@ -15,7 +15,7 @@ |
||
| 15 | 15 | $this->label = $label; |
| 16 | 16 | } |
| 17 | 17 | |
| 18 | - public function value(){ |
|
| 18 | + public function value() { |
|
| 19 | 19 | return $this->label; |
| 20 | 20 | } |
| 21 | 21 | |
@@ -106,11 +106,11 @@ discard block |
||
| 106 | 106 | return new Pilot($this->name, $this->id, $types); |
| 107 | 107 | } |
| 108 | 108 | |
| 109 | - public function addDamage(FlightDamageCount $damage){ |
|
| 109 | + public function addDamage(FlightDamageCount $damage) { |
|
| 110 | 110 | $this->damages[] = $damage; |
| 111 | 111 | } |
| 112 | 112 | |
| 113 | - public function addInvoicedDamage(FlightInvoicedDamageCount $damage){ |
|
| 113 | + public function addInvoicedDamage(FlightInvoicedDamageCount $damage) { |
|
| 114 | 114 | $this->damages[] = $damage; |
| 115 | 115 | } |
| 116 | 116 | |
@@ -161,21 +161,21 @@ discard block |
||
| 161 | 161 | return $flightsCost; |
| 162 | 162 | } |
| 163 | 163 | |
| 164 | - public function totalDamageCost(){ |
|
| 164 | + public function totalDamageCost() { |
|
| 165 | 165 | $flightCost = FlightCost::zero(); |
| 166 | 166 | |
| 167 | - foreach($this->damages as $damage){ |
|
| 167 | + foreach ($this->damages as $damage) { |
|
| 168 | 168 | $flightCost = $flightCost->addCost($damage->getCost()); |
| 169 | 169 | } |
| 170 | 170 | |
| 171 | 171 | return $flightCost; |
| 172 | 172 | } |
| 173 | 173 | |
| 174 | - public function damageCost(){ |
|
| 174 | + public function damageCost() { |
|
| 175 | 175 | $flightCost = FlightCost::zero(); |
| 176 | 176 | |
| 177 | - foreach($this->damages as $damage){ |
|
| 178 | - if(!$damage instanceof FlightDamageCount){ |
|
| 177 | + foreach ($this->damages as $damage) { |
|
| 178 | + if (!$damage instanceof FlightDamageCount) { |
|
| 179 | 179 | continue; |
| 180 | 180 | } |
| 181 | 181 | |
@@ -185,11 +185,11 @@ discard block |
||
| 185 | 185 | return $flightCost; |
| 186 | 186 | } |
| 187 | 187 | |
| 188 | - public function invoicedDamageCost(){ |
|
| 188 | + public function invoicedDamageCost() { |
|
| 189 | 189 | $flightCost = FlightCost::zero(); |
| 190 | 190 | |
| 191 | - foreach($this->damages as $damage){ |
|
| 192 | - if(!$damage instanceof FlightInvoicedDamageCount){ |
|
| 191 | + foreach ($this->damages as $damage) { |
|
| 192 | + if (!$damage instanceof FlightInvoicedDamageCount) { |
|
| 193 | 193 | continue; |
| 194 | 194 | } |
| 195 | 195 | |
@@ -199,7 +199,7 @@ discard block |
||
| 199 | 199 | return $flightCost; |
| 200 | 200 | } |
| 201 | 201 | |
| 202 | - public function damages(){ |
|
| 202 | + public function damages() { |
|
| 203 | 203 | return $this->damages; |
| 204 | 204 | } |
| 205 | 205 | |
@@ -71,7 +71,7 @@ discard block |
||
| 71 | 71 | $pilots[$obj->pilot] = $pilots[$obj->pilot]->addCount( |
| 72 | 72 | new FlightTypeCount( |
| 73 | 73 | $obj->type, |
| 74 | - (int)$obj->nbr, |
|
| 74 | + (int) $obj->nbr, |
|
| 75 | 75 | $this->getFactorByType($obj->type) |
| 76 | 76 | ) |
| 77 | 77 | ); |
@@ -106,7 +106,7 @@ discard block |
||
| 106 | 106 | $pilots[$obj->rowid] = $pilots[$obj->rowid]->addCount( |
| 107 | 107 | new FlightTypeCount( |
| 108 | 108 | 'orga', |
| 109 | - (int)$obj->total, |
|
| 109 | + (int) $obj->total, |
|
| 110 | 110 | $this->getFactorByType('orga') |
| 111 | 111 | ) |
| 112 | 112 | ); |
@@ -136,7 +136,7 @@ discard block |
||
| 136 | 136 | $pilots[$obj->rowid] = $pilots[$obj->rowid]->addCount( |
| 137 | 137 | new FlightTypeCount( |
| 138 | 138 | 'orga_T6', |
| 139 | - (int)$obj->total, |
|
| 139 | + (int) $obj->total, |
|
| 140 | 140 | $this->getFactorByType('orga_T6') |
| 141 | 141 | ) |
| 142 | 142 | ); |
@@ -148,7 +148,7 @@ discard block |
||
| 148 | 148 | |
| 149 | 149 | //Total damages |
| 150 | 150 | $damages = $this->pilotDamageQueryRepository->query($query->getFiscalYear()); |
| 151 | - foreach($damages as $currentDamage){ |
|
| 151 | + foreach ($damages as $currentDamage) { |
|
| 152 | 152 | |
| 153 | 153 | //Pilot doesn't exist |
| 154 | 154 | if (!isset($pilots[$currentDamage->getAuthorId()])) { |
@@ -157,13 +157,13 @@ discard block |
||
| 157 | 157 | |
| 158 | 158 | // Add all damage |
| 159 | 159 | $pilots[$currentDamage->getAuthorId()]->addDamage( |
| 160 | - new FlightDamageCount('', $currentDamage->getAmount()) |
|
| 160 | + new FlightDamageCount('', $currentDamage->getAmount()) |
|
| 161 | 161 | ); |
| 162 | 162 | |
| 163 | 163 | // The damage is already invoiced. So not take into account. |
| 164 | - if($currentDamage->isInvoiced()){ |
|
| 164 | + if ($currentDamage->isInvoiced()) { |
|
| 165 | 165 | $pilots[$currentDamage->getAuthorId()]->addInvoicedDamage( |
| 166 | - new FlightInvoicedDamageCount('', $currentDamage->getAmount()) |
|
| 166 | + new FlightInvoicedDamageCount('', $currentDamage->getAmount()) |
|
| 167 | 167 | ); |
| 168 | 168 | } |
| 169 | 169 | } |
@@ -43,7 +43,7 @@ discard block |
||
| 43 | 43 | |
| 44 | 44 | $id = GETPOST('id', 'int') ?: GETPOST('idBBC_vols', 'int'); |
| 45 | 45 | $action = GETPOST('action', 'alpha'); |
| 46 | -$permissiondellink=$user->rights->flightlog->vol->financial; |
|
| 46 | +$permissiondellink = $user->rights->flightlog->vol->financial; |
|
| 47 | 47 | |
| 48 | 48 | $object = new Bbcvols($db); |
| 49 | 49 | $extrafields = new ExtraFields($db); |
@@ -62,8 +62,8 @@ discard block |
||
| 62 | 62 | $extralabels = $extrafields->fetch_name_optionals_label($object->table_element); |
| 63 | 63 | |
| 64 | 64 | // Load object |
| 65 | -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 |
|
| 66 | -include DOL_DOCUMENT_ROOT.'/core/actions_dellink.inc.php'; |
|
| 65 | +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 |
|
| 66 | +include DOL_DOCUMENT_ROOT . '/core/actions_dellink.inc.php'; |
|
| 67 | 67 | |
| 68 | 68 | // Initialize technical object to manage hooks of modules. Note that conf->hooks_modules contains array array |
| 69 | 69 | $hookmanager->initHooks(array('bbcvols')); |
@@ -99,20 +99,20 @@ discard block |
||
| 99 | 99 | print '<tr><td class="fieldrequired">' . $langs->trans("Fielddate") . '</td><td>' . dol_print_date($object->date) . '</td></tr>'; |
| 100 | 100 | |
| 101 | 101 | if ($user->rights->flightlog->vol->financial) { |
| 102 | - print '<tr><td class="fieldrequired">' . $langs->trans("Fieldis_facture") . '</td><td>' . $object->getLibStatut(5). '</td></tr>'; |
|
| 102 | + print '<tr><td class="fieldrequired">' . $langs->trans("Fieldis_facture") . '</td><td>' . $object->getLibStatut(5) . '</td></tr>'; |
|
| 103 | 103 | } |
| 104 | 104 | |
| 105 | 105 | print '<tr><td class="fieldrequired">' . $langs->trans("Fieldkilometers") . '</td><td>' . $object->kilometers . ' KM</td></tr>'; |
| 106 | 106 | print '<tr><td class="fieldrequired">' . $langs->trans("Fieldjustif_kilometers") . '</td><td>' . $object->justif_kilometers . '</td></tr>'; |
| 107 | -if($object->hasReceiver()){ |
|
| 107 | +if ($object->hasReceiver()) { |
|
| 108 | 108 | print '<tr><td class="fieldrequired">' . $langs->trans("Fieldcost") . '</td><td>' . $object->cost . " " . $langs->getCurrencySymbol($conf->currency) . '</td></tr>'; |
| 109 | 109 | print '<tr><td class="fieldrequired">' . $langs->trans("Fieldfk_receiver") . '</td><td>' . $receiver->getNomUrl(1) . '</td></tr>'; |
| 110 | 110 | } |
| 111 | 111 | |
| 112 | -if($object->isLinkedToOrder()){ |
|
| 112 | +if ($object->isLinkedToOrder()) { |
|
| 113 | 113 | print '<tr><td class="fieldrequired">' . $langs->trans("Order") . '</td><td><ul>'; |
| 114 | - foreach($object->getOrders() as $currentOrder){ |
|
| 115 | - print '<li>'.$currentOrder->getNomUrl(1).'</li>'; |
|
| 114 | + foreach ($object->getOrders() as $currentOrder) { |
|
| 115 | + print '<li>' . $currentOrder->getNomUrl(1) . '</li>'; |
|
| 116 | 116 | } |
| 117 | 117 | print '</ul></td></tr>'; |
| 118 | 118 | } |
@@ -124,18 +124,18 @@ discard block |
||
| 124 | 124 | print '<div class="tabsAction">' . "\n"; |
| 125 | 125 | |
| 126 | 126 | // Make invoice |
| 127 | -if($user->rights->flightlog->vol->financial && $object->fk_type == 2 && !$object->hasFacture()){ |
|
| 128 | - print '<div class="inline-block divButAction"><a class="butAction" href="' . DOL_URL_ROOT . '/flightlog/facture.php?id=' . $object->id.'">' . $langs->trans("Facturer") . '</a></div>' . "\n"; |
|
| 127 | +if ($user->rights->flightlog->vol->financial && $object->fk_type == 2 && !$object->hasFacture()) { |
|
| 128 | + print '<div class="inline-block divButAction"><a class="butAction" href="' . DOL_URL_ROOT . '/flightlog/facture.php?id=' . $object->id . '">' . $langs->trans("Facturer") . '</a></div>' . "\n"; |
|
| 129 | 129 | } |
| 130 | 130 | |
| 131 | 131 | // Open |
| 132 | -if($object->isBilled() && $object->isBillingRequired()){ |
|
| 133 | - print '<div class="inline-block divButAction"><a class="butAction" href="' . DOL_URL_ROOT . '/flightlog/card_tab_financial.php?action=open&id=' . $object->id.'">' . $langs->trans("Ouvrir") . '</a></div>' . "\n"; |
|
| 132 | +if ($object->isBilled() && $object->isBillingRequired()) { |
|
| 133 | + print '<div class="inline-block divButAction"><a class="butAction" href="' . DOL_URL_ROOT . '/flightlog/card_tab_financial.php?action=open&id=' . $object->id . '">' . $langs->trans("Ouvrir") . '</a></div>' . "\n"; |
|
| 134 | 134 | } |
| 135 | 135 | |
| 136 | 136 | print '</div>' . "\n"; |
| 137 | 137 | |
| 138 | -if($user->rights->flightlog->vol->financial){ |
|
| 138 | +if ($user->rights->flightlog->vol->financial) { |
|
| 139 | 139 | print '<div class="fichecenter"><div class="fichehalfleft">'; |
| 140 | 140 | $form->showLinkedObjectBlock($object); |
| 141 | 141 | print '</div></div>'; |