/*
 *    Copyright (c) 2018-2025, ztt All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 *
 * Redistributions of source code must retain the above copyright notice,
 * this list of conditions and the following disclaimer.
 * Redistributions in binary form must reproduce the above copyright
 * notice, this list of conditions and the following disclaimer in the
 * documentation and/or other materials provided with the distribution.
 * Neither the name of the pig4cloud.com developer nor the names of its
 * contributors may be used to endorse or promote products derived from
 * this software without specific prior written permission.
 * Author: ztt
 */

package com.chinaztt.mes.plan.mapper;

import com.baomidou.mybatisplus.annotation.SqlParser;
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.chinaztt.mes.plan.dto.ManufacturingOrderDTO;
import com.chinaztt.mes.plan.dto.MoTestStandardDTO;
import com.chinaztt.mes.plan.entity.ManufacturingOrder;
import com.chinaztt.mes.plan.entity.OrderParam;
import com.chinaztt.mes.plan.excel.ManufacturingOrderData;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 制造订单表
 *
 * @author cxf
 * @date 2020-09-24 14:26:01
 */
@Mapper
public interface ManufacturingOrderMapper extends BaseMapper<ManufacturingOrder> {

    /**
     * 分页查询
     *
     * @param page
     * @param query
     * @return
     */
	@SqlParser(filter = true)
    IPage<List<ManufacturingOrder>> getManufacturingOrderPage(Page page, @Param("ew") QueryWrapper<ManufacturingOrderDTO> query, @Param("orderParam") OrderParam orderParam);

    /**
     * 根据id查询制造订单
     *
     * @param id
     * @return
     */
    ManufacturingOrderDTO selectDtoById(Long id);
	/**
	 * 通过id查询工单来源
	 *
	 * @param id
	 * @return
	 */
	List<ManufacturingOrderDTO> getOperationSupplyById(Long id);
	/**
	 * 分页查询
	 *
	 * @param page
	 * @param query
	 * @param list
	 * @return
	 */
	IPage<List<ManufacturingOrder>> getManufacturingOrderPageByCustomer(Page page,@Param("ew") QueryWrapper<ManufacturingOrderDTO> query,@Param("list")List<Long> list);

	/**
	 * 根据状态查询对应的工单
	 *
	 * @param moId
	 * @param state
	 * @return
	 */
	List<String> checkOperationTaskStateByMoId(@Param("moId") Long moId, @Param("stateList") List<String> stateList);
	/**
	 * 分页查询制造订单报表
	 * @param page
	 * @param gen
	 * @return
	 */
	IPage<ManufacturingOrderDTO> getStatementPage(Page page, @Param("ew")QueryWrapper<ManufacturingOrderDTO> gen);

	/**
	 * 根据报工产出的SN号查询制造订单
	 *
	 * @param sn
	 * @return
	 */
	List<MoTestStandardDTO> getManufacturingOrder(@Param("sn")String sn);

	/**
	 * distinct 查询 零件id | 工艺id | bomId
	 * @param ids
	 * @return
	 */
	List<String> getMergeCheckData(@Param("ids") List<Long> ids);

	/**
	 * 根据工单查找SN
	 * @param taskId
	 * @return
	 */
	String getSNByTaskId(@Param("taskId") Long taskId);

	/**
	 * exccel导出查询
	 *
	 * @param query
	 * @param list
	 * @return
	 */
	List<ManufacturingOrderData> getExcelDataByList(@Param("ew") QueryWrapper<ManufacturingOrderDTO> query,@Param("list")List<Long> list);

	/**
	 * exccel导出查询
	 *
	 * @param query
	 * @param orderParam
	 * @return
	 */
	@SqlParser(filter = true)
	List<ManufacturingOrderData> getExcelDataByParam( @Param("ew") QueryWrapper<ManufacturingOrderDTO> query, @Param("orderParam") OrderParam orderParam);

	/**
	 * 查找对应车间订单下所有工单状态
	 * @param moId
	 * @return
	 */
	List<String> getAllStateByMoId(@Param("moId") Long moId);
}