Discussion :

[Mada2018]

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
SELECT substr(c.code_activite,1,3)progrrmme, c.section_code, c.code_activite, c.intitule_activite,
  c.categorie_depense_code, c.montant_initiale, c.montant_libere, c.montant_engage,c.montant_delegue,
  (c.montant_engage+c.montant_delegue)Consomme,( c.montant_initiale- c.montant_libere)Bloqué,
   (c.montant_libere-(c.montant_engage+c.montant_delegue))Disponible,l.who_done, l.when_done, l.montant_disponible_cp, 
   l.montant_total_engagement_ttc, l.montant_total_liquidation_ttc
	FROM situation.cumuls_activite_ae c ,depense.v_liquidations l
	LEFT JOIN depense.v_liquidations l on  c.section_code=substr(l.liquidation,3,2)
	LEFT JOIN situation.cumuls_activite_ae c on l.categorie=c.categorie_depense_code
	where c.section_code='05' and  c.categorie_depense_code <>'2' and l.categorie <>'2' 
	 and date(l.when_done) BETWEEN '2021-01-01' and '2021-06-30'
	and l.who_done like 'zoumarou%'
	Group by substr(c.code_activite,1,3), c.section_code, c.code_activite, c.intitule_activite, c.categorie_depense_code,
	c.montant_initiale, c.montant_libere, c.montant_engage,    c.montant_delegue,l.who_done, l.when_done, 
	l.montant_disponible_cp, l.montant_total_engagement_ttc, l.montant_total_liquidation_ttc
	having  sum(c.montant_libere)>0
	order by substr(c.code_activite,1,3), c.section_code, c.code_activite, c.intitule_activite, c.categorie_depense_code,
	c.montant_initiale, c.montant_libere, c.montant_engage, c.montant_delegue,l.who_done, l.when_done, 
	l.montant_disponible_cp, l.montant_total_engagement_ttc, l.montant_total_liquidation_ttc