def delete(sysrole_kode):
global cursor
try:
cursor = connection.cursor()
cursor.execute("""DELETE FROM sys_role WHERE sysrole_kode=%s""", sysrole_kode)
connection.commit()
return utility.give_response("00", "DELETE ROLE SUKSES")
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def get():
global cursor
try:
cursor = connection.cursor()
cursor.execute("""SELECT * FROM sys_role""")
result = [dict((cursor.description[i][0], value)
for i, value in enumerate(row)) for row in cursor.fetchall()]
return utility.give_response("00", "GET ROLE SUKSES", result)
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def delete(sysuser_id):
global cursor
try:
cursor = connection.cursor()
cursor.execute("""DELETE FROM sys_user WHERE sysuser_id = %s""",
sysuser_id)
connection.commit()
return utility.give_response("00", "HAPUS USER SUKSES")
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def put(sysrole_kode):
global cursor
try:
sysrole_nama = request.form["sysrole_nama"]
cursor = connection.cursor()
cursor.execute("""UPDATE sys_role SET sysrole_nama=%s WHERE sysrole_kode=%s""",
(sysrole_nama, sysrole_kode))
connection.commit()
return utility.give_response("00", "UPDATE ROLE SUKSES")
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def post():
global cursor
try:
sysrole_kode = request.form["sysrole_kode"]
sysrole_nama = request.form["sysrole_nama"]
cursor = connection.cursor()
cursor.execute("""INSERT sys_role (sysrole_kode,sysrole_nama) VALUES (%s,%s)""",
(sysrole_kode, sysrole_nama))
connection.commit()
return utility.give_response("00", "INSERT ROLE SUKSES")
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def post():
global cursor
try:
sysrole_kode = request.form["sysrole_kode"]
sysmodul_kode = request.form["sysmodul_kode"]
cursor = connection.cursor()
cursor.execute("""DELETE FROM sys_rmodul WHERE sysrole_kode=%s AND sysmodul_kode=%s""",
(sysrole_kode, sysmodul_kode))
connection.commit()
return utility.give_response("00", "DELETE RMODUL SUKSES")
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def put(sysuser_id):
global cursor
try:
cursor = connection.cursor()
sysrole_kode = request.form["sysrole_kode"]
sysuser_nama = request.form["sysuser_nama"]
sysuser_namalengkap = request.form["sysuser_namalengkap"]
sysuser_email = request.form["sysuser_email"]
cursor.execute(
"""UPDATE sys_user SET sysrole_kode = %s, sysuser_nama = %s,
sysuser_namalengkap = %s, sysuser_email = %s WHERE sysuser_id = %s""",
(sysrole_kode, sysuser_nama, sysuser_namalengkap,
sysuser_email, sysuser_id))
connection.commit()
return utility.give_response("00", "UPDATE USER SUKSES")
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def get():
global cursor
try:
cursor = connection.cursor()
cursor.execute(
"""SELECT sys_user.sysuser_id, sys_role.sysrole_kode, sys_role.sysrole_nama,
sys_user.sysuser_nama,sys_user.sysuser_namalengkap,sys_user.sysuser_email
FROM sys_user
INNER JOIN sys_role ON sys_user.sysrole_kode = sys_role.sysrole_kode"""
)
result = [
dict((cursor.description[i][0], value)
for i, value in enumerate(row))
for row in cursor.fetchall()
]
return utility.give_response("00", "GET USER SUKSES", result)
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def post():
global cursor
try:
sysuser_id = request.form["sysuser_id"]
old_password_from_data = queryUtils.get_old_password(sysuser_id)
password_lama = utility.create_hash(request.form["password_lama"])
password_baru = utility.create_hash(request.form["password_baru"])
if password_lama == old_password_from_data:
cursor = connection.cursor()
cursor.execute("""UPDATE sys_user SET sysuser_passw=%s""",
password_baru)
connection.commit()
return utility.give_response("00", "UBAH PASSWORD SUKSES")
else:
return utility.give_response("01", "PASSWORD LAMA TIDAK SAMA",
old_password_from_data)
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def post():
global cursor
try:
sysuser_nama = request.form["sysuser_nama"]
sysuser_passw = utility.create_hash(request.form["sysuser_passw"])
cursor = connection.cursor()
cursor.execute(
"""SELECT COUNT( * ) FROM sys_user WHERE sysuser_nama = %s AND sysuser_passw = %s""",
(sysuser_nama, sysuser_passw))
result_count = cursor.fetchone()
result_row = queryUtils.get_info_user(sysuser_nama, sysuser_passw)
if result_count[0] == 1:
return utility.give_response("00", "LOGIN SUKSES", result_row)
else:
return utility.give_response(
"01", "LOGIN GAGAL,USERNAME ATAU PASSWORD SALAH")
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def put(sysmodul_kode):
global cursor
try:
sysmodul_nama = request.form["sysmodul_nama"]
sysmodul_url = request.form["sysmodul_url"]
sysmodul_icon = request.form["sysmodul_icon"]
sysmodul_parent = request.form["sysmodul_parent"]
if not sysmodul_parent:
sysmodul_parent = None
sysmodul_no_urut = request.form["sysmodul_no_urut"]
cursor = connection.cursor()
cursor.execute(
"""UPDATE sys_modul SET sysmodul_nama=%s,sysmodul_url=%s,sysmodul_icon=%s,sysmodul_parent=%s,sysmodul_no_urut=%s WHERE sysmodul_kode=%s""",
(sysmodul_nama, sysmodul_url, sysmodul_icon, sysmodul_parent,
sysmodul_no_urut, sysmodul_kode))
connection.commit()
return utility.give_response("00", "UPDATE MODUL SUKSES")
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def post():
global cursor
try:
sysuser_id = request.form["sysuser_id"]
sysrole_kode = request.form["sysrole_kode"]
sysuser_nama = request.form["sysuser_nama"]
sysuser_passw = utility.create_hash(request.form["sysuser_passw"])
sysuser_namalengkap = request.form["sysuser_namalengkap"]
sysuser_email = request.form["sysuser_email"]
cursor = connection.cursor()
cursor.execute(
"""INSERT INTO sys_user(sysuser_id, sysrole_kode, sysuser_nama,
sysuser_passw, sysuser_namalengkap, sysuser_email)
VALUES (%s, %s, %s, %s, %s, %s)""",
(sysuser_id, sysrole_kode, sysuser_nama, sysuser_passw,
sysuser_namalengkap, sysuser_email))
connection.commit()
return utility.give_response("00", "INSERT USER SUKSES")
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def post():
global cursor
try:
sysmodul_kode = request.form["sysmodul_kode"]
sysmodul_nama = request.form["sysmodul_nama"]
sysmodul_url = request.form["sysmodul_url"]
sysmodul_icon = request.form["sysmodul_icon"]
sysmodul_parent = request.form["sysmodul_parent"]
if not sysmodul_parent:
sysmodul_parent = None
sysmodul_no_urut = request.form["sysmodul_no_urut"]
cursor = connection.cursor()
cursor.execute(
"""INSERT INTO sys_modul (sysmodul_kode,sysmodul_nama,sysmodul_url,sysmodul_icon,sysmodul_parent,sysmodul_no_urut) VALUES (%s,%s,%s,%s,%s,%s)""",
(sysmodul_kode, sysmodul_nama, sysmodul_url, sysmodul_icon,
sysmodul_parent, sysmodul_no_urut))
connection.commit()
return utility.give_response("00", "INSERT MODUL SUKSES")
except Exception as e:
return utility.give_response("01", str(e))
finally:
cursor.close()
def page_not_found(e):
return utility.give_response("01", str(e))
def get():
return utility.give_response("00", os.getenv('APP_NAME'))
