package com.ibeetl.admin.console.dao;

import com.ibeetl.admin.console.model.OrderItemModel;
import com.ibeetl.admin.console.model.OrderModel;
import com.ibeetl.admin.console.model.SysAddressLevelModel;
import org.beetl.sql.core.annotatoin.SqlResource;

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

@SqlResource("console.orderManage")
public interface OrderManageDao {
    /**
     * 统计所有的总数
     * @return
     */
    List<Map<String, Object>> queryStaticData(int flag);

    /**
     * 统计今天的所有总数
     * @return
     */
    List<Map<String, Object>> queryStaticDataToday(String startTime, String endTime, String receiverphone, int flag);

    /**
     * 统计详情
     * @param startTime
     * @param endTime
     * @param time
     */
    List<Map<String, Object>> queryDetailList(String startTime, String endTime,
                                              String storageUserName, String receiverName,
                                              String flag, int page, int limit);

    /**
     * 统计详情总数
     * @param startTime
     * @param endTime
     * @param flag
     * @return
     */
    int queryDetailListCount(String startTime, String endTime, String storageUserName, String receiverName, String flag);

    /**
     * 统计详情里面的总数
     * @param startTime
     * @param endTime
     * @param flag
     * @return
     */
    List<Map<String, Object>> queryDetailTotal(String startTime, String endTime, int flag);

    /**
     * 查询回收员的订单号
     * @param startTime
     * @param endTime
     * @param phone
     * @param page
     * @param limit
     * @return
     */
    List<Map<String, Object>> queryUserOrderNo(String startTime, String endTime, String phone, int page, int limit, int flag);
    int queryUserOrderNoCount(String startTime, String endTime, String phone, int flag);

    /**
     * 根据订单号统计当前订单的数据总量
     * @param orderNo
     * @return
     */
    List<Map<String, Object>> queryTotalForOrderNo(String orderNo, String flag);

    List<Map<String, Object>> queryTotalOrderItemByIds(String[] orderArr, String storageId);

    String queryOrderIdsByStorageId(String storageId);


    /**
     * 根据用户id查询用户的订单
      */
    List<Map<String, Object>> queryCuserOrderByUserId(String userId, List<String> orderStatus, int page, int limit);
    List<Map<String, Object>> queryCuserOrderByUserIdx(String receiveUserId, List<String> orderStatus, int page, int limit);
    int queryCuserOrderByUserIdCount(String userId, List<String> orderStatus);
    Map<String,Object> queryCuserOrderByUserIdCount1(String userId);
    int queryCuserOrderByUserIdCountx(String receiveUserId, List<String> orderStatus);


    /**
     * 根据订单号查询订单详情
     * @param orderNo
     * @return
     */
    List<Map<String, Object>> queryOrderByOrderno(String orderNo);

    String queryOrderByOrderId(String orderId);
    String queryUserIdByOrderId(String orderId);

    List<Map<String, Object>> queryOrderPageByOrderno(String orderNo,int page,int limit);

    int queryOrderCountByOrderno(String orderNo);

    /**
     * 查询订单列表
     * @param orderStatus
     * @param startTime
     * @param endTime
     */
    List<Map<String, Object>> queryOrderList(String orderStatus, String startTime, String name, String mobilePhone,
                                             String endTime, String orderType,
                                             int page, int limit);
    List<OrderModel> queryOrderApiList(OrderModel orderModel);
    List<OrderModel> queryOrderByTownIdApiList(OrderModel orderModel);
    List<String> queryTownIdsByPartnerIds(List<String> partnerIds);
    int queryOrderListCount(String orderStatus, String startTime, String name, String mobilePhone,
                            String endTime, String orderType);

    int queryOrderApiListCount(OrderModel orderModel);
    int queryOrderByTownIdsApiListCount(OrderModel orderModel);

    /**
     * 根据用户Id查询用的订单分类总数
     * @param userId
     * @return
     */
    List<Map<String, Object>> queryStatusByCuserId(String userId);
    String queryOrderByPartnerId(String orderId);
    String queryTownIdByPartnerId(String townId);

    /**
     * 根据订单号更新订单状态
     * @param orderId
     */
    int updateOrderStatus(String orderId, String receiveId, String orderStatus);
    int updateApirecByOrderId(String orderId,String receiveId,String trid);
    int updateApirecDetailByOrderId(String orderId,String mobilePhone,String name);
    int updateOrderStatus1(String orderId, String orderStatus);
    int updateOrderDetailReData(String orderId,String cancelReasonName);
    String queryOrderReNum(String userId);
    List<Map<String,Object>> queryStorageApiList(OrderModel orderModel);
    int queryStorageApiNum(OrderModel orderModel);


    List<Map<String,Object>> queryStorageDetailApiList(List<String> orderIds,int page,int limit);

    List<Map<String,Object>> queryStroageDetailPageByOrderno(List<String> orderIds,String storageId,int page,int limit);

    int queryStroageDetailCountByOrderno(List<String> orderIds,String storageId);

    int addOrderInfoApi(OrderModel orderModel);

    int addOrderDetailApi(OrderModel orderModel);

    int addOrderItem(List<OrderItemModel> list);

    List<SysAddressLevelModel> queryProvince();
    List<SysAddressLevelModel> queryCityByProvinceId(String provinceId);
    List<SysAddressLevelModel> queryTownShipByCityId(String cityId);
}