setup.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2004-2017  Laurent Destailleur  <eldy@users.sourceforge.net>
 * Copyright (C) 2018-2024  Alexandre Spangaro   <alexandre@inovea-conseil.com>
 * Copyright (C) 2024       MDW                  <mdeweerd@users.noreply.github.com>
 * Copyright (C) 2024       Frédéric France      <frederic.france@free.fr>
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <https://www.gnu.org/licenses/>.
 */
 
// Load Dolibarr environment
require '../../main.inc.php';
require_once DOL_DOCUMENT_ROOT.'/core/lib/asset.lib.php';
require_once DOL_DOCUMENT_ROOT."/core/lib/admin.lib.php";
 
global $langs, $user;
 
// Load translation files required by the page
$langs->loadLangs(array("admin", "assets"));
 
// Access control
if (!$user->admin) {
  accessforbidden();
}
 
// Parameters
$action = GETPOST('action', 'aZ09');
$backtopage = GETPOST('backtopage', 'alpha');
 
$value = GETPOST('value', 'alpha');
$label = GETPOST('label', 'alpha');
$scandir = GETPOST('scan_dir', 'alpha');
$type = 'asset';
 
$arrayofparameters = array(
  'ASSET_ACCOUNTANCY_CATEGORY' => array('type' => 'accountancy_category', 'enabled' => 1),
  'ASSET_DEPRECIATION_DURATION_PER_YEAR' => array('type' => 'string', 'css' => 'minwidth200', 'enabled' => 1),
  //'ASSET_MYPARAM2'=>array('type'=>'textarea','enabled'=>1),
  //'ASSET_MYPARAM3'=>array('type'=>'category:'.Categorie::TYPE_CUSTOMER, 'enabled'=>1),
  //'ASSET_MYPARAM4'=>array('type'=>'emailtemplate:thirdparty', 'enabled'=>1),
  //'ASSET_MYPARAM5'=>array('type'=>'yesno', 'enabled'=>1),
  //'ASSET_MYPARAM5'=>array('type'=>'thirdparty_type', 'enabled'=>1),
  //'ASSET_MYPARAM6'=>array('type'=>'securekey', 'enabled'=>1),
  //'ASSET_MYPARAM7'=>array('type'=>'product', 'enabled'=>1),
);
 
$error = 0;
$setupnotempty = 0;
 
$dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
 
$moduledir = 'asset';
$myTmpObjects = array();
$myTmpObjects['asset'] = array('label' => 'Asset', 'includerefgeneration' => 1, 'includedocgeneration' => 0, 'class' => 'Asset');
 
$tmpobjectkey = GETPOST('object', 'aZ09');
if ($tmpobjectkey && !array_key_exists($tmpobjectkey, $myTmpObjects)) {
  accessforbidden('Bad value for object. Hack attempt ?');
}
 
 
/*
 * Actions
 */
 
include DOL_DOCUMENT_ROOT.'/core/actions_setmoduleoptions.inc.php';
 
