PageRenderTime 65ms CodeModel.GetById 38ms RepoModel.GetById 0ms app.codeStats 0ms

/sysfo/pkdosenpembimbing.php

https://bitbucket.org/justmyfreak/sisfokampus
PHP | 333 lines | 300 code | 28 blank | 5 comment | 7 complexity | c7bfa369621d450438be459e46c05dce MD5 | raw file
  1. <?php
  2. $a=$_SESSION ['level'];
  3. $b=$_GET['syxec'];
  4. $unip = $_SESSION['unip'];
  5. echo "id pengguna= $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. echo"kajur jurusan : $potong<br>";
  13. //kode kajur
  14. $per_id_jur = "SELECT kode FROM jurusan WHERE nama_indonesia='$potong'";
  15. $jalankan = mysql_query($per_id_jur);
  16. $hasil_id_jur = mysql_fetch_array($jalankan);
  17. echo"kode jurusan kajur : $hasil_id_jur[0]<br>";
  18. //kode dosen
  19. $que_dosen ="SELECT kodejurusan FROM dosen WHERE id='$unip'";
  20. $jal_dosen = mysql_query($que_dosen);
  21. $hasil_dosen = mysql_fetch_array($jal_dosen);
  22. echo"kode jurusan dosen : $hasil_dosen[0]<br>";
  23. //kode mahasiswa
  24. $que_mhs ="SELECT KodeJurusan FROM mhsw WHERE NIM='$unip'";
  25. $jal_mhs = mysql_query($que_mhs);
  26. $hasil_mhs = mysql_fetch_array($jal_mhs);
  27. echo"kode jurusan mahasiswa : $hasil_mhs[0]<br>";
  28. //kode karyawan jurusan
  29. $que_karjur ="SELECT Kode FROM karyawan_jurusan WHERE ID='$unip'";
  30. $jal_karjur = mysql_query($que_karjur);
  31. $hasil_karjur = mysql_fetch_array($jal_karjur);
  32. echo"kode jurusan karyawan jurusan : $hasil_karjur[0]<br>";
  33. switch($_GET['aksi']){
  34. default:
  35. if($a=='Kajur'){
  36. ?>
  37. <html>
  38. <body>
  39. <center><h1>Data Dosen Pembimbing PKL</h1></center>
  40. <form method='post' name='formdatapembimbing' action=''>
  41. <table border='5' align='center'>
  42. <tr>
  43. <td>
  44. <table border='1' align='center'>
  45. <tr>
  46. <td align='center'>ID</td>
  47. <td align='center'>NIP</td>
  48. <td align='center'>Nama Dosen</td>
  49. <td colspan='2' align='center'>Aksi</td>
  50. </tr>
  51. <?php
  52. $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]'");
  53. while($tampil = mysql_fetch_array($sql)){
  54. $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[nip]'");
  55. $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
  56. echo "<tr>
  57. <td align='center'>$tampil[id_dsn_pmbimbing]</td>
  58. <td>$tampil[nip]</td>
  59. <td>$tampil_bay_nama[Name]</td>
  60. <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>
  61. </tr>";
  62. }
  63. ?>
  64. </table>
  65. </td>
  66. </tr>
  67. <tr>
  68. <td align='center'>
  69. <input type='button' name='tambah' value='Tambah Data' onclick=window.location.href='?syxec=<?php echo $b ?>&aksi=tambah'>
  70. </td>
  71. </tr>
  72. </table>
  73. </form>
  74. </body>
  75. </html>
  76. <?php }
  77. else if($a=="Dosen"){
  78. ?>
  79. <html>
  80. <body>
  81. <center><h1>Data Dosen Pembimbing PKL</h1></center>
  82. <form method='post' name='formdatapembimbing' action=''>
  83. <table border='5' align='center'>
  84. <tr>
  85. <td>
  86. <table border='1' align='center'>
  87. <tr>
  88. <td>ID</td>
  89. <td>NIP</td>
  90. <td>Nama Dosen</td>
  91. </tr>
  92. <?php
  93. $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]'");
  94. while($tampil = mysql_fetch_array($sql)){
  95. $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[nip]'");
  96. $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
  97. echo "<tr>
  98. <td align='center'>$tampil[id_dsn_pmbimbing]</td>
  99. <td>$tampil[nip]</td>
  100. <td>$tampil_bay_nama[Name]</td>
  101. </tr>";
  102. }
  103. ?>
  104. </table>
  105. </td>
  106. </tr>
  107. </table>
  108. </form>
  109. </body>
  110. </html>
  111. <?php }
  112. else if($a=="Mahasiswa"){
  113. ?>
  114. <html>
  115. <body>
  116. <center><h1>Data Dosen Pembimbing PKL</h1></center>
  117. <form method='post' name='formdatapembimbing' action=''>
  118. <table border='5' align='center'>
  119. <tr>
  120. <td>
  121. <table border='1' align='center'>
  122. <tr>
  123. <td>ID</td>
  124. <td>NIP</td>
  125. <td>Nama Dosen</td>
  126. </tr>
  127. <?php
  128. $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]'");
  129. while($tampil = mysql_fetch_array($sql)){
  130. $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[nip]'");
  131. $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
  132. echo "<tr>
  133. <td align='center'>$tampil[id_dsn_pmbimbing]</td>
  134. <td>$tampil[nip]</td>
  135. <td>$tampil_bay_nama[Name]</td>
  136. </tr>";
  137. }
  138. ?>
  139. </table>
  140. </td>
  141. </tr>
  142. </table>
  143. </form>
  144. </body>
  145. </html>
  146. <?php }
  147. else if($a=="Karyawan Jurusan"){
  148. ?>
  149. <html>
  150. <body>
  151. <center><h1>Data Dosen Pembimbing PKL</h1></center>
  152. <form method='post' name='formdatapembimbing' action=''>
  153. <table border='5' align='center'>
  154. <tr>
  155. <td>
  156. <table border='1' align='center'>
  157. <tr>
  158. <td>ID</td>
  159. <td>NIP</td>
  160. <td>Nama Dosen</td>
  161. </tr>
  162. <?php
  163. $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]'");
  164. while($tampil = mysql_fetch_array($sql)){
  165. $sql_bay_nama=mysql_query("SELECT Name FROM dosen WHERE ID='$tampil[nip]'");
  166. $tampil_bay_nama=mysql_fetch_array($sql_bay_nama);
  167. echo "<tr>
  168. <td align='center'>$tampil[id_dsn_pmbimbing]</td>
  169. <td>$tampil[nip]</td>
  170. <td>$tampil_bay_nama[Name]</td>
  171. </tr>";
  172. }
  173. ?>
  174. </table>
  175. </td>
  176. </tr>
  177. </table>
  178. </form>
  179. </body>
  180. </html>
  181. <?php }
  182. break;
  183. case 'tambah':?>
  184. <html>
  185. <body>
  186. <center><h1>Tambah Dosen Pembimbing PKL</h1></center>
  187. <form method='post' name='formpembimbing' action='?syxec=pkdosenpembimbing&aksi=simpan'>
  188. <table border='5' align='center'>
  189. <tr>
  190. <td>
  191. <table align='center'>
  192. <tr>
  193. <td width='300'><input type='hidden' name='idpembimbing' size='30' value=''></td>
  194. </tr>
  195. <tr>
  196. <td width='200'>Nama Pembimbing</td>
  197. <td>
  198. <select name='napem'>";
  199. <option selected='0' >--Pilih Pembimbing--</option>";
  200. <?php
  201. $query = mysql_query("SELECT * FROM dosen WHERE KodeJurusan='$hasil_id_jur[0]'");
  202. while($dosen = mysql_fetch_array($query)){
  203. echo("<option value=$dosen[ID]>$dosen[Name]</option>");
  204. }
  205. ?>
  206. </select>
  207. </td>
  208. </tr>
  209. <tr>
  210. <td colspan='2' align='center'>
  211. <input type='submit' name='submit' value='Simpan' />
  212. <input type='reset' name='reset' value='Bersihkan' />
  213. </td>
  214. </tr>
  215. </table>
  216. </td>
  217. </tr>
  218. </table>
  219. </form>
  220. </body>
  221. </html>
  222. <?php
  223. break;
  224. case 'ubah':?>
  225. <html>
  226. <body>
  227. <center><h1>Ubah Dosen Pembimbing PKL</h1></center>
  228. <form method='post' name='formpembimbing' action='?syxec=pkdosenpembimbing&aksi=aksi_ubah'>
  229. <?php
  230. $id_ne=$_GET['id'];
  231. $que = mysql_query("SELECT * FROM pkl_dsn_pmbimbing WHERE id_dsn_pmbimbing='$id_ne'");
  232. $jupuk = mysql_fetch_array($que);
  233. ?>
  234. <table border='5' align='center'>
  235. <tr>
  236. <td>
  237. <table align='center'>
  238. <tr>
  239. <?php
  240. echo"<td width='300'><input type='hidden' name='idpembimbing' size='30' value=$jupuk[0]></td>";
  241. ?>
  242. </tr>
  243. <tr>
  244. <td width='200'>Nama Pembimbing</td>
  245. <td>
  246. <select name='napem'>";
  247. <?php
  248. $perintah = mysql_query("SELECT ID,Name FROM dosen WHERE ID='$jupuk[nip]'");
  249. $hasil = mysql_fetch_array($perintah);
  250. echo"<option value='$hasil[ID]' >$hasil[Name]</option>;"
  251. ?>
  252. <?php
  253. $query = mysql_query("SELECT * FROM dosen WHERE KodeJurusan='$hasil_id_jur[0]'");
  254. while($dosen = mysql_fetch_array($query)){
  255. echo("<option value=$dosen[ID]>$dosen[Name]</option>");
  256. }
  257. ?>
  258. </select>
  259. </td>
  260. </tr>
  261. <tr>
  262. <td colspan='2' align='center'>
  263. <input type='submit' name='submit' value='UbAh' />
  264. </td>
  265. </tr>
  266. </table>
  267. </td>
  268. </tr>
  269. </table>
  270. </form>
  271. </body>
  272. </html>
  273. <?php
  274. break;
  275. case "simpan":
  276. $id = $_POST['idpembimbing'];
  277. $nip = $_POST['napem'];
  278. mysql_query("INSERT INTO pkl_dsn_pmbimbing VALUES('$id','$nip')") or die(mysql_error());
  279. echo"<center>
  280. <h2>Data Tersimpan</h2>
  281. <h2>Kembali Ke <a href='?syxec=pkdosenpembimbing'><b>View Data</b></a></h2>
  282. </center>";
  283. break;
  284. case "aksi_ubah":
  285. $id = $_POST['idpembimbing'];
  286. $nip = $_POST['napem'];
  287. mysql_query("UPDATE pkl_dsn_pmbimbing SET nip='$nip' WHERE id_dsn_pmbimbing='$id'");
  288. echo"<center>
  289. <h2>Data Diubah</h2>
  290. <h2>Kembali Ke <a href='?syxec=pkdosenpembimbing'><b>View Data</b></a></h2>
  291. </center>";
  292. break;
  293. break;
  294. case "aksi_hapus":
  295. $a=$_GET['idpembimbing'];
  296. $sql=mysql_query("DELETE FROM pkl_dsn_pmbimbing WHERE id_dsn_pmbimbing='$a'") or die ("Gagal,mysql_error()");
  297. mysql_query("DELETE FROM pkl_kelompok WHERE dsn_pmbimbing='$a'");
  298. mysql_query("DELETE FROM pkl_penilaian WHERE pembimbing='$a'");
  299. echo"<center>
  300. <h2>Data Terhapus</h2>
  301. <h2>Kembali Ke <a href='?syxec=pkdosenpembimbing'><b>View Data</b></a></h2>
  302. </center>";
  303. break;
  304. }
  305. ?>