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;
200 public $deposit_percent;
206 public $extraparams = array();
211 public $lines = array();
218 public $labelStatus = array();
219 public $labelStatusShort = array();
234 public $fk_multicurrency;
239 public $multicurrency_code;
243 public $multicurrency_tx;
247 public $multicurrency_total_ht;
251 public $multicurrency_total_tva;
255 public $multicurrency_total_ttc;
257 public $fields = array(
258 'ref' => array(
'type' =>
'varchar(255)',
'label' =>
'Ref',
'enabled' => 1,
'visible' => 1,
'showoncombobox' => 1,
'position' => 25,
'searchall' => 1),
259 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 750,
'searchall' => 1),
296 public function __construct($db, $socid = 0, $supplier_proposalid = 0)
300 $this->ismultientitymanaged = 1;
301 $this->socid = $socid;
302 $this->
id = $supplier_proposalid;
317 public function add_product($idproduct, $qty, $remise_percent = 0)
326 dol_syslog(get_class($this).
"::add_product $idproduct, $qty, $remise_percent");
327 if ($idproduct > 0) {
328 $prod =
new Product($this->db);
329 $prod->fetch($idproduct);
331 $productdesc = $prod->description;
335 if (empty($tva_tx)) {
343 $price = $prod->multiprices[$this->thirdparty->price_level];
345 $price = $prod->price;
350 $line->fk_product = $idproduct;
351 $line->desc = $productdesc;
353 $line->subprice = $price;
354 $line->remise_percent = $remise_percent;
355 $line->tva_tx = $tva_tx;
357 $this->lines[] = $line;
375 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
376 include_once DOL_DOCUMENT_ROOT.
'/core/class/discount.class.php';
381 $result = $remise->fetch($idremise);
384 if ($remise->fk_facture) {
385 $this->error = $langs->trans(
"ErrorDiscountAlreadyUsed");
386 $this->db->rollback();
391 $supplier_proposalligne->fk_supplier_proposal = $this->id;
392 $supplier_proposalligne->fk_remise_except = $remise->id;
393 $supplier_proposalligne->desc = $remise->description;
394 $supplier_proposalligne->tva_tx = $remise->tva_tx;
395 $supplier_proposalligne->subprice = -(float) $remise->amount_ht;
396 $supplier_proposalligne->fk_product = 0;
397 $supplier_proposalligne->qty = 1;
398 $supplier_proposalligne->remise_percent = 0;
399 $supplier_proposalligne->rang = -1;
400 $supplier_proposalligne->info_bits = 2;
402 $supplier_proposalligne->total_ht = -(float) $remise->amount_ht;
403 $supplier_proposalligne->total_tva = -(float) $remise->amount_tva;
404 $supplier_proposalligne->total_ttc = -(float) $remise->amount_ttc;
406 $result = $supplier_proposalligne->insert();
413 $this->db->rollback();
418 $this->db->rollback();
422 $this->db->rollback();
464 public function addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 0, $fk_product = 0, $remise_percent = 0, $price_base_type =
'HT', $pu_ttc = 0, $info_bits = 0, $type = 0, $rang = -1, $special_code = 0, $fk_parent_line = 0, $fk_fournprice = 0, $pa_ht = 0, $label =
'', $array_options = [], $ref_supplier =
'', $fk_unit = 0, $origin =
'', $origin_id = 0, $pu_ht_devise = 0, $date_start = 0, $date_end = 0)
468 dol_syslog(get_class($this).
"::addline supplier_proposalid=$this->id, desc=$desc, pu_ht=$pu_ht, qty=$qty, txtva=$txtva, fk_product=$fk_product, remise_except=$remise_percent, price_base_type=$price_base_type, pu_ttc=$pu_ttc, info_bits=$info_bits, type=$type");
469 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
472 if (empty($remise_percent)) {
478 if (empty($info_bits)) {
484 if (empty($fk_parent_line) || $fk_parent_line < 0) {
491 $remise_percent =
price2num($remise_percent);
495 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
501 if ($price_base_type ==
'HT') {
512 if ($this->
status == self::STATUS_DRAFT) {
515 if ($fk_product > 0) {
516 if (
getDolGlobalInt(
'SUPPLIER_PROPOSAL_WITH_PREDEFINED_PRICES_ONLY') == 1) {
518 dol_syslog(get_class($this).
"::addline we check supplier prices fk_product=".$fk_product.
" fk_fournprice=".$fk_fournprice.
" qty=".$qty.
" ref_supplier=".$ref_supplier);
520 if ($productsupplier->fetch($fk_product) > 0) {
521 $product_type = $productsupplier->type;
522 $label = $productsupplier->label;
523 $fk_prod_fourn_price = $fk_fournprice;
528 $result = $productsupplier->get_buyprice($fk_prod_fourn_price, $qty, $fk_product,
'none', $this->socid);
530 $pu = $productsupplier->fourn_pu;
531 $ref_supplier = $productsupplier->ref_supplier;
533 if ($remise_percent == 0 && $productsupplier->remise_percent != 0) {
534 $remise_percent = $productsupplier->remise_percent;
538 $langs->load(
"errors");
539 $this->error =
"Ref ".$productsupplier->ref.
" ".$langs->trans(
"ErrorQtyTooLowForThisSupplier");
540 $this->db->rollback();
541 dol_syslog(get_class($this).
"::addline we did not found supplier price, so we can't guess unit price");
547 $langs->load(
"errors");
548 $this->error =
"Ref ".$productsupplier->ref.
" ".$langs->trans(
"ErrorQtyTooLowForThisSupplier");
549 $this->db->rollback();
550 dol_syslog(get_class($this).
"::addline result=".$result.
" - ".$this->error, LOG_DEBUG);
555 $this->db->rollback();
556 dol_syslog(get_class($this).
"::addline result=".$result.
" - ".$this->error, LOG_ERR);
561 $this->db->rollback();
566 $product_type = $type;
579 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
580 $vat_src_code = $reg[1];
581 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
584 if (
isModEnabled(
"multicurrency") && $pu_ht_devise > 0) {
591 (
float) $remise_percent,
593 (
float) $txlocaltax1,
594 (
float) $txlocaltax2,
602 (
float) $this->multicurrency_tx,
605 $total_ht = $tabprice[0];
606 $total_tva = $tabprice[1];
607 $total_ttc = $tabprice[2];
608 $total_localtax1 = $tabprice[9];
609 $total_localtax2 = $tabprice[10];
610 $pu = $pu_ht = $tabprice[3];
613 $multicurrency_total_ht = $tabprice[16];
614 $multicurrency_total_tva = $tabprice[17];
615 $multicurrency_total_ttc = $tabprice[18];
616 $pu_ht_devise = $tabprice[19];
620 if ($ranktouse == -1) {
621 $rangmax = $this->
line_max($fk_parent_line);
622 $ranktouse = $rangmax + 1;
628 $this->line->fk_supplier_proposal = $this->id;
629 $this->line->label = $label;
630 $this->line->desc = $desc;
631 $this->line->qty = $qty;
633 $this->line->vat_src_code = $vat_src_code;
634 $this->line->tva_tx = $txtva;
635 $this->line->localtax1_tx = ($total_localtax1 ? $localtaxes_type[1] : 0);
636 $this->line->localtax2_tx = ($total_localtax2 ? $localtaxes_type[3] : 0);
637 $this->line->localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
638 $this->line->localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
639 $this->line->fk_product = $fk_product;
640 $this->line->remise_percent = $remise_percent;
641 $this->line->subprice = (float) $pu_ht;
642 $this->line->rang = $ranktouse;
643 $this->line->info_bits = $info_bits;
644 $this->line->total_ht = (float) $total_ht;
645 $this->line->total_tva = (float) $total_tva;
646 $this->line->total_localtax1 = (float) $total_localtax1;
647 $this->line->total_localtax2 = (float) $total_localtax2;
648 $this->line->total_ttc = (float) $total_ttc;
649 $this->line->product_type = $type;
650 $this->line->special_code = $special_code;
651 $this->line->fk_parent_line = $fk_parent_line;
652 $this->line->fk_unit = $fk_unit;
653 $this->line->origin = $origin;
654 $this->line->origin_type = $origin;
655 $this->line->origin_id = $origin_id;
656 $this->line->ref_fourn = $this->db->escape($ref_supplier);
657 $this->line->date_start = $date_start;
658 $this->line->date_end = $date_end;
661 if (!empty($fk_product) && $fk_product > 0 && empty($fk_fournprice) && empty($pa_ht)) {
663 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
665 $productFournisseur->find_min_price_product_fournisseur($fk_product);
666 $this->line->fk_fournprice = $productFournisseur->product_fourn_price_id;
668 $this->line->fk_fournprice = ($fk_fournprice > 0 ? $fk_fournprice : 0);
670 $this->line->pa_ht = $pa_ht;
674 $this->line->fk_multicurrency = $this->fk_multicurrency;
675 $this->line->multicurrency_code = $this->multicurrency_code;
676 $this->line->multicurrency_subprice = (float) $pu_ht_devise;
677 $this->line->multicurrency_total_ht = (float) $multicurrency_total_ht;
678 $this->line->multicurrency_total_tva = (float) $multicurrency_total_tva;
679 $this->line->multicurrency_total_ttc = (float) $multicurrency_total_ttc;
682 if (empty($qty) && empty($special_code)) {
683 $this->line->special_code = 3;
686 if (is_array($array_options) && count($array_options) > 0) {
687 $this->line->array_options = $array_options;
690 $result = $this->line->insert();
693 if (!empty($fk_parent_line)) {
695 } elseif ($ranktouse > 0 && $ranktouse <= count($this->lines)) {
696 $linecount = count($this->lines);
697 for ($ii = $ranktouse; $ii <= $linecount; $ii++) {
703 $result = $this->
update_price(1,
'auto', 0, $this->thirdparty);
706 return $this->line->id;
708 $this->db->rollback();
713 $this->db->rollback();
717 $this->error =
'BadStatusOfObjectToAddLine';
749 public function updateline($rowid, $pu, $qty, $remise_percent, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 0, $desc =
'', $price_base_type =
'HT', $info_bits = 0, $special_code = 0, $fk_parent_line = 0, $skip_update_total = 0, $fk_fournprice = 0, $pa_ht = 0, $label =
'', $type = 0, $array_options = [], $ref_supplier =
'', $fk_unit = 0, $pu_ht_devise = 0)
754 $this->error =
'ErrorLineIDDoesNotMatchWithObjectID';
758 dol_syslog(get_class($this).
"::updateLine $rowid, $pu, $qty, $remise_percent, $txtva, $desc, $price_base_type, $info_bits");
759 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
762 $remise_percent =
price2num($remise_percent);
765 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
771 if (empty($qty) && empty($special_code)) {
774 if (!empty($qty) && $special_code == 3) {
791 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
792 $vat_src_code = $reg[1];
793 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
796 if (
isModEnabled(
"multicurrency") && $pu_ht_devise > 0) {
803 (
float) $remise_percent,
805 (
float) $txlocaltax1,
806 (
float) $txlocaltax2,
814 (
float) $this->multicurrency_tx,
817 $total_ht = $tabprice[0];
818 $total_tva = $tabprice[1];
819 $total_ttc = $tabprice[2];
820 $total_localtax1 = $tabprice[9];
821 $total_localtax2 = $tabprice[10];
822 $pu_ht = $tabprice[3];
823 $pu_tva = $tabprice[4];
824 $pu_ttc = $tabprice[5];
827 $multicurrency_total_ht = $tabprice[16];
828 $multicurrency_total_tva = $tabprice[17];
829 $multicurrency_total_ttc = $tabprice[18];
830 $pu_ht_devise = $tabprice[19];
833 if ($price_base_type ==
'TTC') {
839 $line->fetch($rowid);
840 $line->fetch_optionals();
842 $fk_product = $line->fk_product;
845 $staticline = clone $line;
847 $line->oldline = $staticline;
849 $this->line->context = $this->context;
852 if (!empty($fk_parent_line) && !empty($staticline->fk_parent_line) && $fk_parent_line != $staticline->fk_parent_line) {
853 $rangmax = $this->
line_max($fk_parent_line);
854 $this->line->rang = $rangmax + 1;
857 $this->line->id = $rowid;
858 $this->line->label = $label;
859 $this->line->desc = $desc;
860 $this->line->qty = $qty;
861 $this->line->product_type = $type;
863 $this->line->vat_src_code = $vat_src_code;
864 $this->line->tva_tx = $txtva;
865 $this->line->localtax1_tx = $txlocaltax1;
866 $this->line->localtax2_tx = $txlocaltax2;
867 $this->line->localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
868 $this->line->localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
869 $this->line->remise_percent = $remise_percent;
870 $this->line->subprice = (float) $pu;
871 $this->line->info_bits = $info_bits;
872 $this->line->total_ht = (float) $total_ht;
873 $this->line->total_tva = (float) $total_tva;
874 $this->line->total_localtax1 = (float) $total_localtax1;
875 $this->line->total_localtax2 = (float) $total_localtax2;
876 $this->line->total_ttc = (float) $total_ttc;
877 $this->line->special_code = $special_code;
878 $this->line->fk_parent_line = $fk_parent_line;
879 $this->line->skip_update_total = $skip_update_total;
880 $this->line->ref_fourn = $ref_supplier;
881 $this->line->fk_unit = $fk_unit;
884 if (!empty($fk_product) && $fk_product > 0 && empty($fk_fournprice) && empty($pa_ht)) {
886 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
888 $productFournisseur->find_min_price_product_fournisseur($fk_product);
889 $this->line->fk_fournprice = $productFournisseur->product_fourn_price_id;
891 $this->line->fk_fournprice = $fk_fournprice;
893 $this->line->pa_ht = $pa_ht;
895 if (is_array($array_options) && count($array_options) > 0) {
897 foreach ($array_options as $key => $value) {
898 $this->line->array_options[$key] = $array_options[$key];
903 $this->line->multicurrency_subprice = (float) $pu_ht_devise;
904 $this->line->multicurrency_total_ht = (float) $multicurrency_total_ht;
905 $this->line->multicurrency_total_tva = (float) $multicurrency_total_tva;
906 $this->line->multicurrency_total_ttc = (float) $multicurrency_total_ttc;
908 $result = $this->line->update();
911 if (!empty($fk_parent_line)) {
920 $this->error = $this->db->error();
921 $this->db->rollback();
925 dol_syslog(get_class($this).
"::updateline Erreur -2 SupplierProposal en mode incompatible pour cette action");
945 $line->fetch($lineid);
947 if ($this->
id > 0 && (
int) $line->fk_supplier_proposal !== (
int) $this->id) {
948 $this->error =
'ErrorLineIDDoesNotMatchWithObjectID';
952 if ($line->delete($user) > 0) {
973 public function create($user, $notrigger = 0)
975 global $langs, $conf,
$mysoc, $hookmanager;
985 $this->error =
"Failed to fetch company";
986 dol_syslog(get_class($this).
"::create ".$this->error, LOG_ERR);
989 if (!empty($this->
ref)) {
992 $this->error =
'ErrorRefAlreadyExists';
993 dol_syslog(get_class($this).
"::create ".$this->error, LOG_WARNING);
994 $this->db->rollback();
1000 $delivery_date = $this->delivery_date;
1003 if (!empty($this->multicurrency_code)) {
1006 if (empty($this->fk_multicurrency)) {
1008 $this->fk_multicurrency = 0;
1009 $this->multicurrency_tx = 1;
1015 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"supplier_proposal (";
1018 $sql .=
", total_tva";
1019 $sql .=
", total_ttc";
1022 $sql .=
", fk_user_author";
1023 $sql .=
", note_private";
1024 $sql .=
", note_public";
1025 $sql .=
", model_pdf";
1026 $sql .=
", fk_cond_reglement";
1027 $sql .=
", deposit_percent";
1028 $sql .=
", fk_mode_reglement";
1029 $sql .=
", fk_account";
1030 $sql .=
", date_livraison";
1031 $sql .=
", fk_shipping_method";
1032 $sql .=
", fk_projet";
1034 $sql .=
", fk_multicurrency";
1035 $sql .=
", multicurrency_code";
1036 $sql .=
", multicurrency_tx";
1038 $sql .=
" VALUES (";
1039 $sql .= ((int) $this->socid);
1043 $sql .=
", '".$this->db->idate($now).
"'";
1044 $sql .=
", '(PROV)'";
1045 $sql .=
", ".($user->id > 0 ? ((int) $user->id) :
"null");
1046 $sql .=
", '".$this->db->escape($this->note_private).
"'";
1047 $sql .=
", '".$this->db->escape($this->note_public).
"'";
1048 $sql .=
", '".$this->db->escape($this->model_pdf).
"'";
1049 $sql .=
", ".($this->cond_reglement_id > 0 ? ((int) $this->cond_reglement_id) :
'NULL');
1050 $sql .=
", ".(!empty($this->deposit_percent) ?
"'" . $this->db->escape($this->deposit_percent) .
"'" :
'NULL');
1051 $sql .=
", ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) :
'NULL');
1052 $sql .=
", ".($this->fk_account > 0 ? ((int) $this->fk_account) :
'NULL');
1053 $sql .=
", ".(isDolTms($delivery_date) ?
"'".$this->db->idate($delivery_date).
"'" :
"null");
1054 $sql .=
", ".($this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) :
'NULL');
1055 $sql .=
", ".($this->fk_project > 0 ? ((int) $this->fk_project) :
"null");
1056 $sql .=
", ".((int) $conf->entity);
1057 $sql .=
", ".((int) $this->fk_multicurrency);
1058 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
1059 $sql .=
", ".((float) $this->multicurrency_tx);
1062 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1063 $resql = $this->db->query($sql);
1065 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"supplier_proposal");
1068 $this->
ref =
'(PROV'.$this->id.
')';
1069 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"supplier_proposal SET ref='".$this->db->escape($this->
ref).
"' WHERE rowid=".((int) $this->
id);
1071 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1072 $resql = $this->db->query($sql);
1077 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
1078 $this->linked_objects = $this->linkedObjectsIds;
1082 if (!$error && $this->
id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
1083 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
1084 if (is_array($tmp_origin_id)) {
1085 foreach ($tmp_origin_id as $origin_id) {
1100 $fk_parent_line = 0;
1101 $num = count($this->lines);
1103 for ($i = 0; $i < $num; $i++) {
1105 if (($this->lines[$i]->product_type != 9 && empty($this->lines[$i]->fk_parent_line)) || $this->lines[$i]->product_type == 9) {
1106 $fk_parent_line = 0;
1110 $this->lines[$i]->desc,
1111 $this->lines[$i]->subprice,
1112 $this->lines[$i]->qty,
1113 $this->lines[$i]->tva_tx,
1114 $this->lines[$i]->localtax1_tx,
1115 $this->lines[$i]->localtax2_tx,
1116 $this->lines[$i]->fk_product,
1117 $this->lines[$i]->remise_percent,
1121 $this->lines[$i]->product_type,
1122 $this->lines[$i]->rang,
1123 $this->lines[$i]->special_code,
1125 $this->lines[$i]->fk_fournprice,
1126 $this->lines[$i]->pa_ht,
1127 empty($this->lines[$i]->label) ?
'' : $this->lines[$i]->label,
1128 $this->lines[$i]->array_options,
1129 $this->lines[$i]->ref_fourn,
1130 $this->lines[$i]->fk_unit,
1131 'supplier_proposal',
1132 $this->lines[$i]->rowid
1137 $this->error = $this->db->error;
1142 if ($result > 0 && $this->lines[$i]->product_type == 9) {
1143 $fk_parent_line = $result;
1162 if (!$error && !$notrigger) {
1164 $result = $this->call_trigger(
'PROPOSAL_SUPPLIER_CREATE', $user);
1171 $this->error = $this->db->lasterror();
1176 $this->error = $this->db->lasterror();
1181 $this->db->commit();
1182 dol_syslog(get_class($this).
"::create done id=".$this->
id);
1185 $this->db->rollback();
1189 $this->error = $this->db->lasterror();
1190 $this->db->rollback();
1204 global $conf, $hookmanager;
1212 foreach ($this->lines as $line) {
1213 $line->fetch_optionals();
1217 $objFrom = clone $this;
1219 $objsoc =
new Societe($this->db);
1222 if (!empty($fromid) && $fromid != $this->socid) {
1223 if ($objsoc->fetch($fromid) > 0) {
1224 $this->socid = $objsoc->id;
1225 $this->cond_reglement_id = (!empty($objsoc->cond_reglement_id) ? $objsoc->cond_reglement_id : 0);
1226 $this->deposit_percent = (!empty($objsoc->deposit_percent) ? $objsoc->deposit_percent : 0);
1227 $this->mode_reglement_id = (!empty($objsoc->mode_reglement_id) ? $objsoc->mode_reglement_id : 0);
1228 unset($this->fk_project);
1233 $objsoc->fetch($this->socid);
1240 if (!
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON') || !is_readable(DOL_DOCUMENT_ROOT.
"/core/modules/supplier_proposal/" .
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON').
".php")) {
1241 $this->error =
'ErrorSetupNotComplete';
1246 $this->user_author_id = $user->id;
1247 $this->user_validation_id = 0;
1251 require_once DOL_DOCUMENT_ROOT.
"/core/modules/supplier_proposal/" .
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON').
'.php';
1253 $modSupplierProposal =
new $obj();
1254 '@phan-var-force ModeleNumRefSupplierProposal $modSupplierProposal';
1255 $this->
ref = $modSupplierProposal->getNextValue($objsoc, $this);
1258 $this->context[
'createfromclone'] =
'createfromclone';
1259 $result = $this->
create($user);
1266 if (is_object($hookmanager)) {
1267 $parameters = array(
'objFrom' => $objFrom);
1269 $reshook = $hookmanager->executeHooks(
'createFrom', $parameters, $this, $action);
1277 unset($this->context[
'createfromclone']);
1281 $this->db->commit();
1284 $this->db->rollback();
1296 public function fetch($rowid, $ref =
'')
1298 $sql =
"SELECT p.rowid, p.entity, p.ref, p.fk_soc as socid";
1299 $sql .=
", p.total_ttc, p.total_tva, p.localtax1, p.localtax2, p.total_ht";
1300 $sql .=
", p.datec, GREATEST(p.tms, COALESCE(pef.tms, p.tms)) as date_modification";
1301 $sql .=
", p.date_valid as datev";
1302 $sql .=
", p.date_livraison as delivery_date";
1303 $sql .=
", p.model_pdf, p.extraparams";
1304 $sql .=
", p.note_private, p.note_public";
1305 $sql .=
", p.fk_projet as fk_project, p.fk_statut as status";
1306 $sql .=
", p.fk_user_author, p.fk_user_modif, p.fk_user_valid, p.fk_user_cloture";
1307 $sql .=
", p.fk_cond_reglement";
1308 $sql .=
", p.fk_mode_reglement";
1309 $sql .=
', p.fk_account';
1310 $sql .=
", p.fk_shipping_method";
1311 $sql .=
", p.last_main_doc";
1312 $sql .=
", p.fk_multicurrency, p.multicurrency_code, p.multicurrency_tx, p.multicurrency_total_ht, p.multicurrency_total_tva, p.multicurrency_total_ttc";
1313 $sql .=
", c.label as statut_label";
1314 $sql .=
", cr.code as cond_reglement_code, cr.libelle as cond_reglement, cr.libelle_facture as cond_reglement_libelle_doc, p.deposit_percent";
1315 $sql .=
", cp.code as mode_reglement_code, cp.libelle as mode_reglement";
1316 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_propalst as c, ".MAIN_DB_PREFIX.
"supplier_proposal as p";
1317 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"supplier_proposal_extrafields as pef ON pef.fk_object=p.rowid";
1318 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_paiement as cp ON p.fk_mode_reglement = cp.id';
1319 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_payment_term as cr ON p.fk_cond_reglement = cr.rowid';
1320 $sql .=
" WHERE p.fk_statut = c.id";
1321 $sql .=
" AND p.entity IN (".getEntity(
'supplier_proposal').
")";
1323 $sql .=
" AND p.ref = '".$this->db->escape($ref).
"'";
1325 $sql .=
" AND p.rowid = ".((int) $rowid);
1328 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
1329 $resql = $this->db->query($sql);
1331 if ($this->db->num_rows($resql)) {
1332 $obj = $this->db->fetch_object($resql);
1334 $this->
id = $obj->rowid;
1335 $this->entity = $obj->entity;
1337 $this->
ref = $obj->ref;
1338 $this->total_ht = $obj->total_ht;
1339 $this->total_tva = $obj->total_tva;
1340 $this->total_localtax1 = $obj->localtax1;
1341 $this->total_localtax2 = $obj->localtax2;
1342 $this->total_ttc = $obj->total_ttc;
1343 $this->socid = $obj->socid;
1344 $this->fk_project = $obj->fk_project;
1345 $this->model_pdf = $obj->model_pdf;
1346 $this->note = $obj->note_private;
1347 $this->note_private = $obj->note_private;
1348 $this->note_public = $obj->note_public;
1349 $this->statut = (int) $obj->status;
1350 $this->
status = (int) $obj->status;
1351 $this->datec = $this->db->jdate($obj->datec);
1352 $this->datev = $this->db->jdate($obj->datev);
1353 $this->date_creation = $this->db->jdate($obj->datec);
1354 $this->date_modification = $this->db->jdate($obj->date_modification);
1355 $this->
date = $this->date_creation;
1356 $this->date_validation = $this->db->jdate($obj->datev);
1357 $this->delivery_date = $this->db->jdate($obj->delivery_date);
1358 $this->shipping_method_id = ($obj->fk_shipping_method > 0) ? $obj->fk_shipping_method :
null;
1360 $this->last_main_doc = $obj->last_main_doc;
1361 $this->mode_reglement_id = $obj->fk_mode_reglement;
1362 $this->mode_reglement_code = $obj->mode_reglement_code;
1363 $this->mode_reglement = $obj->mode_reglement;
1364 $this->deposit_percent = $obj->deposit_percent;
1365 $this->fk_account = ($obj->fk_account > 0) ? $obj->fk_account :
null;
1366 $this->cond_reglement_id = $obj->fk_cond_reglement;
1367 $this->cond_reglement_code = $obj->cond_reglement_code;
1368 $this->cond_reglement = $obj->cond_reglement;
1369 $this->cond_reglement_label = $obj->cond_reglement;
1370 $this->cond_reglement_doc = $obj->cond_reglement_libelle_doc;
1372 $this->extraparams = (array) (!empty($obj->extraparams) ? json_decode($obj->extraparams,
true) : array());
1374 $this->user_author_id = $obj->fk_user_author;
1375 $this->user_modification_id = $obj->fk_user_modif;
1376 $this->user_validation_id = $obj->fk_user_valid;
1377 $this->user_closing_id = $obj->fk_user_cloture;
1380 $this->fk_multicurrency = $obj->fk_multicurrency;
1381 $this->multicurrency_code = $obj->multicurrency_code;
1382 $this->multicurrency_tx = $obj->multicurrency_tx;
1383 $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
1384 $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
1385 $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
1387 $this->db->free($resql);
1393 $this->lines = array();
1396 $sql =
"SELECT d.rowid, d.fk_supplier_proposal, d.fk_parent_line, d.label as custom_label, d.description, d.price, d.tva_tx, d.localtax1_tx, d.localtax2_tx, d.qty, d.fk_remise_except, d.remise_percent, d.subprice, d.fk_product,";
1397 $sql .=
" d.info_bits, d.total_ht, d.total_tva, d.total_localtax1, d.total_localtax2, d.total_ttc, d.fk_product_fournisseur_price as fk_fournprice, d.buy_price_ht as pa_ht, d.special_code, d.rang, d.product_type,";
1398 $sql .=
' p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label,';
1399 $sql .=
' d.ref_fourn as ref_produit_fourn, d.extraparams,';
1400 $sql .=
' d.fk_multicurrency, d.multicurrency_code, d.multicurrency_subprice, d.multicurrency_total_ht, d.multicurrency_total_tva, d.multicurrency_total_ttc, d.fk_unit';
1401 $sql .=
" FROM ".MAIN_DB_PREFIX.
"supplier_proposaldet as d";
1402 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"product as p ON d.fk_product = p.rowid";
1403 $sql .=
" WHERE d.fk_supplier_proposal = ".((int) $this->
id);
1404 $sql .=
" ORDER by d.rang";
1406 $result = $this->db->query($sql);
1408 $num = $this->db->num_rows($result);
1412 $objp = $this->db->fetch_object($result);
1416 $line->rowid = $objp->rowid;
1417 $line->id = $objp->rowid;
1418 $line->fk_supplier_proposal = $objp->fk_supplier_proposal;
1419 $line->fk_parent_line = $objp->fk_parent_line;
1420 $line->product_type = $objp->product_type;
1421 $line->label = $objp->custom_label;
1422 $line->desc = $objp->description;
1423 $line->qty = $objp->qty;
1424 $line->tva_tx = $objp->tva_tx;
1425 $line->localtax1_tx = $objp->localtax1_tx;
1426 $line->localtax2_tx = $objp->localtax2_tx;
1427 $line->subprice = $objp->subprice;
1428 $line->fk_remise_except = $objp->fk_remise_except;
1429 $line->remise_percent = $objp->remise_percent;
1431 $line->info_bits = $objp->info_bits;
1432 $line->total_ht = $objp->total_ht;
1433 $line->total_tva = $objp->total_tva;
1434 $line->total_localtax1 = $objp->total_localtax1;
1435 $line->total_localtax2 = $objp->total_localtax2;
1436 $line->total_ttc = $objp->total_ttc;
1437 $line->fk_fournprice = $objp->fk_fournprice;
1438 $marginInfos =
getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $line->fk_fournprice, $objp->pa_ht);
1439 $line->pa_ht = $marginInfos[0];
1440 $line->marge_tx = $marginInfos[1];
1441 $line->marque_tx = $marginInfos[2];
1442 $line->special_code = $objp->special_code;
1443 $line->rang = $objp->rang;
1445 $line->fk_product = $objp->fk_product;
1447 $line->ref = $objp->product_ref;
1448 $line->product_ref = $objp->product_ref;
1449 $line->libelle = $objp->product_label;
1450 $line->product_label = $objp->product_label;
1451 $line->product_desc = $objp->product_desc;
1452 $line->fk_product_type = $objp->fk_product_type;
1454 $line->ref_fourn = $objp->ref_produit_fourn;
1456 $line->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams,
true) : array();
1459 $line->fk_multicurrency = $objp->fk_multicurrency;
1460 $line->multicurrency_code = $objp->multicurrency_code;
1461 $line->multicurrency_subprice = $objp->multicurrency_subprice;
1462 $line->multicurrency_total_ht = $objp->multicurrency_total_ht;
1463 $line->multicurrency_total_tva = $objp->multicurrency_total_tva;
1464 $line->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
1465 $line->fk_unit = $objp->fk_unit;
1467 $line->fetch_optionals();
1469 $this->lines[$i] = $line;
1473 $this->db->free($result);
1475 $this->error = $this->db->error();
1482 $this->error =
"Record Not Found";
1485 $this->error = $this->db->error();
1497 public function update($user, $notrigger = 0)
1501 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal SET";
1502 $sql .=
" fk_projet = ".($this->fk_project > 0 ? ((int) $this->fk_project) :
"null");
1503 $sql .=
", fk_cond_reglement = ".($this->cond_reglement_id > 0 ? ((int) $this->cond_reglement_id) :
"null");
1504 $sql .=
", fk_mode_reglement = ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) :
"null");
1505 $sql .=
", fk_account = ".($this->fk_account > 0 ? ((int) $this->fk_account) :
"null");
1506 $sql .=
", fk_shipping_method = ".($this->shipping_method_id > 0 ? ((int) $this->shipping_method_id) :
"null");
1507 $sql .=
", date_livraison = ".($this->delivery_date ?
"'".$this->db->idate($this->delivery_date).
"'" :
"null");
1508 $sql .=
", note_private = ".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null");
1509 $sql .=
", note_public = ".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null");
1510 $sql .=
", model_pdf = ".(isset($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
"null");
1511 $sql .=
", fk_user_modif = ".((int) $user->id);
1512 $sql .=
" WHERE rowid = ".((int) $this->
id);
1516 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
1517 $resql = $this->db->query($sql);
1520 $this->errors[] =
"Error ".$this->db->lasterror();
1530 if (!$error && !$notrigger) {
1532 $result = $this->call_trigger(
'PROPOSAL_SUPPLIER_MODIFY', $user);
1540 $this->error = implode(
', ', $this->errors);
1541 $this->db->rollback();
1545 $this->db->commit();
1556 public function valid($user, $notrigger = 0)
1558 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1560 global $conf, $langs;
1565 if ((!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'supplier_proposal',
'creer'))
1566 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'supplier_proposal',
'validate_advance'))) {
1570 $soc =
new Societe($this->db);
1571 $result = $soc->fetch($this->socid);
1577 dol_syslog(get_class($this).
"::valid checkActiveProductInLines ".$this->error, LOG_INFO);
1581 if (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref)) {
1582 $num = $this->getNextNumRef($soc);
1584 $num = (string) $this->
ref;
1588 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal";
1589 $sql .=
" SET ref = '".$this->db->escape($num).
"',";
1590 $sql .=
" fk_statut = 1, date_valid='".$this->db->idate($now).
"', fk_user_valid=".((int) $user->id);
1591 $sql .=
" WHERE rowid = ".((int) $this->
id).
" AND fk_statut = 0";
1593 dol_syslog(get_class($this).
"::valid", LOG_DEBUG);
1594 $resql = $this->db->query($sql);
1601 if (!$error && !$notrigger) {
1603 $result = $this->call_trigger(
'PROPOSAL_SUPPLIER_VALIDATE', $user);
1611 $this->oldref = $this->ref;
1614 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
1616 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filename = CONCAT('".$this->db->escape($this->newref).
"', SUBSTR(filename, ".(strlen($this->
ref) + 1).
")), filepath = 'supplier_proposal/".$this->db->escape($this->newref).
"'";
1617 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'supplier_proposal/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
1618 $resql = $this->db->query($sql);
1621 $this->error = $this->db->lasterror();
1623 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'supplier_proposal/".$this->db->escape($this->newref).
"'";
1624 $sql .=
" WHERE filepath = 'supplier_proposal/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
1625 $resql = $this->db->query($sql);
1628 $this->error = $this->db->lasterror();
1634 $dirsource = $conf->supplier_proposal->dir_output.
'/'.$oldref;
1635 $dirdest = $conf->supplier_proposal->dir_output.
'/'.$newref;
1636 if (!$error && file_exists($dirsource)) {
1637 dol_syslog(get_class($this).
"::valid rename dir ".$dirsource.
" into ".$dirdest);
1638 if (@rename($dirsource, $dirdest)) {
1641 $listoffiles =
dol_dir_list($conf->supplier_proposal->dir_output.
'/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
1642 foreach ($listoffiles as $fileentry) {
1643 $dirsource = $fileentry[
'name'];
1644 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
1645 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
1646 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
1647 @rename($dirsource, $dirdest);
1656 $this->user_validation_id = $user->id;
1657 $this->datev = $now;
1658 $this->date_validation = $now;
1661 $result = $this->
add_contact($user->id,
'SALESREPFOLL',
'internal', 1);
1662 if ($result < 0 && $result != -2) {
1667 $this->db->commit();
1670 $this->db->rollback();
1674 dol_syslog(
"You don't have permission to validate supplier proposal", LOG_WARNING);
1703 if ($user->hasRight(
'supplier_proposal',
'creer')) {
1704 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal ";
1705 $sql .=
" SET date_livraison = ".(isDolTms($delivery_date) ?
"'".$this->db->idate($delivery_date).
"'" :
'null');
1706 $sql .=
" WHERE rowid = ".((int) $this->
id);
1708 if ($this->db->query($sql)) {
1709 $this->delivery_date = $delivery_date;
1712 $this->error = $this->db->error();
1713 dol_syslog(get_class($this).
"::setDeliveryDate Erreur SQL");
1799 public function reopen($user, $status, $note =
'', $notrigger = 0)
1801 global $langs, $conf;
1805 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal";
1806 $sql .=
" SET fk_statut = ".((int) $status).
",";
1807 if (!empty($note)) {
1808 $sql .=
" note_private = '".$this->db->escape($note).
"',";
1810 $sql .=
" date_cloture = NULL, fk_user_cloture = NULL";
1811 $sql .=
" WHERE rowid = ".((int) $this->
id);
1815 dol_syslog(get_class($this).
"::reopen", LOG_DEBUG);
1816 $resql = $this->db->query($sql);
1819 $this->errors[] =
"Error ".$this->db->lasterror();
1824 $result = $this->call_trigger(
'PROPOSAL_SUPPLIER_REOPEN', $user);
1834 if (!empty($this->errors)) {
1835 foreach ($this->errors as $errmsg) {
1836 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
1837 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1840 $this->db->rollback();
1843 $this->statut = $status;
1846 $this->db->commit();
1862 global $langs, $conf;
1872 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal";
1873 $sql .=
" SET fk_statut = ".((int) $status).
", note_private = '".$this->db->escape($note).
"', date_cloture='".$this->db->idate($now).
"', fk_user_cloture=".((int) $user->id);
1874 $sql .=
" WHERE rowid = ".((int) $this->
id);
1876 $resql = $this->db->query($sql);
1878 $this->statut = $status;
1881 $modelpdf =
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON_PDF_ODT_CLOSED', (empty($this->model_pdf) ?
'' : $this->model_pdf));
1882 $triggerName =
'PROPOSAL_SUPPLIER_CLOSE_REFUSED';
1885 $triggerName =
'PROPOSAL_SUPPLIER_CLOSE_SIGNED';
1886 $modelpdf =
getDolGlobalString(
'SUPPLIER_PROPOSAL_ADDON_PDF_ODT_TOBILL', (empty($this->model_pdf) ?
'' : $this->model_pdf));
1893 $triggerName =
'PROPOSAL_SUPPLIER_CLASSIFY_BILLED';
1898 $outputlangs = $langs;
1900 $outputlangs =
new Translate(
"", $conf);
1901 $newlang = (
GETPOST(
'lang_id',
'aZ09') ?
GETPOST(
'lang_id',
'aZ09') : $this->thirdparty->default_lang);
1902 $outputlangs->setDefaultLang($newlang);
1905 $this->
generateDocument($modelpdf, $outputlangs, $hidedetails, $hidedesc, $hideref);
1909 $result = $this->call_trigger($triggerName, $user);
1916 $this->db->commit();
1919 $this->db->rollback();
1923 $this->error = $this->db->lasterror();
1924 $this->errors[] = $this->db->lasterror();
1925 $this->db->rollback();
1940 dol_syslog(get_class($this).
"::updateOrCreatePriceFournisseur", LOG_DEBUG);
1941 foreach ($this->lines as $product) {
1942 if ($product->subprice <= 0) {
1947 $multicurrency_tx = 1;
1948 $fk_multicurrency = 0;
1950 if (empty($this->thirdparty)) {
1954 $ref_fourn = $product->ref_fourn;
1955 if (empty($ref_fourn)) {
1956 $ref_fourn = $product->ref_supplier;
1958 if (
isModEnabled(
"multicurrency") && !empty($product->multicurrency_code)) {
1961 $productsupplier->id = $product->fk_product;
1963 $productsupplier->update_buyprice($product->qty, $product->total_ht, $user,
'HT', $this->thirdparty, 0, $ref_fourn, $product->tva_tx, 0, 0, 0, $product->info_bits, 0,
'', array(),
'', $product->multicurrency_total_ht,
'HT', $multicurrency_tx, $product->multicurrency_code,
'',
'', 0);
1979 $price =
price2num($product->subprice * $product->qty,
'MU');
1980 $unitPrice =
price2num($product->subprice,
'MU');
1982 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'product_fournisseur_price SET '.(!empty($product->ref_fourn) ?
'ref_fourn = "'.$this->db->escape($product->ref_fourn).
'", ' :
'').
' price ='.((
float) $price).
', unitprice ='.((
float) $unitPrice).
' WHERE rowid = '.((
int) $idProductFournPrice);
1984 $resql = $this->db->query($sql);
1986 $this->error = $this->db->error();
1987 $this->db->rollback();
2004 $price =
price2num($product->subprice * $product->qty,
'MU');
2006 $unitPrice =
price2num($product->subprice,
'MU');
2011 "'".$this->db->idate($now).
"'",
2012 (
int) $product->fk_product,
2013 (
int) $this->thirdparty->id,
2014 "'".$this->db->escape($product->ref_fourn).
"'",
2018 (
float) $product->tva_tx,
2022 if (!empty($product->multicurrency_code)) {
2023 include_once DOL_DOCUMENT_ROOT.
'/multicurrency/class/multicurrency.class.php';
2025 $multicurrency->fetch(0, $product->multicurrency_code);
2026 if (!empty($multicurrency->id)) {
2027 $values[] = (int) $multicurrency->id;
2028 $values[] =
"'".$this->db->escape($product->multicurrency_code).
"'";
2029 $values[] = (float) $product->multicurrency_subprice;
2030 $values[] = (float) $product->multicurrency_total_ht;
2031 $values[] = (float) $multicurrency->rate->rate;
2033 for ($i = 0; $i < 5; $i++) {
2040 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.
'product_fournisseur_price ';
2041 $sql .=
'(datec, fk_product, fk_soc, ref_fourn, price, quantity, unitprice, tva_tx, fk_user';
2042 if (
isModEnabled(
"multicurrency") && !empty($product->multicurrency_code)) {
2043 $sql .=
',fk_multicurrency, multicurrency_code, multicurrency_unitprice, multicurrency_price, multicurrency_tx';
2045 $sql .=
') VALUES ('.implode(
',', $values).
')';
2047 $resql = $this->db->query($sql);
2049 $this->error = $this->db->error();
2050 $this->db->rollback();
2066 global $conf, $langs;
2070 if ($this->
status == self::STATUS_DRAFT) {
2071 dol_syslog(get_class($this).
"::setDraft already draft status", LOG_WARNING);
2075 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposal";
2076 $sql .=
" SET fk_statut = ".self::STATUS_DRAFT;
2077 $sql .=
" WHERE rowid = ".((int) $this->
id);
2079 if ($this->db->query($sql)) {
2081 $this->oldcopy = clone $this;
2086 $result = $this->call_trigger(
'PROPOSAL_SUPPLIER_UNVALIDATE', $user);
2095 $this->db->commit();
2098 $this->db->rollback();
2121 public function liste_array($shortlist = 0, $draft = 0, $notcurrentuser = 0, $socid = 0, $limit = 0, $offset = 0, $sortfield =
'p.datec', $sortorder =
'DESC')
2129 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2130 $search_sale = $user->id;
2133 $sql =
"SELECT s.rowid, s.nom as name, s.client,";
2134 $sql .=
" p.rowid as supplier_proposalid, p.fk_statut, p.total_ht, p.ref, p.remise, ";
2135 $sql .=
" p.datep as dp, p.fin_validite as datelimite";
2136 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s, ".MAIN_DB_PREFIX.
"supplier_proposal as p, ".MAIN_DB_PREFIX.
"c_propalst as c";
2137 $sql .=
" WHERE p.entity IN (".getEntity(
'supplier_proposal').
")";
2138 $sql .=
" AND p.fk_soc = s.rowid";
2139 $sql .=
" AND p.fk_statut = c.id";
2141 $sql .=
" AND s.rowid = ".((int) $socid);
2144 $sql .=
" AND p.fk_statut = 0";
2146 if ($notcurrentuser > 0) {
2147 $sql .=
" AND p.fk_user_author <> ".((int) $user->id);
2150 if ($search_sale && $search_sale !=
'-1') {
2151 if ($search_sale == -2) {
2152 $sql .=
" AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = p.fk_soc)";
2153 } elseif ($search_sale > 0) {
2154 $sql .=
" AND EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = p.fk_soc AND sc.fk_user = ".((int) $search_sale).
")";
2157 $sql .= $this->db->order($sortfield, $sortorder);
2158 $sql .= $this->db->plimit($limit, $offset);
2160 $result = $this->db->query($sql);
2162 $num = $this->db->num_rows($result);
2166 $obj = $this->db->fetch_object($result);
2168 if ($shortlist == 1) {
2169 $ga[$obj->supplier_proposalid] = $obj->ref;
2170 } elseif ($shortlist == 2) {
2171 $ga[$obj->supplier_proposalid] = $obj->ref.
' ('.$obj->name.
')';
2173 $ga[$i][
'id'] = $obj->supplier_proposalid;
2174 $ga[$i][
'ref'] = $obj->ref;
2175 $ga[$i][
'name'] = $obj->name;
2195 public function delete($user, $notrigger = 0)
2197 global $conf, $langs;
2198 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
2206 $result = $this->call_trigger(
'PROPOSAL_SUPPLIER_DELETE', $user);
2215 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"categorie_supplier_proposal";
2216 $sql .=
" WHERE fk_supplier_proposal = ".((int) $this->
id);
2218 $result = $this->db->query($sql);
2221 $this->error = $this->db->lasterror();
2222 $this->errors[] = $this->error;
2227 $main = MAIN_DB_PREFIX.
'supplier_proposaldet';
2228 $ef = $main.
"_extrafields";
2229 $sqlef =
"DELETE FROM $ef WHERE fk_object IN (SELECT rowid FROM $main WHERE fk_supplier_proposal = ".((int) $this->
id).
")";
2230 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"supplier_proposaldet WHERE fk_supplier_proposal = ".((int) $this->
id);
2231 if ($this->db->query($sql)) {
2232 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"supplier_proposal WHERE rowid = ".((int) $this->
id);
2233 if ($this->db->query($sqlef) && $this->db->query($sql)) {
2247 if ($conf->supplier_proposal->dir_output && !empty($this->
ref)) {
2248 $dir = $conf->supplier_proposal->dir_output.
"/".$ref;
2249 $file = $dir.
"/".$ref.
".pdf";
2250 if (file_exists($file)) {
2254 $this->error =
'ErrorFailToDeleteFile';
2255 $this->errors = array(
'ErrorFailToDeleteFile');
2256 $this->db->rollback();
2260 if (file_exists($dir)) {
2263 $this->error =
'ErrorFailToDeleteDir';
2264 $this->errors = array(
'ErrorFailToDeleteDir');
2265 $this->db->rollback();
2278 dol_syslog(get_class($this).
"::delete erreur ".$errorflag.
" ".$this->error, LOG_ERR);
2283 dol_syslog(get_class($this).
"::delete ".$this->
id.
" by ".$user->id, LOG_DEBUG);
2284 $this->db->commit();
2287 $this->error = $this->db->lasterror();
2288 $this->db->rollback();
2292 $this->error = $this->db->lasterror();
2293 $this->db->rollback();
2297 $this->error = $this->db->lasterror();
2298 $this->db->rollback();
2302 $this->db->rollback();
2315 $sql =
"SELECT c.rowid, GREATEST(c.tms, COALESCE(cef.tms, c.tms)) as date_modification,";
2316 $sql .=
" c.datec as date_creation, c.date_valid as date_validation, c.date_cloture as date_closure,";
2317 $sql .=
" c.fk_user_author, c.fk_user_modif, c.fk_user_valid, c.fk_user_cloture";
2318 $sql .=
" FROM ".MAIN_DB_PREFIX.
"supplier_proposal as c";
2319 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"supplier_proposal_extrafields as cef ON cef.fk_object=c.rowid";
2320 $sql .=
" WHERE c.rowid = ".((int) $id);
2322 $result = $this->db->query($sql);
2325 if ($this->db->num_rows($result)) {
2326 $obj = $this->db->fetch_object($result);
2328 $this->
id = $obj->rowid;
2330 $this->date_creation = $this->db->jdate($obj->date_creation);
2331 $this->date_modification = empty($obj->date_modification) ?
'' : $this->db->jdate($obj->date_modification);
2332 $this->date_validation = $this->db->jdate($obj->date_validation);
2333 $this->date_cloture = $this->db->jdate($obj->date_closure);
2335 $this->user_creation_id = $obj->fk_user_author;
2336 $this->user_modification_id = $obj->fk_user_modif;
2337 $this->user_validation_id = $obj->fk_user_valid;
2338 $this->user_closing_id = $obj->fk_user_cloture;
2340 $this->db->free($result);
2371 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
2373 $langs->load(
"supplier_proposal");
2374 $this->labelStatus[
self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusDraft");
2375 $this->labelStatus[
self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusValidated");
2376 $this->labelStatus[
self::STATUS_SIGNED] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusSigned");
2377 $this->labelStatus[
self::STATUS_NOTSIGNED] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusNotSigned");
2378 $this->labelStatus[
self::STATUS_CLOSE] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusClosed");
2379 $this->labelStatusShort[
self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusDraftShort");
2380 $this->labelStatusShort[
self::STATUS_VALIDATED] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusValidatedShort");
2381 $this->labelStatusShort[
self::STATUS_SIGNED] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusSignedShort");
2382 $this->labelStatusShort[
self::STATUS_NOTSIGNED] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusNotSignedShort");
2383 $this->labelStatusShort[
self::STATUS_CLOSE] = $langs->transnoentitiesnoconv(
"SupplierProposalStatusClosedShort");
2387 if ($status == self::STATUS_DRAFT) {
2388 $statusnew =
'status0';
2389 } elseif ($status == self::STATUS_VALIDATED) {
2390 $statusnew =
'status1';
2391 } elseif ($status == self::STATUS_SIGNED) {
2392 $statusnew =
'status4';
2393 } elseif ($status == self::STATUS_NOTSIGNED) {
2394 $statusnew =
'status9';
2395 } elseif ($status == self::STATUS_CLOSE) {
2396 $statusnew =
'status6';
2399 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusnew, $mode);
2414 global $conf, $langs;
2420 $sql =
"SELECT p.rowid, p.ref, p.datec as datec, p.date_cloture as datefin";
2421 $sql .=
" FROM ".MAIN_DB_PREFIX.
"supplier_proposal as p";
2422 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2423 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON p.fk_soc = sc.fk_soc";
2424 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
2427 $sql .= $clause.
" p.entity IN (".
getEntity(
'supplier_proposal').
")";
2428 if ($mode ==
'opened') {
2429 $sql .=
" AND p.fk_statut = 1";
2431 if ($mode ==
'signed') {
2432 $sql .=
" AND p.fk_statut = 2";
2435 $sql .=
" AND p.fk_soc = ".((int) $user->socid);
2438 $resql = $this->db->query($sql);
2440 $label = $labelShort =
'';
2443 if ($mode ==
'opened') {
2444 $delay_warning = !empty($conf->supplier_proposal->cloture->warning_delay) ? $conf->supplier_proposal->cloture->warning_delay : 0;
2446 $label = $langs->trans(
"SupplierProposalsToClose");
2447 $labelShort = $langs->trans(
"ToAcceptRefuse");
2449 if ($mode ==
'signed') {
2450 $delay_warning = !empty($conf->supplier_proposal->facturation->warning_delay) ? $conf->supplier_proposal->facturation->warning_delay : 0;
2452 $label = $langs->trans(
"SupplierProposalsToProcess");
2453 $labelShort = $langs->trans(
"ToClose");
2457 $response->warning_delay = $delay_warning / 60 / 60 / 24;
2458 $response->label = $label;
2459 $response->labelShort = $labelShort;
2460 $response->url = DOL_URL_ROOT.
'/supplier_proposal/list.php?search_status='.$status;
2464 while ($obj = $this->db->fetch_object($resql)) {
2465 $response->nbtodo++;
2466 if ($mode ==
'opened') {
2467 $datelimit = $this->db->jdate($obj->datefin);
2468 if ($datelimit < ($now - $delay_warning)) {
2469 $response->nbtodolate++;
2477 $this->error = $this->db->lasterror();
2493 global $conf, $langs;
2498 $sql =
"SELECT rowid";
2499 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product";
2500 $sql .=
" WHERE entity IN (".getEntity(
'product').
")";
2501 if (array_key_exists(
'tobuy', $param)) {
2502 $sql .=
" AND tobuy = ".((int) $param[
'tobuy']);
2504 $sql .= $this->db->plimit(100);
2506 $resql = $this->db->query($sql);
2508 $num_prods = $this->db->num_rows($resql);
2510 while ($i < $num_prods) {
2512 $row = $this->db->fetch_row($resql);
2513 $prodids[$i] = $row[0];
2519 $this->
ref =
'SPECIMEN';
2520 $this->ref_supplier =
'NEMICEPS';
2521 $this->specimen = 1;
2523 $this->
date = time();
2524 $this->cond_reglement_id = 1;
2525 $this->cond_reglement_code =
'RECEP';
2526 $this->mode_reglement_id = 7;
2527 $this->mode_reglement_code =
'CHQ';
2528 $this->note_public =
'This is a comment (public)';
2529 $this->note_private =
'This is a comment (private)';
2531 $this->multicurrency_tx = 1;
2537 while ($xnbp < $nbp) {
2539 $line->desc = $langs->trans(
"Description").
" ".$xnbp;
2541 $line->subprice = 100;
2542 $line->tva_tx = 19.6;
2543 $line->localtax1_tx = 0;
2544 $line->localtax2_tx = 0;
2546 $line->total_ht = 50;
2547 $line->total_ttc = 59.8;
2548 $line->total_tva = 9.8;
2549 $line->remise_percent = 50;
2551 $line->total_ht = 100;
2552 $line->total_ttc = 119.6;
2553 $line->total_tva = 19.6;
2554 $line->remise_percent = 00;
2557 if ($num_prods > 0) {
2558 $prodid = mt_rand(1, $num_prods);
2559 $line->fk_product = $prodids[$prodid];
2562 $this->lines[$xnbp] = $line;
2564 $this->total_ht += $line->total_ht;
2565 $this->total_tva += $line->total_tva;
2566 $this->total_ttc += $line->total_ttc;
2583 $this->nb = array();
2586 $sql =
"SELECT count(p.rowid) as nb";
2587 $sql .=
" FROM ".MAIN_DB_PREFIX.
"supplier_proposal as p";
2588 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON p.fk_soc = s.rowid";
2589 if (empty($user->socid) && !$user->hasRight(
'societe',
'client',
'voir')) {
2590 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON s.rowid = sc.fk_soc";
2591 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
2594 $sql .=
" ".$clause.
" p.entity IN (".
getEntity(
'supplier_proposal').
")";
2596 $resql = $this->db->query($sql);
2599 while ($obj = $this->db->fetch_object($resql)) {
2600 $this->nb[
"supplier_proposals"] = $obj->nb;
2602 $this->db->free($resql);
2606 $this->error = $this->db->lasterror();
2619 public function getNextNumRef($soc)
2621 global $conf, $db, $langs;
2622 $langs->load(
"supplier_proposal");
2631 $dirmodels = array_merge(array(
'/'), (array) $conf->modules_parts[
'models']);
2632 foreach ($dirmodels as $reldir) {
2633 $dir =
dol_buildpath($reldir.
"core/modules/supplier_proposal/");
2636 $mybool = ((bool) @include_once $dir.$file) || $mybool;
2644 $obj =
new $classname();
2645 '@phan-var-force ModeleNumRefSupplierProposal $obj';
2648 $numref = $obj->getNextValue($soc, $this);
2650 if ($numref !=
"") {
2653 $this->error = $obj->error;
2657 $langs->load(
"errors");
2658 print $langs->trans(
"Error").
" ".$langs->trans(
"ErrorModuleSetupNotComplete", $langs->transnoentitiesnoconv(
"SupplierProposal"));
2671 global $conf, $langs;
2673 $langs->load(
'supplier_proposal');
2676 return [
'optimize' => $langs->trans(
"ShowSupplierProposal")];
2682 $datas[
'picto'] =
img_picto(
'', $this->picto).
' <u class="paddingrightonly">'.$langs->trans(
"SupplierProposal").
'</u>';
2683 if (isset($this->
status)) {
2684 $datas[
'picto'] .=
' '.$this->getLibStatut(5);
2686 if (!empty($this->
ref)) {
2687 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
2689 if (!empty($this->ref_fourn)) {
2690 $datas[
'ref_supplier'] =
'<br><b>'.$langs->trans(
'RefSupplier').
':</b> '.$this->ref_fourn;
2692 if (!empty($this->total_ht)) {
2693 $datas[
'amount_ht'] =
'<br><b>'.$langs->trans(
'AmountHT').
':</b> '.
price($this->total_ht, 0, $langs, 0, -1, -1,
getDolCurrency());
2695 if (!empty($this->total_tva)) {
2696 $datas[
'amount_vat'] =
'<br><b>'.$langs->trans(
'VAT').
':</b> '.
price($this->total_tva, 0, $langs, 0, -1, -1,
getDolCurrency());
2698 if (!empty($this->total_ttc)) {
2699 $datas[
'amount_ttc'] =
'<br><b>'.$langs->trans(
'AmountTTC').
':</b> '.
price($this->total_ttc, 0, $langs, 0, -1, -1,
getDolCurrency());
2716 public function getNomUrl($withpicto = 0, $option =
'', $get_params =
'', $notooltip = 0, $save_lastsearch_value = -1, $addlinktonotes = 0)
2718 global $langs, $conf, $user, $hookmanager;
2720 if (!empty($conf->dol_no_mouse_hover)) {
2728 'objecttype' => $this->element,
2729 'option' => $option,
2731 $classfortooltip =
'classfortooltip';
2734 $classfortooltip =
'classforajaxtooltip';
2735 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
2741 if ($option ==
'') {
2742 $url = DOL_URL_ROOT.
'/supplier_proposal/card.php?id='.$this->
id.$get_params;
2744 if ($option ==
'document') {
2745 $url = DOL_URL_ROOT.
'/supplier_proposal/document.php?id='.$this->
id.$get_params;
2748 if ($option !==
'nolink') {
2750 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
2751 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
2752 $add_save_lastsearch_values = 1;
2754 if ($add_save_lastsearch_values) {
2755 $url .=
'&save_lastsearch_values=1';
2760 if (empty($notooltip) && $user->hasRight(
'propal',
'lire')) {
2762 $label = $langs->trans(
"ShowSupplierProposal");
2763 $linkclose .=
' alt="'.dolPrintHTMLForAttribute($label).
'"';
2765 $linkclose .= ($label ?
' title="'.dolPrintHTMLForAttribute($label).
'"' :
' title="tocomplete"');
2766 $linkclose .= $dataparams.
' class="'.$classfortooltip.
'"';
2769 $linkstart =
'<a href="'.$url.
'"';
2770 $linkstart .= $linkclose.
'>';
2773 $result .= $linkstart;
2775 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), (($withpicto != 2) ?
'class="paddingright"' :
''), 0, 0, $notooltip ? 0 : 1);
2777 if ($withpicto != 2) {
2778 $result .= $this->ref;
2780 $result .= $linkend;
2782 if ($addlinktonotes) {
2783 $txttoshow = ($user->socid > 0 ? $this->note_public : $this->note_private);
2786 $result .=
' <span class="note inline-block">';
2787 $result .=
'<a href="'.DOL_URL_ROOT.
'/supplier_proposal/note.php?id='.$this->
id.
'" class="classfortooltip" title="'.
dol_escape_htmltag($notetoshow).
'">';
2792 $result .=
'</span>';
2796 $hookmanager->initHooks(array($this->element .
'dao'));
2797 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
2798 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
2800 $result = $hookmanager->resPrint;
2802 $result .= $hookmanager->resPrint;
2816 $sql =
'SELECT pt.rowid, pt.label as custom_label, pt.description, pt.fk_product, pt.fk_remise_except,';
2817 $sql .=
' pt.qty, pt.tva_tx, pt.vat_src_code, pt.remise_percent, pt.subprice, pt.info_bits,';
2818 $sql .=
' pt.total_ht, pt.total_tva, pt.total_ttc, pt.fk_product_fournisseur_price as fk_fournprice, pt.buy_price_ht as pa_ht, pt.special_code, pt.localtax1_tx, pt.localtax2_tx,';
2819 $sql .=
' pt.product_type, pt.rang, pt.fk_parent_line, pt.extraparams,';
2820 $sql .=
' p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid,';
2821 $sql .=
' p.description as product_desc, pt.ref_fourn as ref_supplier,';
2822 $sql .=
' pt.fk_multicurrency, pt.multicurrency_code, pt.multicurrency_subprice, pt.multicurrency_total_ht, pt.multicurrency_total_tva, pt.multicurrency_total_ttc, pt.fk_unit';
2823 $sql .=
' FROM '.MAIN_DB_PREFIX.
'supplier_proposaldet as pt';
2824 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON pt.fk_product=p.rowid';
2825 $sql .=
' WHERE pt.fk_supplier_proposal = '.((int) $this->
id);
2826 $sql .=
' ORDER BY pt.rang ASC, pt.rowid';
2828 dol_syslog(get_class($this).
'::getLinesArray', LOG_DEBUG);
2829 $resql = $this->db->query($sql);
2831 $num = $this->db->num_rows($resql);
2835 $obj = $this->db->fetch_object($resql);
2838 $this->lines[$i]->id = $obj->rowid;
2839 $this->lines[$i]->rowid = $obj->rowid;
2841 $this->lines[$i]->label = $obj->custom_label;
2842 $this->lines[$i]->description = $obj->description;
2843 $this->lines[$i]->desc = $obj->description;
2845 $this->lines[$i]->fk_product = $obj->fk_product;
2846 $this->lines[$i]->ref = $obj->ref;
2847 $this->lines[$i]->product_label = $obj->product_label;
2848 $this->lines[$i]->product_desc = $obj->product_desc;
2849 $this->lines[$i]->fk_product_type = $obj->fk_product_type;
2850 $this->lines[$i]->product_type = $obj->product_type;
2851 $this->lines[$i]->qty = $obj->qty;
2852 $this->lines[$i]->subprice = $obj->subprice;
2853 $this->lines[$i]->fk_remise_except = $obj->fk_remise_except;
2854 $this->lines[$i]->remise_percent = $obj->remise_percent;
2855 $this->lines[$i]->tva_tx = $obj->tva_tx;
2856 $this->lines[$i]->vat_src_code = $obj->vat_src_code;
2857 $this->lines[$i]->info_bits = $obj->info_bits;
2858 $this->lines[$i]->total_ht = $obj->total_ht;
2859 $this->lines[$i]->total_tva = $obj->total_tva;
2860 $this->lines[$i]->total_ttc = $obj->total_ttc;
2861 $this->lines[$i]->fk_fournprice = $obj->fk_fournprice;
2862 $marginInfos =
getMarginInfos($obj->subprice, $obj->remise_percent, $obj->tva_tx, $obj->localtax1_tx, $obj->localtax2_tx, $this->lines[$i]->fk_fournprice, $obj->pa_ht);
2863 $this->lines[$i]->pa_ht = $marginInfos[0];
2864 $this->lines[$i]->marge_tx = $marginInfos[1];
2865 $this->lines[$i]->marque_tx = $marginInfos[2];
2866 $this->lines[$i]->fk_parent_line = $obj->fk_parent_line;
2867 $this->lines[$i]->special_code = $obj->special_code;
2868 $this->lines[$i]->rang = $obj->rang;
2870 $this->lines[$i]->ref_fourn = $obj->ref_supplier;
2871 $this->lines[$i]->ref_supplier = $obj->ref_supplier;
2874 $this->lines[$i]->fk_multicurrency = $obj->fk_multicurrency;
2875 $this->lines[$i]->multicurrency_code = $obj->multicurrency_code;
2876 $this->lines[$i]->multicurrency_subprice = $obj->multicurrency_subprice;
2877 $this->lines[$i]->multicurrency_total_ht = $obj->multicurrency_total_ht;
2878 $this->lines[$i]->multicurrency_total_tva = $obj->multicurrency_total_tva;
2879 $this->lines[$i]->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
2880 $this->lines[$i]->fk_unit = $obj->fk_unit;
2881 $this->lines[$i]->extraparams = !empty($obj->extraparams) ? (array) json_decode($obj->extraparams,
true) : array();
2883 $this->lines[$i]->fetch_optionals();
2887 $this->db->free($resql);
2891 $this->error = $this->db->error();
2907 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
2911 $langs->load(
"supplier_proposal");
2912 $outputlangs->load(
"products");
2917 if ($this->model_pdf) {
2918 $modele = $this->model_pdf;
2924 if (empty($modele)) {
2928 $modelpath =
"core/modules/supplier_proposal/doc/";
2930 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
2962 'supplier_proposaldet'
2980 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
2982 $return =
'<div class="box-flex-item box-flex-grow-zero">';
2983 $return .=
'<div class="info-box info-box-sm">';
2984 $return .=
'<span class="info-box-icon bg-infobox-action">';
2987 $return .=
'</span>';
2988 $return .=
'<div class="info-box-content">';
2989 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl() : $this->ref).
'</span>';
2990 if ($selected >= 0) {
2991 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2993 if (property_exists($this,
'socid')) {
2994 $return .=
'<span class="info-box-ref"> | '.$this->socid.
'</span>';
2996 if (property_exists($this,
'delivery_date')) {
2997 $return .=
'<br><span class="opacitymedium">'.$langs->trans(
"DateEnd").
'</span> : <span class="info-box-label">'.
dol_print_date($this->delivery_date).
'</span>';
2999 if (property_exists($this,
'total_ttc')) {
3000 $return .=
'<br><span class="opacitymedium" >'.$langs->trans(
"AmountHT").
' : </span><span class="info-box-label amount">'.
price($this->total_ttc).
'</span>';
3002 if (method_exists($this,
'getLibStatut')) {
3003 $return .=
'<br><div class="info-box-status">'.$this->getLibStatut(3).
'</div>';
3005 $return .=
'</div>';
3006 $return .=
'</div>';
3007 $return .=
'</div>';
3023 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
3024 return parent::setCategoriesCommon($categories, Categorie::TYPE_SUPPLIER_PROPOSAL);
3047 public $element =
'supplier_proposaldet';
3052 public $table_element =
'supplier_proposaldet';
3077 public $fk_supplier_proposal;
3082 public $fk_parent_line;
3099 public $fk_product_type;
3118 public $vat_src_code;
3123 public $remise_percent;
3128 public $fk_remise_except;
3138 public $fk_fournprice;
3156 public $special_code;
3164 public $info_bits = 0;
3202 public $product_ref;
3215 public $product_label;
3227 public $product_desc;
3232 public $localtax1_tx;
3236 public $localtax2_tx;
3240 public $localtax1_type;
3244 public $localtax2_type;
3248 public $total_localtax1;
3252 public $total_localtax2;
3257 public $skip_update_total;
3266 public $ref_supplier;
3272 public $fk_multicurrency;
3277 public $multicurrency_code;
3281 public $multicurrency_subprice;
3285 public $multicurrency_total_ht;
3289 public $multicurrency_total_tva;
3293 public $multicurrency_total_ttc;
3313 $sql =
'SELECT pd.rowid, pd.fk_supplier_proposal, pd.fk_parent_line, pd.fk_product, pd.label as custom_label, pd.description, pd.price, pd.qty, pd.tva_tx,';
3314 $sql .=
' pd.date_start, pd.date_end,';
3315 $sql .=
' pd.remise, pd.remise_percent, pd.fk_remise_except, pd.subprice, pd.subprice_ttc,';
3316 $sql .=
' pd.info_bits, pd.total_ht, pd.total_tva, pd.total_ttc, pd.fk_product_fournisseur_price as fk_fournprice, pd.buy_price_ht as pa_ht, pd.special_code, pd.rang,';
3317 $sql .=
' pd.localtax1_tx, pd.localtax2_tx, pd.total_localtax1, pd.total_localtax2,';
3318 $sql .=
' p.ref as product_ref, p.label as product_label, p.description as product_desc,';
3319 $sql .=
' pd.product_type, pd.ref_fourn as ref_produit_fourn, pd.extraparams,';
3320 $sql .=
' pd.fk_multicurrency, pd.multicurrency_code, pd.multicurrency_subprice, pd.multicurrency_subprice_ttc, pd.multicurrency_total_ht, pd.multicurrency_total_tva, pd.multicurrency_total_ttc, pd.fk_unit';
3321 $sql .=
' FROM '.MAIN_DB_PREFIX.
'supplier_proposaldet as pd';
3322 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON pd.fk_product = p.rowid';
3323 $sql .=
' WHERE pd.rowid = '.((int) $rowid);
3325 $result = $this->db->query($sql);
3327 if ($objp = $this->db->fetch_object($result)) {
3328 $this->
id = $objp->rowid;
3329 $this->fk_supplier_proposal = $objp->fk_supplier_proposal;
3330 $this->fk_parent_line = $objp->fk_parent_line;
3331 $this->label = $objp->custom_label;
3332 $this->desc = $objp->description;
3333 $this->qty = $objp->qty;
3335 $this->subprice = $objp->subprice;
3336 $this->subprice_ttc = $objp->subprice_ttc;
3338 $this->tva_tx = $objp->tva_tx;
3339 $this->remise_percent = $objp->remise_percent;
3340 $this->fk_remise_except = $objp->fk_remise_except;
3341 $this->fk_product = $objp->fk_product;
3342 $this->info_bits = $objp->info_bits;
3343 $this->date_start = $this->db->jdate($objp->date_start);
3344 $this->date_end = $this->db->jdate($objp->date_end);
3346 $this->total_ht = $objp->total_ht;
3347 $this->total_tva = $objp->total_tva;
3348 $this->total_ttc = $objp->total_ttc;
3350 $this->fk_fournprice = $objp->fk_fournprice;
3352 $marginInfos =
getMarginInfos($objp->subprice, $objp->remise_percent, $objp->tva_tx, $objp->localtax1_tx, $objp->localtax2_tx, $this->fk_fournprice, $objp->pa_ht);
3353 $this->pa_ht = $marginInfos[0];
3354 $this->marge_tx = $marginInfos[1];
3355 $this->marque_tx = $marginInfos[2];
3357 $this->special_code = $objp->special_code;
3358 $this->product_type = $objp->product_type;
3359 $this->rang = $objp->rang;
3361 $this->product_ref = $objp->product_ref;
3362 $this->product_label = $objp->product_label;
3363 $this->product_desc = $objp->product_desc;
3365 $this->ref_fourn = $objp->ref_produit_fourn;
3367 $this->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams,
true) : array();
3370 $this->fk_multicurrency = $objp->fk_multicurrency;
3371 $this->multicurrency_code = $objp->multicurrency_code;
3372 $this->multicurrency_subprice = $objp->multicurrency_subprice;
3373 $this->multicurrency_subprice_ttc = $objp->multicurrency_subprice_ttc;
3374 $this->multicurrency_total_ht = $objp->multicurrency_total_ht;
3375 $this->multicurrency_total_tva = $objp->multicurrency_total_tva;
3376 $this->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
3377 $this->fk_unit = $objp->fk_unit;
3379 $this->db->free($result);
3401 dol_syslog(get_class($this).
"::insert rang=".$this->rang);
3404 if (empty($this->tva_tx)) {
3407 if (empty($this->vat_src_code)) {
3408 $this->vat_src_code =
'';
3410 if (empty($this->localtax1_tx)) {
3411 $this->localtax1_tx = 0;
3413 if (empty($this->localtax2_tx)) {
3414 $this->localtax2_tx = 0;
3416 if (empty($this->localtax1_type)) {
3417 $this->localtax1_type =
'';
3419 if (empty($this->localtax2_type)) {
3420 $this->localtax2_type =
'';
3422 if (empty($this->total_localtax1)) {
3423 $this->total_localtax1 = 0;
3425 if (empty($this->total_localtax2)) {
3426 $this->total_localtax2 = 0;
3428 if (empty($this->rang)) {
3431 if (empty($this->remise_percent)) {
3432 $this->remise_percent = 0;
3434 if (empty($this->info_bits)) {
3435 $this->info_bits = 0;
3437 if (empty($this->special_code)) {
3438 $this->special_code = 0;
3440 if (empty($this->fk_parent_line)) {
3441 $this->fk_parent_line = 0;
3443 if (empty($this->fk_fournprice)) {
3444 $this->fk_fournprice = 0;
3446 if (empty($this->fk_unit)) {
3449 if (empty($this->subprice)) {
3450 $this->subprice = 0;
3453 if (empty($this->pa_ht)) {
3458 if ($this->pa_ht == 0) {
3459 $result = $this->
defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
3463 $this->pa_ht = $result;
3468 if ($this->product_type < 0) {
3475 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.
'supplier_proposaldet';
3476 $sql .=
' (fk_supplier_proposal, fk_parent_line, label, description, fk_product, product_type,';
3477 $sql .=
' date_start, date_end,';
3478 $sql .=
' fk_remise_except, qty, tva_tx, vat_src_code, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type,';
3479 $sql .=
' subprice, subprice_ttc, remise_percent, ';
3480 $sql .=
' info_bits, ';
3481 $sql .=
' total_ht, total_tva, total_localtax1, total_localtax2, total_ttc, fk_product_fournisseur_price, buy_price_ht, special_code, rang,';
3482 $sql .=
' ref_fourn,';
3483 $sql .=
' fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_subprice_ttc, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc, fk_unit)';
3484 $sql .=
" VALUES (".$this->fk_supplier_proposal.
",";
3485 $sql .=
" ".($this->fk_parent_line > 0 ? ((int) $this->fk_parent_line) :
"null").
",";
3486 $sql .=
" ".(!empty($this->label) ?
"'".$this->db->escape($this->label).
"'" :
"null").
",";
3487 $sql .=
" '".$this->db->escape($this->desc).
"',";
3488 $sql .=
" ".($this->fk_product ? ((int) $this->fk_product) :
"null").
",";
3489 $sql .=
" ".((int) $this->product_type).
",";
3490 $sql .=
" ".($this->date_start ?
"'".$this->db->idate($this->date_start).
"'" :
"null").
",";
3491 $sql .=
" ".($this->date_end ?
"'".$this->db->idate($this->date_end).
"'" :
"null").
",";
3492 $sql .=
" ".($this->fk_remise_except ? ((int) $this->fk_remise_except) :
"null").
",";
3493 $sql .=
" ".(float)
price2num($this->qty,
'MS').
",";
3494 $sql .=
" ".(float)
price2num($this->tva_tx).
",";
3495 $sql .=
" '".$this->db->escape($this->vat_src_code).
"',";
3496 $sql .=
" ".(float)
price2num($this->localtax1_tx).
",";
3497 $sql .=
" ".(float)
price2num($this->localtax2_tx).
",";
3498 $sql .=
" '".$this->db->escape($this->localtax1_type).
"',";
3499 $sql .=
" '".$this->db->escape($this->localtax2_type).
"',";
3500 $sql .=
" ".(float)
price2num($this->subprice,
'MU') .
",";
3501 $sql .=
" ".(float)
price2num($this->subprice_ttc,
'MU') .
",";
3502 $sql .=
" ".((float) $this->remise_percent).
",";
3503 $sql .=
" ".(isset($this->info_bits) ? ((int) $this->info_bits) :
"null").
",";
3504 $sql .=
" ".(float)
price2num($this->total_ht,
'MT').
",";
3505 $sql .=
" ".(float)
price2num($this->total_tva,
'MT').
",";
3506 $sql .=
" ".(float)
price2num($this->total_localtax1,
'MT').
",";
3507 $sql .=
" ".(float)
price2num($this->total_localtax2,
'MT').
",";
3508 $sql .=
" ".(float)
price2num($this->total_ttc,
'MT').
",";
3509 $sql .=
" ".(!empty($this->fk_fournprice) ? ((int) $this->fk_fournprice) :
"null").
",";
3510 $sql .=
" ".(isset($this->pa_ht) ? (float)
price2num($this->pa_ht,
'MU') :
"null").
",";
3511 $sql .=
' '.((int) $this->special_code).
',';
3512 $sql .=
' '.((int) $this->rang).
',';
3513 $sql .=
" '".$this->db->escape($this->ref_fourn).
"'";
3514 $sql .=
", ".($this->fk_multicurrency > 0 ? ((int) $this->fk_multicurrency) :
'null');
3515 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
3516 $sql .=
", ".(float)
price2num($this->multicurrency_subprice,
'CU');
3517 $sql .=
", ".(float)
price2num($this->multicurrency_subprice_ttc,
'CU');
3518 $sql .=
", ".(float)
price2num($this->multicurrency_total_ht,
'CT');
3519 $sql .=
", ".(float)
price2num($this->multicurrency_total_tva,
'CT');
3520 $sql .=
", ".(float)
price2num($this->multicurrency_total_ttc,
'CT');
3521 $sql .=
", ".($this->fk_unit ? ((int) $this->fk_unit) :
'null');
3524 dol_syslog(get_class($this).
'::insert', LOG_DEBUG);
3525 $resql = $this->db->query($sql);
3527 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
'supplier_proposaldet');
3536 if (!$error && !$notrigger) {
3538 $result = $this->call_trigger(
'LINESUPPLIER_PROPOSAL_INSERT', $user);
3540 $this->db->rollback();
3546 $this->db->commit();
3549 $this->error = $this->db->error().
" sql=".$sql;
3550 $this->db->rollback();
3561 public function delete($user)
3567 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"supplier_proposaldet";
3568 $sql .=
" WHERE rowid = ".((int) $this->
id);
3570 if ($this->db->query($sql)) {
3576 dol_syslog(get_class($this).
"::delete error -4 ".$this->error, LOG_ERR);
3581 $result = $this->call_trigger(
'LINESUPPLIER_PROPOSAL_DELETE', $user);
3583 $this->db->rollback();
3588 $this->db->commit();
3592 $this->error = $this->db->error().
" sql=".$sql;
3593 $this->db->rollback();
3611 if (empty($this->tva_tx)) {
3614 if (empty($this->localtax1_tx)) {
3615 $this->localtax1_tx = 0;
3617 if (empty($this->localtax2_tx)) {
3618 $this->localtax2_tx = 0;
3620 if (empty($this->total_localtax1)) {
3621 $this->total_localtax1 = 0;
3623 if (empty($this->total_localtax2)) {
3624 $this->total_localtax2 = 0;
3626 if (empty($this->localtax1_type)) {
3627 $this->localtax1_type =
'';
3629 if (empty($this->localtax2_type)) {
3630 $this->localtax2_type =
'';
3632 if (empty($this->marque_tx)) {
3633 $this->marque_tx = 0;
3635 if (empty($this->marge_tx)) {
3636 $this->marge_tx = 0;
3638 if (empty($this->remise_percent)) {
3639 $this->remise_percent = 0;
3641 if (empty($this->info_bits)) {
3642 $this->info_bits = 0;
3644 if (empty($this->special_code)) {
3645 $this->special_code = 0;
3647 if (empty($this->fk_parent_line)) {
3648 $this->fk_parent_line = 0;
3650 if (empty($this->fk_fournprice)) {
3651 $this->fk_fournprice = 0;
3653 if (empty($this->fk_unit)) {
3656 if (empty($this->subprice)) {
3657 $this->subprice = 0;
3660 if (empty($this->pa_ht)) {
3665 if ($this->pa_ht == 0) {
3666 $result = $this->
defineBuyPrice($this->subprice, $this->remise_percent, $this->fk_product);
3670 $this->pa_ht = $result;
3677 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposaldet SET";
3678 $sql .=
" description = '".$this->db->escape($this->desc).
"'";
3679 $sql .=
" , label = ".(!empty($this->label) ?
"'".$this->db->escape($this->label).
"'" :
"null");
3680 $sql .=
" , product_type = ".((int) $this->product_type);
3681 $sql .=
" , date_start = ".($this->date_start ?
"'".$this->db->idate($this->date_start).
"'" :
"null");
3682 $sql .=
" , date_end = ".($this->date_end ?
"'".$this->db->idate($this->date_end).
"'" :
"null");
3683 $sql .=
" , tva_tx = '".price2num($this->tva_tx).
"'";
3684 $sql .=
" , localtax1_tx = ".(float)
price2num($this->localtax1_tx);
3685 $sql .=
" , localtax2_tx = ".(float)
price2num($this->localtax2_tx);
3686 $sql .=
" , localtax1_type = '".$this->db->escape($this->localtax1_type).
"'";
3687 $sql .=
" , localtax2_type = '".$this->db->escape($this->localtax2_type).
"'";
3688 $sql .=
" , qty = ".(float)
price2num($this->qty);
3689 $sql .=
" , subprice = ".(float)
price2num($this->subprice);
3690 $sql .=
" , subprice_ttc = ".(float)
price2num($this->subprice_ttc);
3691 $sql .=
" , remise_percent = ".(float)
price2num($this->remise_percent);
3692 $sql .=
" , info_bits = ".((int) $this->info_bits);
3693 if (empty($this->skip_update_total)) {
3694 $sql .=
" , total_ht = ".(float)
price2num($this->total_ht);
3695 $sql .=
" , total_tva = ".(float)
price2num($this->total_tva);
3696 $sql .=
" , total_ttc = ".(float)
price2num($this->total_ttc);
3697 $sql .=
" , total_localtax1 = ".(float)
price2num($this->total_localtax1);
3698 $sql .=
" , total_localtax2 = ".(float)
price2num($this->total_localtax2);
3700 $sql .=
" , fk_product_fournisseur_price = ".(!empty($this->fk_fournprice) ?
"'".$this->db->escape((
string) $this->fk_fournprice).
"'" :
"null");
3701 $sql .=
" , buy_price_ht = ".(float)
price2num($this->pa_ht);
3702 $sql .=
" , special_code = ".((int) $this->special_code);
3703 $sql .=
" , fk_parent_line = ".($this->fk_parent_line > 0 ? $this->fk_parent_line :
"null");
3704 if (!empty($this->rang)) {
3705 $sql .=
", rang = ".((int) $this->rang);
3707 $sql .=
" , ref_fourn = ".(!empty($this->ref_fourn) ?
"'".$this->db->escape($this->ref_fourn).
"'" :
"null");
3708 $sql .=
" , fk_unit = ".($this->fk_unit ? (int) $this->fk_unit :
'null');
3711 $sql .=
" , multicurrency_subprice = ".(float)
price2num($this->multicurrency_subprice);
3712 $sql .=
" , multicurrency_subprice_ttc = ".(float)
price2num($this->multicurrency_subprice_ttc);
3713 $sql .=
" , multicurrency_total_ht = ".(float)
price2num($this->multicurrency_total_ht);
3714 $sql .=
" , multicurrency_total_tva = ".(float)
price2num($this->multicurrency_total_tva);
3715 $sql .=
" , multicurrency_total_ttc = ".(float)
price2num($this->multicurrency_total_ttc);
3717 $sql .=
" WHERE rowid = ".((int) $this->
id);
3719 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
3720 $resql = $this->db->query($sql);
3729 if (!$error && !$notrigger) {
3731 $result = $this->call_trigger(
'LINESUPPLIER_PROPOSAL_MODIFY', $user);
3733 $this->db->rollback();
3739 $this->db->commit();
3742 $this->error = $this->db->error();
3743 $this->db->rollback();
3761 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"supplier_proposaldet SET";
3762 $sql .=
" total_ht = ".(float)
price2num($this->total_ht,
'MT');
3763 $sql .=
",total_tva = ".(float)
price2num($this->total_tva,
'MT');
3764 $sql .=
",total_ttc = ".(float)
price2num($this->total_ttc,
'MT');
3765 $sql .=
" WHERE rowid = ".((int) $this->
id);
3767 dol_syslog(
"SupplierProposalLine::update_total", LOG_DEBUG);
3769 $resql = $this->db->query($sql);
3771 $this->db->commit();
3774 $this->error = $this->db->error();
3775 $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
isLineOfObject($lineid)
Check that a line belongs to this object, using $this->table_element_line and $this->fk_element.
static isExistingObject($element, $id, $ref='', $ref_ext='')
Check if an object id or ref exists If you don't need or want to instantiate the object and just need...
updateRangOfLine($rowid, $rang)
Update position of line (rang)
checkActiveProductInLines($status='onsale')
Check if all products have the right status (on sale, on buy) called during validation of propal,...
deleteExtraFields()
Delete all extra fields values for the current object.
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
static commonReplaceProduct(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a product id with another one.
line_max($fk_parent_line=0)
Get max value used for position of line (rang)
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
add_contact($fk_socpeople, $type_contact, $source='external', $notrigger=0)
Add a link between element $this->element and a contact.
Parent class for class inheritance lines of business objects This class is useless for the moment so ...
Class to manage absolute discounts.
Class to manage Dolibarr database access.
static getIdAndTxFromCode($dbs, $code, $date_document=0)
Get id and rate of currency from code.
Class to manage predefined suppliers products.
Class to manage products or services.
const TYPE_PRODUCT
Regular product.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage price ask supplier.
updatePriceFournisseur($idProductFournPrice, $product, $user)
Update ProductFournisseur.
updateline($rowid, $pu, $qty, $remise_percent, $txtva, $txlocaltax1=0, $txlocaltax2=0, $desc='', $price_base_type='HT', $info_bits=0, $special_code=0, $fk_parent_line=0, $skip_update_total=0, $fk_fournprice=0, $pa_ht=0, $label='', $type=0, $array_options=[], $ref_supplier='', $fk_unit=0, $pu_ht_devise=0)
Update a proposal line.
cloture($user, $status, $note)
Close the askprice.
initAsSpecimen($param=array())
Initialise an instance with random values.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template module.
addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1=0, $txlocaltax2=0, $fk_product=0, $remise_percent=0, $price_base_type='HT', $pu_ttc=0, $info_bits=0, $type=0, $rang=-1, $special_code=0, $fk_parent_line=0, $fk_fournprice=0, $pa_ht=0, $label='', $array_options=[], $ref_supplier='', $fk_unit=0, $origin='', $origin_id=0, $pu_ht_devise=0, $date_start=0, $date_end=0)
Add a proposal line into database (linked to product/service or not) Les parameters sont deja cense e...
info($id)
Object SupplierProposal Information.
create($user, $notrigger=0)
Create commercial proposal into database this->ref can be set or empty.
insert_discount($idremise)
Adding line of fixed discount in the proposal in DB.
reopen($user, $status, $note='', $notrigger=0)
Set an overall discount on the proposal.
static replaceProduct(DoliDB $db, $origin_id, $dest_id)
Function used to replace a product id with another one.
fetch($rowid, $ref='')
Load a proposal from database and its ligne array.
load_board($user, $mode)
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
createFromClone(User $user, $fromid=0)
Load an object from its id and create a new one in database.
const STATUS_NOTSIGNED
Not signed quote, canceled.
const STATUS_DRAFT
Draft status.
liste_array($shortlist=0, $draft=0, $notcurrentuser=0, $socid=0, $limit=0, $offset=0, $sortfield='p.datec', $sortorder='DESC')
Return list of askprice (eventually filtered on user) into an array.
update($user, $notrigger=0)
Update the header fields of the price request that can be edited without a dedicated action.
setDeliveryDate($user, $delivery_date)
Set delivery date.
__construct($db, $socid=0, $supplier_proposalid=0)
Constructor.
LibStatut($status, $mode=1)
Return label of a status (draft, validated, ...)
setCategories($categories)
Sets object to supplied categories.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
updateOrCreatePriceFournisseur($user)
Add or update supplier price according to result of proposal.
loadStateBoard()
Load indicator this->nb of global stats widget.
deleteLine($lineid)
Delete detail line.
const STATUS_VALIDATED
Validated status.
createPriceFournisseur($product, $user)
Create Price Fournisseur.
getLibStatut($mode=0)
Return label of status of proposal (draft, validated, ...)
add_product($idproduct, $qty, $remise_percent=0)
Add line into array ->lines.
set_date_livraison($user, $delivery_date)
Set delivery date.
const STATUS_SIGNED
Signed quote.
getNomUrl($withpicto=0, $option='', $get_params='', $notooltip=0, $save_lastsearch_value=-1, $addlinktonotes=0)
Return clickable link of object (with eventually picto)
getKanbanView($option='', $arraydata=null)
Return clickable link of object (with eventually picto)
getTooltipContentArray($params)
getTooltipContentArray
valid($user, $notrigger=0)
Set status to validated.
const STATUS_CLOSE
Billed or closed/processed quote.
getLinesArray()
Retrieve an array of supplier proposal lines.
setDraft($user)
Set draft status.
Class to manage supplier_proposal lines.
fetch($rowid)
Retrieve the propal line object.
insert($notrigger=0)
Insert object line propal in database.
update_total()
Update DB line fields total_xxx Used by migration.
update($notrigger=0)
Update propal line object into DB.
__construct($db)
Class line Constructor.
Class to manage translations.
Class to manage Dolibarr users.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
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.
dol_now($mode='gmt')
Return date for now.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $allowothertags=array())
Show a picto called object_picto (generic function)
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
get_default_npr(Societe $thirdparty_seller, Societe $thirdparty_buyer, $idprod=0, $idprodfournprice=0)
Function that returns whether VAT must be recoverable collected VAT (e.g.: VAT NPR in France)
getDolCurrency()
Return the main currency ('EUR', 'USD', ...)
dolGetStatus($statusLabel='', $statusLabelShort='', $html='', $statusType='status0', $displayMode=0, $url='', $params=array())
Output the badge of a status.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
getDolGlobalBool($key, $default=false)
Return a Dolibarr global constant boolean value.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
get_default_tva(Societe $thirdparty_seller, Societe $thirdparty_buyer, $idprod=0, $idprodfournprice=0)
Function that return vat rate of a product line (according to seller, buyer and product vat rate) VAT...
get_localtax($vatrate, $local, $thirdparty_buyer=null, $thirdparty_seller=null, $vatnpr=0)
Return localtax rate for a particular VAT rate, when selling a product with vat $vatrate,...
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
getMarginInfos($pv_ht, $remise_percent, $tva_tx, $localtax1_tx, $localtax2_tx, $fk_pa, $pa_ht)
Return an array with margins information of a line.
calcul_price_total($qty, $pu, $remise_percent_ligne, $txtva, $uselocaltax1_rate, $uselocaltax2_rate, $remise_percent_global, $price_base_type, $info_bits, $type, $seller=null, $localtaxes_array=[], $progress=100, $multicurrency_tx=1, $pu_devise=0, $multicurrency_code='')
Calculate totals (net, vat, ...) of a line.
if(getDolGlobalString( 'TAKEPOS_SHOW_CUSTOMER')) print $langs trans('Date')." left Label right Qty right Price right TotalHT right TotalTTC right right right right right right right right right centpercent right TotalHT right n right VAT right n right TotalVAT right n No sujeto a RE IRPF right TotalLT1 right n right TotalLT2 right n right TotalTTC right n takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency right TotalTTC takeposcustomercurrency right takeposcustomercurrency n right PaymentTypeShortLIQ right SELECT p pos_change as p datep as date