class ManualPiezo(BaseLog):
__tablename__ = 'manual_piezo'
id = db.Column(db.Integer, primary_key=True)
sampling = db.Column(db.DateTime, index=True)
p1a = db.Column(db.Float, nullable=True)
p1b = db.Column(db.Float, nullable=True)
p1c = db.Column(db.Float, nullable=True)
p2a = db.Column(db.Float, nullable=True)
p2b = db.Column(db.Float, nullable=True)
p2c = db.Column(db.Float, nullable=True)
p3a = db.Column(db.Float, nullable=True)
p3b = db.Column(db.Float, nullable=True)
p3c = db.Column(db.Float, nullable=True)
p4a = db.Column(db.Float, nullable=True)
p4b = db.Column(db.Float, nullable=True)
p4c = db.Column(db.Float, nullable=True)
p5a = db.Column(db.Float, nullable=True)
p5b = db.Column(db.Float, nullable=True)
p5c = db.Column(db.Float, nullable=True)
bendungan_id = db.Column(db.Integer,
db.ForeignKey('bendungan.id'),
nullable=True)
__table_args__ = (db.UniqueConstraint(
'bendungan_id', 'sampling', name='manualpiezo_bendungan_sampling'), )
class ManualTma(BaseLog):
__tablename__ = 'manual_tma'
id = db.Column(db.Integer, primary_key=True)
sampling = db.Column(db.DateTime, index=True)
bendungan_id = db.Column(db.Integer,
db.ForeignKey('bendungan.id'),
nullable=True)
tma = db.Column(db.Float)
vol = db.Column(db.Float)
telemetri = db.Column(db.Float)
__table_args__ = (db.UniqueConstraint(
'bendungan_id', 'sampling', name='manualtma_bendungan_sampling'), )
@property
def foto(self):
foto = Foto.query.filter(Foto.obj_type == 'manual_tma',
Foto.obj_id == self.id).first()
return foto
def readable_date(self):
return f"{self.sampling.strftime('%d %B %Y')}, Jam {self.sampling.hour}"
def local_cdate(self):
return self.c_date + datetime.timedelta(hours=7)
class ManualTmaEmbung(BaseLog):
__tablename__ = 'manual_tma_embung'
id = db.Column(db.Integer, primary_key=True)
sampling = db.Column(db.DateTime, index=True)
embung_id = db.Column(db.Integer,
db.ForeignKey('embung.id'),
nullable=True)
tma = db.Column(db.Float)
vol = db.Column(db.Float)
__table_args__ = (db.UniqueConstraint('embung_id',
'sampling',
name='manualtma_embung_sampling'), )
def local_cdate(self):
return self.c_date + datetime.timedelta(hours=7)
class ManualDailyEmbung(BaseLog):
__tablename__ = 'manual_daily_embung'
id = db.Column(db.Integer, primary_key=True)
sampling = db.Column(db.DateTime, index=True)
inflow_vol = db.Column(db.Float, nullable=True)
inflow_deb = db.Column(db.Float, nullable=True)
intake_vol = db.Column(db.Float, nullable=True)
intake_deb = db.Column(db.Float, nullable=True)
spillway_vol = db.Column(db.Float, nullable=True)
spillway_deb = db.Column(db.Float, nullable=True)
embung_id = db.Column(db.Integer,
db.ForeignKey('embung.id'),
nullable=True)
__table_args__ = (db.UniqueConstraint(
'embung_id', 'sampling', name='manualdaily_embung_sampling'), )
class KegiatanEmbung(BaseLog):
__tablename__ = 'kegiatan_embung'
id = db.Column(db.Integer, primary_key=True)
sampling = db.Column(db.DateTime)
lokasi = db.Column(db.Text)
rencana = db.Column(db.Text)
pencapaian = db.Column(db.Text)
mulai = db.Column(db.String(5))
selesai = db.Column(db.String(5))
kendala = db.Column(db.Text)
nilai = db.Column(db.Float)
petugas = db.Column(db.Text)
bagian_id = db.Column(db.Integer,
db.ForeignKey('bagian_embung.id'),
nullable=True)
embung_id = db.Column(db.Integer,
db.ForeignKey('embung.id'),
nullable=True)
embung = relationship('Embung', back_populates='kegiatan', lazy='joined')
bagian = relationship('BagianEmbung',
back_populates='kegiatan',
lazy='joined')
__table_args__ = (db.UniqueConstraint(
'embung_id',
'sampling',
'bagian_id',
name='kegiatan_embung_sampling_bagian_id'), )
@property
def fotos(self):
fotos = Foto.query.filter(Foto.obj_type == 'kegiatan_embung',
Foto.obj_id == self.id).all()
result = {}
for f in fotos:
length = len(f.keterangan)
tag = f.keterangan[:length - 1]
result[tag] = f
return result
def get_hms(self):
return self.c_date + datetime.timedelta(hours=7)
class Periodik(db.Model):
__tablename__ = 'periodik'
id = db.Column(db.Integer, primary_key=True)
sampling = db.Column(db.DateTime, index=True)
device_sn = db.Column(db.String(8), db.ForeignKey('device.sn'))
lokasi_id = db.Column(db.Integer,
db.ForeignKey('lokasi.id'),
nullable=True)
mdpl = db.Column(db.Float)
apre = db.Column(db.Float)
sq = db.Column(db.Integer)
temp = db.Column(db.Float)
humi = db.Column(db.Float)
batt = db.Column(db.Float)
rain = db.Column(db.Float) # hujan dalam mm
wlev = db.Column(db.Float) # TMA dalam centi
up_s = db.Column(db.DateTime) # Up Since
ts_a = db.Column(db.DateTime) # Time Set at
received = db.Column(db.DateTime, default=datetime.datetime.utcnow)
device = relationship("Device", back_populates="periodik")
lokasi = relationship("Lokasi", back_populates="periodik")
__table_args__ = (db.UniqueConstraint('device_sn',
'sampling',
name='_device_sampling'), )
def __repr__(self):
return '<Periodik {} Device {}>'.format(self.sampling, self.device_sn)
@classmethod
def temukan_hujan(self, sejak=None):
'''return periodik yang rain > 0'''
dari = 30 # hari lalu
if not sejak:
sejak = datetime.datetime.now() - datetime.timedelta(days=dari)
sejak = sejak.replace(minute=0, hour=7)
data = [
d for d in self.query.filter(
self.sampling >= sejak).order_by(self.sampling)
]
lokasi_hari_hujan = [d.lokasi_id for d in data if (d.rain or 0) > 0]
print(lokasi_hujan)
class ManualDaily(BaseLog):
__tablename__ = 'manual_daily'
id = db.Column(db.Integer, primary_key=True)
sampling = db.Column(db.DateTime, index=True)
ch = db.Column(db.Float, nullable=True)
inflow_vol = db.Column(db.Float, nullable=True)
inflow_deb = db.Column(db.Float, nullable=True)
intake_vol = db.Column(db.Float, nullable=True)
intake_deb = db.Column(db.Float, nullable=True)
intake_ket = db.Column(db.Text, nullable=True)
outflow_vol = db.Column(db.Float, nullable=True)
outflow_deb = db.Column(db.Float, nullable=True)
spillway_vol = db.Column(db.Float, nullable=True)
spillway_deb = db.Column(db.Float, nullable=True)
bendungan_id = db.Column(db.Integer,
db.ForeignKey('bendungan.id'),
nullable=True)
__table_args__ = (db.UniqueConstraint(
'bendungan_id', 'sampling', name='manualdaily_bendungan_sampling'), )
class KinerjaNilai(BaseLog):
__tablename__ = 'kinerja_nilai'
id = db.Column(db.Integer, primary_key=True)
sampling = db.Column(db.DateTime)
nilai = db.Column(db.Float) # nilai input
kinerja_komponen_id = db.Column(db.Integer,
db.ForeignKey('kinerja_komponen.id'))
petugas_id = db.Column(db.Integer, db.ForeignKey('petugas.id'))
kinerja_komponen = relationship('KinerjaKomponen',
back_populates='kinerja_nilai')
petugas = relationship('Petugas', back_populates='kinerja_nilai')
__table_args__ = (db.UniqueConstraint(
'sampling',
'kinerja_komponen_id',
'petugas_id',
name='sampling_kinerja_komponen_petugas'), )
@property
def points(self):
points = (self.nilai / self.kinerja_komponen.input_max
) * self.kinerja_komponen.nilai_max
return round(points, 2)
def set_nilai(self, nilai):
self.nilai = min(max(0, nilai), self.kinerja_komponen.input_max)
def get_kinerja_str(self):
if self.points > 0.9 * self.kinerja_komponen.nilai_max:
return "Sangat Baik"
elif self.points > 0.8 * self.kinerja_komponen.nilai_max:
return "Baik"
elif self.points > 0.7 * self.kinerja_komponen.nilai_max:
return "Cukup"
elif self.points > 0.54 * self.kinerja_komponen.nilai_max:
return "Kurang"
else:
return "Buruk"
class Rencana(BaseLog):
__tablename__ = 'rencana'
id = db.Column(db.Integer, primary_key=True)
sampling = db.Column(db.DateTime, index=True)
po_tma = db.Column(db.Float)
po_vol = db.Column(db.Float)
po_inflow_vol = db.Column(db.Float)
po_inflow_deb = db.Column(db.Float)
po_outflow_vol = db.Column(db.Float, nullable=True)
po_outflow_deb = db.Column(db.Float, nullable=True)
po_bona = db.Column(db.Float, nullable=True)
po_bonb = db.Column(db.Float, nullable=True)
vol_bona = db.Column(db.Float, nullable=True)
vol_bonb = db.Column(db.Float, nullable=True)
bendungan_id = db.Column(db.Integer,
db.ForeignKey('bendungan.id'),
nullable=True)
__table_args__ = (db.UniqueConstraint('bendungan_id',
'sampling',
name='rencana_bendungan_sampling'), )
class ManualVnotch(BaseLog):
__tablename__ = 'manual_vnotch'
id = db.Column(db.Integer, primary_key=True)
sampling = db.Column(db.DateTime, index=True)
vn_tma = db.Column(db.Float, nullable=True)
vn_deb = db.Column(db.Float, nullable=True)
vn1_tma = db.Column(db.Float, nullable=True)
vn1_deb = db.Column(db.Float, nullable=True)
vn2_tma = db.Column(db.Float, nullable=True)
vn2_deb = db.Column(db.Float, nullable=True)
vn3_tma = db.Column(db.Float, nullable=True)
vn3_deb = db.Column(db.Float, nullable=True)
vn4_tma = db.Column(db.Float, nullable=True)
vn4_deb = db.Column(db.Float, nullable=True)
vn5_tma = db.Column(db.Float, nullable=True)
vn5_deb = db.Column(db.Float, nullable=True)
bendungan_id = db.Column(db.Integer,
db.ForeignKey('bendungan.id'),
nullable=True)
__table_args__ = (db.UniqueConstraint(
'bendungan_id', 'sampling', name='manualvnotch_bendungan_sampling'), )
class PiketBanjir(BaseLog):
__tablename__ = 'piket_banjir'
id = db.Column(db.Integer, primary_key=True)
sampling = db.Column(db.DateTime, index=True)
obj_type = db.Column(db.String, default="bendungan")
obj_id = db.Column(db.Integer)
cuaca = db.Column(db.Text)
ch = db.Column(db.Float)
durasi = db.Column(db.Text)
tma = db.Column(db.Float)
volume = db.Column(db.Float)
spillway_tma = db.Column(db.Float)
spillway_deb = db.Column(db.Float)
kondisi = db.Column(db.Text)
petugas_id = db.Column(db.Integer,
db.ForeignKey('petugas.id'),
nullable=True)
petugas = db.Column(db.Text)
__table_args__ = (db.UniqueConstraint('obj_type',
'obj_id',
'sampling',
name='piket_banjir_obj_sampling'), )
@property
def object(self):
if self.obj_type == "bendungan":
return Bendungan.query.get(self.obj_id)
else:
return None
@property
def volume_percent(self):
return round((self.volume / self.object.volume) * 100, 2)