def updateReport(dataMS4):
if request.method == 'POST':
loadData = json.loads(dataMS4)
for row in loadData:
kode_laporan = row['kode_laporan']
org_id = row['org_id']
namaFile = row['namaFile']
PIC = row['PIC']
Pen = row['Penerima']
report_judul = row['reportJudul']
lastProc = datetime.datetime.now()
try:
db = databaseCMS.db_readReport()
cursor = db.cursor()
cursor.execute("INSERT INTO readreport (report_id, report_judul, org_id, namaFile,\
report_lastProcess, read_PIC, read_Penerima)\
VALUES(%s,%s,%s,%s,%s,%s,%s) ON DUPLICATE KEY UPDATE\
report_judul='"+report_judul+"', org_id='"+org_id+"',\
namaFile='"+namaFile+"', report_lastProcess='"+str(lastProc)+"',\
read_PIC = '"+str(PIC)+"', read_Penerima='"+str(Pen)+"' ",(kode_laporan, report_judul,\
org_id, namaFile, str(lastProc), str(PIC), str(Pen)))
db.commit()
except Error as e :
print("Error while connecting file MySQL", e)
finally:
#Closing DB Connection.
if(db.is_connected()):
cursor.close()
db.close()
print("MySQL connection is closed")
def updateReport():
lastProc = datetime.datetime.now()
try:
db = databaseCMS.db_readReport()
cursor = db.cursor()
cursor.execute("INSERT INTO readreport (report_id, report_judul, org_id, namaFile,\
report_lastProcess, read_PIC)\
VALUES(%s,%s,%s,%s,%s,%s,%s) ON DUPLICATE KEY UPDATE\
report_judul='"+report_judul"', org_id='"+org_id+"',\
namaFile='"+namaFile+"', report_lastProcess='"+lastProc+"' ",(kode_laporan, judul_laporan,\
org_id, namaFile, lastProc, PIC))
def viewReport(email):
try:
db = databaseCMS.db_readReport()
cursor = db.cursor()
cursor.execute(
'SELECT report_id, org_id, report_judul,namaFile, report_lastProcess\
FROM readreport a WHERE \
report_lastProcess in (SELECT max(b.report_lastProcess)\
FROM readreport b WHERE a.report_id = b.report_id)\
AND (read_PIC\
LIKE "%' + email + '%" OR read_penerima LIKE "%' + email + '%") ')
listReport = cursor.fetchall()
LR = []
for row in listReport:
a = requests.get('http://127.0.0.1:5001/getNamaOrg/' + str(row[1]))
b = json.dumps(a.json())
c = json.loads(b)
for x in c:
orgName = x['org_name']
listDict = {
'reportId': row[0],
'orgName': orgName,
'orgId': row[1],
'reportJudul': row[2],
'namaFile': row[3],
'reportLastProc': row[4]
}
LR.append(listDict)
result = json.dumps(LR)
return result
except Error as e:
print("Error while connecting file MySQL", e)
finally:
#Closing DB Connection.
if (db.is_connected()):
cursor.close()
db.close()
print("MySQL connection is closed")
def getNamaFile(kode_laporan):
try:
db = databaseCMS.db_readReport()
cursor = db.cursor()
cursor.execute('SELECT namaFile from readreport WHERE report_id = "'+kode_laporan+'"')
result = cursor.fetchone()
print(result)
return json.dumps(result)
except Error as e :
print("Error while connecting file MySQL", e)
finally:
#Closing DB Connection.
if(db.is_connected()):
cursor.close()
db.close()
print("MySQL connection is closed")