function addLog($type, $description, $idcible = '')
{
if ($description != "Configuration|cron" and $description != "Importation") {
$date = new clDate();
$data['idapplication'] = IDAPPLICATION;
if (isset($session)) {
$data['iduser'] = $this->xham->user->getLogin();
} elseif (is_object($this->xham) && is_object($this->xham->user)) {
$data['iduser'] = $this->xham->user->getLogin();
} else {
$data['iduser'] = $_SESSION['informations']['iduser'] ? $_SESSION['informations']['iduser'] : "******";
}
$data['idcible'] = $idcible;
// print $this->logSup ;
$data['type'] = $type;
$data['ip'] = $_SERVER['REMOTE_ADDR'];
$data['date'] = $date->getDatetime();
$data['description'] = $description;
$finTemps = XhamTools::temps();
$tpPage = $finTemps - $this->xham->debTemps;
$data['tempsPage'] = $tpPage;
$data['tempsSQL'] = $this->xham->tpRequetes;
$data['nombreSQL'] = $this->xham->nbRequetes + 1;
// Appel de la classe Requete.
$req = new XhamRequete(BASEXHAM, TABLELOGS, $data);
// Exécution de la requete.
$res = $req->addRecord();
// print affTab ( $res ) ;
// Limitation du nombre de lignes dans la table logs... Désactivé, mais fonctionne parfaitement.
//$mini = $res['cur_id'] - 150 ;
//$res = $requete->delRecord ( "idlog<=$mini" ) ;
}
}
function addTodo()
{
if ($this->xham->user->getLogin() != 'Invité') {
if ($_POST['Nom']) {
$data['idApplication'] = IDAPPLICATION;
$data['idUser'] = $this->xham->user->getLogin();
$data['date'] = date('Y-m-d H:i:s');
if ($_POST['dateLimite']) {
$date = new clDate($_POST['dateLimite']);
$data['dateLimite'] = $date->getDatetime();
}
$data['nom'] = utf8_decode($_POST['Nom']);
$data['categorie'] = utf8_decode($_POST['CategorieA']);
$data['importance'] = $_POST['Importance'];
$data['etat'] = 'afaire';
$data['public'] = $_POST['Public'];
$req = new XhamRequete(BASEXHAM, 'todo', $data, MYSQL_HOST, MYSQL_USER, MYSQL_PASS);
$req->addRecord();
} else {
$af = '<span class="erreur">Vous devez choisir un nom pour la tâche.</span>';
}
//$af = affTab ( $data ) ;
} else {
$af = '<span class="erreur">Vous n\'avez pas le droit d\'utiliser ces fonctions.</span>';
}
if ($this->ajax) {
$this->af .= $af;
} else {
return $af;
}
}
function checkDroit($droit, $description)
{
// Récupération de tous les droits existants.
$param['cw'] = "WHERE libelle='{$droit}' AND idapplication='" . IDAPPLICATION . "'";
$restous = $this->xham->Execute("Fichier", "getDroitsTous", $param, "ResultQuery");
if (!$restous['INDIC_SVC'][2]) {
$param2['idgroupe'] = 0;
$param2['idapplication'] = IDAPPLICATION;
$param2['libelle'] = $droit;
$param2['descriptiondroit'] = addslashes($description);
$requete = new XhamRequete(BASEXHAM, TABLEDROITS, $param2);
$sql = $requete->addRecord();
}
}
function ajouterGroupes()
{
// On vérifie qu'un tableau a bien été transmis.
if (is_array($_POST['groupesdispos'])) {
// Parcours de ce tableau.
while (list($key, $val) = each($_POST['groupesdispos'])) {
$param[cw] = "WHERE idutilisateur=" . $_POST['iduser'] . " AND idgroupe={$val}";
$res = $this->xham->Execute("Fichier", "getGroupesUtilisateur", $param, "ResultQuery");
if (!$res[INDIC_SVC][2]) {
// On récupère les informations de ce droit.
$data[idgroupe] = $val;
$data[idutilisateur] = $_POST['iduser'];
$requete = new XhamRequete(BASEXHAM, TABLERELUG, $data);
$requete->addRecord();
}
}
}
}
function addNewDroit()
{
if ($this->xham->getDroit("Configuration_Droits", "a")) {
$param['cw'] = "WHERE idapplication='" . IDAPPLICATION . "' AND libelle='" . $_POST['libelle'] . "'";
$res = $this->xham->Execute("Fichier", "getDroitsTous", $param, "ResultQuery");
if ($res['INDIC_SVC'][2]) {
$this->erreurs .= "Ce libellé est déjà utilisé. La création est annulée.<br/>";
} elseif (!$_POST['libelle']) {
$this->erreurs .= "Le libellé ne peut pas être vide. La création est annulée.<br/>";
} else {
$data['idapplication'] = IDAPPLICATION;
$data['libelle'] = stripslashes($_POST['libelle']);
$data['descriptiondroit'] = stripslashes($_POST['description']);
$data['idgroupe'] = 0;
$requete = new XhamRequete(BASEXHAM, TABLEDROITS, $data);
$sql = $requete->addRecord();
if (!isset($sql[1]) or !$sql[1]) {
$this->infos .= "Le droit '" . stripslashes($_POST['libelle']) . "' a été créé.<br>";
}
}
}
}
public function addGen($param)
{
$requete = new XhamRequete($this->getBDD(), $this->nomTable, $param, $this->getHost(), $this->getUser(), $this->getPass());
$sql = $requete->addRecord();
$this->id = $sql['cur_id'];
}
function addItem($nomListe)
{
// On vérifie qu'un item ne porte pas déjà ce nom.
$param['cw'] = "WHERE nomitem='" . addslashes(stripslashes($_POST['nomItemF'])) . "' AND nomliste='" . addslashes(stripslashes($nomListe)) . "'";
$res = $this->xham->Execute("Fichier", "getListesItems", $param, "ResultQuery");
// On signale l'erreur si le nom est déjà pris.
if ($res['INDIC_SVC'][2] > 0) {
$this->erreurs .= "Dans la liste \"{$nomListe}\", un item portant ce nom (\"" . $_POST['nomItemF'] . "\") existe déjà. La création est annulée.";
} else {
// Nouveau nom correct.
if (eregi("[0-9a-zA-Z]", $_POST['nomItemF'])) {
if ($this->xham->getOption($nomListe . " Id") and !eregi("[0-9a-zA-Z]", $_POST['libreF'])) {
$this->erreurs .= "L'identifiant est un champ obligatoire.";
} else {
// On positionne correctement le nouvel item et on déplace les autres.
if ($this->xham->getOption(stripslashes($nomListe)) != "Manuel") {
$rang = 1;
} else {
$param['cw'] = "WHERE iditem='" . $_POST['placerF'] . "' and nomliste='" . addslashes(stripslashes($nomListe)) . "'";
$res2 = $this->xham->Execute("Fichier", "getListesItems", $param, "ResultQuery");
$rang = (isset($res2['rang'][0]) ? $res2['rang'][0] : 0) + 1;
}
$param['cw'] = "WHERE rang>='{$rang}' AND nomliste='" . addslashes($nomListe) . "'";
$res = $this->xham->Execute("Fichier", "getListesItems", $param, "ResultQuery");
for ($i = 0; isset($res['iditem'][$i]); $i++) {
$data2['rang'] = $res['rang'][$i] + 1;
$requete = new XhamRequete(BASEXHAM, "listes", $data2);
$requete->updRecord("iditem='" . $res['iditem'][$i] . "'");
}
// Insertion du nouveau item.
$data['categorie'] = "ListesGenerales";
$data['nomliste'] = $nomListe;
$data['nomitem'] = $_POST['nomItemF'];
$data['rang'] = $rang;
$data['valide'] = 1;
$data['localisation'] = isset($_POST['typeF']) ? $_POST['typeF'] : '';
$data['libre'] = isset($_POST['libreF']) ? $_POST['libreF'] : '';
$data['idapplication'] = IDAPPLICATION;
$requete = new XhamRequete(BASEXHAM, "listes", $data);
$requete->addRecord();
// Message d'information.
$this->infos .= "L'item \"" . $_POST['nomItemF'] . "\" a été ajouté dans la liste \"" . stripslashes($nomListe) . "\".";
}
} else {
$this->erreurs .= "Le nom choisi ne doit pas être vide.";
}
}
}
function setNew($user, $clesession)
{
$date = new clDate();
$data['idapplication'] = IDAPPLICATION;
$data['nombre'] = "1";
$data['localisation'] = $this->xham->genNaviFull();
$data['uid'] = $user->getLogin();
$data['type'] = $user->getType();
$data['ip'] = $_SERVER['REMOTE_ADDR'];
$data['date'] = $date->getDatetime();
$data['last'] = $date->getDatetime();
$data['idsession'] = $clesession;
$data['navigateur'] = $user->getNavigateur();
if (is_array($user->getFonctions())) {
$data['fonctions'] = implode('|', $user->getFonctions());
} else {
$data['fonctions'] = $user->getFonctions();
}
if (is_array($user->getServices())) {
$data['equipes'] = implode('|', $user->getServices());
} else {
$data['equipes'] = "";
}
$data['organisations'] = $user->getOrgs();
// Appel de la classe Requete.
$requete = new XhamRequete(BASEXHAM, TABLESACTU, $data);
// Exécution de la requete.
$res = $requete->addRecord();
}
function checkOptionListe($option, $complexe = '')
{
$param['cw'] = "WHERE libelle='" . addslashes(stripslashes($option)) . "' AND idapplication=" . IDAPPLICATION;
$res = $this->xham->Execute("Fichier", "getOptions", $param, "ResultQuery");
if (!$res['INDIC_SVC'][2]) {
if ($complexe) {
$data['libelle'] = $option;
$data['description'] = "Classement de la liste '{$option}'.";
$data['type'] = "combobox";
$data['choix'] = "Manuel|Alphabétique|Alphabétique inversé";
$data['valeur'] = "Manuel";
$data['categorie'] = $option;
$data['idapplication'] = IDAPPLICATION;
$req = new XhamRequete(BASEXHAM, TABLEOPTS, $data);
$ris = $req->addRecord();
$data['libelle'] = "Catégories " . $option;
$data['description'] = "Classement de la liste des catégories de '{$option}'.";
$data['type'] = "combobox";
$data['choix'] = "Manuel|Alphabétique|Alphabétique inversé";
$data['valeur'] = "Manuel";
$data['categorie'] = $option;
$data['idapplication'] = IDAPPLICATION;
$req = new XhamRequete(BASEXHAM, TABLEOPTS, $data);
$ris = $req->addRecord();
$data['libelle'] = "Lignes " . $option;
$data['description'] = "Nombre de lignes dans les listes de gestion de '{$option}'.";
$data['type'] = "combobox";
$data['choix'] = "5|10|15|20|25|30";
$data['valeur'] = "15";
$data['categorie'] = $option;
$data['idapplication'] = IDAPPLICATION;
$req = new XhamRequete(BASEXHAM, TABLEOPTS, $data);
$ris = $req->addRecord();
} else {
switch ($option) {
case 'LignesParListe':
$data['libelle'] = "LignesParListe";
$data['description'] = "Nombre de lignes par liste dans la partie administration.";
$data['type'] = "combobox";
$data['choix'] = "3|4|5|6|7|8|9";
$data['valeur'] = "8";
$data['categorie'] = "Listes Générales";
$data['idapplication'] = IDAPPLICATION;
$req = new XhamRequete(BASEXHAM, TABLEOPTS, $data);
$ris = $req->addRecord();
break;
case 'ListesParLigne':
$data['libelle'] = "ListesParLigne";
$data['description'] = "Nombre de listes par ligne dans la partie administration.";
$data['type'] = "combobox";
$data['choix'] = "3|4|5";
$data['valeur'] = "4";
$data['categorie'] = "Listes Générales";
$data['idapplication'] = IDAPPLICATION;
$req = new XhamRequete(BASEXHAM, TABLEOPTS, $data);
$ris = $req->addRecord();
break;
default:
$data['libelle'] = $option;
$data['description'] = "Classement de la liste des '{$option}'.";
$data['type'] = "combobox";
$data['choix'] = "Manuel|Alphabétique|Alphabétique inversé";
$data['valeur'] = "Manuel";
$data['categorie'] = "Listes Générales";
$data['idapplication'] = IDAPPLICATION;
$req = new XhamRequete(BASEXHAM, TABLEOPTS, $data);
$ris = $req->addRecord();
$data['libelle'] = $option . " Id";
$data['description'] = "Gestion d'un code rattaché aux items de la liste '{$option}'.";
$data['type'] = "bool";
$data['choix'] = "";
$data['valeur'] = "0";
$data['categorie'] = "Listes Générales";
$data['idapplication'] = IDAPPLICATION;
$req = new XhamRequete(BASEXHAM, TABLEOPTS, $data);
$ris = $req->addRecord();
break;
}
}
}
}
function addNewOption()
{
$data['libelle'] = stripslashes($_POST['libelle']);
$data['description'] = stripslashes($_POST['description']);
$data['type'] = $_POST['type'];
$data['choix'] = isset($_POST['choix']) ? stripslashes($_POST['choix']) : '';
$data['categorie'] = $_POST['nouvelle'] ? stripslashes($_POST['nouvelle']) : stripslashes($_POST['categorie']);
$data['idapplication'] = IDAPPLICATION;
$data['administrateur'] = (isset($_POST['administrateur']) and $_POST['administrateur']) ? 1 : 0;
$req = new XhamRequete(BASEXHAM, TABLEOPTS, $data);
$ris = $req->addRecord();
}
function addGroupe()
{
// Récupération de la liste des groupes.
$param['cw'] = "WHERE nomgroupe=\"" . $_POST['newgroupe'] . "\"";
$res = $this->xham->Execute("Fichier", "getGroupes", $param, "ResultQuery");
if ($res['INDIC_SVC'][2]) {
$this->erreurs .= "Le groupe \"" . stripslashes($_POST['newgroupe']) . "\" existe déjà, la création est annulée.";
} else {
$data['nomgroupe'] = $_POST['newgroupe'];
// Préparation de la requête.
$requete = new XhamRequete(BASEXHAM, "groupes", $data);
// Exécution de la requête.
$res = $requete->addRecord();
}
}
function addNewMenu()
{
// Cas d'un sous-menu.
if ($_POST['type']) {
// Calcul du rang.
$param['cw'] = "WHERE menuparent='" . $_POST['type'] . "' AND idapplication=" . IDAPPLICATION;
$ras = $this->xham->Execute("Fichier", "getMenus", $param, "ResultQuery");
$data['rang'] = $ras['INDIC_SVC'][2] + 1;
// Calcul de la clé totale.
$param['cw'] = "WHERE idunique='" . $_POST['type'] . "' AND idapplication=" . IDAPPLICATION;
$rus = $this->xham->Execute("Fichier", "getMenus", $param, "ResultQuery");
$data['cletotale'] = $rus['cle'][0] . "|" . $_POST['cle'];
// Cas d'un menu.
} else {
// Calcul du rang.
$param['cw'] = "WHERE type='menu'" . " AND idapplication=" . IDAPPLICATION;
$ras = $this->xham->Execute("Fichier", "getMenus", $param, "ResultQuery");
$data['rang'] = $ras['INDIC_SVC'][2] + 1;
// Calcul de la clé.
$data['cletotale'] = $_POST['cle'];
}
// Préparation des informations du nouveau menu/sous-menu.
$data['libelle'] = stripslashes($_POST['libelle']);
do {
$idUnique = $this->genIdentifiantUnique();
$param['cw'] = "WHERE idunique='{$idUnique}'";
$ras = $this->xham->Execute("Fichier", "getMenus", $param, "ResultQuery");
} while ($ras['INDIC_SVC'][2]);
$data['idunique'] = $idUnique;
$data['type'] = $_POST['type'] ? "item" : "menu";
$data['menuparent'] = $_POST['type'];
$data['cle'] = stripslashes($_POST['cle']);
$data['noption'] = $_POST['option'];
$data['valeur'] = isset($_POST['valeur']) ? $_POST['valeur'] : '';
$data['droit'] = $_POST['droit'];
$data['etat'] = $_POST['etat'];
$data['classe'] = $_POST['classe'];
$data['arguments'] = isset($_POST['arguments']) ? stripslashes($_POST['arguments']) : '';
$data['code'] = isset($_POST['code']) ? stripslashes($_POST['code']) : '';
$data['idapplication'] = IDAPPLICATION;
// Insertion du nouvel enregistrement.
$req = new XhamRequete(BASEXHAM, TABLENAVI, $data);
$ris = $req->addRecord();
}
