dolibarr 23.0.3
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';
36require_once DOL_DOCUMENT_ROOT.'/core/lib/admin.lib.php';
37require_once DOL_DOCUMENT_ROOT.'/core/lib/member.lib.php';
38
47// Load translation files required by the page
48$langs->loadLangs(array("admin", "members"));
49
50if (!$user->admin) {
52}
53
54
55$oldtypetonewone = array('texte'=>'text', 'chaine'=>'string'); // old type to new ones
56
57$action = GETPOST('action', 'aZ09');
58
59$error = 0;
60
61$helptext = '*'.$langs->trans("FollowingConstantsWillBeSubstituted").'<br>';
62$helptext .= '__DOL_MAIN_URL_ROOT__, __ID__, __FIRSTNAME__, __LASTNAME__, __FULLNAME__, __LOGIN__, __PASSWORD__, ';
63$helptext .= '__COMPANY__, __ADDRESS__, __ZIP__, __TOWN__, __COUNTRY__, __EMAIL__, __BIRTH__, __PHOTO__, __TYPE__, ';
64//$helptext.='__YEAR__, __MONTH__, __DAY__'; // Not supported
65
66// Editing global variables not related to a specific theme
67$constantes = array(
68 'MEMBER_REMINDER_EMAIL' => array('type'=>'yesno', 'label' => $langs->trans('MEMBER_REMINDER_EMAIL', $langs->transnoentities("Module2300Name")), 'help' => $langs->trans('MEMBER_REMINDER_EMAILHelp', $langs->transnoentities("Module2300Name"))),
69 'ADHERENT_EMAIL_TEMPLATE_REMIND_EXPIRATION' => array('type'=>'emailtemplate:member', 'label'=>''),
70 'ADHERENT_EMAIL_TEMPLATE_AUTOREGISTER' => array('type'=>'emailtemplate:member', 'label'=>''),
71 'ADHERENT_EMAIL_TEMPLATE_MEMBER_VALIDATION' => array('type'=>'emailtemplate:member', 'label'=>''),
72 'ADHERENT_EMAIL_TEMPLATE_SUBSCRIPTION' => array('type'=>'emailtemplate:member', 'label'=>''),
73 'ADHERENT_EMAIL_TEMPLATE_CANCELATION' => array('type'=>'emailtemplate:member', 'label'=>''),
74 'ADHERENT_EMAIL_TEMPLATE_EXCLUSION' => array('type'=>'emailtemplate:member', 'label'=>''),
75 'ADHERENT_MAIL_FROM' => array('type'=>'string', 'label'=>''),
76 'ADHERENT_CC_MAIL_FROM' => array('type'=>'string', 'label'=>''),
77 'ADHERENT_AUTOREGISTER_NOTIF_MAIL_SUBJECT' => array('type'=>'string', 'label'=>''),
78 'ADHERENT_AUTOREGISTER_NOTIF_MAIL' => array('type'=>'html', 'tooltip' => $helptext, 'label' => '')
79);
80
81
82
83/*
84 * Actions
85 */
86
87//
88if ($action == 'updateall') {
89 $db->begin();
90
91 $res = 0;
92 foreach ($constantes as $constname => $value) {
93 $constvalue = (GETPOSTISSET('constvalue_'.$constname) ? GETPOST('constvalue_'.$constname, 'alphanohtml') : GETPOST('constvalue'));
94 $consttype = (GETPOSTISSET('consttype_'.$constname) ? GETPOST('consttype_'.$constname, 'alphanohtml') : GETPOST('consttype'));
95 $constnote = (GETPOSTISSET('constnote_'.$constname) ? GETPOST('constnote_'.$constname, 'restricthtml') : GETPOST('constnote'));
96
97 $typetouse = empty($oldtypetonewone[$consttype]) ? $consttype : $oldtypetonewone[$consttype];
98 $constvalue = preg_replace('/:member$/', '', $constvalue);
99
100 $res = dolibarr_set_const($db, $constname, $constvalue, $consttype, 0, $constnote, $conf->entity);
101 if ($res <= 0) {
102 $error++;
103 $action = 'list';
104 }
105 }
106
107 if ($error > 0) {
108 setEventMessages('ErrorFailedToSaveDate', null, 'errors');
109 $db->rollback();
110 } else {
111 setEventMessages('RecordModifiedSuccessfully', null, 'mesgs');
112 $db->commit();
113 }
114}
115
116// Action to update or add a constant
117if ($action == 'update' || $action == 'add') {
118 $constlineid = GETPOSTINT('rowid');
119 $constname = GETPOST('constname', 'alpha');
120
121 $constvalue = (GETPOSTISSET('constvalue_'.$constname) ? GETPOST('constvalue_'.$constname, 'alphanohtml') : GETPOST('constvalue'));
122 $consttype = (GETPOSTISSET('consttype_'.$constname) ? GETPOST('consttype_'.$constname, 'alphanohtml') : GETPOST('consttype'));
123 $constnote = (GETPOSTISSET('constnote_'.$constname) ? GETPOST('constnote_'.$constname, 'restricthtml') : GETPOST('constnote'));
124
125 $typetouse = empty($oldtypetonewone[$consttype]) ? $consttype : $oldtypetonewone[$consttype];
126 $constvalue = preg_replace('/:member$/', '', $constvalue);
127
128 $res = dolibarr_set_const($db, $constname, $constvalue, $typetouse, 0, $constnote, $conf->entity);
129
130 if (!($res > 0)) {
131 $error++;
132 }
133
134 if (!$error) {
135 setEventMessages($langs->trans("SetupSaved"), null, 'mesgs');
136 } else {
137 setEventMessages($langs->trans("Error"), null, 'errors');
138 }
139}
140
141
142/*
143 * View
144 */
145
146$form = new Form($db);
147
148$title = $langs->trans("MembersSetup");
149$help_url = 'EN:Module_Foundations|FR:Module_Adh&eacute;rents|ES:M&oacute;dulo_Miembros|DE:Modul_Mitglieder';
150
151llxHeader('', $title, $help_url, '', 0, 0, '', '', '', 'mod-member page-admin_emails');
152
153$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>';
154
155print load_fiche_titre($langs->trans("MembersSetup"), $linkback, 'title_setup');
156
157
159
160print dol_get_fiche_head($head, 'emails', $langs->trans("Members"), -1, 'user');
161
162// Use global form
163print '<form action="'.$_SERVER["PHP_SELF"].'" method="POST">';
164print '<input type="hidden" name="token" value="'.newToken().'">';
165print '<input type="hidden" name="action" value="updateall">';
166
167print '<br>';
168
169// TODO Try to use the formsetup class.
170
171$tableau = $constantes;
172
173print '<div class="div-table-responsive-no-min">';
174print '<table class="noborder centpercent">';
175print '<tr class="liste_titre">';
176print '<td class="">'.$langs->trans("Description").'</td>';
177print '<td>';
178print '</td>';
179print "</tr>\n";
180
181foreach ($tableau as $key => $const) { // Loop on each param
182 $label = '';
183 $type = $const['type'];
184 $label = $const['label'];
185 $help = empty($const['help']) ? '' : $const['help'];
186 $const = $key;
187
188 $sql = "SELECT rowid, ".$db->decrypt('name')." as name, ".$db->decrypt('value')." as value, type, note";
189 $sql .= " FROM ".MAIN_DB_PREFIX."const";
190 $sql .= " WHERE ".$db->decrypt('name')." = '".$db->escape($const)."'";
191 $sql .= " AND entity IN (0, ".$conf->entity.")";
192 $sql .= " ORDER BY name ASC, entity DESC";
193 $resql = $db->query($sql);
194
195 dol_syslog("List params", LOG_DEBUG);
196
197 if ($resql) {
198 $obj = $db->fetch_object($resql); // Take first result of select
199
200 if (empty($obj)) { // If not yet into table
201 $obj = (object) array('rowid' => '', 'name' => $const, 'value' => '', 'type' => $type, 'note' => '');
202 }
203 if ($const == 'ADHERENT_EMAIL_TEMPLATE_REMIND_EXPIRATION' && !getDolGlobalString('MEMBER_REMINDER_EMAIL')) {
204 continue;
205 }
206
207 print '<tr class="oddeven">';
208
209 // Show label of parameter
210 print '<td>';
211 print '<input type="hidden" name="rowid[]" value="'.$obj->rowid.'">';
212 print '<input type="hidden" name="constname[]" value="'.$const.'">';
213 print '<input type="hidden" name="constnote_'.$obj->name.'" value="'.nl2br(dol_escape_htmltag($obj->note)).'">';
214 print '<input type="hidden" name="consttype_'.$obj->name.'" value="'.($obj->type ? $obj->type : 'string').'">';
215
216 $picto = '';
217 $tmparray = explode(':', $obj->type);
218 if (!empty($tmparray[1])) {
219 $picto = preg_replace('/_send$/', '', $tmparray[1]);
220 }
221 if ($picto) {
222 print img_picto('', $picto, 'class="pictofixedwidth"');
223 }
224
225 if (!empty($tableau[$key]['tooltip'])) {
226 print $form->textwithpicto($label ? $label : $langs->trans('Desc'.$const), $tableau[$key]['tooltip']);
227 } else {
228 print($label ? $label : $langs->trans('Desc'.$const));
229 }
230
231 if (in_array($const, ['ADHERENT_MAIL_FROM', 'ADHERENT_CC_MAIL_FROM'])) {
232 print ' '.img_help(1, $langs->trans("EMailHelpMsgSPFDKIM"));
233 }
234 if ($help) {
235 print '<br><span class="opacitymedium">';
236 //print $langs->trans("MEMBER_REMINDER_EMAILHelp");
237 print $help;
238 print '</span>';
239 }
240
241 print "</td>\n";
242
243 // Value
244 print '<td>';
245 print '<input type="hidden" name="consttype_'.$const.'" value="'.($obj->type ? $obj->type : 'string').'">';
246 print '<input type="hidden" name="constnote_'.$const.'" value="'.nl2br(dol_escape_htmltag($obj->note)).'">';
247 if ($obj->type == 'textarea') {
248 print '<textarea class="flat" name="constvalue_'.$const.'" cols="50" rows="5" wrap="soft">'."\n";
249 print $obj->value;
250 print "</textarea>\n";
251 } elseif ($obj->type == 'html') {
252 require_once DOL_DOCUMENT_ROOT.'/core/class/doleditor.class.php';
253 $doleditor = new DolEditor('constvalue_'.$const, $obj->value, '', 160, 'dolibarr_notes', '', false, false, isModEnabled('fckeditor'), ROWS_5, '90%');
254 $doleditor->Create();
255 } elseif ($obj->type == 'yesno') {
256 print $form->selectyesno('constvalue_'.$const, $obj->value, 1, false, 0, 1);
257 } elseif (preg_match('/emailtemplate/', $obj->type)) {
258 include_once DOL_DOCUMENT_ROOT.'/core/class/html.formmail.class.php';
259 $formmail = new FormMail($db);
260
261 $tmp = explode(':', $obj->type);
262
263 $formmail->fetchAllEMailTemplate($tmp[1], $user, null, -1); // We set lang=null to get in priority record with no lang
264 $arrayofmessagename = array();
265 if (is_array($formmail->lines_model)) {
266 foreach ($formmail->lines_model as $modelmail) {
267 //var_dump($modelmail);
268 $moreonlabel = '';
269 if (!empty($arrayofmessagename[$modelmail->label])) {
270 $moreonlabel = ' <span class="opacitymedium">('.$langs->trans("SeveralLangugeVariatFound").')</span>';
271 }
272 // The 'label' is the key that is unique if we exclude the language
273 $arrayofmessagename[$modelmail->label.':'.$tmp[1]] = $langs->trans(preg_replace('/\‍(|\‍)/', '', $modelmail->label)).$moreonlabel;
274 }
275 }
276 //var_dump($arraydefaultmessage);
277 //var_dump($arrayofmessagename);
278 print $form->selectarray('constvalue_'.$const, $arrayofmessagename, $obj->value.':'.$tmp[1], 'None', 0, 0, '', 0, 0, 0, '', '', 1);
279
280 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>';
281 } elseif (preg_match('/MAIL_FROM$/i', $const)) {
282 print img_picto('', 'email', 'class="pictofixedwidth"').'<input type="text" class="flat minwidth300" name="constvalue_'.$const.'" value="'.dol_escape_htmltag($obj->value).'">';
283 } else { // type = 'string' ou 'chaine'
284 print '<input type="text" class="flat minwidth300" name="constvalue_'.$const .'" value="'.dol_escape_htmltag($obj->value).'">';
285 }
286 print '</td>';
287
288 print "</tr>\n";
289 }
290}
291print '</table>';
292print '</div>';
293
294
295print '<div class="center"><input type="submit" class="button" value="'.$langs->trans("Update").'" name="update"></div>';
296print '</form>';
297
298print dol_get_fiche_end();
299
300// End of page
301llxFooter();
302$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 permettant la generation du formulaire html d'envoi de mail unitaire Usage: $formail = new Form...
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.
dolBuildUrl($url, $params=[], $addtoken=false)
Return path of url.
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.
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.