# coding=utf-8 from django.db import models from django.conf import settings from utils.exceptions import CustomError from apps.option.models import Option from apps.agent.models import Store class ReportCustomer(models.Model): NOT_CHECKED = 0 CHECKED = 1 REPEAT_REPORT = 2 STATUS_CHOICES = ( (NOT_CHECKED, '待审核'), (CHECKED, '已分配'), (REPEAT_REPORT, '重复报备') ) name = models.CharField(max_length=20, verbose_name=u"姓名") tel = models.CharField(max_length=15, verbose_name=u'电话') gender = models.PositiveSmallIntegerField(choices=settings.GENDER_CHOICES, verbose_name=u'性别', default=settings.MALE) village = models.CharField(max_length=200, verbose_name=u'小区') address = models.CharField(max_length=200, verbose_name=u'地址') source = models.ForeignKey(Option, verbose_name=u'来源', related_name='report_customer_source', on_delete=models.PROTECT) project = models.ManyToManyField(Option, verbose_name=u'项目', related_name='report_customer_category', editable=False, null=True,blank=True) notes = models.CharField(max_length=500, verbose_name=u"备注", null=True) report_status = models.PositiveSmallIntegerField(choices=STATUS_CHOICES, verbose_name=u'报备状态', default=NOT_CHECKED) check_user = models.ForeignKey(settings.AUTH_USER_MODEL, verbose_name=u'审核人', related_name='report_customer_check_user', on_delete=models.PROTECT, null=True) check_time = models.DateTimeField(verbose_name=u'审核时间', null=True) create_user = models.ForeignKey(settings.AUTH_USER_MODEL, verbose_name=u'添加人', related_name='report_customer_create_user', editable=False, on_delete=models.PROTECT) create_time = models.DateTimeField(verbose_name=u'添加时间', auto_now_add=True, editable=False) store = models.ForeignKey(Store, verbose_name=u'门店', related_name='report_customer_store', editable=False, on_delete=models.PROTECT) class Meta: db_table = 'report_customer' verbose_name = u'客户报备' ordering = ['-id'] default_permissions = () permissions = [ ('view_report_customer', u'查看'), ('add_report_customer', u'添加'), ('delete_report_customer', u'删除'), ('check_report_customer', u'审核'), ] class NewCustomer(models.Model): report_customer = models.ForeignKey(ReportCustomer, verbose_name=u'报备客户信息', related_name='customer_source', on_delete=models.PROTECT) potential_level = models.ForeignKey(Option, verbose_name=u'潜客级别', related_name='potential_level', on_delete=models.PROTECT) stage_progress = models.ForeignKey(Option, verbose_name=u'阶段进度', related_name='stage_progress', on_delete=models.PROTECT) track_user = models.ForeignKey(settings.AUTH_USER_MODEL, verbose_name=u'跟踪人', related_name='track_user', editable=False, on_delete=models.PROTECT) end_time = models.DateTimeField(verbose_name=u'最后跟踪时间', null=True) next_time = models.DateTimeField(verbose_name=u'下次跟踪时间', null=True) create_user = models.ForeignKey(settings.AUTH_USER_MODEL, verbose_name=u'建档人', related_name='newcustomer_create_user', editable=False, on_delete=models.PROTECT) create_time = models.DateTimeField(verbose_name=u'建档时间', auto_now_add=True, editable=False) class Meta: db_table = 'new_customer' verbose_name = u'客户跟踪信息' ordering = ['-id'] default_permissions = () permissions = [ ('view_new_customer', u'查看'), ('update_new_customer', u'更新'), ('delete_new_customer', u'删除'), ]