Bbcvols::insertOrders() - Code Metrics - Inspection of "select existing customer" - laudeco/bbc-dolibarr-flightlog - Measure and Improve Code Quality continuously with Scrutinizer

Completed
Push — feature/select_existing_custom... ( a1e51a )

by Laurent
created 2019-09-09 16:14 UTC
Bbcvols::insertOrders() A

↳ Parent: Bbcvols
Complexity

Conditions	5
Paths	5
Size

Total Lines
Duplication

Lines	5
Ratio	13.89 %
Importance

Changes
Metric	Value
cc	5
nc	5
nop	0
dl	5
loc	36
rs	9.0328
c	0
b	0
f	0
<?php
/* Copyright (C) 2007-2012  Laurent Destailleur <[email protected]>
 * Copyright (C) 2014       Juanjo Menent       <[email protected]>
 * Copyright (C) 2015       Florian Henry       <[email protected]>
 * Copyright (C) 2015       Raphaël Doursenaud  <[email protected]>
 * Copyright (C) ---Put here your own copyright and developer email---
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
 */

/**
 * \file    flightlog/bbcvols.class.php
 * \ingroup flightlog
 * \brief   This file is an example for a CRUD class file (Create/Read/Update/Delete)
 *          Put some comments here
 */

// Put here all includes required by your class file
require_once DOL_DOCUMENT_ROOT . '/core/class/commonobject.class.php';
require_once DOL_DOCUMENT_ROOT . '/flightballoon/class/bbc_ballons.class.php';
require_once DOL_DOCUMENT_ROOT . '/flightlog/class/bbctypes.class.php';
require_once DOL_DOCUMENT_ROOT . '/commande/class/commande.class.php';

/**
 * Class Bbcvols
 *
 * Put here description of your class
 *
 * @see CommonObject
 */
class Bbcvols extends CommonObject
{

    /**
     * @var string Id to identify managed objects
     */
    public $element = 'flightlog_bbcvols';
    public static $table = 'bbc_vols';

    /**
     * @var string Name of table without prefix where object is stored
     */
    public $table_element = 'bbc_vols';

    public $idBBC_vols;
    public $date = '';
    public $lieuD;
    public $lieuA;
    public $heureD;
    public $heureA;
    public $BBC_ballons_idBBC_ballons;
    public $nbrPax;
    public $remarque;
    public $incidents;
    public $fk_type;
    public $fk_pilot;
    public $fk_organisateur;
    public $is_facture;
    public $kilometers;
    public $cost;
    public $fk_receiver;
    public $justif_kilometers;
    public $date_creation;
    public $date_update;

    /**
     * @var Bbc_ballons
     */
    private $balloon;

    /**
     * @var User
     */
    private $pilot;

    /**
     * @var string
     */
    private $passengerNames;

    /**
     * @var int[]|array
     */
    private $orderIds;

    /**
     * @var Commande[]|array
     */
    private $orders;

    /**
     * @return int
     */
    public function getIdBBCVols()
    {
        return (int) $this->idBBC_vols;
    }

    /**
     * @return int
     */
    public function getId()
    {
        return (int) $this->getIdBBCVols();
    }

    /**
     * @param string|int $ref
     *
     * @return $this
     */
    public function setRef($ref)
    {
        $this->ref = $ref;
        return $this;
    }

    /**
     * Constructor
     *
     * @param DoliDb $db Database handler
     */
    public function __construct(DoliDB $db)
    {
        $this->db = $db;
        $this->cost = 0;

        $this->passengerNames = '';
        $this->orderIds = [];
    }

