gambaran_umum.py
1.65 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
# from types import NoneType
import os
from pyramid.view import (
view_config,
)
from ..views import BaseView
from ..models import *
from ..models.eis import Eis, Chart, ChartItem, Slide
from datatables import ColumnDT, DataTables
from sqlalchemy import func, and_, String, text
from sqlalchemy.sql.expression import cast
from ..models.payment import PaymentPBB, PaymentPAD, PaymentBPHTB, PaymentWEBR, TargetsBangbadil, UploadRealisasiOpsen
from opensipkd.pbb.monitoring.models import PembayaranSppt, Kecamatan, Kelurahan, Sppt
from opensipkd.pjdl.models import Sspd, Pajak, Usaha, PdlDBSession
from datetime import timedelta
from ..models.payment import PCDBSession
from pyramid.renderers import render_to_response
from eispajak.models.eis import UploadFiles, DBSession
log = logging.getLogger(__name__)
class Views(BaseView):
def __init__(self, request):
super().__init__(request)
self.db_session = PCDBSession
# @view_config(route_name='eis-pajak-gambaran', renderer='templates/gambaran_umum.pt',
# permission='eis')
def view_pajak(self):
files = DBSession.query(UploadFiles.title.label('title'),
UploadFiles.description.label('description'),
UploadFiles.file_name.label('file'),
)
files = files.select_from(UploadFiles).all()
page = self.req.matchdict.get('page')
return render_to_response(
'templates/gambaran_umum.pt',
dict(files=files, ),
request=self.req
)
# return {"module": 'pajak',
# "title": "Realisasi Pajak Daerah"}