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)