FirstApp2.git - Gitblit

			@@ -86,16 +86,16 @@
			@Query("""
			SELECT * FROM code
			WHERE substr(createTime, 1, 10) =
			date(:date/1000, 'unixepoch', 'localtime') and pickup = 1
			date(:date/1000, 'unixepoch', 'localtime') and pickup = 1 and category='快递'
			ORDER BY createTime DESC
			""")
			fun getPackagesByDayUnread(date: Long): Flow<List<Code>>
			fun getPackagesByDayReaded(date: Long): Flow<List<Code>>

			@Query("""
			SELECT oneLevel as courierName, COUNT(*) as count
			FROM code
			WHERE strftime('%Y-%W', substr(createTime, 1, 10)) =
			strftime('%Y-%W', datetime(:date/1000, 'unixepoch', 'localtime'))
			strftime('%Y-%W', datetime(:date/1000, 'unixepoch', 'localtime')) and category='快递'
			GROUP BY oneLevel
			ORDER BY count DESC
			""")
			@@ -135,7 +135,7 @@
			SELECT oneLevel as courierName, COUNT(*) as count
			FROM code
			WHERE strftime('%Y-%m', substr(createTime, 1, 10)) =
			strftime('%Y-%m', datetime(:date/1000, 'unixepoch', 'localtime'))
			strftime('%Y-%m', datetime(:date/1000, 'unixepoch', 'localtime')) and category='快递'
			GROUP BY oneLevel
			ORDER BY count DESC
			""")
			@@ -145,7 +145,7 @@
			SELECT oneLevel as courierName, COUNT(*) as count
			FROM code
			WHERE strftime('%Y', substr(createTime, 1, 10)) =
			strftime('%Y', datetime(:date/1000, 'unixepoch', 'localtime'))
			strftime('%Y', datetime(:date/1000, 'unixepoch', 'localtime')) and category='快递'
			GROUP BY oneLevel
			ORDER BY count DESC
			""")
			@@ -340,4 +340,12 @@
			ORDER BY d.date_value ASC
			""")
			fun getWeeklyStatsChart(startDateCur: String, endDateCur: String): Flow<List<DailyStat>>


			@Query("""
			SELECT COUNT(1)
			FROM code
			WHERE date(createTime) BETWEEN date(:startDateCur) AND date(:endDateCur) and category =:type
			""")
			fun getDateStatsByType(startDateCur: String, endDateCur: String,type: String): Flow<Long>
			}