更改查询历史项目分组条件

guoyuji

2025-02-10 a7748c3f762c5a68c368effdfef9c6f8e867059b

更改查询历史项目分组条件

 north-glass-erp/src/main/resources/mapper/sd/CustomerMapper.xml

@@ -140,7 +140,7 @@
    <select id="getProjectList">
        select * from(select project,salesman_id,salesman,id from sd.`order`
                       where customer_id = #{id}
                      group by project, salesman_id
                      group by project
                       ) as a
              order by id desc
    </select>