rekening.py
2.17 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
64
65
66
67
68
69
70
71
72
73
74
from sqlalchemy import (
Column,
Integer,
DateTime,
String,
SmallInteger
)
from sqlalchemy.ext.hybrid import hybrid_property
from sqlalchemy.schema import FetchedValue
from . import PAD_TABLE_ARGS, DefaultModel, Base
class PjdlRekening(Base, DefaultModel):
__tablename__ = 'tblrekening'
__table_args__ = PAD_TABLE_ARGS
id = Column(Integer, primary_key=True)
rekeningkd = Column(String(15), nullable=False, unique=True)
rekeningnm = Column(String(150))
levelid = Column(Integer)
issummary = Column(SmallInteger, nullable=False)
defsign = Column(SmallInteger, nullable=True)
isppkd = Column(SmallInteger, nullable=False, server_default=FetchedValue())
tmt = Column(DateTime)
enabled = Column(SmallInteger)
create_date = Column(DateTime)
create_uid = Column(Integer)
write_date = Column(DateTime)
write_uid = Column(Integer)
insidentil = Column(SmallInteger, server_default=FetchedValue())
# reksts_id = Column(BigInteger)
# rek_akrual_id = Column(BigInteger)
@hybrid_property
def kode(self):
return self.rekeningkd
@kode.setter
def kode(self, kode):
self.rekeningkd = kode
@hybrid_property
def nama(self):
return self.rekeningnm
@nama.setter
def nama(self, kode):
self.rekeningnm = kode
@classmethod
def query_kode(cls, kode):
return cls.query().filter(cls.rekeningkd == kode)
@classmethod
def query_nama(cls, nama):
return cls.query().filter(cls.rekeningnm == nama)
@classmethod
def query_register(cls, order_field="rekeningnm"):
return cls.query_from(columns =[cls.rekeningkd.label('Kode Rekening'),
cls.rekeningnm.label('Nama Rekening'),
cls.issummary.label('Summary'),
cls.tmt, cls.enabled.label('aktif')]). \
order_by(getattr(cls, order_field))
@classmethod
def get_list(cls):
r = []
q = cls.query().order_by(cls.rekeningnm)
for row in q:
g = (str(row.id), f"{row.kode}/ {row.nama}")
r.append(g)
return r