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')