dolibarr 23.0.4
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-2025 Frédéric France <frederic.france@free.fr>
17 * Copyright (C) 2020 Tobias Sekan <tobias.sekan@startmail.com>
18 * Copyright (C) 2022 Gauthier VERDOL <gauthier.verdol@atm-consulting.fr>
19 * Copyright (C) 2024-2025 MDW <mdeweerd@users.noreply.github.com>
20 *
21 * This program is free software; you can redistribute it and/or modify
22 * it under the terms of the GNU General Public License as published by
23 * the Free Software Foundation; either version 3 of the License, or
24 * (at your option) any later version.
25 *
26 * This program is distributed in the hope that it will be useful,
27 * but WITHOUT ANY WARRANTY; without even the implied warranty of
28 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
29 * GNU General Public License for more details.
30 *
31 * You should have received a copy of the GNU General Public License
32 * along with this program. If not, see <https://www.gnu.org/licenses/>.
33 */
34
40require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.product.class.php';
41require_once DOL_DOCUMENT_ROOT.'/core/class/commonobject.class.php';
42require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
43require_once DOL_DOCUMENT_ROOT.'/contact/class/contact.class.php';
44require_once DOL_DOCUMENT_ROOT.'/margin/lib/margins.lib.php';
45require_once DOL_DOCUMENT_ROOT.'/multicurrency/class/multicurrency.class.php';
46require_once DOL_DOCUMENT_ROOT.'/core/class/commonincoterm.class.php';
47
52{
53 use CommonIncoterm;
54
58 public $element = 'supplier_proposal';
59
63 public $table_element = 'supplier_proposal';
64
68 public $table_element_line = 'supplier_proposaldet';
69
73 public $class_element_line = 'SupplierProposalLine';
77 public $fk_element = 'fk_supplier_proposal';
78
82 public $picto = 'supplier_proposal';
83
88 public $restrictiononfksoc = 1;
89
93 protected $table_ref_field = 'ref';
94
98 public $socid; // Id client
99
105 public $author;
106
110 public $ref_fourn; //Reference saisie lors de l'ajout d'une ligne à la demande
114 public $ref_supplier; //Reference saisie lors de l'ajout d'une ligne à la demande
115
120 public $statut; // 0 (draft), 1 (validated), 2 (signed), 3 (not signed), 4 (processed/billed)
121
125 public $date;
126
130 public $delivery_date;
131
137 public $datec;
138
144 public $datev;
145
149 public $user_author_id;
150
156 public $price;
157
163 public $tva;
164
170 public $total;
171
175 public $cond_reglement_code;
179 public $cond_reglement_doc; // label doc
183 public $cond_reglement_label;
184
188 public $mode_reglement_code;
193 public $mode_reglement;
194
200 public $deposit_percent;
201
202
206 public $extraparams = array();
207
211 public $lines = array();
212
216 public $line;
217
218 public $labelStatus = array();
219 public $labelStatusShort = array();
220
224 public $nbtodo;
228 public $nbtodolate;
229
230 // Multicurrency
234 public $fk_multicurrency;
235
239 public $multicurrency_code;
243 public $multicurrency_tx;
247 public $multicurrency_total_ht;
251 public $multicurrency_total_tva;
255 public $multicurrency_total_ttc;
256
257 public $fields = array(
258 'ref' => array('type' => 'varchar(255)', 'label' => 'Ref', 'enabled' => 1, 'visible' => 1, 'showoncombobox' => 1, 'position' => 25, 'searchall' => 1),
259 'note_public' => array('type' => 'html', 'label' => 'NotePublic', 'enabled' => 1, 'visible' => 0, 'position' => 750, 'searchall' => 1),
260 );
261
265 const STATUS_DRAFT = 0;
266
271
275 const STATUS_SIGNED = 2;
276
281
285 const STATUS_CLOSE = 4;
286
287
288
296 public function __construct($db, $socid = 0, $supplier_proposalid = 0)
297 {
298 $this->db = $db;
299
300 $this->ismultientitymanaged = 1;
301 $this->socid = $socid;
302 $this->id = $supplier_proposalid;
303 }
304
305
306 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
317 public function add_product($idproduct, $qty, $remise_percent = 0)
318 {
319 // phpcs:enable
320 global $conf, $mysoc;
321
322 if (!$qty) {
323 $qty = 1;
324 }
325
326 dol_syslog(get_class($this)."::add_product $idproduct, $qty, $remise_percent");
327 if ($idproduct > 0) {
328 $prod = new Product($this->db);
329 $prod->fetch($idproduct);
330
331 $productdesc = $prod->description;
332
333 $tva_tx = get_default_tva($mysoc, $this->thirdparty, $prod->id);
334 $tva_npr = get_default_npr($mysoc, $this->thirdparty, $prod->id);
335 if (empty($tva_tx)) {
336 $tva_npr = 0;
337 }
338 $localtax1_tx = get_localtax($tva_tx, 1, $mysoc, $this->thirdparty, $tva_npr);
339 $localtax2_tx = get_localtax($tva_tx, 2, $mysoc, $this->thirdparty, $tva_npr);
340
341 // multiprix
342 if (getDolGlobalString('PRODUIT_MULTIPRICES') && $this->thirdparty->price_level) {
343 $price = $prod->multiprices[$this->thirdparty->price_level];
344 } else {
345 $price = $prod->price;
346 }
347
348 $line = new SupplierProposalLine($this->db);
349
350 $line->fk_product = $idproduct;
351 $line->desc = $productdesc;
352 $line->qty = $qty;
353 $line->subprice = $price;
354 $line->remise_percent = $remise_percent;
355 $line->tva_tx = $tva_tx;
356
357 $this->lines[] = $line;
358 return 1;
359 }
360 return -1;
361 }
362
363 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
370 public function insert_discount($idremise)
371 {
372 // phpcs:enable
373 global $langs;
374
375 include_once DOL_DOCUMENT_ROOT.'/core/lib/price.lib.php';
376 include_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php';
377
378 $this->db->begin();
379
380 $remise = new DiscountAbsolute($this->db);
381 $result = $remise->fetch($idremise);
382
383 if ($result > 0) {
384 if ($remise->fk_facture) { // Protection against multiple submission
385 $this->error = $langs->trans("ErrorDiscountAlreadyUsed");
386 $this->db->rollback();
387 return -5;
388 }
389
390 $supplier_proposalligne = new SupplierProposalLine($this->db);
391 $supplier_proposalligne->fk_supplier_proposal = $this->id;
392 $supplier_proposalligne->fk_remise_except = $remise->id;
393 $supplier_proposalligne->desc = $remise->description; // Description ligne
394 $supplier_proposalligne->tva_tx = $remise->tva_tx;
395 $supplier_proposalligne->subprice = -(float) $remise->amount_ht;
396 $supplier_proposalligne->fk_product = 0; // Id produit predefini
397 $supplier_proposalligne->qty = 1;
398 $supplier_proposalligne->remise_percent = 0;
399 $supplier_proposalligne->rang = -1;
400 $supplier_proposalligne->info_bits = 2;
401
402 $supplier_proposalligne->total_ht = -(float) $remise->amount_ht;
403 $supplier_proposalligne->total_tva = -(float) $remise->amount_tva;
404 $supplier_proposalligne->total_ttc = -(float) $remise->amount_ttc;
405
406 $result = $supplier_proposalligne->insert();
407 if ($result > 0) {
408 $result = $this->update_price(1);
409 if ($result > 0) {
410 $this->db->commit();
411 return 1;
412 } else {
413 $this->db->rollback();
414 return -1;
415 }
416 } else {
417 $this->setErrorsFromObject($supplier_proposalligne);
418 $this->db->rollback();
419 return -2;
420 }
421 } else {
422 $this->db->rollback();
423 return -2;
424 }
425 }
426
464 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 = [], $ref_supplier = '', $fk_unit = 0, $origin = '', $origin_id = 0, $pu_ht_devise = 0, $date_start = 0, $date_end = 0)
465 {
466 global $mysoc, $langs;
467
468 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");
469 include_once DOL_DOCUMENT_ROOT.'/core/lib/price.lib.php';
470
471 // Clean parameters
472 if (empty($remise_percent)) {
473 $remise_percent = 0;
474 }
475 if (empty($qty)) {
476 $qty = 0;
477 }
478 if (empty($info_bits)) {
479 $info_bits = 0;
480 }
481 if (empty($rang)) {
482 $rang = 0;
483 }
484 if (empty($fk_parent_line) || $fk_parent_line < 0) {
485 $fk_parent_line = 0;
486 }
487 if (empty($pu_ht)) {
488 $pu_ht = 0;
489 }
490
491 $remise_percent = price2num($remise_percent);
492 $qty = (float) price2num($qty);
493 $pu_ht = price2num($pu_ht);
494 $pu_ttc = price2num($pu_ttc);
495 if (!preg_match('/\‍((.*)\‍)/', (string) $txtva)) {
496 $txtva = price2num($txtva); // $txtva can have format '5.0(XXX)' or '5'
497 }
498 $txlocaltax1 = price2num($txlocaltax1);
499 $txlocaltax2 = price2num($txlocaltax2);
500 $pa_ht = price2num($pa_ht);
501 if ($price_base_type == 'HT') {
502 $pu = $pu_ht;
503 } else {
504 $pu = $pu_ttc;
505 }
506
507 // Check parameters
508 if ($type < 0) {
509 return -1;
510 }
511
512 if ($this->status == self::STATUS_DRAFT) {
513 $this->db->begin();
514
515 if ($fk_product > 0) {
516 if (getDolGlobalInt('SUPPLIER_PROPOSAL_WITH_PREDEFINED_PRICES_ONLY') == 1) { // Not the common case
517 // Check quantity is enough
518 dol_syslog(get_class($this)."::addline we check supplier prices fk_product=".$fk_product." fk_fournprice=".$fk_fournprice." qty=".$qty." ref_supplier=".$ref_supplier);
519 $productsupplier = new ProductFournisseur($this->db);
520 if ($productsupplier->fetch($fk_product) > 0) {
521 $product_type = $productsupplier->type;
522 $label = $productsupplier->label;
523 $fk_prod_fourn_price = $fk_fournprice;
524
525 // We use 'none' instead of $ref_supplier, because fourn_ref may not exists anymore. So we will take the first supplier price ok.
526 // If we want a dedicated supplier price, we must provide $fk_prod_fourn_price.
527 // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
528 $result = $productsupplier->get_buyprice($fk_prod_fourn_price, $qty, $fk_product, 'none', $this->socid); // Search on couple $fk_prod_fourn_price/$qty first, then on triplet $qty/$fk_product/$ref_supplier/$this->socid
529 if ($result > 0) {
530 $pu = $productsupplier->fourn_pu; // Unit price supplier price set by get_buyprice
531 $ref_supplier = $productsupplier->ref_supplier; // Ref supplier price set by get_buyprice
532 // is remise percent not keyed but present for the product we add it
533 if ($remise_percent == 0 && $productsupplier->remise_percent != 0) {
534 $remise_percent = $productsupplier->remise_percent;
535 }
536 }
537 if ($result == 0) { // If result == 0, we failed to found the supplier reference price
538 $langs->load("errors");
539 $this->error = "Ref ".$productsupplier->ref." ".$langs->trans("ErrorQtyTooLowForThisSupplier");
540 $this->db->rollback();
541 dol_syslog(get_class($this)."::addline we did not found supplier price, so we can't guess unit price");
542 //$pu = $productsupplier->fourn_pu; // We do not overwrite unit price
543 //$ref = $productsupplier_fourn; // We do not overwrite ref supplier price
544 return -1;
545 }
546 if ($result == -1) {
547 $langs->load("errors");
548 $this->error = "Ref ".$productsupplier->ref." ".$langs->trans("ErrorQtyTooLowForThisSupplier");
549 $this->db->rollback();
550 dol_syslog(get_class($this)."::addline result=".$result." - ".$this->error, LOG_DEBUG);
551 return -1;
552 }
553 if ($result < -1) {
554 $this->setErrorsFromObject($productsupplier);
555 $this->db->rollback();
556 dol_syslog(get_class($this)."::addline result=".$result." - ".$this->error, LOG_ERR);
557 return -1;
558 }
559 } else {
560 $this->setErrorsFromObject($productsupplier);
561 $this->db->rollback();
562 return -1;
563 }
564 }
565 } else {
566 $product_type = $type;
567 }
568
569 // Calcul du total TTC et de la TVA pour la ligne a partir de
570 // qty, pu, remise_percent et txtva
571 // TRES IMPORTANT: C'est au moment de l'insertion ligne qu'on doit stocker
572 // la part ht, tva et ttc, et ce au niveau de la ligne qui a son propre taux tva.
573
574 $localtaxes_type = getLocalTaxesFromRate($txtva, 0, $this->thirdparty, $mysoc);
575
576 // Clean vat code
577 $reg = array();
578 $vat_src_code = '';
579 if (preg_match('/\‍((.*)\‍)/', $txtva, $reg)) {
580 $vat_src_code = $reg[1];
581 $txtva = preg_replace('/\s*\‍(.*\‍)/', '', $txtva); // Remove code into vatrate.
582 }
583
584 if (isModEnabled("multicurrency") && $pu_ht_devise > 0) {
585 $pu = 0;
586 }
587
588 $tabprice = calcul_price_total(
589 $qty,
590 $pu,
591 (float) $remise_percent,
592 $txtva,
593 (float) $txlocaltax1,
594 (float) $txlocaltax2,
595 0,
596 $price_base_type,
597 $info_bits,
598 $type,
599 $this->thirdparty,
600 $localtaxes_type,
601 100,
602 (float) $this->multicurrency_tx,
603 $pu_ht_devise
604 );
605 $total_ht = $tabprice[0];
606 $total_tva = $tabprice[1];
607 $total_ttc = $tabprice[2];
608 $total_localtax1 = $tabprice[9];
609 $total_localtax2 = $tabprice[10];
610 $pu = $pu_ht = $tabprice[3];
611
612 // MultiCurrency
613 $multicurrency_total_ht = $tabprice[16];
614 $multicurrency_total_tva = $tabprice[17];
615 $multicurrency_total_ttc = $tabprice[18];
616 $pu_ht_devise = $tabprice[19];
617
618 // Rang to use
619 $ranktouse = $rang;
620 if ($ranktouse == -1) {
621 $rangmax = $this->line_max($fk_parent_line);
622 $ranktouse = $rangmax + 1;
623 }
624
625 // Insert line
626 $this->line = new SupplierProposalLine($this->db);
627
628 $this->line->fk_supplier_proposal = $this->id;
629 $this->line->label = $label;
630 $this->line->desc = $desc;
631 $this->line->qty = $qty;
632
633 $this->line->vat_src_code = $vat_src_code;
634 $this->line->tva_tx = $txtva;
635 $this->line->localtax1_tx = ($total_localtax1 ? $localtaxes_type[1] : 0);
636 $this->line->localtax2_tx = ($total_localtax2 ? $localtaxes_type[3] : 0);
637 $this->line->localtax1_type = empty($localtaxes_type[0]) ? '' : $localtaxes_type[0];
638 $this->line->localtax2_type = empty($localtaxes_type[2]) ? '' : $localtaxes_type[2];
639 $this->line->fk_product = $fk_product;
640 $this->line->remise_percent = $remise_percent;
641 $this->line->subprice = (float) $pu_ht;
642 $this->line->rang = $ranktouse;
643 $this->line->info_bits = $info_bits;
644 $this->line->total_ht = (float) $total_ht;
645 $this->line->total_tva = (float) $total_tva;
646 $this->line->total_localtax1 = (float) $total_localtax1;
647 $this->line->total_localtax2 = (float) $total_localtax2;
648 $this->line->total_ttc = (float) $total_ttc;
649 $this->line->product_type = $type;
650 $this->line->special_code = $special_code;
651 $this->line->fk_parent_line = $fk_parent_line;
652 $this->line->fk_unit = $fk_unit;
653 $this->line->origin = $origin;
654 $this->line->origin_type = $origin;
655 $this->line->origin_id = $origin_id;
656 $this->line->ref_fourn = $this->db->escape($ref_supplier);
657 $this->line->date_start = $date_start;
658 $this->line->date_end = $date_end;
659
660 // infos merge
661 if (!empty($fk_product) && $fk_product > 0 && empty($fk_fournprice) && empty($pa_ht)) {
662 // When fk_fournprice is 0, we take the lowest buying price
663 include_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.product.class.php';
664 $productFournisseur = new ProductFournisseur($this->db);
665 $productFournisseur->find_min_price_product_fournisseur($fk_product);
666 $this->line->fk_fournprice = $productFournisseur->product_fourn_price_id;
667 } else {
668 $this->line->fk_fournprice = ($fk_fournprice > 0 ? $fk_fournprice : 0); // If fk_fournprice is -1, we will not use fk_fournprice
669 }
670 $this->line->pa_ht = $pa_ht;
671 //var_dump($this->line->fk_fournprice);exit;
672
673 // Multicurrency
674 $this->line->fk_multicurrency = $this->fk_multicurrency;
675 $this->line->multicurrency_code = $this->multicurrency_code;
676 $this->line->multicurrency_subprice = (float) $pu_ht_devise;
677 $this->line->multicurrency_total_ht = (float) $multicurrency_total_ht;
678 $this->line->multicurrency_total_tva = (float) $multicurrency_total_tva;
679 $this->line->multicurrency_total_ttc = (float) $multicurrency_total_ttc;
680
681 // Mise en option de la ligne
682 if (empty($qty) && empty($special_code)) {
683 $this->line->special_code = 3;
684 }
685
686 if (is_array($array_options) && count($array_options) > 0) {
687 $this->line->array_options = $array_options;
688 }
689
690 $result = $this->line->insert();
691 if ($result > 0) {
692 // Reorder if child line
693 if (!empty($fk_parent_line)) {
694 $this->line_order(true, 'DESC');
695 } elseif ($ranktouse > 0 && $ranktouse <= count($this->lines)) { // Update all rank of all other lines
696 $linecount = count($this->lines);
697 for ($ii = $ranktouse; $ii <= $linecount; $ii++) {
698 $this->updateRangOfLine($this->lines[$ii - 1]->id, $ii + 1);
699 }
700 }
701
702 // Mise a jour information denormalisees au niveau de la propale meme
703 $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.
704 if ($result > 0) {
705 $this->db->commit();
706 return $this->line->id;
707 } else {
708 $this->db->rollback();
709 return -1;
710 }
711 } else {
712 $this->setErrorsFromObject($this->line);
713 $this->db->rollback();
714 return -2;
715 }
716 } else {
717 $this->error = 'BadStatusOfObjectToAddLine';
718 return -5;
719 }
720 }
721
722
749 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 = [], $ref_supplier = '', $fk_unit = 0, $pu_ht_devise = 0)
750 {
751 global $mysoc;
752
753 if (!$this->isLineOfObject($rowid)) {
754 $this->error = 'ErrorLineIDDoesNotMatchWithObjectID';
755 return -1;
756 }
757
758 dol_syslog(get_class($this)."::updateLine $rowid, $pu, $qty, $remise_percent, $txtva, $desc, $price_base_type, $info_bits");
759 include_once DOL_DOCUMENT_ROOT.'/core/lib/price.lib.php';
760
761 // Clean parameters
762 $remise_percent = price2num($remise_percent);
763 $qty = (float) price2num($qty);
764 $pu = price2num($pu);
765 if (!preg_match('/\‍((.*)\‍)/', (string) $txtva)) {
766 $txtva = price2num($txtva); // $txtva can have format '5.0(XXX)' or '5'
767 }
768 $txlocaltax1 = price2num($txlocaltax1);
769 $txlocaltax2 = price2num($txlocaltax2);
770 $pa_ht = price2num($pa_ht);
771 if (empty($qty) && empty($special_code)) {
772 $special_code = 3; // Set option tag
773 }
774 if (!empty($qty) && $special_code == 3) {
775 $special_code = 0; // Remove option tag
776 }
777
778 if ($this->status == 0) {
779 $this->db->begin();
780
781 // Calcul du total TTC et de la TVA pour la ligne a partir de
782 // qty, pu, remise_percent et txtva
783 // TRES IMPORTANT: C'est au moment de l'insertion ligne qu'on doit stocker
784 // la part ht, tva et ttc, et ce au niveau de la ligne qui a son propre taux tva.
785
786 $localtaxes_type = getLocalTaxesFromRate($txtva, 0, $mysoc, $this->thirdparty);
787
788 // Clean vat code
789 $reg = array();
790 $vat_src_code = '';
791 if (preg_match('/\‍((.*)\‍)/', $txtva, $reg)) {
792 $vat_src_code = $reg[1];
793 $txtva = preg_replace('/\s*\‍(.*\‍)/', '', $txtva); // Remove code into vatrate.
794 }
795
796 if (isModEnabled("multicurrency") && $pu_ht_devise > 0) {
797 $pu = 0;
798 }
799
800 $tabprice = calcul_price_total(
801 $qty,
802 $pu,
803 (float) $remise_percent,
804 $txtva,
805 (float) $txlocaltax1,
806 (float) $txlocaltax2,
807 0,
808 $price_base_type,
809 $info_bits,
810 $type,
811 $this->thirdparty,
812 $localtaxes_type,
813 100,
814 (float) $this->multicurrency_tx,
815 $pu_ht_devise
816 );
817 $total_ht = $tabprice[0];
818 $total_tva = $tabprice[1];
819 $total_ttc = $tabprice[2];
820 $total_localtax1 = $tabprice[9];
821 $total_localtax2 = $tabprice[10];
822 $pu_ht = $tabprice[3];
823 $pu_tva = $tabprice[4];
824 $pu_ttc = $tabprice[5];
825
826 // MultiCurrency
827 $multicurrency_total_ht = $tabprice[16];
828 $multicurrency_total_tva = $tabprice[17];
829 $multicurrency_total_ttc = $tabprice[18];
830 $pu_ht_devise = $tabprice[19];
831
832 $pu = $pu_ht;
833 if ($price_base_type == 'TTC') {
834 $pu = $pu_ttc;
835 }
836
837 // Fetch current line from the database and then clone the object and set it in $oldline property
838 $line = new SupplierProposalLine($this->db);
839 $line->fetch($rowid);
840 $line->fetch_optionals();
841
842 $fk_product = $line->fk_product;
843
844 // Stock previous line records
845 $staticline = clone $line;
846
847 $line->oldline = $staticline;
848 $this->line = $line;
849 $this->line->context = $this->context;
850
851 // Reorder if fk_parent_line change
852 if (!empty($fk_parent_line) && !empty($staticline->fk_parent_line) && $fk_parent_line != $staticline->fk_parent_line) {
853 $rangmax = $this->line_max($fk_parent_line);
854 $this->line->rang = $rangmax + 1;
855 }
856
857 $this->line->id = $rowid;
858 $this->line->label = $label;
859 $this->line->desc = $desc;
860 $this->line->qty = $qty;
861 $this->line->product_type = $type;
862
863 $this->line->vat_src_code = $vat_src_code;
864 $this->line->tva_tx = $txtva;
865 $this->line->localtax1_tx = $txlocaltax1;
866 $this->line->localtax2_tx = $txlocaltax2;
867 $this->line->localtax1_type = empty($localtaxes_type[0]) ? '' : $localtaxes_type[0];
868 $this->line->localtax2_type = empty($localtaxes_type[2]) ? '' : $localtaxes_type[2];
869 $this->line->remise_percent = $remise_percent;
870 $this->line->subprice = (float) $pu;
871 $this->line->info_bits = $info_bits;
872 $this->line->total_ht = (float) $total_ht;
873 $this->line->total_tva = (float) $total_tva;
874 $this->line->total_localtax1 = (float) $total_localtax1;
875 $this->line->total_localtax2 = (float) $total_localtax2;
876 $this->line->total_ttc = (float) $total_ttc;
877 $this->line->special_code = $special_code;
878 $this->line->fk_parent_line = $fk_parent_line;
879 $this->line->skip_update_total = $skip_update_total;
880 $this->line->ref_fourn = $ref_supplier;
881 $this->line->fk_unit = $fk_unit;
882
883 // infos merge
884 if (!empty($fk_product) && $fk_product > 0 && empty($fk_fournprice) && empty($pa_ht)) {
885 // by external module, take lowest buying price
886 include_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.product.class.php';
887 $productFournisseur = new ProductFournisseur($this->db);
888 $productFournisseur->find_min_price_product_fournisseur($fk_product);
889 $this->line->fk_fournprice = $productFournisseur->product_fourn_price_id;
890 } else {
891 $this->line->fk_fournprice = $fk_fournprice;
892 }
893 $this->line->pa_ht = $pa_ht;
894
895 if (is_array($array_options) && count($array_options) > 0) {
896 // We replace values in this->line->array_options only for entries defined into $array_options
897 foreach ($array_options as $key => $value) {
898 $this->line->array_options[$key] = $array_options[$key];
899 }
900 }
901
902 // Multicurrency
903 $this->line->multicurrency_subprice = (float) $pu_ht_devise;
904 $this->line->multicurrency_total_ht = (float) $multicurrency_total_ht;
905 $this->line->multicurrency_total_tva = (float) $multicurrency_total_tva;
906 $this->line->multicurrency_total_ttc = (float) $multicurrency_total_ttc;
907
908 $result = $this->line->update();
909 if ($result > 0) {
910 // Reorder if child line
911 if (!empty($fk_parent_line)) {
912 $this->line_order(true, 'DESC');
913 }
914
915 $this->update_price(1);
916
917 $this->db->commit();
918 return $result;
919 } else {
920 $this->error = $this->db->error();
921 $this->db->rollback();
922 return -1;
923 }
924 } else {
925 dol_syslog(get_class($this)."::updateline Erreur -2 SupplierProposal en mode incompatible pour cette action");
926 return -2;
927 }
928 }
929
930
937 public function deleteLine($lineid)
938 {
939 global $user;
940
941 if ($this->status == 0) {
942 $line = new SupplierProposalLine($this->db);
943
944 // For triggers
945 $line->fetch($lineid);
946
947 if ($this->id > 0 && (int) $line->fk_supplier_proposal !== (int) $this->id) {
948 $this->error = 'ErrorLineIDDoesNotMatchWithObjectID';
949 return -1;
950 }
951
952 if ($line->delete($user) > 0) {
953 $this->update_price(1);
954
955 return 1;
956 } else {
957 return -1;
958 }
959 } else {
960 return -2;
961 }
962 }
963
964
973 public function create($user, $notrigger = 0)
974 {
975 global $langs, $conf, $mysoc, $hookmanager;
976 $error = 0;
977
978 $now = dol_now();
979
980 dol_syslog(get_class($this)."::create");
981
982 // Check parameters
983 $result = $this->fetch_thirdparty();
984 if ($result < 0) {
985 $this->error = "Failed to fetch company";
986 dol_syslog(get_class($this)."::create ".$this->error, LOG_ERR);
987 return -3;
988 }
989 if (!empty($this->ref)) { // We check that ref is not already used
990 $result = self::isExistingObject($this->element, 0, $this->ref); // Check ref is not yet used
991 if ($result > 0) {
992 $this->error = 'ErrorRefAlreadyExists';
993 dol_syslog(get_class($this)."::create ".$this->error, LOG_WARNING);
994 $this->db->rollback();
995 return -1;
996 }
997 }
998
999 // Set tmp vars
1000 $delivery_date = $this->delivery_date;
1001
1002 // Multicurrency
1003 if (!empty($this->multicurrency_code)) {
1004 list($this->fk_multicurrency, $this->multicurrency_tx) = MultiCurrency::getIdAndTxFromCode($this->db, $this->multicurrency_code, $now);
1005 }
1006 if (empty($this->fk_multicurrency)) {
1007 $this->multicurrency_code = getDolCurrency();
1008 $this->fk_multicurrency = 0;
1009 $this->multicurrency_tx = 1;
1010 }
1011
1012 $this->db->begin();
1013
1014 // Insert into database
1015 $sql = "INSERT INTO ".MAIN_DB_PREFIX."supplier_proposal (";
1016 $sql .= "fk_soc";
1017 $sql .= ", price";
1018 $sql .= ", total_tva";
1019 $sql .= ", total_ttc";
1020 $sql .= ", datec";
1021 $sql .= ", ref";
1022 $sql .= ", fk_user_author";
1023 $sql .= ", note_private";
1024 $sql .= ", note_public";
1025 $sql .= ", model_pdf";
1026 $sql .= ", fk_cond_reglement";
1027 $sql .= ", deposit_percent";
1028 $sql .= ", fk_mode_reglement";
1029 $sql .= ", fk_account";
1030 $sql .= ", date_livraison";
1031 $sql .= ", fk_shipping_method";
1032 $sql .= ", fk_projet";
1033 $sql .= ", entity";
1034 $sql .= ", fk_multicurrency";
1035 $sql .= ", multicurrency_code";
1036 $sql .= ", multicurrency_tx";
1037 $sql .= ") ";
1038 $sql .= " VALUES (";
1039 $sql .= ((int) $this->socid);
1040 $sql .= ", 0";
1041 $sql .= ", 0";
1042 $sql .= ", 0";
1043 $sql .= ", '".$this->db->idate($now)."'";
1044 $sql .= ", '(PROV)'";
1045 $sql .= ", ".($user->id > 0 ? ((int) $user->id) : "null");
1046 $sql .= ", '".$this->db->escape($this->note_private)."'";
1047 $sql .= ", '".$this->db->escape($this->note_public)."'";
1048 $sql .= ", '".$this->db->escape($this->model_pdf)."'";
1049 $sql .= ", ".($this->cond_reglement_id > 0 ? ((int) $this->cond_reglement_id) : 'NULL');
1050 $sql .= ", ".(!empty($this->deposit_percent) ? "'" . $this->db->escape($this->deposit_percent) . "'" : 'NULL');
1051 $sql .= ", ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) : 'NULL');
1052 $sql .= ", ".($this->fk_account > 0 ? ((int) $this->fk_account) : 'NULL');
1053 $sql .= ", ".(isDolTms($delivery_date) ? "'".$this->db->idate($delivery_date)."'" : "null");
1054 $sql .= ", ".($this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) : 'NULL');
1055 $sql .= ", ".($this->fk_project > 0 ? ((int) $this->fk_project) : "null");
1056 $sql .= ", ".((int) $conf->entity);
1057 $sql .= ", ".((int) $this->fk_multicurrency);
1058 $sql .= ", '".$this->db->escape($this->multicurrency_code)."'";
1059 $sql .= ", ".((float) $this->multicurrency_tx);
1060 $sql .= ")";
1061
1062 dol_syslog(get_class($this)."::create", LOG_DEBUG);
1063 $resql = $this->db->query($sql);
1064 if ($resql) {
1065 $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX."supplier_proposal");
1066
1067 if ($this->id) {
1068 $this->ref = '(PROV'.$this->id.')';
1069 $sql = 'UPDATE '.MAIN_DB_PREFIX."supplier_proposal SET ref='".$this->db->escape($this->ref)."' WHERE rowid=".((int) $this->id);
1070
1071 dol_syslog(get_class($this)."::create", LOG_DEBUG);
1072 $resql = $this->db->query($sql);
1073 if (!$resql) {
1074 $error++;
1075 }
1076
1077 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) { // To use new linkedObjectsIds instead of old linked_objects
1078 $this->linked_objects = $this->linkedObjectsIds; // TODO Replace linked_objects with linkedObjectsIds
1079 }
1080
1081 // Add object linked
1082 if (!$error && $this->id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
1083 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
1084 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, ...))
1085 foreach ($tmp_origin_id as $origin_id) {
1086 $ret = $this->add_object_linked($origin, $origin_id);
1087 if (!$ret) {
1088 dol_print_error($this->db);
1089 $error++;
1090 }
1091 }
1092 }
1093 }
1094 }
1095
1096 /*
1097 * Insertion du detail des produits dans la base
1098 */
1099 if (!$error) {
1100 $fk_parent_line = 0;
1101 $num = count($this->lines);
1102
1103 for ($i = 0; $i < $num; $i++) {
1104 // Reset fk_parent_line for no child products and special product
1105 if (($this->lines[$i]->product_type != 9 && empty($this->lines[$i]->fk_parent_line)) || $this->lines[$i]->product_type == 9) {
1106 $fk_parent_line = 0;
1107 }
1108
1109 $result = $this->addline(
1110 $this->lines[$i]->desc,
1111 $this->lines[$i]->subprice,
1112 $this->lines[$i]->qty,
1113 $this->lines[$i]->tva_tx,
1114 $this->lines[$i]->localtax1_tx,
1115 $this->lines[$i]->localtax2_tx,
1116 $this->lines[$i]->fk_product,
1117 $this->lines[$i]->remise_percent,
1118 'HT',
1119 0,
1120 0,
1121 $this->lines[$i]->product_type,
1122 $this->lines[$i]->rang,
1123 $this->lines[$i]->special_code,
1124 $fk_parent_line,
1125 $this->lines[$i]->fk_fournprice,
1126 $this->lines[$i]->pa_ht,
1127 empty($this->lines[$i]->label) ? '' : $this->lines[$i]->label, // deprecated
1128 $this->lines[$i]->array_options,
1129 $this->lines[$i]->ref_fourn,
1130 $this->lines[$i]->fk_unit,
1131 'supplier_proposal',
1132 $this->lines[$i]->rowid
1133 );
1134
1135 if ($result < 0) {
1136 $error++;
1137 $this->error = $this->db->error;
1138 dol_print_error($this->db);
1139 break;
1140 }
1141 // Defined the new fk_parent_line
1142 if ($result > 0 && $this->lines[$i]->product_type == 9) {
1143 $fk_parent_line = $result;
1144 }
1145 }
1146 }
1147
1148 if (!$error) {
1149 // Update denormalized data
1150 $resql = $this->update_price(1);
1151 if ($resql) {
1152 $action = 'update';
1153
1154 // Actions on extra fields
1155 if (!$error) {
1156 $result = $this->insertExtraFields();
1157 if ($result < 0) {
1158 $error++;
1159 }
1160 }
1161
1162 if (!$error && !$notrigger) {
1163 // Call trigger
1164 $result = $this->call_trigger('PROPOSAL_SUPPLIER_CREATE', $user);
1165 if ($result < 0) {
1166 $error++;
1167 }
1168 // End call triggers
1169 }
1170 } else {
1171 $this->error = $this->db->lasterror();
1172 $error++;
1173 }
1174 }
1175 } else {
1176 $this->error = $this->db->lasterror();
1177 $error++;
1178 }
1179
1180 if (!$error) {
1181 $this->db->commit();
1182 dol_syslog(get_class($this)."::create done id=".$this->id);
1183 return $this->id;
1184 } else {
1185 $this->db->rollback();
1186 return -2;
1187 }
1188 } else {
1189 $this->error = $this->db->lasterror();
1190 $this->db->rollback();
1191 return -1;
1192 }
1193 }
1194
1202 public function createFromClone(User $user, $fromid = 0)
1203 {
1204 global $conf, $hookmanager;
1205
1206 $error = 0;
1207 $now = dol_now();
1208
1209 $this->db->begin();
1210
1211 // get extrafields so they will be clone
1212 foreach ($this->lines as $line) {
1213 $line->fetch_optionals();
1214 }
1215
1216 // Load source object
1217 $objFrom = clone $this;
1218
1219 $objsoc = new Societe($this->db);
1220
1221 // Change socid if needed
1222 if (!empty($fromid) && $fromid != $this->socid) {
1223 if ($objsoc->fetch($fromid) > 0) {
1224 $this->socid = $objsoc->id;
1225 $this->cond_reglement_id = (!empty($objsoc->cond_reglement_id) ? $objsoc->cond_reglement_id : 0);
1226 $this->deposit_percent = (!empty($objsoc->deposit_percent) ? $objsoc->deposit_percent : 0);
1227 $this->mode_reglement_id = (!empty($objsoc->mode_reglement_id) ? $objsoc->mode_reglement_id : 0);
1228 unset($this->fk_project);
1229 }
1230
1231 // TODO Change product price if multi-prices
1232 } else {
1233 $objsoc->fetch($this->socid);
1234 }
1235
1236 $this->id = 0;
1237 $this->status = 0;
1238 $this->statut = 0;
1239
1240 if (!getDolGlobalString('SUPPLIER_PROPOSAL_ADDON') || !is_readable(DOL_DOCUMENT_ROOT."/core/modules/supplier_proposal/" . getDolGlobalString('SUPPLIER_PROPOSAL_ADDON').".php")) {
1241 $this->error = 'ErrorSetupNotComplete';
1242 return -1;
1243 }
1244
1245 // Clear fields
1246 $this->user_author_id = $user->id;
1247 $this->user_validation_id = 0;
1248 $this->date = $now;
1249
1250 // Set ref
1251 require_once DOL_DOCUMENT_ROOT."/core/modules/supplier_proposal/" . getDolGlobalString('SUPPLIER_PROPOSAL_ADDON').'.php';
1252 $obj = getDolGlobalString('SUPPLIER_PROPOSAL_ADDON');
1253 $modSupplierProposal = new $obj();
1254 '@phan-var-force ModeleNumRefSupplierProposal $modSupplierProposal';
1255 $this->ref = $modSupplierProposal->getNextValue($objsoc, $this);
1256
1257 // Create clone
1258 $this->context['createfromclone'] = 'createfromclone';
1259 $result = $this->create($user);
1260 if ($result < 0) {
1261 $error++;
1262 }
1263
1264 if (!$error) {
1265 // Hook of thirdparty module
1266 if (is_object($hookmanager)) {
1267 $parameters = array('objFrom' => $objFrom);
1268 $action = '';
1269 $reshook = $hookmanager->executeHooks('createFrom', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
1270 if ($reshook < 0) {
1271 $this->setErrorsFromObject($hookmanager);
1272 $error++;
1273 }
1274 }
1275 }
1276
1277 unset($this->context['createfromclone']);
1278
1279 // End
1280 if (!$error) {
1281 $this->db->commit();
1282 return $this->id;
1283 } else {
1284 $this->db->rollback();
1285 return -1;
1286 }
1287 }
1288
1296 public function fetch($rowid, $ref = '')
1297 {
1298 $sql = "SELECT p.rowid, p.entity, p.ref, p.fk_soc as socid";
1299 $sql .= ", p.total_ttc, p.total_tva, p.localtax1, p.localtax2, p.total_ht";
1300 $sql .= ", p.datec, GREATEST(p.tms, COALESCE(pef.tms, p.tms)) as date_modification";
1301 $sql .= ", p.date_valid as datev";
1302 $sql .= ", p.date_livraison as delivery_date";
1303 $sql .= ", p.model_pdf, p.extraparams";
1304 $sql .= ", p.note_private, p.note_public";
1305 $sql .= ", p.fk_projet as fk_project, p.fk_statut as status";
1306 $sql .= ", p.fk_user_author, p.fk_user_modif, p.fk_user_valid, p.fk_user_cloture";
1307 $sql .= ", p.fk_cond_reglement";
1308 $sql .= ", p.fk_mode_reglement";
1309 $sql .= ', p.fk_account';
1310 $sql .= ", p.fk_shipping_method";
1311 $sql .= ", p.last_main_doc";
1312 $sql .= ", p.fk_multicurrency, p.multicurrency_code, p.multicurrency_tx, p.multicurrency_total_ht, p.multicurrency_total_tva, p.multicurrency_total_ttc";
1313 $sql .= ", c.label as statut_label";
1314 $sql .= ", cr.code as cond_reglement_code, cr.libelle as cond_reglement, cr.libelle_facture as cond_reglement_libelle_doc, p.deposit_percent";
1315 $sql .= ", cp.code as mode_reglement_code, cp.libelle as mode_reglement";
1316 $sql .= " FROM ".MAIN_DB_PREFIX."c_propalst as c, ".MAIN_DB_PREFIX."supplier_proposal as p";
1317 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."supplier_proposal_extrafields as pef ON pef.fk_object=p.rowid";
1318 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_paiement as cp ON p.fk_mode_reglement = cp.id';
1319 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_payment_term as cr ON p.fk_cond_reglement = cr.rowid';
1320 $sql .= " WHERE p.fk_statut = c.id";
1321 $sql .= " AND p.entity IN (".getEntity('supplier_proposal').")";
1322 if ($ref) {
1323 $sql .= " AND p.ref = '".$this->db->escape($ref)."'";
1324 } else {
1325 $sql .= " AND p.rowid = ".((int) $rowid);
1326 }
1327
1328 dol_syslog(get_class($this)."::fetch", LOG_DEBUG);
1329 $resql = $this->db->query($sql);
1330 if ($resql) {
1331 if ($this->db->num_rows($resql)) {
1332 $obj = $this->db->fetch_object($resql);
1333
1334 $this->id = $obj->rowid;
1335 $this->entity = $obj->entity;
1336
1337 $this->ref = $obj->ref;
1338 $this->total_ht = $obj->total_ht;
1339 $this->total_tva = $obj->total_tva;
1340 $this->total_localtax1 = $obj->localtax1;
1341 $this->total_localtax2 = $obj->localtax2;
1342 $this->total_ttc = $obj->total_ttc;
1343 $this->socid = $obj->socid;
1344 $this->fk_project = $obj->fk_project;
1345 $this->model_pdf = $obj->model_pdf;
1346 $this->note = $obj->note_private; // TODO deprecated
1347 $this->note_private = $obj->note_private;
1348 $this->note_public = $obj->note_public;
1349 $this->statut = (int) $obj->status;
1350 $this->status = (int) $obj->status;
1351 $this->datec = $this->db->jdate($obj->datec); // TODO deprecated
1352 $this->datev = $this->db->jdate($obj->datev); // TODO deprecated
1353 $this->date_creation = $this->db->jdate($obj->datec); // Creation date
1354 $this->date_modification = $this->db->jdate($obj->date_modification); // Modification date
1355 $this->date = $this->date_creation;
1356 $this->date_validation = $this->db->jdate($obj->datev); // Validation date
1357 $this->delivery_date = $this->db->jdate($obj->delivery_date);
1358 $this->shipping_method_id = ($obj->fk_shipping_method > 0) ? $obj->fk_shipping_method : null;
1359
1360 $this->last_main_doc = $obj->last_main_doc;
1361 $this->mode_reglement_id = $obj->fk_mode_reglement;
1362 $this->mode_reglement_code = $obj->mode_reglement_code;
1363 $this->mode_reglement = $obj->mode_reglement;
1364 $this->deposit_percent = $obj->deposit_percent;
1365 $this->fk_account = ($obj->fk_account > 0) ? $obj->fk_account : null;
1366 $this->cond_reglement_id = $obj->fk_cond_reglement;
1367 $this->cond_reglement_code = $obj->cond_reglement_code;
1368 $this->cond_reglement = $obj->cond_reglement;
1369 $this->cond_reglement_label = $obj->cond_reglement;
1370 $this->cond_reglement_doc = $obj->cond_reglement_libelle_doc;
1371
1372 $this->extraparams = (array) (!empty($obj->extraparams) ? json_decode($obj->extraparams, true) : array());
1373
1374 $this->user_author_id = $obj->fk_user_author;
1375 $this->user_modification_id = $obj->fk_user_modif;
1376 $this->user_validation_id = $obj->fk_user_valid;
1377 $this->user_closing_id = $obj->fk_user_cloture;
1378
1379 // Multicurrency
1380 $this->fk_multicurrency = $obj->fk_multicurrency;
1381 $this->multicurrency_code = $obj->multicurrency_code;
1382 $this->multicurrency_tx = $obj->multicurrency_tx;
1383 $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
1384 $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
1385 $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
1386
1387 $this->db->free($resql);
1388
1389 // Retrieve all extrafield
1390 // fetch optionals attributes and labels
1391 $this->fetch_optionals();
1392
1393 $this->lines = array();
1394
1395 // Lines of supplier proposals
1396 $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,";
1397 $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,";
1398 $sql .= ' p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label,';
1399 $sql .= ' d.ref_fourn as ref_produit_fourn, d.extraparams,';
1400 $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';
1401 $sql .= " FROM ".MAIN_DB_PREFIX."supplier_proposaldet as d";
1402 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."product as p ON d.fk_product = p.rowid";
1403 $sql .= " WHERE d.fk_supplier_proposal = ".((int) $this->id);
1404 $sql .= " ORDER by d.rang";
1405
1406 $result = $this->db->query($sql);
1407 if ($result) {
1408 $num = $this->db->num_rows($result);
1409 $i = 0;
1410
1411 while ($i < $num) {
1412 $objp = $this->db->fetch_object($result);
1413
1414 $line = new SupplierProposalLine($this->db);
1415
1416 $line->rowid = $objp->rowid; // deprecated
1417 $line->id = $objp->rowid;
1418 $line->fk_supplier_proposal = $objp->fk_supplier_proposal;
1419 $line->fk_parent_line = $objp->fk_parent_line;
1420 $line->product_type = $objp->product_type;
1421 $line->label = $objp->custom_label;
1422 $line->desc = $objp->description; // Description ligne
1423 $line->qty = $objp->qty;
1424 $line->tva_tx = $objp->tva_tx;
1425 $line->localtax1_tx = $objp->localtax1_tx;
1426 $line->localtax2_tx = $objp->localtax2_tx;
1427 $line->subprice = $objp->subprice;
1428 $line->fk_remise_except = $objp->fk_remise_except;
1429 $line->remise_percent = $objp->remise_percent;
1430
1431 $line->info_bits = $objp->info_bits;
1432 $line->total_ht = $objp->total_ht;
1433 $line->total_tva = $objp->total_tva;
1434 $line->total_localtax1 = $objp->total_localtax1;
1435 $line->total_localtax2 = $objp->total_localtax2;
1436 $line->total_ttc = $objp->total_ttc;
1437 $line->fk_fournprice = $objp->fk_fournprice;
1438 $marginInfos = getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $line->fk_fournprice, $objp->pa_ht);
1439 $line->pa_ht = $marginInfos[0];
1440 $line->marge_tx = $marginInfos[1];
1441 $line->marque_tx = $marginInfos[2];
1442 $line->special_code = $objp->special_code;
1443 $line->rang = $objp->rang;
1444
1445 $line->fk_product = $objp->fk_product;
1446
1447 $line->ref = $objp->product_ref; // deprecated
1448 $line->product_ref = $objp->product_ref;
1449 $line->libelle = $objp->product_label; // deprecated
1450 $line->product_label = $objp->product_label;
1451 $line->product_desc = $objp->product_desc; // Description produit
1452 $line->fk_product_type = $objp->fk_product_type;
1453
1454 $line->ref_fourn = $objp->ref_produit_fourn;
1455
1456 $line->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams, true) : array();
1457
1458 // Multicurrency
1459 $line->fk_multicurrency = $objp->fk_multicurrency;
1460 $line->multicurrency_code = $objp->multicurrency_code;
1461 $line->multicurrency_subprice = $objp->multicurrency_subprice;
1462 $line->multicurrency_total_ht = $objp->multicurrency_total_ht;
1463 $line->multicurrency_total_tva = $objp->multicurrency_total_tva;
1464 $line->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
1465 $line->fk_unit = $objp->fk_unit;
1466
1467 $line->fetch_optionals();
1468
1469 $this->lines[$i] = $line;
1470
1471 $i++;
1472 }
1473 $this->db->free($result);
1474 } else {
1475 $this->error = $this->db->error();
1476 return -1;
1477 }
1478
1479 return 1;
1480 }
1481
1482 $this->error = "Record Not Found";
1483 return 0;
1484 } else {
1485 $this->error = $this->db->error();
1486 return -1;
1487 }
1488 }
1489
1497 public function update($user, $notrigger = 0)
1498 {
1499 $error = 0;
1500
1501 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal SET";
1502 $sql .= " fk_projet = ".($this->fk_project > 0 ? ((int) $this->fk_project) : "null");
1503 $sql .= ", fk_cond_reglement = ".($this->cond_reglement_id > 0 ? ((int) $this->cond_reglement_id) : "null");
1504 $sql .= ", fk_mode_reglement = ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) : "null");
1505 $sql .= ", fk_account = ".($this->fk_account > 0 ? ((int) $this->fk_account) : "null");
1506 $sql .= ", fk_shipping_method = ".($this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) : "null");
1507 $sql .= ", date_livraison = ".($this->delivery_date ? "'".$this->db->idate($this->delivery_date)."'" : "null");
1508 $sql .= ", note_private = ".(isset($this->note_private) ? "'".$this->db->escape($this->note_private)."'" : "null");
1509 $sql .= ", note_public = ".(isset($this->note_public) ? "'".$this->db->escape($this->note_public)."'" : "null");
1510 $sql .= ", model_pdf = ".(isset($this->model_pdf) ? "'".$this->db->escape($this->model_pdf)."'" : "null");
1511 $sql .= ", fk_user_modif = ".((int) $user->id);
1512 $sql .= " WHERE rowid = ".((int) $this->id);
1513
1514 $this->db->begin();
1515
1516 dol_syslog(get_class($this)."::update", LOG_DEBUG);
1517 $resql = $this->db->query($sql);
1518 if (!$resql) {
1519 $error++;
1520 $this->errors[] = "Error ".$this->db->lasterror();
1521 }
1522
1523 if (!$error) {
1524 $result = $this->insertExtraFields();
1525 if ($result < 0) {
1526 $error++;
1527 }
1528 }
1529
1530 if (!$error && !$notrigger) {
1531 // Call trigger
1532 $result = $this->call_trigger('PROPOSAL_SUPPLIER_MODIFY', $user);
1533 if ($result < 0) {
1534 $error++;
1535 }
1536 // End call triggers
1537 }
1538
1539 if ($error) {
1540 $this->error = implode(', ', $this->errors);
1541 $this->db->rollback();
1542 return -1 * $error;
1543 }
1544
1545 $this->db->commit();
1546 return 1;
1547 }
1548
1556 public function valid($user, $notrigger = 0)
1557 {
1558 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
1559
1560 global $conf, $langs;
1561
1562 $error = 0;
1563 $now = dol_now();
1564
1565 if ((!getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('supplier_proposal', 'creer'))
1566 || (getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('supplier_proposal', 'validate_advance'))) {
1567 $this->db->begin();
1568
1569 // Numbering module definition
1570 $soc = new Societe($this->db);
1571 $result = $soc->fetch($this->socid);
1572
1573 if ($result < 0) {
1574 return -1;
1575 }
1576 if (!getDolGlobalBool('SUPPLIER_PROPOSAL_NOCHECK_ONBUY_PRODUCTS_ONVALID') && !$this->checkActiveProductInLines('onbuy')) {
1577 dol_syslog(get_class($this)."::valid checkActiveProductInLines ".$this->error, LOG_INFO);
1578 return -1;
1579 }
1580 // Define new ref
1581 if (preg_match('/^[\‍(]?PROV/i', $this->ref) || empty($this->ref)) { // empty should not happened, but when it occurs, the test save life
1582 $num = $this->getNextNumRef($soc);
1583 } else {
1584 $num = (string) $this->ref;
1585 }
1586 $this->newref = dol_sanitizeFileName($num);
1587
1588 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal";
1589 $sql .= " SET ref = '".$this->db->escape($num)."',";
1590 $sql .= " fk_statut = 1, date_valid='".$this->db->idate($now)."', fk_user_valid=".((int) $user->id);
1591 $sql .= " WHERE rowid = ".((int) $this->id)." AND fk_statut = 0";
1592
1593 dol_syslog(get_class($this)."::valid", LOG_DEBUG);
1594 $resql = $this->db->query($sql);
1595 if (!$resql) {
1596 dol_print_error($this->db);
1597 $error++;
1598 }
1599
1600 // Trigger calls
1601 if (!$error && !$notrigger) {
1602 // Call trigger
1603 $result = $this->call_trigger('PROPOSAL_SUPPLIER_VALIDATE', $user);
1604 if ($result < 0) {
1605 $error++;
1606 }
1607 // End call triggers
1608 }
1609
1610 if (!$error) {
1611 $this->oldref = $this->ref;
1612
1613 // Rename directory if dir was a temporary ref
1614 if (preg_match('/^[\‍(]?PROV/i', $this->ref)) {
1615 // Now we rename also files into index
1616 $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)."'";
1617 $sql .= " WHERE filename LIKE '".$this->db->escape($this->ref)."%' AND filepath = 'supplier_proposal/".$this->db->escape($this->ref)."' and entity = ".$conf->entity;
1618 $resql = $this->db->query($sql);
1619 if (!$resql) {
1620 $error++;
1621 $this->error = $this->db->lasterror();
1622 }
1623 $sql = 'UPDATE '.MAIN_DB_PREFIX."ecm_files set filepath = 'supplier_proposal/".$this->db->escape($this->newref)."'";
1624 $sql .= " WHERE filepath = 'supplier_proposal/".$this->db->escape($this->ref)."' and entity = ".$conf->entity;
1625 $resql = $this->db->query($sql);
1626 if (!$resql) {
1627 $error++;
1628 $this->error = $this->db->lasterror();
1629 }
1630
1631 // We rename directory ($this->ref = old ref, $num = new ref) in order not to lose the attachments
1632 $oldref = dol_sanitizeFileName($this->ref);
1633 $newref = dol_sanitizeFileName($num);
1634 $dirsource = $conf->supplier_proposal->dir_output.'/'.$oldref;
1635 $dirdest = $conf->supplier_proposal->dir_output.'/'.$newref;
1636 if (!$error && file_exists($dirsource)) {
1637 dol_syslog(get_class($this)."::valid rename dir ".$dirsource." into ".$dirdest);
1638 if (@rename($dirsource, $dirdest)) {
1639 dol_syslog("Rename ok");
1640 // Rename docs starting with $oldref with $newref
1641 $listoffiles = dol_dir_list($conf->supplier_proposal->dir_output.'/'.$newref, 'files', 1, '^'.preg_quote($oldref, '/'));
1642 foreach ($listoffiles as $fileentry) {
1643 $dirsource = $fileentry['name'];
1644 $dirdest = preg_replace('/^'.preg_quote($oldref, '/').'/', $newref, $dirsource);
1645 $dirsource = $fileentry['path'].'/'.$dirsource;
1646 $dirdest = $fileentry['path'].'/'.$dirdest;
1647 @rename($dirsource, $dirdest);
1648 }
1649 }
1650 }
1651 }
1652
1653 $this->ref = $num;
1654 $this->statut = self::STATUS_VALIDATED;
1656 $this->user_validation_id = $user->id;
1657 $this->datev = $now;
1658 $this->date_validation = $now;
1659
1660 if (getDolGlobalString('SUPPLIER_PROPOSAL_AUTOADD_USER_CONTACT')) {
1661 $result = $this->add_contact($user->id, 'SALESREPFOLL', 'internal', 1);
1662 if ($result < 0 && $result != -2) { // -2 means already exists
1663 $error++;
1664 }
1665 }
1666
1667 $this->db->commit();
1668 return 1;
1669 } else {
1670 $this->db->rollback();
1671 return -1;
1672 }
1673 } else {
1674 dol_syslog("You don't have permission to validate supplier proposal", LOG_WARNING);
1675 return -2;
1676 }
1677 }
1678
1679 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1688 public function set_date_livraison($user, $delivery_date)
1689 {
1690 // phpcs:enable
1691 return $this->setDeliveryDate($user, $delivery_date);
1692 }
1693
1701 public function setDeliveryDate($user, $delivery_date)
1702 {
1703 if ($user->hasRight('supplier_proposal', 'creer')) {
1704 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal ";
1705 $sql .= " SET date_livraison = ".(isDolTms($delivery_date) ? "'".$this->db->idate($delivery_date)."'" : 'null');
1706 $sql .= " WHERE rowid = ".((int) $this->id);
1707
1708 if ($this->db->query($sql)) {
1709 $this->delivery_date = $delivery_date;
1710 return 1;
1711 } else {
1712 $this->error = $this->db->error();
1713 dol_syslog(get_class($this)."::setDeliveryDate Erreur SQL");
1714 return -1;
1715 }
1716 }
1717 return 0;
1718 }
1719
1720 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1728 /*
1729 public function set_remise_percent($user, $remise)
1730 {
1731 // phpcs:enable
1732 $remise = trim($remise) ?trim($remise) : 0;
1733
1734 if ($user->hasRight('supplier_proposal', 'creer')) {
1735 $remise = price2num($remise, 2);
1736
1737 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal SET remise_percent = ".((float) $remise);
1738 $sql .= " WHERE rowid = ".((int) $this->id)." AND fk_statut = 0";
1739
1740 if ($this->db->query($sql)) {
1741 $this->remise_percent = ((float) $remise);
1742 $this->update_price(1);
1743 return 1;
1744 } else {
1745 $this->error = $this->db->error();
1746 return -1;
1747 }
1748 }
1749 return 0;
1750 }
1751 */
1752
1753 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1761 /*
1762 public function set_remise_absolue($user, $remise)
1763 {
1764 // phpcs:enable
1765 if (empty($remise)) {
1766 $remise = 0;
1767 }
1768
1769 $remise = price2num($remise);
1770
1771 if ($user->hasRight('supplier_proposal', 'creer')) {
1772 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal ";
1773 $sql .= " SET remise_absolue = ".((float) $remise);
1774 $sql .= " WHERE rowid = ".((int) $this->id)." AND fk_statut = 0";
1775
1776 if ($this->db->query($sql)) {
1777 $this->remise_absolue = $remise;
1778 $this->update_price(1);
1779 return 1;
1780 } else {
1781 $this->error = $this->db->error();
1782 return -1;
1783 }
1784 }
1785 return 0;
1786 }
1787 */
1788
1789
1799 public function reopen($user, $status, $note = '', $notrigger = 0)
1800 {
1801 global $langs, $conf;
1802
1803 $error = 0;
1804
1805 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal";
1806 $sql .= " SET fk_statut = ".((int) $status).",";
1807 if (!empty($note)) {
1808 $sql .= " note_private = '".$this->db->escape($note)."',";
1809 }
1810 $sql .= " date_cloture = NULL, fk_user_cloture = NULL";
1811 $sql .= " WHERE rowid = ".((int) $this->id);
1812
1813 $this->db->begin();
1814
1815 dol_syslog(get_class($this)."::reopen", LOG_DEBUG);
1816 $resql = $this->db->query($sql);
1817 if (!$resql) {
1818 $error++;
1819 $this->errors[] = "Error ".$this->db->lasterror();
1820 }
1821 if (!$error) {
1822 if (!$notrigger) {
1823 // Call trigger
1824 $result = $this->call_trigger('PROPOSAL_SUPPLIER_REOPEN', $user);
1825 if ($result < 0) {
1826 $error++;
1827 }
1828 // End call triggers
1829 }
1830 }
1831
1832 // Commit or rollback
1833 if ($error) {
1834 if (!empty($this->errors)) {
1835 foreach ($this->errors as $errmsg) {
1836 dol_syslog(get_class($this)."::update ".$errmsg, LOG_ERR);
1837 $this->error .= ($this->error ? ', '.$errmsg : $errmsg);
1838 }
1839 }
1840 $this->db->rollback();
1841 return -1 * $error;
1842 } else {
1843 $this->statut = $status;
1844 $this->status = $status;
1845
1846 $this->db->commit();
1847 return 1;
1848 }
1849 }
1850
1851
1860 public function cloture($user, $status, $note)
1861 {
1862 global $langs, $conf;
1863 $hidedetails = 0;
1864 $hidedesc = 0;
1865 $hideref = 0;
1866
1867 $error = 0;
1868 $now = dol_now();
1869
1870 $this->db->begin();
1871
1872 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal";
1873 $sql .= " SET fk_statut = ".((int) $status).", note_private = '".$this->db->escape($note)."', date_cloture='".$this->db->idate($now)."', fk_user_cloture=".((int) $user->id);
1874 $sql .= " WHERE rowid = ".((int) $this->id);
1875
1876 $resql = $this->db->query($sql);
1877 if ($resql) {
1878 $this->statut = $status;
1879 $this->status = $status;
1880
1881 $modelpdf = getDolGlobalString('SUPPLIER_PROPOSAL_ADDON_PDF_ODT_CLOSED', (empty($this->model_pdf) ? '' : $this->model_pdf));
1882 $triggerName = 'PROPOSAL_SUPPLIER_CLOSE_REFUSED';
1883
1884 if ($status == 2) {
1885 $triggerName = 'PROPOSAL_SUPPLIER_CLOSE_SIGNED';
1886 $modelpdf = getDolGlobalString('SUPPLIER_PROPOSAL_ADDON_PDF_ODT_TOBILL', (empty($this->model_pdf) ? '' : $this->model_pdf));
1887
1888 if (getDolGlobalString('SUPPLIER_PROPOSAL_UPDATE_PRICE_ON_SUPPlIER_PROPOSAL')) { // TODO This option was not tested correctly. Error if product ref does not exists
1889 $result = $this->updateOrCreatePriceFournisseur($user);
1890 }
1891 }
1892 if ($status == 4) {
1893 $triggerName = 'PROPOSAL_SUPPLIER_CLASSIFY_BILLED';
1894 }
1895
1896 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
1897 // Define output language
1898 $outputlangs = $langs;
1899 if (getDolGlobalInt('MAIN_MULTILANGS')) {
1900 $outputlangs = new Translate("", $conf);
1901 $newlang = (GETPOST('lang_id', 'aZ09') ? GETPOST('lang_id', 'aZ09') : $this->thirdparty->default_lang);
1902 $outputlangs->setDefaultLang($newlang);
1903 }
1904
1905 $this->generateDocument($modelpdf, $outputlangs, $hidedetails, $hidedesc, $hideref);
1906 }
1907
1908 // Call trigger
1909 $result = $this->call_trigger($triggerName, $user);
1910 if ($result < 0) {
1911 $error++;
1912 }
1913 // End call triggers
1914
1915 if (!$error) {
1916 $this->db->commit();
1917 return 1;
1918 } else {
1919 $this->db->rollback();
1920 return -1;
1921 }
1922 } else {
1923 $this->error = $this->db->lasterror();
1924 $this->errors[] = $this->db->lasterror();
1925 $this->db->rollback();
1926 return -1;
1927 }
1928 }
1929
1936 public function updateOrCreatePriceFournisseur($user)
1937 {
1938 global $conf;
1939
1940 dol_syslog(get_class($this)."::updateOrCreatePriceFournisseur", LOG_DEBUG);
1941 foreach ($this->lines as $product) {
1942 if ($product->subprice <= 0) {
1943 continue;
1944 }
1945 $productsupplier = new ProductFournisseur($this->db);
1946
1947 $multicurrency_tx = 1;
1948 $fk_multicurrency = 0;
1949
1950 if (empty($this->thirdparty)) {
1951 $this->fetch_thirdparty();
1952 }
1953
1954 $ref_fourn = $product->ref_fourn;
1955 if (empty($ref_fourn)) {
1956 $ref_fourn = $product->ref_supplier;
1957 }
1958 if (isModEnabled("multicurrency") && !empty($product->multicurrency_code)) {
1959 list($fk_multicurrency, $multicurrency_tx) = MultiCurrency::getIdAndTxFromCode($this->db, $product->multicurrency_code);
1960 }
1961 $productsupplier->id = $product->fk_product;
1962
1963 $productsupplier->update_buyprice($product->qty, $product->total_ht, $user, 'HT', $this->thirdparty, 0, $ref_fourn, $product->tva_tx, 0, 0, 0, $product->info_bits, 0, '', array(), '', $product->multicurrency_total_ht, 'HT', $multicurrency_tx, $product->multicurrency_code, '', '', 0);
1964 }
1965
1966 return 1;
1967 }
1968
1977 public function updatePriceFournisseur($idProductFournPrice, $product, $user)
1978 {
1979 $price = price2num($product->subprice * $product->qty, 'MU');
1980 $unitPrice = price2num($product->subprice, 'MU');
1981
1982 $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);
1983
1984 $resql = $this->db->query($sql);
1985 if (!$resql) {
1986 $this->error = $this->db->error();
1987 $this->db->rollback();
1988 return -1;
1989 }
1990 return 1;
1991 }
1992
2000 public function createPriceFournisseur($product, $user)
2001 {
2002 global $conf;
2003
2004 $price = price2num($product->subprice * $product->qty, 'MU');
2005 $qty = price2num($product->qty);
2006 $unitPrice = price2num($product->subprice, 'MU');
2007
2008 $now = dol_now();
2009
2010 $values = array(
2011 "'".$this->db->idate($now)."'",
2012 (int) $product->fk_product,
2013 (int) $this->thirdparty->id,
2014 "'".$this->db->escape($product->ref_fourn)."'",
2015 (float) $price,
2016 (float) $qty,
2017 (float) $unitPrice,
2018 (float) $product->tva_tx,
2019 (int) $user->id
2020 );
2021 if (isModEnabled("multicurrency")) {
2022 if (!empty($product->multicurrency_code)) {
2023 include_once DOL_DOCUMENT_ROOT.'/multicurrency/class/multicurrency.class.php';
2024 $multicurrency = new MultiCurrency($this->db); //need to fetch because empty fk_multicurrency and rate
2025 $multicurrency->fetch(0, $product->multicurrency_code);
2026 if (!empty($multicurrency->id)) {
2027 $values[] = (int) $multicurrency->id;
2028 $values[] = "'".$this->db->escape($product->multicurrency_code)."'";
2029 $values[] = (float) $product->multicurrency_subprice;
2030 $values[] = (float) $product->multicurrency_total_ht;
2031 $values[] = (float) $multicurrency->rate->rate;
2032 } else {
2033 for ($i = 0; $i < 5; $i++) {
2034 $values[] = 'NULL';
2035 }
2036 }
2037 }
2038 }
2039
2040 $sql = 'INSERT INTO '.MAIN_DB_PREFIX.'product_fournisseur_price ';
2041 $sql .= '(datec, fk_product, fk_soc, ref_fourn, price, quantity, unitprice, tva_tx, fk_user';
2042 if (isModEnabled("multicurrency") && !empty($product->multicurrency_code)) {
2043 $sql .= ',fk_multicurrency, multicurrency_code, multicurrency_unitprice, multicurrency_price, multicurrency_tx';
2044 }
2045 $sql .= ') VALUES ('.implode(',', $values).')';
2046
2047 $resql = $this->db->query($sql);
2048 if (!$resql) {
2049 $this->error = $this->db->error();
2050 $this->db->rollback();
2051 return -1;
2052 }
2053 return 1;
2054 }
2055
2056 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2063 public function setDraft($user)
2064 {
2065 // phpcs:enable
2066 global $conf, $langs;
2067
2068 $error = 0;
2069
2070 if ($this->status == self::STATUS_DRAFT) {
2071 dol_syslog(get_class($this)."::setDraft already draft status", LOG_WARNING);
2072 return 0;
2073 }
2074
2075 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal";
2076 $sql .= " SET fk_statut = ".self::STATUS_DRAFT;
2077 $sql .= " WHERE rowid = ".((int) $this->id);
2078
2079 if ($this->db->query($sql)) {
2080 if (!$error) {
2081 $this->oldcopy = clone $this;
2082 }
2083
2084 if (!$error) {
2085 // Call trigger
2086 $result = $this->call_trigger('PROPOSAL_SUPPLIER_UNVALIDATE', $user);
2087 if ($result < 0) {
2088 $error++;
2089 }
2090 }
2091
2092 if (!$error) {
2093 $this->status = self::STATUS_DRAFT;
2094 $this->statut = self::STATUS_DRAFT; // deprecated
2095 $this->db->commit();
2096 return 1;
2097 } else {
2098 $this->db->rollback();
2099 return -1;
2100 }
2101 } else {
2102 return -1;
2103 }
2104 }
2105
2106
2107 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2121 public function liste_array($shortlist = 0, $draft = 0, $notcurrentuser = 0, $socid = 0, $limit = 0, $offset = 0, $sortfield = 'p.datec', $sortorder = 'DESC')
2122 {
2123 // phpcs:enable
2124 global $user;
2125
2126 $ga = array();
2127
2128 $search_sale = 0;
2129 if (empty($user->socid) && !$user->hasRight('societe', 'client', 'voir')) {
2130 $search_sale = $user->id;
2131 }
2132
2133 $sql = "SELECT s.rowid, s.nom as name, s.client,";
2134 $sql .= " p.rowid as supplier_proposalid, p.fk_statut, p.total_ht, p.ref, p.remise, ";
2135 $sql .= " p.datep as dp, p.fin_validite as datelimite";
2136 $sql .= " FROM ".MAIN_DB_PREFIX."societe as s, ".MAIN_DB_PREFIX."supplier_proposal as p, ".MAIN_DB_PREFIX."c_propalst as c";
2137 $sql .= " WHERE p.entity IN (".getEntity('supplier_proposal').")";
2138 $sql .= " AND p.fk_soc = s.rowid";
2139 $sql .= " AND p.fk_statut = c.id";
2140 if ($socid) {
2141 $sql .= " AND s.rowid = ".((int) $socid);
2142 }
2143 if ($draft) {
2144 $sql .= " AND p.fk_statut = 0";
2145 }
2146 if ($notcurrentuser > 0) {
2147 $sql .= " AND p.fk_user_author <> ".((int) $user->id);
2148 }
2149 // Search on sale representative
2150 if ($search_sale && $search_sale != '-1') {
2151 if ($search_sale == -2) {
2152 $sql .= " AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = p.fk_soc)";
2153 } elseif ($search_sale > 0) {
2154 $sql .= " AND EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = p.fk_soc AND sc.fk_user = ".((int) $search_sale).")";
2155 }
2156 }
2157 $sql .= $this->db->order($sortfield, $sortorder);
2158 $sql .= $this->db->plimit($limit, $offset);
2159
2160 $result = $this->db->query($sql);
2161 if ($result) {
2162 $num = $this->db->num_rows($result);
2163 if ($num) {
2164 $i = 0;
2165 while ($i < $num) {
2166 $obj = $this->db->fetch_object($result);
2167
2168 if ($shortlist == 1) {
2169 $ga[$obj->supplier_proposalid] = $obj->ref;
2170 } elseif ($shortlist == 2) {
2171 $ga[$obj->supplier_proposalid] = $obj->ref.' ('.$obj->name.')';
2172 } else {
2173 $ga[$i]['id'] = $obj->supplier_proposalid;
2174 $ga[$i]['ref'] = $obj->ref;
2175 $ga[$i]['name'] = $obj->name;
2176 }
2177
2178 $i++;
2179 }
2180 }
2181 return $ga;
2182 } else {
2183 dol_print_error($this->db);
2184 return -1;
2185 }
2186 }
2187
2195 public function delete($user, $notrigger = 0)
2196 {
2197 global $conf, $langs;
2198 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
2199
2200 $error = 0;
2201
2202 $this->db->begin();
2203
2204 if (!$notrigger) {
2205 // Call trigger
2206 $result = $this->call_trigger('PROPOSAL_SUPPLIER_DELETE', $user);
2207 if ($result < 0) {
2208 $error++;
2209 }
2210 // End call triggers
2211 }
2212
2213 // Remove linked categories.
2214 if (!$error) {
2215 $sql = "DELETE FROM ".MAIN_DB_PREFIX."categorie_supplier_proposal";
2216 $sql .= " WHERE fk_supplier_proposal = ".((int) $this->id);
2217
2218 $result = $this->db->query($sql);
2219 if (!$result) {
2220 $error++;
2221 $this->error = $this->db->lasterror();
2222 $this->errors[] = $this->error;
2223 }
2224 }
2225
2226 if (!$error) {
2227 $main = MAIN_DB_PREFIX.'supplier_proposaldet';
2228 $ef = $main."_extrafields";
2229 $sqlef = "DELETE FROM $ef WHERE fk_object IN (SELECT rowid FROM $main WHERE fk_supplier_proposal = ".((int) $this->id).")";
2230 $sql = "DELETE FROM ".MAIN_DB_PREFIX."supplier_proposaldet WHERE fk_supplier_proposal = ".((int) $this->id);
2231 if ($this->db->query($sql)) {
2232 $sql = "DELETE FROM ".MAIN_DB_PREFIX."supplier_proposal WHERE rowid = ".((int) $this->id);
2233 if ($this->db->query($sqlef) && $this->db->query($sql)) {
2234 // Delete linked object
2235 $res = $this->deleteObjectLinked();
2236 if ($res < 0) {
2237 $error++;
2238 }
2239
2240 if (!$error) {
2241 // Delete record into ECM index (Note that delete is also done when deleting files with the dol_delete_dir_recursive
2242 $this->deleteEcmFiles(0); // Deleting files physically is done later with the dol_delete_dir_recursive
2243 $this->deleteEcmFiles(1); // Deleting files physically is done later with the dol_delete_dir_recursive
2244
2245 // We remove directory
2246 $ref = dol_sanitizeFileName($this->ref);
2247 if ($conf->supplier_proposal->dir_output && !empty($this->ref)) {
2248 $dir = $conf->supplier_proposal->dir_output."/".$ref;
2249 $file = $dir."/".$ref.".pdf";
2250 if (file_exists($file)) {
2251 dol_delete_preview($this);
2252
2253 if (!dol_delete_file($file, 0, 0, 0, $this)) { // For triggers
2254 $this->error = 'ErrorFailToDeleteFile';
2255 $this->errors = array('ErrorFailToDeleteFile');
2256 $this->db->rollback();
2257 return 0;
2258 }
2259 }
2260 if (file_exists($dir)) {
2261 $res = @dol_delete_dir_recursive($dir);
2262 if (!$res) {
2263 $this->error = 'ErrorFailToDeleteDir';
2264 $this->errors = array('ErrorFailToDeleteDir');
2265 $this->db->rollback();
2266 return 0;
2267 }
2268 }
2269 }
2270 }
2271
2272 // Removed extrafields
2273 if (!$error) {
2274 $result = $this->deleteExtraFields();
2275 if ($result < 0) {
2276 $error++;
2277 $errorflag = -4;
2278 dol_syslog(get_class($this)."::delete erreur ".$errorflag." ".$this->error, LOG_ERR);
2279 }
2280 }
2281
2282 if (!$error) {
2283 dol_syslog(get_class($this)."::delete ".$this->id." by ".$user->id, LOG_DEBUG);
2284 $this->db->commit();
2285 return 1;
2286 } else {
2287 $this->error = $this->db->lasterror();
2288 $this->db->rollback();
2289 return 0;
2290 }
2291 } else {
2292 $this->error = $this->db->lasterror();
2293 $this->db->rollback();
2294 return -3;
2295 }
2296 } else {
2297 $this->error = $this->db->lasterror();
2298 $this->db->rollback();
2299 return -2;
2300 }
2301 } else {
2302 $this->db->rollback();
2303 return -1;
2304 }
2305 }
2306
2313 public function info($id)
2314 {
2315 $sql = "SELECT c.rowid, GREATEST(c.tms, COALESCE(cef.tms, c.tms)) as date_modification,";
2316 $sql .= " c.datec as date_creation, c.date_valid as date_validation, c.date_cloture as date_closure,";
2317 $sql .= " c.fk_user_author, c.fk_user_modif, c.fk_user_valid, c.fk_user_cloture";
2318 $sql .= " FROM ".MAIN_DB_PREFIX."supplier_proposal as c";
2319 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."supplier_proposal_extrafields as cef ON cef.fk_object=c.rowid";
2320 $sql .= " WHERE c.rowid = ".((int) $id);
2321
2322 $result = $this->db->query($sql);
2323
2324 if ($result) {
2325 if ($this->db->num_rows($result)) {
2326 $obj = $this->db->fetch_object($result);
2327
2328 $this->id = $obj->rowid;
2329
2330 $this->date_creation = $this->db->jdate($obj->date_creation);
2331 $this->date_modification = empty($obj->date_modification) ? '' : $this->db->jdate($obj->date_modification);
2332 $this->date_validation = $this->db->jdate($obj->date_validation);
2333 $this->date_cloture = $this->db->jdate($obj->date_closure);
2334
2335 $this->user_creation_id = $obj->fk_user_author;
2336 $this->user_modification_id = $obj->fk_user_modif;
2337 $this->user_validation_id = $obj->fk_user_valid;
2338 $this->user_closing_id = $obj->fk_user_cloture;
2339 }
2340 $this->db->free($result);
2341 } else {
2342 dol_print_error($this->db);
2343 }
2344 }
2345
2346
2353 public function getLibStatut($mode = 0)
2354 {
2355 return $this->LibStatut((isset($this->status) ? $this->status : $this->statut), $mode);
2356 }
2357
2358 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2366 public function LibStatut($status, $mode = 1)
2367 {
2368 // phpcs:enable
2369
2370 // Init/load array of translation of status
2371 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
2372 global $langs;
2373 $langs->load("supplier_proposal");
2374 $this->labelStatus[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv("SupplierProposalStatusDraft");
2375 $this->labelStatus[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv("SupplierProposalStatusValidated");
2376 $this->labelStatus[self::STATUS_SIGNED] = $langs->transnoentitiesnoconv("SupplierProposalStatusSigned");
2377 $this->labelStatus[self::STATUS_NOTSIGNED] = $langs->transnoentitiesnoconv("SupplierProposalStatusNotSigned");
2378 $this->labelStatus[self::STATUS_CLOSE] = $langs->transnoentitiesnoconv("SupplierProposalStatusClosed");
2379 $this->labelStatusShort[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv("SupplierProposalStatusDraftShort");
2380 $this->labelStatusShort[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv("SupplierProposalStatusValidatedShort");
2381 $this->labelStatusShort[self::STATUS_SIGNED] = $langs->transnoentitiesnoconv("SupplierProposalStatusSignedShort");
2382 $this->labelStatusShort[self::STATUS_NOTSIGNED] = $langs->transnoentitiesnoconv("SupplierProposalStatusNotSignedShort");
2383 $this->labelStatusShort[self::STATUS_CLOSE] = $langs->transnoentitiesnoconv("SupplierProposalStatusClosedShort");
2384 }
2385
2386 $statusnew = '';
2387 if ($status == self::STATUS_DRAFT) {
2388 $statusnew = 'status0';
2389 } elseif ($status == self::STATUS_VALIDATED) {
2390 $statusnew = 'status1';
2391 } elseif ($status == self::STATUS_SIGNED) {
2392 $statusnew = 'status4';
2393 } elseif ($status == self::STATUS_NOTSIGNED) {
2394 $statusnew = 'status9';
2395 } elseif ($status == self::STATUS_CLOSE) {
2396 $statusnew = 'status6';
2397 }
2398
2399 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status], '', $statusnew, $mode);
2400 }
2401
2402
2403 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2411 public function load_board($user, $mode)
2412 {
2413 // phpcs:enable
2414 global $conf, $langs;
2415
2416 $now = dol_now();
2417
2418 $clause = " WHERE";
2419
2420 $sql = "SELECT p.rowid, p.ref, p.datec as datec, p.date_cloture as datefin";
2421 $sql .= " FROM ".MAIN_DB_PREFIX."supplier_proposal as p";
2422 if (empty($user->socid) && !$user->hasRight('societe', 'client', 'voir')) {
2423 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON p.fk_soc = sc.fk_soc";
2424 $sql .= " WHERE sc.fk_user = ".((int) $user->id);
2425 $clause = " AND";
2426 }
2427 $sql .= $clause." p.entity IN (".getEntity('supplier_proposal').")";
2428 if ($mode == 'opened') {
2429 $sql .= " AND p.fk_statut = 1";
2430 }
2431 if ($mode == 'signed') {
2432 $sql .= " AND p.fk_statut = 2";
2433 }
2434 if ($user->socid) {
2435 $sql .= " AND p.fk_soc = ".((int) $user->socid);
2436 }
2437
2438 $resql = $this->db->query($sql);
2439 if ($resql) {
2440 $label = $labelShort = '';
2441 $status = '';
2442 $delay_warning = 0;
2443 if ($mode == 'opened') {
2444 $delay_warning = !empty($conf->supplier_proposal->cloture->warning_delay) ? $conf->supplier_proposal->cloture->warning_delay : 0;
2445 $status = self::STATUS_VALIDATED;
2446 $label = $langs->trans("SupplierProposalsToClose");
2447 $labelShort = $langs->trans("ToAcceptRefuse");
2448 }
2449 if ($mode == 'signed') {
2450 $delay_warning = !empty($conf->supplier_proposal->facturation->warning_delay) ? $conf->supplier_proposal->facturation->warning_delay : 0;
2451 $status = self::STATUS_SIGNED;
2452 $label = $langs->trans("SupplierProposalsToProcess"); // May be billed or ordered
2453 $labelShort = $langs->trans("ToClose");
2454 }
2455
2456 $response = new WorkboardResponse();
2457 $response->warning_delay = $delay_warning / 60 / 60 / 24;
2458 $response->label = $label;
2459 $response->labelShort = $labelShort;
2460 $response->url = DOL_URL_ROOT.'/supplier_proposal/list.php?search_status='.$status;
2461 $response->img = img_object('', "propal");
2462
2463 // This assignment in condition is not a bug. It allows walking the results.
2464 while ($obj = $this->db->fetch_object($resql)) {
2465 $response->nbtodo++;
2466 if ($mode == 'opened') {
2467 $datelimit = $this->db->jdate($obj->datefin);
2468 if ($datelimit < ($now - $delay_warning)) {
2469 $response->nbtodolate++;
2470 }
2471 }
2472 // TODO Definir regle des propales a facturer en retard
2473 // if ($mode == 'signed' && ! count($this->FactureListeArray($obj->rowid))) $this->nbtodolate++;
2474 }
2475 return $response;
2476 } else {
2477 $this->error = $this->db->lasterror();
2478 return -1;
2479 }
2480 }
2481
2482
2491 public function initAsSpecimen($param = array())
2492 {
2493 global $conf, $langs;
2494
2495 // Load array of products prodids
2496 $num_prods = 0;
2497 $prodids = array();
2498 $sql = "SELECT rowid";
2499 $sql .= " FROM ".MAIN_DB_PREFIX."product";
2500 $sql .= " WHERE entity IN (".getEntity('product').")";
2501 if (array_key_exists('tobuy', $param)) {
2502 $sql .= " AND tobuy = ".((int) $param['tobuy']);
2503 }
2504 $sql .= $this->db->plimit(100);
2505
2506 $resql = $this->db->query($sql);
2507 if ($resql) {
2508 $num_prods = $this->db->num_rows($resql);
2509 $i = 0;
2510 while ($i < $num_prods) {
2511 $i++;
2512 $row = $this->db->fetch_row($resql);
2513 $prodids[$i] = $row[0];
2514 }
2515 }
2516
2517 // Initialise parameters
2518 $this->id = 0;
2519 $this->ref = 'SPECIMEN';
2520 $this->ref_supplier = 'NEMICEPS';
2521 $this->specimen = 1;
2522 $this->socid = 1;
2523 $this->date = time();
2524 $this->cond_reglement_id = 1;
2525 $this->cond_reglement_code = 'RECEP';
2526 $this->mode_reglement_id = 7;
2527 $this->mode_reglement_code = 'CHQ';
2528 $this->note_public = 'This is a comment (public)';
2529 $this->note_private = 'This is a comment (private)';
2530
2531 $this->multicurrency_tx = 1;
2532 $this->multicurrency_code = getDolCurrency();
2533
2534 // Lines
2535 $nbp = min(1000, GETPOSTINT('nblines') ? GETPOSTINT('nblines') : 5); // We can force the nb of lines to test from command line (but not more than 1000)
2536 $xnbp = 0;
2537 while ($xnbp < $nbp) {
2538 $line = new SupplierProposalLine($this->db);
2539 $line->desc = $langs->trans("Description")." ".$xnbp;
2540 $line->qty = 1;
2541 $line->subprice = 100;
2542 $line->tva_tx = 19.6;
2543 $line->localtax1_tx = 0;
2544 $line->localtax2_tx = 0;
2545 if ($xnbp == 2) {
2546 $line->total_ht = 50;
2547 $line->total_ttc = 59.8;
2548 $line->total_tva = 9.8;
2549 $line->remise_percent = 50;
2550 } else {
2551 $line->total_ht = 100;
2552 $line->total_ttc = 119.6;
2553 $line->total_tva = 19.6;
2554 $line->remise_percent = 00;
2555 }
2556
2557 if ($num_prods > 0) {
2558 $prodid = mt_rand(1, $num_prods);
2559 $line->fk_product = $prodids[$prodid];
2560 }
2561
2562 $this->lines[$xnbp] = $line;
2563
2564 $this->total_ht += $line->total_ht;
2565 $this->total_tva += $line->total_tva;
2566 $this->total_ttc += $line->total_ttc;
2567
2568 $xnbp++;
2569 }
2570
2571 return 1;
2572 }
2573
2579 public function loadStateBoard()
2580 {
2581 global $user;
2582
2583 $this->nb = array();
2584 $clause = "WHERE";
2585
2586 $sql = "SELECT count(p.rowid) as nb";
2587 $sql .= " FROM ".MAIN_DB_PREFIX."supplier_proposal as p";
2588 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s ON p.fk_soc = s.rowid";
2589 if (empty($user->socid) && !$user->hasRight('societe', 'client', 'voir')) {
2590 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON s.rowid = sc.fk_soc";
2591 $sql .= " WHERE sc.fk_user = ".((int) $user->id);
2592 $clause = "AND";
2593 }
2594 $sql .= " ".$clause." p.entity IN (".getEntity('supplier_proposal').")";
2595
2596 $resql = $this->db->query($sql);
2597 if ($resql) {
2598 // This assignment in condition is not a bug. It allows walking the results.
2599 while ($obj = $this->db->fetch_object($resql)) {
2600 $this->nb["supplier_proposals"] = $obj->nb;
2601 }
2602 $this->db->free($resql);
2603 return 1;
2604 } else {
2605 dol_print_error($this->db);
2606 $this->error = $this->db->lasterror();
2607 return -1;
2608 }
2609 }
2610
2611
2619 public function getNextNumRef($soc)
2620 {
2621 global $conf, $db, $langs;
2622 $langs->load("supplier_proposal");
2623
2624 if (getDolGlobalString('SUPPLIER_PROPOSAL_ADDON')) {
2625 $mybool = false;
2626
2627 $file = getDolGlobalString('SUPPLIER_PROPOSAL_ADDON') . ".php";
2628 $classname = getDolGlobalString('SUPPLIER_PROPOSAL_ADDON');
2629
2630 // Include file with class
2631 $dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
2632 foreach ($dirmodels as $reldir) {
2633 $dir = dol_buildpath($reldir."core/modules/supplier_proposal/");
2634
2635 // Load file with numbering class (if found)
2636 $mybool = ((bool) @include_once $dir.$file) || $mybool;
2637 }
2638
2639 if (!$mybool) {
2640 dol_print_error(null, "Failed to include file ".$file);
2641 return '';
2642 }
2643
2644 $obj = new $classname();
2645 '@phan-var-force ModeleNumRefSupplierProposal $obj';
2647 $numref = "";
2648 $numref = $obj->getNextValue($soc, $this);
2649
2650 if ($numref != "") {
2651 return $numref;
2652 } else {
2653 $this->error = $obj->error;
2654 return "";
2655 }
2656 } else {
2657 $langs->load("errors");
2658 print $langs->trans("Error")." ".$langs->trans("ErrorModuleSetupNotComplete", $langs->transnoentitiesnoconv("SupplierProposal"));
2659 return "";
2660 }
2661 }
2662
2669 public function getTooltipContentArray($params)
2670 {
2671 global $conf, $langs;
2672
2673 $langs->load('supplier_proposal');
2674
2675 if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
2676 return ['optimize' => $langs->trans("ShowSupplierProposal")];
2677 }
2678
2679 //$option = $params['option'] ?? '';
2680 $datas = [];
2681
2682 $datas['picto'] = img_picto('', $this->picto).' <u class="paddingrightonly">'.$langs->trans("SupplierProposal").'</u>';
2683 if (isset($this->status)) {
2684 $datas['picto'] .= ' '.$this->getLibStatut(5);
2685 }
2686 if (!empty($this->ref)) {
2687 $datas['ref'] = '<br><b>'.$langs->trans('Ref').':</b> '.$this->ref;
2688 }
2689 if (!empty($this->ref_fourn)) {
2690 $datas['ref_supplier'] = '<br><b>'.$langs->trans('RefSupplier').':</b> '.$this->ref_fourn;
2691 }
2692 if (!empty($this->total_ht)) {
2693 $datas['amount_ht'] = '<br><b>'.$langs->trans('AmountHT').':</b> '.price($this->total_ht, 0, $langs, 0, -1, -1, getDolCurrency());
2694 }
2695 if (!empty($this->total_tva)) {
2696 $datas['amount_vat'] = '<br><b>'.$langs->trans('VAT').':</b> '.price($this->total_tva, 0, $langs, 0, -1, -1, getDolCurrency());
2697 }
2698 if (!empty($this->total_ttc)) {
2699 $datas['amount_ttc'] = '<br><b>'.$langs->trans('AmountTTC').':</b> '.price($this->total_ttc, 0, $langs, 0, -1, -1, getDolCurrency());
2700 }
2701
2702 return $datas;
2703 }
2704
2716 public function getNomUrl($withpicto = 0, $option = '', $get_params = '', $notooltip = 0, $save_lastsearch_value = -1, $addlinktonotes = 0)
2717 {
2718 global $langs, $conf, $user, $hookmanager;
2719
2720 if (!empty($conf->dol_no_mouse_hover)) {
2721 $notooltip = 1; // Force disable tooltips
2722 }
2723
2724 $url = '';
2725 $result = '';
2726 $params = [
2727 'id' => $this->id,
2728 'objecttype' => $this->element,
2729 'option' => $option,
2730 ];
2731 $classfortooltip = 'classfortooltip';
2732 $dataparams = '';
2733 if (getDolGlobalInt('MAIN_ENABLE_AJAX_TOOLTIP')) {
2734 $classfortooltip = 'classforajaxtooltip';
2735 $dataparams = ' data-params="'.dol_escape_htmltag(json_encode($params)).'"';
2736 $label = '';
2737 } else {
2738 $label = implode($this->getTooltipContentArray($params));
2739 }
2740
2741 if ($option == '') {
2742 $url = DOL_URL_ROOT.'/supplier_proposal/card.php?id='.$this->id.$get_params;
2743 }
2744 if ($option == 'document') {
2745 $url = DOL_URL_ROOT.'/supplier_proposal/document.php?id='.$this->id.$get_params;
2746 }
2747
2748 if ($option !== 'nolink') {
2749 // Add param to save lastsearch_values or not
2750 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
2751 if ($save_lastsearch_value == -1 && isset($_SERVER["PHP_SELF"]) && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
2752 $add_save_lastsearch_values = 1;
2753 }
2754 if ($add_save_lastsearch_values) {
2755 $url .= '&save_lastsearch_values=1';
2756 }
2757 }
2758
2759 $linkclose = '';
2760 if (empty($notooltip) && $user->hasRight('propal', 'lire')) {
2761 if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
2762 $label = $langs->trans("ShowSupplierProposal");
2763 $linkclose .= ' alt="'.dolPrintHTMLForAttribute($label).'"';
2764 }
2765 $linkclose .= ($label ? ' title="'.dolPrintHTMLForAttribute($label).'"' : ' title="tocomplete"');
2766 $linkclose .= $dataparams.' class="'.$classfortooltip.'"';
2767 }
2768
2769 $linkstart = '<a href="'.$url.'"';
2770 $linkstart .= $linkclose.'>';
2771 $linkend = '</a>';
2772
2773 $result .= $linkstart;
2774 if ($withpicto) {
2775 $result .= img_object(($notooltip ? '' : $label), ($this->picto ? $this->picto : 'generic'), (($withpicto != 2) ? 'class="paddingright"' : ''), 0, 0, $notooltip ? 0 : 1);
2776 }
2777 if ($withpicto != 2) {
2778 $result .= $this->ref;
2779 }
2780 $result .= $linkend;
2781
2782 if ($addlinktonotes) {
2783 $txttoshow = ($user->socid > 0 ? $this->note_public : $this->note_private);
2784 if ($txttoshow) {
2785 $notetoshow = $langs->trans("ViewPrivateNote").':<br>'.dol_string_nohtmltag($txttoshow, 1);
2786 $result .= ' <span class="note inline-block">';
2787 $result .= '<a href="'.DOL_URL_ROOT.'/supplier_proposal/note.php?id='.$this->id.'" class="classfortooltip" title="'.dol_escape_htmltag($notetoshow).'">';
2788 $result .= img_picto('', 'note');
2789 $result .= '</a>';
2790 //$result.=img_picto($langs->trans("ViewNote"),'object_generic');
2791 //$result.='</a>';
2792 $result .= '</span>';
2793 }
2794 }
2795 global $action;
2796 $hookmanager->initHooks(array($this->element . 'dao'));
2797 $parameters = array('id' => $this->id, 'getnomurl' => &$result);
2798 $reshook = $hookmanager->executeHooks('getNomUrl', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
2799 if ($reshook > 0) {
2800 $result = $hookmanager->resPrint;
2801 } else {
2802 $result .= $hookmanager->resPrint;
2803 }
2804 return $result;
2805 }
2806
2812 public function getLinesArray()
2813 {
2814 // For other object, here we call fetch_lines. But fetch_lines does not exists on supplier proposal
2815
2816 $sql = 'SELECT pt.rowid, pt.label as custom_label, pt.description, pt.fk_product, pt.fk_remise_except,';
2817 $sql .= ' pt.qty, pt.tva_tx, pt.vat_src_code, pt.remise_percent, pt.subprice, pt.info_bits,';
2818 $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,';
2819 $sql .= ' pt.product_type, pt.rang, pt.fk_parent_line, pt.extraparams,';
2820 $sql .= ' p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid,';
2821 $sql .= ' p.description as product_desc, pt.ref_fourn as ref_supplier,';
2822 $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';
2823 $sql .= ' FROM '.MAIN_DB_PREFIX.'supplier_proposaldet as pt';
2824 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product as p ON pt.fk_product=p.rowid';
2825 $sql .= ' WHERE pt.fk_supplier_proposal = '.((int) $this->id);
2826 $sql .= ' ORDER BY pt.rang ASC, pt.rowid';
2827
2828 dol_syslog(get_class($this).'::getLinesArray', LOG_DEBUG);
2829 $resql = $this->db->query($sql);
2830 if ($resql) {
2831 $num = $this->db->num_rows($resql);
2832 $i = 0;
2833
2834 while ($i < $num) {
2835 $obj = $this->db->fetch_object($resql);
2836
2837 $this->lines[$i] = new SupplierProposalLine($this->db);
2838 $this->lines[$i]->id = $obj->rowid; // for backward compatibility
2839 $this->lines[$i]->rowid = $obj->rowid;
2840
2841 $this->lines[$i]->label = $obj->custom_label;
2842 $this->lines[$i]->description = $obj->description; // deprecated
2843 $this->lines[$i]->desc = $obj->description;
2844
2845 $this->lines[$i]->fk_product = $obj->fk_product;
2846 $this->lines[$i]->ref = $obj->ref;
2847 $this->lines[$i]->product_label = $obj->product_label;
2848 $this->lines[$i]->product_desc = $obj->product_desc;
2849 $this->lines[$i]->fk_product_type = $obj->fk_product_type; // deprecated
2850 $this->lines[$i]->product_type = $obj->product_type;
2851 $this->lines[$i]->qty = $obj->qty;
2852 $this->lines[$i]->subprice = $obj->subprice;
2853 $this->lines[$i]->fk_remise_except = $obj->fk_remise_except;
2854 $this->lines[$i]->remise_percent = $obj->remise_percent;
2855 $this->lines[$i]->tva_tx = $obj->tva_tx;
2856 $this->lines[$i]->vat_src_code = $obj->vat_src_code;
2857 $this->lines[$i]->info_bits = $obj->info_bits;
2858 $this->lines[$i]->total_ht = $obj->total_ht;
2859 $this->lines[$i]->total_tva = $obj->total_tva;
2860 $this->lines[$i]->total_ttc = $obj->total_ttc;
2861 $this->lines[$i]->fk_fournprice = $obj->fk_fournprice;
2862 $marginInfos = getMarginInfos($obj->subprice, $obj->remise_percent, $obj->tva_tx, $obj->localtax1_tx, $obj->localtax2_tx, $this->lines[$i]->fk_fournprice, $obj->pa_ht);
2863 $this->lines[$i]->pa_ht = $marginInfos[0];
2864 $this->lines[$i]->marge_tx = $marginInfos[1];
2865 $this->lines[$i]->marque_tx = $marginInfos[2];
2866 $this->lines[$i]->fk_parent_line = $obj->fk_parent_line;
2867 $this->lines[$i]->special_code = $obj->special_code;
2868 $this->lines[$i]->rang = $obj->rang;
2869
2870 $this->lines[$i]->ref_fourn = $obj->ref_supplier; // deprecated
2871 $this->lines[$i]->ref_supplier = $obj->ref_supplier;
2872
2873 // Multicurrency
2874 $this->lines[$i]->fk_multicurrency = $obj->fk_multicurrency;
2875 $this->lines[$i]->multicurrency_code = $obj->multicurrency_code;
2876 $this->lines[$i]->multicurrency_subprice = $obj->multicurrency_subprice;
2877 $this->lines[$i]->multicurrency_total_ht = $obj->multicurrency_total_ht;
2878 $this->lines[$i]->multicurrency_total_tva = $obj->multicurrency_total_tva;
2879 $this->lines[$i]->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
2880 $this->lines[$i]->fk_unit = $obj->fk_unit;
2881 $this->lines[$i]->extraparams = !empty($obj->extraparams) ? (array) json_decode($obj->extraparams, true) : array();
2882
2883 $this->lines[$i]->fetch_optionals();
2884
2885 $i++;
2886 }
2887 $this->db->free($resql);
2888
2889 return 1;
2890 } else {
2891 $this->error = $this->db->error();
2892 return -1;
2893 }
2894 }
2895
2907 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams = null)
2908 {
2909 global $langs;
2910
2911 $langs->load("supplier_proposal");
2912 $outputlangs->load("products");
2913
2914 if (!dol_strlen($modele)) {
2915 $modele = ''; // On supplier documents, template can be empty( no doc generated in this case)
2916
2917 if ($this->model_pdf) {
2918 $modele = $this->model_pdf;
2919 } elseif (getDolGlobalString('SUPPLIER_PROPOSAL_ADDON_PDF')) {
2920 $modele = getDolGlobalString('SUPPLIER_PROPOSAL_ADDON_PDF');
2921 }
2922 }
2923
2924 if (empty($modele)) {
2925 return 1;
2926 }
2927
2928 $modelpath = "core/modules/supplier_proposal/doc/";
2929
2930 return $this->commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
2931 }
2932
2933
2942 public static function replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
2943 {
2944 $tables = array(
2945 'supplier_proposal'
2946 );
2947
2948 return CommonObject::commonReplaceThirdparty($dbs, $origin_id, $dest_id, $tables);
2949 }
2950
2959 public static function replaceProduct(DoliDB $db, $origin_id, $dest_id)
2960 {
2961 $tables = array(
2962 'supplier_proposaldet'
2963 );
2964
2965 return CommonObject::commonReplaceProduct($db, $origin_id, $dest_id, $tables);
2966 }
2967
2968
2976 public function getKanbanView($option = '', $arraydata = null)
2977 {
2978 global $langs;
2979
2980 $selected = (empty($arraydata['selected']) ? 0 : $arraydata['selected']);
2981
2982 $return = '<div class="box-flex-item box-flex-grow-zero">';
2983 $return .= '<div class="info-box info-box-sm">';
2984 $return .= '<span class="info-box-icon bg-infobox-action">';
2985 $return .= img_picto('', $this->picto);
2986 //$return .= '<i class="fa fa-dol-action"></i>'; // Can be image
2987 $return .= '</span>';
2988 $return .= '<div class="info-box-content">';
2989 $return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this, 'getNomUrl') ? $this->getNomUrl() : $this->ref).'</span>';
2990 if ($selected >= 0) {
2991 $return .= '<input id="cb'.$this->id.'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->id.'"'.($selected ? ' checked="checked"' : '').'>';
2992 }
2993 if (property_exists($this, 'socid')) {
2994 $return .= '<span class="info-box-ref"> | '.$this->socid.'</span>';
2995 }
2996 if (property_exists($this, 'delivery_date')) {
2997 $return .= '<br><span class="opacitymedium">'.$langs->trans("DateEnd").'</span> : <span class="info-box-label">'.dol_print_date($this->delivery_date).'</span>';
2998 }
2999 if (property_exists($this, 'total_ttc')) {
3000 $return .= '<br><span class="opacitymedium" >'.$langs->trans("AmountHT").' : </span><span class="info-box-label amount">'.price($this->total_ttc).'</span>';
3001 }
3002 if (method_exists($this, 'getLibStatut')) {
3003 $return .= '<br><div class="info-box-status">'.$this->getLibStatut(3).'</div>';
3004 }
3005 $return .= '</div>';
3006 $return .= '</div>';
3007 $return .= '</div>';
3008 return $return;
3009 }
3010
3021 public function setCategories($categories)
3022 {
3023 require_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
3024 return parent::setCategoriesCommon($categories, Categorie::TYPE_SUPPLIER_PROPOSAL);
3025 }
3026}
3027
3028
3033{
3037 public $db;
3038
3042 public $error = '';
3043
3047 public $element = 'supplier_proposaldet';
3048
3052 public $table_element = 'supplier_proposaldet';
3053
3057 public $parent_element = 'supplier_proposal';
3058
3062 public $fk_parent_attribute = 'fk_supplier_proposal';
3063
3067 public $oldline;
3068
3072 public $id;
3073
3077 public $fk_supplier_proposal;
3078
3082 public $fk_parent_line;
3083
3087 public $desc; // Description ligne
3088
3092 public $fk_product; // Id produit predefini
3093
3099 public $fk_product_type;
3105 public $product_type = Product::TYPE_PRODUCT;
3106
3110 public $qty;
3114 public $tva_tx;
3118 public $vat_src_code;
3119
3123 public $remise_percent;
3124
3128 public $fk_remise_except;
3129
3133 public $rang = 0;
3134
3138 public $fk_fournprice;
3139
3143 public $pa_ht;
3147 public $marge_tx;
3151 public $marque_tx;
3152
3156 public $special_code; // Tag for special lines (exclusive tags)
3157 // 1: frais de port
3158 // 2: ecotaxe
3159 // 3: option line (when qty = 0)
3160
3164 public $info_bits = 0; // Liste d'options cumulables:
3165 // Bit 0: 0 si TVA normal - 1 if TVA NPR
3166 // Bit 1: 0 ligne normal - 1 if fixed reduction
3167
3171 public $total_ht; // Total HT de la ligne toute quantite et incluant la remise ligne
3175 public $total_tva; // Total TVA de la ligne toute quantite et incluant la remise ligne
3179 public $total_ttc; // Total TTC de la ligne toute quantite et incluant la remise ligne
3180
3184 public $date_start;
3188 public $date_end;
3189
3190 // From llx_product
3196 public $ref;
3197
3202 public $product_ref;
3203
3209 public $libelle;
3210
3215 public $product_label;
3216
3221 public $label;
3222
3227 public $product_desc;
3228
3232 public $localtax1_tx; // Local tax 1
3236 public $localtax2_tx; // Local tax 2
3240 public $localtax1_type; // Local tax 1 type
3244 public $localtax2_type; // Local tax 2 type
3248 public $total_localtax1; // Line total local tax 1
3252 public $total_localtax2; // Line total local tax 2
3253
3257 public $skip_update_total; // Skip update price total for special lines
3258
3262 public $ref_fourn;
3266 public $ref_supplier;
3267
3268 // Multicurrency
3272 public $fk_multicurrency;
3273
3277 public $multicurrency_code;
3281 public $multicurrency_subprice;
3285 public $multicurrency_total_ht;
3289 public $multicurrency_total_tva;
3293 public $multicurrency_total_ttc;
3294
3300 public function __construct($db)
3301 {
3302 $this->db = $db;
3303 }
3304
3311 public function fetch($rowid)
3312 {
3313 $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,';
3314 $sql .= ' pd.date_start, pd.date_end,';
3315 $sql .= ' pd.remise, pd.remise_percent, pd.fk_remise_except, pd.subprice, pd.subprice_ttc,';
3316 $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,';
3317 $sql .= ' pd.localtax1_tx, pd.localtax2_tx, pd.total_localtax1, pd.total_localtax2,';
3318 $sql .= ' p.ref as product_ref, p.label as product_label, p.description as product_desc,';
3319 $sql .= ' pd.product_type, pd.ref_fourn as ref_produit_fourn, pd.extraparams,';
3320 $sql .= ' pd.fk_multicurrency, pd.multicurrency_code, pd.multicurrency_subprice, pd.multicurrency_subprice_ttc, pd.multicurrency_total_ht, pd.multicurrency_total_tva, pd.multicurrency_total_ttc, pd.fk_unit';
3321 $sql .= ' FROM '.MAIN_DB_PREFIX.'supplier_proposaldet as pd';
3322 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product as p ON pd.fk_product = p.rowid';
3323 $sql .= ' WHERE pd.rowid = '.((int) $rowid);
3324
3325 $result = $this->db->query($sql);
3326 if ($result) {
3327 if ($objp = $this->db->fetch_object($result)) {
3328 $this->id = $objp->rowid;
3329 $this->fk_supplier_proposal = $objp->fk_supplier_proposal;
3330 $this->fk_parent_line = $objp->fk_parent_line;
3331 $this->label = $objp->custom_label;
3332 $this->desc = $objp->description;
3333 $this->qty = $objp->qty;
3334
3335 $this->subprice = $objp->subprice;
3336 $this->subprice_ttc = $objp->subprice_ttc;
3337
3338 $this->tva_tx = $objp->tva_tx;
3339 $this->remise_percent = $objp->remise_percent;
3340 $this->fk_remise_except = $objp->fk_remise_except;
3341 $this->fk_product = $objp->fk_product;
3342 $this->info_bits = $objp->info_bits;
3343 $this->date_start = $this->db->jdate($objp->date_start);
3344 $this->date_end = $this->db->jdate($objp->date_end);
3345
3346 $this->total_ht = $objp->total_ht;
3347 $this->total_tva = $objp->total_tva;
3348 $this->total_ttc = $objp->total_ttc;
3349
3350 $this->fk_fournprice = $objp->fk_fournprice;
3351
3352 $marginInfos = getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $this->fk_fournprice, $objp->pa_ht);
3353 $this->pa_ht = $marginInfos[0];
3354 $this->marge_tx = $marginInfos[1];
3355 $this->marque_tx = $marginInfos[2];
3356
3357 $this->special_code = $objp->special_code;
3358 $this->product_type = $objp->product_type;
3359 $this->rang = $objp->rang;
3360
3361 $this->product_ref = $objp->product_ref;
3362 $this->product_label = $objp->product_label;
3363 $this->product_desc = $objp->product_desc;
3364
3365 $this->ref_fourn = $objp->ref_produit_fourn;
3366
3367 $this->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams, true) : array();
3368
3369 // Multicurrency
3370 $this->fk_multicurrency = $objp->fk_multicurrency;
3371 $this->multicurrency_code = $objp->multicurrency_code;
3372 $this->multicurrency_subprice = $objp->multicurrency_subprice;
3373 $this->multicurrency_subprice_ttc = $objp->multicurrency_subprice_ttc;
3374 $this->multicurrency_total_ht = $objp->multicurrency_total_ht;
3375 $this->multicurrency_total_tva = $objp->multicurrency_total_tva;
3376 $this->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
3377 $this->fk_unit = $objp->fk_unit;
3378
3379 $this->db->free($result);
3380 return 1;
3381 }
3382 return 0;
3383 } else {
3384 dol_print_error($this->db);
3385 return -1;
3386 }
3387 }
3388
3395 public function insert($notrigger = 0)
3396 {
3397 global $user;
3398
3399 $error = 0;
3400
3401 dol_syslog(get_class($this)."::insert rang=".$this->rang);
3402
3403 // Clean parameters
3404 if (empty($this->tva_tx)) {
3405 $this->tva_tx = 0;
3406 }
3407 if (empty($this->vat_src_code)) {
3408 $this->vat_src_code = '';
3409 }
3410 if (empty($this->localtax1_tx)) {
3411 $this->localtax1_tx = 0;
3412 }
3413 if (empty($this->localtax2_tx)) {
3414 $this->localtax2_tx = 0;
3415 }
3416 if (empty($this->localtax1_type)) {
3417 $this->localtax1_type = '';
3418 }
3419 if (empty($this->localtax2_type)) {
3420 $this->localtax2_type = '';
3421 }
3422 if (empty($this->total_localtax1)) {
3423 $this->total_localtax1 = 0;
3424 }
3425 if (empty($this->total_localtax2)) {
3426 $this->total_localtax2 = 0;
3427 }
3428 if (empty($this->rang)) {
3429 $this->rang = 0;
3430 }
3431 if (empty($this->remise_percent)) {
3432 $this->remise_percent = 0;
3433 }
3434 if (empty($this->info_bits)) {
3435 $this->info_bits = 0;
3436 }
3437 if (empty($this->special_code)) {
3438 $this->special_code = 0;
3439 }
3440 if (empty($this->fk_parent_line)) {
3441 $this->fk_parent_line = 0;
3442 }
3443 if (empty($this->fk_fournprice)) {
3444 $this->fk_fournprice = 0;
3445 }
3446 if (empty($this->fk_unit)) {
3447 $this->fk_unit = 0;
3448 }
3449 if (empty($this->subprice)) {
3450 $this->subprice = 0;
3451 }
3452
3453 if (empty($this->pa_ht)) {
3454 $this->pa_ht = 0;
3455 }
3456
3457 // if buy price not defined, define buyprice as configured in margin admin
3458 if ($this->pa_ht == 0) {
3459 $result = $this->defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
3460 if ($result < 0) {
3461 return $result;
3462 } else {
3463 $this->pa_ht = $result;
3464 }
3465 }
3466
3467 // Check parameters
3468 if ($this->product_type < 0) {
3469 return -1;
3470 }
3471
3472 $this->db->begin();
3473
3474 // Insert line into database
3475 $sql = 'INSERT INTO '.MAIN_DB_PREFIX.'supplier_proposaldet';
3476 $sql .= ' (fk_supplier_proposal, fk_parent_line, label, description, fk_product, product_type,';
3477 $sql .= ' date_start, date_end,';
3478 $sql .= ' fk_remise_except, qty, tva_tx, vat_src_code, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type,';
3479 $sql .= ' subprice, subprice_ttc, remise_percent, ';
3480 $sql .= ' info_bits, ';
3481 $sql .= ' total_ht, total_tva, total_localtax1, total_localtax2, total_ttc, fk_product_fournisseur_price, buy_price_ht, special_code, rang,';
3482 $sql .= ' ref_fourn,';
3483 $sql .= ' fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_subprice_ttc, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc, fk_unit)';
3484 $sql .= " VALUES (".$this->fk_supplier_proposal.",";
3485 $sql .= " ".($this->fk_parent_line > 0 ? ((int) $this->fk_parent_line) : "null").",";
3486 $sql .= " ".(!empty($this->label) ? "'".$this->db->escape($this->label)."'" : "null").",";
3487 $sql .= " '".$this->db->escape($this->desc)."',";
3488 $sql .= " ".($this->fk_product ? ((int) $this->fk_product) : "null").",";
3489 $sql .= " ".((int) $this->product_type).",";
3490 $sql .= " ".($this->date_start ? "'".$this->db->idate($this->date_start)."'" : "null").",";
3491 $sql .= " ".($this->date_end ? "'".$this->db->idate($this->date_end)."'" : "null").",";
3492 $sql .= " ".($this->fk_remise_except ? ((int) $this->fk_remise_except) : "null").",";
3493 $sql .= " ".(float) price2num($this->qty, 'MS').",";
3494 $sql .= " ".(float) price2num($this->tva_tx).",";
3495 $sql .= " '".$this->db->escape($this->vat_src_code)."',";
3496 $sql .= " ".(float) price2num($this->localtax1_tx).",";
3497 $sql .= " ".(float) price2num($this->localtax2_tx).",";
3498 $sql .= " '".$this->db->escape($this->localtax1_type)."',";
3499 $sql .= " '".$this->db->escape($this->localtax2_type)."',";
3500 $sql .= " ".(float) price2num($this->subprice, 'MU') .",";
3501 $sql .= " ".(float) price2num($this->subprice_ttc, 'MU') .",";
3502 $sql .= " ".((float) $this->remise_percent).",";
3503 $sql .= " ".(isset($this->info_bits) ? ((int) $this->info_bits) : "null").",";
3504 $sql .= " ".(float) price2num($this->total_ht, 'MT').",";
3505 $sql .= " ".(float) price2num($this->total_tva, 'MT').",";
3506 $sql .= " ".(float) price2num($this->total_localtax1, 'MT').",";
3507 $sql .= " ".(float) price2num($this->total_localtax2, 'MT').",";
3508 $sql .= " ".(float) price2num($this->total_ttc, 'MT').",";
3509 $sql .= " ".(!empty($this->fk_fournprice) ? ((int) $this->fk_fournprice) : "null").",";
3510 $sql .= " ".(isset($this->pa_ht) ? (float) price2num($this->pa_ht, 'MU') : "null").",";
3511 $sql .= ' '.((int) $this->special_code).',';
3512 $sql .= ' '.((int) $this->rang).',';
3513 $sql .= " '".$this->db->escape($this->ref_fourn)."'";
3514 $sql .= ", ".($this->fk_multicurrency > 0 ? ((int) $this->fk_multicurrency) : 'null');
3515 $sql .= ", '".$this->db->escape($this->multicurrency_code)."'";
3516 $sql .= ", ".(float) price2num($this->multicurrency_subprice, 'CU');
3517 $sql .= ", ".(float) price2num($this->multicurrency_subprice_ttc, 'CU');
3518 $sql .= ", ".(float) price2num($this->multicurrency_total_ht, 'CT');
3519 $sql .= ", ".(float) price2num($this->multicurrency_total_tva, 'CT');
3520 $sql .= ", ".(float) price2num($this->multicurrency_total_ttc, 'CT');
3521 $sql .= ", ".($this->fk_unit ? ((int) $this->fk_unit) : 'null');
3522 $sql .= ')';
3523
3524 dol_syslog(get_class($this).'::insert', LOG_DEBUG);
3525 $resql = $this->db->query($sql);
3526 if ($resql) {
3527 $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX.'supplier_proposaldet');
3528
3529 if (!$error) {
3530 $result = $this->insertExtraFields();
3531 if ($result < 0) {
3532 $error++;
3533 }
3534 }
3535
3536 if (!$error && !$notrigger) {
3537 // Call trigger
3538 $result = $this->call_trigger('LINESUPPLIER_PROPOSAL_INSERT', $user);
3539 if ($result < 0) {
3540 $this->db->rollback();
3541 return -1;
3542 }
3543 // End call triggers
3544 }
3545
3546 $this->db->commit();
3547 return 1;
3548 } else {
3549 $this->error = $this->db->error()." sql=".$sql;
3550 $this->db->rollback();
3551 return -1;
3552 }
3553 }
3554
3561 public function delete($user)
3562 {
3563 $error = 0;
3564
3565 $this->db->begin();
3566
3567 $sql = "DELETE FROM ".MAIN_DB_PREFIX."supplier_proposaldet";
3568 $sql .= " WHERE rowid = ".((int) $this->id);
3569
3570 if ($this->db->query($sql)) {
3571 // Remove extrafields
3572 if (!$error) {
3573 $result = $this->deleteExtraFields();
3574 if ($result < 0) {
3575 $error++;
3576 dol_syslog(get_class($this)."::delete error -4 ".$this->error, LOG_ERR);
3577 }
3578 }
3579
3580 // Call trigger
3581 $result = $this->call_trigger('LINESUPPLIER_PROPOSAL_DELETE', $user);
3582 if ($result < 0) {
3583 $this->db->rollback();
3584 return -1;
3585 }
3586 // End call triggers
3587
3588 $this->db->commit();
3589
3590 return 1;
3591 } else {
3592 $this->error = $this->db->error()." sql=".$sql;
3593 $this->db->rollback();
3594 return -1;
3595 }
3596 }
3597
3604 public function update($notrigger = 0)
3605 {
3606 global $user;
3607
3608 $error = 0;
3609
3610 // Clean parameters
3611 if (empty($this->tva_tx)) {
3612 $this->tva_tx = 0;
3613 }
3614 if (empty($this->localtax1_tx)) {
3615 $this->localtax1_tx = 0;
3616 }
3617 if (empty($this->localtax2_tx)) {
3618 $this->localtax2_tx = 0;
3619 }
3620 if (empty($this->total_localtax1)) {
3621 $this->total_localtax1 = 0;
3622 }
3623 if (empty($this->total_localtax2)) {
3624 $this->total_localtax2 = 0;
3625 }
3626 if (empty($this->localtax1_type)) {
3627 $this->localtax1_type = '';
3628 }
3629 if (empty($this->localtax2_type)) {
3630 $this->localtax2_type = '';
3631 }
3632 if (empty($this->marque_tx)) {
3633 $this->marque_tx = 0;
3634 }
3635 if (empty($this->marge_tx)) {
3636 $this->marge_tx = 0;
3637 }
3638 if (empty($this->remise_percent)) {
3639 $this->remise_percent = 0;
3640 }
3641 if (empty($this->info_bits)) {
3642 $this->info_bits = 0;
3643 }
3644 if (empty($this->special_code)) {
3645 $this->special_code = 0;
3646 }
3647 if (empty($this->fk_parent_line)) {
3648 $this->fk_parent_line = 0;
3649 }
3650 if (empty($this->fk_fournprice)) {
3651 $this->fk_fournprice = 0;
3652 }
3653 if (empty($this->fk_unit)) {
3654 $this->fk_unit = 0;
3655 }
3656 if (empty($this->subprice)) {
3657 $this->subprice = 0;
3658 }
3659
3660 if (empty($this->pa_ht)) {
3661 $this->pa_ht = 0;
3662 }
3663
3664 // if buy price not defined, define buyprice as configured in margin admin
3665 if ($this->pa_ht == 0) {
3666 $result = $this->defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
3667 if ($result < 0) {
3668 return $result;
3669 } else {
3670 $this->pa_ht = $result;
3671 }
3672 }
3673
3674 $this->db->begin();
3675
3676 // Mise a jour ligne en base
3677 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposaldet SET";
3678 $sql .= " description = '".$this->db->escape($this->desc)."'";
3679 $sql .= " , label = ".(!empty($this->label) ? "'".$this->db->escape($this->label)."'" : "null");
3680 $sql .= " , product_type = ".((int) $this->product_type);
3681 $sql .= " , date_start = ".($this->date_start ? "'".$this->db->idate($this->date_start)."'" : "null");
3682 $sql .= " , date_end = ".($this->date_end ? "'".$this->db->idate($this->date_end)."'" : "null");
3683 $sql .= " , tva_tx = '".price2num($this->tva_tx)."'";
3684 $sql .= " , localtax1_tx = ".(float) price2num($this->localtax1_tx);
3685 $sql .= " , localtax2_tx = ".(float) price2num($this->localtax2_tx);
3686 $sql .= " , localtax1_type = '".$this->db->escape($this->localtax1_type)."'";
3687 $sql .= " , localtax2_type = '".$this->db->escape($this->localtax2_type)."'";
3688 $sql .= " , qty = ".(float) price2num($this->qty);
3689 $sql .= " , subprice = ".(float) price2num($this->subprice);
3690 $sql .= " , subprice_ttc = ".(float) price2num($this->subprice_ttc);
3691 $sql .= " , remise_percent = ".(float) price2num($this->remise_percent);
3692 $sql .= " , info_bits = ".((int) $this->info_bits);
3693 if (empty($this->skip_update_total)) {
3694 $sql .= " , total_ht = ".(float) price2num($this->total_ht);
3695 $sql .= " , total_tva = ".(float) price2num($this->total_tva);
3696 $sql .= " , total_ttc = ".(float) price2num($this->total_ttc);
3697 $sql .= " , total_localtax1 = ".(float) price2num($this->total_localtax1);
3698 $sql .= " , total_localtax2 = ".(float) price2num($this->total_localtax2);
3699 }
3700 $sql .= " , fk_product_fournisseur_price = ".(!empty($this->fk_fournprice) ? "'".$this->db->escape((string) $this->fk_fournprice)."'" : "null");
3701 $sql .= " , buy_price_ht = ".(float) price2num($this->pa_ht);
3702 $sql .= " , special_code = ".((int) $this->special_code);
3703 $sql .= " , fk_parent_line = ".($this->fk_parent_line > 0 ? $this->fk_parent_line : "null");
3704 if (!empty($this->rang)) {
3705 $sql .= ", rang = ".((int) $this->rang);
3706 }
3707 $sql .= " , ref_fourn = ".(!empty($this->ref_fourn) ? "'".$this->db->escape($this->ref_fourn)."'" : "null");
3708 $sql .= " , fk_unit = ".($this->fk_unit ? (int) $this->fk_unit : 'null');
3709
3710 // Multicurrency
3711 $sql .= " , multicurrency_subprice = ".(float) price2num($this->multicurrency_subprice);
3712 $sql .= " , multicurrency_subprice_ttc = ".(float) price2num($this->multicurrency_subprice_ttc);
3713 $sql .= " , multicurrency_total_ht = ".(float) price2num($this->multicurrency_total_ht);
3714 $sql .= " , multicurrency_total_tva = ".(float) price2num($this->multicurrency_total_tva);
3715 $sql .= " , multicurrency_total_ttc = ".(float) price2num($this->multicurrency_total_ttc);
3716
3717 $sql .= " WHERE rowid = ".((int) $this->id);
3718
3719 dol_syslog(get_class($this)."::update", LOG_DEBUG);
3720 $resql = $this->db->query($sql);
3721 if ($resql) {
3722 if (!$error) {
3723 $result = $this->insertExtraFields();
3724 if ($result < 0) {
3725 $error++;
3726 }
3727 }
3728
3729 if (!$error && !$notrigger) {
3730 // Call trigger
3731 $result = $this->call_trigger('LINESUPPLIER_PROPOSAL_MODIFY', $user);
3732 if ($result < 0) {
3733 $this->db->rollback();
3734 return -1;
3735 }
3736 // End call triggers
3737 }
3738
3739 $this->db->commit();
3740 return 1;
3741 } else {
3742 $this->error = $this->db->error();
3743 $this->db->rollback();
3744 return -2;
3745 }
3746 }
3747
3748 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
3755 public function update_total()
3756 {
3757 // phpcs:enable
3758 $this->db->begin();
3759
3760 // Mise a jour ligne en base
3761 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposaldet SET";
3762 $sql .= " total_ht = ".(float) price2num($this->total_ht, 'MT');
3763 $sql .= ",total_tva = ".(float) price2num($this->total_tva, 'MT');
3764 $sql .= ",total_ttc = ".(float) price2num($this->total_ttc, 'MT');
3765 $sql .= " WHERE rowid = ".((int) $this->id);
3766
3767 dol_syslog("SupplierProposalLine::update_total", LOG_DEBUG);
3768
3769 $resql = $this->db->query($sql);
3770 if ($resql) {
3771 $this->db->commit();
3772 return 1;
3773 } else {
3774 $this->error = $this->db->error();
3775 $this->db->rollback();
3776 return -2;
3777 }
3778 }
3779}
$object ref
Definition info.php:90
Parent class of all other business classes (invoices, contracts, proposals, orders,...
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...
line_order($renum=false, $rowidorder='ASC', $fk_parent_line=true)
Save a new position (field rang) for details lines.
deleteEcmFiles($mode=0)
Delete related files of object in database.
update_price($exclspec=0, $roundingadjust='auto', $nodatabaseupdate=0, $seller=null)
Update total_ht, total_ttc, total_vat, total_localtax1, total_localtax2 for an object (sum of lines).
add_object_linked($origin=null, $origin_id=null, $f_user=null, $notrigger=0)
Add an object link into llx_element_element.
defineBuyPrice($unitPrice=0.0, $discountPercent=0.0, $fk_product=0)
Get buy price to use for margin calculation.
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
fetch_thirdparty($force_thirdparty_id=0)
Load the third party of object, from id $this->socid or $this->fk_soc, into this->thirdparty.
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
Delete all links between an object $this.
setErrorsFromObject($object)
setErrorsFromObject
isLineOfObject($lineid)
Check that a line belongs to this object, using $this->table_element_line and $this->fk_element.
static isExistingObject($element, $id, $ref='', $ref_ext='')
Check if an object id or ref exists If you don't need or want to instantiate the object and just need...
updateRangOfLine($rowid, $rang)
Update position of line (rang)
checkActiveProductInLines($status='onsale')
Check if all products have the right status (on sale, on buy) called during validation of propal,...
deleteExtraFields()
Delete all extra fields values for the current object.
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
static commonReplaceProduct(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a product id with another one.
line_max($fk_parent_line=0)
Get max value used for position of line (rang)
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
add_contact($fk_socpeople, $type_contact, $source='external', $notrigger=0)
Add a link between element $this->element and a contact.
Parent class for class inheritance lines of business objects This class is useless for the moment so ...
Class to manage absolute discounts.
Class to manage Dolibarr database access.
Class Currency.
static getIdAndTxFromCode($dbs, $code, $date_document=0)
Get id and rate of currency from code.
Class to manage predefined suppliers products.
Class to manage products or services.
const TYPE_PRODUCT
Regular product.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage price ask supplier.
updatePriceFournisseur($idProductFournPrice, $product, $user)
Update ProductFournisseur.
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=[], $ref_supplier='', $fk_unit=0, $pu_ht_devise=0)
Update a proposal line.
cloture($user, $status, $note)
Close the askprice.
initAsSpecimen($param=array())
Initialise an instance with random values.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
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=[], $ref_supplier='', $fk_unit=0, $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 parameters sont deja cense e...
info($id)
Object SupplierProposal Information.
create($user, $notrigger=0)
Create commercial proposal into database this->ref can be set or empty.
insert_discount($idremise)
Adding line of fixed discount in the proposal in DB.
reopen($user, $status, $note='', $notrigger=0)
Set an overall discount on the proposal.
static replaceProduct(DoliDB $db, $origin_id, $dest_id)
Function used to replace a product id with another one.
fetch($rowid, $ref='')
Load a proposal from database and its ligne array.
load_board($user, $mode)
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
createFromClone(User $user, $fromid=0)
Load an object from its id and create a new one in database.
const STATUS_NOTSIGNED
Not signed quote, canceled.
const STATUS_DRAFT
Draft status.
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.
update($user, $notrigger=0)
Update the header fields of the price request that can be edited without a dedicated action.
setDeliveryDate($user, $delivery_date)
Set delivery date.
__construct($db, $socid=0, $supplier_proposalid=0)
Constructor.
LibStatut($status, $mode=1)
Return label of a status (draft, validated, ...)
setCategories($categories)
Sets object to supplied categories.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
updateOrCreatePriceFournisseur($user)
Add or update supplier price according to result of proposal.
loadStateBoard()
Load indicator this->nb of global stats widget.
deleteLine($lineid)
Delete detail line.
const STATUS_VALIDATED
Validated status.
createPriceFournisseur($product, $user)
Create Price Fournisseur.
getLibStatut($mode=0)
Return label of status of proposal (draft, validated, ...)
add_product($idproduct, $qty, $remise_percent=0)
Add line into array ->lines.
set_date_livraison($user, $delivery_date)
Set delivery date.
const STATUS_SIGNED
Signed quote.
getNomUrl($withpicto=0, $option='', $get_params='', $notooltip=0, $save_lastsearch_value=-1, $addlinktonotes=0)
Return clickable link of object (with eventually picto)
getKanbanView($option='', $arraydata=null)
Return clickable link of object (with eventually picto)
getTooltipContentArray($params)
getTooltipContentArray
valid($user, $notrigger=0)
Set status to validated.
const STATUS_CLOSE
Billed or closed/processed quote.
getLinesArray()
Retrieve an array of supplier proposal lines.
setDraft($user)
Set draft status.
Class to manage supplier_proposal lines.
fetch($rowid)
Retrieve the propal line object.
insert($notrigger=0)
Insert object line propal in database.
update_total()
Update DB line fields total_xxx Used by migration.
update($notrigger=0)
Update propal line object into DB.
__construct($db)
Class line Constructor.
Class to manage translations.
Class to manage Dolibarr users.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
Definition index.php:171
global $mysoc
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.
dol_delete_dir_recursive($dir, $count=0, $nophperrors=0, $onlysub=0, &$countdeleted=0, $indexdatabase=1, $nolog=0, $level=0)
Remove a directory $dir and its subdirectories (or only files and subdirectories)
dol_dir_list($utf8_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:64
dol_delete_preview($object)
Delete all preview files linked to object instance.
dol_now($mode='gmt')
Return date for now.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $allowothertags=array())
Show a picto called object_picto (generic function)
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
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.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
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.: VAT NPR in France)
getDolCurrency()
Return the main currency ('EUR', 'USD', ...)
dolGetStatus($statusLabel='', $statusLabelShort='', $html='', $statusType='status0', $displayMode=0, $url='', $params=array())
Output the badge of a status.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
getDolGlobalBool($key, $default=false)
Return a Dolibarr global constant boolean value.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
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...
get_localtax($vatrate, $local, $thirdparty_buyer=null, $thirdparty_seller=null, $vatnpr=0)
Return localtax rate for a particular VAT rate, when selling a product with vat $vatrate,...
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
getMarginInfos($pv_ht, $remise_percent, $tva_tx, $localtax1_tx, $localtax2_tx, $fk_pa, $pa_ht)
Return an array with margins information of a line.
calcul_price_total($qty, $pu, $remise_percent_ligne, $txtva, $uselocaltax1_rate, $uselocaltax2_rate, $remise_percent_global, $price_base_type, $info_bits, $type, $seller=null, $localtaxes_array=[], $progress=100, $multicurrency_tx=1, $pu_devise=0, $multicurrency_code='')
Calculate totals (net, vat, ...) of a line.
Definition price.lib.php:90
if(getDolGlobalString( 'TAKEPOS_SHOW_CUSTOMER')) print $langs trans('Date')." left Label right Qty right Price right TotalHT right TotalTTC right right right right right right right right right centpercent right TotalHT right n right VAT right n right TotalVAT right n No sujeto a RE IRPF right TotalLT1 right n right TotalLT2 right n right TotalTTC right n takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency right TotalTTC takeposcustomercurrency right takeposcustomercurrency n right PaymentTypeShortLIQ right SELECT p pos_change as p datep as date
Definition receipt.php:469