invoice.py

from sqlalchemy import (
    Column,
    Integer,
    String,
    Date,
    Float,
    DateTime,
    UniqueConstraint,
    ForeignKey,
    )
from sqlalchemy.ext.declarative import declared_attr


class InvoiceMixin:
    @declared_attr
    def __tablename__(self):
        return 'bphtb_sspd'

    @declared_attr
    def id(self):
        return Column(Integer, primary_key=True)

    @declared_attr
    def tahun(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def kode(self):
        return Column(String(1), nullable=False)

    @declared_attr
    def no_sspd(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def ppat_id(self):
        return Column(Integer, ForeignKey('bphtb.bphtb_ppat.id'))

    @declared_attr
    def wp_nama(self):
        return Column(String(50), nullable=False)

    @declared_attr
    def wp_npwp(self):
        return Column(String(50), nullable=False)

    @declared_attr
    def wp_alamat(self):
        return Column(String(100), nullable=False)

    @declared_attr
    def wp_blok_kav(self):
        return Column(String(100), nullable=False)

    @declared_attr
    def wp_kelurahan(self):
        return Column(String(30), nullable=False)

    @declared_attr
    def wp_rt(self):
        return Column(String(3), nullable=False)

    @declared_attr
    def wp_rw(self):
        return Column(String(3), nullable=False)

    @declared_attr
    def wp_kecamatan(self):
        return Column(String(30), nullable=False)

    @declared_attr
    def wp_kota(self):
        return Column(String(30), nullable=False)

    @declared_attr
    def wp_provinsi(self):
        return Column(String(30), nullable=False)

    @declared_attr
    def wp_identitas(self):
        return Column(String(50), nullable=False)

    @declared_attr
    def wp_identitaskd(self):
        return Column(String(50))

    @declared_attr
    def tgl_transaksi(self):
        return Column(Date, nullable=False)

    @declared_attr
    def kd_propinsi(self):
        return Column(String(2), nullable=False)

    @declared_attr
    def kd_dati2(self):
        return Column(String(2), nullable=False)

    @declared_attr
    def kd_kecamatan(self):
        return Column(String(3), nullable=False)

    @declared_attr
    def kd_kelurahan(self):
        return Column(String(3), nullable=False)

    @declared_attr
    def kd_blok(self):
        return Column(String(3), nullable=False)

    @declared_attr
    def no_urut(self):
        return Column(String(4), nullable=False)

    @declared_attr
    def kd_jns_op(self):
        return Column(String(1), nullable=False)

    @declared_attr
    def thn_pajak_sppt(self):
        return Column(String(4), nullable=False)

    @declared_attr
    def op_alamat(self):
        return Column(String(100), nullable=False)

    @declared_attr
    def op_blok_kav(self):
        return Column(String(100), nullable=False)

    @declared_attr
    def op_rt(self):
        return Column(String(3), nullable=False)

    @declared_attr
    def op_rw(self):
        return Column(String(3), nullable=False)

    @declared_attr
    def bumi_luas(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def bumi_njop(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def bng_luas(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def bng_njop(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def no_sertifikat(self):
        return Column(String(30))

    @declared_attr
    def njop(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def perolehan_id(self):
        return Column(
                Integer, ForeignKey('bphtb.bphtb_perolehan.id'),
                nullable=False)

    @declared_attr
    def npop(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def npoptkp(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def tarif(self):
        return Column(Float, nullable=False)

    @declared_attr
    def terhutang(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def bagian(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def pembagi(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def tarif_pengurang(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def pengurang(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def bphtb_sudah_dibayarkan(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def denda(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def restitusi(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def bphtb_harus_dibayarkan(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def status_pembayaran(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def dasar_id(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def create_uid(self):
        return Column(String(20))

    @declared_attr
    def update_uid(self):
        return Column(String(20))

    @declared_attr
    def created(self):
        return Column(DateTime, nullable=False)

    @declared_attr
    def updated(self):
        return Column(DateTime, nullable=False)

    @declared_attr
    def header_id(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def tgl_print(self):
        return Column(DateTime)

    @declared_attr
    def tgl_approval(self):
        return Column(DateTime)

    @declared_attr
    def file1(self):
        return Column(String(150))

    @declared_attr
    def file2(self):
        return Column(String(150))

    @declared_attr
    def file3(self):
        return Column(String(150))

    @declared_attr
    def file4(self):
        return Column(String(150))

    @declared_attr
    def file5(self):
        return Column(String(150))

    @declared_attr
    def wp_kdpos(self):
        return Column(String(5))

    @declared_attr
    def file6(self):
        return Column(String(150))

    @declared_attr
    def file7(self):
        return Column(String(150))

    @declared_attr
    def file8(self):
        return Column(String(150))

    @declared_attr
    def file9(self):
        return Column(String(150))

    @declared_attr
    def file10(self):
        return Column(String(150))

    @declared_attr
    def keterangan(self):
        return Column(String(100))

    @declared_attr
    def status_daftar(self):
        return Column(Integer)

    @declared_attr
    def persen_pengurang_sendiri(self):
        return Column(Integer)

    @declared_attr
    def pp_nomor_pengurang_sendiri(self):
        return Column(String(50))

    @declared_attr
    def no_ajb(self):
        return Column(String(50))

    @declared_attr
    def tgl_ajb(self):
        return Column(DateTime)

    @declared_attr
    def wp_nama_asal(self):
        return Column(String(50))

    @declared_attr
    def jml_pph(self):
        return Column(Float)

    @declared_attr
    def tgl_pph(self):
        return Column(DateTime)

    @declared_attr
    def posted(self):
        return Column(Integer)

    @declared_attr
    def pos_tp_id(self):
        return Column(Integer)

    @declared_attr
    def status_validasi(self):
        return Column(Integer)

    @declared_attr
    def status_bpn(self):
        return Column(Integer)

    @declared_attr
    def tgl_jatuh_tempo(self):
        return Column(DateTime)

    @declared_attr
    def verifikasi_uid(self):
        return Column(String(20))

    @declared_attr
    def verifikasi_date(self):
        return Column(DateTime)

    @declared_attr
    def pbb_nop(self):
        return Column(String(24))

    @declared_attr
    def verifikasi_bphtb_uid(self):
        return Column(String(20))

    @declared_attr
    def verifikasi_bphtb_date(self):
        return Column(DateTime)

    @declared_attr
    def hasil_penelitian(self):
        return Column(String(20))

    @declared_attr
    def no_sk(self):
        return Column(String(20))

    @declared_attr
    def pengurangan_sk(self):
        return Column(String(20))

    @declared_attr
    def pengurangan_jatuh_tempo_tgl(self):
        return Column(DateTime)

    @declared_attr
    def pengurangan_sk_tgl(self):
        return Column(DateTime)

    @declared_attr
    def ketetapan_no(self):
        return Column(String(20))

    @declared_attr
    def ketetapan_tgl(self):
        return Column(DateTime)

    @declared_attr
    def ketetapan_atas_sspd_no(self):
        return Column(String(20))

    @declared_attr
    def ketetapan_jatuh_tempo_tgl(self):
        return Column(DateTime)

    @declared_attr
    def pembayaran_ke(self):
        return Column(Integer, nullable=False)

    @declared_attr
    def mutasi_penuh(self):
        return Column(Integer)

    @declared_attr
    def npopkp(self):
        return Column(Integer)

    @declared_attr
    def harga_transaksi(self):
        return Column(Integer)

    @declared_attr
    def npoptkp_sudah_didapat(self):
        return Column(Integer)

    # @declared_attr
    # def wp_handphone(self):
    #    return Column(String(15))

    # @declared_attr
    # def sts_id(self):
    #    return Column(Integer, nullable=False)

    @declared_attr
    def bng_luas_beban(self):
        return Column(Integer)

    @declared_attr
    def bng_njop_beban(self):
        return Column(Integer)

    # @declared_attr
    # def bphtb_sudah_dibayarkan_tgl(self):
    #    return Column(Date)

    @declared_attr
    def bumi_luas_beban(self):
        return Column(Integer)

    @declared_attr
    def bumi_njop_beban(self):
        return Column(Integer)

    @declared_attr
    def wp_alamat_asal(self):
        return Column(String(25))

    @declared_attr
    def wp_blok_kav_asal(self):
        return Column(String(25))

    @declared_attr
    def wp_identitas_asal(self):
        return Column(String(25))

    @declared_attr
    def wp_identitaskd_asal(self):
        return Column(String(25))

    @declared_attr
    def wp_kdpos_asal(self):
        return Column(String(30))

    @declared_attr
    def wp_kecamatan_asal(self):
        return Column(String(30))

    @declared_attr
    def wp_kelurahan_asal(self):
        return Column(String(30))

    @declared_attr
    def wp_kota_asal(self):
        return Column(String(30))

    @declared_attr
    def wp_npwp_asal(self):
        return Column(String(50))

    @declared_attr
    def wp_provinsi_asal(self):
        return Column(String(30))

    @declared_attr
    def wp_rt_asal(self):
        return Column(String(3))

    @declared_attr
    def wp_rw_asal(self):
        return Column(String(3))

    # @declared_attr
    # def wp_status_hak_id(self):
    #    return Column(Integer)

    # @declared_attr
    # def peruntukan(self):
    #    return Column(String(50))

    # @declared_attr
    # def parent_id(self):
    #    return Column(Integer)

    @declared_attr
    def __table_args__(self):
        return (
            UniqueConstraint('tahun', 'kode', 'no_sspd'),
            dict(schema='bphtb'))