解决报工查询班组带括号无法筛选问题

chenlu

2025-11-21 763d7cf2f4aed4d21921e08d05b7b121c24ce136

解决报工查询班组带括号无法筛选问题

 north-glass-erp/src/main/resources/mapper/pp/ReportingWork.xml

@@ -579,7 +579,7 @@
            and rw.device_name regexp #{reportingWork.deviceName}
        </if>
        <if test="reportingWork.teamsGroupsName != null and reportingWork.teamsGroupsName != ''">
            and rw.teams_groups_name regexp #{reportingWork.teamsGroupsName}
            and rw.teams_groups_name like concat('%', #{reportingWork.teamsGroupsName}, '%')
        </if>
        GROUP BY rw.reporting_work_id
        ORDER BY rw.reporting_work_id desc