未录入保安员 __qOsfBAAjuOZK4QFNUVQ __kzH6OnLCHexonYGHSNf true 5 false false false false true relatedForm month normal false 0 __8ZbU1bZkQpNXojoHDBb true public = '"+starttime1+"'" } if(isNotNull(deadline)){ whereStr += "and inspect_time <= '"+deadline1+"'" } var sql = "select concat(pk_id,'--__gKCGQxCm7FvcO7bngVr') as id,'"+getDomainid()+"' as domainid,' __gKCGQxCm7FvcO7bngVr' as formid,employee_name as item_employee_name,inspect_time as item_inspect_time ,inspector_name as item_inspector_name,"+ " case company_process_status when '-1' then '合格，无需企业处理' when '0' then '未处理' when '1' then '已处理' end as item_company_process_status,"+ "case supervise_process_status when '0' then '待复核' when '1' then '复核不通过' when '2' then '复核通过' end as item_supervise_process_status "+ " from supervision_reports where organization_id = '"+domainid+"' "+ whereStr; println("sql========"+sql); return sql; })()]]> [] 1 02 0 0