$onglet = $_GET['onglet']; $class = $onglet == 'fsd' ? 'edit' : 'fsd'; //------------------------------------------------------------------------------ PARMS. /*Droit sur les boutons de la dernière colonne*/ $typ_droit = 'd2'; $rubrique = $id_page; $droit = ref_droit($id_user, $typ_droit, $rubrique, $onglet); //------------------------------------------------------------------------------ CONNEXION SERVEUR PostgreSQL $db = sql_connect(SQL_base); if (!$db) { fatal_error("Impossible de se connecter au serveur PostgreSQL.", false); } //------------------------------------------------------------------------------ REF. ref_colonne_et_valeur($onglet); //------------------------------------------------------------------------------ FILTERS $filters = filter_column($aColumns[$onglet]); $sLimit = $filters['sLimit']; $sOrder = $filters['sOrder']; $sWhere = $filters['sWhere']; //------------------------------------------------------------------------------ QUERY $query = $query_liste[$_GET['onglet']] . $sWhere . " " . $sOrder . " " . $sLimit; // echo "<br>".$query; $result = pg_query($db, $query) or die("Erreur pgSQL : " . pg_result_error($result)); if (pg_num_rows($result)) { $aResultTotal = pg_result($result, 0, "total_count"); } else { $aResultTotal = 0; } $iTotal = $aResultTotal; $sOutput = '{'; $sOutput .= '"sEcho": ' . intval($_GET['sEcho']) . ', ';
//----------------------------------------------------------------------------- INIT. require_once "../../_INCLUDE/config_sql.inc.php"; require_once "../../_INCLUDE/fonctions.inc.php"; require_once "../../_INCLUDE/constants.inc.php"; include_once "commun.inc.php"; //------------------------------------------------------------------------------ VAR. // $niveau=$_SESSION['niveau']; $table = $id_page = "utilisateur"; $aColumns = array('id_user', 'prenom', 'nom', 'lib_cbn', 'email', 'tel_bur', 'niveau_lr', 'niveau_eee', 'niveau_catnat', 'niveau_refnat', 'niveau_lsi', 'niveau_fsd', 'ref_lr', 'ref_eee', 'ref_catnat', 'ref_refnat', 'ref_lsi', 'ref_fsd'); $sIndexColumn = "id_user"; $ouinon_txt = array("", "<b>X</b>"); //------------------------------------------------------------------------------ REF. global $aColumns, $ref, $champ_ref; ref_colonne_et_valeur($id_page); //------------------------------------------------------------------------------ MAIN $filters = filter_column($aColumns[$id_page]); $sLimit = $filters['sLimit']; $sOrder = $filters['sOrder']; $sWhere = $filters['sWhere']; //------------------------------------------------------------------------------ QUERY /*id_cbn du USER*/ $query = "SELECT id_cbn FROM applications.utilisateur WHERE id_user = '******'"; $result = pg_query($db, $query) or die("Erreur pgSQL : " . pg_result_error($result)); $row = pg_fetch_row($result); $id_cbn = $row[0]; if ($ref['all'] === 'f' and $niveau['all'] < 255) { $where1 = "WHERE id_cbn = {$id_cbn}"; } elseif ($ref['all'] === 't' and $niveau['all'] < 255) { $where1 = "WHERE id_cbn = {$id_cbn}"; } else { $where1 = "WHERE 1=1";
// Version 1.07 24/09/14 - MaJ columnFilter // //------------------------------------------------------------------------------// //------------------------------------------------------------------------------ INIT. include "commun.inc.php"; //------------------------------------------------------------------------------ VAR. //------------------------------------------------------------------------------ PARMS. //------------------------------------------------------------------------------ CONNEXION SERVEUR PostgreSQL $db = sql_connect(SQL_base); if (!$db) { fatal_error("Impossible de se connecter au serveur PostgreSQL.", false); } //------------------------------------------------------------------------------ REF. global $aColumns, $ref, $champ_ref; ref_colonne_et_valeur("droit_{$id_page}"); //------------------------------------------------------------------------------ MAIN $filters = filter_column($aColumns["droit_{$id_page}"]); $sLimit = $filters['sLimit']; $sOrder = $filters['sOrder']; $sWhere = $filters['sWhere']; //------------------------------------------------------------------------------ QUERY $query = $query_user . " " . $sWhere . " " . $sOrder . " " . $sLimit; // echo "<br>".$query; $result = pg_query($db, $query) or die("Erreur pgSQL : " . pg_result_error($result)); if (pg_num_rows($result)) { $aResultTotal = pg_result($result, 0, "total_count"); } else { $aResultTotal = 0; } $iTotal = $aResultTotal; $sOutput = '{'; $sOutput .= '"sEcho": ' . intval($_GET['sEcho']) . ', ';