package com.ruoyi.production.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.home.dto.ProductionProgressOrderDto;
import com.ruoyi.production.bean.dto.ProductionOrderDto;
import com.ruoyi.production.bean.vo.ProductionOrderVo;
import com.ruoyi.production.pojo.ProductionOrder;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

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

/**
 * <p>
 * 生产订单表 Mapper 接口
 * </p>
 *
 * @author 芯导软件（江苏）有限公司
 * @since 2026-04-21 03:55:52
 */
@Mapper
public interface ProductionOrderMapper extends BaseMapper<ProductionOrder> {

    IPage<ProductionOrderVo> pageProductionOrder(Page<?> page, @Param("c") ProductionOrderDto dto);

    List<ProductionOrderVo> listProductionOrder(@Param("c") ProductionOrderDto dto);

    ProductionOrderVo getProductionOrderInfo(@Param("id") Long id);

    List<ProductionProgressOrderDto> selectProgressOrders(@Param("startTime") LocalDateTime startTime,
                                                          @Param("endTime") LocalDateTime endTime);

    Integer countCreated(@Param("startDate") String startDate, @Param("endDate") String endDate);

    Integer countCompleted(@Param("startDate") String startDate, @Param("endDate") String endDate);

    Integer countPending(@Param("startDate") String startDate, @Param("endDate") String endDate);

    List<Map<String, Object>> selectHomeOrderProgressPage(@Param("status") Integer status,
                                                          @Param("offset") Long offset,
                                                          @Param("size") Long size);

    Long countHomeOrderProgress(@Param("status") Integer status);

    List<Map<String, Object>> countHomeOrderProgressByStatus();

    List<Map<String, Object>> selectHomeTodayProductionPlan(@Param("size") Long size);

    Long countHomeTodayProductionPlan();

}