| ManagementYKDTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/TOrderTaxiMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
ManagementYKDTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/TOrderTaxiMapper.xml
@@ -1369,6 +1369,7 @@ <if test="null != type and 1 == type"> -- 5、订单量统计(日订单量) SELECT DATE_FORMAT(d.dayDate, '%d') AS dateNum, DATE_FORMAT(d.dayDate, '%Y-%m-%d') AS dateStr, COUNT(t.insertTime) AS totalCount, IFNULL(SUM(t.payMoney),0) AS totalMoney @@ -1428,6 +1429,7 @@ <if test="null != type and 2 == type"> -- 6、订单量统计(月订单量) SELECT LPAD(d.month, 2, '0') as dateNum, CONCAT(d.year, '-', LPAD(d.month, 2, '0')) AS dateStr, COUNT(t.insertTime) AS totalCount, IFNULL(SUM(t.payMoney),0) AS totalMoney