40require_once DOL_DOCUMENT_ROOT.
'/core/class/commoninvoice.class.php';
41require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobjectline.class.php';
42require_once DOL_DOCUMENT_ROOT.
'/multicurrency/class/multicurrency.class.php';
43require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
45if (isModEnabled(
'accounting')) {
46 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formaccounting.class.php';
47 require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingaccount.class.php';
58 public $element =
'invoice_supplier';
63 public $table_element =
'facture_fourn';
68 public $table_element_line =
'facture_fourn_det';
73 public $fk_element =
'fk_facture_fourn';
78 public $picto =
'supplier_invoice';
84 public $restrictiononfksoc = 1;
104 public $ref_supplier;
172 public $date_echeance;
202 public $total_localtax1;
204 public $total_localtax2;
215 public $note_private;
229 public $transport_mode_id;
234 public $vat_reverse_charge;
236 public $extraparams = array();
242 public $lines = array();
254 public $fk_facture_source;
259 public $fk_fac_rec_source;
261 public $fields = array(
262 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 10),
263 'ref' => array(
'type' =>
'varchar(255)',
'label' =>
'Ref',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'showoncombobox' => 1,
'position' => 15),
264 'ref_supplier' => array(
'type' =>
'varchar(255)',
'label' =>
'RefSupplier',
'enabled' => 1,
'visible' => -1,
'position' => 20),
265 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'default' =>
'1',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 25,
'index' => 1),
266 'ref_ext' => array(
'type' =>
'varchar(255)',
'label' =>
'RefExt',
'enabled' => 1,
'visible' => 0,
'position' => 30),
267 'type' => array(
'type' =>
'smallint(6)',
'label' =>
'Type',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 35),
268 'subtype' => array(
'type' =>
'smallint(6)',
'label' =>
'InvoiceSubtype',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 36),
269 'fk_soc' => array(
'type' =>
'integer:Societe:societe/class/societe.class.php',
'label' =>
'ThirdParty',
'enabled' =>
'isModEnabled("societe")',
'visible' => -1,
'notnull' => 1,
'position' => 40),
270 'datec' => array(
'type' =>
'datetime',
'label' =>
'DateCreation',
'enabled' => 1,
'visible' => -1,
'position' => 45),
271 'datef' => array(
'type' =>
'date',
'label' =>
'Date',
'enabled' => 1,
'visible' => -1,
'position' => 50),
272 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModification',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 55),
273 'libelle' => array(
'type' =>
'varchar(255)',
'label' =>
'Label',
'enabled' => 1,
'visible' => -1,
'position' => 60),
274 'paye' => array(
'type' =>
'smallint(6)',
'label' =>
'Paye',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 65),
275 'amount' => array(
'type' =>
'double(24,8)',
'label' =>
'Amount',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 70),
276 'remise' => array(
'type' =>
'double(24,8)',
'label' =>
'Discount',
'enabled' => 1,
'visible' => -1,
'position' => 75),
277 'close_code' => array(
'type' =>
'varchar(16)',
'label' =>
'CloseCode',
'enabled' => 1,
'visible' => -1,
'position' => 80),
278 'close_note' => array(
'type' =>
'varchar(128)',
'label' =>
'CloseNote',
'enabled' => 1,
'visible' => -1,
'position' => 85),
279 'tva' => array(
'type' =>
'double(24,8)',
'label' =>
'Tva',
'enabled' => 1,
'visible' => -1,
'position' => 90),
280 'localtax1' => array(
'type' =>
'double(24,8)',
'label' =>
'Localtax1',
'enabled' => 1,
'visible' => -1,
'position' => 95),
281 'localtax2' => array(
'type' =>
'double(24,8)',
'label' =>
'Localtax2',
'enabled' => 1,
'visible' => -1,
'position' => 100),
282 'total_ht' => array(
'type' =>
'double(24,8)',
'label' =>
'TotalHT',
'enabled' => 1,
'visible' => -1,
'position' => 105),
283 'total_tva' => array(
'type' =>
'double(24,8)',
'label' =>
'TotalVAT',
'enabled' => 1,
'visible' => -1,
'position' => 110),
284 'total_ttc' => array(
'type' =>
'double(24,8)',
'label' =>
'TotalTTC',
'enabled' => 1,
'visible' => -1,
'position' => 115),
285 'fk_user_author' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserAuthor',
'enabled' => 1,
'visible' => -1,
'position' => 125),
286 'fk_user_modif' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserModif',
'enabled' => 1,
'visible' => -2,
'notnull' => -1,
'position' => 130),
287 'fk_user_valid' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserValidation',
'enabled' => 1,
'visible' => -1,
'position' => 135),
288 'fk_facture_source' => array(
'type' =>
'integer',
'label' =>
'Fk facture source',
'enabled' => 1,
'visible' => -1,
'position' => 140),
289 'fk_projet' => array(
'type' =>
'integer:Project:projet/class/project.class.php:1:fk_statut=1',
'label' =>
'Project',
'enabled' =>
"isModEnabled('project')",
'visible' => -1,
'position' => 145),
290 'fk_account' => array(
'type' =>
'integer',
'label' =>
'Account',
'enabled' =>
'isModEnabled("bank")',
'visible' => -1,
'position' => 150),
291 'fk_cond_reglement' => array(
'type' =>
'integer',
'label' =>
'PaymentTerm',
'enabled' => 1,
'visible' => -1,
'position' => 155),
292 'fk_mode_reglement' => array(
'type' =>
'integer',
'label' =>
'PaymentMode',
'enabled' => 1,
'visible' => -1,
'position' => 160),
293 'date_lim_reglement' => array(
'type' =>
'date',
'label' =>
'DateLimReglement',
'enabled' => 1,
'visible' => -1,
'position' => 165),
294 'note_private' => array(
'type' =>
'html',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => 0,
'position' => 170),
295 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 175),
296 'model_pdf' => array(
'type' =>
'varchar(255)',
'label' =>
'ModelPdf',
'enabled' => 1,
'visible' => 0,
'position' => 180),
297 'extraparams' => array(
'type' =>
'varchar(255)',
'label' =>
'Extraparams',
'enabled' => 1,
'visible' => -1,
'position' => 190),
298 'fk_incoterms' => array(
'type' =>
'integer',
'label' =>
'IncotermCode',
'enabled' => 1,
'visible' => -1,
'position' => 195),
299 'location_incoterms' => array(
'type' =>
'varchar(255)',
'label' =>
'IncotermLocation',
'enabled' => 1,
'visible' => -1,
'position' => 200),
300 'fk_multicurrency' => array(
'type' =>
'integer',
'label' =>
'MulticurrencyId',
'enabled' => 1,
'visible' => -1,
'position' => 205),
301 'multicurrency_code' => array(
'type' =>
'varchar(255)',
'label' =>
'MulticurrencyCode',
'enabled' => 1,
'visible' => -1,
'position' => 210),
302 'multicurrency_tx' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyRate',
'enabled' => 1,
'visible' => -1,
'position' => 215),
303 'multicurrency_total_ht' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyTotalHT',
'enabled' => 1,
'visible' => -1,
'position' => 220),
304 'multicurrency_total_tva' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyTotalVAT',
'enabled' => 1,
'visible' => -1,
'position' => 225),
305 'multicurrency_total_ttc' => array(
'type' =>
'double(24,8)',
'label' =>
'MulticurrencyTotalTTC',
'enabled' => 1,
'visible' => -1,
'position' => 230),
306 'date_pointoftax' => array(
'type' =>
'date',
'label' =>
'Date pointoftax',
'enabled' => 1,
'visible' => -1,
'position' => 235),
307 'date_valid' => array(
'type' =>
'date',
'label' =>
'DateValidation',
'enabled' => 1,
'visible' => -1,
'position' => 240),
308 'last_main_doc' => array(
'type' =>
'varchar(255)',
'label' =>
'Last main doc',
'enabled' => 1,
'visible' => -1,
'position' => 245),
309 'fk_statut' => array(
'type' =>
'smallint(6)',
'label' =>
'Status',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 500),
310 'import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' => 1,
'visible' => -2,
'position' => 900),
362 const CLOSECODE_DISCOUNTVAT =
'discount_vat';
363 const CLOSECODE_BADCREDIT =
'badsupplier';
364 const CLOSECODE_ABANDONED =
'abandon';
365 const CLOSECODE_REPLACED =
'replaced';
376 $this->ismultientitymanaged = 1;
387 global $langs, $conf, $hookmanager;
393 if (isset($this->ref_supplier)) {
394 $this->ref_supplier = trim($this->ref_supplier);
396 if (empty($this->
type)) {
399 if (empty($this->date)) {
404 if (!empty($this->multicurrency_code) && empty($this->multicurrency_tx)) {
409 if (empty($this->fk_multicurrency)) {
410 $this->multicurrency_code = $conf->currency;
411 $this->fk_multicurrency = 0;
412 $this->multicurrency_tx = 1;
418 if ($this->fac_rec > 0) {
419 $this->fk_fac_rec_source = $this->fac_rec;
421 require_once DOL_DOCUMENT_ROOT .
'/fourn/class/fournisseur.facture-rec.class.php';
423 $result = $_facrec->fetch($this->fac_rec);
424 $result = $_facrec->fetchObjectLinked(
null,
'',
null,
'',
'OR', 1,
'sourcetype', 0);
427 if (!empty($_facrec->frequency)) {
428 $originaldatewhen = $_facrec->date_when;
429 $nextdatewhen =
dol_time_plus_duree($originaldatewhen, $_facrec->frequency, $_facrec->unit_frequency);
431 $this->socid = $_facrec->socid;
433 $originaldatewhen = 0;
435 $previousdaynextdatewhen = 0;
438 $this->entity = $_facrec->entity;
443 $this->fk_project =
GETPOSTINT(
'projectid') > 0 ? (
GETPOSTINT(
'projectid')) : $_facrec->fk_project;
444 $this->note_public =
GETPOST(
'note_public',
'restricthtml') ?
GETPOST(
'note_public',
'restricthtml') : $_facrec->note_public;
445 $this->note_private =
GETPOST(
'note_private',
'restricthtml') ?
GETPOST(
'note_private',
'restricthtml') : $_facrec->note_private;
446 $this->model_pdf =
GETPOST(
'model',
'alpha') ?
GETPOST(
'model',
'alpha') : $_facrec->model_pdf;
447 $this->cond_reglement_id =
GETPOSTINT(
'cond_reglement_id') > 0 ? (
GETPOSTINT(
'cond_reglement_id')) : $_facrec->cond_reglement_id;
448 $this->mode_reglement_id =
GETPOSTINT(
'mode_reglement_id') > 0 ? (
GETPOSTINT(
'mode_reglement_id')) : $_facrec->mode_reglement_id;
449 $this->fk_account =
GETPOST(
'fk_account') > 0 ? ((int)
GETPOST(
'fk_account')) : $_facrec->fk_account;
452 $this->total_ht = $_facrec->total_ht;
453 $this->total_ttc = $_facrec->total_ttc;
456 $this->fk_incoterms = $_facrec->fk_incoterms;
457 $this->location_incoterms = $_facrec->location_incoterms;
463 if (!empty(
GETPOST(
'ref_supplier'))) {
464 $this->ref_supplier = trim($this->ref_supplier);
466 $this->ref_supplier = trim($this->ref_supplier .
'_' . ($_facrec->nb_gen_done + 1));
468 $this->note_public = trim($this->note_public);
469 $this->note_private = trim($this->note_private);
470 $this->note_private =
dol_concatdesc($this->note_private, $langs->trans(
"GeneratedFromRecurringInvoice", $_facrec->title));
472 $this->array_options = $_facrec->array_options;
474 if (! $this->mode_reglement_id) {
475 $this->mode_reglement_id = 0;
480 $this->linked_objects = $_facrec->linkedObjectsIds;
487 if ($_facrec->frequency > 0) {
488 dol_syslog(
"This is a recurring invoice so we set date_last_gen and next date_when");
489 if (empty($_facrec->date_when)) {
490 $_facrec->date_when = $now;
492 $next_date = $_facrec->getNextDate();
493 $result = $_facrec->setValueFrom(
'date_last_gen', $now,
'', 0,
'date',
'', $user,
'');
495 $result = $_facrec->setNextDate($next_date, 1);
499 $outputlangs = $langs;
502 if (
getDolGlobalInt(
'MAIN_MULTILANGS') && empty($newlang) && isset($this->thirdparty->default_lang)) {
503 $newlang = $this->thirdparty->default_lang;
505 if (
getDolGlobalInt(
'MAIN_MULTILANGS') && empty($newlang) && isset($this->default_lang)) {
506 $newlang = $this->default_lang;
508 if (!empty($newlang)) {
510 $outputlangs->setDefaultLang($newlang);
514 $substitutionarray[
'__INVOICE_MONTH__'] =
dol_print_date($this->date,
'%m');
517 $substitutionarray[
'__INVOICE_MONTH_TEXT__'] =
dol_print_date($this->date,
'%B');
520 $substitutionarray[
'__INVOICE_YEAR__'] =
dol_print_date($this->date,
'%Y');
522 $substitutionarray[
'__INVOICE_DATE_NEXT_INVOICE_BEFORE_GEN__'] = $originaldatewhen ?
dol_print_date($originaldatewhen,
'dayhour') :
'';
523 $substitutionarray[
'__INVOICE_DATE_NEXT_INVOICE_AFTER_GEN__'] = $nextdatewhen ?
dol_print_date($nextdatewhen,
'dayhour') :
'';
524 $substitutionarray[
'__INVOICE_PREVIOUS_DATE_NEXT_INVOICE_AFTER_GEN__'] = $previousdaynextdatewhen ?
dol_print_date($previousdaynextdatewhen,
'dayhour') :
'';
525 $substitutionarray[
'__INVOICE_COUNTER_CURRENT__'] = $_facrec->nb_gen_done;
526 $substitutionarray[
'__INVOICE_COUNTER_MAX__'] = $_facrec->nb_gen_max;
535 if (!empty($forceduedate)) {
536 $this->date_echeance = $forceduedate;
539 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"facture_fourn (";
541 $sql .=
", ref_supplier";
550 $sql .=
", vat_reverse_charge";
551 $sql .=
", fk_projet";
552 $sql .=
", fk_cond_reglement";
553 $sql .=
", fk_mode_reglement";
554 $sql .=
", fk_account";
555 $sql .=
", note_private";
556 $sql .=
", note_public";
557 $sql .=
", fk_user_author";
558 $sql .=
", date_lim_reglement";
559 $sql .=
", fk_incoterms, location_incoterms";
560 $sql .=
", fk_multicurrency";
561 $sql .=
", multicurrency_code";
562 $sql .=
", multicurrency_tx";
563 $sql .=
", fk_facture_source";
564 $sql .=
", fk_fac_rec_source";
568 $sql .=
", '".$this->db->escape($this->ref_supplier).
"'";
569 $sql .=
", '".$this->db->escape($this->ref_ext).
"'";
570 $sql .=
", ".((int) $conf->entity);
571 $sql .=
", '".$this->db->escape($this->
type).
"'";
572 $sql .=
", ".((int) $this->subtype);
573 $sql .=
", '".$this->db->escape(isset($this->label) ? $this->label : (isset($this->libelle) ? $this->libelle :
'')).
"'";
574 $sql .=
", ".((int) $this->socid);
575 $sql .=
", '".$this->db->idate($now).
"'";
576 $sql .=
", '".$this->db->idate($this->date).
"'";
577 $sql .=
", ".($this->vat_reverse_charge !=
'' ? ((int) $this->db->escape($this->vat_reverse_charge)) : 0);
578 $sql .=
", ".($this->fk_project > 0 ? ((int) $this->fk_project) :
"null");
579 $sql .=
", ".($this->cond_reglement_id > 0 ? ((int) $this->cond_reglement_id) :
"null");
580 $sql .=
", ".($this->mode_reglement_id > 0 ? ((int) $this->mode_reglement_id) :
"null");
581 $sql .=
", ".($this->fk_account > 0 ? ((int) $this->fk_account) :
'NULL');
582 $sql .=
", '".$this->db->escape($this->note_private).
"'";
583 $sql .=
", '".$this->db->escape($this->note_public).
"'";
584 $sql .=
", ".((int) $user->id).
",";
585 $sql .= $this->date_echeance !=
'' ?
"'".$this->db->idate($this->date_echeance).
"'" :
"null";
586 $sql .=
", ".(int) $this->fk_incoterms;
587 $sql .=
", '".$this->db->escape($this->location_incoterms).
"'";
588 $sql .=
", ".(int) $this->fk_multicurrency;
589 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
590 $sql .=
", ".(float) $this->multicurrency_tx;
591 $sql .=
", ".($this->fk_facture_source ? ((int) $this->fk_facture_source) :
"null");
592 $sql .=
", ".(isset($this->fk_fac_rec_source) ? $this->fk_fac_rec_source :
"NULL");
595 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
596 $resql = $this->db->query($sql);
598 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
'facture_fourn');
601 $this->
ref =
'(PROV'.$this->id.
')';
602 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"facture_fourn SET ref='".$this->db->escape($this->
ref).
"' WHERE rowid=".((int) $this->
id);
604 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
605 $resql = $this->db->query($sql);
610 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
611 $this->linked_objects = $this->linkedObjectsIds;
615 if (!$error && $this->
id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
616 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
617 if (is_array($tmp_origin_id)) {
618 foreach ($tmp_origin_id as $origin_id) {
626 $origin_id = $tmp_origin_id;
636 if (!$error && empty($this->fac_rec) && count($this->lines) && is_object($this->lines[0])) {
637 dol_syslog(
"There is ".count($this->lines).
" lines that are invoice lines objects");
638 foreach ($this->lines as $i => $val) {
639 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.
'facture_fourn_det (fk_facture_fourn, special_code, fk_remise_except)';
640 $sql .=
" VALUES (".((int) $this->
id).
", ".((int) $this->lines[$i]->special_code).
", ".($this->lines[$i]->fk_remise_except > 0 ? ((int) $this->lines[$i]->fk_remise_except) :
'NULL').
')';
642 $resql_insert = $this->db->query($sql);
644 $idligne = $this->db->last_insert_id(MAIN_DB_PREFIX.
'facture_fourn_det');
648 $this->lines[$i]->desc ? $this->lines[$i]->desc : $this->lines[$i]->description,
649 $this->lines[$i]->subprice,
650 $this->lines[$i]->tva_tx.($this->lines[$i]->vat_src_code ?
' ('.$this->lines[$i]->vat_src_code.
')' :
''),
651 $this->lines[$i]->localtax1_tx,
652 $this->lines[$i]->localtax2_tx,
653 $this->lines[$i]->qty,
654 $this->lines[$i]->fk_product,
656 (!empty($this->lines[$i]->info_bits) ? $this->lines[$i]->info_bits :
''),
657 $this->lines[$i]->product_type,
658 $this->lines[$i]->remise_percent,
660 $this->lines[$i]->date_start,
661 $this->lines[$i]->date_end,
662 $this->lines[$i]->array_options,
663 $this->lines[$i]->fk_unit,
664 $this->lines[$i]->multicurrency_subprice,
665 $this->lines[$i]->ref_supplier
668 $this->error = $this->db->lasterror();
669 $this->db->rollback();
673 } elseif (!$error && empty($this->fac_rec)) {
674 dol_syslog(
"There is ".count($this->lines).
" lines that are array lines");
675 foreach ($this->lines as $i => $val) {
676 $line = $this->lines[$i];
680 if (!is_object($line)) {
681 $line = (object) $line;
684 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.
'facture_fourn_det (fk_facture_fourn, special_code, fk_remise_except)';
685 $sql .=
" VALUES (".((int) $this->
id).
", ".((int) $this->lines[$i]->special_code).
", ".($this->lines[$i]->fk_remise_except > 0 ? ((int) $this->lines[$i]->fk_remise_except) :
'NULL').
')';
687 $resql_insert = $this->db->query($sql);
689 $idligne = $this->db->last_insert_id(MAIN_DB_PREFIX.
'facture_fourn_det');
693 $line->desc ? $line->desc : $line->description,
701 (!empty($line->info_bits) ? $line->info_bits :
''),
703 $line->remise_percent,
707 $line->array_options,
709 $line->multicurrency_subprice,
713 $this->error = $this->db->lasterror();
714 $this->db->rollback();
724 foreach ($_facrec->lines as $i => $val) {
725 $product_type = $_facrec->lines[$i]->product_type;
726 if ($_facrec->lines[$i]->fk_product) {
727 $prod =
new Product($this->db);
728 $res = $prod->fetch($_facrec->lines[$i]->fk_product);
739 $tva_tx = $_facrec->lines[$i]->tva_tx . ($_facrec->lines[$i]->vat_src_code ?
'(' . $_facrec->lines[$i]->vat_src_code .
')' :
'');
740 $tva_npr = $_facrec->lines[$i]->info_bits;
741 if (empty($tva_tx)) {
744 $localtax1_tx = $_facrec->lines[$i]->localtax1_tx;
745 $localtax2_tx = $_facrec->lines[$i]->localtax2_tx;
747 $fk_product_fournisseur_price = empty($_facrec->lines[$i]->fk_product_fournisseur_price) ? null : $_facrec->lines[$i]->fk_product_fournisseur_price;
748 $buyprice = empty($_facrec->lines[$i]->buyprice) ? 0 : $_facrec->lines[$i]->buyprice;
751 if (! $buyprice && $_facrec->lines[$i]->fk_product > 0) {
752 require_once DOL_DOCUMENT_ROOT .
'/fourn/class/fournisseur.product.class.php';
754 $producttmp->fetch($_facrec->lines[$i]->fk_product);
759 if (
getDolGlobalString(
'MARGIN_TYPE') ==
'costprice' && !empty($producttmp->cost_price)) {
760 $buyprice = $producttmp->cost_price;
762 $buyprice = $producttmp->pmp;
764 if ($producttmp->find_min_price_product_fournisseur($_facrec->lines[$i]->fk_product) > 0) {
765 if ($producttmp->product_fourn_price_id > 0) {
766 $buyprice =
price2num($producttmp->fourn_unitprice * (1 - $producttmp->fourn_remise_percent / 100) + $producttmp->fourn_remise,
'MU');
772 $result_insert = $this->
addline(
773 $_facrec->lines[$i]->desc ? $_facrec->lines[$i]->desc : $_facrec->lines[$i]->description,
774 $_facrec->lines[$i]->pu_ht,
778 $_facrec->lines[$i]->qty,
779 $_facrec->lines[$i]->fk_product,
780 $_facrec->lines[$i]->remise_percent,
781 ($_facrec->lines[$i]->date_start == 1 && $this->date) ? $this->date :
'',
782 ($_facrec->lines[$i]->date_end == 1 && $previousdaynextdatewhen) ? $previousdaynextdatewhen :
'',
784 $_facrec->lines[$i]->info_bits,
787 $_facrec->lines[$i]->rang,
789 $_facrec->lines[$i]->array_options,
790 $_facrec->lines[$i]->fk_unit,
793 $_facrec->lines[$i]->ref_supplier,
794 $_facrec->lines[$i]->special_code,
798 if ($result_insert < 0) {
800 $this->error = $this->db->error();
820 $result = $this->
call_trigger(
'BILL_SUPPLIER_CREATE', $user);
831 $this->db->rollback();
835 $this->error = $langs->trans(
'FailedToUpdatePrice');
836 $this->db->rollback();
840 if ($this->db->errno() ==
'DB_ERROR_RECORD_ALREADY_EXISTS') {
841 $this->error = $langs->trans(
'ErrorRefAlreadyExists');
842 $this->db->rollback();
845 $this->error = $this->db->lasterror();
846 $this->db->rollback();
860 public function fetch($id = 0, $ref =
'', $ref_ext =
'')
862 if (empty($id) && empty($ref) && empty($ref_ext)) {
869 $sql .=
" t.ref_supplier,";
870 $sql .=
" t.ref_ext,";
871 $sql .=
" t.entity,";
873 $sql .=
" t.subtype,";
874 $sql .=
" t.fk_soc,";
878 $sql .=
" t.libelle as label,";
880 $sql .=
" t.close_code,";
881 $sql .=
" t.close_note,";
883 $sql .=
" t.localtax1,";
884 $sql .=
" t.localtax2,";
885 $sql .=
" t.total_ht,";
886 $sql .=
" t.total_tva,";
887 $sql .=
" t.total_ttc,";
888 $sql .=
" t.fk_statut as status,";
889 $sql .=
" t.fk_user_author,";
890 $sql .=
" t.fk_user_valid,";
891 $sql .=
" t.fk_facture_source,";
892 $sql .=
" t.vat_reverse_charge,";
893 $sql .=
" t.fk_fac_rec_source,";
894 $sql .=
" t.fk_projet as fk_project,";
895 $sql .=
" t.fk_cond_reglement,";
896 $sql .=
" t.fk_account,";
897 $sql .=
" t.fk_mode_reglement,";
898 $sql .=
" t.date_lim_reglement,";
899 $sql .=
" t.note_private,";
900 $sql .=
" t.note_public,";
901 $sql .=
" t.model_pdf,";
902 $sql .=
" t.last_main_doc,";
903 $sql .=
" t.import_key,";
904 $sql .=
" t.extraparams,";
905 $sql .=
" cr.code as cond_reglement_code, cr.libelle as cond_reglement_label, cr.libelle_facture as cond_reglement_doc,";
906 $sql .=
" p.code as mode_reglement_code, p.libelle as mode_reglement_label,";
907 $sql .=
' s.nom as socnom, s.rowid as socid,';
908 $sql .=
' t.fk_incoterms, t.location_incoterms,';
909 $sql .=
" i.libelle as label_incoterms,";
910 $sql .=
' t.fk_transport_mode,';
911 $sql .=
' t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc';
912 $sql .=
' FROM '.MAIN_DB_PREFIX.
'facture_fourn as t';
913 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON (t.fk_soc = s.rowid)";
914 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_payment_term as cr ON t.fk_cond_reglement = cr.rowid";
915 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_paiement as p ON t.fk_mode_reglement = p.id";
916 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_incoterms as i ON t.fk_incoterms = i.rowid';
918 $sql .=
" WHERE t.rowid = ".((int) $id);
920 $sql .=
' WHERE t.entity IN ('.getEntity(
'supplier_invoice').
')';
922 $sql .=
" AND t.ref = '".$this->db->escape($ref).
"'";
925 $sql .=
" AND t.ref_ext = '".$this->db->escape($ref_ext).
"'";
929 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
930 $resql = $this->db->query($sql);
932 if ($this->db->num_rows($resql)) {
933 $obj = $this->db->fetch_object($resql);
935 $this->
id = $obj->rowid;
936 $this->
ref = $obj->ref ? $obj->ref : $obj->rowid;
938 $this->ref_supplier = $obj->ref_supplier;
939 $this->ref_ext = $obj->ref_ext;
940 $this->entity = $obj->entity;
942 $this->subtype = (int) $obj->subtype;
943 $this->socid = $obj->fk_soc;
944 $this->datec = $this->db->jdate($obj->datec);
945 $this->date = $this->db->jdate($obj->datef);
947 $this->tms = $this->db->jdate($obj->tms);
948 $this->libelle = $obj->label;
949 $this->label = $obj->label;
950 $this->paye = $obj->paye;
951 $this->paid = $obj->paye;
952 $this->close_code = $obj->close_code;
953 $this->close_note = $obj->close_note;
954 $this->total_localtax1 = $obj->localtax1;
955 $this->total_localtax2 = $obj->localtax2;
956 $this->total_ht = $obj->total_ht;
957 $this->total_tva = $obj->total_tva;
958 $this->total_ttc = $obj->total_ttc;
959 $this->
status = $obj->status;
960 $this->
statut = $obj->status;
961 $this->fk_statut = $obj->status;
962 $this->user_creation_id = $obj->fk_user_author;
963 $this->author = $obj->fk_user_author;
964 $this->user_validation_id = $obj->fk_user_valid;
965 $this->fk_facture_source = $obj->fk_facture_source;
966 $this->vat_reverse_charge = empty($obj->vat_reverse_charge) ? 0 : 1;
967 $this->fk_fac_rec_source = $obj->fk_fac_rec_source;
968 $this->fk_project = $obj->fk_project;
969 $this->cond_reglement_id = $obj->fk_cond_reglement;
970 $this->cond_reglement_code = $obj->cond_reglement_code;
971 $this->cond_reglement = $obj->cond_reglement_label;
972 $this->cond_reglement_label = $obj->cond_reglement_label;
973 $this->cond_reglement_doc = $obj->cond_reglement_doc;
974 $this->fk_account = $obj->fk_account;
975 $this->mode_reglement_id = $obj->fk_mode_reglement;
976 $this->mode_reglement_code = $obj->mode_reglement_code;
977 $this->mode_reglement = $obj->mode_reglement_label;
978 $this->date_echeance = $this->db->jdate($obj->date_lim_reglement);
979 $this->note = $obj->note_private;
980 $this->note_private = $obj->note_private;
981 $this->note_public = $obj->note_public;
982 $this->model_pdf = $obj->model_pdf;
983 $this->last_main_doc = $obj->last_main_doc;
984 $this->import_key = $obj->import_key;
987 $this->fk_incoterms = $obj->fk_incoterms;
988 $this->location_incoterms = $obj->location_incoterms;
989 $this->label_incoterms = $obj->label_incoterms;
990 $this->transport_mode_id = $obj->fk_transport_mode;
993 $this->fk_multicurrency = $obj->fk_multicurrency;
994 $this->multicurrency_code = $obj->multicurrency_code;
995 $this->multicurrency_tx = $obj->multicurrency_tx;
996 $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
997 $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
998 $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
1000 $this->extraparams = isset($obj->extraparams) ? (array) json_decode($obj->extraparams,
true) : array();
1002 $this->socid = $obj->socid;
1010 $this->error = $this->db->lasterror();
1014 $this->error =
'Bill with id '.$id.
' not found';
1015 dol_syslog(get_class($this).
'::fetch '.$this->error);
1019 $this->db->free($resql);
1022 $this->error =
"Error ".$this->db->lasterror();
1037 $this->lines = array();
1039 $sql =
'SELECT f.rowid, f.ref as ref_supplier, f.description as line_desc, f.date_start, f.date_end, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx';
1040 $sql .=
', f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn, f.fk_remise_except';
1041 $sql .=
', f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit';
1042 $sql .=
', p.rowid as product_id, p.ref as product_ref, p.label as label, p.barcode as product_barcode, p.description as product_desc';
1043 $sql .=
', f.fk_code_ventilation, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc';
1044 $sql .=
' FROM '.MAIN_DB_PREFIX.
'facture_fourn_det as f';
1045 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON f.fk_product = p.rowid';
1046 $sql .=
' WHERE fk_facture_fourn='.((int) $this->
id);
1047 $sql .=
' ORDER BY f.rang, f.rowid';
1049 dol_syslog(get_class($this).
"::fetch_lines", LOG_DEBUG);
1051 $resql_rows = $this->db->query($sql);
1053 $num_rows = $this->db->num_rows($resql_rows);
1056 while ($i < $num_rows) {
1057 $obj = $this->db->fetch_object($resql_rows);
1061 $line->id = $obj->rowid;
1062 $line->rowid = $obj->rowid;
1064 $line->description = $obj->line_desc;
1065 $line->desc = $obj->line_desc;
1066 $line->date_start = $this->db->jdate($obj->date_start);
1067 $line->date_end = $this->db->jdate($obj->date_end);
1069 $line->product_ref = $obj->product_ref;
1070 $line->ref = $obj->product_ref;
1071 $line->ref_supplier = $obj->ref_supplier;
1072 $line->libelle = $obj->label;
1073 $line->label = $obj->label;
1074 $line->product_barcode = $obj->product_barcode;
1075 $line->product_desc = $obj->product_desc;
1076 $line->subprice = $obj->pu_ht;
1077 $line->pu_ht = $obj->pu_ht;
1078 $line->pu_ttc = $obj->pu_ttc;
1079 $line->vat_src_code = $obj->vat_src_code;
1080 $line->tva_tx = $obj->tva_tx;
1081 $line->localtax1_tx = $obj->localtax1_tx;
1082 $line->localtax2_tx = $obj->localtax2_tx;
1083 $line->localtax1_type = $obj->localtax1_type;
1084 $line->localtax2_type = $obj->localtax2_type;
1085 $line->qty = $obj->qty;
1086 $line->remise_percent = $obj->remise_percent;
1087 $line->fk_remise_except = $obj->fk_remise_except;
1089 $line->total_ht = $obj->total_ht;
1090 $line->total_ttc = $obj->total_ttc;
1091 $line->total_tva = $obj->total_tva;
1092 $line->total_localtax1 = $obj->total_localtax1;
1093 $line->total_localtax2 = $obj->total_localtax2;
1094 $line->fk_facture_fourn = $obj->fk_facture_fourn;
1095 $line->fk_product = $obj->fk_product;
1096 $line->product_type = $obj->product_type;
1097 $line->product_label = $obj->label;
1098 $line->info_bits = $obj->info_bits;
1099 $line->fk_parent_line = $obj->fk_parent_line;
1100 $line->special_code = $obj->special_code;
1101 $line->rang = $obj->rang;
1102 $line->fk_unit = $obj->fk_unit;
1105 $line->fk_accounting_account = $obj->fk_code_ventilation;
1108 $line->fk_multicurrency = $obj->fk_multicurrency;
1109 $line->multicurrency_code = $obj->multicurrency_code;
1110 $line->multicurrency_subprice = $obj->multicurrency_subprice;
1111 $line->multicurrency_total_ht = $obj->multicurrency_total_ht;
1112 $line->multicurrency_total_tva = $obj->multicurrency_total_tva;
1113 $line->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
1116 $line->fetch_optionals();
1118 $this->lines[$i] = $line;
1123 $this->db->free($resql_rows);
1126 $this->error = $this->db->error();
1127 dol_syslog(get_class($this).
"::fetch_lines - No lines:{$this->error} Error:{$this->error}", LOG_DEBUG);
1140 public function update($user =
null, $notrigger = 0)
1146 if (empty($this->
type)) {
1149 if (isset($this->
ref)) {
1150 $this->
ref = trim($this->
ref);
1152 if (isset($this->ref_supplier)) {
1153 $this->ref_supplier = trim($this->ref_supplier);
1155 if (isset($this->ref_ext)) {
1156 $this->ref_ext = trim($this->ref_ext);
1158 if (isset($this->entity)) {
1159 $this->entity = (int) $this->entity;
1161 if (isset($this->
type)) {
1164 if (isset($this->subtype)) {
1165 $this->subtype = (int) $this->subtype;
1167 if (isset($this->socid)) {
1168 $this->socid = (int) $this->socid;
1170 if (isset($this->label)) {
1171 $this->label = trim($this->label);
1173 if (isset($this->paid)) {
1174 $this->paid = (int) (
bool) $this->paye;
1175 $this->paye = $this->paid;
1176 } elseif (isset($this->paye)) {
1177 $this->paid = (int) (
bool) $this->paye;
1178 $this->paye = $this->paid;
1180 if (isset($this->close_code)) {
1181 $this->close_code = trim($this->close_code);
1183 if (isset($this->close_note)) {
1184 $this->close_note = trim($this->close_note);
1186 if (empty($this->total_ht)) {
1187 $this->total_ht = 0;
1189 if (empty($this->total_tva)) {
1190 $this->total_tva = 0;
1192 if (empty($this->total_localtax1)) {
1193 $this->total_localtax1 = 0;
1195 if (empty($this->total_localtax2)) {
1196 $this->total_localtax2 = 0;
1198 if (isset($this->total_ttc)) {
1199 $this->total_ttc = (float) $this->total_ttc;
1201 if (isset($this->
status)) {
1203 $this->
statut = $this->status;
1204 } elseif (isset($this->
statut)) {
1206 $this->
statut = $this->status;
1208 if (isset($this->author)) {
1209 $this->author = (int) $this->author;
1211 if (isset($this->fk_user_valid)) {
1212 $this->fk_user_valid = trim($this->fk_user_valid);
1214 if (isset($this->fk_facture_source)) {
1215 $this->fk_facture_source = (int) $this->fk_facture_source;
1217 if (isset($this->fk_project)) {
1218 if (empty($this->fk_project)) {
1219 $this->fk_project = 0;
1221 $this->fk_project = (int) $this->fk_project;
1224 if (isset($this->mode_reglement_id)) {
1225 $this->mode_reglement_id = (int) $this->mode_reglement_id;
1227 if (isset($this->cond_reglement_id)) {
1228 $this->cond_reglement_id = (int) $this->cond_reglement_id;
1230 if (isset($this->note_private)) {
1231 $this->note_private = trim($this->note_private);
1232 $this->note = $this->note_private;
1234 if (isset($this->note_public)) {
1235 $this->note_public = trim($this->note_public);
1237 if (isset($this->model_pdf)) {
1238 $this->model_pdf = trim($this->model_pdf);
1240 if (isset($this->import_key)) {
1241 $this->import_key = trim($this->import_key);
1249 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"facture_fourn SET";
1250 $sql .=
" ref=".(isset($this->
ref) ?
"'".$this->db->escape($this->
ref).
"'" :
"null").
",";
1251 $sql .=
" ref_supplier=".(isset($this->ref_supplier) ?
"'".$this->db->escape($this->ref_supplier).
"'" :
"null").
",";
1252 $sql .=
" ref_ext=".(isset($this->ref_ext) ?
"'".$this->db->escape($this->ref_ext).
"'" :
"null").
",";
1253 $sql .=
" entity=".(isset($this->entity) ? ((int) $this->entity) :
"null").
",";
1254 $sql .=
" type=".(isset($this->
type) ? ((int) $this->
type) :
"null").
",";
1255 $sql .=
" subtype=".((int) $this->subtype).
",";
1256 $sql .=
" fk_soc=".(isset($this->socid) ? ((int) $this->socid) :
"null").
",";
1257 $sql .=
" datec=".(dol_strlen($this->datec) != 0 ?
"'".$this->db->idate($this->datec).
"'" :
'null').
",";
1258 $sql .=
" datef=".(dol_strlen($this->date) != 0 ?
"'".$this->db->idate($this->date).
"'" :
'null').
",";
1260 $sql .=
" tms=".(dol_strlen($this->tms) != 0 ?
"'".$this->db->idate($this->tms).
"'" :
'null').
",";
1262 $sql .=
" libelle=".(isset($this->label) ?
"'".$this->db->escape($this->label).
"'" :
"null").
",";
1263 $sql .=
" paye=".(isset($this->paid) ? ((int) $this->paid) :
"0").
",";
1264 $sql .=
" close_code=".(isset($this->close_code) ?
"'".$this->db->escape($this->close_code).
"'" :
"null").
",";
1265 $sql .=
" close_note=".(isset($this->close_note) ?
"'".$this->db->escape($this->close_note).
"'" :
"null").
",";
1266 $sql .=
" localtax1=".(isset($this->total_localtax1) ? ((float) $this->total_localtax1) :
"null").
",";
1267 $sql .=
" localtax2=".(isset($this->total_localtax2) ? ((float) $this->total_localtax2) :
"null").
",";
1268 $sql .=
" total_ht=".(isset($this->total_ht) ? ((float) $this->total_ht) :
"null").
",";
1269 $sql .=
" total_tva=".(isset($this->total_tva) ? ((float) $this->total_tva) :
"null").
",";
1270 $sql .=
" total_ttc=".(isset($this->total_ttc) ? ((float) $this->total_ttc) :
"null").
",";
1271 $sql .=
" fk_statut=".(isset($this->
status) ? ((int) $this->
status) : (isset($this->
statut) ? ((int) $this->
statut) :
"null")).
",";
1272 $sql .=
" fk_user_author=".(isset($this->author) ? ((int) $this->author) :
"null").
",";
1273 $sql .=
" fk_user_valid=".(isset($this->fk_user_valid) ? ((int) $this->fk_user_valid) :
"null").
",";
1274 $sql .=
" fk_facture_source=".($this->fk_facture_source ? ((int) $this->fk_facture_source) :
"null").
",";
1275 $sql .=
" vat_reverse_charge = ".($this->vat_reverse_charge !=
'' ? ((int) $this->db->escape($this->vat_reverse_charge)) : 0).
",";
1276 $sql .=
" fk_projet=".(!empty($this->fk_project) ? ((int) $this->fk_project) :
"null").
",";
1277 $sql .=
" fk_mode_reglement=".(isset($this->mode_reglement_id) ? ((int) $this->mode_reglement_id) :
"null").
",";
1278 $sql .=
" fk_cond_reglement=".(isset($this->cond_reglement_id) ? ((int) $this->cond_reglement_id) :
"null").
",";
1279 $sql .=
" date_lim_reglement=".(dol_strlen($this->date_echeance) != 0 ?
"'".$this->db->idate($this->date_echeance).
"'" :
'null').
",";
1280 $sql .=
" note_private=".(isset($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
"null").
",";
1281 $sql .=
" note_public=".(isset($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
"null").
",";
1282 $sql .=
" model_pdf=".(isset($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
"null").
",";
1283 $sql .=
" import_key=".(isset($this->import_key) ?
"'".$this->db->escape($this->import_key).
"'" :
"null");
1284 $sql .=
" WHERE rowid=".((int) $this->
id);
1288 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
1289 $resql = $this->db->query($sql);
1294 if ($this->db->errno() ==
'DB_ERROR_RECORD_ALREADY_EXISTS') {
1295 $this->errors[] = $langs->trans(
'ErrorRefAlreadyExists');
1297 $this->errors[] =
"Error ".$this->db->lasterror();
1311 $result = $this->
call_trigger(
'BILL_SUPPLIER_MODIFY', $user);
1321 foreach ($this->errors as $errmsg) {
1322 dol_syslog(get_class($this).
"::update ".$errmsg, LOG_ERR);
1323 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1325 $this->db->rollback();
1328 $this->db->commit();
1343 global $conf, $langs;
1345 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
1346 include_once DOL_DOCUMENT_ROOT.
'/core/class/discount.class.php';
1351 $result =
$remise->fetch($idremise);
1354 if (
$remise->fk_invoice_supplier) {
1355 $this->error = $langs->trans(
"ErrorDiscountAlreadyUsed");
1356 $this->db->rollback();
1361 $facligne->fk_facture_fourn = $this->id;
1362 $facligne->fk_remise_except =
$remise->id;
1363 $facligne->desc =
$remise->description;
1364 $facligne->vat_src_code =
$remise->vat_src_code;
1365 $facligne->tva_tx =
$remise->tva_tx;
1366 $facligne->subprice = -
$remise->amount_ht;
1367 $facligne->fk_product = 0;
1368 $facligne->product_type = 0;
1370 $facligne->remise_percent = 0;
1371 $facligne->rang = -1;
1372 $facligne->info_bits = 2;
1375 $facligne->rang = 1;
1376 $linecount = count($this->lines);
1377 for ($ii = 1; $ii <= $linecount; $ii++) {
1383 if (
$remise->fk_invoice_supplier_source > 0) {
1385 $srcinvoice->fetch(
$remise->fk_invoice_supplier_source);
1386 $totalcostpriceofinvoice = 0;
1387 include_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmargin.class.php';
1389 $arraytmp = $formmargin->getMarginInfosArray($srcinvoice,
false);
1390 $facligne->pa_ht = $arraytmp[
'pa_total'];
1393 $facligne->total_ht = -
$remise->amount_ht;
1394 $facligne->total_tva = -
$remise->amount_tva;
1395 $facligne->total_ttc = -
$remise->amount_ttc;
1397 $facligne->multicurrency_subprice = -
$remise->multicurrency_subprice;
1398 $facligne->multicurrency_total_ht = -
$remise->multicurrency_total_ht;
1399 $facligne->multicurrency_total_tva = -
$remise->multicurrency_total_tva;
1400 $facligne->multicurrency_total_ttc = -
$remise->multicurrency_total_ttc;
1402 $lineid = $facligne->insert();
1407 $result =
$remise->link_to_invoice($lineid, 0);
1409 $this->error =
$remise->error;
1410 $this->db->rollback();
1414 $this->db->commit();
1417 $this->error = $facligne->error;
1418 $this->db->rollback();
1422 $this->error = $facligne->error;
1423 $this->db->rollback();
1427 $this->db->rollback();
1440 public function delete(
User $user, $notrigger = 0)
1446 dol_syslog(
"FactureFournisseur::delete rowid=".$rowid, LOG_DEBUG);
1453 if (!$error && !$notrigger) {
1455 $result = $this->
call_trigger(
'BILL_SUPPLIER_DELETE', $user);
1457 $this->db->rollback();
1465 $sql =
'DELETE FROM '.MAIN_DB_PREFIX.
'societe_remise_except';
1466 $sql .=
' WHERE fk_invoice_supplier_source = '.((int) $rowid);
1467 $sql .=
' AND fk_invoice_supplier_line IS NULL';
1468 $resql = $this->db->query($sql);
1472 $list_rowid_det = array();
1473 foreach ($this->lines as $key => $invoiceline) {
1474 $list_rowid_det[] = $invoiceline->id;
1478 if (count($list_rowid_det)) {
1479 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'societe_remise_except';
1480 $sql .=
' SET fk_invoice_supplier = NULL, fk_invoice_supplier_line = NULL';
1481 $sql .=
' WHERE fk_invoice_supplier_line IN ('.$this->db->sanitize(implode(
',', $list_rowid_det)).
')';
1483 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
1484 if (!$this->db->query($sql)) {
1491 $main = MAIN_DB_PREFIX.
'facture_fourn_det';
1492 $ef = $main.
"_extrafields";
1493 $sqlef =
"DELETE FROM $ef WHERE fk_object IN (SELECT rowid FROM ".$main.
" WHERE fk_facture_fourn = ".((int) $rowid).
")";
1494 $resqlef = $this->db->query($sqlef);
1495 $sql =
'DELETE FROM '.MAIN_DB_PREFIX.
'facture_fourn_det WHERE fk_facture_fourn = '.((int) $rowid);
1496 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
1497 $resql = $this->db->query($sql);
1498 if ($resqlef && $resql) {
1499 $sql =
'DELETE FROM '.MAIN_DB_PREFIX.
'facture_fourn WHERE rowid = '.((int) $rowid);
1500 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
1501 $resql2 = $this->db->query($sql);
1524 if ($conf->fournisseur->facture->dir_output) {
1525 include_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1528 $dir = $conf->fournisseur->facture->dir_output.
'/'.
get_exdir($this->
id, 2, 0, 0, $this,
'invoice_supplier').$ref;
1529 $file = $dir.
"/".$ref.
".pdf";
1530 if (file_exists($file)) {
1532 $this->error =
'ErrorFailToDeleteFile';
1536 if (file_exists($dir)) {
1540 $this->error =
'ErrorFailToDeleteDir';
1552 dol_syslog(get_class($this).
"::delete error -4 ".$this->error, LOG_ERR);
1557 dol_syslog(get_class($this).
"::delete $this->id by $user->id", LOG_DEBUG);
1558 $this->db->commit();
1561 $this->error = $this->db->lasterror();
1562 $this->db->rollback();
1579 public function set_paid($user, $close_code =
'', $close_note =
'')
1582 dol_syslog(get_class($this).
"::set_paid is deprecated, use setPaid instead", LOG_NOTICE);
1583 return $this->
setPaid($user, $close_code, $close_note);
1594 public function setPaid($user, $close_code =
'', $close_note =
'')
1598 if ($this->paid != 1) {
1603 dol_syslog(
"FactureFournisseur::setPaid", LOG_DEBUG);
1605 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'facture_fourn SET';
1606 $sql .=
' fk_statut = '.self::STATUS_CLOSED;
1611 $sql .=
", close_code='".$this->db->escape($close_code).
"'";
1614 $sql .=
", close_note='".$this->db->escape($close_note).
"'";
1616 $sql .=
', fk_user_closing = '.((int) $user->id);
1617 $sql .=
", date_closing = '".$this->db->idate($now).
"'";
1618 $sql .=
' WHERE rowid = '.((int) $this->
id);
1620 $resql = $this->db->query($sql);
1623 $result = $this->
call_trigger(
'BILL_SUPPLIER_PAYED', $user);
1630 $this->error = $this->db->error();
1635 $this->db->commit();
1638 $this->db->rollback();
1660 dol_syslog(get_class($this).
"::set_unpaid is deprecated, use setUnpaid instead", LOG_NOTICE);
1678 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'facture_fourn';
1679 $sql .=
' SET paye=0, fk_statut='.self::STATUS_VALIDATED.
', close_code=null, close_note=null,';
1680 $sql .=
' date_closing=null,';
1681 $sql .=
' fk_user_closing=null';
1682 $sql .=
' WHERE rowid = '.((int) $this->
id);
1684 dol_syslog(get_class($this).
"::set_unpaid", LOG_DEBUG);
1685 $resql = $this->db->query($sql);
1688 $result = $this->
call_trigger(
'BILL_SUPPLIER_UNPAYED', $user);
1695 $this->error = $this->db->error();
1700 $this->db->commit();
1703 $this->db->rollback();
1718 public function setCanceled($user, $close_code =
'', $close_note =
'')
1720 dol_syslog(get_class($this).
"::setCanceled rowid=".((
int) $this->
id), LOG_DEBUG);
1724 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'facture_fourn SET';
1725 $sql .=
' fk_statut='.self::STATUS_ABANDONED;
1727 $sql .=
", close_code='".$this->db->escape($close_code).
"'";
1730 $sql .=
", close_note='".$this->db->escape($close_note).
"'";
1732 $sql .=
" WHERE rowid = ".((int) $this->
id);
1734 $resql = $this->db->query($sql);
1738 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'societe_remise_except';
1739 $sql .=
' SET fk_invoice_supplier = NULL';
1740 $sql .=
' WHERE fk_invoice_supplier = '.((int) $this->
id);
1742 $resql = $this->db->query($sql);
1745 $result = $this->
call_trigger(
'BILL_SUPPLIER_CANCEL', $user);
1747 $this->db->rollback();
1752 $this->db->commit();
1755 $this->error = $this->db->error().
" sql=".$sql;
1756 $this->db->rollback();
1760 $this->error = $this->db->error().
" sql=".$sql;
1761 $this->db->rollback();
1775 public function validate($user, $force_number =
'', $idwarehouse = 0, $notrigger = 0)
1777 global $mysoc, $conf, $langs;
1779 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1784 dol_syslog(get_class($this).
'::validate user='.$user->id.
', force_number='.$force_number.
', idwarehouse='.$idwarehouse);
1791 if ($this->
status > self::STATUS_DRAFT) {
1792 dol_syslog(get_class($this).
"::validate no draft status", LOG_WARNING);
1795 if (preg_match(
'/^'.preg_quote($langs->trans(
"CopyOf").
' ').
'/', $this->ref_supplier)) {
1796 $langs->load(
"errors");
1797 $this->error = $langs->trans(
"ErrorFieldFormat", $langs->transnoentities(
"RefSupplier")).
'. '.$langs->trans(
'RemoveString', $langs->transnoentitiesnoconv(
"CopyOf"));
1800 if (count($this->lines) <= 0) {
1801 $langs->load(
"errors");
1802 $this->error = $langs->trans(
"ErrorObjectMustHaveLinesToBeValidated", $this->
ref);
1807 if (!empty($this->thirdparty) && is_object($this->thirdparty)) {
1808 $array_to_check = array(
'IDPROF1',
'IDPROF2',
'IDPROF3',
'IDPROF4',
'IDPROF5',
'IDPROF6',
'EMAIL',
'ACCOUNTANCY_CODE_SUPPLIER');
1809 foreach ($array_to_check as $key) {
1810 $keymin = strtolower($key);
1811 if ($keymin ==
'accountancy_code_supplier') {
1812 $keymin =
'code_compta_fournisseur';
1814 if (!property_exists($this->thirdparty, $keymin)) {
1817 $vallabel = $this->thirdparty->$keymin;
1819 $i = (int) preg_replace(
'/[^0-9]/',
'', $key);
1821 if ($this->thirdparty->isACompany()) {
1823 if ($mysoc->country_id > 0 && $this->thirdparty->country_id == $mysoc->country_id) {
1824 $idprof_mandatory =
'SOCIETE_'.$key.
'_INVOICE_MANDATORY';
1826 $langs->load(
"errors");
1827 $this->error = $langs->trans(
'ErrorProdIdIsMandatory', $langs->transcountry(
'ProfId'.$i, $this->thirdparty->country_code)).
' ('.$langs->trans(
"ForbiddenBySetupRules").
') ['.$langs->trans(
'Company').
' : '.$this->thirdparty->name.
']';
1828 dol_syslog(__METHOD__.
' '.$this->error, LOG_ERR);
1834 if ($key ==
'EMAIL') {
1837 $langs->load(
"errors");
1838 $this->error = $langs->trans(
"ErrorBadEMail", $this->thirdparty->email).
' ('.$langs->trans(
"ForbiddenBySetupRules").
') ['.$langs->trans(
'Company').
' : '.$this->thirdparty->name.
']';
1839 dol_syslog(__METHOD__.
' '.$this->error, LOG_ERR);
1842 } elseif ($key ==
'ACCOUNTANCY_CODE_SUPPLIER') {
1844 if (
getDolGlobalString(
'SOCIETE_ACCOUNTANCY_CODE_SUPPLIER_INVOICE_MANDATORY') && empty($this->thirdparty->code_compta_fournisseur)) {
1845 $langs->load(
"errors");
1846 $this->error = $langs->trans(
"ErrorAccountancyCodeSupplierIsMandatory", $this->thirdparty->name).
' ('.$langs->trans(
"ForbiddenBySetupRules").
')';
1847 dol_syslog(__METHOD__.
' '.$this->error, LOG_ERR);
1858 if ($force_number) {
1859 $num = $force_number;
1860 } elseif (preg_match(
'/^[\(]?PROV/i', $this->
ref) || empty($this->
ref)) {
1867 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"facture_fourn";
1868 $sql .=
" SET ref='".$this->db->escape($num).
"', fk_statut = 1, fk_user_valid = ".((int) $user->id).
", date_valid = '".$this->db->idate($now).
"'";
1869 $sql .=
" WHERE rowid = ".((int) $this->
id);
1871 dol_syslog(get_class($this).
"::validate", LOG_DEBUG);
1872 $resql = $this->db->query($sql);
1875 if (!$error && isModEnabled(
'stock') &&
getDolGlobalString(
'STOCK_CALCULATE_ON_SUPPLIER_BILL')) {
1876 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
1877 $langs->load(
"agenda");
1879 $cpt = count($this->lines);
1880 for ($i = 0; $i < $cpt; $i++) {
1881 if ($this->lines[$i]->fk_product > 0) {
1883 $mouvP->origin = &$this;
1884 $mouvP->setOrigin($this->element, $this->
id);
1886 $up_ht_disc = $this->lines[$i]->subprice;
1887 if (!empty($this->lines[$i]->remise_percent) && !
getDolGlobalString(
'STOCK_EXCLUDE_DISCOUNT_FOR_PMP')) {
1888 $up_ht_disc =
price2num($up_ht_disc * (100 - $this->lines[$i]->remise_percent) / 100,
'MU');
1891 $result = $mouvP->livraison($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, $up_ht_disc, $langs->trans(
"InvoiceValidatedInDolibarr", $num));
1893 $result = $mouvP->reception($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, $up_ht_disc, $langs->trans(
"InvoiceValidatedInDolibarr", $num));
1896 $this->error = $mouvP->error;
1897 if (count($mouvP->errors)) {
1898 $this->errors = $mouvP->errors;
1907 if (!$error && empty($notrigger)) {
1909 $result = $this->
call_trigger(
'BILL_SUPPLIER_VALIDATE', $user);
1917 $this->oldref = $this->ref;
1920 if (preg_match(
'/^[\(]?PROV/i', $this->
ref)) {
1922 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filename = CONCAT('".$this->db->escape($this->newref).
"', SUBSTR(filename, ".(strlen($this->
ref) + 1).
")), filepath = 'fournisseur/facture/".
get_exdir($this->
id, 2, 0, 0, $this,
'invoice_supplier').$this->db->escape($this->newref).
"'";
1923 $sql .=
" WHERE filename LIKE '".$this->db->escape($this->
ref).
"%' AND filepath = 'fournisseur/facture/".
get_exdir($this->
id, 2, 0, 0, $this,
'invoice_supplier').$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
1924 $resql = $this->db->query($sql);
1927 $this->error = $this->db->lasterror();
1929 $sql =
'UPDATE '.MAIN_DB_PREFIX.
"ecm_files set filepath = 'fournisseur/facture/".
get_exdir($this->
id, 2, 0, 0, $this,
'invoice_supplier').$this->db->escape($this->newref).
"'";
1930 $sql .=
" WHERE filepath = 'fournisseur/facture/".get_exdir($this->
id, 2, 0, 0, $this,
'invoice_supplier').$this->db->escape($this->
ref).
"' and entity = ".$conf->entity;
1931 $resql = $this->db->query($sql);
1934 $this->error = $this->db->lasterror();
1939 $dirsource = $conf->fournisseur->facture->dir_output.
'/'.
get_exdir($this->
id, 2, 0, 0, $this,
'invoice_supplier').$oldref;
1940 $dirdest = $conf->fournisseur->facture->dir_output.
'/'.
get_exdir($this->
id, 2, 0, 0, $this,
'invoice_supplier').$this->newref;
1941 if (!$error && file_exists($dirsource)) {
1942 dol_syslog(get_class($this).
"::validate rename dir ".$dirsource.
" into ".$dirdest);
1944 if (@rename($dirsource, $dirdest)) {
1947 $listoffiles =
dol_dir_list($conf->fournisseur->facture->dir_output.
'/'.
get_exdir($this->
id, 2, 0, 0, $this,
'invoice_supplier').$this->newref,
'files', 1,
'^'.preg_quote($oldref,
'/'));
1948 foreach ($listoffiles as $fileentry) {
1949 $dirsource = $fileentry[
'name'];
1950 $dirdest = preg_replace(
'/^'.preg_quote($oldref,
'/').
'/', $this->newref, $dirsource);
1951 $dirsource = $fileentry[
'path'].
'/'.$dirsource;
1952 $dirdest = $fileentry[
'path'].
'/'.$dirdest;
1953 @rename($dirsource, $dirdest);
1962 $this->
ref = $this->newref;
1969 $this->db->commit();
1972 $this->db->rollback();
1976 $this->error = $this->db->error();
1977 $this->db->rollback();
1990 public function setDraft($user, $idwarehouse = -1, $notrigger = 0)
1993 global $conf, $langs;
1997 if ($this->
status == self::STATUS_DRAFT) {
1998 dol_syslog(__METHOD__.
" already draft status", LOG_WARNING);
2006 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"facture_fourn";
2007 $sql .=
" SET fk_statut = ".self::STATUS_DRAFT;
2008 $sql .=
" WHERE rowid = ".((int) $this->
id);
2010 $result = $this->db->query($sql);
2013 $this->oldcopy = clone $this;
2017 if ($result >= 0 && isModEnabled(
'stock') &&
getDolGlobalString(
'STOCK_CALCULATE_ON_SUPPLIER_BILL')) {
2018 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/mouvementstock.class.php';
2019 $langs->load(
"agenda");
2021 $cpt = count($this->lines);
2022 for ($i = 0; $i < $cpt; $i++) {
2023 if ($this->lines[$i]->fk_product > 0) {
2025 $mouvP->origin = &$this;
2026 $mouvP->setOrigin($this->element, $this->
id);
2029 $result = $mouvP->reception($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, $this->lines[$i]->subprice, $langs->trans(
"InvoiceBackToDraftInDolibarr", $this->ref));
2031 $result = $mouvP->livraison($user, $this->lines[$i]->fk_product, $idwarehouse, $this->lines[$i]->qty, $this->lines[$i]->subprice, $langs->trans(
"InvoiceBackToDraftInDolibarr", $this->ref));
2037 if (!$error && empty($notrigger)) {
2039 $result = $this->
call_trigger(
'BILL_SUPPLIER_UNVALIDATE', $user);
2046 $this->db->commit();
2049 $this->db->rollback();
2053 $this->error = $this->db->error();
2054 $this->db->rollback();
2093 public function addline($desc, $pu, $txtva, $txlocaltax1, $txlocaltax2, $qty, $fk_product = 0, $remise_percent = 0, $date_start = 0, $date_end = 0, $fk_code_ventilation = 0, $info_bits = 0, $price_base_type =
'HT', $type = 0, $rang = -1, $notrigger = 0, $array_options = [], $fk_unit =
null, $origin_id = 0, $pu_devise = 0, $ref_supplier =
'', $special_code = 0, $fk_parent_line = 0, $fk_remise_except = 0)
2095 global $langs, $mysoc;
2097 dol_syslog(get_class($this).
"::addline $desc,$pu,$qty,$txtva,$fk_product,$remise_percent,$date_start,$date_end,$fk_code_ventilation,$info_bits,$price_base_type,$type,$fk_unit,fk_remise_except=$fk_remise_except", LOG_DEBUG);
2098 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
2100 if ($this->
status == self::STATUS_DRAFT) {
2102 if (empty($remise_percent)) {
2103 $remise_percent = 0;
2108 if (empty($info_bits)) {
2114 if (empty($fk_code_ventilation)) {
2115 $fk_code_ventilation = 0;
2117 if (empty($txtva)) {
2120 if (empty($txlocaltax1)) {
2123 if (empty($txlocaltax2)) {
2127 $remise_percent =
price2num($remise_percent);
2130 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
2136 if ($date_start && $date_end && $date_start > $date_end) {
2137 $langs->load(
"errors");
2138 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
2144 if ($fk_product > 0) {
2147 dol_syslog(get_class($this).
"::addline we check supplier prices fk_product=".$fk_product.
" qty=".$qty.
" ref_supplier=".$ref_supplier);
2149 if ($prod->fetch($fk_product) > 0) {
2150 $product_type = $prod->type;
2151 $label = $prod->label;
2152 $fk_prod_fourn_price = 0;
2156 $result = $prod->get_buyprice($fk_prod_fourn_price, $qty, $fk_product,
'none', ($this->fk_soc ? $this->fk_soc : $this->socid));
2159 $pu = $prod->fourn_pu;
2161 $ref_supplier = $prod->ref_supplier;
2163 if ($remise_percent == 0 && $prod->remise_percent != 0) {
2164 $remise_percent = $prod->remise_percent;
2168 $langs->load(
"errors");
2169 $this->error =
"Ref ".$prod->ref.
" ".$langs->trans(
"ErrorQtyTooLowForThisSupplier");
2170 $this->db->rollback();
2171 dol_syslog(get_class($this).
"::addline we did not found supplier price, so we can't guess unit price");
2176 if ($result == -1) {
2177 $langs->load(
"errors");
2178 $this->error =
"Ref ".$prod->ref.
" ".$langs->trans(
"ErrorQtyTooLowForThisSupplier");
2179 $this->db->rollback();
2180 dol_syslog(get_class($this).
"::addline result=".$result.
" - ".$this->error, LOG_DEBUG);
2184 $this->error = $prod->error;
2185 $this->db->rollback();
2186 dol_syslog(get_class($this).
"::addline result=".$result.
" - ".$this->error, LOG_ERR);
2190 $this->error = $prod->error;
2191 $this->db->rollback();
2196 $product_type = $type;
2199 if (isModEnabled(
"multicurrency") && $pu_devise > 0) {
2208 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
2209 $vat_src_code = $reg[1];
2210 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
2218 $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_devise);
2219 $total_ht = $tabprice[0];
2220 $total_tva = $tabprice[1];
2221 $total_ttc = $tabprice[2];
2222 $total_localtax1 = $tabprice[9];
2223 $total_localtax2 = $tabprice[10];
2224 $pu_ht = $tabprice[3];
2227 $multicurrency_total_ht = $tabprice[16];
2228 $multicurrency_total_tva = $tabprice[17];
2229 $multicurrency_total_ttc = $tabprice[18];
2230 $pu_ht_devise = $tabprice[19];
2239 $rang = $rangmax + 1;
2245 $supplierinvoiceline->context = $this->context;
2247 $supplierinvoiceline->fk_facture_fourn = $this->id;
2249 $supplierinvoiceline->desc = $desc;
2250 $supplierinvoiceline->ref_supplier = $ref_supplier;
2252 $supplierinvoiceline->qty = ($this->
type == self::TYPE_CREDIT_NOTE ? abs((
float) $qty) : $qty);
2253 $supplierinvoiceline->subprice = ($this->
type == self::TYPE_CREDIT_NOTE ? -abs($pu_ht) : $pu_ht);
2255 $supplierinvoiceline->vat_src_code = $vat_src_code;
2256 $supplierinvoiceline->tva_tx = $txtva;
2257 $supplierinvoiceline->localtax1_tx = ($total_localtax1 ? $localtaxes_type[1] : 0);
2258 $supplierinvoiceline->localtax2_tx = ($total_localtax2 ? $localtaxes_type[3] : 0);
2259 $supplierinvoiceline->localtax1_type = empty($localtaxes_type[0]) ? 0 : $localtaxes_type[0];
2260 $supplierinvoiceline->localtax2_type = empty($localtaxes_type[2]) ? 0 : $localtaxes_type[2];
2262 $supplierinvoiceline->total_ht = (($this->
type == self::TYPE_CREDIT_NOTE || $qty < 0) ? -abs($total_ht) : $total_ht);
2263 $supplierinvoiceline->total_tva = (($this->
type == self::TYPE_CREDIT_NOTE || $qty < 0) ? -abs($total_tva) : $total_tva);
2264 $supplierinvoiceline->total_localtax1 = (($this->
type == self::TYPE_CREDIT_NOTE || $qty < 0) ? -abs($total_localtax1) : $total_localtax1);
2265 $supplierinvoiceline->total_localtax2 = (($this->
type == self::TYPE_CREDIT_NOTE || $qty < 0) ? -abs($total_localtax2) : $total_localtax2);
2266 $supplierinvoiceline->total_ttc = (($this->
type == self::TYPE_CREDIT_NOTE || $qty < 0) ? -abs($total_ttc) : $total_ttc);
2268 $supplierinvoiceline->fk_product = $fk_product;
2269 $supplierinvoiceline->product_type = $type;
2270 $supplierinvoiceline->remise_percent = $remise_percent;
2271 $supplierinvoiceline->date_start = $date_start;
2272 $supplierinvoiceline->date_end = $date_end;
2273 $supplierinvoiceline->fk_code_ventilation = $fk_code_ventilation;
2274 $supplierinvoiceline->rang = $rang;
2275 $supplierinvoiceline->info_bits = $info_bits;
2276 $supplierinvoiceline->fk_remise_except = $fk_remise_except;
2279 $supplierinvoiceline->special_code = (int) $special_code;
2280 $supplierinvoiceline->fk_parent_line = $fk_parent_line;
2281 $supplierinvoiceline->origin = $this->origin;
2282 $supplierinvoiceline->origin_id = $origin_id;
2283 $supplierinvoiceline->fk_unit = $fk_unit;
2286 $supplierinvoiceline->fk_multicurrency = $this->fk_multicurrency;
2287 $supplierinvoiceline->multicurrency_code = $this->multicurrency_code;
2288 $supplierinvoiceline->multicurrency_subprice = ($this->
type == self::TYPE_CREDIT_NOTE ? -abs($pu_ht_devise) : $pu_ht_devise);
2290 $supplierinvoiceline->multicurrency_total_ht = (($this->
type == self::TYPE_CREDIT_NOTE || $qty < 0) ? -abs($multicurrency_total_ht) : $multicurrency_total_ht);
2291 $supplierinvoiceline->multicurrency_total_tva = (($this->
type == self::TYPE_CREDIT_NOTE || $qty < 0) ? -abs($multicurrency_total_tva) : $multicurrency_total_tva);
2292 $supplierinvoiceline->multicurrency_total_ttc = (($this->
type == self::TYPE_CREDIT_NOTE || $qty < 0) ? -abs($multicurrency_total_ttc) : $multicurrency_total_ttc);
2294 if (is_array($array_options) && count($array_options) > 0) {
2295 $supplierinvoiceline->array_options = $array_options;
2298 $result = $supplierinvoiceline->insert($notrigger);
2301 if (!empty($fk_parent_line)) {
2303 } elseif ($rang > 0 && $rang <= count($this->lines)) {
2304 $linecount = count($this->lines);
2305 for ($ii = $rang; $ii <= $linecount; $ii++) {
2311 $result = $this->
update_price(1,
'auto', 0, $this->thirdparty);
2313 $this->db->commit();
2314 return $supplierinvoiceline->id;
2316 $this->error = $this->db->error();
2317 $this->db->rollback();
2321 $this->error = $supplierinvoiceline->error;
2322 $this->errors = $supplierinvoiceline->errors;
2323 $this->db->rollback();
2356 public function updateline($id, $desc, $pu, $vatrate, $txlocaltax1 = 0, $txlocaltax2 = 0, $qty = 1, $idproduct = 0, $price_base_type =
'HT', $info_bits = 0, $type = 0, $remise_percent = 0, $notrigger = 0, $date_start =
'', $date_end =
'', $array_options = [], $fk_unit =
null, $pu_devise = 0, $ref_supplier =
'', $rang = 0)
2358 global $mysoc, $langs;
2360 dol_syslog(get_class($this).
"::updateline $id,$desc,$pu,$vatrate,$qty,$idproduct,$price_base_type,$info_bits,$type,$remise_percent,$notrigger,$date_start,$date_end,$fk_unit,$pu_devise,$ref_supplier", LOG_DEBUG);
2361 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
2365 $remise_percent = (float)
price2num($remise_percent);
2374 if ($date_start && $date_end && $date_start > $date_end) {
2375 $langs->load(
"errors");
2376 $this->error = $langs->trans(
'ErrorStartDateGreaterEnd');
2381 if (empty($vatrate)) {
2384 if (empty($txlocaltax1)) {
2387 if (empty($txlocaltax2)) {
2391 $txlocaltax1 = (float)
price2num($txlocaltax1);
2392 $txlocaltax2 = (float)
price2num($txlocaltax2);
2405 if (preg_match(
'/\((.*)\)/', (
string) $vatrate, $reg)) {
2406 $vat_src_code = $reg[1];
2407 $vatrate = preg_replace(
'/\s*\(.*\)/',
'', (
string) $vatrate);
2410 $tabprice =
calcul_price_total($qty, $pu, $remise_percent, $vatrate, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $type, $this->thirdparty, $localtaxes_type, 100, $this->multicurrency_tx, $pu_devise);
2411 $total_ht = $tabprice[0];
2412 $total_tva = $tabprice[1];
2413 $total_ttc = $tabprice[2];
2414 $pu_ht = $tabprice[3];
2415 $pu_tva = $tabprice[4];
2416 $pu_ttc = $tabprice[5];
2417 $total_localtax1 = $tabprice[9];
2418 $total_localtax2 = $tabprice[10];
2421 $multicurrency_total_ht = $tabprice[16];
2422 $multicurrency_total_tva = $tabprice[17];
2423 $multicurrency_total_ttc = $tabprice[18];
2424 $pu_ht_devise = $tabprice[19];
2426 if (empty($info_bits)) {
2433 $line->fetch_optionals();
2435 $staticline = clone $line;
2438 $product =
new Product($this->db);
2439 $result = $product->fetch($idproduct);
2440 $product_type = $product->type;
2442 $idproduct = $staticline->fk_product;
2443 $product_type = $type;
2446 $line->oldline = $staticline;
2447 $line->context = $this->context;
2449 $line->description = $desc;
2450 $line->desc = $desc;
2452 $line->qty = ($this->
type == self::TYPE_CREDIT_NOTE ? abs((
float) $qty) : $qty);
2453 $line->subprice = ($this->
type == self::TYPE_CREDIT_NOTE ? -abs($pu_ht) : $pu_ht);
2454 $line->pu_ht = $line->subprice;
2455 $line->pu_ttc = ($this->
type == self::TYPE_CREDIT_NOTE ? -abs($pu_ttc) : $pu_ttc);
2457 $line->remise_percent = $remise_percent;
2458 $line->ref_supplier = $ref_supplier;
2460 $line->date_start = $date_start;
2461 $line->date_end = $date_end;
2463 $line->vat_src_code = $vat_src_code;
2464 $line->tva_tx = $vatrate;
2465 $line->localtax1_tx = $txlocaltax1;
2466 $line->localtax2_tx = $txlocaltax2;
2467 $line->localtax1_type = empty($localtaxes_type[0]) ? 0 : $localtaxes_type[0];
2468 $line->localtax2_type = empty($localtaxes_type[2]) ? 0 : $localtaxes_type[2];
2470 $line->total_ht = (($this->
type == self::TYPE_CREDIT_NOTE || $qty < 0) ? -abs($total_ht) : $total_ht);
2471 $line->total_tva = (($this->
type == self::TYPE_CREDIT_NOTE || $qty < 0) ? -abs($total_tva) : $total_tva);
2472 $line->total_localtax1 = $total_localtax1;
2473 $line->total_localtax2 = $total_localtax2;
2474 $line->total_ttc = (($this->
type == self::TYPE_CREDIT_NOTE || $qty < 0) ? -abs($total_ttc) : $total_ttc);
2476 $line->fk_product = $idproduct;
2477 $line->product_type = $product_type;
2478 $line->info_bits = $info_bits;
2479 $line->fk_unit = $fk_unit;
2480 $line->rang = $rang;
2482 if (is_array($array_options) && count($array_options) > 0) {
2484 foreach ($array_options as $key => $value) {
2485 $line->array_options[$key] = $array_options[$key];
2490 $line->multicurrency_subprice = $pu_ht_devise;
2491 $line->multicurrency_total_ht = $multicurrency_total_ht;
2492 $line->multicurrency_total_tva = $multicurrency_total_tva;
2493 $line->multicurrency_total_ttc = $multicurrency_total_ttc;
2495 $res = $line->update($notrigger);
2498 $this->errors[] = $line->error;
2499 $this->errors = array_merge($this->errors, $line->errors);
2502 $res = $this->
update_price(
'1',
'auto', 0, $this->thirdparty);
2524 $sql =
'UPDATE '.MAIN_DB_PREFIX.
'societe_remise_except';
2525 $sql .=
' SET fk_invoice_supplier_line = NULL';
2526 $sql .=
' WHERE fk_invoice_supplier_line = '.((int) $rowid);
2528 dol_syslog(get_class($this).
"::deleteline", LOG_DEBUG);
2529 $result = $this->db->query($sql);
2531 $this->error = $this->db->error();
2532 $this->db->rollback();
2538 if ($line->fetch($rowid) < 1) {
2542 $res = $line->delete($notrigger);
2545 $this->errors[] = $line->error;
2546 $this->db->rollback();
2552 $this->db->commit();
2555 $this->db->rollback();
2556 $this->error = $this->db->lasterror();
2571 $sql =
'SELECT c.rowid, datec, tms as datem, ';
2572 $sql .=
' fk_user_author, fk_user_modif, fk_user_valid';
2573 $sql .=
' FROM '.MAIN_DB_PREFIX.
'facture_fourn as c';
2574 $sql .=
' WHERE c.rowid = '.((int) $id);
2576 $result = $this->db->query($sql);
2578 if ($this->db->num_rows($result)) {
2579 $obj = $this->db->fetch_object($result);
2581 $this->
id = $obj->rowid;
2583 $this->user_creation_id = $obj->fk_user_author;
2584 $this->user_validation_id = $obj->fk_user_valid;
2585 $this->user_modification_id = $obj->fk_user_modif;
2586 $this->date_creation = $this->db->jdate($obj->datec);
2587 $this->date_modification = $this->db->jdate($obj->datem);
2590 $this->db->free($result);
2612 $sql =
"SELECT f.rowid as rowid, f.ref, f.fk_statut,";
2613 $sql .=
" ff.rowid as rowidnext";
2614 $sql .=
" FROM ".MAIN_DB_PREFIX.
"facture_fourn as f";
2615 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"paiementfourn_facturefourn as pf ON f.rowid = pf.fk_facturefourn";
2616 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"facture_fourn as ff ON f.rowid = ff.fk_facture_source";
2617 $sql .=
" WHERE (f.fk_statut = ".self::STATUS_VALIDATED.
" OR (f.fk_statut = ".self::STATUS_ABANDONED.
" AND f.close_code = '".self::CLOSECODE_ABANDONED.
"'))";
2618 $sql .=
" AND f.entity = ".$conf->entity;
2619 $sql .=
" AND f.paye = 0";
2620 $sql .=
" AND pf.fk_paiementfourn IS NULL";
2621 $sql .=
" AND ff.fk_statut IS NULL";
2623 $sql .=
" AND f.fk_soc = ".((int) $socid);
2625 $sql .=
" ORDER BY f.ref";
2627 dol_syslog(get_class($this).
"::list_replacable_supplier_invoices", LOG_DEBUG);
2628 $resql = $this->db->query($sql);
2630 while ($obj = $this->db->fetch_object($resql)) {
2631 $return[$obj->rowid] = array(
2632 'id' => $obj->rowid,
2634 'status' => $obj->fk_statut
2640 $this->error = $this->db->error();
2662 $sql =
"SELECT f.rowid as rowid, f.ref, f.fk_statut, f.type, f.subtype, f.paye, pf.fk_paiementfourn";
2663 $sql .=
" FROM ".MAIN_DB_PREFIX.
"facture_fourn as f";
2664 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"paiementfourn_facturefourn as pf ON f.rowid = pf.fk_facturefourn";
2665 $sql .=
" WHERE f.entity = ".$conf->entity;
2666 $sql .=
" AND f.fk_statut in (".self::STATUS_VALIDATED.
",".self::STATUS_CLOSED.
")";
2667 $sql .=
" AND NOT EXISTS (SELECT rowid from ".MAIN_DB_PREFIX.
"facture_fourn as ff WHERE f.rowid = ff.fk_facture_source";
2668 $sql .=
" AND ff.type=".self::TYPE_REPLACEMENT.
")";
2669 $sql .=
" AND f.type != ".self::TYPE_CREDIT_NOTE;
2671 $sql .=
" AND f.fk_soc = ".((int) $socid);
2673 $sql .=
" ORDER BY f.ref";
2675 dol_syslog(get_class($this).
"::list_qualified_avoir_supplier_invoices", LOG_DEBUG);
2676 $resql = $this->db->query($sql);
2678 while ($obj = $this->db->fetch_object($resql)) {
2680 if ($obj->fk_statut == self::STATUS_VALIDATED) {
2683 if ($obj->fk_statut == self::STATUS_CLOSED) {
2687 $paymentornot = ($obj->fk_paiementfourn ? 1 : 0);
2688 $return[$obj->rowid] = array(
'ref' => $obj->ref,
'status' => $obj->fk_statut,
'type' => $obj->type,
'paye' => $obj->paye,
'paymentornot' => $paymentornot);
2694 $this->error = $this->db->error();
2709 global $conf, $langs;
2711 $sql =
'SELECT ff.rowid, ff.date_lim_reglement as datefin, ff.fk_statut as status, ff.total_ht, ff.total_ttc';
2712 $sql .=
' FROM '.MAIN_DB_PREFIX.
'facture_fourn as ff';
2713 if (empty($user->socid) && !$user->hasRight(
"societe",
"client",
"voir")) {
2714 $sql .=
" JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON ff.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
2716 $sql .=
' WHERE ff.paye = 0';
2717 $sql .=
" AND ff.fk_statut IN (".self::STATUS_VALIDATED.
")";
2718 $sql .=
" AND ff.entity = ".$conf->entity;
2720 $sql .=
' AND ff.fk_soc = '.((int) $user->socid);
2723 $resql = $this->db->query($sql);
2725 $langs->load(
"bills");
2729 $response->warning_delay = $conf->facture->fournisseur->warning_delay / 60 / 60 / 24;
2730 $response->label = $langs->trans(
"SupplierBillsToPay");
2731 $response->labelShort = $langs->trans(
"StatusToPay");
2733 $response->url = DOL_URL_ROOT.
'/fourn/facture/list.php?search_status=1&mainmenu=billing&leftmenu=suppliers_bills';
2734 $response->img =
img_object($langs->trans(
"Bills"),
"bill");
2738 while ($obj = $this->db->fetch_object($resql)) {
2739 $facturestatic->date_echeance = $this->db->jdate($obj->datefin);
2740 $facturestatic->statut = $obj->status;
2741 $facturestatic->status = $obj->status;
2743 $response->nbtodo++;
2744 $response->total += $obj->total_ht;
2746 if ($facturestatic->hasDelay()) {
2747 $response->nbtodolate++;
2748 $response->url_late = DOL_URL_ROOT.
'/fourn/facture/list.php?search_option=late&mainmenu=billing&leftmenu=suppliers_bills';
2752 $this->db->free($resql);
2756 $this->error = $this->db->error();
2770 global $conf, $langs, $mysoc;
2772 $langs->load(
'bills');
2775 $moretitle = $params[
'moretitle'] ??
'';
2777 $picto = $this->picto;
2778 if ($this->
type == self::TYPE_REPLACEMENT) {
2781 if ($this->
type == self::TYPE_CREDIT_NOTE) {
2784 if ($this->
type == self::TYPE_DEPOSIT) {
2788 $datas[
'picto'] =
img_picto(
'', $picto).
' <u class="paddingrightonly">'.$langs->trans(
"SupplierInvoice").
'</u>';
2789 if ($this->
type == self::TYPE_REPLACEMENT) {
2790 $datas[
'picto'] .=
'<u class="paddingrightonly">'.$langs->transnoentitiesnoconv(
"InvoiceReplace").
'</u>';
2791 } elseif ($this->
type == self::TYPE_CREDIT_NOTE) {
2792 $datas[
'picto'] .=
'<u class="paddingrightonly">'.$langs->transnoentitiesnoconv(
"CreditNote").
'</u>';
2793 } elseif ($this->
type == self::TYPE_DEPOSIT) {
2794 $datas[
'picto'] .=
'<u class="paddingrightonly">'.$langs->transnoentitiesnoconv(
"Deposit").
'</u>';
2796 if (isset($this->
status)) {
2798 if (isset($this->alreadypaid)) {
2799 $alreadypaid = $this->alreadypaid;
2802 $datas[
'picto'] .=
' '.$this->getLibStatut(5, $alreadypaid);
2805 $datas[
'picto'] .=
' - '.$moretitle;
2807 if (!empty($this->
ref)) {
2808 $datas[
'ref'] =
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
2810 if (!empty($this->ref_supplier)) {
2811 $datas[
'refsupplier'] =
'<br><b>'.$langs->trans(
'RefSupplier').
':</b> '.$this->ref_supplier;
2813 if (!empty($this->label)) {
2814 $datas[
'label'] =
'<br><b>'.$langs->trans(
'Label').
':</b> '.$this->label;
2816 if (!empty($this->date)) {
2817 $datas[
'date'] =
'<br><b>'.$langs->trans(
'Date').
':</b> '.
dol_print_date($this->date,
'day');
2819 if (!empty($this->date_echeance)) {
2820 $datas[
'date_echeance'] =
'<br><b>'.$langs->trans(
'DateDue').
':</b> '.
dol_print_date($this->date_echeance,
'day');
2822 if (!empty($this->total_ht)) {
2823 $datas[
'amountht'] =
'<br><b>'.$langs->trans(
'AmountHT').
':</b> '.
price($this->total_ht, 0, $langs, 0, -1, -1, $conf->currency);
2825 if (!empty($this->total_tva)) {
2826 $datas[
'totaltva'] =
'<br><b>'.$langs->trans(
'AmountVAT').
':</b> '.
price($this->total_tva, 0, $langs, 0, -1, -1, $conf->currency);
2828 if (!empty($this->total_localtax1) && $this->total_localtax1 != 0) {
2830 $datas[
'amountlt1'] =
'<br><b>'.$langs->transcountry(
'AmountLT1', $mysoc->country_code).
':</b> '.
price($this->total_localtax1, 0, $langs, 0, -1, -1, $conf->currency);
2832 if (!empty($this->total_localtax2) && $this->total_localtax2 != 0) {
2833 $datas[
'amountlt2'] =
'<br><b>'.$langs->transcountry(
'AmountLT2', $mysoc->country_code).
':</b> '.
price($this->total_localtax2, 0, $langs, 0, -1, -1, $conf->currency);
2835 if (!empty($this->revenuestamp)) {
2836 $datas[
'amountrevenustamp'] =
'<br><b>'.$langs->trans(
'RevenueStamp').
':</b> '.
price($this->revenuestamp, 0, $langs, 0, -1, -1, $conf->currency);
2838 if (!empty($this->total_ttc)) {
2839 $datas[
'totalttc'] =
'<br><b>'.$langs->trans(
'AmountTTC').
':</b> '.
price($this->total_ttc, 0, $langs, 0, -1, -1, $conf->currency);
2857 public function getNomUrl($withpicto = 0, $option =
'', $max = 0, $short = 0, $moretitle =
'', $notooltip = 0, $save_lastsearch_value = -1, $addlinktonotes = 0)
2859 global $langs, $conf, $user, $hookmanager;
2863 if ($option ==
'withdraw') {
2864 $url = DOL_URL_ROOT.
'/compta/facture/prelevement.php?facid='.$this->
id.
'&type=bank-transfer';
2865 } elseif ($option ==
'document') {
2866 $url = DOL_URL_ROOT.
'/fourn/facture/document.php?facid='.$this->id;
2868 $url = DOL_URL_ROOT.
'/fourn/facture/card.php?facid='.$this->id;
2875 if ($option !==
'nolink') {
2877 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
2878 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
2879 $add_save_lastsearch_values = 1;
2881 if ($add_save_lastsearch_values) {
2882 $url .=
'&save_lastsearch_values=1';
2886 $picto = $this->picto;
2887 if ($this->
type == self::TYPE_REPLACEMENT) {
2890 if ($this->
type == self::TYPE_CREDIT_NOTE) {
2893 if ($this->
type == self::TYPE_DEPOSIT) {
2899 'objecttype' => $this->element,
2900 'option' => $option,
2901 'moretitle' => $moretitle,
2903 $classfortooltip =
'classfortooltip';
2906 $classfortooltip =
'classforajaxtooltip';
2907 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
2919 if (empty($notooltip)) {
2921 $label = $langs->trans(
"ShowSupplierInvoice");
2922 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1).
'"';
2924 $linkclose .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
2925 $linkclose .= $dataparams.
' class="'.$classfortooltip.
'"';
2928 $linkstart =
'<a href="'.$url.
'"';
2929 $linkstart .= $linkclose.
'>';
2932 $result .= $linkstart;
2934 $result .=
img_object(($notooltip ?
'' : $label), ($picto ? $picto :
'generic'), ($notooltip ? (($withpicto != 2) ?
'class="paddingright"' :
'') :
'class="'.(($withpicto != 2) ?
'paddingright ' :
'').
'"'), 0, 0, $notooltip ? 0 : 1);
2936 if ($withpicto != 2) {
2937 $result .= ($max ?
dol_trunc($ref, $max) : $ref);
2939 $result .= $linkend;
2941 if ($addlinktonotes) {
2942 $txttoshow = ($user->socid > 0 ? $this->note_public : $this->note_private);
2945 $result .=
' <span class="note inline-block">';
2946 $result .=
'<a href="'.DOL_URL_ROOT.
'/fourn/facture/note.php?id='.$this->
id.
'" class="classfortooltip" title="'.
dol_escape_htmltag($notetoshow).
'">';
2949 $result .=
'</span>';
2953 $hookmanager->initHooks(array($this->element .
'dao'));
2954 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
2955 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
2957 $result = $hookmanager->resPrint;
2959 $result .= $hookmanager->resPrint;
2974 global $db, $langs, $conf;
2975 $langs->load(
"orders");
2979 $conf->global->INVOICE_SUPPLIER_ADDON_NUMBER =
'mod_facture_fournisseur_cactus';
2988 $dirmodels = array_merge(array(
'/'), (array) $conf->modules_parts[
'models']);
2990 foreach ($dirmodels as $reldir) {
2991 $dir =
dol_buildpath($reldir.
"core/modules/supplier_invoice/");
2994 $mybool = ((bool) @include_once $dir.$file) || $mybool;
3002 $obj =
new $classname();
3003 '@phan-var-force ModeleNumRefSuppliersInvoices $obj';
3005 $numref = $obj->getNextValue($soc, $this, $mode);
3007 if ($numref !=
"") {
3010 $this->error = $obj->error;
3026 global $langs, $conf;
3027 include_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
3035 $sql =
"SELECT rowid";
3036 $sql .=
" FROM ".MAIN_DB_PREFIX.
"product";
3037 $sql .=
" WHERE entity IN (".getEntity(
'product').
")";
3038 $sql .= $this->db->plimit(100);
3040 $resql = $this->db->query($sql);
3042 $num_prods = $this->db->num_rows($resql);
3044 while ($i < $num_prods) {
3046 $row = $this->db->fetch_row($resql);
3047 $prodids[$i] = $row[0];
3053 $this->
ref =
'SPECIMEN';
3054 $this->ref_supplier =
'SUPPLIER_REF_SPECIMEN';
3055 $this->specimen = 1;
3058 $this->date_lim_reglement = $this->date + 3600 * 24 * 30;
3059 $this->cond_reglement_code =
'RECEP';
3060 $this->mode_reglement_code =
'CHQ';
3062 $this->note_public =
'This is a comment (public)';
3063 $this->note_private =
'This is a comment (private)';
3065 $this->multicurrency_tx = 1;
3066 $this->multicurrency_code = $conf->currency;
3069 if (empty($option) || $option !=
'nolines') {
3072 while ($xnbp < $nbp) {
3074 $line->desc = $langs->trans(
"Description").
" ".$xnbp;
3076 $line->subprice = 100;
3077 $line->pu_ht = $line->subprice;
3079 $line->tva_tx = 19.6;
3080 $line->localtax1_tx = 0;
3081 $line->localtax2_tx = 0;
3083 $line->total_ht = 50;
3084 $line->total_ttc = 59.8;
3085 $line->total_tva = 9.8;
3086 $line->remise_percent = 50;
3088 $line->total_ht = 100;
3089 $line->total_ttc = 119.6;
3090 $line->total_tva = 19.6;
3091 $line->remise_percent = 0;
3094 if ($num_prods > 0) {
3095 $prodid = mt_rand(1, $num_prods);
3096 $line->fk_product = $prodids[$prodid];
3098 $line->product_type = 0;
3100 $this->lines[$xnbp] = $line;
3102 $this->total_ht += $line->total_ht;
3103 $this->total_tva += $line->total_tva;
3104 $this->total_ttc += $line->total_ttc;
3110 $this->total_ht = $xnbp * 100;
3111 $this->total_tva = $xnbp * 19.6;
3112 $this->total_ttc = $xnbp * 119.6;
3124 global $conf, $user;
3126 $this->nb = array();
3130 $sql =
"SELECT count(f.rowid) as nb";
3131 $sql .=
" FROM ".MAIN_DB_PREFIX.
"facture_fourn as f";
3132 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON f.fk_soc = s.rowid";
3133 if (empty($user->socid) && !$user->hasRight(
"societe",
"client",
"voir")) {
3134 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe_commerciaux as sc ON s.rowid = sc.fk_soc";
3135 $sql .=
" WHERE sc.fk_user = ".((int) $user->id);
3138 $sql .=
" ".$clause.
" f.entity = ".$conf->entity;
3140 $resql = $this->db->query($sql);
3142 while ($obj = $this->db->fetch_object($resql)) {
3143 $this->nb[
"supplier_invoices"] = $obj->nb;
3145 $this->db->free($resql);
3149 $this->error = $this->db->error();
3164 global $conf, $langs;
3181 $object->ref_supplier = (empty($this->ref_supplier) ? $langs->trans(
"CopyOf").
' '.
$object->ref_supplier : $this->ref_supplier);
3183 $object->user_validation_id = 0;
3184 $object->fk_facture_source = 0;
3186 $object->date_validation =
'';
3196 $object->date_echeance =
$object->calculate_date_lim_reglement();
3199 foreach (
$object->lines as $i => $line) {
3200 if (isset(
$object->lines[$i]->info_bits) && (
$object->lines[$i]->info_bits & 0x02) == 0x02) {
3206 $object->context[
'createfromclone'] =
'createfromclone';
3207 $result =
$object->create($user);
3211 $this->error =
$object->error;
3212 $this->errors =
$object->errors;
3219 unset(
$object->context[
'createfromclone']);
3223 $this->db->commit();
3226 $this->db->rollback();
3242 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0, $moreparams =
null)
3246 $langs->load(
"suppliers");
3247 $outputlangs->load(
"products");
3250 if (empty($modele)) {
3258 if (empty($modele)) {
3261 $modelpath =
"core/modules/supplier_invoice/doc/";
3263 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams);
3275 return $user->hasRight(
"fournisseur",
"facture");
3323 if (!$this->date_echeance) {
3327 $status = isset($this->
status) ? $this->
status : $this->statut;
3329 return ($status == self::STATUS_VALIDATED) && ($this->date_echeance < ($now - $conf->facture->fournisseur->warning_delay));
3341 $sql =
"SELECT fk_invoice_supplier FROM ".MAIN_DB_PREFIX.
"societe_remise_except WHERE fk_invoice_supplier_source = ".((int) $this->
id);
3342 $resql = $this->db->query($sql);
3343 if (!empty($resql)) {
3344 $obj = $this->db->fetch_object($resql);
3345 if (!empty($obj->fk_invoice_supplier)) {
3363 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
3365 $picto = $this->picto;
3366 if ($this->
type == self::TYPE_REPLACEMENT) {
3369 if ($this->
type == self::TYPE_CREDIT_NOTE) {
3372 if ($this->
type == self::TYPE_DEPOSIT) {
3376 $return =
'<div class="box-flex-item box-flex-grow-zero">';
3377 $return .=
'<div class="info-box info-box-sm">';
3378 $return .=
'<span class="info-box-icon bg-infobox-action">';
3380 $return .=
'</span>';
3381 $return .=
'<div class="info-box-content">';
3382 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl(1) : $this->ref).
'</span>';
3383 if ($selected >= 0) {
3384 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
3386 if (!empty($arraydata[
'thirdparty'])) {
3387 $return .=
'<br><span class="info-box-label">'.$arraydata[
'thirdparty'].
'</span>';
3389 if (property_exists($this,
'date')) {
3390 $return .=
'<br><span class="info-box-label">'.dol_print_date($this->date,
'day').
'</span>';
3392 if (property_exists($this,
'total_ht')) {
3393 $return .=
' <span class="info-box-label amount" title="'.dol_escape_htmltag($langs->trans(
"AmountHT")).
'">'.
price($this->total_ht);
3394 $return .=
' '.$langs->trans(
"HT");
3395 $return .=
'</span>';
3397 if (method_exists($this,
'getLibStatut')) {
3398 $alreadypaid = (empty($arraydata[
'alreadypaid']) ? 0 : $arraydata[
'alreadypaid']);
3399 $return .=
'<br><div class="info-box-status">'.$this->getLibStatut(3, $alreadypaid).
'</div>';
3401 $return .=
'</div>';
3402 $return .=
'</div>';
3403 $return .=
'</div>';
3415 if (!$this->table_element) {
3416 dol_syslog(get_class($this).
"::setVATReverseCharge was called on object with property table_element not defined", LOG_ERR);
3420 dol_syslog(get_class($this).
'::setVATReverseCharge('.$vatreversecharge.
')');
3422 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
3423 $sql .=
" SET vat_reverse_charge = ".((int) $vatreversecharge);
3424 $sql .=
" WHERE rowid=".((int) $this->
id);
3426 if ($this->db->query($sql)) {
3427 $this->vat_reverse_charge = ($vatreversecharge == 0) ? 0 : 1;
3430 dol_syslog(get_class($this).
'::setVATReverseCharge Error ', LOG_DEBUG);
3431 $this->error = $this->db->error();
3449 global $conf, $langs, $user;
3456 $errorsMsg = array();
3458 $langs->load(
'bills');
3460 if (!isModEnabled(empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD) ?
'fournisseur' :
'supplier_invoice')) {
3461 $this->output .= $langs->trans(
'ModuleNotEnabled', $langs->transnoentitiesnoconv(
'Suppliers'));
3464 if (!in_array($datetouse, array(
'duedate',
'invoicedate'))) {
3465 $this->output .=
'Bad value for parameter datetouse. Must be "duedate" or "invoicedate"';
3469 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
3470 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmail.class.php';
3471 require_once DOL_DOCUMENT_ROOT.
'/core/class/CMailFile.class.php';
3472 $formmail =
new FormMail($this->db);
3482 $sql =
"SELECT rowid as id FROM ".MAIN_DB_PREFIX.
"facture_fourn as f";
3483 if (!empty($paymentmode) && $paymentmode !=
'all') {
3484 $sql .=
", ".MAIN_DB_PREFIX.
"c_paiement as cp";
3486 $sql .=
" WHERE f.paye = 0";
3487 $sql .=
" AND f.fk_statut = ".self::STATUS_VALIDATED;
3488 if ($datetouse ==
'invoicedate') {
3489 $sql .=
" AND f.datef = '".$this->db->idate($tmpidate,
'gmt').
"'";
3491 $sql .=
" AND f.date_lim_reglement = '".$this->db->idate($tmpidate,
'gmt').
"'";
3493 $sql .=
" AND f.entity IN (".getEntity(
'supplier_invoice', 0).
")";
3494 if (!empty($paymentmode) && $paymentmode !=
'all') {
3495 $sql .=
" AND f.fk_mode_reglement = cp.id AND cp.code = '".$this->db->escape($paymentmode).
"'";
3498 if ($datetouse ==
'invoicedate') {
3499 $sql .= $this->db->order(
"datef",
"ASC");
3501 $sql .= $this->db->order(
"date_lim_reglement",
"ASC");
3504 $resql = $this->db->query($sql);
3507 if ($datetouse ==
'invoicedate') {
3508 $this->output .= $langs->transnoentitiesnoconv(
"SearchValidatedSupplierInvoicesWithDate", $stmpidate);
3510 $this->output .= $langs->transnoentitiesnoconv(
"SearchUnpaidSupplierInvoicesWithDueDate", $stmpidate);
3512 if (!empty($paymentmode) && $paymentmode !=
'all') {
3513 $this->output .=
' ('.$langs->transnoentitiesnoconv(
"PaymentMode").
' '.$paymentmode.
')';
3515 $this->output .=
'<br>';
3518 while ($obj = $this->db->fetch_object($resql)) {
3521 $res = $tmpinvoice->fetch($obj->id);
3523 $tmpinvoice->fetch_thirdparty();
3525 $outputlangs =
new Translate(
'', $conf);
3526 if ($tmpinvoice->thirdparty->default_lang) {
3527 $outputlangs->setDefaultLang($tmpinvoice->thirdparty->default_lang);
3528 $outputlangs->loadLangs(array(
"main",
"suppliers"));
3530 $outputlangs = $langs;
3535 $templateLabel =
'';
3536 if (empty($template) || $template ==
'EmailTemplateCode') {
3537 $templateLabel =
'(SendingReminderEmailOnUnpaidSupplierInvoice)';
3539 if (is_numeric($template)) {
3540 $templateId = $template;
3542 $templateLabel = $template;
3546 $arraymessage = $formmail->getEMailTemplate($this->db,
'invoice_supplier_send', $user, $outputlangs, $templateId, 1, $templateLabel);
3547 if (is_numeric($arraymessage) && $arraymessage <= 0) {
3548 $langs->load(
"errors");
3549 $this->output .= $langs->trans(
'ErrorFailedToFindEmailTemplate', $template);
3562 $sendTopic =
make_substitutions(empty($arraymessage->topic) ? $outputlangs->transnoentitiesnoconv(
'InformationMessage') : $arraymessage->topic, $substitutionarray, $outputlangs, 1);
3565 $content = $outputlangs->transnoentitiesnoconv($arraymessage->content);
3571 if ($forcerecipient) {
3572 $to = array($forcerecipient);
3574 $res = $tmpinvoice->fetch_thirdparty();
3575 $recipient = $tmpinvoice->thirdparty;
3577 $tmparraycontact = $tmpinvoice->liste_contact(-1,
'internal', 0,
'SALESREPFOLL');
3578 if (is_array($tmparraycontact) && count($tmparraycontact) > 0) {
3579 foreach ($tmparraycontact as $data_email) {
3580 if (!empty($data_email[
'email'])) {
3581 $to[] = $data_email[
'email'];
3585 if (empty($to) && !empty($recipient->email)) {
3586 $to[] = $recipient->email;
3589 $errormesg =
"Failed to send remind to thirdparty id=".$tmpinvoice->socid.
". No email defined for supplier invoice or customer.";
3593 $errormesg =
"Failed to load recipient with thirdparty id=".$tmpinvoice->socid;
3600 if (!empty($arraymessage->email_from)) {
3601 $from = $arraymessage->email_from;
3604 $errormesg =
"Failed to get sender into global setup MAIN_MAIL_EMAIL_FROM";
3608 if (!$error && !empty($to)) {
3611 $to = implode(
',', $to);
3612 if (!empty($arraymessage->email_to)) {
3613 $to = $to.
','.$arraymessage->email_to;
3617 $errors_to = $conf->global->MAIN_MAIL_ERRORS_TO;
3619 $trackid =
'inv'.$tmpinvoice->id;
3620 $sendcontext =
'standard';
3623 if (!empty($arraymessage->email_tocc)) {
3624 $email_tocc = $arraymessage->email_tocc;
3628 if (!empty($arraymessage->email_tobcc)) {
3629 $email_tobcc = $arraymessage->email_tobcc;
3633 $cMailFile =
new CMailFile($sendTopic, $to, $from, $sendContent, array(), array(), array(), $email_tocc, $email_tobcc, 0, 1, $errors_to,
'', $trackid,
'', $sendcontext,
'');
3636 if ($cMailFile->sendfile()) {
3640 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/actioncomm.class.php';
3645 $actioncomm->type_code =
'AC_OTH_AUTO';
3646 $actioncomm->socid = $tmpinvoice->thirdparty->id;
3647 $actioncomm->contact_id = 0;
3649 $actioncomm->code =
'AC_EMAIL';
3650 $actioncomm->label =
'sendEmailsRemindersOnInvoiceDueDateOK (nbdays='.$nbdays.
' paymentmode='.$paymentmode.
' template='.$template.
' datetouse='.$datetouse.
' forcerecipient='.$forcerecipient.
')';
3651 $actioncomm->note_private = $sendContent;
3652 $actioncomm->fk_project = $tmpinvoice->fk_project;
3653 $actioncomm->datep =
dol_now();
3654 $actioncomm->datef = $actioncomm->datep;
3655 $actioncomm->percentage = -1;
3656 $actioncomm->authorid = $user->id;
3657 $actioncomm->userownerid = $user->id;
3659 $actioncomm->email_msgid = $cMailFile->msgid;
3660 $actioncomm->email_subject = $sendTopic;
3661 $actioncomm->email_from = $from;
3662 $actioncomm->email_sender =
'';
3663 $actioncomm->email_to = $to;
3667 $actioncomm->errors_to = $errors_to;
3669 $actioncomm->elementtype =
'invoice_supplier';
3670 $actioncomm->fk_element = $tmpinvoice->id;
3674 $actioncomm->create($user);
3676 $errormesg = $cMailFile->error.
' : '.$to;
3680 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/actioncomm.class.php';
3685 $actioncomm->type_code =
'AC_OTH_AUTO';
3686 $actioncomm->socid = $tmpinvoice->thirdparty->id;
3687 $actioncomm->contact_id = 0;
3689 $actioncomm->code =
'AC_EMAIL';
3690 $actioncomm->label =
'sendEmailsRemindersOnInvoiceDueDateKO';
3691 $actioncomm->note_private = $errormesg;
3692 $actioncomm->fk_project = $tmpinvoice->fk_project;
3693 $actioncomm->datep =
dol_now();
3694 $actioncomm->datef = $actioncomm->datep;
3695 $actioncomm->percentage = -1;
3696 $actioncomm->authorid = $user->id;
3697 $actioncomm->userownerid = $user->id;
3699 $actioncomm->email_msgid = $cMailFile->msgid;
3700 $actioncomm->email_from = $from;
3701 $actioncomm->email_sender =
'';
3702 $actioncomm->email_to = $to;
3706 $actioncomm->errors_to = $errors_to;
3710 $actioncomm->create($user);
3713 $this->db->commit();
3717 $errorsMsg[] = $errormesg;
3720 $errorsMsg[] =
'Failed to fetch record invoice with ID = '.$obj->id;
3730 $this->output .=
'Nb of emails sent : '.$nbMailSend;
3732 dol_syslog(__METHOD__.
" end - ".$this->output, LOG_INFO);
3736 $this->error =
'Nb of emails sent : '.$nbMailSend.
', '.(empty($errorsMsg) ? $error : implode(
', ', $errorsMsg));
3738 dol_syslog(__METHOD__.
" end - ".$this->error, LOG_INFO);
3755 public $element =
'facture_fourn_det';
3760 public $table_element =
'facture_fourn_det';
3787 public $product_ref;
3794 public $ref_supplier;
3800 public $product_desc;
3827 public $fk_facture_fourn;
3841 public $description;
3849 public $fk_code_ventilation;
3854 public $skip_update_total;
3859 public $situation_percent;
3870 public $vat_src_code;
3882 public $localtax1_tx;
3888 public $localtax2_tx;
3900 public $remise_percent;
3930 public $total_localtax1;
3936 public $total_localtax2;
3947 public $product_type;
3953 public $product_label;
3967 public $fk_remise_except;
3972 public $fk_parent_line;
3977 public $special_code;
3988 public $localtax1_type;
3994 public $localtax2_type;
4015 $sql =
'SELECT f.rowid, f.ref as ref_supplier, f.description as line_desc, f.date_start, f.date_end, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.tva_tx';
4016 $sql .=
', f.localtax1_type, f.localtax2_type, f.localtax1_tx, f.localtax2_tx, f.total_localtax1, f.total_localtax2, f.fk_remise_except';
4017 $sql .=
', f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_facture_fourn, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit';
4018 $sql .=
', p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc';
4019 $sql .=
', f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, multicurrency_total_ttc';
4020 $sql .=
' FROM '.MAIN_DB_PREFIX.
'facture_fourn_det as f';
4021 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON f.fk_product = p.rowid';
4022 $sql .=
' WHERE f.rowid = '.((int) $rowid);
4023 $sql .=
' ORDER BY f.rang, f.rowid';
4025 $query = $this->db->query($sql);
4028 $this->errors[] = $this->db->error();
4032 if (!$this->db->num_rows($query)) {
4036 $obj = $this->db->fetch_object($query);
4038 $this->
id = $obj->rowid;
4039 $this->
rowid = $obj->rowid;
4040 $this->fk_facture_fourn = $obj->fk_facture_fourn;
4043 $this->desc = $obj->line_desc;
4044 $this->date_start = $this->db->jdate($obj->date_start);
4045 $this->date_end = $this->db->jdate($obj->date_end);
4046 $this->product_ref = $obj->product_ref;
4047 $this->ref_supplier = $obj->ref_supplier;
4048 $this->product_desc = $obj->product_desc;
4050 $this->subprice = $obj->pu_ht;
4051 $this->pu_ht = $this->subprice;
4052 $this->pu_ttc = $obj->pu_ttc;
4053 $this->tva_tx = $obj->tva_tx;
4054 $this->localtax1_tx = $obj->localtax1_tx;
4055 $this->localtax2_tx = $obj->localtax2_tx;
4056 $this->localtax1_type = $obj->localtax1_type;
4057 $this->localtax2_type = $obj->localtax2_type;
4059 $this->qty = $obj->qty;
4060 $this->remise_percent = $obj->remise_percent;
4061 $this->fk_remise_except = $obj->fk_remise_except;
4063 $this->total_ht = $obj->total_ht;
4064 $this->total_tva = $obj->total_tva;
4065 $this->total_localtax1 = $obj->total_localtax1;
4066 $this->total_localtax2 = $obj->total_localtax2;
4067 $this->total_ttc = $obj->total_ttc;
4068 $this->fk_product = $obj->fk_product;
4069 $this->product_type = $obj->product_type;
4070 $this->product_label = $obj->product_label;
4071 $this->label = $obj->product_label;
4072 $this->info_bits = $obj->info_bits;
4073 $this->fk_parent_line = $obj->fk_parent_line;
4074 $this->special_code = $obj->special_code;
4075 $this->rang = $obj->rang;
4076 $this->fk_unit = $obj->fk_unit;
4078 $this->multicurrency_subprice = $obj->multicurrency_subprice;
4079 $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
4080 $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
4081 $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
4094 public function delete($notrigger = 0)
4098 dol_syslog(get_class($this).
"::deleteline rowid=".((
int) $this->
id), LOG_DEBUG);
4105 if ($this->
call_trigger(
'LINEBILL_SUPPLIER_DELETE', $user) < 0) {
4117 dol_syslog(get_class($this).
"::delete error -4 ".$this->error, LOG_ERR);
4123 $sql =
'DELETE FROM '.MAIN_DB_PREFIX.
'facture_fourn_det ';
4124 $sql .=
" WHERE rowid = ".((int) $this->
id);
4125 dol_syslog(get_class($this).
"::delete", LOG_DEBUG);
4126 $resql = $this->db->query($sql);
4129 $this->error = $this->db->lasterror();
4134 $this->db->commit();
4137 $this->db->rollback();
4156 if (empty($this->qty)) {
4160 if ($this->product_type < 0) {
4165 if (empty($this->remise_percent)) {
4166 $this->remise_percent = 0;
4168 if (empty($this->tva_tx)) {
4171 if (empty($this->localtax1_tx)) {
4172 $this->localtax1_tx = 0;
4174 if (empty($this->localtax2_tx)) {
4175 $this->localtax2_tx = 0;
4178 if (empty($this->pa_ht)) {
4181 if (empty($this->multicurrency_subprice)) {
4182 $this->multicurrency_subprice = 0;
4184 if (empty($this->multicurrency_total_ht)) {
4185 $this->multicurrency_total_ht = 0;
4187 if (empty($this->multicurrency_total_tva)) {
4188 $this->multicurrency_total_tva = 0;
4190 if (empty($this->multicurrency_total_ttc)) {
4191 $this->multicurrency_total_ttc = 0;
4194 $fk_product = (int) $this->fk_product;
4195 $fk_unit = (int) $this->fk_unit;
4199 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"facture_fourn_det SET";
4200 $sql .=
" description = '".$this->db->escape(empty($this->
description) ? $this->desc : $this->description).
"'";
4201 $sql .=
", ref = '".$this->db->escape($this->ref_supplier ? $this->ref_supplier :
$this->ref).
"'";
4202 $sql .=
", date_start = ".($this->date_start !=
'' ?
"'".$this->db->idate($this->date_start).
"'" :
"null");
4203 $sql .=
", date_end = ".($this->date_end !=
'' ?
"'".$this->db->idate($this->date_end).
"'" :
"null");
4204 $sql .=
", pu_ht = ".price2num($this->subprice);
4205 $sql .=
", pu_ttc = ".price2num($this->pu_ttc);
4206 $sql .=
", qty = ".price2num($this->qty);
4207 $sql .=
", remise_percent = ".price2num($this->remise_percent);
4208 if ($this->fk_remise_except > 0) {
4209 $sql .=
", fk_remise_except=".((int) $this->fk_remise_except);
4211 $sql .=
", fk_remise_except=null";
4213 $sql .=
", vat_src_code = '".$this->db->escape(empty($this->vat_src_code) ?
'' : $this->vat_src_code).
"'";
4214 $sql .=
", tva_tx = ".price2num($this->tva_tx);
4215 $sql .=
", localtax1_tx = ".price2num($this->localtax1_tx);
4216 $sql .=
", localtax2_tx = ".price2num($this->localtax2_tx);
4217 $sql .=
", localtax1_type = '".$this->db->escape($this->localtax1_type).
"'";
4218 $sql .=
", localtax2_type = '".$this->db->escape($this->localtax2_type).
"'";
4219 $sql .=
", total_ht = ".price2num($this->total_ht);
4220 $sql .=
", tva= ".price2num($this->total_tva);
4221 $sql .=
", total_localtax1= ".price2num($this->total_localtax1);
4222 $sql .=
", total_localtax2= ".price2num($this->total_localtax2);
4223 $sql .=
", total_ttc = ".price2num($this->total_ttc);
4224 $sql .=
", fk_product = ".($fk_product > 0 ? (int) $fk_product :
'null');
4225 $sql .=
", product_type = ".((int) $this->product_type);
4226 $sql .=
", info_bits = ".((int) $this->info_bits);
4227 $sql .=
", fk_unit = ".($fk_unit > 0 ? (int) $fk_unit :
'null');
4229 if (!empty($this->rang)) {
4230 $sql .=
", rang=".((int) $this->rang);
4234 $sql .=
" , multicurrency_subprice=".price2num($this->multicurrency_subprice);
4235 $sql .=
" , multicurrency_total_ht=".price2num($this->multicurrency_total_ht);
4236 $sql .=
" , multicurrency_total_tva=".price2num($this->multicurrency_total_tva);
4237 $sql .=
" , multicurrency_total_ttc=".price2num($this->multicurrency_total_ttc);
4239 $sql .=
" WHERE rowid = ".((int) $this->
id);
4241 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
4242 $resql = $this->db->query($sql);
4245 $this->db->rollback();
4246 $this->error = $this->db->lasterror();
4250 $this->
rowid = $this->id;
4260 if (!$error && !$notrigger) {
4261 global $langs, $user;
4264 if ($this->
call_trigger(
'LINEBILL_SUPPLIER_MODIFY', $user) < 0) {
4265 $this->db->rollback();
4272 $this->db->rollback();
4276 $this->db->commit();
4287 public function insert($notrigger = 0, $noerrorifdiscountalreadylinked = 0)
4289 global $user, $langs;
4293 dol_syslog(get_class($this).
"::insert rang=".$this->rang, LOG_DEBUG);
4296 $this->desc = trim($this->desc);
4297 if (empty($this->tva_tx)) {
4300 if (empty($this->localtax1_tx)) {
4301 $this->localtax1_tx = 0;
4303 if (empty($this->localtax2_tx)) {
4304 $this->localtax2_tx = 0;
4306 if (empty($this->localtax1_type)) {
4307 $this->localtax1_type = 0.0;
4309 if (empty($this->localtax2_type)) {
4310 $this->localtax2_type = 0.0;
4312 if (empty($this->total_tva)) {
4313 $this->total_tva = 0;
4315 if (empty($this->total_localtax1)) {
4316 $this->total_localtax1 = 0;
4318 if (empty($this->total_localtax2)) {
4319 $this->total_localtax2 = 0;
4321 if (empty($this->rang)) {
4324 if (empty($this->remise_percent)) {
4325 $this->remise_percent = 0;
4327 if (empty($this->info_bits)) {
4328 $this->info_bits = 0;
4330 if (empty($this->subprice)) {
4331 $this->subprice = 0;
4333 if (empty($this->special_code)) {
4334 $this->special_code = 0;
4336 if (empty($this->fk_parent_line)) {
4337 $this->fk_parent_line = 0;
4339 if (!isset($this->situation_percent) || $this->situation_percent > 100 || (
string) $this->situation_percent ==
'') {
4340 $this->situation_percent = 100;
4343 if (empty($this->pa_ht)) {
4346 if (empty($this->multicurrency_subprice)) {
4347 $this->multicurrency_subprice = 0;
4349 if (empty($this->multicurrency_total_ht)) {
4350 $this->multicurrency_total_ht = 0;
4352 if (empty($this->multicurrency_total_tva)) {
4353 $this->multicurrency_total_tva = 0;
4355 if (empty($this->multicurrency_total_ttc)) {
4356 $this->multicurrency_total_ttc = 0;
4361 if ($this->product_type < 0) {
4362 $this->error =
'ErrorProductTypeMustBe0orMore';
4365 if (!empty($this->fk_product) && $this->fk_product > 0) {
4369 $this->error =
'ErrorProductIdDoesNotExists';
4377 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.$this->table_element;
4378 $sql .=
' (fk_facture_fourn, fk_parent_line, label, description, ref, qty,';
4379 $sql .=
' vat_src_code, tva_tx, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type,';
4380 $sql .=
' fk_product, product_type, remise_percent, fk_remise_except, pu_ht, pu_ttc,';
4381 $sql .=
' date_start, date_end, fk_code_ventilation, rang, special_code,';
4382 $sql .=
' info_bits, total_ht, tva, total_ttc, total_localtax1, total_localtax2, fk_unit';
4383 $sql .=
', fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc';
4385 $sql .=
" VALUES (".$this->fk_facture_fourn.
",";
4386 $sql .=
" ".($this->fk_parent_line > 0 ?
"'".$this->db->escape($this->fk_parent_line).
"'" :
"null").
",";
4388 = !empty($this->product_label)
4389 ? $this->product_label :
4390 (!empty($this->label) ? $this->label :
null);
4391 $sql .=
" ".(!empty($product_label) ?
"'".$this->db->escape($product_label).
"'" :
"null").
",";
4392 $sql .=
" '".$this->db->escape($this->desc ? $this->desc : $this->description).
"',";
4393 $sql .=
" '".$this->db->escape($this->ref_supplier).
"',";
4394 $sql .=
" ".price2num($this->qty).
",";
4396 $sql .=
" ".(empty($this->vat_src_code) ?
"''" :
"'".$this->db->escape($this->vat_src_code).
"'").
",";
4397 $sql .=
" ".price2num($this->tva_tx).
",";
4398 $sql .=
" ".price2num($this->localtax1_tx).
",";
4399 $sql .=
" ".price2num($this->localtax2_tx).
",";
4400 $sql .=
" '".$this->db->escape($this->localtax1_type).
"',";
4401 $sql .=
" '".$this->db->escape($this->localtax2_type).
"',";
4402 $sql .=
' '.((!empty($this->fk_product) && $this->fk_product > 0) ? $this->fk_product :
"null").
',';
4403 $sql .=
" ".((int) $this->product_type).
",";
4404 $sql .=
" ".price2num($this->remise_percent).
",";
4405 $sql .=
' '.(!empty($this->fk_remise_except) ? ((int) $this->fk_remise_except) :
"null").
',';
4406 $sql .=
" ".price2num($this->subprice).
",";
4407 $sql .=
" ".(!empty($this->qty) ?
price2num($this->total_ttc / $this->qty) :
price2num($this->total_ttc)).
",";
4408 $sql .=
" ".(!empty($this->date_start) ?
"'".$this->db->idate($this->date_start).
"'" :
"null").
",";
4409 $sql .=
" ".(!empty($this->date_end) ?
"'".$this->db->idate($this->date_end).
"'" :
"null").
",";
4410 $sql .=
' '.(!empty($this->fk_code_ventilation) ? $this->fk_code_ventilation : 0).
',';
4411 $sql .=
' '.((int) $this->rang).
',';
4412 $sql .=
' '.((int) $this->special_code).
',';
4413 $sql .=
" ".((int) $this->info_bits).
",";
4414 $sql .=
" ".price2num($this->total_ht).
",";
4415 $sql .=
" ".price2num($this->total_tva).
",";
4416 $sql .=
" ".price2num($this->total_ttc).
",";
4417 $sql .=
" ".price2num($this->total_localtax1).
",";
4418 $sql .=
" ".price2num($this->total_localtax2);
4419 $sql .=
", ".(!$this->fk_unit ?
'NULL' : $this->fk_unit);
4420 $sql .=
", ".(int) $this->fk_multicurrency;
4421 $sql .=
", '".$this->db->escape($this->multicurrency_code).
"'";
4422 $sql .=
", ".price2num($this->multicurrency_subprice);
4423 $sql .=
", ".price2num($this->multicurrency_total_ht);
4424 $sql .=
", ".price2num($this->multicurrency_total_tva);
4425 $sql .=
", ".price2num($this->multicurrency_total_ttc);
4428 $resql = $this->db->query($sql);
4430 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.$this->table_element);
4431 $this->
rowid = $this->id;
4442 if ($this->fk_remise_except) {
4444 $result = $discount->fetch($this->fk_remise_except);
4449 if ($discount->fk_facture_line > 0) {
4450 if (empty($noerrorifdiscountalreadylinked)) {
4451 $this->error = $langs->trans(
"ErrorDiscountAlreadyUsed", $discount->id);
4452 dol_syslog(get_class($this).
"::insert Error ".$this->error, LOG_ERR);
4453 $this->db->rollback();
4457 $result = $discount->link_to_invoice($this->
id, 0);
4459 $this->error = $discount->error;
4460 dol_syslog(get_class($this).
"::insert Error ".$this->error, LOG_ERR);
4461 $this->db->rollback();
4466 $this->error = $langs->trans(
"ErrorADiscountThatHasBeenRemovedIsIncluded");
4467 dol_syslog(get_class($this).
"::insert Error ".$this->error, LOG_ERR);
4468 $this->db->rollback();
4472 $this->error = $discount->error;
4473 dol_syslog(get_class($this).
"::insert Error ".$this->error, LOG_ERR);
4474 $this->db->rollback();
4479 if (!$error && !$notrigger) {
4481 $result = $this->
call_trigger(
'LINEBILL_SUPPLIER_CREATE', $user);
4483 $this->db->rollback();
4490 $this->db->commit();
4494 foreach ($this->errors as $errmsg) {
4495 dol_syslog(get_class($this).
"::insert ".$errmsg, LOG_ERR);
4496 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
4499 $this->db->rollback();
4502 $this->error = $this->db->error();
4503 $this->db->rollback();
4520 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"facture_fourn_det SET";
4521 $sql .=
" total_ht = ".price2num($this->total_ht);
4522 $sql .=
", tva= ".price2num($this->total_tva);
4523 $sql .=
", total_localtax1 = ".price2num($this->total_localtax1);
4524 $sql .=
", total_localtax2 = ".price2num($this->total_localtax2);
4525 $sql .=
", total_ttc = ".price2num($this->total_ttc);
4526 $sql .=
" WHERE rowid = ".((int) $this->
id);
4528 dol_syslog(
"FactureFournisseurLigne.class.php::update_total", LOG_DEBUG);
4530 $resql = $this->db->query($sql);
4532 $this->db->commit();
4535 $this->error = $this->db->error();
4536 $this->db->rollback();
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
print $langs trans("AuditedSecurityEvents").'</strong >< span class="opacitymedium"></span >< br > status
Or an array listing all the potential status of the object: array: int of the status => translated la...
Class to manage agenda events (actions)
Class to send emails (with attachments or not) Usage: $mailfile = new CMailFile($subject,...
Superclass for invoices classes.
calculate_date_lim_reglement($cond_reglement=0)
Returns an invoice payment deadline based on the invoice settlement conditions and billing date.
fetch_optionals($rowid=null, $optionsArray=null)
Function to get extra fields of an object into $this->array_options This method is in most cases call...
line_order($renum=false, $rowidorder='ASC', $fk_parent_line=true)
Save a new position (field rang) for details lines.
deleteEcmFiles($mode=0)
Delete related files of object in database.
update_price($exclspec=0, $roundingadjust='auto', $nodatabaseupdate=0, $seller=null)
Update total_ht, total_ttc, total_vat, total_localtax1, total_localtax2 for an object (sum of lines).
add_object_linked($origin=null, $origin_id=null, $f_user=null, $notrigger=0)
Add an object link into llx_element_element.
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
fetch_thirdparty($force_thirdparty_id=0)
Load the third party of object, from id $this->socid or $this->fk_soc, into this->thirdparty.
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
Delete all links between an object $this.
static isExistingObject($element, $id, $ref='', $ref_ext='')
Check if an object id or ref exists If you don't need or want to instantiate the object and just need...
updateRangOfLine($rowid, $rang)
Update position of line (rang)
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.
static commonReplaceProduct(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a product id with another one.
line_max($fk_parent_line=0)
Get max value used for position of line (rang)
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
call_trigger($triggerName, $user)
Call trigger based on this instance.
Parent class for class inheritance lines of business objects This class is useless for the moment so ...
Class to manage absolute discounts.
Class to manage Dolibarr database access.
Class to manage suppliers invoices.
const TYPE_DEPOSIT
Deposit invoice.
create($user)
Create supplier invoice into database.
list_qualified_avoir_supplier_invoices($socid=0)
Return list of qualifying invoices for correction by credit note Invoices that respect the following ...
list_replacable_supplier_invoices($socid=0)
Return list of replaceable invoices Status valid or abandoned for other reason + not paid + no paymen...
deleteLine($rowid, $notrigger=0)
Delete a detail line from database.
set_unpaid($user)
Tag the invoice as not fully paid + trigger call BILL_UNPAYED Function used when a direct debit payme...
setCanceled($user, $close_code='', $close_note='')
Tag invoice as canceled, with no payment on it (example for replacement invoice or payment never rece...
fetch($id=0, $ref='', $ref_ext='')
Load object in memory from database.
addline($desc, $pu, $txtva, $txlocaltax1, $txlocaltax2, $qty, $fk_product=0, $remise_percent=0, $date_start=0, $date_end=0, $fk_code_ventilation=0, $info_bits=0, $price_base_type='HT', $type=0, $rang=-1, $notrigger=0, $array_options=[], $fk_unit=null, $origin_id=0, $pu_devise=0, $ref_supplier='', $special_code=0, $fk_parent_line=0, $fk_remise_except=0)
Adds an invoice line (associated with no predefined product/service) The parameters are already suppo...
info($id)
Loads the info order information into the invoice object.
const TYPE_CREDIT_NOTE
Credit note invoice.
isCreditNoteUsed()
Is credit note used.
getKanbanView($option='', $arraydata=null)
Return clicable link of object (with eventually picto)
load_board($user)
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
getNomUrl($withpicto=0, $option='', $max=0, $short=0, $moretitle='', $notooltip=0, $save_lastsearch_value=-1, $addlinktonotes=0)
Return clicable name (with picto eventually)
getTooltipContentArray($params)
getTooltipContentArray
setPaid($user, $close_code='', $close_note='')
Tag invoice as a paid invoice.
update($user=null, $notrigger=0)
Update database.
__construct($db)
Constructor.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
const TYPE_REPLACEMENT
Replacement invoice.
setUnpaid($user)
Tag the invoice as not fully paid + trigger call BILL_UNPAYED Function used when a direct debit payme...
const STATUS_VALIDATED
Validated (need to be paid)
setDraft($user, $idwarehouse=-1, $notrigger=0)
Set draft status.
getNextNumRef($soc, $mode='next')
Return next reference of supplier invoice not already used (or last reference) according to numbering...
updateline($id, $desc, $pu, $vatrate, $txlocaltax1=0, $txlocaltax2=0, $qty=1, $idproduct=0, $price_base_type='HT', $info_bits=0, $type=0, $remise_percent=0, $notrigger=0, $date_start='', $date_end='', $array_options=[], $fk_unit=null, $pu_devise=0, $ref_supplier='', $rang=0)
Update a line detail into database.
sendEmailsRemindersOnSupplierInvoiceDueDate($nbdays=0, $paymentmode='all', $template='', $datetouse='duedate', $forcerecipient='')
Send reminders by emails for supplier invoices validated that are due.
insert_discount($idremise)
Add a discount line into an invoice (as an invoice line) using an existing absolute discount (Consume...
initAsSpecimen($option='')
Initialise an instance with random values.
const TYPE_STANDARD
Standard invoice.
validate($user, $force_number='', $idwarehouse=0, $notrigger=0)
Tag invoice as validated + call trigger BILL_VALIDATE.
set_paid($user, $close_code='', $close_note='')
Tag invoice as a paid invoice.
createFromClone(User $user, $fromid, $invertdetail=0)
Load an object from its id and create a new one in database.
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0, $moreparams=null)
Create a document onto disk according to template model.
getRights()
Returns the rights used for this class.
const STATUS_ABANDONED
Classified abandoned and no payment done.
hasDelay()
Is the payment of the supplier invoice having a delay?
static replaceProduct(DoliDB $db, $origin_id, $dest_id)
Function used to replace a product id with another one.
loadStateBoard()
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
fetch_lines()
Load this->lines.
const STATUS_CLOSED
Classified paid.
setVATReverseCharge($vatreversecharge)
Change the option VAT reverse charge.
Class to manage invoice templates.
Class to manage stock movements.
static getIdFromCode($dbs, $code)
Get id of currency from code.
static getIdAndTxFromCode($dbs, $code, $date_document='')
Get id and rate of currency from code.
Class to manage predefined suppliers products.
Class to manage products or services.
Class to manage line invoices.
fetch($rowid)
Retrieves a supplier invoice line.
__construct($db)
Constructor.
update($notrigger=0)
Update a supplier invoice line.
insert($notrigger=0, $noerrorifdiscountalreadylinked=0)
Insert line into database.
update_total()
Mise a jour de l'objet ligne de commande en base.
Class to manage translations.
Class to manage Dolibarr users.
dol_get_first_hour($date, $gm='tzserver')
Return GMT time for first hour of a given GMT date (it removes hours, min and second part)
dol_time_plus_duree($time, $duration_value, $duration_unit, $ruleforendofmonth=0)
Add a delay to a date.
print $script_file $mode $langs defaultlang(is_numeric($duration_value) ? " delay=". $duration_value :"").(is_numeric($duration_value2) ? " after cd cd cd description as description
Only used if Module[ID]Desc translation string is not found.
dol_delete_dir_recursive($dir, $count=0, $nophperrors=0, $onlysub=0, &$countdeleted=0, $indexdatabase=1, $nolog=0)
Remove a directory $dir and its subdirectories (or only files and subdirectories)
dol_delete_file($file, $disableglob=0, $nophperrors=0, $nohook=0, $object=null, $allowdotdot=false, $indexdatabase=1, $nolog=0)
Remove a file or several files with a mask.
dol_dir_list($utf8_path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
dol_concatdesc($text1, $text2, $forxml=false, $invert=false)
Concat 2 descriptions with a new line between them (second operand after first one with appropriate n...
complete_substitutions_array(&$substitutionarray, $outputlangs, $object=null, $parameters=null, $callfunc="completesubstitutionarray")
Complete the $substitutionarray with more entries coming from external module that had set the "subst...
make_substitutions($text, $substitutionarray, $outputlangs=null, $converttextinhtmlifnecessary=0)
Make substitution into a text string, replacing keys with vals from $substitutionarray (oldval=>newva...
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_trunc($string, $size=40, $trunc='right', $stringencoding='UTF-8', $nodot=0, $display=0)
Truncate a string to a particular length adding '…' if string larger than length.
getCommonSubstitutionArray($outputlangs, $onlykey=0, $exclude=null, $object=null, $include=null)
Return array of possible common substitutions.
isValidEmail($address, $acceptsupervisorkey=0, $acceptuserkey=0)
Return true if email syntax is ok.
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
get_exdir($num, $level, $alpha, $withoutslash, $object, $modulepart='')
Return a path to have a the directory according to object where files are stored.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
calcul_price_total($qty, $pu, $remise_percent_ligne, $txtva, $uselocaltax1_rate, $uselocaltax2_rate, $remise_percent_global, $price_base_type, $info_bits, $type, $seller='', $localtaxes_array=[], $progress=100, $multicurrency_tx=1, $pu_devise=0, $multicurrency_code='')
Calculate totals (net, vat, ...) of a line.
if(preg_match('/crypted:/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
publicphonebutton2 phonegreen basiclayout basiclayout TotalHT VATCode TotalVAT TotalLT1 TotalLT2 TotalTTC TotalHT clearboth nowraponall TAKEPOS_SHOW_SUBPRICE right right right takeposterminal SELECT e e e e e statut
publicphonebutton2 phonegreen basiclayout basiclayout TotalHT VATCode TotalVAT TotalLT1 TotalLT2 TotalTTC TotalHT clearboth nowraponall TAKEPOS_SHOW_SUBPRICE right right right takeposterminal SELECT e rowid