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)