from django.db import models
from container.models import ContainerListModel,ContainerWCSModel,TaskModel
# 库位主表（记录实时状态）
class LocationModel(models.Model):
LOCATION_TYPES = (
('T5', '5货位'), # 5托盘/批次
('T4', '4货位'), # 4托盘/批次
('S4', '4单货位'), # 4单托盘
('T2', '2货位'), # 2托盘/批次
('T1', '散货位'), # 1托盘
('M1', '通道区'), # 通道区
('E1', '提升机'), # 提升机
('C1', '输送机'), # 输送机
('B1', '充电桩'), # 货架区
)
LOCATION_STATUS = (
('available', '可用'),
('occupied', '占用'),
('disabled', '禁用'),
('reserved', '预留'),
('maintenance', '维护中'),
)
warehouse_code = models.CharField(max_length=255, verbose_name="Warehouse code")
warehouse_name = models.CharField(max_length=255, verbose_name="Warehouse Name")
shelf_type = models.CharField(max_length=255,default = 'storage', verbose_name="Shelf Type")
row = models.IntegerField(verbose_name="Row") # 位置的行号
col = models.IntegerField(verbose_name="Column") # 位置的列号
layer = models.IntegerField(verbose_name="Layer") # 位置的层号
update_time = models.DateTimeField(auto_now=True, blank=True, null=True, verbose_name="Update Time")
empty_label = models.BooleanField(default=True, verbose_name="Empty Flag")
location_code = models.CharField(max_length=20, unique=True, verbose_name='库位编码')
location_group = models.CharField(max_length=20, verbose_name='库位组')
# 示例：T1-L1C001-1
# T1-L1C001-1 代表货位类型为T1，层号为1，列号为001，货位号为1
location_type = models.CharField(max_length=3, choices=LOCATION_TYPES, verbose_name='货位类型')
status = models.CharField(max_length=20, choices=LOCATION_STATUS, default='available', verbose_name='库位状态')
max_capacity = models.PositiveIntegerField(verbose_name='最大容量') # 根据类型自动设置
current_quantity = models.PositiveIntegerField(default=0, verbose_name='当前数')
c_number = models.IntegerField(default=1, verbose_name='库位远近排序')
current_containers = models.ManyToManyField(ContainerListModel,
through='LocationContainerLink',
verbose_name='当前存放托盘')
coordinate = models.CharField(max_length=50, verbose_name='三维坐标') # 格式：行-列-层
access_priority = models.IntegerField(
default=0,
verbose_name='访问优先级',
help_text='值越大表示越远离主通道，应优先使用'
)
is_active = models.BooleanField(default=True, verbose_name='是否有效')
class Meta:
db_table = 'location'
verbose_name = 'Location'
verbose_name_plural = "Location"
ordering = ['-id']
unique_together = ( 'warehouse_code','row', 'col', 'layer') # 防止重复坐标
@classmethod
def get_existing_positions(cls, warehouse_code, rows, cols, layers):
"""获取已存在的坐标集合"""
return set(
cls.objects.filter(
warehouse_code=warehouse_code,
row__lte=rows,
col__lte=cols,
layer__lte=layers
).values_list('row', 'col', 'layer')
)
# 在LocationModel类中新增方法
@classmethod
def generate_locations(cls, warehouse_code):
# 清空现有数据（新增部分）
cls.objects.filter(warehouse_code=warehouse_code).delete()
"""根据规划图生成库位"""
# 定义核心参数（根据规划图调整）
MAIN_AISLES = [18, 1] # 子通道列号
SUB_AISLES = [2,8, 13] # 主通道行号
for row in range(1, 14): # 1-13行
for col in range(1, 3): # 1-19列
for layer in range(1, 4): # 1-3层
# 判断通道区
if col in MAIN_AISLES or row in SUB_AISLES:
loc_type = 'M1'
c_number = row
# 通道
if col ==1 and row == 1:
loc_type = 'T1'
c_number = 1
# 判断货位类型（根据实际规划）
else:
if row <2:
loc_type = 'T1'
c_number = 1
elif row < 8:
loc_type = 'T5'
c_number = row-2
elif row < 13:
loc_type = 'T4'
c_number = row-8
else:
loc_type = 'T2'
c_number = 16-row
# 生成唯一编码
location_code = f"{loc_type}-L{layer}C{col:03d}-{c_number:02d}"
location_group = f"{loc_type}-L{layer}C{col:03d}"
# print(f"生成库位：{location_code}-{row}-{col}-{layer}")
# 创建库位
cls.objects.update_or_create(
warehouse_code=warehouse_code,
warehouse_name="立体仓库",
row=row,
col=col,
layer=layer,
c_number=c_number,
shelf_type=loc_type,
defaults={
'location_code': location_code,
'location_group': location_group,
'location_type': loc_type,
'max_capacity': {
'T5': 5,
'T4': 4,
'T2': 2,
'T1': 1,
'M1': 0,
'E1': 0,
'C1': 0
}[loc_type],
'coordinate': f"{row}-{col}-{layer}",
'is_active': True
},
access_priority=c_number
)
for row in range(1, 16): # 1-15行
for col in range(3, 17): # 1-16列
for layer in range(1, 4): # 1-3层
# 判断通道区
if col in MAIN_AISLES or row in SUB_AISLES:
loc_type = 'M1'
c_number = row
# 通道
if col ==18 and row == 1:
loc_type = 'T1'
c_number = 1
# 判断货位类型（根据实际规划）
else:
if row <2:
loc_type = 'T1'
c_number = 1
elif row < 8:
loc_type = 'T5'
c_number = row-2
elif row < 13:
loc_type = 'T4'
c_number = row-8
else:
loc_type = 'T2'
c_number = 16-row
# 生成唯一编码
location_code = f"{loc_type}-L{layer}C{col:03d}-{c_number:02d}"
location_group = f"{loc_type}-L{layer}C{col:03d}"
# print(f"生成库位：{location_code}-{row}-{col}-{layer}")
# 创建库位
cls.objects.update_or_create(
warehouse_code=warehouse_code,
row=row,
col=col,
layer=layer,
c_number=c_number,
shelf_type=loc_type,
defaults={
'location_code': location_code,
'location_group': location_group,
'location_type': loc_type,
'max_capacity': {
'T5': 5,
'T4': 4,
'T2': 2,
'T1': 1,
'M1': 0,
'E1': 0,
'C1': 0
}[loc_type],
'coordinate': f"{row}-{col}-{layer}",
'is_active': True
},
access_priority=c_number
)
# print("✅ 库位生成成功！")
for row in range(1, 14): # 1-15行
for col in range(17, 20): # 1-16列
for layer in range(1, 4): # 1-3层
# 判断通道区
if col in MAIN_AISLES or row in SUB_AISLES:
loc_type = 'M1'
c_number = row
# 通道
if col ==18 and row == 1:
loc_type = 'T1'
c_number = 1
# 判断货位类型（根据实际规划）
else:
if row <2:
loc_type = 'T1'
c_number = 1
elif row < 8:
loc_type = 'T5'
c_number = row-2
elif row < 13:
loc_type = 'T4'
c_number = row-8
else:
loc_type = 'T2'
c_number = 16-row
# 生成唯一编码
location_code = f"{loc_type}-L{layer}C{col:03d}-{c_number:02d}"
location_group = f"{loc_type}-L{layer}C{col:03d}"
# print(f"生成库位：{location_code}-{row}-{col}-{layer}")
# 创建库位
cls.objects.update_or_create(
warehouse_code=warehouse_code,
row=row,
col=col,
layer=layer,
c_number=c_number,
shelf_type=loc_type,
defaults={
'location_code': location_code,
'location_group': location_group,
'location_type': loc_type,
'max_capacity': {
'T5': 5,
'T4': 4,
'T2': 2,
'T1': 1,
'M1': 0,
'E1': 0,
'C1': 0
}[loc_type],
'coordinate': f"{row}-{col}-{layer}",
'is_active': True
},
access_priority=c_number
)
# print("✅ 库位生成成功！")
for row in range(1, 18): # 1-17行
for col in range(20, 30): # 19-29列
for layer in range(1, 4): # 1-3层
# 判断通道区
if col in MAIN_AISLES or row in SUB_AISLES:
loc_type = 'M1'
c_number = row
# 通道
if col ==18 and row == 1:
loc_type = 'T1'
c_number = 1
if col ==29 and row == 1:
loc_type = 'T1'
c_number = 1
if col ==29 and row == 14:
loc_type = 'S4'
c_number = 4
if col ==29 and row == 15:
loc_type = 'S4'
c_number = 3
if col ==29 and row == 16:
loc_type = 'S4'
c_number = 2
if col ==29 and row == 17:
loc_type = 'S4'
c_number = 1
# 判断货位类型（根据实际规划）
else:
# 判断货位类型（根据实际规划）
if row < 2:
loc_type = 'T1'
c_number = row
elif row < 8:
loc_type = 'T5'
c_number = row-2
elif row < 13:
loc_type = 'T4'
c_number = row-8
else:
loc_type = 'S4'
c_number = 18-row
# 生成唯一编码
location_code = f"{loc_type}-L{layer}C{col:03d}-{c_number:02d}"
location_group = f"{loc_type}-L{layer}C{col:03d}"
# print(f"生成库位：{location_code}-{row}-{col}-{layer}")
# 创建库位
cls.objects.update_or_create(
warehouse_code=warehouse_code,
row=row,
col=col,
layer=layer,
c_number=c_number,
shelf_type=loc_type,
defaults={
'location_code': location_code,
'location_group': location_group,
'location_type': loc_type,
'max_capacity': {
'T5': 5,
'T4': 4,
'S4': 4,
'T2': 2,
'T1': 1,
'M1': 0,
'E1': 0,
'C1': 0,
'B1': 0
}[loc_type],
'coordinate': f"{row}-{col}-{layer}",
'is_active': True
},
access_priority=c_number
)
# 输送机
for row in [14]: # 1-17行
for col in [1,18]: # 1-19列
for layer in range(1, 4): # 1-3层
# 判断货位类型（根据实际规划）
loc_type = 'C1'
c_number = 1
location_code = f"{loc_type}-L{layer}C{col:03d}-{c_number:02d}"
location_group = f"{loc_type}-L{layer}C{col:03d}"
# print(f"生成库位：{location_code}-{row}-{col}-{layer}")
# 创建库位
# 创建库位
cls.objects.update_or_create(
warehouse_code=warehouse_code,
row=row,
col=col,
layer=layer,
c_number=c_number,
shelf_type=loc_type,
defaults={
'location_code': location_code,
'location_group': location_group,
'location_type': loc_type,
'max_capacity': {
'T5': 5,
'T4': 4,
'S4': 4,
'T2': 2,
'T1': 1,
'M1': 0,
'E1': 0,
'C1': 0,
'B1': 0
}[loc_type],
'coordinate': f"{row}-{col}-{layer}",
'is_active': True
},
access_priority=c_number
)
for row in [16]: # 1-17行
for col in [1,18]: # 1-19列
for layer in [1]: # 1-3层
# 判断货位类型（根据实际规划）
loc_type = 'C1'
c_number = row
location_code = f"{loc_type}-L{layer}C{col:03d}-{c_number:02d}"
location_group = f"{loc_type}-L{layer}C{col:03d}"
# 创建库位
cls.objects.update_or_create(
warehouse_code=warehouse_code,
row=row,
col=col,
layer=layer,
c_number=c_number,
shelf_type=loc_type,
defaults={
'location_code': location_code,
'location_group': location_group,
'location_type': loc_type,
'max_capacity': {
'T5': 5,
'T4': 4,
'S4': 4,
'T2': 2,
'T1': 1,
'M1': 0,
'E1': 0,
'C1': 0,
'B1': 0
}[loc_type],
'coordinate': f"{row}-{col}-{layer}",
'is_active': True
},
access_priority=c_number
)
# 提升机
for row in [15]: # 1-17行
for col in [1,18]: # 1-19列
for layer in range(1, 4): # 1-3层
# 判断货位类型（根据实际规划）
loc_type = 'E1'
c_number = row
location_code = f"{loc_type}-L{layer}C{col:03d}-{c_number:02d}"
location_group = f"{loc_type}-L{layer}C{col:03d}"
# 创建库位
cls.objects.update_or_create(
warehouse_code=warehouse_code,
row=row,
col=col,
layer=layer,
c_number=c_number,
shelf_type=loc_type,
defaults={
'location_code': location_code,
'location_group': location_group,
'location_type': loc_type,
'max_capacity': {
'T5': 5,
'T4': 4,
'S4': 4,
'T2': 2,
'T1': 1,
'M1': 0,
'E1': 0,
'C1': 0,
'B1': 0
}[loc_type],
'coordinate': f"{row}-{col}-{layer}",
'is_active': True
},
access_priority=c_number
)
# 充电桩
for row in [14]: # 1-17行
for col in [2]: # 1-19列
for layer in range(1, 3): # 1-3层
# 判断货位类型（根据实际规划）
loc_type = 'B1'
c_number = 1
location_code = f"{loc_type}-L{layer}C{col:03d}-{c_number:02d}"
location_group = f"{loc_type}-L{layer}C{col:03d}"
# 创建库位
cls.objects.update_or_create(
warehouse_code=warehouse_code,
row=row,
col=col,
layer=layer,
c_number=c_number,
shelf_type=loc_type,
defaults={
'location_code': location_code,
'location_group': location_group,
'location_type': loc_type,
'max_capacity': {
'T5': 5,
'T4': 4,
'S4': 4,
'T2': 2,
'T1': 1,
'M1': 0,
'E1': 0,
'C1': 0,
'B1': 0
}[loc_type],
'coordinate': f"{row}-{col}-{layer}",
'is_active': True
},
access_priority=c_number
)
class LocationGroupModel(models.Model):
LOCATION_TYPES = (
('T5', '5货位'), # 5托盘/批次
('T4', '4货位'), # 4托盘/批次
('S4', '4单货位'), # 4单托盘
('T2', '2货位'), # 2托盘/批次
('T1', '散货位'), # 1托盘
)
LOCATION_STATUS = (
('available', '可用'),
('occupied', '占用'),
('full', '满'),
('disabled', '禁用'),
('reserved', '预留'),
('maintenance', '维护中'),
)
warehouse_code = models.CharField(max_length=50, verbose_name='仓库编码')
group_name = models.CharField(max_length=50, verbose_name='库位组名称')
group_type = models.CharField(max_length=50, choices=LOCATION_TYPES, verbose_name='库位组类型')
group_code = models.CharField(max_length=50, verbose_name='库位组编码')
layer = models.PositiveIntegerField(verbose_name='层数')
location_items = models.ManyToManyField(LocationModel, verbose_name='库位')
status = models.CharField(max_length=20, choices=LOCATION_STATUS, default='available', verbose_name='库位状态')
max_capacity = models.PositiveIntegerField(verbose_name='最大容量') # 根据类型自动设置
current_quantity = models.PositiveIntegerField(default=0, verbose_name='当前托盘数')
current_goods_quantity = models.PositiveIntegerField(default=0, verbose_name='当前货物数')
current_batch = models.CharField(max_length=50, default='', verbose_name='当前批次')
current_goods_code = models.CharField(max_length=50, default='', verbose_name='当前货物编码')
access_priority = models.IntegerField(
default=0,
verbose_name='访问优先级',
help_text='值越大表示越远离主通道，应优先使用'
)
left_priority = models.IntegerField(
default=0,
verbose_name='左侧优先级',
help_text='值越大表示越靠左，应优先使用'
)
right_priority = models.IntegerField(
default=0,
verbose_name='右侧优先级',
help_text='值越大表示越靠右，应优先使用'
)
is_active = models.BooleanField(default=True, verbose_name='是否有效')
# create_time = models.DateTimeField(auto_now_add=True, verbose_name='创建时间')
class Meta:
db_table = 'location_group'
verbose_name = 'Location Group'
verbose_name_plural = "Location Group"
ordering = ['-id']
unique_together = ( 'warehouse_code', 'group_code') # 防止重复组编码
@classmethod
def generate_group(cls,warehouse_code):
cls.objects.filter(warehouse_code=warehouse_code).delete()
MAIN_AISLES = [18, 1] # 子通道列号
SUB_AISLES = [2,8, 13] # 主通道行号
for row in range(1, 14): # 1-13行
for col in range(1, 3): # 1-19列
for layer in range(1, 4): # 1-3层
# 判断通道区
if col in MAIN_AISLES or row in SUB_AISLES:
loc_type = 'M1'
c_number = row
# 通道
if col ==1 and row == 1:
loc_type = 'T1'
c_number = 1
# 判断货位类型（根据实际规划）
else:
if row <2:
loc_type = 'T1'
c_number = 1
elif row < 8:
loc_type = 'T5'
c_number = row-2
elif row < 13:
loc_type = 'T4'
c_number = row-8
else:
loc_type = 'T2'
c_number = 16-row
# 生成唯一编码
print(f"生成库组：{row}-{col}-{layer}")
if loc_type == 'M1':
continue
# 创建库位
group_code = f"{loc_type}-L{layer}C{col:03d}"
group_name = f"{loc_type}-L{layer}C{col:03d}"
# 使用（row+col）*layer作为库位排序
left_priority = (abs(row-13)+abs(col-1))*layer
right_priority = (abs(row-13)+abs(col-18))*layer
if cls.objects.filter(warehouse_code=warehouse_code, group_code=group_code).exists():
group_item = cls.objects.get(warehouse_code=warehouse_code, group_code=group_code)
group_item.location_items.add(LocationModel.objects.get(warehouse_code=warehouse_code, row=row, col=col, layer=layer))
group_item.save()
else:
group_item = cls.objects.create(
warehouse_code=warehouse_code,
layer=layer,
group_name=group_name,
group_type=loc_type,
group_code=group_code,
max_capacity={
'T5': 5,
'T4': 4,
'T2': 2,
'T1': 1,
'S4': 4,
'M1': 0,
'E1': 0,
'C1': 0
}[loc_type],
current_quantity=0,
status='available',
access_priority=c_number,
left_priority=left_priority,
right_priority=right_priority,
is_active=True
)
group_item.location_items.add(LocationModel.objects.get(warehouse_code=warehouse_code, row=row, col=col, layer=layer))
group_item.save()
for row in range(1, 16): # 1-15行
for col in range(3, 17): # 1-16列
for layer in range(1, 4): # 1-3层
# 判断通道区
if col in MAIN_AISLES or row in SUB_AISLES:
loc_type = 'M1'
c_number = row
# 通道
if col ==18 and row == 1:
loc_type = 'T1'
c_number = 1
# 判断货位类型（根据实际规划）
else:
if row <2:
loc_type = 'T1'
c_number = 1
elif row < 8:
loc_type = 'T5'
c_number = row-2
elif row < 13:
loc_type = 'T4'
c_number = row-8
else:
loc_type = 'T2'
c_number = 16-row
# print(f"生成库位：{location_code}-{row}-{col}-{layer}")
if loc_type == 'M1':
continue
# 创建库位
group_code = f"{loc_type}-L{layer}C{col:03d}"
group_name = f"{loc_type}-L{layer}C{col:03d}"
left_priority = (abs(row-13)+abs(col-1))*layer
right_priority = (abs(row-13)+abs(col-18))*layer
if cls.objects.filter(warehouse_code=warehouse_code, group_code=group_code).exists():
group_item = cls.objects.get(warehouse_code=warehouse_code, group_code=group_code)
group_item.location_items.add(LocationModel.objects.get(warehouse_code=warehouse_code, row=row, col=col, layer=layer))
group_item.save()
else:
group_item = cls.objects.create(
warehouse_code=warehouse_code,
layer=layer,
group_name=group_name,
group_type=loc_type,
group_code=group_code,
max_capacity={
'T5': 5,
'T4': 4,
'T2': 2,
'T1': 1,
'S4': 4,
'M1': 0,
'E1': 0,
'C1': 0
}[loc_type],
current_quantity=0,
status='available',
access_priority=c_number,
left_priority=left_priority,
right_priority=right_priority,
is_active=True
)
group_item.location_items.add(LocationModel.objects.get(warehouse_code=warehouse_code, row=row, col=col, layer=layer))
group_item.save()
for row in range(1, 14): # 1-15行
for col in range(17, 20): # 1-16列
for layer in range(1, 4): # 1-3层
# 判断通道区
if col in MAIN_AISLES or row in SUB_AISLES:
loc_type = 'M1'
c_number = row
# 通道
if col ==18 and row == 1:
loc_type = 'T1'
c_number = 1
# 判断货位类型（根据实际规划）
else:
if row <2:
loc_type = 'T1'
c_number = 1
elif row < 8:
loc_type = 'T5'
c_number = row-2
elif row < 13:
loc_type = 'T4'
c_number = row-8
else:
loc_type = 'T2'
c_number = 16-row
# print(f"生成库位：{location_code}-{row}-{col}-{layer}")
if loc_type == 'M1':
continue
# 创建库位
group_code = f"{loc_type}-L{layer}C{col:03d}"
group_name = f"{loc_type}-L{layer}C{col:03d}"
left_priority = (abs(row-13)+abs(col-1))*layer
right_priority = (abs(row-13)+abs(col-18))*layer
if cls.objects.filter(warehouse_code=warehouse_code, group_code=group_code).exists():
group_item = cls.objects.get(warehouse_code=warehouse_code, group_code=group_code)
group_item.location_items.add(LocationModel.objects.get(warehouse_code=warehouse_code, row=row, col=col, layer=layer))
group_item.save()
else:
group_item = cls.objects.create(
warehouse_code=warehouse_code,
layer=layer,
group_name=group_name,
group_type=loc_type,
group_code=group_code,
max_capacity={
'T5': 5,
'T4': 4,
'T2': 2,
'T1': 1,
'S4': 4,
'M1': 0,
'E1': 0,
'C1': 0
}[loc_type],
current_quantity=0,
status='available',
access_priority=c_number,
left_priority=left_priority,
right_priority=right_priority,
is_active=True
)
group_item.location_items.add(LocationModel.objects.get(warehouse_code=warehouse_code, row=row, col=col, layer=layer))
group_item.save()
for row in range(1, 18): # 1-17行
for col in range(20, 30): # 19-29列
for layer in range(1, 4): # 1-3层
# 判断通道区
if col in MAIN_AISLES or row in SUB_AISLES:
loc_type = 'M1'
c_number = row
# 通道
if col ==18 and row == 1:
loc_type = 'T1'
c_number = 1
if col ==29 and row == 1:
loc_type = 'T1'
c_number = 1
if col ==29 and row == 14:
loc_type = 'S4'
c_number = 4
if col ==29 and row == 15:
loc_type = 'S4'
c_number = 3
if col ==29 and row == 16:
loc_type = 'S4'
c_number = 2
if col ==29 and row == 17:
loc_type = 'S4'
c_number = 1
# 判断货位类型（根据实际规划）
else:
# 判断货位类型（根据实际规划）
if row < 2:
loc_type = 'T1'
c_number = row
elif row < 8:
loc_type = 'T5'
c_number = row-2
elif row < 13:
loc_type = 'T4'
c_number = row-8
else:
loc_type = 'S4'
c_number = 18-row
# print(f"生成库位：{location_code}-{row}-{col}-{layer}")
if loc_type == 'M1':
continue
# 创建库位
group_code = f"{loc_type}-L{layer}C{col:03d}"
group_name = f"{loc_type}-L{layer}C{col:03d}"
left_priority = (abs(row-13)+abs(col-1))*layer
right_priority = (abs(row-13)+abs(col-18))*layer
if cls.objects.filter(warehouse_code=warehouse_code, group_code=group_code).exists():
group_item = cls.objects.get(warehouse_code=warehouse_code, group_code=group_code)
group_item.location_items.add(LocationModel.objects.get(warehouse_code=warehouse_code, row=row, col=col, layer=layer))
group_item.save()
else:
group_item = cls.objects.create(
warehouse_code=warehouse_code,
layer=layer,
group_name=group_name,
group_type=loc_type,
group_code=group_code,
max_capacity={
'T5': 5,
'T4': 4,
'T2': 2,
'T1': 1,
'S4': 4,
'M1': 0,
'E1': 0,
'C1': 0
}[loc_type],
current_quantity=0,
status='available',
access_priority=c_number,
left_priority=left_priority,
right_priority=right_priority,
is_active=True
)
group_item.location_items.add(LocationModel.objects.get(warehouse_code=warehouse_code, row=row, col=col, layer=layer))
group_item.save()
# 库位-托盘关联表（记录实时存放关系）
class LocationContainerLink(models.Model):
location = models.ForeignKey(LocationModel, on_delete=models.CASCADE, verbose_name='库位')
container = models.ForeignKey(ContainerListModel,on_delete=models.CASCADE)
task_wcs = models.ForeignKey(ContainerWCSModel, on_delete=models.CASCADE, null=True, blank=True)
task_detail = models.ForeignKey(TaskModel, on_delete=models.CASCADE, null=True, blank=True)
put_time = models.DateTimeField(auto_now_add=True, verbose_name='上架时间')
operator = models.CharField(max_length=50, verbose_name='操作人')
is_active = models.BooleanField(default=True, verbose_name='是否有效')
class Meta:
db_table = 'location_container_link'
verbose_name = 'Location-Container Link'
verbose_name_plural = "Location-Container Link"
ordering = ['-id']
unique_together = ( 'location', 'container') # 防止重复关联
class DeviceModel(models.Model):
warehouse_code = models.CharField(max_length=255, verbose_name="Warehouse Code")
location = models.ForeignKey(LocationModel, on_delete=models.CASCADE)
device_id = models.CharField(max_length=255, verbose_name="Device ID")
device_name = models.CharField(max_length=255, verbose_name="Device Name")
device_type = models.CharField(max_length=255, verbose_name="Device Type")
ip_address = models.CharField(max_length=255, verbose_name="IP Address")
port = models.IntegerField(verbose_name="Port")
mode = models.CharField(default='inbound', max_length=255, verbose_name="Mode")
status = models.CharField(max_length=255, verbose_name="Status")
create_time = models.DateTimeField(auto_now_add=True, verbose_name="Create Time")
update_time = models.DateTimeField(auto_now=True, blank=True, null=True, verbose_name="Update Time")
class Meta:
db_table = 'device'
verbose_name = 'Device'
verbose_name_plural = "Device"
ordering = ['-id']
unique_together = ( 'location', 'device_id') # 防止重复设备
@classmethod
def generate_device(cls,warehouse_code):
cls.objects.filter(warehouse_code=warehouse_code).delete()
# 输送机
location = LocationModel.objects.get(warehouse_code=warehouse_code, row=16, col=1, layer=1)
# 创建库位
cls.objects.update_or_create(
warehouse_code=warehouse_code,
location=location,
device_id=f"203",
device_name=f"203",
device_type='输送机',
ip_address='192.168.18.1',
mode = 'inbound',
port=203,
status='available',
)
location = LocationModel.objects.get(warehouse_code=warehouse_code, row=16, col=18, layer=1)
# 创建库位
cls.objects.update_or_create(
warehouse_code=warehouse_code,
location=location,
device_id=f"103",
device_name=f"103",
device_type='输送机',
ip_address='192.168.18.1',
mode = 'outbound',
port=103,
status='available',
)
# 库位变更记录（历史追溯）
class LocationChangeLog(models.Model):
OPERATION_TYPES = (
('put', '上架'),
('pick', '下架'),
('move_in', '移入'),
('move_out', '移出')
)
location = models.ForeignKey(LocationModel, on_delete=models.CASCADE, verbose_name='库位')
container = models.ForeignKey(ContainerListModel, on_delete=models.CASCADE, verbose_name='托盘')
task_wcs = models.ForeignKey(ContainerWCSModel, on_delete=models.CASCADE, null=True, blank=True, verbose_name='WCS任务')
task_detail = models.ForeignKey(TaskModel, on_delete=models.CASCADE, null=True, blank=True, verbose_name='批次详情')
operation_type = models.CharField(max_length=10, choices=OPERATION_TYPES, verbose_name='操作类型')
related_location = models.ForeignKey(LocationModel,
on_delete=models.SET_NULL,
null=True,
related_name='related_logs',
verbose_name='关联库位') # 用于移库操作
timestamp = models.DateTimeField(auto_now_add=True, verbose_name='操作时间')
class Meta:
db_table = 'location_change_log'
verbose_name = 'Location Change Log'
verbose_name_plural = "Location Change Log"
ordering = ['-id']
class base_location(models.Model):
layer1_pressure = models.IntegerField(default=0, verbose_name='第一层工作压力')
layer2_pressure = models.IntegerField(default=0, verbose_name='第二层工作压力')
layer3_pressure = models.IntegerField(default=0, verbose_name='第三层工作压力')
class Meta:
db_table = 'base_location'
verbose_name = 'Base_location'
verbose_name_plural = "Base_location"
ordering = ['-id']
class alloction_pre(models.Model):
batch_number = models.CharField(max_length=255, verbose_name='批次号')
layer_pre_type = models.JSONField(default=list, verbose_name='预留方案')
layer_solution_type = models.JSONField(default=list, verbose_name='规划方案')
layer1_task_finish_number = models.IntegerField(default=0, verbose_name='第一层任务完成数')
layer2_task_finish_number = models.IntegerField(default=0, verbose_name='第二层任务完成数')
layer3_task_finish_number = models.IntegerField(default=0, verbose_name='第三层任务完成数')
create_time = models.DateTimeField(auto_now_add=True, verbose_name='创建时间')
class Meta:
db_table = 'allocation_pre'
verbose_name = 'Allocation_pre'
verbose_name_plural = "Allocation_pre"
ordering = ['-id']
class allocation_history(models.Model):
location = models.ForeignKey(LocationModel, on_delete=models.CASCADE, verbose_name='库位')
container = models.ForeignKey(ContainerListModel, on_delete=models.CASCADE, verbose_name='托盘')
task_wcs = models.ForeignKey(ContainerWCSModel, on_delete=models.CASCADE, null=True, blank=True, verbose_name='WCS任务')
task_detail = models.ForeignKey(TaskModel, on_delete=models.CASCADE, null=True, blank=True, verbose_name='批次详情')
operation_type = models.CharField(max_length=10, verbose_name='操作类型')
related_location = models.ForeignKey(LocationModel,
on_delete=models.SET_NULL,
null=True,
related_name='related_logs_history',
verbose_name='关联库位') # 用于移库操作
timestamp = models.DateTimeField(auto_now_add=True, verbose_name='操作时间')
class Meta:
db_table = 'allocation_history'
verbose_name = 'Allocation_history'
verbose_name_plural = "Allocation_history"
ordering = ['-id']