dolibarr  16.0.5
objectline_view.tpl.php
1 <?php
2 /* Copyright (C) 2010-2013 Regis Houssin <regis.houssin@inodbox.com>
3  * Copyright (C) 2010-2011 Laurent Destailleur <eldy@users.sourceforge.net>
4  * Copyright (C) 2012-2013 Christophe Battarel <christophe.battarel@altairis.fr>
5  * Copyright (C) 2012 Cédric Salvador <csalvador@gpcsolutions.fr>
6  * Copyright (C) 2012-2014 Raphaël Doursenaud <rdoursenaud@gpcsolutions.fr>
7  * Copyright (C) 2013 Florian Henry <florian.henry@open-concept.pro>
8  * Copyright (C) 2017 Juanjo Menent <jmenent@2byte.es>
9  * Copyright (C) 2022 OpenDSI <support@open-dsi.fr>
10  *
11  * This program is free software; you can redistribute it and/or modify
12  * it under the terms of the GNU General Public License as published by
13  * the Free Software Foundation; either version 3 of the License, or
14  * (at your option) any later version.
15  *
16  * This program is distributed in the hope that it will be useful,
17  * but WITHOUT ANY WARRANTY; without even the implied warranty of
18  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19  * GNU General Public License for more details.
20  *
21  * You should have received a copy of the GNU General Public License
22  * along with this program. If not, see <https://www.gnu.org/licenses/>.
23  *
24  * Need to have following variables defined:
25  * $object (invoice, order, ...)
26  * $conf
27  * $langs
28  * $dateSelector
29  * $forceall (0 by default, 1 for supplier invoices/orders)
30  * $element (used to test $user->rights->$element->creer)
31  * $permtoedit (used to replace test $user->rights->$element->creer)
32  * $senderissupplier (0 by default, 1 for supplier invoices/orders)
33  * $inputalsopricewithtax (0 by default, 1 to also show column with unit price including tax)
34  * $outputalsopricetotalwithtax
35  * $usemargins (0 to disable all margins columns, 1 to show according to margin setup)
36  * $object_rights->creer initialized from = $object->getRights()
37  * $disableedit, $disablemove, $disableremove
38  *
39  * $text, $description, $line
40  */
41 
42 // Protection to avoid direct call of template
43 if (empty($object) || !is_object($object)) {
44  print "Error, template page can't be called as URL";
45  exit;
46 }
47 
48 global $mysoc;
49 global $forceall, $senderissupplier, $inputalsopricewithtax, $outputalsopricetotalwithtax;
50 
51 $usemargins = 0;
52 if (!empty($conf->margin->enabled) && !empty($object->element) && in_array($object->element, array('facture', 'facturerec', 'propal', 'commande'))) {
53  $usemargins = 1;
54 }
55 
56 if (empty($dateSelector)) {
57  $dateSelector = 0;
58 }
59 if (empty($forceall)) {
60  $forceall = 0;
61 }
62 if (empty($senderissupplier)) {
63  $senderissupplier = 0;
64 }
65 if (empty($inputalsopricewithtax)) {
66  $inputalsopricewithtax = 0;
67 }
68 if (empty($outputalsopricetotalwithtax)) {
69  $outputalsopricetotalwithtax = 0;
70 }
71 
72 // add html5 elements
73 $domData = ' data-element="'.$line->element.'"';
74 $domData .= ' data-id="'.$line->id.'"';
75 $domData .= ' data-qty="'.$line->qty.'"';
76 $domData .= ' data-product_type="'.$line->product_type.'"';
77 
78 $sign = 1;
79 if (!empty($conf->global->INVOICE_POSITIVE_CREDIT_NOTE_SCREEN) && in_array($object->element, array('facture', 'invoice_supplier')) && $object->type == $object::TYPE_CREDIT_NOTE) {
80  $sign = -1;
81 }
82 
83 
84 $coldisplay = 0;
85 ?>
86 <!-- BEGIN PHP TEMPLATE objectline_view.tpl.php -->
87 <tr id="row-<?php print $line->id?>" class="drag drop oddeven" <?php print $domData; ?> >
88 <?php if (!empty($conf->global->MAIN_VIEW_LINE_NUMBER)) { ?>
89  <td class="linecolnum center"><span class="opacitymedium"><?php $coldisplay++; ?><?php print ($i + 1); ?></span></td>
90 <?php } ?>
91  <td class="linecoldescription minwidth300imp"><?php $coldisplay++; ?><div id="line_<?php print $line->id; ?>"></div>
92 <?php
93 if (($line->info_bits & 2) == 2) {
94  print '<a href="'.DOL_URL_ROOT.'/comm/remx.php?id='.$this->socid.'">';
95  $txt = '';
96  print img_object($langs->trans("ShowReduc"), 'reduc').' ';
97  if ($line->description == '(DEPOSIT)') {
98  $txt = $langs->trans("Deposit");
99  } elseif ($line->description == '(EXCESS RECEIVED)') {
100  $txt = $langs->trans("ExcessReceived");
101  } elseif ($line->description == '(EXCESS PAID)') {
102  $txt = $langs->trans("ExcessPaid");
103  }
104  //else $txt=$langs->trans("Discount");
105  print $txt;
106  print '</a>';
107  if ($line->description) {
108  if ($line->description == '(CREDIT_NOTE)' && $line->fk_remise_except > 0) {
109  include_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php';
110  $discount = new DiscountAbsolute($this->db);
111  $discount->fetch($line->fk_remise_except);
112  print ($txt ? ' - ' : '').$langs->transnoentities("DiscountFromCreditNote", $discount->getNomUrl(0));
113  } elseif ($line->description == '(DEPOSIT)' && $line->fk_remise_except > 0) {
114  include_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php';
115  $discount = new DiscountAbsolute($this->db);
116  $discount->fetch($line->fk_remise_except);
117  print ($txt ? ' - ' : '').$langs->transnoentities("DiscountFromDeposit", $discount->getNomUrl(0));
118  // Add date of deposit
119  if (!empty($conf->global->INVOICE_ADD_DEPOSIT_DATE)) {
120  print ' ('.dol_print_date($discount->datec).')';
121  }
122  } elseif ($line->description == '(EXCESS RECEIVED)' && $objp->fk_remise_except > 0) {
123  include_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php';
124  $discount = new DiscountAbsolute($this->db);
125  $discount->fetch($line->fk_remise_except);
126  print ($txt ? ' - ' : '').$langs->transnoentities("DiscountFromExcessReceived", $discount->getNomUrl(0));
127  } elseif ($line->description == '(EXCESS PAID)' && $objp->fk_remise_except > 0) {
128  include_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php';
129  $discount = new DiscountAbsolute($this->db);
130  $discount->fetch($line->fk_remise_except);
131  print ($txt ? ' - ' : '').$langs->transnoentities("DiscountFromExcessPaid", $discount->getNomUrl(0));
132  } else {
133  print ($txt ? ' - ' : '').dol_htmlentitiesbr($line->description);
134  }
135  }
136 } else {
137  $format = (!empty($conf->global->MAIN_USE_HOURMIN_IN_DATE_RANGE) ? 'dayhour' : 'day');
138 
139  if ($line->fk_product > 0) {
140  print $form->textwithtooltip($text, $description, 3, 0, '', $i, 0, (!empty($line->fk_parent_line) ?img_picto('', 'rightarrow') : ''));
141  } else {
142  $type = (!empty($line->product_type) ? $line->product_type : $line->fk_product_type);
143  if ($type == 1) {
144  $text = img_object($langs->trans('Service'), 'service');
145  } else {
146  $text = img_object($langs->trans('Product'), 'product');
147  }
148 
149  if (!empty($line->label)) {
150  $text .= ' <strong>'.$line->label.'</strong>';
151  print $form->textwithtooltip($text, dol_htmlentitiesbr($line->description), 3, 0, '', $i, 0, (!empty($line->fk_parent_line) ?img_picto('', 'rightarrow') : ''));
152  } else {
153  if (!empty($line->fk_parent_line)) {
154  print img_picto('', 'rightarrow');
155  }
156  if (preg_match('/^\(DEPOSIT\)/', $line->description)) {
157  $newdesc = preg_replace('/^\(DEPOSIT\)/', $langs->trans("Deposit"), $line->description);
158  print $text.' '.dol_htmlentitiesbr($newdesc);
159  } else {
160  print $text.' '.dol_htmlentitiesbr($line->description);
161  }
162  }
163  }
164 
165  // Show date range
166  if ($line->element == 'facturedetrec' || $line->element == 'invoice_supplier_det_rec') {
167  if ($line->element == 'invoice_supplier_det_rec' && $line->product_type != Product::TYPE_PRODUCT) {
168  $line->date_start_fill = $line->date_start;
169  $line->date_end_fill = $line->date_end;
170  }
171  if ($line->date_start_fill || $line->date_end_fill) {
172  print '<div class="clearboth nowraponall daterangeofline-facturedetrec">';
173  }
174  if ($line->date_start_fill) {
175  print '<span class="opacitymedium" title="'.dol_escape_htmltag($langs->trans("AutoFillDateFrom")).'">'.$langs->trans('AutoFillDateFromShort').':</span> '.yn($line->date_start_fill);
176  }
177  if ($line->date_start_fill && $line->date_end_fill) {
178  print ' - ';
179  }
180  if ($line->date_end_fill) {
181  print '<span class="opacitymedium" title="'.dol_escape_htmltag($langs->trans("AutoFillDateTo")).'">'.$langs->trans('AutoFillDateToShort').':</span> '.yn($line->date_end_fill);
182  }
183  if ($line->date_start_fill || $line->date_end_fill) {
184  print '</div>';
185  }
186  } else {
187  if ($line->date_start || $line->date_end) {
188  print '<div class="clearboth nowraponall opacitymedium daterangeofline">'.get_date_range($line->date_start, $line->date_end, $format).'</div>';
189  }
190 
191  if (!$line->date_start || !$line->date_end) {
192  // show warning under line
193  // we need to fetch product associated to line for some test
194  if ($object->element == 'propal' || $object->element == 'order' || $object->element == 'facture' || $object->element == 'propal_supplier' || $object->element == 'supplier_proposal' || $object->element == 'commande') {
195  $res = $line->fetch_product();
196  if ($res > 0 ) {
197  if ($line->product->isService() && $line->product->isMandatoryPeriod()) {
198  print '<div><span class="clearboth nowraponall warning">'.$langs->trans("mandatoryPeriodNeedTobeSet").'</span></div>';
199  }
200  }
201  }
202  }
203 
204  // If we show the lines in a context to create a recurring sale invoice
205  if (basename($_SERVER["PHP_SELF"]) == 'card-rec.php') {
206  $default_start_fill = getDolGlobalInt('INVOICEREC_SET_AUTOFILL_DATE_START');
207  $default_end_fill = getDolGlobalInt('INVOICEREC_SET_AUTOFILL_DATE_END');
208  print '<div class="clearboth nowraponall daterangeofline-facturedetrec">';
209  print '<span class="opacitymedium" title="'.dol_escape_htmltag($langs->trans("AutoFillDateFrom")).'">'.$langs->trans('AutoFillDateFromShort').':</span> '.yn($default_start_fill);
210  print ' - ';
211  print '<span class="opacitymedium" title="'.dol_escape_htmltag($langs->trans("AutoFillDateTo")).'">'.$langs->trans('AutoFillDateToShort').':</span> '.yn($default_end_fill);
212  print '</div>';
213  }
214  }
215 
216  // Add description in form
217  if ($line->fk_product > 0 && !empty($conf->global->PRODUIT_DESC_IN_FORM)) {
218  if ($line->element == 'facturedetrec') {
219  print (!empty($line->description) && $line->description != $line->product_label) ? (($line->date_start_fill || $line->date_end_fill) ? '' : '<br>').'<br>'.dol_htmlentitiesbr($line->description) : '';
220  } elseif ($line->element == 'invoice_supplier_det_rec') {
221  print (!empty($line->description) && $line->description != $line->label) ? (($line->date_start || $line->date_end) ? '' : '<br>').'<br>'.dol_htmlentitiesbr($line->description) : '';
222  } else {
223  print (!empty($line->description) && $line->description != $line->product_label) ? (($line->date_start || $line->date_end) ? '' : '<br>').'<br>'.dol_htmlentitiesbr($line->description) : '';
224  }
225  }
226 
227  // Line extrafield
228  if (!empty($extrafields)) {
229  $temps = $line->showOptionals($extrafields, 'view', array(), '', '', 1, 'line');
230  if (!empty($temps)) {
231  print '<div style="padding-top: 10px" id="extrafield_lines_area_'.$line->id.'" name="extrafield_lines_area_'.$line->id.'">';
232  print $temps;
233  print '</div>';
234  }
235  }
236 }
237 
238 if ($user->rights->fournisseur->lire && $line->fk_fournprice > 0 && empty($conf->global->SUPPLIER_HIDE_SUPPLIER_OBJECTLINES)) {
239  require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.product.class.php';
240  $productfourn = new ProductFournisseur($this->db);
241  $productfourn->fetch_product_fournisseur_price($line->fk_fournprice);
242  print '<div class="clearboth"></div>';
243  print '<span class="opacitymedium">'.$langs->trans('Supplier').' : </span>'.$productfourn->getSocNomUrl(1, 'supplier').' - <span class="opacitymedium">'.$langs->trans('Ref').' : </span>';
244  // Supplier ref
245  if ($user->rights->produit->creer || $user->rights->service->creer) { // change required right here
246  print $productfourn->getNomUrl();
247  } else {
248  print $productfourn->ref_supplier;
249  }
250 }
251 
252 if (!empty($conf->accounting->enabled) && $line->fk_accounting_account > 0) {
253  $accountingaccount = new AccountingAccount($this->db);
254  $accountingaccount->fetch($line->fk_accounting_account);
255  print '<div class="clearboth"></div><br><span class="opacitymedium">'.$langs->trans('AccountingAffectation').' : </span>'.$accountingaccount->getNomUrl(0, 1, 1);
256 }
257 
258 print '</td>';
259 // Vendor price ref
260 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
261  print '<td class="linecolrefsupplier">';
262  print ($line->ref_fourn ? $line->ref_fourn : $line->ref_supplier);
263  print '</td>';
264 }
265 
266 $tooltiponprice = '';
267 $tooltiponpriceend = '';
268 if (empty($conf->global->MAIN_OPTIMIZEFORTEXTBROWSER)) {
269  $tooltiponprice = $langs->transcountry("TotalHT", $mysoc->country_code).'='.price($line->total_ht);
270  $tooltiponprice .= '<br>'.$langs->transcountry("TotalVAT", ($senderissupplier ? $object->thirdparty->country_code : $mysoc->country_code)).'='.price($line->total_tva);
271  $seller = ($senderissupplier ? (is_object($object->thirdparty) ? $object->thirdparty : null) : $mysoc);
272  if ($seller) {
273  if ($seller->useLocalTax(1)) {
274  if (($mysoc->country_code == $object->thirdparty->country_code) || $seller->useLocalTax(1)) {
275  $tooltiponprice .= '<br>'.$langs->transcountry("TotalLT1", ($senderissupplier ? $object->thirdparty->country_code : $mysoc->country_code)).'='.price($line->total_localtax1);
276  } else {
277  $tooltiponprice .= '<br>'.$langs->transcountry("TotalLT1", ($senderissupplier ? $object->thirdparty->country_code : $mysoc->country_code)).'=<span class="opacitymedium">'.$langs->trans("NotUsedForThis".($senderissupplier ? "Vendor" : "Customer")).'</span>';
278  }
279  }
280  if ($seller->useLocalTax(2)) {
281  if (($mysoc->country_code == $object->thirdparty->country_code) || $seller->useLocalTax(2)) {
282  $tooltiponprice .= '<br>'.$langs->transcountry("TotalLT2", ($senderissupplier ? $object->thirdparty->country_code : $mysoc->country_code)).'='.price($line->total_localtax2);
283  } else {
284  $tooltiponprice .= '<br>'.$langs->transcountry("TotalLT2", ($senderissupplier ? $object->thirdparty->country_code : $mysoc->country_code)).'=<span class="opacitymedium">'.$langs->trans("NotUsedForThis".($senderissupplier ? "Vendor" : "Customer")).'</span>';
285  }
286  }
287  }
288  $tooltiponprice .= '<br>'.$langs->transcountry("TotalTTC", $mysoc->country_code).'='.price($line->total_ttc);
289  $tooltiponprice = '<span class="classfortooltip" title="'.dol_escape_htmltag($tooltiponprice).'">';
290  $tooltiponpriceend = '</span>';
291 }
292 
293 // VAT Rate
294 print '<td class="linecolvat nowrap right">';
295 $coldisplay++;
296 $positiverates = '';
297 if (price2num($line->tva_tx)) {
298  $positiverates .= ($positiverates ? '/' : '').price2num($line->tva_tx);
299 }
300 if (price2num($line->total_localtax1)) {
301  $positiverates .= ($positiverates ? '/' : '').price2num($line->localtax1_tx);
302 }
303 if (price2num($line->total_localtax2)) {
304  $positiverates .= ($positiverates ? '/' : '').price2num($line->localtax2_tx);
305 }
306 if (empty($positiverates)) {
307  $positiverates = '0';
308 }
309 print $tooltiponprice;
310 print vatrate($positiverates.($line->vat_src_code ? ' ('.$line->vat_src_code.')' : ''), '%', $line->info_bits);
311 print $tooltiponpriceend;
312 ?></td>
313 
314  <td class="linecoluht nowrap right"><?php $coldisplay++; ?><?php print price($sign * $line->subprice); ?></td>
315 
316 <?php if (!empty($conf->multicurrency->enabled) && $this->multicurrency_code != $conf->currency) { ?>
317  <td class="linecoluht_currency nowrap right"><?php $coldisplay++; ?><?php print price($sign * $line->multicurrency_subprice); ?></td>
318 <?php }
319 
320 if ($inputalsopricewithtax) { ?>
321  <td class="linecoluttc nowrap right"><?php $coldisplay++; ?><?php print (isset($line->pu_ttc) ? price($sign * $line->pu_ttc) : price($sign * $line->subprice)); ?></td>
322 <?php } ?>
323 
324  <td class="linecolqty nowrap right"><?php $coldisplay++; ?>
325 <?php
326 if ((($line->info_bits & 2) != 2) && $line->special_code != 3) {
327  // I comment this because it shows info even when not required
328  // 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
329  // must also not be output for most entities (proposal, intervention, ...)
330  //if($line->qty > $line->stock) print img_picto($langs->trans("StockTooLow"),"warning", 'style="vertical-align: bottom;"')." ";
331  print price($line->qty, 0, '', 0, 0); // Yes, it is a quantity, not a price, but we just want the formating role of function price
332 } else {
333  print '&nbsp;';
334 }
335 print '</td>';
336 
337 if (!empty($conf->global->PRODUCT_USE_UNITS)) {
338  print '<td class="linecoluseunit nowrap left">';
339  $label = $line->getLabelOfUnit('short');
340  if ($label !== '') {
341  print $langs->trans($label);
342  }
343  print '</td>';
344 }
345 if (!empty($line->remise_percent) && $line->special_code != 3) {
346  print '<td class="linecoldiscount right">';
347  $coldisplay++;
348  include_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php';
349  print dol_print_reduction($line->remise_percent, $langs);
350  print '</td>';
351 } else {
352  print '<td class="linecoldiscount">&nbsp;</td>';
353  $coldisplay++;
354 }
355 
356 // Fields for situation invoices
357 if (isset($this->situation_cycle_ref) && $this->situation_cycle_ref) {
358  include_once DOL_DOCUMENT_ROOT.'/core/lib/price.lib.php';
359  $coldisplay++;
360  print '<td class="linecolcycleref nowrap right">'.$line->situation_percent.'%</td>';
361  $coldisplay++;
362  $locataxes_array = getLocalTaxesFromRate($line->tva.($line->vat_src_code ? ' ('.$line->vat_src_code.')' : ''), 0, ($senderissupplier ? $mysoc : $object->thirdparty), ($senderissupplier ? $object->thirdparty : $mysoc));
363  $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);
364  print '<td align="right" class="linecolcycleref2 nowrap">'.price($sign * $tmp[0]).'</td>';
365 }
366 
367 if ($usemargins && !empty($conf->margin->enabled) && empty($user->socid)) {
368  if (!empty($user->rights->margins->creer)) { ?>
369  <td class="linecolmargin1 nowrap margininfos right"><?php $coldisplay++; ?><?php print price($line->pa_ht); ?></td>
370  <?php }
371  if (!empty($conf->global->DISPLAY_MARGIN_RATES) && $user->rights->margins->liretous) { ?>
372  <td class="linecolmargin2 nowrap margininfos right"><?php $coldisplay++; ?><?php print (($line->pa_ht == 0) ? 'n/a' : price(price2num($line->marge_tx, 'MT')).'%'); ?></td>
373  <?php }
374  if (!empty($conf->global->DISPLAY_MARK_RATES) && $user->rights->margins->liretous) {?>
375  <td class="linecolmargin2 nowrap margininfos right"><?php $coldisplay++; ?><?php print price(price2num($line->marque_tx, 'MT')).'%'; ?></td>
376  <?php }
377 }
378 
379 // Price total without tax
380 if ($line->special_code == 3) { ?>
381  <td class="linecoloption nowrap right"><?php $coldisplay++; ?><?php print $langs->trans('Option'); ?></td>
382 <?php } else {
383  print '<td class="linecolht nowrap right">';
384  $coldisplay++;
385  print $tooltiponprice;
386  print price($sign * $line->total_ht);
387  print $tooltiponpriceend;
388  print '</td>';
389  if (!empty($conf->multicurrency->enabled) && $this->multicurrency_code != $conf->currency) {
390  print '<td class="linecolutotalht_currency nowrap right">'.price($sign * $line->multicurrency_total_ht).'</td>';
391  $coldisplay++;
392  }
393 }
394 
395 // Price inc tax
396 if ($outputalsopricetotalwithtax) {
397  print '<td class="linecolht nowrap right">'.price($sign * $line->total_ttc).'</td>';
398  $coldisplay++;
399 }
400 
401 if ($this->statut == 0 && !empty($object_rights->creer) && $action != 'selectlines') {
402  $situationinvoicelinewithparent = 0;
403  if ($line->fk_prev_id != null && in_array($object->element, array('facture', 'facturedet'))) {
404  if ($object->type == $object::TYPE_SITUATION) { // The constant TYPE_SITUATION exists only for object invoice
405  // Set constant to disallow editing during a situation cycle
406  $situationinvoicelinewithparent = 1;
407  }
408  }
409 
410  // Asset info
411  if (!empty($conf->asset->enabled) && $object->element == 'invoice_supplier') {
412  print '<td class="linecolasset center">';
413  $coldisplay++;
414  if (!empty($product_static->accountancy_code_buy) ||
415  !empty($product_static->accountancy_code_buy_intra) ||
416  !empty($product_static->accountancy_code_buy_export)
417  ) {
418  $accountancy_category_asset = $conf->global->ASSET_ACCOUNTANCY_CATEGORY;
419  $filters = array();
420  if (!empty($product_static->accountancy_code_buy)) $filters[] = "account_number = '" . $this->db->escape($product_static->accountancy_code_buy) . "'";
421  if (!empty($product_static->accountancy_code_buy_intra)) $filters[] = "account_number = '" . $this->db->escape($product_static->accountancy_code_buy_intra) . "'";
422  if (!empty($product_static->accountancy_code_buy_export)) $filters[] = "account_number = '" . $this->db->escape($product_static->accountancy_code_buy_export) . "'";
423  $sql = "SELECT COUNT(*) AS found";
424  $sql .= " FROM " . MAIN_DB_PREFIX . "accounting_account";
425  $sql .= " WHERE pcg_type = '" . $this->db->escape($conf->global->ASSET_ACCOUNTANCY_CATEGORY) . "'";
426  $sql .= " AND (" . implode(' OR ', $filters). ")";
427  $resql_asset = $this->db->query($sql);
428  if (!$resql_asset) {
429  print 'Error SQL: ' . $this->db->lasterror();
430  } elseif ($obj = $this->db->fetch_object($resql_asset)) {
431  if (!empty($obj->found)) {
432  print '<a class="reposition" href="' . DOL_URL_ROOT . '/asset/card.php?action=create&supplier_invoice_id=' . $object->id . '&token=' . newToken() . '">';
433  print img_edit_add() . '</a>';
434  }
435  }
436  }
437  print '</td>';
438  }
439 
440  // Edit picto
441  print '<td class="linecoledit center">';
442  $coldisplay++;
443  if (($line->info_bits & 2) == 2 || !empty($disableedit)) {
444  } else { ?>
445  <a class="editfielda reposition" href="<?php print $_SERVER["PHP_SELF"].'?id='.$this->id.'&action=editline&token='.newToken().'&lineid='.$line->id.'#line_'.$line->id; ?>">
446  <?php print img_edit().'</a>';
447  }
448  print '</td>';
449 
450  // Delete picto
451  print '<td class="linecoldelete center">';
452  $coldisplay++;
453  if (!$situationinvoicelinewithparent && empty($disableremove)) { // For situation invoice, deletion is not possible if there is a parent company.
454  print '<a class="reposition" href="'.$_SERVER["PHP_SELF"].'?id='.$this->id.'&action=ask_deleteline&token='.newToken().'&lineid='.$line->id.'">';
455  print img_delete();
456  print '</a>';
457  }
458  print '</td>';
459 
460  // Move up-down picto
461  if ($num > 1 && $conf->browser->layout != 'phone' && ($this->situation_counter == 1 || !$this->situation_cycle_ref) && empty($disablemove)) {
462  print '<td class="linecolmove tdlineupdown center">';
463  $coldisplay++;
464  if ($i > 0) { ?>
465  <a class="lineupdown" href="<?php print $_SERVER["PHP_SELF"].'?id='.$this->id.'&action=up&token='.newToken().'&rowid='.$line->id; ?>">
466  <?php print img_up('default', 0, 'imgupforline'); ?>
467  </a>
468  <?php }
469  if ($i < $num - 1) { ?>
470  <a class="lineupdown" href="<?php print $_SERVER["PHP_SELF"].'?id='.$this->id.'&action=down&token='.newToken().'&rowid='.$line->id; ?>">
471  <?php print img_down('default', 0, 'imgdownforline'); ?>
472  </a>
473  <?php }
474  print '</td>';
475  } else {
476  print '<td '.(($conf->browser->layout != 'phone' && empty($disablemove)) ? ' class="linecolmove tdlineupdown center"' : ' class="linecolmove center"').'></td>';
477  $coldisplay++;
478  }
479 } else {
480  print '<td colspan="3"></td>';
481  $coldisplay = $coldisplay + 3;
482 }
483 
484 if ($action == 'selectlines') { ?>
485  <td class="linecolcheck center"><input type="checkbox" class="linecheckbox" name="line_checkbox[<?php print $i + 1; ?>]" value="<?php print $line->id; ?>" ></td>
486 <?php }
487 
488 print "</tr>\n";
489 
490 print "<!-- END PHP TEMPLATE objectline_view.tpl.php -->\n";
getLocalTaxesFromRate
getLocalTaxesFromRate($vatrate, $local, $buyer, $seller, $firstparamisid=0)
Get type and rate of localtaxes for a particular vat rate/country of a thirdparty.
Definition: functions.lib.php:6097
db
$conf db
API class for accounts.
Definition: inc.php:41
yn
yn($yesno, $case=1, $color=0)
Return yes or no in current language.
Definition: functions.lib.php:6491
ProductFournisseur
Class to manage predefined suppliers products.
Definition: fournisseur.product.class.php:41
$form
if($cancel &&! $id) if($action=='add' &&! $cancel) if($action=='delete') if($id) $form
Actions.
Definition: card.php:142
dol_print_reduction
dol_print_reduction($reduction, $langs)
Returns formated reduction.
Definition: functions2.lib.php:1850
name
$conf db name
Definition: repair.php:122
img_edit
img_edit($titlealt='default', $float=0, $other='')
Show logo editer/modifier fiche.
Definition: functions.lib.php:4389
price2num
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
Definition: functions.lib.php:5661
img_picto
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
Definition: functions.lib.php:3880
calcul_price_total
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.
Definition: price.lib.php:86
img_up
img_up($titlealt='default', $selected=0, $moreclass='')
Show top arrow logo.
Definition: functions.lib.php:4615
img_delete
img_delete($titlealt='default', $other='class="pictodelete"', $morecss='')
Show delete logo.
Definition: functions.lib.php:4429
img_edit_add
img_edit_add($titlealt='default', $other='')
Show logo +.
Definition: functions.lib.php:4353
DiscountAbsolute
Class to manage absolute discounts.
Definition: discount.class.php:29
img_down
img_down($titlealt='default', $selected=0, $moreclass='')
Show down arrow logo.
Definition: functions.lib.php:4596
newToken
newToken()
Return the value of token currently saved into session with name 'newtoken'.
Definition: functions.lib.php:10878
AccountingAccount
Class to manage accounting accounts.
Definition: accountingaccount.class.php:36
img_object
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
Definition: functions.lib.php:4211
dol_htmlentitiesbr
dol_htmlentitiesbr($stringtoencode, $nl2brmode=0, $pagecodefrom='UTF-8', $removelasteolbr=1)
This function is called to encode a string into a HTML string but differs from htmlentities because a...
Definition: functions.lib.php:6991
price
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.
Definition: functions.lib.php:5541
Product\TYPE_PRODUCT
const TYPE_PRODUCT
Regular product.
Definition: product.class.php:500
getDolGlobalInt
getDolGlobalInt($key, $default=0)
Return dolibarr global constant int value.
Definition: functions.lib.php:93
type
if(preg_match('/crypted:/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
Definition: repair.php:119
vatrate
vatrate($rate, $addpercent=false, $info_bits=0, $usestarfornpr=0, $html=0)
Return a string with VAT rate label formated for view output Used into pdf and HTML pages.
Definition: functions.lib.php:5492