dat_objek_pajak.py
2.34 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
from sqlalchemy import (Column, String, DateTime,
Integer, Float,)
from ..tools import FixNop
from ..models import PbbmBase, PbbmDBSession, PBBM_ARGS, CommonModel
class DatObjekPajak(PbbmBase, CommonModel):
__tablename__ = 'dat_objek_pajak'
kd_propinsi = Column(String(2), primary_key=True)
kd_dati2 = Column(String(2), primary_key=True)
kd_kecamatan = Column(String(3), primary_key=True)
kd_kelurahan = Column(String(3), primary_key=True)
kd_blok = Column(String(3), primary_key=True)
no_urut = Column(String(4), primary_key=True)
kd_jns_op = Column(String(1), primary_key=True)
subjek_pajak_id = Column(String(30))
no_formulir_spop = Column(String(11))
no_persil = Column(String(5))
jalan_op = Column(String(30))
blok_kav_no_op = Column(String(15))
rw_op = Column(String(2))
rt_op = Column(String(3))
kd_status_cabang = Column(Integer)
kd_status_wp = Column(String(1))
total_luas_bumi = Column(Float)
total_luas_bng = Column(Float)
njop_bumi = Column(Float)
njop_bng = Column(Float)
status_peta_op = Column(Integer)
jns_transaksi_op = Column(String(1))
tgl_pendataan_op = Column(DateTime)
nip_pendata = Column(String(18))
tgl_pemeriksaan_op = Column(DateTime)
nip_pemeriksa_op = Column(String(18))
tgl_perekaman_op = Column(DateTime)
nip_perekam_op = Column(String(18))
__table_args__ = (
# ForeignKeyConstraint([kd_propinsi, kd_dati2, kd_kecamatan, kd_kelurahan, kd_blok],
# [DatPetaBlok.kd_propinsi, DatPetaBlok.kd_dati2, DatPetaBlok.kd_kecamatan,
# DatPetaBlok.kd_kelurahan, DatPetaBlok.kd_blok]),
# ForeignKeyConstraint([subjek_pajak_id],
# [DatSubjekPajak.subjek_pajak_id]),
PBBM_ARGS,)
@classmethod
def query(cls):
return PbbmDBSession.query(cls)
@classmethod
def query_id(cls, id):
fxSppt = FixNop(id)
return cls.query().filter(
cls.kd_propinsi == fxSppt.kd_propinsi,
cls.kd_dati2 == fxSppt.kd_dati2,
cls.kd_kecamatan == fxSppt.kd_kecamatan,
cls.kd_kelurahan == fxSppt.kd_kelurahan,
cls.kd_blok == fxSppt.kd_blok,
cls.no_urut == fxSppt.no_urut,
cls.kd_jns_op == fxSppt.kd_jns_op)