pejabat.py
1.54 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
from sqlalchemy import (
Column,
Integer,
DateTime,
String,
SmallInteger
)
from sqlalchemy.ext.hybrid import hybrid_property
from . import PAD_TABLE_ARGS, DefaultModel, Base
class PjdlPejabat(Base, DefaultModel):
__tablename__ = 'tblpejabat'
__table_args__ = PAD_TABLE_ARGS
id = Column(Integer, primary_key=True)
nip = Column(String(30))
pejabatnm = Column(String(30))
jabatan = Column(String(50))
golongan = Column(String(5))
pangkat = Column(String(30))
tmt = Column(DateTime)
enabled = Column(SmallInteger)
@hybrid_property
def kode(self):
return self.nip
@kode.setter
def kode(self, kode):
self.nip = kode
@hybrid_property
def nama(self):
return self.pejabatnm
@nama.setter
def nama(self, nama):
self.pejabatnm = nama
@classmethod
def query_kode(cls, kode):
return cls.query().filter(cls.kode == kode)
@classmethod
def query_nama(cls, nama):
return cls.query().filter(cls.nama == nama)
@classmethod
def query_register(cls, order_field="id"):
return cls.query_from(columns =[cls.nip, cls.nama, cls.jabatan, cls.golongan,
cls.pangkat, cls.tmt, cls.enabled.label('Status')]). \
order_by(getattr(cls, order_field))
@classmethod
def get_list(cls):
r = []
q = cls.query().order_by(cls.pejabatnm)
for row in q:
g = (str(row.id), f"{row.kode}/ {row.nama}")
r.append(g)
return r