From 2c183f0f9d534e37dd69809f0eedc19fabea82e8 Mon Sep 17 00:00:00 2001 From: 刘小明 <liuxm_a@163.com> Date: 星期三, 28 八月 2024 11:16:03 +0800 Subject: [PATCH] 添加查询所有工站接口; 修改查询任务计划列表接口 --- pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/station/StationCtrl.java | 126 +++++++++++++++-------------------------- 1 files changed, 47 insertions(+), 79 deletions(-) diff --git a/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/station/StationCtrl.java b/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/station/StationCtrl.java index e081b49..fcaafc3 100644 --- a/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/station/StationCtrl.java +++ b/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/station/StationCtrl.java @@ -1,5 +1,6 @@ package com.dy.pmsPlatform.station; +import cn.hutool.json.JSONArray; import com.alibaba.excel.converters.Converter; import com.alibaba.fastjson2.JSON; import com.dy.common.aop.SsoPowerAop; @@ -8,19 +9,18 @@ import com.dy.common.webUtil.QueryResultVo; import com.dy.pmsGlobal.aop.Log; import com.dy.pmsGlobal.pojoPlt.PltStation; +import com.dy.pmsGlobal.util.QrCodeConstant; import com.dy.pmsGlobal.util.QrCodeUtil; import com.google.zxing.WriterException; import jakarta.servlet.http.HttpServletResponse; import jakarta.validation.Valid; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; -import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.*; import java.io.IOException; import java.util.ArrayList; import java.util.List; -import java.util.Objects; /** * 宸ョ珯 @@ -32,7 +32,6 @@ public class StationCtrl { private static final String fileName = "宸ョ珯淇℃伅" ; private static final String sheetName = "宸ョ珯淇℃伅" ; - private static final String stationPrefix = "103" ; private StationSv sv; @Autowired public StationCtrl(StationSv sv){ @@ -42,24 +41,14 @@ /** * 淇濆瓨 * @param station - * @param bindingResult * @return */ @PostMapping(path="save") @SsoPowerAop(power = "10300007") @Log("淇濆瓨宸ョ珯") - public BaseResponse<Boolean> save(@RequestBody @Valid PltStation station,BindingResult bindingResult){ - if (bindingResult != null && bindingResult.hasErrors()) { - return BaseResponseUtils.buildFail(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage()); - } - int count; - try { - station.deleted = false; - count = sv.save(station); - }catch (Exception e){ - log.error("淇濆瓨宸ョ珯寮傚父", e); - return BaseResponseUtils.buildException(e.getMessage()); - } + public BaseResponse<Boolean> save(@RequestBody @Valid PltStation station){ + station.deleted = false; + int count = sv.save(station); if (count <= 0) { return BaseResponseUtils.buildFail("鏁版嵁搴撳瓨鍌ㄥけ璐�"); @@ -72,23 +61,14 @@ /** * 鏇存柊 * @param station - * @param bindingResult * @return */ @PostMapping(path="update") @SsoPowerAop(power = "10300007") @Log("鏇存柊宸ョ珯") - public BaseResponse<Boolean> update(@RequestBody @Valid PltStation station,BindingResult bindingResult){ - int count; - try { - if (bindingResult != null && bindingResult.hasErrors()) { - return BaseResponseUtils.buildFail(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage()); - } - count = sv.update(station); - }catch (Exception e){ - log.error("鏇存柊宸ョ珯寮傚父", e); - return BaseResponseUtils.buildException(e.getMessage()); - } + public BaseResponse<Boolean> update(@RequestBody @Valid PltStation station){ + int count = sv.update(station); + if (count <= 0) { return BaseResponseUtils.buildFail("鏁版嵁搴撳瓨鍌ㄥけ璐�"); } else { @@ -105,13 +85,8 @@ @SsoPowerAop(power = "10300007") @Log("鍒犻櫎宸ョ珯") public BaseResponse<Boolean> delete(String id){ - int count; - try { - count = sv.delete(Long.parseLong(id)); - }catch (Exception e){ - log.error("鍒犻櫎宸ョ珯寮傚父", e); - return BaseResponseUtils.buildException(e.getMessage()); - } + int count = sv.delete(Long.parseLong(id)); + if (count <= 0) { return BaseResponseUtils.buildFail("鏁版嵁搴撳瓨鍌ㄥけ璐�"); } else { @@ -126,13 +101,8 @@ @SsoPowerAop(power = "10300006") //鐧诲綍涓庢潈闄愬悓鏃堕獙璇� @Log("鏍规嵁ID鏌ヨ宸ョ珯") public BaseResponse<PltStation> one(String id){ - try{ - PltStation param=sv.selectById(id); - return BaseResponseUtils.buildSuccess(JSON.toJSON(param)); - }catch (Exception e){ - log.error("鏍规嵁ID鏌ヨ宸ョ珯寮傚父", e); - return BaseResponseUtils.buildException(e.getMessage()); - } + PltStation param=sv.selectById(id); + return BaseResponseUtils.buildSuccess(JSON.toJSON(param)); } /** @@ -144,26 +114,28 @@ @SsoPowerAop(power = "10300006") @Log("鍒嗛〉鏌ヨ宸ョ珯") public BaseResponse<QueryResultVo<List<PltStation>>> some(@RequestBody QueryVo vo){ - try { - QueryResultVo<List<PltStation>> list = sv.selectSome(vo) ; - return BaseResponseUtils.buildSuccess(list); - }catch (Exception e){ - log.error("鍒嗛〉鏌ヨ宸ョ珯寮傚父", e); - return BaseResponseUtils.buildException(e.getMessage()); - } + QueryResultVo<List<PltStation>> list = sv.selectSome(vo) ; + return BaseResponseUtils.buildSuccess(list); + } + + /** + * 鏌ヨ鎵�鏈夊伐绔� + * @return + */ + @GetMapping(path="all") + @SsoPowerAop(power = "10300006") + @Log("鏌ヨ鎵�鏈夊伐绔�") + public BaseResponse<JSONArray> all(){ + JSONArray array = sv.selectAllIdAndName() ; + return BaseResponseUtils.buildSuccess(array); } @PostMapping(path="disabled") - @SsoPowerAop(power = "10100011") + @SsoPowerAop(power = "10300007") @Log("绂佺敤鎴栧惎鐢ㄥ伐绔�") public BaseResponse<Boolean> disabled(@RequestBody PltStation station){ - int count; - try { - count = sv.disabled(station.id,station.disabled); - }catch (Exception e){ - log.error("绂佺敤鎴栧惎鐢ㄥ伐绔欏紓甯�", e); - return BaseResponseUtils.buildException(e.getMessage()); - } + int count = sv.disabled(station.id,station.disabled); + if (count <= 0) { return BaseResponseUtils.buildFail("鏁版嵁搴撳瓨鍌ㄥけ璐�"); } else { @@ -171,32 +143,28 @@ } } @PostMapping(path="export") - @SsoPowerAop(power = "10300000") + @SsoPowerAop(power = "10300007") @Log("瀵煎嚭宸ョ珯淇℃伅") public void export(HttpServletResponse response){ - try{ - List<Converter> list = new ArrayList<>() ; + List<Converter> list = new ArrayList<>() ; - List<PltStation> stations = sv.selectAll(); - // 浣跨敤骞惰娴佹彁楂樻�ц兘 - stations.parallelStream().forEach(station -> { - ExcelVo vo = new ExcelVo(); - vo.name = station.name; + List<PltStation> stations = sv.selectAll(); + // 浣跨敤骞惰娴佹彁楂樻�ц兘 + stations.parallelStream().forEach(station -> { + ExcelVo vo = new ExcelVo(); + vo.name = station.name; // vo.code = "103"+station.id; - vo.lineName = station.lineName; - try { - vo.qrCode = QrCodeUtil.genQrCode(stationPrefix+station.id); - } catch (IOException e) { - e.printStackTrace(); - } catch (WriterException e) { - e.printStackTrace(); - } - list.add(vo); - }); - QrCodeUtil.downloadExcel(response, fileName,sheetName,list); - }catch (Exception e){ - log.error("瀵煎嚭浜у搧淇℃伅寮傚父", e); - } + vo.lineName = station.lineName; + try { + vo.qrCode = QrCodeUtil.genQrCode(QrCodeConstant.TypeStation+station.id); + } catch (IOException e) { + e.printStackTrace(); + } catch (WriterException e) { + e.printStackTrace(); + } + list.add(vo); + }); + QrCodeUtil.downloadExcel(response, fileName,sheetName,list); } } -- Gitblit v1.8.0