33require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
34require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.class.php';
35require_once DOL_DOCUMENT_ROOT.
'/product/class/productfournisseurprice.class.php';
56 public $product_fourn_price_id;
73 public $delivery_time_days;
83 public $desc_supplier;
88 public $vatrate_supplier;
135 public $fourn_remise_percent;
140 public $fourn_remise;
142 public $fourn_charges;
147 public $product_fourn_id;
149 public $product_fourn_entity;
159 public $fk_availability;
161 public $fourn_unitprice;
162 public $fourn_unitprice_with_discount;
163 public $fourn_tva_tx;
164 public $fourn_tva_npr;
169 public $fk_supplier_price_expression;
174 public $supplier_reputation;
179 public $reputations = array();
186 public $fourn_multicurrency_id;
188 public $fourn_multicurrency_code;
189 public $fourn_multicurrency_tx;
190 public $fourn_multicurrency_price;
191 public $fourn_multicurrency_unitprice;
202 public $supplier_barcode;
213 public $supplier_fk_barcode_type;
217 public $labelStatusShort;
220 const STATUS_OPEN = 1;
221 const STATUS_CANCELED = 0;
234 $langs->load(
"suppliers");
235 $this->reputations = array(
'-1' =>
'',
'FAVORITE' => $langs->trans(
'Favorite'),
'NOTTHGOOD' => $langs->trans(
'NotTheGoodQualitySupplier'),
'DONOTORDER' => $langs->trans(
'DoNotOrderThisProductToThisSupplier'));
252 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"product_fournisseur_price";
253 $sql .=
" WHERE fk_product = ".((int) $this->
id).
" AND fk_soc = ".((int) $id_fourn);
255 dol_syslog(get_class($this).
"::remove_fournisseur", LOG_DEBUG);
256 $resql2 = $this->db->query($sql);
258 $this->error = $this->db->lasterror();
266 $this->db->rollback();
289 $result = $this->
call_trigger(
'SUPPLIER_PRODUCT_BUYPRICE_DELETE', $user);
296 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"product_fournisseur_price";
297 $sql .=
" WHERE rowid = ".((int) $rowid);
299 dol_syslog(get_class($this).
"::remove_product_fournisseur_price", LOG_DEBUG);
300 $resql = $this->db->query($sql);
302 $this->error = $this->db->lasterror();
311 $this->db->rollback();
360 $delivery_time_days = 0,
361 $supplier_reputation =
'',
362 $localtaxes_array = array(),
363 $newdefaultvatcode =
'',
364 $multicurrency_buyprice = 0,
365 $multicurrency_price_base_type =
'HT',
366 $multicurrency_tx = 1,
367 $multicurrency_code =
'',
370 $fk_barcode_type = 0,
374 global $conf, $langs;
381 if (empty($buyprice)) {
384 if (empty($charges)) {
387 if (empty($availability)) {
390 if (empty($remise_percent)) {
393 if (empty($supplier_reputation) || $supplier_reputation == -1) {
394 $supplier_reputation =
'';
396 if ($delivery_time_days !=
'' && !is_numeric($delivery_time_days)) {
397 $delivery_time_days = 0;
399 if ($price_base_type ==
'TTC') {
401 $buyprice /= (1 + ($ttx / 100));
405 $multicurrency_unitBuyPrice =
null;
406 $fk_multicurrency =
null;
407 if (isModEnabled(
"multicurrency")) {
408 if (empty($multicurrency_tx)) {
409 $multicurrency_tx = 1;
411 if (empty($multicurrency_buyprice)) {
412 $multicurrency_buyprice = 0;
414 if ($multicurrency_price_base_type ==
'TTC') {
416 $multicurrency_buyprice /= (1 + ($ttx / 100));
418 $multicurrency_buyprice =
price2num($multicurrency_buyprice,
'MU');
419 $multicurrency_unitBuyPrice =
price2num((
float) $multicurrency_buyprice / $qty,
'MU');
421 $buyprice = (float) $multicurrency_buyprice / $multicurrency_tx;
425 $buyprice = (float)
price2num($buyprice,
'MU');
426 $charges = (float)
price2num($charges,
'MU');
428 $unitBuyPrice = (float)
price2num($buyprice / $qty,
'MU');
432 $packaging =
price2num((empty($this->packaging) ? $qty : $this->packaging),
'MS');
439 if (count($localtaxes_array) > 0) {
440 $localtaxtype1 = $localtaxes_array[
'0'];
441 $localtax1 = $localtaxes_array[
'1'];
442 $localtaxtype2 = $localtaxes_array[
'2'];
443 $localtax2 = $localtaxes_array[
'3'];
445 $localtaxtype1 =
'0';
447 $localtaxtype2 =
'0';
450 if (empty($localtax1)) {
453 if (empty($localtax2)) {
459 if ($this->product_fourn_price_id > 0) {
462 if (is_array($logPrices) && count($logPrices) == 0) {
463 $currentPfp =
new self($this->db);
464 $result = $currentPfp->fetch_product_fournisseur_price($this->product_fourn_price_id);
465 if ($result > 0 && $currentPfp->fourn_price != 0) {
466 $currentPfpUser =
new User($this->db);
467 $result = $currentPfpUser->fetch($currentPfp->user_id);
469 $currentPfp->logPrice(
471 $currentPfp->date_creation,
472 $currentPfp->fourn_price,
473 $currentPfp->fourn_qty,
474 $currentPfp->fourn_multicurrency_price,
475 $currentPfp->fourn_multicurrency_unitprice,
476 $currentPfp->fourn_multicurrency_tx,
477 $currentPfp->fourn_multicurrency_id,
478 $currentPfp->fourn_multicurrency_code
483 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"product_fournisseur_price";
484 $sql .=
" SET fk_user = ".((int) $user->id).
" ,";
485 $sql .=
" datec = '".$this->db->idate($now).
"' ,";
486 $sql .=
" ref_fourn = '".$this->db->escape($ref_fourn).
"',";
487 $sql .=
" desc_fourn = '".$this->db->escape($desc_fourn).
"',";
488 $sql .=
" price = ".((float) $buyprice).
",";
489 $sql .=
" quantity = ".((float) $qty).
",";
490 $sql .=
" remise_percent = ".((float) $remise_percent).
",";
491 $sql .=
" remise = ".((float) $remise).
",";
492 $sql .=
" unitprice = ".((float) $unitBuyPrice).
",";
493 $sql .=
" fk_availability = ".((int) $availability).
",";
494 $sql .=
" multicurrency_price = ".(isset($multicurrency_buyprice) ?
"'".$this->db->escape(
price2num($multicurrency_buyprice)).
"'" :
'null').
",";
495 $sql .=
" multicurrency_unitprice = ".(isset($multicurrency_unitBuyPrice) ?
"'".$this->db->escape(
price2num($multicurrency_unitBuyPrice)).
"'" :
'null').
",";
496 $sql .=
" multicurrency_tx = ".(isset($multicurrency_tx) ?
"'".$this->db->escape($multicurrency_tx).
"'" :
'1').
",";
497 $sql .=
" fk_multicurrency = ".(isset($fk_multicurrency) ? (int) $fk_multicurrency :
'null').
",";
498 $sql .=
" multicurrency_code = ".(isset($multicurrency_code) ?
"'".$this->db->escape($multicurrency_code).
"'" :
'null').
",";
499 $sql .=
" entity = ".$conf->entity.
",";
500 $sql .=
" tva_tx = ".price2num($tva_tx).
",";
506 $sql .=
" default_vat_code=".($newdefaultvatcode ?
"'".$this->db->escape($newdefaultvatcode).
"'" :
"null").
",";
507 $sql .=
" info_bits = ".((int) $newnpr).
",";
508 $sql .=
" charges = ".((float) $charges).
",";
509 $sql .=
" delivery_time_days = ".($delivery_time_days !=
'' ? ((int) $delivery_time_days) :
'null').
",";
510 $sql .=
" supplier_reputation = ".(empty($supplier_reputation) ?
'NULL' :
"'".$this->db->escape($supplier_reputation).
"'").
",";
511 $sql .=
" barcode = ".(empty($barcode) ?
'NULL' :
"'".$this->db->escape($barcode).
"'").
",";
512 $sql .=
" fk_barcode_type = ".(empty($fk_barcode_type) ?
'NULL' :
"'".$this->db->escape($fk_barcode_type).
"'");
514 $sql .=
", packaging = ".(empty($packaging) ? 1 : $packaging);
516 $sql .=
" WHERE rowid = ".((int) $this->product_fourn_price_id);
519 if (!empty($options) && is_array($options)) {
521 $res = $productfournisseurprice->fetch($this->product_fourn_price_id);
523 foreach ($options as $key => $value) {
524 $productfournisseurprice->array_options[$key] = $value;
526 $res = $productfournisseurprice->update($user);
528 $this->error = $productfournisseurprice->error;
529 $this->errors = $productfournisseurprice->errors;
538 dol_syslog(get_class($this).
'::update_buyprice update knowing id of line = product_fourn_price_id = '.$this->product_fourn_price_id, LOG_DEBUG);
539 $resql = $this->db->query($sql);
542 $result = $this->
call_trigger(
'SUPPLIER_PRODUCT_BUYPRICE_MODIFY', $user);
548 $result = $this->
logPrice($user, $now, $buyprice, $qty, $multicurrency_buyprice, $multicurrency_unitBuyPrice, $multicurrency_tx, $fk_multicurrency, $multicurrency_code);
555 return $this->product_fourn_price_id;
557 $this->db->rollback();
561 $this->error = $this->db->error().
" sql=".$sql;
562 $this->db->rollback();
566 dol_syslog(get_class($this).
'::update_buyprice without knowing id of line, so we delete from company, quantity and supplier_ref and insert again', LOG_DEBUG);
569 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"product_fournisseur_price";
570 $sql .=
" WHERE fk_soc = ".((int) $fourn->id).
" AND ref_fourn = '".$this->db->escape($ref_fourn).
"' AND quantity = ".((float) $qty).
" AND entity = ".((int) $conf->entity);
571 $resql = $this->db->query($sql);
574 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"product_fournisseur_price(";
575 $sql .=
" multicurrency_price, multicurrency_unitprice, multicurrency_tx, fk_multicurrency, multicurrency_code,";
576 $sql .=
"datec, fk_product, fk_soc, ref_fourn, desc_fourn, fk_user, price, quantity, remise_percent, remise, unitprice, tva_tx, charges, fk_availability, default_vat_code, info_bits, entity, delivery_time_days, supplier_reputation, barcode, fk_barcode_type";
578 $sql .=
", packaging";
581 $sql .= (isset($multicurrency_buyprice) ?
"'".$this->db->escape(
price2num($multicurrency_buyprice)).
"'" :
'null').
",";
582 $sql .= (isset($multicurrency_unitBuyPrice) ?
"'".$this->db->escape(
price2num($multicurrency_unitBuyPrice)).
"'" :
'null').
",";
583 $sql .= (isset($multicurrency_tx) ?
"'".$this->db->escape($multicurrency_tx).
"'" :
'1').
",";
584 $sql .= (isset($fk_multicurrency) ?
"'".$this->db->escape($fk_multicurrency).
"'" :
'null').
",";
585 $sql .= (isset($multicurrency_code) ?
"'".$this->db->escape($multicurrency_code).
"'" :
'null').
",";
586 $sql .=
" '".$this->db->idate($now).
"',";
587 $sql .=
" ".((int) $this->
id).
",";
588 $sql .=
" ".((int) $fourn->id).
",";
589 $sql .=
" '".$this->db->escape($ref_fourn).
"',";
590 $sql .=
" '".$this->db->escape($desc_fourn).
"',";
591 $sql .=
" ".((int) $user->id).
",";
592 $sql .=
" ".price2num($buyprice).
",";
593 $sql .=
" ".((float) $qty).
",";
594 $sql .=
" ".((float) $remise_percent).
",";
595 $sql .=
" ".((float) $remise).
",";
596 $sql .=
" ".price2num($unitBuyPrice).
",";
597 $sql .=
" ".price2num($tva_tx).
",";
598 $sql .=
" ".price2num($charges).
",";
599 $sql .=
" ".((int) $availability).
",";
600 $sql .=
" ".($newdefaultvatcode ?
"'".$this->db->escape($newdefaultvatcode).
"'" :
"null").
",";
601 $sql .=
" ".((int) $newnpr).
",";
602 $sql .= $conf->entity.
",";
603 $sql .= ($delivery_time_days !=
'' ? ((int) $delivery_time_days) :
'null').
",";
604 $sql .= (empty($supplier_reputation) ?
'NULL' :
"'".$this->db->escape($supplier_reputation).
"'").
",";
605 $sql .= (empty($barcode) ?
'NULL' :
"'".$this->db->escape($barcode).
"'").
",";
606 $sql .= (empty($fk_barcode_type) ?
'NULL' :
"'".$this->db->escape($fk_barcode_type).
"'");
608 $sql .=
", ".(empty($this->packaging) ?
'1' :
"'".$this->db->escape($this->packaging).
"'");
612 $this->product_fourn_price_id = 0;
614 $resql = $this->db->query($sql);
616 $this->product_fourn_price_id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"product_fournisseur_price");
618 $this->error = $this->db->lasterror();
623 if (!empty($options) && is_array($options)) {
625 $res = $productfournisseurprice->fetch($this->product_fourn_price_id);
627 foreach ($options as $key => $value) {
628 $productfournisseurprice->array_options[$key] = $value;
630 $res = $productfournisseurprice->update($user);
632 $this->error = $productfournisseurprice->error;
633 $this->errors = $productfournisseurprice->errors;
643 $result = $this->
logPrice($user, $now, $buyprice, $qty, $multicurrency_buyprice, $multicurrency_unitBuyPrice, $multicurrency_tx, $fk_multicurrency, $multicurrency_code);
651 $result = $this->
call_trigger(
'SUPPLIER_PRODUCT_BUYPRICE_CREATE', $user);
659 return $this->product_fourn_price_id;
661 $this->db->rollback();
665 $this->error = $this->db->lasterror().
" sql=".$sql;
666 $this->db->rollback();
670 $this->error = $this->db->lasterror().
" sql=".$sql;
671 $this->db->rollback();
690 $sql =
"SELECT pfp.rowid, pfp.price, pfp.quantity, pfp.unitprice, pfp.remise_percent, pfp.remise, pfp.tva_tx, pfp.default_vat_code, pfp.info_bits as fourn_tva_npr, pfp.fk_availability,";
691 $sql .=
" pfp.fk_soc, pfp.ref_fourn, pfp.desc_fourn, pfp.fk_product, pfp.charges, pfp.fk_supplier_price_expression, pfp.delivery_time_days,";
692 $sql .=
" pfp.supplier_reputation, pfp.fk_user, pfp.datec,";
693 $sql .=
" pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code,";
694 $sql .=
" pfp.barcode, pfp.fk_barcode_type, pfp.packaging,";
695 $sql .=
" p.ref as product_ref, p.tosell as status, p.tobuy as status_buy";
696 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product_fournisseur_price as pfp, ".MAIN_DB_PREFIX.
"product as p";
697 $sql .=
" WHERE pfp.rowid = ".(int) $rowid;
698 $sql .=
" AND pfp.fk_product = p.rowid";
700 dol_syslog(get_class($this).
"::fetch_product_fournisseur_price", LOG_DEBUG);
701 $resql = $this->db->query($sql);
703 $obj = $this->db->fetch_object($resql);
705 $this->product_fourn_price_id = $rowid;
706 $this->
id = $obj->fk_product;
708 $this->fk_product = $obj->fk_product;
709 $this->product_id = $obj->fk_product;
710 $this->product_ref = $obj->product_ref;
711 $this->
status = $obj->status;
712 $this->status_buy = $obj->status_buy;
713 $this->fourn_id = $obj->fk_soc;
714 $this->fourn_ref = $obj->ref_fourn;
715 $this->ref_supplier = $obj->ref_fourn;
716 $this->desc_supplier = $obj->desc_fourn;
717 $this->fourn_price = $obj->price;
718 $this->fourn_charges = $obj->charges;
719 $this->fourn_qty = $obj->quantity;
720 $this->fourn_remise_percent = $obj->remise_percent;
721 $this->fourn_remise = $obj->remise;
722 $this->fourn_unitprice = $obj->unitprice;
723 $this->fourn_tva_tx = $obj->tva_tx;
724 $this->fourn_tva_npr = $obj->fourn_tva_npr;
726 $this->fk_availability = $obj->fk_availability;
727 $this->delivery_time_days = $obj->delivery_time_days;
728 $this->fk_supplier_price_expression = $obj->fk_supplier_price_expression;
729 $this->supplier_reputation = $obj->supplier_reputation;
730 $this->default_vat_code = $obj->default_vat_code;
731 $this->user_id = $obj->fk_user;
732 $this->date_creation = $this->db->jdate($obj->datec);
733 $this->fourn_multicurrency_price = $obj->multicurrency_price;
734 $this->fourn_multicurrency_unitprice = $obj->multicurrency_unitprice;
735 $this->fourn_multicurrency_tx = $obj->multicurrency_tx;
736 $this->fourn_multicurrency_id = $obj->fk_multicurrency;
737 $this->fourn_multicurrency_code = $obj->multicurrency_code;
738 if (isModEnabled(
'barcode')) {
739 $this->fourn_barcode = $obj->barcode;
740 $this->fourn_fk_barcode_type = $obj->fk_barcode_type;
741 $this->supplier_barcode = $obj->barcode;
742 $this->supplier_fk_barcode_type = $obj->fk_barcode_type;
744 $this->packaging = $obj->packaging;
746 if (isModEnabled(
'dynamicprices') && empty($ignore_expression) && !empty($this->fk_supplier_price_expression)) {
747 require_once DOL_DOCUMENT_ROOT.
'/product/dynamic_price/class/price_parser.class.php';
749 $price_result = $priceparser->parseProductSupplier($this);
750 if ($price_result >= 0) {
751 $this->fourn_price = $price_result;
753 if ($this->fourn_qty != 0) {
754 $this->fourn_unitprice =
price2num($this->fourn_price / $this->fourn_qty,
'MU');
756 $this->fourn_unitprice =
"";
766 $this->error = $this->db->lasterror();
790 $sql =
"SELECT s.nom as supplier_name, s.rowid as fourn_id, p.ref as product_ref, p.tosell as status, p.tobuy as status_buy, ";
791 $sql .=
" pfp.rowid as product_fourn_pri_id, pfp.entity, pfp.ref_fourn, pfp.desc_fourn, pfp.fk_product as product_fourn_id, pfp.fk_supplier_price_expression,";
792 $sql .=
" pfp.price, pfp.quantity, pfp.unitprice, pfp.remise_percent, pfp.remise, pfp.tva_tx, pfp.fk_availability, pfp.charges, pfp.info_bits, pfp.delivery_time_days, pfp.supplier_reputation,";
793 $sql .=
" pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code, pfp.datec, pfp.tms,";
794 $sql .=
" pfp.barcode, pfp.fk_barcode_type, pfp.packaging, pfp.status as pfstatus";
795 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product_fournisseur_price as pfp, ".MAIN_DB_PREFIX.
"product as p, ".MAIN_DB_PREFIX.
"societe as s";
796 $sql .=
" WHERE pfp.entity IN (".getEntity(
'productsupplierprice').
")";
797 $sql .=
" AND pfp.fk_soc = s.rowid AND pfp.fk_product = p.rowid";
798 $sql .= ($socid > 0 ?
' AND pfp.fk_soc = '.((int) $socid) :
'');
799 $sql .=
" AND s.status = 1";
800 $sql .=
" AND pfp.fk_product = ".((int) $prodid);
801 if (empty($sortfield)) {
802 $sql .=
" ORDER BY s.nom, pfp.quantity, pfp.price";
804 $sql .= $this->db->order($sortfield, $sortorder);
806 $sql .= $this->db->plimit($limit, $offset);
807 dol_syslog(get_class($this).
"::list_product_fournisseur_price", LOG_DEBUG);
809 $resql = $this->db->query($sql);
813 while ($record = $this->db->fetch_array($resql)) {
817 $prodfourn->product_ref = $record[
"product_ref"];
818 $prodfourn->product_fourn_price_id = $record[
"product_fourn_pri_id"];
819 $prodfourn->status = $record[
"status"];
820 $prodfourn->status_buy = $record[
"status_buy"];
821 $prodfourn->product_fourn_id = $record[
"product_fourn_id"];
822 $prodfourn->product_fourn_entity = $record[
"entity"];
823 $prodfourn->ref_supplier = $record[
"ref_fourn"];
824 $prodfourn->fourn_ref = $record[
"ref_fourn"];
825 $prodfourn->desc_supplier = $record[
"desc_fourn"];
826 $prodfourn->fourn_price = $record[
"price"];
827 $prodfourn->fourn_qty = $record[
"quantity"];
828 $prodfourn->fourn_remise_percent = $record[
"remise_percent"];
829 $prodfourn->fourn_remise = $record[
"remise"];
830 $prodfourn->fourn_unitprice = $record[
"unitprice"];
831 $prodfourn->fourn_charges = $record[
"charges"];
832 $prodfourn->fourn_tva_tx = $record[
"tva_tx"];
833 $prodfourn->fourn_id = $record[
"fourn_id"];
834 $prodfourn->fourn_name = $record[
"supplier_name"];
835 $prodfourn->fk_availability = $record[
"fk_availability"];
836 $prodfourn->delivery_time_days = $record[
"delivery_time_days"];
837 $prodfourn->id = $prodid;
838 $prodfourn->fourn_tva_npr = $record[
"info_bits"];
839 $prodfourn->fk_supplier_price_expression = $record[
"fk_supplier_price_expression"];
840 $prodfourn->supplier_reputation = $record[
"supplier_reputation"];
841 $prodfourn->fourn_date_creation = $this->db->jdate($record[
'datec']);
842 $prodfourn->fourn_date_modification = $this->db->jdate($record[
'tms']);
844 $prodfourn->fourn_multicurrency_price = $record[
"multicurrency_price"];
845 $prodfourn->fourn_multicurrency_unitprice = $record[
"multicurrency_unitprice"];
846 $prodfourn->fourn_multicurrency_tx = $record[
"multicurrency_tx"];
847 $prodfourn->fourn_multicurrency_id = $record[
"fk_multicurrency"];
848 $prodfourn->fourn_multicurrency_code = $record[
"multicurrency_code"];
850 $prodfourn->packaging = $record[
"packaging"];
851 $prodfourn->status = $record[
"pfstatus"];
853 if (isModEnabled(
'barcode')) {
854 $prodfourn->supplier_barcode = $record[
"barcode"];
855 $prodfourn->supplier_fk_barcode_type = $record[
"fk_barcode_type"];
858 if (isModEnabled(
'dynamicprices') && !empty($prodfourn->fk_supplier_price_expression)) {
859 require_once DOL_DOCUMENT_ROOT.
'/product/dynamic_price/class/price_parser.class.php';
861 $price_result = $priceparser->parseProductSupplier($prodfourn);
862 if ($price_result >= 0) {
863 $prodfourn->fourn_price = $price_result;
864 $prodfourn->fourn_unitprice =
null;
868 if (!isset($prodfourn->fourn_unitprice)) {
869 if ($prodfourn->fourn_qty != 0) {
870 $prodfourn->fourn_unitprice =
price2num($prodfourn->fourn_price / $prodfourn->fourn_qty,
'MU');
872 $prodfourn->fourn_unitprice =
"";
876 $retarray[] = $prodfourn;
879 $this->db->free($resql);
882 $this->error = $this->db->error();
900 if (empty($prodid)) {
901 dol_syslog(
"Warning function find_min_price_product_fournisseur were called with prodid empty. May be a bug.", LOG_WARNING);
905 $this->product_fourn_price_id = 0;
906 $this->product_fourn_id = 0;
907 $this->fourn_ref =
'';
908 $this->fourn_price = 0;
909 $this->fourn_qty = 0;
910 $this->fourn_remise_percent = 0;
911 $this->fourn_remise = 0;
912 $this->fourn_unitprice = 0;
914 $this->fourn_name =
'';
915 $this->delivery_time_days = 0;
918 $this->fourn_multicurrency_price = 0;
919 $this->fourn_multicurrency_unitprice = 0;
920 $this->fourn_multicurrency_tx = 0;
921 $this->fourn_multicurrency_id = 0;
922 $this->fourn_multicurrency_code =
'';
924 $sql =
"SELECT s.nom as supplier_name, s.rowid as fourn_id,";
925 $sql .=
" pfp.rowid as product_fourn_price_id, pfp.ref_fourn,";
926 $sql .=
" pfp.price, pfp.quantity, pfp.unitprice, pfp.tva_tx, pfp.charges,";
927 $sql .=
" pfp.remise, pfp.remise_percent, pfp.fk_supplier_price_expression, pfp.delivery_time_days,";
928 $sql .=
" pfp.multicurrency_price, pfp.multicurrency_unitprice, pfp.multicurrency_tx, pfp.fk_multicurrency, pfp.multicurrency_code";
929 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s, ".MAIN_DB_PREFIX.
"product_fournisseur_price as pfp";
930 $sql .=
" WHERE s.entity IN (".getEntity(
'societe').
")";
931 $sql .=
" AND pfp.entity IN (".getEntity(
'productsupplierprice').
")";
932 $sql .=
" AND pfp.fk_product = ".((int) $prodid);
933 $sql .=
" AND pfp.fk_soc = s.rowid";
934 $sql .=
" AND s.status = 1";
936 $sql .=
" AND pfp.quantity <= ".((float) $qty);
939 $sql .=
' AND pfp.fk_soc = '.((int) $socid);
942 dol_syslog(get_class($this).
"::find_min_price_product_fournisseur", LOG_DEBUG);
944 $resql = $this->db->query($sql);
946 $record_array = array();
949 while ($record = $this->db->fetch_array($resql)) {
950 $record_array[] = $record;
953 if (count($record_array) == 0) {
954 $this->db->free($resql);
958 foreach ($record_array as $record) {
959 $fourn_price = $record[
"price"];
961 $fourn_unitprice = $record[
"unitprice"];
962 $fourn_unitprice_with_discount = $record[
"unitprice"] * (1 - $record[
"remise_percent"] / 100);
964 if (isModEnabled(
'dynamicprices') && !empty($record[
"fk_supplier_price_expression"])) {
966 $prod_supplier->product_fourn_price_id = $record[
"product_fourn_price_id"];
967 $prod_supplier->id = $prodid;
968 $prod_supplier->fourn_qty = $record[
"quantity"];
969 $prod_supplier->fourn_tva_tx = $record[
"tva_tx"];
970 $prod_supplier->fk_supplier_price_expression = $record[
"fk_supplier_price_expression"];
972 require_once DOL_DOCUMENT_ROOT.
'/product/dynamic_price/class/price_parser.class.php';
974 $price_result = $priceparser->parseProductSupplier($prod_supplier);
975 if ($price_result >= 0) {
976 $fourn_price =
price2num($price_result,
'MU');
977 if ($record[
"quantity"] != 0) {
978 $fourn_unitprice =
price2num((
float) $fourn_price / $record[
"quantity"],
'MU');
980 $fourn_unitprice = $fourn_price;
982 $fourn_unitprice_with_discount = (float) $fourn_unitprice * (1 - $record[
"remise_percent"] / 100);
986 if ($fourn_unitprice < $min || $min == -1) {
988 $this->product_fourn_price_id = $record[
"product_fourn_price_id"];
989 $this->ref_supplier = $record[
"ref_fourn"];
990 $this->ref_fourn = $record[
"ref_fourn"];
991 $this->fourn_ref = $record[
"ref_fourn"];
992 $this->fourn_price = $fourn_price;
993 $this->fourn_qty = $record[
"quantity"];
994 $this->fourn_remise_percent = $record[
"remise_percent"];
995 $this->fourn_remise = $record[
"remise"];
996 $this->fourn_unitprice = $fourn_unitprice;
997 $this->fourn_unitprice_with_discount = $fourn_unitprice_with_discount;
998 $this->fourn_charges = $record[
"charges"];
999 $this->fourn_tva_tx = $record[
"tva_tx"];
1000 $this->fourn_id = $record[
"fourn_id"];
1001 $this->fourn_name = $record[
"supplier_name"];
1002 $this->delivery_time_days = $record[
"delivery_time_days"];
1003 $this->fk_supplier_price_expression = $record[
"fk_supplier_price_expression"];
1004 $this->fourn_multicurrency_price = $record[
"multicurrency_price"];
1005 $this->fourn_multicurrency_unitprice = $record[
"multicurrency_unitprice"];
1006 $this->fourn_multicurrency_tx = $record[
"multicurrency_tx"];
1007 $this->fourn_multicurrency_id = $record[
"fk_multicurrency"];
1008 $this->fourn_multicurrency_code = $record[
"multicurrency_code"];
1010 $min = $fourn_unitprice;
1015 $this->db->free($resql);
1017 return $this->product_fourn_price_id;
1019 $this->error = $this->db->error();
1036 $expression_id = $expression_id != 0 ? $expression_id :
'NULL';
1038 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"product_fournisseur_price";
1039 $sql .=
" SET fk_supplier_price_expression = ".((int) $expression_id);
1040 $sql .=
" WHERE rowid = ".((int) $this->product_fourn_price_id);
1042 dol_syslog(get_class($this).
"::setSupplierPriceExpression", LOG_DEBUG);
1044 $resql = $this->db->query($sql);
1046 $this->db->commit();
1049 $this->error = $this->db->error().
" sql=".$sql;
1050 $this->db->rollback();
1065 public function getSocNomUrl($withpicto = 0, $option =
'supplier', $maxlen = 0, $notooltip = 0)
1068 $thirdparty->fetch($this->fourn_id);
1070 return $thirdparty->getNomUrl($withpicto, $option, $maxlen, $notooltip);
1088 global $conf, $langs;
1091 $langs->load(
"suppliers");
1092 if (count($productFournList) > 0) {
1093 $out .=
'<table class="nobordernopadding" width="100%">';
1094 $out .=
'<tr><td class="liste_titre right">'.($showunitprice ? $langs->trans(
"Price").
' '.$langs->trans(
"HT") :
'').
'</td>';
1095 $out .=
'<td class="liste_titre right">'.($showunitprice ? $langs->trans(
"QtyMin") :
'').
'</td>';
1096 $out .=
'<td class="liste_titre">'.$langs->trans(
"Supplier").
'</td>';
1097 $out .=
'<td class="liste_titre">'.$langs->trans(
"SupplierRef").
'</td></tr>';
1098 foreach ($productFournList as $productFourn) {
1099 $out .=
'<tr><td class="right">'.($showunitprice ?
price($productFourn->fourn_unitprice * (1 - $productFourn->fourn_remise_percent / 100) - $productFourn->fourn_remise) :
'').
'</td>';
1100 $out .=
'<td class="right">'.($showunitprice ? $productFourn->fourn_qty :
'').
'</td>';
1101 $out .=
'<td>'.$productFourn->getSocNomUrl(1,
'supplier', $maxlen, $notooltip).
'</td>';
1102 $out .=
'<td>'.$productFourn->fourn_ref.
'<td></tr>';
1106 $out = ($showunitprice ?
price($this->fourn_unitprice * (1 - $this->fourn_remise_percent / 100) + $this->fourn_remise, 0, $langs, 1, -1, -1, $conf->currency).
' '.$langs->trans(
"HT").
' <span class="opacitymedium">(</span>' :
'');
1107 $out .= ($showsuptitle ?
'<span class="opacitymedium">'.$langs->trans(
"Supplier").
'</span>: ' :
'').$this->
getSocNomUrl(1,
'supplier', $maxlen, $notooltip).
' / <span class="opacitymedium">'.$langs->trans(
"SupplierRef").
'</span>: '.$this->ref_supplier;
1108 $out .= ($showunitprice ?
'<span class="opacitymedium">)</span>' :
'');
1124 'product_fournisseur_price'
1141 'product_fournisseur_price'
1160 $sql .=
" u.lastname,";
1161 $sql .=
" pfpl.rowid, pfp.ref_fourn as supplier_ref, pfpl.datec,";
1162 $sql .=
" pfpl.price, pfpl.quantity,";
1163 $sql .=
" pfpl.fk_multicurrency, pfpl.multicurrency_code, pfpl.multicurrency_tx, pfpl.multicurrency_price, pfpl.multicurrency_unitprice";
1164 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product_fournisseur_price_log as pfpl,";
1165 $sql .=
" ".MAIN_DB_PREFIX.
"product_fournisseur_price as pfp,";
1166 $sql .=
" ".MAIN_DB_PREFIX.
"user as u";
1167 $sql .=
" WHERE pfp.entity IN (".getEntity(
'productprice').
")";
1168 $sql .=
" AND pfpl.fk_user = u.rowid";
1169 $sql .=
" AND pfp.rowid = pfpl.fk_product_fournisseur";
1170 $sql .=
" AND pfpl.fk_product_fournisseur = ".((int) $product_fourn_price_id);
1171 if (empty($sortfield)) {
1172 $sql .=
" ORDER BY pfpl.datec";
1174 $sql .= $this->db->order($sortfield, $sortorder);
1176 $sql .= $this->db->plimit($limit, $offset);
1177 dol_syslog(get_class($this).
"::list_product_fournisseur_price_log", LOG_DEBUG);
1179 $resql = $this->db->query($sql);
1181 $retarray = array();
1183 while ($obj = $this->db->fetch_object($resql)) {
1184 $tmparray = array();
1185 $tmparray[
'rowid'] = $obj->rowid;
1186 $tmparray[
'supplier_ref'] = $obj->supplier_ref;
1187 $tmparray[
'datec'] = $this->db->jdate($obj->datec);
1188 $tmparray[
'lastname'] = $obj->lastname;
1189 $tmparray[
'price'] = $obj->price;
1190 $tmparray[
'quantity'] = $obj->quantity;
1191 $tmparray[
'fk_multicurrency'] = $obj->fk_multicurrency;
1192 $tmparray[
'multicurrency_code'] = $obj->multicurrency_code;
1193 $tmparray[
'multicurrency_tx'] = $obj->multicurrency_tx;
1194 $tmparray[
'multicurrency_price'] = $obj->multicurrency_price;
1195 $tmparray[
'multicurrency_unitprice'] = $obj->multicurrency_unitprice;
1197 $retarray[] = $tmparray;
1200 $this->db->free($resql);
1203 $this->error = $this->db->error();
1217 global $conf, $langs;
1220 $langs->load(
"suppliers");
1221 if (count($productFournLogList) > 0) {
1222 $out .=
'<table class="noborder centpercent">';
1223 $out .=
'<tr class="liste_titre"><td class="liste_titre">'.$langs->trans(
"Date").
'</td>';
1224 $out .=
'<td class="liste_titre right">'.$langs->trans(
"Price").
'</td>';
1226 $out .=
'<td class="liste_titre">'.$langs->trans(
"User").
'</td></tr>';
1227 foreach ($productFournLogList as $productFournLog) {
1228 $out .=
'<tr><td>'.dol_print_date($productFournLog[
'datec'],
'dayhour',
'tzuser').
'</td>';
1229 $out .=
'<td class="right">'.price($productFournLog[
'price'], 0, $langs, 1, -1, -1, $conf->currency);
1230 if ($productFournLog[
'multicurrency_code'] != $conf->currency) {
1231 $out .=
' ('.price($productFournLog[
'multicurrency_price'], 0, $langs, 1, -1, -1, $productFournLog[
'multicurrency_code']).
')';
1235 $out .=
'<td>'.$productFournLog[
'lastname'].
'</td></tr>';
1257 public function getNomUrl($withpicto = 0, $option =
'', $maxlength = 0, $save_lastsearch_value = -1, $notooltip = 0, $morecss =
'', $add_label = 0, $sep =
' - ')
1259 global $db, $conf, $langs, $hookmanager;
1261 if (!empty($conf->dol_no_mouse_hover)) {
1268 $newref = $this->ref;
1270 $newref =
dol_trunc($newref, $maxlength,
'middle');
1273 if (!empty($this->entity)) {
1274 $tmpphoto = $this->
show_photos(
'product', $conf->product->multidir_output[$this->entity], 1, 1, 0, 0, 0, 80);
1275 if ($this->nbphoto > 0) {
1276 $label .=
'<div class="photointooltip">';
1277 $label .= $tmpphoto;
1278 $label .=
'</div><div style="clear: both;"></div>';
1283 $label .=
img_picto(
'',
'product').
' <u class="paddingrightonly">'.$langs->trans(
"Product").
'</u>';
1285 $label .=
img_picto(
'',
'service').
' <u class="paddingrightonly">'.$langs->trans(
"Service").
'</u>';
1287 if (isset($this->
status) && isset($this->status_buy)) {
1288 $label .=
' '.$this->getLibStatut(5, 0);
1289 $label .=
' '.$this->getLibStatut(5, 1);
1292 if (!empty($this->
ref)) {
1293 $label .=
'<br><b>'.$langs->trans(
'ProductRef').
':</b> '.($this->
ref ? $this->
ref : $this->product_ref);
1295 if (!empty($this->label)) {
1296 $label .=
'<br><b>'.$langs->trans(
'ProductLabel').
':</b> '.$this->label;
1298 $label .=
'<br><b>'.$langs->trans(
'RefSupplier').
':</b> '.$this->ref_supplier;
1301 if (isModEnabled(
'productbatch')) {
1302 $langs->load(
"productbatch");
1303 $label .=
"<br><b>".$langs->trans(
"ManageLotSerial").
'</b>: '.$this->
getLibStatut(0, 2);
1306 if (isModEnabled(
'barcode')) {
1307 $label .=
'<br><b>'.$langs->trans(
'BarCode').
':</b> '.$this->barcode;
1311 if ($this->weight) {
1312 $label .=
"<br><b>".$langs->trans(
"Weight").
'</b>: '.$this->weight.
' '.
measuringUnitString(0,
"weight", $this->weight_units);
1315 if ($this->length) {
1316 $labelsize .= ($labelsize ?
" - " :
"").
"<b>".$langs->trans(
"Length").
'</b>: '.$this->length.
' '.
measuringUnitString(0,
'size', $this->length_units);
1319 $labelsize .= ($labelsize ?
" - " :
"").
"<b>".$langs->trans(
"Width").
'</b>: '.$this->width.
' '.
measuringUnitString(0,
'size', $this->width_units);
1321 if ($this->height) {
1322 $labelsize .= ($labelsize ?
" - " :
"").
"<b>".$langs->trans(
"Height").
'</b>: '.$this->height.
' '.
measuringUnitString(0,
'size', $this->height_units);
1325 $label .=
"<br>".$labelsize;
1328 $labelsurfacevolume =
"";
1329 if ($this->surface) {
1330 $labelsurfacevolume .= ($labelsurfacevolume ?
" - " :
"").
"<b>".$langs->trans(
"Surface").
'</b>: '.$this->surface.
' '.
measuringUnitString(0,
'surface', $this->surface_units);
1332 if ($this->volume) {
1333 $labelsurfacevolume .= ($labelsurfacevolume ?
" - " :
"").
"<b>".$langs->trans(
"Volume").
'</b>: '.$this->volume.
' '.
measuringUnitString(0,
'volume', $this->volume_units);
1335 if ($labelsurfacevolume) {
1336 $label .=
"<br>".$labelsurfacevolume;
1340 if (isModEnabled(
'accounting') && $this->
status) {
1341 include_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
1342 $label .=
'<br><b>'.$langs->trans(
'ProductAccountancySellCode').
':</b> '.
length_accountg($this->accountancy_code_sell);
1343 $label .=
'<br><b>'.$langs->trans(
'ProductAccountancySellIntraCode').
':</b> '.
length_accountg($this->accountancy_code_sell_intra);
1344 $label .=
'<br><b>'.$langs->trans(
'ProductAccountancySellExportCode').
':</b> '.
length_accountg($this->accountancy_code_sell_export);
1346 if (isModEnabled(
'accounting') && $this->status_buy) {
1347 include_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
1348 $label .=
'<br><b>'.$langs->trans(
'ProductAccountancyBuyCode').
':</b> '.
length_accountg($this->accountancy_code_buy);
1349 $label .=
'<br><b>'.$langs->trans(
'ProductAccountancyBuyIntraCode').
':</b> '.
length_accountg($this->accountancy_code_buy_intra);
1350 $label .=
'<br><b>'.$langs->trans(
'ProductAccountancyBuyExportCode').
':</b> '.
length_accountg($this->accountancy_code_buy_export);
1354 if (is_array($logPrices) && count($logPrices) > 0) {
1355 $label .=
'<br><br>';
1356 $label .=
'<u>'.$langs->trans(
"History").
'</u>';
1360 $url = DOL_URL_ROOT.
'/product/price_suppliers.php?id='.((int) $this->
id).
'&action=create_price&token='.
newToken().
'&socid='.((int) $this->fourn_id).
'&rowid='.((int) $this->product_fourn_price_id);
1362 if ($option !=
'nolink') {
1364 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
1365 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
1366 $add_save_lastsearch_values = 1;
1368 if ($add_save_lastsearch_values) {
1369 $url .=
'&save_lastsearch_values=1';
1374 if (empty($notooltip)) {
1376 $label = $langs->trans(
"SupplierRef");
1377 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1).
'"';
1379 $linkclose .=
' title="'.dol_escape_htmltag($label, 1).
'"';
1380 $linkclose .=
' class="classfortooltip'.($morecss ?
' '.$morecss :
'').
'"';
1382 $linkclose = ($morecss ?
' class="'.$morecss.
'"' :
'');
1385 $linkstart =
'<a href="'.$url.
'"';
1386 $linkstart .= $linkclose.
'>';
1389 $result .= $linkstart;
1391 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), ($notooltip ? (($withpicto != 2) ?
'class="paddingright"' :
'') :
'class="'.(($withpicto != 2) ?
'paddingright ' :
'').
'classfortooltip"'), 0, 0, $notooltip ? 0 : 1);
1393 if ($withpicto != 2) {
1394 $result .= $newref.($this->ref_supplier ?
' ('.$this->ref_supplier.
')' :
'');
1396 $result .= $linkend;
1397 if ($withpicto != 2) {
1398 $result .= (($add_label && $this->label) ? $sep.dol_trunc($this->label, ($add_label > 1 ? $add_label : 0)) :
'');
1402 $hookmanager->initHooks(array($this->element .
'dao'));
1403 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
1404 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
1406 $result = $hookmanager->resPrint;
1408 $result .= $hookmanager->resPrint;
1437 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
1440 $this->labelStatus[self::STATUS_OPEN] = $langs->transnoentitiesnoconv(
'Enabled');
1441 $this->labelStatus[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv(
'Disabled');
1442 $this->labelStatusShort[self::STATUS_OPEN] = $langs->transnoentitiesnoconv(
'Enabled');
1443 $this->labelStatusShort[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv(
'Disabled');
1446 $statusType =
'status4';
1448 if ($status == self::STATUS_CANCELED) {
1449 $statusType =
'status6';
1452 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusType, $mode);
1470 private function logPrice($user, $datec, $buyprice, $qty, $multicurrency_buyprice =
null, $multicurrency_unitBuyPrice =
null, $multicurrency_tx =
null, $fk_multicurrency =
null, $multicurrency_code =
null)
1473 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"product_fournisseur_price_log(";
1474 $sql .=
" multicurrency_price, multicurrency_unitprice, multicurrency_tx, fk_multicurrency, multicurrency_code,";
1475 $sql .=
"datec, fk_product_fournisseur,fk_user,price,quantity)";
1477 $sql .= (isset($multicurrency_buyprice) ?
"'".$this->db->escape(
price2num($multicurrency_buyprice)).
"'" :
'null').
",";
1478 $sql .= (isset($multicurrency_unitBuyPrice) ?
"'".$this->db->escape(
price2num($multicurrency_unitBuyPrice)).
"'" :
'null').
",";
1479 $sql .= (isset($multicurrency_tx) ?
"'".$this->db->escape($multicurrency_tx).
"'" :
'1').
",";
1480 $sql .= (isset($fk_multicurrency) ?
"'".$this->db->escape($fk_multicurrency).
"'" :
'null').
",";
1481 $sql .= (isset($multicurrency_code) ?
"'".$this->db->escape($multicurrency_code).
"'" :
'null').
",";
1482 $sql .=
"'".$this->db->idate($datec).
"',";
1483 $sql .=
" ".((int) $this->product_fourn_price_id).
",";
1484 $sql .=
" ".$user->id.
",";
1485 $sql .=
" ".price2num($buyprice).
",";
1486 $sql .=
" ".price2num($qty);
1489 $resql = $this->db->query($sql);
length_accountg($account)
Return General accounting account with defined length (used for product and miscellaneous)
print $langs trans("AuditedSecurityEvents").'</strong >< span class="opacitymedium"></span >< br > status
Or an array listing all the potential status of the object: array: int of the status => translated la...
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
show_photos($modulepart, $sdir, $size=0, $nbmax=0, $nbbyrow=5, $showfilename=0, $showaction=0, $maxHeight=120, $maxWidth=160, $nolink=0, $overwritetitle=0, $usesharelink=0, $cache='', $addphotorefcss='photoref')
Show photos of an object (nbmax maximum), into several columns.
static commonReplaceProduct(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a product id with another one.
call_trigger($triggerName, $user)
Call trigger based on this instance.
Class to manage Dolibarr database access.
Class to manage suppliers.
static getIdFromCode($dbs, $code)
Get id of currency from code.
Class to parse product price expressions.
Class to manage predefined suppliers products.
displayPriceProductFournisseurLog($productFournLogList=array())
Display log price of product supplier price.
listProductFournisseurPriceLog($product_fourn_price_id, $sortfield='', $sortorder='', $limit=0, $offset=0)
List supplier prices log of a supplier price.
getSocNomUrl($withpicto=0, $option='supplier', $maxlen=0, $notooltip=0)
Display supplier of product.
LibStatut($status, $mode=0, $type=0)
Return the status.
logPrice($user, $datec, $buyprice, $qty, $multicurrency_buyprice=null, $multicurrency_unitBuyPrice=null, $multicurrency_tx=null, $fk_multicurrency=null, $multicurrency_code=null)
Private function to log price history.
setSupplierPriceExpression($expression_id)
Sets the supplier price expression.
__construct($db)
Constructor.
find_min_price_product_fournisseur($prodid, $qty=0, $socid=0)
Load properties for minimum price.
list_product_fournisseur_price($prodid, $sortfield='', $sortorder='', $limit=0, $offset=0, $socid=0)
List all supplier prices of a product.
fetch_product_fournisseur_price($rowid, $ignore_expression=0)
Loads the price information of a provider.
remove_fournisseur($id_fourn)
Remove all prices for this couple supplier-product.
getNomUrl($withpicto=0, $option='', $maxlength=0, $save_lastsearch_value=-1, $notooltip=0, $morecss='', $add_label=0, $sep=' - ')
Return a link to the object card (with optionally the picto).
getLibStatut($mode=0, $type=0)
Return the label of the status.
remove_product_fournisseur_price($rowid)
Remove a price for a couple supplier-product.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
static replaceProduct(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a product id with another one.
update_buyprice( $qty, $buyprice, $user, $price_base_type, $fourn, $availability, $ref_fourn, $tva_tx, $charges=0, $remise_percent=0, $remise=0, $newnpr=0, $delivery_time_days=0, $supplier_reputation='', $localtaxes_array=array(), $newdefaultvatcode='', $multicurrency_buyprice=0, $multicurrency_price_base_type='HT', $multicurrency_tx=1, $multicurrency_code='', $desc_fourn='', $barcode='', $fk_barcode_type=0, $options=array())
Modify the purchase price for a supplier.
display_price_product_fournisseur($showunitprice=1, $showsuptitle=1, $maxlen=0, $notooltip=0, $productFournList=array())
Display price of product.
Class for ProductFournisseurPrice.
Class to manage products or services.
const TYPE_PRODUCT
Regular product.
const TYPE_SERVICE
Service.
Class to manage Dolibarr users.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
dol_now($mode='auto')
Return date for now.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
dol_trunc($string, $size=40, $trunc='right', $stringencoding='UTF-8', $nodot=0, $display=0)
Truncate a string to a particular length adding '…' if string larger than length.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
get_localtax($vatrate, $local, $thirdparty_buyer=null, $thirdparty_seller=null, $vatnpr=0)
Return localtax rate for a particular vat, when selling a product with vat $vatrate,...
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
measuringUnitString($unit, $measuring_style='', $scale='', $use_short_label=0, $outputlangs=null)
Return translation label of a unit key.
if(preg_match('/crypted:/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type