修改【导办服务】：工单实际有自动分配导办人员，未显示

lidongdong

2022-10-18 ca5b370e399a362adac4125080d4df913db38f9c

修改【导办服务】：工单实际有自动分配导办人员，未显示

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

@@ -55,7 +55,7 @@
            consult_user_name,
            concat((select user_name from automessage_sys_user where a.submit_user_id=user_id ), submit_user_phone) submitUser,
            submit_user_id,
            concat((select user_name from automessage_sys_user where a.guide_user_id=user_id ), guide_user_phone) guideUser,
            concat((IFNULL((select user_name from automessage_sys_user where a.guide_user_id=user_id ),'')), (ifnull(guide_user_phone,''))) guideUser,
            guide_user_id,
            (select organization_name from automessage_organization_chart where a.guide_department_id=id)guideDepartmentName,
            guide_department_id,

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

@@ -356,7 +356,7 @@
        order by create_time desc
    </select>

     <select id="sumTransactionNum"  resultMap="TransactionEventEntityResult">
    <select id="sumTransactionNum"  resultMap="TransactionEventEntityResult">
        select sum(transaction_num)sumTransactionNum,count(*) counttransaction   FROM automessage_transaction_event
    </select>

@@ -413,13 +413,12 @@

    <select id="selectSearchList" resultType="com.dg.core.db.manual.pojo.Search">
        select distinct   classify_id, content, type   FROM(
                                                               select id,classify_name title,ifnull(concat((select classify_name from automessage_classify_administration where c.parent_id=id),'/',classify_name),classify_name)  content,id classify_id,4 type  from automessage_classify_administration c UNION
           select id,classify_name title,ifnull(concat((select classify_name from automessage_classify_administration where c.parent_id=id),'/',classify_name),classify_name)  content,id classify_id,4 type  from automessage_classify_administration c UNION

                                                               select  id,matter_name title,concat((select classify_name from  automessage_classify_administration
                                                                                                    where id=(select parent_id from  automessage_classify_administration  where id=automessage_transaction_event.classify_id)),
                                                                                                   '/',(select classify_name from  automessage_classify_administration  where id=automessage_transaction_event.classify_id)) content,classify_id,
                                                                       2 type from automessage_transaction_event
                                                           ) k
           select  id,matter_name title,concat((select classify_name from  automessage_classify_administration
                                                where id=(select parent_id from  automessage_classify_administration  where id=automessage_transaction_event.classify_id)),
                                               '/',(select classify_name from  automessage_classify_administration  where id=automessage_transaction_event.classify_id)) content,classify_id,
                   2 type from automessage_transaction_event) k
        where  k.title like concat('%',#{keyWord}, '%')
    </select>

@@ -435,8 +434,6 @@
                    (select ifnull(concat((select classify_name from automessage_classify_administration where c.parent_id=id),'/',classify_name),classify_name)  content  from automessage_classify_administration c where c.id=t.classify_id) content,
                    3 type from automessage_transaction_event t where  associate_names like  concat('%',#{keyWord}, '%')
    </select>



    <select id="selectDataIfExist" resultType="string">
        select id from automessage_transaction_event