FrameBeurk File
Fmbk/Module/Rhum/Section/modeleSection.php
<?php //FrameBeurk V0.65 Copyright ToolOscope 2016. Licence CeCILL-C.
function Rhum_queryToutesSections() {
return array('SELECT' => array('S.IdSection', 'S.Section',
'S.NbrSujets', 'S.NbrSujetsArchives',
'U.IdUser', 'U.User',
'H.TsAction', 'S.TsMajElements',
'S.IdEtat', 'S.Donnees',
'S.Import'),
'FROM' => 'Rhum_Section AS S '
. 'LEFT JOIN Beurk_Historique AS H ON H.IdNoeud = S.IdSection AND H.NoVersion = 1 '
. 'LEFT JOIN Uzers_User AS U ON U.IdUser = H.IdUser ');
}
function Rhum_querySection($IdSection) {
$tabQuery = Rhum_queryToutesSections();
$tabQuery['WHERE'] = "S.IdSection = '$IdSection'";
return Uzers_ajoutePermissionQUERY($tabQuery);
}
function Rhum_querySectionsForum() {
$tabQuery = Rhum_queryToutesSections();
$tabQuery['ORDER BY'] = 'S.NoOrdre';
return Uzers_ajoutePermissionQUERY($tabQuery);
}
// fonction appelée par la fonction de recherche commune
function Rhum_queryRechercheSection($TsCREMin, $TsCREMax, $MotCle, $Createur) {
$tabQuery['SELECT'] = array("'Section'", 'S.IdSection', 'S.Section', 'U.IdUser', 'U.User', 'H.TsAction', 'S.NbrSujets', 'S.NbrSujetsArchives', 'S.Donnees', '0');
$tabQuery['FROM'] = 'Rhum_Section AS S '
. 'LEFT JOIN Beurk_Historique AS H ON H.IdNoeud = S.IdSection AND H.NoVersion = 1 '
. 'LEFT JOIN Uzers_User AS U ON U.IdUser = H.IdUser ';
$tabQuery['WHERE'] = '';
if ($MotCle != '') {
$tabQuery['SELECT']['score'] = "MATCH(S.Section, S.Donnees) AGAINST ('$MotCle')";
$tabQuery['WHERE'] = db_AND($tabQuery['WHERE'], "MATCH(S.Section, S.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'][] = 'S.IdEtat';
return Uzers_ajoutePermissionQUERY($tabQuery);
}