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
13 files
+ 122
17
Compare changes
  • Side-by-side
  • Inline
Files
13
@@ -17,4 +17,30 @@ tous les documents dont
# Bannette d'avis
# Bannette de visa/signature
\ No newline at end of file
## Avis séquentiels
### 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