def formEditSchedule():
ms2T = Template()
ms2S = Schedule()
if request.method == 'POST':
kode_laporan = request.form['valKode']
ms2T = Template()
ms2S = Schedule()
ms2S.listMaker(kode_laporan)
# print(kode_laporan)
return render_template(
'editSchedule2.html',
kode_laporan=kode_laporan,
detailSchedule=ms2S.showDetailSchedule(kode_laporan),
listPIC=ms2S.namaPIC(),
listPen=ms2S.namaPenerima())
##return render_template('editSchedule.html', detailSchedule = ms2S.showDetailSchedule(kode_laporan))
#return redirect (url_for('editSchedule', kode_laporan=kode_laporan,
# detailSchedule = ms2S.showDetailSchedule()))
return render_template('editSchedule.html',
listKodeLap=ms2T.listKodeReportEditSchedule())
def addSchedule():
ms2T = Template()
ms2S = Schedule()
return render_template('addNewSchedule.html', listKodeReportS = ms2T.listKodeReportAddNewSchedule(),
listPIC = ms2S.namaPIC(), listPen = ms2S.namaPenerima(),
)
def addNewTemplate():
if request.method == 'POST':
ms2T = Template()
kode_laporan = request.form['kodeLaporan2']
server_id = request.form['server']
report_judul = request.form['namaLaporan']
report_deskripsi = request.form['filter']
report_header = request.form['jmlHeader']
report_footer = request.form['jmlFooter']
report_jmlTampilan = request.form['jmlTampilan']
report_periode = request.form['periode']
report_createDate = datetime.datetime.now()
report_userUpdate = 'testUser'
report_lastUpdate = datetime.datetime.now()
report_aktifYN = 'Y'
org_id = request.form['organisasi']
ktgri_id = request.form['kategori']
report_printAllYN = request.form['printAll']
report_createdUser = '******'
report_scheduleYN = 'N'
ms2T.addNewTemplate(kode_laporan, server_id, report_judul, report_deskripsi,
report_header, report_footer, report_jmlTampilan,
report_periode, report_createDate, report_userUpdate,
report_lastUpdate, report_aktifYN, org_id, ktgri_id,
report_printAllYN, report_createdUser, report_scheduleYN)
# return redirect(url_for('newFormatTemplate'))
return render_template('formatTemplate.html', detailTemplate = ms2T.addDetailTemplate(kode_laporan),
kode_laporan=kode_laporan)
def newFormat():
ms2T = Template()
kode_laporan = request.form['kodeLaporan2']
return render_template('formatTemplate.html', detailTemplate = ms2T.addDetailTemplate(kode_laporan),
kode_laporan=kode_laporan)
def prosesInsertQuery():
ms2T = Template()
quer = []
kode_laporan = request.form['kodLap']
if request.method == 'POST':
for query in ['query1', 'query2', 'query3', 'query4', 'query5', 'query6', 'query7', 'query8', 'query9', 'query10', 'query11', 'query12', 'query13', 'query14']:
if (request.form[query] is not None) and (request.form[query] is not ''):
quer.append(request.form[query])
ms2T.addQuery(kode_laporan,quer)
return redirect(url_for('menu'))
def formatTemplate():
if request.method == 'POST':
ms2T = Template()
kode_laporan = request.form['kodeLaporan']
return render_template('formatTemplate.html', detailTemplate = ms2T.addDetailTemplate(kode_laporan),
kode_laporan=kode_laporan)
return redirect(url_for('addTemplate'))
def start():
print( "===============/prosesViewEditSchedule===============")
ms2T = Template()
ms2S = Schedule()
if request.method == 'POST':
kode_laporan = request.form['valKode']
ms2T = Template()
ms2S = Schedule()
ms2S.listMaker(kode_laporan)
#return redirect (url_for('formEditSchedule', kode_laporan=kode_laporan))
# return redirect (url_for('editSchedule', kode_laporan=kode_laporan,
# detailSchedule = ms2S.showDetailSchedule(kode_laporan)))
return render_template('editSchedule.html', kode_laporan=kode_laporan,
detailSchedule = ms2S.showDetailSchedule(kode_laporan),
listPIC = ms2S.namaPIC(), listPen = ms2S.namaPenerima())
def formEditSchedule():
ms2T = Template()
ms2S = Schedule()
if request.method == 'POST':
# kode_laporan = request.form['valKode']
# ms2T = Template()
# ms2S = Schedule()
# print(kode_laporan)
return render_template('editSchedule.html', detailSchedule = ms2S.showDetailSchedule(kode_laporan))
#return redirect (url_for('editSchedule', kode_laporan=kode_laporan,
# detailSchedule = ms2S.showDetailSchedule()))
return render_template('editSchedule.html', listKodeReport = ms2T.listKodeReport())
def addTemplate():
ms2T = Template()
return render_template('addNewTemplate.html',
listServer=ms2T.listNamaServer(),
listOrg=ms2T.listNamaOrganisasi(),
listKategori=ms2T.listKategori(),
listKodeReport=ms2T.listKodeReport())
def formatTemplate():
ms2T = Template()
if request.method == 'POST':
ms2T = Template()
kode_laporan = request.form['kodeLaporan']
return render_template('formatTemplate.html', detailTemplate = ms2T.addDetailTemplate(kode_laporan),
kode_laporan=kode_laporan, detailFormatTemplate = ms2T.detailFormatTemplate(kode_laporan))
# return redirect(url_for('addTemplate'))
return render_template('perubahan.html', listKodeReport = ms2T.listKodeReport())
def editQuery():
ms2T = Template()
if request.method == 'POST':
ms2T = Template()
kode_laporan = request.form['kodLap']
return render_template('insertQuery.html',
editQ=ms2T.viewEditQuery(kode_laporan),
kode_laporan=kode_laporan)
return render_template('perubahan.html',
listKodeReportQuery=ms2T.listKodeReportQuery())
def prosesFormatTemplate():
if request.method == 'POST':
ms2T = Template()
#Template
judul = request.form['namaReport']
periode = request.form['periode']
printAll = request.form['printAll']
jmlHeader = request.form['jmlHeader']
jmlFooter = request.form['jmlFooter']
jmlKolom = request.form['jmlKolom']
#Header
kol = []
lok = []
forK = []
lebK = []
kode_laporan = request.form['kodLap']
# kolom = request.form['kolom']
# lokasi = request.form['lokasi']
# formatKolom = request.form['formatKolom']
# lebarKolom = request.form['lebar']
#Footer
kolF = []
kolF1 = []
kolF2 = []
kolomFooter = request.form['kolomFooter']
for kolom in [
'1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12',
'13', '14', '15', '16', '17', '18', '19', '20'
]:
if (request.form[kolom] is not None) and (request.form[kolom]
is not ''):
kol.append(request.form[kolom])
for lokasi in [
'lokasi1', 'lokasi2', 'lokasi3', 'lokasi4', 'lokasi5',
'lokasi6', 'lokasi7', 'lokasi8', 'lokasi9', 'lokasi10',
'lokasi11', 'lokasi12', 'lokasi13', 'lokasi14', 'lokasi15',
'lokasi16', 'lokasi17', 'lokasi18', 'lokasi19', 'lokasi20'
]:
if (request.form[lokasi] is not None) and (request.form[lokasi]
is not ''):
lok.append(request.form[lokasi])
for formatKol in [
'formatKolom1', 'formatKolom2', 'formatKolom3', 'formatKolom4',
'formatKolom5', 'formatKolom6', 'formatKolom7', 'formatKolom8',
'formatKolom9', 'formatKolom10', 'formatKolom11',
'formatKolom12', 'formatKolom13', 'formatKolom14',
'formatKolom15', 'formatKolom16', 'formatKolom17',
'formatKolom18', 'formatKolom19', 'formatKolom20'
]:
if (request.form[formatKol]
is not None) and (request.form[formatKol] is not ''):
forK.append(request.form[formatKol])
for lebarKol in [
'lebar1', 'lebar2', 'lebar3', 'lebar4', 'lebar5', 'lebar6',
'lebar7', 'lebar8', 'lebar9', 'lebar10', 'lebar11', 'lebar12',
'lebar13', 'lebar14', 'lebar15', 'lebar16', 'lebar17',
'lebar18', 'lebar19', 'lebar20'
]:
if (request.form[lebarKol] is not None) and (request.form[lebarKol]
is not ''):
lebK.append(request.form[lebarKol])
for footer in ['kolFooter1', 'kolFooter2']:
if (kolomFooter is not None) and (kolomFooter is not ''):
kolF.append(kolomFooter)
# for check1 in ['B1', 'C1', 'D1', 'E1', 'F1', 'G1', 'H1', 'I1', 'J1', 'K1', 'L1', 'M1', 'N1']:
ms2T.saveFormatTemplate(
kode_laporan, kol, lok, forK, lebK
) #, kol, judul, periode, printAll, jmlHeader, jmlFooter, jmlKolom)
return redirect(url_for('menu'))
def insertQuery():
ms2T = Template()
return render_template('insertQuery.html', clearQ=ms2T.insQuery())
