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