Skip to content
Snippets Groups Projects

Mise à jour arborescence

Open Nathanaël TRAVIER requested to merge 2.0 into master
Compare and Show latest version
6 files
+ 72
28
Compare changes
  • Side-by-side
  • Inline
Files
6
@@ -18,18 +18,29 @@ tous les documents dont
# Bannette d'avis
## Avis séquentiels
### Avis séquentiel à donner
**Clause** :
status in ('EAVIS')
AND ((res_id, @user_id) IN (
SELECT res_id, item_id
FROM listinstance
WHERE difflist_type = 'AVIS_CIRCUIT'
AND process_date ISNULL
AND res_view_letterbox.res_id = res_id
ORDER BY listinstance_id asc limit 1))
**Clause** :
### Avis séquentiel à donner
**Clause** :
```status in ('EAVIS')``` document au statut EAVIS
```AND ((res_id, @user_id) IN (``` dont l'attributaire est
```SELECT res_id, item_id```
```FROM listinstance```
```WHERE difflist_type = 'AVIS_CIRCUIT'```
```AND process_date ISNULL```
```AND res_view_letterbox.res_id = res_id```
```ORDER BY listinstance_id asc limit 1```
**Utilité**
### Avis séquentiel en cours
```status='EAVIS'```
```AND dest_user=@user_id```
```AND ((```
```SELECT count(res_id)```
```FROM listinstance```
```WHERE res_view_letterbox.res_id = res_id```
```AND difflist_type = 'AVIS_CIRCUIT'```
```AND process_date is NULL) != 0)```
# Bannette de visa/signature
**Utilité** :
Loading