28require
'../../main.inc.php';
29require_once DOL_DOCUMENT_ROOT.
'/expensereport/class/expensereport.class.php';
30require_once DOL_DOCUMENT_ROOT.
'/expensereport/class/paymentexpensereport.class.php';
31require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
42$langs->loadLangs(array(
'bills',
'banks',
'trips'));
46$action =
GETPOST(
'action',
'aZ09');
53if ($id > 0 || !empty($ref)) {
54 $result =
$object->fetch($id, $ref);
62if ($user->socid > 0) {
63 $socid = $user->socid;
68if (!$user->hasRight(
'expensereport',
'lire') || !
checkUserAccessToObject($user, array(
'expensereport'), $object,
'expensereport')) {
72$permissiontoadd = $user->hasRight(
'expensereport',
'to_paid');
80if ($action ==
'add_payment' && $permissiontoadd) {
84 $loc = DOL_URL_ROOT.
'/expensereport/card.php?id='.
$id;
85 header(
"Location: ".$loc);
90 $result = $expensereport->fetch($id, $ref);
97 setEventMessages($langs->trans(
'StatusOfRefMustBe', $expensereport->ref, $langs->transnoentitiesnoconv(
'Approved')),
null,
'errors');
103 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentities(
"PaymentMode")),
null,
'errors');
106 if ($datepaid ==
'') {
107 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentities(
"Date")),
null,
'errors');
111 if (isModEnabled(
"bank") && !($accountid > 0)) {
112 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentities(
"AccountToDebit")),
null,
'errors');
121 foreach ($_POST as $key => $value) {
122 if (substr($key, 0, 7) ==
'amount_') {
124 $amounts[$expensereport->fk_user_author] = (float)
price2num(
GETPOST($key));
130 if (count($amounts) <= 0) {
135 $remaintopay = (float)
price2num($expensereport->total_ttc - $expensereport->getSumPayments(),
'MT');
136 if (!$error && (
float)
price2num(array_sum($amounts),
'MT') > $remaintopay) {
138 setEventMessages($langs->trans(
'PaymentHigherThanReminderToPay'),
null,
'errors');
146 $payment->fk_expensereport = $expensereport->id;
147 $payment->datep = $datepaid;
148 $payment->amounts = $amounts;
151 $payment->fk_typepayment =
GETPOSTINT(
"fk_typepayment");
152 $payment->num_payment =
GETPOST(
"num_payment",
'alphanohtml');
153 $payment->note_public =
GETPOST(
"note_public",
'restricthtml');
154 $payment->fk_bank = $accountid;
157 $paymentid = $payment->create($user);
158 if ($paymentid < 0) {
165 $result = $payment->addPaymentToBank($user,
'payment_expensereport',
'(ExpenseReportPayment)', $accountid,
'',
'');
173 $payment->fetch($paymentid);
175 $remaintopay =
price2num($expensereport->total_ttc - $expensereport->getSumPayments(),
'MT');
176 if ($remaintopay <= 0) {
177 $result = $expensereport->setPaid($expensereport->id, $user);
178 if (!($result > 0)) {
187 $loc = DOL_URL_ROOT.
'/expensereport/card.php?id='.
$id;
188 header(
'Location: '.$loc);
206$form =
new Form($db);
210if ($action ==
'create' || empty($action)) {
212 $expensereport->fetch($id, $ref);
214 $total = $expensereport->total_ttc;
217 if (!empty(
$conf->use_javascript_ajax)) {
218 print
"\n".
'<script type="text/javascript">';
220 print
' $(document).ready(function () {';
221 print
' $(".AutoFillAmount").on(\'click touchstart\', function(){
222 var amount = $(this).data("value");
223 document.getElementById($(this).data(\'rowid\')).value = amount ;
231 print
'<form name="add_payment" action="'.$_SERVER[
'PHP_SELF'].
'" method="post">';
232 print
'<input type="hidden" name="token" value="'.newToken().
'">';
233 print
'<input type="hidden" name="id" value="'.$expensereport->id.
'">';
234 print
'<input type="hidden" name="chid" value="'.$expensereport->id.
'">';
235 print
'<input type="hidden" name="action" value="add_payment">';
242 dol_banner_tab($expensereport,
'ref', $linkback, 1,
'ref',
'ref',
'');
244 print
'<div class="fichecenter">';
245 print
'<div class="underbanner clearboth"></div>';
247 print
'<table class="border centpercent">'.
"\n";
249 print
'<tr><td class="titlefield">'.$langs->trans(
"Period").
'</td><td>'.
get_date_range($expensereport->date_debut, $expensereport->date_fin,
"", $langs, 0).
'</td></tr>';
250 print
'<tr><td>'.$langs->trans(
"Amount").
'</td><td><span class="amount">'.
price($expensereport->total_ttc, 0, $langs, 1, -1, -1,
$conf->currency).
'</span></td></tr>';
252 $sql =
"SELECT sum(p.amount) as total";
253 $sql .=
" FROM ".MAIN_DB_PREFIX.
"payment_expensereport as p, ".MAIN_DB_PREFIX.
"expensereport as e";
254 $sql .=
" WHERE p.fk_expensereport = e.rowid AND p.fk_expensereport = ".((int) $id);
255 $sql .=
' AND e.entity IN ('.getEntity(
'expensereport').
')';
257 $resql = $db->query($sql);
259 $obj = $db->fetch_object($resql);
260 $sumpaid = $obj->total;
263 print
'<tr><td>'.$langs->trans(
"AlreadyPaid").
'</td><td><span class="amount">'.
price($sumpaid, 0, $langs, 1, -1, -1,
$conf->currency).
'</span></td></tr>';
264 print
'<tr><td class="tdtop">'.$langs->trans(
"RemainderToPay").
'</td><td><span class="amount">'.
price($total - $sumpaid, 0, $langs, 1, -1, -1,
$conf->currency).
'</span></td></tr>';
276 print
'<table class="border centpercent">'.
"\n";
278 print
'<tr><td class="titlefield fieldrequired">'.$langs->trans(
"Date").
'</td><td colspan="2">';
280 $datepayment = ($datepaid ==
'' ? (!
getDolGlobalString(
'MAIN_AUTOFILL_DATE') ? -1 :
'') : $datepaid);
281 print $form->selectDate($datepayment,
'', 0, 0, 0,
"add_payment", 1, 1);
285 print
'<tr><td class="fieldrequired">'.$langs->trans(
"PaymentMode").
'</td><td colspan="2">';
286 $form->select_types_paiements(GETPOSTISSET(
"fk_typepayment") ?
GETPOST(
"fk_typepayment",
'alpha') : $expensereport->fk_c_paiement,
"fk_typepayment");
290 if (isModEnabled(
"bank")) {
292 print
'<td class="fieldrequired">'.$langs->trans(
'AccountToDebit').
'</td>';
293 print
'<td colspan="2">';
294 print
img_picto(
'',
'bank_account',
'class="pictofixedwidth"');
295 $form->select_comptes(GETPOSTISSET(
"accountid") ?
GETPOSTINT(
"accountid") : 0,
"accountid", 0,
'', 2);
300 print
'<tr><td>'.$langs->trans(
'Numero');
301 print
' <em>('.$langs->trans(
"ChequeOrTransferNumber").
')</em>';
303 print
'<td colspan="2"><input name="num_payment" type="text" value="'.GETPOST(
'num_payment').
'"></td></tr>'.
"\n";
306 print
'<td class="tdtop">'.$langs->trans(
"Comments").
'</td>';
307 print
'<td valign="top" colspan="2"><textarea name="note_public" wrap="soft" cols="60" rows="'.ROWS_3.
'"></textarea></td>';
320 print
'<table class="noborder centpercent">';
321 print
'<tr class="liste_titre">';
322 print
'<td>'.$langs->trans(
"ExpenseReport").
'</td>';
323 print
'<td class="right">'.$langs->trans(
"Amount").
'</td>';
324 print
'<td class="right">'.$langs->trans(
"AlreadyPaid").
'</td>';
325 print
'<td class="right">'.$langs->trans(
"RemainderToPay").
'</td>';
326 print
'<td class="center">'.$langs->trans(
"Amount").
'</td>';
333 $objp = $expensereport;
335 print
'<tr class="oddeven">';
337 print
'<td>'.$expensereport->getNomUrl(1).
"</td>";
338 print
'<td class="right">'.price($objp->total_ttc).
"</td>";
339 print
'<td class="right">'.price($sumpaid).
"</td>";
340 print
'<td class="right">'.price($objp->total_ttc - $sumpaid).
"</td>";
341 print
'<td class="center">';
342 if ($sumpaid < $objp->total_ttc) {
343 $namef =
"amount_".$objp->id;
344 $nameRemain =
"remain_".$objp->id;
345 if (!empty(
$conf->use_javascript_ajax)) {
346 print
img_picto(
"Auto fill",
'rightarrow',
"class='AutoFillAmount' data-rowid='".$namef.
"' data-value='".($objp->total_ttc - $sumpaid).
"'");
348 $remaintopay = $objp->total_ttc - $sumpaid;
349 print
'<input type=hidden class="sum_remain" name="'.$nameRemain.
'" value="'.$remaintopay.
'">';
350 print
'<input type="text" class="width75" name="'.$namef.
'" id="'.$namef.
'" value="'.
GETPOST($namef).
'">';
358 $total_ttc += $objp->total_ttc;
359 $totalrecu += $sumpaid;
364 print
'<tr class="oddeven">';
365 print
'<td colspan="2" class="left">'.$langs->trans(
"Total").
':</td>';
366 print
'<td class="right"><b>'.price($total_ttc).
'</b></td>';
367 print
'<td class="right"><b>'.price($totalrecu).
'</b></td>';
368 print
'<td class="right"><b>'.price($total_ttc - $totalrecu).
'</b></td>';
369 print
'<td class="center"> </td>';
375 print $form->buttonsSaveCancel();
$id
Support class for third parties, contacts, members, users or resources.
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
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.
Class to manage Trips and Expenses.
const STATUS_APPROVED
Classified approved.
Class to manage payments of expense report.
recordNotFound($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Displays an error page when a record is not found.
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.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
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.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
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.
get_date_range($date_start, $date_end, $format='', $outputlangs=null, $withparenthesis=1)
Format output for start and end date.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
checkUserAccessToObject($user, array $featuresarray, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='', $dbt_select='rowid', $parenttableforentity='')
Check that access by a given user to an object is ok.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.