24 require
'../../main.inc.php';
25 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
26 require_once DOL_DOCUMENT_ROOT.
'/core/class/fiscalyear.class.php';
28 $action =
GETPOST(
'action',
'aZ09');
31 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
32 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
33 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
35 if (empty($page) || $page == -1) {
38 $offset = $limit * $page;
39 $pageprev = $page - 1;
40 $pagenext = $page + 1;
42 $sortfield =
"f.rowid";
49 $langs->loadLangs(array(
"admin",
"compta"));
52 if ($user->socid > 0) {
55 if (empty($user->rights->accounting->fiscalyear->write)) {
62 static $tmpstatut2label = array(
63 '0' =>
'OpenFiscalYear',
64 '1' =>
'CloseFiscalYear'
66 $statut2label = array(
69 foreach ($tmpstatut2label as $key => $val) {
70 $statut2label[$key] = $langs->trans($val);
93 $title = $langs->trans(
'AccountingPeriods');
95 $help_url =
"EN:Module_Double_Entry_Accounting";
99 $sql =
"SELECT f.rowid, f.label, f.date_start, f.date_end, f.statut as status, f.entity";
100 $sql .=
" FROM ".MAIN_DB_PREFIX.
"accounting_fiscalyear as f";
101 $sql .=
" WHERE f.entity = ".$conf->entity;
102 $sql .= $db->order($sortfield, $sortorder);
105 $nbtotalofrecords =
'';
106 if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
107 $result = $db->query($sql);
108 $nbtotalofrecords = $db->num_rows($result);
109 if (($page * $limit) > $nbtotalofrecords) {
115 $sql .= $db->plimit($limit + 1, $offset);
117 $result = $db->query($sql);
119 $num = $db->num_rows($result);
124 $addbutton .=
dolGetButtonTitle($langs->trans(
'NewFiscalYear'),
'',
'fa fa-plus-circle',
'fiscalyear_card.php?action=create',
'', $user->rights->accounting->fiscalyear->write);
127 $title = $langs->trans(
'AccountingPeriods');
128 print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $params, $sortfield, $sortorder,
'', $num, $nbtotalofrecords,
'title_accountancy', 0, $addbutton,
'', $limit, 1);
130 print
'<div class="div-table-responsive">';
131 print
'<table class="tagtable liste centpercent">';
132 print
'<tr class="liste_titre">';
133 print
'<td>'.$langs->trans(
"Ref").
'</td>';
134 print
'<td>'.$langs->trans(
"Label").
'</td>';
135 print
'<td>'.$langs->trans(
"DateStart").
'</td>';
136 print
'<td>'.$langs->trans(
"DateEnd").
'</td>';
137 print
'<td class="center">'.$langs->trans(
"NumberOfAccountancyEntries").
'</td>';
138 print
'<td class="center">'.$langs->trans(
"NumberOfAccountancyMovements").
'</td>';
139 print
'<td class="right">'.$langs->trans(
"Statut").
'</td>';
143 while ($i < $num && $i < $max) {
144 $obj = $db->fetch_object($result);
146 $fiscalyearstatic->ref = $obj->rowid;
147 $fiscalyearstatic->id = $obj->rowid;
148 $fiscalyearstatic->statut = $obj->status;
149 $fiscalyearstatic->status = $obj->status;
151 print
'<tr class="oddeven">';
153 print $fiscalyearstatic->getNomUrl(1);
155 print
'<td class="left">'.$obj->label.
'</td>';
156 print
'<td class="left">'.dol_print_date($db->jdate($obj->date_start),
'day').
'</td>';
157 print
'<td class="left">'.dol_print_date($db->jdate($obj->date_end),
'day').
'</td>';
158 print
'<td class="center">'.$object->getAccountancyEntriesByFiscalYear($obj->date_start, $obj->date_end).
'</td>';
159 print
'<td class="center">'.$object->getAccountancyMovementsByFiscalYear($obj->date_start, $obj->date_end).
'</td>';
160 print
'<td class="right">'.$fiscalyearstatic->LibStatut($obj->statut, 5).
'</td>';
165 print
'<tr class="oddeven"><td colspan="7" class="opacitymedium">'.$langs->trans(
"None").
'</td></tr>';