PageRenderTime 57ms CodeModel.GetById 30ms RepoModel.GetById 0ms app.codeStats 0ms

/sysfo/ujpembimbing.php

https://bitbucket.org/justmyfreak/sisfokampus
PHP | 242 lines | 217 code | 20 blank | 5 comment | 11 complexity | c9d78d9e9c2c84594b15d172528e9381 MD5 | raw file
  1. <?php
  2. $level=$_SESSION ['level'];
  3. $form=$_GET['syxec'];
  4. $unip = $_SESSION['unip'];
  5. echo "$level - $unip<br />";
  6. //deskripsi kajur
  7. $que_jur ="SELECT description FROM kajur WHERE id='$unip'";
  8. $jal_jur = mysql_query($que_jur);
  9. $hasil = mysql_fetch_array($jal_jur);
  10. echo"$hasil[0]<br>";
  11. $potong = substr($hasil[0],6,30);
  12. //kode kajur
  13. $per_id_jur = "SELECT kode FROM jurusan WHERE nama_indonesia='$potong'";
  14. $jalankan = mysql_query($per_id_jur);
  15. $hasil_id_jur = mysql_fetch_array($jalankan);
  16. //kode dosen
  17. $que_dosen ="SELECT kodejurusan FROM dosen WHERE id='$unip'";
  18. $jal_dosen = mysql_query($que_dosen);
  19. $hasil_dosen = mysql_fetch_array($jal_dosen);
  20. //kode mahasiswa
  21. $que_mhs ="SELECT KodeJurusan FROM mhsw WHERE NIM='$unip'";
  22. $jal_mhs = mysql_query($que_mhs);
  23. $hasil_mhs = mysql_fetch_array($jal_mhs);
  24. //kode karyawan jurusan
  25. $que_karjur ="SELECT Kode FROM karyawan_jurusan WHERE ID='$unip'";
  26. $jal_karjur = mysql_query($que_karjur);
  27. $hasil_karjur = mysql_fetch_array($jal_karjur);
  28. echo "<div align='center'><h1>Daftar Dosen Pembimbng Skripsi</h1></div>";
  29. switch($_GET['aksi']){
  30. default:
  31. if($level=='Kajur'){
  32. ?>
  33. <table border='1' width='50%' align='center'>
  34. <tr>
  35. <th align='center'>NIP</th>
  36. <th align='center'>Nama Dosen</th>
  37. </tr>
  38. <?php
  39. $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]'");
  40. while($tampil = mysql_fetch_array($sql)){
  41. $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[acc_pembimbing]'");
  42. $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
  43. if($tampil['acc_pembimbing']!='0'){
  44. echo"
  45. <tr>
  46. <td>$tampil[acc_pembimbing]</td>
  47. <td>$tampil_bay_nama[Name]</td>
  48. </tr>
  49. ";
  50. }
  51. }
  52. ?>
  53. </table>
  54. <?php }
  55. else if($level=="Dosen"){
  56. ?>
  57. <table border='1' width='50%' align='center'>
  58. <tr>
  59. <th align='center'>NIP</th>
  60. <th align='center'>Nama Dosen</th>
  61. </tr>
  62. <?php
  63. $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]'");
  64. while($tampil = mysql_fetch_array($sql)){
  65. $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[acc_pembimbing]'");
  66. $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
  67. if($tampil['acc_pembimbing']!='0'){
  68. echo"
  69. <tr>
  70. <td>$tampil[acc_pembimbing]</td>
  71. <td>$tampil_bay_nama[Name]</td>
  72. </tr>
  73. ";
  74. }
  75. }
  76. ?>
  77. </table>
  78. <?php }
  79. else if($level=="Mahasiswa"){
  80. ?>
  81. <table border='1' width='50%' align='center'>
  82. <tr>
  83. <th align='center'>NIP</th>
  84. <th align='center'>Nama Dosen</th>
  85. </tr>
  86. <?php
  87. $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]'");
  88. while($tampil = mysql_fetch_array($sql)){
  89. $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[acc_pembimbing]'");
  90. $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
  91. if($tampil['acc_pembimbing']!='0'){
  92. echo"
  93. <tr>
  94. <td>$tampil[acc_pembimbing]</td>
  95. <td>$tampil_bay_nama[Name]</td>
  96. </tr>
  97. ";
  98. }
  99. }
  100. ?>
  101. </table>
  102. <?php }
  103. else if($level=="Karyawan Jurusan"){
  104. ?>
  105. <table border='1' width='50%' align='center'>
  106. <tr>
  107. <th align='center'>NIP</th>
  108. <th align='center'>Nama Dosen</th>
  109. </tr>
  110. <?php
  111. $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]'");
  112. while($tampil = mysql_fetch_array($sql)){
  113. $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[acc_pembimbing]'");
  114. $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
  115. if($tampil['acc_pembimbing']!='0'){
  116. echo"
  117. <tr>
  118. <td>$tampil[acc_pembimbing]</td>
  119. <td>$tampil_bay_nama[Name]</td>
  120. </tr>
  121. ";
  122. }
  123. }
  124. ?>
  125. </table>
  126. <?php }
  127. break;
  128. case 'tambah' : ?>
  129. <input type='button' onclick=window.location.href='?syxec=<?php echo $form ?>' value='kembali kedaftar' />
  130. <form name='form1' method='POST' action='?syxec=ujpembimbing&aksi=simpan'>
  131. <table align='center' width='40%'>
  132. <tr>
  133. <td><input type='hidden' name='idpembimbing'></td>
  134. </tr>
  135. <tr>
  136. <td>Nama Pembimimbing</td><td>:</td>
  137. <td>
  138. <select name='napem'>";
  139. <option selected='0' >--Pilih Pembimbing--</option>";
  140. <?php
  141. $query = mysql_query("SELECT * FROM dosen WHERE KodeJurusan='$hasil_id_jur[0]'");
  142. while($dosen = mysql_fetch_array($query)){
  143. echo("<option value=$dosen[ID]>$dosen[Name]</option>");
  144. }
  145. ?>
  146. </select>
  147. </td>
  148. </tr>
  149. <tr>
  150. <td colspan='3'><input type='submit' name='submit' value='tambah'><input type='reset' name='reset' value='ulangi'>
  151. </td>
  152. </tr>
  153. </table>
  154. </form>
  155. <?php break;
  156. case 'edit' : ?>
  157. <input type='button' onclick=window.location.href='?syxec=<?php echo $form ?>' value='kembali kedaftar' />
  158. <form name='form1' method='POST' action='?syxec=ujpembimbing&aksi=aksi_ubah'>
  159. <?php
  160. $id_ne=$_GET['id'];
  161. $que = mysql_query("SELECT * FROM uj_pembimbing WHERE id_pmbimbing='$id_ne'");
  162. $jupuk = mysql_fetch_array($que);
  163. ?>
  164. <table align='center' width='40%'>
  165. <tr>
  166. <?php echo"<td><input type='hidden' name='idpembimbing' value=$jupuk[0]></td>"; ?>
  167. </tr>
  168. <tr>
  169. <td>Nama Pembimbing</td><td>:</td>
  170. <td>
  171. <select name='napem'>";
  172. <?php
  173. $perintah = mysql_query("SELECT ID,Name FROM dosen WHERE ID='$jupuk[nip]'");
  174. $hasil = mysql_fetch_array($perintah);
  175. echo"<option value='$hasil[ID]' >$hasil[Name]</option>;"
  176. ?>
  177. <?php
  178. $query = mysql_query("SELECT * FROM dosen WHERE KodeJurusan='$hasil_id_jur[0]'");
  179. while($dosen = mysql_fetch_array($query)){
  180. echo("<option value=$dosen[ID]>$dosen[Name]</option>");
  181. }
  182. ?>
  183. </select>
  184. </td>
  185. </tr>
  186. <tr>
  187. <td colspan='3'><input type='submit' name='submit' value='ubah'><input type='reset' name='reset' value='ulangi'>
  188. </td>
  189. </tr>
  190. </table>
  191. </form>
  192. <?php
  193. break;
  194. case "simpan":
  195. $id = $_POST['idpembimbing'];
  196. $nip = $_POST['napem'];
  197. mysql_query("INSERT INTO uj_pembimbing VALUES('$id','$nip')") or die(mysql_error());
  198. echo"<center>
  199. <h2>Data Tersimpan</h2>
  200. <h2>Kembali Ke <a href='?syxec=ujpembimbing'><b>View Data</b></a></h2>
  201. </center>";
  202. break;
  203. case "aksi_ubah":
  204. $id = $_POST['idpembimbing'];
  205. $nip = $_POST['napem'];
  206. mysql_query("UPDATE uj_pembimbing SET nip='$nip' WHERE id_pmbimbing='$id'") or die(mysql_error());
  207. echo"<center>
  208. <h2>Data Diubah</h2>
  209. <h2>Kembali Ke <a href='?syxec=ujpembimbing'><b>View Data</b></a></h2>
  210. </center>";
  211. break;
  212. break;
  213. case "aksi_hapus":
  214. $id=$_GET['idpembimbing'];
  215. mysql_query("DELETE FROM uj_pembimbing WHERE id_pmbimbing='$id'") or die (mysql_error());
  216. 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()");
  217. echo"<center>
  218. <h2>Data Terhapus</h2>
  219. <h2>Kembali Ke <a href='?syxec=ujpembimbing'><b>View Data</b></a></h2>
  220. </center>";
  221. break;
  222. } ?>