models.py 26 KB

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