1.居民查看的导办工单里的工作人员姓名脱敏显示，显示为”姓+老师“，示例”李老师“2.后台导办工单可以按用户提交时间、办事指南分类进行筛选

fengjin

2022-11-09 0d29c76ba962388ffb79897e809cd2b2c17ce944

1.居民查看的导办工单里的工作人员姓名脱敏显示，显示为”姓+老师“，示例”李老师“2.后台导办工单可以按用户提交时间、办事指南分类进行筛选

 flower_city/src/main/resources/mapper/GuideEvolveMapper.xml

@@ -60,6 +60,42 @@
        order by create_time desc
    </select>

    <select id="selectHideList" resultMap="GuideEvolveResult">
        SELECT
            id,
            departmental_id,
            IFNULL(
                    (select  concat(substring(user_name,1,1),'老师') from automessage_sys_user where a.to_user_id=user_id and user_type in (1,2)),
                    (select user_name from automessage_sys_user where a.to_user_id=user_id))toUserName,
            IFNULL(
                    (select  concat(substring(user_name,1,1),'老师') from automessage_sys_user where a.from_user_id=user_id and user_type in (1,2)),
                    (select user_name from automessage_sys_user where a.from_user_id=user_id))fromUserName,
            to_user_id,
            from_user_id,
            state,
            remark,
            guide_id,
            transaction_id,
            accessory_id,
            accessory_name,
            accessory_url,
            from_departmental_id,
            video_url,
            picture_url,
            create_time,
            update_time,
            guide_order_num,
            is_timeout
        FROM
            automessage_guide_evolve a
        <where>
            <if test="guideId != null and guideId != ''">
                AND guide_id=#{guideId}
            </if>
        </where>
        order by create_time desc
    </select>


    <insert id="insertConfig" parameterType="com.dg.core.db.gen.entity.GuideEvolveEntity">
        insert into automessage_guide_evolve (

 flower_city/src/main/resources/mapper/GuideRepairOrderMapper.xml

@@ -105,6 +105,16 @@
            <if test="status != null and status != ''">
                AND a.state=#{status}
            </if>
            <if test="createTimeStartTime != null and createTimeStartTime != ''">
                and create_time > #{createTimeStartTime}
            </if>
            <if test="createTimeTimeEndTime != null and createTimeTimeEndTime != ''">
               and  #{createTimeTimeEndTime} > create_time
            </if>
            <if test="classifyId != null and classifyId != ''">
                and  classify_id in (select id FROM automessage_classify_administration where  parent_id = #{classifyId})
            </if>

        </where>
        order by  update_time desc ,  create_time desc
    </select>