添加字段

ANDRU-PC\Andru

2023-07-19 1f0e2e49c1189751b56e9d3c81db8d012d8f9256

添加字段

 phi_platform_common/src/main/resources/mapper/platform/NotificationLogMapper.xml

@@ -8,7 +8,7 @@
    <!-- 整个实体类修改，表字段=实体类字段-->
    <sql id="Update_Column_All">
        <trim prefixOverrides=",">
            ,commonId = #{commonId},commonType = #{commonType},notificationSubject = #{notificationSubject},notificationType = #{notificationType},overdueDay = #{overdueDay},overdueAmount = #{overdueAmount},status = #{status},statusInfo = #{statusInfo},isReceive = #{isReceive},userMoneyAssociationId = #{userMoneyAssociationId},isDel = #{isDel},createTime = #{createTime},editTime = #{editTime}
            ,commonId = #{commonId},commonType = #{commonType},notificationSubject = #{notificationSubject},notificationType = #{notificationType},overdueDay = #{overdueDay},overdueAmount = #{overdueAmount},status = #{status},statusInfo = #{statusInfo},isReceive = #{isReceive},userMoneyAssociationId = #{userMoneyAssociationId},remark = #{remark},isDel = #{isDel},createTime = #{createTime},editTime = #{editTime}
        </trim>
    </sql>
     
@@ -19,8 +19,12 @@
        <selectKey keyProperty="id" resultType="String" order="BEFORE">
               select replace(uuid(),'-','') from dual
        </selectKey>
        insert into notification_log (id,commonId,commonType,notificationSubject,notificationType,overdueDay,overdueAmount,status,statusInfo,isReceive,userMoneyAssociationId,isDel,createTime,editTime)  values (#{id},#{commonId},#{commonType},#{notificationSubject},#{notificationType},#{overdueDay},#{overdueAmount},#{status},#{statusInfo},#{isReceive},#{userMoneyAssociationId},#{isDel},#{createTime},#{editTime})
        insert into notification_log (id,commonId,commonType,notificationSubject,notificationType,overdueDay,overdueAmount,status,statusInfo,isReceive,userMoneyAssociationId,remark,isDel,createTime,editTime)  values (#{id},#{commonId},#{commonType},#{notificationSubject},#{notificationType},#{overdueDay},#{overdueAmount},#{status},#{statusInfo},#{isReceive},#{userMoneyAssociationId},#{remark},#{isDel},#{createTime},#{editTime})
    </insert>

    <insert id="insertById" parameterType="com.hx.phiappt.model.NotificationLog">
        insert into notification_log (id,commonId,commonType,notificationSubject,notificationType,overdueDay,overdueAmount,status,statusInfo,isReceive,userMoneyAssociationId,remark,isDel,createTime,editTime)  values (#{id},#{commonId},#{commonType},#{notificationSubject},#{notificationType},#{overdueDay},#{overdueAmount},#{status},#{statusInfo},#{isReceive},#{userMoneyAssociationId},#{remark},#{isDel},#{createTime},#{editTime})
    </insert>

    <select id="selectList" resultType="com.hx.phiappt.model.NotificationLog" parameterType="com.hx.mybatisTool.SqlSentence" >
        ${sqlSentence}
@@ -51,14 +55,14 @@

    <select id="selectOneByKey" resultType="com.hx.phiappt.model.NotificationLog" parameterType="java.lang.Object" >
        select 
            id,commonId,commonType,notificationSubject,notificationType,overdueDay,overdueAmount,status,statusInfo,isReceive,userMoneyAssociationId,isDel,createTime,editTime
            id,commonId,commonType,notificationSubject,notificationType,overdueDay,overdueAmount,status,statusInfo,isReceive,userMoneyAssociationId,remark,isDel,createTime,editTime
        from notification_log
        WHERE id = #{value}
    </select>

    <select id="selectOneByKeyBlob" resultType="com.hx.phiappt.model.NotificationLog" parameterType="java.lang.Object" >
        select 
            id,commonId,commonType,notificationSubject,notificationType,overdueDay,overdueAmount,status,statusInfo,isReceive,userMoneyAssociationId,isDel,createTime,editTime
            id,commonId,commonType,notificationSubject,notificationType,overdueDay,overdueAmount,status,statusInfo,isReceive,userMoneyAssociationId,remark,isDel,createTime,editTime
        from notification_log
        WHERE id = #{value}
    </select>