27require
'../../main.inc.php';
36require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
37require_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
38require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingjournal.class.php';
39require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/bookkeeping.class.php';
42$langs->loadLangs(array(
"banks",
"accountancy",
"compta",
"other"));
45$action =
GETPOST(
'action',
'aZ09');
47$date_startmonth =
GETPOSTINT(
'date_startmonth');
53$in_bookkeeping =
GETPOST(
'in_bookkeeping');
54if ($in_bookkeeping ==
'') {
55 $in_bookkeeping =
'notyet';
60$result =
$object->fetch($id_journal);
63} elseif ($result < 0) {
65} elseif ($result == 0) {
69$hookmanager->initHooks(array(
'globaljournal',
$object->nature.
'journal'));
73$date_end =
dol_mktime(23, 59, 59, $date_endmonth, $date_endday, $date_endyear);
78if (empty($date_startmonth)) {
82 $pastmonthyear = $dates[
'pastmonthyear'];
83 $pastmonth = $dates[
'pastmonth'];
85if (empty($date_endmonth)) {
88 $date_end = $dates[
'date_end'];
89 $pastmonthyear = $dates[
'pastmonthyear'];
90 $pastmonth = $dates[
'pastmonth'];
93if (!
GETPOSTISSET(
'date_startmonth') && (empty($date_start) || empty($date_end))) {
99if ($action ==
'writebookkeeping') {
100 $data_type =
'bookkeeping';
102if ($action ==
'exportcsv') {
105$journal_data =
$object->getData($user, $data_type, $date_start, $date_end, $in_bookkeeping);
106if (!is_array($journal_data)) {
114if ($user->socid > 0) {
117if (!$user->hasRight(
'accounting',
'bind',
'write')) {
126$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $user, $action);
131if ($action ==
'writebookkeeping' && $user->hasRight(
'accounting',
'bind',
'write')) {
134 $result =
$object->writeIntoBookkeeping($user, $journal_data);
137 $error = abs($result);
140 $nb_elements = count($journal_data);
141 if (empty($error) && $nb_elements > 0) {
142 setEventMessages($langs->trans(
"GeneralLedgerIsWritten"),
null,
'mesgs');
143 } elseif ($nb_elements == $error) {
144 setEventMessages($langs->trans(
"NoNewRecordSaved"),
null,
'warnings');
146 setEventMessages($langs->trans(
"GeneralLedgerSomeRecordWasNotRecorded"),
null,
'warnings');
150} elseif ($action ==
'exportcsv' && $user->hasRight(
'accounting',
'bind',
'write')) {
152 $result =
$object->exportCsv($journal_data, $date_end);
157 $filename =
'journal';
158 $type_export =
'journal';
160 require_once DOL_DOCUMENT_ROOT .
'/core/lib/date.lib.php';
161 include DOL_DOCUMENT_ROOT.
'/accountancy/tpl/export_journal.tpl.php';
172 $param =
'id_journal=' . $id_journal;
173 $param .=
'&date_startday=' . $date_startday;
174 $param .=
'&date_startmonth=' . $date_startmonth;
175 $param .=
'&date_startyear=' . $date_startyear;
176 $param .=
'&date_endday=' . $date_endday;
177 $param .=
'&date_endmonth=' . $date_endmonth;
178 $param .=
'&date_endyear=' . $date_endyear;
179 $param .=
'&in_bookkeeping=' . $in_bookkeeping;
180 header(
"Location: " . $_SERVER[
'PHP_SELF'] . ($param ?
'?' . $param :
''));
189$form =
new Form($db);
201} elseif (
$object->nature == 2) {
204} elseif (
$object->nature == 3) {
207} elseif (
$object->nature == 4) {
213} elseif (
$object->nature == 5) {
217 $title =
$object->getLibType();
218 $some_mandatory_steps_of_setup_were_not_done =
false;
219 $account_accounting_not_defined =
false;
222$title = $langs->trans(
"GenerationOfAccountingEntries") .
' - ' .
$object->getNomUrl(0, 2, 1,
'', 1);
223$help_url =
'EN:Module_Double_Entry_Accounting|FR:Module_Comptabilité_en_Partie_Double#Génération_des_écritures_en_comptabilité';
231$description = $langs->trans(
"DescJournalOnlyBindedVisible") .
'<br>';
234 $description .= $langs->trans(
"DepositsAreNotIncluded");
236 $description .= $langs->trans(
"DepositsAreIncluded");
239 $description .= $langs->trans(
"SupplierDepositsAreNotIncluded");
243$listofchoices = array(
'notyet' => $langs->trans(
"NotYetInGeneralLedger"),
'already' => $langs->trans(
"AlreadyInGeneralLedger"));
244$period = $form->selectDate($date_start ? $date_start : -1,
'date_start', 0, 0, 0,
'', 1, 0) .
' - ' . $form->selectDate($date_end ? $date_end : -1,
'date_end', 0, 0, 0,
'', 1, 0);
245$period .=
' - ' . $langs->trans(
"JournalizationInLedgerStatus") .
' ' . $form->selectarray(
'in_bookkeeping', $listofchoices, $in_bookkeeping, 1);
247$varlink =
'id_journal=' . $id_journal;
249journalHead($nom, $nomlink, $period, $periodlink, $description, $builddate, $exportlink, array(
'action' =>
''),
'', $varlink);
254 $sql =
"SELECT COUNT(rowid) as nb FROM ".MAIN_DB_PREFIX.
"accounting_fiscalyear WHERE entity = ".((int)
$conf->entity);
255 $resql = $db->query($sql);
257 $obj = $db->fetch_object($resql);
259 print
'<br><div class="warning">'.img_warning().
' '.$langs->trans(
"TheFiscalPeriodIsNotDefined");
260 $desc =
' : '.$langs->trans(
"AccountancyAreaDescFiscalPeriod", 4,
'{link}');
261 $desc = str_replace(
'{link}',
'<strong>'.$langs->transnoentitiesnoconv(
"MenuAccountancy").
'-'.$langs->transnoentitiesnoconv(
"Setup").
"-".$langs->transnoentitiesnoconv(
"FiscalPeriod").
'</strong>', $desc);
266 dol_print_error($db);
272 $sql =
"SELECT COUNT(rowid) as nb";
273 $sql .=
" FROM " . MAIN_DB_PREFIX .
"bank_account";
274 $sql .=
" WHERE entity = " . (int)
$conf->entity;
275 $sql .=
" AND fk_accountancy_journal IS NULL";
276 $sql .=
" AND clos=0";
277 $resql = $db->query($sql);
279 $obj = $db->fetch_object($resql);
281 print
'<br>' . img_warning() .
' ' . $langs->trans(
"TheJournalCodeIsNotDefinedOnSomeBankAccount");
282 print
' : ' . $langs->trans(
"AccountancyAreaDescBank", 9,
'<strong>' . $langs->transnoentitiesnoconv(
"MenuAccountancy") .
'-' . $langs->transnoentitiesnoconv(
"Setup") .
"-" . $langs->transnoentitiesnoconv(
"BankAccounts") .
'</strong>');
285 dol_print_error($db);
290if ($some_mandatory_steps_of_setup_were_not_done) {
291 print
'<br><div class="warning">' . img_warning() .
' ' . $langs->trans(
"SomeMandatoryStepsOfSetupWereNotDone");
292 print
' : ' . $langs->trans(
"AccountancyAreaDescMisc", 4,
'<strong>' . $langs->transnoentitiesnoconv(
"MenuAccountancy") .
'-' . $langs->transnoentitiesnoconv(
"Setup") .
"-" . $langs->transnoentitiesnoconv(
"MenuDefaultAccounts") .
'</strong>');
295print
'<br><div class="tabsAction tabsActionNoBottom centerimp">';
296if (
getDolGlobalString(
'ACCOUNTING_ENABLE_EXPORT_DRAFT_JOURNAL') && $in_bookkeeping ==
'notyet') {
297 print
'<input type="button" class="butAction" name="exportcsv" value="' . $langs->trans(
"ExportDraftJournal") .
'" onclick="launch_export();" />';
299if ($account_accounting_not_defined) {
300 print
'<input type="button" class="butActionRefused classfortooltip" title="' .
dol_escape_htmltag($langs->trans(
"SomeMandatoryStepsOfSetupWereNotDone")) .
'" value="' . $langs->trans(
"WriteBookKeeping") .
'" />';
302 if ($in_bookkeeping ==
'notyet') {
303 print
'<input type="button" class="butAction" name="writebookkeeping" value="' . $langs->trans(
"WriteBookKeeping") .
'" onclick="writebookkeeping();" />';
305 print
'<a href="#" class="butActionRefused classfortooltip" name="writebookkeeping">' . $langs->trans(
"WriteBookKeeping") .
'</a>';
312 <script type="text/javascript">
313 function launch_export() {
314 $("div.fiche form input[name=\"action\"]").val("exportcsv");
315 $("div.fiche form input[type=\"submit\"]").click();
316 $("div.fiche form input[name=\"action\"]").val("");
318 function writebookkeeping() {
319 console.log("click on writebookkeeping");
320 $("div.fiche form input[name=\"action\"]").val("writebookkeeping");
321 $("div.fiche form input[type=\"submit\"]").click();
322 $("div.fiche form input[name=\"action\"]").val("");
326$object_label = $langs->trans(
"ObjectsRef");
328 $object_label = $langs->trans(
"InvoiceRef");
331 $object_label = $langs->trans(
"ExpenseReportRef");
340print
'<div class="div-table-responsive">';
341print
'<table class="noborder centpercent">';
342print
'<tr class="liste_titre">';
343print
'<td>' . $langs->trans(
"Date") .
'</td>';
344print
'<td>' . $langs->trans(
"Piece") .
' (' . $object_label .
')</td>';
345print
'<td>' . $langs->trans(
"AccountAccounting") .
'</td>';
346print
'<td>' . $langs->trans(
"SubledgerAccount") .
'</td>';
347print
'<td>' . $langs->trans(
"LabelOperation") .
'</td>';
349 print
'<td class="center">' . $langs->trans(
"PaymentMode") .
'</td>';
351print
'<td class="right">' . $langs->trans(
"AccountingDebit") .
'</td>';
352print
'<td class="right">' . $langs->trans(
"AccountingCredit") .
'</td>';
355if (is_array($journal_data) && !empty($journal_data)) {
356 foreach ($journal_data as $element_id => $element) {
357 foreach ($element[
'blocks'] as $lines) {
358 foreach ($lines as $line) {
359 print
'<tr class="oddeven">';
360 print
'<td>' . $line[
'date'] .
'</td>';
361 print
'<td>' . $line[
'piece'] .
'</td>';
362 print
'<td>' . $line[
'account_accounting'] .
'</td>';
363 print
'<td>' . $line[
'subledger_account'] .
'</td>';
364 print
'<td>' . $line[
'label_operation'] .
'</td>';
366 print
'<td class="center">' . $line[
'payment_mode'] .
'</td>';
368 print
'<td class="right nowraponall">' . $line[
'debit'] .
'</td>';
369 print
'<td class="right nowraponall">' . $line[
'credit'] .
'</td>';
383 print
'<tr class="oddeven"><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
if(! $sortfield) if(! $sortorder) $object
journalHead($nom, $variant, $period, $periodlink, $description, $builddate, $exportlink='', $moreparam=array(), $calcmode='', $varlink='', $moreoptions=array())
Show header of a page used to transfer/dispatch data in accounting.
getDefaultDatesForTransfer()
Return Default dates for transfer based on periodicity option in accountancy setup.
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
Class to manage accounting journals.
dol_get_first_day($year, $month=1, $gm=false)
Return GMT time for first day of a month or year.
dol_get_last_day($year, $month=12, $gm=false)
Return GMT time for last day of a month or year.
$date_start
Variables from include:
dol_now($mode='gmt')
Return date for now.
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...
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.