    /**
     * Create a flight
     *
     * @param  User $user      User that creates
     * @param  bool $notrigger false=launch triggers after, true=disable triggers
     *
     * @return int <0 if KO, Id of created object if OK
     * @throws Exception
     */
    public function create(User $user, $notrigger = false)
    {
        dol_syslog(__METHOD__, LOG_DEBUG);

        $error = 0;

        if (isset($this->idBBC_vols)) {
            $this->idBBC_vols = trim($this->idBBC_vols);
        }
        if (isset($this->lieuD)) {
            $this->lieuD = trim($this->lieuD);
        }
        if (isset($this->lieuA)) {
            $this->lieuA = trim($this->lieuA);
        }
        if (isset($this->heureD)) {
            $this->heureD = trim($this->heureD) . '00';
        }
        if (isset($this->heureA)) {
            $this->heureA = trim($this->heureA) . '00';
        }
        if (isset($this->BBC_ballons_idBBC_ballons)) {
            $this->BBC_ballons_idBBC_ballons = trim($this->BBC_ballons_idBBC_ballons);
        }
        if (isset($this->nbrPax)) {
            $this->nbrPax = trim($this->nbrPax);
        }
        if (isset($this->remarque)) {
            $this->remarque = trim($this->remarque);
        }
        if (isset($this->incidents)) {
            $this->incidents = trim($this->incidents);
        }
        if (isset($this->fk_type)) {
            $this->fk_type = trim($this->fk_type);
        }
        if (isset($this->fk_pilot)) {
            $this->fk_pilot = trim($this->fk_pilot);
        }
        if (isset($this->fk_organisateur)) {
            $this->fk_organisateur = trim($this->fk_organisateur);
        }
        if (isset($this->is_facture)) {
            $this->is_facture = trim($this->is_facture);
        }
        if (isset($this->kilometers)) {
            $this->kilometers = trim($this->kilometers);
        }
        if (isset($this->cost)) {
            $this->cost = trim($this->cost);
        }
        if (isset($this->fk_receiver)) {
            $this->fk_receiver = trim($this->fk_receiver);
        }
        if (isset($this->justif_kilometers)) {
            $this->justif_kilometers = trim($this->justif_kilometers);
        }
        if (isset($this->passengerNames)) {
            $this->passengerNames = trim($this->passengerNames);
        }

        $nextId = $this->getNextId();

        // Insert request
        $sql = 'INSERT INTO ' . MAIN_DB_PREFIX . $this->table_element . '(';
        $sql .= 'idBBC_vols,';
        $sql .= 'ref,';
        $sql .= 'rowid,';
        $sql .= 'date,';
        $sql .= 'lieuD,';
        $sql .= 'lieuA,';
        $sql .= 'heureD,';
        $sql .= 'heureA,';
        $sql .= 'BBC_ballons_idBBC_ballons,';
        $sql .= 'nbrPax,';
        $sql .= 'remarque,';
        $sql .= 'incidents,';
        $sql .= 'fk_type,';
        $sql .= 'fk_pilot,';
        $sql .= 'fk_organisateur,';
        $sql .= 'is_facture,';
        $sql .= 'kilometers,';
        $sql .= 'cost,';
        $sql .= 'fk_receiver,';
        $sql .= 'justif_kilometers,';
        $sql .= 'date_creation,';
        $sql .= 'date_update,';
        $sql .= 'passenger_names';
        $sql .= ') VALUES (';

        $sql .= sprintf('%s, %s, %s,', $nextId, $nextId, $nextId);
        $sql .= ' ' . (!isset($this->date) || dol_strlen($this->date) == 0 ? 'NULL' : "'" . $this->db->idate($this->date) . "'") . ',';
        $sql .= ' ' . (!isset($this->lieuD) ? 'NULL' : "'" . $this->db->escape($this->lieuD) . "'") . ',';
        $sql .= ' ' . (!isset($this->lieuA) ? 'NULL' : "'" . $this->db->escape($this->lieuA) . "'") . ',';
        $sql .= ' ' . (!isset($this->heureD) ? 'NULL' : "'" . $this->heureD . "'") . ',';
        $sql .= ' ' . (!isset($this->heureA) ? 'NULL' : "'" . $this->heureA . "'") . ',';
        $sql .= ' ' . (!isset($this->BBC_ballons_idBBC_ballons) ? 'NULL' : $this->BBC_ballons_idBBC_ballons) . ',';
        $sql .= ' ' . (!isset($this->nbrPax) ? 'NULL' : "'" . $this->db->escape($this->nbrPax) . "'") . ',';
        $sql .= ' ' . (!isset($this->remarque) ? 'NULL' : "'" . $this->db->escape($this->remarque) . "'") . ',';
        $sql .= ' ' . (!isset($this->incidents) ? 'NULL' : "'" . $this->db->escape($this->incidents) . "'") . ',';
        $sql .= ' ' . (!isset($this->fk_type) || (int) $this->fk_type === -1 ? 'NULL' : $this->fk_type) . ',';
        $sql .= ' ' . (!isset($this->fk_pilot) || (int) $this->fk_pilot === -1 ? 'NULL' : $this->fk_pilot) . ',';
        $sql .= ' ' . (!isset($this->fk_organisateur) || (int) $this->fk_organisateur === -1 ? 'NULL' : $this->fk_organisateur) . ',';
        $sql .= ' ' . (!isset($this->is_facture) ? '0' : $this->is_facture) . ',';
        $sql .= ' ' . (!isset($this->kilometers) || empty($this->kilometers) ? '0' : $this->kilometers) . ',';
        $sql .= ' ' . (!isset($this->cost) ? 'NULL' : "'" . $this->db->escape($this->cost) . "'") . ',';
        $sql .= ' ' . (!isset($this->fk_receiver) || (int) $this->fk_receiver === -1 ? 'NULL' : $this->fk_receiver) . ',';
        $sql .= ' ' . (!isset($this->justif_kilometers) ? 'NULL' : "'" . $this->db->escape($this->justif_kilometers) . "'") . ',';
        $sql .= ' ' . "'" . date('Y-m-d H:i:s') . "'" . ',';
        $sql .= ' ' . "'" . date('Y-m-d H:i:s') . "'" . ',';
        $sql .= ' ' . "'" . $this->passengerNames . "'" ;
        $sql .= ')';

        $this->db->begin();

        $resql = $this->db->query($sql);
        if (!$resql) {
            $error++;
            $this->errors[] = 'Error ' . $this->db->lasterror();
            dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
        }

        if (!$error) {
            $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX . $this->table_element);
            if(!$this->insertOrders()){
                $error++;
            }

            if (!$notrigger) {
                $result = $this->call_trigger('BBC_FLIGHT_CREATED', $user);
                if ($result < 0) {
                    $error++;
                }
            }
        }

