1 2 3 4 5 6 7 8 9 10 11 12 13
|
public function evolutionbilan($month1,$month2){
print "SELECT (MonthName(datedubilan)) as periode,Year(datedubilan)as annee,sum(mensuelafd.precedentsuivie) as precedentsuivie,sum(mensuelafd.enqueteseffectue) as enqueteseffectue,sum(mensuelafd.famillecz) as famillecz,sum(mensuelafd.refuseafd) as refuseafd,((sum(mensuelafd.refuseafd)) / (sum(mensuelafd.famillecz)) *100) as tauxderefus,sum(mensuelafd.entredumois) as entredumois,((sum(mensuelafd.precedentsuivie)) + (sum(mensuelafd.entredumois))) as nombretotalfamillessuivieperiode,sum(mensuelafd.totalsortie) as totalsortie,((sum(mensuelafd.precedentsuivie)) + (sum(mensuelafd.entredumois)) - (sum(mensuelafd.totalsortie))) as totalsuiviefin
FROM mensuelafd
GROUP BY Month( datedubilan),Year(datedubilan)
Order by Month( datedubilan),Year(datedubilan)
where (mensuelafd.datedubilan >= {D '$month1'} AND mensuelafd.datedubilan <= {D '$month2'})";
return $this->findManySimple("SELECT (MonthName(datedubilan)) as periode,Year(datedubilan)as annee,sum(mensuelafd.precedentsuivie) as precedentsuivie,sum(mensuelafd.enqueteseffectue) as enqueteseffectue,sum(mensuelafd.famillecz) as famillecz,sum(mensuelafd.refuseafd) as refuseafd,((sum(mensuelafd.refuseafd)) / (sum(mensuelafd.famillecz)) *100) as tauxderefus,sum(mensuelafd.entredumois) as entredumois,((sum(mensuelafd.precedentsuivie)) + (sum(mensuelafd.entredumois))) as nombretotalfamillessuivieperiode,sum(mensuelafd.totalsortie) as totalsortie,((sum(mensuelafd.precedentsuivie)) + (sum(mensuelafd.entredumois)) - (sum(mensuelafd.totalsortie))) as totalsuiviefin
FROM mensuelafd
GROUP BY Month( datedubilan),Year(datedubilan)
Order by Month( datedubilan),Year(datedubilan)
where (mensuelafd.datedubilan >= {D '$month1'} AND mensuelafd.datedubilan <= {D '$month2'})"); |
Partager