| | |
| | | |
| | | public class InspectionStaffData implements ReportExecute { |
| | | |
| | | public JSONObject hasInTd(JSONArray tds, Map<String, Object> dataObj) { |
| | | public JSONObject hasInTd(JSONArray tds, Map dataObj) { |
| | | |
| | | if (tds == null || tds.size() < 1) { |
| | | return null; |
| | |
| | | |
| | | } |
| | | |
| | | @Override |
| | | public JSONObject execute(JSONObject params, IQueryServiceDAO queryServiceDAOImpl) { |
| | | |
| | | JSONObject paramOut = new JSONObject(); |
| | |
| | | sql += "GROUP BY t.staff_name ,ipo.inspection_name"; |
| | | |
| | | |
| | | List<Map<String, Object>> datas = queryServiceDAOImpl.executeSql(sql, sqlParams.toArray()); |
| | | List datas = queryServiceDAOImpl.executeSql(sql, sqlParams.toArray()); |
| | | |
| | | if (datas == null || datas.size() < 1) { |
| | | paramOut.put("td", new JSONArray()); |
| | |
| | | |
| | | JSONArray tds = new JSONArray(); |
| | | JSONObject td = null; |
| | | for (Map<String, Object> dataObj : datas) { |
| | | for (int dataIndex = 0 ; dataIndex < datas.size() ; dataIndex ++ ){ |
| | | Map dataObj = (Map)datas.get(dataIndex); |
| | | td = hasInTd(tds, dataObj); |
| | | |
| | | if (td == null) { |