PageRenderTime 64ms CodeModel.GetById 27ms RepoModel.GetById 1ms app.codeStats 0ms

/sysfo/jdwlujian.php

https://bitbucket.org/justmyfreak/sisfokampus
PHP | 440 lines | 402 code | 16 blank | 22 comment | 97 complexity | 2e8fbab416d9da44b16e5a317120541f MD5 | raw file
  1. <?php
  2. // Author: E. Setio Dewo, setio_dewo@telkom.net, Juni 2003
  3. // *** FUNGSI2 ***
  4. function DispJadwalUjian($thn, $kdj, $kdp='', $ujn, $jdl, $det=0) {
  5. global $strCantQuery;
  6. $_tgl = $ujn.'Tanggal';
  7. $_mul = $ujn.'Mulai';
  8. $_sel = $ujn.'Selesai';
  9. $_kmps = $ujn.'Kampus';
  10. $_rng = $ujn.'Ruang';
  11. // Set where
  12. $whr = '';
  13. $whr .= (empty($kdp)) ? '' : "and j.Program='$kdp' ";
  14. // jika cetak detail
  15. if ($det == 0) {
  16. $detfld = '';
  17. $detord = ''; $detfrm = '';
  18. $dethdr = '';
  19. }
  20. else {
  21. $detfld = " count(k.ID) as JML, ";
  22. $detord = " group by j.ID ";
  23. $detfrm = " left outer join krs k on j.ID=k.IDJadwal ";
  24. $dethdr = "<th class=ttl>Jml</th>";
  25. }
  26. // ambil data
  27. $s = "select j.ID, j.IDDosen, j.IDMK, j.KodeMK, j.NamaMK, pr.Nama_Indonesia as PRG,
  28. j.$_tgl, h.Nama as HR, j.Tunda, j.$_tgl,
  29. DATE_FORMAT(j.$_tgl, '%d-%m-%Y') as tgl,
  30. TIME_FORMAT(j.$_mul, '%H:%i') as mul, TIME_FORMAT(j.$_sel, '%H:%i') as sel,
  31. j.$_kmps, j.$_rng, $detfld
  32. concat(ds.Name, ', ', ds.Gelar) as DSN
  33. from jadwal j $detfrm
  34. left outer join dosen ds on j.IDDosen=ds.ID
  35. left outer join program pr on j.Program=pr.Kode
  36. left outer join hari h on DAYOFWEEK(j.$_tgl)=h.ID
  37. where j.Tahun='$thn' and j.KodeJurusan='$kdj' $whr
  38. $detord
  39. order by j.$_tgl, j.$_mul ";
  40. $r = mysql_query($s) or die("$strCantQuery: $s<br>".mysql_error());
  41. echo "<table class=box cellspacing=0 cellpadding=4>";
  42. echo "<tr>
  43. <tr><th class=ttl>Tanggal</th>
  44. <th class=ttl>Jam</th>
  45. <th class=ttl>Kode MK</th><th class=ttl>Mata Kuliah</th><th class=ttl>Dosen</th>
  46. <th class=ttl>Ruang</th> $dethdr
  47. </tr>";
  48. $ih = ''; $first = TRUE;
  49. while ($w = mysql_fetch_array($r)) {
  50. // Tampilkan menu
  51. if ($_SESSION['ulevel'] == 1 || $_SESSION['ulevel'] == 2)
  52. $strmk = "<a href='sysfo.php?syxec=jdwlujian&ujn=$ujn&jid=$w[ID]'>$w[KodeMK]</a>";
  53. else $strmk = $w['KMK'];
  54. $cls = ($w['Tunda'] == 'Y')? 'class=nac' : 'class=lst';
  55. // cek apa harinya sama?
  56. if ($ih != $w['HR']) {
  57. if ($first) $first = false;
  58. else echo "<tr><td colspan=7 class=uline>&nbsp;</td></tr>";
  59. $ih = $w['HR'];
  60. $harinya = "$w[HR], $w[tgl]";
  61. }
  62. else {
  63. $harinya = '';
  64. }
  65. // apakah menampilkan data?
  66. if ($det == 1) {
  67. $str = "<td $cls align=right>$w[JML]</td>";
  68. }
  69. else {
  70. $str = '';
  71. }
  72. // tampilkan data
  73. echo "
  74. <tr><td>$harinya</td>
  75. <td $cls>$w[mul] - $w[sel]</td>
  76. <td $cls>$strmk</td>
  77. <td $cls>$w[NamaMK]</td><td $cls>$w[DSN]</td>
  78. <td $cls>$w[$_rng]</td>
  79. $str
  80. </tr>";
  81. }
  82. echo "<tr><td height=2></td></tr></table>";
  83. }
  84. function EditJadwalUjian($jid, $ujn, $jdl) {
  85. global $strCantQuery, $prn;
  86. if (!isset($prn)) $prn = 0;
  87. $_tgl = $ujn.'Tanggal';
  88. $_mul = $ujn.'Mulai';
  89. $_sel = $ujn.'Selesai';
  90. $_kmps = $ujn.'Kampus';
  91. $_rng = $ujn.'Ruang';
  92. $s = "select DATE_FORMAT(j.$_tgl, '%d-%m-%Y') as tgl,
  93. TIME_FORMAT(j.$_mul, '%H:%i') as mul, TIME_FORMAT(j.$_sel, '%H:%i') as sel,
  94. j.$_kmps as kmps, j.$_rng as rng, concat(ds.Name, ', ', ds.Gelar) as dsn,
  95. mk.Kode, mk.Nama_Indonesia as MK, mk.SKS
  96. from jadwal j left outer join matakuliah mk on j.IDMK=mk.ID
  97. left outer join dosen ds on j.IDDosen=ds.ID
  98. where j.ID=$jid limit 1";
  99. $r = mysql_query($s) or die("$strCantQuery: $s");
  100. $tgl = mysql_result($r, 0, 'tgl');
  101. $mul = mysql_result($r, 0, 'mul');
  102. $sel = mysql_result($r, 0, 'sel');
  103. $kmps = mysql_result($r, 0, 'kmps');
  104. $rng = mysql_result($r, 0, 'rng');
  105. $kmk = mysql_result($r, 0, 'Kode');
  106. $mk = mysql_result($r, 0, 'MK');
  107. $sks = mysql_result($r, 0, 'SKS');
  108. $dsn = mysql_result($r, 0, 'dsn');
  109. if (empty($mul)) $mul = '00:00';
  110. if (empty($sel)) $sel = '00:00';
  111. if (empty($tgl)) $tgl = date('d-m-Y');
  112. $atgl = explode('-', $tgl);
  113. $tgld = $atgl[0]; $tglm = $atgl[1]; $tgly = $atgl[2];
  114. //GetOption2('jurusan', "concat(Kode, ' -- ', Nama_Indonesia)", 'Kode', $kdj, '', 'Kode');
  115. $optkmps = GetOption2('kampus', "concat(Kode, ' -- ', Kampus)", 'Kode', $kmps, '', 'Kode');
  116. $sid = session_id(); $snm = session_name();
  117. if ($prn == 0) $button = "<input type=submit name='prcjdwl' value='Simpan'>&nbsp;
  118. <input type=reset name=reset value='Reset'>&nbsp;
  119. <input type=button name=balik value='Kembali' onClick=\"location='sysfo.php?syxec=jdwlujian&$snm=$sid'\">";
  120. else $button = '';
  121. return <<<EOF
  122. <table class=box cellspacing=0 cellpadding=4 width=100%>
  123. <form action='sysfo.php' method=POST>
  124. <input type=hidden name='syxec' value='jdwlujian'>
  125. <input type=hidden name='jid' value='$jid'>
  126. <input type=hidden name='ujn' value='$ujn'>
  127. <tr><th class=ttl colspan=2>Edit $jdl</th></tr>
  128. <tr><td class=uline>Mata Kuliah</td><td class=uline>$kmk - $mk - $sks SKS</td></tr>
  129. <tr><td class=uline>Dosen</td><td class=uline>$dsn</td></tr>
  130. <tr><td class=uline>Tanggal</td><td class=uline>
  131. <input type=text name='tgld' value='$tgld' size=2 maxlength=2>
  132. <input type=text name='tglm' value='$tglm' size=2 maxlength=2>
  133. <input type=text name='tgly' value='$tgly' size=4 maxlength=4>
  134. </td></tr>
  135. <tr><td class=uline>Jam mulai</td><td class=uline><input type=text name='mul' value='$mul' size=5 maxlength=5></td></tr>
  136. <tr><td class=uline>Jam Selesai</td><td class=uline><input type=text name='sel' value='$sel' size=5 maxlength=5></td></tr>
  137. <tr><td class=uline>Kampus</td><td class=uline><select name='kmps'>$optkmps</select></td></tr>
  138. <tr><td class=uline>Ruang</td><td class=uline><input type=text name='rng' value='$rng' size=50 maxlength=50></td></tr>
  139. <tr><td class=uline colspan=2>$button</td></tr>
  140. </form><tr><td height=2></td></tr></table>
  141. EOF;
  142. }
  143. function GetErrorRuang($r, $ujn, $msg) {
  144. $_tgl = $ujn.'Tanggal';
  145. $_mul = $ujn.'Mulai';
  146. $_sel = $ujn.'Selesai';
  147. $_kmps = $ujn.'Kampus';
  148. $_rng = $ujn.'Ruang';
  149. for ($i=0; $i < mysql_num_rows($r); $i++) {
  150. $strmk = GetFields('matakuliah', 'ID', mysql_result($r, $i, 'IDMK'), 'Kode,Nama_Indonesia');
  151. $str1 = "<li>$msg<br>".
  152. mysql_result($r, $i, $_tgl). ' '.
  153. mysql_result($r, $i, $_mul).' - '.mysql_result($r, $i, $_sel). ' : '.
  154. $strmk['Kode'] . ' - '. $strmk['Nama_Indonesia'] . ' dari '.
  155. mysql_result($r, $i, $_kmps) . ' : ' . mysql_result($r, $i, $_rng).
  156. '</li>';
  157. }
  158. return $str1;
  159. }
  160. function CheckRuang ($jid, $ujn, $kdk, $kdr, $tgl, $jm, $js) {
  161. global $strCantQuery, $fmtErrorMsg;
  162. $_tgl = $ujn.'Tanggal';
  163. $_mul = $ujn.'Mulai';
  164. $_sel = $ujn.'Selesai';
  165. $_kmps = $ujn.'Kampus';
  166. $_rng = $ujn.'Ruang';
  167. // cek bentrok?
  168. $sm = "select * from jadwal where $_kmps='$kdk' and $_rng='$kdr' and $_tgl='$tgl' and
  169. $_mul <= '$jm:00' and '$jm:00' <= $_sel and ID<>$jid ";
  170. $rm = mysql_query($sm) or die ("$strCantQuery: $sm");
  171. $hm = mysql_num_rows($rm);
  172. if ($hm > 0) $str1 = GetErrorRuang($rm, $ujn, '<b>Jam Mulai Bentrok.</b>');
  173. else $str1 = '';
  174. $ss = "select * from jadwal where $_kmps='$kdk' and $_rng='$kdr' and $_tgl='$tgl' and
  175. $_mul <= '$js' and '$js' <= $_sel and ID<>$jid ";
  176. $rs = mysql_query($ss) or die ("$strCantQuery: $ss");
  177. $hs = mysql_num_rows($rs);
  178. if ($hs > 0) $str2 = GetErrorRuang($rs, $ujn, '<b>Jam Selesai Bentrok.</b>');
  179. else $str2 = '';
  180. if (!($hm == 0 && $hs ==0)) {
  181. $arrtgl = explode('-', $tgl);
  182. DisplayHeader($fmtErrorMsg, "Tidak dapat dijadwalkan di <b>$kdk - $kdr</b>.<br>
  183. Ruang telah dipakai oleh : <br><ul> $str1 $str2 </ul><hr size=1 color=silver>
  184. Pilihan: <a href='sysfo.php?syxec=jdwlujian&jid=$jid&ujn=$ujn&tgld=$arrtgl[2]&tglm=$arrtgl[1]&tgly=$arrtgl[0]&mul=$jm&sel=$js&rng=$kdr&kmps=$kdk&prcjdwl=1&gabung=1'>Gabung Jadwal Ujian</a>");
  185. }
  186. return ($hm == 0) && ($hs == 0);
  187. }
  188. function PrcJdwlUjian($kdj) {
  189. global $strCantQuery, $fmtErrorMsg, $thn, $strTahunNotActive;
  190. if (!isTahunAktif($thn, $kdj)) DisplayHeader($fmtErrorMsg, $strTahunNotActive);
  191. else {
  192. $gabung = (isset($_REQUEST['gabung']))? $_REQUEST['gabung'] : 0;
  193. $jid = $_REQUEST['jid'];
  194. $ujn = $_REQUEST['ujn'];
  195. if (isset($_REQUEST['tgld'])) $tgld = $_REQUEST['tgld']; else $tgld = '00';
  196. if (isset($_REQUEST['tglm'])) $tglm = $_REQUEST['tglm']; else $tglm = '00';
  197. if (isset($_REQUEST['tgly'])) $tgly = $_REQUEST['tgly']; else $tgly = '0000';
  198. $tgl = "$tgly-$tglm-$tgld";
  199. if (isset($_REQUEST['mul'])) $mul = $_REQUEST['mul']; else $mul = '00:00';
  200. if (isset($_REQUEST['sel'])) $sel = $_REQUEST['sel']; else $sel = '00:00';
  201. $rng = $_REQUEST['rng'];
  202. $kmps = $_REQUEST['kmps'];
  203. if ($tgl == '0000-00-00') {
  204. DisplayHeader($fmtErrorMsg, "Tanggal yang dimasukkan tidak valid.");
  205. return $jid;
  206. }
  207. else {
  208. $_tgl = $ujn.'Tanggal';
  209. $_mul = $ujn.'Mulai';
  210. $_sel = $ujn.'Selesai';
  211. $_kmps = $ujn.'Kampus';
  212. $_rng = $ujn.'Ruang';
  213. $s = "update jadwal set $_tgl='$tgl', $_mul='$mul', $_sel='$sel', $_kmps='$kmps', $_rng='$rng'
  214. where ID=$jid ";
  215. // Cek apakah dapat digabung?
  216. if ($gabung==0) {
  217. if (CheckRuang ($jid, $ujn, $kmps, $rng, $tgl, $mul, $sel)) {
  218. $r = mysql_query($s) or die("$strCantQuery: $s");
  219. //return 0;
  220. return $jid;
  221. } else return $jid;
  222. }
  223. // Jadwal ujian digabung. OKE?
  224. else {
  225. $r = mysql_query($s) or die("Gagal: $s<br>".mysql_error());
  226. return $jid;
  227. }
  228. }
  229. }
  230. }
  231. function EditPengawasUjian($jid, $ujn, $Level=3) {
  232. global $prn;
  233. if ($prn==0) {
  234. $optdsn = GetOption2('dosen', "concat(Name, ', ', Gelar)", 'Name', '', '', 'Login');
  235. $optkar = GetOption2('karyawan', "concat(Login, ' -- ', Name)", 'Login', '', '', 'Login');
  236. $a = "<table class=box cellspacing=0 cellpadding=4>
  237. <form action='sysfo.php' method=GET>
  238. <input type=hidden name='syxec' value='jdwlujian'>
  239. <input type=hidden name='jid' value='$jid'>
  240. <input type=hidden name='ujn' value='$ujn'>
  241. <input type=hidden name='Level' value='3'>
  242. <tr><th class=ttl colspan=2>Tambahkan Pengawas Ujian</th></tr>
  243. <tr><td class=uline>Dosen</td><td class=uline><select name='alog'>$optdsn</select><input type=submit name='prcawas' value='+'></td></form></tr>
  244. <form action='sysfo.php' method=GET>
  245. <input type=hidden name='syxec' value='jdwlujian'>
  246. <input type=hidden name='jid' value='$jid'>
  247. <input type=hidden name='ujn' value='$ujn'>
  248. <input type=hidden name='Level' value='2'>
  249. <tr><td class=uline>Karyawan</td><td class=uline><select name='alog'>$optkar</select><input type=submit name='prcawas' value='+'></td></tr>
  250. </form><tr><td height=2></td></tr></table>";
  251. } else $a = '';
  252. $a .= GetDaftarJagaUjian($jid, $ujn);
  253. return $a;
  254. }
  255. function GetDaftarJagaUjian($jid, $ujn) {
  256. // Ambil pengawas dosen
  257. $s1 = "select p.ID, p.Login, concat(d.Name, ', ', d.Gelar) as NMA
  258. from pengawasujian p left outer join dosen d on p.Login=d.Login
  259. where p.IDJadwal='$jid' and p.Level=3 order by d.Name";
  260. $r1 = mysql_query($s1) or die("Gagal: $s1<br>".mysql_error());
  261. $header = "<tr><th class=ttl>#</th><th class=ttl>Kode</th><th class=ttl>Nama</th><td></td></tr>";
  262. $a = "<table class=basic cellspacing=0 cellpadding=4>
  263. <tr><td colspan=4><b class=ttl>Dosen Jaga</td></tr>
  264. $header";
  265. $n = 0;
  266. while ($w = mysql_fetch_array($r1)) {
  267. $n++;
  268. //<td><a href='sysfo.php?syxec=jdwlujian&jid=$jid&pid=$row[ID]'>
  269. $a .= "<tr><td class=nac>$n</td><td class=uline>$w[Login]</td><td class=uline>$w[NMA]</td>
  270. <td class=uline align=center><a href='sysfo.php?syxec=jdwlujian&jid=$jid&pid=$w[ID]'><img src='image/del.gif' border=0></a></td></tr>";
  271. }
  272. // Ambil pengawas karyawan
  273. $s2 = "select p.ID, p.Login, concat(d.Login, ' -- ', d.Name) as NMA
  274. from pengawasujian p left outer join karyawan d on p.Login=d.Login
  275. where p.IDJadwal='$jid' and p.Level=2 order by d.Name";
  276. $r2 = mysql_query($s2) or die("Gagal: $s2<br>".mysql_error());
  277. $n = 0;
  278. $a .= "<tr><td height=10></td></tr><tr><td colspan=4><b class=ttl>Karyawan Jaga</td></tr>
  279. $header";
  280. while ($w = mysql_fetch_array($r2)) {
  281. $n++;
  282. $a .= "<tr><td class=nac>$n</td><td class=uline>$w[Login]</td><td class=uline>$w[NMA]</td>
  283. <td class=uline align=center><a href='sysfo.php?syxec=jdwlujian&jid=$jid&pid=$w[ID]'><img src='image/del.gif' border=0></a></td></tr>";
  284. }
  285. return $a.'</table>';
  286. }
  287. function EditPengawasUjian_old($jid, $ujn, $level=3) {
  288. global $strCantQuery, $prn;
  289. if (!isset($prn)) $prn = 0;
  290. if ($prn == 0)
  291. $_1 = <<<EOF
  292. <table class=basic cellspacing=0 cellpadding=2>
  293. <form action='sysfo.php' method=GET>
  294. <input type=hidden name='syxec' value='jdwlujian'>
  295. <input type=hidden name='jid' value='$jid'>
  296. <input type=hidden name='ujn' value='$ujn'>
  297. <tr><th class=ttl colspan=2>Tambahkan Pengawas</th></tr>
  298. <tr><td class=lst width=100>Kode Login</td>
  299. <td class=lst><input type=text name='_log' size=10 maxlength=10>&nbsp;<input type=submit name='prcawas' value='Simpan'>
  300. </td></tr>
  301. </form></table><br>
  302. EOF;
  303. else $_1 = '';
  304. $s = "select p.*, concat(d.Name, ', ', d.Gelar) as DSN
  305. from pengawasujian p left outer join dosen d on p.Login=d.Login
  306. where p.IDJadwal=$jid";
  307. $r = mysql_query($s) or die("$strCantQuery: $s");
  308. $_2 = "<table class=basic cellspacing=0 cellpadding=2 width=100%>
  309. <tr><th class=ttl colspan=3>Pengawas Ujian</th></tr>
  310. <tr><th class=ttl>#</th><th class=ttl>Kode</th><th class=ttl>Nama</th></tr>";
  311. $_3 = '';
  312. $cnt = 0;
  313. while ($row = mysql_fetch_array($r)) {
  314. $cnt++;
  315. if ($prn == 0) $strdel = "<td><a href='sysfo.php?syxec=jdwlujian&jid=$jid&pid=$row[ID]'>Del</a></td>";
  316. else $strdel = '';
  317. $_3 = $_3 . <<<EOF
  318. <tr><td class=lst>$cnt</td>
  319. <td class=lst>$row[Login]</td><td class=lst>$row[DSN]</td>
  320. $strdel</tr>
  321. EOF;
  322. }
  323. $_4 = "</table>";
  324. return $_1.$_2.$_3.$_4;
  325. }
  326. function CekAwasUjian($jid, $ujn, $Level, $log) {
  327. global $fmtErrorMsg, $strCantQuery;
  328. $_tgl = $ujn.'Tanggal';
  329. $_mul = $ujn.'Mulai';
  330. $_sel = $ujn.'Selesai';
  331. $arr = GetFields('jadwal', 'ID', $jid, "$_tgl, $_mul, $_sel");
  332. $tgl = $arr[$_tgl];
  333. $mul = $arr[$_mul];
  334. $sel = $arr[$_sel];
  335. $str = '';
  336. // Cek tahap 1
  337. $s1 = "select j.$_tgl, j.$_mul, j.$_sel, mk.Kode, mk.Nama_Indonesia as MK
  338. from pengawasujian p inner join jadwal j on p.IDJadwal=j.ID
  339. left outer join matakuliah mk on j.IDMK=mk.ID
  340. where p.Login='$log' and j.ID<>$jid and p.UJN='$ujn' and p.Level='$Level'
  341. and j.$_tgl='$tgl' and j.$_mul <= '$mul' and '$mul' <= j.$_sel";
  342. $r1 = mysql_query($s1) or die("$strCantQuery: $s1".mysql_error());
  343. if (mysql_num_rows($r1) > 0) $str = $str. "<li>Jam Mulai Jadwal <b>$log</b> bentrok dengan <b>".mysql_result($r1, 0, 'Kode').
  344. " -> ". mysql_result($r1, 0, 'MK')."</b></li>";
  345. // Cek tahap 2
  346. $s2 = "select j.$_tgl, j.$_mul, j.$_sel, mk.Kode, mk.Nama_Indonesia as MK
  347. from pengawasujian p inner join jadwal j on p.IDJadwal=j.ID
  348. left outer join matakuliah mk on j.IDMK=mk.ID
  349. where p.Login='$log' and j.ID<>$jid and p.UJN='$ujn' and p.Level='$Level'
  350. and j.$_tgl='$tgl' and j.$_mul <= '$sel' and '$sel' <= j.$_sel";
  351. $r2 = mysql_query($s2) or die("$strCantQuery: $s1");
  352. if (mysql_num_rows($r2) > 0) $str = $str. "<li>Jam Selesai Jadwal <b>$log</b> bentrok dengan <b>".mysql_result($r2, 0, 'Kode').
  353. " -> ". mysql_result($r2, 0, 'MK')."</b></li>";
  354. if (!empty($str)) {
  355. $str .= "<hr size=1>Pilihan: <a href='sysfo.php?syxec=jdwlujian&jid=$jid&ujn=$ujn&Level=$Level&alog=$log&prcawas=1&gabung=1'>Gabungkan pengawas</a>";
  356. DisplayHeader($fmtErrorMsg, $str);
  357. }
  358. return empty($str);
  359. }
  360. function PrcAwas() {
  361. global $strCantQuery, $fmtErrorMsg;
  362. $alog = (isset($_REQUEST['alog'])) ? $_REQUEST['alog'] : '';
  363. if (empty($alog)) die ("Anda belum memasukkan pengawas");
  364. $jid = $_REQUEST['jid'];
  365. $ujn = $_REQUEST['ujn'];
  366. $Level = $_REQUEST['Level'];
  367. $gabung = (!empty($_REQUEST['gabung']))? $_REQUEST['gabung'] : 0;
  368. $c1 = GetaField('pengawasujian', "IDJadwal='$jid' and Level='$Level' and Login", $alog, 'ID');
  369. if (!empty($c1)) DisplayHeader($fmtErrorMsg, "Pengawas <b>$alog</b> sudah didaftar.");
  370. else {
  371. if ($gabung == 1) SimpanAwasUjian($jid, $ujn, $Level, $alog);
  372. else {
  373. if (CekAwasUjian($jid, $ujn, $Level, $alog)) SimpanAwasUjian($jid, $ujn, $Level, $alog);
  374. }
  375. }
  376. }
  377. function SimpanAwasUjian($jid, $ujn, $Level, $alog) {
  378. $s = "insert into pengawasujian (IDJadwal, Login, UJN, Level, Honor) values ('$jid', '$alog', '$ujn', '$Level', 0)";
  379. $r = mysql_query($s) or die("$strCantQuery: $s");
  380. }
  381. function DelPID() {
  382. $pid = $_REQUEST['pid'];
  383. mysql_query("delete from pengawasujian where ID=$pid");
  384. }
  385. // *** PARAMETER ***
  386. $ujn = GetSetVar('ujn');
  387. $thn = GetSetVar('thn');
  388. $kdj = GetSetVar('kdj');
  389. $kdp = GetSetVar('kdp');
  390. $jid = (isset($_REQUEST['jid']))? $_REQUEST['jid'] : 0;
  391. $prn = (isset($_REQUEST['prn']))? $_REQUEST['prn'] : 0;
  392. $det = (isset($_REQUEST['det']))? $_REQUEST['det'] : 0;
  393. // *** BAGIAN UTAMA ***
  394. $jdl = GetUjianCaption($ujn);
  395. DisplayHeader($fmtPageTitle, "Jadwal $jdl");
  396. if (isset($_REQUEST['prcjdwl'])) $jid = PrcJdwlUjian($kdj);
  397. if (isset($_REQUEST['prcawas'])) PrcAwas();
  398. if (isset($_REQUEST['prcawasgbg'])) PrcAwasGabung();
  399. if (isset($_REQUEST['pid'])) DelPID();
  400. DispOptJdwl0('jdwlujian');
  401. if ($prn == 0) DispOptUjian($ujn);
  402. if (!empty($thn) && !empty($kdj) && !empty($kdp) && !empty($ujn)) {
  403. if ($prn == 0) {
  404. $sid = session_id(); $snm = session_name();
  405. //$prn = GetPrinter("print.php?print=sysfo/cetakabsen.php&jid=$jid&PHPSESSID=$sid");
  406. if ($jid == 0) {
  407. echo "<p><a href='print.php?print=sysfo/jdwlujian.php&prn=1&$snm=$sid' target=_blank>Cetak Jadwal</a>";
  408. if (($_SESSION['ulevel'] == 1) || ($_SESSION['ulevel'] == 2))
  409. echo " | <a href='print.php?print=sysfo/jdwlujian.php&prn=1&det=1&$snm=$sid' target=_blank>Cetak Detail Jadwal</a>";
  410. }
  411. }
  412. if ($jid > 0) {
  413. $strEditJadwalUjian = EditJadwalUjian($jid, $ujn, $jdl);
  414. $strEditPengawasUjian = EditPengawasUjian($jid, $ujn);
  415. echo <<<EOF
  416. <table class=basic cellspacing=1 cellpadding=2 width=100%>
  417. <tr><td class=basic valign=top width=50%>$strEditJadwalUjian</td>
  418. <td class=basic valign=top>$strEditPengawasUjian</td></tr>
  419. </table>
  420. EOF;
  421. }
  422. else DispJadwalUjian($thn, $kdj, $kdp, $ujn, $jdl, $det);
  423. }
  424. ?>