From 26cacfd543f22efd1a3409c954d64efb0c7ae544 Mon Sep 17 00:00:00 2001
From: shenyijian <1178253012@qq.com>
Date: Thu, 13 Jun 2024 14:49:57 +0800
Subject: [PATCH] 湖北水库：施工：项目列表
---
skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DO/SgProjectInfoDO.java | 166 +++++++++++++++++++++++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProjectInfoServiceImpl.java | 29 ++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.java | 21 +++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/SgProjectInfoService.java | 20 +++
skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DTO/ProjectSearchDTO.java | 12 ++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.xml | 14 ++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/controller/SgProjectInfoController.java | 39 ++++++
7 files changed, 301 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DO/SgProjectInfoDO.java b/skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DO/SgProjectInfoDO.java
new file mode 100644
index 0000000..25d5ac6
--- /dev/null
+++ b/skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DO/SgProjectInfoDO.java
@@ -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;
+}
diff --git a/skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DTO/ProjectSearchDTO.java b/skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DTO/ProjectSearchDTO.java
new file mode 100644
index 0000000..43dc59f
--- /dev/null
+++ b/skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DTO/ProjectSearchDTO.java
@@ -0,0 +1,12 @@
+package cn.gistack.sm.sg.DTO;
+
+import lombok.Data;
+
+/**
+ * 查询类
+ */
+@Data
+public class ProjectSearchDTO {
+ private String projectName;
+ private String skName;
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/controller/SgProjectInfoController.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/controller/SgProjectInfoController.java
new file mode 100644
index 0000000..d5ce7d3
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/controller/SgProjectInfoController.java
@@ -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);
+ }
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.java
new file mode 100644
index 0000000..3ec42e3
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.java
@@ -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);
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.xml
new file mode 100644
index 0000000..23e694a
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.xml
@@ -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>
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/SgProjectInfoService.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/SgProjectInfoService.java
new file mode 100644
index 0000000..56690fe
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/SgProjectInfoService.java
@@ -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);
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProjectInfoServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProjectInfoServiceImpl.java
new file mode 100644
index 0000000..a81cf97
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/service/impl/SgProjectInfoServiceImpl.java
@@ -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);
+ }
+}
--
Gitblit v1.9.3