/*
 *    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.basic.mapper;

import com.alibaba.fastjson.JSONObject;
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.dto.LocationDTO;
import com.chinaztt.mes.basic.entity.Location;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

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

/**
 * 库位基础数据
 *
 * @author sunxl
 * @date 2020-09-21 08:18:12
 */
@Mapper
public interface LocationMapper extends BaseMapper<Location> {
	/**
	 * Description: 查询库位列表
	 *
	 * @param page
	 * @param ew
	 * @return IPage<List < Location>>
	 */
	IPage<List<Location>> getLoc(Page page, @Param("ew") QueryWrapper<LocationDTO> ew);


	/**
	 * Description: 查询库位列表
	 *
	 * @param page
	 * @param ew
	 * @return IPage<List < Location>>
	 */
	IPage<List<LocationDTO>> getLocationDtoPage(Page page, @Param("ew") QueryWrapper<LocationDTO> ew);


	/**
	 * Description: 将编号变成null
	 *
	 * @param ids
	 */
	void upLocationDate(@Param("ids") List<Long> ids);

	/**
	 * 关联工作站的库位
	 *
	 * @param id
	 * @return
	 */
	List<LocationDTO> getNoWorkstationLocation(Long id);

	/**
	 * Description: 查询库位列表
	 *
	 * @param location
	 * @return List<Location>
	 */
	List<Location> getPrepare(Location location);

	/**
	 * PDA查询所有
	 *
	 * @param gen
	 * @return
	 */
	List<JSONObject> pdaList(@Param("ew") QueryWrapper<LocationDTO> gen);

	/**
	 * 根据库位编号查询库位信息
	 *
	 * @param locationNo
	 * @return
	 */
	Location getLocationByLocationNo(@Param("locationNo") String locationNo);


	/**
	 * 根据工作站id 查询type是4 的库位
	 *
	 * @param workstationId
	 * @return
	 */
	List<Location> getLocation4(String workstationId);

	/**
	 * 根据工作站id和库位类型检索库位
	 *
	 * @param workstationId
	 * @param locationType
	 * @return
	 */
	List<Location> getLocationByWorkstationId(@Param("workstationId") Long workstationId, @Param("locationType") Long locationType);

	/**
	 * 根据localGroups搜索库位号
	 *
	 * @param localGroups
	 * @return
	 */
	List<Map> getLocationByGroups(@Param("localGroups")List<Long> localGroups);

	/**
	 * 获取成品库位
	 */
	List<Location> getFinishProductLocation();

	/**
	 * 根据工作站查找退料库位（投入库位，待处理库位）
	 * @param workstationId
	 * @return
	 */
	List<Location> getReturnLocationByWorkstationId(@Param("workstationId") Long workstationId,
													@Param("locationTypeList") List<Long> locationTypeList);
}