37 require
'../main.inc.php';
38 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formadmin.class.php';
39 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcompany.class.php';
40 require_once DOL_DOCUMENT_ROOT.
'/core/lib/admin.lib.php';
41 require_once DOL_DOCUMENT_ROOT.
'/core/lib/functions2.lib.php';
42 require_once DOL_DOCUMENT_ROOT.
'/core/class/doleditor.class.php';
43 require_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
44 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formaccounting.class.php';
47 $langsArray=array(
"errors",
"admin",
"mails",
"languages");
50 $langsArray[]=
'members';
53 $langsArray[]=
'eventorganization';
56 $langs->loadLangs($langsArray);
58 $toselect =
GETPOST(
'toselect',
'array');
59 $action =
GETPOST(
'action',
'aZ09') ?
GETPOST(
'action',
'aZ09') :
'view';
60 $massaction =
GETPOST(
'massaction',
'alpha');
61 $confirm =
GETPOST(
'confirm',
'alpha');
62 $mode =
GETPOST(
'mode',
'aZ09');
63 $optioncss =
GETPOST(
'optioncss',
'alpha');
66 $rowid =
GETPOST(
'rowid',
'alpha');
67 $search_label =
GETPOST(
'search_label',
'alphanohtml');
68 $search_type_template =
GETPOST(
'search_type_template',
'alpha');
69 $search_lang =
GETPOST(
'search_lang',
'alpha');
70 $search_fk_user =
GETPOST(
'search_fk_user',
'intcomma');
71 $search_topic =
GETPOST(
'search_topic',
'alpha');
75 $acts[0] =
"activate";
77 $actl[0] =
img_picto($langs->trans(
"Disabled"),
'switch_off',
'class="size15x"');
78 $actl[1] =
img_picto($langs->trans(
"Activated"),
'switch_on',
'class="size15x"');
80 $listoffset =
GETPOST(
'listoffset',
'alpha');
81 $listlimit =
GETPOST(
'listlimit',
'alpha') > 0 ?
GETPOST(
'listlimit',
'alpha') : 1000;
83 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
84 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
85 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
87 if (empty($page) || $page == -1) {
90 $offset = $listlimit * $page;
91 $pageprev = $page - 1;
92 $pagenext = $page + 1;
94 if (empty($sortfield)) {
95 $sortfield =
'type_template, lang, position, label';
97 if (empty($sortorder)) {
102 $hookmanager->initHooks(array(
'emailtemplates'));
107 $tabname[25] = MAIN_DB_PREFIX.
"c_email_templates";
111 $tabfield[25] =
"label,lang,type_template,fk_user,private,position,topic,joinfiles,content";
112 if (!empty($conf->global->MAIN_EMAIL_TEMPLATES_FOR_OBJECT_LINES)) {
113 $tabfield[25] .=
',content_lines';
117 $tabfieldvalue = array();
118 $tabfieldvalue[25] =
"label,lang,type_template,fk_user,private,position,topic,joinfiles,content";
119 if (!empty($conf->global->MAIN_EMAIL_TEMPLATES_FOR_OBJECT_LINES)) {
120 $tabfieldvalue[25] .=
',content_lines';
124 $tabfieldinsert = array();
125 $tabfieldinsert[25] =
"label,lang,type_template,fk_user,private,position,topic,joinfiles,content";
126 if (!empty($conf->global->MAIN_EMAIL_TEMPLATES_FOR_OBJECT_LINES)) {
127 $tabfieldinsert[25] .=
',content_lines';
129 $tabfieldinsert[25] .=
',entity';
137 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmail.class.php';
139 if (empty($conf->global->MAIN_EMAIL_TEMPLATES_FOR_OBJECT_LINES)) {
141 $tmp[
'__(AnyTranslationKey)__'] =
'Translation';
142 $helpsubstit = $langs->trans(
"AvailableVariables").
':<br>';
143 $helpsubstitforlines = $langs->trans(
"AvailableVariables").
':<br>';
144 foreach ($tmp as $key => $val) {
145 $helpsubstit .= $key.
' -> '.$val.
'<br>';
146 $helpsubstitforlines .= $key.
' -> '.$val.
'<br>';
150 $tmp[
'__(AnyTranslationKey)__'] =
'Translation';
151 $helpsubstit = $langs->trans(
"AvailableVariables").
':<br>';
152 $helpsubstitforlines = $langs->trans(
"AvailableVariables").
':<br>';
153 foreach ($tmp as $key => $val) {
154 $helpsubstit .= $key.
' -> '.$val.
'<br>';
157 foreach ($tmp as $key => $val) {
158 $helpsubstitforlines .= $key.
' -> '.$val.
'<br>';
164 $tabhelp[25] = array(
165 'label'=>$langs->trans(
'EnterAnyCode'),
166 'topic'=>
'<span class="small">'.$helpsubstit.
'</span>',
167 'joinfiles'=>$langs->trans(
'AttachMainDocByDefault'),
168 'content'=>
'<span class="small">'.$helpsubstit.
'</span>',
169 'content_lines'=>
'<span class="small">'.$helpsubstitforlines.
'</span>',
170 'type_template'=>$langs->trans(
"TemplateForElement"),
171 'private'=>$langs->trans(
"TemplateIsVisibleByOwnerOnly"),
172 'position'=>$langs->trans(
"PositionIntoComboList")
177 $elementList = array();
180 $elementList[
'all'] =
'-- '.dol_escape_htmltag($langs->trans(
"All")).
' --';
181 $elementList[
'none'] =
'-- '.dol_escape_htmltag($langs->trans(
"None")).
' --';
182 $elementList[
'user'] =
img_picto(
'',
'user',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToUser'));
183 if (
isModEnabled(
'adherent') && !empty($user->rights->adherent->lire)) {
184 $elementList[
'member'] =
img_picto(
'',
'object_member',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToMember'));
186 if (
isModEnabled(
'recruitment') && !empty($user->rights->recruitment->recruitmentjobposition->read)) {
187 $elementList[
'recruitmentcandidature_send'] =
img_picto(
'',
'recruitmentcandidature',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'RecruitmentCandidatures'));
189 if (
isModEnabled(
"societe") && $user->hasRight(
'societe',
'lire')) {
190 $elementList[
'thirdparty'] =
img_picto(
'',
'company',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToThirdparty'));
193 $elementList[
'project'] =
img_picto(
'',
'project',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToProject'));
195 if (
isModEnabled(
"propal") && !empty($user->rights->propal->lire)) {
196 $elementList[
'propal_send'] =
img_picto(
'',
'propal',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToSendProposal'));
198 if (
isModEnabled(
'commande') && !empty($user->rights->commande->lire)) {
199 $elementList[
'order_send'] =
img_picto(
'',
'order',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToSendOrder'));
201 if (
isModEnabled(
'facture') && !empty($user->rights->facture->lire)) {
202 $elementList[
'facture_send'] =
img_picto(
'',
'bill',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToSendInvoice'));
205 $elementList[
'shipping_send'] =
img_picto(
'',
'dolly',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToSendShipment'));
208 $elementList[
'reception_send'] =
img_picto(
'',
'dollyrevert',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToSendReception'));
211 $elementList[
'fichinter_send'] =
img_picto(
'',
'intervention',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToSendIntervention'));
214 $elementList[
'supplier_proposal_send'] =
img_picto(
'',
'propal',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToSendSupplierRequestForQuotation'));
216 if ((
isModEnabled(
"fournisseur") && !empty($user->rights->fournisseur->commande->lire) && empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD)) || (
isModEnabled(
"supplier_order") && !empty($user->rights->supplier_order->lire))) {
217 $elementList[
'order_supplier_send'] =
img_picto(
'',
'order',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToSendSupplierOrder'));
219 if ((
isModEnabled(
"fournisseur") && !empty($user->rights->fournisseur->facture->lire) && empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD)) || (
isModEnabled(
"supplier_invoice") && !empty($user->rights->supplier_invoice->lire))) {
220 $elementList[
'invoice_supplier_send'] =
img_picto(
'',
'bill',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToSendSupplierInvoice'));
222 if (
isModEnabled(
'contrat') && !empty($user->rights->contrat->lire)) {
223 $elementList[
'contract'] =
img_picto(
'',
'contract',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToSendContract'));
225 if (
isModEnabled(
'ticket') && !empty($user->rights->ticket->read)) {
226 $elementList[
'ticket_send'] =
img_picto(
'',
'ticket',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToTicket'));
228 if (
isModEnabled(
'expensereport') && !empty($user->rights->expensereport->lire)) {
229 $elementList[
'expensereport_send'] =
img_picto(
'',
'trip',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToExpenseReport'));
232 $elementList[
'actioncomm_send'] =
img_picto(
'',
'action',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToSendEventPush'));
234 if (
isModEnabled(
'eventorganization') && !empty($user->rights->eventorganization->read)) {
235 $elementList[
'conferenceorbooth'] =
img_picto(
'',
'action',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToSendEventOrganization'));
237 if (!empty($conf->partnership->enabled) && !empty($user->rights->partnership->read)) {
238 $elementList[
'partnership_send'] =
img_picto(
'',
'partnership',
'class="pictofixedwidth"').dol_escape_htmltag($langs->trans(
'MailToPartnership'));
241 $parameters = array(
'elementList'=>$elementList);
242 $reshook = $hookmanager->executeHooks(
'emailElementlist', $parameters);
244 foreach ($hookmanager->resArray as $item => $value) {
245 $elementList[$item] = $value;
254 if (!empty($user->socid)) {
258 $permissiontoadd = 1;
259 $permissiontodelete = 1;
267 if (
GETPOST(
'cancel',
'alpha')) {
271 if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend') {
275 $parameters = array();
276 $reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
281 if (empty($reshook)) {
283 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
286 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
289 $search_type_template =
'';
291 $search_fk_user =
'';
294 $search_array_options = array();
298 if ((
GETPOST(
'actionadd',
'alpha') ||
GETPOST(
'actionmodify',
'alpha')) && $permissiontoadd) {
299 $listfield = explode(
',', str_replace(
' ',
'', $tabfield[$id]));
300 $listfieldinsert = explode(
',', $tabfieldinsert[$id]);
301 $listfieldmodify = explode(
',', $tabfieldinsert[$id]);
302 $listfieldvalue = explode(
',', $tabfieldvalue[$id]);
306 foreach ($listfield as $f => $value) {
308 if (in_array($value, [
'joinfiles',
'content',
'content_lines',
'module'])) {
313 if (
GETPOST(
'actionmodify',
'alpha') && $value ==
'topic') {
314 $_POST[
'topic'] =
GETPOST(
'topic-'.$rowid);
317 if ((!
GETPOSTISSET($value) ||
GETPOST($value) ==
'' ||
GETPOST($value) ==
'-1') && $value !=
'lang' && $value !=
'fk_user' && $value !=
'position') {
319 $fieldnamekey = $listfield[$f];
321 if ($fieldnamekey ==
'libelle' || ($fieldnamekey ==
'label')) {
322 $fieldnamekey =
'Code';
324 if ($fieldnamekey ==
'code') {
325 $fieldnamekey =
'Code';
327 if ($fieldnamekey ==
'note') {
328 $fieldnamekey =
'Note';
330 if ($fieldnamekey ==
'type_template') {
331 $fieldnamekey =
'TypeOfTemplate';
333 if ($fieldnamekey ==
'fk_user') {
334 $fieldnamekey =
'Owner';
336 if ($fieldnamekey ==
'private') {
337 $fieldnamekey =
'Private';
339 if ($fieldnamekey ==
'position') {
340 $fieldnamekey =
'Position';
342 if ($fieldnamekey ==
'topic') {
343 $fieldnamekey =
'Topic';
346 setEventMessages($langs->transnoentities(
"ErrorFieldRequired", $langs->transnoentities($fieldnamekey)),
null,
'errors');
352 if ($ok &&
GETPOST(
'actionadd')) {
354 $sql =
"INSERT INTO ".$tabname[$id].
" (";
356 $sql .= $tabfieldinsert[$id];
357 $sql .=
", active, enabled)";
362 foreach ($listfieldinsert as $f => $value) {
363 $keycode = isset($listfieldvalue[$i]) ? $listfieldvalue[$i] :
"";
364 if ($value ==
'lang') {
365 $keycode =
'langcode';
367 if (empty($keycode)) {
372 if ($value ==
'entity') {
373 $_POST[$keycode] = $conf->entity;
375 if ($value ==
'fk_user' && !($_POST[$keycode] > 0)) {
376 $_POST[$keycode] =
'';
378 if ($value ==
'private' && !is_numeric($_POST[$keycode])) {
379 $_POST[$keycode] =
'0';
381 if ($value ==
'position' && !is_numeric($_POST[$keycode])) {
382 $_POST[$keycode] =
'1';
389 if (
GETPOST($keycode) ==
'' && $keycode !=
'langcode') {
391 } elseif (
GETPOST($keycode) ==
'0' && $keycode ==
'langcode') {
393 } elseif ($keycode ==
'fk_user') {
395 $sql .=
" ".((int) $user->id);
397 $sql .=
" ".((int)
GETPOST($keycode,
'int'));
399 } elseif ($keycode ==
'content') {
400 $sql .=
"'".$db->escape(
GETPOST($keycode,
'restricthtml')).
"'";
401 } elseif (in_array($keycode, array(
'joinfiles',
'private',
'position',
'entity'))) {
402 $sql .= (int)
GETPOST($keycode,
'int');
404 $sql .=
"'".$db->escape(
GETPOST($keycode,
'alphanohtml')).
"'";
411 $result = $db->query($sql);
414 $_POST = array(
'id'=>$id);
416 if ($db->errno() ==
'DB_ERROR_RECORD_ALREADY_EXISTS') {
417 setEventMessages($langs->transnoentities(
"ErrorRecordAlreadyExists"),
null,
'errors');
426 if ($ok &&
GETPOST(
'actionmodify')) {
430 $sql =
"UPDATE ".$tabname[$id].
" SET ";
433 foreach ($listfieldmodify as $field) {
434 if ($field ==
'entity') {
437 $_POST[$keycode] = $conf->entity;
439 $keycode = $listfieldvalue[$i];
442 if ($field ==
'lang') {
443 $keycode =
'langcode';
445 if (empty($keycode)) {
450 if ($field ==
'fk_user' && !($_POST[
'fk_user'] > 0)) {
451 $_POST[
'fk_user'] =
'';
453 if ($field ==
'topic') {
454 $_POST[
'topic'] = $_POST[
'topic-'.$rowid];
456 if ($field ==
'joinfiles') {
457 $_POST[
'joinfiles'] = $_POST[
'joinfiles-'.$rowid];
459 if ($field ==
'content') {
460 $_POST[
'content'] = $_POST[
'content-'.$rowid];
462 if ($field ==
'content_lines') {
463 $_POST[
'content_lines'] = $_POST[
'content_lines-'.$rowid];
471 if (
GETPOST($keycode) ==
'' || ($keycode !=
'langcode' && $keycode !=
'position' && $keycode !=
'private' && !
GETPOST($keycode))) {
473 } elseif (
GETPOST($keycode) ==
'0' && $keycode ==
'langcode') {
475 } elseif ($keycode ==
'fk_user') {
477 $sql .=
" ".((int) $user->id);
479 $sql .=
" ".((int)
GETPOST($keycode,
'int'));
481 } elseif ($keycode ==
'content') {
482 $sql .=
"'".$db->escape(
GETPOST($keycode,
'restricthtml')).
"'";
483 } elseif (in_array($keycode, array(
'joinfiles',
'private',
'position'))) {
484 $sql .= (int)
GETPOST($keycode,
'int');
486 $sql .=
"'".$db->escape(
GETPOST($keycode,
'alphanohtml')).
"'";
492 $sql .=
" WHERE ".$rowidcol.
" = ".((int) $rowid);
494 $sql .=
" AND fk_user = ".((int) $user->id);
499 $resql = $db->query($sql);
509 if ($action ==
'confirm_delete' && $confirm ==
'yes' && $permissiontodelete) {
512 $sql =
"DELETE from ".$tabname[$id].
" WHERE ".$rowidcol.
" = ".((int) $rowid);
514 $sql .=
" AND fk_user = ".((int) $user->id);
517 $result = $db->query($sql);
519 if ($db->errno() ==
'DB_ERROR_CHILD_EXISTS') {
520 setEventMessages($langs->transnoentities(
"ErrorRecordIsUsedByChild"),
null,
'errors');
528 if ($action == $acts[0] && $permissiontoadd) {
531 $sql =
"UPDATE ".$tabname[$id].
" SET active = 1 WHERE rowid = ".((int) $rowid);
533 $result = $db->query($sql);
540 if ($action == $acts[1] && $permissiontoadd) {
543 $sql =
"UPDATE ".$tabname[$id].
" SET active = 0 WHERE rowid = ".((int) $rowid);
545 $result = $db->query($sql);
565 if (!empty($user->admin) && (empty($_SESSION[
'leftmenu']) || $_SESSION[
'leftmenu'] !=
'email_templates')) {
566 $title = $langs->trans(
"EMailsSetup");
568 $title = $langs->trans(
"EMailTemplates");
573 $sql =
"SELECT rowid as rowid, module, label, type_template, lang, fk_user, private, position, topic, joinfiles, content_lines, content, enabled, active";
574 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_email_templates";
575 $sql .=
" WHERE entity IN (".getEntity(
'email_template').
")";
577 $sql .=
" AND (private = 0 OR (private = 1 AND fk_user = ".((int) $user->id).
"))";
578 $sql .=
" AND (active = 1 OR fk_user = ".((int) $user->id).
")";
581 $sql .=
" AND (lang = '".$db->escape($langs->defaultlang).
"' OR lang IS NULL OR lang = '')";
586 if ($search_type_template !=
'' && $search_type_template !=
'-1') {
592 if ($search_fk_user !=
'' && $search_fk_user !=
'-1') {
599 if ($sortfield ==
'country') {
600 $sortfield =
'country_code';
602 $sql .= $db->order($sortfield, $sortorder);
603 $sql .= $db->plimit($listlimit + 1, $offset);
611 $arrayofselected = is_array($toselect) ? $toselect : array();
615 $param .=
'&mode='.urlencode($mode);
617 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
618 $param .=
'&contextpage='.urlencode($contextpage);
620 if ($limit > 0 && $limit != $conf->liste_limit) {
621 $param .=
'&limit='.urlencode($limit);
623 if (!empty($search) && is_array($search)) {
624 foreach ($search as $key => $val) {
625 if (is_array($search[$key]) && count($search[$key])) {
626 foreach ($search[$key] as $skey) {
628 $param .=
'&search_'.$key.
'[]='.urlencode($skey);
631 } elseif ($search[$key] !=
'') {
632 $param .=
'&search_'.$key.
'='.urlencode($search[$key]);
636 if ($optioncss !=
'') {
637 $param .=
'&optioncss='.urlencode($optioncss);
640 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
642 $parameters = array();
643 $reshook = $hookmanager->executeHooks(
'printFieldListSearchParam', $parameters, $object);
644 $param .= $hookmanager->resPrint;
648 $titlepicto =
'title_setup';
651 $url = DOL_URL_ROOT.
'/admin/mails_templates.php?action=create';
652 $newcardbutton =
dolGetButtonTitle($langs->trans(
'NewEMailTemplate'),
'',
'fa fa-plus-circle', $url,
'', $permissiontoadd);
655 if (!empty($user->admin) && (empty($_SESSION[
'leftmenu']) || $_SESSION[
'leftmenu'] !=
'email_templates')) {
661 if (!empty($user->admin) && (empty($_SESSION[
'leftmenu']) || $_SESSION[
'leftmenu'] !=
'email_templates')) {
666 if (!empty($user->admin) && (empty($_SESSION[
'leftmenu']) || $_SESSION[
'leftmenu'] !=
'email_templates')) {
673 if ($action ==
'delete') {
674 print
$form->formconfirm($_SERVER[
"PHP_SELF"].
'?'.($page ?
'page='.$page.
'&' :
'').
'sortfield='.$sortfield.
'&sortorder='.$sortorder.
'&rowid='.((
int) $rowid).
'&code='.urlencode($code).
'&id='.((
int) $id), $langs->trans(
'DeleteLine'), $langs->trans(
'ConfirmDeleteLine'),
'confirm_delete',
'', 0, 1);
678 $fieldlist = explode(
',', $tabfield[$id]);
680 if ($action ==
'create') {
682 $obj =
new stdClass();
683 $obj->label =
GETPOST(
'label');
685 $obj->type_template =
GETPOST(
'type_template');
686 $obj->fk_user =
GETPOST(
'fk_user',
'int');
687 $obj->private =
GETPOST(
'private',
'int');
688 $obj->position =
GETPOST(
'position');
689 $obj->topic =
GETPOST(
'topic');
690 $obj->joinfiles =
GETPOST(
'joinfiles');
691 $obj->content =
GETPOST(
'content',
'restricthtml');
694 print
'<form action="'.$_SERVER[
'PHP_SELF'].
'?id='.$id.
'" method="POST">';
695 print
'<input type="hidden" name="token" value="'.newToken().
'">';
696 print
'<input type="hidden" name="action" value="add">';
697 print
'<input type="hidden" name="from" value="'.dol_escape_htmltag(
GETPOST(
'from',
'alpha')).
'">';
699 print
'<div class="div-table-responsive-no-min">';
700 print
'<table class="noborder centpercent">';
703 print
'<tr class="liste_titre">';
704 foreach ($fieldlist as $field => $value) {
707 $valuetoshow = ucfirst($fieldlist[$field]);
708 $valuetoshow = $langs->trans($valuetoshow);
710 if ($fieldlist[$field] ==
'fk_user') {
711 $valuetoshow = $langs->trans(
"Owner");
713 if ($fieldlist[$field] ==
'lang') {
714 $valuetoshow = (!
getDolGlobalInt(
'MAIN_MULTILANGS') ?
' ' : $langs->trans(
"Language"));
716 if ($fieldlist[$field] ==
'type') {
717 $valuetoshow = $langs->trans(
"Type");
719 if ($fieldlist[$field] ==
'code') {
720 $valuetoshow = $langs->trans(
"Code");
722 if ($fieldlist[$field] ==
'libelle' || $fieldlist[$field] ==
'label') {
723 $valuetoshow = $langs->trans(
"Code");
725 if ($fieldlist[$field] ==
'type_template') {
726 $valuetoshow = $langs->trans(
"TypeOfTemplate"); $align =
"center";
728 if ($fieldlist[$field] ==
'private') {
731 if ($fieldlist[$field] ==
'position') {
735 if ($fieldlist[$field] ==
'topic') {
738 if ($fieldlist[$field] ==
'joinfiles') {
741 if ($fieldlist[$field] ==
'content') {
744 if ($fieldlist[$field] ==
'content_lines') {
747 if ($valuetoshow !=
'') {
748 print
'<th class="'.$align.
'">';
749 if (!empty($tabhelp[$id][$value]) && preg_match(
'/^http(s*):/i', $tabhelp[$id][$value])) {
750 print
'<a href="'.$tabhelp[$id][$value].
'" target="_blank" rel="noopener noreferrer">'.$valuetoshow.
' '.
img_help(1, $valuetoshow).
'</a>';
751 } elseif (!empty($tabhelp[$id][$value])) {
752 if (in_array($value, array(
'topic'))) {
753 print
$form->textwithpicto($valuetoshow, $tabhelp[$id][$value], 1,
'help',
'', 0, 2, $value);
755 print
$form->textwithpicto($valuetoshow, $tabhelp[$id][$value], 1,
'help',
'', 0, 2);
764 print
'<input type="hidden" name="id" value="'.$id.
'">';
768 $tmpaction =
'create';
770 'fieldlist' => $fieldlist,
771 'tabname' => $tabname[$id]
773 $reshook = $hookmanager->executeHooks(
'createEmailTemplateFieldlist', $parameters, $obj, $tmpaction);
774 $error = $hookmanager->error;
775 $errors = $hookmanager->errors;
779 print
'<tr class="oddeven">';
781 if (empty($reshook)) {
782 if ($action ==
'edit') {
783 fieldList($fieldlist, $obj, $tabname[$id],
'hide');
785 fieldList($fieldlist, $obj, $tabname[$id],
'add');
789 print
'<td class="right">';
794 $fieldsforcontent = array(
'topic',
'joinfiles',
'content');
795 if (!empty($conf->global->MAIN_EMAIL_TEMPLATES_FOR_OBJECT_LINES)) {
796 $fieldsforcontent = array(
'topic',
'joinfiles',
'content',
'content_lines');
798 foreach ($fieldsforcontent as $tmpfieldlist) {
799 print
'<tr class="impair nodrag nodrop nohover"><td colspan="7" class="nobottom">';
802 if ($tmpfieldlist ==
'topic') {
803 print
'<strong>'.$form->textwithpicto($langs->trans(
"Topic"), $tabhelp[$id][$tmpfieldlist], 1,
'help',
'', 0, 2, $tmpfieldlist).
'</strong> ';
805 if ($tmpfieldlist ==
'joinfiles') {
806 print
'<strong>'.$form->textwithpicto($langs->trans(
"FilesAttachedToEmail"), $tabhelp[$id][$tmpfieldlist], 1,
'help',
'', 0, 2, $tmpfieldlist).
'</strong> ';
808 if ($tmpfieldlist ==
'content') {
809 print
$form->textwithpicto($langs->trans(
"Content"), $tabhelp[$id][$tmpfieldlist], 1,
'help',
'', 0, 2, $tmpfieldlist).
'<br>';
811 if ($tmpfieldlist ==
'content_lines') {
812 print
$form->textwithpicto($langs->trans(
"ContentForLines"), $tabhelp[$id][$tmpfieldlist], 1,
'help',
'', 0, 2, $tmpfieldlist).
'<br>';
816 if ($tmpfieldlist ==
'topic') {
817 print
'<input type="text" class="flat minwidth500" name="'.$tmpfieldlist.
'" value="'.(!empty($obj->$tmpfieldlist) ? $obj->$tmpfieldlist :
'').
'">';
818 } elseif ($tmpfieldlist ==
'joinfiles') {
819 print
$form->selectyesno($tmpfieldlist, (isset($obj->$tmpfieldlist) ? $obj->$tmpfieldlist :
'0'), 1,
false, 0, 1);
821 $okforextended =
true;
822 if (empty($conf->global->FCKEDITOR_ENABLE_MAIL)) {
823 $okforextended =
false;
825 $doleditor =
new DolEditor($tmpfieldlist, (!empty($obj->$tmpfieldlist) ? $obj->$tmpfieldlist :
''),
'', 180,
'dolibarr_mailings',
'In',
false, $acceptlocallinktomedia, $okforextended, ROWS_4,
'90%');
826 print $doleditor->Create(1);
834 if ($action !=
'edit') {
836 print
'<input type="submit" class="button button-add" name="actionadd" value="'.$langs->trans(
"Add").
'"> ';
837 print
'<input type="submit" class="button button-cancel" name="actioncancel" value="'.$langs->trans(
"Cancel").
'">';
848 $resql = $db->query($sql);
854 $num = $db->num_rows(
$resql);
856 print
'<form action="'.$_SERVER[
'PHP_SELF'].
'?id='.$id.
'" method="POST">';
857 print
'<input type="hidden" name="token" value="'.newToken().
'">';
858 print
'<input type="hidden" name="from" value="'.dol_escape_htmltag(
GETPOST(
'from',
'alpha')).
'">';
860 print
'<div class="div-table-responsive-no-min">';
861 print
'<table class="noborder centpercent">';
867 $param .=
'&search_label='.urlencode($search_label);
869 if ($search_lang > 0) {
870 $param .=
'&search_lang='.urlencode($search_lang);
872 if ($search_type_template !=
'-1') {
873 $param .=
'&search_type_template='.urlencode($search_type_template);
875 if ($search_fk_user > 0) {
876 $param .=
'&search_fk_user='.urlencode($search_fk_user);
879 $param .=
'&search_topic='.urlencode($search_topic);
882 $paramwithsearch = $param;
884 $paramwithsearch .=
'&sortorder='.urlencode($sortorder);
887 $paramwithsearch .=
'&sortfield='.urlencode($sortfield);
889 if (
GETPOST(
'from',
'alpha')) {
890 $paramwithsearch .=
'&from='.urlencode(
GETPOST(
'from',
'alpha'));
894 if ($num > $listlimit) {
895 print
'<tr class="none"><td class="right" colspan="'.(3 + count($fieldlist)).
'">';
896 print_fleche_navigation($page, $_SERVER[
"PHP_SELF"], $paramwithsearch, ($num > $listlimit),
'<li class="pagination"><span>'.$langs->trans(
"Page").
' '.($page + 1).
'</span></li>');
902 print
'<tr class="liste_titre">';
904 foreach ($fieldlist as $field => $value) {
905 if ($value ==
'label') {
906 print
'<td class="liste_titre"><input type="text" name="search_label" class="maxwidth200" value="'.dol_escape_htmltag($search_label).
'"></td>';
907 } elseif ($value ==
'lang') {
908 print
'<td class="liste_titre">';
909 print $formadmin->select_language($search_lang,
'search_lang', 0,
null, 1, 0, 0,
'maxwidth100');
911 } elseif ($value ==
'fk_user') {
912 print
'<td class="liste_titre">';
913 print
$form->select_dolusers($search_fk_user,
'search_fk_user', 1,
null, 0, ($user->admin ?
'' :
'hierarchyme'),
null, 0, 0, 0,
'', 0,
'',
'maxwidth125', 1);
915 } elseif ($value ==
'topic') {
916 print
'<td class="liste_titre"><input type="text" name="search_topic" value="'.dol_escape_htmltag($search_topic).
'"></td>';
917 } elseif ($value ==
'type_template') {
918 print
'<td class="liste_titre center">';
919 print
$form->selectarray(
'search_type_template', $elementList, $search_type_template, 1, 0, 0,
'', 0, 0, 0,
'',
'minwidth100 maxwidth125', 1,
'', 0, 1);
921 } elseif (!in_array($value, array(
'content',
'content_lines'))) {
922 print
'<td class="liste_titre"></td>';
926 if (empty($conf->global->MAIN_EMAIL_TEMPLATES_FOR_OBJECT_LINES)) {
927 print
'<td class="liste_titre"></td>';
931 print
'<td class="liste_titre right" width="64">';
932 $searchpicto =
$form->showFilterButtons();
938 print
'<tr class="liste_titre">';
939 foreach ($fieldlist as $field => $value) {
952 $valuetoshow = ucfirst($fieldlist[$field]);
953 $valuetoshow = $langs->trans($valuetoshow);
954 if ($fieldlist[$field] ==
'fk_user') {
955 $valuetoshow = $langs->trans(
"Owner");
957 if ($fieldlist[$field] ==
'lang') {
958 $valuetoshow = $langs->trans(
"Language");
960 if ($fieldlist[$field] ==
'type') {
961 $valuetoshow = $langs->trans(
"Type");
963 if ($fieldlist[$field] ==
'libelle' || $fieldlist[$field] ==
'label') {
964 $valuetoshow = $langs->trans(
"Code");
966 if ($fieldlist[$field] ==
'type_template') {
968 $valuetoshow = $langs->trans(
"TypeOfTemplate");
970 if ($fieldlist[$field] ==
'private') {
973 if ($fieldlist[$field] ==
'position') {
977 if ($fieldlist[$field] ==
'joinfiles') {
978 $valuetoshow = $langs->trans(
"FilesAttachedToEmail"); $align =
'center'; $forcenowrap = 0;
980 if ($fieldlist[$field] ==
'content') {
981 $valuetoshow = $langs->trans(
"Content"); $showfield = 0;
983 if ($fieldlist[$field] ==
'content_lines') {
984 $valuetoshow = $langs->trans(
"ContentForLines"); $showfield = 0;
989 if (!empty($tabhelp[$id][$value])) {
990 if (in_array($value, array(
'topic'))) {
991 $valuetoshow =
$form->textwithpicto($valuetoshow, $tabhelp[$id][$value], 1,
'help',
'', 0, 2,
'tooltip'.$value, $forcenowrap);
993 $valuetoshow =
$form->textwithpicto($valuetoshow, $tabhelp[$id][$value], 1,
'help',
'', 0, 2,
'', $forcenowrap);
996 print
getTitleFieldOfList($valuetoshow, 0, $_SERVER[
"PHP_SELF"], ($sortable ? $fieldlist[$field] :
''), ($page ?
'page='.$page.
'&' :
''), $param,
"align=".$align, $sortfield, $sortorder);
1000 print
getTitleFieldOfList($langs->trans(
"Status"), 0, $_SERVER[
"PHP_SELF"],
"active", ($page ?
'page='.$page.
'&' :
''), $param,
'align="center"', $sortfield, $sortorder);
1009 $obj = $db->fetch_object(
$resql);
1012 if ($action ==
'edit' && ($rowid == (!empty($obj->rowid) ? $obj->rowid : $obj->code))) {
1013 print
'<tr class="oddeven" id="rowid-'.$obj->rowid.
'">';
1015 $tmpaction =
'edit';
1016 $parameters = array(
'fieldlist'=>$fieldlist,
'tabname'=>$tabname[$id]);
1017 $reshook = $hookmanager->executeHooks(
'editEmailTemplateFieldlist', $parameters, $obj, $tmpaction);
1018 $error = $hookmanager->error; $errors = $hookmanager->errors;
1021 if (empty($reshook)) {
1022 fieldList($fieldlist, $obj, $tabname[$id],
'edit');
1025 print
'<td></td><td></td><td></td>';
1026 print
'<td class="center">';
1027 print
'<input type="hidden" name="page" value="'.$page.
'">';
1028 print
'<input type="hidden" name="rowid" value="'.$rowid.
'">';
1029 print
'<input type="submit" class="button buttongen button-save" name="actionmodify" value="'.$langs->trans(
"Modify").
'">';
1030 print
'<div name="'.(!empty($obj->rowid) ? $obj->rowid : $obj->code).
'"></div>';
1031 print
'<input type="submit" class="button buttongen button-cancel" name="actioncancel" value="'.$langs->trans(
"Cancel").
'">';
1034 $fieldsforcontent = array(
'topic',
'joinfiles',
'content');
1035 if (!empty($conf->global->MAIN_EMAIL_TEMPLATES_FOR_OBJECT_LINES)) {
1036 $fieldsforcontent = array(
'topic',
'joinfiles',
'content',
'content_lines');
1038 foreach ($fieldsforcontent as $tmpfieldlist) {
1041 $valuetoshow = $obj->$tmpfieldlist;
1047 print
'</tr><tr class="oddeven" nohover tr-'.$tmpfieldlist.
'-'.$rowid.
' ">';
1048 print
'<td colspan="8">';
1049 if ($tmpfieldlist ==
'topic') {
1050 print
'<strong>'.$form->textwithpicto($langs->trans(
"Topic"), $tabhelp[$id][$tmpfieldlist], 1,
'help',
'', 0, 2, $tmpfieldlist).
'</strong> ';
1051 print
'<input type="text" class="flat minwidth500" name="'.$tmpfieldlist.
'-'.$rowid.
'" value="'.(!empty($obj->{$tmpfieldlist}) ? $obj->{$tmpfieldlist} :
'').
'">';
1053 if ($tmpfieldlist ==
'joinfiles') {
1054 print
'<strong>'.$form->textwithpicto($langs->trans(
"FilesAttachedToEmail"), $tabhelp[$id][$tmpfieldlist], 1,
'help',
'', 0, 2, $tmpfieldlist).
'</strong> ';
1055 print
$form->selectyesno($tmpfieldlist.
'-'.$rowid, (isset($obj->$tmpfieldlist) ? $obj->$tmpfieldlist :
'0'), 1,
false, 0, 1);
1058 if ($tmpfieldlist ==
'content') {
1059 print
$form->textwithpicto($langs->trans(
"Content"), $tabhelp[$id][$tmpfieldlist], 1,
'help',
'', 0, 2, $tmpfieldlist).
'<br>';
1060 $okforextended =
true;
1061 if (empty($conf->global->FCKEDITOR_ENABLE_MAIL)) {
1062 $okforextended =
false;
1065 $doleditor =
new DolEditor($tmpfieldlist.
'-'.$rowid, (!empty($obj->{$tmpfieldlist}) ? $obj->{$tmpfieldlist} :
''),
'', 500,
'dolibarr_mailings',
'In', 0, $acceptlocallinktomedia, $okforextended, ROWS_6,
'90%');
1066 print $doleditor->Create(1);
1068 if ($tmpfieldlist ==
'content_lines') {
1069 print
$form->textwithpicto($langs->trans(
"ContentForLines"), $tabhelp[$id][$tmpfieldlist], 1,
'help',
'', 0, 2, $tmpfieldlist).
'<br>';
1070 $okforextended =
true;
1071 if (empty($conf->global->FCKEDITOR_ENABLE_MAIL)) {
1072 $okforextended =
false;
1074 $doleditor =
new DolEditor($tmpfieldlist.
'-'.$rowid, (!empty($obj->{$tmpfieldlist}) ? $obj->{$tmpfieldlist} :
''),
'', 140,
'dolibarr_mailings',
'In', 0, $acceptlocallinktomedia, $okforextended, ROWS_6,
'90%');
1075 print $doleditor->Create(1);
1089 $tempmodulekey = $obj->module;
1090 if (empty($conf->$tempmodulekey) || empty($conf->$tempmodulekey->enabled)) {
1096 $keyforobj =
'type_template';
1097 if (!in_array($obj->$keyforobj, array_keys($elementList))) {
1102 if (!
dol_eval($obj->enabled, 1, 1,
'1')) {
1109 print
'<tr class="oddeven" id="rowid-'.$obj->rowid.
'">';
1111 $tmpaction =
'view';
1112 $parameters = array(
'fieldlist'=>$fieldlist,
'tabname'=>$tabname[$id]);
1113 $reshook = $hookmanager->executeHooks(
'viewEmailTemplateFieldlist', $parameters, $obj, $tmpaction);
1115 $error = $hookmanager->error; $errors = $hookmanager->errors;
1117 if (empty($reshook)) {
1118 foreach ($fieldlist as $field => $value) {
1119 if (in_array($fieldlist[$field], array(
'content',
'content_lines'))) {
1126 $valuetoshow = $obj->{$fieldlist[$field]};
1127 if ($value ==
'label' || $value ==
'topic') {
1128 if ($langs->trans($valuetoshow) != $valuetoshow) {
1129 $valuetoshow = $langs->trans($valuetoshow);
1133 if ($value ==
'label') {
1134 $class .=
' tdoverflowmax100';
1136 if ($value ==
'topic') {
1137 $class .=
' tdoverflowmax200 small';
1139 if ($value ==
'type_template') {
1140 $valuetoshow = isset($elementList[$valuetoshow]) ? $elementList[$valuetoshow] : $valuetoshow;
1143 if ($value ==
'lang' && $valuetoshow) {
1144 $valuetoshow = $valuetoshow.
' - '.$langs->trans(
"Language_".$valuetoshow);
1146 if ($value ==
'fk_user') {
1147 if ($valuetoshow > 0) {
1148 $fuser =
new User($db);
1149 $fuser->fetch($valuetoshow);
1150 $valuetoshow = $fuser->getNomUrl(1);
1153 if ($value ==
'private') {
1156 $valuetoshow =
yn($valuetoshow);
1161 if ($value ==
'position') {
1164 if ($value ==
'joinfiles') {
1167 $valuetoshow =
yn(1);
1173 $class .=
' '.$align;
1178 print
'<!-- '.$fieldlist[$field].
' -->';
1179 print
'<td class="'.$class.
'"';
1180 if (in_array($value, array(
'code',
'label',
'topic'))) {
1181 print
' title="'.dol_escape_htmltag($valuetoshow).
'"';
1191 $iserasable = 1; $canbedisabled = 1; $canbemodified = 1;
1192 if (!$user->admin && $obj->fk_user != $user->id) {
1198 $url = $_SERVER[
"PHP_SELF"].
'?'.($page ?
'page='.$page.
'&' :
'').
'sortfield='.$sortfield.
'&sortorder='.$sortorder.
'&rowid='.(!empty($obj->rowid) ? $obj->rowid : (!empty($obj->code) ? $obj->code :
'')).
'&code='.(!empty($obj->code) ?urlencode($obj->code) :
'');
1204 print
'<td class="center nowrap">';
1205 if ($canbedisabled) {
1206 print
'<a class="reposition" href="'.$url.
'&action='.$acts[$obj->active].
'&token='.
newToken().
'">'.$actl[$obj->active].
'</a>';
1208 print
'<span class="opacitymedium">'.$actl[$obj->active].
'</span>';
1213 print
'<td class="center nowraponall" width="64">';
1214 if ($canbemodified) {
1215 print
'<a class="reposition editfielda" href="'.$url.
'&action=edit&token='.
newToken().
'">'.
img_edit().
'</a>';
1218 print
'<a class="marginleftonly" href="'.$url.
'&action=delete&token='.
newToken().
'">'.
img_delete().
'</a>';
1232 if ($nbqualified == 0) {
1234 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
1243 if (!empty($user->admin) && (empty($_SESSION[
'leftmenu']) || $_SESSION[
'leftmenu'] !=
'email_templates')) {
1262 function fieldList($fieldlist, $obj =
'', $tabname =
'', $context =
'')
1264 global $conf, $langs, $user, $db;
1266 global $elementList;
1270 foreach ($fieldlist as $field => $value) {
1271 if ($value ==
'fk_user') {
1274 print
$form->select_dolusers(empty($obj->{$value}) ?
'' : $obj->{$value},
'fk_user', 1,
null, 0, ($user->admin ?
'' :
'hierarchyme'),
null, 0, 0, 0,
'', 0,
'',
'minwidth150 maxwidth200');
1276 if ($context ==
'add') {
1277 print $user->getNomUrl(1);
1278 $forcedvalue = $user->id;
1280 if ($obj && !empty($obj->{$value}) && $obj->{$value} > 0) {
1281 $fuser =
new User($db);
1282 $fuser->fetch($obj->{$value});
1283 print $fuser->getNomUrl(1);
1284 $forcedvalue = $fuser->id;
1286 $forcedvalue = $obj->{$value};
1290 print
'<input type="hidden" value="'.$forcedvalue.
'" name="'.$keyname.
'">';
1293 } elseif ($value ==
'lang') {
1296 $selectedlang =
GETPOSTISSET(
'langcode') ?
GETPOST(
'langcode',
'aZ09') : $langs->defaultlang;
1297 if ($context ==
'edit') {
1298 $selectedlang = $obj->lang;
1300 print $formadmin->select_language($selectedlang,
'langcode', 0,
null, 1, 0, 0,
'maxwidth150');
1302 if (!empty($obj->lang)) {
1303 print $obj->lang.
' - '.$langs->trans(
'Language_'.$obj->lang);
1306 if ($keyname ==
'lang') {
1307 $keyname =
'langcode';
1309 print
'<input type="hidden" value="'.(empty($obj->lang) ?
'' : $obj->lang).
'" name="'.$keyname.
'">';
1312 } elseif ($value ==
'type_template') {
1314 print
'<td class="center">';
1315 if ($context ==
'edit' && !empty($obj->type_template) && !in_array($obj->type_template, array_keys($elementList))) {
1317 print
'<input type="hidden" name="type_template" value="'.$obj->type_template.
'">';
1318 print $obj->type_template;
1320 print
$form->selectarray(
'type_template', $elementList, (!empty($obj->type_template) ? $obj->type_template:
''), 1, 0, 0,
'', 0, 0, 0,
'',
'minwidth150', 1,
'', 0, 1);
1323 } elseif ($context ==
'add' && in_array($value, array(
'topic',
'joinfiles',
'content',
'content_lines'))) {
1325 } elseif ($context ==
'edit' && in_array($value, array(
'topic',
'joinfiles',
'content',
'content_lines'))) {
1327 } elseif ($context ==
'hide' && in_array($value, array(
'topic',
'joinfiles',
'content',
'content_lines'))) {
1330 $size =
''; $class =
''; $classtd =
'';
1331 if ($value ==
'code') {
1332 $class =
'maxwidth100';
1334 if ($value ==
'label') {
1335 $class =
'maxwidth200';
1337 if ($value ==
'private') {
1338 $class =
'maxwidth50'; $classtd =
'center';
1340 if ($value ==
'position') {
1341 $class =
'maxwidth50 center'; $classtd =
'center';
1343 if ($value ==
'libelle') {
1344 $class =
'quatrevingtpercent';
1346 if ($value ==
'topic') {
1347 $class =
'quatrevingtpercent';
1349 if ($value ==
'sortorder' || $value ==
'sens' || $value ==
'category_type') {
1350 $size =
'size="2" ';
1353 print
'<td'.($classtd ?
' class="'.$classtd.
'"' :
'').
'>';
1354 if ($value ==
'private') {
1355 if (empty($user->admin)) {
1356 print
$form->selectyesno($value,
'1', 1);
1358 print
$form->selectyesno($value, (isset($obj->{$value}) ? $obj->{$value}:
''), 1);
1361 print
'<input type="text" '.$size.
'class="flat'.($class ?
' '.$class :
'').
'" value="'.(isset($obj->{$value}) ? $obj->{$value}:
'').
'" name="'. $value .
'">';