package com.thhy.materials.modules.biz.pipeoutplan.mapper;

import com.thhy.materials.modules.biz.pipeoutplan.entity.PipeOutPlanEntity;
import com.thhy.materials.modules.biz.pipeoutplan.entity.PipeOutPlanMothEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

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

/**
 * @Author QiuYuHao
 * @CreateDate 2023-11-03 9:41:37
 * 发运计划mapper
 */
@Mapper
public interface PipeOutPlanMapper {

	/**
	 * 新增发运计划表
	 * @param pipeOutPlanEntity
	 */
	void insert(PipeOutPlanEntity pipeOutPlanEntity);

	/**
	 * 新增发运计划月数表
	 * @param pipeOutPlanMothEntity
	 */
	void insertMoth(PipeOutPlanMothEntity pipeOutPlanMothEntity);

	/**
	 * 删除发运计划表
	 * @param pipeNeedId
	 */
	void delete(String pipeNeedId);

	/**
	 * 删除发运计划月数表
	 * @param pipeNeedId
	 */
	void deleteMoth(String pipeNeedId);

	/**
	 * 更新发运计划表
	 * @param pipeOutPlanEntity
	 */
	void update(PipeOutPlanEntity pipeOutPlanEntity);

	/**
	 * 查询单条发运计划表
	 * @param pipeNeedId
	 * @return
	 */
	PipeOutPlanEntity selectInfo(String pipeNeedId);

	PipeOutPlanEntity selectInfoByProIdAndYear(
			@Param("proId") String proId,
			@Param("planYear") Integer year);

	/**
	 * 查询发运计划列表
	 * @param map
	 * @return
	 */
	List<PipeOutPlanEntity> findAll(Map<String,Object> map);

	/**
	 * 查询发运计划月数表
	 * @param pipeNeedId
	 * @return
	 */
	List<PipeOutPlanMothEntity> findMothList(String pipeNeedId);

	/**
	 * 查询每月数量
	 * @param proId
	 * @param year
	 * @return
	 */
	List<PipeOutPlanMothEntity> findMothListByProIdAndYear(@Param("proId") String proId,
	                                                       @Param("year") String year,
	                                                       @Param("planOutId") String planOutId);
}