/*
 *    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.production.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.chinaztt.mes.basic.entity.Location;
import com.chinaztt.mes.production.dto.ApplyReportTypeDetailDTO;
import com.chinaztt.mes.production.dto.OperationTaskDTO;
import com.chinaztt.mes.production.entity.OperationTask;
import com.chinaztt.mes.production.vo.OperationTaskScreenVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

/**
 * 工序任务
 *
 * @author zhangxy
 * @date 2020-09-18 09:26:35
 */
@Mapper
public interface OperationTaskMapper extends BaseMapper<OperationTask> {

	/**
	 * 查询机台工序任务，车间执行看板用
	 *
	 * @param workstationId
	 * @return
	 */
	List<OperationTaskDTO> getListByWorkstationId(Long workstationId);

	/**
	 * 分页查询
	 *
	 * @param page
	 * @param ew
	 * @return
	 */
	IPage<List<OperationTaskDTO>> queryPage(Page page, @Param("ew") QueryWrapper<OperationTaskDTO> ew);

	/**
	 * 查询工单任务
	 *
	 * @param gen
	 * @return
	 */
	List<OperationTaskDTO> getOperationTask(@Param("ew") QueryWrapper<OperationTaskDTO> gen,
											@Param("stateLimit") Boolean stateLimit,
											@Param("productSn") String productSn,
											@Param("salesOrder") String salesOrder,
											@Param("productName") String productName,
											@Param("outBatchNo") String outBatchNo,
											@Param("mpsNo") String mpsNo,
											@Param("operationStockStatus") Boolean operationStockStatus);

	/**
	 * 更新完成数量
	 *
	 * @param id
	 * @param diffQuantity
	 */
	void updateCompletedQuantity(@Param("id") Long id, @Param("diffQuantity") BigDecimal diffQuantity);

	/**
	 * 根据id查询
	 *
	 * @param id
	 * @return
	 */
	OperationTaskDTO getOperationTaskDTO(Long id);

	/**
	 * 关联删除
	 *
	 * @param id
	 * @return
	 */
	void deleteOperationById(Long id);

	/**
	 * PDA查询所有
	 *
	 * @param page
	 * @param gen
	 * @return
	 */
	IPage<List<OperationTaskDTO>> pdaPage(Page page, @Param("ew") QueryWrapper<OperationTaskDTO> gen);

	/**
	 * 查询当前工单同一个制造订单下的下一道工序的工单
	 *
	 * @param operationTaskId
	 * @return
	 */
	List<OperationTask> getLastOperationTask(Long operationTaskId);

	/**
	 * @param ids
	 * @return
	 */
	List<OperationTaskDTO> selectByIds(@Param("ids") List<Long> ids);

	/**
	 * @param id
	 * @return
	 */
	List<OperationTaskDTO> getCombinedOperationTaskInfo(Long id);

	/**
	 * 获取检测汇报类型基础数据
	 *
	 * @return
	 */
	List<ApplyReportTypeDetailDTO> getApplyReportType();

	/**
	 * 根据车间订单查询临时车间订单
	 *
	 * @param moId
	 * @return
	 */
	List<OperationTaskDTO> getFromMoOptionByMoId(Long moId);

	/**
	 * 根据工单ids查询货盘运输任务
	 *
	 * @param ids
	 * @return
	 */
	List<String> getPalletOptaskCode(@Param("ids") List<Long> ids);

	/**
	 * 根据工作站编号获取工作站对应的投料库位列表
	 *
	 * @param workstationNo 工作站编号
	 * @return
	 */
	List<Location> getFeedLocationListByWorkstationNo(@Param("workstationNo") String workstationNo);

	/**
	 * 根据工作站编号获取工作站对的工单列表
	 *
	 * @param workstationNo
	 * @return
	 */
	List<OperationTask> getActiveOperationTaskListByWorkstationNo(@Param("workstationNo") String workstationNo);

	/**
	 * 根据工作站编号获取没有直接指定工作站的工单列表
	 *
	 * @param workstationNo
	 * @return
	 */
	List<OperationTask> getActiveOperationTaskListUnPointWorkstationByWorkstationNo(@Param("workstationNo") String workstationNo);

	/**
	 * 根据货盘运输任务id查询工单
	 *
	 * @param palletId
	 * @return
	 */
	List<OperationTaskDTO> getByPalletTransId(Long palletId);

	/**
	 * 根据工单id查询信息
	 *
	 * @param id
	 * @return
	 */
	OperationTaskDTO getOperationInfoById(Long id);

	/**
	 * @param id
	 */
	void updateNextPriority(Long id);

	/**
	 * @param id
	 */
	void removeActualFinishDateById(Long id);

	/**
	 * 根据产出批次号获取生产数量（包含交班产出）
	 *
	 * @param batchNo
	 * @return
	 */
	BigDecimal getProdOutQtyByBatchNo(@Param("batchNo") String batchNo);

	/**
	 * 根据产出批次号获取工序id
	 *
	 * @param batchNo
	 * @return
	 */
	Long getOperationId(@Param("batchNo") String batchNo);

	/**
	 * 根据工单id查找对应车间订单号
	 *
	 * @param operationTaskId
	 * @return
	 */
	String getTaskMoNo(@Param("id") Long operationTaskId);

	/**
	 * 根据工单id查找对应车间订单下所有工单状态
	 *
	 * @param operationTaskId
	 * @return
	 */
	List<String> getAllTaskStateByTaskId(@Param("id") Long operationTaskId);

	/**
	 * 根据工单id判断当前是否是最后一道工序工单
	 *
	 * @param id
	 * @return
	 */
	Boolean validateIsLastOperation(@Param("id") Long id);

	/**
	 * @param operationTaskId
	 * @return
	 */
	Long getFirstOperationId(@Param("operationTaskId") Long operationTaskId);

	/**
	 * @param operationTaskId
	 * @return
	 */
	Long getOperationIdByTaskId(@Param("operationTaskId") Long operationTaskId);

	/**
	 * 查询根据客户订单id 查询工单
	 *
	 * @param customerOrderId
	 * @return
	 */
	List<OperationTaskScreenVO> getByCustomerOrderId(@Param("customerOrderId") Long customerOrderId);
}