LocationMapper.java
2.83 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
package com.huaheng.pc.config.location.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.huaheng.pc.config.location.domain.Location;
import com.huaheng.pc.config.points.domain.Points;
import org.apache.ibatis.annotations.Param;
import java.util.LinkedHashMap;
import java.util.List;
public interface LocationMapper extends BaseMapper<Location> {
void updateStatus(@Param("warehouseCode") String warehouseCode, @Param("code") String code, @Param("status") String status);
Location position(String locatingRule);
int addList(@Param("locations") List<Location> locations);
int updateList(@Param("locations") List<Location> locations);
Location getAllLocation(@Param("warehouseCode") String warehouseCode, @Param("type") String type);
//库位利用率
List<LinkedHashMap<String, Object>> getLocationProp();
List<Location> pickLocation();
List<Location> selectLocationByContainerEmpty(@Param("warehouseCode") String warehouseCode, @Param("zoneCode") String zoneCode, @Param("roadWay") String roadWay);
List<Location> selectContainerEmpty(@Param("warehouseCode") String warehouseCode);
int getFirstRowOfZone(@Param("warehouseCode") String warehouseCode, @Param("locationType") String locationType);
int getLastRowOfZone(@Param("warehouseCode") String warehouseCode, @Param("locationType") String locationType);
Location selectAddress(Location location);
List<Location> selectEmptyAddress(Points points);
//查出外侧有货，内测无货的库位
List<String> selectlistEmpty(String warehouseCode);
List<Location> selectCode( String warehouseCode);
//查找空库位
Location selectByPrefix(Location location);
//查找类似空库位
Location selectModelByOld(Location location);
//查找类似空库位
Location selectModelByOlds(@Param("location") Location location,@Param("codes") List<String> codes);
/**
* 获取相邻的两个库位（存在托盘或者不存在托盘）
* @param layer
* @param line
* @param flag true表示存在托盘，false表示不存在托盘
* @return
*/
List<Location> getLocationAajacentIsNull(@Param("layer")Integer layer,@Param("line")Integer line,@Param("flag")Boolean flag) ;
Location getLocationRoadWay(@Param("roadway") Integer roadway);
/**
* 获取周边的库位（存在托盘或者不存在托盘）
* @param line
* @param layer
* @param flag true表示存在托盘，false表示不存在托盘
* @return
*/
List<Location> getLocationAdjacent(@Param("line")Integer line,@Param("layer")Integer layer,@Param("flag")Boolean flag);
Location getLocationFarAway(@Param("roadway") Integer roadway,@Param("flag")int flag,@Param("layer")int layer);
Location getLocationOfRule();
List<Location> selectListInventory(String zoneCode);
}