Propal

Complexity

Total Complexity

490

Size/Duplication

Total Lines	3291
Duplicated Lines	0 %

Importance

Changes

0

<?php
class Propal extends CommonObject
{

    /**
     * @var string ID to identify managed object
     */
    public $element = 'propal';

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

    /**
     * @var int    Name of subtable line
     */
    public $table_element_line = 'propaldet';

    /**
     * @var int Field with ID of parent key if this field has a parent
     */
    public $fk_element = 'fk_propal';

    /**
     * @var string String with name of icon for myobject. Must be the part after the 'object_' into object_myobject.png
     */
    public $picto = 'propal';

    /**
     * 0=No test on entity, 1=Test with field entity, 2=Test with link by societe
     * @var int
     */
    public $ismultientitymanaged = 1;

    /**
     * 0=Default, 1=View may be restricted to sales representative only if no permission to see all or to company of external user if external user
     * @var integer
     */
    public $restrictiononfksoc = 1;

    /**
     * {@inheritdoc}
     */
    protected $table_ref_field = 'ref';

    /**
     * ID of the client
     * @var int
     */
    public $socid;
    public $contactid;
    public $author;
    public $ref_client;

    /**
     * Status of the quote
     * @var int
     * @see Propal::STATUS_DRAFT, Propal::STATUS_VALIDATED, Propal::STATUS_SIGNED, Propal::STATUS_NOTSIGNED, Propal::STATUS_BILLED
     */
    public $statut;

    /**
     * @deprecated
     * @see date_creation
     */
    public $datec;

    /**
     * Creation date
     * @var int
     */
    public $date_creation;

    /**
     * @deprecated
     * @see date_validation
     */
    public $datev;

    /**
     * Validation date
     * @var int
     */
    public $date_validation;

    /**
     * Date of the quote
     * @var
     */
    public $date;

    /**
     * @deprecated
     * @see date
     */
    public $datep;
    public $date_livraison;
    public $fin_validite;
    public $user_author_id;
    public $user_valid_id;
    public $user_close_id;

    /**
     * @deprecated
     * @see total_ht
     */
    public $price;

    /**
     * @deprecated
     * @see total_tva
     */
    public $tva;

    /**
     * @deprecated
     * @see total_ttc
     */
    public $total;
    public $cond_reglement_code;
    public $mode_reglement_code;
    public $remise = 0;
    public $remise_percent = 0;
    public $remise_absolue = 0;

    /**
     * @var int ID
     */
    public $fk_address;
    public $address_type;
    public $address;
    public $availability_id;
    public $availability_code;
    public $demand_reason_id;
    public $demand_reason_code;
    public $products = array();
    public $extraparams = array();

    /**
     * @var PropaleLigne[]
     */
    public $lines = array();
    public $line;
    public $labelstatut = array();
    public $labelstatut_short = array();
    public $specimen;
    // Multicurrency
    /**
     * @var int ID
     */
    public $fk_multicurrency;
    public $multicurrency_code;
    public $multicurrency_tx;
    public $multicurrency_total_ht;
    public $multicurrency_total_tva;
    public $multicurrency_total_ttc;
    public $oldcopy;

    /**
     * Draft status
     */
    const STATUS_DRAFT = 0;

    /**
     * Validated status
     */
    const STATUS_VALIDATED = 1;

    /**
     * Signed quote
     */
    const STATUS_SIGNED = 2;

    /**
     * Not signed quote
     */
    const STATUS_NOTSIGNED = 3;

    /**
     * Billed or processed quote
     */
    const STATUS_BILLED = 4;   // Todo rename into STATUS_CLOSE


