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';
58 public $element =
'supplier_proposal';
63 public $table_element =
'supplier_proposal';
68 public $table_element_line =
'supplier_proposaldet';
73 public $class_element_line =
'SupplierProposalLine';
77 public $fk_element =
'fk_supplier_proposal';
82 public $picto =
'supplier_proposal';
88 public $restrictiononfksoc = 1;
114 public $ref_supplier;
130 public $delivery_date;
149 public $user_author_id;
175 public $cond_reglement_code;
179 public $cond_reglement_doc;
183 public $cond_reglement_label;
188 public $mode_reglement_code;
193 public $mode_reglement;
198 public $extraparams = array();
203 public $lines = array();
210 public $labelStatus = array();
211 public $labelStatusShort = array();
226 public $fk_multicurrency;
231 public $multicurrency_code;
235 public $multicurrency_tx;
239 public $multicurrency_total_ht;
243 public $multicurrency_total_tva;
247 public $multicurrency_total_ttc;
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),
288 public function __construct($db, $socid = 0, $supplier_proposalid = 0)
290 global
$conf, $langs;
294 $this->ismultientitymanaged = 1;
295 $this->socid = $socid;
296 $this->
id = $supplier_proposalid;
311 public function add_product($idproduct, $qty, $remise_percent = 0)
314 global
$conf, $mysoc;
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);
325 $productdesc = $prod->description;
329 if (empty($tva_tx)) {
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);
336 if (
$conf->global->PRODUIT_MULTIPRICES && $this->thirdparty->price_level) {
337 $price = $prod->multiprices[$this->thirdparty->price_level];
339 $price = $prod->price;
344 $line->fk_product = $idproduct;
345 $line->desc = $productdesc;
347 $line->subprice = $price;
348 $line->remise_percent = $remise_percent;
349 $line->tva_tx = $tva_tx;
351 $this->lines[] = $line;
369 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
370 include_once DOL_DOCUMENT_ROOT.
'/core/class/discount.class.php';
375 $result = $remise->fetch($idremise);
378 if ($remise->fk_facture) {
379 $this->error = $langs->trans(
"ErrorDiscountAlreadyUsed");
380 $this->db->rollback();
385 $supplier_proposalligne->fk_supplier_proposal = $this->id;
386 $supplier_proposalligne->fk_remise_except = $remise->id;
387 $supplier_proposalligne->desc = $remise->description;
388 $supplier_proposalligne->tva_tx = $remise->tva_tx;
389 $supplier_proposalligne->subprice = -(float) $remise->amount_ht;
390 $supplier_proposalligne->fk_product = 0;
391 $supplier_proposalligne->qty = 1;
392 $supplier_proposalligne->remise_percent = 0;
393 $supplier_proposalligne->rang = -1;
394 $supplier_proposalligne->info_bits = 2;
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;
400 $result = $supplier_proposalligne->insert();
407 $this->db->rollback();
411 $this->error = $supplier_proposalligne->error;
412 $this->db->rollback();
416 $this->db->rollback();
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)
460 global $mysoc,
$conf, $langs;
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';
466 if (empty($remise_percent)) {
472 if (empty($info_bits)) {
478 if (empty($fk_parent_line) || $fk_parent_line < 0) {
485 $remise_percent =
price2num($remise_percent);
489 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
495 if ($price_base_type ==
'HT') {
506 if ($this->statut == self::STATUS_DRAFT) {
509 if ($fk_product > 0) {
510 if (
getDolGlobalInt(
'SUPPLIER_PROPOSAL_WITH_PREDEFINED_PRICES_ONLY') == 1) {
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);
514 if ($productsupplier->fetch($fk_product) > 0) {
515 $product_type = $productsupplier->type;
516 $label = $productsupplier->label;
517 $fk_prod_fourn_price = $fk_fournprice;
522 $result = $productsupplier->get_buyprice($fk_prod_fourn_price, $qty, $fk_product,
'none', $this->socid);
524 $pu = $productsupplier->fourn_pu;
525 $ref_supplier = $productsupplier->ref_supplier;
527 if ($remise_percent == 0 && $productsupplier->remise_percent != 0) {
528 $remise_percent = $productsupplier->remise_percent;
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");
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);
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);
555 $this->error = $productsupplier->error;
556 $this->errors = $productsupplier->errors;
557 $this->db->rollback();
562 $product_type = $type;
575 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
576 $vat_src_code = $reg[1];
577 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
580 if (isModEnabled(
"multicurrency") && $pu_ht_devise > 0) {
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];
593 $multicurrency_total_ht = $tabprice[16];
594 $multicurrency_total_tva = $tabprice[17];
595 $multicurrency_total_ttc = $tabprice[18];
596 $pu_ht_devise = $tabprice[19];
600 if ($ranktouse == -1) {
601 $rangmax = $this->
line_max($fk_parent_line);
602 $ranktouse = $rangmax + 1;
609 if ($remise_percent > 0) {
610 $remise = round(((
float) $pu * (
float) $remise_percent / 100), 2);
611 $price = (float) $pu - $remise;
617 $this->line->fk_supplier_proposal = $this->id;
618 $this->line->label = $label;
619 $this->line->desc = $desc;
620 $this->line->qty = $qty;
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;
649 if (!empty($fk_product) && $fk_product > 0 && empty($fk_fournprice) && empty($pa_ht)) {
651 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
653 $productFournisseur->find_min_price_product_fournisseur($fk_product);
654 $this->line->fk_fournprice = $productFournisseur->product_fourn_price_id;
656 $this->line->fk_fournprice = ($fk_fournprice > 0 ? $fk_fournprice : 0);
658 $this->line->pa_ht = $pa_ht;
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;
670 if (empty($qty) && empty($special_code)) {
671 $this->line->special_code = 3;
674 if (is_array($array_options) && count($array_options) > 0) {
675 $this->line->array_options = $array_options;
678 $result = $this->line->insert();
681 if (!empty($fk_parent_line)) {
683 } elseif ($ranktouse > 0 && $ranktouse <= count($this->lines)) {
684 $linecount = count($this->lines);
685 for ($ii = $ranktouse; $ii <= $linecount; $ii++) {
691 $result = $this->
update_price(1,
'auto', 0, $this->thirdparty);
694 return $this->line->id;
696 $this->db->rollback();
700 $this->error = $this->line->error;
701 $this->errors = $this->line->errors;
702 $this->db->rollback();
706 $this->error =
'BadStatusOfObjectToAddLine';
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)
740 global
$conf, $user, $langs, $mysoc;
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';
746 $remise_percent =
price2num($remise_percent);
749 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
755 if (empty($qty) && empty($special_code)) {
758 if (!empty($qty) && $special_code == 3) {
775 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
776 $vat_src_code = $reg[1];
777 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
780 if (isModEnabled(
"multicurrency") && $pu_ht_devise > 0) {
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];
795 $multicurrency_total_ht = $tabprice[16];
796 $multicurrency_total_tva = $tabprice[17];
797 $multicurrency_total_ttc = $tabprice[18];
798 $pu_ht_devise = $tabprice[19];
801 if ($price_base_type ==
'TTC') {
807 $line->fetch($rowid);
808 $line->fetch_optionals();
810 $fk_product = $line->fk_product;
813 $staticline = clone $line;
815 $line->oldline = $staticline;
817 $this->line->context = $this->context;
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;
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;
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;
852 if (!empty($fk_product) && $fk_product > 0 && empty($fk_fournprice) && empty($pa_ht)) {
854 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
856 $productFournisseur->find_min_price_product_fournisseur($fk_product);
857 $this->line->fk_fournprice = $productFournisseur->product_fourn_price_id;
859 $this->line->fk_fournprice = $fk_fournprice;
861 $this->line->pa_ht = $pa_ht;
863 if (is_array($array_options) && count($array_options) > 0) {
865 foreach ($array_options as $key => $value) {
866 $this->line->array_options[$key] = $array_options[$key];
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;
876 $result = $this->line->update();
879 if (!empty($fk_parent_line)) {
888 $this->error = $this->db->error();
889 $this->db->rollback();
893 dol_syslog(get_class($this).
"::updateline Erreur -2 SupplierProposal en mode incompatible pour cette action");
909 if ($this->statut == 0) {
913 $line->fetch($lineid);
915 if ($this->
id > 0 && (
int) $line->fk_supplier_proposal !== (
int) $this->id) {
916 $this->error =
'ErrorLineIDDoesNotMatchWithObjectID';
920 if ($line->delete($user) > 0) {
941 public function create($user, $notrigger = 0)
943 global $langs,
$conf, $mysoc, $hookmanager;
953 $this->error =
"Failed to fetch company";
954 dol_syslog(get_class($this).
"::create ".$this->error, LOG_ERR);
957 if (!empty($this->
ref)) {
960 $this->error =
'ErrorRefAlreadyExists';
961 dol_syslog(get_class($this).
"::create ".$this->error, LOG_WARNING);
962 $this->db->rollback();
968 $delivery_date = $this->delivery_date;
971 if (!empty($this->multicurrency_code)) {
974 if (empty($this->fk_multicurrency)) {
975 $this->multicurrency_code =
$conf->currency;
976 $this->fk_multicurrency = 0;
977 $this->multicurrency_tx = 1;
983 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"supplier_proposal (";
986 $sql .=
", total_tva";
987 $sql .=
", total_ttc";
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";
1001 $sql .=
", fk_multicurrency";
1002 $sql .=
", multicurrency_code";
1003 $sql .=
", multicurrency_tx";
1005 $sql .=
" VALUES (";
1006 $sql .= ((int) $this->socid);
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);
1028 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1029 $resql = $this->db->query($sql);
1031 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"supplier_proposal");
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);
1037 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1038 $resql = $this->db->query($sql);
1043 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
1044 $this->linked_objects = $this->linkedObjectsIds;
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)) {
1051 foreach ($tmp_origin_id as $origin_id) {
1066 $fk_parent_line = 0;
1067 $num = count($this->lines);
1069 for ($i = 0; $i < $num; $i++) {
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;
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,
1087 $this->lines[$i]->product_type,
1088 $this->lines[$i]->rang,
1089 $this->lines[$i]->special_code,
1091 $this->lines[$i]->fk_fournprice,
1092 $this->lines[$i]->pa_ht,
1093 empty($this->lines[$i]->label) ?
'' : $this->lines[$i]->label,
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
1103 $this->error = $this->db->error;
1108 if ($result > 0 && $this->lines[$i]->product_type == 9) {
1109 $fk_parent_line = $result;
1128 if (!$error && !$notrigger) {
1130 $result = $this->
call_trigger(
'PROPOSAL_SUPPLIER_CREATE', $user);
1137 $this->error = $this->db->lasterror();
1142 $this->error = $this->db->lasterror();
1147 $this->db->commit();
1148 dol_syslog(get_class($this).
"::create done id=".$this->
id);
1151 $this->db->rollback();
1155 $this->error = $this->db->lasterror();
1156 $this->db->rollback();
1170 global
$conf, $hookmanager;
1178 foreach ($this->lines as $line) {
1179 $line->fetch_optionals();
1183 $objFrom = clone $this;
1185 $objsoc =
new Societe($this->db);
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);
1198 $objsoc->fetch($this->socid);
1204 if (!
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON') || !is_readable(DOL_DOCUMENT_ROOT.
"/core/modules/supplier_proposal/" .
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON').
".php")) {
1205 $this->error =
'ErrorSetupNotComplete';
1210 $this->user_author_id = $user->id;
1211 $this->user_validation_id = 0;
1215 require_once DOL_DOCUMENT_ROOT.
"/core/modules/supplier_proposal/" .
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON').
'.php';
1217 $modSupplierProposal =
new $obj();
1218 '@phan-var-force ModeleNumRefSupplierProposal $modSupplierProposal';
1219 $this->
ref = $modSupplierProposal->getNextValue($objsoc, $this);
1222 $this->context[
'createfromclone'] =
'createfromclone';
1223 $result = $this->
create($user);
1230 if (is_object($hookmanager)) {
1231 $parameters = array(
'objFrom' => $objFrom);
1233 $reshook = $hookmanager->executeHooks(
'createFrom', $parameters, $this, $action);
1241 unset($this->context[
'createfromclone']);
1245 $this->db->commit();
1248 $this->db->rollback();
1260 public function fetch($rowid, $ref =
'')
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').
")";
1288 $sql .=
" AND p.ref = '".$this->db->escape($ref).
"'";
1290 $sql .=
" AND p.rowid = ".((int) $rowid);
1293 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
1294 $resql = $this->db->query($sql);
1296 if ($this->db->num_rows($resql)) {
1297 $obj = $this->db->fetch_object($resql);
1299 $this->
id = $obj->rowid;
1300 $this->entity = $obj->entity;
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;
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);
1317 $this->datev = $this->db->jdate($obj->datev);
1318 $this->date_creation = $this->db->jdate($obj->datec);
1319 $this->date = $this->date_creation;
1320 $this->date_validation = $this->db->jdate($obj->datev);
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;
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;
1335 $this->extraparams = (array) (!empty($obj->extraparams) ? json_decode($obj->extraparams,
true) : array());
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;
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;
1349 $this->db->free($resql);
1355 $this->lines = array();
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";
1368 $result = $this->db->query($sql);
1370 $num = $this->db->num_rows($result);
1374 $objp = $this->db->fetch_object($result);
1378 $line->rowid = $objp->rowid;
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;
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;
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;
1407 $line->fk_product = $objp->fk_product;
1409 $line->ref = $objp->product_ref;
1410 $line->product_ref = $objp->product_ref;
1411 $line->libelle = $objp->product_label;
1412 $line->product_label = $objp->product_label;
1413 $line->product_desc = $objp->product_desc;
1414 $line->fk_product_type = $objp->fk_product_type;
1416 $line->ref_fourn = $objp->ref_produit_fourn;
1418 $line->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams,
true) : array();
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;
1429 $line->fetch_optionals();
1431 $this->lines[$i] = $line;
1435 $this->db->free($result);
1437 $this->error = $this->db->error();
1444 $this->error =
"Record Not Found";
1447 $this->error = $this->db->error();
1459 public function update($user, $notrigger = 0)
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);
1478 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
1479 $resql = $this->db->query($sql);
1482 $this->errors[] =
"Error ".$this->db->lasterror();
1492 if (!$error && !$notrigger) {
1494 $result = $this->
call_trigger(
'PROPOSAL_SUPPLIER_MODIFY', $user);
1502 $this->error = implode(
', ', $this->errors);
1503 $this->db->rollback();
1507 $this->db->commit();
1518 public function valid($user, $notrigger = 0)
1520 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1522 global
$conf, $langs;
1527 if ((!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'supplier_proposal',
'creer'))
1528 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'supplier_proposal',
'validate_advance'))) {
1532 $soc =
new Societe($this->db);
1533 $result = $soc->fetch($this->socid);
1540 if (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref)) {
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";
1552 dol_syslog(get_class($this).
"::valid", LOG_DEBUG);
1553 $resql = $this->db->query($sql);
1560 if (!$error && !$notrigger) {
1562 $result = $this->
call_trigger(
'PROPOSAL_SUPPLIER_VALIDATE', $user);
1570 $this->oldref = $this->ref;
1573 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
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);
1580 $this->error = $this->db->lasterror();
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);
1587 $this->error = $this->db->lasterror();
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)) {
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);
1615 $this->user_validation_id = $user->id;
1616 $this->datev = $now;
1617 $this->date_validation = $now;
1620 $result = $this->
add_contact($user->id,
'SALESREPFOLL',
'internal', 1);
1621 if ($result < 0 && $result != -2) {
1626 $this->db->commit();
1629 $this->db->rollback();
1633 dol_syslog(
"You don't have permission to validate supplier proposal", LOG_WARNING);
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);
1667 if ($this->db->query($sql)) {
1668 $this->delivery_date = $delivery_date;
1671 $this->error = $this->db->error();
1672 dol_syslog(get_class($this).
"::setDeliveryDate Erreur SQL");
1758 public function reopen($user, $status, $note =
'', $notrigger = 0)
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).
"',";
1767 $sql .=
" date_cloture = NULL, fk_user_cloture = NULL";
1768 $sql .=
" WHERE rowid = ".((int) $this->
id);
1772 dol_syslog(get_class($this).
"::reopen", LOG_DEBUG);
1773 $resql = $this->db->query($sql);
1776 $this->errors[] =
"Error ".$this->db->lasterror();
1781 $result = $this->
call_trigger(
'PROPOSAL_SUPPLIER_REOPEN', $user);
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);
1797 $this->db->rollback();
1800 $this->statut = $status;
1803 $this->db->commit();
1819 global $langs,
$conf;
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);
1833 $resql = $this->db->query($sql);
1835 $this->statut = $status;
1838 $modelpdf =
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON_PDF_ODT_CLOSED', (empty($this->model_pdf) ?
'' : $this->model_pdf));
1839 $triggerName =
'PROPOSAL_SUPPLIER_CLOSE_REFUSED';
1842 $triggerName =
'PROPOSAL_SUPPLIER_CLOSE_SIGNED';
1843 $modelpdf =
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON_PDF_ODT_TOBILL', (empty($this->model_pdf) ?
'' : $this->model_pdf));
1850 $triggerName =
'PROPOSAL_SUPPLIER_CLASSIFY_BILLED';
1855 $outputlangs = $langs;
1858 $newlang = (
GETPOST(
'lang_id',
'aZ09') ?
GETPOST(
'lang_id',
'aZ09') : $this->thirdparty->default_lang);
1859 $outputlangs->setDefaultLang($newlang);
1862 $this->
generateDocument($modelpdf, $outputlangs, $hidedetails, $hidedesc, $hideref);
1873 $this->db->commit();
1876 $this->db->rollback();
1880 $this->error = $this->db->lasterror();
1881 $this->errors[] = $this->db->lasterror();
1882 $this->db->rollback();
1897 dol_syslog(get_class($this).
"::updateOrCreatePriceFournisseur", LOG_DEBUG);
1898 foreach ($this->lines as $product) {
1899 if ($product->subprice <= 0) {
1904 $multicurrency_tx = 1;
1905 $fk_multicurrency = 0;
1907 if (empty($this->thirdparty)) {
1911 $ref_fourn = $product->ref_fourn;
1912 if (empty($ref_fourn)) {
1913 $ref_fourn = $product->ref_supplier;
1915 if (isModEnabled(
"multicurrency") && !empty($product->multicurrency_code)) {
1918 $productsupplier->id = $product->fk_product;
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);
1936 $price =
price2num($product->subprice * $product->qty,
'MU');
1937 $unitPrice =
price2num($product->subprice,
'MU');
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);
1941 $resql = $this->db->query($sql);
1943 $this->error = $this->db->error();
1944 $this->db->rollback();
1961 $price =
price2num($product->subprice * $product->qty,
'MU');
1963 $unitPrice =
price2num($product->subprice,
'MU');
1968 "'".$this->db->idate($now).
"'",
1969 (
int) $product->fk_product,
1970 (
int) $this->thirdparty->id,
1971 "'".$this->db->escape($product->ref_fourn).
"'",
1975 (
float) $product->tva_tx,
1978 if (isModEnabled(
"multicurrency")) {
1979 if (!empty($product->multicurrency_code)) {
1980 include_once DOL_DOCUMENT_ROOT.
'/multicurrency/class/multicurrency.class.php';
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;
1990 for ($i = 0; $i < 5; $i++) {
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';
2002 $sql .=
') VALUES ('.implode(
',', $values).
')';
2004 $resql = $this->db->query($sql);
2006 $this->error = $this->db->error();
2007 $this->db->rollback();
2023 global
$conf, $langs;
2027 if ($this->
status == self::STATUS_DRAFT) {
2028 dol_syslog(get_class($this).
"::setDraft already draft status", LOG_WARNING);
2032 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal";
2033 $sql .=
" SET fk_statut = ".self::STATUS_DRAFT;
2034 $sql .=
" WHERE rowid = ".((int) $this->
id);
2036 if ($this->db->query($sql)) {
2038 $this->oldcopy = clone $this;
2043 $result = $this->
call_trigger(
'PROPOSAL_SUPPLIER_UNVALIDATE', $user);
2052 $this->db->commit();
2055 $this->db->rollback();
2078 public function liste_array($shortlist = 0, $draft = 0, $notcurrentuser = 0, $socid = 0, $limit = 0, $offset = 0, $sortfield =
'p.datec', $sortorder =
'DESC')
2086 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2087 $search_sale = $user->id;
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";
2098 $sql .=
" AND s.rowid = ".((int) $socid);
2101 $sql .=
" AND p.fk_statut = 0";
2103 if ($notcurrentuser > 0) {
2104 $sql .=
" AND p.fk_user_author <> ".((int) $user->id);
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).
")";
2114 $sql .= $this->db->order($sortfield, $sortorder);
2115 $sql .= $this->db->plimit($limit, $offset);
2117 $result = $this->db->query($sql);
2119 $num = $this->db->num_rows($result);
2123 $obj = $this->db->fetch_object($result);
2125 if ($shortlist == 1) {
2126 $ga[$obj->supplier_proposalid] = $obj->ref;
2127 } elseif ($shortlist == 2) {
2128 $ga[$obj->supplier_proposalid] = $obj->ref.
' ('.$obj->name.
')';
2130 $ga[$i][
'id'] = $obj->supplier_proposalid;
2131 $ga[$i][
'ref'] = $obj->ref;
2132 $ga[$i][
'name'] = $obj->name;
2152 public function delete($user, $notrigger = 0)
2154 global
$conf, $langs;
2155 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
2163 $result = $this->
call_trigger(
'PROPOSAL_SUPPLIER_DELETE', $user);
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)) {
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)) {
2198 $this->error =
'ErrorFailToDeleteFile';
2199 $this->errors = array(
'ErrorFailToDeleteFile');
2200 $this->db->rollback();
2204 if (file_exists($dir)) {
2207 $this->error =
'ErrorFailToDeleteDir';
2208 $this->errors = array(
'ErrorFailToDeleteDir');
2209 $this->db->rollback();
2222 dol_syslog(get_class($this).
"::delete erreur ".$errorflag.
" ".$this->error, LOG_ERR);
2227 dol_syslog(get_class($this).
"::delete ".$this->
id.
" by ".$user->id, LOG_DEBUG);
2228 $this->db->commit();
2231 $this->error = $this->db->lasterror();
2232 $this->db->rollback();
2236 $this->error = $this->db->lasterror();
2237 $this->db->rollback();
2241 $this->error = $this->db->lasterror();
2242 $this->db->rollback();
2246 $this->db->rollback();
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);
2265 $result = $this->db->query($sql);
2268 if ($this->db->num_rows($result)) {
2269 $obj = $this->db->fetch_object($result);
2271 $this->
id = $obj->rowid;
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);
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;
2281 $this->db->free($result);
2312 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
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");
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';
2340 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusnew, $mode);
2355 global
$conf, $langs;
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);
2368 $sql .= $clause.
" p.entity IN (".
getEntity(
'supplier_proposal').
")";
2369 if ($mode ==
'opened') {
2370 $sql .=
" AND p.fk_statut = 1";
2372 if ($mode ==
'signed') {
2373 $sql .=
" AND p.fk_statut = 2";
2376 $sql .=
" AND p.fk_soc = ".((int) $user->socid);
2379 $resql = $this->db->query($sql);
2381 $label = $labelShort =
'';
2384 if ($mode ==
'opened') {
2385 $delay_warning = !empty(
$conf->supplier_proposal->cloture->warning_delay) ?
$conf->supplier_proposal->cloture->warning_delay : 0;
2387 $label = $langs->trans(
"SupplierProposalsToClose");
2388 $labelShort = $langs->trans(
"ToAcceptRefuse");
2390 if ($mode ==
'signed') {
2391 $delay_warning = !empty(
$conf->supplier_proposal->facturation->warning_delay) ?
$conf->supplier_proposal->facturation->warning_delay : 0;
2393 $label = $langs->trans(
"SupplierProposalsToProcess");
2394 $labelShort = $langs->trans(
"ToClose");
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;
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++;
2418 $this->error = $this->db->lasterror();
2433 global $user, $langs,
$conf;
2438 $sql =
"SELECT rowid";
2439 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product";
2440 $sql .=
" WHERE entity IN (".getEntity(
'product').
")";
2441 $sql .= $this->db->plimit(100);
2443 $resql = $this->db->query($sql);
2445 $num_prods = $this->db->num_rows($resql);
2447 while ($i < $num_prods) {
2449 $row = $this->db->fetch_row($resql);
2450 $prodids[$i] = $row[0];
2456 $this->
ref =
'SPECIMEN';
2457 $this->specimen = 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)';
2469 while ($xnbp < $nbp) {
2471 $line->desc = $langs->trans(
"Description").
" ".$xnbp;
2473 $line->subprice = 100;
2474 $line->tva_tx = 19.6;
2475 $line->localtax1_tx = 0;
2476 $line->localtax2_tx = 0;
2478 $line->total_ht = 50;
2479 $line->total_ttc = 59.8;
2480 $line->total_tva = 9.8;
2481 $line->remise_percent = 50;
2483 $line->total_ht = 100;
2484 $line->total_ttc = 119.6;
2485 $line->total_tva = 19.6;
2486 $line->remise_percent = 00;
2489 if ($num_prods > 0) {
2490 $prodid = mt_rand(1, $num_prods);
2491 $line->fk_product = $prodids[$prodid];
2494 $this->lines[$xnbp] = $line;
2496 $this->total_ht += $line->total_ht;
2497 $this->total_tva += $line->total_tva;
2498 $this->total_ttc += $line->total_ttc;
2513 global
$conf, $user;
2515 $this->nb = array();
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);
2526 $sql .=
" ".$clause.
" p.entity IN (".
getEntity(
'supplier_proposal').
")";
2528 $resql = $this->db->query($sql);
2531 while ($obj = $this->db->fetch_object($resql)) {
2532 $this->nb[
"supplier_proposals"] = $obj->nb;
2534 $this->db->free($resql);
2538 $this->error = $this->db->lasterror();
2553 global
$conf, $db, $langs;
2554 $langs->load(
"supplier_proposal");
2563 $dirmodels = array_merge(array(
'/'), (array)
$conf->modules_parts[
'models']);
2564 foreach ($dirmodels as $reldir) {
2565 $dir =
dol_buildpath($reldir.
"core/modules/supplier_proposal/");
2568 $mybool = ((bool) @include_once $dir.$file) || $mybool;
2576 $obj =
new $classname();
2577 '@phan-var-force ModeleNumRefSupplierProposal $obj';
2579 $numref = $obj->getNextValue($soc, $this);
2581 if ($numref !=
"") {
2584 $this->error = $obj->error;
2588 $langs->load(
"errors");
2589 print $langs->trans(
"Error").
" ".$langs->trans(
"ErrorModuleSetupNotComplete", $langs->transnoentitiesnoconv(
"SupplierProposal"));
2602 global
$conf, $langs, $menumanager;
2604 $langs->load(
'supplier_proposal');
2607 return [
'optimize' => $langs->trans(
"ShowSupplierProposal")];
2610 $option = $params[
'option'] ??
'';
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);
2617 if (!empty($this->
ref)) {
2618 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
2620 if (!empty($this->ref_fourn)) {
2621 $datas[
'ref_supplier'] =
'<br><b>'.$langs->trans(
'RefSupplier').
':</b> '.$this->ref_fourn;
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);
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);
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);
2647 public function getNomUrl($withpicto = 0, $option =
'', $get_params =
'', $notooltip = 0, $save_lastsearch_value = -1, $addlinktonotes = 0)
2649 global $langs,
$conf, $user, $hookmanager;
2651 if (!empty(
$conf->dol_no_mouse_hover)) {
2659 'objecttype' => $this->element,
2660 'option' => $option,
2662 $classfortooltip =
'classfortooltip';
2665 $classfortooltip =
'classforajaxtooltip';
2666 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
2672 if ($option ==
'') {
2673 $url = DOL_URL_ROOT.
'/supplier_proposal/card.php?id='.$this->
id.$get_params;
2675 if ($option ==
'document') {
2676 $url = DOL_URL_ROOT.
'/supplier_proposal/document.php?id='.$this->
id.$get_params;
2679 if ($option !==
'nolink') {
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;
2685 if ($add_save_lastsearch_values) {
2686 $url .=
'&save_lastsearch_values=1';
2691 if (empty($notooltip) && $user->hasRight(
'propal',
'lire')) {
2693 $label = $langs->trans(
"ShowSupplierProposal");
2694 $linkclose .=
' alt="'.dolPrintHTMLForAttribute($label).
'"';
2696 $linkclose .= ($label ?
' title="'.dolPrintHTMLForAttribute($label).
'"' :
' title="tocomplete"');
2697 $linkclose .= $dataparams.
' class="'.$classfortooltip.
'"';
2700 $linkstart =
'<a href="'.$url.
'"';
2701 $linkstart .= $linkclose.
'>';
2704 $result .= $linkstart;
2706 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), (($withpicto != 2) ?
'class="paddingright"' :
''), 0, 0, $notooltip ? 0 : 1);
2708 if ($withpicto != 2) {
2709 $result .= $this->ref;
2711 $result .= $linkend;
2713 if ($addlinktonotes) {
2714 $txttoshow = ($user->socid > 0 ? $this->note_public : $this->note_private);
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).
'">';
2723 $result .=
'</span>';
2727 $hookmanager->initHooks(array($this->element .
'dao'));
2728 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
2729 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
2731 $result = $hookmanager->resPrint;
2733 $result .= $hookmanager->resPrint;
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';
2759 dol_syslog(get_class($this).
'::getLinesArray', LOG_DEBUG);
2760 $resql = $this->db->query($sql);
2762 $num = $this->db->num_rows($resql);
2766 $obj = $this->db->fetch_object($resql);
2769 $this->lines[$i]->id = $obj->rowid;
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;
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;
2799 $this->lines[$i]->ref_fourn = $obj->ref_supplier;
2800 $this->lines[$i]->ref_supplier = $obj->ref_supplier;
2802 $this->extraparams = !empty($obj->extraparams) ? (array) json_decode($obj->extraparams,
true) : array();
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;
2815 $this->db->free($resql);
2819 $this->error = $this->db->error();
2835 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
2839 $langs->load(
"supplier_proposal");
2840 $outputlangs->load(
"products");
2845 if ($this->model_pdf) {
2846 $modele = $this->model_pdf;
2852 if (empty($modele)) {
2856 $modelpath =
"core/modules/supplier_proposal/doc/";
2858 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
2890 'supplier_proposaldet'
2908 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
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">';
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"' :
'').
'>';
2921 if (property_exists($this,
'socid')) {
2922 $return .=
'<span class="info-box-ref"> | '.$this->socid.
'</span>';
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>';
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>';
2930 if (method_exists($this,
'getLibStatut')) {
2931 $return .=
'<br><div class="info-box-status">'.$this->getLibStatut(3).
'</div>';
2933 $return .=
'</div>';
2934 $return .=
'</div>';
2935 $return .=
'</div>';
2959 public $element =
'supplier_proposaldet';
2964 public $table_element =
'supplier_proposaldet';
2989 public $fk_supplier_proposal;
2994 public $fk_parent_line;
3011 public $fk_product_type;
3030 public $vat_src_code;
3040 public $remise_percent;
3045 public $fk_remise_except;
3055 public $fk_fournprice;
3073 public $special_code;
3081 public $info_bits = 0;
3119 public $product_ref;
3132 public $product_label;
3144 public $product_desc;
3149 public $localtax1_tx;
3153 public $localtax2_tx;
3157 public $localtax1_type;
3161 public $localtax2_type;
3165 public $total_localtax1;
3169 public $total_localtax2;
3174 public $skip_update_total;
3183 public $ref_supplier;
3189 public $fk_multicurrency;
3194 public $multicurrency_code;
3198 public $multicurrency_subprice;
3202 public $multicurrency_total_ht;
3206 public $multicurrency_total_tva;
3210 public $multicurrency_total_ttc;
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);
3242 $result = $this->db->query($sql);
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);
3260 $this->total_ht = $objp->total_ht;
3261 $this->total_tva = $objp->total_tva;
3262 $this->total_ttc = $objp->total_ttc;
3264 $this->fk_fournprice = $objp->fk_fournprice;
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];
3271 $this->special_code = $objp->special_code;
3272 $this->product_type = $objp->product_type;
3273 $this->rang = $objp->rang;
3275 $this->
ref = $objp->product_ref;
3276 $this->product_ref = $objp->product_ref;
3277 $this->libelle = $objp->product_label;
3278 $this->product_label = $objp->product_label;
3279 $this->product_desc = $objp->product_desc;
3281 $this->ref_fourn = $objp->ref_produit_fourn;
3283 $this->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams,
true) : array();
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;
3294 $this->db->free($result);
3312 global
$conf, $langs, $user;
3316 dol_syslog(get_class($this).
"::insert rang=".$this->rang);
3319 if (empty($this->tva_tx)) {
3322 if (empty($this->vat_src_code)) {
3323 $this->vat_src_code =
'';
3325 if (empty($this->localtax1_tx)) {
3326 $this->localtax1_tx = 0;
3328 if (empty($this->localtax2_tx)) {
3329 $this->localtax2_tx = 0;
3331 if (empty($this->localtax1_type)) {
3332 $this->localtax1_type =
'';
3334 if (empty($this->localtax2_type)) {
3335 $this->localtax2_type =
'';
3337 if (empty($this->total_localtax1)) {
3338 $this->total_localtax1 = 0;
3340 if (empty($this->total_localtax2)) {
3341 $this->total_localtax2 = 0;
3343 if (empty($this->rang)) {
3346 if (empty($this->remise_percent)) {
3347 $this->remise_percent = 0;
3349 if (empty($this->info_bits)) {
3350 $this->info_bits = 0;
3352 if (empty($this->special_code)) {
3353 $this->special_code = 0;
3355 if (empty($this->fk_parent_line)) {
3356 $this->fk_parent_line = 0;
3358 if (empty($this->fk_fournprice)) {
3359 $this->fk_fournprice = 0;
3361 if (empty($this->fk_unit)) {
3364 if (empty($this->subprice)) {
3365 $this->subprice = 0;
3368 if (empty($this->pa_ht)) {
3373 if ($this->pa_ht == 0) {
3374 $result = $this->
defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
3378 $this->pa_ht = $result;
3383 if ($this->product_type < 0) {
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');
3437 dol_syslog(get_class($this).
'::insert', LOG_DEBUG);
3438 $resql = $this->db->query($sql);
3440 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
'supplier_proposaldet');
3449 if (!$error && !$notrigger) {
3451 $result = $this->
call_trigger(
'LINESUPPLIER_PROPOSAL_INSERT', $user);
3453 $this->db->rollback();
3459 $this->db->commit();
3462 $this->error = $this->db->error().
" sql=".$sql;
3463 $this->db->rollback();
3474 public function delete($user)
3480 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"supplier_proposaldet";
3481 $sql .=
" WHERE rowid = ".((int) $this->
id);
3483 if ($this->db->query($sql)) {
3489 dol_syslog(get_class($this).
"::delete error -4 ".$this->error, LOG_ERR);
3494 $result = $this->
call_trigger(
'LINESUPPLIER_PROPOSAL_DELETE', $user);
3496 $this->db->rollback();
3501 $this->db->commit();
3505 $this->error = $this->db->error().
" sql=".$sql;
3506 $this->db->rollback();
3519 global
$conf, $langs, $user;
3524 if (empty($this->tva_tx)) {
3527 if (empty($this->localtax1_tx)) {
3528 $this->localtax1_tx = 0;
3530 if (empty($this->localtax2_tx)) {
3531 $this->localtax2_tx = 0;
3533 if (empty($this->total_localtax1)) {
3534 $this->total_localtax1 = 0;
3536 if (empty($this->total_localtax2)) {
3537 $this->total_localtax2 = 0;
3539 if (empty($this->localtax1_type)) {
3540 $this->localtax1_type =
'';
3542 if (empty($this->localtax2_type)) {
3543 $this->localtax2_type =
'';
3545 if (empty($this->marque_tx)) {
3546 $this->marque_tx = 0;
3548 if (empty($this->marge_tx)) {
3549 $this->marge_tx = 0;
3551 if (empty($this->remise_percent)) {
3552 $this->remise_percent = 0;
3554 if (empty($this->info_bits)) {
3555 $this->info_bits = 0;
3557 if (empty($this->special_code)) {
3558 $this->special_code = 0;
3560 if (empty($this->fk_parent_line)) {
3561 $this->fk_parent_line = 0;
3563 if (empty($this->fk_fournprice)) {
3564 $this->fk_fournprice = 0;
3566 if (empty($this->fk_unit)) {
3569 if (empty($this->subprice)) {
3570 $this->subprice = 0;
3573 if (empty($this->pa_ht)) {
3578 if ($this->pa_ht == 0) {
3579 $result = $this->
defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
3583 $this->pa_ht = $result;
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);
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);
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');
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);
3628 $sql .=
" WHERE rowid = ".((int) $this->
id);
3630 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
3631 $resql = $this->db->query($sql);
3640 if (!$error && !$notrigger) {
3642 $result = $this->
call_trigger(
'LINESUPPLIER_PROPOSAL_MODIFY', $user);
3644 $this->db->rollback();
3650 $this->db->commit();
3653 $this->error = $this->db->error();
3654 $this->db->rollback();
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);
3678 dol_syslog(
"SupplierProposalLine::update_total", LOG_DEBUG);
3680 $resql = $this->db->query($sql);
3682 $this->db->commit();
3685 $this->error = $this->db->error();
3686 $this->db->rollback();
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.
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...
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.
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...
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.