if ($action == 'updateMask') {
  $maskconst = GETPOST('maskconst', 'alpha');
  $mask = GETPOST('mask', 'alpha');
 
  if ($maskconst && preg_match('/_MASK$/', $maskconst)) {
    $res = dolibarr_set_const($db, $maskconst, $mask, 'chaine', 0, '', $conf->entity);
    if (!($res > 0)) {
      $error++;
    }
  }
 
  if (!$error) {
    setEventMessages($langs->trans("SetupSaved"), null, 'mesgs');
  } else {
    setEventMessages($langs->trans("Error"), null, 'errors');
  }
} elseif ($action == 'specimen' && $tmpobjectkey) {
  $modele = GETPOST('module', 'alpha');
 
  $className = $myTmpObjects[$tmpobjectkey]['class'];
  $tmpobject = new $className($db);
  $tmpobject->initAsSpecimen();
 
  // Search template files
  $file = '';
  $classname = '';
  $dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
  foreach ($dirmodels as $reldir) {
    $file = dol_buildpath($reldir."core/modules/asset/doc/pdf_".$modele."_".strtolower($tmpobjectkey).".modules.php", 0);
    if (file_exists($file)) {
      $classname = "pdf_".$modele;
      break;
    }
  }
 
  if ($classname !== '') {
    require_once $file;
 
    $module = new $classname($db);
    '@phan-var-force ModelePDFAsset $module';
 
    if ($module->write_file($tmpobject, $langs) > 0) {
      header("Location: ".DOL_URL_ROOT."/document.php?modulepart=".strtolower($tmpobjectkey)."&file=SPECIMEN.pdf");
      return;
    } else {
      setEventMessages($module->error, null, 'errors');
      dol_syslog($module->error, LOG_ERR);
    }
  } else {
    setEventMessages($langs->trans("ErrorModuleNotFound"), null, 'errors');
    dol_syslog($langs->trans("ErrorModuleNotFound"), LOG_ERR);
  }
} elseif ($action == 'setmod') {
  // TODO Check if numbering module chosen can be activated by calling method canBeActivated
  if (!empty($tmpobjectkey)) {
    $constforval = 'ASSET_'.strtoupper($tmpobjectkey)."_ADDON";
    dolibarr_set_const($db, $constforval, $value, 'chaine', 0, '', $conf->entity);
  }
} elseif ($action == 'set') {
  // Activate a model
  $ret = addDocumentModel($value, $type, $label, $scandir);
} elseif ($action == 'del') {
  $ret = delDocumentModel($value, $type);
  if ($ret > 0) {
    if (!empty($tmpobjectkey)) {
      $constforval = 'ASSET_'.strtoupper($tmpobjectkey).'_ADDON_PDF';
      if (getDolGlobalString($constforval) == "$value") {
        dolibarr_del_const($db, $constforval, $conf->entity);
      }
    }
  }
} elseif ($action == 'setdoc') {
  // Set or unset default model
  if (!empty($tmpobjectkey)) {
    $constforval = 'ASSET_'.strtoupper($tmpobjectkey).'_ADDON_PDF';
    if (dolibarr_set_const($db, $constforval, $value, 'chaine', 0, '', $conf->entity)) {
      // The constant that was read before the new set
      // We therefore requires a variable to have a coherent view
      $conf->global->$constforval = $value;
    }
 
    // We disable/enable the document template (into llx_document_model table)
    $ret = delDocumentModel($value, $type);
    if ($ret > 0) {
      $ret = addDocumentModel($value, $type, $label, $scandir);
    }
  }
} elseif ($action == 'unsetdoc') {
  if (!empty($tmpobjectkey)) {
    $constforval = 'ASSET_'.strtoupper($tmpobjectkey).'_ADDON_PDF';
    dolibarr_del_const($db, $constforval, $conf->entity);
  }
}
 
 
 
/*
 * View
 */
 
$form = new Form($db);
 
$help_url = '';
$page_name = "AssetSetup";
 
llxHeader('', $langs->trans($page_name), $help_url);
 
// Subheader
$linkback = '<a href="'.($backtopage ? $backtopage : DOL_URL_ROOT.'/admin/modules.php?restore_lastsearch_values=1').'">'.$langs->trans("BackToModuleList").'</a>';
 
print load_fiche_titre($langs->trans($page_name), $linkback, 'title_setup');
 
// Configuration header
$head = assetAdminPrepareHead();
print dol_get_fiche_head($head, 'settings', $langs->trans($page_name), -1, "asset");
 
