<if test='map.timeType !=null and map.timeType =="today"'>
and TO_DAYS(insert_time)=TO_DAYS(NOW())</if><if test='map.timeType !=null and map.timeType =="yesterday"'>
and TO_DAYS(insert_time)=TO_DAYS(DATE_SUB(NOW(),INTERVAL 1 DAY))</if><if test='map.timeType !=null and map.timeType =="sevenDay"'>
and TO_DAYS(insert_time)>=TO_DAYS(DATE_SUB(NOW(),INTERVAL 7 DAY))</if><if test='map.timeType !=null and map.timeType =="fifteenDay"'>
and TO_DAYS(insert_time)>=TO_DAYS(DATE_SUB(NOW(),INTERVAL 15 DAY))</if>
近7天每天的数据
SELECT
d.date,ifnull( s.num,0) AS price
FROM
(SELECTCURDATE() AS date UNION ALL
SELECTDATE_SUB(CURDATE(), INTERVAL 1 DAY ) AS date UNION ALL
SELECTDATE_SUB(CURDATE(), INTERVAL 2 DAY ) AS date UNION ALL
SELECTDATE_SUB(CURDATE(), INTERVAL 3 DAY ) AS date UNION ALL
SELECTDATE_SUB(CURDATE(), INTERVAL 4 DAY ) AS date UNION ALL
SELECTDATE_SUB(CURDATE(), INTERVAL 5 DAY ) AS date UNION ALL
SELECTDATE_SUB(CURDATE(), INTERVAL 6 DAY )AS date
) d
LEFT JOIN (SELECT LEFT
( insert_time,10)AS insert_time,count(1) AS num
FROM
subject_mark AS o
WHERE1=1
GROUP BYDATE_FORMAT( insert_time, '%Y-%m-%d' )) AS s ON d.date = s.insert_time
ORDER BY
d.date DESC