/sysfo/pkdosenpembimbing.php
PHP | 333 lines | 300 code | 28 blank | 5 comment | 7 complexity | c7bfa369621d450438be459e46c05dce MD5 | raw file
- <?php
- $a=$_SESSION ['level'];
- $b=$_GET['syxec'];
- $unip = $_SESSION['unip'];
- echo "id pengguna= $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);
- echo"kajur jurusan : $potong<br>";
-
- //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);
- echo"kode jurusan kajur : $hasil_id_jur[0]<br>";
-
- //kode dosen
- $que_dosen ="SELECT kodejurusan FROM dosen WHERE id='$unip'";
- $jal_dosen = mysql_query($que_dosen);
- $hasil_dosen = mysql_fetch_array($jal_dosen);
- echo"kode jurusan dosen : $hasil_dosen[0]<br>";
-
- //kode mahasiswa
- $que_mhs ="SELECT KodeJurusan FROM mhsw WHERE NIM='$unip'";
- $jal_mhs = mysql_query($que_mhs);
- $hasil_mhs = mysql_fetch_array($jal_mhs);
- echo"kode jurusan mahasiswa : $hasil_mhs[0]<br>";
-
- //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"kode jurusan karyawan jurusan : $hasil_karjur[0]<br>";
-
-
- switch($_GET['aksi']){
- default:
- if($a=='Kajur'){
- ?>
-
- <html>
- <body>
- <center><h1>Data Dosen Pembimbing PKL</h1></center>
- <form method='post' name='formdatapembimbing' action=''>
- <table border='5' align='center'>
- <tr>
- <td>
- <table border='1' align='center'>
- <tr>
- <td align='center'>ID</td>
- <td align='center'>NIP</td>
- <td align='center'>Nama Dosen</td>
- <td colspan='2' align='center'>Aksi</td>
- </tr>
- <?php
- $sql=mysql_query("select b.id_dsn_pmbimbing ,a.ID as nip , a.Name from dosen a , pkl_dsn_pmbimbing b where a.ID=b.nip 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[nip]'");
- $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
- echo "<tr>
- <td align='center'>$tampil[id_dsn_pmbimbing]</td>
- <td>$tampil[nip]</td>
- <td>$tampil_bay_nama[Name]</td>
- <td width='120' align='center'><a href='?syxec=$b&aksi=ubah&id=$tampil[id_dsn_pmbimbing]'>Ubah</a> | <a href='?syxec=$b&aksi=aksi_hapus&idpembimbing=$tampil[id_dsn_pmbimbing]' onClick=\"return confirm('Apakah Hapus?')\"/>Hapus</a></td>
- </tr>";
- }
- ?>
- </table>
- </td>
- </tr>
- <tr>
- <td align='center'>
- <input type='button' name='tambah' value='Tambah Data' onclick=window.location.href='?syxec=<?php echo $b ?>&aksi=tambah'>
- </td>
- </tr>
- </table>
- </form>
- </body>
- </html>
-
- <?php }
- else if($a=="Dosen"){
- ?>
-
- <html>
- <body>
- <center><h1>Data Dosen Pembimbing PKL</h1></center>
- <form method='post' name='formdatapembimbing' action=''>
- <table border='5' align='center'>
- <tr>
- <td>
- <table border='1' align='center'>
- <tr>
- <td>ID</td>
- <td>NIP</td>
- <td>Nama Dosen</td>
- </tr>
- <?php
- $sql=mysql_query("select b.id_dsn_pmbimbing ,a.ID as nip , a.Name from dosen a , pkl_dsn_pmbimbing b where a.ID=b.nip AND a.KodeJurusan='$hasil_dosen[0]'");
- while($tampil = mysql_fetch_array($sql)){
- $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[nip]'");
- $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
- echo "<tr>
- <td align='center'>$tampil[id_dsn_pmbimbing]</td>
- <td>$tampil[nip]</td>
- <td>$tampil_bay_nama[Name]</td>
- </tr>";
- }
- ?>
- </table>
- </td>
- </tr>
- </table>
- </form>
- </body>
- </html>
-
- <?php }
- else if($a=="Mahasiswa"){
- ?>
-
- <html>
- <body>
- <center><h1>Data Dosen Pembimbing PKL</h1></center>
- <form method='post' name='formdatapembimbing' action=''>
- <table border='5' align='center'>
- <tr>
- <td>
- <table border='1' align='center'>
- <tr>
- <td>ID</td>
- <td>NIP</td>
- <td>Nama Dosen</td>
- </tr>
- <?php
- $sql=mysql_query("select b.id_dsn_pmbimbing ,a.ID as nip , a.Name from dosen a , pkl_dsn_pmbimbing b where a.ID=b.nip AND a.KodeJurusan='$hasil_mhs[0]'");
- while($tampil = mysql_fetch_array($sql)){
- $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[nip]'");
- $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
- echo "<tr>
- <td align='center'>$tampil[id_dsn_pmbimbing]</td>
- <td>$tampil[nip]</td>
- <td>$tampil_bay_nama[Name]</td>
- </tr>";
- }
- ?>
- </table>
- </td>
- </tr>
- </table>
- </form>
- </body>
- </html>
-
- <?php }
- else if($a=="Karyawan Jurusan"){
- ?>
-
- <html>
- <body>
- <center><h1>Data Dosen Pembimbing PKL</h1></center>
- <form method='post' name='formdatapembimbing' action=''>
- <table border='5' align='center'>
- <tr>
- <td>
- <table border='1' align='center'>
- <tr>
- <td>ID</td>
- <td>NIP</td>
- <td>Nama Dosen</td>
- </tr>
- <?php
- $sql=mysql_query("select b.id_dsn_pmbimbing ,a.ID as nip , a.Name from dosen a , pkl_dsn_pmbimbing b where a.ID=b.nip AND a.KodeJurusan='$hasil_karjur[0]'");
- while($tampil = mysql_fetch_array($sql)){
- $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[nip]'");
- $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
- echo "<tr>
- <td align='center'>$tampil[id_dsn_pmbimbing]</td>
- <td>$tampil[nip]</td>
- <td>$tampil_bay_nama[Name]</td>
- </tr>";
- }
- ?>
- </table>
- </td>
- </tr>
- </table>
- </form>
- </body>
- </html>
-
- <?php }
- break;
-
- case 'tambah':?>
-
- <html>
- <body>
- <center><h1>Tambah Dosen Pembimbing PKL</h1></center>
- <form method='post' name='formpembimbing' action='?syxec=pkdosenpembimbing&aksi=simpan'>
- <table border='5' align='center'>
- <tr>
- <td>
- <table align='center'>
- <tr>
- <td width='300'><input type='hidden' name='idpembimbing' size='30' value=''></td>
- </tr>
- <tr>
- <td width='200'>Nama Pembimbing</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='2' align='center'>
- <input type='submit' name='submit' value='Simpan' />
- <input type='reset' name='reset' value='Bersihkan' />
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- </form>
-
- </body>
- </html>
-
- <?php
- break;
-
- case 'ubah':?>
-
- <html>
- <body>
- <center><h1>Ubah Dosen Pembimbing PKL</h1></center>
- <form method='post' name='formpembimbing' action='?syxec=pkdosenpembimbing&aksi=aksi_ubah'>
- <?php
- $id_ne=$_GET['id'];
- $que = mysql_query("SELECT * FROM pkl_dsn_pmbimbing WHERE id_dsn_pmbimbing='$id_ne'");
- $jupuk = mysql_fetch_array($que);
- ?>
- <table border='5' align='center'>
- <tr>
- <td>
- <table align='center'>
- <tr>
- <?php
- echo"<td width='300'><input type='hidden' name='idpembimbing' size='30' value=$jupuk[0]></td>";
- ?>
-
- </tr>
- <tr>
- <td width='200'>Nama Pembimbing</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='2' align='center'>
- <input type='submit' name='submit' value='UbAh' />
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- </form>
-
- </body>
- </html>
-
- <?php
- break;
-
- case "simpan":
- $id = $_POST['idpembimbing'];
- $nip = $_POST['napem'];
- mysql_query("INSERT INTO pkl_dsn_pmbimbing VALUES('$id','$nip')") or die(mysql_error());
- echo"<center>
- <h2>Data Tersimpan</h2>
- <h2>Kembali Ke <a href='?syxec=pkdosenpembimbing'><b>View Data</b></a></h2>
- </center>";
- break;
-
- case "aksi_ubah":
- $id = $_POST['idpembimbing'];
- $nip = $_POST['napem'];
- mysql_query("UPDATE pkl_dsn_pmbimbing SET nip='$nip' WHERE id_dsn_pmbimbing='$id'");
- echo"<center>
- <h2>Data Diubah</h2>
- <h2>Kembali Ke <a href='?syxec=pkdosenpembimbing'><b>View Data</b></a></h2>
- </center>";
- break;
- break;
-
- case "aksi_hapus":
- $a=$_GET['idpembimbing'];
- $sql=mysql_query("DELETE FROM pkl_dsn_pmbimbing WHERE id_dsn_pmbimbing='$a'") or die ("Gagal,mysql_error()");
- mysql_query("DELETE FROM pkl_kelompok WHERE dsn_pmbimbing='$a'");
- mysql_query("DELETE FROM pkl_penilaian WHERE pembimbing='$a'");
- echo"<center>
- <h2>Data Terhapus</h2>
- <h2>Kembali Ke <a href='?syxec=pkdosenpembimbing'><b>View Data</b></a></h2>
- </center>";
- break;
- }
- ?>