| | |
| | | } |
| | | //根据维护区和机房名称查询电池组信息 |
| | | @PostMapping("inform") |
| | | @ApiOperation(notes = "stationName 为模糊查询条件",value="维护区和机房名称查询电池组信息") |
| | | @ApiOperation(notes = "stationName1、2、3、5 为模糊查询条件",value="维护区和机房名称查询电池组信息") |
| | | public ServiceModel searchInform(@ApiParam(value = "省",required = true) @RequestParam String stationName1, @ApiParam(value = "市",required = true)@RequestParam String stationName2, @ApiParam(value = "区",required = true)@RequestParam String stationName5, @ApiParam(value = "机房",required = true)@RequestParam String stationName3, @ApiParam(value = "页码",required = true)@RequestParam Integer pageNum, @ApiParam(value = "页面数量",required = true)@RequestParam Integer pageSize) { |
| | | Batt_Maint_Dealarm bmd = new Batt_Maint_Dealarm(); |
| | | bmd.setBinf(new BattInf()); |
| | |
| | | }*/ |
| | | |
| | | //根据电池id查询电池的基本信息 |
| | | @GetMapping("byBattGroupId") |
| | | @PostMapping("searchBattBybattgroupId") |
| | | @ApiOperation(notes = "",value="电池id查询电池的基本信息") |
| | | public ServiceModel searchBattBybattgroupid(@RequestParam Integer battGroupId) { |
| | | BattInf bif = new BattInf(); |
| | | bif.setBattGroupId(battGroupId); |
| | | |
| | | return service.searchBattBybattgroupid(bif); |
| | | } |
| | | |
| | | @PostMapping("findByBattGroupId") |
| | | @ApiOperation(notes = "",value="findByBattGroupId") |
| | | public ServiceModel findByBattGroupId(@RequestParam Integer battGroupId){ |
| | | BattInf binf = new BattInf(); |
| | | binf.setBattGroupId(battGroupId); |
| | | ServiceModel model=service.findByBattGroupId(binf); |
| | | return model; |
| | | } |
| | | |
| | | //查询出当前存在内存中最大的设备的id(很重要**********) |
| | |
| | | return service.judgeBatt(binf); |
| | | } |
| | | |
| | | @PostMapping("byBattGroupId2") |
| | | @ApiOperation(notes = "",value="byBattGroupId2") |
| | | public ServiceModel findByBattGroupId(@RequestParam Integer battGroupId){ |
| | | BattInf binf = new BattInf(); |
| | | binf.setBattGroupId(battGroupId); |
| | | ServiceModel model=service.findByBattGroupId(binf); |
| | | return model; |
| | | } |
| | | |
| | | //根据电池组id查询不重复的单体编号 |
| | | @PostMapping("monNumByBattGroupId") |
| | | @ApiOperation(notes = "",value="电池组id查询不重复的单体编号") |
| | |
| | | * moncount中存放统计季度:一季度为1 以此类推 -3 |
| | | * monnum 中存放年份 -2020*/ |
| | | @PostMapping("beyondTime") |
| | | @ApiOperation(notes = "区域层次放在stationid中 battgroupnum 中存放统计方式:年度统计为0 季度统计为1 moncount中存放统计季度:一季度为1 以此类推 monnum 中存放年份",value="按地域和标称电压分组统计蓄电池组服役超期的数量") |
| | | public ServiceModel serchBeyondTime(@ApiParam(value = "区域层次(字符串数字)",required = true) @RequestParam String stationId,@ApiParam(value = "统计方式:年度统计为0 季度统计为1",required = true) @RequestParam Integer battGroupNum,@ApiParam(value = "年份",required = true) @RequestParam Integer monNum,@ApiParam(value = "统计季度:一季度为1 以此类推",required = true) @RequestParam Integer monCount,@ApiParam(value = "",required = true) @RequestParam Date BattInUseDate,@ApiParam(value = "使用日期段 格式2021/02/01 08:16:35",required = true) @RequestParam Date BattInUseDate1) { |
| | | @ApiOperation(notes = "TODO 待测", |
| | | value="按地域和标称电压分组统计蓄电池组服役超期的数量") |
| | | public ServiceModel serchBeyondTime(@ApiParam(value = "区域层次(字符串数字)",required = true) @RequestParam String stationId, |
| | | @ApiParam(value = "年份",required = true) @RequestParam Integer monNum, |
| | | @ApiParam(value = "统计方式:年度统计为0 季度统计为1",required = true) @RequestParam Integer battGroupNum, |
| | | @ApiParam(value = "统计季度:一季度为1 以此类推",required = true) @RequestParam Integer monCount) { |
| | | ServiceModel model= new ServiceModel(); |
| | | try { |
| | | Integer.parseInt(stationId); |
| | |
| | | binf.setBattGroupNum(battGroupNum); |
| | | binf.setMonNum(monNum); |
| | | binf.setMonCount(monCount); |
| | | binf.setBattInUseDate(BattInUseDate); |
| | | binf.setBattInUseDate1(BattInUseDate1); |
| | | return service.serchBeyondTime(binf); |
| | | model =service.serchBeyondTime(binf); |
| | | return model; |
| | | } |
| | | |
| | | //6.4.8按地域和标称电压分组统计蓄电池组的数量(蓄电池组数量统计) |
| | | @GetMapping("battGroupCountByMonVolStdGroup") |
| | | @ApiOperation(notes = "",value="按地域和标称电压分组统计蓄电池组的数量(蓄电池组数量统计)") |
| | | public ServiceModel serchByMonVolStdGroup(@RequestBody BattInf bif){ |
| | | // bif=ActionUtil.getGson("yyyy-MM-dd").fromJson(result,BattInf.class); |
| | | |
| | | return service.serchByMonVolStdGroup(bif); |
| | | @PostMapping("battGroupCountByMonVolStdGroup") |
| | | @ApiOperation(notes = "TODO 待测",value="按地域和标称电压分组统计蓄电池组的数量(蓄电池组数量统计)") |
| | | public ServiceModel serchByMonVolStdGroup(@ApiParam(value = "区域层次(字符串数字)",required = true) @RequestParam String stationId, |
| | | @ApiParam(value = "获取年份",required = true) @RequestParam Integer monNum, |
| | | @ApiParam(value = "存放统计方式:年度统计为0 季度统计为1",required = true) @RequestParam Integer battGroupNum, |
| | | @ApiParam(value = "存放统计季度:一季度为1 以此类推",required = true) @RequestParam Integer monCount){ |
| | | ServiceModel model = new ServiceModel(); |
| | | BattInf bif = new BattInf(); |
| | | try { |
| | | Integer.parseInt(stationId); |
| | | } catch (NumberFormatException e) { |
| | | e.printStackTrace(); |
| | | model.setMsg("参数不合法"); |
| | | return model; |
| | | } |
| | | bif.setStationId(stationId); |
| | | bif.setBattGroupNum(battGroupNum); |
| | | bif.setMonNum(monNum); |
| | | bif.setMonCount(monCount); |
| | | model = service.serchByMonVolStdGroup(bif); |
| | | return model; |
| | | } |
| | | |
| | | //6.4.9按地域和标称电压分组统计蓄电池组品牌的数量(蓄电池供应商信息统计) |
| | | @GetMapping("battProducerCountByBattProducerGroup") |
| | | @PostMapping("battProducerCountByBattProducerGroup") |
| | | @ApiOperation(notes = "",value="按地域和标称电压分组统计蓄电池组品牌的数量(蓄电池供应商信息统计)") |
| | | public ServiceModel serchByBattProducerGroup(@RequestBody BattInf bif){ |
| | | // bif=ActionUtil.getGson("yyyy-MM-dd").fromJson(result,BattInf.class); |
| | | |
| | | public ServiceModel serchByBattProducerGroup(@ApiParam(value = "区域层次(字符串数字)",required = true) @RequestParam String stationId, |
| | | @ApiParam(value = "获取年份",required = true) @RequestParam Integer monNum, |
| | | @ApiParam(value = "存放统计方式:年度统计为0 季度统计为1",required = true) @RequestParam Integer battGroupNum, |
| | | @ApiParam(value = "存放统计季度:一季度为1 以此类推",required = true) @RequestParam Integer monCount){ |
| | | ServiceModel model = new ServiceModel(); |
| | | BattInf bif = new BattInf(); |
| | | try { |
| | | Integer.parseInt(stationId); |
| | | } catch (NumberFormatException e) { |
| | | e.printStackTrace(); |
| | | model.setMsg("参数不合法"); |
| | | return model; |
| | | } |
| | | bif.setStationId(stationId); |
| | | bif.setBattGroupNum(battGroupNum); |
| | | bif.setMonNum(monNum); |
| | | bif.setMonCount(monCount); |
| | | return service.serchByBattProducerGroup(bif); |
| | | } |
| | | |
| | | //6.4.10按地域和标称电压分组统计蓄电池组使用时间(蓄电池投产年限统计) |
| | | @GetMapping("battGroupTimeInUse") |
| | | @PostMapping("battGroupTimeInUse") |
| | | @ApiOperation(notes = "",value="按地域和标称电压分组统计蓄电池组使用时间(蓄电池投产年限统计)") |
| | | public ServiceModel serchByBattInUseDateGroup(@RequestBody BattInf bif){ |
| | | // bif=ActionUtil.getGson("yyyy-MM-dd").fromJson(result,BattInf.class); |
| | | |
| | | public ServiceModel serchByBattInUseDateGroup(@ApiParam(value = "区域层次(字符串数字)",required = true) @RequestParam String stationId, |
| | | @ApiParam(value = "获取年份",required = true) @RequestParam Integer monNum, |
| | | @ApiParam(value = "存放统计方式:年度统计为0 季度统计为1",required = true) @RequestParam Integer battGroupNum, |
| | | @ApiParam(value = "存放统计季度:一季度为1 以此类推",required = true) @RequestParam Integer monCount){ |
| | | ServiceModel model = new ServiceModel(); |
| | | BattInf bif = new BattInf(); |
| | | try { |
| | | Integer.parseInt(stationId); |
| | | } catch (NumberFormatException e) { |
| | | e.printStackTrace(); |
| | | model.setMsg("参数不合法"); |
| | | return model; |
| | | } |
| | | bif.setStationId(stationId); |
| | | bif.setBattGroupNum(battGroupNum); |
| | | bif.setMonNum(monNum); |
| | | bif.setMonCount(monCount); |
| | | return service.serchByBattInUseDateGroup(bif); |
| | | } |
| | | |
| | | //1 根据机房id查询电池组id排序最小值 |
| | | @GetMapping("byIdLow") |
| | | @PostMapping("byIdLow") |
| | | @ApiOperation(notes = "",value="机房id查询电池组id排序最小值") |
| | | public ServiceModel serchByIdLow(@RequestBody BattInf bif){ |
| | | // bif=ActionUtil.getGson("yyyy-MM-dd").fromJson(result,BattInf.class); |
| | | |
| | | public ServiceModel serchByIdLow(@RequestParam String stationId){ |
| | | ServiceModel model = new ServiceModel(); |
| | | BattInf bif = new BattInf(); |
| | | try { |
| | | Integer.parseInt(stationId); |
| | | } catch (NumberFormatException e) { |
| | | e.printStackTrace(); |
| | | model.setMsg("参数不合法"); |
| | | return model; |
| | | } |
| | | bif.setStationId(stationId); |
| | | return service.serchByIdLow(bif); |
| | | } |
| | | |