laporan_rekap_dph.py
2.58 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
# import os
# import colander
# from datetime import datetime
# from sqlalchemy import not_, func, literal_column, and_, or_
# from sqlalchemy.orm import aliased
# from sqlalchemy.sql import select
# from pyramid.view import (view_config)
# from pyramid.httpexceptions import (HTTPFound,)
# from deform import (
# Form,
# widget,
# ValidationFailure,
# )
# from ..tools import dmy, date_from_str, INVOICE_STATUS as STATUS
# from ..views import ColumnDT, DataTables, BaseView, deferred_status
# from ..models import PbbmDBSession
# from ..models import PembayaranDph, Kecamatan, Kelurahan
#
# class view(BaseView):
# ########
# # List #
# ########
# @view_config(route_name='pbbm-dph-rekap', renderer='templates/rekap-lap-dph/list.pt',
# permission='pbbm-dph-rekap')
# def view_list(self):
# kecamatans = Kecamatan.query().order_by('kd_kecamatan').all()
# kelurahans = Kelurahan.query().\
# filter_by(kd_kecamatan=self.ses['kd_kecamatan']).\
# order_by('kd_kelurahan').all()
# return dict(project=self.req.app_name,
# kecamatans = kecamatans,
# kelurahans = kelurahans,
# tahun = datetime.now().year)
#
# ##########
# # Action #
# ##########
# @view_config(route_name='pbbm-dph-rekap-act', renderer='json',
# permission='pbbm-dph-rekap-act')
# def view_act(self):
# request = self.req
# ses = request.session
# params = request.params
# url_dict = request.matchdict
#
# # ambil prosedur rekap dari model pembayaran dph
# query_union = PembayaranDph.rekap(ses['dt_awal'], ses['dt_akhir'])
#
# if url_dict['act']=='grid':
# columns = [
# ColumnDT(query_union.c.kode, mData="kode"),
# ColumnDT(query_union.c.uraian, mData="uraian"),
# ColumnDT(query_union.c.jumlah, mData="jumlah", global_search=False),
# ColumnDT(query_union.c.bayar, mData="bayar", global_search=False),
# ColumnDT(query_union.c.denda, mData="denda", global_search=False),
# ]
# query = PbbmDBSession.query().select_from(query_union).\
# order_by(query_union.c.kode)
#
# rowTable = DataTables(request.GET, query, columns)
# return rowTable.output_result()
#
#
# def route_list(request):
# return HTTPFound(location=request.route_url('pbbm-dph-rekap'))