liding
5 小时以前 196a02bf5ed7feac7c0382d868e93832f3c55a9e
fix(customer): 修正客户数据关联查询逻辑
已修改1个文件
2 ■■■ 文件已修改
src/main/resources/mapper/basic/CustomerMapper.xml 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/mapper/basic/CustomerMapper.xml
@@ -142,7 +142,7 @@
            where rm.status=1
            group by sl.customer_id
        ) T4 on T4.customer_id=T1.customer_id
        left join customer c on T1.customer_id = c.id
        inner join customer c on T1.customer_id = c.id
        <where>
            <if test="customerName!=null and customerName!=''">
                AND c.customer_name LIKE CONCAT('%', #{customerName}, '%')