dolibarr  18.0.0-beta
supplier_proposal.class.php
Go to the documentation of this file.
1 <?php
2 /* Copyright (C) 2002-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3  * Copyright (C) 2004 Eric Seigne <eric.seigne@ryxeo.com>
4  * Copyright (C) 2004-2011 Laurent Destailleur <eldy@users.sourceforge.net>
5  * Copyright (C) 2005 Marc Barilley <marc@ocebo.com>
6  * Copyright (C) 2005-2013 Regis Houssin <regis.houssin@inodbox.com>
7  * Copyright (C) 2006 Andre Cianfarani <acianfa@free.fr>
8  * Copyright (C) 2008 Raphael Bertrand <raphael.bertrand@resultic.fr>
9  * Copyright (C) 2010-2020 Juanjo Menent <jmenent@2byte.es>
10  * Copyright (C) 2010-2018 Philippe Grand <philippe.grand@atoo-net.com>
11  * Copyright (C) 2012-2014 Christophe Battarel <christophe.battarel@altairis.fr>
12  * Copyright (C) 2013 Florian Henry <florian.henry@open-concept.pro>
13  * Copyright (C) 2014 Marcos García <marcosgdf@gmail.com>
14  * Copyright (C) 2016 Ferran Marcet <fmarcet@2byte.es>
15  * Copyright (C) 2018 Nicolas ZABOURI <info@inovea-conseil.com>
16  * Copyright (C) 2019-2023 Frédéric France <frederic.france@netlogic.fr>
17  * Copyright (C) 2020 Tobias Sekan <tobias.sekan@startmail.com>
18  * Copyright (C) 2022 Gauthier VERDOL <gauthier.verdol@atm-consulting.fr>
19  *
20  * This program is free software; you can redistribute it and/or modify
21  * it under the terms of the GNU General Public License as published by
22  * the Free Software Foundation; either version 3 of the License, or
23  * (at your option) any later version.
24  *
25  * This program is distributed in the hope that it will be useful,
26  * but WITHOUT ANY WARRANTY; without even the implied warranty of
27  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
28  * GNU General Public License for more details.
29  *
30  * You should have received a copy of the GNU General Public License
31  * along with this program. If not, see <https://www.gnu.org/licenses/>.
32  */
33 
39 require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.product.class.php';
40 require_once DOL_DOCUMENT_ROOT.'/core/class/commonobject.class.php';
41 require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
42 require_once DOL_DOCUMENT_ROOT.'/contact/class/contact.class.php';
43 require_once DOL_DOCUMENT_ROOT.'/margin/lib/margins.lib.php';
44 require_once DOL_DOCUMENT_ROOT.'/multicurrency/class/multicurrency.class.php';
45 require_once DOL_DOCUMENT_ROOT.'/core/class/commonincoterm.class.php';
46 
51 {
52  use CommonIncoterm;
53 
57  public $element = 'supplier_proposal';
58 
62  public $table_element = 'supplier_proposal';
63 
67  public $table_element_line = 'supplier_proposaldet';
68 
72  public $fk_element = 'fk_supplier_proposal';
73 
77  public $picto = 'supplier_proposal';
78 
83  public $ismultientitymanaged = 1;
84 
89  public $restrictiononfksoc = 1;
90 
94  protected $table_ref_field = 'ref';
95 
96  public $socid; // Id client
97 
102  public $author;
103 
104  public $ref_fourn; //Reference saisie lors de l'ajout d'une ligne à la demande
105  public $ref_supplier; //Reference saisie lors de l'ajout d'une ligne à la demande
106  public $statut; // 0 (draft), 1 (validated), 2 (signed), 3 (not signed), 4 (processed/billed)
107 
111  public $date;
112 
117  public $date_livraison;
118 
122  public $delivery_date;
123 
128  public $datec;
129 
133  public $date_creation;
134 
139  public $datev;
140 
144  public $date_validation;
145 
146 
147  public $user_author_id;
148  public $user_valid_id;
149  public $user_close_id;
150 
155  public $price;
156 
161  public $tva;
162 
167  public $total;
168 
169  public $cond_reglement_code;
170  public $mode_reglement_code;
171  public $remise = 0;
172  public $remise_percent = 0;
173  public $remise_absolue = 0;
174 
175  public $extraparams = array();
176  public $lines = array();
177  public $line;
178 
179  public $labelStatus = array();
180  public $labelStatusShort = array();
181 
182  public $nbtodo;
183  public $nbtodolate;
184 
185  // Multicurrency
189  public $fk_multicurrency;
190 
191  public $multicurrency_code;
192  public $multicurrency_tx;
193  public $multicurrency_total_ht;
194  public $multicurrency_total_tva;
195  public $multicurrency_total_ttc;
196 
200  const STATUS_DRAFT = 0;
201 
205  const STATUS_VALIDATED = 1;
206 
210  const STATUS_SIGNED = 2;
211 
215  const STATUS_NOTSIGNED = 3;
216 
220  const STATUS_CLOSE = 4;
221 
222 
223 
231  public function __construct($db, $socid = "", $supplier_proposalid = 0)
232  {
233  global $conf, $langs;
234 
235  $this->db = $db;
236 
237  $this->socid = $socid;
238  $this->id = $supplier_proposalid;
239  }
240 
241 
242  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
253  public function add_product($idproduct, $qty, $remise_percent = 0)
254  {
255  // phpcs:enable
256  global $conf, $mysoc;
257 
258  if (!$qty) {
259  $qty = 1;
260  }
261 
262  dol_syslog(get_class($this)."::add_product $idproduct, $qty, $remise_percent");
263  if ($idproduct > 0) {
264  $prod = new Product($this->db);
265  $prod->fetch($idproduct);
266 
267  $productdesc = $prod->description;
268 
269  $tva_tx = get_default_tva($mysoc, $this->thirdparty, $prod->id);
270  $tva_npr = get_default_npr($mysoc, $this->thirdparty, $prod->id);
271  if (empty($tva_tx)) {
272  $tva_npr = 0;
273  }
274  $localtax1_tx = get_localtax($tva_tx, 1, $mysoc, $this->thirdparty, $tva_npr);
275  $localtax2_tx = get_localtax($tva_tx, 2, $mysoc, $this->thirdparty, $tva_npr);
276 
277  // multiprix
278  if ($conf->global->PRODUIT_MULTIPRICES && $this->thirdparty->price_level) {
279  $price = $prod->multiprices[$this->thirdparty->price_level];
280  } else {
281  $price = $prod->price;
282  }
283 
284  $line = new SupplierProposalLine($this->db);
285 
286  $line->fk_product = $idproduct;
287  $line->desc = $productdesc;
288  $line->qty = $qty;
289  $line->subprice = $price;
290  $line->remise_percent = $remise_percent;
291  $line->tva_tx = $tva_tx;
292 
293  $this->lines[] = $line;
294  return 1;
295  }
296  return -1;
297  }
298 
299  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
306  public function insert_discount($idremise)
307  {
308  // phpcs:enable
309  global $langs;
310 
311  include_once DOL_DOCUMENT_ROOT.'/core/lib/price.lib.php';
312  include_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php';
313 
314  $this->db->begin();
315 
316  $remise = new DiscountAbsolute($this->db);
317  $result = $remise->fetch($idremise);
318 
319  if ($result > 0) {
320  if ($remise->fk_facture) { // Protection against multiple submission
321  $this->error = $langs->trans("ErrorDiscountAlreadyUsed");
322  $this->db->rollback();
323  return -5;
324  }
325 
326  $supplier_proposalligne = new SupplierProposalLine($this->db);
327  $supplier_proposalligne->fk_supplier_proposal = $this->id;
328  $supplier_proposalligne->fk_remise_except = $remise->id;
329  $supplier_proposalligne->desc = $remise->description; // Description ligne
330  $supplier_proposalligne->tva_tx = $remise->tva_tx;
331  $supplier_proposalligne->subprice = -$remise->amount_ht;
332  $supplier_proposalligne->fk_product = 0; // Id produit predefini
333  $supplier_proposalligne->qty = 1;
334  $supplier_proposalligne->remise_percent = 0;
335  $supplier_proposalligne->rang = -1;
336  $supplier_proposalligne->info_bits = 2;
337 
338  $supplier_proposalligne->total_ht = -$remise->amount_ht;
339  $supplier_proposalligne->total_tva = -$remise->amount_tva;
340  $supplier_proposalligne->total_ttc = -$remise->amount_ttc;
341 
342  $result = $supplier_proposalligne->insert();
343  if ($result > 0) {
344  $result = $this->update_price(1);
345  if ($result > 0) {
346  $this->db->commit();
347  return 1;
348  } else {
349  $this->db->rollback();
350  return -1;
351  }
352  } else {
353  $this->error = $supplier_proposalligne->error;
354  $this->db->rollback();
355  return -2;
356  }
357  } else {
358  $this->db->rollback();
359  return -2;
360  }
361  }
362 
400  public function addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 0, $fk_product = 0, $remise_percent = 0, $price_base_type = 'HT', $pu_ttc = 0, $info_bits = 0, $type = 0, $rang = -1, $special_code = 0, $fk_parent_line = 0, $fk_fournprice = 0, $pa_ht = 0, $label = '', $array_options = 0, $ref_supplier = '', $fk_unit = '', $origin = '', $origin_id = 0, $pu_ht_devise = 0, $date_start = 0, $date_end = 0)
401  {
402  global $mysoc, $conf, $langs;
403 
404  dol_syslog(get_class($this)."::addline supplier_proposalid=$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");
405  include_once DOL_DOCUMENT_ROOT.'/core/lib/price.lib.php';
406 
407  // Clean parameters
408  if (empty($remise_percent)) {
409  $remise_percent = 0;
410  }
411  if (empty($qty)) {
412  $qty = 0;
413  }
414  if (empty($info_bits)) {
415  $info_bits = 0;
416  }
417  if (empty($rang)) {
418  $rang = 0;
419  }
420  if (empty($fk_parent_line) || $fk_parent_line < 0) {
421  $fk_parent_line = 0;
422  }
423  if (empty($pu_ht)) {
424  $pu_ht = 0;
425  }
426 
427  $remise_percent = price2num($remise_percent);
428  $qty = price2num($qty);
429  $pu_ht = price2num($pu_ht);
430  $pu_ttc = price2num($pu_ttc);
431  if (!preg_match('/\((.*)\)/', $txtva)) {
432  $txtva = price2num($txtva); // $txtva can have format '5.0(XXX)' or '5'
433  }
434  $txlocaltax1 = price2num($txlocaltax1);
435  $txlocaltax2 = price2num($txlocaltax2);
436  $pa_ht = price2num($pa_ht);
437  if ($price_base_type == 'HT') {
438  $pu = $pu_ht;
439  } else {
440  $pu = $pu_ttc;
441  }
442 
443  // Check parameters
444  if ($type < 0) {
445  return -1;
446  }
447 
448  if ($this->statut == self::STATUS_DRAFT) {
449  $this->db->begin();
450 
451  if ($fk_product > 0) {
452  if (!empty($conf->global->SUPPLIER_PROPOSAL_WITH_PREDEFINED_PRICES_ONLY)) {
453  // Check quantity is enough
454  dol_syslog(get_class($this)."::addline we check supplier prices fk_product=".$fk_product." fk_fournprice=".$fk_fournprice." qty=".$qty." ref_supplier=".$ref_supplier);
455  $productsupplier = new ProductFournisseur($this->db);
456  if ($productsupplier->fetch($fk_product) > 0) {
457  $product_type = $productsupplier->type;
458  $label = $productsupplier->label;
459  $fk_prod_fourn_price = $fk_fournprice;
460 
461  // We use 'none' instead of $ref_supplier, because fourn_ref may not exists anymore. So we will take the first supplier price ok.
462  // If we want a dedicated supplier price, we must provide $fk_prod_fourn_price.
463  $result = $productsupplier->get_buyprice($fk_prod_fourn_price, $qty, $fk_product, 'none', ($this->fk_soc ? $this->fk_soc : $this->socid)); // Search on couple $fk_prod_fourn_price/$qty first, then on triplet $qty/$fk_product/$ref_supplier/$this->fk_soc
464  if ($result > 0) {
465  $pu = $productsupplier->fourn_pu; // Unit price supplier price set by get_buyprice
466  $ref_supplier = $productsupplier->ref_supplier; // Ref supplier price set by get_buyprice
467  // is remise percent not keyed but present for the product we add it
468  if ($remise_percent == 0 && $productsupplier->remise_percent != 0) {
469  $remise_percent = $productsupplier->remise_percent;
470  }
471  }
472  if ($result == 0) { // If result == 0, we failed to found the supplier reference price
473  $langs->load("errors");
474  $this->error = "Ref ".$productsupplier->ref." ".$langs->trans("ErrorQtyTooLowForThisSupplier");
475  $this->db->rollback();
476  dol_syslog(get_class($this)."::addline we did not found supplier price, so we can't guess unit price");
477  //$pu = $productsupplier->fourn_pu; // We do not overwrite unit price
478  //$ref = $productsupplier_fourn; // We do not overwrite ref supplier price
479  return -1;
480  }
481  if ($result == -1) {
482  $langs->load("errors");
483  $this->error = "Ref ".$productsupplier->ref." ".$langs->trans("ErrorQtyTooLowForThisSupplier");
484  $this->db->rollback();
485  dol_syslog(get_class($this)."::addline result=".$result." - ".$this->error, LOG_DEBUG);
486  return -1;
487  }
488  if ($result < -1) {
489  $this->error = $productsupplier->error;
490  $this->errors = $productsupplier->errors;
491  $this->db->rollback();
492  dol_syslog(get_class($this)."::addline result=".$result." - ".$this->error, LOG_ERR);
493  return -1;
494  }
495  } else {
496  $this->error = $productsupplier->error;
497  $this->errors = $productsupplier->errors;
498  $this->db->rollback();
499  return -1;
500  }
501  }
502  } else {
503  $product_type = $type;
504  }
505 
506  // Calcul du total TTC et de la TVA pour la ligne a partir de
507  // qty, pu, remise_percent et txtva
508  // TRES IMPORTANT: C'est au moment de l'insertion ligne qu'on doit stocker
509  // la part ht, tva et ttc, et ce au niveau de la ligne qui a son propre taux tva.
510 
511  $localtaxes_type = getLocalTaxesFromRate($txtva, 0, $this->thirdparty, $mysoc);
512 
513  // Clean vat code
514  $reg = array();
515  $vat_src_code = '';
516  if (preg_match('/\((.*)\)/', $txtva, $reg)) {
517  $vat_src_code = $reg[1];
518  $txtva = preg_replace('/\s*\(.*\)/', '', $txtva); // Remove code into vatrate.
519  }
520 
521  if (isModEnabled("multicurrency") && $pu_ht_devise > 0) {
522  $pu = 0;
523  }
524 
525  $tabprice = calcul_price_total($qty, $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $type, $this->thirdparty, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);
526  $total_ht = $tabprice[0];
527  $total_tva = $tabprice[1];
528  $total_ttc = $tabprice[2];
529  $total_localtax1 = $tabprice[9];
530  $total_localtax2 = $tabprice[10];
531  $pu = $pu_ht = $tabprice[3];
532 
533  // MultiCurrency
534  $multicurrency_total_ht = $tabprice[16];
535  $multicurrency_total_tva = $tabprice[17];
536  $multicurrency_total_ttc = $tabprice[18];
537  $pu_ht_devise = $tabprice[19];
538 
539  // Rang to use
540  $ranktouse = $rang;
541  if ($ranktouse == -1) {
542  $rangmax = $this->line_max($fk_parent_line);
543  $ranktouse = $rangmax + 1;
544  }
545 
546  // TODO A virer
547  // Anciens indicateurs: $price, $remise (a ne plus utiliser)
548  $price = $pu;
549  $remise = 0;
550  if ($remise_percent > 0) {
551  $remise = round(($pu * $remise_percent / 100), 2);
552  $price = $pu - $remise;
553  }
554 
555  // Insert line
556  $this->line = new SupplierProposalLine($this->db);
557 
558  $this->line->fk_supplier_proposal = $this->id;
559  $this->line->label = $label;
560  $this->line->desc = $desc;
561  $this->line->qty = $qty;
562 
563  $this->line->vat_src_code = $vat_src_code;
564  $this->line->tva_tx = $txtva;
565  $this->line->localtax1_tx = ($total_localtax1 ? $localtaxes_type[1] : 0);
566  $this->line->localtax2_tx = ($total_localtax2 ? $localtaxes_type[3] : 0);
567  $this->line->localtax1_type = empty($localtaxes_type[0]) ? '' : $localtaxes_type[0];
568  $this->line->localtax2_type = empty($localtaxes_type[2]) ? '' : $localtaxes_type[2];
569  $this->line->fk_product = $fk_product;
570  $this->line->remise_percent = $remise_percent;
571  $this->line->subprice = $pu_ht;
572  $this->line->rang = $ranktouse;
573  $this->line->info_bits = $info_bits;
574  $this->line->total_ht = $total_ht;
575  $this->line->total_tva = $total_tva;
576  $this->line->total_localtax1 = $total_localtax1;
577  $this->line->total_localtax2 = $total_localtax2;
578  $this->line->total_ttc = $total_ttc;
579  $this->line->product_type = $type;
580  $this->line->special_code = $special_code;
581  $this->line->fk_parent_line = $fk_parent_line;
582  $this->line->fk_unit = $fk_unit;
583  $this->line->origin = $origin;
584  $this->line->origin_id = $origin_id;
585  $this->line->ref_fourn = $this->db->escape($ref_supplier);
586  $this->line->date_start = $date_start;
587  $this->line->date_end = $date_end;
588 
589  // infos marge
590  if (!empty($fk_product) && $fk_product > 0 && empty($fk_fournprice) && empty($pa_ht)) {
591  // When fk_fournprice is 0, we take the lowest buying price
592  include_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.product.class.php';
593  $productFournisseur = new ProductFournisseur($this->db);
594  $productFournisseur->find_min_price_product_fournisseur($fk_product);
595  $this->line->fk_fournprice = $productFournisseur->product_fourn_price_id;
596  } else {
597  $this->line->fk_fournprice = ($fk_fournprice > 0 ? $fk_fournprice : 0); // If fk_fournprice is -1, we will not use fk_fournprice
598  }
599  $this->line->pa_ht = $pa_ht;
600  //var_dump($this->line->fk_fournprice);exit;
601 
602  // Multicurrency
603  $this->line->fk_multicurrency = $this->fk_multicurrency;
604  $this->line->multicurrency_code = $this->multicurrency_code;
605  $this->line->multicurrency_subprice = $pu_ht_devise;
606  $this->line->multicurrency_total_ht = $multicurrency_total_ht;
607  $this->line->multicurrency_total_tva = $multicurrency_total_tva;
608  $this->line->multicurrency_total_ttc = $multicurrency_total_ttc;
609 
610  // Mise en option de la ligne
611  if (empty($qty) && empty($special_code)) {
612  $this->line->special_code = 3;
613  }
614 
615  if (is_array($array_options) && count($array_options) > 0) {
616  $this->line->array_options = $array_options;
617  }
618 
619  $result = $this->line->insert();
620  if ($result > 0) {
621  // Reorder if child line
622  if (!empty($fk_parent_line)) {
623  $this->line_order(true, 'DESC');
624  } elseif ($ranktouse > 0 && $ranktouse <= count($this->lines)) { // Update all rank of all other lines
625  $linecount = count($this->lines);
626  for ($ii = $ranktouse; $ii <= $linecount; $ii++) {
627  $this->updateRangOfLine($this->lines[$ii - 1]->id, $ii + 1);
628  }
629  }
630 
631  // Mise a jour informations denormalisees au niveau de la propale meme
632  $result = $this->update_price(1, 'auto', 0, $this->thirdparty); // This method is designed to add line from user input so total calculation must be done using 'auto' mode.
633  if ($result > 0) {
634  $this->db->commit();
635  return $this->line->id;
636  } else {
637  $this->error = $this->error();
638  $this->errors = $this->errors();
639  $this->db->rollback();
640  return -1;
641  }
642  } else {
643  $this->error = $this->line->error;
644  $this->errors = $this->line->errors;
645  $this->db->rollback();
646  return -2;
647  }
648  } else {
649  $this->error = 'BadStatusOfObjectToAddLine';
650  return -5;
651  }
652  }
653 
654 
681  public function updateline($rowid, $pu, $qty, $remise_percent, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 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, $array_options = 0, $ref_supplier = '', $fk_unit = '', $pu_ht_devise = 0)
682  {
683  global $conf, $user, $langs, $mysoc;
684 
685  dol_syslog(get_class($this)."::updateLine $rowid, $pu, $qty, $remise_percent, $txtva, $desc, $price_base_type, $info_bits");
686  include_once DOL_DOCUMENT_ROOT.'/core/lib/price.lib.php';
687 
688  // Clean parameters
689  $remise_percent = price2num($remise_percent);
690  $qty = price2num($qty);
691  $pu = price2num($pu);
692  if (!preg_match('/\((.*)\)/', $txtva)) {
693  $txtva = price2num($txtva); // $txtva can have format '5.0(XXX)' or '5'
694  }
695  $txlocaltax1 = price2num($txlocaltax1);
696  $txlocaltax2 = price2num($txlocaltax2);
697  $pa_ht = price2num($pa_ht);
698  if (empty($qty) && empty($special_code)) {
699  $special_code = 3; // Set option tag
700  }
701  if (!empty($qty) && $special_code == 3) {
702  $special_code = 0; // Remove option tag
703  }
704 
705  if ($this->statut == 0) {
706  $this->db->begin();
707 
708  // Calcul du total TTC et de la TVA pour la ligne a partir de
709  // qty, pu, remise_percent et txtva
710  // TRES IMPORTANT: C'est au moment de l'insertion ligne qu'on doit stocker
711  // la part ht, tva et ttc, et ce au niveau de la ligne qui a son propre taux tva.
712 
713  $localtaxes_type = getLocalTaxesFromRate($txtva, 0, $mysoc, $this->thirdparty);
714 
715  // Clean vat code
716  $reg = array();
717  $vat_src_code = '';
718  if (preg_match('/\((.*)\)/', $txtva, $reg)) {
719  $vat_src_code = $reg[1];
720  $txtva = preg_replace('/\s*\(.*\)/', '', $txtva); // Remove code into vatrate.
721  }
722 
723  if (isModEnabled("multicurrency") && $pu_ht_devise > 0) {
724  $pu = 0;
725  }
726 
727  $tabprice = calcul_price_total($qty, $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $type, $this->thirdparty, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);
728  $total_ht = $tabprice[0];
729  $total_tva = $tabprice[1];
730  $total_ttc = $tabprice[2];
731  $total_localtax1 = $tabprice[9];
732  $total_localtax2 = $tabprice[10];
733  $pu_ht = $tabprice[3];
734  $pu_tva = $tabprice[4];
735  $pu_ttc = $tabprice[5];
736 
737  // MultiCurrency
738  $multicurrency_total_ht = $tabprice[16];
739  $multicurrency_total_tva = $tabprice[17];
740  $multicurrency_total_ttc = $tabprice[18];
741  $pu_ht_devise = $tabprice[19];
742 
743  $pu = $pu_ht;
744  if ($price_base_type == 'TTC') {
745  $pu = $pu_ttc;
746  }
747 
748  //Fetch current line from the database and then clone the object and set it in $oldline property
749  $line = new SupplierProposalLine($this->db);
750  $line->fetch($rowid);
751  $line->fetch_optionals();
752 
753  // Stock previous line records
754  $staticline = clone $line;
755 
756  $line->oldline = $staticline;
757  $this->line = $line;
758  $this->line->context = $this->context;
759 
760  // Reorder if fk_parent_line change
761  if (!empty($fk_parent_line) && !empty($staticline->fk_parent_line) && $fk_parent_line != $staticline->fk_parent_line) {
762  $rangmax = $this->line_max($fk_parent_line);
763  $this->line->rang = $rangmax + 1;
764  }
765 
766  $this->line->id = $rowid;
767  $this->line->label = $label;
768  $this->line->desc = $desc;
769  $this->line->qty = $qty;
770  $this->line->product_type = $type;
771 
772  $this->line->vat_src_code = $vat_src_code;
773  $this->line->tva_tx = $txtva;
774  $this->line->localtax1_tx = $txlocaltax1;
775  $this->line->localtax2_tx = $txlocaltax2;
776  $this->line->localtax1_type = empty($localtaxes_type[0]) ? '' : $localtaxes_type[0];
777  $this->line->localtax2_type = empty($localtaxes_type[2]) ? '' : $localtaxes_type[2];
778  $this->line->remise_percent = $remise_percent;
779  $this->line->subprice = $pu;
780  $this->line->info_bits = $info_bits;
781  $this->line->total_ht = $total_ht;
782  $this->line->total_tva = $total_tva;
783  $this->line->total_localtax1 = $total_localtax1;
784  $this->line->total_localtax2 = $total_localtax2;
785  $this->line->total_ttc = $total_ttc;
786  $this->line->special_code = $special_code;
787  $this->line->fk_parent_line = $fk_parent_line;
788  $this->line->skip_update_total = $skip_update_total;
789  $this->line->ref_fourn = $ref_supplier;
790  $this->line->fk_unit = $fk_unit;
791 
792  // infos marge
793  if (!empty($fk_product) && $fk_product > 0 && empty($fk_fournprice) && empty($pa_ht)) {
794  // by external module, take lowest buying price
795  include_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.product.class.php';
796  $productFournisseur = new ProductFournisseur($this->db);
797  $productFournisseur->find_min_price_product_fournisseur($fk_product);
798  $this->line->fk_fournprice = $productFournisseur->product_fourn_price_id;
799  } else {
800  $this->line->fk_fournprice = $fk_fournprice;
801  }
802  $this->line->pa_ht = $pa_ht;
803 
804  if (is_array($array_options) && count($array_options) > 0) {
805  // We replace values in this->line->array_options only for entries defined into $array_options
806  foreach ($array_options as $key => $value) {
807  $this->line->array_options[$key] = $array_options[$key];
808  }
809  }
810 
811  // Multicurrency
812  $this->line->multicurrency_subprice = $pu_ht_devise;
813  $this->line->multicurrency_total_ht = $multicurrency_total_ht;
814  $this->line->multicurrency_total_tva = $multicurrency_total_tva;
815  $this->line->multicurrency_total_ttc = $multicurrency_total_ttc;
816 
817  $result = $this->line->update();
818  if ($result > 0) {
819  // Reorder if child line
820  if (!empty($fk_parent_line)) {
821  $this->line_order(true, 'DESC');
822  }
823 
824  $this->update_price(1);
825 
826  $this->fk_supplier_proposal = $this->id;
827 
828  $this->db->commit();
829  return $result;
830  } else {
831  $this->error = $this->db->error();
832  $this->db->rollback();
833  return -1;
834  }
835  } else {
836  dol_syslog(get_class($this)."::updateline Erreur -2 SupplierProposal en mode incompatible pour cette action");
837  return -2;
838  }
839  }
840 
841 
848  public function deleteline($lineid)
849  {
850  if ($this->statut == 0) {
851  $line = new SupplierProposalLine($this->db);
852 
853  // For triggers
854  $line->fetch($lineid);
855 
856  if ($line->delete() > 0) {
857  $this->update_price(1);
858 
859  return 1;
860  } else {
861  return -1;
862  }
863  } else {
864  return -2;
865  }
866  }
867 
868 
877  public function create($user, $notrigger = 0)
878  {
879  global $langs, $conf, $mysoc, $hookmanager;
880  $error = 0;
881 
882  $now = dol_now();
883 
884  dol_syslog(get_class($this)."::create");
885 
886  // Check parameters
887  $result = $this->fetch_thirdparty();
888  if ($result < 0) {
889  $this->error = "Failed to fetch company";
890  dol_syslog(get_class($this)."::create ".$this->error, LOG_ERR);
891  return -3;
892  }
893  if (!empty($this->ref)) { // We check that ref is not already used
894  $result = self::isExistingObject($this->element, 0, $this->ref); // Check ref is not yet used
895  if ($result > 0) {
896  $this->error = 'ErrorRefAlreadyExists';
897  dol_syslog(get_class($this)."::create ".$this->error, LOG_WARNING);
898  $this->db->rollback();
899  return -1;
900  }
901  }
902 
903  // Set tmp vars
904  $delivery_date = empty($this->delivery_date) ? $this->date_livraison : $this->delivery_date;
905 
906  // Multicurrency
907  if (!empty($this->multicurrency_code)) {
908  list($this->fk_multicurrency, $this->multicurrency_tx) = MultiCurrency::getIdAndTxFromCode($this->db, $this->multicurrency_code, $now);
909  }
910  if (empty($this->fk_multicurrency)) {
911  $this->multicurrency_code = $conf->currency;
912  $this->fk_multicurrency = 0;
913  $this->multicurrency_tx = 1;
914  }
915 
916  $this->db->begin();
917 
918  // Insert into database
919  $sql = "INSERT INTO ".MAIN_DB_PREFIX."supplier_proposal (";
920  $sql .= "fk_soc";
921  $sql .= ", price";
922  $sql .= ", remise";
923  $sql .= ", remise_percent";
924  $sql .= ", remise_absolue";
925  $sql .= ", total_tva";
926  $sql .= ", total_ttc";
927  $sql .= ", datec";
928  $sql .= ", ref";
929  $sql .= ", fk_user_author";
930  $sql .= ", note_private";
931  $sql .= ", note_public";
932  $sql .= ", model_pdf";
933  $sql .= ", fk_cond_reglement";
934  $sql .= ", fk_mode_reglement";
935  $sql .= ", fk_account";
936  $sql .= ", date_livraison";
937  $sql .= ", fk_shipping_method";
938  $sql .= ", fk_projet";
939  $sql .= ", entity";
940  $sql .= ", fk_multicurrency";
941  $sql .= ", multicurrency_code";
942  $sql .= ", multicurrency_tx";
943  $sql .= ") ";
944  $sql .= " VALUES (";
945  $sql .= ((int) $this->socid);
946  $sql .= ", 0";
947  $sql .= ", ".((double) $this->remise);
948  $sql .= ", ".($this->remise_percent ? ((double) $this->remise_percent) : 'null');
949  $sql .= ", ".($this->remise_absolue ? ((double) $this->remise_absolue) : 'null');
950  $sql .= ", 0";
951  $sql .= ", 0";
952  $sql .= ", '".$this->db->idate($now)."'";
953  $sql .= ", '(PROV)'";
954  $sql .= ", ".($user->id > 0 ? ((int) $user->id) : "null");
955  $sql .= ", '".$this->db->escape($this->note_private)."'";
956  $sql .= ", '".$this->db->escape($this->note_public)."'";
957  $sql .= ", '".$this->db->escape($this->model_pdf)."'";
958  $sql .= ", ".($this->cond_reglement_id > 0 ? ((int) $this->cond_reglement_id) : 'NULL');
959  $sql .= ", ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) : 'NULL');
960  $sql .= ", ".($this->fk_account > 0 ? ((int) $this->fk_account) : 'NULL');
961  $sql .= ", ".($delivery_date ? "'".$this->db->idate($delivery_date)."'" : "null");
962  $sql .= ", ".($this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) : 'NULL');
963  $sql .= ", ".($this->fk_project > 0 ? ((int) $this->fk_project) : "null");
964  $sql .= ", ".((int) $conf->entity);
965  $sql .= ", ".((int) $this->fk_multicurrency);
966  $sql .= ", '".$this->db->escape($this->multicurrency_code)."'";
967  $sql .= ", ".((double) $this->multicurrency_tx);
968  $sql .= ")";
969 
970  dol_syslog(get_class($this)."::create", LOG_DEBUG);
971  $resql = $this->db->query($sql);
972  if ($resql) {
973  $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX."supplier_proposal");
974 
975  if ($this->id) {
976  $this->ref = '(PROV'.$this->id.')';
977  $sql = 'UPDATE '.MAIN_DB_PREFIX."supplier_proposal SET ref='".$this->db->escape($this->ref)."' WHERE rowid=".((int) $this->id);
978 
979  dol_syslog(get_class($this)."::create", LOG_DEBUG);
980  $resql = $this->db->query($sql);
981  if (!$resql) {
982  $error++;
983  }
984 
985  if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) { // To use new linkedObjectsIds instead of old linked_objects
986  $this->linked_objects = $this->linkedObjectsIds; // TODO Replace linked_objects with linkedObjectsIds
987  }
988 
989  // Add object linked
990  if (!$error && $this->id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
991  foreach ($this->linked_objects as $origin => $tmp_origin_id) {
992  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, ...))
993  foreach ($tmp_origin_id as $origin_id) {
994  $ret = $this->add_object_linked($origin, $origin_id);
995  if (!$ret) {
996  dol_print_error($this->db);
997  $error++;
998  }
999  }
1000  }
1001  }
1002  }
1003 
1004  /*
1005  * Insertion du detail des produits dans la base
1006  */
1007  if (!$error) {
1008  $fk_parent_line = 0;
1009  $num = count($this->lines);
1010 
1011  for ($i = 0; $i < $num; $i++) {
1012  // Reset fk_parent_line for no child products and special product
1013  if (($this->lines[$i]->product_type != 9 && empty($this->lines[$i]->fk_parent_line)) || $this->lines[$i]->product_type == 9) {
1014  $fk_parent_line = 0;
1015  }
1016 
1017  $result = $this->addline(
1018  $this->lines[$i]->desc,
1019  $this->lines[$i]->subprice,
1020  $this->lines[$i]->qty,
1021  $this->lines[$i]->tva_tx,
1022  $this->lines[$i]->localtax1_tx,
1023  $this->lines[$i]->localtax2_tx,
1024  $this->lines[$i]->fk_product,
1025  $this->lines[$i]->remise_percent,
1026  'HT',
1027  0,
1028  0,
1029  $this->lines[$i]->product_type,
1030  $this->lines[$i]->rang,
1031  $this->lines[$i]->special_code,
1032  $fk_parent_line,
1033  $this->lines[$i]->fk_fournprice,
1034  $this->lines[$i]->pa_ht,
1035  empty($this->lines[$i]->label) ? '' : $this->lines[$i]->label, // deprecated
1036  $this->lines[$i]->array_options,
1037  $this->lines[$i]->ref_fourn,
1038  $this->lines[$i]->fk_unit,
1039  'supplier_proposal',
1040  $this->lines[$i]->rowid
1041  );
1042 
1043  if ($result < 0) {
1044  $error++;
1045  $this->error = $this->db->error;
1046  dol_print_error($this->db);
1047  break;
1048  }
1049  // Defined the new fk_parent_line
1050  if ($result > 0 && $this->lines[$i]->product_type == 9) {
1051  $fk_parent_line = $result;
1052  }
1053  }
1054  }
1055 
1056  if (!$error) {
1057  // Mise a jour infos denormalisees
1058  $resql = $this->update_price(1);
1059  if ($resql) {
1060  $action = 'update';
1061 
1062  // Actions on extra fields
1063  if (!$error) {
1064  $result = $this->insertExtraFields();
1065  if ($result < 0) {
1066  $error++;
1067  }
1068  }
1069 
1070  if (!$error && !$notrigger) {
1071  // Call trigger
1072  $result = $this->call_trigger('PROPOSAL_SUPPLIER_CREATE', $user);
1073  if ($result < 0) {
1074  $error++;
1075  }
1076  // End call triggers
1077  }
1078  } else {
1079  $this->error = $this->db->lasterror();
1080  $error++;
1081  }
1082  }
1083  } else {
1084  $this->error = $this->db->lasterror();
1085  $error++;
1086  }
1087 
1088  if (!$error) {
1089  $this->db->commit();
1090  dol_syslog(get_class($this)."::create done id=".$this->id);
1091  return $this->id;
1092  } else {
1093  $this->db->rollback();
1094  return -2;
1095  }
1096  } else {
1097  $this->error = $this->db->lasterror();
1098  $this->db->rollback();
1099  return -1;
1100  }
1101  }
1102 
1110  public function createFromClone(User $user, $fromid = 0)
1111  {
1112  global $conf, $hookmanager;
1113 
1114  $error = 0;
1115  $now = dol_now();
1116 
1117  $this->db->begin();
1118 
1119  // get extrafields so they will be clone
1120  foreach ($this->lines as $line) {
1121  $line->fetch_optionals();
1122  }
1123 
1124  // Load source object
1125  $objFrom = clone $this;
1126 
1127  $objsoc = new Societe($this->db);
1128 
1129  // Change socid if needed
1130  if (!empty($fromid) && $fromid != $this->socid) {
1131  if ($objsoc->fetch($fromid) > 0) {
1132  $this->socid = $objsoc->id;
1133  $this->cond_reglement_id = (!empty($objsoc->cond_reglement_id) ? $objsoc->cond_reglement_id : 0);
1134  $this->mode_reglement_id = (!empty($objsoc->mode_reglement_id) ? $objsoc->mode_reglement_id : 0);
1135  $this->fk_project = '';
1136  }
1137 
1138  // TODO Change product price if multi-prices
1139  } else {
1140  $objsoc->fetch($this->socid);
1141  }
1142 
1143  $this->id = 0;
1144  $this->statut = 0;
1145 
1146  if (empty($conf->global->SUPPLIER_PROPOSAL_ADDON) || !is_readable(DOL_DOCUMENT_ROOT."/core/modules/supplier_proposal/".$conf->global->SUPPLIER_PROPOSAL_ADDON.".php")) {
1147  $this->error = 'ErrorSetupNotComplete';
1148  return -1;
1149  }
1150 
1151  // Clear fields
1152  $this->user_author = $user->id; // deprecated
1153  $this->user_author_id = $user->id;
1154  $this->user_valid = 0; // deprecated
1155  $this->user_valid_id = 0;
1156  $this->date = $now;
1157 
1158  // Set ref
1159  require_once DOL_DOCUMENT_ROOT."/core/modules/supplier_proposal/".$conf->global->SUPPLIER_PROPOSAL_ADDON.'.php';
1160  $obj = $conf->global->SUPPLIER_PROPOSAL_ADDON;
1161  $modSupplierProposal = new $obj;
1162  $this->ref = $modSupplierProposal->getNextValue($objsoc, $this);
1163 
1164  // Create clone
1165  $this->context['createfromclone'] = 'createfromclone';
1166  $result = $this->create($user);
1167  if ($result < 0) {
1168  $error++;
1169  }
1170 
1171  if (!$error) {
1172  // Hook of thirdparty module
1173  if (is_object($hookmanager)) {
1174  $parameters = array('objFrom'=>$objFrom);
1175  $action = '';
1176  $reshook = $hookmanager->executeHooks('createFrom', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
1177  if ($reshook < 0) {
1178  $this->setErrorsFromObject($hookmanager);
1179  $error++;
1180  }
1181  }
1182  }
1183 
1184  unset($this->context['createfromclone']);
1185 
1186  // End
1187  if (!$error) {
1188  $this->db->commit();
1189  return $this->id;
1190  } else {
1191  $this->db->rollback();
1192  return -1;
1193  }
1194  }
1195 
1203  public function fetch($rowid, $ref = '')
1204  {
1205  global $conf;
1206 
1207  $sql = "SELECT p.rowid, p.entity, p.ref, p.remise, p.remise_percent, p.remise_absolue, p.fk_soc";
1208  $sql .= ", p.total_ttc, p.total_tva, p.localtax1, p.localtax2, p.total_ht";
1209  $sql .= ", p.datec";
1210  $sql .= ", p.date_valid as datev";
1211  $sql .= ", p.date_livraison as delivery_date";
1212  $sql .= ", p.model_pdf, p.extraparams";
1213  $sql .= ", p.note_private, p.note_public";
1214  $sql .= ", p.fk_projet as fk_project, p.fk_statut";
1215  $sql .= ", p.fk_user_author, p.fk_user_valid, p.fk_user_cloture";
1216  $sql .= ", p.fk_cond_reglement";
1217  $sql .= ", p.fk_mode_reglement";
1218  $sql .= ', p.fk_account';
1219  $sql .= ", p.fk_shipping_method";
1220  $sql .= ", p.fk_multicurrency, p.multicurrency_code, p.multicurrency_tx, p.multicurrency_total_ht, p.multicurrency_total_tva, p.multicurrency_total_ttc";
1221  $sql .= ", c.label as statut_label";
1222  $sql .= ", cr.code as cond_reglement_code, cr.libelle as cond_reglement, cr.libelle_facture as cond_reglement_libelle_doc";
1223  $sql .= ", cp.code as mode_reglement_code, cp.libelle as mode_reglement";
1224  $sql .= " FROM ".MAIN_DB_PREFIX."c_propalst as c, ".MAIN_DB_PREFIX."supplier_proposal as p";
1225  $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_paiement as cp ON p.fk_mode_reglement = cp.id';
1226  $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_payment_term as cr ON p.fk_cond_reglement = cr.rowid';
1227  $sql .= " WHERE p.fk_statut = c.id";
1228  $sql .= " AND p.entity IN (".getEntity('supplier_proposal').")";
1229  if ($ref) {
1230  $sql .= " AND p.ref = '".$this->db->escape($ref)."'";
1231  } else {
1232  $sql .= " AND p.rowid = ".((int) $rowid);
1233  }
1234 
1235  dol_syslog(get_class($this)."::fetch", LOG_DEBUG);
1236  $resql = $this->db->query($sql);
1237  if ($resql) {
1238  if ($this->db->num_rows($resql)) {
1239  $obj = $this->db->fetch_object($resql);
1240 
1241  $this->id = $obj->rowid;
1242  $this->entity = $obj->entity;
1243 
1244  $this->ref = $obj->ref;
1245  $this->remise = $obj->remise;
1246  $this->remise_percent = $obj->remise_percent;
1247  $this->remise_absolue = $obj->remise_absolue;
1248  $this->total_ht = $obj->total_ht;
1249  $this->total_tva = $obj->total_tva;
1250  $this->total_localtax1 = $obj->localtax1;
1251  $this->total_localtax2 = $obj->localtax2;
1252  $this->total_ttc = $obj->total_ttc;
1253  $this->socid = $obj->fk_soc;
1254  $this->fk_project = $obj->fk_project;
1255  $this->model_pdf = $obj->model_pdf;
1256  $this->modelpdf = $obj->model_pdf; // deprecated
1257  $this->note = $obj->note_private; // TODO deprecated
1258  $this->note_private = $obj->note_private;
1259  $this->note_public = $obj->note_public;
1260  $this->statut = (int) $obj->fk_statut;
1261  $this->status = (int) $obj->fk_statut;
1262  $this->statut_libelle = $obj->statut_label;
1263  $this->datec = $this->db->jdate($obj->datec); // TODO deprecated
1264  $this->datev = $this->db->jdate($obj->datev); // TODO deprecated
1265  $this->date_creation = $this->db->jdate($obj->datec); // Creation date
1266  $this->date = $this->date_creation;
1267  $this->date_validation = $this->db->jdate($obj->datev); // Validation date
1268  $this->date_livraison = $this->db->jdate($obj->delivery_date); // deprecated
1269  $this->delivery_date = $this->db->jdate($obj->delivery_date);
1270  $this->shipping_method_id = ($obj->fk_shipping_method > 0) ? $obj->fk_shipping_method : null;
1271 
1272  $this->mode_reglement_id = $obj->fk_mode_reglement;
1273  $this->mode_reglement_code = $obj->mode_reglement_code;
1274  $this->mode_reglement = $obj->mode_reglement;
1275  $this->fk_account = ($obj->fk_account > 0) ? $obj->fk_account : null;
1276  $this->cond_reglement_id = $obj->fk_cond_reglement;
1277  $this->cond_reglement_code = $obj->cond_reglement_code;
1278  $this->cond_reglement = $obj->cond_reglement;
1279  $this->cond_reglement_doc = $obj->cond_reglement_libelle_doc;
1280 
1281  $this->extraparams = (array) json_decode($obj->extraparams, true);
1282 
1283  $this->user_author_id = $obj->fk_user_author;
1284  $this->user_valid_id = $obj->fk_user_valid;
1285  $this->user_close_id = $obj->fk_user_cloture;
1286 
1287  // Multicurrency
1288  $this->fk_multicurrency = $obj->fk_multicurrency;
1289  $this->multicurrency_code = $obj->multicurrency_code;
1290  $this->multicurrency_tx = $obj->multicurrency_tx;
1291  $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
1292  $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
1293  $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
1294 
1295  if ($obj->fk_statut == 0) {
1296  $this->brouillon = 1;
1297  }
1298 
1299  // Retrieve all extrafield
1300  // fetch optionals attributes and labels
1301  $this->fetch_optionals();
1302 
1303  $this->db->free($resql);
1304 
1305  $this->lines = array();
1306 
1307  // Lines of supplier proposals
1308  $sql = "SELECT d.rowid, d.fk_supplier_proposal, d.fk_parent_line, d.label as custom_label, d.description, d.price, d.tva_tx, d.localtax1_tx, d.localtax2_tx, d.qty, d.fk_remise_except, d.remise_percent, d.subprice, d.fk_product,";
1309  $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,";
1310  $sql .= ' p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label,';
1311  $sql .= ' d.ref_fourn as ref_produit_fourn,';
1312  $sql .= ' d.fk_multicurrency, d.multicurrency_code, d.multicurrency_subprice, d.multicurrency_total_ht, d.multicurrency_total_tva, d.multicurrency_total_ttc, d.fk_unit';
1313  $sql .= " FROM ".MAIN_DB_PREFIX."supplier_proposaldet as d";
1314  $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."product as p ON d.fk_product = p.rowid";
1315  $sql .= " WHERE d.fk_supplier_proposal = ".((int) $this->id);
1316  $sql .= " ORDER by d.rang";
1317 
1318  $result = $this->db->query($sql);
1319  if ($result) {
1320  $num = $this->db->num_rows($result);
1321  $i = 0;
1322 
1323  while ($i < $num) {
1324  $objp = $this->db->fetch_object($result);
1325 
1326  $line = new SupplierProposalLine($this->db);
1327 
1328  $line->rowid = $objp->rowid; // deprecated
1329  $line->id = $objp->rowid;
1330  $line->fk_supplier_proposal = $objp->fk_supplier_proposal;
1331  $line->fk_parent_line = $objp->fk_parent_line;
1332  $line->product_type = $objp->product_type;
1333  $line->label = $objp->custom_label;
1334  $line->desc = $objp->description; // Description ligne
1335  $line->qty = $objp->qty;
1336  $line->tva_tx = $objp->tva_tx;
1337  $line->localtax1_tx = $objp->localtax1_tx;
1338  $line->localtax2_tx = $objp->localtax2_tx;
1339  $line->subprice = $objp->subprice;
1340  $line->fk_remise_except = $objp->fk_remise_except;
1341  $line->remise_percent = $objp->remise_percent;
1342 
1343  $line->info_bits = $objp->info_bits;
1344  $line->total_ht = $objp->total_ht;
1345  $line->total_tva = $objp->total_tva;
1346  $line->total_localtax1 = $objp->total_localtax1;
1347  $line->total_localtax2 = $objp->total_localtax2;
1348  $line->total_ttc = $objp->total_ttc;
1349  $line->fk_fournprice = $objp->fk_fournprice;
1350  $marginInfos = getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $line->fk_fournprice, $objp->pa_ht);
1351  $line->pa_ht = $marginInfos[0];
1352  $line->marge_tx = $marginInfos[1];
1353  $line->marque_tx = $marginInfos[2];
1354  $line->special_code = $objp->special_code;
1355  $line->rang = $objp->rang;
1356 
1357  $line->fk_product = $objp->fk_product;
1358 
1359  $line->ref = $objp->product_ref; // deprecated
1360  $line->product_ref = $objp->product_ref;
1361  $line->libelle = $objp->product_label; // deprecated
1362  $line->product_label = $objp->product_label;
1363  $line->product_desc = $objp->product_desc; // Description produit
1364  $line->fk_product_type = $objp->fk_product_type;
1365 
1366  $line->ref_fourn = $objp->ref_produit_fourn;
1367 
1368  // Multicurrency
1369  $line->fk_multicurrency = $objp->fk_multicurrency;
1370  $line->multicurrency_code = $objp->multicurrency_code;
1371  $line->multicurrency_subprice = $objp->multicurrency_subprice;
1372  $line->multicurrency_total_ht = $objp->multicurrency_total_ht;
1373  $line->multicurrency_total_tva = $objp->multicurrency_total_tva;
1374  $line->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
1375  $line->fk_unit = $objp->fk_unit;
1376 
1377  $this->lines[$i] = $line;
1378 
1379  $i++;
1380  }
1381  $this->db->free($result);
1382  } else {
1383  $this->error = $this->db->error();
1384  return -1;
1385  }
1386 
1387  // Retrieve all extrafield
1388  // fetch optionals attributes and labels
1389  $this->fetch_optionals();
1390 
1391  return 1;
1392  }
1393 
1394  $this->error = "Record Not Found";
1395  return 0;
1396  } else {
1397  $this->error = $this->db->error();
1398  return -1;
1399  }
1400  }
1401 
1409  public function valid($user, $notrigger = 0)
1410  {
1411  require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
1412 
1413  global $conf, $langs;
1414 
1415  $error = 0;
1416  $now = dol_now();
1417 
1418  if ((empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !empty($user->rights->supplier_proposal->creer))
1419  || (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !empty($user->rights->supplier_proposal->validate_advance))) {
1420  $this->db->begin();
1421 
1422  // Numbering module definition
1423  $soc = new Societe($this->db);
1424  $result = $soc->fetch($this->socid);
1425 
1426  if ($result < 0) {
1427  return -1;
1428  }
1429 
1430  // Define new ref
1431  if (preg_match('/^[\(]?PROV/i', $this->ref) || empty($this->ref)) { // empty should not happened, but when it occurs, the test save life
1432  $num = $this->getNextNumRef($soc);
1433  } else {
1434  $num = $this->ref;
1435  }
1436  $this->newref = dol_sanitizeFileName($num);
1437 
1438  $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal";
1439  $sql .= " SET ref = '".$this->db->escape($num)."',";
1440  $sql .= " fk_statut = 1, date_valid='".$this->db->idate($now)."', fk_user_valid=".((int) $user->id);
1441  $sql .= " WHERE rowid = ".((int) $this->id)." AND fk_statut = 0";
1442 
1443  dol_syslog(get_class($this)."::valid", LOG_DEBUG);
1444  $resql = $this->db->query($sql);
1445  if (!$resql) {
1446  dol_print_error($this->db);
1447  $error++;
1448  }
1449 
1450  // Trigger calls
1451  if (!$error && !$notrigger) {
1452  // Call trigger
1453  $result = $this->call_trigger('PROPOSAL_SUPPLIER_VALIDATE', $user);
1454  if ($result < 0) {
1455  $error++;
1456  }
1457  // End call triggers
1458  }
1459 
1460  if (!$error) {
1461  $this->oldref = $this->ref;
1462 
1463  // Rename directory if dir was a temporary ref
1464  if (preg_match('/^[\(]?PROV/i', $this->ref)) {
1465  // Now we rename also files into index
1466  $sql = 'UPDATE '.MAIN_DB_PREFIX."ecm_files set filename = CONCAT('".$this->db->escape($this->newref)."', SUBSTR(filename, ".(strlen($this->ref) + 1).")), filepath = 'supplier_proposal/".$this->db->escape($this->newref)."'";
1467  $sql .= " WHERE filename LIKE '".$this->db->escape($this->ref)."%' AND filepath = 'supplier_proposal/".$this->db->escape($this->ref)."' and entity = ".$conf->entity;
1468  $resql = $this->db->query($sql);
1469  if (!$resql) {
1470  $error++; $this->error = $this->db->lasterror();
1471  }
1472 
1473  // We rename directory ($this->ref = old ref, $num = new ref) in order not to lose the attachments
1474  $oldref = dol_sanitizeFileName($this->ref);
1475  $newref = dol_sanitizeFileName($num);
1476  $dirsource = $conf->supplier_proposal->dir_output.'/'.$oldref;
1477  $dirdest = $conf->supplier_proposal->dir_output.'/'.$newref;
1478  if (!$error && file_exists($dirsource)) {
1479  dol_syslog(get_class($this)."::valid rename dir ".$dirsource." into ".$dirdest);
1480  if (@rename($dirsource, $dirdest)) {
1481  dol_syslog("Rename ok");
1482  // Rename docs starting with $oldref with $newref
1483  $listoffiles = dol_dir_list($conf->supplier_proposal->dir_output.'/'.$newref, 'files', 1, '^'.preg_quote($oldref, '/'));
1484  foreach ($listoffiles as $fileentry) {
1485  $dirsource = $fileentry['name'];
1486  $dirdest = preg_replace('/^'.preg_quote($oldref, '/').'/', $newref, $dirsource);
1487  $dirsource = $fileentry['path'].'/'.$dirsource;
1488  $dirdest = $fileentry['path'].'/'.$dirdest;
1489  @rename($dirsource, $dirdest);
1490  }
1491  }
1492  }
1493  }
1494 
1495  $this->ref = $num;
1496  $this->brouillon = 0;
1497  $this->statut = 1;
1498  $this->user_valid_id = $user->id;
1499  $this->datev = $now;
1500 
1501  $this->db->commit();
1502  return 1;
1503  } else {
1504  $this->db->rollback();
1505  return -1;
1506  }
1507  } else {
1508  dol_syslog("You don't have permission to validate supplier proposal", LOG_WARNING);
1509  return -2;
1510  }
1511  }
1512 
1513  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1522  public function set_date_livraison($user, $delivery_date)
1523  {
1524  // phpcs:enable
1525  return $this->setDeliveryDate($user, $delivery_date);
1526  }
1527 
1535  public function setDeliveryDate($user, $delivery_date)
1536  {
1537  if (!empty($user->rights->supplier_proposal->creer)) {
1538  $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal ";
1539  $sql .= " SET date_livraison = ".($delivery_date != '' ? "'".$this->db->idate($delivery_date)."'" : 'null');
1540  $sql .= " WHERE rowid = ".((int) $this->id);
1541 
1542  if ($this->db->query($sql)) {
1543  $this->date_livraison = $delivery_date;
1544  $this->delivery_date = $delivery_date;
1545  return 1;
1546  } else {
1547  $this->error = $this->db->error();
1548  dol_syslog(get_class($this)."::setDeliveryDate Erreur SQL");
1549  return -1;
1550  }
1551  }
1552  return 0;
1553  }
1554 
1555  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1563  public function set_remise_percent($user, $remise)
1564  {
1565  // phpcs:enable
1566  $remise = trim($remise) ?trim($remise) : 0;
1567 
1568  if (!empty($user->rights->supplier_proposal->creer)) {
1569  $remise = price2num($remise, 2);
1570 
1571  $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal SET remise_percent = ".((float) $remise);
1572  $sql .= " WHERE rowid = ".((int) $this->id)." AND fk_statut = 0";
1573 
1574  if ($this->db->query($sql)) {
1575  $this->remise_percent = ((float) $remise);
1576  $this->update_price(1);
1577  return 1;
1578  } else {
1579  $this->error = $this->db->error();
1580  return -1;
1581  }
1582  }
1583  return 0;
1584  }
1585 
1586 
1587  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1595  public function set_remise_absolue($user, $remise)
1596  {
1597  // phpcs:enable
1598  if (empty($remise)) {
1599  $remise = 0;
1600  }
1601 
1602  $remise = price2num($remise);
1603 
1604  if (!empty($user->rights->supplier_proposal->creer)) {
1605  $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal ";
1606  $sql .= " SET remise_absolue = ".((float) $remise);
1607  $sql .= " WHERE rowid = ".((int) $this->id)." AND fk_statut = 0";
1608 
1609  if ($this->db->query($sql)) {
1610  $this->remise_absolue = $remise;
1611  $this->update_price(1);
1612  return 1;
1613  } else {
1614  $this->error = $this->db->error();
1615  return -1;
1616  }
1617  }
1618  return 0;
1619  }
1620 
1621 
1622 
1632  public function reopen($user, $statut, $note = '', $notrigger = 0)
1633  {
1634  global $langs, $conf;
1635 
1636  $this->statut = $statut;
1637  $error = 0;
1638 
1639  $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal";
1640  $sql .= " SET fk_statut = ".((int) $this->statut).",";
1641  if (!empty($note)) {
1642  $sql .= " note_private = '".$this->db->escape($note)."',";
1643  }
1644  $sql .= " date_cloture=NULL, fk_user_cloture=NULL";
1645  $sql .= " WHERE rowid = ".((int) $this->id);
1646 
1647  $this->db->begin();
1648 
1649  dol_syslog(get_class($this)."::reopen", LOG_DEBUG);
1650  $resql = $this->db->query($sql);
1651  if (!$resql) {
1652  $error++; $this->errors[] = "Error ".$this->db->lasterror();
1653  }
1654  if (!$error) {
1655  if (!$notrigger) {
1656  // Call trigger
1657  $result = $this->call_trigger('PROPOSAL_SUPPLIER_REOPEN', $user);
1658  if ($result < 0) {
1659  $error++;
1660  }
1661  // End call triggers
1662  }
1663  }
1664 
1665  // Commit or rollback
1666  if ($error) {
1667  if (!empty($this->errors)) {
1668  foreach ($this->errors as $errmsg) {
1669  dol_syslog(get_class($this)."::update ".$errmsg, LOG_ERR);
1670  $this->error .= ($this->error ? ', '.$errmsg : $errmsg);
1671  }
1672  }
1673  $this->db->rollback();
1674  return -1 * $error;
1675  } else {
1676  $this->db->commit();
1677  return 1;
1678  }
1679  }
1680 
1681 
1690  public function cloture($user, $status, $note)
1691  {
1692  global $langs, $conf;
1693  $hidedetails = 0;
1694  $hidedesc = 0;
1695  $hideref = 0;
1696  $this->statut = $status;
1697  $error = 0;
1698  $now = dol_now();
1699 
1700  $this->db->begin();
1701 
1702  $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal";
1703  $sql .= " SET fk_statut = ".((int) $status).", note_private = '".$this->db->escape($note)."', date_cloture='".$this->db->idate($now)."', fk_user_cloture=".$user->id;
1704  $sql .= " WHERE rowid = ".((int) $this->id);
1705 
1706  $resql = $this->db->query($sql);
1707  if ($resql) {
1708  $modelpdf = $conf->global->SUPPLIER_PROPOSAL_ADDON_PDF_ODT_CLOSED ? $conf->global->SUPPLIER_PROPOSAL_ADDON_PDF_ODT_CLOSED : (empty($this->model_pdf) ? '' : $this->model_pdf);
1709  $triggerName = 'PROPOSAL_SUPPLIER_CLOSE_REFUSED';
1710 
1711  if ($status == 2) {
1712  $triggerName = 'PROPOSAL_SUPPLIER_CLOSE_SIGNED';
1713  $modelpdf = $conf->global->SUPPLIER_PROPOSAL_ADDON_PDF_ODT_TOBILL ? $conf->global->SUPPLIER_PROPOSAL_ADDON_PDF_ODT_TOBILL : (empty($this->model_pdf) ? '' : $this->model_pdf);
1714 
1715  if (!empty($conf->global->SUPPLIER_PROPOSAL_UPDATE_PRICE_ON_SUPPlIER_PROPOSAL)) { // TODO This option was not tested correctly. Error if product ref does not exists
1716  $result = $this->updateOrCreatePriceFournisseur($user);
1717  }
1718  }
1719  if ($status == 4) {
1720  $triggerName = 'PROPOSAL_SUPPLIER_CLASSIFY_BILLED';
1721  }
1722 
1723  if (empty($conf->global->MAIN_DISABLE_PDF_AUTOUPDATE)) {
1724  // Define output language
1725  $outputlangs = $langs;
1726  if (getDolGlobalInt('MAIN_MULTILANGS')) {
1727  $outputlangs = new Translate("", $conf);
1728  $newlang = (GETPOST('lang_id', 'aZ09') ? GETPOST('lang_id', 'aZ09') : $this->thirdparty->default_lang);
1729  $outputlangs->setDefaultLang($newlang);
1730  }
1731  //$ret=$object->fetch($id); // Reload to get new records
1732  $this->generateDocument($modelpdf, $outputlangs, $hidedetails, $hidedesc, $hideref);
1733  }
1734 
1735  // Call trigger
1736  $result = $this->call_trigger($triggerName, $user);
1737  if ($result < 0) {
1738  $error++;
1739  }
1740  // End call triggers
1741 
1742  if (!$error) {
1743  $this->db->commit();
1744  return 1;
1745  } else {
1746  $this->db->rollback();
1747  return -1;
1748  }
1749  } else {
1750  $this->error = $this->db->lasterror();
1751  $this->errors[] = $this->db->lasterror();
1752  $this->db->rollback();
1753  return -1;
1754  }
1755  }
1756 
1763  public function updateOrCreatePriceFournisseur($user)
1764  {
1765  global $conf;
1766 
1767  dol_syslog(get_class($this)."::updateOrCreatePriceFournisseur", LOG_DEBUG);
1768  foreach ($this->lines as $product) {
1769  if ($product->subprice <= 0) {
1770  continue;
1771  }
1772  $productsupplier = new ProductFournisseur($this->db);
1773 
1774  $multicurrency_tx = 1;
1775  $fk_multicurrency = 0;
1776 
1777  if (empty($this->thirdparty)) {
1778  $this->fetch_thirdparty();
1779  }
1780 
1781  $ref_fourn = $product->ref_fourn;
1782  if (empty($ref_fourn)) {
1783  $ref_fourn = $product->ref_supplier;
1784  }
1785  if (isModEnabled("multicurrency") && !empty($product->multicurrency_code)) {
1786  list($fk_multicurrency, $multicurrency_tx) = MultiCurrency::getIdAndTxFromCode($this->db, $product->multicurrency_code);
1787  }
1788  $productsupplier->id = $product->fk_product;
1789 
1790  $productsupplier->update_buyprice($product->qty, $product->total_ht, $user, 'HT', $this->thirdparty, '', $ref_fourn, $product->tva_tx, 0, 0, 0, $product->info_bits, '', '', array(), '', $product->multicurrency_total_ht, 'HT', $multicurrency_tx, $product->multicurrency_code, '', '', '');
1791  }
1792 
1793  return 1;
1794  }
1795 
1804  public function updatePriceFournisseur($idProductFournPrice, $product, $user)
1805  {
1806  $price = price2num($product->subprice * $product->qty, 'MU');
1807  $unitPrice = price2num($product->subprice, 'MU');
1808 
1809  $sql = 'UPDATE '.MAIN_DB_PREFIX.'product_fournisseur_price SET '.(!empty($product->ref_fourn) ? 'ref_fourn = "'.$this->db->escape($product->ref_fourn).'", ' : '').' price ='.((float) $price).', unitprice ='.((float) $unitPrice).' WHERE rowid = '.((int) $idProductFournPrice);
1810 
1811  $resql = $this->db->query($sql);
1812  if (!$resql) {
1813  $this->error = $this->db->error();
1814  $this->db->rollback();
1815  return -1;
1816  }
1817  return 1;
1818  }
1819 
1827  public function createPriceFournisseur($product, $user)
1828  {
1829  global $conf;
1830 
1831  $price = price2num($product->subprice * $product->qty, 'MU');
1832  $qty = price2num($product->qty);
1833  $unitPrice = price2num($product->subprice, 'MU');
1834 
1835  $now = dol_now();
1836 
1837  $values = array(
1838  "'".$this->db->idate($now)."'",
1839  $product->fk_product,
1840  $this->thirdparty->id,
1841  "'".$product->ref_fourn."'",
1842  $price,
1843  $qty,
1844  $unitPrice,
1845  $product->tva_tx,
1846  $user->id
1847  );
1848  if (isModEnabled("multicurrency")) {
1849  if (!empty($product->multicurrency_code)) {
1850  include_once DOL_DOCUMENT_ROOT.'/multicurrency/class/multicurrency.class.php';
1851  $multicurrency = new MultiCurrency($this->db); //need to fetch because empty fk_multicurrency and rate
1852  $multicurrency->fetch(0, $product->multicurrency_code);
1853  if (!empty($multicurrency->id)) {
1854  $values[] = $multicurrency->id;
1855  $values[] = "'".$product->multicurrency_code."'";
1856  $values[] = $product->multicurrency_subprice;
1857  $values[] = $product->multicurrency_total_ht;
1858  $values[] = $multicurrency->rate->rate;
1859  } else {
1860  for ($i = 0; $i < 5; $i++) {
1861  $values[] = 'NULL';
1862  }
1863  }
1864  }
1865  }
1866 
1867  $sql = 'INSERT INTO '.MAIN_DB_PREFIX.'product_fournisseur_price ';
1868  $sql .= '(datec, fk_product, fk_soc, ref_fourn, price, quantity, unitprice, tva_tx, fk_user';
1869  if (isModEnabled("multicurrency") && !empty($product->multicurrency_code)) {
1870  $sql .= ',fk_multicurrency, multicurrency_code, multicurrency_unitprice, multicurrency_price, multicurrency_tx';
1871  }
1872  $sql .= ') VALUES ('.implode(',', $values).')';
1873 
1874  $resql = $this->db->query($sql);
1875  if (!$resql) {
1876  $this->error = $this->db->error();
1877  $this->db->rollback();
1878  return -1;
1879  }
1880  return 1;
1881  }
1882 
1883  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1890  public function setDraft($user)
1891  {
1892  // phpcs:enable
1893  global $conf, $langs;
1894 
1895  $error = 0;
1896 
1897  if ($this->statut == self::STATUS_DRAFT) {
1898  dol_syslog(get_class($this)."::setDraft already draft status", LOG_WARNING);
1899  return 0;
1900  }
1901 
1902  $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal";
1903  $sql .= " SET fk_statut = ".self::STATUS_DRAFT;
1904  $sql .= " WHERE rowid = ".((int) $this->id);
1905 
1906  if ($this->db->query($sql)) {
1907  if (!$error) {
1908  $this->oldcopy = clone $this;
1909  }
1910 
1911  if (!$error) {
1912  // Call trigger
1913  $result = $this->call_trigger('PROPOSAL_SUPPLIER_UNVALIDATE', $user);
1914  if ($result < 0) {
1915  $error++;
1916  }
1917  }
1918 
1919  if (!$error) {
1920  $this->statut = self::STATUS_DRAFT;
1921  $this->brouillon = 1;
1922  $this->db->commit();
1923  return 1;
1924  } else {
1925  $this->db->rollback();
1926  return -1;
1927  }
1928  } else {
1929  return -1;
1930  }
1931  }
1932 
1933 
1934  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1948  public function liste_array($shortlist = 0, $draft = 0, $notcurrentuser = 0, $socid = 0, $limit = 0, $offset = 0, $sortfield = 'p.datec', $sortorder = 'DESC')
1949  {
1950  // phpcs:enable
1951  global $conf, $user;
1952 
1953  $ga = array();
1954 
1955  $sql = "SELECT s.rowid, s.nom as name, s.client,";
1956  $sql .= " p.rowid as supplier_proposalid, p.fk_statut, p.total_ht, p.ref, p.remise, ";
1957  $sql .= " p.datep as dp, p.fin_validite as datelimite";
1958  if (empty($user->rights->societe->client->voir) && !$socid) {
1959  $sql .= ", sc.fk_soc, sc.fk_user";
1960  }
1961  $sql .= " FROM ".MAIN_DB_PREFIX."societe as s, ".MAIN_DB_PREFIX."supplier_proposal as p, ".MAIN_DB_PREFIX."c_propalst as c";
1962  if (empty($user->rights->societe->client->voir) && !$socid) {
1963  $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
1964  }
1965  $sql .= " WHERE p.entity IN (".getEntity('supplier_proposal').")";
1966  $sql .= " AND p.fk_soc = s.rowid";
1967  $sql .= " AND p.fk_statut = c.id";
1968  if (empty($user->rights->societe->client->voir) && !$socid) { //restriction
1969  $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
1970  }
1971  if ($socid) {
1972  $sql .= " AND s.rowid = ".((int) $socid);
1973  }
1974  if ($draft) {
1975  $sql .= " AND p.fk_statut = 0";
1976  }
1977  if ($notcurrentuser > 0) {
1978  $sql .= " AND p.fk_user_author <> ".$user->id;
1979  }
1980  $sql .= $this->db->order($sortfield, $sortorder);
1981  $sql .= $this->db->plimit($limit, $offset);
1982 
1983  $result = $this->db->query($sql);
1984  if ($result) {
1985  $num = $this->db->num_rows($result);
1986  if ($num) {
1987  $i = 0;
1988  while ($i < $num) {
1989  $obj = $this->db->fetch_object($result);
1990 
1991  if ($shortlist == 1) {
1992  $ga[$obj->supplier_proposalid] = $obj->ref;
1993  } elseif ($shortlist == 2) {
1994  $ga[$obj->supplier_proposalid] = $obj->ref.' ('.$obj->name.')';
1995  } else {
1996  $ga[$i]['id'] = $obj->supplier_proposalid;
1997  $ga[$i]['ref'] = $obj->ref;
1998  $ga[$i]['name'] = $obj->name;
1999  }
2000 
2001  $i++;
2002  }
2003  }
2004  return $ga;
2005  } else {
2006  dol_print_error($this->db);
2007  return -1;
2008  }
2009  }
2010 
2018  public function delete($user, $notrigger = 0)
2019  {
2020  global $conf, $langs;
2021  require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
2022 
2023  $error = 0;
2024 
2025  $this->db->begin();
2026 
2027  if (!$notrigger) {
2028  // Call trigger
2029  $result = $this->call_trigger('PROPOSAL_SUPPLIER_DELETE', $user);
2030  if ($result < 0) {
2031  $error++;
2032  }
2033  // End call triggers
2034  }
2035 
2036  if (!$error) {
2037  $main = MAIN_DB_PREFIX.'supplier_proposaldet';
2038  $ef = $main."_extrafields";
2039  $sqlef = "DELETE FROM $ef WHERE fk_object IN (SELECT rowid FROM $main WHERE fk_supplier_proposal = ".((int) $this->id).")";
2040  $sql = "DELETE FROM ".MAIN_DB_PREFIX."supplier_proposaldet WHERE fk_supplier_proposal = ".((int) $this->id);
2041  if ($this->db->query($sql)) {
2042  $sql = "DELETE FROM ".MAIN_DB_PREFIX."supplier_proposal WHERE rowid = ".((int) $this->id);
2043  if ($this->db->query($sqlef) && $this->db->query($sql)) {
2044  // Delete linked object
2045  $res = $this->deleteObjectLinked();
2046  if ($res < 0) {
2047  $error++;
2048  }
2049 
2050  if (!$error) {
2051  // Delete record into ECM index (Note that delete is also done when deleting files with the dol_delete_dir_recursive
2052  $this->deleteEcmFiles();
2053 
2054  // We remove directory
2055  $ref = dol_sanitizeFileName($this->ref);
2056  if ($conf->supplier_proposal->dir_output && !empty($this->ref)) {
2057  $dir = $conf->supplier_proposal->dir_output."/".$ref;
2058  $file = $dir."/".$ref.".pdf";
2059  if (file_exists($file)) {
2060  dol_delete_preview($this);
2061 
2062  if (!dol_delete_file($file, 0, 0, 0, $this)) { // For triggers
2063  $this->error = 'ErrorFailToDeleteFile';
2064  $this->errors = array('ErrorFailToDeleteFile');
2065  $this->db->rollback();
2066  return 0;
2067  }
2068  }
2069  if (file_exists($dir)) {
2070  $res = @dol_delete_dir_recursive($dir);
2071  if (!$res) {
2072  $this->error = 'ErrorFailToDeleteDir';
2073  $this->errors = array('ErrorFailToDeleteDir');
2074  $this->db->rollback();
2075  return 0;
2076  }
2077  }
2078  }
2079  }
2080 
2081  // Removed extrafields
2082  if (!$error) {
2083  $result = $this->deleteExtraFields();
2084  if ($result < 0) {
2085  $error++;
2086  $errorflag = -4;
2087  dol_syslog(get_class($this)."::delete erreur ".$errorflag." ".$this->error, LOG_ERR);
2088  }
2089  }
2090 
2091  if (!$error) {
2092  dol_syslog(get_class($this)."::delete ".$this->id." by ".$user->id, LOG_DEBUG);
2093  $this->db->commit();
2094  return 1;
2095  } else {
2096  $this->error = $this->db->lasterror();
2097  $this->db->rollback();
2098  return 0;
2099  }
2100  } else {
2101  $this->error = $this->db->lasterror();
2102  $this->db->rollback();
2103  return -3;
2104  }
2105  } else {
2106  $this->error = $this->db->lasterror();
2107  $this->db->rollback();
2108  return -2;
2109  }
2110  } else {
2111  $this->db->rollback();
2112  return -1;
2113  }
2114  }
2115 
2122  public function info($id)
2123  {
2124  $sql = "SELECT c.rowid, ";
2125  $sql .= " c.datec, c.date_valid as datev, c.date_cloture as dateo,";
2126  $sql .= " c.fk_user_author, c.fk_user_valid, c.fk_user_cloture";
2127  $sql .= " FROM ".MAIN_DB_PREFIX."supplier_proposal as c";
2128  $sql .= " WHERE c.rowid = ".((int) $id);
2129 
2130  $result = $this->db->query($sql);
2131 
2132  if ($result) {
2133  if ($this->db->num_rows($result)) {
2134  $obj = $this->db->fetch_object($result);
2135 
2136  $this->id = $obj->rowid;
2137 
2138  $this->date_creation = $this->db->jdate($obj->datec);
2139  $this->date_validation = $this->db->jdate($obj->datev);
2140  $this->date_cloture = $this->db->jdate($obj->dateo);
2141 
2142  $cuser = new User($this->db);
2143  $cuser->fetch($obj->fk_user_author);
2144  $this->user_creation = $cuser;
2145 
2146  if ($obj->fk_user_valid) {
2147  $vuser = new User($this->db);
2148  $vuser->fetch($obj->fk_user_valid);
2149  $this->user_validation = $vuser;
2150  }
2151 
2152  if ($obj->fk_user_cloture) {
2153  $cluser = new User($this->db);
2154  $cluser->fetch($obj->fk_user_cloture);
2155  $this->user_cloture = $cluser;
2156  }
2157  }
2158  $this->db->free($result);
2159  } else {
2160  dol_print_error($this->db);
2161  }
2162  }
2163 
2164 
2171  public function getLibStatut($mode = 0)
2172  {
2173  return $this->LibStatut((isset($this->statut) ? $this->statut : $this->status), $mode);
2174  }
2175 
2176  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2184  public function LibStatut($status, $mode = 1)
2185  {
2186  // phpcs:enable
2187 
2188  // Init/load array of translation of status
2189  if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
2190  global $langs;
2191  $langs->load("supplier_proposal");
2192  $this->labelStatus[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv("SupplierProposalStatusDraft");
2193  $this->labelStatus[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv("SupplierProposalStatusValidated");
2194  $this->labelStatus[self::STATUS_SIGNED] = $langs->transnoentitiesnoconv("SupplierProposalStatusSigned");
2195  $this->labelStatus[self::STATUS_NOTSIGNED] = $langs->transnoentitiesnoconv("SupplierProposalStatusNotSigned");
2196  $this->labelStatus[self::STATUS_CLOSE] = $langs->transnoentitiesnoconv("SupplierProposalStatusClosed");
2197  $this->labelStatusShort[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv("SupplierProposalStatusDraftShort");
2198  $this->labelStatusShort[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv("SupplierProposalStatusValidatedShort");
2199  $this->labelStatusShort[self::STATUS_SIGNED] = $langs->transnoentitiesnoconv("SupplierProposalStatusSignedShort");
2200  $this->labelStatusShort[self::STATUS_NOTSIGNED] = $langs->transnoentitiesnoconv("SupplierProposalStatusNotSignedShort");
2201  $this->labelStatusShort[self::STATUS_CLOSE] = $langs->transnoentitiesnoconv("SupplierProposalStatusClosedShort");
2202  }
2203 
2204  $statusnew = '';
2205  if ($status == self::STATUS_DRAFT) {
2206  $statusnew = 'status0';
2207  } elseif ($status == self::STATUS_VALIDATED) {
2208  $statusnew = 'status1';
2209  } elseif ($status == self::STATUS_SIGNED) {
2210  $statusnew = 'status4';
2211  } elseif ($status == self::STATUS_NOTSIGNED) {
2212  $statusnew = 'status9';
2213  } elseif ($status == self::STATUS_CLOSE) {
2214  $statusnew = 'status6';
2215  }
2216 
2217  return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status], '', $statusnew, $mode);
2218  }
2219 
2220 
2221  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2229  public function load_board($user, $mode)
2230  {
2231  // phpcs:enable
2232  global $conf, $user, $langs;
2233 
2234  $now = dol_now();
2235 
2236  $this->nbtodo = $this->nbtodolate = 0;
2237  $clause = " WHERE";
2238 
2239  $sql = "SELECT p.rowid, p.ref, p.datec as datec, p.date_cloture as datefin";
2240  $sql .= " FROM ".MAIN_DB_PREFIX."supplier_proposal as p";
2241  if (empty($user->rights->societe->client->voir) && !$user->socid) {
2242  $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON p.fk_soc = sc.fk_soc";
2243  $sql .= " WHERE sc.fk_user = ".((int) $user->id);
2244  $clause = " AND";
2245  }
2246  $sql .= $clause." p.entity IN (".getEntity('supplier_proposal').")";
2247  if ($mode == 'opened') {
2248  $sql .= " AND p.fk_statut = 1";
2249  }
2250  if ($mode == 'signed') {
2251  $sql .= " AND p.fk_statut = 2";
2252  }
2253  if ($user->socid) {
2254  $sql .= " AND p.fk_soc = ".((int) $user->socid);
2255  }
2256 
2257  $resql = $this->db->query($sql);
2258  if ($resql) {
2259  $label = $labelShort = '';
2260  $status = '';
2261  if ($mode == 'opened') {
2262  $delay_warning = !empty($conf->supplier_proposal->cloture->warning_delay) ? $conf->supplier_proposal->cloture->warning_delay : 0;
2263  $status = self::STATUS_VALIDATED;
2264  $label = $langs->trans("SupplierProposalsToClose");
2265  $labelShort = $langs->trans("ToAcceptRefuse");
2266  }
2267  if ($mode == 'signed') {
2268  $delay_warning = !empty($conf->supplier_proposal->facturation->warning_delay) ? $conf->supplier_proposal->facturation->warning_delay : 0;
2269  $status = self::STATUS_SIGNED;
2270  $label = $langs->trans("SupplierProposalsToProcess"); // May be billed or ordered
2271  $labelShort = $langs->trans("ToClose");
2272  }
2273 
2274  $response = new WorkboardResponse();
2275  $response->warning_delay = $delay_warning / 60 / 60 / 24;
2276  $response->label = $label;
2277  $response->labelShort = $labelShort;
2278  $response->url = DOL_URL_ROOT.'/supplier_proposal/list.php?search_status='.$status;
2279  $response->img = img_object('', "propal");
2280 
2281  // This assignment in condition is not a bug. It allows walking the results.
2282  while ($obj = $this->db->fetch_object($resql)) {
2283  $response->nbtodo++;
2284  if ($mode == 'opened') {
2285  $datelimit = $this->db->jdate($obj->datefin);
2286  if ($datelimit < ($now - $delay_warning)) {
2287  $response->nbtodolate++;
2288  }
2289  }
2290  // TODO Definir regle des propales a facturer en retard
2291  // if ($mode == 'signed' && ! count($this->FactureListeArray($obj->rowid))) $this->nbtodolate++;
2292  }
2293  return $response;
2294  } else {
2295  $this->error = $this->db->lasterror();
2296  return -1;
2297  }
2298  }
2299 
2300 
2308  public function initAsSpecimen()
2309  {
2310  global $user, $langs, $conf;
2311 
2312  // Load array of products prodids
2313  $num_prods = 0;
2314  $prodids = array();
2315  $sql = "SELECT rowid";
2316  $sql .= " FROM ".MAIN_DB_PREFIX."product";
2317  $sql .= " WHERE entity IN (".getEntity('product').")";
2318  $sql .= $this->db->plimit(100);
2319 
2320  $resql = $this->db->query($sql);
2321  if ($resql) {
2322  $num_prods = $this->db->num_rows($resql);
2323  $i = 0;
2324  while ($i < $num_prods) {
2325  $i++;
2326  $row = $this->db->fetch_row($resql);
2327  $prodids[$i] = $row[0];
2328  }
2329  }
2330 
2331  // Initialise parametres
2332  $this->id = 0;
2333  $this->ref = 'SPECIMEN';
2334  $this->specimen = 1;
2335  $this->socid = 1;
2336  $this->date = time();
2337  $this->cond_reglement_id = 1;
2338  $this->cond_reglement_code = 'RECEP';
2339  $this->mode_reglement_id = 7;
2340  $this->mode_reglement_code = 'CHQ';
2341  $this->note_public = 'This is a comment (public)';
2342  $this->note_private = 'This is a comment (private)';
2343  // Lines
2344  $nbp = 5;
2345  $xnbp = 0;
2346  while ($xnbp < $nbp) {
2347  $line = new SupplierProposalLine($this->db);
2348  $line->desc = $langs->trans("Description")." ".$xnbp;
2349  $line->qty = 1;
2350  $line->subprice = 100;
2351  $line->tva_tx = 19.6;
2352  $line->localtax1_tx = 0;
2353  $line->localtax2_tx = 0;
2354  if ($xnbp == 2) {
2355  $line->total_ht = 50;
2356  $line->total_ttc = 59.8;
2357  $line->total_tva = 9.8;
2358  $line->remise_percent = 50;
2359  } else {
2360  $line->total_ht = 100;
2361  $line->total_ttc = 119.6;
2362  $line->total_tva = 19.6;
2363  $line->remise_percent = 00;
2364  }
2365 
2366  if ($num_prods > 0) {
2367  $prodid = mt_rand(1, $num_prods);
2368  $line->fk_product = $prodids[$prodid];
2369  }
2370 
2371  $this->lines[$xnbp] = $line;
2372 
2373  $this->total_ht += $line->total_ht;
2374  $this->total_tva += $line->total_tva;
2375  $this->total_ttc += $line->total_ttc;
2376 
2377  $xnbp++;
2378  }
2379  }
2380 
2381  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2387  public function load_state_board()
2388  {
2389  // phpcs:enable
2390  global $conf, $user;
2391 
2392  $this->nb = array();
2393  $clause = "WHERE";
2394 
2395  $sql = "SELECT count(p.rowid) as nb";
2396  $sql .= " FROM ".MAIN_DB_PREFIX."supplier_proposal as p";
2397  $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s ON p.fk_soc = s.rowid";
2398  if (empty($user->rights->societe->client->voir) && !$user->socid) {
2399  $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON s.rowid = sc.fk_soc";
2400  $sql .= " WHERE sc.fk_user = ".((int) $user->id);
2401  $clause = "AND";
2402  }
2403  $sql .= " ".$clause." p.entity IN (".getEntity('supplier_proposal').")";
2404 
2405  $resql = $this->db->query($sql);
2406  if ($resql) {
2407  // This assignment in condition is not a bug. It allows walking the results.
2408  while ($obj = $this->db->fetch_object($resql)) {
2409  $this->nb["supplier_proposals"] = $obj->nb;
2410  }
2411  $this->db->free($resql);
2412  return 1;
2413  } else {
2414  dol_print_error($this->db);
2415  $this->error = $this->db->lasterror();
2416  return -1;
2417  }
2418  }
2419 
2420 
2428  public function getNextNumRef($soc)
2429  {
2430  global $conf, $db, $langs;
2431  $langs->load("supplier_proposal");
2432 
2433  if (!empty($conf->global->SUPPLIER_PROPOSAL_ADDON)) {
2434  $mybool = false;
2435 
2436  $file = $conf->global->SUPPLIER_PROPOSAL_ADDON.".php";
2437  $classname = $conf->global->SUPPLIER_PROPOSAL_ADDON;
2438 
2439  // Include file with class
2440  $dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
2441  foreach ($dirmodels as $reldir) {
2442  $dir = dol_buildpath($reldir."core/modules/supplier_proposal/");
2443 
2444  // Load file with numbering class (if found)
2445  $mybool |= @include_once $dir.$file;
2446  }
2447 
2448  if (!$mybool) {
2449  dol_print_error('', "Failed to include file ".$file);
2450  return '';
2451  }
2452 
2453  $obj = new $classname();
2454  $numref = "";
2455  $numref = $obj->getNextValue($soc, $this);
2456 
2457  if ($numref != "") {
2458  return $numref;
2459  } else {
2460  $this->error = $obj->error;
2461  return "";
2462  }
2463  } else {
2464  $langs->load("errors");
2465  print $langs->trans("Error")." ".$langs->trans("ErrorModuleSetupNotComplete", $langs->transnoentitiesnoconv("SupplierProposal"));
2466  return "";
2467  }
2468  }
2469 
2477  public function getTooltipContentArray($params)
2478  {
2479  global $conf, $langs, $menumanager;
2480 
2481  $langs->load('supplier_proposal');
2482 
2483  if (!empty($conf->global->MAIN_OPTIMIZEFORTEXTBROWSER)) {
2484  return ['optimize' => $langs->trans("ShowSupplierProposal")];
2485  }
2486 
2487  $option = $params['option'] ?? '';
2488  $datas = [];
2489 
2490  $datas['picto'] = img_picto('', $this->picto).' <u class="paddingrightonly">'.$langs->trans("SupplierProposal").'</u>';
2491  if (isset($this->status)) {
2492  $datas['picto'] .= ' '.$this->getLibStatut(5);
2493  }
2494  if (!empty($this->ref)) {
2495  $datas['ref'] = '<br><b>'.$langs->trans('Ref').':</b> '.$this->ref;
2496  }
2497  if (!empty($this->ref_fourn)) {
2498  $datas['ref_supplier'] = '<br><b>'.$langs->trans('RefSupplier').':</b> '.$this->ref_fourn;
2499  }
2500  if (!empty($this->total_ht)) {
2501  $datas['amount_ht'] = '<br><b>'.$langs->trans('AmountHT').':</b> '.price($this->total_ht, 0, $langs, 0, -1, -1, $conf->currency);
2502  }
2503  if (!empty($this->total_tva)) {
2504  $datas['amount_vat'] = '<br><b>'.$langs->trans('VAT').':</b> '.price($this->total_tva, 0, $langs, 0, -1, -1, $conf->currency);
2505  }
2506  if (!empty($this->total_ttc)) {
2507  $datas['amount_ttc'] = '<br><b>'.$langs->trans('AmountTTC').':</b> '.price($this->total_ttc, 0, $langs, 0, -1, -1, $conf->currency);
2508  }
2509 
2510  return $datas;
2511  }
2512 
2524  public function getNomUrl($withpicto = 0, $option = '', $get_params = '', $notooltip = 0, $save_lastsearch_value = -1, $addlinktonotes = 0)
2525  {
2526  global $langs, $conf, $user, $hookmanager;
2527 
2528  if (!empty($conf->dol_no_mouse_hover)) {
2529  $notooltip = 1; // Force disable tooltips
2530  }
2531 
2532  $url = '';
2533  $result = '';
2534  $params = [
2535  'id' => $this->id,
2536  'objecttype' => $this->element,
2537  'option' => $option,
2538  ];
2539  $classfortooltip = 'classfortooltip';
2540  $dataparams = '';
2541  if (getDolGlobalInt('MAIN_ENABLE_AJAX_TOOLTIP')) {
2542  $classfortooltip = 'classforajaxtooltip';
2543  $dataparams = ' data-params="'.dol_escape_htmltag(json_encode($params)).'"';
2544  $label = '';
2545  } else {
2546  $label = implode($this->getTooltipContentArray($params));
2547  }
2548 
2549  if ($option == '') {
2550  $url = DOL_URL_ROOT.'/supplier_proposal/card.php?id='.$this->id.$get_params;
2551  }
2552  if ($option == 'document') {
2553  $url = DOL_URL_ROOT.'/supplier_proposal/document.php?id='.$this->id.$get_params;
2554  }
2555 
2556  if ($option !== 'nolink') {
2557  // Add param to save lastsearch_values or not
2558  $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
2559  if ($save_lastsearch_value == -1 && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
2560  $add_save_lastsearch_values = 1;
2561  }
2562  if ($add_save_lastsearch_values) {
2563  $url .= '&save_lastsearch_values=1';
2564  }
2565  }
2566 
2567  $linkclose = '';
2568  if (empty($notooltip) && $user->hasRight('propal', 'lire')) {
2569  if (!empty($conf->global->MAIN_OPTIMIZEFORTEXTBROWSER)) {
2570  $label = $langs->trans("ShowSupplierProposal");
2571  $linkclose .= ' alt="'.dol_escape_htmltag($label, 1).'"';
2572  }
2573  $linkclose .= ($label ? ' title="'.dol_escape_htmltag($label, 1).'"' : ' title="tocomplete"');
2574  $linkclose .= $dataparams.' class="'.$classfortooltip.'"';
2575  }
2576 
2577  $linkstart = '<a href="'.$url.'"';
2578  $linkstart .= $linkclose.'>';
2579  $linkend = '</a>';
2580 
2581  $result .= $linkstart;
2582  if ($withpicto) {
2583  $result .= img_object(($notooltip ? '' : $label), $this->picto, ($notooltip ? (($withpicto != 2) ? 'class="paddingright"' : '') : $dataparams.' class="'.(($withpicto != 2) ? 'paddingright ' : '').$classfortooltip.'"'), 0, 0, $notooltip ? 0 : 1);
2584  }
2585  if ($withpicto != 2) {
2586  $result .= $this->ref;
2587  }
2588  $result .= $linkend;
2589 
2590  if ($addlinktonotes) {
2591  $txttoshow = ($user->socid > 0 ? $this->note_public : $this->note_private);
2592  if ($txttoshow) {
2593  $notetoshow = $langs->trans("ViewPrivateNote").':<br>'.dol_string_nohtmltag($txttoshow, 1);
2594  $result .= ' <span class="note inline-block">';
2595  $result .= '<a href="'.DOL_URL_ROOT.'/supplier_proposal/note.php?id='.$this->id.'" class="classfortooltip" title="'.dol_escape_htmltag($notetoshow).'">';
2596  $result .= img_picto('', 'note');
2597  $result .= '</a>';
2598  //$result.=img_picto($langs->trans("ViewNote"),'object_generic');
2599  //$result.='</a>';
2600  $result .= '</span>';
2601  }
2602  }
2603  global $action;
2604  $hookmanager->initHooks(array($this->element . 'dao'));
2605  $parameters = array('id'=>$this->id, 'getnomurl' => &$result);
2606  $reshook = $hookmanager->executeHooks('getNomUrl', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
2607  if ($reshook > 0) {
2608  $result = $hookmanager->resPrint;
2609  } else {
2610  $result .= $hookmanager->resPrint;
2611  }
2612  return $result;
2613  }
2614 
2620  public function getLinesArray()
2621  {
2622  // For other object, here we call fetch_lines. But fetch_lines does not exists on supplier proposal
2623 
2624  $sql = 'SELECT pt.rowid, pt.label as custom_label, pt.description, pt.fk_product, pt.fk_remise_except,';
2625  $sql .= ' pt.qty, pt.tva_tx, pt.vat_src_code, pt.remise_percent, pt.subprice, pt.info_bits,';
2626  $sql .= ' pt.total_ht, pt.total_tva, pt.total_ttc, pt.fk_product_fournisseur_price as fk_fournprice, pt.buy_price_ht as pa_ht, pt.special_code, pt.localtax1_tx, pt.localtax2_tx,';
2627  $sql .= ' pt.product_type, pt.rang, pt.fk_parent_line,';
2628  $sql .= ' p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid,';
2629  $sql .= ' p.description as product_desc, pt.ref_fourn as ref_supplier,';
2630  $sql .= ' pt.fk_multicurrency, pt.multicurrency_code, pt.multicurrency_subprice, pt.multicurrency_total_ht, pt.multicurrency_total_tva, pt.multicurrency_total_ttc, pt.fk_unit';
2631  $sql .= ' FROM '.MAIN_DB_PREFIX.'supplier_proposaldet as pt';
2632  $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product as p ON pt.fk_product=p.rowid';
2633  $sql .= ' WHERE pt.fk_supplier_proposal = '.((int) $this->id);
2634  $sql .= ' ORDER BY pt.rang ASC, pt.rowid';
2635 
2636  dol_syslog(get_class($this).'::getLinesArray', LOG_DEBUG);
2637  $resql = $this->db->query($sql);
2638  if ($resql) {
2639  $num = $this->db->num_rows($resql);
2640  $i = 0;
2641 
2642  while ($i < $num) {
2643  $obj = $this->db->fetch_object($resql);
2644 
2645  $this->lines[$i] = new SupplierProposalLine($this->db);
2646  $this->lines[$i]->id = $obj->rowid; // for backward compatibility
2647  $this->lines[$i]->rowid = $obj->rowid;
2648  $this->lines[$i]->label = $obj->custom_label;
2649  $this->lines[$i]->description = $obj->description;
2650  $this->lines[$i]->fk_product = $obj->fk_product;
2651  $this->lines[$i]->ref = $obj->ref;
2652  $this->lines[$i]->product_label = $obj->product_label;
2653  $this->lines[$i]->product_desc = $obj->product_desc;
2654  $this->lines[$i]->fk_product_type = $obj->fk_product_type; // deprecated
2655  $this->lines[$i]->product_type = $obj->product_type;
2656  $this->lines[$i]->qty = $obj->qty;
2657  $this->lines[$i]->subprice = $obj->subprice;
2658  $this->lines[$i]->fk_remise_except = $obj->fk_remise_except;
2659  $this->lines[$i]->remise_percent = $obj->remise_percent;
2660  $this->lines[$i]->tva_tx = $obj->tva_tx;
2661  $this->lines[$i]->vat_src_code = $obj->vat_src_code;
2662  $this->lines[$i]->info_bits = $obj->info_bits;
2663  $this->lines[$i]->total_ht = $obj->total_ht;
2664  $this->lines[$i]->total_tva = $obj->total_tva;
2665  $this->lines[$i]->total_ttc = $obj->total_ttc;
2666  $this->lines[$i]->fk_fournprice = $obj->fk_fournprice;
2667  $marginInfos = getMarginInfos($obj->subprice, $obj->remise_percent, $obj->tva_tx, $obj->localtax1_tx, $obj->localtax2_tx, $this->lines[$i]->fk_fournprice, $obj->pa_ht);
2668  $this->lines[$i]->pa_ht = $marginInfos[0];
2669  $this->lines[$i]->marge_tx = $marginInfos[1];
2670  $this->lines[$i]->marque_tx = $marginInfos[2];
2671  $this->lines[$i]->fk_parent_line = $obj->fk_parent_line;
2672  $this->lines[$i]->special_code = $obj->special_code;
2673  $this->lines[$i]->rang = $obj->rang;
2674 
2675  $this->lines[$i]->ref_fourn = $obj->ref_supplier; // deprecated
2676  $this->lines[$i]->ref_supplier = $obj->ref_supplier;
2677 
2678  // Multicurrency
2679  $this->lines[$i]->fk_multicurrency = $obj->fk_multicurrency;
2680  $this->lines[$i]->multicurrency_code = $obj->multicurrency_code;
2681  $this->lines[$i]->multicurrency_subprice = $obj->multicurrency_subprice;
2682  $this->lines[$i]->multicurrency_total_ht = $obj->multicurrency_total_ht;
2683  $this->lines[$i]->multicurrency_total_tva = $obj->multicurrency_total_tva;
2684  $this->lines[$i]->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
2685  $this->lines[$i]->fk_unit = $obj->fk_unit;
2686 
2687  $i++;
2688  }
2689  $this->db->free($resql);
2690 
2691  return 1;
2692  } else {
2693  $this->error = $this->db->error();
2694  return -1;
2695  }
2696  }
2697 
2709  public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams = null)
2710  {
2711  global $conf, $langs;
2712 
2713  $langs->load("supplier_proposal");
2714  $outputlangs->load("products");
2715 
2716  if (!dol_strlen($modele)) {
2717  $modele = 'aurore';
2718 
2719  if ($this->model_pdf) {
2720  $modele = $this->model_pdf;
2721  } elseif (!empty($conf->global->SUPPLIER_PROPOSAL_ADDON_PDF)) {
2722  $modele = $conf->global->SUPPLIER_PROPOSAL_ADDON_PDF;
2723  }
2724  }
2725 
2726  $modelpath = "core/modules/supplier_proposal/doc/";
2727 
2728  return $this->commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
2729  }
2730 
2731 
2740  public static function replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
2741  {
2742  $tables = array(
2743  'supplier_proposal'
2744  );
2745 
2746  return CommonObject::commonReplaceThirdparty($dbs, $origin_id, $dest_id, $tables);
2747  }
2748 
2757  public static function replaceProduct(DoliDB $db, $origin_id, $dest_id)
2758  {
2759  $tables = array(
2760  'supplier_proposaldet'
2761  );
2762 
2763  return CommonObject::commonReplaceProduct($db, $origin_id, $dest_id, $tables);
2764  }
2765 
2766 
2774  public function getKanbanView($option = '', $arraydata = null)
2775  {
2776  global $langs;
2777 
2778  $selected = (empty($arraydata['selected']) ? 0 : $arraydata['selected']);
2779 
2780  $return = '<div class="box-flex-item box-flex-grow-zero">';
2781  $return .= '<div class="info-box info-box-sm">';
2782  $return .= '<span class="info-box-icon bg-infobox-action">';
2783  $return .= img_picto('', $this->picto);
2784  //$return .= '<i class="fa fa-dol-action"></i>'; // Can be image
2785  $return .= '</span>';
2786  $return .= '<div class="info-box-content">';
2787  $return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this, 'getNomUrl') ? $this->getNomUrl() : $this->ref).'</span>';
2788  $return .= '<input id="cb'.$this->id.'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->id.'"'.($selected ? ' checked="checked"' : '').'>';
2789  if (property_exists($this, 'socid')) {
2790  $return .= '<span class="info-box-ref"> | '.$this->socid.'</span>';
2791  }
2792  if (property_exists($this, 'delivery_date')) {
2793  $return .= '<br><span class="opacitymedium">'.$langs->trans("DateEnd").'</span> : <span class="info-box-label">'.dol_print_date($this->delivery_date).'</span>';
2794  }
2795  if (property_exists($this, 'total_ttc')) {
2796  $return .='<br><span class="opacitymedium" >'.$langs->trans("AmountHT").' : </span><span class="info-box-label amount">'.price($this->total_ttc).'</span>';
2797  }
2798  if (method_exists($this, 'getLibStatut')) {
2799  $return .= '<br><div class="info-box-status margintoponly">'.$this->getLibStatut(3).'</div>';
2800  }
2801  $return .= '</div>';
2802  $return .= '</div>';
2803  $return .= '</div>';
2804  return $return;
2805  }
2806 }
2807 
2808 
2813 {
2817  public $db;
2818 
2822  public $error = '';
2823 
2827  public $element = 'supplier_proposaldet';
2828 
2832  public $table_element = 'supplier_proposaldet';
2833 
2834  public $oldline;
2835 
2839  public $id;
2840 
2844  public $fk_supplier_proposal;
2845 
2849  public $fk_parent_line;
2850 
2851  public $desc; // Description ligne
2852 
2856  public $fk_product; // Id produit predefini
2857 
2868  public $product_type = Product::TYPE_PRODUCT;
2869 
2870  public $qty;
2871  public $tva_tx;
2872  public $vat_src_code;
2873 
2874  public $subprice;
2875  public $remise_percent;
2876 
2880  public $fk_remise_except;
2881 
2882  public $rang = 0;
2883 
2887  public $fk_fournprice;
2888 
2889  public $pa_ht;
2890  public $marge_tx;
2891  public $marque_tx;
2892 
2893  public $special_code; // Tag for special lines (exlusive tags)
2894  // 1: frais de port
2895  // 2: ecotaxe
2896  // 3: option line (when qty = 0)
2897 
2898  public $info_bits = 0; // Liste d'options cumulables:
2899  // Bit 0: 0 si TVA normal - 1 si TVA NPR
2900  // Bit 1: 0 ligne normale - 1 si ligne de remise fixe
2901 
2902  public $total_ht; // Total HT de la ligne toute quantite et incluant la remise ligne
2903  public $total_tva; // Total TVA de la ligne toute quantite et incluant la remise ligne
2904  public $total_ttc; // Total TTC de la ligne toute quantite et incluant la remise ligne
2905 
2906  public $date_start;
2907  public $date_end;
2908 
2909  // From llx_product
2914  public $ref;
2915 
2920  public $product_ref;
2921 
2926  public $libelle;
2927 
2932  public $product_label;
2933 
2938  public $product_desc;
2939 
2940  public $localtax1_tx; // Local tax 1
2941  public $localtax2_tx; // Local tax 2
2942  public $localtax1_type; // Local tax 1 type
2943  public $localtax2_type; // Local tax 2 type
2944  public $total_localtax1; // Line total local tax 1
2945  public $total_localtax2; // Line total local tax 2
2946 
2947  public $skip_update_total; // Skip update price total for special lines
2948 
2949  public $ref_fourn;
2950  public $ref_supplier;
2951 
2952  // Multicurrency
2956  public $fk_multicurrency;
2957 
2958  public $multicurrency_code;
2959  public $multicurrency_subprice;
2960  public $multicurrency_total_ht;
2961  public $multicurrency_total_tva;
2962  public $multicurrency_total_ttc;
2963 
2969  public function __construct($db)
2970  {
2971  $this->db = $db;
2972  }
2973 
2980  public function fetch($rowid)
2981  {
2982  $sql = 'SELECT pd.rowid, pd.fk_supplier_proposal, pd.fk_parent_line, pd.fk_product, pd.label as custom_label, pd.description, pd.price, pd.qty, pd.tva_tx,';
2983  $sql .= ' pd.date_start, pd.date_end,';
2984  $sql .= ' pd.remise, pd.remise_percent, pd.fk_remise_except, pd.subprice,';
2985  $sql .= ' pd.info_bits, pd.total_ht, pd.total_tva, pd.total_ttc, pd.fk_product_fournisseur_price as fk_fournprice, pd.buy_price_ht as pa_ht, pd.special_code, pd.rang,';
2986  $sql .= ' pd.localtax1_tx, pd.localtax2_tx, pd.total_localtax1, pd.total_localtax2,';
2987  $sql .= ' p.ref as product_ref, p.label as product_label, p.description as product_desc,';
2988  $sql .= ' pd.product_type, pd.ref_fourn as ref_produit_fourn,';
2989  $sql .= ' pd.fk_multicurrency, pd.multicurrency_code, pd.multicurrency_subprice, pd.multicurrency_total_ht, pd.multicurrency_total_tva, pd.multicurrency_total_ttc, pd.fk_unit';
2990  $sql .= ' FROM '.MAIN_DB_PREFIX.'supplier_proposaldet as pd';
2991  $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product as p ON pd.fk_product = p.rowid';
2992  $sql .= ' WHERE pd.rowid = '.((int) $rowid);
2993 
2994  $result = $this->db->query($sql);
2995  if ($result) {
2996  $objp = $this->db->fetch_object($result);
2997 
2998  $this->id = $objp->rowid;
2999  $this->fk_supplier_proposal = $objp->fk_supplier_proposal;
3000  $this->fk_parent_line = $objp->fk_parent_line;
3001  $this->label = $objp->custom_label;
3002  $this->desc = $objp->description;
3003  $this->qty = $objp->qty;
3004  $this->subprice = $objp->subprice;
3005  $this->tva_tx = $objp->tva_tx;
3006  $this->remise_percent = $objp->remise_percent;
3007  $this->fk_remise_except = $objp->fk_remise_except;
3008  $this->fk_product = $objp->fk_product;
3009  $this->info_bits = $objp->info_bits;
3010  $this->date_start = $this->db->jdate($objp->date_start);
3011  $this->date_end = $this->db->jdate($objp->date_end);
3012 
3013  $this->total_ht = $objp->total_ht;
3014  $this->total_tva = $objp->total_tva;
3015  $this->total_ttc = $objp->total_ttc;
3016 
3017  $this->fk_fournprice = $objp->fk_fournprice;
3018 
3019  $marginInfos = getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $this->fk_fournprice, $objp->pa_ht);
3020  $this->pa_ht = $marginInfos[0];
3021  $this->marge_tx = $marginInfos[1];
3022  $this->marque_tx = $marginInfos[2];
3023 
3024  $this->special_code = $objp->special_code;
3025  $this->product_type = $objp->product_type;
3026  $this->rang = $objp->rang;
3027 
3028  $this->ref = $objp->product_ref; // deprecated
3029  $this->product_ref = $objp->product_ref;
3030  $this->libelle = $objp->product_label; // deprecated
3031  $this->product_label = $objp->product_label;
3032  $this->product_desc = $objp->product_desc;
3033 
3034  $this->ref_fourn = $objp->ref_produit_fourn;
3035 
3036  // Multicurrency
3037  $this->fk_multicurrency = $objp->fk_multicurrency;
3038  $this->multicurrency_code = $objp->multicurrency_code;
3039  $this->multicurrency_subprice = $objp->multicurrency_subprice;
3040  $this->multicurrency_total_ht = $objp->multicurrency_total_ht;
3041  $this->multicurrency_total_tva = $objp->multicurrency_total_tva;
3042  $this->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
3043  $this->fk_unit = $objp->fk_unit;
3044 
3045  $this->db->free($result);
3046  return 1;
3047  } else {
3048  dol_print_error($this->db);
3049  return -1;
3050  }
3051  }
3052 
3059  public function insert($notrigger = 0)
3060  {
3061  global $conf, $langs, $user;
3062 
3063  $error = 0;
3064 
3065  dol_syslog(get_class($this)."::insert rang=".$this->rang);
3066 
3067  // Clean parameters
3068  if (empty($this->tva_tx)) {
3069  $this->tva_tx = 0;
3070  }
3071  if (empty($this->vat_src_code)) {
3072  $this->vat_src_code = '';
3073  }
3074  if (empty($this->localtax1_tx)) {
3075  $this->localtax1_tx = 0;
3076  }
3077  if (empty($this->localtax2_tx)) {
3078  $this->localtax2_tx = 0;
3079  }
3080  if (empty($this->localtax1_type)) {
3081  $this->localtax1_type = 0;
3082  }
3083  if (empty($this->localtax2_type)) {
3084  $this->localtax2_type = 0;
3085  }
3086  if (empty($this->total_localtax1)) {
3087  $this->total_localtax1 = 0;
3088  }
3089  if (empty($this->total_localtax2)) {
3090  $this->total_localtax2 = 0;
3091  }
3092  if (empty($this->rang)) {
3093  $this->rang = 0;
3094  }
3095  if (empty($this->remise_percent)) {
3096  $this->remise_percent = 0;
3097  }
3098  if (empty($this->info_bits)) {
3099  $this->info_bits = 0;
3100  }
3101  if (empty($this->special_code)) {
3102  $this->special_code = 0;
3103  }
3104  if (empty($this->fk_parent_line)) {
3105  $this->fk_parent_line = 0;
3106  }
3107  if (empty($this->fk_fournprice)) {
3108  $this->fk_fournprice = 0;
3109  }
3110  if (empty($this->fk_unit)) {
3111  $this->fk_unit = 0;
3112  }
3113  if (empty($this->subprice)) {
3114  $this->subprice = 0;
3115  }
3116 
3117  if (empty($this->pa_ht)) {
3118  $this->pa_ht = 0;
3119  }
3120 
3121  // if buy price not defined, define buyprice as configured in margin admin
3122  if ($this->pa_ht == 0) {
3123  $result = $this->defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
3124  if ($result < 0) {
3125  return $result;
3126  } else {
3127  $this->pa_ht = $result;
3128  }
3129  }
3130 
3131  // Check parameters
3132  if ($this->product_type < 0) {
3133  return -1;
3134  }
3135 
3136  $this->db->begin();
3137 
3138  // Insert line into database
3139  $sql = 'INSERT INTO '.MAIN_DB_PREFIX.'supplier_proposaldet';
3140  $sql .= ' (fk_supplier_proposal, fk_parent_line, label, description, fk_product, product_type,';
3141  $sql .= ' date_start, date_end,';
3142  $sql .= ' fk_remise_except, qty, tva_tx, vat_src_code, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type,';
3143  $sql .= ' subprice, remise_percent, ';
3144  $sql .= ' info_bits, ';
3145  $sql .= ' total_ht, total_tva, total_localtax1, total_localtax2, total_ttc, fk_product_fournisseur_price, buy_price_ht, special_code, rang,';
3146  $sql .= ' ref_fourn,';
3147  $sql .= ' fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc, fk_unit)';
3148  $sql .= " VALUES (".$this->fk_supplier_proposal.",";
3149  $sql .= " ".($this->fk_parent_line > 0 ? ((int) $this->fk_parent_line) : "null").",";
3150  $sql .= " ".(!empty($this->label) ? "'".$this->db->escape($this->label)."'" : "null").",";
3151  $sql .= " '".$this->db->escape($this->desc)."',";
3152  $sql .= " ".($this->fk_product ? ((int) $this->fk_product) : "null").",";
3153  $sql .= " '".$this->db->escape($this->product_type)."',";
3154  $sql .= " ".($this->date_start ? "'".$this->db->idate($this->date_start)."'" : "null").",";
3155  $sql .= " ".($this->date_end ? "'".$this->db->idate($this->date_end)."'" : "null").",";
3156  $sql .= " ".($this->fk_remise_except ? ((int) $this->fk_remise_except) : "null").",";
3157  $sql .= " ".price2num($this->qty, 'MS').",";
3158  $sql .= " ".price2num($this->tva_tx).",";
3159  $sql .= " '".$this->db->escape($this->vat_src_code)."',";
3160  $sql .= " ".price2num($this->localtax1_tx).",";
3161  $sql .= " ".price2num($this->localtax2_tx).",";
3162  $sql .= " '".$this->db->escape($this->localtax1_type)."',";
3163  $sql .= " '".$this->db->escape($this->localtax2_type)."',";
3164  $sql .= " ".price2num($this->subprice, 'MU') .",";
3165  $sql .= " ".((float) $this->remise_percent).",";
3166  $sql .= " ".(isset($this->info_bits) ? ((int) $this->info_bits) : "null").",";
3167  $sql .= " ".price2num($this->total_ht, 'MT').",";
3168  $sql .= " ".price2num($this->total_tva, 'MT').",";
3169  $sql .= " ".price2num($this->total_localtax1, 'MT').",";
3170  $sql .= " ".price2num($this->total_localtax2, 'MT').",";
3171  $sql .= " ".price2num($this->total_ttc, 'MT').",";
3172  $sql .= " ".(!empty($this->fk_fournprice) ? ((int) $this->fk_fournprice) : "null").",";
3173  $sql .= " ".(isset($this->pa_ht) ? price2num($this->pa_ht, 'MU') : "null").",";
3174  $sql .= ' '.((int) $this->special_code).',';
3175  $sql .= ' '.((int) $this->rang).',';
3176  $sql .= " '".$this->db->escape($this->ref_fourn)."'";
3177  $sql .= ", ".($this->fk_multicurrency > 0 ? ((int) $this->fk_multicurrency) : 'null');
3178  $sql .= ", '".$this->db->escape($this->multicurrency_code)."'";
3179  $sql .= ", ".price2num($this->multicurrency_subprice, 'CU');
3180  $sql .= ", ".price2num($this->multicurrency_total_ht, 'CT');
3181  $sql .= ", ".price2num($this->multicurrency_total_tva, 'CT');
3182  $sql .= ", ".price2num($this->multicurrency_total_ttc, 'CT');
3183  $sql .= ", ".($this->fk_unit ? ((int) $this->fk_unit) : 'null');
3184  $sql .= ')';
3185 
3186  dol_syslog(get_class($this).'::insert', LOG_DEBUG);
3187  $resql = $this->db->query($sql);
3188  if ($resql) {
3189  $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX.'supplier_proposaldet');
3190 
3191  if (!$error) {
3192  $result = $this->insertExtraFields();
3193  if ($result < 0) {
3194  $error++;
3195  }
3196  }
3197 
3198  if (!$error && !$notrigger) {
3199  // Call trigger
3200  $result = $this->call_trigger('LINESUPPLIER_PROPOSAL_INSERT', $user);
3201  if ($result < 0) {
3202  $this->db->rollback();
3203  return -1;
3204  }
3205  // End call triggers
3206  }
3207 
3208  $this->db->commit();
3209  return 1;
3210  } else {
3211  $this->error = $this->db->error()." sql=".$sql;
3212  $this->db->rollback();
3213  return -1;
3214  }
3215  }
3216 
3222  public function delete()
3223  {
3224  global $conf, $langs, $user;
3225 
3226  $error = 0;
3227  $this->db->begin();
3228 
3229  $sql = "DELETE FROM ".MAIN_DB_PREFIX."supplier_proposaldet WHERE rowid = ".((int) $this->id);
3230  dol_syslog("SupplierProposalLine::delete", LOG_DEBUG);
3231  if ($this->db->query($sql)) {
3232  // Remove extrafields
3233  if (!$error) {
3234  $result = $this->deleteExtraFields();
3235  if ($result < 0) {
3236  $error++;
3237  dol_syslog(get_class($this)."::delete error -4 ".$this->error, LOG_ERR);
3238  }
3239  }
3240 
3241  // Call trigger
3242  $result = $this->call_trigger('LINESUPPLIER_PROPOSAL_DELETE', $user);
3243  if ($result < 0) {
3244  $this->db->rollback();
3245  return -1;
3246  }
3247  // End call triggers
3248 
3249  $this->db->commit();
3250 
3251  return 1;
3252  } else {
3253  $this->error = $this->db->error()." sql=".$sql;
3254  $this->db->rollback();
3255  return -1;
3256  }
3257  }
3258 
3265  public function update($notrigger = 0)
3266  {
3267  global $conf, $langs, $user;
3268 
3269  $error = 0;
3270 
3271  // Clean parameters
3272  if (empty($this->tva_tx)) {
3273  $this->tva_tx = 0;
3274  }
3275  if (empty($this->localtax1_tx)) {
3276  $this->localtax1_tx = 0;
3277  }
3278  if (empty($this->localtax2_tx)) {
3279  $this->localtax2_tx = 0;
3280  }
3281  if (empty($this->total_localtax1)) {
3282  $this->total_localtax1 = 0;
3283  }
3284  if (empty($this->total_localtax2)) {
3285  $this->total_localtax2 = 0;
3286  }
3287  if (empty($this->localtax1_type)) {
3288  $this->localtax1_type = 0;
3289  }
3290  if (empty($this->localtax2_type)) {
3291  $this->localtax2_type = 0;
3292  }
3293  if (empty($this->marque_tx)) {
3294  $this->marque_tx = 0;
3295  }
3296  if (empty($this->marge_tx)) {
3297  $this->marge_tx = 0;
3298  }
3299  if (empty($this->remise_percent)) {
3300  $this->remise_percent = 0;
3301  }
3302  if (empty($this->info_bits)) {
3303  $this->info_bits = 0;
3304  }
3305  if (empty($this->special_code)) {
3306  $this->special_code = 0;
3307  }
3308  if (empty($this->fk_parent_line)) {
3309  $this->fk_parent_line = 0;
3310  }
3311  if (empty($this->fk_fournprice)) {
3312  $this->fk_fournprice = 0;
3313  }
3314  if (empty($this->fk_unit)) {
3315  $this->fk_unit = 0;
3316  }
3317  if (empty($this->subprice)) {
3318  $this->subprice = 0;
3319  }
3320 
3321  if (empty($this->pa_ht)) {
3322  $this->pa_ht = 0;
3323  }
3324 
3325  // if buy price not defined, define buyprice as configured in margin admin
3326  if ($this->pa_ht == 0) {
3327  $result = $this->defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
3328  if ($result < 0) {
3329  return $result;
3330  } else {
3331  $this->pa_ht = $result;
3332  }
3333  }
3334 
3335  $this->db->begin();
3336 
3337  // Mise a jour ligne en base
3338  $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposaldet SET";
3339  $sql .= " description='".$this->db->escape($this->desc)."'";
3340  $sql .= " , label=".(!empty($this->label) ? "'".$this->db->escape($this->label)."'" : "null");
3341  $sql .= " , product_type=".((int) $this->product_type);
3342  $sql .= " , date_start=".($this->date_start ? "'".$this->db->idate($this->date_start)."'" : "null");
3343  $sql .= " , date_end=".($this->date_end ? "'".$this->db->idate($this->date_end)."'" : "null");
3344  $sql .= " , tva_tx='".price2num($this->tva_tx)."'";
3345  $sql .= " , localtax1_tx=".price2num($this->localtax1_tx);
3346  $sql .= " , localtax2_tx=".price2num($this->localtax2_tx);
3347  $sql .= " , localtax1_type='".$this->db->escape($this->localtax1_type)."'";
3348  $sql .= " , localtax2_type='".$this->db->escape($this->localtax2_type)."'";
3349  $sql .= " , qty='".price2num($this->qty)."'";
3350  $sql .= " , subprice=".price2num($this->subprice);
3351  $sql .= " , remise_percent=".price2num($this->remise_percent);
3352  $sql .= " , info_bits='".$this->db->escape($this->info_bits)."'";
3353  if (empty($this->skip_update_total)) {
3354  $sql .= " , total_ht=".price2num($this->total_ht);
3355  $sql .= " , total_tva=".price2num($this->total_tva);
3356  $sql .= " , total_ttc=".price2num($this->total_ttc);
3357  $sql .= " , total_localtax1=".price2num($this->total_localtax1);
3358  $sql .= " , total_localtax2=".price2num($this->total_localtax2);
3359  }
3360  $sql .= " , fk_product_fournisseur_price=".(!empty($this->fk_fournprice) ? "'".$this->db->escape($this->fk_fournprice)."'" : "null");
3361  $sql .= " , buy_price_ht=".price2num($this->pa_ht);
3362  if (strlen($this->special_code)) {
3363  $sql .= " , special_code=".((int) $this->special_code);
3364  }
3365  $sql .= " , fk_parent_line=".($this->fk_parent_line > 0 ? $this->fk_parent_line : "null");
3366  if (!empty($this->rang)) {
3367  $sql .= ", rang=".((int) $this->rang);
3368  }
3369  $sql .= " , ref_fourn=".(!empty($this->ref_fourn) ? "'".$this->db->escape($this->ref_fourn)."'" : "null");
3370  $sql .= " , fk_unit=".($this->fk_unit ? $this->fk_unit : 'null');
3371 
3372  // Multicurrency
3373  $sql .= " , multicurrency_subprice=".price2num($this->multicurrency_subprice);
3374  $sql .= " , multicurrency_total_ht=".price2num($this->multicurrency_total_ht);
3375  $sql .= " , multicurrency_total_tva=".price2num($this->multicurrency_total_tva);
3376  $sql .= " , multicurrency_total_ttc=".price2num($this->multicurrency_total_ttc);
3377 
3378  $sql .= " WHERE rowid = ".((int) $this->id);
3379 
3380  dol_syslog(get_class($this)."::update", LOG_DEBUG);
3381  $resql = $this->db->query($sql);
3382  if ($resql) {
3383  if (!$error) {
3384  $result = $this->insertExtraFields();
3385  if ($result < 0) {
3386  $error++;
3387  }
3388  }
3389 
3390  if (!$error && !$notrigger) {
3391  // Call trigger
3392  $result = $this->call_trigger('LINESUPPLIER_PROPOSAL_MODIFY', $user);
3393  if ($result < 0) {
3394  $this->db->rollback();
3395  return -1;
3396  }
3397  // End call triggers
3398  }
3399 
3400  $this->db->commit();
3401  return 1;
3402  } else {
3403  $this->error = $this->db->error();
3404  $this->db->rollback();
3405  return -2;
3406  }
3407  }
3408 
3409  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
3416  public function update_total()
3417  {
3418  // phpcs:enable
3419  $this->db->begin();
3420 
3421  // Mise a jour ligne en base
3422  $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposaldet SET";
3423  $sql .= " total_ht=".price2num($this->total_ht, 'MT');
3424  $sql .= ",total_tva=".price2num($this->total_tva, 'MT');
3425  $sql .= ",total_ttc=".price2num($this->total_ttc, 'MT');
3426  $sql .= " WHERE rowid = ".((int) $this->id);
3427 
3428  dol_syslog("SupplierProposalLine::update_total", LOG_DEBUG);
3429 
3430  $resql = $this->db->query($sql);
3431  if ($resql) {
3432  $this->db->commit();
3433  return 1;
3434  } else {
3435  $this->error = $this->db->error();
3436  $this->db->rollback();
3437  return -2;
3438  }
3439  }
3440 }
SupplierProposal\cloture
cloture($user, $status, $note)
Close the askprice.
Definition: supplier_proposal.class.php:1690
SupplierProposal\replaceThirdparty
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
Definition: supplier_proposal.class.php:2740
SupplierProposalLine\update
update($notrigger=0)
Update propal line object into DB.
Definition: supplier_proposal.class.php:3265
Societe
Class to manage third parties objects (customers, suppliers, prospects...)
Definition: societe.class.php:51
getLocalTaxesFromRate
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
Definition: functions.lib.php:6386
SupplierProposal\getTooltipContentArray
getTooltipContentArray($params)
getTooltipContentArray
Definition: supplier_proposal.class.php:2477
dol_escape_htmltag
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
Definition: functions.lib.php:1594
dol_sanitizeFileName
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
Definition: functions.lib.php:1322
SupplierProposal\getNextNumRef
getNextNumRef($soc)
Returns the reference to the following non used Proposal used depending on the active numbering modul...
Definition: supplier_proposal.class.php:2428
dol_delete_dir_recursive
dol_delete_dir_recursive($dir, $count=0, $nophperrors=0, $onlysub=0, &$countdeleted=0, $indexdatabase=1, $nolog=0)
Remove a directory $dir and its subdirectories (or only files and subdirectories)
Definition: files.lib.php:1483
DoliDB
Class to manage Dolibarr database access.
Definition: DoliDB.class.php:30
ProductFournisseur
Class to manage predefined suppliers products.
Definition: fournisseur.product.class.php:40
SupplierProposal\insert_discount
insert_discount($idremise)
Adding line of fixed discount in the proposal in DB.
Definition: supplier_proposal.class.php:306
GETPOST
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
Definition: functions.lib.php:607
CommonObject\updateRangOfLine
updateRangOfLine($rowid, $rang)
Update position of line (rang)
Definition: commonobject.class.php:3138
dol_print_error
dol_print_error($db='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
Definition: functions.lib.php:5096
CommonObject\setErrorsFromObject
setErrorsFromObject($object)
setErrorsFromObject
Definition: commonobject.class.php:711
SupplierProposal\valid
valid($user, $notrigger=0)
Set status to validated.
Definition: supplier_proposal.class.php:1409
SupplierProposal\getLinesArray
getLinesArray()
Retrieve an array of supplier proposal lines.
Definition: supplier_proposal.class.php:2620
SupplierProposal\set_remise_percent
set_remise_percent($user, $remise)
Set an overall discount on the proposal.
Definition: supplier_proposal.class.php:1563
Translate
Class to manage translations.
Definition: translate.class.php:30
dol_buildpath
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
Definition: functions.lib.php:1157
SupplierProposal\getLibStatut
getLibStatut($mode=0)
Return label of status of proposal (draft, validated, ...)
Definition: supplier_proposal.class.php:2171
SupplierProposal\generateDocument
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
Definition: supplier_proposal.class.php:2709
dol_dir_list
dol_dir_list($path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
Definition: files.lib.php:62
CommonIncoterm
trait CommonIncoterm
Superclass for incoterm classes.
Definition: commonincoterm.class.php:29
SupplierProposal\STATUS_NOTSIGNED
const STATUS_NOTSIGNED
Not signed quote, canceled.
Definition: supplier_proposal.class.php:215
CommonObject\deleteObjectLinked
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid='', $f_user=null, $notrigger=0)
Delete all links between an object $this.
Definition: commonobject.class.php:4143
SupplierProposal\add_product
add_product($idproduct, $qty, $remise_percent=0)
Add line into array ->lines.
Definition: supplier_proposal.class.php:253
SupplierProposal\set_date_livraison
set_date_livraison($user, $delivery_date)
Set delivery date.
Definition: supplier_proposal.class.php:1522
SupplierProposal\addline
addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1=0, $txlocaltax2=0, $fk_product=0, $remise_percent=0, $price_base_type='HT', $pu_ttc=0, $info_bits=0, $type=0, $rang=-1, $special_code=0, $fk_parent_line=0, $fk_fournprice=0, $pa_ht=0, $label='', $array_options=0, $ref_supplier='', $fk_unit='', $origin='', $origin_id=0, $pu_ht_devise=0, $date_start=0, $date_end=0)
Add a proposal line into database (linked to product/service or not) Les parametres sont deja cense e...
Definition: supplier_proposal.class.php:400
CommonObjectLine
Parent class for class inheritance lines of business objects This class is useless for the moment so ...
Definition: commonobjectline.class.php:32
CommonObject
Parent class of all other business classes (invoices, contracts, proposals, orders,...
Definition: commonobject.class.php:45
SupplierProposal\reopen
reopen($user, $statut, $note='', $notrigger=0)
Reopen the commercial proposal.
Definition: supplier_proposal.class.php:1632
price2num
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
Definition: functions.lib.php:5943
SupplierProposal\liste_array
liste_array($shortlist=0, $draft=0, $notcurrentuser=0, $socid=0, $limit=0, $offset=0, $sortfield='p.datec', $sortorder='DESC')
Return list of askprice (eventually filtered on user) into an array.
Definition: supplier_proposal.class.php:1948
SupplierProposal\STATUS_VALIDATED
const STATUS_VALIDATED
Validated status.
Definition: supplier_proposal.class.php:205
dol_print_date
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs='', $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
Definition: functions.lib.php:2665
SupplierProposal\$table_ref_field
$table_ref_field
{}
Definition: supplier_proposal.class.php:94
SupplierProposal\LibStatut
LibStatut($status, $mode=1)
Return label of a status (draft, validated, ...)
Definition: supplier_proposal.class.php:2184
WorkboardResponse
Definition: workboardresponse.class.php:24
CommonObject\fetch_thirdparty
fetch_thirdparty($force_thirdparty_id=0)
Load the third party of object, from id $this->socid or $this->fk_soc, into this->thirdparty.
Definition: commonobject.class.php:1613
SupplierProposal\deleteline
deleteline($lineid)
Delete detail line.
Definition: supplier_proposal.class.php:848
img_picto
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
Definition: functions.lib.php:4125
SupplierProposalLine\$ref
$ref
Definition: supplier_proposal.class.php:2914
SupplierProposal\$price
$price
Definition: supplier_proposal.class.php:155
rowid
print *****$script_file(".$version.") pid c cd cd cd description as p label as s rowid
Definition: email_expire_services_to_representatives.php:79
CommonObject\commonGenerateDocument
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
Definition: commonobject.class.php:5334
calcul_price_total
calcul_price_total($qty, $pu, $remise_percent_ligne, $txtva, $uselocaltax1_rate, $uselocaltax2_rate, $remise_percent_global, $price_base_type, $info_bits, $type, $seller='', $localtaxes_array='', $progress=100, $multicurrency_tx=1, $pu_devise=0, $multicurrency_code='')
Calculate totals (net, vat, ...) of a line.
Definition: price.lib.php:86
dol_delete_file
dol_delete_file($file, $disableglob=0, $nophperrors=0, $nohook=0, $object=null, $allowdotdot=false, $indexdatabase=1, $nolog=0)
Remove a file or several files with a mask.
Definition: files.lib.php:1332
CommonObject\update_price
update_price($exclspec=0, $roundingadjust='none', $nodatabaseupdate=0, $seller=null)
Update total_ht, total_ttc, total_vat, total_localtax1, total_localtax2 for an object (sum of lines).
Definition: commonobject.class.php:3450
SupplierProposal\load_board
load_board($user, $mode)
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
Definition: supplier_proposal.class.php:2229
SupplierProposal\create
create($user, $notrigger=0)
Create commercial proposal into database this->ref can be set or empty.
Definition: supplier_proposal.class.php:877
SupplierProposal\info
info($id)
Object SupplierProposal Information.
Definition: supplier_proposal.class.php:2122
MultiCurrency
Class Currency.
Definition: multicurrency.class.php:39
get_default_npr
get_default_npr(Societe $thirdparty_seller, Societe $thirdparty_buyer, $idprod=0, $idprodfournprice=0)
Function that returns whether VAT must be recoverable collected VAT (e.g.
Definition: functions.lib.php:6726
getEntity
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
Definition: functions.lib.php:265
SupplierProposal\getNomUrl
getNomUrl($withpicto=0, $option='', $get_params='', $notooltip=0, $save_lastsearch_value=-1, $addlinktonotes=0)
Return clicable link of object (with eventually picto)
Definition: supplier_proposal.class.php:2524
get_localtax
get_localtax($vatrate, $local, $thirdparty_buyer="", $thirdparty_seller="", $vatnpr=0)
Return localtax rate for a particular vat, when selling a product with vat $vatrate,...
Definition: functions.lib.php:6124
CommonObject\insertExtraFields
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
Definition: commonobject.class.php:6110
SupplierProposalLine\insert
insert($notrigger=0)
Insert object line propal in database.
Definition: supplier_proposal.class.php:3059
CommonObject\isExistingObject
static isExistingObject($element, $id, $ref='', $ref_ext='')
Check an object id/ref exists If you don't need/want to instantiate object and just need to know if o...
Definition: commonobject.class.php:669
$sql
if(isModEnabled('facture') &&!empty($user->rights->facture->lire)) if((isModEnabled('fournisseur') &&empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD) && $user->hasRight("fournisseur", "facture", "lire"))||(isModEnabled('supplier_invoice') && $user->hasRight("supplier_invoice", "lire"))) if(isModEnabled('don') && $user->hasRight('don', 'lire')) if(isModEnabled('tax') &&!empty($user->rights->tax->charges->lire)) if(isModEnabled('facture') &&isModEnabled('commande') && $user->hasRight("commande", "lire") &&empty($conf->global->WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER)) $sql
Social contributions to pay.
Definition: index.php:746
CommonObject\defineBuyPrice
defineBuyPrice($unitPrice=0.0, $discountPercent=0.0, $fk_product=0)
Get buy price to use for margin calculation.
Definition: commonobject.class.php:8527
dol_string_nohtmltag
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
Definition: functions.lib.php:7034
CommonObject\commonReplaceProduct
static commonReplaceProduct(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a product id with another one.
Definition: commonobject.class.php:8498
CommonObject\deleteEcmFiles
deleteEcmFiles($mode=0)
Delete related files of object in database.
Definition: commonobject.class.php:10100
dol_syslog
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
Definition: functions.lib.php:1732
DiscountAbsolute
Class to manage absolute discounts.
Definition: discount.class.php:29
SupplierProposalLine\__construct
__construct($db)
Class line Contructor.
Definition: supplier_proposal.class.php:2969
SupplierProposal\updatePriceFournisseur
updatePriceFournisseur($idProductFournPrice, $product, $user)
Upate ProductFournisseur.
Definition: supplier_proposal.class.php:1804
SupplierProposal\fetch
fetch($rowid, $ref='')
Load a proposal from database and its ligne array.
Definition: supplier_proposal.class.php:1203
MultiCurrency\getIdAndTxFromCode
static getIdAndTxFromCode($dbs, $code, $date_document='')
Get id and rate of currency from code.
Definition: multicurrency.class.php:528
CommonObject\line_max
line_max($fk_parent_line=0)
Get max value used for position of line (rang)
Definition: commonobject.class.php:3296
CommonObject\fetch_optionals
fetch_optionals($rowid=null, $optionsArray=null)
Function to get extra fields of an object into $this->array_options This method is in most cases call...
Definition: commonobject.class.php:5959
SupplierProposalLine\fetch
fetch($rowid)
Retrieve the propal line object.
Definition: supplier_proposal.class.php:2980
dol_strlen
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
Definition: functions.lib.php:3987
get_default_tva
get_default_tva(Societe $thirdparty_seller, Societe $thirdparty_buyer, $idprod=0, $idprodfournprice=0)
Function that return vat rate of a product line (according to seller, buyer and product vat rate) VAT...
Definition: functions.lib.php:6612
SupplierProposal\createFromClone
createFromClone(User $user, $fromid=0)
Load an object from its id and create a new one in database.
Definition: supplier_proposal.class.php:1110
SupplierProposal\$author
$author
Definition: supplier_proposal.class.php:102
SupplierProposal\createPriceFournisseur
createPriceFournisseur($product, $user)
Create ProductFournisseur.
Definition: supplier_proposal.class.php:1827
isModEnabled
isModEnabled($module)
Is Dolibarr module enabled.
Definition: functions.lib.php:207
ref
$object ref
Definition: info.php:78
User
Class to manage Dolibarr users.
Definition: user.class.php:47
SupplierProposalLine\$fk_product_type
$fk_product_type
Definition: supplier_proposal.class.php:2862
SupplierProposal\$datev
$datev
Definition: supplier_proposal.class.php:139
SupplierProposal\initAsSpecimen
initAsSpecimen()
Initialise an instance with random values.
Definition: supplier_proposal.class.php:2308
CommonObject\deleteExtraFields
deleteExtraFields()
Delete all extra fields values for the current object.
Definition: commonobject.class.php:6070
CommonObject\$note
$note
Definition: commonobject.class.php:478
Product
Class to manage products or services.
Definition: product.class.php:46
SupplierProposalLine
Class to manage supplier_proposal lines.
Definition: supplier_proposal.class.php:2812
getMarginInfos
getMarginInfos($pvht, $remise_percent, $tva_tx, $localtax1_tx, $localtax2_tx, $fk_pa, $paht)
Return an array with margins information of a line.
Definition: margins.lib.php:118
SupplierProposal\updateline
updateline($rowid, $pu, $qty, $remise_percent, $txtva, $txlocaltax1=0, $txlocaltax2=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, $array_options=0, $ref_supplier='', $fk_unit='', $pu_ht_devise=0)
Update a proposal line.
Definition: supplier_proposal.class.php:681
SupplierProposal\$tva
$tva
Definition: supplier_proposal.class.php:161
dol_delete_preview
dol_delete_preview($object)
Delete all preview files linked to object instance.
Definition: files.lib.php:1535
CommonObject\add_object_linked
add_object_linked($origin=null, $origin_id=null, $f_user=null, $notrigger=0)
Add an object link into llx_element_element.
Definition: commonobject.class.php:3733
SupplierProposal\replaceProduct
static replaceProduct(DoliDB $db, $origin_id, $dest_id)
Function used to replace a product id with another one.
Definition: supplier_proposal.class.php:2757
dolGetStatus
dolGetStatus($statusLabel='', $statusLabelShort='', $html='', $statusType='status0', $displayMode=0, $url='', $params=array())
Output the badge of a status.
Definition: functions.lib.php:10932
SupplierProposal\load_state_board
load_state_board()
Load indicator this->nb of global stats widget.
Definition: supplier_proposal.class.php:2387
img_object
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
Definition: functions.lib.php:4462
SupplierProposal\set_remise_absolue
set_remise_absolue($user, $remise)
Set an absolute overall discount on the proposal.
Definition: supplier_proposal.class.php:1595
SupplierProposal\__construct
__construct($db, $socid="", $supplier_proposalid=0)
Constructor.
Definition: supplier_proposal.class.php:231
SupplierProposal\STATUS_CLOSE
const STATUS_CLOSE
Billed or closed/processed quote.
Definition: supplier_proposal.class.php:220
dol_now
dol_now($mode='auto')
Return date for now.
Definition: functions.lib.php:3046
price
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
Definition: functions.lib.php:5817
CommonObject\call_trigger
call_trigger($triggerName, $user)
Call trigger based on this instance.
Definition: commonobject.class.php:5743
SupplierProposalLine\update_total
update_total()
Update DB line fields total_xxx Used by migration.
Definition: supplier_proposal.class.php:3416
Product\TYPE_PRODUCT
const TYPE_PRODUCT
Regular product.
Definition: product.class.php:552
SupplierProposal\$datec
$datec
Definition: supplier_proposal.class.php:128
SupplierProposal
Class to manage price ask supplier.
Definition: supplier_proposal.class.php:50
getDolGlobalInt
getDolGlobalInt($key, $default=0)
Return dolibarr global constant int value.
Definition: functions.lib.php:156
CommonObject\line_order
line_order($renum=false, $rowidorder='ASC', $fk_parent_line=true)
Save a new position (field rang) for details lines.
Definition: commonobject.class.php:2974
SupplierProposal\STATUS_DRAFT
const STATUS_DRAFT
Draft status.
Definition: supplier_proposal.class.php:200
CommonObject\commonReplaceThirdparty
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
Definition: commonobject.class.php:8469
SupplierProposal\updateOrCreatePriceFournisseur
updateOrCreatePriceFournisseur($user)
Add or update supplier price according to result of proposal.
Definition: supplier_proposal.class.php:1763
SupplierProposalLine\$libelle
$libelle
Definition: supplier_proposal.class.php:2926
SupplierProposal\getKanbanView
getKanbanView($option='', $arraydata=null)
Return clicable link of object (with eventually picto)
Definition: supplier_proposal.class.php:2774
SupplierProposal\setDeliveryDate
setDeliveryDate($user, $delivery_date)
Set delivery date.
Definition: supplier_proposal.class.php:1535
SupplierProposal\setDraft
setDraft($user)
Set draft status.
Definition: supplier_proposal.class.php:1890
SupplierProposal\STATUS_SIGNED
const STATUS_SIGNED
Signed quote.
Definition: supplier_proposal.class.php:210
SupplierProposal\$total
$total
Definition: supplier_proposal.class.php:167
float
div float
Buy price without taxes.
Definition: style.css.php:921