督导督办 - 查找督导督办记录列表 __68zGjFNYxfzExGBiSBB __68zGjFNYxfzExGBiSBB published __EgMT4C5EMdmkrwem6Lb UTF-8 post /supervision/report/list json = '" + inspectStartTime + "'"; } if(isNotNull(inspectEndTime)){ sql += " and date(inspect_time) <= '" + inspectEndTime + "'"; } //如果是未录入的保安员/驻勤点，此处查询条件是公司处理状态.0,未处理。1，已处理；如果是无组织，则查询条件是监管处理状态。0，未处理，2已处理 if(isNotNull(processStatus)){ if(type == '0' || type == "2"){ sql += " and company_process_status = " + processStatus; }else if(type == '1' || type == "3"){ sql += " and supervise_process_status = " + processStatus; } } var pageIndex = parameters["pageIndex"]; var pageSize = parameters["pageSize"]; var limitFrom = (pageIndex - 1) * pageSize; sql += " order by inspect_time desc limit " + limitFrom + "," + pageSize; var data = queryByDSName(dsNames.DS_INSPECTION,sql); var result = new Packages.java.util.HashMap(); //result.put("sql", sql); result.put("data", data); return result; })()]]>