33require_once DOL_DOCUMENT_ROOT.
'/core/class/notify.class.php';
34require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
35require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.facture.class.php';
36require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
44 const TRIGGER_PREFIX =
'SUPPLIERBILLREC';
48 public $element =
'invoice_supplier_rec';
53 public $table_element =
'facture_fourn_rec';
58 public $table_element_line =
'facture_fourn_det_rec';
63 public $fk_element =
'fk_facture_fourn';
68 public $picto =
'bill';
117 public $vat_src_code;
125 public $mode_reglement_id;
126 public $mode_reglement_code;
127 public $cond_reglement_code;
128 public $cond_reglement_doc;
129 public $cond_reglement_id;
134 public $date_lim_reglement;
136 public $usenewprice = 0;
138 public $unit_frequency;
140 public $date_last_gen;
155 public $auto_validate;
156 public $generate_pdf;
162 public $lines = array();
207 public $fields = array(
208 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 10),
209 'titre' => array(
'type' =>
'varchar(100)',
'label' =>
'Titre',
'enabled' => 1,
'showoncombobox' => 1,
'visible' => -1,
'position' => 15),
210 'ref_supplier' => array(
'type' =>
'varchar(180)',
'label' =>
'RefSupplier',
'enabled' => 1,
'showoncombobox' => 1,
'visible' => -1,
'position' => 20),
211 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'default' =>
'1',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 25,
'index' => 1),
212 'fk_soc' => array(
'type' =>
'integer:Societe:societe/class/societe.class.php',
'label' =>
'ThirdParty',
'enabled' =>
'isModEnabled("societe")',
'visible' => -1,
'notnull' => 1,
'position' => 30),
213 'datec' => array(
'type' =>
'datetime',
'label' =>
'DateCreation',
'enabled' => 1,
'visible' => -1,
'position' => 35),
214 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModification',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 40),
215 'suspended' => array(
'type' =>
'integer',
'label' =>
'Suspended',
'enabled' => 1,
'visible' => -1,
'position' => 225),
216 'libelle' => array(
'type' =>
'varchar(100)',
'label' =>
'Libelle',
'enabled' => 1,
'showoncombobox' => 0,
'visible' => -1,
'position' => 15),
218 'localtax1' => array(
'type' =>
'double(24,8)',
'label' =>
'Localtax1',
'enabled' => 1,
'visible' => -1,
'position' => 60,
'isameasure' => 1),
219 'localtax2' => array(
'type' =>
'double(24,8)',
'label' =>
'Localtax2',
'enabled' => 1,
'visible' => -1,
'position' => 65,
'isameasure' => 1),
220 'total_ht' => array(
'type' =>
'double(24,8)',
'label' =>
'Total',
'enabled' => 1,
'visible' => -1,
'position' => 70,
'isameasure' => 1),
221 'total_tva' => array(
'type' =>
'double(24,8)',
'label' =>
'Tva',
'enabled' => 1,
'visible' => -1,
'position' => 55,
'isameasure' => 1),
222 'total_ttc' => array(
'type' =>
'double(24,8)',
'label' =>
'Total ttc',
'enabled' => 1,
'visible' => -1,
'position' => 75,
'isameasure' => 1),
224 'fk_user_author' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'Fk user author',
'enabled' => 1,
'visible' => -1,
'position' => 80),
225 'fk_user_modif' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserModif',
'enabled' => 1,
'visible' => -2,
'notnull' => -1,
'position' => 210),
226 'fk_projet' => array(
'type' =>
'integer:Project:projet/class/project.class.php:1:fk_statut=1',
'label' =>
'Fk projet',
'enabled' =>
"isModEnabled('project')",
'visible' => -1,
'position' => 85),
227 'fk_account' => array(
'type' =>
'integer',
'label' =>
'Fk account',
'enabled' =>
'isModEnabled("bank")',
'visible' => -1,
'position' => 175),
228 'fk_cond_reglement' => array(
'type' =>
'integer',
'label' =>
'Fk cond reglement',
'enabled' => 1,
'visible' => -1,
'position' => 90),
229 'fk_mode_reglement' => array(
'type' =>
'integer',
'label' =>
'Fk mode reglement',
'enabled' => 1,
'visible' => -1,
'position' => 95),
230 'date_lim_reglement' => array(
'type' =>
'date',
'label' =>
'Date lim reglement',
'enabled' => 1,
'visible' => -1,
'position' => 100),
232 'note_private' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 105),
233 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => 0,
'position' => 110),
234 'modelpdf' => array(
'type' =>
'varchar(255)',
'label' =>
'Modelpdf',
'enabled' => 1,
'visible' => -1,
'position' => 115),
236 'fk_multicurrency' => array(
'type' =>
'integer',
'label' =>
'Fk multicurrency',
'enabled' => 1,
'visible' => -1,
'position' => 180),
237 'multicurrency_code' => array(
'type' =>
'varchar(255)',
'label' =>
'Multicurrency code',
'enabled' => 1,
'visible' => -1,
'position' => 185),
238 'multicurrency_tx' => array(
'type' =>
'double(24,8)',
'label' =>
'Multicurrency tx',
'enabled' => 1,
'visible' => -1,
'position' => 190,
'isameasure' => 1),
239 'multicurrency_total_ht' => array(
'type' =>
'double(24,8)',
'label' =>
'Multicurrency total ht',
'enabled' => 1,
'visible' => -1,
'position' => 195,
'isameasure' => 1),
240 'multicurrency_total_tva' => array(
'type' =>
'double(24,8)',
'label' =>
'Multicurrency total tva',
'enabled' => 1,
'visible' => -1,
'position' => 200,
'isameasure' => 1),
241 'multicurrency_total_ttc' => array(
'type' =>
'double(24,8)',
'label' =>
'Multicurrency total ttc',
'enabled' => 1,
'visible' => -1,
'position' => 205,
'isameasure' => 1),
243 'usenewprice' => array(
'type' =>
'integer',
'label' =>
'UseNewPrice',
'enabled' => 1,
'visible' => 0,
'position' => 155),
244 'frequency' => array(
'type' =>
'integer',
'label' =>
'Frequency',
'enabled' => 1,
'visible' => -1,
'position' => 150),
245 'unit_frequency' => array(
'type' =>
'varchar(2)',
'label' =>
'Unit frequency',
'enabled' => 1,
'visible' => -1,
'position' => 125),
247 'date_when' => array(
'type' =>
'datetime',
'label' =>
'Date when',
'enabled' => 1,
'visible' => -1,
'position' => 130),
248 'date_last_gen' => array(
'type' =>
'datetime',
'label' =>
'Date last gen',
'enabled' => 1,
'visible' => -1,
'position' => 135),
249 'nb_gen_done' => array(
'type' =>
'integer',
'label' =>
'Nb gen done',
'enabled' => 1,
'visible' => -1,
'position' => 140),
250 'nb_gen_max' => array(
'type' =>
'integer',
'label' =>
'Nb gen max',
'enabled' => 1,
'visible' => -1,
'position' => 145),
251 'revenuestamp' => array(
'type' =>
'double(24,8)',
'label' =>
'RevenueStamp',
'enabled' => 1,
'visible' => -1,
'position' => 160,
'isameasure' => 1),
252 'auto_validate' => array(
'type' =>
'integer',
'label' =>
'Auto validate',
'enabled' => 1,
'visible' => -1,
'position' => 165),
253 'generate_pdf' => array(
'type' =>
'integer',
'label' =>
'Generate pdf',
'enabled' => 1,
'visible' => -1,
'position' => 170),
257 const STATUS_NOTSUSPENDED = 0;
258 const STATUS_SUSPENDED = 1;
280 public function create($user, $facFournId, $notrigger = 0)
288 $this->titre = empty($this->titre) ?
'' : $this->titre;
289 $this->title = empty($this->title) ?
'' : $this->title;
291 $this->
ref = $this->$keyforref;
292 $this->ref_supplier = empty($this->ref_supplier) ?
'' : $this->ref_supplier;
293 $this->usenewprice = empty($this->usenewprice) ? 0 : $this->usenewprice;
294 $this->suspended = empty($this->suspended) ? 0 : $this->suspended;
296 if (empty($this->frequency)) {
297 $this->frequency = 0;
298 $this->date_when =
null;
300 $this->frequency = abs($this->frequency);
301 $this->nb_gen_done = 0;
302 $this->nb_gen_max = empty($this->nb_gen_max) ? 0 : $this->nb_gen_max;
303 $this->auto_validate = empty($this->auto_validate) ? 0 : $this->auto_validate;
304 $this->generate_pdf = empty($this->generate_pdf) ? 0 : $this->generate_pdf;
310 $result = $facfourn_src->fetch($facFournId);
312 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.
'facture_fourn_rec (';
315 $sql .=
', ref_supplier';
319 $sql .=
', suspended';
321 $sql .=
', total_ttc';
322 $sql .=
', fk_user_author';
323 $sql .=
', fk_projet';
324 $sql .=
', fk_account';
325 $sql .=
', fk_cond_reglement';
326 $sql .=
', fk_mode_reglement';
327 $sql .=
', date_lim_reglement';
328 $sql .=
', note_private';
329 $sql .=
', note_public';
330 $sql .=
', modelpdf';
331 $sql .=
', fk_multicurrency';
332 $sql .=
', multicurrency_code';
333 $sql .=
', multicurrency_tx';
334 $sql .=
', usenewprice';
335 $sql .=
', frequency';
336 $sql .=
', unit_frequency';
337 $sql .=
', date_when';
338 $sql .=
', date_last_gen';
339 $sql .=
', nb_gen_done';
340 $sql .=
', nb_gen_max';
341 $sql .=
', auto_validate';
342 $sql .=
', generate_pdf';
343 $sql .=
') VALUES (';
344 $sql .=
"'".$this->db->escape($this->title).
"'";
345 $sql .=
", ".($this->subtype ?
"'".$this->db->escape($this->subtype).
"'" :
"null");
346 $sql .=
", '".$this->db->escape($this->ref_supplier).
"'";
347 $sql .=
", ".((int) $conf->entity);
348 $sql .=
", ".((int) $facfourn_src->socid);
349 $sql .=
", '".$this->db->idate($now).
"'";
350 $sql .=
", ".((int) $this->suspended);
351 $sql .=
", '".$this->db->escape($this->libelle).
"'";
352 $sql .=
", " .(!empty($facfourn_src->total_ttc) ? (float) $facfourn_src->total_ttc :
'0');
353 $sql .=
", " .((int) $user->id);
354 $sql .=
", " .(!empty($this->fk_project) ? ((int) $this->fk_project) :
'NULL');
355 $sql .=
", " .(!empty($facfourn_src->fk_account) ? ((int) $facfourn_src->fk_account) :
'NULL');
356 $sql .=
", " .($this->cond_reglement_id > 0 ? (int) $this->cond_reglement_id :
'NULL');
357 $sql .=
", " .($this->mode_reglement_id > 0 ? (int) $this->mode_reglement_id :
'NULL');
358 $sql .=
", ".($facfourn_src->date_echeance > 0 ?
"'".$this->db->idate($facfourn_src->date_echeance).
"'" :
'NULL');
359 $sql .=
", " .(!empty($this->note_private) ?
"'".$this->db->escape($this->note_private).
"'" :
'NULL');
360 $sql .=
", " .(!empty($this->note_public) ?
"'".$this->db->escape($this->note_public).
"'" :
'NULL');
361 $sql .=
", " .(!empty($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
'NULL');
362 $sql .=
", " . (int) $facfourn_src->fk_multicurrency;
363 $sql .=
", '".$this->db->escape($facfourn_src->multicurrency_code).
"'";
364 $sql .=
", " . (float) $facfourn_src->multicurrency_tx;
365 $sql .=
", " . (int) $this->usenewprice;
366 $sql .=
", " . (int) $this->frequency;
367 $sql .=
", '".$this->db->escape($this->unit_frequency).
"'";
368 $sql .=
", " .(!empty($this->date_when) ?
"'".$this->db->idate($this->date_when).
"'" :
'NULL');
369 $sql .=
", " .(!empty($this->date_last_gen) ?
"'".$this->db->idate($this->date_last_gen).
"'" :
'NULL');
370 $sql .=
", " . (int) $this->nb_gen_done;
371 $sql .=
", " . (int) $this->nb_gen_max;
372 $sql .=
", " . (int) $this->auto_validate;
373 $sql .=
", " . (int) $this->generate_pdf;
376 if ($this->db->query($sql)) {
377 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
'facture_fourn_rec');
380 $this->fk_multicurrency = $facfourn_src->fk_multicurrency;
382 $this->multicurrency_code = $facfourn_src->multicurrency_code;
383 $this->multicurrency_tx = $facfourn_src->multicurrency_tx;
386 $num = count($facfourn_src->lines);
387 for ($i = 0; $i < $num; $i++) {
388 $tva_tx = $facfourn_src->lines[$i]->tva_tx;
389 if (!empty($facfourn_src->lines[$i]->vat_src_code) && !preg_match(
'/\(/', (
string) $tva_tx)) {
390 $tva_tx .=
' ('.$facfourn_src->lines[$i]->vat_src_code.
')';
393 $result_insert = $this->
addline(
394 $facfourn_src->lines[$i]->fk_product,
395 $facfourn_src->lines[$i]->ref_supplier,
396 $facfourn_src->lines[$i]->product_label,
397 $facfourn_src->lines[$i]->desc ? $facfourn_src->lines[$i]->desc : $facfourn_src->lines[$i]->description,
398 $facfourn_src->lines[$i]->pu_ht,
399 $facfourn_src->lines[$i]->pu_ttc,
400 $facfourn_src->lines[$i]->qty,
401 $facfourn_src->lines[$i]->remise_percent,
403 $facfourn_src->lines[$i]->localtax1_tx,
404 $facfourn_src->lines[$i]->localtax2_tx,
406 $facfourn_src->lines[$i]->product_type,
407 $facfourn_src->lines[$i]->date_start,
408 $facfourn_src->lines[$i]->date_end,
409 $facfourn_src->lines[$i]->info_bits,
410 $facfourn_src->lines[$i]->special_code,
411 $facfourn_src->lines[$i]->rang,
412 $facfourn_src->lines[$i]->fk_unit
415 if ($result_insert < 0) {
420 $result2 = $objectline->fetch($result_insert);
423 if (method_exists($facfourn_src->lines[$i],
'fetch_optionals')) {
424 $facfourn_src->lines[$i]->fetch_optionals($facfourn_src->lines[$i]->id);
425 $objectline->array_options = $facfourn_src->lines[$i]->array_options;
428 $result = $objectline->insertExtraFields();
432 } elseif ($result2 < 0) {
433 $this->errors[] = $objectline->error;
439 if (!empty($this->linkedObjectsIds) && empty($this->linked_objects)) {
440 $this->linked_objects = $this->linkedObjectsIds;
444 if (!$error && $this->
id && !empty($this->linked_objects) && is_array($this->linked_objects)) {
445 foreach ($this->linked_objects as $origin => $tmp_origin_id) {
446 if (is_array($tmp_origin_id)) {
447 foreach ($tmp_origin_id as $origin_id) {
450 $this->error = $this->db->lasterror();
455 $origin_id = $tmp_origin_id;
458 $this->error = $this->db->lasterror();
472 if (!$error && !$notrigger) {
474 $result = $this->
call_trigger(
'SUPPLIERBILLREC_CREATE', $user);
476 $this->db->rollback();
483 $this->db->rollback();
490 $this->error = $this->db->lasterror();
491 $this->db->rollback();
495 $this->db->rollback();
512 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"facture_fourn_rec SET";
513 $sql .=
" titre = '" . (!empty($this->title) ? $this->db->escape($this->title) :
"").
"'," ;
514 $sql .=
" subtype=".(isset($this->subtype) ? $this->db->escape($this->subtype) :
"null").
",";
515 $sql .=
" ref_supplier = '". (!empty($this->ref_supplier) ? $this->db->escape($this->ref_supplier) :
"").
"',";
516 $sql .=
" entity = ". (!empty($this->entity) ? ((int) $this->entity) : 1) .
',';
517 if (!empty($this->socid) && $this->socid > 0) {
518 $sql .=
" fk_soc = ". ((int) $this->socid).
',';
519 } elseif (!empty($this->fk_soc) && $this->fk_soc > 0) {
520 $sql .=
" fk_soc = ". ((int) $this->fk_soc).
',';
522 $sql .=
" suspended = ". (!empty($this->suspended) ? ((int) $this->suspended) : 0) .
',';
523 $sql .=
" libelle = ". (!empty($this->libelle) ?
"'".$this->db->escape($this->libelle).
"'" :
'NULL') .
",";
524 $sql .=
" vat_src_code = ". (!empty($this->vat_src_code) ?
"'".$this->db->escape($this->vat_src_code).
"'" :
'NULL') .
',';
525 $sql .=
" localtax1 = ". (!empty($this->localtax1) ? ((float) $this->localtax1) : 0.00) .
',';
526 $sql .=
" localtax2 = ". (!empty($this->localtax2) ? ((float) $this->localtax2) : 0.00) .
',';
527 $sql .=
" total_ht = ". (!empty($this->total_ht) ? ((float) $this->total_ht) : 0.00) .
',';
528 $sql .=
" total_tva = ". (!empty($this->total_tva) ? ((float) $this->total_tva) : 0.00) .
',';
529 $sql .=
" total_ttc = ". (!empty($this->total_ttc) ? ((float) $this->total_ttc) : 0.00) .
',';
530 $sql .=
" fk_user_modif = ". ((int) $user->id) .
',';
531 $sql .=
" fk_projet = ". (!empty($this->fk_project) ? ((int) $this->fk_project) :
'NULL') .
',';
532 $sql .=
" fk_account = ". (!empty($this->fk_account) ? ((int) $this->fk_account) :
'NULL') .
',';
533 $sql .=
" fk_mode_reglement = ". (!empty($this->mode_reglement_id) ? ((int) $this->mode_reglement_id) :
'NULL') .
',';
534 $sql .=
" fk_cond_reglement = ". (!empty($this->cond_reglement_id) ? ((int) $this->cond_reglement_id) :
'NULL') .
',';
535 $sql .=
" date_lim_reglement = ". (!empty($this->date_lim_reglement) ?
"'".$this->db->idate($this->date_lim_reglement).
"'" :
'NULL') .
',';
536 $sql .=
" note_private = '". (!empty($this->note_private) ? $this->db->escape($this->note_private) :
'') .
"',";
537 $sql .=
" note_public = '". (!empty($this->note_public) ? $this->db->escape($this->note_public) :
'') .
"',";
538 $sql .=
" modelpdf = ". (!empty($this->model_pdf) ?
"'".$this->db->escape($this->model_pdf).
"'" :
'NULL') .
",";
539 $sql .=
" fk_multicurrency = ". (!empty($this->fk_multicurrency) ? ((int) $this->fk_multicurrency) :
'NULL') .
',';
540 $sql .=
" multicurrency_code = ". (!empty($this->multicurrency_code) ?
"'".$this->db->escape($this->multicurrency_code).
"'" :
'NULL') .
",";
541 $sql .=
" multicurrency_tx = ". (!empty($this->multicurrency_tx) ? ((float) $this->multicurrency_tx) : 1) .
',';
542 $sql .=
" multicurrency_total_ht = ". (!empty($this->multicurrency_total_ht) ? ((float) $this->multicurrency_total_ht) : 0.00) .
',';
543 $sql .=
" multicurrency_total_tva = ". (!empty($this->multicurrency_total_tva) ? ((float) $this->multicurrency_total_tva) : 0.00) .
',';
544 $sql .=
" multicurrency_total_ttc = ". (!empty($this->multicurrency_total_ttc) ? ((float) $this->multicurrency_total_ttc) : 0.00) .
',';
545 $sql .=
" usenewprice = ". (!empty($this->usenewprice) ? ((int) $this->usenewprice) : 0) .
',';
546 $sql .=
" frequency = ". (!empty($this->frequency) ? ((int) $this->frequency) : 0).
',';
547 $sql .=
" unit_frequency = '". (!empty($this->unit_frequency) ? $this->db->escape($this->unit_frequency) :
'').
"',";
548 $sql .=
" date_when = ". (!empty($this->date_when) ?
"'".$this->db->idate($this->date_when).
"'" :
'NULL') .
',';
549 $sql .=
" date_last_gen = ". (!empty($this->date_last_gen) ?
"'".$this->db->idate($this->date_last_gen).
"'" :
'NULL') .
',';
550 $sql .=
" nb_gen_done = ". (!empty($this->nb_gen_done) ? ((int) $this->nb_gen_done) : 0) .
',';
551 $sql .=
" nb_gen_max = ". (!empty($this->nb_gen_max) ? ((int) $this->nb_gen_max) : 0) .
',';
552 $sql .=
" auto_validate = ". (!empty($this->auto_validate) ? ((int) $this->auto_validate) : 0);
553 $sql .=
" WHERE rowid = ". (int) $this->
id;
557 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
558 $resql = $this->db->query($sql);
567 if (!$error && !$notrigger) {
569 $result = $this->
call_trigger(
'SUPPLIERBILLREC_MODIFY', $user);
571 $this->db->rollback();
579 $this->error = $this->db->lasterror();
580 $this->db->rollback();
593 public function fetch($rowid, $ref =
'', $ref_ext =
'')
595 $sql =
'SELECT f.rowid, f.titre as title, f.subtype, f.ref_supplier, f.entity, f.fk_soc';
596 $sql .=
', f.datec, f.tms, f.suspended';
597 $sql .=
', f.libelle as label';
598 $sql .=
', f.vat_src_code, f.localtax1, f.localtax2';
599 $sql .=
', f.total_tva, f.total_ht, f.total_ttc';
600 $sql .=
', f.fk_user_author, f.fk_user_modif';
601 $sql .=
', f.fk_projet as fk_project, f.fk_account';
602 $sql .=
', f.fk_mode_reglement, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle';
603 $sql .=
', f.fk_cond_reglement, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc';
604 $sql .=
', f.date_lim_reglement';
605 $sql .=
', f.note_private, f.note_public, f.modelpdf as model_pdf';
606 $sql .=
', f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc';
607 $sql .=
', f.usenewprice, f.frequency, f.unit_frequency, f.date_when, f.date_last_gen, f.nb_gen_done, f.nb_gen_max, f.auto_validate';
608 $sql .=
', f.generate_pdf';
609 $sql .=
' FROM '.MAIN_DB_PREFIX.
'facture_fourn_rec as f';
610 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_payment_term as c ON f.fk_cond_reglement = c.rowid';
611 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_paiement as p ON f.fk_mode_reglement = p.id';
612 $sql .=
' WHERE f.entity IN ('.getEntity(
'invoice').
')';
614 $sql .=
' AND f.rowid='. (int) $rowid;
616 $sql .=
" AND f.titre='".$this->db->escape($ref).
"'";
618 $sql .=
' AND f.rowid = 0';
621 $result = $this->db->query($sql);
623 if ($this->db->num_rows($result)) {
624 $obj = $this->db->fetch_object($result);
628 $this->
id = $obj->rowid;
629 $this->titre = $obj->title;
630 $this->title = $obj->title;
631 $this->subtype = $obj->subtype;
632 $this->
ref = $obj->title;
633 $this->ref_supplier = $obj->ref_supplier;
634 $this->entity = $obj->entity;
635 $this->socid = $obj->fk_soc;
636 $this->date_creation = $obj->datec;
637 $this->date_modification = $obj->tms;
638 $this->suspended = $obj->suspended;
639 $this->libelle = $obj->label;
640 $this->label = $obj->label;
641 $this->vat_src_code = $obj->vat_src_code;
642 $this->total_localtax1 = $obj->localtax1;
643 $this->total_localtax2 = $obj->localtax2;
644 $this->total_ht = $obj->total_ht;
645 $this->total_tva = $obj->total_tva;
646 $this->total_ttc = $obj->total_ttc;
647 $this->user_author = $obj->fk_user_author;
648 $this->user_modif = $obj->fk_user_modif;
649 $this->fk_project = $obj->fk_project;
650 $this->fk_account = $obj->fk_account;
651 $this->mode_reglement_id = $obj->fk_mode_reglement;
652 $this->mode_reglement_code = $obj->mode_reglement_code;
653 $this->mode_reglement = $obj->mode_reglement_libelle;
654 $this->cond_reglement_id = $obj->fk_cond_reglement;
655 $this->cond_reglement_code = $obj->cond_reglement_code;
656 $this->cond_reglement = $obj->cond_reglement_libelle;
657 $this->cond_reglement_doc = $obj->cond_reglement_libelle_doc;
658 $this->date_lim_reglement = $this->db->jdate($obj->date_lim_reglement);
659 $this->note_private = $obj->note_private;
660 $this->note_public = $obj->note_public;
661 $this->model_pdf = $obj->model_pdf;
664 $this->fk_multicurrency = $obj->fk_multicurrency;
665 $this->multicurrency_code = $obj->multicurrency_code;
666 $this->multicurrency_tx = $obj->multicurrency_tx;
667 $this->multicurrency_total_ht = $obj->multicurrency_total_ht;
668 $this->multicurrency_total_tva = $obj->multicurrency_total_tva;
669 $this->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
671 $this->usenewprice = $obj->usenewprice;
672 $this->frequency = $obj->frequency;
673 $this->unit_frequency = $obj->unit_frequency;
674 $this->date_when = $this->db->jdate($obj->date_when);
675 $this->date_last_gen = $this->db->jdate($obj->date_last_gen);
676 $this->nb_gen_done = $obj->nb_gen_done;
677 $this->nb_gen_max = $obj->nb_gen_max;
678 $this->auto_validate = $obj->auto_validate;
679 $this->generate_pdf = $obj->generate_pdf;
690 $this->error = $this->db->lasterror();
695 $this->error =
'Bill with id '.$rowid.
' or ref '.$ref.
' not found';
696 dol_syslog(
'Facture::Fetch Error '.$this->error, LOG_ERR);
700 $this->error = $this->db->error();
725 $this->lines = array();
736 $sql =
'SELECT l.rowid,';
737 $sql .=
' l.fk_facture_fourn, l.fk_parent_line, l.fk_product, l.ref, l.label, l.description as line_desc,';
738 $sql .=
' l.pu_ht, l.pu_ttc, l.qty, l.remise_percent, l.fk_remise_except, l.vat_src_code, l.tva_tx,';
739 $sql .=
' l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type,';
740 $sql .=
' l.total_ht, l.total_tva, l.total_ttc, total_localtax1, total_localtax2,';
741 $sql .=
' l.product_type, l.date_start, l.date_end,';
742 $sql .=
' l.info_bits, l.special_code, l.rang,';
743 $sql .=
' l.fk_unit, l.import_key, l.fk_user_author, l.fk_user_modif,';
744 $sql .=
' l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc,';
745 $sql .=
' p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc';
746 $sql .=
' FROM '.MAIN_DB_PREFIX.
'facture_fourn_det_rec as l';
747 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON l.fk_product = p.rowid';
748 $sql .=
' WHERE l.fk_facture_fourn = '. (int) $this->
id;
749 $sql .=
' ORDER BY l.rang';
751 dol_syslog(
'FactureFournisseurRec::fetch_lines', LOG_DEBUG);
753 $result = $this->db->query($sql);
755 $num = $this->db->num_rows($result);
758 $objp = $this->db->fetch_object($result);
762 $line->id = $objp->rowid;
763 $line->fk_facture_fourn = $objp->fk_facture_fourn;
764 $line->fk_parent = $objp->fk_parent_line;
765 $line->fk_product = $objp->fk_product;
766 $line->ref_supplier = $objp->ref;
767 $line->label = $objp->label;
768 $line->description = $objp->line_desc;
769 $line->desc = $objp->line_desc;
770 $line->pu_ht = $objp->pu_ht;
771 $line->pu_ttc = $objp->pu_ttc;
772 $line->qty = $objp->qty;
773 $line->remise_percent = $objp->remise_percent;
774 $line->fk_remise_except = $objp->fk_remise_except;
775 $line->vat_src_code = $objp->vat_src_code;
776 $line->tva_tx = $objp->tva_tx;
777 $line->localtax1_tx = $objp->localtax1_tx;
778 $line->localtax1_type = $objp->localtax1_type;
779 $line->localtax2_tx = $objp->localtax2_tx;
780 $line->localtax2_type = $objp->localtax2_type;
781 $line->total_ht = $objp->total_ht;
782 $line->total_tva = $objp->total_tva;
783 $line->total_localtax1 = $objp->total_localtax1;
784 $line->total_localtax2 = $objp->total_localtax2;
785 $line->total_ttc = $objp->total_ttc;
786 $line->product_type = $objp->product_type;
787 $line->date_start = $objp->date_start;
788 $line->date_end = $objp->date_end;
789 $line->info_bits = $objp->info_bits ;
790 $line->special_code = $objp->special_code;
791 $line->rang = $objp->rang;
792 $line->fk_unit = $objp->fk_unit;
793 $line->import_key = $objp->import_key;
794 $line->fk_user_author = $objp->fk_user_author;
795 $line->fk_user_modif = $objp->fk_user_modif;
796 $line->fk_multicurrency = $objp->fk_multicurrency;
797 $line->multicurrency_code = $objp->multicurrency_code;
798 $line->multicurrency_subprice = $objp->multicurrency_subprice;
799 $line->multicurrency_total_ht = $objp->multicurrency_total_ht;
800 $line->multicurrency_total_tva = $objp->multicurrency_total_tva;
801 $line->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
803 $line->fetch_optionals();
805 $this->lines[$i] = $line;
810 $this->db->free($result);
813 $this->error = $this->db->lasterror();
827 public function delete(
User $user, $notrigger = 0, $idwarehouse = -1)
831 dol_syslog(get_class($this).
"::delete rowid=".((
int) $rowid), LOG_DEBUG);
836 $main = MAIN_DB_PREFIX.
'facture_fourn_det_rec';
837 $ef = $main.
"_extrafields";
839 $sqlef =
"DELETE FROM ".$ef.
" WHERE fk_object IN (SELECT rowid FROM ".$main.
" WHERE fk_facture_fourn = ". (int) $rowid .
")";
840 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"facture_fourn_det_rec WHERE fk_facture_fourn = ". (int) $rowid;
842 if ($this->db->query($sqlef) && $this->db->query($sql)) {
843 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"facture_fourn_rec WHERE rowid = ". (int) $rowid;
845 if ($this->db->query($sql)) {
857 $this->error = $this->db->lasterror();
861 $this->error = $this->db->lasterror();
864 if (!$error && !$notrigger) {
866 $result = $this->
call_trigger(
'SUPPLIERBILLREC_DELETE', $user);
876 $this->db->rollback();
907 public function addline($fk_product, $ref, $label, $desc, $pu_ht, $pu_ttc, $qty, $remise_percent, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 0, $price_base_type =
'HT', $type = 0, $date_start = 0, $date_end = 0, $info_bits = 0, $special_code = 0, $rang = -1, $fk_unit =
null, $pu_ht_devise = 0)
909 global $mysoc, $user;
911 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
915 dol_syslog(get_class($this).
"::addline facid=$facid,desc=$desc,pu_ht=$pu_ht,qty=$qty,txtva=$txtva,txlocaltax1=$txlocaltax1,txlocaltax2=$txlocaltax2,fk_product=$fk_product,remise_percent=$remise_percent,info_bits=$info_bits,price_base_type=$price_base_type,pu_ttc=$pu_ttc,type=$type,fk_unit=$fk_unit,pu_ht_devise=$pu_ht_devise,date_start_fill=$date_start,date_end_fill=$date_end", LOG_DEBUG);
922 if ($this->suspended == self::STATUS_NOTSUSPENDED) {
928 if (preg_match(
'/\((.*)\)/', (
string) $txtva, $reg)) {
929 $vat_src_code = $reg[1];
930 $txtva = preg_replace(
'/\s*\(.*\)/',
'', (
string) $txtva);
934 $fk_product = empty($fk_product) ? 0 : $fk_product;
935 $label = empty($label) ?
'' : $label;
936 $remise_percent = empty($remise_percent) ? 0 :
price2num($remise_percent);
940 if (!preg_match(
'/\((.*)\)/', $txtva)) {
945 $txtva = !empty($txtva) ? $txtva : 0;
946 $txlocaltax1 = !empty($txlocaltax1) ? $txlocaltax1 : 0;
947 $txlocaltax2 = !empty($txlocaltax2) ? $txlocaltax2 : 0;
948 $info_bits = !empty($info_bits) ? $info_bits : 0;
949 $info_bits = !empty($info_bits) ? $info_bits : 0;
950 $pu = $price_base_type ==
'HT' ? $pu_ht : $pu_ttc;
956 $tabprice =
calcul_price_total($qty, $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $type, $mysoc, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);
957 $total_ht = $tabprice[0];
958 $total_tva = $tabprice[1];
959 $total_ttc = $tabprice[2];
960 $total_localtax1 = $tabprice[9];
961 $total_localtax2 = $tabprice[10];
962 $pu_ht = $tabprice[3];
965 $multicurrency_total_ht = $tabprice[16];
966 $multicurrency_total_tva = $tabprice[17];
967 $multicurrency_total_ttc = $tabprice[18];
968 $pu_ht_devise = $tabprice[19];
971 $product_type = $type;
973 $product =
new Product($this->db);
974 $result = $product->fetch($fk_product);
978 $product_type = $product->type;
980 $label = $product->label;
984 $sql =
'INSERT INTO ' . MAIN_DB_PREFIX .
'facture_fourn_det_rec (';
985 $sql .=
'fk_facture_fourn';
986 $sql .=
', fk_product';
989 $sql .=
', description';
993 $sql .=
', remise_percent';
994 $sql .=
', fk_remise_except';
995 $sql .=
', vat_src_code';
997 $sql .=
', localtax1_tx';
998 $sql .=
', localtax1_type';
999 $sql .=
', localtax2_tx';
1000 $sql .=
', localtax2_type';
1001 $sql .=
', total_ht';
1002 $sql .=
', total_tva';
1003 $sql .=
', total_localtax1';
1004 $sql .=
', total_localtax2';
1005 $sql .=
', total_ttc';
1006 $sql .=
', product_type';
1007 $sql .=
', date_start';
1008 $sql .=
', date_end';
1009 $sql .=
', info_bits';
1010 $sql .=
', special_code';
1012 $sql .=
', fk_unit';
1013 $sql .=
', fk_user_author';
1014 $sql .=
', fk_multicurrency, multicurrency_code, multicurrency_subprice, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc';
1015 $sql .=
') VALUES (';
1016 $sql .=
' ' . (int) $facid;
1017 $sql .=
', ' . (!empty($fk_product) ?
"'" . $this->db->escape($fk_product) .
"'" :
'null');
1018 $sql .=
', ' . (!empty($ref) ?
"'" . $this->db->escape($ref) .
"'" :
'null');
1019 $sql .=
', ' . (!empty($label) ?
"'" . $this->db->escape($label) .
"'" :
'null');
1020 $sql .=
", '" . $this->db->escape($desc) .
"'";
1024 $sql .=
', ' .
price2num($remise_percent);
1026 $sql .=
", '" . $this->db->escape($vat_src_code) .
"'";
1029 $sql .=
", '" . $this->db->escape(isset($localtaxes_type[0]) ? $localtaxes_type[0] :
'') .
"'";
1031 $sql .=
", '" . $this->db->escape(isset($localtaxes_type[2]) ? $localtaxes_type[2] :
'') .
"'";
1034 $sql .=
', ' .
price2num($total_localtax1);
1035 $sql .=
', ' .
price2num($total_localtax2);
1037 $sql .=
', ' . (int) $product_type;
1038 $sql .=
', ' . ($date_start > 0 ? (int) $date_start :
'NULL');
1039 $sql .=
', ' . ($date_end > 0 ? (int) $date_end :
'NULL');
1040 $sql .=
', ' . (int) $info_bits;
1041 $sql .=
', ' . (int) $special_code;
1042 $sql .=
', ' . (int) $rang;
1043 $sql .=
', ' . ($fk_unit ? (int) $fk_unit :
'NULL');
1044 $sql .=
', ' . (int) $user->id;
1045 $sql .=
', ' . (int) $this->fk_multicurrency;
1046 $sql .=
", '" . $this->db->escape($this->multicurrency_code) .
"'";
1047 $sql .=
', ' .
price2num($pu_ht_devise,
'CU');
1048 $sql .=
', ' .
price2num($multicurrency_total_ht,
'CT');
1049 $sql .=
', ' .
price2num($multicurrency_total_tva,
'CT');
1050 $sql .=
', ' .
price2num($multicurrency_total_ttc,
'CT');
1053 dol_syslog(get_class($this).
'::addline', LOG_DEBUG);
1054 if ($this->db->query($sql)) {
1055 $lineId = $this->db->last_insert_id(MAIN_DB_PREFIX.
'facture_fourn_det_rec');
1058 $this->db->commit();
1061 $this->db->rollback();
1062 $this->error = $this->db->lasterror();
1067 $this->error =
'Recurring Invoice is suspended. adding lines not allowed.';
1100 public function updateline($rowid, $fk_product, $ref, $label, $desc, $pu_ht, $qty, $remise_percent, $txtva, $txlocaltax1 = 0, $txlocaltax2 = 0, $price_base_type =
'HT', $type = 0, $date_start = 0, $date_end = 0, $info_bits = 0, $special_code = 0, $rang = -1, $fk_unit =
null, $pu_ht_devise = 0, $pu_ttc = 0)
1102 global $mysoc, $user;
1106 dol_syslog(get_class($this).
'::updateline facid=' .$facid.
" rowid=$rowid, desc=$desc, pu_ht=$pu_ht, qty=$qty, txtva=$txtva, txlocaltax1=$txlocaltax1, txlocaltax2=$txlocaltax2, fk_product=$fk_product, remise_percent=$remise_percent, info_bits=$info_bits, price_base_type=$price_base_type, pu_ttc=$pu_ttc, type=$type, fk_unit=$fk_unit, pu_ht_devise=$pu_ht_devise", LOG_DEBUG);
1107 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
1114 if ($this->
status == self::STATUS_SUSPENDED) {
1116 $fk_product = empty($fk_product) ? 0 : $fk_product;
1117 $label = empty($label) ?
'' : $label;
1118 $remise_percent = empty($remise_percent) ? 0 :
price2num($remise_percent);
1120 $info_bits = empty($info_bits) ? 0 : $info_bits;
1123 $pu_ht_devise =
price2num($pu_ht_devise);
1125 if (!preg_match(
'/\((.*)\)/', (
string) $txtva)) {
1129 $txlocaltax1 = empty($txlocaltax1) ? 0 :
price2num($txlocaltax1);
1130 $txlocaltax2 = empty($txlocaltax2) ? 0 :
price2num($txlocaltax2);
1131 $this->multicurrency_total_ht = empty($this->multicurrency_total_ht) ? 0 : $this->multicurrency_total_ht;
1132 $this->multicurrency_total_tva = empty($this->multicurrency_total_tva) ? 0 : $this->multicurrency_total_tva;
1133 $this->multicurrency_total_ttc = empty($this->multicurrency_total_ttc) ? 0 : $this->multicurrency_total_ttc;
1135 $pu = $price_base_type ==
'HT' ? $pu_ht : $pu_ttc;
1147 if (preg_match(
'/\((.*)\)/', $txtva, $reg)) {
1148 $vat_src_code = $reg[1];
1149 $txtva = preg_replace(
'/\s*\(.*\)/',
'', $txtva);
1152 $tabprice =
calcul_price_total($qty, $pu, $remise_percent, $txtva, $txlocaltax1, $txlocaltax2, 0, $price_base_type, $info_bits, $type, $mysoc, $localtaxes_type, 100, $this->multicurrency_tx, $pu_ht_devise);
1154 $total_ht = $tabprice[0];
1155 $total_tva = $tabprice[1];
1156 $total_ttc = $tabprice[2];
1157 $total_localtax1 = $tabprice[9];
1158 $total_localtax2 = $tabprice[10];
1159 $pu_ht = $tabprice[3];
1160 $pu_tva = $tabprice[4];
1161 $pu_ttc = $tabprice[5];
1164 $multicurrency_total_ht = $tabprice[16];
1165 $multicurrency_total_tva = $tabprice[17];
1166 $multicurrency_total_ttc = $tabprice[18];
1167 $pu_ht_devise = $tabprice[19];
1169 $product_type = $type;
1171 $product =
new Product($this->db);
1172 $result = $product->fetch($fk_product);
1173 $product_type = $product->type;
1176 $sql =
'UPDATE ' . MAIN_DB_PREFIX .
'facture_fourn_det_rec SET';
1177 $sql .=
' fk_facture_fourn = ' . ((int) $facid);
1178 $sql .=
', fk_product = ' . ($fk_product > 0 ? ((int) $fk_product) :
'null');
1179 $sql .=
", ref = '" . $this->db->escape($ref) .
"'";
1180 $sql .=
", label = '" . $this->db->escape($label) .
"'";
1181 $sql .=
", description = '" . $this->db->escape($desc) .
"'";
1182 $sql .=
', pu_ht = ' .
price2num($pu_ht);
1184 $sql .=
", remise_percent = '" .
price2num($remise_percent) .
"'";
1185 $sql .=
", vat_src_code = '" . $this->db->escape($vat_src_code) .
"'";
1186 $sql .=
', tva_tx = ' .
price2num($txtva);
1187 $sql .=
', localtax1_tx = ' . (float) $txlocaltax1;
1188 $sql .=
", localtax1_type = '" . $this->db->escape($localtaxes_type[0]) .
"'";
1189 $sql .=
', localtax2_tx = ' . (float) $txlocaltax2;
1190 $sql .=
", localtax2_type = '" . $this->db->escape($localtaxes_type[2]) .
"'";
1191 $sql .=
", total_ht = '" .
price2num($total_ht) .
"'";
1192 $sql .=
", total_tva = '" .
price2num($total_tva) .
"'";
1193 $sql .=
", total_localtax1 = '" .
price2num($total_localtax1) .
"'";
1194 $sql .=
", total_localtax2 = '" .
price2num($total_localtax2) .
"'";
1195 $sql .=
", total_ttc = '" .
price2num($total_ttc) .
"'";
1196 $sql .=
', product_type = ' . (int) $product_type;
1197 $sql .=
', date_start = ' . (empty($date_start) ?
'NULL' : (int) $date_start);
1198 $sql .=
', date_end = ' . (empty($date_end) ?
'NULL' : (int) $date_end);
1199 $sql .=
', info_bits = ' . (int) $info_bits;
1200 $sql .=
', special_code = ' . (int) $special_code;
1201 $sql .=
', rang = ' . (int) $rang;
1202 $sql .=
', fk_unit = ' . ($fk_unit ?
"'" . $this->db->escape($fk_unit) .
"'" :
'null');
1203 $sql .=
', fk_user_modif = ' . (int) $user;
1204 $sql .=
', multicurrency_subprice = '.price2num($pu_ht_devise);
1205 $sql .=
', multicurrency_total_ht = '.price2num($multicurrency_total_ht);
1206 $sql .=
', multicurrency_total_tva = '.price2num($multicurrency_total_tva);
1207 $sql .=
', multicurrency_total_ttc = '.price2num($multicurrency_total_ttc);
1208 $sql .=
' WHERE rowid = ' . (int) $rowid;
1210 dol_syslog(get_class($this).
'::updateline', LOG_DEBUG);
1211 if ($this->db->query($sql)) {
1216 $this->error = $this->db->lasterror();
1244 if (empty($this->date_when)) {
1258 if ($this->nb_gen_max > 0 && ($this->nb_gen_done >= $this->nb_gen_max)) {
1273 return ($this->
isMaxNbGenReached() ?
'<strike>' :
'').$ret.($this->isMaxNbGenReached() ?
'</strike>' :
'');
1288 global $conf, $langs, $db, $user, $hookmanager;
1294 $langs->loadLangs(array(
'main',
'bills'));
1298 $today =
dol_mktime(23, 59, 59, $tmparray[
'mon'], $tmparray[
'mday'], $tmparray[
'year']);
1300 dol_syslog(
'createRecurringInvoices restrictioninvoiceid=' .$restrictioninvoiceid.
' forcevalidation=' .$forcevalidation);
1302 $sql =
'SELECT rowid FROM '.MAIN_DB_PREFIX.
'facture_fourn_rec';
1303 $sql .=
' WHERE frequency > 0';
1304 $sql .=
" AND (date_when IS NULL OR date_when <= '".$this->db->idate($today).
"')";
1305 $sql .=
' AND (nb_gen_done < nb_gen_max OR nb_gen_max = 0)';
1306 $sql .=
' AND suspended = 0';
1307 $sql .=
' AND entity = '. (int) $conf->entity;
1308 if ($restrictioninvoiceid > 0) {
1309 $sql .=
' AND rowid = '. (int) $restrictioninvoiceid;
1311 $sql .= $this->db->order(
'entity',
'ASC');
1313 $parameters = array(
1314 'restrictioninvoiceid' => $restrictioninvoiceid,
1315 'forcevalidation' => $forcevalidation,
1317 $reshook = $hookmanager->executeHooks(
'beforeCreationOfRecurringInvoices', $parameters, $sql);
1319 $resql = $this->db->query($sql);
1322 $num = $this->db->num_rows($resql);
1325 $this->output .= $langs->trans(
'FoundXQualifiedRecurringInvoiceTemplate', $num).
"\n";
1327 $this->output .= $langs->trans(
'NoQualifiedRecurringInvoiceTemplateFound');
1330 $saventity = $conf->entity;
1334 $line = $this->db->fetch_object($resql);
1338 $invoiceidgenerated = 0;
1340 $new_fac_fourn =
null;
1342 $laststep =
"Fetch {$line->rowid}";
1343 $facturerec->fetch($line->rowid);
1345 if ($facturerec->id > 0) {
1347 $conf->entity = $facturerec->entity;
1349 dol_syslog(
'createRecurringInvoices Process invoice template id=' .$facturerec->id.
', ref=' .$facturerec->ref.
', entity=' .$facturerec->entity);
1352 $new_fac_fourn->fac_rec = $facturerec->id;
1353 $new_fac_fourn->fk_fac_rec_source = $facturerec->id;
1356 $new_fac_fourn->subtype = $facturerec->subtype;
1359 $new_fac_fourn->date = empty($facturerec->date_when) ? $now : $facturerec->date_when;
1360 $new_fac_fourn->socid = $facturerec->socid;
1361 $new_fac_fourn->lines = $facturerec->lines;
1362 $new_fac_fourn->ref_supplier = $facturerec->ref_supplier;
1363 $new_fac_fourn->model_pdf = $facturerec->model_pdf;
1364 $new_fac_fourn->fk_project = $facturerec->fk_project;
1365 $new_fac_fourn->label = $facturerec->label;
1366 $new_fac_fourn->libelle = $facturerec->label;
1368 $invoiceidgenerated = $new_fac_fourn->create($user);
1369 $laststep =
"Create invoiceidgenerated $invoiceidgenerated";
1370 if ($invoiceidgenerated <= 0) {
1371 $this->errors = $new_fac_fourn->errors;
1372 $this->error = $new_fac_fourn->error;
1375 if (!$error && ($facturerec->auto_validate || $forcevalidation)) {
1376 $result = $new_fac_fourn->validate($user);
1377 $laststep =
"Validate by user {$user->login}";
1379 $this->errors = $new_fac_fourn->errors;
1380 $this->error = $new_fac_fourn->error;
1385 if (!$error && $facturerec->generate_pdf) {
1387 $laststep =
"Refresh ".$new_fac_fourn->id;
1388 $new_fac_fourn->fetch($new_fac_fourn->id);
1389 $laststep =
"GenerateDocument ".$new_fac_fourn->id;
1390 $result = $new_fac_fourn->generateDocument($facturerec->model_pdf, $langs);
1392 $this->errors = $new_fac_fourn->errors;
1393 $this->error = $new_fac_fourn->error;
1399 $this->error =
'Failed to load invoice template with id=' .$line->rowid.
', entity=' .$conf->entity.
"\n";
1400 $this->errors[] =
'Failed to load invoice template with id=' .$line->rowid.
', entity=' .$conf->entity;
1401 dol_syslog(
'createRecurringInvoices Failed to load invoice template with id=' .$line->rowid.
', entity=' .$conf->entity);
1404 if (!$error && $invoiceidgenerated >= 0) {
1405 $facturerec->nb_gen_done++;
1406 $facturerec->date_last_gen =
dol_now();
1407 $facturerec->date_when = $facturerec->getNextDate();
1408 $facturerec->update($user);
1409 $this->db->commit(
'createRecurringInvoices Process invoice template id=' .$facturerec->id.
', title=' .$facturerec->title);
1410 dol_syslog(
'createRecurringInvoices Process invoice template ' .$facturerec->title.
' is finished with a success generation');
1412 $this->output .= $langs->trans(
'InvoiceGeneratedFromTemplate', $new_fac_fourn->ref, $facturerec->title).
"\n";
1414 $this->db->rollback(
'createRecurringInvoices Process invoice template error='.$error.
' invoiceidgenerated='.$invoiceidgenerated.
' LastStep='.$laststep.
' id=' .$facturerec->id.
', title=' .$facturerec->title);
1417 $parameters = array(
1420 'errorCount' => $error,
1421 'invoiceidgenerated' => $invoiceidgenerated,
1422 'facturerec' => $facturerec,
1425 $reshook = $hookmanager->executeHooks(
'afterCreationOfRecurringInvoice', $parameters, $new_fac_fourn);
1430 $conf->entity = $saventity;
1435 $this->output = trim($this->output);
1437 return $error ? $error : 0;
1452 public function getNomUrl($withpicto = 0, $option =
'', $max = 0, $short = 0, $moretitle =
'', $notooltip = 0, $save_lastsearch_value = -1)
1454 global $langs, $hookmanager;
1458 $label =
'<u>'.$langs->trans(
'RepeatableInvoice').
'</u>';
1459 if (!empty($this->
ref)) {
1460 $label .=
'<br><b>'.$langs->trans(
'Ref').
':</b> '.$this->ref;
1462 if ($this->frequency > 0) {
1463 $label .=
'<br><b>'.$langs->trans(
'Frequency').
':</b> '.$langs->trans(
'FrequencyPer_'.$this->unit_frequency, $this->frequency);
1465 if (!empty($this->date_last_gen)) {
1466 $label .=
'<br><b>'.$langs->trans(
'DateLastGeneration').
':</b> '.
dol_print_date($this->date_last_gen,
'dayhour');
1468 if ($this->frequency > 0) {
1469 if (!empty($this->date_when)) {
1470 $label .=
'<br><b>'.$langs->trans(
'NextDateToExecution').
':</b> ';
1471 $label .= (empty($this->suspended) ?
'' :
'<strike>').
dol_print_date($this->date_when,
'day').(empty($this->suspended) ?
'' :
'</strike>');
1472 if (!empty($this->suspended)) {
1473 $label .=
' ('.$langs->trans(
'Disabled').
')';
1478 $url = DOL_URL_ROOT.
'/fourn/facture/card-rec.php?facid='.$this->id;
1484 if ($option !=
'nolink') {
1486 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
1487 if ($save_lastsearch_value == -1 && preg_match(
'/list\.php/', $_SERVER[
'PHP_SELF'])) {
1488 $add_save_lastsearch_values = 1;
1490 if ($add_save_lastsearch_values) {
1491 $url .=
'&save_lastsearch_values=1';
1495 $linkstart =
'<a href="'.$url.
'" title="'.
dol_escape_htmltag($label, 1).
'" class="classfortooltip">';
1498 $result .= $linkstart;
1500 $result .=
img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), ($notooltip ? (($withpicto != 2) ?
'class="paddingright"' :
'') :
'class="'.(($withpicto != 2) ?
'paddingright ' :
'').
'classfortooltip"'), 0, 0, $notooltip ? 0 : 1);
1502 if ($withpicto != 2) {
1503 $result .= $this->ref;
1505 $result .= $linkend;
1507 $hookmanager->initHooks(array($this->element .
'dao'));
1508 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
1509 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
1511 $result = $hookmanager->resPrint;
1513 $result .= $hookmanager->resPrint;
1527 return $this->
LibStatut($this->frequency ? 1 : 0, $this->suspended, $mode, $alreadypaid, empty($this->
type) ? 0 : $this->type);
1541 public function LibStatut($recur, $status, $mode = 0, $alreadypaid = -1, $type = 0)
1545 $langs->load(
'bills');
1547 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1548 $statusType =
'status0';
1553 if ($status == self::STATUS_SUSPENDED) {
1554 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1556 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1559 if ($status == self::STATUS_SUSPENDED) {
1560 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1562 $labelStatus = $langs->transnoentitiesnoconv(
'Draft');
1565 } elseif ($mode == 1) {
1568 if ($status == self::STATUS_SUSPENDED) {
1569 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1571 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1574 if ($status == self::STATUS_SUSPENDED) {
1575 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1577 $labelStatus = $langs->transnoentitiesnoconv(
'Draft');
1580 } elseif ($mode == 2) {
1582 if ($status == self::STATUS_SUSPENDED) {
1583 $statusType =
'status6';
1584 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1586 $statusType =
'status4';
1587 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1590 if ($status == self::STATUS_SUSPENDED) {
1591 $statusType =
'status6';
1592 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1594 $statusType =
'status0';
1595 $labelStatus = $langs->transnoentitiesnoconv(
'Draft');
1598 } elseif ($mode == 3) {
1601 if ($status == self::STATUS_SUSPENDED) {
1602 $statusType =
'status6';
1603 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1605 $statusType =
'status4';
1606 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1609 if ($status == self::STATUS_SUSPENDED) {
1610 $statusType =
'status6';
1611 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1613 $statusType =
'status0';
1614 $labelStatus = $langs->transnoentitiesnoconv(
'Draft');
1617 } elseif ($mode == 4) {
1620 if ($status == self::STATUS_SUSPENDED) {
1621 $statusType =
'status6';
1622 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1624 $statusType =
'status4';
1625 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1628 if ($status == self::STATUS_SUSPENDED) {
1629 $statusType =
'status6';
1630 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1632 $statusType =
'status0';
1633 $labelStatus = $langs->transnoentitiesnoconv(
'Draft');
1636 } elseif ($mode == 5 || $mode == 6) {
1642 if ($status == self::STATUS_SUSPENDED) {
1643 $statusType =
'status6';
1644 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1646 $statusType =
'status4';
1647 $labelStatus = $langs->transnoentitiesnoconv(
'Active');
1650 if ($status == self::STATUS_SUSPENDED) {
1651 $statusType =
'status6';
1652 $labelStatus = $langs->transnoentitiesnoconv(
'Disabled');
1654 $statusType =
'status0';
1655 $labelStatus = $langs->transnoentitiesnoconv(
'Draft');
1660 $labelStatusShort = $labelStatus;
1662 return dolGetStatus($labelStatus, $labelStatusShort,
'', $statusType, $mode);
1675 global $user, $langs, $conf;
1679 $nownotime =
dol_mktime(0, 0, 0, $arraynow[
'mon'], $arraynow[
'mday'], $arraynow[
'year']);
1685 $sql =
'SELECT rowid';
1686 $sql .=
' FROM ' .MAIN_DB_PREFIX.
'product';
1687 $sql .=
' WHERE entity IN (' .getEntity(
'product').
')';
1688 $sql .= $this->db->plimit(100);
1690 $resql = $this->db->query($sql);
1692 $num_prods = $this->db->num_rows($resql);
1694 while ($i < $num_prods) {
1696 $row = $this->db->fetch_row($resql);
1697 $prodids[$i] = $row[0];
1703 $this->
ref =
'SPECIMEN';
1704 $this->title =
'SPECIMEN';
1705 $this->specimen = 1;
1707 $this->date = $nownotime;
1708 $this->date_lim_reglement = $nownotime + 3600 * 24 * 30;
1709 $this->cond_reglement_id = 1;
1710 $this->cond_reglement_code =
'RECEP';
1712 $this->mode_reglement_id = 0;
1713 $this->mode_reglement_code =
'';
1714 $this->note_public =
'This is a comment (public)';
1715 $this->note_private =
'This is a comment (private)';
1716 $this->note =
'This is a comment (private)';
1717 $this->fk_incoterms = 0;
1718 $this->location_incoterms =
'';
1720 if (empty($option) || $option !=
'nolines') {
1724 while ($xnbp < $nbp) {
1726 $line->desc = $langs->trans(
'Description').
' ' .$xnbp;
1728 $line->subprice = 100;
1729 $line->tva_tx = 19.6;
1730 $line->localtax1_tx = 0;
1731 $line->localtax2_tx = 0;
1732 $line->remise_percent = 0;
1734 $prodid = mt_rand(1, $num_prods);
1735 $line->fk_product = $prodids[$prodid];
1737 $line->total_ht = -100;
1738 $line->total_ttc = -119.6;
1739 $line->total_tva = -19.6;
1740 } elseif ($xnbp == 2) {
1741 $line->subprice = -100;
1742 $line->total_ht = -100;
1743 $line->total_ttc = -119.6;
1744 $line->total_tva = -19.6;
1745 $line->remise_percent = 0;
1746 } elseif ($xnbp == 3) {
1747 $prodid = mt_rand(1, $num_prods);
1748 $line->fk_product = $prodids[$prodid];
1749 $line->total_ht = 50;
1750 $line->total_ttc = 59.8;
1751 $line->total_tva = 9.8;
1752 $line->remise_percent = 50;
1754 $prodid = mt_rand(1, $num_prods);
1755 $line->fk_product = $prodids[$prodid];
1756 $line->total_ht = 100;
1757 $line->total_ttc = 119.6;
1758 $line->total_tva = 19.6;
1759 $line->remise_percent = 00;
1762 $this->lines[$xnbp] = $line;
1765 $this->total_ht += $line->total_ht;
1766 $this->total_tva += $line->total_tva;
1767 $this->total_ttc += $line->total_ttc;
1769 $this->revenuestamp = 0;
1773 $line->desc = $langs->trans(
'Description').
' (offered line)';
1775 $line->subprice = 100;
1776 $line->tva_tx = 19.6;
1777 $line->localtax1_tx = 0;
1778 $line->localtax2_tx = 0;
1779 $line->remise_percent = 100;
1780 $line->total_ht = 0;
1781 $line->total_ttc = 0;
1782 $line->total_tva = 0;
1783 $prodid = mt_rand(1, $num_prods);
1784 $line->fk_product = $prodids[$prodid];
1786 $this->lines[$xnbp] = $line;
1790 $this->usenewprice = 0;
1821 if (!$this->table_element) {
1822 dol_syslog(get_class($this).
'::setFrequencyAndUnit was called on object with property table_element not defined', LOG_ERR);
1826 if (!empty($frequency) && empty($unit)) {
1827 dol_syslog(get_class($this).
'::setFrequencyAndUnit was called on object with params frequency defined but unit not defined', LOG_ERR);
1831 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
1832 $sql .=
" SET frequency = ".($frequency ? ((int) $frequency) :
"NULL");
1833 if (!empty($unit)) {
1834 $sql .=
", unit_frequency = '".$this->db->escape($unit).
"'";
1836 $sql .=
" WHERE rowid = ".((int) $this->
id);
1838 dol_syslog(get_class($this).
'::setFrequencyAndUnit', LOG_DEBUG);
1840 if ($this->db->query($sql)) {
1841 $this->frequency = $frequency;
1842 if (!empty($unit)) {
1843 $this->unit_frequency = $unit;
1847 $this->error = $this->db->lasterror();
1861 if (!$this->table_element) {
1862 dol_syslog(get_class($this).
'::setNextDate was called on object with property table_element not defined', LOG_ERR);
1865 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
1866 $sql .=
" SET date_when = " .($date ?
"'".$this->db->idate($date).
"'" :
"NULL");
1867 if ($increment_nb_gen_done > 0) {
1868 $sql .=
", nb_gen_done = nb_gen_done + 1";
1870 $sql .=
" WHERE rowid = " . (int) $this->
id;
1872 dol_syslog(get_class($this).
'::setNextDate', LOG_DEBUG);
1874 if ($this->db->query($sql)) {
1875 $this->date_when = $date;
1876 if ($increment_nb_gen_done > 0) {
1877 $this->nb_gen_done++;
1881 $this->error = $this->db->lasterror();
1894 if (!$this->table_element) {
1895 dol_syslog(get_class($this).
'::setMaxPeriod was called on object with property table_element not defined', LOG_ERR);
1903 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
1904 $sql .=
" SET nb_gen_max = ". (int) $nb;
1905 $sql .=
" WHERE rowid = " . (int) $this->
id;
1907 dol_syslog(get_class($this).
'::setMaxPeriod', LOG_DEBUG);
1909 if ($this->db->query($sql)) {
1910 $this->nb_gen_max = $nb;
1926 if (!$this->table_element) {
1927 dol_syslog(get_class($this).
'::setAutoValidate was called on object with property table_element not defined', LOG_ERR);
1931 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
1932 $sql .=
" SET auto_validate = ".((int) $validate);
1933 $sql .=
" WHERE rowid = " . (int) $this->
id;
1935 dol_syslog(get_class($this).
'::setAutoValidate', LOG_DEBUG);
1937 if ($this->db->query($sql)) {
1938 $this->auto_validate = $validate;
1954 if (!$this->table_element) {
1955 dol_syslog(get_class($this).
'::setGeneratePdf was called on object with property table_element not defined', LOG_ERR);
1959 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
1960 $sql .=
" SET generate_pdf = ". (int) $validate;
1961 $sql .=
" WHERE rowid = " . (int) $this->
id;
1963 dol_syslog(get_class($this).
'::setGeneratePdf', LOG_DEBUG);
1965 if ($this->db->query($sql)) {
1966 $this->generate_pdf = $validate;
1982 if (!$this->table_element) {
1983 dol_syslog(get_class($this).
'::setModelPdf was called on object with property table_element not defined', LOG_ERR);
1987 $sql =
"UPDATE ".MAIN_DB_PREFIX.$this->table_element;
1988 $sql .=
" SET modelpdf = '".$this->db->escape($model).
"'";
1989 $sql .=
" WHERE rowid = " . (int) $this->
id;
1991 dol_syslog(get_class($this).
'::setModelPdf', LOG_DEBUG);
1993 if ($this->db->query($sql)) {
1994 $this->model_pdf = $model;
2014 public $element =
'invoice_supplier_det_rec';
2019 public $table_element =
'facture_fourn_det_rec';
2021 public $fk_facture_fourn;
2024 public $ref_supplier;
2037 public $remise_percent;
2038 public $fk_remise_except;
2039 public $vat_src_code;
2041 public $localtax1_tx;
2042 public $localtax1_type;
2043 public $localtax2_tx;
2044 public $localtax2_type;
2046 public $product_type;
2054 public $special_code;
2057 public $fk_user_author;
2058 public $fk_user_modif;
2068 public function delete(
User $user, $notrigger = 0)
2076 $result = $this->
call_trigger(
'LINESUPPLIERBILLREC_DELETE', $user);
2092 $sql =
'DELETE FROM ' . MAIN_DB_PREFIX . $this->table_element .
' WHERE rowid=' . (int) $this->
id;
2094 $res = $this->db->query($sql);
2095 if ($res ===
false) {
2097 $this->errors[] = $this->db->lasterror();
2103 $this->db->rollback();
2106 $this->db->commit();
2120 $sql =
'SELECT l.rowid,';
2121 $sql .=
' l.fk_facture_fourn, l.fk_parent_line, l.fk_product,';
2122 $sql .=
' l.ref as ref_supplier, l.label, l.description as line_desc, l.pu_ht, l.pu_ttc, l.qty, l.remise_percent, l.fk_remise_except,';
2123 $sql .=
' l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax1_type, l.localtax2_tx, l.localtax2_type,';
2124 $sql .=
' l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc,';
2125 $sql .=
' l.product_type, l.date_start, l.date_end,';
2126 $sql .=
' l.info_bits, l.special_code, l.rang, l.fk_unit, l.import_key,';
2127 $sql .=
' l.fk_user_author, l.fk_user_modif, l.fk_multicurrency,';
2128 $sql .=
' l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc,';
2129 $sql .=
' p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc';
2130 $sql .=
' FROM '.MAIN_DB_PREFIX.
'facture_fourn_det_rec as l';
2131 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'product as p ON l.fk_product = p.rowid';
2132 $sql .=
' WHERE l.rowid = '. (int) $rowid;
2133 $sql .=
' ORDER BY l.rang';
2136 $result = $this->db->query($sql);
2138 $objp = $this->db->fetch_object($result);
2140 $this->
id = $objp->rowid;
2141 $this->fk_facture_fourn = $objp->fk_facture_fourn;
2142 $this->fk_parent = $objp->fk_parent_line;
2143 $this->fk_product = $objp->fk_product;
2144 $this->ref_supplier = $objp->ref_supplier;
2145 $this->label = $objp->label;
2147 $this->desc = $objp->line_desc;
2148 $this->pu_ht = $objp->pu_ht;
2149 $this->pu_ttc = $objp->pu_ttc;
2150 $this->qty = $objp->qty;
2151 $this->remise_percent = $objp->remise_percent;
2152 $this->fk_remise_except = $objp->fk_remise_except;
2153 $this->vat_src_code = $objp->vat_src_code;
2154 $this->tva_tx = $objp->tva_tx;
2155 $this->localtax1_tx = $objp->localtax1_tx;
2156 $this->localtax1_type = $objp->localtax1_type;
2157 $this->localtax2_tx = $objp->localtax2_tx;
2158 $this->localtax2_type = $objp->localtax2_type;
2159 $this->total_ht = $objp->total_ht;
2160 $this->total_tva = $objp->total_tva;
2161 $this->total_localtax1 = $objp->total_localtax1;
2162 $this->total_localtax2 = $objp->total_localtax2;
2163 $this->total_ttc = $objp->total_ttc;
2164 $this->product_type = $objp->product_type;
2165 $this->date_start = $objp->date_start;
2166 $this->date_end = $objp->date_end;
2167 $this->info_bits = $objp->info_bits;
2168 $this->special_code = $objp->special_code;
2169 $this->rang = $objp->rang;
2170 $this->fk_unit = $objp->fk_unit;
2171 $this->import_key = $objp->import_key;
2172 $this->fk_user_author = $objp->fk_user_author;
2173 $this->fk_user_modif = $objp->fk_user_modif;
2174 $this->fk_multicurrency = $objp->fk_multicurrency;
2175 $this->multicurrency_code = $objp->multicurrency_code;
2176 $this->multicurrency_subprice = $objp->multicurrency_subprice;
2177 $this->multicurrency_total_ht = $objp->multicurrency_total_ht;
2178 $this->multicurrency_total_tva = $objp->multicurrency_total_tva;
2179 $this->multicurrency_total_ttc = $objp->multicurrency_total_ttc;
2181 $this->db->free($result);
2184 $this->error = $this->db->lasterror();
2203 include_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
2205 $sql =
'UPDATE ' . MAIN_DB_PREFIX .
'facture_fourn_det_rec SET';
2206 $sql .=
' fk_facture_fourn = ' . (int) $this->fk_facture_fourn;
2207 $sql .=
', fk_parent_line = ' . (int) $this->fk_parent;
2208 $sql .=
', fk_product = ' . (int) $this->fk_product;
2209 $sql .=
', ref = ' . (!empty($this->
ref) ?
"'" . $this->db->escape($this->
ref) .
"'" :
'NULL');
2210 $sql .=
", label = " . (!empty($this->label) ?
"'" . $this->db->escape($this->label) .
"'" :
'NULL');
2211 $sql .=
", description = '" . $this->db->escape($this->desc ? $this->desc :
$this->description) .
"'";
2212 $sql .=
', pu_ht = ' .
price2num($this->pu_ht);
2213 $sql .=
', pu_ttc = ' .
price2num($this->pu_ttc);
2214 $sql .=
', qty = ' .
price2num($this->qty);
2215 $sql .=
", remise_percent = '" .
price2num($this->remise_percent) .
"'";
2216 $sql .=
', fk_remise_except = ' . (int) $this->fk_remise_except;
2217 $sql .=
", vat_src_code = '" . $this->db->escape($this->vat_src_code) .
"'";
2218 $sql .=
', tva_tx = ' .
price2num($this->tva_tx);
2219 $sql .=
', localtax1_tx = ' .
price2num($this->localtax1_tx);
2220 $sql .=
", localtax1_type = '" . $this->db->escape($this->localtax1_type) .
"'";
2221 $sql .=
', localtax2_tx = ' .
price2num($this->localtax2_tx);
2222 $sql .=
", localtax2_type = '" . $this->db->escape($this->localtax2_type) .
"'";
2223 if (empty($this->skip_update_total)) {
2224 $sql .=
', total_ht = ' .
price2num($this->total_ht);
2225 $sql .=
', total_tva = ' .
price2num($this->total_tva);
2226 $sql .=
', total_localtax1 = ' .
price2num($this->total_localtax1);
2227 $sql .=
', total_localtax2 = ' .
price2num($this->total_localtax2);
2228 $sql .=
', total_ttc = ' .
price2num($this->total_ttc);
2230 $sql .=
', product_type = ' . (int) $this->product_type;
2231 $sql .=
', date_start = ' . (int) $this->date_start;
2232 $sql .=
', date_end = ' . (int) $this->date_end;
2233 $sql .=
", info_bits = " . ((int) $this->info_bits);
2234 $sql .=
', special_code =' . (int) $this->special_code;
2235 $sql .=
', rang = ' . (int) $this->rang;
2236 $sql .=
', fk_unit = ' .($this->fk_unit ?
"'".$this->db->escape($this->fk_unit).
"'" :
'null');
2237 $sql .=
', fk_user_modif = ' . (int) $user->id;
2238 $sql .=
' WHERE rowid = ' . (int) $this->
id;
2242 dol_syslog(get_class($this).
'::updateline', LOG_DEBUG);
2243 $resql = $this->db->query($sql);
2252 if (!$error && !$notrigger) {
2254 $result = $this->
call_trigger(
'LINESUPPLIERBILLREC_MODIFY', $user);
2262 $this->db->rollback();
2265 $this->db->commit();
2269 $this->error = $this->db->lasterror();
2270 $this->db->rollback();
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...
Superclass for invoices classes.
const TYPE_STANDARD
Standard invoice.
calculate_date_lim_reglement($cond_reglement=0)
Returns an invoice payment deadline based on the invoice settlement conditions and billing date.
const STATUS_DRAFT
Draft status.
Parent class of all other business classes for details of elements (invoices, contracts,...
fetch_optionals($rowid=null, $optionsArray=null)
Function to get extra fields of an object into $this->array_options This method is in most cases call...
update_price($exclspec=0, $roundingadjust='auto', $nodatabaseupdate=0, $seller=null)
Update total_ht, total_ttc, total_vat, total_localtax1, total_localtax2 for an object (sum of lines).
add_object_linked($origin=null, $origin_id=null, $f_user=null, $notrigger=0)
Add an object link into llx_element_element.
deleteObjectLinked($sourceid=null, $sourcetype='', $targetid=null, $targettype='', $rowid=0, $f_user=null, $notrigger=0)
Delete all links between an object $this.
deleteExtraFields()
Delete all extra fields values for the current object.
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
call_trigger($triggerName, $user)
Call trigger based on this instance.
Class to manage Dolibarr database access.
Class to manage suppliers invoices.
Class to manage supplier invoice lines of templates.
fetch($rowid)
Get line of template invoice.
update(User $user, $notrigger=0)
Update a line to supplier invoice template .
Class to manage invoice templates.
setModelPdf($model)
Update the model for documents.
fetch($rowid, $ref='', $ref_ext='')
Load object and lines.
strikeIfMaxNbGenReached($ret)
Format string to output with by striking the string if max number of generation was reached.
setFrequencyAndUnit($frequency, $unit)
Update frequency and unit.
getNextNumRef($soc, $mode='next')
Return next reference of invoice not already used (or last reference)
create($user, $facFournId, $notrigger=0)
Create a predefined supplier invoice.
setGeneratePdf($validate)
Update the auto generate documents.
getLinesArray()
Create an array of invoice lines.
initAsSpecimen($option='')
Initialise an instance with random values.
LibStatut($recur, $status, $mode=0, $alreadypaid=-1, $type=0)
Return label of a status.
updateline($rowid, $fk_product, $ref, $label, $desc, $pu_ht, $qty, $remise_percent, $txtva, $txlocaltax1=0, $txlocaltax2=0, $price_base_type='HT', $type=0, $date_start=0, $date_end=0, $info_bits=0, $special_code=0, $rang=-1, $fk_unit=null, $pu_ht_devise=0, $pu_ttc=0)
Update a line to supplier invoice template.
isMaxNbGenReached()
Return if maximum number of generation is reached.
setAutoValidate($validate)
Update the auto validate flag of invoice.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
getNextDate()
Return the next date of.
__construct($db)
Constructor.
fetch_lines()
Get lines of template invoices into this->lines.
getLibStatut($mode=0, $alreadypaid=-1)
Return label of object status.
setNextDate($date, $increment_nb_gen_done=0)
Update the next date of execution.
setMaxPeriod($nb)
Update the maximum period.
createRecurringInvoices($restrictioninvoiceid=0, $forcevalidation=0)
Create all recurrents supplier invoices (for all entities if multicompany is used).
update(User $user, $notrigger=0)
Update fourn_invoice_rec.
addline($fk_product, $ref, $label, $desc, $pu_ht, $pu_ttc, $qty, $remise_percent, $txtva, $txlocaltax1=0, $txlocaltax2=0, $price_base_type='HT', $type=0, $date_start=0, $date_end=0, $info_bits=0, $special_code=0, $rang=-1, $fk_unit=null, $pu_ht_devise=0)
Add a line to recursive supplier invoice.
getNomUrl($withpicto=0, $option='', $max=0, $short=0, $moretitle='', $notooltip=0, $save_lastsearch_value=-1)
Return clicable name (with picto eventually)
Class to manage invoice lines.
Class to manage products or services.
Class to manage Dolibarr users.
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_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_now($mode='auto')
Return date for now.
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_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_getdate($timestamp, $fast=false, $forcetimezone='')
Return an array with locale date info.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
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