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 = (array) json_decode($obj->extraparams,
true);
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) && (!empty($user->rights->fournisseur->commande->creer) || !empty($user->rights->supplier_order->creer)))
676 || (!empty($conf->global->MAIN_USE_ADVANCED_PERMS) && !empty($user->rights->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();
730 $dirsource = $conf->fournisseur->commande->dir_output.
'/'.$oldref;
731 $dirdest = $conf->fournisseur->commande->dir_output.
'/'.$newref;
732 if (!$error && file_exists($dirsource)) {
733 dol_syslog(get_class($this).
"::valid rename dir ".$dirsource.
" into ".$dirdest);
735 if (@rename($dirsource, $dirdest)) {
738 $listoffiles =
dol_dir_list($conf->fournisseur->commande->dir_output.
'/'.$newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
739 foreach ($listoffiles as $fileentry) {
740 $dirsource = $fileentry[
'name'];
741 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $newref, $dirsource);
742 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
743 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
744 @rename($dirsource, $dirdest);
761 $this->db->rollback();
765 $this->error =
'NotAuthorized';
766 dol_syslog(get_class($this).
"::valid ".$this->error, LOG_ERR);
779 return $this->
LibStatut($this->statut, $mode, $this->billed);
791 public function LibStatut($status, $mode = 0, $billed = 0)
794 global $conf, $langs, $hookmanager;
796 if (empty($this->statuts) || empty($this->statuts_short)) {
797 $langs->load(
'orders');
799 $this->statuts[0] =
'StatusSupplierOrderDraft';
800 $this->statuts[1] =
'StatusSupplierOrderValidated';
801 $this->statuts[2] =
'StatusSupplierOrderApproved';
802 if (empty($conf->global->SUPPLIER_ORDER_USE_DISPATCH_STATUS)) {
803 $this->statuts[3] =
'StatusSupplierOrderOnProcess';
805 $this->statuts[3] =
'StatusSupplierOrderOnProcessWithValidation';
807 $this->statuts[4] =
'StatusSupplierOrderReceivedPartially';
808 $this->statuts[5] =
'StatusSupplierOrderReceivedAll';
809 $this->statuts[6] =
'StatusSupplierOrderCanceled';
810 $this->statuts[7] =
'StatusSupplierOrderCanceled';
811 $this->statuts[9] =
'StatusSupplierOrderRefused';
814 $this->statuts_short[0] =
'StatusSupplierOrderDraftShort';
815 $this->statuts_short[1] =
'StatusSupplierOrderValidatedShort';
816 $this->statuts_short[2] =
'StatusSupplierOrderApprovedShort';
817 $this->statuts_short[3] =
'StatusSupplierOrderOnProcessShort';
818 $this->statuts_short[4] =
'StatusSupplierOrderReceivedPartiallyShort';
819 $this->statuts_short[5] =
'StatusSupplierOrderReceivedAllShort';
820 $this->statuts_short[6] =
'StatusSupplierOrderCanceledShort';
821 $this->statuts_short[7] =
'StatusSupplierOrderCanceledShort';
822 $this->statuts_short[9] =
'StatusSupplierOrderRefusedShort';
825 $statustrans = array(
837 $statusClass =
'status0';
838 if (!empty($statustrans[$status])) {
839 $statusClass = $statustrans[$status];
844 $billedtext =
' - '.$langs->trans(
"Billed");
846 if ($status == 5 && $billed) {
847 $statusClass =
'status6';
850 $statusLong = $langs->transnoentitiesnoconv($this->statuts[$status]).$billedtext;
851 $statusShort = $langs->transnoentitiesnoconv($this->statuts_short[$status]);
853 $parameters = array(
'status' => $status,
'mode' => $mode,
'billed' => $billed);
854 $reshook = $hookmanager->executeHooks(
'LibStatut', $parameters, $this);
856 return $hookmanager->resPrint;
859 return dolGetStatus($statusLong, $statusShort,
'', $statusClass, $mode);
871 global $conf, $langs, $user;
873 $langs->loadLangs([
'bills',
'orders']);
876 $nofetch = !empty($params[
'nofetch']);
878 if ($user->hasRight(
"fournisseur",
"commande",
"read")) {
879 $datas[
'picto'] =
'<u class="paddingrightonly">'.$langs->trans(
"SupplierOrder").
'</u>';
880 if (isset($this->statut)) {
881 $datas[
'picto'] .=
' '.$this->getLibStatut(5);
883 if (!empty($this->
ref)) {
884 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
886 if (!empty($this->ref_supplier)) {
887 $datas[
'refsupplier'] =
'<br><b>'.$langs->trans(
'RefSupplier').
':</b> '.$this->ref_supplier;
890 $langs->load(
'companies');
891 if (empty($this->thirdparty)) {
894 $datas[
'supplier'] =
'<br><b>'.$langs->trans(
'Supplier').
':</b> '.$this->thirdparty->getNomUrl(1,
'', 0, 1);
896 if (!empty($this->total_ht)) {
897 $datas[
'totalht'] =
'<br><b>'.$langs->trans(
'AmountHT').
':</b> '.
price($this->total_ht, 0, $langs, 0, -1, -1, $conf->currency);
899 if (!empty($this->total_tva)) {
900 $datas[
'totaltva'] =
'<br><b>'.$langs->trans(
'VAT').
':</b> '.
price($this->total_tva, 0, $langs, 0, -1, -1, $conf->currency);
902 if (!empty($this->total_ttc)) {
903 $datas[
'totalttc'] =
'<br><b>'.$langs->trans(
'AmountTTC').
':</b> '.
price($this->total_ttc, 0, $langs, 0, -1, -1, $conf->currency);
905 if (!empty($this->date)) {
906 $datas[
'date'] =
'<br><b>'.$langs->trans(
'Date').
':</b> '.
dol_print_date($this->date,
'day');
908 if (!empty($this->delivery_date)) {
909 $datas[
'deliverydate'] =
'<br><b>'.$langs->trans(
'DeliveryDate').
':</b> '.
dol_print_date($this->delivery_date,
'dayhour');
925 public function getNomUrl($withpicto = 0, $option =
'', $notooltip = 0, $save_lastsearch_value = -1, $addlinktonotes = 0)
927 global $langs, $conf, $user, $hookmanager;
932 'objecttype' => $this->element,
936 $classfortooltip =
'classfortooltip';
939 $classfortooltip =
'classforajaxtooltip';
940 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
946 $url = DOL_URL_ROOT.
'/fourn/commande/card.php?id='.$this->id;
948 if ($option !==
'nolink') {
950 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
951 if ($save_lastsearch_value == -1 && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
952 $add_save_lastsearch_values = 1;
954 if ($add_save_lastsearch_values) {
955 $url .=
'&save_lastsearch_values=1';
960 if (empty($notooltip)) {
961 if (!empty($conf->global->MAIN_OPTIMIZEFORTEXTBROWSER)) {
962 $label = $langs->trans(
"ShowOrder");
963 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1).
'"';
965 $linkclose .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
966 $linkclose .= $dataparams.
' class="'.$classfortooltip.
'"';
969 $linkstart =
'<a href="'.$url.
'"';
970 $linkstart .= $linkclose.
'>';
973 $result .= $linkstart;
975 $result .=
img_object(($notooltip ?
'' : $label), $this->picto, ($notooltip ? (($withpicto != 2) ?
'class="paddingright"' :
'') : $dataparams.
' class="'.(($withpicto != 2) ?
'paddingright ' :
'').$classfortooltip.
'"'), 0, 0, $notooltip ? 0 : 1);
977 if ($withpicto != 2) {
978 $result .= $this->ref;
982 if ($addlinktonotes) {
983 $txttoshow = ($user->socid > 0 ? $this->note_public : $this->note_private);
986 $result .=
' <span class="note inline-block">';
987 $result .=
'<a href="'.DOL_URL_ROOT.
'/fourn/commande/note.php?id='.$this->
id.
'" class="classfortooltip" title="'.
dol_escape_htmltag($notetoshow).
'">';
992 $result .=
'</span>';
997 $hookmanager->initHooks(array($this->element .
'dao'));
998 $parameters = array(
'id'=>$this->
id,
'getnomurl' => &$result);
999 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
1001 $result = $hookmanager->resPrint;
1003 $result .= $hookmanager->resPrint;
1018 global $db, $langs, $conf;
1019 $langs->load(
"orders");
1021 if (!empty($conf->global->COMMANDE_SUPPLIER_ADDON_NUMBER)) {
1028 $dirmodels = array_merge(array(
'/'), (array) $conf->modules_parts[
'models']);
1030 foreach ($dirmodels as $reldir) {
1031 $dir =
dol_buildpath($reldir.
"core/modules/supplier_order/");
1034 $mybool |= @include_once $dir.$file;
1037 if ($mybool ===
false) {
1042 $obj =
new $classname();
1043 $numref = $obj->getNextValue($soc, $this);
1045 if ($numref !=
"") {
1048 $this->error = $obj->error;
1052 $this->error =
"Error_COMMANDE_SUPPLIER_ADDON_NotDefined";
1066 if ($this->billed) {
1072 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'commande_fournisseur SET billed = 1';
1075 if ($this->db->query(
$sql)) {
1078 $result = $this->
call_trigger(
'ORDER_SUPPLIER_CLASSIFY_BILLED', $user);
1088 $this->db->commit();
1091 $this->db->rollback();
1097 $this->db->rollback();
1110 public function approve($user, $idwarehouse = 0, $secondlevel = 0)
1112 global $langs, $conf;
1113 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1119 if ($user->rights->fournisseur->commande->approuver) {
1125 $soc =
new Societe($this->db);
1126 $soc->fetch($this->fourn_id);
1129 if (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref)) {
1137 $movetoapprovestatus =
true;
1140 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur";
1141 $sql .=
" SET ref='".$this->db->escape($num).
"',";
1142 if (empty($secondlevel)) {
1143 $sql .=
" date_approve='".$this->db->idate($now).
"',";
1144 $sql .=
" fk_user_approve = ".$user->id;
1145 if (!empty($conf->global->SUPPLIER_ORDER_3_STEPS_TO_BE_APPROVED) && $this->total_ht >= $conf->global->SUPPLIER_ORDER_3_STEPS_TO_BE_APPROVED) {
1146 if (empty($this->user_approve_id2)) {
1147 $movetoapprovestatus =
false;
1148 $comment =
' (first level)';
1153 $sql .=
" date_approve2='".$this->db->idate($now).
"',";
1154 $sql .=
" fk_user_approve2 = ".((int) $user->id);
1155 if (empty($this->user_approve_id)) {
1156 $movetoapprovestatus =
false;
1158 $comment =
' (second level)';
1161 if ($movetoapprovestatus) {
1162 $sql .=
", fk_statut = ".self::STATUS_ACCEPTED;
1164 $sql .=
", fk_statut = ".self::STATUS_VALIDATED;
1166 $sql .=
" WHERE rowid = ".((int) $this->
id);
1167 $sql .=
" AND fk_statut = ".self::STATUS_VALIDATED;
1169 if ($this->db->query(
$sql)) {
1170 if (!empty($conf->global->SUPPLIER_ORDER_AUTOADD_USER_CONTACT)) {
1171 $result = $this->
add_contact($user->id,
'SALESREPFOLL',
'internal', 1);
1172 if ($result < 0 && $result != -2) {
1178 if (!$error && $movetoapprovestatus &&
isModEnabled(
'stock') && !empty($conf->global->STOCK_CALCULATE_ON_SUPPLIER_VALIDATE_ORDER)) {
1179 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
1180 $langs->load(
"agenda");
1182 $cpt = count($this->lines);
1183 for ($i = 0; $i < $cpt; $i++) {
1185 if ($this->lines[$i]->fk_product > 0) {
1186 $this->line = $this->lines[$i];
1188 $mouvP->origin = &$this;
1189 $mouvP->setOrigin($this->element, $this->
id);
1191 $up_ht_disc = $this->lines[$i]->subprice;
1192 if (!empty($this->lines[$i]->remise_percent) && empty($conf->global->STOCK_EXCLUDE_DISCOUNT_FOR_PMP)) {
1193 $up_ht_disc =
price2num($up_ht_disc * (100 - $this->lines[$i]->remise_percent) / 100,
'MU');
1195 $result = $mouvP->reception($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, $up_ht_disc, $langs->trans(
"OrderApprovedInDolibarr", $this->ref));
1206 $result = $this->
call_trigger(
'ORDER_SUPPLIER_APPROVE', $user);
1214 $this->
ref = $this->newref;
1216 if ($movetoapprovestatus) {
1221 if (empty($secondlevel)) {
1222 $this->date_approve = $now;
1223 $this->user_approve_id = $user->id;
1226 $this->date_approve2 = $now;
1227 $this->user_approve_id2 = $user->id;
1230 $this->db->commit();
1233 $this->db->rollback();
1237 $this->db->rollback();
1238 $this->error = $this->db->lasterror();
1242 dol_syslog(get_class($this).
"::approve Not Authorized", LOG_ERR);
1255 global $conf, $langs;
1261 if ($user->rights->fournisseur->commande->approuver) {
1265 $sql .=
" WHERE rowid = ".((int) $this->
id);
1267 if ($this->db->query(
$sql)) {
1272 $result = $this->
call_trigger(
'ORDER_SUPPLIER_REFUSE', $user);
1275 $this->db->rollback();
1277 $this->db->commit();
1282 $this->db->rollback();
1283 $this->error = $this->db->lasterror();
1284 dol_syslog(get_class($this).
"::refuse Error -1");
1288 dol_syslog(get_class($this).
"::refuse Not Authorized");
1302 public function Cancel($user, $idwarehouse = -1)
1305 global $langs, $conf;
1311 if ($user->rights->fournisseur->commande->commander) {
1316 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur SET fk_statut = ".((int) $statut);
1317 $sql .=
" WHERE rowid = ".((int) $this->
id);
1318 dol_syslog(get_class($this).
"::cancel", LOG_DEBUG);
1319 if ($this->db->query(
$sql)) {
1323 $result = $this->
call_trigger(
'ORDER_SUPPLIER_CANCEL', $user);
1330 $this->db->commit();
1333 $this->db->rollback();
1337 $this->db->rollback();
1338 $this->error = $this->db->lasterror();
1339 dol_syslog(get_class($this).
"::cancel ".$this->error);
1343 dol_syslog(get_class($this).
"::cancel Not Authorized");
1357 public function commande($user, $date, $methode, $comment =
'')
1362 if ($user->rights->fournisseur->commande->commander) {
1365 $newnoteprivate = $this->note_private;
1367 $newnoteprivate =
dol_concatdesc($newnoteprivate, $langs->trans(
"Comment").
': '.$comment);
1370 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur";
1371 $sql .=
" SET fk_statut=".self::STATUS_ORDERSENT.
", fk_input_method=".$methode.
", date_commande='".$this->db->idate($date).
"', ";
1372 $sql .=
" note_private='".$this->db->escape($newnoteprivate).
"'";
1373 $sql .=
" WHERE rowid=".((int) $this->
id);
1375 dol_syslog(get_class($this).
"::commande", LOG_DEBUG);
1376 if ($this->db->query(
$sql)) {
1378 $this->methode_commande_id = $methode;
1379 $this->date_commande = $date;
1380 $this->context = array(
'comments' => $comment);
1383 $result = $this->
call_trigger(
'ORDER_SUPPLIER_SUBMIT', $user);
1390 $this->error = $this->db->lasterror();
1391 $this->errors[] = $this->db->lasterror();
1395 $this->db->commit();
1397 $this->db->rollback();
1401 $this->error = $langs->trans(
'NotAuthorized');
1402 $this->errors[] = $langs->trans(
'NotAuthorized');
1403 dol_syslog(get_class($this).
"::commande User not Authorized", LOG_WARNING);
1406 return ($error ? -1 : 1);
1416 public function create($user, $notrigger = 0)
1418 global $langs, $conf, $hookmanager;
1426 $date = ($this->date_commande ? $this->date_commande : $this->date);
1430 $delivery_date = empty($this->delivery_date) ? $this->date_livraison : $this->delivery_date;
1433 if (empty($this->source)) {
1438 if (!empty($this->multicurrency_code) && empty($this->multicurrency_tx)) {
1443 if (empty($this->fk_multicurrency)) {
1444 $this->multicurrency_code = $conf->currency;
1445 $this->fk_multicurrency = 0;
1446 $this->multicurrency_tx = 1;
1450 $this->brouillon = 1;
1452 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"commande_fournisseur (";
1454 $sql .=
", ref_supplier";
1455 $sql .=
", note_private";
1456 $sql .=
", note_public";
1459 $sql .=
", fk_projet";
1460 $sql .=
", date_creation";
1461 $sql .=
", date_livraison";
1462 $sql .=
", fk_user_author";
1463 $sql .=
", fk_statut";
1465 $sql .=
", model_pdf";
1466 $sql .=
", fk_mode_reglement";
1467 $sql .=
", fk_cond_reglement";
1468 $sql .=
", fk_account";
1469 $sql .=
", fk_incoterms, location_incoterms";
1470 $sql .=
", fk_multicurrency";
1471 $sql .=
", multicurrency_code";
1472 $sql .=
", multicurrency_tx";
1474 $sql .=
" VALUES (";
1476 $sql .=
", '".$this->db->escape($this->ref_supplier).
"'";
1477 $sql .=
", '".$this->db->escape($this->note_private).
"'";
1478 $sql .=
", '".$this->db->escape($this->note_public).
"'";
1479 $sql .=
", ".setEntity($this);
1480 $sql .=
", ".((int) $this->socid);
1481 $sql .=
", ".($this->fk_project > 0 ? ((int) $this->fk_project) :
"null");
1482 $sql .=
", '".$this->db->idate($date).
"'";
1483 $sql .=
", ".($delivery_date ?
"'".$this->db->idate($delivery_date).
"'" :
"null");
1484 $sql .=
", ".((int) $user->id);
1485 $sql .=
", ".self::STATUS_DRAFT;
1486 $sql .=
", ".((int) $this->source);
1488 $sql .=
", ".($this->mode_reglement_id > 0 ? $this->mode_reglement_id :
'null');
1489 $sql .=
", ".($this->cond_reglement_id > 0 ? $this->cond_reglement_id :
'null');
1490 $sql .=
", ".($this->fk_account > 0 ? $this->fk_account :
'NULL');
1491 $sql .=
", ".(int) $this->fk_incoterms;
1492 $sql .=
", '".$this->db->escape($this->location_incoterms).
"'";
1493 $sql .=
", ".(int) $this->fk_multicurrency;
1494 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
1495 $sql .=
", ".(double) $this->multicurrency_tx;
1498 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1499 if ($this->db->query(
$sql)) {
1500 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"commande_fournisseur");
1503 $num = count($this->lines);
1506 for ($i = 0; $i < $num; $i++) {
1507 $line = $this->lines[$i];
1508 if (!is_object($line)) {
1509 $line = (object) $line;
1521 $line->localtax1_tx,
1522 $line->localtax2_tx,
1526 $line->remise_percent,
1529 $line->product_type,
1534 $line->array_options,
1539 dol_syslog(get_class($this).
"::create ".$this->error, LOG_WARNING);
1540 $this->db->rollback();
1545 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur";
1546 $sql .=
" SET ref='(PROV".$this->id.
")'";
1547 $sql .=
" WHERE rowid=".((int) $this->
id);
1548 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
1549 if ($this->db->query(
$sql)) {
1552 $this->
ref =
"(PROV".$this->id.
")";
1554 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
1555 $this->linked_objects = $this->linkedObjectsIds;
1559 if (!$error && $this->
id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
1560 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
1561 if (is_array($tmp_origin_id)) {
1562 foreach ($tmp_origin_id as $origin_id) {
1571 $origin_id = $tmp_origin_id;
1589 if (!$error && !$notrigger) {
1591 $result = $this->
call_trigger(
'ORDER_SUPPLIER_CREATE', $user);
1593 $this->db->rollback();
1600 $this->db->commit();
1603 $this->error = $this->db->lasterror();
1604 $this->db->rollback();
1609 $this->error =
'Failed to get ID of inserted line';
1614 $this->error = $this->db->lasterror();
1615 $this->db->rollback();
1635 if (isset($this->
ref)) {
1636 $this->
ref = trim($this->
ref);
1638 if (isset($this->ref_supplier)) {
1639 $this->ref_supplier = trim($this->ref_supplier);
1641 if (isset($this->note_private)) {
1642 $this->note_private = trim($this->note_private);
1644 if (isset($this->note_public)) {
1645 $this->note_public = trim($this->note_public);
1647 if (isset($this->model_pdf)) {
1648 $this->model_pdf = trim($this->model_pdf);
1650 if (isset($this->import_key)) {
1651 $this->import_key = trim($this->import_key);
1655 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element.
" SET";
1657 $sql .=
" ref=".(isset($this->
ref) ?
"'".$this->db->escape($this->
ref).
"'" :
"null").
",";
1658 $sql .=
" ref_supplier=".(isset($this->ref_supplier) ?
"'".$this->db->escape($this->ref_supplier).
"'" :
"null").
",";
1659 $sql .=
" ref_ext=".(isset($this->ref_ext) ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null").
",";
1660 $sql .=
" fk_soc=".(isset($this->socid) ? $this->socid :
"null").
",";
1661 $sql .=
" date_commande=".(strval($this->date_commande) !=
'' ?
"'".$this->db->idate($this->date_commande).
"'" :
'null').
",";
1662 $sql .=
" date_valid=".(strval($this->date_validation) !=
'' ?
"'".$this->db->idate($this->date_validation).
"'" :
'null').
",";
1663 $sql .=
" total_tva=".(isset($this->total_tva) ? $this->total_tva :
"null").
",";
1664 $sql .=
" localtax1=".(isset($this->total_localtax1) ? $this->total_localtax1 :
"null").
",";
1665 $sql .=
" localtax2=".(isset($this->total_localtax2) ? $this->total_localtax2 :
"null").
",";
1666 $sql .=
" total_ht=".(isset($this->total_ht) ? $this->total_ht :
"null").
",";
1667 $sql .=
" total_ttc=".(isset($this->total_ttc) ? $this->total_ttc :
"null").
",";
1668 $sql .=
" fk_statut=".(isset($this->statut) ? $this->statut :
"null").
",";
1669 $sql .=
" fk_user_author=".(isset($this->user_author_id) ? $this->user_author_id :
"null").
",";
1670 $sql .=
" fk_user_valid=".(isset($this->user_valid) && $this->user_valid > 0 ? $this->user_valid :
"null").
",";
1671 $sql .=
" fk_projet=".(isset($this->fk_project) ? $this->fk_project :
"null").
",";
1672 $sql .=
" fk_cond_reglement=".(isset($this->cond_reglement_id) ? $this->cond_reglement_id :
"null").
",";
1673 $sql .=
" fk_mode_reglement=".(isset($this->mode_reglement_id) ? $this->mode_reglement_id :
"null").
",";
1674 $sql .=
" date_livraison=".(strval($this->delivery_date) !=
'' ?
"'".$this->db->idate($this->delivery_date).
"'" :
'null').
",";
1676 $sql .=
" fk_account=".($this->fk_account > 0 ? $this->fk_account :
"null").
",";
1678 $sql .=
" note_private=".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null").
",";
1679 $sql .=
" note_public=".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null").
",";
1680 $sql .=
" model_pdf=".(isset($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
"null").
",";
1681 $sql .=
" import_key=".(isset($this->import_key) ?
"'".$this->db->escape($this->import_key).
"'" :
"null");
1683 $sql .=
" WHERE rowid=".((int) $this->
id);
1687 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
1688 $resql = $this->db->query(
$sql);
1691 $this->errors[] =
"Error ".$this->db->lasterror();
1701 if (!$error && !$notrigger) {
1703 $result = $this->
call_trigger(
'ORDER_SUPPLIER_MODIFY', $user);
1712 foreach ($this->errors as $errmsg) {
1713 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
1714 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1716 $this->db->rollback();
1719 $this->db->commit();
1734 global $conf, $user, $hookmanager;
1741 foreach ($this->lines as $line) {
1742 $line->fetch_optionals();
1746 $objFrom = clone $this;
1749 if (!empty($socid) && $socid != $this->socid) {
1750 $objsoc =
new Societe($this->db);
1752 if ($objsoc->fetch($socid) > 0) {
1753 $this->socid = $objsoc->id;
1754 $this->cond_reglement_id = (!empty($objsoc->cond_reglement_id) ? $objsoc->cond_reglement_id : 0);
1755 $this->mode_reglement_id = (!empty($objsoc->mode_reglement_id) ? $objsoc->mode_reglement_id : 0);
1756 $this->fk_project = 0;
1757 $this->fk_delivery_address = 0;
1767 $this->user_author_id = $user->id;
1768 $this->user_valid = 0;
1769 $this->date_creation =
'';
1770 $this->date_validation =
'';
1771 $this->ref_supplier =
'';
1772 $this->user_approve_id =
'';
1773 $this->user_approve_id2 =
'';
1774 $this->date_approve =
'';
1775 $this->date_approve2 =
'';
1778 $this->context[
'createfromclone'] =
'createfromclone';
1779 $result = $this->
create($user, $notrigger);
1786 if (is_object($hookmanager)) {
1787 $parameters = array(
'objFrom'=>$objFrom);
1789 $reshook = $hookmanager->executeHooks(
'createFrom', $parameters, $this, $action);
1797 unset($this->context[
'createfromclone']);
1801 $this->db->commit();
1804 $this->db->rollback();
1838 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)
1840 global $langs, $mysoc, $conf;
1842 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");
1843 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
1845 if ($this->statut == self::STATUS_DRAFT) {
1846 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
1855 if (empty($txtva)) {
1861 if (empty($txlocaltax1)) {
1864 if (empty($txlocaltax2)) {
1867 if (empty($remise_percent)) {
1868 $remise_percent = 0;
1871 $remise_percent =
price2num($remise_percent);
1874 $pu_ht_devise =
price2num($pu_ht_devise);
1876 if (!preg_match(
'/\((.*)\)/', $txtva)) {
1881 if ($price_base_type ==
'HT') {
1886 $desc = trim($desc);
1889 if ($qty < 0 && !$fk_product) {
1890 $this->error = $langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Product"));
1896 if ($date_start && $date_end && $date_start > $date_end) {
1897 $langs->load(
"errors");
1898 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
1905 $product_type = $type;
1908 if ($fk_product > 0) {
1909 if (!empty($conf->global->SUPPLIER_ORDER_WITH_PREDEFINED_PRICES_ONLY)) {
1911 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);
1913 if ($prod->fetch($fk_product) > 0) {
1914 $product_type = $prod->type;
1915 $label = $prod->label;
1919 $result = $prod->get_buyprice($fk_prod_fourn_price, $qty, $fk_product,
'none', (isset($this->fk_soc) ? $this->fk_soc : $this->socid));
1923 if ($result > 0 && ($origin ==
'commande' || $pu ===
'')) {
1924 $pu = $prod->fourn_pu;
1925 $ref_supplier = $prod->ref_supplier;
1927 if ($remise_percent == 0 && $prod->remise_percent != 0) {
1928 $remise_percent = $prod->remise_percent;
1932 $langs->load(
"errors");
1933 $this->error =
"Ref ".$prod->ref.
" ".$langs->trans(
"ErrorQtyTooLowForThisSupplier");
1934 $this->db->rollback();
1935 dol_syslog(get_class($this).
"::addline we did not found supplier price, so we can't guess unit price");
1940 if ($result == -1) {
1941 $langs->load(
"errors");
1942 $this->error =
"Ref ".$prod->ref.
" ".$langs->trans(
"ErrorQtyTooLowForThisSupplier");
1943 $this->db->rollback();
1944 dol_syslog(get_class($this).
"::addline result=".$result.
" - ".$this->error, LOG_DEBUG);
1948 $this->error = $prod->error;
1949 $this->db->rollback();
1950 dol_syslog(get_class($this).
"::addline result=".$result.
" - ".$this->error, LOG_ERR);
1954 $this->error = $prod->error;
1955 $this->db->rollback();
1961 if (!empty($conf->global->PRODUCT_USE_SUPPLIER_PACKAGING)) {
1962 $prod =
new Product($this->db);
1963 $prod->get_buyprice($fk_prod_fourn_price, $qty, $fk_product,
'none', ($this->fk_soc ? $this->fk_soc : $this->socid));
1965 if ($qty < $prod->packaging) {
1966 $qty = $prod->packaging;
1968 if (!empty($prod->packaging) && ($qty % $prod->packaging) > 0) {
1969 $coeff = intval($qty / $prod->packaging) + 1;
1970 $qty = $prod->packaging * $coeff;
1971 setEventMessages($langs->trans(
'QtyRecalculatedWithPackaging'),
null,
'mesgs');
1977 if (
isModEnabled(
"multicurrency") && $pu_ht_devise > 0) {
1986 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
1987 $vat_src_code = $reg[1];
1988 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
1996 $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);
1998 $total_ht = $tabprice[0];
1999 $total_tva = $tabprice[1];
2000 $total_ttc = $tabprice[2];
2001 $total_localtax1 = $tabprice[9];
2002 $total_localtax2 = $tabprice[10];
2003 $pu = $pu_ht = $tabprice[3];
2006 $multicurrency_total_ht = $tabprice[16];
2007 $multicurrency_total_tva = $tabprice[17];
2008 $multicurrency_total_ttc = $tabprice[18];
2009 $pu_ht_devise = $tabprice[19];
2011 $localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
2012 $localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
2016 $rang = $rangmax + 1;
2022 $this->line->context = $this->context;
2024 $this->line->fk_commande = $this->id;
2025 $this->line->label = $label;
2026 $this->line->ref_fourn = $ref_supplier;
2027 $this->line->ref_supplier = $ref_supplier;
2028 $this->line->desc = $desc;
2029 $this->line->qty = $qty;
2030 $this->line->tva_tx = $txtva;
2031 $this->line->localtax1_tx = ($total_localtax1 ? $localtaxes_type[1] : 0);
2032 $this->line->localtax2_tx = ($total_localtax2 ? $localtaxes_type[3] : 0);
2033 $this->line->localtax1_type = $localtax1_type;
2034 $this->line->localtax2_type = $localtax2_type;
2035 $this->line->fk_product = $fk_product;
2036 $this->line->product_type = $product_type;
2037 $this->line->remise_percent = $remise_percent;
2038 $this->line->subprice = $pu_ht;
2039 $this->line->rang = $rang;
2040 $this->line->info_bits = $info_bits;
2042 $this->line->vat_src_code = $vat_src_code;
2043 $this->line->total_ht = $total_ht;
2044 $this->line->total_tva = $total_tva;
2045 $this->line->total_localtax1 = $total_localtax1;
2046 $this->line->total_localtax2 = $total_localtax2;
2047 $this->line->total_ttc = $total_ttc;
2048 $this->line->product_type = $type;
2049 $this->line->special_code = (!empty($this->special_code) ? $this->special_code : 0);
2050 $this->line->origin = $origin;
2051 $this->line->origin_id = $origin_id;
2052 $this->line->fk_unit = $fk_unit;
2054 $this->line->date_start = $date_start;
2055 $this->line->date_end = $date_end;
2058 $this->line->fk_multicurrency = $this->fk_multicurrency;
2059 $this->line->multicurrency_code = $this->multicurrency_code;
2060 $this->line->multicurrency_subprice = $pu_ht_devise;
2061 $this->line->multicurrency_total_ht = $multicurrency_total_ht;
2062 $this->line->multicurrency_total_tva = $multicurrency_total_tva;
2063 $this->line->multicurrency_total_ttc = $multicurrency_total_ttc;
2065 $this->line->subprice = $pu_ht;
2066 $this->line->price = $this->line->subprice;
2068 $this->line->remise_percent = $remise_percent;
2070 if (is_array($array_options) && count($array_options) > 0) {
2071 $this->line->array_options = $array_options;
2074 $result = $this->line->insert($notrigger);
2077 if (!empty($fk_parent_line)) {
2079 } elseif ($rang > 0 && $rang <= count($this->lines)) {
2080 $linecount = count($this->lines);
2081 for ($ii = $rang; $ii <= $linecount; $ii++) {
2087 $result = $this->
update_price(1,
'auto', 0, $this->thirdparty);
2089 $this->db->commit();
2090 return $this->line->id;
2092 $this->db->rollback();
2096 $this->error = $this->line->error;
2097 $this->errors = $this->line->errors;
2098 dol_syslog(get_class($this).
"::addline error=".$this->error, LOG_ERR);
2099 $this->db->rollback();
2123 public function dispatchProduct($user, $product, $qty, $entrepot, $price = 0, $comment =
'', $eatby =
'', $sellby =
'', $batch =
'', $fk_commandefourndet = 0, $notrigger = 0, $fk_reception = 0)
2125 global $conf, $langs;
2128 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
2131 if ($entrepot <= 0) {
2132 $this->error =
'ErrorBadValueForParameterWarehouse';
2136 $this->error =
'ErrorBadValueForParameterQty';
2140 $dispatchstatus = 1;
2141 if (!empty($conf->global->SUPPLIER_ORDER_USE_DISPATCH_STATUS)) {
2142 $dispatchstatus = 0;
2149 if (($this->statut == self::STATUS_ORDERSENT || $this->statut == self::STATUS_RECEIVED_PARTIALLY || $this->statut == self::STATUS_RECEIVED_COMPLETELY)) {
2152 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"commande_fournisseur_dispatch";
2153 $sql .=
" (fk_commande, fk_product, qty, fk_entrepot, fk_user, datec, fk_commandefourndet, status, comment, eatby, sellby, batch, fk_reception) VALUES";
2154 $sql .=
" ('".$this->id.
"','".$product.
"','".$qty.
"',".($entrepot > 0 ?
"'".$entrepot.
"'" :
"null").
",'".$user->id.
"','".$this->db->idate($now).
"','".$fk_commandefourndet.
"', ".$dispatchstatus.
", '".$this->db->escape($comment).
"', ";
2155 $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");
2158 dol_syslog(get_class($this).
"::dispatchProduct", LOG_DEBUG);
2159 $resql = $this->db->query(
$sql);
2162 global $conf, $langs, $user;
2164 $result = $this->
call_trigger(
'LINEORDER_SUPPLIER_DISPATCH', $user);
2171 $this->error = $this->db->lasterror();
2176 if (!$error && $entrepot > 0 &&
isModEnabled(
'stock') && !empty($conf->global->STOCK_CALCULATE_ON_SUPPLIER_DISPATCH_ORDER)) {
2180 $mouv->origin = &$this;
2181 $mouv->setOrigin($this->element, $this->
id);
2184 if (!empty($conf->global->SUPPLIER_ORDER_ALLOW_NEGATIVE_QTY_FOR_SUPPLIER_ORDER_RETURN) && $qty < 0) {
2185 $result = $mouv->livraison($user, $product, $entrepot, $qty*(-1), $price, $comment, $now, $eatby, $sellby, $batch, 0, $inventorycode);
2187 $result = $mouv->reception($user, $product, $entrepot, $qty, $price, $comment, $eatby, $sellby, $batch,
'', 0, $inventorycode);
2191 $this->error = $mouv->error;
2192 $this->errors = $mouv->errors;
2193 dol_syslog(get_class($this).
"::dispatchProduct ".$this->error.
" ".join(
',', $this->errors), LOG_ERR);
2200 $this->db->commit();
2203 $this->db->rollback();
2207 $this->error =
'BadStatusForObject';
2221 if ($this->statut == 0) {
2224 if ($line->fetch($idline) <= 0) {
2230 foreach ($dispatchedLines as $dispatchLine) {
2231 if ($dispatchLine[
'orderlineid'] == $idline) {
2232 $this->error =
"LineAlreadyDispatched";
2233 $this->errors[] = $this->error;
2238 if ($line->delete($notrigger) > 0) {
2242 $this->error = $line->error;
2243 $this->errors = $line->errors;
2258 public function delete(
User $user, $notrigger = 0)
2260 global $langs, $conf;
2261 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
2267 if (empty($notrigger)) {
2269 $result = $this->
call_trigger(
'ORDER_SUPPLIER_DELETE', $user);
2271 $this->errors[] =
'ErrorWhenRunningTrigger';
2272 dol_syslog(get_class($this).
"::delete ".$this->error, LOG_ERR);
2273 $this->db->rollback();
2281 if (!empty($this->linkedObjects) && array_key_exists(
'reception', $this->linkedObjects)) {
2282 foreach ($this->linkedObjects[
'reception'] as $element) {
2283 if ($element->statut >= 0) {
2284 $this->errors[] = $langs->trans(
'ReceptionExist');
2291 $main = MAIN_DB_PREFIX.
'commande_fournisseurdet';
2292 $ef = $main.
"_extrafields";
2293 $sql =
"DELETE FROM $ef WHERE fk_object IN (SELECT rowid FROM $main WHERE fk_commande = ".((int) $this->
id).
")";
2294 dol_syslog(get_class($this).
"::delete extrafields lines", LOG_DEBUG);
2295 if (!$this->db->query(
$sql)) {
2296 $this->error = $this->db->lasterror();
2297 $this->errors[] = $this->db->lasterror();
2301 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"commande_fournisseurdet WHERE fk_commande =".((int) $this->
id);
2302 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
2303 if (!$this->db->query(
$sql)) {
2304 $this->error = $this->db->lasterror();
2305 $this->errors[] = $this->db->lasterror();
2309 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"commande_fournisseur WHERE rowid =".((int) $this->
id);
2310 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
2311 if ($resql = $this->db->query(
$sql)) {
2312 if ($this->db->affected_rows($resql) < 1) {
2313 $this->error = $this->db->lasterror();
2314 $this->errors[] = $this->db->lasterror();
2318 $this->error = $this->db->lasterror();
2319 $this->errors[] = $this->db->lasterror();
2327 $this->error =
'FailToDeleteExtraFields';
2328 $this->errors[] =
'FailToDeleteExtraFields';
2330 dol_syslog(get_class($this).
"::delete error -4 ".$this->error, LOG_ERR);
2337 $this->error =
'FailToDeleteObjectLinked';
2338 $this->errors[] =
'FailToDeleteObjectLinked';
2348 if ($conf->fournisseur->commande->dir_output) {
2349 $dir = $conf->fournisseur->commande->dir_output.
"/".$ref;
2350 $file = $dir.
"/".$ref.
".pdf";
2351 if (file_exists($file)) {
2353 $this->error =
'ErrorFailToDeleteFile';
2354 $this->errors[] =
'ErrorFailToDeleteFile';
2358 if (file_exists($dir)) {
2361 $this->error =
'ErrorFailToDeleteDir';
2362 $this->errors[] =
'ErrorFailToDeleteDir';
2370 dol_syslog(get_class($this).
"::delete $this->id by $user->id", LOG_DEBUG);
2371 $this->db->commit();
2374 dol_syslog(get_class($this).
"::delete ".$this->error, LOG_ERR);
2375 $this->db->rollback();
2389 $sql =
"SELECT rowid, libelle";
2390 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_input_method";
2391 $sql .=
" WHERE active = 1";
2393 $resql = $this->db->query(
$sql);
2396 $num = $this->db->num_rows($resql);
2397 $this->methodes_commande = array();
2399 $row = $this->db->fetch_row($resql);
2401 $this->methodes_commande[$row[0]] = $row[1];
2424 $sql =
"SELECT p.ref, p.label,";
2425 $sql .=
" e.rowid as warehouse_id, e.ref as entrepot,";
2426 $sql .=
" cfd.rowid as dispatchedlineid, cfd.fk_product, cfd.qty, cfd.eatby, cfd.sellby, cfd.batch, cfd.comment, cfd.status, cfd.fk_commandefourndet";
2427 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product as p,";
2428 $sql .=
" ".MAIN_DB_PREFIX.
"commande_fournisseur_dispatch as cfd";
2429 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"entrepot as e ON cfd.fk_entrepot = e.rowid";
2430 $sql .=
" WHERE cfd.fk_commande = ".((int) $this->
id);
2431 $sql .=
" AND cfd.fk_product = p.rowid";
2433 $sql .=
" AND cfd.status = ".((int) $status);
2435 $sql .=
" ORDER BY cfd.rowid ASC";
2437 $resql = $this->db->query(
$sql);
2439 $num = $this->db->num_rows($resql);
2443 $objp = $this->db->fetch_object($resql);
2446 'id' => $objp->dispatchedlineid,
2447 'productid' => $objp->fk_product,
2448 'warehouseid' => $objp->warehouse_id,
2449 'qty' => $objp->qty,
2450 'orderlineid' => $objp->fk_commandefourndet
2457 dol_print_error($this->db,
'Failed to execute request to get dispatched lines');
2476 global $conf, $langs;
2483 $usercanreceive = 0;
2485 $usercanreceive = $user->rights->fournisseur->commande->receptionner;
2487 $usercanreceive = $user->rights->reception->creer;
2490 if ($usercanreceive) {
2492 if ($type ==
'par') {
2494 } elseif ($type ==
'tot') {
2496 } elseif ($type ==
'nev') {
2498 } elseif ($type ==
'can') {
2502 dol_syslog(get_class($this).
"::Livraison Error -2", LOG_ERR);
2507 if (!empty($conf->global->SUPPLIER_ORDER_USE_DISPATCH_STATUS)) {
2509 if (!$error && ($type ==
'tot')) {
2511 if (count($dispatchedlinearray) > 0) {
2514 $this->errors[] =
'ErrorCantSetReceptionToTotalDoneWithReceptionToApprove';
2515 dol_syslog(
'ErrorCantSetReceptionToTotalDoneWithReceptionToApprove', LOG_DEBUG);
2518 if (!$error && !empty($conf->global->SUPPLIER_ORDER_USE_DISPATCH_STATUS_NEED_APPROVE) && ($type ==
'tot')) {
2520 if (count($dispatchedlinearray) > 0) {
2523 $this->errors[] =
'ErrorCantSetReceptionToTotalDoneWithReceptionDenied';
2524 dol_syslog(
'ErrorCantSetReceptionToTotalDoneWithReceptionDenied', LOG_DEBUG);
2531 if (empty($error)) {
2534 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur";
2535 $sql .=
" SET fk_statut = ".((int) $statut);
2536 $sql .=
" WHERE rowid = ".((int) $this->
id);
2537 $sql .=
" AND fk_statut IN (".self::STATUS_ORDERSENT.
",".self::STATUS_RECEIVED_PARTIALLY.
")";
2539 dol_syslog(get_class($this).
"::Livraison", LOG_DEBUG);
2540 $resql = $this->db->query(
$sql);
2543 $old_statut = $this->statut;
2544 $this->statut = $statut;
2545 $this->actionmsg2 = $comment;
2548 $result_trigger = $this->
call_trigger(
'ORDER_SUPPLIER_RECEIVE', $user);
2549 if ($result_trigger < 0) {
2554 if (empty($error)) {
2555 $this->db->commit();
2557 $this->statut = $old_statut;
2558 $this->db->rollback();
2559 $this->error = $this->db->lasterror();
2563 $this->db->rollback();
2564 $this->error = $this->db->lasterror();
2569 $this->error = $langs->trans(
'NotAuthorized');
2570 $this->errors[] = $langs->trans(
'NotAuthorized');
2571 dol_syslog(get_class($this).
"::Livraison Not Authorized");
2603 if ($user->rights->fournisseur->commande->creer || $user->rights->supplier_order->creer) {
2608 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur";
2609 $sql .=
" SET date_livraison = ".($delivery_date ?
"'".$this->db->idate($delivery_date).
"'" :
'null');
2610 $sql .=
" WHERE rowid = ".((int) $this->
id);
2613 $resql = $this->db->query(
$sql);
2615 $this->errors[] = $this->db->error();
2620 $this->oldcopy = clone $this;
2621 $this->date_livraison = $delivery_date;
2622 $this->delivery_date = $delivery_date;
2625 if (!$notrigger && empty($error)) {
2627 $result = $this->
call_trigger(
'ORDER_SUPPLIER_MODIFY', $user);
2635 $this->db->commit();
2638 foreach ($this->errors as $errmsg) {
2639 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2640 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2642 $this->db->rollback();
2662 if ($user->rights->fournisseur->commande->creer || $user->rights->supplier_order->creer) {
2667 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"commande_fournisseur";
2668 $sql .=
" SET fk_projet = ".($id_projet > 0 ? (int) $id_projet :
'null');
2669 $sql .=
" WHERE rowid = ".((int) $this->
id);
2672 $resql = $this->db->query(
$sql);
2674 $this->errors[] = $this->db->error();
2679 $this->oldcopy = clone $this;
2680 $this->fk_projet = $id_projet;
2681 $this->fk_project = $id_projet;
2684 if (!$notrigger && empty($error)) {
2686 $result = $this->
call_trigger(
'ORDER_SUPPLIER_MODIFY', $user);
2694 $this->db->commit();
2697 foreach ($this->errors as $errmsg) {
2698 dol_syslog(__METHOD__.
' Error: '.$errmsg, LOG_ERR);
2699 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
2701 $this->db->rollback();
2719 $comclient =
new Commande($this->db);
2720 $comclient->fetch($comclientid);
2724 $this->lines = array();
2726 $num = count($comclient->lines);
2727 for ($i = 0; $i < $num; $i++) {
2728 $prod =
new Product($this->db);
2731 if ($prod->fetch($comclient->lines[$i]->fk_product) > 0) {
2732 $label = $prod->label;
2736 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"commande_fournisseurdet";
2737 $sql .=
" (fk_commande, label, description, fk_product, price, qty, tva_tx, localtax1_tx, localtax2_tx, remise_percent, subprice, remise, ref)";
2738 $sql .=
" VALUES (".((int) $idc).
", '".$this->db->escape($label).
"', '".$this->db->escape($comclient->lines[$i]->desc).
"'";
2739 $sql .=
",".$comclient->lines[$i]->fk_product.
", ".
price2num($comclient->lines[$i]->price,
'MU');
2740 $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);
2741 $sql .=
", '".price2num($comclient->lines[$i]->subprice,
'MT').
"','0', '".$this->db->escape($ref).
"');";
2742 if ($this->db->query(
$sql)) {
2759 global $conf, $langs;
2764 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'commande_fournisseur';
2765 $sql .=
" SET fk_statut = ".$status;
2766 $sql .=
" WHERE rowid = ".((int) $this->
id);
2768 dol_syslog(get_class($this).
"::setStatus", LOG_DEBUG);
2769 $resql = $this->db->query(
$sql);
2772 $triggerName = array();
2773 $triggerName[0] =
'DRAFT';
2774 $triggerName[1] =
'VALIDATED';
2775 $triggerName[2] =
'APPROVED';
2776 $triggerName[3] =
'ORDERED';
2777 $triggerName[4] =
'RECEIVED_PARTIALLY';
2778 $triggerName[5] =
'RECEIVED_COMPLETELY';
2779 $triggerName[6] =
'CANCELED';
2780 $triggerName[7] =
'CANCELED';
2781 $triggerName[9] =
'REFUSED';
2784 $result = $this->
call_trigger(
"ORDER_SUPPLIER_STATUS_".$triggerName[$status], $user);
2791 $this->error = $this->db->lasterror();
2792 dol_syslog(get_class($this).
"::setStatus ".$this->error);
2796 $this->statut = $status;
2797 $this->db->commit();
2800 $this->db->rollback();
2828 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 =
'')
2830 global $mysoc, $conf, $langs;
2831 dol_syslog(get_class($this).
"::updateline $rowid, $desc, $pu, $qty, $remise_percent, $txtva, $price_base_type, $info_bits, $type, $fk_unit");
2832 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
2836 if ($this->brouillon) {
2841 if (empty($info_bits)) {
2844 if (empty($txtva)) {
2847 if (empty($txlocaltax1)) {
2850 if (empty($txlocaltax2)) {
2853 if (empty($remise)) {
2856 if (empty($remise_percent)) {
2857 $remise_percent = 0;
2860 $remise_percent =
price2num($remise_percent);
2866 $pu_ht_devise =
price2num($pu_ht_devise);
2867 if (!preg_match(
'/\((.*)\)/', $txtva)) {
2877 if ($date_start && $date_end && $date_start > $date_end) {
2878 $langs->load(
"errors");
2879 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
2895 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
2896 $vat_src_code = $reg[1];
2897 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
2900 $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);
2901 $total_ht = $tabprice[0];
2902 $total_tva = $tabprice[1];
2903 $total_ttc = $tabprice[2];
2904 $total_localtax1 = $tabprice[9];
2905 $total_localtax2 = $tabprice[10];
2906 $pu_ht = $tabprice[3];
2907 $pu_tva = $tabprice[4];
2908 $pu_ttc = $tabprice[5];
2911 $multicurrency_total_ht = $tabprice[16];
2912 $multicurrency_total_tva = $tabprice[17];
2913 $multicurrency_total_ttc = $tabprice[18];
2914 $pu_ht_devise = $tabprice[19];
2916 $localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
2917 $localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
2921 $this->line->fetch($rowid);
2923 $oldline = clone $this->line;
2924 $this->line->oldline = $oldline;
2926 $this->line->context = $this->context;
2928 $this->line->fk_commande = $this->id;
2930 $this->line->desc = $desc;
2933 if (!empty($conf->global->PRODUCT_USE_SUPPLIER_PACKAGING)) {
2934 if ($qty < $this->line->packaging) {
2935 $qty = $this->line->packaging;
2937 if (!empty($this->line->packaging) && ($qty % $this->line->packaging) > 0) {
2938 $coeff = intval($qty / $this->line->packaging) + 1;
2939 $qty = $this->line->packaging * $coeff;
2940 setEventMessage($langs->trans(
'QtyRecalculatedWithPackaging'),
'mesgs');
2945 $this->line->qty = $qty;
2946 $this->line->ref_supplier = $ref_supplier;
2948 $this->line->vat_src_code = $vat_src_code;
2949 $this->line->tva_tx = $txtva;
2950 $this->line->localtax1_tx = $txlocaltax1;
2951 $this->line->localtax2_tx = $txlocaltax2;
2952 $this->line->localtax1_type = empty($localtaxes_type[0]) ?
'' : $localtaxes_type[0];
2953 $this->line->localtax2_type = empty($localtaxes_type[2]) ?
'' : $localtaxes_type[2];
2954 $this->line->remise_percent = $remise_percent;
2955 $this->line->subprice = $pu_ht;
2956 $this->line->rang = $this->rang;
2957 $this->line->info_bits = $info_bits;
2958 $this->line->total_ht = $total_ht;
2959 $this->line->total_tva = $total_tva;
2960 $this->line->total_localtax1 = $total_localtax1;
2961 $this->line->total_localtax2 = $total_localtax2;
2962 $this->line->total_ttc = $total_ttc;
2963 $this->line->product_type = $type;
2964 $this->line->special_code = (!empty($this->special_code) ? $this->special_code : 0);
2965 $this->line->origin = $this->origin;
2966 $this->line->fk_unit = $fk_unit;
2968 $this->line->date_start = $date_start;
2969 $this->line->date_end = $date_end;
2972 $this->line->fk_multicurrency = $this->fk_multicurrency;
2973 $this->line->multicurrency_code = $this->multicurrency_code;
2974 $this->line->multicurrency_subprice = $pu_ht_devise;
2975 $this->line->multicurrency_total_ht = $multicurrency_total_ht;
2976 $this->line->multicurrency_total_tva = $multicurrency_total_tva;
2977 $this->line->multicurrency_total_ttc = $multicurrency_total_ttc;
2979 $this->line->subprice = $pu_ht;
2980 $this->line->price = $this->line->subprice;
2982 $this->line->remise_percent = $remise_percent;
2984 if (is_array($array_options) && count($array_options) > 0) {
2986 foreach ($array_options as $key => $value) {
2987 $this->line->array_options[$key] = $array_options[$key];
2991 $result = $this->line->update($notrigger);
2997 $this->db->commit();
3000 $this->error = $this->db->lasterror();
3001 $this->db->rollback();
3005 $this->error =
"Order status makes operation forbidden";
3006 dol_syslog(get_class($this).
"::updateline ".$this->error, LOG_ERR);
3021 global $user, $langs, $conf;
3023 include_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
3025 dol_syslog(get_class($this).
"::initAsSpecimen");
3032 $sql =
"SELECT rowid";
3033 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product";
3034 $sql .=
" WHERE entity IN (".getEntity(
'product').
")";
3035 $sql .= $this->db->order(
"rowid",
"ASC");
3036 $sql .= $this->db->plimit(1);
3037 $resql = $this->db->query(
$sql);
3039 $obj = $this->db->fetch_object($resql);
3040 $prodid = $obj->rowid;
3045 $this->
ref =
'SPECIMEN';
3046 $this->specimen = 1;
3049 $this->date_commande = $now;
3050 $this->date_lim_reglement = $this->date + 3600 * 24 * 30;
3051 $this->cond_reglement_code =
'RECEP';
3052 $this->mode_reglement_code =
'CHQ';
3054 $this->note_public =
'This is a comment (public)';
3055 $this->note_private =
'This is a comment (private)';
3057 $this->multicurrency_tx = 1;
3058 $this->multicurrency_code = $conf->currency;
3065 while ($xnbp < $nbp) {
3067 $line->desc = $langs->trans(
"Description").
" ".$xnbp;
3069 $line->subprice = 100;
3071 $line->tva_tx = 19.6;
3072 $line->localtax1_tx = 0;
3073 $line->localtax2_tx = 0;
3075 $line->total_ht = 50;
3076 $line->total_ttc = 59.8;
3077 $line->total_tva = 9.8;
3078 $line->remise_percent = 50;
3080 $line->total_ht = 100;
3081 $line->total_ttc = 119.6;
3082 $line->total_tva = 19.6;
3083 $line->remise_percent = 00;
3085 $line->fk_product = $prodid;
3087 $this->lines[$xnbp] = $line;
3089 $this->total_ht += $line->total_ht;
3090 $this->total_tva += $line->total_tva;
3091 $this->total_ttc += $line->total_ttc;
3105 $sql =
'SELECT c.rowid, date_creation as datec, tms as datem, date_valid as date_validation, date_approve as datea, date_approve2 as datea2,';
3106 $sql .=
' fk_user_author, fk_user_modif, fk_user_valid, fk_user_approve, fk_user_approve2';
3107 $sql .=
' FROM '.MAIN_DB_PREFIX.
'commande_fournisseur as c';
3108 $sql .=
' WHERE c.rowid = '.((int) $id);
3110 $result = $this->db->query(
$sql);
3112 if ($this->db->num_rows($result)) {
3113 $obj = $this->db->fetch_object($result);
3114 $this->
id = $obj->rowid;
3115 if ($obj->fk_user_author) {
3116 $this->user_creation_id = $obj->fk_user_author;
3118 if ($obj->fk_user_valid) {
3119 $this->user_validation_id = $obj->fk_user_valid;
3121 if ($obj->fk_user_modif) {
3122 $this->user_modification_id = $obj->fk_user_modif;
3124 if ($obj->fk_user_approve) {
3125 $this->user_approve_id = $obj->fk_user_approve;
3127 if ($obj->fk_user_approve2) {
3128 $this->user_approve_id2 = $obj->fk_user_approve2;
3131 $this->date_creation = $this->db->jdate($obj->datec);
3132 $this->date_modification = $this->db->jdate($obj->datem);
3133 $this->date_approve = $this->db->jdate($obj->datea);
3134 $this->date_approve2 = $this->db->jdate($obj->datea2);
3135 $this->date_validation = $this->db->jdate($obj->date_validation);
3137 $this->db->free($result);
3152 global $conf, $user;
3154 $this->nb = array();
3157 $sql =
"SELECT count(co.rowid) as nb";
3158 $sql .=
" FROM ".MAIN_DB_PREFIX.
"commande_fournisseur as co";
3159 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON co.fk_soc = s.rowid";
3160 if (empty($user->rights->societe->client->voir) && !$user->socid) {
3161 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON s.rowid = sc.fk_soc";
3162 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
3165 $sql .=
" ".$clause.
" co.entity IN (".
getEntity(
'supplier_order').
")";
3167 $resql = $this->db->query(
$sql);
3169 while ($obj = $this->db->fetch_object($resql)) {
3170 $this->nb[
"supplier_orders"] = $obj->nb;
3172 $this->db->free($resql);
3176 $this->error = $this->db->error();
3192 global $conf, $langs;
3194 $sql =
"SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date, c.total_ht";
3195 $sql .=
" FROM ".MAIN_DB_PREFIX.
"commande_fournisseur as c";
3196 if (empty($user->rights->societe->client->voir) && !$user->socid) {
3197 $sql .=
" JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON c.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
3199 $sql .=
" WHERE c.entity = ".$conf->entity;
3200 if ($mode ===
'awaiting') {
3201 $sql .=
" AND c.fk_statut IN (".self::STATUS_ORDERSENT.
", ".self::STATUS_RECEIVED_PARTIALLY.
")";
3203 $sql .=
" AND c.fk_statut IN (".self::STATUS_VALIDATED.
", ".self::STATUS_ACCEPTED.
")";
3206 $sql .=
" AND c.fk_soc = ".((int) $user->socid);
3209 $resql = $this->db->query(
$sql);
3214 $response->warning_delay = $conf->commande->fournisseur->warning_delay / 60 / 60 / 24;
3215 $response->label = $langs->trans(
"SuppliersOrdersToProcess");
3216 $response->labelShort = $langs->trans(
"Opened");
3217 $response->url = DOL_URL_ROOT.
'/fourn/commande/list.php?search_status=1,2&mainmenu=commercial&leftmenu=orders_suppliers';
3220 if ($mode ===
'awaiting') {
3221 $response->label = $langs->trans(
"SuppliersOrdersAwaitingReception");
3222 $response->labelShort = $langs->trans(
"AwaitingReception");
3223 $response->url = DOL_URL_ROOT.
'/fourn/commande/list.php?search_status=3,4&mainmenu=commercial&leftmenu=orders_suppliers';
3226 while ($obj = $this->db->fetch_object($resql)) {
3227 $commandestatic->delivery_date = $this->db->jdate($obj->delivery_date);
3228 $commandestatic->date_commande = $this->db->jdate($obj->date_commande);
3229 $commandestatic->statut = $obj->fk_statut;
3231 $response->nbtodo++;
3232 $response->total += $obj->total_ht;
3234 if ($commandestatic->hasDelay()) {
3235 $response->nbtodolate++;
3241 $this->error = $this->db->error();
3256 if ($this->methode_commande_id > 0) {
3257 $sql =
"SELECT rowid, code, libelle as label";
3258 $sql .=
" FROM ".MAIN_DB_PREFIX.
'c_input_method';
3259 $sql .=
" WHERE active=1 AND rowid = ".((int) $this->methode_commande_id);
3261 $resql = $this->db->query(
$sql);
3263 if ($this->db->num_rows($resql)) {
3264 $obj = $this->db->fetch_object($resql);
3266 $string = $langs->trans($obj->code);
3267 if ($string == $obj->code) {
3268 $string = $obj->label !=
'-' ? $obj->label :
'';
3291 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
3293 global $conf, $langs;
3298 if (!empty($this->model_pdf)) {
3299 $modele = $this->model_pdf;
3300 } elseif (!empty($conf->global->COMMANDE_SUPPLIER_ADDON_PDF)) {
3305 if (empty($modele)) {
3308 $langs->load(
"suppliers");
3309 $outputlangs->load(
"products");
3311 $modelpath =
"core/modules/supplier_order/doc/";
3312 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
3324 if (empty($this->lines)) {
3331 foreach ($this->lines as $line) {
3332 if ($line->fk_product > 0) {
3333 $idp = $obj->find_min_price_product_fournisseur($line->fk_product, $line->qty);
3336 if ($obj->delivery_time_days > $nb) {
3337 $nb = $obj->delivery_time_days;
3346 return $nb.
' '.$langs->trans(
'Days');
3358 return $user->rights->fournisseur->commande;
3373 'commande_fournisseur'
3390 'commande_fournisseurdet'
3407 if (empty($this->delivery_date) && !empty($this->date_livraison)) {
3408 $this->delivery_date = $this->date_livraison;
3411 if ($this->statut == self::STATUS_ORDERSENT || $this->statut == self::STATUS_RECEIVED_PARTIALLY) {
3413 if (!empty($this->delivery_date)) {
3414 $date_to_test = $this->delivery_date;
3415 return $date_to_test && $date_to_test < ($now - $conf->commande->fournisseur->warning_delay);
3423 $date_to_test = $this->date_commande;
3425 return ($this->statut > 0 && $this->statut < 5) && $date_to_test && $date_to_test < ($now - $conf->commande->fournisseur->warning_delay);
3438 global $conf, $langs;
3440 if (empty($this->delivery_date) && !empty($this->date_livraison)) {
3441 $this->delivery_date = $this->date_livraison;
3446 if ($this->statut == self::STATUS_ORDERSENT || $this->statut == self::STATUS_RECEIVED_PARTIALLY) {
3447 if (!empty($this->delivery_date)) {
3448 $text = $langs->trans(
"DeliveryDate").
' '.
dol_print_date($this->delivery_date,
'day');
3450 $text = $langs->trans(
"OrderDate").
' '.
dol_print_date($this->date_commande,
'day');
3453 $text = $langs->trans(
"OrderDate").
' '.
dol_print_date($this->date_commande,
'day');
3456 $text .=
' '.($conf->commande->fournisseur->warning_delay > 0 ?
'+' :
'-').
' '.round(abs($conf->commande->fournisseur->warning_delay) / 3600 / 24, 1).
' '.$langs->trans(
"days").
' < '.$langs->trans(
"Today");
3473 global $conf, $langs;
3476 require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.commande.dispatch.class.php';
3478 $qtydelivered = array();
3479 $qtywished = array();
3482 $filter = array(
't.fk_commande'=>$this->
id);
3483 if (!empty($conf->global->SUPPLIER_ORDER_USE_DISPATCH_STATUS)) {
3484 $filter[
't.status'] = 1;
3487 $ret = $supplierorderdispatch->fetchAll(
'',
'', 0, 0, $filter);
3489 $this->error = $supplierorderdispatch->error; $this->errors = $supplierorderdispatch->errors;
3492 if (is_array($supplierorderdispatch->lines) && count($supplierorderdispatch->lines) > 0) {
3493 require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
3497 foreach ($supplierorderdispatch->lines as $line) {
3498 $qtydelivered[$line->fk_product] += $line->qty;
3500 foreach ($this->lines as $line) {
3502 if (empty($conf->global->STOCK_SUPPORTS_SERVICES) && $line->product_type > 0) {
3505 $qtywished[$line->fk_product] += $line->qty;
3509 $diff_array = array_diff_assoc($qtydelivered, $qtywished);
3510 $keysinwishednotindelivered = array_diff(array_keys($qtywished), array_keys($qtydelivered));
3511 $keysindeliverednotinwished = array_diff(array_keys($qtydelivered), array_keys($qtywished));
3519 if (count($diff_array) == 0 && count($keysinwishednotindelivered) == 0 && count($keysindeliverednotinwished) == 0) {
3520 if ($closeopenorder) {
3522 $ret = $this->
Livraison($user, $date_liv,
'tot', $comment);
3530 $ret = $this->
Livraison($user, $date_liv,
'par', $comment);
3536 } elseif (!empty($conf->global->SUPPLIER_ORDER_MORE_THAN_WISHED)) {
3541 if (count($diff_array) > 0) {
3545 foreach ($diff_array as $key => $value) {
3547 if ($qtydelivered[$key] >= $qtywished[$key]) {
3554 if ($close == count($diff_array)) {
3556 if ($closeopenorder) {
3557 $ret = $this->
Livraison($user, $date_liv,
'tot', $comment);
3564 $ret = $this->
Livraison($user, $date_liv,
'par', $comment);
3572 $ret = $this->
Livraison($user, $date_liv,
'par', $comment);
3580 $ret = $this->
Livraison($user, $date_liv,
'par', $comment);
3602 $this->receptions = array();
3604 dol_syslog(get_class($this).
"::loadReceptions", LOG_DEBUG);
3606 $sql =
'SELECT cd.rowid, cd.fk_product,';
3607 $sql .=
' sum(cfd.qty) as qty';
3608 $sql .=
' FROM '.MAIN_DB_PREFIX.
'commande_fournisseur_dispatch as cfd,';
3609 if ($filtre_statut >= 0) {
3610 $sql .=
' '.MAIN_DB_PREFIX.
'reception as e,';
3612 $sql .=
' '.MAIN_DB_PREFIX.
'commande_fournisseurdet as cd';
3614 if ($filtre_statut >= 0) {
3615 $sql .=
' cfd.fk_reception = e.rowid AND';
3617 $sql .=
' cfd.fk_commandefourndet = cd.rowid';
3618 $sql .=
' AND cd.fk_commande ='.((int) $this->
id);
3619 if ($this->fk_product > 0) {
3620 $sql .=
' AND cd.fk_product = '.((int) $this->fk_product);
3622 if ($filtre_statut >= 0) {
3623 $sql .=
' AND e.fk_statut >= '.((int) $filtre_statut);
3625 $sql .=
' GROUP BY cd.rowid, cd.fk_product';
3627 $resql = $this->db->query(
$sql);
3629 $num = $this->db->num_rows($resql);
3632 $obj = $this->db->fetch_object($resql);
3633 empty($this->receptions[$obj->rowid]) ? $this->receptions[$obj->rowid] = $obj->qty : $this->receptions[$obj->rowid] += $obj->qty;
3636 $this->db->free($resql);
3640 $this->error = $this->db->lasterror();
3656 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
3658 $return =
'<div class="box-flex-item box-flex-grow-zero">';
3659 $return .=
'<div class="info-box info-box-sm">';
3660 $return .=
'<span class="info-box-icon bg-infobox-action">';
3662 $return .=
'</span>';
3663 $return .=
'<div class="info-box-content">';
3664 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl() : $this->ref).
'</span>';
3665 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
3666 if (property_exists($this,
'socid') || property_exists($this,
'total_tva')) {
3667 $return .=
'<br><span class="info-box-label amount">'.$this->socid.
'</span>';
3669 if (property_exists($this,
'billed')) {
3670 $return .=
'<br><span class="opacitymedium">'.$langs->trans(
"Billed").
' : </span><span class="info-box-label">'.
yn($this->billed).
'</span>';
3672 if (method_exists($this,
'getLibStatut')) {
3673 $return .=
'<br><div class="info-box-status margintoponly">'.$this->getLibStatut(3).
'</div>';
3675 $return .=
'</div>';
3676 $return .=
'</div>';
3677 $return .=
'</div>';
3692 public $element =
'commande_fournisseurdet';
3697 public $table_element =
'commande_fournisseurdet';
3705 public $fk_commande;
3711 public $fk_parent_line;
3719 public $special_code = 0;
3736 public $ref_supplier;
3768 $sql =
'SELECT cd.rowid, cd.fk_commande, cd.fk_product, cd.product_type, cd.description, cd.qty, cd.tva_tx, cd.special_code,';
3769 $sql .=
' cd.localtax1_tx, cd.localtax2_tx, cd.localtax1_type, cd.localtax2_type, cd.ref as ref_supplier,';
3770 $sql .=
' cd.remise, cd.remise_percent, cd.subprice,';
3771 $sql .=
' cd.info_bits, cd.total_ht, cd.total_tva, cd.total_ttc,';
3772 $sql .=
' cd.total_localtax1, cd.total_localtax2,';
3773 $sql .=
' p.ref as product_ref, p.label as product_label, p.description as product_desc,';
3774 $sql .=
' cd.date_start, cd.date_end, cd.fk_unit,';
3775 $sql .=
' cd.multicurrency_subprice, cd.multicurrency_total_ht, cd.multicurrency_total_tva, cd.multicurrency_total_ttc,';
3776 $sql .=
' c.fk_soc as socid';
3777 $sql .=
' FROM '.MAIN_DB_PREFIX.
'commande_fournisseur as c, '.MAIN_DB_PREFIX.
'commande_fournisseurdet as cd';
3778 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON cd.fk_product = p.rowid';
3779 $sql .=
' WHERE cd.fk_commande = c.rowid AND cd.rowid = '.((int) $rowid);
3781 $result = $this->db->query(
$sql);
3783 $objp = $this->db->fetch_object($result);
3785 if (!empty($objp)) {
3786 $this->
rowid = $objp->rowid;
3787 $this->
id = $objp->rowid;
3788 $this->fk_commande = $objp->fk_commande;
3789 $this->desc = $objp->description;
3790 $this->qty = $objp->qty;
3791 $this->ref_fourn = $objp->ref_supplier;
3792 $this->ref_supplier = $objp->ref_supplier;
3793 $this->subprice = $objp->subprice;
3794 $this->tva_tx = $objp->tva_tx;
3795 $this->localtax1_tx = $objp->localtax1_tx;
3796 $this->localtax2_tx = $objp->localtax2_tx;
3797 $this->localtax1_type = $objp->localtax1_type;
3798 $this->localtax2_type = $objp->localtax2_type;
3799 $this->remise = $objp->remise;
3800 $this->remise_percent = $objp->remise_percent;
3801 $this->fk_product = $objp->fk_product;
3802 $this->info_bits = $objp->info_bits;
3803 $this->total_ht = $objp->total_ht;
3804 $this->total_tva = $objp->total_tva;
3805 $this->total_localtax1 = $objp->total_localtax1;
3806 $this->total_localtax2 = $objp->total_localtax2;
3807 $this->total_ttc = $objp->total_ttc;
3808 $this->product_type = $objp->product_type;
3809 $this->special_code = $objp->special_code;
3811 $this->
ref = $objp->product_ref;
3813 $this->product_ref = $objp->product_ref;
3814 $this->product_label = $objp->product_label;
3815 $this->product_desc = $objp->product_desc;
3817 if (!empty($conf->global->PRODUCT_USE_SUPPLIER_PACKAGING)) {
3822 $sqlsearchpackage =
'SELECT rowid, packaging FROM '.MAIN_DB_PREFIX.
"product_fournisseur_price";
3823 $sqlsearchpackage .=
' WHERE entity IN ('.getEntity(
'product_fournisseur_price').
")";
3824 $sqlsearchpackage .=
" AND fk_product = ".((int) $objp->fk_product);
3825 $sqlsearchpackage .=
" AND ref_fourn = '".$this->db->escape($objp->ref_supplier).
"'";
3826 $sqlsearchpackage .=
" AND quantity <= ".((float) $objp->qty);
3827 $sqlsearchpackage .=
" AND (packaging IS NULL OR packaging = 0 OR packaging <= ".((float) $objp->qty).
")";
3828 $sqlsearchpackage .=
" AND fk_soc = ".((int) $objp->socid);
3829 $sqlsearchpackage .=
" ORDER BY packaging ASC";
3830 $sqlsearchpackage .=
" LIMIT 1";
3832 $resqlsearchpackage = $this->db->query($sqlsearchpackage);
3833 if ($resqlsearchpackage) {
3834 $objsearchpackage = $this->db->fetch_object($resqlsearchpackage);
3835 if ($objsearchpackage) {
3836 $this->fk_fournprice = $objsearchpackage->rowid;
3837 $this->packaging = $objsearchpackage->packaging;
3840 $this->error = $this->db->lasterror();
3845 $this->date_start = $this->db->jdate($objp->date_start);
3846 $this->date_end = $this->db->jdate($objp->date_end);
3847 $this->fk_unit = $objp->fk_unit;
3849 $this->multicurrency_subprice = $objp->multicurrency_subprice;
3850 $this->multicurrency_total_ht = $objp->multicurrency_total_ht;
3851 $this->multicurrency_total_tva = $objp->multicurrency_total_tva;
3852 $this->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
3856 $this->db->free($result);
3859 $this->error =
'Supplier order line with id='.$rowid.
' not found';
3860 dol_syslog(get_class($this).
"::fetch Error ".$this->error, LOG_ERR);
3877 global $conf, $user;
3881 dol_syslog(get_class($this).
"::insert rang=".$this->rang);
3884 if (empty($this->tva_tx)) {
3887 if (empty($this->localtax1_tx)) {
3888 $this->localtax1_tx = 0;
3890 if (empty($this->localtax2_tx)) {
3891 $this->localtax2_tx = 0;
3893 if (empty($this->localtax1_type)) {
3894 $this->localtax1_type =
'0';
3896 if (empty($this->localtax2_type)) {
3897 $this->localtax2_type =
'0';
3899 if (empty($this->total_localtax1)) {
3900 $this->total_localtax1 = 0;
3902 if (empty($this->total_localtax2)) {
3903 $this->total_localtax2 = 0;
3905 if (empty($this->rang)) {
3908 if (empty($this->remise_percent)) {
3909 $this->remise_percent = 0;
3911 if (empty($this->info_bits)) {
3912 $this->info_bits = 0;
3914 if (empty($this->special_code)) {
3915 $this->special_code = 0;
3917 if (empty($this->fk_parent_line)) {
3918 $this->fk_parent_line = 0;
3920 if (empty($this->pa_ht)) {
3925 if (!empty($this->multicurrency_code)) {
3928 if (empty($this->fk_multicurrency)) {
3929 $this->multicurrency_code = $conf->currency;
3930 $this->fk_multicurrency = 0;
3931 $this->multicurrency_tx = 1;
3935 if ($this->product_type < 0) {
3942 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.$this->table_element;
3943 $sql .=
" (fk_commande, label, description, date_start, date_end,";
3944 $sql .=
" fk_product, product_type, special_code, rang,";
3945 $sql .=
" qty, vat_src_code, tva_tx, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, remise_percent, subprice, ref,";
3946 $sql .=
" total_ht, total_tva, total_localtax1, total_localtax2, total_ttc, fk_unit,";
3947 $sql .=
" fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc";
3949 $sql .=
" VALUES (".$this->fk_commande.
", '".$this->db->escape($this->label).
"','".$this->db->escape($this->desc).
"',";
3950 $sql .=
" ".($this->date_start ?
"'".$this->db->idate($this->date_start).
"'" :
"null").
",";
3951 $sql .=
" ".($this->date_end ?
"'".$this->db->idate($this->date_end).
"'" :
"null").
",";
3952 if ($this->fk_product) {
3953 $sql .= $this->fk_product.
",";
3957 $sql .=
"'".$this->db->escape($this->product_type).
"',";
3958 $sql .=
"'".$this->db->escape($this->special_code).
"',";
3959 $sql .=
"'".$this->db->escape($this->rang).
"',";
3960 $sql .=
"'".$this->db->escape($this->qty).
"', ";
3961 $sql .=
" ".(empty($this->vat_src_code) ?
"''" :
"'".$this->db->escape($this->vat_src_code).
"'").
",";
3962 $sql .=
" ".price2num($this->tva_tx).
", ";
3963 $sql .=
" ".price2num($this->localtax1_tx).
",";
3964 $sql .=
" ".price2num($this->localtax2_tx).
",";
3965 $sql .=
" '".$this->db->escape($this->localtax1_type).
"',";
3966 $sql .=
" '".$this->db->escape($this->localtax2_type).
"',";
3967 $sql .=
" ".((float) $this->remise_percent).
", ".
price2num($this->subprice,
'MU').
", '".$this->db->escape($this->ref_supplier).
"',";
3968 $sql .=
" ".price2num($this->total_ht).
",";
3969 $sql .=
" ".price2num($this->total_tva).
",";
3970 $sql .=
" ".price2num($this->total_localtax1).
",";
3971 $sql .=
" ".price2num($this->total_localtax2).
",";
3972 $sql .=
" ".price2num($this->total_ttc).
",";
3973 $sql .= ($this->fk_unit ?
"'".$this->db->escape($this->fk_unit).
"'" :
"null");
3974 $sql .=
", ".($this->fk_multicurrency ? ((int) $this->fk_multicurrency) :
"null");
3975 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
3976 $sql .=
", ".($this->multicurrency_subprice ?
price2num($this->multicurrency_subprice) :
'0');
3977 $sql .=
", ".($this->multicurrency_total_ht ?
price2num($this->multicurrency_total_ht) :
'0');
3978 $sql .=
", ".($this->multicurrency_total_tva ?
price2num($this->multicurrency_total_tva) :
'0');
3979 $sql .=
", ".($this->multicurrency_total_ttc ?
price2num($this->multicurrency_total_ttc) :
'0');
3982 dol_syslog(get_class($this).
"::insert", LOG_DEBUG);
3983 $resql = $this->db->query(
$sql);
3985 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.$this->table_element);
3986 $this->
rowid = $this->id;
3995 if (!$error && !$notrigger) {
3997 $result = $this->
call_trigger(
'LINEORDER_SUPPLIER_CREATE', $user);
4005 $this->db->commit();
4009 foreach ($this->errors as $errmsg) {
4010 dol_syslog(get_class($this).
"::delete ".$errmsg, LOG_ERR);
4011 $this->errors[] = ($this->errors ?
', '.$errmsg : $errmsg);
4013 $this->db->rollback();
4016 $this->errors[] = $this->db->error();
4017 $this->db->rollback();
4029 global $conf, $user;
4036 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element.
" SET";
4037 $sql .=
" description='".$this->db->escape($this->desc).
"'";
4038 $sql .=
", ref='".$this->db->escape($this->ref_supplier).
"'";
4039 $sql .=
", subprice='".price2num($this->subprice).
"'";
4041 $sql .=
", remise_percent='".price2num($this->remise_percent).
"'";
4043 $sql .=
", vat_src_code = '".(empty($this->vat_src_code) ?
'' : $this->vat_src_code).
"'";
4044 $sql .=
", tva_tx='".price2num($this->tva_tx).
"'";
4045 $sql .=
", localtax1_tx='".price2num($this->localtax1_tx).
"'";
4046 $sql .=
", localtax2_tx='".price2num($this->localtax2_tx).
"'";
4047 $sql .=
", localtax1_type='".$this->db->escape($this->localtax1_type).
"'";
4048 $sql .=
", localtax2_type='".$this->db->escape($this->localtax2_type).
"'";
4049 $sql .=
", qty='".price2num($this->qty).
"'";
4050 $sql .=
", date_start=".(!empty($this->date_start) ?
"'".$this->db->idate($this->date_start).
"'" :
"null");
4051 $sql .=
", date_end=".(!empty($this->date_end) ?
"'".$this->db->idate($this->date_end).
"'" :
"null");
4052 $sql .=
", info_bits='".$this->db->escape($this->info_bits).
"'";
4053 $sql .=
", total_ht='".price2num($this->total_ht).
"'";
4054 $sql .=
", total_tva='".price2num($this->total_tva).
"'";
4055 $sql .=
", total_localtax1='".price2num($this->total_localtax1).
"'";
4056 $sql .=
", total_localtax2='".price2num($this->total_localtax2).
"'";
4057 $sql .=
", total_ttc='".price2num($this->total_ttc).
"'";
4058 $sql .=
", product_type=".$this->product_type;
4059 $sql .=
", special_code=".(!empty($this->special_code) ? $this->special_code : 0);
4060 $sql .= ($this->fk_unit ?
", fk_unit='".$this->db->escape($this->fk_unit).
"'" :
", fk_unit=null");
4063 $sql .=
", multicurrency_subprice=".price2num($this->multicurrency_subprice);
4064 $sql .=
", multicurrency_total_ht=".price2num($this->multicurrency_total_ht);
4065 $sql .=
", multicurrency_total_tva=".price2num($this->multicurrency_total_tva);
4066 $sql .=
", multicurrency_total_ttc=".price2num($this->multicurrency_total_ttc);
4068 $sql .=
" WHERE rowid = ".((int) $this->
id);
4070 dol_syslog(get_class($this).
"::updateline", LOG_DEBUG);
4071 $resql = $this->db->query(
$sql);
4080 if (!$error && !$notrigger) {
4082 $result = $this->
call_trigger(
'LINEORDER_SUPPLIER_MODIFY', $user);
4084 $this->db->rollback();
4091 $this->db->commit();
4094 $this->db->rollback();
4098 $this->error = $this->db->lasterror();
4099 $this->db->rollback();
4110 public function delete($notrigger = 0)
4121 $this->db->rollback();
4125 $sql =
'DELETE FROM '.MAIN_DB_PREFIX.
"commande_fournisseurdet WHERE rowid=".((int) $this->
id);
4128 $resql = $this->db->query(
$sql);
4132 $result = $this->
call_trigger(
'LINEORDER_SUPPLIER_DELETE', $user);
4140 $this->db->commit();
4144 foreach ($this->errors as $errmsg) {
4145 dol_syslog(get_class($this).
"::delete ".$errmsg, LOG_ERR);
4146 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
4148 $this->db->rollback();
4151 $this->error = $this->db->lasterror();