32require
'../main.inc.php';
44require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formexpensereport.class.php';
45require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
46require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmail.class.php';
47require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formprojet.class.php';
48require_once DOL_DOCUMENT_ROOT.
'/core/class/CMailFile.class.php';
49require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
50require_once DOL_DOCUMENT_ROOT.
'/ecm/class/ecmfiles.class.php';
51require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
52require_once DOL_DOCUMENT_ROOT.
'/core/lib/expensereport.lib.php';
53require_once DOL_DOCUMENT_ROOT.
'/core/lib/price.lib.php';
54require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
55require_once DOL_DOCUMENT_ROOT.
'/core/lib/images.lib.php';
56require_once DOL_DOCUMENT_ROOT.
'/core/modules/expensereport/modules_expensereport.php';
57require_once DOL_DOCUMENT_ROOT.
'/expensereport/class/expensereport.class.php';
58require_once DOL_DOCUMENT_ROOT.
'/expensereport/class/paymentexpensereport.class.php';
59require_once DOL_DOCUMENT_ROOT.
'/core/class/doleditor.class.php';
61 require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingjournal.class.php';
65$langs->loadLangs(array(
"trips",
"bills",
"mails"));
67$action =
GETPOST(
'action',
'aZ09');
68$cancel =
GETPOST(
'cancel',
'alpha');
69$confirm =
GETPOST(
'confirm',
'alpha');
70$backtopage =
GETPOST(
'backtopage',
'alpha');
77$vatrate =
GETPOST(
'vatrate',
'alpha');
79$comments =
GETPOST(
'comments',
'restricthtml');
84$childids = $user->getAllChildIds(1);
91 if (empty($date_end)) {
98$rootfordata = DOL_DATA_ROOT;
99$rootforuser = DOL_DATA_ROOT;
102 $rootfordata .=
'/'.$conf->entity;
104$conf->expensereport->dir_output = $rootfordata.
'/expensereport';
108$urlwithroot = $urlwithouturlroot.DOL_URL_ROOT;
120$extrafields->fetch_name_optionals_label(
$object->table_element);
123include DOL_DOCUMENT_ROOT.
'/core/actions_fetchobject.inc.php';
126$hookmanager->initHooks(array(
'expensereportcard',
'globalcard'));
130$caneditreport = (empty(
$object->id) || in_array(
$object->fk_user_author, $childids) || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'expensereport',
'writeall_advance')));
132$permissionnote = $user->hasRight(
'expensereport',
'creer') && $caneditreport;
133$permissiondellink = $user->hasRight(
'expensereport',
'creer') && $caneditreport;
134$permissiontoadd = $user->hasRight(
'expensereport',
'creer') && $caneditreport;
135$permissiontoeditextra = $permissiontoadd;
136if (
GETPOST(
'attribute',
'aZ09') && isset($extrafields->attributes[
$object->table_element][
'perms'][
GETPOST(
'attribute',
'aZ09')])) {
138 $permissiontoeditextra =
dol_eval((
string) $extrafields->attributes[
$object->table_element][
'perms'][
GETPOST(
'attribute',
'aZ09')]);
149 if ($user->hasRight(
'expensereport',
'readall')) {
152 if (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'expensereport',
'writeall_advance')) {
155 if ($user->hasRight(
'expensereport',
'lire') && in_array(
$object->fk_user_author, $childids)) {
158 if ($user->hasRight(
'expensereport',
'approve') &&
$object->fk_user_validator == $user->id) {
167if ($user->hasRight(
'expensereport',
'supprimer')) {
176 $socid = $user->socid;
180$permissiontoadd = $user->hasRight(
'expensereport',
'creer') && $caneditreport;
193$parameters = array(
'socid' => $socid);
194$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
199if (empty($reshook)) {
200 $backurlforlist = DOL_URL_ROOT.
'/expensereport/list.php';
202 if (empty($backtopage) || ($cancel && empty($id))) {
203 if (empty($backtopage) || ($cancel && strpos($backtopage,
'__ID__'))) {
204 if (empty($id) && (($action !=
'add' && $action !=
'create') || $cancel)) {
205 $backtopage = $backurlforlist;
207 $backtopage = DOL_URL_ROOT.
'/expensereport/card.php?id='.((!empty($id) &&
$id > 0) ? $id :
'__ID__');
213 if (!empty($backtopageforcancel)) {
214 header(
"Location: ".$backtopageforcancel);
216 } elseif (!empty($backtopage)) {
217 header(
"Location: ".$backtopage);
231 $fk_c_type_fees = -1;
235 $allowedstatusforaction = array(
243 if ($user->hasRight(
'expensereport',
'approve') || $user->hasRight(
'expensereport',
'to_paid')) {
246 if ($user->hasRight(
'expensereport',
'to_paid')) {
249 if (array_key_exists($action, $allowedstatusforaction) &&
$object->id > 0 && !in_array(
$object->status, $allowedstatusforaction[$action])) {
250 $labelsofallowedstatus = array();
251 foreach ($allowedstatusforaction[$action] as $allowedstatus) {
252 $labelsofallowedstatus[] =
$object->LibStatut($allowedstatus, 0);
254 setEventMessages($langs->trans(
"StatusOfRefMustBe",
$object->ref, implode(
' / ', $labelsofallowedstatus)),
null,
'errors');
258 include DOL_DOCUMENT_ROOT.
'/core/actions_linkedfiles.inc.php';
260 if (!empty(
GETPOST(
'sendit',
'alpha'))) {
261 if ($action ==
'updateline') {
262 $action =
'editline';
268 include DOL_DOCUMENT_ROOT.
'/core/actions_setnotes.inc.php';
270 include DOL_DOCUMENT_ROOT.
'/core/actions_dellink.inc.php';
272 include DOL_DOCUMENT_ROOT.
'/core/actions_lineupdown.inc.php';
275 if ($action ==
'confirm_clone' && $confirm ==
'yes' && $permissiontoadd) {
280 $fk_user_author_clone = (
GETPOSTINT(
'fk_user_author') > 0 ?
GETPOSTINT(
'fk_user_author') : $user->id);
281 if ((!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') || !$user->hasRight(
'expensereport',
'writeall_advance')) && !in_array($fk_user_author_clone, $childids)) {
290 header(
"Location: ".$_SERVER[
'PHP_SELF'].
'?id='.$result);
301 if ($action ==
'confirm_delete' &&
GETPOST(
"confirm",
'alpha') ==
"yes" && $id > 0 && $candelete) {
304 $result =
$object->delete($user);
306 header(
"Location: index.php");
313 if ($action ==
'add' && $permissiontoadd) {
320 if (!(
$object->fk_user_author > 0)) {
321 $object->fk_user_author = $user->id;
325 if ((!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && !$user->hasRight(
'expensereport',
'creer'))
326 || (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && !$user->hasRight(
'expensereport',
'creer') && !$user->hasRight(
'expensereport',
'writeall_advance'))) {
331 if (!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') || !$user->hasRight(
'expensereport',
'writeall_advance')) {
332 if (!in_array(
$object->fk_user_author, $childids)) {
340 $fuser->fetch(
$object->fk_user_author);
349 $ret = $extrafields->setOptionalsFromPost(
null, $object);
358 if ($overlappingExpenseReportID > 0) {
360 setEventMessages($langs->trans(
"ErrorDoubleDeclaration").
' <a href="'.$_SERVER[
'PHP_SELF'].
'?id='.$overlappingExpenseReportID.
'">'. $langs->trans(
'ShowTrip').
'</a>',
null,
'errors');
375 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".$id);
385 if (($action ==
'update' || $action ==
'updateFromRefuse') && $permissiontoadd) {
399 $object->fk_user_modif = $user->id;
401 $result =
$object->update($user);
403 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".
GETPOSTINT(
'id'));
410 if ($action ==
'update_extras' && $permissiontoeditextra) {
413 $attribute_name =
GETPOST(
'attribute',
'aZ09');
416 $ret = $extrafields->setOptionalsFromPost(
null, $object, $attribute_name);
422 $result =
$object->updateExtraField($attribute_name,
'EXPENSEREPORT_MODIFY');
430 $action =
'edit_extras';
434 if ($action ==
"confirm_validate" &&
GETPOST(
"confirm",
'alpha') ==
"yes" && $id > 0 && $permissiontoadd) {
440 $result =
$object->setValidate($user);
445 $outputlangs = $langs;
448 $newlang =
GETPOST(
'lang_id',
'aZ09');
452 $tmpuser->fetch(
$object->fk_user_author);
453 $newlang = $tmpuser->lang;
455 if (!empty($newlang)) {
457 $outputlangs->setDefaultLang($newlang);
462 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
469 if (!$error && $result > 0 &&
$object->fk_user_validator > 0) {
470 $langs->load(
"mails");
474 $destinataire->fetch(
$object->fk_user_validator);
475 $emailTo = $destinataire->email;
479 $expediteur->fetch(
$object->fk_user_author);
482 if ($emailTo && $emailFrom) {
493 $subject = $societeName.
" - ".$langs->transnoentities(
"ExpenseReportWaitingForApproval");
496 $link = $urlwithroot.
'/expensereport/card.php?id='.
$object->id;
497 $link =
'<a href="'.$link.
'">'.$link.
'</a>';
498 $message = $langs->transnoentities(
"ExpenseReportWaitingForApprovalMessage", $expediteur->getFullName($langs),
get_date_range(
$object->date_debut,
$object->date_fin,
'', $langs), $link);
513 $mailfile =
new CMailFile($subject, $emailTo, $emailFrom, $message, $filedir, $mimetype, $filename,
'',
'', 0, -1);
515 if (empty($mailfile->error)) {
517 $result = $mailfile->sendfile();
519 $mesg = $langs->trans(
'MailSuccessfulySent', $mailfile->getValidAddress($emailFrom, 2), $mailfile->getValidAddress($emailTo, 2));
522 $langs->load(
"other");
523 if (!empty($mailfile->error) || !empty($mailfile->errors)) {
526 if (!empty($mailfile->error)) {
527 $mesg .=
'<br>' . $mailfile->error;
529 if (!empty($mailfile->errors) && is_array($mailfile->errors)) {
530 $mesg .=
'<br>' . implode(
'<br>', $mailfile->errors);
534 setEventMessages(
'No mail sent. Feature is disabled by option MAIN_DISABLE_ALL_MAILS',
null,
'warnings');
542 setEventMessages($langs->trans(
"NoEmailSentBadSenderOrRecipientEmail"),
null,
'warnings');
549 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".$id);
556 if ($action ==
"confirm_save_from_refuse" &&
GETPOST(
"confirm",
'alpha') ==
"yes" && $id > 0 && $permissiontoadd) {
559 $result =
$object->set_save_from_refuse($user);
564 $outputlangs = $langs;
567 $newlang =
GETPOST(
'lang_id',
'aZ09');
571 $tmpuser->fetch(
$object->fk_user_author);
572 $newlang = $tmpuser->lang;
574 if (!empty($newlang)) {
576 $outputlangs->setDefaultLang($newlang);
581 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
590 $destinataire->fetch(
$object->fk_user_validator);
591 $emailTo = $destinataire->email;
595 $expediteur->fetch(
$object->fk_user_author);
598 if ($emailFrom && $emailTo) {
609 $subject = $societeName.
" - ".$langs->transnoentities(
"ExpenseReportWaitingForReApproval");
612 $link = $urlwithroot.
'/expensereport/card.php?id='.
$object->id;
613 $link =
'<a href="'.$link.
'">'.$link.
'</a>';
615 $message .=
'<br>'.$langs->transnoentities(
"ExpenseReportWaitingForReApprovalMessage2", $link);
634 $mailfile =
new CMailFile($subject, $emailTo, $emailFrom, $message, $filedir, $mimetype, $filename,
'',
'', 0, -1);
636 if (empty($mailfile->error)) {
638 $result = $mailfile->sendfile();
640 $mesg = $langs->trans(
'MailSuccessfulySent', $mailfile->getValidAddress($emailFrom, 2), $mailfile->getValidAddress($emailTo, 2));
642 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".$id);
645 $langs->load(
"other");
646 if ($mailfile->error) {
648 $mesg .= $langs->trans(
'ErrorFailedToSendMail', $emailFrom, $emailTo);
649 $mesg .=
'<br>'.$mailfile->error;
652 setEventMessages(
'No mail sent. Feature is disabled by option MAIN_DISABLE_ALL_MAILS',
null,
'warnings');
660 setEventMessages($langs->trans(
"NoEmailSentBadSenderOrRecipientEmail"),
null,
'warnings');
669 if ($action ==
"confirm_approve" &&
GETPOST(
"confirm",
'alpha') ==
"yes" && $id > 0 && $user->hasRight(
'expensereport',
'approve')) {
673 $result =
$object->setApproved($user);
678 $outputlangs = $langs;
681 $newlang =
GETPOST(
'lang_id',
'aZ09');
685 $tmpuser->fetch(
$object->fk_user_author);
686 $newlang = $tmpuser->lang;
688 if (!empty($newlang)) {
690 $outputlangs->setDefaultLang($newlang);
695 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
704 $destinataire->fetch(
$object->fk_user_author);
705 $emailTo = $destinataire->email;
709 if (empty($emailTo)) {
715 $expediteur->fetch(
$object->fk_user_approve > 0 ?
$object->fk_user_approve :
$object->fk_user_validator);
718 if ($emailFrom && $emailTo) {
729 $subject = $societeName.
" - ".$langs->transnoentities(
"ExpenseReportApproved");
732 $link = $urlwithroot.
'/expensereport/card.php?id='.
$object->id;
733 $link =
'<a href="'.$link.
'">'.$link.
'</a>';
734 $message = $langs->transnoentities(
"ExpenseReportApprovedMessage",
$object->ref, $destinataire->getFullName($langs), $expediteur->getFullName($langs), $link);
751 $mailfile =
new CMailFile($subject, $emailTo, $emailFrom, $message, $filedir, $mimetype, $filename, $emailCC,
'', 0, -1);
753 if (empty($mailfile->error)) {
755 $result = $mailfile->sendfile();
757 $mesg = $langs->trans(
'MailSuccessfulySent', $mailfile->getValidAddress($emailFrom, 2), $mailfile->getValidAddress($emailTo, 2));
759 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".$id);
762 $langs->load(
"other");
763 if ($mailfile->error) {
765 $mesg .= $langs->trans(
'ErrorFailedToSendMail', $emailFrom, $emailTo);
766 $mesg .=
'<br>'.$mailfile->error;
769 setEventMessages(
'No mail sent. Feature is disabled by option MAIN_DISABLE_ALL_MAILS',
null,
'warnings');
777 setEventMessages($langs->trans(
"NoEmailSentBadSenderOrRecipientEmail"),
null,
'warnings');
786 if ($action ==
"confirm_refuse" &&
GETPOST(
'confirm',
'alpha') ==
"yes" && $id > 0 && $user->hasRight(
'expensereport',
'approve')) {
790 $detailRefuse =
GETPOST(
'detail_refuse',
'alpha');
791 $result =
$object->setDeny($user, $detailRefuse);
796 $outputlangs = $langs;
799 $newlang =
GETPOST(
'lang_id',
'aZ09');
803 $tmpuser->fetch(
$object->fk_user_author);
804 $newlang = $tmpuser->lang;
806 if (!empty($newlang)) {
808 $outputlangs->setDefaultLang($newlang);
813 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
822 $destinataire->fetch(
$object->fk_user_author);
823 $emailTo = $destinataire->email;
827 $expediteur->fetch(
$object->fk_user_refuse);
830 if ($emailFrom && $emailTo) {
841 $subject = $societeName.
" - ".$langs->transnoentities(
"ExpenseReportRefused");
844 $link = $urlwithroot.
'/expensereport/card.php?id='.
$object->id;
845 $link =
'<a href="'.$link.
'">'.$link.
'</a>';
846 $message = $langs->transnoentities(
"ExpenseReportRefusedMessage",
$object->ref, $destinataire->getFullName($langs), $expediteur->getFullName($langs), $detailRefuse, $link);
864 $mailfile =
new CMailFile($subject, $emailTo, $emailFrom, $message, $filedir, $mimetype, $filename,
'',
'', 0, -1);
866 if (empty($mailfile->error)) {
868 $result = $mailfile->sendfile();
870 $mesg = $langs->trans(
'MailSuccessfulySent', $mailfile->getValidAddress($emailFrom, 2), $mailfile->getValidAddress($emailTo, 2));
872 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".$id);
875 $langs->load(
"other");
876 if ($mailfile->error) {
878 $mesg .= $langs->trans(
'ErrorFailedToSendMail', $emailFrom, $emailTo);
879 $mesg .=
'<br>'.$mailfile->error;
882 setEventMessages(
'No mail sent. Feature is disabled by option MAIN_DISABLE_ALL_MAILS',
null,
'warnings');
890 setEventMessages($langs->trans(
"NoEmailSentBadSenderOrRecipientEmail"),
null,
'warnings');
900 if ($action ==
"confirm_cancel" &&
GETPOST(
'confirm',
'alpha') ==
"yes" && $id > 0 && $user->hasRight(
'expensereport',
'creer')) {
901 if (!
GETPOST(
'detail_cancel',
'alpha')) {
902 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Comment")),
null,
'errors');
907 if ($user->id ==
$object->fk_user_valid || $user->id ==
$object->fk_user_author) {
908 $detailCancel =
GETPOST(
'detail_cancel',
'alpha');
909 $result =
$object->set_cancel($user, $detailCancel);
914 $outputlangs = $langs;
917 $newlang =
GETPOST(
'lang_id',
'aZ09');
921 $tmpuser->fetch(
$object->fk_user_author);
922 $newlang = $tmpuser->lang;
924 if (!empty($newlang)) {
926 $outputlangs->setDefaultLang($newlang);
931 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
940 $destinataire->fetch(
$object->fk_user_author);
941 $emailTo = $destinataire->email;
945 $expediteur->fetch(
$object->fk_user_cancel);
948 if ($emailFrom && $emailTo) {
959 $subject = $societeName.
" - ".$langs->transnoentities(
"ExpenseReportCanceled");
962 $link = $urlwithroot.
'/expensereport/card.php?id='.
$object->id;
963 $link =
'<a href="'.$link.
'">'.$link.
'</a>';
964 $message = $langs->transnoentities(
"ExpenseReportCanceledMessage",
$object->ref, $destinataire->getFullName($langs), $expediteur->getFullName($langs), $detailCancel, $link);
982 $mailfile =
new CMailFile($subject, $emailTo, $emailFrom, $message, $filedir, $mimetype, $filename,
'',
'', 0, -1);
984 if (empty($mailfile->error)) {
986 $result = $mailfile->sendfile();
988 $mesg = $langs->trans(
'MailSuccessfulySent', $mailfile->getValidAddress($emailFrom, 2), $mailfile->getValidAddress($emailTo, 2));
990 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".$id);
993 $langs->load(
"other");
994 if ($mailfile->error) {
996 $mesg .= $langs->trans(
'ErrorFailedToSendMail', $emailFrom, $emailTo);
997 $mesg .=
'<br>'.$mailfile->error;
1000 setEventMessages(
'No mail sent. Feature is disabled by option MAIN_DISABLE_ALL_MAILS',
null,
'warnings');
1008 setEventMessages($langs->trans(
"NoEmailSentBadSenderOrRecipientEmail"),
null,
'warnings');
1021 if ($action ==
"confirm_setdraft" &&
GETPOST(
'confirm',
'alpha') ==
"yes" && $id > 0 && $user->hasRight(
'expensereport',
'creer')) {
1024 if ($user->id ==
$object->fk_user_author || $user->id ==
$object->fk_user_valid || in_array(
$object->fk_user_author, $childids)) {
1030 $outputlangs = $langs;
1033 $newlang =
GETPOST(
'lang_id',
'aZ09');
1037 $tmpuser->fetch(
$object->fk_user_author);
1038 $newlang = $tmpuser->lang;
1040 if (!empty($newlang)) {
1042 $outputlangs->setDefaultLang($newlang);
1047 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
1052 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".$id);
1062 if ($action ==
'set_unpaid' && $id > 0 && $user->hasRight(
'expensereport',
'to_paid')) {
1066 $result =
$object->setUnpaid($user);
1071 $outputlangs = $langs;
1074 $newlang =
GETPOST(
'lang_id',
'aZ09');
1078 $tmpuser->fetch(
$object->fk_user_author);
1079 $newlang = $tmpuser->lang;
1081 if (!empty($newlang)) {
1083 $outputlangs->setDefaultLang($newlang);
1088 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
1091 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".$id);
1097 if ($action ==
'set_paid' && $id > 0 && $user->hasRight(
'expensereport',
'to_paid')) {
1101 $result =
$object->setPaid($id, $user);
1106 $outputlangs = $langs;
1109 $newlang =
GETPOST(
'lang_id',
'aZ09');
1113 $tmpuser->fetch(
$object->fk_user_author);
1114 $newlang = $tmpuser->lang;
1116 if (!empty($newlang)) {
1118 $outputlangs->setDefaultLang($newlang);
1123 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
1134 $destinataire =
new User(
$db);
1135 $destinataire->fetch(
$object->fk_user_author);
1136 $emailTo = $destinataire->email;
1140 $expediteur->fetch($user->id);
1143 if ($emailFrom && $emailTo) {
1144 $filename = array();
1146 $mimetype = array();
1154 $subject = $societeName.
" - ".$langs->transnoentities(
"ExpenseReportPaid");
1157 $link = $urlwithroot.
'/expensereport/card.php?id='.
$object->id;
1158 $link =
'<a href="'.$link.
'">'.$link.
'</a>';
1159 $message = $langs->transnoentities(
"ExpenseReportPaidMessage",
$object->ref, $destinataire->getFullName($langs), $expediteur->getFullName($langs), $link);
1162 $object->setDocModel($user,
"");
1163 $resultPDF = expensereport_pdf_create(
$db, $object,
'',
"", $langs);
1166 $mailfile =
new CMailFile($subject, $emailTo, $emailFrom, $message, $filedir, $mimetype, $filename,
'',
'', 0, -1);
1168 if (empty($mailfile->error)) {
1170 $result = $mailfile->sendfile();
1172 $mesg = $langs->trans(
'MailSuccessfulySent', $mailfile->getValidAddress($emailFrom, 2), $mailfile->getValidAddress($emailTo, 2));
1175 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".$id);
1178 $langs->load(
"other");
1179 if ($mailfile->error) {
1181 $mesg .= $langs->trans(
'ErrorFailedToSendMail', $emailFrom, $emailTo);
1182 $mesg .=
'<br>'.$mailfile->error;
1185 setEventMessages(
'No mail sent. Feature is disabled by option MAIN_DISABLE_ALL_MAILS',
null,
'warnings');
1192 setEventMessages($langs->trans(
"NoEmailSentBadSenderOrRecipientEmail"),
null,
'warnings');
1202 if ($action ==
"addline" && $permissiontoadd) {
1206 $arrayoffiles =
GETPOST(
'attachfile',
'array');
1207 if (is_array($arrayoffiles) && !empty($arrayoffiles[0])) {
1208 include_once DOL_DOCUMENT_ROOT.
'/ecm/class/ecmfiles.class.php';
1209 $entityprefix = (
$conf->entity !=
'1') ?
$conf->entity.
'/' :
'';
1210 $relativepath = $entityprefix.
'expensereport/'.
$object->ref.
'/'.$arrayoffiles[0];
1212 $ecmfiles->fetch(0,
'', $relativepath);
1213 $fk_ecm_files = $ecmfiles->id;
1218 if (empty($vatrate)) {
1221 $tmpvat =
price2num(preg_replace(
'/\s*\(.*\)/',
'', $vatrate));
1225 if (empty($value_unit)) {
1226 $value_unit =
price2num((
float) $value_unit_ht + ((
float) $value_unit_ht * (
float) $tmpvat / 100),
'MU');
1229 $fk_c_exp_tax_cat =
GETPOSTINT(
'fk_c_exp_tax_cat');
1236 if (!($fk_c_type_fees > 0)) {
1238 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Type")),
null,
'errors');
1242 if ((
float) $tmpvat < 0 || $tmpvat ===
'') {
1244 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"VAT")),
null,
'errors');
1249 if (empty($date) || $date ==
"--") {
1251 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Date")),
null,
'errors');
1252 } elseif ($date < $object->date_debut || $date > (
$object->date_fin + (24 * 3600 - 1))) {
1258 $langs->load(
"errors");
1259 $type = $error > 0 ?
'errors' :
'warnings';
1260 setEventMessages($langs->trans(
"WarningDateOfLineMustBeInExpenseReportRange"),
null, $type);
1264 if ($value_unit == 0) {
1266 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"PriceUTTC")),
null,
'errors');
1270 if ($projectRequired && $fk_project <= 0) {
1272 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Project")),
null,
'errors');
1276 if ($fileRequired && $fk_ecm_files == 0) {
1278 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"File")),
null,
'errors');
1285 $result =
$object->addline($qty, $value_unit, $fk_c_type_fees, $vatrate, $date, $comments, $fk_project, $fk_c_exp_tax_cat, $type, $fk_ecm_files);
1291 $outputlangs = $langs;
1292 $newlang =
GETPOST(
'lang_id',
'alpha');
1295 $tmpuser->fetch(
$object->fk_user_author);
1296 $newlang = $tmpuser->lang;
1298 if (!empty($newlang)) {
1300 $outputlangs->setDefaultLang($newlang);
1303 $object->generateDocument(
$object->model_pdf, $outputlangs, $hidedetails, $hidedesc, $hideref);
1307 unset($value_unit_ht);
1311 unset($fk_c_type_fees);
1322 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".
GETPOSTINT(
'id'));
1331 setEventMessages($langs->trans(
"ErrorDeleteLineNotAllowedByObjectStatus"),
null,
'errors');
1335 if ($action ==
'confirm_delete_line' &&
GETPOST(
"confirm",
'alpha') ==
"yes" && $permissiontoadd) {
1341 $total_ht = $object_ligne->total_ht;
1342 $total_tva = $object_ligne->total_tva;
1349 $outputlangs = $langs;
1352 $newlang =
GETPOST(
'lang_id',
'aZ09');
1356 $tmpuser->fetch(
$object->fk_user_author);
1357 $newlang = $tmpuser->lang;
1359 if (!empty($newlang)) {
1361 $outputlangs->setDefaultLang($newlang);
1366 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
1370 header(
"Location: ".$_SERVER[
"PHP_SELF"].
"?id=".
GETPOSTINT(
'id'));
1377 if ($action ==
"updateline" && $permissiontoadd) {
1384 $arrayoffiles =
GETPOST(
'attachfile',
'array');
1385 if (is_array($arrayoffiles) && !empty($arrayoffiles[0])) {
1386 include_once DOL_DOCUMENT_ROOT.
'/ecm/class/ecmfiles.class.php';
1387 $entityprefix = (
$conf->entity !=
'1') ?
$conf->entity.
'/' :
'';
1388 $relativepath = $entityprefix.
'expensereport/'.
$object->ref.
'/'.$arrayoffiles[0];
1390 $ecmfiles->fetch(0,
'', $relativepath);
1391 $fk_ecm_files = $ecmfiles->id;
1396 $type_fees_id =
GETPOSTINT(
'fk_c_type_fees');
1397 $fk_c_exp_tax_cat =
GETPOSTINT(
'fk_c_exp_tax_cat');
1398 $projet_id = $fk_project;
1399 $comments =
GETPOST(
'comments',
'restricthtml');
1401 $vatrate =
GETPOST(
'vatrate',
'alpha');
1404 if (empty($vatrate)) {
1407 $tmpvat =
price2num(preg_replace(
'/\s*\(.*\)/',
'', $vatrate));
1411 if (empty($value_unit)) {
1412 $value_unit =
price2num((
float) $value_unit_ht + ((
float) $value_unit_ht * (
float) $tmpvat / 100),
'MU');
1417 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Type")),
null,
'errors');
1420 if ((
float) $tmpvat < 0 || $tmpvat ==
'') {
1422 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Vat")),
null,
'errors');
1426 if ($date < $object->date_debut || $date > (
$object->date_fin + (24 * 3600 - 1))) {
1431 $langs->load(
"errors");
1432 $type = $error > 0 ?
'errors' :
'warnings';
1433 setEventMessages($langs->trans(
"WarningDateOfLineMustBeInExpenseReportRange"),
null, $type);
1437 if ($projectRequired && $projet_id <= 0) {
1439 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"Project")),
null,
'errors');
1444 $result =
$object->updateline($rowid, $type_fees_id, $projet_id, $vatrate, $comments, (
float) $qty, (
float) $value_unit, $date, $id, $fk_c_exp_tax_cat, $fk_ecm_files);
1449 $outputlangs = $langs;
1452 $newlang =
GETPOST(
'lang_id',
'aZ09');
1456 $tmpuser->fetch(
$object->fk_user_author);
1457 $newlang = $tmpuser->lang;
1459 if (!empty($newlang)) {
1461 $outputlangs->setDefaultLang($newlang);
1466 $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref);
1470 unset($value_unit_ht);
1474 unset($fk_c_type_fees);
1487 include DOL_DOCUMENT_ROOT.
'/core/actions_printing.inc.php';
1490 $triggersendname =
'EXPENSEREPORT_SENTBYMAIL';
1491 $autocopy =
'MAIN_MAIL_AUTOCOPY_EXPENSEREPORT_TO';
1492 $trackid =
'exp'.$object->id;
1493 include DOL_DOCUMENT_ROOT.
'/core/actions_sendmails.inc.php';
1496 $upload_dir =
$conf->expensereport->dir_output;
1497 include DOL_DOCUMENT_ROOT.
'/core/actions_builddoc.inc.php';
1505$title = $langs->trans(
"ExpenseReport").
" - ".$langs->trans(
"Card");
1506$help_url =
"EN:Module_Expense_Reports|FR:Module_Notes_de_frais";
1521if ($action ==
'create') {
1524 print
'<form action="'.$_SERVER[
'PHP_SELF'].
'" method="post" name="create">';
1525 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1526 print
'<input type="hidden" name="action" value="add">';
1527 print
'<input type="hidden" name="backtopage" value="'.$backtopage.
'">';
1531 print
'<table class="border centpercent">';
1536 print
'<td class="fieldrequired">'.$langs->trans(
"User").
'</td>';
1538 $defaultselectuser = $user->id;
1540 $defaultselectuser =
GETPOSTINT(
'fk_user_author');
1542 $include_users =
'hierarchyme';
1543 if (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'expensereport',
'writeall_advance')) {
1544 $include_users = array();
1546 print
img_picto(
'',
'user',
'class="pictofixedwidth"').$form->select_dolusers($defaultselectuser,
'fk_user_author', 0,
null, 0, $include_users,
'',
'0,'.
$conf->entity, 0, 0,
'', 0,
'',
'minwidth200 maxwidth500 inline-block');
1552 print
'<td class="titlefieldcreate fieldrequired">'.$langs->trans(
"DateStart").
'</td>';
1553 print
'<td>'.img_picto(
'',
'action',
'class="pictofixedwidth"');
1560 print
'<td class="fieldrequired">'.$langs->trans(
"DateEnd").
'</td>';
1561 print
'<td>'.img_picto(
'',
'action',
'class="pictofixedwidth"');
1562 print $form->selectDate($date_end ? $date_end : -1,
'date_fin', 0, 0, 0,
'', 1, 1);
1569 print
'<td>'.$langs->trans(
"ReviewedByCP").
'</td>';
1572 $include_users =
$object->fetch_users_approver_expensereport();
1573 if (empty($include_users)) {
1574 print
img_warning().
' '.$langs->trans(
"NobodyHasPermissionToValidateExpenseReport");
1576 $defaultselectuser = (empty($user->fk_user_expense_validator) ? $user->fk_user : $user->fk_user_expense_validator);
1581 $defaultselectuser =
GETPOSTINT(
'fk_user_validator');
1583 $s = $form->select_dolusers($defaultselectuser,
"fk_user_validator", 1,
null, ((empty($defaultselectuser) || !
getDolGlobalString(
'EXPENSEREPORT_DEFAULT_VALIDATOR_UNCHANGEABLE')) ? 0 : 1), $include_users);
1584 print
img_picto(
'',
'user',
'class="pictofixedwidth"').$form->textwithpicto($s, $langs->trans(
"AnyOtherInThisListCanValidate"));
1592 print
'<td>'.$langs->trans(
"ModePaiement").
'</td>';
1594 $form->select_types_paiements(
'',
'fk_c_paiement');
1603 print
'<td class="tdtop">'.$langs->trans(
'NotePublic').
'</td>';
1606 $doleditor =
new DolEditor(
'note_public', $note_public,
'', 80,
'dolibarr_notes',
'In',
false,
false, !
getDolGlobalString(
'FCKEDITOR_ENABLE_NOTE_PUBLIC') ? 0 : 1, ROWS_3,
'90%');
1607 print $doleditor->Create(1);
1611 $note_private =
GETPOSTISSET(
'note_private') ?
GETPOST(
'note_private',
'restricthtml') :
'';
1613 if (empty($user->socid)) {
1615 print
'<td class="tdtop">'.$langs->trans(
'NotePrivate').
'</td>';
1618 $doleditor =
new DolEditor(
'note_private', $note_private,
'', 80,
'dolibarr_notes',
'In',
false,
false, !
getDolGlobalString(
'FCKEDITOR_ENABLE_NOTE_PRIVATE') ? 0 : 1, ROWS_3,
'90%');
1619 print $doleditor->Create(1);
1624 $parameters = array(
'colspan' =>
' colspan="3"',
'cols' => 3);
1625 $reshook = $hookmanager->executeHooks(
'formObjectOptions', $parameters, $object, $action);
1626 print $hookmanager->resPrint;
1627 if (empty($reshook)) {
1628 print
$object->showOptionals($extrafields,
'create', $parameters);
1636 print $form->buttonsSaveCancel(
"AddTrip");
1641 $result =
$object->fetch($id, $ref);
1644 if (!in_array(
$object->fk_user_author, $childids)) {
1645 if (!$user->hasRight(
'expensereport',
'readall') && !$user->hasRight(
'expensereport',
'lire_tous')
1646 && (!
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') || !$user->hasRight(
'expensereport',
'writeall_advance'))) {
1649 print
'<div class="tabBar">';
1650 print $langs->trans(
'NotUserRightToView');
1665 print
"<form name='update' action=\"".$_SERVER[
'PHP_SELF'].
"\" method=\"post\">\n";
1666 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1667 print
'<input type="hidden" name="id" value="'.$id.
'">';
1668 print
'<input type="hidden" name="backtopage" value="'.$backtopage.
'">';
1670 print
dol_get_fiche_head($head,
'card', $langs->trans(
"ExpenseReport"), 0,
'trip', 0,
'',
'', 0,
'', 1);
1673 print
'<input type="hidden" name="action" value="updateFromRefuse">';
1675 print
'<input type="hidden" name="action" value="update">';
1678 $linkback =
'<a href="'.DOL_URL_ROOT.
'/expensereport/list.php?restore_lastsearch_values=1'.(!empty($socid) ?
'&socid='.$socid :
'').
'">'.$langs->trans(
"BackToList").
'</a>';
1680 print
'<table class="border centpercent">';
1683 print
'<td>'.$langs->trans(
"User").
'</td>';
1686 if (
$object->fk_user_author > 0) {
1687 $userfee->fetch(
$object->fk_user_author);
1688 print $userfee->getNomUrl(-1);
1693 print
'<tr><td class="titlefieldcreate">'.$langs->trans(
"Ref").
'</td><td>';
1694 print $form->showrefnav($object,
'ref', $linkback, 1,
'ref',
'ref',
'');
1698 print
'<td>'.$langs->trans(
"DateStart").
'</td>';
1700 print $form->selectDate(
$object->date_debut,
'date_debut');
1704 print
'<td>'.$langs->trans(
"DateEnd").
'</td>';
1706 print $form->selectDate(
$object->date_fin,
'date_fin');
1712 print
'<td>'.$langs->trans(
"ModePaiement").
'</td>';
1714 $form->select_types_paiements((
string)
$object->fk_c_paiement,
'fk_c_paiement');
1721 print
'<td>'.$langs->trans(
"VALIDATOR").
'</td>';
1723 $include_users =
$object->fetch_users_approver_expensereport();
1724 $s = $form->select_dolusers(
$object->fk_user_validator,
"fk_user_validator", 1,
null, 0, $include_users);
1725 print $form->textwithpicto($s, $langs->trans(
"AnyOtherInThisListCanValidate"));
1730 print
'<td>'.$langs->trans(
"VALIDOR").
'</td>';
1733 $userfee->fetch(
$object->fk_user_valid);
1734 print $userfee->getNomUrl(-1);
1740 print
'<td>'.$langs->trans(
"AUTHORPAIEMENT").
'</td>';
1743 $userfee->fetch($user->id);
1744 print $userfee->getNomUrl(-1);
1756 print $form->buttonsSaveCancel(
"Modify");
1760 $taxlessUnitPriceDisabled =
getDolGlobalString(
'EXPENSEREPORT_FORCE_LINE_AMOUNTS_INCLUDING_TAXES_ONLY') ?
' disabled' :
'';
1762 print
dol_get_fiche_head($head,
'card', $langs->trans(
"ExpenseReport"), -1,
'trip', 0,
'',
'', 0,
'', 1);
1767 if ($action ==
'clone') {
1769 $criteriaforfilter =
'hierarchyme';
1770 if (
getDolGlobalString(
'MAIN_USE_ADVANCED_PERMS') && $user->hasRight(
'expensereport',
'writeall_advance')) {
1771 $criteriaforfilter =
'';
1773 $formquestion = array(
1775 0 => array(
'type' =>
'other',
'name' =>
'fk_user_author',
'label' => $langs->trans(
"SelectTargetUser"),
'value' => $form->select_dolusers((
GETPOSTINT(
'fk_user_author') > 0 ?
GETPOSTINT(
'fk_user_author') : $user->id),
'fk_user_author', 0, null, 0, $criteriaforfilter,
'',
'0', 0, 0,
'', 0,
'',
'maxwidth150'))
1778 $formconfirm = $form->formconfirm($_SERVER[
"PHP_SELF"].
'?id='.
$object->id, $langs->trans(
'ToClone'), $langs->trans(
'ConfirmCloneExpenseReport',
$object->ref),
'confirm_clone', $formquestion,
'yes', 1);
1781 if ($action ==
'save') {
1782 $formconfirm = $form->formconfirm($_SERVER[
"PHP_SELF"].
"?id=".$id, $langs->trans(
"SaveTrip"), $langs->trans(
"ConfirmSaveTrip"),
"confirm_validate",
"",
"", 1);
1785 if ($action ==
'save_from_refuse') {
1786 $formconfirm = $form->formconfirm($_SERVER[
"PHP_SELF"].
"?id=".$id, $langs->trans(
"SaveTrip"), $langs->trans(
"ConfirmSaveTrip"),
"confirm_save_from_refuse",
"",
"", 1);
1789 if ($action ==
'delete') {
1790 $formconfirm = $form->formconfirm($_SERVER[
"PHP_SELF"].
"?id=".$id, $langs->trans(
"DeleteTrip"), $langs->trans(
"ConfirmDeleteTrip"),
"confirm_delete",
"",
"", 1);
1793 if ($action ==
'validate') {
1794 $formconfirm = $form->formconfirm($_SERVER[
"PHP_SELF"].
"?id=".$id, $langs->trans(
"ValideTrip"), $langs->trans(
"ConfirmValideTrip"),
"confirm_approve",
"",
"", 1);
1797 if ($action ==
'paid') {
1798 $formconfirm = $form->formconfirm($_SERVER[
"PHP_SELF"].
"?id=".$id, $langs->trans(
"PaidTrip"), $langs->trans(
"ConfirmPaidTrip"),
"confirm_paid",
"",
"", 1);
1801 if ($action ==
'cancel') {
1802 $array_input = array(
'text' => $langs->trans(
"ConfirmCancelTrip"), 0 => array(
'type' =>
"text",
'label' =>
'<strong>'.$langs->trans(
"Comment").
'</strong>',
'name' =>
"detail_cancel",
'value' =>
""));
1803 $formconfirm = $form->formconfirm($_SERVER[
"PHP_SELF"].
"?id=".$id, $langs->trans(
"Cancel"),
"",
"confirm_cancel", $array_input,
"", 1);
1806 if ($action ==
'setdraft') {
1807 $formconfirm = $form->formconfirm($_SERVER[
"PHP_SELF"].
"?id=".$id, $langs->trans(
"BrouillonnerTrip"), $langs->trans(
"ConfirmBrouillonnerTrip"),
"confirm_setdraft",
"",
"", 1);
1810 if ($action ==
'refuse') {
1811 $array_input = array(
'text' => $langs->trans(
"ConfirmRefuseTrip"), 0 => array(
'type' =>
"text",
'label' => $langs->trans(
"Comment"),
'name' =>
"detail_refuse",
'value' =>
""));
1812 $formconfirm = $form->formconfirm($_SERVER[
"PHP_SELF"].
"?id=".$id, $langs->trans(
"Deny"),
'',
"confirm_refuse", $array_input,
"yes", 1);
1815 if ($action ==
'delete_line') {
1816 $formconfirm = $form->formconfirm($_SERVER[
"PHP_SELF"].
"?id=".
$id.
"&rowid=".
GETPOSTINT(
'rowid'), $langs->trans(
"DeleteLine"), $langs->trans(
"ConfirmDeleteLine"),
"confirm_delete_line",
'',
'yes', 1);
1820 $parameters = array(
'formConfirm' => $formconfirm);
1821 $reshook = $hookmanager->executeHooks(
'formConfirm', $parameters, $object, $action);
1822 if (empty($reshook)) {
1823 $formconfirm .= $hookmanager->resPrint;
1824 } elseif ($reshook > 0) {
1825 $formconfirm = $hookmanager->resPrint;
1832 $linkback =
'<a href="'.DOL_URL_ROOT.
'/expensereport/list.php?restore_lastsearch_values=1'.(!empty($socid) ?
'&socid='.$socid :
'').
'">'.$langs->trans(
"BackToList").
'</a>';
1834 $morehtmlref =
'<div class="refidno">';
1835 $morehtmlref .=
'</div>';
1837 dol_banner_tab($object,
'ref', $linkback, 1,
'ref',
'ref', $morehtmlref);
1839 print
'<div class="fichecenter">';
1840 print
'<div class="fichehalfleft">';
1841 print
'<div class="underbanner clearboth"></div>';
1843 print
'<table class="border tableforfield centpercent">';
1847 print
'<td class="titlefield">'.$langs->trans(
"User").
'</td>';
1849 if (
$object->fk_user_author > 0) {
1851 $result = $userauthor->fetch(
$object->fk_user_author);
1854 } elseif ($result > 0) {
1855 print $userauthor->getNomUrl(-1);
1862 print
'<td class="titlefield">'.$langs->trans(
"Period").
'</td>';
1869 print
'<td>'.$langs->trans(
"ModePaiement").
'</td>';
1870 print
'<td>'.$object->fk_c_paiement.
'</td>';
1876 print
'<td>'.$langs->trans(
"DATE_SAVE").
'</td>';
1877 print
'<td>'.dol_print_date(
$object->date_valid,
'dayhour',
'tzuser');
1879 print
' '.img_warning($langs->trans(
"Late").
' - '.$langs->trans(
"ToApprove"));
1882 print
' '.img_warning($langs->trans(
"Late").
' - '.$langs->trans(
"ToPay"));
1890 print
'<td>'.$langs->trans(
"VALIDATOR").
'</td>';
1892 if (
$object->fk_user_validator > 0) {
1894 $result = $userfee->fetch(
$object->fk_user_validator);
1896 print $userfee->getNomUrl(-1);
1898 if (empty($userfee->email) || !
isValidEmail($userfee->email)) {
1899 $langs->load(
"errors");
1900 print
img_warning($langs->trans(
"ErrorBadEMail", $userfee->email));
1906 print
'<td>'.$langs->trans(
"CANCEL_USER").
'</span></td>';
1908 if (
$object->fk_user_cancel > 0) {
1910 $result = $userfee->fetch(
$object->fk_user_cancel);
1912 print $userfee->getNomUrl(-1);
1918 print
'<td>'.$langs->trans(
"MOTIF_CANCEL").
'</td>';
1919 print
'<td>'.$object->detail_cancel.
'</td></tr>';
1922 print
'<td>'.$langs->trans(
"DATE_CANCEL").
'</td>';
1923 print
'<td>'.dol_print_date(
$object->date_cancel,
'dayhour',
'tzuser').
'</td></tr>';
1927 print
'<td>'.$langs->trans(
"ApprovedBy").
'</td>';
1929 if (
$object->fk_user_approve > 0) {
1931 $result = $userapp->fetch(
$object->fk_user_approve);
1933 print $userapp->getNomUrl(-1);
1939 print
'<td>'.$langs->trans(
"DateApprove").
'</td>';
1940 print
'<td>'.dol_print_date(
$object->date_approve,
'dayhour',
'tzuser').
'</td></tr>';
1946 print
'<td>'.$langs->trans(
"REFUSEUR").
'</td>';
1949 $result = $userfee->fetch(
$object->fk_user_refuse);
1951 print $userfee->getNomUrl(-1);
1956 print
'<td>'.$langs->trans(
"DATE_REFUS").
'</td>';
1957 print
'<td>'.dol_print_date(
$object->date_refuse,
'dayhour',
'tzuser');
1959 print
' - '.$object->detail_refuse;
1983 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_view.tpl.php';
1988 print
'<div class="fichehalfright">';
1989 print
'<div class="underbanner clearboth"></div>';
1991 print
'<table class="border tableforfield centpercent">';
1995 print
'<td class="titlefieldmiddle">'.$langs->trans(
"AmountHT").
'</td>';
1996 print
'<td class="nowrap amountcard">'.price(
$object->total_ht, 1,
'', 1, - 1, - 1,
$conf->currency).
'</td>';
2013 print
'<td>'.$langs->trans(
"AmountVAT").
'</td>';
2014 print
'<td class="nowrap amountcard">'.price(
$object->total_tva, 1,
'', 1, -1, -1,
$conf->currency).
'</td>';
2018 if (
$mysoc->localtax1_assuj ==
"1" ||
$object->total_localtax1 != 0) {
2019 print
'<tr><td>'.$langs->transcountry(
"AmountLT1",
$mysoc->country_code).
'</td>';
2020 print
'<td class="valuefield">'.price(
$object->total_localtax1, 1,
'', 1, -1, -1,
$conf->currency).
'</td></tr>';
2022 if (
$mysoc->localtax2_assuj ==
"1" ||
$object->total_localtax2 != 0) {
2023 print
'<tr><td>'.$langs->transcountry(
"AmountLT2",
$mysoc->country_code).
'</td>';
2024 print
'<td class="valuefield">'.price(
$object->total_localtax2, 1,
'', 1, -1, -1,
$conf->currency).
'</td></tr>';
2028 print
'<td>'.$langs->trans(
"AmountTTC").
'</td>';
2029 print
'<td class="nowrap amountcard">'.price(
$object->total_ttc, 1,
'', 1, -1, -1,
$conf->currency).
'</td>';
2033 $canSeeBankAccount =
isModEnabled(
'bank') && $user->hasRight(
'banque',
'lire');
2036 if ($canSeeBankAccount) {
2041 print
'<div class="div-table-responsive-no-min">';
2042 print
'<table class="noborder paymenttable centpercent">';
2044 print
'<tr class="liste_titre">';
2045 print
'<td class="liste_titre">'.$langs->trans(
'Payments').
'</td>';
2046 print
'<td class="liste_titre">'.$langs->trans(
'Date').
'</td>';
2047 print
'<td class="liste_titre">'.$langs->trans(
'Type').
'</td>';
2048 if ($canSeeBankAccount) {
2049 print
'<td class="liste_titre right">'.$langs->trans(
'BankAccount').
'</td>';
2051 print
'<td class="liste_titre" width="18"> </td>';
2052 print
'<td class="liste_titre right">'.$langs->trans(
'Amount').
'</td>';
2056 $sql =
"SELECT p.rowid, p.num_payment, p.datep as dp, p.amount, p.fk_bank,";
2057 $sql .=
"c.code as payment_code, c.libelle as payment_type,";
2058 $sql .=
"ba.rowid as baid, ba.ref as baref, ba.label, ba.number as banumber, ba.account_number, ba.fk_accountancy_journal";
2059 $sql .=
" FROM ".MAIN_DB_PREFIX.
"expensereport as e, ".MAIN_DB_PREFIX.
"payment_expensereport as p";
2060 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_paiement as c ON p.fk_typepayment = c.id";
2061 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'bank as b ON p.fk_bank = b.rowid';
2062 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'bank_account as ba ON b.fk_account = ba.rowid';
2063 $sql .=
" WHERE e.rowid = ".((int) $id);
2064 $sql .=
" AND p.fk_expensereport = e.rowid";
2065 $sql .=
' AND e.entity IN ('.getEntity(
'expensereport').
')';
2066 $sql .=
" ORDER BY dp";
2068 $resql =
$db->query($sql);
2070 $num =
$db->num_rows($resql);
2074 $objp =
$db->fetch_object($resql);
2076 $paymentexpensereportstatic->id = $objp->rowid;
2077 $paymentexpensereportstatic->datep =
$db->jdate($objp->dp);
2078 $paymentexpensereportstatic->ref = $objp->rowid;
2079 $paymentexpensereportstatic->num_payment = $objp->num_payment;
2080 $paymentexpensereportstatic->type_code = $objp->payment_code;
2081 $paymentexpensereportstatic->type_label = $objp->payment_type;
2083 print
'<tr class="oddeven">';
2085 print $paymentexpensereportstatic->getNomUrl(1);
2087 print
'<td>'.dol_print_date(
$db->jdate($objp->dp),
'day').
"</td>\n";
2088 $labeltype = $langs->trans(
"PaymentType".$objp->payment_code) !=
"PaymentType".$objp->payment_code ? $langs->trans(
"PaymentType".$objp->payment_code) : $objp->payment_type;
2089 print
"<td>".$labeltype.
' '.$objp->num_payment.
"</td>\n";
2091 if ($canSeeBankAccount) {
2092 $bankaccountstatic->id = $objp->baid;
2093 $bankaccountstatic->ref = $objp->baref;
2094 $bankaccountstatic->label = $objp->baref;
2095 $bankaccountstatic->number = $objp->banumber;
2098 $bankaccountstatic->account_number = $objp->account_number;
2101 $accountingjournal->fetch($objp->fk_accountancy_journal);
2102 $bankaccountstatic->accountancy_journal = $accountingjournal->getNomUrl(0, 1, 1,
'', 1);
2105 print
'<td class="right">';
2106 if ($bankaccountstatic->id) {
2107 print $bankaccountstatic->getNomUrl(1,
'transactions');
2112 print
'<td class="right">'.price($objp->amount).
"</td>";
2114 $totalpaid += $objp->amount;
2120 $resteapayeraffiche = $remaintopay;
2122 if ($remaintopay > 0) {
2123 $cssforamountpaymentcomplete =
'amountremaintopay';
2125 $cssforamountpaymentcomplete =
'amountpaymentcomplete';
2129 $cssforamountpaymentcomplete =
'amountpaymentneutral strikefordisabled';
2130 } elseif (
$object->paid == 1 && $remaintopay > 0) {
2131 $cssforamountpaymentcomplete =
'amountpaymentneutral strikefordisabled';
2133 print
'<tr><td colspan="'.$nbcols.
'" class="right">'.$langs->trans(
"AlreadyPaid").
':</td>';
2135 print
'<td class="right">'.price($totalpaid).
'</td></tr>';
2137 print
'<tr><td colspan="'.$nbcols.
'" class="right">'.$langs->trans(
"AmountExpected").
':</td>';
2139 print
'<td class="right">'.price(
$object->total_ttc).
'</td></tr>';
2141 print
'<tr><td colspan="'.$nbcols.
'" class="right">'.$langs->trans(
"RemainderToPay").
':</td>';
2143 print
'<td class="right'.($resteapayeraffiche ?
' amountremaintopay' : (
' '.$cssforamountpaymentcomplete)).
'">'.
price($resteapayeraffiche).
'</td></tr>';
2152 print
'<div class="clearboth"></div>';
2158 print
'<div style="clear: both;"></div>';
2160 $actiontouse =
'updateline';
2162 $actiontouse =
'addline';
2165 print
'<form name="expensereport" action="'.$_SERVER[
"PHP_SELF"].
'" enctype="multipart/form-data" method="post" >';
2166 print
'<input type="hidden" name="token" value="'.newToken().
'">';
2167 print
'<input type="hidden" name="action" value="'.$actiontouse.
'">';
2168 print
'<input type="hidden" name="id" value="'.$object->id.
'">';
2169 print
'<input type="hidden" name="fk_expensereport" value="'.$object->id.
'" />';
2170 print
'<input type="hidden" name="backtopage" value="'.$backtopage.
'">';
2171 print
'<input type="hidden" name="page_y" value="">';
2173 print
'<div class="div-table-responsive-no-min">';
2174 print
'<table id="tablelines" class="noborder centpercent">';
2180 print
'<tr class="liste_titre headerexpensereportdet">';
2181 print
'<td class="center linecollinenb">'.$langs->trans(
'LineNb').
'</td>';
2183 print
'<td class="center linecoldate">'.$langs->trans(
'Date').
'</td>';
2185 print
'<td class="minwidth100imp linecolproject">'.$langs->trans(
'Project').
'</td>';
2187 print
'<td class="center linecoltype">'.$langs->trans(
'Type').
'</td>';
2189 print
'<td class="center linecolcarcategory">'.$langs->trans(
'CarCategory').
'</td>';
2191 print
'<td class="linecoldescription">'.$langs->trans(
'Description').
'</td>';
2192 print
'<td class="right linecolvat">'.$langs->trans(
'VAT').
'</td>';
2193 print
'<td class="right linecolpriceuht">'.$langs->trans(
'PriceUHT').
'</td>';
2194 print
'<td class="right linecolpriceuttc">'.$langs->trans(
'PriceUTTC').
'</td>';
2195 print
'<td class="right linecolqty">'.$langs->trans(
'Qty').
'</td>';
2196 if ($action !=
'editline') {
2197 print
'<td class="right linecolamountht">'.$langs->trans(
'AmountHT').
'</td>';
2198 print
'<td class="right linecolamountttc">'.$langs->trans(
'AmountTTC').
'</td>';
2210 print
'<td class="right"></td>';
2214 foreach (
$object->lines as &$line) {
2217 if ($action !=
'editline' || $line->id !=
GETPOSTINT(
'rowid')) {
2218 print
'<tr class="oddeven linetr" data-id="'.$line->id.
'">';
2221 print
'<td class="center linecollinenb">';
2226 print
'<td class="center linecoldate">'.dol_print_date(
$db->jdate($line->date),
'day').
'</td>';
2230 print
'<td class="lineproject">';
2231 if ($line->fk_project > 0) {
2232 $projecttmp->id = $line->fk_project;
2233 $projecttmp->ref = $line->projet_ref;
2234 $projecttmp->title = $line->projet_title;
2235 print $projecttmp->getNomUrl(1);
2242 require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingaccount.class.php';
2244 $resaccountingaccount = $accountingaccount->fetch(0, $line->type_fees_accountancy_code, 1);
2246 $titlealt .= $langs->trans(
"AccountancyCode").
': ';
2247 if ($resaccountingaccount > 0) {
2248 $titlealt .= $accountingaccount->account_number;
2250 $titlealt .= $langs->trans(
"NotFound");
2256 print
'<td class="center linecoltype" title="'.dol_escape_htmltag($titlealt).
'">';
2257 $labeltype = ($langs->trans(($line->type_fees_code)) == $line->type_fees_code ? $line->type_fees_libelle : $langs->trans($line->type_fees_code));
2263 print
'<td class="fk_c_exp_tax_cat linecoltaxcat">';
2264 $exp_tax_cat_label =
dol_getIdFromCode(
$db, $line->fk_c_exp_tax_cat,
'c_exp_tax_cat',
'rowid',
'label');
2265 print $langs->trans($exp_tax_cat_label);
2270 print
'<td class="left linecolcomment minwidth100">'.dol_nl2br($line->comments).
'</td>';
2273 $senderissupplier = 0;
2274 $tooltiponprice =
'';
2275 $tooltiponpriceend =
'';
2277 $tooltiponprice = $langs->transcountry(
"TotalHT",
$mysoc->country_code).
'='.
price($line->total_ht);
2278 $tooltiponprice .=
'<br>'.$langs->transcountry(
"TotalVAT", ($senderissupplier ?
$object->thirdparty->country_code :
$mysoc->country_code)).
'='.
price($line->total_tva);
2279 if (is_object(
$object->thirdparty)) {
2280 if ($senderissupplier) {
2281 $seller =
$object->thirdparty;
2288 if (
$mysoc->useLocalTax(1)) {
2289 if (($seller->country_code == $buyer->country_code) || $line->total_localtax1 || $seller->useLocalTax(1)) {
2290 $tooltiponprice .=
'<br>'.$langs->transcountry(
"TotalLT1", $seller->country_code).
'='.
price($line->total_localtax1);
2292 $tooltiponprice .=
'<br>'.$langs->transcountry(
"TotalLT1", $seller->country_code).
'=<span class="opacitymedium">'.$langs->trans($senderissupplier ?
"NotUsedForThisVendor" :
"NotUsedForThisCustomer").
'</span>';
2295 if (
$mysoc->useLocalTax(2)) {
2296 if ((isset($seller->country_code) && isset($buyer->thirdparty->country_code) && $seller->country_code == $buyer->thirdparty->country_code) || $line->total_localtax2 || $seller->useLocalTax(2)) {
2297 $tooltiponprice .=
'<br>'.$langs->transcountry(
"TotalLT2", $seller->country_code).
'='.
price($line->total_localtax2);
2299 $tooltiponprice .=
'<br>'.$langs->transcountry(
"TotalLT2", $seller->country_code).
'=<span class="opacitymedium">'.$langs->trans($senderissupplier ?
"NotUsedForThisVendor" :
"NotUsedForThisCustomer").
'</span>';
2303 $tooltiponprice .=
'<br>'.$langs->transcountry(
"TotalTTC",
$mysoc->country_code).
'='.
price($line->total_ttc);
2305 $tooltiponprice =
'<span class="classfortooltip" title="'.dol_escape_htmltag($tooltiponprice).
'">';
2306 $tooltiponpriceend =
'</span>';
2309 print
'<td class="right linecolvatrate">';
2310 print $tooltiponprice;
2311 print
vatrate($line->vatrate.($line->vat_src_code ?
' ('.$line->vat_src_code.
')' :
''), true);
2312 print $tooltiponpriceend;
2316 print
'<td class="right linecolunitht">';
2317 if (!empty($line->value_unit_ht)) {
2318 print
price($line->value_unit_ht);
2320 $tmpvat =
price2num(preg_replace(
'/\s*\(.*\)/',
'', $line->vatrate));
2321 $pricenettoshow =
price2num((
float) $line->value_unit / (1 + (
float) $tmpvat / 100),
'MU');
2322 print
price($pricenettoshow);
2326 print
'<td class="right linecolunitttc">'.price($line->value_unit).
'</td>';
2328 print
'<td class="right linecolqty">'.dol_escape_htmltag((
string) $line->qty).
'</td>';
2330 if ($action !=
'editline') {
2331 print
'<td class="right linecoltotalht">'.price($line->total_ht).
'</td>';
2332 print
'<td class="right linecoltotalttc">'.price($line->total_ttc).
'</td>';
2336 print
'<td class="center linecolpreview">';
2337 if ($line->fk_ecm_files > 0) {
2338 $modulepart =
'expensereport';
2339 $maxheightmini = 32;
2341 $result = $ecmfilesstatic->fetch($line->fk_ecm_files);
2343 $relativepath = preg_replace(
'/^([0-9]+\/)?expensereport\//',
'', $ecmfilesstatic->filepath);
2344 $fileinfo = pathinfo($ecmfilesstatic->filepath.
'/'.$ecmfilesstatic->filename);
2347 if (!
dol_is_file(
$conf->expensereport->dir_output.
'/'.$relativepath.
'/'.$minifile)) {
2351 $urlforhref =
getAdvancedPreviewUrl($modulepart, $relativepath.
'/'.$fileinfo[
'filename'].
'.'.strtolower($fileinfo[
'extension']), 1,
'&entity='.(empty(
$object->entity) ?
$conf->entity :
$object->entity));
2352 if (empty($urlforhref)) {
2353 $urlforhref = DOL_URL_ROOT.
'/viewimage.php?modulepart='.$modulepart.
'&entity='.(empty(
$object->entity) ?
$conf->entity :
$object->entity).
'&file='.urlencode($relativepath.$fileinfo[
'filename'].
'.'.strtolower($fileinfo[
'extension']));
2354 print
'<a href="'.$urlforhref.
'" class="aphoto" target="_blank" rel="noopener noreferrer">';
2356 print
'<a href="'.$urlforhref[
'url'].
'" class="'.$urlforhref[
'css'].
'" target="'.$urlforhref[
'target'].
'" mime="'.$urlforhref[
'mime'].
'">';
2358 print
'<img class="photo" height="'.$maxheightmini.
'" src="'.DOL_URL_ROOT.
'/viewimage.php?modulepart='.$modulepart.
'&entity='.(empty(
$object->entity) ?
$conf->entity :
$object->entity).
'&file='.urlencode($relativepath.
'/'.$minifile).
'" title="">';
2361 if (preg_match(
'/\.pdf$/i', $ecmfilesstatic->filename)) {
2362 $filepdf =
$conf->expensereport->dir_output.
'/'.$relativepath.
'/'.$ecmfilesstatic->filename;
2363 $fileimage =
$conf->expensereport->dir_output.
'/'.$relativepath.
'/'.$ecmfilesstatic->filename.
'_preview.png';
2364 $relativepathimage = $relativepath.
'/'.$ecmfilesstatic->filename.
'_preview.png';
2366 $pdfexists = file_exists($filepdf);
2369 if (!file_exists($fileimage) || (filemtime($fileimage) < filemtime($filepdf))) {
2371 include_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
2380 if ($pdfexists && !$error) {
2381 $heightforphotref = 70;
2382 if (!empty(
$conf->dol_optimize_smallscreen)) {
2383 $heightforphotref = 60;
2385 $urlforhref =
getAdvancedPreviewUrl($modulepart, $relativepath.
'/'.$fileinfo[
'filename'].
'.'.strtolower($fileinfo[
'extension']), 1,
'&entity='.(empty(
$object->entity) ?
$conf->entity :
$object->entity));
2386 print
'<a href="'.$urlforhref[
'url'].
'" class="'.$urlforhref[
'css'].
'" target="'.$urlforhref[
'target'].
'" mime="'.$urlforhref[
'mime'].
'">';
2388 if (file_exists($fileimage)) {
2389 print
'<img height="'.$heightforphotref.
'" class="photo photowithmargin photowithborder" src="'.DOL_URL_ROOT.
'/viewimage.php?modulepart=apercu'.$modulepart.
'&file='.urlencode($relativepathimage).
'">';
2392 print
img_mime($ecmfilesstatic->filename);
2402 print
'<td class="nowrap right linecolwarning">';
2403 print !empty($line->rule_warning_message) ?
img_warning($line->rule_warning_message) :
' ';
2408 print
'<td class="nowrap right linecolaction">';
2410 print
'<a class="editfielda reposition paddingrightonly" href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&action=editline&token='.
newToken().
'&rowid='.$line->rowid.
'">';
2412 print
'</a> ';
2413 print
'<a class="paddingrightonly" href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&action=delete_line&token='.
newToken().
'&rowid='.$line->rowid.
'">';
2423 if ($action ==
'editline' && $line->id ==
GETPOSTINT(
'rowid')) {
2433 print
'<!-- line of expense report -->'.
"\n";
2434 print
'<tr class="tredited">';
2436 print
'<td class="center">';
2440 print
'<td colspan="'.($colspan - 1).
'" class="liste_titre"> ';
2441 print
'<a href="" class="commonlink auploadnewfilenow reposition">'.$langs->trans(
"UploadANewFileNow");
2442 print
img_picto($langs->trans(
"UploadANewFileNow"),
'chevron-down',
'', 0, 0, 0,
'',
'marginleftonly');
2445 print
' - <a href="" class="commonlink aattachtodoc reposition">'.$langs->trans(
"AttachTheNewLineToTheDocument");
2446 print
img_picto($langs->trans(
"AttachTheNewLineToTheDocument"),
'chevron-down',
'', 0, 0, 0,
'',
'marginleftonly');
2450 print
'<!-- Code to open/close section to submit or link files in edit mode -->'.
"\n";
2451 print
'<script type="text/javascript">'.
"\n";
2452 print
'$(document).ready(function() {
2453 $( ".auploadnewfilenow" ).click(function() {
2454 jQuery(".truploadnewfilenow").toggle();
2455 jQuery(".trattachnewfilenow").hide();
2458 $( ".aattachtodoc" ).click(function() {
2459 jQuery(".trattachnewfilenow").toggle();
2460 jQuery(".truploadnewfilenow").hide();
2463 if (is_array(
GETPOST(
'attachfile',
'array')) && count(
GETPOST(
'attachfile',
'array'))) {
2464 print
'jQuery(".trattachnewfilenow").toggle();'.
"\n";
2467 jQuery("form[name=\"expensereport\"]").submit(function() {
2468 if (jQuery(".truploadnewfilenow").is(":hidden")) {
2469 jQuery("input[name=\"sendit\"]").val("");
2476 print
'</script>'.
"\n";
2479 $filenamelinked =
'';
2480 if ($line->fk_ecm_files > 0) {
2481 $result = $ecmfilesstatic->fetch($line->fk_ecm_files);
2483 $filenamelinked = $ecmfilesstatic->filename;
2487 $tredited =
'tredited';
2488 include DOL_DOCUMENT_ROOT.
'/expensereport/tpl/expensereport_addfile.tpl.php';
2489 include DOL_DOCUMENT_ROOT.
'/expensereport/tpl/expensereport_linktofile.tpl.php';
2491 print
'<tr class="oddeven tredited">';
2496 print
'<td class="center">';
2497 print $form->selectDate($line->date,
'date');
2502 print
'<td class="nowraponall">';
2503 print $formproject->select_projects(-1, (
string) $line->fk_project,
'fk_project', 0, 0, $projectRequired ? 0 : 1, 1, 0, 0, 0,
'', 1, 0,
'maxwidth300');
2508 print
'<td class="center">';
2509 print $formexpensereport->selectTypeExpenseReport($line->fk_c_type_fees,
'fk_c_type_fees');
2513 print
'<td class="fk_c_exp_tax_cat">';
2514 $params = array(
'fk_expense' =>
$object->id,
'fk_expense_det' => $line->id,
'date' => $line->date);
2515 print $form->selectExpenseCategories((
string) $line->fk_c_exp_tax_cat,
'fk_c_exp_tax_cat', 1, array(),
'fk_c_type_fees', (
int) $userauthor->default_c_exp_tax_cat, $params);
2521 print
'<textarea name="comments" class="flat_ndf centpercent">'.dol_escape_htmltag($line->comments, 0, 1).
'</textarea>';
2525 $selectedvat =
price2num($line->vatrate).(!empty($line->vat_src_code) ?
' ('.$line->vat_src_code.
')' :
'');
2526 print
'<td class="right">';
2528 print $form->load_tva(
'vatrate', (
GETPOSTISSET(
"vatrate") ?
GETPOST(
"vatrate") : $selectedvat), null, null, 0, 0,
'', false, 1, 2);
2532 print
'<td class="right">';
2533 print
'<input type="text" min="0" class="right maxwidth50" id="value_unit_ht" name="value_unit_ht" value="'.dol_escape_htmltag(
price2num((!empty($line->value_unit_ht) ? $line->value_unit_ht :
""))).
'"'.$taxlessUnitPriceDisabled.
' />';
2537 print
'<td class="right">';
2538 print
'<input type="text" min="0" class="right maxwidth50" id="value_unit" name="value_unit" value="'.dol_escape_htmltag(
price2num($line->value_unit)).
'" />';
2542 print
'<td class="right">';
2543 print
'<input type="text" min="0" class="input_qty right maxwidth50" name="qty" value="'.dol_escape_htmltag((
string) $line->qty).
'" />';
2550 print
'<td class="center">';
2554 print
'<td class="center">';
2558 print
'<input type="hidden" name="rowid" value="'.$line->rowid.
'">';
2559 print $form->buttonsSaveCancel(
'Save',
'Cancel', array(),
false,
'small');
2578 if ($action !=
'editline') {
2582 $nbFiles = $nbLinks = 0;
2583 $arrayoffiles = array();
2585 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
2586 require_once DOL_DOCUMENT_ROOT.
'/core/lib/images.lib.php';
2587 require_once DOL_DOCUMENT_ROOT.
'/core/class/link.class.php';
2590 $nbFiles = count($arrayoffiles);
2595 print
'<tr class="liste_titre">';
2596 print
'<td colspan="'.$colspan.
'" class="liste_titre expensereportautoload">';
2597 print
'<a href="" class="commonlink auploadnewfilenow reposition">'.$langs->trans(
"UploadANewFileNow");
2598 print
img_picto($langs->trans(
"UploadANewFileNow"),
'chevron-down',
'', 0, 0, 0,
'',
'marginleftonly');
2601 print
' - <a href="" class="commonlink aattachtodoc reposition">'.$langs->trans(
"AttachTheNewLineToTheDocument");
2602 print
img_picto($langs->trans(
"AttachTheNewLineToTheDocument"),
'chevron-down',
'', 0, 0, 0,
'',
'marginleftonly');
2606 print
'<!-- Code to open/close section to submit or link files in the form to add new line -->'.
"\n";
2607 print
'<script type="text/javascript">'.
"\n";
2608 print
'$(document).ready(function() {
2609 $( ".auploadnewfilenow" ).click(function() {
2610 console.log("We click on toggle of auploadnewfilenow");
2611 jQuery(".truploadnewfilenow").toggle();
2612 jQuery(".trattachnewfilenow").hide();
2613 if (jQuery(".truploadnewfilenow").is(":hidden")) {
2614 jQuery("input[name=\"sendit\"]").prop("name", "senditdisabled");
2616 jQuery("input[name=\"senditdisabled\"]").prop("name", "sendit");
2618 // TODO Switch css fa-chevron-dow and add fa-chevron-up
2621 $( ".aattachtodoc" ).click(function() {
2622 console.log("We click on toggle of aattachtodoc");
2623 jQuery(".trattachnewfilenow").toggle();
2624 jQuery(".truploadnewfilenow").hide();
2625 // TODO Switch css fa-chevron-dow and add fa-chevron-up
2628 if (is_array(
GETPOST(
'attachfile',
'array')) && count(
GETPOST(
'attachfile',
'array')) && $action !=
'updateline') {
2629 print
'jQuery(".trattachnewfilenow").show();'.
"\n";
2632 jQuery("form[name=\"expensereport\"]").submit(function() {
2633 if (jQuery(".truploadnewfilenow").is(":hidden")) {
2634 /* When section to send file is not expanded, we disable the button sendit that submit form to add a new file, so button to submit line will work. */
2635 jQuery("input[name=\"sendit\"]").val("");
2636 jQuery("input[name=\"sendit\"]").prop("name", "senditdisabled");
2638 jQuery("input[name=\"senditdisabled\"]").prop("name", "sendit");
2645 print
'</script>'.
"\n";
2649 include DOL_DOCUMENT_ROOT.
'/expensereport/tpl/expensereport_linktofile.tpl.php';
2650 include DOL_DOCUMENT_ROOT.
'/expensereport/tpl/expensereport_addfile.tpl.php';
2652 print
'<tr class="liste_titre expensereportcreate">';
2654 print
'<td class="center expensereportcreatedate">'.$langs->trans(
'Date').
'</td>';
2656 print
'<td class="minwidth100imp">'.$form->textwithpicto($langs->trans(
'Project'), $langs->trans(
"ClosedProjectsAreHidden")).
'</td>';
2658 print
'<td class="center expensereportcreatetype">'.$langs->trans(
'Type').
'</td>';
2660 print
'<td>'.$langs->trans(
'CarCategory').
'</td>';
2662 print
'<td class="expensereportcreatedescription">'.$langs->trans(
'Description').
'</td>';
2663 print
'<td class="right expensereportcreatevat">'.$langs->trans(
'VAT').
'</td>';
2664 print
'<td class="right expensereportcreatepriceuth">'.$langs->trans(
'PriceUHT').
'</td>';
2665 print
'<td class="right expensereportcreatepricettc">'.$langs->trans(
'PriceUTTC').
'</td>';
2666 print
'<td class="right expensereportcreateqty">'.$langs->trans(
'Qty').
'</td>';
2673 print
'<tr class="oddeven nohover">';
2679 print
'<td class="center inputdate">';
2680 print $form->selectDate(!empty($date) ? $date : -1,
'date', 0, 0, 0,
'', 1, 1);
2685 print
'<td class="inputproject">';
2686 $formproject->select_projects(-1, !empty($fk_project) ? (
string) $fk_project :
'0',
'fk_project', 0, 0, $projectRequired ? 0 : 1, -1, 0, 0, 0,
'', 0, 0,
'maxwidth300');
2691 print
'<td class="center inputtype">';
2692 print $formexpensereport->selectTypeExpenseReport(!empty($fk_c_type_fees) ? $fk_c_type_fees :
"",
'fk_c_type_fees', 1);
2696 print
'<td class="fk_c_exp_tax_cat">';
2697 $params = array(
'fk_expense' =>
$object->id);
2698 print $form->selectExpenseCategories(
'',
'fk_c_exp_tax_cat', 1, array(),
'fk_c_type_fees', $userauthor->default_c_exp_tax_cat, $params, 0);
2703 print
'<td class="inputcomment">';
2704 print
'<textarea class="flat_ndf centpercent" name="comments" rows="'.ROWS_2.
'">'.
dol_escape_htmltag(!empty($comments) ? $comments :
"", 0, 1).
'</textarea>';
2708 print
'<td class="right inputvat">';
2712 $conf->global->MAIN_VAT_DEFAULT_IF_AUTODETECT_FAILS =
'none';
2715 print $form->load_tva(
'vatrate', (!empty($vatrate) ? $vatrate : $defaultvat), null, null, 0, 0,
'', false, 1);
2719 print
'<td class="right inputpricenet">';
2720 print
'<input type="text" class="right maxwidth50" id="value_unit_ht" name="value_unit_ht" value="'.dol_escape_htmltag((!empty($value_unit_ht) ? $value_unit_ht :
"")).
'"'.$taxlessUnitPriceDisabled.
' />';
2724 print
'<td class="right inputtax">';
2725 print
'<input type="text" class="right maxwidth50" id="value_unit" name="value_unit" value="'.dol_escape_htmltag((!empty($value_unit) ? $value_unit :
"")).
'">';
2729 print
'<td class="right inputqty">';
2730 print
'<input type="text" min="0" class=" input_qty right maxwidth50" name="qty" value="'.dol_escape_htmltag(!empty($qty) ? $qty : 1).
'">';
2736 if ($action !=
'editline') {
2737 print
'<td class="right"></td>';
2738 print
'<td class="right"></td>';
2742 print
'<td class="center inputbuttons">';
2743 print $form->buttonsSaveCancel(
"Add",
'', array(),
true,
'reposition');
2754 /* JQuery for product free or predefined select */
2755 jQuery(document).ready(function() {
2756 jQuery("#value_unit_ht").keyup(function(event) {
2757 console.log(event.which); // discard event tag and arrows
2758 if (event.which != 9 && (event.which < 37 ||event.which > 40) && jQuery("#value_unit_ht").val() != "") {
2759 jQuery("#value_unit").val("");
2762 jQuery("#value_unit").keyup(function(event) {
2763 console.log(event.which); // discard event tag and arrows
2764 if (event.which != 9 && (event.which < 37 || event.which > 40) && jQuery("#value_unit").val() != "") {
2765 jQuery("#value_unit_ht").val("");
2773 /* unit price coef calculation */
2774 jQuery(".input_qty, #fk_c_type_fees, #select_fk_c_exp_tax_cat, #vatrate ").change(function(event) {
2775 console.log("We change a parameter");
2777 let type_fee = jQuery("#fk_c_type_fees").find(":selected").val();
2778 let tax_cat = jQuery("#select_fk_c_exp_tax_cat").find(":selected").val();
2779 let tva = jQuery("#vatrate").find(":selected").val();
2780 let qty = jQuery(".input_qty").val();
2782 let path = "'.DOL_URL_ROOT.
'/expensereport/ajax/ajaxik.php";
2783 path += "?fk_c_exp_tax_cat="+tax_cat;
2784 path += "&fk_expense="+'.((int)
$object->id).
';
2785 path += "&vatrate="+tva;
2786 path += "&qty="+qty;
2788 if (type_fee == 4) { // mileage expenses
2789 if (tax_cat == "" || parseInt(tax_cat) <= 0){
2797 success: function(response) {
2798 if (response.response_status == "success"){';
2802 jQuery("#value_unit").val(parseFloat(response.data) * (100 + parseFloat(tva)) / 100);
2803 jQuery("#value_unit").trigger("change");
2807 jQuery("#value_unit_ht").val(response.data);
2808 jQuery("#value_unit_ht").trigger("change");
2809 jQuery("#value_unit").val("");
2814 } else if(response.response_status == "error" && response.errorMessage != undefined && response.errorMessage.length > 0 ) {
2815 console.log("We get an error result");
2816 $.jnotify(response.errorMessage, "error", {timeout: 0, type: "error"},{ remove: function (){} } );
2822 /*console.log(event.which); // discard event tag and arrows
2823 if (event.which != 9 && (event.which < 37 || event.which > 40) && jQuery("#value_unit").val() != "") {
2824 jQuery("#value_unit_ht").val("");
2844 print
'Record not found';
2855print
'<div class="tabsAction">';
2857if ($action !=
'create' && $action !=
'edit' && $action !=
'editline') {
2862 if (empty($user->socid)) {
2864 print
dolGetButtonAction(
'', $langs->trans(
'SendMail'),
'email',
dolBuildUrl($_SERVER[
"PHP_SELF"], [
'id' =>
$object->id,
'action' =>
'presend',
'mode' =>
'init'],
true).
'#formmailbeforetitle',
'');
2874 if (in_array(
$object->fk_user_author, $childids) || $user->hasRight(
'expensereport',
'writeall_advance')) {
2876 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=edit&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
'Modify').
'</a></div>';
2879 if (count(
$object->lines) > 0) {
2880 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=save&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
'ValidateAndSubmit').
'</a></div>';
2891 if ($user->id ==
$object->fk_user_author || $user->id ==
$object->fk_user_valid) {
2893 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=edit&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
'Modify').
'</a></div>';
2895 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=save_from_refuse&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
'ValidateAndSubmit').
'</a></div>';
2900 if ($user->id ==
$object->fk_user_author || $user->id ==
$object->fk_user_valid) {
2902 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=setdraft&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
'SetToDraft').
'</a></div>';
2912 if (in_array(
$object->fk_user_author, $childids)) {
2914 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=setdraft&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
'SetToDraft').
'</a></div>';
2922 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=validate&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
'Approve').
'</a></div>';
2924 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=refuse&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
'Deny').
'</a></div>';
2927 if ($user->id ==
$object->fk_user_author || $user->id ==
$object->fk_user_valid) {
2929 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=cancel&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
"Cancel").
'</a></div>';
2938 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=refuse&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
'Deny').
'</a></div>';
2944 if ($remaintopay == 0) {
2945 print
'<div class="inline-block divButAction"><span class="butActionRefused classfortooltip" title="'.$langs->trans(
"DisabledBecauseRemainderToPayIsZero").
'">'.$langs->trans(
'DoPayment').
'</span></div>';
2947 print
'<div class="inline-block divButAction"><a class="butAction" href="'.DOL_URL_ROOT.
'/expensereport/payment/payment.php?id='.
$object->id.
'&action=create">'.$langs->trans(
'DoPayment').
'</a></div>';
2955 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&action=set_paid&token='.
newToken().
'">'.$langs->trans(
"ClassifyPaid").
"</a></div>";
2961 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=cancel&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
"Cancel").
'</a></div>';
2970 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=cancel&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
"Cancel").
'</a></div>';
2975 print
'<div class="inline-block divButAction"><a class="butAction" href="'.$_SERVER[
"PHP_SELF"].
'?action=set_unpaid&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
'ClassifyUnPaid').
'</a></div>';
2979 if ($user->hasRight(
'expensereport',
'creer')) {
2980 print
'<div class="inline-block divButAction"><a class="butAction butActionClone" href="'.$_SERVER[
'PHP_SELF'].
'?id='.
$object->id.
'&action=clone&token='.
newToken().
'">'.$langs->trans(
"ToClone").
'</a></div>';
2986 print
'<div class="inline-block divButAction"><a class="butActionDelete" href="'.$_SERVER[
"PHP_SELF"].
'?action=delete&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
'Delete').
'</a></div>';
2989 print
'<div class="inline-block divButAction"><a class="butActionDelete" href="'.$_SERVER[
"PHP_SELF"].
'?action=delete&token='.
newToken().
'&id='.
$object->id.
'">'.$langs->trans(
'Delete').
'</a></div>';
2992 $parameters = array();
2993 $reshook = $hookmanager->executeHooks(
'addMoreActionsButtons', $parameters, $object, $action);
3000if (
GETPOST(
'modelselected',
'alpha')) {
3001 $action =
'presend';
3004if ($action !=
'presend') {
3009 print
'<div class="fichecenter"><div class="fichehalfleft">';
3010 print
'<a name="builddoc"></a>';
3012 if ($user->hasRight(
'expensereport',
'creer') && $action !=
'create' && $action !=
'edit') {
3015 $urlsource = $_SERVER[
"PHP_SELF"].
"?id=".
$object->id;
3016 $genallowed = $user->hasRight(
'expensereport',
'creer');
3017 $delallowed = $user->hasRight(
'expensereport',
'creer');
3019 print $formfile->showdocuments(
'expensereport', $filename, $filedir, $urlsource, $genallowed, $delallowed);
3020 $somethingshown = $formfile->numoffiles;
3036 print
'</div><div class="fichehalfright">';
3038 include_once DOL_DOCUMENT_ROOT.
'/core/class/html.formactions.class.php';
3040 $somethingshown = $formactions->showactions($object,
'expensereport', 0);
3042 print
'</div></div>';
3046$modelmail =
'expensereport_send';
3047$defaulttopic =
'SendExpenseReportRef';
3048$diroutput =
$conf->expensereport->dir_output;
3049$trackid =
'exp'.$object->id;
3051include DOL_DOCUMENT_ROOT.
'/core/tpl/card_presend.tpl.php';
$id
Support class for third parties, contacts, members, users or resources.
if(! $sortfield) if(! $sortorder) $object
global $dolibarr_main_url_root
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 bank accounts.
Class to manage accounting accounts.
Class to manage accounting journals.
Class to send emails (with attachments or not) Usage: $mailfile = new CMailFile($subject,...
Class to manage a WYSIWYG editor.
Class to manage ECM files.
Class to manage Trips and Expenses.
const STATUS_DRAFT
Draft status.
const STATUS_APPROVED
Classified approved.
const STATUS_CANCELED
Classified canceled.
const STATUS_CLOSED
Classified paid.
const STATUS_REFUSED
Classified refused.
const STATUS_VALIDATED
Validated (need to be paid)
Class of expense report details lines.
static count($dbs, $objecttype, $objectid)
Return nb of links.
Class to manage payments of expense report.
Class to manage projects.
Class to manage translations.
Class to manage Dolibarr users.
expensereport_prepare_head($object)
Prepare array with list of tabs.
dol_convert_file($fileinput, $ext='png', $fileoutput='', $page='')
Convert a PDF file into another image format.
dol_is_file($pathoffile)
Return if path is a file.
dol_dir_list($utf8_path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
$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_getIdFromCode($db, $key, $tablename, $fieldkey='code', $fieldid='id', $entityfilter=0, $filters='', $useCache=true)
Return an id or code from a code or id.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
vatrate($rate, $addpercent=false, $info_bits=0, $usestarfornpr=0, $html=0)
Return a string with VAT rate label formatted for view output Used into pdf and HTML pages.
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)
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
img_delete($titlealt='default', $other='class="pictodelete"', $morecss='')
Show delete logo.
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 '.
dolBuildUrl($url, $params=[], $addtoken=false, $anchor='')
Return path of url.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
dol_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
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.
img_mime($file, $titlealt='', $morecss='')
Show MIME img of a file.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
dolGetButtonAction($label, $text='', $actionType='default', $url='', $id='', $userRight=1, $params=array())
Function dolGetButtonAction.
getImageFileNameForSize($file, $extName, $extImgTarget='')
Return the filename of file to get the thumbs.
get_date_range($date_start, $date_end, $format='', $outputlangs=null, $withparenthesis=1)
Format output for start and end date.
getAdvancedPreviewUrl($modulepart, $relativepath, $alldata=0, $param='')
Return URL we can use for advanced preview links.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_clone($srcobject, $native=2)
Create a clone of instance of object (new instance with same value for each properties) With native =...
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...
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='', $morecssonpicto='widthpictotitle')
Load a title with picto.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
isValidEmail($address, $acceptsupervisorkey=0, $acceptuserkey=0)
Return true if email syntax is ok.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
img_edit($titlealt='default', $float=0, $other='')
Show logo edit/modify fiche.
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...
image_format_supported($file, $acceptsvg=0)
Return if a filename is file name of a supported image format.
print $langs trans('Date')." left Ref Label right Qty right Price right TotalHT right TotalTTC right right right right right right right right right centpercent right TotalHT right n right VAT right n right TotalVAT right n No sujeto a RE IRPF right TotalLT1 right n right TotalLT2 right n right TotalTTC right n takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency right TotalTTC takeposcustomercurrency right takeposcustomercurrency n right Paid right PaymentTypeShortLIQ right SELECT p pos_change as p datep as date
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $nodie=0, $mode='')
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.