From f532169845c8fc4214dc1cb817981cc1d3e7befd Mon Sep 17 00:00:00 2001 From: zhaoxiaohao <913652501@qq.com> Date: Sat, 08 Aug 2020 22:51:19 +0800 Subject: [PATCH] c端 不添加数据user --- kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/java/com/kidgrow/oprationcenter/mapper/ProductOrderDetailMapper.java | 61 ++++++++++++++++++++++++++++-- 1 files changed, 57 insertions(+), 4 deletions(-) diff --git a/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/java/com/kidgrow/oprationcenter/mapper/ProductOrderDetailMapper.java b/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/java/com/kidgrow/oprationcenter/mapper/ProductOrderDetailMapper.java index 3ea3515..6b38cef 100644 --- a/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/java/com/kidgrow/oprationcenter/mapper/ProductOrderDetailMapper.java +++ b/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/java/com/kidgrow/oprationcenter/mapper/ProductOrderDetailMapper.java @@ -1,8 +1,11 @@ package com.kidgrow.oprationcenter.mapper; -import com.kidgrow.oprationcenter.model.ProductOrderDetail; -import com.kidgrow.db.mapper.SuperMapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.kidgrow.db.mapper.SuperMapper; +import com.kidgrow.oprationcenter.model.ProductOrderDetail; +import com.kidgrow.oprationcenter.vo.GroupProductDetail; +import com.kidgrow.oprationcenter.vo.OrderChartVo; +import com.kidgrow.oprationcenter.vo.ProductOrderJoinDetail; import org.apache.ibatis.annotations.Param; import java.util.List; @@ -24,11 +27,61 @@ * @return */ List<ProductOrderDetail> findList(Page<ProductOrderDetail> page, @Param("p") Map<String, Object> params); - + /** + * 查询产品/明显的充值记录列表 + * @param params + * @return + */ + List<ProductOrderJoinDetail> findAllList(@Param("p") Map<String, Object> params); /** * 根据ProductOrderDetail对象当做查询条件进行查询 * @param * @return ProductOrderDetail对象 */ - ProductOrderDetail findByObject(@Param("p") ProductOrderDetail productOrderDetail); + ProductOrderDetail findByObject(@Param("p") ProductOrderDetail productOrderDetail);/** + * 统计产品使用量 + * @param + * @return ProductOrderDetail对象 + */ + List<GroupProductDetail> groupProductDetail(Page<GroupProductDetail> page, @Param("p") Map<String, Object> params); + + List<ProductOrderJoinDetail> getTypeByUser(Long id); + + /** + * 获取一个科室的试用套餐数量 + * @param departmentId + * @return + */ + int getEnabledCount(Long departmentId); + + /** + * 统计获取数据量 + * @param datatype + * 0 试用审核量 + * 1 套餐总量 + * 2 未处理用户反馈 + * 3 未处理数据需求 + * @return + */ + int oprationChart(@Param("datatype") int datatype); + + /** + * 按指定类型统计合同数量 + * @param params + * datatype 1 按年 + * 2 按月 + * 3 按天 + * 4 按周 + * beginTime 查询时间段的开始时间 + * endTime 结束时间 + * @return + */ + OrderChartVo productOrderChart(@Param("p") Map<String, Object> params); + + /** + * 统计产品的使用数量 + * @return ccount 是数量 + * units 是产品名称 + */ + OrderChartVo proCountChart(); } -- Gitblit v1.8.0