1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
$q=$this->createQuery('s')
->select('s.id,u.id, c.id, f.id, f1.name as forma, f1.periodicite,
IF(
(CURRENT_DATE() <= TIMESTAMPADD(MONTH, f1.periodicite, max(fu.date)))
||
(f1.periodicite=0 && MAX(fu.date) IS NOT NULL),
0,
1
) as result,
MAX(fu.date) as maximum')
->leftJoin('s.classifications u')
->leftJoin('u.class c')
->leftJoin('c.list_formation f')
->leftJoin('f.formation f1')
->leftJoin('s.formations fu ON s.id=fu.user_id AND fu.formation_id=f1.id')
->having('s.id=?',$user_id)
->groupBy('s.id, u.id, c.id, f.id, f1.name')
->execute(array(), Doctrine::HYDRATE_ARRAY)
;
$data=$q; |
Partager