class yTEDuPhongHuyen(CommonModel):
__tablename__ = 'yteduphonghuyen'
id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid)
tenphuluc = db.Column(db.String)
thongtu = db.Column(db.String)
ngaybanhanhthongtu = db.Column(db.DateTime())
tenphieu = db.Column(db.String)
donvibaocao = db.Column(db.String)
phamvi = db.Column(db.String)
ngaynaocao = db.Column(db.DateTime())
kqvschung_id = db.Column(UUID(as_uuid=True),
ForeignKey('kqvschung.id'),
nullable=True)
kqvschung = relationship('KetQuaVSChung')
tongsomaunuoclamxetnghiem = db.Column(db.String)
tongsodat = db.Column(db.String)
tyledat = db.Column(db.String)
tongsokdat = db.Column(db.String)
cumdancuduoi500ng_id = db.Column(UUID(as_uuid=True),
ForeignKey('cumdancuduoi500ng.id'),
nullable=True)
cumdancuduoi500ng = relationship('CumDanCuDuoi500ng')
cacbienphapsuly = db.Column(db.String)
cacbienphapsuly500ng_id = db.Column(UUID(as_uuid=True),
ForeignKey('cacbienphapsuly500ng.id'),
nullable=True)
cacbienphapsuly500ng = relationship('CacBienPhapSuLy500ng')
nhanxet = db.Column(db.String)
kiennghi = db.Column(db.String)
kyten = db.Column(db.String)
class KetQuaNgoaiKiemChatLuongNuocSach(CommonModel):
__tablename__ = 'ketqua_ngoaikiem_chatluong_nuocsach'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True), db.ForeignKey('user.id'), nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger,nullable=False)
nambaocao = db.Column(db.Integer, nullable=False)
ngaybaocao = db.Column(db.DateTime())
donvicapnuoc_id = db.Column(UUID(as_uuid=True), db.ForeignKey('donvicapnuoc.id'), nullable=False)
donvicapnuoc = db.relationship('DonViCapNuoc', viewonly=True)
tendonvicapnuoc = db.Column(db.String)
diachi_donvicapnuoc = db.Column(db.String)
congsuat_thietke = db.Column(DECIMAL)
tongso_hogiadinh = db.Column(db.Integer, default=0)
nguonnuoc_nguyenlieu = db.Column(db.SmallInteger)
tansuat_noikiem = db.Column(db.String)
thoigiankiemtra = db.Column(db.DateTime())
tendonvi_ngoaikiem = db.Column(db.String)
noidung_ngoaikiem = db.Column(db.String)
thunghiem_chatluong_nuoc = db.Column(db.SmallInteger, default=0)
loai_donvi_kiemtra = db.Column(db.SmallInteger)
thanhphan_doankiemtra = db.Column(db.String)
laphoso_theoquydinh = db.Column(db.SmallInteger, default=0)
hoso_daydu_theoquydinh = db.Column(db.SmallInteger, default=0)
tailieu_thieu = db.Column(db.String)
somau_thunghiem_dungquydinh = db.Column(db.SmallInteger, default=0)
thunghiem_daydu_thongso = db.Column(db.SmallInteger, default=0)
tansuat_thuchien_noikiem_dungquydinh = db.Column(db.SmallInteger, default=0)
thuchien_baocao_daydu = db.Column(db.SmallInteger, default=0)
thuchien_congkhai_thongtin = db.Column(db.SmallInteger, default=0)
thuchien_bienphap_khacphuc = db.Column(db.SmallInteger, default=0)
tongsomau_noikiem_thunghiem = db.Column(db.Integer, default=0)
tongsomau_noikiem_dat_quychuan = db.Column(db.Integer, default=0)
tongsomau_noikiem_khongdat_quychuan = db.Column(db.Integer, default=0)
tong_thongso_noikiem_khongdat = db.Column(db.Integer, default=0)
danhsachthongso_noikiem_khongdat = db.Column(JSONB)
tong_thongso_ngoaikiem_khongdat = db.Column(db.Integer, default=0)
danhsachthongso_ngoaikiem_khongdat = db.Column(JSONB)
somauvavitri = db.Column(db.Integer, default=0)
danhsachvitrilaymau = db.Column(JSONB)
ketquangoaikiemchatluongnuoc = db.Column(JSONB)
ketquangoaikiem = db.Column(db.SmallInteger, default=0)
nhanxet = db.Column(db.String)
congbo_thongtin_chodonvicapnuoc = db.Column(db.SmallInteger, default=0)
congkhai_thongtin = db.Column(db.SmallInteger, default=0)
thongbao_coquan_thamquyen = db.Column(db.SmallInteger, default=0)
thongbao_donvi_chuquan = db.Column(db.SmallInteger, default=0)
kiennghi = db.Column(db.String)
ketluan = db.Column(db.String)
class VienChuyenNganhKhuVuc(CommonModel):
__tablename__ = 'vienchuyennganhkhuvuc'
id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid)
tenphuluc = db.Column(db.String)
thongtu = db.Column(db.String)
ngaybanhanhthongtu = db.Column(db.DateTime())
tenphieu = db.Column(db.String)
donvibaocao = db.Column(db.String)
phamvi = db.Column(db.String)
ngaynaocao = db.Column(db.DateTime())
tongsonhamay = db.Column(db.String)
tongsonhamaydckt = db.Column(db.String)
tongsoluotkt = db.Column(db.String)
soluotktkodat = db.Column(db.String)
tylekodat = db.Column(db.String)
socskt2lankdat = db.Column(db.String)
tongsomaulamxn = db.Column(db.String)
tongsodat = db.Column(db.String)
tyledat = db.Column(db.String)
tongsomaukdat = db.Column(db.String)
tylekodat = db.Column(db.String)
halankodat = db.Column(db.String)
somaukdatvatly = db.Column(db.String)
somaukdatvisinhvat = db.Column(db.String)
cacbienphapsuly = db.Column(db.String)
kqktvschungho500ng_id = db.Column(UUID(as_uuid=True),
ForeignKey('kqktvschungho500ng.id'),
nullable=True)
kqktvschungho500ng = relationship('KQKTVSChungHo500ng')
tongsomaulamxetnghiem2 = db.Column(db.String)
tongsomaudat2 = db.Column(db.String)
tyledat2 = db.Column(db.String)
kqktvschungho500ngkdat_id = db.Column(
UUID(as_uuid=True),
ForeignKey('kqktvschungho500ngkdat.id'),
nullable=True)
kqktvschungho500ngkdat = relationship('KQKTVSChungHo500ngKDat')
tonghopkqktvschungho500ng_id = db.Column(
UUID(as_uuid=True),
ForeignKey('tonghopkqktvschungho500ng.id'),
nullable=True)
tonghopkqktvschungho500ng = relationship('TongHopKQKTVSChungHo500ng')
ketqua = db.Column(db.String)
hoatdong = db.Column(db.String)
kyten = db.Column(db.String)
nhanxetkiennghi = db.Column(db.String)
kyten = db.Column(db.String)
class TienDoKeHoachBCC(CommonModel):
__tablename__ = 'tiendo_kehoach_bcc'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True),
db.ForeignKey('user.id'),
nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger, nullable=False)
ngaybaocao = db.Column(db.DateTime(), default=default_datetime_now)
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False)
loaikybaocao = db.Column(db.Integer, nullable=False)
# danhmucnganh_id = db.Column(UUID(as_uuid=True), ForeignKey('danhmucnganh.id'), nullable=True)
# danhmucnganh = relationship('DanhMucNganh')
tinhthanh_id = db.Column(UUID(as_uuid=True),
ForeignKey('tinhthanh.id'),
nullable=True)
tinhthanh = relationship('TinhThanh')
quanhuyen_id = db.Column(UUID(as_uuid=True),
ForeignKey('quanhuyen.id'),
nullable=True)
quanhuyen = relationship('QuanHuyen')
xaphuong_id = db.Column(UUID(as_uuid=True),
ForeignKey('xaphuong.id'),
nullable=True)
xaphuong = relationship('XaPhuong')
thonxom_id = db.Column(UUID(as_uuid=True),
ForeignKey('thonxom.id'),
nullable=True)
thonxom = relationship('ThonXom')
tiendo_xaydung = db.Column(db.SmallInteger, nullable=True)
tiendo_rasoat = db.Column(db.SmallInteger, nullable=True)
tiendo_pheduyet = db.Column(db.SmallInteger, nullable=True)
ngay_pheduyet = db.Column(db.DateTime())
sohoatdong_cotloi_pheduyet = db.Column(db.Integer)
sohoatdong_cotloi_hoanthanh = db.Column(db.Integer)
# nganh_id = db.Column(UUID(as_uuid=True), ForeignKey('nganh.id'), nullable=True)
# nganh = relationship('Nganh')
giangvien = db.Column(db.Integer, default=0) # giang vien tai don vi
giangvien_nu = db.Column(db.Integer, default=0) # giang vien tai don vi
tongsogiangvien = db.Column(
db.Integer, default=0) #tong so giang vien, bao gom cac don vi con
tongsogiangvien_nu = db.Column(db.Integer, default=0)
tongsonguoithamgia = db.Column(db.Integer, default=0)
tongsonguoithamgia_nu = db.Column(db.Integer, default=0)
tongsonguoithamgia_dtts = db.Column(db.Integer, default=0)
danhsach_hoatdong = db.Column(JSONB())
tuyendonvi = db.Column(db.String) #tinh/huyen/xa/thon
class User(db.Model):
__tablename__ = 'na_user'
__table_args__ = {'extend_existing': True}
uuid = db.Column(UUID(), primary_key=True, default=uuid_ext.uuid4)
firstname = db.Column(db.String(255), index=True, nullable=False)
secondname = db.Column(db.String(255), index=True, nullable=False)
email = db.Column(db.String(255), index=True, unique=True, nullable=False)
password_hash = db.Column(db.String(128))
thirdparty_authenticated = db.Column(db.Boolean,
nullable=False,
default=False)
thirdparty_name = db.Column(db.String(255))
authenticated = db.Column(db.Boolean, nullable=False, default=False)
last_login_at = db.Column(db.DateTime())
current_login_at = db.Column(db.DateTime())
last_login_ip = db.Column(db.String(100))
current_login_ip = db.Column(db.String(100))
login_count = db.Column(db.Integer)
active = db.Column(db.Boolean())
roles = relationship('Role',
secondary=user_role_assoc,
backref=db.backref('users', lazy='dynamic'))
group_uuid = db.Column(UUID, db.ForeignKey('na_user_group.uuid'))
group = relationship('Group', back_populates='users')
group_admin = db.Column(db.Boolean, nullable=False, default=False)
created = db.Column(db.DateTime, default=datetime.utcnow)
updated = db.Column(db.DateTime,
default=datetime.utcnow,
onupdate=datetime.utcnow)
def get_id(self):
return self.uuid
def is_authenticated(self):
return self.authenticated
def set_password(self, password):
self.password_hash = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password_hash, password)
def is_active(self):
return self.active
def add_roles(self, *roles):
self.roles.extend([role for role in roles if role not in self.roles])
def remove_roles(self, *roles):
self.roles = [role for role in self.roles if role not in roles]
class yTEDuPhongTinh(CommonModel):
__tablename__ = 'yteduphongtinh'
id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid)
tenphuluc = db.Column(db.String)
thongtu = db.Column(db.String)
ngaybanhanhthongtu = db.Column(db.DateTime())
tenphieu = db.Column(db.String)
donvibaocao = db.Column(db.String)
phamvi = db.Column(db.String)
ngaynaocao = db.Column(db.DateTime())
tongsonhamay = db.Column(db.String)
tongsonhamaydckt = db.Column(db.String)
tongsoluotkt = db.Column(db.String)
soluotktkodat = db.Column(db.String)
tylekodat = db.Column(db.String)
socskt2lankdat = db.Column(db.String)
tongsomaulamxn = db.Column(db.String)
tongsodat = db.Column(db.String)
tyledat = db.Column(db.String)
tongsomaukdat = db.Column(db.String)
tylekodat = db.Column(db.String)
halankodat = db.Column(db.String)
somaukdatvatly = db.Column(db.String)
somaukdatvisinhvat = db.Column(db.String)
cacbienphapsuly = db.Column(db.String)
tramcapnuoc500ng_id = db.Column(UUID(as_uuid=True),
ForeignKey('tramcapnuoc500ng.id'),
nullable=True)
tramcapnuoc500ng = relationship('TramCapNuoc500ng')
tongsomaulamxetnghiem2 = db.Column(db.String)
tongsomaudat2 = db.Column(db.String)
tyledat2 = db.Column(db.String)
xetnghiemnuoc500ng_id = db.Column(UUID(as_uuid=True),
ForeignKey('xetnghiemnuoc500ng.id'),
nullable=True)
xetnghiemnuoc500ng = relationship('XetNghiemNuoc500ng')
vsnhatieugd_id = db.Column(UUID(as_uuid=True),
ForeignKey('vsnhatieugd.id'),
nullable=True)
vsnhatieugd = relationship('VSNhaTieuGD')
nhanxet = db.Column(db.String)
kiennghi = db.Column(db.String)
kyten = db.Column(db.String)
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 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 BaoCaoNghiNgoNhiemBenhQuocGia(CommonModel):
__tablename__ = 'baocaonghingonhiembenhquocgia'
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('baocaonghingonhiembenhquocgia',lazy='dynamic'))
tenquocgia = db.Column(db.String())
ngaydiqua = db.Column(db.DateTime())
class BaoCaoTienDoDuyTriVSTXBenVung(CommonModel):
__tablename__ = 'baocao_tiendo_duytri_vstx_benvung'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True),
db.ForeignKey('user.id'),
nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger, nullable=False)
ngaybaocao = db.Column(db.DateTime())
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False)
loaikybaocao = db.Column(db.Integer, nullable=False)
tinhthanh_id = db.Column(UUID(as_uuid=True),
ForeignKey('tinhthanh.id'),
nullable=True)
tinhthanh = relationship('TinhThanh')
quanhuyen_id = db.Column(UUID(as_uuid=True),
ForeignKey('quanhuyen.id'),
nullable=True)
quanhuyen = relationship('QuanHuyen')
xaphuong_id = db.Column(UUID(as_uuid=True),
ForeignKey('xaphuong.id'),
nullable=True)
xaphuong = relationship('XaPhuong')
nam_datvesinh_toanxa = db.Column(db.Integer)
nam_datvesinh_toanxa_benvung = db.Column(db.Integer)
tyle_truong_duytri_vesinh = db.Column(db.DECIMAL)
tyle_tramyte_duytri_vesinh = db.Column(db.DECIMAL)
class BaoCaoVienChuyenNganhNuoc(CommonModel):
__tablename__ = 'baocao_vienchuyennganh_nuoc'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True), db.ForeignKey('user.id'), nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger,nullable=False)
ngaybaocao = db.Column(db.DateTime())
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False, default=1)
loaikybaocao = db.Column(db.Integer, nullable=False)#thang=1,quy=2,6thang=3,nam=4
tong_tinh_phutrach = db.Column(db.Integer, default=0)
tong_tinh_cobaocao = db.Column(db.Integer, default=0)
tong_donvi_capnuoc_phutrach = db.Column(db.Integer, default=0)
tong_hogiadinh_duoccungcapnuoc = db.Column(db.Integer, default=0)
tong_hogiadinh_diaban = db.Column(db.Integer, default=0)
tong_maunuoc_thunghiem_ngoaikiem_vien = db.Column(db.Integer, default=0)
tong_mau_dat_quychuan_ngoaikiem_vien = db.Column(db.Integer, default=0)
tong_mau_khongdat_quychuan_ngoaikiem_vien = db.Column(db.Integer, default=0)
thongso_khongdat_ngoaikiem_vien = db.Column(JSONB)
ketqua_kiemtra_noikiem_tinh = db.Column(JSONB)
cacdexuat_kythuat = db.Column(db.String)
nghiencuu_chatluong_nuocsach = db.Column(db.String)
ketluan = db.Column(db.String)
dexuat = db.Column(db.String)
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 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 User(CommonModel):
__tablename__ = 'user'
id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid)
first_name = db.Column(db.String(255))
last_name = db.Column(db.String(255))
fullname = db.Column(db.String(255))
email = db.Column(db.String(255), unique=True)
password = db.Column(db.String(255))
confirmpassword = db.Column(db.String(255))
active = db.Column(db.Boolean(), default=True)
phone = db.Column(db.String(255), unique=True)
birthday = db.Column(db.DateTime())
gender = db.Column(db.String(255))
macongdan = db.Column(db.String(255), unique=True)
roles = db.relationship('Role',
secondary=roles_users,
backref=db.backref('users', lazy='dynamic'))
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
confirmed_at = db.Column(db.DateTime())
last_login_at = db.Column(db.DateTime())
current_login_at = db.Column(db.DateTime())
last_login_ip = db.Column(db.String(255))
current_login_ip = db.Column(db.String(255))
login_count = db.Column(db.Integer)
trangthai = db.Column(db.SmallInteger)
def __repr__(self):
""" Show user object info. """
return '<User: {}>'.format(self.id)
def has_role(self, role):
if isinstance(role, str):
return role in (role.name for role in self.roles)
else:
return role in self.roles
def add_role(self, role):
pass
def remove_role(self, role):
pass
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 NcSachNhaTieuHoGD(CommonModel):
__tablename__ = 'ncsachnhatieuhogd'
id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid)
tenphuluc = db.Column(db.String)
thongtu = db.Column(db.String)
ngaybanhanhthongtu = db.Column(db.DateTime())
tenphieu = db.Column(db.String)
donvibaocao = db.Column(db.String)
phamvi = db.Column(db.String)
ngaynaocao = db.Column(db.DateTime())
hinhthuccapnuoc_id = db.Column(UUID(as_uuid=True),
ForeignKey('hinhthuccungcapnchogd.id'),
nullable=True)
hinhthuccapnuoc = relationship('HinhThucCungCapNcHoGD')
cacbienphapsuly_id = db.Column(UUID(as_uuid=True),
ForeignKey('cacbienphapsuly.id'),
nullable=True)
cacbienphapsuly = relationship('CacBienPhapSuLy')
nhanxetkiennghi = db.Column(db.String)
kyten = db.Column(db.String)
class TrungTamYteDuPhong(CommonModel):
__tablename__ = 'trungtamyteduphong'
id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid)
tenphuluc = db.Column(db.String)
thongtu = db.Column(db.String)
ngaybanhanhthongtu = db.Column(db.DateTime())
tenphieu = db.Column(db.String)
donvibaocao = db.Column(db.String)
phamvi = db.Column(db.String)
ngaynaocao = db.Column(db.DateTime())
tongsonhamay = db.Column(db.String)
sonhamaydckiemtra = db.Column(db.String)
sonhamaydambaovesinh = db.Column(db.String)
somaulaxn = db.Column(db.String)
somaudat = db.Column(db.String)
tyledat = db.Column(db.String)
kodatvatlyhoahoc = db.Column(db.String)
kdatvisinhvat = db.Column(db.String)
cacbienphapsuly = db.Column(db.String)
nhanxet = db.Column(db.String)
kiennghi = db.Column(db.String)
kyten = db.Column(db.String)
class User(CommonModel):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255))
email = db.Column(db.String(255), unique=True)
password = db.Column(db.String(255))
first_name = db.Column(db.String(120))
last_name = db.Column(db.String(120))
active = db.Column(db.Boolean(), default=False)
confirmed_at = db.Column(db.DateTime())
roles = db.relationship('Role', secondary=roles_users)
last_login_at = db.Column(db.DateTime())
current_login_at = db.Column(db.DateTime())
last_login_ip = db.Column(db.String(255))
current_login_ip = db.Column(db.String(255))
login_count = db.Column(db.Integer)
birthday = db.Column(db.DateTime())
gender = db.Column(db.String(255))
phone = db.Column(db.String(31))
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)
def __repr__(self):
return '<models.User[email=%s]>' % self.email
def __is_admin__(self):
return True
def has_role(self, role):
"""Returns `True` if the user identifies with the specified role.
:param role: A role name or `Role` instance"""
if isinstance(role, str):
return role in (role.name for role in self.roles)
else:
return role in self.roles
class BaoCaoVien(CommonModel):
__tablename__ = 'baocaovien'
id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255), unique=True)
ngaybaocao = db.Column(db.DateTime(),default=func.now())
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)
danhgia = db.Column(db.String())
kiennghivien = db.Column(db.String())
kiennghidonvi = db.Column(db.String())
tinhtrang = db.Column(db.SmallInteger, nullable=False, default=1)
__table_args__ = (UniqueConstraint('donvi_id', 'ma', name='uq_baocaovien_donvi_id_ma'),)
class Phieu_DieuTra_Truonghoc_TramYTe_Vesinh_CapNuoc(CommonModel):
__tablename__ = 'phieu_dieutra_truonghoc_tramyte_vesinh_capnuoc'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True), db.ForeignKey('user.id'), nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger,nullable=False)
ngaybaocao = db.Column(db.DateTime())
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False)
loaikybaocao = db.Column(db.Integer, nullable=False)
tinhthanh_id = db.Column(UUID(as_uuid=True), ForeignKey('tinhthanh.id'), nullable=True)
tinhthanh = relationship('TinhThanh')
quanhuyen_id = db.Column(UUID(as_uuid=True), ForeignKey('quanhuyen.id'), nullable=True)
quanhuyen = relationship('QuanHuyen')
xaphuong_id = db.Column(UUID(as_uuid=True), ForeignKey('xaphuong.id'), nullable=True)
xaphuong = relationship('XaPhuong')
ten_truong_tramyte = db.Column(db.String)
ma_truong_tramyte = db.Column(db.String)
loai_truong_tramyte = db.Column(db.Integer)
loaidiem_truong = db.Column(db.Integer)#chinh,phu
# buoihoc_moihocsinh = db.Column(db.Integer)
truong_sobuoihoc = db.Column(db.Integer)
truong_sohocsinh_moibuoi = db.Column(db.Integer)
truong_sohocsinh_nam = db.Column(db.Integer)
truong_sohocsinh_nu = db.Column(db.Integer)
tennguoitraloi = db.Column(db.String)
chucvu_nguoitraloi = db.Column(db.String)
thongtinlienlac = db.Column(db.String)
nguonnuocchinh = db.Column(db.Integer)
nguonnuocchinh_loaikhac = db.Column(db.String)
chatluongnuocuong = db.Column(db.Integer)
sokhuvesinh_truong_tramyte = db.Column(db.Integer)
sokhuvesinh_truong_hossinh_nam = db.Column(db.Integer)
sokhuvesinh_truong_hocsinh_nu = db.Column(db.Integer)
sokhuvesinh_truong_giaovien_nam = db.Column(db.Integer)
sokhuvesinh_truong_giaovien_nu = db.Column(db.Integer)
phieuchitiet = db.Column(JSONB)#Phieu_Chitiet_Vesinh_Capnuoc_Truong_TramYTe
ghichu = db.Column(db.String)
ketluan = db.Column(db.SmallInteger, default=0)
class TienDoVeSinhToanXa(CommonModel):
__tablename__ = 'tiendovesinhtoanxa'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True),
db.ForeignKey('user.id'),
nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger, nullable=False)
ngaybaocao = db.Column(db.DateTime())
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False)
loaikybaocao = db.Column(db.Integer, nullable=False)
tinhthanh_id = db.Column(UUID(as_uuid=True),
ForeignKey('tinhthanh.id'),
nullable=True)
tinhthanh = relationship('TinhThanh')
quanhuyen_id = db.Column(UUID(as_uuid=True),
ForeignKey('quanhuyen.id'),
nullable=True)
quanhuyen = relationship('QuanHuyen')
xaphuong_id = db.Column(UUID(as_uuid=True),
ForeignKey('xaphuong.id'),
nullable=True)
xaphuong = relationship('XaPhuong')
tyle_hogiadinh_nhatieucaithien = db.Column(db.DECIMAL)
tyle_hogiadinh_diemruatay = db.Column(db.DECIMAL)
tyle_truonghoc_conuocsach_nhatieuhvs = db.Column(db.DECIMAL)
tonso_hocsinh = db.Column(db.Integer)
tyle_tramyte_conuocsach_nhatieuhvs = db.Column(db.Integer)
tongso_hogiadinh_xa = db.Column(db.Integer)
tong_danso_xa = db.Column(db.Integer)
tyle_giadinh_chulanu = db.Column(db.DECIMAL)
tyle_hogiadinh_dtts = db.Column(db.DECIMAL)
class BaoCaoNuocSachHuyenTinh(CommonModel):
__tablename__ = 'baocao_nuocsach_huyentinh'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True), db.ForeignKey('user.id'), nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger,nullable=False)
ngaybaocao = db.Column(db.DateTime())
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False, default=1)
loaikybaocao = db.Column(db.Integer, nullable=False)#thang=1,quy=2,6thang=3,nam=4
loaibaocao = db.Column(db.SmallInteger, nullable=False, default=1)#captinh=1, caphuyen=2
tinhthanh_id = db.Column(UUID(as_uuid=True), ForeignKey('tinhthanh.id'), nullable=True)
tinhthanh = relationship('TinhThanh')
quanhuyen_id = db.Column(UUID(as_uuid=True), ForeignKey('quanhuyen.id'), nullable=True)
quanhuyen = relationship('QuanHuyen')
tong_donvi_capnuoc = db.Column(db.Integer, default=0)
tong_donvi_capnuoc_mat = db.Column(db.Integer, default=0)
tong_donvi_capnuoc_ngam = db.Column(db.Integer, default=0)
tong_donvi_capnuoc_mat_ngam = db.Column(db.Integer, default=0)
tong_donvi_capnuoc_duoi1000m3 = db.Column(db.Integer, default=0)
tong_donvi_capnuoc_tren1000m3 = db.Column(db.Integer, default=0)
tong_hogiadinh_duoccungcapnuoc = db.Column(db.Integer, default=0)
tong_hogiadinh_diaban = db.Column(db.Integer, default=0)
tong_soluot_ngoaikiem = db.Column(db.Integer, default=0)
tong_donvi_capnuoc_thuchien_ngoaikiem = db.Column(db.Integer, default=0)
tong_kinhphi_congtac_ngoaikiem = db.Column(db.Integer, default=0)
kinhphi_ngoaikiem_sovoinamtruoc = db.Column(db.SmallInteger)
#lay so lieu tu bao cao 2B cua donvi cong don len
tongdat_laphoso_theoquydinh_ngoaikiem = db.Column(db.Integer, default=0)
tongdat_hoso_daydu_theoquydinh_ngoaikiem = db.Column(db.Integer, default=0)
tongdat_somau_thunghiem_dungquydinh_ngoaikiem = db.Column(db.Integer, default=0)
tongdat_thunghiem_daydu_thongso_ngoaikiem = db.Column(db.Integer, default=0)
tongdat_tansuat_thuchien_noikiem_dungquydinh_ngoaikiem = db.Column(db.Integer, default=0)
tongdat_thuchien_baocao_daydu_ngoaikiem = db.Column(db.Integer, default=0)
tongdat_thuchien_congkhai_thongtin_ngoaikiem = db.Column(db.Integer, default=0)
tongdat_thuchien_bienphap_khacphuc_ngoaikiem = db.Column(db.Integer, default=0)
tong_maunuoc_thunghiem_ngoaikiem_trungtam = db.Column(db.Integer, default=0)
tong_mau_dat_quychuan_ngoaikiem_trungtam = db.Column(db.Integer, default=0)
tong_mau_khongdat_quychuan_ngoaikiem_trungtam = db.Column(db.Integer, default=0)
thongso_khongdat_ngoaikiem_trungtam = db.Column(JSONB)
hoso_quanly_noikiem = db.Column(JSONB)
tong_maunuoc_thunghiem_noikiem = db.Column(db.Integer, default=0)
tong_mau_dat_quychuan_noikiem = db.Column(db.Integer, default=0)
tong_mau_khongdat_quychuan_noikiem = db.Column(db.Integer, default=0)
thongso_khongdat_noikiem = db.Column(JSONB)
danhsach_donvi_ngoaikiem = db.Column(JSONB)
hoso_quanly_ngoaikiem_baocao = db.Column(JSONB)
tong_maunuoc_thunghiem_ngoaikiem_baocao = db.Column(db.Integer, default=0)
tong_mau_dat_quychuan_ngoaikiem_baocao = db.Column(db.Integer, default=0)
tong_mau_khongdat_quychuan_ngoaikiem_baocao = db.Column(db.Integer, default=0)
thongso_khongdat_ngoaikiem_baocao = db.Column(JSONB)
thongbao_thongtin_chatluongnuoc = db.Column(db.Integer, default=0)
congkhai_thongtin_coquan_ngoaikiem = db.Column(db.Integer, default=0)
thongbao_coquan_thamquyen = db.Column(db.Integer, default=0)
thongbao_donvi_chuquan = db.Column(db.Integer, default=0)
nhanxet = db.Column(db.String)
dexuat = db.Column(db.String)
class TongHopKetQuaKiemTraChatLuongNuocSach(CommonModel):
__tablename__ = 'tonghop_ketqua_chatluong_nuocsach'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True), db.ForeignKey('user.id'), nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger,nullable=False)
ngaybaocao = db.Column(db.DateTime())
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False, default=1)
loaikybaocao = db.Column(db.Integer, nullable=False)#thang=1,quy=2,6thang=3,nam=4
donvicapnuoc_id = db.Column(UUID(as_uuid=True), db.ForeignKey('donvicapnuoc.id'), nullable=False)
donvicapnuoc = db.relationship('DonViCapNuoc', viewonly=True)
tendonvicapnuoc = db.Column(db.String)
diachi_donvicapnuoc = db.Column(db.String)
congsuat_thietke = db.Column(DECIMAL)
tongso_hogiadinh = db.Column(db.Integer)
nguonnuoc_nguyenlieu = db.Column(db.SmallInteger)
tansuat_noikiem = db.Column(db.Integer)
tinhthanh_id = db.Column(UUID(as_uuid=True), ForeignKey('tinhthanh.id'), nullable=True)
tinhthanh = relationship('TinhThanh')
quanhuyen_id = db.Column(UUID(as_uuid=True), ForeignKey('quanhuyen.id'), nullable=True)
quanhuyen = relationship('QuanHuyen')
xaphuong_id = db.Column(UUID(as_uuid=True), ForeignKey('xaphuong.id'), nullable=True)
xaphuong = relationship('XaPhuong')
#lay so lieu tu bao cao 1B cong don len
tong_laphoso_theoquydinh_noikiem = db.Column(db.Integer, default=0)
tong_hoso_daydu_theoquydinh_noikiem = db.Column(db.Integer, default=0)
tong_somau_thunghiem_dungquydinh_noikiem = db.Column(db.Integer, default=0)
tong_thunghiem_daydu_thongso_noikiem = db.Column(db.Integer, default=0)
tong_tansuat_thuchien_noikiem_dungquydinh_noikiem = db.Column(db.Integer, default=0)
tong_thuchien_baocao_daydu_noikiem = db.Column(db.Integer, default=0)
tong_thuchien_congkhai_thongtin_noikiem = db.Column(db.Integer, default=0)
tong_thuchien_bienphap_khacphuc_dat_noikiem = db.Column(db.Integer, default=0)
tong_thuchien_bienphap_khacphuc_khongdat_noikiem = db.Column(db.Integer, default=0)
tong_maunuoc_thunghiem_noikiem = db.Column(db.Integer, default=0)
tong_mau_dat_quychuan_noikiem = db.Column(db.Integer, default=0)
tong_mau_khongdat_quychuan_noikiem = db.Column(db.Integer, default=0)
thongso_khongdat_noikiem = db.Column(JSONB)
#lay tu form ngoai kiem
tong_solan_ngoaikiem = db.Column(db.Integer, default=0)
donvi_thuchien_ngoaikiem = db.Column(JSONB)
#lay so lieu tu bao cao 2B cong don len
tong_laphoso_theoquydinh_ngoaikiem = db.Column(db.Integer, default=0)
tong_hoso_daydu_theoquydinh_ngoaikiem = db.Column(db.Integer, default=0)
tong_somau_thunghiem_dungquydinh_ngoaikiem = db.Column(db.Integer, default=0)
tong_thunghiem_daydu_thongso_ngoaikiem = db.Column(db.Integer, default=0)
tong_tansuat_thuchien_noikiem_dungquydinh_ngoaikiem = db.Column(db.Integer, default=0)
tong_thuchien_baocao_daydu_ngoaikiem = db.Column(db.Integer, default=0)
tong_thuchien_congkhai_thongtin_ngoaikiem = db.Column(db.Integer, default=0)
tong_thuchien_bienphap_khacphuc_dat_ngoaikiem = db.Column(db.Integer, default=0)
tong_thuchien_bienphap_khacphuc_khongdat_ngoaikiem = db.Column(db.Integer, default=0)
tong_maunuoc_thunghiem_ngoaikiem = db.Column(db.Integer, default=0)
tong_mau_dat_quychuan_ngoaikiem = db.Column(db.Integer, default=0)
tong_mau_khongdat_quychuan_ngoaikiem = db.Column(db.Integer, default=0)
thongso_khongdat_ngoaikiem = db.Column(JSONB)
ketluan_dexuat = db.Column(db.String)
class VSCapThon(CommonModel):
__tablename__ = 'vscapthon'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True),
db.ForeignKey('user.id'),
nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger, nullable=False)
ngaybaocao = db.Column(db.DateTime())
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False, default=1)
loaikybaocao = db.Column(db.Integer,
nullable=False) #thang=1,quy=2,6thang=3,nam=4
# tungay = db.Column(db.Date())
# denngay = db.Column(db.Date())
nhatieuthonhvs = db.Column(JSONB())
tinhthanh_id = db.Column(UUID(as_uuid=True),
ForeignKey('tinhthanh.id'),
nullable=True)
tinhthanh = relationship('TinhThanh')
quanhuyen_id = db.Column(UUID(as_uuid=True),
ForeignKey('quanhuyen.id'),
nullable=True)
quanhuyen = relationship('QuanHuyen')
xaphuong_id = db.Column(UUID(as_uuid=True),
ForeignKey('xaphuong.id'),
nullable=True)
xaphuong = relationship('XaPhuong')
thuocsuprsws = db.Column(db.SmallInteger)
tenthon = db.Column(db.String)
thonxom_id = db.Column(UUID(as_uuid=True),
ForeignKey('thonxom.id'),
nullable=True)
thonxom = relationship('ThonXom', viewonly=True)
tong_soho = db.Column(db.Integer, default=0)
tong_chuholanu = db.Column(db.Integer, default=0)
tong_sohongheo = db.Column(db.Integer, default=0)
tong_sohodtts = db.Column(db.Integer, default=0)
tong_danso = db.Column(db.Integer, default=0)
tong_nam = db.Column(db.Integer, default=0)
tong_nu = db.Column(db.Integer, default=0)
tong_soho_conhatieu = db.Column(db.Integer, default=0)
tong_khongnhatieu = db.Column(db.Integer, default=0)
tong_hopvs = db.Column(db.Integer, default=0) #
tong_khonghopvs = db.Column(db.Integer, default=0) #
tong_soho_conhatieu_truocbaocao = db.Column(db.Integer, default=0)
tong_soho_conhatieu_xaymoi = db.Column(db.Integer, default=0)
tong_soho_conhatieu_hvs_truocbaocao = db.Column(db.Integer, default=0)
tong_soho_conhatieu_hvs_xuongcap = db.Column(db.Integer, default=0)
tong_tuhoai = db.Column(db.Integer, default=0)
tong_tuhoai_hvs = db.Column(db.Integer, default=0)
tong_tuhoai_xaymoi = db.Column(db.Integer, default=0)
tong_soho_conhatieu_tuhoai_hvs_truocbaocao = db.Column(db.Integer,
default=0)
tong_soho_conhatieu_tuhoai_hvs_xuongcap = db.Column(db.Integer, default=0)
tong_thamdoi = db.Column(db.Integer, default=0)
tong_thamdoi_hvs = db.Column(db.Integer, default=0)
tong_thamdoi_xaymoi = db.Column(db.Integer, default=0)
tong_soho_conhatieu_thamdoi_hvs_truocbaocao = db.Column(db.Integer,
default=0)
tong_soho_conhatieu_thamdoi_hvs_xuongcap = db.Column(db.Integer, default=0)
tong_2ngan = db.Column(db.Integer, default=0)
tong_2ngan_hvs = db.Column(db.Integer, default=0)
tong_2ngan_xaymoi = db.Column(db.Integer, default=0)
tong_soho_conhatieu_2ngan_hvs_truocbaocao = db.Column(db.Integer,
default=0)
tong_soho_conhatieu_2ngan_hvs_xuongcap = db.Column(db.Integer, default=0)
tong_ongthonghoi = db.Column(db.Integer, default=0)
tong_ongthonghoi_hvs = db.Column(db.Integer, default=0)
tong_ongthonghoi_xaymoi = db.Column(db.Integer, default=0)
tong_soho_conhatieu_vip_hvs_truocbaocao = db.Column(db.Integer, default=0)
tong_soho_conhatieu_vip_hvs_xuongcap = db.Column(db.Integer, default=0)
tong_loaikhac = db.Column(db.Integer, default=0)
tong_loaikhac_hvs = db.Column(db.Integer, default=0)
tong_caithien = db.Column(db.Integer, default=0)
tong_caithien_hvs = db.Column(db.Integer, default=0) #
tong_caithien_hongheo = db.Column(db.Integer, default=0)
tong_caithien_hongheo_hvs = db.Column(db.Integer, default=0) #
tong_soho_conhatieu_caithien_hvs_truocbaocao = db.Column(db.Integer,
default=0)
tong_soho_conhatieu_caithien_hvs_xuongcap = db.Column(db.Integer,
default=0)
tong_soho_conhatieu_caithien_hongheo_hvs_truocbaocao = db.Column(
db.Integer, default=0)
tong_soho_conhatieu_caithien_hongheo_hvs_xuongcap = db.Column(db.Integer,
default=0)
tong_diemruatay = db.Column(db.Integer, default=0)
class BaoCaoNghiNgoNhiemBenh(CommonModel):
__tablename__ = 'baocaonghingonhiembenh'
id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255))
matokhaiyte = db.Column(db.String(), index=True)
ngaybaocao = db.Column(db.DateTime(),default=func.now(), index=True)
noibaocao = db.Column(db.String(255))
nambaocao = db.Column(db.Integer, nullable=False)
donvi_id = db.Column(db.Integer,db.ForeignKey('donvi.id'), nullable=True, index=True)
tendonvi = db.Column(db.String())
madonvi = db.Column(db.String())
donvi = db.relationship('DonVi',viewonly=True)
cuakhau_id = db.Column(db.Integer, index=True, nullable=True)
tencuakhau = db.Column(db.String())
macuakhau = db.Column(db.String())
#dulieu
hoten = db.Column(db.String(), index=True)
gioitinh = db.Column(db.String(20))
namsinh = db.Column(db.Integer())
quoctich = db.Column(db.String())
ma_quoctich = db.Column(db.String())
cmtnd = db.Column(db.String(), index=True)
cuakhau_nhapquacanh = db.Column(db.String())
gio_nhapquacanh = db.Column(db.Integer())
ngay_nhapquacanh = db.Column(db.DateTime())
phuongtien = db.Column(db.String())
sohieu_phuongtien = db.Column(db.String())
noio = db.Column(db.String())
noio_tinhthanh = db.Column(db.String())
noio_matinhthanh = db.Column(db.String())
diachi_lienlac = db.Column(db.String())
email = db.Column(db.String())
dienthoai = db.Column(db.String(63))
benh_nghingo = db.Column(db.String())
tiensu_dichte = db.Column(db.String())
tiensu_ngaykhoiphat = db.Column(db.DateTime())
tiensu_trieuchunglamsang = db.Column(db.String())
tiensu_chandoan = db.Column(db.String())
tiensu_xutri = db.Column(db.String())
noitiepnhan_xutri = db.Column(db.String())
nhanxet_danhgia = db.Column(db.String())
dauhieubenh_sot = db.Column(db.SmallInteger)
dauhieubenh_ho = db.Column(db.SmallInteger)
dauhieubenh_khotho = db.Column(db.SmallInteger)
dauhieubenh_dauhong = db.Column(db.SmallInteger)
dauhieubenh_buonnon = db.Column(db.SmallInteger)
dauhieubenh_tieuchay = db.Column(db.SmallInteger)
dauhieubenh_xuathuyetngoaida = db.Column(db.SmallInteger)
dauhieubenh_phatban = db.Column(db.SmallInteger)
ngaygio_phathien = db.Column(db.String())
huongxutri = db.Column(db.String())
tinhtrang = db.Column(db.SmallInteger, nullable=False, default=1)
class VSCapTinh(CommonModel):
__tablename__ = 'vscaptinh'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True),
db.ForeignKey('user.id'),
nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger, nullable=False)
ngaybaocao = db.Column(db.DateTime())
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False)
loaikybaocao = db.Column(db.Integer, nullable=False)
tinhthanh_id = db.Column(UUID(as_uuid=True),
ForeignKey('tinhthanh.id'),
nullable=True)
tinhthanh = relationship('TinhThanh')
tentinh = db.Column(db.String)
tong_sohuyen = db.Column(db.Integer)
tong_soxa = db.Column(db.Integer)
tong_sothon = db.Column(db.Integer)
tong_soho = db.Column(db.Integer)
tong_chuholanu = db.Column(db.Integer)
tong_sohongheo = db.Column(db.Integer)
tong_sohodtts = db.Column(db.Integer)
tong_danso = db.Column(db.Integer)
tong_nam = db.Column(db.Integer)
tong_nu = db.Column(db.Integer)
tong_soho_conhatieu = db.Column(db.Integer, default=0)
tong_khongnhatieu = db.Column(db.Integer, default=0)
tong_hopvs = db.Column(db.Integer, default=0) #
tong_khonghopvs = db.Column(db.Integer, default=0) #
tong_soho_conhatieu_truocbaocao = db.Column(db.Integer, default=0)
tong_soho_conhatieu_xaymoi = db.Column(db.Integer, default=0)
tong_soho_conhatieu_hvs_truocbaocao = db.Column(db.Integer, default=0)
tong_soho_conhatieu_hvs_xuongcap = db.Column(db.Integer, default=0)
tong_tuhoai = db.Column(db.Integer, default=0)
tong_tuhoai_hvs = db.Column(db.Integer, default=0)
tong_tuhoai_xaymoi = db.Column(db.Integer, default=0)
tong_soho_conhatieu_tuhoai_hvs_truocbaocao = db.Column(db.Integer,
default=0)
tong_soho_conhatieu_tuhoai_hvs_xuongcap = db.Column(db.Integer, default=0)
tong_thamdoi = db.Column(db.Integer, default=0)
tong_thamdoi_hvs = db.Column(db.Integer, default=0)
tong_thamdoi_xaymoi = db.Column(db.Integer, default=0)
tong_soho_conhatieu_thamdoi_hvs_truocbaocao = db.Column(db.Integer,
default=0)
tong_soho_conhatieu_thamdoi_hvs_xuongcap = db.Column(db.Integer, default=0)
tong_2ngan = db.Column(db.Integer, default=0)
tong_2ngan_hvs = db.Column(db.Integer, default=0)
tong_2ngan_xaymoi = db.Column(db.Integer, default=0)
tong_soho_conhatieu_2ngan_hvs_truocbaocao = db.Column(db.Integer,
default=0)
tong_soho_conhatieu_2ngan_hvs_xuongcap = db.Column(db.Integer, default=0)
tong_ongthonghoi = db.Column(db.Integer, default=0)
tong_ongthonghoi_hvs = db.Column(db.Integer, default=0)
tong_ongthonghoi_xaymoi = db.Column(db.Integer, default=0)
tong_soho_conhatieu_vip_hvs_truocbaocao = db.Column(db.Integer, default=0)
tong_soho_conhatieu_vip_hvs_xuongcap = db.Column(db.Integer, default=0)
tong_loaikhac = db.Column(db.Integer, default=0)
tong_loaikhac_hvs = db.Column(db.Integer, default=0)
tong_caithien = db.Column(db.Integer, default=0)
tong_caithien_hvs = db.Column(db.Integer, default=0) #
tong_caithien_hongheo = db.Column(db.Integer, default=0)
tong_caithien_hongheo_hvs = db.Column(db.Integer, default=0) #
tong_soho_conhatieu_caithien_hvs_truocbaocao = db.Column(db.Integer,
default=0)
tong_soho_conhatieu_caithien_hvs_xuongcap = db.Column(db.Integer,
default=0)
tong_soho_conhatieu_caithien_hongheo_hvs_truocbaocao = db.Column(
db.Integer, default=0)
tong_soho_conhatieu_caithien_hongheo_hvs_xuongcap = db.Column(db.Integer,
default=0)
tong_diemruatay = db.Column(db.Integer, default=0)
danhsachbaocao = db.Column(JSONB())
class ToKhaiYTe(CommonModel):
__tablename__ = "tokhaiyte"
id = db.Column(db.String, primary_key=True)
ngaykekhai = db.Column(db.DateTime(), nullable=False)
donvi_id = db.Column(db.Integer, nullable=False, index=True)
tendonvi = db.Column(db.String())
madonvi = db.Column(db.String())
cuakhau_id = db.Column(db.Integer, nullable=False, index=True)
tencuakhau = db.Column(db.String())
macuakhau = db.Column(db.String())
canbo_id = db.Column(db.Integer, nullable=True)
tencanbo = db.Column(db.String)
emailcanbo = db.Column(db.String)
hoten = db.Column(db.String, index=True)
namsinh = db.Column(db.Integer)
gioitinh = db.Column(db.String)
quoctich = db.Column(db.String)
cmtnd = db.Column(db.String, index=True)
thongtindilai_taubay = db.Column(db.SmallInteger) #taubay, tauthuyen, oto, khac
thongtindilai_tauthuyen = db.Column(db.SmallInteger)
thongtindilai_oto = db.Column(db.SmallInteger)
thongtindilai_khac = db.Column(db.SmallInteger)
thongtindilai_chitiet = db.Column(db.String)
sohieu_phuongtien = db.Column(db.String)
soghe_phuongtien = db.Column(db.String)
ngay_khoihanh = db.Column(db.DateTime())
ngay_nhapcanh = db.Column(db.DateTime())
noi_khoihanh = db.Column(db.String)
noiden = db.Column(db.String)
quocgiadiqua = db.Column(db.String())
diachi_taivietnam = db.Column(db.String)
sodienthoai = db.Column(db.String)
email = db.Column(db.String)
dauhieubenh_sot = db.Column(db.SmallInteger)
dauhieubenh_ho = db.Column(db.SmallInteger)
dauhieubenh_khotho = db.Column(db.SmallInteger)
dauhieubenh_dauhong = db.Column(db.SmallInteger)
dauhieubenh_buonnon = db.Column(db.SmallInteger)
dauhieubenh_tieuchay = db.Column(db.SmallInteger)
dauhieubenh_xuathuyetngoaida = db.Column(db.SmallInteger)
dauhieubenh_phatban = db.Column(db.SmallInteger)
vacxin_dasudung = db.Column(db.String())
tiepxuc_dongvat = db.Column(db.SmallInteger())
chamsocnguoibenhtruyennhiem = db.Column(db.SmallInteger())
ngaygio_phathien = db.Column(db.String)
tinhtrang = db.Column(db.String)
huongxutri = db.Column(db.String)
cachlytaptrung = db.Column(db.String)
trangthai = db.Column(db.String)
note = db.Column(db.Text())
ngon_ngu = db.Column(db.String(10))
extra_data = db.Column(JSONB)
class Gioi_Dantoc_ThieuSo(CommonModel):
__tablename__ = 'gioi_dantoc_thieuso'
donvi_id = db.Column(db.Integer, db.ForeignKey('donvi.id'), nullable=False)
donvi = db.relationship('DonVi', viewonly=True)
nguoibaocao_id = db.Column(UUID(as_uuid=True),
db.ForeignKey('user.id'),
nullable=True)
nguoibaocao = db.relationship('User', viewonly=True)
tinhtrang = db.Column(db.SmallInteger, nullable=False)
ngaybaocao = db.Column(db.DateTime())
nambaocao = db.Column(db.Integer, nullable=False)
kybaocao = db.Column(db.SmallInteger, nullable=False)
loaikybaocao = db.Column(db.Integer, nullable=False)
tongso_duocdaotao_yte = db.Column(db.Integer)
tongso_nguoithamgia_nu_yte = db.Column(db.Integer)
tyle_nguoithamgia_nu_yte = db.Column(db.DECIMAL)
tongso_nguoithamgia_dtts_yte = db.Column(db.Integer)
tyle_nguoithamgia_dtts_yte = db.Column(db.DECIMAL)
tongso_giangvien_nu_yte = db.Column(db.DECIMAL)
tongso_duocdaotao_giaoduc = db.Column(db.Integer)
tongso_nguoithamgia_nu_giaoduc = db.Column(db.Integer)
tyle_nguoithamgia_nu_giaoduc = db.Column(db.DECIMAL)
tongso_nguoithamgia_dtts_giaoduc = db.Column(db.Integer)
tyle_nguoithamgia_dtts_giaoduc = db.Column(db.DECIMAL)
tongso_giangvien_nu_giaoduc = db.Column(db.DECIMAL)
# sobuoihoc = db.Column(db.Integer)
# hsmoibuoi = db.Column(db.Integer)
# hsnam = db.Column(db.Integer)
# hsnu = db.Column(db.Integer)
# # trgchinh = db.Column(db.String)
# loaitrg = db.Column(db.Integer)
# ngtraloi = db.Column(db.String)
# vitrichuvu = db.Column(db.String)
# thongtinll = db.Column(db.String)
# nguonnccongtrinh = relationship('NguocNcCongTrinh')
# nguonnccongtrinh_id = db.Column(UUID(as_uuid=True), ForeignKey('nguonnccongtrinh.id'), nullable=True)
# capnctruongtram = relationship('CapNcTruongTram')
# capnctruongtram_id = db.Column(UUID(as_uuid=True), ForeignKey('capnctruongtram.id'), nullable=True)
# class NguonNuocCuaTruongHoc(CommonModel):
# __tablename__ = 'nguonNnuoccuatruonghoc'
# class CapNcTruongTram(CommonModel):
# __tablename__ = 'capnctruongtram'
# matrgtram = db.Column(db.String)
# tentrgtram = db.Column(db.String)
# tenkhu = db.Column(db.String)
# qskhuvs = db.Column(db.Integer)
# khac = db.Column(db.String)
# chauxi = db.Column(db.Integer)
# sannhanut = db.Column(db.Integer)
# daykincua = db.Column(db.Integer)
# bechuanut = db.Column(db.Integer)
# kcbechua = db.Column(db.Integer)
# hoatdongbt = db.Column(db.Integer)
# nuocsach = db.Column(db.Integer)
# ctruatay = db.Column(db.Integer)
# qscongtrinh = db.Column(db.Integer)
# mailop = db.Column(db.Integer)
# dinhdong = db.Column(db.Integer)
# ctsachse = db.Column(db.Integer)
# sansach = db.Column(db.Integer)
# nangmui = db.Column(db.Integer)
# nuocthaichay = db.Column(db.Integer)
# bexicao = db.Column(db.Integer)
# ngaplut = db.Column(db.Integer)
# khuditieu = db.Column(db.Integer)
# tt_dientich = db.Column(db.Integer)
# tt_sochau = db.Column(db.Integer)
# decapquantrong = db.Column(db.String)
class TruongHopCachLyTapTrung(CommonModel):
__tablename__ = 'truonghopcachlytaptrung'
# id = db.Column(db.Integer, primary_key=True)
ma = db.Column(db.String(255))
matokhaiyte = db.Column(db.String(), index=True)
ngaybaocao = db.Column(db.DateTime(), index=True, nullable=False)
noibaocao = db.Column(db.String(255))
nambaocao = db.Column(db.Integer, nullable=False)
donvi_id = db.Column(db.Integer, nullable=False, index=True)
tendonvi = db.Column(db.String())
madonvi = db.Column(db.String())
cuakhau_id = db.Column(db.Integer, index=True)
tencuakhau = db.Column(db.String())
macuakhau = db.Column(db.String())
#dulieu
hoten = db.Column(db.String(), index=True)
gioitinh = db.Column(db.String(20))
namsinh = db.Column(db.Integer())
quoctich = db.Column(db.String())
ma_quoctich = db.Column(db.String())
cmtnd = db.Column(db.String(), index=True)
cuakhau_nhapquacanh = db.Column(db.String())
gio_nhapquacanh = db.Column(db.Integer())
ngay_nhapquacanh = db.Column(db.DateTime())
phuongtien = db.Column(db.String())
sohieu_phuongtien = db.Column(db.String())
noio = db.Column(db.String())
noio_tinhthanh = db.Column(db.String())
noio_matinhthanh = db.Column(db.String())
noio_quanhuyen = db.Column(db.String())
noio_xaphuong = db.Column(db.String())
diachi_lienlac = db.Column(db.String())
email = db.Column(db.String())
sodienthoai = db.Column(db.String(63))
nghenghiep = db.Column(db.String())
benh_nghingo = db.Column(db.String())
tiensu_dichte = db.Column(db.String())
tiensu_trieuchunglamsang = db.Column(db.String())
tiensu_xutri = db.Column(db.String())
noitiepnhan_xutri_id = db.Column(db.Integer())
noitiepnhan_xutri = db.Column(db.String())
ngaygio_phathien = db.Column(db.String())
# ngay_phathien = db.Column(db.DateTime())
# gio_phathien = db.Column(db.Integer())
tinhtrang_phathien = db.Column(db.String())
benhly_kemtheo = db.Column(db.String())
# huongxutri = db.Column(db.String())
nhanxet_danhgia = db.Column(db.String())
ghichu = db.Column(db.String())
tinhtrang = db.Column(db.SmallInteger, nullable=False, default=1)
# class TruongHopCachLyTapTrung(CommonModel):
# __tablename__ = "truonghopcachlytaptrung"
# #id = db.Column(db.Integer, primary_key=True)
# id = db.Column(UUID(as_uuid=True), primary_key=True, default=default_uuid())
# ma = db.Column(db.String(255))
# matokhaiyte = db.Column(db.String(), index=True)
# ngaybaocao = db.Column(db.DateTime(),default=func.now(), index=True)
# noibaocao = db.Column(db.String(255))
# #nambaocao = db.Column(db.Integer, nullable=False)
# donvi_id = db.Column(db.Integer,db.ForeignKey('donvi.id'), nullable=True, index=True)
# tendonvi = db.Column(db.String())
# madonvi = db.Column(db.String())
# donvi = db.relationship('DonVi',viewonly=True)
# cuakhau_id = db.Column(db.Integer, index=True, nullable=True)
# tencuakhau = db.Column(db.String())
# macuakhau = db.Column(db.String())
# #dulieu
# hoten = db.Column(db.String(), index=True)
# gioitinh = db.Column(db.String(20))
# namsinh = db.Column(db.Integer())
# quoctich = db.Column(db.String())
# ma_quoctich = db.Column(db.String())
# cmtnd = db.Column(db.String(), index=True)
# noio = db.Column(db.String())
# noio_tinhthanh = db.Column(db.String())
# noio_matinhthanh = db.Column(db.String())
# trangthai = db.Column(db.String)
# note = db.Column(db.Text())
# extra_data = db.Column(JSONB)
