新增全景及业务附件表基础接口

zhongrj

2024-11-11 774e064befe434f974ae5e9700bd4c2913868fd4

新增全景及业务附件表基础接口

 src/main/java/org/springblade/common/utils/ShapeFileUtil.java

@@ -305,10 +305,16 @@
                    if (json.getJSONObject("properties").get("Name")!= null) {
                        shpDTO.put("name",json.getJSONObject("properties").getString("Name"));
                    }
                    if (json.getJSONObject("properties").get("TYPE")!= null) {
                        shpDTO.put("name",json.getJSONObject("properties").getString("TYPE"));
                    }
                    // 所属公司名称
                    if (json.getJSONObject("properties").get("name_1")!= null) {
                        shpDTO.put("firmName",json.getJSONObject("properties").getString("name_1"));
                    }
                    if (json.getJSONObject("properties").get("QYMC")!= null) {
                        shpDTO.put("firmName",json.getJSONObject("properties").getString("QYMC"));
                    }
                    dtoList.add(shpDTO);
                } catch (NumberFormatException e) {
                    System.err.println("处理单个特征时发生错误：" + e.getMessage());

 src/main/java/org/springblade/modules/yw/controller/PanoramicController.java

New file
@@ -0,0 +1,106 @@
package org.springblade.modules.yw.controller;

import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
import lombok.AllArgsConstructor;
import javax.validation.Valid;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.Func;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springblade.modules.yw.entity.PanoramicEntity;
import org.springblade.modules.yw.vo.PanoramicVO;
import org.springblade.modules.yw.service.IPanoramicService;
import springfox.documentation.annotations.ApiIgnore;
import java.util.Map;

/**
 * 全景表 控制器
 *
 * @author BladeX
 * @since 2024-11-11
 */
@RestController
@AllArgsConstructor
@RequestMapping("yw/panoramic")
@Api(value = "全景表", tags = "全景表接口")
public class PanoramicController {

    private final IPanoramicService panoramicService;

    /**
     * 全景表 详情
     */
    @GetMapping("/detail")
    @ApiOperationSupport(order = 1)
    @ApiOperation(value = "详情", notes = "传入panoramic")
    public R<PanoramicEntity> detail(PanoramicEntity panoramic) {
        PanoramicEntity detail = panoramicService.getOne(Condition.getQueryWrapper(panoramic));
        return R.data(detail);
    }
    /**
     * 全景表 分页
     */
    @GetMapping("/list")
    @ApiOperationSupport(order = 2)
    @ApiOperation(value = "分页", notes = "传入panoramic")
    public R<IPage<PanoramicEntity>> list(@ApiIgnore @RequestParam Map<String, Object> panoramic, Query query) {
        IPage<PanoramicEntity> pages = panoramicService.page(Condition.getPage(query), Condition.getQueryWrapper(panoramic, PanoramicEntity.class));
        return R.data(pages);
    }

    /**
     * 全景表 自定义分页
     */
    @GetMapping("/page")
    @ApiOperationSupport(order = 3)
    @ApiOperation(value = "分页", notes = "传入panoramic")
    public R<IPage<PanoramicVO>> page(PanoramicVO panoramic, Query query) {
        IPage<PanoramicVO> pages = panoramicService.selectPanoramicPage(Condition.getPage(query), panoramic);
        return R.data(pages);
    }

    /**
     * 全景表 新增
     */
    @PostMapping("/save")
    @ApiOperationSupport(order = 4)
    @ApiOperation(value = "新增", notes = "传入panoramic")
    public R save(@Valid @RequestBody PanoramicEntity panoramic) {
        return R.status(panoramicService.save(panoramic));
    }

    /**
     * 全景表 修改
     */
    @PostMapping("/update")
    @ApiOperationSupport(order = 5)
    @ApiOperation(value = "修改", notes = "传入panoramic")
    public R update(@Valid @RequestBody PanoramicEntity panoramic) {
        return R.status(panoramicService.updateById(panoramic));
    }

    /**
     * 全景表 新增或修改
     */
    @PostMapping("/submit")
    @ApiOperationSupport(order = 6)
    @ApiOperation(value = "新增或修改", notes = "传入panoramic")
    public R submit(@Valid @RequestBody PanoramicEntity panoramic) {
        return R.status(panoramicService.saveOrUpdate(panoramic));
    }

    /**
     * 全景表 删除
     */
    @PostMapping("/remove")
    @ApiOperationSupport(order = 7)
    @ApiOperation(value = "逻辑删除", notes = "传入ids")
    public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
        return R.status(panoramicService.removeByIds(Func.toLongList(ids)));
    }
}

 src/main/java/org/springblade/modules/yw/controller/YwAttachController.java

