/sysfo/ujpembimbing.php
PHP | 242 lines | 217 code | 20 blank | 5 comment | 11 complexity | c9d78d9e9c2c84594b15d172528e9381 MD5 | raw file
- <?php
- $level=$_SESSION ['level'];
- $form=$_GET['syxec'];
- $unip = $_SESSION['unip'];
- echo "$level - $unip<br />";
-
- //deskripsi kajur
- $que_jur ="SELECT description FROM kajur WHERE id='$unip'";
- $jal_jur = mysql_query($que_jur);
- $hasil = mysql_fetch_array($jal_jur);
- echo"$hasil[0]<br>";
- $potong = substr($hasil[0],6,30);
-
- //kode kajur
- $per_id_jur = "SELECT kode FROM jurusan WHERE nama_indonesia='$potong'";
- $jalankan = mysql_query($per_id_jur);
- $hasil_id_jur = mysql_fetch_array($jalankan);
-
- //kode dosen
- $que_dosen ="SELECT kodejurusan FROM dosen WHERE id='$unip'";
- $jal_dosen = mysql_query($que_dosen);
- $hasil_dosen = mysql_fetch_array($jal_dosen);
-
- //kode mahasiswa
- $que_mhs ="SELECT KodeJurusan FROM mhsw WHERE NIM='$unip'";
- $jal_mhs = mysql_query($que_mhs);
- $hasil_mhs = mysql_fetch_array($jal_mhs);
-
- //kode karyawan jurusan
- $que_karjur ="SELECT Kode FROM karyawan_jurusan WHERE ID='$unip'";
- $jal_karjur = mysql_query($que_karjur);
- $hasil_karjur = mysql_fetch_array($jal_karjur);
-
- echo "<div align='center'><h1>Daftar Dosen Pembimbng Skripsi</h1></div>";
-
- switch($_GET['aksi']){
- default:
- if($level=='Kajur'){
- ?>
- <table border='1' width='50%' align='center'>
- <tr>
- <th align='center'>NIP</th>
- <th align='center'>Nama Dosen</th>
- </tr>
- <?php
- $sql=mysql_query("SELECT b.nim ,b.acc_pembimbing ,a.NIM from mhsw a , uj_peserta b where a.NIM=b.nim AND a.KodeJurusan='$hasil_id_jur[0]'");
- while($tampil = mysql_fetch_array($sql)){
- $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[acc_pembimbing]'");
- $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
- if($tampil['acc_pembimbing']!='0'){
- echo"
-
- <tr>
- <td>$tampil[acc_pembimbing]</td>
- <td>$tampil_bay_nama[Name]</td>
- </tr>
- ";
- }
- }
- ?>
- </table>
-
- <?php }
- else if($level=="Dosen"){
- ?>
- <table border='1' width='50%' align='center'>
- <tr>
- <th align='center'>NIP</th>
- <th align='center'>Nama Dosen</th>
- </tr>
- <?php
- $sql=mysql_query("SELECT b.nim ,b.acc_pembimbing ,a.NIM from mhsw a , uj_peserta b where a.NIM=b.nim AND a.KodeJurusan='$hasil_dosen[0]'");
- while($tampil = mysql_fetch_array($sql)){
- $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[acc_pembimbing]'");
- $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
- if($tampil['acc_pembimbing']!='0'){
- echo"
-
- <tr>
- <td>$tampil[acc_pembimbing]</td>
- <td>$tampil_bay_nama[Name]</td>
- </tr>
- ";
- }
- }
- ?>
- </table>
-
- <?php }
- else if($level=="Mahasiswa"){
- ?>
- <table border='1' width='50%' align='center'>
- <tr>
- <th align='center'>NIP</th>
- <th align='center'>Nama Dosen</th>
- </tr>
- <?php
- $sql=mysql_query("SELECT b.nim ,b.acc_pembimbing ,a.NIM from mhsw a , uj_peserta b where a.NIM=b.nim AND a.KodeJurusan='$hasil_mhs[0]'");
- while($tampil = mysql_fetch_array($sql)){
- $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[acc_pembimbing]'");
- $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
- if($tampil['acc_pembimbing']!='0'){
- echo"
-
- <tr>
- <td>$tampil[acc_pembimbing]</td>
- <td>$tampil_bay_nama[Name]</td>
- </tr>
- ";
- }
- }
- ?>
- </table>
-
- <?php }
- else if($level=="Karyawan Jurusan"){
- ?>
- <table border='1' width='50%' align='center'>
- <tr>
- <th align='center'>NIP</th>
- <th align='center'>Nama Dosen</th>
- </tr>
- <?php
- $sql=mysql_query("SELECT b.nim ,b.acc_pembimbing ,a.NIM from mhsw a , uj_peserta b where a.NIM=b.nim AND a.KodeJurusan='$hasil_karjur[0]'");
- while($tampil = mysql_fetch_array($sql)){
- $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[acc_pembimbing]'");
- $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
- if($tampil['acc_pembimbing']!='0'){
- echo"
-
- <tr>
- <td>$tampil[acc_pembimbing]</td>
- <td>$tampil_bay_nama[Name]</td>
- </tr>
- ";
- }
- }
- ?>
- </table>
- <?php }
- break;
- case 'tambah' : ?>
- <input type='button' onclick=window.location.href='?syxec=<?php echo $form ?>' value='kembali kedaftar' />
- <form name='form1' method='POST' action='?syxec=ujpembimbing&aksi=simpan'>
- <table align='center' width='40%'>
- <tr>
- <td><input type='hidden' name='idpembimbing'></td>
- </tr>
- <tr>
- <td>Nama Pembimimbing</td><td>:</td>
- <td>
- <select name='napem'>";
- <option selected='0' >--Pilih Pembimbing--</option>";
- <?php
- $query = mysql_query("SELECT * FROM dosen WHERE KodeJurusan='$hasil_id_jur[0]'");
- while($dosen = mysql_fetch_array($query)){
- echo("<option value=$dosen[ID]>$dosen[Name]</option>");
- }
- ?>
- </select>
- </td>
- </tr>
- <tr>
- <td colspan='3'><input type='submit' name='submit' value='tambah'><input type='reset' name='reset' value='ulangi'>
- </td>
- </tr>
- </table>
- </form>
- <?php break;
-
- case 'edit' : ?>
- <input type='button' onclick=window.location.href='?syxec=<?php echo $form ?>' value='kembali kedaftar' />
- <form name='form1' method='POST' action='?syxec=ujpembimbing&aksi=aksi_ubah'>
- <?php
- $id_ne=$_GET['id'];
- $que = mysql_query("SELECT * FROM uj_pembimbing WHERE id_pmbimbing='$id_ne'");
- $jupuk = mysql_fetch_array($que);
- ?>
- <table align='center' width='40%'>
- <tr>
- <?php echo"<td><input type='hidden' name='idpembimbing' value=$jupuk[0]></td>"; ?>
- </tr>
- <tr>
- <td>Nama Pembimbing</td><td>:</td>
- <td>
- <select name='napem'>";
- <?php
- $perintah = mysql_query("SELECT ID,Name FROM dosen WHERE ID='$jupuk[nip]'");
- $hasil = mysql_fetch_array($perintah);
- echo"<option value='$hasil[ID]' >$hasil[Name]</option>;"
- ?>
-
- <?php
- $query = mysql_query("SELECT * FROM dosen WHERE KodeJurusan='$hasil_id_jur[0]'");
- while($dosen = mysql_fetch_array($query)){
- echo("<option value=$dosen[ID]>$dosen[Name]</option>");
- }
- ?>
- </select>
- </td>
- </tr>
- <tr>
- <td colspan='3'><input type='submit' name='submit' value='ubah'><input type='reset' name='reset' value='ulangi'>
- </td>
- </tr>
- </table>
- </form>
- <?php
- break;
-
- case "simpan":
- $id = $_POST['idpembimbing'];
- $nip = $_POST['napem'];
- mysql_query("INSERT INTO uj_pembimbing VALUES('$id','$nip')") or die(mysql_error());
- echo"<center>
- <h2>Data Tersimpan</h2>
- <h2>Kembali Ke <a href='?syxec=ujpembimbing'><b>View Data</b></a></h2>
- </center>";
- break;
-
- case "aksi_ubah":
- $id = $_POST['idpembimbing'];
- $nip = $_POST['napem'];
- mysql_query("UPDATE uj_pembimbing SET nip='$nip' WHERE id_pmbimbing='$id'") or die(mysql_error());
- echo"<center>
- <h2>Data Diubah</h2>
- <h2>Kembali Ke <a href='?syxec=ujpembimbing'><b>View Data</b></a></h2>
- </center>";
- break;
- break;
-
- case "aksi_hapus":
- $id=$_GET['idpembimbing'];
- mysql_query("DELETE FROM uj_pembimbing WHERE id_pmbimbing='$id'") or die (mysql_error());
- mysql_query("DELETE FROM uj_peserta WHERE usulan_pembimbing=(SELECT nip FROM uj_pembimbing WHERE id_pmbimbing='$id') OR acc_pembimbing=(SELECT nip FROM uj_pembimbing WHERE id_pmbimbing='$id')") or die ("Gagal,mysql_error()");
- echo"<center>
- <h2>Data Terhapus</h2>
- <h2>Kembali Ke <a href='?syxec=ujpembimbing'><b>View Data</b></a></h2>
- </center>";
- break;
-
- } ?>