FrameBeurk File
Fmbk/Module/Dnlod/RessourceVersion/modeleRessourceVersion.php
<?php //FrameBeurk V0.65 Copyright ToolOscope 2016. Licence CeCILL-C.
function Dnlod_queryToutesVersionsRessources() {
return array('SELECT' => array( 'R.IdRessourceVersion', 'R.RessourceVersion',
'R.IdRessource',
'U.IdUser', 'U.User',
'H.TsAction', 'Q.TsAction',
'R.IdEtat', 'R.NbrDemandes',
'R.NbrTelecharges', 'R.Donnees',
'R.Import', 'R.TypeMime'),
'FROM' => 'Dnlod_RessourceVersion AS R '
. 'LEFT JOIN Beurk_Historique AS H ON H.IdNoeud = R.IdRessourceVersion AND H.NoVersion = 1 '
. 'LEFT JOIN Beurk_Historique AS Q ON Q.IdNoeud = R.IdRessourceVersion AND Q.NoVersion = R.NoVersion '
. 'LEFT JOIN Uzers_User AS U ON U.IdUser = H.IdUser ');
}
function Dnlod_queryVersionsRessource($IdRessource) {
$tabQuery = Dnlod_queryToutesVersionsRessources();
$tabQuery['WHERE'] = "R.IdRessource = '$IdRessource'";
$tabQuery['ORDER BY'] = 'R.RessourceVersion DESC';
return $tabQuery;
}
function Dnlod_queryRessourceVersion($IdRessourceVersion) {
$tabQuery = Dnlod_queryToutesVersionsRessources();
$tabQuery['WHERE'] = "R.IdRessourceVersion = '$IdRessourceVersion'";
return $tabQuery;
}