from base_models import (
Base,
DBSession,
)
from sismiop.query import Query
from common.pbb.models import Models
from common.pbb.structure import INVOICE_ID
from conf import (
db_url,
db_schema,
)
engine = create_engine(db_url)
Base.metadata.bind = engine
DBSession.configure(bind=engine)
models = Models(Base, db_schema)
class InquiryByQuery(Query):
def __init__(self, invoice_id_raw):
Query.__init__(self, models, DBSession)
self.invoice_id = FixLength(INVOICE_ID)
self.invoice_id.set_raw(invoice_id_raw)
q = self.query_invoice(
self.invoice_id['Propinsi'], self.invoice_id['Kabupaten'],
self.invoice_id['Kecamatan'], self.invoice_id['Kelurahan'],
self.invoice_id['Blok'], self.invoice_id['Urut'],
self.invoice_id['Jenis'], self.invoice_id['Tahun Pajak'])
self.invoice = q.first()
self.ket = None
if not self.invoice:
from base_models import (
Base,
DBSession,
)
from sismiop.query import Reversal
from common.pbb.models import Models
from common.pbb.structure import INVOICE_ID
from conf import (
db_url,
db_schema,
)
engine = create_engine(db_url)
Base.metadata.bind = engine
DBSession.configure(bind=engine)
models = Models(Base, db_schema, None)
class ReversalByQuery(Reversal):
def __init__(self, invoice_id_raw):
self.invoice_id = FixLength(INVOICE_ID)
self.invoice_id.set_raw(invoice_id_raw)
Reversal.__init__(self, models, DBSession, self.invoice_id['Propinsi'],
self.invoice_id['Kabupaten'],
self.invoice_id['Kecamatan'],
self.invoice_id['Kelurahan'],
self.invoice_id['Blok'], self.invoice_id['Urut'],
self.invoice_id['Jenis'],
self.invoice_id['Tahun Pajak'])
def set_unpaid(self):
db_pool_size,
db_max_overflow,
persen_denda,
nip_rekam_byr_sppt,
host,
)
engine = create_engine(db_url, pool_size=db_pool_size,
max_overflow=db_max_overflow)
Base = declarative_base()
Base.metadata.bind = engine
session_factory = sessionmaker()
DBSession = scoped_session(session_factory)
DBSession.configure(bind=engine)
models = Models(Base, db_schema, iso_db_schema)
query = Payment(models, DBSession)
BANK_FIELDS = ('kd_kanwil', 'kd_kantor', 'kd_tp')
PREFIX_NTP_FIELDS = BANK_FIELDS[:-1]
class BaseResponse(object):
def __init__(self, parent):
self.parent = parent
self.invoice_id = FixLength(INVOICE_ID)
self.invoice_id_raw = parent.from_iso.get_invoice_id()
self.invoice_id.set_raw(self.invoice_id_raw)
def is_transaction_owner(self, pay):
iso_db_schema,
payment_db_schema,
db_pool_size,
db_max_overflow,
persen_denda,
nip_rekam_byr_sppt,
host,
)
engine = create_engine(db_url,
pool_size=db_pool_size,
max_overflow=db_max_overflow)
Base.metadata.bind = engine
DBSession.configure(bind=engine)
models = Models(Base,
db_schema,
iso_db_schema,
payment_db_schema=payment_db_schema)
BANK_FIELDS = ('kd_kanwil', 'kd_kantor', 'kd_tp')
PREFIX_NTP_FIELDS = BANK_FIELDS[:-1]
class BaseResponse(object):
def __init__(self, parent):
self.parent = parent
self.invoice_id = FixLength(INVOICE_ID)
self.invoice_id.set_raw(parent.from_iso.get_invoice_id())
self.invoice_id_raw = self.invoice_id.get_raw()
def is_transaction_owner(self, pay):
conf = host[self.parent.conf['name']]
from sqlalchemy import create_engine
from tools import FixLength
from base_models import (
Base,
DBSession,
)
from sismiop.query import Query
from common.pbb.models import Models
from common.pbb.structure import INVOICE_ID
from conf import db_url
engine = create_engine(db_url)
Base.metadata.bind = engine
DBSession.configure(bind=engine)
models = Models(Base, None, None)
class InquiryByQuery(Query):
def __init__(self, invoice_id_raw):
Query.__init__(self, models, DBSession)
self.invoice_id = FixLength(INVOICE_ID)
self.invoice_id.set_raw(invoice_id_raw)
q = self.query_invoice(
self.invoice_id['Propinsi'], self.invoice_id['Kabupaten'],
self.invoice_id['Kecamatan'], self.invoice_id['Kelurahan'],
self.invoice_id['Blok'], self.invoice_id['Urut'],
self.invoice_id['Jenis'], self.invoice_id['Tahun Pajak'])
self.invoice = q.first()
self.ket = None
if not self.invoice:
return