| ruoyi-service/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
ruoyi-service/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml
@@ -91,7 +91,7 @@ </select> <select id="getOrderStatistics" resultType="com.ruoyi.order.vo.OrderStatistics"> SELECT count(*) as total, SUM( CASE WHEN tor.order_type = 2 and distribution_mode = 2 THEN 0 ELSE 1 END ) as total, SUM( CASE WHEN tor.order_type = 1 THEN 1 ELSE 0 END ) as serviceTotal, SUM( CASE WHEN tor.order_type = 2 and distribution_mode = 1 THEN 1 ELSE 0 END ) as singleTotal, SUM( tor.total_amount ) as totalMoney,
