models.py 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581
  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 imagekit.models import ProcessedImageField
  7. from imagekit.processors import ResizeToFill
  8. from Ansjer.config import SERVER_DOMAIN
  9. from Service.CommonService import CommonService
  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. ROLE_TYPES = (
  64. ('Guests', u'Guests'),
  65. ('Users', u'Users'),
  66. ('Admins', u'Admins'),
  67. ('SysAdmins', u'SysAdmins'),
  68. ('LOGAdmins', u'LOGAdmins'),
  69. ('OTAAdmins', u'OTAAdmins'),
  70. ('DBAAdmins', u'DBAAdmins'),
  71. ('SuperAdmins', u'SuperAdmins'),
  72. )
  73. rid = models.SmallIntegerField(primary_key=True, unique=True, verbose_name=u'用户角色组ID')
  74. roleName = models.CharField(max_length=32, choices=ROLE_TYPES, unique=True,
  75. default='User', verbose_name=u'角色名称')
  76. permission = models.ManyToManyField(to='Permissions', blank=True, verbose_name=u'权限', db_table='role_permissions')
  77. Description = models.TextField(blank=True, default='', verbose_name=u'描述信息')
  78. objects = RoleManager()
  79. class Meta:
  80. ordering = ['roleName']
  81. db_table = 'role'
  82. verbose_name = u'用户角色'
  83. verbose_name_plural = verbose_name
  84. def __str__(self):
  85. return self.roleName
  86. def natural_key(self):
  87. return (self.roleName,)
  88. def has_perm(self, permission, obj=None):
  89. if self.rid == 100:
  90. return True
  91. permlist = self.permission.all()
  92. for perm in permlist:
  93. if perm.permName == permission:
  94. return True
  95. return False
  96. def get_all_perms_id(self):
  97. perms = self.permission.all()
  98. permslist = []
  99. if self.rid == 100:
  100. perms = Permissions.objects.all()
  101. for perm in perms:
  102. permslist.append(perm.id)
  103. return permslist
  104. else:
  105. permlist_tmp = []
  106. for perm in perms:
  107. permlist_tmp.append(perm.id)
  108. permSet = set(permlist_tmp)
  109. permslist = list(permSet)
  110. permslist.sort()
  111. return permslist
  112. def get_all_permission(self):
  113. perms = self.permission.all()
  114. permslist = []
  115. if self.rid == 100:
  116. perms = Permissions.objects.all()
  117. for perm in perms:
  118. permslist.append(perm.permName)
  119. return permslist
  120. else:
  121. permlist_tmp = []
  122. for perm in perms:
  123. permlist_tmp.append(perm.permName)
  124. permSet = set(permlist_tmp)
  125. permslist = list(permSet)
  126. permslist.sort()
  127. return permslist
  128. class Device_User(AbstractBaseUser):
  129. userID = models.CharField(blank=True, max_length=32, primary_key=True,
  130. verbose_name=u'用户ID', unique=True, default=CommonService.getUserID(getUser=True))
  131. role = models.ManyToManyField(to='Role', blank=True, verbose_name=u'用户角色', db_table='user_role')
  132. username = models.CharField(max_length=40, verbose_name=u'用户名', unique = True)
  133. password = models.CharField(max_length=128, verbose_name=u'密码')
  134. userEmail = models.EmailField(max_length = 64, verbose_name=u'邮箱', unique = True, null=True, blank=True)
  135. # 实际的路径就是 MEDIA_ROOT/Image/filename,所以可用upload_to来指定文件存放的前缀路径
  136. userIconPath = ProcessedImageField(blank=True, upload_to='User/Images/', default='static/User/default.png',
  137. verbose_name=u'头像',
  138. # 图片将处理成85x85的尺寸
  139. processors=[ResizeToFill(85, 85)],)
  140. userIconUrl = models.URLField(blank = True, max_length = 128, default=SERVER_DOMAIN
  141. + '/account/getAvatar/User/defaultUser.png')
  142. NickName = models.CharField(blank=True, max_length=32, default='', verbose_name=u'用户昵称')
  143. is_superuser = models.IntegerField(blank=True, default=0, verbose_name=u'用户类型')
  144. is_active = models.BooleanField(blank=True, default=False, verbose_name=u'用户活动状态')
  145. data_joined = models.DateTimeField(blank=True, verbose_name=u'加入时间', auto_now_add=True)
  146. last_login = models.DateTimeField(blank=True, verbose_name='u最后登录时间', auto_now=True)
  147. user_isValid = models.BooleanField(blank=True, default=False, verbose_name=u'用户有效性', help_text=u'是否是认证通过的用户')
  148. online = models.BooleanField(blank=True, default=False, verbose_name=u'用户登录状态')
  149. machine_code = models.CharField(blank=True, max_length=128, default='', verbose_name=u'机械码')
  150. language = models.CharField(blank=True, null=True, max_length=16, default='', verbose_name=u'语言地区')
  151. objects = UserManager()
  152. USERNAME_FIELD = 'username' # 必须有一个唯一标识
  153. REQUIRED_FIELDS = ['userID', 'is_superuser'] # 创建superuser时的必须字段
  154. class Meta:
  155. ordering = ('-data_joined', )
  156. verbose_name = u'用户信息'
  157. db_table = 'device_user'
  158. get_latest_by = 'last_login'
  159. def __str__(self):
  160. return self.username
  161. def get_full_name(self):
  162. return self.userEmail
  163. def get_short_name(self):
  164. return self.username
  165. def get_role_id(self):
  166. rids = []
  167. roles = self.role.all()
  168. for role in roles:
  169. rids.append(role.rid)
  170. return rids
  171. def has_perm(self, permission, obj=None):
  172. roles = self.role.all()
  173. for role in roles:
  174. if role.rid == 100:
  175. return True
  176. permlist = self.permission.all()
  177. for perm in permlist:
  178. if perm.permName == permission:
  179. return True
  180. for role in roles:
  181. permlist = role.permission.all()
  182. for perm in permlist:
  183. if perm.permName == permission:
  184. return True
  185. return False
  186. def get_all_perms_id(self):
  187. roles = self.role.all()
  188. perms = self.permission.all()
  189. permslist = []
  190. for role in roles:
  191. if role.rid == 100:
  192. perms = Permissions.objects.all()
  193. for perm in perms:
  194. permslist.append(perm.id)
  195. return permslist
  196. for perm in perms:
  197. permslist.append(perm.id)
  198. permSet = set(permslist)
  199. for role in roles:
  200. permlist_tmp = []
  201. for perm in role.permission.all():
  202. permlist_tmp.append(perm.id)
  203. permSet_tmp = set(permlist_tmp)
  204. permSet = permSet.union(permSet_tmp)
  205. permslist = list(permSet)
  206. permslist.sort()
  207. return permslist
  208. def get_all_permission(self):
  209. roles = self.role.all()
  210. perms = self.permission.all()
  211. permslist = []
  212. for role in roles:
  213. if role.rid == 100:
  214. perms = Permissions.objects.all()
  215. for perm in perms:
  216. permslist.append(perm.permName)
  217. return permslist
  218. for perm in perms:
  219. permslist.append(perm.permName)
  220. permSet = set(permslist)
  221. for role in roles:
  222. permlist_tmp = []
  223. for perm in role.permission.all():
  224. permlist_tmp.append(perm.permName)
  225. permSet_tmp = set(permlist_tmp)
  226. permSet = permSet.union(permSet_tmp)
  227. permslist = list(permSet)
  228. permslist.sort()
  229. return permslist
  230. def has_module_perms(self, app_label):
  231. return True
  232. @property
  233. def is_staff(self):
  234. return self.is_superuser
  235. class Device_Info(models.Model):
  236. id = models.CharField(blank=True, max_length=32, primary_key=True)
  237. userID = models.ForeignKey(Device_User, blank=True, to_field='userID',
  238. on_delete=models.CASCADE)
  239. NickName = models.CharField(blank=True, max_length=32, verbose_name=u'设备名称')
  240. UID = models.CharField(blank=True, max_length=32, verbose_name=u'设备UID')
  241. SID = models.CharField(blank=True, max_length=32, verbose_name=u'服务器ID')
  242. View_Account = models.CharField(blank=True, max_length=32, verbose_name=u'设备用户名称')
  243. View_Password = models.CharField(blank=True, max_length=32, verbose_name=u'设备密码')
  244. AudioFormat = models.IntegerField(blank=True, default=1, verbose_name=u'初始化影像')
  245. EventNotification = models.IntegerField(blank=True, verbose_name=u'报警类型')
  246. ChannelIndex = models.IntegerField(blank=True, verbose_name=u'通道号')
  247. Online = models.BooleanField(blank=True, default=False, verbose_name=u'设备是否在线')
  248. mMonitorIndex = models.IntegerField(blank=True, default=-1)
  249. Type = models.IntegerField(blank=True)
  250. DebugMode = models.IntegerField(blank=True, verbose_name=u'调试模式')
  251. NotificationMode = models.IntegerField(blank=True, verbose_name=u'是否报警')
  252. qvgaLevel = models.BooleanField(blank=True, verbose_name=u'SD与HD画面', default=0,
  253. help_text=u'0代表:SD、1代表:HD')
  254. isShare = models.BooleanField(blank=True, verbose_name=u'共享设备',
  255. help_text=u'是否为共享获取的设备', default=False)
  256. primaryUserID = models.CharField(blank=True, verbose_name='主用户',
  257. help_text=u'该设备的主用户', max_length=32, default='')
  258. data_joined = models.DateTimeField(blank=True, verbose_name=u'设备添加时间', auto_now_add=True)
  259. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True,null=True)
  260. ip = models.CharField(blank=True, max_length=20, null=True, verbose_name=u'设备区域ip')
  261. area = models.CharField(blank=True, max_length=100, null=True, verbose_name=u'设备区域area')
  262. # ios要求新增字段
  263. version = models.CharField(blank=True, max_length=20, null=True, verbose_name=u'版本号')
  264. SpaceUsable = models.CharField(blank=True, max_length=20, null=True, verbose_name=u'可用空间')
  265. SpaceSum = models.CharField(blank=True, max_length=20, null=True, verbose_name=u'总空间')
  266. WIFIName = models.CharField(blank=True, max_length=50, null=True, verbose_name=u'无线名称')
  267. WIFIIP = models.CharField(blank=True, max_length=20, null=True, verbose_name=u'无线ip')
  268. WIFIPwd = models.CharField(blank=True, max_length=50, null=True, verbose_name=u'无线密码')
  269. isDetector = models.BooleanField(blank=True, verbose_name=u'侦测开关0:关闭,1:开启)',default=False)
  270. DetectorRank = models.IntegerField(blank=True, default=0, verbose_name=u'侦测灵敏度 1:低,2:中,3:高4:最高')
  271. iSNotification = models.BooleanField(blank=True, verbose_name=u'报警通知 0:关闭,1:开启)',default=False)
  272. MirrorType = models.IntegerField(blank=True, default=0, verbose_name=u'镜像类型 0:关闭镜像,1:上下镜像,2:左右镜像,3:上下左右镜像')
  273. RecordType = models.IntegerField(blank=True, default=0, verbose_name=u'录像模式(0:关闭,1:全是录像,3:报警录像)')
  274. TimeZone = models.CharField(blank=True, max_length=50, null=True, verbose_name=u'时区')
  275. ###
  276. REQUIRED_FIELDS = []
  277. def __str__(self):
  278. return self.NickName
  279. def model_to_dict(self, fields=None, exclude=None):
  280. opts = self._meta
  281. data = {}
  282. for f in chain(opts.concrete_fields, opts.private_fields, opts.many_to_many):
  283. if not getattr(f, 'editable', False):
  284. continue
  285. if fields and f.name not in fields:
  286. continue
  287. if exclude and f.name in exclude:
  288. continue
  289. data[f.name] = f.value_from_object(self)
  290. return data
  291. class Meta:
  292. db_table = 'device_info'
  293. ordering = ('-data_joined',)
  294. verbose_name = u'用户设备信息表'
  295. verbose_name_plural=verbose_name
  296. class AuthToken_Token(models.Model):
  297. tokenID = models.OneToOneField(Device_User, blank=True,on_delete=models.CASCADE,
  298. primary_key=True) #定义一对一关系
  299. access_token = models.CharField(blank=True, max_length=256)
  300. refresh_token = models.CharField(blank=True, max_length=256)
  301. last_update = models.DateTimeField(blank=True, auto_now=True)
  302. iCode = models.CharField(blank=True, max_length=12, verbose_name=u'干扰码')
  303. mCode = models.CharField(blank=True, max_length=64, verbose_name=u'设备码')
  304. class Meta:
  305. verbose_name = u'用户Token'
  306. db_table = 'authtoken_token'
  307. ordering = ('-last_update', )
  308. class AuthToken_JWT(models.Model):
  309. jwtID = models.OneToOneField(Device_User, blank=True, on_delete=models.CASCADE,
  310. primary_key=True, verbose_name=u'token userID')
  311. access_token = models.CharField(blank=True, max_length=384, verbose_name=u'Access Token')
  312. refresh_token = models.CharField(blank=True, max_length=384, verbose_name=u'Refresh Token')
  313. secret = models.CharField(blank=True, max_length=32, verbose_name=u'Secret')
  314. last_update = models.DateTimeField(blank=True, auto_now=True, verbose_name=u'Last Update')
  315. class Meta:
  316. verbose_name = u'用户JWT'
  317. verbose_name_plural = verbose_name
  318. db_table = 'authtoken_jwt'
  319. ordering = ('-last_update', )
  320. class Email_Captcha(models.Model):
  321. userCaptcha = models.CharField(max_length=10, verbose_name=u'验证码')
  322. userEmail = models.EmailField(max_length=50, verbose_name=u'邮箱')
  323. sendType = models.CharField(choices=(("register",u"注册"),("forget",u"找回密码")), max_length=15)
  324. sendTime = models.DateField(auto_now_add=True)
  325. class Meta:
  326. db_table = 'email_captcha'
  327. ordering = ('-sendTime',)
  328. verbose_name = u'邮箱验证码'
  329. verbose_name_plural=verbose_name
  330. class Auth_Captcha(models.Model):
  331. username = models.CharField(max_length=50, help_text=u'用户名(邮箱或电话号码)')
  332. authcaptca = models.CharField(max_length=6, help_text=u'验证码')
  333. sendtype = models.CharField(max_length=15, choices=(("register",u"注册"),("forget",u"找回密码")))
  334. sendtime = models.DateTimeField(auto_now_add=True)
  335. class Meta:
  336. db_table = 'auth_captcha'
  337. ordering = ('-sendtime',)
  338. verbose_name = u'邮箱验证码'
  339. verbose_name_plural=verbose_name
  340. class Access_Log(models.Model):
  341. id = models.AutoField(primary_key=True,verbose_name=u'自增标记ID')
  342. user = models.CharField(max_length=100,null=True,db_index=True,blank=True,verbose_name=u'用户')
  343. operation = models.CharField(max_length=100,db_index=True,null=True,blank=True,verbose_name=u'操作')
  344. ip = models.CharField(max_length=100,null=True,blank=True,verbose_name=u'访问ip地址')
  345. url = models.CharField(max_length=150,null=True,blank=True,verbose_name=u'访问路径')
  346. status = models.IntegerField(null=True,blank=True,verbose_name=u'状态')
  347. time = models.DateTimeField(null=True,blank=True, db_index=True,verbose_name=u'访问时间')
  348. content = models.TextField(blank=True,null=True, verbose_name=u'参数内容')
  349. class Meta:
  350. db_table = 'access_log'
  351. verbose_name = u'访问日志表'
  352. verbose_name_plural=verbose_name
  353. class Equipment_Stream(models.Model):
  354. id = models.AutoField(primary_key=True,verbose_name=u'自增标记ID')
  355. userID = models.CharField(blank=True, max_length=32,verbose_name=u'用户ID')
  356. status = models.IntegerField(null=True, blank=True, verbose_name=u'状态')
  357. uid = models.CharField(null=True, blank=True,max_length=32, verbose_name=u'设备ID')
  358. channel = models.IntegerField(null=True, blank=True, verbose_name=u'设备通道')
  359. access_token = models.CharField(blank=True, max_length=128,verbose_name=u'设备推流验证令牌')
  360. total_flow = models.FloatField(null=True, blank=True, verbose_name=u'传输总容量')
  361. add_time = models.DateTimeField(blank=True, null=True,verbose_name=u'加入时间', auto_now_add=True)
  362. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  363. rank = models.IntegerField(null=True, blank=True, verbose_name=u'推流套餐类型')
  364. class Meta:
  365. db_table = 'equipment_stream'
  366. verbose_name = u'用户设备推流表'
  367. verbose_name_plural=verbose_name
  368. class Equipment_Sensor(models.Model):
  369. id = models.AutoField(primary_key=True,verbose_name=u'自增标记ID')
  370. status = models.IntegerField(null=True, blank=True, verbose_name=u'状态')
  371. type = models.IntegerField(null=True, blank=True, verbose_name=u'类型')
  372. name = models.CharField(null=True, blank=True,max_length=128, verbose_name=u'传感器名称')
  373. add_time = models.DateTimeField(blank=True,null=True, verbose_name=u'加入时间', auto_now_add=True)
  374. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  375. uid = models.CharField(null=True, blank=True,max_length=32, verbose_name=u'设备ID')
  376. def __str__(self):
  377. return self.id
  378. class Meta:
  379. db_table = 'equipment_sensor'
  380. verbose_name = u'设备传感器表'
  381. verbose_name_plural=verbose_name
  382. ordering = ('id',)
  383. class Equipment_Info(models.Model):
  384. id = models.AutoField(primary_key=True,verbose_name=u'自增标记ID')
  385. devUid = models.CharField(null=True, blank=True,max_length=32, verbose_name=u'设备ID')
  386. devNickName = models.CharField(blank=True, max_length=32, default='',verbose_name=u'设备昵称')
  387. Channel = models.IntegerField(null=True, blank=True, verbose_name=u'设备通道')
  388. eventType = models.IntegerField(null=True, blank=True, verbose_name=u'事件类型')
  389. viewAccont = models.CharField(blank=True,null=True, max_length=32, verbose_name=u'设备账户')
  390. viewPwd = models.CharField(blank=True, null=True,max_length=32, verbose_name=u'设备密码')
  391. status = models.BooleanField(blank=True, default=False, verbose_name=u'事件状态')
  392. alarm = models.CharField(blank=True, max_length=256, verbose_name=u'报警信息')
  393. eventTime = models.CharField(blank=True,null=True, max_length=16, verbose_name=u'设备报警时间')
  394. receiveTime = models.CharField(blank=True,null=True, max_length=16, verbose_name=u'接收到报警时间')
  395. userID = models.ForeignKey(Device_User, null=True,blank=True, to_field='userID',
  396. on_delete=models.CASCADE)
  397. def __str__(self):
  398. return self.id
  399. class Meta:
  400. db_table = 'equipment_info'
  401. verbose_name = u'设备信息推送表'
  402. verbose_name_plural=verbose_name
  403. ordering = ('-id',)
  404. class Feedback_Info(models.Model):
  405. id = models.AutoField(primary_key=True,verbose_name=u'自增标记ID')
  406. userID = models.CharField(blank=True, max_length=32, verbose_name=u'用户ID')
  407. status = models.BooleanField(blank=True, default=False, verbose_name=u'状态:0未解决/解决')
  408. content = models.TextField(blank=True,null=True, verbose_name=u'反馈描述')
  409. add_time = models.DateTimeField(blank=True, null=True, verbose_name=u'加入时间/反馈时间', auto_now_add=True)
  410. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  411. def __str__(self):
  412. return self.id
  413. class Meta:
  414. db_table = 'feedback_info'
  415. verbose_name = u'用户反馈信息表'
  416. verbose_name_plural=verbose_name
  417. ordering = ('id',)
  418. class Store_Meal(models.Model):
  419. id = models.AutoField(primary_key=True,verbose_name=u'自增ID')
  420. title = models.CharField(blank=True, max_length=32, verbose_name=u'标题')
  421. price = models.CharField(blank=True, max_length=32, verbose_name=u'价格')
  422. day = models.IntegerField(null=True, blank=True, verbose_name=u'存储时间')
  423. content = models.TextField(blank=True,null=True, verbose_name=u'描述')
  424. add_time = models.DateTimeField(blank=True,null=True, verbose_name=u'加入时间', auto_now_add=True)
  425. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  426. def __str__(self):
  427. return self.id
  428. class Meta:
  429. db_table = 'store_meal'
  430. verbose_name = u'存储套餐'
  431. verbose_name_plural=verbose_name
  432. ordering = ('id',)
  433. class Device_Meal(models.Model):
  434. id = models.AutoField(primary_key=True,verbose_name=u'自增标记ID')
  435. status = models.IntegerField(null=True, blank=True, verbose_name=u'状态')
  436. uid = models.CharField(null=True, blank=True,max_length=32,verbose_name=u'设备ID')
  437. channel = models.IntegerField(null=True, blank=True, verbose_name=u'设备通道')
  438. add_time = models.DateTimeField(blank=True, null=True,verbose_name=u'加入时间', auto_now_add=True)
  439. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  440. end_time = models.DateTimeField(blank=True, verbose_name=u'最后时间')
  441. rank = models.ForeignKey(Store_Meal, blank=True, to_field='id',
  442. on_delete=models.CASCADE,verbose_name='套餐类型')
  443. class Meta:
  444. db_table = 'device_meal'
  445. verbose_name = u'设备关联套餐表'
  446. verbose_name_plural=verbose_name
  447. ordering = ('id',)
  448. def __str__(self):
  449. return self.id
  450. class Equipment_Version(models.Model):
  451. eid = models.CharField(blank=True, max_length=32, primary_key=True)
  452. ESN = models.CharField(blank=True, max_length=32, verbose_name=u'设备规格名称')
  453. code = models.CharField(blank=True, max_length=32, verbose_name=u'设备规格代码')
  454. version = models.CharField(blank=True, max_length=32, verbose_name=u'设备版本')
  455. softwareVersion = models.CharField(blank=True, max_length=32, verbose_name=u'软件版本')
  456. chipModelList2Code = models.CharField(max_length=32,blank=True, verbose_name=u'主芯片码')
  457. channel = models.IntegerField(blank=True, verbose_name=u'通道数')
  458. resolutionRatio = models.IntegerField(blank=True, verbose_name=u'分辨率')
  459. type = models.CharField(blank=True, max_length=16, verbose_name=u'设备机型')
  460. companyCode = models.CharField(blank=True, max_length=128, verbose_name=u'用户公司名称')
  461. data_joined = models.DateTimeField(blank=True, verbose_name=u'加入时间', auto_now_add=True)
  462. fileSize = models.IntegerField(blank=True, verbose_name=u'文件总大小')
  463. filePath = models.CharField(blank=True, max_length=256, verbose_name=u'升级文件路径')
  464. Description = models.TextField(blank=True, default='', verbose_name=u'描述信息')
  465. fileMd5 = models.CharField(blank=True,max_length=32,null=True,verbose_name=u'上传文件MD5加密')
  466. status = models.BooleanField(blank=True, default=True, verbose_name=u'是否开启更新状态')
  467. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  468. lang = models.CharField(blank=True, null=True,default=0, max_length=32, verbose_name=u'ota包内置语言')
  469. def __str__(self):
  470. return self.eid
  471. class Meta:
  472. verbose_name = '设备版本信息'
  473. ordering = ('-data_joined',)
  474. db_table = 'equipment_version'
  475. class App_Info(models.Model):
  476. id = models.AutoField(primary_key=True,verbose_name=u'自增标记ID')
  477. appBundleId = models.CharField(blank=True, max_length=32, verbose_name=u'appID')
  478. appName = models.CharField(blank=True, max_length=32, verbose_name=u'app名称')
  479. systemLanguage = models.CharField(blank=True, max_length=32, verbose_name=u'系统语言')
  480. newAppversion = models.CharField(blank=True, max_length=12, verbose_name=u'系统版本')
  481. bundleVersion = models.CharField(blank=True, max_length=12, verbose_name=u'项目版本')
  482. content = models.TextField(blank=True,null=True, verbose_name=u'更新内容')
  483. app_type = models.IntegerField(null=True, blank=True, verbose_name=u'app类型')
  484. add_time = models.DateTimeField(blank=True,null=True, verbose_name=u'加入时间', auto_now_add=True)
  485. update_time = models.DateTimeField(blank=True, verbose_name=u'更新时间', auto_now=True)
  486. downloadLink = models.TextField(blank=True, null=True, verbose_name='升级')
  487. def __str__(self):
  488. return self.id
  489. class Meta:
  490. db_table = 'app_info'
  491. verbose_name = u'app信息表'
  492. verbose_name_plural=verbose_name
  493. ordering = ('id',)