驻勤点检查 - 驻勤点检查记录查询
__68zGjFNYxfzExGBiSBB
__68zGjFNYxfzExGBiSBB
published
__gn2gDsNOACBU1N20GmM
UTF-8
post
/inspect/station/reports/list
json
= '" + inspectStartTime + "'";
}
if(isNotNull(inspectEndTime)){
sql += " and date(inspect_time) <= '" + inspectEndTime + "'";
}
if(isNotNull(result)){
sql += " and result = " + result;
}
if(isNotNull(companyProcessStatus)){
sql += " and company_process_status = " + companyProcessStatus;
}
if(isNotNull(superviseProcessStatus)){
sql += " and supervise_process_status = " + superviseProcessStatus;
}
var pageIndex = parameters["pageIndex"];
var pageSize = parameters["pageSize"];
var limitFrom = (pageIndex - 1) * pageSize;
sql += " ORDER BY inspect_time desc limit " + limitFrom + "," + pageSize;
println("查找驻勤点检查记录sql======>" + sql);
var data = queryByDSName(dsNames.DS_INSPECTION,sql);
var result = new Packages.java.util.HashMap();
//result.put("sql", sql);
result.put("data", data);
return result;
})()]]>