33require_once DOL_DOCUMENT_ROOT.
'/core/class/notify.class.php';
34require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
35require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.facture.class.php';
36require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.facture-rec.ligne.class.php';
37require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
49 public $TRIGGER_PREFIX =
'SUPPLIERBILLREC';
54 public $element =
'invoice_supplier_rec';
59 public $table_element =
'facture_fourn_rec';
64 public $table_element_line =
'facture_fourn_det_rec';
69 public $fk_element =
'fk_facture_fourn';
74 public $picto =
'supplier_invoice';
135 public $vat_src_code;
161 public $mode_reglement_id;
165 public $mode_reglement_code;
169 public $cond_reglement_code;
173 public $cond_reglement_doc;
177 public $cond_reglement_id;
182 public $date_lim_reglement;
187 public $usenewprice = 0;
195 public $unit_frequency;
203 public $date_last_gen;
218 public $auto_validate;
222 public $generate_pdf;
228 public $lines = array();
270 public $fields = array(
271 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 10),
272 'titre' => array(
'type' =>
'varchar(100)',
'label' =>
'Titre',
'enabled' => 1,
'showoncombobox' => 1,
'visible' => -1,
'position' => 15),
273 'ref_supplier' => array(
'type' =>
'varchar(180)',
'label' =>
'RefSupplier',
'enabled' => 1,
'showoncombobox' => 1,
'visible' => -1,
'position' => 20),
274 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'default' =>
'1',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 25,
'index' => 1),
275 'fk_soc' => array(
'type' =>
'integer:Societe:societe/class/societe.class.php',
'label' =>
'ThirdParty',
'enabled' =>
'isModEnabled("societe")',
'visible' => -1,
'notnull' => 1,
'position' => 30),
276 'datec' => array(
'type' =>
'datetime',
'label' =>
'DateCreation',
'enabled' => 1,
'visible' => -1,
'position' => 35),
277 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModification',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 40),
278 'suspended' => array(
'type' =>
'integer',
'label' =>
'Suspended',
'enabled' => 1,
'visible' => -1,
'position' => 225),
279 'libelle' => array(
'type' =>
'varchar(100)',
'label' =>
'Libelle',
'enabled' => 1,
'showoncombobox' => 0,
'visible' => -1,
'position' => 15),
281 'localtax1' => array(
'type' =>
'double(24,8)',
'label' =>
'Localtax1',
'enabled' => 1,
'visible' => -1,
'position' => 60,
'isameasure' => 1),
282 'localtax2' => array(
'type' =>
'double(24,8)',
'label' =>
'Localtax2',
'enabled' => 1,
'visible' => -1,
'position' => 65,
'isameasure' => 1),
283 'total_ht' => array(
'type' =>
'double(24,8)',
'label' =>
'Total',
'enabled' => 1,
'visible' => -1,
'position' => 70,
'isameasure' => 1),
284 'total_tva' => array(
'type' =>
'double(24,8)',
'label' =>
'Tva',
'enabled' => 1,
'visible' => -1,
'position' => 55,
'isameasure' => 1),
285 'total_ttc' => array(
'type' =>
'double(24,8)',
'label' =>
'Total ttc',
'enabled' => 1,
'visible' => -1,
'position' => 75,
'isameasure' => 1),
287 'fk_user_author' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserAuthor',
'enabled' => 1,
'visible' => -1,
'position' => 80),
288 'fk_user_modif' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserModif',
'enabled' => 1,
'visible' => -2,
'notnull' => -1,
'position' => 210),
289 'fk_projet' => array(
'type' =>
'integer:Project:projet/class/project.class.php:1:fk_statut=1',
'label' =>
'Project',
'enabled' =>
"isModEnabled('project')",
'visible' => -1,
'position' => 85),
290 'fk_account' => array(
'type' =>
'integer',
'label' =>
'BankAccount',
'enabled' =>
'isModEnabled("bank")',
'visible' => -1,
'position' => 175),
291 'fk_cond_reglement' => array(
'type' =>
'integer',
'label' =>
'PaymentTerm',
'enabled' => 1,
'visible' => -1,
'position' => 90),
292 'fk_mode_reglement' => array(
'type' =>
'integer',
'label' =>
'PaymentMode',
'enabled' => 1,
'visible' => -1,
'position' => 95),
293 'date_lim_reglement' => array(
'type' =>
'date',
'label' =>
'Date lim reglement',
'enabled' => 1,
'visible' => -1,
'position' => 100),
295 'note_private' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 105),
296 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => 0,
'position' => 110),
297 'modelpdf' => array(
'type' =>
'varchar(255)',
'label' =>
'Modelpdf',
'enabled' => 1,
'visible' => -1,
'position' => 115),
299 'fk_multicurrency' => array(
'type' =>
'integer',
'label' =>
'Currency',
'enabled' => 1,
'visible' => -1,
'position' => 180),
300 'multicurrency_code' => array(
'type' =>
'varchar(255)',
'label' =>
'Multicurrency code',
'enabled' => 1,
'visible' => -1,
'position' => 185),
301 'multicurrency_tx' => array(
'type' =>
'double(24,8)',
'label' =>
'Multicurrency tx',
'enabled' => 1,
'visible' => -1,
'position' => 190,
'isameasure' => 1),
302 'multicurrency_total_ht' => array(
'type' =>
'double(24,8)',
'label' =>
'Multicurrency total ht',
'enabled' => 1,
'visible' => -1,
'position' => 195,
'isameasure' => 1),
303 'multicurrency_total_tva' => array(
'type' =>
'double(24,8)',
'label' =>
'Multicurrency total tva',
'enabled' => 1,
'visible' => -1,
'position' => 200,
'isameasure' => 1),
304 'multicurrency_total_ttc' => array(
'type' =>
'double(24,8)',
'label' =>
'Multicurrency total ttc',
'enabled' => 1,
'visible' => -1,
'position' => 205,
'isameasure' => 1),
306 'usenewprice' => array(
'type' =>
'integer',
'label' =>
'UseNewPrice',
'enabled' => 1,
'visible' => 0,
'position' => 155),
307 'frequency' => array(
'type' =>
'integer',
'label' =>
'Frequency',
'enabled' => 1,
'visible' => -1,
'position' => 150),
308 'unit_frequency' => array(
'type' =>
'varchar(2)',
'label' =>
'Unit frequency',
'enabled' => 1,
'visible' => -1,
'position' => 125),
310 'date_when' => array(
'type' =>
'datetime',
'label' =>
'Date when',
'enabled' => 1,
'visible' => -1,
'position' => 130),
311 'date_last_gen' => array(
'type' =>
'datetime',
'label' =>
'Date last gen',
'enabled' => 1,
'visible' => -1,
'position' => 135),
312 'nb_gen_done' => array(
'type' =>
'integer',
'label' =>
'Nb gen done',
'enabled' => 1,
'visible' => -1,
'position' => 140),
313 'nb_gen_max' => array(
'type' =>
'integer',
'label' =>
'Nb gen max',
'enabled' => 1,
'visible' => -1,
'position' => 145),
314 'revenuestamp' => array(
'type' =>
'double(24,8)',
'label' =>
'RevenueStamp',
'enabled' => 1,
'visible' => -1,
'position' => 160,
'isameasure' => 1),
315 'auto_validate' => array(
'type' =>
'integer',
'label' =>
'Auto validate',
'enabled' => 1,
'visible' => -1,
'position' => 165),
316 'generate_pdf' => array(
'type' =>
'integer',
'label' =>
'Generate pdf',
'enabled' => 1,
'visible' => -1,
'position' => 170),
320 const STATUS_NOTSUSPENDED = 0;
321 const STATUS_SUSPENDED = 1;
344 public function create($user, $facFournId, $notrigger = 0, $onlylines = array())
351 $label = empty($this->label) ? $this->libelle : $this->label;
354 $this->titre = empty($this->titre) ?
'' : $this->titre;
355 $this->title = empty($this->title) ?
'' : $this->title;
357 $this->
ref = $this->$keyforref;
359 $this->ref_supplier = empty($this->ref_supplier) ?
'' : $this->ref_supplier;
361 $this->usenewprice = empty($this->usenewprice) ? 0 : $this->usenewprice;
362 $this->suspended = empty($this->suspended) ? 0 : $this->suspended;
364 if (empty($this->frequency)) {
365 $this->frequency = 0;
366 $this->date_when =
null;
368 $this->frequency = abs($this->frequency);
369 $this->nb_gen_done = 0;
370 $this->nb_gen_max = empty($this->nb_gen_max) ? 0 : $this->nb_gen_max;
371 $this->auto_validate = empty($this->auto_validate) ? 0 : $this->auto_validate;
372 $this->generate_pdf = empty($this->generate_pdf) ? 0 : $this->generate_pdf;
378 $result = $facfourn_src->fetch($facFournId);
380 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.
'facture_fourn_rec (';
383 $sql .=
', ref_supplier';
387 $sql .=
', suspended';
389 $sql .=
', total_ttc';
390 $sql .=
', fk_user_author';
391 $sql .=
', fk_projet';
392 $sql .=
', fk_account';
393 $sql .=
', fk_cond_reglement';
394 $sql .=
', fk_mode_reglement';
395 $sql .=
', date_lim_reglement';
396 $sql .=
', note_private';
397 $sql .=
', note_public';
398 $sql .=
', modelpdf';
399 $sql .=
', fk_multicurrency';
400 $sql .=
', multicurrency_code';
401 $sql .=
', multicurrency_tx';
402 $sql .=
', usenewprice';
403 $sql .=
', frequency';
404 $sql .=
', unit_frequency';
405 $sql .=
', date_when';
406 $sql .=
', date_last_gen';
407 $sql .=
', nb_gen_done';
408 $sql .=
', nb_gen_max';
409 $sql .=
', auto_validate';
410 $sql .=
', generate_pdf';
411 $sql .=
') VALUES (';
412 $sql .=
"'".$this->db->escape($this->title).
"'";
413 $sql .=
", ".(isset($this->subtype) ? (int) $this->subtype :
"NULL");
414 $sql .=
", '".$this->db->escape($this->ref_supplier).
"'";
415 $sql .=
", ".((int)
$conf->entity);
416 $sql .=
", ".((int) $facfourn_src->socid);
417 $sql .=
", '".$this->db->idate($now).
"'";
418 $sql .=
", ".((int) $this->suspended);
419 $sql .=
", '".$this->db->escape($label).
"'";
420 $sql .=
", " .(!empty($facfourn_src->total_ttc) ? (float) $facfourn_src->total_ttc :
'0');
421 $sql .=
", " .((int) $user->id);
422 $sql .=
", " .(!empty($this->fk_project) ? ((int) $this->fk_project) :
'NULL');
423 $sql .=
", " .(!empty($facfourn_src->fk_account) ? ((int) $facfourn_src->fk_account) :
'NULL');
424 $sql .=
", " .($this->cond_reglement_id > 0 ? (int) $this->cond_reglement_id :
'NULL');
425 $sql .=
", " .($this->mode_reglement_id > 0 ? (int) $this->mode_reglement_id :
'NULL');
426 $sql .=
", ".($facfourn_src->date_echeance > 0 ?
"'".$this->db->idate($facfourn_src->date_echeance).
"'" :
'NULL');
427 $sql .=
", " .(!empty($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
'NULL');
428 $sql .=
", " .(!empty($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
'NULL');
429 $sql .=
", " .(!empty($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
'NULL');
430 $sql .=
", " . (int) $facfourn_src->fk_multicurrency;
431 $sql .=
", '".$this->db->escape($facfourn_src->multicurrency_code).
"'";
432 $sql .=
", " . (float) $facfourn_src->multicurrency_tx;
433 $sql .=
", " . (int) $this->usenewprice;
434 $sql .=
", " . (int) $this->frequency;
435 $sql .=
", '".$this->db->escape($this->unit_frequency).
"'";
436 $sql .=
", " .(!empty($this->date_when) ?
"'".$this->db->idate($this->date_when).
"'" :
'NULL');
437 $sql .=
", " .(!empty($this->date_last_gen) ?
"'".$this->db->idate($this->date_last_gen).
"'" :
'NULL');
438 $sql .=
", " . (int) $this->nb_gen_done;
439 $sql .=
", " . (int) $this->nb_gen_max;
440 $sql .=
", " . (int) $this->auto_validate;
441 $sql .=
", " . (int) $this->generate_pdf;
444 if ($this->db->query($sql)) {
445 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
'facture_fourn_rec');
448 $this->fk_multicurrency = $facfourn_src->fk_multicurrency;
450 $this->multicurrency_code = $facfourn_src->multicurrency_code;
451 $this->multicurrency_tx = $facfourn_src->multicurrency_tx;
454 $num = count($facfourn_src->lines);
455 for ($i = 0; $i < $num; $i++) {
456 $facfourn_line = $facfourn_src->lines[$i];
457 '@phan-var-force SupplierInvoiceLine $facfourn_line';
458 if (!empty($onlylines) && !in_array($facfourn_line->id, $onlylines)) {
462 $tva_tx = $facfourn_line->tva_tx;
463 if (!empty($facfourn_line->vat_src_code) && !preg_match(
'/\(/', (
string) $tva_tx)) {
464 $tva_tx .=
' ('.$facfourn_line->vat_src_code.
')';
467 $result_insert = $this->
addline(
468 $facfourn_line->fk_product,
469 $facfourn_line->ref_supplier,
470 $facfourn_line->product_label,
471 $facfourn_line->desc ? $facfourn_line->desc : $facfourn_line->description,
472 $facfourn_line->pu_ht,
473 $facfourn_line->pu_ttc,
475 $facfourn_line->remise_percent,
477 $facfourn_line->localtax1_tx,
478 $facfourn_line->localtax2_tx,
480 $facfourn_line->product_type,
481 $facfourn_line->date_start,
482 $facfourn_line->date_end,
483 $facfourn_line->info_bits,
484 $facfourn_line->special_code,
485 $facfourn_line->rang,
486 $facfourn_line->fk_unit
489 if ($result_insert < 0) {
494 $result2 = $objectline->fetch($result_insert);
497 if (method_exists($facfourn_line,
'fetch_optionals')) {
498 $facfourn_line->fetch_optionals($facfourn_line->id);
499 $objectline->array_options = $facfourn_line->array_options;
502 $result = $objectline->insertExtraFields();
506 } elseif ($result2 < 0) {
507 $this->errors[] = $objectline->error;
513 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
514 $this->linked_objects = $this->linkedObjectsIds;
518 if (!$error && $this->
id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
519 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
520 if (is_array($tmp_origin_id)) {
521 foreach ($tmp_origin_id as $origin_id) {
524 $this->error = $this->db->lasterror();
529 $origin_id = $tmp_origin_id;
532 $this->error = $this->db->lasterror();
546 if (!$error && !$notrigger) {
548 $result = $this->call_trigger(
'SUPPLIERBILLREC_CREATE', $user);
550 $this->db->rollback();
557 $this->db->rollback();
564 $this->error = $this->db->lasterror();
565 $this->db->rollback();
569 $this->db->rollback();
586 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"facture_fourn_rec SET";
587 $sql .=
" titre = '" . (!empty($this->title) ? $this->db->escape($this->title) :
"").
"'," ;
588 $sql .=
" subtype=".(isset($this->subtype) ? (int) $this->subtype :
"NULL").
",";
589 $sql .=
" ref_supplier = '". (!empty($this->ref_supplier) ? $this->db->escape($this->ref_supplier) :
"").
"',";
590 $sql .=
" entity = ". (!empty($this->entity) ? ((int) $this->entity) : 1) .
',';
591 if (!empty($this->socid) && $this->socid > 0) {
592 $sql .=
" fk_soc = ". ((int) $this->socid).
',';
593 } elseif (!empty($this->fk_soc) && $this->fk_soc > 0) {
594 $sql .=
" fk_soc = ". ((int) $this->fk_soc).
',';
596 $sql .=
" suspended = ". (!empty($this->suspended) ? ((int) $this->suspended) : 0) .
',';
597 $sql .=
" libelle = ". (!empty($this->libelle) ?
"'".$this->db->escape($this->libelle).
"'" :
'NULL') .
",";
598 $sql .=
" vat_src_code = ". (!empty($this->vat_src_code) ?
"'".$this->db->escape($this->vat_src_code).
"'" :
'NULL') .
',';
599 $sql .=
" localtax1 = ". (!empty($this->localtax1) ? ((float) $this->localtax1) : 0.00) .
',';
600 $sql .=
" localtax2 = ". (!empty($this->localtax2) ? ((float) $this->localtax2) : 0.00) .
',';
601 $sql .=
" total_ht = ". (!empty($this->total_ht) ? ((float) $this->total_ht) : 0.00) .
',';
602 $sql .=
" total_tva = ". (!empty($this->total_tva) ? ((float) $this->total_tva) : 0.00) .
',';
603 $sql .=
" total_ttc = ". (!empty($this->total_ttc) ? ((float) $this->total_ttc) : 0.00) .
',';
604 $sql .=
" fk_user_modif = ". ((int) $user->id) .
',';
605 $sql .=
" fk_projet = ". (!empty($this->fk_project) ? ((int) $this->fk_project) :
'NULL') .
',';
606 $sql .=
" fk_account = ". (!empty($this->fk_account) ? ((int) $this->fk_account) :
'NULL') .
',';
607 $sql .=
" fk_mode_reglement = ". (!empty($this->mode_reglement_id) ? ((int) $this->mode_reglement_id) :
'NULL') .
',';
608 $sql .=
" fk_cond_reglement = ". (!empty($this->cond_reglement_id) ? ((int) $this->cond_reglement_id) :
'NULL') .
',';
609 $sql .=
" date_lim_reglement = ". (!empty($this->date_lim_reglement) ?
"'".$this->db->idate($this->date_lim_reglement).
"'" :
'NULL') .
',';
610 $sql .=
" note_private = '". (!empty($this->note_private) ? $this->db->escape($this->note_private) :
'') .
"',";
611 $sql .=
" note_public = '". (!empty($this->note_public) ? $this->db->escape($this->note_public) :
'') .
"',";
612 $sql .=
" modelpdf = ". (!empty($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
'NULL') .
",";
613 $sql .=
" fk_multicurrency = ". (!empty($this->fk_multicurrency) ? ((int) $this->fk_multicurrency) :
'NULL') .
',';
614 $sql .=
" multicurrency_code = ". (!empty($this->multicurrency_code) ?
"'".$this->db->escape($this->multicurrency_code).
"'" :
'NULL') .
",";
615 $sql .=
" multicurrency_tx = ". (!empty($this->multicurrency_tx) ? ((float) $this->multicurrency_tx) : 1) .
',';
616 $sql .=
" multicurrency_total_ht = ". (!empty($this->multicurrency_total_ht) ? ((float) $this->multicurrency_total_ht) : 0.00) .
',';
617 $sql .=
" multicurrency_total_tva = ". (!empty($this->multicurrency_total_tva) ? ((float) $this->multicurrency_total_tva) : 0.00) .
',';
618 $sql .=
" multicurrency_total_ttc = ". (!empty($this->multicurrency_total_ttc) ? ((float) $this->multicurrency_total_ttc) : 0.00) .
',';
619 $sql .=
" usenewprice = ". (!empty($this->usenewprice) ? ((int) $this->usenewprice) : 0) .
',';
620 $sql .=
" frequency = ". (!empty($this->frequency) ? ((int) $this->frequency) : 0).
',';
621 $sql .=
" unit_frequency = '". (!empty($this->unit_frequency) ? $this->db->escape($this->unit_frequency) :
'').
"',";
622 $sql .=
" date_when = ". (!empty($this->date_when) ?
"'".$this->db->idate($this->date_when).
"'" :
'NULL') .
',';
623 $sql .=
" date_last_gen = ". (!empty($this->date_last_gen) ?
"'".$this->db->idate($this->date_last_gen).
"'" :
'NULL') .
',';
624 $sql .=
" nb_gen_done = ". (!empty($this->nb_gen_done) ? ((int) $this->nb_gen_done) : 0) .
',';
625 $sql .=
" nb_gen_max = ". (!empty($this->nb_gen_max) ? ((int) $this->nb_gen_max) : 0) .
',';
626 $sql .=
" auto_validate = ". (!empty($this->auto_validate) ? ((int) $this->auto_validate) : 0);
627 $sql .=
" WHERE rowid = ". (int) $this->
id;
631 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
632 $resql = $this->db->query($sql);
641 if (!$error && !$notrigger) {
643 $result = $this->call_trigger(
'SUPPLIERBILLREC_MODIFY', $user);
645 $this->db->rollback();
653 $this->error = $this->db->lasterror();
654 $this->db->rollback();
667 public function fetch($rowid, $ref =
'', $ref_ext =
'')
669 $sql =
'SELECT f.rowid, f.titre as title, f.subtype, f.ref_supplier, f.entity, f.fk_soc';
670 $sql .=
', f.datec, f.tms, f.suspended';
671 $sql .=
', f.libelle as label';
672 $sql .=
', f.vat_src_code, f.localtax1, f.localtax2';
673 $sql .=
', f.total_tva, f.total_ht, f.total_ttc';
674 $sql .=
', f.fk_user_author, f.fk_user_modif';
675 $sql .=
', f.fk_projet as fk_project, f.fk_account';
676 $sql .=
', f.fk_mode_reglement, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle';
677 $sql .=
', f.fk_cond_reglement, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc';
678 $sql .=
', f.date_lim_reglement';
679 $sql .=
', f.note_private, f.note_public, f.modelpdf as model_pdf';
680 $sql .=
', f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc';
681 $sql .=
', f.usenewprice, f.frequency, f.unit_frequency, f.date_when, f.date_last_gen, f.nb_gen_done, f.nb_gen_max, f.auto_validate';
682 $sql .=
', f.generate_pdf';
683 $sql .=
' FROM '.MAIN_DB_PREFIX.
'facture_fourn_rec as f';
684 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_payment_term as c ON f.fk_cond_reglement = c.rowid';
685 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_paiement as p ON f.fk_mode_reglement = p.id';
686 $sql .=
' WHERE f.entity IN ('.getEntity(
'invoice').
')';
688 $sql .=
' AND f.rowid='. (int) $rowid;
690 $sql .=
" AND f.titre='".$this->db->escape($ref).
"'";
692 $sql .=
' AND f.rowid = 0';
695 $result = $this->db->query($sql);
697 if ($this->db->num_rows($result)) {
698 $obj = $this->db->fetch_object($result);
702 $this->
id = $obj->rowid;
703 $this->titre = $obj->title;
704 $this->title = $obj->title;
705 $this->subtype = $obj->subtype;
706 $this->
ref = $obj->title;
707 $this->ref_supplier = $obj->ref_supplier;
708 $this->entity = $obj->entity;
709 $this->socid = $obj->fk_soc;
710 $this->date_creation = $obj->datec;
711 $this->date_modification = $obj->tms;
713 $this->
status = $obj->suspended;
714 $this->suspended = $obj->suspended;
716 $this->label = $obj->label;
717 $this->vat_src_code = $obj->vat_src_code;
718 $this->total_localtax1 = $obj->localtax1;
719 $this->total_localtax2 = $obj->localtax2;
720 $this->total_ht = $obj->total_ht;
721 $this->total_tva = $obj->total_tva;
722 $this->total_ttc = $obj->total_ttc;
723 $this->user_creation_id = $obj->fk_user_author;
724 $this->user_modif = $obj->fk_user_modif;
725 $this->fk_project = $obj->fk_project;
726 $this->fk_account = $obj->fk_account;
727 $this->mode_reglement_id = $obj->fk_mode_reglement;
728 $this->mode_reglement_code = $obj->mode_reglement_code;
729 $this->mode_reglement = $obj->mode_reglement_libelle;
730 $this->cond_reglement_id = $obj->fk_cond_reglement;
731 $this->cond_reglement_code = $obj->cond_reglement_code;
732 $this->cond_reglement = $obj->cond_reglement_libelle;
733 $this->cond_reglement_doc = $obj->cond_reglement_libelle_doc;
734 $this->date_lim_reglement = $this->db->jdate($obj->date_lim_reglement);
735 $this->note_private = $obj->note_private;
736 $this->note_public = $obj->note_public;
737 $this->model_pdf = $obj->model_pdf;
740 $this->fk_multicurrency = $obj->fk_multicurrency;
741 $this->multicurrency_code = $obj->multicurrency_code;
742 $this->multicurrency_tx = $obj->multicurrency_tx;
743 $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
744 $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
745 $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
747 $this->usenewprice = $obj->usenewprice;
748 $this->frequency = $obj->frequency;
749 $this->unit_frequency = $obj->unit_frequency;
750 $this->date_when = $this->db->jdate($obj->date_when);
751 $this->date_last_gen = $this->db->jdate($obj->date_last_gen);
752 $this->nb_gen_done = $obj->nb_gen_done;
753 $this->nb_gen_max = $obj->nb_gen_max;
754 $this->auto_validate = $obj->auto_validate;
755 $this->generate_pdf = $obj->generate_pdf;
766 $this->error = $this->db->lasterror();
771 $this->error =
'Bill with id '.$rowid.
' or ref '.$ref.
' not found';
772 dol_syslog(
'Facture::Fetch Error '.$this->error, LOG_ERR);
776 $this->error = $this->db->error();
801 $this->lines = array();
812 $sql =
'SELECT l.rowid,';
813 $sql .=
' l.fk_facture_fourn, l.fk_parent_line, l.fk_product, l.ref as ref_supplier, l.label, l.description as line_desc,';
814 $sql .=
' l.pu_ht, l.pu_ttc, l.qty, l.remise_percent, l.fk_remise_except, l.vat_src_code, l.tva_tx,';
815 $sql .=
' l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type,';
816 $sql .=
' l.total_ht, l.total_tva, l.total_ttc, total_localtax1, total_localtax2,';
817 $sql .=
' l.product_type, l.date_start, l.date_end,';
818 $sql .=
' l.info_bits, l.special_code, l.rang,';
819 $sql .=
' l.fk_unit, l.import_key, l.fk_user_author, l.fk_user_modif, l.extraparams,';
820 $sql .=
' l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc,';
821 $sql .=
' p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc';
822 $sql .=
' FROM '.MAIN_DB_PREFIX.
'facture_fourn_det_rec as l';
823 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON l.fk_product = p.rowid';
824 $sql .=
' WHERE l.fk_facture_fourn = '. (int) $this->
id;
825 $sql .=
' ORDER BY l.rang';
827 dol_syslog(
'FactureFournisseurRec::fetch_lines', LOG_DEBUG);
829 $result = $this->db->query($sql);
831 $num = $this->db->num_rows($result);
834 $objp = $this->db->fetch_object($result);
838 $line->id = $objp->rowid;
839 $line->fk_facture_fourn = $objp->fk_facture_fourn;
840 $line->fk_parent = $objp->fk_parent_line;
841 $line->fk_product = $objp->fk_product;
842 $line->ref = $objp->product_ref;
843 $line->product_ref = $objp->product_ref;
844 $line->product_label = $objp->product_label;
845 $line->product_desc = $objp->product_desc;
846 $line->ref_supplier = $objp->ref_supplier;
847 $line->label = $objp->label;
848 $line->description = $objp->line_desc;
849 $line->desc = $objp->line_desc;
850 $line->pu_ht = $objp->pu_ht;
851 $line->subprice = $objp->pu_ht;
852 $line->pu_ttc = $objp->pu_ttc;
853 $line->subprice_ttc = $objp->pu_ttc;
854 $line->qty = $objp->qty;
855 $line->remise_percent = $objp->remise_percent;
856 $line->fk_remise_except = $objp->fk_remise_except;
857 $line->vat_src_code = $objp->vat_src_code;
858 $line->tva_tx = $objp->tva_tx;
859 $line->localtax1_tx = $objp->localtax1_tx;
860 $line->localtax1_type = $objp->localtax1_type;
861 $line->localtax2_tx = $objp->localtax2_tx;
862 $line->localtax2_type = $objp->localtax2_type;
863 $line->total_ht = $objp->total_ht;
864 $line->total_tva = $objp->total_tva;
865 $line->total_localtax1 = $objp->total_localtax1;
866 $line->total_localtax2 = $objp->total_localtax2;
867 $line->total_ttc = $objp->total_ttc;
868 $line->product_type = $objp->product_type;
869 $line->date_start = $objp->date_start;
870 $line->date_end = $objp->date_end;
871 $line->info_bits = $objp->info_bits ;
872 $line->special_code = $objp->special_code;
873 $line->rang = $objp->rang;
874 $line->fk_unit = $objp->fk_unit;
875 $line->import_key = $objp->import_key;
876 $line->fk_user_author = $objp->fk_user_author;
877 $line->fk_user_modif = $objp->fk_user_modif;
878 $this->extraparams = !empty($objp->extraparams) ? (array) json_decode($objp->extraparams,
true) : array();
879 $line->fk_multicurrency = $objp->fk_multicurrency;
880 $line->multicurrency_code = $objp->multicurrency_code;
881 $line->multicurrency_subprice = $objp->multicurrency_subprice;
882 $line->multicurrency_total_ht = $objp->multicurrency_total_ht;
883 $line->multicurrency_total_tva = $objp->multicurrency_total_tva;
884 $line->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
886 $line->fetch_optionals();
888 $this->lines[$i] = $line;
893 $this->db->free($result);
896 $this->error = $this->db->lasterror();
910 public function delete(
User $user, $notrigger = 0, $idwarehouse = -1)
914 dol_syslog(get_class($this).
"::delete rowid=".((
int) $rowid), LOG_DEBUG);
919 $sql_main_table = MAIN_DB_PREFIX.
'facture_fourn_det_rec';
920 $sql_ef_table = $sql_main_table.
"_extrafields";
922 $sqlef =
"DELETE FROM ".$sql_ef_table.
" WHERE fk_object IN (SELECT rowid FROM ".$sql_main_table.
" WHERE fk_facture_fourn = ". (int) $rowid .
")";
923 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"facture_fourn_det_rec WHERE fk_facture_fourn = ". (int) $rowid;
925 if ($this->db->query($sqlef) && $this->db->query($sql)) {
926 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"facture_fourn_rec WHERE rowid = ". (int) $rowid;
928 if ($this->db->query($sql)) {
940 $this->error = $this->db->lasterror();
944 $this->error = $this->db->lasterror();
947 if (!$error && !$notrigger) {
949 $result = $this->call_trigger(
'SUPPLIERBILLREC_DELETE', $user);
959 $this->db->rollback();
990 public function addline($fk_product, $ref, $label, $desc, $pu_ht, $pu_ttc, $qty, $remise_percent, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 0, $price_base_type =
'HT', $type = 0,
$date_start = 0, $date_end = 0, $info_bits = 0, $special_code = 0, $rang = -1, $fk_unit =
null, $pu_ht_devise = 0)
994 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
998 dol_syslog(get_class($this).
"::addline facid=$facid,desc=$desc,pu_ht=$pu_ht,qty=$qty,txtva=$txtva,txlocaltax1=$txlocaltax1,txlocaltax2=$txlocaltax2,fk_product=$fk_product,remise_percent=$remise_percent,info_bits=$info_bits,price_base_type=$price_base_type,pu_ttc=$pu_ttc,type=$type,fk_unit=$fk_unit,pu_ht_devise=$pu_ht_devise,date_start_fill=$date_start,date_end_fill=$date_end", LOG_DEBUG);
1010 if (preg_match(
'/\((.*)\)/', (
string) $txtva, $reg)) {
1011 $vat_src_code = $reg[1];
1012 $txtva = preg_replace(
'/\s*\(.*\)/',
'', (
string) $txtva);
1016 $fk_product = empty($fk_product) ? 0 : $fk_product;
1017 $label = empty($label) ?
'' : $label;
1018 $remise_percent = empty($remise_percent) ? 0 :
price2num($remise_percent);
1022 if (!preg_match(
'/\((.*)\)/', $txtva)) {
1027 $txtva = !empty($txtva) ? $txtva : 0;
1028 $txlocaltax1 = !empty($txlocaltax1) ? $txlocaltax1 : 0;
1029 $txlocaltax2 = !empty($txlocaltax2) ? $txlocaltax2 : 0;
1030 $info_bits = !empty($info_bits) ? $info_bits : 0;
1031 $info_bits = !empty($info_bits) ? $info_bits : 0;
1033 $pu = ($price_base_type ==
'HT' ? $pu_ht : $pu_ttc);
1039 $tabprice =
calcul_price_total((
float) $qty, (
float) $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $type,
$mysoc, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);
1040 $total_ht = $tabprice[0];
1041 $total_tva = $tabprice[1];
1042 $total_ttc = $tabprice[2];
1043 $total_localtax1 = $tabprice[9];
1044 $total_localtax2 = $tabprice[10];
1045 $pu_ht = $tabprice[3];
1048 $multicurrency_total_ht = $tabprice[16];
1049 $multicurrency_total_tva = $tabprice[17];
1050 $multicurrency_total_ttc = $tabprice[18];
1051 $pu_ht_devise = $tabprice[19];
1054 $product_type = $type;
1056 $product =
new Product($this->db);
1057 $result = $product->fetch($fk_product);
1061 $product_type = $product->type;
1062 if (empty($label)) {
1063 $label = $product->label;
1067 $sql =
'INSERT INTO ' . MAIN_DB_PREFIX .
'facture_fourn_det_rec (';
1068 $sql .=
'fk_facture_fourn';
1069 $sql .=
', fk_product';
1072 $sql .=
', description';
1076 $sql .=
', remise_percent';
1077 $sql .=
', fk_remise_except';
1078 $sql .=
', vat_src_code';
1080 $sql .=
', localtax1_tx';
1081 $sql .=
', localtax1_type';
1082 $sql .=
', localtax2_tx';
1083 $sql .=
', localtax2_type';
1084 $sql .=
', total_ht';
1085 $sql .=
', total_tva';
1086 $sql .=
', total_localtax1';
1087 $sql .=
', total_localtax2';
1088 $sql .=
', total_ttc';
1089 $sql .=
', product_type';
1090 $sql .=
', date_start';
1091 $sql .=
', date_end';
1092 $sql .=
', info_bits';
1093 $sql .=
', special_code';
1095 $sql .=
', fk_unit';
1096 $sql .=
', fk_user_author';
1097 $sql .=
', fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc';
1098 $sql .=
') VALUES (';
1099 $sql .=
' ' . (int) $facid;
1100 $sql .=
', ' . (!empty($fk_product) ? ((int) $fk_product) :
'null');
1101 $sql .=
', ' . (!empty($ref) ?
"'" . $this->db->escape($ref) .
"'" :
'null');
1102 $sql .=
', ' . (!empty($label) ?
"'" . $this->db->escape($label) .
"'" :
'null');
1103 $sql .=
", '" . $this->db->escape($desc) .
"'";
1107 $sql .=
', ' .
price2num($remise_percent);
1109 $sql .=
", '" . $this->db->escape($vat_src_code) .
"'";
1112 $sql .=
", '" . $this->db->escape(isset($localtaxes_type[0]) ? $localtaxes_type[0] :
'') .
"'";
1114 $sql .=
", '" . $this->db->escape(isset($localtaxes_type[2]) ? $localtaxes_type[2] :
'') .
"'";
1117 $sql .=
', ' .
price2num($total_localtax1);
1118 $sql .=
', ' .
price2num($total_localtax2);
1120 $sql .=
', ' . (int) $product_type;
1122 $sql .=
', ' . ($date_end > 0 ? (int) $date_end :
'NULL');
1123 $sql .=
', ' . (int) $info_bits;
1124 $sql .=
', ' . (int) $special_code;
1125 $sql .=
', ' . (int) $rang;
1126 $sql .=
', ' . ($fk_unit ? (int) $fk_unit :
'NULL');
1127 $sql .=
', ' . (int) $user->id;
1128 $sql .=
', ' . (int) $this->fk_multicurrency;
1129 $sql .=
", '" . $this->db->escape($this->multicurrency_code) .
"'";
1130 $sql .=
', ' .
price2num($pu_ht_devise,
'CU');
1131 $sql .=
', ' .
price2num($multicurrency_total_ht,
'CT');
1132 $sql .=
', ' .
price2num($multicurrency_total_tva,
'CT');
1133 $sql .=
', ' .
price2num($multicurrency_total_ttc,
'CT');
1136 dol_syslog(get_class($this).
'::addline', LOG_DEBUG);
1137 if ($this->db->query($sql)) {
1138 $lineId = $this->db->last_insert_id(MAIN_DB_PREFIX.
'facture_fourn_det_rec');
1141 $this->db->commit();
1144 $this->db->rollback();
1145 $this->error = $this->db->lasterror();
1178 public function updateline($rowid, $fk_product, $ref, $label, $desc, $pu_ht, $qty, $remise_percent, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 0, $price_base_type =
'HT', $type = 0,
$date_start = 0, $date_end = 0, $info_bits = 0, $special_code = 0, $rang = -1, $fk_unit =
null, $pu_ht_devise = 0, $pu_ttc = 0)
1183 $this->error =
'ErrorLineIDDoesNotMatchWithObjectID';
1189 dol_syslog(get_class($this).
'::updateline facid=' .$facid.
" rowid=$rowid, desc=$desc, pu_ht=$pu_ht, qty=$qty, txtva=$txtva, txlocaltax1=$txlocaltax1, txlocaltax2=$txlocaltax2, fk_product=$fk_product, remise_percent=$remise_percent, info_bits=$info_bits, price_base_type=$price_base_type, pu_ttc=$pu_ttc, type=$type, fk_unit=$fk_unit, pu_ht_devise=$pu_ht_devise", LOG_DEBUG);
1190 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
1198 $fk_product = empty($fk_product) ? 0 : $fk_product;
1199 $label = empty($label) ?
'' : $label;
1200 $remise_percent = empty($remise_percent) ? 0 :
price2num($remise_percent);
1202 $info_bits = empty($info_bits) ? 0 : $info_bits;
1205 $pu_ht_devise =
price2num($pu_ht_devise);
1207 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
1211 $txlocaltax1 = empty($txlocaltax1) ? 0 :
price2num($txlocaltax1);
1212 $txlocaltax2 = empty($txlocaltax2) ? 0 :
price2num($txlocaltax2);
1213 $this->multicurrency_total_ht = empty($this->multicurrency_total_ht) ? 0 : $this->multicurrency_total_ht;
1214 $this->multicurrency_total_tva = empty($this->multicurrency_total_tva) ? 0 : $this->multicurrency_total_tva;
1215 $this->multicurrency_total_ttc = empty($this->multicurrency_total_ttc) ? 0 : $this->multicurrency_total_ttc;
1217 $pu = ($price_base_type ==
'HT' ? $pu_ht : $pu_ttc);
1229 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
1230 $vat_src_code = $reg[1];
1231 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
1234 $tabprice =
calcul_price_total((
float) $qty, (
float) $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $type,
$mysoc, $localtaxes_type, 100, $this->multicurrency_tx, (
float) $pu_ht_devise);
1236 $total_ht = $tabprice[0];
1237 $total_tva = $tabprice[1];
1238 $total_ttc = $tabprice[2];
1239 $total_localtax1 = $tabprice[9];
1240 $total_localtax2 = $tabprice[10];
1241 $pu_ht = $tabprice[3];
1242 $pu_tva = $tabprice[4];
1243 $pu_ttc = $tabprice[5];
1246 $multicurrency_total_ht = $tabprice[16];
1247 $multicurrency_total_tva = $tabprice[17];
1248 $multicurrency_total_ttc = $tabprice[18];
1249 $pu_ht_devise = $tabprice[19];
1251 $product_type = $type;
1253 $product =
new Product($this->db);
1254 $result = $product->fetch($fk_product);
1255 $product_type = $product->type;
1258 $sql =
'UPDATE ' . MAIN_DB_PREFIX .
'facture_fourn_det_rec SET';
1259 $sql .=
' fk_facture_fourn = ' . ((int) $facid);
1260 $sql .=
', fk_product = ' . ($fk_product > 0 ? ((int) $fk_product) :
'null');
1261 $sql .=
", ref = '" . $this->db->escape($ref) .
"'";
1262 $sql .=
", label = '" . $this->db->escape($label) .
"'";
1263 $sql .=
", description = '" . $this->db->escape($desc) .
"'";
1264 $sql .=
', pu_ht = ' .
price2num($pu_ht);
1266 $sql .=
", remise_percent = '" .
price2num($remise_percent) .
"'";
1267 $sql .=
", vat_src_code = '" . $this->db->escape($vat_src_code) .
"'";
1268 $sql .=
', tva_tx = ' .
price2num($txtva);
1269 $sql .=
', localtax1_tx = ' . (float) $txlocaltax1;
1270 $sql .=
", localtax1_type = '" . $this->db->escape($localtaxes_type[0]) .
"'";
1271 $sql .=
', localtax2_tx = ' . (float) $txlocaltax2;
1272 $sql .=
", localtax2_type = '" . $this->db->escape($localtaxes_type[2]) .
"'";
1273 $sql .=
", total_ht = '" .
price2num($total_ht) .
"'";
1274 $sql .=
", total_tva = '" .
price2num($total_tva) .
"'";
1275 $sql .=
", total_localtax1 = '" .
price2num($total_localtax1) .
"'";
1276 $sql .=
", total_localtax2 = '" .
price2num($total_localtax2) .
"'";
1277 $sql .=
", total_ttc = '" .
price2num($total_ttc) .
"'";
1278 $sql .=
', product_type = ' . (int) $product_type;
1280 $sql .=
', date_end = ' . (empty($date_end) ?
'NULL' : (int) $date_end);
1281 $sql .=
', info_bits = ' . (int) $info_bits;
1282 $sql .=
', special_code = ' . (int) $special_code;
1283 $sql .=
', rang = ' . (int) $rang;
1284 $sql .=
', fk_unit = ' . ($fk_unit ?
"'" . $this->db->escape($fk_unit) .
"'" :
'null');
1285 $sql .=
', fk_user_modif = ' . (int) $user->id;
1286 $sql .=
', multicurrency_subprice = '.price2num($pu_ht_devise);
1287 $sql .=
', multicurrency_total_ht = '.price2num($multicurrency_total_ht);
1288 $sql .=
', multicurrency_total_tva = '.price2num($multicurrency_total_tva);
1289 $sql .=
', multicurrency_total_ttc = '.price2num($multicurrency_total_ttc);
1290 $sql .=
' WHERE rowid = ' . (int) $rowid;
1292 dol_syslog(get_class($this).
'::updateline', LOG_DEBUG);
1293 if ($this->db->query($sql)) {
1298 $this->error = $this->db->lasterror();
1324 if (empty($this->date_when)) {
1328 return dol_time_plus_duree((
int) $this->date_when, $this->frequency, $this->unit_frequency, 1,
'tzserver');
1339 if ($this->nb_gen_max > 0 && ($this->nb_gen_done >= $this->nb_gen_max)) {
1354 return ($this->
isMaxNbGenReached() ?
'<strike>' :
'').$ret.($this->isMaxNbGenReached() ?
'</strike>' :
'');
1369 global
$conf, $langs, $db, $user, $hookmanager;
1375 $langs->loadLangs(array(
'main',
'bills'));
1379 $today =
dol_mktime(23, 59, 59, $tmparray[
'mon'], $tmparray[
'mday'], $tmparray[
'year']);
1381 dol_syslog(
'createRecurringInvoices restrictioninvoiceid=' .$restrictioninvoiceid.
' forcevalidation=' .$forcevalidation);
1383 $sql =
'SELECT rowid FROM '.MAIN_DB_PREFIX.
'facture_fourn_rec';
1384 $sql .=
' WHERE frequency > 0';
1385 $sql .=
" AND (date_when IS NULL OR date_when <= '".$this->db->idate($today).
"')";
1386 $sql .=
' AND (nb_gen_done < nb_gen_max OR nb_gen_max = 0)';
1387 $sql .=
' AND suspended = 0';
1388 $sql .=
' AND entity = '. (int)
$conf->entity;
1389 if ($restrictioninvoiceid > 0) {
1390 $sql .=
' AND rowid = '. (int) $restrictioninvoiceid;
1392 $sql .= $this->db->order(
'entity',
'ASC');
1394 $sql .= $this->db->plimit(
getDolGlobalInt(
'NB_REC_FACT_GEN_BY_CALL'));
1397 $parameters = array(
1398 'restrictioninvoiceid' => $restrictioninvoiceid,
1399 'forcevalidation' => $forcevalidation,
1401 $reshook = $hookmanager->executeHooks(
'beforeCreationOfRecurringInvoices', $parameters, $sql);
1403 $resql = $this->db->query($sql);
1406 $num = $this->db->num_rows($resql);
1409 $this->output .= $langs->trans(
'FoundXQualifiedRecurringInvoiceTemplate', $num).
"\n";
1411 $this->output .= $langs->trans(
'NoQualifiedRecurringInvoiceTemplateFound');
1414 $saventity =
$conf->entity;
1418 $line = $this->db->fetch_object($resql);
1422 $errorforinvoice = 0;
1423 $invoiceidgenerated = 0;
1425 $new_fac_fourn =
null;
1427 $laststep =
"Fetch {$line->rowid}";
1428 $facturerec->fetch($line->rowid);
1430 if ($facturerec->id > 0) {
1432 $conf->entity = $facturerec->entity;
1434 dol_syslog(
'createRecurringInvoices Process invoice template id=' .$facturerec->id.
', ref=' .$facturerec->ref.
', entity=' .$facturerec->entity);
1437 $new_fac_fourn->fac_rec = $facturerec->id;
1438 $new_fac_fourn->fk_fac_rec_source = $facturerec->id;
1441 $new_fac_fourn->subtype = $facturerec->subtype;
1444 $new_fac_fourn->date = empty($facturerec->date_when) ? $now : $facturerec->date_when;
1445 $new_fac_fourn->socid = $facturerec->socid;
1446 $new_fac_fourn->lines = $facturerec->lines;
1447 $new_fac_fourn->ref_supplier = $facturerec->ref_supplier;
1448 $new_fac_fourn->model_pdf = $facturerec->model_pdf;
1449 $new_fac_fourn->fk_project = $facturerec->fk_project;
1450 $new_fac_fourn->label = $facturerec->label;
1451 $new_fac_fourn->libelle = $facturerec->label;
1453 $invoiceidgenerated = $new_fac_fourn->create($user);
1454 $laststep =
"Create invoiceidgenerated $invoiceidgenerated";
1455 if ($invoiceidgenerated <= 0) {
1460 if (!$errorforinvoice && ($facturerec->auto_validate || $forcevalidation)) {
1461 $result = $new_fac_fourn->validate($user);
1462 $laststep =
"Validate by user {$user->login}";
1470 if (!$errorforinvoice && $facturerec->generate_pdf) {
1472 $laststep =
"Refresh ".$new_fac_fourn->id;
1473 $new_fac_fourn->fetch($new_fac_fourn->id);
1474 $laststep =
"GenerateDocument ".$new_fac_fourn->id;
1475 $result = $new_fac_fourn->generateDocument($facturerec->model_pdf, $langs);
1484 $this->error =
'Failed to load invoice template with id=' .$line->rowid.
', entity=' .$conf->entity.
"\n";
1485 $this->errors[] =
'Failed to load invoice template with id=' .$line->rowid.
', entity=' .$conf->entity;
1486 dol_syslog(
'createRecurringInvoices Failed to load invoice template with id=' .$line->rowid.
', entity=' .$conf->entity);
1491 if (!$errorforinvoice && $invoiceidgenerated > 0) {
1492 $facturerec->nb_gen_done++;
1493 $facturerec->date_last_gen =
dol_now();
1494 $nextDate = $facturerec->getNextDate();
1495 $facturerec->date_when = (($nextDate ===
false) ?
null : $nextDate);
1496 $facturerec->update($user);
1497 $this->db->commit(
'createRecurringInvoices Process invoice template id=' .$facturerec->id.
', title=' .$facturerec->title);
1498 dol_syslog(
'createRecurringInvoices Process invoice template ' .$facturerec->title.
' is finished with a success generation');
1500 $this->output .= $langs->trans(
'InvoiceGeneratedFromTemplate', $new_fac_fourn->ref, $facturerec->title).
"\n";
1502 $this->db->rollback(
'createRecurringInvoices Process invoice template error='.$error.
' invoiceidgenerated='.$invoiceidgenerated.
' LastStep='.$laststep.
' id=' .$facturerec->id.
', title=' .$facturerec->title);
1505 $parameters = array(
1508 'errorCount' => $error,
1509 'invoiceidgenerated' => $invoiceidgenerated,
1510 'facturerec' => $facturerec,
1514 $reshook = $hookmanager->executeHooks(
'afterCreationOfRecurringInvoice', $parameters, $new_fac_fourn);
1519 $conf->entity = $saventity;
1521 dol_print_error($this->db);
1524 $this->output = trim($this->output);
1526 return $error ? $error : 0;
1541 public function getNomUrl($withpicto = 0, $option =
'', $max = 0, $short = 0, $moretitle =
'', $notooltip = 0, $save_lastsearch_value = -1)
1543 global $langs, $hookmanager;
1547 $label =
'<u>'.$langs->trans(
'RepeatableInvoice').
'</u>';
1548 if (!empty($this->
ref)) {
1549 $label .=
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
1551 if ($this->frequency > 0) {
1552 $label .=
'<br><b>'.$langs->trans(
'Frequency').
':</b> '.$langs->trans(
'FrequencyPer_'.$this->unit_frequency, $this->frequency);
1554 if (!empty($this->date_last_gen)) {
1555 $label .=
'<br><b>'.$langs->trans(
'DateLastGeneration').
':</b> '.
dol_print_date($this->date_last_gen,
'dayhour');
1557 if ($this->frequency > 0) {
1558 if (!empty($this->date_when)) {
1559 $label .=
'<br><b>'.$langs->trans(
'NextDateToExecution').
':</b> ';
1560 $label .= (empty($this->suspended) ?
'' :
'<strike>').
dol_print_date($this->date_when,
'day').(empty($this->suspended) ?
'' :
'</strike>');
1561 if (!empty($this->suspended)) {
1562 $label .=
' ('.$langs->trans(
'Disabled').
')';
1567 $url = DOL_URL_ROOT.
'/fourn/facture/card-rec.php?facid='.$this->id;
1573 if ($option !=
'nolink') {
1575 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
1576 if ($save_lastsearch_value == -1 && preg_match(
'/list\.php/', $_SERVER[
'PHP_SELF'])) {
1577 $add_save_lastsearch_values = 1;
1579 if ($add_save_lastsearch_values) {
1580 $url .=
'&save_lastsearch_values=1';
1584 $linkstart =
'<a href="'.$url.
'" title="'.
dol_escape_htmltag($label, 1).
'" class="classfortooltip">';
1587 $result .= $linkstart;
1589 $result .= img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), ($notooltip ? (($withpicto != 2) ?
'class="paddingright"' :
'') :
'class="'.(($withpicto != 2) ?
'paddingright ' :
'').
'classfortooltip"'), 0, 0, $notooltip ? 0 : 1);
1591 if ($withpicto != 2) {
1592 $result .= $this->ref;
1594 $result .= $linkend;
1596 $hookmanager->initHooks(array($this->element .
'dao'));
1597 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
1598 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
1600 $result = $hookmanager->resPrint;
1602 $result .= $hookmanager->resPrint;
1616 return $this->
LibStatut($this->frequency ? 1 : 0, $this->suspended, $mode, $alreadypaid, empty($this->
type) ? 0 : $this->type);
1631 public function LibStatut($recur, $status, $mode = 0, $alreadypaid = -1, $type = 0, $nbofopendirectdebitorcredittransfer = 0)
1635 $langs->load(
'bills');
1637 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1638 $statusType =
'status0';
1643 if ($status == self::STATUS_SUSPENDED) {
1644 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1646 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1649 if ($status == self::STATUS_SUSPENDED) {
1650 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1652 $labelStatus = $langs->transnoentitiesnoconv(
'Draft');
1655 } elseif ($mode == 1) {
1658 if ($status == self::STATUS_SUSPENDED) {
1659 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1661 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1664 if ($status == self::STATUS_SUSPENDED) {
1665 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1667 $labelStatus = $langs->transnoentitiesnoconv(
'Draft');
1670 } elseif ($mode == 2) {
1672 if ($status == self::STATUS_SUSPENDED) {
1673 $statusType =
'status6';
1674 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1676 $statusType =
'status4';
1677 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1680 if ($status == self::STATUS_SUSPENDED) {
1681 $statusType =
'status6';
1682 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1684 $statusType =
'status0';
1685 $labelStatus = $langs->transnoentitiesnoconv(
'Draft');
1688 } elseif ($mode == 3) {
1691 if ($status == self::STATUS_SUSPENDED) {
1692 $statusType =
'status6';
1693 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1695 $statusType =
'status4';
1696 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1699 if ($status == self::STATUS_SUSPENDED) {
1700 $statusType =
'status6';
1701 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1703 $statusType =
'status0';
1704 $labelStatus = $langs->transnoentitiesnoconv(
'Draft');
1707 } elseif ($mode == 4) {
1710 if ($status == self::STATUS_SUSPENDED) {
1711 $statusType =
'status6';
1712 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1714 $statusType =
'status4';
1715 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1718 if ($status == self::STATUS_SUSPENDED) {
1719 $statusType =
'status6';
1720 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1722 $statusType =
'status0';
1723 $labelStatus = $langs->transnoentitiesnoconv(
'Draft');
1726 } elseif ($mode == 5 || $mode == 6) {
1732 if ($status == self::STATUS_SUSPENDED) {
1733 $statusType =
'status6';
1734 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1736 $statusType =
'status4';
1737 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1740 if ($status == self::STATUS_SUSPENDED) {
1741 $statusType =
'status6';
1742 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1744 $statusType =
'status0';
1745 $labelStatus = $langs->transnoentitiesnoconv(
'Draft');
1750 $labelStatusShort = $labelStatus;
1752 return dolGetStatus($labelStatus, $labelStatusShort,
'', $statusType, $mode);
1765 global $user, $langs,
$conf;
1769 $nownotime =
dol_mktime(0, 0, 0, $arraynow[
'mon'], $arraynow[
'mday'], $arraynow[
'year']);
1775 $sql =
'SELECT rowid';
1776 $sql .=
' FROM ' .MAIN_DB_PREFIX.
'product';
1777 $sql .=
' WHERE entity IN (' .getEntity(
'product').
')';
1778 $sql .= $this->db->plimit(100);
1780 $resql = $this->db->query($sql);
1782 $num_prods = $this->db->num_rows($resql);
1784 while ($i < $num_prods) {
1786 $row = $this->db->fetch_row($resql);
1787 $prodids[$i] = $row[0];
1793 $this->
ref =
'SPECIMEN';
1794 $this->title =
'SPECIMEN';
1795 $this->specimen = 1;
1797 $this->
date = $nownotime;
1798 $this->date_lim_reglement = $nownotime + 3600 * 24 * 30;
1799 $this->cond_reglement_id = 1;
1800 $this->cond_reglement_code =
'RECEP';
1802 $this->mode_reglement_id = 0;
1803 $this->mode_reglement_code =
'';
1804 $this->note_public =
'This is a comment (public)';
1805 $this->note_private =
'This is a comment (private)';
1806 $this->note =
'This is a comment (private)';
1807 $this->fk_incoterms = 0;
1808 $this->location_incoterms =
'';
1810 if (empty($option) || $option !=
'nolines') {
1814 while ($xnbp < $nbp) {
1816 $line->desc = $langs->trans(
'Description').
' ' .$xnbp;
1818 $line->subprice = 100;
1819 $line->tva_tx = 19.6;
1820 $line->localtax1_tx = 0;
1821 $line->localtax2_tx = 0;
1822 $line->remise_percent = 0;
1824 $prodid = mt_rand(1, $num_prods);
1825 $line->fk_product = $prodids[$prodid];
1827 $line->total_ht = -100;
1828 $line->total_ttc = -119.6;
1829 $line->total_tva = -19.6;
1830 } elseif ($xnbp == 2) {
1831 $line->subprice = -100;
1832 $line->total_ht = -100;
1833 $line->total_ttc = -119.6;
1834 $line->total_tva = -19.6;
1835 $line->remise_percent = 0;
1836 } elseif ($xnbp == 3) {
1837 $prodid = mt_rand(1, $num_prods);
1838 $line->fk_product = $prodids[$prodid];
1839 $line->total_ht = 50;
1840 $line->total_ttc = 59.8;
1841 $line->total_tva = 9.8;
1842 $line->remise_percent = 50;
1844 $prodid = mt_rand(1, $num_prods);
1845 $line->fk_product = $prodids[$prodid];
1846 $line->total_ht = 100;
1847 $line->total_ttc = 119.6;
1848 $line->total_tva = 19.6;
1849 $line->remise_percent = 00;
1852 $this->lines[$xnbp] = $line;
1855 $this->total_ht += $line->total_ht;
1856 $this->total_tva += $line->total_tva;
1857 $this->total_ttc += $line->total_ttc;
1859 $this->revenuestamp = 0;
1863 $line->desc = $langs->trans(
'Description').
' (offered line)';
1865 $line->subprice = 100;
1866 $line->tva_tx = 19.6;
1867 $line->localtax1_tx = 0;
1868 $line->localtax2_tx = 0;
1869 $line->remise_percent = 100;
1870 $line->total_ht = 0;
1871 $line->total_ttc = 0;
1872 $line->total_tva = 0;
1873 $prodid = mt_rand(1, $num_prods);
1874 $line->fk_product = $prodids[$prodid];
1876 $this->lines[$xnbp] = $line;
1880 $this->usenewprice = 0;
1911 if (!$this->table_element) {
1912 dol_syslog(get_class($this).
'::setFrequencyAndUnit was called on object with property table_element not defined', LOG_ERR);
1916 if (!empty($frequency) && empty($unit)) {
1917 dol_syslog(get_class($this).
'::setFrequencyAndUnit was called on object with params frequency defined but unit not defined', LOG_ERR);
1921 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
1922 $sql .=
" SET frequency = ".($frequency ? ((int) $frequency) :
"NULL");
1923 if (!empty($unit)) {
1924 $sql .=
", unit_frequency = '".$this->db->escape($unit).
"'";
1926 $sql .=
" WHERE rowid = ".((int) $this->
id);
1928 dol_syslog(get_class($this).
'::setFrequencyAndUnit', LOG_DEBUG);
1930 if ($this->db->query($sql)) {
1931 $this->frequency = $frequency;
1932 if (!empty($unit)) {
1933 $this->unit_frequency = $unit;
1937 $this->error = $this->db->lasterror();
1951 if (!$this->table_element) {
1952 dol_syslog(get_class($this).
'::setNextDate was called on object with property table_element not defined', LOG_ERR);
1955 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
1956 $sql .=
" SET date_when = " .($date ?
"'".$this->db->idate($date).
"'" :
"NULL");
1957 if ($increment_nb_gen_done > 0) {
1958 $sql .=
", nb_gen_done = nb_gen_done + 1";
1960 $sql .=
" WHERE rowid = " . (int) $this->
id;
1962 dol_syslog(get_class($this).
'::setNextDate', LOG_DEBUG);
1964 if ($this->db->query($sql)) {
1965 $this->date_when = $date;
1966 if ($increment_nb_gen_done > 0) {
1967 $this->nb_gen_done++;
1971 $this->error = $this->db->lasterror();
1984 if (!$this->table_element) {
1985 dol_syslog(get_class($this).
'::setMaxPeriod was called on object with property table_element not defined', LOG_ERR);
1993 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
1994 $sql .=
" SET nb_gen_max = ". (int) $nb;
1995 $sql .=
" WHERE rowid = " . (int) $this->
id;
1997 dol_syslog(get_class($this).
'::setMaxPeriod', LOG_DEBUG);
1999 if ($this->db->query($sql)) {
2000 $this->nb_gen_max = $nb;
2003 dol_print_error($this->db);
2016 if (!$this->table_element) {
2017 dol_syslog(get_class($this).
'::setAutoValidate was called on object with property table_element not defined', LOG_ERR);
2021 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
2022 $sql .=
" SET auto_validate = ".((int) $validate);
2023 $sql .=
" WHERE rowid = " . (int) $this->
id;
2025 dol_syslog(get_class($this).
'::setAutoValidate', LOG_DEBUG);
2027 if ($this->db->query($sql)) {
2028 $this->auto_validate = $validate;
2031 dol_print_error($this->db);
2044 if (!$this->table_element) {
2045 dol_syslog(get_class($this).
'::setGeneratePdf was called on object with property table_element not defined', LOG_ERR);
2049 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
2050 $sql .=
" SET generate_pdf = ". (int) $validate;
2051 $sql .=
" WHERE rowid = " . (int) $this->
id;
2053 dol_syslog(get_class($this).
'::setGeneratePdf', LOG_DEBUG);
2055 if ($this->db->query($sql)) {
2056 $this->generate_pdf = $validate;
2059 dol_print_error($this->db);
2072 if (!$this->table_element) {
2073 dol_syslog(get_class($this).
'::setModelPdf was called on object with property table_element not defined', LOG_ERR);
2077 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
2078 $sql .=
" SET modelpdf = '".$this->db->escape($model).
"'";
2079 $sql .=
" WHERE rowid = " . (int) $this->
id;
2081 dol_syslog(get_class($this).
'::setModelPdf', LOG_DEBUG);
2083 if ($this->db->query($sql)) {
2084 $this->model_pdf = $model;
2087 dol_print_error($this->db);
2101 if ($mode ==
'create') {
2104 if (!in_array($mode, array(
'read',
'write',
'delete'))) {
2108 return (
bool) $user->hasRight(
"fournisseur",
"facture", $mode);
$propal type
'integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter[:Sortfield]]]',...
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
Superclass for invoice classes.
const TYPE_STANDARD
Standard invoice.
calculate_date_lim_reglement($cond_reglement=0)
Returns an invoice payment deadline based on the invoice settlement conditions and billing date.
const STATUS_DRAFT
Draft status.
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...
update_price($exclspec=0, $roundingadjust='auto', $nodatabaseupdate=0, $seller=null)
Update total_ht, total_ttc, total_vat, total_localtax1, total_localtax2 for an object (sum of lines).
add_object_linked($origin=null, $origin_id=null, $f_user=null, $notrigger=0)
Add an object link into llx_element_element.
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
Delete all links between an object $this.
setErrorsFromObject($object)
setErrorsFromObject
isLineOfObject($lineid)
Check that a line belongs to this object, using $this->table_element_line and $this->fk_element.
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.
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
Class to manage Dolibarr database access.
Class to manage suppliers invoices.
Class to manage supplier invoice lines of templates.
Class to manage invoice templates.
setModelPdf($model)
Update the model for documents.
fetch($rowid, $ref='', $ref_ext='')
Load object and lines.
strikeIfMaxNbGenReached($ret)
Format string to output with by striking the string if max number of generation was reached.
setFrequencyAndUnit($frequency, $unit)
Update frequency and unit.
getNextNumRef($soc, $mode='next')
Return next reference of invoice not already used (or last reference)
setGeneratePdf($validate)
Update the auto generate documents.
getLinesArray()
Create an array of invoice lines.
initAsSpecimen($option='')
Initialise an instance with random values.
updateline($rowid, $fk_product, $ref, $label, $desc, $pu_ht, $qty, $remise_percent, $txtva, $txlocaltax1=0, $txlocaltax2=0, $price_base_type='HT', $type=0, $date_start=0, $date_end=0, $info_bits=0, $special_code=0, $rang=-1, $fk_unit=null, $pu_ht_devise=0, $pu_ttc=0)
Update a line to supplier invoice template.
isMaxNbGenReached()
Return if maximum number of generation is reached.
LibStatut($recur, $status, $mode=0, $alreadypaid=-1, $type=0, $nbofopendirectdebitorcredittransfer=0)
Return label of a status.
setAutoValidate($validate)
Update the auto validate flag of invoice.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
getNextDate()
Return the next date of.
__construct($db)
Constructor.
fetch_lines()
Get lines of template invoices into this->lines.
getLibStatut($mode=0, $alreadypaid=-1)
Return label of object status.
hasUserPermission(User $user, $mode='write')
Check if user has a permission on template supplier invoices.
setNextDate($date, $increment_nb_gen_done=0)
Update the next date of execution.
setMaxPeriod($nb)
Update the maximum period.
createRecurringInvoices($restrictioninvoiceid=0, $forcevalidation=0)
Create all recurrents supplier invoices (for all entities if multicompany is used).
update(User $user, $notrigger=0)
Update fourn_invoice_rec.
addline($fk_product, $ref, $label, $desc, $pu_ht, $pu_ttc, $qty, $remise_percent, $txtva, $txlocaltax1=0, $txlocaltax2=0, $price_base_type='HT', $type=0, $date_start=0, $date_end=0, $info_bits=0, $special_code=0, $rang=-1, $fk_unit=null, $pu_ht_devise=0)
Add a line to recursive supplier invoice.
getNomUrl($withpicto=0, $option='', $max=0, $short=0, $moretitle='', $notooltip=0, $save_lastsearch_value=-1)
Return clickable name (with picto eventually)
create($user, $facFournId, $notrigger=0, $onlylines=array())
Create a predefined supplier invoice.
Class to manage invoice lines.
Class to manage products or services.
Class to manage Dolibarr users.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
dol_time_plus_duree($time, $duration_value, $duration_unit, $ruleforendofmonth=0, $tz='')
Add a delay to a date.
$date_start
Variables from include:
dol_now($mode='gmt')
Return date for now.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
price2num($amount, $rounding='', $option=0, $currencycode='')
Function that return a number with universal decimal format (decimal separator is '.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_getdate($timestamp, $fast=false, $forcetimezone='')
Return an array with locale date info.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
calcul_price_total($qty, $pu, $remise_percent_ligne, $txtva, $uselocaltax1_rate, $uselocaltax2_rate, $notused, $price_base_type, $info_bits, $type, $seller=null, $localtaxes_array=[], $progress=100, $multicurrency_tx=1, $pu_devise=0, $multicurrency_code='')
Calculate totals (net, vat, ...) of a line.
print $langs trans('Date')." left Ref Label right Qty right Price right TotalHT right TotalTTC right right right right right right right right right centpercent right TotalHT right n right VAT right n right TotalVAT right n No sujeto a RE IRPF right TotalLT1 right n right TotalLT2 right n right TotalTTC right n takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency right TotalTTC takeposcustomercurrency right takeposcustomercurrency n right Paid right PaymentTypeShortLIQ right SELECT p pos_change as p datep as date