新增办事指南处理用户信息字段2

lidongdong

2023-10-24 418d162a1dd8274a0b6c35a7493db57fdcc27695

新增办事指南处理用户信息字段2

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/entity/JinhuiQuestnaireUserAnswer.java

@@ -40,15 +40,12 @@
    @ApiModelProperty(value = "回复")
    private String reply;

    @TableField(exist = false)
    @ApiModelProperty(value = "用户名")
    private String userName;

    @TableField(exist = false)
    @ApiModelProperty(value = "电话")
    private String phone;

    @TableField(exist = false)
    @ApiModelProperty(value = "身份证")
    private String idCard;


 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/resources/mapper/JinhuiComActQuestnaireUserAnswerMapper.xml

@@ -9,6 +9,9 @@
        <result property="jsonObject" column="json_object" />
        <result property="transactType" column="transact_type" />
        <result property="reply" column="reply" />
        <result property="userName" column="user_name" />
        <result property="phone" column="phone" />
        <result property="idCard" column="id_card" />
        <result property="processingTime" column="processing_time" />
        <result property="creationTime" column="creation_time" />
        <result property="updateTime" column="update_time" />
@@ -18,11 +21,11 @@
    <select id="getList" resultMap="itemMap">
        select
            jcaqa.id,
            su.name as userName,
            su.phone,
            su.id_card as idCard,
            jcaqa.questnaire_id,
            jcaqa.user_id,
            jcaqa.user_name,
            jcaqa.phone,
            jcaqa.id_card,
            jcaqa.creation_time,
            jcaqa.json_object,
            jcaqa.update_time,
@@ -30,7 +33,6 @@
            jcaqa.transact_type,
            jcaqa.reply
        from jinhui_com_act_questnaire_user_answer as jcaqa
        Left join sys_user su on su.user_id=jcaqa.user_id
        where jcaqa.user_id=#{userId}
        order by jcaqa.creation_time desc
    </select>
@@ -39,11 +41,11 @@
    <select id="getDetails" resultMap="itemMap">
        select
            jcaqa.id,
            su.name as userName,
            su.phone,
            su.id_card as idCard,
            jcaqa.questnaire_id,
            jcaqa.user_id,
            jcaqa.user_name,
            jcaqa.phone,
            jcaqa.id_card,
            jcaqa.creation_time,
            jcaqa.json_object,
            jcaqa.update_time,
@@ -51,7 +53,6 @@
            jcaqa.transact_type,
            jcaqa.reply
        from jinhui_com_act_questnaire_user_answer as jcaqa
        Left join sys_user su on su.user_id=jcaqa.user_id
        <where>
            1=1
            <if test=" id!=null and id!='' ">
@@ -93,6 +94,15 @@
            <if test="item.reply != null and item.reply != '' ">
                reply,
            </if>
            <if test="item.userName != null and item.userName != '' ">
                user_name,
            </if>
            <if test="item.phone != null and item.phone != '' ">
                phone,
            </if>
            <if test="item.idCard != null and item.idCard != '' ">
                id_card,
            </if>
            creation_time
        </trim>
        values
@@ -117,6 +127,15 @@
            </if>
            <if test="item.reply != null and item.reply != '' ">
                #{item.reply},
            </if>
            <if test="item.userName != null and item.userName != '' ">
                #{item.userName},
            </if>
            <if test="item.phone != null and item.phone != '' ">
                #{item.phone},
            </if>
            <if test="item.idCard != null and item.idCard != '' ">
                #{item.idCard},
            </if>
            sysdate()
        </trim>
@@ -146,6 +165,15 @@
            <if test="item.reply != null and item.reply != '' ">
                reply=#{item.reply},
            </if>
            <if test="item.userName != null and item.userName != '' ">
                user_name=#{item.userName},
            </if>
            <if test="item.phone != null and item.phone != '' ">
                phone=#{item.phone},
            </if>
            <if test="item.idCard != null and item.idCard != '' ">
                id_card=#{item.idCard},
            </if>
            update_time=sysdate()
        </set>
        where id = #{item.id}