From 6bf63be83c6e5eeed1b5d19747f473478075c3a6 Mon Sep 17 00:00:00 2001 From: liriming <1343021927@qq.com> Date: 星期一, 02 九月 2024 17:38:02 +0800 Subject: [PATCH] 测点列表接口开发 --- iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpApiController.java | 2 iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/DaPointService.java | 27 +++--- iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/impl/DaPointServiceImpl.java | 69 ++++++++-------- iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/controller/admin/DaPointController.java | 101 +++++++++---------------- iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/dao/DaPointDao.java | 18 +++- 5 files changed, 99 insertions(+), 118 deletions(-) diff --git a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpApiController.java b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpApiController.java index a29448d..222a362 100644 --- a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpApiController.java +++ b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/channel/http/controller/admin/HttpApiController.java @@ -22,7 +22,7 @@ * @createTime 2024年08月27日 */ @RestController -@RequestMapping("/data/http/api") +@RequestMapping("/data/channel/http/api") public class HttpApiController { @Resource diff --git a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/controller/admin/DaPointController.java b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/controller/admin/DaPointController.java index d29f255..abb0093 100644 --- a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/controller/admin/DaPointController.java +++ b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/controller/admin/DaPointController.java @@ -1,37 +1,32 @@ package com.iailab.module.data.point.controller.admin; -import com.iailab.framework.common.constant.Constant; -import com.iailab.framework.common.page.PageData; import com.iailab.framework.common.pojo.CommonResult; -import com.iailab.framework.common.util.validation.ValidationUtils; -import com.iailab.framework.common.validation.group.AddGroup; -import com.iailab.framework.common.validation.group.UpdateGroup; -import com.iailab.framework.common.validation.group.DefaultGroup; +import com.iailab.framework.common.pojo.PageResult; +import com.iailab.framework.common.util.object.BeanUtils; import com.iailab.module.data.point.dto.DaPointDTO; +import com.iailab.module.data.point.entity.DaPointEntity; import com.iailab.module.data.point.service.DaPointService; +import com.iailab.module.data.point.vo.DaPointPageReqVO; +import com.iailab.module.data.point.vo.DaPointRespVO; import io.swagger.v3.oas.annotations.Operation; -import io.swagger.v3.oas.annotations.Parameter; -import io.swagger.v3.oas.annotations.Parameters; -import javax.annotation.Resource; -import javax.annotation.security.PermitAll; -import javax.validation.Valid; - import io.swagger.v3.oas.annotations.tags.Tag; -import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.transaction.annotation.Transactional; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; +import javax.annotation.Resource; +import javax.validation.Valid; import java.util.List; import java.util.Map; +import java.util.UUID; import static com.iailab.framework.common.pojo.CommonResult.success; /** - * @author PanZhibao + * @author lirm * @Description - * @createTime 2024年05月12日 + * @createTime 2024年09月2日 */ @Tag(name = "数据采集,测点") @RestController @@ -43,66 +38,42 @@ private DaPointService daPointService; @GetMapping("page") - @Operation(summary = "分页") - @Parameters({ - @Parameter(name = Constant.PAGE, description = "当前页码,从1开始", required = true) , - @Parameter(name = Constant.LIMIT, description = "每页显示记录数", required = true) , - @Parameter(name = Constant.ORDER_FIELD, description = "排序字段") , - @Parameter(name = Constant.ORDER, description = "排序方式,可选值(asc、desc)") - }) - @PreAuthorize("@ss.hasPermission('data:point:query')") - public CommonResult<PageData<DaPointDTO>> page(@RequestParam Map<String, Object> params){ - PageData<DaPointDTO> page = daPointService.page(params); - - return success(page); - } - - @GetMapping("{id}") - @Operation(summary = "信息") - @PreAuthorize("@ss.hasPermission('data:point:query')") - public CommonResult<DaPointDTO> get(@PathVariable("id") String id){ - DaPointDTO data = daPointService.get(id); - - return new CommonResult<DaPointDTO>().setData(data); + public CommonResult<PageResult<DaPointRespVO>> page(@Valid DaPointPageReqVO reqVO){ + PageResult<DaPointEntity> page = daPointService.queryPage(reqVO); + return success(BeanUtils.toBean(page, DaPointRespVO.class)); } @GetMapping("/list") @Operation(summary = "列表") - @PreAuthorize("@ss.hasPermission('data:point:query')") public CommonResult<List<DaPointDTO>> list(@Valid @RequestParam Map<String, Object> params) { List<DaPointDTO> list = daPointService.list(params); return success(list); } - @PostMapping - @Operation(summary = "保存") - @PreAuthorize("@ss.hasPermission('data:point:save')") - public CommonResult save(@RequestBody DaPointDTO dto){ - //效验数据 - ValidationUtils.validate(dto, AddGroup.class, DefaultGroup.class); - daPointService.add(dto); - - return new CommonResult(); + @GetMapping("/info/{id}") + public CommonResult<DaPointDTO> info(@PathVariable("id") String id){ + DaPointDTO info= daPointService.info(id); + return success(info); } - @PutMapping - @Operation(summary = "修改") - @PreAuthorize("@ss.hasPermission('data:point:update')") - public CommonResult update(@RequestBody DaPointDTO dto){ - //效验数据 - ValidationUtils.validate(dto, UpdateGroup.class, DefaultGroup.class); - - daPointService.update(dto); - - return new CommonResult(); + @PostMapping("/add") + public CommonResult<Boolean> add(@RequestBody DaPointDTO daPointDTO){ + String id = UUID.randomUUID().toString(); + daPointDTO.setId(id); + daPointService.add(daPointDTO); + return success(true); } - @DeleteMapping - @Operation(summary = "删除") - @PreAuthorize("@ss.hasPermission('data:point:delete')") - public CommonResult delete(@RequestBody String[] ids){ + @PutMapping("/update") + public CommonResult<Boolean> update(@RequestBody DaPointDTO daPointDTO) { + daPointService.update(daPointDTO); + return success(true); + } + + @DeleteMapping("/delete") + public CommonResult<Boolean> delete(String[] ids) { daPointService.delete(ids); - return new CommonResult(); + return success(true); } @GetMapping("pointNo") @@ -115,17 +86,17 @@ @PutMapping("/enable") @Operation(summary = "启用") @Transactional - public CommonResult enable(@RequestBody String[] ids) { + public CommonResult<Boolean> enable(@RequestBody String[] ids) { daPointService.enableByIds(ids); - return new CommonResult(); + return success(true); } @PutMapping("/disable") @Operation(summary = "禁用") @Transactional - public CommonResult disable(@RequestBody String[] ids) { + public CommonResult<Boolean> disable(@RequestBody String[] ids) { daPointService.disableByIds(ids); - return new CommonResult(); + return success(true); } } \ No newline at end of file diff --git a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/dao/DaPointDao.java b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/dao/DaPointDao.java index 6aa212b..d977988 100644 --- a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/dao/DaPointDao.java +++ b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/dao/DaPointDao.java @@ -1,10 +1,13 @@ package com.iailab.module.data.point.dao; import com.baomidou.mybatisplus.core.metadata.IPage; -import com.iailab.framework.common.dao.BaseDao; +import com.iailab.framework.common.pojo.PageResult; +import com.iailab.framework.mybatis.core.mapper.BaseMapperX; +import com.iailab.framework.mybatis.core.query.LambdaQueryWrapperX; import com.iailab.framework.tenant.core.db.dynamic.TenantDS; import com.iailab.module.data.point.dto.DaPointDTO; import com.iailab.module.data.point.entity.DaPointEntity; +import com.iailab.module.data.point.vo.DaPointPageReqVO; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @@ -12,13 +15,13 @@ import java.util.Map; /** - * @author PanZhibao + * @author lirm * @Description - * @createTime 2022年07月12日 13:47:00 + * @createTime 2024年09月2日 */ @TenantDS @Mapper -public interface DaPointDao extends BaseDao<DaPointEntity> { +public interface DaPointDao extends BaseMapperX<DaPointEntity> { IPage<DaPointDTO> getPageList(IPage<DaPointEntity> page, @Param("params") Map<String, Object> params); @@ -27,4 +30,11 @@ List<DaPointDTO> getMeasurePoint(Map<String, Object> params); List<DaPointDTO> getMathPoint(Map<String, Object> params); + + default PageResult<DaPointEntity> selectPage(DaPointPageReqVO reqVO) { + return selectPage(reqVO, new LambdaQueryWrapperX<DaPointEntity>() + .likeIfPresent(DaPointEntity::getPointNo, reqVO.getPointNo()) + .likeIfPresent(DaPointEntity::getPointName, reqVO.getPointName()) + .orderByDesc(DaPointEntity::getCreateTime)); + } } diff --git a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/DaPointService.java b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/DaPointService.java index 0f16bf2..f3bec40 100644 --- a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/DaPointService.java +++ b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/DaPointService.java @@ -1,31 +1,31 @@ package com.iailab.module.data.point.service; -import com.iailab.framework.common.page.PageData; -import com.iailab.framework.common.service.BaseService; +import com.iailab.framework.common.pojo.PageResult; import com.iailab.module.data.point.dto.DaPointDTO; import com.iailab.module.data.point.entity.DaPointEntity; +import com.iailab.module.data.point.vo.DaPointPageReqVO; import java.util.List; import java.util.Map; /** - * @author PanZhibao + * @author lirm * @Description - * @createTime 2024年05月12日 + * @createTime 2024年09月2日 */ -public interface DaPointService extends BaseService<DaPointEntity> { +public interface DaPointService{ + PageResult<DaPointEntity> queryPage(DaPointPageReqVO reqVO); - PageData<DaPointDTO> page(Map<String, Object> params); + DaPointDTO info(String id); - DaPointDTO get(String id); + void add(DaPointDTO daPointDTO); + + void update(DaPointDTO daPointDTO); + + void delete(String[] id); + List<DaPointDTO> list(Map<String, Object> params); - - void add(DaPointDTO dataPoint); - - void update(DaPointDTO dataPoint); - - void delete(String[] ids); List<DaPointDTO> getConstantPoint(String freq); @@ -50,4 +50,5 @@ void disableByIds(String[] ids); void updateDefaultValue(DaPointDTO dto); + } diff --git a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/impl/DaPointServiceImpl.java b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/impl/DaPointServiceImpl.java index 57ff47b..b410b7f 100644 --- a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/impl/DaPointServiceImpl.java +++ b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/point/service/impl/DaPointServiceImpl.java @@ -2,38 +2,37 @@ import com.alibaba.fastjson.JSONArray; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; -import com.baomidou.mybatisplus.core.metadata.IPage; -import com.iailab.framework.common.constant.Constant; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.iailab.framework.common.pojo.PageResult; +import com.iailab.framework.common.util.object.ConvertUtils; import com.iailab.module.data.common.enums.CommonConstant; import com.iailab.module.data.common.enums.IsEnableEnum; -import com.iailab.framework.common.page.PageData; -import com.iailab.framework.common.service.impl.BaseServiceImpl; -import com.iailab.framework.common.util.object.ConvertUtils; import com.iailab.module.data.point.common.IncreaseCodeEnum; -import com.iailab.module.data.point.dao.DaPointDao; -import com.iailab.module.data.point.service.DaMeasurePointService; import com.iailab.module.data.point.common.PointTypeEnum; +import com.iailab.module.data.point.dao.DaPointDao; import com.iailab.module.data.point.dto.DaMeasurePointDTO; import com.iailab.module.data.point.dto.DaPointDTO; import com.iailab.module.data.point.entity.DaPointEntity; import com.iailab.module.data.point.service.DaMathPointService; +import com.iailab.module.data.point.service.DaMeasurePointService; import com.iailab.module.data.point.service.DaPointService; import com.iailab.module.data.point.service.DaSequenceNumService; +import com.iailab.module.data.point.vo.DaPointPageReqVO; import org.apache.commons.lang3.StringUtils; -import javax.annotation.Resource; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; +import javax.annotation.Resource; import java.util.*; /** - * @author PanZhibao + * @author lirm * @Description - * @createTime 2024年05月12日 + * @createTime 2024年09月2日 */ @Service -public class DaPointServiceImpl extends BaseServiceImpl<DaPointDao, DaPointEntity> implements DaPointService { +public class DaPointServiceImpl extends ServiceImpl<DaPointDao, DaPointEntity> implements DaPointService { @Resource private DaMeasurePointService daMeasurePointService; @@ -43,19 +42,19 @@ @Resource private DaSequenceNumService daSequenceNumService; + + @Resource + private DaPointDao daPointDao; + @Override - public PageData<DaPointDTO> page(Map<String, Object> params) { - IPage<DaPointDTO> page = baseDao.getPageList( - getPage(params, Constant.CREATE_TIME, false), - params - ); - return getPageData(page, DaPointDTO.class); + public PageResult<DaPointEntity> queryPage(DaPointPageReqVO reqVO) { + return daPointDao.selectPage(reqVO); } @Override - public DaPointDTO get(String id) { - DaPointEntity entity = baseDao.selectById(id); + public DaPointDTO info(String id) { + DaPointEntity entity = daPointDao.selectById(id); DaPointDTO result = ConvertUtils.sourceToTarget(entity, DaPointDTO.class); if (PointTypeEnum.MEASURE_POINT.getCode().equals(result.getPointType())) { DaMeasurePointDTO measurePoint = daMeasurePointService.getByPoint(id); @@ -86,7 +85,7 @@ .in(!CollectionUtils.isEmpty(pointNos),"point_no", pointNos) .like(StringUtils.isNotBlank(pointNoLike), "point_no", pointNoLike) .last("limit 1, 10"); - List<DaPointEntity> list = baseDao.selectList(queryWrapper); + List<DaPointEntity> list = daPointDao.selectList(queryWrapper); return ConvertUtils.sourceToTarget(list, DaPointDTO.class); } @@ -110,7 +109,7 @@ } daPointEntity.setIsEnable(CommonConstant.IS_ENABLE); daPointEntity.setCreateTime(new Date()); - baseDao.insert(daPointEntity); + daPointDao.insert(daPointEntity); } @Override @@ -118,7 +117,7 @@ public void update(DaPointDTO dataPoint) { DaPointEntity daPointEntity = ConvertUtils.sourceToTarget(dataPoint, DaPointEntity.class); daPointEntity.setUpdateTime(new Date()); - baseDao.updateById(daPointEntity); + daPointDao.updateById(daPointEntity); if (PointTypeEnum.MEASURE_POINT.getName().equals(dataPoint.getPointType())) { DaMeasurePointDTO measurePoint = dataPoint.getMeasurePoint(); measurePoint.setSourceType(dataPoint.getSourceOption().get(0)); @@ -133,7 +132,7 @@ @Override @Transactional(rollbackFor = Exception.class) public void delete(String[] ids) { - baseDao.deleteBatchIds(Arrays.asList(ids)); + daPointDao.deleteBatchIds(Arrays.asList(ids)); daMeasurePointService.deleteByPoint(ids); daMathPointService.deleteByPoint(ids); } @@ -144,7 +143,7 @@ params.put("pointType", PointTypeEnum.CONSTANT.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("minfreqid", freq); - return baseDao.getConstantPoint(params); + return daPointDao.getConstantPoint(params); } @Override @@ -153,7 +152,7 @@ params.put("pointType", PointTypeEnum.CONSTANT.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("pointNos", pointNos); - return baseDao.getConstantPoint(params); + return daPointDao.getConstantPoint(params); } @Override @@ -162,7 +161,7 @@ params.put("pointType", PointTypeEnum.MEASURE_POINT.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("minfreqid", freq); - return baseDao.getMeasurePoint(params); + return daPointDao.getMeasurePoint(params); } @Override @@ -171,7 +170,7 @@ params.put("pointType", PointTypeEnum.MEASURE_POINT.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("pointNos", pointNos); - return baseDao.getMeasurePoint(params); + return daPointDao.getMeasurePoint(params); } @Override @@ -179,7 +178,7 @@ Map<String, Object> params = new HashMap<>(); params.put("pointType", PointTypeEnum.MEASURE_POINT.getCode()); params.put("pointNo", pointNo); - List<DaPointDTO> list = baseDao.getMeasurePoint(params); + List<DaPointDTO> list = daPointDao.getMeasurePoint(params); if (CollectionUtils.isEmpty(list)) { return null; } @@ -192,7 +191,7 @@ params.put("pointType", PointTypeEnum.CALCULATE_POINT.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("minfreqid", freq); - return baseDao.getMathPoint(params); + return daPointDao.getMathPoint(params); } @Override @@ -201,14 +200,14 @@ params.put("pointType", PointTypeEnum.CALCULATE_POINT.getCode()); params.put("isEnable", CommonConstant.IS_ENABLE); params.put("pointNos", pointNos); - return baseDao.getMathPoint(params); + return daPointDao.getMathPoint(params); } @Override public DaPointDTO getByNo(String pointNo) { QueryWrapper<DaPointEntity> wrapper = new QueryWrapper<>(); wrapper.eq("point_no", pointNo); - DaPointEntity entity = baseDao.selectOne(wrapper); + DaPointEntity entity = daPointDao.selectOne(wrapper); return ConvertUtils.sourceToTarget(entity, DaPointDTO.class); } @@ -216,7 +215,7 @@ public List<DaPointDTO> getByNos(List<String> pointNos) { QueryWrapper<DaPointEntity> wrapper = new QueryWrapper<>(); wrapper.in("point_no", pointNos); - List<DaPointEntity> list = baseDao.selectList(wrapper); + List<DaPointEntity> list = daPointDao.selectList(wrapper); return ConvertUtils.sourceToTarget(list, DaPointDTO.class); } @@ -226,7 +225,7 @@ wrapper.eq("point_no", dto.getPointNo()); DaPointEntity entity = new DaPointEntity(); entity.setDefaultValue(dto.getDefaultValue()); - baseDao.update(entity, wrapper); + daPointDao.update(entity, wrapper); } @Override @@ -238,7 +237,7 @@ DaPointEntity entity = new DaPointEntity(); entity.setId(item); entity.setIsEnable(IsEnableEnum.ENABLE.value()); - baseDao.updateById(entity); + daPointDao.updateById(entity); }); } @@ -251,7 +250,7 @@ DaPointEntity entity = new DaPointEntity(); entity.setId(item); entity.setIsEnable(IsEnableEnum.DISABLE.value()); - baseDao.updateById(entity); + daPointDao.updateById(entity); }); } } \ No newline at end of file -- Gitblit v1.9.3