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

lidongdong

2023-10-24 3e9e12250123c5b17780c4d1a1f7f1bbdacf4829

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

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/jinhui/JinhuiQuestnaireUserAnswerVO.java

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

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

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

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

    @ApiModelProperty(value = "处理时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date processingTime;

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

@@ -1,5 +1,6 @@
package com.panzhihua.service_jinhui_community.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
@@ -39,6 +40,19 @@
    @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;


    @ApiModelProperty(value = "处理时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date processingTime;

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

@@ -17,46 +17,54 @@
    <!-- 分页查询 -->
    <select id="getList" resultMap="itemMap">
        select
            id,
            questnaire_id,
            user_id,
            creation_time,
            json_object,
            update_time,
            processing_time,
            transact_type,
            reply
        from jinhui_com_act_questnaire_user_answer
        where user_id=#{userId}
        order by creation_time desc
            jcaqa.id,
            su.name as userName,
            su.phone,
            su.id_card as idCard,
            jcaqa.questnaire_id,
            jcaqa.user_id,
            jcaqa.creation_time,
            jcaqa.json_object,
            jcaqa.update_time,
            jcaqa.processing_time,
            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>


    <select id="getDetails" resultMap="itemMap">
        select
            id,
            questnaire_id,
            user_id,
            creation_time,
            json_object,
            update_time,
            processing_time,
            transact_type,
            reply
        from jinhui_com_act_questnaire_user_answer
            jcaqa.id,
            su.name as userName,
            su.phone,
            su.id_card as idCard,
            jcaqa.questnaire_id,
            jcaqa.user_id,
            jcaqa.creation_time,
            jcaqa.json_object,
            jcaqa.update_time,
            jcaqa.processing_time,
            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!='' ">
                and id=#{id}
                and jcaqa.id=#{id}
            </if>
            <if test=" questnaireId!=null and questnaireId!='' ">
                and questnaire_id=#{questnaireId}
                and jcaqa.questnaire_id=#{questnaireId}
            </if>
            <if test=" userId!=null and userId!='' ">
                and user_id=#{userId}
                and jcaqa.user_id=#{userId}
            </if>
            <if test=" transactType!=null and transactType!='' ">
                and transact_type=#{transactType}
                and jcaqa.transact_type=#{transactType}
            </if>
        </where>
    </select>