37 require_once DOL_DOCUMENT_ROOT.
'/core/class/commonorder.class.php';
38 require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
39 require_once DOL_DOCUMENT_ROOT.
'/multicurrency/class/multicurrency.class.php';
41 require_once DOL_DOCUMENT_ROOT.
'/product/class/productbatch.class.php';
53 public $element =
'order_supplier';
58 public $table_element =
'commande_fournisseur';
63 public $table_element_line =
'commande_fournisseurdet';
68 public $fk_element =
'fk_commande';
73 public $picto =
'supplier_order';
79 public $ismultientitymanaged = 1;
85 public $restrictiononfksoc = 1;
106 public $ref_supplier;
133 public $statuts_short;
140 public $date_creation;
142 public $date_approve;
143 public $date_approve2;
144 public $date_commande;
150 public $date_livraison;
155 public $delivery_date;
159 public $total_localtax1;
160 public $total_localtax2;
169 public $cond_reglement_id;
170 public $cond_reglement_code;
171 public $cond_reglement_label;
172 public $cond_reglement_doc;
182 public $mode_reglement_id;
187 public $mode_reglement_code;
192 public $mode_reglement;
193 public $user_author_id;
194 public $user_valid_id;
195 public $user_approve_id;
196 public $user_approve_id2;
200 public $extraparams = array();
205 public $lines = array();
215 public $linked_objects = array();
221 public $fk_multicurrency;
223 public $multicurrency_code;
224 public $multicurrency_tx;
225 public $multicurrency_total_ht;
226 public $multicurrency_total_tva;
227 public $multicurrency_total_ttc;
258 'rowid' =>array(
'type'=>
'integer',
'label'=>
'TechnicalID',
'enabled'=>1,
'visible'=>0,
'notnull'=>1,
'position'=>10),
259 'ref' =>array(
'type'=>
'varchar(255)',
'label'=>
'Ref',
'enabled'=>1,
'visible'=>1,
'showoncombobox'=>1,
'position'=>25,
'searchall'=>1),
260 'ref_ext' =>array(
'type'=>
'varchar(255)',
'label'=>
'Ref ext',
'enabled'=>1,
'visible'=>0,
'position'=>35),
261 'ref_supplier' =>array(
'type'=>
'varchar(255)',
'label'=>
'RefOrderSupplierShort',
'enabled'=>1,
'visible'=>1,
'position'=>40,
'searchall'=>1),
262 'fk_projet' =>array(
'type'=>
'integer:Project:projet/class/project.class.php:1:(fk_statut:=:1)',
'label'=>
'Project',
'enabled'=>
"isModEnabled('project')",
'visible'=>-1,
'position'=>45),
263 'date_valid' =>array(
'type'=>
'datetime',
'label'=>
'DateValidation',
'enabled'=>1,
'visible'=>-1,
'position'=>710),
264 'date_approve' =>array(
'type'=>
'datetime',
'label'=>
'DateApprove',
'enabled'=>1,
'visible'=>-1,
'position'=>720),
265 'date_approve2' =>array(
'type'=>
'datetime',
'label'=>
'DateApprove2',
'enabled'=>1,
'visible'=>3,
'position'=>725),
266 'date_commande' =>array(
'type'=>
'date',
'label'=>
'OrderDateShort',
'enabled'=>1,
'visible'=>1,
'position'=>70),
267 'date_livraison' =>array(
'type'=>
'datetime',
'label'=>
'DeliveryDate',
'enabled'=>
'empty($conf->global->ORDER_DISABLE_DELIVERY_DATE)',
'visible'=>1,
'position'=>74),
268 'fk_user_author' =>array(
'type'=>
'integer:User:user/class/user.class.php',
'label'=>
'UserAuthor',
'enabled'=>1,
'visible'=>3,
'position'=>41),
269 'fk_user_modif' =>array(
'type'=>
'integer:User:user/class/user.class.php',
'label'=>
'UserModif',
'enabled'=>1,
'visible'=>3,
'notnull'=>-1,
'position'=>80),
270 'fk_user_valid' =>array(
'type'=>
'integer:User:user/class/user.class.php',
'label'=>
'UserValidation',
'enabled'=>1,
'visible'=>3,
'position'=>711),
271 'fk_user_approve' =>array(
'type'=>
'integer:User:user/class/user.class.php',
'label'=>
'UserApproval',
'enabled'=>1,
'visible'=>3,
'position'=>721),
272 'fk_user_approve2' =>array(
'type'=>
'integer:User:user/class/user.class.php',
'label'=>
'UserApproval2',
'enabled'=>1,
'visible'=>3,
'position'=>726),
273 'source' =>array(
'type'=>
'smallint(6)',
'label'=>
'Source',
'enabled'=>1,
'visible'=>3,
'notnull'=>1,
'position'=>100),
274 'billed' =>array(
'type'=>
'smallint(6)',
'label'=>
'Billed',
'enabled'=>1,
'visible'=>1,
'position'=>710),
275 'total_ht' =>array(
'type'=>
'double(24,8)',
'label'=>
'AmountHT',
'enabled'=>1,
'visible'=>1,
'position'=>130,
'isameasure'=>1),
276 'total_tva' =>array(
'type'=>
'double(24,8)',
'label'=>
'AmountVAT',
'enabled'=>1,
'visible'=>1,
'position'=>135,
'isameasure'=>1),
277 'localtax1' =>array(
'type'=>
'double(24,8)',
'label'=>
'LT1',
'enabled'=>1,
'visible'=>3,
'position'=>140,
'isameasure'=>1),
278 'localtax2' =>array(
'type'=>
'double(24,8)',
'label'=>
'LT2',
'enabled'=>1,
'visible'=>3,
'position'=>145,
'isameasure'=>1),
279 'total_ttc' =>array(
'type'=>
'double(24,8)',
'label'=>
'AmountTTC',
'enabled'=>1,
'visible'=>-1,
'position'=>150,
'isameasure'=>1),
280 'note_public' =>array(
'type'=>
'html',
'label'=>
'NotePublic',
'enabled'=>1,
'visible'=>0,
'position'=>750,
'searchall'=>1),
281 'note_private' =>array(
'type'=>
'html',
'label'=>
'NotePrivate',
'enabled'=>1,
'visible'=>0,
'position'=>760,
'searchall'=>1),
282 'model_pdf' =>array(
'type'=>
'varchar(255)',
'label'=>
'ModelPDF',
'enabled'=>1,
'visible'=>0,
'position'=>165),
283 'fk_input_method' =>array(
'type'=>
'integer',
'label'=>
'OrderMode',
'enabled'=>1,
'visible'=>3,
'position'=>170),
284 'fk_cond_reglement' =>array(
'type'=>
'integer',
'label'=>
'PaymentTerm',
'enabled'=>1,
'visible'=>3,
'position'=>175),
285 'fk_mode_reglement' =>array(
'type'=>
'integer',
'label'=>
'PaymentMode',
'enabled'=>1,
'visible'=>3,
'position'=>180),
286 'extraparams' =>array(
'type'=>
'varchar(255)',
'label'=>
'Extraparams',
'enabled'=>1,
'visible'=>0,
'position'=>190),
287 'fk_account' =>array(
'type'=>
'integer',
'label'=>
'BankAccount',
'enabled'=>
'isModEnabled("banque")',
'visible'=>3,
'position'=>200),
288 'fk_incoterms' =>array(
'type'=>
'integer',
'label'=>
'IncotermCode',
'enabled'=>1,
'visible'=>3,
'position'=>205),
289 'location_incoterms' =>array(
'type'=>
'varchar(255)',
'label'=>
'IncotermLocation',
'enabled'=>1,
'visible'=>3,
'position'=>210),
290 'fk_multicurrency' =>array(
'type'=>
'integer',
'label'=>
'Fk multicurrency',
'enabled'=>1,
'visible'=>0,
'position'=>215),
291 'multicurrency_code' =>array(
'type'=>
'varchar(255)',
'label'=>
'Currency',
'enabled'=>
'isModEnabled("multicurrency")',
'visible'=>-1,
'position'=>220),
292 'multicurrency_tx' =>array(
'type'=>
'double(24,8)',
'label'=>
'CurrencyRate',
'enabled'=>
'isModEnabled("multicurrency")',
'visible'=>-1,
'position'=>225),
293 'multicurrency_total_ht' =>array(
'type'=>
'double(24,8)',
'label'=>
'MulticurrencyAmountHT',
'enabled'=>
'isModEnabled("multicurrency")',
'visible'=>-1,
'position'=>230),
294 'multicurrency_total_tva' =>array(
'type'=>
'double(24,8)',
'label'=>
'MulticurrencyAmountVAT',
'enabled'=>
'isModEnabled("multicurrency")',
'visible'=>-1,
'position'=>235),
295 'multicurrency_total_ttc' =>array(
'type'=>
'double(24,8)',
'label'=>
'MulticurrencyAmountTTC',
'enabled'=>
'isModEnabled("multicurrency")',
'visible'=>-1,
'position'=>240),
296 'date_creation' =>array(
'type'=>
'datetime',
'label'=>
'Date creation',
'enabled'=>1,
'visible'=>-1,
'position'=>500),
297 'fk_soc' =>array(
'type'=>
'integer:Societe:societe/class/societe.class.php',
'label'=>
'ThirdParty',
'enabled'=>
'isModEnabled("societe")',
'visible'=>1,
'notnull'=>1,
'position'=>50),
298 'entity' =>array(
'type'=>
'integer',
'label'=>
'Entity',
'default'=>1,
'enabled'=>1,
'visible'=>0,
'notnull'=>1,
'position'=>1000,
'index'=>1),
299 'tms'=>array(
'type'=>
'datetime',
'label'=>
"DateModificationShort",
'enabled'=>1,
'visible'=>-1,
'notnull'=>1,
'position'=>501),
300 'last_main_doc' =>array(
'type'=>
'varchar(255)',
'label'=>
'LastMainDoc',
'enabled'=>1,
'visible'=>0,
'position'=>700),
301 'fk_statut' =>array(
'type'=>
'smallint(6)',
'label'=>
'Status',
'enabled'=>1,
'visible'=>1,
'position'=>701),
302 'import_key' =>array(
'type'=>
'varchar(14)',
'label'=>
'ImportId',
'enabled'=>1,
'visible'=>0,
'position'=>900),
377 public function fetch($id, $ref =
'')
382 if (empty($id) && empty($ref)) {
386 $sql =
"SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.total_tva,";
387 $sql .=
" c.localtax1, c.localtax2, ";
388 $sql .=
" c.date_creation, c.date_valid, c.date_approve, c.date_approve2,";
389 $sql .=
" c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2,";
390 $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,";
391 $sql .=
" c.fk_account,";
392 $sql .=
" c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed,";
393 $sql .=
" c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc,";
394 $sql .=
" cm.libelle as methode_commande,";
395 $sql .=
" cr.code as cond_reglement_code, cr.libelle as cond_reglement_label, cr.libelle_facture as cond_reglement_doc,";
396 $sql .=
" p.code as mode_reglement_code, p.libelle as mode_reglement_libelle";
397 $sql .=
', c.fk_incoterms, c.location_incoterms';
398 $sql .=
', i.libelle as label_incoterms';
399 $sql .=
" FROM ".MAIN_DB_PREFIX.
"commande_fournisseur as c";
400 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_payment_term as cr ON c.fk_cond_reglement = cr.rowid";
401 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_paiement as p ON c.fk_mode_reglement = p.id";
402 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_input_method as cm ON cm.rowid = c.fk_input_method";
403 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_incoterms as i ON c.fk_incoterms = i.rowid';
406 $sql .=
" WHERE c.entity IN (".getEntity(
'supplier_order').
")";
408 $sql .=
" WHERE c.rowid=".((int) $id);
412 $sql .=
" AND c.ref='".$this->db->escape($ref).
"'";
415 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
416 $resql = $this->db->query(
$sql);
418 $obj = $this->db->fetch_object($resql);
420 $this->error =
'Bill with id '.$id.
' not found';
421 dol_syslog(get_class($this).
'::fetch '.$this->error);
425 $this->
id = $obj->rowid;
426 $this->entity = $obj->entity;
428 $this->
ref = $obj->ref;
429 $this->ref_supplier = $obj->ref_supplier;
430 $this->socid = $obj->fk_soc;
431 $this->fourn_id = $obj->fk_soc;
432 $this->statut = $obj->fk_statut;
433 $this->status = $obj->fk_statut;
434 $this->billed = $obj->billed;
435 $this->user_author_id = $obj->fk_user_author;
436 $this->user_valid_id = $obj->fk_user_valid;
437 $this->user_approve_id = $obj->fk_user_approve;
438 $this->user_approve_id2 = $obj->fk_user_approve2;
439 $this->total_ht = $obj->total_ht;
440 $this->total_tva = $obj->total_tva;
441 $this->total_localtax1 = $obj->localtax1;
442 $this->total_localtax2 = $obj->localtax2;
443 $this->total_ttc = $obj->total_ttc;
444 $this->date_creation = $this->db->jdate($obj->date_creation);
445 $this->date_valid = $this->db->jdate($obj->date_valid);
446 $this->date_approve = $this->db->jdate($obj->date_approve);
447 $this->date_approve2 = $this->db->jdate($obj->date_approve2);
448 $this->date_commande = $this->db->jdate($obj->date_commande);
449 if (isset($obj->date_commande)) {
450 $this->date = $this->date_commande;
452 $this->date = $this->date_creation;
454 $this->date_livraison = $this->db->jdate($obj->delivery_date);
455 $this->delivery_date = $this->db->jdate($obj->delivery_date);
456 $this->remise_percent = $obj->remise_percent;
457 $this->methode_commande_id = $obj->fk_input_method;
458 $this->methode_commande = $obj->methode_commande;
460 $this->source = $obj->source;
461 $this->fk_project = $obj->fk_project;
462 $this->cond_reglement_id = $obj->fk_cond_reglement;
463 $this->cond_reglement_code = $obj->cond_reglement_code;
464 $this->cond_reglement = $obj->cond_reglement_label;
465 $this->cond_reglement_label = $obj->cond_reglement_label;
466 $this->cond_reglement_doc = $obj->cond_reglement_doc;
467 $this->fk_account = $obj->fk_account;
468 $this->mode_reglement_id = $obj->fk_mode_reglement;
469 $this->mode_reglement_code = $obj->mode_reglement_code;
470 $this->mode_reglement = $obj->mode_reglement_libelle;
471 $this->note = $obj->note_private;
472 $this->note_private = $obj->note_private;
473 $this->note_public = $obj->note_public;
474 $this->model_pdf = $obj->model_pdf;
475 $this->modelpdf = $obj->model_pdf;
478 $this->fk_incoterms = $obj->fk_incoterms;
479 $this->location_incoterms = $obj->location_incoterms;
480 $this->label_incoterms = $obj->label_incoterms;
483 $this->fk_multicurrency = $obj->fk_multicurrency;
484 $this->multicurrency_code = $obj->multicurrency_code;
485 $this->multicurrency_tx = $obj->multicurrency_tx;
486 $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
487 $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
488 $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
490 $this->extraparams = isset($obj->extraparams) ? (array) json_decode($obj->extraparams,
true) : array();
492 $this->db->free($resql);
498 if ($this->statut == 0) {
499 $this->brouillon = 1;
513 $this->error = $this->db->error().
" sql=".
$sql;
530 $this->lines = array();
532 $sql =
"SELECT l.rowid, l.fk_commande, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty,";
533 $sql .=
" l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice,";
534 $sql .=
" l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2,";
535 $sql .=
" l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang,";
536 $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,";
537 $sql .=
" l.fk_unit,";
538 $sql .=
" l.date_start, l.date_end,";
539 $sql .=
' l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc';
540 $sql .=
" FROM ".MAIN_DB_PREFIX.
"commande_fournisseurdet as l";
541 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON l.fk_product = p.rowid';
542 $sql .=
" WHERE l.fk_commande = ".((int) $this->
id);
544 $sql .=
' AND p.fk_product_type = 0';
546 $sql .=
" ORDER BY l.rang, l.rowid";
549 dol_syslog(get_class($this).
"::fetch_lines", LOG_DEBUG);
551 $result = $this->db->query(
$sql);
553 $num = $this->db->num_rows($result);
557 $objp = $this->db->fetch_object($result);
561 $line->id = $objp->rowid;
562 $line->fk_commande = $objp->fk_commande;
563 $line->desc = $objp->description;
564 $line->description = $objp->description;
565 $line->qty = $objp->qty;
566 $line->tva_tx = $objp->tva_tx;
567 $line->localtax1_tx = $objp->localtax1_tx;
568 $line->localtax2_tx = $objp->localtax2_tx;
569 $line->localtax1_type = $objp->localtax1_type;
570 $line->localtax2_type = $objp->localtax2_type;
571 $line->subprice = $objp->subprice;
572 $line->pu_ht = $objp->subprice;
573 $line->remise_percent = $objp->remise_percent;
575 $line->vat_src_code = $objp->vat_src_code;
576 $line->total_ht = $objp->total_ht;
577 $line->total_tva = $objp->total_tva;
578 $line->total_localtax1 = $objp->total_localtax1;
579 $line->total_localtax2 = $objp->total_localtax2;
580 $line->total_ttc = $objp->total_ttc;
581 $line->product_type = $objp->product_type;
583 $line->fk_product = $objp->fk_product;
585 $line->libelle = $objp->product_label;
586 $line->product_label = $objp->product_label;
587 $line->product_desc = $objp->product_desc;
588 $line->product_tobatch = $objp->product_tobatch;
589 $line->product_barcode = $objp->product_barcode;
591 $line->ref = $objp->product_ref;
592 $line->product_ref = $objp->product_ref;
593 $line->ref_fourn = $objp->ref_supplier;
594 $line->ref_supplier = $objp->ref_supplier;
596 if (!empty($conf->global->PRODUCT_USE_SUPPLIER_PACKAGING)) {
601 $sqlsearchpackage =
'SELECT rowid, packaging FROM '.MAIN_DB_PREFIX.
"product_fournisseur_price";
602 $sqlsearchpackage .=
' WHERE entity IN ('.getEntity(
'product_fournisseur_price').
")";
603 $sqlsearchpackage .=
" AND fk_product = ".((int) $objp->fk_product);
604 $sqlsearchpackage .=
" AND ref_fourn = '".$this->db->escape($objp->ref_supplier).
"'";
605 $sqlsearchpackage .=
" AND quantity <= ".((float) $objp->qty);
606 $sqlsearchpackage .=
" AND (packaging IS NULL OR packaging = 0 OR packaging <= ".((float) $objp->qty).
")";
607 $sqlsearchpackage .=
" AND fk_soc = ".((int) $this->socid);
608 $sqlsearchpackage .=
" ORDER BY packaging ASC";
609 $sqlsearchpackage .=
" LIMIT 1";
611 $resqlsearchpackage = $this->db->query($sqlsearchpackage);
612 if ($resqlsearchpackage) {
613 $objsearchpackage = $this->db->fetch_object($resqlsearchpackage);
614 if ($objsearchpackage) {
615 $line->fk_fournprice = $objsearchpackage->rowid;
616 $line->packaging = $objsearchpackage->packaging;
619 $this->error = $this->db->lasterror();
624 $line->date_start = $this->db->jdate($objp->date_start);
625 $line->date_end = $this->db->jdate($objp->date_end);
626 $line->fk_unit = $objp->fk_unit;
629 $line->fk_multicurrency = $objp->fk_multicurrency;
630 $line->multicurrency_code = $objp->multicurrency_code;
631 $line->multicurrency_subprice = $objp->multicurrency_subprice;
632 $line->multicurrency_total_ht = $objp->multicurrency_total_ht;
633 $line->multicurrency_total_tva = $objp->multicurrency_total_tva;
634 $line->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
636 $line->special_code = $objp->special_code;
637 $line->fk_parent_line = $objp->fk_parent_line;
639 $line->rang = $objp->rang;
643 $line->fetch_optionals();
645 $this->lines[$i] = $line;
649 $this->db->free($result);
653 $this->error = $this->db->error().
" sql=".
$sql;
666 public function valid($user, $idwarehouse = 0, $notrigger = 0)
668 global $langs, $conf;
669 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
675 if ((empty($conf->global->MAIN_USE_ADVANCED_PERMS) && ($user->hasRight(
"fournisseur",
"commande",
"creer") || $user->hasRight(
"supplier_order",
"creer")))
676 || (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && $user->hasRight(
"fournisseur",
"supplier_order_advance",
"validate"))) {
681 $soc->fetch($this->fourn_id);
684 if (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref)) {
691 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"commande_fournisseur";
692 $sql .=
" SET ref='".$this->db->escape($num).
"',";
693 $sql .=
" fk_statut = ".self::STATUS_VALIDATED.
",";
694 $sql .=
" date_valid='".$this->db->idate(
dol_now()).
"',";
695 $sql .=
" fk_user_valid = ".((int) $user->id);
696 $sql .=
" WHERE rowid = ".((int) $this->
id);
697 $sql .=
" AND fk_statut = ".self::STATUS_DRAFT;
699 $resql = $this->db->query(
$sql);
705 if (!$error && !$notrigger) {
707 $result = $this->
call_trigger(
'ORDER_SUPPLIER_VALIDATE', $user);
715 $this->oldref = $this->ref;
718 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
720 $sql =
'UPDATE '.MAIN_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).
"'";
721 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'fournisseur/commande/".$this->db->escape($this->
ref).
"' and entity = ".((int) $conf->entity);
722 $resql = $this->db->query(
$sql);
724 $error++; $this->error = $this->db->lasterror();
726 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'fournisseur/commande/".$this->db->escape($this->newref).
"'";
727 $sql .=
" WHERE filepath = 'fournisseur/commande/".$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
728 $resql = $this->db->query(
$sql);
730 $error++; $this->error = $this->db->lasterror();
736 $dirsource = $conf->fournisseur->commande->dir_output.
'/'.$oldref;
737 $dirdest = $conf->fournisseur->commande->dir_output.
'/'.$newref;
738 if (!$error && file_exists($dirsource)) {
739 dol_syslog(get_class($this).
"::valid rename dir ".$dirsource.
" into ".$dirdest);
741 if (@rename($dirsource, $dirdest)) {
744 $listoffiles =
dol_dir_list($conf->fournisseur->commande->dir_output.
'/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
745 foreach ($listoffiles as $fileentry) {
746 $dirsource = $fileentry[
'name'];
747 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
748 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
749 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
750 @rename($dirsource, $dirdest);
767 $this->db->rollback();
771 $this->error =
'NotAuthorized';
772 dol_syslog(get_class($this).
"::valid ".$this->error, LOG_ERR);
785 return $this->
LibStatut($this->statut, $mode, $this->billed);
797 public function LibStatut($status, $mode = 0, $billed = 0)
800 global $conf, $langs, $hookmanager;
802 if (empty($this->statuts) || empty($this->statuts_short)) {
803 $langs->load(
'orders');
805 $this->statuts[0] =
'StatusSupplierOrderDraft';
806 $this->statuts[1] =
'StatusSupplierOrderValidated';
807 $this->statuts[2] =
'StatusSupplierOrderApproved';
808 if (empty($conf->global->SUPPLIER_ORDER_USE_DISPATCH_STATUS)) {
809 $this->statuts[3] =
'StatusSupplierOrderOnProcess';
811 $this->statuts[3] =
'StatusSupplierOrderOnProcessWithValidation';
813 $this->statuts[4] =
'StatusSupplierOrderReceivedPartially';
814 $this->statuts[5] =
'StatusSupplierOrderReceivedAll';
815 $this->statuts[6] =
'StatusSupplierOrderCanceled';
816 $this->statuts[7] =
'StatusSupplierOrderCanceled';
817 $this->statuts[9] =
'StatusSupplierOrderRefused';
820 $this->statuts_short[0] =
'StatusSupplierOrderDraftShort';
821 $this->statuts_short[1] =
'StatusSupplierOrderValidatedShort';
822 $this->statuts_short[2] =
'StatusSupplierOrderApprovedShort';
823 $this->statuts_short[3] =
'StatusSupplierOrderOnProcessShort';
824 $this->statuts_short[4] =
'StatusSupplierOrderReceivedPartiallyShort';
825 $this->statuts_short[5] =
'StatusSupplierOrderReceivedAllShort';
826 $this->statuts_short[6] =
'StatusSupplierOrderCanceledShort';
827 $this->statuts_short[7] =
'StatusSupplierOrderCanceledShort';
828 $this->statuts_short[9] =
'StatusSupplierOrderRefusedShort';
831 $statustrans = array(
843 $statusClass =
'status0';
844 if (!empty($statustrans[$status])) {
845 $statusClass = $statustrans[$status];
850 $billedtext =
' - '.$langs->trans(
"Billed");
852 if ($status == 5 && $billed) {
853 $statusClass =
'status6';
856 $statusLong = $langs->transnoentitiesnoconv($this->statuts[$status]).$billedtext;
857 $statusShort = $langs->transnoentitiesnoconv($this->statuts_short[$status]);
859 $parameters = array(
'status' => $status,
'mode' => $mode,
'billed' => $billed);
860 $reshook = $hookmanager->executeHooks(
'LibStatut', $parameters, $this);
862 return $hookmanager->resPrint;
865 return dolGetStatus($statusLong, $statusShort,
'', $statusClass, $mode);
877 global $conf, $langs, $user;
879 $langs->loadLangs([
'bills',
'orders']);
882 $nofetch = !empty($params[
'nofetch']);
884 if ($user->hasRight(
"fournisseur",
"commande",
"read")) {
885 $datas[
'picto'] =
'<u class="paddingrightonly">'.$langs->trans(
"SupplierOrder").
'</u>';
886 if (isset($this->statut)) {
887 $datas[
'picto'] .=
' '.$this->getLibStatut(5);
889 if (!empty($this->
ref)) {
890 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
892 if (!empty($this->ref_supplier)) {
893 $datas[
'refsupplier'] =
'<br><b>'.$langs->trans(
'RefSupplier').
':</b> '.$this->ref_supplier;
896 $langs->load(
'companies');
897 if (empty($this->thirdparty)) {
900 $datas[
'supplier'] =
'<br><b>'.$langs->trans(
'Supplier').
':</b> '.$this->thirdparty->getNomUrl(1,
'', 0, 1);
902 if (!empty($this->total_ht)) {
903 $datas[
'totalht'] =
'<br><b>'.$langs->trans(
'AmountHT').
':</b> '.
price($this->total_ht, 0, $langs, 0, -1, -1, $conf->currency);
905 if (!empty($this->total_tva)) {
906 $datas[
'totaltva'] =
'<br><b>'.$langs->trans(
'VAT').
':</b> '.
price($this->total_tva, 0, $langs, 0, -1, -1, $conf->currency);
908 if (!empty($this->total_ttc)) {
909 $datas[
'totalttc'] =
'<br><b>'.$langs->trans(
'AmountTTC').
':</b> '.
price($this->total_ttc, 0, $langs, 0, -1, -1, $conf->currency);
911 if (!empty($this->date)) {
912 $datas[
'date'] =
'<br><b>'.$langs->trans(
'Date').
':</b> '.
dol_print_date($this->date,
'day');
914 if (!empty($this->delivery_date)) {
915 $datas[
'deliverydate'] =
'<br><b>'.$langs->trans(
'DeliveryDate').
':</b> '.
dol_print_date($this->delivery_date,
'dayhour');
931 public function getNomUrl($withpicto = 0, $option =
'', $notooltip = 0, $save_lastsearch_value = -1, $addlinktonotes = 0)
933 global $langs, $conf, $user, $hookmanager;
938 'objecttype' => $this->element,
942 $classfortooltip =
'classfortooltip';
945 $classfortooltip =
'classforajaxtooltip';
946 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
952 $url = DOL_URL_ROOT.
'/fourn/commande/card.php?id='.$this->id;
954 if ($option !==
'nolink') {
956 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
957 if ($save_lastsearch_value == -1 && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
958 $add_save_lastsearch_values = 1;
960 if ($add_save_lastsearch_values) {
961 $url .=
'&save_lastsearch_values=1';
966 if (empty($notooltip)) {
967 if (!empty($conf->global->MAIN_OPTIMIZEFORTEXTBROWSER)) {
968 $label = $langs->trans(
"ShowOrder");
969 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1).
'"';
971 $linkclose .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
972 $linkclose .= $dataparams.
' class="'.$classfortooltip.
'"';
975 $linkstart =
'<a href="'.$url.
'"';
976 $linkstart .= $linkclose.
'>';
979 $result .= $linkstart;
981 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), (($withpicto != 2) ?
'class="paddingright"' :
''), 0, 0, $notooltip ? 0 : 1);
983 if ($withpicto != 2) {
984 $result .= $this->ref;
988 if ($addlinktonotes) {
989 $txttoshow = ($user->socid > 0 ? $this->note_public : $this->note_private);
992 $result .=
' <span class="note inline-block">';
993 $result .=
'<a href="'.DOL_URL_ROOT.
'/fourn/commande/note.php?id='.$this->
id.
'" class="classfortooltip" title="'.
dol_escape_htmltag($notetoshow).
'">';
998 $result .=
'</span>';
1003 $hookmanager->initHooks(array($this->element .
'dao'));
1004 $parameters = array(
'id'=>$this->
id,
'getnomurl' => &$result);
1005 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
1007 $result = $hookmanager->resPrint;
1009 $result .= $hookmanager->resPrint;
1024 global $db, $langs, $conf;
1025 $langs->load(
"orders");
1027 if (!empty($conf->global->COMMANDE_SUPPLIER_ADDON_NUMBER)) {
1034 $dirmodels = array_merge(array(
'/'), (array) $conf->modules_parts[
'models']);
1036 foreach ($dirmodels as $reldir) {
1037 $dir =
dol_buildpath($reldir.
"core/modules/supplier_order/");
1040 $mybool |= @include_once $dir.$file;
1043 if ($mybool ===
false) {
1048 $obj =
new $classname();
1049 $numref = $obj->getNextValue($soc, $this);
1051 if ($numref !=
"") {
1054 $this->error = $obj->error;
1058 $this->error =
"Error_COMMANDE_SUPPLIER_ADDON_NotDefined";
1072 if ($this->billed) {
1078 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'commande_fournisseur SET billed = 1';
1081 if ($this->db->query(
$sql)) {
1084 $result = $this->
call_trigger(
'ORDER_SUPPLIER_CLASSIFY_BILLED', $user);
1094 $this->db->commit();
1097 $this->db->rollback();
1103 $this->db->rollback();
1116 public function approve($user, $idwarehouse = 0, $secondlevel = 0)
1118 global $langs, $conf;
1119 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1125 if ($user->hasRight(
"fournisseur",
"commande",
"approuver")) {
1131 $soc =
new Societe($this->db);
1132 $soc->fetch($this->fourn_id);
1135 if (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref)) {
1143 $movetoapprovestatus =
true;
1146 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur";
1147 $sql .=
" SET ref='".$this->db->escape($num).
"',";
1148 if (empty($secondlevel)) {
1149 $sql .=
" date_approve='".$this->db->idate($now).
"',";
1150 $sql .=
" fk_user_approve = ".$user->id;
1151 if (!empty($conf->global->SUPPLIER_ORDER_3_STEPS_TO_BE_APPROVED) && $this->total_ht >= $conf->global->SUPPLIER_ORDER_3_STEPS_TO_BE_APPROVED) {
1152 if (empty($this->user_approve_id2)) {
1153 $movetoapprovestatus =
false;
1154 $comment =
' (first level)';
1159 $sql .=
" date_approve2='".$this->db->idate($now).
"',";
1160 $sql .=
" fk_user_approve2 = ".((int) $user->id);
1161 if (empty($this->user_approve_id)) {
1162 $movetoapprovestatus =
false;
1164 $comment =
' (second level)';
1167 if ($movetoapprovestatus) {
1168 $sql .=
", fk_statut = ".self::STATUS_ACCEPTED;
1170 $sql .=
", fk_statut = ".self::STATUS_VALIDATED;
1172 $sql .=
" WHERE rowid = ".((int) $this->
id);
1173 $sql .=
" AND fk_statut = ".self::STATUS_VALIDATED;
1175 if ($this->db->query(
$sql)) {
1176 if (!empty($conf->global->SUPPLIER_ORDER_AUTOADD_USER_CONTACT)) {
1177 $result = $this->
add_contact($user->id,
'SALESREPFOLL',
'internal', 1);
1178 if ($result < 0 && $result != -2) {
1184 if (!$error && $movetoapprovestatus &&
isModEnabled(
'stock') && !empty($conf->global->STOCK_CALCULATE_ON_SUPPLIER_VALIDATE_ORDER)) {
1185 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
1186 $langs->load(
"agenda");
1188 $cpt = count($this->lines);
1189 for ($i = 0; $i < $cpt; $i++) {
1191 if ($this->lines[$i]->fk_product > 0) {
1192 $this->line = $this->lines[$i];
1194 $mouvP->origin = &$this;
1195 $mouvP->setOrigin($this->element, $this->
id);
1197 $up_ht_disc = $this->lines[$i]->subprice;
1198 if (!empty($this->lines[$i]->remise_percent) && empty($conf->global->STOCK_EXCLUDE_DISCOUNT_FOR_PMP)) {
1199 $up_ht_disc =
price2num($up_ht_disc * (100 - $this->lines[$i]->remise_percent) / 100,
'MU');
1201 $result = $mouvP->reception($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, $up_ht_disc, $langs->trans(
"OrderApprovedInDolibarr", $this->ref));
1212 $result = $this->
call_trigger(
'ORDER_SUPPLIER_APPROVE', $user);
1220 $this->
ref = $this->newref;
1222 if ($movetoapprovestatus) {
1227 if (empty($secondlevel)) {
1228 $this->date_approve = $now;
1229 $this->user_approve_id = $user->id;
1232 $this->date_approve2 = $now;
1233 $this->user_approve_id2 = $user->id;
1236 $this->db->commit();
1239 $this->db->rollback();
1243 $this->db->rollback();
1244 $this->error = $this->db->lasterror();
1248 dol_syslog(get_class($this).
"::approve Not Authorized", LOG_ERR);
1261 global $conf, $langs;
1267 if ($user->hasRight(
"fournisseur",
"commande",
"approuver")) {
1271 $sql .=
" WHERE rowid = ".((int) $this->
id);
1273 if ($this->db->query(
$sql)) {
1278 $result = $this->
call_trigger(
'ORDER_SUPPLIER_REFUSE', $user);
1281 $this->db->rollback();
1283 $this->db->commit();
1288 $this->db->rollback();
1289 $this->error = $this->db->lasterror();
1290 dol_syslog(get_class($this).
"::refuse Error -1");
1294 dol_syslog(get_class($this).
"::refuse Not Authorized");
1308 public function Cancel($user, $idwarehouse = -1)
1311 global $langs, $conf;
1317 if ($user->hasRight(
"fournisseur",
"commande",
"commander")) {
1322 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur SET fk_statut = ".((int) $statut);
1323 $sql .=
" WHERE rowid = ".((int) $this->
id);
1324 dol_syslog(get_class($this).
"::cancel", LOG_DEBUG);
1325 if ($this->db->query(
$sql)) {
1329 $result = $this->
call_trigger(
'ORDER_SUPPLIER_CANCEL', $user);
1336 $this->db->commit();
1339 $this->db->rollback();
1343 $this->db->rollback();
1344 $this->error = $this->db->lasterror();
1345 dol_syslog(get_class($this).
"::cancel ".$this->error);
1349 dol_syslog(get_class($this).
"::cancel Not Authorized");
1363 public function commande($user, $date, $methode, $comment =
'')
1368 if ($user->hasRight(
"fournisseur",
"commande",
"commander")) {
1371 $newnoteprivate = $this->note_private;
1373 $newnoteprivate =
dol_concatdesc($newnoteprivate, $langs->trans(
"Comment").
': '.$comment);
1376 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur";
1377 $sql .=
" SET fk_statut=".self::STATUS_ORDERSENT.
", fk_input_method=".$methode.
", date_commande='".$this->db->idate($date).
"', ";
1378 $sql .=
" note_private='".$this->db->escape($newnoteprivate).
"'";
1379 $sql .=
" WHERE rowid=".((int) $this->
id);
1381 dol_syslog(get_class($this).
"::commande", LOG_DEBUG);
1382 if ($this->db->query(
$sql)) {
1384 $this->methode_commande_id = $methode;
1385 $this->date_commande = $date;
1386 $this->context = array(
'comments' => $comment);
1389 $result = $this->
call_trigger(
'ORDER_SUPPLIER_SUBMIT', $user);
1396 $this->error = $this->db->lasterror();
1397 $this->errors[] = $this->db->lasterror();
1401 $this->db->commit();
1403 $this->db->rollback();
1407 $this->error = $langs->trans(
'NotAuthorized');
1408 $this->errors[] = $langs->trans(
'NotAuthorized');
1409 dol_syslog(get_class($this).
"::commande User not Authorized", LOG_WARNING);
1412 return ($error ? -1 : 1);
1422 public function create($user, $notrigger = 0)
1424 global $langs, $conf, $hookmanager;
1432 $date = ($this->date_commande ? $this->date_commande : $this->date);
1436 $delivery_date = empty($this->delivery_date) ? $this->date_livraison : $this->delivery_date;
1439 if (empty($this->source)) {
1444 if (!empty($this->multicurrency_code) && empty($this->multicurrency_tx)) {
1449 if (empty($this->fk_multicurrency)) {
1450 $this->multicurrency_code = $conf->currency;
1451 $this->fk_multicurrency = 0;
1452 $this->multicurrency_tx = 1;
1456 $this->brouillon = 1;
1458 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"commande_fournisseur (";
1460 $sql .=
", ref_supplier";
1461 $sql .=
", note_private";
1462 $sql .=
", note_public";
1465 $sql .=
", fk_projet";
1466 $sql .=
", date_creation";
1467 $sql .=
", date_livraison";
1468 $sql .=
", fk_user_author";
1469 $sql .=
", fk_statut";
1471 $sql .=
", model_pdf";
1472 $sql .=
", fk_mode_reglement";
1473 $sql .=
", fk_cond_reglement";
1474 $sql .=
", fk_account";
1475 $sql .=
", fk_incoterms, location_incoterms";
1476 $sql .=
", fk_multicurrency";
1477 $sql .=
", multicurrency_code";
1478 $sql .=
", multicurrency_tx";
1480 $sql .=
" VALUES (";
1482 $sql .=
", '".$this->db->escape($this->ref_supplier).
"'";
1483 $sql .=
", '".$this->db->escape($this->note_private).
"'";
1484 $sql .=
", '".$this->db->escape($this->note_public).
"'";
1485 $sql .=
", ".setEntity($this);
1486 $sql .=
", ".((int) $this->socid);
1487 $sql .=
", ".($this->fk_project > 0 ? ((int) $this->fk_project) :
"null");
1488 $sql .=
", '".$this->db->idate($date).
"'";
1489 $sql .=
", ".($delivery_date ?
"'".$this->db->idate($delivery_date).
"'" :
"null");
1490 $sql .=
", ".((int) $user->id);
1491 $sql .=
", ".self::STATUS_DRAFT;
1492 $sql .=
", ".((int) $this->source);
1494 $sql .=
", ".($this->mode_reglement_id > 0 ? $this->mode_reglement_id :
'null');
1495 $sql .=
", ".($this->cond_reglement_id > 0 ? $this->cond_reglement_id :
'null');
1496 $sql .=
", ".($this->fk_account > 0 ? $this->fk_account :
'NULL');
1497 $sql .=
", ".(int) $this->fk_incoterms;
1498 $sql .=
", '".$this->db->escape($this->location_incoterms).
"'";
1499 $sql .=
", ".(int) $this->fk_multicurrency;
1500 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
1501 $sql .=
", ".(double) $this->multicurrency_tx;
1504 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1505 if ($this->db->query(
$sql)) {
1506 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"commande_fournisseur");
1509 $num = count($this->lines);
1512 for ($i = 0; $i < $num; $i++) {
1513 $line = $this->lines[$i];
1514 if (!is_object($line)) {
1515 $line = (object) $line;
1527 $line->localtax1_tx,
1528 $line->localtax2_tx,
1532 $line->remise_percent,
1535 $line->product_type,
1540 $line->array_options,
1542 $line->multicurrency_subprice,
1549 dol_syslog(get_class($this).
"::create ".$this->error, LOG_WARNING);
1550 $this->db->rollback();
1555 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur";
1556 $sql .=
" SET ref='(PROV".$this->id.
")'";
1557 $sql .=
" WHERE rowid=".((int) $this->
id);
1558 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1559 if ($this->db->query(
$sql)) {
1562 $this->
ref =
"(PROV".$this->id.
")";
1564 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
1565 $this->linked_objects = $this->linkedObjectsIds;
1569 if (!$error && $this->
id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
1570 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
1571 if (is_array($tmp_origin_id)) {
1572 foreach ($tmp_origin_id as $origin_id) {
1581 $origin_id = $tmp_origin_id;
1599 if (!$error && !$notrigger) {
1601 $result = $this->
call_trigger(
'ORDER_SUPPLIER_CREATE', $user);
1603 $this->db->rollback();
1610 $this->db->commit();
1613 $this->error = $this->db->lasterror();
1614 $this->db->rollback();
1619 $this->error =
'Failed to get ID of inserted line';
1624 $this->error = $this->db->lasterror();
1625 $this->db->rollback();
1645 if (isset($this->
ref)) {
1646 $this->
ref = trim($this->
ref);
1648 if (isset($this->ref_supplier)) {
1649 $this->ref_supplier = trim($this->ref_supplier);
1651 if (isset($this->note_private)) {
1652 $this->note_private = trim($this->note_private);
1654 if (isset($this->note_public)) {
1655 $this->note_public = trim($this->note_public);
1657 if (isset($this->model_pdf)) {
1658 $this->model_pdf = trim($this->model_pdf);
1660 if (isset($this->import_key)) {
1661 $this->import_key = trim($this->import_key);
1665 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element.
" SET";
1667 $sql .=
" ref=".(isset($this->
ref) ?
"'".$this->db->escape($this->
ref).
"'" :
"null").
",";
1668 $sql .=
" ref_supplier=".(isset($this->ref_supplier) ?
"'".$this->db->escape($this->ref_supplier).
"'" :
"null").
",";
1669 $sql .=
" ref_ext=".(isset($this->ref_ext) ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null").
",";
1670 $sql .=
" fk_soc=".(isset($this->socid) ? $this->socid :
"null").
",";
1671 $sql .=
" date_commande=".(strval($this->date_commande) !=
'' ?
"'".$this->db->idate($this->date_commande).
"'" :
'null').
",";
1672 $sql .=
" date_valid=".(strval($this->date_validation) !=
'' ?
"'".$this->db->idate($this->date_validation).
"'" :
'null').
",";
1673 $sql .=
" total_tva=".(isset($this->total_tva) ? $this->total_tva :
"null").
",";
1674 $sql .=
" localtax1=".(isset($this->total_localtax1) ? $this->total_localtax1 :
"null").
",";
1675 $sql .=
" localtax2=".(isset($this->total_localtax2) ? $this->total_localtax2 :
"null").
",";
1676 $sql .=
" total_ht=".(isset($this->total_ht) ? $this->total_ht :
"null").
",";
1677 $sql .=
" total_ttc=".(isset($this->total_ttc) ? $this->total_ttc :
"null").
",";
1678 $sql .=
" fk_statut=".(isset($this->statut) ? $this->statut :
"null").
",";
1679 $sql .=
" fk_user_author=".(isset($this->user_author_id) ? $this->user_author_id :
"null").
",";
1680 $sql .=
" fk_user_valid=".(isset($this->user_valid) && $this->user_valid > 0 ? $this->user_valid :
"null").
",";
1681 $sql .=
" fk_projet=".(isset($this->fk_project) ? $this->fk_project :
"null").
",";
1682 $sql .=
" fk_cond_reglement=".(isset($this->cond_reglement_id) ? $this->cond_reglement_id :
"null").
",";
1683 $sql .=
" fk_mode_reglement=".(isset($this->mode_reglement_id) ? $this->mode_reglement_id :
"null").
",";
1684 $sql .=
" date_livraison=".(strval($this->delivery_date) !=
'' ?
"'".$this->db->idate($this->delivery_date).
"'" :
'null').
",";
1686 $sql .=
" fk_account=".($this->fk_account > 0 ? $this->fk_account :
"null").
",";
1688 $sql .=
" note_private=".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null").
",";
1689 $sql .=
" note_public=".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null").
",";
1690 $sql .=
" model_pdf=".(isset($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
"null").
",";
1691 $sql .=
" import_key=".(isset($this->import_key) ?
"'".$this->db->escape($this->import_key).
"'" :
"null");
1693 $sql .=
" WHERE rowid=".((int) $this->
id);
1697 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
1698 $resql = $this->db->query(
$sql);
1701 $this->errors[] =
"Error ".$this->db->lasterror();
1711 if (!$error && !$notrigger) {
1713 $result = $this->
call_trigger(
'ORDER_SUPPLIER_MODIFY', $user);
1722 foreach ($this->errors as $errmsg) {
1723 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
1724 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1726 $this->db->rollback();
1729 $this->db->commit();
1744 global $conf, $user, $hookmanager;
1751 foreach ($this->lines as $line) {
1752 $line->fetch_optionals();
1756 $objFrom = clone $this;
1759 if (!empty($socid) && $socid != $this->socid) {
1760 $objsoc =
new Societe($this->db);
1762 if ($objsoc->fetch($socid) > 0) {
1763 $this->socid = $objsoc->id;
1764 $this->cond_reglement_id = (!empty($objsoc->cond_reglement_id) ? $objsoc->cond_reglement_id : 0);
1765 $this->mode_reglement_id = (!empty($objsoc->mode_reglement_id) ? $objsoc->mode_reglement_id : 0);
1766 $this->fk_project = 0;
1767 $this->fk_delivery_address = 0;
1777 $this->user_author_id = $user->id;
1778 $this->user_valid = 0;
1779 $this->date_creation =
'';
1780 $this->date_validation =
'';
1781 $this->ref_supplier =
'';
1782 $this->user_approve_id =
'';
1783 $this->user_approve_id2 =
'';
1784 $this->date_approve =
'';
1785 $this->date_approve2 =
'';
1788 $this->context[
'createfromclone'] =
'createfromclone';
1789 $result = $this->
create($user, $notrigger);
1796 if (is_object($hookmanager)) {
1797 $parameters = array(
'objFrom'=>$objFrom);
1799 $reshook = $hookmanager->executeHooks(
'createFrom', $parameters, $this, $action);
1807 unset($this->context[
'createfromclone']);
1811 $this->db->commit();
1814 $this->db->rollback();
1848 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 =
false, $date_start =
null, $date_end =
null, $array_options = 0, $fk_unit =
null, $pu_ht_devise = 0, $origin =
'', $origin_id = 0, $rang = -1, $special_code = 0)
1850 global $langs, $mysoc, $conf;
1852 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");
1853 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
1855 if ($this->statut == self::STATUS_DRAFT) {
1856 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
1865 if (empty($txtva)) {
1871 if (empty($txlocaltax1)) {
1874 if (empty($txlocaltax2)) {
1877 if (empty($remise_percent)) {
1878 $remise_percent = 0;
1881 $remise_percent =
price2num($remise_percent);
1884 $pu_ht_devise =
price2num($pu_ht_devise);
1886 if (!preg_match(
'/\((.*)\)/', $txtva)) {
1891 if ($price_base_type ==
'HT') {
1896 $desc = trim($desc);
1899 if ($qty < 0 && !$fk_product) {
1900 $this->error = $langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Product"));
1906 if ($date_start && $date_end && $date_start > $date_end) {
1907 $langs->load(
"errors");
1908 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
1915 $product_type = $type;
1918 if ($fk_product > 0) {
1919 if (!empty($conf->global->SUPPLIER_ORDER_WITH_PREDEFINED_PRICES_ONLY)) {
1921 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);
1923 if ($prod->fetch($fk_product) > 0) {
1924 $product_type = $prod->type;
1925 $label = $prod->label;
1929 $result = $prod->get_buyprice($fk_prod_fourn_price, $qty, $fk_product,
'none', (isset($this->fk_soc) ? $this->fk_soc : $this->socid));
1933 if ($result > 0 && ($origin ==
'commande' || $pu ===
'')) {
1934 $pu = $prod->fourn_pu;
1935 $ref_supplier = $prod->ref_supplier;
1937 if ($remise_percent == 0 && $prod->remise_percent != 0) {
1938 $remise_percent = $prod->remise_percent;
1942 $langs->load(
"errors");
1943 $this->error =
"Ref ".$prod->ref.
" ".$langs->trans(
"ErrorQtyTooLowForThisSupplier");
1944 $this->db->rollback();
1945 dol_syslog(get_class($this).
"::addline we did not found supplier price, so we can't guess unit price");
1950 if ($result == -1) {
1951 $langs->load(
"errors");
1952 $this->error =
"Ref ".$prod->ref.
" ".$langs->trans(
"ErrorQtyTooLowForThisSupplier");
1953 $this->db->rollback();
1954 dol_syslog(get_class($this).
"::addline result=".$result.
" - ".$this->error, LOG_DEBUG);
1958 $this->error = $prod->error;
1959 $this->db->rollback();
1960 dol_syslog(get_class($this).
"::addline result=".$result.
" - ".$this->error, LOG_ERR);
1964 $this->error = $prod->error;
1965 $this->db->rollback();
1971 if (!empty($conf->global->PRODUCT_USE_SUPPLIER_PACKAGING)) {
1972 $prod =
new Product($this->db);
1973 $prod->get_buyprice($fk_prod_fourn_price, $qty, $fk_product,
'none', (empty($this->fk_soc) ? $this->socid : $this->fk_soc));
1975 if ($qty < $prod->packaging) {
1976 $qty = $prod->packaging;
1978 if (!empty($prod->packaging) && ($qty % $prod->packaging) > 0) {
1979 $coeff = intval($qty / $prod->packaging) + 1;
1980 $qty = $prod->packaging * $coeff;
1981 setEventMessages($langs->trans(
'QtyRecalculatedWithPackaging'),
null,
'mesgs');
1987 if (
isModEnabled(
"multicurrency") && $pu_ht_devise > 0) {
1996 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
1997 $vat_src_code = $reg[1];
1998 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
2006 $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);
2008 $total_ht = $tabprice[0];
2009 $total_tva = $tabprice[1];
2010 $total_ttc = $tabprice[2];
2011 $total_localtax1 = $tabprice[9];
2012 $total_localtax2 = $tabprice[10];
2013 $pu = $pu_ht = $tabprice[3];
2016 $multicurrency_total_ht = $tabprice[16];
2017 $multicurrency_total_tva = $tabprice[17];
2018 $multicurrency_total_ttc = $tabprice[18];
2019 $pu_ht_devise = $tabprice[19];
2021 $localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
2022 $localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
2026 $rang = $rangmax + 1;
2032 $this->line->context = $this->context;
2034 $this->line->fk_commande = $this->id;
2035 $this->line->label = $label;
2036 $this->line->ref_fourn = $ref_supplier;
2037 $this->line->ref_supplier = $ref_supplier;
2038 $this->line->desc = $desc;
2039 $this->line->qty = $qty;
2040 $this->line->tva_tx = $txtva;
2041 $this->line->localtax1_tx = ($total_localtax1 ? $localtaxes_type[1] : 0);
2042 $this->line->localtax2_tx = ($total_localtax2 ? $localtaxes_type[3] : 0);
2043 $this->line->localtax1_type = $localtax1_type;
2044 $this->line->localtax2_type = $localtax2_type;
2045 $this->line->fk_product = $fk_product;
2046 $this->line->product_type = $product_type;
2047 $this->line->remise_percent = $remise_percent;
2048 $this->line->subprice = $pu_ht;
2049 $this->line->rang = $rang;
2050 $this->line->info_bits = $info_bits;
2052 $this->line->vat_src_code = $vat_src_code;
2053 $this->line->total_ht = $total_ht;
2054 $this->line->total_tva = $total_tva;
2055 $this->line->total_localtax1 = $total_localtax1;
2056 $this->line->total_localtax2 = $total_localtax2;
2057 $this->line->total_ttc = $total_ttc;
2058 $this->line->product_type = $type;
2059 $this->line->special_code = (!empty($special_code) ? $special_code : 0);
2060 $this->line->origin = $origin;
2061 $this->line->origin_id = $origin_id;
2062 $this->line->fk_unit = $fk_unit;
2064 $this->line->date_start = $date_start;
2065 $this->line->date_end = $date_end;
2068 $this->line->fk_multicurrency = $this->fk_multicurrency;
2069 $this->line->multicurrency_code = $this->multicurrency_code;
2070 $this->line->multicurrency_subprice = $pu_ht_devise;
2071 $this->line->multicurrency_total_ht = $multicurrency_total_ht;
2072 $this->line->multicurrency_total_tva = $multicurrency_total_tva;
2073 $this->line->multicurrency_total_ttc = $multicurrency_total_ttc;
2075 $this->line->subprice = $pu_ht;
2076 $this->line->price = $this->line->subprice;
2078 $this->line->remise_percent = $remise_percent;
2080 if (is_array($array_options) && count($array_options) > 0) {
2081 $this->line->array_options = $array_options;
2084 $result = $this->line->insert($notrigger);
2087 if (!empty($fk_parent_line)) {
2089 } elseif ($rang > 0 && $rang <= count($this->lines)) {
2090 $linecount = count($this->lines);
2091 for ($ii = $rang; $ii <= $linecount; $ii++) {
2097 $result = $this->
update_price(1,
'auto', 0, $this->thirdparty);
2099 $this->db->commit();
2100 return $this->line->id;
2102 $this->db->rollback();
2106 $this->error = $this->line->error;
2107 $this->errors = $this->line->errors;
2108 dol_syslog(get_class($this).
"::addline error=".$this->error, LOG_ERR);
2109 $this->db->rollback();
2134 public function dispatchProduct($user, $product, $qty, $entrepot, $price = 0, $comment =
'', $eatby =
'', $sellby =
'', $batch =
'', $fk_commandefourndet = 0, $notrigger = 0, $fk_reception = 0)
2136 global $conf, $langs;
2139 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
2142 if ($entrepot <= 0) {
2143 $this->error =
'ErrorBadValueForParameterWarehouse';
2147 $this->error =
'ErrorBadValueForParameterQty';
2151 $dispatchstatus = 1;
2152 if (!empty($conf->global->SUPPLIER_ORDER_USE_DISPATCH_STATUS)) {
2153 $dispatchstatus = 0;
2160 if (($this->statut == self::STATUS_ORDERSENT || $this->statut == self::STATUS_RECEIVED_PARTIALLY || $this->statut == self::STATUS_RECEIVED_COMPLETELY)) {
2163 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"commande_fournisseur_dispatch";
2164 $sql .=
" (fk_commande, fk_product, qty, fk_entrepot, fk_user, datec, fk_commandefourndet, status, comment, eatby, sellby, batch, fk_reception) VALUES";
2165 $sql .=
" ('".$this->id.
"','".$product.
"','".$qty.
"',".($entrepot > 0 ?
"'".$entrepot.
"'" :
"null").
",'".$user->id.
"','".$this->db->idate($now).
"','".$fk_commandefourndet.
"', ".$dispatchstatus.
", '".$this->db->escape($comment).
"', ";
2166 $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");
2169 dol_syslog(get_class($this).
"::dispatchProduct", LOG_DEBUG);
2170 $resql = $this->db->query(
$sql);
2173 global $conf, $langs, $user;
2175 $result = $this->
call_trigger(
'LINEORDER_SUPPLIER_DISPATCH', $user);
2182 $this->error = $this->db->lasterror();
2187 if (!$error && $entrepot > 0 &&
isModEnabled(
'stock') && !empty($conf->global->STOCK_CALCULATE_ON_SUPPLIER_DISPATCH_ORDER)) {
2191 $mouv->origin = &$this;
2192 $mouv->setOrigin($this->element, $this->
id);
2195 if (!empty($conf->global->SUPPLIER_ORDER_ALLOW_NEGATIVE_QTY_FOR_SUPPLIER_ORDER_RETURN) && $qty < 0) {
2196 $result = $mouv->livraison($user, $product, $entrepot, $qty*(-1), $price, $comment, $now, $eatby, $sellby, $batch, 0, $inventorycode);
2198 $result = $mouv->reception($user, $product, $entrepot, $qty, $price, $comment, $eatby, $sellby, $batch,
'', 0, $inventorycode);
2202 $this->error = $mouv->error;
2203 $this->errors = $mouv->errors;
2204 dol_syslog(get_class($this).
"::dispatchProduct ".$this->error.
" ".join(
',', $this->errors), LOG_ERR);
2211 $this->db->commit();
2214 $this->db->rollback();
2218 $this->error =
'BadStatusForObject';
2232 if ($this->statut == 0) {
2235 if ($line->fetch($idline) <= 0) {
2241 foreach ($dispatchedLines as $dispatchLine) {
2242 if ($dispatchLine[
'orderlineid'] == $idline) {
2243 $this->error =
"LineAlreadyDispatched";
2244 $this->errors[] = $this->error;
2249 if ($line->delete($notrigger) > 0) {
2253 $this->error = $line->error;
2254 $this->errors = $line->errors;
2269 public function delete(
User $user, $notrigger = 0)
2271 global $langs, $conf;
2272 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
2278 if (empty($notrigger)) {
2280 $result = $this->
call_trigger(
'ORDER_SUPPLIER_DELETE', $user);
2282 $this->errors[] =
'ErrorWhenRunningTrigger';
2283 dol_syslog(get_class($this).
"::delete ".$this->error, LOG_ERR);
2284 $this->db->rollback();
2292 if (!empty($this->linkedObjects) && array_key_exists(
'reception', $this->linkedObjects)) {
2293 foreach ($this->linkedObjects[
'reception'] as $element) {
2294 if ($element->statut >= 0) {
2295 $this->errors[] = $langs->trans(
'ReceptionExist');
2302 $main = MAIN_DB_PREFIX.
'commande_fournisseurdet';
2303 $ef = $main.
"_extrafields";
2304 $sql =
"DELETE FROM $ef WHERE fk_object IN (SELECT rowid FROM $main WHERE fk_commande = ".((int) $this->
id).
")";
2305 dol_syslog(get_class($this).
"::delete extrafields lines", LOG_DEBUG);
2306 if (!$this->db->query(
$sql)) {
2307 $this->error = $this->db->lasterror();
2308 $this->errors[] = $this->db->lasterror();
2312 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"commande_fournisseurdet WHERE fk_commande =".((int) $this->
id);
2313 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
2314 if (!$this->db->query(
$sql)) {
2315 $this->error = $this->db->lasterror();
2316 $this->errors[] = $this->db->lasterror();
2320 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"commande_fournisseur WHERE rowid =".((int) $this->
id);
2321 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
2322 if ($resql = $this->db->query(
$sql)) {
2323 if ($this->db->affected_rows($resql) < 1) {
2324 $this->error = $this->db->lasterror();
2325 $this->errors[] = $this->db->lasterror();
2329 $this->error = $this->db->lasterror();
2330 $this->errors[] = $this->db->lasterror();
2338 $this->error =
'FailToDeleteExtraFields';
2339 $this->errors[] =
'FailToDeleteExtraFields';
2341 dol_syslog(get_class($this).
"::delete error -4 ".$this->error, LOG_ERR);
2348 $this->error =
'FailToDeleteObjectLinked';
2349 $this->errors[] =
'FailToDeleteObjectLinked';
2359 if ($conf->fournisseur->commande->dir_output) {
2360 $dir = $conf->fournisseur->commande->dir_output.
"/".$ref;
2361 $file = $dir.
"/".$ref.
".pdf";
2362 if (file_exists($file)) {
2364 $this->error =
'ErrorFailToDeleteFile';
2365 $this->errors[] =
'ErrorFailToDeleteFile';
2369 if (file_exists($dir)) {
2372 $this->error =
'ErrorFailToDeleteDir';
2373 $this->errors[] =
'ErrorFailToDeleteDir';
2381 dol_syslog(get_class($this).
"::delete $this->id by $user->id", LOG_DEBUG);
2382 $this->db->commit();
2385 dol_syslog(get_class($this).
"::delete ".$this->error, LOG_ERR);
2386 $this->db->rollback();
2400 $sql =
"SELECT rowid, libelle";
2401 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_input_method";
2402 $sql .=
" WHERE active = 1";
2404 $resql = $this->db->query(
$sql);
2407 $num = $this->db->num_rows($resql);
2408 $this->methodes_commande = array();
2410 $row = $this->db->fetch_row($resql);
2412 $this->methodes_commande[$row[0]] = $row[1];
2435 $sql =
"SELECT p.ref, p.label,";
2436 $sql .=
" e.rowid as warehouse_id, e.ref as entrepot,";
2437 $sql .=
" cfd.rowid as dispatchedlineid, cfd.fk_product, cfd.qty, cfd.eatby, cfd.sellby, cfd.batch, cfd.comment, cfd.status, cfd.fk_commandefourndet";
2438 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product as p,";
2439 $sql .=
" ".MAIN_DB_PREFIX.
"commande_fournisseur_dispatch as cfd";
2440 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"entrepot as e ON cfd.fk_entrepot = e.rowid";
2441 $sql .=
" WHERE cfd.fk_commande = ".((int) $this->
id);
2442 $sql .=
" AND cfd.fk_product = p.rowid";
2444 $sql .=
" AND cfd.status = ".((int) $status);
2446 $sql .=
" ORDER BY cfd.rowid ASC";
2448 $resql = $this->db->query(
$sql);
2450 $num = $this->db->num_rows($resql);
2454 $objp = $this->db->fetch_object($resql);
2457 'id' => $objp->dispatchedlineid,
2458 'productid' => $objp->fk_product,
2459 'warehouseid' => $objp->warehouse_id,
2460 'qty' => $objp->qty,
2461 'orderlineid' => $objp->fk_commandefourndet
2468 dol_print_error($this->db,
'Failed to execute request to get dispatched lines');
2487 global $conf, $langs;
2494 $usercanreceive = 0;
2496 $usercanreceive = $user->hasRight(
"fournisseur",
"commande",
"receptionner");
2498 $usercanreceive = $user->hasRight(
"reception",
"creer");
2501 if ($usercanreceive) {
2503 if ($type ==
'par') {
2505 } elseif ($type ==
'tot') {
2507 } elseif ($type ==
'nev') {
2509 } elseif ($type ==
'can') {
2513 dol_syslog(get_class($this).
"::Livraison Error -2", LOG_ERR);
2518 if (!empty($conf->global->SUPPLIER_ORDER_USE_DISPATCH_STATUS)) {
2520 if (!$error && ($type ==
'tot')) {
2522 if (count($dispatchedlinearray) > 0) {
2525 $this->errors[] =
'ErrorCantSetReceptionToTotalDoneWithReceptionToApprove';
2526 dol_syslog(
'ErrorCantSetReceptionToTotalDoneWithReceptionToApprove', LOG_DEBUG);
2529 if (!$error && !empty($conf->global->SUPPLIER_ORDER_USE_DISPATCH_STATUS_NEED_APPROVE) && ($type ==
'tot')) {
2531 if (count($dispatchedlinearray) > 0) {
2534 $this->errors[] =
'ErrorCantSetReceptionToTotalDoneWithReceptionDenied';
2535 dol_syslog(
'ErrorCantSetReceptionToTotalDoneWithReceptionDenied', LOG_DEBUG);
2542 if (empty($error)) {
2545 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur";
2546 $sql .=
" SET fk_statut = ".((int) $statut);
2547 $sql .=
" WHERE rowid = ".((int) $this->
id);
2548 $sql .=
" AND fk_statut IN (".self::STATUS_ORDERSENT.
",".self::STATUS_RECEIVED_PARTIALLY.
")";
2550 dol_syslog(get_class($this).
"::Livraison", LOG_DEBUG);
2551 $resql = $this->db->query(
$sql);
2554 $old_statut = $this->statut;
2555 $this->statut = $statut;
2556 $this->actionmsg2 = $comment;
2559 $result_trigger = $this->
call_trigger(
'ORDER_SUPPLIER_RECEIVE', $user);
2560 if ($result_trigger < 0) {
2565 if (empty($error)) {
2566 $this->db->commit();
2568 $this->statut = $old_statut;
2569 $this->db->rollback();
2570 $this->error = $this->db->lasterror();
2574 $this->db->rollback();
2575 $this->error = $this->db->lasterror();
2580 $this->error = $langs->trans(
'NotAuthorized');
2581 $this->errors[] = $langs->trans(
'NotAuthorized');
2582 dol_syslog(get_class($this).
"::Livraison Not Authorized");
2614 if ($user->hasRight(
"fournisseur",
"commande",
"creer") || $user->hasRight(
"supplier_order",
"creer")) {
2619 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur";
2620 $sql .=
" SET date_livraison = ".($delivery_date ?
"'".$this->db->idate($delivery_date).
"'" :
'null');
2621 $sql .=
" WHERE rowid = ".((int) $this->
id);
2624 $resql = $this->db->query(
$sql);
2626 $this->errors[] = $this->db->error();
2631 $this->oldcopy = clone $this;
2632 $this->date_livraison = $delivery_date;
2633 $this->delivery_date = $delivery_date;
2636 if (!$notrigger && empty($error)) {
2638 $result = $this->
call_trigger(
'ORDER_SUPPLIER_MODIFY', $user);
2646 $this->db->commit();
2649 foreach ($this->errors as $errmsg) {
2650 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2651 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2653 $this->db->rollback();
2673 if ($user->hasRight(
"fournisseur",
"commande",
"creer") || $user->hasRight(
"supplier_order",
"creer")) {
2678 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur";
2679 $sql .=
" SET fk_projet = ".($id_projet > 0 ? (int) $id_projet :
'null');
2680 $sql .=
" WHERE rowid = ".((int) $this->
id);
2683 $resql = $this->db->query(
$sql);
2685 $this->errors[] = $this->db->error();
2690 $this->oldcopy = clone $this;
2691 $this->fk_projet = $id_projet;
2692 $this->fk_project = $id_projet;
2695 if (!$notrigger && empty($error)) {
2697 $result = $this->
call_trigger(
'ORDER_SUPPLIER_MODIFY', $user);
2705 $this->db->commit();
2708 foreach ($this->errors as $errmsg) {
2709 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2710 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2712 $this->db->rollback();
2730 $comclient =
new Commande($this->db);
2731 $comclient->fetch($comclientid);
2735 $this->lines = array();
2737 $num = count($comclient->lines);
2738 for ($i = 0; $i < $num; $i++) {
2739 $prod =
new Product($this->db);
2742 if ($prod->fetch($comclient->lines[$i]->fk_product) > 0) {
2743 $label = $prod->label;
2747 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"commande_fournisseurdet";
2748 $sql .=
" (fk_commande, label, description, fk_product, price, qty, tva_tx, localtax1_tx, localtax2_tx, remise_percent, subprice, remise, ref)";
2749 $sql .=
" VALUES (".((int) $idc).
", '".$this->db->escape($label).
"', '".$this->db->escape($comclient->lines[$i]->desc).
"'";
2750 $sql .=
",".$comclient->lines[$i]->fk_product.
", ".
price2num($comclient->lines[$i]->price,
'MU');
2751 $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);
2752 $sql .=
", '".price2num($comclient->lines[$i]->subprice,
'MT').
"','0', '".$this->db->escape($ref).
"');";
2753 if ($this->db->query(
$sql)) {
2770 global $conf, $langs;
2775 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'commande_fournisseur';
2776 $sql .=
" SET fk_statut = ".$status;
2777 $sql .=
" WHERE rowid = ".((int) $this->
id);
2779 dol_syslog(get_class($this).
"::setStatus", LOG_DEBUG);
2780 $resql = $this->db->query(
$sql);
2783 $triggerName = array();
2784 $triggerName[0] =
'DRAFT';
2785 $triggerName[1] =
'VALIDATED';
2786 $triggerName[2] =
'APPROVED';
2787 $triggerName[3] =
'ORDERED';
2788 $triggerName[4] =
'RECEIVED_PARTIALLY';
2789 $triggerName[5] =
'RECEIVED_COMPLETELY';
2790 $triggerName[6] =
'CANCELED';
2791 $triggerName[7] =
'CANCELED';
2792 $triggerName[9] =
'REFUSED';
2795 $result = $this->
call_trigger(
"ORDER_SUPPLIER_STATUS_".$triggerName[$status], $user);
2802 $this->error = $this->db->lasterror();
2803 dol_syslog(get_class($this).
"::setStatus ".$this->error);
2807 $this->statut = $status;
2808 $this->db->commit();
2811 $this->db->rollback();
2839 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 =
'', $date_end =
'', $array_options = 0, $fk_unit =
null, $pu_ht_devise = 0, $ref_supplier =
'')
2841 global $mysoc, $conf, $langs;
2842 dol_syslog(get_class($this).
"::updateline $rowid, $desc, $pu, $qty, $remise_percent, $txtva, $price_base_type, $info_bits, $type, $fk_unit");
2843 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
2847 if ($this->brouillon) {
2852 if (empty($info_bits)) {
2855 if (empty($txtva)) {
2858 if (empty($txlocaltax1)) {
2861 if (empty($txlocaltax2)) {
2864 if (empty($remise)) {
2867 if (empty($remise_percent)) {
2868 $remise_percent = 0;
2871 $remise_percent =
price2num($remise_percent);
2877 $pu_ht_devise =
price2num($pu_ht_devise);
2878 if (!preg_match(
'/\((.*)\)/', $txtva)) {
2888 if ($date_start && $date_end && $date_start > $date_end) {
2889 $langs->load(
"errors");
2890 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
2906 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
2907 $vat_src_code = $reg[1];
2908 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
2911 $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);
2912 $total_ht = $tabprice[0];
2913 $total_tva = $tabprice[1];
2914 $total_ttc = $tabprice[2];
2915 $total_localtax1 = $tabprice[9];
2916 $total_localtax2 = $tabprice[10];
2917 $pu_ht = $tabprice[3];
2918 $pu_tva = $tabprice[4];
2919 $pu_ttc = $tabprice[5];
2922 $multicurrency_total_ht = $tabprice[16];
2923 $multicurrency_total_tva = $tabprice[17];
2924 $multicurrency_total_ttc = $tabprice[18];
2925 $pu_ht_devise = $tabprice[19];
2927 $localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
2928 $localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
2932 $this->line->fetch($rowid);
2934 $oldline = clone $this->line;
2935 $this->line->oldline = $oldline;
2937 $this->line->context = $this->context;
2939 $this->line->fk_commande = $this->id;
2941 $this->line->desc = $desc;
2944 if (!empty($conf->global->PRODUCT_USE_SUPPLIER_PACKAGING)) {
2945 if ($qty < $this->line->packaging) {
2946 $qty = $this->line->packaging;
2948 if (!empty($this->line->packaging) && ($qty % $this->line->packaging) > 0) {
2949 $coeff = intval($qty / $this->line->packaging) + 1;
2950 $qty = $this->line->packaging * $coeff;
2951 setEventMessage($langs->trans(
'QtyRecalculatedWithPackaging'),
'mesgs');
2956 $this->line->qty = $qty;
2957 $this->line->ref_supplier = $ref_supplier;
2959 $this->line->vat_src_code = $vat_src_code;
2960 $this->line->tva_tx = $txtva;
2961 $this->line->localtax1_tx = $txlocaltax1;
2962 $this->line->localtax2_tx = $txlocaltax2;
2963 $this->line->localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
2964 $this->line->localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
2965 $this->line->remise_percent = $remise_percent;
2966 $this->line->subprice = $pu_ht;
2967 $this->line->info_bits = $info_bits;
2968 $this->line->total_ht = $total_ht;
2969 $this->line->total_tva = $total_tva;
2970 $this->line->total_localtax1 = $total_localtax1;
2971 $this->line->total_localtax2 = $total_localtax2;
2972 $this->line->total_ttc = $total_ttc;
2973 $this->line->product_type = $type;
2974 $this->line->special_code = $oldline->special_code;
2975 $this->line->rang = $oldline->rang;
2976 $this->line->origin = $this->origin;
2977 $this->line->fk_unit = $fk_unit;
2979 $this->line->date_start = $date_start;
2980 $this->line->date_end = $date_end;
2983 $this->line->fk_multicurrency = $this->fk_multicurrency;
2984 $this->line->multicurrency_code = $this->multicurrency_code;
2985 $this->line->multicurrency_subprice = $pu_ht_devise;
2986 $this->line->multicurrency_total_ht = $multicurrency_total_ht;
2987 $this->line->multicurrency_total_tva = $multicurrency_total_tva;
2988 $this->line->multicurrency_total_ttc = $multicurrency_total_ttc;
2990 $this->line->subprice = $pu_ht;
2991 $this->line->price = $this->line->subprice;
2993 $this->line->remise_percent = $remise_percent;
2995 if (is_array($array_options) && count($array_options) > 0) {
2997 foreach ($array_options as $key => $value) {
2998 $this->line->array_options[$key] = $array_options[$key];
3002 $result = $this->line->update($notrigger);
3008 $this->db->commit();
3011 $this->error = $this->db->lasterror();
3012 $this->db->rollback();
3016 $this->error =
"Order status makes operation forbidden";
3017 dol_syslog(get_class($this).
"::updateline ".$this->error, LOG_ERR);
3032 global $user, $langs, $conf;
3034 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
3036 dol_syslog(get_class($this).
"::initAsSpecimen");
3043 $sql =
"SELECT rowid";
3044 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product";
3045 $sql .=
" WHERE entity IN (".getEntity(
'product').
")";
3046 $sql .= $this->db->order(
"rowid",
"ASC");
3047 $sql .= $this->db->plimit(1);
3048 $resql = $this->db->query(
$sql);
3050 $obj = $this->db->fetch_object($resql);
3051 $prodid = $obj->rowid;
3056 $this->
ref =
'SPECIMEN';
3057 $this->specimen = 1;
3060 $this->date_commande = $now;
3061 $this->date_lim_reglement = $this->date + 3600 * 24 * 30;
3062 $this->cond_reglement_code =
'RECEP';
3063 $this->mode_reglement_code =
'CHQ';
3065 $this->note_public =
'This is a comment (public)';
3066 $this->note_private =
'This is a comment (private)';
3068 $this->multicurrency_tx = 1;
3069 $this->multicurrency_code = $conf->currency;
3076 while ($xnbp < $nbp) {
3078 $line->desc = $langs->trans(
"Description").
" ".$xnbp;
3080 $line->subprice = 100;
3082 $line->tva_tx = 19.6;
3083 $line->localtax1_tx = 0;
3084 $line->localtax2_tx = 0;
3086 $line->total_ht = 50;
3087 $line->total_ttc = 59.8;
3088 $line->total_tva = 9.8;
3089 $line->remise_percent = 50;
3091 $line->total_ht = 100;
3092 $line->total_ttc = 119.6;
3093 $line->total_tva = 19.6;
3094 $line->remise_percent = 00;
3096 $line->fk_product = $prodid;
3098 $this->lines[$xnbp] = $line;
3100 $this->total_ht += $line->total_ht;
3101 $this->total_tva += $line->total_tva;
3102 $this->total_ttc += $line->total_ttc;
3116 $sql =
'SELECT c.rowid, date_creation as datec, tms as datem, date_valid as date_validation, date_approve as datea, date_approve2 as datea2,';
3117 $sql .=
' fk_user_author, fk_user_modif, fk_user_valid, fk_user_approve, fk_user_approve2';
3118 $sql .=
' FROM '.MAIN_DB_PREFIX.
'commande_fournisseur as c';
3119 $sql .=
' WHERE c.rowid = '.((int) $id);
3121 $result = $this->db->query(
$sql);
3123 if ($this->db->num_rows($result)) {
3124 $obj = $this->db->fetch_object($result);
3125 $this->
id = $obj->rowid;
3126 if ($obj->fk_user_author) {
3127 $this->user_creation_id = $obj->fk_user_author;
3129 if ($obj->fk_user_valid) {
3130 $this->user_validation_id = $obj->fk_user_valid;
3132 if ($obj->fk_user_modif) {
3133 $this->user_modification_id = $obj->fk_user_modif;
3135 if ($obj->fk_user_approve) {
3136 $this->user_approve_id = $obj->fk_user_approve;
3138 if ($obj->fk_user_approve2) {
3139 $this->user_approve_id2 = $obj->fk_user_approve2;
3142 $this->date_creation = $this->db->jdate($obj->datec);
3143 $this->date_modification = $this->db->jdate($obj->datem);
3144 $this->date_approve = $this->db->jdate($obj->datea);
3145 $this->date_approve2 = $this->db->jdate($obj->datea2);
3146 $this->date_validation = $this->db->jdate($obj->date_validation);
3148 $this->db->free($result);
3163 global $conf, $user;
3165 $this->nb = array();
3168 $sql =
"SELECT count(co.rowid) as nb";
3169 $sql .=
" FROM ".MAIN_DB_PREFIX.
"commande_fournisseur as co";
3170 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON co.fk_soc = s.rowid";
3171 if (!$user->hasRight(
"societe",
"client",
"voir") && !$user->socid) {
3172 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON s.rowid = sc.fk_soc";
3173 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
3176 $sql .=
" ".$clause.
" co.entity IN (".
getEntity(
'supplier_order').
")";
3178 $resql = $this->db->query(
$sql);
3180 while ($obj = $this->db->fetch_object($resql)) {
3181 $this->nb[
"supplier_orders"] = $obj->nb;
3183 $this->db->free($resql);
3187 $this->error = $this->db->error();
3203 global $conf, $langs;
3205 $sql =
"SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date, c.total_ht";
3206 $sql .=
" FROM ".MAIN_DB_PREFIX.
"commande_fournisseur as c";
3207 if (!$user->hasRight(
"societe",
"client",
"voir") && !$user->socid) {
3208 $sql .=
" JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON c.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
3210 $sql .=
" WHERE c.entity = ".$conf->entity;
3211 if ($mode ===
'awaiting') {
3212 $sql .=
" AND c.fk_statut IN (".self::STATUS_ORDERSENT.
", ".self::STATUS_RECEIVED_PARTIALLY.
")";
3214 $sql .=
" AND c.fk_statut IN (".self::STATUS_VALIDATED.
", ".self::STATUS_ACCEPTED.
")";
3217 $sql .=
" AND c.fk_soc = ".((int) $user->socid);
3220 $resql = $this->db->query(
$sql);
3225 $response->warning_delay = $conf->commande->fournisseur->warning_delay / 60 / 60 / 24;
3226 $response->label = $langs->trans(
"SuppliersOrdersToProcess");
3227 $response->labelShort = $langs->trans(
"Opened");
3228 $response->url = DOL_URL_ROOT.
'/fourn/commande/list.php?search_status=1,2&mainmenu=commercial&leftmenu=orders_suppliers';
3231 if ($mode ===
'awaiting') {
3232 $response->label = $langs->trans(
"SuppliersOrdersAwaitingReception");
3233 $response->labelShort = $langs->trans(
"AwaitingReception");
3234 $response->url = DOL_URL_ROOT.
'/fourn/commande/list.php?search_status=3,4&mainmenu=commercial&leftmenu=orders_suppliers';
3237 while ($obj = $this->db->fetch_object($resql)) {
3238 $commandestatic->delivery_date = $this->db->jdate($obj->delivery_date);
3239 $commandestatic->date_commande = $this->db->jdate($obj->date_commande);
3240 $commandestatic->statut = $obj->fk_statut;
3242 $response->nbtodo++;
3243 $response->total += $obj->total_ht;
3245 if ($commandestatic->hasDelay()) {
3246 $response->nbtodolate++;
3252 $this->error = $this->db->error();
3267 if ($this->methode_commande_id > 0) {
3268 $sql =
"SELECT rowid, code, libelle as label";
3269 $sql .=
" FROM ".MAIN_DB_PREFIX.
'c_input_method';
3270 $sql .=
" WHERE active=1 AND rowid = ".((int) $this->methode_commande_id);
3272 $resql = $this->db->query(
$sql);
3274 if ($this->db->num_rows($resql)) {
3275 $obj = $this->db->fetch_object($resql);
3277 $string = $langs->trans($obj->code);
3278 if ($string == $obj->code) {
3279 $string = $obj->label !=
'-' ? $obj->label :
'';
3302 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
3304 global $conf, $langs;
3309 if (!empty($this->model_pdf)) {
3310 $modele = $this->model_pdf;
3311 } elseif (!empty($conf->global->COMMANDE_SUPPLIER_ADDON_PDF)) {
3316 if (empty($modele)) {
3319 $langs->load(
"suppliers");
3320 $outputlangs->load(
"products");
3322 $modelpath =
"core/modules/supplier_order/doc/";
3323 $result = $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
3336 if (empty($this->lines)) {
3343 foreach ($this->lines as $line) {
3344 if ($line->fk_product > 0) {
3345 $idp = $obj->find_min_price_product_fournisseur($line->fk_product, $line->qty);
3348 if ($obj->delivery_time_days > $nb) {
3349 $nb = $obj->delivery_time_days;
3358 return $nb.
' '.$langs->trans(
'Days');
3370 return $user->hasRight(
"fournisseur",
"commande");
3385 'commande_fournisseur'
3402 'commande_fournisseurdet'
3419 if (empty($this->delivery_date) && !empty($this->date_livraison)) {
3420 $this->delivery_date = $this->date_livraison;
3423 if ($this->statut == self::STATUS_ORDERSENT || $this->statut == self::STATUS_RECEIVED_PARTIALLY) {
3425 if (!empty($this->delivery_date)) {
3426 $date_to_test = $this->delivery_date;
3427 return $date_to_test && $date_to_test < ($now - $conf->commande->fournisseur->warning_delay);
3435 $date_to_test = $this->date_commande;
3437 return ($this->statut > 0 && $this->statut < 5) && $date_to_test && $date_to_test < ($now - $conf->commande->fournisseur->warning_delay);
3450 global $conf, $langs;
3452 if (empty($this->delivery_date) && !empty($this->date_livraison)) {
3453 $this->delivery_date = $this->date_livraison;
3458 if ($this->statut == self::STATUS_ORDERSENT || $this->statut == self::STATUS_RECEIVED_PARTIALLY) {
3459 if (!empty($this->delivery_date)) {
3460 $text = $langs->trans(
"DeliveryDate").
' '.
dol_print_date($this->delivery_date,
'day');
3462 $text = $langs->trans(
"OrderDate").
' '.
dol_print_date($this->date_commande,
'day');
3465 $text = $langs->trans(
"OrderDate").
' '.
dol_print_date($this->date_commande,
'day');
3468 $text .=
' '.($conf->commande->fournisseur->warning_delay > 0 ?
'+' :
'-').
' '.round(abs($conf->commande->fournisseur->warning_delay) / 3600 / 24, 1).
' '.$langs->trans(
"days").
' < '.$langs->trans(
"Today");
3485 global $conf, $langs;
3488 require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.commande.dispatch.class.php';
3490 $qtydelivered = array();
3491 $qtywished = array();
3494 $filter = array(
't.fk_commande'=>$this->
id);
3495 if (!empty($conf->global->SUPPLIER_ORDER_USE_DISPATCH_STATUS)) {
3496 $filter[
't.status'] = 1;
3499 $ret = $supplierorderdispatch->fetchAll(
'',
'', 0, 0, $filter);
3501 $this->error = $supplierorderdispatch->error; $this->errors = $supplierorderdispatch->errors;
3504 if (is_array($supplierorderdispatch->lines) && count($supplierorderdispatch->lines) > 0) {
3505 require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
3509 foreach ($supplierorderdispatch->lines as $line) {
3510 $qtydelivered[$line->fk_product] += $line->qty;
3512 foreach ($this->lines as $line) {
3514 if (empty($conf->global->STOCK_SUPPORTS_SERVICES) && $line->product_type > 0) {
3517 $qtywished[$line->fk_product] += $line->qty;
3521 $diff_array = array_diff_assoc($qtydelivered, $qtywished);
3522 $keysinwishednotindelivered = array_diff(array_keys($qtywished), array_keys($qtydelivered));
3523 $keysindeliverednotinwished = array_diff(array_keys($qtydelivered), array_keys($qtywished));
3531 if (count($diff_array) == 0 && count($keysinwishednotindelivered) == 0 && count($keysindeliverednotinwished) == 0) {
3532 if ($closeopenorder) {
3534 $ret = $this->
Livraison($user, $date_liv,
'tot', $comment);
3542 $ret = $this->
Livraison($user, $date_liv,
'par', $comment);
3548 } elseif (!empty($conf->global->SUPPLIER_ORDER_MORE_THAN_WISHED)) {
3553 if (count($diff_array) > 0) {
3557 foreach ($diff_array as $key => $value) {
3559 if ($qtydelivered[$key] >= $qtywished[$key]) {
3566 if ($close == count($diff_array)) {
3568 if ($closeopenorder) {
3569 $ret = $this->
Livraison($user, $date_liv,
'tot', $comment);
3576 $ret = $this->
Livraison($user, $date_liv,
'par', $comment);
3584 $ret = $this->
Livraison($user, $date_liv,
'par', $comment);
3592 $ret = $this->
Livraison($user, $date_liv,
'par', $comment);
3614 $this->receptions = array();
3616 dol_syslog(get_class($this).
"::loadReceptions", LOG_DEBUG);
3618 $sql =
'SELECT cd.rowid, cd.fk_product,';
3619 $sql .=
' sum(cfd.qty) as qty';
3620 $sql .=
' FROM '.MAIN_DB_PREFIX.
'commande_fournisseur_dispatch as cfd,';
3621 if ($filtre_statut >= 0) {
3622 $sql .=
' '.MAIN_DB_PREFIX.
'reception as e,';
3624 $sql .=
' '.MAIN_DB_PREFIX.
'commande_fournisseurdet as cd';
3626 if ($filtre_statut >= 0) {
3627 $sql .=
' cfd.fk_reception = e.rowid AND';
3629 $sql .=
' cfd.fk_commandefourndet = cd.rowid';
3630 $sql .=
' AND cd.fk_commande ='.((int) $this->
id);
3631 if (isset($this->fk_product) && !empty($this->fk_product) > 0) {
3632 $sql .=
' AND cd.fk_product = '.((int) $this->fk_product);
3634 if ($filtre_statut >= 0) {
3635 $sql .=
' AND e.fk_statut >= '.((int) $filtre_statut);
3637 $sql .=
' GROUP BY cd.rowid, cd.fk_product';
3639 $resql = $this->db->query(
$sql);
3641 $num = $this->db->num_rows($resql);
3644 $obj = $this->db->fetch_object($resql);
3645 empty($this->receptions[$obj->rowid]) ? $this->receptions[$obj->rowid] = $obj->qty : $this->receptions[$obj->rowid] += $obj->qty;
3648 $this->db->free($resql);
3652 $this->error = $this->db->lasterror();
3668 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
3670 $return =
'<div class="box-flex-item box-flex-grow-zero">';
3671 $return .=
'<div class="info-box info-box-sm">';
3672 $return .=
'<span class="info-box-icon bg-infobox-action">';
3674 $return .=
'</span>';
3675 $return .=
'<div class="info-box-content">';
3676 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl() : $this->ref).
'</span>';
3677 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
3678 if (property_exists($this,
'socid') || property_exists($this,
'total_tva')) {
3679 $return .=
'<br><span class="info-box-label amount">'.$this->socid.
'</span>';
3681 if (property_exists($this,
'billed')) {
3682 $return .=
'<br><span class="opacitymedium">'.$langs->trans(
"Billed").
' : </span><span class="info-box-label">'.
yn($this->billed).
'</span>';
3684 if (method_exists($this,
'getLibStatut')) {
3685 $return .=
'<br><div class="info-box-status margintoponly">'.$this->getLibStatut(3).
'</div>';
3687 $return .=
'</div>';
3688 $return .=
'</div>';
3689 $return .=
'</div>';
3704 public $element =
'commande_fournisseurdet';
3709 public $table_element =
'commande_fournisseurdet';
3717 public $fk_commande;
3723 public $fk_parent_line;
3731 public $special_code = 0;
3748 public $ref_supplier;
3780 $sql =
'SELECT cd.rowid, cd.fk_commande, cd.fk_product, cd.product_type, cd.description, cd.qty, cd.tva_tx, cd.special_code,';
3781 $sql .=
' cd.localtax1_tx, cd.localtax2_tx, cd.localtax1_type, cd.localtax2_type, cd.ref as ref_supplier,';
3782 $sql .=
' cd.remise, cd.remise_percent, cd.subprice,';
3783 $sql .=
' cd.info_bits, cd.total_ht, cd.total_tva, cd.total_ttc,';
3784 $sql .=
' cd.total_localtax1, cd.total_localtax2,';
3785 $sql .=
' p.ref as product_ref, p.label as product_label, p.description as product_desc,';
3786 $sql .=
' cd.date_start, cd.date_end, cd.fk_unit,';
3787 $sql .=
' cd.multicurrency_subprice, cd.multicurrency_total_ht, cd.multicurrency_total_tva, cd.multicurrency_total_ttc,';
3788 $sql .=
' c.fk_soc as socid';
3789 $sql .=
' FROM '.MAIN_DB_PREFIX.
'commande_fournisseur as c, '.MAIN_DB_PREFIX.
'commande_fournisseurdet as cd';
3790 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON cd.fk_product = p.rowid';
3791 $sql .=
' WHERE cd.fk_commande = c.rowid AND cd.rowid = '.((int) $rowid);
3793 $result = $this->db->query(
$sql);
3795 $objp = $this->db->fetch_object($result);
3797 if (!empty($objp)) {
3798 $this->
rowid = $objp->rowid;
3799 $this->
id = $objp->rowid;
3800 $this->fk_commande = $objp->fk_commande;
3801 $this->desc = $objp->description;
3802 $this->qty = $objp->qty;
3803 $this->ref_fourn = $objp->ref_supplier;
3804 $this->ref_supplier = $objp->ref_supplier;
3805 $this->subprice = $objp->subprice;
3806 $this->tva_tx = $objp->tva_tx;
3807 $this->localtax1_tx = $objp->localtax1_tx;
3808 $this->localtax2_tx = $objp->localtax2_tx;
3809 $this->localtax1_type = $objp->localtax1_type;
3810 $this->localtax2_type = $objp->localtax2_type;
3811 $this->remise = $objp->remise;
3812 $this->remise_percent = $objp->remise_percent;
3813 $this->fk_product = $objp->fk_product;
3814 $this->info_bits = $objp->info_bits;
3815 $this->total_ht = $objp->total_ht;
3816 $this->total_tva = $objp->total_tva;
3817 $this->total_localtax1 = $objp->total_localtax1;
3818 $this->total_localtax2 = $objp->total_localtax2;
3819 $this->total_ttc = $objp->total_ttc;
3820 $this->product_type = $objp->product_type;
3821 $this->special_code = $objp->special_code;
3823 $this->
ref = $objp->product_ref;
3825 $this->product_ref = $objp->product_ref;
3826 $this->product_label = $objp->product_label;
3827 $this->product_desc = $objp->product_desc;
3829 if (!empty($conf->global->PRODUCT_USE_SUPPLIER_PACKAGING)) {
3834 $sqlsearchpackage =
'SELECT rowid, packaging FROM '.MAIN_DB_PREFIX.
"product_fournisseur_price";
3835 $sqlsearchpackage .=
' WHERE entity IN ('.getEntity(
'product_fournisseur_price').
")";
3836 $sqlsearchpackage .=
" AND fk_product = ".((int) $objp->fk_product);
3837 $sqlsearchpackage .=
" AND ref_fourn = '".$this->db->escape($objp->ref_supplier).
"'";
3838 $sqlsearchpackage .=
" AND quantity <= ".((float) $objp->qty);
3839 $sqlsearchpackage .=
" AND (packaging IS NULL OR packaging = 0 OR packaging <= ".((float) $objp->qty).
")";
3840 $sqlsearchpackage .=
" AND fk_soc = ".((int) $objp->socid);
3841 $sqlsearchpackage .=
" ORDER BY packaging ASC";
3842 $sqlsearchpackage .=
" LIMIT 1";
3844 $resqlsearchpackage = $this->db->query($sqlsearchpackage);
3845 if ($resqlsearchpackage) {
3846 $objsearchpackage = $this->db->fetch_object($resqlsearchpackage);
3847 if ($objsearchpackage) {
3848 $this->fk_fournprice = $objsearchpackage->rowid;
3849 $this->packaging = $objsearchpackage->packaging;
3852 $this->error = $this->db->lasterror();
3857 $this->date_start = $this->db->jdate($objp->date_start);
3858 $this->date_end = $this->db->jdate($objp->date_end);
3859 $this->fk_unit = $objp->fk_unit;
3861 $this->multicurrency_subprice = $objp->multicurrency_subprice;
3862 $this->multicurrency_total_ht = $objp->multicurrency_total_ht;
3863 $this->multicurrency_total_tva = $objp->multicurrency_total_tva;
3864 $this->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
3868 $this->db->free($result);
3871 $this->error =
'Supplier order line with id='.$rowid.
' not found';
3872 dol_syslog(get_class($this).
"::fetch Error ".$this->error, LOG_ERR);
3889 global $conf, $user;
3893 dol_syslog(get_class($this).
"::insert rang=".$this->rang);
3896 if (empty($this->tva_tx)) {
3899 if (empty($this->localtax1_tx)) {
3900 $this->localtax1_tx = 0;
3902 if (empty($this->localtax2_tx)) {
3903 $this->localtax2_tx = 0;
3905 if (empty($this->localtax1_type)) {
3906 $this->localtax1_type =
'0';
3908 if (empty($this->localtax2_type)) {
3909 $this->localtax2_type =
'0';
3911 if (empty($this->total_localtax1)) {
3912 $this->total_localtax1 = 0;
3914 if (empty($this->total_localtax2)) {
3915 $this->total_localtax2 = 0;
3917 if (empty($this->rang)) {
3920 if (empty($this->remise_percent)) {
3921 $this->remise_percent = 0;
3923 if (empty($this->info_bits)) {
3924 $this->info_bits = 0;
3926 if (empty($this->special_code)) {
3927 $this->special_code = 0;
3929 if (empty($this->fk_parent_line)) {
3930 $this->fk_parent_line = 0;
3932 if (empty($this->pa_ht)) {
3937 if (!empty($this->multicurrency_code)) {
3940 if (empty($this->fk_multicurrency)) {
3941 $this->multicurrency_code = $conf->currency;
3942 $this->fk_multicurrency = 0;
3943 $this->multicurrency_tx = 1;
3947 if ($this->product_type < 0) {
3954 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.$this->table_element;
3955 $sql .=
" (fk_commande, label, description, date_start, date_end,";
3956 $sql .=
" fk_product, product_type, special_code, rang,";
3957 $sql .=
" qty, vat_src_code, tva_tx, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, remise_percent, subprice, ref,";
3958 $sql .=
" total_ht, total_tva, total_localtax1, total_localtax2, total_ttc, fk_unit,";
3959 $sql .=
" fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc";
3961 $sql .=
" VALUES (".$this->fk_commande.
", '".$this->db->escape($this->label).
"','".$this->db->escape($this->desc).
"',";
3962 $sql .=
" ".($this->date_start ?
"'".$this->db->idate($this->date_start).
"'" :
"null").
",";
3963 $sql .=
" ".($this->date_end ?
"'".$this->db->idate($this->date_end).
"'" :
"null").
",";
3964 if ($this->fk_product) {
3965 $sql .= $this->fk_product.
",";
3969 $sql .=
"'".$this->db->escape($this->product_type).
"',";
3970 $sql .=
"'".$this->db->escape($this->special_code).
"',";
3971 $sql .=
"'".$this->db->escape($this->rang).
"',";
3972 $sql .=
"'".$this->db->escape($this->qty).
"', ";
3973 $sql .=
" ".(empty($this->vat_src_code) ?
"''" :
"'".$this->db->escape($this->vat_src_code).
"'").
",";
3974 $sql .=
" ".price2num($this->tva_tx).
", ";
3975 $sql .=
" ".price2num($this->localtax1_tx).
",";
3976 $sql .=
" ".price2num($this->localtax2_tx).
",";
3977 $sql .=
" '".$this->db->escape($this->localtax1_type).
"',";
3978 $sql .=
" '".$this->db->escape($this->localtax2_type).
"',";
3979 $sql .=
" ".((float) $this->remise_percent).
", ".
price2num($this->subprice,
'MU').
", '".$this->db->escape($this->ref_supplier).
"',";
3980 $sql .=
" ".price2num($this->total_ht).
",";
3981 $sql .=
" ".price2num($this->total_tva).
",";
3982 $sql .=
" ".price2num($this->total_localtax1).
",";
3983 $sql .=
" ".price2num($this->total_localtax2).
",";
3984 $sql .=
" ".price2num($this->total_ttc).
",";
3985 $sql .= ($this->fk_unit ?
"'".$this->db->escape($this->fk_unit).
"'" :
"null");
3986 $sql .=
", ".($this->fk_multicurrency ? ((int) $this->fk_multicurrency) :
"null");
3987 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
3988 $sql .=
", ".($this->multicurrency_subprice ?
price2num($this->multicurrency_subprice) :
'0');
3989 $sql .=
", ".($this->multicurrency_total_ht ?
price2num($this->multicurrency_total_ht) :
'0');
3990 $sql .=
", ".($this->multicurrency_total_tva ?
price2num($this->multicurrency_total_tva) :
'0');
3991 $sql .=
", ".($this->multicurrency_total_ttc ?
price2num($this->multicurrency_total_ttc) :
'0');
3994 dol_syslog(get_class($this).
"::insert", LOG_DEBUG);
3995 $resql = $this->db->query(
$sql);
3997 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.$this->table_element);
3998 $this->
rowid = $this->id;
4007 if (!$error && !$notrigger) {
4009 $result = $this->
call_trigger(
'LINEORDER_SUPPLIER_CREATE', $user);
4017 $this->db->commit();
4021 foreach ($this->errors as $errmsg) {
4022 dol_syslog(get_class($this).
"::delete ".$errmsg, LOG_ERR);
4023 $this->errors[] = ($this->errors ?
', '.$errmsg : $errmsg);
4025 $this->db->rollback();
4028 $this->errors[] = $this->db->error();
4029 $this->db->rollback();
4041 global $conf, $user;
4048 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element.
" SET";
4049 $sql .=
" description='".$this->db->escape($this->desc).
"'";
4050 $sql .=
", ref='".$this->db->escape($this->ref_supplier).
"'";
4051 $sql .=
", subprice='".price2num($this->subprice).
"'";
4053 $sql .=
", remise_percent='".price2num($this->remise_percent).
"'";
4055 $sql .=
", vat_src_code = '".(empty($this->vat_src_code) ?
'' : $this->vat_src_code).
"'";
4056 $sql .=
", tva_tx='".price2num($this->tva_tx).
"'";
4057 $sql .=
", localtax1_tx='".price2num($this->localtax1_tx).
"'";
4058 $sql .=
", localtax2_tx='".price2num($this->localtax2_tx).
"'";
4059 $sql .=
", localtax1_type='".$this->db->escape($this->localtax1_type).
"'";
4060 $sql .=
", localtax2_type='".$this->db->escape($this->localtax2_type).
"'";
4061 $sql .=
", qty='".price2num($this->qty).
"'";
4062 $sql .=
", date_start=".(!empty($this->date_start) ?
"'".$this->db->idate($this->date_start).
"'" :
"null");
4063 $sql .=
", date_end=".(!empty($this->date_end) ?
"'".$this->db->idate($this->date_end).
"'" :
"null");
4064 $sql .=
", info_bits='".$this->db->escape($this->info_bits).
"'";
4065 $sql .=
", total_ht='".price2num($this->total_ht).
"'";
4066 $sql .=
", total_tva='".price2num($this->total_tva).
"'";
4067 $sql .=
", total_localtax1='".price2num($this->total_localtax1).
"'";
4068 $sql .=
", total_localtax2='".price2num($this->total_localtax2).
"'";
4069 $sql .=
", total_ttc='".price2num($this->total_ttc).
"'";
4070 $sql .=
", product_type=".$this->product_type;
4071 $sql .=
", special_code=".(!empty($this->special_code) ? $this->special_code : 0);
4072 $sql .= ($this->fk_unit ?
", fk_unit='".$this->db->escape($this->fk_unit).
"'" :
", fk_unit=null");
4075 $sql .=
", multicurrency_subprice=".price2num($this->multicurrency_subprice);
4076 $sql .=
", multicurrency_total_ht=".price2num($this->multicurrency_total_ht);
4077 $sql .=
", multicurrency_total_tva=".price2num($this->multicurrency_total_tva);
4078 $sql .=
", multicurrency_total_ttc=".price2num($this->multicurrency_total_ttc);
4080 $sql .=
" WHERE rowid = ".((int) $this->
id);
4082 dol_syslog(get_class($this).
"::updateline", LOG_DEBUG);
4083 $resql = $this->db->query(
$sql);
4092 if (!$error && !$notrigger) {
4094 $result = $this->
call_trigger(
'LINEORDER_SUPPLIER_MODIFY', $user);
4096 $this->db->rollback();
4103 $this->db->commit();
4106 $this->db->rollback();
4110 $this->error = $this->db->lasterror();
4111 $this->db->rollback();
4122 public function delete($notrigger = 0)
4133 $this->db->rollback();
4137 $sql1 =
'UPDATE '.MAIN_DB_PREFIX.
"commandedet SET fk_commandefourndet = NULL WHERE rowid=".((int) $this->
id);
4138 $resql = $this->db->query($sql1);
4140 $this->db->rollback();
4144 $sql2 =
'DELETE FROM '.MAIN_DB_PREFIX.
"commande_fournisseurdet WHERE rowid=".((int) $this->
id);
4147 $resql = $this->db->query($sql2);
4151 $result = $this->
call_trigger(
'LINEORDER_SUPPLIER_DELETE', $user);
4159 $this->db->commit();
4163 foreach ($this->errors as $errmsg) {
4164 dol_syslog(get_class($this).
"::delete ".$errmsg, LOG_ERR);
4165 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
4167 $this->db->rollback();
4170 $this->error = $this->db->lasterror();
Class to manage table commandefournisseurdispatch.
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.
deleteline($idline, $notrigger=0)
Delete line.
load_state_board()
Charge indicateurs this->nb de tableau de bord.
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: ...
$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 informations d'ordre info dans l'objet facture.
const STATUS_CANCELED
Order canceled.
getNextNumRef($soc)
Returns the following order reference not used depending on the numbering model activated defined wit...
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=false, $date_start=null, $date_end=null, $array_options=0, $fk_unit=null, $pu_ht_devise=0, $origin='', $origin_id=0, $rang=-1, $special_code=0)
Add order line.
calcAndSetStatusDispatch(User $user, $closeopenorder=1, $comment='')
Calc status regarding to dispatched stock.
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='', $date_end='', $array_options=0, $fk_unit=null, $pu_ht_devise=0, $ref_supplier='')
Update line.
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 (commande_fournisseur_dispatch) and add product...
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.
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)
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.
static replaceProduct(DoliDB $db, $origin_id, $dest_id)
Function used to replace a product id with another one.
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.
get_methodes_commande()
Get list of order methods.
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.
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.
setErrorsFromObject($object)
setErrorsFromObject
updateRangOfLine($rowid, $rang)
Update position of line (rang)
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid='', $f_user=null, $notrigger=0)
Delete all links between an object $this.
update_price($exclspec=0, $roundingadjust='none', $nodatabaseupdate=0, $seller=null)
Update total_ht, total_ttc, total_vat, total_localtax1, total_localtax2 for an object (sum of lines).
deleteExtraFields()
Delete all extra fields values for the current object.
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
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 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.
if(isModEnabled('facture') && $user->hasRight('facture', 'lire')) if((isModEnabled('fournisseur') &&empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD) && $user->hasRight("fournisseur", "facture", "lire"))||(isModEnabled('supplier_invoice') && $user->hasRight("supplier_invoice", "lire"))) if(isModEnabled('don') && $user->hasRight('don', 'lire')) if(isModEnabled('tax') &&!empty($user->rights->tax->charges->lire)) if(isModEnabled('facture') &&isModEnabled('commande') && $user->hasRight("commande", "lire") &&empty($conf->global->WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER)) $sql
Social contributions to pay.
print *****$script_file(".$version.") pid c cd cd cd description as p label as s rowid
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($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.
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 '.
dol_print_error($db='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
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_print_date($time, $format='', $tzoutput='auto', $outputlangs='', $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return dolibarr global constant int value.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
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...
dolGetStatus($statusLabel='', $statusLabelShort='', $html='', $statusType='status0', $displayMode=0, $url='', $params=array())
Output the badge of a status.
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.
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
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.