New file
@@ -0,0 +1,106 @@
package org.springblade.modules.yw.controller;

import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
import lombok.AllArgsConstructor;
import javax.validation.Valid;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.Func;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springblade.modules.yw.entity.YwAttachEntity;
import org.springblade.modules.yw.vo.YwAttachVO;
import org.springblade.modules.yw.service.IYwAttachService;
import springfox.documentation.annotations.ApiIgnore;
import java.util.Map;

/**
 * 业务附件表 控制器
 *
 * @author BladeX
 * @since 2024-11-11
 */
@RestController
@AllArgsConstructor
@RequestMapping("yw/attach")
@Api(value = "业务附件表", tags = "业务附件表接口")
public class YwAttachController {

    private final IYwAttachService attachService;

    /**
     * 业务附件表 详情
     */
    @GetMapping("/detail")
    @ApiOperationSupport(order = 1)
    @ApiOperation(value = "详情", notes = "传入attach")
    public R<YwAttachEntity> detail(YwAttachEntity attach) {
        YwAttachEntity detail = attachService.getOne(Condition.getQueryWrapper(attach));
        return R.data(detail);
    }
    /**
     * 业务附件表 分页
     */
    @GetMapping("/list")
    @ApiOperationSupport(order = 2)
    @ApiOperation(value = "分页", notes = "传入attach")
    public R<IPage<YwAttachEntity>> list(@ApiIgnore @RequestParam Map<String, Object> attach, Query query) {
        IPage<YwAttachEntity> pages = attachService.page(Condition.getPage(query), Condition.getQueryWrapper(attach, YwAttachEntity.class));
        return R.data(pages);
    }

    /**
     * 业务附件表 自定义分页
     */
    @GetMapping("/page")
    @ApiOperationSupport(order = 3)
    @ApiOperation(value = "分页", notes = "传入attach")
    public R<IPage<YwAttachVO>> page(YwAttachVO attach, Query query) {
        IPage<YwAttachVO> pages = attachService.selectAttachPage(Condition.getPage(query), attach);
        return R.data(pages);
    }

    /**
     * 业务附件表 新增
     */
    @PostMapping("/save")
    @ApiOperationSupport(order = 4)
    @ApiOperation(value = "新增", notes = "传入attach")
    public R save(@Valid @RequestBody YwAttachEntity attach) {
        return R.status(attachService.save(attach));
    }

    /**
     * 业务附件表 修改
     */
    @PostMapping("/update")
    @ApiOperationSupport(order = 5)
    @ApiOperation(value = "修改", notes = "传入attach")
    public R update(@Valid @RequestBody YwAttachEntity attach) {
        return R.status(attachService.updateById(attach));
    }

    /**
     * 业务附件表 新增或修改
     */
    @PostMapping("/submit")
    @ApiOperationSupport(order = 6)
    @ApiOperation(value = "新增或修改", notes = "传入attach")
    public R submit(@Valid @RequestBody YwAttachEntity attach) {
        return R.status(attachService.saveOrUpdate(attach));
    }

    /**
     * 业务附件表 删除
     */
    @PostMapping("/remove")
    @ApiOperationSupport(order = 7)
    @ApiOperation(value = "逻辑删除", notes = "传入ids")
    public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
        return R.status(attachService.removeByIds(Func.toLongList(ids)));
    }
}

 src/main/java/org/springblade/modules/yw/entity/PanoramicEntity.java

New file
@@ -0,0 +1,100 @@
package org.springblade.modules.yw.entity;

import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;

import java.io.Serializable;
import java.util.Date;

