@Override public RequestForm mapRow(ResultSet rs, int rowNum) throws SQLException { RequestForm requestForm = new RequestForm(); requestForm.setRequestFormId(rs.getLong("request_form_id")); requestForm.setRequestCSNo(rs.getString("request_cs_no")); requestForm.setRequestFormStatus(rs.getString("request_form_status")); requestForm.setRequestDate(rs.getDate("request_date")); return requestForm; }
@RequestMapping( value = {"/search.htm"}, method = RequestMethod.POST) public ModelAndView search(@ModelAttribute RequestForm requestForm) { logger.info(" Start Search GET "); ModelAndView mav = new ModelAndView(); mav.setViewName("peaMeterIndex"); mav.addObject("requestForm", requestForm); List<RequestForm> requestFormList = peaMeterService.queryCSNoForMeterSearch(requestForm.getRequestCSNo()); mav.addObject("requestFormList", requestFormList); return mav; }
@RequestMapping(value = "/edit.htm", method = RequestMethod.POST) public ModelAndView edit(@ModelAttribute RequestForm requestForm, BindingResult result) { logger.info(" Start edit Post "); ModelAndView mav = new ModelAndView(); try { requestForm = new RequestFormValidator().validate(requestForm, result); if (result.hasErrors()) { mav.setViewName("peaMeterForm"); } else { requestForm.setRequestFormStatus(BuckwaConstants.END_STATUS); peaMeterService.insertMeter(requestForm); mav.addObject("requestFormList", peaMeterService.queryIdForMeterList()); mav.setViewName("peaMeterIndex"); } } catch (Exception e) { e.printStackTrace(); } return mav; }
@Override public List<RequestForm> queryCSNoForManagerSearch(RequestForm requestForm) { StringBuilder sql = new StringBuilder(); List<String> strList = new ArrayList<String>(); String strSql = ""; sql.append(" SELECT "); sql.append(" request_form_id, request_cs_no, request_form_status, request_date "); sql.append(" FROM pea_request_form "); sql.append(" WHERE 1 = 1 "); if (StringUtils.isNotEmpty(requestForm.getRequestCSNo())) { sql.append(" AND request_cs_no LIKE '%" + requestForm.getRequestCSNo() + "%' "); } if (StringUtils.isNotEmpty(requestForm.getChkNewStatus())) { strList.add("'" + requestForm.getChkNewStatus() + "'"); } if (StringUtils.isNotEmpty(requestForm.getChkSurveyStatus())) { strList.add("'" + requestForm.getChkSurveyStatus() + "'"); } if (StringUtils.isNotEmpty(requestForm.getChkMeterStatus())) { strList.add("'" + requestForm.getChkMeterStatus() + "'"); } if (StringUtils.isNotEmpty(requestForm.getChkEndStatus())) { strList.add("'" + requestForm.getChkEndStatus() + "'"); } if (StringUtils.isNotEmpty(requestForm.getChkNewStatus()) || StringUtils.isNotEmpty(requestForm.getChkSurveyStatus()) || StringUtils.isNotEmpty(requestForm.getChkMeterStatus()) || StringUtils.isNotEmpty(requestForm.getChkEndStatus())) { for (int i = 0; i < strList.size(); i++) { strSql = strSql + strList.get(i); if (strList.size() >= 2 && i + 1 < strList.size()) { strSql = strSql + ", "; } } System.out.println(strSql); sql.append(" AND request_form_status IN (" + strSql + ") "); } sql.append(" ORDER BY request_date DESC "); sql.append(" LIMIT 0, 7 "); List<RequestForm> requestFormList = this.executeQuery(sql.toString(), csNoMapper); return requestFormList; }