dph.py

import logging
import os
from datetime import datetime

import colander
from datatables import ColumnDT
from deform import (
    widget, ValidationFailure,
)
from tangsel.base.models import UserArea, ResDesa
from tangsel.base.views import DataTables
from tangsel.base.widgets import widget_os
from tangsel.models import DBSession
from pyramid.view import (view_config)

from tangsel.tools import ymd
from tangsel.tools.buttons import btn_search
from tangsel.tools.pbb import FixDati2, nop_formatted, query_nop, FixKelurahan
from tangsel.tools.report import open_rml_row, open_rml_pdf, pdf_response
from . import BaseView, btn_tambah, btn_tutup
from ..models import Kecamatan, Kelurahan
from ..models import PembayaranDph
from ..tools import get_settings
from ..tools import thousand
from sqlalchemy import not_, func, or_, desc, and_
from tangsel.tools.buttons import btn_cancel, btn_print_ttr
from deform.form import Button
from pyramid.i18n import TranslationStringFactory

_ = TranslationStringFactory('button')
btn_bukti_terima = Button('cetak_bukti_bayar', title=_(
    'Cetak Bukti Terima'), css_class="btn-info",
    type="button")

settings = get_settings
log = logging.getLogger(__name__)


class ListSchema(colander.Schema):
    id = colander.SchemaNode(
        colander.Integer(),
        field=PembayaranDph.id,
        title="Aksi"
    )
    nop = colander.SchemaNode(
        colander.String(),
        width="125px",
        className="text-center",
        title="NOP",
    )
    tahun = colander.SchemaNode(
        colander.String(),
        width="50px")
    ke = colander.SchemaNode(
        colander.String(),
        className="text-center",
        width="50px")
    nama = colander.SchemaNode(
        colander.String(),
    )
    jatuh_Tempo = colander.SchemaNode(
        colander.String(),
        width="100px",
        className="text-center",
    )
    pokok = colander.SchemaNode(
        colander.Integer(),
        width="100px",
        className="text-right",
        field=PembayaranDph.pbb_yg_harus_dibayar_sppt
    )

    denda = colander.SchemaNode(
        colander.Integer(),
        width="100px",
        className="text-right",
    )
    bayar = colander.SchemaNode(
        colander.Integer(),
        width="100px",
        className="text-right",
    )
    tgl_pembayaran = colander.SchemaNode(
        colander.String(),
        width="100px",
        className="text-center",
        title="Tanggal",
    )
    status = colander.SchemaNode(
        colander.Integer(),
        widget=widget.CheckboxWidget(true_val=1, false_val=0),
        # width="50px",
        className="text-center")


class Tagihan(colander.Schema):
    tgl_jatuh_tempo_sppt = colander.SchemaNode(
        colander.String(),
        missing=colander.drop,
        widget=widget.TextInputWidget(readonly=True),
        title="Jatuhtempo",
    )
    
    pokok = colander.SchemaNode(
        colander.String(),
        widget=widget_os.MoneyInputWidget(readonly=True),
        missing=colander.drop,
        oid="pokok",
        default=0
    )
    denda = colander.SchemaNode(
        colander.String(),
        widget=widget_os.MoneyInputWidget(readonly=True),
        missing=colander.drop,
        oid="denda",
        default=0
    )
    jumlah = colander.SchemaNode(
        colander.String(),
        widget=widget_os.MoneyInputWidget(readonly=True),
        missing=colander.drop,
        oid="jumlah",
        default=0
    )


class LokasiOp(colander.Schema):
    kecamatan = colander.SchemaNode(
        colander.String(),
        widget=widget.TextInputWidget(readonly=True),
        missing=colander.drop,
        oid="kecamatan",
    )
    kelurahan = colander.SchemaNode(
        colander.String(),
        widget=widget.TextInputWidget(readonly=True),
        missing=colander.drop,
        oid="kelurahan",
    )


