crm项目：

一.项目需求分析：

二.思维导图：

三.业务场景分析（用户使用场景）：

四.原型图：

建议用Axure专业软件画

五.开发工具造型：

python

django

mysql

jquery

bootstrap

linux

nginx

pycharm

六.创建项目：

设计表结构

写代码

models.py表设计:
from django.db import models
from django.contrib.auth.models import User

Create your models here.

class UserProfile(models.Model):
"""用户信息表"""
user = models.OneToOneField(User)
name = models.CharField(max_length=64,verbose_name="姓名")
role = models.ManyToManyField("Role",blank=True,null=True)

def __str__(self): #__unicode__
    return self.name

class Role(models.Model):
"""角色表"""
name = models.CharField(max_length=64,unique=True)
menus = models.ManyToManyField("Menus",blank=True)
def str(self):
return self.name

class CustomerInfo(models.Model):
"""客户信息表"""
name = models.CharField(max_length=64,default=None)
contact_type_choices = ((0,'qq'),(1,'微信'),(2,'手机'))
contact_type = models.SmallIntegerField(choices=contact_type_choices,default=0)
contact = models.CharField(max_length=64,unique=True)
source_choices = ((0,'QQ群'),
(1,'51CTO'),
(2,'百度推广'),
(3,'知乎'),
(4,'转介绍'),
(5,'其它'),
)
source = models.SmallIntegerField(choices=source_choices)
referral_from = models.ForeignKey("self",blank=True,null=True,verbose_name="转介绍")
consult_courses = models.ManyToManyField("Course",verbose_name="咨询课程")
consult_content = models.TextField(verbose_name="咨询内容")
status_choices = ((0,'未报名'),(1,'已报名'),(2,'已退学'))
status = models.SmallIntegerField(choices=status_choices)
consultant = models.ForeignKey("UserProfile",verbose_name="课程顾问")
date = models.DateField(auto_now_add=True)

def __str__(self):
    return self.name

class Student(models.Model):
"""学员表"""
customer = models.ForeignKey("CustomerInfo")
class_grades = models.ManyToManyField("ClassList")

def __str__(self):
    return self.customer

class CustomerFollowUp(models.Model):
"""客户跟踪记录表"""
customer = models.ForeignKey("CustomerInfo")
content = models.TextField(verbose_name="跟踪内容")
user = models.ForeignKey("UserProfile",verbose_name="跟进人")
status_choices = ((0,'近期无报名计划'),
(1,'一个月内报名'),
(2,'2周内内报名'),
(3,'已报名'),
)
status = models.SmallIntegerField(choices=status_choices)
date = models.DateField(auto_now_add=True)
def str(self):
return self.content

class Course(models.Model):
"""课程表"""
name = models.CharField(verbose_name='课程名称',max_length=64,unique=True)
price = models.PositiveSmallIntegerField()
period = models.PositiveSmallIntegerField(verbose_name="课程周期(月)",default=5)
outline = models.TextField(verbose_name="大纲")

def __str__(self):
    return self.name

class ClassList(models.Model):
"""班级列表"""
branch = models.ForeignKey("Branch")
course = models.ForeignKey("Course")
class_type_choices = ((0,'脱产'),(1,'周末'),(2,'网络班'))
class_type = models.SmallIntegerField(choices=class_type_choices,default=0)
semester = models.SmallIntegerField(verbose_name="学期")
teachers = models.ManyToManyField("UserProfile",verbose_name="讲师")
start_date = models.DateField("开班日期")
graduate_date = models.DateField("毕业日期",blank=True,null=True)
def str(self):

    return "%s(%s)期" %(self.course.name,self.semester)

class Meta:
    unique_together =  ('branch','class_type','course','semester')

class CourseRecord(models.Model):
"""上课记录"""
class_grade = models.ForeignKey("ClassList",verbose_name="上课班级")
day_num = models.PositiveSmallIntegerField(verbose_name="课程节次")
teacher = models.ForeignKey("UserProfile")
title = models.CharField("本节主题",max_length=64)
content = models.TextField("本节内容")
has_homework = models.BooleanField("本节有作业",default=True)
homework = models.TextField("作业需求",blank=True,null=True)
date = models.DateTimeField(auto_now_add=True)
def str(self):
return "%s第(%s)节" %(self.class_grade,self.day_num)

class Meta:
    unique_together = ('class_grade','day_num')

class StudyRecord(models.Model):
"""学习记录表"""
course_record = models.ForeignKey("CourseRecord")
student = models.ForeignKey("Student")

score_choices = ((100,"A+"),
                 (90,"A"),
                 (85,"B+"),
                 (80,"B"),
                 (75,"B-"),
                 (70,"C+"),
                 (60,"C"),
                 (40,"C-"),
                 (-50,"D"),
                 (0,"N/A"), #not avaliable
                 (-100,"COPY"), #not avaliable
                 )
score = models.SmallIntegerField(choices=score_choices,default=0)
show_choices = ((0,'缺勤'),
                (1,'已签到'),
                (2,'迟到'),
                (3,'早退'),
                )
show_status = models.SmallIntegerField(choices=show_choices,default=1)
note = models.TextField("成绩备注",blank=True,null=True)

date = models.DateTimeField(auto_now_add=True)

def __str__(self):

    return "%s %s %s" %(self.course_record,self.student,self.score)

class Branch(models.Model):
"""校区"""
name = models.CharField(max_length=64,unique=True)
addr = models.CharField(max_length=128,blank=True,null=True)
def str(self):
return self.name

class Menus(models.Model):
"""动态菜单"""
name = models.CharField(max_length=64)
url_type_choices = ((0,'absolute'),(1,'dynamic'))
url_type = models.SmallIntegerField(choices=url_type_choices,default=0)
url_name = models.CharField(max_length=128)

def __str__(self):
    return self.name

class Meta:
    unique_together = ('name','url_name')

return

一.crm项目开发之架构设计