    /**
     * 	Constructor
     *
     * 	@param      DoliDB	$db         Database handler
     * 	@param      int		$socid		Id third party
     * 	@param      int		$propalid   Id proposal
     */
    function __construct($db, $socid = "", $propalid = 0)
    {
        global $conf, $langs;

        $this->db = $db;

        $this->socid = $socid;
        $this->id = $propalid;

        $this->products = array();

        $this->duree_validite = $conf->global->PROPALE_VALIDITY_DURATION;
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     *  Add line into array products
     *  $this->thirdparty should be loaded
     *
     * 	@param  int		$idproduct       	Product Id to add
     * 	@param  int		$qty             	Quantity
     * 	@param  int		$remise_percent  	Discount effected on Product
     *  @return	int							<0 if KO, >0 if OK
     *
     * 	TODO	Replace calls to this function by generation objet Ligne
     * 			inserted into table $this->products
     */
    function add_product($idproduct, $qty, $remise_percent = 0)
    {
        // phpcs:enable
        global $conf, $mysoc;

        if (!$qty)
            $qty = 1;

        dol_syslog(get_class($this) . "::add_product $idproduct, $qty, $remise_percent");
        if ($idproduct > 0) {
            $prod = new Product($this->db);
            $prod->fetch($idproduct);

            $productdesc = $prod->description;

            $tva_tx = get_default_tva($mysoc, $this->thirdparty, $prod->id);
            $tva_npr = get_default_npr($mysoc, $this->thirdparty, $prod->id);
            if (empty($tva_tx))
                $tva_npr = 0;
            $vat_src_code = '';     // May be defined into tva_tx

            $localtax1_tx = get_localtax($tva_tx, 1, $mysoc, $this->thirdparty, $tva_npr);
            $localtax2_tx = get_localtax($tva_tx, 2, $mysoc, $this->thirdparty, $tva_npr);

            // multiprices
            if ($conf->global->PRODUIT_MULTIPRICES && $this->thirdparty->price_level) {
                $price = $prod->multiprices[$this->thirdparty->price_level];
            } else {
                $price = $prod->price;
            }

            $line = new PropaleLigne($this->db);

            $line->fk_product = $idproduct;
            $line->desc = $productdesc;
            $line->qty = $qty;
            $line->subprice = $price;
            $line->remise_percent = $remise_percent;
            $line->vat_src_code = $vat_src_code;
            $line->tva_tx = $tva_tx;
            $line->fk_unit = $prod->fk_unit;
            if ($tva_npr)
                $line->info_bits = 1;

            $this->lines[] = $line;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     * 	Adding line of fixed discount in the proposal in DB
     *
     * 	@param     int		$idremise			Id of fixed discount
     *  @return    int          				>0 if OK, <0 if KO
     */
    function insert_discount($idremise)
    {
        // phpcs:enable
        global $langs;

        include_once DOL_DOCUMENT_ROOT . '/core/lib/price.lib.php';
        include_once DOL_DOCUMENT_ROOT . '/core/class/discount.class.php';

        $this->db->begin();

        $remise = new DiscountAbsolute($this->db);
        $result = $remise->fetch($idremise);

        if ($result > 0) {
            if ($remise->fk_facture) { // Protection against multiple submission
                $this->error = $langs->trans("ErrorDiscountAlreadyUsed");
                $this->db->rollback();
                return -5;
            }

            $line = new PropaleLigne($this->db);

            $this->line->context = $this->context;

            $line->fk_propal = $this->id;
            $line->fk_remise_except = $remise->id;
            $line->desc = $remise->description;    // Description ligne
            $line->vat_src_code = $remise->vat_src_code;
            $line->tva_tx = $remise->tva_tx;
            $line->subprice = -$remise->amount_ht;
            $line->fk_product = 0;     // Id produit predefined
            $line->qty = 1;
            $line->remise = 0;
            $line->remise_percent = 0;
            $line->rang = -1;
            $line->info_bits = 2;

            // TODO deprecated
            $line->price = -$remise->amount_ht;

            $line->total_ht = -$remise->amount_ht;
            $line->total_tva = -$remise->amount_tva;
            $line->total_ttc = -$remise->amount_ttc;

            $result = $line->insert();
            if ($result > 0) {
                $result = $this->update_price(1);
                if ($result > 0) {
                    $this->db->commit();
                    return 1;
                } else {
                    $this->db->rollback();
                    return -1;
                }
            } else {
                $this->error = $line->error;
                $this->db->rollback();
                return -2;
            }
        } else {
            $this->db->rollback();
            return -2;
        }
    }

    /**
     *    	Add a proposal line into database (linked to product/service or not)
     *      The parameters are already supposed to be appropriate and with final values to the call
     *      of this method. Also, for the VAT rate, it must have already been defined
     *      by whose calling the method get_default_tva (societe_vendeuse, societe_acheteuse, '' product)
     *      and desc must already have the right value (it's up to the caller to manage multilanguage)
     *
     * 		@param    	string		$desc				Description of line
     * 		@param    	float		$pu_ht				Unit price
     * 		@param    	float		$qty             	Quantity
     * 		@param    	float		$txtva           	Force Vat rate, -1 for auto (Can contain the vat_src_code too with syntax '9.9 (CODE)')
     * 		@param		float		$txlocaltax1		Local tax 1 rate (deprecated, use instead txtva with code inside)
     *  	@param		float		$txlocaltax2		Local tax 2 rate (deprecated, use instead txtva with code inside)
     * 		@param    	int			$fk_product      	Id du produit/service predefini
     * 		@param    	float		$remise_percent  	Pourcentage de remise de la ligne
     * 		@param    	string		$price_base_type	HT or TTC
     * 		@param    	float		$pu_ttc             Prix unitaire TTC
     * 		@param    	int			$info_bits			Bits de type de lignes
     *      @param      int			$type               Type of line (0=product, 1=service). Not used if fk_product is defined, the type of product is used.
     *      @param      int			$rang               Position of line
     *      @param		int			$special_code		Special code (also used by externals modules!)
     *      @param		int			$fk_parent_line		Id of parent line
     *      @param		int			$fk_fournprice		Id supplier price
     *      @param		int			$pa_ht				Buying price without tax
     *      @param		string		$label				???
     * 		@param      int			$date_start       	Start date of the line
     * 		@param      int			$date_end         	End date of the line
     *      @param		array		$array_options		extrafields array
     * 		@param 		string		$fk_unit 			Code of the unit to use. Null to use the default one
     *      @param		string		$origin				'order', ...
     *      @param		int			$origin_id			Id of origin object
     * 		@param		double		$pu_ht_devise		Unit price in currency
     * 		@param		int    		$fk_remise_except	Id discount if line is from a discount
     *    	@return    	int         	    			>0 if OK, <0 if KO
     *    	@see       	add_product
     */
    function addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1 = 0.0, $txlocaltax2 = 0.0, $fk_product = 0, $remise_percent = 0.0, $price_base_type = 'HT', $pu_ttc = 0.0, $info_bits = 0, $type = 0, $rang = -1, $special_code = 0, $fk_parent_line = 0, $fk_fournprice = 0, $pa_ht = 0, $label = '', $date_start = '', $date_end = '', $array_options = 0, $fk_unit = null, $origin = '', $origin_id = 0, $pu_ht_devise = 0, $fk_remise_except = 0)
    {
        global $mysoc, $conf, $langs;

        dol_syslog(get_class($this) . "::addline propalid=$this->id, desc=$desc, pu_ht=$pu_ht, qty=$qty, txtva=$txtva, fk_product=$fk_product, remise_except=$remise_percent, price_base_type=$price_base_type, pu_ttc=$pu_ttc, info_bits=$info_bits, type=$type, fk_remise_except=" . $fk_remise_except);
        if ($this->statut == self::STATUS_DRAFT) {
            include_once DOL_DOCUMENT_ROOT . '/core/lib/price.lib.php';

            // Clean parameters
            if (empty($remise_percent))
                $remise_percent = 0;
            if (empty($qty))
                $qty = 0;
            if (empty($info_bits))
                $info_bits = 0;
            if (empty($rang))
                $rang = 0;
            if (empty($fk_parent_line) || $fk_parent_line < 0)
                $fk_parent_line = 0;

            $remise_percent = price2num($remise_percent);
            $qty = price2num($qty);
            $pu_ht = price2num($pu_ht);
            $pu_ht_devise = price2num($pu_ht_devise);
            $pu_ttc = price2num($pu_ttc);
            if (!preg_match('/\((.*)\)/', $txtva)) {
                $txtva = price2num($txtva);               // $txtva can have format '5,1' or '5.1' or '5.1(XXX)', we must clean only if '5,1'
            }
            $txlocaltax1 = price2num($txlocaltax1);
            $txlocaltax2 = price2num($txlocaltax2);
            $pa_ht = price2num($pa_ht);
            if ($price_base_type == 'HT') {
                $pu = $pu_ht;
            } else {
                $pu = $pu_ttc;
            }

            // Check parameters
            if ($type < 0)
                return -1;

            $this->db->begin();

            $product_type = $type;
            if (!empty($fk_product)) {
                $product = new Product($this->db);
                $result = $product->fetch($fk_product);
                $product_type = $product->type;

                if (!empty($conf->global->STOCK_MUST_BE_ENOUGH_FOR_PROPOSAL) && $product_type == 0 && $product->stock_reel < $qty) {
                    $langs->load("errors");
                    $this->error = $langs->trans('ErrorStockIsNotEnoughToAddProductOnProposal', $product->ref);
                    $this->db->rollback();
                    return -3;
                }
            }

            // Calcul du total TTC et de la TVA pour la ligne a partir de
            // qty, pu, remise_percent et txtva
            // TRES IMPORTANT: C'est au moment de l'insertion ligne qu'on doit stocker
            // la part ht, tva et ttc, et ce au niveau de la ligne qui a son propre taux tva.

            $localtaxes_type = getLocalTaxesFromRate($txtva, 0, $this->thirdparty, $mysoc);

            // Clean vat code
            $vat_src_code = '';
            if (preg_match('/\((.*)\)/', $txtva, $reg)) {
                $vat_src_code = $reg[1];
                $txtva = preg_replace('/\s*\(.*\)/', '', $txtva);    // Remove code into vatrate.
            }

            $tabprice = calcul_price_total($qty, $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $product_type, $mysoc, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);

            $total_ht = $tabprice[0];
            $total_tva = $tabprice[1];
            $total_ttc = $tabprice[2];
            $total_localtax1 = $tabprice[9];
            $total_localtax2 = $tabprice[10];
            $pu_ht = $tabprice[3];
            $pu_tva = $tabprice[4];
            $pu_ttc = $tabprice[5];

            // MultiCurrency
            $multicurrency_total_ht = $tabprice[16];
            $multicurrency_total_tva = $tabprice[17];
            $multicurrency_total_ttc = $tabprice[18];
            $pu_ht_devise = $tabprice[19];

            // Rang to use
            $rangtouse = $rang;
            if ($rangtouse == -1) {
                $rangmax = $this->line_max($fk_parent_line);
                $rangtouse = $rangmax + 1;
            }

            // TODO A virer
            // Anciens indicateurs: $price, $remise (a ne plus utiliser)
            $price = $pu;
            $remise = 0;
            if ($remise_percent > 0) {
                $remise = round(($pu * $remise_percent / 100), 2);
                $price = $pu - $remise;
            }

            // Insert line
            $this->line = new PropaleLigne($this->db);

            $this->line->context = $this->context;

            $this->line->fk_propal = $this->id;
            $this->line->label = $label;
            $this->line->desc = $desc;
            $this->line->qty = $qty;

            $this->line->vat_src_code = $vat_src_code;
            $this->line->tva_tx = $txtva;
            $this->line->localtax1_tx = ($total_localtax1 ? $localtaxes_type[1] : 0);
            $this->line->localtax2_tx = ($total_localtax2 ? $localtaxes_type[3] : 0);
            $this->line->localtax1_type = $localtaxes_type[0];
            $this->line->localtax2_type = $localtaxes_type[2];
            $this->line->fk_product = $fk_product;
            $this->line->product_type = $type;
            $this->line->fk_remise_except = $fk_remise_except;
            $this->line->remise_percent = $remise_percent;
            $this->line->subprice = $pu_ht;
            $this->line->rang = $rangtouse;
            $this->line->info_bits = $info_bits;
            $this->line->total_ht = $total_ht;
            $this->line->total_tva = $total_tva;
            $this->line->total_localtax1 = $total_localtax1;
            $this->line->total_localtax2 = $total_localtax2;
            $this->line->total_ttc = $total_ttc;
            $this->line->special_code = $special_code;
            $this->line->fk_parent_line = $fk_parent_line;
            $this->line->fk_unit = $fk_unit;

            $this->line->date_start = $date_start;
            $this->line->date_end = $date_end;

            $this->line->fk_fournprice = $fk_fournprice;
            $this->line->pa_ht = $pa_ht;

            $this->line->origin_id = $origin_id;
            $this->line->origin = $origin;

            // Multicurrency
            $this->line->fk_multicurrency = $this->fk_multicurrency;
            $this->line->multicurrency_code = $this->multicurrency_code;
            $this->line->multicurrency_subprice = $pu_ht_devise;
            $this->line->multicurrency_total_ht = $multicurrency_total_ht;
            $this->line->multicurrency_total_tva = $multicurrency_total_tva;
            $this->line->multicurrency_total_ttc = $multicurrency_total_ttc;

            // Mise en option de la ligne
            if (empty($qty) && empty($special_code))
                $this->line->special_code = 3;

            // TODO deprecated
            $this->line->price = $price;
            $this->line->remise = $remise;

            if (is_array($array_options) && count($array_options) > 0) {
                $this->line->array_options = $array_options;
            }

            $result = $this->line->insert();
            if ($result > 0) {
                // Reorder if child line
                if (!empty($fk_parent_line))
                    $this->line_order(true, 'DESC');

                // Mise a jour informations denormalisees au niveau de la propale meme
                $result = $this->update_price(1, 'auto', 0, $mysoc); // This method is designed to add line from user input so total calculation must be done using 'auto' mode.
                if ($result > 0) {
                    $this->db->commit();
                    return $this->line->rowid;
                } else {
                    $this->error = $this->db->error();
                    $this->db->rollback();
                    return -1;
                }
            } else {
                $this->error = $this->line->error;
                $this->db->rollback();
                return -2;
            }
        } else {
            dol_syslog(get_class($this) . "::addline status of order must be Draft to allow use of ->addline()", LOG_ERR);
            return -3;
        }
    }

    /**
     *  Update a proposal line
     *
     *  @param      int			$rowid           	Id de la ligne
     *  @param      float		$pu		     	  	Prix unitaire (HT ou TTC selon price_base_type)
     *  @param      float		$qty            	Quantity
     *  @param      float		$remise_percent  	Remise effectuee sur le produit
     *  @param      float		$txtva	          	Taux de TVA
     * 	@param	  	float		$txlocaltax1		Local tax 1 rate
     *  @param	  	float		$txlocaltax2		Local tax 2 rate
     *  @param      string		$desc            	Description
     * 	@param	  	string		$price_base_type	HT ou TTC
     * 	@param      int			$info_bits        	Miscellaneous informations
     * 	@param		int			$special_code		Special code (also used by externals modules!)
     * 	@param		int			$fk_parent_line		Id of parent line (0 in most cases, used by modules adding sublevels into lines).
     * 	@param		int			$skip_update_total	Keep fields total_xxx to 0 (used for special lines by some modules)
     *  @param		int			$fk_fournprice		Id of origin supplier price
     *  @param		int			$pa_ht				Price (without tax) of product when it was bought
     *  @param		string		$label				???
     *  @param		int			$type				0/1=Product/service
     * 	@param      int			$date_start       	Start date of the line
     * 	@param      int			$date_end         	End date of the line
     *  @param		array		$array_options		extrafields array
     * 	@param 		string		$fk_unit 			Code of the unit to use. Null to use the default one
     * 	@param		double		$pu_ht_devise		Unit price in currency
     * 	@param		int			$notrigger			disable line update trigger
     *  @return     int     		        		0 if OK, <0 if KO
     */
    function updateline($rowid, $pu, $qty, $remise_percent, $txtva, $txlocaltax1 = 0.0, $txlocaltax2 = 0.0, $desc = '', $price_base_type = 'HT', $info_bits = 0, $special_code = 0, $fk_parent_line = 0, $skip_update_total = 0, $fk_fournprice = 0, $pa_ht = 0, $label = '', $type = 0, $date_start = '', $date_end = '', $array_options = 0, $fk_unit = null, $pu_ht_devise = 0, $notrigger = 0)
    {
        global $mysoc;

        dol_syslog(get_class($this) . "::updateLine rowid=$rowid, pu=$pu, qty=$qty, remise_percent=$remise_percent,
        txtva=$txtva, desc=$desc, price_base_type=$price_base_type, info_bits=$info_bits, special_code=$special_code, fk_parent_line=$fk_parent_line, pa_ht=$pa_ht, type=$type, date_start=$date_start, date_end=$date_end");
        include_once DOL_DOCUMENT_ROOT . '/core/lib/price.lib.php';

        // Clean parameters
        $remise_percent = price2num($remise_percent);
        $qty = price2num($qty);
        $pu = price2num($pu);
        $pu_ht_devise = price2num($pu_ht_devise);
        $txtva = price2num($txtva);
        $txlocaltax1 = price2num($txlocaltax1);
        $txlocaltax2 = price2num($txlocaltax2);
        $pa_ht = price2num($pa_ht);
        if (empty($qty) && empty($special_code))
            $special_code = 3;    // Set option tag
        if (!empty($qty) && $special_code == 3)
            $special_code = 0;    // Remove option tag
        if (empty($type))
            $type = 0;

        if ($this->statut == self::STATUS_DRAFT) {
            $this->db->begin();

            // Calcul du total TTC et de la TVA pour la ligne a partir de
            // qty, pu, remise_percent et txtva
            // TRES IMPORTANT: C'est au moment de l'insertion ligne qu'on doit stocker
            // la part ht, tva et ttc, et ce au niveau de la ligne qui a son propre taux tva.

            $localtaxes_type = getLocalTaxesFromRate($txtva, 0, $this->thirdparty, $mysoc);

            // Clean vat code
            $vat_src_code = '';
            if (preg_match('/\((.*)\)/', $txtva, $reg)) {
                $vat_src_code = $reg[1];
                $txtva = preg_replace('/\s*\(.*\)/', '', $txtva);    // Remove code into vatrate.
            }

            $tabprice = calcul_price_total($qty, $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $type, $mysoc, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);
            $total_ht = $tabprice[0];
            $total_tva = $tabprice[1];
            $total_ttc = $tabprice[2];
            $total_localtax1 = $tabprice[9];
            $total_localtax2 = $tabprice[10];
            $pu_ht = $tabprice[3];
            $pu_tva = $tabprice[4];
            $pu_ttc = $tabprice[5];

            // MultiCurrency
            $multicurrency_total_ht = $tabprice[16];
            $multicurrency_total_tva = $tabprice[17];
            $multicurrency_total_ttc = $tabprice[18];
            $pu_ht_devise = $tabprice[19];

            // Anciens indicateurs: $price, $remise (a ne plus utiliser)
            $price = $pu;
            $remise = 0;
            if ($remise_percent > 0) {
                $remise = round(($pu * $remise_percent / 100), 2);
                $price = $pu - $remise;
            }

            //Fetch current line from the database and then clone the object and set it in $oldline property
            $line = new PropaleLigne($this->db);
            $line->fetch($rowid);
            $line->fetch_optionals(); // Fetch extrafields for oldcopy

            $staticline = clone $line;

            $line->oldline = $staticline;
            $this->line = $line;
            $this->line->context = $this->context;

            // Reorder if fk_parent_line change
            if (!empty($fk_parent_line) && !empty($staticline->fk_parent_line) && $fk_parent_line != $staticline->fk_parent_line) {
                $rangmax = $this->line_max($fk_parent_line);
                $this->line->rang = $rangmax + 1;
            }

            $this->line->rowid = $rowid;
            $this->line->label = $label;
            $this->line->desc = $desc;
            $this->line->qty = $qty;
            $this->line->product_type = $type;
            $this->line->vat_src_code = $vat_src_code;
            $this->line->tva_tx = $txtva;
            $this->line->localtax1_tx = $txlocaltax1;
            $this->line->localtax2_tx = $txlocaltax2;
            $this->line->localtax1_type = $localtaxes_type[0];
            $this->line->localtax2_type = $localtaxes_type[2];
            $this->line->remise_percent = $remise_percent;
            $this->line->subprice = $pu_ht;
            $this->line->info_bits = $info_bits;

            $this->line->total_ht = $total_ht;
            $this->line->total_tva = $total_tva;
            $this->line->total_localtax1 = $total_localtax1;
            $this->line->total_localtax2 = $total_localtax2;
            $this->line->total_ttc = $total_ttc;
            $this->line->special_code = $special_code;
            $this->line->fk_parent_line = $fk_parent_line;
            $this->line->skip_update_total = $skip_update_total;
            $this->line->fk_unit = $fk_unit;

            $this->line->fk_fournprice = $fk_fournprice;
            $this->line->pa_ht = $pa_ht;

            $this->line->date_start = $date_start;
            $this->line->date_end = $date_end;

            // TODO deprecated
            $this->line->price = $price;
            $this->line->remise = $remise;

            if (is_array($array_options) && count($array_options) > 0) {
                $this->line->array_options = $array_options;
            }

            // Multicurrency
            $this->line->multicurrency_subprice = $pu_ht_devise;
            $this->line->multicurrency_total_ht = $multicurrency_total_ht;
            $this->line->multicurrency_total_tva = $multicurrency_total_tva;
            $this->line->multicurrency_total_ttc = $multicurrency_total_ttc;

            $result = $this->line->update($notrigger);
            if ($result > 0) {
                // Reorder if child line
                if (!empty($fk_parent_line))
                    $this->line_order(true, 'DESC');

                $this->update_price(1);

                $this->fk_propal = $this->id;
                $this->rowid = $rowid;

                $this->db->commit();
                return $result;
            }
            else {
                $this->error = $this->line->error;

                $this->db->rollback();
                return -1;
            }
        } else {
            dol_syslog(get_class($this) . "::updateline Erreur -2 Propal en mode incompatible pour cette action");
            return -2;
        }
    }

    /**
     *  Delete detail line
     *
     *  @param		int		$lineid			Id of line to delete
     *  @return     int         			>0 if OK, <0 if KO
     */
    function deleteline($lineid)
    {
        global $user;

        if ($this->statut == self::STATUS_DRAFT) {
            $this->db->begin();

            $line = new PropaleLigne($this->db);

            // For triggers
            $line->fetch($lineid);

            if ($line->delete($user) > 0) {
                $this->update_price(1);

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

    /**
     *  Create commercial proposal into database
     * 	this->ref can be set or empty. If empty, we will use "(PROVid)"
     *
     * 	@param		User	$user		User that create
     * 	@param		int		$notrigger	1=Does not execute triggers, 0= execute triggers
     *  @return     int     			<0 if KO, >=0 if OK
     */
    function create($user, $notrigger = 0)
    {
        global $conf, $hookmanager;
        $error = 0;

        $now = dol_now();

        // Clean parameters
        if (empty($this->entity))
            $this->entity = $conf->entity;
        if (empty($this->date))
            $this->date = $this->datep;
        $this->fin_validite = $this->date + ($this->duree_validite * 24 * 3600);
        if (empty($this->availability_id))
            $this->availability_id = 0;
        if (empty($this->demand_reason_id))
            $this->demand_reason_id = 0;

        // Multicurrency (test on $this->multicurrency_tx because we should take the default rate only if not using origin rate)
        if (!empty($this->multicurrency_code) && empty($this->multicurrency_tx))
            list($this->fk_multicurrency, $this->multicurrency_tx) = MultiCurrency::getIdAndTxFromCode($this->db, $this->multicurrency_code, $this->date);
        else
            $this->fk_multicurrency = MultiCurrency::getIdFromCode($this->db, $this->multicurrency_code);
        if (empty($this->fk_multicurrency)) {
            $this->multicurrency_code = $conf->currency;
            $this->fk_multicurrency = 0;
            $this->multicurrency_tx = 1;
        }

        dol_syslog(get_class($this) . "::create");

        // Check parameters
        $result = $this->fetch_thirdparty();
        if ($result < 0) {
            $this->error = "Failed to fetch company";
            dol_syslog(get_class($this) . "::create " . $this->error, LOG_ERR);
            return -3;
        }

        // Check parameters
        if (!empty($this->ref)) { // We check that ref is not already used
            $result = self::isExistingObject($this->element, 0, $this->ref); // Check ref is not yet used
            if ($result > 0) {
                $this->error = 'ErrorRefAlreadyExists';
                dol_syslog(get_class($this) . "::create " . $this->error, LOG_WARNING);
                $this->db->rollback();
                return -1;
            }
        }

        if (empty($this->date)) {
            $this->error = "Date of proposal is required";
            dol_syslog(get_class($this) . "::create " . $this->error, LOG_ERR);
            return -4;
        }


        $this->db->begin();

        // Insert into database
        $sql = "INSERT INTO " . MAIN_DB_PREFIX . "propal (";
        $sql .= "fk_soc";
        $sql .= ", price";
        $sql .= ", remise";
        $sql .= ", remise_percent";
        $sql .= ", remise_absolue";
        $sql .= ", tva";
        $sql .= ", total";
        $sql .= ", datep";
        $sql .= ", datec";
        $sql .= ", ref";
        $sql .= ", fk_user_author";
        $sql .= ", note_private";
        $sql .= ", note_public";
        $sql .= ", model_pdf";
        $sql .= ", fin_validite";
        $sql .= ", fk_cond_reglement";
        $sql .= ", fk_mode_reglement";
        $sql .= ", fk_account";
        $sql .= ", ref_client";
        $sql .= ", date_livraison";
        $sql .= ", fk_shipping_method";
        $sql .= ", fk_availability";
        $sql .= ", fk_input_reason";
        $sql .= ", fk_projet";
        $sql .= ", fk_incoterms";
        $sql .= ", location_incoterms";
        $sql .= ", entity";
        $sql .= ", fk_multicurrency";
        $sql .= ", multicurrency_code";
        $sql .= ", multicurrency_tx";
        $sql .= ") ";
        $sql .= " VALUES (";
        $sql .= $this->socid;
        $sql .= ", 0";
        $sql .= ", " . $this->remise;
        $sql .= ", " . ($this->remise_percent ? $this->db->escape($this->remise_percent) : 'NULL');
        $sql .= ", " . ($this->remise_absolue ? $this->db->escape($this->remise_absolue) : 'NULL');
        $sql .= ", 0";
        $sql .= ", 0";
        $sql .= ", '" . $this->db->idate($this->date) . "'";
        $sql .= ", '" . $this->db->idate($now) . "'";
        $sql .= ", '(PROV)'";
        $sql .= ", " . ($user->id > 0 ? "'" . $user->id . "'" : "NULL");
        $sql .= ", '" . $this->db->escape($this->note_private) . "'";
        $sql .= ", '" . $this->db->escape($this->note_public) . "'";
        $sql .= ", '" . $this->db->escape($this->modelpdf) . "'";
        $sql .= ", " . ($this->fin_validite != '' ? "'" . $this->db->idate($this->fin_validite) . "'" : "NULL");
        $sql .= ", " . ($this->cond_reglement_id > 0 ? $this->cond_reglement_id : 'NULL');
        $sql .= ", " . ($this->mode_reglement_id > 0 ? $this->mode_reglement_id : 'NULL');
        $sql .= ", " . ($this->fk_account > 0 ? $this->fk_account : 'NULL');
        $sql .= ", '" . $this->db->escape($this->ref_client) . "'";
        $sql .= ", " . ($this->date_livraison != '' ? "'" . $this->db->idate($this->date_livraison) . "'" : "NULL");
        $sql .= ", " . ($this->shipping_method_id > 0 ? $this->shipping_method_id : 'NULL');
        $sql .= ", " . $this->availability_id;
        $sql .= ", " . $this->demand_reason_id;
        $sql .= ", " . ($this->fk_project ? $this->fk_project : "null");
        $sql .= ", " . (int) $this->fk_incoterms;
        $sql .= ", '" . $this->db->escape($this->location_incoterms) . "'";
        $sql .= ", " . $this->entity;
        $sql .= ", " . (int) $this->fk_multicurrency;
        $sql .= ", '" . $this->db->escape($this->multicurrency_code) . "'";
        $sql .= ", " . (double) $this->multicurrency_tx;
        $sql .= ")";

        dol_syslog(get_class($this) . "::create", LOG_DEBUG);
        $resql = $this->db->query($sql);
        if ($resql) {
            $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX . "propal");

            if ($this->id) {
                $this->ref = '(PROV' . $this->id . ')';
                $sql = 'UPDATE ' . MAIN_DB_PREFIX . "propal SET ref='" . $this->db->escape($this->ref) . "' WHERE rowid=" . $this->id;

                dol_syslog(get_class($this) . "::create", LOG_DEBUG);
                $resql = $this->db->query($sql);
                if (!$resql)
                    $error++;

                if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) { // To use new linkedObjectsIds instead of old linked_objects
                    $this->linked_objects = $this->linkedObjectsIds; // TODO Replace linked_objects with linkedObjectsIds
                }

                // Add object linked
                if (!$error && $this->id && is_array($this->linked_objects) && !empty($this->linked_objects)) {
                    foreach ($this->linked_objects as $origin => $tmp_origin_id) {
                        if (is_array($tmp_origin_id)) {       // New behaviour, if linked_object can have several links per type, so is something like array('contract'=>array(id1, id2, ...))
                            foreach ($tmp_origin_id as $origin_id) {
                                $ret = $this->add_object_linked($origin, $origin_id);
                                if (!$ret) {
                                    $this->error = $this->db->lasterror();
                                    $error++;
                                }
                            }
                        } else {                                // Old behaviour, if linked_object has only one link per type, so is something like array('contract'=>id1))
                            $origin_id = $tmp_origin_id;
                            $ret = $this->add_object_linked($origin, $origin_id);
                            if (!$ret) {
                                $this->error = $this->db->lasterror();
                                $error++;
                            }
                        }
                    }
                }

                // Add linked object (deprecated, use ->linkedObjectsIds instead)
                if (!$error && $this->origin && $this->origin_id) {
                    dol_syslog('Deprecated use of linked object, use ->linkedObjectsIds instead', LOG_WARNING);
                    $ret = $this->add_object_linked();
                    if (!$ret)
                        dol_print_error($this->db);
                }

                /*
                 *  Insertion du detail des produits dans la base
                 *  Insert products detail in database
                 */
                if (!$error) {
                    $fk_parent_line = 0;
                    $num = count($this->lines);

                    for ($i = 0; $i < $num; $i++) {
                        if (!is_object($this->lines[$i])) { // If this->lines is not array of objects, coming from REST API   // Convert into object this->lines[$i].
                            $line = (object) $this->lines[$i];
                        } else {
                            $line = $this->lines[$i];
                        }
                        // Reset fk_parent_line for line that are not child lines or special product
                        if (($line->product_type != 9 && empty($line->fk_parent_line)) || $line->product_type == 9) {
                            $fk_parent_line = 0;
                        }
                        // Complete vat rate with code
                        $vatrate = $line->tva_tx;
                        if ($line->vat_src_code && !preg_match('/\(.*\)/', $vatrate))
                            $vatrate .= ' (' . $line->vat_src_code . ')';

                        $result = $this->addline(
                            $line->desc, $line->subprice, $line->qty, $vatrate, $line->localtax1_tx, $line->localtax2_tx, $line->fk_product, $line->remise_percent, 'HT', 0, $line->info_bits, $line->product_type, $line->rang, $line->special_code, $fk_parent_line, $line->fk_fournprice, $line->pa_ht, $line->label, $line->date_start, $line->date_end, $line->array_options, $line->fk_unit, $this->element, $line->id
                        );

                        if ($result < 0) {
                            $error++;
                            $this->error = $this->db->error;
                            dol_print_error($this->db);
                            break;
                        }
                        // Defined the new fk_parent_line
                        if ($result > 0 && $line->product_type == 9) {
                            $fk_parent_line = $result;
                        }
                    }
                }

                // Set delivery address
                if (!$error && $this->fk_delivery_address) {
                    $sql = "UPDATE " . MAIN_DB_PREFIX . "propal";
                    $sql .= " SET fk_delivery_address = " . $this->fk_delivery_address;
                    $sql .= " WHERE ref = '" . $this->db->escape($this->ref) . "'";
                    $sql .= " AND entity = " . $conf->entity;

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

                if (!$error) {
                    // Mise a jour infos denormalisees
                    $resql = $this->update_price(1);
                    if ($resql) {
                        $action = 'update';

                        // Actions on extra fields
                        if (!$error) {
                            if (empty($conf->global->MAIN_EXTRAFIELDS_DISABLED)) { // For avoid conflicts if trigger used
                                $result = $this->insertExtraFields();
                                if ($result < 0) {
                                    $error++;
                                }
                            }
                        }

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

            if (!$error) {
                $this->db->commit();
                dol_syslog(get_class($this) . "::create done id=" . $this->id);
                return $this->id;
            } else {
                $this->db->rollback();
                return -2;
            }
        } else {
            $this->error = $this->db->lasterror();
            $this->db->rollback();
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     * 	Insert into DB a proposal object completely defined by its data members (ex, results from copy).
     *
     * 	@param 		User	$user	User that create
     * 	@return    	int				Id of the new object if ok, <0 if ko
     * 	@see       	create
     */
    function create_from($user)
    {
        // phpcs:enable
        // i love this function because $this->products is not used in create function...
        $this->products = $this->lines;

        return $this->create($user);
    }

    /**
     * 		Load an object from its id and create a new one in database
     *
     * 		@param		int				$socid			Id of thirdparty
     * 	 	@return		int								New id of clone
     */
    function createFromClone($socid = 0)
    {
        global $user, $conf, $hookmanager;

        dol_include_once('/projet/class/project.class.php');

        $this->context['createfromclone'] = 'createfromclone';

        $error = 0;
        $now = dol_now();

        $this->db->begin();

        // get extrafields so they will be clone
        foreach ($this->lines as $line)
            $line->fetch_optionals();

        // Load dest object
        $clonedObj = clone $this;

        $objsoc = new Societe($this->db);

        // Change socid if needed
        if (!empty($socid) && $socid != $clonedObj->socid) {
            if ($objsoc->fetch($socid) > 0) {
                $clonedObj->socid = $objsoc->id;
                $clonedObj->cond_reglement_id = (!empty($objsoc->cond_reglement_id) ? $objsoc->cond_reglement_id : 0);
                $clonedObj->mode_reglement_id = (!empty($objsoc->mode_reglement_id) ? $objsoc->mode_reglement_id : 0);
                $clonedObj->fk_delivery_address = '';

                /* if (!empty($conf->projet->enabled))
                  {
                  $project = new Project($db);
                  if ($this->fk_project > 0 && $project->fetch($this->fk_project)) {
                  if ($project->socid <= 0) $clonedObj->fk_project = $this->fk_project;
                  else $clonedObj->fk_project = '';
                  } else {
                  $clonedObj->fk_project = '';
                  }
                  } */
                $clonedObj->fk_project = '';    // A cloned proposal is set by default to no project.
            }

            // reset ref_client
            $clonedObj->ref_client = '';

            // TODO Change product price if multi-prices
        } else {
            $objsoc->fetch($clonedObj->socid);
        }

        $clonedObj->id = 0;
        $clonedObj->ref = '';
        $clonedObj->statut = self::STATUS_DRAFT;

        // Clear fields
        $clonedObj->user_author = $user->id;
        $clonedObj->user_valid = '';
        $clonedObj->date = $now;
        $clonedObj->datep = $now;    // deprecated
        $clonedObj->fin_validite = $clonedObj->date + ($clonedObj->duree_validite * 24 * 3600);
        if (empty($conf->global->MAIN_KEEP_REF_CUSTOMER_ON_CLONING))
            $clonedObj->ref_client = '';

        // Create clone
        $result = $clonedObj->create($user);
        if ($result < 0)
            $error++;
        else {
            // copy internal contacts
            if ($clonedObj->copy_linked_contact($this, 'internal') < 0)
                $error++;

            // copy external contacts if same company
            elseif ($this->socid == $clonedObj->socid) {
                if ($clonedObj->copy_linked_contact($this, 'external') < 0)
                    $error++;
            }
        }

        if (!$error) {
            // Hook of thirdparty module
            if (is_object($hookmanager)) {
                $parameters = array('objFrom' => $this, 'clonedObj' => $clonedObj);
                $action = '';
                $reshook = $hookmanager->executeHooks('createFrom', $parameters, $clonedObj, $action);    // Note that $action and $object may have been modified by some hooks
                if ($reshook < 0)
                    $error++;
            }
        }

        unset($this->context['createfromclone']);

        // End
        if (!$error) {
            $this->db->commit();
            return $clonedObj->id;
        } else {
            $this->db->rollback();
            return -1;
        }
    }

    /**
     * 	Load a proposal from database and its ligne array
     *
     * 	@param      int			$rowid		id of object to load
     * 	@param		string		$ref		Ref of proposal
     * 	@return     int         			>0 if OK, <0 if KO
     */
    function fetch($rowid, $ref = '')
    {

        $sql = "SELECT p.rowid, p.ref, p.entity, p.remise, p.remise_percent, p.remise_absolue, p.fk_soc";
        $sql .= ", p.total, p.tva, p.localtax1, p.localtax2, p.total_ht";
        $sql .= ", p.datec";
        $sql .= ", p.date_valid as datev";
        $sql .= ", p.datep as dp";
        $sql .= ", p.fin_validite as dfv";
        $sql .= ", p.date_livraison as date_livraison";
        $sql .= ", p.model_pdf, p.last_main_doc, p.ref_client, p.extraparams";
        $sql .= ", p.note_private, p.note_public";
        $sql .= ", p.fk_projet, p.fk_statut";
        $sql .= ", p.fk_user_author, p.fk_user_valid, p.fk_user_cloture";
        $sql .= ", p.fk_delivery_address";
        $sql .= ", p.fk_availability";
        $sql .= ", p.fk_input_reason";
        $sql .= ", p.fk_cond_reglement";
        $sql .= ", p.fk_mode_reglement";
        $sql .= ', p.fk_account';
        $sql .= ", p.fk_shipping_method";
        $sql .= ", p.fk_incoterms, p.location_incoterms";
        $sql .= ", p.fk_multicurrency, p.multicurrency_code, p.multicurrency_tx, p.multicurrency_total_ht, p.multicurrency_total_tva, p.multicurrency_total_ttc";
        $sql .= ", p.tms as date_modification";
        $sql .= ", i.libelle as libelle_incoterms";
        $sql .= ", c.label as statut_label";
        $sql .= ", ca.code as availability_code, ca.label as availability";
        $sql .= ", dr.code as demand_reason_code, dr.label as demand_reason";
        $sql .= ", cr.code as cond_reglement_code, cr.libelle as cond_reglement, cr.libelle_facture as cond_reglement_libelle_doc";
        $sql .= ", cp.code as mode_reglement_code, cp.libelle as mode_reglement";
        $sql .= " FROM " . MAIN_DB_PREFIX . "propal as p";
        $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_propalst as c ON p.fk_statut = c.id';
        $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_paiement as cp ON p.fk_mode_reglement = cp.id AND cp.entity IN (' . getEntity('c_paiement') . ')';
        $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_payment_term as cr ON p.fk_cond_reglement = cr.rowid AND cr.entity IN (' . getEntity('c_payment_term') . ')';
        $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_availability as ca ON p.fk_availability = ca.rowid';
        $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_input_reason as dr ON p.fk_input_reason = dr.rowid';
        $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'c_incoterms as i ON p.fk_incoterms = i.rowid';

        if ($ref) {
            $sql .= " WHERE p.entity IN (" . getEntity('propal') . ")"; // Dont't use entity if you use rowid
            $sql .= " AND p.ref='" . $this->db->escape($ref) . "'";
        } else
            $sql .= " WHERE p.rowid=" . $rowid;

        dol_syslog(get_class($this) . "::fetch", LOG_DEBUG);
        $resql = $this->db->query($sql);
        if ($resql) {
            if ($this->db->num_rows($resql)) {
                $obj = $this->db->fetch_object($resql);

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

                $this->ref = $obj->ref;
                $this->ref_client = $obj->ref_client;
                $this->remise = $obj->remise;
                $this->remise_percent = $obj->remise_percent;
                $this->remise_absolue = $obj->remise_absolue;
                $this->total = $obj->total; // TODO deprecated
                $this->total_ht = $obj->total_ht;
                $this->total_tva = $obj->tva;
                $this->total_localtax1 = $obj->localtax1;
                $this->total_localtax2 = $obj->localtax2;
                $this->total_ttc = $obj->total;
                $this->socid = $obj->fk_soc;
                $this->fk_project = $obj->fk_projet;
                $this->modelpdf = $obj->model_pdf;
                $this->last_main_doc = $obj->last_main_doc;
                $this->note = $obj->note_private; // TODO deprecated
                $this->note_private = $obj->note_private;
                $this->note_public = $obj->note_public;
                $this->statut = (int) $obj->fk_statut;
                $this->statut_libelle = $obj->statut_label;

                $this->datec = $this->db->jdate($obj->datec); // TODO deprecated
                $this->datev = $this->db->jdate($obj->datev); // TODO deprecated
                $this->date_creation = $this->db->jdate($obj->datec); //Creation date
                $this->date_validation = $this->db->jdate($obj->datev); //Validation date
                $this->date_modification = $this->db->jdate($obj->date_modification); // tms
                $this->date = $this->db->jdate($obj->dp); // Proposal date
                $this->datep = $this->db->jdate($obj->dp);    // deprecated
                $this->fin_validite = $this->db->jdate($obj->dfv);
                $this->date_livraison = $this->db->jdate($obj->date_livraison);
                $this->shipping_method_id = ($obj->fk_shipping_method > 0) ? $obj->fk_shipping_method : null;
                $this->availability_id = $obj->fk_availability;
                $this->availability_code = $obj->availability_code;
                $this->availability = $obj->availability;
                $this->demand_reason_id = $obj->fk_input_reason;
                $this->demand_reason_code = $obj->demand_reason_code;
                $this->demand_reason = $obj->demand_reason;
                $this->fk_address = $obj->fk_delivery_address;

                $this->mode_reglement_id = $obj->fk_mode_reglement;
                $this->mode_reglement_code = $obj->mode_reglement_code;
                $this->mode_reglement = $obj->mode_reglement;
                $this->fk_account = ($obj->fk_account > 0) ? $obj->fk_account : null;
                $this->cond_reglement_id = $obj->fk_cond_reglement;
                $this->cond_reglement_code = $obj->cond_reglement_code;
                $this->cond_reglement = $obj->cond_reglement;
                $this->cond_reglement_doc = $obj->cond_reglement_libelle_doc;

                $this->extraparams = (array) json_decode($obj->extraparams, true);

                $this->user_author_id = $obj->fk_user_author;
                $this->user_valid_id = $obj->fk_user_valid;
                $this->user_close_id = $obj->fk_user_cloture;

                //Incoterms
                $this->fk_incoterms = $obj->fk_incoterms;
                $this->location_incoterms = $obj->location_incoterms;
                $this->libelle_incoterms = $obj->libelle_incoterms;

                // Multicurrency
                $this->fk_multicurrency = $obj->fk_multicurrency;
                $this->multicurrency_code = $obj->multicurrency_code;
                $this->multicurrency_tx = $obj->multicurrency_tx;
                $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
                $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
                $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;

                if ($obj->fk_statut == self::STATUS_DRAFT) {
                    $this->brouillon = 1;
                }

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

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

                $this->lines = array();

                /*
                 * Lines
                 */
                $result = $this->fetch_lines();
                if ($result < 0) {
                    return -3;
                }

                return 1;
            }

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

    /**
     *      Update database
     *
     *      @param      User	$user        	User that modify
     *      @param      int		$notrigger	    0=launch triggers after, 1=disable triggers
     *      @return     int      			   	<0 if KO, >0 if OK
     */
    function update(User $user, $notrigger = 0)
    {
        global $conf;

        $error = 0;

        // Clean parameters
        if (isset($this->ref))
            $this->ref = trim($this->ref);
        if (isset($this->ref_client))
            $this->ref_client = trim($this->ref_client);
        if (isset($this->note) || isset($this->note_private))
            $this->note_private = (isset($this->note_private) ? trim($this->note_private) : trim($this->note));
        if (isset($this->note_public))
            $this->note_public = trim($this->note_public);
        if (isset($this->modelpdf))
            $this->modelpdf = trim($this->modelpdf);
        if (isset($this->import_key))
            $this->import_key = trim($this->import_key);

        // Check parameters
        // Put here code to add control on parameters values
        // Update request
        $sql = "UPDATE " . MAIN_DB_PREFIX . "propal SET";

        $sql .= " ref=" . (isset($this->ref) ? "'" . $this->db->escape($this->ref) . "'" : "null") . ",";
        $sql .= " ref_client=" . (isset($this->ref_client) ? "'" . $this->db->escape($this->ref_client) . "'" : "null") . ",";
        $sql .= " ref_ext=" . (isset($this->ref_ext) ? "'" . $this->db->escape($this->ref_ext) . "'" : "null") . ",";
        $sql .= " fk_soc=" . (isset($this->socid) ? $this->socid : "null") . ",";
        $sql .= " datep=" . (strval($this->datep) != '' ? "'" . $this->db->idate($this->datep) . "'" : 'null') . ",";
        $sql .= " date_valid=" . (strval($this->date_validation) != '' ? "'" . $this->db->idate($this->date_validation) . "'" : 'null') . ",";
        $sql .= " tva=" . (isset($this->total_tva) ? $this->total_tva : "null") . ",";
        $sql .= " localtax1=" . (isset($this->total_localtax1) ? $this->total_localtax1 : "null") . ",";
        $sql .= " localtax2=" . (isset($this->total_localtax2) ? $this->total_localtax2 : "null") . ",";
        $sql .= " total_ht=" . (isset($this->total_ht) ? $this->total_ht : "null") . ",";
        $sql .= " total=" . (isset($this->total_ttc) ? $this->total_ttc : "null") . ",";
        $sql .= " fk_statut=" . (isset($this->statut) ? $this->statut : "null") . ",";
        $sql .= " fk_user_author=" . (isset($this->user_author_id) ? $this->user_author_id : "null") . ",";
        $sql .= " fk_user_valid=" . (isset($this->user_valid) ? $this->user_valid : "null") . ",";
        $sql .= " fk_projet=" . (isset($this->fk_project) ? $this->fk_project : "null") . ",";
        $sql .= " fk_cond_reglement=" . (isset($this->cond_reglement_id) ? $this->cond_reglement_id : "null") . ",";
        $sql .= " fk_mode_reglement=" . (isset($this->mode_reglement_id) ? $this->mode_reglement_id : "null") . ",";
        $sql .= " note_private=" . (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 .= " model_pdf=" . (isset($this->modelpdf) ? "'" . $this->db->escape($this->modelpdf) . "'" : "null") . ",";
        $sql .= " import_key=" . (isset($this->import_key) ? "'" . $this->db->escape($this->import_key) . "'" : "null") . "";

        $sql .= " WHERE rowid=" . $this->id;

        $this->db->begin();

        dol_syslog(get_class($this) . "::update", LOG_DEBUG);
        $resql = $this->db->query($sql);
        if (!$resql) {
            $error++;
            $this->errors[] = "Error " . $this->db->lasterror();
        }

        if (!$error && empty($conf->global->MAIN_EXTRAFIELDS_DISABLED) && is_array($this->array_options) && count($this->array_options) > 0) {
            $result = $this->insertExtraFields();
            if ($result < 0) {
                $error++;
            }
        }

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

        // Commit or rollback
        if ($error) {
            foreach ($this->errors as $errmsg) {
                dol_syslog(get_class($this) . "::update " . $errmsg, LOG_ERR);
                $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
            }
            $this->db->rollback();
            return -1 * $error;
        } else {
            $this->db->commit();
            return 1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     * Load array lines
     *
     * @param		int		$only_product	Return only physical products
     * @return		int						<0 if KO, >0 if OK
     */
    function fetch_lines($only_product = 0)
    {
        // phpcs:enable
        $this->lines = array();

        $sql = 'SELECT d.rowid, d.fk_propal, d.fk_parent_line, d.label as custom_label, d.description, d.price, d.vat_src_code, d.tva_tx, d.localtax1_tx, d.localtax2_tx, d.localtax1_type, d.localtax2_type, d.qty, d.fk_remise_except, d.remise_percent, d.subprice, d.fk_product,';
        $sql .= ' d.info_bits, d.total_ht, d.total_tva, d.total_localtax1, d.total_localtax2, d.total_ttc, d.fk_product_fournisseur_price as fk_fournprice, d.buy_price_ht as pa_ht, d.special_code, d.rang, d.product_type,';
        $sql .= ' d.fk_unit,';
        $sql .= ' p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_batch,';
        $sql .= ' p.weight, p.weight_units, p.volume, p.volume_units,';
        $sql .= ' d.date_start, d.date_end,';
        $sql .= ' d.fk_multicurrency, d.multicurrency_code, d.multicurrency_subprice, d.multicurrency_total_ht, d.multicurrency_total_tva, d.multicurrency_total_ttc';
        $sql .= ' FROM ' . MAIN_DB_PREFIX . 'propaldet as d';
        $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'product as p ON (d.fk_product = p.rowid)';
        $sql .= ' WHERE d.fk_propal = ' . $this->id;
        if ($only_product)
            $sql .= ' AND p.fk_product_type = 0';
        $sql .= ' ORDER by d.rang';

        dol_syslog(get_class($this) . "::fetch_lines", LOG_DEBUG);
        $result = $this->db->query($sql);
        if ($result) {
            require_once DOL_DOCUMENT_ROOT . '/core/class/extrafields.class.php';

            $num = $this->db->num_rows($result);

            $i = 0;
            while ($i < $num) {
                $objp = $this->db->fetch_object($result);

                $line = new PropaleLigne($this->db);

                $line->rowid = $objp->rowid; //Deprecated
                $line->id = $objp->rowid;
                $line->fk_propal = $objp->fk_propal;
                $line->fk_parent_line = $objp->fk_parent_line;
                $line->product_type = $objp->product_type;
                $line->label = $objp->custom_label;
                $line->desc = $objp->description;  // Description ligne
                $line->description = $objp->description;  // Description ligne
                $line->qty = $objp->qty;
                $line->vat_src_code = $objp->vat_src_code;
                $line->tva_tx = $objp->tva_tx;
                $line->localtax1_tx = $objp->localtax1_tx;
                $line->localtax2_tx = $objp->localtax2_tx;
                $line->localtax1_type = $objp->localtax1_type;
                $line->localtax2_type = $objp->localtax2_type;
                $line->subprice = $objp->subprice;
                $line->fk_remise_except = $objp->fk_remise_except;
                $line->remise_percent = $objp->remise_percent;
                $line->price = $objp->price;  // TODO deprecated

                $line->info_bits = $objp->info_bits;
                $line->total_ht = $objp->total_ht;
                $line->total_tva = $objp->total_tva;
                $line->total_localtax1 = $objp->total_localtax1;
                $line->total_localtax2 = $objp->total_localtax2;
                $line->total_ttc = $objp->total_ttc;
                $line->fk_fournprice = $objp->fk_fournprice;
                $marginInfos = getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $line->fk_fournprice, $objp->pa_ht);
                $line->pa_ht = $marginInfos[0];
                $line->marge_tx = $marginInfos[1];
                $line->marque_tx = $marginInfos[2];
                $line->special_code = $objp->special_code;
                $line->rang = $objp->rang;

                $line->fk_product = $objp->fk_product;

                $line->ref = $objp->product_ref;  // TODO deprecated
                $line->product_ref = $objp->product_ref;
                $line->libelle = $objp->product_label;  // TODO deprecated
                $line->product_label = $objp->product_label;
                $line->product_desc = $objp->product_desc;   // Description produit
                $line->product_tobatch = $objp->product_tobatch;
                $line->fk_product_type = $objp->fk_product_type; // TODO deprecated
                $line->fk_unit = $objp->fk_unit;
                $line->weight = $objp->weight;
                $line->weight_units = $objp->weight_units;
                $line->volume = $objp->volume;
                $line->volume_units = $objp->volume_units;

                $line->date_start = $this->db->jdate($objp->date_start);
                $line->date_end = $this->db->jdate($objp->date_end);

                // Multicurrency
                $line->fk_multicurrency = $objp->fk_multicurrency;
                $line->multicurrency_code = $objp->multicurrency_code;
                $line->multicurrency_subprice = $objp->multicurrency_subprice;
                $line->multicurrency_total_ht = $objp->multicurrency_total_ht;
                $line->multicurrency_total_tva = $objp->multicurrency_total_tva;
                $line->multicurrency_total_ttc = $objp->multicurrency_total_ttc;

                $line->fetch_optionals();

                $this->lines[$i] = $line;
                //dol_syslog("1 ".$line->fk_product);
                //print "xx $i ".$this->lines[$i]->fk_product;
                $i++;
            }

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

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

    /**
     *  Set status to validated
     *
     *  @param	User	$user       Object user that validate
     *  @param	int		$notrigger	1=Does not execute triggers, 0=execute triggers
     *  @return int         		<0 if KO, 0=Nothing done, >=0 if OK
     */
    function valid($user, $notrigger = 0)
    {
        require_once DOL_DOCUMENT_ROOT . '/core/lib/files.lib.php';

        global $conf;

        $error = 0;

        // Protection
        if ($this->statut == self::STATUS_VALIDATED) {
            dol_syslog(get_class($this) . "::valid action abandonned: already validated", LOG_WARNING);
            return 0;
        }

        if (!((empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !empty($user->rights->propal->creer)) || (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !empty($user->rights->propal->propal_advance->validate)))) {
            $this->error = 'ErrorPermissionDenied';
            dol_syslog(get_class($this) . "::valid " . $this->error, LOG_ERR);
            return -1;
        }

        $now = dol_now();

        $this->db->begin();

        // Numbering module definition
        $soc = new Societe($this->db);
        $soc->fetch($this->socid);

        // Define new ref
        if (!$error && (preg_match('/^[\(]?PROV/i', $this->ref) || empty($this->ref))) { // empty should not happened, but when it occurs, the test save life
            $num = $this->getNextNumRef($soc);
        } else {
            $num = $this->ref;
        }
        $this->newref = $num;

        $sql = "UPDATE " . MAIN_DB_PREFIX . "propal";
        $sql .= " SET ref = '" . $num . "',";
        $sql .= " fk_statut = " . self::STATUS_VALIDATED . ", date_valid='" . $this->db->idate($now) . "', fk_user_valid=" . $user->id;
        $sql .= " WHERE rowid = " . $this->id . " AND fk_statut = " . self::STATUS_DRAFT;

        dol_syslog(get_class($this) . "::valid", LOG_DEBUG);
        $resql = $this->db->query($sql);
        if (!$resql) {
            dol_print_error($this->db);
            $error++;
        }

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

        if (!$error) {
            $this->oldref = $this->ref;

            // Rename directory if dir was a temporary ref
            if (preg_match('/^[\(]?PROV/i', $this->ref)) {
                // Rename of propal directory ($this->ref = old ref, $num = new ref)
                // to  not lose the linked files
                $oldref = dol_sanitizeFileName($this->ref);
                $newref = dol_sanitizeFileName($num);
                $dirsource = $conf->propal->multidir_output[$this->entity] . '/' . $oldref;
                $dirdest = $conf->propal->multidir_output[$this->entity] . '/' . $newref;

                if (file_exists($dirsource)) {
                    dol_syslog(get_class($this) . "::validate rename dir " . $dirsource . " into " . $dirdest);
                    if (@rename($dirsource, $dirdest)) {
                        dol_syslog("Rename ok");
                        // Rename docs starting with $oldref with $newref
                        $listoffiles = dol_dir_list($dirdest, 'files', 1, '^' . preg_quote($oldref, '/'));
                        foreach ($listoffiles as $fileentry) {
                            $dirsource = $fileentry['name'];
                            $dirdest = preg_replace('/^' . preg_quote($oldref, '/') . '/', $newref, $dirsource);
                            $dirsource = $fileentry['path'] . '/' . $dirsource;
                            $dirdest = $fileentry['path'] . '/' . $dirdest;
                            @rename($dirsource, $dirdest);
                        }
                    }
                }
            }

            $this->ref = $num;
            $this->brouillon = 0;
            $this->statut = self::STATUS_VALIDATED;
            $this->user_valid_id = $user->id;
            $this->datev = $now;

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

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     *  Define proposal date
     *
     *  @param  User		$user      	Object user that modify
     *  @param  int			$date		Date
     *  @param  int			$notrigger	1=Does not execute triggers, 0= execute triggers
     *  @return	int         			<0 if KO, >0 if OK
     */
    function set_date($user, $date, $notrigger = 0)
    {
        // phpcs:enable
        if (empty($date)) {
            $this->error = 'ErrorBadParameter';
            dol_syslog(get_class($this) . "::set_date " . $this->error, LOG_ERR);
            return -1;
        }

        if (!empty($user->rights->propal->creer)) {
            $error = 0;

            $this->db->begin();

            $sql = "UPDATE " . MAIN_DB_PREFIX . "propal SET datep = '" . $this->db->idate($date) . "'";
            $sql .= " WHERE rowid = " . $this->id . " AND fk_statut = " . self::STATUS_DRAFT;

            dol_syslog(__METHOD__, LOG_DEBUG);
            $resql = $this->db->query($sql);
            if (!$resql) {
                $this->errors[] = $this->db->error();
                $error++;
            }

            if (!$error) {
                $this->oldcopy = clone $this;
                $this->date = $date;
                $this->datep = $date;    // deprecated
            }

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

            if (!$error) {
                $this->db->commit();
                return 1;
            } else {
                foreach ($this->errors as $errmsg) {
                    dol_syslog(__METHOD__ . ' Error: ' . $errmsg, LOG_ERR);
                    $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                }
                $this->db->rollback();
                return -1 * $error;
            }
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     * 	Define end validity date
     *
     * 	@param		User	$user        		Object user that modify
     * 	@param      int		$date_fin_validite	End of validity date
     *  @param  	int		$notrigger			1=Does not execute triggers, 0= execute triggers
     * 	@return     int         				<0 if KO, >0 if OK
     */
    function set_echeance($user, $date_fin_validite, $notrigger = 0)
    {
        // phpcs:enable
        if (!empty($user->rights->propal->creer)) {
            $error = 0;

            $this->db->begin();

            $sql = "UPDATE " . MAIN_DB_PREFIX . "propal SET fin_validite = " . ($date_fin_validite != '' ? "'" . $this->db->idate($date_fin_validite) . "'" : 'null');
            $sql .= " WHERE rowid = " . $this->id . " AND fk_statut = " . self::STATUS_DRAFT;

            dol_syslog(__METHOD__, LOG_DEBUG);
            $resql = $this->db->query($sql);
            if (!$resql) {
                $this->errors[] = $this->db->error();
                $error++;
            }


            if (!$error) {
                $this->oldcopy = clone $this;
                $this->fin_validite = $date_fin_validite;
            }

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

            if (!$error) {
                $this->db->commit();
                return 1;
            } else {
                foreach ($this->errors as $errmsg) {
                    dol_syslog(__METHOD__ . ' Error: ' . $errmsg, LOG_ERR);
                    $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                }
                $this->db->rollback();
                return -1 * $error;
            }
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     * 	Set delivery date
     *
     * 	@param      User 	$user        		Object user that modify
     * 	@param      int		$date_livraison     Delivery date
     *  @param  	int		$notrigger			1=Does not execute triggers, 0= execute triggers
     * 	@return     int         				<0 if ko, >0 if ok
     */
    function set_date_livraison($user, $date_livraison, $notrigger = 0)
    {
        // phpcs:enable
        if (!empty($user->rights->propal->creer)) {
            $error = 0;

            $this->db->begin();

            $sql = "UPDATE " . MAIN_DB_PREFIX . "propal ";
            $sql .= " SET date_livraison = " . ($date_livraison != '' ? "'" . $this->db->idate($date_livraison) . "'" : 'null');
            $sql .= " WHERE rowid = " . $this->id;

            dol_syslog(__METHOD__, LOG_DEBUG);
            $resql = $this->db->query($sql);
            if (!$resql) {
                $this->errors[] = $this->db->error();
                $error++;
            }

            if (!$error) {
                $this->oldcopy = clone $this;
                $this->date_livraison = $date_livraison;
            }

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

            if (!$error) {
                $this->db->commit();
                return 1;
            } else {
                foreach ($this->errors as $errmsg) {
                    dol_syslog(__METHOD__ . ' Error: ' . $errmsg, LOG_ERR);
                    $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                }
                $this->db->rollback();
                return -1 * $error;
            }
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     *  Set delivery
     *
     *  @param		User	$user		  	Object user that modify
     *  @param      int		$id				Availability id
     *  @param  	int		$notrigger		1=Does not execute triggers, 0= execute triggers
     *  @return     int           			<0 if KO, >0 if OK
     */
    function set_availability($user, $id, $notrigger = 0)
    {
        // phpcs:enable
        if (!empty($user->rights->propal->creer) && $this->statut >= self::STATUS_DRAFT) {
            $error = 0;

            $this->db->begin();

            $sql = "UPDATE " . MAIN_DB_PREFIX . "propal ";
            $sql .= " SET fk_availability = '" . $id . "'";
            $sql .= " WHERE rowid = " . $this->id;

            dol_syslog(__METHOD__ . ' availability(' . $id . ')', LOG_DEBUG);
            $resql = $this->db->query($sql);
            if (!$resql) {
                $this->errors[] = $this->db->error();
                $error++;
            }

            if (!$error) {
                $this->oldcopy = clone $this;
                $this->fk_availability = $id;
                $this->availability_id = $id;
            }

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

            if (!$error) {
                $this->db->commit();
                return 1;
            } else {
                foreach ($this->errors as $errmsg) {
                    dol_syslog(__METHOD__ . ' Error: ' . $errmsg, LOG_ERR);
                    $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                }
                $this->db->rollback();
                return -1 * $error;
            }
        } else {
            $error_str = 'Propal status do not meet requirement ' . $this->statut;
            dol_syslog(__METHOD__ . $error_str, LOG_ERR);
            $this->error = $error_str;
            $this->errors[] = $this->error;
            return -2;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     *  Set source of demand
     *
     *  @param		User	$user		Object user that modify
     *  @param      int		$id			Input reason id
     *  @param  	int		$notrigger	1=Does not execute triggers, 0= execute triggers
     *  @return     int           		<0 if KO, >0 if OK
     */
    function set_demand_reason($user, $id, $notrigger = 0)
    {
        // phpcs:enable
        if (!empty($user->rights->propal->creer) && $this->statut >= self::STATUS_DRAFT) {
            $error = 0;

            $this->db->begin();

            $sql = "UPDATE " . MAIN_DB_PREFIX . "propal ";
            $sql .= " SET fk_input_reason = " . $id;
            $sql .= " WHERE rowid = " . $this->id;

            dol_syslog(__METHOD__, LOG_DEBUG);
            $resql = $this->db->query($sql);
            if (!$resql) {
                $this->errors[] = $this->db->error();
                $error++;
            }


            if (!$error) {
                $this->oldcopy = clone $this;
                $this->fk_input_reason = $id;
                $this->demand_reason_id = $id;
            }


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

            if (!$error) {
                $this->db->commit();
                return 1;
            } else {
                foreach ($this->errors as $errmsg) {
                    dol_syslog(__METHOD__ . ' Error: ' . $errmsg, LOG_ERR);
                    $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                }
                $this->db->rollback();
                return -1 * $error;
            }
        } else {
            $error_str = 'Propal status do not meet requirement ' . $this->statut;
            dol_syslog(__METHOD__ . $error_str, LOG_ERR);
            $this->error = $error_str;
            $this->errors[] = $this->error;
            return -2;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     * Set customer reference number
     *
     *  @param      User	$user			Object user that modify
     *  @param      string	$ref_client		Customer reference
     *  @param  	int		$notrigger		1=Does not execute triggers, 0= execute triggers
     *  @return     int						<0 if ko, >0 if ok
     */
    function set_ref_client($user, $ref_client, $notrigger = 0)
    {
        // phpcs:enable
        if (!empty($user->rights->propal->creer)) {
            $error = 0;

            $this->db->begin();

            $sql = 'UPDATE ' . MAIN_DB_PREFIX . 'propal SET ref_client = ' . (empty($ref_client) ? 'NULL' : '\'' . $this->db->escape($ref_client) . '\'');
            $sql .= ' WHERE rowid = ' . $this->id;

            dol_syslog(__METHOD__ . ' $this->id=' . $this->id . ', ref_client=' . $ref_client, LOG_DEBUG);
            $resql = $this->db->query($sql);
            if (!$resql) {
                $this->errors[] = $this->db->error();
                $error++;
            }

            if (!$error) {
                $this->oldcopy = clone $this;
                $this->ref_client = $ref_client;
            }

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

            if (!$error) {
                $this->db->commit();
                return 1;
            } else {
                foreach ($this->errors as $errmsg) {
                    dol_syslog(__METHOD__ . ' Error: ' . $errmsg, LOG_ERR);
                    $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                }
                $this->db->rollback();
                return -1 * $error;
            }
        } else {
            return -1;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     * 	Set an overall discount on the proposal
     *
     * 	@param      User	$user       Object user that modify
     * 	@param      double	$remise     Amount discount
     *  @param  	int		$notrigger	1=Does not execute triggers, 0= execute triggers
     * 	@return     int         		<0 if ko, >0 if ok
     */
    function set_remise_percent($user, $remise, $notrigger = 0)
    {
        // phpcs:enable
        $remise = trim($remise) ? trim($remise) : 0;

        if (!empty($user->rights->propal->creer)) {
            $remise = price2num($remise);

            $error = 0;

            $this->db->begin();

            $sql = "UPDATE " . MAIN_DB_PREFIX . "propal SET remise_percent = " . $remise;
            $sql .= " WHERE rowid = " . $this->id . " AND fk_statut = " . self::STATUS_DRAFT;

            dol_syslog(__METHOD__, LOG_DEBUG);
            $resql = $this->db->query($sql);
            if (!$resql) {
                $this->errors[] = $this->db->error();
                $error++;
            }

            if (!$error) {
                $this->oldcopy = clone $this;
                $this->remise_percent = $remise;
                $this->update_price(1);
            }

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

            if (!$error) {
                $this->db->commit();
                return 1;
            } else {
                foreach ($this->errors as $errmsg) {
                    dol_syslog(__METHOD__ . ' Error: ' . $errmsg, LOG_ERR);
                    $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                }
                $this->db->rollback();
                return -1 * $error;
            }
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     * 	Set an absolute overall discount on the proposal
     *
     * 	@param      User	$user       Object user that modify
     * 	@param      double	$remise     Amount discount
     *  @param  	int		$notrigger	1=Does not execute triggers, 0= execute triggers
     * 	@return     int         		<0 if ko, >0 if ok
     */
    function set_remise_absolue($user, $remise, $notrigger = 0)
    {
        // phpcs:enable
        $remise = trim($remise) ? trim($remise) : 0;

        if (!empty($user->rights->propal->creer)) {
            $remise = price2num($remise);

            $error = 0;

            $this->db->begin();

            $sql = "UPDATE " . MAIN_DB_PREFIX . "propal ";
            $sql .= " SET remise_absolue = " . $remise;
            $sql .= " WHERE rowid = " . $this->id . " AND fk_statut = " . self::STATUS_DRAFT;

            dol_syslog(__METHOD__, LOG_DEBUG);
            $resql = $this->db->query($sql);
            if (!$resql) {
                $this->errors[] = $this->db->error();
                $error++;
            }

            if (!$error) {
                $this->oldcopy = clone $this;
                $this->remise_absolue = $remise;
                $this->update_price(1);
            }

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

            if (!$error) {
                $this->db->commit();
                return 1;
            } else {
                foreach ($this->errors as $errmsg) {
                    dol_syslog(__METHOD__ . ' Error: ' . $errmsg, LOG_ERR);
                    $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                }
                $this->db->rollback();
                return -1 * $error;
            }
        }
    }

    /**
     * 	Reopen the commercial proposal
     *
     * 	@param      User	$user		Object user that close
     * 	@param      int		$statut		Statut
     * 	@param      string	$note		Comment
     *  @param		int		$notrigger	1=Does not execute triggers, 0= execute triggers
     * 	@return     int         		<0 if KO, >0 if OK
     */
    function reopen($user, $statut, $note = '', $notrigger = 0)
    {

        $this->statut = $statut;
        $error = 0;

        $sql = "UPDATE " . MAIN_DB_PREFIX . "propal";
        $sql .= " SET fk_statut = " . $this->statut . ",";
        if (!empty($note))
            $sql .= " note_private = '" . $this->db->escape($note) . "',";
        $sql .= " date_cloture=NULL, fk_user_cloture=NULL";
        $sql .= " WHERE rowid = " . $this->id;

        $this->db->begin();

        dol_syslog(get_class($this) . "::reopen", LOG_DEBUG);
        $resql = $this->db->query($sql);
        if (!$resql) {
            $error++;
            $this->errors[] = "Error " . $this->db->lasterror();
        }
        if (!$error) {
            if (!$notrigger) {
                // Call trigger
                $result = $this->call_trigger('PROPAL_REOPEN', $user);
                if ($result < 0) {
                    $error++;
                }
                // End call triggers
            }
        }

        // Commit or rollback
        if ($error) {
            if (!empty($this->errors)) {
                foreach ($this->errors as $errmsg) {
                    dol_syslog(get_class($this) . "::update " . $errmsg, LOG_ERR);
                    $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                }
            }
            $this->db->rollback();
            return -1 * $error;
        } else {
            $this->db->commit();
            return 1;
        }
    }

    /**
     * 	Close the commercial proposal
     *
     * 	@param      User	$user		Object user that close
     * 	@param      int		$statut		Statut
     * 	@param      string	$note		Complete private note with this note
     *  @param		int		$notrigger	1=Does not execute triggers, 0=Execute triggers
     * 	@return     int         		<0 if KO, >0 if OK
     */
    function cloture($user, $statut, $note = "", $notrigger = 0)
    {
        global $langs, $conf;

        $error = 0;
        $now = dol_now();

        $this->db->begin();

        $newprivatenote = dol_concatdesc($this->note_private, $note);

        $sql = "UPDATE " . MAIN_DB_PREFIX . "propal";
        $sql .= " SET fk_statut = " . $statut . ", note_private = '" . $this->db->escape($newprivatenote) . "', date_cloture='" . $this->db->idate($now) . "', fk_user_cloture=" . $user->id;
        $sql .= " WHERE rowid = " . $this->id;

        $resql = $this->db->query($sql);
        if ($resql) {
            $modelpdf = $conf->global->PROPALE_ADDON_PDF_ODT_CLOSED ? $conf->global->PROPALE_ADDON_PDF_ODT_CLOSED : $this->modelpdf;
            $trigger_name = 'PROPAL_CLOSE_REFUSED';

            if ($statut == self::STATUS_SIGNED) {
                $trigger_name = 'PROPAL_CLOSE_SIGNED';
                $modelpdf = $conf->global->PROPALE_ADDON_PDF_ODT_TOBILL ? $conf->global->PROPALE_ADDON_PDF_ODT_TOBILL : $this->modelpdf;

                // The connected company is classified as a client
                $soc = new Societe($this->db);
                $soc->id = $this->socid;
                $result = $soc->set_as_client();

                if ($result < 0) {
                    $this->error = $this->db->lasterror();
                    $this->db->rollback();
                    return -2;
                }
            }
            if ($statut == self::STATUS_BILLED) { // Why this ?
                $trigger_name = 'PROPAL_CLASSIFY_BILLED';
            }

            if (empty($conf->global->MAIN_DISABLE_PDF_AUTOUPDATE)) {
                // Define output language
                $outputlangs = $langs;
                if (!empty($conf->global->MAIN_MULTILANGS)) {
                    $outputlangs = new Translate("", $conf);
                    $newlang = (GETPOST('lang_id', 'aZ09') ? GETPOST('lang_id', 'aZ09') : $this->thirdparty->default_lang);
                    $outputlangs->setDefaultLang($newlang);
                }
                //$ret=$object->fetch($id);    // Reload to get new records
                $this->generateDocument($modelpdf, $outputlangs);
            }

            if (!$error) {
                $this->oldcopy = clone $this;
                $this->statut = $statut;
                $this->date_cloture = $now;
                $this->note_private = $newprivatenote;
            }

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

            if (!$error) {
                $this->db->commit();
                return 1;
            } else {
                $this->statut = $this->oldcopy->statut;
                $this->date_cloture = $this->oldcopy->date_cloture;
                $this->note_private = $this->oldcopy->note_private;

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

    /**
     * 	Class invoiced the Propal
     *
     * 	@param  	User	$user    	Object user
     *  @param		int		$notrigger	1=Does not execute triggers, 0= execute triggers
     * 	@return     int     			<0 si ko, >0 si ok
     */
    function classifyBilled(User $user, $notrigger = 0)
    {
        $error = 0;

        $this->db->begin();

        $sql = 'UPDATE ' . MAIN_DB_PREFIX . 'propal SET fk_statut = ' . self::STATUS_BILLED;
        $sql .= ' WHERE rowid = ' . $this->id . ' AND fk_statut > ' . self::STATUS_DRAFT;

        dol_syslog(__METHOD__, LOG_DEBUG);
        $resql = $this->db->query($sql);
        if (!$resql) {
            $this->errors[] = $this->db->error();
            $error++;
        }

        if (!$error) {
            $this->oldcopy = clone $this;
            $this->statut = self::STATUS_BILLED;
        }

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

        if (!$error) {
            $this->db->commit();
            return 1;
        } else {
            foreach ($this->errors as $errmsg) {
                dol_syslog(__METHOD__ . ' Error: ' . $errmsg, LOG_ERR);
                $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
            }
            $this->db->rollback();
            return -1 * $error;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     * 	Set draft status
     *
     * 	@param		User	$user		Object user that modify
     *  @param		int		$notrigger	1=Does not execute triggers, 0= execute triggers
     * 	@return		int					<0 if KO, >0 if OK
     */
    function set_draft($user, $notrigger = 0)
    {
        // phpcs:enable
        $error = 0;

        $this->db->begin();

        $sql = "UPDATE " . MAIN_DB_PREFIX . "propal SET fk_statut = " . self::STATUS_DRAFT;
        $sql .= " WHERE rowid = " . $this->id;

        dol_syslog(__METHOD__, LOG_DEBUG);
        $resql = $this->db->query($sql);
        if (!$resql) {
            $this->errors[] = $this->db->error();
            $error++;
        }

        if (!$error) {
            $this->oldcopy = clone $this;
            $this->statut = self::STATUS_DRAFT;
            $this->brouillon = 1;
        }

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

        if (!$error) {
            $this->db->commit();
            return 1;
        } else {
            foreach ($this->errors as $errmsg) {
                dol_syslog(__METHOD__ . ' Error: ' . $errmsg, LOG_ERR);
                $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
            }
            $this->db->rollback();
            return -1 * $error;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     *    Return list of proposal (eventually filtered on user) into an array
     *
     *    @param	int		$shortlist			0=Return array[id]=ref, 1=Return array[](id=>id,ref=>ref,name=>name)
     *    @param	int		$draft				0=not draft, 1=draft
     *    @param	int		$notcurrentuser		0=all user, 1=not current user
     *    @param    int		$socid				Id third pary
     *    @param    int		$limit				For pagination
     *    @param    int		$offset				For pagination
     *    @param    string	$sortfield			Sort criteria
     *    @param    string	$sortorder			Sort order
     *    @return	int		       				-1 if KO, array with result if OK
     */
    function liste_array($shortlist = 0, $draft = 0, $notcurrentuser = 0, $socid = 0, $limit = 0, $offset = 0, $sortfield = 'p.datep', $sortorder = 'DESC')
    {
        // phpcs:enable
        global $user;

        $ga = array();

        $sql = "SELECT s.rowid, s.nom as name, s.client,";
        $sql .= " p.rowid as propalid, p.fk_statut, p.total_ht, p.ref, p.remise, ";
        $sql .= " p.datep as dp, p.fin_validite as datelimite";
        if (!$user->rights->societe->client->voir && !$socid)
            $sql .= ", sc.fk_soc, sc.fk_user";
        $sql .= " FROM " . MAIN_DB_PREFIX . "societe as s, " . MAIN_DB_PREFIX . "propal as p, " . MAIN_DB_PREFIX . "c_propalst as c";
        if (!$user->rights->societe->client->voir && !$socid)
            $sql .= ", " . MAIN_DB_PREFIX . "societe_commerciaux as sc";
        $sql .= " WHERE p.entity IN (" . getEntity('propal') . ")";
        $sql .= " AND p.fk_soc = s.rowid";
        $sql .= " AND p.fk_statut = c.id";
        if (!$user->rights->societe->client->voir && !$socid) { //restriction
            $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = " . $user->id;
        }
        if ($socid)
            $sql .= " AND s.rowid = " . $socid;
        if ($draft)
            $sql .= " AND p.fk_statut = " . self::STATUS_DRAFT;
        if ($notcurrentuser > 0)
            $sql .= " AND p.fk_user_author <> " . $user->id;
        $sql .= $this->db->order($sortfield, $sortorder);
        $sql .= $this->db->plimit($limit, $offset);

        $result = $this->db->query($sql);
        if ($result) {
            $num = $this->db->num_rows($result);
            if ($num) {
                $i = 0;
                while ($i < $num) {
                    $obj = $this->db->fetch_object($result);

                    if ($shortlist == 1) {
                        $ga[$obj->propalid] = $obj->ref;
                    } else if ($shortlist == 2) {
                        $ga[$obj->propalid] = $obj->ref . ' (' . $obj->name . ')';
                    } else {
                        $ga[$i]['id'] = $obj->propalid;
                        $ga[$i]['ref'] = $obj->ref;
                        $ga[$i]['name'] = $obj->name;
                    }

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

    /**
     *  Returns an array with the numbers of related invoices
     *
     * 	@return	array		Array of invoices
     */
    function getInvoiceArrayList()
    {
        return $this->InvoiceArrayList($this->id);
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     *  Returns an array with id and ref of related invoices
     *
     * 	@param		int		$id			Id propal
     * 	@return		array				Array of invoices id
     */
    function InvoiceArrayList($id)
    {
        // phpcs:enable
        $ga = array();
        $linkedInvoices = array();

        $this->fetchObjectLinked($id, $this->element);
        foreach ($this->linkedObjectsIds as $objecttype => $objectid) {
            // Nouveau système du comon object renvoi des rowid et non un id linéaire de 1 à n
            // On parcourt donc une liste d'objets en tant qu'objet unique
            foreach ($objectid as $key => $object) {
                // Cas des factures liees directement
                if ($objecttype == 'facture') {
                    $linkedInvoices[] = $object;
                }
                // Cas des factures liees par un autre objet (ex: commande)
                else {
                    $this->fetchObjectLinked($object, $objecttype);
                    foreach ($this->linkedObjectsIds as $subobjecttype => $subobjectid) {
                        foreach ($subobjectid as $subkey => $subobject) {
                            if ($subobjecttype == 'facture') {
                                $linkedInvoices[] = $subobject;
                            }
                        }
                    }
                }
            }
        }

        if (count($linkedInvoices) > 0) {
            $sql = "SELECT rowid as facid, ref, total, datef as df, fk_user_author, fk_statut, paye";
            $sql .= " FROM " . MAIN_DB_PREFIX . "facture";
            $sql .= " WHERE rowid IN (" . implode(',', $linkedInvoices) . ")";

            dol_syslog(get_class($this) . "::InvoiceArrayList", LOG_DEBUG);
            $resql = $this->db->query($sql);

            if ($resql) {
                $tab_sqlobj = array();
                $nump = $this->db->num_rows($resql);
                for ($i = 0; $i < $nump; $i++) {
                    $sqlobj = $this->db->fetch_object($resql);
                    $tab_sqlobj[] = $sqlobj;
                }
                $this->db->free($resql);

                $nump = count($tab_sqlobj);

                if ($nump) {
                    $i = 0;
                    while ($i < $nump) {
                        $obj = array_shift($tab_sqlobj);

                        $ga[$i] = $obj;

                        $i++;
                    }
                }
                return $ga;
            } else {
                return -1;
            }
        } else
            return $ga;
    }

    /**
     * 	Delete proposal
     *
     * 	@param	User	$user        	Object user that delete
     * 	@param	int		$notrigger		1=Does not execute triggers, 0= execute triggers
     * 	@return	int						1 if ok, otherwise if error
     */
    function delete($user, $notrigger = 0)
    {
        global $conf;
        require_once DOL_DOCUMENT_ROOT . '/core/lib/files.lib.php';

        $error = 0;

        $this->db->begin();

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

        if (!$error) {
            $sql = "DELETE FROM " . MAIN_DB_PREFIX . "propaldet WHERE fk_propal = " . $this->id;
            if ($this->db->query($sql)) {
                $sql = "DELETE FROM " . MAIN_DB_PREFIX . "propal WHERE rowid = " . $this->id;
                if ($this->db->query($sql)) {
                    // Delete linked object
                    $res = $this->deleteObjectLinked();
                    if ($res < 0)
                        $error++;

                    // Delete linked contacts
                    $res = $this->delete_linked_contact();
                    if ($res < 0)
                        $error++;

                    if (!$error) {
                        // We remove directory
                        $ref = dol_sanitizeFileName($this->ref);
                        if ($conf->propal->multidir_output[$this->entity] && !empty($this->ref)) {
                            $dir = $conf->propal->multidir_output[$this->entity] . "/" . $ref;
                            $file = $dir . "/" . $ref . ".pdf";
                            if (file_exists($file)) {
                                dol_delete_preview($this);

                                if (!dol_delete_file($file, 0, 0, 0, $this)) { // For triggers
                                    $this->error = 'ErrorFailToDeleteFile';
                                    $this->errors = array('ErrorFailToDeleteFile');
                                    $this->db->rollback();
                                    return 0;
                                }
                            }
                            if (file_exists($dir)) {
                                $res = @dol_delete_dir_recursive($dir);
                                if (!$res) {
                                    $this->error = 'ErrorFailToDeleteDir';
                                    $this->errors = array('ErrorFailToDeleteDir');
                                    $this->db->rollback();
                                    return 0;
                                }
                            }
                        }
                    }

                    // Removed extrafields
                    if (!$error) {
                        if (empty($conf->global->MAIN_EXTRAFIELDS_DISABLED)) { // For avoid conflicts if trigger used
                            $result = $this->deleteExtraFields();
                            if ($result < 0) {
                                $error++;
                                $errorflag = -4;
                                dol_syslog(get_class($this) . "::delete erreur " . $errorflag . " " . $this->error, LOG_ERR);
                            }
                        }
                    }

                    if (!$error) {
                        dol_syslog(get_class($this) . "::delete " . $this->id . " by " . $user->id, LOG_DEBUG);
                        $this->db->commit();
                        return 1;
                    } else {
                        $this->error = $this->db->lasterror();
                        $this->db->rollback();
                        return 0;
                    }
                } else {
                    $this->error = $this->db->lasterror();
                    $this->db->rollback();
                    return -3;
                }
            } else {
                $this->error = $this->db->lasterror();
                $this->db->rollback();
                return -2;
            }
        } else {
            $this->db->rollback();
            return -1;
        }
    }

    /**
     *  Change the delivery time
     *
     *  @param	int	$availability_id	Id of new delivery time
     * 	@param	int	$notrigger			1=Does not execute triggers, 0= execute triggers
     *  @return int                  	>0 if OK, <0 if KO
     *  @deprecated  use set_availability
     */
    function availability($availability_id, $notrigger = 0)
    {
        global $user;

        if ($this->statut >= self::STATUS_DRAFT) {
            $error = 0;

            $this->db->begin();

            $sql = 'UPDATE ' . MAIN_DB_PREFIX . 'propal';
            $sql .= ' SET fk_availability = ' . $availability_id;
            $sql .= ' WHERE rowid=' . $this->id;

            dol_syslog(__METHOD__ . ' availability(' . $availability_id . ')', LOG_DEBUG);
            $resql = $this->db->query($sql);
            if (!$resql) {
                $this->errors[] = $this->db->error();
                $error++;
            }

            if (!$error) {
                $this->oldcopy = clone $this;
                $this->availability_id = $availability_id;
            }

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

            if (!$error) {
                $this->db->commit();
                return 1;
            } else {
                foreach ($this->errors as $errmsg) {
                    dol_syslog(__METHOD__ . ' Error: ' . $errmsg, LOG_ERR);
                    $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                }
                $this->db->rollback();
                return -1 * $error;
            }
        } else {
            $error_str = 'Propal status do not meet requirement ' . $this->statut;
            dol_syslog(__METHOD__ . $error_str, LOG_ERR);
            $this->error = $error_str;
            $this->errors[] = $this->error;
            return -2;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     * 	Change source demand
     *
     * 	@param	int $demand_reason_id 	Id of new source demand
     * 	@param	int	$notrigger			1=Does not execute triggers, 0= execute triggers
     * 	@return int						>0 si ok, <0 si ko
     * 	@deprecated use set_demand_reason
     */
    function demand_reason($demand_reason_id, $notrigger = 0)
    {
        // phpcs:enable
        global $user;

        if ($this->statut >= self::STATUS_DRAFT) {
            $error = 0;

            $this->db->begin();

            $sql = 'UPDATE ' . MAIN_DB_PREFIX . 'propal';
            $sql .= ' SET fk_input_reason = ' . $demand_reason_id;
            $sql .= ' WHERE rowid=' . $this->id;

            dol_syslog(__METHOD__ . ' demand_reason(' . $demand_reason_id . ')', LOG_DEBUG);
            $resql = $this->db->query($sql);
            if (!$resql) {
                $this->errors[] = $this->db->error();
                $error++;
            }

            if (!$error) {
                $this->oldcopy = clone $this;
                $this->demand_reason_id = $demand_reason_id;
            }

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

            if (!$error) {
                $this->db->commit();
                return 1;
            } else {
                foreach ($this->errors as $errmsg) {
                    dol_syslog(__METHOD__ . ' Error: ' . $errmsg, LOG_ERR);
                    $this->error .= ($this->error ? ', ' . $errmsg : $errmsg);
                }
                $this->db->rollback();
                return -1 * $error;
            }
        } else {
            $error_str = 'Propal status do not meet requirement ' . $this->statut;
            dol_syslog(__METHOD__ . $error_str, LOG_ERR);
            $this->error = $error_str;
            $this->errors[] = $this->error;
            return -2;
        }
    }

    /**
     * 	Object Proposal Information
     *
     * 	@param	int		$id		Proposal id
     *  @return	void
     */
    function info($id)
    {
        $sql = "SELECT c.rowid, ";
        $sql .= " c.datec, c.date_valid as datev, c.date_cloture as dateo,";
        $sql .= " c.fk_user_author, c.fk_user_valid, c.fk_user_cloture";
        $sql .= " FROM " . MAIN_DB_PREFIX . "propal as c";
        $sql .= " WHERE c.rowid = " . $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->date_creation = $this->db->jdate($obj->datec);
                $this->date_validation = $this->db->jdate($obj->datev);
                $this->date_cloture = $this->db->jdate($obj->dateo);

                $cuser = new User($this->db);
                $cuser->fetch($obj->fk_user_author);
                $this->user_creation = $cuser;

                if ($obj->fk_user_valid) {
                    $vuser = new User($this->db);
                    $vuser->fetch($obj->fk_user_valid);
                    $this->user_validation = $vuser;
                }

                if ($obj->fk_user_cloture) {
                    $cluser = new User($this->db);
                    $cluser->fetch($obj->fk_user_cloture);
                    $this->user_cloture = $cluser;
                }
            }
            $this->db->free($result);
        } else {
            dol_print_error($this->db);
        }
    }

    /**
     *    	Return label of status of proposal (draft, validated, ...)
     *
     *    	@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
     *    	@return     string		Label
     */
    function getLibStatut($mode = 0)
    {
        return $this->LibStatut($this->statut, $mode);
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     *    	Return label of a status (draft, validated, ...)
     *
     *    	@param      int			$statut		id 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
     *    	@return     string		Label
     */
    function LibStatut($statut, $mode = 1)
    {
        // phpcs:enable
        global $conf;

        // Init/load array of translation of status
        if (empty($this->labelstatut) || empty($this->labelstatut_short)) {
            global $langs;
            $langs->load("propal");
            $this->labelstatut[0] = $langs->trans("PropalStatusDraft");
            $this->labelstatut[1] = $langs->trans("PropalStatusValidated");
            $this->labelstatut[2] = $langs->trans("PropalStatusSigned");
            $this->labelstatut[3] = $langs->trans("PropalStatusNotSigned");
            $this->labelstatut[4] = $langs->trans("PropalStatusBilled");
            $this->labelstatut_short[0] = $langs->trans("PropalStatusDraftShort");
            $this->labelstatut_short[1] = $langs->trans("PropalStatusValidatedShort");
            $this->labelstatut_short[2] = $langs->trans("PropalStatusSignedShort");
            $this->labelstatut_short[3] = $langs->trans("PropalStatusNotSignedShort");
            $this->labelstatut_short[4] = $langs->trans("PropalStatusBilledShort");
        }

        $statuttrans = '';
        if ($statut == self::STATUS_DRAFT)
            $statuttrans = 'statut0';
        elseif ($statut == self::STATUS_VALIDATED)
            $statuttrans = 'statut1';
        elseif ($statut == self::STATUS_SIGNED)
            $statuttrans = 'statut3';
        elseif ($statut == self::STATUS_NOTSIGNED)
            $statuttrans = 'statut5';
        elseif ($statut == self::STATUS_BILLED)
            $statuttrans = 'statut6';

        if ($mode == 0)
            return $this->labelstatut[$statut];
        elseif ($mode == 1)
            return $this->labelstatut_short[$statut];
        elseif ($mode == 2)
            return img_picto($this->labelstatut_short[$statut], $statuttrans) . ' ' . $this->labelstatut_short[$statut];
        elseif ($mode == 3)
            return img_picto($this->labelstatut[$statut], $statuttrans);
        elseif ($mode == 4)
            return img_picto($this->labelstatut[$statut], $statuttrans) . ' ' . $this->labelstatut[$statut];
        elseif ($mode == 5)
            return '<span class="hideonsmartphone">' . $this->labelstatut_short[$statut] . ' </span>' . img_picto($this->labelstatut[$statut], $statuttrans);
        elseif ($mode == 6)
            return '<span class="hideonsmartphone">' . $this->labelstatut[$statut] . ' </span>' . img_picto($this->labelstatut[$statut], $statuttrans);
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     *      Load indicators for dashboard (this->nbtodo and this->nbtodolate)
     *
     *      @param          User	$user   Object user
     *      @param          int		$mode   "opened" for proposal to close, "signed" for proposal to invoice
     *      @return WorkboardResponse|int <0 if KO, WorkboardResponse if OK
     */
    function load_board($user, $mode)
    {
        // phpcs:enable
        global $conf, $langs;

        $clause = " WHERE";

        $sql = "SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin, p.total_ht";
        $sql .= " FROM " . MAIN_DB_PREFIX . "propal as p";
        if (!$user->rights->societe->client->voir && !$user->societe_id) {
            $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "societe_commerciaux as sc ON p.fk_soc = sc.fk_soc";
            $sql .= " WHERE sc.fk_user = " . $user->id;
            $clause = " AND";
        }
        $sql .= $clause . " p.entity IN (" . getEntity('propal') . ")";
        if ($mode == 'opened')
            $sql .= " AND p.fk_statut = " . self::STATUS_VALIDATED;
        if ($mode == 'signed')
            $sql .= " AND p.fk_statut = " . self::STATUS_SIGNED;
        if ($user->societe_id)
            $sql .= " AND p.fk_soc = " . $user->societe_id;

        $resql = $this->db->query($sql);
        if ($resql) {
            $langs->load("propal");
            $now = dol_now();

            $delay_warning = 0;
            $statut = 0;
            $label = '';
            if ($mode == 'opened') {
                $delay_warning = $conf->propal->cloture->warning_delay;
                $statut = self::STATUS_VALIDATED;
                $label = $langs->trans("PropalsToClose");
            }
            if ($mode == 'signed') {
                $delay_warning = $conf->propal->facturation->warning_delay;
                $statut = self::STATUS_SIGNED;
                $label = $langs->trans("PropalsToBill");         // We set here bill but may be billed or ordered
            }

            $response = new WorkboardResponse();
            $response->warning_delay = $delay_warning / 60 / 60 / 24;
            $response->label = $label;
            $response->url = DOL_URL_ROOT . '/comm/propal/list.php?viewstatut=' . $statut . '&mainmenu=commercial&leftmenu=propals';
            $response->url_late = DOL_URL_ROOT . '/comm/propal/list.php?viewstatut=' . $statut . '&mainmenu=commercial&leftmenu=propals&sortfield=p.datep&sortorder=asc';
            $response->img = img_object('', "propal");

            // This assignment in condition is not a bug. It allows walking the results.
            while ($obj = $this->db->fetch_object($resql)) {
                $response->nbtodo++;
                $response->total += $obj->total_ht;

                if ($mode == 'opened') {
                    $datelimit = $this->db->jdate($obj->datefin);
                    if ($datelimit < ($now - $delay_warning)) {
                        $response->nbtodolate++;
                    }
                }
                // TODO Definir regle des propales a facturer en retard
                // if ($mode == 'signed' && ! count($this->FactureListeArray($obj->rowid))) $this->nbtodolate++;
            }

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

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

        // Load array of products prodids
        $num_prods = 0;
        $prodids = array();
        $sql = "SELECT rowid";
        $sql .= " FROM " . MAIN_DB_PREFIX . "product";
        $sql .= " WHERE entity IN (" . getEntity('product') . ")";
        $resql = $this->db->query($sql);
        if ($resql) {
            $num_prods = $this->db->num_rows($resql);
            $i = 0;
            while ($i < $num_prods) {
                $i++;
                $row = $this->db->fetch_row($resql);
                $prodids[$i] = $row[0];
            }
        }

        // Initialise parametres
        $this->id = 0;
        $this->ref = 'SPECIMEN';
        $this->ref_client = 'NEMICEPS';
        $this->specimen = 1;
        $this->socid = 1;
        $this->date = time();
        $this->fin_validite = $this->date + 3600 * 24 * 30;
        $this->cond_reglement_id = 1;
        $this->cond_reglement_code = 'RECEP';
        $this->mode_reglement_id = 7;
        $this->mode_reglement_code = 'CHQ';
        $this->availability_id = 1;
        $this->availability_code = 'AV_NOW';
        $this->demand_reason_id = 1;
        $this->demand_reason_code = 'SRC_00';
        $this->note_public = 'This is a comment (public)';
        $this->note_private = 'This is a comment (private)';
        // Lines
        $nbp = 5;
        $xnbp = 0;
        while ($xnbp < $nbp) {
            $line = new PropaleLigne($this->db);
            $line->desc = $langs->trans("Description") . " " . $xnbp;
            $line->qty = 1;
            $line->subprice = 100;
            $line->price = 100;
            $line->tva_tx = 20;
            $line->localtax1_tx = 0;
            $line->localtax2_tx = 0;
            if ($xnbp == 2) {
                $line->total_ht = 50;
                $line->total_ttc = 60;
                $line->total_tva = 10;
                $line->remise_percent = 50;
            } else {
                $line->total_ht = 100;
                $line->total_ttc = 120;
                $line->total_tva = 20;
                $line->remise_percent = 00;

A parse error occurred: The alleged octal '0' is invalid

            }

            if ($num_prods > 0) {
                $prodid = mt_rand(1, $num_prods);
                $line->fk_product = $prodids[$prodid];
                $line->product_ref = 'SPECIMEN';
            }

            $this->lines[$xnbp] = $line;

            $this->total_ht += $line->total_ht;
            $this->total_tva += $line->total_tva;
            $this->total_ttc += $line->total_ttc;

            $xnbp++;
        }
    }

    // phpcs:disable PEAR.NamingConventions.ValidFunctionName.NotCamelCaps
    /**
     *      Charge indicateurs this->nb de tableau de bord
     *
     *      @return     int         <0 if ko, >0 if ok
     */
    function load_state_board()
    {
        // phpcs:enable
        global $user;

        $this->nb = array();
        $clause = "WHERE";

        $sql = "SELECT count(p.rowid) as nb";
        $sql .= " FROM " . MAIN_DB_PREFIX . "propal as p";
        $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "societe as s ON p.fk_soc = s.rowid";
        if (!$user->rights->societe->client->voir && !$user->societe_id) {
            $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "societe_commerciaux as sc ON s.rowid = sc.fk_soc";
            $sql .= " WHERE sc.fk_user = " . $user->id;
            $clause = "AND";
        }
        $sql .= " " . $clause . " p.entity IN (" . getEntity('propal') . ")";

        $resql = $this->db->query($sql);
        if ($resql) {
            // This assignment in condition is not a bug. It allows walking the results.
            while ($obj = $this->db->fetch_object($resql)) {
                $this->nb["proposals"] = $obj->nb;
            }
            $this->db->free($resql);
            return 1;
        } else {
            dol_print_error($this->db);
            $this->error = $this->db->error();
            return -1;
        }
    }

    /**
     *  Returns the reference to the following non used Proposal used depending on the active numbering module
     *  defined into PROPALE_ADDON
     *
     *  @param	Societe		$soc  	Object thirdparty
     *  @return string      		Reference libre pour la propale
     */
    function getNextNumRef($soc)
    {
        global $conf, $langs;
        $langs->load("propal");

        $classname = $conf->global->PROPALE_ADDON;

        if (!empty($classname)) {
            $mybool = false;

            $file = $classname . ".php";

            // Include file with class
            $dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
            foreach ($dirmodels as $reldir) {

                $dir = dol_buildpath($reldir . "core/modules/propale/");

                // Load file with numbering class (if found)
                $mybool |= @include_once $dir . $file;
            }

            if (!$mybool) {
                dol_print_error('', "Failed to include file " . $file);
                return '';
            }

            $obj = new $classname();
            $numref = "";
            $numref = $obj->getNextValue($soc, $this);

            if ($numref != "") {
                return $numref;
            } else {
                $this->error = $obj->error;
                //dol_print_error($db,"Propale::getNextNumRef ".$obj->error);
                return "";
            }
        } else {
            $langs->load("errors");
            print $langs->trans("Error") . " " . $langs->trans("ErrorModuleSetupNotComplete");
            return "";
        }
    }

    /**
     * 	Return clicable link of object (with eventually picto)
     *
     * 	@param      int		$withpicto		          Add picto into link
     * 	@param      string	$option			          Where point the link ('expedition', 'document', ...)
     * 	@param      string	$get_params    	          Parametres added to url
     *  @param	    int   	$notooltip		          1=Disable tooltip
     *  @param      int     $save_lastsearch_value    -1=Auto, 0=No save of lastsearch_values when clicking, 1=Save lastsearch_values whenclicking
     * 	@return     string          		          String with URL
     */
    function getNomUrl($withpicto = 0, $option = '', $get_params = '', $notooltip = 0, $save_lastsearch_value = -1)
    {
        global $langs, $conf, $user;

        if (!empty($conf->dol_no_mouse_hover)) {
            $notooltip = 1;   // Force disable tooltips
        }

        $result = '';
        $label = '';
        $url = '';

        if ($user->rights->propal->lire) {
            $label = '<u>' . $langs->trans("ShowPropal") . '</u>';
            if (!empty($this->ref)) {
                $label .= '<br><b>' . $langs->trans('Ref') . ':</b> ' . $this->ref;
            }
            if (!empty($this->ref_client)) {
                $label .= '<br><b>' . $langs->trans('RefCustomer') . ':</b> ' . $this->ref_client;
            }
            if (!empty($this->total_ht)) {
                $label .= '<br><b>' . $langs->trans('AmountHT') . ':</b> ' . price($this->total_ht, 0, $langs, 0, -1, -1, $conf->currency);
            }
            if (!empty($this->total_tva)) {
                $label .= '<br><b>' . $langs->trans('VAT') . ':</b> ' . price($this->total_tva, 0, $langs, 0, -1, -1, $conf->currency);
            }
            if (!empty($this->total_ttc)) {
                $label .= '<br><b>' . $langs->trans('AmountTTC') . ':</b> ' . price($this->total_ttc, 0, $langs, 0, -1, -1, $conf->currency);
            }
            if ($option == '') {
                // $url = DOL_URL_ROOT . '/comm/propal/card.php?id=' . $this->id . $get_params;
                $url = BASE_URI . '?controller=comm/propal&method=card&id=' . $this->id . $get_params;
            }
            if ($option == 'compta') {  // deprecated
                // $url = DOL_URL_ROOT . '/comm/propal/card.php?id=' . $this->id . $get_params;
                $url = BASE_URI . '?controller=comm/propal&method=card&id=' . $this->id . $get_params;
            }
            if ($option == 'expedition') {
                // $url = DOL_URL_ROOT . '/expedition/propal.php?id=' . $this->id . $get_params;
                $url = BASE_URI . '?controller=expedition&method=propal&id=' . $this->id . $get_params;
            }
            if ($option == 'document') {
                // $url = DOL_URL_ROOT . '/comm/propal/document.php?id=' . $this->id . $get_params;
                $url = BASE_URI . '?controller=comm/propal&method=document&id=' . $this->id . $get_params;
            }

            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 && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
                    $add_save_lastsearch_values = 1;
                }
                if ($add_save_lastsearch_values) {
                    $url .= '&save_lastsearch_values=1';
                }
            }
        }

        $linkclose = '';
        if (empty($notooltip) && $user->rights->propal->lire) {
            if (!empty($conf->global->MAIN_OPTIMIZEFORTEXTBROWSER)) {
                $label = $langs->trans("ShowPropal");
                $linkclose .= ' alt="' . dol_escape_htmltag($label, 1) . '"';
            }
            $linkclose .= ' title="' . dol_escape_htmltag($label, 1) . '"';
            $linkclose .= ' class="classfortooltip"';
        }

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

        $result .= $linkstart;
        if ($withpicto)
            $result .= img_object(($notooltip ? '' : $label), $this->picto, ($notooltip ? (($withpicto != 2) ? 'class="paddingright"' : '') : 'class="' . (($withpicto != 2) ? 'paddingright ' : '') . 'classfortooltip"'), 0, 0, $notooltip ? 0 : 1);
        if ($withpicto != 2)
            $result .= $this->ref;
        $result .= $linkend;

        return $result;
    }

    /**
     * 	Retrieve an array of proposal lines
     *
     * 	@return int		>0 if OK, <0 if KO
     */
    function getLinesArray()
    {
        return $this->fetch_lines();
    }

    /**
     *  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
     *  @param   null|array  $moreparams     Array to provide more information
     * 	@return     int         				0 if KO, 1 if OK
     */
    public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams = null)
    {
        global $conf, $langs;

        $langs->load("propale");

        if (!dol_strlen($modele)) {

            $modele = 'azur';

            if ($this->modelpdf) {
                $modele = $this->modelpdf;
            } elseif (!empty($conf->global->PROPALE_ADDON_PDF)) {
                $modele = $conf->global->PROPALE_ADDON_PDF;
            }
        }

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

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

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

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