25require
'../../main.inc.php';
26require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
27require_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
28require_once DOL_DOCUMENT_ROOT.
'/core/class/fiscalyear.class.php';
29require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formaccounting.class.php';
30require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/bookkeeping.class.php';
33$langs->loadLangs(array(
"compta",
"bills",
"other",
"accountancy"));
35$action =
GETPOST(
'action',
'aZ09');
36$confirm =
GETPOST(
'confirm',
'aZ09');
37$fiscal_period_id =
GETPOSTINT(
'fiscal_period_id');
42if (!isModEnabled(
'accounting')) {
45if ($user->socid > 0) {
48if (!$user->hasRight(
'accounting',
'fiscalyear',
'write')) {
53$hookmanager->initHooks(array(
'accountancyclosure'));
58$fiscal_periods =
$object->getFiscalPeriods();
59if (!is_array($fiscal_periods)) {
63$active_fiscal_periods = array();
64$last_fiscal_period =
null;
65$current_fiscal_period =
null;
66$next_fiscal_period =
null;
67$next_active_fiscal_period =
null;
68if (is_array($fiscal_periods)) {
69 foreach ($fiscal_periods as $fiscal_period) {
70 if (empty($fiscal_period[
'status'])) {
71 $active_fiscal_periods[] = $fiscal_period;
73 if (isset($current_fiscal_period)) {
74 if (!isset($next_fiscal_period)) {
75 $next_fiscal_period = $fiscal_period;
77 if (!isset($next_active_fiscal_period) && empty($fiscal_period[
'status'])) {
78 $next_active_fiscal_period = $fiscal_period;
81 if ($fiscal_period_id == $fiscal_period[
'id'] || (empty($fiscal_period_id) && $fiscal_period[
'date_start'] <= $now && $now <= $fiscal_period[
'date_end'])) {
82 $current_fiscal_period = $fiscal_period;
84 $last_fiscal_period = $fiscal_period;
90$accounting_groups_used_for_balance_sheet_account = array_filter(array_map(
'trim', explode(
',',
getDolGlobalString(
'ACCOUNTING_CLOSURE_ACCOUNTING_GROUPS_USED_FOR_BALANCE_SHEET_ACCOUNT'))),
'strlen');
91$accounting_groups_used_for_income_statement = array_filter(array_map(
'trim', explode(
',',
getDolGlobalString(
'ACCOUNTING_CLOSURE_ACCOUNTING_GROUPS_USED_FOR_INCOME_STATEMENT'))),
'strlen');
98$parameters = array(
'fiscal_periods' => $fiscal_periods,
'last_fiscal_period' => $last_fiscal_period,
'current_fiscal_period' => $current_fiscal_period,
'next_fiscal_period' => $next_fiscal_period);
99$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
104if (empty($reshook)) {
105 if (isset($current_fiscal_period) && $user->hasRight(
'accounting',
'fiscalyear',
'write')) {
106 if ($action ==
'confirm_step_1' && $confirm ==
"yes") {
110 $result =
$object->validateMovementForFiscalPeriod($date_start, $date_end);
112 setEventMessages($langs->trans(
"AllMovementsWereRecordedAsValidated"),
null,
'mesgs');
114 header(
"Location: " . $_SERVER[
'PHP_SELF'] . (isset($current_fiscal_period) ?
'?fiscal_period_id=' . $current_fiscal_period[
'id'] :
''));
117 setEventMessages($langs->trans(
"NotAllMovementsCouldBeRecordedAsValidated"),
null,
'errors');
121 } elseif ($action ==
'confirm_step_2' && $confirm ==
"yes") {
122 $new_fiscal_period_id =
GETPOSTINT(
'new_fiscal_period_id');
123 $separate_auxiliary_account =
GETPOST(
'separate_auxiliary_account',
'aZ09');
124 $generate_bookkeeping_records =
GETPOST(
'generate_bookkeeping_records',
'aZ09');
126 $result =
$object->closeFiscalPeriod($current_fiscal_period[
'id'], $new_fiscal_period_id, $separate_auxiliary_account, $generate_bookkeeping_records);
130 setEventMessages($langs->trans(
"AccountancyClosureCloseSuccessfully"),
null,
'mesgs');
132 header(
"Location: " . $_SERVER[
'PHP_SELF'] . (isset($current_fiscal_period) ?
'?fiscal_period_id=' . $current_fiscal_period[
'id'] :
''));
135 } elseif ($action ==
'confirm_step_3' && $confirm ==
"yes") {
136 $inventory_journal_id =
GETPOSTINT(
'inventory_journal_id');
137 $new_fiscal_period_id =
GETPOSTINT(
'new_fiscal_period_id');
141 $result =
$object->insertAccountingReversal($current_fiscal_period[
'id'], $inventory_journal_id, $new_fiscal_period_id, $date_start, $date_end);
145 setEventMessages($langs->trans(
"AccountancyClosureInsertAccountingReversalSuccessfully"),
null,
'mesgs');
147 header(
"Location: " . $_SERVER[
'PHP_SELF'] . (isset($current_fiscal_period) ?
'?fiscal_period_id=' . $current_fiscal_period[
'id'] :
''));
159$form =
new Form($db);
162$title = $langs->trans(
'Closure');
164$help_url =
'EN:Module_Double_Entry_Accounting|FR:Module_Comptabilité_en_Partie_Double#Cl.C3.B4ture_annuelle';
170if (isset($current_fiscal_period)) {
171 if ($action ==
'step_1') {
172 $form_question = array();
174 $form_question[
'date_start'] = array(
175 'name' =>
'date_start',
177 'label' => $langs->trans(
'DateStart'),
178 'value' => $current_fiscal_period[
'date_start']
180 $form_question[
'date_end'] = array(
181 'name' =>
'date_end',
183 'label' => $langs->trans(
'DateEnd'),
184 'value' => $current_fiscal_period[
'date_end']
187 $formconfirm = $form->formconfirm(
188 $_SERVER[
"PHP_SELF"] .
'?fiscal_period_id=' . $current_fiscal_period[
'id'],
189 $langs->trans(
'ValidateMovements'),
190 $langs->trans(
'DescValidateMovements', $langs->transnoentitiesnoconv(
"RegistrationInAccounting")),
197 } elseif ($action ==
'step_2') {
198 $form_question = array();
200 $fiscal_period_arr = array();
201 foreach ($active_fiscal_periods as $info) {
202 $fiscal_period_arr[$info[
'id']] = $info[
'label'];
204 $form_question[
'new_fiscal_period_id'] = array(
205 'name' =>
'new_fiscal_period_id',
207 'label' => $langs->trans(
'AccountancyClosureStep3NewFiscalPeriod'),
208 'values' => $fiscal_period_arr,
209 'default' => isset($next_active_fiscal_period) ? $next_active_fiscal_period[
'id'] :
'',
211 $form_question[
'generate_bookkeeping_records'] = array(
212 'name' =>
'generate_bookkeeping_records',
213 'type' =>
'checkbox',
214 'label' => $langs->trans(
'AccountancyClosureGenerateClosureBookkeepingRecords'),
217 $form_question[
'separate_auxiliary_account'] = array(
218 'name' =>
'separate_auxiliary_account',
219 'type' =>
'checkbox',
220 'label' => $langs->trans(
'AccountancyClosureSeparateAuxiliaryAccounts'),
224 $formconfirm = $form->formconfirm(
225 $_SERVER[
"PHP_SELF"] .
'?fiscal_period_id=' . $current_fiscal_period[
'id'],
226 $langs->trans(
'AccountancyClosureClose'),
227 $langs->trans(
'AccountancyClosureConfirmClose'),
234 } elseif ($action ==
'step_3') {
235 $form_question = array();
237 $form_question[
'inventory_journal_id'] = array(
238 'name' =>
'inventory_journal_id',
240 'label' => $langs->trans(
'InventoryJournal'),
241 'value' => $formaccounting->select_journal(0,
"inventory_journal_id", 8, 1, 0, 0)
243 $fiscal_period_arr = array();
244 foreach ($active_fiscal_periods as $info) {
245 $fiscal_period_arr[$info[
'id']] = $info[
'label'];
247 $form_question[
'new_fiscal_period_id'] = array(
248 'name' =>
'new_fiscal_period_id',
250 'label' => $langs->trans(
'AccountancyClosureStep3NewFiscalPeriod'),
251 'values' => $fiscal_period_arr,
252 'default' => isset($next_active_fiscal_period) ? $next_active_fiscal_period[
'id'] :
'',
254 $form_question[
'date_start'] = array(
255 'name' =>
'date_start',
257 'label' => $langs->trans(
'DateStart'),
260 $form_question[
'date_end'] = array(
261 'name' =>
'date_end',
263 'label' => $langs->trans(
'DateEnd'),
264 'value' => $current_fiscal_period[
'date_end']
267 $formconfirm = $form->formconfirm(
268 $_SERVER[
"PHP_SELF"] .
'?fiscal_period_id=' . $current_fiscal_period[
'id'],
269 $langs->trans(
'AccountancyClosureAccountingReversal'),
270 $langs->trans(
'AccountancyClosureConfirmAccountingReversal'),
281$parameters = array(
'formConfirm' => $formconfirm,
'fiscal_periods' => $fiscal_periods,
'last_fiscal_period' => $last_fiscal_period,
'current_fiscal_period' => $current_fiscal_period,
'next_fiscal_period' => $next_fiscal_period);
282$reshook = $hookmanager->executeHooks(
'formConfirm', $parameters, $object, $action);
283if (empty($reshook)) {
284 $formconfirm .= $hookmanager->resPrint;
285} elseif ($reshook > 0) {
286 $formconfirm = $hookmanager->resPrint;
292$fiscal_period_nav_text = $langs->trans(
"FiscalPeriod");
294$fiscal_period_nav_text .=
' <a href="' . (isset($last_fiscal_period) ? $_SERVER[
"PHP_SELF"] .
'?fiscal_period_id=' . $last_fiscal_period[
'id'] :
'#" class="disabled') .
'">' .
img_previous() .
'</a>';
295$fiscal_period_nav_text .=
' <a href="' . (isset($next_fiscal_period) ? $_SERVER[
"PHP_SELF"] .
'?fiscal_period_id=' . $next_fiscal_period[
'id'] :
'#" class="disabled') .
'">' .
img_next() .
'</a>';
296if (!empty($current_fiscal_period)) {
297 $fiscal_period_nav_text .= $current_fiscal_period[
'label'].
' (' . (isset($current_fiscal_period) ?
dol_print_date($current_fiscal_period[
'date_start'],
'day') .
' - ' .
dol_print_date($current_fiscal_period[
'date_end'],
'day') .
')' :
'');
300print
load_fiche_titre($langs->trans(
"Closure") .
" - " . $fiscal_period_nav_text,
'',
'title_accountancy');
302if (empty($current_fiscal_period)) {
303 print $langs->trans(
'ErrorNoFiscalPeriodActiveFound', $langs->trans(
"Accounting"), $langs->trans(
"Setup"), $langs->trans(
"FiscalPeriod"));
306if (isset($current_fiscal_period)) {
309 $head[0][0] = DOL_URL_ROOT .
'/accountancy/closure/index.php?fiscal_period_id=' . $current_fiscal_period[
'id'];
310 $head[0][1] = $langs->trans(
"AccountancyClosureStep1");
311 $head[0][2] =
'step1';
314 print
'<span class="opacitymedium">' . $langs->trans(
"AccountancyClosureStep1Desc") .
'</span><br>';
316 $count_by_month =
$object->getCountByMonthForFiscalPeriod($current_fiscal_period[
'date_start'], $current_fiscal_period[
'date_end']);
317 if (!is_array($count_by_month)) {
321 if (empty($count_by_month[
'total'])) {
322 $buttonvalidate =
'<a class="butActionRefused classfortooltip" href="#">' . $langs->trans(
"ValidateMovements") .
'</a>';
324 $buttonvalidate =
'<a class="butAction" href="' . $_SERVER[
"PHP_SELF"] .
'?action=step_1&fiscal_period_id=' . $current_fiscal_period[
'id'] .
'">' . $langs->trans(
"ValidateMovements") .
'</a>';
326 print_barre_liste($langs->trans(
"OverviewOfMovementsNotValidated"),
'',
'',
'',
'',
'',
'', -1,
'',
'', 0, $buttonvalidate,
'', 0, 1, 0);
328 print
'<div class="div-table-responsive-no-min">';
329 print
'<table class="noborder centpercent">';
331 print
'<tr class="liste_titre">';
332 $nb_years = is_array($count_by_month[
'list']) ? count($count_by_month[
'list']) : 0;
334 print
'<td class="right">' . $langs->trans(
"Year") .
'</td>';
336 for ($i = 1; $i <= 12; $i++) {
337 print
'<td class="right">' . $langs->trans(
'MonthShort' . str_pad((
string) $i, 2,
'0', STR_PAD_LEFT)) .
'</td>';
339 print
'<td class="right"><b>' . $langs->trans(
"Total") .
'</b></td>';
342 if (is_array($count_by_month[
'list'])) {
343 foreach ($count_by_month[
'list'] as $info) {
344 print
'<tr class="oddeven">';
346 print
'<td class="right">' . $info[
'year'] .
'</td>';
348 for ($i = 1; $i <= 12; $i++) {
349 print
'<td class="right">' . ((int) $info[
'count'][$i]) .
'</td>';
351 print
'<td class="right"><b>' . $info[
'total'] .
'</b></td></tr>';
362 $head[0][0] = DOL_URL_ROOT .
'/accountancy/closure/index.php?fiscal_period_id=' . $current_fiscal_period[
'id'];
363 $head[0][1] = $langs->trans(
"AccountancyClosureStep2");
364 $head[0][2] =
'step2';
369 if (empty($count_by_month[
'total']) && empty($current_fiscal_period[
'status'])) {
370 $button =
'<a class="butAction" href="' . $_SERVER[
"PHP_SELF"] .
'?action=step_2&fiscal_period_id=' . $current_fiscal_period[
'id'] .
'">' . $langs->trans(
"AccountancyClosureClose") .
'</a>';
372 $button =
'<a class="butActionRefused classfortooltip" href="#">' . $langs->trans(
"AccountancyClosureClose") .
'</a>';
374 print_barre_liste(
'',
'',
'',
'',
'',
'',
'', -1,
'',
'', 0, $button,
'', 0, 1, 0);
380 $head[0][0] = DOL_URL_ROOT .
'/accountancy/closure/index.php?fiscal_period_id=' . $current_fiscal_period[
'id'];
381 $head[0][1] = $langs->trans(
"AccountancyClosureStep3");
382 $head[0][2] =
'step3';
387 if (empty($current_fiscal_period[
'status'])) {
388 $button =
'<a class="butActionRefused classfortooltip" href="#">' . $langs->trans(
"AccountancyClosureAccountingReversal") .
'</a>';
390 $button =
'<a class="butAction" href="' . $_SERVER[
"PHP_SELF"] .
'?action=step_3&fiscal_period_id=' . $current_fiscal_period[
'id'] .
'">' . $langs->trans(
"AccountancyClosureAccountingReversal") .
'</a>';
392 print_barre_liste(
'',
'',
'',
'',
'',
'',
'', -1,
'',
'', 0, $button,
'', 0, 1, 0);
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader()
Empty header.
Class to manage Ledger (General Ledger and Subledger)
dol_time_plus_duree($time, $duration_value, $duration_unit, $ruleforendofmonth=0)
Add a delay to a date.
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...
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0)
Show tabs of a record.
dol_now($mode='auto')
Return date for now.
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).
img_previous($titlealt='default', $moreatt='')
Show previous logo.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $hideselectlimit=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0)
Set event messages in dol_events session object.
img_next($titlealt='default', $moreatt='')
Show next logo.
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.