FrameBeurk File
Fmbk/Module/Uzers/PermissionPerimetre/modelePermissionPerimetre.php
<?php //FrameBeurk V0.65 Copyright ToolOscope 2016. Licence CeCILL-C.
function Uzers_queryTousPermissionPerimetres() {
return 'SELECT PO.IdPermissionPerimetre, PO.IdEntite, PO.PermisOuInterdit, U.IdUser, U.User, H.TsAction, Q.TsAction '
. 'FROM Uzers_PermissionPerimetre PO '
. 'LEFT JOIN Beurk_Historique AS H ON H.IdNoeud = PO.IdPermissionPerimetre AND H.NoVersion = 1 '
. 'LEFT JOIN Beurk_Historique AS Q ON Q.IdNoeud = PO.IdPermissionPerimetre AND Q.NoVersion = PO.NoVersion '
. 'LEFT JOIN Uzers_User AS U ON U.IdUser = H.IdUser ';
}
function Uzers_queryPerimetresPermission($IdPermission) {
return Uzers_queryTousPermissionPerimetres()
. "WHERE IdPermission = '$IdPermission' "
. "ORDER BY PO.IdPermissionPerimetre ASC";
}
function Uzers_queryDoublonPermissionPerimetres($IdPermission, $IdEntite, $IdPermissionPerimetre = '') {
return 'SELECT 1 FROM Uzers_PermissionPerimetre '
. "WHERE IdEntite = '$IdEntite' AND IdPermission = '$IdPermission' "
. (($IdPermissionPerimetre != '') ? "AND IdPermissionPerimetre <> '$IdPermissionPerimetre'" : '');
}
© 2010-2015 by ToolOscope SASU. © 2016-2018 by Arnaud De Rette. All rights reserved