/**
 * 全景表 实体类
 *
 * @author BladeX
 * @since 2024-11-11
 */
@Data
@TableName("yw_panoramic")
@ApiModel(value = "Panoramic对象", description = "全景表")
public class PanoramicEntity implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
     * 主键id
     */
    @ApiModelProperty(value = "主键ID", example = "")
    @TableId(value = "id",type = IdType.ASSIGN_ID)
    private Long id;

    /**
     * 企业id
     */
    @ApiModelProperty(value = "企业id")
    private Long firmId;
    /**
     * 全景名称
     */
    @ApiModelProperty(value = "全景名称")
    private String name;
    /**
     * 经度
     */
    @ApiModelProperty(value = "经度")
    private String lng;
    /**
     * 纬度
     */
    @ApiModelProperty(value = "纬度")
    private String lat;
    /**
     * 全景地址url
     */
    @ApiModelProperty(value = "全景地址url")
    private String url;
    /**
     * 备注
     */
    @ApiModelProperty(value = "备注")
    private String remark;
    /**
     * 创建人
     */
    @ApiModelProperty(value = "创建人", example = "")
    @TableField(value = "create_user", fill = FieldFill.INSERT)
    private Long createUser;

    /**
     * 创建时间
     */
    @ApiModelProperty(value = "创建时间", example = "")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @TableField(value = "create_time", fill = FieldFill.INSERT)
    private Date createTime;

    /**
     * 更新人
     */
    @ApiModelProperty(value = "更新人", example = "")
    @TableField("update_user")
    private Long updateUser;

    /**
     * 更新人时间
     */
    @ApiModelProperty(value = "更新人时间", example = "")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @TableField(value = "update_time", fill = FieldFill.INSERT)
    private Date updateTime;

    /**
     * 是否删除 0：否  1：是
     */
    @ApiModelProperty(value = "是否删除 0：否  1：是", example = "")
    @TableField("is_deleted")
    @TableLogic
    private Integer isDeleted;

}

 src/main/java/org/springblade/modules/yw/entity/YwAttachEntity.java

New file
@@ -0,0 +1,90 @@
package org.springblade.modules.yw.entity;

import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;

import java.io.Serializable;
import java.util.Date;

/**
 * 业务附件表 实体类
 *
 * @author BladeX
 * @since 2024-11-11
 */
@Data
@TableName("yw_attach")
@ApiModel(value = "Attach对象", description = "业务附件表")
public class YwAttachEntity implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
     * 主键id
     */
    @ApiModelProperty(value = "主键ID", example = "")
    @TableId(value = "id",type = IdType.ASSIGN_ID)
    private Long id;

    /**
     * 企业id
     */
    @ApiModelProperty(value = "企业id")
    private Long firmId;
    /**
     * 名称
     */
    @ApiModelProperty(value = "名称")
    private String name;
    /**
     * url
     */
    @ApiModelProperty(value = "url")
    private String link;
    /**
     * 备注
     */
    @ApiModelProperty(value = "备注")
    private String remark;
    /**
     * 创建人
     */
    @ApiModelProperty(value = "创建人", example = "")
    @TableField(value = "create_user", fill = FieldFill.INSERT)
    private Long createUser;

    /**
     * 创建时间
     */
    @ApiModelProperty(value = "创建时间", example = "")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @TableField(value = "create_time", fill = FieldFill.INSERT)
    private Date createTime;

    /**
     * 更新人
     */
    @ApiModelProperty(value = "更新人", example = "")
    @TableField("update_user")
    private Long updateUser;

    /**
     * 更新人时间
     */
    @ApiModelProperty(value = "更新人时间", example = "")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @TableField(value = "update_time", fill = FieldFill.INSERT)
    private Date updateTime;

    /**
     * 是否删除 0：否  1：是
     */
    @ApiModelProperty(value = "是否删除 0：否  1：是", example = "")
    @TableField("is_deleted")
    @TableLogic
    private Integer isDeleted;

}

 src/main/java/org/springblade/modules/yw/mapper/IYwAttachService.xml

