update

张天森

2022-10-11 e7d874f3526403ee34307318594aa249b8505f11

update

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComEventTransferRecordMapper.java

@@ -39,4 +39,7 @@
     * @date 2022-09-07 11:23:52
     */
    List<ComEventTransferRecord> listByComEventTransferRecord(@Param("comEventTransferRecord") ComEventTransferRecord comEventTransferRecord);


    int insertSelective(ComEventTransferRecord comEventTransferRecord);
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComEventTransferRecordServiceImpl.java

@@ -60,7 +60,7 @@
            comEventTransferRecord.setId(Snowflake.getId());
        }
        comEventTransferRecord.setCreateAt(new Date());
        int i = comEventTransferRecordMapper.insert(comEventTransferRecord);
        int i = comEventTransferRecordMapper.insertSelective(comEventTransferRecord);
        if (!(i>0)) {
            return R.fail(ReturnMsgConstants.DATA_EXIST);
        }

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComEventTransferRecordMapper.xml

@@ -33,7 +33,7 @@
        id,event_id,parents_transfer_event_id,from_type,from_id,from_name,from_user_id,to_type,to_id,to_name,to_user_id,save,process_result,process_result_data,process_date,process_by,process_by_name,process_type,create_at,specialist_id,specialist_org,specialist_level,specialist_name,event_result,event_status
    </sql>

    <select id="pageByComEventTransferRecord" resultType="com.panzhihua.service_community.entity.ComEventTransferRecord">
    <select id="pageByComEventTransferRecord" resultType="com.panzhihua.service_community.entity.ComEventTransferRecord">
        SELECT <include refid="columns" />
        FROM com_sanshuo_event_transfer_record
    </select>
@@ -43,4 +43,181 @@
        FROM com_sanshuo_event_transfer_record
    </select>

    <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.panzhihua.service_community.entity.ComEventTransferRecord">
    insert into com_sanshuo_event_transfer_record
    <trim prefix="(" suffix=")" suffixOverrides=",">
        <if test="id != null">
            id,
        </if>
        <if test="eventId != null">
            event_id,
        </if>
        <if test="parentsTransferEventId != null">
            parents_transfer_event_id,
        </if>
        <if test="fromType != null">
            from_type,
        </if>
        <if test="fromId != null">
            from_id,
        </if>
        <if test="fromName != null">
            from_name,
        </if>
        <if test="fromUserId != null">
            from_user_id,
        </if>
        <if test="toType != null">
            to_type,
        </if>
        <if test="toId != null">
            to_id,
        </if>
        <if test="toName != null">
            to_name,
        </if>
        <if test="toUserId != null">
            to_user_id,
        </if>
        <if test="save != null">
            `save`,
        </if>
        <if test="processResult != null">
            process_result,
        </if>
        <if test="processResultData != null">
            process_result_data,
        </if>
        <if test="processDate != null">
            process_date,
        </if>
        <if test="processBy != null">
            process_by,
        </if>
        <if test="processByName != null">
            process_by_name,
        </if>
        <if test="processType != null">
            process_type,
        </if>
        <if test="createAt != null">
            create_at,
        </if>
        <if test="specialistId != null">
            specialist_id,
        </if>
        <if test="specialistOrg != null">
            specialist_org,
        </if>
        <if test="specialistLevel != null">
            specialist_level,
        </if>
        <if test="specialistName != null">
            specialist_name,
        </if>
        <if test="eventResult != null">
            event_result,
        </if>
        <if test="eventStatus != null">
            event_status,
        </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
        <if test="id != null">
            #{id,jdbcType=BIGINT},
        </if>
        <if test="eventId != null">
            #{eventId,jdbcType=BIGINT},
        </if>
        <if test="parentsTransferEventId != null">
            #{parentsTransferEventId,jdbcType=BIGINT},
        </if>
        <if test="fromType != null">
            #{fromType,jdbcType=TINYINT},
        </if>
        <if test="fromId != null">
            #{fromId,jdbcType=BIGINT},
        </if>
        <if test="fromName != null">
            #{fromName,jdbcType=VARCHAR},
        </if>
        <if test="fromUserId != null">
            #{fromUserId,jdbcType=BIGINT},
        </if>
        <if test="toType != null">
            #{toType,jdbcType=TINYINT},
        </if>
        <if test="toId != null">
            #{toId,jdbcType=BIGINT},
        </if>
        <if test="toName != null">
            #{toName,jdbcType=VARCHAR},
        </if>
        <if test="toUserId != null">
            #{toUserId,jdbcType=BIGINT},
        </if>
        <if test="save != null">
            #{save,jdbcType=BIT},
        </if>
        <if test="processResult != null">
            #{processResult,jdbcType=VARCHAR},
        </if>
        <if test="processResultData != null">
            #{processResultData,jdbcType=VARCHAR},
        </if>
        <if test="processDate != null">
            #{processDate,jdbcType=TIMESTAMP},
        </if>
        <if test="processBy != null">
            #{processBy,jdbcType=BIGINT},
        </if>
        <if test="processByName != null">
            #{processByName,jdbcType=VARCHAR},
        </if>
        <if test="processType != null">
            #{processType,jdbcType=INTEGER},
        </if>
        <if test="createAt != null">
            #{createAt,jdbcType=TIMESTAMP},
        </if>
        <if test="specialistId != null">
            #{specialistId,jdbcType=BIGINT},
        </if>
        <if test="specialistOrg != null">
            #{specialistOrg,jdbcType=VARCHAR},
        </if>
        <if test="specialistLevel != null">
            #{specialistLevel,jdbcType=VARCHAR},
        </if>
        <if test="specialistName != null">
            #{specialistName,jdbcType=VARCHAR},
        </if>
        <if test="eventResult != null">
            #{eventResult,jdbcType=TINYINT},
        </if>
        <if test="eventStatus != null">
            #{eventStatus,jdbcType=TINYINT},
        </if>
    </trim>
