models.py 2.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
  1. import os
  2. from django.db import models
  3. from django.conf import settings
  4. from PIL import Image
  5. from apps.tenant.models import Tenant
  6. from utils.file_operation import UploadFile, DeleteFile
  7. class OperationHelp(models.Model):
  8. title = models.CharField(verbose_name=u'标题', max_length=100)
  9. content = models.TextField(verbose_name=u'内容',blank=True, null=True)
  10. create_user = models.ForeignKey(settings.AUTH_USER_MODEL, verbose_name=u"创建人", on_delete=models.PROTECT,
  11. editable=False)
  12. create_time = models.DateTimeField(verbose_name='创建时间', auto_now_add=True)
  13. enable = models.BooleanField(verbose_name=u"在用", default=True)
  14. tenant = models.ForeignKey(Tenant, verbose_name=u'企业', editable=False, on_delete=models.PROTECT)
  15. class Meta:
  16. db_table = 'operation_help'
  17. ordering = ['-id', 'tenant']
  18. verbose_name = u'运维帮助'
  19. class OperationHelpUpfile(models.Model):
  20. operation_help = models.ForeignKey(OperationHelp,verbose_name=u'运维帮助', on_delete=models.PROTECT,null=True)
  21. file_path = models.CharField(verbose_name=u'路径', max_length=250)
  22. width = models.IntegerField(verbose_name=u"图片宽度")
  23. height = models.IntegerField(verbose_name=u"图片高度")
  24. radio_size = models.FloatField(verbose_name="视频大小", blank=True, default=0)
  25. tenant = models.ForeignKey(Tenant, verbose_name=u'企业', editable=False, on_delete=models.PROTECT, null=True)
  26. class Meta:
  27. db_table = 'operation_help_upfile'
  28. ordering = ['-id']
  29. verbose_name = u'运维帮助图片'
  30. def _add_img(self,file,user_id):
  31. width = None
  32. height = None
  33. path = "operation_help_upfile/"
  34. filename = UploadFile(file, path, user_id)
  35. fullname = "%s%s" % (settings.MEDIA_ROOT, filename)
  36. try:
  37. img = Image.open(fullname)
  38. width, height = img.size
  39. # 缩略图压缩宽或高最大200
  40. if width > 1440:
  41. img = img.resize((1440, int((height / width) * 1440)), Image.ANTIALIAS)
  42. img.save(fullname)
  43. width, height = img.size
  44. except:
  45. pass
  46. self.file_path = "%s%s" % (settings.MEDIA_URL, filename)
  47. self.width = width
  48. self.height = height
  49. self.save()
  50. def _add_radio(self, file, user_id):
  51. path = "operation_help_upfile/"
  52. filename = UploadFile(file, path, user_id)
  53. fullname = "%s%s" % (settings.MEDIA_ROOT, filename)
  54. radio_size = os.path.getsize(fullname)
  55. self.radio_size = "%.2f" % (radio_size/(1024*1024))
  56. self.file__ath = "%s%s" % (settings.MEDIA_URL, filename)
  57. self.save()
  58. def del_file(self):
  59. file_path = self.file_path
  60. self.delete()
  61. DeleteFile(file_path)