Product::hasbatch() - Code Metrics - alxarafe/alixar - Measure and Improve Code Quality continuously with Scrutinizer

Product::hasbatch() A
last analyzed 2024-11-03 11:50 UTC

↳ Parent: Product
Complexity

Conditions	2
Paths	2
Size

Total Lines	3
Code Lines	1
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	2
eloc	1
nc	2
nop	0
dl	0
loc	3
rs	10
c	0
b	0
f	0
<?php

/* Copyright (C) 2001-2007  Rodolphe Quiedeville        <[email protected]>
 * Copyright (C) 2004-2014	Laurent Destailleur		    <[email protected]>
 * Copyright (C) 2005-2015	Regis Houssin			    <[email protected]>
 * Copyright (C) 2006		Andre Cianfarani		    <[email protected]>
 * Copyright (C) 2007-2011	Jean Heimburger			    <[email protected]>
 * Copyright (C) 2010-2018	Juanjo Menent			    <[email protected]>
 * Copyright (C) 2012       Cedric Salvador             <[email protected]>
 * Copyright (C) 2013-2014	Cedric GROSS			    <[email protected]>
 * Copyright (C) 2013-2016	Marcos García			    <[email protected]>
 * Copyright (C) 2011-2021	Open-DSI				    <[email protected]>
 * Copyright (C) 2014		Henry Florian			    <[email protected]>
 * Copyright (C) 2014-2016	Philippe Grand			    <[email protected]>
 * Copyright (C) 2014		Ion agorria			        <[email protected]>
 * Copyright (C) 2016-2024	Ferran Marcet			    <[email protected]>
 * Copyright (C) 2017		Gustavo Novaro
 * Copyright (C) 2019-2024  Frédéric France             <[email protected]>
 * Copyright (C) 2023		Benjamin Falière		    <[email protected]>
 * Copyright (C) 2024		MDW						    <[email protected]>
 * Copyright (C) 2024       Rafael San José             <[email protected]>
 *
 * 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 <https://www.gnu.org/licenses/>.
 */

namespace Dolibarr\Code\Product\Classes;

