PageRenderTime 53ms CodeModel.GetById 27ms RepoModel.GetById 0ms app.codeStats 0ms

/sysfo/skjdwlujiansk.php

https://bitbucket.org/justmyfreak/sisfokampus
PHP | 663 lines | 621 code | 35 blank | 7 comment | 37 complexity | 5b92532fafdc365b2ca4ac6e37216c6e MD5 | raw file
  1. <?php
  2. $a=$_SESSION['level'];
  3. $b=$_GET['syxec'];
  4. $c=$_SESSION ['uid'];
  5. echo"level = $a <br>";
  6. //deskripsi kajur
  7. $que_jur ="SELECT description FROM kajur WHERE id='$c'";
  8. $jal_jur = mysql_query($que_jur);
  9. $hasil = mysql_fetch_array($jal_jur);
  10. $potong = substr($hasil[0],6,30);
  11. //kode jurusan
  12. $per_id_jur = "SELECT kode FROM jurusan WHERE nama_indonesia='$potong'";
  13. $jalankan = mysql_query($per_id_jur);
  14. $hasil_id_jur = mysql_fetch_array($jalankan);
  15. //kode dosen
  16. $que_dosen ="SELECT kodejurusan FROM dosen WHERE id='$c'";
  17. $jal_dosen = mysql_query($que_dosen);
  18. $hasil_dosen = mysql_fetch_array($jal_dosen);
  19. //kode mahasiswa
  20. $que_mhs ="SELECT kodejurusan FROM mhsw WHERE id='$c'";
  21. $jal_mhs = mysql_query($que_mhs);
  22. $hasil_mhs = mysql_fetch_array($jal_mhs);
  23. //nim mhs
  24. $per_sel_mah = "SELECT nim FROM mhsw WHERE id='$c'";
  25. $jalan_sel_mah = mysql_query($per_sel_mah);
  26. $hasil_sel_mah = mysql_fetch_array($jalan_sel_mah);
  27. //kode karyawan jurusan
  28. $que_karjur ="SELECT Kode FROM karyawan_jurusan WHERE ID='$c'";
  29. $jal_karjur = mysql_query($que_karjur);
  30. $hasil_karjur = mysql_fetch_array($jal_karjur);
  31. echo"kode jurusan karyawan jurusan : $hasil_karjur[0]<br>";
  32. switch($_GET['aksi']){
  33. default:
  34. if($a=='Kajur'){
  35. echo "
  36. <form method='post' name='formdatajadwal' action=''>
  37. <table border='1' align='center'>
  38. <tr>
  39. <td colspan='13' align='left'>
  40. <input type='button' onclick=window.location.href='?syxec=$b&aksi=tambah' name='tambah' value='Tambah'/>
  41. </td>
  42. </tr>
  43. <tr>
  44. <th>ID</th>
  45. <th>NIM</th>
  46. <th>Nama</th>
  47. <th>Judul Skripsi</th>
  48. <th>Hari</th>
  49. <th>Tanggal</th>
  50. <th>Jam</th>
  51. <th>Ruang</th>
  52. <th>Dosen Penguji 1</th>
  53. <th>Dosen Penguji 2</th>
  54. <th>Dosen Penguji 3</th>
  55. <th>Dosen Penguji 4</th>
  56. <th>Aksi</th>
  57. </tr>
  58. ";
  59. $perintah = "SELECT d.id_jadwal, d.nim, a.Name, b.judul, d.hari, d.tanggal, d.jam, c.Nama, (SELECT Name FROM dosen WHERE ID=d.penguji1) as Penguji1, (SELECT Name FROM dosen WHERE ID=d.penguji2) as Penguji2, (SELECT Name FROM dosen WHERE ID=d.penguji3) as Penguji3, (SELECT Name FROM dosen WHERE ID=d.penguji4) as Penguji4
  60. FROM mhsw a, skr_peserta b, ruang c , skr_penjadwalan d
  61. WHERE a.NIM=d.nim AND b.nim=d.nim AND c.Kode=d.id_ruang AND a.KodeJurusan='$hasil_id_jur[0]'
  62. ORDER BY d.id_jadwal ASC";
  63. $jalan = mysql_query($perintah);
  64. while($hasil=mysql_fetch_array($jalan)){
  65. echo"
  66. <tr>
  67. <td>$hasil[0]</td>
  68. <td>$hasil[1]</td>
  69. <td>$hasil[2]</td>
  70. <td>$hasil[3]</td>
  71. <td>$hasil[4]</td>
  72. <td>$hasil[5]</td>
  73. <td>$hasil[6]</td>
  74. <td>$hasil[7]</td>
  75. <td>$hasil[8]</td>
  76. <td>$hasil[9]</td>
  77. <td>$hasil[10]</td>
  78. <td>$hasil[11]</td>
  79. <td><a href='?syxec=$b&aksi=ubah&id=$hasil[0]'>Edit</a> | <a href='?syxec=$b&aksi=hapus&idxx=$hasil[0]'>Hapus</a></td>
  80. <tr>
  81. ";
  82. }
  83. echo"
  84. </table>
  85. </form>
  86. ";
  87. }
  88. else if($a=='Dosen'){
  89. echo "
  90. <form method='post' name='formdatajadwal' action=''>
  91. <table border='1' align='center'>
  92. <tr>
  93. <th>ID</th>
  94. <th>NIM</th>
  95. <th>Nama</th>
  96. <th>Judul Skripsi</th>
  97. <th>Hari</th>
  98. <th>Tanggal</th>
  99. <th>Jam</th>
  100. <th>Ruang</th>
  101. <th>Dosen Penguji 1</th>
  102. <th>Dosen Penguji 2</th>
  103. <th>Dosen Penguji 3</th>
  104. <th>Dosen Penguji 4</th>
  105. </tr>
  106. ";
  107. $perintah = "SELECT d.id_jadwal, d.nim, a.Name, b.judul, d.hari, d.tanggal, d.jam, c.Nama, (SELECT Name FROM dosen WHERE ID=d.penguji1) as Penguji1, (SELECT Name FROM dosen WHERE ID=d.penguji2) as Penguji2, (SELECT Name FROM dosen WHERE ID=d.penguji3) as Penguji3, (SELECT Name FROM dosen WHERE ID=d.penguji4) as Penguji4
  108. FROM mhsw a, skr_peserta b, ruang c , skr_penjadwalan d
  109. WHERE a.NIM=d.nim AND b.nim=d.nim AND c.Kode=d.id_ruang AND a.KodeJurusan='$hasil_dosen[0]'
  110. ORDER BY d.id_jadwal ASC";
  111. $jalan = mysql_query($perintah);
  112. while($hasil=mysql_fetch_array($jalan)){
  113. echo"
  114. <tr>
  115. <td>$hasil[0]</td>
  116. <td>$hasil[1]</td>
  117. <td>$hasil[2]</td>
  118. <td>$hasil[3]</td>
  119. <td>$hasil[4]</td>
  120. <td>$hasil[5]</td>
  121. <td>$hasil[6]</td>
  122. <td>$hasil[7]</td>
  123. <td>$hasil[8]</td>
  124. <td>$hasil[9]</td>
  125. <td>$hasil[10]</td>
  126. <td>$hasil[11]</td>
  127. <tr>
  128. ";
  129. }
  130. echo"
  131. </table>
  132. </form>
  133. ";
  134. }
  135. else if($a=='Mahasiswa'){
  136. echo "
  137. <form method='post' name='formdatajadwal' action=''>
  138. <table border='1' align='center'>
  139. <tr>
  140. <th>ID</th>
  141. <th>NIM</th>
  142. <th>Nama</th>
  143. <th>Judul Skripsi</th>
  144. <th>Hari</th>
  145. <th>Tanggal</th>
  146. <th>Jam</th>
  147. <th>Ruang</th>
  148. <th>Dosen Penguji 1</th>
  149. <th>Dosen Penguji 2</th>
  150. <th>Dosen Penguji 3</th>
  151. <th>Dosen Penguji 4</th>
  152. </tr>
  153. ";
  154. $perintah = "SELECT d.id_jadwal, d.nim, a.Name, b.judul, d.hari, d.tanggal, d.jam, c.Nama, (SELECT Name FROM dosen WHERE ID=d.penguji1) as Penguji1, (SELECT Name FROM dosen WHERE ID=d.penguji2) as Penguji2, (SELECT Name FROM dosen WHERE ID=d.penguji3) as Penguji3, (SELECT Name FROM dosen WHERE ID=d.penguji4) as Penguji4
  155. FROM mhsw a, skr_peserta b, ruang c , skr_penjadwalan d
  156. WHERE a.NIM=d.nim AND b.nim=d.nim AND c.Kode=d.id_ruang AND a.KodeJurusan='$hasil_mhs[0]'
  157. ORDER BY d.id_jadwal ASC";
  158. $jalan = mysql_query($perintah);
  159. while($hasil=mysql_fetch_array($jalan)){
  160. echo"
  161. <tr>
  162. <td>$hasil[0]</td>
  163. <td>$hasil[1]</td>
  164. <td>$hasil[2]</td>
  165. <td>$hasil[3]</td>
  166. <td>$hasil[4]</td>
  167. <td>$hasil[5]</td>
  168. <td>$hasil[6]</td>
  169. <td>$hasil[7]</td>
  170. <td>$hasil[8]</td>
  171. <td>$hasil[9]</td>
  172. <td>$hasil[10]</td>
  173. <td>$hasil[11]</td>
  174. <tr>
  175. ";
  176. }
  177. echo"
  178. </table>
  179. </form>
  180. ";
  181. }
  182. else if($a=='Karyawan Jurusan'){
  183. echo "
  184. <form method='post' name='formdatajadwal' action=''>
  185. <table border='1' align='center'>
  186. <tr>
  187. <th>ID</th>
  188. <th>NIM</th>
  189. <th>Nama</th>
  190. <th>Judul Skripsi</th>
  191. <th>Hari</th>
  192. <th>Tanggal</th>
  193. <th>Jam</th>
  194. <th>Ruang</th>
  195. <th>Dosen Penguji 1</th>
  196. <th>Dosen Penguji 2</th>
  197. <th>Dosen Penguji 3</th>
  198. <th>Dosen Penguji 4</th>
  199. </tr>
  200. ";
  201. $perintah = "SELECT d.id_jadwal, d.nim, a.Name, b.judul, d.hari, d.tanggal, d.jam, c.Nama, (SELECT Name FROM dosen WHERE ID=d.penguji1) as Penguji1, (SELECT Name FROM dosen WHERE ID=d.penguji2) as Penguji2, (SELECT Name FROM dosen WHERE ID=d.penguji3) as Penguji3, (SELECT Name FROM dosen WHERE ID=d.penguji4) as Penguji4
  202. FROM mhsw a, skr_peserta b, ruang c , skr_penjadwalan d
  203. WHERE a.NIM=d.nim AND b.nim=d.nim AND c.Kode=d.id_ruang AND a.KodeJurusan='$hasil_karjur[0]'
  204. ORDER BY d.id_jadwal ASC";
  205. $jalan = mysql_query($perintah);
  206. while($hasil=mysql_fetch_array($jalan)){
  207. echo"
  208. <tr>
  209. <td>$hasil[0]</td>
  210. <td>$hasil[1]</td>
  211. <td>$hasil[2]</td>
  212. <td>$hasil[3]</td>
  213. <td>$hasil[4]</td>
  214. <td>$hasil[5]</td>
  215. <td>$hasil[6]</td>
  216. <td>$hasil[7]</td>
  217. <td>$hasil[8]</td>
  218. <td>$hasil[9]</td>
  219. <td>$hasil[10]</td>
  220. <td>$hasil[11]</td>
  221. <tr>
  222. ";
  223. }
  224. echo"
  225. </table>
  226. </form>
  227. ";
  228. }
  229. break;
  230. case('tambah'):
  231. echo "
  232. <form method='post' name='formskjdwlujiansk' action='?syxec=$b&aksi=insert'>
  233. <table align='center'>
  234. <tr>
  235. <td>
  236. <input type='hidden' name='id_jadwal' value=''/>
  237. </td>
  238. </tr>
  239. <tr>
  240. <td>
  241. <label>Nama</label>
  242. </td>
  243. <td>
  244. :
  245. <select name='nim'>
  246. <option value='0'>- Pilih Nama -</option>";
  247. $perintah_nama = "SELECT a.nim,b.Name FROM skr_peserta a,mhsw b WHERE a.nim=b.NIM AND b.KodeJurusan='$hasil_id_jur[0]'";
  248. $jalan_nama = mysql_query($perintah_nama);
  249. while($hasil_nama = mysql_fetch_array($jalan_nama)){
  250. echo "<option name='nim' value=$hasil_nama[0]>$hasil_nama[1]</option>";
  251. }
  252. echo "</select>
  253. </td>
  254. </tr>
  255. <tr>
  256. <td>
  257. <label>Hari</label>
  258. </td>
  259. <td>
  260. :
  261. <select name='hari'>
  262. <option value='0' selected>- Pilih Hari -</option>
  263. <option name='hari' value='senin'>senin</option>
  264. <option name='hari' value='selasa'>selasa</option>
  265. <option name='hari' value='rabu'>rabu</option>
  266. <option name='hari' value='kamis'>kamis</option>
  267. <option name='hari' value='jumat'>jumat</option>
  268. <option name='hari' value='sabtu'>sabtu</option>
  269. </select>
  270. </td>
  271. </tr>
  272. <tr>
  273. <td>
  274. <label>Tanggal</label>
  275. </td>
  276. <td>
  277. : <input type='text' name='tanggal'/>
  278. </td>
  279. </tr>
  280. <tr>
  281. <td>
  282. <label>Jam</label>
  283. </td>
  284. <td>
  285. : <input type='text' name='jam'/>
  286. </td>
  287. </tr>
  288. <tr>
  289. <td>
  290. <label>Ruang</label>
  291. </td>
  292. <td>
  293. :
  294. <select name='id_ruang'>
  295. <option value='0' selected>- Pilih Ruang -</option>";
  296. $perintah = "SELECT Kode,Nama FROM ruang ORDER BY Kode";
  297. $jalan = mysql_query($perintah);
  298. while($hasil = mysql_fetch_array($jalan)){
  299. echo "<option name='id_ruang' value=$hasil[0]>$hasil[1]</option>";
  300. }
  301. echo "</select>
  302. </td>
  303. </tr>
  304. <tr>
  305. <td>
  306. <label>Dosen Penguji 1</label>
  307. </td>
  308. <td>
  309. :
  310. <select name='dosen_penguji1'>
  311. <option value='0' selected>- Pilih Dosen Penguji -</option>";
  312. $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
  313. $jalan = mysql_query($perintah);
  314. while($hasil = mysql_fetch_array($jalan)){
  315. echo "<option name='dosen_penguji1' value=$hasil[0]>$hasil[1]</option>";
  316. }
  317. echo "</select>
  318. </td>
  319. </tr>
  320. <tr>
  321. <td>
  322. <label>Dosen Penguji 2</label>
  323. </td>
  324. <td>
  325. :
  326. <select name='dosen_penguji2'>
  327. <option value='0' selected>- Pilih Dosen Penguji -</option>";
  328. $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
  329. $jalan = mysql_query($perintah);
  330. while($hasil = mysql_fetch_array($jalan)){
  331. echo "<option name='dosen_penguji2' value=$hasil[0]>$hasil[1]</option>";
  332. }
  333. echo "</select>
  334. </td>
  335. </tr>
  336. <tr>
  337. <td>
  338. <label>Dosen Penguji 3</label>
  339. </td>
  340. <td>
  341. :
  342. <select name='dosen_penguji3'>
  343. <option value='0' selected>- Pilih Dosen Penguji -</option>";
  344. $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
  345. $jalan = mysql_query($perintah);
  346. while($hasil = mysql_fetch_array($jalan)){
  347. echo "<option name='dosen_penguji3' value=$hasil[0]>$hasil[1]</option>";
  348. }
  349. echo "</select>
  350. </td>
  351. </tr>
  352. <tr>
  353. <td>
  354. <label>Dosen Penguji 4</label>
  355. </td>
  356. <td>
  357. :
  358. <select name='dosen_penguji4'>
  359. <option value='0' selected>- Pilih Dosen Penguji -</option>";
  360. $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
  361. $jalan = mysql_query($perintah);
  362. while($hasil = mysql_fetch_array($jalan)){
  363. echo "<option name='dosen_penguji4' value=$hasil[0]>$hasil[1]</option>";
  364. }
  365. echo "</select>
  366. </td>
  367. </tr>
  368. <tr>
  369. <td colspan='2' align='center'>
  370. <input type='reset' name='submit2' value='Reset' />
  371. <input type='submit' name='submit' value='Simpan' />
  372. </td>
  373. </tr>
  374. </table>
  375. </form>
  376. ";
  377. break;
  378. case('insert'):
  379. $id_jadwal = $_POST['id_jadwal'];
  380. $nim = $_POST['nim'];
  381. $id_ruang = $_POST['id_ruang'];
  382. $hari = $_POST['hari'];
  383. $tanggal = $_POST['tanggal'];
  384. $jam = $_POST['jam'];
  385. $dp1 = $_POST['dosen_penguji1'];
  386. $dp2 = $_POST['dosen_penguji2'];
  387. $dp3 = $_POST['dosen_penguji3'];
  388. $dp4 = $_POST['dosen_penguji4'];
  389. $Q=mysql_query("SELECT nim FROM skr_penjadwalan");
  390. $nC = 0;
  391. while($R=mysql_fetch_array($Q)){
  392. if($R[0]==$nim){
  393. $nC = 1;
  394. break;
  395. }
  396. }
  397. $Q=mysql_query("SELECT hari, tanggal, jam FROM skr_penjadwalan");
  398. $iC = 0;
  399. while($R=mysql_fetch_array($Q)){
  400. if($R[0]==$hari&&$R[1]==$tanggal&&$R[2]==$jam){
  401. $iC = 1;
  402. break;
  403. }
  404. }
  405. if($iC != 1 && $nC != 1 && $dp1 != $dp2 && $dp1 != $dp3 && $dp1 != $dp4 && $dp2 != $dp3 && $dp2 != $dp4 && $dp3 != $dp4){
  406. mysql_query("INSERT INTO skr_penjadwalan VALUES ('$id_jadwal','$nim','$id_ruang','$hari','$tanggal','$jam','$dp1','$dp2','$dp3','$dp4')");
  407. $q = mysql_query("SELECT id_jadwal FROM skr_penjadwalan WHERE nim=$nim");
  408. $h = mysql_fetch_array($q);
  409. mysql_query("INSERT INTO skr_beritaacara VALUES ('null','$h[id_jadwal]','$nim',0,0,0,0,0,'null')");
  410. echo"<center>Data berhasil disimpan<br>Kembali ke <big><a href='?syxec=skjdwlujiansk'><blink>List Data</blink></a></big></center>";
  411. }
  412. else{
  413. echo("<center>Jadwal <big>Bentrok</big> atau <big>Dosen Penguji ada yang sama</big><br>Kembali ke <big><a href='?syxec=skjdwlujiansk&aksi=tambah'><blink>Form Tambah Jadwal</blink></a></big></center>");
  414. }
  415. break;
  416. case('edit'):
  417. $idxx = $_GET['idxx'];
  418. $nim = $_POST['nim'];
  419. $id_ruang = $_POST['id_ruang'];
  420. $hari = $_POST['hari'];
  421. $tanggal = $_POST['tanggal'];
  422. $jam = $_POST['jam'];
  423. $dp1 = $_POST['dosen_penguji1'];
  424. $dp2 = $_POST['dosen_penguji2'];
  425. $dp3 = $_POST['dosen_penguji3'];
  426. $dp4 = $_POST['dosen_penguji4'];
  427. //echo"'$nim','$id_ruang','$hari','$tanggal','$jam','$dp1','$dp2','$dp3','$dp4')";
  428. $perintah = "UPDATE skr_penjadwalan SET id_ruang='$id_ruang',hari='$hari',tanggal='$tanggal',jam='$jam',penguji1='$dp1',penguji2='$dp2',penguji3='$dp3',penguji4='$dp4' WHERE id_jadwal='$idxx'";
  429. mysql_query($perintah);
  430. echo"<center>Data berhasil diubah<br>Kembali ke <big><a href='?syxec=skjdwlujiansk'><blink>List Data</blink></a></big></center>";
  431. break;
  432. case "ubah";
  433. $idxx=$_GET['id'];
  434. echo "
  435. <form method='post' name='formskjdwlujiansk' action='?syxec=$b&aksi=edit&idxx=$idxx'>
  436. <table align='center'>
  437. <tr>
  438. <td>
  439. <input type='hidden' name='id_jadwal' value=''/>
  440. </td>
  441. </tr>
  442. <tr>
  443. <td>
  444. <label>Nama</label>
  445. </td>
  446. <td>
  447. ";
  448. $query = "SELECT a.Name FROM mhsw a, skr_penjadwalan b WHERE a.NIM=b.nim AND b.id_jadwal=$idxx";
  449. $result=mysql_query($query);
  450. $hasil=mysql_fetch_array($result);
  451. echo(": ".$hasil[0]);
  452. echo "</td>
  453. </tr>
  454. <tr>
  455. <td>
  456. <label>Hari</label>
  457. </td>
  458. <td>
  459. :
  460. ";
  461. $query = "SELECT hari FROM skr_penjadwalan WHERE id_jadwal=$idxx";
  462. $result=mysql_query($query);
  463. $hasil=mysql_fetch_array($result);
  464. echo"
  465. <select name='hari'>
  466. <option value='0'"; if($hasil[0]==null){echo(" selected=true ");} echo">- Pilih Hari -</option>
  467. <option name='hari' value='senin'"; if($hasil[0]=="senin"){echo(" selected=true ");} echo">senin</option>
  468. <option name='hari' value='selasa'"; if($hasil[0]=="selasa"){echo(" selected=true ");} echo">selasa</option>
  469. <option name='hari' value='rabu'"; if($hasil[0]=="rabu"){echo(" selected=true ");} echo">rabu</option>
  470. <option name='hari' value='kamis'"; if($hasil[0]=="kamis"){echo(" selected=true ");} echo">kamis</option>
  471. <option name='hari' value='jumat'"; if($hasil[0]=="jumat"){echo(" selected=true ");} echo">jumat</option>
  472. <option name='hari' value='sabtu'"; if($hasil[0]=="sabtu"){echo(" selected=true ");} echo">sabtu</option>
  473. </select>
  474. </td>
  475. </tr>
  476. <tr>
  477. <td>
  478. <label>Tanggal</label>
  479. </td>
  480. <td>
  481. ";
  482. $query = "SELECT tanggal, jam FROM skr_penjadwalan WHERE id_jadwal=$idxx";
  483. $result=mysql_query($query);
  484. $hasil=mysql_fetch_array($result);
  485. echo"
  486. : <input type='text' name='tanggal' value='$hasil[0]'/>
  487. </td>
  488. </tr>
  489. <tr>
  490. <td>
  491. <label>Jam</label>
  492. </td>
  493. <td>
  494. : <input type='text' name='jam' value='$hasil[1]' />
  495. </td>
  496. </tr>
  497. <tr>
  498. <td>
  499. <label>Ruang</label>
  500. </td>
  501. <td>
  502. :
  503. <select name='id_ruang'>
  504. <option value='0' selected>- Pilih Ruang -</option>";
  505. $perintah = "SELECT Kode,Nama FROM ruang ORDER BY Kode";
  506. $jalan = mysql_query($perintah);
  507. while($hasil = mysql_fetch_array($jalan)){
  508. $query=mysql_query("SELECT id_ruang FROM skr_penjadwalan WHERE id_jadwal=$idxx");
  509. $shadow=mysql_fetch_array($query);
  510. if($shadow[0]==$hasil[0]){
  511. echo "<option name='id_ruang' value=$hasil[0] selected=true>$hasil[1]</option>";
  512. }
  513. else{
  514. echo "<option name='id_ruang' value=$hasil[0]>$hasil[1]</option>";
  515. }
  516. }
  517. echo "</select>
  518. </td>
  519. </tr>
  520. <tr>
  521. <td>
  522. <label>Dosen Penguji 1</label>
  523. </td>
  524. <td>
  525. :
  526. <select name='dosen_penguji1'>
  527. <option value='0' selected>- Pilih Dosen Penguji -</option>";
  528. $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
  529. $jalan = mysql_query($perintah);
  530. while($hasil = mysql_fetch_array($jalan)){
  531. $query=mysql_query("SELECT penguji1 FROM skr_penjadwalan WHERE id_jadwal=$idxx");
  532. $shadow=mysql_fetch_array($query);
  533. if($shadow[0]==$hasil[0]){
  534. echo "<option name='dosen_penguji1' value=$hasil[0] selected=true>$hasil[1]</option>";
  535. }
  536. else{
  537. echo "<option name='dosen_penguji1' value=$hasil[0]>$hasil[1]</option>";
  538. }
  539. }
  540. echo "</select>
  541. </td>
  542. </tr>
  543. <tr>
  544. <td>
  545. <label>Dosen Penguji 2</label>
  546. </td>
  547. <td>
  548. :
  549. <select name='dosen_penguji2'>
  550. <option value='0' selected>- Pilih Dosen Penguji -</option>";
  551. $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
  552. $jalan = mysql_query($perintah);
  553. while($hasil = mysql_fetch_array($jalan)){
  554. $query=mysql_query("SELECT penguji2 FROM skr_penjadwalan WHERE id_jadwal=$idxx");
  555. $shadow=mysql_fetch_array($query);
  556. if($shadow[0]==$hasil[0]){
  557. echo "<option name='dosen_penguji2' value=$hasil[0] selected=true>$hasil[1]</option>";
  558. }
  559. else{
  560. echo "<option name='dosen_penguji2' value=$hasil[0]>$hasil[1]</option>";
  561. }
  562. }
  563. echo "</select>
  564. </td>
  565. </tr>
  566. <tr>
  567. <td>
  568. <label>Dosen Penguji 3</label>
  569. </td>
  570. <td>
  571. :
  572. <select name='dosen_penguji3'>
  573. <option value='0' selected>- Pilih Dosen Penguji -</option>";
  574. $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
  575. $jalan = mysql_query($perintah);
  576. while($hasil = mysql_fetch_array($jalan)){
  577. $query=mysql_query("SELECT penguji3 FROM skr_penjadwalan WHERE id_jadwal=$idxx");
  578. $shadow=mysql_fetch_array($query);
  579. if($shadow[0]==$hasil[0]){
  580. echo "<option name='dosen_penguji3' value=$hasil[0] selected=true>$hasil[1]</option>";
  581. }
  582. else{
  583. echo "<option name='dosen_penguji3' value=$hasil[0]>$hasil[1]</option>";
  584. }
  585. }
  586. echo "</select>
  587. </td>
  588. </tr>
  589. <tr>
  590. <td>
  591. <label>Dosen Penguji 4</label>
  592. </td>
  593. <td>
  594. :
  595. <select name='dosen_penguji4'>
  596. <option value='0' selected>- Pilih Dosen Penguji -</option>";
  597. $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
  598. $jalan = mysql_query($perintah);
  599. while($hasil = mysql_fetch_array($jalan)){
  600. $query=mysql_query("SELECT penguji4 FROM skr_penjadwalan WHERE id_jadwal=$idxx");
  601. $shadow=mysql_fetch_array($query);
  602. if($shadow[0]==$hasil[0]){
  603. echo "<option name='dosen_penguji4' value=$hasil[0] selected=true>$hasil[1]</option>";
  604. }
  605. else{
  606. echo "<option name='dosen_penguji4' value=$hasil[0]>$hasil[1]</option>";
  607. }
  608. }
  609. echo "</select>
  610. </td>
  611. </tr>
  612. <tr>
  613. <td colspan='2' align='center'>
  614. <input type='submit' name='submit' value='Ubah' />
  615. </td>
  616. </tr>
  617. </table>
  618. </form>
  619. ";
  620. break;
  621. case('hapus'):
  622. $idxx = $_GET['idxx'];
  623. mysql_query("DELETE FROM skr_penjadwalan WHERE id_jadwal = '$idxx'");
  624. mysql_query("DELETE FROM skr_beritaacara WHERE id_jadwal = '$idxx'");
  625. echo"<center>Data berhasil dihapus<br>Kembali ke <big><a href='?syxec=skjdwlujiansk'><blink>List Data</blink></a></big></center>";
  626. break;
  627. }
  628. ?>