def getDosenByKeahlian(keahlian_id):
query = """select dosen.id, dosen.NIP, dosen.Nama from dosen
join dosen_has_lingkup_keahlian on dosen_has_lingkup_keahlian.dosen_id = dosen.id
join lingkup_keahlian on lingkup_keahlian.id = dosen_has_lingkup_keahlian.lingkup_keahlian_id
where lingkup_keahlian.id = '{0}'""".format(keahlian_id)
cursor = ExecuteSql(query)
return cursor.fetchall()
def getKeahlianDosen(NIP):
query = """select lingkup_keahlian.id, lingkup_keahlian.keahlian from lingkup_keahlian
join dosen_has_lingkup_keahlian on dosen_has_lingkup_keahlian.lingkup_keahlian_id = lingkup_keahlian.id
join dosen on dosen.id = dosen_has_lingkup_keahlian.dosen_id
where dosen.NIP = '{0}'""".format(NIP)
cursor = ExecuteSql(query)
results = cursor.fetchall()
keahlian = mapKeahlian(results)
return keahlian
def getDosenProfile(NIP):
queryDosen = "select id, NIP ,nama, jenis_kelamin, email from dosen where NIP = '{0}'".format(
NIP)
cusrsor = ExecuteSql(queryDosen)
result = cusrsor.fetchone()
dosen = Dosen()
dosen.id = result[0]
dosen.NIP = result[1]
dosen.nama = result[2]
dosen.jenis_kelamin = result[3]
dosen.email = result[4]
return dosen
def getTugasAkhirBimbingan(NIP):
query = """select
mahasiswa.id_mahasiswa,
nama_mahasiswa,
tugas_akhir.Judul,
tugas_akhir.status,
tugas_akhir.id
from mahasiswa
join tugas_akhir on mahasiswa.Tugas_Akhir_id = tugas_akhir.id
join dosen on tugas_akhir.id_dosen = dosen.id
where dosen.NIP = '{0}'""".format(NIP)
cursor = ExecuteSql(query)
return cursor.fetchall()
def login(username, password, loginAs):
query = ''
if loginAs == 'mahasiswa':
query = "select count(*) from {0} where {1} = '{2}' AND password = '******' ".format(
'mahasiswa', 'id_mahasiswa', username, password)
elif loginAs == 'dosen':
query = "select count(*) from {0} where {1} = '{2}' AND password = '******' ".format(
'dosen', 'NIP', username, password)
else:
query = "select count(*) from {0} where {1} = '{2}' AND password = '******' ".format(
'admin', 'NIP', username, password)
try:
cursor = ExecuteSql(query)
row = cursor.fetchone()
except:
pass
if row[0] <= 0:
return False
session['username'] = username
session['login'] = loginAs
return True
def getAllKeahlian():
query = "select id, keahlian from lingkup_keahlian"
cursor = ExecuteSql(query)
results = cursor.fetchall()
keahlian = mapKeahlian(results)
return keahlian
def getAllDosen():
query = "select dosen.id, dosen.NIP, dosen.Nama from dosen"
cursor = ExecuteSql(query)
return cursor.fetchall()