New file
@@ -0,0 +1,24 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.springblade.modules.yw.mapper.YwAttachMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="attachResultMap" type="org.springblade.modules.yw.entity.YwAttachEntity">
        <result column="id" property="id"/>
        <result column="firm_id" property="firmId"/>
        <result column="name" property="name"/>
        <result column="link" property="link"/>
        <result column="remark" property="remark"/>
        <result column="create_user" property="createUser"/>
        <result column="create_time" property="createTime"/>
        <result column="update_user" property="updateUser"/>
        <result column="update_time" property="updateTime"/>
        <result column="is_deleted" property="isDeleted"/>
    </resultMap>


    <select id="selectAttachPage" resultMap="attachResultMap">
        select * from yw_attach where is_deleted = 0
    </select>

</mapper>

 src/main/java/org/springblade/modules/yw/mapper/IndParkInfoMapper.xml

File was deleted

 src/main/java/org/springblade/modules/yw/mapper/PanoramicMapper.java

New file
@@ -0,0 +1,26 @@
package org.springblade.modules.yw.mapper;

import org.springblade.modules.yw.entity.PanoramicEntity;
import org.springblade.modules.yw.vo.PanoramicVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;

/**
 * 全景表 Mapper 接口
 *
 * @author BladeX
 * @since 2024-11-11
 */
public interface PanoramicMapper extends BaseMapper<PanoramicEntity> {

    /**
     * 自定义分页
     *
     * @param page
     * @param panoramic
     * @return
     */
    List<PanoramicVO> selectPanoramicPage(IPage page, PanoramicVO panoramic);

}

 src/main/java/org/springblade/modules/yw/mapper/PanoramicMapper.xml

New file
@@ -0,0 +1,26 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.springblade.modules.yw.mapper.PanoramicMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="panoramicResultMap" type="org.springblade.modules.yw.entity.PanoramicEntity">
        <result column="id" property="id"/>
        <result column="firm_id" property="firmId"/>
        <result column="name" property="name"/>
        <result column="lng" property="lng"/>
        <result column="lat" property="lat"/>
        <result column="url" property="url"/>
        <result column="remark" property="remark"/>
        <result column="create_user" property="createUser"/>
        <result column="create_time" property="createTime"/>
        <result column="update_user" property="updateUser"/>
        <result column="update_time" property="updateTime"/>
        <result column="is_deleted" property="isDeleted"/>
    </resultMap>


    <select id="selectPanoramicPage" resultMap="panoramicResultMap">
        select * from yw_panoramic where is_deleted = 0
    </select>

</mapper>

 src/main/java/org/springblade/modules/yw/mapper/YwAttachMapper.java

New file
@@ -0,0 +1,26 @@
package org.springblade.modules.yw.mapper;

import org.springblade.modules.yw.entity.YwAttachEntity;
import org.springblade.modules.yw.vo.YwAttachVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;

/**
 * 业务附件表 Mapper 接口
 *
 * @author BladeX
 * @since 2024-11-11
 */
public interface YwAttachMapper extends BaseMapper<YwAttachEntity> {

    /**
     * 自定义分页
     *
     * @param page
     * @param attach
     * @return
     */
    List<YwAttachVO> selectAttachPage(IPage page, YwAttachVO attach);

}

 src/main/java/org/springblade/modules/yw/service/IPanoramicService.java

New file
@@ -0,0 +1,24 @@
package org.springblade.modules.yw.service;

import com.baomidou.mybatisplus.extension.service.IService;
import org.springblade.modules.yw.entity.PanoramicEntity;
import org.springblade.modules.yw.vo.PanoramicVO;
import com.baomidou.mybatisplus.core.metadata.IPage;

/**
 * 全景表 服务类
 *
 * @author BladeX
 * @since 2024-11-11
 */
public interface IPanoramicService extends IService<PanoramicEntity> {
    /**
     * 自定义分页
     *
     * @param page
     * @param panoramic
     * @return
     */
    IPage<PanoramicVO> selectPanoramicPage(IPage<PanoramicVO> page, PanoramicVO panoramic);

}

 src/main/java/org/springblade/modules/yw/service/IYwAttachService.java

