毕设&课程作业_智能电表系统.zip

package com.gd.emeter; import java.lang.reflect.Field; import java.math.BigDecimal; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import org.apache.commons.lang3.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import com.gd.mapper.MeterMapper; import com.gd.mapper.NBMapper; import com.gd.mapper.StatMapper; import com.gd.model.po.CarrierValueFee; import com.gd.model.po.CompanyYearMonthValue; import com.gd.model.po.Meter; import com.gd.model.po.Meter12Month; import com.gd.model.po.MeterLostData; import com.gd.model.po.MeterMonthReport; import com.gd.model.po.MeterNum; import com.gd.model.po.MeterValueTime; import com.gd.model.po.MeterWarning; import com.gd.redis.InitLoadToRedis; /** * @author ZhouHR */ @Controller @RequestMapping("/stat") public class StatController { @Autowired private MeterMapper meterMapper; @Autowired private NBMapper nbMapper; @Autowired private StatMapper satMapper; @RequestMapping("/toListMeterValueChart") public String toListMeterValueChart(HttpServletRequest request) { // request.setAttribute("meterNo", meterNo); return "jsp/emeter/listMeterValueChart"; } @RequestMapping("/toListMeterValueDayChart") public String toListMeterValueDayChart(HttpServletRequest request) { Calendar c = Calendar.getInstance(); c.add(Calendar.DAY_OF_MONTH, -1); DateFormat df1 = new SimpleDateFormat("yyyy-MM-dd"); String date1 = df1.format(c.getTime()); request.setAttribute("date1", date1); return "jsp/emeter/listMeterValueDayChart"; } @RequestMapping("/toListMeterNum") public String toListMeterNum(String companyId, HttpServletRequest request) { // request.setAttribute("companyId", companyId); return "jsp/emeter/listMeterNum"; } @RequestMapping("/toListMeterValue") public String toListMeterValue(String companyId, HttpServletRequest request) { return "jsp/emeter/listMeterValue"; } @RequestMapping("/toListMeterValueDay") public String toListMeterValueDay(@RequestParam(required = false) String meterNo, String date1, HttpServletRequest request) { if (StringUtils.isEmpty(date1)) { Date date = new Date(); DateFormat df1 = new SimpleDateFormat("yyyy-MM-dd"); date1 = df1.format(date); } request.setAttribute("date1", date1); return "jsp/emeter/listMeterValueDay"; } @RequestMapping("/toListCarrierValue") public String toListCarrierValue(HttpServletRequest request) { return "jsp/emeter/listCarrierValueChart"; } @RequestMapping("/toListCarrierValueDay") public String toListCarrierValueDay(HttpServletRequest request) { Calendar c = Calendar.getInstance(); c.add(Calendar.DAY_OF_MONTH, -1); DateFormat df1 = new SimpleDateFormat("yyyy-MM-dd"); String date1 = df1.format(c.getTime()); request.setAttribute("date1", date1); return "jsp/emeter/listCarrierValueDayChart"; } @RequestMapping("/toListDataReload") public String toLostDataReload(@RequestParam(required = false) String meterNo, HttpServletRequest request) { request.setAttribute("meterNo", meterNo); return "jsp/emeter/listLostDataReload"; } @RequestMapping("/toListYear") public String toListYear(@RequestParam(required = false) String meterNo, HttpServletRequest request) { request.setAttribute("meterNo", meterNo); return "jsp/emeter/listMonthReport"; } @RequestMapping("/toListDay") public String toListDay(@RequestParam(required = false) String meterNo, String date1, HttpServletRequest request) { request.setAttribute("meterNo", meterNo); if (StringUtils.isEmpty(date1)) { Date date = new Date(); DateFormat df1 = new SimpleDateFormat("yyyy-MM-dd"); date1 = df1.format(date); } request.setAttribute("date1", date1); return "jsp/emeter/listDayReport"; } @RequestMapping("/toListWarning") public String toListWarning(@RequestParam(required = false) String meterNo, HttpServletRequest request) { request.setAttribute("meterNo", meterNo); return "jsp/emeter/listStatWarning"; } private static void plusValue(Meter12Month meter12Month, String value) { BigDecimal bd1 = new BigDecimal(meter12Month.getYearValue()); if (StringUtils.isEmpty(value)) { value = "0"; } BigDecimal bd2 = new BigDecimal(value); bd1 = bd1.add(bd2); meter12Month.setYearValue(bd1.toPlainString()); } @SuppressWarnings("rawtypes") @RequestMapping("/pagingDay") @ResponseBody public Map pagingDay(@RequestBody(required = false) Map<String, Object> params, HttpServletRequest request) throws ParseException { Map<String, Object> map = new HashMap<String, Object>(); //分页查询 Integer page = Integer.valueOf(params.get("page").toString()); Integer rows = Integer.valueOf(params.get("rows").toString()); params.put("p1", (page - 1) * rows); params.put("p2", (page) * rows); String date1 = params.get("date1").toString(); DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); DateFormat sdf1 = new SimpleDateFormat("yyyyMMdd"); Date date = sdf.parse(date1); Calendar c = Calendar.getInstance(); c.setTime(date); c.set(Calendar.DAY_OF_WEEK, Calendar.MONDAY); date1 = sdf1.format(c.getTime()); c.add(Calendar.DAY_OF_WEEK, 6); String date2 = sdf1.format(c.getTime()); params.put("date1", date1); params.put("date2", date2); List<MeterMonthReport> list = meterMapper.getDayReport(params); int total = meterMapper.countDayReport(params); List<Meter12Month> listMeter12Month = new ArrayList<Meter12Month>(); Map<String, Meter12Month> mapMeter12Month = new HashMap<String, Meter12Month>(); Class clazz = Meter12Month.class; Field[] result = clazz.getDeclaredFields(); for (MeterMonthReport meterMonthReport : list) { String meterNo = meterMonthReport.getMeterNo(); Meter12Month meter12Month = mapMeter12Month.get(meterNo); if (meter12Month == null) { meter12Month = new Meter12Month(); meter12Month.setMeterNo(meterMonthReport.getMeterNo()); meter12Month.setProjectNo(meterMonthReport.getProjectNo()); meter12Month.setCompanyId(meterMonthReport.getCompanyId()); meter12Month.setYearValue(meterMonthReport.getEvalue()); mapMeter12Month.put(meterNo, meter12Month); listMeter12Month.add(meter12Month); // total++; } else { // plusValue(meter12Month,meterMonthReport); } int yearmonth = meterMonthReport.getYearmonth(); Integer nmonth = yearmonth - Integer.valueOf(date1) + 1; for (Field field : result) { String name = "evalue" + nmonth; if (name.equals(field.getName())) { try { field.setAccessible(true); field.set(meter12Month, meterMonthReport.getEvalue()); } catch (IllegalArgumentException e) { e.printStackTrace();