''
) AS demandtime,
COALESCE(do.needpurpose,
''
) AS needpurpose,
COALESCE(do.questiontype,
''
) AS questiontype,
COALESCE(do.questiongrade,
''
) AS questiongrade,
do.grademsg,
do.dept_name,
do.dept,
do.type,
COALESCE(DATE_FORMAT(do.schedule_month,
'%Y-%m-%d %H:%i:%s'
),
''
) AS schedule_month,
CASE
WHEN do.is_customized = 1 THEN
'是'
ELSE
'否'
END AS is_customized,
COALESCE(do.cloud_examiner,
''
) AS cloudExaminer,
COALESCE(DATE_FORMAT(do.cloud_gmt_examiner,
'%Y-%m-%d %H:%i:%s'
),
''
) AS cloud_gmt_examiner,
COALESCE(do.cloud_reviewer,
''
) AS cloud_reviewer,
COALESCE(DATE_FORMAT(do.cloud_gmt_reviewer,
'%Y-%m-%d %H:%i:%s'
),
''
) AS cloud_gmt_reviewer,
COALESCE(do.cloud_pm,
''
) AS cloud_pm,
COALESCE(DATE_FORMAT(do.cloud_gmt_pm,
'%Y-%m-%d %H:%i:%s'
),
''
) AS cloud_gmt_pm,
d1.dept_name AS firstDeptName,
d2.dept_name AS secondDeptName,
p.name AS project,
do.curator,
u3.nickname AS curatorName,
COALESCE(DATE_FORMAT(do.pm_start_time,
'%Y-%m-%d %H:%i:%s'
),
''
) AS pmStartTime,
TIME_FORMAT(TIMEDIFF(do.pm_end_time, do.pm_start_time),
'%H小时 %i分钟'
) AS communicateTime
FROM
demand_order
do
JOIN
users_user u ON do.actor_id = u.id
LEFT JOIN
department d1 ON u.firstDept = d1.wx_code
LEFT JOIN
department d2 ON u.secondDept = d2.wx_code
LEFT JOIN
users_user u2 ON do.product_manager = u2.id
LEFT JOIN
users_user u3 ON do.curator = u3.username
left join
project p on p.id = do.project
WHERE createdDate BETWEEN
'2025-03-29 00:00:00'
AND
'2025-04-28 23:59:59'
AND do.is_deleted=0;
