class Users(db.Model):
username = db.Column(db.String(20),unique=True,primary_key=True)
password = db.Column(db.String(20))
root = db.Column(db.String(2))
def __init__(self, username, password, root):
self.username = username
self.password = password
self.root = root
def __str__(self):
return "Users(username='******')" % self.username
class Project_salary(db.Model):
project_salary_id = db.Column(db.String(20), unique=True,
primary_key=True) #工资编号
project_id = db.Column(db.String(20)) #项目编号
project_name = db.Column(db.String(20)) #项目名称
customer_id = db.Column(db.String(20)) #客户编号
employee_id = db.Column(db.String(20)) # 员工编号
quality = db.Column(db.Float) # 员工完成该项目的质量，提成=该项目金额/员工的个数*质量
project_money = db.Column(db.Float) # 项目金额
employee_money = db.Column(db.Float) #员工提成
def __init__(self, project_salary_id, project_id, project_name,
customer_id, employee_id, quality, project_money,
employee_money):
self.project_salary_id = project_salary_id
self.project_id = project_id
self.project_name = project_name
self.customer_id = customer_id
self.employee_id = employee_id
self.quality = quality
self.project_money = project_money
self.employee_money = employee_money
def __str__(self):
return "Project_salary(project_salary_id='%s')" % self.project_salary_id
class Project(db.Model):
project_id = db.Column(db.String(20), unique=True, primary_key=True) #项目Id
project_name = db.Column(db.String(20), nullable=False) #项目名称
customer_id = db.Column(db.String(20), nullable=False) #客户ID
start_date = db.Column(db.DateTime) #开始日期
end_date = db.Column(db.DateTime) #结束日期
project_type = db.Column(db.String(20)) #项目类型
project_money = db.Column(db.Float) #项目金额
status = db.Column(db.Integer) #项目状态
def __init__(self, project_id, project_name, customer_id, start_date,
end_date, project_type, project_money, status):
self.project_id = project_id
self.project_name = project_name
self.customer_id = customer_id
self.start_date = start_date
self.end_date = end_date
self.project_type = project_type
self.project_money = project_money
self.status = status
def __str__(self):
return "Project(project_name='%s')" % self.project_name
class Employee_salary(db.Model):
employee_salary_id = db.Column(db.String(20),unique=True,primary_key=True) #工资编号
employee_id = db.Column(db.String(20)) #员工编号
project_number = db.Column(db.Integer)#项目个数
attendance = db.Column(db.Float)#出勤率
salary = db.Column(db.Float)#员工总工资
date = db.Column(db.DateTime) #日期
def __init__(self, employee_salary_id, employee_id, project_number,attendance
,salary ,date):
self.employee_salary_id = employee_salary_id
self.employee_id = employee_id
self.project_number = project_number
self.attendance = attendance
self.salary = salary
self.date = date
def __str__(self):
return "Employee_salary(employee_salary_id='%s')" % self.employee_salary_id
class Customer(db.Model):
customer_id = db.Column(db.String(20), unique=True,
primary_key=True) #客户ID
customer_name = db.Column(db.String(20)) #客户姓名
customer_rank = db.Column(db.String(20)) #客户等级
customer_phone = db.Column(db.String(20)) #客户电话
customer_qq = db.Column(db.String(20)) #客户qq
customer_email = db.Column(db.String(30)) #客户邮箱
def __init__(self, customer_id, customer_name, customer_rank,
customer_phone, customer_qq, customer_email):
self.customer_id = customer_id
self.customer_name = customer_name
self.customer_rank = customer_rank
self.customer_phone = customer_phone
self.customer_qq = customer_qq
self.customer_email = customer_email
def __str__(self):
return "Customer(customer_name='%s')" % self.customer_name
class Employee(db.Model):
employee_id = db.Column(db.String(20), unique=True,
primary_key=True) #员工ID
employee_name = db.Column(db.String(20)) #员工姓名
employee_phone = db.Column(db.String(20)) # 联系方式
supervisor_id = db.Column(db.String(20)) #主管部门编号，属于哪个部门或属于哪个主管
employee_rank = db.Column(db.String(20)) #分新手和老手
position = db.Column(db.String(20)) #员工职位,1为超级管理员，2为主管，3为员工
def __init__(self, employee_id, employee_name, employee_phone,
supervisor_id, employee_rank, position):
self.employee_id = employee_id
self.employee_name = employee_name
self.employee_phone = employee_phone
self.supervisor_id = supervisor_id
self.employee_rank = employee_rank
self.position = position
def __str__(self):
return "Employee(employee_id='%s')" % self.employee_id
class User(db.Model, db.Timestamp, db.HasProperties, db.FullText):
__fulltext_columns__ = ('first_name', 'last_name')
first_name = db.Column(db.Unicode(64))
last_name = db.Column(db.Unicode(64))
email = db.Column(db.Unicode(255), nullable=False, unique=True)
_password = db.Column(db.UnicodeText, name="password")
_temp_password = db.Column(db.UnicodeText, name="temp_password")
password_expires = db.Column(db.DateTime)
is_staff = db.Column(db.Boolean, nullable=False, default=False)
is_active = db.Column(db.Boolean, nullable=False, default=True)
tick = db.Column(db.Integer, nullable=False, default=0)
last_login_at = db.Column(db.DateTime)
last_request_at = db.Column(db.DateTime)
@staticmethod
def mkpassword(length=16):
return passlib.pwd.genword(length=length)
@staticmethod
def check_password(password, plain_text_password):
return password and plain_text_password and pwd_context.verify(
plain_text_password, password)
def __unicode__(self):
return '{} {} ({})'.format(self.first_name, self.last_name, self.email)
@property
def password(self):
return self._password
@password.setter
def password(self, plain_text_password):
self._password = pwd_context.hash(plain_text_password)
self.password_expires = datetime.utcnow() + timedelta(days=365)
password = synonym('_password', descriptor=password)
@property
def temp_password(self):
return self._temp_password
@temp_password.setter
def temp_password(self, plain_text_password):
self._temp_password = pwd_context.hash(
plain_text_password) if plain_text_password is not None else None
temp_password = synonym('_temp_password', descriptor=temp_password)