class CarList(db.Model):
__tablename__ = 'car_lists'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(25), unique=True)
car_status = db.Column(db.String(10))
company = db.Column(db.String(10))
car_procedure_infos = db.relationship('CarProcedureInfo', backref='cars', lazy='dynamic')
class ProcedureNode(db.Model):
__tablename__ = 'procedure_nodes'
procedure_node_id = db.Column(db.Integer, primary_key=True)
procedure_node_flowmodal = db.Column(db.String(50))
procedure_node_name = db.Column(db.String(25))
parent_id = db.Column(db.Integer)
procedure_node_role = db.Column(db.String(25))
procedure_node_escription = db.Column(db.String(25))
class House(db.Model): # 这是房间表
__tablename__ = 'houses'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(15))
size=db.Column(db.String(15))
company = db.Column(db.String(10))
def __str__(self):
return self.name
class FieldPermission(db.Model):
__tablename__ = 'field_permissions'
field_permission_id = db.Column(db.Integer, primary_key=True)
field_permission_flowmodal = db.Column(db.String(50))
field_permission_node = db.Column(db.Integer)
field_permission_field_name = db.Column(db.String(25))
field_permission_read = db.Column(db.String(25))
field_permission_write = db.Column(db.String(25))
field_permission_company = db.Column(db.String(20))
class ProcedureLine(db.Model):
__tablename__ = 'procedure_lines'
procedure_line_id = db.Column(db.Integer, primary_key=True)
procedure_line_flowmodal = db.Column(db.String(50))
procedure_line_pre_line_id = db.Column(db.Integer)
procedure_line_pre_line_name = db.Column(db.String(25))
procedure_line_next_line_id = db.Column(db.Integer)
procedure_line_next_line_name = db.Column(db.String(25))
procedure_line_description = db.Column(db.String(25))
class ProcedureState(db.Model):
__tablename__ = 'procedure_states'
procedure_state_id = db.Column(db.Integer, primary_key=True)
procedure_state_flowid = db.Column(db.String(50))
procedure_state = db.Column(db.Integer)
procedure_state_name = db.Column(db.String(25))
procedure_state_flowmodal = db.Column(db.String(25))
procedure_state_procedure_list_name = db.Column(db.String(25))
procedure_state_user_id = db.Column(db.Integer)
procedure_state_approval_datetime = db.Column(db.DateTime())
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
firstname = db.Column(db.String(50))
lastname = db.Column(db.String(50))
email = db.Column(db.String(120))
pictures = db.relationship("Picture", back_populates="user")
def __init__(self, firstname, lastname, email=None):
self.firstname = firstname
self.lastname = lastname
self.email = email
class ProcedureApproval(db.Model):
__tablename__ = 'procedure_approvals'
procedure_approval_id = db.Column(db.Integer, primary_key=True)
procedure_approval_flowid = db.Column(db.String(50))
procedure_approval_flowname = db.Column(db.String(50))
procedure_approval_current_line_node_id = db.Column(db.Integer)
procedure_approval_user_id = db.Column(db.Integer)
procedure_approval_flowmodal = db.Column(db.String(25))
procedure_approval_reason = db.Column(db.String(25))
procedure_approval_approval_datetime = db.Column(db.DateTime())
procedure_approval_state = db.Column(db.Integer)
procedure_approval_company = db.Column(db.String(10))
class ProcedureList(db.Model):
__tablename__ = 'procedure_lists'
procedure_list_id = db.Column(db.Integer, primary_key=True)
procedure_list_flowmodal = db.Column(db.String(50))
procedure_list_name = db.Column(db.String(20), unique=True)
procedure_lists = db.relationship("CarProcedureInfo", backref="procedure_name", lazy='dynamic')
# procedure_list_department = db.Column(db.String(20))
#
# procedure_list_departmentid = db.Column(db.Integer, db.ForeignKey("company_departments.id"))
# departments = db.relationship('CompanyDepartment', foreign_keys=[procedure_list_departmentid], backref="users",
# single_parent=True)
procedure_list_company = db.Column(db.String(20))
procedure_list_address = db.Column(db.String(40))
class CompanyDepartment(db.Model):
__tablename__ = 'company_departments'
id = db.Column(db.Integer, primary_key=True)
company = db.Column(db.String(20))
department = db.Column(db.String(20))
status = db.Column(db.String(10))
def jsonstr(self):
jsonstr = {
"department_id": self.id,
"alterdepartmentname": self.department,
"alterstatus": self.status,
}
return jsonstr
class Role(db.Model):
__tablename__ = 'roles'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), unique=True)
default = db.Column(db.Boolean, default=False, index=True)
permissions = db.Column(db.Integer)
users = db.relationship('User', backref='role', lazy='dynamic')
def __init__(self, **kwargs):
super(Role, self).__init__(**kwargs)
if self.permissions is None:
self.permissions = 0
def has_permission(self, perm):
return self.permissions & perm == perm
def add_permission(self, perm):
if not self.has_permission(perm):
self.permissions += perm
def remove_permission(self, perm):
if self.has_permission(perm):
self.permissions -= perm
def reset_permissions(self):
self.permissions = 0
class Picture(db.Model):
__tablename__ = 'picture'
id = db.Column(db.Integer, primary_key=True)
path = db.Column(db.String(250))
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
user = db.relationship("User", back_populates="pictures")
def __init__(self, path, user):
self.path = path
self.user = user
class PackageProcedureInfo(db.Model):
__tablename__ = 'package_procedure_infos'
id = db.Column(db.String(36), primary_key=True)
procedure_list_id = db.Column(db.Integer)
procedure_list_flowmodal = db.Column(db.String(50))
procedure_name = db.Column(db.String(15))
logistics_company_id = db.Column(db.Integer, db.ForeignKey("logistics_company_lists.id"))
package_infos = db.relationship('LogisticCompanyList', foreign_keys=[logistics_company_id],
backref="package_procedure_infos_logistics_companys",
single_parent=True)
num = db.Column(db.String(50))
destination_company = db.Column(db.String(100))
package_name = db.Column(db.String(50))
payment_method = db.Column(db.String(15))
approval_user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
approval_users = db.relationship('User', foreign_keys=[approval_user_id],
backref="package_procedure_infos_approval_users",
single_parent=True)
# approval_department = db.Column(db.String(15))
# approval_departmentid= db.Column(db.Integer)
# approval_departmentid = db.Column(db.Integer, db.ForeignKey("company_departments.id"))
# approval_departments = db.relationship('CompanyDepartment', foreign_keys=[approval_departmentid],
# backref="package_procedure_infos_approval",
# single_parent=True)
collect_user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
collect_users = db.relationship('User', foreign_keys=[collect_user_id],
backref="package_procedure_infos_collect_users",
single_parent=True)
# collect_department = db.Column(db.String(15))
# collect_departmentid = db.Column(db.Integer)
collect_departmentid = db.Column(db.Integer, db.ForeignKey("company_departments.id"))
collect_departments = db.relationship('CompanyDepartment', foreign_keys=[collect_departmentid],
backref="package_procedure_infos_collect",
single_parent=True)
# status = db.Column(db.String(15))
approval_time = db.Column(db.DateTime(), default=datetime.now)
confirm_time = db.Column(db.DateTime())
current_line_node_id = db.Column(db.Integer)
state = db.Column(db.Integer)
def jsonstr(self):
jsonstr = {
"id": self.id,
"logistics_company": self.package_infos.company_name,
"num": self.num,
"destination_company": self.destination_company,
"package_name": self.package_name,
"payment_method": self.payment_method,
"approval_person": self.approval_users.username,
"approval_department": self.approval_users.departments.department,
"collect_person": self.collect_users.username,
"collect_department": self.collect_users.departments.department,
"approval_time": self.approval_time.strftime("%Y-%m-%d %H:%M:%S"),
"confirm_time": self.confirm_time.strftime("%Y-%m-%d %H:%M:%S"),
}
return jsonstr
class Order(db.Model): # 这是会议室预定记录表
__tablename__ = 'orders'
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.Date())
user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
users = db.relationship('User', foreign_keys=[user_id],
backref="orders_users",
single_parent=True)
house_id = db.Column(db.Integer, db.ForeignKey("houses.id"))
houses = db.relationship('House', foreign_keys=[house_id],
backref="orders_houses",
single_parent=True)
time = db.Column(db.Integer)
company = db.Column(db.String(10))
# 创建联合唯一索引
__table_args__ = (db.UniqueConstraint('date', 'time', "house_id","company"),)
def __str__(self):
return self.name
class User(UserMixin, db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), unique=True, index=True)
# department = db.Column(db.String(64))
departmentid = db.Column(db.Integer, db.ForeignKey("company_departments.id"))
departments = db.relationship('CompanyDepartment', foreign_keys=[departmentid], backref="users",
single_parent=True)
company = db.Column(db.String(64))
tel = db.Column(db.String(15))
password_hash = db.Column(db.String(128))
role_id = db.Column(db.Integer, db.ForeignKey('roles.id'))
status = db.Column(db.String(10))
# car_procedure_infos = db.relationship('CarProcedureInfo', foreign_keys=[])
# car_procedure_infos_first = db.relationship('CarProcedureInfo', backref='first_users', lazy='dynamic')
# car_procedure_infos_second = db.relationship('CarProcedureInfo', backref='second_users', lazy='dynamic')
# car_procedure_infos_confirm = db.relationship('CarProcedureInfo', backref='confirm_users', lazy='dynamic')
def __init__(self, **kwargs):
super(User, self).__init__(**kwargs)
# if self.role is None:
# if self.email == current_app.config['FLASKY_ADMIN']:
# self.role = Role.query.filter_by(name='Administrator').first()
# if self.role is None:
# self.role = Role.query.filter_by(default=True).first()
# if self.email is not None and self.avatar_hash is None:
# self.avatar_hash = self.gravatar_hash()
# self.follow(self)
@property
def password(self):
raise AttributeError('password is not a readable attribute')
@password.setter
def password(self, password):
self.password_hash = generate_password_hash(password)
def verify_password(self, password):
return check_password_hash(self.password_hash, password)
def can(self, perm):
return self.role is not None and self.role.has_permission(perm)
def is_administrator(self):
return self.can(Permission.ADMIN)
def ping(self):
self.last_seen = datetime.utcnow()
db.session.add(self)
def jsonstr(self):
jsonstr = {
"user_id": self.id,
"altername": self.username,
"alterdepartment": self.departmentid,
"altertel": self.tel,
"alterrolename": self.role.name,
"alterroleid": self.role_id,
"alterstatus": "1" if self.status == "正常" else "0",
}
return jsonstr
class LogisticCompanyList(db.Model):
__tablename__ = 'logistics_company_lists'
id = db.Column(db.Integer, primary_key=True)
company_name = db.Column(db.String(25), unique=True)
company_status = db.Column(db.Integer)
class CarProcedureInfo(db.Model):
__tablename__ = 'car_procedure_infos'
id = db.Column(db.String(36), primary_key=True)
procedure_list_id = db.Column(db.Integer, db.ForeignKey('procedure_lists.procedure_list_id'))
procedure_list_flowmodal = db.Column(db.String(50))
user_id = db.Column(db.Integer, db.ForeignKey('users.id'))
tel = db.Column(db.String(15))
users = db.relationship('User', foreign_keys=user_id, backref="car_procedure_infos",
single_parent=True)
department = db.Column(db.String(64))
departmentid = db.Column(db.Integer, db.ForeignKey("company_departments.id"))
departments = db.relationship('CompanyDepartment', foreign_keys=[departmentid], backref="car_procedure_infos",
single_parent=True)
car_id = db.Column(db.Integer, db.ForeignKey('car_lists.id'))
approval_time = db.Column(db.DateTime(), default=datetime.now)
book_start_datetime = db.Column(db.DATETIME())
book_end_datetime = db.Column(db.DATETIME())
actual_start_datetime = db.Column(db.DATETIME())
actual_end_datetime = db.Column(db.DATETIME())
number = db.Column(db.String(20))
namelist = db.Column(db.String(50))
reason = db.Column(db.String(128))
etc = db.Column(db.Boolean, default=False)
arrival_place = db.Column(db.String(30))
# first_approval = db.Column(db.Integer, db.ForeignKey('users.id'))
# first_users = db.relationship('User', foreign_keys=[first_approval], backref="car_procedure_infos_first",
# single_parent=True)
# status1 = db.Column(db.Integer)
# second_approval = db.Column(db.Integer, db.ForeignKey('users.id'))
# second_users = db.relationship('User', foreign_keys=[second_approval], backref="car_procedure_infos_second",
# single_parent=True)
# status2 = db.Column(db.Integer)
# confirmer = db.Column(db.Integer, db.ForeignKey('users.id'))
# car_procedure_infos_confirm = db.relationship('User', foreign_keys=[confirmer],
# backref="car_procedure_infos_confirm", single_parent=True)
miles = db.Column(db.Integer)
outmiles = db.Column(db.Integer)
company = db.Column(db.String(10))
driver = db.Column(db.String(10))
# rejectreason = db.Column(db.String(100))
# procedure_no = db.Column(db.Integer)
current_line_node_id = db.Column(db.Integer)
state = db.Column(db.Integer)
def jsonstr(self):
jsonstr = {
"id": self.id,
"user_name": self.users.username if self.user_id else "",
"tel": self.tel,
"department": self.department,
"car_name": self.cars.name if self.car_id else "",
"approval_time": self.approval_time.strftime("%Y-%m-%d %H:%M:%S") if self.approval_time else "",
"book_start_datetime": self.book_start_datetime.strftime(
"%Y-%m-%d %H:%M:%S") if self.book_start_datetime else "",
"book_end_datetime": self.book_end_datetime.strftime("%Y-%m-%d %H:%M:%S") if self.book_end_datetime else "",
"actual_start_datetime": self.actual_start_datetime.strftime(
"%Y-%m-%d %H:%M:%S") if self.actual_start_datetime else "",
"actual_end_datetime": self.actual_end_datetime.strftime(
"%Y-%m-%d %H:%M:%S") if self.actual_end_datetime else "",
"number": self.number,
"namelist": self.namelist,
"reason": self.reason,
"etc": "使用ETC" if self.etc else "未使用ETC",
"arrival_place": self.arrival_place,
# "first_approval": self.first_users.username if self.first_approval else "",
# "status1": "一级审批中" if self.status1 == 0 else "审批通过" if self.status1 == 1 else "一级审批被拒绝",
# "second_approval": self.second_users.username if self.second_approval else "",
# "status2": "二级审批中" if self.status2 == 0 else "审批通过" if self.status2 == 1 else "二级审批被拒绝",
# "confirmer": self.car_procedure_infos_confirm.username if self.confirmer else "",
"miles": self.miles,
"outmiles": self.outmiles,
"company": self.company,
# "rejectreason": self.rejectreason,
"driver": self.driver
}
return jsonstr