yudao-module-bi/src/main/java/cn/iocoder/yudao/module/bi/controller/admin/config/BiWarehouseCoordinateController.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,40 @@ package cn.iocoder.yudao.module.bi.controller.admin.config; import cn.iocoder.yudao.framework.common.pojo.CommonResult; import cn.iocoder.yudao.module.bi.dal.dataobject.BiWarehouseCoordinateDO; import cn.iocoder.yudao.module.bi.service.config.BiWarehouseCoordinateService; import io.swagger.v3.oas.annotations.Operation; import io.swagger.v3.oas.annotations.tags.Tag; import jakarta.annotation.Resource; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; import java.util.List; import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success; @Tag(name = "管çåå° - BI ä»åºåæ é ç½®") @RestController @RequestMapping("/bi/warehouse-coordinate") @Validated public class BiWarehouseCoordinateController { @Resource private BiWarehouseCoordinateService service; @GetMapping("/list") @Operation(summary = "è·åå ¨é¨ä»åºåæ ") public CommonResult<List<BiWarehouseCoordinateDO>> list() { return success(service.listAll()); } @PostMapping("/batch-save") @Operation(summary = "æ¹éä¿åä»åºåæ ") @PreAuthorize("@ss.hasPermission('bi:warehouse-coordinate:update')") public CommonResult<Boolean> batchSave(@RequestBody List<BiWarehouseCoordinateDO> list) { service.batchSave(list); return success(true); } } yudao-module-bi/src/main/java/cn/iocoder/yudao/module/bi/dal/dataobject/BiWarehouseCoordinateDO.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,37 @@ package cn.iocoder.yudao.module.bi.dal.dataobject; import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.*; /** * ä»åºåæ é ç½® DO * * @author äº */ @TableName("bi_warehouse_coordinate") @Data @EqualsAndHashCode(callSuper = true) @ToString(callSuper = true) @Builder @NoArgsConstructor @AllArgsConstructor public class BiWarehouseCoordinateDO extends BaseDO { @TableId private Long id; /** ä»åºåç§° */ private String name; /** ç»åº¦ */ private Double longitude; /** 纬度 */ private Double latitude; /** æåº */ private Integer sort; } yudao-module-bi/src/main/java/cn/iocoder/yudao/module/bi/dal/mysql/BiWarehouseCoordinateMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,15 @@ package cn.iocoder.yudao.module.bi.dal.mysql; import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX; import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; import cn.iocoder.yudao.module.bi.dal.dataobject.BiWarehouseCoordinateDO; import org.apache.ibatis.annotations.Mapper; @Mapper public interface BiWarehouseCoordinateMapper extends BaseMapperX<BiWarehouseCoordinateDO> { default BiWarehouseCoordinateDO selectByName(String name) { return selectOne(new LambdaQueryWrapperX<BiWarehouseCoordinateDO>() .eq(BiWarehouseCoordinateDO::getName, name)); } } yudao-module-bi/src/main/java/cn/iocoder/yudao/module/bi/enums/ErrorCodeConstants.java
@@ -22,4 +22,7 @@ ErrorCode BI_DATA_SOURCE_CONFIG_NOT_EXISTS = new ErrorCode(1_080_101, "æ°æ®æºé ç½®ä¸åå¨"); ErrorCode BI_DATA_SOURCE_CONFIG_IS_DISABLE = new ErrorCode(1_080_102, "æ°æ®æºé 置已ç¦ç¨"); // ========== ä»åºåæ é ç½®ç¸å ³ 1-080-151 ~ 1-080-170 ========== ErrorCode BI_WAREHOUSE_COORDINATE_NOT_EXISTS = new ErrorCode(1_080_151, "ä»åºåæ é ç½®ä¸åå¨"); } yudao-module-bi/src/main/java/cn/iocoder/yudao/module/bi/service/config/BiWarehouseCoordinateService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,20 @@ package cn.iocoder.yudao.module.bi.service.config; import cn.iocoder.yudao.module.bi.dal.dataobject.BiWarehouseCoordinateDO; import java.util.List; /** * ä»åºåæ é ç½® Service * * @author äº */ public interface BiWarehouseCoordinateService { /** æ¥è¯¢å ¨é¨åæ */ List<BiWarehouseCoordinateDO> listAll(); /** æ¹éä¿ååæ */ void batchSave(List<BiWarehouseCoordinateDO> list); } yudao-module-bi/src/main/java/cn/iocoder/yudao/module/bi/service/config/BiWarehouseCoordinateServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,38 @@ package cn.iocoder.yudao.module.bi.service.config; import cn.iocoder.yudao.module.bi.dal.dataobject.BiWarehouseCoordinateDO; import cn.iocoder.yudao.module.bi.dal.mysql.BiWarehouseCoordinateMapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import jakarta.annotation.Resource; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.util.List; /** * ä»åºåæ é ç½® Service å®ç° * * @author äº */ @Service public class BiWarehouseCoordinateServiceImpl implements BiWarehouseCoordinateService { @Resource private BiWarehouseCoordinateMapper mapper; @Override public List<BiWarehouseCoordinateDO> listAll() { return mapper.selectList(Wrappers.emptyWrapper()); } @Override @Transactional(rollbackFor = Exception.class) public void batchSave(List<BiWarehouseCoordinateDO> list) { mapper.delete(Wrappers.emptyWrapper()); for (BiWarehouseCoordinateDO item : list) { item.setId(null); mapper.insert(item); } } }