feat(quality): 添加质检检查名称搜索功能
- 在质检查询条件中新增检查名称模糊匹配
- 实现了检查名称的动态SQL条件构建
- 保持与其他查询条件的兼容性
- 遵循现有的参数验证模式
| | |
| | | <if test="qualityInspect.productName != null and qualityInspect.productName != '' "> |
| | | AND qi.product_name like concat('%',#{qualityInspect.productName},'%') |
| | | </if> |
| | | <if test="qualityInspect.checkName != null and qualityInspect.checkName != '' "> |
| | | AND qi.check_name like concat('%',#{qualityInspect.checkName},'%') |
| | | </if> |
| | | <if test="qualityInspect.entryDateStart != null and qualityInspect.entryDateStart != '' "> |
| | | AND qi.check_time >= DATE_FORMAT(#{qualityInspect.entryDateStart},'%Y-%m-%d') |
| | | </if> |