use Dolibarr\Code\Categories\Classes\Categorie;
use Dolibarr\Code\Expedition\Classes\Expedition;
use Dolibarr\Code\Product\Model\ProductLot;
.
|-- OtherDir
|   |-- Bar.php
|   `-- Foo.php
`-- SomeDir
    `-- Foo.php
use Dolibarr\Code\User\Classes\User;
use Dolibarr\Code\Variants\Model\ProductAttributeCombination;
use Dolibarr\Core\Base\CommonObject;
use DoliDB;

/**
 *    \file       htdocs/product/class/product.class.php
 *    \ingroup    produit
 *    \brief      File of class to manage the predefined products or services
 */

require_once constant('DOL_DOCUMENT_ROOT') . '/core/lib/product.lib.php';

/**
 * Class to manage products or services
 */
class Product extends CommonObject
{
    /**
     * Const sell or eat by mandatory id
     */
    const SELL_OR_EAT_BY_MANDATORY_ID_NONE = 0;
    const SELL_OR_EAT_BY_MANDATORY_ID_SELL_BY = 1;
    const SELL_OR_EAT_BY_MANDATORY_ID_EAT_BY = 2;
    const SELL_OR_EAT_BY_MANDATORY_ID_SELL_AND_EAT = 3;
    /**
     * Regular product
     */
    const TYPE_PRODUCT = 0;
    /**
     * Service
     */
    const TYPE_SERVICE = 1;
    /**
     * @var string ID to identify managed object
     */
    public $element = 'product';
    /**
     * @var string Name of table without prefix where object is stored
     */
    public $table_element = 'product';
    /**
     * @var string Field with ID of parent key if this field has a parent
     */
    public $fk_element = 'fk_product';
    /**
     * @var static
     */
    public $oldcopy;
    /**
     * @var string picto
     */
    public $picto = 'product';
    public $regeximgext = '\.gif|\.jpg|\.jpeg|\.png|\.bmp|\.webp|\.xpm|\.xbm'; // See also into images.lib.php

    /**
     * @deprecated  Use $label instead
     * @see $label
     */
    public $libelle;

    /**
     * Product label
     *
     * @var string
     */
    public $label;

    /**
     * Product description
     *
     * @var string
     */
    public $description;

    /**
     * Product other fields PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION
     *
     * @var string
     */
    public $other;

    /**
     * Check TYPE constants
     *
     * @var int
     */
    public $type = self::TYPE_PRODUCT;

    /**
     * Selling price without tax
     *
     * @var float
     */
    public $price;

    public $price_formated;         // used by takepos/ajax/ajax.php

    /**
     * Selling price with tax
     *
     * @var float
     */
    public $price_ttc;

    public $price_ttc_formated;     // used by takepos/ajax/ajax.php

    /**
     * Minimum price net
     *
     * @var float
     */
    public $price_min;

    /**
     * Minimum price with tax
     *
     * @var float
     */
    public $price_min_ttc;

    /**
     * Base price ('TTC' for price including tax or 'HT' for net price)
     * @var string
     */
    public $price_base_type;
    public $price_label;

    //! Arrays for multiprices
    public $multiprices = array();
    public $multiprices_ttc = array();
    public $multiprices_base_type = array();
    public $multiprices_default_vat_code = array();
    public $multiprices_min = array();
    public $multiprices_min_ttc = array();
    public $multiprices_tva_tx = array();
    public $multiprices_recuperableonly = array();

    //! Price by quantity arrays
    public $price_by_qty;
    public $prices_by_qty = array();
    public $prices_by_qty_id = array();
    public $prices_by_qty_list = array();

    /**
     * @var int price level set after updateprice for trigger
     */
    public $level;

    //! Array for multilangs
    public $multilangs = array();

    //! Default VAT code for product (link to code into llx_c_tva but without foreign keys)
    public $default_vat_code;

    //! Default VAT rate of product
    public $tva_tx;

    /**
     * int  French VAT NPR is used (0 or 1)
     */
    public $tva_npr = 0;

    //! Default discount percent
    public $remise_percent;

    //! Other local taxes
    public $localtax1_tx;
    public $localtax2_tx;
    public $localtax1_type;
    public $localtax2_type;

    // Properties set by get_buyprice() for return

    public $desc_supplier;
    public $vatrate_supplier;
    public $default_vat_code_supplier;
    public $fourn_multicurrency_price;
    public $fourn_multicurrency_unitprice;
    public $fourn_multicurrency_tx;
    public $fourn_multicurrency_id;
    public $fourn_multicurrency_code;
    public $packaging;


    /**
     * Lifetime (in seconds)
     *
     * @var int|null
     * @see ProductLot
     */
    public $lifetime;

    /**
     * Quality control frequency (in days ?)
     *
     * @var int|null
     * @see ProductLot
     */
    public $qc_frequency;

    /**
     * Stock real (denormalized data)
     *
     * @var int
     */
    public $stock_reel = 0;

    /**
     * Stock virtual
     *
     * @var int
     */
    public $stock_theorique;

    /**
     * Cost price
     *
     * @var float
     */
    public $cost_price;

    //! Average price value for product entry into stock (PMP)
    public $pmp;

    /**
     * Stock alert
     *
     * @var float
     */
    public $seuil_stock_alerte = 0;

    /**
     * Ask for replenishment when $desiredstock < $stock_reel
     */
    public $desiredstock = 0;

    /**
     * Service expiration
     */
    public $duration_value;
    /**
     * Service expiration unit
     */
    public $duration_unit;
    /**
     * Service expiration label (value + unit)
     */
    public $duration;

    /**
     * @var int Service Workstation
     */
    public $fk_default_workstation;

    /**
     * Status indicates whether the product is on sale '1' or not '0'
     *
     * @var int
     */
    public $status = 0;

    /**
     * Status indicates whether the product is on sale '1' or not '0'
     * @var int
     * @deprecated  Use $status instead
     * @see $status
     */
    public $tosell;

    /**
     * Status indicate whether the product is available for purchase '1' or not '0'
     *
     * @var int
     */
    public $status_buy = 0;

    /**
     * Status indicate whether the product is available for purchase '1' or not '0'
     * @var int
     * @deprecated Use $status_buy instead
     * @see $status_buy
     */
    public $tobuy;

    /**
     * Status indicates whether the product is a finished product '1' or a raw material '0'
     *
     * @var ?int
     */
    public $finished;

    /**
     * fk_default_bom indicates the default bom
     *
     * @var int
     */
    public $fk_default_bom;

    /**
     * product_fourn_price_id indicates the fourn price id
     *
     * @var int
     */
    public $product_fourn_price_id;

    /**
     * buyprice indicates buy price off the product
     *
     * @var float
     */
    public $buyprice;

    /**
     * for backward compatibility
     *
     * @var int
     */
    public $tobatch;


    /**
     * We must manage lot/batch number, sell-by date and so on : '0':no, '1':yes, '2": yes with unique serial number
     *
     * @var int
     */
    public $status_batch = 0;

    /**
     * Make sell-by or eat-by date mandatory
     *
     * @var int
     */
    public $sell_or_eat_by_mandatory = 0;

    /**
     * If allowed, we can edit batch or serial number mask for each product
     *
     * @var string
     */
    public $batch_mask = '';

    /**
     * Customs code
     *
     * @var string
     */
    public $customcode;

    /**
     * Product URL
     *
     * @var string
     */
    public $url;

    //! Metric of products
    public $weight;
    public $weight_units;   // scale -3, 0, 3, 6
    public $length;
    public $length_units;   // scale -3, 0, 3, 6
    public $width;
    public $width_units;    // scale -3, 0, 3, 6
    public $height;
    public $height_units;   // scale -3, 0, 3, 6
    public $surface;
    public $surface_units;  // scale -3, 0, 3, 6
    public $volume;
    public $volume_units;   // scale -3, 0, 3, 6

    public $net_measure;
    public $net_measure_units;  // scale -3, 0, 3, 6

    public $accountancy_code_sell;
    public $accountancy_code_sell_intra;
    public $accountancy_code_sell_export;
    public $accountancy_code_buy;
    public $accountancy_code_buy_intra;
    public $accountancy_code_buy_export;

    /**
     * @var string|int  Main Barcode value, -1 or 'auto' for auto code
     */
    public $barcode;

    /**
     * @var int     Main Barcode type ID
     */
    public $barcode_type;

    /**
     * @var string  Main Barcode type code
     */
    public $barcode_type_code;

    public $stats_propale = array();
    public $stats_commande = array();
    public $stats_contrat = array();
    public $stats_facture = array();
    public $stats_proposal_supplier = array();
    public $stats_commande_fournisseur = array();
    public $stats_expedition = array();
    public $stats_reception = array();
    public $stats_mo = array();
    public $stats_bom = array();
    public $stats_mrptoconsume = array();
    public $stats_mrptoproduce = array();
    public $stats_facturerec = array();
    public $stats_facture_fournisseur = array();

    //! Size of image
    public $imgWidth;
    public $imgHeight;

    /**
     * @var integer|string date_creation
     */
    public $date_creation;

    /**
     * @var integer|string date_modification
     */
    public $date_modification;

    //! Id du fournisseur
    public $product_fourn_id;

    //! Product ID already linked to a reference supplier
    public $product_id_already_linked;

    public $nbphoto = 0;

    //! Contains detail of stock of product into each warehouse
    public $stock_warehouse = array();

    /**
     * @var int Default warehouse Id
     */
    public $fk_default_warehouse;
    /**
     * @var int ID
     */
    public $fk_price_expression;

    /* To store supplier price found */
    public $fourn_qty;
    public $fourn_pu;
    public $fourn_price_base_type;

    /**
     * @var int ID
     */
    public $fourn_socid;

    /**
     * @deprecated
     * @see        $ref_supplier
     */
    public $ref_fourn;

    /**
     * @var string ref supplier
     */
    public $ref_supplier;

    /**
     * @var int|null                ID of the unit of measurement (rowid in llx_c_units table)
     * @see measuringUnitString()
     * @see getLabelOfUnit()
     */
    public $fk_unit;

    /**
     * Price is generated using multiprice rules
     *
     * @var int
     */
    public $price_autogen = 0;

    /**
     * Array with list of supplier prices of product
     *
     * @var array
     */
    public $supplierprices;

    /**
     * Array with list of sub-products for Kits
     *
     * @var array
     */
    public $sousprods;

    /**
     * @var array Path of subproducts. Build from ->sousprods with get_arbo_each_prod()
     */
    public $res;


    /**
     * Property set to save result of isObjectUsed(). Used for example by Product API.
     *
     * @var boolean
     */
    public $is_object_used;

    /**
     * If this Product is within a kit:
     * Quantity of this Product within this kit
     *
     * @var float
     * @see Product::is_sousproduit()       To set this property
     * @see Product::add_sousproduit()
     * @see Product::update_sousproduit()
     */
    public $is_sousproduit_qty;

    /**
     * If this Product is within a kit:
     * 1 = modify the stock of this child Product upon modification of the stock of its parent Product
     * ("incdec" stands for increase/decrease)
     *
     * @var 0|1

     * @see Product::is_sousproduit()       To set this property
     * @see Product::add_sousproduit()
     * @see Product::update_sousproduit()
     */
    public $is_sousproduit_incdec;

    public $mandatory_period;


    /**
     *  'type' if the field format ('integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter]]', 'varchar(x)', 'double(24,8)', 'real', 'price', 'text', 'html', 'date', 'datetime', 'timestamp', 'duration', 'mail', 'phone', 'url', 'password')
     *         Note: Filter can be a string like "(t.ref:like:'SO-%') or (t.date_creation:<:'20160101') or (t.nature:is:NULL)"
     *  'label' the translation key.
     *  'enabled' is a condition when the field must be managed (Example: 1 or 'getDolGlobalString("MY_SETUP_PARAM")'
     *  'position' is the sort order of field.
     *  'notnull' is set to 1 if not null in database. Set to -1 if we must set data to null if empty ('' or 0).
     *  'visible' says if field is visible in list (Examples: 0=Not visible, 1=Visible on list and create/update/view forms, 2=Visible on list only, 3=Visible on create/update/view form only (not list), 4=Visible on list and update/view form only (not create). 5=Visible on list and view only (not create/not update). Using a negative value means field is not shown by default on list but can be selected for viewing)
     *  'noteditable' says if field is not editable (1 or 0)
     *  'default' is a default value for creation (can still be overwrote by the Setup of Default Values if field is editable in creation form). Note: If default is set to '(PROV)' and field is 'ref', the default value will be set to '(PROVid)' where id is rowid when a new record is created.
     *  'index' if we want an index in database.
     *  'foreignkey'=>'tablename.field' if the field is a foreign key (it is recommended to name the field fk_...).
     *  'searchall' is 1 if we want to search in this field when making a search from the quick search button.
     *  'isameasure' must be set to 1 if you want to have a total on list for this field. Field type must be summable like integer or double(24,8).
     *  'css' is the CSS style to use on field. For example: 'maxwidth200'
     *  'help' is a string visible as a tooltip on field
     *  'showoncombobox' if value of the field must be visible into the label of the combobox that list record
     *  'disabled' is 1 if we want to have the field locked by a 'disabled' attribute. In most cases, this is never set into the definition of $fields into class, but is set dynamically by some part of code.
     *  'arrayofkeyval' to set list of value if type is a list of predefined values. For example: array("0"=>"Draft","1"=>"Active","-1"=>"Cancel")
     *  'autofocusoncreate' to have field having the focus on a create form. Only 1 field should have this property set to 1.
     *  'comment' is not used. You can store here any text of your choice. It is not used by application.
     *
     *  Note: To have value dynamic, you can set value to 0 in definition and edit the value on the fly into the constructor.
     */

    /**
     * @var array<string,array{type:string,label:string,enabled:int<0,2>|string,position:int,notnull?:int,visible:int,noteditable?:int,default?:string,index?:int,foreignkey?:string,searchall?:int,isameasure?:int,css?:string,csslist?:string,help?:string,showoncombobox?:int,disabled?:int,arrayofkeyval?:array<int,string>,comment?:string}>  Array with all fields and their property. Do not use it as a static var. It may be modified by constructor.

     */
    public $fields = array(
        'rowid' => array('type' => 'integer', 'label' => 'TechnicalID', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'index' => 1, 'position' => 1, 'comment' => 'Id'),
        'ref' => array('type' => 'varchar(128)', 'label' => 'Ref', 'enabled' => 1, 'visible' => 1, 'notnull' => 1, 'showoncombobox' => 1, 'index' => 1, 'position' => 10, 'searchall' => 1, 'comment' => 'Reference of object'),
        'entity' => array('type' => 'integer', 'label' => 'Entity', 'enabled' => 1, 'visible' => 0, 'default' => '1', 'notnull' => 1, 'index' => 1, 'position' => 5),
        'label' => array('type' => 'varchar(255)', 'label' => 'Label', 'enabled' => 1, 'visible' => 1, 'notnull' => 1, 'showoncombobox' => 2, 'position' => 15, 'csslist' => 'tdoverflowmax250'),
        'barcode' => array('type' => 'varchar(255)', 'label' => 'Barcode', 'enabled' => 'isModEnabled("barcode")', 'position' => 20, 'visible' => -1, 'showoncombobox' => 3, 'cssview' => 'tdwordbreak', 'csslist' => 'tdoverflowmax125'),
        'fk_barcode_type' => array('type' => 'integer', 'label' => 'BarcodeType', 'enabled' => 1, 'position' => 21, 'notnull' => 0, 'visible' => -1,),
        'note_public' => array('type' => 'html', 'label' => 'NotePublic', 'enabled' => 1, 'visible' => 0, 'position' => 61),
        'note' => array('type' => 'html', 'label' => 'NotePrivate', 'enabled' => 1, 'visible' => 0, 'position' => 62),
        'datec' => array('type' => 'datetime', 'label' => 'DateCreation', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'position' => 500),
        'tms' => array('type' => 'timestamp', 'label' => 'DateModification', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'position' => 501),
        //'date_valid'    =>array('type'=>'datetime',     'label'=>'DateCreation',     'enabled'=>1, 'visible'=>-2, 'position'=>502),
        'fk_user_author' => array('type' => 'integer', 'label' => 'UserAuthor', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'position' => 510, 'foreignkey' => 'llx_user.rowid'),
        'fk_user_modif' => array('type' => 'integer', 'label' => 'UserModif', 'enabled' => 1, 'visible' => -2, 'notnull' => -1, 'position' => 511),
        //'fk_user_valid' =>array('type'=>'integer',      'label'=>'UserValidation',        'enabled'=>1, 'visible'=>-1, 'position'=>512),
        'localtax1_tx' => array('type' => 'double(6,3)', 'label' => 'Localtax1tx', 'enabled' => 1, 'position' => 150, 'notnull' => 0, 'visible' => -1,),
        'localtax1_type' => array('type' => 'varchar(10)', 'label' => 'Localtax1type', 'enabled' => 1, 'position' => 155, 'notnull' => 1, 'visible' => -1,),
        'localtax2_tx' => array('type' => 'double(6,3)', 'label' => 'Localtax2tx', 'enabled' => 1, 'position' => 160, 'notnull' => 0, 'visible' => -1,),
        'localtax2_type' => array('type' => 'varchar(10)', 'label' => 'Localtax2type', 'enabled' => 1, 'position' => 165, 'notnull' => 1, 'visible' => -1,),
        'last_main_doc' => array('type' => 'varchar(255)', 'label' => 'LastMainDoc', 'enabled' => 1, 'visible' => -1, 'position' => 170),
        'import_key' => array('type' => 'varchar(14)', 'label' => 'ImportId', 'enabled' => 1, 'visible' => -2, 'notnull' => -1, 'index' => 0, 'position' => 1000),
        //'tosell'       =>array('type'=>'integer',      'label'=>'Status',           'enabled'=>1, 'visible'=>1,  'notnull'=>1, 'default'=>'0', 'index'=>1,  'position'=>1000, 'arrayofkeyval'=>array(0=>'Draft', 1=>'Active', -1=>'Cancel')),
        //'tobuy'        =>array('type'=>'integer',      'label'=>'Status',           'enabled'=>1, 'visible'=>1,  'notnull'=>1, 'default'=>'0', 'index'=>1,  'position'=>1000, 'arrayofkeyval'=>array(0=>'Draft', 1=>'Active', -1=>'Cancel')),
        'mandatory_period' => array('type' => 'integer', 'label' => 'mandatoryperiod', 'enabled' => 1, 'visible' => 1, 'notnull' => 1, 'default' => '0', 'index' => 1, 'position' => 1000),
    );
    /**
     * @var array<string, array<string>>    List of child tables. To test if we can delete object.
     */
    protected $childtables = array(
        'supplier_proposaldet' => array('name' => 'SupplierProposal', 'parent' => 'supplier_proposal', 'parentkey' => 'fk_supplier_proposal'),
        'propaldet' => array('name' => 'Proposal', 'parent' => 'propal', 'parentkey' => 'fk_propal'),
        'commandedet' => array('name' => 'Order', 'parent' => 'commande', 'parentkey' => 'fk_commande'),
        'facturedet' => array('name' => 'Invoice', 'parent' => 'facture', 'parentkey' => 'fk_facture'),
        'contratdet' => array('name' => 'Contract', 'parent' => 'contrat', 'parentkey' => 'fk_contrat'),
        'facture_fourn_det' => array('name' => 'SupplierInvoice', 'parent' => 'facture_fourn', 'parentkey' => 'fk_facture_fourn'),
        'commande_fournisseurdet' => array('name' => 'SupplierOrder', 'parent' => 'commande_fournisseur', 'parentkey' => 'fk_commande'),
        'mrp_production' => array('name' => 'Mo', 'parent' => 'mrp_mo', 'parentkey' => 'fk_mo')
    );
    /**
     * {@inheritdoc}
     */
    protected $table_ref_field = 'ref';

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

        $this->ismultientitymanaged = 1;
        $this->isextrafieldmanaged = 1;

        $this->canvas = '';
    }

    /**
     * Function used to replace a thirdparty id with another one.
     *
     * @param DoliDB $dbs Database handler
     * @param int $origin_id Old thirdparty id
     * @param int $dest_id New thirdparty id
     * @return bool
     */
    public static function replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
    {
        $tables = array(
            'product_customer_price',
            'product_customer_price_log'
        );

        return CommonObject::commonReplaceThirdparty($dbs, $origin_id, $dest_id, $tables);
    }

    /**
     *    Check that ref and label are ok
     *
     * @return int         >1 if OK, <=0 if KO
     */
    public function check()
    {
        if (getDolGlobalInt('MAIN_SECURITY_ALLOW_UNSECURED_REF_LABELS')) {
            $this->ref = trim($this->ref);
        } else {
            $this->ref = dol_sanitizeFileName(stripslashes($this->ref));
        }

        $err = 0;
        if (dol_strlen(trim($this->ref)) == 0) {
            $err++;
        }

        if (dol_strlen(trim($this->label)) == 0) {
            $err++;
        }

        if ($err > 0) {
            return 0;
        } else {
            return 1;
        }
    }

    /**
     * Insert product into database
     *
     * @param User $user User making insert
     * @param int $notrigger Disable triggers
     * @return int                      Id of product/service if OK, < 0 if KO
     */
    public function create($user, $notrigger = 0)
    {
        global $conf, $langs;

        $error = 0;

        // Clean parameters
        if (getDolGlobalInt('MAIN_SECURITY_ALLOW_UNSECURED_REF_LABELS')) {
            $this->ref = trim($this->ref);
        } else {
            $this->ref = dol_sanitizeFileName(dol_string_nospecial(trim($this->ref)));
        }
        $this->label = trim($this->label);
        $this->price_ttc = (float)price2num($this->price_ttc);
        $this->price = (float)price2num($this->price);
        $this->price_min_ttc = (float)price2num($this->price_min_ttc);
        $this->price_min = (float)price2num($this->price_min);
        $this->price_label = trim($this->price_label);
        if (empty($this->tva_tx)) {
            $this->tva_tx = 0;
        }
        if (empty($this->tva_npr)) {
            $this->tva_npr = 0;
        }
        //Local taxes
        if (empty($this->localtax1_tx)) {
            $this->localtax1_tx = 0;
        }
        if (empty($this->localtax2_tx)) {
            $this->localtax2_tx = 0;
        }
        if (empty($this->localtax1_type)) {
            $this->localtax1_type = '0';
        }
        if (empty($this->localtax2_type)) {
            $this->localtax2_type = '0';
        }
        if (empty($this->price)) {
            $this->price = 0;
        }
        if (empty($this->price_min)) {
            $this->price_min = 0;
        }
        // Price by quantity
        if (empty($this->price_by_qty)) {
            $this->price_by_qty = 0;
        }

        if (empty($this->status)) {
            $this->status = 0;
        }
        if (empty($this->status_buy)) {
            $this->status_buy = 0;
        }

        $price_ht = 0;
        $price_ttc = 0;
        $price_min_ht = 0;
        $price_min_ttc = 0;

        //
        if ($this->price_base_type == 'TTC' && $this->price_ttc > 0) {
            $price_ttc = price2num($this->price_ttc, 'MU');
            $price_ht = price2num($this->price_ttc / (1 + ($this->tva_tx / 100)), 'MU');
        }

        //
        if ($this->price_base_type != 'TTC' && $this->price > 0) {
            $price_ht = price2num($this->price, 'MU');
            $price_ttc = price2num($this->price * (1 + ($this->tva_tx / 100)), 'MU');
        }

        //
        if (($this->price_min_ttc > 0) && ($this->price_base_type == 'TTC')) {
            $price_min_ttc = price2num($this->price_min_ttc, 'MU');
            $price_min_ht = price2num($this->price_min_ttc / (1 + ($this->tva_tx / 100)), 'MU');
        }

        //
        if (($this->price_min > 0) && ($this->price_base_type != 'TTC')) {
            $price_min_ht = price2num($this->price_min, 'MU');
            $price_min_ttc = price2num($this->price_min * (1 + ($this->tva_tx / 100)), 'MU');
        }

        $this->accountancy_code_buy = trim($this->accountancy_code_buy);
        $this->accountancy_code_buy_intra = trim($this->accountancy_code_buy_intra);
        $this->accountancy_code_buy_export = trim($this->accountancy_code_buy_export);
        $this->accountancy_code_sell = trim($this->accountancy_code_sell);
        $this->accountancy_code_sell_intra = trim($this->accountancy_code_sell_intra);
        $this->accountancy_code_sell_export = trim($this->accountancy_code_sell_export);

        // Barcode value
        $this->barcode = trim($this->barcode);
        $this->mandatory_period = empty($this->mandatory_period) ? 0 : $this->mandatory_period;
        // Check parameters
        if (empty($this->label)) {
            $this->error = 'ErrorMandatoryParametersNotProvided';
            return -1;
        }

        if (empty($this->ref) || $this->ref == 'auto') {
            // Load object modCodeProduct
            $module = getDolGlobalString('PRODUCT_CODEPRODUCT_ADDON', 'mod_codeproduct_leopard');
            if ($module != 'mod_codeproduct_leopard') {    // Do not load module file for leopard
                if (substr($module, 0, 16) == 'mod_codeproduct_' && substr($module, -3) == 'php') {
                    $module = substr($module, 0, dol_strlen($module) - 4);
                }
                dol_include_once('/core/modules/product/' . $module . '.php');
                $modCodeProduct = new $module();
                '@phan-var-force ModeleProductCode $modCodeProduct';
                if (!empty($modCodeProduct->code_auto)) {
                    $this->ref = $modCodeProduct->getNextValue($this, $this->type);
                }
                unset($modCodeProduct);
            }

            if (empty($this->ref)) {
                $this->error = 'ProductModuleNotSetupForAutoRef';
                return -2;
            }
        }

        dol_syslog(get_only_class($this) . "::create ref=" . $this->ref . " price=" . $this->price . " price_ttc=" . $this->price_ttc . " tva_tx=" . $this->tva_tx . " price_base_type=" . $this->price_base_type, LOG_DEBUG);

        $now = dol_now();

        if (empty($this->date_creation)) {
            $this->date_creation = $now;
        }

        $this->db->begin();

        // For automatic creation during create action (not used by Dolibarr GUI, can be used by scripts)
        if ($this->barcode == '-1' || $this->barcode == 'auto') {
            $this->barcode = $this->get_barcode($this, $this->barcode_type_code);
        }

        // Check more parameters
        // If error, this->errors[] is filled
        $result = $this->verify();

        if ($result >= 0) {
            $sql = "SELECT count(*) as nb";
            $sql .= " FROM " . $this->db->prefix() . "product";
            $sql .= " WHERE entity IN (" . getEntity('product') . ")";
            $sql .= " AND ref = '" . $this->db->escape($this->ref) . "'";

            $result = $this->db->query($sql);
            if ($result) {
                $obj = $this->db->fetch_object($result);
                if ($obj->nb == 0) {
                    // Insert new product, no previous one found
                    $sql = "INSERT INTO " . $this->db->prefix() . "product (";
                    $sql .= "datec";
                    $sql .= ", entity";
                    $sql .= ", ref";
                    $sql .= ", ref_ext";
                    $sql .= ", price_min";
                    $sql .= ", price_min_ttc";
                    $sql .= ", label";
                    $sql .= ", fk_user_author";
                    $sql .= ", fk_product_type";
                    $sql .= ", price";
                    $sql .= ", price_ttc";
                    $sql .= ", price_base_type";
                    $sql .= ", price_label";
                    $sql .= ", tobuy";
                    $sql .= ", tosell";
                    if (!getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
                        $sql .= ", accountancy_code_buy";
                        $sql .= ", accountancy_code_buy_intra";
                        $sql .= ", accountancy_code_buy_export";
                        $sql .= ", accountancy_code_sell";
                        $sql .= ", accountancy_code_sell_intra";
                        $sql .= ", accountancy_code_sell_export";
                    }
                    $sql .= ", canvas";
                    $sql .= ", finished";
                    $sql .= ", tobatch";
                    $sql .= ", sell_or_eat_by_mandatory";
                    $sql .= ", batch_mask";
                    $sql .= ", fk_unit";
                    $sql .= ", mandatory_period";
                    $sql .= ") VALUES (";
                    $sql .= "'" . $this->db->idate($this->date_creation) . "'";
                    $sql .= ", " . (!empty($this->entity) ? (int)$this->entity : (int)$conf->entity);
                    $sql .= ", '" . $this->db->escape($this->ref) . "'";
                    $sql .= ", " . (!empty($this->ref_ext) ? "'" . $this->db->escape($this->ref_ext) . "'" : "null");
                    $sql .= ", " . price2num($price_min_ht);
                    $sql .= ", " . price2num($price_min_ttc);
                    $sql .= ", " . (!empty($this->label) ? "'" . $this->db->escape($this->label) . "'" : "null");
                    $sql .= ", " . ((int)$user->id);
                    $sql .= ", " . ((int)$this->type);
                    $sql .= ", " . price2num($price_ht, 'MT');
                    $sql .= ", " . price2num($price_ttc, 'MT');
                    $sql .= ", '" . $this->db->escape($this->price_base_type) . "'";
                    $sql .= ", " . (!empty($this->price_label) ? "'" . $this->db->escape($this->price_label) . "'" : "null");
                    $sql .= ", " . ((int)$this->status);
                    $sql .= ", " . ((int)$this->status_buy);
                    if (!getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
                        $sql .= ", '" . $this->db->escape($this->accountancy_code_buy) . "'";
                        $sql .= ", '" . $this->db->escape($this->accountancy_code_buy_intra) . "'";
                        $sql .= ", '" . $this->db->escape($this->accountancy_code_buy_export) . "'";
                        $sql .= ", '" . $this->db->escape($this->accountancy_code_sell) . "'";
                        $sql .= ", '" . $this->db->escape($this->accountancy_code_sell_intra) . "'";
                        $sql .= ", '" . $this->db->escape($this->accountancy_code_sell_export) . "'";
                    }
                    $sql .= ", '" . $this->db->escape($this->canvas) . "'";
                    $sql .= ", " . ((!isset($this->finished) || $this->finished < 0 || $this->finished == '') ? 'NULL' : (int)$this->finished);
                    $sql .= ", " . ((empty($this->status_batch) || $this->status_batch < 0) ? '0' : ((int)$this->status_batch));
                    $sql .= ", " . ((empty($this->sell_or_eat_by_mandatory) || $this->sell_or_eat_by_mandatory < 0) ? 0 : ((int)$this->sell_or_eat_by_mandatory));
                    $sql .= ", '" . $this->db->escape($this->batch_mask) . "'";
                    $sql .= ", " . ($this->fk_unit > 0 ? ((int)$this->fk_unit) : 'NULL');
                    $sql .= ", '" . $this->db->escape($this->mandatory_period) . "'";
                    $sql .= ")";

                    dol_syslog(get_only_class($this) . "::Create", LOG_DEBUG);

                    $result = $this->db->query($sql);
                    if ($result) {
                        $id = $this->db->last_insert_id($this->db->prefix() . "product");

                        if ($id > 0) {
                            $this->id = $id;
                            $this->price = $price_ht;
class Id
{
    public $id;

    public function __construct($id)
    {
        $this->id = $id;
    }

}

class Account
{
    /** @var  Id $id */
    public $id;
}

$account_id = false;

if (starsAreRight()) {
    $account_id = new Id(42);
}

$account = new Account();
if ($account instanceof Id)
{
    $account->id = $account_id;
}
                            $this->price_ttc = $price_ttc;
class Id
{
    public $id;

    public function __construct($id)
    {
        $this->id = $id;
    }

}

class Account
{
    /** @var  Id $id */
    public $id;
}

$account_id = false;

if (starsAreRight()) {
    $account_id = new Id(42);
}

$account = new Account();
if ($account instanceof Id)
{
    $account->id = $account_id;
}
                            $this->price_min = $price_min_ht;
class Id
{
    public $id;

    public function __construct($id)
    {
        $this->id = $id;
    }

}

class Account
{
    /** @var  Id $id */
    public $id;
}

$account_id = false;

if (starsAreRight()) {
    $account_id = new Id(42);
}

$account = new Account();
if ($account instanceof Id)
{
    $account->id = $account_id;
}
                            $this->price_min_ttc = $price_min_ttc;
class Id
{
    public $id;

    public function __construct($id)
    {
        $this->id = $id;
    }

}

class Account
{
    /** @var  Id $id */
    public $id;
}

$account_id = false;

if (starsAreRight()) {
    $account_id = new Id(42);
}

$account = new Account();
if ($account instanceof Id)
{
    $account->id = $account_id;
}

                            $result = $this->_log_price($user);
                            if ($result > 0) {
                                if ($this->update($id, $user, true, 'add') <= 0) {
                                    $error++;
                                }
                            } else {
                                $error++;
                                $this->error = $this->db->lasterror();
                            }

                            // update accountancy for this entity
                            if (!$error && getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
                                $this->db->query("DELETE FROM " . $this->db->prefix() . "product_perentity WHERE fk_product = " . ((int)$this->id) . " AND entity = " . ((int)$conf->entity));

                                $sql = "INSERT INTO " . $this->db->prefix() . "product_perentity (";
                                $sql .= " fk_product";
                                $sql .= ", entity";
                                $sql .= ", accountancy_code_buy";
                                $sql .= ", accountancy_code_buy_intra";
                                $sql .= ", accountancy_code_buy_export";
                                $sql .= ", accountancy_code_sell";
                                $sql .= ", accountancy_code_sell_intra";
                                $sql .= ", accountancy_code_sell_export";
                                $sql .= ") VALUES (";
                                $sql .= $this->id;
                                $sql .= ", " . $conf->entity;
                                $sql .= ", '" . $this->db->escape($this->accountancy_code_buy) . "'";
                                $sql .= ", '" . $this->db->escape($this->accountancy_code_buy_intra) . "'";
                                $sql .= ", '" . $this->db->escape($this->accountancy_code_buy_export) . "'";
                                $sql .= ", '" . $this->db->escape($this->accountancy_code_sell) . "'";
                                $sql .= ", '" . $this->db->escape($this->accountancy_code_sell_intra) . "'";
                                $sql .= ", '" . $this->db->escape($this->accountancy_code_sell_export) . "'";
                                $sql .= ")";
                                $result = $this->db->query($sql);
                                if (!$result) {
                                    $error++;
                                    $this->error = 'ErrorFailedToInsertAccountancyForEntity';
                                }
                            }
                        } else {
                            $error++;
                            $this->error = 'ErrorFailedToGetInsertedId';
                        }
                    } else {
                        $error++;
                        $this->error = $this->db->lasterror();
                    }
                } else {
                    // Product already exists with this ref
                    $langs->load("products");
                    $error++;
                    $this->error = "ErrorProductAlreadyExists";
                    dol_syslog(get_only_class($this) . "::Create fails, ref " . $this->ref . " already exists");
                }
            } else {
                $error++;
                $this->error = $this->db->lasterror();
            }

            if (!$error && !$notrigger) {
                // Call trigger
                $result = $this->call_trigger('PRODUCT_CREATE', $user);
                if ($result < 0) {
                    $error++;
                }
                // End call triggers
            }

            if (!$error) {
                $this->db->commit();
                return $this->id;
            } else {
                $this->db->rollback();
                return -$error;
            }
        } else {
            $this->db->rollback();
            dol_syslog(get_only_class($this) . "::Create fails verify " . implode(',', $this->errors), LOG_WARNING);
            return -3;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Get a barcode from the module to generate barcode values.
     *  Return value is stored into this->barcode
     *
     * @param Product $object Object product or service
     * @param string $type Barcode type (ean, isbn, ...)
     * @return string
     */
    public function get_barcode($object, $type = '')
    {
        // phpcs:enable
        global $conf;

        $result = '';
        if (getDolGlobalString('BARCODE_PRODUCT_ADDON_NUM')) {
            $dirsociete = array_merge(array('/core/modules/barcode/'), $conf->modules_parts['barcode']);
            foreach ($dirsociete as $dirroot) {
                $res = dol_include_once($dirroot . getDolGlobalString('BARCODE_PRODUCT_ADDON_NUM') . '.php');
                if ($res) {
                    break;
                }
            }
            $var = getDolGlobalString('BARCODE_PRODUCT_ADDON_NUM');
            $mod = new $var();
            '@phan-var-force ModeleNumRefBarCode $module';

            $result = $mod->getNextValue($object, $type);

            dol_syslog(get_only_class($this) . "::get_barcode barcode=" . $result . " module=" . $var);
        }
        return $result;
    }

    /**
     *    Check properties of product are ok (like name, barcode, ...).
     *    All properties must be already loaded on object (this->barcode, this->barcode_type_code, ...).
     *
     * @return int        0 if OK, <0 if KO
     */
    public function verify()
    {
        global $langs;

        $this->errors = array();

        $result = 0;
        $this->ref = trim($this->ref);

        if (!$this->ref) {
            $this->errors[] = 'ErrorBadRef';
            $result = -2;
        }

        $arrayofnonnegativevalue = array('weight' => 'Weight', 'width' => 'Width', 'height' => 'Height', 'length' => 'Length', 'surface' => 'Surface', 'volume' => 'Volume');
        foreach ($arrayofnonnegativevalue as $key => $value) {
            if (property_exists($this, $key) && !empty($this->$key) && ($this->$key < 0)) {
                $langs->loadLangs(array("main", "other"));
                $this->error = $langs->trans("FieldCannotBeNegative", $langs->transnoentitiesnoconv($value));
                $this->errors[] = $this->error;
                $result = -4;
            }
        }

        $rescode = $this->check_barcode($this->barcode, $this->barcode_type_code);
        if ($rescode) {
            if ($rescode == -1) {
                $this->errors[] = 'ErrorBadBarCodeSyntax';
            } elseif ($rescode == -2) {
                $this->errors[] = 'ErrorBarCodeRequired';
            } elseif ($rescode == -3) {
                // Note: Common usage is to have barcode unique. For variants, we should have a different barcode.
                $this->errors[] = 'ErrorBarCodeAlreadyUsed';
            }

            $result = -3;
        }

        return $result;
    }

    /**
     *  Check barcode
     *
     * @param string $valuetotest Value to test
     * @param string $typefortest Type of barcode (ISBN, EAN, ...)
     * @return int                        0 if OK
     *                                     -1 ErrorBadBarCodeSyntax
     *                                     -2 ErrorBarCodeRequired
     *                                     -3 ErrorBarCodeAlreadyUsed
     */
    public function check_barcode($valuetotest, $typefortest)
    {
        // phpcs:enable
        global $conf;
        if (isModEnabled('barcode') && getDolGlobalString('BARCODE_PRODUCT_ADDON_NUM')) {
            $module = strtolower(getDolGlobalString('BARCODE_PRODUCT_ADDON_NUM'));

            $dirsociete = array_merge(array('/core/modules/barcode/'), $conf->modules_parts['barcode']);
            foreach ($dirsociete as $dirroot) {
                $res = dol_include_once($dirroot . $module . '.php');
                if ($res) {
                    break;
                }
            }

            $mod = new $module();
            '@phan-var-force ModeleNumRefBarCode $mod';

            dol_syslog(get_only_class($this) . "::check_barcode value=" . $valuetotest . " type=" . $typefortest . " module=" . $module);
            $result = $mod->verif($this->db, $valuetotest, $this, 0, $typefortest);
            return $result;
        } else {
            return 0;
        }
    }

    /**
     *  Insert a track that we changed a customer price
     *
     * @param User $user User making change
     * @param int $level price level to change
     * @return int                    Return integer <0 if KO, >0 if OK
     */
    private function _log_price($user, $level = 0)
    {
        // phpcs:enable
        global $conf;

        $now = dol_now();

        // Clean parameters
        if (empty($this->price_by_qty)) {
            $this->price_by_qty = 0;
        }

        // Add new price
        $sql = "INSERT INTO " . $this->db->prefix() . "product_price(price_level,date_price, fk_product, fk_user_author, price_label, price, price_ttc, price_base_type,tosell, tva_tx, default_vat_code, recuperableonly,";
        $sql .= " localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, price_min,price_min_ttc,price_by_qty,entity,fk_price_expression) ";
        $sql .= " VALUES(" . ($level ? ((int)$level) : 1) . ", '" . $this->db->idate($now) . "', " . ((int)$this->id) . ", " . ((int)$user->id) . ", " . (empty($this->price_label) ? "null" : "'" . $this->db->escape($this->price_label) . "'") . ", " . ((float)price2num($this->price)) . ", " . ((float)price2num($this->price_ttc)) . ",'" . $this->db->escape($this->price_base_type) . "'," . ((int)$this->status) . ", " . ((float)price2num($this->tva_tx)) . ", " . ($this->default_vat_code ? ("'" . $this->db->escape($this->default_vat_code) . "'") : "null") . ", " . ((int)$this->tva_npr) . ",";
        $sql .= " " . price2num($this->localtax1_tx) . ", " . price2num($this->localtax2_tx) . ", '" . $this->db->escape($this->localtax1_type) . "', '" . $this->db->escape($this->localtax2_type) . "', " . price2num($this->price_min) . ", " . price2num($this->price_min_ttc) . ", " . price2num($this->price_by_qty) . ", " . ((int)$conf->entity) . "," . ($this->fk_price_expression > 0 ? ((int)$this->fk_price_expression) : 'null');
        $sql .= ")";

        dol_syslog(get_only_class($this) . "::_log_price", LOG_DEBUG);
        $resql = $this->db->query($sql);
        if (!$resql) {
            $this->error = $this->db->lasterror();
            dol_print_error($this->db);
            return -1;
        } else {
            return 1;
        }
    }

    /**
     *  Update a record into database.
     *  If batch flag is set to on, we create records into llx_product_batch
     *
     * @param int $id Id of product
     * @param User $user Object user making update
     * @param int $notrigger Disable triggers
     * @param string $action Current action for hookmanager ('add' or 'update')
     * @param boolean $updatetype Update product type
     * @return int                  1 if OK, -1 if ref already exists, -2 if other error
     */
    public function update($id, $user, $notrigger = 0, $action = 'update', $updatetype = false)
    {
        global $langs, $conf, $hookmanager;

        $error = 0;

        // Check parameters
        if (!$this->label) {
            $this->label = 'MISSING LABEL';
        }

        // Clean parameters
        if (getDolGlobalInt('MAIN_SECURITY_ALLOW_UNSECURED_REF_LABELS')) {
            $this->ref = trim($this->ref);
        } else {
            $this->ref = dol_string_nospecial(trim($this->ref));
        }
        $this->label = trim($this->label);
        $this->description = trim($this->description);
        $this->note_private = (isset($this->note_private) ? trim($this->note_private) : null);
        $this->note_public = (isset($this->note_public) ? trim($this->note_public) : null);
        $this->net_measure = price2num($this->net_measure);
        $this->net_measure_units = (empty($this->net_measure_units) ? '' : trim($this->net_measure_units));
        $this->weight = price2num($this->weight);
        $this->weight_units = (empty($this->weight_units) ? '' : trim($this->weight_units));
        $this->length = price2num($this->length);
        $this->length_units = (empty($this->length_units) ? '' : trim($this->length_units));
        $this->width = price2num($this->width);
        $this->width_units = (empty($this->width_units) ? '' : trim($this->width_units));
        $this->height = price2num($this->height);
        $this->height_units = (empty($this->height_units) ? '' : trim($this->height_units));
        $this->surface = price2num($this->surface);
        $this->surface_units = (empty($this->surface_units) ? '' : trim($this->surface_units));
        $this->volume = price2num($this->volume);
        $this->volume_units = (empty($this->volume_units) ? '' : trim($this->volume_units));

        // set unit not defined
        if (is_numeric($this->length_units)) {
            $this->width_units = $this->length_units; // Not used yet
        }
        if (is_numeric($this->length_units)) {
            $this->height_units = $this->length_units; // Not used yet
        }

        // Automated compute surface and volume if not filled
        if (empty($this->surface) && !empty($this->length) && !empty($this->width) && $this->length_units == $this->width_units) {
            $this->surface = (float)$this->length * (float)$this->width;
            $this->surface_units = measuring_units_squared($this->length_units);
        }
        if (empty($this->volume) && !empty($this->surface) && !empty($this->height) && $this->length_units == $this->height_units) {
            $this->volume = $this->surface * (float)$this->height;
            $this->volume_units = measuring_units_cubed($this->height_units);
        }

        if (empty($this->tva_tx)) {
            $this->tva_tx = 0;
        }
        if (empty($this->tva_npr)) {
            $this->tva_npr = 0;
        }
        if (empty($this->localtax1_tx)) {
            $this->localtax1_tx = 0;
        }
        if (empty($this->localtax2_tx)) {
            $this->localtax2_tx = 0;
        }
        if (empty($this->localtax1_type)) {
            $this->localtax1_type = '0';
        }
        if (empty($this->localtax2_type)) {
            $this->localtax2_type = '0';
        }
        if (empty($this->status)) {
            $this->status = 0;
        }
        if (empty($this->status_buy)) {
            $this->status_buy = 0;
        }

        if (empty($this->country_id)) {
            $this->country_id = 0;
        }

        if (empty($this->state_id)) {
            $this->state_id = 0;
        }

        // Barcode value
        $this->barcode = (empty($this->barcode) ? '' : trim($this->barcode));

        $this->accountancy_code_buy = trim($this->accountancy_code_buy);
        $this->accountancy_code_buy_intra = (!empty($this->accountancy_code_buy_intra) ? trim($this->accountancy_code_buy_intra) : '');
        $this->accountancy_code_buy_export = trim($this->accountancy_code_buy_export);
        $this->accountancy_code_sell = trim($this->accountancy_code_sell);
        $this->accountancy_code_sell_intra = trim($this->accountancy_code_sell_intra);
        $this->accountancy_code_sell_export = trim($this->accountancy_code_sell_export);


        $this->db->begin();

        $result = 0;
        // Check name is required and codes are ok or unique. If error, this->errors[] is filled
        if ($action != 'add') {
            $result = $this->verify(); // We don't check when update called during a create because verify was already done
        } else {
            // we can continue
            $result = 0;
        }

        if ($result >= 0) {
            // $this->oldcopy should have been set by the caller of update (here properties were already modified)
            if (is_null($this->oldcopy) || (is_object($this->oldcopy) && $this->oldcopy->isEmpty())) {
                $this->oldcopy = dol_clone($this, 1);
            }
            // Test if batch management is activated on existing product
            // If yes, we create missing entries into product_batch
            if ($this->hasbatch() && !$this->oldcopy->hasbatch()) {
                //$valueforundefinedlot = 'Undefined';  // In previous version, 39 and lower
                $valueforundefinedlot = '000000';
                if (getDolGlobalString('STOCK_DEFAULT_BATCH')) {
                    $valueforundefinedlot = getDolGlobalString('STOCK_DEFAULT_BATCH');
                }

                dol_syslog("Flag batch of product id=" . $this->id . " is set to ON, so we will create missing records into product_batch");

                $this->load_stock();
                foreach ($this->stock_warehouse as $idW => $ObjW) {   // For each warehouse where we have stocks defined for this product (for each lines in product_stock)
                    $qty_batch = 0;
                    foreach ($ObjW->detail_batch as $detail) {    // Each lines of detail in product_batch of the current $ObjW = product_stock
                        if ($detail->batch == $valueforundefinedlot || $detail->batch == 'Undefined') {
                            // We discard this line, we will create it later
                            $sqlclean = "DELETE FROM " . $this->db->prefix() . "product_batch WHERE batch in('Undefined', '" . $this->db->escape($valueforundefinedlot) . "') AND fk_product_stock = " . ((int)$ObjW->id);
                            $result = $this->db->query($sqlclean);
                            if (!$result) {
                                dol_print_error($this->db);
                                exit;

                            }
                            continue;
                        }

                        $qty_batch += $detail->qty;
                    }
                    // Quantities in batch details are not same as stock quantity,
                    // so we add a default batch record to complete and get same qty in parent and child table
                    if ($ObjW->real != $qty_batch) {
                        $ObjBatch = new Productbatch($this->db);
                        $ObjBatch->batch = $valueforundefinedlot;
                        $ObjBatch->qty = ($ObjW->real - $qty_batch);
                        $ObjBatch->fk_product_stock = $ObjW->id;

                        if ($ObjBatch->create($user, 1) < 0) {
                            $error++;
                            $this->errors = $ObjBatch->errors;
                        } else {
                            // we also add lot record if not exist
                            $ObjLot = new Productlot($this->db);
                            // @phan-suppress-next-line PhanPluginSuspiciousParamPosition
                            if ($ObjLot->fetch(0, $this->id, $valueforundefinedlot) == 0) {
                                $ObjLot->fk_product = $this->id;
                                $ObjLot->entity = $this->entity;
                                $ObjLot->fk_user_creat = $user->id;
                                $ObjLot->batch = $valueforundefinedlot;
                                if ($ObjLot->create($user, true) < 0) {
                                    $error++;
                                    $this->errors = $ObjLot->errors;

                                }
                            }
                        }
                    }
                }
            }

            // For automatic creation
            if ($this->barcode == -1) {
                $this->barcode = $this->get_barcode($this, $this->barcode_type_code);
            }

            $sql = "UPDATE " . $this->db->prefix() . "product";
            $sql .= " SET label = '" . $this->db->escape($this->label) . "'";

            if ($updatetype && ($this->isProduct() || $this->isService())) {
                $sql .= ", fk_product_type = " . ((int)$this->type);
            }

            $sql .= ", ref = '" . $this->db->escape($this->ref) . "'";
            $sql .= ", ref_ext = " . (!empty($this->ref_ext) ? "'" . $this->db->escape($this->ref_ext) . "'" : "null");
            $sql .= ", default_vat_code = " . ($this->default_vat_code ? "'" . $this->db->escape($this->default_vat_code) . "'" : "null");
            $sql .= ", tva_tx = " . ((float)$this->tva_tx);
            $sql .= ", recuperableonly = " . ((int)$this->tva_npr);
            $sql .= ", localtax1_tx = " . ((float)$this->localtax1_tx);
            $sql .= ", localtax2_tx = " . ((float)$this->localtax2_tx);
            $sql .= ", localtax1_type = " . ($this->localtax1_type != '' ? "'" . $this->db->escape($this->localtax1_type) . "'" : "'0'");
            $sql .= ", localtax2_type = " . ($this->localtax2_type != '' ? "'" . $this->db->escape($this->localtax2_type) . "'" : "'0'");

            $sql .= ", barcode = " . (empty($this->barcode) ? "null" : "'" . $this->db->escape($this->barcode) . "'");
            $sql .= ", fk_barcode_type = " . (empty($this->barcode_type) ? "null" : $this->db->escape($this->barcode_type));

            $sql .= ", tosell = " . (int)$this->status;
            $sql .= ", tobuy = " . (int)$this->status_buy;
            $sql .= ", tobatch = " . ((empty($this->status_batch) || $this->status_batch < 0) ? '0' : (int)$this->status_batch);
            $sql .= ", sell_or_eat_by_mandatory = " . ((empty($this->sell_or_eat_by_mandatory) || $this->sell_or_eat_by_mandatory < 0) ? 0 : (int)$this->sell_or_eat_by_mandatory);
            $sql .= ", batch_mask = '" . $this->db->escape($this->batch_mask) . "'";

            $sql .= ", finished = " . ((!isset($this->finished) || $this->finished < 0 || $this->finished == '') ? "null" : (int)$this->finished);
            $sql .= ", fk_default_bom = " . ((!isset($this->fk_default_bom) || $this->fk_default_bom < 0 || $this->fk_default_bom == '') ? "null" : (int)$this->fk_default_bom);
            $sql .= ", net_measure = " . ($this->net_measure != '' ? "'" . $this->db->escape($this->net_measure) . "'" : 'null');
            $sql .= ", net_measure_units = " . ($this->net_measure_units != '' ? "'" . $this->db->escape($this->net_measure_units) . "'" : 'null');
            $sql .= ", weight = " . ($this->weight != '' ? "'" . $this->db->escape($this->weight) . "'" : 'null');
            $sql .= ", weight_units = " . ($this->weight_units != '' ? "'" . $this->db->escape($this->weight_units) . "'" : 'null');
            $sql .= ", length = " . ($this->length != '' ? "'" . $this->db->escape($this->length) . "'" : 'null');
            $sql .= ", length_units = " . ($this->length_units != '' ? "'" . $this->db->escape($this->length_units) . "'" : 'null');
            $sql .= ", width= " . ($this->width != '' ? "'" . $this->db->escape($this->width) . "'" : 'null');
            $sql .= ", width_units = " . ($this->width_units != '' ? "'" . $this->db->escape($this->width_units) . "'" : 'null');
            $sql .= ", height = " . ($this->height != '' ? "'" . $this->db->escape($this->height) . "'" : 'null');
            $sql .= ", height_units = " . ($this->height_units != '' ? "'" . $this->db->escape($this->height_units) . "'" : 'null');
            $sql .= ", surface = " . ($this->surface != '' ? "'" . $this->db->escape($this->surface) . "'" : 'null');
            $sql .= ", surface_units = " . ($this->surface_units != '' ? "'" . $this->db->escape($this->surface_units) . "'" : 'null');
            $sql .= ", volume = " . ($this->volume != '' ? "'" . $this->db->escape($this->volume) . "'" : 'null');
            $sql .= ", volume_units = " . ($this->volume_units != '' ? "'" . $this->db->escape($this->volume_units) . "'" : 'null');
            $sql .= ", fk_default_warehouse = " . ($this->fk_default_warehouse > 0 ? ((int)$this->fk_default_warehouse) : 'null');
            $sql .= ", fk_default_workstation = " . ($this->fk_default_workstation > 0 ? ((int)$this->fk_default_workstation) : 'null');
            $sql .= ", seuil_stock_alerte = " . ((isset($this->seuil_stock_alerte) && is_numeric($this->seuil_stock_alerte)) ? (float)$this->seuil_stock_alerte : 'null');
            $sql .= ", description = '" . $this->db->escape($this->description) . "'";
            $sql .= ", url = " . ($this->url ? "'" . $this->db->escape($this->url) . "'" : 'null');
            $sql .= ", customcode = '" . $this->db->escape($this->customcode) . "'";
            $sql .= ", fk_country = " . ($this->country_id > 0 ? (int)$this->country_id : 'null');
            $sql .= ", fk_state = " . ($this->state_id > 0 ? (int)$this->state_id : 'null');
            $sql .= ", lifetime = " . ($this->lifetime > 0 ? (int)$this->lifetime : 'null');
            $sql .= ", qc_frequency = " . ($this->qc_frequency > 0 ? (int)$this->qc_frequency : 'null');
            $sql .= ", note = " . (isset($this->note_private) ? "'" . $this->db->escape($this->note_private) . "'" : 'null');
            $sql .= ", note_public = " . (isset($this->note_public) ? "'" . $this->db->escape($this->note_public) . "'" : 'null');
            $sql .= ", duration = '" . $this->db->escape($this->duration_value . $this->duration_unit) . "'";
            if (!getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
                $sql .= ", accountancy_code_buy = '" . $this->db->escape($this->accountancy_code_buy) . "'";
                $sql .= ", accountancy_code_buy_intra = '" . $this->db->escape($this->accountancy_code_buy_intra) . "'";
                $sql .= ", accountancy_code_buy_export = '" . $this->db->escape($this->accountancy_code_buy_export) . "'";
                $sql .= ", accountancy_code_sell= '" . $this->db->escape($this->accountancy_code_sell) . "'";
                $sql .= ", accountancy_code_sell_intra= '" . $this->db->escape($this->accountancy_code_sell_intra) . "'";
                $sql .= ", accountancy_code_sell_export= '" . $this->db->escape($this->accountancy_code_sell_export) . "'";
            }
            $sql .= ", desiredstock = " . ((isset($this->desiredstock) && is_numeric($this->desiredstock)) ? (float)$this->desiredstock : "null");
            $sql .= ", cost_price = " . ($this->cost_price != '' ? $this->db->escape($this->cost_price) : 'null');
            $sql .= ", fk_unit= " . (!$this->fk_unit ? 'NULL' : (int)$this->fk_unit);
            $sql .= ", price_autogen = " . (!$this->price_autogen ? 0 : 1);
            $sql .= ", fk_price_expression = " . ($this->fk_price_expression != 0 ? (int)$this->fk_price_expression : 'NULL');
            $sql .= ", fk_user_modif = " . ($user->id > 0 ? $user->id : 'NULL');
            $sql .= ", mandatory_period = " . ($this->mandatory_period);
            // stock field is not here because it is a denormalized value from product_stock.
            $sql .= " WHERE rowid = " . ((int)$id);

            dol_syslog(get_only_class($this) . "::update", LOG_DEBUG);

            $resql = $this->db->query($sql);
            if ($resql) {
                $this->id = $id;

                // Multilangs
                if (getDolGlobalInt('MAIN_MULTILANGS')) {
                    if ($this->setMultiLangs($user) < 0) {
                        $this->error = $langs->trans("Error") . " : " . $this->db->error() . " - " . $sql;
                        $this->db->rollback();
                        return -2;
                    }
                }

                $action = 'update';

                // update accountancy for this entity
                if (!$error && getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
                    $this->db->query("DELETE FROM " . $this->db->prefix() . "product_perentity WHERE fk_product = " . ((int)$this->id) . " AND entity = " . ((int)$conf->entity));

                    $sql = "INSERT INTO " . $this->db->prefix() . "product_perentity (";
                    $sql .= " fk_product";
                    $sql .= ", entity";
                    $sql .= ", accountancy_code_buy";
                    $sql .= ", accountancy_code_buy_intra";
                    $sql .= ", accountancy_code_buy_export";
                    $sql .= ", accountancy_code_sell";
                    $sql .= ", accountancy_code_sell_intra";
                    $sql .= ", accountancy_code_sell_export";
                    $sql .= ") VALUES (";
                    $sql .= $this->id;
                    $sql .= ", " . $conf->entity;
                    $sql .= ", '" . $this->db->escape($this->accountancy_code_buy) . "'";
                    $sql .= ", '" . $this->db->escape($this->accountancy_code_buy_intra) . "'";
                    $sql .= ", '" . $this->db->escape($this->accountancy_code_buy_export) . "'";
                    $sql .= ", '" . $this->db->escape($this->accountancy_code_sell) . "'";
                    $sql .= ", '" . $this->db->escape($this->accountancy_code_sell_intra) . "'";
                    $sql .= ", '" . $this->db->escape($this->accountancy_code_sell_export) . "'";
                    $sql .= ")";
                    $result = $this->db->query($sql);
                    if (!$result) {
                        $error++;
                        $this->error = 'ErrorFailedToUpdateAccountancyForEntity';
                    }
                }

                if (!$this->hasbatch() && $this->oldcopy->hasbatch()) {
                    // Selection of all product stock movements that contains batchs
                    $sql = 'SELECT pb.qty, ps.fk_entrepot, pb.batch FROM ' . MAIN_DB_PREFIX . 'product_batch as pb';
                    $sql .= ' INNER JOIN ' . MAIN_DB_PREFIX . 'product_stock as ps ON (ps.rowid = pb.fk_product_stock)';
                    $sql .= ' WHERE ps.fk_product = ' . (int)$this->id;

                    $resql = $this->db->query($sql);
                    if ($resql) {
                        $inventorycode = dol_print_date(dol_now(), '%Y%m%d%H%M%S');

                        while ($obj = $this->db->fetch_object($resql)) {
                            $value = $obj->qty;
                            $fk_entrepot = $obj->fk_entrepot;
                            $price = 0;
                            $dlc = '';
                            $dluo = '';
                            $batch = $obj->batch;

                            // To know how to revert stockMouvement (add or remove)
                            $addOremove = $value > 0 ? 1 : 0; // 1 if remove, 0 if add
                            $label = $langs->trans('BatchStockMouvementAddInGlobal');
                            $res = $this->correct_stock_batch($user, $fk_entrepot, abs($value), $addOremove, $label, $price, $dlc, $dluo, $batch, $inventorycode, '', null, 0, null, true);

                            if ($res > 0) {
                                $label = $langs->trans('BatchStockMouvementAddInGlobal');
                                $res = $this->correct_stock($user, $fk_entrepot, abs($value), (int)empty($addOremove), $label, $price, $inventorycode, '', null, 0);
                                if ($res < 0) {
                                    $error++;
                                }
                            } else {
                                $error++;
                            }
                        }
                    }
                }

                // Actions on extra fields
                if (!$error) {
                    $result = $this->insertExtraFields();
                    if ($result < 0) {
                        $error++;
                    }
                }

                if (!$error && !$notrigger) {
                    // Call trigger
                    $result = $this->call_trigger('PRODUCT_MODIFY', $user);
                    if ($result < 0) {
                        $error++;
                    }
                    // End call triggers
                }

                if (!$error && (is_object($this->oldcopy) && $this->oldcopy->ref !== $this->ref)) {
                    // We remove directory
                    if ($conf->product->dir_output) {
                        $olddir = $conf->product->dir_output . "/" . dol_sanitizeFileName($this->oldcopy->ref);
                        $newdir = $conf->product->dir_output . "/" . dol_sanitizeFileName($this->ref);
                        if (file_exists($olddir)) {
                            //include_once DOL_DOCUMENT_ROOT . '/core/lib/files.lib.php';
                            //$res = dol_move($olddir, $newdir);
                            // do not use dol_move with directory
                            $res = @rename($olddir, $newdir);
                            if (!$res) {
                                $langs->load("errors");
                                $this->error = $langs->trans('ErrorFailToRenameDir', $olddir, $newdir);
                                $error++;
                            }
                        }
                    }
                }

                if (!$error) {
                    if (isModEnabled('variants')) {
                        $comb = new ProductAttributeCombination();

                        foreach ($comb->fetchAllByFkProductParent($this->id) as $currcomb) {
                            $currcomb->updateProperties($this, $user);
                        }
                    }

                    $this->db->commit();
                    return 1;
                } else {
                    $this->db->rollback();
                    return -$error;
                }
            } else {
                if ($this->db->errno() == 'DB_ERROR_RECORD_ALREADY_EXISTS') {
                    $langs->load("errors");
                    if (empty($conf->barcode->enabled) || empty($this->barcode)) {
                        $this->error = $langs->trans("Error") . " : " . $langs->trans("ErrorProductAlreadyExists", $this->ref);
                    } else {
                        $this->error = $langs->trans("Error") . " : " . $langs->trans("ErrorProductBarCodeAlreadyExists", $this->barcode);
                    }
                    $this->errors[] = $this->error;
                    $this->db->rollback();
                    return -1;
                } else {
                    $this->error = $langs->trans("Error") . " : " . $this->db->error() . " - " . $sql;
                    $this->errors[] = $this->error;
                    $this->db->rollback();
                    return -2;
                }
            }
        } else {
            $this->db->rollback();
            dol_syslog(get_only_class($this) . "::Update fails verify " . implode(',', $this->errors), LOG_WARNING);
            return -3;
        }
    }

    /**
     * Return if object has a sell-by date or eat-by date
     *
     * @return boolean     True if it's has
     */
    public function hasbatch()
    {
        return ($this->status_batch > 0 ? true : false);
    }

    /**
     * Load information about stock of a product into ->stock_reel, ->stock_warehouse[] (including stock_warehouse[idwarehouse]->detail_batch for batch products)
     * This function need a lot of load. If you use it on list, use a cache to execute it once for each product id.
     * If ENTREPOT_EXTRA_STATUS is set, filtering on warehouse status is possible.
     *
     * @param string $option '' = Load all stock info, also from closed and internal warehouses, 'nobatch' = do not load batch detail, 'novirtual' = do no load virtual detail
     *                                              You can also filter on 'warehouseclosed', 'warehouseopen', 'warehouseinternal'
     * @param int $includedraftpoforvirtual Include draft status of PO for virtual stock calculation
     * @param int $dateofvirtualstock Date of virtual stock
     * @return  int                                 Return integer < 0 if KO, > 0 if OK
     * @see     load_virtual_stock(), loadBatchInfo()
     */
    public function load_stock($option = '', $includedraftpoforvirtual = null, $dateofvirtualstock = null)
    {
        // phpcs:enable
        global $conf;

        $this->stock_reel = 0;
        $this->stock_warehouse = array();
        $this->stock_theorique = 0;

        // Set filter on warehouse status
        $warehouseStatus = array();
        if (preg_match('/warehouseclosed/', $option)) {
            $warehouseStatus[Entrepot::STATUS_CLOSED] = Entrepot::STATUS_CLOSED;
        }
        if (preg_match('/warehouseopen/', $option)) {
            $warehouseStatus[Entrepot::STATUS_OPEN_ALL] = Entrepot::STATUS_OPEN_ALL;
        }
        if (preg_match('/warehouseinternal/', $option)) {
            if (getDolGlobalString('ENTREPOT_EXTRA_STATUS')) {
                $warehouseStatus[Entrepot::STATUS_OPEN_INTERNAL] = Entrepot::STATUS_OPEN_INTERNAL;
            } else {
                $warehouseStatus[Entrepot::STATUS_OPEN_ALL] = Entrepot::STATUS_OPEN_ALL;
            }
        }

        $sql = "SELECT ps.rowid, ps.reel, ps.fk_entrepot";
        $sql .= " FROM " . $this->db->prefix() . "product_stock as ps";
        $sql .= ", " . $this->db->prefix() . "entrepot as w";
        $sql .= " WHERE w.entity IN (" . getEntity('stock') . ")";
        $sql .= " AND w.rowid = ps.fk_entrepot";
        $sql .= " AND ps.fk_product = " . ((int)$this->id);
        if (count($warehouseStatus)) {
            $sql .= " AND w.statut IN (" . $this->db->sanitize(implode(',', $warehouseStatus)) . ")";
        }

        $sql .= " ORDER BY ps.reel " . (getDolGlobalString('DO_NOT_TRY_TO_DEFRAGMENT_STOCKS_WAREHOUSE') ? 'DESC' : 'ASC'); // Note : qty ASC is important for expedition card, to avoid stock fragmentation;

        dol_syslog(get_only_class($this) . "::load_stock", LOG_DEBUG);
        $result = $this->db->query($sql);
        if ($result) {
            $num = $this->db->num_rows($result);
            $i = 0;
            if ($num > 0) {
                while ($i < $num) {
                    $row = $this->db->fetch_object($result);
                    $this->stock_warehouse[$row->fk_entrepot] = new stdClass();

                    $this->stock_warehouse[$row->fk_entrepot]->real = $row->reel;
                    $this->stock_warehouse[$row->fk_entrepot]->id = $row->rowid;
                    if ((!preg_match('/nobatch/', $option)) && $this->hasbatch()) {
                        $this->stock_warehouse[$row->fk_entrepot]->detail_batch = Productbatch::findAll($this->db, $row->rowid, 1, $this->id);
                    }
                    $this->stock_reel += $row->reel;
                    $i++;
                }
            }
            $this->db->free($result);

            if (!preg_match('/novirtual/', $option)) {
                $this->load_virtual_stock($includedraftpoforvirtual, $dateofvirtualstock); // This load stock_theorique and also load all arrays stats_xxx...
            }

            return 1;
        } else {
            $this->error = $this->db->lasterror();
            return -1;
        }
    }

    /**
     *  Load value ->stock_theorique of a product. Property this->id must be defined.
     *  This function need a lot of load. If you use it on list, use a cache to execute it one for each product id.
     *
     * @param int $includedraftpoforvirtual Include draft status and not yet approved Purchase Orders for virtual stock calculation
     * @param int $dateofvirtualstock Date of virtual stock
     * @return int                                 Return integer < 0 if KO, > 0 if OK
     * @see    load_stock(), loadBatchInfo()
     */
    public function load_virtual_stock($includedraftpoforvirtual = null, $dateofvirtualstock = null)
    {
        // phpcs:enable
        global $conf, $hookmanager, $action;

        $stock_commande_client = 0;
        $stock_commande_fournisseur = 0;
        $stock_sending_client = 0;
        $stock_reception_fournisseur = 0;
        $stock_inproduction = 0;

        //dol_syslog("load_virtual_stock");

        if (isModEnabled('order')) {
            $result = $this->load_stats_commande(0, '1,2', 1);
            if ($result < 0) {
                dol_print_error($this->db, $this->error);
            }
            $stock_commande_client = $this->stats_commande['qty'];
        }
        if (isModEnabled("shipping")) {
            $filterShipmentStatus = '';
            if (getDolGlobalString('STOCK_CALCULATE_ON_SHIPMENT')) {
                $filterShipmentStatus = Expedition::STATUS_VALIDATED . ',' . Expedition::STATUS_CLOSED;
            } elseif (getDolGlobalString('STOCK_CALCULATE_ON_SHIPMENT_CLOSE')) {
                $filterShipmentStatus = Expedition::STATUS_CLOSED;
            }
            $result = $this->load_stats_sending(0, '1,2', 1, $filterShipmentStatus);
            if ($result < 0) {
                dol_print_error($this->db, $this->error);
            }
            $stock_sending_client = $this->stats_expedition['qty'];
        }
        if (isModEnabled("supplier_order")) {
            $filterStatus = getDolGlobalString('SUPPLIER_ORDER_STATUS_FOR_VIRTUAL_STOCK', '3,4');
            if (isset($includedraftpoforvirtual)) {
                $filterStatus = '0,1,2,' . $filterStatus; // 1,2 may have already been inside $filterStatus but it is better to have twice than missing $filterStatus does not include them
            }
            $result = $this->load_stats_commande_fournisseur(0, $filterStatus, 1, $dateofvirtualstock);
            if ($result < 0) {
                dol_print_error($this->db, $this->error);
            }
            $stock_commande_fournisseur = $this->stats_commande_fournisseur['qty'];
        }
        if ((isModEnabled("supplier_order") || isModEnabled("supplier_invoice")) && empty($conf->reception->enabled)) {
            // Case module reception is not used
            $filterStatus = '4';
            if (isset($includedraftpoforvirtual)) {
                $filterStatus = '0,' . $filterStatus;
            }
            $result = $this->load_stats_reception(0, $filterStatus, 1, $dateofvirtualstock);
            if ($result < 0) {
                dol_print_error($this->db, $this->error);
            }
            $stock_reception_fournisseur = $this->stats_reception['qty'];
        }
        if ((isModEnabled("supplier_order") || isModEnabled("supplier_invoice")) && isModEnabled("reception")) {
            // Case module reception is used
            $filterStatus = '4';
            if (isset($includedraftpoforvirtual)) {
                $filterStatus = '0,' . $filterStatus;
            }
            $result = $this->load_stats_reception(0, $filterStatus, 1, $dateofvirtualstock); // Use same tables than when module reception is not used.
            if ($result < 0) {
                dol_print_error($this->db, $this->error);
            }
            $stock_reception_fournisseur = $this->stats_reception['qty'];
        }
        if (isModEnabled('mrp')) {
            $result = $this->load_stats_inproduction(0, '1,2', 1, $dateofvirtualstock);
            if ($result < 0) {
                dol_print_error($this->db, $this->error);
            }
            $stock_inproduction = $this->stats_mrptoproduce['qty'] - $this->stats_mrptoconsume['qty'];
        }

        $this->stock_theorique = $this->stock_reel + $stock_inproduction;

        // Stock decrease mode
        if (getDolGlobalString('STOCK_CALCULATE_ON_SHIPMENT') || getDolGlobalString('STOCK_CALCULATE_ON_SHIPMENT_CLOSE')) {
            $this->stock_theorique -= ($stock_commande_client - $stock_sending_client);
        } elseif (getDolGlobalString('STOCK_CALCULATE_ON_VALIDATE_ORDER')) {
            $this->stock_theorique += 0;
        } elseif (getDolGlobalString('STOCK_CALCULATE_ON_BILL')) {
            $this->stock_theorique -= $stock_commande_client;
        }
        // Stock Increase mode
        if (getDolGlobalString('STOCK_CALCULATE_ON_RECEPTION') || getDolGlobalString('STOCK_CALCULATE_ON_RECEPTION_CLOSE')) {
            $this->stock_theorique += ($stock_commande_fournisseur - $stock_reception_fournisseur);
        } elseif (getDolGlobalString('STOCK_CALCULATE_ON_SUPPLIER_DISPATCH_ORDER')) {
            $this->stock_theorique += ($stock_commande_fournisseur - $stock_reception_fournisseur);
        } elseif (getDolGlobalString('STOCK_CALCULATE_ON_SUPPLIER_VALIDATE_ORDER')) {
            $this->stock_theorique -= $stock_reception_fournisseur;
        } elseif (getDolGlobalString('STOCK_CALCULATE_ON_SUPPLIER_BILL')) {
            $this->stock_theorique += ($stock_commande_fournisseur - $stock_reception_fournisseur);
        }

        $parameters = array('id' => $this->id, 'includedraftpoforvirtual' => $includedraftpoforvirtual);
        // Note that $action and $object may have been modified by some hooks
        $reshook = $hookmanager->executeHooks('loadvirtualstock', $parameters, $this, $action);
        if ($reshook > 0) {
            $this->stock_theorique = $hookmanager->resArray['stock_theorique'];
        } elseif ($reshook == 0 && isset($hookmanager->resArray['stock_stats_hook'])) {
            $this->stock_theorique += $hookmanager->resArray['stock_stats_hook'];
        }

        //Virtual Stock by Warehouse
        if (!empty($this->stock_warehouse) && getDolGlobalString('STOCK_ALLOW_VIRTUAL_STOCK_PER_WAREHOUSE')) {
            foreach ($this->stock_warehouse as $warehouseid => $stockwarehouse) {
                if (isModEnabled('mrp')) {
                    $result = $this->load_stats_inproduction(0, '1,2', 1, $dateofvirtualstock, $warehouseid);
                    if ($result < 0) {
                        dol_print_error($this->db, $this->error);
                    }
                }

                if ($this->fk_default_warehouse == $warehouseid) {
                    $this->stock_warehouse[$warehouseid]->virtual = $this->stock_warehouse[$warehouseid]->real + $this->stock_warehouse[$warehouseid]->stats_mrptoproduce['qty'] + $this->stats_commande_fournisseur['qty'] - ($this->stats_commande['qty'] + $this->stats_mrptoconsume['qty']);
                } else {
                    $this->stock_warehouse[$warehouseid]->virtual = $this->stock_warehouse[$warehouseid]->real + $this->stock_warehouse[$warehouseid]->stats_mrptoproduce['qty'];
                }
            }
        }

        return 1;
    }

    /**
     *  Charge tableau des stats commande client pour le produit/service
     *
     * @param int $socid Id thirdparty to filter on a thirdparty
     * @param string $filtrestatut Id status to filter on a status
     * @param int $forVirtualStock Ignore rights filter for virtual stock calculation. Set when load_stats_commande is used for virtual stock calculation.
     * @return integer                 Array of stats in $this->stats_commande (nb=nb of order, qty=qty ordered), <0 if ko or >0 if ok
     */
    public function load_stats_commande($socid = 0, $filtrestatut = '', $forVirtualStock = 0)
    {
        // phpcs:enable
        global $conf, $user, $hookmanager, $action;

        $sql = "SELECT COUNT(DISTINCT c.fk_soc) as nb_customers, COUNT(DISTINCT c.rowid) as nb,";
        $sql .= " COUNT(cd.rowid) as nb_rows, SUM(cd.qty) as qty";
        $sql .= " FROM " . $this->db->prefix() . "commandedet as cd";
        $sql .= ", " . $this->db->prefix() . "commande as c";
        $sql .= ", " . $this->db->prefix() . "societe as s";
        if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE c.rowid = cd.fk_commande";
        $sql .= " AND c.fk_soc = s.rowid";
        $sql .= " AND c.entity IN (" . getEntity($forVirtualStock && getDolGlobalString('STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE') ? 'stock' : 'commande') . ")";
        $sql .= " AND cd.fk_product = " . ((int)$this->id);
        if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND c.fk_soc = " . ((int)$socid);
        }
        if ($filtrestatut != '') {
            $sql .= " AND c.fk_statut in (" . $this->db->sanitize($filtrestatut) . ")";
        }

        $result = $this->db->query($sql);
        if ($result) {
            $obj = $this->db->fetch_object($result);
            $this->stats_commande['customers'] = $obj->nb_customers;
            $this->stats_commande['nb'] = $obj->nb;
            $this->stats_commande['rows'] = $obj->nb_rows;
            $this->stats_commande['qty'] = $obj->qty ? $obj->qty : 0;

            // if it's a virtual product, maybe it is in order by extension
            if (getDolGlobalString('PRODUCT_STATS_WITH_PARENT_PROD_IF_INCDEC')) {
                $TFather = $this->getFather();
                if (is_array($TFather) && !empty($TFather)) {
                    foreach ($TFather as &$fatherData) {
                        $pFather = new Product($this->db);
                        $pFather->id = $fatherData['id'];
                        $qtyCoef = $fatherData['qty'];

                        if ($fatherData['incdec']) {
                            $pFather->load_stats_commande($socid, $filtrestatut);

                            $this->stats_commande['customers'] += $pFather->stats_commande['customers'];
                            $this->stats_commande['nb'] += $pFather->stats_commande['nb'];
                            $this->stats_commande['rows'] += $pFather->stats_commande['rows'];
                            $this->stats_commande['qty'] += $pFather->stats_commande['qty'] * $qtyCoef;
                        }
                    }
                }
            }

            // If stock decrease is on invoice validation, the theoretical stock continue to
            // count the orders to ship in theoretical stock when some are already removed by invoice validation.
            if ($forVirtualStock && getDolGlobalString('STOCK_CALCULATE_ON_BILL')) {
                if (getDolGlobalString('DECREASE_ONLY_UNINVOICEDPRODUCTS')) {
                    // If option DECREASE_ONLY_UNINVOICEDPRODUCTS is on, we make a compensation but only if order not yet invoice.
                    $adeduire = 0;
                    $sql = "SELECT SUM(" . $this->db->ifsql('f.type=2', -1, 1) . " * fd.qty) as count FROM " . $this->db->prefix() . "facturedet as fd ";
                    $sql .= " JOIN " . $this->db->prefix() . "facture as f ON fd.fk_facture = f.rowid";
                    $sql .= " JOIN " . $this->db->prefix() . "element_element as el ON ((el.fk_target = f.rowid AND el.targettype = 'facture' AND sourcetype = 'commande') OR (el.fk_source = f.rowid AND el.targettype = 'commande' AND sourcetype = 'facture'))";
                    $sql .= " JOIN " . $this->db->prefix() . "commande as c ON el.fk_source = c.rowid";
                    $sql .= " WHERE c.fk_statut IN (" . $this->db->sanitize($filtrestatut) . ") AND c.facture = 0 AND fd.fk_product = " . ((int)$this->id);

                    dol_syslog(__METHOD__ . ":: sql $sql", LOG_NOTICE);
                    $resql = $this->db->query($sql);
                    if ($resql) {
                        if ($this->db->num_rows($resql) > 0) {
                            $obj = $this->db->fetch_object($resql);
                            $adeduire += $obj->count;
                        }
                    }

                    $this->stats_commande['qty'] -= $adeduire;
                } else {
                    // If option DECREASE_ONLY_UNINVOICEDPRODUCTS is off, we make a compensation with lines of invoices linked to the order

                    // For every order having invoice already validated we need to decrease stock cause it's in physical stock
                    $adeduire = 0;
                    $sql = "SELECT sum(" . $this->db->ifsql('f.type=2', -1, 1) . " * fd.qty) as count FROM " . MAIN_DB_PREFIX . "facturedet as fd ";
                    $sql .= " JOIN " . MAIN_DB_PREFIX . "facture as f ON fd.fk_facture = f.rowid";
                    $sql .= " JOIN " . MAIN_DB_PREFIX . "element_element as el ON ((el.fk_target = f.rowid AND el.targettype = 'facture' AND sourcetype = 'commande') OR (el.fk_source = f.rowid AND el.targettype = 'commande' AND sourcetype = 'facture'))";
                    $sql .= " JOIN " . MAIN_DB_PREFIX . "commande as c ON el.fk_source = c.rowid";
                    $sql .= " WHERE c.fk_statut IN (" . $this->db->sanitize($filtrestatut) . ") AND f.fk_statut > " . Facture::STATUS_DRAFT . " AND fd.fk_product = " . ((int)$this->id);

                    dol_syslog(__METHOD__ . ":: sql $sql", LOG_NOTICE);
                    $resql = $this->db->query($sql);
                    if ($resql) {
                        if ($this->db->num_rows($resql) > 0) {
                            $obj = $this->db->fetch_object($resql);
                            $adeduire += $obj->count;
                        }
                    } else {
                        $this->error = $this->db->error();
                        return -1;
                    }

                    $this->stats_commande['qty'] -= $adeduire;
                }
            }

            $parameters = array('socid' => $socid, 'filtrestatut' => $filtrestatut, 'forVirtualStock' => $forVirtualStock);
            $reshook = $hookmanager->executeHooks('loadStatsCustomerOrder', $parameters, $this, $action);
            if ($reshook > 0) {
                $this->stats_commande = $hookmanager->resArray['stats_commande'];
            }
            return 1;
        } else {
            $this->error = $this->db->error();
            return -1;
        }
    }

    /**
     *  Return all parent products for current product (first level only)
     *
     * @return array|int         Array of product
     * @see hasFatherOrChild()
     */
    public function getFather()
    {
        $sql = "SELECT p.rowid, p.label as label, p.ref as ref, pa.fk_product_pere as id, p.fk_product_type, pa.qty, pa.incdec, p.entity";
        $sql .= ", p.tosell as status, p.tobuy as status_buy";
        $sql .= " FROM " . $this->db->prefix() . "product_association as pa,";
        $sql .= " " . $this->db->prefix() . "product as p";
        $sql .= " WHERE p.rowid = pa.fk_product_pere";
        $sql .= " AND pa.fk_product_fils = " . ((int)$this->id);

        $res = $this->db->query($sql);
        if ($res) {
            $prods = array();
            while ($record = $this->db->fetch_array($res)) {
                // $record['id'] = $record['rowid'] = id of father
                $prods[$record['id']]['id'] = $record['rowid'];
                $prods[$record['id']]['ref'] = $record['ref'];
                $prods[$record['id']]['label'] = $record['label'];
                $prods[$record['id']]['qty'] = $record['qty'];
                $prods[$record['id']]['incdec'] = $record['incdec'];
                $prods[$record['id']]['fk_product_type'] = $record['fk_product_type'];
                $prods[$record['id']]['entity'] = $record['entity'];
                $prods[$record['id']]['status'] = $record['status'];
                $prods[$record['id']]['status_buy'] = $record['status_buy'];
            }
            return $prods;
        } else {
            dol_print_error($this->db);
            return -1;
        }
    }


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Charge tableau des stats expedition client pour le produit/service
     *
     * @param int $socid Id thirdparty to filter on a thirdparty
     * @param string $filtrestatut [=''] Ids order status separated by comma
     * @param int $forVirtualStock Ignore rights filter for virtual stock calculation.
     * @param string $filterShipmentStatus [=''] Ids shipment status separated by comma
     * @return  int                                 Array of stats in $this->stats_expedition, <0 if ko or >0 if ok
     */
    public function load_stats_sending($socid = 0, $filtrestatut = '', $forVirtualStock = 0, $filterShipmentStatus = '')
    {
        // phpcs:enable
        global $conf, $user, $hookmanager, $action;

        $sql = "SELECT COUNT(DISTINCT e.fk_soc) as nb_customers, COUNT(DISTINCT e.rowid) as nb,";
        $sql .= " COUNT(ed.rowid) as nb_rows, SUM(ed.qty) as qty";
        $sql .= " FROM " . $this->db->prefix() . "expeditiondet as ed";
        $sql .= ", " . $this->db->prefix() . "commandedet as cd";
        $sql .= ", " . $this->db->prefix() . "commande as c";
        $sql .= ", " . $this->db->prefix() . "expedition as e";
        $sql .= ", " . $this->db->prefix() . "societe as s";
        if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE e.rowid = ed.fk_expedition";
        $sql .= " AND c.rowid = cd.fk_commande";
        $sql .= " AND e.fk_soc = s.rowid";
        $sql .= " AND e.entity IN (" . getEntity($forVirtualStock && getDolGlobalString('STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE') ? 'stock' : 'expedition') . ")";
        $sql .= " AND ed.fk_elementdet = cd.rowid";
        $sql .= " AND cd.fk_product = " . ((int)$this->id);
        if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
            $sql .= " AND e.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND e.fk_soc = " . ((int)$socid);
        }
        if ($filtrestatut != '') {
            $sql .= " AND c.fk_statut IN (" . $this->db->sanitize($filtrestatut) . ")";
        }
        if (!empty($filterShipmentStatus)) {
            $sql .= " AND e.fk_statut IN (" . $this->db->sanitize($filterShipmentStatus) . ")";
        }

        $result = $this->db->query($sql);
        if ($result) {
            $obj = $this->db->fetch_object($result);
            $this->stats_expedition['customers'] = $obj->nb_customers;
            $this->stats_expedition['nb'] = $obj->nb;
            $this->stats_expedition['rows'] = $obj->nb_rows;
            $this->stats_expedition['qty'] = $obj->qty ? $obj->qty : 0;

            // if it's a virtual product, maybe it is in sending by extension
            if (getDolGlobalString('PRODUCT_STATS_WITH_PARENT_PROD_IF_INCDEC')) {
                $TFather = $this->getFather();
                if (is_array($TFather) && !empty($TFather)) {
                    foreach ($TFather as &$fatherData) {
                        $pFather = new Product($this->db);
                        $pFather->id = $fatherData['id'];
                        $qtyCoef = $fatherData['qty'];

                        if ($fatherData['incdec']) {
                            $pFather->load_stats_sending($socid, $filtrestatut, $forVirtualStock);

                            $this->stats_expedition['customers'] += $pFather->stats_expedition['customers'];
                            $this->stats_expedition['nb'] += $pFather->stats_expedition['nb'];
                            $this->stats_expedition['rows'] += $pFather->stats_expedition['rows'];
                            $this->stats_expedition['qty'] += $pFather->stats_expedition['qty'] * $qtyCoef;
                        }
                    }
                }
            }

            $parameters = array('socid' => $socid, 'filtrestatut' => $filtrestatut, 'forVirtualStock' => $forVirtualStock, 'filterShipmentStatus' => $filterShipmentStatus);
            $reshook = $hookmanager->executeHooks('loadStatsSending', $parameters, $this, $action);
            if ($reshook > 0) {
                $this->stats_expedition = $hookmanager->resArray['stats_expedition'];
            }

            return 1;
        } else {
            $this->error = $this->db->error();
            return -1;
        }
    }


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Charge tableau des stats commande fournisseur pour le produit/service
     *
     * @param int $socid Id thirdparty to filter on a thirdparty
     * @param string $filtrestatut Id of status to filter on status
     * @param int $forVirtualStock Ignore rights filter for virtual stock calculation.
     * @param int $dateofvirtualstock Date of virtual stock
     * @return  int                         Array of stats in $this->stats_commande_fournisseur, <0 if ko or >0 if ok
     */
    public function load_stats_commande_fournisseur($socid = 0, $filtrestatut = '', $forVirtualStock = 0, $dateofvirtualstock = null)
    {
        // phpcs:enable
        global $conf, $user, $hookmanager, $action;

        $sql = "SELECT COUNT(DISTINCT c.fk_soc) as nb_suppliers, COUNT(DISTINCT c.rowid) as nb,";
        $sql .= " COUNT(cd.rowid) as nb_rows, SUM(cd.qty) as qty";
        $sql .= " FROM " . $this->db->prefix() . "commande_fournisseurdet as cd";
        $sql .= ", " . $this->db->prefix() . "commande_fournisseur as c";
        $sql .= ", " . $this->db->prefix() . "societe as s";
        if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE c.rowid = cd.fk_commande";
        $sql .= " AND c.fk_soc = s.rowid";
        $sql .= " AND c.entity IN (" . getEntity($forVirtualStock && getDolGlobalString('STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE') ? 'stock' : 'supplier_order') . ")";
        $sql .= " AND cd.fk_product = " . ((int)$this->id);
        if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND c.fk_soc = " . ((int)$socid);
        }
        if ($filtrestatut != '') {
            $sql .= " AND c.fk_statut in (" . $this->db->sanitize($filtrestatut) . ")"; // Peut valoir 0
        }
        if (!empty($dateofvirtualstock)) {
            $sql .= " AND c.date_livraison <= '" . $this->db->idate($dateofvirtualstock) . "'";
        }

        $result = $this->db->query($sql);
        if ($result) {
            $obj = $this->db->fetch_object($result);
            $this->stats_commande_fournisseur['suppliers'] = $obj->nb_suppliers;
            $this->stats_commande_fournisseur['nb'] = $obj->nb;
            $this->stats_commande_fournisseur['rows'] = $obj->nb_rows;
            $this->stats_commande_fournisseur['qty'] = $obj->qty ? $obj->qty : 0;

            $parameters = array('socid' => $socid, 'filtrestatut' => $filtrestatut, 'forVirtualStock' => $forVirtualStock);
            $reshook = $hookmanager->executeHooks('loadStatsSupplierOrder', $parameters, $this, $action);
            if ($reshook > 0) {
                $this->stats_commande_fournisseur = $hookmanager->resArray['stats_commande_fournisseur'];
            }

            return 1;
        } else {
            $this->error = $this->db->error() . ' sql=' . $sql;
            return -1;
        }
    }

    /**
     *  Charge tableau des stats réception fournisseur pour le produit/service
     *
     * @param int $socid Id thirdparty to filter on a thirdparty
     * @param string $filtrestatut Id status to filter on a status
     * @param int $forVirtualStock Ignore rights filter for virtual stock calculation.
     * @param int $dateofvirtualstock Date of virtual stock
     * @return int                          Array of stats in $this->stats_reception, <0 if ko or >0 if ok
     */
    public function load_stats_reception($socid = 0, $filtrestatut = '', $forVirtualStock = 0, $dateofvirtualstock = null)
    {
        // phpcs:enable
        global $conf, $user, $hookmanager, $action;

        $sql = "SELECT COUNT(DISTINCT cf.fk_soc) as nb_suppliers, COUNT(DISTINCT cf.rowid) as nb,";
        $sql .= " COUNT(fd.rowid) as nb_rows, SUM(fd.qty) as qty";
        $sql .= " FROM " . $this->db->prefix() . "receptiondet_batch as fd";
        $sql .= ", " . $this->db->prefix() . "commande_fournisseur as cf";
        $sql .= ", " . $this->db->prefix() . "societe as s";
        if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE cf.rowid = fd.fk_element";
        $sql .= " AND cf.fk_soc = s.rowid";
        $sql .= " AND cf.entity IN (" . getEntity($forVirtualStock && getDolGlobalString('STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE') ? 'stock' : 'supplier_order') . ")";
        $sql .= " AND fd.fk_product = " . ((int)$this->id);
        if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
            $sql .= " AND cf.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND cf.fk_soc = " . ((int)$socid);
        }
        if ($filtrestatut != '') {
            $sql .= " AND cf.fk_statut IN (" . $this->db->sanitize($filtrestatut) . ")";
        }
        if (!empty($dateofvirtualstock)) {
            $sql .= " AND fd.datec <= '" . $this->db->idate($dateofvirtualstock) . "'";
        }

        $result = $this->db->query($sql);
        if ($result) {
            $obj = $this->db->fetch_object($result);
            $this->stats_reception['suppliers'] = $obj->nb_suppliers;
            $this->stats_reception['nb'] = $obj->nb;
            $this->stats_reception['rows'] = $obj->nb_rows;
            $this->stats_reception['qty'] = $obj->qty ? $obj->qty : 0;

            $parameters = array('socid' => $socid, 'filtrestatut' => $filtrestatut, 'forVirtualStock' => $forVirtualStock);
            $reshook = $hookmanager->executeHooks('loadStatsReception', $parameters, $this, $action);
            if ($reshook > 0) {
                $this->stats_reception = $hookmanager->resArray['stats_reception'];
            }

            return 1;
        } else {
            $this->error = $this->db->error();
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Charge tableau des stats production pour le produit/service
     *
     * @param int $socid Id thirdparty to filter on a thirdparty
     * @param string $filtrestatut Id status to filter on a status
     * @param int $forVirtualStock Ignore rights filter for virtual stock calculation.
     * @param int $dateofvirtualstock Date of virtual stock
     * @param int $warehouseid Filter by a warehouse. Warning: When a filter on a warehouse is set, it is not possible to calculate an accurate virtual stock because we can't know in which warehouse will be done virtual stock changes.
     * @return  integer                     Array of stats in $this->stats_mrptoproduce (nb=nb of order, qty=qty ordered), <0 if ko or >0 if ok
     */
    public function load_stats_inproduction($socid = 0, $filtrestatut = '', $forVirtualStock = 0, $dateofvirtualstock = null, $warehouseid = 0)
    {
        // phpcs:enable
        global $user, $hookmanager, $action;

        $serviceStockIsEnabled = isModEnabled("service") && getDolGlobalString('STOCK_SUPPORTS_SERVICES');

        $sql = "SELECT COUNT(DISTINCT m.fk_soc) as nb_customers, COUNT(DISTINCT m.rowid) as nb,";
        $sql .= " COUNT(mp.rowid) as nb_rows, SUM(mp.qty) as qty, role";
        $sql .= " FROM " . $this->db->prefix() . "mrp_production as mp";
        $sql .= ", " . $this->db->prefix() . "mrp_mo as m";
        $sql .= " LEFT JOIN " . $this->db->prefix() . "societe as s ON s.rowid = m.fk_soc";
        if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE m.rowid = mp.fk_mo";
        $sql .= " AND m.entity IN (" . getEntity(($forVirtualStock && getDolGlobalString('STOCK_CALCULATE_VIRTUAL_STOCK_TRANSVERSE_MODE')) ? 'stock' : 'mrp') . ")";
        $sql .= " AND mp.fk_product = " . ((int)$this->id);
        $sql .= " AND (mp.disable_stock_change IN (0) OR mp.disable_stock_change IS NULL)";
        if (!$user->hasRight('societe', 'client', 'voir') && !$forVirtualStock) {
            $sql .= " AND m.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND m.fk_soc = " . ((int)$socid);
        }
        if ($filtrestatut != '') {
            $sql .= " AND m.status IN (" . $this->db->sanitize($filtrestatut) . ")";
        }
        if (!empty($dateofvirtualstock)) {
            $sql .= " AND m.date_valid <= '" . $this->db->idate($dateofvirtualstock) . "'"; // better date to code ? end of production ?
        }
        if (!$serviceStockIsEnabled) {
            $sql .= "AND EXISTS (SELECT p.rowid FROM " . $this->db->prefix() . "product AS p WHERE p.rowid = " . ((int)$this->id) . " AND p.fk_product_type IN (0))";
        }
        if (!empty($warehouseid)) {
            $sql .= " AND m.fk_warehouse = " . ((int)$warehouseid);
        }
        $sql .= " GROUP BY role";

        if ($warehouseid) {
            $this->stock_warehouse[$warehouseid]->stats_mrptoproduce['qty'] = 0;
        } else {
            $this->stats_mrptoconsume['customers'] = 0;
            $this->stats_mrptoconsume['nb'] = 0;
            $this->stats_mrptoconsume['rows'] = 0;
            $this->stats_mrptoconsume['qty'] = 0;
            $this->stats_mrptoproduce['customers'] = 0;
            $this->stats_mrptoproduce['nb'] = 0;
            $this->stats_mrptoproduce['rows'] = 0;
            $this->stats_mrptoproduce['qty'] = 0;
        }

        $result = $this->db->query($sql);
        if ($result) {
            while ($obj = $this->db->fetch_object($result)) {
                if ($obj->role == 'toconsume' && empty($warehouseid)) {
                    $this->stats_mrptoconsume['customers'] += $obj->nb_customers;
                    $this->stats_mrptoconsume['nb'] += $obj->nb;
                    $this->stats_mrptoconsume['rows'] += $obj->nb_rows;
                    $this->stats_mrptoconsume['qty'] += ($obj->qty ? $obj->qty : 0);
                }
                if ($obj->role == 'consumed' && empty($warehouseid)) {
                    //$this->stats_mrptoconsume['customers'] += $obj->nb_customers;
                    //$this->stats_mrptoconsume['nb'] += $obj->nb;
                    //$this->stats_mrptoconsume['rows'] += $obj->nb_rows;
                    $this->stats_mrptoconsume['qty'] -= ($obj->qty ? $obj->qty : 0);
                }
                if ($obj->role == 'toproduce') {
                    if ($warehouseid) {
                        $this->stock_warehouse[$warehouseid]->stats_mrptoproduce['qty'] += ($obj->qty ? $obj->qty : 0);
                    } else {
                        $this->stats_mrptoproduce['customers'] += $obj->nb_customers;
                        $this->stats_mrptoproduce['nb'] += $obj->nb;
                        $this->stats_mrptoproduce['rows'] += $obj->nb_rows;
                        $this->stats_mrptoproduce['qty'] += ($obj->qty ? $obj->qty : 0);
                    }
                }
                if ($obj->role == 'produced') {
                    //$this->stats_mrptoproduce['customers'] += $obj->nb_customers;
                    //$this->stats_mrptoproduce['nb'] += $obj->nb;
                    //$this->stats_mrptoproduce['rows'] += $obj->nb_rows;
                    if ($warehouseid) {
                        $this->stock_warehouse[$warehouseid]->stats_mrptoproduce['qty'] -= ($obj->qty ? $obj->qty : 0);
                    } else {
                        $this->stats_mrptoproduce['qty'] -= ($obj->qty ? $obj->qty : 0);
                    }
                }
            }

            // Clean data
            if ($warehouseid) {
                if ($this->stock_warehouse[$warehouseid]->stats_mrptoproduce['qty'] < 0) {
                    $this->stock_warehouse[$warehouseid]->stats_mrptoproduce['qty'] = 0;
                }
            } else {
                if ($this->stats_mrptoconsume['qty'] < 0) {
                    $this->stats_mrptoconsume['qty'] = 0;
                }
                if ($this->stats_mrptoproduce['qty'] < 0) {
                    $this->stats_mrptoproduce['qty'] = 0;
                }
            }

            $parameters = array('socid' => $socid, 'filtrestatut' => $filtrestatut, 'forVirtualStock' => $forVirtualStock);
            $reshook = $hookmanager->executeHooks('loadStatsInProduction', $parameters, $this, $action);
            if ($reshook > 0) {
                $this->stats_mrptoproduce = $hookmanager->resArray['stats_mrptoproduce'];
            }

            return 1;
        } else {
            $this->error = $this->db->error();
            return -1;
        }
    }

    /**
     *  Load a product in memory from database
     *
     * @param int $id Id of product/service to load
     * @param string $ref Ref of product/service to load
     * @param string $ref_ext Ref ext of product/service to load
     * @param string $barcode Barcode of product/service to load
     * @param int $ignore_expression When module dynamicprices is on, ignores the math expression for calculating price and uses the db value instead
     * @param int $ignore_price_load Load product without loading $this->multiprices... array (when we are sure we don't need them)
     * @param int $ignore_lang_load Load product without loading $this->multilangs language arrays (when we are sure we don't need them)
     * @return int                       Return integer <0 if KO, 0 if not found, >0 if OK
     */
    public function fetch($id = 0, $ref = '', $ref_ext = '', $barcode = '', $ignore_expression = 0, $ignore_price_load = 0, $ignore_lang_load = 0)
    {
        include_once DOL_DOCUMENT_ROOT . '/core/lib/company.lib.php';

        global $langs, $conf;

        dol_syslog(get_only_class($this) . "::fetch id=" . $id . " ref=" . $ref . " ref_ext=" . $ref_ext);

        // Check parameters
        if (!$id && !$ref && !$ref_ext && !$barcode) {
            $this->error = 'ErrorWrongParameters';
            dol_syslog(get_only_class($this) . "::fetch " . $this->error, LOG_ERR);
            return -1;
        }

        $sql = "SELECT p.rowid, p.ref, p.ref_ext, p.label, p.description, p.url, p.note_public, p.note as note_private, p.customcode, p.fk_country, p.fk_state, p.lifetime, p.qc_frequency, p.price, p.price_ttc,";
        $sql .= " p.price_min, p.price_min_ttc, p.price_base_type, p.cost_price, p.default_vat_code, p.tva_tx, p.recuperableonly as tva_npr, p.localtax1_tx, p.localtax2_tx, p.localtax1_type, p.localtax2_type, p.tosell,";
        $sql .= " p.tobuy, p.fk_product_type, p.duration, p.fk_default_warehouse, p.fk_default_workstation, p.seuil_stock_alerte, p.canvas, p.net_measure, p.net_measure_units, p.weight, p.weight_units,";
        $sql .= " p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.last_main_doc,";
        $sql .= " p.surface, p.surface_units, p.volume, p.volume_units, p.barcode, p.fk_barcode_type, p.finished, p.fk_default_bom, p.mandatory_period,";
        if (!getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
            $sql .= " p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export,";
        } else {
            $sql .= " ppe.accountancy_code_buy, ppe.accountancy_code_buy_intra, ppe.accountancy_code_buy_export, ppe.accountancy_code_sell, ppe.accountancy_code_sell_intra, ppe.accountancy_code_sell_export,";
        }

        //For MultiCompany
        //PMP per entity & Stocks Sharings stock_reel includes only stocks shared with this entity
        $separatedEntityPMP = false;    // Set to true to get the AWP from table llx_product_perentity instead of field 'pmp' into llx_product.
        $separatedStock = false;        // Set to true will count stock from subtable llx_product_stock. It is slower than using denormalized field 'stock', but it is required when using multientity and shared warehouses.
        $visibleWarehousesEntities = $conf->entity;
        if (getDolGlobalString('MULTICOMPANY_PRODUCT_SHARING_ENABLED')) {
            if (getDolGlobalString('MULTICOMPANY_PMP_PER_ENTITY_ENABLED')) {
                $checkPMPPerEntity = $this->db->query("SELECT pmp FROM " . $this->db->prefix() . "product_perentity WHERE fk_product = " . ((int)$id) . " AND entity = " . (int)$conf->entity);
                if ($this->db->num_rows($checkPMPPerEntity) > 0) {
                    $separatedEntityPMP = true;
                }
            }
            global $mc;
            $separatedStock = true;
            if (isset($mc->sharings['stock']) && !empty($mc->sharings['stock'])) {
                $visibleWarehousesEntities .= "," . implode(",", $mc->sharings['stock']);
            }
        }
        if ($separatedEntityPMP) {
            $sql .= " ppe.pmp,";
        } else {
            $sql .= " p.pmp,";
        }
        $sql .= " p.datec, p.tms, p.import_key, p.entity, p.desiredstock, p.tobatch, p.sell_or_eat_by_mandatory, p.batch_mask, p.fk_unit,";
        $sql .= " p.fk_price_expression, p.price_autogen, p.model_pdf,";
        $sql .= " p.price_label,";
        if ($separatedStock) {
            $sql .= " SUM(sp.reel) as stock";
        } else {
            $sql .= " p.stock";
        }
        $sql .= " FROM " . $this->db->prefix() . "product as p";
        if (getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED') || $separatedEntityPMP) {
            $sql .= " LEFT JOIN " . $this->db->prefix() . "product_perentity as ppe ON ppe.fk_product = p.rowid AND ppe.entity = " . ((int)$conf->entity);
        }
        if ($separatedStock) {
            $sql .= " LEFT JOIN " . $this->db->prefix() . "product_stock as sp ON sp.fk_product = p.rowid AND sp.fk_entrepot IN (SELECT rowid FROM " . $this->db->prefix() . "entrepot WHERE entity IN (" . $this->db->sanitize($visibleWarehousesEntities) . "))";
        }

        if ($id) {
            $sql .= " WHERE p.rowid = " . ((int)$id);
        } else {
            $sql .= " WHERE p.entity IN (" . getEntity($this->element) . ")";
            if ($ref) {
                $sql .= " AND p.ref = '" . $this->db->escape($ref) . "'";
            } elseif ($ref_ext) {
                $sql .= " AND p.ref_ext = '" . $this->db->escape($ref_ext) . "'";
            } elseif ($barcode) {
                $sql .= " AND p.barcode = '" . $this->db->escape($barcode) . "'";
            }
        }
        if ($separatedStock) {
            $sql .= " GROUP BY p.rowid, p.ref, p.ref_ext, p.label, p.description, p.url, p.note_public, p.note, p.customcode, p.fk_country, p.fk_state, p.lifetime, p.qc_frequency, p.price, p.price_ttc,";
            $sql .= " p.price_min, p.price_min_ttc, p.price_base_type, p.cost_price, p.default_vat_code, p.tva_tx, p.recuperableonly, p.localtax1_tx, p.localtax2_tx, p.localtax1_type, p.localtax2_type, p.tosell,";
            $sql .= " p.tobuy, p.fk_product_type, p.duration, p.fk_default_warehouse, p.fk_default_workstation, p.seuil_stock_alerte, p.canvas, p.net_measure, p.net_measure_units, p.weight, p.weight_units,";
            $sql .= " p.length, p.length_units, p.width, p.width_units, p.height, p.height_units,";
            $sql .= " p.surface, p.surface_units, p.volume, p.volume_units, p.barcode, p.fk_barcode_type, p.finished, p.fk_default_bom, p.mandatory_period,";
            if (!getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
                $sql .= " p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export,";
            } else {
                $sql .= " ppe.accountancy_code_buy, ppe.accountancy_code_buy_intra, ppe.accountancy_code_buy_export, ppe.accountancy_code_sell, ppe.accountancy_code_sell_intra, ppe.accountancy_code_sell_export,";
            }
            if ($separatedEntityPMP) {
                $sql .= " ppe.pmp,";
            } else {
                $sql .= " p.pmp,";
            }
            $sql .= " p.datec, p.tms, p.import_key, p.entity, p.desiredstock, p.tobatch, p.sell_or_eat_by_mandatory, p.batch_mask, p.fk_unit,";
            $sql .= " p.fk_price_expression, p.price_autogen, p.model_pdf";
            $sql .= " ,p.price_label";
            if (!$separatedStock) {
                $sql .= ", p.stock";
            }
        }

        $resql = $this->db->query($sql);
        if ($resql) {
            unset($this->oldcopy);

            if ($this->db->num_rows($resql) > 0) {
                $obj = $this->db->fetch_object($resql);

                $this->id = $obj->rowid;
                $this->ref = $obj->ref;
                $this->ref_ext = $obj->ref_ext;
                $this->label = $obj->label;
                $this->description = $obj->description;
                $this->url = $obj->url;
                $this->note_public = $obj->note_public;
                $this->note_private = $obj->note_private;
                $this->note = $obj->note_private; // deprecated
                /** @scrutinizer ignore-deprecated */ $this->note = $obj->note_private; // deprecated

                $this->type = $obj->fk_product_type;
                $this->price_label = $obj->price_label;
                $this->status = $obj->tosell;
                $this->status_buy = $obj->tobuy;
                $this->status_batch = $obj->tobatch;
                $this->sell_or_eat_by_mandatory = $obj->sell_or_eat_by_mandatory;
                $this->batch_mask = $obj->batch_mask;

                $this->customcode = $obj->customcode;
                $this->country_id = $obj->fk_country;
                $this->country_code = getCountry($this->country_id, 2, $this->db);
class Id
{
    public $id;

    public function __construct($id)
    {
        $this->id = $id;
    }

}

class Account
{
    /** @var  Id $id */
    public $id;
}

$account_id = false;

if (starsAreRight()) {
    $account_id = new Id(42);
}

$account = new Account();
if ($account instanceof Id)
{
    $account->id = $account_id;
}
                $this->state_id = $obj->fk_state;
                $this->lifetime = $obj->lifetime;
                $this->qc_frequency = $obj->qc_frequency;
                $this->price = $obj->price;
                $this->price_ttc = $obj->price_ttc;
                $this->price_min = $obj->price_min;
                $this->price_min_ttc = $obj->price_min_ttc;
                $this->price_base_type = $obj->price_base_type;
                $this->cost_price = $obj->cost_price;
                $this->default_vat_code = $obj->default_vat_code;
                $this->tva_tx = $obj->tva_tx;
                //! French VAT NPR
                $this->tva_npr = $obj->tva_npr;
                //! Local taxes
                $this->localtax1_tx = $obj->localtax1_tx;
                $this->localtax2_tx = $obj->localtax2_tx;
                $this->localtax1_type = $obj->localtax1_type;
                $this->localtax2_type = $obj->localtax2_type;

                $this->finished = $obj->finished;
                $this->fk_default_bom = $obj->fk_default_bom;

                $this->duration = $obj->duration;
                $this->duration_value = $obj->duration ? substr($obj->duration, 0, dol_strlen($obj->duration) - 1) : null;
                $this->duration_unit = $obj->duration ? substr($obj->duration, -1) : null;
                $this->canvas = $obj->canvas;
                $this->net_measure = $obj->net_measure;
                $this->net_measure_units = $obj->net_measure_units;
                $this->weight = $obj->weight;
                $this->weight_units = $obj->weight_units;
                $this->length = $obj->length;
                $this->length_units = $obj->length_units;
                $this->width = $obj->width;
                $this->width_units = $obj->width_units;
                $this->height = $obj->height;
                $this->height_units = $obj->height_units;

                $this->surface = $obj->surface;
                $this->surface_units = $obj->surface_units;
                $this->volume = $obj->volume;
                $this->volume_units = $obj->volume_units;
                $this->barcode = $obj->barcode;
                $this->barcode_type = $obj->fk_barcode_type;

                $this->accountancy_code_buy = $obj->accountancy_code_buy;
                $this->accountancy_code_buy_intra = $obj->accountancy_code_buy_intra;
                $this->accountancy_code_buy_export = $obj->accountancy_code_buy_export;
                $this->accountancy_code_sell = $obj->accountancy_code_sell;
                $this->accountancy_code_sell_intra = $obj->accountancy_code_sell_intra;
                $this->accountancy_code_sell_export = $obj->accountancy_code_sell_export;

                $this->fk_default_warehouse = $obj->fk_default_warehouse;
                $this->fk_default_workstation = $obj->fk_default_workstation;
                $this->seuil_stock_alerte = $obj->seuil_stock_alerte;
                $this->desiredstock = $obj->desiredstock;
                $this->stock_reel = $obj->stock;
                $this->pmp = $obj->pmp;

                $this->date_creation = $obj->datec;
                $this->date_modification = $obj->tms;
                $this->import_key = $obj->import_key;
                $this->entity = $obj->entity;

                $this->ref_ext = $obj->ref_ext;
                $this->fk_price_expression = $obj->fk_price_expression;
                $this->fk_unit = $obj->fk_unit;
                $this->price_autogen = $obj->price_autogen;
                $this->model_pdf = $obj->model_pdf;
                $this->last_main_doc = $obj->last_main_doc;

                $this->mandatory_period = $obj->mandatory_period;

                $this->db->free($resql);

                // fetch optionals attributes and labels
                $this->fetch_optionals();

                // Multilangs
                if (getDolGlobalInt('MAIN_MULTILANGS') && empty($ignore_lang_load)) {
                    $this->getMultiLangs();
                }

                // Load multiprices array
                if (getDolGlobalString('PRODUIT_MULTIPRICES') && empty($ignore_price_load)) {                // prices per segment
                    $produit_multiprices_limit = getDolGlobalString('PRODUIT_MULTIPRICES_LIMIT');
                    for ($i = 1; $i <= $produit_multiprices_limit; $i++) {
                        $sql = "SELECT price, price_ttc, price_min, price_min_ttc,";
                        $sql .= " price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly";
                        $sql .= " ,price_label";
                        $sql .= " FROM " . $this->db->prefix() . "product_price";
                        $sql .= " WHERE entity IN (" . getEntity('productprice') . ")";
                        $sql .= " AND price_level=" . ((int)$i);
                        $sql .= " AND fk_product = " . ((int)$this->id);
                        $sql .= " ORDER BY date_price DESC, rowid DESC";    // Get the most recent line
                        $sql .= " LIMIT 1";                                 // Only the first one
                        $resql = $this->db->query($sql);
                        if ($resql) {
                            $result = $this->db->fetch_array($resql);

                            $this->multiprices[$i] = $result ? $result["price"] : null;
                            $this->multiprices_ttc[$i] = $result ? $result["price_ttc"] : null;
                            $this->multiprices_min[$i] = $result ? $result["price_min"] : null;
                            $this->multiprices_min_ttc[$i] = $result ? $result["price_min_ttc"] : null;
                            $this->multiprices_base_type[$i] = $result ? $result["price_base_type"] : null;
                            // Next two fields are used only if PRODUIT_MULTIPRICES_USE_VAT_PER_LEVEL is on
                            $this->multiprices_tva_tx[$i] = $result ? $result["tva_tx"] . ($result ? ' (' . $result['default_vat_code'] . ')' : '') : null;
                            $this->multiprices_recuperableonly[$i] = $result ? $result["recuperableonly"] : null;

                            // Price by quantity
                            /*
                             $this->prices_by_qty[$i]=$result["price_by_qty"];
                             $this->prices_by_qty_id[$i]=$result["rowid"];
                             // Récuperation de la liste des prix selon qty si flag positionné
                             if ($this->prices_by_qty[$i] == 1)
                             {
                             $sql = "SELECT rowid, price, unitprice, quantity, remise_percent, remise, price_base_type";
                             $sql.= " FROM ".$this->db->prefix()."product_price_by_qty";
                             $sql.= " WHERE fk_product_price = ".((int) $this->prices_by_qty_id[$i]);
                             $sql.= " ORDER BY quantity ASC";

                             $resql = $this->db->query($sql);
                             if ($resql)
                             {
                             $resultat=array();
                             $ii=0;
                             while ($result= $this->db->fetch_array($resql)) {
                             $resultat[$ii]=array();
                             $resultat[$ii]["rowid"]=$result["rowid"];
                             $resultat[$ii]["price"]= $result["price"];
                             $resultat[$ii]["unitprice"]= $result["unitprice"];
                             $resultat[$ii]["quantity"]= $result["quantity"];
                             $resultat[$ii]["remise_percent"]= $result["remise_percent"];
                             $resultat[$ii]["remise"]= $result["remise"];                    // deprecated
                             $resultat[$ii]["price_base_type"]= $result["price_base_type"];
                             $ii++;
                             }
                             $this->prices_by_qty_list[$i]=$resultat;
                             }
                             else
                             {
                             dol_print_error($this->db);
                             return -1;
                             }
                             }*/
                        } else {
                            $this->error = $this->db->lasterror;
                            return -1;
                        }
                    }
                } elseif (getDolGlobalString('PRODUIT_CUSTOMER_PRICES') && empty($ignore_price_load)) {            // prices per customers
                    // Nothing loaded by default. List may be very long.
                } elseif (getDolGlobalString('PRODUIT_CUSTOMER_PRICES_BY_QTY') && empty($ignore_price_load)) {    // prices per quantity
                    $sql = "SELECT price, price_ttc, price_min, price_min_ttc,";
                    $sql .= " price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid";
                    $sql .= " FROM " . $this->db->prefix() . "product_price";
                    $sql .= " WHERE fk_product = " . ((int)$this->id);
                    $sql .= " ORDER BY date_price DESC, rowid DESC";
                    $sql .= " LIMIT 1";

                    $resql = $this->db->query($sql);
                    if ($resql) {
                        $result = $this->db->fetch_array($resql);

                        if ($result) {
                            // Price by quantity
                            $this->prices_by_qty[0] = $result["price_by_qty"];
                            $this->prices_by_qty_id[0] = $result["rowid"];
                            // Récuperation de la liste des prix selon qty si flag positionné
                            if ($this->prices_by_qty[0] == 1) {
                                $sql = "SELECT rowid,price, unitprice, quantity, remise_percent, remise, remise, price_base_type";
                                $sql .= " FROM " . $this->db->prefix() . "product_price_by_qty";
                                $sql .= " WHERE fk_product_price = " . ((int)$this->prices_by_qty_id[0]);
                                $sql .= " ORDER BY quantity ASC";

                                $resql = $this->db->query($sql);
                                if ($resql) {
                                    $resultat = array();
                                    $ii = 0;
                                    while ($result = $this->db->fetch_array($resql)) {
                                        $resultat[$ii] = array();
                                        $resultat[$ii]["rowid"] = $result["rowid"];
                                        $resultat[$ii]["price"] = $result["price"];
                                        $resultat[$ii]["unitprice"] = $result["unitprice"];
                                        $resultat[$ii]["quantity"] = $result["quantity"];
                                        $resultat[$ii]["remise_percent"] = $result["remise_percent"];
                                        //$resultat[$ii]["remise"]= $result["remise"];                    // deprecated
                                        $resultat[$ii]["price_base_type"] = $result["price_base_type"];
                                        $ii++;
                                    }
                                    $this->prices_by_qty_list[0] = $resultat;
                                } else {
                                    $this->error = $this->db->lasterror;
                                    return -1;
                                }
                            }
                        }
                    } else {
                        $this->error = $this->db->lasterror;
                        return -1;
                    }
                } elseif (getDolGlobalString('PRODUIT_CUSTOMER_PRICES_BY_QTY_MULTIPRICES') && empty($ignore_price_load)) {    // prices per customer and quantity
                    $produit_multiprices_limit = getDolGlobalString('PRODUIT_MULTIPRICES_LIMIT');
                    for ($i = 1; $i <= $produit_multiprices_limit; $i++) {
                        $sql = "SELECT price, price_ttc, price_min, price_min_ttc,";
                        $sql .= " price_base_type, tva_tx, default_vat_code, tosell, price_by_qty, rowid, recuperableonly";
                        $sql .= " FROM " . $this->db->prefix() . "product_price";
                        $sql .= " WHERE entity IN (" . getEntity('productprice') . ")";
                        $sql .= " AND price_level=" . ((int)$i);
                        $sql .= " AND fk_product = " . ((int)$this->id);
                        $sql .= " ORDER BY date_price DESC, rowid DESC";
                        $sql .= " LIMIT 1";
                        $resql = $this->db->query($sql);
                        if (!$resql) {
                            $this->error = $this->db->lasterror;
                            return -1;
                        } elseif ($result = $this->db->fetch_array($resql)) {
                            $this->multiprices[$i] = (!empty($result["price"]) ? $result["price"] : 0);
                            $this->multiprices_ttc[$i] = (!empty($result["price_ttc"]) ? $result["price_ttc"] : 0);
                            $this->multiprices_min[$i] = (!empty($result["price_min"]) ? $result["price_min"] : 0);
                            $this->multiprices_min_ttc[$i] = (!empty($result["price_min_ttc"]) ? $result["price_min_ttc"] : 0);
                            $this->multiprices_base_type[$i] = (!empty($result["price_base_type"]) ? $result["price_base_type"] : '');
                            // Next two fields are used only if PRODUIT_MULTIPRICES_USE_VAT_PER_LEVEL is on
                            $this->multiprices_tva_tx[$i] = (!empty($result["tva_tx"]) ? $result["tva_tx"] : 0); // TODO Add ' ('.$result['default_vat_code'].')'
                            $this->multiprices_recuperableonly[$i] = (!empty($result["recuperableonly"]) ? $result["recuperableonly"] : 0);

                            // Price by quantity
                            $this->prices_by_qty[$i] = (!empty($result["price_by_qty"]) ? $result["price_by_qty"] : 0);
                            $this->prices_by_qty_id[$i] = (!empty($result["rowid"]) ? $result["rowid"] : 0);
                            // Récuperation de la liste des prix selon qty si flag positionné
                            if ($this->prices_by_qty[$i] == 1) {
                                $sql = "SELECT rowid, price, unitprice, quantity, remise_percent, remise, price_base_type";
                                $sql .= " FROM " . $this->db->prefix() . "product_price_by_qty";
                                $sql .= " WHERE fk_product_price = " . ((int)$this->prices_by_qty_id[$i]);
                                $sql .= " ORDER BY quantity ASC";

                                $resql = $this->db->query($sql);
                                if ($resql) {
                                    $resultat = array();
                                    $ii = 0;
                                    while ($result = $this->db->fetch_array($resql)) {
                                        $resultat[$ii] = array();
                                        $resultat[$ii]["rowid"] = $result["rowid"];
                                        $resultat[$ii]["price"] = $result["price"];
                                        $resultat[$ii]["unitprice"] = $result["unitprice"];
                                        $resultat[$ii]["quantity"] = $result["quantity"];
                                        $resultat[$ii]["remise_percent"] = $result["remise_percent"];
                                        $resultat[$ii]["remise"] = $result["remise"]; // deprecated
                                        $resultat[$ii]["price_base_type"] = $result["price_base_type"];
                                        $ii++;
                                    }
                                    $this->prices_by_qty_list[$i] = $resultat;
                                } else {
                                    $this->error = $this->db->lasterror;
                                    return -1;
                                }
                            }
                        }
                    }
                }

                if (isModEnabled('dynamicprices') && !empty($this->fk_price_expression) && empty($ignore_expression)) {
                    include_once DOL_DOCUMENT_ROOT . '/product/dynamic_price/class/price_parser.class.php';
                    $priceparser = new PriceParser($this->db);
                    $price_result = $priceparser->parseProduct($this);
                    if ($price_result >= 0) {
                        $this->price = $price_result;
                        // Calculate the VAT
                        $this->price_ttc = (float)price2num($this->price) * (1 + ($this->tva_tx / 100));
                        $this->price_ttc = (float)price2num($this->price_ttc, 'MU');
                    }
                }

                // We should not load stock during the fetch. If someone need stock of product, he must call load_stock after fetching product.
                // Instead we just init the stock_warehouse array
                $this->stock_warehouse = array();

                return 1;
            } else {
                return 0;
            }
        } else {
            $this->error = $this->db->lasterror();
            return -1;
        }
    }

    /**
     *    Load array this->multilangs
     *
     * @return int        Return integer <0 if KO, >0 if OK
     */
    public function getMultiLangs()
    {
        global $langs;

        $current_lang = $langs->getDefaultLang();

        $sql = "SELECT lang, label, description, note as other";
        $sql .= " FROM " . $this->db->prefix() . "product_lang";
        $sql .= " WHERE fk_product = " . ((int)$this->id);

        $result = $this->db->query($sql);
        if ($result) {
            while ($obj = $this->db->fetch_object($result)) {
                //print 'lang='.$obj->lang.' current='.$current_lang.'<br>';
                if ($obj->lang == $current_lang) {  // si on a les traduct. dans la langue courante on les charge en infos principales.
                    $this->label = $obj->label;
                    $this->description = $obj->description;
                    $this->other = $obj->other;
                }
                $this->multilangs[(string)$obj->lang]["label"] = $obj->label;
                $this->multilangs[(string)$obj->lang]["description"] = $obj->description;
                $this->multilangs[(string)$obj->lang]["other"] = $obj->other;
            }
            return 1;
        } else {
            $this->error = "Error: " . $this->db->lasterror() . " - " . $sql;
            return -1;
        }
    }

    /**
     *    Update or add a translation for a product
     *
     * @param User $user Object user making update
     * @return int        Return integer <0 if KO, >0 if OK
     */
    public function setMultiLangs($user)
    {
        global $conf, $langs;

        $langs_available = $langs->get_available_languages(DOL_DOCUMENT_ROOT, 0, 2);
        $current_lang = $langs->getDefaultLang();

        foreach ($langs_available as $key => $value) {
            if ($key == $current_lang) {
                $sql = "SELECT rowid";
                $sql .= " FROM " . $this->db->prefix() . "product_lang";
                $sql .= " WHERE fk_product = " . ((int)$this->id);
                $sql .= " AND lang = '" . $this->db->escape($key) . "'";

                $result = $this->db->query($sql);

                if ($this->db->num_rows($result)) { // if there is already a description line for this language
                    $sql2 = "UPDATE " . $this->db->prefix() . "product_lang";
                    $sql2 .= " SET ";
                    $sql2 .= " label='" . $this->db->escape($this->label) . "',";
                    $sql2 .= " description='" . $this->db->escape($this->description) . "'";
                    if (getDolGlobalString('PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION')) {
                        $sql2 .= ", note='" . $this->db->escape($this->other) . "'";
                    }
                    $sql2 .= " WHERE fk_product = " . ((int)$this->id) . " AND lang = '" . $this->db->escape($key) . "'";
                } else {
                    $sql2 = "INSERT INTO " . $this->db->prefix() . "product_lang (fk_product, lang, label, description";
                    if (getDolGlobalString('PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION')) {
                        $sql2 .= ", note";
                    }
                    $sql2 .= ")";
                    $sql2 .= " VALUES(" . ((int)$this->id) . ",'" . $this->db->escape($key) . "','" . $this->db->escape($this->label) . "',";
                    $sql2 .= " '" . $this->db->escape($this->description) . "'";
                    if (getDolGlobalString('PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION')) {
                        $sql2 .= ", '" . $this->db->escape($this->other) . "'";
                    }
                    $sql2 .= ")";
                }
                dol_syslog(get_only_class($this) . '::setMultiLangs key = current_lang = ' . $key);
                if (!$this->db->query($sql2)) {
                    $this->error = $this->db->lasterror();
                    return -1;
                }
            } elseif (isset($this->multilangs[$key])) {
                if (empty($this->multilangs["$key"]["label"])) {
                    $this->errors[] = $key . ' : ' . $langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Label"));
                    return -1;
                }

                $sql = "SELECT rowid";
                $sql .= " FROM " . $this->db->prefix() . "product_lang";
                $sql .= " WHERE fk_product = " . ((int)$this->id);
                $sql .= " AND lang = '" . $this->db->escape($key) . "'";

                $result = $this->db->query($sql);

                if ($this->db->num_rows($result)) { // if there is already a description line for this language
                    $sql2 = "UPDATE " . $this->db->prefix() . "product_lang";
                    $sql2 .= " SET ";
                    $sql2 .= " label = '" . $this->db->escape($this->multilangs["$key"]["label"]) . "',";
                    $sql2 .= " description = '" . $this->db->escape($this->multilangs["$key"]["description"]) . "'";
                    if (getDolGlobalString('PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION')) {
                        $sql2 .= ", note = '" . $this->db->escape($this->multilangs["$key"]["other"]) . "'";
                    }
                    $sql2 .= " WHERE fk_product = " . ((int)$this->id) . " AND lang = '" . $this->db->escape($key) . "'";
                } else {
                    $sql2 = "INSERT INTO " . $this->db->prefix() . "product_lang (fk_product, lang, label, description";
                    if (getDolGlobalString('PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION')) {
                        $sql2 .= ", note";
                    }
                    $sql2 .= ")";
                    $sql2 .= " VALUES(" . ((int)$this->id) . ",'" . $this->db->escape($key) . "','" . $this->db->escape($this->multilangs["$key"]["label"]) . "',";
                    $sql2 .= " '" . $this->db->escape($this->multilangs["$key"]["description"]) . "'";
                    if (getDolGlobalString('PRODUCT_USE_OTHER_FIELD_IN_TRANSLATION')) {
                        $sql2 .= ", '" . $this->db->escape($this->multilangs["$key"]["other"]) . "'";
                    }
                    $sql2 .= ")";
                }

                // We do not save if main fields are empty
                if ($this->multilangs["$key"]["label"] || $this->multilangs["$key"]["description"]) {
                    if (!$this->db->query($sql2)) {
                        $this->error = $this->db->lasterror();
                        return -1;
                    }
                }
            } else {
                // language is not current language and we didn't provide a multilang description for this language
            }
        }

        // Call trigger
        $result = $this->call_trigger('PRODUCT_SET_MULTILANGS', $user);
        if ($result < 0) {
            $this->error = $this->db->lasterror();
            return -1;
        }
        // End call triggers

        return 1;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Return if object is a product.
     *
     * @return boolean     True if it's a product
     */
    public function isProduct()
    {
        return ($this->type == Product::TYPE_PRODUCT ? true : false);
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Return if object is a product
     *
     * @return boolean     True if it's a service
     */
    public function isService()
    {
        return ($this->type == Product::TYPE_SERVICE ? true : false);
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Adjust stock in a warehouse for product with batch number
     *
     * @param User $user user asking change
     * @param int $id_entrepot id of warehouse
     * @param double $nbpiece nb of units (should be always positive, use $movement to decide if we add or remove)
     * @param int $movement 0 = add, 1 = remove
     * @param string $label Label of stock movement
     * @param double $price Price to use for stock eval
     * @param int|string $dlc eat-by date
     * @param int|string $dluo sell-by date
     * @param string $lot Lot number
     * @param string $inventorycode Inventory code
     * @param string $origin_element Origin element type
     * @param int $origin_id Origin id of element
     * @param int $disablestockchangeforsubproduct Disable stock change for sub-products of kit (useful only if product is a subproduct)
     * @param Extrafields $extrafields Array of extrafields
     * @param boolean $force_update_batch Force update batch
     * @return int                      Return integer <0 if KO, >0 if OK
     */
    public function correct_stock_batch($user, $id_entrepot, $nbpiece, $movement, $label = '', $price = 0, $dlc = '', $dluo = '', $lot = '', $inventorycode = '', $origin_element = '', $origin_id = null, $disablestockchangeforsubproduct = 0, $extrafields = null, $force_update_batch = false)
    {
        // phpcs:enable
        if ($id_entrepot) {
            $this->db->begin();

            include_once DOL_DOCUMENT_ROOT . '/product/stock/class/mouvementstock.class.php';

            if ($nbpiece < 0) {
                if (!$movement) {
                    $movement = 1;
                }
                $nbpiece = abs($nbpiece);
            }

            $op = array();
            $op[0] = "+" . trim((string)$nbpiece);
            $op[1] = "-" . trim((string)$nbpiece);

            $movementstock = new MouvementStock($this->db);
            $movementstock->setOrigin($origin_element, $origin_id); // Set ->origin_type and ->fk_origin
            $result = $movementstock->_create($user, $this->id, $id_entrepot, $op[$movement], $movement, $price, $label, $inventorycode, '', $dlc, $dluo, $lot, false, 0, $disablestockchangeforsubproduct, 0, $force_update_batch);

            if ($result >= 0) {
                if ($extrafields) {
                    $array_options = $extrafields->getOptionalsFromPost('stock_mouvement');
                    $movementstock->array_options = $array_options;
                    $movementstock->insertExtraFields();
                }
                $this->db->commit();
                return 1;
            } else {
                $this->error = $movementstock->error;
                $this->errors = $movementstock->errors;

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


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Adjust stock in a warehouse for product
     *
     * @param User $user user asking change
     * @param int $id_entrepot id of warehouse
     * @param double $nbpiece nb of units (should be always positive, use $movement to decide if we add or remove)
     * @param int $movement 0 = add, 1 = remove
     * @param string $label Label of stock movement
     * @param double $price Unit price HT of product, used to calculate average weighted price (PMP in french). If 0, average weighted price is not changed.
     * @param string $inventorycode Inventory code
     * @param string $origin_element Origin element type
     * @param int $origin_id Origin id of element
     * @param int $disablestockchangeforsubproduct Disable stock change for sub-products of kit (useful only if product is a subproduct)
     * @param Extrafields $extrafields Array of extrafields
     * @return int                    Return integer <0 if KO, >0 if OK
     */
    public function correct_stock($user, $id_entrepot, $nbpiece, $movement, $label = '', $price = 0, $inventorycode = '', $origin_element = '', $origin_id = null, $disablestockchangeforsubproduct = 0, $extrafields = null)
    {
        // phpcs:enable
        if ($id_entrepot) {
            $this->db->begin();

            include_once DOL_DOCUMENT_ROOT . '/product/stock/class/mouvementstock.class.php';

            if ($nbpiece < 0) {
                if (!$movement) {
                    $movement = 1;
                }
                $nbpiece = abs($nbpiece);
            }
            $op = array();
            $op[0] = "+" . trim((string)$nbpiece);
            $op[1] = "-" . trim((string)$nbpiece);

            $movementstock = new MouvementStock($this->db);
            $movementstock->setOrigin($origin_element, $origin_id); // Set ->origin_type and ->origin_id
            $result = $movementstock->_create($user, $this->id, $id_entrepot, $op[$movement], $movement, $price, $label, $inventorycode, '', '', '', '', false, 0, $disablestockchangeforsubproduct);

            if ($result >= 0) {
                if ($extrafields) {
                    $array_options = $extrafields->getOptionalsFromPost('stock_mouvement');
                    $movementstock->array_options = $array_options;
                    $movementstock->insertExtraFields();
                }
                $this->db->commit();
                return 1;
            } else {
                $this->error = $movementstock->error;
                $this->errors = $movementstock->errors;

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

        return -1;
    }


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Delete a product from database (if not used)
     *
     * @param User $user User (object) deleting product
     * @param int $notrigger Do not execute trigger
     * @return int                    Return integer < 0 if KO, 0 = Not possible, > 0 if OK
     */
    public function delete(User $user, $notrigger = 0)
    {
        global $conf, $langs;
        include_once DOL_DOCUMENT_ROOT . '/core/lib/files.lib.php';

        $error = 0;

        // Check parameters
        if (empty($this->id)) {
            $this->error = "Object must be fetched before calling delete";
            return -1;
        }
        if (($this->type == Product::TYPE_PRODUCT && !$user->hasRight('produit', 'supprimer')) || ($this->type == Product::TYPE_SERVICE && !$user->hasRight('service', 'supprimer'))) {
            $this->error = "ErrorForbidden";
            return 0;
        }

        $objectisused = $this->isObjectUsed($this->id);
        if (empty($objectisused)) {
            $this->db->begin();

            if (!$error && empty($notrigger)) {
                // Call trigger
                $result = $this->call_trigger('PRODUCT_DELETE', $user);
                if ($result < 0) {
                    $error++;
                }
                // End call triggers
            }

            // Delete from product_batch on product delete
            if (!$error) {
                $sql = "DELETE FROM " . $this->db->prefix() . 'product_batch';
                $sql .= " WHERE fk_product_stock IN (";
                $sql .= "SELECT rowid FROM " . $this->db->prefix() . 'product_stock';
                $sql .= " WHERE fk_product = " . ((int)$this->id) . ")";

                $result = $this->db->query($sql);
                if (!$result) {
                    $error++;
                    $this->errors[] = $this->db->lasterror();
                }
            }

            // Delete all child tables
            if (!$error) {
                $elements = array('product_fournisseur_price', 'product_price', 'product_lang', 'categorie_product', 'product_stock', 'product_customer_price', 'product_lot'); // product_batch is done before
                foreach ($elements as $table) {
                    if (!$error) {
                        $sql = "DELETE FROM " . $this->db->prefix() . $table;
                        $sql .= " WHERE fk_product = " . (int)$this->id;

                        $result = $this->db->query($sql);
                        if (!$result) {
                            $error++;
                            $this->errors[] = $this->db->lasterror();
                        }
                    }
                }
            }

            if (!$error) {
                //If it is a parent product, then we remove the association with child products
                $prodcomb = new ProductAttributeCombination();

                if ($prodcomb->deleteByFkProductParent($user, $this->id) < 0) {
class A
{
    function getObject()
    {
        return null;
    }

}

$a = new A();
if ($a->getObject()) {
                    $error++;
                    $this->errors[] = 'Error deleting combinations';
                }

                //We also check if it is a child product
                if (!$error && ($prodcomb->fetchByFkProductChild($this->id) > 0) && ($prodcomb->delete($user) < 0)) {
                    $error++;
                    $this->errors[] = 'Error deleting child combination';
                }
            }

            // Delete from product_association
            if (!$error) {
                $sql = "DELETE FROM " . $this->db->prefix() . "product_association";
                $sql .= " WHERE fk_product_pere = " . (int)$this->id . " OR fk_product_fils = " . (int)$this->id;

                $result = $this->db->query($sql);
                if (!$result) {
                    $error++;
                    $this->errors[] = $this->db->lasterror();
                }
            }

            // Remove extrafields
            if (!$error) {
                $result = $this->deleteExtraFields();
                if ($result < 0) {
                    $error++;
                    dol_syslog(get_only_class($this) . "::delete error -4 " . $this->error, LOG_ERR);
                }
            }

            // Delete product
            if (!$error) {
                $sqlz = "DELETE FROM " . $this->db->prefix() . "product";
                $sqlz .= " WHERE rowid = " . (int)$this->id;

                $resultz = $this->db->query($sqlz);
                if (!$resultz) {
                    $error++;
                    $this->errors[] = $this->db->lasterror();
                }
            }

            // Delete record into ECM index and physically
            if (!$error) {
                $res = $this->deleteEcmFiles(0); // Deleting files physically is done later with the dol_delete_dir_recursive
                $res = $this->deleteEcmFiles(1); // Deleting files physically is done later with the dol_delete_dir_recursive
                if (!$res) {
                    $error++;
                }
            }

            if (!$error) {
                // We remove directory
                $ref = dol_sanitizeFileName($this->ref);
                if ($conf->product->dir_output) {
                    $dir = $conf->product->dir_output . "/" . $ref;
                    if (file_exists($dir)) {
                        $res = @dol_delete_dir_recursive($dir);
                        if (!$res) {
                            $this->errors[] = 'ErrorFailToDeleteDir';
                            $error++;
                        }
                    }
                }
            }

            if (!$error) {
                $this->db->commit();
                return 1;
            } else {
                foreach ($this->errors as $errmsg) {
                    dol_syslog(get_only_class($this) . "::delete " . $errmsg, LOG_ERR);
                    $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                }
                $this->db->rollback();
                return -$error;
            }
        } else {
            $this->error = "ErrorRecordIsUsedCantDelete";
            return 0;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Get sell or eat by mandatory label
     *
     * @return  string  Sell or eat by mandatory label
     */
    public function getSellOrEatByMandatoryLabel()
    {
        $sellOrEatByMandatoryLabel = '';

        $sellOrEatByMandatoryList = self::getSellOrEatByMandatoryList();
        if (isset($sellOrEatByMandatoryList[$this->sell_or_eat_by_mandatory])) {
            $sellOrEatByMandatoryLabel = $sellOrEatByMandatoryList[$this->sell_or_eat_by_mandatory];
        }

        return $sellOrEatByMandatoryLabel;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Get sell or eat by mandatory list
     *
     * @return  array   Sell or eat by mandatory list
     */
    public static function getSellOrEatByMandatoryList()
    {
        global $langs;

        $sellByLabel = $langs->trans('SellByDate');
        $eatByLabel = $langs->trans('EatByDate');
        return array(
            self::SELL_OR_EAT_BY_MANDATORY_ID_NONE => $langs->trans('BatchSellOrEatByMandatoryNone'),
            self::SELL_OR_EAT_BY_MANDATORY_ID_SELL_BY => $sellByLabel,
            self::SELL_OR_EAT_BY_MANDATORY_ID_EAT_BY => $eatByLabel,
            self::SELL_OR_EAT_BY_MANDATORY_ID_SELL_AND_EAT => $langs->trans('BatchSellOrEatByMandatoryAll', $sellByLabel, $eatByLabel),
        );
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *    Delete a language for this product
     *
     * @param string $langtodelete Language code to delete
     * @param User $user Object user making delete
     *
     * @return int                            Return integer <0 if KO, >0 if OK
     */
    public function delMultiLangs($langtodelete, $user)
    {
        $sql = "DELETE FROM " . $this->db->prefix() . "product_lang";
        $sql .= " WHERE fk_product = " . ((int)$this->id) . " AND lang = '" . $this->db->escape($langtodelete) . "'";

        dol_syslog(get_only_class($this) . '::delMultiLangs', LOG_DEBUG);
        $result = $this->db->query($sql);
        if ($result) {
            // Call trigger
            $result = $this->call_trigger('PRODUCT_DEL_MULTILANGS', $user);
            if ($result < 0) {
                $this->error = $this->db->lasterror();
                dol_syslog(get_only_class($this) . '::delMultiLangs error=' . $this->error, LOG_ERR);
                return -1;
            }
            // End call triggers
            return 1;
        } else {
            $this->error = $this->db->lasterror();
            dol_syslog(get_only_class($this) . '::delMultiLangs error=' . $this->error, LOG_ERR);
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Sets an accountancy code for a product.
     * Also calls PRODUCT_MODIFY trigger when modified
     *
     * @param string $type It can be 'buy', 'buy_intra', 'buy_export', 'sell', 'sell_intra' or 'sell_export'
     * @param string $value Accountancy code
     * @return  int             Return integer <0 KO >0 OK
     */
    public function setAccountancyCode($type, $value)
    {
        global $user, $langs, $conf;

        $error = 0;

        $this->db->begin();

        if ($type == 'buy') {
            $field = 'accountancy_code_buy';
        } elseif ($type == 'buy_intra') {
            $field = 'accountancy_code_buy_intra';
        } elseif ($type == 'buy_export') {
            $field = 'accountancy_code_buy_export';
        } elseif ($type == 'sell') {
            $field = 'accountancy_code_sell';
        } elseif ($type == 'sell_intra') {
            $field = 'accountancy_code_sell_intra';
        } elseif ($type == 'sell_export') {
            $field = 'accountancy_code_sell_export';
        } else {
            return -1;
        }

        $sql = "UPDATE " . $this->db->prefix() . $this->table_element . " SET ";
        $sql .= "$field = '" . $this->db->escape($value) . "'";
        $sql .= " WHERE rowid = " . ((int)$this->id);

        dol_syslog(__METHOD__, LOG_DEBUG);
        $resql = $this->db->query($sql);

        if ($resql) {
            // Call trigger
            $result = $this->call_trigger('PRODUCT_MODIFY', $user);
            if ($result < 0) {
                $error++;
            }
            // End call triggers

            if ($error) {
                $this->db->rollback();
                return -1;
            }

            $this->$field = $value;

            $this->db->commit();
            return 1;
        } else {
            $this->error = $this->db->lasterror();
            $this->db->rollback();
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Delete a price line
     *
     * @param User $user Object user
     * @param int $rowid Line id to delete
     * @return int                Return integer <0 if KO, >0 if OK
     */
    public function log_price_delete($user, $rowid)
    {
        // phpcs:enable
        $sql = "DELETE FROM " . $this->db->prefix() . "product_price_by_qty";
        $sql .= " WHERE fk_product_price = " . ((int)$rowid);
        $resql = $this->db->query($sql);

        $sql = "DELETE FROM " . $this->db->prefix() . "product_price";
        $sql .= " WHERE rowid=" . ((int)$rowid);
        $resql = $this->db->query($sql);
        if ($resql) {
            return 1;
        } else {
            $this->error = $this->db->lasterror();
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Return price of sell of a product for a seller/buyer/product.
     *
     * @param Societe $thirdparty_seller Seller
     * @param Societe $thirdparty_buyer Buyer
     * @param int $pqp Id of product price per quantity if a selection was done of such a price
     * @return  array                               Array of price information array('pu_ht'=> , 'pu_ttc'=> , 'tva_tx'=>'X.Y (code)', ...), 'tva_npr'=>0, ...)
     * @see get_buyprice(), find_min_price_product_fournisseur()
     */
    public function getSellPrice($thirdparty_seller, $thirdparty_buyer, $pqp = 0)
    {
        global $conf, $hookmanager, $action;

        // Call hook if any
        if (is_object($hookmanager)) {
            $parameters = array('thirdparty_seller' => $thirdparty_seller, 'thirdparty_buyer' => $thirdparty_buyer, 'pqp' => $pqp);
            // Note that $action and $object may have been modified by some hooks
            $reshook = $hookmanager->executeHooks('getSellPrice', $parameters, $this, $action);
            if ($reshook > 0) {
                return $hookmanager->resArray;
            }
        }

        // Update if prices fields are defined
        $tva_tx = get_default_tva($thirdparty_seller, $thirdparty_buyer, $this->id);
        $tva_npr = get_default_npr($thirdparty_seller, $thirdparty_buyer, $this->id);
        if (empty($tva_tx)) {
            $tva_npr = 0;
        }

        $pu_ht = $this->price;
        $pu_ttc = $this->price_ttc;
        $price_min = $this->price_min;
        $price_base_type = $this->price_base_type;

        // If price per segment
        if (getDolGlobalString('PRODUIT_MULTIPRICES') && !empty($thirdparty_buyer->price_level)) {
            $pu_ht = $this->multiprices[$thirdparty_buyer->price_level];
            $pu_ttc = $this->multiprices_ttc[$thirdparty_buyer->price_level];
            $price_min = $this->multiprices_min[$thirdparty_buyer->price_level];
            $price_base_type = $this->multiprices_base_type[$thirdparty_buyer->price_level];
            if (getDolGlobalString('PRODUIT_MULTIPRICES_USE_VAT_PER_LEVEL')) {  // using this option is a bug. kept for backward compatibility
                if (isset($this->multiprices_tva_tx[$thirdparty_buyer->price_level])) {
                    $tva_tx = $this->multiprices_tva_tx[$thirdparty_buyer->price_level];
                }
                if (isset($this->multiprices_recuperableonly[$thirdparty_buyer->price_level])) {
                    $tva_npr = $this->multiprices_recuperableonly[$thirdparty_buyer->price_level];
                }
                if (empty($tva_tx)) {
                    $tva_npr = 0;
                }
            }
        } elseif (getDolGlobalString('PRODUIT_CUSTOMER_PRICES')) {
            // If price per customer
            require_once constant('DOL_DOCUMENT_ROOT') . '/product/class/productcustomerprice.class.php';

            $prodcustprice = new ProductCustomerPrice($this->db);

            $filter = array('t.fk_product' => $this->id, 't.fk_soc' => $thirdparty_buyer->id);

            $result = $prodcustprice->fetchAll('', '', 0, 0, $filter);
            if ($result) {
                if (count($prodcustprice->lines) > 0) {
                    $pu_ht = price($prodcustprice->lines[0]->price);
                    $price_min = price($prodcustprice->lines[0]->price_min);
                    $pu_ttc = price($prodcustprice->lines[0]->price_ttc);
                    $price_base_type = $prodcustprice->lines[0]->price_base_type;
                    $tva_tx = $prodcustprice->lines[0]->tva_tx;
                    if ($prodcustprice->lines[0]->default_vat_code && !preg_match('/\(.*\)/', $tva_tx)) {
                        $tva_tx .= ' (' . $prodcustprice->lines[0]->default_vat_code . ')';
                    }
                    $tva_npr = $prodcustprice->lines[0]->recuperableonly;
                    if (empty($tva_tx)) {
                        $tva_npr = 0;
                    }
                }
            }
        } elseif (getDolGlobalString('PRODUIT_CUSTOMER_PRICES_BY_QTY')) {
            // If price per quantity
            if ($this->prices_by_qty[0]) {
                // yes, this product has some prices per quantity
                // Search price into product_price_by_qty from $this->id
                foreach ($this->prices_by_qty_list[0] as $priceforthequantityarray) {
                    if ($priceforthequantityarray['rowid'] != $pqp) {
                        continue;
                    }
                    // We found the price
                    if ($priceforthequantityarray['price_base_type'] == 'HT') {
                        $pu_ht = $priceforthequantityarray['unitprice'];
                    } else {
                        $pu_ttc = $priceforthequantityarray['unitprice'];
                    }
                    break;
                }
            }
        } elseif (getDolGlobalString('PRODUIT_CUSTOMER_PRICES_BY_QTY_MULTIPRICES')) {
            // If price per quantity and customer
            if ($this->prices_by_qty[$thirdparty_buyer->price_level]) {
                // yes, this product has some prices per quantity
                // Search price into product_price_by_qty from $this->id
                foreach ($this->prices_by_qty_list[$thirdparty_buyer->price_level] as $priceforthequantityarray) {
                    if ($priceforthequantityarray['rowid'] != $pqp) {
                        continue;
                    }
                    // We found the price
                    if ($priceforthequantityarray['price_base_type'] == 'HT') {
                        $pu_ht = $priceforthequantityarray['unitprice'];
                    } else {
                        $pu_ttc = $priceforthequantityarray['unitprice'];
                    }
                    break;
                }
            }
        }

        return array('pu_ht' => $pu_ht, 'pu_ttc' => $pu_ttc, 'price_min' => $price_min, 'price_base_type' => $price_base_type, 'tva_tx' => $tva_tx, 'tva_npr' => $tva_npr);
    }


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Read price used by a provider.
     * We enter as input couple prodfournprice/qty or triplet qty/product_id/fourn_ref.
     * This also set some properties on product like ->buyprice, ->fourn_pu, ...
     *
     * @param int $prodfournprice Id du tarif = rowid table product_fournisseur_price
     * @param double $qty Quantity asked or -1 to get first entry found
     * @param int $product_id Filter on a particular product id
     * @param string $fourn_ref Filter on a supplier price ref. 'none' to exclude ref in search.
     * @param int $fk_soc If of supplier
     * @return int|string             Return integer <-1 if KO, -1 if qty not enough, 0 if OK but nothing found, id_product if OK and found. May also initialize some properties like (->ref_supplier, buyprice, fourn_pu, vatrate_supplier...), or printable result of hook
     * @see getSellPrice(), find_min_price_product_fournisseur()
     */
    public function get_buyprice($prodfournprice, $qty, $product_id = 0, $fourn_ref = '', $fk_soc = 0)
    {
        // phpcs:enable
        global $action, $hookmanager;

        // Call hook if any
        if (is_object($hookmanager)) {
            $parameters = array(
                'prodfournprice' => $prodfournprice,
                'qty' => $qty,
                'product_id' => $product_id,
                'fourn_ref' => $fourn_ref,
                'fk_soc' => $fk_soc,
            );
            // Note that $action and $object may have been modified by some hooks
            $reshook = $hookmanager->executeHooks('getBuyPrice', $parameters, $this, $action);
            if ($reshook > 0) {
                return $hookmanager->resArray;
            }
        }

        $result = 0;

        // We do a first search with a select by searching with couple prodfournprice and qty only (later we will search on triplet qty/product_id/fourn_ref)
        $sql = "SELECT pfp.rowid, pfp.price as price, pfp.quantity as quantity, pfp.remise_percent, pfp.fk_soc,";
        $sql .= " pfp.fk_product, pfp.ref_fourn as ref_supplier, pfp.desc_fourn as desc_supplier, pfp.tva_tx, pfp.default_vat_code, pfp.fk_supplier_price_expression,";
        $sql .= " pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code,";
        $sql .= " pfp.packaging";
        $sql .= " FROM " . $this->db->prefix() . "product_fournisseur_price as pfp";
        $sql .= " WHERE pfp.rowid = " . ((int)$prodfournprice);
        if ($qty > 0) {
            $sql .= " AND pfp.quantity <= " . ((float)$qty);
        }
        $sql .= " ORDER BY pfp.quantity DESC";

        dol_syslog(get_only_class($this) . "::get_buyprice first search by prodfournprice/qty", LOG_DEBUG);
        $resql = $this->db->query($sql);
        if ($resql) {
            $obj = $this->db->fetch_object($resql);
            if ($obj && $obj->quantity > 0) {        // If we found a supplier prices from the id of supplier price
                if (isModEnabled('dynamicprices') && !empty($obj->fk_supplier_price_expression)) {
                    $prod_supplier = new ProductFournisseur($this->db);
                    $prod_supplier->product_fourn_price_id = $obj->rowid;
                    $prod_supplier->id = $obj->fk_product;
                    $prod_supplier->fourn_qty = $obj->quantity;
                    $prod_supplier->fourn_tva_tx = $obj->tva_tx;
                    $prod_supplier->fk_supplier_price_expression = $obj->fk_supplier_price_expression;

                    include_once DOL_DOCUMENT_ROOT . '/product/dynamic_price/class/price_parser.class.php';
                    $priceparser = new PriceParser($this->db);
                    $price_result = $priceparser->parseProductSupplier($prod_supplier);
                    if ($price_result >= 0) {
                        $obj->price = $price_result;
                    }
                }
                $this->product_fourn_price_id = $obj->rowid;
                $this->buyprice = $obj->price; // deprecated
                $this->fourn_pu = $obj->price / $obj->quantity; // Unit price of product of supplier
                $this->fourn_price_base_type = 'HT'; // Price base type
                $this->fourn_socid = $obj->fk_soc; // Company that offer this price
                $this->ref_fourn = $obj->ref_supplier; // deprecated
                $this->ref_supplier = $obj->ref_supplier; // Ref supplier
                $this->desc_supplier = $obj->desc_supplier; // desc supplier
                $this->remise_percent = $obj->remise_percent; // remise percent if present and not typed
                $this->vatrate_supplier = $obj->tva_tx; // Vat ref supplier
                $this->default_vat_code_supplier = $obj->default_vat_code; // Vat code supplier
                $this->fourn_multicurrency_price = $obj->multicurrency_price;
                $this->fourn_multicurrency_unitprice = $obj->multicurrency_unitprice;
                $this->fourn_multicurrency_tx = $obj->multicurrency_tx;
                $this->fourn_multicurrency_id = $obj->fk_multicurrency;
                $this->fourn_multicurrency_code = $obj->multicurrency_code;
                if (getDolGlobalString('PRODUCT_USE_SUPPLIER_PACKAGING')) {
                    $this->packaging = $obj->packaging;
                }
                $result = $obj->fk_product;
                return $result;
            } else { // If not found
                // We do a second search by doing a select again but searching with less reliable criteria: couple qty/id product, and if set fourn_ref or fk_soc.
                $sql = "SELECT pfp.rowid, pfp.price as price, pfp.quantity as quantity, pfp.remise_percent, pfp.fk_soc,";
                $sql .= " pfp.fk_product, pfp.ref_fourn as ref_supplier, pfp.desc_fourn as desc_supplier, pfp.tva_tx, pfp.default_vat_code, pfp.fk_supplier_price_expression,";
                $sql .= " pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code,";
                $sql .= " pfp.packaging";
                $sql .= " FROM " . $this->db->prefix() . "product_fournisseur_price as pfp";
                $sql .= " WHERE 1 = 1";
                if ($product_id > 0) {
                    $sql .= " AND pfp.fk_product = " . ((int)$product_id);
                }
                if ($fourn_ref != 'none') {
                    $sql .= " AND pfp.ref_fourn = '" . $this->db->escape($fourn_ref) . "'";
                }
                if ($fk_soc > 0) {
                    $sql .= " AND pfp.fk_soc = " . ((int)$fk_soc);
                }
                if ($qty > 0) {
                    $sql .= " AND pfp.quantity <= " . ((float)$qty);
                }
                $sql .= " ORDER BY pfp.quantity DESC";
                $sql .= " LIMIT 1";

                dol_syslog(get_only_class($this) . "::get_buyprice second search from qty/ref/product_id", LOG_DEBUG);
                $resql = $this->db->query($sql);
                if ($resql) {
                    $obj = $this->db->fetch_object($resql);
                    if ($obj && $obj->quantity > 0) {        // If found
                        if (isModEnabled('dynamicprices') && !empty($obj->fk_supplier_price_expression)) {
                            $prod_supplier = new ProductFournisseur($this->db);
                            $prod_supplier->product_fourn_price_id = $obj->rowid;
                            $prod_supplier->id = $obj->fk_product;
                            $prod_supplier->fourn_qty = $obj->quantity;
                            $prod_supplier->fourn_tva_tx = $obj->tva_tx;
                            $prod_supplier->fk_supplier_price_expression = $obj->fk_supplier_price_expression;

                            include_once DOL_DOCUMENT_ROOT . '/product/dynamic_price/class/price_parser.class.php';
                            $priceparser = new PriceParser($this->db);
                            $price_result = $priceparser->parseProductSupplier($prod_supplier);
                            if ($result >= 0) {
                                $obj->price = $price_result;
                            }
                        }
                        $this->product_fourn_price_id = $obj->rowid;
                        $this->buyprice = $obj->price; // deprecated
                        $this->fourn_qty = $obj->quantity; // min quantity for price for a virtual supplier
                        $this->fourn_pu = $obj->price / $obj->quantity; // Unit price of product for a virtual supplier
                        $this->fourn_price_base_type = 'HT'; // Price base type for a virtual supplier
                        $this->fourn_socid = $obj->fk_soc; // Company that offer this price
                        $this->ref_fourn = $obj->ref_supplier; // deprecated
                        $this->ref_supplier = $obj->ref_supplier; // Ref supplier
                        $this->desc_supplier = $obj->desc_supplier; // desc supplier
                        $this->remise_percent = $obj->remise_percent; // remise percent if present and not typed
                        $this->vatrate_supplier = $obj->tva_tx; // Vat ref supplier
                        $this->default_vat_code_supplier = $obj->default_vat_code; // Vat code supplier
                        $this->fourn_multicurrency_price = $obj->multicurrency_price;
                        $this->fourn_multicurrency_unitprice = $obj->multicurrency_unitprice;
                        $this->fourn_multicurrency_tx = $obj->multicurrency_tx;
                        $this->fourn_multicurrency_id = $obj->fk_multicurrency;
                        $this->fourn_multicurrency_code = $obj->multicurrency_code;
                        if (getDolGlobalString('PRODUCT_USE_SUPPLIER_PACKAGING')) {
                            $this->packaging = $obj->packaging;
                        }
                        $result = $obj->fk_product;
                        return $result;
                    } else {
                        return -1; // Ce produit n'existe pas avec cet id tarif fournisseur ou existe mais qte insuffisante, ni pour le couple produit/ref fournisseur dans la quantité.
                    }
                } else {
                    $this->error = $this->db->lasterror();
                    return -3;
                }
            }
        } else {
            $this->error = $this->db->lasterror();
            return -2;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Modify customer price of a product/Service for a given level
     *
     * @param double $newprice New price
     * @param string $newpricebase HT or TTC
     * @param User $user Object user that make change
     * @param  ?double $newvat New VAT Rate (For example 8.5. Should not be a string)
     * @param double $newminprice New price min
     * @param int $level 0=standard, >0 = level if multilevel prices
     * @param int $newnpr 0=Standard vat rate, 1=Special vat rate for French NPR VAT
     * @param int $newpbq 1 if it has price by quantity
     * @param int $ignore_autogen Used to avoid infinite loops
     * @param array $localtaxes_array Array with localtaxes info array('0'=>type1,'1'=>rate1,'2'=>type2,'3'=>rate2) (loaded by getLocalTaxesFromRate(vatrate, 0, ...) function).
     * @param string $newdefaultvatcode Default vat code
     * @param string $price_label Price Label
     * @param int $notrigger Disable triggers
     * @return int                            Return integer <0 if KO, >0 if OK
     */
    public function updatePrice($newprice, $newpricebase, $user, $newvat = null, $newminprice = 0, $level = 0, $newnpr = 0, $newpbq = 0, $ignore_autogen = 0, $localtaxes_array = array(), $newdefaultvatcode = '', $price_label = '', $notrigger = 0)
    {
        global $conf, $langs;

        $lastPriceData = $this->getArrayForPriceCompare($level); // temporary store current price before update

        $id = $this->id;

        dol_syslog(get_only_class($this) . "::update_price id=" . $id . " newprice=" . $newprice . " newpricebase=" . $newpricebase . " newminprice=" . $newminprice . " level=" . $level . " npr=" . $newnpr . " newdefaultvatcode=" . $newdefaultvatcode);

        // Clean parameters
        if (empty($this->tva_tx)) {
            $this->tva_tx = 0;
        }
        if (empty($newnpr)) {
            $newnpr = 0;
        }
        if (empty($newminprice)) {
            $newminprice = 0;
        }

        // Check parameters
        if ($newvat === null || $newvat == '') {  // Maintain '' for backwards compatibility
            $newvat = $this->tva_tx;
        }

        // If multiprices are enabled, then we check if the current product is subject to price autogeneration
        // Price will be modified ONLY when the first one is the one that is being modified
        if ((getDolGlobalString('PRODUIT_MULTIPRICES') || getDolGlobalString('PRODUIT_CUSTOMER_PRICES_BY_QTY_MULTIPRICES')) && !$ignore_autogen && $this->price_autogen && ($level == 1)) {
            return $this->generateMultiprices($user, $newprice, $newpricebase, $newvat, $newnpr, $newpbq);
        }

        if (!empty($newminprice) && ($newminprice > $newprice)) {
            $this->error = 'ErrorPriceCantBeLowerThanMinPrice';
            return -1;
        }

        if ($newprice !== '' || $newprice === 0) {
            if ($newpricebase == 'TTC') {
                $price_ttc = price2num($newprice, 'MU');
                $price = (float)price2num($newprice) / (1 + ((float)$newvat / 100));
                $price = price2num($price, 'MU');

                if ($newminprice != '' || $newminprice == 0) {
                    $price_min_ttc = price2num($newminprice, 'MU');
                    $price_min = (float)price2num($newminprice) / (1 + ($newvat / 100));
                    $price_min = price2num($price_min, 'MU');
                } else {
                    $price_min = 0;
                    $price_min_ttc = 0;
                }
            } else {
                $price = (float)price2num($newprice, 'MU');
                $price_ttc = ($newnpr != 1) ? price2num($newprice) * (1 + ($newvat / 100)) : $price;
                $price_ttc = (float)price2num($price_ttc, 'MU');

                if ($newminprice !== '' || $newminprice === 0) {
                    $price_min = price2num($newminprice, 'MU');
                    $price_min_ttc = (float)price2num($newminprice) * (1 + ($newvat / 100));
                    $price_min_ttc = price2num($price_min_ttc, 'MU');
                    //print 'X'.$newminprice.'-'.$price_min;
                } else {
                    $price_min = 0;
                    $price_min_ttc = 0;
                }
            }
            //print 'x'.$id.'-'.$newprice.'-'.$newpricebase.'-'.$price.'-'.$price_ttc.'-'.$price_min.'-'.$price_min_ttc;

            if (count($localtaxes_array) > 0) {
                $localtaxtype1 = $localtaxes_array['0'];
                $localtax1 = $localtaxes_array['1'];
                $localtaxtype2 = $localtaxes_array['2'];
                $localtax2 = $localtaxes_array['3'];
            } else {
                // if array empty, we try to use the vat code
                if (!empty($newdefaultvatcode)) {
                    global $mysoc;
                    // Get record from code
                    $sql = "SELECT t.rowid, t.code, t.recuperableonly as tva_npr, t.localtax1, t.localtax2, t.localtax1_type, t.localtax2_type";
                    $sql .= " FROM " . MAIN_DB_PREFIX . "c_tva as t, " . MAIN_DB_PREFIX . "c_country as c";
                    $sql .= " WHERE t.fk_pays = c.rowid AND c.code = '" . $this->db->escape($mysoc->country_code) . "'";
                    $sql .= " AND t.taux = " . ((float)$newdefaultvatcode) . " AND t.active = 1";
                    $sql .= " AND t.code = '" . $this->db->escape($newdefaultvatcode) . "'";
                    $resql = $this->db->query($sql);
                    if ($resql) {
                        $obj = $this->db->fetch_object($resql);
                        if ($obj) {
                            $npr = $obj->tva_npr;
                            $localtax1 = $obj->localtax1;
                            $localtax2 = $obj->localtax2;
                            $localtaxtype1 = $obj->localtax1_type;
                            $localtaxtype2 = $obj->localtax2_type;
                        }
                    }
                } else {
                    // old method. deprecated because we can't retrieve type
                    $localtaxtype1 = '0';
                    $localtax1 = get_localtax($newvat, 1);
                    $localtaxtype2 = '0';
                    $localtax2 = get_localtax($newvat, 2);
                }
            }
            if (empty($localtax1)) {
                $localtax1 = 0; // If = '' then = 0
            }
            if (empty($localtax2)) {
                $localtax2 = 0; // If = '' then = 0
            }

            $this->db->begin();

            // Ne pas mettre de quote sur les numeriques decimaux.
            // Ceci provoque des stockages avec arrondis en base au lieu des valeurs exactes.
            $sql = "UPDATE " . $this->db->prefix() . "product SET";
            $sql .= " price_base_type = '" . $this->db->escape($newpricebase) . "',";
            $sql .= " price = " . (float)$price . ",";
            $sql .= " price_ttc = " . (float)$price_ttc . ",";
            $sql .= " price_min = " . (float)$price_min . ",";
            $sql .= " price_min_ttc = " . (float)$price_min_ttc . ",";
            $sql .= " localtax1_tx = " . ($localtax1 >= 0 ? (float)$localtax1 : 'NULL') . ",";
            $sql .= " localtax2_tx = " . ($localtax2 >= 0 ? (float)$localtax2 : 'NULL') . ",";
            $sql .= " localtax1_type = " . ($localtaxtype1 != '' ? "'" . $this->db->escape($localtaxtype1) . "'" : "'0'") . ",";
            $sql .= " localtax2_type = " . ($localtaxtype2 != '' ? "'" . $this->db->escape($localtaxtype2) . "'" : "'0'") . ",";
            $sql .= " default_vat_code = " . ($newdefaultvatcode ? "'" . $this->db->escape($newdefaultvatcode) . "'" : "null") . ",";
            $sql .= " price_label = " . (!empty($price_label) ? "'" . $this->db->escape($price_label) . "'" : "null") . ",";
            $sql .= " tva_tx = " . (float)price2num($newvat) . ",";
            $sql .= " recuperableonly = '" . $this->db->escape($newnpr) . "'";
            $sql .= " WHERE rowid = " . ((int)$id);

            dol_syslog(get_only_class($this) . "::update_price", LOG_DEBUG);
            $resql = $this->db->query($sql);
            if ($resql) {
                $this->multiprices[$level] = $price;
                $this->multiprices_ttc[$level] = $price_ttc;
                $this->multiprices_min[$level] = $price_min;
                $this->multiprices_min_ttc[$level] = $price_min_ttc;
                $this->multiprices_base_type[$level] = $newpricebase;
                $this->multiprices_default_vat_code[$level] = $newdefaultvatcode;
                $this->multiprices_tva_tx[$level] = $newvat;
                $this->multiprices_recuperableonly[$level] = $newnpr;

                $this->price = $price;
class Id
{
    public $id;

    public function __construct($id)
    {
        $this->id = $id;
    }

}

class Account
{
    /** @var  Id $id */
    public $id;
}

$account_id = false;

if (starsAreRight()) {
    $account_id = new Id(42);
}

$account = new Account();
if ($account instanceof Id)
{
    $account->id = $account_id;
}
                $this->price_label = $price_label;
                $this->price_ttc = $price_ttc;
class Id
{
    public $id;

    public function __construct($id)
    {
        $this->id = $id;
    }

}

class Account
{
    /** @var  Id $id */
    public $id;
}

$account_id = false;

if (starsAreRight()) {
    $account_id = new Id(42);
}

$account = new Account();
if ($account instanceof Id)
{
    $account->id = $account_id;
}
                $this->price_min = $price_min;
class Id
{
    public $id;

    public function __construct($id)
    {
        $this->id = $id;
    }

}

class Account
{
    /** @var  Id $id */
    public $id;
}

$account_id = false;

if (starsAreRight()) {
    $account_id = new Id(42);
}

$account = new Account();
if ($account instanceof Id)
{
    $account->id = $account_id;
}
                $this->price_min_ttc = $price_min_ttc;
class Id
{
    public $id;

    public function __construct($id)
    {
        $this->id = $id;
    }

}

class Account
{
    /** @var  Id $id */
    public $id;
}

$account_id = false;

if (starsAreRight()) {
    $account_id = new Id(42);
}

$account = new Account();
if ($account instanceof Id)
{
    $account->id = $account_id;
}
                $this->price_base_type = $newpricebase;
                $this->default_vat_code = $newdefaultvatcode;
                $this->tva_tx = $newvat;
                $this->tva_npr = $newnpr;

                //Local taxes
                $this->localtax1_tx = $localtax1;
                $this->localtax2_tx = $localtax2;
                $this->localtax1_type = $localtaxtype1;
                $this->localtax2_type = $localtaxtype2;

                // Price by quantity
                $this->price_by_qty = $newpbq;

                // check if price have really change before log
                $newPriceData = $this->getArrayForPriceCompare($level);
                if (!empty(array_diff_assoc($newPriceData, $lastPriceData)) || !getDolGlobalString('PRODUIT_MULTIPRICES')) {
                    $this->_log_price($user, $level); // Save price for level into table product_price
                }

                $this->level = $level; // Store level of price edited for trigger

                // Call trigger
                if (!$notrigger) {
                    $result = $this->call_trigger('PRODUCT_PRICE_MODIFY', $user);
                    if ($result < 0) {
                        $this->db->rollback();
                        return -1;
                    }
                }
                // End call triggers

                $this->db->commit();
            } else {
                $this->db->rollback();
                $this->error = $this->db->lasterror();
                return -1;
            }
        }

        return 1;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  used to check if price have really change to avoid log pollution
     *
     * @param int $level price level to change
     * @return array
     */
    private function getArrayForPriceCompare($level = 0)
    {
        $testExit = array('multiprices', 'multiprices_ttc', 'multiprices_base_type', 'multiprices_min', 'multiprices_min_ttc', 'multiprices_tva_tx', 'multiprices_recuperableonly');

        foreach ($testExit as $field) {
            if (!isset($this->$field)) {
                return array();
            }
            $tmparray = $this->$field;
            if (!isset($tmparray[$level])) {
                return array();
            }
        }

        $lastPrice = array(
            'level' => $level ? $level : 1,
            'multiprices' => (float)$this->multiprices[$level],
            'multiprices_ttc' => (float)$this->multiprices_ttc[$level],
            'multiprices_base_type' => $this->multiprices_base_type[$level],
            'multiprices_min' => (float)$this->multiprices_min[$level],
            'multiprices_min_ttc' => (float)$this->multiprices_min_ttc[$level],
            'multiprices_tva_tx' => (float)$this->multiprices_tva_tx[$level],
            'multiprices_recuperableonly' => (float)$this->multiprices_recuperableonly[$level],
        );

        return $lastPrice;
    }


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Generates prices for a product based on product multiprice generation rules
     *
     * @param User $user User that updates the prices
     * @param float $baseprice Base price
     * @param string $price_type Base price type
     * @param float $price_vat VAT % tax
     * @param int $npr NPR
     * @param string $psq ¿?
     * @return int -1 KO, 1 OK
     */
    public function generateMultiprices(User $user, $baseprice, $price_type, $price_vat, $npr, $psq)
    {
        global $conf;

        $sql = "SELECT rowid, level, fk_level, var_percent, var_min_percent FROM " . $this->db->prefix() . "product_pricerules";
        $query = $this->db->query($sql);

        $rules = array();

        while ($result = $this->db->fetch_object($query)) {
            $rules[$result->level] = $result;
        }

        //Because prices can be based on other level's prices, we temporarily store them
        $prices = array(
            1 => $baseprice
        );

        $nbofproducts = getDolGlobalInt('PRODUIT_MULTIPRICES_LIMIT');
        for ($i = 1; $i <= $nbofproducts; $i++) {
            $price = $baseprice;
            $price_min = $baseprice;

            //We have to make sure it does exist and it is > 0
            //First price level only allows changing min_price
            if ($i > 1 && isset($rules[$i]->var_percent) && $rules[$i]->var_percent) {
                $price = $prices[$rules[$i]->fk_level] * (1 + ($rules[$i]->var_percent / 100));
            }

            $prices[$i] = $price;

            //We have to make sure it does exist and it is > 0
            if (isset($rules[$i]->var_min_percent) && $rules[$i]->var_min_percent) {
                $price_min = $price * (1 - ($rules[$i]->var_min_percent / 100));
            }

            //Little check to make sure the price is modified before triggering generation
            $check_amount = (($price == $this->multiprices[$i]) && ($price_min == $this->multiprices_min[$i]));
            $check_type = ($baseprice == $this->multiprices_base_type[$i]);

            if ($check_amount && $check_type) {
                continue;
            }

            if ($this->updatePrice($price, $price_type, $user, $price_vat, $price_min, $i, $npr, $psq, true) < 0) {
                return -1;
            }
        }

        return 1;
    }


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Sets the supplier price expression
     *
     * @param int $expression_id Expression
     * @return     int                     Return integer <0 if KO, >0 if OK
     * @deprecated Use Product::update instead
     */
    public function setPriceExpression($expression_id)
    {
        global $user;

        $this->fk_price_expression = $expression_id;

        return $this->update($this->id, $user);
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Charge tableau des stats OF pour le produit/service
     *
     * @param int $socid Id societe
     * @return int                     Array of stats in $this->stats_mo, <0 if ko or >0 if ok
     */
    public function load_stats_mo($socid = 0)
    {
        // phpcs:enable
        global $user, $hookmanager, $action;

        $error = 0;

        foreach (array('toconsume', 'consumed', 'toproduce', 'produced') as $role) {
            $this->stats_mo['customers_' . $role] = 0;
            $this->stats_mo['nb_' . $role] = 0;
            $this->stats_mo['qty_' . $role] = 0;

            $sql = "SELECT COUNT(DISTINCT c.fk_soc) as nb_customers, COUNT(DISTINCT c.rowid) as nb,";
            $sql .= " SUM(mp.qty) as qty";
            $sql .= " FROM " . $this->db->prefix() . "mrp_mo as c";
            $sql .= " INNER JOIN " . $this->db->prefix() . "mrp_production as mp ON mp.fk_mo=c.rowid";
            if (!$user->hasRight('societe', 'client', 'voir')) {
                $sql .= " INNER JOIN " . $this->db->prefix() . "societe_commerciaux as sc ON sc.fk_soc=c.fk_soc AND sc.fk_user = " . ((int)$user->id);
            }
            $sql .= " WHERE ";
            $sql .= " c.entity IN (" . getEntity('mo') . ")";

            $sql .= " AND mp.fk_product = " . ((int)$this->id);
            $sql .= " AND mp.role ='" . $this->db->escape($role) . "'";
            if ($socid > 0) {
                $sql .= " AND c.fk_soc = " . ((int)$socid);
            }

            $result = $this->db->query($sql);
            if ($result) {
                $obj = $this->db->fetch_object($result);
                $this->stats_mo['customers_' . $role] = $obj->nb_customers ? $obj->nb_customers : 0;
                $this->stats_mo['nb_' . $role] = $obj->nb ? $obj->nb : 0;
                $this->stats_mo['qty_' . $role] = $obj->qty ? price2num($obj->qty, 'MS') : 0;     // qty may be a float due to the SUM()
            } else {
                $this->error = $this->db->error();
                $error++;
            }
        }

        if (!empty($error)) {
            return -1;
        }

        $parameters = array('socid' => $socid);
        $reshook = $hookmanager->executeHooks('loadStatsCustomerMO', $parameters, $this, $action);
        if ($reshook > 0) {
            $this->stats_mo = $hookmanager->resArray['stats_mo'];
        }

        return 1;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Charge tableau des stats OF pour le produit/service
     *
     * @param int $socid Id societe
     * @return int        Array of stats in $this->stats_bom, <0 if ko or >0 if ok
     */
    public function load_stats_bom($socid = 0)
    {
        // phpcs:enable
        global $user, $hookmanager, $action;

        $error = 0;

        $this->stats_bom['nb_toproduce'] = 0;
        $this->stats_bom['nb_toconsume'] = 0;
        $this->stats_bom['qty_toproduce'] = 0;
        $this->stats_bom['qty_toconsume'] = 0;

        $sql = "SELECT COUNT(DISTINCT b.rowid) as nb_toproduce,";
        $sql .= " SUM(b.qty) as qty_toproduce";
        $sql .= " FROM " . $this->db->prefix() . "bom_bom as b";
        $sql .= " INNER JOIN " . $this->db->prefix() . "bom_bomline as bl ON bl.fk_bom=b.rowid";
        $sql .= " WHERE ";
        $sql .= " b.entity IN (" . getEntity('bom') . ")";
        $sql .= " AND b.fk_product =" . ((int)$this->id);
        $sql .= " GROUP BY b.rowid";

        $result = $this->db->query($sql);
        if ($result) {
            $obj = $this->db->fetch_object($result);
            $this->stats_bom['nb_toproduce'] = !empty($obj->nb_toproduce) ? $obj->nb_toproduce : 0;
            $this->stats_bom['qty_toproduce'] = !empty($obj->qty_toproduce) ? price2num($obj->qty_toproduce) : 0;
        } else {
            $this->error = $this->db->error();
            $error++;
        }

        $sql = "SELECT COUNT(DISTINCT bl.rowid) as nb_toconsume,";
        $sql .= " SUM(bl.qty) as qty_toconsume";
        $sql .= " FROM " . $this->db->prefix() . "bom_bom as b";
        $sql .= " INNER JOIN " . $this->db->prefix() . "bom_bomline as bl ON bl.fk_bom=b.rowid";
        $sql .= " WHERE ";
        $sql .= " b.entity IN (" . getEntity('bom') . ")";
        $sql .= " AND bl.fk_product =" . ((int)$this->id);

        $result = $this->db->query($sql);
        if ($result) {
            $obj = $this->db->fetch_object($result);
            $this->stats_bom['nb_toconsume'] = !empty($obj->nb_toconsume) ? $obj->nb_toconsume : 0;
            $this->stats_bom['qty_toconsume'] = !empty($obj->qty_toconsume) ? price2num($obj->qty_toconsume) : 0;
        } else {
            $this->error = $this->db->error();
            $error++;
        }

        if (!empty($error)) {
            return -1;
        }

        $parameters = array('socid' => $socid);
        $reshook = $hookmanager->executeHooks('loadStatsCustomerMO', $parameters, $this, $action);
        if ($reshook > 0) {
            $this->stats_bom = $hookmanager->resArray['stats_bom'];
        }

        return 1;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Charge tableau des stats propale pour le produit/service
     *
     * @param int $socid Id societe
     * @return int        Array of stats in $this->stats_propale, <0 if ko or >0 if ok
     */
    public function load_stats_propale($socid = 0)
    {
        // phpcs:enable
        global $conf, $user, $hookmanager, $action;

        $sql = "SELECT COUNT(DISTINCT p.fk_soc) as nb_customers, COUNT(DISTINCT p.rowid) as nb,";
        $sql .= " COUNT(pd.rowid) as nb_rows, SUM(pd.qty) as qty";
        $sql .= " FROM " . $this->db->prefix() . "propaldet as pd";
        $sql .= ", " . $this->db->prefix() . "propal as p";
        $sql .= ", " . $this->db->prefix() . "societe as s";
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE p.rowid = pd.fk_propal";
        $sql .= " AND p.fk_soc = s.rowid";
        $sql .= " AND p.entity IN (" . getEntity('propal') . ")";
        $sql .= " AND pd.fk_product = " . ((int)$this->id);
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND p.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        //$sql.= " AND pr.fk_statut != 0";
        if ($socid > 0) {
            $sql .= " AND p.fk_soc = " . ((int)$socid);
        }

        $result = $this->db->query($sql);
        if ($result) {
            $obj = $this->db->fetch_object($result);
            $this->stats_propale['customers'] = $obj->nb_customers;
            $this->stats_propale['nb'] = $obj->nb;
            $this->stats_propale['rows'] = $obj->nb_rows;
            $this->stats_propale['qty'] = $obj->qty ? $obj->qty : 0;

            // if it's a virtual product, maybe it is in proposal by extension
            if (getDolGlobalString('PRODUCT_STATS_WITH_PARENT_PROD_IF_INCDEC')) {
                $TFather = $this->getFather();
                if (is_array($TFather) && !empty($TFather)) {
                    foreach ($TFather as &$fatherData) {
                        $pFather = new Product($this->db);
                        $pFather->id = $fatherData['id'];
                        $qtyCoef = $fatherData['qty'];

                        if ($fatherData['incdec']) {
                            $pFather->load_stats_propale($socid);

                            $this->stats_propale['customers'] += $pFather->stats_propale['customers'];
                            $this->stats_propale['nb'] += $pFather->stats_propale['nb'];
                            $this->stats_propale['rows'] += $pFather->stats_propale['rows'];
                            $this->stats_propale['qty'] += $pFather->stats_propale['qty'] * $qtyCoef;
                        }
                    }
                }
            }

            $parameters = array('socid' => $socid);
            $reshook = $hookmanager->executeHooks('loadStatsCustomerProposal', $parameters, $this, $action);
            if ($reshook > 0) {
                $this->stats_propale = $hookmanager->resArray['stats_propale'];
            }

            return 1;
        } else {
            $this->error = $this->db->error();
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Charge tableau des stats propale pour le produit/service
     *
     * @param int $socid Id thirdparty
     * @return int        Array of stats in $this->stats_proposal_supplier, <0 if ko or >0 if ok
     */
    public function load_stats_proposal_supplier($socid = 0)
    {
        // phpcs:enable
        global $conf, $user, $hookmanager, $action;

        $sql = "SELECT COUNT(DISTINCT p.fk_soc) as nb_suppliers, COUNT(DISTINCT p.rowid) as nb,";
        $sql .= " COUNT(pd.rowid) as nb_rows, SUM(pd.qty) as qty";
        $sql .= " FROM " . $this->db->prefix() . "supplier_proposaldet as pd";
        $sql .= ", " . $this->db->prefix() . "supplier_proposal as p";
        $sql .= ", " . $this->db->prefix() . "societe as s";
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE p.rowid = pd.fk_supplier_proposal";
        $sql .= " AND p.fk_soc = s.rowid";
        $sql .= " AND p.entity IN (" . getEntity('supplier_proposal') . ")";
        $sql .= " AND pd.fk_product = " . ((int)$this->id);
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND p.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        //$sql.= " AND pr.fk_statut != 0";
        if ($socid > 0) {
            $sql .= " AND p.fk_soc = " . ((int)$socid);
        }

        $result = $this->db->query($sql);
        if ($result) {
            $obj = $this->db->fetch_object($result);
            $this->stats_proposal_supplier['suppliers'] = $obj->nb_suppliers;
            $this->stats_proposal_supplier['nb'] = $obj->nb;
            $this->stats_proposal_supplier['rows'] = $obj->nb_rows;
            $this->stats_proposal_supplier['qty'] = $obj->qty ? $obj->qty : 0;

            $parameters = array('socid' => $socid);
            $reshook = $hookmanager->executeHooks('loadStatsSupplierProposal', $parameters, $this, $action);
            if ($reshook > 0) {
                $this->stats_proposal_supplier = $hookmanager->resArray['stats_proposal_supplier'];
            }

            return 1;
        } else {
            $this->error = $this->db->error();
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Charge tableau des stats contrat pour le produit/service
     *
     * @param int $socid Id societe
     * @return int                     Array of stats in $this->stats_contrat, <0 if ko or >0 if ok
     */
    public function load_stats_contrat($socid = 0)
    {
        // phpcs:enable
        global $conf, $user, $hookmanager, $action;

        $sql = "SELECT COUNT(DISTINCT c.fk_soc) as nb_customers, COUNT(DISTINCT c.rowid) as nb,";
        $sql .= " COUNT(cd.rowid) as nb_rows, SUM(cd.qty) as qty";
        $sql .= " FROM " . $this->db->prefix() . "contratdet as cd";
        $sql .= ", " . $this->db->prefix() . "contrat as c";
        $sql .= ", " . $this->db->prefix() . "societe as s";
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE c.rowid = cd.fk_contrat";
        $sql .= " AND c.fk_soc = s.rowid";
        $sql .= " AND c.entity IN (" . getEntity('contract') . ")";
        $sql .= " AND cd.fk_product = " . ((int)$this->id);
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        //$sql.= " AND c.statut != 0";
        if ($socid > 0) {
            $sql .= " AND c.fk_soc = " . ((int)$socid);
        }

        $result = $this->db->query($sql);
        if ($result) {
            $obj = $this->db->fetch_object($result);
            $this->stats_contrat['customers'] = $obj->nb_customers;
            $this->stats_contrat['nb'] = $obj->nb;
            $this->stats_contrat['rows'] = $obj->nb_rows;
            $this->stats_contrat['qty'] = $obj->qty ? $obj->qty : 0;

            // if it's a virtual product, maybe it is in contract by extension
            if (getDolGlobalString('PRODUCT_STATS_WITH_PARENT_PROD_IF_INCDEC')) {
                $TFather = $this->getFather();
                if (is_array($TFather) && !empty($TFather)) {
                    foreach ($TFather as &$fatherData) {
                        $pFather = new Product($this->db);
                        $pFather->id = $fatherData['id'];
                        $qtyCoef = $fatherData['qty'];

                        if ($fatherData['incdec']) {
                            $pFather->load_stats_contrat($socid);

                            $this->stats_contrat['customers'] += $pFather->stats_contrat['customers'];
                            $this->stats_contrat['nb'] += $pFather->stats_contrat['nb'];
                            $this->stats_contrat['rows'] += $pFather->stats_contrat['rows'];
                            $this->stats_contrat['qty'] += $pFather->stats_contrat['qty'] * $qtyCoef;
                        }
                    }
                }
            }

            $parameters = array('socid' => $socid);
            $reshook = $hookmanager->executeHooks('loadStatsContract', $parameters, $this, $action);
            if ($reshook > 0) {
                $this->stats_contrat = $hookmanager->resArray['stats_contrat'];
            }

            return 1;
        } else {
            $this->error = $this->db->error() . ' sql=' . $sql;
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Charge tableau des stats facture recurrentes pour le produit/service
     *
     * @param int $socid Id societe
     * @return int                     Array of stats in $this->stats_facture, <0 if ko or >0 if ok
     */
    public function load_stats_facturerec($socid = 0)
    {
        // phpcs:enable
        global $conf, $user, $hookmanager, $action;

        $sql = "SELECT COUNT(DISTINCT f.fk_soc) as nb_customers, COUNT(DISTINCT f.rowid) as nb,";
        $sql .= " COUNT(fd.rowid) as nb_rows, SUM(fd.qty) as qty";
        $sql .= " FROM " . MAIN_DB_PREFIX . "facturedet_rec as fd";
        $sql .= ", " . MAIN_DB_PREFIX . "facture_rec as f";
        $sql .= ", " . MAIN_DB_PREFIX . "societe as s";
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . MAIN_DB_PREFIX . "societe_commerciaux as sc";
        }
        $sql .= " WHERE f.rowid = fd.fk_facture";
        $sql .= " AND f.fk_soc = s.rowid";
        $sql .= " AND f.entity IN (" . getEntity('invoice') . ")";
        $sql .= " AND fd.fk_product = " . ((int)$this->id);
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        //$sql.= " AND f.fk_statut != 0";
        if ($socid > 0) {
            $sql .= " AND f.fk_soc = " . ((int)$socid);
        }

        $result = $this->db->query($sql);
        if ($result) {
            $obj = $this->db->fetch_object($result);
            $this->stats_facturerec['customers'] = $obj->nb_customers;
            $this->stats_facturerec['nb'] = $obj->nb;
            $this->stats_facturerec['rows'] = $obj->nb_rows;
            $this->stats_facturerec['qty'] = $obj->qty ? $obj->qty : 0;

            // if it's a virtual product, maybe it is in invoice by extension
            if (getDolGlobalString('PRODUCT_STATS_WITH_PARENT_PROD_IF_INCDEC')) {
                $TFather = $this->getFather();
                if (is_array($TFather) && !empty($TFather)) {
                    foreach ($TFather as &$fatherData) {
                        $pFather = new Product($this->db);
                        $pFather->id = $fatherData['id'];
                        $qtyCoef = $fatherData['qty'];

                        if ($fatherData['incdec']) {
                            $pFather->load_stats_facture($socid);

                            $this->stats_facturerec['customers'] += $pFather->stats_facturerec['customers'];
                            $this->stats_facturerec['nb'] += $pFather->stats_facturerec['nb'];
                            $this->stats_facturerec['rows'] += $pFather->stats_facturerec['rows'];
                            $this->stats_facturerec['qty'] += $pFather->stats_facturerec['qty'] * $qtyCoef;
                        }
                    }
                }
            }

            $parameters = array('socid' => $socid);
            $reshook = $hookmanager->executeHooks('loadStatsCustomerInvoiceRec', $parameters, $this, $action);
            if ($reshook > 0) {
                $this->stats_facturerec = $hookmanager->resArray['stats_facturerec'];
            }

            return 1;
        } else {
            $this->error = $this->db->error();
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Charge tableau des stats facture pour le produit/service
     *
     * @param int $socid Id societe
     * @return int                     Array of stats in $this->stats_facture, <0 if ko or >0 if ok
     */
    public function load_stats_facture($socid = 0)
    {
        // phpcs:enable
        global $conf, $user, $hookmanager, $action;

        $sql = "SELECT COUNT(DISTINCT f.fk_soc) as nb_customers, COUNT(DISTINCT f.rowid) as nb,";
        $sql .= " COUNT(fd.rowid) as nb_rows, SUM(" . $this->db->ifsql('f.type != 2', 'fd.qty', 'fd.qty * -1') . ") as qty";
        $sql .= " FROM " . $this->db->prefix() . "facturedet as fd";
        $sql .= ", " . $this->db->prefix() . "facture as f";
        $sql .= ", " . $this->db->prefix() . "societe as s";
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE f.rowid = fd.fk_facture";
        $sql .= " AND f.fk_soc = s.rowid";
        $sql .= " AND f.entity IN (" . getEntity('invoice') . ")";
        $sql .= " AND fd.fk_product = " . ((int)$this->id);
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        //$sql.= " AND f.fk_statut != 0";
        if ($socid > 0) {
            $sql .= " AND f.fk_soc = " . ((int)$socid);
        }

        $result = $this->db->query($sql);
        if ($result) {
            $obj = $this->db->fetch_object($result);
            $this->stats_facture['customers'] = $obj->nb_customers;
            $this->stats_facture['nb'] = $obj->nb;
            $this->stats_facture['rows'] = $obj->nb_rows;
            $this->stats_facture['qty'] = $obj->qty ? $obj->qty : 0;

            // if it's a virtual product, maybe it is in invoice by extension
            if (getDolGlobalString('PRODUCT_STATS_WITH_PARENT_PROD_IF_INCDEC')) {
                $TFather = $this->getFather();
                if (is_array($TFather) && !empty($TFather)) {
                    foreach ($TFather as &$fatherData) {
                        $pFather = new Product($this->db);
                        $pFather->id = $fatherData['id'];
                        $qtyCoef = $fatherData['qty'];

                        if ($fatherData['incdec']) {
                            $pFather->load_stats_facture($socid);

                            $this->stats_facture['customers'] += $pFather->stats_facture['customers'];
                            $this->stats_facture['nb'] += $pFather->stats_facture['nb'];
                            $this->stats_facture['rows'] += $pFather->stats_facture['rows'];
                            $this->stats_facture['qty'] += $pFather->stats_facture['qty'] * $qtyCoef;
                        }
                    }
                }
            }

            $parameters = array('socid' => $socid);
            $reshook = $hookmanager->executeHooks('loadStatsCustomerInvoice', $parameters, $this, $action);
            if ($reshook > 0) {
                $this->stats_facture = $hookmanager->resArray['stats_facture'];
            }

            return 1;
        } else {
            $this->error = $this->db->error();
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Charge tableau des stats facture pour le produit/service
     *
     * @param int $socid Id societe
     * @return int                     Array of stats in $this->stats_facture_fournisseur, <0 if ko or >0 if ok
     */
    public function load_stats_facture_fournisseur($socid = 0)
    {
        // phpcs:enable
        global $conf, $user, $hookmanager, $action;

        $sql = "SELECT COUNT(DISTINCT f.fk_soc) as nb_suppliers, COUNT(DISTINCT f.rowid) as nb,";
        $sql .= " COUNT(fd.rowid) as nb_rows, SUM(fd.qty) as qty";
        $sql .= " FROM " . $this->db->prefix() . "facture_fourn_det as fd";
        $sql .= ", " . $this->db->prefix() . "facture_fourn as f";
        $sql .= ", " . $this->db->prefix() . "societe as s";
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE f.rowid = fd.fk_facture_fourn";
        $sql .= " AND f.fk_soc = s.rowid";
        $sql .= " AND f.entity IN (" . getEntity('facture_fourn') . ")";
        $sql .= " AND fd.fk_product = " . ((int)$this->id);
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        //$sql.= " AND f.fk_statut != 0";
        if ($socid > 0) {
            $sql .= " AND f.fk_soc = " . ((int)$socid);
        }

        $result = $this->db->query($sql);
        if ($result) {
            $obj = $this->db->fetch_object($result);
            $this->stats_facture_fournisseur['suppliers'] = $obj->nb_suppliers;
            $this->stats_facture_fournisseur['nb'] = $obj->nb;
            $this->stats_facture_fournisseur['rows'] = $obj->nb_rows;
            $this->stats_facture_fournisseur['qty'] = $obj->qty ? $obj->qty : 0;

            $parameters = array('socid' => $socid);
            $reshook = $hookmanager->executeHooks('loadStatsSupplierInvoice', $parameters, $this, $action);
            if ($reshook > 0) {
                $this->stats_facture_fournisseur = $hookmanager->resArray['stats_facture_fournisseur'];
            }

            return 1;
        } else {
            $this->error = $this->db->error();
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Return nb of units or customers invoices in which product is included
     *
     * @param int $socid Limit count on a particular third party id
     * @param string $mode 'byunit'=number of unit, 'bynumber'=nb of entities
     * @param int $filteronproducttype 0=To filter on product only, 1=To filter on services only
     * @param int $year Year (0=last 12 month, -1=all years)
     * @param string $morefilter More sql filters
     * @return array                       Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11
     */
    public function get_nb_vente($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter = '')
    {
        // phpcs:enable
        global $conf;
        global $user;

        $sql = "SELECT sum(d.qty) as qty, date_format(f.datef, '%Y%m')";
        if ($mode == 'bynumber') {
            $sql .= ", count(DISTINCT f.rowid)";
        }
        $sql .= ", sum(d.total_ht) as total_ht";
        $sql .= " FROM " . $this->db->prefix() . "facturedet as d, " . $this->db->prefix() . "facture as f, " . $this->db->prefix() . "societe as s";
        if ($filteronproducttype >= 0) {
            $sql .= ", " . $this->db->prefix() . "product as p";
        }
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE f.rowid = d.fk_facture";
        if ($this->id > 0) {
            $sql .= " AND d.fk_product = " . ((int)$this->id);
        } else {
            $sql .= " AND d.fk_product > 0";
        }
        if ($filteronproducttype >= 0) {
            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int)$filteronproducttype);
        }
        $sql .= " AND f.fk_soc = s.rowid";
        $sql .= " AND f.entity IN (" . getEntity('invoice') . ")";
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND f.fk_soc = $socid";
        }
        $sql .= $morefilter;
        $sql .= " GROUP BY date_format(f.datef,'%Y%m')";
        $sql .= " ORDER BY date_format(f.datef,'%Y%m') DESC";

        return $this->_get_stats($sql, $mode, $year);

    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Return an array formatted for showing graphs
     *
     * @param string $sql Request to execute
     * @param string $mode 'byunit'=number of unit, 'bynumber'=nb of entities
     * @param int $year Year (0=current year, -1=all years)
     * @return array|int            Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11
     */
    private function _get_stats($sql, $mode, $year = 0)
    {
        // phpcs:enable
        $tab = array();

        $resql = $this->db->query($sql);
        if ($resql) {
            $num = $this->db->num_rows($resql);
            $i = 0;
            while ($i < $num) {
                $arr = $this->db->fetch_array($resql);
                if (is_array($arr)) {
                    $keyfortab = (string)$arr[1];
                    if ($year == -1) {
                        $keyfortab = substr($keyfortab, -2);
                    }

                    if ($mode == 'byunit') {
                        $tab[$keyfortab] = (empty($tab[$keyfortab]) ? 0 : $tab[$keyfortab]) + $arr[0]; // 1st field
                    } elseif ($mode == 'bynumber') {
                        $tab[$keyfortab] = (empty($tab[$keyfortab]) ? 0 : $tab[$keyfortab]) + $arr[2]; // 3rd field
                    } elseif ($mode == 'byamount') {
                        $tab[$keyfortab] = (empty($tab[$keyfortab]) ? 0 : $tab[$keyfortab]) + $arr[2]; // 3rd field
                    } else {
                        // Bad value for $mode
                        return -1;
                    }
                }
                $i++;
            }
        } else {
            $this->error = $this->db->error() . ' sql=' . $sql;
            return -1;
        }

        if (empty($year)) {
            $year = dol_print_date(time(), '%Y');
            $month = dol_print_date(time(), '%m');
        } elseif ($year == -1) {
            $year = '';
            $month = 12; // We imagine we are at end of year, so we get last 12 month before, so all correct year.
        } else {
            $month = 12; // We imagine we are at end of year, so we get last 12 month before, so all correct year.
        }

        $result = array();

        for ($j = 0; $j < 12; $j++) {
            // $ids is 'D', 'N', 'O', 'S', ... (First letter of month in user language)
            $idx = ucfirst(dol_trunc(dol_print_date(dol_mktime(12, 0, 0, $month, 1, 1970), "%b"), 1, 'right', 'UTF-8', 1));

            //print $idx.'-'.$year.'-'.$month.'<br>';
            $result[$j] = array($idx, isset($tab[$year . $month]) ? $tab[$year . $month] : 0);
            //            $result[$j] = array($monthnum,isset($tab[$year.$month])?$tab[$year.$month]:0);

            $month = "0" . ($month - 1);
            if (dol_strlen($month) == 3) {
                $month = substr($month, 1);
            }
            if ($month == 0) {
                $month = 12;
                $year = $year - 1;
            }
        }

        return array_reverse($result);
    }


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Return nb of units or supplier invoices in which product is included
     *
     * @param int $socid Limit count on a particular third party id
     * @param string $mode 'byunit'=number of unit, 'bynumber'=nb of entities
     * @param int $filteronproducttype 0=To filter on product only, 1=To filter on services only
     * @param int $year Year (0=last 12 month, -1=all years)
     * @param string $morefilter More sql filters
     * @return array                       Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11
     */
    public function get_nb_achat($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter = '')
    {
        // phpcs:enable
        global $conf;
        global $user;

        $sql = "SELECT sum(d.qty) as qty, date_format(f.datef, '%Y%m')";
        if ($mode == 'bynumber') {
            $sql .= ", count(DISTINCT f.rowid)";
        }
        $sql .= ", sum(d.total_ht) as total_ht";
        $sql .= " FROM " . $this->db->prefix() . "facture_fourn_det as d, " . $this->db->prefix() . "facture_fourn as f, " . $this->db->prefix() . "societe as s";
        if ($filteronproducttype >= 0) {
            $sql .= ", " . $this->db->prefix() . "product as p";
        }
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE f.rowid = d.fk_facture_fourn";
        if ($this->id > 0) {
            $sql .= " AND d.fk_product = " . ((int)$this->id);
        } else {
            $sql .= " AND d.fk_product > 0";
        }
        if ($filteronproducttype >= 0) {
            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int)$filteronproducttype);
        }
        $sql .= " AND f.fk_soc = s.rowid";
        $sql .= " AND f.entity IN (" . getEntity('facture_fourn') . ")";
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND f.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND f.fk_soc = $socid";
        }
        $sql .= $morefilter;
        $sql .= " GROUP BY date_format(f.datef,'%Y%m')";
        $sql .= " ORDER BY date_format(f.datef,'%Y%m') DESC";

        return $this->_get_stats($sql, $mode, $year);

    }


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Return nb of units in proposals in which product is included
     *
     * @param int $socid Limit count on a particular third party id
     * @param string $mode 'byunit'=number of unit, 'bynumber'=nb of entities, 'byamount'=amount
     * @param int $filteronproducttype 0=To filter on product only, 1=To filter on services only
     * @param int $year Year (0=last 12 month, -1=all years)
     * @param string $morefilter More sql filters
     * @return array                       Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11
     */
    public function get_nb_propal($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter = '')
    {
        // phpcs:enable
        global $conf, $user;

        $sql = "SELECT sum(d.qty) as qty, date_format(p.datep, '%Y%m')";
        if ($mode == 'bynumber') {
            $sql .= ", count(DISTINCT p.rowid)";
        }
        $sql .= ", sum(d.total_ht) as total_ht";
        $sql .= " FROM " . $this->db->prefix() . "propaldet as d, " . $this->db->prefix() . "propal as p, " . $this->db->prefix() . "societe as s";
        if ($filteronproducttype >= 0) {
            $sql .= ", " . $this->db->prefix() . "product as prod";
        }
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE p.rowid = d.fk_propal";
        if ($this->id > 0) {
            $sql .= " AND d.fk_product = " . ((int)$this->id);
        } else {
            $sql .= " AND d.fk_product > 0";
        }
        if ($filteronproducttype >= 0) {
            $sql .= " AND prod.rowid = d.fk_product AND prod.fk_product_type = " . ((int)$filteronproducttype);
        }
        $sql .= " AND p.fk_soc = s.rowid";
        $sql .= " AND p.entity IN (" . getEntity('propal') . ")";
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND p.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND p.fk_soc = " . ((int)$socid);
        }
        $sql .= $morefilter;
        $sql .= " GROUP BY date_format(p.datep,'%Y%m')";
        $sql .= " ORDER BY date_format(p.datep,'%Y%m') DESC";

        return $this->_get_stats($sql, $mode, $year);

    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Return nb of units in proposals in which product is included
     *
     * @param int $socid Limit count on a particular third party id
     * @param string $mode 'byunit'=number of unit, 'bynumber'=nb of entities
     * @param int $filteronproducttype 0=To filter on product only, 1=To filter on services only
     * @param int $year Year (0=last 12 month, -1=all years)
     * @param string $morefilter More sql filters
     * @return array                       Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11
     */
    public function get_nb_propalsupplier($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter = '')
    {
        // phpcs:enable
        global $conf;
        global $user;

        $sql = "SELECT sum(d.qty) as qty, date_format(p.date_valid, '%Y%m')";
        if ($mode == 'bynumber') {
            $sql .= ", count(DISTINCT p.rowid)";
        }
        $sql .= ", sum(d.total_ht) as total_ht";
        $sql .= " FROM " . $this->db->prefix() . "supplier_proposaldet as d, " . $this->db->prefix() . "supplier_proposal as p, " . $this->db->prefix() . "societe as s";
        if ($filteronproducttype >= 0) {
            $sql .= ", " . $this->db->prefix() . "product as prod";
        }
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE p.rowid = d.fk_supplier_proposal";
        if ($this->id > 0) {
            $sql .= " AND d.fk_product = " . ((int)$this->id);
        } else {
            $sql .= " AND d.fk_product > 0";
        }
        if ($filteronproducttype >= 0) {
            $sql .= " AND prod.rowid = d.fk_product AND prod.fk_product_type = " . ((int)$filteronproducttype);
        }
        $sql .= " AND p.fk_soc = s.rowid";
        $sql .= " AND p.entity IN (" . getEntity('supplier_proposal') . ")";
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND p.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND p.fk_soc = " . ((int)$socid);
        }
        $sql .= $morefilter;
        $sql .= " GROUP BY date_format(p.date_valid,'%Y%m')";
        $sql .= " ORDER BY date_format(p.date_valid,'%Y%m') DESC";

        return $this->_get_stats($sql, $mode, $year);

    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Return nb of units in orders in which product is included
     *
     * @param int $socid Limit count on a particular third party id
     * @param string $mode 'byunit'=number of unit, 'bynumber'=nb of entities
     * @param int $filteronproducttype 0=To filter on product only, 1=To filter on services only
     * @param int $year Year (0=last 12 month, -1=all years)
     * @param string $morefilter More sql filters
     * @return array                       Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11
     */
    public function get_nb_order($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter = '')
    {
        // phpcs:enable
        global $conf, $user;

        $sql = "SELECT sum(d.qty) as qty, date_format(c.date_commande, '%Y%m')";
        if ($mode == 'bynumber') {
            $sql .= ", count(DISTINCT c.rowid)";
        }
        $sql .= ", sum(d.total_ht) as total_ht";
        $sql .= " FROM " . $this->db->prefix() . "commandedet as d, " . $this->db->prefix() . "commande as c, " . $this->db->prefix() . "societe as s";
        if ($filteronproducttype >= 0) {
            $sql .= ", " . $this->db->prefix() . "product as p";
        }
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE c.rowid = d.fk_commande";
        if ($this->id > 0) {
            $sql .= " AND d.fk_product = " . ((int)$this->id);
        } else {
            $sql .= " AND d.fk_product > 0";
        }
        if ($filteronproducttype >= 0) {
            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int)$filteronproducttype);
        }
        $sql .= " AND c.fk_soc = s.rowid";
        $sql .= " AND c.entity IN (" . getEntity('commande') . ")";
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND c.fk_soc = " . ((int)$socid);
        }
        $sql .= $morefilter;
        $sql .= " GROUP BY date_format(c.date_commande,'%Y%m')";
        $sql .= " ORDER BY date_format(c.date_commande,'%Y%m') DESC";

        return $this->_get_stats($sql, $mode, $year);

    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Return nb of units in orders in which product is included
     *
     * @param int $socid Limit count on a particular third party id
     * @param string $mode 'byunit'=number of unit, 'bynumber'=nb of entities
     * @param int $filteronproducttype 0=To filter on product only, 1=To filter on services only
     * @param int $year Year (0=last 12 month, -1=all years)
     * @param string $morefilter More sql filters
     * @return array                       Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11
     */
    public function get_nb_ordersupplier($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter = '')
    {
        // phpcs:enable
        global $conf, $user;

        $sql = "SELECT sum(d.qty) as qty, date_format(c.date_commande, '%Y%m')";
        if ($mode == 'bynumber') {
            $sql .= ", count(DISTINCT c.rowid)";
        }
        $sql .= ", sum(d.total_ht) as total_ht";
        $sql .= " FROM " . $this->db->prefix() . "commande_fournisseurdet as d, " . $this->db->prefix() . "commande_fournisseur as c, " . $this->db->prefix() . "societe as s";
        if ($filteronproducttype >= 0) {
            $sql .= ", " . $this->db->prefix() . "product as p";
        }
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE c.rowid = d.fk_commande";
        if ($this->id > 0) {
            $sql .= " AND d.fk_product = " . ((int)$this->id);
        } else {
            $sql .= " AND d.fk_product > 0";
        }
        if ($filteronproducttype >= 0) {
            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int)$filteronproducttype);
        }
        $sql .= " AND c.fk_soc = s.rowid";
        $sql .= " AND c.entity IN (" . getEntity('supplier_order') . ")";
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND c.fk_soc = " . ((int)$socid);
        }
        $sql .= $morefilter;
        $sql .= " GROUP BY date_format(c.date_commande,'%Y%m')";
        $sql .= " ORDER BY date_format(c.date_commande,'%Y%m') DESC";

        return $this->_get_stats($sql, $mode, $year);

    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Return nb of units in orders in which product is included
     *
     * @param int $socid Limit count on a particular third party id
     * @param string $mode 'byunit'=number of unit, 'bynumber'=nb of entities
     * @param int $filteronproducttype 0=To filter on product only, 1=To filter on services only
     * @param int $year Year (0=last 12 month, -1=all years)
     * @param string $morefilter More sql filters
     * @return array                       Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11
     */
    public function get_nb_contract($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter = '')
    {
        // phpcs:enable
        global $conf, $user;

        $sql = "SELECT sum(d.qty) as qty, date_format(c.date_contrat, '%Y%m')";
        if ($mode == 'bynumber') {
            $sql .= ", count(DISTINCT c.rowid)";
        }
        $sql .= ", sum(d.total_ht) as total_ht";
        $sql .= " FROM " . $this->db->prefix() . "contratdet as d, " . $this->db->prefix() . "contrat as c, " . $this->db->prefix() . "societe as s";
        if ($filteronproducttype >= 0) {
            $sql .= ", " . $this->db->prefix() . "product as p";
        }
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }
        $sql .= " WHERE c.entity IN (" . getEntity('contract') . ")";
        $sql .= " AND c.rowid = d.fk_contrat";

        if ($this->id > 0) {
            $sql .= " AND d.fk_product = " . ((int)$this->id);
        } else {
            $sql .= " AND d.fk_product > 0";
        }
        if ($filteronproducttype >= 0) {
            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int)$filteronproducttype);
        }
        $sql .= " AND c.fk_soc = s.rowid";

        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND c.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND c.fk_soc = " . ((int)$socid);
        }
        $sql .= $morefilter;
        $sql .= " GROUP BY date_format(c.date_contrat,'%Y%m')";
        $sql .= " ORDER BY date_format(c.date_contrat,'%Y%m') DESC";

        return $this->_get_stats($sql, $mode, $year);

    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Return nb of units in orders in which product is included
     *
     * @param int $socid Limit count on a particular third party id
     * @param string $mode 'byunit'=number of unit, 'bynumber'=nb of entities
     * @param int $filteronproducttype 0=To filter on product only, 1=To filter on services only
     * @param int $year Year (0=last 12 month, -1=all years)
     * @param string $morefilter More sql filters
     * @return array                       Return integer <0 if KO, result[month]=array(valuex,valuey) where month is 0 to 11
     */
    public function get_nb_mos($socid, $mode, $filteronproducttype = -1, $year = 0, $morefilter = '')
    {
        // phpcs:enable
        global $conf, $user;

        $sql = "SELECT sum(d.qty), date_format(d.date_valid, '%Y%m')";
        if ($mode == 'bynumber') {
            $sql .= ", count(DISTINCT d.rowid)";
        }
        $sql .= " FROM " . $this->db->prefix() . "mrp_mo as d LEFT JOIN  " . $this->db->prefix() . "societe as s ON d.fk_soc = s.rowid";
        if ($filteronproducttype >= 0) {
            $sql .= ", " . $this->db->prefix() . "product as p";
        }
        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= ", " . $this->db->prefix() . "societe_commerciaux as sc";
        }

        $sql .= " WHERE d.entity IN (" . getEntity('mo') . ")";
        $sql .= " AND d.status > 0";

        if ($this->id > 0) {
            $sql .= " AND d.fk_product = " . ((int)$this->id);
        } else {
            $sql .= " AND d.fk_product > 0";
        }
        if ($filteronproducttype >= 0) {
            $sql .= " AND p.rowid = d.fk_product AND p.fk_product_type = " . ((int)$filteronproducttype);
        }

        if (!$user->hasRight('societe', 'client', 'voir')) {
            $sql .= " AND d.fk_soc = sc.fk_soc AND sc.fk_user = " . ((int)$user->id);
        }
        if ($socid > 0) {
            $sql .= " AND d.fk_soc = " . ((int)$socid);
        }
        $sql .= $morefilter;
        $sql .= " GROUP BY date_format(d.date_valid,'%Y%m')";
        $sql .= " ORDER BY date_format(d.date_valid,'%Y%m') DESC";

        return $this->_get_stats($sql, $mode, $year);

    }

    /**
     *  Link a product/service to a parent product/service
     *
     * @param int $id_pere Id of parent product/service
     * @param int $id_fils Id of child product/service
     * @param float $qty Quantity
     * @param int $incdec 1=Increase/decrease stock of child when parent stock increase/decrease
     * @param int $notrigger Disable triggers
     * @return int                Return integer < 0 if KO, > 0 if OK
     */
    public function add_sousproduit($id_pere, $id_fils, $qty, $incdec = 1, $notrigger = 0)
    {
        global $user;

        // phpcs:enable
        // Clean parameters
        if (!is_numeric($id_pere)) {
            $id_pere = 0;
        }
        if (!is_numeric($id_fils)) {
            $id_fils = 0;
        }
        if (!is_numeric($incdec)) {
            $incdec = 0;
        }

        $result = $this->del_sousproduit($id_pere, $id_fils);
        if ($result < 0) {
            return $result;
        }

        // Check not already father of id_pere (to avoid father -> child -> father links)
        $sql = "SELECT fk_product_pere from " . $this->db->prefix() . "product_association";
        $sql .= " WHERE fk_product_pere = " . ((int)$id_fils) . " AND fk_product_fils = " . ((int)$id_pere);
        if (!$this->db->query($sql)) {
            dol_print_error($this->db);
            return -1;
        } else {
            //Selection of the highest row
            $sql = "SELECT MAX(rang) as max_rank FROM " . $this->db->prefix() . "product_association";
            $sql .= " WHERE fk_product_pere  = " . ((int)$id_pere);
            $resql = $this->db->query($sql);
            if ($resql) {
                $obj = $this->db->fetch_object($resql);
                $rank = $obj->max_rank + 1;
                //Addition of a product with the highest rank +1
                $sql = "INSERT INTO " . $this->db->prefix() . "product_association(fk_product_pere,fk_product_fils,qty,incdec,rang)";
                $sql .= " VALUES (" . ((int)$id_pere) . ", " . ((int)$id_fils) . ", " . price2num($qty, 'MS') . ", " . ((int)$incdec) . ", " . ((int)$rank) . ")";
                if (!$this->db->query($sql)) {
                    dol_print_error($this->db);
                    return -1;
                } else {
                    if (!$notrigger) {
                        // Call trigger
                        $result = $this->call_trigger('PRODUCT_SUBPRODUCT_ADD', $user);
                        if ($result < 0) {
                            $this->error = $this->db->lasterror();
                            dol_syslog(get_only_class($this) . '::addSubproduct error=' . $this->error, LOG_ERR);
                            return -1;
                        }
                    }
                    // End call triggers

                    return 1;
                }
            } else {
                dol_print_error($this->db);
                return -1;
            }
        }
    }

    /**
     *  Remove a link between a subproduct and a parent product/service
     *
     * @param int $fk_parent Id of parent product (child will no more be linked to it)
     * @param int $fk_child Id of child product
     * @param int $notrigger Disable triggers
     * @return int            Return integer < 0 if KO, > 0 if OK
     */
    public function del_sousproduit($fk_parent, $fk_child, $notrigger = 0)
    {
        global $user;

        // phpcs:enable
        if (!is_numeric($fk_parent)) {
            $fk_parent = 0;
        }
        if (!is_numeric($fk_child)) {
            $fk_child = 0;
        }

        $sql = "DELETE FROM " . $this->db->prefix() . "product_association";
        $sql .= " WHERE fk_product_pere  = " . ((int)$fk_parent);
        $sql .= " AND fk_product_fils = " . ((int)$fk_child);

        dol_syslog(get_only_class($this) . '::del_sousproduit', LOG_DEBUG);
        if (!$this->db->query($sql)) {
            dol_print_error($this->db);
            return -1;
        }

        // Updated ranks so that none are missing
        $sqlrank = "SELECT rowid, rang FROM " . $this->db->prefix() . "product_association";
        $sqlrank .= " WHERE fk_product_pere = " . ((int)$fk_parent);
        $sqlrank .= " ORDER BY rang";
        $resqlrank = $this->db->query($sqlrank);
        if ($resqlrank) {
            $cpt = 0;
            while ($objrank = $this->db->fetch_object($resqlrank)) {
                $cpt++;
                $sql = "UPDATE " . $this->db->prefix() . "product_association";
                $sql .= " SET rang = " . ((int)$cpt);
                $sql .= " WHERE rowid = " . ((int)$objrank->rowid);
                if (!$this->db->query($sql)) {
                    dol_print_error($this->db);
                    return -1;
                }
            }
        }

        if (!$notrigger) {
            // Call trigger
            $result = $this->call_trigger('PRODUCT_SUBPRODUCT_DELETE', $user);
            if ($result < 0) {
                $this->error = $this->db->lasterror();
                dol_syslog(get_only_class($this) . '::delSubproduct error=' . $this->error, LOG_ERR);
                return -1;
            }
            // End call triggers
        }

        return 1;
    }

    /**
     *  Modify composed product
     *
     * @param int $id_pere Id of parent product/service
     * @param int $id_fils Id of child product/service
     * @param float $qty Quantity
     * @param int $incdec 1=Increase/decrease stock of child when parent stock increase/decrease
     * @param int $notrigger Disable triggers
     * @return int                Return integer < 0 if KO, > 0 if OK
     */
    public function update_sousproduit($id_pere, $id_fils, $qty, $incdec = 1, $notrigger = 0)
    {
        global $user;

        // phpcs:enable
        // Clean parameters
        if (!is_numeric($id_pere)) {
            $id_pere = 0;
        }
        if (!is_numeric($id_fils)) {
            $id_fils = 0;
        }
        if (!is_numeric($incdec)) {
            $incdec = 1;
        }
        if (!is_numeric($qty)) {
            $qty = 1;
        }

        $sql = 'UPDATE ' . $this->db->prefix() . 'product_association SET ';
        $sql .= 'qty = ' . price2num($qty, 'MS');
        $sql .= ',incdec = ' . ((int)$incdec);
        $sql .= ' WHERE fk_product_pere = ' . ((int)$id_pere) . ' AND fk_product_fils = ' . ((int)$id_fils);

        if (!$this->db->query($sql)) {
            dol_print_error($this->db);
            return -1;
        } else {
            if (!$notrigger) {
                // Call trigger
                $result = $this->call_trigger('PRODUCT_SUBPRODUCT_UPDATE', $user);
                if ($result < 0) {
                    $this->error = $this->db->lasterror();
                    dol_syslog(get_only_class($this) . '::updateSubproduct error=' . $this->error, LOG_ERR);
                    return -1;
                }
                // End call triggers
            }

            return 1;
        }
    }

    /**
     *  Check if it is a sub-product into a kit
     *
     * @param int $fk_parent Id of parent kit product
     * @param int $fk_child Id of child product
     * @return int                  Return 1 or 0; -1 if error
     */
    public function is_sousproduit($fk_parent, $fk_child)
    {
        // phpcs:enable
        $sql = "SELECT fk_product_pere, qty, incdec";
        $sql .= " FROM " . $this->db->prefix() . "product_association";
        $sql .= " WHERE fk_product_pere  = " . ((int)$fk_parent);
        $sql .= " AND fk_product_fils = " . ((int)$fk_child);

        $result = $this->db->query($sql);
        if ($result) {
            $num = $this->db->num_rows($result);

            if ($num > 0) {
                $obj = $this->db->fetch_object($result);

                $this->is_sousproduit_qty = $obj->qty;
                $this->is_sousproduit_incdec = $obj->incdec;

                return 1;
            } else {
                return 0;
            }
        } else {
            dol_print_error($this->db);
            return -1;
        }
    }

    /**
     *  Add a supplier price for the product.
     *  Note: Duplicate ref is accepted for different quantity only, or for different companies.
     *
     * @param User $user User that make link
     * @param int $id_fourn Supplier id
     * @param string $ref_fourn Supplier ref
     * @param float $quantity Quantity minimum for price
     * @return int               Return integer < 0 if KO, 0 if link already exists for this product, > 0 if OK
     */
    public function add_fournisseur($user, $id_fourn, $ref_fourn, $quantity)
    {
        // phpcs:enable
        global $conf;

        $now = dol_now();

        dol_syslog(get_only_class($this) . "::add_fournisseur id_fourn = " . $id_fourn . " ref_fourn=" . $ref_fourn . " quantity=" . $quantity, LOG_DEBUG);

        // Clean parameters
        $quantity = price2num($quantity, 'MS');

        if ($ref_fourn) {
            // Check if ref is not already used
            $sql = "SELECT rowid, fk_product";
            $sql .= " FROM " . $this->db->prefix() . "product_fournisseur_price";
            $sql .= " WHERE fk_soc = " . ((int)$id_fourn);
            $sql .= " AND ref_fourn = '" . $this->db->escape($ref_fourn) . "'";
            $sql .= " AND fk_product <> " . ((int)$this->id);
            $sql .= " AND entity IN (" . getEntity('productsupplierprice') . ")";

            $resql = $this->db->query($sql);
            if ($resql) {
                $obj = $this->db->fetch_object($resql);
                if ($obj) {
                    // If the supplier ref already exists but for another product (duplicate ref is accepted for different quantity only or different companies)
                    $this->product_id_already_linked = $obj->fk_product;
                    return -3;
                }
                $this->db->free($resql);
            }
        }

        $sql = "SELECT rowid";
        $sql .= " FROM " . $this->db->prefix() . "product_fournisseur_price";
        $sql .= " WHERE fk_soc = " . ((int)$id_fourn);
        if ($ref_fourn) {
            $sql .= " AND ref_fourn = '" . $this->db->escape($ref_fourn) . "'";
        } else {
            $sql .= " AND (ref_fourn = '' OR ref_fourn IS NULL)";
        }
        $sql .= " AND quantity = " . ((float)$quantity);
        $sql .= " AND fk_product = " . ((int)$this->id);
        $sql .= " AND entity IN (" . getEntity('productsupplierprice') . ")";

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

            // The reference supplier does not exist, we create it for this product.
            if (empty($obj)) {
                $sql = "INSERT INTO " . $this->db->prefix() . "product_fournisseur_price(";
                $sql .= "datec";
                $sql .= ", entity";
                $sql .= ", fk_product";
                $sql .= ", fk_soc";
                $sql .= ", ref_fourn";
                $sql .= ", quantity";
                $sql .= ", fk_user";
                $sql .= ", tva_tx";
                $sql .= ") VALUES (";
                $sql .= "'" . $this->db->idate($now) . "'";
                $sql .= ", " . ((int)$conf->entity);
                $sql .= ", " . ((int)$this->id);
                $sql .= ", " . ((int)$id_fourn);
                $sql .= ", '" . $this->db->escape($ref_fourn) . "'";
                $sql .= ", " . ((float)$quantity);
                $sql .= ", " . ((int)$user->id);
                $sql .= ", 0";
                $sql .= ")";

                if ($this->db->query($sql)) {
                    $this->product_fourn_price_id = $this->db->last_insert_id($this->db->prefix() . "product_fournisseur_price");
                    return 1;
                } else {
                    $this->error = $this->db->lasterror();
                    return -1;
                }
            } else {
                // If the supplier price already exists for this product and quantity
                $this->product_fourn_price_id = $obj->rowid;
                return 0;
            }
        } else {
            $this->error = $this->db->lasterror();
            return -2;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Return list of suppliers providing the product or service
     *
     * @return array        Array of vendor ids
     */
    public function list_suppliers()
    {
        // phpcs:enable
        global $conf;

        $list = array();

        $sql = "SELECT DISTINCT p.fk_soc";
        $sql .= " FROM " . $this->db->prefix() . "product_fournisseur_price as p";
        $sql .= " WHERE p.fk_product = " . ((int)$this->id);
        $sql .= " AND p.entity = " . ((int)$conf->entity);

        $result = $this->db->query($sql);
        if ($result) {
            $num = $this->db->num_rows($result);
            $i = 0;
            while ($i < $num) {
                $obj = $this->db->fetch_object($result);
                $list[$i] = $obj->fk_soc;
                $i++;
            }
        }

        return $list;
    }

    /**
     *  Recopie les prix d'un produit/service sur un autre
     *
     * @param int $fromId Id product source
     * @param int $toId Id product target
     * @return int                     Return integer < 0 if KO, > 0 if OK
     */
    public function clone_price($fromId, $toId)
    {
        global $conf, $user;

        $now = dol_now();

        $this->db->begin();

        // prices
        $sql = "INSERT INTO " . $this->db->prefix() . "product_price (";
        $sql .= " entity";
        $sql .= ", fk_product";
        $sql .= ", date_price";
        $sql .= ", price_level";
        $sql .= ", price";
        $sql .= ", price_ttc";
        $sql .= ", price_min";
        $sql .= ", price_min_ttc";
        $sql .= ", price_base_type";
        $sql .= ", price_label";
        $sql .= ", default_vat_code";
        $sql .= ", tva_tx";
        $sql .= ", recuperableonly";
        $sql .= ", localtax1_tx";
        $sql .= ", localtax1_type";
        $sql .= ", localtax2_tx";
        $sql .= ", localtax2_type";
        $sql .= ", fk_user_author";
        $sql .= ", tosell";
        $sql .= ", price_by_qty";
        $sql .= ", fk_price_expression";
        $sql .= ", fk_multicurrency";
        $sql .= ", multicurrency_code";
        $sql .= ", multicurrency_tx";
        $sql .= ", multicurrency_price";
        $sql .= ", multicurrency_price_ttc";
        $sql .= ")";
        $sql .= " SELECT";
        $sql .= " entity";
        $sql .= ", " . $toId;
        $sql .= ", '" . $this->db->idate($now) . "'";
        $sql .= ", price_level";
        $sql .= ", price";
        $sql .= ", price_ttc";
        $sql .= ", price_min";
        $sql .= ", price_min_ttc";
        $sql .= ", price_base_type";
        $sql .= ", price_label";
        $sql .= ", default_vat_code";
        $sql .= ", tva_tx";
        $sql .= ", recuperableonly";
        $sql .= ", localtax1_tx";
        $sql .= ", localtax1_type";
        $sql .= ", localtax2_tx";
        $sql .= ", localtax2_type";
        $sql .= ", " . $user->id;
        $sql .= ", tosell";
        $sql .= ", price_by_qty";
        $sql .= ", fk_price_expression";
        $sql .= ", fk_multicurrency";
        $sql .= ", multicurrency_code";
        $sql .= ", multicurrency_tx";
        $sql .= ", multicurrency_price";
        $sql .= ", multicurrency_price_ttc";
        $sql .= " FROM " . $this->db->prefix() . "product_price ps";
        $sql .= " WHERE fk_product = " . ((int)$fromId);
        $sql .= " AND date_price IN (SELECT MAX(pd.date_price) FROM " . $this->db->prefix() . "product_price pd WHERE pd.fk_product = " . ((int)$fromId) . " AND pd.price_level = ps.price_level)";
        $sql .= " ORDER BY date_price DESC";

        dol_syslog(__METHOD__, LOG_DEBUG);
        $resql = $this->db->query($sql);
        if (!$resql) {
            $this->db->rollback();
            return -1;
        }

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

    /**
     * Clone links between products
     *
     * @param int $fromId Product id
     * @param int $toId Product id
     * @return int                  Return integer <0 if KO, >0 if OK
     */
    public function clone_associations($fromId, $toId)
    {
        // phpcs:enable
        $this->db->begin();

        $sql = 'INSERT INTO ' . $this->db->prefix() . 'product_association (fk_product_pere, fk_product_fils, qty, incdec)';
        $sql .= " SELECT " . $toId . ", fk_product_fils, qty, incdec FROM " . $this->db->prefix() . "product_association";
        $sql .= " WHERE fk_product_pere = " . ((int)$fromId);

        dol_syslog(get_only_class($this) . '::clone_association', LOG_DEBUG);
        if (!$this->db->query($sql)) {
            $this->db->rollback();
            return -1;
        }

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

    /**
     *  Recopie les fournisseurs et prix fournisseurs d'un produit/service sur un autre
     *
     * @param int $fromId Id produit source
     * @param int $toId Id produit cible
     * @return int                 Return integer < 0 si erreur, > 0 si ok
     */
    public function clone_fournisseurs($fromId, $toId)
    {
        // phpcs:enable
        $this->db->begin();

        $now = dol_now();

        // les fournisseurs
        /*$sql = "INSERT ".$this->db->prefix()."product_fournisseur ("
         . " datec, fk_product, fk_soc, ref_fourn, fk_user_author )"
         . " SELECT '".$this->db->idate($now)."', ".$toId.", fk_soc, ref_fourn, fk_user_author"
         . " FROM ".$this->db->prefix()."product_fournisseur"
         . " WHERE fk_product = ".((int) $fromId);

         if ( ! $this->db->query($sql ) )
         {
         $this->db->rollback();
         return -1;
         }*/

        // les prix de fournisseurs.
        $sql = "INSERT " . $this->db->prefix() . "product_fournisseur_price (";
        $sql .= " datec, fk_product, fk_soc, price, quantity, fk_user, tva_tx)";
        $sql .= " SELECT '" . $this->db->idate($now) . "', " . ((int)$toId) . ", fk_soc, price, quantity, fk_user, tva_tx";
        $sql .= " FROM " . $this->db->prefix() . "product_fournisseur_price";
        $sql .= " WHERE fk_product = " . ((int)$fromId);

        dol_syslog(get_only_class($this) . '::clone_fournisseurs', LOG_DEBUG);
        $resql = $this->db->query($sql);
        if (!$resql) {
            $this->db->rollback();
            return -1;
        } else {
            $this->db->commit();
            return 1;
        }
    }

    /**
     *  Build the tree of subproducts and return it.
     *  this->sousprods must have been loaded by this->get_sousproduits_arbo()
     *
     * @param int $multiply Because each sublevel must be multiplicated by parent nb
     * @param int $ignore_stock_load Ignore stock load
     * @return array                        Array with tree
     */
    public function get_arbo_each_prod($multiply = 1, $ignore_stock_load = 0)
    {
        // phpcs:enable
        $this->res = array();
        if (isset($this->sousprods) && is_array($this->sousprods)) {
            foreach ($this->sousprods as $prod_name => $desc_product) {
                if (is_array($desc_product)) {
                    $this->fetch_prod_arbo($desc_product, "", $multiply, 1, $this->id, $ignore_stock_load); // This set $this->res
                }
            }
        }
        //var_dump($res);
        return $this->res;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Function recursive, used only by get_arbo_each_prod(), to build tree of subproducts into ->res
     *  Define value of this->res
     *
     * @param array $prod Products array
     * @param string $compl_path Directory path of parents to add before
     * @param int $multiply Because each sublevel must be multiplicated by parent nb
     * @param int $level Init level
     * @param int $id_parent Id parent
     * @param int $ignore_stock_load Ignore stock load
     * @return void
     */
    public function fetch_prod_arbo($prod, $compl_path = '', $multiply = 1, $level = 1, $id_parent = 0, $ignore_stock_load = 0)
    {
        // phpcs:enable
        global $conf, $langs;

        $tmpproduct = null;
        //var_dump($prod);
        foreach ($prod as $id_product => $desc_pere) {    // $id_product is 0 (first call starting with root top) or an id of a sub_product
            if (is_array($desc_pere)) {    // If desc_pere is an array, this means it's a child
                $id = (!empty($desc_pere[0]) ? $desc_pere[0] : '');
                $nb = (!empty($desc_pere[1]) ? $desc_pere[1] : '');
                $type = (!empty($desc_pere[2]) ? $desc_pere[2] : '');
                $label = (!empty($desc_pere[3]) ? $desc_pere[3] : '');
                $incdec = (!empty($desc_pere[4]) ? $desc_pere[4] : 0);

                if ($multiply < 1) {
                    $multiply = 1;
                }

                //print "XXX We add id=".$id." - label=".$label." - nb=".$nb." - multiply=".$multiply." fullpath=".$compl_path.$label."\n";
                if (is_null($tmpproduct)) {
                    $tmpproduct = new Product($this->db); // So we initialize tmpproduct only once for all loop.
                }
                $tmpproduct->fetch($id); // Load product to get ->ref

                if (empty($ignore_stock_load) && ($tmpproduct->isProduct() || getDolGlobalString('STOCK_SUPPORTS_SERVICES'))) {
                    $tmpproduct->load_stock('nobatch,novirtual'); // Load stock to get true ->stock_reel
                }

                $this->res[] = array(
                    'id' => $id, // Id product
                    'id_parent' => $id_parent,
                    'ref' => $tmpproduct->ref, // Ref product
                    'nb' => $nb, // Nb of units that compose parent product
                    'nb_total' => $nb * $multiply, // Nb of units for all nb of product
                    'stock' => $tmpproduct->stock_reel, // Stock
                    'stock_alert' => $tmpproduct->seuil_stock_alerte, // Stock alert
                    'label' => $label,
                    'fullpath' => $compl_path . $label, // Label
                    'type' => $type, // Nb of units that compose parent product
                    'desiredstock' => $tmpproduct->desiredstock,
                    'level' => $level,
                    'incdec' => $incdec,
                    'entity' => $tmpproduct->entity
                );

                // Recursive call if there child has children of its own
                if (isset($desc_pere['childs']) && is_array($desc_pere['childs'])) {
                    //print 'YYY We go down for '.$desc_pere[3]." -> \n";
                    $this->fetch_prod_arbo($desc_pere['childs'], $compl_path . $desc_pere[3] . " -> ", $desc_pere[1] * $multiply, $level + 1, $id, $ignore_stock_load);
                }
            }
        }
    }

    /**
     * Count all parent and children products for current product (first level only)
     *
     * @param int $mode 0=Both parent and child, -1=Parents only, 1=Children only
     * @return  int             Nb of father + child
     * @see getFather(), get_sousproduits_arbo()
     */
    public function hasFatherOrChild($mode = 0)
    {
        $nb = 0;

        $sql = "SELECT COUNT(pa.rowid) as nb";
        $sql .= " FROM " . $this->db->prefix() . "product_association as pa";
        if ($mode == 0) {
            $sql .= " WHERE pa.fk_product_fils = " . ((int)$this->id) . " OR pa.fk_product_pere = " . ((int)$this->id);
        } elseif ($mode == -1) {
            $sql .= " WHERE pa.fk_product_fils = " . ((int)$this->id); // We are a child, so we found lines that link to parents (can have several parents)
        } elseif ($mode == 1) {
            $sql .= " WHERE pa.fk_product_pere = " . ((int)$this->id); // We are a parent, so we found lines that link to children (can have several children)
        }

        $resql = $this->db->query($sql);
        if ($resql) {
            $obj = $this->db->fetch_object($resql);
            if ($obj) {
                $nb = $obj->nb;
            }
        } else {
            return -1;
        }

        return $nb;
    }


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Return if a product has variants or not
     *
     * @return int        Number of variants
     */
    public function hasVariants()
    {
        $nb = 0;
        $sql = "SELECT count(rowid) as nb FROM " . $this->db->prefix() . "product_attribute_combination WHERE fk_product_parent = " . ((int)$this->id);
        $sql .= " AND entity IN (" . getEntity('product') . ")";

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

        return $nb;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Return if loaded product is a variant
     *
     * @return bool|int     Return true if the product is a variant, false if not, -1 if error
     */
    public function isVariant()
    {
        global $conf;
        if (isModEnabled('variants')) {
            $sql = "SELECT rowid FROM " . $this->db->prefix() . "product_attribute_combination WHERE fk_product_child = " . ((int)$this->id) . " AND entity IN (" . getEntity('product') . ")";

            $query = $this->db->query($sql);

            if ($query) {
                if (!$this->db->num_rows($query)) {
                    return false;
                }
                return true;
            } else {
                dol_print_error($this->db);
                return -1;
            }
        } else {
            return false;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *     Return tree of all subproducts for product. Tree contains array of array(0=prodid, 1=>qty, 2=>product type, 3=>label, 4=>incdec, 5=>product ref)
     *     Set this->sousprods
     *
     * @return void
     */
    public function get_sousproduits_arbo()
    {
        // phpcs:enable
        $parent = array();

        foreach ($this->getChildsArbo($this->id) as $keyChild => $valueChild) {    // Warning. getChildsArbo can call getChildsArbo recursively. Starting point is $value[0]=id of product
            $parent[$this->label][$keyChild] = $valueChild;
        }
        foreach ($parent as $key => $value) {        // key=label, value is array of children
            $this->sousprods[$key] = $value;
        }
    }


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Return children of product $id
     *
     * @param int $id Id of product to search children of
     * @param int $firstlevelonly Return only direct child
     * @param int $level Level of recursing call (start to 1)
     * @param array $parents Array of all parents of $id
     * @return array|int                    Return array(prodid=>array(0=prodid, 1=>qty, 2=>product type, 3=>label, 4=>incdec, 5=>product ref)
     */
    public function getChildsArbo($id, $firstlevelonly = 0, $level = 1, $parents = array())
    {
        global $alreadyfound;

        if (empty($id)) {
            return array();
        }

        $sql = "SELECT p.rowid, p.ref, p.label as label, p.fk_product_type,";
        $sql .= " pa.qty as qty, pa.fk_product_fils as id, pa.incdec,";
        $sql .= " pa.rowid as fk_association, pa.rang";
        $sql .= " FROM " . $this->db->prefix() . "product as p,";
        $sql .= " " . $this->db->prefix() . "product_association as pa";
        $sql .= " WHERE p.rowid = pa.fk_product_fils";
        $sql .= " AND pa.fk_product_pere = " . ((int)$id);
        $sql .= " AND pa.fk_product_fils <> " . ((int)$id); // This should not happens, it is to avoid infinite loop if it happens
        $sql .= " ORDER BY pa.rang";

        dol_syslog(get_only_class($this) . '::getChildsArbo id=' . $id . ' level=' . $level . ' parents=' . (is_array($parents) ? implode(',', $parents) : $parents), LOG_DEBUG);

        if ($level == 1) {
            $alreadyfound = array($id => 1); // We init array of found object to start of tree, so if we found it later (should not happened), we stop immediately
        }
        // Protection against infinite loop
        if ($level > 30) {
            return array();
        }

        $res = $this->db->query($sql);
        if ($res) {
            $prods = array();
            while ($rec = $this->db->fetch_array($res)) {
                if (!empty($alreadyfound[$rec['rowid']])) {
                    dol_syslog(get_only_class($this) . '::getChildsArbo the product id=' . $rec['rowid'] . ' was already found at a higher level in tree. We discard to avoid infinite loop', LOG_WARNING);
                    if (in_array($rec['id'], $parents)) {
                        continue; // We discard this child if it is already found at a higher level in tree in the same branch.
                    }
                }
                $alreadyfound[$rec['rowid']] = 1;
                $prods[$rec['rowid']] = array(
                    0 => $rec['rowid'],
                    1 => $rec['qty'],
                    2 => $rec['fk_product_type'],
                    3 => $this->db->escape($rec['label']),
                    4 => $rec['incdec'],
                    5 => $rec['ref'],
                    6 => $rec['fk_association'],
                    7 => $rec['rang']
                );
                //$prods[$this->db->escape($rec['label'])]= array(0=>$rec['id'],1=>$rec['qty'],2=>$rec['fk_product_type']);
                //$prods[$this->db->escape($rec['label'])]= array(0=>$rec['id'],1=>$rec['qty']);
                if (empty($firstlevelonly)) {
                    $parents[] = $rec['rowid'];
                    $listofchilds = $this->getChildsArbo($rec['rowid'], 0, $level + 1, $parents);
                    foreach ($listofchilds as $keyChild => $valueChild) {
                        $prods[$rec['rowid']]['childs'][$keyChild] = $valueChild;
                    }
                }
            }

            return $prods;
        } else {
            dol_print_error($this->db);
            return -1;
        }
    }

    /**
     *  Create a document onto disk according to template module.
     *
     * @param string $modele Force model to use ('' to not force)
     * @param Translate $outputlangs Object langs to use for output
     * @param int $hidedetails Hide details of lines
     * @param int $hidedesc Hide description
     * @param int $hideref Hide ref
     * @return int                         0 if KO, 1 if OK
     */
    public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0)
    {
        global $conf, $user, $langs;

        $langs->load("products");
        $outputlangs->load("products");

        // Positionne le modele sur le nom du modele a utiliser
        if (!dol_strlen($modele)) {
            $modele = getDolGlobalString('PRODUCT_ADDON_PDF', 'strato');
        }

        $modelpath = "core/modules/product/doc/";

        return $this->commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref);
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Retour label of nature of product
     *
     * @return string|int        Return label or ''. -1 if error
     */
    public function getLibFinished()
    {
        global $langs;
        $langs->load('products');
        $label = '';

        if (isset($this->finished) && $this->finished >= 0) {
            $sql = "SELECT label, code FROM " . $this->db->prefix() . "c_product_nature where code = " . ((int)$this->finished) . " AND active=1";
            $resql = $this->db->query($sql);
            if (!$resql) {
                $this->error = $this->db->error() . ' sql=' . $sql;
                dol_syslog(__METHOD__ . ' Error ' . $this->error, LOG_ERR);
                return -1;
            } elseif ($this->db->num_rows($resql) > 0 && $res = $this->db->fetch_array($resql)) {
                $label = $langs->trans($res['label']);
            }
            $this->db->free($resql);
        }

        return $label;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Load existing information about a serial
     *
     * @param string $batch Lot/serial number
     * @return array                    Array with record into product_batch
     * @see    load_stock(), load_virtual_stock()
     */
    public function loadBatchInfo($batch)
    {
        $result = array();

        $sql = "SELECT pb.batch, pb.eatby, pb.sellby, SUM(pb.qty) AS qty FROM " . $this->db->prefix() . "product_batch as pb, " . $this->db->prefix() . "product_stock as ps";
        $sql .= " WHERE pb.fk_product_stock = ps.rowid AND ps.fk_product = " . ((int)$this->id) . " AND pb.batch = '" . $this->db->escape($batch) . "'";
        $sql .= " GROUP BY pb.batch, pb.eatby, pb.sellby";
        dol_syslog(get_only_class($this) . "::loadBatchInfo load first entry found for lot/serial = " . $batch, LOG_DEBUG);
        $resql = $this->db->query($sql);
        if ($resql) {
            $num = $this->db->num_rows($resql);
            $i = 0;
            while ($i < $num) {
                $obj = $this->db->fetch_object($resql);
                $result[] = array('batch' => $batch, 'eatby' => $this->db->jdate($obj->eatby), 'sellby' => $this->db->jdate($obj->sellby), 'qty' => $obj->qty);
                $i++;
            }
            return $result;
        } else {
            dol_print_error($this->db);
            $this->db->rollback();
            return array();
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Move an uploaded file described into $file array into target directory $sdir.
     *
     * @param string $sdir Target directory
     * @param string $file Array of file info of file to upload: array('name'=>..., 'tmp_name'=>...)
     * @return int                    Return integer <0 if KO, >0 if OK
     */
    public function add_photo($sdir, $file)
    {
        // phpcs:enable
        global $conf;

        include_once DOL_DOCUMENT_ROOT . '/core/lib/files.lib.php';

        $result = 0;

        $dir = $sdir;
        if (getDolGlobalInt('PRODUCT_USE_OLD_PATH_FOR_PHOTO')) {
            $dir .= '/' . get_exdir($this->id, 2, 0, 0, $this, 'product') . $this->id . "/photos";
        } else {
            $dir .= '/' . get_exdir(0, 0, 0, 0, $this, 'product') . dol_sanitizeFileName($this->ref);
        }

        dol_mkdir($dir);

        $dir_osencoded = $dir;

        if (is_dir($dir_osencoded)) {
            $originImage = $dir . '/' . $file['name'];

            // Cree fichier en taille origine
            $result = dol_move_uploaded_file($file['tmp_name'], $originImage, 1);

            if (file_exists(dol_osencode($originImage))) {
                // Create thumbs
                $this->addThumbs($originImage);
            }
        }

        if (is_numeric($result) && $result > 0) {
            return 1;
        } else {
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Return an array with all photos of product found on disk. There is no sorting criteria.
     *
     * @param string $dir Directory to scan
     * @param int $nbmax Number maximum of photos (0=no maximum)
     * @return array            Array of photos
     */
    public function liste_photos($dir, $nbmax = 0)
    {
        // phpcs:enable
        include_once DOL_DOCUMENT_ROOT . '/core/lib/files.lib.php';
        include_once DOL_DOCUMENT_ROOT . '/core/lib/images.lib.php';

        $nbphoto = 0;
        $tabobj = array();

        $dir_osencoded = dol_osencode($dir);
        $handle = @opendir($dir_osencoded);
        if (is_resource($handle)) {
            while (($file = readdir($handle)) !== false) {
                if (!utf8_check($file)) {
                    $file = mb_convert_encoding($file, 'UTF-8', 'ISO-8859-1'); // readdir returns ISO
                }
                if (dol_is_file($dir . $file) && image_format_supported($file) >= 0) {
                    $nbphoto++;

                    // We forge name of thumb.
                    $photo = $file;
                    $photo_vignette = '';
                    $regs = array();
                    if (preg_match('/(' . $this->regeximgext . ')$/i', $photo, $regs)) {
                        $photo_vignette = preg_replace('/' . $regs[0] . '/i', '', $photo) . '_small' . $regs[0];
                    }

                    $dirthumb = $dir . 'thumbs/';

                    // Object
                    $obj = array();
                    $obj['photo'] = $photo;
                    if ($photo_vignette && dol_is_file($dirthumb . $photo_vignette)) {
                        $obj['photo_vignette'] = 'thumbs/' . $photo_vignette;
                    } else {
                        $obj['photo_vignette'] = "";
                    }

                    $tabobj[$nbphoto - 1] = $obj;

                    // Do we have to continue with next photo ?
                    if ($nbmax && $nbphoto >= $nbmax) {
                        break;
                    }
                }
            }

            closedir($handle);
        }

        return $tabobj;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     *  Delete a photo and its thumbs
     *
     * @param string $file Path to image file
     * @return void
     */
    public function delete_photo($file)
    {
        // phpcs:enable
        include_once DOL_DOCUMENT_ROOT . '/core/lib/files.lib.php';
        include_once DOL_DOCUMENT_ROOT . '/core/lib/images.lib.php';

        $dir = dirname($file) . '/'; // Chemin du dossier contenant l'image d'origine
        $dirthumb = $dir . '/thumbs/'; // Chemin du dossier contenant la vignette
        $filename = preg_replace('/' . preg_quote($dir, '/') . '/i', '', $file); // Nom du fichier

        // On efface l'image d'origine
        dol_delete_file($file, 0, 0, 0, $this); // For triggers

        // Si elle existe, on efface la vignette
        if (preg_match('/(' . $this->regeximgext . ')$/i', $filename, $regs)) {
            $photo_vignette = preg_replace('/' . $regs[0] . '/i', '', $filename) . '_small' . $regs[0];
            if (file_exists(dol_osencode($dirthumb . $photo_vignette))) {
                dol_delete_file($dirthumb . $photo_vignette);
            }

            $photo_vignette = preg_replace('/' . $regs[0] . '/i', '', $filename) . '_mini' . $regs[0];
            if (file_exists(dol_osencode($dirthumb . $photo_vignette))) {
                dol_delete_file($dirthumb . $photo_vignette);
            }
        }
    }

    /**
     *  Load size of image file
     *
     * @param string $file Path to file
     * @return void
     */
    public function get_image_size($file)
    {
        // phpcs:enable
        $file_osencoded = dol_osencode($file);
        $infoImg = getimagesize($file_osencoded); // Get information on image
        $this->imgWidth = $infoImg[0]; // Largeur de l'image
        $this->imgHeight = $infoImg[1]; // Hauteur de l'image
    }

    /**
     *  Load indicators this->nb for the dashboard
     *
     * @return int                 Return integer <0 if KO, >0 if OK
     */
    public function loadStateBoard()
    {
        global $hookmanager;

        $this->nb = array();

        $sql = "SELECT count(p.rowid) as nb, fk_product_type";
        $sql .= " FROM " . $this->db->prefix() . "product as p";
        $sql .= ' WHERE p.entity IN (' . getEntity($this->element, 1) . ')';
        // Add where from hooks
        if (is_object($hookmanager)) {
            $parameters = array();
            $reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters, $this); // Note that $action and $object may have been modified by hook
            $sql .= $hookmanager->resPrint;
        }
        $sql .= ' GROUP BY fk_product_type';

        $resql = $this->db->query($sql);
        if ($resql) {
            while ($obj = $this->db->fetch_object($resql)) {
                if ($obj->fk_product_type == 1) {
                    $this->nb["services"] = $obj->nb;
                } else {
                    $this->nb["products"] = $obj->nb;
                }
            }
            $this->db->free($resql);
            return 1;
        } else {
            dol_print_error($this->db);
            $this->error = $this->db->error();
            return -1;
        }
    }

    /**
     * Return if object need to have its stock managed
     *
     * @return boolean     True if it's a service
     */
    public function isStockManaged()
    {
        return ($this->isProduct() || getDolGlobalString('STOCK_SUPPORTS_SERVICES'));
    }

    /**
     * Return if  object have a constraint on mandatory_period
     *
     * @return boolean     True if mandatory_period set to 1
     */
    public function isMandatoryPeriod()
    {
        return ($this->mandatory_period == 1 ? true : false);
    }

    /**
     *  Initialise an instance with random values.
     *  Used to build previews or test instances.
     *    id must be 0 if object instance is a specimen.
     *
     * @return int
     */
    public function initAsSpecimen()
    {
        $now = dol_now();

        // Initialize parameters
        $this->specimen = 1;
        $this->id = 0;
        $this->ref = 'PRODUCT_SPEC';
        $this->label = 'PRODUCT SPECIMEN';
        $this->description = 'This is description of this product specimen that was created the ' . dol_print_date($now, 'dayhourlog') . '.';
        $this->specimen = 1;
        $this->country_id = 1;
        $this->status = 1;
        $this->status_buy = 1;
        $this->tobatch = 0;
        $this->sell_or_eat_by_mandatory = 0;
        $this->note_private = 'This is a comment (private)';
        $this->note_public = 'This is a comment (public)';
        $this->date_creation = $now;
        $this->date_modification = $now;

        $this->weight = 4;
        $this->weight_units = 3;

        $this->length = 5;
        $this->length_units = 1;
        $this->width = 6;
        $this->width_units = 0;
        $this->height = null;
        $this->height_units = null;

        $this->surface = 30;
        $this->surface_units = 0;
        $this->volume = 300;
        $this->volume_units = 0;

        $this->barcode = -1; // Create barcode automatically

        return 1;
    }

    /**
     *    Returns the text label from units dictionary
     *
     * @param string $type Label type (long or short)
     * @return string|int Return integer <0 if ko, label if ok
     */
    public function getLabelOfUnit($type = 'long')
    {
        global $langs;

        if (!$this->fk_unit) {
0   == false // true
0   == null  // true
123 == false // false
123 == null  // false

// It is often better to use strict comparison
0 === false // false
0 === null  // false
            return '';
        }

        $langs->load('products');
        $label = '';
        $label_type = 'label';
        if ($type == 'short') {
            $label_type = 'short_label';
        }

        $sql = "SELECT " . $label_type . ", code from " . $this->db->prefix() . "c_units where rowid = " . ((int)$this->fk_unit);

        $resql = $this->db->query($sql);
        if (!$resql) {
            $this->error = $this->db->error();
            dol_syslog(get_only_class($this) . "::getLabelOfUnit Error " . $this->error, LOG_ERR);
            return -1;
        } elseif ($this->db->num_rows($resql) > 0 && $res = $this->db->fetch_array($resql)) {
            $label = ($label_type == 'short_label' ? $res[$label_type] : 'unit' . $res['code']);
        }
        $this->db->free($resql);

        return $label;
    }


    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Return minimum product recommended price
     *
     * @return int            Minimum recommended price that is higher price among all suppliers * PRODUCT_MINIMUM_RECOMMENDED_PRICE
     */
    public function min_recommended_price()
    {
        // phpcs:enable
        global $conf;

        $maxpricesupplier = 0;

        if (getDolGlobalString('PRODUCT_MINIMUM_RECOMMENDED_PRICE')) {
            include_once DOL_DOCUMENT_ROOT . '/fourn/class/fournisseur.product.class.php';
            $product_fourn = new ProductFournisseur($this->db);
            $product_fourn_list = $product_fourn->list_product_fournisseur_price($this->id, '', '');

            if (is_array($product_fourn_list) && count($product_fourn_list) > 0) {
                foreach ($product_fourn_list as $productfourn) {
                    if ($productfourn->fourn_unitprice > $maxpricesupplier) {
                        $maxpricesupplier = $productfourn->fourn_unitprice;
                    }
                }

                $maxpricesupplier *= getDolGlobalString('PRODUCT_MINIMUM_RECOMMENDED_PRICE');
            }
        }

        return $maxpricesupplier;
    }

    /**
     * Sets object to supplied categories.
     *
     * Deletes object from existing categories not supplied.
     * Adds it to non existing supplied categories.
     * Existing categories are left untouch.
     *
     * @param int[]|int $categories Category or categories IDs
     * @return int                          Return integer <0 if KO, >0 if OK
     */
    public function setCategories($categories)
    {
        return parent::setCategoriesCommon($categories, Categorie::TYPE_PRODUCT);
    }

    /**
     *  Load information for tab info
     *
     * @param int $id Id of thirdparty to load
     * @return void
     */
    public function info($id)
    {
        $sql = "SELECT p.rowid, p.ref, p.datec as date_creation, p.tms as date_modification,";
        $sql .= " p.fk_user_author, p.fk_user_modif";
        $sql .= " FROM " . $this->db->prefix() . $this->table_element . " as p";
        $sql .= " WHERE p.rowid = " . ((int)$id);

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

                $this->id = $obj->rowid;
                $this->ref = $obj->ref;

                $this->user_creation_id = $obj->fk_user_author;
                $this->user_modification_id = $obj->fk_user_modif;

                $this->date_creation = $this->db->jdate($obj->date_creation);
                $this->date_modification = $this->db->jdate($obj->date_modification);
            }

            $this->db->free($result);
        } else {
            dol_print_error($this->db);
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps

    /**
     * Return the duration of a service in hours (for a service based on duration fields)
     *
     * @return float|-1     Duration in hours if OK, -1 if KO

     */
    public function getProductDurationHours()
    {
        global $langs;

        if (empty($this->duration_value)) {
            $this->errors[] = 'ErrorDurationForServiceNotDefinedCantCalculateHourlyPrice';
            return -1;
        }

        if ($this->duration_unit == 'i') {
            $prodDurationHours = 1. / 60;
        }
        if ($this->duration_unit == 'h') {
            $prodDurationHours = 1.;
        }
        if ($this->duration_unit == 'd') {
            $prodDurationHours = 24.;
        }
        if ($this->duration_unit == 'w') {
            $prodDurationHours = 24. * 7;
        }
        if ($this->duration_unit == 'm') {
            $prodDurationHours = 24. * 30;
        }
        if ($this->duration_unit == 'y') {
            $prodDurationHours = 24. * 365;
        }
        $prodDurationHours *= $this->duration_value;

        return $prodDurationHours;
    }

    /**
     *  Return clicable link of object (with eventually picto)
     *
     * @param string $option Where point the link (0=> main card, 1,2 => shipment, 'nolink'=>No link)
     * @param array $arraydata Array of data
     * @return     string                              HTML Code for Kanban thumb.
     */
    public function getKanbanView($option = '', $arraydata = null)
    {
        global $langs, $conf;

        $selected = (empty($arraydata['selected']) ? 0 : $arraydata['selected']);

        $return = '<div class="box-flex-item box-flex-grow-zero">';
        $return .= '<div class="info-box info-box-sm">';
        $return .= '<div class="info-box-img">';
        $label = '';
        if ($this->is_photo_available($conf->product->multidir_output[$this->entity])) {
            $label .= $this->show_photos('product', $conf->product->multidir_output[$this->entity], 1, 1, 0, 0, 0, 120, 160, 0, 0, 0, '', 'photoref photokanban');
            $return .= $label;
        } else {
            if ($this->type == Product::TYPE_PRODUCT) {
                $label .= img_picto('', 'product');
            } elseif ($this->type == Product::TYPE_SERVICE) {
                $label .= img_picto('', 'service');
            }
            $return .= $label;
        }
        $return .= '</div>';
        $return .= '<div class="info-box-content">';
        $return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">' . (method_exists($this, 'getNomUrl') ? $this->getNomUrl() : $this->ref) . '</span>';
        if ($selected >= 0) {
            $return .= '<input id="cb' . $this->id . '" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="' . $this->id . '"' . ($selected ? ' checked="checked"' : '') . '>';
        }
        if (property_exists($this, 'label')) {
            $return .= '<br><span class="info-box-label opacitymedium inline-block tdoverflowmax150 valignmiddle" title="' . dol_escape_htmltag($this->label) . '">' . dol_escape_htmltag($this->label) . '</span>';
        }
        if (property_exists($this, 'price') && property_exists($this, 'price_ttc')) {
            if ($this->price_base_type == 'TTC') {
                $return .= '<br><span class="info-box-status amount">' . price($this->price_ttc) . ' ' . $langs->trans("TTC") . '</span>';
            } else {
                if ($this->status) {
                    $return .= '<br><span class="info-box-status amount">' . price($this->price) . ' ' . $langs->trans("HT") . '</span>';
                }
            }
        }
        $br = 1;
        if (property_exists($this, 'stock_reel') && $this->isProduct()) {
            $return .= '<br><div class="info-box-status opacitymedium inline-block valignmiddle">' . img_picto($langs->trans('PhysicalStock'), 'stock') . '</div><div class="inline-block valignmiddle paddingleft" title="' . $langs->trans('PhysicalStock') . '">' . $this->stock_reel . '</div>';
            $br = 0;
        }
        if (method_exists($this, 'getLibStatut')) {
            if ($br) {
                $return .= '<br><div class="info-box-status inline-block valignmiddle">' . $this->getLibStatut(3, 1) . ' ' . $this->getLibStatut(3, 0) . '</div>';
            } else {
                $return .= '<div class="info-box-status inline-block valignmiddle marginleftonly paddingleft">' . $this->getLibStatut(3, 1) . ' ' . $this->getLibStatut(3, 0) . '</div>';
            }
        }
        $return .= '</div>';
        $return .= '</div>';
        $return .= '</div>';
        return $return;
    }

    /**
     *  Return if at least one photo is available
     *
     * @param string $sdir Directory to scan
     * @return boolean                 True if at least one photo is available, False if not
     */
    public function is_photo_available($sdir)
    {
        // phpcs:enable
        include_once DOL_DOCUMENT_ROOT . '/core/lib/files.lib.php';
        include_once DOL_DOCUMENT_ROOT . '/core/lib/images.lib.php';

        global $conf;

        $dir = $sdir;
        if (getDolGlobalInt('PRODUCT_USE_OLD_PATH_FOR_PHOTO')) {
            $dir .= '/' . get_exdir($this->id, 2, 0, 0, $this, 'product') . $this->id . "/photos/";
        } else {
            $dir .= '/' . get_exdir(0, 0, 0, 0, $this, 'product');
        }

        $nbphoto = 0;

        $dir_osencoded = dol_osencode($dir);
        if (file_exists($dir_osencoded)) {
            $handle = opendir($dir_osencoded);
            if (is_resource($handle)) {
                while (($file = readdir($handle)) !== false) {
                    if (!utf8_check($file)) {
                        $file = mb_convert_encoding($file, 'UTF-8', 'ISO-8859-1'); // To be sure data is stored in UTF8 in memory
                    }
                    if (dol_is_file($dir . $file) && image_format_supported($file) >= 0) {
                        return true;
                    }
                }
            }
        }
        return false;
    }

    /**
     *    Return clickable link of object (with eventually picto)
     *
     * @param int $withpicto Add picto into link
     * @param string $option Where point the link ('stock', 'composition', 'category', 'supplier', '')
     * @param int $maxlength Maxlength of ref
     * @param int $save_lastsearch_value -1=Auto, 0=No save of lastsearch_values when clicking, 1=Save lastsearch_values when clicking
     * @param int $notooltip No tooltip
     * @param string $morecss ''=Add more css on link
     * @param int $add_label 0=Default, 1=Add label into string, >1=Add first chars into string
     * @param string $sep ' - '=Separator between ref and label if option 'add_label' is set
     * @return  string                          String with URL
     */
    public function getNomUrl($withpicto = 0, $option = '', $maxlength = 0, $save_lastsearch_value = -1, $notooltip = 0, $morecss = '', $add_label = 0, $sep = ' - ')
    {
        global $conf, $langs, $hookmanager, $user;
        include_once DOL_DOCUMENT_ROOT . '/core/lib/product.lib.php';

        $result = '';

        $newref = $this->ref;
        if ($maxlength) {
            $newref = dol_trunc($newref, $maxlength, 'middle');
        }
        $params = [
            'id' => $this->id,
            'objecttype' => (isset($this->type) ? ($this->type == 1 ? 'service' : 'product') : $this->element),
            'option' => $option,
            'nofetch' => 1,
        ];
        $classfortooltip = 'classfortooltip';
        $dataparams = '';
        if (getDolGlobalInt('MAIN_ENABLE_AJAX_TOOLTIP')) {
            $classfortooltip = 'classforajaxtooltip';
            $dataparams = ' data-params="' . dol_escape_htmltag(json_encode($params)) . '"';
            $label = '';
        } else {
            $label = implode($this->getTooltipContentArray($params));
        }

        $linkclose = '';
        if (empty($notooltip)) {
            if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
                $label = $langs->trans("ShowProduct");
                $linkclose .= ' alt="' . dol_escape_htmltag($label, 1, 1) . '"';
            }
            $linkclose .= ($label ? ' title="' . dol_escape_htmltag($label, 1, 1) . '"' : ' title="tocomplete"');
            $linkclose .= $dataparams . ' class="nowraponall ' . $classfortooltip . ($morecss ? ' ' . $morecss : '') . '"';
        } else {
            $linkclose = ' class="nowraponall' . ($morecss ? ' ' . $morecss : '') . '"';
        }

        if ($option == 'supplier' || $option == 'category') {
            $url = constant('BASE_URL') . '/product/price_suppliers.php?id=' . $this->id;
        } elseif ($option == 'stock') {
            $url = constant('BASE_URL') . '/product/stock/product.php?id=' . $this->id;
        } elseif ($option == 'composition') {
            $url = constant('BASE_URL') . '/product/composition/card.php?id=' . $this->id;
        } else {
            $url = constant('BASE_URL') . '/product/card.php?id=' . $this->id;
        }

        if ($option !== 'nolink') {
            // Add param to save lastsearch_values or not
            $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
            if ($save_lastsearch_value == -1 && isset($_SERVER["PHP_SELF"]) && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
                $add_save_lastsearch_values = 1;
            }
            if ($add_save_lastsearch_values) {
                $url .= '&save_lastsearch_values=1';
            }
        }

        $linkstart = '<a href="' . $url . '"';
        $linkstart .= $linkclose . '>';
        $linkend = '</a>';

        $result .= $linkstart;
        if ($withpicto) {
            if ($this->type == Product::TYPE_PRODUCT) {
                $result .= (img_object(($notooltip ? '' : $label), 'product', 'class="paddingright"', 0, 0, $notooltip ? 0 : 1));
            }
            if ($this->type == Product::TYPE_SERVICE) {
                $result .= (img_object(($notooltip ? '' : $label), 'service', 'class="paddingright"', 0, 0, $notooltip ? 0 : 1));
            }
        }
        $result .= '<span class="aaa">' . dol_escape_htmltag($newref) . '</span>';
        $result .= $linkend;
        if ($withpicto != 2) {
            $result .= (($add_label && $this->label) ? $sep . dol_trunc($this->label, ($add_label > 1 ? $add_label : 0)) : '');
        }

        global $action;
        $hookmanager->initHooks(array('productdao'));
        $parameters = array('id' => $this->id, 'getnomurl' => &$result, 'label' => &$label);
        $reshook = $hookmanager->executeHooks('getNomUrl', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
        if ($reshook > 0) {
            $result = $hookmanager->resPrint;
        } else {
            $result .= $hookmanager->resPrint;
        }

        return $result;
    }

    /**
     * getTooltipContentArray
     * @param array $params params to construct tooltip data
     * @return array
     * @since v18
     */
    public function getTooltipContentArray($params)
    {
        global $conf, $langs, $user;

        $langs->loadLangs(array('products', 'other'));

        $datas = array();
        $nofetch = !empty($params['nofetch']);

        if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
            return ['optimize' => $langs->trans("ShowProduct")];
        }

        if (!empty($this->entity)) {
            $tmpphoto = $this->show_photos('product', $conf->product->multidir_output[$this->entity], 1, 1, 0, 0, 0, 80, 0, 0, 0, 0, 1);
            if ($this->nbphoto > 0) {
                $datas['photo'] = '<div class="photointooltip floatright">' . "\n" . $tmpphoto . '</div>';
            }
        }

        if ($this->type == Product::TYPE_PRODUCT) {
            $datas['picto'] = img_picto('', 'product') . ' <u class="paddingrightonly">' . $langs->trans("Product") . '</u>';
        } elseif ($this->type == Product::TYPE_SERVICE) {
            $datas['picto'] = img_picto('', 'service') . ' <u class="paddingrightonly">' . $langs->trans("Service") . '</u>';
        }
        if (isset($this->status) && isset($this->status_buy)) {
            $datas['status'] = ' ' . $this->getLibStatut(5, 0) . ' ' . $this->getLibStatut(5, 1);
        }

        if (!empty($this->ref)) {
            $datas['ref'] = '<br><b>' . $langs->trans('ProductRef') . ':</b> ' . $this->ref;
        }
        if (!empty($this->label)) {
            $datas['label'] = '<br><b>' . $langs->trans('ProductLabel') . ':</b> ' . $this->label;
        }
        if (!empty($this->description)) {
            $datas['description'] = '<br><b>' . $langs->trans('ProductDescription') . ':</b> ' . dolGetFirstLineOfText($this->description, 5);
        }
        if ($this->type == Product::TYPE_PRODUCT || getDolGlobalString('STOCK_SUPPORTS_SERVICES')) {
            if (isModEnabled('productbatch')) {
                $langs->load("productbatch");
                $datas['batchstatus'] = "<br><b>" . $langs->trans("ManageLotSerial") . '</b>: ' . $this->getLibStatut(0, 2);
            }
        }
        if (isModEnabled('barcode')) {
            $datas['barcode'] = '<br><b>' . $langs->trans('BarCode') . ':</b> ' . $this->barcode;
        }

        if ($this->type == Product::TYPE_PRODUCT) {
            if ($this->weight) {
                $datas['weight'] = "<br><b>" . $langs->trans("Weight") . '</b>: ' . $this->weight . ' ' . measuringUnitString(0, "weight", $this->weight_units);
            }
            $labelsize = "";
            if ($this->length) {
                $labelsize .= ($labelsize ? " - " : "") . "<b>" . $langs->trans("Length") . '</b>: ' . $this->length . ' ' . measuringUnitString(0, 'size', $this->length_units);
            }
            if ($this->width) {
                $labelsize .= ($labelsize ? " - " : "") . "<b>" . $langs->trans("Width") . '</b>: ' . $this->width . ' ' . measuringUnitString(0, 'size', $this->width_units);
            }
            if ($this->height) {
                $labelsize .= ($labelsize ? " - " : "") . "<b>" . $langs->trans("Height") . '</b>: ' . $this->height . ' ' . measuringUnitString(0, 'size', $this->height_units);
            }
            if ($labelsize) {
                $datas['size'] = "<br>" . $labelsize;
            }

            $labelsurfacevolume = "";
            if ($this->surface) {
                $labelsurfacevolume .= ($labelsurfacevolume ? " - " : "") . "<b>" . $langs->trans("Surface") . '</b>: ' . $this->surface . ' ' . measuringUnitString(0, 'surface', $this->surface_units);
            }
            if ($this->volume) {
                $labelsurfacevolume .= ($labelsurfacevolume ? " - " : "") . "<b>" . $langs->trans("Volume") . '</b>: ' . $this->volume . ' ' . measuringUnitString(0, 'volume', $this->volume_units);
            }
            if ($labelsurfacevolume) {
                $datas['surface'] = "<br>" . $labelsurfacevolume;
            }
        }
        if ($this->type == Product::TYPE_SERVICE && !empty($this->duration_value)) {
            // Duration
            $datas['duration'] = '<br><b>' . $langs->trans("Duration") . ':</b> ' . $this->duration_value;
            if ($this->duration_value > 1) {
                $dur = array("i" => $langs->trans("Minutes"), "h" => $langs->trans("Hours"), "d" => $langs->trans("Days"), "w" => $langs->trans("Weeks"), "m" => $langs->trans("Months"), "y" => $langs->trans("Years"));
            } elseif ($this->duration_value > 0) {
                $dur = array("i" => $langs->trans("Minute"), "h" => $langs->trans("Hour"), "d" => $langs->trans("Day"), "w" => $langs->trans("Week"), "m" => $langs->trans("Month"), "y" => $langs->trans("Year"));
            }
            $datas['duration'] .= (!empty($this->duration_unit) && isset($dur[$this->duration_unit]) ? "&nbsp;" . $langs->trans($dur[$this->duration_unit]) : '');
        }
        if (empty($user->socid)) {
            if (!empty($this->pmp) && $this->pmp) {
                $datas['pmp'] = "<br><b>" . $langs->trans("PMPValue") . '</b>: ' . price($this->pmp, 0, '', 1, -1, -1, $conf->currency);
            }

            if (isModEnabled('accounting')) {
                if ($this->status && isset($this->accountancy_code_sell)) {
                    include_once DOL_DOCUMENT_ROOT . '/core/lib/accounting.lib.php';
                    $selllabel = '<br>';
                    $selllabel .= '<br><b>' . $langs->trans('ProductAccountancySellCode') . ':</b> ' . length_accountg($this->accountancy_code_sell);
                    $selllabel .= '<br><b>' . $langs->trans('ProductAccountancySellIntraCode') . ':</b> ' . length_accountg($this->accountancy_code_sell_intra);
                    $selllabel .= '<br><b>' . $langs->trans('ProductAccountancySellExportCode') . ':</b> ' . length_accountg($this->accountancy_code_sell_export);
                    $datas['accountancysell'] = $selllabel;
                }
                if ($this->status_buy && isset($this->accountancy_code_buy)) {
                    include_once DOL_DOCUMENT_ROOT . '/core/lib/accounting.lib.php';
                    $buylabel = '';
                    if (empty($this->status)) {
                        $buylabel .= '<br>';
                    }
                    $buylabel .= '<br><b>' . $langs->trans('ProductAccountancyBuyCode') . ':</b> ' . length_accountg($this->accountancy_code_buy);
                    $buylabel .= '<br><b>' . $langs->trans('ProductAccountancyBuyIntraCode') . ':</b> ' . length_accountg($this->accountancy_code_buy_intra);
                    $buylabel .= '<br><b>' . $langs->trans('ProductAccountancyBuyExportCode') . ':</b> ' . length_accountg($this->accountancy_code_buy_export);
                    $datas['accountancybuy'] = $buylabel;
                }
            }
        }
        // show categories for this record only in ajax to not overload lists
        if (isModEnabled('category') && !$nofetch) {
            $form = new Form($this->db);
            $datas['categories'] = '<br>' . $form->showCategories($this->id, Categorie::TYPE_PRODUCT, 1);
        }

        return $datas;
    }

    /**
     *    Return label of status of object
     *
     * @param int $mode 0=long label, 1=short label, 2=Picto + short label, 3=Picto, 4=Picto + long label, 5=Short label + Picto
     * @param int $type 0=Sell, 1=Buy, 2=Batch Number management
     * @return string          Label of status
     */
    public function getLibStatut($mode = 0, $type = 0)
    {
        switch ($type) {
            case 0:
                return $this->LibStatut($this->status, $mode, $type);
            case 1:
                return $this->LibStatut($this->status_buy, $mode, $type);
            case 2:
                return $this->LibStatut($this->status_batch, $mode, $type);
            default:
                //Simulate previous behavior but should return an error string
                return $this->LibStatut($this->status_buy, $mode, $type);
        }
    }

    /**
     *    Return label of a given status
     *
     * @param int $status Statut
     * @param int $mode 0=long label, 1=short label, 2=Picto + short label, 3=Picto, 4=Picto + long label, 5=Short label + Picto, 6=Long label + Picto
     * @param int $type 0=Status "to sell", 1=Status "to buy", 2=Status "to Batch"
     * @return string               Label of status
     */
    public function LibStatut($status, $mode = 0, $type = 0)
    {
        // phpcs:enable
        global $conf, $langs;

        $labelStatus = $labelStatusShort = '';

        $langs->load('products');
        if (isModEnabled('productbatch')) {
            $langs->load("productbatch");
        }

        if ($type == 2) {
            switch ($mode) {
                case 0:
                    $label = ($status == 0 ? $langs->transnoentitiesnoconv('ProductStatusNotOnBatch') : ($status == 1 ? $langs->transnoentitiesnoconv('ProductStatusOnBatch') : $langs->transnoentitiesnoconv('ProductStatusOnSerial')));
                    return dolGetStatus($label);
                case 1:
                    $label = ($status == 0 ? $langs->transnoentitiesnoconv('ProductStatusNotOnBatchShort') : ($status == 1 ? $langs->transnoentitiesnoconv('ProductStatusOnBatchShort') : $langs->transnoentitiesnoconv('ProductStatusOnSerialShort')));
                    return dolGetStatus($label);
                case 2:
                    return $this->LibStatut($status, 3, 2) . ' ' . $this->LibStatut($status, 1, 2);
                case 3:
                    return dolGetStatus($langs->transnoentitiesnoconv('ProductStatusNotOnBatch'), '', '', empty($status) ? 'status5' : 'status4', 3, 'dot');
                case 4:
                    return $this->LibStatut($status, 3, 2) . ' ' . $this->LibStatut($status, 0, 2);
                case 5:
                    return $this->LibStatut($status, 1, 2) . ' ' . $this->LibStatut($status, 3, 2);
                default:
                    return dolGetStatus($langs->transnoentitiesnoconv('Unknown'));
            }
        }

        $statuttrans = empty($status) ? 'status5' : 'status4';

        if ($status == 0) {
            // $type   0=Status "to sell", 1=Status "to buy", 2=Status "to Batch"
            if ($type == 0) {
                $labelStatus = $langs->transnoentitiesnoconv('ProductStatusNotOnSellShort');
                $labelStatusShort = $langs->transnoentitiesnoconv('ProductStatusNotOnSell');
            } elseif ($type == 1) {
                $labelStatus = $langs->transnoentitiesnoconv('ProductStatusNotOnBuyShort');
                $labelStatusShort = $langs->transnoentitiesnoconv('ProductStatusNotOnBuy');
            } elseif ($type == 2) {
                $labelStatus = $langs->transnoentitiesnoconv('ProductStatusNotOnBatch');
                $labelStatusShort = $langs->transnoentitiesnoconv('ProductStatusNotOnBatchShort');
            }
        } elseif ($status == 1) {
            // $type   0=Status "to sell", 1=Status "to buy", 2=Status "to Batch"
            if ($type == 0) {
                $labelStatus = $langs->transnoentitiesnoconv('ProductStatusOnSellShort');
                $labelStatusShort = $langs->transnoentitiesnoconv('ProductStatusOnSell');
            } elseif ($type == 1) {
                $labelStatus = $langs->transnoentitiesnoconv('ProductStatusOnBuyShort');
                $labelStatusShort = $langs->transnoentitiesnoconv('ProductStatusOnBuy');
            } elseif ($type == 2) {
                $labelStatus = ($status == 1 ? $langs->transnoentitiesnoconv('ProductStatusOnBatch') : $langs->transnoentitiesnoconv('ProductStatusOnSerial'));
                $labelStatusShort = ($status == 1 ? $langs->transnoentitiesnoconv('ProductStatusOnBatchShort') : $langs->transnoentitiesnoconv('ProductStatusOnSerialShort'));
            }
        } elseif ($type == 2 && $status == 2) {
            $labelStatus = $langs->transnoentitiesnoconv('ProductStatusOnSerial');
            $labelStatusShort = $langs->transnoentitiesnoconv('ProductStatusOnSerialShort');
        }

        if ($mode > 6) {
            return dolGetStatus($langs->transnoentitiesnoconv('Unknown'), '', '', 'status0', 0);
        } else {
            return dolGetStatus($labelStatus, $labelStatusShort, '', $statuttrans, $mode);
        }
    }

    /**
     * Returns the rights used for this class
     *
     * @return Object
     */
    public function getRights()
    {
        global $user;

        if ($this->isProduct()) {
            return $user->rights->produit;
        } else {
            return $user->rights->service;
        }
    }
}

alxarafe / alixar

Product::hasbatch() A last analyzed 2024-11-03 11:50 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

Product::hasbatch() A
last analyzed 2024-11-03 11:50 UTC
