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())