runQuery($q);
?>
Statistik Dosen
runQuery($d);
if($db->dbRows()>0){
$dosen=$db->dbFetch();
}
switch($jenis){
case 'pemb1':
$qq="SELECT tm.nim, tm.nmLengkap, trh.judul_final
FROM tbrekaphasil trh
LEFT JOIN tbdosen td ON (trh.pemb1=td.nip)
LEFT JOiN tbmhs tm ON (trh.nim=tm.nim)
WHERE trh.semester='$smt' AND td.nip='$nip'";
$txt="Sebagai Pembimbing 1";
break;
case 'pemb2':
$qq="SELECT tm.nim, tm.nmLengkap, trh.judul_final
FROM tbrekaphasil trh
LEFT JOIN tbdosen td ON (trh.pemb2=td.nip)
LEFT JOiN tbmhs tm ON (trh.nim=tm.nim)
WHERE trh.semester='$smt' AND td.nip='$nip'";
$txt="Sebagai Pembimbing 2";
break;
case 'peng1':
$qq="SELECT tm.nim, tm.nmLengkap, trh.judul_final
FROM tbrekaphasil trh
LEFT JOIN tbdosen td ON (trh.peng1=td.nip)
LEFT JOiN tbmhs tm ON (trh.nim=tm.nim)
WHERE trh.semester='$smt' AND td.nip='$nip'";
$txt="Sebagai Penguji 1";
break;
case 'peng2':
$qq="SELECT tm.nim, tm.nmLengkap, trh.judul_final
FROM tbrekaphasil trh
LEFT JOIN tbdosen td ON (trh.peng2=td.nip)
LEFT JOiN tbmhs tm ON (trh.nim=tm.nim)
WHERE trh.semester='$smt' AND td.nip='$nip'";
$txt="Sebagai Penguji 2";
break;
}
//echo $qq;
$db->runQuery($qq);
echo $dosen['nmLengkap']." : ";
echo $txt."
";
echo 'Daftar Mahasiswa
';
echo 'semester : '.$smt.'
';
echo '';
echo '
| NIM |
Nama Mahasiswa |
Judul |
';
if($db->dbRows()>0){
while($m=$db->dbFetch()){
echo '
| '.$m['nim'].' |
'.$m['nmLengkap'].' |
'.$m['judul_final'].' |
';
}
}
echo '
';
}
}else{
$db2=new dB($dbsetting);
if($_GET['detail']==""){
$q="SELECT td.nip,td.nmLengkap, COUNT(if(trh.pemb1=td.nip,1,null)) as pemb1,
COUNT(if(trh.pemb2=td.nip,1,null)) as pemb2,
COUNT(if(trh.peng1=td.nip,1,null)) as peng1,
COUNT(if(trh.peng2=td.nip,1,null)) as peng2
FROM tbrekaphasil trh,tbdosen td
WHERE td.status='A'
GROUP BY td.nip
ORDER BY td.nip
";
$db2->runQuery($q);
?>
Statistik Dosen
runQuery($d);
if($db2->dbRows()>0){
$dosen=$db2->dbFetch();
}
switch($jenis){
case 'pemb1':
$qq="SELECT tm.nim, tm.nmLengkap, trh.judul_final, trh.semester
FROM tbrekaphasil trh
LEFT JOIN tbdosen td ON (trh.pemb1=td.nip)
LEFT JOiN tbmhs tm ON (trh.nim=tm.nim)
WHERE td.nip='$nip' ORDER BY trh.semester, tm.nim";
$txt="Sebagai Pembimbing 1";
break;
case 'pemb2':
$qq="SELECT tm.nim, tm.nmLengkap, trh.judul_final, trh.semester
FROM tbrekaphasil trh
LEFT JOIN tbdosen td ON (trh.pemb2=td.nip)
LEFT JOiN tbmhs tm ON (trh.nim=tm.nim)
WHERE td.nip='$nip' ORDER BY trh.semester, tm.nim";
$txt="Sebagai Pembimbing 2";
break;
case 'peng1':
$qq="SELECT tm.nim, tm.nmLengkap, trh.judul_final, trh.semester
FROM tbrekaphasil trh
LEFT JOIN tbdosen td ON (trh.peng1=td.nip)
LEFT JOiN tbmhs tm ON (trh.nim=tm.nim)
WHERE td.nip='$nip' ORDER BY trh.semester, tm.nim";
$txt="Sebagai Penguji 1";
break;
case 'peng2':
$qq="SELECT tm.nim, tm.nmLengkap, trh.judul_final, trh.semester
FROM tbrekaphasil trh
LEFT JOIN tbdosen td ON (trh.peng2=td.nip)
LEFT JOiN tbmhs tm ON (trh.nim=tm.nim)
WHERE td.nip='$nip' ORDER BY trh.semester, tm.nim";
$txt="Sebagai Penguji 2";
break;
}
//echo $qq;
$db2->runQuery($qq);
echo $dosen['nmLengkap']." : ";
echo $txt."
";
echo 'Daftar Mahasiswa
';
echo '';
echo '
| NIM |
Nama Mahasiswa |
Judul |
Semester |
';
if($db2->dbRows()>0){
while($m=$db2->dbFetch()){
echo '
| '.$m['nim'].' |
'.$m['nmLengkap'].' |
'.$m['judul_final'].' |
'.$m['semester'].' |
';
}
}
echo '
';
}
}
?>