feat(business-opportunity): 修改商机查询条件为模糊匹配

liyong

2026-05-08 26406dca5b814f76425825083a480d51fabcce40

feat(business-opportunity): 修改商机查询条件为模糊匹配

- 将客户名称查询从精确匹配改为模糊匹配
- 将城市查询从精确匹配改为模糊匹配
- 将录入人员查询从精确匹配改为模糊匹配
- 保持状态查询的精确匹配逻辑不变
- 保留录入日期范围查询功能

 src/main/resources/mapper/basic/BusinessOpportunityMapper.xml

@@ -31,19 +31,19 @@
        business_opportunity bo
        <where>
            <if test="businessOpportunityDto.customerName != null">
                and bo.customer_name = #{businessOpportunityDto.customerName}
                and bo.customer_name like concat('%',#{businessOpportunityDto.customerName},'%')
            </if>
            <if test="businessOpportunityDto.city != null">
                and bo.city = #{businessOpportunityDto.city}
                and bo.city like concat('%',#{businessOpportunityDto.city},'%')
            </if>
            <if test="businessOpportunityDto.entryPerson != null">
                and bo.entry_person = #{businessOpportunityDto.entryPerson}
                and bo.entry_person like concat('%', #{businessOpportunityDto.entryPerson},'%')
            </if>
            <if test="businessOpportunityDto.status != null">
                and bo.status = #{businessOpportunityDto.status}
            </if>
            <if test="businessOpportunityDto.customerName != null">
                and bo.customer_name = #{businessOpportunityDto.customerName}
                and bo.customer_name like concat('%',#{businessOpportunityDto.customerName},'%')
            </if>
            <if test="businessOpportunityDto.entryDateStart != null">
                and bo.entry_date &gt;= STR_TO_DATE(#{businessOpportunityDto.entryDateStart}, '%Y-%m-%d')