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(); }