Cacher is the code snippet organizer for pro developers

SET @rdate=DATE_FORMAT(date_sub(NOW(), interval 1 day),'%Y-%m-%d');
select
vvtsm.`date`,
vvu.realname,
vvtsm.`consumed` as '工时',
vvtsm.`work` as '任务日报',
vvt.id as '任务ID',
vvt.name as '任务名称',
vvt.`status` as '任务状态',
vvt.`estimate` as '需求估时',
vvtsm.`left` as '剩余工时'
from `vvzt_user` vvu
left join `vvzt_task` vvt on vvt.`assignedTo` = vvu.`account` or vvt.`finishedBy` = vvu.`account`
left join `vvzt_taskestimate` vvtsm on vvt.id=vvtsm.task and vvtsm.date = @rdate
left join `vvzt_story` vvs on vvt.`story` = vvs.id
where
vvu.role like 'dev%'
and vvu.dept in (8)
and vvu.deleted='0'
and vvt.`parent` > 0
and (vvt.`finishedDate`='0000-00-00 00:00:00' or vvt.`finishedDate`>=@rdate)
and (vvtsm.`consumed`>0)
order by vvu.dept asc,vvu.account desc