def dgPenjab(request):
sort_by = "penjab.kd_pj"
query_total = "select count(*) from penjab"
query_data = "select * from penjab"
kwargs={
"png_jawab":request.POST.get('cPng_jawab')
}
return jsonView.datagridJson(sort_by,query_total,query_data,Penjab,request,tgl="",**kwargs)
def dgBangsal(request):
sort_by = "bangsal.nm_bangsal"
query_total = "select count(*) from bangsal"
query_data = "select * from bangsal"
kwargs = {"kd_bangsal": request.POST.get('cKd_bangsal')}
return jsonView.datagridJson(sort_by,
query_total,
query_data,
Bangsal,
request,
tgl="",
**kwargs)
def dgPoliklinik(request):
sort_by = "poliklinik.nm_poli"
query_total = "select count(*) from poliklinik"
query_data = "select * from poliklinik"
kwargs = {"kd_poli": request.POST.get('cKd_poli')}
return jsonView.datagridJson(sort_by,
query_total,
query_data,
Poliklinik,
request,
tgl="",
**kwargs)
def dgRekening(request):
sort_by = "rekening.nm_rek"
query_total = "select count(*) from rekening"
query_data = """
select rekening.kd_rek,rekening.nm_rek,rekening.tipe,rekening.balance,rekening.level from rekening
"""
kwargs = {'kd_rek': request.POST.get('cKd_rek')}
return jsonView.datagridJson(sort_by,
query_total,
query_data,
Rekening,
request,
tgl="",
**kwargs)
def dgKamar(request):
sort_by = "bangsal.nm_bangsal"
query_total = "select count(*) from kamar inner join bangsal on kamar.kd_bangsal=bangsal.kd_bangsal"
query_data = """
select kamar.kd_bangsal,kamar.kelas,kamar.statusdata,kamar.kd_kamar,bangsal.nm_bangsal,kamar.status,kamar.trf_kamar
from kamar
inner join bangsal on kamar.kd_bangsal=bangsal.kd_bangsal
"""
kwargs = {"nm_bangsal": request.POST.get('cNm_bangsal')}
return jsonView.datagridJson(sort_by,
query_total,
query_data,
Kamar,
request,
tgl="",
**kwargs)