30 require
'../../main.inc.php';
32 require_once DOL_DOCUMENT_ROOT.
'/compta/tva/class/tva.class.php';
33 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
34 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
35 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
36 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
37 require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingjournal.class.php';
40 $langs->loadLangs(array(
'compta',
'bills'));
42 $action =
GETPOST(
'action',
'aZ09') ?
GETPOST(
'action',
'aZ09') :
'view';
43 $massaction =
GETPOST(
'massaction',
'alpha');
44 $show_files =
GETPOST(
'show_files',
'int');
45 $confirm =
GETPOST(
'confirm',
'alpha');
46 $cancel =
GETPOST(
'cancel',
'alpha');
47 $toselect =
GETPOST(
'toselect',
'array');
48 $contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'salestaxeslist';
49 $backtopage =
GETPOST(
'backtopage',
'alpha');
50 $optioncss =
GETPOST(
'optioncss',
'alpha');
51 $optioncss =
GETPOST(
'optioncss',
'aZ');
54 $search_ref =
GETPOST(
'search_ref',
'alpha');
55 $search_label =
GETPOST(
'search_label',
'alpha');
56 $search_dateend_start =
dol_mktime(0, 0, 0,
GETPOST(
'search_dateend_startmonth',
'int'),
GETPOST(
'search_dateend_startday',
'int'),
GETPOST(
'search_dateend_startyear',
'int'));
57 $search_dateend_end =
dol_mktime(23, 59, 59,
GETPOST(
'search_dateend_endmonth',
'int'),
GETPOST(
'search_dateend_endday',
'int'),
GETPOST(
'search_dateend_endyear',
'int'));
58 $search_datepayment_start =
dol_mktime(0, 0, 0,
GETPOST(
'search_datepayment_startmonth',
'int'),
GETPOST(
'search_datepayment_startday',
'int'),
GETPOST(
'search_datepayment_startyear',
'int'));
59 $search_datepayment_end =
dol_mktime(23, 59, 59,
GETPOST(
'search_datepayment_endmonth',
'int'),
GETPOST(
'search_datepayment_endday',
'int'),
GETPOST(
'search_datepayment_endyear',
'int'));
60 $search_type =
GETPOST(
'search_type',
'int');
61 $search_account =
GETPOST(
'search_account',
'int');
62 $search_amount =
GETPOST(
'search_amount',
'alpha');
63 $search_status =
GETPOST(
'search_status',
'int');
66 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
67 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
68 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
70 if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
74 $offset = $limit * $page;
75 $pageprev = $page - 1;
76 $pagenext = $page + 1;
79 $sortfield =
't.datev';
86 't.rowid' =>array(
'checked'=>1,
'position'=>10,
'label'=>
"Ref",),
87 't.label' =>array(
'checked'=>1,
'position'=>20,
'label'=>
"Label"),
88 't.datev' =>array(
'checked'=>1,
'position'=>30,
'label'=>
"PeriodEndDate"),
89 't.fk_typepayment' =>array(
'checked'=>1,
'position'=>50,
'label'=>
"DefaultPaymentMode"),
90 't.amount' =>array(
'checked'=>1,
'position'=>90,
'label'=>
"Amount"),
91 't.status' =>array(
'checked'=>1,
'position'=>90,
'label'=>
"Status"),
95 $arrayfields[
't.fk_account'] = array(
'checked'=>1,
'position'=>60,
'label'=>
"DefaultBankAccount");
101 $hookmanager->initHooks(array(
'salestaxeslist'));
102 $object =
new Tva($db);
104 $permissiontoadd = $user->hasRight(
'tax',
'charges',
'creer');
105 $permissiontodelete = $user->hasRight(
'tax',
'charges',
'supprimer');
108 $socid =
GETPOST(
'socid',
'int');
110 $socid = $user->socid;
119 $parameters = array(
'socid'=>$socid);
120 $reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
126 if (empty($reshook)) {
128 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
130 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
133 $search_dateend_start =
'';
134 $search_dateend_end =
'';
135 $search_datepayment_start =
'';
136 $search_datepayment_end =
'';
138 $search_account =
'';
142 $search_array_options = array();
146 $objectclass =
'Tva';
147 $objectlabel =
'Tva';
148 $uploaddir = $conf->tax->dir_output;
149 include DOL_DOCUMENT_ROOT.
'/core/actions_massactions.inc.php';
160 $tva_static =
new Tva($db);
161 $bankstatic =
new Account($db);
167 $title = $langs->trans(
"VATDeclarations");
174 $sql =
'SELECT t.rowid, t.amount, t.label, t.datev, t.datep, t.paye as status, t.fk_typepayment as type, t.fk_account,';
175 $sql.=
' ba.label as blabel, ba.ref as bref, ba.number as bnumber, ba.account_number, ba.iban_prefix as iban, ba.bic, ba.currency_code, ba.clos,';
176 $sql.=
' t.num_payment, pst.code as payment_code,';
177 $sql .=
' SUM(ptva.amount) as alreadypayed';
181 $sql .=
' FROM '.MAIN_DB_PREFIX.
'tva as t';
182 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_paiement as pst ON (t.fk_typepayment = pst.id)';
183 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'bank_account as ba ON (t.fk_account = ba.rowid)';
184 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"payment_vat as ptva ON (ptva.fk_tva = t.rowid)";
185 $sql .=
' WHERE t.entity IN ('.getEntity($object->element).
')';
187 if (!empty($search_ref)) {
190 if (!empty($search_label)) {
193 if (!empty($search_dateend_start)) {
194 $sql .=
" AND t.datev >= '".$db->idate($search_dateend_start).
"'";
196 if (!empty($search_dateend_end)) {
197 $sql .=
" AND t.datev <= '".$db->idate($search_dateend_end).
"'";
199 if (!empty($search_datepayment_start)) {
200 $sql .=
" AND t.datep >= '".$db->idate($search_datepayment_start).
"'";
202 if (!empty($search_datepayment_end)) {
203 $sql .=
" AND t.datep <= '".$db->idate($search_datepayment_end).
"'";
205 if (!empty($search_type) && $search_type > 0) {
206 $sql .=
' AND t.fk_typepayment = '.((int) $search_type);
208 if (!empty($search_account) && $search_account > 0) {
209 $sql .=
' AND t.fk_account = '.((int) $search_account);
211 if (!empty($search_amount)) {
214 if ($search_status !=
'' && $search_status >= 0) {
215 $sql .=
" AND t.paye = ".((int) $search_status);
218 $sql .=
" GROUP BY t.rowid, t.amount, t.label, t.datev, t.datep, t.paye, t.fk_typepayment, t.fk_account, ba.label, ba.ref, ba.number, ba.account_number, ba.iban_prefix, ba.bic, ba.currency_code, ba.clos, t.num_payment, pst.code";
221 $nbtotalofrecords =
'';
224 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords',
$sql);
225 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
226 $resql = $db->query($sqlforcount);
228 $objforcount = $db->fetch_object($resql);
229 $nbtotalofrecords = $objforcount->nbtotalofrecords;
234 if (($page * $limit) > $nbtotalofrecords) {
242 $sql .= $db->order($sortfield, $sortorder);
244 $sql .= $db->plimit($limit + 1, $offset);
247 $resql = $db->query(
$sql);
253 $num = $db->num_rows($resql);
261 $arrayofselected = is_array($toselect) ? $toselect : array();
265 $param .=
'&mode='.urlencode($mode);
267 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
268 $param .=
'&contextpage='.urlencode($contextpage);
270 if ($limit > 0 && $limit != $conf->liste_limit) {
271 $param .=
'&limit='.((int) $limit);
273 if ($optioncss !=
'') {
274 $param .=
'&optioncss='.urlencode($optioncss);
277 if (!empty($search_ref)) {
278 $param .=
'&search_ref="'.$search_ref.
'"';
280 if (!empty($search_label)) {
281 $param .=
'&search_label="'.$search_label.
'"';
283 if (!empty($search_dateend_start)) {
284 $param .=
'&search_dateend_startyear='.GETPOST(
'search_dateend_startyear',
'int');
286 if (!empty($search_dateend_start)) {
287 $param .=
'&search_dateend_startmonth='.GETPOST(
'search_dateend_startmonth',
'int');
289 if (!empty($search_dateend_start)) {
290 $param .=
'&search_dateend_startday='.GETPOST(
'search_dateend_startday',
'int');
292 if (!empty($search_dateend_end)) {
293 $param .=
'&search_dateend_endyear='.GETPOST(
'search_dateend_endyear',
'int');
295 if (!empty($search_dateend_end)) {
296 $param .=
'&search_dateend_endmonth='.GETPOST(
'search_dateend_endmonth',
'int');
298 if (!empty($search_dateend_end)) {
299 $param .=
'&search_dateend_endday='.GETPOST(
'search_dateend_endday',
'int');
301 if (!empty($search_datepayment_start)) {
302 $param .=
'&search_datepayment_startyear='.GETPOST(
'search_datepayment_startyear',
'int');
304 if (!empty($search_datepayment_start)) {
305 $param .=
'&search_datepayment_startmonth='.GETPOST(
'search_datepayment_startmonth',
'int');
307 if (!empty($search_datepayment_start)) {
308 $param .=
'&search_datepayment_startday='.GETPOST(
'search_datepayment_startday',
'int');
310 if (!empty($search_datepayment_end)) {
311 $param .=
'&search_datepayment_endyear='.GETPOST(
'search_datepayment_endyear',
'int');
313 if (!empty($search_datepayment_end)) {
314 $param .=
'&search_datepayment_endmonth='.GETPOST(
'search_datepayment_endmonth',
'int');
316 if (!empty($search_datepayment_end)) {
317 $param .=
'&search_datepayment_endday='.GETPOST(
'search_datepayment_endday',
'int');
319 if (!empty($search_type) && $search_type > 0) {
320 $param .=
'&search_type='.$search_type;
322 if (!empty($search_account) && $search_account > 0) {
323 $param .=
'&search_account='.$search_account;
325 if (!empty($search_amount)) {
326 $param .=
'&search_amount="'.$search_amount.
'"';
328 if ($search_status !=
'' && $search_status !=
'-1') {
329 $param .=
'&search_status='.urlencode($search_status);
333 $arrayofmassactions = array(
337 if (!empty($permissiontodelete)) {
338 $arrayofmassactions[
'predelete'] =
img_picto(
'',
'delete',
'class="pictofixedwidth"').$langs->trans(
"Delete");
340 $massactionbutton =
$form->selectMassAction(
'', $arrayofmassactions);
344 print
'<form method="POST" id="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'">';
345 if ($optioncss !=
'') {
346 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
348 print
'<input type="hidden" name="token" value="'.newToken().
'">';
349 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
350 print
'<input type="hidden" name="action" value="list">';
351 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
352 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
353 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
354 print
'<input type="hidden" name="page" value="'.$page.
'">';
355 print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
356 print
'<input type="hidden" name="page_y" value="">';
357 print
'<input type="hidden" name="mode" value="'.$mode.
'">';
359 $url = DOL_URL_ROOT.
'/compta/tva/card.php?action=create';
360 if (!empty($socid)) {
361 $url .=
'&socid='.$socid;
364 $newcardbutton .=
dolGetButtonTitle($langs->trans(
'ViewList'),
'',
'fa fa-bars imgforviewmode', $_SERVER[
"PHP_SELF"].
'?mode=common'.preg_replace(
'/(&|\?)*mode=[^&]+/',
'', $param),
'', ((empty($mode) || $mode ==
'common') ? 2 : 1), array(
'morecss'=>
'reposition'));
365 $newcardbutton .=
dolGetButtonTitle($langs->trans(
'ViewKanban'),
'',
'fa fa-th-list imgforviewmode', $_SERVER[
"PHP_SELF"].
'?mode=kanban'.preg_replace(
'/(&|\?)*mode=[^&]+/',
'', $param),
'', ($mode ==
'kanban' ? 2 : 1), array(
'morecss'=>
'reposition'));
367 $newcardbutton .=
dolGetButtonTitle($langs->trans(
'NewVATPayment'),
'',
'fa fa-plus-circle', $url,
'', $permissiontoadd);
369 print_barre_liste($title, $page, $_SERVER[
'PHP_SELF'], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'title_accountancy', 0, $newcardbutton,
'', $limit, 0, 0, 1);
372 $topicmail =
"SendVAT";
374 $objecttmp =
new Tva($db);
375 $trackid =
'vat'.$object->id;
376 include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
378 $varpage = empty($contextpage) ? $_SERVER[
'PHP_SELF'] : $contextpage;
379 $selectedfields =
$form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
getDolGlobalString(
'MAIN_CHECKBOX_LEFT_COLUMN'));
380 if ($massactionbutton) {
381 $selectedfields .=
$form->showCheckAddButtons(
'checkforselect', 1);
386 $parameters = array();
387 $reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
388 if (empty($reshook)) {
389 $moreforfilter .= $hookmanager->resPrint;
391 $moreforfilter = $hookmanager->resPrint;
394 if (!empty($moreforfilter)) {
395 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
396 print $moreforfilter;
397 $parameters = array();
398 $reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
399 print $hookmanager->resPrint;
403 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
404 $selectedfields = ($mode !=
'kanban' ?
$form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
getDolGlobalString(
'MAIN_CHECKBOX_LEFT_COLUMN',
'')) :
'');
405 $selectedfields .= (count($arrayofmassactions) ?
$form->showCheckAddButtons(
'checkforselect', 1) :
'');
407 print
'<div class="div-table-responsive">';
408 print
'<table class="tagtable nobottomiftotal liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
412 print
'<tr class="liste_titre_filter">';
415 print
'<td class="liste_titre center maxwidthsearch">';
416 $searchpicto =
$form->showFilterButtons(
'left');
422 if (!empty($conf->global->MAIN_VIEW_LINE_NUMBER_IN_LIST)) {
423 print
'<td class="liste_titre">';
428 if (!empty($arrayfields[
't.rowid'][
'checked'])) {
429 print
'<td class="liste_titre">';
430 print
'<input type="text" class="flat" size="4" name="search_ref" value="'.dol_escape_htmltag($search_ref).
'">';
435 if (!empty($arrayfields[
't.label'][
'checked'])) {
436 print
'<td class="liste_titre">';
437 print
'<input type="text" class="flat" size="10" name="search_label" value="'.dol_escape_htmltag($search_label).
'">';
442 if (!empty($arrayfields[
't.datev'][
'checked'])) {
443 print
'<td class="liste_titre center">';
444 print
'<div class="nowrap">';
445 print
$form->selectDate($search_dateend_start ? $search_dateend_start : -1,
'search_dateend_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
"From"));
447 print
'<div class="nowrap">';
448 print
$form->selectDate($search_dateend_end ? $search_dateend_end : -1,
'search_dateend_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
"to"));
466 if (!empty($arrayfields[
't.fk_typepayment'][
'checked'])) {
467 print
'<td class="liste_titre left">';
468 print
$form->select_types_paiements($search_type,
'search_type',
'', 0, 1, 1, 16, 1,
'', 1);
473 if (!empty($arrayfields[
't.fk_account'][
'checked'])) {
474 print
'<td class="liste_titre left">';
475 $form->select_comptes($search_account,
'search_account', 0,
'', 1);
480 if (!empty($arrayfields[
't.amount'][
'checked'])) {
481 print
'<td class="liste_titre right">';
482 print
'<input name="search_amount" class="flat" type="text" size="8" value="'.$search_amount.
'">';
487 if (!empty($arrayfields[
't.status'][
'checked'])) {
488 print
'<td class="liste_titre right parentonrightofpage">';
489 $liststatus = array(
'0' => $langs->trans(
"Unpaid"),
'1' => $langs->trans(
"Paid"));
490 print
$form->selectarray(
'search_status', $liststatus, $search_status, 1, 0, 0,
'', 0, 0, 0,
'',
'search_status width100 onrightofpage');
495 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
498 $parameters = array(
'arrayfields'=>$arrayfields);
499 $reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters, $object, $action);
500 print $hookmanager->resPrint;
504 print
'<td class="liste_titre center maxwidthsearch">';
505 $searchpicto =
$form->showFilterButtons();
511 $totalarray = array();
512 $totalarray[
'nbfield'] = 0;
516 print
'<tr class="liste_titre">';
518 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ').
"\n";
519 $totalarray[
'nbfield']++;
521 if (!empty($conf->global->MAIN_VIEW_LINE_NUMBER_IN_LIST)) {
523 $totalarray[
'nbfield']++;
525 if (!empty($arrayfields[
't.rowid'][
'checked'])) {
526 print_liste_field_titre($arrayfields[
't.rowid'][
'label'], $_SERVER[
'PHP_SELF'],
't.rowid',
'', $param,
'', $sortfield, $sortorder);
527 $totalarray[
'nbfield']++;
529 if (!empty($arrayfields[
't.label'][
'checked'])) {
530 print_liste_field_titre($arrayfields[
't.label'][
'label'], $_SERVER[
'PHP_SELF'],
't.label',
'', $param,
'align="left"', $sortfield, $sortorder);
531 $totalarray[
'nbfield']++;
533 if (!empty($arrayfields[
't.datev'][
'checked'])) {
534 print_liste_field_titre($arrayfields[
't.datev'][
'label'], $_SERVER[
'PHP_SELF'],
't.datev',
'', $param,
'align="center"', $sortfield, $sortorder);
535 $totalarray[
'nbfield']++;
537 if (!empty($arrayfields[
't.fk_typepayment'][
'checked'])) {
538 print_liste_field_titre($arrayfields[
't.fk_typepayment'][
'label'], $_SERVER[
'PHP_SELF'],
't.fk_typepayment',
'', $param,
'', $sortfield, $sortorder,
'left ');
539 $totalarray[
'nbfield']++;
541 if (!empty($arrayfields[
't.fk_account'][
'checked'])) {
542 print_liste_field_titre($arrayfields[
't.fk_account'][
'label'], $_SERVER[
'PHP_SELF'],
't.fk_account',
'', $param,
'', $sortfield, $sortorder,
'left ');
543 $totalarray[
'nbfield']++;
545 if (!empty($arrayfields[
't.amount'][
'checked'])) {
546 print_liste_field_titre($arrayfields[
't.amount'][
'label'], $_SERVER[
'PHP_SELF'],
't.amount',
'', $param,
'', $sortfield, $sortorder,
'right ');
547 $totalarray[
'nbfield']++;
549 if (!empty($arrayfields[
't.status'][
'checked'])) {
550 print_liste_field_titre($arrayfields[
't.status'][
'label'], $_SERVER[
"PHP_SELF"],
"t.paye",
"", $param,
'class="right"', $sortfield, $sortorder);
551 $totalarray[
'nbfield']++;
554 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
556 $parameters = array(
'arrayfields'=>$arrayfields,
'param'=>$param,
'sortfield'=>$sortfield,
'sortorder'=>$sortorder);
557 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object, $action);
558 print $hookmanager->resPrint;
562 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ').
"\n";
563 $totalarray[
'nbfield']++;
570 $savnbfield = $totalarray[
'nbfield'];
571 $totalarray = array();
572 $totalarray[
'nbfield'] = 0;
573 $imaxinloop = ($limit ? min($num, $limit) : $num);
574 while ($i < $imaxinloop) {
575 $obj = $db->fetch_object($resql);
580 $tva_static->id = $obj->rowid;
581 $tva_static->ref = $obj->rowid;
582 $tva_static->label = $obj->label;
583 $tva_static->type_payment = $obj->payment_code;
584 $tva_static->datev = $obj->datev;
585 $tva_static->amount = $obj->amount;
586 $tva_static->paye = $obj->status;
587 $tva_static->status = $obj->status;
588 $object = $tva_static;
590 if ($mode ==
'kanban') {
592 print
'<tr class="trkanban"><td colspan="'.$savnbfield.
'">';
593 print
'<div class="box-flex-container kanban">';
596 if ($massactionbutton || $massaction) {
598 if (in_array($object->id, $arrayofselected)) {
602 print $object->getKanbanView(
'', array(
'selected' => in_array($object->id, $arrayofselected)));
603 if ($i == ($imaxinloop - 1)) {
610 print
'<tr data-rowid="'.$object->id.
'" class="oddeven">';
613 print
'<td class="nowrap center">';
614 if ($massactionbutton || $massaction) {
616 if (in_array($object->id, $arrayofselected)) {
619 print
'<input id="cb'.$object->id.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
623 $totalarray[
'nbfield']++;
628 if (!empty($conf->global->MAIN_VIEW_LINE_NUMBER_IN_LIST)) {
629 print
'<td>'.(($offset * $limit) + $i).
'</td>';
631 $totalarray[
'nbfield']++;
636 if (!empty($arrayfields[
't.rowid'][
'checked'])) {
638 print $tva_static->getNomUrl(1);
641 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$tva_static->id;
642 print $formfile->getDocumentsLink($tva_static->element, $filename, $filedir,
'',
'valignmiddle paddingleft2imp');
645 $totalarray[
'nbfield']++;
650 if (!empty($arrayfields[
't.label'][
'checked'])) {
651 print
'<td>'.dol_trunc($obj->label, 40).
'</td>';
653 $totalarray[
'nbfield']++;
658 if (!empty($arrayfields[
't.datev'][
'checked'])) {
659 print
'<td class="center">'.dol_print_date($db->jdate($obj->datev),
'day').
'</td>';
661 $totalarray[
'nbfield']++;
675 if (!empty($arrayfields[
't.fk_typepayment'][
'checked'])) {
677 if (!empty($obj->payment_code)) print $langs->trans(
"PaymentTypeShort".$obj->payment_code);
680 $totalarray[
'nbfield']++;
685 if (!empty($arrayfields[
't.fk_account'][
'checked'])) {
687 if ($obj->fk_account > 0) {
688 $bankstatic->id = $obj->fk_account;
689 $bankstatic->ref = $obj->bref;
690 $bankstatic->number = $obj->bnumber;
691 $bankstatic->iban = $obj->iban;
692 $bankstatic->bic = $obj->bic;
693 $bankstatic->currency_code = $langs->trans(
"Currency".$obj->currency_code);
694 $bankstatic->account_number = $obj->account_number;
695 $bankstatic->clos = $obj->clos;
700 $bankstatic->label = $obj->blabel;
701 print $bankstatic->getNomUrl(1);
704 if (!$i) $totalarray[
'nbfield']++;
708 if (!empty($arrayfields[
't.amount'][
'checked'])) {
709 print
'<td class="nowrap right"><span class="amount">' .
price($obj->amount) .
'</span></td>';
711 $totalarray[
'nbfield']++;
713 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'amount';
714 if (empty($totalarray[
'val'][
'amount'])) {
715 $totalarray[
'val'][
'amount'] = $obj->amount;
717 $totalarray[
'val'][
'amount'] += $obj->amount;
721 if (!empty($arrayfields[
't.status'][
'checked'])) {
722 print
'<td class="nowrap right">' . $tva_static->getLibStatut(5, $obj->alreadypayed) .
'</td>';
724 $totalarray[
'nbfield']++;
726 if (!empty($arrayfields[
't.amount'][
'checked'])) {
727 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'';
733 print
'<td class="nowrap center">';
734 if ($massactionbutton || $massaction) {
736 if (in_array($object->id, $arrayofselected)) {
739 print
'<input id="cb'.$object->id.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
743 $totalarray[
'nbfield']++;
754 include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
759 foreach ($arrayfields as $key => $val) {
760 if (!empty($val[
'checked'])) {
764 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
769 $parameters = array(
'arrayfields'=>$arrayfields,
'sql'=>
$sql);
770 $reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters, $object, $action);
771 print $hookmanager->resPrint;
773 print
'</table>'.
"\n";
776 print
'</form>'.
"\n";