models.py 5.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114
  1. # coding=utf-8
  2. from django.db import models
  3. from django.conf import settings
  4. from apps.foundation.models import Option
  5. from apps.vehicle.models import Model
  6. from apps.customer.models import Customer
  7. from apps.store.models import Shop
  8. from apps.images.models import Images
  9. class VhicleDriveReserve(models.Model):
  10. WAIT_DRIVE = 1
  11. FINISHED = 2
  12. REVOKE = 3
  13. STATUS_CHOICES = (
  14. (WAIT_DRIVE, u'待试驾'),
  15. (FINISHED, u'已试驾'),
  16. (REVOKE, u'已取消'),
  17. )
  18. model = models.ForeignKey(Model, verbose_name=u'车型', on_delete=models.PROTECT)
  19. shop = models.ForeignKey(Shop, verbose_name=u'门店', on_delete=models.PROTECT)
  20. create_time = models.DateTimeField(verbose_name=u"添加时间", auto_now_add=True, editable=False)
  21. status = models.PositiveSmallIntegerField(choices=STATUS_CHOICES, verbose_name=u'状态', default=WAIT_DRIVE)
  22. customer = models.ForeignKey(Customer, verbose_name=u'客户', on_delete=models.PROTECT, editable=False)
  23. name = models.CharField(max_length=100, verbose_name=u'名称', null=True)
  24. tel = models.CharField(max_length=20, verbose_name=u'电话', null=True)
  25. date = models.DateField(verbose_name=u'预约日期', null=True)
  26. img1 = models.ForeignKey(Images, verbose_name=u'驾驶证正面', on_delete=models.PROTECT,
  27. related_name=u'vehicle_drive_reserve_front', null=True)
  28. img2 = models.ForeignKey(Images, verbose_name=u'驾驶证反面', on_delete=models.PROTECT,
  29. related_name=u'vehicle_drive_reserve_back', null=True)
  30. notes = models.CharField(max_length=500, verbose_name=u'备注', null=True)
  31. delete = models.BooleanField(verbose_name=u'删除', default=False, editable=False)
  32. class Meta:
  33. db_table = 'vehicle_drive_reserve'
  34. verbose_name = u'试驾预约'
  35. default_permissions = ()
  36. class VhicleInquiry(models.Model):
  37. WAIT_VISIT = 1
  38. VISITED = 2
  39. STATUS_CHOICES = (
  40. (WAIT_VISIT, u'待回访'),
  41. (VISITED, u'已回访'),
  42. )
  43. model = models.ForeignKey(Model, verbose_name=u'车型', on_delete=models.PROTECT)
  44. shop = models.ForeignKey(Shop, verbose_name=u'门店', on_delete=models.PROTECT)
  45. create_time = models.DateTimeField(verbose_name=u"添加时间", auto_now_add=True, editable=False)
  46. status = models.PositiveSmallIntegerField(choices=STATUS_CHOICES, verbose_name=u'状态', default=WAIT_VISIT)
  47. customer = models.ForeignKey(Customer, verbose_name=u'客户', on_delete=models.PROTECT, editable=False)
  48. name = models.CharField(max_length=100, verbose_name=u'名称', null=True)
  49. tel = models.CharField(max_length=20, verbose_name=u'电话', null=True)
  50. area = models.CharField(max_length=100, verbose_name=u'城市', null=True)
  51. displace = models.BooleanField(verbose_name=u'置换', default=False, editable=False)
  52. notes = models.CharField(max_length=500, verbose_name=u'备注', null=True)
  53. delete = models.BooleanField(verbose_name=u'删除', default=False, editable=False)
  54. class Meta:
  55. db_table = 'vehicle_inquiry'
  56. verbose_name = u'新车询价'
  57. default_permissions = ()
  58. class UsedVhicleInquiry(models.Model):
  59. WAIT_VISIT = 1
  60. VISITED = 2
  61. STATUS_CHOICES = (
  62. (WAIT_VISIT, u'待回访'),
  63. (VISITED, u'已回访'),
  64. )
  65. brand = models.ForeignKey(Option, verbose_name=u'品牌', on_delete=models.PROTECT)
  66. create_time = models.DateTimeField(verbose_name=u"添加时间", auto_now_add=True, editable=False)
  67. status = models.PositiveSmallIntegerField(choices=STATUS_CHOICES, verbose_name=u'状态', default=WAIT_VISIT)
  68. customer = models.ForeignKey(Customer, verbose_name=u'客户', on_delete=models.PROTECT, editable=False)
  69. name = models.CharField(max_length=100, verbose_name=u'名称', null=True)
  70. gender = models.PositiveSmallIntegerField(choices=settings.GENDER_CHOICES, verbose_name=u'性别', null=True)
  71. years = models.CharField(max_length=100, verbose_name=u'车龄', null=True)
  72. area = models.CharField(max_length=100, verbose_name=u'城市', null=True)
  73. mileage = models.FloatField(verbose_name=u"车辆里程", null=True)
  74. notes = models.CharField(max_length=500, verbose_name=u'备注', null=True)
  75. delete = models.BooleanField(verbose_name=u'删除', default=False, editable=False)
  76. class Meta:
  77. db_table = 'usedvehicle_inquiry'
  78. verbose_name = u'二手车询价'
  79. default_permissions = ()
  80. class UsedVhicleEstimate(models.Model):
  81. WAIT_VISIT = 1
  82. VISITED = 2
  83. STATUS_CHOICES = (
  84. (WAIT_VISIT, u'待回访'),
  85. (VISITED, u'已回访'),
  86. )
  87. brand = models.ForeignKey(Option, verbose_name=u'品牌', on_delete=models.PROTECT)
  88. create_time = models.DateTimeField(verbose_name=u"添加时间", auto_now_add=True, editable=False)
  89. status = models.PositiveSmallIntegerField(choices=STATUS_CHOICES, verbose_name=u'状态', default=WAIT_VISIT)
  90. customer = models.ForeignKey(Customer, verbose_name=u'客户', on_delete=models.PROTECT, editable=False)
  91. model = models.CharField(max_length=100, verbose_name=u'车型', null=True)
  92. plate_date = models.DateField(verbose_name=u"上牌日期", blank=True, null=True)
  93. area = models.CharField(max_length=100, verbose_name=u'城市', null=True)
  94. mileage = models.FloatField(verbose_name=u"车辆里程", null=True)
  95. notes = models.CharField(max_length=500, verbose_name=u'备注', null=True)
  96. delete = models.BooleanField(verbose_name=u'删除', default=False, editable=False)
  97. class Meta:
  98. db_table = 'usedvehicle_estimate'
  99. verbose_name = u'二手车预估'
  100. default_permissions = ()