        // Commit or rollback
        if ($error) {
            $this->db->rollback();

            return -1 * $error;
        }

        $this->db->commit();
        return $this->id;
    }

    /**
     * Inserts the order linked to the flight
     */
    private function insertOrders(){

        if(empty($this->orderIds)){
            return true;
        }

        $valueTemplate = '(%s, %s, %s)';
        
        // Insert request
        $sql = 'INSERT INTO llx_bbc_vols_orders(';
        $sql .= 'order_id,';
        $sql .= 'flight_id,';
        $sql .= 'nbr_passengers';
        $sql .= ') VALUES %s';
        
        $values = [];

        foreach($this->orderIds as $orderId=>$nbrPassengers){
            $values[] = sprintf(
                $valueTemplate,
                $orderId,
                $this->db->escape($this->id),
                (!isset($nbrPassengers) ? '0' :  $this->db->escape($nbrPassengers))
            );
        }

        $resql = $this->db->query(sprintf($sql, implode(',', $values)));

        if (!$resql) {

            $this->errors[] = 'Error ' . $this->db->lasterror();
            dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
            return false;
        }

        return true;
    }

    /**
     * Inserts the order linked to the flight
     */
    private function updateOrders(){

        if(empty($this->orderIds)){
            return true;
        }

        $this->deleteOrders();
        $this->insertOrders();
    }

    /**
     * Inserts the order linked to the flight
     */
    private function deleteOrders(){

        if(empty($this->orderIds)){
            return true;
        }

        $sql = 'DELETE FROM `llx_bbc_vols_orders` WHERE flight_id = %s';
        $resql = $this->db->query(sprintf($sql, $this->db->escape($this->id)));

        if (!$resql) {

            $this->errors[] = 'Error ' . $this->db->lasterror();
            dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
            return false;
        }

        return true;
    }

    /**
     * Load object in memory from the database
     *
     * @param int    $id  Id object
     * @param string $ref Ref
     *
     * @return int <0 if KO, 0 if not found, >0 if OK
     * @throws Exception
     */
    public function fetch($id, $ref = null)
    {
        dol_syslog(__METHOD__, LOG_DEBUG);

        $sql = 'SELECT';
        $sql .= " t.idBBC_vols,";
        $sql .= " t.date,";
        $sql .= " t.lieuD,";
        $sql .= " t.lieuA,";
        $sql .= " t.heureD,";
        $sql .= " t.heureA,";
        $sql .= " t.BBC_ballons_idBBC_ballons,";
        $sql .= " t.nbrPax,";
        $sql .= " t.remarque,";
        $sql .= " t.incidents,";
        $sql .= " t.fk_type,";
        $sql .= " t.fk_pilot,";
        $sql .= " t.fk_organisateur,";
        $sql .= " t.is_facture,";
        $sql .= " t.kilometers,";
        $sql .= " t.cost,";
        $sql .= " t.fk_receiver,";
        $sql .= " t.justif_kilometers,";
        $sql .= " t.date_creation,";
        $sql .= " t.date_update,";
        $sql .= " t.passenger_names,";
        $sql .= " t.fk_project";


        $sql .= ' FROM ' . MAIN_DB_PREFIX . $this->table_element . ' as t';
        if (null !== $ref) {

            $sql .= ' WHERE t.ref = ' . '\'' . $ref . '\'';
        } else {
            $sql .= ' WHERE t.idBBC_vols = ' . $id;
        }

        $resql = $this->db->query($sql);
        if ($resql) {
            $numrows = $this->db->num_rows($resql);
            if ($numrows) {
                $obj = $this->db->fetch_object($resql);

                $this->id = $obj->idBBC_vols;

                $this->idBBC_vols = (int) $obj->idBBC_vols;
                $this->date = $this->db->jdate($obj->date);
                $this->lieuD = $obj->lieuD;
                $this->lieuA = $obj->lieuA;
                $this->heureD = $obj->heureD;
                $this->heureA = $obj->heureA;
                $this->BBC_ballons_idBBC_ballons = (int) $obj->BBC_ballons_idBBC_ballons;
                $this->nbrPax = $obj->nbrPax;
                $this->remarque = $obj->remarque;
                $this->incidents = $obj->incidents;
                $this->fk_type = (int) $obj->fk_type;
                $this->fk_pilot = (int) $obj->fk_pilot;
                $this->fk_organisateur = (int) $obj->fk_organisateur;
                $this->statut = $this->is_facture = (int) $obj->is_facture;
                $this->kilometers = $obj->kilometers;
                $this->total_ttc = $this->cost = $obj->cost;
                $this->fk_receiver = (int) $obj->fk_receiver;
                $this->justif_kilometers = $obj->justif_kilometers;
                $this->date_creation = $obj->date_creation;
                $this->date_update = $obj->date_update;
                $this->passengerNames = $obj->passenger_names;
                $this->fk_project = $obj->fk_project;

                $this->balloon = $this->fetchBalloon();
                $this->thirdparty = $this->pilot = $this->fetchUser($this->fk_pilot);
                $this->fetchOrder();
            }
            $this->db->free($resql);

            if ($numrows) {
                return 1;
            } else {
                return 0;
            }
        }

        $this->errors[] = 'Error ' . $this->db->lasterror();
        dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
        return -1;
    }

    /**
     * @param  User $user      User that modifies
     * @param  bool $notrigger false=launch triggers after, true=disable triggers
     *
     * @return int <0 if KO, >0 if OK
     * @throws Exception
     */
    public function update(User $user, $notrigger = false)
    {
        $error = 0;

        dol_syslog(__METHOD__, LOG_DEBUG);

        // Clean parameters

        if (isset($this->idBBC_vols)) {
            $this->idBBC_vols = trim($this->idBBC_vols);
        }
        if (isset($this->lieuD)) {
            $this->lieuD = trim($this->lieuD);
        }
        if (isset($this->lieuA)) {
            $this->lieuA = trim($this->lieuA);
        }
        if (isset($this->heureD)) {
            $this->heureD = trim($this->heureD);
        }
        if (isset($this->heureA)) {
            $this->heureA = trim($this->heureA);
        }
        if (isset($this->BBC_ballons_idBBC_ballons)) {
            $this->BBC_ballons_idBBC_ballons = trim($this->BBC_ballons_idBBC_ballons);
        }
        if (isset($this->nbrPax)) {
            $this->nbrPax = trim($this->nbrPax);
        }
        if (isset($this->remarque)) {
            $this->remarque = trim($this->remarque);
        }
        if (isset($this->incidents)) {
            $this->incidents = trim($this->incidents);
        }
        if (isset($this->fk_type)) {
            $this->fk_type = trim($this->fk_type);
        }
        if (isset($this->fk_pilot)) {
            $this->fk_pilot = trim($this->fk_pilot);
        }
        if (isset($this->fk_organisateur)) {
            $this->fk_organisateur = trim($this->fk_organisateur);
        }
        if (isset($this->is_facture)) {
            $this->is_facture = trim($this->is_facture);
        }
        if (isset($this->kilometers)) {
            $this->kilometers = trim($this->kilometers);
        }
        if (isset($this->cost)) {
            $this->cost = trim($this->cost);
        }
        if (isset($this->fk_receiver)) {
            $this->fk_receiver = trim($this->fk_receiver);
        }
        if (isset($this->justif_kilometers)) {
            $this->justif_kilometers = trim($this->justif_kilometers);
        }
        if (isset($this->passengerNames)) {
            $this->passengerNames = trim($this->passengerNames);
        }


        // Check parameters
        // Put here code to add a control on parameters values

        // Update request
        $sql = 'UPDATE ' . MAIN_DB_PREFIX . $this->table_element . ' SET';

        $sql .= ' date = ' . (!isset($this->date) || dol_strlen($this->date) != 0 ? "'" . $this->db->idate($this->date) . "'" : 'null') . ',';
        $sql .= ' lieuD = ' . (isset($this->lieuD) ? "'" . $this->db->escape($this->lieuD) . "'" : "null") . ',';
        $sql .= ' lieuA = ' . (isset($this->lieuA) ? "'" . $this->db->escape($this->lieuA) . "'" : "null") . ',';
        $sql .= ' heureD = ' . (isset($this->heureD) ? "'" . $this->heureD . "'" : "null") . ',';
        $sql .= ' heureA = ' . (isset($this->heureA) ? "'" . $this->heureA . "'" : "null") . ',';
        $sql .= ' BBC_ballons_idBBC_ballons = ' . (isset($this->BBC_ballons_idBBC_ballons) ? $this->BBC_ballons_idBBC_ballons : "null") . ',';
        $sql .= ' nbrPax = ' . (isset($this->nbrPax) ? "'" . $this->db->escape($this->nbrPax) . "'" : "null") . ',';
        $sql .= ' remarque = ' . (isset($this->remarque) ? "'" . $this->db->escape($this->remarque) . "'" : "null") . ',';
        $sql .= ' incidents = ' . (isset($this->incidents) ? "'" . $this->db->escape($this->incidents) . "'" : "null") . ',';
        $sql .= ' fk_type = ' . (isset($this->fk_type) && (int) $this->fk_type > 0 ? $this->fk_type : "null") . ',';
        $sql .= ' fk_pilot = ' . (isset($this->fk_pilot) && (int) $this->fk_pilot > 0 ? $this->fk_pilot : "null") . ',';
        $sql .= ' fk_organisateur = ' . (isset($this->fk_organisateur) && (int) $this->fk_organisateur > 0 ? $this->fk_organisateur : "null") . ',';
        $sql .= ' is_facture = ' . (isset($this->is_facture) ? $this->is_facture : "0") . ',';
        $sql .= ' kilometers = ' . (!empty($this->kilometers) ? $this->kilometers : "0") . ',';
        $sql .= ' cost = ' . (isset($this->cost) ? "'" . $this->db->escape($this->cost) . "'" : "''") . ',';
        $sql .= ' fk_receiver = ' . (isset($this->fk_receiver) && (int) $this->fk_receiver > 0 ? $this->fk_receiver : "null") . ',';
        $sql .= ' justif_kilometers = ' . (isset($this->justif_kilometers) ? "'" . $this->db->escape($this->justif_kilometers) . "'," : "'',");
        $sql .= ' date_update = ' . "'" . date('Y-m-d H:i:s') . "',";
        $sql .= ' passenger_names = ' . "'" . trim($this->passengerNames);

        $sql .= ' WHERE idBBC_vols=' . $this->idBBC_vols;

        $this->db->begin();

        $resql = $this->db->query($sql);
        if (!$resql) {
            $error++;
            $this->errors[] = 'Error ' . $this->db->lasterror();
            dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
        }

        if (!$error && !$notrigger) {
            $result = $this->call_trigger('BBC_FLIGHT_UPDATED', $user);
            if ($result < 0) {
                $error++;
            }
        }

        // Commit or rollback
        if ($error) {
            $this->db->rollback();

            return -1 * $error;
        }

        $this->updateOrders();

        $this->db->commit();
        return 1;
    }

    /**
     * Delete object in database
     *
     * @param User $user      User that deletes
     * @param bool $notrigger false=launch triggers after, true=disable triggers
     *
     * @return int <0 if KO, >0 if OK
     * @throws Exception
     */
    public function delete(User $user, $notrigger = false)
    {
        dol_syslog(__METHOD__, LOG_DEBUG);

        $error = 0;

        $this->db->begin();

        if (!$error) {
            if (!$notrigger) {
                $result = $this->call_trigger('BBC_FLIGHT_DELETED', $user);
                if ($result < 0) {
                    $error++;
                }
            }
        }

        if (!$error) {

            $sql = 'DELETE FROM ' . MAIN_DB_PREFIX . $this->table_element;
            $sql .= ' WHERE idBBC_vols=' . $this->idBBC_vols;

            $resql = $this->db->query($sql);
            if (!$resql) {
                $error++;
                $this->errors[] = 'Error ' . $this->db->lasterror();
                dol_syslog(__METHOD__ . ' ' . join(',', $this->errors), LOG_ERR);
            }
        }

        // Commit or rollback
        if ($error) {
            $this->db->rollback();
            return -1 * $error;
        }

        $this->db->commit();
        return 1;
    }

    /**
     *  Return a link to the user card (with optionaly the picto)
     *    Use this->id,this->lastname, this->firstname
     *
     * @param    int     $withpicto Include picto in link (0=No picto, 1=Include picto into link, 2=Only picto)
     * @param    string  $option    On what the link point to
     * @param    integer $notooltip 1=Disable tooltip
     * @param    int     $maxlen    Max length of visible user name
     * @param  string    $morecss   Add more css on link
     *
     * @return    string                        String with URL
     */
    public function getNomUrl($withpicto = 0, $option = '', $notooltip = 0, $maxlen = 24, $morecss = '')
    {
        global $langs;

        $result = '';

        $label = '<u>' . $langs->trans("MyModule") . '</u>';
        $label .= '<div width="100%">';
        $label .= '<b>' . $langs->trans('Ref') . ':</b> ' . $this->idBBC_vols . '<br>';
        $label .= '<b>' . $langs->trans('Date') . ':</b> ' . dol_print_date($this->date, '%d-%m-%Y') . '<br/>';
        $label .= '<b>' . $langs->trans('T') . '</b> ' . $this->fk_type . '<br/>';
        $label .= '<b>' . $langs->trans('De') . ':</b> ' . $this->lieuD . '<br/>';
        $label .= '<b>' . $langs->trans('à') . ':</b> ' . $this->lieuA . '<br/>';
        $label .= '</div>';

        $link = '<a href="' . DOL_URL_ROOT . '/flightlog/card.php?id=' . $this->idBBC_vols . '"';
        $link .= ($notooltip ? '' : ' title="' . dol_escape_htmltag($label,
                1) . '" class="classfortooltip' . ($morecss ? ' ' . $morecss : '') . '"');
        $link .= '>';
        $linkend = '</a>';

        if ($withpicto) {

            $result .= ($link . img_object(($notooltip ? '' : $label), 'label',
                    ($notooltip ? '' : 'class="classfortooltip"')) . $linkend);
            if ($withpicto != 2) {
                $result .= ' ';
            }
        }
        $result .= $link . $this->idBBC_vols . $linkend;
        return $result;
    }

    /**
     *  Retourne le libelle du status d'un user (actif, inactif)
     *
     * @param    int $mode 0=libelle long, 1=libelle court, 2=Picto + Libelle court, 3=Picto, 4=Picto + Libelle long, 5=Libelle court + Picto
     *
     * @return    string                   Label of status
     */
    public function getLibStatut($mode = 0)
    {
        return $this->LibStatut($this->is_facture, $mode);
    }

    /**
     * Renvoi le libelle d'un status donne
     *
     * @param int $status Id status
     * @param int $mode   0=libelle long, 1=libelle court, 2=Picto + Libelle court, 3=Picto, 4=Picto + Libelle long, 5=Libelle court + Picto
     *
     * @return string                    Label of status
     */
    private function LibStatut($status, $mode = 0)
    {
        global $langs;

        $billDone = $langs->trans('Facturé');
        $billNotDone = $langs->trans('Ouvert');

        if ($mode == 0) {

            if ($status == 1) {
                return $billDone;
            }
            if ($status == 0) {
                return $billNotDone;
            }
        }
        if ($mode == 1) {

            if ($status == 1) {
                return $billDone;
            }
            if ($status == 0) {
                return $billNotDone;
            }
        }
        if ($mode == 2) {

            if ($status == 1) {
                return img_picto($billDone, 'statut4') . ' ' . $billDone;
            }
            if ($status == 0) {
                return img_picto($billNotDone, 'statut5') . ' ' . $billNotDone;
            }
        }
        if ($mode == 3) {
            if ($status == 1) {
                return img_picto($billDone, 'statut4');
            }
            if ($status == 0) {
                return img_picto($billNotDone, 'statut5');
            }
        }
        if ($mode == 4) {

            if ($status == 1) {
                return img_picto($billDone, 'statut4') . ' ' . $billDone;
            }
            if ($status == 0) {
                return img_picto($billNotDone, 'statut5') . ' ' . $billNotDone;
            }
        }
        if ($mode == 5) {

            if ($status == 1) {
                return $billDone . ' ' . img_picto($billDone, 'statut4');
            }
            if ($status == 0) {
                return $billNotDone . ' ' . img_picto($billNotDone, 'statut5');
            }
        }

        return "";
    }

    /**
     * @return string
     */
    public function __toString()
    {
        return $this->idBBC_vols . " " . $this->getPlaces();
    }

    /**
     * @return string
     */
    public function toString()
    {
        return "" . $this;
    }

    /**
     * @return string
     */
    public function getStatus()
    {
        return $this->statut;
    }

    /**
     * @return boolean
     */
    public function hasFacture()
    {
        $this->fetchObjectLinked($this->id, $this->element);

        return isset($this->linkedObjectsIds['facture']) && count($this->linkedObjectsIds['facture']) > 0;
    }

    /**
     * @param int $userId
     *
     * @return User
     */
    private function fetchUser($userId)
    {
        $user = new User($this->db);
        $user->fetch($userId);

        return $user;
    }

    /**
     * @return Bbc_ballons
     */
    private function fetchBalloon()
    {
        $balloon = new Bbc_ballons($this->db);
        $balloon->fetch($this->BBC_ballons_idBBC_ballons);

        return $balloon;
    }

    /**
     * @return Bbc_ballons
     */
    public function getBalloon()
    {
        if (!$this->balloon) {
            $this->balloon = $this->fetchBalloon();
        }

        return $this->balloon;
    }

    /**
     * @return User
     */
    public function getPilot()
    {
        if (!$this->pilot) {
            $this->pilot = $this->fetchUser($this->fk_pilot);
        }

        return $this->pilot;
    }

    /**
     * @return int
     */
    public function getPilotId()
    {
        return (int) $this->fk_pilot;
    }

    /**
     * @return int
     */
    public function getOrganisatorId()
    {
        return (int) $this->fk_organisateur;
    }

    /**
     * @return Bbctypes
     */
    public function getFlightType()
    {
        $flightType = new Bbctypes($this->db);
        $flightType->fetch($this->fk_type);

        return $flightType;
    }

    /**
     * @return string
     */
    public function getComment()
    {
        return $this->remarque;
    }

    /**
     * @return string
     */
    public function getIncident()
    {
        return $this->incidents;
    }

    /**
     * Return true if the number of pax is greater than 0
     *
     * @return boolean
     */
    public function hasPax()
    {
        return (int) $this->nbrPax > 0;
    }

    /**
     * Regarding the type of the flight give an indication if the flight must have pax to be valid.
     *
     * @return boolean
     */
    public function mustHavePax()
    {
        return $this->getFlightType()->isPaxRequired();
    }

    /**
     * Returns true if the amount requested by the flight is 0.
     *
     * @return boolean
     */
    public function isFree()
    {
        return empty($this->cost) || intval($this->cost) === 0;
    }

    /**
     * @return int
     */
    public function getAmountReceived()
    {
        return $this->cost;
    }

    /**
     * @return float
     */
    public function getAmountPerPassenger()
    {
        $nbrPax = $this->nbrPax > 0 ? $this->nbrPax : 1;
        return $this->cost / $nbrPax;
    }

    /**
     * @return boolean
     */
    public function hasReceiver()
    {
        return !empty($this->fk_receiver);
    }

    /**
     * @return boolean
     */
    public function hasKilometers()
    {
        return !empty($this->kilometers);
    }

    /**
     * @return boolean
     */
    public function hasKilometersDescription()
    {
        return !empty(trim($this->justif_kilometers));
    }

    /**
     * @return int
     */
    public function getKilometers()
    {
        return (int) $this->kilometers;
    }

    /**
     * @return string
     */
    public function getPlaces()
    {
        return $this->lieuD . ' -> ' . $this->lieuA;
    }

    /**
     * @return string
     */
    public function getDescription()
    {
        return $this->__toString() . ' - ' . $this->passengerNames;
    }

    /**
     * @return string
     */
    public function getPassengerNames()
    {
        return $this->passengerNames;
    }

    /**
     * @param string $passengerNames
     *
     * @return Bbcvols
     */
    public function setPassengerNames($passengerNames)
    {
        $this->passengerNames = $passengerNames;
        return $this;
    }

    /**
     * @return int
     */
    public function getNumberOfPassengers()
    {
        return (int) $this->nbrPax;
    }

    /**
     * @return int[]|array
     */
    public function getOrderIds()
    {
        return $this->orderIds;
    }

    /**
     * @param int $orderId
     * @param int $nbrPassengers
     */
    public function addOrderId($orderId, $nbrPassengers){
        if(!isset($this->orderIds)){
            $this->orderIds = [];
        }

        $this->orderIds[$orderId] = $nbrPassengers;
    }

    /**
     * Is an instruction flight (T6/T7)
     */
    public function isInstruction()
    {
        return $this->getFlightType()->isInstruction();
    }

    /**
     * @return bool
     */
    public function isLinkedToOrder()
    {
        return isset($this->orderIds) && !empty($this->orderIds);
    }

    /**
     * Fetch the orders based on the order ids.
     */
    public function fetchOrder()
    {
        $sql = 'SELECT';
        $sql .= " t.order_id,";
        $sql .= " t.flight_id,";
        $sql .= " t.nbr_passengers";

        $sql .= ' FROM llx_bbc_vols_orders as t';
        $sql .= sprintf(' WHERE t.flight_id = %s', $this->id);

        $resql = $this->db->query($sql);
        if ($resql) {
            $numrows = $this->db->num_rows($resql);
            if ($numrows) {
                for($i = 0 ; $i < $numrows ; $i++){
                    $obj = $this->db->fetch_object($resql);
                    $this->orderIds[$obj->order_id] = $obj->nbr_passengers;

                    $order = new Commande($this->db);
                    $order->fetch($obj->order_id);

                    $this->orders[$obj->order_id] = $order;
                }

            }
        }

        return $this;
    }

    /**
     * @return Commande[]|array
     */
    public function getOrders()
    {
        if(!isset($this->orders) || empty($this->orders)){
            $this->fetchOrder();
        }
        return $this->orders;
    }

    /**
     * Flag the flight as billed
     *
     * @return $this
     */
    public function bill()
    {
        $this->is_facture = true;
        return $this;
    }

    /**
     * @return boolean
     */
    public function isBilled()
    {
        return !empty($this->is_facture);
    }

    /**
     * @return DateTime
     */
    public function getDate()
    {
        return (new DateTime())->setTimestamp($this->date);
    }

    /**
     * @param string $date
     *
     * @return Bbcvols
     */
    public function setDate($date)
    {
        $this->date = $date;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getLieuD()
    {
        return $this->lieuD;
    }

    /**
     * @param mixed $lieuD
     *
     * @return Bbcvols
     */
    public function setLieuD($lieuD)
    {
        $this->lieuD = $lieuD;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getLieuA()
    {
        return $this->lieuA;
    }

    /**
     * @param mixed $lieuA
     *
     * @return Bbcvols
     */
    public function setLieuA($lieuA)
    {
        $this->lieuA = $lieuA;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getHeureD()
    {
        return $this->heureD;
    }

    /**
     * @param mixed $heureD
     *
     * @return Bbcvols
     */
    public function setHeureD($heureD)
    {
        $this->heureD = $heureD;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getHeureA()
    {
        return $this->heureA;
    }

    /**
     * @param mixed $heureA
     *
     * @return Bbcvols
     */
    public function setHeureA($heureA)
    {
        $this->heureA = $heureA;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getBBCBallonsIdBBCBallons()
    {
        return $this->BBC_ballons_idBBC_ballons;
    }

    /**
     * @param mixed $BBC_ballons_idBBC_ballons
     *
     * @return Bbcvols
     */
    public function setBBCBallonsIdBBCBallons($BBC_ballons_idBBC_ballons)
    {
        $this->BBC_ballons_idBBC_ballons = $BBC_ballons_idBBC_ballons;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getNbrPax()
    {
        return $this->nbrPax;
    }

    /**
     * @param mixed $nbrPax
     *
     * @return Bbcvols
     */
    public function setNbrPax($nbrPax)
    {
        $this->nbrPax = $nbrPax;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getRemarque()
    {
        return $this->remarque;
    }

    /**
     * @param mixed $remarque
     *
     * @return Bbcvols
     */
    public function setRemarque($remarque)
    {
        $this->remarque = $remarque;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getIncidents()
    {
        return $this->incidents;
    }

    /**
     * @param mixed $incidents
     *
     * @return Bbcvols
     */
    public function setIncidents($incidents)
    {
        $this->incidents = $incidents;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getFkType()
    {
        return $this->fk_type;
    }

    /**
     * @param mixed $fk_type
     *
     * @return Bbcvols
     */
    public function setFkType($fk_type)
    {
        $this->fk_type = $fk_type;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getFkPilot()
    {
        return $this->fk_pilot;
    }

    /**
     * @param mixed $fk_pilot
     *
     * @return Bbcvols
     */
    public function setFkPilot($fk_pilot)
    {
        $this->fk_pilot = $fk_pilot;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getFkOrganisateur()
    {
        return $this->fk_organisateur;
    }

    /**
     * @param mixed $fk_organisateur
     *
     * @return Bbcvols
     */
    public function setFkOrganisateur($fk_organisateur)
    {
        $this->fk_organisateur = $fk_organisateur;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getisFacture()
    {
        return $this->is_facture;
    }

    /**
     * @param mixed $is_facture
     *
     * @return Bbcvols
     */
    public function setIsFacture($is_facture)
    {
        $this->is_facture = $is_facture;
        return $this;
    }

    /**
     * @return int
     */
    public function getCost()
    {
        return $this->cost;
    }

    /**
     * @param int $cost
     *
     * @return Bbcvols
     */
    public function setCost($cost)
    {
        $this->cost = $cost;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getFkReceiver()
    {
        return $this->fk_receiver;
    }

    /**
     * @param mixed $fk_receiver
     *
     * @return Bbcvols
     */
    public function setFkReceiver($fk_receiver)
    {
        $this->fk_receiver = $fk_receiver;
        return $this;
    }

    /**
     * @return mixed
     */
    public function getJustifKilometers()
    {
        return $this->justif_kilometers;
    }

    /**
     * @param mixed $justif_kilometers
     *
     * @return Bbcvols
     */
    public function setJustifKilometers($justif_kilometers)
    {
        $this->justif_kilometers = $justif_kilometers;
        return $this;
    }

    /**
     * @return bool
     */
    public function hasProject()
    {
        return $this->fk_project !== null;
    }

    /**
     * @return string|int
     */
    private function getNextId()
    {
        /** @var mysqli_result $result */
        $result = $this->db->query("SELECT
        auto_increment
    FROM
        information_schema.tables
    WHERE
        table_name = 'llx_bbc_vols'
        and table_schema = database();");

        return $result->fetch_assoc()['auto_increment'];
    }


}

laudeco / bbc-dolibarr-flightlog

Push — feature/select_existing_custom... ( a1e51a )

Bbcvols::insertOrders() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
