dolibarr 23.0.4
card.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2015-2017 Alexandre Spangaro <aspangaro@open-dsi.fr>
3 * Copyright (C) 2024-2025 MDW <mdeweerd@users.noreply.github.com>
4 * Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
5 *
6 * This program is free software; you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation; either version 3 of the License, or
9 * (at your option) any later version.
10 *
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
15 *
16 * You should have received a copy of the GNU General Public License
17 * along with this program. If not, see <https://www.gnu.org/licenses/>.
18 */
19
26// Load Dolibarr environment
27require '../../main.inc.php';
35require_once DOL_DOCUMENT_ROOT.'/expensereport/class/expensereport.class.php';
36require_once DOL_DOCUMENT_ROOT.'/expensereport/class/paymentexpensereport.class.php';
37require_once DOL_DOCUMENT_ROOT.'/core/modules/expensereport/modules_expensereport.php';
38require_once DOL_DOCUMENT_ROOT.'/core/lib/expensereport.lib.php';
39if (isModEnabled("bank")) {
40 require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';
41}
42
43// Load translation files required by the page
44$langs->loadLangs(array('bills', 'banks', 'companies', 'trips'));
45
46$id = GETPOST('rowid') ? GETPOSTINT('rowid') : GETPOSTINT('id');
47$action = GETPOST('action', 'aZ09');
48$confirm = GETPOST('confirm');
49
51
52if ($id > 0) {
53 $result = $object->fetch($id);
54 if (!$result) {
55 dol_print_error($db, 'Failed to get payment id '.$id);
56 }
57}
58
59// Security check
60if ($user->socid) {
61 $socid = $user->socid;
62}
63
64// Load the parent expense report so restrictedArea() can also check the user hierarchy
65$expensereport = new ExpenseReport($db);
66if ($object->fk_expensereport > 0) {
67 if ($expensereport->fetch($object->fk_expensereport) <= 0) {
69 }
70}
71
72$result = restrictedArea($user, 'expensereport', ($expensereport->id > 0 ? $expensereport : 0), 'expensereport');
73
74
75/*
76 * Actions
77 */
78
79// Delete payment
80if ($action == 'confirm_delete' && $confirm == 'yes' && $user->hasRight('expensereport', 'supprimer')) {
81 $db->begin();
82
83 $result = $object->delete($user);
84 if ($result > 0) {
85 $db->commit();
86 header("Location: ".DOL_URL_ROOT."/expensereport/index.php");
87 exit;
88 } else {
89 setEventMessages($object->error, $object->errors, 'errors');
90 $db->rollback();
91 }
92}
93
94
95/*
96 * View
97 */
98
99llxHeader('', $langs->trans("ExpenseReportPayment"));
100
101$form = new Form($db);
102
104
105print dol_get_fiche_head($head, 'payment', $langs->trans("ExpenseReportPayment"), -1, 'payment');
106
107/*
108 * Confirm deleting of the payment
109 */
110if ($action == 'delete') {
111 print $form->formconfirm('card.php?id='.$object->id, $langs->trans("DeletePayment"), $langs->trans("ConfirmDeletePayment"), 'confirm_delete', '', 0, 2);
112}
113
114$linkback = '';
115// $linkback = '<a href="' . DOL_URL_ROOT . '/expensereport/payment/list.php">' . $langs->trans("BackToList") . '</a>';
116
117dol_banner_tab($object, 'ref', $linkback, 1, 'ref', 'ref', '');
118
119print '<div class="fichecenter">';
120print '<div class="underbanner clearboth"></div>';
121
122print '<table class="border centpercent">'."\n";
123
124// Date payment
125print '<tr><td class="titlefield">'.$langs->trans('Date').'</td><td>'.dol_print_date($object->datep, 'day').'</td></tr>';
126
127// Mode
128print '<tr><td>'.$langs->trans('PaymentMode').'</td><td>'.$langs->trans("PaymentType".$object->type_code).'</td></tr>';
129
130// Number
131print '<tr><td>'.$langs->trans('Numero').'</td><td>'.dol_escape_htmltag($object->num_payment).'</td></tr>';
132
133// Amount
134print '<tr><td>'.$langs->trans('Amount').'</td><td>'.price($object->amount, 0, $langs, 1, -1, -1, $conf->currency).'</td></tr>';
135
136// Note public
137print '<tr><td class="tdtop">'.$langs->trans('Note').'</td><td class="valeur sensiblehtmlcontent">'.dol_string_onlythesehtmltags(dol_htmlentitiesbr($object->note_public)).'</td></tr>';
138
139$disable_delete = 0;
140$title_button = '';
141// Bank account
142if (isModEnabled("bank")) {
143 if ($object->bank_account) {
144 $bankline = new AccountLine($db);
145 $bankline->fetch($object->bank_line);
146 if ($bankline->rappro) {
147 $disable_delete = 1;
148 $title_button = dol_escape_htmltag($langs->transnoentitiesnoconv("CantRemoveConciliatedPayment"));
149 }
150
151 print '<tr>';
152 print '<td>'.$langs->trans('BankTransactionLine').'</td>';
153 print '<td colspan="3">';
154 print $bankline->getNomUrl(1, 0, 'showconciliated');
155 print '</td>';
156 print '</tr>';
157
158 print '<tr>';
159 print '<td>'.$langs->trans('BankAccount').'</td>';
160 print '<td colspan="3">';
161 $accountstatic = new Account($db);
162 $accountstatic->fetch($bankline->fk_account);
163 print $accountstatic->getNomUrl(1);
164 print '</td>';
165 print '</tr>';
166 }
167}
168
169print '</table>';
170
171print '</div>';
172
173print dol_get_fiche_end();
174
175
176/*
177 * List of expense report paid
178 */
179
180$sql = 'SELECT er.rowid as eid, er.paid, er.total_ttc, per.amount';
181$sql .= ' FROM '.MAIN_DB_PREFIX.'payment_expensereport as per,'.MAIN_DB_PREFIX.'expensereport as er';
182$sql .= ' WHERE per.fk_expensereport = er.rowid';
183$sql .= ' AND er.entity IN ('.getEntity('expensereport').')';
184$sql .= ' AND per.rowid = '.((int) $id);
185
186dol_syslog("expensereport/payment/card.php", LOG_DEBUG);
187$resql = $db->query($sql);
188if ($resql) {
189 $num = $db->num_rows($resql);
190
191 $i = 0;
192 $total = 0;
193 print '<br>';
194
195 print '<div class="div-table-responsive">';
196 print '<table class="noborder centpercent">';
197
198 print '<tr class="liste_titre">';
199 print '<td>'.$langs->trans('ExpenseReport').'</td>';
200 print '<td class="right">'.$langs->trans('ExpectedToPay').'</td>';
201 print '<td class="right">'.$langs->trans('PayedByThisPayment').'</td>';
202 print '<td class="right">'.$langs->trans('RemainderToPay').'</td>';
203 print '<td class="center">'.$langs->trans('Status').'</td>';
204 print "</tr>\n";
205
206 if ($num > 0) {
207 while ($i < $num) {
208 $objp = $db->fetch_object($resql);
209
210 print '<tr class="oddeven">';
211
212 $expensereport = new ExpenseReport($db);
213 $expensereport->fetch($objp->eid);
214
215 // Expense report
216 print '<td>';
217 print $expensereport->getNomUrl(1);
218 print "</td>\n";
219
220 // Expected to pay
221 print '<td class="right">'.price($objp->total_ttc).'</td>';
222
223 // Amount paid
224 print '<td class="right">'.price($objp->amount).'</td>';
225
226 // Remain to pay
227 print '<td class="right">'.price($objp->total_ttc - $objp->amount).'</td>';
228
229 // Status
230 print '<td class="center">'.$expensereport->getLibStatut(4).'</td>';
231
232 print "</tr>\n";
233
234 if ($objp->paid == 1) { // If at least one invoice is paid, disable delete
235 $disable_delete = 2;
236 $title_button = $langs->trans("CantRemovePaymentWithOneInvoicePaid");
237 }
238 $total += $objp->amount;
239 $i++;
240 }
241 }
242
243
244 print "</table>\n";
245 print '</div>';
246
247 $db->free($resql);
248} else {
249 dol_print_error($db);
250}
251
252
253
254/*
255 * Actions buttons
256 */
257print '<div class="tabsAction">';
258
259// Delete
260if ($action == '') {
261 if ($user->hasRight('expensereport', 'supprimer')) {
262 if (!$disable_delete) {
263 print dolGetButtonAction($langs->trans("Delete"), '', 'delete', $_SERVER["PHP_SELF"].'?id='.$object->id.'&action=delete&token='.newToken(), 'delete', 1);
264 } else {
265 print dolGetButtonAction($title_button, $langs->trans("Delete"), 'delete', $_SERVER["PHP_SELF"].'?id='.$object->id.'&action=delete&token='.newToken(), 'delete', 0);
266 }
267 }
268}
269
270print '</div>';
271
272// End of page
273llxFooter();
274$db->close();
$id
Support class for third parties, contacts, members, users or resources.
Definition account.php:47
if(! $sortfield) if(! $sortorder) $object
Definition account.php:100
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
Definition wrapper.php:91
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.
Definition wrapper.php:73
Class to manage bank accounts.
Class to manage bank transaction lines.
Class to manage Trips and Expenses.
Class to manage generation of HTML components Only common components must be here.
Class to manage payments of expense report.
payment_expensereport_prepare_head(PaymentExpenseReport $object)
Returns an array with the tabs for the "Expense report payment" section It loads tabs from modules lo...
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
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, $morecssdiv='')
Show tabs of a record.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
dolGetButtonAction($label, $text='', $actionType='default', $url='', $id='', $userRight=1, $params=array())
Function dolGetButtonAction.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_htmlentitiesbr($stringtoencode, $nl2brmode=0, $pagecodefrom='UTF-8', $removelasteolbr=1)
This function is called to encode a string into a HTML string but differs from htmlentities because a...
dol_string_onlythesehtmltags($stringtoclean, $cleanalsosomestyles=1, $removeclassattribute=1, $cleanalsojavascript=0, $allowiframe=0, $allowed_tags=array(), $allowlink=0, $allowscript=0, $allowstyle=0, $allowphp=0)
Clean a string to keep only desirable HTML tags.
isModEnabled($module)
Is Dolibarr module enabled.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $mode=0)
Check permissions of a user to show a page and an object.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.