24 require
'../main.inc.php';
25 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formadmin.class.php';
26 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcompany.class.php';
27 require_once DOL_DOCUMENT_ROOT.
'/core/lib/admin.lib.php';
28 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
29 require_once DOL_DOCUMENT_ROOT.
'/core/lib/website.lib.php';
30 require_once DOL_DOCUMENT_ROOT.
'/core/lib/functions2.lib.php';
31 require_once DOL_DOCUMENT_ROOT.
'/core/class/doleditor.class.php';
32 require_once DOL_DOCUMENT_ROOT.
'/website/class/website.class.php';
35 $langs->loadlangs(array(
'errors',
'admin',
'companies',
'website'));
37 $action =
GETPOST(
'action',
'alpha') ?
GETPOST(
'action',
'alpha') :
'view';
38 $confirm =
GETPOST(
'confirm',
'alpha');
39 $backtopage =
GETPOST(
'backtopage',
'alpha');
41 $rowid =
GETPOST(
'rowid',
'alpha');
49 $acts[0] =
"activate";
51 $actl[0] =
img_picto($langs->trans(
"Disabled"),
'switch_off',
'class="size15x"');
52 $actl[1] =
img_picto($langs->trans(
"Activated"),
'switch_on',
'class="size15x"');
55 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
56 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
57 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
59 if (empty($page) || $page == -1) {
62 $offset = $limit * $page;
63 $pageprev = $page - 1;
64 $pagenext = $page + 1;
66 if (empty($sortfield)) {
67 $sortfield =
'position, ref';
69 if (empty($sortorder)) {
74 $hookmanager->initHooks(array(
'website'));
78 $tabname[1] = MAIN_DB_PREFIX.
"website";
82 $tablib[1] =
"Websites";
86 $tabsql[1] =
"SELECT f.rowid as rowid, f.entity, f.ref, f.description, f.virtualhost, f.position, f.status, f.date_creation FROM ".MAIN_DB_PREFIX.
'website as f WHERE f.entity IN ('.
getEntity(
'website').
')';
89 $tabsqlsort = array();
90 $tabsqlsort[1] =
"ref ASC";
94 $tabfield[1] =
"ref,description,virtualhost,position,date_creation";
97 $tabfieldvalue = array();
98 $tabfieldvalue[1] =
"ref,description,virtualhost,position,entity";
101 $tabfieldinsert = array();
102 $tabfieldinsert[1] =
"ref,description,virtualhost,position,entity";
112 $tabcond[1] = (!empty($conf->website->enabled));
116 $tabhelp[1] = array(
'ref'=>$langs->trans(
"EnterAnyCode"),
'virtualhost'=>$langs->trans(
"SetHereVirtualHost", DOL_DATA_ROOT.($conf->entity > 1 ?
'/'.$conf->entity :
'').
'/website/<i>websiteref</i>'));
119 $tabfieldcheck = array();
120 $tabfieldcheck[1] = array();
124 $elementList = array();
125 $sourceList = array();
133 if (
GETPOST(
'actionadd',
'alpha') ||
GETPOST(
'actionmodify',
'alpha')) {
134 $listfield = explode(
',', $tabfield[$id]);
135 $listfieldinsert = explode(
',', $tabfieldinsert[$id]);
136 $listfieldmodify = explode(
',', $tabfieldinsert[$id]);
137 $listfieldvalue = explode(
',', $tabfieldvalue[$id]);
141 foreach ($listfield as $f => $value) {
144 $fieldnamekey = $listfield[$f];
145 setEventMessages($langs->transnoentities(
"ErrorFieldRequired", $langs->transnoentities($fieldnamekey)),
null,
'errors');
147 } elseif ($value ==
'ref' && !preg_match(
'/^[a-z0-9_\-\.]+$/i',
GETPOST($value))) {
149 $fieldnamekey = $listfield[$f];
150 setEventMessages($langs->transnoentities(
"ErrorFieldCanNotContainSpecialCharacters", $langs->transnoentities($fieldnamekey)),
null,
'errors');
157 $websitekey = strtolower(
GETPOST(
'ref'));
161 if ($ok &&
GETPOST(
'actionadd',
'alpha')) {
162 if ($tabrowid[$id]) {
165 $sql =
"SELECT max(".$tabrowid[$id].
") newid from ".$tabname[$id];
166 $result = $db->query($sql);
168 $obj = $db->fetch_object($result);
169 $newid = ($obj->newid + 1);
182 $sql =
"INSERT INTO ".$tabname[$id].
" (";
184 if ($tabrowid[$id] && !in_array($tabrowid[$id], $listfieldinsert)) {
185 $sql .= $tabrowid[$id].
",";
187 $sql .= $tabfieldinsert[$id];
192 if ($tabrowid[$id] && !in_array($tabrowid[$id], $listfieldinsert)) {
196 foreach ($listfieldinsert as $f => $value) {
197 if ($value ==
'entity') {
198 $_POST[$listfieldvalue[$i]] = $conf->entity;
200 if ($value ==
'ref') {
201 $_POST[$listfieldvalue[$i]] = strtolower(
GETPOST($listfieldvalue[$i]));
206 if (
GETPOST($listfieldvalue[$i]) ==
'') {
209 $sql .=
"'".$db->escape(
GETPOST($listfieldvalue[$i])).
"'";
216 $result = $db->query($sql);
221 if ($db->errno() ==
'DB_ERROR_RECORD_ALREADY_EXISTS') {
222 setEventMessages($langs->transnoentities(
"ErrorRecordAlreadyExists"),
null,
'errors');
230 if ($ok &&
GETPOST(
'actionmodify',
'alpha')) {
231 if ($tabrowid[$id]) {
232 $rowidcol = $tabrowid[$id];
240 $rowid =
GETPOST(
'rowid',
'int');
241 $website->fetch($rowid);
244 $sql =
"UPDATE ".$tabname[$id].
" SET ";
246 if ($tabrowid[$id] && !in_array($tabrowid[$id], $listfieldmodify)) {
247 $sql .= $tabrowid[$id].
"=";
248 $sql .=
"'".$db->escape($rowid).
"', ";
251 foreach ($listfieldmodify as $field) {
252 if ($field ==
'entity') {
253 $_POST[$listfieldvalue[$i]] = $conf->entity;
259 if ($_POST[$listfieldvalue[$i]] ==
'') {
262 $sql .=
"'".$db->escape(
GETPOST($listfieldvalue[$i])).
"'";
266 $sql .=
" WHERE ".$rowidcol.
" = ".((int) $rowid);
270 $resql = $db->query($sql);
273 if ($newname != $website->ref) {
274 $srcfile = DOL_DATA_ROOT.($conf->entity > 1 ?
'/'.$conf->entity :
'').
'/website/'.$website->ref;
275 $destfile = DOL_DATA_ROOT.($conf->entity > 1 ?
'/'.$conf->entity :
'').
'/website/'.$newname;
279 setEventMessages($langs->trans(
'ErrorDirAlreadyExists', $destfile),
null,
'errors');
281 @rename($srcfile, $destfile);
284 $arrayreplacement = array($website->ref.
'/htmlheader.html' => $newname.
'/htmlheader.html');
285 $listofilestochange =
dol_dir_list($destfile,
'files', 0,
'\.php$');
286 foreach ($listofilestochange as $key => $value) {
305 if (
GETPOST(
'actioncancel',
'alpha')) {
309 if ($action ==
'confirm_delete' && $confirm ==
'yes') {
310 if ($tabrowid[$id]) {
311 $rowidcol = $tabrowid[$id];
317 $website->fetch($rowid);
319 if ($website->id > 0) {
320 $sql =
"DELETE from ".MAIN_DB_PREFIX.
"website_account WHERE fk_website = ".((int) $rowid);
321 $result = $db->query($sql);
323 $sql =
"DELETE from ".MAIN_DB_PREFIX.
"website_page WHERE fk_website = ".((int) $rowid);
324 $result = $db->query($sql);
326 $sql =
"DELETE from ".MAIN_DB_PREFIX.
"website_extrafields WHERE fk_object = ".((int) $rowid);
327 $result = $db->query($sql);
329 $sql =
"DELETE from ".MAIN_DB_PREFIX.
"website WHERE rowid = ".((int) $rowid);
330 $result = $db->query($sql);
332 if ($db->errno() ==
'DB_ERROR_CHILD_EXISTS') {
333 setEventMessages($langs->transnoentities(
"ErrorRecordIsUsedByChild"),
null,
'errors');
348 if ($action == $acts[0]) {
349 if ($tabrowid[$id]) {
350 $rowidcol = $tabrowid[$id];
356 $sql =
"UPDATE ".$tabname[$id].
" SET status = 1 WHERE rowid = ".((int) $rowid);
359 $result = $db->query($sql);
366 if ($action == $acts[1]) {
367 if ($tabrowid[$id]) {
368 $rowidcol = $tabrowid[$id];
374 $sql =
"UPDATE ".$tabname[$id].
" SET status = 0 WHERE rowid = ".((int) $rowid);
377 $result = $db->query($sql);
392 llxHeader(
'', $langs->trans(
"WebsiteSetup"));
394 $titre = $langs->trans(
"WebsiteSetup");
395 $linkback =
'<a href="'.($backtopage ? $backtopage : DOL_URL_ROOT.
'/admin/modules.php').
'">'.$langs->trans(
"BackToModuleList").
'</a>';
402 $head[$h][0] = DOL_URL_ROOT.
"/admin/website.php";
403 $head[$h][1] = $langs->trans(
"WebSites");
404 $head[$h][2] =
'website';
407 $head[$h][0] = DOL_URL_ROOT.
"/admin/website_options.php";
408 $head[$h][1] = $langs->trans(
"Options");
409 $head[$h][2] =
'options';
415 print
'<span class="opacitymedium">'.$langs->trans(
"WebsiteSetupDesc").
'</span><br>';
420 if ($action ==
'delete') {
421 print
$form->formconfirm($_SERVER[
"PHP_SELF"].
'?'.($page ?
'page='.$page.
'&' :
'').
'sortfield='.$sortfield.
'&sortorder='.$sortorder.
'&rowid='.$rowid, $langs->trans(
'DeleteWebsite'), $langs->trans(
'ConfirmDeleteWebsite'),
'confirm_delete',
'', 0, 1, 220);
431 $sql .= $db->order($sortfield, $sortorder);
432 $sql .= $db->plimit($limit + 1, $offset);
435 $fieldlist = explode(
',', $tabfield[$id]);
437 print
'<form action="'.$_SERVER[
'PHP_SELF'].
'" method="POST">';
438 print
'<input type="hidden" name="token" value="'.newToken().
'">';
439 print
'<table class="noborder centpercent">';
443 $fieldlist = explode(
',', $tabfield[$id]);
446 print
'<tr class="liste_titre">';
447 foreach ($fieldlist as $field => $value) {
448 if ($fieldlist[$field] ==
'date_creation') {
454 $valuetoshow = ucfirst($fieldlist[$field]);
455 $valuetoshow = $langs->trans($valuetoshow);
457 if ($fieldlist[$field] ==
'lang') {
458 $valuetoshow = $langs->trans(
"Language");
460 if ($valuetoshow !=
'') {
461 print
'<td class="'.$align.
'">';
462 if (!empty($tabhelp[$id][$value]) && preg_match(
'/^http(s*):/i', $tabhelp[$id][$value])) {
463 print
'<a href="'.$tabhelp[$id][$value].
'" target="_blank" rel="noopener noreferrer">'.$valuetoshow.
' '.
img_help(1, $valuetoshow).
'</a>';
464 } elseif (!empty($tabhelp[$id][$value])) {
465 if ($value ==
'virtualhost') {
466 print
$form->textwithpicto($valuetoshow, $tabhelp[$id][$value], 1,
'help',
'', 0, 2,
'tooltipvirtual');
468 print
$form->textwithpicto($valuetoshow, $tabhelp[$id][$value]);
477 print
'<td colspan="4">';
482 print
'<tr class="oddeven">';
484 $obj =
new stdClass();
486 if (
GETPOST(
'actionadd',
'alpha')) {
487 foreach ($fieldlist as $key => $val) {
493 if (!isset($obj->position)) {
499 print
'<td colspan="3" class="right">';
500 if ($action !=
'edit') {
501 print
'<input type="submit" class="button button-add" name="actionadd" value="'.$langs->trans(
"Add").
'">';
512 $resql = $db->query($sql);
514 $num = $db->num_rows(
$resql);
519 print
'<form action="'.$_SERVER[
'PHP_SELF'].
'" method="POST">';
520 print
'<input type="hidden" name="token" value="'.newToken().
'">';
521 print
'<input type="hidden" name="page" value="'.$page.
'">';
522 print
'<input type="hidden" name="rowid" value="'.$rowid.
'">';
524 print
'<table class="noborder centpercent">';
527 print
'<tr class="liste_titre">';
528 foreach ($fieldlist as $field => $value) {
542 $valuetoshow = ucfirst($fieldlist[$field]);
543 $valuetoshow = $langs->trans($valuetoshow);
544 if ($fieldlist[$field] ==
'lang') {
545 $valuetoshow = $langs->trans(
"Language");
547 if ($fieldlist[$field] ==
'type') {
548 $valuetoshow = $langs->trans(
"Type");
550 if ($fieldlist[$field] ==
'code') {
551 $valuetoshow = $langs->trans(
"Code");
553 if ($fieldlist[$field] ==
'date_creation') {
554 $valuetoshow = $langs->trans(
"DateCreation");
559 print
getTitleFieldOfList($valuetoshow, 0, $_SERVER[
"PHP_SELF"], ($sortable ? $fieldlist[$field] :
''), ($page ?
'page='.$page.
'&' :
''),
"",
"align=".$align, $sortfield, $sortorder);
563 print
getTitleFieldOfList($langs->trans(
"Status"), 0, $_SERVER[
"PHP_SELF"],
"status", ($page ?
'page='.$page.
'&' :
''),
"",
'align="center"', $sortfield, $sortorder);
570 $obj = $db->fetch_object(
$resql);
572 print
'<tr class="oddeven" id="rowid-'.$obj->rowid.
'">';
573 if ($action ==
'edit' && ($rowid == (!empty($obj->rowid) ? $obj->rowid : $obj->code))) {
575 $parameters = array(
'fieldlist'=>$fieldlist,
'tabname'=>$tabname[$id]);
576 $reshook = $hookmanager->executeHooks(
'editWebsiteFieldlist', $parameters, $obj, $tmpaction);
577 $error = $hookmanager->error; $errors = $hookmanager->errors;
579 if (empty($reshook)) {
583 print
'<td colspan="3" class="right"><a name="'.(!empty($obj->rowid) ? $obj->rowid : $obj->code).
'"> </a><input type="submit" class="button button-edit" name="actionmodify" value="'.$langs->trans(
"Modify").
'">';
584 print
' <input type="submit" class="button button-cancel" name="actioncancel" value="'.$langs->trans(
"Cancel").
'"></td>';
587 $parameters = array(
'fieldlist'=>$fieldlist,
'tabname'=>$tabname[$id]);
588 $reshook = $hookmanager->executeHooks(
'viewWebsiteFieldlist', $parameters, $obj, $tmpaction);
590 $error = $hookmanager->error; $errors = $hookmanager->errors;
592 if (empty($reshook)) {
593 foreach ($fieldlist as $field => $value) {
596 $fieldname = $fieldlist[$field];
597 $valuetoshow = $obj->$fieldname;
601 print
'<td align="'.$align.
'">'.$valuetoshow.
'</td>';
607 $iserasable = 1; $isdisable = 1;
612 $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) :
'').
'&';
615 print
'<td align="center" class="nowrap">';
616 print
'<a class="reposition" href="'.$url.
'action='.$acts[($obj->status ? 1 : 0)].
'">'.$actl[($obj->status ? 1 : 0)].
'</a>';
620 print
'<td align="center"><a class="reposition editfielda" href="'.$url.
'action=edit&token='.
newToken().
'">'.
img_edit().
'</a></td>';
624 print
'<td align="center"><a class="reposition" href="'.$url.
'action=delete&token='.
newToken().
'">'.
img_delete().
'</a></td>';
626 print
'<td class="center">'.img_delete($langs->trans(
"DisableSiteFirst"),
'class="opacitymedium"').
'</td>';
661 global $conf, $langs, $db;
664 global $elementList, $sourceList, $localtax_typeList;
669 foreach ($fieldlist as $field => $value) {
670 $fieldname = $fieldlist[$field];
672 if ($fieldlist[$field] ==
'lang') {
674 print $formadmin->select_language($conf->global->MAIN_LANG_DEFAULT,
'lang');
676 } elseif ($fieldlist[$field] ==
'code' && isset($obj->$fieldname)) {
677 print
'<td><input type="text" class="flat" value="'.(!empty($obj->$fieldname) ? $obj->$fieldname :
'').
'" size="10" name="'.$fieldlist[$field].
'"></td>';
679 if ($fieldlist[$field] ==
'date_creation') {
685 if ($fieldlist[$field] ==
'code') {
688 if ($fieldlist[$field] ==
'position') {
691 if ($fieldlist[$field] ==
'libelle') {
692 $size =
'size="32" ';
694 if ($fieldlist[$field] ==
'tracking') {
695 $size =
'size="92" ';
697 if ($fieldlist[$field] ==
'sortorder') {
700 print
'<input type="text" '.$size.
' class="flat" value="'.(isset($obj->$fieldname) ? $obj->$fieldname :
'').
'" name="'.$fieldlist[$field].
'">';