41require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
42require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobject.class.php';
43require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
44require_once DOL_DOCUMENT_ROOT.
'/contact/class/contact.class.php';
45require_once DOL_DOCUMENT_ROOT.
'/margin/lib/margins.lib.php';
46require_once DOL_DOCUMENT_ROOT.
'/multicurrency/class/multicurrency.class.php';
47require_once DOL_DOCUMENT_ROOT.
'/core/class/commonincoterm.class.php';
48require_once DOL_DOCUMENT_ROOT.
'/subtotals/class/commonsubtotal.class.php';
60 public $element =
'supplier_proposal';
65 public $table_element =
'supplier_proposal';
70 public $table_element_line =
'supplier_proposaldet';
75 public $class_element_line =
'SupplierProposalLine';
79 public $fk_element =
'fk_supplier_proposal';
84 public $picto =
'supplier_proposal';
90 public $restrictiononfksoc = 1;
116 public $ref_supplier;
132 public $delivery_date;
151 public $user_author_id;
177 public $cond_reglement_code;
181 public $cond_reglement_doc;
185 public $cond_reglement_label;
190 public $mode_reglement_code;
195 public $mode_reglement;
202 public $deposit_percent;
208 public $extraparams = array();
213 public $lines = array();
220 public $labelStatus = array();
221 public $labelStatusShort = array();
236 public $fk_multicurrency;
241 public $multicurrency_code;
245 public $multicurrency_tx;
249 public $multicurrency_total_ht;
253 public $multicurrency_total_tva;
257 public $multicurrency_total_ttc;
259 public $fields = array(
260 'ref' => array(
'type' =>
'varchar(255)',
'label' =>
'Ref',
'enabled' => 1,
'visible' => 1,
'showoncombobox' => 1,
'position' => 25,
'searchall' => 1),
261 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 750,
'searchall' => 1),
298 public function __construct($db, $socid = 0, $supplier_proposalid = 0)
302 $this->ismultientitymanaged = 1;
303 $this->socid = $socid;
304 $this->
id = $supplier_proposalid;
319 public function add_product($idproduct, $qty, $remise_percent = 0)
328 dol_syslog(get_class($this).
"::add_product $idproduct, $qty, $remise_percent");
329 if ($idproduct > 0) {
331 $prod->fetch($idproduct);
333 $productdesc =
$prod->description;
337 if (empty($tva_tx)) {
345 $price =
$prod->multiprices[$this->thirdparty->price_level];
347 $price =
$prod->price;
352 $line->fk_product = $idproduct;
353 $line->desc = $productdesc;
355 $line->subprice = $price;
356 $line->remise_percent = $remise_percent;
357 $line->tva_tx = $tva_tx;
359 $this->lines[] = $line;
377 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
378 include_once DOL_DOCUMENT_ROOT.
'/core/class/discount.class.php';
383 $result = $remise->fetch($idremise);
386 if ($remise->fk_facture) {
387 $this->error = $langs->trans(
"ErrorDiscountAlreadyUsed");
388 $this->db->rollback();
393 $supplier_proposalligne->fk_supplier_proposal = $this->id;
394 $supplier_proposalligne->fk_remise_except = $remise->id;
395 $supplier_proposalligne->desc = $remise->description;
396 $supplier_proposalligne->tva_tx = $remise->tva_tx;
397 $supplier_proposalligne->localtax1_tx = $remise->localtax1_tx;
398 $supplier_proposalligne->localtax1_type = $remise->localtax1_type;
399 $supplier_proposalligne->localtax2_tx = $remise->localtax1_tx;
400 $supplier_proposalligne->localtax2_type = $remise->localtax1_type;
401 $supplier_proposalligne->subprice = -(float) $remise->amount_ht;
402 $supplier_proposalligne->fk_product = 0;
403 $supplier_proposalligne->qty = 1;
404 $supplier_proposalligne->remise_percent = 0;
405 $supplier_proposalligne->rang = -1;
406 $supplier_proposalligne->info_bits = 2;
408 $supplier_proposalligne->total_ht = -(float) $remise->amount_ht;
409 $supplier_proposalligne->total_tva = -(float) $remise->amount_tva;
410 $supplier_proposalligne->total_ttc = -(float) $remise->amount_ttc;
411 $supplier_proposalligne->total_localtax1 = -(float) $remise->total_localtax1;
412 $supplier_proposalligne->total_localtax2 = -(float) $remise->total_localtax2;
414 $result = $supplier_proposalligne->insert();
421 $this->db->rollback();
426 $this->db->rollback();
430 $this->db->rollback();
471 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)
475 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");
476 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
479 if (empty($remise_percent)) {
485 if (empty($info_bits)) {
491 if (empty($fk_parent_line) || $fk_parent_line < 0) {
498 $remise_percent =
price2num($remise_percent);
502 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
508 if ($price_base_type ==
'HT') {
519 if ($this->
status == self::STATUS_DRAFT) {
522 if ($fk_product > 0) {
523 if (
getDolGlobalInt(
'SUPPLIER_PROPOSAL_WITH_PREDEFINED_PRICES_ONLY') == 1) {
525 dol_syslog(get_class($this).
"::addline we check supplier prices fk_product=".$fk_product.
" fk_fournprice=".$fk_fournprice.
" qty=".$qty.
" ref_supplier=".$ref_supplier);
527 if ($productsupplier->fetch($fk_product) > 0) {
528 $product_type = $productsupplier->type;
529 $label = $productsupplier->label;
530 $fk_prod_fourn_price = $fk_fournprice;
535 $result = $productsupplier->get_buyprice($fk_prod_fourn_price, $qty, $fk_product,
'none', $this->socid);
537 $pu = $productsupplier->fourn_pu;
538 $ref_supplier = $productsupplier->ref_supplier;
540 if ($remise_percent == 0 && $productsupplier->remise_percent != 0) {
541 $remise_percent = $productsupplier->remise_percent;
545 $langs->load(
"errors");
546 $this->error =
"Ref ".$productsupplier->ref.
" ".$langs->trans(
"ErrorQtyTooLowForThisSupplier");
547 $this->db->rollback();
548 dol_syslog(get_class($this).
"::addline we did not found supplier price, so we can't guess unit price");
554 $langs->load(
"errors");
555 $this->error =
"Ref ".$productsupplier->ref.
" ".$langs->trans(
"ErrorQtyTooLowForThisSupplier");
556 $this->db->rollback();
557 dol_syslog(get_class($this).
"::addline result=".$result.
" - ".$this->error, LOG_DEBUG);
562 $this->db->rollback();
563 dol_syslog(get_class($this).
"::addline result=".$result.
" - ".$this->error, LOG_ERR);
568 $this->db->rollback();
573 $product_type = $type;
585 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
586 $vat_src_code = $reg[1];
587 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
590 if (
isModEnabled(
"multicurrency") && $pu_ht_devise > 0) {
597 (
float) $remise_percent,
599 (
float) $txlocaltax1,
600 (
float) $txlocaltax2,
608 (
float) $this->multicurrency_tx,
611 $total_ht = $tabprice[0];
612 $total_tva = $tabprice[1];
613 $total_ttc = $tabprice[2];
614 $total_localtax1 = $tabprice[9];
615 $total_localtax2 = $tabprice[10];
616 $pu = $pu_ht = $tabprice[3];
619 $multicurrency_total_ht = $tabprice[16];
620 $multicurrency_total_tva = $tabprice[17];
621 $multicurrency_total_ttc = $tabprice[18];
622 $pu_ht_devise = $tabprice[19];
626 if ($ranktouse == -1) {
627 $rangmax = $this->
line_max($fk_parent_line);
628 $ranktouse = $rangmax + 1;
634 $this->line->fk_supplier_proposal = $this->id;
635 $this->line->label = $label;
636 $this->line->desc = $desc;
637 $this->line->qty = $qty;
639 $this->line->vat_src_code = $vat_src_code;
640 $this->line->tva_tx = $txtva;
641 $this->line->localtax1_tx = ($total_localtax1 ? $localtaxes_type[1] : 0);
642 $this->line->localtax2_tx = ($total_localtax2 ? $localtaxes_type[3] : 0);
643 $this->line->localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
644 $this->line->localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
645 $this->line->fk_product = $fk_product;
646 $this->line->remise_percent = $remise_percent;
647 $this->line->subprice = (float) $pu_ht;
648 $this->line->rang = $ranktouse;
649 $this->line->info_bits = $info_bits;
650 $this->line->total_ht = (float) $total_ht;
651 $this->line->total_tva = (float) $total_tva;
652 $this->line->total_localtax1 = (float) $total_localtax1;
653 $this->line->total_localtax2 = (float) $total_localtax2;
654 $this->line->total_ttc = (float) $total_ttc;
655 $this->line->product_type = $type;
656 $this->line->special_code = $special_code;
657 $this->line->fk_parent_line = $fk_parent_line;
658 $this->line->fk_unit = $fk_unit;
659 $this->line->origin = $origin;
660 $this->line->origin_type = $origin;
661 $this->line->origin_id = $origin_id;
662 $this->line->ref_fourn = $this->db->escape($ref_supplier);
664 $this->line->date_end = $date_end;
667 if (!empty($fk_product) && $fk_product > 0 && empty($fk_fournprice) && empty($pa_ht)) {
669 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
671 $productFournisseur->find_min_price_product_fournisseur($fk_product);
672 $this->line->fk_fournprice = $productFournisseur->product_fourn_price_id;
674 $this->line->fk_fournprice = ($fk_fournprice > 0 ? $fk_fournprice : 0);
676 $this->line->pa_ht = $pa_ht;
680 $this->line->fk_multicurrency = $this->fk_multicurrency;
681 $this->line->multicurrency_code = $this->multicurrency_code;
682 $this->line->multicurrency_subprice = (float) $pu_ht_devise;
683 $this->line->multicurrency_total_ht = (float) $multicurrency_total_ht;
684 $this->line->multicurrency_total_tva = (float) $multicurrency_total_tva;
685 $this->line->multicurrency_total_ttc = (float) $multicurrency_total_ttc;
688 if (empty($qty) && empty($special_code)) {
689 $this->line->special_code = 3;
692 if (is_array($array_options) && count($array_options) > 0) {
693 $this->line->array_options = $array_options;
696 $result = $this->line->insert();
699 if (!empty($fk_parent_line)) {
701 } elseif ($ranktouse > 0 && $ranktouse <= count($this->lines)) {
702 $linecount = count($this->lines);
703 for ($ii = $ranktouse; $ii <= $linecount; $ii++) {
709 $result = $this->
update_price(1,
'auto', 0, $this->thirdparty);
712 return $this->line->id;
714 $this->db->rollback();
719 $this->db->rollback();
723 $this->error =
'BadStatusOfObjectToAddLine';
755 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)
760 $this->error =
'ErrorLineIDDoesNotMatchWithObjectID';
764 dol_syslog(get_class($this).
"::updateLine $rowid, $pu, $qty, $remise_percent, $txtva, $desc, $price_base_type, $info_bits");
765 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
768 $remise_percent =
price2num($remise_percent);
771 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
777 if (empty($qty) && empty($special_code)) {
780 if (!empty($qty) && $special_code == 3) {
796 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
797 $vat_src_code = $reg[1];
798 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
801 if (
isModEnabled(
"multicurrency") && $pu_ht_devise > 0) {
808 (
float) $remise_percent,
810 (
float) $txlocaltax1,
811 (
float) $txlocaltax2,
819 (
float) $this->multicurrency_tx,
822 $total_ht = $tabprice[0];
823 $total_tva = $tabprice[1];
824 $total_ttc = $tabprice[2];
825 $total_localtax1 = $tabprice[9];
826 $total_localtax2 = $tabprice[10];
827 $pu_ht = $tabprice[3];
828 $pu_tva = $tabprice[4];
829 $pu_ttc = $tabprice[5];
832 $multicurrency_total_ht = $tabprice[16];
833 $multicurrency_total_tva = $tabprice[17];
834 $multicurrency_total_ttc = $tabprice[18];
835 $pu_ht_devise = $tabprice[19];
838 if ($price_base_type ==
'TTC') {
844 $line->fetch($rowid);
845 $line->fetch_optionals();
847 $fk_product = $line->fk_product;
850 $staticline = clone $line;
852 $line->oldline = $staticline;
854 $this->line->context = $this->context;
857 if (!empty($fk_parent_line) && !empty($staticline->fk_parent_line) && $fk_parent_line != $staticline->fk_parent_line) {
858 $rangmax = $this->
line_max($fk_parent_line);
859 $this->line->rang = $rangmax + 1;
862 $this->line->id = $rowid;
863 $this->line->label = $label;
864 $this->line->desc = $desc;
865 $this->line->qty = $qty;
866 $this->line->product_type = $type;
868 $this->line->vat_src_code = $vat_src_code;
869 $this->line->tva_tx = $txtva;
870 $this->line->localtax1_tx = $txlocaltax1;
871 $this->line->localtax2_tx = $txlocaltax2;
872 $this->line->localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
873 $this->line->localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
874 $this->line->remise_percent = $remise_percent;
875 $this->line->subprice = (float) $pu;
876 $this->line->info_bits = $info_bits;
877 $this->line->total_ht = (float) $total_ht;
878 $this->line->total_tva = (float) $total_tva;
879 $this->line->total_localtax1 = (float) $total_localtax1;
880 $this->line->total_localtax2 = (float) $total_localtax2;
881 $this->line->total_ttc = (float) $total_ttc;
882 $this->line->special_code = $special_code;
883 $this->line->fk_parent_line = $fk_parent_line;
884 $this->line->skip_update_total = $skip_update_total;
885 $this->line->ref_fourn = $ref_supplier;
886 $this->line->fk_unit = $fk_unit;
889 if (!empty($fk_product) && $fk_product > 0 && empty($fk_fournprice) && empty($pa_ht)) {
891 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
893 $productFournisseur->find_min_price_product_fournisseur($fk_product);
894 $this->line->fk_fournprice = $productFournisseur->product_fourn_price_id;
896 $this->line->fk_fournprice = $fk_fournprice;
898 $this->line->pa_ht = $pa_ht;
900 if (is_array($array_options) && count($array_options) > 0) {
902 foreach ($array_options as $key => $value) {
903 $this->line->array_options[$key] = $array_options[$key];
908 $this->line->multicurrency_subprice = (float) $pu_ht_devise;
909 $this->line->multicurrency_total_ht = (float) $multicurrency_total_ht;
910 $this->line->multicurrency_total_tva = (float) $multicurrency_total_tva;
911 $this->line->multicurrency_total_ttc = (float) $multicurrency_total_ttc;
913 $result = $this->line->update();
916 if (!empty($fk_parent_line)) {
925 $this->error = $this->db->error();
926 $this->db->rollback();
930 dol_syslog(get_class($this).
"::updateline Erreur -2 SupplierProposal en mode incompatible pour cette action");
950 $line->fetch($lineid);
952 if ($this->
id > 0 && (
int) $line->fk_supplier_proposal !== (
int) $this->id) {
953 $this->error =
'ErrorLineIDDoesNotMatchWithObjectID';
957 if ($line->delete($user) > 0) {
978 public function create($user, $notrigger = 0)
990 $this->error =
"Failed to fetch company";
991 dol_syslog(get_class($this).
"::create ".$this->error, LOG_ERR);
994 if (!empty($this->
ref)) {
997 $this->error =
'ErrorRefAlreadyExists';
998 dol_syslog(get_class($this).
"::create ".$this->error, LOG_WARNING);
999 $this->db->rollback();
1005 $delivery_date = $this->delivery_date;
1008 if (!empty($this->multicurrency_code)) {
1011 if (empty($this->fk_multicurrency)) {
1013 $this->fk_multicurrency = 0;
1014 $this->multicurrency_tx = 1;
1020 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"supplier_proposal (";
1023 $sql .=
", total_tva";
1024 $sql .=
", total_ttc";
1027 $sql .=
", fk_user_author";
1028 $sql .=
", note_private";
1029 $sql .=
", note_public";
1030 $sql .=
", model_pdf";
1031 $sql .=
", fk_cond_reglement";
1032 $sql .=
", deposit_percent";
1033 $sql .=
", fk_mode_reglement";
1034 $sql .=
", fk_account";
1035 $sql .=
", date_livraison";
1036 $sql .=
", fk_shipping_method";
1037 $sql .=
", fk_projet";
1039 $sql .=
", fk_multicurrency";
1040 $sql .=
", multicurrency_code";
1041 $sql .=
", multicurrency_tx";
1043 $sql .=
" VALUES (";
1044 $sql .= ((int) $this->socid);
1048 $sql .=
", '".$this->db->idate($now).
"'";
1049 $sql .=
", '(PROV)'";
1050 $sql .=
", ".($user->id > 0 ? ((int) $user->id) :
"null");
1051 $sql .=
", '".$this->db->escape($this->note_private).
"'";
1052 $sql .=
", '".$this->db->escape($this->note_public).
"'";
1053 $sql .=
", '".$this->db->escape($this->model_pdf).
"'";
1054 $sql .=
", ".($this->cond_reglement_id > 0 ? ((int) $this->cond_reglement_id) :
'NULL');
1055 $sql .=
", ".(!empty($this->deposit_percent) ?
"'" . $this->db->escape($this->deposit_percent) .
"'" :
'NULL');
1056 $sql .=
", ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) :
'NULL');
1057 $sql .=
", ".($this->fk_account > 0 ? ((int) $this->fk_account) :
'NULL');
1058 $sql .=
", ".(isDolTms($delivery_date) ?
"'".$this->db->idate($delivery_date).
"'" :
"null");
1059 $sql .=
", ".($this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) :
'NULL');
1060 $sql .=
", ".($this->fk_project > 0 ? ((int) $this->fk_project) :
"null");
1061 $sql .=
", ".((int)
$conf->entity);
1062 $sql .=
", ".((int) $this->fk_multicurrency);
1063 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
1064 $sql .=
", ".((float) $this->multicurrency_tx);
1067 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1068 $resql = $this->db->query($sql);
1070 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"supplier_proposal");
1073 $this->
ref =
'(PROV'.$this->id.
')';
1074 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"supplier_proposal SET ref='".$this->db->escape($this->
ref).
"' WHERE rowid=".((int) $this->
id);
1076 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1077 $resql = $this->db->query($sql);
1082 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
1083 $this->linked_objects = $this->linkedObjectsIds;
1087 if (!$error && $this->
id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
1088 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
1089 if (is_array($tmp_origin_id)) {
1090 foreach ($tmp_origin_id as $origin_id) {
1105 $fk_parent_line = 0;
1106 $num = count($this->lines);
1108 for ($i = 0; $i < $num; $i++) {
1110 if (($this->lines[$i]->product_type != 9 && empty($this->lines[$i]->fk_parent_line)) || $this->lines[$i]->product_type == 9) {
1111 $fk_parent_line = 0;
1115 $this->lines[$i]->desc,
1116 $this->lines[$i]->subprice,
1117 $this->lines[$i]->qty,
1118 $this->lines[$i]->tva_tx,
1119 $this->lines[$i]->localtax1_tx,
1120 $this->lines[$i]->localtax2_tx,
1121 $this->lines[$i]->fk_product,
1122 $this->lines[$i]->remise_percent,
1126 $this->lines[$i]->product_type,
1127 $this->lines[$i]->rang,
1128 $this->lines[$i]->special_code,
1130 $this->lines[$i]->fk_fournprice,
1131 $this->lines[$i]->pa_ht,
1132 empty($this->lines[$i]->label) ?
'' : $this->lines[$i]->label,
1133 $this->lines[$i]->array_options,
1134 $this->lines[$i]->ref_fourn,
1135 $this->lines[$i]->fk_unit,
1136 'supplier_proposal',
1137 $this->lines[$i]->rowid
1142 $this->error = $this->db->error;
1147 if ($result > 0 && $this->lines[$i]->product_type == 9) {
1148 $fk_parent_line = $result;
1167 if (!$error && !$notrigger) {
1169 $result = $this->call_trigger(
'PROPOSAL_SUPPLIER_CREATE', $user);
1176 $this->error = $this->db->lasterror();
1181 $this->error = $this->db->lasterror();
1186 $this->db->commit();
1187 dol_syslog(get_class($this).
"::create done id=".$this->
id);
1190 $this->db->rollback();
1194 $this->error = $this->db->lasterror();
1195 $this->db->rollback();
1209 global $hookmanager;
1217 foreach ($this->lines as $line) {
1218 $line->fetch_optionals();
1222 $objFrom = clone $this;
1224 $objsoc =
new Societe($this->db);
1227 if (!empty($fromid) && $fromid != $this->socid) {
1228 if ($objsoc->fetch($fromid) > 0) {
1229 $this->socid = $objsoc->id;
1230 $this->cond_reglement_id = (!empty($objsoc->cond_reglement_id) ? $objsoc->cond_reglement_id : 0);
1231 $this->deposit_percent = (!empty($objsoc->deposit_percent) ? $objsoc->deposit_percent : 0);
1232 $this->mode_reglement_id = (!empty($objsoc->mode_reglement_id) ? $objsoc->mode_reglement_id : 0);
1233 unset($this->fk_project);
1238 $objsoc->fetch($this->socid);
1245 if (!
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON') || !is_readable(DOL_DOCUMENT_ROOT.
"/core/modules/supplier_proposal/" .
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON').
".php")) {
1246 $this->error =
'ErrorSetupNotComplete';
1251 $this->user_author_id = $user->id;
1252 $this->user_validation_id = 0;
1256 require_once DOL_DOCUMENT_ROOT.
"/core/modules/supplier_proposal/" .
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON').
'.php';
1258 $modSupplierProposal =
new $obj();
1259 '@phan-var-force ModeleNumRefSupplierProposal $modSupplierProposal';
1260 $this->
ref = $modSupplierProposal->getNextValue($objsoc, $this);
1263 $this->context[
'createfromclone'] =
'createfromclone';
1264 $result = $this->
create($user);
1271 if (is_object($hookmanager)) {
1272 $parameters = array(
'objFrom' => $objFrom);
1274 $reshook = $hookmanager->executeHooks(
'createFrom', $parameters, $this, $action);
1282 unset($this->context[
'createfromclone']);
1286 $this->db->commit();
1289 $this->db->rollback();
1301 public function fetch($rowid, $ref =
'')
1303 $sql =
"SELECT p.rowid, p.entity, p.ref, p.fk_soc as socid";
1304 $sql .=
", p.total_ttc, p.total_tva, p.localtax1, p.localtax2, p.total_ht";
1305 $sql .=
", p.datec, GREATEST(p.tms, COALESCE(pef.tms, p.tms)) as date_modification";
1306 $sql .=
", p.date_valid as datev";
1307 $sql .=
", p.date_livraison as delivery_date";
1308 $sql .=
", p.model_pdf, p.extraparams";
1309 $sql .=
", p.note_private, p.note_public";
1310 $sql .=
", p.fk_projet as fk_project, p.fk_statut as status";
1311 $sql .=
", p.fk_user_author, p.fk_user_modif, p.fk_user_valid, p.fk_user_cloture";
1312 $sql .=
", p.fk_cond_reglement";
1313 $sql .=
", p.fk_mode_reglement";
1314 $sql .=
', p.fk_account';
1315 $sql .=
", p.fk_shipping_method";
1316 $sql .=
", p.last_main_doc";
1317 $sql .=
", p.fk_multicurrency, p.multicurrency_code, p.multicurrency_tx, p.multicurrency_total_ht, p.multicurrency_total_tva, p.multicurrency_total_ttc";
1318 $sql .=
", c.label as statut_label";
1319 $sql .=
", cr.code as cond_reglement_code, cr.libelle as cond_reglement, cr.libelle_facture as cond_reglement_libelle_doc, p.deposit_percent";
1320 $sql .=
", cp.code as mode_reglement_code, cp.libelle as mode_reglement";
1321 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_propalst as c, ".MAIN_DB_PREFIX.
"supplier_proposal as p";
1322 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"supplier_proposal_extrafields as pef ON pef.fk_object=p.rowid";
1323 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_paiement as cp ON p.fk_mode_reglement = cp.id';
1324 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_payment_term as cr ON p.fk_cond_reglement = cr.rowid';
1325 $sql .=
" WHERE p.fk_statut = c.id";
1326 $sql .=
" AND p.entity IN (".getEntity(
'supplier_proposal').
")";
1328 $sql .=
" AND p.ref = '".$this->db->escape($ref).
"'";
1330 $sql .=
" AND p.rowid = ".((int) $rowid);
1333 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
1334 $resql = $this->db->query($sql);
1336 if ($this->db->num_rows($resql)) {
1337 $obj = $this->db->fetch_object($resql);
1339 $this->
id = $obj->rowid;
1340 $this->entity = $obj->entity;
1342 $this->
ref = $obj->ref;
1343 $this->total_ht = $obj->total_ht;
1344 $this->total_tva = $obj->total_tva;
1345 $this->total_localtax1 = $obj->localtax1;
1346 $this->total_localtax2 = $obj->localtax2;
1347 $this->total_ttc = $obj->total_ttc;
1348 $this->socid = $obj->socid;
1349 $this->fk_project = $obj->fk_project;
1350 $this->model_pdf = $obj->model_pdf;
1351 $this->note = $obj->note_private;
1352 $this->note_private = $obj->note_private;
1353 $this->note_public = $obj->note_public;
1354 $this->statut = (int) $obj->status;
1355 $this->
status = (int) $obj->status;
1356 $this->datec = $this->db->jdate($obj->datec);
1357 $this->datev = $this->db->jdate($obj->datev);
1358 $this->date_creation = $this->db->jdate($obj->datec);
1359 $this->date_modification = $this->db->jdate($obj->date_modification);
1360 $this->
date = $this->date_creation;
1361 $this->date_validation = $this->db->jdate($obj->datev);
1362 $this->delivery_date = $this->db->jdate($obj->delivery_date);
1363 $this->shipping_method_id = ($obj->fk_shipping_method > 0) ? $obj->fk_shipping_method :
null;
1365 $this->last_main_doc = $obj->last_main_doc;
1366 $this->mode_reglement_id = $obj->fk_mode_reglement;
1367 $this->mode_reglement_code = $obj->mode_reglement_code;
1368 $this->mode_reglement = $obj->mode_reglement;
1369 $this->deposit_percent = $obj->deposit_percent;
1370 $this->fk_account = ($obj->fk_account > 0) ? $obj->fk_account :
null;
1371 $this->cond_reglement_id = $obj->fk_cond_reglement;
1372 $this->cond_reglement_code = $obj->cond_reglement_code;
1373 $this->cond_reglement = $obj->cond_reglement;
1374 $this->cond_reglement_label = $obj->cond_reglement;
1375 $this->cond_reglement_doc = $obj->cond_reglement_libelle_doc;
1377 $this->extraparams = (array) (!empty($obj->extraparams) ? json_decode($obj->extraparams,
true) : array());
1379 $this->user_author_id = $obj->fk_user_author;
1380 $this->user_modification_id = $obj->fk_user_modif;
1381 $this->user_validation_id = $obj->fk_user_valid;
1382 $this->user_closing_id = $obj->fk_user_cloture;
1385 $this->fk_multicurrency = $obj->fk_multicurrency;
1386 $this->multicurrency_code = $obj->multicurrency_code;
1387 $this->multicurrency_tx = $obj->multicurrency_tx;
1388 $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
1389 $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
1390 $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
1392 $this->db->free($resql);
1398 $this->lines = array();
1401 $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,";
1402 $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,";
1403 $sql .=
' p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label,';
1404 $sql .=
' d.ref_fourn as ref_produit_fourn, d.extraparams,';
1405 $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';
1406 $sql .=
" FROM ".MAIN_DB_PREFIX.
"supplier_proposaldet as d";
1407 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"product as p ON d.fk_product = p.rowid";
1408 $sql .=
" WHERE d.fk_supplier_proposal = ".((int) $this->
id);
1409 $sql .=
" ORDER by d.rang";
1411 $result = $this->db->query($sql);
1413 $num = $this->db->num_rows($result);
1417 $objp = $this->db->fetch_object($result);
1421 $line->rowid = $objp->rowid;
1422 $line->id = $objp->rowid;
1423 $line->fk_supplier_proposal = $objp->fk_supplier_proposal;
1424 $line->fk_parent_line = $objp->fk_parent_line;
1425 $line->product_type = $objp->product_type;
1426 $line->label = $objp->custom_label;
1427 $line->desc = $objp->description;
1428 $line->qty = $objp->qty;
1429 $line->tva_tx = $objp->tva_tx;
1430 $line->localtax1_tx = $objp->localtax1_tx;
1431 $line->localtax2_tx = $objp->localtax2_tx;
1432 $line->subprice = $objp->subprice;
1433 $line->fk_remise_except = $objp->fk_remise_except;
1434 $line->remise_percent = $objp->remise_percent;
1436 $line->info_bits = $objp->info_bits;
1437 $line->total_ht = $objp->total_ht;
1438 $line->total_tva = $objp->total_tva;
1439 $line->total_localtax1 = $objp->total_localtax1;
1440 $line->total_localtax2 = $objp->total_localtax2;
1441 $line->total_ttc = $objp->total_ttc;
1442 $line->fk_fournprice = $objp->fk_fournprice;
1443 $marginInfos =
getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $line->fk_fournprice, $objp->pa_ht);
1444 $line->pa_ht = $marginInfos[0];
1445 $line->marge_tx = $marginInfos[1];
1446 $line->marque_tx = $marginInfos[2];
1447 $line->special_code = $objp->special_code;
1448 $line->rang = $objp->rang;
1450 $line->fk_product = $objp->fk_product;
1452 $line->ref = $objp->product_ref;
1453 $line->product_ref = $objp->product_ref;
1454 $line->libelle = $objp->product_label;
1455 $line->product_label = $objp->product_label;
1456 $line->product_desc = $objp->product_desc;
1457 $line->fk_product_type = $objp->fk_product_type;
1459 $line->ref_fourn = $objp->ref_produit_fourn;
1461 $line->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams,
true) : array();
1464 $line->fk_multicurrency = $objp->fk_multicurrency;
1465 $line->multicurrency_code = $objp->multicurrency_code;
1466 $line->multicurrency_subprice = $objp->multicurrency_subprice;
1467 $line->multicurrency_total_ht = $objp->multicurrency_total_ht;
1468 $line->multicurrency_total_tva = $objp->multicurrency_total_tva;
1469 $line->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
1470 $line->fk_unit = $objp->fk_unit;
1472 $line->fetch_optionals();
1474 $this->lines[$i] = $line;
1478 $this->db->free($result);
1480 $this->error = $this->db->error();
1487 $this->error =
"Record Not Found";
1490 $this->error = $this->db->error();
1502 public function update($user, $notrigger = 0)
1506 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal SET";
1507 $sql .=
" fk_projet = ".($this->fk_project > 0 ? ((int) $this->fk_project) :
"null");
1508 $sql .=
", fk_cond_reglement = ".($this->cond_reglement_id > 0 ? ((int) $this->cond_reglement_id) :
"null");
1509 $sql .=
", fk_mode_reglement = ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) :
"null");
1510 $sql .=
", fk_account = ".($this->fk_account > 0 ? ((int) $this->fk_account) :
"null");
1511 $sql .=
", fk_shipping_method = ".($this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) :
"null");
1512 $sql .=
", date_livraison = ".($this->delivery_date ?
"'".$this->db->idate($this->delivery_date).
"'" :
"null");
1513 $sql .=
", note_private = ".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null");
1514 $sql .=
", note_public = ".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null");
1515 $sql .=
", model_pdf = ".(isset($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
"null");
1516 $sql .=
", fk_user_modif = ".((int) $user->id);
1517 $sql .=
" WHERE rowid = ".((int) $this->
id);
1521 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
1522 $resql = $this->db->query($sql);
1525 $this->errors[] =
"Error ".$this->db->lasterror();
1535 if (!$error && !$notrigger) {
1537 $result = $this->call_trigger(
'PROPOSAL_SUPPLIER_MODIFY', $user);
1545 $this->error = implode(
', ', $this->errors);
1546 $this->db->rollback();
1550 $this->db->commit();
1561 public function valid($user, $notrigger = 0)
1563 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1570 if ((!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'supplier_proposal',
'creer'))
1571 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'supplier_proposal',
'validate_advance'))) {
1575 $soc =
new Societe($this->db);
1576 $result = $soc->fetch($this->socid);
1582 dol_syslog(get_class($this).
"::valid checkActiveProductInLines ".$this->error, LOG_INFO);
1586 if (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref)) {
1587 $num = $this->getNextNumRef($soc);
1593 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal";
1594 $sql .=
" SET ref = '".$this->db->escape($num).
"',";
1595 $sql .=
" fk_statut = 1, date_valid='".$this->db->idate($now).
"', fk_user_valid=".((int) $user->id);
1596 $sql .=
" WHERE rowid = ".((int) $this->
id).
" AND fk_statut = 0";
1598 dol_syslog(get_class($this).
"::valid", LOG_DEBUG);
1599 $resql = $this->db->query($sql);
1606 if (!$error && !$notrigger) {
1608 $result = $this->call_trigger(
'PROPOSAL_SUPPLIER_VALIDATE', $user);
1616 $this->oldref = $this->ref;
1619 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
1621 $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).
"'";
1622 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'supplier_proposal/".$this->db->escape($this->
ref).
"' and entity = ".((int)
$conf->entity);
1623 $resql = $this->db->query($sql);
1626 $this->error = $this->db->lasterror();
1628 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'supplier_proposal/".$this->db->escape($this->newref).
"'";
1629 $sql .=
" WHERE filepath = 'supplier_proposal/".$this->db->escape($this->
ref).
"' and entity = ".((int)
$conf->entity);
1630 $resql = $this->db->query($sql);
1633 $this->error = $this->db->lasterror();
1639 $dirsource =
$conf->supplier_proposal->dir_output.
'/'.$oldref;
1640 $dirdest =
$conf->supplier_proposal->dir_output.
'/'.$newref;
1641 if (!$error && file_exists($dirsource)) {
1642 dol_syslog(get_class($this).
"::valid rename dir ".$dirsource.
" into ".$dirdest);
1643 if (@rename($dirsource, $dirdest)) {
1646 $listoffiles =
dol_dir_list(
$conf->supplier_proposal->dir_output.
'/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
1647 foreach ($listoffiles as $fileentry) {
1648 $dirsource = $fileentry[
'name'];
1649 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
1650 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
1651 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
1652 @rename($dirsource, $dirdest);
1661 $this->user_validation_id = $user->id;
1662 $this->datev = $now;
1663 $this->date_validation = $now;
1666 $result = $this->
add_contact($user->id,
'SALESREPFOLL',
'internal', 1);
1667 if ($result < 0 && $result != -2) {
1672 $this->db->commit();
1675 $this->db->rollback();
1679 dol_syslog(
"You don't have permission to validate supplier proposal", LOG_WARNING);
1708 if ($user->hasRight(
'supplier_proposal',
'creer')) {
1709 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal ";
1710 $sql .=
" SET date_livraison = ".(isDolTms($delivery_date) ?
"'".$this->db->idate($delivery_date).
"'" :
'null');
1711 $sql .=
" WHERE rowid = ".((int) $this->
id);
1713 if ($this->db->query($sql)) {
1714 $this->delivery_date = $delivery_date;
1717 $this->error = $this->db->error();
1718 dol_syslog(get_class($this).
"::setDeliveryDate Erreur SQL");
1735 public function reopen($user, $status, $note =
'', $notrigger = 0)
1739 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal";
1740 $sql .=
" SET fk_statut = ".((int) $status).
",";
1741 if (!empty($note)) {
1742 $sql .=
" note_private = '".$this->db->escape($note).
"',";
1744 $sql .=
" date_cloture = NULL, fk_user_cloture = NULL";
1745 $sql .=
" WHERE rowid = ".((int) $this->
id);
1749 dol_syslog(get_class($this).
"::reopen", LOG_DEBUG);
1750 $resql = $this->db->query($sql);
1753 $this->errors[] =
"Error ".$this->db->lasterror();
1758 $result = $this->call_trigger(
'PROPOSAL_SUPPLIER_REOPEN', $user);
1768 if (!empty($this->errors)) {
1769 foreach ($this->errors as $errmsg) {
1770 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
1771 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1774 $this->db->rollback();
1777 $this->statut = $status;
1780 $this->db->commit();
1796 global $langs,
$conf;
1806 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal";
1807 $sql .=
" SET fk_statut = ".((int) $status).
", note_private = '".$this->db->escape($note).
"', date_cloture='".$this->db->idate($now).
"', fk_user_cloture=".((int) $user->id);
1808 $sql .=
" WHERE rowid = ".((int) $this->
id);
1810 $resql = $this->db->query($sql);
1812 $this->statut = $status;
1815 $modelpdf =
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON_PDF_ODT_CLOSED', (empty($this->model_pdf) ?
'' : $this->model_pdf));
1816 $triggerName =
'PROPOSAL_SUPPLIER_CLOSE_REFUSED';
1819 $triggerName =
'PROPOSAL_SUPPLIER_CLOSE_SIGNED';
1820 $modelpdf =
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON_PDF_ODT_TOBILL', (empty($this->model_pdf) ?
'' : $this->model_pdf));
1827 $triggerName =
'PROPOSAL_SUPPLIER_CLASSIFY_BILLED';
1832 $outputlangs = $langs;
1835 $newlang = (
GETPOST(
'lang_id',
'aZ09') ?
GETPOST(
'lang_id',
'aZ09') : $this->thirdparty->default_lang);
1836 $outputlangs->setDefaultLang($newlang);
1839 $this->
generateDocument($modelpdf, $outputlangs, $hidedetails, $hidedesc, $hideref);
1843 $result = $this->call_trigger($triggerName, $user);
1850 $this->db->commit();
1853 $this->db->rollback();
1857 $this->error = $this->db->lasterror();
1858 $this->errors[] = $this->db->lasterror();
1859 $this->db->rollback();
1872 dol_syslog(get_class($this).
"::updateOrCreatePriceFournisseur", LOG_DEBUG);
1874 foreach ($this->lines as $product) {
1875 if ($product->subprice <= 0) {
1880 $multicurrency_tx = 1;
1881 $fk_multicurrency = 0;
1883 if (empty($this->thirdparty)) {
1887 $ref_fourn = $product->ref_fourn;
1888 if (empty($ref_fourn)) {
1889 $ref_fourn = $product->ref_supplier;
1891 if (
isModEnabled(
"multicurrency") && !empty($product->multicurrency_code)) {
1894 $productsupplier->id = $product->fk_product;
1896 $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);
1912 $price =
price2num($product->subprice * $product->qty,
'MU');
1913 $unitPrice =
price2num($product->subprice,
'MU');
1915 $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);
1917 $resql = $this->db->query($sql);
1919 $this->error = $this->db->error();
1920 $this->db->rollback();
1935 $price =
price2num($product->subprice * $product->qty,
'MU');
1937 $unitPrice =
price2num($product->subprice,
'MU');
1941 $sanitized_values = array(
1942 "'".$this->db->idate($now).
"'",
1943 (
int) $product->fk_product,
1944 (
int) $this->thirdparty->id,
1945 "'".$this->db->escape($product->ref_fourn).
"'",
1949 (
float) $product->tva_tx,
1953 if (!empty($product->multicurrency_code)) {
1954 include_once DOL_DOCUMENT_ROOT.
'/multicurrency/class/multicurrency.class.php';
1956 $multicurrency->fetch(0, $product->multicurrency_code);
1957 if (!empty($multicurrency->id)) {
1958 $sanitized_values[] = (int) $multicurrency->id;
1959 $sanitized_values[] =
"'".$this->db->escape($product->multicurrency_code).
"'";
1960 $sanitized_values[] = (float) $product->multicurrency_subprice;
1961 $sanitized_values[] = (float) $product->multicurrency_total_ht;
1962 $sanitized_values[] = (float) $multicurrency->rate->rate;
1964 for ($i = 0; $i < 5; $i++) {
1965 $sanitized_values[] =
'NULL';
1971 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.
'product_fournisseur_price ';
1972 $sql .=
'(datec, fk_product, fk_soc, ref_fourn, price, quantity, unitprice, tva_tx, fk_user';
1973 if (
isModEnabled(
"multicurrency") && !empty($product->multicurrency_code)) {
1974 $sql .=
',fk_multicurrency, multicurrency_code, multicurrency_unitprice, multicurrency_price, multicurrency_tx';
1976 $sql .=
') VALUES ('.implode(
',', $sanitized_values).
')';
1978 $resql = $this->db->query($sql);
1980 $this->error = $this->db->error();
1981 $this->db->rollback();
1999 if ($this->
status == self::STATUS_DRAFT) {
2000 dol_syslog(get_class($this).
"::setDraft already draft status", LOG_WARNING);
2004 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal";
2005 $sql .=
" SET fk_statut = ".self::STATUS_DRAFT;
2006 $sql .=
" WHERE rowid = ".((int) $this->
id);
2008 if ($this->db->query($sql)) {
2010 $this->oldcopy = clone $this;
2015 $result = $this->call_trigger(
'PROPOSAL_SUPPLIER_UNVALIDATE', $user);
2024 $this->db->commit();
2027 $this->db->rollback();
2050 public function liste_array($shortlist = 0, $draft = 0, $notcurrentuser = 0, $socid = 0, $limit = 0, $offset = 0, $sortfield =
'p.datec', $sortorder =
'DESC')
2058 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2059 $search_sale = $user->id;
2062 $sql =
"SELECT s.rowid, s.nom as name, s.client,";
2063 $sql .=
" p.rowid as supplier_proposalid, p.fk_statut, p.total_ht, p.ref, p.remise, ";
2064 $sql .=
" p.datep as dp, p.fin_validite as datelimite";
2065 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s, ".MAIN_DB_PREFIX.
"supplier_proposal as p, ".MAIN_DB_PREFIX.
"c_propalst as c";
2066 $sql .=
" WHERE p.entity IN (".getEntity(
'supplier_proposal').
")";
2067 $sql .=
" AND p.fk_soc = s.rowid";
2068 $sql .=
" AND p.fk_statut = c.id";
2070 $sql .=
" AND s.rowid = ".((int) $socid);
2073 $sql .=
" AND p.fk_statut = 0";
2075 if ($notcurrentuser > 0) {
2076 $sql .=
" AND p.fk_user_author <> ".((int) $user->id);
2079 if ($search_sale && $search_sale !=
'-1') {
2080 if ($search_sale == -2) {
2081 $sql .=
" AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = p.fk_soc)";
2082 } elseif ($search_sale > 0) {
2083 $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).
")";
2086 $sql .= $this->db->order($sortfield, $sortorder);
2087 $sql .= $this->db->plimit($limit, $offset);
2089 $result = $this->db->query($sql);
2091 $num = $this->db->num_rows($result);
2095 $obj = $this->db->fetch_object($result);
2097 if ($shortlist == 1) {
2098 $ga[$obj->supplier_proposalid] = $obj->ref;
2099 } elseif ($shortlist == 2) {
2100 $ga[$obj->supplier_proposalid] = $obj->ref.
' ('.$obj->name.
')';
2102 $ga[$i][
'id'] = $obj->supplier_proposalid;
2103 $ga[$i][
'ref'] = $obj->ref;
2104 $ga[$i][
'name'] = $obj->name;
2124 public function delete($user, $notrigger = 0)
2127 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
2135 $result = $this->call_trigger(
'PROPOSAL_SUPPLIER_DELETE', $user);
2144 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"categorie_supplier_proposal";
2145 $sql .=
" WHERE fk_supplier_proposal = ".((int) $this->
id);
2147 $result = $this->db->query($sql);
2150 $this->error = $this->db->lasterror();
2151 $this->errors[] = $this->error;
2156 $sanitized_main = MAIN_DB_PREFIX.
'supplier_proposaldet';
2157 $sanitized_ef = $sanitized_main.
"_extrafields";
2158 $sqlef =
"DELETE FROM $sanitized_ef WHERE fk_object IN (SELECT rowid FROM $sanitized_main WHERE fk_supplier_proposal = ".((int) $this->
id).
")";
2159 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"supplier_proposaldet WHERE fk_supplier_proposal = ".((int) $this->
id);
2160 if ($this->db->query($sql)) {
2161 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"supplier_proposal WHERE rowid = ".((int) $this->
id);
2162 if ($this->db->query($sqlef) && $this->db->query($sql)) {
2176 if ($conf->supplier_proposal->dir_output && !empty($this->
ref)) {
2177 $dir =
$conf->supplier_proposal->dir_output.
"/".$ref;
2178 $file = $dir.
"/".$ref.
".pdf";
2179 if (file_exists($file)) {
2183 $this->error =
'ErrorFailToDeleteFile';
2184 $this->errors = array(
'ErrorFailToDeleteFile');
2185 $this->db->rollback();
2189 if (file_exists($dir)) {
2192 $this->error =
'ErrorFailToDeleteDir';
2193 $this->errors = array(
'ErrorFailToDeleteDir');
2194 $this->db->rollback();
2207 dol_syslog(get_class($this).
"::delete erreur ".$errorflag.
" ".$this->error, LOG_ERR);
2212 dol_syslog(get_class($this).
"::delete ".$this->
id.
" by ".$user->id, LOG_DEBUG);
2213 $this->db->commit();
2216 $this->error = $this->db->lasterror();
2217 $this->db->rollback();
2221 $this->error = $this->db->lasterror();
2222 $this->db->rollback();
2226 $this->error = $this->db->lasterror();
2227 $this->db->rollback();
2231 $this->db->rollback();
2244 $sql =
"SELECT c.rowid, GREATEST(c.tms, COALESCE(cef.tms, c.tms)) as date_modification,";
2245 $sql .=
" c.datec as date_creation, c.date_valid as date_validation, c.date_cloture as date_closure,";
2246 $sql .=
" c.fk_user_author, c.fk_user_modif, c.fk_user_valid, c.fk_user_cloture";
2247 $sql .=
" FROM ".MAIN_DB_PREFIX.
"supplier_proposal as c";
2248 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"supplier_proposal_extrafields as cef ON cef.fk_object=c.rowid";
2249 $sql .=
" WHERE c.rowid = ".((int) $id);
2251 $result = $this->db->query($sql);
2254 if ($this->db->num_rows($result)) {
2255 $obj = $this->db->fetch_object($result);
2257 $this->
id = $obj->rowid;
2259 $this->date_creation = $this->db->jdate($obj->date_creation);
2260 $this->date_modification = empty($obj->date_modification) ?
'' : $this->db->jdate($obj->date_modification);
2261 $this->date_validation = $this->db->jdate($obj->date_validation);
2262 $this->date_cloture = $this->db->jdate($obj->date_closure);
2264 $this->user_creation_id = $obj->fk_user_author;
2265 $this->user_modification_id = $obj->fk_user_modif;
2266 $this->user_validation_id = $obj->fk_user_valid;
2267 $this->user_closing_id = $obj->fk_user_cloture;
2269 $this->db->free($result);
2300 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
2302 $langs->load(
"supplier_proposal");
2303 $this->labelStatus[
self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusDraft");
2304 $this->labelStatus[
self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusValidated");
2305 $this->labelStatus[
self::STATUS_SIGNED] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusSigned");
2306 $this->labelStatus[
self::STATUS_NOTSIGNED] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusNotSigned");
2307 $this->labelStatus[
self::STATUS_CLOSE] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusClosed");
2308 $this->labelStatusShort[
self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusDraftShort");
2309 $this->labelStatusShort[
self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusValidatedShort");
2310 $this->labelStatusShort[
self::STATUS_SIGNED] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusSignedShort");
2311 $this->labelStatusShort[
self::STATUS_NOTSIGNED] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusNotSignedShort");
2312 $this->labelStatusShort[
self::STATUS_CLOSE] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusClosedShort");
2316 if ($status == self::STATUS_DRAFT) {
2317 $statusnew =
'status0';
2318 } elseif ($status == self::STATUS_VALIDATED) {
2319 $statusnew =
'status1';
2320 } elseif ($status == self::STATUS_SIGNED) {
2321 $statusnew =
'status4';
2322 } elseif ($status == self::STATUS_NOTSIGNED) {
2323 $statusnew =
'status9';
2324 } elseif ($status == self::STATUS_CLOSE) {
2325 $statusnew =
'status6';
2328 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusnew, $mode);
2343 global
$conf, $langs;
2349 $sql =
"SELECT p.rowid, p.ref, p.datec as datec, p.date_cloture as datefin";
2350 $sql .=
" FROM ".MAIN_DB_PREFIX.
"supplier_proposal as p";
2351 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2352 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON p.fk_soc = sc.fk_soc";
2353 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
2356 $sql .= $clause.
" p.entity IN (".
getEntity(
'supplier_proposal').
")";
2357 if ($mode ==
'opened') {
2358 $sql .=
" AND p.fk_statut = 1";
2360 if ($mode ==
'signed') {
2361 $sql .=
" AND p.fk_statut = 2";
2364 $sql .=
" AND p.fk_soc = ".((int) $user->socid);
2367 $resql = $this->db->query($sql);
2369 $label = $labelShort =
'';
2372 if ($mode ==
'opened') {
2373 $delay_warning = !empty(
$conf->supplier_proposal->cloture->warning_delay) ?
$conf->supplier_proposal->cloture->warning_delay : 0;
2375 $label = $langs->trans(
"SupplierProposalsToClose");
2376 $labelShort = $langs->trans(
"ToAcceptRefuse");
2378 if ($mode ==
'signed') {
2379 $delay_warning = !empty(
$conf->supplier_proposal->facturation->warning_delay) ?
$conf->supplier_proposal->facturation->warning_delay : 0;
2381 $label = $langs->trans(
"SupplierProposalsToProcess");
2382 $labelShort = $langs->trans(
"ToClose");
2386 $response->warning_delay = $delay_warning / 60 / 60 / 24;
2387 $response->label = $label;
2388 $response->labelShort = $labelShort;
2389 $response->url = DOL_URL_ROOT.
'/supplier_proposal/list.php?search_status='.$status;
2393 while ($obj = $this->db->fetch_object($resql)) {
2394 $response->nbtodo++;
2395 if ($mode ==
'opened') {
2396 $datelimit = $this->db->jdate($obj->datefin);
2397 if ($datelimit < ($now - $delay_warning)) {
2398 $response->nbtodolate++;
2406 $this->error = $this->db->lasterror();
2422 global
$conf, $langs;
2427 $sql =
"SELECT rowid";
2428 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product";
2429 $sql .=
" WHERE entity IN (".getEntity(
'product').
")";
2430 if (array_key_exists(
'tobuy', $param)) {
2431 $sql .=
" AND tobuy = ".((int) $param[
'tobuy']);
2433 $sql .= $this->db->plimit(100);
2435 $resql = $this->db->query($sql);
2437 $num_prods = $this->db->num_rows($resql);
2439 while ($i < $num_prods) {
2441 $row = $this->db->fetch_row($resql);
2442 $prodids[$i] = $row[0];
2448 $this->
ref =
'SPECIMEN';
2449 $this->ref_supplier =
'NEMICEPS';
2450 $this->specimen = 1;
2452 $this->
date = time();
2453 $this->cond_reglement_id = 1;
2454 $this->cond_reglement_code =
'RECEP';
2455 $this->mode_reglement_id = 7;
2456 $this->mode_reglement_code =
'CHQ';
2457 $this->note_public =
'This is a comment (public)';
2458 $this->note_private =
'This is a comment (private)';
2460 $this->multicurrency_tx = 1;
2466 while ($xnbp < $nbp) {
2468 $line->desc = $langs->trans(
"Description").
" ".$xnbp;
2470 $line->subprice = 100;
2471 $line->tva_tx = 19.6;
2472 $line->localtax1_tx = 0;
2473 $line->localtax2_tx = 0;
2475 $line->total_ht = 50;
2476 $line->total_ttc = 59.8;
2477 $line->total_tva = 9.8;
2478 $line->remise_percent = 50;
2480 $line->total_ht = 100;
2481 $line->total_ttc = 119.6;
2482 $line->total_tva = 19.6;
2483 $line->remise_percent = 00;
2486 if ($num_prods > 0) {
2487 $prodid = mt_rand(1, $num_prods);
2488 $line->fk_product = $prodids[$prodid];
2491 $this->lines[$xnbp] = $line;
2493 $this->total_ht += $line->total_ht;
2494 $this->total_tva += $line->total_tva;
2495 $this->total_ttc += $line->total_ttc;
2512 $this->nb = array();
2515 $sql =
"SELECT count(p.rowid) as nb";
2516 $sql .=
" FROM ".MAIN_DB_PREFIX.
"supplier_proposal as p";
2517 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON p.fk_soc = s.rowid";
2518 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2519 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON s.rowid = sc.fk_soc";
2520 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
2523 $sql .=
" ".$clause.
" p.entity IN (".
getEntity(
'supplier_proposal').
")";
2525 $resql = $this->db->query($sql);
2528 while ($obj = $this->db->fetch_object($resql)) {
2529 $this->nb[
"supplier_proposals"] = $obj->nb;
2531 $this->db->free($resql);
2535 $this->error = $this->db->lasterror();
2548 public function getNextNumRef($soc)
2550 global
$conf, $db, $langs;
2551 $langs->load(
"supplier_proposal");
2560 $dirmodels = array_merge(array(
'/'), (array)
$conf->modules_parts[
'models']);
2561 foreach ($dirmodels as $reldir) {
2562 $dir =
dol_buildpath($reldir.
"core/modules/supplier_proposal/");
2565 $mybool = ((bool) @include_once $dir.$file) || $mybool;
2573 $obj =
new $classname();
2574 '@phan-var-force ModeleNumRefSupplierProposal $obj';
2577 $numref = $obj->getNextValue($soc, $this);
2579 if ($numref !=
"") {
2582 $this->error = $obj->error;
2586 $langs->load(
"errors");
2587 print $langs->trans(
"Error").
" ".$langs->trans(
"ErrorModuleSetupNotComplete", $langs->transnoentitiesnoconv(
"SupplierProposal"));
2600 global
$conf, $langs;
2602 $langs->load(
'supplier_proposal');
2605 return [
'optimize' => $langs->trans(
"ShowSupplierProposal")];
2611 $datas[
'picto'] =
img_picto(
'', $this->picto).
' <u class="paddingrightonly">'.$langs->trans(
"SupplierProposal").
'</u>';
2612 if (isset($this->
status)) {
2613 $datas[
'picto'] .=
' '.$this->getLibStatut(5);
2615 if (!empty($this->
ref)) {
2616 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
2618 if (!empty($this->ref_fourn)) {
2619 $datas[
'ref_supplier'] =
'<br><b>'.$langs->trans(
'RefSupplier').
':</b> '.$this->ref_fourn;
2621 if (!empty($this->total_ht)) {
2622 $datas[
'amount_ht'] =
'<br><b>'.$langs->trans(
'AmountHT').
':</b> '.
price($this->total_ht, 0, $langs, 0, -1, -1,
getDolCurrency());
2624 if (!empty($this->total_tva)) {
2625 $datas[
'amount_vat'] =
'<br><b>'.$langs->trans(
'VAT').
':</b> '.
price($this->total_tva, 0, $langs, 0, -1, -1,
getDolCurrency());
2627 if (!empty($this->total_ttc)) {
2628 $datas[
'amount_ttc'] =
'<br><b>'.$langs->trans(
'AmountTTC').
':</b> '.
price($this->total_ttc, 0, $langs, 0, -1, -1,
getDolCurrency());
2645 public function getNomUrl($withpicto = 0, $option =
'', $get_params =
'', $notooltip = 0, $save_lastsearch_value = -1, $addlinktonotes = 0)
2647 global $langs,
$conf, $user, $hookmanager;
2649 if (!empty(
$conf->dol_no_mouse_hover)) {
2657 'objecttype' => $this->element,
2658 'option' => $option,
2660 $classfortooltip =
'classfortooltip';
2663 $classfortooltip =
'classforajaxtooltip';
2664 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
2670 if ($option ==
'') {
2671 $url = DOL_URL_ROOT.
'/supplier_proposal/card.php?id='.$this->
id.$get_params;
2673 if ($option ==
'document') {
2674 $url = DOL_URL_ROOT.
'/supplier_proposal/document.php?id='.$this->
id.$get_params;
2677 if ($option !==
'nolink') {
2679 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
2680 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
2681 $add_save_lastsearch_values = 1;
2683 if ($add_save_lastsearch_values) {
2684 $url .=
'&save_lastsearch_values=1';
2689 if (empty($notooltip) && $user->hasRight(
'propal',
'lire')) {
2691 $label = $langs->trans(
"ShowSupplierProposal");
2692 $linkclose .=
' alt="'.dolPrintHTMLForAttribute($label).
'"';
2694 $linkclose .= ($label ?
' title="'.dolPrintHTMLForAttribute($label).
'"' :
' title="tocomplete"');
2695 $linkclose .= $dataparams.
' class="'.$classfortooltip.
'"';
2698 $linkstart =
'<a href="'.$url.
'"';
2699 $linkstart .= $linkclose.
'>';
2702 $result .= $linkstart;
2704 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), (($withpicto != 2) ?
'class="paddingright"' :
''), 0, 0, $notooltip ? 0 : 1);
2706 if ($withpicto != 2) {
2707 $result .= $this->ref;
2709 $result .= $linkend;
2711 if ($addlinktonotes) {
2712 $txttoshow = ($user->socid > 0 ? $this->note_public : $this->note_private);
2715 $result .=
' <span class="note inline-block">';
2716 $result .=
'<a href="'.DOL_URL_ROOT.
'/supplier_proposal/note.php?id='.$this->
id.
'" class="classfortooltip" title="'.
dol_escape_htmltag($notetoshow).
'">';
2721 $result .=
'</span>';
2725 $hookmanager->initHooks(array($this->element .
'dao'));
2726 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
2727 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
2729 $result = $hookmanager->resPrint;
2731 $result .= $hookmanager->resPrint;
2745 $sql =
'SELECT pt.rowid, pt.label as custom_label, pt.description, pt.fk_product, pt.fk_remise_except,';
2746 $sql .=
' pt.qty, pt.tva_tx, pt.vat_src_code, pt.remise_percent, pt.subprice, pt.info_bits,';
2747 $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,';
2748 $sql .=
' pt.product_type, pt.rang, pt.fk_parent_line, pt.extraparams,';
2749 $sql .=
' p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid,';
2750 $sql .=
' p.description as product_desc, pt.ref_fourn as ref_supplier,';
2751 $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';
2752 $sql .=
' FROM '.MAIN_DB_PREFIX.
'supplier_proposaldet as pt';
2753 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON pt.fk_product=p.rowid';
2754 $sql .=
' WHERE pt.fk_supplier_proposal = '.((int) $this->
id);
2755 $sql .=
' ORDER BY pt.rang ASC, pt.rowid';
2757 dol_syslog(get_class($this).
'::getLinesArray', LOG_DEBUG);
2758 $resql = $this->db->query($sql);
2760 $num = $this->db->num_rows($resql);
2764 $obj = $this->db->fetch_object($resql);
2767 $this->lines[$i]->id = $obj->rowid;
2768 $this->lines[$i]->rowid = $obj->rowid;
2770 $this->lines[$i]->label = $obj->custom_label;
2771 $this->lines[$i]->description = $obj->description;
2772 $this->lines[$i]->desc = $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;
2803 $this->lines[$i]->fk_multicurrency = $obj->fk_multicurrency;
2804 $this->lines[$i]->multicurrency_code = $obj->multicurrency_code;
2805 $this->lines[$i]->multicurrency_subprice = $obj->multicurrency_subprice;
2806 $this->lines[$i]->multicurrency_total_ht = $obj->multicurrency_total_ht;
2807 $this->lines[$i]->multicurrency_total_tva = $obj->multicurrency_total_tva;
2808 $this->lines[$i]->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
2809 $this->lines[$i]->fk_unit = $obj->fk_unit;
2810 $this->lines[$i]->extraparams = !empty($obj->extraparams) ? (array) json_decode($obj->extraparams,
true) : array();
2812 $this->lines[$i]->fetch_optionals();
2816 $this->db->free($resql);
2820 $this->error = $this->db->error();
2836 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
2840 $langs->load(
"supplier_proposal");
2841 $outputlangs->load(
"products");
2846 if ($this->model_pdf) {
2847 $modele = $this->model_pdf;
2853 if (empty($modele)) {
2857 $modelpath =
"core/modules/supplier_proposal/doc/";
2859 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
2891 'supplier_proposaldet'
2909 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
2911 $return =
'<div class="box-flex-item box-flex-grow-zero">';
2912 $return .=
'<div class="info-box info-box-sm">';
2913 $return .=
'<span class="info-box-icon bg-infobox-action">';
2916 $return .=
'</span>';
2917 $return .=
'<div class="info-box-content">';
2918 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl() : $this->ref).
'</span>';
2919 if ($selected >= 0) {
2920 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2922 if (property_exists($this,
'socid')) {
2923 $return .=
'<span class="info-box-ref"> | '.$this->socid.
'</span>';
2925 if (property_exists($this,
'delivery_date')) {
2926 $return .=
'<br><span class="opacitymedium">'.$langs->trans(
"DateEnd").
'</span> : <span class="info-box-label">'.
dol_print_date($this->delivery_date).
'</span>';
2928 if (property_exists($this,
'total_ttc')) {
2929 $return .=
'<br><span class="opacitymedium" >'.$langs->trans(
"AmountHT").
' : </span><span class="info-box-label amount">'.
price($this->total_ttc).
'</span>';
2931 if (method_exists($this,
'getLibStatut')) {
2932 $return .=
'<br><div class="info-box-status">'.$this->getLibStatut(3).
'</div>';
2934 $return .=
'</div>';
2935 $return .=
'</div>';
2936 $return .=
'</div>';
2952 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
2953 return parent::setCategoriesCommon($categories, Categorie::TYPE_SUPPLIER_PROPOSAL);
2976 public $element =
'supplier_proposaldet';
2981 public $table_element =
'supplier_proposaldet';
3006 public $fk_supplier_proposal;
3011 public $fk_parent_line;
3028 public $fk_product_type;
3047 public $vat_src_code;
3052 public $remise_percent;
3057 public $fk_remise_except;
3067 public $fk_fournprice;
3085 public $special_code;
3093 public $info_bits = 0;
3131 public $product_ref;
3144 public $product_label;
3156 public $product_desc;
3161 public $localtax1_tx;
3165 public $localtax2_tx;
3169 public $localtax1_type;
3173 public $localtax2_type;
3177 public $total_localtax1;
3181 public $total_localtax2;
3186 public $skip_update_total;
3195 public $ref_supplier;
3201 public $fk_multicurrency;
3206 public $multicurrency_code;
3210 public $multicurrency_subprice;
3214 public $multicurrency_total_ht;
3218 public $multicurrency_total_tva;
3222 public $multicurrency_total_ttc;
3242 $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,';
3243 $sql .=
' pd.date_start, pd.date_end,';
3244 $sql .=
' pd.remise, pd.remise_percent, pd.fk_remise_except, pd.subprice, pd.subprice_ttc,';
3245 $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,';
3246 $sql .=
' pd.localtax1_tx, pd.localtax2_tx, pd.total_localtax1, pd.total_localtax2,';
3247 $sql .=
' p.ref as product_ref, p.label as product_label, p.description as product_desc,';
3248 $sql .=
' pd.product_type, pd.ref_fourn as ref_produit_fourn, pd.extraparams,';
3249 $sql .=
' pd.fk_multicurrency, pd.multicurrency_code, pd.multicurrency_subprice, pd.multicurrency_subprice_ttc, pd.multicurrency_total_ht, pd.multicurrency_total_tva, pd.multicurrency_total_ttc, pd.fk_unit';
3250 $sql .=
' FROM '.MAIN_DB_PREFIX.
'supplier_proposaldet as pd';
3251 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON pd.fk_product = p.rowid';
3252 $sql .=
' WHERE pd.rowid = '.((int) $rowid);
3254 $result = $this->db->query($sql);
3256 if ($objp = $this->db->fetch_object($result)) {
3257 $this->
id = $objp->rowid;
3258 $this->fk_supplier_proposal = $objp->fk_supplier_proposal;
3259 $this->fk_parent_line = $objp->fk_parent_line;
3260 $this->label = $objp->custom_label;
3261 $this->desc = $objp->description;
3262 $this->qty = $objp->qty;
3264 $this->subprice = $objp->subprice;
3265 $this->subprice_ttc = $objp->subprice_ttc;
3267 $this->tva_tx = $objp->tva_tx;
3268 $this->remise_percent = $objp->remise_percent;
3269 $this->fk_remise_except = $objp->fk_remise_except;
3270 $this->fk_product = $objp->fk_product;
3271 $this->info_bits = $objp->info_bits;
3272 $this->date_start = $this->db->jdate($objp->date_start);
3273 $this->date_end = $this->db->jdate($objp->date_end);
3275 $this->total_ht = $objp->total_ht;
3276 $this->total_tva = $objp->total_tva;
3277 $this->total_ttc = $objp->total_ttc;
3279 $this->fk_fournprice = $objp->fk_fournprice;
3281 $marginInfos =
getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $this->fk_fournprice, $objp->pa_ht);
3282 $this->pa_ht = $marginInfos[0];
3283 $this->marge_tx = $marginInfos[1];
3284 $this->marque_tx = $marginInfos[2];
3286 $this->special_code = $objp->special_code;
3287 $this->product_type = $objp->product_type;
3288 $this->rang = $objp->rang;
3290 $this->product_ref = $objp->product_ref;
3291 $this->product_label = $objp->product_label;
3292 $this->product_desc = $objp->product_desc;
3294 $this->ref_fourn = $objp->ref_produit_fourn;
3296 $this->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams,
true) : array();
3299 $this->fk_multicurrency = $objp->fk_multicurrency;
3300 $this->multicurrency_code = $objp->multicurrency_code;
3301 $this->multicurrency_subprice = $objp->multicurrency_subprice;
3302 $this->multicurrency_subprice_ttc = $objp->multicurrency_subprice_ttc;
3303 $this->multicurrency_total_ht = $objp->multicurrency_total_ht;
3304 $this->multicurrency_total_tva = $objp->multicurrency_total_tva;
3305 $this->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
3306 $this->fk_unit = $objp->fk_unit;
3308 $this->db->free($result);
3330 dol_syslog(get_class($this).
"::insert rang=".$this->rang);
3333 if (empty($this->tva_tx)) {
3336 if (empty($this->vat_src_code)) {
3337 $this->vat_src_code =
'';
3339 if (empty($this->localtax1_tx)) {
3340 $this->localtax1_tx = 0;
3342 if (empty($this->localtax2_tx)) {
3343 $this->localtax2_tx = 0;
3345 if (empty($this->localtax1_type)) {
3346 $this->localtax1_type =
'';
3348 if (empty($this->localtax2_type)) {
3349 $this->localtax2_type =
'';
3351 if (empty($this->total_localtax1)) {
3352 $this->total_localtax1 = 0;
3354 if (empty($this->total_localtax2)) {
3355 $this->total_localtax2 = 0;
3357 if (empty($this->rang)) {
3360 if (empty($this->remise_percent)) {
3361 $this->remise_percent = 0;
3363 if (empty($this->info_bits)) {
3364 $this->info_bits = 0;
3366 if (empty($this->special_code)) {
3367 $this->special_code = 0;
3369 if (empty($this->fk_parent_line)) {
3370 $this->fk_parent_line = 0;
3372 if (empty($this->fk_fournprice)) {
3373 $this->fk_fournprice = 0;
3375 if (empty($this->fk_unit)) {
3378 if (empty($this->subprice)) {
3379 $this->subprice = 0;
3382 if (empty($this->pa_ht)) {
3387 if ($this->pa_ht == 0) {
3388 $result = $this->
defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product, $this->qty);
3392 $this->pa_ht = $result;
3397 if ($this->product_type < 0) {
3404 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.
'supplier_proposaldet';
3405 $sql .=
' (fk_supplier_proposal, fk_parent_line, label, description, fk_product, product_type,';
3406 $sql .=
' date_start, date_end,';
3407 $sql .=
' fk_remise_except, qty, tva_tx, vat_src_code, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type,';
3408 $sql .=
' subprice, subprice_ttc, remise_percent, ';
3409 $sql .=
' info_bits, ';
3410 $sql .=
' total_ht, total_tva, total_localtax1, total_localtax2, total_ttc, fk_product_fournisseur_price, buy_price_ht, special_code, rang,';
3411 $sql .=
' ref_fourn,';
3412 $sql .=
' fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_subprice_ttc, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc, fk_unit)';
3413 $sql .=
" VALUES (".((int) $this->fk_supplier_proposal).
",";
3414 $sql .=
" ".($this->fk_parent_line > 0 ? ((int) $this->fk_parent_line) :
"null").
",";
3415 $sql .=
" ".(!empty($this->label) ?
"'".$this->db->escape($this->label).
"'" :
"null").
",";
3416 $sql .=
" '".$this->db->escape($this->desc).
"',";
3417 $sql .=
" ".($this->fk_product ? ((int) $this->fk_product) :
"null").
",";
3418 $sql .=
" ".((int) $this->product_type).
",";
3419 $sql .=
" ".($this->date_start ?
"'".$this->db->idate($this->date_start).
"'" :
"null").
",";
3420 $sql .=
" ".($this->date_end ?
"'".$this->db->idate($this->date_end).
"'" :
"null").
",";
3421 $sql .=
" ".($this->fk_remise_except ? ((int) $this->fk_remise_except) :
"null").
",";
3422 $sql .=
" ".(float)
price2num($this->qty,
'MS').
",";
3423 $sql .=
" ".(float)
price2num($this->tva_tx).
",";
3424 $sql .=
" '".$this->db->escape($this->vat_src_code).
"',";
3425 $sql .=
" ".(float)
price2num($this->localtax1_tx).
",";
3426 $sql .=
" ".(float)
price2num($this->localtax2_tx).
",";
3427 $sql .=
" '".$this->db->escape($this->localtax1_type).
"',";
3428 $sql .=
" '".$this->db->escape($this->localtax2_type).
"',";
3429 $sql .=
" ".(float)
price2num($this->subprice,
'MU') .
",";
3430 $sql .=
" ".(float)
price2num($this->subprice_ttc,
'MU') .
",";
3431 $sql .=
" ".((float) $this->remise_percent).
",";
3432 $sql .=
" ".(isset($this->info_bits) ? ((int) $this->info_bits) :
"null").
",";
3433 $sql .=
" ".(float)
price2num($this->total_ht,
'MT').
",";
3434 $sql .=
" ".(float)
price2num($this->total_tva,
'MT').
",";
3435 $sql .=
" ".(float)
price2num($this->total_localtax1,
'MT').
",";
3436 $sql .=
" ".(float)
price2num($this->total_localtax2,
'MT').
",";
3437 $sql .=
" ".(float)
price2num($this->total_ttc,
'MT').
",";
3438 $sql .=
" ".(!empty($this->fk_fournprice) ? ((int) $this->fk_fournprice) :
"null").
",";
3439 $sql .=
" ".(isset($this->pa_ht) ? (float)
price2num($this->pa_ht,
'MU') :
"null").
",";
3440 $sql .=
' '.((int) $this->special_code).
',';
3441 $sql .=
' '.((int) $this->rang).
',';
3442 $sql .=
" '".$this->db->escape($this->ref_fourn).
"'";
3443 $sql .=
", ".($this->fk_multicurrency > 0 ? ((int) $this->fk_multicurrency) :
'null');
3444 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
3445 $sql .=
", ".(float)
price2num($this->multicurrency_subprice,
'CU');
3446 $sql .=
", ".(float)
price2num($this->multicurrency_subprice_ttc,
'CU');
3447 $sql .=
", ".(float)
price2num($this->multicurrency_total_ht,
'CT');
3448 $sql .=
", ".(float)
price2num($this->multicurrency_total_tva,
'CT');
3449 $sql .=
", ".(float)
price2num($this->multicurrency_total_ttc,
'CT');
3450 $sql .=
", ".($this->fk_unit ? ((int) $this->fk_unit) :
'null');
3453 dol_syslog(get_class($this).
'::insert', LOG_DEBUG);
3454 $resql = $this->db->query($sql);
3456 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
'supplier_proposaldet');
3465 if (!$error && !$notrigger) {
3467 $result = $this->call_trigger(
'LINESUPPLIER_PROPOSAL_INSERT', $user);
3469 $this->db->rollback();
3475 $this->db->commit();
3478 $this->error = $this->db->error().
" sql=".$sql;
3479 $this->db->rollback();
3490 public function delete($user)
3496 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"supplier_proposaldet";
3497 $sql .=
" WHERE rowid = ".((int) $this->
id);
3499 if ($this->db->query($sql)) {
3505 dol_syslog(get_class($this).
"::delete error -4 ".$this->error, LOG_ERR);
3510 $result = $this->call_trigger(
'LINESUPPLIER_PROPOSAL_DELETE', $user);
3512 $this->db->rollback();
3517 $this->db->commit();
3521 $this->error = $this->db->error().
" sql=".$sql;
3522 $this->db->rollback();
3540 if (empty($this->tva_tx)) {
3543 if (empty($this->localtax1_tx)) {
3544 $this->localtax1_tx = 0;
3546 if (empty($this->localtax2_tx)) {
3547 $this->localtax2_tx = 0;
3549 if (empty($this->total_localtax1)) {
3550 $this->total_localtax1 = 0;
3552 if (empty($this->total_localtax2)) {
3553 $this->total_localtax2 = 0;
3555 if (empty($this->localtax1_type)) {
3556 $this->localtax1_type =
'';
3558 if (empty($this->localtax2_type)) {
3559 $this->localtax2_type =
'';
3561 if (empty($this->marque_tx)) {
3562 $this->marque_tx = 0;
3564 if (empty($this->marge_tx)) {
3565 $this->marge_tx = 0;
3567 if (empty($this->remise_percent)) {
3568 $this->remise_percent = 0;
3570 if (empty($this->info_bits)) {
3571 $this->info_bits = 0;
3573 if (empty($this->special_code)) {
3574 $this->special_code = 0;
3576 if (empty($this->fk_parent_line)) {
3577 $this->fk_parent_line = 0;
3579 if (empty($this->fk_fournprice)) {
3580 $this->fk_fournprice = 0;
3582 if (empty($this->fk_unit)) {
3585 if (empty($this->subprice)) {
3586 $this->subprice = 0;
3589 if (empty($this->pa_ht)) {
3594 if ($this->pa_ht == 0) {
3595 $result = $this->
defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product, $this->qty);
3599 $this->pa_ht = $result;
3606 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposaldet SET";
3607 $sql .=
" description = '".$this->db->escape($this->desc).
"'";
3608 $sql .=
" , label = ".(!empty($this->label) ?
"'".$this->db->escape($this->label).
"'" :
"null");
3609 $sql .=
" , product_type = ".((int) $this->product_type);
3610 $sql .=
" , date_start = ".($this->date_start ?
"'".$this->db->idate($this->date_start).
"'" :
"null");
3611 $sql .=
" , date_end = ".($this->date_end ?
"'".$this->db->idate($this->date_end).
"'" :
"null");
3612 $sql .=
" , tva_tx = '".price2num($this->tva_tx).
"'";
3613 $sql .=
" , localtax1_tx = ".(float)
price2num($this->localtax1_tx);
3614 $sql .=
" , localtax2_tx = ".(float)
price2num($this->localtax2_tx);
3615 $sql .=
" , localtax1_type = '".$this->db->escape($this->localtax1_type).
"'";
3616 $sql .=
" , localtax2_type = '".$this->db->escape($this->localtax2_type).
"'";
3617 $sql .=
" , qty = ".(float)
price2num($this->qty);
3618 $sql .=
" , subprice = ".(float)
price2num($this->subprice);
3619 $sql .=
" , subprice_ttc = ".(float)
price2num($this->subprice_ttc);
3620 $sql .=
" , remise_percent = ".(float)
price2num($this->remise_percent);
3621 $sql .=
" , info_bits = ".((int) $this->info_bits);
3622 if (empty($this->skip_update_total)) {
3623 $sql .=
" , total_ht = ".(float)
price2num($this->total_ht);
3624 $sql .=
" , total_tva = ".(float)
price2num($this->total_tva);
3625 $sql .=
" , total_ttc = ".(float)
price2num($this->total_ttc);
3626 $sql .=
" , total_localtax1 = ".(float)
price2num($this->total_localtax1);
3627 $sql .=
" , total_localtax2 = ".(float)
price2num($this->total_localtax2);
3629 $sql .=
" , fk_product_fournisseur_price = ".(!empty($this->fk_fournprice) ?
"'".$this->db->escape((
string) $this->fk_fournprice).
"'" :
"null");
3630 $sql .=
" , buy_price_ht = ".(float)
price2num($this->pa_ht);
3631 $sql .=
" , special_code = ".((int) $this->special_code);
3632 $sql .=
" , fk_parent_line = ".($this->fk_parent_line > 0 ? ((int) $this->fk_parent_line) :
"null");
3633 if (!empty($this->rang)) {
3634 $sql .=
", rang = ".((int) $this->rang);
3636 $sql .=
" , ref_fourn = ".(!empty($this->ref_fourn) ?
"'".$this->db->escape($this->ref_fourn).
"'" :
"null");
3637 $sql .=
" , fk_unit = ".($this->fk_unit ? (int) $this->fk_unit :
'null');
3640 $sql .=
" , multicurrency_subprice = ".(float)
price2num($this->multicurrency_subprice);
3641 $sql .=
" , multicurrency_subprice_ttc = ".(float)
price2num($this->multicurrency_subprice_ttc);
3642 $sql .=
" , multicurrency_total_ht = ".(float)
price2num($this->multicurrency_total_ht);
3643 $sql .=
" , multicurrency_total_tva = ".(float)
price2num($this->multicurrency_total_tva);
3644 $sql .=
" , multicurrency_total_ttc = ".(float)
price2num($this->multicurrency_total_ttc);
3646 $sql .=
" WHERE rowid = ".((int) $this->
id);
3648 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
3649 $resql = $this->db->query($sql);
3658 if (!$error && !$notrigger) {
3660 $result = $this->call_trigger(
'LINESUPPLIER_PROPOSAL_MODIFY', $user);
3662 $this->db->rollback();
3668 $this->db->commit();
3671 $this->error = $this->db->error();
3672 $this->db->rollback();
3690 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposaldet SET";
3691 $sql .=
" total_ht = ".(float)
price2num($this->total_ht,
'MT');
3692 $sql .=
",total_tva = ".(float)
price2num($this->total_tva,
'MT');
3693 $sql .=
",total_ttc = ".(float)
price2num($this->total_ttc,
'MT');
3694 $sql .=
" WHERE rowid = ".((int) $this->
id);
3696 dol_syslog(
"SupplierProposalLine::update_total", LOG_DEBUG);
3698 $resql = $this->db->query($sql);
3700 $this->db->commit();
3703 $this->error = $this->db->error();
3704 $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.
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
fetch_thirdparty($force_thirdparty_id=0)
Load the third party of object, from id $this->socid or $this->fk_soc, into this->thirdparty.
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
Delete all links between an object $this.
setErrorsFromObject($object)
setErrorsFromObject
isLineOfObject($lineid)
Check that a line belongs to this object, using $this->table_element_line and $this->fk_element.
static isExistingObject($element, $id, $ref='', $ref_ext='')
Check if an object id or ref exists If you don't need or want to instantiate the object and just need...
updateRangOfLine($rowid, $rang)
Update position of line (rang)
checkActiveProductInLines($status='onsale')
Check if all products have the right status (on sale, on buy) called during validation of propal,...
deleteExtraFields()
Delete all extra fields values for the current object.
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
static commonReplaceProduct(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a product id with another one.
line_max($fk_parent_line=0)
Get max value used for position of line (rang)
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
defineBuyPrice($unitPrice=0.0, $discountPercent=0.0, $fk_product=0, $qty=0)
Get buy price to use for margin calculation.
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.
initAsSpecimen($param=array())
Initialise an instance with random values.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1=0, $txlocaltax2=0, $fk_product=0, $remise_percent=0, $price_base_type='HT', $pu_ttc=0, $info_bits=0, $type=0, $rang=-1, $special_code=0, $fk_parent_line=0, $fk_fournprice=0, $pa_ht=0, $label='', $array_options=[], $ref_supplier='', $fk_unit=0, $origin='', $origin_id=0, $pu_ht_devise=0, $date_start=0, $date_end=0)
Add a proposal line into database (linked to product/service or not) The parameters are already suppo...
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)
Reopen the commercial proposal.
static replaceProduct(DoliDB $db, $origin_id, $dest_id)
Function used to replace a product id with another one.
fetch($rowid, $ref='')
Load a proposal from database and its lines array.
load_board($user, $mode)
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
createFromClone(User $user, $fromid=0)
Load an object from its id and create a new one in database.
const STATUS_NOTSIGNED
Not signed quote, canceled.
const STATUS_DRAFT
Draft status.
liste_array($shortlist=0, $draft=0, $notcurrentuser=0, $socid=0, $limit=0, $offset=0, $sortfield='p.datec', $sortorder='DESC')
Return list of askprice (eventually filtered on user) into an array.
update($user, $notrigger=0)
Update the header fields of the price request that can be edited without a dedicated action.
setDeliveryDate($user, $delivery_date)
Set delivery date.
__construct($db, $socid=0, $supplier_proposalid=0)
Constructor.
LibStatut($status, $mode=1)
Return label of a status (draft, validated, ...)
setCategories($categories)
Sets object to supplied categories.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
updateOrCreatePriceFournisseur($user)
Add or update supplier price according to result of proposal.
loadStateBoard()
Load indicator this->nb of global stats widget.
deleteLine($lineid)
Delete detail line.
const STATUS_VALIDATED
Validated status.
createPriceFournisseur($product, $user)
Create Price Fournisseur.
getLibStatut($mode=0)
Return label of status of proposal (draft, validated, ...)
add_product($idproduct, $qty, $remise_percent=0)
Add line into array ->lines.
set_date_livraison($user, $delivery_date)
Set delivery date.
const STATUS_SIGNED
Signed quote.
getNomUrl($withpicto=0, $option='', $get_params='', $notooltip=0, $save_lastsearch_value=-1, $addlinktonotes=0)
Return clickable link of object (with eventually picto)
getKanbanView($option='', $arraydata=null)
Return clickable link of object (with eventually picto)
getTooltipContentArray($params)
getTooltipContentArray
valid($user, $notrigger=0)
Set status to validated.
const STATUS_CLOSE
Billed or closed/processed quote.
getLinesArray()
Retrieve an array of supplier proposal lines.
setDraft($user)
Set draft status.
Class to manage supplier_proposal lines.
fetch($rowid)
Retrieve the propal line object.
insert($notrigger=0)
Insert object line propal in database.
update_total()
Update DB line fields total_xxx Used by migration.
update($notrigger=0)
Update propal line object into DB.
__construct($db)
Class line Constructor.
Class to manage translations.
Class to manage Dolibarr users.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
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.
$date_start
Variables from include:
dol_now($mode='gmt')
Return date for now.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $allowothertags=array())
Show a picto called object_picto (generic function)
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
get_default_npr(Societe $thirdparty_seller, Societe $thirdparty_buyer, $idprod=0, $idprodfournprice=0)
Function that returns whether VAT must be recoverable collected VAT (e.g.: VAT NPR in France)
getDolCurrency()
Return the main currency ('EUR', 'USD', ...)
dolGetStatus($statusLabel='', $statusLabelShort='', $html='', $statusType='status0', $displayMode=0, $url='', $params=array())
Output the badge of a status.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
getDolGlobalBool($key, $default=false)
Return a Dolibarr global constant boolean value.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
get_default_tva(Societe $thirdparty_seller, Societe $thirdparty_buyer, $idprod=0, $idprodfournprice=0)
Function that return vat rate of a product line (according to seller, buyer and product vat rate) VAT...
get_localtax($vatrate, $local, $thirdparty_buyer=null, $thirdparty_seller=null, $vatnpr=0)
Return localtax rate for a particular VAT rate, when selling a product with vat $vatrate,...
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
print $langs trans("Show") . '< td style="' . $timeColor . '" align="center"> s</td > badge status0 badge status4 badge status3 Error badge status8< td align="center">< span class="badge ' . $badge . '"></span ></td >< td align="center">< a href="#" class="button button-small" onclick="openLogModal(this)" data-req="' . dol_escape_htmltag($reqSafe) . '" data-res="' . dol_escape_htmltag($resSafe) . '" data-err="' . dol_escape_htmltag($errSafe) . '">< span class="fa fa-search-plus"></span ></a ></td ></tr >< tr >< td colspan="' . $colspan . '" class="opacitymedium"></td ></tr ></table ></div ></form > logModal none logModal none s a JSON string
buildzip.php
getMarginInfos($pv_ht, $remise_percent, $tva_tx, $localtax1_tx, $localtax2_tx, $fk_pa, $pa_ht)
Return an array with margins information of a line.
calcul_price_total($qty, $pu, $remise_percent_ligne, $txtva, $uselocaltax1_rate, $uselocaltax2_rate, $notused, $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.
print $langs trans('Date')." left Ref Label right Qty right Price right TotalHT right TotalTTC right right right right right right right right right centpercent right TotalHT right n right VAT right n right TotalVAT right n No sujeto a RE IRPF right TotalLT1 right n right TotalLT2 right n right TotalTTC right n takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency right TotalTTC takeposcustomercurrency right takeposcustomercurrency n right Paid right PaymentTypeShortLIQ right SELECT p pos_change as p datep as date