foreach ($myTmpObjects as $myTmpObjectKey => $myTmpObjectArray) {
  if ($myTmpObjectArray['includerefgeneration']) {
    /*
     * Assets Numbering model
     */
    $setupnotempty++;
 
    print load_fiche_titre($langs->trans("AssetNumberingModules", $myTmpObjectKey), '', '');
 
    print '<table class="noborder centpercent">';
    print '<tr class="liste_titre">';
    print '<td>'.$langs->trans("Name").'</td>';
    print '<td>'.$langs->trans("Description").'</td>';
    print '<td class="nowrap">'.$langs->trans("Example").'</td>';
    print '<td class="center" width="60">'.$langs->trans("Status").'</td>';
    print '<td class="center" width="16">'.$langs->trans("ShortInfo").'</td>';
    print '</tr>'."\n";
 
    clearstatcache();
 
    foreach ($dirmodels as $reldir) {
      $dir = dol_buildpath($reldir."core/modules/".$moduledir);
 
      if (is_dir($dir)) {
        $handle = opendir($dir);
        if (is_resource($handle)) {
          while (($file = readdir($handle)) !== false) {
            if (strpos($file, 'mod_'.strtolower($myTmpObjectKey).'_') === 0 && substr($file, dol_strlen($file) - 3, 3) == 'php') {
              $file = substr($file, 0, dol_strlen($file) - 4);
 
              require_once $dir.'/'.$file.'.php';
 
              $module = new $file($db);
              '@phan-var-force ModeleNumRefAsset $module';
 
              // Show modules according to feature level
              if ($module->version == 'development' && getDolGlobalInt('MAIN_FEATURES_LEVEL') < 2) {
                continue;
              }
              if ($module->version == 'experimental' && getDolGlobalInt('MAIN_FEATURES_LEVEL') < 1) {
                continue;
              }
 
              if ($module->isEnabled()) {
                dol_include_once('/'.$moduledir.'/class/'.strtolower($myTmpObjectKey).'.class.php');
 
                print '<tr class="oddeven"><td>'.$module->name."</td><td>\n";
                print $module->info($langs);
                print '</td>';
 
                // Show example of the numbering model
                print '<td class="nowrap">';
                $tmp = $module->getExample();
                if (preg_match('/^Error/', $tmp)) {
                  $langs->load("errors");
                  print '<div class="error">'.$langs->trans($tmp).'</div>';
                } elseif ($tmp == 'NotConfigured') {
                  print $langs->trans($tmp);
                } else {
                  print $tmp;
                }
                print '</td>'."\n";
 
                print '<td class="center">';
                $constforvar = 'ASSET_'.strtoupper($myTmpObjectKey).'_ADDON';
                if (getDolGlobalString($constforvar) == $file) {
                  print img_picto($langs->trans("Activated"), 'switch_on');
                } else {
                  print '<a href="'.$_SERVER["PHP_SELF"].'?action=setmod&token='.newToken().'&object='.strtolower($myTmpObjectKey).'&value='.urlencode($file).'">';
                  print img_picto($langs->trans("Disabled"), 'switch_off');
                  print '</a>';
                }
                print '</td>';
 
                $className = $myTmpObjectArray['class'];
                $mytmpinstance = new $className($db);
                $mytmpinstance->initAsSpecimen();
 
                // Info
                $htmltooltip = '';
                $htmltooltip .= ''.$langs->trans("Version").': <b>'.$module->getVersion().'</b><br>';
 
                $nextval = $module->getNextValue($mytmpinstance);
                if ("$nextval" != $langs->trans("NotAvailable")) {  // Keep " on nextval
                  $htmltooltip .= ''.$langs->trans("NextValue").': ';
                  if ($nextval) {
                    if (preg_match('/^Error/', $nextval) || $nextval == 'NotConfigured') {
                      $nextval = $langs->trans($nextval);
                    }
                    $htmltooltip .= $nextval.'<br>';
                  } else {
                    $htmltooltip .= $langs->trans($module->error).'<br>';
                  }
                }
 
                print '<td class="center">';
                print $form->textwithpicto('', $htmltooltip, 1, 0);
                print '</td>';
 
                print "</tr>\n";
              }
            }
          }
          closedir($handle);
        }
      }
    }
    print "</table><br>\n";
  }
 
  if ($myTmpObjectArray['includedocgeneration']) {
    /*
     * Document templates generators
     */
    $setupnotempty++;
    $type = strtolower($myTmpObjectKey);
 
    print load_fiche_titre($langs->trans("DocumentModules", $myTmpObjectKey), '', '');
 
    // Load array def with activated templates
    $def = array();
    $sql = "SELECT nom";
    $sql .= " FROM ".MAIN_DB_PREFIX."document_model";
    $sql .= " WHERE type = '".$db->escape($type)."'";
    $sql .= " AND entity = ".$conf->entity;
    $resql = $db->query($sql);
    if ($resql) {
      $i = 0;
      $num_rows = $db->num_rows($resql);
      while ($i < $num_rows) {
        $array = $db->fetch_array($resql);
        if (is_array($array)) {
          array_push($def, $array[0]);
        }
        $i++;
      }
    } else {
      dol_print_error($db);
    }
 
    print "<table class=\"noborder\" width=\"100%\">\n";
    print "<tr class=\"liste_titre\">\n";
    print '<td>'.$langs->trans("Name").'</td>';
    print '<td>'.$langs->trans("Description").'</td>';
    print '<td class="center" width="60">'.$langs->trans("Status")."</td>\n";
    print '<td class="center" width="60">'.$langs->trans("Default")."</td>\n";
    print '<td class="center" width="38">'.$langs->trans("ShortInfo").'</td>';
    print '<td class="center" width="38">'.$langs->trans("Preview").'</td>';
    print "</tr>\n";
 
    clearstatcache();
 
    foreach ($dirmodels as $reldir) {
      foreach (array('', '/doc') as $valdir) {
        $realpath = $reldir."core/modules/".$moduledir.$valdir;
        $dir = dol_buildpath($realpath);
 
        if (is_dir($dir)) {
          $handle = opendir($dir);
          if (is_resource($handle)) {
            $filelist = array();
            while (($file = readdir($handle)) !== false) {
              $filelist[] = $file;
            }
            closedir($handle);
            arsort($filelist);
 
            foreach ($filelist as $file) {
              if (preg_match('/\.modules\.php$/i', $file) && preg_match('/^(pdf_|doc_)/', $file)) {
                if (file_exists($dir.'/'.$file)) {
                  $name = substr($file, 4, dol_strlen($file) - 16);
                  $classname = substr($file, 0, dol_strlen($file) - 12);
 
                  require_once $dir.'/'.$file;
                  $module = new $classname($db);
                  '@phan-var-force ModelePDFAsset $module';
 
                  $modulequalified = 1;
                  if ($module->version == 'development' && getDolGlobalInt('MAIN_FEATURES_LEVEL') < 2) {
                    $modulequalified = 0;
                  }
                  if ($module->version == 'experimental' && getDolGlobalInt('MAIN_FEATURES_LEVEL') < 1) {
                    $modulequalified = 0;
                  }
 
                  if ($modulequalified) {
                    print '<tr class="oddeven"><td width="100">';
                    print(empty($module->name) ? $name : $module->name);
                    print "</td><td>\n";
                    if (method_exists($module, 'info')) {
                      print $module->info($langs);  // @phan-suppress-current-line PhanUndeclaredMethod
                    } else {
                      print $module->description;
                    }
                    print '</td>';
 
                    // Active
                    if (in_array($name, $def)) {
                      print '<td class="center">'."\n";
                      print '<a href="'.$_SERVER["PHP_SELF"].'?action=del&token='.newToken().'&value='.urlencode($name).'">';
                      print img_picto($langs->trans("Enabled"), 'switch_on');
                      print '</a>';
                      print '</td>';
                    } else {
                      print '<td class="center">'."\n";
                      print '<a href="'.$_SERVER["PHP_SELF"].'?action=set&token='.newToken().'&value='.urlencode($name).'&scan_dir='.urlencode($module->scandir).'&label='.urlencode($module->name).'">'.img_picto($langs->trans("Disabled"), 'switch_off').'</a>';
                      print "</td>";
                    }
 
                    // Default
                    print '<td class="center">';
                    $constforvar = 'ASSET_'.strtoupper($myTmpObjectKey).'_ADDON';
                    if (getDolGlobalString($constforvar) == $name) {
                      //print img_picto($langs->trans("Default"), 'on');
                      // Even if choice is the default value, we allow to disable it. Replace this with previous line if you need to disable unset
                      print '<a href="'.$_SERVER["PHP_SELF"].'?action=unsetdoc&token='.newToken().'&object='.urlencode(strtolower($myTmpObjectKey)).'&value='.urlencode($name).'&scan_dir='.urlencode($module->scandir).'&label='.urlencode($module->name).'&amp;type='.urlencode($type).'" alt="'.$langs->trans("Disable").'">'.img_picto($langs->trans("Enabled"), 'on').'</a>';
                    } else {
                      print '<a href="'.$_SERVER["PHP_SELF"].'?action=setdoc&token='.newToken().'&object='.urlencode(strtolower($myTmpObjectKey)).'&value='.urlencode($name).'&scan_dir='.urlencode($module->scandir).'&label='.urlencode($module->name).'" alt="'.$langs->trans("Default").'">'.img_picto($langs->trans("Disabled"), 'off').'</a>';
                    }
                    print '</td>';
 
                    // Info
                    $htmltooltip = ''.$langs->trans("Name").': '.$module->name;
                    $htmltooltip .= '<br>'.$langs->trans("Type").': '.($module->type ? $module->type : $langs->trans("Unknown"));
                    if ($module->type == 'pdf') {
                      $htmltooltip .= '<br>'.$langs->trans("Width").'/'.$langs->trans("Height").': '.$module->page_largeur.'/'.$module->page_hauteur;
                    }
                    $htmltooltip .= '<br>'.$langs->trans("Path").': '.preg_replace('/^\//', '', $realpath).'/'.$file;
 
                    $htmltooltip .= '<br><br><u>'.$langs->trans("FeaturesSupported").':</u>';
                    $htmltooltip .= '<br>'.$langs->trans("Logo").': '.yn($module->option_logo, 1, 1);
                    $htmltooltip .= '<br>'.$langs->trans("MultiLanguage").': '.yn($module->option_multilang, 1, 1);
 
                    print '<td class="center">';
                    print $form->textwithpicto('', $htmltooltip, 1, 0);
                    print '</td>';
 
                    // Preview
                    print '<td class="center">';
                    if ($module->type == 'pdf') {
                      print '<a href="'.$_SERVER["PHP_SELF"].'?action=specimen&module='.$name.'&object='.$myTmpObjectKey.'">'.img_object($langs->trans("Preview"), 'pdf').'</a>';
                    } else {
                      print img_object($langs->trans("PreviewNotAvailable"), 'generic');
                    }
                    print '</td>';
 
                    print "</tr>\n";
                  }
                }
              }
            }
          }
        }
      }
    }
 
    print '</table>';
  }
}
 