class WajibPajak(colander.Schema):
    nm_wp_sppt = colander.SchemaNode(
        colander.String(),
        widget=widget.TextInputWidget(readonly=True),
        missing=colander.drop,
        oid="nm_wp_sppt",
        title="Nama",
    )

    jln_wp_sppt = colander.SchemaNode(
        colander.String(),
        widget=widget.TextInputWidget(readonly=True),
        missing=colander.drop,
        oid="jln_wp_sppt",
        title="Alamat",
    )
    blok_kav_no_wp_sppt = colander.SchemaNode(
        colander.String(),
        widget=widget.TextInputWidget(readonly=True),
        missing=colander.drop,
        oid="blok_kav_no_wp_sppt",
        title="Blok/Kav/No",
    )
    rw_wp_sppt = colander.SchemaNode(
        colander.String(),
        widget=widget.TextInputWidget(readonly=True),
        missing=colander.drop,
        oid="rw_wp_sppt",
        title="RW",
    )
    rt_wp_sppt = colander.SchemaNode(
        colander.String(),
        widget=widget.TextInputWidget(readonly=True),
        missing=colander.drop,
        oid="rt_wp_sppt",
        title="RT",
    )
    kelurahan_wp_sppt = colander.SchemaNode(
        colander.String(),
        widget=widget.TextInputWidget(readonly=True),
        missing=colander.drop,
        oid="kelurahan_wp_sppt",
        title="Kelurahan",
    )
    kota_wp_sppt = colander.SchemaNode(
        colander.String(),
        widget=widget.TextInputWidget(readonly=True),
        missing=colander.drop,
        oid="kota_wp_sppt",
        title="Kota",
    )
    kd_pos_wp_sppt = colander.SchemaNode(
        colander.String(),
        widget=widget.TextInputWidget(readonly=True),
        missing=colander.drop,
        oid="kd_pos_wp_sppt",
        title="Kode Pos",
    )
    npwp_sppt = colander.SchemaNode(
        colander.String(),
        widget=widget.TextInputWidget(readonly=True),
        missing=colander.drop,
        oid="npwp_sppt",
        title="NPWP",
    )


class AddSchema(colander.Schema):
    # nop = colander.SchemaNode(
    #         colander.String(),
    #         title = "NOP",
    #         oid = "nop",
    #       )

    # edit nop --------------------------------------
    # nop_pemda = colander.SchemaNode(
    #     colander.String(),
    #     widget=widget.TextInputWidget(readonly=True),
    #     missing=colander.drop,
    #     title="Pemda",
    #     oid="nop_pemda",
    # )
    # nop_desa = colander.SchemaNode(
    #     colander.String(),
    #     # validator=colander.Length(max=6),
    #     title="Kec/Desa",
    #     oid="nop_desa",
    # )
    # nop_blok = colander.SchemaNode(
    #     colander.String(),
    #     # validator=colander.Length(max=3),
    #     title="Blok",
    #     oid="nop_blok",
    # )
    # nop_urut = colander.SchemaNode(
    #     colander.String(),
    #     # validator=colander.Length(max=4),
    #     title="No Urut",
    #     oid="nop_urut",
    # )
    # nop_jenis = colander.SchemaNode(
    #     colander.String(),
    #     # validator=colander.Length(max=1),
    #     title="No Jenis",
    #     oid="nop_jenis",
    #     default="0"
    # )
    #

    nop = colander.SchemaNode(
        colander.String(),
        widget=widget.TextInputWidget(mask='99.99.999.999.999.9999.9'),
        # validator=colander.Length(max=3),
        title="NOP",
        oid="nop",
        field=query_nop(PembayaranDph)
    )
    tahun = colander.SchemaNode(
        colander.String(),
        widget=widget_os.TextInputWidget(button=btn_search),
        title="Tahun",
        oid="tahun",
    )
    tagihan = Tagihan()
    lokasi_objek_pajak = LokasiOp()
    wajib_pajak = WajibPajak()
    pembayaran_ke = colander.SchemaNode(
        colander.String(),
        widget=widget_os.MoneyInputWidget(readonly=True),
        missing=colander.drop,
        oid="ke",
        title="Pembayaran Ke",
        default=0,
    )


class EditSchema(AddSchema):
    id = colander.SchemaNode(colander.String(),
                             missing=colander.drop,
                             widget=widget.HiddenWidget(readonly=True))


