package com.poteviohealth.cgp.statistics.mapper;

import com.baomidou.mybatisplus.annotation.SqlParser;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.poteviohealth.cgp.common.integrated.ListParams;
import com.poteviohealth.cgp.common.integrated.customer.model.CustomerServiceParams;
import com.poteviohealth.cgp.common.integrated.customer.model.CustomerSubsidyDTO;
import com.poteviohealth.cgp.common.integrated.partner.model.AreaDTO;
import com.poteviohealth.cgp.statistics.model.Order;
import com.poteviohealth.cgp.statistics.model.outdto.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.LinkedList;
import java.util.List;

/**
 * 居家大屏
 * @author Qin
 */
@Mapper
public interface OrderMapper extends BaseMapper<Order>{

    /**
     * 获取积分客户信息
     * @param wrapper
     * @param operator
     * @param dbName
     * @return
     */
    @SqlParser(filter = true)
    List<IntegralTrans> integralCustomerList(@Param(Constants.WRAPPER) Wrapper wrapper, @Param("operatorId") Integer operator, @Param("dbName") String dbName);


    /**
     * 积分大屏统计
     * @return
     */
    @SqlParser(filter = true)
    List<IntegralTrans> integralTransList(@Param(Constants.WRAPPER) Wrapper wrapper, @Param("operatorId") Integer operator, @Param("dbName") String dbName);


    /**
     * 获取区域信息
     * @param dbName
     * @return
     */
    List<AreaDTO> areaList(@Param("dbName") String dbName);

    /**
     * 获取驿站员工信息
     * @param dbName
     * @return
     */
    List<SupplierStationEmployee> supplierStationEmployeeList(@Param("dbName") String dbName);


    /**
     * 获取驿站信息
     * @param dbName
     * @return
     */
    List<SupplierStation> supplierStationList(@Param("dbName") String dbName);


    /**
     * 获取服务人员信息
     * @param dbName
     * @return
     */
    List<Employee> employeeList(@Param("dbName") String dbName);

    /**
     * 获取平台运营商
     * @param dbName
     * @return
     */
    List<Integer> getOperatorList(@Param("dbName") String dbName);

    /**
     * 获取客户信息
     * @param operatorId
     * @param dbName
     * @param wrapper
     * @return
     */
    List<CustomerSubsidyDTO> getSubsidyCustomerList(@Param("operatorId")Integer operatorId, @Param("dbName")String dbName, @Param(Constants.WRAPPER) Wrapper wrapper);

    /**
     * 统计已服务客户数
     * @param operatorId
     * @param dbName
     * @return
     */
    @SqlParser(filter = true)
    List<CustomerServiceParams> orderServiceCustomerList(@Param("operatorId")Integer operatorId, @Param("dbName")String dbName);

    /**
     * 获取助餐客户信息
     * @param operatorId
     * @param dbName
     * @param wrapper
     * @return
     */
    List<Customer> getSubsidyCustomerMealList(@Param("operatorId")Integer operatorId, @Param("dbName")String dbName, @Param(Constants.WRAPPER) Wrapper wrapper);

    /**
     * 获取订单数据
     * @param operatorId
     * @param dbName
     * @param wrapper
     * @return
     */
    @SqlParser(filter = true)
    List<OrderIntegrationData> queryOrderIntegrationData(@Param("operatorId")Integer operatorId, @Param("dbName")String dbName,@Param(Constants.WRAPPER) Wrapper wrapper);

    /**
     * 获取服务分类
     * @param dbName
     * @return
     */
    List<ListParams> getAllCategory(@Param("dbName")String dbName);

    /**
     * 积分交易
     * @param dbName
     * @return
     */
    List<IntegralTransaction> integralTransactionList(@Param("dbName")String dbName,@Param("operatorId")Integer operatorId);

    /**
     * 积分商品
     * @param dbName
     * @return
     */
    List<IntegralProduct> integralProductList(@Param("dbName")String dbName);

    /**
     * 获取商户
     * @param dbName
     * @return
     */
    List<StationMerchant> getStationMerchantList(@Param("dbName")String dbName);

    /**
     * 查询消费商品
     * @param dbName
     * @param operatorId
     * @return
     */
    List<Product> queryIntegralProduct(@Param("dbName")String dbName,@Param("operatorId")Integer operatorId);

    /**
     * 获取有积分记录的运营商
     * @param dbName
     * @param wrapper
     * @return
     */
    List<Integer> getIntegralCardAccOperatorIdList(@Param("dbName")String dbName,@Param(Constants.WRAPPER) Wrapper wrapper);

    /**
     * 获取有积分记录的运营商
     * @param dbName
     * @return
     */
    List<Integer> getIntegralCardDetailOperatorIdList(@Param("dbName")String dbName);


    /**
     * excel
     * @param wrapper
     * @return
     */
    @SqlParser(filter=true)
    LinkedList<OrderExcelDTO> orderExcel(@Param(Constants.WRAPPER) Wrapper wrapper, @Param("dbName")String dbName, @Param("operatorId")Integer operatorId, @Param("start")Integer start);

    @SqlParser(filter = true)
    int orderPageListSize(@Param(Constants.WRAPPER) Wrapper wrapper,@Param("dbName")String dbName,@Param("operatorId")Integer operatorId);

    @SqlParser(filter = true)
    int orderPageListAllSize(@Param(Constants.WRAPPER) Wrapper wrapper,@Param("dbName")String dbName,@Param("operatorId")Integer operatorId);

    @SqlParser(filter = true)
    int dishesOrderPageListAllSize(@Param(Constants.WRAPPER) Wrapper wrapper,@Param("dbName")String dbName,@Param("operatorId")Integer operatorId);

    /**
     * excel
     * @param wrapper
     * @return
     */
    @SqlParser(filter=true)
    LinkedList<DishesOrderWebOutDTO> dishesOrderExcel(@Param(Constants.WRAPPER) Wrapper wrapper,@Param("dbName")String dbName,@Param("operatorId")Integer operatorId,@Param("start")Integer start);


    @SqlParser(filter = true)
    int costOrderPageListAllSize(@Param(Constants.WRAPPER) Wrapper wrapper,@Param("dbName")String dbName,@Param("operatorId")Integer operatorId);


    /**
     * excel
     * @param wrapper
     * @return
     */
    @SqlParser(filter=true)
    LinkedList<OrderCostWebOutDTO> costOrderExcel(@Param(Constants.WRAPPER) Wrapper wrapper,@Param("dbName")String dbName,@Param("operatorId")Integer operatorId,@Param("start")Integer start);

}