Пример #1
0
 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" ) ;
     }
 }
Пример #2
0
 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;
     }
 }
Пример #3
0
 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();
     }
 }
Пример #4
0
 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();
             }
         }
     }
 }
Пример #5
0
 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>";
             }
         }
     }
 }
Пример #6
0
 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'];
 }
Пример #7
0
 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.";
         }
     }
 }
Пример #8
0
 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();
 }
Пример #9
0
 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;
             }
         }
     }
 }
Пример #10
0
 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();
 }
Пример #11
0
 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();
     }
 }
Пример #12
0
 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();
 }