package com.ruoyi.inspect.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
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.basic.pojo.StructureTestObject;
import com.ruoyi.inspect.dto.CostStatisticsDto;
import com.ruoyi.inspect.dto.SampleOrderDto;
import com.ruoyi.inspect.dto.SampleProductDto2;
import com.ruoyi.inspect.dto.SampleProductExportDto;
import com.ruoyi.inspect.pojo.InsOrder;
import com.ruoyi.inspect.vo.InsOrderPrintingVo;
import com.ruoyi.inspect.vo.SampleDefectsFatherVo;
import org.apache.ibatis.annotations.Param;

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

/**
 * @author gaoaoy
 * @description 针对表【ins_order(检验下单)】的数据库操作Mapper
 * @createDate 2024-03-12 16:17:55
 * @Entity com.yuanchu.mom.pojo.InsOrder
 */
public interface InsOrderMapper extends BaseMapper<InsOrder> {

    //获取检验下单数据
    IPage<SampleOrderDto> selectInsOrderPage(IPage<InsOrder> page, QueryWrapper<SampleOrderDto> ew, String laboratory, String isOrderAll);


    String getLaboratoryCode(String name);

    IPage<SampleProductDto2> selectSampleAndProductByOrderId(IPage<SampleProductDto2> page, QueryWrapper<SampleProductDto2> ew, Integer id);

    IPage<CostStatisticsDto> selectCostStatistics(IPage<CostStatisticsDto> page, QueryWrapper<CostStatisticsDto> ew);

    List<CostStatisticsDto> selectCostStatistics2(@Param("ew") QueryWrapper<CostStatisticsDto> ew);

    List<Map<String, String>> selectDeviceList(Set<String> names);
    List<SampleDefectsFatherVo> selectSampleDefects(Page page, @Param("inspectionItems") String inspectionItems, @Param("orderNumber") String orderNumber);

    Long getCount(@Param("inspectionItems") String inspectionItems, @Param("orderNumber") String orderNumber);

    String getStandardMethodCode(Integer id);

    int updateStatus( Integer id);

    String selLaboratoryCode(String laboratory);

    List<Map<Integer, Object>> selectReportModelByOrderId(@Param("id") Integer id, @Param("laboratory") String laboratory);

    String seldepLimsId(int depLimsId);

    /**
     * 查询检验结果
     * @param ids
     * @return
     */
    List<SampleProductExportDto> selectSampleBySampleId(@Param("ids") List<Integer> ids);

    /**
     * 获取批量检验的总数
     * @param id
     * @return
     */
    int selectSampleMax(Integer id);

    /**
     * 获取线芯颜色
     * @param id
     * @return
     */
    List<String> selectSampleCableTag(Integer id);

    /**
     *
     * @param orderId
     * @return
     */
    int selectSampleItemS(Integer orderId);

    /**
     * 只查询默认第一个的产品
     * @param id
     * @return
     */
    List<SampleProductExportDto> selectSampleBySampleIdOne(Integer id);

    /**
     * 查询日历图
     * @param
     * @return
     */
    List<Map<String, Object>> selectCalendarWorkByWeek(int day);

    /**
     *
     * @param partNo
     * @return
     */
    StructureTestObject selectProductByPartNo(String partNo);

    /**
     *
     * @param partNo
     * @return
     */
    StructureTestObject selectByPartNo(String partNo);

    /**
     * 成品标签打印
     * @param ids
     * @return
     */
    List<InsOrderPrintingVo> labelOrderPrinting(List<Integer> ids);

    List<SampleOrderDto> rawAllInsOrderExport(QueryWrapper<SampleOrderDto> ew,  String laboratory, String isOrderAll);

    /**
     * 根据订单查询试验室
     * @param insOrderId
     * @return
     */
    String selectLaboratoryByOrderId(Integer insOrderId);

    InsOrder selectFirstSubmit(Integer insSampleId);
}