${if(sql("FRDemo","select count(*) from `res_hours_report_this` a
where a.per_id = '"+人员id+
"' and a.year='"+year_code+
"' and a.week='"+week_code+"'",1,1)=0,
"select a.pro_name
,a.pro_id
,next_task_name as task_name
,next_work_content as work_content
,next_plan_completion_ratio as plan_completion_ratio
,'' as actual_completion_ratio
,next_risk_problem as risk_problem
,'' as work_date
,'' as work_hours
,a.year
,a.week
,a.pro_status
,a.pro_sub_status
,a.per_id
-- ,'1' as ststus
from res_hours_report_next a
where a.per_id = '"+人员id+
"' and a.year='"+year_code+
"' and a.week='"+week_code+"'",
"SELECT a.pro_name
,a.pro_id
,this_task_name as task_name
,this_work_content as work_content
,this_plan_completion_ratio as plan_completion_ratio
,this_actual_completion_ratio as actual_completion_ratio
,this_risk_problem as risk_problem
,a.work_date
,a.work_hours
,a.year
,a.week
,pro_status
,pro_sub_status
,a.per_id
FROM `res_hours_report_this` a
where a.per_id ='" +人员id+
"' and year='"+year_code+
"' and week='"+week_code+"'")}
1min目标场景问卷
立即参与
