def status_krs():
status = 0
cursor = koneksi.cursor()
query = """SELECT set_8 FROM tb_setting WHERE set_5=%s""" % (aktiv)
cursor.execute(query)
data = cursor.fetchall()
for d in data:
status = d[0]
return status
def prodi_mhs(idd):
prodi_id = 0
cursor = koneksi.cursor()
query = """SELECT prodi_1 FROM tb_mhs WHERE mhs_1=%s""" % (idd)
cursor.execute(query)
data = cursor.fetchall()
for d in data:
prodi_id = d[0]
return prodi_id
def logo():
image = ""
cursor = koneksi.cursor()
query = """SELECT set_7 FROM tb_setting WHERE set_5=%s""" % (aktiv)
cursor.execute(query)
data = cursor.fetchall()
for d in data:
image = d[0]
return image
def nm_univ():
univ = ""
cursor = koneksi.cursor()
query = """SELECT set_2 FROM tb_setting WHERE set_5=%s""" % (aktiv)
cursor.execute(query)
data = cursor.fetchall()
for d in data:
univ = d[0]
return univ
def get_id_abl_kls(id_mhs, id_kls, tahun_ajaran, semester):
cursor = koneksi.cursor()
query = """SELECT abl_kls_1 FROM tb_ambil_kls WHERE mhs_1=%s AND kls_1=%s AND abl_kls_2=%s AND abl_kls_3=%s"""
cursor.execute(query, (id_mhs, id_kls, tahun_ajaran, semester))
temp = cursor.fetchall()
for t in temp:
data = t[0]
break
return data
def smstr():
sem = ""
cursor = koneksi.cursor()
query = """SELECT set_4 FROM tb_setting WHERE set_5=%s""" % (aktiv)
cursor.execute(query)
data = cursor.fetchall()
for d in data:
sem = d[0]
return sem
def get_id_dsn(idd):
cursor = koneksi.cursor()
query = """SELECT dsn_1 from tb_dosen WHERE usr_1=%s""" % (idd)
cursor.execute(query)
temp = cursor.fetchall()
for t in temp:
data = t[0]
break
return data
def thn_ajaran():
thn = ""
cursor = koneksi.cursor()
query = """SELECT set_3 FROM tb_setting WHERE set_5=%s""" % (aktiv)
cursor.execute(query)
data = cursor.fetchall()
for d in data:
thn = d[0]
return thn
def profil_dsn(idd):
data = ()
cursor = koneksi.cursor()
query = """SELECT * FROM tb_dosen WHERE dsn_1=%s""" % (idd)
cursor.execute(query)
temp = cursor.fetchall()
for i in temp:
data = data + i
return data
def profil_mhs(idd):
data = ()
cursor = koneksi.cursor()
query = """SELECT * FROM profil_mhs WHERE mhs_1=%s""" % (idd)
cursor.execute(query)
temp = cursor.fetchall()
for i in temp:
data = data + i
return data
def get_id_user(idd):
cursor = koneksi.cursor()
print "SELECT usr_1 from tb_user WHERE usr_2='%s'" % (str(idd))
query = "SELECT usr_1 from tb_user WHERE usr_2='%s'" % (str(idd))
cursor.execute(query)
temp = cursor.fetchall()
for d in temp:
data = d[0]
break
return data
def info_pilih_kelas(idd):
data = ()
cursor = koneksi.cursor()
query = """SELECT * FROM pilih_kelas WHERE kls_1=%s""" % (idd)
cursor.execute(query)
temp = cursor.fetchall()
for i in temp:
data = data + i
return data
def modelku():
try:
cursor = koneksi.cursor()
query = """DELIMITER // \n
CREATE PROCEDURE delete_dsn_usr (IN id_dosen INT) BEGIN DECLARE id_user int; SELECT tb_user.usr_1 INTO id_user FROM tb_user WHERE usr_6=id_dosen AND usr_4=3; DELETE FROM tb_user WHERE usr_1=id_user; \n
END; //"""
cursor.execute(query)
koneksi.commit()
cursor.close()
except Exception as e:
return {'error': str(e)}
print query
return query
def get_info(nm_tabel, kolom_tgl):
terbaru = ()
jumlah = ()
hasil = ()
cursor = koneksi.cursor()
query = """SELECT COUNT(%s) FROM %s""" % (kolom_tgl, nm_tabel)
cursor.execute(query)
data1 = cursor.fetchall()
query = """SELECT * FROM %s ORDER BY %s DESC""" % (nm_tabel, kolom_tgl)
cursor.execute(query)
data2 = cursor.fetchall()
for i in data1:
jumlah = jumlah + (i)
break
for i in data2:
terbaru = jumlah + (i)
break
hasil = hasil + (terbaru)
return hasil
