FrameBeurk File
Fmbk/Module/Uzers/User/modeleUser.php
<?php //FrameBeurk V0.65 Copyright ToolOscope 2016. Licence CeCILL-C.
function Uzers_queryTousUsers() {
return array('SELECT' => array('U.IdUser', 'U.User',
'U.IdEtat', 'U.Alerte',
'U.IdStyle', 'U.adresseEmail',
'H.TsAction', 'Q.TsAction',
'U.NbrSujets', 'U.NbrCommentaires',
'U.Donnees'),
'FROM' => 'Uzers_User AS U '
. 'LEFT JOIN Beurk_Historique AS H ON H.IdNoeud = U.IdUser AND H.NoVersion = 1 '
. 'LEFT JOIN Beurk_Historique AS Q ON Q.IdNoeud = U.IdUser AND Q.NoVersion = U.NoVersion ');
}
function Uzers_queryUser($IdUser) {
$tabQuery = Uzers_queryTousUsers();
$tabQuery['WHERE'] = "U.IdUser = '$IdUser'";
return Uzers_ajoutePermissionQUERY($tabQuery);
}
function Uzers_queryListeUser() {
$tabQuery = Uzers_queryTousUsers();
$tabQuery['ORDER BY'] = 'U.User';
$tabQuery = Uzers_ajoutePermissionQUERY($tabQuery);
return Kom1_pagineRequete($tabQuery);
}
function Uzers_queryModereUser($topAActiver) {
$tabQuery = Uzers_queryTousUsers();
$tabQuery['WHERE'] = (($topAActiver) ? ("U.IdEtat = '" . Beurk_id('T') . "' ") : "U.Alerte = 'O' ");
$tabQuery['ORDER BY'] = 'U.User';
$tabQuery = Uzers_ajoutePermissionQUERY($tabQuery);
return Kom1_pagineRequete($tabQuery);
}
function Uzers_queryGroupesUser($IdUser) {
$tabQuery = array('SELECT' => array('UG.IdUserGroupe', 'UG.IdUser', "''", 'UG.IdGroupe', 'G.Groupe', 'H.TsAction', 'Q.TsAction', 'UG.IdEtat'),
'FROM' => 'Uzers_UserGroupe AS UG '
. 'LEFT JOIN Uzers_Groupe AS G ON UG.IdGroupe = G.IdGroupe '
. '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.IdUser = '$IdUser'",
'ORDER BY' => 'G.Groupe');
$tabQuery = Uzers_ajoutePermissionQUERY($tabQuery);
return Kom1_pagineRequete($tabQuery);
}
// fonction appelée par la fonction de recherche commune
function Uzers_queryRechercheUser($TsCREMin, $TsCREMax, $MotCle, $Createur) {
$tabQuery['SELECT'] = array("'User'", 'U.IdUser', 'U.User', '0', '0', 'H.TsAction', 'U.NbrSujets', 'U.NbrCommentaires', 'U.Donnees', '0');
$tabQuery['FROM'] = 'Uzers_User AS U '
. 'LEFT JOIN Beurk_Historique AS H ON H.IdNoeud = U.IdUser AND H.NoVersion = 1 ';
$tabQuery['WHERE'] = '';
if ($MotCle != '') {
$tabQuery['SELECT']['score'] = "MATCH(U.User, U.Donnees) AGAINST ('$MotCle')";
$tabQuery['WHERE'] = db_AND($tabQuery['WHERE'], "MATCH(U.User, U.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'][] = 'U.IdEtat';
return Uzers_ajoutePermissionQUERY($tabQuery);
}