* Copyright (C) 2010-2011 Laurent Destailleur * Copyright (C) 2012-2013 Christophe Battarel * Copyright (C) 2012 Cédric Salvador * Copyright (C) 2012-2014 Raphaël Doursenaud * Copyright (C) 2013 Florian Henry * Copyright (C) 2017 Juanjo Menent * Copyright (C) 2022 OpenDSI * Copyright (C) 2024 MDW * Copyright (C) 2024 Alexandre Spangaro * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see . * * Need to have the following variables defined: * $object (invoice, order, ...) * $conf * $langs * $dateSelector * $forceall (0 by default, 1 for supplier invoices/orders) * $element (used to test $user->rights->$element->creer) * $permtoedit (used to replace test $user->rights->$element->creer) * $senderissupplier (0 by default, 1 for supplier invoices/orders) * $inputalsopricewithtax (0 by default, 1 to also show column with unit price including tax) * $outputalsopricetotalwithtax * $usemargins (0 to disable all margins columns, 1 to show according to margin setup) * $disableedit, $disablemove, $disableremove * * $text, $description, $line */ // Protection to avoid direct call of template if (empty($object) || !is_object($object)) { print "Error, template page can't be called as URL"; exit(1); } '@phan-var-force CommonObject $this @phan-var-force CommonObject $object @phan-var-force 0|1 $forceall @phan-var-force int $num '; global $mysoc; global $forceall, $senderissupplier, $inputalsopricewithtax, $outputalsopricetotalwithtax; $usemargins = 0; if (isModEnabled('margin') && !empty($object->element) && in_array($object->element, array('facture', 'facturerec', 'propal', 'commande'))) { $usemargins = 1; } if (empty($dateSelector)) { $dateSelector = 0; } if (empty($forceall)) { $forceall = 0; } if (empty($senderissupplier)) { $senderissupplier = 0; } if (empty($inputalsopricewithtax)) { $inputalsopricewithtax = 0; } if (empty($outputalsopricetotalwithtax)) { $outputalsopricetotalwithtax = 0; } // add html5 elements $domData = ' data-element="'.$line->element.'"'; $domData .= ' data-id="'.$line->id.'"'; $domData .= ' data-qty="'.$line->qty.'"'; $domData .= ' data-product_type="'.$line->product_type.'"'; $sign = 1; // @phan-suppress-next-line PhanUndeclaredConstantOfClass if (getDolGlobalString('INVOICE_POSITIVE_CREDIT_NOTE_SCREEN') && in_array($object->element, array('facture', 'invoice_supplier')) && $object->type == $object::TYPE_CREDIT_NOTE) { $sign = -1; } $coldisplay = 0; ?> >

