ShopMall

// AccountingDataController.java
public enum DateRange {
    TODAY, YESTERDAY,
    THIS_WEEK, LAST_WEEK,
    // 회계 실무 핵심 개념
    MTD,   // 월초~오늘
    QTD,   // 분기초~오늘
    YTD,   // 연초~오늘
    LAST_MONTH,
    LAST_QUARTER,
    LAST_YEAR,
    CUSTOM;
}

-- AccountingDAO.xml  ·  WITH 절 CTE
WITH base AS (
  SELECT order_date, qty, price, discount
  FROM   tbl_order_item
  WHERE  order_date BETWEEN #{from} AND #{to}
),
daily AS (
  SELECT
    TRUNC(order_date)         AS d,
    COUNT(*)                   AS orders,
    SUM(qty)                   AS qty,
    SUM(price)                 AS gross,
    SUM(price - discount)      AS net
  FROM   base
  GROUP BY TRUNC(order_date)
)
SELECT * FROM daily ORDER BY d;