New file
@@ -0,0 +1,24 @@
package org.springblade.modules.yw.service;

import com.baomidou.mybatisplus.extension.service.IService;
import org.springblade.modules.yw.entity.YwAttachEntity;
import org.springblade.modules.yw.vo.YwAttachVO;
import com.baomidou.mybatisplus.core.metadata.IPage;

/**
 * 业务附件表 服务类
 *
 * @author BladeX
 * @since 2024-11-11
 */
public interface IYwAttachService extends IService<YwAttachEntity> {
    /**
     * 自定义分页
     *
     * @param page
     * @param attach
     * @return
     */
    IPage<YwAttachVO> selectAttachPage(IPage<YwAttachVO> page, YwAttachVO attach);

}

 src/main/java/org/springblade/modules/yw/service/impl/GeomInfoServiceImpl.java

@@ -146,7 +146,7 @@
    private void setFirmId(GeomInfoEntity geomInfoEntity,String firmName) {
        if (!Strings.isBlank(firmName)) {
            QueryWrapper<FirmInfo> wrapper = new QueryWrapper<>();
            wrapper.eq("name", firmName);
            wrapper.like("name", '%' +firmName + '%');
            FirmInfo one = firmInfoService.getOne(wrapper);
            if (null!=one)
                geomInfoEntity.setFirmId(one.getId());

 src/main/java/org/springblade/modules/yw/service/impl/PanoramicServiceImpl.java

New file
@@ -0,0 +1,25 @@
package org.springblade.modules.yw.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.modules.yw.entity.PanoramicEntity;
import org.springblade.modules.yw.vo.PanoramicVO;
import org.springblade.modules.yw.mapper.PanoramicMapper;
import org.springblade.modules.yw.service.IPanoramicService;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.core.metadata.IPage;

/**
 * 全景表 服务实现类
 *
 * @author BladeX
 * @since 2024-11-11
 */
@Service
public class PanoramicServiceImpl extends ServiceImpl<PanoramicMapper, PanoramicEntity> implements IPanoramicService {

    @Override
    public IPage<PanoramicVO> selectPanoramicPage(IPage<PanoramicVO> page, PanoramicVO panoramic) {
        return page.setRecords(baseMapper.selectPanoramicPage(page, panoramic));
    }

}

 src/main/java/org/springblade/modules/yw/service/impl/YwAttachServiceImpl.java

New file
@@ -0,0 +1,25 @@
package org.springblade.modules.yw.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.modules.yw.entity.YwAttachEntity;
import org.springblade.modules.yw.vo.YwAttachVO;
import org.springblade.modules.yw.mapper.YwAttachMapper;
import org.springblade.modules.yw.service.IYwAttachService;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.core.metadata.IPage;

/**
 * 业务附件表 服务实现类
 *
 * @author BladeX
 * @since 2024-11-11
 */
@Service
public class YwAttachServiceImpl extends ServiceImpl<YwAttachMapper, YwAttachEntity> implements IYwAttachService {

    @Override
    public IPage<YwAttachVO> selectAttachPage(IPage<YwAttachVO> page, YwAttachVO attach) {
        return page.setRecords(baseMapper.selectAttachPage(page, attach));
    }

}

 src/main/java/org/springblade/modules/yw/vo/PanoramicVO.java

New file
@@ -0,0 +1,16 @@
package org.springblade.modules.yw.vo;

import org.springblade.modules.yw.entity.PanoramicEntity;
import lombok.Data;

/**
 * 全景表 视图实体类
 *
 * @author BladeX
 * @since 2024-11-11
 */
@Data
public class PanoramicVO extends PanoramicEntity {
    private static final long serialVersionUID = 1L;

}

 src/main/java/org/springblade/modules/yw/vo/YwAttachVO.java

New file
@@ -0,0 +1,16 @@
package org.springblade.modules.yw.vo;

import org.springblade.modules.yw.entity.YwAttachEntity;
import lombok.Data;

/**
 * 业务附件表 视图实体类
 *
 * @author BladeX
 * @since 2024-11-11
 */
@Data
public class YwAttachVO extends YwAttachEntity {
    private static final long serialVersionUID = 1L;

}