39require_once DOL_DOCUMENT_ROOT.
'/core/class/commonorder.class.php';
40require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
41require_once DOL_DOCUMENT_ROOT.
'/multicurrency/class/multicurrency.class.php';
42if (isModEnabled(
'productbatch')) {
43 require_once DOL_DOCUMENT_ROOT.
'/product/class/productbatch.class.php';
55 public $element =
'order_supplier';
60 public $table_element =
'commande_fournisseur';
65 public $table_element_line =
'commande_fournisseurdet';
70 public $fk_element =
'fk_commande';
75 public $picto =
'supplier_order';
81 public $restrictiononfksoc = 1;
101 public $ref_supplier;
139 public $date_creation;
149 public $date_approve;
155 public $date_approve2;
160 public $date_commande;
163 public $remise_percent;
164 public $methode_commande_id;
165 public $methode_commande;
170 public $delivery_date;
185 public $total_localtax1;
190 public $total_localtax2;
207 public $cond_reglement_id;
212 public $cond_reglement_code;
217 public $cond_reglement_label;
222 public $cond_reglement_doc;
232 public $mode_reglement_id;
237 public $mode_reglement_code;
242 public $mode_reglement;
247 public $user_author_id;
252 public $user_approve_id;
258 public $user_approve_id2;
262 public $extraparams = array();
267 public $lines = array();
277 public $linked_objects = array();
282 public $date_lim_reglement;
283 public $receptions = array();
289 public $fk_multicurrency;
294 public $multicurrency_code;
299 public $multicurrency_tx;
304 public $multicurrency_total_ht;
309 public $multicurrency_total_tva;
314 public $multicurrency_total_ttc;
344 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => 0,
'notnull' => 1,
'position' => 10),
345 'ref' => array(
'type' =>
'varchar(255)',
'label' =>
'Ref',
'enabled' => 1,
'visible' => 1,
'showoncombobox' => 1,
'position' => 25,
'searchall' => 1),
346 'ref_ext' => array(
'type' =>
'varchar(255)',
'label' =>
'Ref ext',
'enabled' => 1,
'visible' => 0,
'position' => 35),
347 'ref_supplier' => array(
'type' =>
'varchar(255)',
'label' =>
'RefOrderSupplierShort',
'enabled' => 1,
'visible' => 1,
'position' => 40,
'searchall' => 1),
348 'fk_projet' => array(
'type' =>
'integer:Project:projet/class/project.class.php:1:(fk_statut:=:1)',
'label' =>
'Project',
'enabled' =>
"isModEnabled('project')",
'visible' => -1,
'position' => 45),
349 'date_valid' => array(
'type' =>
'datetime',
'label' =>
'DateValidation',
'enabled' => 1,
'visible' => -1,
'position' => 710),
350 'date_approve' => array(
'type' =>
'datetime',
'label' =>
'DateApprove',
'enabled' => 1,
'visible' => -1,
'position' => 720),
351 'date_approve2' => array(
'type' =>
'datetime',
'label' =>
'DateApprove2',
'enabled' => 1,
'visible' => 3,
'position' => 725),
352 'date_commande' => array(
'type' =>
'date',
'label' =>
'OrderDateShort',
'enabled' => 1,
'visible' => 1,
'position' => 70),
353 'date_livraison' => array(
'type' =>
'datetime',
'label' =>
'DeliveryDate',
'enabled' =>
'empty($conf->global->ORDER_DISABLE_DELIVERY_DATE)',
'visible' => 1,
'position' => 74),
354 'fk_user_author' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserAuthor',
'enabled' => 1,
'visible' => 3,
'position' => 41),
355 'fk_user_modif' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserModif',
'enabled' => 1,
'visible' => 3,
'notnull' => -1,
'position' => 80),
356 'fk_user_valid' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserValidation',
'enabled' => 1,
'visible' => 3,
'position' => 711),
357 'fk_user_approve' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserApproval',
'enabled' => 1,
'visible' => 3,
'position' => 721),
358 'fk_user_approve2' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserApproval2',
'enabled' => 1,
'visible' => 3,
'position' => 726),
359 'source' => array(
'type' =>
'smallint(6)',
'label' =>
'Source',
'enabled' => 1,
'visible' => 3,
'notnull' => 1,
'position' => 100),
360 'billed' => array(
'type' =>
'smallint(6)',
'label' =>
'Billed',
'enabled' => 1,
'visible' => 1,
'position' => 710),
361 'total_ht' => array(
'type' =>
'double(24,8)',
'label' =>
'AmountHT',
'enabled' => 1,
'visible' => 1,
'position' => 130,
'isameasure' => 1),
362 'total_tva' => array(
'type' =>
'double(24,8)',
'label' =>
'AmountVAT',
'enabled' => 1,
'visible' => 1,
'position' => 135,
'isameasure' => 1),
363 'localtax1' => array(
'type' =>
'double(24,8)',
'label' =>
'LT1',
'enabled' => 1,
'visible' => 3,
'position' => 140,
'isameasure' => 1),
364 'localtax2' => array(
'type' =>
'double(24,8)',
'label' =>
'LT2',
'enabled' => 1,
'visible' => 3,
'position' => 145,
'isameasure' => 1),
365 'total_ttc' => array(
'type' =>
'double(24,8)',
'label' =>
'AmountTTC',
'enabled' => 1,
'visible' => -1,
'position' => 150,
'isameasure' => 1),
366 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 750,
'searchall' => 1),
367 'note_private' => array(
'type' =>
'html',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => 0,
'position' => 760,
'searchall' => 1),
368 'model_pdf' => array(
'type' =>
'varchar(255)',
'label' =>
'ModelPDF',
'enabled' => 1,
'visible' => 0,
'position' => 165),
369 'fk_input_method' => array(
'type' =>
'integer',
'label' =>
'OrderMode',
'enabled' => 1,
'visible' => 3,
'position' => 170),
370 'fk_cond_reglement' => array(
'type' =>
'integer',
'label' =>
'PaymentTerm',
'enabled' => 1,
'visible' => 3,
'position' => 175),
371 'fk_mode_reglement' => array(
'type' =>
'integer',
'label' =>
'PaymentMode',
'enabled' => 1,
'visible' => 3,
'position' => 180),
372 'extraparams' => array(
'type' =>
'varchar(255)',
'label' =>
'Extraparams',
'enabled' => 1,
'visible' => 0,
'position' => 190),
373 'fk_account' => array(
'type' =>
'integer',
'label' =>
'BankAccount',
'enabled' =>
'isModEnabled("bank")',
'visible' => 3,
'position' => 200),
374 'fk_incoterms' => array(
'type' =>
'integer',
'label' =>
'IncotermCode',
'enabled' => 1,
'visible' => 3,
'position' => 205),
375 'location_incoterms' => array(
'type' =>
'varchar(255)',
'label' =>
'IncotermLocation',
'enabled' => 1,
'visible' => 3,
'position' => 210),
376 'fk_multicurrency' => array(
'type' =>
'integer',
'label' =>
'Fk multicurrency',
'enabled' => 1,
'visible' => 0,
'position' => 215),
377 'multicurrency_code' => array(
'type' =>
'varchar(255)',
'label' =>
'Currency',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 220),
378 'multicurrency_tx' => array(
'type' =>
'double(24,8)',
'label' =>
'CurrencyRate',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 225),
379 'multicurrency_total_ht' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyAmountHT',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 230),
380 'multicurrency_total_tva' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyAmountVAT',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 235),
381 'multicurrency_total_ttc' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyAmountTTC',
'enabled' =>
'isModEnabled("multicurrency")',
'visible' => -1,
'position' => 240),
382 'date_creation' => array(
'type' =>
'datetime',
'label' =>
'Date creation',
'enabled' => 1,
'visible' => -1,
'position' => 500),
383 'fk_soc' => array(
'type' =>
'integer:Societe:societe/class/societe.class.php',
'label' =>
'ThirdParty',
'enabled' =>
'isModEnabled("societe")',
'visible' => 1,
'notnull' => 1,
'position' => 50),
384 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'default' =>
'1',
'enabled' => 1,
'visible' => 0,
'notnull' => 1,
'position' => 1000,
'index' => 1),
385 'tms' => array(
'type' =>
'datetime',
'label' =>
"DateModificationShort",
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 501),
386 'last_main_doc' => array(
'type' =>
'varchar(255)',
'label' =>
'LastMainDoc',
'enabled' => 1,
'visible' => 0,
'position' => 700),
387 'fk_statut' => array(
'type' =>
'smallint(6)',
'label' =>
'Status',
'enabled' => 1,
'visible' => 1,
'position' => 701),
388 'import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' => 1,
'visible' => 0,
'position' => 900),
452 $this->ismultientitymanaged = 1;
463 public function fetch($id, $ref =
'')
466 if (empty($id) && empty($ref)) {
470 $sql =
"SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut as status, c.amount_ht, c.total_ht, c.total_ttc, c.total_tva,";
471 $sql .=
" c.localtax1, c.localtax2, ";
472 $sql .=
" c.date_creation, c.date_valid, c.date_approve, c.date_approve2,";
473 $sql .=
" c.fk_user_author as user_author_id, c.fk_user_valid as user_validation_id, c.fk_user_approve as user_approve_id, c.fk_user_approve2 as user_approve_id2,";
474 $sql .=
" c.date_commande as date_commande, c.date_livraison as delivery_date, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method,";
475 $sql .=
" c.fk_account,";
476 $sql .=
" c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed,";
477 $sql .=
" c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc,";
478 $sql .=
" cm.libelle as methode_commande,";
479 $sql .=
" cr.code as cond_reglement_code, cr.libelle as cond_reglement_label, cr.libelle_facture as cond_reglement_doc,";
480 $sql .=
" p.code as mode_reglement_code, p.libelle as mode_reglement_libelle";
481 $sql .=
', c.fk_incoterms, c.location_incoterms';
482 $sql .=
', i.libelle as label_incoterms';
483 $sql .=
" FROM ".$this->db->prefix().
"commande_fournisseur as c";
484 $sql .=
" LEFT JOIN ".$this->db->prefix().
"c_payment_term as cr ON c.fk_cond_reglement = cr.rowid";
485 $sql .=
" LEFT JOIN ".$this->db->prefix().
"c_paiement as p ON c.fk_mode_reglement = p.id";
486 $sql .=
" LEFT JOIN ".$this->db->prefix().
"c_input_method as cm ON cm.rowid = c.fk_input_method";
487 $sql .=
' LEFT JOIN '.$this->db->prefix().
'c_incoterms as i ON c.fk_incoterms = i.rowid';
490 $sql .=
" WHERE c.entity IN (".getEntity(
'supplier_order').
")";
492 $sql .=
" WHERE c.rowid=".((int) $id);
496 $sql .=
" AND c.ref='".$this->db->escape($ref).
"'";
499 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
500 $resql = $this->db->query($sql);
502 $obj = $this->db->fetch_object($resql);
504 $this->error =
'Bill with id '.$id.
' not found';
505 dol_syslog(get_class($this).
'::fetch '.$this->error);
509 $this->
id = $obj->rowid;
510 $this->entity = $obj->entity;
512 $this->
ref = $obj->ref;
513 $this->ref_supplier = $obj->ref_supplier;
514 $this->socid = $obj->fk_soc;
515 $this->fourn_id = $obj->fk_soc;
516 $this->
statut = $obj->status;
517 $this->
status = $obj->status;
518 $this->billed = $obj->billed;
519 $this->user_author_id = $obj->user_author_id;
520 $this->user_validation_id = $obj->user_validation_id;
521 $this->user_approve_id = $obj->user_approve_id;
522 $this->user_approve_id2 = $obj->user_approve_id2;
523 $this->total_ht = $obj->total_ht;
524 $this->total_tva = $obj->total_tva;
525 $this->total_localtax1 = $obj->localtax1;
526 $this->total_localtax2 = $obj->localtax2;
527 $this->total_ttc = $obj->total_ttc;
528 $this->date_creation = $this->db->jdate($obj->date_creation);
529 $this->date_valid = $this->db->jdate($obj->date_valid);
530 $this->date_approve = $this->db->jdate($obj->date_approve);
531 $this->date_approve2 = $this->db->jdate($obj->date_approve2);
532 $this->date_commande = $this->db->jdate($obj->date_commande);
533 if (isset($obj->date_commande)) {
534 $this->date = $this->date_commande;
536 $this->date = $this->date_creation;
538 $this->delivery_date = $this->db->jdate($obj->delivery_date);
539 $this->remise_percent = $obj->remise_percent;
540 $this->methode_commande_id = $obj->fk_input_method;
541 $this->methode_commande = $obj->methode_commande;
543 $this->source = $obj->source;
544 $this->fk_project = $obj->fk_project;
545 $this->cond_reglement_id = $obj->fk_cond_reglement;
546 $this->cond_reglement_code = $obj->cond_reglement_code;
547 $this->cond_reglement = $obj->cond_reglement_label;
548 $this->cond_reglement_label = $obj->cond_reglement_label;
549 $this->cond_reglement_doc = $obj->cond_reglement_doc;
550 $this->fk_account = $obj->fk_account;
551 $this->mode_reglement_id = $obj->fk_mode_reglement;
552 $this->mode_reglement_code = $obj->mode_reglement_code;
553 $this->mode_reglement = $obj->mode_reglement_libelle;
554 $this->note = $obj->note_private;
555 $this->note_private = $obj->note_private;
556 $this->note_public = $obj->note_public;
557 $this->model_pdf = $obj->model_pdf;
560 $this->fk_incoterms = $obj->fk_incoterms;
561 $this->location_incoterms = $obj->location_incoterms;
562 $this->label_incoterms = $obj->label_incoterms;
565 $this->fk_multicurrency = $obj->fk_multicurrency;
566 $this->multicurrency_code = $obj->multicurrency_code;
567 $this->multicurrency_tx = $obj->multicurrency_tx;
568 $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
569 $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
570 $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
572 $this->extraparams = isset($obj->extraparams) ? (array) json_decode($obj->extraparams,
true) : array();
574 $this->db->free($resql);
589 $this->error = $this->db->error().
" sql=".$sql;
605 $this->lines = array();
607 $sql =
"SELECT l.rowid, l.fk_commande, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty,";
608 $sql .=
" l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice,";
609 $sql .=
" l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2,";
610 $sql .=
" l.total_ht, l.total_tva, l.total_ttc, l.info_bits, l.special_code, l.fk_parent_line, l.rang,";
611 $sql .=
" p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, p.tobatch as product_tobatch, p.barcode as product_barcode,";
612 $sql .=
" l.fk_unit,";
613 $sql .=
" l.date_start, l.date_end,";
614 $sql .=
' l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc';
615 $sql .=
" FROM ".$this->db->prefix().
"commande_fournisseurdet as l";
616 $sql .=
' LEFT JOIN '.$this->db->prefix().
'product as p ON l.fk_product = p.rowid';
617 $sql .=
" WHERE l.fk_commande = ".((int) $this->
id);
619 $sql .=
' AND p.fk_product_type = 0';
621 $sql .=
" ORDER BY l.rang, l.rowid";
624 dol_syslog(get_class($this).
"::fetch_lines", LOG_DEBUG);
626 $result = $this->db->query($sql);
628 $num = $this->db->num_rows($result);
632 $objp = $this->db->fetch_object($result);
636 $line->id = $objp->rowid;
637 $line->fk_commande = $objp->fk_commande;
638 $line->desc = $objp->description;
639 $line->description = $objp->description;
640 $line->qty = $objp->qty;
641 $line->tva_tx = $objp->tva_tx;
642 $line->localtax1_tx = $objp->localtax1_tx;
643 $line->localtax2_tx = $objp->localtax2_tx;
644 $line->localtax1_type = $objp->localtax1_type;
645 $line->localtax2_type = $objp->localtax2_type;
646 $line->subprice = $objp->subprice;
647 $line->pu_ht = $objp->subprice;
648 $line->remise_percent = $objp->remise_percent;
650 $line->vat_src_code = $objp->vat_src_code;
651 $line->total_ht = $objp->total_ht;
652 $line->total_tva = $objp->total_tva;
653 $line->total_localtax1 = $objp->total_localtax1;
654 $line->total_localtax2 = $objp->total_localtax2;
655 $line->total_ttc = $objp->total_ttc;
656 $line->product_type = $objp->product_type;
658 $line->fk_product = $objp->fk_product;
660 $line->libelle = $objp->product_label;
661 $line->product_label = $objp->product_label;
662 $line->product_desc = $objp->product_desc;
663 $line->product_tobatch = $objp->product_tobatch;
664 $line->product_barcode = $objp->product_barcode;
666 $line->ref = $objp->product_ref;
667 $line->product_ref = $objp->product_ref;
668 $line->ref_fourn = $objp->ref_supplier;
669 $line->ref_supplier = $objp->ref_supplier;
676 $sqlsearchpackage =
'SELECT rowid, packaging FROM '.$this->db->prefix().
"product_fournisseur_price";
677 $sqlsearchpackage .=
' WHERE entity IN ('.getEntity(
'product_fournisseur_price').
")";
678 $sqlsearchpackage .=
" AND fk_product = ".((int) $objp->fk_product);
679 $sqlsearchpackage .=
" AND ref_fourn = '".$this->db->escape($objp->ref_supplier).
"'";
680 $sqlsearchpackage .=
" AND quantity <= ".((float) $objp->qty);
681 $sqlsearchpackage .=
" AND (packaging IS NULL OR packaging = 0 OR packaging <= ".((float) $objp->qty).
")";
682 $sqlsearchpackage .=
" AND fk_soc = ".((int) $this->socid);
683 $sqlsearchpackage .=
" ORDER BY packaging ASC";
684 $sqlsearchpackage .=
" LIMIT 1";
686 $resqlsearchpackage = $this->db->query($sqlsearchpackage);
687 if ($resqlsearchpackage) {
688 $objsearchpackage = $this->db->fetch_object($resqlsearchpackage);
689 if ($objsearchpackage) {
690 $line->fk_fournprice = $objsearchpackage->rowid;
691 $line->packaging = $objsearchpackage->packaging;
694 $this->error = $this->db->lasterror();
699 $line->date_start = $this->db->jdate($objp->date_start);
700 $line->date_end = $this->db->jdate($objp->date_end);
701 $line->fk_unit = $objp->fk_unit;
704 $line->fk_multicurrency = $objp->fk_multicurrency;
705 $line->multicurrency_code = $objp->multicurrency_code;
706 $line->multicurrency_subprice = $objp->multicurrency_subprice;
707 $line->multicurrency_total_ht = $objp->multicurrency_total_ht;
708 $line->multicurrency_total_tva = $objp->multicurrency_total_tva;
709 $line->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
711 $line->info_bits = $objp->info_bits;
712 $line->special_code = $objp->special_code;
713 $line->fk_parent_line = $objp->fk_parent_line;
715 $line->rang = $objp->rang;
719 $line->fetch_optionals();
721 $this->lines[$i] = $line;
725 $this->db->free($result);
729 $this->error = $this->db->error().
" sql=".$sql;
742 public function valid($user, $idwarehouse = 0, $notrigger = 0)
745 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
751 if ((!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && ($user->hasRight(
"fournisseur",
"commande",
"creer") || $user->hasRight(
"supplier_order",
"creer")))
752 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
"fournisseur",
"supplier_order_advance",
"validate"))) {
757 $soc->fetch($this->fourn_id);
760 if (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref)) {
767 $sql =
'UPDATE '.$this->db->prefix().
"commande_fournisseur";
768 $sql .=
" SET ref='".$this->db->escape($num).
"',";
769 $sql .=
" fk_statut = ".((int) self::STATUS_VALIDATED).
",";
770 $sql .=
" date_valid='".$this->db->idate(
dol_now()).
"',";
771 $sql .=
" fk_user_valid = ".((int) $user->id);
772 $sql .=
" WHERE rowid = ".((int) $this->
id);
773 $sql .=
" AND fk_statut = ".((int) self::STATUS_DRAFT);
775 $resql = $this->db->query($sql);
781 if (!$error && !$notrigger) {
783 $result = $this->
call_trigger(
'ORDER_SUPPLIER_VALIDATE', $user);
791 $this->oldref = $this->ref;
794 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
796 $sql =
'UPDATE '.$this->db->prefix().
"ecm_files set filename = CONCAT('".$this->db->escape($this->newref).
"', SUBSTR(filename, ".(strlen($this->
ref) + 1).
")), filepath = 'fournisseur/commande/".$this->db->escape($this->newref).
"'";
797 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'fournisseur/commande/".$this->db->escape($this->
ref).
"' and entity = ".((int) $conf->entity);
798 $resql = $this->db->query($sql);
801 $this->error = $this->db->lasterror();
803 $sql =
'UPDATE '.$this->db->prefix().
"ecm_files set filepath = 'fournisseur/commande/".$this->db->escape($this->newref).
"'";
804 $sql .=
" WHERE filepath = 'fournisseur/commande/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
805 $resql = $this->db->query($sql);
808 $this->error = $this->db->lasterror();
814 $dirsource = $conf->fournisseur->commande->dir_output.
'/'.$oldref;
815 $dirdest = $conf->fournisseur->commande->dir_output.
'/'.$newref;
816 if (!$error && file_exists($dirsource)) {
817 dol_syslog(get_class($this).
"::valid rename dir ".$dirsource.
" into ".$dirdest);
819 if (@rename($dirsource, $dirdest)) {
822 $listoffiles =
dol_dir_list($conf->fournisseur->commande->dir_output.
'/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
823 foreach ($listoffiles as $fileentry) {
824 $dirsource = $fileentry[
'name'];
825 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
826 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
827 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
828 @rename($dirsource, $dirdest);
846 $this->db->rollback();
850 $this->error =
'NotAuthorized';
851 dol_syslog(get_class($this).
"::valid ".$this->error, LOG_ERR);
876 public function LibStatut($status, $mode = 0, $billed = 0)
879 global $langs, $hookmanager;
881 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
882 $langs->load(
'orders');
884 $this->labelStatus[0] =
'StatusSupplierOrderDraft';
885 $this->labelStatus[1] =
'StatusSupplierOrderValidated';
886 $this->labelStatus[2] =
'StatusSupplierOrderApproved';
888 $this->labelStatus[3] =
'StatusSupplierOrderOnProcess';
890 $this->labelStatus[3] =
'StatusSupplierOrderOnProcessWithValidation';
892 $this->labelStatus[4] =
'StatusSupplierOrderReceivedPartially';
893 $this->labelStatus[5] =
'StatusSupplierOrderReceivedAll';
894 $this->labelStatus[6] =
'StatusSupplierOrderCanceled';
895 $this->labelStatus[7] =
'StatusSupplierOrderCanceled';
896 $this->labelStatus[9] =
'StatusSupplierOrderRefused';
899 $this->labelStatusShort[0] =
'StatusSupplierOrderDraftShort';
900 $this->labelStatusShort[1] =
'StatusSupplierOrderValidatedShort';
901 $this->labelStatusShort[2] =
'StatusSupplierOrderApprovedShort';
902 $this->labelStatusShort[3] =
'StatusSupplierOrderOnProcessShort';
903 $this->labelStatusShort[4] =
'StatusSupplierOrderReceivedPartiallyShort';
904 $this->labelStatusShort[5] =
'StatusSupplierOrderReceivedAllShort';
905 $this->labelStatusShort[6] =
'StatusSupplierOrderCanceledShort';
906 $this->labelStatusShort[7] =
'StatusSupplierOrderCanceledShort';
907 $this->labelStatusShort[9] =
'StatusSupplierOrderRefusedShort';
910 $statustrans = array(
922 $statusClass =
'status0';
923 if (!empty($statustrans[$status])) {
924 $statusClass = $statustrans[$status];
929 $billedtext =
' - '.$langs->trans(
"Billed");
931 if ($status == 5 && $billed) {
932 $statusClass =
'status6';
935 $statusLong = $langs->transnoentitiesnoconv($this->labelStatus[$status]).$billedtext;
936 $statusShort = $langs->transnoentitiesnoconv($this->labelStatusShort[$status]);
938 $parameters = array(
'status' => $status,
'mode' => $mode,
'billed' => $billed);
939 $reshook = $hookmanager->executeHooks(
'LibStatut', $parameters, $this);
941 return $hookmanager->resPrint;
944 return dolGetStatus($statusLong, $statusShort,
'', $statusClass, $mode);
956 global $conf, $langs, $user;
958 $langs->loadLangs([
'bills',
'orders']);
961 $nofetch = !empty($params[
'nofetch']);
963 if ($user->hasRight(
"fournisseur",
"commande",
"read")) {
964 $datas[
'picto'] =
'<u class="paddingrightonly">'.$langs->trans(
"SupplierOrder").
'</u>';
965 if (isset($this->
statut)) {
966 $datas[
'picto'] .=
' '.$this->getLibStatut(5);
968 if (!empty($this->
ref)) {
969 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
971 if (!empty($this->ref_supplier)) {
972 $datas[
'refsupplier'] =
'<br><b>'.$langs->trans(
'RefSupplier').
':</b> '.$this->ref_supplier;
975 $langs->load(
'companies');
976 if (empty($this->thirdparty)) {
979 $datas[
'supplier'] =
'<br><b>'.$langs->trans(
'Supplier').
':</b> '.$this->thirdparty->getNomUrl(1,
'', 0, 1);
981 if (!empty($this->total_ht)) {
982 $datas[
'totalht'] =
'<br><b>'.$langs->trans(
'AmountHT').
':</b> '.
price($this->total_ht, 0, $langs, 0, -1, -1, $conf->currency);
984 if (!empty($this->total_tva)) {
985 $datas[
'totaltva'] =
'<br><b>'.$langs->trans(
'VAT').
':</b> '.
price($this->total_tva, 0, $langs, 0, -1, -1, $conf->currency);
987 if (!empty($this->total_ttc)) {
988 $datas[
'totalttc'] =
'<br><b>'.$langs->trans(
'AmountTTC').
':</b> '.
price($this->total_ttc, 0, $langs, 0, -1, -1, $conf->currency);
990 if (!empty($this->date)) {
991 $datas[
'date'] =
'<br><b>'.$langs->trans(
'Date').
':</b> '.
dol_print_date($this->date,
'day');
993 if (!empty($this->delivery_date)) {
994 $datas[
'deliverydate'] =
'<br><b>'.$langs->trans(
'DeliveryDate').
':</b> '.
dol_print_date($this->delivery_date,
'dayhour');
1010 public function getNomUrl($withpicto = 0, $option =
'', $notooltip = 0, $save_lastsearch_value = -1, $addlinktonotes = 0)
1012 global $langs, $user, $hookmanager;
1017 'objecttype' => $this->element,
1018 'option' => $option,
1021 $classfortooltip =
'classfortooltip';
1024 $classfortooltip =
'classforajaxtooltip';
1025 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
1031 $url = DOL_URL_ROOT.
'/fourn/commande/card.php?id='.$this->id;
1033 if ($option !==
'nolink') {
1035 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
1036 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
1037 $add_save_lastsearch_values = 1;
1039 if ($add_save_lastsearch_values) {
1040 $url .=
'&save_lastsearch_values=1';
1045 if (empty($notooltip)) {
1047 $label = $langs->trans(
"ShowOrder");
1048 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1).
'"';
1050 $linkclose .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
1051 $linkclose .= $dataparams.
' class="'.$classfortooltip.
'"';
1054 $linkstart =
'<a href="'.$url.
'"';
1055 $linkstart .= $linkclose.
'>';
1058 $result .= $linkstart;
1060 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), (($withpicto != 2) ?
'class="paddingright"' :
''), 0, 0, $notooltip ? 0 : 1);
1062 if ($withpicto != 2) {
1063 $result .= $this->ref;
1065 $result .= $linkend;
1067 if ($addlinktonotes) {
1068 $txttoshow = ($user->socid > 0 ? $this->note_public : $this->note_private);
1071 $result .=
' <span class="note inline-block">';
1072 $result .=
'<a href="'.DOL_URL_ROOT.
'/fourn/commande/note.php?id='.$this->
id.
'" class="classfortooltip" title="'.
dol_escape_htmltag($notetoshow).
'">';
1077 $result .=
'</span>';
1082 $hookmanager->initHooks(array($this->element .
'dao'));
1083 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
1084 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
1086 $result = $hookmanager->resPrint;
1088 $result .= $hookmanager->resPrint;
1103 global $langs, $conf;
1104 $langs->load(
"orders");
1113 $dirmodels = array_merge(array(
'/'), (array) $conf->modules_parts[
'models']);
1115 foreach ($dirmodels as $reldir) {
1116 $dir =
dol_buildpath($reldir.
"core/modules/supplier_order/");
1119 $mybool = ((bool) @include_once $dir.$file) || $mybool;
1122 if ($mybool ===
false) {
1127 $obj =
new $classname();
1128 $numref = $obj->getNextValue($soc, $this);
1130 if ($numref !=
"") {
1133 $this->error = $obj->error;
1137 $this->error =
"Error_COMMANDE_SUPPLIER_ADDON_NotDefined";
1151 if ($this->billed) {
1157 $sql =
'UPDATE '.$this->db->prefix().
'commande_fournisseur SET billed = 1';
1160 if ($this->db->query($sql)) {
1163 $result = $this->
call_trigger(
'ORDER_SUPPLIER_CLASSIFY_BILLED', $user);
1173 $this->db->commit();
1176 $this->db->rollback();
1182 $this->db->rollback();
1195 public function approve($user, $idwarehouse = 0, $secondlevel = 0)
1197 global $langs, $conf;
1198 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1204 if ($user->hasRight(
"fournisseur",
"commande",
"approuver")) {
1210 $soc =
new Societe($this->db);
1211 $soc->fetch($this->fourn_id);
1214 if (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref)) {
1222 $movetoapprovestatus =
true;
1225 $sql =
"UPDATE ".$this->db->prefix().
"commande_fournisseur";
1226 $sql .=
" SET ref='".$this->db->escape($num).
"',";
1227 if (empty($secondlevel)) {
1228 $sql .=
" date_approve='".$this->db->idate($now).
"',";
1229 $sql .=
" fk_user_approve = ".$user->id;
1230 if (
getDolGlobalString(
'SUPPLIER_ORDER_3_STEPS_TO_BE_APPROVED') && $this->total_ht >= $conf->global->SUPPLIER_ORDER_3_STEPS_TO_BE_APPROVED) {
1231 if (empty($this->user_approve_id2)) {
1232 $movetoapprovestatus =
false;
1233 $comment =
' (first level)';
1237 $sql .=
" date_approve2='".$this->db->idate($now).
"',";
1238 $sql .=
" fk_user_approve2 = ".((int) $user->id);
1239 if (empty($this->user_approve_id)) {
1240 $movetoapprovestatus =
false;
1242 $comment =
' (second level)';
1245 if ($movetoapprovestatus) {
1246 $sql .=
", fk_statut = ".self::STATUS_ACCEPTED;
1248 $sql .=
", fk_statut = ".self::STATUS_VALIDATED;
1250 $sql .=
" WHERE rowid = ".((int) $this->
id);
1251 $sql .=
" AND fk_statut = ".self::STATUS_VALIDATED;
1253 if ($this->db->query($sql)) {
1255 $result = $this->
add_contact($user->id,
'SALESREPFOLL',
'internal', 1);
1256 if ($result < 0 && $result != -2) {
1262 if (!$error && $movetoapprovestatus && isModEnabled(
'stock') &&
getDolGlobalString(
'STOCK_CALCULATE_ON_SUPPLIER_VALIDATE_ORDER')) {
1263 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
1264 $langs->load(
"agenda");
1266 $cpt = count($this->lines);
1267 for ($i = 0; $i < $cpt; $i++) {
1269 if ($this->lines[$i]->fk_product > 0) {
1270 $this->line = $this->lines[$i];
1272 $mouvP->origin = &$this;
1273 $mouvP->setOrigin($this->element, $this->
id);
1275 $up_ht_disc = $this->lines[$i]->subprice;
1276 if (!empty($this->lines[$i]->remise_percent) && !
getDolGlobalString(
'STOCK_EXCLUDE_DISCOUNT_FOR_PMP')) {
1277 $up_ht_disc =
price2num($up_ht_disc * (100 - $this->lines[$i]->remise_percent) / 100,
'MU');
1279 $result = $mouvP->reception($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, $up_ht_disc, $langs->trans(
"OrderApprovedInDolibarr", $this->ref));
1290 $result = $this->
call_trigger(
'ORDER_SUPPLIER_APPROVE', $user);
1298 $this->
ref = $this->newref;
1300 if ($movetoapprovestatus) {
1305 if (empty($secondlevel)) {
1306 $this->date_approve = $now;
1307 $this->user_approve_id = $user->id;
1309 $this->date_approve2 = $now;
1310 $this->user_approve_id2 = $user->id;
1313 $this->db->commit();
1316 $this->db->rollback();
1320 $this->db->rollback();
1321 $this->error = $this->db->lasterror();
1325 dol_syslog(get_class($this).
"::approve Not Authorized", LOG_ERR);
1338 global $conf, $langs;
1344 if ($user->hasRight(
"fournisseur",
"commande",
"approuver")) {
1347 $sql =
"UPDATE ".$this->db->prefix().
"commande_fournisseur SET fk_statut = ".
self::STATUS_REFUSED;
1348 $sql .=
" WHERE rowid = ".((int) $this->
id);
1350 if ($this->db->query($sql)) {
1355 $result = $this->
call_trigger(
'ORDER_SUPPLIER_REFUSE', $user);
1358 $this->db->rollback();
1360 $this->db->commit();
1365 $this->db->rollback();
1366 $this->error = $this->db->lasterror();
1367 dol_syslog(get_class($this).
"::refuse Error -1");
1371 dol_syslog(get_class($this).
"::refuse Not Authorized");
1385 public function Cancel($user, $idwarehouse = -1)
1388 global $langs, $conf;
1394 if ($user->hasRight(
"fournisseur",
"commande",
"commander")) {
1399 $sql =
"UPDATE ".$this->db->prefix().
"commande_fournisseur SET fk_statut = ".((int) $statut);
1400 $sql .=
" WHERE rowid = ".((int) $this->
id);
1401 dol_syslog(get_class($this).
"::cancel", LOG_DEBUG);
1402 if ($this->db->query($sql)) {
1406 $result = $this->
call_trigger(
'ORDER_SUPPLIER_CANCEL', $user);
1413 $this->db->commit();
1416 $this->db->rollback();
1420 $this->db->rollback();
1421 $this->error = $this->db->lasterror();
1422 dol_syslog(get_class($this).
"::cancel ".$this->error);
1426 dol_syslog(get_class($this).
"::cancel Not Authorized");
1440 public function commande($user, $date, $methode, $comment =
'')
1445 if ($user->hasRight(
"fournisseur",
"commande",
"commander")) {
1448 $newnoteprivate = $this->note_private;
1450 $newnoteprivate =
dol_concatdesc($newnoteprivate, $langs->trans(
"Comment").
': '.$comment);
1453 $sql =
"UPDATE ".$this->db->prefix().
"commande_fournisseur";
1454 $sql .=
" SET fk_statut=".self::STATUS_ORDERSENT.
", fk_input_method=".$methode.
", date_commande='".$this->db->idate($date).
"', ";
1455 $sql .=
" note_private='".$this->db->escape($newnoteprivate).
"'";
1456 $sql .=
" WHERE rowid=".((int) $this->
id);
1458 dol_syslog(get_class($this).
"::commande", LOG_DEBUG);
1459 if ($this->db->query($sql)) {
1461 $this->methode_commande_id = $methode;
1462 $this->date_commande = $date;
1463 $this->context = array(
'comments' => $comment);
1466 $result = $this->
call_trigger(
'ORDER_SUPPLIER_SUBMIT', $user);
1473 $this->error = $this->db->lasterror();
1474 $this->errors[] = $this->db->lasterror();
1478 $this->db->commit();
1480 $this->db->rollback();
1484 $this->error = $langs->trans(
'NotAuthorized');
1485 $this->errors[] = $langs->trans(
'NotAuthorized');
1486 dol_syslog(get_class($this).
"::commande User not Authorized", LOG_WARNING);
1489 return ($error ? -1 : 1);
1499 public function create($user, $notrigger = 0)
1501 global $langs, $conf, $hookmanager;
1509 $date = ($this->date_commande ? $this->date_commande : $this->date);
1513 $delivery_date = $this->delivery_date;
1516 if (empty($this->source)) {
1521 if (!empty($this->multicurrency_code) && empty($this->multicurrency_tx)) {
1526 if (empty($this->fk_multicurrency)) {
1527 $this->multicurrency_code = $conf->currency;
1528 $this->fk_multicurrency = 0;
1529 $this->multicurrency_tx = 1;
1536 $sql =
"INSERT INTO ".$this->db->prefix().
"commande_fournisseur (";
1538 $sql .=
", ref_supplier";
1539 $sql .=
", note_private";
1540 $sql .=
", note_public";
1543 $sql .=
", fk_projet";
1544 $sql .=
", date_creation";
1545 $sql .=
", date_livraison";
1546 $sql .=
", fk_user_author";
1547 $sql .=
", fk_statut";
1549 $sql .=
", model_pdf";
1550 $sql .=
", fk_mode_reglement";
1551 $sql .=
", fk_cond_reglement";
1552 $sql .=
", fk_account";
1553 $sql .=
", fk_incoterms, location_incoterms";
1554 $sql .=
", fk_multicurrency";
1555 $sql .=
", multicurrency_code";
1556 $sql .=
", multicurrency_tx";
1558 $sql .=
" VALUES (";
1560 $sql .=
", ".(isset($this->ref_supplier) ?
"'".$this->db->escape($this->ref_supplier).
"'" :
"NULL");
1561 $sql .=
", '".$this->db->escape($this->note_private).
"'";
1562 $sql .=
", '".$this->db->escape($this->note_public).
"'";
1563 $sql .=
", ".setEntity($this);
1564 $sql .=
", ".((int) $this->socid);
1565 $sql .=
", ".($this->fk_project > 0 ? ((int) $this->fk_project) :
"null");
1566 $sql .=
", '".$this->db->idate($date).
"'";
1567 $sql .=
", ".($delivery_date ?
"'".$this->db->idate($delivery_date).
"'" :
"null");
1568 $sql .=
", ".((int) $user->id);
1569 $sql .=
", ".self::STATUS_DRAFT;
1570 $sql .=
", ".((int) $this->source);
1571 $sql .=
", '".$this->db->escape(
getDolGlobalString(
'COMMANDE_SUPPLIER_ADDON_PDF')).
"'";
1572 $sql .=
", ".($this->mode_reglement_id > 0 ? $this->mode_reglement_id :
'null');
1573 $sql .=
", ".($this->cond_reglement_id > 0 ? $this->cond_reglement_id :
'null');
1574 $sql .=
", ".($this->fk_account > 0 ? $this->fk_account :
'NULL');
1575 $sql .=
", ".(int) $this->fk_incoterms;
1576 $sql .=
", '".$this->db->escape($this->location_incoterms).
"'";
1577 $sql .=
", ".(int) $this->fk_multicurrency;
1578 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
1579 $sql .=
", ".(float) $this->multicurrency_tx;
1582 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1583 if ($this->db->query($sql)) {
1584 $this->
id = $this->db->last_insert_id($this->db->prefix().
"commande_fournisseur");
1587 $num = count($this->lines);
1590 for ($i = 0; $i < $num; $i++) {
1591 $line = $this->lines[$i];
1592 if (!is_object($line)) {
1593 $line = (object) $line;
1604 $line->localtax1_tx,
1605 $line->localtax2_tx,
1609 $line->remise_percent,
1612 $line->product_type,
1617 $line->array_options,
1619 $line->multicurrency_subprice,
1626 dol_syslog(get_class($this).
"::create ".$this->error, LOG_WARNING);
1627 $this->db->rollback();
1632 $sql =
"UPDATE ".$this->db->prefix().
"commande_fournisseur";
1633 $sql .=
" SET ref='(PROV".$this->id.
")'";
1634 $sql .=
" WHERE rowid=".((int) $this->
id);
1636 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1637 if ($this->db->query($sql)) {
1640 $this->
ref =
"(PROV".$this->id.
")";
1642 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
1643 $this->linked_objects = $this->linkedObjectsIds;
1647 if (!$error && $this->
id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
1648 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
1649 if (is_array($tmp_origin_id)) {
1650 foreach ($tmp_origin_id as $origin_id) {
1658 $origin_id = $tmp_origin_id;
1676 if (!$error && !$notrigger) {
1678 $result = $this->
call_trigger(
'ORDER_SUPPLIER_CREATE', $user);
1680 $this->db->rollback();
1688 $this->db->commit();
1691 $this->db->rollback();
1695 $this->error = $this->db->lasterror();
1696 $this->db->rollback();
1701 $this->error =
'Failed to get ID of inserted line';
1706 $this->error = $this->db->lasterror();
1707 $this->db->rollback();
1727 if (isset($this->
ref)) {
1728 $this->
ref = trim($this->
ref);
1730 if (isset($this->ref_supplier)) {
1731 $this->ref_supplier = trim($this->ref_supplier);
1733 if (isset($this->note_private)) {
1734 $this->note_private = trim($this->note_private);
1736 if (isset($this->note_public)) {
1737 $this->note_public = trim($this->note_public);
1739 if (isset($this->model_pdf)) {
1740 $this->model_pdf = trim($this->model_pdf);
1742 if (isset($this->import_key)) {
1743 $this->import_key = trim($this->import_key);
1747 $sql =
"UPDATE ".$this->db->prefix().$this->table_element.
" SET";
1749 $sql .=
" ref=".(isset($this->
ref) ?
"'".$this->db->escape($this->
ref).
"'" :
"null").
",";
1750 $sql .=
" ref_supplier=".(isset($this->ref_supplier) ?
"'".$this->db->escape($this->ref_supplier).
"'" :
"null").
",";
1751 $sql .=
" ref_ext=".(isset($this->ref_ext) ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null").
",";
1752 $sql .=
" fk_soc=".(isset($this->socid) ? $this->socid :
"null").
",";
1753 $sql .=
" date_commande=".(strval($this->date_commande) !=
'' ?
"'".$this->db->idate($this->date_commande).
"'" :
'null').
",";
1754 $sql .=
" date_valid=".(strval($this->date_validation) !=
'' ?
"'".$this->db->idate($this->date_validation).
"'" :
'null').
",";
1755 $sql .=
" total_tva=".(isset($this->total_tva) ? $this->total_tva :
"null").
",";
1756 $sql .=
" localtax1=".(isset($this->total_localtax1) ? $this->total_localtax1 :
"null").
",";
1757 $sql .=
" localtax2=".(isset($this->total_localtax2) ? $this->total_localtax2 :
"null").
",";
1758 $sql .=
" total_ht=".(isset($this->total_ht) ? $this->total_ht :
"null").
",";
1759 $sql .=
" total_ttc=".(isset($this->total_ttc) ? $this->total_ttc :
"null").
",";
1760 $sql .=
" fk_statut=".(isset($this->
statut) ? $this->
statut :
"null").
",";
1761 $sql .=
" fk_user_author=".(isset($this->user_author_id) ? $this->user_author_id :
"null").
",";
1762 $sql .=
" fk_user_valid=".(isset($this->user_validation_id) && $this->user_validation_id > 0 ? $this->user_validation_id :
"null").
",";
1763 $sql .=
" fk_projet=".(isset($this->fk_project) ? $this->fk_project :
"null").
",";
1764 $sql .=
" fk_cond_reglement=".(isset($this->cond_reglement_id) ? $this->cond_reglement_id :
"null").
",";
1765 $sql .=
" fk_mode_reglement=".(isset($this->mode_reglement_id) ? $this->mode_reglement_id :
"null").
",";
1766 $sql .=
" date_livraison=".(strval($this->delivery_date) !=
'' ?
"'".$this->db->idate($this->delivery_date).
"'" :
'null').
",";
1768 $sql .=
" fk_account=".($this->fk_account > 0 ? $this->fk_account :
"null").
",";
1770 $sql .=
" note_private=".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null").
",";
1771 $sql .=
" note_public=".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null").
",";
1772 $sql .=
" model_pdf=".(isset($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
"null").
",";
1773 $sql .=
" import_key=".(isset($this->import_key) ?
"'".$this->db->escape($this->import_key).
"'" :
"null");
1775 $sql .=
" WHERE rowid=".((int) $this->
id);
1779 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
1780 $resql = $this->db->query($sql);
1783 $this->errors[] =
"Error ".$this->db->lasterror();
1793 if (!$error && !$notrigger) {
1795 $result = $this->
call_trigger(
'ORDER_SUPPLIER_MODIFY', $user);
1804 foreach ($this->errors as $errmsg) {
1805 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
1806 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1808 $this->db->rollback();
1811 $this->db->commit();
1826 global $conf, $user, $hookmanager;
1833 foreach ($this->lines as $line) {
1834 $line->fetch_optionals();
1838 $objFrom = clone $this;
1841 if (!empty($socid) && $socid != $this->socid) {
1842 $objsoc =
new Societe($this->db);
1844 if ($objsoc->fetch($socid) > 0) {
1845 $this->socid = $objsoc->id;
1846 $this->cond_reglement_id = (!empty($objsoc->cond_reglement_id) ? $objsoc->cond_reglement_id : 0);
1847 $this->mode_reglement_id = (!empty($objsoc->mode_reglement_id) ? $objsoc->mode_reglement_id : 0);
1848 $this->fk_project = 0;
1849 $this->fk_delivery_address = 0;
1859 $this->user_author_id = $user->id;
1860 $this->user_validation_id = 0;
1863 $this->date_creation = 0;
1864 $this->date_validation = 0;
1865 $this->date_commande = 0;
1866 $this->ref_supplier =
'';
1867 $this->user_approve_id = 0;
1868 $this->user_approve_id2 = 0;
1869 $this->date_approve = 0;
1870 $this->date_approve2 = 0;
1873 $this->context[
'createfromclone'] =
'createfromclone';
1874 $result = $this->
create($user, $notrigger);
1881 if (is_object($hookmanager)) {
1882 $parameters = array(
'objFrom' => $objFrom);
1884 $reshook = $hookmanager->executeHooks(
'createFrom', $parameters, $this, $action);
1892 unset($this->context[
'createfromclone']);
1896 $this->db->commit();
1899 $this->db->rollback();
1933 public function addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1 = 0.0, $txlocaltax2 = 0.0, $fk_product = 0, $fk_prod_fourn_price = 0, $ref_supplier =
'', $remise_percent = 0.0, $price_base_type =
'HT', $pu_ttc = 0.0, $type = 0, $info_bits = 0, $notrigger = 0, $date_start =
null, $date_end =
null, $array_options = [], $fk_unit =
null, $pu_ht_devise = 0, $origin =
'', $origin_id = 0, $rang = -1, $special_code = 0)
1935 global $langs, $mysoc, $conf;
1937 dol_syslog(get_class($this).
"::addline $desc, $pu_ht, $qty, $txtva, $txlocaltax1, $txlocaltax2, $fk_product, $fk_prod_fourn_price, $ref_supplier, $remise_percent, $price_base_type, $pu_ttc, $type, $info_bits, $notrigger, $date_start, $date_end, $fk_unit, $pu_ht_devise, $origin, $origin_id");
1938 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
1940 if ($this->
statut == self::STATUS_DRAFT) {
1941 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
1950 if (empty($txtva)) {
1956 if (empty($txlocaltax1)) {
1959 if (empty($txlocaltax2)) {
1962 if (empty($remise_percent)) {
1963 $remise_percent = 0;
1966 $remise_percent =
price2num($remise_percent);
1969 $pu_ht_devise =
price2num($pu_ht_devise);
1971 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
1976 if ($price_base_type ==
'HT') {
1981 $desc = trim($desc);
1984 if ($qty < 0 && !$fk_product) {
1985 $this->error = $langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Product"));
1991 if ($date_start && $date_end && $date_start > $date_end) {
1992 $langs->load(
"errors");
1993 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
2000 $product_type = $type;
2003 if ($fk_product > 0) {
2006 dol_syslog(get_class($this).
"::addline we check supplier prices fk_product=".$fk_product.
" fk_prod_fourn_price=".$fk_prod_fourn_price.
" qty=".$qty.
" ref_supplier=".$ref_supplier);
2008 if ($prod->fetch($fk_product) > 0) {
2009 $product_type = $prod->type;
2010 $label = $prod->label;
2014 $result = $prod->get_buyprice($fk_prod_fourn_price, $qty, $fk_product,
'none', (isset($this->fk_soc) ? $this->fk_soc : $this->socid));
2018 if ($result > 0 && ($origin ==
'commande' || $pu ===
'')) {
2019 $pu = $prod->fourn_pu;
2020 $ref_supplier = $prod->ref_supplier;
2022 if ($remise_percent == 0 && $prod->remise_percent != 0) {
2023 $remise_percent = $prod->remise_percent;
2027 $langs->load(
"errors");
2028 $this->error =
"Ref ".$prod->ref.
" ".$langs->trans(
"ErrorQtyTooLowForThisSupplier");
2029 $this->db->rollback();
2030 dol_syslog(get_class($this).
"::addline we did not found supplier price, so we can't guess unit price");
2035 if ($result == -1) {
2036 $langs->load(
"errors");
2037 $this->error =
"Ref ".$prod->ref.
" ".$langs->trans(
"ErrorQtyTooLowForThisSupplier");
2038 $this->db->rollback();
2039 dol_syslog(get_class($this).
"::addline result=".$result.
" - ".$this->error, LOG_DEBUG);
2043 $this->error = $prod->error;
2044 $this->db->rollback();
2045 dol_syslog(get_class($this).
"::addline result=".$result.
" - ".$this->error, LOG_ERR);
2049 $this->error = $prod->error;
2050 $this->db->rollback();
2057 $prod =
new Product($this->db);
2058 $prod->get_buyprice($fk_prod_fourn_price, $qty, $fk_product,
'none', (empty($this->fk_soc) ? $this->socid : $this->fk_soc));
2060 if ($qty < $prod->packaging) {
2061 $qty = $prod->packaging;
2063 if (!empty($prod->packaging) && ($qty % $prod->packaging) > 0) {
2064 $coeff = intval($qty / $prod->packaging) + 1;
2065 $qty = $prod->packaging * $coeff;
2066 setEventMessages($langs->trans(
'QtyRecalculatedWithPackaging'),
null,
'mesgs');
2072 if (isModEnabled(
"multicurrency") && $pu_ht_devise > 0) {
2081 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
2082 $vat_src_code = $reg[1];
2083 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
2091 $tabprice =
calcul_price_total($qty, $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $product_type, $this->thirdparty, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);
2093 $total_ht = $tabprice[0];
2094 $total_tva = $tabprice[1];
2095 $total_ttc = $tabprice[2];
2096 $total_localtax1 = $tabprice[9];
2097 $total_localtax2 = $tabprice[10];
2098 $pu = $pu_ht = $tabprice[3];
2101 $multicurrency_total_ht = $tabprice[16];
2102 $multicurrency_total_tva = $tabprice[17];
2103 $multicurrency_total_ttc = $tabprice[18];
2104 $pu_ht_devise = $tabprice[19];
2106 $localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
2107 $localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
2111 $rang = $rangmax + 1;
2117 $this->line->context = $this->context;
2119 $this->line->fk_commande = $this->id;
2120 $this->line->label = $label;
2121 $this->line->ref_fourn = $ref_supplier;
2122 $this->line->ref_supplier = $ref_supplier;
2123 $this->line->desc = $desc;
2124 $this->line->qty = $qty;
2125 $this->line->tva_tx = $txtva;
2126 $this->line->localtax1_tx = ($total_localtax1 ? $localtaxes_type[1] : 0);
2127 $this->line->localtax2_tx = ($total_localtax2 ? $localtaxes_type[3] : 0);
2128 $this->line->localtax1_type = $localtax1_type;
2129 $this->line->localtax2_type = $localtax2_type;
2130 $this->line->fk_product = $fk_product;
2131 $this->line->product_type = $product_type;
2132 $this->line->remise_percent = $remise_percent;
2133 $this->line->subprice = $pu_ht;
2134 $this->line->rang = $rang;
2135 $this->line->info_bits = $info_bits;
2137 $this->line->vat_src_code = $vat_src_code;
2138 $this->line->total_ht = $total_ht;
2139 $this->line->total_tva = $total_tva;
2140 $this->line->total_localtax1 = $total_localtax1;
2141 $this->line->total_localtax2 = $total_localtax2;
2142 $this->line->total_ttc = $total_ttc;
2143 $this->line->product_type = $type;
2144 $this->line->special_code = (!empty($special_code) ? $special_code : 0);
2145 $this->line->origin = $origin;
2146 $this->line->origin_id = $origin_id;
2147 $this->line->fk_unit = $fk_unit;
2149 $this->line->date_start = $date_start;
2150 $this->line->date_end = $date_end;
2153 $this->line->fk_multicurrency = $this->fk_multicurrency;
2154 $this->line->multicurrency_code = $this->multicurrency_code;
2155 $this->line->multicurrency_subprice = $pu_ht_devise;
2156 $this->line->multicurrency_total_ht = $multicurrency_total_ht;
2157 $this->line->multicurrency_total_tva = $multicurrency_total_tva;
2158 $this->line->multicurrency_total_ttc = $multicurrency_total_ttc;
2160 $this->line->subprice = $pu_ht;
2161 $this->line->price = $this->line->subprice;
2163 $this->line->remise_percent = $remise_percent;
2165 if (is_array($array_options) && count($array_options) > 0) {
2166 $this->line->array_options = $array_options;
2169 $result = $this->line->insert($notrigger);
2172 if (!empty($this->line->fk_parent_line)) {
2174 } elseif ($rang > 0 && $rang <= count($this->lines)) {
2175 $linecount = count($this->lines);
2176 for ($ii = $rang; $ii <= $linecount; $ii++) {
2182 $result = $this->
update_price(1,
'auto', 0, $this->thirdparty);
2184 $this->db->commit();
2185 return $this->line->id;
2187 $this->db->rollback();
2191 $this->error = $this->line->error;
2192 $this->errors = $this->line->errors;
2193 dol_syslog(get_class($this).
"::addline error=".$this->error, LOG_ERR);
2194 $this->db->rollback();
2219 public function dispatchProduct($user, $product, $qty, $entrepot, $price = 0, $comment =
'', $eatby =
'', $sellby =
'', $batch =
'', $fk_commandefourndet = 0, $notrigger = 0, $fk_reception = 0)
2221 global $conf, $langs;
2224 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
2227 if ($entrepot <= 0) {
2228 $this->error =
'ErrorBadValueForParameterWarehouse';
2232 $this->error =
'ErrorBadValueForParameterQty';
2236 $dispatchstatus = 1;
2238 $dispatchstatus = 0;
2245 if (($this->
statut == self::STATUS_ORDERSENT || $this->
statut == self::STATUS_RECEIVED_PARTIALLY || $this->
statut == self::STATUS_RECEIVED_COMPLETELY)) {
2248 $sql =
"INSERT INTO ".$this->db->prefix().
"receptiondet_batch";
2249 $sql .=
" (fk_element, fk_product, qty, fk_entrepot, fk_user, datec, fk_elementdet, status, comment, eatby, sellby, batch, fk_reception) VALUES";
2250 $sql .=
" ('".$this->id.
"','".$product.
"','".$qty.
"',".($entrepot > 0 ?
"'".$entrepot.
"'" :
"null").
",'".$user->id.
"','".$this->db->idate($now).
"','".$fk_commandefourndet.
"', ".$dispatchstatus.
", '".$this->db->escape($comment).
"', ";
2251 $sql .= ($eatby ?
"'".$this->db->idate($eatby).
"'" :
"null").
", ".($sellby ?
"'".$this->db->idate($sellby).
"'" :
"null").
", ".($batch ?
"'".$this->db->escape($batch).
"'" :
"null").
", ".($fk_reception > 0 ?
"'".$this->db->escape($fk_reception).
"'" :
"null");
2254 dol_syslog(get_class($this).
"::dispatchProduct", LOG_DEBUG);
2255 $resql = $this->db->query($sql);
2258 global $conf, $langs, $user;
2260 $result = $this->
call_trigger(
'LINEORDER_SUPPLIER_DISPATCH', $user);
2267 $this->error = $this->db->lasterror();
2272 if (!$error && $entrepot > 0 && isModEnabled(
'stock') &&
getDolGlobalString(
'STOCK_CALCULATE_ON_SUPPLIER_DISPATCH_ORDER')) {
2276 $mouv->origin = &$this;
2277 $mouv->setOrigin($this->element, $this->
id);
2280 if (
getDolGlobalString(
'SUPPLIER_ORDER_ALLOW_NEGATIVE_QTY_FOR_SUPPLIER_ORDER_RETURN') && $qty < 0) {
2281 $result = $mouv->livraison($user, $product, $entrepot, $qty * (-1), $price, $comment, $now, $eatby, $sellby, $batch, 0, $inventorycode);
2283 $result = $mouv->reception($user, $product, $entrepot, $qty, $price, $comment, $eatby, $sellby, $batch,
'', 0, $inventorycode);
2287 $this->error = $mouv->error;
2288 $this->errors = $mouv->errors;
2289 dol_syslog(get_class($this).
"::dispatchProduct ".$this->error.
" ".implode(
',', $this->errors), LOG_ERR);
2296 $this->db->commit();
2299 $this->db->rollback();
2303 $this->error =
'BadStatusForObject';
2319 if ($this->
statut == 0) {
2322 if ($line->fetch($idline) <= 0) {
2328 foreach ($dispatchedLines as $dispatchLine) {
2329 if ($dispatchLine[
'orderlineid'] == $idline) {
2330 $this->error =
"LineAlreadyDispatched";
2331 $this->errors[] = $this->error;
2336 if ($line->delete($user, $notrigger) > 0) {
2355 public function delete(
User $user, $notrigger = 0)
2357 global $langs, $conf;
2358 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
2364 if (empty($notrigger)) {
2366 $result = $this->
call_trigger(
'ORDER_SUPPLIER_DELETE', $user);
2368 $this->errors[] =
'ErrorWhenRunningTrigger';
2369 dol_syslog(get_class($this).
"::delete ".$this->error, LOG_ERR);
2370 $this->db->rollback();
2378 if (!empty($this->linkedObjects) && array_key_exists(
'reception', $this->linkedObjects)) {
2379 foreach ($this->linkedObjects[
'reception'] as $element) {
2380 if ($element->statut >= 0) {
2381 $this->errors[] = $langs->trans(
'ReceptionExist');
2388 $main = $this->db->prefix().
'commande_fournisseurdet';
2391 $sql1 =
"UPDATE ".$this->db->prefix().
"commandedet SET fk_commandefourndet = NULL WHERE fk_commandefourndet IN (SELECT rowid FROM ".$this->db->sanitize($main).
" WHERE fk_commande = ".((int) $this->
id).
")";
2392 dol_syslog(__METHOD__.
" linked order lines", LOG_DEBUG);
2393 if (!$this->db->query($sql1)) {
2395 $this->error = $this->db->lasterror();
2396 $this->errors[] = $this->db->lasterror();
2401 $ef = $main.
"_extrafields";
2402 $sql =
"DELETE FROM ".$this->db->sanitize($ef).
" WHERE fk_object IN (SELECT rowid FROM ".$this->db->sanitize($main).
" WHERE fk_commande = ".((int) $this->
id).
")";
2403 dol_syslog(get_class($this).
"::delete extrafields lines", LOG_DEBUG);
2404 if (!$this->db->query($sql)) {
2405 $this->error = $this->db->lasterror();
2406 $this->errors[] = $this->db->lasterror();
2412 $sql =
"DELETE FROM ".$this->db->prefix().
"commande_fournisseurdet WHERE fk_commande = ".((int) $this->
id);
2413 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
2414 if (!$this->db->query($sql)) {
2415 $this->error = $this->db->lasterror();
2416 $this->errors[] = $this->db->lasterror();
2422 $sql =
"DELETE FROM ".$this->db->prefix().
"commande_fournisseur WHERE rowid = ".((int) $this->
id);
2423 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
2424 if ($resql = $this->db->query($sql)) {
2425 if ($this->db->affected_rows($resql) < 1) {
2426 $this->error = $this->db->lasterror();
2427 $this->errors[] = $this->db->lasterror();
2431 $this->error = $this->db->lasterror();
2432 $this->errors[] = $this->db->lasterror();
2441 $this->error =
'FailToDeleteExtraFields';
2442 $this->errors[] =
'FailToDeleteExtraFields';
2444 dol_syslog(get_class($this).
"::delete error -4 ".$this->error, LOG_ERR);
2451 $this->error =
'FailToDeleteObjectLinked';
2452 $this->errors[] =
'FailToDeleteObjectLinked';
2463 if ($conf->fournisseur->commande->dir_output) {
2464 $dir = $conf->fournisseur->commande->dir_output.
"/".$ref;
2465 $file = $dir.
"/".$ref.
".pdf";
2466 if (file_exists($file)) {
2468 $this->error =
'ErrorFailToDeleteFile';
2469 $this->errors[] =
'ErrorFailToDeleteFile';
2473 if (file_exists($dir)) {
2476 $this->error =
'ErrorFailToDeleteDir';
2477 $this->errors[] =
'ErrorFailToDeleteDir';
2485 dol_syslog(get_class($this).
"::delete $this->id by $user->id", LOG_DEBUG);
2486 $this->db->commit();
2489 dol_syslog(get_class($this).
"::delete ".$this->error, LOG_ERR);
2490 $this->db->rollback();
2509 $sql =
"SELECT p.ref, p.label,";
2510 $sql .=
" e.rowid as warehouse_id, e.ref as entrepot,";
2511 $sql .=
" cfd.rowid as dispatchedlineid, cfd.fk_product, cfd.qty, cfd.eatby, cfd.sellby, cfd.batch, cfd.comment, cfd.status, cfd.fk_elementdet";
2512 $sql .=
" FROM ".$this->db->prefix().
"product as p,";
2513 $sql .=
" ".$this->db->prefix().
"receptiondet_batch as cfd";
2514 $sql .=
" LEFT JOIN ".$this->db->prefix().
"entrepot as e ON cfd.fk_entrepot = e.rowid";
2515 $sql .=
" WHERE cfd.fk_element = ".((int) $this->
id);
2516 $sql .=
" AND cfd.fk_product = p.rowid";
2518 $sql .=
" AND cfd.status = ".((int) $status);
2520 $sql .=
" ORDER BY cfd.rowid ASC";
2522 $resql = $this->db->query($sql);
2524 $num = $this->db->num_rows($resql);
2528 $objp = $this->db->fetch_object($resql);
2531 'id' => $objp->dispatchedlineid,
2532 'productid' => $objp->fk_product,
2533 'warehouseid' => $objp->warehouse_id,
2534 'qty' => $objp->qty,
2535 'orderlineid' => $objp->fk_elementdet
2542 dol_print_error($this->db,
'Failed to execute request to get dispatched lines');
2561 global $conf, $langs;
2568 $usercanreceive = 0;
2569 if (!isModEnabled(
'reception')) {
2570 $usercanreceive = $user->hasRight(
"fournisseur",
"commande",
"receptionner");
2572 $usercanreceive = $user->hasRight(
"reception",
"creer");
2575 if ($usercanreceive) {
2577 if ($type ==
'par') {
2579 } elseif ($type ==
'tot') {
2581 } elseif ($type ==
'nev') {
2583 } elseif ($type ==
'can') {
2587 dol_syslog(get_class($this).
"::Livraison Error -2", LOG_ERR);
2594 if (!$error && ($type ==
'tot')) {
2596 if (count($dispatchedlinearray) > 0) {
2599 $this->errors[] =
'ErrorCantSetReceptionToTotalDoneWithReceptionToApprove';
2600 dol_syslog(
'ErrorCantSetReceptionToTotalDoneWithReceptionToApprove', LOG_DEBUG);
2603 if (!$error &&
getDolGlobalString(
'SUPPLIER_ORDER_USE_DISPATCH_STATUS_NEED_APPROVE') && ($type ==
'tot')) {
2605 if (count($dispatchedlinearray) > 0) {
2608 $this->errors[] =
'ErrorCantSetReceptionToTotalDoneWithReceptionDenied';
2609 dol_syslog(
'ErrorCantSetReceptionToTotalDoneWithReceptionDenied', LOG_DEBUG);
2616 if (empty($error)) {
2619 $sql =
"UPDATE ".$this->db->prefix().
"commande_fournisseur";
2620 $sql .=
" SET fk_statut = ".((int) $statut);
2621 $sql .=
" WHERE rowid = ".((int) $this->
id);
2622 $sql .=
" AND fk_statut IN (".self::STATUS_ORDERSENT.
",".self::STATUS_RECEIVED_PARTIALLY.
")";
2624 dol_syslog(get_class($this).
"::Livraison", LOG_DEBUG);
2625 $resql = $this->db->query($sql);
2628 $old_statut = $this->statut;
2630 $this->context[
'actionmsg2'] = $comment;
2633 $result_trigger = $this->
call_trigger(
'ORDER_SUPPLIER_RECEIVE', $user);
2634 if ($result_trigger < 0) {
2639 if (empty($error)) {
2640 $this->db->commit();
2642 $this->
statut = $old_statut;
2643 $this->db->rollback();
2644 $this->error = $this->db->lasterror();
2648 $this->db->rollback();
2649 $this->error = $this->db->lasterror();
2654 $this->error = $langs->trans(
'NotAuthorized');
2655 $this->errors[] = $langs->trans(
'NotAuthorized');
2656 dol_syslog(get_class($this).
"::Livraison Not Authorized");
2688 if ($user->hasRight(
"fournisseur",
"commande",
"creer") || $user->hasRight(
"supplier_order",
"creer")) {
2693 $sql =
"UPDATE ".$this->db->prefix().
"commande_fournisseur";
2694 $sql .=
" SET date_livraison = ".($delivery_date ?
"'".$this->db->idate($delivery_date).
"'" :
'null');
2695 $sql .=
" WHERE rowid = ".((int) $this->
id);
2698 $resql = $this->db->query($sql);
2700 $this->errors[] = $this->db->error();
2705 $this->oldcopy = clone $this;
2706 $this->delivery_date = $delivery_date;
2709 if (!$notrigger && empty($error)) {
2711 $result = $this->
call_trigger(
'ORDER_SUPPLIER_MODIFY', $user);
2719 $this->db->commit();
2722 foreach ($this->errors as $errmsg) {
2723 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2724 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2726 $this->db->rollback();
2746 if ($user->hasRight(
"fournisseur",
"commande",
"creer") || $user->hasRight(
"supplier_order",
"creer")) {
2751 $sql =
"UPDATE ".$this->db->prefix().
"commande_fournisseur";
2752 $sql .=
" SET fk_projet = ".($id_projet > 0 ? (int) $id_projet :
'null');
2753 $sql .=
" WHERE rowid = ".((int) $this->
id);
2756 $resql = $this->db->query($sql);
2758 $this->errors[] = $this->db->error();
2763 $this->oldcopy = clone $this;
2764 $this->fk_projet = $id_projet;
2765 $this->fk_project = $id_projet;
2768 if (!$notrigger && empty($error)) {
2770 $result = $this->
call_trigger(
'ORDER_SUPPLIER_MODIFY', $user);
2778 $this->db->commit();
2781 foreach ($this->errors as $errmsg) {
2782 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2783 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2785 $this->db->rollback();
2803 $comclient =
new Commande($this->db);
2804 $comclient->fetch($comclientid);
2808 $this->lines = array();
2810 $num = count($comclient->lines);
2811 for ($i = 0; $i < $num; $i++) {
2812 $prod =
new Product($this->db);
2815 if ($prod->fetch($comclient->lines[$i]->fk_product) > 0) {
2816 $label = $prod->label;
2820 $sql =
"INSERT INTO ".$this->db->prefix().
"commande_fournisseurdet";
2821 $sql .=
" (fk_commande, label, description, fk_product, price, qty, tva_tx, localtax1_tx, localtax2_tx, remise_percent, subprice, remise, ref)";
2822 $sql .=
" VALUES (".((int) $idc).
", '".$this->db->escape($label).
"', '".$this->db->escape($comclient->lines[$i]->desc).
"'";
2823 $sql .=
",".$comclient->lines[$i]->fk_product.
", ".
price2num($comclient->lines[$i]->price,
'MU');
2824 $sql .=
", ".price2num($comclient->lines[$i]->qty,
'MS').
", ".
price2num($comclient->lines[$i]->tva_tx, 5).
", ".
price2num($comclient->lines[$i]->localtax1_tx, 5).
", ".
price2num($comclient->lines[$i]->localtax2_tx, 5).
", ".
price2num($comclient->lines[$i]->remise_percent, 3);
2825 $sql .=
", '".price2num($comclient->lines[$i]->subprice,
'MT').
"','0', '".$this->db->escape($ref).
"');";
2826 if ($this->db->query($sql)) {
2843 global $conf, $langs;
2848 $sql =
'UPDATE '.$this->db->prefix().
'commande_fournisseur';
2849 $sql .=
" SET fk_statut = ".$status;
2850 $sql .=
" WHERE rowid = ".((int) $this->
id);
2852 dol_syslog(get_class($this).
"::setStatus", LOG_DEBUG);
2853 $resql = $this->db->query($sql);
2856 $triggerName = array();
2857 $triggerName[0] =
'DRAFT';
2858 $triggerName[1] =
'VALIDATED';
2859 $triggerName[2] =
'APPROVED';
2860 $triggerName[3] =
'ORDERED';
2861 $triggerName[4] =
'RECEIVED_PARTIALLY';
2862 $triggerName[5] =
'RECEIVED_COMPLETELY';
2863 $triggerName[6] =
'CANCELED';
2864 $triggerName[7] =
'CANCELED';
2865 $triggerName[9] =
'REFUSED';
2868 $result = $this->
call_trigger(
"ORDER_SUPPLIER_STATUS_".$triggerName[$status], $user);
2875 $this->error = $this->db->lasterror();
2876 dol_syslog(get_class($this).
"::setStatus ".$this->error);
2881 $this->db->commit();
2884 $this->db->rollback();
2912 public function updateline($rowid, $desc, $pu, $qty, $remise_percent, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 0, $price_base_type =
'HT', $info_bits = 0, $type = 0, $notrigger = 0, $date_start = 0, $date_end = 0, $array_options = [], $fk_unit =
null, $pu_ht_devise = 0, $ref_supplier =
'')
2914 global $mysoc, $conf, $langs;
2915 dol_syslog(get_class($this).
"::updateline $rowid, $desc, $pu, $qty, $remise_percent, $txtva, $price_base_type, $info_bits, $type, $fk_unit");
2916 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
2920 if ($this->
statut == self::STATUS_DRAFT) {
2925 if (empty($info_bits)) {
2928 if (empty($txtva)) {
2931 if (empty($txlocaltax1)) {
2934 if (empty($txlocaltax2)) {
2937 if (empty($remise_percent)) {
2938 $remise_percent = 0;
2941 $remise_percent = (float)
price2num($remise_percent);
2947 $pu_ht_devise =
price2num($pu_ht_devise);
2948 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
2951 $txlocaltax1 = (float)
price2num($txlocaltax1);
2952 $txlocaltax2 = (float)
price2num($txlocaltax2);
2958 if ($date_start && $date_end && $date_start > $date_end) {
2959 $langs->load(
"errors");
2960 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
2976 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
2977 $vat_src_code = $reg[1];
2978 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
2981 $tabprice =
calcul_price_total($qty, $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $type, $this->thirdparty, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);
2982 $total_ht = $tabprice[0];
2983 $total_tva = $tabprice[1];
2984 $total_ttc = $tabprice[2];
2985 $total_localtax1 = $tabprice[9];
2986 $total_localtax2 = $tabprice[10];
2987 $pu_ht = $tabprice[3];
2988 $pu_tva = $tabprice[4];
2989 $pu_ttc = $tabprice[5];
2992 $multicurrency_total_ht = $tabprice[16];
2993 $multicurrency_total_tva = $tabprice[17];
2994 $multicurrency_total_ttc = $tabprice[18];
2995 $pu_ht_devise = $tabprice[19];
2997 $localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
2998 $localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
3002 $this->line->fetch($rowid);
3004 $oldline = clone $this->line;
3005 $this->line->oldline = $oldline;
3007 $this->line->context = $this->context;
3009 $this->line->fk_commande = $this->id;
3011 $this->line->desc = $desc;
3015 if ($qty < $this->line->packaging) {
3016 $qty = $this->line->packaging;
3018 if (!empty($this->line->packaging) && ($qty % $this->line->packaging) > 0) {
3019 $coeff = intval($qty / $this->line->packaging) + 1;
3020 $qty = $this->line->packaging * $coeff;
3021 setEventMessage($langs->trans(
'QtyRecalculatedWithPackaging'),
'mesgs');
3026 $this->line->qty = $qty;
3027 $this->line->ref_supplier = $ref_supplier;
3029 $this->line->vat_src_code = $vat_src_code;
3030 $this->line->tva_tx = $txtva;
3031 $this->line->localtax1_tx = $txlocaltax1;
3032 $this->line->localtax2_tx = $txlocaltax2;
3033 $this->line->localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
3034 $this->line->localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
3035 $this->line->remise_percent = $remise_percent;
3036 $this->line->subprice = $pu_ht;
3037 $this->line->info_bits = $info_bits;
3038 $this->line->total_ht = $total_ht;
3039 $this->line->total_tva = $total_tva;
3040 $this->line->total_localtax1 = $total_localtax1;
3041 $this->line->total_localtax2 = $total_localtax2;
3042 $this->line->total_ttc = $total_ttc;
3043 $this->line->product_type = $type;
3044 $this->line->special_code = $oldline->special_code;
3045 $this->line->rang = $oldline->rang;
3046 $this->line->origin = $this->origin;
3047 $this->line->fk_unit = $fk_unit;
3049 $this->line->date_start = $date_start;
3050 $this->line->date_end = $date_end;
3053 $this->line->fk_multicurrency = $this->fk_multicurrency;
3054 $this->line->multicurrency_code = $this->multicurrency_code;
3055 $this->line->multicurrency_subprice = $pu_ht_devise;
3056 $this->line->multicurrency_total_ht = $multicurrency_total_ht;
3057 $this->line->multicurrency_total_tva = $multicurrency_total_tva;
3058 $this->line->multicurrency_total_ttc = $multicurrency_total_ttc;
3060 $this->line->subprice = $pu_ht;
3061 $this->line->price = $this->line->subprice;
3063 $this->line->remise_percent = $remise_percent;
3065 if (is_array($array_options) && count($array_options) > 0) {
3067 foreach ($array_options as $key => $value) {
3068 $this->line->array_options[$key] = $array_options[$key];
3072 $result = $this->line->update($notrigger);
3078 $this->db->commit();
3081 $this->error = $this->db->lasterror();
3082 $this->db->rollback();
3086 $this->error =
"Order status makes operation forbidden";
3087 dol_syslog(get_class($this).
"::updateline ".$this->error, LOG_ERR);
3102 global $user, $langs, $conf;
3104 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
3106 dol_syslog(get_class($this).
"::initAsSpecimen");
3113 $sql =
"SELECT rowid";
3114 $sql .=
" FROM ".$this->db->prefix().
"product";
3115 $sql .=
" WHERE entity IN (".getEntity(
'product').
")";
3116 $sql .= $this->db->order(
"rowid",
"ASC");
3117 $sql .= $this->db->plimit(1);
3118 $resql = $this->db->query($sql);
3119 if ($resql && $this->db->num_rows($resql)) {
3120 $obj = $this->db->fetch_object($resql);
3121 $prodid = $obj->rowid;
3126 $this->
ref =
'SPECIMEN';
3127 $this->specimen = 1;
3130 $this->date_commande = $now;
3131 $this->date_lim_reglement = $this->date + 3600 * 24 * 30;
3132 $this->cond_reglement_code =
'RECEP';
3133 $this->mode_reglement_code =
'CHQ';
3135 $this->note_public =
'This is a comment (public)';
3136 $this->note_private =
'This is a comment (private)';
3138 $this->multicurrency_tx = 1;
3139 $this->multicurrency_code = $conf->currency;
3146 while ($xnbp < $nbp) {
3148 $line->desc = $langs->trans(
"Description").
" ".$xnbp;
3150 $line->subprice = 100;
3151 $line->tva_tx = 19.6;
3152 $line->localtax1_tx = 0;
3153 $line->localtax2_tx = 0;
3155 $line->total_ht = 50;
3156 $line->total_ttc = 59.8;
3157 $line->total_tva = 9.8;
3158 $line->remise_percent = 50;
3160 $line->total_ht = 100;
3161 $line->total_ttc = 119.6;
3162 $line->total_tva = 19.6;
3163 $line->remise_percent = 00;
3165 $line->fk_product = $prodid;
3167 $this->lines[$xnbp] = $line;
3169 $this->total_ht += $line->total_ht;
3170 $this->total_tva += $line->total_tva;
3171 $this->total_ttc += $line->total_ttc;
3187 $sql =
'SELECT c.rowid, date_creation as datec, tms as datem, date_valid as date_validation, date_approve as datea, date_approve2 as datea2,';
3188 $sql .=
' fk_user_author, fk_user_modif, fk_user_valid, fk_user_approve, fk_user_approve2';
3189 $sql .=
' FROM '.$this->db->prefix().
'commande_fournisseur as c';
3190 $sql .=
' WHERE c.rowid = '.((int) $id);
3192 $result = $this->db->query($sql);
3194 if ($this->db->num_rows($result)) {
3195 $obj = $this->db->fetch_object($result);
3197 $this->
id = $obj->rowid;
3199 $this->user_creation_id = $obj->fk_user_author;
3200 $this->user_validation_id = $obj->fk_user_valid;
3201 $this->user_modification_id = $obj->fk_user_modif;
3202 $this->user_approve_id = $obj->fk_user_approve;
3203 $this->user_approve_id2 = $obj->fk_user_approve2;
3205 $this->date_creation = $this->db->jdate($obj->datec);
3206 $this->date_modification = $this->db->jdate($obj->datem);
3207 $this->date_approve = $this->db->jdate($obj->datea);
3208 $this->date_approve2 = $this->db->jdate($obj->datea2);
3209 $this->date_validation = $this->db->jdate($obj->date_validation);
3211 $this->db->free($result);
3224 global $conf, $user;
3226 $this->nb = array();
3229 $sql =
"SELECT count(co.rowid) as nb";
3230 $sql .=
" FROM ".$this->db->prefix().
"commande_fournisseur as co";
3231 $sql .=
" LEFT JOIN ".$this->db->prefix().
"societe as s ON co.fk_soc = s.rowid";
3232 if (empty($user->socid) && !$user->hasRight(
"societe",
"client",
"voir") && !$user->socid) {
3233 $sql .=
" LEFT JOIN ".$this->db->prefix().
"societe_commerciaux as sc ON s.rowid = sc.fk_soc";
3234 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
3237 $sql .=
" ".$clause.
" co.entity IN (".
getEntity(
'supplier_order').
")";
3239 $resql = $this->db->query($sql);
3241 while ($obj = $this->db->fetch_object($resql)) {
3242 $this->nb[
"supplier_orders"] = $obj->nb;
3244 $this->db->free($resql);
3248 $this->error = $this->db->error();
3264 global $conf, $langs;
3266 $sql =
"SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date, c.total_ht";
3267 $sql .=
" FROM ".$this->db->prefix().
"commande_fournisseur as c";
3268 if (empty($user->socid) && !$user->hasRight(
"societe",
"client",
"voir") && !$user->socid) {
3269 $sql .=
" JOIN ".$this->db->prefix().
"societe_commerciaux as sc ON c.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
3271 $sql .=
" WHERE c.entity = ".$conf->entity;
3272 if ($mode ===
'awaiting') {
3273 $sql .=
" AND c.fk_statut IN (".self::STATUS_ORDERSENT.
", ".self::STATUS_RECEIVED_PARTIALLY.
")";
3275 $sql .=
" AND c.fk_statut IN (".self::STATUS_VALIDATED.
", ".self::STATUS_ACCEPTED.
")";
3278 $sql .=
" AND c.fk_soc = ".((int) $user->socid);
3281 $resql = $this->db->query($sql);
3286 $response->warning_delay = $conf->commande->fournisseur->warning_delay / 60 / 60 / 24;
3287 $response->label = $langs->trans(
"SuppliersOrdersToProcess");
3288 $response->labelShort = $langs->trans(
"Opened");
3289 $response->url = DOL_URL_ROOT.
'/fourn/commande/list.php?search_status=1,2&mainmenu=commercial&leftmenu=orders_suppliers';
3292 if ($mode ===
'awaiting') {
3293 $response->label = $langs->trans(
"SuppliersOrdersAwaitingReception");
3294 $response->labelShort = $langs->trans(
"AwaitingReception");
3295 $response->url = DOL_URL_ROOT.
'/fourn/commande/list.php?search_status=3,4&mainmenu=commercial&leftmenu=orders_suppliers';
3298 while ($obj = $this->db->fetch_object($resql)) {
3299 $commandestatic->delivery_date = $this->db->jdate($obj->delivery_date);
3300 $commandestatic->date_commande = $this->db->jdate($obj->date_commande);
3301 $commandestatic->statut = $obj->fk_statut;
3303 $response->nbtodo++;
3304 $response->total += $obj->total_ht;
3306 if ($commandestatic->hasDelay()) {
3307 $response->nbtodolate++;
3313 $this->error = $this->db->error();
3328 if ($this->methode_commande_id > 0) {
3329 $sql =
"SELECT rowid, code, libelle as label";
3330 $sql .=
" FROM ".$this->db->prefix().
'c_input_method';
3331 $sql .=
" WHERE active=1 AND rowid = ".((int) $this->methode_commande_id);
3333 $resql = $this->db->query($sql);
3335 if ($this->db->num_rows($resql)) {
3336 $obj = $this->db->fetch_object($resql);
3338 $string = $langs->trans($obj->code);
3339 if ($string == $obj->code) {
3340 $string = $obj->label !=
'-' ? $obj->label :
'';
3363 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
3365 global $conf, $langs;
3370 if (!empty($this->model_pdf)) {
3371 $modele = $this->model_pdf;
3377 if (empty($modele)) {
3380 $langs->load(
"suppliers");
3381 $outputlangs->load(
"products");
3383 $modelpath =
"core/modules/supplier_order/doc/";
3384 $result = $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
3397 if (empty($this->lines)) {
3404 foreach ($this->lines as $line) {
3405 if ($line->fk_product > 0) {
3407 $idp = $tmpproductfourn->find_min_price_product_fournisseur($line->fk_product, $line->qty, $this->thirdparty->id);
3410 if ($tmpproductfourn->delivery_time_days > $nb) {
3411 $nb = $tmpproductfourn->delivery_time_days;
3420 return $nb.
' '.$langs->trans(
'days');
3433 return $user->hasRight(
"fournisseur",
"commande");
3448 'commande_fournisseur'
3465 'commande_fournisseurdet'
3482 if ($this->
statut == self::STATUS_ORDERSENT || $this->
statut == self::STATUS_RECEIVED_PARTIALLY) {
3484 if (!empty($this->delivery_date)) {
3485 $date_to_test = $this->delivery_date;
3486 return $date_to_test && $date_to_test < ($now - $conf->commande->fournisseur->warning_delay);
3494 $date_to_test = $this->date_commande;
3496 return ($this->
statut > 0 && $this->
statut < 5) && $date_to_test && $date_to_test < ($now - $conf->commande->fournisseur->warning_delay);
3509 global $conf, $langs;
3511 $langs->load(
'orders');
3515 if ($this->
statut == self::STATUS_ORDERSENT || $this->
statut == self::STATUS_RECEIVED_PARTIALLY) {
3516 if (!empty($this->delivery_date)) {
3517 $text = $langs->trans(
"DeliveryDate").
' '.
dol_print_date($this->delivery_date,
'day');
3519 $text = $langs->trans(
"OrderDate").
' '.
dol_print_date($this->date_commande,
'day');
3522 $text = $langs->trans(
"OrderDate").
' '.
dol_print_date($this->date_commande,
'day');
3525 $text .=
' '.($conf->commande->fournisseur->warning_delay > 0 ?
'+' :
'-').
' '.round(abs($conf->commande->fournisseur->warning_delay) / 3600 / 24, 1).
' '.$langs->trans(
"days").
' < '.$langs->trans(
"Today");
3542 if (isModEnabled(
"supplier_order")) {
3543 require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.commande.dispatch.class.php';
3545 $qtydelivered = array();
3546 $qtywished = array();
3550 $filter = array(
't.fk_element' => $this->
id);
3552 $filter[
't.status'] = 1;
3555 $ret = $supplierorderdispatch->fetchAll(
'',
'', 0, 0, $filter);
3557 $this->error = $supplierorderdispatch->error;
3558 $this->errors = $supplierorderdispatch->errors;
3561 if (is_array($supplierorderdispatch->lines) && count($supplierorderdispatch->lines) > 0) {
3562 require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
3566 foreach ($supplierorderdispatch->lines as $line) {
3567 if (array_key_exists($line->fk_product, $qtydelivered)) {
3568 $qtydelivered[$line->fk_product] += $line->qty;
3570 $qtydelivered[$line->fk_product] = $line->qty;
3573 foreach ($this->lines as $line) {
3578 if (array_key_exists($line->fk_product, $qtywished)) {
3579 $qtywished[$line->fk_product] += $line->qty;
3581 $qtywished[$line->fk_product] = $line->qty;
3586 $diff_array = array_diff_assoc($qtydelivered, $qtywished);
3587 $keysinwishednotindelivered = array_diff(array_keys($qtywished), array_keys($qtydelivered));
3588 $keysindeliverednotinwished = array_diff(array_keys($qtydelivered), array_keys($qtywished));
3596 if (count($diff_array) == 0 && count($keysinwishednotindelivered) == 0 && count($keysindeliverednotinwished) == 0) {
3597 if ($closeopenorder) {
3599 $ret = $this->
Livraison($user, $date_liv,
'tot', $comment);
3607 $ret = $this->
Livraison($user, $date_liv,
'par', $comment);
3618 if (count($diff_array) > 0) {
3622 foreach ($diff_array as $key => $value) {
3624 if ($qtydelivered[$key] >= $qtywished[$key]) {
3631 if ($close == count($diff_array)) {
3633 if ($closeopenorder) {
3634 $ret = $this->
Livraison($user, $date_liv,
'tot', $comment);
3641 $ret = $this->
Livraison($user, $date_liv,
'par', $comment);
3649 $ret = $this->
Livraison($user, $date_liv,
'par', $comment);
3657 $ret = $this->
Livraison($user, $date_liv,
'par', $comment);
3679 $this->receptions = array();
3681 dol_syslog(get_class($this).
"::loadReceptions", LOG_DEBUG);
3683 $sql =
'SELECT cd.rowid, cd.fk_product,';
3684 $sql .=
' sum(cfd.qty) as qty';
3685 $sql .=
' FROM '.$this->db->prefix().
'receptiondet_batch as cfd,';
3686 if ($filtre_statut >= 0) {
3687 $sql .=
' '.$this->db->prefix().
'reception as e,';
3689 $sql .=
' '.$this->db->prefix().
'commande_fournisseurdet as cd';
3691 if ($filtre_statut >= 0) {
3692 $sql .=
' cfd.fk_reception = e.rowid AND';
3694 $sql .=
' cfd.fk_elementdet = cd.rowid';
3695 $sql .=
' AND cd.fk_commande ='.((int) $this->
id);
3696 if (isset($this->fk_product) && !empty($this->fk_product) > 0) {
3697 $sql .=
' AND cd.fk_product = '.((int) $this->fk_product);
3699 if ($filtre_statut >= 0) {
3700 $sql .=
' AND e.fk_statut >= '.((int) $filtre_statut);
3702 $sql .=
' GROUP BY cd.rowid, cd.fk_product';
3704 $resql = $this->db->query($sql);
3706 $num = $this->db->num_rows($resql);
3709 $obj = $this->db->fetch_object($resql);
3710 empty($this->receptions[$obj->rowid]) ? $this->receptions[$obj->rowid] = $obj->qty : $this->receptions[$obj->rowid] += $obj->qty;
3713 $this->db->free($resql);
3717 $this->error = $this->db->lasterror();
3733 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
3735 $return =
'<div class="box-flex-item box-flex-grow-zero">';
3736 $return .=
'<div class="info-box info-box-sm">';
3737 $return .=
'<span class="info-box-icon bg-infobox-action">';
3739 $return .=
'</span>';
3740 $return .=
'<div class="info-box-content">';
3741 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl() : $this->ref).
'</span>';
3742 if ($selected >= 0) {
3743 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
3745 if (property_exists($this,
'socid') || property_exists($this,
'total_tva')) {
3746 $return .=
'<br><span class="info-box-label amount">'.$this->socid.
'</span>';
3748 if (property_exists($this,
'billed')) {
3749 $return .=
'<br><span class="opacitymedium">'.$langs->trans(
"Billed").
' : </span><span class="info-box-label">'.
yn($this->billed).
'</span>';
3751 if (method_exists($this,
'getLibStatut')) {
3752 $return .=
'<br><div class="info-box-status">'.$this->getLibStatut(3).
'</div>';
3754 $return .=
'</div>';
3755 $return .=
'</div>';
3756 $return .=
'</div>';
3771 public $element =
'commande_fournisseurdet';
3776 public $table_element =
'commande_fournisseurdet';
3794 public $fk_commande;
3800 public $fk_parent_line;
3812 public $special_code = 0;
3822 public $fk_fournprice;
3832 public $ref_supplier;
3862 $sql =
'SELECT cd.rowid, cd.fk_commande, cd.fk_product, cd.product_type, cd.description, cd.qty, cd.tva_tx, cd.special_code,';
3863 $sql .=
' cd.localtax1_tx, cd.localtax2_tx, cd.localtax1_type, cd.localtax2_type, cd.ref as ref_supplier,';
3864 $sql .=
' cd.remise, cd.remise_percent, cd.subprice,';
3865 $sql .=
' cd.info_bits, cd.total_ht, cd.total_tva, cd.total_ttc,';
3866 $sql .=
' cd.total_localtax1, cd.total_localtax2,';
3867 $sql .=
' p.ref as product_ref, p.label as product_label, p.description as product_desc,';
3868 $sql .=
' cd.date_start, cd.date_end, cd.fk_unit,';
3869 $sql .=
' cd.multicurrency_subprice, cd.multicurrency_total_ht, cd.multicurrency_total_tva, cd.multicurrency_total_ttc,';
3870 $sql .=
' c.fk_soc as socid';
3871 $sql .=
' FROM '.$this->db->prefix().
'commande_fournisseur as c, '.$this->db->prefix().
'commande_fournisseurdet as cd';
3872 $sql .=
' LEFT JOIN '.$this->db->prefix().
'product as p ON cd.fk_product = p.rowid';
3873 $sql .=
' WHERE cd.fk_commande = c.rowid AND cd.rowid = '.((int) $rowid);
3875 $result = $this->db->query($sql);
3877 $objp = $this->db->fetch_object($result);
3879 if (!empty($objp)) {
3880 $this->
rowid = $objp->rowid;
3881 $this->
id = $objp->rowid;
3882 $this->fk_commande = $objp->fk_commande;
3883 $this->desc = $objp->description;
3884 $this->qty = $objp->qty;
3885 $this->ref_fourn = $objp->ref_supplier;
3886 $this->ref_supplier = $objp->ref_supplier;
3887 $this->subprice = $objp->subprice;
3888 $this->tva_tx = $objp->tva_tx;
3889 $this->localtax1_tx = $objp->localtax1_tx;
3890 $this->localtax2_tx = $objp->localtax2_tx;
3891 $this->localtax1_type = $objp->localtax1_type;
3892 $this->localtax2_type = $objp->localtax2_type;
3893 $this->remise = $objp->remise;
3894 $this->remise_percent = $objp->remise_percent;
3895 $this->fk_product = $objp->fk_product;
3896 $this->info_bits = $objp->info_bits;
3897 $this->total_ht = $objp->total_ht;
3898 $this->total_tva = $objp->total_tva;
3899 $this->total_localtax1 = $objp->total_localtax1;
3900 $this->total_localtax2 = $objp->total_localtax2;
3901 $this->total_ttc = $objp->total_ttc;
3902 $this->product_type = $objp->product_type;
3903 $this->special_code = $objp->special_code;
3905 $this->
ref = $objp->product_ref;
3907 $this->product_ref = $objp->product_ref;
3908 $this->product_label = $objp->product_label;
3909 $this->product_desc = $objp->product_desc;
3916 $sqlsearchpackage =
'SELECT rowid, packaging FROM '.$this->db->prefix().
"product_fournisseur_price";
3917 $sqlsearchpackage .=
' WHERE entity IN ('.getEntity(
'product_fournisseur_price').
")";
3918 $sqlsearchpackage .=
" AND fk_product = ".((int) $objp->fk_product);
3919 $sqlsearchpackage .=
" AND ref_fourn = '".$this->db->escape($objp->ref_supplier).
"'";
3920 $sqlsearchpackage .=
" AND quantity <= ".((float) $objp->qty);
3921 $sqlsearchpackage .=
" AND (packaging IS NULL OR packaging = 0 OR packaging <= ".((float) $objp->qty).
")";
3922 $sqlsearchpackage .=
" AND fk_soc = ".((int) $objp->socid);
3923 $sqlsearchpackage .=
" ORDER BY packaging ASC";
3924 $sqlsearchpackage .=
" LIMIT 1";
3926 $resqlsearchpackage = $this->db->query($sqlsearchpackage);
3927 if ($resqlsearchpackage) {
3928 $objsearchpackage = $this->db->fetch_object($resqlsearchpackage);
3929 if ($objsearchpackage) {
3930 $this->fk_fournprice = $objsearchpackage->rowid;
3931 $this->packaging = $objsearchpackage->packaging;
3934 $this->error = $this->db->lasterror();
3939 $this->date_start = $this->db->jdate($objp->date_start);
3940 $this->date_end = $this->db->jdate($objp->date_end);
3941 $this->fk_unit = $objp->fk_unit;
3943 $this->multicurrency_subprice = $objp->multicurrency_subprice;
3944 $this->multicurrency_total_ht = $objp->multicurrency_total_ht;
3945 $this->multicurrency_total_tva = $objp->multicurrency_total_tva;
3946 $this->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
3950 $this->db->free($result);
3953 $this->error =
'Supplier order line with id='.$rowid.
' not found';
3954 dol_syslog(get_class($this).
"::fetch Error ".$this->error, LOG_ERR);
3971 global $conf, $user;
3975 dol_syslog(get_class($this).
"::insert rang=".$this->rang);
3978 if (empty($this->tva_tx)) {
3981 if (empty($this->localtax1_tx)) {
3982 $this->localtax1_tx = 0;
3984 if (empty($this->localtax2_tx)) {
3985 $this->localtax2_tx = 0;
3987 if (empty($this->localtax1_type)) {
3988 $this->localtax1_type =
'0';
3990 if (empty($this->localtax2_type)) {
3991 $this->localtax2_type =
'0';
3993 if (empty($this->total_localtax1)) {
3994 $this->total_localtax1 = 0;
3996 if (empty($this->total_localtax2)) {
3997 $this->total_localtax2 = 0;
3999 if (empty($this->rang)) {
4002 if (empty($this->remise_percent)) {
4003 $this->remise_percent = 0;
4005 if (empty($this->info_bits)) {
4006 $this->info_bits = 0;
4008 if (empty($this->special_code)) {
4009 $this->special_code = 0;
4011 if (empty($this->fk_parent_line)) {
4012 $this->fk_parent_line = 0;
4014 if (empty($this->pa_ht)) {
4019 if (!empty($this->multicurrency_code)) {
4022 if (empty($this->fk_multicurrency)) {
4023 $this->multicurrency_code = $conf->currency;
4024 $this->fk_multicurrency = 0;
4025 $this->multicurrency_tx = 1;
4029 if ($this->product_type < 0) {
4036 $sql =
'INSERT INTO '.$this->db->prefix().$this->table_element;
4037 $sql .=
" (fk_commande, label, description, date_start, date_end,";
4038 $sql .=
" fk_product, product_type, special_code, rang,";
4039 $sql .=
" qty, vat_src_code, tva_tx, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, remise_percent, subprice, ref,";
4040 $sql .=
" total_ht, total_tva, total_localtax1, total_localtax2, total_ttc, fk_unit,";
4041 $sql .=
" fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc,";
4042 $sql .=
" fk_parent_line)";
4043 $sql .=
" VALUES (".$this->fk_commande.
", '".$this->db->escape($this->label).
"','".$this->db->escape($this->desc).
"',";
4044 $sql .=
" ".($this->date_start ?
"'".$this->db->idate($this->date_start).
"'" :
"null").
",";
4045 $sql .=
" ".($this->date_end ?
"'".$this->db->idate($this->date_end).
"'" :
"null").
",";
4046 if ($this->fk_product) {
4047 $sql .= $this->fk_product.
",";
4051 $sql .=
"'".$this->db->escape($this->product_type).
"',";
4052 $sql .= (int) $this->special_code .
",";
4053 $sql .=
"'".$this->db->escape($this->rang).
"',";
4054 $sql .=
"'".$this->db->escape($this->qty).
"', ";
4055 $sql .=
" ".(empty($this->vat_src_code) ?
"''" :
"'".$this->db->escape($this->vat_src_code).
"'").
",";
4056 $sql .=
" ".price2num($this->tva_tx).
", ";
4057 $sql .=
" ".price2num($this->localtax1_tx).
",";
4058 $sql .=
" ".price2num($this->localtax2_tx).
",";
4059 $sql .=
" '".$this->db->escape($this->localtax1_type).
"',";
4060 $sql .=
" '".$this->db->escape($this->localtax2_type).
"',";
4061 $sql .=
" ".((float) $this->remise_percent).
", ".
price2num($this->subprice,
'MU').
", '".$this->db->escape($this->ref_supplier).
"',";
4062 $sql .=
" ".price2num($this->total_ht).
",";
4063 $sql .=
" ".price2num($this->total_tva).
",";
4064 $sql .=
" ".price2num($this->total_localtax1).
",";
4065 $sql .=
" ".price2num($this->total_localtax2).
",";
4066 $sql .=
" ".price2num($this->total_ttc).
",";
4067 $sql .= ($this->fk_unit ?
"'".$this->db->escape($this->fk_unit).
"'" :
"null");
4068 $sql .=
", ".($this->fk_multicurrency ? ((int) $this->fk_multicurrency) :
"null");
4069 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
4070 $sql .=
", ".($this->multicurrency_subprice ?
price2num($this->multicurrency_subprice) :
'0');
4071 $sql .=
", ".($this->multicurrency_total_ht ?
price2num($this->multicurrency_total_ht) :
'0');
4072 $sql .=
", ".($this->multicurrency_total_tva ?
price2num($this->multicurrency_total_tva) :
'0');
4073 $sql .=
", ".($this->multicurrency_total_ttc ?
price2num($this->multicurrency_total_ttc) :
'0');
4074 $sql .=
", ".((!empty($this->fk_parent_line) && $this->fk_parent_line > 0) ? $this->fk_parent_line :
'null');
4077 dol_syslog(get_class($this).
"::insert", LOG_DEBUG);
4078 $resql = $this->db->query($sql);
4080 $this->
id = $this->db->last_insert_id($this->db->prefix().$this->table_element);
4081 $this->
rowid = $this->id;
4090 if (!$error && !$notrigger) {
4092 $result = $this->
call_trigger(
'LINEORDER_SUPPLIER_CREATE', $user);
4100 $this->db->commit();
4104 foreach ($this->errors as $errmsg) {
4105 dol_syslog(get_class($this).
"::delete ".$errmsg, LOG_ERR);
4106 $this->errors[] = ($this->errors ?
', '.$errmsg : $errmsg);
4108 $this->db->rollback();
4111 $this->errors[] = $this->db->error();
4112 $this->db->rollback();
4131 $sql =
"UPDATE ".$this->db->prefix().$this->table_element.
" SET";
4132 $sql .=
" description='".$this->db->escape($this->desc).
"'";
4133 $sql .=
", ref='".$this->db->escape($this->ref_supplier).
"'";
4134 $sql .=
", subprice='".price2num($this->subprice).
"'";
4136 $sql .=
", remise_percent='".price2num($this->remise_percent).
"'";
4138 $sql .=
", vat_src_code = '".(empty($this->vat_src_code) ?
'' : $this->vat_src_code).
"'";
4139 $sql .=
", tva_tx='".price2num($this->tva_tx).
"'";
4140 $sql .=
", localtax1_tx='".price2num($this->localtax1_tx).
"'";
4141 $sql .=
", localtax2_tx='".price2num($this->localtax2_tx).
"'";
4142 $sql .=
", localtax1_type='".$this->db->escape($this->localtax1_type).
"'";
4143 $sql .=
", localtax2_type='".$this->db->escape($this->localtax2_type).
"'";
4144 $sql .=
", qty='".price2num($this->qty).
"'";
4145 $sql .=
", date_start=".(!empty($this->date_start) ?
"'".$this->db->idate($this->date_start).
"'" :
"null");
4146 $sql .=
", date_end=".(!empty($this->date_end) ?
"'".$this->db->idate($this->date_end).
"'" :
"null");
4147 $sql .=
", info_bits='".$this->db->escape($this->info_bits).
"'";
4148 $sql .=
", total_ht='".price2num($this->total_ht).
"'";
4149 $sql .=
", total_tva='".price2num($this->total_tva).
"'";
4150 $sql .=
", total_localtax1='".price2num($this->total_localtax1).
"'";
4151 $sql .=
", total_localtax2='".price2num($this->total_localtax2).
"'";
4152 $sql .=
", total_ttc='".price2num($this->total_ttc).
"'";
4153 $sql .=
", product_type=".$this->product_type;
4154 $sql .=
", special_code=".(!empty($this->special_code) ? $this->special_code : 0);
4155 $sql .= ($this->fk_unit ?
", fk_unit='".$this->db->escape($this->fk_unit).
"'" :
", fk_unit=null");
4158 $sql .=
", multicurrency_subprice=".price2num($this->multicurrency_subprice);
4159 $sql .=
", multicurrency_total_ht=".price2num($this->multicurrency_total_ht);
4160 $sql .=
", multicurrency_total_tva=".price2num($this->multicurrency_total_tva);
4161 $sql .=
", multicurrency_total_ttc=".price2num($this->multicurrency_total_ttc);
4163 $sql .=
" WHERE rowid = ".((int) $this->
id);
4165 dol_syslog(get_class($this).
"::updateline", LOG_DEBUG);
4166 $resql = $this->db->query($sql);
4175 if (!$error && !$notrigger) {
4177 $result = $this->
call_trigger(
'LINEORDER_SUPPLIER_MODIFY', $user);
4179 $this->db->rollback();
4186 $this->db->commit();
4189 $this->db->rollback();
4193 $this->error = $this->db->lasterror();
4194 $this->db->rollback();
4206 public function delete($user, $notrigger = 0)
4219 $this->db->rollback();
4223 $sql1 =
'UPDATE '.$this->db->prefix().
"commandedet SET fk_commandefourndet = NULL WHERE fk_commandefourndet=".((int) $this->
id);
4224 $resql = $this->db->query($sql1);
4226 $this->db->rollback();
4230 $sql2 =
'DELETE FROM '.$this->db->prefix().
"commande_fournisseurdet WHERE rowid=".((int) $this->
id);
4233 $resql = $this->db->query($sql2);
4237 $result = $this->
call_trigger(
'LINEORDER_SUPPLIER_DELETE', $user);
4245 $this->db->commit();
4249 foreach ($this->errors as $errmsg) {
4250 dol_syslog(get_class($this).
"::delete ".$errmsg, LOG_ERR);
4251 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
4253 $this->db->rollback();
4256 $this->error = $this->db->lasterror();
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...
Class to manage table ReceptionLineBatch.
Class to manage predefined suppliers products.
const STATUS_CANCELED_AFTER_ORDER
Order canceled/never received.
const STATUS_RECEIVED_PARTIALLY
Received partially.
setDeliveryDate($user, $delivery_date, $notrigger=0)
Set the planned delivery date.
updateFromCommandeClient($user, $idc, $comclientid)
Update a supplier order from a sales order.
getNomUrl($withpicto=0, $option='', $notooltip=0, $save_lastsearch_value=-1, $addlinktonotes=0)
Return clicable name (with picto eventually)
loadReceptions($filtre_statut=-1)
Load array this->receptions of lines of shipments with nb of products sent for each order line Note: ...
static replaceProduct(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a product id with another one.
$fields
'type' field format ('integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter[:Sortf...
refuse($user)
Refuse an order.
set_date_livraison($user, $delivery_date, $notrigger=0)
Set delivery date.
getKanbanView($option='', $arraydata=null)
Return clicable link of object (with eventually picto)
info($id)
Charge les information d'ordre info dans l'objet facture.
const STATUS_CANCELED
Order canceled.
getNextNumRef($soc)
Returns the next order reference not used, based on the numbering model defined within COMMANDE_SUPPL...
fetch_lines($only_product=0)
Load array lines.
getInputMethod()
Returns the translated input method of object (defined if $this->methode_commande_id > 0).
const STATUS_VALIDATED
Validated status.
const STATUS_RECEIVED_COMPLETELY
Received completely.
addline($desc, $pu_ht, $qty, $txtva, $txlocaltax1=0.0, $txlocaltax2=0.0, $fk_product=0, $fk_prod_fourn_price=0, $ref_supplier='', $remise_percent=0.0, $price_base_type='HT', $pu_ttc=0.0, $type=0, $info_bits=0, $notrigger=0, $date_start=null, $date_end=null, $array_options=[], $fk_unit=null, $pu_ht_devise=0, $origin='', $origin_id=0, $rang=-1, $special_code=0)
Add order line.
loadStateBoard()
Load the indicators this->nb for the state board.
calcAndSetStatusDispatch(User $user, $closeopenorder=1, $comment='')
Calc status regarding to dispatched stock.
set_id_projet($user, $id_projet, $notrigger=0)
Set the id projet.
const STATUS_DRAFT
Draft status.
showDelay()
Show the customer delayed info.
getTooltipContentArray($params)
getTooltipContentArray
approve($user, $idwarehouse=0, $secondlevel=0)
Approve a supplier order.
__construct($db)
Constructor.
Cancel($user, $idwarehouse=-1)
Cancel an approved order.
dispatchProduct($user, $product, $qty, $entrepot, $price=0, $comment='', $eatby='', $sellby='', $batch='', $fk_commandefourndet=0, $notrigger=0, $fk_reception=0)
Save a receiving into the tracking table of receiving (receptiondet_batch) and add product into stock...
valid($user, $idwarehouse=0, $notrigger=0)
Validate an order.
create($user, $notrigger=0)
Create order with draft status.
update(User $user, $notrigger=0)
Update Supplier Order.
createFromClone(User $user, $socid=0, $notrigger=0)
Load an object from its id and create a new one in database.
updateline($rowid, $desc, $pu, $qty, $remise_percent, $txtva, $txlocaltax1=0, $txlocaltax2=0, $price_base_type='HT', $info_bits=0, $type=0, $notrigger=0, $date_start=0, $date_end=0, $array_options=[], $fk_unit=null, $pu_ht_devise=0, $ref_supplier='')
Update line.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template model.
const STATUS_ACCEPTED
Accepted.
const STATUS_ORDERSENT
Order sent, shipment on process.
commande($user, $date, $methode, $comment='')
Submit a supplier order to supplier.
getRights()
Returns the rights used for this class.
load_board($user, $mode='opened')
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
deleteLine($idline, $notrigger=0)
Delete line.
getMaxDeliveryTimeDay($langs)
Return the max number delivery delay in day.
fetch($id, $ref='')
Get object and lines from database.
Livraison($user, $date, $type, $comment)
Set a delivery in database for this supplier order.
getDispachedLines($status=-1)
Return array of dispatched lines waiting to be approved for this order.
classifyBilled(User $user)
Class invoiced the supplier order.
initAsSpecimen()
Initialise an instance with random values.
const SOURCE_ID_REPLENISHMENT
The constant used into source field to track the order was generated by the replenishement feature.
setStatus($user, $status)
Tag order with a particular status.
const STATUS_REFUSED
Refused.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
getLibStatut($mode=0)
Return label of the status of object.
hasDelay()
Is the supplier order delayed? We suppose a purchase ordered as late if a the purchase order has been...
LibStatut($status, $mode=0, $billed=0)
Return label of a status.
Class to manage line orders.
update($notrigger=0)
Update the line object into db.
insert($notrigger=0)
Insert line into database.
fetch($rowid)
Load line order.
__construct($db)
Constructor.
Class to manage customers orders.
fetch_optionals($rowid=null, $optionsArray=null)
Function to get extra fields of an object into $this->array_options This method is in most cases call...
line_order($renum=false, $rowidorder='ASC', $fk_parent_line=true)
Save a new position (field rang) for details lines.
deleteEcmFiles($mode=0)
Delete related files of object in database.
update_price($exclspec=0, $roundingadjust='auto', $nodatabaseupdate=0, $seller=null)
Update total_ht, total_ttc, total_vat, total_localtax1, total_localtax2 for an object (sum of lines).
add_object_linked($origin=null, $origin_id=null, $f_user=null, $notrigger=0)
Add an object link into llx_element_element.
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
fetch_thirdparty($force_thirdparty_id=0)
Load the third party of object, from id $this->socid or $this->fk_soc, into this->thirdparty.
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
Delete all links between an object $this.
setErrorsFromObject($object)
setErrorsFromObject
updateRangOfLine($rowid, $rang)
Update position of line (rang)
deleteExtraFields()
Delete all extra fields values for the current object.
fetchObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $clause='OR', $alsosametype=1, $orderby='sourcetype', $loadalsoobjects=1)
Fetch array of objects linked to current object (object of enabled modules only).
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
static commonReplaceProduct(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a product id with another one.
line_max($fk_parent_line=0)
Get max value used for position of line (rang)
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
call_trigger($triggerName, $user)
Call trigger based on this instance.
add_contact($fk_socpeople, $type_contact, $source='external', $notrigger=0)
Add a link between element $this->element and a contact.
Superclass for orders classes.
Superclass for orders classes.
Class to manage Dolibarr database access.
Class to manage stock movements.
static getIdFromCode($dbs, $code)
Get id of currency from code.
static getIdAndTxFromCode($dbs, $code, $date_document='')
Get id and rate of currency from code.
Class to manage predefined suppliers products.
Class to manage products or services.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
dol_delete_dir_recursive($dir, $count=0, $nophperrors=0, $onlysub=0, &$countdeleted=0, $indexdatabase=1, $nolog=0)
Remove a directory $dir and its subdirectories (or only files and subdirectories)
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_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.
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)
yn($yesno, $case=1, $color=0)
Return yes or no in current language.
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 '.
setEventMessage($mesgs, $style='mesgs', $noduplicate=0)
Set event message in dol_events session object.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
dol_concatdesc($text1, $text2, $forxml=false, $invert=false)
Concat 2 descriptions with a new line between them (second operand after first one with appropriate n...
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0)
Set event messages in dol_events session object.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
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 dolibarr global constant string value.
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...
calcul_price_total($qty, $pu, $remise_percent_ligne, $txtva, $uselocaltax1_rate, $uselocaltax2_rate, $remise_percent_global, $price_base_type, $info_bits, $type, $seller='', $localtaxes_array=[], $progress=100, $multicurrency_tx=1, $pu_devise=0, $multicurrency_code='')
Calculate totals (net, vat, ...) of a line.
publicphonebutton2 phonegreen basiclayout basiclayout TotalHT VATCode TotalVAT TotalLT1 TotalLT2 TotalTTC TotalHT clearboth nowraponall TAKEPOS_SHOW_SUBPRICE right right right takeposterminal SELECT e e e e e statut
publicphonebutton2 phonegreen basiclayout basiclayout TotalHT VATCode TotalVAT TotalLT1 TotalLT2 TotalTTC TotalHT clearboth nowraponall TAKEPOS_SHOW_SUBPRICE right right right takeposterminal SELECT e rowid