1 2 3 4 5 6 7 8 9 10 11 12 13
| SELECT e.employe_id, e.nom, e.prenom,n.description,t.priorite, t.date_record as date_record,t.duree AS newduree,
tc.duree,tc.jour,td.tache_desc,t.tache_id,a.avancement_desc,IFNULL(t.duree,0) AS newduree
FROM tache t,note n,time_cart tc,tache_desc
td,avancement a,employe e
WHERE dossier_id = $dossier_id
AND WEEKOFYEAR(t.date_record) >= 0
AND WEEKOFYEAR(t.date_record) <= 0
AND n.tache_id = t.tache_id
AND tc.time_cart_id = t.time_cart_id
AND td.tache_desc_id = t.tache_desc_id
AND a.avancement_id = t.avancement_id
AND e.employe_id = t.employe_id
ORDER BY t.date_record |
Partager