dolibarr 24.0.0-beta
member_emails.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2003 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2003 Jean-Louis Bergamo <jlb@j1b.org>
4 * Copyright (C) 2004-2012 Laurent Destailleur <eldy@users.sourceforge.net>
5 * Copyright (C) 2004 Sebastien Di Cintio <sdicintio@ressource-toi.org>
6 * Copyright (C) 2004 Benoit Mortier <benoit.mortier@opensides.be>
7 * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
8 * Copyright (C) 2011-2012 Juanjo Menent <jmenent@2byte.es>
9 * Copyright (C) 2012 J. Fernando Lagrange <fernando@demo-tic.org>
10 * Copyright (C) 2015 Jean-François Ferry <jfefe@aternatik.fr>
11 * Copyright (C) 2024 Alexandre Spangaro <alexandre@inovea-conseil.com>
12 * Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
13 *
14 * This program is free software; you can redistribute it and/or modify
15 * it under the terms of the GNU General Public License as published by
16 * the Free Software Foundation; either version 3 of the License, or
17 * (at your option) any later version.
18 *
19 * This program is distributed in the hope that it will be useful,
20 * but WITHOUT ANY WARRANTY; without even the implied warranty of
21 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
22 * GNU General Public License for more details.
23 *
24 * You should have received a copy of the GNU General Public License
25 * along with this program. If not, see <https://www.gnu.org/licenses/>.
26 */
27
34// Load Dolibarr environment
35require '../../main.inc.php';
43require_once DOL_DOCUMENT_ROOT.'/core/lib/admin.lib.php';
44require_once DOL_DOCUMENT_ROOT.'/core/lib/member.lib.php';
45
46// Load translation files required by the page
47$langs->loadLangs(array("admin", "members"));
48
49if (!$user->admin) {
51}
52
53
54$oldtypetonewone = array('texte'=>'text', 'chaine'=>'string'); // old type to new ones
55
56$action = GETPOST('action', 'aZ09');
57
58$error = 0;
59
60$helptext = '*'.$langs->trans("FollowingConstantsWillBeSubstituted").'<br>';
61$helptext .= '__DOL_MAIN_URL_ROOT__, __ID__, __FIRSTNAME__, __LASTNAME__, __FULLNAME__, __LOGIN__, __PASSWORD__, ';
62$helptext .= '__COMPANY__, __ADDRESS__, __ZIP__, __TOWN__, __COUNTRY__, __EMAIL__, __BIRTH__, __PHOTO__, __TYPE__, ';
63//$helptext.='__YEAR__, __MONTH__, __DAY__'; // Not supported
64
65// Editing global variables not related to a specific theme
66$constantes = array(
67 'MEMBER_REMINDER_EMAIL' => array('type'=>'yesno', 'label' => $langs->trans('MEMBER_REMINDER_EMAIL', $langs->transnoentities("Module2300Name")), 'help' => $langs->trans('MEMBER_REMINDER_EMAILHelp', $langs->transnoentities("Module2300Name"))),
68 'ADHERENT_EMAIL_TEMPLATE_REMIND_EXPIRATION' => array('type'=>'emailtemplate:member', 'label'=>''),
69 'ADHERENT_EMAIL_TEMPLATE_AUTOREGISTER' => array('type'=>'emailtemplate:member', 'label'=>''),
70 'ADHERENT_EMAIL_TEMPLATE_MEMBER_VALIDATION' => array('type'=>'emailtemplate:member', 'label'=>''),
71 'ADHERENT_EMAIL_TEMPLATE_SUBSCRIPTION' => array('type'=>'emailtemplate:member', 'label'=>''),
72 'ADHERENT_EMAIL_TEMPLATE_CANCELATION' => array('type'=>'emailtemplate:member', 'label'=>''),
73 'ADHERENT_EMAIL_TEMPLATE_EXCLUSION' => array('type'=>'emailtemplate:member', 'label'=>''),
74 'ADHERENT_MAIL_FROM' => array('type'=>'string', 'label'=>''),
75 'ADHERENT_CC_MAIL_FROM' => array('type'=>'string', 'label'=>''),
76 'ADHERENT_AUTOREGISTER_NOTIF_MAIL_SUBJECT' => array('type'=>'string', 'label'=>''),
77 'ADHERENT_AUTOREGISTER_NOTIF_MAIL' => array('type'=>'html', 'tooltip' => $helptext, 'label' => '')
78);
79
80
81/*
82 * Actions
83 */
84
85//
86if ($action == 'updateall') {
87 $db->begin();
88
89 $res = 0;
90 foreach ($constantes as $constname => $value) {
91 $constvalue = (GETPOSTISSET('constvalue_'.$constname) ? GETPOST('constvalue_'.$constname, 'alphanohtml') : GETPOST('constvalue'));
92 $consttype = (GETPOSTISSET('consttype_'.$constname) ? GETPOST('consttype_'.$constname, 'alphanohtml') : GETPOST('consttype'));
93 $constnote = (GETPOSTISSET('constnote_'.$constname) ? GETPOST('constnote_'.$constname, 'restricthtml') : GETPOST('constnote'));
94
95 $typetouse = empty($oldtypetonewone[$consttype]) ? $consttype : $oldtypetonewone[$consttype];
96 $constvalue = preg_replace('/:member$/', '', $constvalue);
97
98 $res = dolibarr_set_const($db, $constname, $constvalue, $consttype, 0, $constnote, $conf->entity);
99 if ($res <= 0) {
100 $error++;
101 $action = 'list';
102 }
103 }
104
105 if ($error > 0) {
106 setEventMessages('ErrorFailedToSaveDate', null, 'errors');
107 $db->rollback();
108 } else {
109 setEventMessages('RecordModifiedSuccessfully', null, 'mesgs');
110 $db->commit();
111 }
112}
113
114// Action to update or add a constant
115if ($action == 'update' || $action == 'add') {
116 $constlineid = GETPOSTINT('rowid');
117 $constname = GETPOST('constname', 'alpha');
118
119 $constvalue = (GETPOSTISSET('constvalue_'.$constname) ? GETPOST('constvalue_'.$constname, 'alphanohtml') : GETPOST('constvalue'));
120 $consttype = (GETPOSTISSET('consttype_'.$constname) ? GETPOST('consttype_'.$constname, 'alphanohtml') : GETPOST('consttype'));
121 $constnote = (GETPOSTISSET('constnote_'.$constname) ? GETPOST('constnote_'.$constname, 'restricthtml') : GETPOST('constnote'));
122
123 $typetouse = empty($oldtypetonewone[$consttype]) ? $consttype : $oldtypetonewone[$consttype];
124 $constvalue = preg_replace('/:member$/', '', $constvalue);
125
126 $res = dolibarr_set_const($db, $constname, $constvalue, $typetouse, 0, $constnote, $conf->entity);
127
128 if (!($res > 0)) {
129 $error++;
130 }
131
132 if (!$error) {
133 setEventMessages($langs->trans("SetupSaved"), null, 'mesgs');
134 } else {
135 setEventMessages($langs->trans("Error"), null, 'errors');
136 }
137}
138
139
140/*
141 * View
142 */
143
144$form = new Form($db);
145
146$title = $langs->trans("MembersSetup");
147$help_url = 'EN:Module_Foundations|FR:Module_Adh&eacute;rents|ES:M&oacute;dulo_Miembros|DE:Modul_Mitglieder';
148
149llxHeader('', $title, $help_url, '', 0, 0, '', '', '', 'mod-member page-admin_emails');
150
151$linkback = '<a href="'.dolBuildUrl(DOL_URL_ROOT.'/admin/modules.php', ['restore_lastsearch_values' => 1]).'">'.img_picto($langs->trans("BackToModuleList"), 'back', 'class="pictofixedwidth"').'<span class="hideonsmartphone">'.$langs->trans("BackToModuleList").'</span></a>';
152
153print load_fiche_titre($langs->trans("MembersSetup"), $linkback, 'title_setup');
154
155
157
158print dol_get_fiche_head($head, 'emails', $langs->trans("Members"), -1, 'user');
159
160// Use global form
161print '<form action="'.$_SERVER["PHP_SELF"].'" method="POST">';
162print '<input type="hidden" name="token" value="'.newToken().'">';
163print '<input type="hidden" name="action" value="updateall">';
164
165print '<br>';
166
167// TODO Try to use the formsetup class.
168
169$tableau = $constantes;
170
171print '<div class="div-table-responsive-no-min">';
172print '<table class="noborder centpercent">';
173print '<tr class="liste_titre">';
174print '<td class="">'.$langs->trans("Parameter").'</td>';
175print '<td>';
176print '</td>';
177print "</tr>\n";
178
179foreach ($tableau as $key => $const) { // Loop on each param
180 $label = '';
181 $type = $const['type'];
182 $label = $const['label'];
183 $help = empty($const['help']) ? '' : $const['help'];
184 $const = $key;
185
186 $sql = "SELECT rowid, ".$db->decrypt('name')." as name, ".$db->decrypt('value')." as value, type, note";
187 $sql .= " FROM ".MAIN_DB_PREFIX."const";
188 $sql .= " WHERE ".$db->decrypt('name')." = '".$db->escape($const)."'";
189 $sql .= " AND entity IN (0, ".$conf->entity.")";
190 $sql .= " ORDER BY name ASC, entity DESC";
191 $resql = $db->query($sql);
192
193 dol_syslog("List params", LOG_DEBUG);
194
195 if ($resql) {
196 $obj = $db->fetch_object($resql); // Take first result of select
197
198 if (empty($obj)) { // If not yet into table
199 $obj = (object) array('rowid' => '', 'name' => $const, 'value' => '', 'type' => $type, 'note' => '');
200 }
201 if ($const == 'ADHERENT_EMAIL_TEMPLATE_REMIND_EXPIRATION' && !getDolGlobalString('MEMBER_REMINDER_EMAIL')) {
202 continue;
203 }
204
205 print '<tr class="oddeven">';
206
207 // Show label of parameter
208 print '<td>';
209 print '<input type="hidden" name="rowid[]" value="'.$obj->rowid.'">';
210 print '<input type="hidden" name="constname[]" value="'.$const.'">';
211 print '<input type="hidden" name="constnote_'.$obj->name.'" value="'.nl2br(dol_escape_htmltag($obj->note)).'">';
212 print '<input type="hidden" name="consttype_'.$obj->name.'" value="'.($obj->type ? $obj->type : 'string').'">';
213
214 $picto = '';
215 $tmparray = explode(':', $obj->type);
216 if (!empty($tmparray[1])) {
217 $picto = preg_replace('/_send$/', '', $tmparray[1]);
218 }
219 if ($picto) {
220 print img_picto('', $picto, 'class="pictofixedwidth"');
221 }
222
223 if (!empty($tableau[$key]['tooltip'])) {
224 print $form->textwithpicto($label ? $label : $langs->trans('Desc'.$const), $tableau[$key]['tooltip'] . $help);
225 } else {
226 print '<span class="valignmiddle">';
227 print($label ? $label : $langs->trans('Desc'.$const));
228 print '</span>';
229 if ($help) {
230 print $form->textwithpicto('', $help);
231 }
232 }
233
234 if (in_array($const, ['ADHERENT_MAIL_FROM', 'ADHERENT_CC_MAIL_FROM'])) {
235 print ' '.img_help(1, $langs->trans("EMailHelpMsgSPFDKIM"));
236 }
237
238 print "</td>\n";
239
240 // Value
241 print '<td>';
242 print '<input type="hidden" name="consttype_'.$const.'" value="'.($obj->type ? $obj->type : 'string').'">';
243 print '<input type="hidden" name="constnote_'.$const.'" value="'.nl2br(dol_escape_htmltag($obj->note)).'">';
244 if ($obj->type == 'textarea') {
245 print '<textarea class="flat" name="constvalue_'.$const.'" cols="50" rows="5" wrap="soft">'."\n";
246 print $obj->value;
247 print "</textarea>\n";
248 } elseif ($obj->type == 'html') {
249 require_once DOL_DOCUMENT_ROOT.'/core/class/doleditor.class.php';
250 $doleditor = new DolEditor('constvalue_'.$const, $obj->value, '', 160, 'dolibarr_notes', '', false, false, isModEnabled('fckeditor'), ROWS_5, '90%');
251 $doleditor->Create();
252 } elseif ($obj->type == 'yesno') {
253 print $form->selectyesno('constvalue_'.$const, $obj->value, 1, false, 0, 1);
254 } elseif (preg_match('/emailtemplate/', $obj->type)) {
255 include_once DOL_DOCUMENT_ROOT.'/core/class/html.formmail.class.php';
256 $formmail = new FormMail($db);
257
258 $tmp = explode(':', $obj->type);
259
260 $formmail->fetchAllEMailTemplate($tmp[1], $user, null, -1); // We set lang=null to get in priority record with no lang
261 $arrayofmessagename = array();
262 if (is_array($formmail->lines_model)) {
263 foreach ($formmail->lines_model as $modelmail) {
264 //var_dump($modelmail);
265 $moreonlabel = '';
266 if (!empty($arrayofmessagename[$modelmail->label])) {
267 $moreonlabel = ' <span class="opacitymedium">('.$langs->trans("SeveralLangugeVariatFound").')</span>';
268 }
269 // The 'label' is the key that is unique if we exclude the language
270 $arrayofmessagename[$modelmail->label.':'.$tmp[1]] = $langs->trans(preg_replace('/\‍(|\‍)/', '', $modelmail->label)).$moreonlabel;
271 }
272 }
273 //var_dump($arraydefaultmessage);
274 //var_dump($arrayofmessagename);
275 print $form->selectarray('constvalue_'.$const, $arrayofmessagename, $obj->value.':'.$tmp[1], 'None', 0, 0, '', 0, 0, 0, '', '', 1);
276
277 print '<a href="'.dolBuildUrl(DOL_URL_ROOT.'/admin/mails_templates.php', ['action' => 'create', 'type_template' => $tmp[1], 'backtopage' => dolBuildUrl($_SERVER["PHP_SELF"])]).'">'.img_picto('', 'add').'</a>';
278 } elseif (preg_match('/MAIL_FROM$/i', $const)) {
279 print img_picto('', 'email', 'class="pictofixedwidth"').'<input type="text" class="flat minwidth300" name="constvalue_'.$const.'" value="'.dol_escape_htmltag($obj->value).'">';
280 } else { // type = 'string' ou 'chaine'
281 print '<input type="text" class="flat minwidth300" name="constvalue_'.$const .'" value="'.dol_escape_htmltag($obj->value).'">';
282 }
283 print '</td>';
284
285 print "</tr>\n";
286 }
287}
288print '</table>';
289print '</div>';
290
291
292print '<div class="center"><input type="submit" class="button" value="'.$langs->trans("Update").'" name="update"></div>';
293print '</form>';
294
295print dol_get_fiche_end();
296
297// End of page
298llxFooter();
299$db->close();
dolibarr_set_const($db, $name, $value, $type='chaine', $visible=0, $note='', $entity=1)
Insert a parameter (key,value) into database (delete old key then insert it again).
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
Definition wrapper.php:91
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
Definition wrapper.php:73
Class to manage a WYSIWYG editor.
Class to manage generation of HTML components Only common components must be here.
Class to manage a HTML form to send a unitary email Usage: $formail = new FormMail($db) $formmail->pr...
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $db
API class for accounts.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0, $morecssdiv='')
Show tabs of a record.
dolBuildUrl($url, $params=[], $addtoken=false, $anchor='')
Return path of url.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='', $morecssonpicto='widthpictotitle')
Load a title with picto.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
member_admin_prepare_head()
Return array head with list of tabs to view object information.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.