class BangDichBenh(CommonModel):
__tablename__ = 'bangdichbenh'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True)
baocao = db.relationship('BaoCao', backref=db.backref('bangdichbenh',lazy='dynamic'))
cuakhau_id = db.Column(db.Integer,db.ForeignKey('cuakhau.id'), nullable=True)
tencuakhau = db.Column(db.String())
macuakhau = db.Column(db.String(25))
sothutu = db.Column(db.SmallInteger())
db_csbc = db.Column(db.Integer())
db_dvdtc = db.Column(db.Integer())
db_dvkd = db.Column(db.Integer())
db_mdc = db.Column(db.Integer())
db_mdm = db.Column(db.Integer())
db_sldtc = db.Column(db.Integer())
db_slgs = db.Column(db.Integer())
db_sxdtc = db.Column(db.Integer())
db_sxkd = db.Column(db.Integer())
#bosung:
db_mdc_slgs = db.Column(db.Integer())
db_mdc_slxl = db.Column(db.Integer())
db_csbc_slgs = db.Column(db.Integer())
db_csbc_slxl = db.Column(db.Integer())
db_mdm_slgs = db.Column(db.Integer())
db_mdm_slxl = db.Column(db.Integer())
db_csdv_slgs = db.Column(db.Integer())
db_csdv_sld = db.Column(db.Integer())
db_cssx_slgs = db.Column(db.Integer())
db_cssx_sld = db.Column(db.Integer())
class BangHangHoa(CommonModel):
__tablename__ = 'banghanghoa'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True)
baocao = db.relationship('BaoCao', backref=db.backref('banghanghoa',lazy='dynamic'))
cuakhau_id = db.Column(db.Integer,db.ForeignKey('cuakhau.id'), nullable=True)
tencuakhau = db.Column(db.String())
macuakhau = db.Column(db.String(25))
sothutu = db.Column(db.SmallInteger())
hh_nc_bpbk_sl = db.Column(db.Integer())
hh_nc_bpbk_skt = db.Column(db.Integer())
hh_nc_bpbk_sxl = db.Column(db.Integer())
hh_nc_hhk_tl = db.Column(db.Float())
hh_nc_hhk_skt = db.Column(db.Integer())
hh_nc_hhk_sxl = db.Column(db.Integer())
hh_nc_ghichu = db.Column(db.String())
hh_xc_bpbk_sl = db.Column(db.Integer())
hh_xc_bpbk_skt = db.Column(db.Integer())
hh_xc_bpbk_sxl = db.Column(db.Integer())
hh_xc_hhk_tl = db.Column(db.Float())
hh_xc_hhk_skt = db.Column(db.Integer())
hh_xc_hhk_sxl = db.Column(db.Integer())
hh_xc_ghichu = db.Column(db.String())
hh_qc_bpbk_sl = db.Column(db.Integer())
hh_qc_bpbk_skt = db.Column(db.Integer())
hh_qc_bpbk_sxl = db.Column(db.Integer())
hh_qc_hhk_tl = db.Column(db.Float())
hh_qc_hhk_skt = db.Column(db.Integer())
hh_qc_hhk_sxl = db.Column(db.Integer())
hh_qc_ghichu = db.Column(db.String())
class BaoCaoTongHopNghiNgoNhiemBenhNhomA(CommonModel):
__tablename__ = "baocaotonghopnghingonhiembenhnhoma"
id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid())
loaibaocao = db.Column(db.SmallInteger()) #1 - don vi, 2 cua khau
ngaybaocao = db.Column(db.DateTime(), index=True, default=func.now())
donvi_id = db.Column(db.Integer, index=True, nullable=False)
madonvi = db.Column(db.String())
tendonvi = db.Column(db.String())
cuakhau_id = db.Column(db.Integer, index=True, nullable=True)
tencuakhau = db.Column(db.String())
macuakhau = db.Column(db.String())
#cuakhau
songuoinhapcanh = db.Column(db.BigInteger)
sohanhkhachkhaibao = db.Column(db.BigInteger)
sochuyenbay = db.Column(db.BigInteger)
songuoinghingo = db.Column(db.BigInteger)
#donvi
songuoidangcachlytaptrung = db.Column(db.BigInteger)
songuoidangcachlytaptrung_cotrieuchung = db.Column(db.BigInteger)
songuoicachlytainha = db.Column(db.BigInteger)
songuoihetcachly = db.Column(db.BigInteger)
data = db.Column(JSONB)
class CuaKhau(CommonModel):
__tablename__ = 'cuakhau'
id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255), unique=True)
ten = db.Column(db.String(255), nullable=False)
#loaicuakhau = db.Column(db.SmallInteger) #
kiemdichyte = db.Column(db.Boolean, default=True)
phongcachly = db.Column(db.Boolean, default=True)
nguoilienlac = db.Column(db.String(255), nullable=True)
sodienthoai = db.Column(db.String, nullable=True)
diachi = db.Column(db.String, nullable=True)
email = db.Column(db.String, nullable=True)
donvi_id = db.Column(db.Integer,db.ForeignKey('donvi.id'), nullable=True)
donvi = db.relationship('DonVi', backref=db.backref('cuakhau',lazy='dynamic'),viewonly=True)
tinhthanh_id = db.Column(db.Integer,db.ForeignKey('tinhthanh.id'), nullable=True)
tinhthanh = db.relationship('TinhThanh',viewonly=True)
thutu = db.Column(db.Integer, nullable=True)
#loaicuakhau
duongboquocte = db.Column(db.Boolean, default=False)
duongbochinh = db.Column(db.Boolean, default=False)
duongbophu = db.Column(db.Boolean, default=False)
duongsat = db.Column(db.Boolean, default=False)
duonghangkhong = db.Column(db.Boolean, default=False)
duongthuyloai1 = db.Column(db.Boolean, default=False)
duongthuyloai2 = db.Column(db.Boolean, default=False)
quocgia_tiepgiap = db.Column(db.String, nullable=True)
cuakhau_tiepgiap = db.Column(db.String, nullable=True)
class User(db.Model):
__tablename__ = 'users'
__table_args__ = (
db.UniqueConstraint('name'),
db.UniqueConstraint('email'),
)
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(15, collation='utf8mb4_general_ci'),
nullable=False)
display_name = db.Column(db.String(50, collation='utf8mb4_general_ci'),
nullable=False)
email = db.Column(db.String(256, collation='utf8mb4_general_ci'),
nullable=False)
password = db.Column(db.String(1024, collation='utf8mb4_general_ci'),
nullable=False)
created_at = db.Column(db.DateTime, nullable=False, default=datetime.now)
updated_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now,
onupdate=datetime.now)
def __init__(self, name, display_name, email, password):
self.name = name
self.display_name = display_name
self.email = email
self.password = password
class ProductArea(Abstract):
""" ProductArea model class"""
slug = db.Column(db.String(255), nullable=False)
title = db.Column(db.String(255), nullable=False)
def __repr__(self):
return f'<ProductArea: {self.title}>'
class Country(CommonModel):
__tablename__ = "country"
country_name = db.Column(db.String(50))
code = db.Column(db.String(50))
cities = db.relationship("City",
order_by="City.id",
cascade="all, delete-orphan")
class QuanHuyen(CommonModel):
__tablename__ = 'quanhuyen'
id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255), unique=True)
ten = db.Column(db.String(255), nullable=False)
tinhthanh_id = db.Column(db.Integer, db.ForeignKey('tinhthanh.id'), nullable=True)
tinhthanh = db.relationship('TinhThanh',viewonly=True)
class TinhThanh(CommonModel):
__tablename__ = 'tinhthanh'
id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255), unique=True)
ten = db.Column(db.String(255), nullable=False)
quocgia_id = db.Column(db.Integer, db.ForeignKey('quocgia.id'), nullable=True)
quocgia = db.relationship('QuocGia',viewonly=True)
class BaiViet(CommonModel):
__tablename__ = 'baiviet'
id = db.Column(db.Integer, primary_key=True)
ngaytao = db.Column(db.DateTime(),default=func.now())
tieude = db.Column(db.String())
gioithieu = db.Column(db.String())
noidung = db.Column(db.Text())
phamvi = db.Column(db.String(20))
class AvatarImage(db.Model):
__tablename__ = "avatar_image"
id = db.Column(db.Integer, primary_key=True)
path = db.Column(db.String(255), unique=True)
url = db.Column(db.String(255))
user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
user = db.relationship("User")
class Employee(Abstract, UserMixin):
""" Employee model class"""
first_name = db.Column(db.String(255), nullable=False)
last_name = db.Column(db.String(255), nullable=False)
email = db.Column(EmailType, unique=True, nullable=False)
password = db.Column(db.Text)
def __repr__(self):
return f'<Employee: {self.first_name} {self.last_name}>'
class BaoCaoNghiNgoNhiemBenhXetNghiem(CommonModel):
__tablename__ = 'baocaonghingonhiembenhxetnghiem'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocaonghingonhiembenh.id'), nullable=True)
baocao = db.relationship('BaoCaoNghiNgoNhiemBenh', backref=db.backref('baocaonghingonhiembenhxetnghiem',lazy='dynamic'))
loaimauxetnghiem = db.Column(db.String())
ngaylay = db.Column(db.DateTime())
ketqua = db.Column(db.String())
class BangHopTacQuocTe(CommonModel):
__tablename__ = 'banghoptacquocte'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True)
baocao = db.relationship('BaoCao', backref=db.backref('banghoptacquocte',lazy='dynamic'))
sothutu = db.Column(db.SmallInteger())
quocgia = db.Column(db.String())
noidung = db.Column(db.String())
class BaoCaoNghiNgoNhiemBenhNguoiTiepXuc(CommonModel):
__tablename__ = 'baocaonghingonhiembenhnguoitiepxuc'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocaonghingonhiembenh.id'), nullable=True)
baocao = db.relationship('BaoCaoNghiNgoNhiemBenh', backref=db.backref('baocaonghingonhiembenhnguoitiepxuc',lazy='dynamic'))
hoten = db.Column(db.String())
quoctich = db.Column(db.String())
cmtnd = db.Column(db.String())
dienthoai = db.Column(db.String())
email = db.Column(db.String())
class BaoCaoNghiNgoNhiemBenhVacxin(CommonModel):
__tablename__ = 'baocaonghingonhiembenhvacxin'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocaonghingonhiembenh.id'), nullable=True)
baocao = db.relationship('BaoCaoNghiNgoNhiemBenh', backref=db.backref('baocaonghingonhiembenhvacxin',lazy='dynamic'))
tenvacxin = db.Column(db.String())
solandung = db.Column(db.SmallInteger)
ngaydunggannhat = db.Column(db.DateTime())
ketqua = db.Column(db.String())
class BangVienHoatDongChung(CommonModel):
__tablename__ = 'bangvienhoatdongchung'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocaovien.id'), nullable=True)
baocao = db.relationship('BaoCaoVien', backref=db.backref('bangvienhoatdongchung',lazy='dynamic'))
noidung = db.Column(db.String())
sothutu = db.Column(db.SmallInteger())
tenhoatdong = db.Column(db.String())
soluong = db.Column(db.Integer())
class user(Base):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
username = db.Column('username',db.String(80), unique=True)
password = db.Column('password',db.String(120))
def __init__(self, username, password):
self.username = username
self.password = password
print("User __init__ has fired")
class OrganizationStaff(CommonModel):
__tablename__ = 'organizationstaff'
id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid)
name = db.Column(db.String(255))
phone = db.Column(db.String(255))
email = db.Column(db.String(255))
role = db.Column(db.String(255))
organization_id = db.Column(UUID(as_uuid=True),
ForeignKey('organization.id'),
nullable=True)
class BaoCao(CommonModel):
__tablename__ = 'baocao'
id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255))
ngaybaocao = db.Column(db.DateTime(),default=func.now())
loaikybaocao = db.Column(db.Integer, nullable=False)
loaibaocao = db.Column(db.SmallInteger()) #1 - don vi, 2 cua khau
kybaocao = db.Column(db.SmallInteger, nullable=False)
nambaocao = db.Column(db.Integer, nullable=False)
tungay = db.Column(db.Date())
denngay = db.Column(db.Date())
donvi_id = db.Column(db.Integer,db.ForeignKey('donvi.id'), nullable=True)
donvi = db.relationship('DonVi',viewonly=True)
cuakhau_id = db.Column(db.Integer,db.ForeignKey('cuakhau.id'), nullable=True)
cuakhau = db.relationship('CuaKhau',viewonly=True)
nhanxetnguoi = db.Column(db.String())
nhanxetphuongtien = db.Column(db.String())
nhanxethanghoa = db.Column(db.String())
nhanxetthithe = db.Column(db.String())
nhanxetvssh = db.Column(db.String())
nhanxet = db.Column(db.String())
kiennghi = db.Column(db.String())
hoatdongkhac = db.Column(db.String())
nhanlucts = db.Column(db.Integer())
nhanlucbienche = db.Column(db.Integer())
nhanluchopdong = db.Column(db.Integer())
tinhtrang = db.Column(db.SmallInteger, nullable=False, default=1)
class BangTiemChung(CommonModel):
__tablename__ = 'bangtiemchung'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True)
baocao = db.relationship('BaoCao', backref=db.backref('bangtiemchung',lazy='dynamic'))
sothutu = db.Column(db.SmallInteger())
tenbenh = db.Column(db.String())
tenvacxin = db.Column(db.String())
soluong = db.Column(db.Integer())
ghichu = db.Column(db.String())
class BangTruyenThong(CommonModel):
__tablename__ = 'bangtruyenthong'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True)
baocao = db.relationship('BaoCao', backref=db.backref('bangtruyenthong',lazy='dynamic'))
sothutu = db.Column(db.SmallInteger())
hinhthuc = db.Column(db.String())
noidung = db.Column(db.String())
doituong = db.Column(db.String())
ketqua = db.Column(db.Integer())
class BangNghienCuuKhoaHoc(CommonModel):
__tablename__ = 'bangnghiencuukhoahoc'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True)
baocao = db.relationship('BaoCao', backref=db.backref('bangnghiencuukhoahoc',lazy='dynamic'))
sothutu = db.Column(db.SmallInteger())
tendetai = db.Column(db.String())
thoigianthuchien = db.Column(db.String())
detaicap = db.Column(db.String())
linhvucnghiencuu = db.Column(db.String())
class Employee(db.Model):
__tablename__ = "Employees"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
gid = db.Column(db.String(50), unique=True, nullable=False)
local_id = db.Column(db.String(50), unique=True, nullable=False)
name = db.Column(db.String(50), nullable=False)
last_name = db.Column(db.String(50), nullable=False)
time_tracks = db.relationship("TimeTrack", backref="employee", lazy=True)
def __repr__(self):
return f"{self.name} {self.last_name}"
class BangVienSuKien(CommonModel):
__tablename__ = 'bangviensukien'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocaovien.id'), nullable=True)
baocao = db.relationship('BaoCaoVien', backref=db.backref('bangviensukien',lazy='dynamic'))
sothutu = db.Column(db.SmallInteger())
tensukien = db.Column(db.String())
diadiem = db.Column(db.String())
bienphap = db.Column(db.String())
ketqua = db.Column(db.String())
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80), unique=True)
password = db.Column(db.String(120))
permissions = db.relationship('Permission',
secondary=user_permissions,
backref=db.backref('users', lazy='dynamic'))
def __init__(self, username, password):
self.username = username
self.password = password
class BangXetNghiem(CommonModel):
__tablename__ = 'bangxetnghiem'
id = db.Column(db.Integer, primary_key=True)
baocao_id = db.Column(db.Integer,db.ForeignKey('baocao.id'), nullable=True)
baocao = db.relationship('BaoCao', backref=db.backref('bangxetnghiem',lazy='dynamic'))
sothutu = db.Column(db.SmallInteger())
loaixetnghiem = db.Column(db.String())
soluongmau = db.Column(db.Integer())
dattieuchuan = db.Column(db.Integer())
ghichu = db.Column(db.String())
class ConfigVariables(db.Model):
__bind_key__ = 'caesar'
__tablename__ = '%s_config' % TABLE_PREFIX
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
code = db.Column(db.String(25), unique=True, nullable=False)
name = db.Column(db.Unicode(50), unique=True, nullable=False)
value = db.Column(db.Unicode(100))
value_type = db.Column(db.String(30))
def __unicode__(self):
return self.code
class DiaDiemCachLyTapTrung(CommonModel):
__tablename__ = "diadiemcachlytaptrung"
id = db.Column(db.Integer, primary_key=True)
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=True, index=True)
cuakhau_id = db.Column(db.Integer, db.ForeignKey('cuakhau.id'), nullable=True, index=True)
ten = db.Column(db.String(255), nullable=False)
diachi = db.Column(db.String(255), nullable=True)
nguoilienlac = db.Column(db.String(255), nullable=False)
sodienthoai = db.Column(db.String)
email = db.Column(db.String)
ghichu = db.Column(db.String)
class Car(db.Model):
id = db.Column(db.Integer, primary_key=True)
make = db.Column(db.String(20))
model = db.Column(db.String(20))
build_date = db.Column(db.DateTime)
colour_id = db.Column(db.Integer, db.ForeignKey('colour.id'))
def save_to_db(self):
db.session.add(self)
db.session.commit()
def delete_from_db(self):
db.session.delete(self)
db.session.commit()
