1 2 3
| public function findBYmois($month1,$month2){
return $this->findMany('SELECT sum(mensuelafd.enqueteseffectue) as enqueteseffectue,sum(mensuelafd.enquetesprevue) as enquetesprevue,sum(mensuelafd.enqueteencours) as enqueteencours,sum(mensuelafd.famillecz) as famillecz,sum(mensuelafd.accepteafd) as accepteafd,sum(mensuelafd.refuseafd) as refuseafd,sum(mensuelafd.reprisemec) as reprisemec,sum(mensuelafd.vadsuivie) as vadsuivie,sum(mensuelafd.vadferme) as vadferme,sum(mensuelafd.vadsortie) as vadsortie,sum(mensuelafd.totalvad) as totalvad,sum(mensuelafd.plusplus) as plusplus,sum(mensuelafd.plus) as plus,sum(mensuelafd.egaleplus) as egaleplus,sum(mensuelafd.egale) as egale,sum(mensuelafd.totalanalysable) as totalanalysable,sum(mensuelafd.mecmoins) as mecmoins,sum(mensuelafd.autrena) as autrena,sum(mensuelafd.totalna) as totalna,sum(mensuelafd.totalsortie) as totalsortie,sum(mensuelafd.precedentsuivie) as precedentsuivie,sum(mensuelafd.entredumois) as entredumois,sum(mensuelafd.sortiedumois) as sortiedumois,sum(mensuelafd.totalsuivie) as totalsuivie,sum(mensuelafd.totalsuiviefin) as totalsuiviefin,sum(mensuelafd.niveau1) as niveau1,sum(mensuelafd.niveau2) as niveau2,sum(mensuelafd.niveau3) as niveau3,sum(mensuelafd.niveau4) as niveau4,sum(mensuelafd.niveau5) as niveau5,sum(mensuelafd.niveau6) as niveau6,sum(mensuelafd.mecnondetermine) as mecnondetermine FROM mensuelafd,mois where datedubilan between datedubilan=:ParamRec AND datedubilan=:ParamRec2 GROUP BY yyyy mm',array('ParamRec'=>$month1,'ParamRec2'=>$month2));
} |