Utilisation de la délégation dans le bureau

Les instructions dans les vues 0 : Filtre sur tous mes droits d'accès avec remplacement par like '%' pour Admin (Tous mes droits y compris par remplacement temporaire ou par délégation permanente ou rôle Admin) 1 : Filtre sur les remplacements temporaires (ne prend pas en compte mes droits ni mes délégations permanentes) 2 : Filtre sur tous mes droits d'accès sans prendre en compte le rôle Admin ( utilisé dans les vues du type 'bureau' ) 3 : Filtre sur les délégations permanentes (ne prend pas en compte mes droits ni mes remplacements temporaires) 4 : Filtre sur mes droits uniquement (ne prend pas en compte les remplacements temporaires ni les délégations permanentes)

Par exemple 2 est remplacé par : in ( liste des rôles de l'utilisateur connecté, ses services, son nom, ses délégations permanentes ou temporaires)

Exemple de vue :

-- Les documents en workflow
SELECT Distinct
D.id as id,
'Document en traitement' as Type_document,
D.reference as reference,
D.title as title,
D.version as version,
dbo.GetNameActivity(DP.current_activity)as GED_ETAPE,
1 as colTri
FROM DocumentProcessAccessRights DA,
Documents D ,
DocumentProcess DP,
FRM_Document FRM
WHERE
DA.resource_name {4}
AND DA.access_mode = 2
AND DP.process_status = 1
AND DP.id_document = D.id
AND DA.id_document = D.id
AND FRM.id_document = D.id
AND DA.resource_name not in
( select ph.performer from DocumentProcess dp
inner join ProcessInstances pi on pi.id_root_parent = dp.id_instance
inner join ProcessHistory ph on ph.id_instance = pi.id
where dp.id_document = D.id and pi.status = 4 and pi.component_type = 'Activity' )

UNION

-- Les documents sans workflow Elaboration
SELECT Distinct
D.id as id,
'Document en traitement' as Type_document,
D.reference as reference,
D.title as title,
D.version as version,
'Elaboration' as GED_ETAPE,
2 as colTri
FROM
Documents D,
DocumentProcessView DPV,
FRM_Document FRM
WHERE
D.created_by = @UserName
AND DPV.id = D.id
AND DPV.process_status = 0
AND FRM.id_document = D.id

UNION

-- Les AR à signer
SELECT Distinct
D.id as id,
'Document en traitement' as Type_document,
D.reference as reference,
D.title as title,
D.version as version,
'[Doit accuser réception]' as GED_ETAPE,
3 as colTri
FROM
DocumentDistributions DD,
Documents D,
FRM_Document FRM
Where
D.id = DD.id_document
AND D.id = FRM.id_document
AND DD.status = 2
AND DD.type = 0
AND DD.dn_name = @UserName
UNION
-- Les DM
SELECT Distinct
D.id as id,
'Demande de modification' as GED_TYPE,
FRM.ParentDocReference as reference,
D.title as title,
D.version as version,
'[Demande de Modification]' as GED_ETAPE,
4 as colTri
FROM
DocumentProcessAccessRights DA ,
Documents D ,
DocumentProcess DP,
FRM_Demande_de_modification FRM
INNER JOIN Documents DQ on DQ.id = FRM.ParentDocId
INNER JOIN FRM_Document DQP on DQP.id_document = DQ.id
WHERE
DA.resource_name {4}
AND DA.access_mode = 2
AND DP.process_status = 1
AND DP.id_document = D.id
AND DA.id_document = D.id
AND D.id = FRM.id_document
UNION
-- les DS
SELECT
D.id as id,
'Document de synthèse' as GED_TYPE,
FRM.ParentDocReference as reference,
D.title as title,
D.version as version,
'[Document de Synthèse]' as GED_ETAPE,
5 as colTri
FROM DocumentProcessAccessRights DA ,
Documents D ,
DocumentProcess DP,
FRM_Document_de_synthese FRM
INNER JOIN Documents DQ on DQ.id = FRM.ParentDocId
INNER JOIN FRM_Document DQP on DQP.id_document = DQ.id
WHERE DA.resource_name {4}
AND DA.access_mode = 2
AND DP.process_status = 1
AND DP.id_document = D.id
AND DA.id_document = D.id
AND D.id = FRM.id_document

UNION

-- Les documents en workflow par délégation ou remplacement
SELECT Distinct
D.id as id,
'Par Délégation : Document en traitement' as Type_document,
D.reference as reference,
D.title as title,
D.version as version,
dbo.GetNameActivity(DP.current_activity)as GED_ETAPE,
6 as colTri
FROM DocumentProcessAccessRights DA,
Documents D ,
DocumentProcess DP,
FRM_Document FRM
WHERE
(DA.resource_name {1} OR DA.resource_name {3})
AND DA.access_mode = 2
AND DP.process_status = 1
AND DP.id_document = D.id
AND DA.id_document = D.id
AND FRM.id_document = D.id
AND DA.resource_name not in
( select ph.performer from DocumentProcess dp
inner join ProcessInstances pi on pi.id_root_parent = dp.id_instance
inner join ProcessHistory ph on ph.id_instance = pi.id
where dp.id_document = D.id and pi.status = 4 and pi.component_type = 'Activity' )

UNION

-- Les documents sans workflow Elaboration
SELECT Distinct
D.id as id,
'Par Délégation : Document en traitement' as Type_document,
D.reference as reference,
D.title as title,
D.version as version,
'Elaboration' as GED_ETAPE,
7 as colTri
FROM
Documents D,
DocumentProcessView DPV,
FRM_Document FRM
WHERE
( D.created_by {1} OR D.created_by {3})
AND DPV.id = D.id
AND DPV.process_status = 0
AND FRM.id_document = D.id
UNION
-- Les DM
SELECT Distinct
D.id as id,
'Par Délégation : Demande de modification' as GED_TYPE,
FRM.ParentDocReference as reference,
D.title as title,
D.version as version,
'[Demande de Modification]' as GED_ETAPE,
8 as colTri
FROM
DocumentProcessAccessRights DA ,
Documents D ,
DocumentProcess DP,
FRM_Demande_de_modification FRM
INNER JOIN Documents DQ on DQ.id = FRM.ParentDocId
INNER JOIN FRM_Document DQP on DQP.id_document = DQ.id
WHERE
(DA.resource_name {1} OR DA.resource_name {3})
AND DA.access_mode = 2
AND DP.process_status = 1
AND DP.id_document = D.id
AND DA.id_document = D.id
AND D.id = FRM.id_document
UNION
-- les DS
SELECT
D.id as id,
'Par Délégation : Document de synthèse' as GED_TYPE,
FRM.ParentDocReference as reference,
D.title as title,
D.version as version,
'[Document de Synthèse]' as GED_ETAPE,
8 as colTri
FROM DocumentProcessAccessRights DA ,
Documents D ,
DocumentProcess DP,
FRM_Document_de_synthese FRM
INNER JOIN Documents DQ on DQ.id = FRM.ParentDocId
INNER JOIN FRM_Document DQP on DQP.id_document = DQ.id
WHERE
(DA.resource_name {1} OR DA.resource_name {3})
AND DA.access_mode = 2
AND DP.process_status = 1
AND DP.id_document = D.id
AND DA.id_document = D.id
AND D.id = FRM.id_document