调度范围变更 __Dd0Db4TlFENjzphGkaK __KWBHssgPtqkxvqhTKlW true 5 false false false false false relatedForm month normal false 0 false public = '"+format(startTime,"yyyy-MM-dd HH:mm:ss")+"' "; } if(isNotNull(endTime)){ whereStr += " and item_created_time <= '"+format(endTime,"yyyy-MM-dd HH:mm:ss")+"' "; } if(isNotNull(updateStartTime)){ whereStr += " and item_approved_time >= '"+format(updateStartTime,"yyyy-MM-dd HH:mm:ss")+"' "; } if(isNotNull(updateEndTime)){ whereStr += " and item_approved_time <= '"+format(updateEndTime,"yyyy-MM-dd HH:mm:ss")+"' "; } var sql = "select a.id,a.formid,a.applicationid,a.id as item_id,"+ "a.domainid,"+ "item_name,"+//产品名称 "item_number,"+//调度账号编号 "case item_status when 0 then '正常' when 1 then '过期' end as item_status ,"+//账号状态 "item_end_time,"+//到期时间 "item_ip,"+//新调度IP "item_service_scope,"+//新调度范围 "item_created_time,"+//申请时间 "item_approved_time,"+//变更时间 "item_device_pk_id,"+//调度设备id //"case item_approver_status when item_approver_status='0' then '申请中' when item_approver_status='1' then '已变更' when item_approver_status='2' then '拒绝' end as item_approver_status ,"+//申请状态 "item_approver_status,"+ "item_approved_note "+//拒绝原因 " from tlk_device_desk_request a join tlk_device b on a.item_device_pk_id = b.item_pk_id where 1=1 "; sql+=whereStr+" order by item_created_time desc "; println(sql); return sql; })()]]> [] 1 02 0 0