forked from kidgrow-microservices-platform

houruijun
2020-08-09 92257d291a9d171a15b22c1fc6527b1a909ac3f6
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
     */
    List<OrderChartVo> productOrderChart(@Param("p") Map<String, Object> params);
    /**
     * 统计产品的使用数量
     * @return  ccount 是数量
     *          units 是产品名称
     */
    List<OrderChartVo> proCountChart();
}