class Budget(db.Model):
__tablename__ = "budget"
bu_id_pk = db.Column(db.Integer, primary_key=True)
bu_name = db.Column(db.String(255), nullable=False)
bu_amount = db.Column(db.Numeric(10,2), nullable=False)
bu_start_date = db.Column(db.Date, nullable=False)
bu_end_date = db.Column(db.Date, nullable=False)
bu_days_count = db.Column(db.Integer, nullable=False)
bu_avg_daily_consumption = db.Column(db.Numeric(10,2), nullable=False)
# sa_id_fk = db.Column(db.Integer, db.ForeignKey('saldo.sa_id_pk'),
# nullable=False)
ms_id_fk = db.Column(db.Integer, db.ForeignKey('money_source.ms_id_pk'),
nullable=False)
acc_id_fk = db.Column(db.Integer, db.ForeignKey('account.id'),
nullable=False)
def __init__(self, name, amount, start_date, end_date):
self.bu_name = name
self.bu_amount = amount
self.bu_start_date = start_date
self.bu_end_date = end_date
self.bu_days_count = self.pv_lkm(start_date, end_date)
self.bu_avg_daily_consumption = self.bu_amount / self.bu_days_count
self.done = False
def pv_lkm(self, before, after):
d1 = before
d2 = after
return abs(d1 - d2).days
class EyeExamReport(db.Model):
report_id = db.Column(db.Integer, primary_key=True)
patient_id = db.Column(db.Integer,
db.ForeignKey(User.id, ondelete="NO ACTION"))
tech_id = db.Column(db.Integer,
db.ForeignKey(Technician.id, ondelete="NO ACTION"),
nullable=False)
expiration_date = db.Column(db.Date(), nullable=False)
l_S = db.Column(db.Numeric(3, 2), nullable=False)
r_S = db.Column(db.Numeric(3, 2), nullable=False)
l_CYL = db.Column(db.Numeric(3, 2))
r_CYL = db.Column(db.Numeric(3, 2))
l_Axis = db.Column(db.Integer)
r_Axis = db.Column(db.Integer)
def __init__(self, patient_id, tech_id, expiration_date, l_S, r_S, l_CYL,
r_CYL, l_Axis, r_Axis):
self.patient_id = patient_id
self.tech_id = tech_id
self.expiration_date = expiration_date
self.l_S = l_S
self.r_S = r_S
self.l_CYL = l_CYL
self.r_CYL = r_CYL
self.l_Axis = l_Axis
self.r_Axis = r_Axis
class Food(db.Model):
__tablename__ = 'food'
id = db.Column(db.Integer, primary_key=True)
platform_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
platform_name = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue())
communities = db.Column(db.String(1000), nullable=False, server_default=db.FetchedValue())
cat_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
date_from = db.Column(db.DateTime, nullable=False)
date_to = db.Column(db.DateTime, nullable=False)
name = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue())
ratio = db.Column(db.Numeric(10, 2), nullable=False, server_default=db.FetchedValue())
market_price = db.Column(db.Numeric(10, 2), nullable=False, server_default=db.FetchedValue())
price = db.Column(db.Numeric(10, 2), nullable=False, server_default=db.FetchedValue())
main_image = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue())
summary = db.Column(db.String(2000), nullable=False, server_default=db.FetchedValue())
stock = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
tags = db.Column(db.String(200), nullable=False, server_default=db.FetchedValue())
status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
month_count = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
total_count = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
view_count = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
comment_count = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
limit_quantity = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
class Food(Base):
account_id = db.Column(db.Integer,
db.ForeignKey('account.id'),
nullable=True)
name = db.Column(db.String(100), nullable=False, index=True)
energy = db.Column(db.Integer, nullable=False)
protein = db.Column(db.Numeric(scale=2), nullable=False)
carb = db.Column(db.Numeric(scale=2), nullable=False)
fat = db.Column(db.Numeric(scale=2), nullable=False)
class PayOrder(db.Model): # 在线购买订单表
__tablename__ = 'pay_order'
__table_args__ = (db.Index('idx_member_id_status', 'member_id',
'status'), )
id = db.Column(db.Integer, primary_key=True)
order_sn = db.Column(db.String(40),
nullable=False,
unique=True,
server_default=db.FetchedValue())
member_id = db.Column(db.BigInteger,
nullable=False,
server_default=db.FetchedValue())
total_price = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue())
yun_price = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue())
pay_price = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue())
pay_sn = db.Column(db.String(128),
nullable=False,
server_default=db.FetchedValue())
prepay_id = db.Column(db.String(128),
nullable=False,
server_default=db.FetchedValue())
note = db.Column(db.Text, nullable=False)
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
express_status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
express_address_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
express_info = db.Column(db.String(1000),
nullable=False,
server_default=db.FetchedValue())
comment_status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
pay_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class RepairLog(db.Model):
__tablename__ = "repair_logs"
id = db.Column(db.Integer, primary_key=True)
machine_id = db.Column(db.Integer,
db.ForeignKey("machine.id"),
nullable=False)
machine = db.relationship("Machine", back_populates="repair_logs")
date = db.Column(db.Date, nullable=False)
description = db.Column(db.String(128), nullable=False)
part_name = db.Column(db.String(64), nullable=False)
part_number = db.Column(db.String(64))
part_cost = db.Column(db.Numeric(10, 2), default=0)
labor_cost = db.Column(db.Numeric(10, 2), default=0)
class Payroll(UserMixin, db.Model):
__tablename__ = 'payroll'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), nullable=False)
email = db.Column(db.String(64), nullable=True)
department= db.Column(db.String(64), nullable=False)
shift = db.Column(db.String(64), nullable=False)
fdate = db.Column(db.String(64), nullable=False)
tdate = db.Column(db.String(64), nullable=False)
sdate = db.Column(db.String(64), nullable=False)
gross = db.Column(db.Numeric(64), nullable=False)
final = db.Column(db.Numeric(64), nullable=False)
status=db.Column(db.String(64), default='Paid')
class FoodSaleChangeLog(db.Model):
__tablename__ = 'food_sale_change_log'
id = db.Column(db.Integer, primary_key=True)
platform_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
community_id = db.Column(db.Integer, nullable=True, server_default=db.FetchedValue())
community_name = db.Column(db.String(100), nullable=True, server_default=db.FetchedValue())
pay_order_item_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
food_id = db.Column(db.Integer, nullable=False, index=True, server_default=db.FetchedValue())
quantity = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
price = db.Column(db.Numeric(10, 2), nullable=False, server_default=db.FetchedValue())
benefit = db.Column(db.Numeric(10, 2), server_default=db.FetchedValue())
member_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
class JobServer(db.Model):
__tablename__ = 'job_server'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50, 'utf8mb4_general_ci'),
nullable=False,
server_default=db.FetchedValue(),
info='服务器名字')
env = db.Column(db.String(100, 'utf8mb4_general_ci'),
nullable=False,
server_default=db.FetchedValue(),
info='支持环境，逗号分割')
note = db.Column(db.String(100, 'utf8mb4_general_ci'),
nullable=False,
server_default=db.FetchedValue(),
info='备注')
cpu_load = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue(),
info='cpu load')
available_mem = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue(),
info='可用内存')
total_mem = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue(),
info='总内存数量')
weight = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='权重')
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='状态 1：有效 0：无效')
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='最后一次更新时间')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='插入时间')
def __init__(self, **items):
for key in items:
if hasattr(self, key):
setattr(self, key, items[key])
class Good(db.Model):
__tablename__ = 'goods'
id = db.Column(db.Integer, primary_key=True)
cat_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='分类id')
name = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='商品名称')
price = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue(),
info='商品价格')
main_image = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='商品主图')
summary = db.Column(db.String(10000),
nullable=False,
server_default=db.FetchedValue(),
info='商品描述')
stock = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='库存数')
tags = db.Column(db.String(200),
nullable=False,
server_default=db.FetchedValue(),
info='tag 标签，用","连接')
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='1:有效，0：无效')
month_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='月销量')
total_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='总销量')
view_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='总浏览次数')
comment_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='总评论数')
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='最后一次更新时间')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='创建时间')
class UserBuyHistory(db.Model):
__tablename__ = 'user_buy_history'
id = db.Column(db.Integer, primary_key=True)
openid = db.Column(db.String(50),
nullable=False,
server_default=db.FetchedValue())
nickname = db.Column(db.String(50),
nullable=False,
server_default=db.FetchedValue())
cat_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
product = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue())
price = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue())
buy_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class ShareItem(db.Model):
__tablename__ = 'share_item'
id = db.Column(db.Integer, primary_key=True)
member_id = db.Column(db.BigInteger,
nullable=False,
index=True,
server_default=db.FetchedValue())
parent_id = db.Column(db.BigInteger,
nullable=False,
server_default=db.FetchedValue())
tree = db.Column(db.String(10000),
nullable=False,
index=True,
server_default=db.FetchedValue())
money = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue())
level = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
CREATE_TIME = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
UPDATE_TIME = db.Column(db.DateTime, nullable=False)
class StatDailyFood(db.Model):
__tablename__ = 'stat_daily_food'
__table_args__ = (db.Index('date_food_id', 'date', 'food_id'), )
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.Date, nullable=False)
food_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='菜品id')
total_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='售卖总数量')
total_pay_money = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue(),
info='总售卖金额')
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='最后一次更新时间')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='插入时间')
class Food(db.Model):
__tablename__ = 'food'
id = db.Column(db.Integer, primary_key=True)
cat_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='分类id')
name = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='书籍名称')
price = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue(),
info='售卖金额')
main_image = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='封面图')
summary = db.Column(db.String(10000),
nullable=False,
server_default=db.FetchedValue(),
info='描述')
stock = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='库存量')
tags = db.Column(db.String(200),
nullable=False,
server_default=db.FetchedValue(),
info='tag关键字，以","连接')
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='状态 1：有效 0：无效')
month_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='月销售数量')
total_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='总销售量')
view_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='总浏览次数')
comment_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='总评论量')
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='最后更新时间')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='最后插入时间')
class RechargeOrder(db.Model):
__tablename__ = 'recharge_order'
__table_args__ = (db.Index('idx_member_id_status', 'member_id',
'status'), )
id = db.Column(db.Integer, primary_key=True)
order_sn = db.Column(db.String(40),
nullable=False,
unique=True,
server_default=db.FetchedValue())
Cid = db.Column(db.BigInteger,
nullable=False,
server_default=db.FetchedValue())
money = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue())
pay_sn = db.Column(db.String(128),
nullable=False,
server_default=db.FetchedValue())
prepay_id = db.Column(db.String(128),
nullable=False,
server_default=db.FetchedValue())
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
pay_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class Goods(db.Model):
__tablename__ = 'goods'
id = db.Column(db.Integer, primary_key=True)
cat_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='??id')
name = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='????')
price = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue(),
info='????')
main_image = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue(),
info='????')
summary = db.Column(db.String(10000),
nullable=False,
server_default=db.FetchedValue(),
info='????')
stock = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='???')
tags = db.Column(db.String(200),
nullable=False,
server_default=db.FetchedValue(),
info='tag ????","??')
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='1:???0???')
month_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='???')
total_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='???')
view_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='?????')
comment_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='????')
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='????????')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='????')
class Transaction(db.Model):
__tablename__ = "transactions"
tr_id_pk = db.Column(db.Integer, primary_key=True)
date_created = db.Column(db.DateTime, default=db.func.current_timestamp())
date_modified = db.Column(db.DateTime, default=db.func.current_timestamp(),
onupdate=db.func.current_timestamp())
tr_date = db.Column(db.Date, nullable=False)
tr_month = db.Column(db.Integer, nullable=False)
tr_amount = db.Column(db.Numeric(10,2), nullable=False)
tr_participant = db.Column(db.String(255))
tr_info = db.Column(db.String(255))
ms_id_fk = db.Column(db.Integer, db.ForeignKey('money_source.ms_id_pk'),
nullable=False)
acc_id_fk = db.Column(db.Integer, db.ForeignKey('account.id'),
nullable=False)
def __init__(self, date, amount, participant,info):
self.tr_date = date
self.tr_month = self.pv2kk(date)
self.tr_amount = amount
self.tr_participant = participant
self.tr_info = info
def pv2kk(self, date):
return date.month
class FoodSaleChangeLog(db.Model):
__tablename__ = 'food_sale_change_log'
id = db.Column(db.Integer, primary_key=True)
food_id = db.Column(db.Integer,
nullable=False,
index=True,
server_default=db.FetchedValue(),
info='??id')
quantity = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='????')
price = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue(),
info='????')
member_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='??id')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='????')
class Createemp(UserMixin, db.Model):
__tablename__ = 'employees'
id = db.Column(db.Integer, primary_key=True)
firstname = db.Column(db.String(64), nullable=False)
lastname = db.Column(db.String(64), nullable=False)
age = db.Column(db.Numeric(64), nullable=False)
gender = db.Column(db.String(64), nullable=False)
# bdate = db.Column(db.String(64), nullable=False)
# jdate = db.Column(db.String(64), nullable=False)
address = db.Column(db.String(64), nullable=False)
email = db.Column(db.String(64), nullable=True)
designation= db.Column(db.String(64), nullable=False)
department= db.Column(db.String(64), nullable=False)
basic = db.Column(db.Numeric(64), nullable=False)
pf = db.Column(db.Numeric(64), nullable=False)
mf = db.Column(db.Numeric(64), nullable=False)
class StatDailyMember(db.Model):
__tablename__ = 'stat_daily_member'
__table_args__ = (db.Index('idx_date_member_id', 'date', 'member_id'), )
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.Date, nullable=False, info='日期')
member_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='会员id')
total_shared_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue(),
info='当日分享总次数')
total_pay_money = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue(),
info='当日付款总金额')
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='最后一次更新时间')
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue(),
info='插入时间')
class Food(db.Model):
__tablename__ = 'food'
id = db.Column(db.Integer, primary_key=True)
cat_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
member_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
name = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue())
price = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue())
image = db.Column(db.String(100),
nullable=False,
server_default=db.FetchedValue())
summary = db.Column(db.String(10000),
nullable=False,
server_default=db.FetchedValue())
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
total_count = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
@property
def status_desc(self):
status_map = {"0": "已删除", "1": "正常"}
return status_map[str(self.status)]
class PayOrderItem(db.Model):
__tablename__ = 'pay_order_item'
id = db.Column(db.Integer, primary_key=True)
pay_order_id = db.Column(db.Integer,
nullable=False,
index=True,
server_default=db.FetchedValue())
member_id = db.Column(db.BigInteger,
nullable=False,
server_default=db.FetchedValue())
quantity = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
price = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue())
food_id = db.Column(db.Integer,
nullable=False,
index=True,
server_default=db.FetchedValue())
note = db.Column(db.Text, nullable=False)
status = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
updated_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
class FoodSaleChangeLog(db.Model):
__tablename__ = 'food_sale_change_log'
id = db.Column(db.Integer, primary_key=True)
food_id = db.Column(db.Integer,
nullable=False,
index=True,
server_default=db.FetchedValue())
quantity = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
price = db.Column(db.Numeric(10, 2),
nullable=False,
server_default=db.FetchedValue())
member_id = db.Column(db.Integer,
nullable=False,
server_default=db.FetchedValue())
created_time = db.Column(db.DateTime,
nullable=False,
server_default=db.FetchedValue())
@property
def member_name(self):
member = Member.query.filter_by(id=self.member_id).first()
return member.nickname
class FlicketPost(PaginatedAPIMixin, Base):
__tablename__ = "flicket_post"
id = db.Column(db.Integer, primary_key=True)
ticket_id = db.Column(db.Integer, db.ForeignKey(FlicketTicket.id))
ticket = db.relationship(FlicketTicket, back_populates="posts")
content = db.Column(db.String(field_size["content_max_length"]))
user_id = db.Column(db.Integer, db.ForeignKey(FlicketUser.id))
user = db.relationship(FlicketUser, foreign_keys="FlicketPost.user_id")
date_added = db.Column(db.DateTime())
date_modified = db.Column(db.DateTime())
modified_id = db.Column(db.Integer, db.ForeignKey(FlicketUser.id))
modified = db.relationship(FlicketUser, foreign_keys="FlicketPost.modified_id")
days = db.Column(db.Numeric(10, 2), server_default="0")
# finds all the images associated with the post
uploads = db.relationship(
"FlicketUploads", primaryjoin="and_(FlicketPost.id == FlicketUploads.posts_id)"
)
# finds all the actions associated with the post
actions = db.relationship(
"FlicketAction", primaryjoin="FlicketPost.id == FlicketAction.post_id"
)
def to_dict(self):
"""
:return: dict()
"""
data = {
"id": self.id,
"content": self.content,
"data_added": self.date_added,
"date_modified": self.date_modified,
"ticket_id": self.ticket_id,
"user_id": self.user_id,
"links": {
"self": app.config["base_url"] + url_for("bp_api.get_post", id=self.id),
"created_by": app.config["base_url"]
+ url_for("bp_api.get_user", id=self.user_id),
"posts": app.config["base_url"]
+ url_for("bp_api.get_posts", ticket_id=self.ticket_id),
},
}
return data
def __repr__(self):
return "<FlicketPost: id={}, ticket_id={}, content={}>".format(
self.id, self.ticket_id, self.content
)
class Task(db.Model):
__tablename__ = 'Task'
id = db.Column('id', db.Integer, primary_key=True)
account_id = db.Column('account_id',
db.Integer,
db.ForeignKey('Account.id'),
nullable=False)
tasklist_id = db.Column('tasklist_id',
db.Integer,
db.ForeignKey('TaskList.id'),
nullable=False)
order = db.Column('order', db.Numeric(precision=16), nullable=False)
description = db.Column('description', db.Unicode, nullable=False)
is_completed = db.Column('is_completed', db.Boolean, default=False)
tags = db.relationship("Tag",
secondary=task_tag,
collection_class=set,
lazy="dynamic",
backref="tasks")
account = db.relationship('Account', foreign_keys=account_id)
tasklist = db.relationship('TaskList', foreign_keys=tasklist_id)
def __init__(self, account_id, tasklist_id, order, description):
self.account_id = account_id
self.tasklist_id = tasklist_id
self.order = order
self.description = description
@staticmethod
def get_tags_by_task():
stmt_string = (
'SELECT \"Task\".id, \"Tag\".id, \"Tag\".name FROM \"Tag\"'
' CROSS JOIN \"TaskTag\"'
' INNER JOIN \"Task\" ON \"Task\".id = \"TaskTag\".task_id and'
'\"Tag\".id = \"TaskTag\".tag_id')
res = db.engine.execute(stmt_string)
tags_by_task = {}
for row in res:
if row[0]:
if row[0] not in tags_by_task:
tags_by_task[row[0]] = []
tags_by_task[row[0]].append({"id": row[1], "name": row[2]})
return tags_by_task
@staticmethod
def get_tags_for_task(task_id):
stmt_string = ('SELECT \"Tag\".id, \"Tag\".name FROM \"Tag\"'
' INNER JOIN \"TaskTag\" ON \"TaskTag\".task_id = ' +
str(task_id) + ' and \"TaskTag\".tag_id = \"Tag\".id')
res = db.engine.execute(text(stmt_string))
tags = []
for row in res:
tags.append({"id": row[0], "name": row[1]})
return tags
class WhiteoilOil(db.Model):
__tablename__ = 'whiteoil_oil'
oil_id = db.Column(db.String(32), primary_key=True)
oil_name = db.Column(db.String(50))
oil_density = db.Column(db.Numeric(asdecimal=False))
oil_status = db.Column(db.String(2))
oil_remark = db.Column(db.String(200))
class PayOrder(db.Model):
__tablename__ = 'pay_order'
__table_args__ = (
db.Index('idx_member_id_status', 'member_id', 'status'),
)
id = db.Column(db.Integer, primary_key=True)
order_sn = db.Column(db.String(40), nullable=False, unique=True, server_default=db.FetchedValue())
member_id = db.Column(db.BigInteger, nullable=False, server_default=db.FetchedValue())
total_price = db.Column(db.Numeric(10, 2), nullable=False, server_default=db.FetchedValue())
yun_price = db.Column(db.Numeric(10, 2), nullable=False, server_default=db.FetchedValue())
pay_price = db.Column(db.Numeric(10, 2), nullable=False, server_default=db.FetchedValue())
pay_sn = db.Column(db.String(128), nullable=False, server_default=db.FetchedValue())
prepay_id = db.Column(db.String(128), nullable=False, server_default=db.FetchedValue())
note = db.Column(db.Text, nullable=False)
status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
express_status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
express_address_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
express_info = db.Column(db.String(100), nullable=False, server_default=db.FetchedValue())
comment_status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue())
pay_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
@property
def pay_status(self):
tmp_status = self.status
if self.status == 1:
tmp_status = self.express_status
if self.express_status == 1 and self.comment_status == 0:
tmp_status = -5
if self.express_status == 1 and self.comment_status == 1:
tmp_status = 1
return tmp_status
@property
def status_desc(self):
return app.config['PAY_STATUS_DISPLAY_MAPPING'][ str( self.pay_status )]
@property
def order_number(self):
order_number = self.created_time.strftime("%Y%m%d%H%M%S")
order_number = order_number + str(self.id).zfill(5)
return order_number
class Location(db.Model):
"""Model for Location data"""
# Fields
id = db.Column(db.Integer, primary_key=True)
ip = db.Column(db.String(15))
latitude = db.Column(db.Numeric(8, 6))
longitude = db.Column(db.Numeric(9, 6))
positionAccuracy = db.Column(db.Float())
altitude = db.Column(db.Float())
altitudeAccuracy = db.Column(db.Float())
speed = db.Column(db.Float())
heading = db.Column(db.Float())
w3w = db.Column(db.String(60))
timeStamp = db.Column(db.DateTime(), index=True)
# Relationships
track_id = db.Column(db.Integer, db.ForeignKey('track.id'))
class PayOrder(db.Model):
__tablename__ = 'pay_order'
__table_args__ = (
db.Index('idx_member_id_status', 'member_id', 'status'),
)
id = db.Column(db.Integer, primary_key=True)
order_sn = db.Column(db.String(40), nullable=False, unique=True, server_default=db.FetchedValue(), info='随机订单号')
member_id = db.Column(db.BigInteger, nullable=False, server_default=db.FetchedValue(), info='会员id')
total_price = db.Column(db.Numeric(10, 2), nullable=False, server_default=db.FetchedValue(), info='订单应付金额')
yun_price = db.Column(db.Numeric(10, 2), nullable=False, server_default=db.FetchedValue(), info='运费金额')
pay_price = db.Column(db.Numeric(10, 2), nullable=False, server_default=db.FetchedValue(), info='订单实付金额')
pay_sn = db.Column(db.String(128), nullable=False, server_default=db.FetchedValue(), info='第三方流水号')
prepay_id = db.Column(db.String(128), nullable=False, server_default=db.FetchedValue(), info='第三方预付id')
note = db.Column(db.Text, nullable=False, info='备注信息')
status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='1：支付完成 0 无效 -1 申请退款 -2 退款中 -9 退款成功 -8 待支付 -7 完成支付待确认')
express_status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='快递状态，-8 待支付 -7 已付款待发货 1：确认收货 0：失败')
express_address_id = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='快递地址id')
express_info = db.Column(db.String(1000), nullable=False, server_default=db.FetchedValue(), info='快递信息')
comment_status = db.Column(db.Integer, nullable=False, server_default=db.FetchedValue(), info='评论状态')
pay_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='付款到账时间')
updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='最近一次更新时间')
created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue(), info='插入时间')
@property
def pay_status(self):
tmp_status = self.status
if self.status == 1:
tmp_status = self.express_status
if self.express_status == 1 and self.comment_status == 0:
tmp_status = -5
if self.express_status == 1 and self.comment_status == 1:
tmp_status = 1
return tmp_status
@property
def status_desc(self):
return app.config['PAY_STATUS_DISPLAY_MAPPING'][str(self.pay_status)]
@property
def order_number(self):
order_number = self.created_time.strftime("%Y%m%d%H%M%S")
order_number = order_number + str(self.id).zfill(5)
return order_number
class Delivery(db.Model):
__tablename__ = 'deliveries'
id = db.Column(db.Integer, primary_key=True)
created_at = db.Column(db.DateTime)
client_id = db.Column(db.Integer, db.ForeignKey("clients.id"), nullable=False)
cdd_id = db.Column(db.Integer, db.ForeignKey("cdds.id"), nullable=False)
price = db.Column(db.Numeric(8,2))
final_date = db.Column(db.DateTime)
chunks = db.relationship('Chunk', backref="delivery", lazy='dynamic')
bookings = db.relationship('Booking', backref="delivery", lazy='dynamic')
