28require
'../../main.inc.php';
36require_once DOL_DOCUMENT_ROOT.
'/expensereport/class/expensereport.class.php';
37require_once DOL_DOCUMENT_ROOT.
'/expensereport/class/paymentexpensereport.class.php';
38require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
41$langs->loadLangs(array(
'bills',
'banks',
'trips'));
45$action =
GETPOST(
'action',
'aZ09');
52if ($id > 0 || !empty($ref)) {
53 $result =
$object->fetch($id, $ref);
61if ($user->socid > 0) {
62 $socid = $user->socid;
67if (!$user->hasRight(
'expensereport',
'lire') || !
checkUserAccessToObject($user, array(
'expensereport'), $object,
'expensereport')) {
71$permissiontoadd = $user->hasRight(
'expensereport',
'to_paid');
78if ($action ==
'add_payment' && $permissiontoadd) {
82 $loc = DOL_URL_ROOT.
'/expensereport/card.php?id='.
$id;
83 header(
"Location: ".$loc);
88 $result = $expensereport->fetch($id, $ref);
95 setEventMessages($langs->trans(
'StatusOfRefMustBe', $expensereport->ref, $langs->transnoentitiesnoconv(
'Approved')),
null,
'errors');
101 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentities(
"PaymentMode")),
null,
'errors');
104 if ($datepaid ==
'') {
105 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentities(
"Date")),
null,
'errors');
110 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentities(
"AccountToDebit")),
null,
'errors');
119 foreach ($_POST as $key => $value) {
120 if (substr($key, 0, 7) ==
'amount_') {
122 $amounts[$expensereport->fk_user_author] = (float)
price2num(
GETPOST($key));
128 if (count($amounts) <= 0) {
133 $remaintopay = (float)
price2num($expensereport->total_ttc - $expensereport->getSumPayments(),
'MT');
134 if (!$error && (
float)
price2num(array_sum($amounts),
'MT') > $remaintopay) {
136 setEventMessages($langs->trans(
'PaymentHigherThanReminderToPay'),
null,
'errors');
144 $payment->fk_expensereport = $expensereport->id;
145 $payment->datep = $datepaid;
146 $payment->amounts = $amounts;
149 $payment->fk_typepayment =
GETPOSTINT(
"fk_typepayment");
150 $payment->num_payment =
GETPOST(
"num_payment",
'alphanohtml');
151 $payment->note_public =
GETPOST(
"note_public",
'restricthtml');
152 $payment->fk_bank = $accountid;
155 $paymentid = $payment->create($user);
156 if ($paymentid < 0) {
163 $result = $payment->addPaymentToBank($user,
'payment_expensereport',
'(ExpenseReportPayment)', $accountid,
'',
'');
171 $payment->fetch($paymentid);
173 $remaintopay =
price2num($expensereport->total_ttc - $expensereport->getSumPayments(),
'MT');
174 if ($remaintopay <= 0) {
175 $result = $expensereport->setPaid($expensereport->id, $user);
176 if (!($result > 0)) {
185 $loc = DOL_URL_ROOT.
'/expensereport/card.php?id='.
$id;
186 header(
'Location: '.$loc);
204$form =
new Form($db);
208if ($action ==
'create' || empty($action)) {
210 $expensereport->fetch($id, $ref);
212 $total = $expensereport->total_ttc;
215 if (!empty($conf->use_javascript_ajax)) {
216 print
"\n".
'<script type="text/javascript">';
218 print
' $(document).ready(function () {';
219 print
' $(".AutoFillAmount").on(\'click touchstart\', function(){
220 var amount = $(this).data("value");
221 document.getElementById($(this).data(\'rowid\')).value = amount ;
229 print
'<form name="add_payment" action="'.$_SERVER[
'PHP_SELF'].
'" method="post">';
230 print
'<input type="hidden" name="token" value="'.newToken().
'">';
231 print
'<input type="hidden" name="id" value="'.$expensereport->id.
'">';
232 print
'<input type="hidden" name="chid" value="'.$expensereport->id.
'">';
233 print
'<input type="hidden" name="action" value="add_payment">';
240 dol_banner_tab($expensereport,
'ref', $linkback, 1,
'ref',
'ref',
'');
242 print
'<div class="fichecenter">';
243 print
'<div class="underbanner clearboth"></div>';
245 print
'<table class="border centpercent">'.
"\n";
247 print
'<tr><td class="titlefield">'.$langs->trans(
"Period").
'</td><td>'.
get_date_range($expensereport->date_debut, $expensereport->date_fin,
"", $langs, 0).
'</td></tr>';
248 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>';
250 $sql =
"SELECT sum(p.amount) as total";
251 $sql .=
" FROM ".MAIN_DB_PREFIX.
"payment_expensereport as p, ".MAIN_DB_PREFIX.
"expensereport as e";
252 $sql .=
" WHERE p.fk_expensereport = e.rowid AND p.fk_expensereport = ".((int) $id);
253 $sql .=
' AND e.entity IN ('.getEntity(
'expensereport').
')';
255 $resql = $db->query($sql);
257 $obj = $db->fetch_object($resql);
258 $sumpaid = $obj->total;
261 print
'<tr><td>'.$langs->trans(
"AlreadyPaid").
'</td><td><span class="amount">'.
price($sumpaid, 0, $langs, 1, -1, -1, $conf->currency).
'</span></td></tr>';
262 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>';
274 print
'<table class="border centpercent">'.
"\n";
276 print
'<tr><td class="titlefield fieldrequired">'.$langs->trans(
"Date").
'</td><td colspan="2">';
278 $datepayment = ($datepaid ==
'' ? (!
getDolGlobalString(
'MAIN_AUTOFILL_DATE') ? -1 :
'') : $datepaid);
279 print $form->selectDate($datepayment,
'', 0, 0, 0,
"add_payment", 1, 1);
283 print
'<tr><td class="fieldrequired">'.$langs->trans(
"PaymentMode").
'</td><td colspan="2">';
284 $form->select_types_paiements(GETPOSTISSET(
"fk_typepayment") ?
GETPOST(
"fk_typepayment",
'alpha') : $expensereport->fk_c_paiement,
"fk_typepayment");
290 print
'<td class="fieldrequired">'.$langs->trans(
'AccountToDebit').
'</td>';
291 print
'<td colspan="2">';
292 print
img_picto(
'',
'bank_account',
'class="pictofixedwidth"');
293 $form->select_comptes(GETPOSTISSET(
"accountid") ?
GETPOSTINT(
"accountid") : 0,
"accountid", 0,
'', 2);
298 print
'<tr><td>'.$langs->trans(
'Numero');
299 print
' <em>('.$langs->trans(
"ChequeOrTransferNumber").
')</em>';
301 print
'<td colspan="2"><input name="num_payment" type="text" value="'.GETPOST(
'num_payment').
'"></td></tr>'.
"\n";
304 print
'<td class="tdtop">'.$langs->trans(
"Comments").
'</td>';
305 print
'<td valign="top" colspan="2"><textarea name="note_public" wrap="soft" cols="60" rows="'.ROWS_3.
'"></textarea></td>';
318 print
'<table class="noborder centpercent">';
319 print
'<tr class="liste_titre">';
320 print
'<td>'.$langs->trans(
"ExpenseReport").
'</td>';
321 print
'<td class="right">'.$langs->trans(
"Amount").
'</td>';
322 print
'<td class="right">'.$langs->trans(
"AlreadyPaid").
'</td>';
323 print
'<td class="right">'.$langs->trans(
"RemainderToPay").
'</td>';
324 print
'<td class="center">'.$langs->trans(
"Amount").
'</td>';
331 $objp = $expensereport;
333 print
'<tr class="oddeven">';
335 print
'<td>'.$expensereport->getNomUrl(1).
"</td>";
336 print
'<td class="right">'.price($objp->total_ttc).
"</td>";
337 print
'<td class="right">'.price($sumpaid).
"</td>";
338 print
'<td class="right">'.price($objp->total_ttc - $sumpaid).
"</td>";
339 print
'<td class="center">';
340 if ($sumpaid < $objp->total_ttc) {
341 $namef =
"amount_".$objp->id;
342 $nameRemain =
"remain_".$objp->id;
343 if (!empty($conf->use_javascript_ajax)) {
344 print
img_picto(
"Auto fill",
'rightarrow.png',
"class='AutoFillAmount' data-rowid='".$namef.
"' data-value='".($objp->total_ttc - $sumpaid).
"'");
346 $remaintopay = $objp->total_ttc - $sumpaid;
347 print
'<input type=hidden class="sum_remain" name="'.$nameRemain.
'" value="'.$remaintopay.
'">';
348 print
'<input type="text" class="width75" name="'.$namef.
'" id="'.$namef.
'" value="'.
GETPOST($namef).
'">';
356 $total_ttc += $objp->total_ttc;
357 $totalrecu += $sumpaid;
362 print
'<tr class="oddeven">';
363 print
'<td colspan="2" class="left">'.$langs->trans(
"Total").
':</td>';
364 print
'<td class="right"><b>'.price($total_ttc).
'</b></td>';
365 print
'<td class="right"><b>'.price($totalrecu).
'</b></td>';
366 print
'<td class="right"><b>'.price($total_ttc - $totalrecu).
'</b></td>';
367 print
'<td class="center"> </td>';
373 print $form->buttonsSaveCancel();
$id
Support class for third parties, contacts, members, users or resources.
if(! $sortfield) if(! $sortorder) $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...
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.
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='', $morecssonpicto='widthpictotitle')
Load a title with picto.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
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.