FrameBeurk File
Fmbk/Module/Uzers/PermissionAction/modelePermissionAction.php
<?php //FrameBeurk V0.65 Copyright ToolOscope 2016. Licence CeCILL-C.
function Uzers_queryTousPermissionActions() {
return 'SELECT PA.IdPermissionAction, PA.IdAction, T.Terminal, PA.IdEntite, U.IdUser, U.User, H.TsAction, Q.TsAction '
. 'FROM Uzers_PermissionAction PA '
. 'LEFT JOIN Beurk_Historique AS H ON H.IdNoeud = PA.IdPermissionAction AND H.NoVersion = 1 '
. 'LEFT JOIN Beurk_Historique AS Q ON Q.IdNoeud = PA.IdPermissionAction AND Q.NoVersion = PA.NoVersion '
. 'LEFT JOIN Beurk_Terminal AS T ON T.IdTerminal = PA.IdAction '
. 'LEFT JOIN Uzers_User AS U ON U.IdUser = H.IdUser ';
}
function Uzers_queryActionsPermission($IdPermission) {
return Uzers_queryTousPermissionActions()
. "WHERE IdPermission = '$IdPermission' "
. "ORDER BY T.Terminal ASC";
}
function Uzers_queryDoublonPermissionActions($IdPermission, $IdAction, $IdEntite, $IdPermissionAction = '') {
return 'SELECT 1 FROM Uzers_PermissionAction '
. "WHERE IdAction = '$IdAction' AND IdEntite = '$IdEntite' AND IdPermission = '$IdPermission' "
. (($IdPermissionAction != '') ? "AND IdPermissionAction <> '$IdPermissionAction'" : '');
}