class View(BaseView):
    def __init__(self, request):
        super().__init__(request)
        self.list_schema = ListSchema
        self.add_schema = AddSchema
        self.edit_schema = EditSchema
        self.list_url = 'pbbm/dph'
        self.list_route = 'pbbm-dph'
        self.table = PembayaranDph
        # self.list_buttons += self.list_report
        self.list_buttons = (btn_tambah,) + self.list_report
        self.rinci = ['tagihan', 'lokasi_objek_pajak', 'wajib_pajak']
        self.form_scripts = ""

    def list_join(self, query, **kwargs):
        return query.filter(self.table.user_id == self.req.user.id). \
            filter(PembayaranDph.tgl_pembayaran
                   .between(self.dt_awal, self.dt_akhir),
                   PembayaranDph.create_uid == self.req.user.id)

    @view_config(route_name='pbbm-dph', renderer='templates/list_dph.pt',
                 permission='pbb-monitoring-dph')
    def view_list(self):
        return super().view_list(allow_edit=False, allow_delete=False)  # edit delete hide

    @view_config(route_name='pbbm-dph-act', renderer='json',
                 permission='pbb-monitoring-dph')
    def view_act(self):
        # return super().view_act()
        request = self.req
        ses = request.session
        params = request.params
        url_dict = request.matchdict
        if url_dict['act'] == 'grid':
            pk_id = 'id' in params and params['id'] and int(params['id']) or 0
            if url_dict['act'] == 'grid':
                columns = [
                    ColumnDT(func.concat(PembayaranDph.kd_propinsi, func.concat(".", 
                            func.concat(PembayaranDph.kd_dati2, func.concat(".", 
                            func.concat(PembayaranDph.kd_kecamatan, func.concat(".", 
                            func.concat(PembayaranDph.kd_kelurahan, func.concat(".", 
                            func.concat(PembayaranDph.kd_blok, func.concat(".", 
                            func.concat(PembayaranDph.no_urut, func.concat(".", 
                            func.concat(PembayaranDph.kd_jns_op, func.concat(".", 
                            func.concat(PembayaranDph.thn_pajak_sppt, func.concat(".", 
                            func.concat(PembayaranDph.pembayaran_ke))))))))))))))))), mData="id"),
                    ColumnDT(query_nop(self.table), mData="nop"),
                    ColumnDT(PembayaranDph.thn_pajak_sppt, mData='tahun'),
                    ColumnDT(PembayaranDph.nm_wp_sppt, mData='nama'),
                    ColumnDT(PembayaranDph.tgl_jatuh_tempo_sppt,
                             mData='jatuh_Tempo'),
                    ColumnDT(PembayaranDph.pbb_yg_harus_dibayar_sppt,
                             mData='pokok'),
                    ColumnDT(PembayaranDph.denda, mData='denda'),
                    ColumnDT(PembayaranDph.bayar, mData='bayar'),
                    ColumnDT(PembayaranDph.tgl_pembayaran,
                             mData='tgl_pembayaran'),
                    ColumnDT(PembayaranDph.posted, mData='posted'),
                    ColumnDT(PembayaranDph.status, mData='status'),
                    ColumnDT(PembayaranDph.pembayaran_ke, mData='ke'),
                ]
                query = DBSession.query().select_from(PembayaranDph).\
                    filter(PembayaranDph.tgl_pembayaran
                           .between(self.dt_awal, self.dt_akhir),
                           PembayaranDph.create_uid == request.user.id). \
                    order_by(desc(PembayaranDph.id))

                row_table = DataTables(request.GET, query, columns)
                return row_table.output_result()
        else:
            return super().view_act()

    def query_id(self):
        q = self.table.query_id(self.req.matchdict['id'])
        return q

    def next_add(self, form, **kwargs):
        request = self.req
        log.debug("Next")
        table = kwargs.get("table", None)
        if 'search' in self.req.POST:
            log.debug("Search")
            controls = request.POST.items()
            # request.session['nop_desa'] = values['nop_desa']
            # request.session['nop_blok'] = values['nop_blok']
            try:
                c = form.validate(controls)
            except ValidationFailure as e:
                form.render(appstruct=e.cstruct)
                self.ses.flash('Data NOP atau Tahun Tidak Valid', 'error')
                return self.returned_form(form, **kwargs)

            values = dict(c)
            # menggabungkan beberapa nilai menjadi nilai nop
            # nop = values['nop_pemda'] + values['nop_desa'] + values['nop_blok'] + \
            #       values['nop_urut'] + values['nop_jenis']

            # values = format_thousand(values)
            form.render(appstruct=values)
            return self.returned_form(form, **kwargs)
        #
        #     if 'simpan' in request.POST:
        #         if not 'pegawai_kd' in request.session:
        #             request.session.flash("NIP pegawai tidak ada ", 'error')
        #             return dict(form=form,
        #                         status=2)
        #         save_request(request, values)
        #         values = format_thousand(values)
        #         form.render(appstruct=values)
        #         return dict(form=form,
        #                     status=3)
        # return route_add(request)

        # mengisi value nop_pemda dari pbb_pemda, mengisi nop_desa dan nop_blok dengan membuat session
        # values = dict(nop_pemda=pbb_pemda(),
        #               nop_desa='nop_desa' in request.session and request.session['nop_desa'] or '',
        #               nop_blok='nop_blok' in request.session and request.session['nop_blok'] or '')
        # form.render(appstruct=values)
        #
        # return dict(form=form,
        #             status=1)

    def save_request(self, values, row=None):
        values["create_uid"] = self.req.user.id
        return super().save(values, row)

    def form_validator(self, form, value):
        e = colander.Invalid(form, "Error message on Form")
        error = {}
        nop = value["nop"]
        dati2 = FixDati2(nop)
        if dati2["kd_propinsi"] != self.pemda["kd_propinsi"] or \
                dati2["kd_dati2"] != self.pemda["kd_dati2"]:
            error["nop"] = "Kode pemda tidak sesuai"

        desa = FixKelurahan(nop)
        user = UserArea.allow_area(self.req.user.id, desa.get_raw_dotted())
        if not user:
            e["nop"] = f"Anda tidak punya akses melihat NOP {nop}"
            raise e

        nop = value['nop']
        sppt = PembayaranDph.piutang(nop, value['tahun'])

        if not sppt:
            error["nop"] = 'SPPT Tidak Ditemukan'
        else:
            if sppt and 'status' in sppt:
                msg = 'SPPT Sudah Ada Pembayaran'
                if sppt['pokok'] > 0:
                    msg = '%s (Sisa tagihan Rp. %s)' % (
                        msg, thousand(sppt["pokok"]))
                else:
                    error["nop"] = '%s (SPPT Sudah Lunas)' % (msg)

            value.update(sppt["sppt"].to_dict(date_format="%Y-%m-%d %H:%M:%S"))
            value["tagihan"] = {
                'pokok': sppt['pokok'],
                'denda': sppt['denda'],
                'jumlah': sppt['pokok'] + sppt['denda'],
                'tgl_jatuh_tempo_sppt': sppt["jatuh_tempo"],
            }
            value['pembayaran_ke'] = sppt['ke']
            value["lokasi_objek_pajak"] = {
                'kecamatan': Kecamatan.query_id(nop).first().nm_kecamatan,
                'kelurahan': Kelurahan.query_id(nop).first().nm_kelurahan,

            }
            value["wajib_pajak"] = {
                'nm_wp_sppt': sppt['sppt'].nm_wp_sppt,
                'jln_wp_sppt': sppt['sppt'].jln_wp_sppt,
                'blok_kav_no_wp_sppt': sppt['sppt'].blok_kav_no_wp_sppt and sppt['sppt'].blok_kav_no_wp_sppt or "",
                'rt_wp_sppt': sppt['sppt'].rt_wp_sppt and sppt['sppt'].rt_wp_sppt or "00",
                'rw_wp_sppt': sppt['sppt'].rw_wp_sppt and sppt['sppt'].rt_wp_sppt or "000",
                'kelurahan_wp_sppt': sppt['sppt'].kelurahan_wp_sppt and sppt['sppt'].kelurahan_wp_sppt or "",
                'kota_wp_sppt': sppt['sppt'].kota_wp_sppt and sppt['sppt'].kota_wp_sppt or "" ,
                'npwp_sppt': sppt['sppt'].npwp_sppt and sppt['sppt'].npwp_sppt or "",
                'kd_pos_wp_sppt': sppt['sppt'].kd_pos_wp_sppt and sppt['sppt'].kd_pos_wp_sppt or "",
            }
            tgl_bayar = datetime.now()
            value["pembayaran_ke"] = sppt["ke"]
            value["pokok"] = sppt["pokok"]
            value["denda"] = sppt["denda"]
            value["bayar"] = sppt['pokok'] + sppt['denda']
            value["tgl_pembayaran"] = ymd(tgl_bayar)
            value["tgl_rekam_byr"] = tgl_bayar
            value["status"] = 0
        if error:
            for r in error:
                e[r] = error[r]
            raise e
            # pass

            # edited---------------------------------------------------------------------------
            # # def err_nop_des():
            # #     raise colander.Invalid(form,
            # #                            'NOP desa %s tidak boleh lebih dari 6 angka.' % (
            # #                            value['nop_desa']))
            # #
            # # def err_nop_blok():
            # #     raise colander.Invalid(form,
            # #                            'NOP blok %s tidak boleh lebih dari 3 angka.' % (
            # #                            value['nop_blok']))
            # #
            # # def err_nop_norut():
            # #     raise colander.Invalid(form,
            # #                            'NOP nomor urut %s tidak boleh lebih dari 4 angka.' % (
            # #                                value['nop_urut']))
            # #
            # # def err_nop_jenis():
            # #     raise colander.Invalid(form,
            # #                            'NOP jenis %s tidak boleh lebih dari 1 angka.' % (
            # #                                value['nop_jenis']))
            # #
            # # # syarat
            # # nop_des = len(value['nop_desa'])
            # # nop_blk = len(value['nop_blok'])
            # # nop_urt = len(value['nop_urut'])
            # # nop_jns = len(value['nop_jenis'])
            #
            # if nop_des > 6:
            #     err_nop_des()
            # if nop_blk > 3:
            #     err_nop_blok()
            # if nop_urt > 4:
            #     err_nop_norut()
            # if nop_jns > 1:
            #     err_nop_jenis()

    @ view_config(route_name='pbbm-dph-add', renderer='templates/form.pt',
                  permission='pbb-monitoring-dph')
    def view_add(self):
        return super().view_add()
        #
        # request = self.req
        # form = get_form(request, AddSchema)
        #
        # if request.POST:
        #     if 'batal' in request.POST:
        #         return route_list(request)
        #
        #     if 'cari' in request.POST or 'simpan' in request.POST:
        #
        #         controls = request.POST.items()
        #         # memunculkan session ketika diclose atau disimpan
        #         values = dict(controls)
        #         request.session['nop_desa'] = values['nop_desa']
        #         request.session['nop_blok'] = values['nop_blok']
        #
        #         try:
        #             controls = form.validate(controls)
        #         except ValidationFailure as e:
        #             form.render(appstruct=e.cstruct)
        #             self.ses.flash('Data NOP atau Tahun Tidak Valid', 'error')
        #             return dict(form=form,
        #                         status=1)
        #
        #         values = dict(controls)
        #         # menggabungkan beberapa nilai menjadi nilai nop
        #         nop = values['nop_pemda'] + values['nop_desa'] + values['nop_blok'] + \
        #               values['nop_urut'] + values['nop_jenis']
        #
        #         # nop = values['nop']
        #
        #         sppt = PembayaranDph.piutang(nop, values['tahun'])
        #         if sppt and 'status' in sppt:
        #             msg = 'SPPT Sudah Ada Pembayaran'
        #
        #             if sppt['pokok'] > 0:
        #                 msg = '%s (Sisa tagihan Rp. %s)' % (msg, thousand(pokok))
        #             else:
        #                 msg = '%s (SPPT Sudah Lunas)' % (msg)
        #             self.ses.flash(msg, 'error')
        #             return dict(form=form,
        #                         status=1)
        #
        #         if not sppt:
        #             self.ses.flash('SPPT Tidak Ditemukan', 'error')
        #             return dict(form=form,
        #                         status=1)
        #
        #         values['pokok'] = sppt['pokok']
        #         values['denda'] = sppt['denda']
        #         values['jumlah'] = sppt['pokok'] + sppt['denda']
        #         values['pembayaran_ke'] = sppt['ke']
        #
        #         values['kecamatan'] = Kecamatan.query_id(nop).first().nm_kecamatan
        #         values['kelurahan'] = Kelurahan.query_id(nop).first().nm_kelurahan
        #
        #         values['nm_wp_sppt'] = sppt['sppt'].nm_wp_sppt
        #         values['jln_wp_sppt'] = sppt['sppt'].jln_wp_sppt
        #         values['blok_kav_no_wp_sppt'] = sppt['sppt'].blok_kav_no_wp_sppt
        #         values['rt_wp_sppt'] = sppt['sppt'].rt_wp_sppt
        #         values['rw_wp_sppt'] = sppt['sppt'].rw_wp_sppt
        #         values['kelurahan_wp_sppt'] = sppt['sppt'].kelurahan_wp_sppt
        #         values['kota_wp_sppt'] = sppt['sppt'].kota_wp_sppt
        #         values['npwp_sppt'] = sppt['sppt'].npwp_sppt
        #         values['kd_pos_wp_sppt'] = sppt['sppt'].kd_pos_wp_sppt
        #         if 'cari' in request.POST:
        #             values = format_thousand(values)
        #             form.render(appstruct=values)
        #             return dict(form=form,
        #                         status=2)
        #
        #         if 'simpan' in request.POST:
        #             if not 'pegawai_kd' in request.session:
        #                 request.session.flash("NIP pegawai tidak ada ", 'error')
        #                 return dict(form=form,
        #                             status=2)
        #             save_request(request, values)
        #             values = format_thousand(values)
        #             form.render(appstruct=values)
        #             return dict(form=form,
        #                         status=3)
        #     return route_add(request)
        # # mengisi value nop_pemda dari pbb_pemda, mengisi nop_desa dan nop_blok dengan membuat session
        # values = dict(nop_pemda=pbb_pemda(),
        #               nop_desa='nop_desa' in request.session and request.session['nop_desa'] or '',
        #               nop_blok='nop_blok' in request.session and request.session['nop_blok'] or '')
        # form.render(appstruct=values)
        #
        # return dict(form=form,
        #             status=1)

    @ view_config(route_name='pbbm-dph-view', renderer='templates/form_dph.pt',
                  permission='pbb-monitoring-dph')
    def view_view(self):
        self.form_scripts = scripts
        return super().view_view(buttons=(btn_cancel, btn_bukti_terima))

    def get_values(self, row, istime=False):
        d = row.to_dict(date_format='%Y-%m-%d')
        for f in d:
            if type(d[f]) is str:
                d[f] = d[f].strip()
        d["nop"] = nop_formatted(row)
        d["tahun"] = row.thn_pajak_sppt
        d['pokok'] = row.pbb_yg_harus_dibayar_sppt
        d['jumlah'] = row.bayar
        d['kecamatan'] = Kecamatan.query_id(
            nop_formatted(row)).first().nm_kecamatan
        d['kelurahan'] = Kelurahan.query_id(
            nop_formatted(row)).first().nm_kelurahan
        for art in self.rinci:
            d[art] = d
        return d

    def pdf_response(self, **kwargs):
        query = self.table.query_register()
        _here = os.path.dirname(__file__)  # get current folder -> views
        path = os.path.dirname(_here)  # mundur 1 level
        path = os.path.join(path, 'reports')
        rml_row = open_rml_row(path + '/dph.row.rml')

        rows = []
        tot_denda = tot_bayar = 0
        for r in query.all():
            s = rml_row.format(nop=r.nop, tahun=r.tahun, nama=r.nama,
                               pokok=thousand(r.bayar - r.denda),
                               denda=thousand(r.denda),
                               bayar=thousand(r.bayar))
            rows.append(s)
            tot_denda += r.denda
            tot_bayar += r.bayar
        s = rml_row.format(nop='JUMLAH', tahun='', nama='',
                           pokok=thousand(tot_bayar - tot_denda),
                           denda=thousand(tot_denda),
                           bayar=thousand(tot_bayar))
        rows.append(s)
        pdf, filename = open_rml_pdf(path + '/dph.rml', rows=rows,
                                     company=self.req.company,
                                     departement=self.req.departement,
                                     address=self.req.address,
                                     periode="%s s.d %s" % (self.awal, self.akhir))
        return pdf_response(self.req, pdf, filename)


