SELECT MAIN182.FLOW_NUM AS 流程编号, HR.LASTNAME AS 申请人, MAIN182.CREATE_DATE AS 创建日期, DEP.DEPARTMENTNAME AS 部门名称, MAIN182.COOP_NAME AS 表彰方, MAIN182.COOP_TEL AS 联系方式, MAIN182.REWARD_DESC_MAIN AS 表彰奖项内容, SW_1.SELECTNAME AS 奖励对象, DT1182.REWARD_DESC_DT AS 对象描述, DT1182.REWARD_GOODS AS 奖励物品, SW_2.SELECTNAME AS 奖励证明, DT1182.REWARD_AMOUNTS AS 奖励金额, DT1182.RETURN_AMOUNTS AS 公司返还金额, DT1182.REMARK AS 备注, WREQ.STATUS AS 流程状态FROM FORMTABLE_MAIN_182 MAIN182 INNER JOIN FORMTABLE_MAIN_182_DT1 DT1182 ON MAIN182.ID = DT1182.MAINID INNER JOIN HRMRESOURCE HR ON MAIN182.APPLICANT = HR.ID INNER JOIN HRMDEPARTMENT DEP ON MAIN182.DEPARTMENT = DEP.ID INNER JOIN ( SELECT WORKFLOW_SELECTITEM.SELECTVALUE, WORKFLOW_SELECTITEM.SELECTNAME FROM WORKFLOW_SELECTITEM WHERE WORKFLOW_SELECTITEM.FIELDID = 16914 ) SW_1 ON SW_1.SELECTVALUE = DT1182.REWARD_TYPE INNER JOIN ( SELECT WORKFLOW_SELECTITEM.SELECTVALUE, WORKFLOW_SELECTITEM.SELECTNAME FROM WORKFLOW_SELECTITEM WHERE WORKFLOW_SELECTITEM.FIELDID = 16916 ) SW_2 ON SW_2.SELECTVALUE = DT1182.REWARD_TYPE INNER JOIN WORKFLOW_REQUESTBASE WREQ ON MAIN182.REQUESTID = WREQ.REQUESTIDWHERE 1 = 1AND MAIN182.CREATE_DATE >='${GET_CALDAY}' --创建时间1AND MAIN182.CREATE_DATE <='${GET_CALDAY_TO}' --创建时间2 ${GET_ZICZS0000}--创建部门${GET_BZF} --表彰方${GET_JLDX} --奖励对象${GET_JLZM} --奖励证明
