package com.cjs.cms.dao.agent;

import java.util.List;
import java.util.Map;

import org.springframework.stereotype.Repository;

import com.cjs.cms.util.db.OracleDao;

/**
 * 查询交易明细
 * @author tongxiaochuan
 *
 */
@Repository
public interface HisOtcDeliverDao extends OracleDao {

    /**一级会员交易明细查询*/
    List<Map<String, Object>> queryTradeMember(Map<String, Object> params);

    int queryTradeMemberTotal(Map<String, Object> params);

    Map<String, Object> queryTradeMemberSum(Map<String, Object> params);

    List<Map<String, Object>> queryTradeAgent(Map<String, Object> params);

    int queryTradeAgentTotal(Map<String, Object> params);

    Map<String, Object> queryTradeAgentSum(Map<String, Object> params);

    /**查询指定日期交易买入额*/
    List<Map<String, Object>> queryDailyBusinessBalance(Map<String, Object> params);

    /**查询用户首次买入日为指定日期的买入额达标用户列表*/
    List<String> queryUserForFirstBuyDay(Map<String, Object> params);

    /**按用户及藏品分组查询买入累计金额*/
    List<Map<String, Object>> queryListForTradeRecord(Map<String, Object> params);
}