修改bug

fengjin

2022-10-27 737b019f7ea2ca553ce30a98b4b5f83adaf333f8

修改bug

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

@@ -52,7 +52,7 @@
                select classify_id from  automessage_transaction_event where department_id=#{departmentId} UNION
                select parent_id from  automessage_classify_administration
                where id in (select classify_id FROM automessage_transaction_event
                where department_id=#{departmentId}))
                where department_id in (select id from automessage_organization_chart where id=#{departmentId}  or parent_id=#{departmentId}))  )
            </if>
        </where>
    </select>

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

@@ -393,7 +393,7 @@
        <include refid="selectTransactionEventEntityVo"/>
        where  (classify_id= #{classifyId} or classify_id in (select id FROM automessage_classify_administration where parent_id =#{classifyId} ))
        <if test="departmentId!=null">
            and   department_id=#{departmentId}
            and  department_id in (select id from automessage_organization_chart where id=#{departmentId}  or parent_id=#{departmentId})
        </if>
        order by create_time desc
    </select>