lmk-shop-java.git

			@@ -93,6 +93,7 @@
			"o.consignee_mobile AS consigneeMobile," +
			"o.member_id AS memberId," +
			"m.nick_name AS nickName," +
			"o.customize_flag AS customizeFlag," +
			"o.modify_address_flag AS modifyAddressFlag,"+
			" GROUP_CONCAT(oi.goods_id) as group_goods_id," +
			" GROUP_CONCAT(oi.sku_id) as group_sku_id," +
			@@ -193,32 +194,4 @@
			@Select("select o.* " +
			" FROM li_order o INNER JOIN li_order_item AS oi on o.sn = oi.order_sn ${ew.customSqlSegment} ")
			List<Order> queryListByParams(@Param(Constants.WRAPPER) Wrapper<Order> queryWrapper);


			@Select("SELECT " +
			" DATE(create_time) AS day, " +
			" COUNT(*) AS count " +
			" FROM" +
			" li_order o" +
			" WHERE " +
			" o.create_time BETWEEN #{startTime} AND #{endTime} " +
			" GROUP BY" +
			" day " +
			" ORDER BY " +
			" day ASC")
			List<Map<String, Object>> selectOrderCountByDay(Date startTime, Date endTime);

			@Select("SELECT " +
			" DATE(create_time) AS day, " +
			" HOUR(create_time) AS hour," +
			" COUNT(*) AS count " +
			" FROM" +
			" li_order o" +
			" WHERE " +
			" o.create_time BETWEEN #{startTime} AND #{endTime} " +
			" GROUP BY" +
			" day " +
			" ORDER BY " +
			" day , hour ASC")
			List<Map<String, Object>> selectOrderTimePeriod(Date startTime, Date endTime);
			}