550 lines
30 KiB
Python
550 lines
30 KiB
Python
import hashlib
|
||
import os
|
||
|
||
from django.contrib.auth.models import AbstractUser
|
||
from django.db import models
|
||
from utils.models import CoreModel
|
||
|
||
|
||
STATUS_CHOICES = (
|
||
(0, "禁用"),
|
||
(1, "启用"),
|
||
)
|
||
|
||
|
||
class Users(AbstractUser, CoreModel):
|
||
username = models.CharField(max_length=150, unique=True, db_index=True, verbose_name='用户账号',
|
||
help_text="用户账号")
|
||
email = models.EmailField(max_length=255, verbose_name="邮箱", null=True, blank=True, help_text="邮箱")
|
||
mobile = models.CharField(max_length=255, verbose_name="电话", null=True, blank=True, help_text="电话")
|
||
avatar = models.TextField(verbose_name="头像", null=True, blank=True, help_text="头像")
|
||
name = models.CharField(max_length=40, verbose_name="姓名", help_text="姓名")
|
||
status = models.BooleanField(default=True, verbose_name="状态", help_text="状态")
|
||
GENDER_CHOICES = (
|
||
(0, "女"),
|
||
(1, "男"),
|
||
)
|
||
gender = models.IntegerField(choices=GENDER_CHOICES, default=1, verbose_name="性别", null=True, blank=True,
|
||
help_text="性别")
|
||
USER_TYPE = (
|
||
(0, "后台用户"),
|
||
(1, "前台用户"),
|
||
)
|
||
user_type = models.IntegerField(choices=USER_TYPE, default=0, verbose_name="用户类型", null=True, blank=True,
|
||
help_text="用户类型")
|
||
post = models.ManyToManyField(to='Post', verbose_name='关联岗位', db_constraint=False, help_text="关联岗位")
|
||
role = models.ManyToManyField(to='Role', verbose_name='关联角色', db_constraint=False, help_text="关联角色")
|
||
dept = models.ForeignKey(to='Dept', verbose_name='所属部门', on_delete=models.SET_NULL, db_constraint=False,
|
||
null=True,
|
||
blank=True, help_text="关联部门")
|
||
first_name = models.CharField(max_length=150, blank=True, null=True)
|
||
last_name = models.CharField(max_length=150, blank=True, null=True)
|
||
home_path = models.CharField(max_length=150, blank=True, null=True)
|
||
|
||
|
||
class Meta:
|
||
db_table = "system_users"
|
||
verbose_name = '用户表'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('-create_datetime',)
|
||
|
||
|
||
class Post(CoreModel):
|
||
name = models.CharField(null=False, max_length=64, verbose_name="岗位名称", help_text="岗位名称")
|
||
code = models.CharField(max_length=32, verbose_name="岗位编码", help_text="岗位编码")
|
||
STATUS_CHOICES = (
|
||
(0, "离职"),
|
||
(1, "在职"),
|
||
)
|
||
status = models.IntegerField(choices=STATUS_CHOICES, default=1, verbose_name="岗位状态", help_text="岗位状态")
|
||
|
||
class Meta:
|
||
db_table = "system_post"
|
||
verbose_name = '岗位表'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('sort',)
|
||
|
||
|
||
class Role(CoreModel):
|
||
name = models.CharField(max_length=64, verbose_name="角色名称", help_text="角色名称")
|
||
code = models.CharField(max_length=64, unique=True, verbose_name="角色编码", help_text="角色编码")
|
||
# key = models.CharField(max_length=64, unique=True, verbose_name="权限字符", help_text="权限字符")
|
||
status = models.BooleanField(default=True, verbose_name="角色状态", help_text="角色状态")
|
||
admin = models.BooleanField(default=False, verbose_name="是否为admin", help_text="是否为admin")
|
||
DATASCOPE_CHOICES = (
|
||
(0, "仅本人数据权限"),
|
||
(1, "本部门数据权限"),
|
||
(2, "本部门及以下数据权限"),
|
||
(3, "全部数据权限"),
|
||
(4, "自定数据权限"),
|
||
)
|
||
data_range = models.IntegerField(default=0, choices=DATASCOPE_CHOICES, verbose_name="数据权限范围",
|
||
help_text="数据权限范围")
|
||
dept = models.ManyToManyField(to='Dept', verbose_name='数据权限-关联部门', db_constraint=False,
|
||
help_text="数据权限-关联部门")
|
||
menu = models.ManyToManyField(to='Menu', verbose_name='关联菜单', db_constraint=False, help_text="关联菜单")
|
||
permission = models.ManyToManyField(to='MenuButton', verbose_name='关联菜单的接口按钮', db_constraint=False,
|
||
help_text="关联菜单的接口按钮")
|
||
column = models.ManyToManyField(to='MenuColumnField', verbose_name='列表权限', db_constraint=False,
|
||
help_text="列表权限")
|
||
|
||
class Meta:
|
||
db_table = 'system_role'
|
||
verbose_name = '角色表'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('sort',)
|
||
|
||
|
||
class Dept(CoreModel):
|
||
name = models.CharField(max_length=64, verbose_name="部门名称", help_text="部门名称")
|
||
owner = models.CharField(max_length=32, verbose_name="负责人", null=True, blank=True, help_text="负责人")
|
||
phone = models.CharField(max_length=32, verbose_name="联系电话", null=True, blank=True, help_text="联系电话")
|
||
email = models.EmailField(max_length=32, verbose_name="邮箱", null=True, blank=True, help_text="邮箱")
|
||
status = models.BooleanField(default=True, verbose_name="部门状态", null=True, blank=True,
|
||
help_text="部门状态")
|
||
parent = models.ForeignKey(to='Dept', on_delete=models.PROTECT, default=None, verbose_name="上级部门",
|
||
db_constraint=False, null=True, blank=True, help_text="上级部门")
|
||
|
||
class Meta:
|
||
db_table = "system_dept"
|
||
verbose_name = '部门表'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('sort',)
|
||
|
||
|
||
class Button(CoreModel):
|
||
name = models.CharField(max_length=64, unique=True, verbose_name="权限名称", help_text="权限名称")
|
||
code = models.CharField(max_length=64, unique=True, verbose_name="权限值", help_text="权限值")
|
||
status = models.BooleanField(default=True, verbose_name="按钮状态", null=True, blank=True, help_text="按钮状态")
|
||
|
||
class Meta:
|
||
db_table = "system_button"
|
||
verbose_name = '权限标识表'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('sort',)
|
||
|
||
|
||
class Menu(CoreModel):
|
||
parent = models.ForeignKey(to='Menu', on_delete=models.CASCADE, verbose_name="上级菜单", null=True, blank=True,
|
||
db_constraint=False, help_text="上级菜单")
|
||
icon = models.CharField(max_length=64, default='ant-design:book-outlined', verbose_name="菜单图标",
|
||
help_text="菜单图标")
|
||
title = models.CharField(max_length=64, verbose_name="菜单名称", help_text="菜单名称")
|
||
permission = models.CharField(max_length=64, null=True, blank=True, verbose_name="权限标识", help_text="权限标识")
|
||
ISLINK_CHOICES = (
|
||
(0, "否"),
|
||
(1, "是"),
|
||
)
|
||
is_ext = models.BooleanField(default=False, verbose_name="是否外链", help_text="是否外链")
|
||
|
||
TYPE_CHOICES = (
|
||
(0, "目录"),
|
||
(1, "菜单"),
|
||
)
|
||
type = models.IntegerField(choices=TYPE_CHOICES, verbose_name="是否目录", help_text="是否目录")
|
||
path = models.CharField(max_length=128, verbose_name="路由地址", null=True, blank=True, help_text="路由地址")
|
||
redirect = models.CharField(max_length=128, verbose_name="重定向地址", null=True, blank=True,
|
||
help_text="重定向地址")
|
||
|
||
component = models.CharField(max_length=128, verbose_name="组件地址", null=True, blank=True, help_text="组件地址")
|
||
name = models.CharField(max_length=50, verbose_name="组件名称", null=True, blank=True, help_text="组件名称")
|
||
status = models.BooleanField(default=True, blank=True, verbose_name="菜单状态", help_text="菜单状态")
|
||
keepalive = models.BooleanField(default=False, blank=True, verbose_name="是否页面缓存", help_text="是否页面缓存")
|
||
hide_menu = models.BooleanField(default=False, blank=True, verbose_name="侧边栏中是否隐藏",
|
||
help_text="侧边栏中是否隐藏")
|
||
|
||
class Meta:
|
||
db_table = "system_menu"
|
||
verbose_name = '菜单表'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('sort',)
|
||
|
||
|
||
class MenuButton(CoreModel):
|
||
menu = models.ForeignKey(to="Menu", db_constraint=False, related_name="menuPermission", on_delete=models.CASCADE,
|
||
verbose_name="关联菜单", help_text='关联菜单')
|
||
name = models.CharField(max_length=64, verbose_name="名称", help_text="名称")
|
||
code = models.CharField(max_length=64, verbose_name="权限值", help_text="权限值")
|
||
api = models.CharField(max_length=200, verbose_name="接口地址", help_text="接口地址")
|
||
METHOD_CHOICES = (
|
||
(0, "GET"),
|
||
(1, "POST"),
|
||
(2, "PUT"),
|
||
(3, "DELETE"),
|
||
)
|
||
method = models.IntegerField(default=0, verbose_name="接口请求方法", null=True, blank=True,
|
||
help_text="接口请求方法")
|
||
|
||
class Meta:
|
||
db_table = "system_menu_button"
|
||
verbose_name = '菜单权限表'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('sort',)
|
||
|
||
|
||
class MenuColumnField(CoreModel):
|
||
menu = models.ForeignKey(to="Menu", db_constraint=False, related_name="menuColumnField", on_delete=models.CASCADE,
|
||
verbose_name="关联菜单", help_text='关联菜单')
|
||
name = models.CharField(max_length=64, verbose_name="名称", help_text="名称")
|
||
code = models.CharField(max_length=64, verbose_name="权限值", help_text="权限值")
|
||
|
||
class Meta:
|
||
db_table = "system_menu_column_field"
|
||
verbose_name = '菜单数据列表'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('sort',)
|
||
|
||
|
||
class Dict(CoreModel):
|
||
name = models.CharField(max_length=100, blank=True, null=True, verbose_name="字典名称", help_text="字典名称")
|
||
code = models.CharField(max_length=100, blank=True, null=True, verbose_name="编码", help_text="编码")
|
||
status = models.BooleanField(default=True, blank=True, verbose_name="状态", help_text="状态")
|
||
remark = models.CharField(max_length=2000, blank=True, null=True, verbose_name="备注", help_text="备注")
|
||
|
||
class Meta:
|
||
db_table = 'system_dict'
|
||
verbose_name = "字典表"
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('sort',)
|
||
|
||
|
||
class DictItem(CoreModel):
|
||
icon = models.CharField(max_length=100, blank=True, null=True, verbose_name="ICON", help_text="ICON")
|
||
label = models.CharField(max_length=100, blank=True, null=True, verbose_name="显示名称", help_text="显示名称")
|
||
value = models.CharField(max_length=100, blank=True, null=True, verbose_name="实际值", help_text="实际值")
|
||
status = models.BooleanField(default=True, blank=True, verbose_name="状态", help_text="状态")
|
||
dict = models.ForeignKey(to="Dict", db_constraint=False, related_name="dictItem", on_delete=models.CASCADE,
|
||
help_text="字典")
|
||
remark = models.CharField(max_length=2000, blank=True, null=True, verbose_name="备注", help_text="备注")
|
||
|
||
class Meta:
|
||
db_table = 'system_dict_item'
|
||
verbose_name = "字典表详情表"
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('sort',)
|
||
|
||
|
||
class CategoryDict(CoreModel):
|
||
label = models.CharField(max_length=100, blank=True, null=True, verbose_name="显示名称", help_text="显示名称")
|
||
value = models.CharField(max_length=100, blank=True, null=True, verbose_name="实际值", help_text="实际值")
|
||
code = models.CharField(max_length=100, unique=True, blank=True, null=True, verbose_name="编码", help_text="编码")
|
||
parent = models.ForeignKey(to='CategoryDict', on_delete=models.CASCADE, default=None, verbose_name="上级",
|
||
db_constraint=False, null=True, blank=True, help_text="上级")
|
||
|
||
class Meta:
|
||
db_table = 'system_category_dict'
|
||
verbose_name = "分类字典表"
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('sort',)
|
||
|
||
|
||
class OperationLog(CoreModel):
|
||
request_username = models.CharField(max_length=50, blank=True, null=True, verbose_name="请求用户",
|
||
help_text="请求用户")
|
||
request_modular = models.CharField(max_length=64, verbose_name="请求模块", null=True, blank=True,
|
||
help_text="请求模块")
|
||
request_path = models.CharField(max_length=400, verbose_name="请求地址", null=True, blank=True,
|
||
help_text="请求地址")
|
||
request_body = models.TextField(verbose_name="请求参数", null=True, blank=True, help_text="请求参数")
|
||
request_method = models.CharField(max_length=8, verbose_name="请求方式", null=True, blank=True,
|
||
help_text="请求方式")
|
||
request_msg = models.TextField(verbose_name="操作说明", null=True, blank=True, help_text="操作说明")
|
||
request_ip = models.CharField(max_length=32, verbose_name="请求ip地址", null=True, blank=True,
|
||
help_text="请求ip地址")
|
||
request_browser = models.CharField(max_length=64, verbose_name="请求浏览器", null=True, blank=True,
|
||
help_text="请求浏览器")
|
||
response_code = models.CharField(max_length=32, verbose_name="响应状态码", null=True, blank=True,
|
||
help_text="响应状态码")
|
||
request_os = models.CharField(max_length=64, verbose_name="操作系统", null=True, blank=True, help_text="操作系统")
|
||
json_result = models.TextField(verbose_name="返回信息", null=True, blank=True, help_text="返回信息")
|
||
status = models.BooleanField(default=False, verbose_name="响应状态", help_text="响应状态")
|
||
|
||
class Meta:
|
||
db_table = 'system_operation_log'
|
||
verbose_name = '操作日志'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('-create_datetime',)
|
||
|
||
|
||
def media_file_name(instance, filename):
|
||
h = instance.md5sum
|
||
basename, ext = os.path.splitext(filename)
|
||
return os.path.join('files', h[0:1], h[1:2], h + ext.lower())
|
||
|
||
|
||
class File(CoreModel):
|
||
name = models.CharField(max_length=255, null=True, blank=True, verbose_name="实际名称", help_text="实际名称")
|
||
save_name = models.CharField(max_length=255, null=True, blank=True, verbose_name="存储名称", help_text="存储名称")
|
||
url = models.FileField(upload_to=media_file_name)
|
||
size = models.BigIntegerField(null=True, blank=True, verbose_name="大小", help_text="大小")
|
||
md5sum = models.CharField(max_length=36, blank=True, verbose_name="文件md5", help_text="文件md5")
|
||
|
||
class Meta:
|
||
db_table = 'system_file'
|
||
verbose_name = '文件管理'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('-create_datetime',)
|
||
|
||
|
||
class Area(CoreModel):
|
||
name = models.CharField(max_length=100, verbose_name="名称", help_text="名称")
|
||
code = models.CharField(max_length=20, verbose_name="地区编码", help_text="地区编码", unique=True, db_index=True)
|
||
level = models.BigIntegerField(verbose_name="地区层级(1省份 2城市 3区县 4乡级)",
|
||
help_text="地区层级(1省份 2城市 3区县 4乡级)")
|
||
pinyin = models.CharField(max_length=255, verbose_name="拼音", help_text="拼音")
|
||
initials = models.CharField(max_length=20, verbose_name="首字母", help_text="首字母")
|
||
enable = models.BooleanField(default=True, verbose_name="是否启用", help_text="是否启用")
|
||
pcode = models.ForeignKey(to='self', verbose_name='父地区编码', to_field="code", on_delete=models.CASCADE,
|
||
db_constraint=False, null=True, blank=True, help_text="父地区编码")
|
||
|
||
class Meta:
|
||
db_table = "system_area"
|
||
verbose_name = '地区表'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('code',)
|
||
|
||
def __str__(self):
|
||
return f"{self.name}"
|
||
|
||
|
||
class ApiWhiteList(CoreModel):
|
||
url = models.CharField(max_length=200, help_text="url地址", verbose_name="url")
|
||
METHOD_CHOICES = (
|
||
(0, "GET"),
|
||
(1, "POST"),
|
||
(2, "PUT"),
|
||
(3, "DELETE"),
|
||
)
|
||
method = models.IntegerField(default=0, verbose_name="接口请求方法", null=True, blank=True,
|
||
help_text="接口请求方法")
|
||
enable_datasource = models.BooleanField(default=True, verbose_name="激活数据权限", help_text="激活数据权限",
|
||
blank=True)
|
||
|
||
class Meta:
|
||
db_table = "system_api_white_list"
|
||
verbose_name = '接口白名单'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('-create_datetime',)
|
||
|
||
|
||
class SystemConfig(CoreModel):
|
||
parent = models.ForeignKey(to='self', verbose_name='父级', on_delete=models.CASCADE,
|
||
db_constraint=False, null=True, blank=True, help_text="父级")
|
||
title = models.CharField(max_length=50, verbose_name="标题", help_text="标题")
|
||
key = models.CharField(max_length=20, verbose_name="键", help_text="键")
|
||
value = models.JSONField(max_length=100, verbose_name="值", help_text="值", null=True, blank=True)
|
||
status = models.BooleanField(default=False, verbose_name="启用状态", help_text="启用状态")
|
||
data_options = models.JSONField(verbose_name="数据options", help_text="数据options", null=True, blank=True)
|
||
FORM_ITEM_TYPE_LIST = (
|
||
(0, 'text'),
|
||
(1, 'textarea'),
|
||
(2, 'number'),
|
||
(3, 'select'),
|
||
(4, 'radio'),
|
||
(5, 'checkbox'),
|
||
(6, 'date'),
|
||
(7, 'datetime'),
|
||
(8, 'time'),
|
||
(9, 'imgs'),
|
||
(10, 'files'),
|
||
(11, 'array'),
|
||
(12, 'foreignkey'),
|
||
(13, 'manytomany'),
|
||
)
|
||
form_item_type = models.IntegerField(choices=FORM_ITEM_TYPE_LIST, verbose_name="表单类型", help_text="表单类型",
|
||
default=0,
|
||
blank=True)
|
||
rule = models.JSONField(null=True, blank=True, verbose_name="校验规则", help_text="校验规则")
|
||
placeholder = models.CharField(max_length=50, null=True, blank=True, verbose_name="提示信息", help_text="提示信息")
|
||
setting = models.JSONField(null=True, blank=True, verbose_name="配置", help_text="配置")
|
||
|
||
class Meta:
|
||
db_table = "system_config"
|
||
verbose_name = '系统配置表'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('sort',)
|
||
|
||
def __str__(self):
|
||
return f"{self.title}"
|
||
|
||
|
||
class LoginLog(CoreModel):
|
||
LOGIN_TYPE_CHOICES = (
|
||
(1, '普通登录'),
|
||
)
|
||
username = models.CharField(max_length=32, verbose_name="登录用户名", null=True, blank=True, help_text="登录用户名")
|
||
ip = models.CharField(max_length=32, verbose_name="登录ip", null=True, blank=True, help_text="登录ip")
|
||
agent = models.TextField(verbose_name="agent信息", null=True, blank=True, help_text="agent信息")
|
||
browser = models.CharField(max_length=200, verbose_name="浏览器名", null=True, blank=True, help_text="浏览器名")
|
||
os = models.CharField(max_length=200, verbose_name="操作系统", null=True, blank=True, help_text="操作系统")
|
||
continent = models.CharField(max_length=50, verbose_name="州", null=True, blank=True, help_text="州")
|
||
country = models.CharField(max_length=50, verbose_name="国家", null=True, blank=True, help_text="国家")
|
||
province = models.CharField(max_length=50, verbose_name="省份", null=True, blank=True, help_text="省份")
|
||
city = models.CharField(max_length=50, verbose_name="城市", null=True, blank=True, help_text="城市")
|
||
district = models.CharField(max_length=50, verbose_name="县区", null=True, blank=True, help_text="县区")
|
||
isp = models.CharField(max_length=50, verbose_name="运营商", null=True, blank=True, help_text="运营商")
|
||
area_code = models.CharField(max_length=50, verbose_name="区域代码", null=True, blank=True, help_text="区域代码")
|
||
country_english = models.CharField(max_length=50, verbose_name="英文全称", null=True, blank=True,
|
||
help_text="英文全称")
|
||
country_code = models.CharField(max_length=50, verbose_name="简称", null=True, blank=True, help_text="简称")
|
||
longitude = models.CharField(max_length=50, verbose_name="经度", null=True, blank=True, help_text="经度")
|
||
latitude = models.CharField(max_length=50, verbose_name="纬度", null=True, blank=True, help_text="纬度")
|
||
login_type = models.IntegerField(default=1, choices=LOGIN_TYPE_CHOICES, verbose_name="登录类型",
|
||
help_text="登录类型")
|
||
|
||
class Meta:
|
||
db_table = 'system_login_log'
|
||
verbose_name = '登录日志'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('-create_datetime',)
|
||
|
||
|
||
class GeneratorTemplate(CoreModel):
|
||
name = models.CharField(null=False, max_length=64, verbose_name="模板名称", help_text="模板名称")
|
||
code = models.CharField(max_length=32, verbose_name="模板编码", help_text="模板编码")
|
||
form_info = models.TextField(verbose_name="表单信息", help_text="表单信息")
|
||
table_info = models.TextField(verbose_name="表格信息", help_text="表格信息")
|
||
has_menu = models.BooleanField(default=False, verbose_name="是否已经生成菜单", help_text="是否已经生成菜单")
|
||
|
||
class Meta:
|
||
db_table = "system_generator_template"
|
||
verbose_name = '代码生成器模板'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('-create_datetime',)
|
||
|
||
|
||
|
||
#-------------------------------------------------追加----------------------------------------------------
|
||
|
||
|
||
|
||
class VDESData(models.Model):
|
||
"""本船VDES信息模型"""
|
||
mmsi = models.CharField(max_length=15, verbose_name="MMSI号码", unique=True, help_text="船舶唯一识别码") #唯一
|
||
latitude = models.FloatField(verbose_name="纬度", help_text="船舶当前位置纬度")
|
||
longitude = models.FloatField(verbose_name="经度", help_text="船舶当前位置经度")
|
||
speed = models.FloatField(verbose_name="航速", help_text="航速(节)", null=True, blank=True)
|
||
course = models.FloatField(verbose_name="航向", help_text="航向(度)", null=True, blank=True)
|
||
heading = models.FloatField(verbose_name="船首向", help_text="船首向(度)", null=True, blank=True)
|
||
nav_status = models.IntegerField(verbose_name="航行状态", null=True, blank=True, help_text="0=机动船在航,1=锚泊等")
|
||
timestamp = models.DateTimeField(verbose_name="时间戳", help_text="AIS数据更新时间")
|
||
ship_name = models.CharField(max_length=100, verbose_name="船名", null=True, blank=True)
|
||
ship_type = models.IntegerField(verbose_name="船舶类型", null=True, blank=True, help_text="1-99=各种船舶类型")
|
||
draught = models.FloatField(verbose_name="吃水", null=True, blank=True, help_text="单位:米")
|
||
destination = models.CharField(max_length=100, verbose_name="目的地", null=True, blank=True)
|
||
eta = models.DateTimeField(verbose_name="预计到达时间", null=True, blank=True)
|
||
|
||
class Meta:
|
||
db_table = "system_vdes_data"
|
||
verbose_name = 'VDES数据'
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('-timestamp',) # 默认按时间倒序排列
|
||
|
||
|
||
class ShipLatestStatus(models.Model):
|
||
mmsi = models.CharField(max_length=15, verbose_name="MMSI号码", unique=True, help_text="船舶唯一识别码") #唯一
|
||
latitude = models.FloatField(verbose_name="纬度", help_text="船舶当前位置纬度")
|
||
longitude = models.FloatField(verbose_name="经度", help_text="船舶当前位置经度")
|
||
speed = models.FloatField(verbose_name="航速", help_text="航速(节)", null=True, blank=True)
|
||
course = models.FloatField(verbose_name="航向", help_text="航向(度)", null=True, blank=True)
|
||
heading = models.FloatField(verbose_name="船首向", help_text="船首向(度)", null=True, blank=True)
|
||
nav_status = models.IntegerField(verbose_name="航行状态", null=True, blank=True, help_text="0=机动船在航,1=锚泊等")
|
||
timestamp = models.DateTimeField(verbose_name="时间戳", help_text="AIS数据更新时间")
|
||
ship_name = models.CharField(max_length=100, verbose_name="船名", null=True, blank=True)
|
||
ship_type = models.IntegerField(verbose_name="船舶类型", null=True, blank=True, help_text="1-99=各种船舶类型")
|
||
draught = models.FloatField(verbose_name="吃水", null=True, blank=True, help_text="单位:米")
|
||
destination = models.CharField(max_length=100, verbose_name="目的地", null=True, blank=True)
|
||
eta = models.DateTimeField(verbose_name="预计到达时间", null=True, blank=True)
|
||
# 添加虚拟字段：不写入数据库，但可以在 raw 查询中赋值
|
||
distance_km = None
|
||
class Meta:
|
||
db_table = "ship_latest_status"
|
||
ordering = ('-timestamp',) # 默认按时间倒序排列
|
||
|
||
|
||
class GpsStatus(models.Model):
|
||
utc_time = models.DateTimeField(verbose_name="UTC时间")
|
||
longitude = models.FloatField(verbose_name="经度")
|
||
latitude = models.FloatField(verbose_name="纬度")
|
||
altitude = models.FloatField(verbose_name="海拔高度")
|
||
used_satellites = models.IntegerField(verbose_name="定位卫星数")
|
||
gps_satellites = models.IntegerField(verbose_name="GPS卫星数")
|
||
beidou_satellites = models.IntegerField(verbose_name="北斗卫星数")
|
||
gps_status = models.IntegerField(verbose_name="GPS状态")
|
||
fix_mode = models.IntegerField(verbose_name="定位模式")
|
||
hdop = models.FloatField(verbose_name="HDOP精度")
|
||
speed = models.FloatField(verbose_name="运动速度")
|
||
direction = models.FloatField(verbose_name="运动方向")
|
||
|
||
class Meta:
|
||
db_table = "gps_status"
|
||
ordering = ('-utc_time',)
|
||
|
||
|
||
class Content(models.Model):
|
||
Id = models.AutoField(primary_key=True, verbose_name="自增Id", help_text="自增Id")
|
||
SendId = models.BigIntegerField(verbose_name="发送人Id", null=True, help_text="发送人Id")
|
||
ReciverId = models.BigIntegerField(verbose_name="接收人Id", help_text="接收人Id")
|
||
Content = models.TextField(verbose_name="聊天内容", help_text="聊天内容")
|
||
Type = models.IntegerField(verbose_name="内容类型", help_text="内容类型：0html文本，1图片，2视频，3文件")
|
||
State = models.IntegerField(verbose_name="是否发送成功", help_text="是否发送成功：0否，1是")
|
||
NoCode = models.CharField(max_length=255, verbose_name="时间戳", help_text="时间戳")
|
||
CreateDateUtc = models.CharField(max_length=255, verbose_name="创建时间", help_text="创建时间")
|
||
Title = models.CharField(max_length=255, null=True, blank=True, verbose_name="拓展功能字段", help_text="拓展功能字段")
|
||
Description = models.CharField(max_length=255, null=True, blank=True, verbose_name="拓展功能字段", help_text="拓展功能字段")
|
||
Label = models.CharField(max_length=255, null=True, blank=True, verbose_name="拓展功能字段", help_text="拓展功能字段")
|
||
Thumbnail = models.CharField(max_length=255, null=True, blank=True, verbose_name="拓展功能字段", help_text="拓展功能字段")
|
||
ReadFlag = models.BooleanField(verbose_name="是否阅读", help_text="是否阅读：0否，1是")
|
||
Avatar = models.CharField(max_length=500, null=True, blank=True, verbose_name="头像", help_text="头像")
|
||
SoundStatus = models.IntegerField(default=0, verbose_name="音频播放状态", help_text="音频播放状态：0未播放，1播放中，2已播放")
|
||
|
||
class Meta:
|
||
db_table = "content"
|
||
verbose_name = "内容表"
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('-CreateDateUtc',)
|
||
|
||
|
||
class Contacts(models.Model):
|
||
Id = models.AutoField(primary_key=True, verbose_name="Id", help_text="Id，自增")
|
||
Name = models.CharField(max_length=255, null=True, blank=True, verbose_name="备注", help_text="备注")
|
||
MMSI = models.CharField(max_length=255, verbose_name="MMSI号码", help_text="MMSI号码")
|
||
Mobile = models.CharField(max_length=255, null=True, blank=True, verbose_name="手机号", help_text="手机号")
|
||
OnlineState = models.BooleanField(null=True, blank=True, verbose_name="在线状态", help_text="在线状态")
|
||
Region = models.CharField(max_length=255, null=True, blank=True, verbose_name="地区", help_text="地区")
|
||
Avatar = models.CharField(max_length=500, null=True, blank=True, verbose_name="头像", help_text="头像")
|
||
HistorySessionList = models.TextField(null=True, blank=True, verbose_name="历史会话列表", help_text="历史会话列表")
|
||
OutTradeNo = models.CharField(max_length=255, null=True, blank=True, verbose_name="socket.id", help_text="socket.id")
|
||
NoCode = models.CharField(max_length=255, null=True, blank=True, verbose_name="时间戳", help_text="时间戳")
|
||
|
||
class Meta:
|
||
db_table = "contacts"
|
||
verbose_name = "通讯录"
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('-Id',)
|
||
unique_together = ('Id', 'MMSI')
|
||
|
||
|
||
class HistorySession(models.Model):
|
||
Id = models.AutoField(primary_key=True, verbose_name="Id", help_text="Id，自增")
|
||
FormId = models.BigIntegerField(verbose_name="来自用户Id", help_text="来自用户Id")
|
||
Name = models.CharField(max_length=255, null=True, blank=True, verbose_name="备注", help_text="备注")
|
||
MMSI = models.CharField(max_length=255, verbose_name="MMSI号码", help_text="MMSI号码")
|
||
Mobile = models.CharField(max_length=255, null=True, blank=True, verbose_name="手机号", help_text="手机号")
|
||
Region = models.CharField(max_length=255, null=True, blank=True, verbose_name="地区", help_text="地区")
|
||
Avatar = models.CharField(max_length=500, null=True, blank=True, verbose_name="头像", help_text="头像")
|
||
ById = models.BigIntegerField(verbose_name="归属用户Id", help_text="归属用户Id", default=1)
|
||
|
||
class Meta:
|
||
db_table = "history_session"
|
||
verbose_name = "历史会话表"
|
||
verbose_name_plural = verbose_name
|
||
ordering = ('-Id',)
|
||
unique_together = ('Id', 'MMSI')
|
||
|
||
#记录是否获取到vdes消息
|
||
class MessageFlag(models.Model):
|
||
has_new_message = models.BooleanField(default=False) # 是否有新消息
|
||
|
||
class Meta:
|
||
db_table = "message_flag" |