SELECT DISTINCT wc.REQUESTID,
                hr.LASTNAME                                                AS 创建人,
                hs.LASTNAME                                                AS 节点操作者,
                (CASE LOGTYPE
                     WHEN 0 THEN "批准"
                     WHEN 1 THEN "保存"
                     WHEN 2 THEN "提交"
                     WHEN 3 THEN "退回"
                     WHEN 4 THEN "重新打开"
                     WHEN 5 THEN "删除"
                     WHEN 6 THEN "激活"
                     WHEN 7 THEN "转发"
                     WHEN 8 THEN "部分同意"
                     WHEN 9 THEN "批注"
                     WHEN 'e' THEN "强制归档"
                     WHEN 't' THEN "抄送"
                     WHEN 's' THEN "督办" END)                                  LOGTYPE,
                wn.NODENAME,
                wr.CREATEDATE                                              AS 创建日期,
                wc.RECEIVEDATE                                             AS 接收日期,
                wc.RECEIVETIME                                             AS 接收时间,
                wc.OPERATEDATE                                             AS 处理日期,
                wc.OPERATETIME                                             AS 处理时间,
                TIMESTAMPDIFF(MINUTE, CONCAT(wc.RECEIVEDATE, " ", wc.RECEIVETIME),
                              CONCAT(wc.OPERATEDATE, " ", wc.OPERATETIME)) AS "操作耗时(分钟)",
                wr.`STATUS`,
                wb.WORKFLOWNAME                                            AS 流程名称,
                REQUESTNAME                                                AS 流程标题,
                (CASE CURRENTNODETYPE
                     WHEN 1 THEN "提交"
                     WHEN 2 THEN "审批"
                     WHEN 3 THEN "归档"
                     WHEN 0
                         THEN "待提交" END)                                      CURRENTNODETYPEFROM workflow_requestbase wr INNER JOIN ( SELECT ID, LASTNAME FROM hrmresource WHERE SUBCOMPANYID1 = 159 ) hr
ON wr.CREATER = hr.ID LEFT JOIN workflow_currentoperator wc ON wc.REQUESTID = wr.REQUESTID LEFT JOIN hrmresource hs ON hs.ID = wc.USERID LEFT JOIN workflow_base wb ON wb.id = wc.WORKFLOWID LEFT JOIN workflow_nodebase wn ON wc.NODEID = wn.id LEFT JOIN workflow_requestlog rl ON wc.USERID = rl.OPERATOR AND wc.REQUESTID = rl.REQUESTID AND wc.NODEID = rl.NODEID
WHERE wr.CREATEDATE BETWEEN "2020-04-01" AND "2020-04-30"
ORDER BY REQUESTID