dolibarr 22.0.5
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-2024 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
198 public $extraparams = array();
199
203 public $lines = array();
204
208 public $line;
209
210 public $labelStatus = array();
211 public $labelStatusShort = array();
212
216 public $nbtodo;
220 public $nbtodolate;
221
222 // Multicurrency
226 public $fk_multicurrency;
227
231 public $multicurrency_code;
235 public $multicurrency_tx;
239 public $multicurrency_total_ht;
243 public $multicurrency_total_tva;
247 public $multicurrency_total_ttc;
248
249 public $fields = array(
250 'ref' => array('type' => 'varchar(255)', 'label' => 'Ref', 'enabled' => 1, 'visible' => 1, 'showoncombobox' => 1, 'position' => 25, 'searchall' => 1),
251 'note_public' => array('type' => 'html', 'label' => 'NotePublic', 'enabled' => 1, 'visible' => 0, 'position' => 750, 'searchall' => 1),
252 );
253
257 const STATUS_DRAFT = 0;
258
263
267 const STATUS_SIGNED = 2;
268
273
277 const STATUS_CLOSE = 4;
278
279
280
288 public function __construct($db, $socid = 0, $supplier_proposalid = 0)
289 {
290 global $conf, $langs;
291
292 $this->db = $db;
293
294 $this->ismultientitymanaged = 1;
295 $this->socid = $socid;
296 $this->id = $supplier_proposalid;
297 }
298
299
300 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
311 public function add_product($idproduct, $qty, $remise_percent = 0)
312 {
313 // phpcs:enable
314 global $conf, $mysoc;
315
316 if (!$qty) {
317 $qty = 1;
318 }
319
320 dol_syslog(get_class($this)."::add_product $idproduct, $qty, $remise_percent");
321 if ($idproduct > 0) {
322 $prod = new Product($this->db);
323 $prod->fetch($idproduct);
324
325 $productdesc = $prod->description;
326
327 $tva_tx = get_default_tva($mysoc, $this->thirdparty, $prod->id);
328 $tva_npr = get_default_npr($mysoc, $this->thirdparty, $prod->id);
329 if (empty($tva_tx)) {
330 $tva_npr = 0;
331 }
332 $localtax1_tx = get_localtax($tva_tx, 1, $mysoc, $this->thirdparty, $tva_npr);
333 $localtax2_tx = get_localtax($tva_tx, 2, $mysoc, $this->thirdparty, $tva_npr);
334
335 // multiprix
336 if ($conf->global->PRODUIT_MULTIPRICES && $this->thirdparty->price_level) {
337 $price = $prod->multiprices[$this->thirdparty->price_level];
338 } else {
339 $price = $prod->price;
340 }
341
342 $line = new SupplierProposalLine($this->db);
343
344 $line->fk_product = $idproduct;
345 $line->desc = $productdesc;
346 $line->qty = $qty;
347 $line->subprice = $price;
348 $line->remise_percent = $remise_percent;
349 $line->tva_tx = $tva_tx;
350
351 $this->lines[] = $line;
352 return 1;
353 }
354 return -1;
355 }
356
357 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
364 public function insert_discount($idremise)
365 {
366 // phpcs:enable
367 global $langs;
368
369 include_once DOL_DOCUMENT_ROOT.'/core/lib/price.lib.php';
370 include_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php';
371
372 $this->db->begin();
373
374 $remise = new DiscountAbsolute($this->db);
375 $result = $remise->fetch($idremise);
376
377 if ($result > 0) {
378 if ($remise->fk_facture) { // Protection against multiple submission
379 $this->error = $langs->trans("ErrorDiscountAlreadyUsed");
380 $this->db->rollback();
381 return -5;
382 }
383
384 $supplier_proposalligne = new SupplierProposalLine($this->db);
385 $supplier_proposalligne->fk_supplier_proposal = $this->id;
386 $supplier_proposalligne->fk_remise_except = $remise->id;
387 $supplier_proposalligne->desc = $remise->description; // Description ligne
388 $supplier_proposalligne->tva_tx = $remise->tva_tx;
389 $supplier_proposalligne->subprice = -(float) $remise->amount_ht;
390 $supplier_proposalligne->fk_product = 0; // Id produit predefini
391 $supplier_proposalligne->qty = 1;
392 $supplier_proposalligne->remise_percent = 0;
393 $supplier_proposalligne->rang = -1;
394 $supplier_proposalligne->info_bits = 2;
395
396 $supplier_proposalligne->total_ht = -(float) $remise->amount_ht;
397 $supplier_proposalligne->total_tva = -(float) $remise->amount_tva;
398 $supplier_proposalligne->total_ttc = -(float) $remise->amount_ttc;
399
400 $result = $supplier_proposalligne->insert();
401 if ($result > 0) {
402 $result = $this->update_price(1);
403 if ($result > 0) {
404 $this->db->commit();
405 return 1;
406 } else {
407 $this->db->rollback();
408 return -1;
409 }
410 } else {
411 $this->error = $supplier_proposalligne->error;
412 $this->db->rollback();
413 return -2;
414 }
415 } else {
416 $this->db->rollback();
417 return -2;
418 }
419 }
420
458 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)
459 {
460 global $mysoc, $conf, $langs;
461
462 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");
463 include_once DOL_DOCUMENT_ROOT.'/core/lib/price.lib.php';
464
465 // Clean parameters
466 if (empty($remise_percent)) {
467 $remise_percent = 0;
468 }
469 if (empty($qty)) {
470 $qty = 0;
471 }
472 if (empty($info_bits)) {
473 $info_bits = 0;
474 }
475 if (empty($rang)) {
476 $rang = 0;
477 }
478 if (empty($fk_parent_line) || $fk_parent_line < 0) {
479 $fk_parent_line = 0;
480 }
481 if (empty($pu_ht)) {
482 $pu_ht = 0;
483 }
484
485 $remise_percent = price2num($remise_percent);
486 $qty = (float) price2num($qty);
487 $pu_ht = price2num($pu_ht);
488 $pu_ttc = price2num($pu_ttc);
489 if (!preg_match('/\‍((.*)\‍)/', (string) $txtva)) {
490 $txtva = price2num($txtva); // $txtva can have format '5.0(XXX)' or '5'
491 }
492 $txlocaltax1 = price2num($txlocaltax1);
493 $txlocaltax2 = price2num($txlocaltax2);
494 $pa_ht = price2num($pa_ht);
495 if ($price_base_type == 'HT') {
496 $pu = $pu_ht;
497 } else {
498 $pu = $pu_ttc;
499 }
500
501 // Check parameters
502 if ($type < 0) {
503 return -1;
504 }
505
506 if ($this->statut == self::STATUS_DRAFT) {
507 $this->db->begin();
508
509 if ($fk_product > 0) {
510 if (getDolGlobalInt('SUPPLIER_PROPOSAL_WITH_PREDEFINED_PRICES_ONLY') == 1) { // Not the common case
511 // Check quantity is enough
512 dol_syslog(get_class($this)."::addline we check supplier prices fk_product=".$fk_product." fk_fournprice=".$fk_fournprice." qty=".$qty." ref_supplier=".$ref_supplier);
513 $productsupplier = new ProductFournisseur($this->db);
514 if ($productsupplier->fetch($fk_product) > 0) {
515 $product_type = $productsupplier->type;
516 $label = $productsupplier->label;
517 $fk_prod_fourn_price = $fk_fournprice;
518
519 // We use 'none' instead of $ref_supplier, because fourn_ref may not exists anymore. So we will take the first supplier price ok.
520 // If we want a dedicated supplier price, we must provide $fk_prod_fourn_price.
521 // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
522 $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
523 if ($result > 0) {
524 $pu = $productsupplier->fourn_pu; // Unit price supplier price set by get_buyprice
525 $ref_supplier = $productsupplier->ref_supplier; // Ref supplier price set by get_buyprice
526 // is remise percent not keyed but present for the product we add it
527 if ($remise_percent == 0 && $productsupplier->remise_percent != 0) {
528 $remise_percent = $productsupplier->remise_percent;
529 }
530 }
531 if ($result == 0) { // If result == 0, we failed to found the supplier reference price
532 $langs->load("errors");
533 $this->error = "Ref ".$productsupplier->ref." ".$langs->trans("ErrorQtyTooLowForThisSupplier");
534 $this->db->rollback();
535 dol_syslog(get_class($this)."::addline we did not found supplier price, so we can't guess unit price");
536 //$pu = $productsupplier->fourn_pu; // We do not overwrite unit price
537 //$ref = $productsupplier_fourn; // We do not overwrite ref supplier price
538 return -1;
539 }
540 if ($result == -1) {
541 $langs->load("errors");
542 $this->error = "Ref ".$productsupplier->ref." ".$langs->trans("ErrorQtyTooLowForThisSupplier");
543 $this->db->rollback();
544 dol_syslog(get_class($this)."::addline result=".$result." - ".$this->error, LOG_DEBUG);
545 return -1;
546 }
547 if ($result < -1) {
548 $this->error = $productsupplier->error;
549 $this->errors = $productsupplier->errors;
550 $this->db->rollback();
551 dol_syslog(get_class($this)."::addline result=".$result." - ".$this->error, LOG_ERR);
552 return -1;
553 }
554 } else {
555 $this->error = $productsupplier->error;
556 $this->errors = $productsupplier->errors;
557 $this->db->rollback();
558 return -1;
559 }
560 }
561 } else {
562 $product_type = $type;
563 }
564
565 // Calcul du total TTC et de la TVA pour la ligne a partir de
566 // qty, pu, remise_percent et txtva
567 // TRES IMPORTANT: C'est au moment de l'insertion ligne qu'on doit stocker
568 // la part ht, tva et ttc, et ce au niveau de la ligne qui a son propre taux tva.
569
570 $localtaxes_type = getLocalTaxesFromRate($txtva, 0, $this->thirdparty, $mysoc);
571
572 // Clean vat code
573 $reg = array();
574 $vat_src_code = '';
575 if (preg_match('/\‍((.*)\‍)/', $txtva, $reg)) {
576 $vat_src_code = $reg[1];
577 $txtva = preg_replace('/\s*\‍(.*\‍)/', '', $txtva); // Remove code into vatrate.
578 }
579
580 if (isModEnabled("multicurrency") && $pu_ht_devise > 0) {
581 $pu = 0;
582 }
583
584 $tabprice = calcul_price_total($qty, $pu, (float) $remise_percent, $txtva, (float) $txlocaltax1, (float) $txlocaltax2, 0, $price_base_type, $info_bits, $type, $this->thirdparty, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);
585 $total_ht = $tabprice[0];
586 $total_tva = $tabprice[1];
587 $total_ttc = $tabprice[2];
588 $total_localtax1 = $tabprice[9];
589 $total_localtax2 = $tabprice[10];
590 $pu = $pu_ht = $tabprice[3];
591
592 // MultiCurrency
593 $multicurrency_total_ht = $tabprice[16];
594 $multicurrency_total_tva = $tabprice[17];
595 $multicurrency_total_ttc = $tabprice[18];
596 $pu_ht_devise = $tabprice[19];
597
598 // Rang to use
599 $ranktouse = $rang;
600 if ($ranktouse == -1) {
601 $rangmax = $this->line_max($fk_parent_line);
602 $ranktouse = $rangmax + 1;
603 }
604
605 // TODO A virer
606 // Anciens indicateurs: $price, $remise (a ne plus utiliser)
607 $price = $pu;
608 $remise = 0;
609 if ($remise_percent > 0) {
610 $remise = round(((float) $pu * (float) $remise_percent / 100), 2);
611 $price = (float) $pu - $remise;
612 }
613
614 // Insert line
615 $this->line = new SupplierProposalLine($this->db);
616
617 $this->line->fk_supplier_proposal = $this->id;
618 $this->line->label = $label;
619 $this->line->desc = $desc;
620 $this->line->qty = $qty;
621
622 $this->line->vat_src_code = $vat_src_code;
623 $this->line->tva_tx = $txtva;
624 $this->line->localtax1_tx = ($total_localtax1 ? $localtaxes_type[1] : 0);
625 $this->line->localtax2_tx = ($total_localtax2 ? $localtaxes_type[3] : 0);
626 $this->line->localtax1_type = empty($localtaxes_type[0]) ? '' : $localtaxes_type[0];
627 $this->line->localtax2_type = empty($localtaxes_type[2]) ? '' : $localtaxes_type[2];
628 $this->line->fk_product = $fk_product;
629 $this->line->remise_percent = $remise_percent;
630 $this->line->subprice = (float) $pu_ht;
631 $this->line->rang = $ranktouse;
632 $this->line->info_bits = $info_bits;
633 $this->line->total_ht = (float) $total_ht;
634 $this->line->total_tva = (float) $total_tva;
635 $this->line->total_localtax1 = (float) $total_localtax1;
636 $this->line->total_localtax2 = (float) $total_localtax2;
637 $this->line->total_ttc = (float) $total_ttc;
638 $this->line->product_type = $type;
639 $this->line->special_code = $special_code;
640 $this->line->fk_parent_line = $fk_parent_line;
641 $this->line->fk_unit = $fk_unit;
642 $this->line->origin = $origin;
643 $this->line->origin_id = $origin_id;
644 $this->line->ref_fourn = $this->db->escape($ref_supplier);
645 $this->line->date_start = $date_start;
646 $this->line->date_end = $date_end;
647
648 // infos merge
649 if (!empty($fk_product) && $fk_product > 0 && empty($fk_fournprice) && empty($pa_ht)) {
650 // When fk_fournprice is 0, we take the lowest buying price
651 include_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.product.class.php';
652 $productFournisseur = new ProductFournisseur($this->db);
653 $productFournisseur->find_min_price_product_fournisseur($fk_product);
654 $this->line->fk_fournprice = $productFournisseur->product_fourn_price_id;
655 } else {
656 $this->line->fk_fournprice = ($fk_fournprice > 0 ? $fk_fournprice : 0); // If fk_fournprice is -1, we will not use fk_fournprice
657 }
658 $this->line->pa_ht = $pa_ht;
659 //var_dump($this->line->fk_fournprice);exit;
660
661 // Multicurrency
662 $this->line->fk_multicurrency = $this->fk_multicurrency;
663 $this->line->multicurrency_code = $this->multicurrency_code;
664 $this->line->multicurrency_subprice = (float) $pu_ht_devise;
665 $this->line->multicurrency_total_ht = (float) $multicurrency_total_ht;
666 $this->line->multicurrency_total_tva = (float) $multicurrency_total_tva;
667 $this->line->multicurrency_total_ttc = (float) $multicurrency_total_ttc;
668
669 // Mise en option de la ligne
670 if (empty($qty) && empty($special_code)) {
671 $this->line->special_code = 3;
672 }
673
674 if (is_array($array_options) && count($array_options) > 0) {
675 $this->line->array_options = $array_options;
676 }
677
678 $result = $this->line->insert();
679 if ($result > 0) {
680 // Reorder if child line
681 if (!empty($fk_parent_line)) {
682 $this->line_order(true, 'DESC');
683 } elseif ($ranktouse > 0 && $ranktouse <= count($this->lines)) { // Update all rank of all other lines
684 $linecount = count($this->lines);
685 for ($ii = $ranktouse; $ii <= $linecount; $ii++) {
686 $this->updateRangOfLine($this->lines[$ii - 1]->id, $ii + 1);
687 }
688 }
689
690 // Mise a jour information denormalisees au niveau de la propale meme
691 $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.
692 if ($result > 0) {
693 $this->db->commit();
694 return $this->line->id;
695 } else {
696 $this->db->rollback();
697 return -1;
698 }
699 } else {
700 $this->error = $this->line->error;
701 $this->errors = $this->line->errors;
702 $this->db->rollback();
703 return -2;
704 }
705 } else {
706 $this->error = 'BadStatusOfObjectToAddLine';
707 return -5;
708 }
709 }
710
711
738 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)
739 {
740 global $conf, $user, $langs, $mysoc;
741
742 dol_syslog(get_class($this)."::updateLine $rowid, $pu, $qty, $remise_percent, $txtva, $desc, $price_base_type, $info_bits");
743 include_once DOL_DOCUMENT_ROOT.'/core/lib/price.lib.php';
744
745 // Clean parameters
746 $remise_percent = price2num($remise_percent);
747 $qty = (float) price2num($qty);
748 $pu = price2num($pu);
749 if (!preg_match('/\‍((.*)\‍)/', (string) $txtva)) {
750 $txtva = price2num($txtva); // $txtva can have format '5.0(XXX)' or '5'
751 }
752 $txlocaltax1 = price2num($txlocaltax1);
753 $txlocaltax2 = price2num($txlocaltax2);
754 $pa_ht = price2num($pa_ht);
755 if (empty($qty) && empty($special_code)) {
756 $special_code = 3; // Set option tag
757 }
758 if (!empty($qty) && $special_code == 3) {
759 $special_code = 0; // Remove option tag
760 }
761
762 if ($this->status == 0) {
763 $this->db->begin();
764
765 // Calcul du total TTC et de la TVA pour la ligne a partir de
766 // qty, pu, remise_percent et txtva
767 // TRES IMPORTANT: C'est au moment de l'insertion ligne qu'on doit stocker
768 // la part ht, tva et ttc, et ce au niveau de la ligne qui a son propre taux tva.
769
770 $localtaxes_type = getLocalTaxesFromRate($txtva, 0, $mysoc, $this->thirdparty);
771
772 // Clean vat code
773 $reg = array();
774 $vat_src_code = '';
775 if (preg_match('/\‍((.*)\‍)/', $txtva, $reg)) {
776 $vat_src_code = $reg[1];
777 $txtva = preg_replace('/\s*\‍(.*\‍)/', '', $txtva); // Remove code into vatrate.
778 }
779
780 if (isModEnabled("multicurrency") && $pu_ht_devise > 0) {
781 $pu = 0;
782 }
783
784 $tabprice = calcul_price_total($qty, $pu, (float) $remise_percent, $txtva, (float) $txlocaltax1, (float) $txlocaltax2, 0, $price_base_type, $info_bits, $type, $this->thirdparty, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);
785 $total_ht = $tabprice[0];
786 $total_tva = $tabprice[1];
787 $total_ttc = $tabprice[2];
788 $total_localtax1 = $tabprice[9];
789 $total_localtax2 = $tabprice[10];
790 $pu_ht = $tabprice[3];
791 $pu_tva = $tabprice[4];
792 $pu_ttc = $tabprice[5];
793
794 // MultiCurrency
795 $multicurrency_total_ht = $tabprice[16];
796 $multicurrency_total_tva = $tabprice[17];
797 $multicurrency_total_ttc = $tabprice[18];
798 $pu_ht_devise = $tabprice[19];
799
800 $pu = $pu_ht;
801 if ($price_base_type == 'TTC') {
802 $pu = $pu_ttc;
803 }
804
805 // Fetch current line from the database and then clone the object and set it in $oldline property
806 $line = new SupplierProposalLine($this->db);
807 $line->fetch($rowid);
808 $line->fetch_optionals();
809
810 $fk_product = $line->fk_product;
811
812 // Stock previous line records
813 $staticline = clone $line;
814
815 $line->oldline = $staticline;
816 $this->line = $line;
817 $this->line->context = $this->context;
818
819 // Reorder if fk_parent_line change
820 if (!empty($fk_parent_line) && !empty($staticline->fk_parent_line) && $fk_parent_line != $staticline->fk_parent_line) {
821 $rangmax = $this->line_max($fk_parent_line);
822 $this->line->rang = $rangmax + 1;
823 }
824
825 $this->line->id = $rowid;
826 $this->line->label = $label;
827 $this->line->desc = $desc;
828 $this->line->qty = $qty;
829 $this->line->product_type = $type;
830
831 $this->line->vat_src_code = $vat_src_code;
832 $this->line->tva_tx = $txtva;
833 $this->line->localtax1_tx = $txlocaltax1;
834 $this->line->localtax2_tx = $txlocaltax2;
835 $this->line->localtax1_type = empty($localtaxes_type[0]) ? '' : $localtaxes_type[0];
836 $this->line->localtax2_type = empty($localtaxes_type[2]) ? '' : $localtaxes_type[2];
837 $this->line->remise_percent = $remise_percent;
838 $this->line->subprice = (float) $pu;
839 $this->line->info_bits = $info_bits;
840 $this->line->total_ht = (float) $total_ht;
841 $this->line->total_tva = (float) $total_tva;
842 $this->line->total_localtax1 = (float) $total_localtax1;
843 $this->line->total_localtax2 = (float) $total_localtax2;
844 $this->line->total_ttc = (float) $total_ttc;
845 $this->line->special_code = $special_code;
846 $this->line->fk_parent_line = $fk_parent_line;
847 $this->line->skip_update_total = $skip_update_total;
848 $this->line->ref_fourn = $ref_supplier;
849 $this->line->fk_unit = $fk_unit;
850
851 // infos merge
852 if (!empty($fk_product) && $fk_product > 0 && empty($fk_fournprice) && empty($pa_ht)) {
853 // by external module, take lowest buying price
854 include_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.product.class.php';
855 $productFournisseur = new ProductFournisseur($this->db);
856 $productFournisseur->find_min_price_product_fournisseur($fk_product);
857 $this->line->fk_fournprice = $productFournisseur->product_fourn_price_id;
858 } else {
859 $this->line->fk_fournprice = $fk_fournprice;
860 }
861 $this->line->pa_ht = $pa_ht;
862
863 if (is_array($array_options) && count($array_options) > 0) {
864 // We replace values in this->line->array_options only for entries defined into $array_options
865 foreach ($array_options as $key => $value) {
866 $this->line->array_options[$key] = $array_options[$key];
867 }
868 }
869
870 // Multicurrency
871 $this->line->multicurrency_subprice = (float) $pu_ht_devise;
872 $this->line->multicurrency_total_ht = (float) $multicurrency_total_ht;
873 $this->line->multicurrency_total_tva = (float) $multicurrency_total_tva;
874 $this->line->multicurrency_total_ttc = (float) $multicurrency_total_ttc;
875
876 $result = $this->line->update();
877 if ($result > 0) {
878 // Reorder if child line
879 if (!empty($fk_parent_line)) {
880 $this->line_order(true, 'DESC');
881 }
882
883 $this->update_price(1);
884
885 $this->db->commit();
886 return $result;
887 } else {
888 $this->error = $this->db->error();
889 $this->db->rollback();
890 return -1;
891 }
892 } else {
893 dol_syslog(get_class($this)."::updateline Erreur -2 SupplierProposal en mode incompatible pour cette action");
894 return -2;
895 }
896 }
897
898
905 public function deleteLine($lineid)
906 {
907 global $user;
908
909 if ($this->statut == 0) {
910 $line = new SupplierProposalLine($this->db);
911
912 // For triggers
913 $line->fetch($lineid);
914
915 if ($this->id > 0 && (int) $line->fk_supplier_proposal !== (int) $this->id) {
916 $this->error = 'ErrorLineIDDoesNotMatchWithObjectID';
917 return -1;
918 }
919
920 if ($line->delete($user) > 0) {
921 $this->update_price(1);
922
923 return 1;
924 } else {
925 return -1;
926 }
927 } else {
928 return -2;
929 }
930 }
931
932
941 public function create($user, $notrigger = 0)
942 {
943 global $langs, $conf, $mysoc, $hookmanager;
944 $error = 0;
945
946 $now = dol_now();
947
948 dol_syslog(get_class($this)."::create");
949
950 // Check parameters
951 $result = $this->fetch_thirdparty();
952 if ($result < 0) {
953 $this->error = "Failed to fetch company";
954 dol_syslog(get_class($this)."::create ".$this->error, LOG_ERR);
955 return -3;
956 }
957 if (!empty($this->ref)) { // We check that ref is not already used
958 $result = self::isExistingObject($this->element, 0, $this->ref); // Check ref is not yet used
959 if ($result > 0) {
960 $this->error = 'ErrorRefAlreadyExists';
961 dol_syslog(get_class($this)."::create ".$this->error, LOG_WARNING);
962 $this->db->rollback();
963 return -1;
964 }
965 }
966
967 // Set tmp vars
968 $delivery_date = $this->delivery_date;
969
970 // Multicurrency
971 if (!empty($this->multicurrency_code)) {
972 list($this->fk_multicurrency, $this->multicurrency_tx) = MultiCurrency::getIdAndTxFromCode($this->db, $this->multicurrency_code, $now);
973 }
974 if (empty($this->fk_multicurrency)) {
975 $this->multicurrency_code = $conf->currency;
976 $this->fk_multicurrency = 0;
977 $this->multicurrency_tx = 1;
978 }
979
980 $this->db->begin();
981
982 // Insert into database
983 $sql = "INSERT INTO ".MAIN_DB_PREFIX."supplier_proposal (";
984 $sql .= "fk_soc";
985 $sql .= ", price";
986 $sql .= ", total_tva";
987 $sql .= ", total_ttc";
988 $sql .= ", datec";
989 $sql .= ", ref";
990 $sql .= ", fk_user_author";
991 $sql .= ", note_private";
992 $sql .= ", note_public";
993 $sql .= ", model_pdf";
994 $sql .= ", fk_cond_reglement";
995 $sql .= ", fk_mode_reglement";
996 $sql .= ", fk_account";
997 $sql .= ", date_livraison";
998 $sql .= ", fk_shipping_method";
999 $sql .= ", fk_projet";
1000 $sql .= ", entity";
1001 $sql .= ", fk_multicurrency";
1002 $sql .= ", multicurrency_code";
1003 $sql .= ", multicurrency_tx";
1004 $sql .= ") ";
1005 $sql .= " VALUES (";
1006 $sql .= ((int) $this->socid);
1007 $sql .= ", 0";
1008 $sql .= ", 0";
1009 $sql .= ", 0";
1010 $sql .= ", '".$this->db->idate($now)."'";
1011 $sql .= ", '(PROV)'";
1012 $sql .= ", ".($user->id > 0 ? ((int) $user->id) : "null");
1013 $sql .= ", '".$this->db->escape($this->note_private)."'";
1014 $sql .= ", '".$this->db->escape($this->note_public)."'";
1015 $sql .= ", '".$this->db->escape($this->model_pdf)."'";
1016 $sql .= ", ".($this->cond_reglement_id > 0 ? ((int) $this->cond_reglement_id) : 'NULL');
1017 $sql .= ", ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) : 'NULL');
1018 $sql .= ", ".($this->fk_account > 0 ? ((int) $this->fk_account) : 'NULL');
1019 $sql .= ", ".(isDolTms($delivery_date) ? "'".$this->db->idate($delivery_date)."'" : "null");
1020 $sql .= ", ".($this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) : 'NULL');
1021 $sql .= ", ".($this->fk_project > 0 ? ((int) $this->fk_project) : "null");
1022 $sql .= ", ".((int) $conf->entity);
1023 $sql .= ", ".((int) $this->fk_multicurrency);
1024 $sql .= ", '".$this->db->escape($this->multicurrency_code)."'";
1025 $sql .= ", ".((float) $this->multicurrency_tx);
1026 $sql .= ")";
1027
1028 dol_syslog(get_class($this)."::create", LOG_DEBUG);
1029 $resql = $this->db->query($sql);
1030 if ($resql) {
1031 $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX."supplier_proposal");
1032
1033 if ($this->id) {
1034 $this->ref = '(PROV'.$this->id.')';
1035 $sql = 'UPDATE '.MAIN_DB_PREFIX."supplier_proposal SET ref='".$this->db->escape($this->ref)."' WHERE rowid=".((int) $this->id);
1036
1037 dol_syslog(get_class($this)."::create", LOG_DEBUG);
1038 $resql = $this->db->query($sql);
1039 if (!$resql) {
1040 $error++;
1041 }
1042
1043 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) { // To use new linkedObjectsIds instead of old linked_objects
1044 $this->linked_objects = $this->linkedObjectsIds; // TODO Replace linked_objects with linkedObjectsIds
1045 }
1046
1047 // Add object linked
1048 if (!$error && $this->id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
1049 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
1050 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, ...))
1051 foreach ($tmp_origin_id as $origin_id) {
1052 $ret = $this->add_object_linked($origin, $origin_id);
1053 if (!$ret) {
1054 dol_print_error($this->db);
1055 $error++;
1056 }
1057 }
1058 }
1059 }
1060 }
1061
1062 /*
1063 * Insertion du detail des produits dans la base
1064 */
1065 if (!$error) {
1066 $fk_parent_line = 0;
1067 $num = count($this->lines);
1068
1069 for ($i = 0; $i < $num; $i++) {
1070 // Reset fk_parent_line for no child products and special product
1071 if (($this->lines[$i]->product_type != 9 && empty($this->lines[$i]->fk_parent_line)) || $this->lines[$i]->product_type == 9) {
1072 $fk_parent_line = 0;
1073 }
1074
1075 $result = $this->addline(
1076 $this->lines[$i]->desc,
1077 $this->lines[$i]->subprice,
1078 $this->lines[$i]->qty,
1079 $this->lines[$i]->tva_tx,
1080 $this->lines[$i]->localtax1_tx,
1081 $this->lines[$i]->localtax2_tx,
1082 $this->lines[$i]->fk_product,
1083 $this->lines[$i]->remise_percent,
1084 'HT',
1085 0,
1086 0,
1087 $this->lines[$i]->product_type,
1088 $this->lines[$i]->rang,
1089 $this->lines[$i]->special_code,
1090 $fk_parent_line,
1091 $this->lines[$i]->fk_fournprice,
1092 $this->lines[$i]->pa_ht,
1093 empty($this->lines[$i]->label) ? '' : $this->lines[$i]->label, // deprecated
1094 $this->lines[$i]->array_options,
1095 $this->lines[$i]->ref_fourn,
1096 $this->lines[$i]->fk_unit,
1097 'supplier_proposal',
1098 $this->lines[$i]->rowid
1099 );
1100
1101 if ($result < 0) {
1102 $error++;
1103 $this->error = $this->db->error;
1104 dol_print_error($this->db);
1105 break;
1106 }
1107 // Defined the new fk_parent_line
1108 if ($result > 0 && $this->lines[$i]->product_type == 9) {
1109 $fk_parent_line = $result;
1110 }
1111 }
1112 }
1113
1114 if (!$error) {
1115 // Mise a jour infos denormalisees
1116 $resql = $this->update_price(1);
1117 if ($resql) {
1118 $action = 'update';
1119
1120 // Actions on extra fields
1121 if (!$error) {
1122 $result = $this->insertExtraFields();
1123 if ($result < 0) {
1124 $error++;
1125 }
1126 }
1127
1128 if (!$error && !$notrigger) {
1129 // Call trigger
1130 $result = $this->call_trigger('PROPOSAL_SUPPLIER_CREATE', $user);
1131 if ($result < 0) {
1132 $error++;
1133 }
1134 // End call triggers
1135 }
1136 } else {
1137 $this->error = $this->db->lasterror();
1138 $error++;
1139 }
1140 }
1141 } else {
1142 $this->error = $this->db->lasterror();
1143 $error++;
1144 }
1145
1146 if (!$error) {
1147 $this->db->commit();
1148 dol_syslog(get_class($this)."::create done id=".$this->id);
1149 return $this->id;
1150 } else {
1151 $this->db->rollback();
1152 return -2;
1153 }
1154 } else {
1155 $this->error = $this->db->lasterror();
1156 $this->db->rollback();
1157 return -1;
1158 }
1159 }
1160
1168 public function createFromClone(User $user, $fromid = 0)
1169 {
1170 global $conf, $hookmanager;
1171
1172 $error = 0;
1173 $now = dol_now();
1174
1175 $this->db->begin();
1176
1177 // get extrafields so they will be clone
1178 foreach ($this->lines as $line) {
1179 $line->fetch_optionals();
1180 }
1181
1182 // Load source object
1183 $objFrom = clone $this;
1184
1185 $objsoc = new Societe($this->db);
1186
1187 // Change socid if needed
1188 if (!empty($fromid) && $fromid != $this->socid) {
1189 if ($objsoc->fetch($fromid) > 0) {
1190 $this->socid = $objsoc->id;
1191 $this->cond_reglement_id = (!empty($objsoc->cond_reglement_id) ? $objsoc->cond_reglement_id : 0);
1192 $this->mode_reglement_id = (!empty($objsoc->mode_reglement_id) ? $objsoc->mode_reglement_id : 0);
1193 unset($this->fk_project);
1194 }
1195
1196 // TODO Change product price if multi-prices
1197 } else {
1198 $objsoc->fetch($this->socid);
1199 }
1200
1201 $this->id = 0;
1202 $this->statut = 0;
1203
1204 if (!getDolGlobalString('SUPPLIER_PROPOSAL_ADDON') || !is_readable(DOL_DOCUMENT_ROOT."/core/modules/supplier_proposal/" . getDolGlobalString('SUPPLIER_PROPOSAL_ADDON').".php")) {
1205 $this->error = 'ErrorSetupNotComplete';
1206 return -1;
1207 }
1208
1209 // Clear fields
1210 $this->user_author_id = $user->id;
1211 $this->user_validation_id = 0;
1212 $this->date = $now;
1213
1214 // Set ref
1215 require_once DOL_DOCUMENT_ROOT."/core/modules/supplier_proposal/" . getDolGlobalString('SUPPLIER_PROPOSAL_ADDON').'.php';
1216 $obj = getDolGlobalString('SUPPLIER_PROPOSAL_ADDON');
1217 $modSupplierProposal = new $obj();
1218 '@phan-var-force ModeleNumRefSupplierProposal $modSupplierProposal';
1219 $this->ref = $modSupplierProposal->getNextValue($objsoc, $this);
1220
1221 // Create clone
1222 $this->context['createfromclone'] = 'createfromclone';
1223 $result = $this->create($user);
1224 if ($result < 0) {
1225 $error++;
1226 }
1227
1228 if (!$error) {
1229 // Hook of thirdparty module
1230 if (is_object($hookmanager)) {
1231 $parameters = array('objFrom' => $objFrom);
1232 $action = '';
1233 $reshook = $hookmanager->executeHooks('createFrom', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
1234 if ($reshook < 0) {
1235 $this->setErrorsFromObject($hookmanager);
1236 $error++;
1237 }
1238 }
1239 }
1240
1241 unset($this->context['createfromclone']);
1242
1243 // End
1244 if (!$error) {
1245 $this->db->commit();
1246 return $this->id;
1247 } else {
1248 $this->db->rollback();
1249 return -1;
1250 }
1251 }
1252
1260 public function fetch($rowid, $ref = '')
1261 {
1262 global $conf;
1263
1264 $sql = "SELECT p.rowid, p.entity, p.ref, p.fk_soc as socid";
1265 $sql .= ", p.total_ttc, p.total_tva, p.localtax1, p.localtax2, p.total_ht";
1266 $sql .= ", p.datec";
1267 $sql .= ", p.date_valid as datev";
1268 $sql .= ", p.date_livraison as delivery_date";
1269 $sql .= ", p.model_pdf, p.extraparams";
1270 $sql .= ", p.note_private, p.note_public";
1271 $sql .= ", p.fk_projet as fk_project, p.fk_statut";
1272 $sql .= ", p.fk_user_author, p.fk_user_valid, p.fk_user_cloture";
1273 $sql .= ", p.fk_cond_reglement";
1274 $sql .= ", p.fk_mode_reglement";
1275 $sql .= ', p.fk_account';
1276 $sql .= ", p.fk_shipping_method";
1277 $sql .= ", p.last_main_doc";
1278 $sql .= ", p.fk_multicurrency, p.multicurrency_code, p.multicurrency_tx, p.multicurrency_total_ht, p.multicurrency_total_tva, p.multicurrency_total_ttc";
1279 $sql .= ", c.label as statut_label";
1280 $sql .= ", cr.code as cond_reglement_code, cr.libelle as cond_reglement, cr.libelle_facture as cond_reglement_libelle_doc";
1281 $sql .= ", cp.code as mode_reglement_code, cp.libelle as mode_reglement";
1282 $sql .= " FROM ".MAIN_DB_PREFIX."c_propalst as c, ".MAIN_DB_PREFIX."supplier_proposal as p";
1283 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_paiement as cp ON p.fk_mode_reglement = cp.id';
1284 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_payment_term as cr ON p.fk_cond_reglement = cr.rowid';
1285 $sql .= " WHERE p.fk_statut = c.id";
1286 $sql .= " AND p.entity IN (".getEntity('supplier_proposal').")";
1287 if ($ref) {
1288 $sql .= " AND p.ref = '".$this->db->escape($ref)."'";
1289 } else {
1290 $sql .= " AND p.rowid = ".((int) $rowid);
1291 }
1292
1293 dol_syslog(get_class($this)."::fetch", LOG_DEBUG);
1294 $resql = $this->db->query($sql);
1295 if ($resql) {
1296 if ($this->db->num_rows($resql)) {
1297 $obj = $this->db->fetch_object($resql);
1298
1299 $this->id = $obj->rowid;
1300 $this->entity = $obj->entity;
1301
1302 $this->ref = $obj->ref;
1303 $this->total_ht = $obj->total_ht;
1304 $this->total_tva = $obj->total_tva;
1305 $this->total_localtax1 = $obj->localtax1;
1306 $this->total_localtax2 = $obj->localtax2;
1307 $this->total_ttc = $obj->total_ttc;
1308 $this->socid = $obj->socid;
1309 $this->fk_project = $obj->fk_project;
1310 $this->model_pdf = $obj->model_pdf;
1311 $this->note = $obj->note_private; // TODO deprecated
1312 $this->note_private = $obj->note_private;
1313 $this->note_public = $obj->note_public;
1314 $this->statut = (int) $obj->fk_statut;
1315 $this->status = (int) $obj->fk_statut;
1316 $this->datec = $this->db->jdate($obj->datec); // TODO deprecated
1317 $this->datev = $this->db->jdate($obj->datev); // TODO deprecated
1318 $this->date_creation = $this->db->jdate($obj->datec); // Creation date
1319 $this->date = $this->date_creation;
1320 $this->date_validation = $this->db->jdate($obj->datev); // Validation date
1321 $this->delivery_date = $this->db->jdate($obj->delivery_date);
1322 $this->shipping_method_id = ($obj->fk_shipping_method > 0) ? $obj->fk_shipping_method : null;
1323
1324 $this->last_main_doc = $obj->last_main_doc;
1325 $this->mode_reglement_id = $obj->fk_mode_reglement;
1326 $this->mode_reglement_code = $obj->mode_reglement_code;
1327 $this->mode_reglement = $obj->mode_reglement;
1328 $this->fk_account = ($obj->fk_account > 0) ? $obj->fk_account : null;
1329 $this->cond_reglement_id = $obj->fk_cond_reglement;
1330 $this->cond_reglement_code = $obj->cond_reglement_code;
1331 $this->cond_reglement = $obj->cond_reglement;
1332 $this->cond_reglement_label = $obj->cond_reglement;
1333 $this->cond_reglement_doc = $obj->cond_reglement_libelle_doc;
1334
1335 $this->extraparams = (array) (!empty($obj->extraparams) ? json_decode($obj->extraparams, true) : array());
1336
1337 $this->user_author_id = $obj->fk_user_author;
1338 $this->user_validation_id = $obj->fk_user_valid;
1339 $this->user_closing_id = $obj->fk_user_cloture;
1340
1341 // Multicurrency
1342 $this->fk_multicurrency = $obj->fk_multicurrency;
1343 $this->multicurrency_code = $obj->multicurrency_code;
1344 $this->multicurrency_tx = $obj->multicurrency_tx;
1345 $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
1346 $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
1347 $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
1348
1349 $this->db->free($resql);
1350
1351 // Retrieve all extrafield
1352 // fetch optionals attributes and labels
1353 $this->fetch_optionals();
1354
1355 $this->lines = array();
1356
1357 // Lines of supplier proposals
1358 $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,";
1359 $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,";
1360 $sql .= ' p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label,';
1361 $sql .= ' d.ref_fourn as ref_produit_fourn, d.extraparams,';
1362 $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';
1363 $sql .= " FROM ".MAIN_DB_PREFIX."supplier_proposaldet as d";
1364 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."product as p ON d.fk_product = p.rowid";
1365 $sql .= " WHERE d.fk_supplier_proposal = ".((int) $this->id);
1366 $sql .= " ORDER by d.rang";
1367
1368 $result = $this->db->query($sql);
1369 if ($result) {
1370 $num = $this->db->num_rows($result);
1371 $i = 0;
1372
1373 while ($i < $num) {
1374 $objp = $this->db->fetch_object($result);
1375
1376 $line = new SupplierProposalLine($this->db);
1377
1378 $line->rowid = $objp->rowid; // deprecated
1379 $line->id = $objp->rowid;
1380 $line->fk_supplier_proposal = $objp->fk_supplier_proposal;
1381 $line->fk_parent_line = $objp->fk_parent_line;
1382 $line->product_type = $objp->product_type;
1383 $line->label = $objp->custom_label;
1384 $line->desc = $objp->description; // Description ligne
1385 $line->qty = $objp->qty;
1386 $line->tva_tx = $objp->tva_tx;
1387 $line->localtax1_tx = $objp->localtax1_tx;
1388 $line->localtax2_tx = $objp->localtax2_tx;
1389 $line->subprice = $objp->subprice;
1390 $line->fk_remise_except = $objp->fk_remise_except;
1391 $line->remise_percent = $objp->remise_percent;
1392
1393 $line->info_bits = $objp->info_bits;
1394 $line->total_ht = $objp->total_ht;
1395 $line->total_tva = $objp->total_tva;
1396 $line->total_localtax1 = $objp->total_localtax1;
1397 $line->total_localtax2 = $objp->total_localtax2;
1398 $line->total_ttc = $objp->total_ttc;
1399 $line->fk_fournprice = $objp->fk_fournprice;
1400 $marginInfos = getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $line->fk_fournprice, $objp->pa_ht);
1401 $line->pa_ht = $marginInfos[0];
1402 $line->marge_tx = $marginInfos[1];
1403 $line->marque_tx = $marginInfos[2];
1404 $line->special_code = $objp->special_code;
1405 $line->rang = $objp->rang;
1406
1407 $line->fk_product = $objp->fk_product;
1408
1409 $line->ref = $objp->product_ref; // deprecated
1410 $line->product_ref = $objp->product_ref;
1411 $line->libelle = $objp->product_label; // deprecated
1412 $line->product_label = $objp->product_label;
1413 $line->product_desc = $objp->product_desc; // Description produit
1414 $line->fk_product_type = $objp->fk_product_type;
1415
1416 $line->ref_fourn = $objp->ref_produit_fourn;
1417
1418 $line->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams, true) : array();
1419
1420 // Multicurrency
1421 $line->fk_multicurrency = $objp->fk_multicurrency;
1422 $line->multicurrency_code = $objp->multicurrency_code;
1423 $line->multicurrency_subprice = $objp->multicurrency_subprice;
1424 $line->multicurrency_total_ht = $objp->multicurrency_total_ht;
1425 $line->multicurrency_total_tva = $objp->multicurrency_total_tva;
1426 $line->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
1427 $line->fk_unit = $objp->fk_unit;
1428
1429 $line->fetch_optionals();
1430
1431 $this->lines[$i] = $line;
1432
1433 $i++;
1434 }
1435 $this->db->free($result);
1436 } else {
1437 $this->error = $this->db->error();
1438 return -1;
1439 }
1440
1441 return 1;
1442 }
1443
1444 $this->error = "Record Not Found";
1445 return 0;
1446 } else {
1447 $this->error = $this->db->error();
1448 return -1;
1449 }
1450 }
1451
1459 public function update($user, $notrigger = 0)
1460 {
1461 $error = 0;
1462
1463 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal SET";
1464 $sql .= " fk_projet = ".($this->fk_project > 0 ? ((int) $this->fk_project) : "null");
1465 $sql .= ", fk_cond_reglement = ".($this->cond_reglement_id > 0 ? ((int) $this->cond_reglement_id) : "null");
1466 $sql .= ", fk_mode_reglement = ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) : "null");
1467 $sql .= ", fk_account = ".($this->fk_account > 0 ? ((int) $this->fk_account) : "null");
1468 $sql .= ", fk_shipping_method = ".($this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) : "null");
1469 $sql .= ", date_livraison = ".($this->delivery_date ? "'".$this->db->idate($this->delivery_date)."'" : "null");
1470 $sql .= ", note_private = ".(isset($this->note_private) ? "'".$this->db->escape($this->note_private)."'" : "null");
1471 $sql .= ", note_public = ".(isset($this->note_public) ? "'".$this->db->escape($this->note_public)."'" : "null");
1472 $sql .= ", model_pdf = ".(isset($this->model_pdf) ? "'".$this->db->escape($this->model_pdf)."'" : "null");
1473 $sql .= ", fk_user_modif = ".((int) $user->id);
1474 $sql .= " WHERE rowid = ".((int) $this->id);
1475
1476 $this->db->begin();
1477
1478 dol_syslog(get_class($this)."::update", LOG_DEBUG);
1479 $resql = $this->db->query($sql);
1480 if (!$resql) {
1481 $error++;
1482 $this->errors[] = "Error ".$this->db->lasterror();
1483 }
1484
1485 if (!$error) {
1486 $result = $this->insertExtraFields();
1487 if ($result < 0) {
1488 $error++;
1489 }
1490 }
1491
1492 if (!$error && !$notrigger) {
1493 // Call trigger
1494 $result = $this->call_trigger('PROPOSAL_SUPPLIER_MODIFY', $user);
1495 if ($result < 0) {
1496 $error++;
1497 }
1498 // End call triggers
1499 }
1500
1501 if ($error) {
1502 $this->error = implode(', ', $this->errors);
1503 $this->db->rollback();
1504 return -1 * $error;
1505 }
1506
1507 $this->db->commit();
1508 return 1;
1509 }
1510
1518 public function valid($user, $notrigger = 0)
1519 {
1520 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
1521
1522 global $conf, $langs;
1523
1524 $error = 0;
1525 $now = dol_now();
1526
1527 if ((!getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('supplier_proposal', 'creer'))
1528 || (getDolGlobalString('MAIN_USE_ADVANCED_PERMS') && $user->hasRight('supplier_proposal', 'validate_advance'))) {
1529 $this->db->begin();
1530
1531 // Numbering module definition
1532 $soc = new Societe($this->db);
1533 $result = $soc->fetch($this->socid);
1534
1535 if ($result < 0) {
1536 return -1;
1537 }
1538
1539 // Define new ref
1540 if (preg_match('/^[\‍(]?PROV/i', $this->ref) || empty($this->ref)) { // empty should not happened, but when it occurs, the test save life
1541 $num = $this->getNextNumRef($soc);
1542 } else {
1543 $num = $this->ref;
1544 }
1545 $this->newref = dol_sanitizeFileName($num);
1546
1547 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal";
1548 $sql .= " SET ref = '".$this->db->escape($num)."',";
1549 $sql .= " fk_statut = 1, date_valid='".$this->db->idate($now)."', fk_user_valid=".((int) $user->id);
1550 $sql .= " WHERE rowid = ".((int) $this->id)." AND fk_statut = 0";
1551
1552 dol_syslog(get_class($this)."::valid", LOG_DEBUG);
1553 $resql = $this->db->query($sql);
1554 if (!$resql) {
1555 dol_print_error($this->db);
1556 $error++;
1557 }
1558
1559 // Trigger calls
1560 if (!$error && !$notrigger) {
1561 // Call trigger
1562 $result = $this->call_trigger('PROPOSAL_SUPPLIER_VALIDATE', $user);
1563 if ($result < 0) {
1564 $error++;
1565 }
1566 // End call triggers
1567 }
1568
1569 if (!$error) {
1570 $this->oldref = $this->ref;
1571
1572 // Rename directory if dir was a temporary ref
1573 if (preg_match('/^[\‍(]?PROV/i', $this->ref)) {
1574 // Now we rename also files into index
1575 $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)."'";
1576 $sql .= " WHERE filename LIKE '".$this->db->escape($this->ref)."%' AND filepath = 'supplier_proposal/".$this->db->escape($this->ref)."' and entity = ".$conf->entity;
1577 $resql = $this->db->query($sql);
1578 if (!$resql) {
1579 $error++;
1580 $this->error = $this->db->lasterror();
1581 }
1582 $sql = 'UPDATE '.MAIN_DB_PREFIX."ecm_files set filepath = 'supplier_proposal/".$this->db->escape($this->newref)."'";
1583 $sql .= " WHERE filepath = 'supplier_proposal/".$this->db->escape($this->ref)."' and entity = ".$conf->entity;
1584 $resql = $this->db->query($sql);
1585 if (!$resql) {
1586 $error++;
1587 $this->error = $this->db->lasterror();
1588 }
1589
1590 // We rename directory ($this->ref = old ref, $num = new ref) in order not to lose the attachments
1591 $oldref = dol_sanitizeFileName($this->ref);
1592 $newref = dol_sanitizeFileName($num);
1593 $dirsource = $conf->supplier_proposal->dir_output.'/'.$oldref;
1594 $dirdest = $conf->supplier_proposal->dir_output.'/'.$newref;
1595 if (!$error && file_exists($dirsource)) {
1596 dol_syslog(get_class($this)."::valid rename dir ".$dirsource." into ".$dirdest);
1597 if (@rename($dirsource, $dirdest)) {
1598 dol_syslog("Rename ok");
1599 // Rename docs starting with $oldref with $newref
1600 $listoffiles = dol_dir_list($conf->supplier_proposal->dir_output.'/'.$newref, 'files', 1, '^'.preg_quote($oldref, '/'));
1601 foreach ($listoffiles as $fileentry) {
1602 $dirsource = $fileentry['name'];
1603 $dirdest = preg_replace('/^'.preg_quote($oldref, '/').'/', $newref, $dirsource);
1604 $dirsource = $fileentry['path'].'/'.$dirsource;
1605 $dirdest = $fileentry['path'].'/'.$dirdest;
1606 @rename($dirsource, $dirdest);
1607 }
1608 }
1609 }
1610 }
1611
1612 $this->ref = $num;
1613 $this->statut = self::STATUS_VALIDATED;
1615 $this->user_validation_id = $user->id;
1616 $this->datev = $now;
1617 $this->date_validation = $now;
1618
1619 if (getDolGlobalString('SUPPLIER_PROPOSAL_AUTOADD_USER_CONTACT')) {
1620 $result = $this->add_contact($user->id, 'SALESREPFOLL', 'internal', 1);
1621 if ($result < 0 && $result != -2) { // -2 means already exists
1622 $error++;
1623 }
1624 }
1625
1626 $this->db->commit();
1627 return 1;
1628 } else {
1629 $this->db->rollback();
1630 return -1;
1631 }
1632 } else {
1633 dol_syslog("You don't have permission to validate supplier proposal", LOG_WARNING);
1634 return -2;
1635 }
1636 }
1637
1638 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1647 public function set_date_livraison($user, $delivery_date)
1648 {
1649 // phpcs:enable
1650 return $this->setDeliveryDate($user, $delivery_date);
1651 }
1652
1660 public function setDeliveryDate($user, $delivery_date)
1661 {
1662 if ($user->hasRight('supplier_proposal', 'creer')) {
1663 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal ";
1664 $sql .= " SET date_livraison = ".(isDolTms($delivery_date) ? "'".$this->db->idate($delivery_date)."'" : 'null');
1665 $sql .= " WHERE rowid = ".((int) $this->id);
1666
1667 if ($this->db->query($sql)) {
1668 $this->delivery_date = $delivery_date;
1669 return 1;
1670 } else {
1671 $this->error = $this->db->error();
1672 dol_syslog(get_class($this)."::setDeliveryDate Erreur SQL");
1673 return -1;
1674 }
1675 }
1676 return 0;
1677 }
1678
1679 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1687 /*
1688 public function set_remise_percent($user, $remise)
1689 {
1690 // phpcs:enable
1691 $remise = trim($remise) ?trim($remise) : 0;
1692
1693 if ($user->hasRight('supplier_proposal', 'creer')) {
1694 $remise = price2num($remise, 2);
1695
1696 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal SET remise_percent = ".((float) $remise);
1697 $sql .= " WHERE rowid = ".((int) $this->id)." AND fk_statut = 0";
1698
1699 if ($this->db->query($sql)) {
1700 $this->remise_percent = ((float) $remise);
1701 $this->update_price(1);
1702 return 1;
1703 } else {
1704 $this->error = $this->db->error();
1705 return -1;
1706 }
1707 }
1708 return 0;
1709 }
1710 */
1711
1712 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
1720 /*
1721 public function set_remise_absolue($user, $remise)
1722 {
1723 // phpcs:enable
1724 if (empty($remise)) {
1725 $remise = 0;
1726 }
1727
1728 $remise = price2num($remise);
1729
1730 if ($user->hasRight('supplier_proposal', 'creer')) {
1731 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal ";
1732 $sql .= " SET remise_absolue = ".((float) $remise);
1733 $sql .= " WHERE rowid = ".((int) $this->id)." AND fk_statut = 0";
1734
1735 if ($this->db->query($sql)) {
1736 $this->remise_absolue = $remise;
1737 $this->update_price(1);
1738 return 1;
1739 } else {
1740 $this->error = $this->db->error();
1741 return -1;
1742 }
1743 }
1744 return 0;
1745 }
1746 */
1747
1748
1758 public function reopen($user, $status, $note = '', $notrigger = 0)
1759 {
1760 $error = 0;
1761
1762 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal";
1763 $sql .= " SET fk_statut = ".((int) $status).",";
1764 if (!empty($note)) {
1765 $sql .= " note_private = '".$this->db->escape($note)."',";
1766 }
1767 $sql .= " date_cloture = NULL, fk_user_cloture = NULL";
1768 $sql .= " WHERE rowid = ".((int) $this->id);
1769
1770 $this->db->begin();
1771
1772 dol_syslog(get_class($this)."::reopen", LOG_DEBUG);
1773 $resql = $this->db->query($sql);
1774 if (!$resql) {
1775 $error++;
1776 $this->errors[] = "Error ".$this->db->lasterror();
1777 }
1778 if (!$error) {
1779 if (!$notrigger) {
1780 // Call trigger
1781 $result = $this->call_trigger('PROPOSAL_SUPPLIER_REOPEN', $user);
1782 if ($result < 0) {
1783 $error++;
1784 }
1785 // End call triggers
1786 }
1787 }
1788
1789 // Commit or rollback
1790 if ($error) {
1791 if (!empty($this->errors)) {
1792 foreach ($this->errors as $errmsg) {
1793 dol_syslog(get_class($this)."::update ".$errmsg, LOG_ERR);
1794 $this->error .= ($this->error ? ', '.$errmsg : $errmsg);
1795 }
1796 }
1797 $this->db->rollback();
1798 return -1 * $error;
1799 } else {
1800 $this->statut = $status;
1801 $this->status = $status;
1802
1803 $this->db->commit();
1804 return 1;
1805 }
1806 }
1807
1808
1817 public function cloture($user, $status, $note)
1818 {
1819 global $langs, $conf;
1820 $hidedetails = 0;
1821 $hidedesc = 0;
1822 $hideref = 0;
1823
1824 $error = 0;
1825 $now = dol_now();
1826
1827 $this->db->begin();
1828
1829 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal";
1830 $sql .= " SET fk_statut = ".((int) $status).", note_private = '".$this->db->escape($note)."', date_cloture='".$this->db->idate($now)."', fk_user_cloture=".((int) $user->id);
1831 $sql .= " WHERE rowid = ".((int) $this->id);
1832
1833 $resql = $this->db->query($sql);
1834 if ($resql) {
1835 $this->statut = $status;
1836 $this->status = $status;
1837
1838 $modelpdf = getDolGlobalString('SUPPLIER_PROPOSAL_ADDON_PDF_ODT_CLOSED', (empty($this->model_pdf) ? '' : $this->model_pdf));
1839 $triggerName = 'PROPOSAL_SUPPLIER_CLOSE_REFUSED';
1840
1841 if ($status == 2) {
1842 $triggerName = 'PROPOSAL_SUPPLIER_CLOSE_SIGNED';
1843 $modelpdf = getDolGlobalString('SUPPLIER_PROPOSAL_ADDON_PDF_ODT_TOBILL', (empty($this->model_pdf) ? '' : $this->model_pdf));
1844
1845 if (getDolGlobalString('SUPPLIER_PROPOSAL_UPDATE_PRICE_ON_SUPPlIER_PROPOSAL')) { // TODO This option was not tested correctly. Error if product ref does not exists
1846 $result = $this->updateOrCreatePriceFournisseur($user);
1847 }
1848 }
1849 if ($status == 4) {
1850 $triggerName = 'PROPOSAL_SUPPLIER_CLASSIFY_BILLED';
1851 }
1852
1853 if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) {
1854 // Define output language
1855 $outputlangs = $langs;
1856 if (getDolGlobalInt('MAIN_MULTILANGS')) {
1857 $outputlangs = new Translate("", $conf);
1858 $newlang = (GETPOST('lang_id', 'aZ09') ? GETPOST('lang_id', 'aZ09') : $this->thirdparty->default_lang);
1859 $outputlangs->setDefaultLang($newlang);
1860 }
1861
1862 $this->generateDocument($modelpdf, $outputlangs, $hidedetails, $hidedesc, $hideref);
1863 }
1864
1865 // Call trigger
1866 $result = $this->call_trigger($triggerName, $user);
1867 if ($result < 0) {
1868 $error++;
1869 }
1870 // End call triggers
1871
1872 if (!$error) {
1873 $this->db->commit();
1874 return 1;
1875 } else {
1876 $this->db->rollback();
1877 return -1;
1878 }
1879 } else {
1880 $this->error = $this->db->lasterror();
1881 $this->errors[] = $this->db->lasterror();
1882 $this->db->rollback();
1883 return -1;
1884 }
1885 }
1886
1893 public function updateOrCreatePriceFournisseur($user)
1894 {
1895 global $conf;
1896
1897 dol_syslog(get_class($this)."::updateOrCreatePriceFournisseur", LOG_DEBUG);
1898 foreach ($this->lines as $product) {
1899 if ($product->subprice <= 0) {
1900 continue;
1901 }
1902 $productsupplier = new ProductFournisseur($this->db);
1903
1904 $multicurrency_tx = 1;
1905 $fk_multicurrency = 0;
1906
1907 if (empty($this->thirdparty)) {
1908 $this->fetch_thirdparty();
1909 }
1910
1911 $ref_fourn = $product->ref_fourn;
1912 if (empty($ref_fourn)) {
1913 $ref_fourn = $product->ref_supplier;
1914 }
1915 if (isModEnabled("multicurrency") && !empty($product->multicurrency_code)) {
1916 list($fk_multicurrency, $multicurrency_tx) = MultiCurrency::getIdAndTxFromCode($this->db, $product->multicurrency_code);
1917 }
1918 $productsupplier->id = $product->fk_product;
1919
1920 $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);
1921 }
1922
1923 return 1;
1924 }
1925
1934 public function updatePriceFournisseur($idProductFournPrice, $product, $user)
1935 {
1936 $price = price2num($product->subprice * $product->qty, 'MU');
1937 $unitPrice = price2num($product->subprice, 'MU');
1938
1939 $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);
1940
1941 $resql = $this->db->query($sql);
1942 if (!$resql) {
1943 $this->error = $this->db->error();
1944 $this->db->rollback();
1945 return -1;
1946 }
1947 return 1;
1948 }
1949
1957 public function createPriceFournisseur($product, $user)
1958 {
1959 global $conf;
1960
1961 $price = price2num($product->subprice * $product->qty, 'MU');
1962 $qty = price2num($product->qty);
1963 $unitPrice = price2num($product->subprice, 'MU');
1964
1965 $now = dol_now();
1966
1967 $values = array(
1968 "'".$this->db->idate($now)."'",
1969 (int) $product->fk_product,
1970 (int) $this->thirdparty->id,
1971 "'".$this->db->escape($product->ref_fourn)."'",
1972 (float) $price,
1973 (float) $qty,
1974 (float) $unitPrice,
1975 (float) $product->tva_tx,
1976 (int) $user->id
1977 );
1978 if (isModEnabled("multicurrency")) {
1979 if (!empty($product->multicurrency_code)) {
1980 include_once DOL_DOCUMENT_ROOT.'/multicurrency/class/multicurrency.class.php';
1981 $multicurrency = new MultiCurrency($this->db); //need to fetch because empty fk_multicurrency and rate
1982 $multicurrency->fetch(0, $product->multicurrency_code);
1983 if (!empty($multicurrency->id)) {
1984 $values[] = (int) $multicurrency->id;
1985 $values[] = "'".$this->db->escape($product->multicurrency_code)."'";
1986 $values[] = (float) $product->multicurrency_subprice;
1987 $values[] = (float) $product->multicurrency_total_ht;
1988 $values[] = (float) $multicurrency->rate->rate;
1989 } else {
1990 for ($i = 0; $i < 5; $i++) {
1991 $values[] = 'NULL';
1992 }
1993 }
1994 }
1995 }
1996
1997 $sql = 'INSERT INTO '.MAIN_DB_PREFIX.'product_fournisseur_price ';
1998 $sql .= '(datec, fk_product, fk_soc, ref_fourn, price, quantity, unitprice, tva_tx, fk_user';
1999 if (isModEnabled("multicurrency") && !empty($product->multicurrency_code)) {
2000 $sql .= ',fk_multicurrency, multicurrency_code, multicurrency_unitprice, multicurrency_price, multicurrency_tx';
2001 }
2002 $sql .= ') VALUES ('.implode(',', $values).')';
2003
2004 $resql = $this->db->query($sql);
2005 if (!$resql) {
2006 $this->error = $this->db->error();
2007 $this->db->rollback();
2008 return -1;
2009 }
2010 return 1;
2011 }
2012
2013 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2020 public function setDraft($user)
2021 {
2022 // phpcs:enable
2023 global $conf, $langs;
2024
2025 $error = 0;
2026
2027 if ($this->status == self::STATUS_DRAFT) {
2028 dol_syslog(get_class($this)."::setDraft already draft status", LOG_WARNING);
2029 return 0;
2030 }
2031
2032 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposal";
2033 $sql .= " SET fk_statut = ".self::STATUS_DRAFT;
2034 $sql .= " WHERE rowid = ".((int) $this->id);
2035
2036 if ($this->db->query($sql)) {
2037 if (!$error) {
2038 $this->oldcopy = clone $this;
2039 }
2040
2041 if (!$error) {
2042 // Call trigger
2043 $result = $this->call_trigger('PROPOSAL_SUPPLIER_UNVALIDATE', $user);
2044 if ($result < 0) {
2045 $error++;
2046 }
2047 }
2048
2049 if (!$error) {
2050 $this->status = self::STATUS_DRAFT;
2051 $this->statut = self::STATUS_DRAFT; // deprecated
2052 $this->db->commit();
2053 return 1;
2054 } else {
2055 $this->db->rollback();
2056 return -1;
2057 }
2058 } else {
2059 return -1;
2060 }
2061 }
2062
2063
2064 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2078 public function liste_array($shortlist = 0, $draft = 0, $notcurrentuser = 0, $socid = 0, $limit = 0, $offset = 0, $sortfield = 'p.datec', $sortorder = 'DESC')
2079 {
2080 // phpcs:enable
2081 global $user;
2082
2083 $ga = array();
2084
2085 $search_sale = 0;
2086 if (empty($user->socid) && !$user->hasRight('societe', 'client', 'voir')) {
2087 $search_sale = $user->id;
2088 }
2089
2090 $sql = "SELECT s.rowid, s.nom as name, s.client,";
2091 $sql .= " p.rowid as supplier_proposalid, p.fk_statut, p.total_ht, p.ref, p.remise, ";
2092 $sql .= " p.datep as dp, p.fin_validite as datelimite";
2093 $sql .= " FROM ".MAIN_DB_PREFIX."societe as s, ".MAIN_DB_PREFIX."supplier_proposal as p, ".MAIN_DB_PREFIX."c_propalst as c";
2094 $sql .= " WHERE p.entity IN (".getEntity('supplier_proposal').")";
2095 $sql .= " AND p.fk_soc = s.rowid";
2096 $sql .= " AND p.fk_statut = c.id";
2097 if ($socid) {
2098 $sql .= " AND s.rowid = ".((int) $socid);
2099 }
2100 if ($draft) {
2101 $sql .= " AND p.fk_statut = 0";
2102 }
2103 if ($notcurrentuser > 0) {
2104 $sql .= " AND p.fk_user_author <> ".((int) $user->id);
2105 }
2106 // Search on sale representative
2107 if ($search_sale && $search_sale != '-1') {
2108 if ($search_sale == -2) {
2109 $sql .= " AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = p.fk_soc)";
2110 } elseif ($search_sale > 0) {
2111 $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).")";
2112 }
2113 }
2114 $sql .= $this->db->order($sortfield, $sortorder);
2115 $sql .= $this->db->plimit($limit, $offset);
2116
2117 $result = $this->db->query($sql);
2118 if ($result) {
2119 $num = $this->db->num_rows($result);
2120 if ($num) {
2121 $i = 0;
2122 while ($i < $num) {
2123 $obj = $this->db->fetch_object($result);
2124
2125 if ($shortlist == 1) {
2126 $ga[$obj->supplier_proposalid] = $obj->ref;
2127 } elseif ($shortlist == 2) {
2128 $ga[$obj->supplier_proposalid] = $obj->ref.' ('.$obj->name.')';
2129 } else {
2130 $ga[$i]['id'] = $obj->supplier_proposalid;
2131 $ga[$i]['ref'] = $obj->ref;
2132 $ga[$i]['name'] = $obj->name;
2133 }
2134
2135 $i++;
2136 }
2137 }
2138 return $ga;
2139 } else {
2140 dol_print_error($this->db);
2141 return -1;
2142 }
2143 }
2144
2152 public function delete($user, $notrigger = 0)
2153 {
2154 global $conf, $langs;
2155 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
2156
2157 $error = 0;
2158
2159 $this->db->begin();
2160
2161 if (!$notrigger) {
2162 // Call trigger
2163 $result = $this->call_trigger('PROPOSAL_SUPPLIER_DELETE', $user);
2164 if ($result < 0) {
2165 $error++;
2166 }
2167 // End call triggers
2168 }
2169
2170 if (!$error) {
2171 $main = MAIN_DB_PREFIX.'supplier_proposaldet';
2172 $ef = $main."_extrafields";
2173 $sqlef = "DELETE FROM $ef WHERE fk_object IN (SELECT rowid FROM $main WHERE fk_supplier_proposal = ".((int) $this->id).")";
2174 $sql = "DELETE FROM ".MAIN_DB_PREFIX."supplier_proposaldet WHERE fk_supplier_proposal = ".((int) $this->id);
2175 if ($this->db->query($sql)) {
2176 $sql = "DELETE FROM ".MAIN_DB_PREFIX."supplier_proposal WHERE rowid = ".((int) $this->id);
2177 if ($this->db->query($sqlef) && $this->db->query($sql)) {
2178 // Delete linked object
2179 $res = $this->deleteObjectLinked();
2180 if ($res < 0) {
2181 $error++;
2182 }
2183
2184 if (!$error) {
2185 // Delete record into ECM index (Note that delete is also done when deleting files with the dol_delete_dir_recursive
2186 $this->deleteEcmFiles(0); // Deleting files physically is done later with the dol_delete_dir_recursive
2187 $this->deleteEcmFiles(1); // Deleting files physically is done later with the dol_delete_dir_recursive
2188
2189 // We remove directory
2190 $ref = dol_sanitizeFileName($this->ref);
2191 if ($conf->supplier_proposal->dir_output && !empty($this->ref)) {
2192 $dir = $conf->supplier_proposal->dir_output."/".$ref;
2193 $file = $dir."/".$ref.".pdf";
2194 if (file_exists($file)) {
2195 dol_delete_preview($this);
2196
2197 if (!dol_delete_file($file, 0, 0, 0, $this)) { // For triggers
2198 $this->error = 'ErrorFailToDeleteFile';
2199 $this->errors = array('ErrorFailToDeleteFile');
2200 $this->db->rollback();
2201 return 0;
2202 }
2203 }
2204 if (file_exists($dir)) {
2205 $res = @dol_delete_dir_recursive($dir);
2206 if (!$res) {
2207 $this->error = 'ErrorFailToDeleteDir';
2208 $this->errors = array('ErrorFailToDeleteDir');
2209 $this->db->rollback();
2210 return 0;
2211 }
2212 }
2213 }
2214 }
2215
2216 // Removed extrafields
2217 if (!$error) {
2218 $result = $this->deleteExtraFields();
2219 if ($result < 0) {
2220 $error++;
2221 $errorflag = -4;
2222 dol_syslog(get_class($this)."::delete erreur ".$errorflag." ".$this->error, LOG_ERR);
2223 }
2224 }
2225
2226 if (!$error) {
2227 dol_syslog(get_class($this)."::delete ".$this->id." by ".$user->id, LOG_DEBUG);
2228 $this->db->commit();
2229 return 1;
2230 } else {
2231 $this->error = $this->db->lasterror();
2232 $this->db->rollback();
2233 return 0;
2234 }
2235 } else {
2236 $this->error = $this->db->lasterror();
2237 $this->db->rollback();
2238 return -3;
2239 }
2240 } else {
2241 $this->error = $this->db->lasterror();
2242 $this->db->rollback();
2243 return -2;
2244 }
2245 } else {
2246 $this->db->rollback();
2247 return -1;
2248 }
2249 }
2250
2257 public function info($id)
2258 {
2259 $sql = "SELECT c.rowid, ";
2260 $sql .= " c.datec as date_creation, c.date_valid as date_validation, c.date_cloture as date_closure,";
2261 $sql .= " c.fk_user_author, c.fk_user_valid, c.fk_user_cloture";
2262 $sql .= " FROM ".MAIN_DB_PREFIX."supplier_proposal as c";
2263 $sql .= " WHERE c.rowid = ".((int) $id);
2264
2265 $result = $this->db->query($sql);
2266
2267 if ($result) {
2268 if ($this->db->num_rows($result)) {
2269 $obj = $this->db->fetch_object($result);
2270
2271 $this->id = $obj->rowid;
2272
2273 $this->date_creation = $this->db->jdate($obj->date_creation);
2274 $this->date_validation = $this->db->jdate($obj->date_validation);
2275 $this->date_cloture = $this->db->jdate($obj->date_closure);
2276
2277 $this->user_creation_id = $obj->fk_user_author;
2278 $this->user_validation_id = $obj->fk_user_valid;
2279 $this->user_closing_id = $obj->fk_user_cloture;
2280 }
2281 $this->db->free($result);
2282 } else {
2283 dol_print_error($this->db);
2284 }
2285 }
2286
2287
2294 public function getLibStatut($mode = 0)
2295 {
2296 return $this->LibStatut((isset($this->status) ? $this->status : $this->statut), $mode);
2297 }
2298
2299 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2307 public function LibStatut($status, $mode = 1)
2308 {
2309 // phpcs:enable
2310
2311 // Init/load array of translation of status
2312 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
2313 global $langs;
2314 $langs->load("supplier_proposal");
2315 $this->labelStatus[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv("SupplierProposalStatusDraft");
2316 $this->labelStatus[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv("SupplierProposalStatusValidated");
2317 $this->labelStatus[self::STATUS_SIGNED] = $langs->transnoentitiesnoconv("SupplierProposalStatusSigned");
2318 $this->labelStatus[self::STATUS_NOTSIGNED] = $langs->transnoentitiesnoconv("SupplierProposalStatusNotSigned");
2319 $this->labelStatus[self::STATUS_CLOSE] = $langs->transnoentitiesnoconv("SupplierProposalStatusClosed");
2320 $this->labelStatusShort[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv("SupplierProposalStatusDraftShort");
2321 $this->labelStatusShort[self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv("SupplierProposalStatusValidatedShort");
2322 $this->labelStatusShort[self::STATUS_SIGNED] = $langs->transnoentitiesnoconv("SupplierProposalStatusSignedShort");
2323 $this->labelStatusShort[self::STATUS_NOTSIGNED] = $langs->transnoentitiesnoconv("SupplierProposalStatusNotSignedShort");
2324 $this->labelStatusShort[self::STATUS_CLOSE] = $langs->transnoentitiesnoconv("SupplierProposalStatusClosedShort");
2325 }
2326
2327 $statusnew = '';
2328 if ($status == self::STATUS_DRAFT) {
2329 $statusnew = 'status0';
2330 } elseif ($status == self::STATUS_VALIDATED) {
2331 $statusnew = 'status1';
2332 } elseif ($status == self::STATUS_SIGNED) {
2333 $statusnew = 'status4';
2334 } elseif ($status == self::STATUS_NOTSIGNED) {
2335 $statusnew = 'status9';
2336 } elseif ($status == self::STATUS_CLOSE) {
2337 $statusnew = 'status6';
2338 }
2339
2340 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status], '', $statusnew, $mode);
2341 }
2342
2343
2344 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
2352 public function load_board($user, $mode)
2353 {
2354 // phpcs:enable
2355 global $conf, $langs;
2356
2357 $now = dol_now();
2358
2359 $clause = " WHERE";
2360
2361 $sql = "SELECT p.rowid, p.ref, p.datec as datec, p.date_cloture as datefin";
2362 $sql .= " FROM ".MAIN_DB_PREFIX."supplier_proposal as p";
2363 if (empty($user->socid) && !$user->hasRight('societe', 'client', 'voir')) {
2364 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON p.fk_soc = sc.fk_soc";
2365 $sql .= " WHERE sc.fk_user = ".((int) $user->id);
2366 $clause = " AND";
2367 }
2368 $sql .= $clause." p.entity IN (".getEntity('supplier_proposal').")";
2369 if ($mode == 'opened') {
2370 $sql .= " AND p.fk_statut = 1";
2371 }
2372 if ($mode == 'signed') {
2373 $sql .= " AND p.fk_statut = 2";
2374 }
2375 if ($user->socid) {
2376 $sql .= " AND p.fk_soc = ".((int) $user->socid);
2377 }
2378
2379 $resql = $this->db->query($sql);
2380 if ($resql) {
2381 $label = $labelShort = '';
2382 $status = '';
2383 $delay_warning = 0;
2384 if ($mode == 'opened') {
2385 $delay_warning = !empty($conf->supplier_proposal->cloture->warning_delay) ? $conf->supplier_proposal->cloture->warning_delay : 0;
2386 $status = self::STATUS_VALIDATED;
2387 $label = $langs->trans("SupplierProposalsToClose");
2388 $labelShort = $langs->trans("ToAcceptRefuse");
2389 }
2390 if ($mode == 'signed') {
2391 $delay_warning = !empty($conf->supplier_proposal->facturation->warning_delay) ? $conf->supplier_proposal->facturation->warning_delay : 0;
2392 $status = self::STATUS_SIGNED;
2393 $label = $langs->trans("SupplierProposalsToProcess"); // May be billed or ordered
2394 $labelShort = $langs->trans("ToClose");
2395 }
2396
2397 $response = new WorkboardResponse();
2398 $response->warning_delay = $delay_warning / 60 / 60 / 24;
2399 $response->label = $label;
2400 $response->labelShort = $labelShort;
2401 $response->url = DOL_URL_ROOT.'/supplier_proposal/list.php?search_status='.$status;
2402 $response->img = img_object('', "propal");
2403
2404 // This assignment in condition is not a bug. It allows walking the results.
2405 while ($obj = $this->db->fetch_object($resql)) {
2406 $response->nbtodo++;
2407 if ($mode == 'opened') {
2408 $datelimit = $this->db->jdate($obj->datefin);
2409 if ($datelimit < ($now - $delay_warning)) {
2410 $response->nbtodolate++;
2411 }
2412 }
2413 // TODO Definir regle des propales a facturer en retard
2414 // if ($mode == 'signed' && ! count($this->FactureListeArray($obj->rowid))) $this->nbtodolate++;
2415 }
2416 return $response;
2417 } else {
2418 $this->error = $this->db->lasterror();
2419 return -1;
2420 }
2421 }
2422
2423
2431 public function initAsSpecimen()
2432 {
2433 global $user, $langs, $conf;
2434
2435 // Load array of products prodids
2436 $num_prods = 0;
2437 $prodids = array();
2438 $sql = "SELECT rowid";
2439 $sql .= " FROM ".MAIN_DB_PREFIX."product";
2440 $sql .= " WHERE entity IN (".getEntity('product').")";
2441 $sql .= $this->db->plimit(100);
2442
2443 $resql = $this->db->query($sql);
2444 if ($resql) {
2445 $num_prods = $this->db->num_rows($resql);
2446 $i = 0;
2447 while ($i < $num_prods) {
2448 $i++;
2449 $row = $this->db->fetch_row($resql);
2450 $prodids[$i] = $row[0];
2451 }
2452 }
2453
2454 // Initialise parameters
2455 $this->id = 0;
2456 $this->ref = 'SPECIMEN';
2457 $this->specimen = 1;
2458 $this->socid = 1;
2459 $this->date = time();
2460 $this->cond_reglement_id = 1;
2461 $this->cond_reglement_code = 'RECEP';
2462 $this->mode_reglement_id = 7;
2463 $this->mode_reglement_code = 'CHQ';
2464 $this->note_public = 'This is a comment (public)';
2465 $this->note_private = 'This is a comment (private)';
2466 // Lines
2467 $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)
2468 $xnbp = 0;
2469 while ($xnbp < $nbp) {
2470 $line = new SupplierProposalLine($this->db);
2471 $line->desc = $langs->trans("Description")." ".$xnbp;
2472 $line->qty = 1;
2473 $line->subprice = 100;
2474 $line->tva_tx = 19.6;
2475 $line->localtax1_tx = 0;
2476 $line->localtax2_tx = 0;
2477 if ($xnbp == 2) {
2478 $line->total_ht = 50;
2479 $line->total_ttc = 59.8;
2480 $line->total_tva = 9.8;
2481 $line->remise_percent = 50;
2482 } else {
2483 $line->total_ht = 100;
2484 $line->total_ttc = 119.6;
2485 $line->total_tva = 19.6;
2486 $line->remise_percent = 00;
2487 }
2488
2489 if ($num_prods > 0) {
2490 $prodid = mt_rand(1, $num_prods);
2491 $line->fk_product = $prodids[$prodid];
2492 }
2493
2494 $this->lines[$xnbp] = $line;
2495
2496 $this->total_ht += $line->total_ht;
2497 $this->total_tva += $line->total_tva;
2498 $this->total_ttc += $line->total_ttc;
2499
2500 $xnbp++;
2501 }
2502
2503 return 1;
2504 }
2505
2511 public function loadStateBoard()
2512 {
2513 global $conf, $user;
2514
2515 $this->nb = array();
2516 $clause = "WHERE";
2517
2518 $sql = "SELECT count(p.rowid) as nb";
2519 $sql .= " FROM ".MAIN_DB_PREFIX."supplier_proposal as p";
2520 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s ON p.fk_soc = s.rowid";
2521 if (empty($user->socid) && !$user->hasRight('societe', 'client', 'voir')) {
2522 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON s.rowid = sc.fk_soc";
2523 $sql .= " WHERE sc.fk_user = ".((int) $user->id);
2524 $clause = "AND";
2525 }
2526 $sql .= " ".$clause." p.entity IN (".getEntity('supplier_proposal').")";
2527
2528 $resql = $this->db->query($sql);
2529 if ($resql) {
2530 // This assignment in condition is not a bug. It allows walking the results.
2531 while ($obj = $this->db->fetch_object($resql)) {
2532 $this->nb["supplier_proposals"] = $obj->nb;
2533 }
2534 $this->db->free($resql);
2535 return 1;
2536 } else {
2537 dol_print_error($this->db);
2538 $this->error = $this->db->lasterror();
2539 return -1;
2540 }
2541 }
2542
2543
2551 public function getNextNumRef($soc)
2552 {
2553 global $conf, $db, $langs;
2554 $langs->load("supplier_proposal");
2555
2556 if (getDolGlobalString('SUPPLIER_PROPOSAL_ADDON')) {
2557 $mybool = false;
2558
2559 $file = getDolGlobalString('SUPPLIER_PROPOSAL_ADDON') . ".php";
2560 $classname = getDolGlobalString('SUPPLIER_PROPOSAL_ADDON');
2561
2562 // Include file with class
2563 $dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
2564 foreach ($dirmodels as $reldir) {
2565 $dir = dol_buildpath($reldir."core/modules/supplier_proposal/");
2566
2567 // Load file with numbering class (if found)
2568 $mybool = ((bool) @include_once $dir.$file) || $mybool;
2569 }
2570
2571 if (!$mybool) {
2572 dol_print_error(null, "Failed to include file ".$file);
2573 return '';
2574 }
2575
2576 $obj = new $classname();
2577 '@phan-var-force ModeleNumRefSupplierProposal $obj';
2578 $numref = "";
2579 $numref = $obj->getNextValue($soc, $this);
2580
2581 if ($numref != "") {
2582 return $numref;
2583 } else {
2584 $this->error = $obj->error;
2585 return "";
2586 }
2587 } else {
2588 $langs->load("errors");
2589 print $langs->trans("Error")." ".$langs->trans("ErrorModuleSetupNotComplete", $langs->transnoentitiesnoconv("SupplierProposal"));
2590 return "";
2591 }
2592 }
2593
2600 public function getTooltipContentArray($params)
2601 {
2602 global $conf, $langs, $menumanager;
2603
2604 $langs->load('supplier_proposal');
2605
2606 if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
2607 return ['optimize' => $langs->trans("ShowSupplierProposal")];
2608 }
2609
2610 $option = $params['option'] ?? '';
2611 $datas = [];
2612
2613 $datas['picto'] = img_picto('', $this->picto).' <u class="paddingrightonly">'.$langs->trans("SupplierProposal").'</u>';
2614 if (isset($this->status)) {
2615 $datas['picto'] .= ' '.$this->getLibStatut(5);
2616 }
2617 if (!empty($this->ref)) {
2618 $datas['ref'] = '<br><b>'.$langs->trans('Ref').':</b> '.$this->ref;
2619 }
2620 if (!empty($this->ref_fourn)) {
2621 $datas['ref_supplier'] = '<br><b>'.$langs->trans('RefSupplier').':</b> '.$this->ref_fourn;
2622 }
2623 if (!empty($this->total_ht)) {
2624 $datas['amount_ht'] = '<br><b>'.$langs->trans('AmountHT').':</b> '.price($this->total_ht, 0, $langs, 0, -1, -1, $conf->currency);
2625 }
2626 if (!empty($this->total_tva)) {
2627 $datas['amount_vat'] = '<br><b>'.$langs->trans('VAT').':</b> '.price($this->total_tva, 0, $langs, 0, -1, -1, $conf->currency);
2628 }
2629 if (!empty($this->total_ttc)) {
2630 $datas['amount_ttc'] = '<br><b>'.$langs->trans('AmountTTC').':</b> '.price($this->total_ttc, 0, $langs, 0, -1, -1, $conf->currency);
2631 }
2632
2633 return $datas;
2634 }
2635
2647 public function getNomUrl($withpicto = 0, $option = '', $get_params = '', $notooltip = 0, $save_lastsearch_value = -1, $addlinktonotes = 0)
2648 {
2649 global $langs, $conf, $user, $hookmanager;
2650
2651 if (!empty($conf->dol_no_mouse_hover)) {
2652 $notooltip = 1; // Force disable tooltips
2653 }
2654
2655 $url = '';
2656 $result = '';
2657 $params = [
2658 'id' => $this->id,
2659 'objecttype' => $this->element,
2660 'option' => $option,
2661 ];
2662 $classfortooltip = 'classfortooltip';
2663 $dataparams = '';
2664 if (getDolGlobalInt('MAIN_ENABLE_AJAX_TOOLTIP')) {
2665 $classfortooltip = 'classforajaxtooltip';
2666 $dataparams = ' data-params="'.dol_escape_htmltag(json_encode($params)).'"';
2667 $label = '';
2668 } else {
2669 $label = implode($this->getTooltipContentArray($params));
2670 }
2671
2672 if ($option == '') {
2673 $url = DOL_URL_ROOT.'/supplier_proposal/card.php?id='.$this->id.$get_params;
2674 }
2675 if ($option == 'document') {
2676 $url = DOL_URL_ROOT.'/supplier_proposal/document.php?id='.$this->id.$get_params;
2677 }
2678
2679 if ($option !== 'nolink') {
2680 // Add param to save lastsearch_values or not
2681 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
2682 if ($save_lastsearch_value == -1 && isset($_SERVER["PHP_SELF"]) && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
2683 $add_save_lastsearch_values = 1;
2684 }
2685 if ($add_save_lastsearch_values) {
2686 $url .= '&save_lastsearch_values=1';
2687 }
2688 }
2689
2690 $linkclose = '';
2691 if (empty($notooltip) && $user->hasRight('propal', 'lire')) {
2692 if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
2693 $label = $langs->trans("ShowSupplierProposal");
2694 $linkclose .= ' alt="'.dolPrintHTMLForAttribute($label).'"';
2695 }
2696 $linkclose .= ($label ? ' title="'.dolPrintHTMLForAttribute($label).'"' : ' title="tocomplete"');
2697 $linkclose .= $dataparams.' class="'.$classfortooltip.'"';
2698 }
2699
2700 $linkstart = '<a href="'.$url.'"';
2701 $linkstart .= $linkclose.'>';
2702 $linkend = '</a>';
2703
2704 $result .= $linkstart;
2705 if ($withpicto) {
2706 $result .= img_object(($notooltip ? '' : $label), ($this->picto ? $this->picto : 'generic'), (($withpicto != 2) ? 'class="paddingright"' : ''), 0, 0, $notooltip ? 0 : 1);
2707 }
2708 if ($withpicto != 2) {
2709 $result .= $this->ref;
2710 }
2711 $result .= $linkend;
2712
2713 if ($addlinktonotes) {
2714 $txttoshow = ($user->socid > 0 ? $this->note_public : $this->note_private);
2715 if ($txttoshow) {
2716 $notetoshow = $langs->trans("ViewPrivateNote").':<br>'.dol_string_nohtmltag($txttoshow, 1);
2717 $result .= ' <span class="note inline-block">';
2718 $result .= '<a href="'.DOL_URL_ROOT.'/supplier_proposal/note.php?id='.$this->id.'" class="classfortooltip" title="'.dol_escape_htmltag($notetoshow).'">';
2719 $result .= img_picto('', 'note');
2720 $result .= '</a>';
2721 //$result.=img_picto($langs->trans("ViewNote"),'object_generic');
2722 //$result.='</a>';
2723 $result .= '</span>';
2724 }
2725 }
2726 global $action;
2727 $hookmanager->initHooks(array($this->element . 'dao'));
2728 $parameters = array('id' => $this->id, 'getnomurl' => &$result);
2729 $reshook = $hookmanager->executeHooks('getNomUrl', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
2730 if ($reshook > 0) {
2731 $result = $hookmanager->resPrint;
2732 } else {
2733 $result .= $hookmanager->resPrint;
2734 }
2735 return $result;
2736 }
2737
2743 public function getLinesArray()
2744 {
2745 // For other object, here we call fetch_lines. But fetch_lines does not exists on supplier proposal
2746
2747 $sql = 'SELECT pt.rowid, pt.label as custom_label, pt.description, pt.fk_product, pt.fk_remise_except,';
2748 $sql .= ' pt.qty, pt.tva_tx, pt.vat_src_code, pt.remise_percent, pt.subprice, pt.info_bits,';
2749 $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,';
2750 $sql .= ' pt.product_type, pt.rang, pt.fk_parent_line, pt.extraparams,';
2751 $sql .= ' p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid,';
2752 $sql .= ' p.description as product_desc, pt.ref_fourn as ref_supplier,';
2753 $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';
2754 $sql .= ' FROM '.MAIN_DB_PREFIX.'supplier_proposaldet as pt';
2755 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product as p ON pt.fk_product=p.rowid';
2756 $sql .= ' WHERE pt.fk_supplier_proposal = '.((int) $this->id);
2757 $sql .= ' ORDER BY pt.rang ASC, pt.rowid';
2758
2759 dol_syslog(get_class($this).'::getLinesArray', LOG_DEBUG);
2760 $resql = $this->db->query($sql);
2761 if ($resql) {
2762 $num = $this->db->num_rows($resql);
2763 $i = 0;
2764
2765 while ($i < $num) {
2766 $obj = $this->db->fetch_object($resql);
2767
2768 $this->lines[$i] = new SupplierProposalLine($this->db);
2769 $this->lines[$i]->id = $obj->rowid; // for backward compatibility
2770 $this->lines[$i]->rowid = $obj->rowid;
2771 $this->lines[$i]->fetch_optionals();
2772 $this->lines[$i]->label = $obj->custom_label;
2773 $this->lines[$i]->description = $obj->description;
2774 $this->lines[$i]->fk_product = $obj->fk_product;
2775 $this->lines[$i]->ref = $obj->ref;
2776 $this->lines[$i]->product_label = $obj->product_label;
2777 $this->lines[$i]->product_desc = $obj->product_desc;
2778 $this->lines[$i]->fk_product_type = $obj->fk_product_type; // deprecated
2779 $this->lines[$i]->product_type = $obj->product_type;
2780 $this->lines[$i]->qty = $obj->qty;
2781 $this->lines[$i]->subprice = $obj->subprice;
2782 $this->lines[$i]->fk_remise_except = $obj->fk_remise_except;
2783 $this->lines[$i]->remise_percent = $obj->remise_percent;
2784 $this->lines[$i]->tva_tx = $obj->tva_tx;
2785 $this->lines[$i]->vat_src_code = $obj->vat_src_code;
2786 $this->lines[$i]->info_bits = $obj->info_bits;
2787 $this->lines[$i]->total_ht = $obj->total_ht;
2788 $this->lines[$i]->total_tva = $obj->total_tva;
2789 $this->lines[$i]->total_ttc = $obj->total_ttc;
2790 $this->lines[$i]->fk_fournprice = $obj->fk_fournprice;
2791 $marginInfos = getMarginInfos($obj->subprice, $obj->remise_percent, $obj->tva_tx, $obj->localtax1_tx, $obj->localtax2_tx, $this->lines[$i]->fk_fournprice, $obj->pa_ht);
2792 $this->lines[$i]->pa_ht = $marginInfos[0];
2793 $this->lines[$i]->marge_tx = $marginInfos[1];
2794 $this->lines[$i]->marque_tx = $marginInfos[2];
2795 $this->lines[$i]->fk_parent_line = $obj->fk_parent_line;
2796 $this->lines[$i]->special_code = $obj->special_code;
2797 $this->lines[$i]->rang = $obj->rang;
2798
2799 $this->lines[$i]->ref_fourn = $obj->ref_supplier; // deprecated
2800 $this->lines[$i]->ref_supplier = $obj->ref_supplier;
2801
2802 $this->extraparams = !empty($obj->extraparams) ? (array) json_decode($obj->extraparams, true) : array();
2803
2804 // Multicurrency
2805 $this->lines[$i]->fk_multicurrency = $obj->fk_multicurrency;
2806 $this->lines[$i]->multicurrency_code = $obj->multicurrency_code;
2807 $this->lines[$i]->multicurrency_subprice = $obj->multicurrency_subprice;
2808 $this->lines[$i]->multicurrency_total_ht = $obj->multicurrency_total_ht;
2809 $this->lines[$i]->multicurrency_total_tva = $obj->multicurrency_total_tva;
2810 $this->lines[$i]->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
2811 $this->lines[$i]->fk_unit = $obj->fk_unit;
2812
2813 $i++;
2814 }
2815 $this->db->free($resql);
2816
2817 return 1;
2818 } else {
2819 $this->error = $this->db->error();
2820 return -1;
2821 }
2822 }
2823
2835 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams = null)
2836 {
2837 global $langs;
2838
2839 $langs->load("supplier_proposal");
2840 $outputlangs->load("products");
2841
2842 if (!dol_strlen($modele)) {
2843 $modele = ''; // On supplier documents, template can be empty( no doc generated in this case)
2844
2845 if ($this->model_pdf) {
2846 $modele = $this->model_pdf;
2847 } elseif (getDolGlobalString('SUPPLIER_PROPOSAL_ADDON_PDF')) {
2848 $modele = getDolGlobalString('SUPPLIER_PROPOSAL_ADDON_PDF');
2849 }
2850 }
2851
2852 if (empty($modele)) {
2853 return 1;
2854 }
2855
2856 $modelpath = "core/modules/supplier_proposal/doc/";
2857
2858 return $this->commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
2859 }
2860
2861
2870 public static function replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
2871 {
2872 $tables = array(
2873 'supplier_proposal'
2874 );
2875
2876 return CommonObject::commonReplaceThirdparty($dbs, $origin_id, $dest_id, $tables);
2877 }
2878
2887 public static function replaceProduct(DoliDB $db, $origin_id, $dest_id)
2888 {
2889 $tables = array(
2890 'supplier_proposaldet'
2891 );
2892
2893 return CommonObject::commonReplaceProduct($db, $origin_id, $dest_id, $tables);
2894 }
2895
2896
2904 public function getKanbanView($option = '', $arraydata = null)
2905 {
2906 global $langs;
2907
2908 $selected = (empty($arraydata['selected']) ? 0 : $arraydata['selected']);
2909
2910 $return = '<div class="box-flex-item box-flex-grow-zero">';
2911 $return .= '<div class="info-box info-box-sm">';
2912 $return .= '<span class="info-box-icon bg-infobox-action">';
2913 $return .= img_picto('', $this->picto);
2914 //$return .= '<i class="fa fa-dol-action"></i>'; // Can be image
2915 $return .= '</span>';
2916 $return .= '<div class="info-box-content">';
2917 $return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this, 'getNomUrl') ? $this->getNomUrl() : $this->ref).'</span>';
2918 if ($selected >= 0) {
2919 $return .= '<input id="cb'.$this->id.'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->id.'"'.($selected ? ' checked="checked"' : '').'>';
2920 }
2921 if (property_exists($this, 'socid')) {
2922 $return .= '<span class="info-box-ref"> | '.$this->socid.'</span>';
2923 }
2924 if (property_exists($this, 'delivery_date')) {
2925 $return .= '<br><span class="opacitymedium">'.$langs->trans("DateEnd").'</span> : <span class="info-box-label">'.dol_print_date($this->delivery_date).'</span>';
2926 }
2927 if (property_exists($this, 'total_ttc')) {
2928 $return .= '<br><span class="opacitymedium" >'.$langs->trans("AmountHT").' : </span><span class="info-box-label amount">'.price($this->total_ttc).'</span>';
2929 }
2930 if (method_exists($this, 'getLibStatut')) {
2931 $return .= '<br><div class="info-box-status">'.$this->getLibStatut(3).'</div>';
2932 }
2933 $return .= '</div>';
2934 $return .= '</div>';
2935 $return .= '</div>';
2936 return $return;
2937 }
2938}
2939
2940
2945{
2949 public $db;
2950
2954 public $error = '';
2955
2959 public $element = 'supplier_proposaldet';
2960
2964 public $table_element = 'supplier_proposaldet';
2965
2969 public $parent_element = 'supplier_proposal';
2970
2974 public $fk_parent_attribute = 'fk_supplier_proposal';
2975
2979 public $oldline;
2980
2984 public $id;
2985
2989 public $fk_supplier_proposal;
2990
2994 public $fk_parent_line;
2995
2999 public $desc; // Description ligne
3000
3004 public $fk_product; // Id produit predefini
3005
3011 public $fk_product_type;
3017 public $product_type = Product::TYPE_PRODUCT;
3018
3022 public $qty;
3026 public $tva_tx;
3030 public $vat_src_code;
3031
3036 public $subprice;
3040 public $remise_percent;
3041
3045 public $fk_remise_except;
3046
3050 public $rang = 0;
3051
3055 public $fk_fournprice;
3056
3060 public $pa_ht;
3064 public $marge_tx;
3068 public $marque_tx;
3069
3073 public $special_code; // Tag for special lines (exclusive tags)
3074 // 1: frais de port
3075 // 2: ecotaxe
3076 // 3: option line (when qty = 0)
3077
3081 public $info_bits = 0; // Liste d'options cumulables:
3082 // Bit 0: 0 si TVA normal - 1 if TVA NPR
3083 // Bit 1: 0 ligne normal - 1 if fixed reduction
3084
3088 public $total_ht; // Total HT de la ligne toute quantite et incluant la remise ligne
3092 public $total_tva; // Total TVA de la ligne toute quantite et incluant la remise ligne
3096 public $total_ttc; // Total TTC de la ligne toute quantite et incluant la remise ligne
3097
3101 public $date_start;
3105 public $date_end;
3106
3107 // From llx_product
3113 public $ref;
3114
3119 public $product_ref;
3120
3126 public $libelle;
3127
3132 public $product_label;
3133
3138 public $label;
3139
3144 public $product_desc;
3145
3149 public $localtax1_tx; // Local tax 1
3153 public $localtax2_tx; // Local tax 2
3157 public $localtax1_type; // Local tax 1 type
3161 public $localtax2_type; // Local tax 2 type
3165 public $total_localtax1; // Line total local tax 1
3169 public $total_localtax2; // Line total local tax 2
3170
3174 public $skip_update_total; // Skip update price total for special lines
3175
3179 public $ref_fourn;
3183 public $ref_supplier;
3184
3185 // Multicurrency
3189 public $fk_multicurrency;
3190
3194 public $multicurrency_code;
3198 public $multicurrency_subprice;
3202 public $multicurrency_total_ht;
3206 public $multicurrency_total_tva;
3210 public $multicurrency_total_ttc;
3211
3217 public function __construct($db)
3218 {
3219 $this->db = $db;
3220 }
3221
3228 public function fetch($rowid)
3229 {
3230 $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,';
3231 $sql .= ' pd.date_start, pd.date_end,';
3232 $sql .= ' pd.remise, pd.remise_percent, pd.fk_remise_except, pd.subprice,';
3233 $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,';
3234 $sql .= ' pd.localtax1_tx, pd.localtax2_tx, pd.total_localtax1, pd.total_localtax2,';
3235 $sql .= ' p.ref as product_ref, p.label as product_label, p.description as product_desc,';
3236 $sql .= ' pd.product_type, pd.ref_fourn as ref_produit_fourn, pd.extraparams,';
3237 $sql .= ' pd.fk_multicurrency, pd.multicurrency_code, pd.multicurrency_subprice, pd.multicurrency_total_ht, pd.multicurrency_total_tva, pd.multicurrency_total_ttc, pd.fk_unit';
3238 $sql .= ' FROM '.MAIN_DB_PREFIX.'supplier_proposaldet as pd';
3239 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'product as p ON pd.fk_product = p.rowid';
3240 $sql .= ' WHERE pd.rowid = '.((int) $rowid);
3241
3242 $result = $this->db->query($sql);
3243 if ($result) {
3244 if ($objp = $this->db->fetch_object($result)) {
3245 $this->id = $objp->rowid;
3246 $this->fk_supplier_proposal = $objp->fk_supplier_proposal;
3247 $this->fk_parent_line = $objp->fk_parent_line;
3248 $this->label = $objp->custom_label;
3249 $this->desc = $objp->description;
3250 $this->qty = $objp->qty;
3251 $this->subprice = $objp->subprice;
3252 $this->tva_tx = $objp->tva_tx;
3253 $this->remise_percent = $objp->remise_percent;
3254 $this->fk_remise_except = $objp->fk_remise_except;
3255 $this->fk_product = $objp->fk_product;
3256 $this->info_bits = $objp->info_bits;
3257 $this->date_start = $this->db->jdate($objp->date_start);
3258 $this->date_end = $this->db->jdate($objp->date_end);
3259
3260 $this->total_ht = $objp->total_ht;
3261 $this->total_tva = $objp->total_tva;
3262 $this->total_ttc = $objp->total_ttc;
3263
3264 $this->fk_fournprice = $objp->fk_fournprice;
3265
3266 $marginInfos = getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $this->fk_fournprice, $objp->pa_ht);
3267 $this->pa_ht = $marginInfos[0];
3268 $this->marge_tx = $marginInfos[1];
3269 $this->marque_tx = $marginInfos[2];
3270
3271 $this->special_code = $objp->special_code;
3272 $this->product_type = $objp->product_type;
3273 $this->rang = $objp->rang;
3274
3275 $this->ref = $objp->product_ref; // deprecated
3276 $this->product_ref = $objp->product_ref;
3277 $this->libelle = $objp->product_label; // deprecated
3278 $this->product_label = $objp->product_label;
3279 $this->product_desc = $objp->product_desc;
3280
3281 $this->ref_fourn = $objp->ref_produit_fourn;
3282
3283 $this->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams, true) : array();
3284
3285 // Multicurrency
3286 $this->fk_multicurrency = $objp->fk_multicurrency;
3287 $this->multicurrency_code = $objp->multicurrency_code;
3288 $this->multicurrency_subprice = $objp->multicurrency_subprice;
3289 $this->multicurrency_total_ht = $objp->multicurrency_total_ht;
3290 $this->multicurrency_total_tva = $objp->multicurrency_total_tva;
3291 $this->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
3292 $this->fk_unit = $objp->fk_unit;
3293
3294 $this->db->free($result);
3295 return 1;
3296 }
3297 return 0;
3298 } else {
3299 dol_print_error($this->db);
3300 return -1;
3301 }
3302 }
3303
3310 public function insert($notrigger = 0)
3311 {
3312 global $conf, $langs, $user;
3313
3314 $error = 0;
3315
3316 dol_syslog(get_class($this)."::insert rang=".$this->rang);
3317
3318 // Clean parameters
3319 if (empty($this->tva_tx)) {
3320 $this->tva_tx = 0;
3321 }
3322 if (empty($this->vat_src_code)) {
3323 $this->vat_src_code = '';
3324 }
3325 if (empty($this->localtax1_tx)) {
3326 $this->localtax1_tx = 0;
3327 }
3328 if (empty($this->localtax2_tx)) {
3329 $this->localtax2_tx = 0;
3330 }
3331 if (empty($this->localtax1_type)) {
3332 $this->localtax1_type = '';
3333 }
3334 if (empty($this->localtax2_type)) {
3335 $this->localtax2_type = '';
3336 }
3337 if (empty($this->total_localtax1)) {
3338 $this->total_localtax1 = 0;
3339 }
3340 if (empty($this->total_localtax2)) {
3341 $this->total_localtax2 = 0;
3342 }
3343 if (empty($this->rang)) {
3344 $this->rang = 0;
3345 }
3346 if (empty($this->remise_percent)) {
3347 $this->remise_percent = 0;
3348 }
3349 if (empty($this->info_bits)) {
3350 $this->info_bits = 0;
3351 }
3352 if (empty($this->special_code)) {
3353 $this->special_code = 0;
3354 }
3355 if (empty($this->fk_parent_line)) {
3356 $this->fk_parent_line = 0;
3357 }
3358 if (empty($this->fk_fournprice)) {
3359 $this->fk_fournprice = 0;
3360 }
3361 if (empty($this->fk_unit)) {
3362 $this->fk_unit = 0;
3363 }
3364 if (empty($this->subprice)) {
3365 $this->subprice = 0;
3366 }
3367
3368 if (empty($this->pa_ht)) {
3369 $this->pa_ht = 0;
3370 }
3371
3372 // if buy price not defined, define buyprice as configured in margin admin
3373 if ($this->pa_ht == 0) {
3374 $result = $this->defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
3375 if ($result < 0) {
3376 return $result;
3377 } else {
3378 $this->pa_ht = $result;
3379 }
3380 }
3381
3382 // Check parameters
3383 if ($this->product_type < 0) {
3384 return -1;
3385 }
3386
3387 $this->db->begin();
3388
3389 // Insert line into database
3390 $sql = 'INSERT INTO '.MAIN_DB_PREFIX.'supplier_proposaldet';
3391 $sql .= ' (fk_supplier_proposal, fk_parent_line, label, description, fk_product, product_type,';
3392 $sql .= ' date_start, date_end,';
3393 $sql .= ' fk_remise_except, qty, tva_tx, vat_src_code, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type,';
3394 $sql .= ' subprice, remise_percent, ';
3395 $sql .= ' info_bits, ';
3396 $sql .= ' total_ht, total_tva, total_localtax1, total_localtax2, total_ttc, fk_product_fournisseur_price, buy_price_ht, special_code, rang,';
3397 $sql .= ' ref_fourn,';
3398 $sql .= ' fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc, fk_unit)';
3399 $sql .= " VALUES (".$this->fk_supplier_proposal.",";
3400 $sql .= " ".($this->fk_parent_line > 0 ? ((int) $this->fk_parent_line) : "null").",";
3401 $sql .= " ".(!empty($this->label) ? "'".$this->db->escape($this->label)."'" : "null").",";
3402 $sql .= " '".$this->db->escape($this->desc)."',";
3403 $sql .= " ".($this->fk_product ? ((int) $this->fk_product) : "null").",";
3404 $sql .= " '".$this->db->escape((string) $this->product_type)."',";
3405 $sql .= " ".($this->date_start ? "'".$this->db->idate($this->date_start)."'" : "null").",";
3406 $sql .= " ".($this->date_end ? "'".$this->db->idate($this->date_end)."'" : "null").",";
3407 $sql .= " ".($this->fk_remise_except ? ((int) $this->fk_remise_except) : "null").",";
3408 $sql .= " ".price2num($this->qty, 'MS').",";
3409 $sql .= " ".price2num($this->tva_tx).",";
3410 $sql .= " '".$this->db->escape($this->vat_src_code)."',";
3411 $sql .= " ".price2num($this->localtax1_tx).",";
3412 $sql .= " ".price2num($this->localtax2_tx).",";
3413 $sql .= " '".$this->db->escape($this->localtax1_type)."',";
3414 $sql .= " '".$this->db->escape($this->localtax2_type)."',";
3415 $sql .= " ".price2num($this->subprice, 'MU') .",";
3416 $sql .= " ".((float) $this->remise_percent).",";
3417 $sql .= " ".(isset($this->info_bits) ? ((int) $this->info_bits) : "null").",";
3418 $sql .= " ".price2num($this->total_ht, 'MT').",";
3419 $sql .= " ".price2num($this->total_tva, 'MT').",";
3420 $sql .= " ".price2num($this->total_localtax1, 'MT').",";
3421 $sql .= " ".price2num($this->total_localtax2, 'MT').",";
3422 $sql .= " ".price2num($this->total_ttc, 'MT').",";
3423 $sql .= " ".(!empty($this->fk_fournprice) ? ((int) $this->fk_fournprice) : "null").",";
3424 $sql .= " ".(isset($this->pa_ht) ? price2num($this->pa_ht, 'MU') : "null").",";
3425 $sql .= ' '.((int) $this->special_code).',';
3426 $sql .= ' '.((int) $this->rang).',';
3427 $sql .= " '".$this->db->escape($this->ref_fourn)."'";
3428 $sql .= ", ".($this->fk_multicurrency > 0 ? ((int) $this->fk_multicurrency) : 'null');
3429 $sql .= ", '".$this->db->escape($this->multicurrency_code)."'";
3430 $sql .= ", ".price2num($this->multicurrency_subprice, 'CU');
3431 $sql .= ", ".price2num($this->multicurrency_total_ht, 'CT');
3432 $sql .= ", ".price2num($this->multicurrency_total_tva, 'CT');
3433 $sql .= ", ".price2num($this->multicurrency_total_ttc, 'CT');
3434 $sql .= ", ".($this->fk_unit ? ((int) $this->fk_unit) : 'null');
3435 $sql .= ')';
3436
3437 dol_syslog(get_class($this).'::insert', LOG_DEBUG);
3438 $resql = $this->db->query($sql);
3439 if ($resql) {
3440 $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX.'supplier_proposaldet');
3441
3442 if (!$error) {
3443 $result = $this->insertExtraFields();
3444 if ($result < 0) {
3445 $error++;
3446 }
3447 }
3448
3449 if (!$error && !$notrigger) {
3450 // Call trigger
3451 $result = $this->call_trigger('LINESUPPLIER_PROPOSAL_INSERT', $user);
3452 if ($result < 0) {
3453 $this->db->rollback();
3454 return -1;
3455 }
3456 // End call triggers
3457 }
3458
3459 $this->db->commit();
3460 return 1;
3461 } else {
3462 $this->error = $this->db->error()." sql=".$sql;
3463 $this->db->rollback();
3464 return -1;
3465 }
3466 }
3467
3474 public function delete($user)
3475 {
3476 $error = 0;
3477
3478 $this->db->begin();
3479
3480 $sql = "DELETE FROM ".MAIN_DB_PREFIX."supplier_proposaldet";
3481 $sql .= " WHERE rowid = ".((int) $this->id);
3482
3483 if ($this->db->query($sql)) {
3484 // Remove extrafields
3485 if (!$error) {
3486 $result = $this->deleteExtraFields();
3487 if ($result < 0) {
3488 $error++;
3489 dol_syslog(get_class($this)."::delete error -4 ".$this->error, LOG_ERR);
3490 }
3491 }
3492
3493 // Call trigger
3494 $result = $this->call_trigger('LINESUPPLIER_PROPOSAL_DELETE', $user);
3495 if ($result < 0) {
3496 $this->db->rollback();
3497 return -1;
3498 }
3499 // End call triggers
3500
3501 $this->db->commit();
3502
3503 return 1;
3504 } else {
3505 $this->error = $this->db->error()." sql=".$sql;
3506 $this->db->rollback();
3507 return -1;
3508 }
3509 }
3510
3517 public function update($notrigger = 0)
3518 {
3519 global $conf, $langs, $user;
3520
3521 $error = 0;
3522
3523 // Clean parameters
3524 if (empty($this->tva_tx)) {
3525 $this->tva_tx = 0;
3526 }
3527 if (empty($this->localtax1_tx)) {
3528 $this->localtax1_tx = 0;
3529 }
3530 if (empty($this->localtax2_tx)) {
3531 $this->localtax2_tx = 0;
3532 }
3533 if (empty($this->total_localtax1)) {
3534 $this->total_localtax1 = 0;
3535 }
3536 if (empty($this->total_localtax2)) {
3537 $this->total_localtax2 = 0;
3538 }
3539 if (empty($this->localtax1_type)) {
3540 $this->localtax1_type = '';
3541 }
3542 if (empty($this->localtax2_type)) {
3543 $this->localtax2_type = '';
3544 }
3545 if (empty($this->marque_tx)) {
3546 $this->marque_tx = 0;
3547 }
3548 if (empty($this->marge_tx)) {
3549 $this->marge_tx = 0;
3550 }
3551 if (empty($this->remise_percent)) {
3552 $this->remise_percent = 0;
3553 }
3554 if (empty($this->info_bits)) {
3555 $this->info_bits = 0;
3556 }
3557 if (empty($this->special_code)) {
3558 $this->special_code = 0;
3559 }
3560 if (empty($this->fk_parent_line)) {
3561 $this->fk_parent_line = 0;
3562 }
3563 if (empty($this->fk_fournprice)) {
3564 $this->fk_fournprice = 0;
3565 }
3566 if (empty($this->fk_unit)) {
3567 $this->fk_unit = 0;
3568 }
3569 if (empty($this->subprice)) {
3570 $this->subprice = 0;
3571 }
3572
3573 if (empty($this->pa_ht)) {
3574 $this->pa_ht = 0;
3575 }
3576
3577 // if buy price not defined, define buyprice as configured in margin admin
3578 if ($this->pa_ht == 0) {
3579 $result = $this->defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
3580 if ($result < 0) {
3581 return $result;
3582 } else {
3583 $this->pa_ht = $result;
3584 }
3585 }
3586
3587 $this->db->begin();
3588
3589 // Mise a jour ligne en base
3590 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposaldet SET";
3591 $sql .= " description='".$this->db->escape($this->desc)."'";
3592 $sql .= " , label=".(!empty($this->label) ? "'".$this->db->escape($this->label)."'" : "null");
3593 $sql .= " , product_type=".((int) $this->product_type);
3594 $sql .= " , date_start=".($this->date_start ? "'".$this->db->idate($this->date_start)."'" : "null");
3595 $sql .= " , date_end=".($this->date_end ? "'".$this->db->idate($this->date_end)."'" : "null");
3596 $sql .= " , tva_tx='".price2num($this->tva_tx)."'";
3597 $sql .= " , localtax1_tx=".price2num($this->localtax1_tx);
3598 $sql .= " , localtax2_tx=".price2num($this->localtax2_tx);
3599 $sql .= " , localtax1_type='".$this->db->escape($this->localtax1_type)."'";
3600 $sql .= " , localtax2_type='".$this->db->escape($this->localtax2_type)."'";
3601 $sql .= " , qty='".price2num($this->qty)."'";
3602 $sql .= " , subprice=".price2num($this->subprice);
3603 $sql .= " , remise_percent=".price2num($this->remise_percent);
3604 $sql .= " , info_bits='".$this->db->escape((string) $this->info_bits)."'";
3605 if (empty($this->skip_update_total)) {
3606 $sql .= " , total_ht=".price2num($this->total_ht);
3607 $sql .= " , total_tva=".price2num($this->total_tva);
3608 $sql .= " , total_ttc=".price2num($this->total_ttc);
3609 $sql .= " , total_localtax1=".price2num($this->total_localtax1);
3610 $sql .= " , total_localtax2=".price2num($this->total_localtax2);
3611 }
3612 $sql .= " , fk_product_fournisseur_price=".(!empty($this->fk_fournprice) ? "'".$this->db->escape((string) $this->fk_fournprice)."'" : "null");
3613 $sql .= " , buy_price_ht=".price2num($this->pa_ht);
3614 $sql .= " , special_code=".((int) $this->special_code);
3615 $sql .= " , fk_parent_line=".($this->fk_parent_line > 0 ? $this->fk_parent_line : "null");
3616 if (!empty($this->rang)) {
3617 $sql .= ", rang=".((int) $this->rang);
3618 }
3619 $sql .= " , ref_fourn=".(!empty($this->ref_fourn) ? "'".$this->db->escape($this->ref_fourn)."'" : "null");
3620 $sql .= " , fk_unit=".($this->fk_unit ? $this->fk_unit : 'null');
3621
3622 // Multicurrency
3623 $sql .= " , multicurrency_subprice=".price2num($this->multicurrency_subprice);
3624 $sql .= " , multicurrency_total_ht=".price2num($this->multicurrency_total_ht);
3625 $sql .= " , multicurrency_total_tva=".price2num($this->multicurrency_total_tva);
3626 $sql .= " , multicurrency_total_ttc=".price2num($this->multicurrency_total_ttc);
3627
3628 $sql .= " WHERE rowid = ".((int) $this->id);
3629
3630 dol_syslog(get_class($this)."::update", LOG_DEBUG);
3631 $resql = $this->db->query($sql);
3632 if ($resql) {
3633 if (!$error) {
3634 $result = $this->insertExtraFields();
3635 if ($result < 0) {
3636 $error++;
3637 }
3638 }
3639
3640 if (!$error && !$notrigger) {
3641 // Call trigger
3642 $result = $this->call_trigger('LINESUPPLIER_PROPOSAL_MODIFY', $user);
3643 if ($result < 0) {
3644 $this->db->rollback();
3645 return -1;
3646 }
3647 // End call triggers
3648 }
3649
3650 $this->db->commit();
3651 return 1;
3652 } else {
3653 $this->error = $this->db->error();
3654 $this->db->rollback();
3655 return -2;
3656 }
3657 }
3658
3659 // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
3666 public function update_total()
3667 {
3668 // phpcs:enable
3669 $this->db->begin();
3670
3671 // Mise a jour ligne en base
3672 $sql = "UPDATE ".MAIN_DB_PREFIX."supplier_proposaldet SET";
3673 $sql .= " total_ht=".price2num($this->total_ht, 'MT');
3674 $sql .= ",total_tva=".price2num($this->total_tva, 'MT');
3675 $sql .= ",total_ttc=".price2num($this->total_ttc, 'MT');
3676 $sql .= " WHERE rowid = ".((int) $this->id);
3677
3678 dol_syslog("SupplierProposalLine::update_total", LOG_DEBUG);
3679
3680 $resql = $this->db->query($sql);
3681 if ($resql) {
3682 $this->db->commit();
3683 return 1;
3684 } else {
3685 $this->error = $this->db->error();
3686 $this->db->rollback();
3687 return -2;
3688 }
3689 }
3690}
$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
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)
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.
call_trigger($triggerName, $user)
Call trigger based on this instance.
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.
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.
getNextNumRef($soc)
Returns the reference to the following non used Proposal used depending on the active numbering modul...
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.
initAsSpecimen()
Initialise an instance with random values.
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, ...)
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
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:63
dol_delete_preview($object)
Delete all preview files linked to object instance.
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_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.
dol_now($mode='auto')
Return date for now.
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.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
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)
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_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0)
Clean a string to use it as a file name.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
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, 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.
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
Definition member.php:79
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