{
// Check values
if (GETPOST('type')=='varchar' && GETPOST('size') > 255)
{
$error++;
$langs->load("errors");
$mesg=$langs->trans("ErrorSizeTooLongForVarcharType");
$action = 'create';
}
if (! $error)
{
// Type et taille non encore pris en compte => varchar(255)
if (isset($_POST["attrname"]) && preg_match("/^\w[a-zA-Z0-9-_]*$/",$_POST['attrname']))
{
$result=$extrafields->addExtraField($_POST['attrname'],$_POST['label'],$_POST['type'],$_POST['pos'],$_POST['size'],$elementtype);
if ($result > 0)
{
Header("Location: ".$_SERVER["PHP_SELF"]);
exit;
}
else
{
$error++;
$mesg=$extrafields->error;
}
}
else
{
$error++;
$langs->load("errors");
/**
* Function called when module is enabled.
* The init function add constants, boxes, permissions and menus (defined in constructor) into Dolibarr database.
* It also creates data directories
*
* @param string $options Options when enabling module ('', 'noboxes')
* @return int 1 if OK, 0 if KO
*/
function init($options = '')
{
$sql = array();
define('INC_FROM_DOLIBARR', true);
dol_include_once('/of/config.php');
dol_include_once('/of/script/create-maj-base.php');
$result = $this->_load_tables('/of/sql/');
dol_include_once('/core/class/extrafields.class.php');
$extrafields = new ExtraFields($this->db);
$res = $extrafields->addExtraField('fk_of', 'Ordre de Fabrication', 'sellist', 0, '', 'projet_task', 0, 0, '', serialize(array('options' => array('assetOf:numero:rowid' => null))));
$extrafields = new ExtraFields($this->db);
$res = $extrafields->addExtraField('fk_product', 'Produit à fabriquer', 'sellist', 0, '', 'projet_task', 0, 0, '', serialize(array('options' => array('product:label:rowid' => null))));
return $this->_init($sql, $options);
}
/**
* Function called when module is enabled.
* The init function add constants, boxes, permissions and menus (defined in constructor) into Dolibarr database.
* It also creates data directories
*
* @param string $options Options when enabling module ('', 'noboxes')
* @return int 1 if OK, 0 if KO
*/
function init($options = '')
{
$sql = array();
define('INC_FROM_DOLIBARR', true);
dol_include_once('/factor/config.php');
dol_include_once('/factor/script/create-maj-base.php');
dol_include_once('/core/class/extrafields.class.php');
$extrafields = new ExtraFields($this->db);
$res = $extrafields->addExtraField('fk_soc_factor', 'Fournisseur du factor', 'sellist', 0, '', 'societe', 0, 0, '', unserialize('a:1:{s:7:"options";a:1:{s:32:"societe:nom:rowid::fournisseur=1";N;}}'));
//Ne peut prendre de order by
$res = $extrafields->addExtraField('factor_suivi', 'Utiliser le factor', 'select', 0, '', 'societe', 0, 0, '', array("options" => array(2 => 'Non', 1 => 'Oui')));
$res = $extrafields->addExtraField('factor_depot', 'Déposé au factor', 'select', 0, '', 'facture', 0, 0, '', array("options" => array(2 => 'A déposer', 1 => 'Oui')));
$result = $this->_load_tables('/factor/sql/');
return $this->_init($sql, $options);
}
// Change this following line to use the correct relative path from htdocs (do not remove DOL_DOCUMENT_ROOT)
dol_include_once('/core/lib/admin.lib.php');
dol_include_once('/core/class/extrafields.class.php');
// Access control
if (!$user->admin) {
accessforbidden();
}
// Parameters
$action = GETPOST('action', 'alpha');
if ($action == 'save') {
foreach ($_REQUEST['TDivers'] as $name => $param) {
dolibarr_set_const($db, $name, $param);
if ($name == 'SCRUM_USE_PROJECT_PRIORITY' && $param == 1) {
$extrafields = new ExtraFields($db);
$default_value = array('options' => array(0 => $langs->trans('Normal'), 1 => $langs->trans('Important')));
$res = $extrafields->addExtraField('priority', 'Priorité', 'select', 1, 0, 'projet', false, false, '', serialize($default_value));
}
/*else if($name == 'SCRUM_GROUP_TASK_BY_PRODUCT' && $param == 1) {
$extrafields=new ExtraFields($db);
$res = $extrafields->addExtraField('grou', 'Priorité', 'select', 1, 0, 'projet', false, false, '', serialize( $default_value ) );
}*/
}
setEventMessage($langs->trans('RegisterSuccess'));
}
llxHeader('', 'Gestion de scrumboard, à propos', '');
$linkback = '<a href="' . DOL_URL_ROOT . '/admin/modules.php">' . $langs->trans("BackToModuleList") . '</a>';
print_fiche_titre('Scrumboard', $linkback, 'setup');
showParameters();
function showParameters()
{
global $db, $conf, $langs;
/**
* Function called when module is enabled.
* The init function add constants, boxes, permissions and menus (defined in constructor) into Dolibarr database.
* It also creates data directories
*
* @param string $options Options when enabling module ('', 'noboxes')
* @return int 1 if OK, 0 if KO
*/
function init($options = '')
{
global $db;
$sql = array();
define('INC_FROM_DOLIBARR', true);
dol_include_once('/propalautosend/config.php');
dol_include_once('/propalautosend/script/create-maj-base.php');
dol_include_once('/core/class/extrafields.class.php');
$result = $this->_load_tables('/propalautosend/sql/');
$e = new ExtraFields($db);
$e->addExtraField('date_relance', 'Date de relance', 'date', 0, '', 'propal');
return $this->_init($sql, $options);
}
if (!$user->admin) {
accessforbidden();
}
// Parameters
$action = GETPOST('action', 'alpha');
if (preg_match('/set_(.*)/', $action, $reg)) {
$code = $reg[1];
if (dolibarr_set_const($db, $code, GETPOST($code), 'chaine', 0, '', $conf->entity) > 0) {
if ($code == 'SCRUM_USE_PROJECT_PRIORITY') {
$extrafields = new ExtraFields($db);
$default_value = array('options' => array(0 => $langs->trans('Normal'), 1 => $langs->trans('Important')));
$res = $extrafields->addExtraField('priority', 'Priorité', 'select', 1, 0, 'projet', false, false, '', serialize($default_value));
} else {
if ($code == 'SCRUM_GROUP_TASK_BY_RAL' && GETPOST($code) == 1) {
$extrafields = new ExtraFields($db);
$res = $extrafields->addExtraField('fk_product_ral', 'RALLinkedToOrder', 'varchar', '', 255, 'projet_task');
}
}
/*else if($name == 'SCRUM_GROUP_TASK_BY_PRODUCT' && $param == 1) {
$extrafields=new ExtraFields($db);
$res = $extrafields->addExtraField('grou', 'Priorité', 'select', 1, 0, 'projet', false, false, '', serialize( $default_value ) );
}*/
setEventMessage($langs->trans('RegisterSuccess'));
header("Location: " . $_SERVER["PHP_SELF"]);
exit;
} else {
dol_print_error($db);
}
}
if (preg_match('/del_(.*)/', $action, $reg)) {
$code = $reg[1];
/**
* Function called when module is enabled.
* The init function add constants, boxes, permissions and menus (defined in constructor) into Dolibarr database.
* It also creates data directories
*
* @param string $options Options when enabling module ('', 'noboxes')
* @return int 1 if OK, 0 if KO
*/
function init($options = '')
{
$sql = array();
define('INC_FROM_DOLIBARR', true);
dol_include_once('/contratconcurrent/config.php');
dol_include_once('/contratconcurrent/script/create-maj-base.php');
dol_include_once('/core/class/extrafields.class.php');
$extrafields = new ExtraFields($this->db);
$res = $extrafields->addExtraField('concurrent', 'Contrat concurrent', 'select', 1, '', 'contrat', 0, 0, '', array("options" => array('non', 'oui')));
$result = $this->_load_tables('/contratconcurrent/sql/');
return $this->_init($sql, $options);
}
function create_extrafield($code, $label, $type, $elementtype, $options = array())
{
global $db;
$e = new ExtraFields($db);
$e->addExtraField($code, $label, $type, '', '', $elementtype, 0, 0, '', $options);
}
/**
* Function called when module is enabled.
* The init function add constants, boxes, permissions and menus (defined in constructor) into Dolibarr database.
* It also creates data directories
*
* @param string $options Options when enabling module ('', 'noboxes')
* @return int 1 if OK, 0 if KO
*/
function init($options = '')
{
$sql = array();
define('INC_FROM_DOLIBARR', true);
dol_include_once('/mandarin/config.php');
dol_include_once('/mandarin/script/create-maj-base.php');
$result = $this->_load_tables('/mandarin/sql/');
dol_include_once('/core/class/extrafields.class.php');
$extrafields = new ExtraFields($this->db);
$res = $extrafields->addExtraField('contrat', 'Contrat', 'varchar', 0, 150, 'user');
$extrafields = new ExtraFields($this->db);
$res = $extrafields->addExtraField('thm', 'THM', 'double', 0, '', 'user');
$extrafields = new ExtraFields($this->db);
$res = $extrafields->addExtraField('horaire', 'Horaire contractuel', 'varchar', 0, 150, 'user');
$extrafields = new ExtraFields($this->db);
$res = $extrafields->addExtraField('dds', 'Date de sortie', 'date', 0, 10, 'user');
return $this->_init($sql, $options);
}
/**
* Function called when module is enabled.
* The init function add constants, boxes, permissions and menus
* (defined in constructor) into Dolibarr database.
* It also creates data directories
*
* @param string $options Options when enabling module ('', 'noboxes')
* @return int 1 if OK, 0 if KO
*/
public function init($options = '')
{
global $db;
$sql = array();
$result = $this->loadTables();
$db->query("ALTER TABLE `" . MAIN_DB_PREFIX . "projet_task` \n\t\t\t\t\tADD `grid_col` FLOAT NOT NULL DEFAULT '0',\n\t\t\t\t\tADD `grid_row` FLOAT NOT NULL DEFAULT '999999'");
$db->query("ALTER TABLE `" . MAIN_DB_PREFIX . "projet_task`\n\t\t\t\t\tADD grid_height FLOAT NOT NULL DEFAULT 0");
$db->query('ALTER TABLE `' . MAIN_DB_PREFIX . 'projet_task`
ADD INDEX `grid_row_grid_col` (`grid_row`, `grid_col`)');
$db->query("ALTER TABLE " . MAIN_DB_PREFIX . "projet_task\n\t\t\t\tADD date_estimated_start DATETIME NOT NULL \n\t\t\t , ADD date_estimated_end DATETIME NOT NULL \n\t\t\t , ADD INDEX (date_estimated_start, date_estimated_end)");
dol_include_once('/core/class/extrafields.class.php');
$extrafields = new ExtraFields($this->db);
$res = $extrafields->addExtraField('color', 'Couleur du projet', 'varchar', 1, 8, 'projet', false, false, '');
$extrafields = new ExtraFields($this->db);
$res = $extrafields->addExtraField('grid_use', 'Afficher sur la grille de planning', 'boolean', 0, '', 'projet_task');
$extrafields = new ExtraFields($this->db);
$res = $extrafields->addExtraField('needed_ressource', 'nb ressources nécessaires', 'int', 0, '', 'projet_task');
return $this->_init($sql, $options);
}
/**
* Function called when module is enabled.
* The init function add constants, boxes, permissions and menus (defined in constructor) into Dolibarr database.
* It also creates data directories
*
* @param string $options Options when enabling module ('', 'noboxes')
* @return int 1 if OK, 0 if KO
*/
function init($options = '')
{
$sql = array();
define('INC_FROM_DOLIBARR', true);
dol_include_once('/facturecourrier/config.php');
dol_include_once('/facturecourrier/script/create-maj-base.php');
dol_include_once('/core/class/extrafields.class.php');
$extrafields = new ExtraFields($this->db);
$res = $extrafields->addExtraField('facture_papier', 'Facture par courrier', 'select', 0, '', 'societe', 0, 0, '', array("options" => array(1 => 'Non', 2 => 'Oui')));
$res = $extrafields->addExtraField('courrier_envoi', 'Facture envoyée par courrier', 'date', 0, '', 'facture', 0, 0, '');
$result = $this->_load_tables('/facturecourrier/sql/');
return $this->_init($sql, $options);
}
break;
case 'saveIDCategToExclude':
if (_saveConst($db, 'REMISE_ID_CATEG_TO_EXCLUDE', $_REQUEST['idcategtoexclude'])) {
setEventMessage($langs->trans('IDCategSaved'));
} else {
setEventMessage($langs->trans('IDCategNotSaved'), 'errors');
}
case 'save':
$const_name = array_keys($_REQUEST['TDivers'])[0];
$val = $conf->global->{$const_name};
$val = !$val;
if ($const_name === 'REMISE_USE_THIRDPARTY_DISCOUNT' && !empty($val)) {
dolibarr_set_const($db, 'REMISE_USE_THIRDPARTY_DISCOUNT', $val);
dolibarr_set_const($db, 'REMISE_USE_WEIGHT', !$val);
$e = new ExtraFields($db);
$e->addExtraField('remsup', 'Remise supplémentaire', 'double', '', '24,8', 'societe');
} elseif ($const_name === 'REMISE_USE_WEIGHT' && !empty($val)) {
dolibarr_set_const($db, 'REMISE_USE_WEIGHT', $val);
dolibarr_set_const($db, 'REMISE_USE_THIRDPARTY_DISCOUNT', !$val);
} else {
dolibarr_set_const($db, $const_name, $val);
}
default:
break;
}
/*
* View
*/
//print_r($TFraisDePort);
$page_name = "RemiseSetup";
llxHeader('', $langs->trans($page_name));
/**
* Function called when module is enabled.
* The init function add constants, boxes, permissions and menus
* (defined in constructor) into Dolibarr database.
* It also creates data directories
*
* @param string $options Options when enabling module ('', 'noboxes')
* @return int 1 if OK, 0 if KO
*/
public function init($options = '')
{
global $db, $conf;
$sql = array();
$result = $this->loadTables();
// Création extrafield pour choix si remise doit apparaitre sur doc.
dol_include_once('/core/class/extrafields.class.php');
//function addExtraField($attrname, $label, $type, $pos, $size, $elementtype, $unique=0, $required=0,$default_value='', $param=0)
$ext = new ExtraFields($db);
$res = $ext->addExtraField("use_remise", 'Automatisation des remises', 'select', 0, "", 'propal', 0, 0, '', array("options" => array("Oui" => "Oui", "Non" => "Non")));
$res = $ext->addExtraField("use_remise", 'Automatisation des remises', 'select', 0, "", 'commande', 0, 0, '', array("options" => array("Oui" => "Oui", "Non" => "Non")));
$res = $ext->addExtraField("use_remise", 'Automatisation des remises', 'select', 0, "", 'facture', 0, 0, '', array("options" => array("Oui" => "Oui", "Non" => "Non")));
define('INC_FROM_DOLIBARR', true);
dol_include_once('/remise/config.php');
dol_include_once('/remise/class/remise.class.php');
$PDOdb = new TPDOdb();
$o = new TRemise();
$o->init_db_by_vars($PDOdb);
if (!empty($conf->global->REMISE_WEIGHT_ARRAY)) {
$TRemise = unserialize($conf->global->REMISE_WEIGHT_ARRAY);
foreach ($TRemise as $remise) {
$o = new TRemise();
$o->palier = $remise['weight'];
$o->remise = $remise['remise'];
$o->zip = $remise['zip'];
$o->type = 'WEIGHT';
$o->save($PDOdb);
}
dolibarr_del_const($db, 'REMISE_WEIGHT_ARRAY');
}
if (!empty($conf->global->REMISE_ARRAY)) {
$TRemise = unserialize($conf->global->REMISE_ARRAY);
foreach ($TRemise as $palier => $remise) {
$o = new TRemise();
$o->palier = $palier;
$o->remise = $remise;
$o->type = 'AMOUNT';
$o->save($PDOdb);
}
dolibarr_del_const($db, 'REMISE_ARRAY');
}
return $this->_init($sql, $options);
}
