/**
* On récupère les droits d'accès de l'utilisateur sur l'intranet
* @param int $paramIdUser
* @param int $paramIdFtaRole
* @return array
*/
public static function checkIdIntranetActionsByRoleANDSiteFromUser($paramIdUser, $paramIdFtaRole)
{
if ($paramIdFtaRole != "0") {
$arrayIdIntranetActionsParent = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT DISTINCT ' . IntranetActionsModel::TABLENAME . '.' . IntranetActionsModel::FIELDNAME_PARENT_INTRANET_ACTIONS . ' FROM ' . self::TABLENAME . ', ' . FtaActionRoleModel::TABLENAME . ', ' . IntranetActionsModel::TABLENAME . ' WHERE ' . FtaActionRoleModel::TABLENAME . '.' . FtaActionRoleModel::FIELDNAME_ID_INTRANET_ACTIONS . ' = ' . self::TABLENAME . '.' . self::FIELDNAME_ID_INTRANET_ACTIONS . ' AND ' . FtaActionRoleModel::TABLENAME . '.' . FtaActionRoleModel::FIELDNAME_ID_FTA_ROLE . '=' . $paramIdFtaRole . ' AND ' . self::FIELDNAME_ID_USER . '=' . $paramIdUser . ' AND ' . self::FIELDNAME_NIVEAU_INTRANET_DROITS_ACCES . ' =' . IntranetNiveauAccesModel::NIVEAU_GENERIC_TRUE . ' AND ' . IntranetActionsModel::TABLENAME . '.' . IntranetActionsModel::KEYNAME . ' = ' . self::TABLENAME . '.' . self::FIELDNAME_ID_INTRANET_ACTIONS);
} else {
$arrayIdIntranetActionsParent = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT DISTINCT ' . IntranetActionsModel::TABLENAME . '.' . IntranetActionsModel::FIELDNAME_PARENT_INTRANET_ACTIONS . ' FROM ' . self::TABLENAME . ', ' . IntranetActionsModel::TABLENAME . ' WHERE ' . self::FIELDNAME_ID_USER . '=' . $paramIdUser . ' AND ' . self::FIELDNAME_NIVEAU_INTRANET_DROITS_ACCES . ' =' . IntranetNiveauAccesModel::NIVEAU_GENERIC_TRUE . ' AND ' . self::FIELDNAME_ID_INTRANET_MODULES . ' =' . IntranetModulesModel::ID_MODULES_FTA . ' AND ' . IntranetActionsModel::TABLENAME . '.' . IntranetActionsModel::KEYNAME . ' = ' . self::TABLENAME . '.' . self::FIELDNAME_ID_INTRANET_ACTIONS);
}
if ($arrayIdIntranetActionsParent) {
foreach ($arrayIdIntranetActionsParent as $rowsIdIntranetActionsParent) {
$IdIntranetActionsParent[] = $rowsIdIntranetActionsParent[IntranetActionsModel::FIELDNAME_PARENT_INTRANET_ACTIONS];
}
$arrayIdIntranetActions = DatabaseOperation::convertSqlStatementWithoutKeyToArray('SELECT DISTINCT ' . IntranetActionsModel::TABLENAME . '.' . IntranetActionsModel::KEYNAME . ' FROM ' . IntranetActionsModel::TABLENAME . ' WHERE ( 0 ' . IntranetActionsModel::addIdIntranetActionParent($IdIntranetActionsParent) . ' )');
if ($arrayIdIntranetActions) {
foreach ($arrayIdIntranetActions as $rowsIdIntranetActions) {
$IdIntranetActions[] = $rowsIdIntranetActions[self::FIELDNAME_ID_INTRANET_ACTIONS];
}
} else {
$IdIntranetActions = array("0");
}
} else {
$IdIntranetActions = array("0");
}
return $IdIntranetActions;
}