info_bits & 2) == 2) { print ''; $txt = ''; print img_object($langs->trans("ShowReduc"), 'reduc').' '; if ($line->description == '(DEPOSIT)') { $txt = $langs->trans("Deposit"); } elseif ($line->description == '(EXCESS RECEIVED)') { $txt = $langs->trans("ExcessReceived"); } elseif ($line->description == '(EXCESS PAID)') { $txt = $langs->trans("ExcessPaid"); } //else $txt=$langs->trans("Discount"); print $txt; print ''; if ($line->description) { if ($line->description == '(CREDIT_NOTE)' && $line->fk_remise_except > 0) { include_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php'; $discount = new DiscountAbsolute($this->db); $discount->fetch($line->fk_remise_except); print($txt ? ' - ' : '').$langs->transnoentities("DiscountFromCreditNote", $discount->getNomUrl(0)); } elseif ($line->description == '(DEPOSIT)' && $line->fk_remise_except > 0) { include_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php'; $discount = new DiscountAbsolute($this->db); $discount->fetch($line->fk_remise_except); print($txt ? ' - ' : '').$langs->transnoentities("DiscountFromDeposit", $discount->getNomUrl(0)); // Add date of deposit if (getDolGlobalString('INVOICE_ADD_DEPOSIT_DATE')) { print ' ('.dol_print_date($discount->datec).')'; } } elseif ($line->description == '(EXCESS RECEIVED)' && $objp->fk_remise_except > 0) { include_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php'; $discount = new DiscountAbsolute($this->db); $discount->fetch($line->fk_remise_except); print($txt ? ' - ' : '').$langs->transnoentities("DiscountFromExcessReceived", $discount->getNomUrl(0)); } elseif ($line->description == '(EXCESS PAID)' && $objp->fk_remise_except > 0) { include_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php'; $discount = new DiscountAbsolute($this->db); $discount->fetch($line->fk_remise_except); print($txt ? ' - ' : '').$langs->transnoentities("DiscountFromExcessPaid", $discount->getNomUrl(0)); } else { print($txt ? ' - ' : '').dol_htmlentitiesbr($line->description); } } } else { $format = (getDolGlobalString('MAIN_USE_HOURMIN_IN_DATE_RANGE') ? 'dayhour' : 'day'); if ($line->fk_product > 0) { if (getDolGlobalInt('MAIN_ENABLE_AJAX_TOOLTIP')) { print (!empty($line->fk_parent_line) ? img_picto('', 'rightarrow') : '') . $text; if (!getDolGlobalInt('PRODUIT_DESC_IN_FORM')) { print $form->textwithpicto('', $description); } } else { print $form->textwithtooltip($text, $description, 3, 0, '', $i, 0, (!empty($line->fk_parent_line) ? img_picto('', 'rightarrow') : '')); } } else { $type = (!empty($line->product_type) ? $line->product_type : $line->fk_product_type); if ($type == 1) { $text = img_object($langs->trans('Service'), 'service'); } else { $text = img_object($langs->trans('Product'), 'product'); } if (!empty($line->label)) { $text .= ' '.$line->label.''; print $form->textwithtooltip($text, dol_htmlentitiesbr($line->description), 3, 0, '', $i, 0, (!empty($line->fk_parent_line) ? img_picto('', 'rightarrow') : '')); } else { if (!empty($line->fk_parent_line)) { print img_picto('', 'rightarrow'); } if (preg_match('/^$DEPOSIT$/', $line->description)) { $newdesc = preg_replace('/^$DEPOSIT$/', $langs->trans("Deposit"), $line->description); print $text.' '.dol_htmlentitiesbr($newdesc); } else { print $text.' '.dol_htmlentitiesbr($line->description); } } } // Show date range if ($line->element == 'facturedetrec' || $line->element == 'invoice_supplier_det_rec') { if ($line->element == 'invoice_supplier_det_rec' && $line->product_type != Product::TYPE_PRODUCT) { $line->date_start_fill = $line->date_start; $line->date_end_fill = $line->date_end; } if ($line->date_start_fill || $line->date_end_fill) { print '

'; } if ($line->date_start_fill) { print ''.$langs->trans('AutoFillDateFromShort').': '.yn($line->date_start_fill); } if ($line->date_start_fill && $line->date_end_fill) { print ' - '; } if ($line->date_end_fill) { print ''.$langs->trans('AutoFillDateToShort').': '.yn($line->date_end_fill); } if ($line->date_start_fill || $line->date_end_fill) { print '

'; } } else { if ($line->date_start || $line->date_end) { print '

'.get_date_range($line->date_start, $line->date_end, $format).'

'; } if (!$line->date_start || !$line->date_end) { // show warning under line // we need to fetch product associated to line for some test if ($object->element == 'propal' || $object->element == 'order' || $object->element == 'facture' || $object->element == 'propal_supplier' || $object->element == 'supplier_proposal' || $object->element == 'commande') { $res = $line->fetch_product(); if ($res > 0) { if ($line->product->isService() && $line->product->isMandatoryPeriod()) { print '

'.$langs->trans("mandatoryPeriodNeedTobeSet").'

'; } } } } // If we show the lines in a context to create a recurring sale invoice if (basename($_SERVER["PHP_SELF"]) == 'card-rec.php') { $default_start_fill = getDolGlobalInt('INVOICEREC_SET_AUTOFILL_DATE_START'); $default_end_fill = getDolGlobalInt('INVOICEREC_SET_AUTOFILL_DATE_END'); print '

'; print ''.$langs->trans('AutoFillDateFromShort').': '.yn($default_start_fill); print ' - '; print ''.$langs->trans('AutoFillDateToShort').': '.yn($default_end_fill); print '

'; } } // Add description in form if ($line->fk_product > 0 && getDolGlobalInt('PRODUIT_DESC_IN_FORM_ACCORDING_TO_DEVICE')) { if ($line->element == 'facturedetrec') { print (!empty($line->description) && $line->description != $line->product_label) ? (($line->date_start_fill || $line->date_end_fill) ? '' : '
').'
'.dol_htmlentitiesbr($line->description) : ''; } elseif ($line->element == 'invoice_supplier_det_rec') { print (!empty($line->description) && $line->description != $line->label) ? (($line->date_start || $line->date_end) ? '' : '
').'
'.dol_htmlentitiesbr($line->description) : ''; } else { print (!empty($line->description) && $line->description != $line->product_label) ? (($line->date_start || $line->date_end) ? '' : '
').'
'.dol_htmlentitiesbr($line->description) : ''; } } // Line extrafield if (!empty($extrafields)) { $temps = $line->showOptionals($extrafields, 'view', array(), '', '', 1, 'line'); if (!empty($temps)) { print '

'; print $temps; print '

'; } } } if ($user->hasRight('fournisseur', 'lire') && isset($line->fk_fournprice) && $line->fk_fournprice > 0 && !getDolGlobalString('SUPPLIER_HIDE_SUPPLIER_OBJECTLINES')) { require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.product.class.php'; $productfourn = new ProductFournisseur($this->db); $productfourn->fetch_product_fournisseur_price($line->fk_fournprice); print '

'; print ''.$langs->trans('Supplier').' : '.$productfourn->getSocNomUrl(1, 'supplier').' - '.$langs->trans('Ref').' : '; // Supplier ref if ($user->hasRight('produit', 'creer') || $user->hasRight('service', 'creer')) { // change required right here print $productfourn->getNomUrl(); } else { print $productfourn->ref_supplier; } } if (isModEnabled('accounting') && !empty($line->fk_accounting_account) && $line->fk_accounting_account > 0) { $accountingaccount = new AccountingAccount($this->db); $accountingaccount->fetch($line->fk_accounting_account); print '

'.$langs->trans('AccountingAffectation').' : '.$accountingaccount->getNomUrl(0, 1, 1); } print ''; // Vendor price ref if ($object->element == 'supplier_proposal' || $object->element == 'order_supplier' || $object->element == 'invoice_supplier' || $object->element == 'invoice_supplier_rec') { // We must have same test in printObjectLines print ''; print($line->ref_fourn ? $line->ref_fourn : $line->ref_supplier); print ''; } $tooltiponprice = ''; $tooltiponpriceend = ''; if (!getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) { $tooltiponprice = $langs->transcountry("TotalHT", $mysoc->country_code).'='.price($line->total_ht); $tooltiponprice .= '
'.$langs->transcountry("TotalVAT", ($senderissupplier ? $object->thirdparty->country_code : $mysoc->country_code)).'='.price($line->total_tva); if (is_object($object->thirdparty)) { if ($senderissupplier) { $seller = $object->thirdparty; $buyer = $mysoc; } else { $seller = $mysoc; $buyer = $object->thirdparty; } if ($mysoc->useLocalTax(1)) { if (($seller->country_code == $buyer->country_code) || $line->total_localtax1 || $seller->useLocalTax(1)) { $tooltiponprice .= '
'.$langs->transcountry("TotalLT1", $seller->country_code).'='.price($line->total_localtax1); } else { $tooltiponprice .= '
'.$langs->transcountry("TotalLT1", $seller->country_code).'='.$langs->trans($senderissupplier ? "NotUsedForThisVendor" : "NotUsedForThisCustomer").''; } } if ($mysoc->useLocalTax(2)) { if ((isset($seller->country_code) && isset($buyer->thirdparty->country_code) && $seller->country_code == $buyer->thirdparty->country_code) || $line->total_localtax2 || $seller->useLocalTax(2)) { $tooltiponprice .= '
'.$langs->transcountry("TotalLT2", $seller->country_code).'='.price($line->total_localtax2); } else { $tooltiponprice .= '
'.$langs->transcountry("TotalLT2", $seller->country_code).'='.$langs->trans($senderissupplier ? "NotUsedForThisVendor" : "NotUsedForThisCustomer").''; } } } $tooltiponprice .= '
'.$langs->transcountry("TotalTTC", $mysoc->country_code).'='.price($line->total_ttc); $tooltiponprice = ''; $tooltiponpriceend = ''; } // VAT Rate print ''; $coldisplay++; $positiverates = ''; if (price2num($line->tva_tx)) { $positiverates .= ($positiverates ? '/' : '').price2num($line->tva_tx); } if (price2num($line->total_localtax1)) { $positiverates .= ($positiverates ? '/' : '').price2num($line->localtax1_tx); } if (price2num($line->total_localtax2)) { $positiverates .= ($positiverates ? '/' : '').price2num($line->localtax2_tx); } if (empty($positiverates)) { $positiverates = '0'; } print $tooltiponprice; print vatrate($positiverates.($line->vat_src_code ? ' ('.$line->vat_src_code.')' : ''), '%', $line->info_bits); print $tooltiponpriceend; ?> subprice); ?> multicurrency_code != $conf->currency) { ?> multicurrency_subprice); ?> pu_ttc) ? $line->pu_ttc : null; if (getDolGlobalInt('MAIN_UNIT_PRICE_WITH_TAX_IS_FOR_ALL_TAXES')) { $upinctax = price2num($line->total_ttc / (float) $line->qty, 'MU'); } print(isset($upinctax) ? price($sign * $upinctax) : price($sign * $line->subprice)); ?> info_bits & 2) != 2) && $line->special_code != 3) { // I comment this because it shows info even when not required // for example always visible on invoice but must be visible only if stock module on and stock decrease option is on invoice validation and status is not validated // must also not be output for most entities (proposal, intervention, ...) //if($line->qty > $line->stock) print img_picto($langs->trans("StockTooLow"),"warning", 'style="vertical-align: bottom;"')." "; print price($line->qty, 0, '', 0, 0); // Yes, it is a quantity, not a price, but we just want the formatting role of function price } else { print ' '; } print ''; if (getDolGlobalString('PRODUCT_USE_UNITS')) { print ''; $label = $line->getLabelOfUnit('short'); if ($label !== '') { print $langs->trans($label); } print ''; } if (!empty($line->remise_percent) && $line->special_code != 3) { print ''; $coldisplay++; include_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php'; print dol_print_reduction($line->remise_percent, $langs); print ''; } else { print ' '; $coldisplay++; } // Fields for situation invoices if (isset($this->situation_cycle_ref) && $this->situation_cycle_ref) { include_once DOL_DOCUMENT_ROOT.'/core/lib/price.lib.php'; $coldisplay++; if (getDolGlobalInt('INVOICE_USE_SITUATION') == 2) { $previous_progress = $line->get_allprev_progress($object->id); $current_progress = $previous_progress + floatval($line->situation_percent); print ''.$current_progress.'%'; $coldisplay++; print ''.$line->situation_percent.'%'; $coldisplay++; $locataxes_array = getLocalTaxesFromRate($line->tva.($line->vat_src_code ? ' ('.$line->vat_src_code.')' : ''), 0, ($senderissupplier ? $mysoc : $object->thirdparty), ($senderissupplier ? $object->thirdparty : $mysoc)); $tmp = calcul_price_total($line->qty, $line->pu, $line->remise_percent, $line->txtva, -1, -1, 0, 'HT', $line->info_bits, $line->type, ($senderissupplier ? $object->thirdparty : $mysoc), $locataxes_array, 100, $object->multicurrency_tx, $line->multicurrency_subprice); print ''.price($sign * $tmp[0]).''; } else { print ''.$line->situation_percent.'%'; $coldisplay++; $locataxes_array = getLocalTaxesFromRate($line->tva.($line->vat_src_code ? ' ('.$line->vat_src_code.')' : ''), 0, ($senderissupplier ? $mysoc : $object->thirdparty), ($senderissupplier ? $object->thirdparty : $mysoc)); $tmp = calcul_price_total($line->qty, $line->pu, $line->remise_percent, $line->txtva, -1, -1, 0, 'HT', $line->info_bits, $line->type, ($senderissupplier ? $object->thirdparty : $mysoc), $locataxes_array, 100, $object->multicurrency_tx, $line->multicurrency_subprice); print ''.price($sign * $tmp[0]).''; } } if ($usemargins && isModEnabled('margin') && empty($user->socid)) { if ($user->hasRight('margins', 'creer')) { ?> pa_ht); ?> hasRight('margins', 'liretous')) { ?> pa_ht == 0) ? 'n/a' : price(price2num($line->marge_tx, 'MT')).'%'); ?> hasRight('margins', 'liretous')) {?> marque_tx, 'MT')).'%'; ?> special_code == 3) { $coldisplay++; $colspanOptions = ''; if (!empty($conf->multicurrency->enabled) && $object->multicurrency_code != $conf->currency) { $coldisplay++; $colspanOptions = ' colspan="2"'; } print ''.$langs->trans('Option').''; } else { print ''; $coldisplay++; print $tooltiponprice; print price($sign * $line->total_ht); print $tooltiponpriceend; print ''; if (isModEnabled("multicurrency") && $this->multicurrency_code != $conf->currency) { print ''.price($sign * $line->multicurrency_total_ht).''; $coldisplay++; } } // Price inc tax if ($outputalsopricetotalwithtax) { print ''.price($sign * $line->total_ttc).''; $coldisplay++; } // TODO Replace this with $permissiontoedit ? $objectRights = $this->getRights(); $tmppermtoedit = $objectRights->creer; if ($this->status == 0 && $tmppermtoedit && $action != 'selectlines') { $situationinvoicelinewithparent = 0; if (isset($line->fk_prev_id) && in_array($object->element, array('facture', 'facturedet'))) { // @phan-suppress-next-line PhanUndeclaredConstantOfClass if ($object->type == $object::TYPE_SITUATION) { // The constant TYPE_SITUATION exists only for object invoice // Set constant to disallow editing during a situation cycle $situationinvoicelinewithparent = 1; } } // Asset info if (isModEnabled('asset') && $object->element == 'invoice_supplier') { print ''; $coldisplay++; if (!empty($product_static->accountancy_code_buy) || !empty($product_static->accountancy_code_buy_intra) || !empty($product_static->accountancy_code_buy_export) ) { $accountancy_category_asset = getDolGlobalString('ASSET_ACCOUNTANCY_CATEGORY'); $filters = array(); if (!empty($product_static->accountancy_code_buy)) { $filters[] = "account_number = '" . $this->db->escape($product_static->accountancy_code_buy) . "'"; } if (!empty($product_static->accountancy_code_buy_intra)) { $filters[] = "account_number = '" . $this->db->escape($product_static->accountancy_code_buy_intra) . "'"; } if (!empty($product_static->accountancy_code_buy_export)) { $filters[] = "account_number = '" . $this->db->escape($product_static->accountancy_code_buy_export) . "'"; } $sql = "SELECT COUNT(*) AS found"; $sql .= " FROM " . MAIN_DB_PREFIX . "accounting_account"; $sql .= " WHERE pcg_type = '" . $this->db->escape($conf->global->ASSET_ACCOUNTANCY_CATEGORY) . "'"; $sql .= " AND (" . implode(' OR ', $filters). ")"; $resql_asset = $this->db->query($sql); if (!$resql_asset) { print 'Error SQL: ' . $this->db->lasterror(); } elseif ($obj = $this->db->fetch_object($resql_asset)) { if (!empty($obj->found)) { print ''; print img_edit_add() . ''; } } } print ''; } // Edit picto print ''; $coldisplay++; if (($line->info_bits & 2) == 2 || !empty($disableedit)) { } else { ?> id; ?>"> '; } print ''; // Delete picto print ''; $coldisplay++; if (!$situationinvoicelinewithparent && empty($disableremove)) { // For situation invoice, deletion is not possible if there is a parent company. print 'id.'">'; print img_delete(); print ''; } print ''; // Move up-down picto if ($num > 1 && $conf->browser->layout != 'phone' && ((property_exists($this, 'situation_counter') && $this->situation_counter == 1) || empty($this->situation_cycle_ref)) && empty($disablemove)) { print ''; $coldisplay++; if ($i > 0) { ?> id; ?>"> id; ?>"> '; } else { print 'browser->layout != 'phone' && empty($disablemove)) ? ' class="linecolmove tdlineupdown center"' : ' class="linecolmove center"').'>'; $coldisplay++; } } else { $colspan = 3; if (isModEnabled('asset') && $object->element == 'invoice_supplier') { $colspan++; } print ''; $coldisplay += $colspan; } if ($action == 'selectlines') { ?> \n"; print "\n";