class Customs_Declaration_Base(BaseModel): id = db.Column(db.Integer, primary_key=True, autoincrement=True) uuid = db.Column(db.String(100), unique=True, default=lambda: str(uuid4())) create_time = db.Column(db.DateTime, default=datetime.now) pre_entry_code = db.Column(db.String(100)) declaration_code = db.Column(db.BigInteger, unique=True) bl_code = db.Column(db.String(100)) case_code = db.Column(db.String(100)) contract_code = db.Column(db.String(100)) customs_date = db.Column(db.Date) business_company = db.Column(db.String(100)) customs_company = db.Column(db.String(100)) consignee = db.Column(db.String(100)) vessel_name = db.Column(db.String(100)) vessel_code = db.Column(db.String(100)) trade_type = db.Column(db.String(100)) license_code = db.Column(db.String(100)) approval_code = db.Column(db.String(100)) freight = db.Column(db.String(100)) insurance_premiums = db.Column(db.String(100)) sundry_charges = db.Column(db.String(100)) packages_num = db.Column(db.Integer, default=1) packing_type = db.Column(db.String(100)) gross_weight = db.Column(db.DECIMAL(10, 2)) net_weight = db.Column(db.DECIMAL(10, 2)) container_code = db.Column(db.String(100)) marks = db.Column(db.String(200)) tax_price = db.Column(db.DECIMAL(10, 2)) refund_reason = db.Column(db.String(200)) check_date = db.Column(db.Date)
class CarInOut(db.Model): """ 定义过车信息表 """ __tablename__ = 'car_in_out' id = db.Column(db.String(64), primary_key=True, comment='过车记录ID') park_id = db.Column(db.String(64), db.ForeignKey('park_info.id')) plate_no = db.Column(db.String(10), nullable=False, comment='车牌') in_time = db.Column(db.DateTime, comment='进场时间') out_time = db.Column(db.DateTime, comment='出场时间') in_port = db.Column(db.String(20), comment='进场通道') out_port = db.Column(db.String(20), comment='出场通道') in_man = db.Column(db.String(20), comment='进场管理员') out_man = db.Column(db.String(20), comment='出场管理员') stay_min = db.Column(db.Integer, comment='停留分钟') fee_require = db.Column(db.DECIMAL(7, 2), comment='应收金额') fee_receipt = db.Column(db.DECIMAL(7, 2), comment='实收金额') pay_type = db.Column(db.Integer, comment='支付方式(0现金,1微信,2支付宝,3代付,4优惠券)') park_state = db.Column(db.Integer, comment='停车状态(0停车中,1停车结束,2异常停车)') remarks = db.Column(db.String(255), comment='备注') parkingpay = db.relationship('ParkingPay', backref='carinout', lazy='dynamic') def __repr__(self): return 'car_in_out: id[%s] - parkname[%s] - plate_no[%s] - in_time[%s] - out_time[%s]' % ( self.id, self.park_id, self.plate_no, self.in_time, self.out_time)
class Commodity(db.Model, BaseModel): __tablename__ = 'commodity' id = db.Column(db.Integer, primary_key=True, autoincrement=True) item_code = db.Column(db.String(100)) create_time = db.Column(db.DateTime, default=datetime.now) hs_code = db.Column(db.String(10)) commodity_name = db.Column(db.String(200)) commodity_type = db.Column(db.String(200)) quantity_and_unit = db.Column(db.String(100)) country = db.Column(db.String(100)) unit_price = db.Column(db.DECIMAL(10, 4)) total_price = db.Column(db.DECIMAL(10, 2)) currency_id = db.Column(db.Integer, db.ForeignKey('currency.id')) tax_free_mode_id = db.Column(db.Integer, db.ForeignKey('tax_free_mode.id')) import_declaration_id = db.Column( db.Integer, db.ForeignKey('import_customs_declaration.id')) export_declaration_id = db.Column( db.Integer, db.ForeignKey('export_customs_declaration.id')) currency = db.relationship('Currency', backref='commoditys') tax_free_mode = db.relationship('Tax_Free_Mode', backref='commoditys') import_declaration = db.relationship('Import_Customs_Declaration', backref='commoditys') export_declaration = db.relationship('Export_Customs_Declaration', backref='commoditys')
class Product(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50), nullable=False) amount = db.Column(db.Integer, nullable=False) price = db.Column(db.DECIMAL(5, 2), nullable=False) last_price = db.Column(db.DECIMAL(5, 2), nullable=False) PE_ratio = db.Column(db.DECIMAL(5, 2), nullable=False) total_increase = db.Column(db.DECIMAL(6, 2), nullable=False)
class Product_2(db.Model): id = db.Column(db.Integer, primary_key=True) symbol = db.Column(db.String(255), nullable=False) name = db.Column(db.String(255), nullable=False) last_price = db.Column(db.DECIMAL(10, 4), nullable=False) change = db.Column(db.DECIMAL(10, 4), nullable=False) chg = db.Column(db.DECIMAL(10, 2), nullable=False) highest = db.Column(db.DECIMAL(10, 4), nullable=False) lowest = db.Column(db.DECIMAL(10, 4), nullable=False)
class Proxy_Agreement_Base(BaseModel): id = db.Column(db.Integer, primary_key=True, autoincrement=True) uuid = db.Column(db.String(100), unique=True, default=lambda: str(uuid4())) goods_name = db.Column(db.String(60), nullable=False) hs_code = db.Column(db.String(10), nullable=False) total_price = db.Column(db.DECIMAL(10, 2), nullable=False) customs_price = db.Column(db.DECIMAL(10, 2)) import_or_export_date = db.Column(db.Date, nullable=False) bl_code = db.Column(db.String(100), nullable=False) telephone = db.Column(db.String(100)) other = db.Column(db.Text)
class ParkInfo(db.Model): """ 定义停车场基本信息表 """ __tablename__ = 'park_info' id = db.Column(db.String(64), primary_key=True, comment='停车场ID') name = db.Column(db.String(20), nullable=False, comment='停车场名字') contact = db.Column(db.String(10), comment='联系人') mobile = db.Column(db.String(15), comment='联系电话') address = db.Column(db.String(255), nullable=False, comment='停车场地址') longitude = db.Column(db.DECIMAL(10, 7), nullable=False, comment='经度') latitude = db.Column(db.DECIMAL(10, 7), nullable=False, comment='纬度') type = db.Column(db.Integer, nullable=False, comment='停车场类型(0公共,1私人)') total_parking_space = db.Column(db.Integer, comment='总车位') empty_parking_space = db.Column(db.Integer, comment='空余车位') monthly_parking_space = db.Column(db.Integer, comment='月卡车位') charging_rules = db.Column(db.String(255), comment='收费规则') create_on = db.Column(db.DateTime, default=datetime.now, comment='创建时间') create_by = db.Column(db.String(20), nullable=False, comment='创建人') update_on = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now, comment='修改时间') update_by = db.Column(db.String(20), comment='修改人') delete_on = db.Column(db.DateTime, comment='删除时间') delete_by = db.Column(db.String(20), comment='删除人') state = db.Column(db.Integer, default=1, comment='状态(0删除,1启用)') # ismonthly = db.Column(db.Integer, default=1, comment='是否启用月卡(0不启用,1启用)') remarks = db.Column(db.String(255), comment='备注') carinout = db.relationship('CarInOut', backref='parkinfo', lazy='dynamic') moncategory = db.relationship('MonthlyCategory', backref='parkinfo', lazy='dynamic') sysuser = db.relationship('SysUser', secondary=sys_user_park, backref='parkinfo', lazy='dynamic') def __repr__(self): return 'park_info: id[%s], name[%s], ' % (self.id, self.name) # 删除停车场的时候解除与用户关联 @property def remove_user_park(self): users = self.sysuser for u in users: self.sysuser.remove(u) try: db.session.commit() logger.info('解除用户与<%s>停车场的关联成功' % self.id) except Exception as e: logger.error('解除用户与<%s>停车场的关联失败' % self.id)
class Station(db.Model): """ comment= '站点(站点id、类型id、站点名称、经度、纬度)'; """ __tablename__ = "station" station_id = db.Column(db.Integer, nullable=False, primary_key=True) station_name = db.Column(db.String(20), nullable=False) delete_type = db.Column(db.SMALLINT, nullable=False, default=0, comment='(0:正常,1:删除)') station_type = db.Column(db.SMALLINT, nullable=False) density = db.Column(db.String(11), nullable=False, comment='(G:少,B:较多,R:多)') longitude = db.Column(db.DECIMAL(10, 6)) latitude = db.Column(db.DECIMAL(10, 6)) # 反向引用 route_station route_station = db.relationship("route_station", backref="station", lazy="dynamic") # 反向引用 station_passenger station_passenger = db.relationship("station_passenger", backref="station", lazy="dynamic") # 反向引用 user_station user_station = db.relationship("user_station", backref="station", lazy="dynamic") def __init__(self, station_name, station_type, density, longitude, latitude, delete_type=0): self.station_id = station_name self.station_type = station_type self.delete_type = delete_type self.density = density self.longitude = longitude self.latitude = latitude def save(self): db.session.add(self) db.session.commit() def __rper__(self): return '<Station:%r>' % self.__tablename__
class MonthlyCategory(db.Model): """ 定义月卡分类表 """ __tablename__ = 'monthly_category' id = db.Column(db.String(64), primary_key=True, comment='月卡分类ID') park_id = db.Column(db.String(64), db.ForeignKey('park_info.id')) name = db.Column(db.String(20), nullable=False, comment='月卡名称') price = db.Column(db.DECIMAL(7, 2), nullable=False, comment='月卡单价') create_on = db.Column(db.DateTime, default=datetime.now, comment='创建时间') create_by = db.Column(db.String(20), comment='创建人') update_on = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now, comment='修改时间') update_by = db.Column(db.String(20), comment='修改人') delete_on = db.Column(db.DateTime, comment='删除时间') delete_by = db.Column(db.String(20), comment='删除人') state = db.Column(db.Integer, comment='状态(0删除,1启用)') monapply = db.relationship('MonthlyApply', backref='monthly_category', lazy='dynamic') def __repr__(self): return 'monthly_category: id[%s] - park_id[%s] - 月卡名称[%s] - 单价[%s] - 状态[%s]' % ( self.id, self.park_id, self.name, self.money, self.state)
class Currency(db.Model, BaseModel): __tablename__ = 'currency' id = db.Column(db.Integer, primary_key=True, autoincrement=True) code = db.Column(db.Integer, unique=True) name = db.Column(db.String(100), nullable=False) e_name = db.Column(db.String(100), nullable=False) exchange_rate = db.Column(db.DECIMAL(10, 4))
class job_position(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) create_time = db.Column( db.DateTime, default=datetime.now) # used by jobList sort algorithm comp_id = db.Column(db.Integer, db.ForeignKey('user.id')) pos_name = db.Column(db.String(80), nullable=False) pos_desc = db.Column(db.Text, nullable=False) # employment_type = db.Column(db.Enum('Full-time', 'Part-time', 'Internship'), default='full-time') employment_type = db.Column(db.String(20)) salary = db.Column(db.DECIMAL(10, 2), nullable=False) salary_type = db.Column(db.String(20)) location = db.Column(db.String(100)) responsibility = db.Column(db.Text, nullable=False) experience = db.Column(db.String(2)) exp_dura = db.Column(db.String(50)) exp_type = db.Column(db.String(20)) exp_des = db.Column(db.Text) qualification = db.Column(db.String(2)) req_qual = db.Column(db.String(20)) qual_des = db.Column(db.Text) recruiting_nb = db.Column(db.Integer) closing_date = db.Column(db.String(10), default='OPEN') submitted_nb = db.Column(db.Integer, default=0) company = db.relationship('user', backref=db.backref('job_positions')) @hybrid_property def transfer_salary(self): # change all the salary type to 'per year' if self.salary_type == 'per hour': return self.salary * 7 * 240 elif self.salary_type == 'per day': return self.salary * 240 elif self.salary_type == 'per week': return self.salary * 48 elif self.salary_type == 'per month': return self.salary * 12 else: return self.salary @transfer_salary.expression def transfer_salary(cls): return db.case([(cls.salary_type == 'per hour', cls.salary * 7 * 240), (cls.salary_type == 'per day', cls.salary * 240), (cls.salary_type == 'per week', cls.salary * 48), (cls.salary_type == 'per month', cls.salary * 12)], else_=cls.salary)
class MonthlyPay(db.Model): """ 月卡缴费表 """ __tablename__ = 'monthly_pay' id = db.Column(db.String(64), primary_key=True, comment='月卡订单ID') apply_id = db.Column(db.String(64), db.ForeignKey('monthly_apply.id')) order_id = db.Column(db.String(64), comment='订单号') mchorder_id = db.Column(db.String(64), comment='商户订单号') months = db.Column(db.Integer, comment='缴费时长') fee_require = db.Column(db.DECIMAL(7, 2), comment='应收金额') fee_receipt = db.Column(db.DECIMAL(7, 2), comment='实收金额') fee_free = db.Column(db.DECIMAL(7, 2), comment='优惠金额') pay_type = db.Column(db.Integer, comment='缴费方式(1微信,2支付宝)') create_on = db.Column(db.DateTime, default=datetime.now, comment='创建时间') pay_on = db.Column(db.DateTime, comment='支付时间') state = db.Column(db.Integer, comment='支付状态(0待支付,1支付完成,2关闭支付)') def __repr__(self): return 'monthly_pay: id[%s] - apply_id[%s] - order_id[%s] - 缴费时长[%s] - 实收[%s] - 支付状态[%s]' % ( self.id, self.apply_id, self.order_id, self.months, self.fee_receipt, self.state)
class ParkingPay(db.Model): """ 定义临停缴费表 """ __tablename__ = 'parking_pay' id = db.Column(db.String(64), primary_key=True, comment='订单ID') car_id = db.Column(db.String(64), db.ForeignKey('car_in_out.id')) order_id = db.Column(db.String(64), comment='订单号') mchorder_id = db.Column(db.String(64), comment='商户订单号') fee_require = db.Column(db.DECIMAL(7, 2), comment='应收金额') fee_receipt = db.Column(db.DECIMAL(7, 2), comment='实收金额') fee_free = db.Column(db.DECIMAL(7, 2), comment='优惠金额') pay_type = db.Column(db.Integer, comment='支付方式(1微信,2支付宝)') create_on = db.Column(db.DateTime, default=datetime.now, comment='创建时间') pay_on = db.Column(db.DateTime, comment='支付时间') state = db.Column(db.Integer, comment='支付状态(0待支付,1支付完成,2关闭支付)') remarks = db.Column(db.String(255), comment='备注') def __repr__(self): return 'parking_pay: id[%s] - car_id[%s] - 订单号[%s] - 应收[%s] - 实收[%s] - 支付类型[%s] - 状态[%s] ' % ( self.id, self.car_id, self.order_id, self.fee_require, self.fee_receipt, self.pay_type, self.state)
class Product_1(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255), nullable=False) last_price = db.Column(db.DECIMAL(10, 2), nullable=False) change = db.Column(db.DECIMAL(10, 2), nullable=False) chg = db.Column(db.DECIMAL(10, 2), nullable=False) open = db.Column(db.DECIMAL(10, 2), nullable=False) highest = db.Column(db.DECIMAL(10, 2), nullable=False) lowest = db.Column(db.DECIMAL(10, 2), nullable=False) pre_close = db.Column(db.DECIMAL(10, 2), nullable=False) volume = db.Column(db.String(255), nullable=False) turnover = db.Column(db.String(255), nullable=False)
class Transactions(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.String()) transaction_amount = db.Column(db.String()) transaction_time = db.Column(db.DECIMAL()) @property def serialize(self): """Return object data in serializeable format""" return { 'id': self.id, 'user_id': self.user_id, 'transaction_amount': self.transaction_amount, 'transaction_time': self.transaction_time, }
class offer_tb(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) res_id = db.Column(db.Integer, db.ForeignKey('resume.id')) create_time = db.Column(db.DateTime, default=datetime.now) classes = db.Column(db.String(20)) # templete pos_name = db.Column(db.String(50)) department = db.Column(db.String(50)) working_date = db.Column(db.String(10)) salary = db.Column(db.DECIMAL(10, 2)) salary_type = db.Column(db.String(20)) benefit_date = db.Column(db.String(10)) HR_name = db.Column(db.String(30)) # user defined customized_cont = db.Column(db.String(1000))
class MonthlyApply(db.Model): """ 定义月卡申请表 """ __tablename__ = 'monthly_apply' id = db.Column(db.String(64), primary_key=True, comment='月卡申请ID') category_id = db.Column(db.String(64), db.ForeignKey('monthly_category.id')) plate_no = db.Column(db.String(2550), nullable=False, comment='月卡车牌') begin_date = db.Column(db.Date, nullable=False, comment='开始日期') end_date = db.Column(db.Date, nullable=False, comment='结束日期') price = db.Column(db.DECIMAL(7, 2), nullable=False, comment='月卡单价') applicant = db.Column(db.String(10), comment='联系人') mobile = db.Column(db.String(15), comment='联系电话') create_on = db.Column(db.DateTime, default=datetime.now, comment='创建时间') create_by = db.Column(db.String(20), comment='创建人') update_on = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now, comment='修改时间') update_by = db.Column(db.String(20), comment='修改人') delete_on = db.Column(db.DateTime, comment='删除时间') delete_by = db.Column(db.String(20), comment='删除人') state = db.Column(db.Integer, comment='状态(0删除,1启用,2过期)') remarks = db.Column(db.String(255), comment='备注') monpay = db.relationship('MonthlyPay', backref='monthly_apply', lazy='dynamic') def __repr__(self): return 'monthly_apply: id[%s] - category_id[%s] - 车牌[%s] - 开始时间[%s] - 结束时间[%s] - 状态[%s]' % ( self.id, self.category_id, self.plate_no, self.begin_date, self.end_date, self.state) def get_monpay(self): pass
class User(db.Model): """ comment= '用户(电话、用户id、用户名、密码、删除类型、邮箱、性别、头像、家庭住址、经度、 纬度、出生日期) '; """ __tablename__ = "user" user_id = db.Column(db.Integer, nullable=False, primary_key=True, comment='用户编号') phone = db.Column(db.CHAR(11), nullable=False, comment='电话') user_name = db.Column(db.String(50), nullable=False, comment='用户名') email = db.Column(db.String(50)) password = db.Column(db.CHAR(32), nullable=False, comment='密码') delete_type = db.Column(db.SMALLINT, nullable=False, default=0, comment='(0:正常,1:删除)') sex = db.Column(db.Integer, nullable=False, comment='性别(0女,1男)') head_img = db.Column(db.String(200), comment='头像') address = db.Column(db.String(100)) born_date = db.Column(db.DATE, nullable=False, comment='出生日期') longitude = db.Column(db.DECIMAL(10, 6)) latitude = db.Column(db.DECIMAL(10, 6)) production = db.Column(db.String(500)) __table_args__ = ( UniqueConstraint('phone', 'user_name'), # 电话和用户名唯一 ) # 反向引用 user_station user_station = db.relationship("user_station", backref="user", lazy="dynamic") # 反向引用 user_bus user_bus = db.relationship("user_bus", backref="user", lazy="dynamic") # 反向引用 user_passenger user_passenger = db.relationship("user_passenger", backref="user", lazy="dynamic") def __init__(self, phone, user_name, email, password, sex, head_img, address, born_date, longitude, latitude, production, delete_type=0): self.phone = phone self.user_name = user_name self.email = email self.password = password self.sex = sex self.head_img = head_img self.address = address self.born_date = born_date self.longitude = longitude self.latitude = latitude self.production = production self.delete_type = delete_type def save(self): db.session.add(self) db.session.commit() def __rper__(self): return '<User:%r>' % self.__tablename__
class table_shouye(db.Model): __tablename__ = 'table_shouye' xiaobiaoti = db.Column(db.String(50)) neirong = db.Column(db.String(1000)) xh = db.Column(db.DECIMAL(2, 0), primary_key=True)