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