models.py 125 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248
  1. from itertools import chain
  2. from django.contrib.auth.models import BaseUserManager, AbstractBaseUser
  3. from django.db import models
  4. # from django.utils import six
  5. # from django.utils.encoding import python_2_unicode_compatible
  6. from six import python_2_unicode_compatible
  7. from imagekit.models import ProcessedImageField
  8. from imagekit.processors import ResizeToFill
  9. from AnsjerPush.config import SERVER_DOMAIN
  10. from django.utils import timezone
  11. class PermissionsManager(models.Manager):
  12. use_in_migrations = True
  13. def get_by_natural_key(self, permName):
  14. return self.get(
  15. permName=permName
  16. )
  17. class RoleManager(models.Manager):
  18. """
  19. The manager for the auth's Role model..
  20. """
  21. use_in_migrations = True
  22. def get_by_natural_key(self, roleName):
  23. return self.get(roleName=roleName)
  24. class UserManager(BaseUserManager):
  25. def create_user(self, username, password, userID, is_active,
  26. user_isValid, **extra_fields):
  27. user = self.model(
  28. username=username,
  29. userID=userID,
  30. is_active=is_active,
  31. user_isValid=user_isValid,
  32. **extra_fields
  33. )
  34. user.set_password(password)
  35. user.save(using=self._db)
  36. role = Role.objects.get(rid=1)
  37. user.role.add(role)
  38. return user
  39. def create_superuser(self, username, password, userID, is_active,
  40. user_isValid, **extra_fields):
  41. # extra_fields.setdefault('is_superuser', is_superuser)
  42. is_superuser = extra_fields.get('is_superuser', None)
  43. if is_superuser != 100 and is_superuser != 1:
  44. raise ValueError('Superuser must have is_superuser=1 or 100.')
  45. return self.create_user(username, password, userID, is_active,
  46. user_isValid, **extra_fields)
  47. @python_2_unicode_compatible
  48. class Permissions(models.Model):
  49. permName = models.CharField(blank=True, null=True, max_length=32, unique=True, verbose_name=u'权限名称')
  50. description = models.CharField(blank=True, null=True, max_length=128, verbose_name=u'描述信息', default='')
  51. objects = PermissionsManager()
  52. def __str__(self):
  53. return "%s" % (
  54. six.text_type(self.description))
  55. class Meta:
  56. ordering = ['permName']
  57. db_table = 'permissions'
  58. verbose_name = u'role permission'
  59. verbose_name_plural = verbose_name
  60. unique_together = (('permName'),)
  61. def natural_key(self):
  62. return (self.permName)
  63. class MenuModel(models.Model):
  64. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  65. parentId = models.IntegerField(default=0, verbose_name='父节点ID')
  66. name = models.CharField(max_length=50, null=True, default='', verbose_name='名称') #首字母大写,一定要与vue文件的name对应起来,用于noKeepAlive缓存控制(该项特别重要)
  67. path = models.CharField(max_length=100, null=True, default='',verbose_name='路径')
  68. component = models.CharField(max_length=100, null=True, default='', verbose_name='vue文件路径') #所谓的vue 组件
  69. hidden = models.BooleanField(blank=True, default=False, verbose_name=u'是否隐藏')
  70. alwaysShow = models.BooleanField(blank=True, default=False, verbose_name=u'始终显示当前节点')
  71. levelHidden = models.BooleanField(blank=True, default=False, verbose_name=u'是否隐藏一级路由')
  72. title = models.CharField(max_length=50, default='',verbose_name='标题')
  73. icon = models.CharField(max_length=50, default='',verbose_name='图标名')
  74. isCustomSvg = models.BooleanField(blank=True, default=False, verbose_name=u'是否是自定义svg图标')
  75. noKeepAlive = models.BooleanField(blank=True, default=False, verbose_name=u'当前路由是否不缓存')
  76. noClosable = models.BooleanField(blank=True, default=False, verbose_name=u'当前路由是否可关闭多标签页')
  77. badge = models.CharField(max_length=10, default='', verbose_name='badge小标签(只支持子级)')
  78. tabHidden = models.BooleanField(blank=True, default=False, verbose_name=u'当前路由是否不显示多标签页')
  79. activeMenu = models.CharField(max_length=50, default='', verbose_name='高亮指定菜单')
  80. dot = models.BooleanField(blank=True, default=False, verbose_name=u'小圆点')
  81. dynamicNewTab = models.BooleanField(blank=True, default=False, verbose_name=u'动态传参路由是否新开标签页')
  82. redirect = models.CharField(max_length=50, default='', verbose_name='重定向')
  83. menu_code = models.CharField(max_length=100, default='', verbose_name='菜单编码')
  84. menutype = models.SmallIntegerField(default=1, verbose_name=u'类型') #类型: 1-菜单 2-按钮
  85. sort = models.IntegerField(default=0, verbose_name='排序')
  86. class Meta:
  87. db_table = 'menu'
  88. verbose_name = u'菜单表'
  89. verbose_name_plural = verbose_name
  90. class Role(models.Model):
  91. rid = models.SmallIntegerField(primary_key=True, unique=True, verbose_name=u'用户角色组ID')
  92. roleName = models.CharField(max_length=32, unique=True,
  93. default='User', verbose_name=u'角色名称')
  94. permission = models.ManyToManyField(to='Permissions', blank=True, verbose_name=u'权限', db_table='role_permissions')
  95. menu = models.ManyToManyField(to='MenuModel', blank=True, verbose_name=u'后台菜单权限', db_table='role_menu')
  96. Description = models.TextField(blank=True, default='', verbose_name=u'描述信息')
  97. objects = RoleManager()
  98. class Meta:
  99. ordering = ['roleName']
  100. db_table = 'role'
  101. verbose_name = u'用户角色'
  102. verbose_name_plural = verbose_name
  103. def __str__(self):
  104. return self.roleName
  105. def natural_key(self):
  106. return (self.roleName,)
  107. def get_all_permission(self):
  108. perms = self.permission.all()
  109. permslist = []
  110. if self.rid == 100:
  111. perms = Permissions.objects.all()
  112. for perm in perms:
  113. permslist.append(perm.permName)
  114. return permslist
  115. else:
  116. permlist_tmp = []
  117. for perm in perms:
  118. permlist_tmp.append(perm.permName)
  119. permSet = set(permlist_tmp)
  120. permslist = list(permSet)
  121. permslist.sort()
  122. return permslist
  123. class Device_User(AbstractBaseUser):
  124. userID = models.CharField(blank=True, max_length=32, primary_key=True,
  125. verbose_name=u'用户ID', unique=True)
  126. role = models.ManyToManyField(to='Role', blank=True, verbose_name=u'用户角色', db_table='user_role')
  127. username = models.CharField(max_length=64, db_index=True, verbose_name=u'用户名', default='', blank=True)
  128. password = models.CharField(max_length=128, verbose_name=u'密码')
  129. userEmail = models.EmailField(max_length=64, db_index=True, verbose_name=u'邮箱', default='', blank=True)
  130. # 实际的路径就是 MEDIA_ROOT/Image/filename,所以可用upload_to来指定文件存放的前缀路径
  131. userIconPath = ProcessedImageField(blank=True, upload_to='User/Images/', default='static/User/default.png',
  132. verbose_name=u'头像',
  133. # 图片将处理成85x85的尺寸
  134. processors=[ResizeToFill(85, 85)], )
  135. userIconUrl = models.URLField(blank=True, max_length=128, default=SERVER_DOMAIN
  136. + 'account/getAvatar/User/defaultUser.png')
  137. NickName = models.CharField(blank=True, max_length=64, default='', verbose_name=u'用户昵称')
  138. is_superuser = models.IntegerField(blank=True, default=0, verbose_name=u'用户类型')
  139. is_active = models.BooleanField(blank=True, default=False, verbose_name=u'用户活动状态')
  140. data_joined = models.DateTimeField(blank=True, verbose_name=u'加入时间', auto_now_add=True)
  141. last_login = models.DateTimeField(blank=True, verbose_name='u最后登录时间', auto_now=True)
  142. user_isValid = models.BooleanField(blank=True, default=False, verbose_name=u'用户有效性', help_text=u'是否是认证通过的用户')
  143. online = models.BooleanField(blank=True, default=False, verbose_name=u'用户登录状态')
  144. machine_code = models.CharField(blank=True, max_length=128, default='', verbose_name=u'机械码')
  145. language = models.CharField(blank=True, max_length=16, default='en', verbose_name=u'语言地区')
  146. # 手机注册增加字段
  147. phone = models.CharField(max_length=16, db_index=True, verbose_name=u'手机号', default='', blank=True)
  148. fingerprint_enable = models.SmallIntegerField(default=0, verbose_name=u'是否开启了指纹登录') # 0:未开启,1:已开启
  149. fingerprint_key = models.CharField(max_length=128, default='', verbose_name=u'客户端用于解码的密钥等信息')
  150. is_local = models.BooleanField(blank=True, default=False, verbose_name=u'是否是本地登录用户') # False:账号登录,1:本地登录
  151. subscribe_email = models.SmallIntegerField(default=0, verbose_name=u'是否订阅营销邮件') # 0:未订阅,1:订阅,2:不订阅
  152. region_country = models.IntegerField(blank=True, default=0, verbose_name='地区表唯一标识')
  153. objects = UserManager()
  154. USERNAME_FIELD = 'userID' # 必须有一个唯一标识
  155. REQUIRED_FIELDS = ['is_superuser'] # 创建superuser时的必须字段
  156. class Meta:
  157. ordering = ('-data_joined',)
  158. verbose_name = u'用户信息'
  159. db_table = 'device_user'
  160. get_latest_by = 'last_login'
  161. def __str__(self):
  162. return self.username
  163. def get_role_id(self):
  164. rids = []
  165. roles = self.role.all()
  166. for role in roles:
  167. rids.append(role.rid)
  168. return rids
  169. def get_all_permission(self):
  170. roles = self.role.all()
  171. perms = self.permission.all()
  172. permslist = []
  173. for role in roles:
  174. if role.rid == 100:
  175. perms = Permissions.objects.all()
  176. for perm in perms:
  177. permslist.append(perm.permName)
  178. return permslist
  179. for perm in perms:
  180. permslist.append(perm.permName)
  181. permSet = set(permslist)
  182. for role in roles:
  183. permlist_tmp = []
  184. for perm in role.permission.all():
  185. permlist_tmp.append(perm.permName)
  186. permSet_tmp = set(permlist_tmp)
  187. permSet = permSet.union(permSet_tmp)
  188. permslist = list(permSet)
  189. permslist.sort()
  190. return permslist
  191. @property
  192. def is_staff(self):
  193. return self.is_superuser
  194. # 设备表是建项目开发者设计的,自己看着办
  195. # 谢谢提醒!我选择凉拌。
  196. # 我选择狗带
  197. class Device_Info(models.Model):
  198. id = models.CharField(blank=True, max_length=32, primary_key=True)
  199. userID = models.ForeignKey(Device_User, blank=True, to_field='userID', on_delete=models.CASCADE)
  200. NickName = models.CharField(blank=True, max_length=32, verbose_name=u'设备名称')
  201. UID = models.CharField(blank=True, max_length=32, verbose_name=u'设备UID', default='')
  202. SID = models.CharField(blank=True, max_length=32, verbose_name=u'服务器ID', default='')
  203. View_Account = models.CharField(blank=True, max_length=32, verbose_name=u'设备用户名称', default='')
  204. View_Password = models.CharField(blank=True, max_length=32, verbose_name=u'设备密码', default='')
  205. AudioFormat = models.IntegerField(blank=True, default=1, verbose_name=u'初始化影像')
  206. EventNotification = models.IntegerField(blank=True, verbose_name=u'报警类型', default=0)
  207. ChannelIndex = models.IntegerField(blank=True, verbose_name=u'通道号', default=0)
  208. Online = models.BooleanField(blank=True, default=False, verbose_name=u'设备是否在线')
  209. mMonitorIndex = models.IntegerField(blank=True, default=-1)
  210. Type = models.IntegerField(blank=True, verbose_name='设备类型')
  211. DebugMode = models.IntegerField(blank=True, verbose_name=u'调试模式', default=0)
  212. NotificationMode = models.IntegerField(blank=True, verbose_name=u'是否报警', default=0)
  213. qvgaLevel = models.BooleanField(blank=True, verbose_name=u'SD与HD画面', default=0,
  214. help_text=u'0代表:SD、1代表:HD')
  215. isShare = models.BooleanField(blank=True, verbose_name=u'共享设备',
  216. help_text=u'是否为共享获取的设备', default=False)
  217. primaryUserID = models.CharField(blank=True, verbose_name='主用户id', max_length=32, default='')
  218. primaryMaster = models.CharField(max_length=64, verbose_name=u'主用户名', default='')
  219. vodPrimaryUserID = models.CharField(blank=True, verbose_name='云存主用户id', max_length=32, default='')
  220. vodPrimaryMaster = models.CharField(max_length=64, verbose_name=u'云存主用户名', default='')
  221. data_joined = models.DateTimeField(blank=True, verbose_name=u'设备添加时间', auto_now_add=True)
  222. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True, null=True)
  223. ip = models.CharField(blank=True, max_length=20, default='', verbose_name=u'设备区域ip')
  224. area = models.CharField(blank=True, max_length=100, default='', verbose_name=u'设备区域area')
  225. # ios要求新增字段
  226. version = models.CharField(blank=True, max_length=20, default='', verbose_name=u'版本号')
  227. iSNotification = models.BooleanField(blank=True, verbose_name=u'报警通知 0:关闭,1:开启)', default=False)
  228. isVod = models.SmallIntegerField(blank=True, default=0, verbose_name='是否支持云存') # 是否支持云存设备
  229. isExist = models.SmallIntegerField(blank=True, default=1, verbose_name='是否被删除') # 是否被删除了(需主用户交互) 1存在,0不存在,2设备被重置
  230. isCameraOpenCloud = models.SmallIntegerField(blank=True, default=1, verbose_name='是否开启云存') # 0:不开启 1:开启
  231. serial_number = models.CharField(blank=True, max_length=9, default='', verbose_name='关联序列号')
  232. ###
  233. REQUIRED_FIELDS = []
  234. def __str__(self):
  235. return self.NickName
  236. def model_to_dict(self, fields=None, exclude=None):
  237. opts = self._meta
  238. data = {}
  239. for f in chain(opts.concrete_fields, opts.private_fields, opts.many_to_many):
  240. if not getattr(f, 'editable', False):
  241. continue
  242. if fields and f.name not in fields:
  243. continue
  244. if exclude and f.name in exclude:
  245. continue
  246. data[f.name] = f.value_from_object(self)
  247. return data
  248. class Meta:
  249. db_table = 'device_info'
  250. ordering = ('-data_joined',)
  251. verbose_name = u'用户设备信息表'
  252. verbose_name_plural = verbose_name
  253. class Access_Log(models.Model):
  254. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  255. user = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'用户')
  256. operation = models.CharField(max_length=100, db_index=True, default='', blank=True, verbose_name=u'操作')
  257. ip = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'访问ip地址')
  258. url = models.CharField(max_length=150, default='', blank=True, verbose_name=u'访问路径')
  259. status = models.IntegerField(default=0, blank=True, verbose_name=u'状态')
  260. time = models.DateTimeField(null=True, blank=True, db_index=True, verbose_name=u'访问时间')
  261. content = models.TextField(blank=True, default='', verbose_name=u'参数内容')
  262. class Meta:
  263. db_table = 'access_log'
  264. verbose_name = u'访问日志表'
  265. verbose_name_plural = verbose_name
  266. class Equipment_Info(models.Model):
  267. id = models.BigAutoField(primary_key=True, verbose_name=u'自增标记ID')
  268. devUid = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'设备ID')
  269. devNickName = models.CharField(blank=True, max_length=32, default='', verbose_name=u'设备昵称')
  270. Channel = models.IntegerField(default=1, blank=True, verbose_name=u'设备通道')
  271. eventType = models.IntegerField(default=0, blank=True, verbose_name=u'事件类型')
  272. status = models.BooleanField(blank=True, default=False, verbose_name=u'事件状态')
  273. alarm = models.CharField(blank=True, max_length=256, verbose_name=u'报警信息')
  274. eventTime = models.CharField(blank=True, db_index=True, default='', max_length=16, verbose_name=u'设备报警时间')
  275. receiveTime = models.CharField(blank=True, default='', max_length=16, verbose_name=u'接收到报警时间')
  276. userID_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户ID')
  277. is_st = models.SmallIntegerField(default=0, verbose_name='是否截图') # 0 否,1 是图,2,视频,3,多图
  278. storage_location = models.SmallIntegerField(default=1, verbose_name='数据信息存储位置。1:阿里云oss,2:aws')
  279. borderCoords = models.TextField(default='', blank=True, verbose_name=u'ai类型图片边框位置信息')
  280. # message_id = models.CharField(blank=True, max_length=32, default='', verbose_name='第三方推送服务器返回的id')
  281. # push_type = models.SmallIntegerField(blank=True, default=0, verbose_name='第三方推送服务器标志。0:APNS推送,1:谷歌推送,2:极光推送')
  282. # push_server_status = models.IntegerField(blank=True, default=200, verbose_name='是否成功推送到第三方服务器。200:成功,other:失败')
  283. # push_device_status = models.SmallIntegerField(blank=True, default=-1, verbose_name='是否成功推送到目标设备。0:失败,1:成功')
  284. addTime = models.IntegerField(verbose_name='添加时间', db_index=True, default=0)
  285. def __str__(self):
  286. return self.id
  287. class Meta:
  288. db_table = 'equipment_info'
  289. verbose_name = u'设备信息推送表'
  290. verbose_name_plural = verbose_name
  291. ordering = ('-id',)
  292. app_label = "db2"
  293. class EquipmentInfoMonday(models.Model):
  294. id = models.BigAutoField(primary_key=True, verbose_name=u'自增标记ID')
  295. device_user_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户id')
  296. device_uid = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'设备uid')
  297. device_nick_name = models.CharField(blank=True, max_length=32, default='', verbose_name=u'设备昵称')
  298. channel = models.IntegerField(default=1, blank=True, verbose_name=u'设备通道')
  299. event_type = models.IntegerField(default=0, blank=True,
  300. verbose_name=u'事件类型(0:代表空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物),51:移动侦测,'
  301. u'52:传感器报警,53:影像遗失,54:PIR,55:门磁报警, 56:外部发报, 57:人型报警,'
  302. u'702:摄像头休眠,703:摄像头唤醒,'
  303. u'704:电量过低)')
  304. status = models.BooleanField(blank=True, default=False, verbose_name=u'事件状态(0,1)')
  305. alarm = models.CharField(blank=True, max_length=256, verbose_name=u'报警信息')
  306. event_time = models.CharField(blank=True, db_index=True, default='', max_length=16, verbose_name=u'设备报警时间')
  307. receive_time = models.CharField(blank=True, default='', max_length=16, verbose_name=u'接收到报警时间')
  308. is_st = models.SmallIntegerField(default=0, verbose_name='是否截图(0:否,1:图片,2:视频)') # 0 否,1 是图,2,视频
  309. storage_location = models.SmallIntegerField(default=1, verbose_name='数据信息存储位置。1:阿里云oss,2:aws')
  310. border_coords = models.TextField(default='', blank=True, verbose_name=u'ai类型图片边框位置信息')
  311. add_time = models.IntegerField(verbose_name='添加时间', db_index=True, default=0)
  312. def __str__(self):
  313. return self.id
  314. class Meta:
  315. db_table = 'equipment_info_monday'
  316. verbose_name = u'星期一设备信息推送表'
  317. verbose_name_plural = verbose_name
  318. ordering = ('-id',)
  319. app_label = "db2"
  320. class EquipmentInfoTuesday(models.Model):
  321. id = models.BigAutoField(primary_key=True, verbose_name=u'自增标记ID')
  322. device_user_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户id')
  323. device_uid = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'设备uid')
  324. device_nick_name = models.CharField(blank=True, max_length=32, default='', verbose_name=u'设备昵称')
  325. channel = models.IntegerField(default=1, blank=True, verbose_name=u'设备通道')
  326. event_type = models.IntegerField(default=0, blank=True,
  327. verbose_name=u'事件类型(0:代表空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物),51:移动侦测,'
  328. u'52:传感器报警,53:影像遗失,54:PIR,55:门磁报警, 56:外部发报, 57:人型报警,'
  329. u'702:摄像头休眠,703:摄像头唤醒,'
  330. u'704:电量过低)')
  331. status = models.BooleanField(blank=True, default=False, verbose_name=u'事件状态(0,1)')
  332. alarm = models.CharField(blank=True, max_length=256, verbose_name=u'报警信息')
  333. event_time = models.CharField(blank=True, db_index=True, default='', max_length=16, verbose_name=u'设备报警时间')
  334. receive_time = models.CharField(blank=True, default='', max_length=16, verbose_name=u'接收到报警时间')
  335. is_st = models.SmallIntegerField(default=0, verbose_name='是否截图(0:否,1:图片,2:视频)') # 0 否,1 是图,2,视频
  336. storage_location = models.SmallIntegerField(default=1, verbose_name='数据信息存储位置。1:阿里云oss,2:aws')
  337. border_coords = models.TextField(default='', blank=True, verbose_name=u'ai类型图片边框位置信息')
  338. add_time = models.IntegerField(verbose_name='添加时间', db_index=True, default=0)
  339. def __str__(self):
  340. return self.id
  341. class Meta:
  342. db_table = 'equipment_info_tuesday'
  343. verbose_name = u'星期二设备信息推送表'
  344. verbose_name_plural = verbose_name
  345. ordering = ('-id',)
  346. app_label = "db2"
  347. class EquipmentInfoWednesday(models.Model):
  348. id = models.BigAutoField(primary_key=True, verbose_name=u'自增标记ID')
  349. device_user_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户id')
  350. device_uid = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'设备uid')
  351. device_nick_name = models.CharField(blank=True, max_length=32, default='', verbose_name=u'设备昵称')
  352. channel = models.IntegerField(default=1, blank=True, verbose_name=u'设备通道')
  353. event_type = models.IntegerField(default=0, blank=True,
  354. verbose_name=u'事件类型(0:代表空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物),51:移动侦测,'
  355. u'52:传感器报警,53:影像遗失,54:PIR,55:门磁报警, 56:外部发报, 57:人型报警,'
  356. u'702:摄像头休眠,703:摄像头唤醒,'
  357. u'704:电量过低)')
  358. status = models.BooleanField(blank=True, default=False, verbose_name=u'事件状态(0,1)')
  359. alarm = models.CharField(blank=True, max_length=256, verbose_name=u'报警信息')
  360. event_time = models.CharField(blank=True, db_index=True, default='', max_length=16, verbose_name=u'设备报警时间')
  361. receive_time = models.CharField(blank=True, default='', max_length=16, verbose_name=u'接收到报警时间')
  362. is_st = models.SmallIntegerField(default=0, verbose_name='是否截图(0:否,1:图片,2:视频)') # 0 否,1 是图,2,视频
  363. storage_location = models.SmallIntegerField(default=1, verbose_name='数据信息存储位置。1:阿里云oss,2:aws')
  364. border_coords = models.TextField(default='', blank=True, verbose_name=u'ai类型图片边框位置信息')
  365. add_time = models.IntegerField(verbose_name='添加时间', db_index=True, default=0)
  366. def __str__(self):
  367. return self.id
  368. class Meta:
  369. db_table = 'equipment_info_wednesday'
  370. verbose_name = u'星期三设备信息推送表'
  371. verbose_name_plural = verbose_name
  372. ordering = ('-id',)
  373. app_label = "db2"
  374. class EquipmentInfoThursday(models.Model):
  375. id = models.BigAutoField(primary_key=True, verbose_name=u'自增标记ID')
  376. device_user_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户id')
  377. device_uid = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'设备uid')
  378. device_nick_name = models.CharField(blank=True, max_length=32, default='', verbose_name=u'设备昵称')
  379. channel = models.IntegerField(default=1, blank=True, verbose_name=u'设备通道')
  380. event_type = models.IntegerField(default=0, blank=True,
  381. verbose_name=u'事件类型(0:代表空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物),51:移动侦测,'
  382. u'52:传感器报警,53:影像遗失,54:PIR,55:门磁报警, 56:外部发报, 57:人型报警,'
  383. u'702:摄像头休眠,703:摄像头唤醒,'
  384. u'704:电量过低)')
  385. status = models.BooleanField(blank=True, default=False, verbose_name=u'事件状态(0,1)')
  386. alarm = models.CharField(blank=True, max_length=256, verbose_name=u'报警信息')
  387. event_time = models.CharField(blank=True, db_index=True, default='', max_length=16, verbose_name=u'设备报警时间')
  388. receive_time = models.CharField(blank=True, default='', max_length=16, verbose_name=u'接收到报警时间')
  389. is_st = models.SmallIntegerField(default=0, verbose_name='是否截图(0:否,1:图片,2:视频)') # 0 否,1 是图,2,视频
  390. storage_location = models.SmallIntegerField(default=1, verbose_name='数据信息存储位置。1:阿里云oss,2:aws')
  391. border_coords = models.TextField(default='', blank=True, verbose_name=u'ai类型图片边框位置信息')
  392. add_time = models.IntegerField(verbose_name='添加时间', db_index=True, default=0)
  393. def __str__(self):
  394. return self.id
  395. class Meta:
  396. db_table = 'equipment_info_thursday'
  397. verbose_name = u'星期四设备信息推送表'
  398. verbose_name_plural = verbose_name
  399. ordering = ('-id',)
  400. app_label = "db2"
  401. class EquipmentInfoFriday(models.Model):
  402. id = models.BigAutoField(primary_key=True, verbose_name=u'自增标记ID')
  403. device_user_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户id')
  404. device_uid = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'设备uid')
  405. device_nick_name = models.CharField(blank=True, max_length=32, default='', verbose_name=u'设备昵称')
  406. channel = models.IntegerField(default=1, blank=True, verbose_name=u'设备通道')
  407. event_type = models.IntegerField(default=0, blank=True,
  408. verbose_name=u'事件类型(0:代表空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物),51:移动侦测,'
  409. u'52:传感器报警,53:影像遗失,54:PIR,55:门磁报警, 56:外部发报, 57:人型报警,'
  410. u'702:摄像头休眠,703:摄像头唤醒,'
  411. u'704:电量过低)')
  412. status = models.BooleanField(blank=True, default=False, verbose_name=u'事件状态(0,1)')
  413. alarm = models.CharField(blank=True, max_length=256, verbose_name=u'报警信息')
  414. event_time = models.CharField(blank=True, db_index=True, default='', max_length=16, verbose_name=u'设备报警时间')
  415. receive_time = models.CharField(blank=True, default='', max_length=16, verbose_name=u'接收到报警时间')
  416. is_st = models.SmallIntegerField(default=0, verbose_name='是否截图(0:否,1:图片,2:视频)') # 0 否,1 是图,2,视频
  417. storage_location = models.SmallIntegerField(default=1, verbose_name='数据信息存储位置。1:阿里云oss,2:aws')
  418. border_coords = models.TextField(default='', blank=True, verbose_name=u'ai类型图片边框位置信息')
  419. add_time = models.IntegerField(verbose_name='添加时间', db_index=True, default=0)
  420. def __str__(self):
  421. return self.id
  422. class Meta:
  423. db_table = 'equipment_info_friday'
  424. verbose_name = u'星期五设备信息推送表'
  425. verbose_name_plural = verbose_name
  426. ordering = ('-id',)
  427. app_label = "db2"
  428. class EquipmentInfoSaturday(models.Model):
  429. id = models.BigAutoField(primary_key=True, verbose_name=u'自增标记ID')
  430. device_user_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户id')
  431. device_uid = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'设备uid')
  432. device_nick_name = models.CharField(blank=True, max_length=32, default='', verbose_name=u'设备昵称')
  433. channel = models.IntegerField(default=1, blank=True, verbose_name=u'设备通道')
  434. event_type = models.IntegerField(default=0, blank=True,
  435. verbose_name=u'事件类型(0:代表空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物),51:移动侦测,'
  436. u'52:传感器报警,53:影像遗失,54:PIR,55:门磁报警, 56:外部发报, 57:人型报警,'
  437. u'702:摄像头休眠,703:摄像头唤醒,'
  438. u'704:电量过低)')
  439. status = models.BooleanField(blank=True, default=False, verbose_name=u'事件状态(0,1)')
  440. alarm = models.CharField(blank=True, max_length=256, verbose_name=u'报警信息')
  441. event_time = models.CharField(blank=True, db_index=True, default='', max_length=16, verbose_name=u'设备报警时间')
  442. receive_time = models.CharField(blank=True, default='', max_length=16, verbose_name=u'接收到报警时间')
  443. is_st = models.SmallIntegerField(default=0, verbose_name='是否截图(0:否,1:图片,2:视频)') # 0 否,1 是图,2,视频
  444. storage_location = models.SmallIntegerField(default=1, verbose_name='数据信息存储位置。1:阿里云oss,2:aws')
  445. border_coords = models.TextField(default='', blank=True, verbose_name=u'ai类型图片边框位置信息')
  446. add_time = models.IntegerField(verbose_name='添加时间', db_index=True, default=0)
  447. def __str__(self):
  448. return self.id
  449. class Meta:
  450. db_table = 'equipment_info_saturday'
  451. verbose_name = u'星期六设备信息推送表'
  452. verbose_name_plural = verbose_name
  453. ordering = ('-id',)
  454. app_label = "db2"
  455. class EquipmentInfoSunday(models.Model):
  456. id = models.BigAutoField(primary_key=True, verbose_name=u'自增标记ID')
  457. device_user_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户id')
  458. device_uid = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'设备uid')
  459. device_nick_name = models.CharField(blank=True, max_length=32, default='', verbose_name=u'设备昵称')
  460. channel = models.IntegerField(default=1, blank=True, verbose_name=u'设备通道')
  461. event_type = models.IntegerField(default=0, blank=True,
  462. verbose_name=u'事件类型(0:代表空字符,1:ai人,2:ai动物,3:车,123:组合类型(人/车/动物),51:移动侦测,'
  463. u'52:传感器报警,53:影像遗失,54:PIR,55:门磁报警, 56:外部发报, 57:人型报警,'
  464. u'702:摄像头休眠,703:摄像头唤醒,'
  465. u'704:电量过低)')
  466. status = models.BooleanField(blank=True, default=False, verbose_name=u'事件状态(0,1)')
  467. alarm = models.CharField(blank=True, max_length=256, verbose_name=u'报警信息')
  468. event_time = models.CharField(blank=True, db_index=True, default='', max_length=16, verbose_name=u'设备报警时间')
  469. receive_time = models.CharField(blank=True, default='', max_length=16, verbose_name=u'接收到报警时间')
  470. is_st = models.SmallIntegerField(default=0, verbose_name='是否截图(0:否,1:图片,2:视频)') # 0 否,1 是图,2,视频
  471. storage_location = models.SmallIntegerField(default=1, verbose_name='数据信息存储位置。1:阿里云oss,2:aws')
  472. border_coords = models.TextField(default='', blank=True, verbose_name=u'ai类型图片边框位置信息')
  473. add_time = models.IntegerField(verbose_name='添加时间', db_index=True, default=0)
  474. def __str__(self):
  475. return self.id
  476. class Meta:
  477. db_table = 'equipment_info_sunday'
  478. verbose_name = u'星期天设备信息推送表'
  479. verbose_name_plural = verbose_name
  480. ordering = ('-id',)
  481. app_label = "db2"
  482. class Ai_Push_Info(models.Model):
  483. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  484. devUid = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'设备ID')
  485. devNickName = models.CharField(blank=True, max_length=32, default='', verbose_name=u'设备昵称')
  486. Channel = models.IntegerField(default=1, blank=True, verbose_name=u'设备通道')
  487. eventType = models.CharField(blank=True, max_length=100, default='', verbose_name=u'事件类型')
  488. status = models.BooleanField(blank=True, default=False, verbose_name=u'事件状态')
  489. alarm = models.CharField(blank=True, max_length=256, verbose_name=u'报警信息')
  490. eventTime = models.CharField(blank=True, default='', max_length=16, verbose_name=u'设备报警时间')
  491. receiveTime = models.CharField(blank=True, default='', max_length=16, verbose_name=u'接收到报警时间')
  492. userID_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户ID')
  493. is_st = models.SmallIntegerField(default=0, verbose_name='是否截图') # 0 否,1 是图,2,视频
  494. storage_location = models.SmallIntegerField(default=1, db_index=True, verbose_name='数据信息存储位置。1:阿里云oss,2:aws')
  495. # message_id = models.CharField(blank=True, max_length=32, default='', verbose_name='第三方推送服务器返回的id')
  496. # push_type = models.SmallIntegerField(blank=True, default=0, verbose_name='第三方推送服务器标志。0:APNS推送,1:谷歌推送,2:极光推送')
  497. # push_server_status = models.IntegerField(blank=True, default=200, verbose_name='是否成功推送到第三方服务器。200:成功,other:失败')
  498. # push_device_status = models.SmallIntegerField(blank=True, default=-1, verbose_name='是否成功推送到目标设备。0:失败,1:成功')
  499. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  500. def __str__(self):
  501. return self.id
  502. class Meta:
  503. db_table = 'ai_push_info'
  504. verbose_name = u'ai信息推送表'
  505. verbose_name_plural = verbose_name
  506. ordering = ('-id',)
  507. class StatResModel(models.Model):
  508. id = models.AutoField(primary_key=True, verbose_name='自动ID')
  509. name = models.CharField(default='', max_length=120, verbose_name='图片名称', unique=True)
  510. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  511. def __str__(self):
  512. return self.name
  513. class Meta:
  514. db_table = 'statres'
  515. verbose_name = '静态资源表'
  516. verbose_name_plural = verbose_name
  517. ordering = ('id',)
  518. class FeedBackModel(models.Model):
  519. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  520. userID = models.ForeignKey(Device_User, null=True, blank=True, to_field='userID', on_delete=models.CASCADE)
  521. type = models.SmallIntegerField(default=0, verbose_name='反馈类型') # 【0:产品建议,1:功能异常,2:安全问题】
  522. status = models.SmallIntegerField(default=0, verbose_name='状态:0未解决/解决')
  523. content = models.TextField(blank=True, null=True, verbose_name=u'反馈描述')
  524. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  525. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  526. FS = models.ManyToManyField(to='StatResModel', blank=True, verbose_name=u'用户反馈关联资源',
  527. db_table='fb_res')
  528. app = models.CharField(max_length=8, default='', verbose_name='类型') # [ios,android]
  529. phone_model = models.CharField(max_length=64, default='', verbose_name='手机型号') # [小米,android]
  530. os_version = models.CharField(max_length=16, default='', verbose_name='系统版本')
  531. uid = models.CharField(max_length=20, default='', verbose_name='设备uid')
  532. product_type = models.CharField(max_length=32, default='', verbose_name='设备uid')
  533. app_version = models.CharField(max_length=32, default='', verbose_name='app版本信息')
  534. appBundleId = models.CharField(max_length=32, default='', verbose_name='app版本appBundleId')
  535. email = models.CharField(max_length=32, default='', verbose_name='app版本email')
  536. score = models.CharField(max_length=32, default='0', verbose_name='评分--星星数')
  537. def __str__(self):
  538. return self.id
  539. class Meta:
  540. db_table = 'feedback'
  541. verbose_name = u'用户反馈信息表'
  542. verbose_name_plural = verbose_name
  543. ordering = ('-id',)
  544. class User_Brand(models.Model):
  545. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  546. # 关联用户
  547. userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE)
  548. deviceSupplier = models.CharField(max_length=32, default='', verbose_name='(必填)设备供应商 string (例:华为、小米...)')
  549. deviceModel = models.CharField(max_length=64, default='', verbose_name='(必填)设备型号 string @mock=HM NOTE 1TD')
  550. osType = models.CharField(max_length=32, default='', verbose_name='(必填)操作系统名称 string @mock=Android')
  551. osVersion = models.CharField(max_length=32, default='', verbose_name='(必填)操作系统版本号 string @mock=4.0')
  552. country = models.CharField(max_length=200, default='', verbose_name='国家')
  553. province = models.CharField(max_length=150, default='', verbose_name='省')
  554. city = models.CharField(max_length=132, default='', verbose_name='市')
  555. area = models.CharField(max_length=132, default='', verbose_name='区')
  556. street = models.CharField(max_length=132, default='', verbose_name='街道')
  557. longitude = models.CharField(max_length=30, default='', verbose_name='经度')
  558. latitude = models.CharField(max_length=30, default='', verbose_name='纬度')
  559. appId = models.CharField(max_length=50, default='', verbose_name='appid_值')
  560. status = models.IntegerField(default=0, verbose_name='传国家省市信息过来就为状态:1 ,不传就为状态:0')
  561. ip = models.CharField(blank=True, max_length=20, default='', verbose_name=u'区域ip')
  562. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  563. def __str__(self):
  564. return self.id
  565. class Meta:
  566. db_table = 'user_brand'
  567. verbose_name = u'用户登录手机端手机品牌统计表'
  568. verbose_name_plural = verbose_name
  569. ordering = ('id',)
  570. # 存储通表
  571. class VodBucketModel(models.Model):
  572. id = models.AutoField(primary_key=True, verbose_name='主键')
  573. bucket = models.CharField(max_length=60, verbose_name='存储桶名称')
  574. storeDay = models.IntegerField(default=0, verbose_name='存储生命周期(天)')
  575. content = models.TextField(verbose_name='描述', default='')
  576. endpoint = models.CharField(max_length=125, default='', verbose_name='存储节点')
  577. area = models.CharField(max_length=16, default='', verbose_name='区域')
  578. region = models.CharField(max_length=16, default='', verbose_name='regionID')
  579. is_free = models.SmallIntegerField(default=0, verbose_name='是否为免费存储桶[0:否,1:是]')
  580. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  581. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  582. mold = models.SmallIntegerField(default=0, verbose_name='存储区域类型') # 0:国内阿里 1:国外aws
  583. region_id = models.IntegerField(default=1, verbose_name='大洲编号')
  584. def __str__(self):
  585. return self.id
  586. class Meta:
  587. db_table = 'vod_bucket'
  588. verbose_name = u'存储通信息'
  589. verbose_name_plural = verbose_name
  590. ordering = ('-id',)
  591. class Store_Meal(models.Model):
  592. id = models.AutoField(primary_key=True, verbose_name=u'自增ID')
  593. # title = models.CharField(blank=True, max_length=32, verbose_name=u'标题')
  594. currency = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'货币符号')
  595. symbol = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'符号')
  596. price = models.CharField(blank=True, max_length=32, verbose_name=u'价格')
  597. virtual_price = models.CharField(blank=True, max_length=32, verbose_name=u'虚拟价格')
  598. is_discounts = models.SmallIntegerField(default=0, verbose_name=u'该套餐是否有优惠 [0=否,1是]') # 0没有;1有
  599. discount_price = models.CharField(blank=True, max_length=32, verbose_name=u'第二年优惠价格')
  600. day = models.IntegerField(default=0, blank=True, verbose_name=u'云存录像保存天数(循环)') # 7,30,180,360
  601. expire = models.IntegerField(default=0, blank=True, verbose_name=u'有效期') #单位月
  602. # content = models.TextField(blank=True, null=True, verbose_name=u'描述')
  603. add_time = models.DateTimeField(blank=True, null=True, verbose_name=u'加入时间', auto_now_add=True)
  604. # type = models.SmallIntegerField(default=0, verbose_name='付款类型') # 0是paypal,1为支付宝
  605. pay_type = models.ManyToManyField(to='Pay_Type', verbose_name='付款类型', db_table='store_meal_pay')
  606. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  607. bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE,
  608. default=1, verbose_name='存储空间')
  609. commodity_type = models.SmallIntegerField(default=0, verbose_name='云存储套餐类型') # 0:事件型 1:连续型
  610. commodity_code = models.CharField(default='', max_length=32, verbose_name='套餐规格码')
  611. is_show = models.SmallIntegerField(default=0, verbose_name=u'该套餐是否隐藏 [0=否,1是]')
  612. # lang = models.CharField(default='', max_length=20, verbose_name='语言/国家')
  613. lang = models.ManyToManyField(to='Lang', verbose_name='套餐语言', db_table='store_meal_lang')
  614. cycle_config_id = models.IntegerField(null=True, verbose_name='周期付款配置表id')
  615. sort = models.IntegerField(default=99, blank=True, verbose_name=u'排序,越小越靠前') #单位月
  616. # 备用字段
  617. spare_3 = models.CharField(default='', blank=True, max_length=64, db_index=True, verbose_name=u'备用字段3')
  618. spare_4 = models.CharField(default='', blank=True, max_length=64, db_index=True, verbose_name=u'备用字段4')
  619. def __str__(self):
  620. return self.id
  621. class Meta:
  622. db_table = 'store_meal'
  623. verbose_name = u'存储套餐'
  624. verbose_name_plural = verbose_name
  625. ordering = ('id',)
  626. class AiStoreMeal(models.Model):
  627. id = models.AutoField(primary_key=True, verbose_name=u'自增ID')
  628. title = models.CharField(blank=True, max_length=32, verbose_name=u'标题')
  629. currency = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'货币符号')
  630. symbol = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'符号')
  631. price = models.CharField(blank=True, max_length=32, verbose_name=u'价格')
  632. virtual_price = models.CharField(blank=True, max_length=32, verbose_name=u'虚拟价格')
  633. is_discounts = models.SmallIntegerField(default=0, verbose_name=u'该套餐是否有优惠 [0=否,1是]') # 0没有;1有
  634. discount_price = models.CharField(blank=True, max_length=32, verbose_name=u'第二年优惠价格')
  635. effective_day = models.IntegerField(default=0, blank=True, verbose_name=u'有效天数') # 7,30,180,360
  636. content = models.TextField(blank=True, null=True, verbose_name=u'描述')
  637. add_time = models.DateTimeField(blank=True, null=True, verbose_name=u'加入时间', auto_now_add=True)
  638. # type = models.SmallIntegerField(default=0, verbose_name='付款类型') # 0是paypal,1为支付宝
  639. pay_type = models.ManyToManyField(to='Pay_Type', verbose_name='付款类型', db_table='ai_store_meal_pay')
  640. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  641. # bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE,
  642. # default=1, verbose_name='存储空间')
  643. # commodity_type = models.SmallIntegerField(default=0, verbose_name='套餐类型') # 1:人形 2:动物 3:汽车
  644. is_show = models.SmallIntegerField(default=0, verbose_name=u'该套餐是否隐藏 [0=否,1是]')
  645. lang = models.CharField(default='', max_length=20, verbose_name='语言/国家')
  646. # cycle_config_id = models.IntegerField(null=True, verbose_name='周期付款配置表id')
  647. def __str__(self):
  648. return self.id
  649. class Meta:
  650. db_table = 'ai_store_meal'
  651. verbose_name = u'AI套餐'
  652. verbose_name_plural = verbose_name
  653. ordering = ('id',)
  654. class Pay_Type(models.Model):
  655. id = models.AutoField(primary_key=True, verbose_name=u'自增ID')
  656. payment = models.CharField(max_length=32, verbose_name=u'支付方式')
  657. def __str__(self):
  658. return self.id
  659. class Meta:
  660. db_table = 'pay_type'
  661. verbose_name = u'付款类型'
  662. verbose_name_plural = verbose_name
  663. ordering = ('id',)
  664. # 套餐语言表
  665. class Lang(models.Model):
  666. id = models.AutoField(primary_key=True, verbose_name='自增ID')
  667. lang = models.CharField(default='', max_length=20, db_index=True, verbose_name='语言/国家')
  668. title = models.CharField(blank=True, max_length=320, verbose_name='标题')
  669. content = models.TextField(blank=True, null=True, verbose_name='描述')
  670. discount_content = models.CharField(blank=True, max_length=320, verbose_name=u'优惠信息描述')
  671. def __str__(self):
  672. return self.id
  673. class Meta:
  674. db_table = 'lang'
  675. verbose_name = '套餐语言'
  676. verbose_name_plural = verbose_name
  677. ordering = ('id',)
  678. class Equipment_Version(models.Model):
  679. eid = models.CharField(blank=True, max_length=32, primary_key=True)
  680. ESN = models.CharField(blank=True, max_length=32, verbose_name=u'设备规格名称')
  681. code = models.CharField(blank=True, max_length=64, verbose_name=u'设备规格代码')
  682. version = models.CharField(blank=True, max_length=64, verbose_name=u'设备版本')
  683. softwareVersion = models.CharField(blank=True, max_length=32, verbose_name=u'软件版本')
  684. chipModelList2Code = models.CharField(max_length=32, blank=True, verbose_name=u'主芯片码')
  685. channel = models.IntegerField(blank=True, verbose_name=u'通道数')
  686. resolutionRatio = models.IntegerField(blank=True, verbose_name=u'分辨率')
  687. type = models.CharField(blank=True, max_length=16, verbose_name=u'设备机型')
  688. companyCode = models.CharField(blank=True, max_length=128, verbose_name=u'用户公司名称')
  689. data_joined = models.DateTimeField(blank=True, verbose_name=u'加入时间', auto_now_add=True)
  690. fileSize = models.CharField(blank=True, max_length=16, verbose_name=u'文件总大小')
  691. filePath = models.CharField(blank=True, max_length=256, verbose_name=u'升级文件路径')
  692. Description = models.TextField(blank=True, default='', verbose_name=u'描述信息')
  693. fileMd5 = models.CharField(blank=True, max_length=32, default='', verbose_name=u'上传文件MD5加密')
  694. status = models.BooleanField(blank=True, default=True, verbose_name=u'是否开启更新状态')
  695. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  696. lang = models.CharField(blank=True, default='en', max_length=32, verbose_name=u'ota包内置语言')
  697. mci = models.CharField(default='', blank=True, max_length=10, verbose_name='设备类型')
  698. img = models.CharField(max_length=300, blank=True, default='', verbose_name=u'图片路径')
  699. max_ver = models.CharField(default='', max_length=16, verbose_name='最大版本号')
  700. def __str__(self):
  701. return self.eid
  702. class Meta:
  703. verbose_name = '设备版本信息'
  704. ordering = ('-data_joined',)
  705. db_table = 'equipment_version'
  706. class App_Info(models.Model):
  707. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  708. appBundleId = models.CharField(blank=True, max_length=32, verbose_name=u'appID')
  709. appName = models.CharField(blank=True, max_length=32, verbose_name=u'app名称')
  710. systemLanguage = models.CharField(blank=True, max_length=32, verbose_name=u'系统语言')
  711. newAppversion = models.CharField(blank=True, max_length=12, verbose_name=u'系统版本')
  712. minAppversion = models.CharField(default='', blank=True, max_length=12, verbose_name=u'最小系统版本')
  713. bundleVersion = models.CharField(blank=True, max_length=12, verbose_name=u'项目版本')
  714. content = models.TextField(blank=True, default='', verbose_name=u'更新内容')
  715. app_type = models.IntegerField(default=0, blank=True, verbose_name=u'app类型') # ios 1,android 2
  716. add_time = models.DateTimeField(blank=True, null=True, verbose_name=u'加入时间', auto_now_add=True)
  717. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  718. downloadLink = models.CharField(max_length=300, blank=True, default='', verbose_name='升级')
  719. img = models.CharField(default='', max_length=128, verbose_name='图片路径')
  720. def __str__(self):
  721. return self.id
  722. class Meta:
  723. db_table = 'app_info'
  724. verbose_name = u'app信息表'
  725. verbose_name_plural = verbose_name
  726. ordering = ('id',)
  727. class App_Colophon(models.Model):
  728. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  729. app_id = models.ForeignKey(App_Info, to_field='id', on_delete=models.CASCADE, verbose_name='appid编号', blank=True,
  730. default=1)
  731. lang = models.CharField(blank=True, max_length=32, verbose_name=u'系统语言')
  732. newApp_version = models.CharField(blank=True, max_length=12, verbose_name=u'系统版本')
  733. content = models.TextField(blank=True, default='', verbose_name=u'更新内容')
  734. version_time = models.IntegerField(default=0, blank=True, verbose_name=u'版本更新的时间')
  735. def __str__(self):
  736. return self.id
  737. class Meta:
  738. db_table = 'app_colophon'
  739. verbose_name = u'app信息表的记录关联到App_Info'
  740. verbose_name_plural = verbose_name
  741. ordering = ('id',)
  742. class Order_Model(models.Model):
  743. orderID = models.CharField(blank=True, max_length=20, primary_key=True, verbose_name=u'订单id')
  744. paymentID = models.CharField(blank=True, max_length=64, default='', verbose_name='付款id')
  745. trade_no = models.CharField(blank=True, max_length=32, default='', verbose_name='第三方订单号')
  746. userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE) # 订单关联用户
  747. UID = models.CharField(max_length=20, verbose_name='设备UID')
  748. channel = models.SmallIntegerField(default=0, verbose_name=u'通道数')
  749. desc = models.CharField(max_length=50, default='', verbose_name='商品描述')
  750. price = models.CharField(default='', max_length=16, verbose_name='价格')
  751. refunded_amount = models.FloatField(default=0, verbose_name=u'已退款金额')
  752. currency = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'货币')
  753. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  754. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  755. isSelectDiscounts = models.SmallIntegerField(default=0, verbose_name=u'用户是否选择了第二年优惠 [0=否,1是]')
  756. # 0: 待支付, 1:支付成功, 2: 取消支付, 4: 退款失败, 5: 全额退款, 6: 部分退款, 9:处理中, 10:支付失败
  757. status = models.SmallIntegerField(default=0, verbose_name='付款状态')
  758. # 1: PayPal, 2: 支付宝, 3: 微信, 10: 免费体验, 11: 激活码
  759. payType = models.SmallIntegerField(default=0, verbose_name='支付方式')
  760. payTime = models.IntegerField(verbose_name='支付成功时间', default=0)
  761. rank = models.ForeignKey(Store_Meal, to_field='id', default='', on_delete=models.CASCADE, verbose_name='关联云存套餐表')
  762. ai_rank = models.ForeignKey(AiStoreMeal, to_field='id', default='', on_delete=models.CASCADE, verbose_name='关联ai套餐表')
  763. order_type = models.SmallIntegerField(default=0, verbose_name='订单类型:0:云存:1:ai')
  764. nickname = models.CharField(default='', max_length=64, verbose_name='设备昵称')
  765. uid_bucket_id = models.IntegerField(default=0, verbose_name='关联uid_bucket的字段')
  766. commodity_type = models.SmallIntegerField(default=0, verbose_name='云存储套餐类型')
  767. commodity_code = models.CharField(default='', max_length=32, verbose_name='套餐规格码')
  768. pay_url = models.CharField(max_length=2000, default='', verbose_name='支付url')
  769. paypal = models.CharField(max_length=500, null=True, blank=True, verbose_name='支付批准url')
  770. promotion_rule_id = models.CharField(blank=True, max_length=64, default='', verbose_name='促销id')
  771. plan_id = models.CharField(default='', blank=True, max_length=64, verbose_name=u'paypal计划id')
  772. agreement_id = models.CharField(default='', blank=True, max_length=64, verbose_name=u'paypal协议id')
  773. coupon_id = models.CharField(default='', blank=True, max_length=10, verbose_name=u'优惠券id')
  774. # 备用字段
  775. spare_4 = models.CharField(default='', blank=True, max_length=64, db_index=True, verbose_name=u'备用字段4')
  776. def __str__(self):
  777. return self.orderID
  778. class Meta:
  779. db_table = 'orders'
  780. verbose_name = u'订单信息表'
  781. verbose_name_plural = verbose_name
  782. ordering = ('-orderID',)
  783. class CouponModel(models.Model):
  784. id = models.AutoField(primary_key=True, verbose_name='主键')
  785. userID_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户ID')
  786. use_status = models.SmallIntegerField(default=0, verbose_name='使用状态') #0未使用;1冻结;2已使用
  787. type = models.SmallIntegerField(default=0, verbose_name='优惠类型') #1打折; 2抵扣
  788. coupon_discount = models.CharField(blank=True, max_length=32, verbose_name=u'折扣力度')
  789. distributeTime = models.IntegerField(verbose_name='发放到用户账户时间', default=0)
  790. valid_time = models.PositiveIntegerField(default=9999999999, verbose_name='有效期间') #超过有效期不可在使用;0永久
  791. # use_limit = models.CharField(default=0, max_length=100, verbose_name='使用限制') #0:所有服务都可使用; 1:云存;2:ai;
  792. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  793. def __str__(self):
  794. return self.id
  795. class Meta:
  796. db_table = 'coupon'
  797. verbose_name = u'优惠券'
  798. verbose_name_plural = verbose_name
  799. class PayCycleConfigModel(models.Model):
  800. id = models.AutoField(primary_key=True, verbose_name='主键')
  801. # name = models.CharField(default='',max_length=200, verbose_name='计划名字')
  802. # tax = models.CharField(max_length=2000, default='', verbose_name='税金')
  803. cycles = models.IntegerField(verbose_name='周期:0代表无限期', default=0)
  804. frequency = models.CharField(max_length=50,verbose_name='频率,MONTH,WEEK,YEAR', default=0)
  805. frequencyInterval = models.IntegerField(default=0, verbose_name='频率周期')
  806. remark = models.CharField(max_length=1000, default='', verbose_name='备注')
  807. def __str__(self):
  808. return self.id
  809. class Meta:
  810. db_table = 'pay_cycle_config'
  811. verbose_name = u'周期付款计划'
  812. verbose_name_plural = verbose_name
  813. class PromotionRuleModel(models.Model):
  814. id = models.AutoField(primary_key=True, verbose_name='主键')
  815. ruleName = models.TextField(default='', verbose_name='规则名字') #json格式, 例: {"cn":"黑色星期五","en":"Black Friday"}
  816. ruleDesc = models.TextField(default='', verbose_name='规则描述') #json格式, 例: {"cn":"买一送一","en":"buy one get one free"}
  817. ruleConfig = models.CharField(max_length=2000, default='', verbose_name='规则配置') #json格式, 例: {"buy": 1, "get": 1}
  818. startTime = models.IntegerField(verbose_name='促销活动开始时间', default=0)
  819. endTime = models.IntegerField(verbose_name='促销活动结束时间', default=0)
  820. status = models.SmallIntegerField(default=0, verbose_name='活动状态:0未进行;1进行中')
  821. remark = models.CharField(max_length=50, default='', verbose_name='备注')
  822. popups = models.CharField(max_length=2000, default='', verbose_name='app弹窗消息') #json格式 ,例: {"cn":"买一送一","en":"buy one get one free"}
  823. def __str__(self):
  824. return self.id
  825. class Meta:
  826. db_table = 'promotion_rule'
  827. verbose_name = u'促销规则表'
  828. verbose_name_plural = verbose_name
  829. ordering = ('-id',)
  830. class VodHlsModel(models.Model):
  831. id = models.AutoField(primary_key=True, verbose_name='回放列表主键')
  832. uid = models.CharField(max_length=20, verbose_name='设备UID', db_index=True)
  833. channel = models.SmallIntegerField(default=0, verbose_name='通道')
  834. time = models.IntegerField(verbose_name='播放列表名字时间戳', default=0, db_index=True)
  835. endTime = models.IntegerField(verbose_name='云存储删除时间(周期)', default=0, db_index=True)
  836. sec = models.IntegerField(verbose_name='秒数', default=0)
  837. bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, default=1,
  838. verbose_name='存储空间')
  839. fg = models.CharField(max_length=20,verbose_name='ts个数,时间描述片段数') # 阿里为时间片段数,亚马逊为一个32bit整型,前28bit代表ts文件的时长
  840. def __str__(self):
  841. return self.id
  842. class Meta:
  843. db_table = 'vod_hls'
  844. verbose_name = u'云存回放信息表'
  845. verbose_name_plural = verbose_name
  846. ordering = ('-id',)
  847. class OssCrdModel(models.Model):
  848. id = models.AutoField(primary_key=True, verbose_name='主键')
  849. uid = models.CharField(max_length=20, verbose_name='设备UID')
  850. channel = models.SmallIntegerField(default=0, verbose_name='通道')
  851. data = models.TextField(verbose_name='设备sts')
  852. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  853. bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, default=1,
  854. verbose_name='存储空间')
  855. def __str__(self):
  856. return self.id
  857. class Meta:
  858. db_table = 'osscrd'
  859. verbose_name = u'设备证书'
  860. verbose_name_plural = verbose_name
  861. ordering = ('-id',)
  862. class StsCrdModel(models.Model):
  863. id = models.AutoField(primary_key=True, verbose_name='主键')
  864. uid = models.CharField(max_length=20, verbose_name='设备UID', db_index=True)
  865. channel = models.SmallIntegerField(default=0, verbose_name='通道')
  866. data = models.TextField(verbose_name='设备sts')
  867. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  868. bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, default=1,
  869. verbose_name='存储空间')
  870. type = models.SmallIntegerField(default=0,verbose_name='sts类型') # 0:阿里云,1:s3
  871. def __str__(self):
  872. return self.id
  873. class Meta:
  874. db_table = 'stscrd'
  875. verbose_name = u'设备证书'
  876. verbose_name_plural = verbose_name
  877. ordering = ('-id',)
  878. class UID_Bucket(models.Model):
  879. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  880. uid = models.CharField(max_length=20, verbose_name='设备UID', db_index=True)
  881. channel = models.SmallIntegerField(default=0, verbose_name='通道')
  882. bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, verbose_name='存储空间')
  883. status = models.SmallIntegerField(default=0, verbose_name='状态[0:开启,1:关闭]')
  884. endTime = models.BigIntegerField(verbose_name='套餐结束时间', db_index=True, default=0)
  885. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  886. updateTime = models.BigIntegerField(verbose_name='更新时间', default=0)
  887. use_status = models.IntegerField(verbose_name='使用状态[1:使用中,2已过期]', default=0)
  888. has_unused = models.SmallIntegerField(default=0, verbose_name='是否拥有其它未使用的套餐[0:否,1:是]')
  889. class Meta:
  890. db_table = 'vod_uid_bucket'
  891. verbose_name = '设备关联套餐表'
  892. verbose_name_plural = verbose_name
  893. ordering = ('id',)
  894. class Unused_Uid_Meal(models.Model):
  895. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  896. uid = models.CharField(max_length=20, verbose_name='设备UID', db_index=True)
  897. channel = models.SmallIntegerField(default=0, verbose_name='通道')
  898. bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, verbose_name='存储空间')
  899. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  900. expire = models.IntegerField(verbose_name='存储桶存储时长[月份]', default=0)
  901. num = models.IntegerField(verbose_name='个数', default=0)
  902. # effect_time = models.BigIntegerField(verbose_name='生效时间', db_index=True, default=0)
  903. # uid_bucket = models.ForeignKey(UID_Bucket, blank=True, to_field='id', on_delete=models.CASCADE, default=0,
  904. # verbose_name='uid_bucket关联')
  905. class Meta:
  906. db_table = 'unused_uid_Meal'
  907. verbose_name = '未使用的设备关联套餐表'
  908. verbose_name_plural = verbose_name
  909. ordering = ('id',)
  910. class UID_Preview(models.Model):
  911. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  912. uid = models.CharField(default='', max_length=20, db_index=True, verbose_name='设备UID')
  913. channel = models.SmallIntegerField(verbose_name=u'通道号', default=0)
  914. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  915. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  916. class Meta:
  917. db_table = 'uid_preview'
  918. verbose_name = '设备预览图'
  919. verbose_name_plural = verbose_name
  920. ordering = ('id',)
  921. # 系统发送信息新到用户
  922. class SysMsgModel(models.Model):
  923. id = models.AutoField(primary_key=True, verbose_name='自增id')
  924. userID_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户ID')
  925. msg = models.TextField(blank=True, default='', verbose_name=u'发送内容')
  926. status = models.SmallIntegerField(verbose_name='是否已读', default=0) # 0:否,1:是
  927. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  928. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  929. eventType = models.IntegerField(verbose_name='消息类型', default=0) # 默认系统消息类型,0系统消息,1 ipcamera消息
  930. uid = models.CharField(default='', max_length=20, db_index=True, verbose_name='设备UID')
  931. class Meta:
  932. db_table = 'sys_msg'
  933. verbose_name = '系统消息'
  934. verbose_name_plural = verbose_name
  935. ordering = ('-id',)
  936. app_label = "db2"
  937. # 设备推送重构
  938. # 设备配置表,新
  939. class UidSetModel(models.Model):
  940. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  941. uid = models.CharField(max_length=20, db_index=True, unique=True, verbose_name='设备UID')
  942. channel = models.SmallIntegerField(default=0, verbose_name='通道数量') #
  943. detect_status = models.SmallIntegerField(default=0, verbose_name='推送开关') # 状态[0:关闭,1:开启,2:用户解绑]
  944. detect_interval = models.IntegerField(verbose_name='推送间隔', default=60) # 秒
  945. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  946. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  947. ucode = models.CharField(max_length=32, verbose_name='设备产品码', default='')
  948. version = models.CharField(max_length=32, verbose_name='设备版本', default='')
  949. p2p_region = models.CharField(max_length=16, verbose_name='设备p2p区域', default='ALL') # ALL CN EU US
  950. cloud_vod = models.SmallIntegerField(default=2, verbose_name='云存开关') # 0,关闭,1开启,2,不支持
  951. tz = models.CharField(default='', max_length=16, verbose_name ='设备时区') # +8
  952. video_code = models.SmallIntegerField(default=0, verbose_name='编码类型') # 0:264,1:265
  953. nickname = models.CharField(default='', max_length=64, verbose_name='设备昵称')
  954. ip = models.CharField(max_length=20, default='', verbose_name=u'设备ip')
  955. # 设备重置后第一次启动时间
  956. is_alexa = models.IntegerField(default=0, verbose_name='是否支持alexa') # 0为不支持,1为支持,2为开启alexa发现
  957. detect_group = models.CharField(default='', max_length=32, verbose_name=u'检测类型')
  958. pwd = models.CharField(max_length=32, default='', verbose_name=u'设备密码') # 暂时是预留字段
  959. resetTime = models.IntegerField(default=0, verbose_name='设备重置时间')
  960. region_alexa = models.CharField(max_length=8, verbose_name='设备alexa区域', default='ALL') # ALL CN EU US
  961. deviceModel = models.CharField(blank=True, max_length=64, default='', verbose_name=u'设备型号')
  962. TimeZone = models.CharField(blank=True, max_length=50, default='', verbose_name=u'时区')
  963. TimeStatus = models.SmallIntegerField(default=0, verbose_name='同步手机时间开关。0:关闭,1:开启')
  964. SpaceUsable = models.CharField(blank=True, max_length=20, default='', verbose_name=u'可用空间')
  965. SpaceSum = models.CharField(blank=True, max_length=20, default='', verbose_name=u'总空间')
  966. MirrorType = models.IntegerField(blank=True, default=0, verbose_name=u'镜像类型 0:关闭镜像,1:上下镜像,2:左右镜像,3:上下左右镜像')
  967. RecordType = models.IntegerField(blank=True, default=0, verbose_name=u'录像模式(0:关闭,1:全是录像,3:报警录像)')
  968. OutdoorModel = models.IntegerField(blank=True, default=0, verbose_name=u'室外模式 0:关闭,1:开启')
  969. WIFIName = models.CharField(blank=True, max_length=50, default='', verbose_name=u'无线名称')
  970. isDetector = models.SmallIntegerField(default=0, verbose_name=u'侦测开关0:关闭,1:开启')
  971. DetectorRank = models.IntegerField(default=0, verbose_name=u'侦测灵敏度 0:低,1:中,2:高,3:最高')
  972. is_human = models.IntegerField(default=0, verbose_name='是否支持人形追踪。0:不支持,1:支持')
  973. is_custom_voice = models.IntegerField(default=0, verbose_name='是否支持自定义语音。0:不支持,1:支持')
  974. double_wifi = models.IntegerField(default=0, verbose_name='是否支持双频wifi。0:不支持,1:支持')
  975. is_ptz = models.IntegerField(default=0, verbose_name='是否支持云台。0:不支持,1:支持')
  976. is_ai = models.IntegerField(default=2, verbose_name='是否支持ai') # 0,关闭,1开启,2,不支持
  977. is_notification = models.IntegerField(blank=True, default=1, verbose_name='新加-消息提醒开关') # 0:关闭,1:开启
  978. new_detect_interval = models.IntegerField(blank=True, verbose_name='新加-消息提醒间隔', default=60) # 秒
  979. class Meta:
  980. db_table = 'uid_set'
  981. verbose_name = u'设备配置表'
  982. verbose_name_plural = verbose_name
  983. ordering = ('id',)
  984. # 设备关联用户推送
  985. class UidPushModel(models.Model):
  986. id = models.AutoField(primary_key=True, verbose_name='自增id')
  987. userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE)
  988. uid_set = models.ForeignKey(UidSetModel, to_field='id', on_delete=models.CASCADE)
  989. appBundleId = models.CharField(blank=True, max_length=32, verbose_name=u'appID')
  990. app_type = models.IntegerField(default=0, verbose_name=u'app类型 1:ios,2:安卓')
  991. push_type = models.IntegerField(default=0, verbose_name=u'推送类型') # 0,apns 1,安卓gcm 2,极光
  992. token_val = models.CharField(default='', max_length=160, verbose_name=u'设备验证令牌')
  993. m_code = models.CharField(default='', max_length=64, verbose_name='手机唯一标识')
  994. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  995. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  996. lang = models.CharField(max_length=8, verbose_name='推送语言类型', default='en') # en英文 cn中文
  997. tz = models.CharField(max_length=8, verbose_name='utc时区', default='0')
  998. class Meta:
  999. db_table = 'uid_push'
  1000. verbose_name = '设备绑定'
  1001. verbose_name_plural = verbose_name
  1002. ordering = ('-id',)
  1003. class GatewayPush(models.Model):
  1004. id = models.AutoField(primary_key=True, verbose_name='自增id')
  1005. user_id = models.CharField(default='', max_length=32, verbose_name=u'用户id')
  1006. app_bundle_id = models.CharField(default='', max_length=32, verbose_name=u'app包id')
  1007. app_type = models.IntegerField(default=0, verbose_name=u'app类型') # 1: ios, 2: 安卓
  1008. push_type = models.IntegerField(default=0, verbose_name=u'推送类型') # 0: apns, 1: 安卓gcm, 2: 极光
  1009. token_val = models.CharField(default='', max_length=500, verbose_name=u'设备验证令牌')
  1010. m_code = models.CharField(default='', max_length=64, verbose_name='手机唯一标识')
  1011. lang = models.CharField(default='en', max_length=8, verbose_name='推送语言')
  1012. tz = models.CharField(default='0', max_length=8, verbose_name='时区')
  1013. logout = models.BooleanField(default=False, verbose_name=u'退出登录')
  1014. class Meta:
  1015. db_table = 'gateway_push'
  1016. verbose_name = '网关推送'
  1017. verbose_name_plural = verbose_name
  1018. app_label = 'db2'
  1019. # 设备通道配置
  1020. class UidChannelSetModel(models.Model):
  1021. id = models.AutoField(primary_key=True, verbose_name='自增id')
  1022. uid = models.ForeignKey(UidSetModel, to_field='id', on_delete=models.CASCADE)
  1023. channel = models.IntegerField(default=1, verbose_name='通道号')
  1024. channel_name = models.CharField(blank=True, default='', max_length=20, verbose_name=u'通道名')
  1025. pir_audio = models.SmallIntegerField(default=0, verbose_name='pir声音。0:关闭,1:开启')
  1026. mic_audio = models.SmallIntegerField(default=0, verbose_name='mic声音。0:关闭,1:开启')
  1027. battery_status = models.SmallIntegerField(default=0, verbose_name='低电量提醒状态。0:关闭,1:开启')
  1028. battery_level = models.SmallIntegerField(default=0, verbose_name='低电量提醒级别。0: 低于10%;1:低于25%;2:低于50%;3:低于75%')
  1029. sleep_status = models.SmallIntegerField(default=0, verbose_name='是否开启【休眠通知】。0:关闭;1:开启')
  1030. sleep_time = models.SmallIntegerField(default=0, verbose_name='摄像机进入休眠时间。0:不休眠;1:10秒;2:20秒;3:30秒')
  1031. light_night_model = models.IntegerField(default=0, verbose_name='夜视模式') # 0:全彩模式,1:黑白模式,2:智能夜视模式
  1032. light_alarm_type = models.IntegerField(default=0, verbose_name='警报人形类型') # 0为人形,1为移动,3是人形和移动侦测0x0f
  1033. # 声光报警级别: 0: 关闭,1:强烈声光告警,2:轻微声光告警,3: 强烈声告警,4:轻微声告警,5:强烈光告警
  1034. light_alarm_level = models.IntegerField(default=0, verbose_name='声光报警级别')
  1035. light_alarm_man_en = models.IntegerField(default=0, verbose_name='人为告警状态') # 0:关,1:开
  1036. light_alarm_vol = models.IntegerField(default=0, verbose_name='报警音量') # 音量值0-100
  1037. light_long_light = models.IntegerField(default=0, verbose_name='长亮')
  1038. voice_prompt_status = models.SmallIntegerField(default=0, verbose_name='个性语音提示快关。0:关闭,1:开启')
  1039. voice_prompt_enter = models.IntegerField(default=0, verbose_name='进入铃声id')
  1040. voice_prompt_leave = models.IntegerField(default=0, verbose_name='离开铃声id')
  1041. voice_prompt_intelligent_mute = models.SmallIntegerField(default=0, verbose_name='智能静音。0:关闭,1:开启')
  1042. voice_start_x = models.FloatField(default=0, verbose_name='起始坐标的x')
  1043. voice_start_y = models.FloatField(default=18, verbose_name='起始坐标的y')
  1044. voice_end_x = models.FloatField(default=44, verbose_name='结束坐标的x')
  1045. voice_end_y = models.FloatField(default=18, verbose_name='结束坐标的y')
  1046. voice_start_time = models.IntegerField(default=0, verbose_name='语音执行的起始时间')
  1047. voice_end_time = models.IntegerField(default=0, verbose_name='语音执行的结束时间')
  1048. voice_repeat_day = models.IntegerField(default=127, verbose_name='语音执行的日期,周几')
  1049. voice_direction = models.IntegerField(default=0, verbose_name='语音方向。')
  1050. class Meta:
  1051. db_table = 'uid_channel'
  1052. verbose_name = '设备通道设置'
  1053. verbose_name_plural = verbose_name
  1054. # oauth2 第三方登录补全信息
  1055. class UserExModel(models.Model):
  1056. id = models.AutoField(primary_key=True, verbose_name='自增id')
  1057. userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE)
  1058. appBundleId = models.CharField(default='', max_length=32, verbose_name=u'appID')
  1059. region = models.CharField(default='', max_length=16, verbose_name='区域语言')
  1060. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  1061. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  1062. # {'cn': '简体中文', 'tc': '繁体中文', 'fr': '法文', 'ru': '俄文', 'es': '西班牙文', 'pl': '波兰文', 'ja': '日文', 'de': '德文', 'en': '英文'}
  1063. class Meta:
  1064. db_table = 'user_ex'
  1065. verbose_name = '用户扩展信息表'
  1066. verbose_name_plural = verbose_name
  1067. ordering = ('-id',)
  1068. # oauth2 第三方登录补全信息
  1069. class UserOauth2Model(models.Model):
  1070. id = models.AutoField(primary_key=True, verbose_name='自增id')
  1071. userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE)
  1072. authType = models.SmallIntegerField(default=0, verbose_name=0) # 授权类型 0 非授权,1 微信授权,2 苹果授权
  1073. unionID = models.CharField(default='', max_length=64, verbose_name='唯一标记') # 绑定唯一标记 unionID
  1074. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  1075. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  1076. # {'cn': '简体中文', 'tc': '繁体中文', 'fr': '法文', 'ru': '俄文', 'es': '西班牙文', 'pl': '波兰文', 'ja': '日文', 'de': '德文', 'en': '英文'}
  1077. class Meta:
  1078. db_table = 'user_oauth2'
  1079. verbose_name = '用户oauth2关联'
  1080. verbose_name_plural = verbose_name
  1081. ordering = ('-id',)
  1082. class SysMassModel(models.Model):
  1083. id = models.AutoField(primary_key=True, verbose_name='主键自增id')
  1084. sender = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE) # 发送人
  1085. platform = models.CharField(default='', verbose_name='平台', max_length=16)
  1086. lang = models.TextField(blank=True, default='', verbose_name=u'语种')
  1087. recever = models.TextField(blank=True, default='', verbose_name=u'接受者')
  1088. msg = models.TextField(blank=True, default='', verbose_name=u'发送内容')
  1089. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  1090. updTime = models.IntegerField(verbose_name='修改时间', default=0)
  1091. class Meta:
  1092. db_table = 'sys_mass'
  1093. verbose_name = '群发消息记录表'
  1094. verbose_name_plural = verbose_name
  1095. ordering = ('-id',)
  1096. class UidUserModel(models.Model):
  1097. id = models.CharField(max_length=32, primary_key=True)
  1098. userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE)
  1099. NickName = models.CharField(max_length=32, verbose_name=u'设备名称')
  1100. UID = models.CharField(max_length=32, verbose_name=u'设备UID', default='')
  1101. View_Account = models.CharField(max_length=32, verbose_name=u'设备用户名称', default='')
  1102. View_Password = models.CharField(max_length=32, verbose_name=u'设备密码', default='')
  1103. ChannelIndex = models.IntegerField(verbose_name=u'通道号', default=0)
  1104. Type = models.IntegerField(verbose_name='设备类型')
  1105. NotificationMode = models.IntegerField(verbose_name=u'是否报警', default=0)
  1106. isShare = models.BooleanField(verbose_name=u'共享设备', default=False)
  1107. primaryUserID = models.CharField(verbose_name='主用户id', max_length=32, default='')
  1108. primaryMaster = models.CharField(max_length=64, verbose_name=u'主用户名', default='')
  1109. data_joined = models.DateTimeField(verbose_name=u'设备添加时间', auto_now_add=True)
  1110. version = models.CharField(max_length=20, default='', verbose_name=u'版本号')
  1111. isVod = models.SmallIntegerField(default=0, verbose_name='是否支持云存') # 是否支持云存设备
  1112. isExist = models.SmallIntegerField(default=1, verbose_name='是否被删除') # 是否被删除了(需主用户交互) 1存在,0不存在
  1113. is_ap = models.SmallIntegerField(default=1, verbose_name='是否为ap模式添加') # 1为ap模式添加,0为非ap模式添加
  1114. class Meta:
  1115. db_table = 'uid_user'
  1116. ordering = ('-data_joined',)
  1117. verbose_name = u'用户设备ap表'
  1118. verbose_name_plural = verbose_name
  1119. class pushDeployModel(models.Model):
  1120. id = models.AutoField(primary_key=True, verbose_name='主键自增id')
  1121. name = models.CharField(max_length=32, default='', verbose_name=u'推送配置名称')
  1122. key = models.CharField(max_length=32, default='', verbose_name=u'推送配置key')
  1123. secret = models.CharField(max_length=32, default='', verbose_name=u'推送配置密钥')
  1124. pem = models.CharField(max_length=32, default='', verbose_name=u'推送配置路径')
  1125. type = models.CharField(max_length=32, default='', verbose_name=u'推送配置类型') # ios 1,android 2
  1126. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  1127. updTime = models.IntegerField(verbose_name='修改时间', default=0)
  1128. class Meta:
  1129. db_table = 'push_deploy'
  1130. verbose_name = '推送配置表'
  1131. verbose_name_plural = verbose_name
  1132. ordering = ('-id',)
  1133. class AppSetModel(models.Model):
  1134. id = models.AutoField(primary_key=True, verbose_name='主键自增id')
  1135. appBundleId = models.CharField(max_length=64, default='', verbose_name=u'APPid')
  1136. content = models.TextField(default='', verbose_name=u'里面包含评分,用户帮助,ap添加方式,ap工具,广告模块等json字段值')
  1137. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  1138. updTime = models.IntegerField(verbose_name='修改时间', default=0)
  1139. class Meta:
  1140. db_table = 'app_set'
  1141. verbose_name = 'app的各个版本控制表'
  1142. verbose_name_plural = verbose_name
  1143. ordering = ('-id',)
  1144. # 认证客户端类型表
  1145. class ApplicationModel(models.Model):
  1146. CLIENT_TYPES = (
  1147. ('confidential', 'confidential'),
  1148. ('public', 'public'),
  1149. )
  1150. # authorization_code
  1151. # 授权码模式(即先登录获取code, 再获取token)
  1152. # password
  1153. # 密码模式(将用户名, 密码传过去, 直接获取token)
  1154. # client_credentials
  1155. # 客户端模式(无用户, 用户向客户端注册, 然后客户端以自己的名义向’服务端’获取资源)
  1156. # implicit
  1157. # 简化模式(在redirect_uri
  1158. # 的Hash传递token;
  1159. # Auth客户端运行在浏览器中, 如JS, Flash)
  1160. # refresh_token
  1161. # 刷新access_token
  1162. GRANT_TYPES = (
  1163. ('authorization_code', "authorization_code"),
  1164. ('password', "password"),
  1165. ('client_credentials', "client_credentials"),
  1166. ('implicit', "implicit"),
  1167. ('refresh_token', "refresh_token"),
  1168. )
  1169. id = models.BigAutoField(primary_key=True)
  1170. name = models.CharField(max_length=128, blank=True, verbose_name='client名字描述')
  1171. client_id = models.CharField(max_length=50, unique=True, verbose_name='客户端id')
  1172. client_secret = models.CharField(max_length=50, unique=True, verbose_name='客户端secret')
  1173. client_type = models.CharField(max_length=32, choices=CLIENT_TYPES, verbose_name='客户端类型')
  1174. grant_type = models.CharField(max_length=32, choices=GRANT_TYPES, blank=True, null=True)
  1175. redirect_uri = models.TextField(blank=True, null=True, verbose_name='重定向url')
  1176. skip_auth = models.BooleanField(default=False, verbose_name='是否跳过点击授权')
  1177. add_time = models.IntegerField(verbose_name='添加时间', default=0)
  1178. update_time = models.IntegerField(verbose_name='更新时间', default=0)
  1179. class Meta:
  1180. ordering = ('-add_time',)
  1181. verbose_name = u'可授权客户端表'
  1182. db_table = 'oauth_application'
  1183. # 授权码信息表
  1184. class GrantCodeModel(models.Model):
  1185. id = models.BigAutoField(primary_key=True)
  1186. userID = models.ForeignKey(Device_User, verbose_name="用户表userID", to_field='userID', on_delete=models.CASCADE)
  1187. code = models.CharField(max_length=32, unique=True)
  1188. app_id = models.CharField(max_length=100, default='', verbose_name="appBundleId")
  1189. application = models.ForeignKey(ApplicationModel, verbose_name="用户表id", to_field='id', on_delete=models.CASCADE)
  1190. expire_time = models.IntegerField(verbose_name='过期时间', default=0)
  1191. add_time = models.IntegerField(verbose_name='添加时间', default=0)
  1192. update_time = models.IntegerField(verbose_name='更新时间', default=0)
  1193. # 输出的永远是本地时间输出的永远是本地时间
  1194. def is_expired(self):
  1195. return timezone.now() >= self.expire_time
  1196. class Meta:
  1197. ordering = ('-add_time',)
  1198. verbose_name = u'授权码表'
  1199. db_table = 'oauth_grant_code'
  1200. class UserAppFrequencyModel(models.Model):
  1201. id = models.AutoField(primary_key=True)
  1202. user = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE, verbose_name='关联设备用户表')
  1203. type = models.SmallIntegerField(default=0, verbose_name='使用频率类型') # 1:每天,2:三天,3:一周,4:两周,5:一个月,6:一个月以上
  1204. data_time = models.IntegerField(default=0, verbose_name='数据时间')
  1205. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1206. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1207. class Meta:
  1208. verbose_name = '用户使用APP频率表'
  1209. verbose_name_plural = verbose_name
  1210. db_table = 'user_app_frequency'
  1211. ordering = ('-add_time',)
  1212. class AppFrequencyStatisticsModel(models.Model):
  1213. id = models.AutoField(primary_key=True)
  1214. data = models.TextField(default='', verbose_name='统计好的数据')
  1215. month = models.IntegerField(default=0, verbose_name='月份')
  1216. year = models.IntegerField(default=0, verbose_name='年份')
  1217. class Meta:
  1218. verbose_name = 'app月使用频率统计表'
  1219. verbose_name_plural = verbose_name
  1220. db_table = 'app_frequency_statistics'
  1221. class AppFrequencyYearStatisticsModel(models.Model):
  1222. id = models.AutoField(primary_key=True)
  1223. data = models.TextField(default='', verbose_name='统计好的数据')
  1224. year = models.IntegerField(default=0, verbose_name='年份')
  1225. num = models.IntegerField(default=0, verbose_name='总人数')
  1226. class Meta:
  1227. verbose_name = 'app使用频率统计表,年度统计'
  1228. verbose_name_plural = verbose_name
  1229. db_table = 'app_frequency_year_statistics'
  1230. # alexa连接数统计表
  1231. class AlexaConnectStatisticsModel(models.Model):
  1232. id = models.AutoField(primary_key=True)
  1233. num = models.IntegerField(default=0, verbose_name='总人数')
  1234. data_time = models.IntegerField(default=0, verbose_name='数据时间')
  1235. class Meta:
  1236. verbose_name = 'alexa连接数统计表'
  1237. verbose_name_plural = verbose_name
  1238. db_table = 'alexa_statistics'
  1239. class FAQModel(models.Model):
  1240. id = models.AutoField(primary_key=True)
  1241. title = models.CharField(max_length=64, default='', unique=True, verbose_name='标题')
  1242. content = models.TextField(default='', verbose_name='内容')
  1243. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1244. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1245. class Meta:
  1246. db_table = 'tb_faq'
  1247. verbose_name = '问题帮助表'
  1248. verbose_name_plural = verbose_name
  1249. class AppLogModel(models.Model):
  1250. id = models.AutoField(primary_key=True)
  1251. user = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE, verbose_name='关联设备用户表')
  1252. uid = models.CharField(max_length=20, default='', verbose_name='设备uid')
  1253. average_delay = models.CharField(max_length=32, default='', verbose_name='最高平均延时')
  1254. status = models.SmallIntegerField(default=0, verbose_name='失败状态') # 0: 成功,1: 失败
  1255. filename = models.CharField(max_length=120, default='', verbose_name='文件名')
  1256. add_time = models.IntegerField(default=0, verbose_name='日期')
  1257. class Meta:
  1258. db_table = 'app_log'
  1259. verbose_name = 'APP日志表'
  1260. verbose_name_plural = verbose_name
  1261. class DeviceLogModel(models.Model):
  1262. id = models.AutoField(primary_key=True)
  1263. ip = models.CharField(default='', max_length=32, verbose_name='ip')
  1264. uid = models.CharField(max_length=32, default='', verbose_name='设备uid')
  1265. serial_number = models.CharField(max_length=9, default='', verbose_name='序列号')
  1266. status = models.SmallIntegerField(default=0, verbose_name='上传状态') # 0: 成功,1: 失败
  1267. filename = models.CharField(max_length=120, default='', verbose_name='文件名')
  1268. add_time = models.DateTimeField(blank=True, auto_now_add=True, verbose_name=u'添加时间')
  1269. class Meta:
  1270. db_table = 'device_log'
  1271. verbose_name = '设备日志表'
  1272. verbose_name_plural = verbose_name
  1273. class EquipmentInfoExStatisticsModel(models.Model):
  1274. id = models.AutoField(primary_key=True)
  1275. push_type = models.SmallIntegerField(default=0, verbose_name='第三方推送服务器标志。0:APNS推送,1:谷歌推送,2:极光推送')
  1276. number_of_successes = models.IntegerField(default=0, verbose_name='推送成功数量')
  1277. number_of_failures = models.IntegerField(default=0, verbose_name='推送失败数量')
  1278. number_of_arrival = models.IntegerField(default=0, verbose_name='推送到达数量')
  1279. statistics_date = models.IntegerField(default=0, verbose_name='属于哪天、哪月的统计')
  1280. date_type = models.SmallIntegerField(default=0, verbose_name='统计日期的类型。0:天,1:月')
  1281. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1282. class Meta:
  1283. db_table = 'equipment_info_ex_statistics'
  1284. verbose_name = '推送消息统计表'
  1285. verbose_name_plural = verbose_name
  1286. class CountryIPModel(models.Model):
  1287. id = models.AutoField(primary_key=True)
  1288. ip = models.CharField(default='', max_length=32, verbose_name='ip')
  1289. user_ex = models.ForeignKey(UserExModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联用户扩展信息表id')
  1290. country = models.CharField(default='', max_length=100, verbose_name='国家')
  1291. status = models.SmallIntegerField(default=0, verbose_name='是否已经查找,0:否,1:是')
  1292. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1293. class Meta:
  1294. db_table = 'country_ip'
  1295. verbose_name = 'ip-国家统计表'
  1296. verbose_name_plural = verbose_name
  1297. class ZositechHelpModel(models.Model):
  1298. id = models.AutoField(primary_key=True)
  1299. locale = models.CharField(default='', db_index=True, max_length=50, verbose_name='语言')
  1300. label_names = models.CharField(default='', db_index=True, max_length=50, verbose_name='标签')
  1301. origin = models.CharField(default='', db_index=True ,max_length=50, verbose_name='来源')
  1302. # author_id = models.CharField(default='', max_length=50, verbose_name='管理员id')
  1303. # body = models.TextField(default='', blank=True, verbose_name='内容')
  1304. # comments_disabled = models.CharField(default='', max_length=10, verbose_name='comments')
  1305. # created_at = models.CharField(default='', max_length=50, verbose_name='创建时间')
  1306. # draft = models.CharField(default='', max_length=10, verbose_name='草稿')
  1307. # edited_at = models.CharField(default='',max_length=50, verbose_name='修改时间')
  1308. # html_url = models.CharField(default='', blank=True, verbose_name='跳转路径')
  1309. # body = models.CharField(default='', blank=True, verbose_name='标签')
  1310. # body = models.CharField(default='', blank=True, verbose_name='标签')
  1311. # body = models.TextField(default='', blank=True, verbose_name='标签')
  1312. # body = models.TextField(default='', blank=True, verbose_name='标签')
  1313. # body = models.CharField(default='', blank=True, verbose_name='标签')
  1314. # body = models.CharField(default='', blank=True, verbose_name='标签')
  1315. content = models.TextField(blank=True, default='', verbose_name=u'内容')
  1316. class Meta:
  1317. db_table = 'zositech_help'
  1318. verbose_name = '周视使用帮助表'
  1319. verbose_name_plural = verbose_name
  1320. class EquipmentVersionLimitModel(models.Model):
  1321. id = models.AutoField(primary_key=True)
  1322. type = models.SmallIntegerField(default=0, verbose_name='限制类型')
  1323. content = models.TextField(default='', verbose_name='限制内容')
  1324. equipment_version = models.ForeignKey(Equipment_Version, to_field='eid', on_delete=models.CASCADE, verbose_name='关联设备版本信息id')
  1325. status = models.SmallIntegerField(default=0, verbose_name='是否启用。0:不启用,1:启用')
  1326. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1327. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1328. class Meta:
  1329. db_table = 'equipment_version_limit'
  1330. verbose_name = '设备版本信息限制表'
  1331. verbose_name_plural = verbose_name
  1332. class ExperienceContextModel(models.Model):
  1333. id = models.AutoField(primary_key=True)
  1334. experience_type = models.SmallIntegerField(default=0,verbose_name='体验类型') # 0: 免费体验套餐, 1: 激活码
  1335. uid = models.CharField(max_length=20, default='', verbose_name='设备uid')
  1336. do_time = models.IntegerField(default=0, verbose_name='激活时间')
  1337. # is_experience = models.SmallIntegerField(default=0, verbose_name=u'是否云存体验用户') # 0:不是体验用户,1:是体验用户
  1338. class Meta:
  1339. db_table = 'experience_context'
  1340. verbose_name = '设备体验表'
  1341. verbose_name_plural = verbose_name
  1342. class CDKcontextModel(models.Model):
  1343. id = models.AutoField(primary_key=True)
  1344. cdk = models.CharField(max_length=50,unique=True,verbose_name='激活码')
  1345. create_time = models.IntegerField(default=0, verbose_name='创建时间')
  1346. valid_time = models.IntegerField(default=0, verbose_name='有效期间') #超过有效期激活码不可在激活 ,0:永久
  1347. is_activate = models.SmallIntegerField(default=0, verbose_name='是否已激活') #0 未激活 1 已激活
  1348. is_down = models.SmallIntegerField(default=0, verbose_name='是否已下载') #0 未下载 1 已下载
  1349. rank = models.ForeignKey(Store_Meal, to_field='id', default='', on_delete=models.CASCADE, verbose_name='套餐类型')
  1350. # order = models.ForeignKey(Order_Model, blank=True, max_length=20, to_field='orderID', on_delete=models.CASCADE, verbose_name='订单id', unique=True)
  1351. order = models.CharField(max_length=20, blank=True, unique=True, verbose_name='订单id')
  1352. # 备用字段
  1353. spare_1 = models.CharField(default='', blank=True, max_length=64, verbose_name=u'备用字段1')
  1354. spare_2 = models.CharField(default='', blank=True, max_length=64, verbose_name=u'备用字段2')
  1355. spare_3 = models.CharField(default='', blank=True, max_length=64, db_index=True, verbose_name=u'备用字段3')
  1356. spare_4 = models.CharField(default='', blank=True, max_length=64, db_index=True, verbose_name=u'备用字段4')
  1357. class Meta:
  1358. db_table = 'cdk_context'
  1359. verbose_name = '激活码表'
  1360. verbose_name_plural = verbose_name
  1361. class VoicePromptModel(models.Model):
  1362. id = models.AutoField(primary_key=True)
  1363. title = models.CharField(max_length=128, default='', verbose_name='语音标题')
  1364. type = models.SmallIntegerField(default=0, verbose_name='语音类型。0:进入语音,1:离开语音')
  1365. filename = models.CharField(max_length=120, default='', verbose_name='文件名')
  1366. language = models.CharField(max_length=16, default='', verbose_name='语言类型')
  1367. classification = models.SmallIntegerField(default=1, verbose_name='语音分类。0:系统,1:自定义')
  1368. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1369. uid = models.CharField(max_length=20, default='0', verbose_name='关联设备UID')
  1370. channel = models.IntegerField(default=0, verbose_name='通道号')
  1371. status = models.SmallIntegerField(default=1, verbose_name='是否启用。0:不启用,1:启用')
  1372. class Meta:
  1373. db_table = 'voice_prompt'
  1374. verbose_name = '语音提示表'
  1375. verbose_name_plural = verbose_name
  1376. class DeviceTypeModel(models.Model):
  1377. id = models.AutoField(primary_key=True)
  1378. name = models.CharField(max_length=64, default='', verbose_name='设备名称')
  1379. model = models.SmallIntegerField(default=0, verbose_name='设备大类。1:dvr,2:ipc')
  1380. type = models.IntegerField(default=0, verbose_name='设备类型')
  1381. ptz_type = models.IntegerField(default=0, verbose_name='ptz类型。1:dvr球机,2:IPCPTZ,3:同轴菜单')
  1382. icon = models.CharField(max_length=120, default='', verbose_name='文件名')
  1383. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1384. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1385. class Meta:
  1386. db_table = 'device_type'
  1387. verbose_name = '设备类型表'
  1388. verbose_name_plural = verbose_name
  1389. class OperatingLogsModel(models.Model):
  1390. id = models.AutoField(primary_key=True)
  1391. userId = models.CharField(blank=False, max_length=32, db_index=True, verbose_name=u'操作人')
  1392. operatingtime = models.DateTimeField(blank=True, verbose_name=u'操作时间', auto_now=True)
  1393. operatingcontent = models.TextField(blank=True, default='', verbose_name=u'操作内容')
  1394. operatingtype = models.CharField(blank=True, verbose_name=u'操作类型', max_length=32)
  1395. is_saveprocessinfo = models.SmallIntegerField(default=1, verbose_name=u'是否保存过程信息。1:保存,2:不保存')
  1396. devUid = models.CharField(default='', blank=True, max_length=32, verbose_name=u'设备ID')
  1397. userIp = models.CharField(blank=True, max_length=20, default='', verbose_name=u'用户ip')
  1398. class Meta:
  1399. db_table = 'operating_logs'
  1400. verbose_name = '操作数据表'
  1401. verbose_name_plural = verbose_name
  1402. class ProcessInfoLogsModel(models.Model):
  1403. id = models.AutoField(primary_key=True)
  1404. userId = models.CharField(blank=False, max_length=32, db_index=True, verbose_name=u'操作人')
  1405. devUid = models.CharField(default='', blank=True, max_length=32, verbose_name=u'设备ID')
  1406. operatingcontent = models.TextField(blank=True, default='', verbose_name=u'操作内容')
  1407. operatingtime = models.DateTimeField(blank=True, verbose_name=u'操作时间', auto_now=True)
  1408. class Meta:
  1409. db_table = 'processinfo_logs'
  1410. verbose_name = '过程信息表'
  1411. verbose_name_plural = verbose_name
  1412. class EquipmentLogModel(models.Model):
  1413. id = models.AutoField(primary_key=True)
  1414. user = models.CharField(blank=False, max_length=32, db_index=True, verbose_name=u'操作用户')
  1415. uid = models.CharField(default='', blank=True, max_length=32, verbose_name=u'设备uid')
  1416. equipmentid = models.CharField(blank=False, max_length=100, db_index=True, verbose_name=u'设备主键id')
  1417. NickName = models.CharField(blank=True, max_length=32, verbose_name=u'设备名称')
  1418. ip = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'访问ip地址')
  1419. time = models.DateTimeField(null=True, blank=True, db_index=True, verbose_name=u'访问时间')
  1420. operatingcontent = models.TextField(blank=True, default='', verbose_name=u'操作内容')
  1421. url = models.CharField(max_length=150, default='', blank=True, verbose_name=u'访问路径')
  1422. class Meta:
  1423. db_table = 'equipment_log'
  1424. verbose_name = '设备日志表'
  1425. verbose_name_plural = verbose_name
  1426. class UserModel(models.Model):
  1427. id = models.AutoField(primary_key=True)
  1428. username = models.CharField(unique=True, max_length=128, null=False, verbose_name='用户名')
  1429. password = models.CharField(max_length=128, null=False, verbose_name='密码')
  1430. permission = models.CharField(max_length=24, null=False, verbose_name='权限')
  1431. login_time = models.IntegerField(blank=True, default=0, verbose_name='登录时间')
  1432. online = models.SmallIntegerField(default=0, verbose_name='是否在线')
  1433. phone = models.CharField(max_length=11, default='', verbose_name='手机号')
  1434. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1435. class Meta:
  1436. verbose_name = '用户表'
  1437. verbose_name_plural = verbose_name
  1438. db_table = 'user'
  1439. class CompanyModel(models.Model):
  1440. id = models.AutoField(primary_key=True)
  1441. name = models.CharField(max_length=64, unique=True, default='', verbose_name='企业名称')
  1442. mark = models.CharField(max_length=3, unique=True, default='', verbose_name='企业标志,用于序列号的后三位')
  1443. secret = models.CharField(max_length=10, db_index=True, default='', verbose_name='企业秘钥')
  1444. quantity = models.IntegerField(default=0, verbose_name='已购买的序列号的数量')
  1445. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1446. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1447. class Meta:
  1448. db_table = 'tb_company'
  1449. verbose_name = '企业表'
  1450. verbose_name_plural = verbose_name
  1451. class RegionModel(models.Model):
  1452. id = models.AutoField(primary_key=True)
  1453. name = models.CharField(max_length=32, default='', verbose_name='区域名称')
  1454. continent_code = models.CharField(max_length=3, default='', verbose_name='洲代码')
  1455. api = models.CharField(max_length=50, default='', verbose_name='请求地址')
  1456. class Meta:
  1457. db_table = 'tb_region'
  1458. verbose_name = '区域表'
  1459. verbose_name_plural = verbose_name
  1460. class VPGModel(models.Model):
  1461. id = models.AutoField(primary_key=True)
  1462. name = models.CharField(max_length=32, default='', verbose_name='群组名称')
  1463. uid_count = models.IntegerField(default=0, verbose_name='uid数量')
  1464. region = models.ForeignKey(RegionModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='群组用于的地区')
  1465. company = models.ForeignKey(CompanyModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联企业表')
  1466. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1467. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1468. class Meta:
  1469. db_table = 'tb_vpg'
  1470. verbose_name = 'vpg表'
  1471. verbose_name_plural = verbose_name
  1472. class UIDModel(models.Model):
  1473. id = models.AutoField(primary_key=True)
  1474. uid = models.CharField(max_length=20, null=False, db_index=True, unique=True, verbose_name='设备id')
  1475. mac = models.CharField(max_length=17, null=True, default='', verbose_name='设备id对应的mac地址')
  1476. uid_extra = models.TextField(default='', verbose_name='uid的额外描述')
  1477. status = models.SmallIntegerField(default=0, verbose_name='使用状态') # 0:未分配,1:已分配,2:已使用
  1478. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1479. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1480. area = models.SmallIntegerField(default=0, verbose_name='区域') #0:国内;1:国外
  1481. vpg = models.ForeignKey(VPGModel, to_field='id', default=1, on_delete=models.DO_NOTHING, verbose_name='关联VPG表的id')
  1482. p2p_type = models.IntegerField(default=1, verbose_name='p2p类型。1:宸云,2:tutk')
  1483. full_uid_code = models.CharField(max_length=256, default='', verbose_name='宸云完整uid')
  1484. platform = models.CharField(max_length=10, default='', verbose_name='平台')
  1485. init_string = models.CharField(max_length=256, default='', verbose_name='尚云设备初始化字符')
  1486. init_string_app = models.CharField(max_length=256, default='', verbose_name='尚云设备app初始化字符')
  1487. class Meta:
  1488. ordering = ('-add_time',)
  1489. verbose_name = 'uid表'
  1490. verbose_name_plural = verbose_name
  1491. db_table = 'uid'
  1492. class UserUIDModel(models.Model):
  1493. id = models.AutoField(primary_key=True)
  1494. user = models.ForeignKey(UserModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联用户表id')
  1495. uid = models.ForeignKey(UIDModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联uid表id')
  1496. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1497. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1498. class Meta:
  1499. verbose_name = '用户与UID的关联表'
  1500. verbose_name_plural = verbose_name
  1501. db_table = 'user_uid'
  1502. class PermissionModel(models.Model):
  1503. id = models.AutoField(primary_key=True)
  1504. type = models.SmallIntegerField(null=False, verbose_name='权限枚举')
  1505. description = models.TextField(default='', verbose_name='权限描述')
  1506. class Meta:
  1507. verbose_name = '权限表'
  1508. verbose_name_plural = verbose_name
  1509. db_table = 'permission'
  1510. class LogModel(models.Model):
  1511. id = models.AutoField(primary_key=True)
  1512. operation = models.CharField(max_length=100, default='', verbose_name='操作描述')
  1513. time = models.IntegerField(default=0, verbose_name='操作时间')
  1514. ip = models.CharField(default='', max_length=24, verbose_name='用户ip')
  1515. user = models.ForeignKey(UserModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联用户id')
  1516. content = models.TextField(default='', verbose_name='请求参数')
  1517. status = models.IntegerField(default=0, verbose_name='请求状态')
  1518. url = models.CharField(max_length=150, default='', verbose_name='请求路径')
  1519. class Meta:
  1520. ordering = ('-time',)
  1521. verbose_name = '日志表'
  1522. verbose_name_plural = verbose_name
  1523. db_table = 'log'
  1524. class HistoryUIDModel(models.Model):
  1525. id = models.AutoField(primary_key=True)
  1526. uid = models.CharField(max_length=20, null=False, db_index=True, verbose_name='设备id')
  1527. uid_extra = models.TextField(default='', verbose_name='uid的额外描述')
  1528. status = models.SmallIntegerField(default=0, verbose_name='使用状态')
  1529. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1530. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1531. area = models.SmallIntegerField(default=0, verbose_name='区域') # 0:国内;1:国外
  1532. class Meta:
  1533. verbose_name = '历史UID表'
  1534. verbose_name_plural = verbose_name
  1535. db_table = 'history_uid'
  1536. class MacModel(models.Model):
  1537. id = models.AutoField(primary_key=True)
  1538. value = models.CharField(max_length=17, null=False, verbose_name='最新的mac地址')
  1539. is_active = models.BooleanField(default=True, verbose_name='当前mac地址是否可用')
  1540. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1541. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1542. class Meta:
  1543. verbose_name = '最新的mac地址表'
  1544. verbose_name_plural = verbose_name
  1545. db_table = 'tb_mac'
  1546. class OrderTaskModel(models.Model):
  1547. id = models.AutoField(primary_key=True)
  1548. order_number = models.CharField(max_length=32, verbose_name='订单号')
  1549. board = models.CharField(max_length=32, verbose_name='主板')
  1550. plan = models.CharField(max_length=32, verbose_name='配置方案')
  1551. checksum = models.CharField(max_length=32, verbose_name='校验和')
  1552. ic_model = models.CharField(max_length=32, verbose_name='ic型号')
  1553. quantity = models.IntegerField(default=0, verbose_name='通知单上的生成数量')
  1554. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1555. class Meta:
  1556. db_table = 'order_task'
  1557. verbose_name = '订单任务表'
  1558. verbose_name_plural = verbose_name
  1559. class OrderUIDModel(models.Model):
  1560. id = models.AutoField(primary_key=True)
  1561. uid = models.ForeignKey(UIDModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联uid表')
  1562. order = models.ForeignKey(OrderTaskModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联订单任务表')
  1563. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1564. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1565. class Meta:
  1566. db_table = 'order_uid'
  1567. verbose_name = '订单与uid关联表'
  1568. verbose_name_plural = verbose_name
  1569. class CountryModel(models.Model):
  1570. id = models.AutoField(primary_key=True)
  1571. number = models.IntegerField(unique=True, verbose_name='区号')
  1572. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1573. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1574. region = models.ForeignKey(RegionModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联区域表')
  1575. country_code = models.CharField(max_length=2, default='', verbose_name='国家iso2代码')
  1576. country_name = models.CharField(max_length=20, default='', verbose_name='国家名')
  1577. class Meta:
  1578. db_table = 'tb_country'
  1579. verbose_name = '地区表'
  1580. verbose_name_plural = verbose_name
  1581. class LanguageModel(models.Model):
  1582. id = models.AutoField(primary_key=True)
  1583. lang = models.CharField(max_length=16, default='', verbose_name='语种')
  1584. lang_youdao = models.CharField(max_length=16, default='', verbose_name='有道的语种')
  1585. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1586. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1587. class Meta:
  1588. db_table = 'tb_language'
  1589. verbose_name = '语言表'
  1590. verbose_name_plural = verbose_name
  1591. class CountryLanguageModel(models.Model):
  1592. id = models.AutoField(primary_key=True)
  1593. country_name = models.CharField(max_length=64, default='', verbose_name='国家名称')
  1594. language = models.ForeignKey(LanguageModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联语言表的id')
  1595. country = models.ForeignKey(CountryModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联地区表的id')
  1596. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1597. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1598. class Meta:
  1599. db_table = 'tb_country_language'
  1600. verbose_name = '不同语言的地区名称表'
  1601. verbose_name_plural = verbose_name
  1602. class SerialNumberModel(models.Model):
  1603. id = models.AutoField(primary_key=True)
  1604. serial_number = models.CharField(max_length=9, db_index=True, unique=True, verbose_name='序列号')
  1605. status = models.SmallIntegerField(default=1, verbose_name='可用状态。0:不可用,1:可用')
  1606. use_status = models.SmallIntegerField(default=0, db_index=True, verbose_name='使用状态, 0: 未使用, 1: 已分配')
  1607. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1608. class Meta:
  1609. db_table = 'tb_serial_number'
  1610. verbose_name = '序列号表'
  1611. verbose_name_plural = verbose_name
  1612. class CompanySerialModel(models.Model):
  1613. id = models.AutoField(primary_key=True)
  1614. company = models.ForeignKey(CompanyModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联企业表的id')
  1615. serial_number = models.CharField(max_length=11, db_index=True, blank=True, default='', verbose_name=u'6位数序列号')
  1616. status = models.SmallIntegerField(default=0, verbose_name='序列号的状态。0:未使用,1:已使用,2:已和UID关联,3:已占用')
  1617. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1618. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1619. class Meta:
  1620. db_table = 'tb_company_serial'
  1621. verbose_name = '企业关联序列号表'
  1622. verbose_name_plural = verbose_name
  1623. class UIDCompanySerialModel(models.Model):
  1624. id = models.AutoField(primary_key=True)
  1625. uid = models.ForeignKey(UIDModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联UID表')
  1626. company_serial = models.ForeignKey(CompanySerialModel, to_field='id', on_delete=models.CASCADE, verbose_name='6位数序列号')
  1627. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1628. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1629. class Meta:
  1630. db_table = 'tb_uid_company_serial'
  1631. verbose_name = 'UID关联【企业关联序列号】表'
  1632. verbose_name_plural = verbose_name
  1633. class iotdeviceInfoModel(models.Model):
  1634. id = models.AutoField(primary_key=True)
  1635. serial_number = models.CharField(max_length=11, blank=True, default='', db_index=True, verbose_name=u'关联Device_Info表的序列号')
  1636. uid = models.CharField(blank=True, max_length=32, default='', db_index=True, verbose_name=u'设备UID')
  1637. certificate_id = models.CharField(blank=True, max_length=256, default='', verbose_name=u'证书id')
  1638. certificate_pem = models.TextField(blank=True, default='', verbose_name=u'证书项目')
  1639. public_key = models.TextField(blank=True, default='', verbose_name=u'公有密钥')
  1640. private_key = models.TextField(blank=True, default='', verbose_name=u'私有密钥')
  1641. thing_name = models.CharField(blank=True, max_length=256, default='', verbose_name=u'IoT Thing Name')
  1642. thing_groups = models.CharField(blank=True, max_length=256, default='', verbose_name=u'IoT Thing Groups')
  1643. endpoint = models.CharField(blank=True, max_length=256, db_index=True, default='', verbose_name=u'iot端点')
  1644. token_iot_number = models.CharField(blank=True, db_index=True, default='', max_length=50, verbose_name='连接iot令牌')
  1645. add_time = models.DateTimeField(blank=True, auto_now_add=True, verbose_name=u'添加时间')
  1646. update_time = models.DateTimeField(blank=True, auto_now=True, verbose_name=u'更新时间')
  1647. class Meta:
  1648. db_table = 'iot_deviceInfo'
  1649. verbose_name = 'iot设备信息表'
  1650. verbose_name_plural = verbose_name
  1651. ordering = ('-add_time',)
  1652. class UIDMainUser(models.Model):
  1653. id = models.AutoField(primary_key=True)
  1654. UID = models.CharField(blank=True, max_length=32, verbose_name=u'设备UID', default='')
  1655. user_id = models.CharField(blank=True, max_length=32, verbose_name=u'用户ID', default='')
  1656. class Meta:
  1657. db_table = 'uid_mainuser'
  1658. verbose_name = '设备主用户表'
  1659. verbose_name_plural = verbose_name
  1660. class Pc_Info(models.Model):
  1661. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1662. pc_name = models.CharField(blank=True, max_length=32, verbose_name=u'软件名称')
  1663. bundle_version = models.IntegerField(default=0, verbose_name=u'项目类型。0:Zosi;149:COCOON HD; 150:Loocam; 151:中性')
  1664. pc_version = models.CharField(blank=True, max_length=12, verbose_name=u'版本号')
  1665. pc_test = models.SmallIntegerField(default=0, verbose_name='测试版。0:否,1:是')
  1666. lang = models.CharField(blank=True, max_length=32, verbose_name=u'语言类型')
  1667. download_link = models.CharField(max_length=300, blank=True, default='', verbose_name='下载链接')
  1668. add_time = models.IntegerField(verbose_name='添加时间', default=0)
  1669. update_time = models.IntegerField(verbose_name='更新时间', default=0)
  1670. file_type = models.CharField(blank=True, max_length=32, verbose_name=u'文件类型')
  1671. package = models.CharField(blank=True, max_length=32, verbose_name=u'整合包id')
  1672. explain = models.TextField(blank=True, default='', verbose_name=u'更新内容')
  1673. is_update = models.SmallIntegerField(blank=True, default=0, verbose_name='强制更新。0:否,1:是')
  1674. is_open = models.SmallIntegerField(blank=True, default=0, verbose_name='是否开启版本。0:否,1:是')
  1675. content = models.TextField(blank=True, default='', verbose_name=u'内容信息')
  1676. authority = models.SmallIntegerField(blank=True, default=0, verbose_name='权限')
  1677. class Meta:
  1678. db_table = 'pc_info'
  1679. verbose_name = u'pc信息表'
  1680. verbose_name_plural = verbose_name
  1681. ordering = ('id',)
  1682. class CloudLogModel(models.Model):
  1683. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1684. user = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'用户')
  1685. uid = models.CharField(blank=True, max_length=32, db_index=True, verbose_name=u'uid', default='')
  1686. operation = models.CharField(max_length=100, db_index=True, default='', blank=True, verbose_name=u'操作')
  1687. ip = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'访问ip地址')
  1688. url = models.CharField(max_length=150, default='', blank=True, verbose_name=u'访问路径')
  1689. time = models.IntegerField(null=True, blank=True, db_index=True, verbose_name=u'访问时间')
  1690. content = models.TextField(blank=True, default='', verbose_name=u'参数内容')
  1691. class Meta:
  1692. db_table = 'cloud_log'
  1693. verbose_name = '云存api记录表'
  1694. verbose_name_plural = verbose_name
  1695. class VideoPlaybackTimeModel(models.Model):
  1696. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1697. userID = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'用户ID')
  1698. uid = models.CharField(max_length=32, default='', db_index=True, verbose_name=u'uid')
  1699. playMode = models.CharField(max_length=10, default='', verbose_name=u'播放模式')
  1700. startTime = models.IntegerField(default=0, verbose_name=u'开始播放时间')
  1701. duration = models.SmallIntegerField(default=0, verbose_name='播放时长')
  1702. class Meta:
  1703. db_table = 'video_playback_time'
  1704. verbose_name = '视频播放时长表'
  1705. verbose_name_plural = verbose_name
  1706. class PctestjobModel(models.Model):
  1707. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1708. jobname = models.CharField(blank=True, max_length=32, verbose_name=u'岗位名字')
  1709. jobcode = models.SmallIntegerField(default=3, verbose_name='岗位code 。1:管理员,3:普通人员')
  1710. class Meta:
  1711. db_table = 'pctest_job'
  1712. verbose_name = u'pc岗位表'
  1713. verbose_name_plural = verbose_name
  1714. ordering = ('id',)
  1715. class PctestdeviceModel(models.Model):
  1716. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1717. devicename = models.CharField(blank=True, max_length=32, verbose_name=u'设备名字')
  1718. class Meta:
  1719. db_table = 'pctest_device'
  1720. verbose_name = u'pc测试设备表'
  1721. verbose_name_plural = verbose_name
  1722. ordering = ('id',)
  1723. class PctestfunctionModel(models.Model):
  1724. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1725. functionname = models.CharField(blank=True, max_length=32, verbose_name=u'职能名字')
  1726. functioncode = models.SmallIntegerField(default=1, verbose_name='职能code 。PC端自己逻辑判断')
  1727. class Meta:
  1728. db_table = 'pctest_function'
  1729. verbose_name = u'pc设备职能表'
  1730. verbose_name_plural = verbose_name
  1731. ordering = ('id',)
  1732. class PctestuserModel(models.Model):
  1733. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1734. username = models.CharField(blank=True, max_length=32, verbose_name=u'用户名字')
  1735. password = models.CharField(blank=True, max_length=32, verbose_name=u'用户名字')
  1736. job = models.ForeignKey(PctestjobModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联pc岗位表')
  1737. class Meta:
  1738. db_table = 'pctest_user'
  1739. verbose_name = u'pc角色岗位表'
  1740. verbose_name_plural = verbose_name
  1741. ordering = ('id',)
  1742. class PctestlogModel(models.Model):
  1743. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1744. user = models.ForeignKey(PctestuserModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联pc岗位表')
  1745. content = models.TextField(blank=True, default='', verbose_name=u'测试日志')
  1746. addtime = models.IntegerField(verbose_name='添加时间', default=0)
  1747. class Meta:
  1748. db_table = 'pctest_log'
  1749. verbose_name = u'pc测试日志表'
  1750. verbose_name_plural = verbose_name
  1751. ordering = ('id',)
  1752. class PctestjobdeviceModel(models.Model):
  1753. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1754. job = models.ForeignKey(PctestjobModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联pc岗位表')
  1755. device = models.ForeignKey(PctestdeviceModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联pc测试设备表')
  1756. class Meta:
  1757. db_table = 'pctest_job_device'
  1758. verbose_name = u'pc岗位设备关联表'
  1759. verbose_name_plural = verbose_name
  1760. ordering = ('id',)
  1761. class PctestModel(models.Model):
  1762. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1763. device = models.ForeignKey(PctestdeviceModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联pc测试设备表')
  1764. function = models.ForeignKey(PctestfunctionModel, to_field='id', on_delete=models.DO_NOTHING, verbose_name='关联pc设备职能表')
  1765. class Meta:
  1766. db_table = 'pctest_device_function'
  1767. verbose_name = u'pc岗位设备关联表'
  1768. verbose_name_plural = verbose_name
  1769. ordering = ('id',)
  1770. class P2PIpModel(models.Model):
  1771. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1772. uid = models.CharField(max_length=20, default='', unique=True, db_index=True, verbose_name='设备uid')
  1773. ip = models.CharField(default='', max_length=32, verbose_name='ip')
  1774. p2p_request_times = models.IntegerField(default=0, verbose_name='p2p请求次数')
  1775. relay_request_times = models.IntegerField(default=0, verbose_name='relay请求次数')
  1776. continent_name = models.CharField(default='', max_length=10, verbose_name='大洲')
  1777. country_name = models.CharField(default='', max_length=100, verbose_name='国家')
  1778. region_name = models.CharField(default='', max_length=100, verbose_name='地区')
  1779. city_name = models.CharField(default='', max_length=100, verbose_name='城市')
  1780. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  1781. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  1782. class Meta:
  1783. db_table = 'p2p_ip'
  1784. verbose_name = u'设备p2p_ip地区表'
  1785. verbose_name_plural = verbose_name
  1786. class DeviceDomainModel(models.Model):
  1787. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1788. uid = models.CharField(max_length=20, default='', unique=True, db_index=True, verbose_name='uid')
  1789. serial_number = models.CharField(max_length=9, default='', unique=True, db_index=True, verbose_name='序列号')
  1790. ip = models.CharField(default='', max_length=32, verbose_name='ip')
  1791. country_name = models.CharField(max_length=20, default='', verbose_name='国家名')
  1792. api = models.CharField(max_length=50, default='', verbose_name='使用的域名')
  1793. add_time = models.DateTimeField(blank=True, auto_now_add=True, verbose_name=u'添加时间')
  1794. update_time = models.DateTimeField(blank=True, auto_now=True, verbose_name=u'更新时间')
  1795. class Meta:
  1796. db_table = 'device_domain'
  1797. verbose_name = u'设备域名表'
  1798. verbose_name_plural = verbose_name
  1799. class RequestRecordModel(models.Model):
  1800. id = models.AutoField(primary_key=True, verbose_name=u'自增ID')
  1801. method = models.CharField(max_length=10, default='', verbose_name='请求类型')
  1802. url = models.CharField(max_length=200, default='', verbose_name='请求路径')
  1803. parameter = models.CharField(max_length=200, default='', verbose_name='请求参数')
  1804. execute_time = models.FloatField(default=0, verbose_name='执行时间')
  1805. status_code = models.CharField(max_length=10, default='', verbose_name='响应状态码')
  1806. reason_phrase = models.CharField(max_length=200, default='', verbose_name='错误信息')
  1807. add_time = models.DateTimeField(blank=True, auto_now_add=True, verbose_name=u'添加时间')
  1808. class Meta:
  1809. db_table = 'request_record'
  1810. verbose_name = u'请求记录表'
  1811. verbose_name_plural = verbose_name
  1812. ordering = ('-add_time',)
  1813. class AiService(models.Model):
  1814. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1815. uid = models.CharField(max_length=20, verbose_name='设备UID', db_index=True)
  1816. channel = models.SmallIntegerField(default=0, verbose_name='通道')
  1817. orders = models.ForeignKey(Order_Model, to_field='orderID', default='', on_delete=models.CASCADE, verbose_name='关联订单表')
  1818. detect_status = models.SmallIntegerField(default=0, verbose_name='状态[0:开启,1:关闭]')
  1819. endTime = models.BigIntegerField(verbose_name='套餐结束时间', db_index=True, default=0)
  1820. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  1821. updTime = models.BigIntegerField(verbose_name='更新时间', default=0)
  1822. use_status = models.IntegerField(verbose_name='使用状态[0:未使用,1:使用中,2已过期]', default=0)
  1823. detect_group = models.CharField(blank=True, default='1', max_length=100, verbose_name='侦测类型[1=人;2=动物;3=车]')
  1824. detect_interval = models.IntegerField(verbose_name='推送间隔', default=60) # 秒
  1825. class Meta:
  1826. db_table = 'ai_service'
  1827. verbose_name = 'ai设备服务表'
  1828. verbose_name_plural = verbose_name
  1829. ordering = ('id',)
  1830. class AiProcessTime(models.Model):
  1831. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1832. msg_id = models.CharField(max_length=50, verbose_name='消息id', default=0)
  1833. detectTime = models.BigIntegerField(verbose_name='设备侦测时间', default=0)
  1834. receiveTime = models.BigIntegerField(verbose_name='接口调用时间', default=0)
  1835. aiTime = models.BigIntegerField(verbose_name='ai识别上传开始时间', default=0)
  1836. aiEndTime = models.BigIntegerField(verbose_name='ai识别结束时间', default=0)
  1837. pushTime = models.BigIntegerField(verbose_name='推送开始时间', default=0)
  1838. pushEndTime = models.BigIntegerField(verbose_name='推送结束时间', default=0)
  1839. picUploadTime = models.BigIntegerField(verbose_name='图片上传开始时间', default=0)
  1840. picUploadEndTime = models.BigIntegerField(verbose_name='图片上传结束结束时间', default=0)
  1841. serverCountTime = models.BigIntegerField(verbose_name='服务器总花时间', default=0)
  1842. appPushTime = models.IntegerField(verbose_name='添加时间', default=0)
  1843. endTime = models.IntegerField(verbose_name='接口结束时间', default=0)
  1844. class Meta:
  1845. db_table = 'ai_process_time'
  1846. verbose_name = 'ai设备服务表'
  1847. verbose_name_plural = verbose_name
  1848. ordering = ('id',)
  1849. class GatewaySubDevice(models.Model):
  1850. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1851. device = models.ForeignKey(Device_Info, to_field='id', default='', on_delete=models.CASCADE,
  1852. verbose_name='关联设备信息id')
  1853. device_type = models.SmallIntegerField(default=0, verbose_name=u'设备类型')
  1854. nickname = models.CharField(default='', max_length=32, verbose_name=u'设备名称')
  1855. ieee_addr = models.CharField(default='', max_length=64, verbose_name=u'长地址')
  1856. src_addr = models.CharField(default='', max_length=16, verbose_name=u'短地址')
  1857. status = models.SmallIntegerField(default=0, verbose_name='状态') # 0:关闭, 1:开启
  1858. created_time = models.IntegerField(default=0, verbose_name='创建时间')
  1859. updated_time = models.IntegerField(default=0, verbose_name='更新时间')
  1860. class Meta:
  1861. db_table = 'gateway_sub_device'
  1862. verbose_name = '网关子设备'
  1863. verbose_name_plural = verbose_name
  1864. class SensorRecord(models.Model):
  1865. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  1866. gateway_sub_device_id = models.IntegerField(default=0, blank=True, verbose_name=u'网关子设备id')
  1867. alarm = models.CharField(default='', max_length=32, verbose_name=u'消息内容')
  1868. event_type = models.SmallIntegerField(default=0, verbose_name=u'消息类型')
  1869. created_time = models.IntegerField(default=0, verbose_name='创建时间')
  1870. class Meta:
  1871. db_table = 'sensor_record'
  1872. verbose_name = '传感器记录'
  1873. verbose_name_plural = verbose_name
  1874. app_label = 'db2'