FirstApp2.git - Gitblit

			@@ -202,7 +202,7 @@
			CAST(strftime('%W', dates.date) AS INTEGER) as weekOfYear,
			COUNT(code.id) as count
			FROM dates
			LEFT JOIN code ON date(code.createTime) = dates.date
			LEFT JOIN code ON date(code.createTime) = dates.date and code.category='快递'
			GROUP BY dates.date
			ORDER BY dates.date
			""")
			@@ -237,12 +237,12 @@
			)
			SELECT
			strftime('%m', month_start) as date,
			COUNT(code.id) as count,
			COUNT(c.id) as count,
			strftime('%Y-%m-%d', month_start) as weekStart
			FROM months
			LEFT JOIN code ON strftime('%Y-%m', code.createTime) = strftime('%Y-%m', months.month_start)
			GROUP BY months.month_start
			ORDER BY months.month_start ASC
			FROM months m
			LEFT JOIN code c ON strftime('%Y-%m', c.createTime) = strftime('%Y-%m', m.month_start) and c.category='快递'
			GROUP BY m.month_start
			ORDER BY m.month_start ASC
			""")
			fun getYearMonthlyStats(date: Long): Flow<List<DailyStat>>

			@@ -335,7 +335,7 @@
			COUNT(c.id) AS count,
			'' AS weekStart
			FROM dates d
			LEFT JOIN code c ON date(c.createTime) = d.date_value
			LEFT JOIN code c ON date(c.createTime) = d.date_value and c.category='快递'
			GROUP BY d.date_value
			ORDER BY d.date_value ASC
			""")