单位工程管理

邱宇豪

2023-09-20 c152e96d408f8792b8582440955df930999f5481

单位工程管理

 hd/pipe/engineeringManage/src/main/java/com/thhy/engineering/modules/biz/engineering/entity/SysSegment.java

@@ -62,4 +62,30 @@
     * @mbg.generated Fri Mar 31 14:17:37 CST 2023
     */
    private static final long serialVersionUID = 1L;

    /**
     * 起讫里程
     */
    private String mileage;

    /**
     * 单位工程名称
     */
    private String unitProjectName;

    /**
     * 开始时间
     */
    private Date startTime;

    /**
     * 结束时间
     */
    private Date endTime;

    /**
     * 工期
     */
    private String duration;

}

 hd/pipe/engineeringManage/src/main/resources/mapping/SysProjectMapper.xml

@@ -387,6 +387,40 @@
      <if test="createUser != null">
        create_user = #{createUser,jdbcType=VARCHAR},
      </if>

        <if test="createUnit != null">
            create_unit = #{createUnit,jdbcType=VARCHAR},
        </if>
        <if test="planUnit != null">
            plan_unit = #{planUnit,jdbcType=VARCHAR},
        </if>
        <if test="supervisionUnit != null">
            supervision_unit = #{supervisionUnit,jdbcType=VARCHAR},
        </if>
        <if test="constructionUnit != null">
            construction_unit = #{constructionUnit,jdbcType=VARCHAR},
        </if>
        <if test="outsideDiameter != null">
            outside_diameter = #{outsideDiameter,jdbcType=DOUBLE},
        </if>
        <if test="innerDiameter != null">
            inner_diameter = #{innerDiameter,jdbcType=DOUBLE},
        </if>
        <if test="thickness != null">
            thickness = #{thickness,jdbcType=DOUBLE},
        </if>
        <if test="ringWidth != null">
            ring_width = #{ringWidth,jdbcType=DOUBLE},
        </if>
        <if test="concreteStrengthGrade != null">
            concrete_strength_grade = #{concreteStrengthGrade,jdbcType=VARCHAR},
        </if>
        <if test="impermeabilityLevel != null">
            impermeability_level = #{impermeabilityLevel,jdbcType=VARCHAR},
        </if>
        <if test="waterproofType != null">
            waterproof_type = #{waterproofType,jdbcType=VARCHAR},
        </if>
    </set>
    where pro_id = #{proId,jdbcType=VARCHAR}
  </update>

 hd/pipe/engineeringManage/src/main/resources/mapping/SysSegmentMapper.xml

@@ -14,6 +14,11 @@
    <result column="shield_enp" jdbcType="VARCHAR" property="shieldEnp" />
    <result column="station" jdbcType="VARCHAR" property="station" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
      <result column="mileage" jdbcType="VARCHAR" property="mileage" />
      <result column="unit_project_name" jdbcType="VARCHAR" property="unitProjectName" />
      <result column="start_time" jdbcType="DATE" property="startTime" />
      <result column="end_time" jdbcType="DATE" property="endTime" />
      <result column="duration" jdbcType="VARCHAR" property="duration" />
  </resultMap>

  <select id="segmentNameByOne" parameterType="java.lang.String" resultType="java.lang.String" >
@@ -44,6 +49,21 @@
      <if test="createTime != null">
        create_time,
      </if>
        <if test="mileage != null">
            mileage,
        </if>
        <if test="unitProjectName != null">
            unit_project_name,
        </if>
        <if test="startTime != null">
            start_time,
        </if>
        <if test="endTime != null">
            end_time,
        </if>
        <if test="duration != null">
            duration,
        </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="segmentId != null">
@@ -67,6 +87,21 @@
      <if test="createTime != null">
        #{createTime,jdbcType=TIMESTAMP},
      </if>
        <if test="mileage != null">
            #{mileage,jdbcType=VARCHAR},
        </if>
        <if test="unitProjectName != null">
            #{unitProjectName,jdbcType=VARCHAR},
        </if>
        <if test="startTime != null">
            #{startTime,jdbcType=DATE},
        </if>
        <if test="endTime != null">
            #{endTime,jdbcType=DATE},
        </if>
        <if test="duration != null">
            #{duration,jdbcType=VARCHAR},
        </if>
    </trim>
  </insert>
  <insert id="segmentNeedInsert" >
@@ -108,10 +143,18 @@
         ss.shield_enp as shieldEnp,
         ss.station as station,
         ss.create_time as createTime,
         ss.mileage as mileage,
         ss.unit_project_name as unitProjectName,
         ss.start_time as startTime,
         ss.end_time as endTime,
         ss.duration as duration,
        sp.pro_name as proName,spu.real_name as realName from sys_segment ss
        left join sys_project sp on ss.pro_id=sp.pro_id
        left join sys_plat_user spu on ss.segment_admin=spu.user_id
        where ss.is_use=1
        <if test="unitProjectName!=null and unitProjectName!='' ">
          and ss.unit_project_name like concat('%',#{unitProjectName},'%')
        </if>
        <if test="segmentName!=null and segmentName!='' ">
          and ss.segment_name like concat('%',#{segmentName},'%')
        </if>
@@ -132,6 +175,11 @@
         ss.shield_enp as shieldEnp,
         ss.station as station,
         ss.create_time as createTime,
        ss.mileage as mileage,
        ss.unit_project_name as unitProjectName,
        ss.start_time as startTime,
        ss.end_time as endTime,
        ss.duration as duration,
        sp.pro_name,spu.real_name from sys_segment ss
        left join sys_project sp on ss.pro_id=sp.pro_id
        left join sys_plat_user spu on ss.segment_admin=spu.user_id
@@ -178,6 +226,21 @@
      <if test="createTime != null">
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
        <if test="mileage != null">
            mileage = #{mileage,jdbcType=VARCHAR},
        </if>
        <if test="unitProjectName != null">
            unit_project_name = #{unitProjectName,jdbcType=VARCHAR},
        </if>
        <if test="startTime != null">
            start_time = #{startTime,jdbcType=DATE},
        </if>
        <if test="endTime != null">
            end_time = #{endTime,jdbcType=DATE},
        </if>
        <if test="duration != null">
            duration = #{duration,jdbcType=VARCHAR},
        </if>
    </set>
    where segment_id = #{segmentId,jdbcType=VARCHAR}
  </update>