models.py 63 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193
  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, timezone
  5. from django.utils.encoding import python_2_unicode_compatible
  6. from imagekit.models import ProcessedImageField
  7. from imagekit.processors import ResizeToFill
  8. from Ansjer.config import SERVER_DOMAIN
  9. from django.utils import timezone
  10. class PermissionsManager(models.Manager):
  11. use_in_migrations = True
  12. def get_by_natural_key(self, permName):
  13. return self.get(
  14. permName=permName
  15. )
  16. class RoleManager(models.Manager):
  17. """
  18. The manager for the auth's Role model..
  19. """
  20. use_in_migrations = True
  21. def get_by_natural_key(self, roleName):
  22. return self.get(roleName=roleName)
  23. class UserManager(BaseUserManager):
  24. def create_user(self, username, password, userID, is_active,
  25. user_isValid, **extra_fields):
  26. user = self.model(
  27. username=username,
  28. userID=userID,
  29. is_active=is_active,
  30. user_isValid=user_isValid,
  31. **extra_fields
  32. )
  33. user.set_password(password)
  34. user.save(using=self._db)
  35. role = Role.objects.get(rid=1)
  36. user.role.add(role)
  37. return user
  38. def create_superuser(self, username, password, userID, is_active,
  39. user_isValid, **extra_fields):
  40. # extra_fields.setdefault('is_superuser', is_superuser)
  41. is_superuser = extra_fields.get('is_superuser', None)
  42. if is_superuser != 100 and is_superuser != 1:
  43. raise ValueError('Superuser must have is_superuser=1 or 100.')
  44. return self.create_user(username, password, userID, is_active,
  45. user_isValid, **extra_fields)
  46. @python_2_unicode_compatible
  47. class Permissions(models.Model):
  48. permName = models.CharField(blank=True, null=True, max_length=32, unique=True, verbose_name=u'权限名称')
  49. description = models.CharField(blank=True, null=True, max_length=128, verbose_name=u'描述信息', default='')
  50. objects = PermissionsManager()
  51. def __str__(self):
  52. return "%s" % (
  53. six.text_type(self.description))
  54. class Meta:
  55. ordering = ['permName']
  56. db_table = 'permissions'
  57. verbose_name = u'role permission'
  58. verbose_name_plural = verbose_name
  59. unique_together = (('permName'),)
  60. def natural_key(self):
  61. return (self.permName)
  62. class Role(models.Model):
  63. rid = models.SmallIntegerField(primary_key=True, unique=True, verbose_name=u'用户角色组ID')
  64. roleName = models.CharField(max_length=32, unique=True,
  65. default='User', verbose_name=u'角色名称')
  66. permission = models.ManyToManyField(to='Permissions', blank=True, verbose_name=u'权限', db_table='role_permissions')
  67. Description = models.TextField(blank=True, default='', verbose_name=u'描述信息')
  68. objects = RoleManager()
  69. class Meta:
  70. ordering = ['roleName']
  71. db_table = 'role'
  72. verbose_name = u'用户角色'
  73. verbose_name_plural = verbose_name
  74. def __str__(self):
  75. return self.roleName
  76. def natural_key(self):
  77. return (self.roleName,)
  78. def get_all_permission(self):
  79. perms = self.permission.all()
  80. permslist = []
  81. if self.rid == 100:
  82. perms = Permissions.objects.all()
  83. for perm in perms:
  84. permslist.append(perm.permName)
  85. return permslist
  86. else:
  87. permlist_tmp = []
  88. for perm in perms:
  89. permlist_tmp.append(perm.permName)
  90. permSet = set(permlist_tmp)
  91. permslist = list(permSet)
  92. permslist.sort()
  93. return permslist
  94. class Device_User(AbstractBaseUser):
  95. userID = models.CharField(blank=True, max_length=32, primary_key=True,
  96. verbose_name=u'用户ID', unique=True)
  97. role = models.ManyToManyField(to='Role', blank=True, verbose_name=u'用户角色', db_table='user_role')
  98. username = models.CharField(max_length=64, db_index=True, verbose_name=u'用户名', default='', blank=True)
  99. password = models.CharField(max_length=128, verbose_name=u'密码')
  100. userEmail = models.EmailField(max_length=64, verbose_name=u'邮箱', default='', blank=True)
  101. # 实际的路径就是 MEDIA_ROOT/Image/filename,所以可用upload_to来指定文件存放的前缀路径
  102. userIconPath = ProcessedImageField(blank=True, upload_to='User/Images/', default='static/User/default.png',
  103. verbose_name=u'头像',
  104. # 图片将处理成85x85的尺寸
  105. processors=[ResizeToFill(85, 85)], )
  106. userIconUrl = models.URLField(blank=True, max_length=128, default=SERVER_DOMAIN
  107. + 'account/getAvatar/User/defaultUser.png')
  108. NickName = models.CharField(blank=True, max_length=64, default='', verbose_name=u'用户昵称')
  109. is_superuser = models.IntegerField(blank=True, default=0, verbose_name=u'用户类型')
  110. is_active = models.BooleanField(blank=True, default=False, verbose_name=u'用户活动状态')
  111. data_joined = models.DateTimeField(blank=True, verbose_name=u'加入时间', auto_now_add=True)
  112. last_login = models.DateTimeField(blank=True, verbose_name='u最后登录时间', auto_now=True)
  113. user_isValid = models.BooleanField(blank=True, default=False, verbose_name=u'用户有效性', help_text=u'是否是认证通过的用户')
  114. online = models.BooleanField(blank=True, default=False, verbose_name=u'用户登录状态')
  115. machine_code = models.CharField(blank=True, max_length=128, default='', verbose_name=u'机械码')
  116. language = models.CharField(blank=True, max_length=16, default='en', verbose_name=u'语言地区')
  117. # 手机注册增加字段
  118. phone = models.CharField(max_length=16, verbose_name=u'手机号', default='', blank=True)
  119. fingerprint_enable = models.SmallIntegerField(default=0, verbose_name=u'是否开启了指纹登录') # 0:未开启,1:已开启
  120. fingerprint_key = models.CharField(max_length=128, default='', verbose_name=u'客户端用于解码的密钥等信息')
  121. is_local = models.BooleanField(blank=True, default=False, verbose_name=u'是否是本地登录用户') # False:账号登录,1:本地登录
  122. subscribe_email = models.SmallIntegerField(default=0, verbose_name=u'是否订阅营销邮件') # 0:未订阅,1:订阅,2:不订阅
  123. objects = UserManager()
  124. USERNAME_FIELD = 'userID' # 必须有一个唯一标识
  125. REQUIRED_FIELDS = ['is_superuser'] # 创建superuser时的必须字段
  126. class Meta:
  127. ordering = ('-data_joined',)
  128. verbose_name = u'用户信息'
  129. db_table = 'device_user'
  130. get_latest_by = 'last_login'
  131. def __str__(self):
  132. return self.username
  133. def get_role_id(self):
  134. rids = []
  135. roles = self.role.all()
  136. for role in roles:
  137. rids.append(role.rid)
  138. return rids
  139. def get_all_permission(self):
  140. roles = self.role.all()
  141. perms = self.permission.all()
  142. permslist = []
  143. for role in roles:
  144. if role.rid == 100:
  145. perms = Permissions.objects.all()
  146. for perm in perms:
  147. permslist.append(perm.permName)
  148. return permslist
  149. for perm in perms:
  150. permslist.append(perm.permName)
  151. permSet = set(permslist)
  152. for role in roles:
  153. permlist_tmp = []
  154. for perm in role.permission.all():
  155. permlist_tmp.append(perm.permName)
  156. permSet_tmp = set(permlist_tmp)
  157. permSet = permSet.union(permSet_tmp)
  158. permslist = list(permSet)
  159. permslist.sort()
  160. return permslist
  161. @property
  162. def is_staff(self):
  163. return self.is_superuser
  164. # 设备表是建项目开发者设计的,自己看着办
  165. # 谢谢提醒!我选择凉拌。
  166. # 我选择狗带
  167. class Device_Info(models.Model):
  168. id = models.CharField(blank=True, max_length=32, primary_key=True)
  169. userID = models.ForeignKey(Device_User, blank=True, to_field='userID', on_delete=models.CASCADE)
  170. NickName = models.CharField(blank=True, max_length=32, verbose_name=u'设备名称')
  171. UID = models.CharField(blank=True, max_length=32, verbose_name=u'设备UID', default='')
  172. SID = models.CharField(blank=True, max_length=32, verbose_name=u'服务器ID', default='')
  173. View_Account = models.CharField(blank=True, max_length=32, verbose_name=u'设备用户名称', default='')
  174. View_Password = models.CharField(blank=True, max_length=32, verbose_name=u'设备密码', default='')
  175. AudioFormat = models.IntegerField(blank=True, default=1, verbose_name=u'初始化影像')
  176. EventNotification = models.IntegerField(blank=True, verbose_name=u'报警类型', default=0)
  177. ChannelIndex = models.IntegerField(blank=True, verbose_name=u'通道号', default=0)
  178. Online = models.BooleanField(blank=True, default=False, verbose_name=u'设备是否在线')
  179. mMonitorIndex = models.IntegerField(blank=True, default=-1)
  180. Type = models.IntegerField(blank=True, verbose_name='设备类型')
  181. DebugMode = models.IntegerField(blank=True, verbose_name=u'调试模式', default=0)
  182. NotificationMode = models.IntegerField(blank=True, verbose_name=u'是否报警', default=0)
  183. qvgaLevel = models.BooleanField(blank=True, verbose_name=u'SD与HD画面', default=0,
  184. help_text=u'0代表:SD、1代表:HD')
  185. isShare = models.BooleanField(blank=True, verbose_name=u'共享设备',
  186. help_text=u'是否为共享获取的设备', default=False)
  187. primaryUserID = models.CharField(blank=True, verbose_name='主用户id', max_length=32, default='')
  188. primaryMaster = models.CharField(max_length=64, verbose_name=u'主用户名', default='')
  189. vodPrimaryUserID = models.CharField(blank=True, verbose_name='云存主用户id', max_length=32, default='')
  190. vodPrimaryMaster = models.CharField(max_length=64, verbose_name=u'云存主用户名', default='')
  191. data_joined = models.DateTimeField(blank=True, verbose_name=u'设备添加时间', auto_now_add=True)
  192. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True, null=True)
  193. ip = models.CharField(blank=True, max_length=20, default='', verbose_name=u'设备区域ip')
  194. area = models.CharField(blank=True, max_length=100, default='', verbose_name=u'设备区域area')
  195. # ios要求新增字段
  196. version = models.CharField(blank=True, max_length=20, default='', verbose_name=u'版本号')
  197. iSNotification = models.BooleanField(blank=True, verbose_name=u'报警通知 0:关闭,1:开启)', default=False)
  198. isVod = models.SmallIntegerField(blank=True, default=0, verbose_name='是否支持云存') # 是否支持云存设备
  199. isExist = models.SmallIntegerField(blank=True, default=1, verbose_name='是否被删除') # 是否被删除了(需主用户交互) 1存在,0不存在,2设备被重置
  200. ###
  201. REQUIRED_FIELDS = []
  202. def __str__(self):
  203. return self.NickName
  204. def model_to_dict(self, fields=None, exclude=None):
  205. opts = self._meta
  206. data = {}
  207. for f in chain(opts.concrete_fields, opts.private_fields, opts.many_to_many):
  208. if not getattr(f, 'editable', False):
  209. continue
  210. if fields and f.name not in fields:
  211. continue
  212. if exclude and f.name in exclude:
  213. continue
  214. data[f.name] = f.value_from_object(self)
  215. return data
  216. class Meta:
  217. db_table = 'device_info'
  218. ordering = ('-data_joined',)
  219. verbose_name = u'用户设备信息表'
  220. verbose_name_plural = verbose_name
  221. class Access_Log(models.Model):
  222. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  223. user = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'用户')
  224. operation = models.CharField(max_length=100, db_index=True, default='', blank=True, verbose_name=u'操作')
  225. ip = models.CharField(max_length=100, default='', db_index=True, blank=True, verbose_name=u'访问ip地址')
  226. url = models.CharField(max_length=150, default='', blank=True, verbose_name=u'访问路径')
  227. status = models.IntegerField(default=0, blank=True, verbose_name=u'状态')
  228. time = models.DateTimeField(null=True, blank=True, db_index=True, verbose_name=u'访问时间')
  229. content = models.TextField(blank=True, default='', verbose_name=u'参数内容')
  230. class Meta:
  231. db_table = 'access_log'
  232. verbose_name = u'访问日志表'
  233. verbose_name_plural = verbose_name
  234. class Equipment_Info(models.Model):
  235. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  236. devUid = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'设备ID')
  237. devNickName = models.CharField(blank=True, max_length=32, default='', verbose_name=u'设备昵称')
  238. Channel = models.IntegerField(default=1, blank=True, verbose_name=u'设备通道')
  239. eventType = models.IntegerField(default=0, blank=True, verbose_name=u'事件类型')
  240. status = models.BooleanField(blank=True, default=False, verbose_name=u'事件状态')
  241. alarm = models.CharField(blank=True, max_length=256, verbose_name=u'报警信息')
  242. eventTime = models.CharField(blank=True, default='', max_length=16, verbose_name=u'设备报警时间')
  243. receiveTime = models.CharField(blank=True, default='', max_length=16, verbose_name=u'接收到报警时间')
  244. userID_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户ID')
  245. is_st = models.SmallIntegerField(default=0, verbose_name='是否截图') # 0 否,1 是图,2,视频
  246. # message_id = models.CharField(blank=True, max_length=32, default='', verbose_name='第三方推送服务器返回的id')
  247. # push_type = models.SmallIntegerField(blank=True, default=0, verbose_name='第三方推送服务器标志。0:APNS推送,1:谷歌推送,2:极光推送')
  248. # push_server_status = models.IntegerField(blank=True, default=200, verbose_name='是否成功推送到第三方服务器。200:成功,other:失败')
  249. # push_device_status = models.SmallIntegerField(blank=True, default=-1, verbose_name='是否成功推送到目标设备。0:失败,1:成功')
  250. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  251. def __str__(self):
  252. return self.id
  253. class Meta:
  254. db_table = 'equipment_info'
  255. verbose_name = u'设备信息推送表'
  256. verbose_name_plural = verbose_name
  257. ordering = ('-id',)
  258. app_label = "db2"
  259. class StatResModel(models.Model):
  260. id = models.AutoField(primary_key=True, verbose_name='自动ID')
  261. name = models.CharField(default='', max_length=120, verbose_name='图片名称', unique=True)
  262. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  263. def __str__(self):
  264. return self.name
  265. class Meta:
  266. db_table = 'statres'
  267. verbose_name = '静态资源表'
  268. verbose_name_plural = verbose_name
  269. ordering = ('id',)
  270. class FeedBackModel(models.Model):
  271. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  272. userID = models.ForeignKey(Device_User, null=True, blank=True, to_field='userID', on_delete=models.CASCADE)
  273. type = models.SmallIntegerField(default=0, verbose_name='反馈类型') # 【0:产品建议,1:功能异常,2:安全问题】
  274. status = models.SmallIntegerField(default=0, verbose_name='状态:0未解决/解决')
  275. content = models.TextField(blank=True, null=True, verbose_name=u'反馈描述')
  276. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  277. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  278. FS = models.ManyToManyField(to='StatResModel', blank=True, verbose_name=u'用户反馈关联资源',
  279. db_table='fb_res')
  280. app = models.CharField(max_length=8, default='', verbose_name='类型') # [ios,android]
  281. phone_model = models.CharField(max_length=64, default='', verbose_name='手机型号') # [小米,android]
  282. os_version = models.CharField(max_length=16, default='', verbose_name='系统版本')
  283. uid = models.CharField(max_length=20, default='', verbose_name='设备uid')
  284. product_type = models.CharField(max_length=32, default='', verbose_name='设备uid')
  285. app_version = models.CharField(max_length=32, default='', verbose_name='app版本信息')
  286. appBundleId = models.CharField(max_length=32, default='', verbose_name='app版本appBundleId')
  287. email = models.CharField(max_length=32, default='', verbose_name='app版本email')
  288. score = models.CharField(max_length=32, default='0', verbose_name='评分--星星数')
  289. def __str__(self):
  290. return self.id
  291. class Meta:
  292. db_table = 'feedback'
  293. verbose_name = u'用户反馈信息表'
  294. verbose_name_plural = verbose_name
  295. ordering = ('-id',)
  296. class User_Brand(models.Model):
  297. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  298. # 关联用户
  299. userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE)
  300. deviceSupplier = models.CharField(max_length=32, default='', verbose_name='(必填)设备供应商 string (例:华为、小米...)')
  301. deviceModel = models.CharField(max_length=64, default='', verbose_name='(必填)设备型号 string @mock=HM NOTE 1TD')
  302. osType = models.CharField(max_length=32, default='', verbose_name='(必填)操作系统名称 string @mock=Android')
  303. osVersion = models.CharField(max_length=32, default='', verbose_name='(必填)操作系统版本号 string @mock=4.0')
  304. country = models.CharField(max_length=200, default='', verbose_name='国家')
  305. province = models.CharField(max_length=150, default='', verbose_name='省')
  306. city = models.CharField(max_length=132, default='', verbose_name='市')
  307. area = models.CharField(max_length=132, default='', verbose_name='区')
  308. street = models.CharField(max_length=132, default='', verbose_name='街道')
  309. longitude = models.CharField(max_length=30, default='', verbose_name='经度')
  310. latitude = models.CharField(max_length=30, default='', verbose_name='纬度')
  311. appId = models.CharField(max_length=50, default='', verbose_name='appid_值')
  312. status = models.IntegerField(default=0, verbose_name='传国家省市信息过来就为状态:1 ,不传就为状态:0')
  313. ip = models.CharField(blank=True, max_length=20, default='', verbose_name=u'区域ip')
  314. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  315. def __str__(self):
  316. return self.id
  317. class Meta:
  318. db_table = 'user_brand'
  319. verbose_name = u'用户登录手机端手机品牌统计表'
  320. verbose_name_plural = verbose_name
  321. ordering = ('id',)
  322. # 存储通表
  323. class VodBucketModel(models.Model):
  324. id = models.AutoField(primary_key=True, verbose_name='主键')
  325. bucket = models.CharField(max_length=30, verbose_name='设备UID')
  326. storeDay = models.IntegerField(default=0, verbose_name='存储生命周期(天)')
  327. content = models.TextField(verbose_name='描述', default='')
  328. endpoint = models.CharField(max_length=125, default='', verbose_name='存储节点')
  329. area = models.CharField(max_length=16, default='', verbose_name='区域')
  330. region = models.CharField(max_length=16, default='', verbose_name='regionID')
  331. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  332. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  333. mold = models.SmallIntegerField(default=0, verbose_name='存储区域类型') # 0:国内阿里 1:国外aws
  334. def __str__(self):
  335. return self.id
  336. class Meta:
  337. db_table = 'vod_bucket'
  338. verbose_name = u'存储通信息'
  339. verbose_name_plural = verbose_name
  340. ordering = ('-id',)
  341. class Store_Meal(models.Model):
  342. id = models.AutoField(primary_key=True, verbose_name=u'自增ID')
  343. title = models.CharField(blank=True, max_length=32, verbose_name=u'标题')
  344. currency = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'货币符号')
  345. symbol = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'符号')
  346. price = models.CharField(blank=True, max_length=32, verbose_name=u'价格')
  347. virtual_price = models.CharField(blank=True, max_length=32, verbose_name=u'虚拟价格')
  348. is_discounts = models.SmallIntegerField(default=0, verbose_name=u'该套餐是否有优惠 [0=否,1是]') # 0没有;1有
  349. discount_price = models.CharField(blank=True, max_length=32, verbose_name=u'第二年优惠价格')
  350. discount_content = models.CharField(blank=True, max_length=320, verbose_name=u'优惠信息描述')
  351. day = models.IntegerField(default=0, blank=True, verbose_name=u'云存录像保存天数(循环)') # 7,30,180,360
  352. expire = models.IntegerField(default=0, blank=True, verbose_name=u'有效期') #单位月
  353. content = models.TextField(blank=True, null=True, verbose_name=u'描述')
  354. add_time = models.DateTimeField(blank=True, null=True, verbose_name=u'加入时间', auto_now_add=True)
  355. # type = models.SmallIntegerField(default=0, verbose_name='付款类型') # 0是paypal,1为支付宝
  356. pay_type = models.ManyToManyField(to='Pay_Type', verbose_name='付款类型', db_table='store_meal_pay')
  357. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  358. bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE,
  359. default=1, verbose_name='存储空间')
  360. commodity_type = models.SmallIntegerField(default=0, verbose_name='云存储套餐类型') # 0:事件型 1:连续型
  361. commodity_code = models.CharField(default='', max_length=32, verbose_name='套餐规格码')
  362. # lang = models.CharField(default='', max_length=20, verbose_name='语言/国家')
  363. def __str__(self):
  364. return self.id
  365. class Meta:
  366. db_table = 'store_meal'
  367. verbose_name = u'存储套餐'
  368. verbose_name_plural = verbose_name
  369. ordering = ('id',)
  370. class Pay_Type(models.Model):
  371. id = models.AutoField(primary_key=True, verbose_name=u'自增ID')
  372. payment = models.CharField(max_length=32, verbose_name=u'支付方式')
  373. def __str__(self):
  374. return self.id
  375. class Meta:
  376. db_table = 'pay_type'
  377. verbose_name = u'付款类型'
  378. verbose_name_plural = verbose_name
  379. ordering = ('id',)
  380. class Equipment_Version(models.Model):
  381. eid = models.CharField(blank=True, max_length=32, primary_key=True)
  382. ESN = models.CharField(blank=True, max_length=32, verbose_name=u'设备规格名称')
  383. code = models.CharField(blank=True, max_length=64, verbose_name=u'设备规格代码')
  384. version = models.CharField(blank=True, max_length=64, verbose_name=u'设备版本')
  385. softwareVersion = models.CharField(blank=True, max_length=32, verbose_name=u'软件版本')
  386. chipModelList2Code = models.CharField(max_length=32, blank=True, verbose_name=u'主芯片码')
  387. channel = models.IntegerField(blank=True, verbose_name=u'通道数')
  388. resolutionRatio = models.IntegerField(blank=True, verbose_name=u'分辨率')
  389. type = models.CharField(blank=True, max_length=16, verbose_name=u'设备机型')
  390. companyCode = models.CharField(blank=True, max_length=128, verbose_name=u'用户公司名称')
  391. data_joined = models.DateTimeField(blank=True, verbose_name=u'加入时间', auto_now_add=True)
  392. fileSize = models.IntegerField(blank=True, verbose_name=u'文件总大小')
  393. filePath = models.CharField(blank=True, max_length=256, verbose_name=u'升级文件路径')
  394. Description = models.TextField(blank=True, default='', verbose_name=u'描述信息')
  395. fileMd5 = models.CharField(blank=True, max_length=32, default='', verbose_name=u'上传文件MD5加密')
  396. status = models.BooleanField(blank=True, default=True, verbose_name=u'是否开启更新状态')
  397. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  398. lang = models.CharField(blank=True, default='en', max_length=32, verbose_name=u'ota包内置语言')
  399. mci = models.CharField(default='', blank=True, max_length=10, verbose_name='设备类型')
  400. img = models.CharField(max_length=300, blank=True, default='', verbose_name=u'图片路径')
  401. max_ver = models.CharField(default='', max_length=16, verbose_name='最大版本号')
  402. def __str__(self):
  403. return self.eid
  404. class Meta:
  405. verbose_name = '设备版本信息'
  406. ordering = ('-data_joined',)
  407. db_table = 'equipment_version'
  408. class App_Info(models.Model):
  409. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  410. appBundleId = models.CharField(blank=True, max_length=32, verbose_name=u'appID')
  411. appName = models.CharField(blank=True, max_length=32, verbose_name=u'app名称')
  412. systemLanguage = models.CharField(blank=True, max_length=32, verbose_name=u'系统语言')
  413. newAppversion = models.CharField(blank=True, max_length=12, verbose_name=u'系统版本')
  414. minAppversion = models.CharField(default='', blank=True, max_length=12, verbose_name=u'最小系统版本')
  415. bundleVersion = models.CharField(blank=True, max_length=12, verbose_name=u'项目版本')
  416. content = models.TextField(blank=True, default='', verbose_name=u'更新内容')
  417. app_type = models.IntegerField(default=0, blank=True, verbose_name=u'app类型') # ios 1,android 2
  418. add_time = models.DateTimeField(blank=True, null=True, verbose_name=u'加入时间', auto_now_add=True)
  419. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  420. downloadLink = models.CharField(max_length=300, blank=True, default='', verbose_name='升级')
  421. img = models.CharField(default='', max_length=128, verbose_name='图片路径')
  422. def __str__(self):
  423. return self.id
  424. class Meta:
  425. db_table = 'app_info'
  426. verbose_name = u'app信息表'
  427. verbose_name_plural = verbose_name
  428. ordering = ('id',)
  429. class App_Colophon(models.Model):
  430. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  431. app_id = models.ForeignKey(App_Info, to_field='id', on_delete=models.CASCADE, verbose_name='appid编号', blank=True,
  432. default=1)
  433. lang = models.CharField(blank=True, max_length=32, verbose_name=u'系统语言')
  434. newApp_version = models.CharField(blank=True, max_length=12, verbose_name=u'系统版本')
  435. content = models.TextField(blank=True, default='', verbose_name=u'更新内容')
  436. version_time = models.IntegerField(default=0, blank=True, verbose_name=u'版本更新的时间')
  437. def __str__(self):
  438. return self.id
  439. class Meta:
  440. db_table = 'app_colophon'
  441. verbose_name = u'app信息表的记录关联到App_Info'
  442. verbose_name_plural = verbose_name
  443. ordering = ('id',)
  444. class Order_Model(models.Model):
  445. orderID = models.CharField(blank=True, max_length=20, primary_key=True, verbose_name=u'订单id')
  446. trade_no = models.CharField(blank=True, max_length=32, default='', verbose_name='第三方订单号')
  447. # 订单关联用户
  448. userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE)
  449. UID = models.CharField(max_length=20, verbose_name='设备UID')
  450. channel = models.SmallIntegerField(default=0, verbose_name=u'通道数')
  451. desc = models.CharField(max_length=50, default='', verbose_name='商品描述')
  452. price = models.CharField(default='', max_length=16, verbose_name='价格')
  453. currency = models.CharField(blank=True, default='$', max_length=32, verbose_name=u'货币')
  454. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  455. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  456. # endTime = models.IntegerField(verbose_name='结束时间', default=0)
  457. isSelectDiscounts = models.SmallIntegerField(default=0, verbose_name=u'用户是否选择了第二年优惠 [0=否,1是]')
  458. status = models.SmallIntegerField(default=0, verbose_name='付款状态') # 0:待支付,1:成功,2:取消,3:已退款, 9:处理中,10:付款失败
  459. payType = models.SmallIntegerField(default=0, verbose_name='付款类型0:paypal,1:alipay')
  460. payTime = models.IntegerField(verbose_name='支付成功时间', default=0)
  461. rank = models.ForeignKey(Store_Meal, to_field='id', default='', on_delete=models.CASCADE, verbose_name='套餐类型')
  462. nickname = models.CharField(default='', max_length=64, verbose_name='设备昵称')
  463. uid_bucket_id = models.IntegerField(default=0, verbose_name='关联uid_bucket的字段')
  464. commodity_type = models.SmallIntegerField(default=0, verbose_name='云存储套餐类型')
  465. commodity_code = models.CharField(default='', max_length=32, verbose_name='套餐规格码')
  466. pay_url = models.CharField(max_length=2000, default='', verbose_name='支付url')
  467. paypal = models.CharField(max_length=500, null=True, blank=True, verbose_name='支付批准url')
  468. def __str__(self):
  469. return self.orderID
  470. class Meta:
  471. db_table = 'orders'
  472. verbose_name = u'订单信息表'
  473. verbose_name_plural = verbose_name
  474. ordering = ('-orderID',)
  475. class VodHlsModel(models.Model):
  476. id = models.AutoField(primary_key=True, verbose_name='回放列表主键')
  477. uid = models.CharField(max_length=20, verbose_name='设备UID', db_index=True)
  478. channel = models.SmallIntegerField(default=0, verbose_name='通道')
  479. time = models.IntegerField(verbose_name='播放列表名字时间戳', default=0, db_index=True)
  480. endTime = models.IntegerField(verbose_name='云存储删除时间(周期)', default=0)
  481. sec = models.IntegerField(verbose_name='秒数', default=0)
  482. bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, default=1,
  483. verbose_name='存储空间')
  484. fg = models.CharField(max_length=20,verbose_name='ts个数,时间描述片段数') # 阿里为时间片段数,亚马逊为一个32bit整型,前28bit代表ts文件的时长
  485. def __str__(self):
  486. return self.id
  487. class Meta:
  488. db_table = 'vod_hls'
  489. verbose_name = u'云存回放信息表'
  490. verbose_name_plural = verbose_name
  491. ordering = ('-id',)
  492. class OssCrdModel(models.Model):
  493. id = models.AutoField(primary_key=True, verbose_name='主键')
  494. uid = models.CharField(max_length=20, verbose_name='设备UID')
  495. channel = models.SmallIntegerField(default=0, verbose_name='通道')
  496. data = models.TextField(verbose_name='设备sts')
  497. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  498. bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, default=1,
  499. verbose_name='存储空间')
  500. def __str__(self):
  501. return self.id
  502. class Meta:
  503. db_table = 'osscrd'
  504. verbose_name = u'设备证书'
  505. verbose_name_plural = verbose_name
  506. ordering = ('-id',)
  507. class StsCrdModel(models.Model):
  508. id = models.AutoField(primary_key=True, verbose_name='主键')
  509. uid = models.CharField(max_length=20, verbose_name='设备UID')
  510. channel = models.SmallIntegerField(default=0, verbose_name='通道')
  511. data = models.TextField(verbose_name='设备sts')
  512. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  513. bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, default=1,
  514. verbose_name='存储空间')
  515. type = models.SmallIntegerField(default=0,verbose_name='sts类型') # 0:阿里云,1:s3
  516. def __str__(self):
  517. return self.id
  518. class Meta:
  519. db_table = 'stscrd'
  520. verbose_name = u'设备证书'
  521. verbose_name_plural = verbose_name
  522. ordering = ('-id',)
  523. class UID_Bucket(models.Model):
  524. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  525. uid = models.CharField(max_length=20, verbose_name='设备UID')
  526. channel = models.SmallIntegerField(default=0, verbose_name='通道')
  527. bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, verbose_name='存储空间')
  528. status = models.SmallIntegerField(default=0, verbose_name='状态[0:开启,1:关闭]')
  529. endTime = models.BigIntegerField(verbose_name='套餐结束时间', db_index=True, default=0)
  530. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  531. updateTime = models.BigIntegerField(verbose_name='更新时间', default=0)
  532. use_status = models.IntegerField(verbose_name='使用状态[1:使用中,2已过期]', default=0)
  533. has_unused = models.SmallIntegerField(default=0, verbose_name='是否拥有其它未使用的套餐[0:否,1:是]')
  534. class Meta:
  535. db_table = 'vod_uid_bucket'
  536. verbose_name = '设备关联套餐表'
  537. verbose_name_plural = verbose_name
  538. ordering = ('id',)
  539. class Unused_Uid_Meal(models.Model):
  540. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  541. uid = models.CharField(max_length=20, verbose_name='设备UID')
  542. channel = models.SmallIntegerField(default=0, verbose_name='通道')
  543. bucket = models.ForeignKey(VodBucketModel, blank=True, to_field='id', on_delete=models.CASCADE, verbose_name='存储空间')
  544. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  545. expire = models.IntegerField(verbose_name='存储桶存储时长[月份]', default=0)
  546. num = models.IntegerField(verbose_name='个数', default=0)
  547. # effect_time = models.BigIntegerField(verbose_name='生效时间', db_index=True, default=0)
  548. # uid_bucket = models.ForeignKey(UID_Bucket, blank=True, to_field='id', on_delete=models.CASCADE, default=0,
  549. # verbose_name='uid_bucket关联')
  550. class Meta:
  551. db_table = 'unused_uid_Meal'
  552. verbose_name = '未使用的设备关联套餐表'
  553. verbose_name_plural = verbose_name
  554. ordering = ('id',)
  555. class UID_Preview(models.Model):
  556. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  557. uid = models.CharField(default='', max_length=20, db_index=True, verbose_name='设备UID')
  558. channel = models.SmallIntegerField(verbose_name=u'通道号', default=0)
  559. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  560. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  561. class Meta:
  562. db_table = 'uid_preview'
  563. verbose_name = '设备预览图'
  564. verbose_name_plural = verbose_name
  565. ordering = ('id',)
  566. # 系统发送信息新到用户
  567. class SysMsgModel(models.Model):
  568. id = models.AutoField(primary_key=True, verbose_name='自增id')
  569. userID_id = models.CharField(default='', db_index=True, blank=True, max_length=32, verbose_name=u'用户ID')
  570. msg = models.TextField(blank=True, default='', verbose_name=u'发送内容')
  571. status = models.SmallIntegerField(verbose_name='是否已读', default=0) # 0:否,1:是
  572. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  573. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  574. eventType = models.IntegerField(verbose_name='消息类型', default=0) # 默认系统消息类型,0系统消息,1 ipcamera消息
  575. uid = models.CharField(default='', max_length=20, db_index=True, verbose_name='设备UID')
  576. class Meta:
  577. db_table = 'sys_msg'
  578. verbose_name = '系统消息'
  579. verbose_name_plural = verbose_name
  580. ordering = ('-id',)
  581. app_label = "db2"
  582. # 设备推送重构
  583. # 设备配置表,新
  584. class UidSetModel(models.Model):
  585. id = models.AutoField(primary_key=True, verbose_name=u'自增标记ID')
  586. uid = models.CharField(max_length=20, db_index=True, unique=True, verbose_name='设备UID')
  587. channel = models.SmallIntegerField(default=0, verbose_name='通道数量') #
  588. detect_status = models.SmallIntegerField(default=0, verbose_name='推送开关') # 状态[0:关闭,1:开启,2:用户解绑]
  589. detect_interval = models.IntegerField(verbose_name='推送间隔', default=60) # 秒
  590. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  591. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  592. ucode = models.CharField(max_length=32, verbose_name='设备产品码', default='')
  593. version = models.CharField(max_length=32, verbose_name='设备版本', default='')
  594. p2p_region = models.CharField(max_length=16, verbose_name='设备p2p区域', default='ALL') # ALL CN EU US
  595. cloud_vod = models.SmallIntegerField(default=2, verbose_name='云存开关') # 0,关闭,1开启,2,不支持
  596. tz = models.CharField(default='', max_length=16, verbose_name ='设备时区') # +8
  597. video_code = models.SmallIntegerField(default=0, verbose_name='编码类型') # 0:264,1:265
  598. nickname = models.CharField(default='', max_length=64, verbose_name='设备昵称')
  599. ip = models.CharField(max_length=20, default='', verbose_name=u'设备ip')
  600. # 设备重置后第一次启动时间
  601. is_alexa = models.IntegerField(default=0, verbose_name='是否支持alexa') # 0为不支持,1为支持,2为开启alexa发现
  602. detect_group = models.CharField(default='', max_length=32, verbose_name=u'检测类型')
  603. pwd = models.CharField(max_length=32, default='', verbose_name=u'设备密码') # 暂时是预留字段
  604. resetTime = models.IntegerField(default=0, verbose_name='设备重置时间')
  605. region_alexa = models.CharField(max_length=8, verbose_name='设备alexa区域', default='ALL') # ALL CN EU US
  606. deviceModel = models.CharField(blank=True, max_length=64, default='', verbose_name=u'设备型号')
  607. TimeZone = models.CharField(blank=True, max_length=50, default='', verbose_name=u'时区')
  608. TimeStatus = models.SmallIntegerField(default=0, verbose_name='同步手机时间开关。0:关闭,1:开启')
  609. SpaceUsable = models.CharField(blank=True, max_length=20, default='', verbose_name=u'可用空间')
  610. SpaceSum = models.CharField(blank=True, max_length=20, default='', verbose_name=u'总空间')
  611. MirrorType = models.IntegerField(blank=True, default=0, verbose_name=u'镜像类型 0:关闭镜像,1:上下镜像,2:左右镜像,3:上下左右镜像')
  612. RecordType = models.IntegerField(blank=True, default=0, verbose_name=u'录像模式(0:关闭,1:全是录像,3:报警录像)')
  613. OutdoorModel = models.IntegerField(blank=True, default=0, verbose_name=u'室外模式 0:关闭,1:开启')
  614. WIFIName = models.CharField(blank=True, max_length=50, default='', verbose_name=u'无线名称')
  615. isDetector = models.SmallIntegerField(default=0, verbose_name=u'侦测开关0:关闭,1:开启')
  616. DetectorRank = models.IntegerField(default=0, verbose_name=u'侦测灵敏度 0:低,1:中,2:高,3:最高')
  617. is_human = models.IntegerField(default=0, verbose_name='是否支持人形追踪。0:不支持,1:支持')
  618. is_custom_voice = models.IntegerField(default=0, verbose_name='是否支持自定义语音。0:不支持,1:支持')
  619. double_wifi = models.IntegerField(default=0, verbose_name='是否支持双频wifi。0:不支持,1:支持')
  620. class Meta:
  621. db_table = 'uid_set'
  622. verbose_name = u'设备配置表'
  623. verbose_name_plural = verbose_name
  624. ordering = ('id',)
  625. # 设备关联用户推送
  626. class UidPushModel(models.Model):
  627. id = models.AutoField(primary_key=True, verbose_name='自增id')
  628. userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE)
  629. uid_set = models.ForeignKey(UidSetModel, to_field='id', on_delete=models.CASCADE)
  630. appBundleId = models.CharField(blank=True, max_length=32, verbose_name=u'appID')
  631. app_type = models.IntegerField(default=0, verbose_name=u'app类型 1:ios,2:安卓')
  632. push_type = models.IntegerField(default=0, verbose_name=u'推送类型') # 0,apns 1,安卓gcm 2,极光
  633. token_val = models.CharField(default='', max_length=160, verbose_name=u'设备验证令牌')
  634. m_code = models.CharField(default='', max_length=64, verbose_name='手机唯一标识')
  635. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  636. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  637. lang = models.CharField(max_length=8, verbose_name='推送语言类型', default='en') # en英文 cn中文
  638. tz = models.CharField(max_length=8, verbose_name='utc时区', default='0')
  639. class Meta:
  640. db_table = 'uid_push'
  641. verbose_name = '设备绑定'
  642. verbose_name_plural = verbose_name
  643. ordering = ('-id',)
  644. # 设备通道配置
  645. class UidChannelSetModel(models.Model):
  646. id = models.AutoField(primary_key=True, verbose_name='自增id')
  647. uid = models.ForeignKey(UidSetModel, to_field='id', on_delete=models.CASCADE)
  648. channel = models.IntegerField(default=1, verbose_name='通道号')
  649. pir_audio = models.SmallIntegerField(default=0, verbose_name='pir声音。0:关闭,1:开启')
  650. mic_audio = models.SmallIntegerField(default=0, verbose_name='mic声音。0:关闭,1:开启')
  651. battery_status = models.SmallIntegerField(default=0, verbose_name='低电量提醒状态。0:关闭,1:开启')
  652. battery_level = models.SmallIntegerField(default=0, verbose_name='低电量提醒级别。0: 低于10%;1:低于25%;2:低于50%;3:低于75%')
  653. sleep_status = models.SmallIntegerField(default=0, verbose_name='是否开启【休眠通知】。0:关闭;1:开启')
  654. sleep_time = models.SmallIntegerField(default=0, verbose_name='摄像机进入休眠时间。0:不休眠;1:10秒;2:20秒;3:30秒')
  655. light_night_model = models.IntegerField(default=0, verbose_name='夜视模式') # 0:全彩模式,1:黑白模式,2:智能夜视模式
  656. light_alarm_type = models.IntegerField(default=0, verbose_name='警报人形类型') # 0为人形,1为移动,3是人形和移动侦测0x0f
  657. light_alarm_level = models.IntegerField(default=0,
  658. verbose_name='声光报警级别') # 0: 关闭,1:强烈声光告警,2:轻微声光告警,3: 强烈声告警,4:轻微声告警,5:强烈光告警
  659. light_alarm_man_en = models.IntegerField(default=0, verbose_name='人为告警状态') # 0:关,1:开
  660. light_alarm_vol = models.IntegerField(default=0, verbose_name='报警音量') # 音量值0-100
  661. light_long_light = models.IntegerField(default=0, verbose_name='长亮')
  662. voice_prompt_status = models.SmallIntegerField(default=0, verbose_name='个性语音提示快关。0:关闭,1:开启')
  663. voice_prompt_enter = models.IntegerField(default=0, verbose_name='进入铃声id')
  664. voice_prompt_leave = models.IntegerField(default=0, verbose_name='离开铃声id')
  665. voice_prompt_intelligent_mute = models.SmallIntegerField(default=0, verbose_name='智能静音。0:关闭,1:开启')
  666. voice_start_x = models.FloatField(default=0, verbose_name='起始坐标的x')
  667. voice_start_y = models.FloatField(default=18, verbose_name='起始坐标的y')
  668. voice_end_x = models.FloatField(default=44, verbose_name='结束坐标的x')
  669. voice_end_y = models.FloatField(default=18, verbose_name='结束坐标的y')
  670. voice_start_time = models.IntegerField(default=0, verbose_name='语音执行的起始时间')
  671. voice_end_time = models.IntegerField(default=0, verbose_name='语音执行的结束时间')
  672. voice_repeat_day = models.IntegerField(default=127, verbose_name='语音执行的日期,周几')
  673. voice_direction = models.IntegerField(default=0, verbose_name='语音方向。')
  674. class Meta:
  675. db_table = 'uid_channel'
  676. verbose_name = '设备通道设置'
  677. verbose_name_plural = verbose_name
  678. # oauth2 第三方登录补全信息
  679. class UserExModel(models.Model):
  680. id = models.AutoField(primary_key=True, verbose_name='自增id')
  681. userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE)
  682. appBundleId = models.CharField(default='', max_length=32, verbose_name=u'appID')
  683. region = models.CharField(default='', max_length=16, verbose_name='区域语言')
  684. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  685. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  686. # {'cn': '简体中文', 'tc': '繁体中文', 'fr': '法文', 'ru': '俄文', 'es': '西班牙文', 'pl': '波兰文', 'ja': '日文', 'de': '德文', 'en': '英文'}
  687. class Meta:
  688. db_table = 'user_ex'
  689. verbose_name = '用户扩展信息表'
  690. verbose_name_plural = verbose_name
  691. ordering = ('-id',)
  692. # oauth2 第三方登录补全信息
  693. class UserOauth2Model(models.Model):
  694. id = models.AutoField(primary_key=True, verbose_name='自增id')
  695. userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE)
  696. authType = models.SmallIntegerField(default=0, verbose_name=0) # 授权类型 0 非授权,1 微信授权,2 苹果授权
  697. unionID = models.CharField(default='', max_length=64, verbose_name='唯一标记') # 绑定唯一标记 unionID
  698. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  699. updTime = models.IntegerField(verbose_name='更新时间', default=0)
  700. # {'cn': '简体中文', 'tc': '繁体中文', 'fr': '法文', 'ru': '俄文', 'es': '西班牙文', 'pl': '波兰文', 'ja': '日文', 'de': '德文', 'en': '英文'}
  701. class Meta:
  702. db_table = 'user_oauth2'
  703. verbose_name = '用户oauth2关联'
  704. verbose_name_plural = verbose_name
  705. ordering = ('-id',)
  706. class SysMassModel(models.Model):
  707. id = models.AutoField(primary_key=True, verbose_name='主键自增id')
  708. sender = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE) # 发送人
  709. platform = models.CharField(default='', verbose_name='平台', max_length=16)
  710. lang = models.TextField(blank=True, default='', verbose_name=u'语种')
  711. recever = models.TextField(blank=True, default='', verbose_name=u'接受者')
  712. msg = models.TextField(blank=True, default='', verbose_name=u'发送内容')
  713. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  714. updTime = models.IntegerField(verbose_name='修改时间', default=0)
  715. class Meta:
  716. db_table = 'sys_mass'
  717. verbose_name = '群发消息记录表'
  718. verbose_name_plural = verbose_name
  719. ordering = ('-id',)
  720. class UidUserModel(models.Model):
  721. id = models.CharField(max_length=32, primary_key=True)
  722. userID = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE)
  723. NickName = models.CharField(max_length=32, verbose_name=u'设备名称')
  724. UID = models.CharField(max_length=32, verbose_name=u'设备UID', default='')
  725. View_Account = models.CharField(max_length=32, verbose_name=u'设备用户名称', default='')
  726. View_Password = models.CharField(max_length=32, verbose_name=u'设备密码', default='')
  727. ChannelIndex = models.IntegerField(verbose_name=u'通道号', default=0)
  728. Type = models.IntegerField(verbose_name='设备类型')
  729. NotificationMode = models.IntegerField(verbose_name=u'是否报警', default=0)
  730. isShare = models.BooleanField(verbose_name=u'共享设备', default=False)
  731. primaryUserID = models.CharField(verbose_name='主用户id', max_length=32, default='')
  732. primaryMaster = models.CharField(max_length=64, verbose_name=u'主用户名', default='')
  733. data_joined = models.DateTimeField(verbose_name=u'设备添加时间', auto_now_add=True)
  734. version = models.CharField(max_length=20, default='', verbose_name=u'版本号')
  735. isVod = models.SmallIntegerField(default=0, verbose_name='是否支持云存') # 是否支持云存设备
  736. isExist = models.SmallIntegerField(default=1, verbose_name='是否被删除') # 是否被删除了(需主用户交互) 1存在,0不存在
  737. is_ap = models.SmallIntegerField(default=1, verbose_name='是否为ap模式添加') # 1为ap模式添加,0为非ap模式添加
  738. class Meta:
  739. db_table = 'uid_user'
  740. ordering = ('-data_joined',)
  741. verbose_name = u'用户设备ap表'
  742. verbose_name_plural = verbose_name
  743. class pushDeployModel(models.Model):
  744. id = models.AutoField(primary_key=True, verbose_name='主键自增id')
  745. name = models.CharField(max_length=32, default='', verbose_name=u'推送配置名称')
  746. key = models.CharField(max_length=32, default='', verbose_name=u'推送配置key')
  747. secret = models.CharField(max_length=32, default='', verbose_name=u'推送配置密钥')
  748. pem = models.CharField(max_length=32, default='', verbose_name=u'推送配置路径')
  749. type = models.CharField(max_length=32, default='', verbose_name=u'推送配置类型') # ios 1,android 2
  750. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  751. updTime = models.IntegerField(verbose_name='修改时间', default=0)
  752. class Meta:
  753. db_table = 'push_deploy'
  754. verbose_name = '推送配置表'
  755. verbose_name_plural = verbose_name
  756. ordering = ('-id',)
  757. class AppSetModel(models.Model):
  758. id = models.AutoField(primary_key=True, verbose_name='主键自增id')
  759. appBundleId = models.CharField(max_length=64, default='', verbose_name=u'APPid')
  760. content = models.TextField(default='', verbose_name=u'里面包含评分,用户帮助,ap添加方式,ap工具,广告模块等json字段值')
  761. addTime = models.IntegerField(verbose_name='添加时间', default=0)
  762. updTime = models.IntegerField(verbose_name='修改时间', default=0)
  763. class Meta:
  764. db_table = 'app_set'
  765. verbose_name = 'app的各个版本控制表'
  766. verbose_name_plural = verbose_name
  767. ordering = ('-id',)
  768. # 认证客户端类型表
  769. class ApplicationModel(models.Model):
  770. CLIENT_TYPES = (
  771. ('confidential', 'confidential'),
  772. ('public', 'public'),
  773. )
  774. # authorization_code
  775. # 授权码模式(即先登录获取code, 再获取token)
  776. # password
  777. # 密码模式(将用户名, 密码传过去, 直接获取token)
  778. # client_credentials
  779. # 客户端模式(无用户, 用户向客户端注册, 然后客户端以自己的名义向’服务端’获取资源)
  780. # implicit
  781. # 简化模式(在redirect_uri
  782. # 的Hash传递token;
  783. # Auth客户端运行在浏览器中, 如JS, Flash)
  784. # refresh_token
  785. # 刷新access_token
  786. GRANT_TYPES = (
  787. ('authorization_code', "authorization_code"),
  788. ('password', "password"),
  789. ('client_credentials', "client_credentials"),
  790. ('implicit', "implicit"),
  791. ('refresh_token', "refresh_token"),
  792. )
  793. id = models.BigAutoField(primary_key=True)
  794. name = models.CharField(max_length=128, blank=True, verbose_name='client名字描述')
  795. client_id = models.CharField(max_length=50, unique=True, verbose_name='客户端id')
  796. client_secret = models.CharField(max_length=50, unique=True, verbose_name='客户端secret')
  797. client_type = models.CharField(max_length=32, choices=CLIENT_TYPES, verbose_name='客户端类型')
  798. grant_type = models.CharField(max_length=32, choices=GRANT_TYPES, blank=True, null=True)
  799. redirect_uri = models.TextField(blank=True, null=True, verbose_name='重定向url')
  800. skip_auth = models.BooleanField(default=False, verbose_name='是否跳过点击授权')
  801. add_time = models.IntegerField(verbose_name='添加时间', default=0)
  802. update_time = models.IntegerField(verbose_name='更新时间', default=0)
  803. class Meta:
  804. ordering = ('-add_time',)
  805. verbose_name = u'可授权客户端表'
  806. db_table = 'oauth_application'
  807. # 授权码信息表
  808. class GrantCodeModel(models.Model):
  809. id = models.BigAutoField(primary_key=True)
  810. userID = models.ForeignKey(Device_User, verbose_name="用户表userID", to_field='userID', on_delete=models.CASCADE)
  811. code = models.CharField(max_length=32, unique=True)
  812. app_id = models.CharField(max_length=100, default='', verbose_name="appBundleId")
  813. application = models.ForeignKey(ApplicationModel, verbose_name="用户表id", to_field='id', on_delete=models.CASCADE)
  814. expire_time = models.IntegerField(verbose_name='过期时间', default=0)
  815. add_time = models.IntegerField(verbose_name='添加时间', default=0)
  816. update_time = models.IntegerField(verbose_name='更新时间', default=0)
  817. # 输出的永远是本地时间输出的永远是本地时间
  818. def is_expired(self):
  819. return timezone.now() >= self.expire_time
  820. class Meta:
  821. ordering = ('-add_time',)
  822. verbose_name = u'授权码表'
  823. db_table = 'oauth_grant_code'
  824. class UserAppFrequencyModel(models.Model):
  825. id = models.AutoField(primary_key=True)
  826. user = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE, verbose_name='关联设备用户表')
  827. type = models.SmallIntegerField(default=0, verbose_name='使用频率类型') # 1:每天,2:三天,3:一周,4:两周,5:一个月,6:一个月以上
  828. data_time = models.IntegerField(default=0, verbose_name='数据时间')
  829. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  830. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  831. class Meta:
  832. verbose_name = '用户使用APP频率表'
  833. verbose_name_plural = verbose_name
  834. db_table = 'user_app_frequency'
  835. ordering = ('-add_time',)
  836. class AppFrequencyStatisticsModel(models.Model):
  837. id = models.AutoField(primary_key=True)
  838. data = models.TextField(default='', verbose_name='统计好的数据')
  839. month = models.IntegerField(default=0, verbose_name='月份')
  840. year = models.IntegerField(default=0, verbose_name='年份')
  841. class Meta:
  842. verbose_name = 'app月使用频率统计表'
  843. verbose_name_plural = verbose_name
  844. db_table = 'app_frequency_statistics'
  845. class AppFrequencyYearStatisticsModel(models.Model):
  846. id = models.AutoField(primary_key=True)
  847. data = models.TextField(default='', verbose_name='统计好的数据')
  848. year = models.IntegerField(default=0, verbose_name='年份')
  849. num = models.IntegerField(default=0, verbose_name='总人数')
  850. class Meta:
  851. verbose_name = 'app使用频率统计表,年度统计'
  852. verbose_name_plural = verbose_name
  853. db_table = 'app_frequency_year_statistics'
  854. # alexa连接数统计表
  855. class AlexaConnectStatisticsModel(models.Model):
  856. id = models.AutoField(primary_key=True)
  857. num = models.IntegerField(default=0, verbose_name='总人数')
  858. data_time = models.IntegerField(default=0, verbose_name='数据时间')
  859. class Meta:
  860. verbose_name = 'alexa连接数统计表'
  861. verbose_name_plural = verbose_name
  862. db_table = 'alexa_statistics'
  863. class FAQModel(models.Model):
  864. id = models.AutoField(primary_key=True)
  865. title = models.CharField(max_length=64, default='', unique=True, verbose_name='标题')
  866. content = models.TextField(default='', verbose_name='内容')
  867. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  868. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  869. class Meta:
  870. db_table = 'tb_faq'
  871. verbose_name = '问题帮助表'
  872. verbose_name_plural = verbose_name
  873. class AppLogModel(models.Model):
  874. id = models.AutoField(primary_key=True)
  875. user = models.ForeignKey(Device_User, to_field='userID', on_delete=models.CASCADE, verbose_name='关联设备用户表')
  876. uid = models.CharField(max_length=20, default='', verbose_name='设备uid')
  877. average_delay = models.CharField(max_length=32, default='', verbose_name='最高平均延时')
  878. status = models.SmallIntegerField(default=0, verbose_name='失败状态')
  879. filename = models.CharField(max_length=120, default='', verbose_name='文件名')
  880. add_time = models.IntegerField(default=0, verbose_name='日期')
  881. class Meta:
  882. db_table = 'app_log'
  883. verbose_name = 'APP日志表'
  884. verbose_name_plural = verbose_name
  885. class EquipmentInfoExStatisticsModel(models.Model):
  886. id = models.AutoField(primary_key=True)
  887. push_type = models.SmallIntegerField(default=0, verbose_name='第三方推送服务器标志。0:APNS推送,1:谷歌推送,2:极光推送')
  888. number_of_successes = models.IntegerField(default=0, verbose_name='推送成功数量')
  889. number_of_failures = models.IntegerField(default=0, verbose_name='推送失败数量')
  890. number_of_arrival = models.IntegerField(default=0, verbose_name='推送到达数量')
  891. statistics_date = models.IntegerField(default=0, verbose_name='属于哪天、哪月的统计')
  892. date_type = models.SmallIntegerField(default=0, verbose_name='统计日期的类型。0:天,1:月')
  893. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  894. class Meta:
  895. db_table = 'equipment_info_ex_statistics'
  896. verbose_name = '推送消息统计表'
  897. verbose_name_plural = verbose_name
  898. class CountryIPModel(models.Model):
  899. id = models.AutoField(primary_key=True)
  900. ip = models.CharField(default='', max_length=32, verbose_name='ip')
  901. user_ex = models.ForeignKey(UserExModel, to_field='id', on_delete=models.CASCADE, verbose_name='关联用户扩展信息表id')
  902. country = models.CharField(default='', max_length=100, verbose_name='国家')
  903. status = models.SmallIntegerField(default=0, verbose_name='是否已经查找,0:否,1:是')
  904. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  905. class Meta:
  906. db_table = 'country_ip'
  907. verbose_name = 'ip-国家统计表'
  908. verbose_name_plural = verbose_name
  909. class ZositechHelpModel(models.Model):
  910. id = models.AutoField(primary_key=True)
  911. locale = models.CharField(default='', db_index=True, max_length=50, verbose_name='语言')
  912. label_names = models.CharField(default='', db_index=True, max_length=50, verbose_name='标签')
  913. origin = models.CharField(default='', db_index=True ,max_length=50, verbose_name='来源')
  914. # author_id = models.CharField(default='', max_length=50, verbose_name='管理员id')
  915. # body = models.TextField(default='', blank=True, verbose_name='内容')
  916. # comments_disabled = models.CharField(default='', max_length=10, verbose_name='comments')
  917. # created_at = models.CharField(default='', max_length=50, verbose_name='创建时间')
  918. # draft = models.CharField(default='', max_length=10, verbose_name='草稿')
  919. # edited_at = models.CharField(default='',max_length=50, verbose_name='修改时间')
  920. # html_url = models.CharField(default='', blank=True, verbose_name='跳转路径')
  921. # body = models.CharField(default='', blank=True, verbose_name='标签')
  922. # body = models.CharField(default='', blank=True, verbose_name='标签')
  923. # body = models.TextField(default='', blank=True, verbose_name='标签')
  924. # body = models.TextField(default='', blank=True, verbose_name='标签')
  925. # body = models.CharField(default='', blank=True, verbose_name='标签')
  926. # body = models.CharField(default='', blank=True, verbose_name='标签')
  927. content = models.TextField(blank=True, default='', verbose_name=u'内容')
  928. class Meta:
  929. db_table = 'zositech_help'
  930. verbose_name = '周视使用帮助表'
  931. verbose_name_plural = verbose_name
  932. class EquipmentVersionLimitModel(models.Model):
  933. id = models.AutoField(primary_key=True)
  934. type = models.SmallIntegerField(default=0, verbose_name='限制类型')
  935. content = models.TextField(default='', verbose_name='限制内容')
  936. equipment_version = models.ForeignKey(Equipment_Version, to_field='eid', on_delete=models.CASCADE, verbose_name='关联设备版本信息id')
  937. status = models.SmallIntegerField(default=0, verbose_name='是否启用。0:不启用,1:启用')
  938. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  939. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  940. class Meta:
  941. db_table = 'equipment_version_limit'
  942. verbose_name = '设备版本信息限制表'
  943. verbose_name_plural = verbose_name
  944. class ExperienceContextModel(models.Model):
  945. id = models.AutoField(primary_key=True)
  946. experience_type = models.SmallIntegerField(default=0,verbose_name='体验类型') # 0: 免费体验套餐, 1: 激活码
  947. uid = models.CharField(max_length=20, default='', verbose_name='设备uid')
  948. do_time = models.IntegerField(default=0, verbose_name='激活时间')
  949. # is_experience = models.SmallIntegerField(default=0, verbose_name=u'是否云存体验用户') # 0:不是体验用户,1:是体验用户
  950. class Meta:
  951. db_table = 'experience_context'
  952. verbose_name = '设备体验表'
  953. verbose_name_plural = verbose_name
  954. class CDKcontextModel(models.Model):
  955. id = models.AutoField(primary_key=True)
  956. cdk = models.CharField(max_length=50,unique=True,verbose_name='激活码')
  957. create_time = models.IntegerField(default=0, verbose_name='创建时间')
  958. valid_time = models.IntegerField(default=0, verbose_name='有效期间') #超过有效期激活码不可在激活 ,0:永久
  959. is_activate = models.SmallIntegerField(default=0, verbose_name='是否已激活') #0 未激活 1 已激活
  960. rank = models.ForeignKey(Store_Meal, to_field='id', default='', on_delete=models.CASCADE, verbose_name='套餐类型')
  961. # order = models.ForeignKey(Order_Model, blank=True, max_length=20, to_field='orderID', on_delete=models.CASCADE, verbose_name='订单id', unique=True)
  962. order = models.CharField(max_length=20, blank=True, unique=True, verbose_name='订单id')
  963. class Meta:
  964. db_table = 'cdk_context'
  965. verbose_name = '激活码表'
  966. verbose_name_plural = verbose_name
  967. class VoicePromptModel(models.Model):
  968. id = models.AutoField(primary_key=True)
  969. title = models.CharField(max_length=128, default='', verbose_name='语音标题')
  970. type = models.SmallIntegerField(default=0, verbose_name='语音类型。0:进入语音,1:离开语音')
  971. filename = models.CharField(max_length=120, default='', verbose_name='文件名')
  972. language = models.CharField(max_length=16, default='', verbose_name='语言类型')
  973. classification = models.SmallIntegerField(default=1, verbose_name='语音分类。0:系统,1:自定义')
  974. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  975. uid = models.CharField(max_length=20, default='0', verbose_name='关联设备UID')
  976. channel = models.IntegerField(default=0, verbose_name='通道号')
  977. status = models.SmallIntegerField(default=1, verbose_name='是否启用。0:不启用,1:启用')
  978. class Meta:
  979. db_table = 'voice_prompt'
  980. verbose_name = '语音提示表'
  981. verbose_name_plural = verbose_name
  982. class DeviceTypeModel(models.Model):
  983. id = models.AutoField(primary_key=True)
  984. name = models.CharField(max_length=64, default='', verbose_name='设备名称')
  985. model = models.SmallIntegerField(default=0, verbose_name='设备大类。1:dvr,2:ipc')
  986. type = models.IntegerField(default=0, verbose_name='设备类型')
  987. ptz_type = models.IntegerField(default=0, verbose_name='ptz类型。1:dvr球机,2:IPCPTZ,3:同轴菜单')
  988. icon = models.CharField(max_length=120, default='', verbose_name='文件名')
  989. add_time = models.IntegerField(default=0, verbose_name='添加时间')
  990. update_time = models.IntegerField(default=0, verbose_name='更新时间')
  991. class Meta:
  992. db_table = 'device_type'
  993. verbose_name = '设备类型表'
  994. verbose_name_plural = verbose_name