from django.db import models
from rbac import models as rbac_model
class Department(models.Model):
    """
    部门表
    市场部     1000
    销售      1001
    """
    title = models.CharField(verbose_name=\'部门名称\', max_length=16)
    code = models.IntegerField(verbose_name=\'部门编号\',unique=True,null=False)
    def __str__(self):
        return self.title
class UserInfo(models.Model):
    """
    员工表
    """
    auth = models.OneToOneField(verbose_name=\'用户权限\', to=rbac_model.User,blank=True,null=True)
    name = models.CharField(verbose_name=\'员工姓名\', max_length=16)
    username = models.CharField(verbose_name=\'用户名\', max_length=32)
    password = models.CharField(verbose_name=\'密码\', max_length=64)
    email = models.EmailField(verbose_name=\'邮箱\', max_length=64)
    depart = models.ForeignKey(verbose_name=\'部门\', to="Department",to_field="code")
    def __str__(self):
        return self.name
class Course(models.Model):
    """
    课程表
    如：
        Linux基础
        Linux架构师
        Python自动化开发精英班
        Python自动化开发架构师班
    """
    name = models.CharField(verbose_name=\'课程名称\', max_length=32)
    def __str__(self):
        return self.name
class School(models.Model):
    """
    校区表
    如：
        北京海淀校区
        北京昌平校区
        上海虹口校区
        广州白云山校区
    """
    title = models.CharField(verbose_name=\'校区名称\', max_length=32)
    def __str__(self):
        return self.title
class ClassList(models.Model):
    """
    班级表
    如：
        Python全栈  面授班  5期  10000  2017-11-11  2018-5-11
    """
    school = models.ForeignKey(verbose_name=\'校区\', to=\'School\')
    course = models.ForeignKey(verbose_name=\'课程名称\', to=\'Course\')
    semester = models.IntegerField(verbose_name="班级(期)")
    price = models.IntegerField(verbose_name="学费")
    start_date = models.DateField(verbose_name="开班日期")
    graduate_date = models.DateField(verbose_name="结业日期", null=True, blank=True)
    memo = models.CharField(verbose_name=\'说明\', max_length=256, blank=True, null=True, )
    teachers = models.ManyToManyField(verbose_name=\'任课老师\', to=\'UserInfo\', related_name=\'teach_classes\',limit_choices_to={\'depart_id__in\':[1003,1004,]})
    tutor = models.ForeignKey(verbose_name=\'班主任\', to=\'UserInfo\', related_name=\'classes\',limit_choices_to={"depart_id":1002})
    def __str__(self):
        return "{0}({1}期)".format(self.course.name, self.semester)
class Customer(models.Model):
    """
    客户表
    """
    qq = models.CharField(verbose_name=\'qq\', max_length=64, unique=True, help_text=\'QQ号必须唯一\')
    name = models.CharField(verbose_name=\'学生姓名\', max_length=16)
    gender_choices = ((1, \'男\'), (2, \'女\'))
    gender = models.SmallIntegerField(verbose_name=\'性别\', choices=gender_choices)
    education_choices = (
        (1, \'重点大学\'),
        (2, \'普通本科\'),
        (3, \'独立院校\'),
        (4, \'民办本科\'),
        (5, \'大专\'),
        (6, \'民办专科\'),
        (7, \'高中\'),
        (8, \'其他\')
    )
    education = models.IntegerField(verbose_name=\'学历\', choices=education_choices, blank=True, null=True, )
    graduation_school = models.CharField(verbose_name=\'毕业学校\', max_length=64, blank=True, null=True)
    major = models.CharField(verbose_name=\'所学专业\', max_length=64, blank=True, null=True)
    experience_choices = [
        (1, \'在校生\'),
        (2, \'应届毕业\'),
        (3, \'半年以内\'),
        (4, \'半年至一年\'),
        (5, \'一年至三年\'),
        (6, \'三年至五年\'),
        (7, \'五年以上\'),
    ]
    experience = models.IntegerField(verbose_name=\'工作经验\', blank=True, null=True, choices=experience_choices)
    work_status_choices = [
        (1, \'在职\'),
        (2, \'无业\')
    ]
    work_status = models.IntegerField(verbose_name="职业状态", choices=work_status_choices, default=1, blank=True,
                                      null=True)
    company = models.CharField(verbose_name="目前就职公司", max_length=64, blank=True, null=True)
    salary = models.CharField(verbose_name="当前薪资", max_length=64, blank=True, null=True)
    source_choices = [
        (1, "qq群"),
        (2, "内部转介绍"),
        (3, "官方网站"),
        (4, "百度推广"),
        (5, "360推广"),
        (6, "搜狗推广"),
        (7, "腾讯课堂"),
        (8, "广点通"),
        (9, "高校宣讲"),
        (10, "渠道代理"),
        (11, "51cto"),
        (12, "智汇推"),
        (13, "网盟"),
        (14, "DSP"),
        (15, "SEO"),
        (16, "其它"),
    ]
    source = models.SmallIntegerField(\'客户来源\', choices=source_choices, default=1)
    referral_from = models.ForeignKey(
        \'self\',
        blank=True,
        null=True,
        verbose_name="转介绍自学员",
        help_text="若此客户是转介绍自内部学员,请在此处选择内部学员姓名",
        related_name="internal_referral"
    )
    course = models.ManyToManyField(verbose_name="咨询课程", to="Course")
    status_choices = [
        (1, "已报名"),
        (2, "未报名")
    ]
    status = models.IntegerField(
        verbose_name="状态",
        choices=status_choices,
        default=2,
        help_text=u"选择客户此时的状态"
    )
    consultant = models.ForeignKey(verbose_name="课程顾问", to=\'UserInfo\', related_name=\'consultant\',limit_choices_to={\'depart_id\':1001})
    date = models.DateField(verbose_name="咨询日期", auto_now_add=True)
    last_consult_date = models.DateField(verbose_name="最后跟进日期", auto_now_add=True)
    recv_date = models.DateField(verbose_name=\'接单时间\', null=True, blank=True)
    def __str__(self):
        return "姓名:{0},QQ:{1}".format(self.name, self.qq, )
class CustomerDistribution(models.Model):
    """
    客户分配表
    """
    user = models.ForeignKey(verbose_name=\'客户顾问\',to=\'UserInfo\',related_name=\'cds\',limit_choices_to={\'depart_id\':1000})
    customer = models.ForeignKey(verbose_name=\'客户\',to=\'Customer\',related_name=\'dealers\')
    ctime = models.DateField()
    status_choices = (
        (1,\'正在跟进\'),
        (2,\'已成单\'),
        (3,\'3天未跟进\'),
        (4,\'15天未成单\'),
    )
    status = models.IntegerField(verbose_name=\'状态\',choices=status_choices,default=1)
    memo = models.CharField(verbose_name=\'更多信息\',max_length=255)
class SaleRank(models.Model):
    """
    销售权重和数量
    """
    user = models.ForeignKey(to="UserInfo",limit_choices_to={\'depart_id\':1000})
    num = models.IntegerField(verbose_name=\'数量\')
    weight = models.IntegerField(verbose_name=\'权重\')
class ConsultRecord(models.Model):
    """
    客户跟进记录
    """
    customer = models.ForeignKey(verbose_name="所咨询客户", to=\'Customer\')
    consultant = models.ForeignKey(verbose_name="跟踪人", to=\'UserInfo\')
    date = models.DateField(verbose_name="跟进日期", auto_now_add=True)
    note = models.TextField(verbose_name="跟进内容...")
class PaymentRecord(models.Model):
    """
    缴费记录
    """
    customer = models.ForeignKey(Customer, verbose_name="客户")
    class_list = models.ForeignKey(verbose_name="班级", to="ClassList", blank=True, null=True)
    pay_type_choices = [
        (1, "订金/报名费"),
        (2, "学费"),
        (3, "转班"),
        (4, "退学"),
        (5, "退款"),
    ]
    pay_type = models.IntegerField(verbose_name="费用类型", choices=pay_type_choices, default=1)
    paid_fee = models.IntegerField(verbose_name="费用数额", default=0)
    turnover = models.IntegerField(verbose_name="成交金额", blank=True, null=True)
    quote = models.IntegerField(verbose_name="报价金额", blank=True, null=True)
    note = models.TextField(verbose_name="备注", blank=True, null=True)
    date = models.DateTimeField(verbose_name="交款日期", auto_now_add=True)
    consultant = models.ForeignKey(verbose_name="负责老师", to=\'UserInfo\', help_text="谁签的单就选谁")
class Student(models.Model):
    """
    学生表（已报名）
    """
    customer = models.OneToOneField(verbose_name=\'客户信息\', to=\'Customer\')
    username = models.CharField(verbose_name=\'用户名\', max_length=32)
    password = models.CharField(verbose_name=\'密码\', max_length=64)
    emergency_contract = models.CharField(max_length=32, blank=True, null=True, verbose_name=\'紧急联系人\')
    class_list = models.ManyToManyField(verbose_name="已报班级", to=\'ClassList\', blank=True)
    company = models.CharField(verbose_name=\'公司\', max_length=128, blank=True, null=True)
    location = models.CharField(max_length=64, verbose_name=\'所在区域\', blank=True, null=True)
    position = models.CharField(verbose_name=\'岗位\', max_length=64, blank=True, null=True)
    salary = models.IntegerField(verbose_name=\'薪资\', blank=True, null=True)
    welfare = models.CharField(verbose_name=\'福利\', max_length=256, blank=True, null=True)
    date = models.DateField(verbose_name=\'入职时间\', help_text=\'格式yyyy-mm-dd\', blank=True, null=True)
    memo = models.CharField(verbose_name=\'备注\', max_length=256, blank=True, null=True)
    def __str__(self):
        return self.username
class CourseRecord(models.Model):
    """
    上课记录表
    """
    class_obj = models.ForeignKey(verbose_name="班级", to="ClassList")
    day_num = models.IntegerField(verbose_name="节次", help_text=u"此处填写第几节课或第几天课程...,必须为数字")
    teacher = models.ForeignKey(verbose_name="讲师", to=\'UserInfo\')
    date = models.DateField(verbose_name="上课日期", auto_now_add=True)
    course_title = models.CharField(verbose_name=\'本节课程标题\', max_length=64, blank=True, null=True)
    course_memo = models.TextField(verbose_name=\'本节课程内容概要\', blank=True, null=True)
    has_homework = models.BooleanField(default=True, verbose_name="本节有作业")
    homework_title = models.CharField(verbose_name=\'本节作业标题\', max_length=64, blank=True, null=True)
    homework_memo = models.TextField(verbose_name=\'作业描述\', max_length=500, blank=True, null=True)
    exam = models.TextField(verbose_name=\'踩分点\', max_length=300, blank=True, null=True)
    def __str__(self):
        return "{0} day{1}".format(self.class_obj, self.day_num)
class StudyRecord(models.Model):
    course_record = models.ForeignKey(verbose_name="第几天课程", to="CourseRecord")
    student = models.ForeignKey(verbose_name="学员", to=\'Student\')
    record_choices = ((\'checked\', "已签到"),
                      (\'vacate\', "请假"),
                      (\'late\', "迟到"),
                      (\'noshow\', "缺勤"),
                      (\'leave_early\', "早退"),
                      )
    record = models.CharField("上课纪录", choices=record_choices, default="checked", max_length=64)
    score_choices = ((100, \'A+\'),
                     (90, \'A\'),
                     (85, \'B+\'),
                     (80, \'B\'),
                     (70, \'B-\'),
                     (60, \'C+\'),
                     (50, \'C\'),
                     (40, \'C-\'),
                     (0, \' D\'),
                     (-1, \'N/A\'),
                     (-100, \'COPY\'),
                     (-1000, \'FAIL\'),
                     )
    score = models.IntegerField("本节成绩", choices=score_choices, default=-1)
    homework_note = models.CharField(verbose_name=\'作业评语\', max_length=255, blank=True, null=True)
    note = models.CharField(verbose_name="备注", max_length=255, blank=True, null=True)
    homework = models.FileField(verbose_name=\'作业文件\', blank=True, null=True, default=None)
    stu_memo = models.TextField(verbose_name=\'学员备注\', blank=True, null=True)
    date = models.DateTimeField(verbose_name=\'提交作业日期\', auto_now_add=True)
    def __str__(self):
        return "{0}-{1}".format(self.course_record, self.student)

from django.db import models
class Menu(models.Model):
    \'\'\'
    菜单表
    \'\'\'
    title=models.CharField(max_length=32,verbose_name="菜单名称")
    def __str__(self):
        return self.title
class Group(models.Model):
    \'\'\'
    权限组
    \'\'\'
    caption=models.CharField(max_length=32,verbose_name="组名称")
    menu=models.ForeignKey(verbose_name="所属菜单",to="Menu",default=1)
    def __str__(self):
        return self.caption
class Permission(models.Model):
    """
    权限表
    """
    title = models.CharField(verbose_name=\'标题\',max_length=32)
    url = models.CharField(verbose_name="含正则URL",max_length=64)
    # is_menu = models.BooleanField(verbose_name="是否是菜单")
    menu_gp=models.ForeignKey(verbose_name="组内菜单",to="Permission",null=True,blank=True)
    code=models.CharField(max_length=32,verbose_name="代码",default="list")
    group=models.ForeignKey(verbose_name="s所在权限组",to="Group",default=1)
    class Meta:
        verbose_name_plural = "权限表"
 
    def __str__(self):
        return self.title
class User(models.Model):
    """
    用户表
    """
    username = models.CharField(verbose_name=\'用户名\',max_length=32)
    password = models.CharField(verbose_name=\'密码\',max_length=64)
    email = models.CharField(verbose_name=\'邮箱\',max_length=32)
    roles = models.ManyToManyField(verbose_name=\'具有的所有角色\',to="Role",blank=True)
    class Meta:
        verbose_name_plural = "用户表"
 
    def __str__(self):
        return self.username
class Role(models.Model):
    """
    角色表
    """
    title = models.CharField(max_length=32)
    permissions = models.ManyToManyField(verbose_name=\'具有的所有权限\',to=\'Permission\',blank=True)
    class Meta:
        verbose_name_plural = "角色表"
 
    def __str__(self):
        return self.title

from django.db import models
# Create your models here.
class UserInfo(models.Model):
    \'\'\'
    用户表
    \'\'\'
    username=models.CharField(max_length=32,verbose_name="用户名")
    pwd=models.CharField(max_length=32,verbose_name="密码")
    def __str__(self):
        return self.username
    class Meta:
        verbose_name_plural="用户表"
 
 
class ClassList(models.Model):
    \'\'\'
    班级表
    \'\'\'
    title=models.CharField(max_length=64,verbose_name="班级名称")
    def __str__(self):
        return self.title
    class Meta:
        verbose_name_plural="班级表"
 
class Student(models.Model):
    \'\'\'
    学生表
    \'\'\'
    username = models.CharField(max_length=32,verbose_name="姓名")
    pwd=models.CharField(max_length=32,verbose_name="姓名")
    cls = models.ForeignKey(to=ClassList,verbose_name="所属班级")
    def __str__(self):
        return self.username
    class Meta:
        verbose_name_plural="学生表"
 
class QuestionSuv(models.Model):
    \'\'\'
    问卷表
    \'\'\'
    title=models.CharField(max_length=32,verbose_name="问卷名称")
    create_time = models.DateTimeField(verbose_name=\'创建时间\', auto_now_add=True)
    end_time = models.DateTimeField(verbose_name="结束时间",null=True)
    classobj=models.ForeignKey(to=ClassList,verbose_name="班级")
    userInfoobj=models.ForeignKey(to=UserInfo,verbose_name="创建人")
    def __str__(self):
        return self.title
    class Meta:
        verbose_name_plural="问卷表"
 
class Question(models.Model):
    \'\'\'
    问题表
    \'\'\'
    title=models.CharField(max_length=32,verbose_name="问题名称")
    question_type=(
        (1,"单选"),
        (2,"打分"),
        (3,"建议")
    )
    type=models.IntegerField(choices=question_type,verbose_name="问题类型")
    questionSuv=models.ManyToManyField(to=QuestionSuv,verbose_name="所属问卷")
    def __str__(self):
        return self.title
    class Meta:
        verbose_name_plural="问题表"
 
 
class Option(models.Model):
    \'\'\'
    单选表
    \'\'\'
    title=models.CharField(max_length=32,verbose_name="选项名称")
    value=models.IntegerField(verbose_name="选项所对应的分值")
    question = models.ForeignKey(to=Question,verbose_name="所属问题")
    def __str__(self):
        return self.title
    class Meta:
        verbose_name_plural="单选表"
 
class Answer(models.Model):
    \'\'\'
    答案表
    \'\'\'
    stu=models.ForeignKey(to=Student,verbose_name="所属学生")
    question=models.ForeignKey(to=Question,verbose_name="所属问题")
    option=models.ForeignKey(to=Option,null=True,blank=True,verbose_name="所属单选表")
    value=models.IntegerField(null=True,blank=True,verbose_name="打分表的分值")
    content=models.CharField(max_length=255,null=True,blank=True,verbose_name="建议表的内容")
    questionSuv=models.ForeignKey(to=QuestionSuv,null=True)
    class Meta:
        verbose_name_plural="答案表"

from django.db import models
# Create your models here.
 
class Room(models.Model):
    name=models.CharField(max_length=32,verbose_name=\'会议室名称\')
    def __str__(self):
        return self.name
    class Meta:
        verbose_name_plural=\'会议室\'
 
class UserInfo(models.Model):
    name=models.CharField(max_length=32,verbose_name=\'用户名\')
    pwd=models.CharField(max_length=32,verbose_name=\'密码\')
    def __str__(self):
        return self.name
    class Meta:
        verbose_name_plural=\'用户表\'
 
class Book(models.Model):
    date=models.DateField(max_length=32,verbose_name=\'日期\')
    time_choice=((1,"8:00"),(2,\'9:00\'),(3,\'10:00\'),(4,\'11:00\'),(5,\'12:00\'),(6,\'13:00\'),
                 (7,\'14:00\'),(8,\'15:00\'),(9,\'16:00\'),(10,\'17:00\'),(11,\'18:00\'),(12,\'19:00\'),
                 (13,\'20:00\'),
                 )
    time=models.IntegerField(choices=time_choice,verbose_name=\'时间段\')
    room=models.ForeignKey(\'Room\',verbose_name=\'会议室\')
    user=models.ForeignKey(\'UserInfo\',verbose_name=\'用户\',null=True)
    class Meta:
        verbose_name_plural=\'预定表\'
        unique_together=(
            (\'date\',\'time\',\'room\'),
        )

import os
import sys
import django
sys.path.append(r\'D:\test\DjangoTest\crm\')
os.chdir(r\'D:\test\DjangoTest\crm\')
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "crm.settings")
django.setup()
import redis
POOL = redis.ConnectionPool(host=\'192.168.20.150\', port=6379, password=\'\')
CONN = redis.Redis(connection_pool=POOL)
class Tiga(object):
    users = None  # [1,2,1,2,3,1,...]
    iter_users = None  # iter([1,2,1,2,3,1,...])
    reset_status = False
    rollback_list = []
    @classmethod
    def fetch_users(cls):
        from app01 import models
        sales = models.SaleRank.objects.all().order_by(\'-weight\')
        item = []
        # 方法一
        # d={}
        # for sale in sales:
        #     #print(sale.user.name, sale.user_id,sale.num,sale.weight)
        #     d[sale.user.id]=sale.num
        # print(d)
        # sum=0
        # for k,v in d.items():
        #     sum+=int(v)
        # print(sum)
        # for i in range(sum):
        #     for k,v in d.items():
        #         if item.count(k)>=v:
        #             continue
        #         else:
        #             item.append(k)
        #         if len(item)>sum:
        #             break
 
        # 方法二:
        count = 0
        while True:
            flag = False
            for sale in sales:
                if count < sale.num:
                    item.append(sale.user_id)
                    flag = True
            count += 1
            if not flag:
                break
 
        if item:
            CONN.rpush(\'ctz_sale_id_list\', *item)
            CONN.rpush(\'ctz_sale_id_list_origin\', *item)
            return True
        else:
            return False
    @classmethod
    def get_sale_id(cls):
        origin_count = CONN.llen(\'ctz_sale_id_list_origin\')
        if not origin_count:
            status = cls.fetch_users()
            if not status:
                return None
        sale_id = CONN.lpop(\'ctz_sale_id_list\')
        if sale_id:
            return sale_id
        reset = CONN.rpop(\'ctz_reset_id\')
        if reset:
            CONN.delete(\'ctz_sale_id_list_origin\')
            status = cls.fetch_users()
            if not status:
                return None
            CONN.delete(\'ctz_reset_id\')
            return CONN.lpop(\'ctz_sale_id_list\')
        else:
            count = CONN.llen(\'ctz_sale_id_list_origin\')
            for i in range(count):
                v = CONN.lindex(\'ctz_sale_id_list_origin\', i)
                CONN.rpush(\'ctz_sale_id_list\', v)
            return CONN.lpop(\'ctz_sale_id_list\')
            # if cls.rollback_list:
            #     return cls.rollback_list.pop()
            # if not cls.users:
            #     cls.fetch_users()
            # if not cls.iter_users:
            #     cls.iter_users = iter(cls.users)
            # try:
            #     user_id = next(cls.iter_users)
            # except StopIteration as e:
            #     if cls.reset_status:
            #         cls.fetch_users()
            #         cls.reset_status = False
            #     cls.iter_users = iter(cls.users)
            #     user_id = cls.get_sale_id()
            # return user_id
    @classmethod
    def reset(cls):
        CONN.rpush(\'ctz_reset_id\', 1)
    @classmethod
    def rollback(cls, nid):
        CONN.lpush(\'ctz_sale_id_list\', nid)
Tiga.fetch_users()

 def singleInput_view(self, request):
        if request.method == \'GET\':
            form = SingleModelForm()
            return render(request, \'singleInput.html\', {\'form\': form})
        else:
            """客户表新增数据：
                             - 获取该分配的课程顾问id
                             - 当前时间
                          客户分配表中新增数据
                             - 获取新创建的客户ID
                             - 顾问ID
                          """
            form = SingleModelForm(data=request.POST)
            if form.is_valid():
                from tiga1 import Tiga
                user_id = Tiga.get_sale_id()
                if not user_id:
                    return HttpResponse(\'无销售顾问,无法进行分配\')
                try:
                    with transaction.atomic():
                        now_date = datetime.datetime.now().date()
                        # form.cleaned_data[\'consultant_id\'] = user_id
                        # form.cleaned_data[\'status\'] = 2
                        # form.cleaned_data[\'last_consult_date\'] = now_date
                        # form.cleaned_data[\'recv_date\'] = now_date
                        # course = form.cleaned_data.pop(\'course\')
                        # customer = models.Customer.objects.create(**form.cleaned_data)
                        # print(form)
                        # customer.course.add(*course)
                        form.instance.consultant_id = user_id
                        form.instance.last_consult_date = now_date
                        form.instance.recv_date = now_date
                        customer = form.save()
                        print(customer)
                        print(\'.....\')
                        models.CustomerDistribution.objects.create(customer=customer, user_id=user_id, ctime=now_date)
                        body = \'给你分配新用户了\'
                        print(564123)
                        message.send_message(\'分配新用户\', body, \'1789920207@qq.com\', \'zjm\')
                except Exception as e:
                    # Tiga.rollback(user_id)
                    return HttpResponse(\'录入异常\')
                return redirect(\'/stark/app01/customer/\')
            return render(request, \'singleInput.html\', {\'form\': form})
    def multiInput_view(self, request):
        if request.method == \'GET\':
            return render(request, \'multiInput.html\')
        else:
            from tiga1 import Tiga
            user_id = Tiga.get_sale_id()
            now_date = datetime.datetime.now().date()
            fileObj = request.FILES.get(\'file\')
            # with open(\'multiInput.xlsx\', \'wb\')as f:
            #     for chuck in fileObj:
            #         f.write(chuck)
 
            import xlrd
            #workbook = xlrd.open_workbook(\'multiInput.xlsx\')
            workbook = xlrd.open_workbook(file_contents=fileObj.read())
            sheet = workbook.sheet_by_index(0)
            maps = {
                0: \'qq\',
                1: \'name\',
                2: \'gender\',
                3: \'course\',
            }
            for index in range(1, sheet.nrows):
                row = sheet.row(index)
                dic = {}
                for i in maps:
                    key = maps[i]
                    cell = row[i]
                    if i in (0, 2):
                        dic[key] = int(cell.value)
                    elif i == 1:
                        dic[key] = cell.value
                    else:
                        course_id = cell.value
                        course_list_str = course_id.split(\'_\')
                        course_list_int = []
                        for i in course_list_str:
                            course_list_int.append(int(i))
                        dic[key] = course_list_int
                print(dic)
                try:
                    with transaction.atomic():
                        dic[\'consultant_id\'] = user_id
                        dic[\'recv_date\'] = now_date
                        print(dic)
                        print(type(dic[\'qq\']))
                        course_list = dic.pop(\'course\')
                        print(dic)
                        print(course_list)
                        customer = models.Customer.objects.create(**dic)
                        customer.course.add(*course_list)
                        print(customer)
                        models.CustomerDistribution.objects.create(customer=customer, user_id=user_id, ctime=now_date)
                except Exception as e:
                    Tiga.rollback(user_id)
                    return HttpResponse(\'批量导入出现异常\')
            return HttpResponse(\'ok\')