scripts = """
            window.jsPDF = window.jspdf.jsPDF;
            var docPDF = new jsPDF();

            function downloadPDF(invoiceNo){
                $('[name=cancel]').hide();
                $('[name=cetak_bukti_bayar]').hide();
                var elementHTML = document.querySelector("#content");
                docPDF.html(elementHTML, {
                    callback: function(docPDF) {
                        docPDF.save(invoiceNo+'.pdf');
                    },
                    x: 15,
                    y: 15,
                    width: 170,
                    windowWidth: 650
                });
            }
            $(document).ready(function() {
                $('[name=cetak_bukti_bayar]').click(function () {
                    downloadPDF('a');
                    setTimeout(function () {
                        $('[name=cetak_bukti_bayar]').show();
                        $('[name=cancel]').show();
                    }, 5000);
                });
            });
        """

#
# def format_thousand(values):
#     values['pokok'] = thousand(values['pokok'])
#     values['denda'] = thousand(values['denda'])
#     values['jumlah'] = thousand(values['jumlah'])
#     return values
#
#
# #######
# # Add #
# #######
# def form_validator(form, value):
#     # pass
#
#     # edited---------------------------------------------------------------------------
#     def err_nop_des():
#         raise colander.Invalid(form,
#                                'NOP desa %s tidak boleh lebih dari 6 angka.' % (value['nop_desa']))
#
#     def err_nop_blok():
#         raise colander.Invalid(form,
#                                'NOP blok %s tidak boleh lebih dari 3 angka.' % (value['nop_blok']))
#
#     def err_nop_norut():
#         raise colander.Invalid(form,
#                                'NOP nomor urut %s tidak boleh lebih dari 4 angka.' % (
#                                    value['nop_urut']))
#
#     def err_nop_jenis():
#         raise colander.Invalid(form,
#                                'NOP jenis %s tidak boleh lebih dari 1 angka.' % (
#                                    value['nop_jenis']))
#
#     # syarat
#     nop_des = len(value['nop_desa'])
#     nop_blk = len(value['nop_blok'])
#     nop_urt = len(value['nop_urut'])
#     nop_jns = len(value['nop_jenis'])
#
#     if nop_des > 6:
#         err_nop_des()
#     if nop_blk > 3:
#         err_nop_blok()
#     if nop_urt > 4:
#         err_nop_norut()
#     if nop_jns > 1:
#         err_nop_jenis()
#
#
# def get_form(request, class_form, row=None):
#     schema = class_form(validator=form_validator)
#     schema = schema.bind()
#     schema.request = request
#     if row:
#         schema.deserialize(row)
#     return Form(schema, buttons=('simpan', 'batal'))
#
#
# def save(values, user, row=None):
#     if not row:
#         row = PembayaranDph()
#         row.tgl_pembayaran = datetime.now().date()
#         row.tgl_rekam_byr = datetime.now()
#         row.user_id = user.id
#         row.posted = 0
#     row.from_dict(values)
#     PbbmDBSession.add(row)
#     PbbmDBSession.flush()
#     return row
#
#
# def save_request(request, values, row=None):
#     if 'id' in request.matchdict:
#         values['id'] = request.matchdict['id']
#     nop = values['nop_pemda'] + values['nop_desa'] + values['nop_blok'] + \
#           values['nop_urut'] + values['nop_jenis']
#     fixNop = FixNop(nop)
#     values['kd_propinsi'] = fixNop['kd_propinsi']
#     values['kd_dati2'] = fixNop['kd_dati2']
#     values['kd_kecamatan'] = fixNop['kd_kecamatan']
#     values['kd_kelurahan'] = fixNop['kd_kelurahan']
#     values['kd_blok'] = fixNop['kd_blok']
#     values['no_urut'] = fixNop['no_urut']
#     values['kd_jns_op'] = fixNop['kd_jns_op']
#     values['thn_pajak'] = values['tahun']
#     values['bayar'] = values['jumlah']
#     values['departemen_id'] = request.session['departemen_id']
#     values['nip_rekam_byr'] = request.session['pegawai_kd']
#
#     row = save(values, request.user, row)
#     request.session.flash('DPH sudah disimpan.')
#
#
# def route_list(request):
#     return HTTPFound(location=request.route_url('pbbm-dph'))
#
#
# def route_add(request):
#     return HTTPFound(location=request.route_url('pbbm-dph-add'))