package com.ruoyi.errand.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.ruoyi.errand.domain.Order;
import com.ruoyi.errand.object.dto.sys.FinanceStatisticsDTO;
import com.ruoyi.errand.object.dto.sys.OrderPageListDTO;
import com.ruoyi.errand.object.vo.app.AppUserOrderListVO;
import com.ruoyi.errand.object.vo.app.OrderDetailVO;
import com.ruoyi.errand.object.vo.sys.FinanceStatisticsVO;
import com.ruoyi.errand.object.vo.sys.OrderPageListVO;
import com.ruoyi.errand.object.vo.sys.OrderSysDetailVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.security.core.parameters.P;

import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.util.List;
import java.util.Map;

@Mapper
public interface OrderMapper extends BaseMapper<Order> {
    IPage<AppUserOrderListVO> getAppUserOrderList(@Param("page") IPage<Order> page, @Param("orderStatus") Integer orderStatus, @Param("appUserId")Long appUserId);

    OrderDetailVO getOrderDetail(Integer id);

    Map<String, Object> getOrderTopInfoByDate(@Param("communityId")Integer communityId,@Param("start") LocalDateTime start, @Param("end")LocalDateTime end);

    List<Map<String, Object>> countGroupByDate(@Param("start") LocalDateTime start,@Param("end")  LocalDateTime end,@Param("datePattern")  String datePattern, @Param("communityId") Integer communityId);

    List<FinanceStatisticsVO> financeStatistics( @Param("dto") FinanceStatisticsDTO dto);

    long selectPageTotal(@Param("dto") FinanceStatisticsDTO dto);

    IPage<OrderPageListVO> getOrderPageList(@Param("page")IPage<OrderPageListVO> page, @Param("dto")OrderPageListDTO dto);

    OrderSysDetailVO detail(@Param("id")Integer id);

    List<FinanceStatisticsVO> export(@Param("dto")FinanceStatisticsDTO dto);

    List<OrderPageListVO> orderExport(@Param("dto")OrderPageListDTO dto);
}