models.py 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139
  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 VehicleDriveReserve(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. notes = models.CharField(max_length=500, verbose_name=u'备注', null=True, blank=True)
  27. delete = models.BooleanField(verbose_name=u'删除', default=False, editable=False)
  28. class Meta:
  29. db_table = 'vehicle_drive_reserve'
  30. verbose_name = u'试驾预约'
  31. ordering = ("-id",)
  32. default_permissions = ()
  33. class VehicleInquiry(models.Model):
  34. WAIT_VISIT = 1
  35. VISITED = 2
  36. STATUS_CHOICES = (
  37. (WAIT_VISIT, u'待回访'),
  38. (VISITED, u'已回访'),
  39. )
  40. model = models.ForeignKey(Model, verbose_name=u'车型', on_delete=models.PROTECT)
  41. shop = models.ForeignKey(Shop, verbose_name=u'门店', on_delete=models.PROTECT)
  42. create_time = models.DateTimeField(verbose_name=u"添加时间", auto_now_add=True, editable=False)
  43. status = models.PositiveSmallIntegerField(choices=STATUS_CHOICES, verbose_name=u'状态', default=WAIT_VISIT)
  44. customer = models.ForeignKey(Customer, verbose_name=u'客户', on_delete=models.PROTECT, editable=False)
  45. name = models.CharField(max_length=100, verbose_name=u'名称', null=True)
  46. tel = models.CharField(max_length=20, verbose_name=u'电话', null=True)
  47. area = models.CharField(max_length=100, verbose_name=u'城市', null=True)
  48. displace = models.BooleanField(verbose_name=u'置换', default=False, editable=False)
  49. notes = models.CharField(max_length=500, verbose_name=u'备注', null=True, blank=True)
  50. delete = models.BooleanField(verbose_name=u'删除', default=False, editable=False)
  51. class Meta:
  52. db_table = 'vehicle_inquiry'
  53. verbose_name = u'新车询价'
  54. ordering = ("-id",)
  55. default_permissions = ()
  56. class UsedVehicleInquiry(models.Model):
  57. WAIT_VISIT = 1
  58. VISITED = 2
  59. STATUS_CHOICES = (
  60. (WAIT_VISIT, u'待回访'),
  61. (VISITED, u'已回访'),
  62. )
  63. brand = models.ForeignKey(Option, verbose_name=u'品牌', on_delete=models.PROTECT)
  64. create_time = models.DateTimeField(verbose_name=u"添加时间", auto_now_add=True, editable=False)
  65. status = models.PositiveSmallIntegerField(choices=STATUS_CHOICES, verbose_name=u'状态', default=WAIT_VISIT)
  66. customer = models.ForeignKey(Customer, verbose_name=u'客户', on_delete=models.PROTECT, editable=False)
  67. name = models.CharField(max_length=100, verbose_name=u'名称', null=True)
  68. gender = models.PositiveSmallIntegerField(choices=settings.GENDER_CHOICES, verbose_name=u'性别', null=True)
  69. years = models.CharField(max_length=100, verbose_name=u'车龄', null=True)
  70. area = models.CharField(max_length=100, verbose_name=u'城市', null=True)
  71. mileage = models.FloatField(verbose_name=u"车辆里程", null=True)
  72. notes = models.CharField(max_length=500, verbose_name=u'备注', null=True, blank=True)
  73. delete = models.BooleanField(verbose_name=u'删除', default=False, editable=False)
  74. class Meta:
  75. db_table = 'usedvehicle_inquiry'
  76. verbose_name = u'二手车询价'
  77. ordering = ("-id",)
  78. default_permissions = ()
  79. class UsedVehicleEstimate(models.Model):
  80. WAIT_VISIT = 1
  81. VISITED = 2
  82. STATUS_CHOICES = (
  83. (WAIT_VISIT, u'待回访'),
  84. (VISITED, u'已回访'),
  85. )
  86. brand = models.ForeignKey(Option, verbose_name=u'品牌', on_delete=models.PROTECT)
  87. shop = models.ForeignKey(Shop, 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. tel = models.CharField(max_length=20, verbose_name=u'电话', null=True)
  92. model = models.CharField(max_length=100, verbose_name=u'车型', null=True)
  93. plate_date = models.DateField(verbose_name=u"上牌日期", blank=True, null=True)
  94. area = models.CharField(max_length=100, verbose_name=u'城市', null=True)
  95. mileage = models.FloatField(verbose_name=u"车辆里程", null=True)
  96. notes = models.CharField(max_length=500, verbose_name=u'备注', null=True, blank=True)
  97. delete = models.BooleanField(verbose_name=u'删除', default=False, editable=False)
  98. class Meta:
  99. db_table = 'usedvehicle_estimate'
  100. verbose_name = u'二手车预估'
  101. ordering = ("-id",)
  102. default_permissions = ()
  103. class InsurConsultation(models.Model):
  104. WAIT_VISIT = 1
  105. VISITED = 2
  106. STATUS_CHOICES = (
  107. (WAIT_VISIT, u'待回访'),
  108. (VISITED, u'已回访'),
  109. )
  110. shop = models.ForeignKey(Shop, verbose_name=u'门店', on_delete=models.PROTECT)
  111. create_time = models.DateTimeField(verbose_name=u"添加时间", auto_now_add=True, editable=False)
  112. status = models.PositiveSmallIntegerField(choices=STATUS_CHOICES, verbose_name=u'状态', default=WAIT_VISIT)
  113. customer = models.ForeignKey(Customer, verbose_name=u'客户', on_delete=models.PROTECT, editable=False)
  114. name = models.CharField(max_length=100, verbose_name=u'名称', null=True)
  115. tel = models.CharField(max_length=20, verbose_name=u'电话', null=True)
  116. content = models.CharField(max_length=1000, verbose_name=u'内容', null=True)
  117. delete = models.BooleanField(verbose_name=u'删除', default=False, editable=False)
  118. class Meta:
  119. db_table = 'insur_consultation'
  120. verbose_name = u'续保咨询'
  121. ordering = ("-id",)
  122. default_permissions = ()