skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DO/SgProjectInfoDO.java
New file @@ -0,0 +1,166 @@ package cn.gistack.sm.sg.DO; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Getter; import lombok.Setter; import java.io.Serializable; import java.time.LocalDateTime; /** * <p> * 施工项目表 * </p> * * @author shenyijian * @since 2024-06-13 11:51:20 */ @Getter @Setter @TableName("SG_PROJECT_INFO") public class SgProjectInfoDO implements Serializable { private static final long serialVersionUID = 1L; private Long id; /** * 项目名称 */ private String projectName; /** * 项目编号 */ private String projectCode; /** * 所属标段 */ private String inspectionPerson; /** * 建设期次 */ private String buildStage; /** * 项目地址 */ private String projectAddress; /** * 备案号 */ private String filingCode; /** * 经纬度 */ private String lonLat; /** * 维护负责人 */ private String responsiblePerson; /** * 昨程方式 */ private String remoteMethod; /** * 注册到期时间 */ private LocalDateTime expTime; /** * 总承包 */ private String generalContract; /** * 总承包责任人 */ private String generalPerson; /** * 设计单位 */ private String designUnit; /** * 设计单位责任人 */ private String designPerson; /** * 监理单位 */ private String controlUnit; /** * 监理单位责任人 */ private String controlPerson; /** * 施工单位 */ private String constructionUnit; /** * 施工单位责任人 */ private String constructionPerson; /** * 施工自检单位 */ private String selfUnit; /** * 施工自检单位责任人 */ private String selfPerson; /** * 竣工验收检测单位 */ private String acceptanceUnit; /** * 竣工验收检测单位责任人 */ private String acceptancePerson; /** * 水库ID */ private String skId; /** * 创建人 */ private Long createUser; /** * 创建时间 */ private LocalDateTime createTime; /** * 修改人 */ private Long updateUser; /** * 修改时间 */ private LocalDateTime updateTime; /** * 水库名 */ private String skName; } skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DTO/ProjectSearchDTO.java
New file @@ -0,0 +1,12 @@ package cn.gistack.sm.sg.DTO; import lombok.Data; /** * 查询类 */ @Data public class ProjectSearchDTO { private String projectName; private String skName; } skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/controller/SgProjectInfoController.java
New file @@ -0,0 +1,39 @@ package cn.gistack.sm.sg.controller; import cn.gistack.sm.patrol.entity.PatrolInfo; import cn.gistack.sm.sg.DO.SgProjectInfoDO; import cn.gistack.sm.sg.DTO.ProjectSearchDTO; import cn.gistack.sm.sg.service.SgProjectInfoService; import com.baomidou.mybatisplus.core.metadata.IPage; import io.swagger.annotations.ApiOperation; import org.springblade.core.boot.ctrl.BladeController; import org.springblade.core.mp.support.Condition; import org.springblade.core.mp.support.Query; import org.springblade.core.tool.api.R; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; /** * <p> * 施工项目表 前端控制器 * </p> * * @author shenyijian * @since 2024-06-13 11:51:20 */ @RestController @RequestMapping("/sg_project_info") public class SgProjectInfoController extends BladeController { @Autowired private SgProjectInfoService sgProjectInfoService; /** * 分页列表查询 */ @GetMapping(value = "/list") public R queryPageList(ProjectSearchDTO searchDTO, Query query) { IPage<SgProjectInfoDO> page = sgProjectInfoService.queryPageList(Condition.getPage(query), searchDTO); return R.data(page); } } skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.java
New file @@ -0,0 +1,21 @@ package cn.gistack.sm.sg.mapper; import cn.gistack.sm.sg.DO.SgProjectInfoDO; import cn.gistack.sm.sg.DTO.ProjectSearchDTO; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import org.apache.ibatis.annotations.Param; import java.util.List; /** * <p> * 施工项目表 Mapper 接口 * </p> * * @author shenyijian * @since 2024-06-13 11:51:20 */ public interface SgProjectInfoMapper extends BaseMapper<SgProjectInfoDO> { List<SgProjectInfoDO> queryPageList(@Param("dto") ProjectSearchDTO dto); } skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.xml
New file @@ -0,0 +1,14 @@ <?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="cn.gistack.sm.sg.mapper.SgProjectInfoMapper"> <select id="queryPageList" resultType="cn.gistack.sm.sg.DO.SgProjectInfoDO"> select * from YWXT.SG_PROJECT_INFO info where 1=1 <if test="dto.projectName != null and dto.projectName != ''"> and info.project_name = #{dto.projectName} </if> <if test="dto.skName != null and dto.skName != ''"> and info.sk_name = #{dto.skName} </if> </select> </mapper> skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/SgProjectInfoService.java
New file @@ -0,0 +1,20 @@ package cn.gistack.sm.sg.service; import cn.gistack.sm.patrol.entity.PatrolInfo; import cn.gistack.sm.sg.DO.SgProjectInfoDO; import cn.gistack.sm.sg.DTO.ProjectSearchDTO; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.IService; /** * <p> * 施工项目表 服务类 * </p> * * @author shenyijian * @since 2024-06-13 11:51:20 */ public interface SgProjectInfoService extends IService<SgProjectInfoDO> { IPage<SgProjectInfoDO> queryPageList(IPage<SgProjectInfoDO> page, ProjectSearchDTO searchDTO); } skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProjectInfoServiceImpl.java
New file @@ -0,0 +1,29 @@ package cn.gistack.sm.sg.service.impl; import cn.gistack.sm.sg.DO.SgProjectInfoDO; import cn.gistack.sm.sg.DTO.ProjectSearchDTO; import cn.gistack.sm.sg.mapper.SgProjectInfoMapper; import cn.gistack.sm.sg.service.SgProjectInfoService; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.springframework.stereotype.Service; import java.util.List; /** * <p> * 施工项目表 服务实现类 * </p> * * @author shenyijian * @since 2024-06-13 11:51:20 */ @Service public class SgProjectInfoServiceImpl extends ServiceImpl<SgProjectInfoMapper, SgProjectInfoDO> implements SgProjectInfoService { @Override public IPage<SgProjectInfoDO> queryPageList(IPage<SgProjectInfoDO> page, ProjectSearchDTO searchDTO) { List<SgProjectInfoDO> sgProjectInfoDOS = baseMapper.queryPageList(searchDTO); return page.setRecords(sgProjectInfoDOS); } }