if ($action == 'edit') {
  print '<form method="POST" action="'.$_SERVER["PHP_SELF"].'">';
  print '<input type="hidden" name="token" value="'.newToken().'">';
  print '<input type="hidden" name="action" value="update">';
 
  print '<table class="noborder centpercent">';
  print '<tr class="liste_titre"><td class="titlefield">'.$langs->trans("Parameter").'</td><td>'.$langs->trans("Value").'</td></tr>';
 
  foreach ($arrayofparameters as $constname => $val) {
    if ($val['enabled'] == 1) {
      $setupnotempty++;
      print '<tr class="oddeven"><td>';
      $tooltiphelp = (($langs->trans($constname . 'Tooltip') != $constname . 'Tooltip') ? $langs->trans($constname . 'Tooltip') : '');
      print '<span id="helplink'.$constname.'" class="spanforparamtooltip">'.$form->textwithpicto($langs->trans($constname), $tooltiphelp, 1, 'info', '', 0, 3, 'tootips'.$constname).'</span>';
      print '</td><td>';
 
      if ($val['type'] == 'textarea') {
        print '<textarea class="flat" name="'.$constname.'" id="'.$constname.'" cols="50" rows="5" wrap="soft">' . "\n";
        print getDolGlobalString($constname);
        print "</textarea>\n";
      } elseif ($val['type'] == 'html') {
        require_once DOL_DOCUMENT_ROOT . '/core/class/doleditor.class.php';
        $doleditor = new DolEditor($constname, getDolGlobalString($constname), '', 160, 'dolibarr_notes', '', false, false, isModEnabled('fckeditor'), ROWS_5, '90%');
        $doleditor->Create();
      } elseif ($val['type'] == 'yesno') {
        print $form->selectyesno($constname, getDolGlobalString($constname), 1);
      } elseif (preg_match('/emailtemplate:/', $val['type'])) {
        include_once DOL_DOCUMENT_ROOT . '/core/class/html.formmail.class.php';
        $formmail = new FormMail($db);
 
        $tmp = explode(':', $val['type']);
        $nboftemplates = $formmail->fetchAllEMailTemplate($tmp[1], $user, null, 1); // We set lang=null to get in priority record with no lang
        //$arraydefaultmessage = $formmail->getEMailTemplate($db, $tmp[1], $user, null, 0, 1, '');
        $arrayofmessagename = array();
        if (is_array($formmail->lines_model)) {
          foreach ($formmail->lines_model as $modelmail) {
            //var_dump($modelmail);
            $moreonlabel = '';
            if (!empty($arrayofmessagename[$modelmail->label])) {
              $moreonlabel = ' <span class="opacitymedium">(' . $langs->trans("SeveralLangugeVariatFound") . ')</span>';
            }
            // The 'label' is the key that is unique if we exclude the language
            $arrayofmessagename[$modelmail->id] = $langs->trans(preg_replace('/\‍(|\‍)/', '', $modelmail->label)) . $moreonlabel;
          }
        }
        print $form->selectarray($constname, $arrayofmessagename, getDolGlobalString($constname), 'None', 0, 0, '', 0, 0, 0, '', '', 1);
      } elseif (preg_match('/category:/', $val['type'])) {
        require_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
        require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
        $formother = new FormOther($db);
 
        $tmp = explode(':', $val['type']);
        print img_picto('', 'category', 'class="pictofixedwidth"');
        print $formother->select_categories($tmp[1], getDolGlobalString($constname), $constname, 0, $langs->trans('CustomersProspectsCategoriesShort'));
      } elseif (preg_match('/thirdparty_type/', $val['type'])) {
        require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php';
        $formcompany = new FormCompany($db);
        print $formcompany->selectProspectCustomerType(getDolGlobalString($constname), $constname);
      } elseif ($val['type'] == 'securekey') {
        print '<input required="required" type="text" class="flat" id="'.$constname.'" name="'.$constname.'" value="'.(GETPOST($constname, 'alpha') ? GETPOST($constname, 'alpha') : getDolGlobalString($constname)).'" size="40">';
        if (!empty($conf->use_javascript_ajax)) {
          print '&nbsp;'.img_picto($langs->trans('Generate'), 'refresh', 'id="generate_token'.$constname.'" class="linkobject"');
        }
 
        // Add button to autosuggest a key
        include_once DOL_DOCUMENT_ROOT.'/core/lib/security2.lib.php';
        print dolJSToSetRandomPassword($constname, 'generate_token'.$constname);
      } elseif ($val['type'] == 'product') {
        if (isModEnabled("product") || isModEnabled("service")) {
          $selected = getDolGlobalString($constname);
          $form->select_produits($selected, $constname, '', 0);
        }
      } elseif ($val['type'] == 'accountancy_code') {
        $selected = getDolGlobalString($constname);
        if (isModEnabled('accounting')) {
          require_once DOL_DOCUMENT_ROOT . '/core/class/html.formaccounting.class.php';
          $formaccounting = new FormAccounting($db);
          print $formaccounting->select_account($selected, $constname, 1, array(), 1, 1, 'minwidth150 maxwidth300', 1);
        } else {
          print '<input name="' . $constname . '" class="maxwidth200" value="' . dol_escape_htmltag($selected) . '">';
        }
      } elseif ($val['type'] == 'accountancy_category') {
        $selected = getDolGlobalString($constname);
        if (isModEnabled('accounting')) {
          print '<input type="text" name="' . $constname . '" list="pcg_type_datalist" value="' . $selected . '">';
          // autosuggest from existing account types if found
          print '<datalist id="pcg_type_datalist">';
          require_once DOL_DOCUMENT_ROOT . '/accountancy/class/accountancysystem.class.php';
          $accountsystem = new AccountancySystem($db);
          $accountsystem->fetch(getDolGlobalInt('CHARTOFACCOUNTS'));
          $sql = 'SELECT DISTINCT pcg_type FROM ' . MAIN_DB_PREFIX . 'accounting_account';
          $sql .= " WHERE fk_pcg_version = '" . $db->escape($accountsystem->ref) . "'";
          $sql .= ' AND entity in ('.getEntity('accounting_account', 0).')';    // Always limit to current entity. No sharing in accountancy.
          $sql .= ' LIMIT 50000'; // just as a sanity check
          $resql = $db->query($sql);
          if ($resql) {
            while ($obj = $db->fetch_object($resql)) {
              print '<option value="' . dol_escape_htmltag($obj->pcg_type) . '">';
            }
          }
          print '</datalist>';
        } else {
          print '<input name="' . $constname . '" class="maxwidth200" value="' . dol_escape_htmltag($selected) . '">';
        }
      } else {
        print '<input name="'.$constname.'"  class="flat '.(empty($val['css']) ? 'minwidth200' : $val['css']).'" value="'.getDolGlobalString($constname).'">';
      }
      print '</td></tr>';
    }
  }
  print '</table>';
 
  print '<br><div class="center">';
  print '<input class="button button-save" type="submit" value="'.$langs->trans("Save").'">';
  print '</div>';
 
  print '</form>';
  print '<br>';
} else {
  if (!empty($arrayofparameters)) {
    print '<table class="noborder centpercent">';
    print '<tr class="liste_titre"><td class="titlefield">'.$langs->trans("Parameter").'</td><td>'.$langs->trans("Value").'</td></tr>';
 
    foreach ($arrayofparameters as $constname => $val) {
      if ($val['enabled'] == 1) {
        $setupnotempty++;
        print '<tr class="oddeven"><td>';
        $tooltiphelp = (($langs->trans($constname . 'Tooltip') != $constname . 'Tooltip') ? $langs->trans($constname . 'Tooltip') : '');
        print $form->textwithpicto($langs->trans($constname), $tooltiphelp);
        print '</td><td>';
 
        if ($val['type'] == 'textarea') {
          print dol_nl2br(getDolGlobalString($constname));
        } elseif ($val['type'] == 'html') {
          print getDolGlobalString($constname);
        } elseif ($val['type'] == 'yesno') {
          print ajax_constantonoff($constname);
        } elseif (preg_match('/emailtemplate:/', $val['type'])) {
          include_once DOL_DOCUMENT_ROOT . '/core/class/html.formmail.class.php';
          $formmail = new FormMail($db);
 
          $tmp = explode(':', $val['type']);
 
          $template = $formmail->getEMailTemplate($db, $tmp[1], $user, $langs, getDolGlobalString($constname));
          if ($template < 0) {
            setEventMessages(null, $formmail->errors, 'errors');
          }
          print $langs->trans($template->label);
        } elseif (preg_match('/category:/', $val['type'])) {
          $c = new Categorie($db);
          $result = $c->fetch(getDolGlobalInt($constname));
          if ($result < 0) {
            setEventMessages(null, $c->errors, 'errors');
          } elseif ($result > 0) {
            $ways = $c->print_all_ways(' &gt;&gt; ', 'none', 0, 1); // $ways[0] = "ccc2 >> ccc2a >> ccc2a1" with html formatted text
            $toprint = array();
            foreach ($ways as $way) {
              $toprint[] = '<li class="select2-search-choice-dolibarr noborderoncategories"' . ($c->color ? ' style="background: #' . $c->color . ';"' : ' style="background: #bbb"') . '>' . $way . '</li>';
            }
            print '<div class="select2-container-multi-dolibarr" style="width: 90%;"><ul class="select2-choices-dolibarr">' . implode(' ', $toprint) . '</ul></div>';
          }
        } elseif (preg_match('/thirdparty_type/', $val['type'])) {
          if (getDolGlobalInt($constname) == 2) {
            print $langs->trans("Prospect");
          } elseif (getDolGlobalInt($constname) == 3) {
            print $langs->trans("ProspectCustomer");
          } elseif (getDolGlobalInt($constname) == 1) {
            print $langs->trans("Customer");
          } elseif (getDolGlobalInt($constname) == 0) {
            print $langs->trans("NorProspectNorCustomer");
          }
        } elseif ($val['type'] == 'product') {
          $product = new Product($db);
          $resprod = $product->fetch(getDolGlobalInt($constname));
          if ($resprod > 0) {
            print $product->ref;
          } elseif ($resprod < 0) {
            setEventMessages(null, $object->errors, "errors");
          }
        } elseif ($val['type'] == 'accountancy_code') {
          if (isModEnabled('accounting')) {
            require_once DOL_DOCUMENT_ROOT . '/accountancy/class/accountingaccount.class.php';
            $accountingaccount = new AccountingAccount($db);
            $accountingaccount->fetch(0, getDolGlobalString($constname), 1);
 
            print $accountingaccount->getNomUrl(0, 1, 1, '', 1);
          } else {
            print getDolGlobalString($constname);
          }
        } else {
          print getDolGlobalString($constname);
        }
        print '</td></tr>';
      }
    }
 
    print '</table>';
 
    print '<div class="tabsAction">';
    print '<a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=edit&token='.newToken().'">'.$langs->trans("Modify").'</a>';
    print '</div>';
  } else {
    print '<br>'.$langs->trans("NothingToSetup");
  }
}
 
if (empty($setupnotempty)) {
  print '<br>'.$langs->trans("NothingToSetup");
}
 
// Page end
print dol_get_fiche_end();
 
llxFooter();
$db->close();