</insert>
    <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.panzhihua.service_community.entity.ComEventTransferRecord" useGeneratedKeys="true">
    insert into com_sanshuo_event_transfer_record (id,event_id, parents_transfer_event_id, from_type,
      from_id, from_name, from_user_id,
      to_type, to_id, to_name,
      to_user_id, `save`, process_result,
      process_result_data, process_date, process_by,
      process_by_name, process_type, create_at,
      specialist_id, specialist_org, specialist_level,
      specialist_name, event_result, event_status
      )
    values (#{id},#{eventId,jdbcType=BIGINT}, #{parentsTransferEventId,jdbcType=BIGINT}, #{fromType,jdbcType=TINYINT},
      #{fromId,jdbcType=BIGINT}, #{fromName,jdbcType=VARCHAR}, #{fromUserId,jdbcType=BIGINT},
      #{toType,jdbcType=TINYINT}, #{toId,jdbcType=BIGINT}, #{toName,jdbcType=VARCHAR},
      #{toUserId,jdbcType=BIGINT}, #{save,jdbcType=BIT}, #{processResult,jdbcType=VARCHAR},
      #{processResultData,jdbcType=VARCHAR}, #{processDate,jdbcType=TIMESTAMP}, #{processBy,jdbcType=BIGINT},
      #{processByName,jdbcType=VARCHAR}, #{processType,jdbcType=INTEGER}, #{createAt,jdbcType=TIMESTAMP},
      #{specialistId,jdbcType=BIGINT}, #{specialistOrg,jdbcType=VARCHAR}, #{specialistLevel,jdbcType=VARCHAR},
      #{specialistName,jdbcType=VARCHAR}, #{eventResult,jdbcType=TINYINT}, #{eventStatus,jdbcType=TINYINT}
      )
  </insert>
</mapper>