dolibarr 20.0.0
card.php
1<?php
2/* Copyright (C) 2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2005 Simon TOSSER <simon@kornog-computing.com>
4 * Copyright (C) 2013-2024 Alexandre Spangaro <alexandre@inovea-conseil.com>
5 * Copyright (C) 2013-2014 Olivier Geffroy <jeff@jeffinfo.com>
6 * Copyright (C) 2013-2014 Florian Henry <florian.henry@open-concept.pro>
7 * Copyright (C) 2014 Juanjo Menent <jmenent@2byte.es>
8 * Copyright (C) 2015 Jean-François Ferry <jfefe@aternatik.fr>
9 *
10 * This program is free software; you can redistribute it and/or modify
11 * it under the terms of the GNU General Public License as published by
12 * the Free Software Foundation; either version 3 of the License, or
13 * (at your option) any later version.
14 *
15 * This program is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU General Public License for more details.
19 *
20 * You should have received a copy of the GNU General Public License
21 * along with this program. If not, see <https://www.gnu.org/licenses/>.
22 *
23 */
29require '../../main.inc.php';
30
31require_once DOL_DOCUMENT_ROOT.'/expensereport/class/expensereport.class.php';
32require_once DOL_DOCUMENT_ROOT.'/core/class/html.formaccounting.class.php';
33
34// Load translation files required by the page
35$langs->loadLangs(array("bills", "accountancy", "trips"));
36
37$action = GETPOST('action', 'aZ09');
38$cancel = GETPOST('cancel', 'alpha');
39$backtopage = GETPOST('backtopage', 'alpha');
40
41$codeventil = GETPOSTINT('codeventil');
42$id = GETPOSTINT('id');
43
44// Security check
45if (!isModEnabled('accounting')) {
47}
48if ($user->socid > 0) {
50}
51if (!$user->hasRight('accounting', 'bind', 'write')) {
53}
54
55
56/*
57 * Actions
58 */
59
60if ($action == 'ventil' && $user->hasRight('accounting', 'bind', 'write')) {
61 if (!$cancel) {
62 if ($codeventil < 0) {
63 $codeventil = 0;
64 }
65
66 $sql = " UPDATE ".MAIN_DB_PREFIX."expensereport_det";
67 $sql .= " SET fk_code_ventilation = ".((int) $codeventil);
68 $sql .= " WHERE rowid = ".((int) $id);
69
70 $resql = $db->query($sql);
71 if (!$resql) {
72 setEventMessages($db->lasterror(), null, 'errors');
73 } else {
74 setEventMessages($langs->trans("RecordModifiedSuccessfully"), null, 'mesgs');
75 if ($backtopage) {
76 header("Location: ".$backtopage);
77 exit();
78 }
79 }
80 } else {
81 header("Location: ./lines.php");
82 exit();
83 }
84}
85
86
87
88/*
89 * View
90 */
91$help_url ='EN:Module_Double_Entry_Accounting|FR:Module_Comptabilit&eacute;_en_Partie_Double#Liaisons_comptables';
92
93llxHeader("", $langs->trans('FicheVentilation'), $help_url, '', 0, 0, '', '', '', 'mod-accountancy accountancy-expensereport page-card');
94
95if ($cancel == $langs->trans("Cancel")) {
96 $action = '';
97}
98
99// Create
100$form = new Form($db);
101$expensereport_static = new ExpenseReport($db);
102$formaccounting = new FormAccounting($db);
103
104if (!empty($id)) {
105 $sql = "SELECT er.ref, er.rowid as facid, erd.fk_c_type_fees, erd.comments, erd.rowid, erd.fk_code_ventilation,";
106 $sql .= " f.id as type_fees_id, f.code as type_fees_code, f.label as type_fees_label,";
107 $sql .= " aa.account_number, aa.label";
108 $sql .= " FROM ".MAIN_DB_PREFIX."expensereport_det as erd";
109 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_type_fees as f ON f.id = erd.fk_c_type_fees";
110 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."accounting_account as aa ON erd.fk_code_ventilation = aa.rowid";
111 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."expensereport as er ON er.rowid = erd.fk_expensereport";
112 $sql .= " WHERE er.fk_statut > 0 AND erd.rowid = ".((int) $id);
113 $sql .= " AND er.entity IN (".getEntity('expensereport', 0).")"; // We don't share object for accountancy
114
115 dol_syslog("/accounting/expensereport/card.php", LOG_DEBUG);
116 $result = $db->query($sql);
117
118 if ($result) {
119 $num_lines = $db->num_rows($result);
120 $i = 0;
121
122 if ($num_lines) {
123 $objp = $db->fetch_object($result);
124
125 print '<form action="'.$_SERVER["PHP_SELF"].'?id='.$id.'" method="post">'."\n";
126 print '<input type="hidden" name="token" value="'.newToken().'">';
127 print '<input type="hidden" name="action" value="ventil">';
128 print '<input type="hidden" name="backtopage" value="'.dol_escape_htmltag($backtopage).'">';
129
130 print load_fiche_titre($langs->trans('ExpenseReportsVentilation'), '', 'title_accountancy');
131
132 print dol_get_fiche_head();
133
134 print '<table class="border centpercent">';
135
136 // Ref
137 print '<tr><td class="titlefield">'.$langs->trans("ExpenseReport").'</td>';
138 $expensereport_static->ref = $objp->ref;
139 $expensereport_static->id = $objp->erid;
140 print '<td>'.$expensereport_static->getNomUrl(1).'</td>';
141 print '</tr>';
142
143 print '<tr><td>'.$langs->trans("Line").'</td>';
144 print '<td>'.stripslashes(nl2br($objp->rowid)).'</td></tr>';
145
146 print '<tr><td>'.$langs->trans("Description").'</td>';
147 print '<td>'.stripslashes(nl2br($objp->comments)).'</td></tr>';
148
149 print '<tr><td>'.$langs->trans("TypeFees").'</td>';
150 print '<td>'.($langs->trans($objp->type_fees_code) == $objp->type_fees_code ? $objp->type_fees_label : $langs->trans(($objp->type_fees_code))).'</td>';
151
152 print '<tr><td>'.$langs->trans("Account").'</td><td>';
153 print $formaccounting->select_account($objp->fk_code_ventilation, 'codeventil', 1);
154 print '</td></tr>';
155 print '</table>';
156
157 print dol_get_fiche_end();
158
159 print '<div class="center">';
160 print '<input class="button button-save" type="submit" value="'.$langs->trans("Save").'">';
161 print '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
162 print '<input class="button button-cancel" type="submit" name="cancel" value="'.$langs->trans("Cancel").'">';
163 print '</div>';
164
165 print '</form>';
166 } else {
167 print "Error";
168 }
169 } else {
170 print "Error";
171 }
172} else {
173 print "Error ID incorrect";
174}
175
176// End of page
177llxFooter();
178$db->close();
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader()
Empty header.
Definition wrapper.php:55
llxFooter()
Empty footer.
Definition wrapper.php:69
Class to manage Trips and Expenses.
Class to manage generation of HTML components for accounting management.
Class to manage generation of HTML components Only common components must be here.
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_get_fiche_end($notab=0)
Return tab footer of a card.
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.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.