FrameBeurk File
Fmbk/Module/Uzers/Groupe/modeleGroupe.php
<?php //FrameBeurk V0.65 Copyright ToolOscope 2016. Licence CeCILL-C.
function Uzers_queryTousGroupes() {
return array('SELECT' => array('G.IdGroupe', 'G.Groupe',
'G.NbrUsers', 'G.NbrPermissions',
'U.IdUser', 'U.User',
'H.TsAction', 'Q.TsAction',
'G.IdEtat', 'G.Donnees'),
'FROM' => 'Uzers_Groupe AS G '
. 'LEFT JOIN Beurk_Historique AS H ON H.IdNoeud = G.IdGroupe AND H.NoVersion = 1 '
. 'LEFT JOIN Beurk_Historique AS Q ON Q.IdNoeud = G.IdGroupe AND Q.NoVersion = G.NoVersion '
. 'LEFT JOIN Uzers_User AS U ON U.IdUser = H.IdUser ');
}
function Uzers_queryGroupe($IdGroupe) {
$tabQuery = Uzers_queryTousGroupes();
$tabQuery['WHERE'] = "G.IdGroupe = '$IdGroupe'";
return Uzers_ajoutePermissionQUERY($tabQuery);
}
function Uzers_queryListeGroupe() {
$tabQuery = Uzers_queryTousGroupes();
$tabQuery['ORDER BY'] = 'G.Groupe';
$tabQuery = Uzers_ajoutePermissionQUERY($tabQuery);
return Kom1_pagineRequete($tabQuery);
}
function Uzers_queryUsersGroupe($IdGroupe) {
$tabQuery = array('SELECT' => array('UG.IdUserGroupe', 'UG.IdUser', 'U.User', 'UG.IdGroupe', "''", 'H.TsAction', 'Q.TsAction', 'UG.IdEtat'),
'FROM' => 'Uzers_UserGroupe AS UG '
. 'LEFT JOIN Uzers_User AS U ON UG.IdUser = U.IdUser '
. 'LEFT JOIN Beurk_Historique AS H ON H.IdNoeud = UG.IdUserGroupe AND H.NoVersion = 1 '
. 'LEFT JOIN Beurk_Historique AS Q ON Q.IdNoeud = UG.IdUserGroupe AND Q.NoVersion = UG.NoVersion ',
'WHERE' => "UG.IdGroupe = '$IdGroupe'",
'ORDER BY' => 'U.User');
$tabQuery = Uzers_ajoutePermissionQUERY($tabQuery);
return Kom1_pagineRequete($tabQuery);
}
function Uzers_queryPermissionsGroupe($IdGroupe) {
$tabQuery = array('SELECT' => array('GP.IdGroupePermission', 'GP.IdGroupe', "''", 'GP.IdPermission', 'P.Permission', 'H.TsAction', 'Q.TsAction', 'GP.IdEtat'),
'FROM' => 'Uzers_GroupePermission GP '
. 'LEFT JOIN Uzers_Permission P ON GP.IdPermission = P.IdPermission '
. 'LEFT JOIN Beurk_Historique AS H ON H.IdNoeud = GP.IdGroupePermission AND H.NoVersion = 1 '
. 'LEFT JOIN Beurk_Historique AS Q ON Q.IdNoeud = GP.IdGroupePermission AND Q.NoVersion = GP.NoVersion ',
'WHERE' => "GP.IdGroupe = '$IdGroupe'",
'ORDER BY' => 'GP.IdPermission ASC');
$tabQuery = Uzers_ajoutePermissionQUERY($tabQuery);
return Kom1_pagineRequete($tabQuery);
}
// fonction appelée par la fonction de recherche commune
function Uzers_queryRechercheGroupe($TsCREMin, $TsCREMax, $MotCle, $Createur) {
$tabQuery['SELECT'] = array("'Groupe'", 'G.IdGroupe', 'G.Groupe', 'U.IdUser', 'U.User', 'H.TsAction', 'G.NbrUsers', 'G.NbrPermissions', 'G.Donnees', '0');
$tabQuery['FROM'] = 'Uzers_Groupe AS G '
. 'LEFT JOIN Beurk_Historique AS H ON H.IdNoeud = G.IdGroupe AND H.NoVersion = 1 '
. 'LEFT JOIN Uzers_User AS U ON U.IdUser = H.IdUser ';
$tabQuery['WHERE'] = '';
if ($MotCle != '') {
$tabQuery['SELECT']['score'] = "MATCH(G.Groupe, G.Donnees) AGAINST ('$MotCle')";
$tabQuery['WHERE'] = db_AND($tabQuery['WHERE'], "MATCH(G.Groupe, G.Donnees) AGAINST ('$MotCle')");
} else
$tabQuery['SELECT']['score'] = '1'; // score
if ($TsCREMin != '' && $TsCREMax != '')
$tabQuery['WHERE'] = db_AND($tabQuery['WHERE'], "H.TsAction BETWEEN $TsCREMin AND $TsCREMax");
if ($Createur != '')
$tabQuery['WHERE'] = db_AND($tabQuery['WHERE'], "U.User = '$Createur'");
$tabQuery['SELECT'][] = "''"; // champs utile pour les permissions
$tabQuery['SELECT'][] = 'G.IdEtat';
return Uzers_ajoutePermissionQUERY($tabQuery);
}
