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

/kiriskpp1.php

https://bitbucket.org/metamorph/kppnadministration
PHP | 1795 lines | 1545 code | 131 blank | 119 comment | 77 complexity | 802c4816cf8ad756dd9ef6cfd2c63a21 MD5 | raw file
Possible License(s): GPL-2.0

Large files files are truncated, but you can click here to view the full file

  1. <?php
  2. //$PhpEncoder = new CPhpEncoder();
  3. $timezone = "Asia/Jakarta";
  4. if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);
  5. // Halaman utama (Home)
  6. if ($_GET['module']=='home'){
  7. }
  8. // Form insert data tanda terima SKPP Seksi Sub Bagian Umum
  9. elseif($_GET['module'] == 'tandaterimaskpp'){
  10. $qMaxagd = mysql_query("SELECT MAX(noagenda) maxAgd FROM d_skpp WHERE noagenda LIKE 'SKPP%'");
  11. $rMaxagd = mysql_fetch_array($qMaxagd);
  12. //penambahan setiap nomor agenda
  13. $noagd = $rMaxagd['maxAgd'];
  14. $jenAgd = 'SKPP';
  15. $noUrut = (int) substr($noagd,6,5);
  16. $noUrut++;
  17. //hasil akhir nomor agenda
  18. $newAgd = $jenAgd.'-'.sprintf("%05s",$noUrut);
  19. echo "<style type='text/css'>
  20. em { font-weight: bold; padding-right: 1em; vertical-align: top; }
  21. </style>
  22. <script>
  23. $(document).ready(function(){
  24. $('#form').validate();
  25. $('#tanggal').datepicker();
  26. });
  27. $(document).ready(function(){
  28. $('#form').validate();
  29. $('#tgagdtrm').datepicker();
  30. });
  31. $(document).ready(function(){
  32. $('#form').validate();
  33. $('#tgagdsls').datepicker();
  34. });
  35. </script>
  36. <div id='stylized' class='myform'>
  37. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  38. <h1>Form perekaman data SKPP</h1>
  39. <p><b>Step 1</b> - Data SKPP ini akan digunakan dalam proses penerbitan Surat Pengantar SKPP</p>
  40. <label>Nomor Agenda
  41. <span class='small'>Nomor agenda</span>
  42. </label>
  43. <input type='text' id='noagenda' class='required' minlength='3' name='noagenda' maxlength='10' value='$newAgd' readonly='readonly' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'staskpp')\" />
  44. <label>Status SKPP
  45. <span class='small'>Isikan status SKPP</span>
  46. </label>
  47. <select name='staskpp' id='staskpp' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'kdjenskpp')\" >
  48. <option selected='selected'>-- Pilih Status SKPP --</option>
  49. <option value='01'>01 - PNS</option>
  50. <option value='02'>02 - TNI</option>
  51. <option value='03'>03 - POLRI</option>
  52. </select>
  53. <label>Jenis SKPP
  54. <span class='small'>Isikan jenis SKPP</span>
  55. </label>
  56. <select name='kdjenskpp' id='kdjenskpp' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'kdgpp')\" >
  57. <option selected='selected'>-- Pilih Jenis SKPP --</option>
  58. <option value='01'>01 - Pindah</option>
  59. <option value='02'>02 - Pensiun</option>
  60. </select>
  61. <label>Kode GPP
  62. <span class='small'>Pilih kode GPP</span>
  63. </label>
  64. <select name='kdgpp' id='kdgpp' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'noskpp')\" >
  65. <option selected='selected'>-- Pilih kode GPP --</option>
  66. <option value='00'>00 - Non GPP</option>
  67. <option value='01'>01 - GPP</option>
  68. </select>
  69. <label>Nomor SKPP
  70. <span class='small'>Isikan nomor SKPP</span>
  71. </label>
  72. <input type='text' id='noskpp' name='noskpp' class='required' minlength='1' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tanggal')\" />
  73. <label>Tanggal SKPP
  74. <span class='small'>Isikan tanggal SKPP</span>
  75. </label>
  76. <input type='text' id='tanggal' name='tgskpp' class= 'required' minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'kdsatker')\" />
  77. <label>Kode Satker
  78. <span class='small'>Isikan kode satker</span>
  79. </label>
  80. <input type='text' id='kdsatker' name='kdsatker' class='required' minlength='6' maxlength='6' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'anskpp')\" />
  81. <label>Nama Pegawai
  82. <span class='small'>Isikan nama pegawai/janda/duda</span>
  83. </label>
  84. <input type='text' id='anskpp' name='anskpp' class='required' minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nip')\" />
  85. <label>NIP/NRP
  86. <span class='small'>Isikan NIP/NRP pegawai</span>
  87. </label>
  88. <input type='text' id='nip' name='nip' class='required' minlength='2' maxlength='18' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'pangkat')\" />
  89. <label>Pangkat/Golongan
  90. <span class='small'>Isikan pangkat pegawai</span>
  91. </label>";
  92. $qPangkat = mysql_query("SELECT kdgol,nmgol1,nmgol2 FROM t_golongan");
  93. echo "<select name='pangkat' id='pangkat' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'alamat')\">
  94. <option selected='selected'>--Pilih Golongan/Pangkat--</option>";
  95. while($rPangkat = mysql_fetch_array($qPangkat)){
  96. $kdgol = $rPangkat['kdgol'];
  97. $nmgol1 = $rPangkat['nmgol1'];
  98. $nmgol2 = $rPangkat['nmgol2'];
  99. echo "<option value='$kdgol'>$nmgol1&nbsp;&nbsp;&nbsp;$nmgol2</option>";
  100. }
  101. echo "</select>
  102. <label>Alamat
  103. <span class='small'>Isikan alamat pegawai/janda/duda</span>
  104. </label>
  105. <input type='text' id='alamat' name='alamat' class='required' minlength='2' maxlength='45' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tgagdtrm')\" />
  106. <label>Tanggal terima SKPP
  107. <span class='small'>Isikan tanggal penerimaan SKPP</span>
  108. </label>
  109. <input type='text' id='tgagdtrm' name='tgagdtrm' class= 'required' minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tgagdsls')\" />
  110. <label>Tanggal selesai SKPP
  111. <span class='small'>Isikan tanggal penyelesaian SKPP</span>
  112. </label>
  113. <input type='text' id='tgagdsls' name='tgagdsls' class= 'required' minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  114. <input type='submit' value='Rekam' class='button' id='submit' name='Insertdatatujuanskpp' />
  115. <div class='spacer'></div>
  116. </form>
  117. </div>";
  118. }
  119. // Form insert tujuan SKPP beserta kota tujuan
  120. elseif($_POST['Insertdatatujuanskpp'] == 'Rekam'){
  121. $kdsatker = $_POST['kdsatker'];
  122. $qSatker = mysql_query("SELECT kdsatker FROM t_satker WHERE kdsatker='$kdsatker'")or die(mysql_error);
  123. $rSatker = mysql_num_rows($qSatker);
  124. // Konfirmasi muncul pop up apabila kode satker tidak ada dalam kode referensi
  125. if($rSatker < 1){
  126. echo "<script type='text/javascript'>
  127. $(document).ready(function() {
  128. $('#promptkonfirmasi').dialog({
  129. modal: true
  130. });
  131. });
  132. </script>
  133. <div id='promptkonfirmasi' title='Konfirmasi Kode Satker Data SKPP'>
  134. <center><b>Kode satker $kdsatker tidak terdaftar dalam referensi!</b></center>
  135. <br />
  136. <br />
  137. <table border='0' align='center'>
  138. <form name='form1' method='get' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  139. <tr><td><input type='hidden' name='module' value='tandaterimaskpp' /><input type='submit' name='konfirmasirekamskpp' value='Kembali' /></td>
  140. </form>";
  141. }
  142. elseif(isset($_POST['staskpp']) && $_POST['staskpp'] == '01' && isset($_POST['kdgpp']) && $_POST['kdgpp'] == '00'){
  143. echo "<script type='text/javascript'>
  144. $(document).ready(function() {
  145. $('#promptkonfirmasi').dialog({
  146. modal: true
  147. });
  148. });
  149. </script>
  150. <div id='promptkonfirmasi' title='Konfirmasi Status SKPP dengan Kode GPP'>
  151. <center><b>Status pegawai adalah PNS tetapi tidak menggunakan aplikasi GPP. Untuk PNS wajib menggunakan aplikasi GPP!</b></center>
  152. <br />
  153. <br />
  154. <table border='0' align='center'>
  155. <form name='form1' method='get' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  156. <tr><td><input type='hidden' name='module' value='tandaterimaskpp' /><input type='submit' name='konfirmasirekamskpp' value='Kembali' /></td>
  157. </form>";
  158. }
  159. else{
  160. // Jika kdjenskpp = SKPP Pindah
  161. if($_POST['kdjenskpp'] == "01"){
  162. $noagenda = $_POST['noagenda'];
  163. $kdjenskpp = $_POST['kdjenskpp'];
  164. $kdgpp = $_POST['kdgpp'];
  165. $noskpp = $_POST['noskpp'];
  166. $TgSkpp = $_POST['tgskpp'];
  167. $staskpp = $_POST['staskpp'];
  168. $anskpp = $_POST['anskpp'];
  169. $kdsatker = $_POST['kdsatker'];
  170. $nip = $_POST['nip'];
  171. $pangkat = $_POST['pangkat'];
  172. $alamat = $_POST['alamat'];
  173. $tgagdtrm = $_POST['tgagdtrm'];
  174. $tgagdsls = $_POST['tgagdsls'];
  175. echo "<div id='stylized' class='myform'>
  176. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  177. <h1>Form perekaman data SKPP</h1>
  178. <p><b>Step 2</b> - Data SKPP ini akan digunakan dalam proses penerbitan Surat Pengantar SKPP</p>
  179. <label>Kota Satker Asal
  180. <span class='small'>Isikan kota satker asal</span>
  181. </label>
  182. <input type='text' id='kotaasal' name='kotaasal' class='required' minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'kotatujuan')\" />
  183. <label>Kota Tujuan SKPP
  184. <span class='small'>Isikan kota tujuan SKPP</span>
  185. </label>
  186. <input type='text' id='kotatujuan' name='kotatujuan' class='required' minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'satkerbaru')\" />
  187. <label>Nama satker baru/tujuan
  188. <span class='small'>Isikan nama satker baru/tujuan</span>
  189. </label>
  190. <input type='text' id='satkerbaru' name='satkerbaru' class='required' minlength='2' maxlength='60' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tujuanskpp')\" />
  191. <label>KPPN Tujuan SKPP
  192. <span class='small'>Isikan KPPN tujuan SKPP</span>
  193. </label>
  194. <input type='text' id='tujuanskpp' name='tujuanskpp' class='required' minlength='2' maxlength='60' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  195. <input type='hidden' name='noagenda' value='$noagenda' />
  196. <input type='hidden' name='kdjenskpp' value='$kdjenskpp' />
  197. <input type='hidden' name='kdgpp' value='$kdgpp' />
  198. <input type='hidden' name='noskpp' value='$noskpp' />
  199. <input type='hidden' name='tgskpp' value='$TgSkpp' />
  200. <input type='hidden' name='staskpp' value='$staskpp' />
  201. <input type='hidden' name='anskpp' value='$anskpp' />
  202. <input type='hidden' name='kdsatker' value='$kdsatker' />
  203. <input type='hidden' name='nip' value='$nip' />
  204. <input type='hidden' name='pangkat' value='$pangkat' />
  205. <input type='hidden' name='alamat' value='$alamat' />
  206. <input type='hidden' name='tgagdtrm' value='$tgagdtrm' />
  207. <input type='hidden' name='tgagdsls' value='$tgagdsls' />
  208. <input type='submit' value='Rekam' class='button' id='submit' name='Insertdataskpp' />
  209. <div class='spacer'></div>
  210. </form>
  211. </div>";
  212. }
  213. // Jika kdjenskpp = SKPP Pensiun
  214. else{
  215. $noagenda = $_POST['noagenda'];
  216. $kdjenskpp = $_POST['kdjenskpp'];
  217. $kdgpp = $_POST['kdgpp'];
  218. $noskpp = $_POST['noskpp'];
  219. $TgSkpp = $_POST['tgskpp'];
  220. $staskpp = $_POST['staskpp'];
  221. $anskpp = $_POST['anskpp'];
  222. $kdsatker = $_POST['kdsatker'];
  223. $nip = $_POST['nip'];
  224. $pangkat = $_POST['pangkat'];
  225. $alamat = $_POST['alamat'];
  226. $tgagdtrm = $_POST['tgagdtrm'];
  227. $tgagdsls = $_POST['tgagdsls'];
  228. $qnmsatker= mysql_query("SELECT nmsatker FROM t_satker WHERE kdsatker='$kdsatker'")or die(mysql_error);
  229. $rnmsatker = mysql_fetch_array($qnmsatker);
  230. $nmsatker = $rnmsatker[0];
  231. echo "<div id='stylized' class='myform'>
  232. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  233. <h1>Form perekaman data SKPP</h1>
  234. <p><b>Step 2</b> - Data SKPP ini akan digunakan dalam proses penerbitan Surat Pengantar SKPP</p>
  235. <label>Kota Satker Asal
  236. <span class='small'>Isikan kota satker asal</span>
  237. </label>
  238. <input type='text' id='kotaasal' name='kotaasal' class='required' minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'kotatujuan')\" />
  239. <label>Kota Tujuan SKPP
  240. <span class='small'>Isikan kota tujuan SKPP</span>
  241. </label>
  242. <input type='text' id='kotatujuan' name='kotatujuan' class='required' minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  243. <input type='hidden' name='noagenda' value='$noagenda' />
  244. <input type='hidden' name='kdjenskpp' value='$kdjenskpp' />
  245. <input type='hidden' name='kdgpp' value='$kdgpp' />
  246. <input type='hidden' name='noskpp' value='$noskpp' />
  247. <input type='hidden' name='tgskpp' value='$TgSkpp' />
  248. <input type='hidden' name='staskpp' value='$staskpp' />
  249. <input type='hidden' name='anskpp' value='$anskpp' />
  250. <input type='hidden' name='kdsatker' value='$kdsatker' />
  251. <input type='hidden' name='nip' value='$nip' />
  252. <input type='hidden' name='pangkat' value='$pangkat' />
  253. <input type='hidden' name='alamat' value='$alamat' />
  254. <input type='hidden' name='tgagdtrm' value='$tgagdtrm' />
  255. <input type='hidden' name='tgagdsls' value='$tgagdsls' />
  256. <input type='submit' value='Rekam' class='button' id='submit' name='Insertdataskpp' />
  257. <div class='spacer'></div>
  258. </form>
  259. </div>";
  260. }
  261. }
  262. }
  263. // Action insert data SKPP dari tanda terima SKPP Seksi Sub Bagian Umum
  264. elseif($_POST['Insertdataskpp'] == 'Rekam'){
  265. $noagenda = $_POST['noagenda'];
  266. $kdjenskpp = $_POST['kdjenskpp'];
  267. $kdgpp = $_POST['kdgpp'];
  268. $noskpp = $_POST['noskpp'];
  269. $TgSkpp = $_POST['tgskpp'];
  270. $Tgskpp = explode('/',$TgSkpp);
  271. $thnskpp = $Tgskpp[2];
  272. $blnskpp = $Tgskpp[1];
  273. $tglskpp = $Tgskpp[0];
  274. $tgskpp = $thnskpp.'-'.$blnskpp.'-'.$tglskpp;
  275. $staskpp = $_POST['staskpp'];
  276. $anskpp = $_POST['anskpp'];
  277. $nip = $_POST['nip'];
  278. $pangkat = $_POST['pangkat'];
  279. $alamat = $_POST['alamat'];
  280. $kdsatker = $_POST['kdsatker'];
  281. $satkerbaru = $_POST['satkerbaru'];
  282. $kotaasal = $_POST['kotaasal'];
  283. $tujuanskpp= $_POST['tujuanskpp'];
  284. $kotatujuan = $_POST['kotatujuan'];
  285. $TgAgdtrm = $_POST['tgagdtrm'];
  286. $TgagdTrm = explode('/',$TgAgdtrm);
  287. $thntrm = $TgagdTrm[2];
  288. $blntrm = $TgagdTrm[1];
  289. $tgltrm = $TgagdTrm[0];
  290. $tgagdtrm = $thntrm.'-'.$blntrm.'-'.$tgltrm;
  291. $TgAgdsls = $_POST['tgagdsls'];
  292. $TgagdSls = explode('/',$TgAgdsls);
  293. $thnsls = $TgagdSls[2];
  294. $blnsls = $TgagdSls[1];
  295. $tglsls = $TgagdSls[0];
  296. $tgagdsls = $thnsls.'-'.$blnsls.'-'.$tglsls;
  297. $username = $_SESSION[namauser];
  298. $qkppn = mysql_query("SELECT nmkppn FROM t_kppn WHERE kddefa='1'");
  299. $rkppn = mysql_fetch_array($qkppn);
  300. $kppn = $rkppn['nmkppn'];
  301. // Jika Non GPP & Pindah (TNI Pindah SKPP akan ditujukan ke KPPN Tujuan) Status terima loket umum statproses=1
  302. if($kdgpp == "00" && $kdjenskpp == "01"){
  303. mysql_query("INSERT INTO d_skpp(noagenda,kdjenskpp,kdgpp,noskpp,tgskpp,staskpp,anskpp,nip,pangkat,alamat,kdsatker,tujuanskpp,kotatujuan,satkerbaru,kotaasal,tgagdtrm,tgagdsls,userterimaum,statproses) VALUES('$noagenda','$kdjenskpp','$kdgpp','$noskpp','$tgskpp','$staskpp','$anskpp','$nip','$pangkat','$alamat','$kdsatker','$tujuanskpp','$kotatujuan','$satkerbaru','$kotaasal','$tgagdtrm','$tgagdsls','$username','1')");
  304. }
  305. // Jika Non GPP & Pensiun (TNI Pindah SKPP akan ditujukan ke Asabri) Status terima loket umum statproses=1
  306. elseif($kdgpp == "00" && $kdjenskpp == "02"){
  307. mysql_query("INSERT INTO d_skpp(noagenda,kdjenskpp,kdgpp,noskpp,tgskpp,staskpp,anskpp,nip,pangkat,alamat,kdsatker,kotatujuan,kotaasal,tgagdtrm,tgagdsls,userterimaum,statproses) VALUES('$noagenda','$kdjenskpp','$kdgpp','$noskpp','$tgskpp','$staskpp','$anskpp','$nip','$pangkat','$alamat','$kdsatker','$kotatujuan','$kotaasal','$tgagdtrm','$tgagdsls','$username','1')");
  308. }
  309. // Jika GPP & Pindah (PNS Pindah SKPP akan ditujukan ke KPA Satker Asal) Status terima loket umum statproses=1
  310. elseif($kdgpp == "01" && $kdjenskpp == "01"){
  311. mysql_query("INSERT INTO d_skpp(noagenda,kdjenskpp,kdgpp,noskpp,tgskpp,staskpp,anskpp,nip,pangkat,alamat,kdsatker,tujuanskpp,kotatujuan,satkerbaru,kotaasal,tgagdtrm,tgagdsls,userterimaum,statproses) VALUES('$noagenda','$kdjenskpp','$kdgpp','$noskpp','$tgskpp','$staskpp','$anskpp','$nip','$pangkat','$alamat','$kdsatker','$tujuanskpp','$kotatujuan','$satkerbaru','$kotaasal','$tgagdtrm','$tgagdsls','$username','1')");
  312. }
  313. // Jika GPP & Pensiun (PNS Pensiun SKPP akan ditujukan ke KPA Satker Asal) Status terima loket umum statproses=1
  314. elseif($kdgpp == "01" && $kdjenskpp == "02"){
  315. mysql_query("INSERT INTO d_skpp(noagenda,kdjenskpp,kdgpp,noskpp,tgskpp,staskpp,anskpp,nip,pangkat,alamat,kdsatker,kotatujuan,kotaasal,tgagdtrm,tgagdsls,userterimaum,statproses) VALUES('$noagenda','$kdjenskpp','$kdgpp','$noskpp','$tgskpp','$staskpp','$anskpp','$nip','$pangkat','$alamat','$kdsatker','$kotatujuan','$kotaasal','$tgagdtrm','$tgagdsls','$username','1')");
  316. }
  317. echo "<script type='text/javascript'>
  318. $(document).ready(function() {
  319. $('#promptkonfirmasi').dialog({
  320. modal: true
  321. });
  322. });
  323. </script>
  324. <div id='promptkonfirmasi' title='Konfirmasi Entri Data SKPP'>
  325. <center><b>Data SKPP a.n. $anskpp dengan no. SKPP $noskpp berhasil direkam</b></center>
  326. <br />
  327. <br />
  328. <table border='0' align='center'>
  329. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  330. <tr><td><input type='submit' name='konfirmasirekamskpp' value='Kembali' /></td>
  331. </form>
  332. <form name='form1' method='post' action='reporttandaterimaskpp.php'>
  333. <input type='hidden' name='noagenda' value='$noagenda' />
  334. <input type='hidden' name='kdjenskpp' value='$kdjenskpp' />
  335. <input type='hidden' name='kdgpp' value='$kdgpp' />
  336. <input type='hidden' name='noskpp' value='$noskpp' />
  337. <input type='hidden' name='tgskpp' value='$TgSkpp' />
  338. <input type='hidden' name='staskpp' value='$staskpp' />
  339. <input type='hidden' name='anskpp' value='$anskpp' />
  340. <input type='hidden' name='nip' value='$nip' />
  341. <input type='hidden' name='pangkat' value='$pangkat' />
  342. <input type='hidden' name='alamat' value='$alamat' />
  343. <input type='hidden' name='kdsatker' value='$kdsatker' />
  344. <input type='hidden' name='tujuanskpp' value='$tujuanskpp' />
  345. <input type='hidden' name='kotatujuan' value='$kotatujuan' />
  346. <input type='hidden' name='username' value='$username' />
  347. <input type='hidden' name='kppn' value='$kppn' />
  348. <input type='hidden' name='tgagdtrm' value='$tgagdtrm' />
  349. <input type='hidden' name='tgagdsls' value='$tgagdsls' />
  350. <td><input type='submit' name='konfirmasirekamskpp' value='Cetak' onClick=\"this.form.target='_blank'; return true;\" /></td></tr>
  351. </form>
  352. </table>
  353. </div>";
  354. }
  355. // Tabel SKPP GPP untuk melakukan pemrosesan SKPP di Seksi Pencairan Dana GPP
  356. // GPP Pelaksana Pencairan Dana
  357. elseif($_GET['module'] == "prosesskpp"){
  358. $username = $_SESSION[namauser];
  359. echo "<div id='stylized' class='myform'>
  360. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  361. <h1>Proses SKPP</h1>
  362. <p>Proses SKPP meliputi proses edit data SKPP, cetak konsep SP SKPP, dan cetak net SP SKPP</p>
  363. </form>
  364. </div>
  365. <br />
  366. <br />
  367. <div id='normaltable'>
  368. <table class='normaltable' width='100%'>
  369. <tr>
  370. <th width='10%' height='35'>No.</th>
  371. <th width='15%'>No. Agenda</th>
  372. <th width='15%'>Tgl. Diterima</th>
  373. <th width='15%'>Nama</th>
  374. <th width='15%'>No. SKPP</th>
  375. <th width='15%'>Batas Selesai</th>
  376. <th width='15%' colspan='3'>Tindakan</th>
  377. </tr>";
  378. $qDataSkpp = mysql_query("SELECT noagenda,date_format(date(tgagdtrm),'%d-%m-%Y'),anskpp,noskpp,date_format(date(tgagdsls),'%d-%m-%Y'),date(tgagdsls),tgctkkonseppd,tgctknetpd,id_skpp,kdjenskpp,kdgpp,statproses,tujuanskpp,pangkat,userterimaum,userparafkasipd,tgparafkasipd,usertdtgnkasipd,tgtdtgnkasipd,userterimaum FROM d_skpp WHERE kdgpp='01' AND statproses!='0' AND namapengambil is null ORDER BY statproses, noagenda DESC,tgagdtrm,tgagdsls")or die(mysql_error);
  379. $no =1;
  380. $oddcol = "#CCFF99";
  381. $evencol = "#CCDD88";
  382. while($rDataSkpp = mysql_fetch_row($qDataSkpp)){
  383. if($no % 2 == 0) {$color = $evencol;}
  384. else{$color = $oddcol;}
  385. echo "<tr bgcolor='$color'>
  386. <td height='45'>$no</td>
  387. <td>$rDataSkpp[0]</td>
  388. <td>$rDataSkpp[1]</td>
  389. <td>$rDataSkpp[2]</td>
  390. <td>$rDataSkpp[3]</td>";
  391. // Apabila tanggal penyelesaian dilewati, background color berubah warna merah
  392. if(date('Y-m-d') <= $rDataSkpp[5]){
  393. echo "<td>$rDataSkpp[4]</td>";
  394. }
  395. else{
  396. echo "<td bgcolor='#FF0000'><font color='#FFFF00'><b>$rDataSkpp[4]</b></font></td>";
  397. }
  398. // Kondisi tombol yang dimunculkan berkaitan dengan status pencetakan
  399. switch($rDataSkpp[11]){
  400. // Jika status proses = 1 aktifkan tombol cetak konsep
  401. case 1:
  402. echo "<td>
  403. <form name='form1' method='post' action='report/report.php'>
  404. <input type='hidden' name='username' value='$username' />
  405. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  406. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  407. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  408. <input type='submit' class='normaltablesubmit' name='reportkonsepskpp' value='Tayang' onClick=\"this.form.target='_blank'; return true;\" />
  409. </form>
  410. </td>
  411. <td>
  412. <form name='form1' method='post' action='report/report.php'>
  413. <input type='hidden' name='username' value='$username' />
  414. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  415. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  416. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  417. <input type='submit' class='normaltablesubmit' name='reportkonsepskpp' value='Konsep' onClick=\"setTimeout('location.reload(true);',1000); this.form.target='_blank'; return true;\" />
  418. </form>
  419. </td>
  420. <td>
  421. <form method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  422. <input type='hidden' name='username' value='$username' />
  423. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  424. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  425. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  426. <input type='submit' class='normaltablesubmit' name='editSkpp' value='Edit' />
  427. </form>
  428. </td>";
  429. break;
  430. // Jika status proses = 3 paraf Kasi PD => aktifkan tombol cetak net
  431. case 3:
  432. echo "<td>
  433. <form name='form1' method='post' action='report/report.php'>";
  434. // Proses Nomor Net SP
  435. $qN = "SELECT max(nomorsuratkeluar) AS maxSklr FROM d_suratkeluar WHERE nomorsuratkeluar LIKE 'SP-%'";
  436. $qNet = mysql_query($qN);
  437. $rNet = mysql_fetch_object($qNet);
  438. $MaxSklr= explode('-',$rNet->maxSklr);
  439. $huruf = $MaxSklr[0];
  440. $angka = $MaxSklr[1];
  441. // Casting to integer
  442. $nourut = (int) substr($angka,1,5);
  443. $nourut++;
  444. // Nomor surat keluar pengantar SKPP
  445. $nomorsuratkeluar = "SP-".sprintf("%05s",$nourut);
  446. $kodesuratkeluar = "WPB.14/KP.02/2012";
  447. $newNoklr = "Nomor: ".$nomorsuratkeluar."/".$kodesuratkeluar;
  448. echo $tujuansurat;
  449. echo "
  450. <input type='hidden' name='nosurat' value='$newNoklr' />
  451. <input type='hidden' name='username' value='$username' />
  452. <input type='hidden' name='status' value='$rDataSkpp[11]' />
  453. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  454. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  455. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  456. <input type='submit' class='normaltablesubmit' name='reportkonsepskpp' value='Tayang' onClick=\"this.form.target='_blank'; return true;\" />
  457. </form>
  458. </td>
  459. <td>
  460. <form method='post' action='report/report.php'>
  461. <input type='hidden' name='username' value='$username' />";
  462. // Proses Nomor Net SP
  463. $qN = "SELECT max(nomorsuratkeluar) AS maxSklr FROM d_suratkeluar WHERE nomorsuratkeluar LIKE 'SP-%'";
  464. $qNet = mysql_query($qN);
  465. $rNet = mysql_fetch_object($qNet);
  466. $MaxSklr= explode('-',$rNet->maxSklr);
  467. $huruf = $MaxSklr[0];
  468. $angka = $MaxSklr[1];
  469. // Casting to integer
  470. $nourut = (int) substr($angka,1,5);
  471. $nourut++;
  472. // Preparing to insert into SKPP table and suratmasuk table
  473. // Nomor surat keluar pengantar SKPP
  474. $nomorsuratkeluar = "SP-".sprintf("%05s",$nourut);
  475. $kodesuratkeluar = "WPB.14/KP.02/2012";
  476. // Preparing to update table d_skpp(nospskpp) where noagdskpp
  477. $nospskpp = $nomorsuratkeluar."/".$kodesuratkeluar;
  478. $newNoklr = "Nomor: ".$nomorsuratkeluar."/".$kodesuratkeluar;
  479. $tujuansurat = $rDataSkpp[12];
  480. // Preparing to update table d_skpp(tgspskpp) where noagdskpp and d_suratkeluar
  481. $tglsurat = date('Y-m-d');
  482. $perihal = "SKPP a.n. ".$rDataSkpp[2];
  483. $userpelaksana = $rDataSkpp[14];
  484. $Timepelaksana = new DateTime;
  485. $timepelaksana = $Timepelaksana->format('Y-m-d H:i:s');
  486. $userkasi = $rDataSkpp[15];
  487. $timekasi = $rDataSkpp[16];
  488. $userpejabat = $rDataSkpp[17];
  489. $timepejabat = $rDataSkpp[18];
  490. $usertrmsekret = $rDataSkpp[19];
  491. $Timetrmsekret = new DateTime($rDataSkpp[1]);
  492. $timetrmsekret = $Timetrmsekret->format('Y-m-d H:i:s');
  493. $nomorsuratmasuk = $rDataSkpp[0];
  494. echo "
  495. <input type='hidden' name='nomorsuratkeluar' value='$nomorsuratkeluar' />
  496. <input type='hidden' name='kodesuratkeluar' value='$kodesuratkeluar' />
  497. <input type='hidden' name='tujuansurat' value='$tujuansurat' />
  498. <input type='hidden' name='tglsurat' value='$tglsurat' />
  499. <input type='hidden' name='perihal' value='$perihal' />
  500. <input type='hidden' name='userpelaksana' value='$userpelaksana' />
  501. <input type='hidden' name='timepelaksana' value='$timepelaksana' />
  502. <input type='hidden' name='userkasi' value='$userkasi' />
  503. <input type='hidden' name='timekasi' value='$timekasi' />
  504. <input type='hidden' name='userpejabat' value='$userpejabat' />
  505. <input type='hidden' name='timetrmpejabat' value='$timepejabat' />
  506. <input type='hidden' name='usertrmsekret' value='$usertrmsekret' />
  507. <input type='hidden' name='timetrmsekret' value='$timetrmsekret' />
  508. <input type='hidden' name='nomorsuratmasuk' value='$nomorsuratmasuk' />
  509. <input type='hidden' name='nospskpp' value='$nospskpp' />
  510. <input type='hidden' name='tgspskpp' value='$tglsurat' />
  511. <input type='hidden' name='noagenda' value='$nomorsuratmasuk' />
  512. <input type='hidden' name='nosurat' value='$newNoklr' />
  513. <input type='hidden' name='username' value='$username' />
  514. <input type='hidden' name='status' value='$rDataSkpp[11]' />
  515. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  516. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  517. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  518. <input type='submit' class='normaltablesubmit' name='reportnetskpp' value='Net' onClick=\"setTimeout('location.reload(true);',1000); this.form.target='_blank';return true;\" />
  519. </form>
  520. </td>
  521. <td>
  522. <form method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  523. <input type='hidden' name='username' value='$username' />
  524. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  525. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  526. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  527. <input type='submit' class='normaltablesubmit' name='editSkpp' value='Edit' />
  528. </form>
  529. </td>";
  530. break;
  531. // Jika status proses = 2 cetak konsep PD
  532. case 2:
  533. echo "<td width='15%' colspan='2'>Cetak konsep</td>
  534. <td>
  535. <form method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  536. <input type='hidden' name='username' value='$username' />
  537. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  538. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  539. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  540. <input type='submit' class='normaltablesubmit' name='editSkpp' value='Edit' />
  541. </form>
  542. </td>";
  543. break;
  544. // Jika status proses = 4 cetak net PD
  545. case 4:
  546. echo "<td colspan='3'>Cetak net</td>";
  547. break;
  548. // Jika status proses = 5 tdtangan net Kasi PD
  549. case 5:
  550. echo "<td colspan='3'>Td.Tgn.Kasi.PD</td>";
  551. break;
  552. // Jika status proses = 6 split Sub Bagian Umum
  553. case 6:
  554. echo "<td colspan='3'>Split SKPP</td>";
  555. break;
  556. // Jika status proses = 7 Loket Pengambilan Sub Bagian Umum
  557. case 7:
  558. echo "<td colspan='3'>Loket pengambilan</td>";
  559. break;
  560. }
  561. echo "</tr>";
  562. $no++;
  563. }
  564. echo "</table>
  565. </div>
  566. </form>";
  567. }
  568. // Tabel SKPP Non GPP untuk melakukan pemrosesan SKPP di Seksi Pencairan Dana Non GPP
  569. // Non GPP Pelaksana Pencairan Dana
  570. elseif($_GET['module'] == "prosesskppn"){
  571. $username = $_SESSION[namauser];
  572. echo "<div id='stylized' class='myform'>
  573. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  574. <h1>Proses SKPP</h1>
  575. <p>Proses SKPP meliputi proses edit data SKPP, cetak konsep SP SKPP, dan cetak net SP SKPP</p>
  576. </form>
  577. </div>
  578. <br />
  579. <br />
  580. <br />
  581. <br />
  582. <div id='normaltable'>
  583. <table class='normaltable' width='100%'>
  584. <tr>
  585. <th width='10%' height='35'>No.</th>
  586. <th width='15%'>No. Agenda</th>
  587. <th width='15%'>Tgl. Diterima</th>
  588. <th width='15%'>Nama</th>
  589. <th width='15%'>No. SKPP</th>
  590. <th width='15%'>Batas Selesai</th>
  591. <th width='15%' colspan='3'>Tindakan</th>
  592. </tr>";
  593. $qDataSkpp = mysql_query("SELECT noagenda,date_format(date(tgagdtrm),'%d-%m-%Y'),anskpp,noskpp,date_format(date(tgagdsls),'%d-%m-%Y'),date(tgagdsls),tgctkkonseppd,tgctknetpd,id_skpp,kdjenskpp,kdgpp,statproses FROM d_skpp WHERE kdgpp='00' AND statproses!='0' AND namapengambil is null ORDER BY statproses,noagenda DESC,tgagdtrm,tgagdsls")or die(mysql_error);
  594. $no =1;
  595. $oddcol = "#CCFF99";
  596. $evencol = "#CCDD88";
  597. while($rDataSkpp = mysql_fetch_row($qDataSkpp)){
  598. if($no % 2 == 0) {$color = $evencol;}
  599. else{$color = $oddcol;}
  600. echo "<tr bgcolor='$color'>
  601. <td height='35'>$no</td>
  602. <td>$rDataSkpp[0]</td>
  603. <td>$rDataSkpp[1]</td>
  604. <td>$rDataSkpp[2]</td>
  605. <td>$rDataSkpp[3]</td>";
  606. // Apabila tanggal penyelesaian dilewati, background color berubah warna merah
  607. if(date('Y-m-d') <= $rDataSkpp[5]){
  608. echo "<td>$rDataSkpp[4]</td>";
  609. }
  610. else{
  611. echo "<td bgcolor='#FF0000'><font color='#FFFF00'><b>$rDataSkpp[4]</b></font></td>";
  612. }
  613. // Kondisi tombol yang dimunculkan berkaitan dengan status pencetakan
  614. switch($rDataSkpp[11]){
  615. // Jika status proses = 1 aktifkan tombol cetak konsep
  616. case 1:
  617. echo "<td>
  618. <form name='form1' method='post' action='report/report.php'>
  619. <input type='hidden' name='username' value='$username' />
  620. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  621. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  622. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  623. <input type='submit' class='normaltablesubmit' name='reportkonsepskpp' value='Tayang' onClick=\"this.form.target='_blank'; return true;\" />
  624. </form>
  625. </td>
  626. <td>
  627. <form name='form1' method='post' action='report/report.php'>
  628. <input type='hidden' name='username' value='$username' />
  629. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  630. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  631. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  632. <input type='submit' class='normaltablesubmit' name='reportkonsepskpp' value='Konsep' onClick=\"setTimeout('location.reload(true);',1000); this.form.target='_blank'; return true;\" />
  633. </form>
  634. </td>
  635. <td>
  636. <form method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  637. <input type='hidden' name='username' value='$username' />
  638. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  639. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  640. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  641. <input type='submit' class='normaltablesubmit' name='editSkpp' value='Edit' />
  642. </form>
  643. </td>";
  644. break;
  645. // Jika status proses = 3 paraf Kasi PD => aktifkan tombol cetak net
  646. case 3:
  647. echo "<td>
  648. <form name='form1' method='post' action='report/report.php'>
  649. <input type='hidden' name='username' value='$username' />
  650. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  651. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  652. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  653. <input type='submit' class='normaltablesubmit' name='reportkonsepskpp' value='Tayang' onClick=\"this.form.target='_blank'; return true;\" />
  654. </form>
  655. </td>
  656. <td>
  657. <form method='post' action='report/report.php'>
  658. <input type='hidden' name='username' value='$username' />
  659. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  660. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  661. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  662. <input type='submit' class='normaltablesubmit' name='reportnetskpp' value='Net' onClick=\"setTimeout('location.reload(true);',1000); this.form.target='_blank'; return true;\" />
  663. </form>
  664. </td>
  665. <td>
  666. <form method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  667. <input type='hidden' name='username' value='$username' />
  668. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  669. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  670. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  671. <input type='submit' class='normaltablesubmit' name='editSkpp' value='Edit' />
  672. </form>
  673. </td>";
  674. break;
  675. // Jika status proses = 2 cetak konsep PD
  676. case 2:
  677. echo "<td width='15%' colspan='2'>Cetak konsep</td>
  678. <td>
  679. <form method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  680. <input type='hidden' name='username' value='$username' />
  681. <input type='hidden' name='kdgpp' value='$rDataSkpp[10]' />
  682. <input type='hidden' name='kdjenskpp' value='$rDataSkpp[9]' />
  683. <input type='hidden' name='idSkpp' value='$rDataSkpp[8]' />
  684. <input type='submit' class='normaltablesubmit' name='editSkpp' value='Edit' />
  685. </form>
  686. </td>";
  687. break;
  688. // Jika status proses = 4 cetak net PD
  689. case 4:
  690. echo "<td colspan='3'>Cetak net</td>";
  691. break;
  692. // Jika status proses = 5 tdtangan net Kasi PD
  693. case 5:
  694. echo "<td colspan='3'>Td.Tgn.Kasi.PD</td>";
  695. break;
  696. // Jika status proses = 6 split Sub Bagian Umum
  697. case 6:
  698. echo "<td colspan='3'>Split SKPP</td>";
  699. break;
  700. // Jika status proses = 7 Loket Pengambilan Sub Bagian Umum
  701. case 7:
  702. echo "<td colspan='3'>Loket pengambilan</td>";
  703. break;
  704. }
  705. echo "</tr>";
  706. $no++;
  707. }
  708. echo "</table>
  709. </div>
  710. </form>";
  711. }
  712. // Tabel SKPP GPP untuk melakukan pemrosesan SKPP oleh KEPALA SEKSI PENCAIRAN DANA
  713. // GPP Kepala Seksi Pencairan Dana
  714. elseif($_GET['module'] == "proseskasiskppgpp"){
  715. $username = $_SESSION[namauser];
  716. echo "<div id='stylized' class='myform'>
  717. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  718. <h1>Proses SKPP oleh Kepala Kantor/Kepala Seksi Pencairan Dana</h1>
  719. <p>Proses SKPP oleh Kepala Kantor/Kasi. Pencairan Dana meliputi proses paraf konsep SP SKPP dan tanda tangan net SP SKPP</p>
  720. </form>
  721. </div>
  722. <br />
  723. <br />
  724. <div id='normaltable'>
  725. <table class='normaltable' width='100%'>
  726. <tr>
  727. <th width='10%' width='35'>No.</th>
  728. <th width='15%'>No. Agenda</th>
  729. <th width='15%'>Tgl. Diterima</th>
  730. <th width='15%'>Nama</th>
  731. <th width='15%'>No. SKPP</th>
  732. <th width='15%'>Batas Selesai</th>
  733. <th width='15%' colspan='3'>Tindakan</th>
  734. </tr>";
  735. $qDataSkpp = mysql_query("SELECT noagenda,date_format(date(tgagdtrm),'%d-%m-%Y') AS tgagdtrm,anskpp,noskpp,date_format(date(tgagdsls),'%d-%m-%Y') AS tgagdsls ,date(tgagdsls) AS batasselesai,tgctkkonseppd,tgctknetpd,id_skpp,kdjenskpp,kdgpp,statproses FROM d_skpp WHERE kdgpp='01' AND statproses!='0' AND namapengambil is null ORDER BY statproses,noagenda DESC,tgagdtrm,tgagdsls")or die(mysql_error);
  736. $no =1;
  737. $oddcol = "#CCFF99";
  738. $evencol = "#CCDD88";
  739. while($rDataSkpp = mysql_fetch_array($qDataSkpp)){
  740. if($no % 2 == 0) {$color = $evencol;}
  741. else{$color = $oddcol;}
  742. $idSkpp = $rDataSkpp['id_skpp'];
  743. $noagenda = $rDataSkpp['noagenda'];
  744. $tgagdtrm = $rDataSkpp['tgagdtrm'];
  745. $anskpp = $rDataSkpp['anskpp'];
  746. $tgagdsls = $rDataSkpp['tgagdsls'];
  747. $batassls = $rDataSkpp['batasselesai'];
  748. $tgctkkonsppd = $rDataSkpp['tgctkkonseppd'];
  749. $tgctknetpd = $rDataSkpp['tgctknetpd'];
  750. $kdjenskpp = $rDataSkpp['kdjenskpp'];
  751. $kdgpp = $rDataSkpp['kdgpp'];
  752. $statproses = $rDataSkpp['statproses'];
  753. echo "<tr bgcolor='$color'>
  754. <td width='35'>$no</td>
  755. <td>$noagenda</td>
  756. <td>$tgagdtrm</td>
  757. <td>$anskpp</td>
  758. <td>$tgagdsls</td>";
  759. // Apabila tanggal penyelesaian dilewati, background color berubah warna merah
  760. if(date('Y-m-d') <= $batassls){
  761. echo "<td>$tgagdsls</td>";
  762. }
  763. else{
  764. echo "<td bgcolor='#FF0000'><font color='#FFFF00'><b>$tgagdsls</b></font></td>";
  765. }
  766. // Kondisi tombol yang dimunculkan berkaitan dengan status pencetakan
  767. switch($statproses){
  768. // Jika status proses = 2 cetak konsep PD => paraf konsep SP SKPP
  769. case 2:
  770. echo "<td>
  771. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  772. <input type='hidden' name='username' value='$username' />
  773. <input type='hidden' name='kdgpp' value='$kdgpp' />
  774. <input type='hidden' name='kdjenskpp' value='$kdjenskpp' />
  775. <input type='hidden' name='idSkpp' value='$idSkpp' />
  776. <input type='submit' class='normaltablesubmit' name='parafskpp' value='Paraf' onClick=\"setTimeout('location.reload(true);',1000); return true;\" />
  777. </form>
  778. </td>";
  779. break;
  780. // Jika status proses = 4 cetak net PD => tanda tangan net SP SKPP
  781. case 4:
  782. echo "<td>
  783. <form method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  784. <input type='hidden' name='username' value='$username' />
  785. <input type='hidden' name='kdgpp' value='$kdgpp' />
  786. <input type='hidden' name='kdjenskpp' value='$kdjenskpp' />
  787. <input type='hidden' name='idSkpp' value='$idSkpp' />
  788. <input type='submit' class='normaltablesubmit' name='tandatanganskpp' value='T.Tangan' onClick=\"setTimeout('location.reload(true);',1000); this.form.target='_blank'; return true;\" />
  789. </form>
  790. </td>";
  791. break;
  792. case 1:
  793. echo "<td colspan='2'>Terima di Loket Umum</td>";
  794. break;
  795. case 3:
  796. echo "<td colspan='2'>Paraf KK/Kasi. PD</td>";
  797. break;
  798. case 5:
  799. echo "<td colspan='2'>TdTgn.KK/Kasi. PD</td>";
  800. break;
  801. case 6:
  802. echo "<td colspan='2'>Split SKPP</td>";
  803. break;
  804. }
  805. echo "</tr>";
  806. $no++;
  807. }
  808. echo "</table>
  809. </div>
  810. </form>";
  811. }
  812. // Tabel SKPP Non GPP untuk melakukan pemrosesan SKPP oleh KEPALA KANTOR
  813. // Non GPP diproses langsung ke Kepala Kantor
  814. elseif($_GET['module'] == "proseskasiskppnongpp"){
  815. $username = $_SESSION[namauser];
  816. echo "<div id='stylized' class='myform'>
  817. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  818. <h1>Proses SKPP oleh Kepala Seksi Pencairan Dana</h1>
  819. <p>Proses SKPP oleh Kasi. Pencairan Dana meliputi proses paraf konsep SP SKPP dan tanda tangan net SP SKPP</p>
  820. </form>
  821. </div>
  822. <br />
  823. <br />
  824. <div id='normaltable'>
  825. <table class='normaltable' width='100%'>
  826. <tr>
  827. <th width='10%' height='35'>No.</th>
  828. <th width='15%'>No. Agenda</th>
  829. <th width='15%'>Tgl. Diterima</th>
  830. <th width='15%'>Nama</th>
  831. <th width='15%'>No. SKPP</th>
  832. <th width='15%'>Batas Selesai</th>
  833. <th width='15%' colspan='3'>Tindakan</th>
  834. </tr>";
  835. $qDataSkpp = mysql_query("SELECT noagenda,date_format(date(tgagdtrm),'%d-%m-%Y') AS tgagdtrm,anskpp,noskpp,date_format(date(tgagdsls),'%d-%m-%Y') AS tgagdsls ,date(tgagdsls) AS batasselesai,tgctkkonseppd,tgctknetpd,id_skpp,kdjenskpp,kdgpp,statproses FROM d_skpp WHERE kdgpp='00' AND statproses!='0' AND namapengambil is null ORDER BY statproses,noagenda DESC,tgagdtrm,tgagdsls")or die(mysql_error);
  836. $no =1;
  837. $oddcol = "#CCFF99";
  838. $evencol = "#CCDD88";
  839. while($rDataSkpp = mysql_fetch_array($qDataSkpp)){
  840. if($no % 2 == 0) {$color = $evencol;}
  841. else{$color = $oddcol;}
  842. $idSkpp = $rDataSkpp['id_skpp'];
  843. $noagenda = $rDataSkpp['noagenda'];
  844. $tgagdtrm = $rDataSkpp['tgagdtrm'];
  845. $anskpp = $rDataSkpp['anskpp'];
  846. $tgagdsls = $rDataSkpp['tgagdsls'];
  847. $batassls = $rDataSkpp['batasselesai'];
  848. $tgctkkonsppd = $rDataSkpp['tgctkkonseppd'];
  849. $tgctknetpd = $rDataSkpp['tgctknetpd'];
  850. $kdjenskpp = $rDataSkpp['kdjenskpp'];
  851. $kdgpp = $rDataSkpp['kdgpp'];
  852. $statproses = $rDataSkpp['statproses'];
  853. echo "<tr bgcolor='$color'>
  854. <td height='35'>$no</td>
  855. <td>$noagenda</td>
  856. <td>$tgagdtrm</td>
  857. <td>$anskpp</td>
  858. <td>$tgagdsls</td>";
  859. // Apabila tanggal penyelesaian dilewati, background color berubah warna merah
  860. if(date('Y-m-d') <= $batassls){
  861. echo "<td>$tgagdsls</td>";
  862. }
  863. else{
  864. echo "<td bgcolor='#FF0000'><font color='#FFFF00'><b>$tgagdsls</b></font></td>";
  865. }
  866. // Kondisi tombol yang dimunculkan berkaitan dengan status pencetakan
  867. switch($statproses){
  868. // Jika status proses = 2 cetak konsep PD => paraf konsep SP SKPP
  869. case 2:
  870. echo "<td>
  871. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  872. <input type='hidden' name='username' value='$username' />
  873. <input type='hidden' name='kdgpp' value='$kdgpp' />
  874. <input type='hidden' name='kdjenskpp' value='$kdjenskpp' />
  875. <input type='hidden' name='idSkpp' value='$idSkpp' />
  876. <input type='submit' class='normaltablesubmit' name='parafskpp' value='Paraf' onClick=\"setTimeout('location.reload(true);',1000); return true;\" />
  877. </form>
  878. </td>";
  879. break;
  880. // Jika status proses = 4 cetak net PD => tanda tangan net SP SKPP
  881. case 4:
  882. echo "<td>
  883. <form method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  884. <input type='hidden' name='username' value='$username' />
  885. <input type='hidden' name='kdgpp' value='$kdgpp' />
  886. <input type='hidden' name='kdjenskpp' value='$kdjenskpp' />
  887. <input type='hidden' name='idSkpp' value='$idSkpp' />
  888. <input type='submit' class='normaltablesubmit' name='tandatanganskpp' value='T.Tangan' onClick=\"setTimeout('location.reload(true);',1000); this.form.target='_blank'; return true;\" />
  889. </form>
  890. </td>";
  891. break;
  892. // Jika status proses = 1 terima loket umum
  893. case 1:
  894. echo "<td colspan='2'>Terima di Loket Umum</td>";
  895. break;
  896. case 3:
  897. echo "<td colspan='2'>Paraf KK/Kasi. PD</td>";
  898. break;
  899. case 5:
  900. echo "<td colspan='2'>Td.Tgn.KK/Kasi. PD</td>";
  901. break;
  902. case 6:
  903. echo "<td colspan='2'>Split SKPP</td>";
  904. break;
  905. }
  906. echo "</tr>";
  907. $no++;
  908. }
  909. echo "</table>
  910. </div>
  911. </form>";
  912. }
  913. // Tabel SKPP GPP untuk menunjukkan proses splitting SKPP oleh Sub Bagian Umum
  914. // GPP Pelaksana Sub Bagian Umum
  915. elseif($_GET['module'] == "prosessplitskppgpp"){
  916. $username = $_SESSION[namauser];
  917. echo "<div id='stylized' class='myform'>
  918. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  919. <h1>Splitting SKPP oleh Pelaksana Sub Bagian Umum</h1>
  920. <p>Splitting SKPP oleh pelaksana sub bagian umum</p>
  921. </form>
  922. </div>
  923. <br />
  924. <br />
  925. <div id='normaltable'>
  926. <table class='normaltable' width='100%'>
  927. <tr>
  928. <th width='10%' height='35'>No.</th>
  929. <th width='15%'>No. Agenda</th>
  930. <th width='15%'>Tgl. Diterima</th>
  931. <th width='15%'>Nama</th>
  932. <th width='15%'>No. SKPP</th>
  933. <th width='15%'>Batas Selesai</th>
  934. <th width='15%' colspan='3'>Tindakan</th>
  935. </tr>";
  936. $qDataSkpp = mysql_query("SELECT noagenda,date_format(date(tgagdtrm),'%d-%m-%Y') AS tgagdtrm,anskpp,noskpp,date_format(date(tgagdsls),'%d-%m-%Y') AS tgagdsls ,date(tgagdsls) AS batasselesai,tgctkkonseppd,tgctknetpd,id_skpp,kdjenskpp,kdgpp,statproses FROM d_skpp WHERE kdgpp='01' AND statproses!='0' AND namapengambil is null ORDER BY noagenda DESC,tgagdtrm,tgagdsls")or die(mysql_error);
  937. $no =1;
  938. $oddcol = "#CCFF99";
  939. $evencol = "#CCDD88";
  940. while($rDataSkpp = mysql_fetch_array($qDataSkpp)){
  941. if($no % 2 == 0) {$color = $evencol;}
  942. else{$color = $oddcol;}
  943. $idSkpp = $rDataSkpp['id_skpp'];
  944. $noagenda = $rDataSkpp['noagenda'];
  945. $tgagdtrm = $rDataSkpp['tgagdtrm'];
  946. $anskpp = $rDataSkpp['anskpp'];
  947. $tgagdsls = $rDataSkpp['tgagdsls'];
  948. $batassls = $rDataSkpp['batasselesai'];
  949. $tgctkkonsppd = $rDataSkpp['tgctkkonseppd'];
  950. $tgctknetpd = $rDataSkpp['tgctknetpd'];
  951. $kdjenskpp = $rDataSkpp['kdjenskpp'];
  952. $kdgpp = $rDataSkpp['kdgpp'];
  953. $statproses = $rDataSkpp['statproses'];
  954. echo "<tr bgcolor='$color'>
  955. <td height='35'>$no</td>
  956. <td>$noagenda</td>
  957. <td>$tgagdtrm</td>
  958. <td>$anskpp</td>
  959. <td>$tgagdsls</td>";
  960. // Apabila tanggal penyelesaian dilewati, background color berubah warna merah
  961. if(date('Y-m-d') <= $batassls){
  962. echo "<td>$tgagdsls</td>";
  963. }
  964. else{
  965. echo "<td bgcolor='#FF0000'><font color='#FFFF00'><b>$tgagdsls</b></font></td>";
  966. }
  967. // Kondisi tombol yang dimunculkan berkaitan dengan status pencetakan
  968. switch($statproses){
  969. // Jika status proses = 5 tandatangan net Kasi PD => split SP SKPP
  970. case 5:
  971. echo "<td>
  972. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  973. <input type='hidden' name='username' value='$username' />
  974. <input type='hidden' name='kdgpp' value='$kdgpp' />
  975. <input type='hidden' name='kdjenskpp' value='$kdjenskpp' />
  976. <input type='hidden' name='idSkpp' value='$idSkpp' />
  977. <input type='submit' class='normaltablesubmit' name='splitskpp' value='Split' onClick=\"setTimeout('location.reload(true);',1000); return true;\" />
  978. </form>
  979. </td>";
  980. break;
  981. // Jika status proses = 6 split umum => loket pengambilan SP SKPP
  982. case 6:
  983. echo "<td>
  984. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  985. <input type='hidden' name='username' value='$username' />
  986. <input type='hidden' name='kdgpp' value='$kdgpp' />
  987. <input type='hidden' name='kdjenskpp' value='$kdjenskpp' />
  988. <input type='hidden' name='idSkpp' value='$idSkpp' />
  989. <input type='submit' class='normaltablesubmit' name='pengambilanskpp' value='Ambil' onClick=\"setTimeout('location.reload(true);',1000); this.form.target='_blank'; return true;\" />
  990. </form>
  991. </td>";
  992. break;
  993. case 1:
  994. echo "<td>Terima di Loket Umum</td>";
  995. break;
  996. case 2:
  997. echo "<td>Cetak Konsep</td>";
  998. break;
  999. // Status paraf KK atau Kasi
  1000. case 3:
  1001. echo "<td>Paraf KK/Kasi.PD</td>";
  1002. break;
  1003. // Status cetak net SP SKPP
  1004. case 4:
  1005. echo "<td>Cetak Net</td>";
  1006. break;
  1007. // Status tanda tangan KK atau Kasi
  1008. case 5:
  1009. echo "<td>Td.Tgn KK/Kasi.PD</td>";
  1010. break;
  1011. }
  1012. echo "</tr>";
  1013. $no++;
  1014. }
  1015. echo "</table>
  1016. </div>
  1017. </form>";
  1018. }
  1019. // Tabel SKPP Non GPP untuk menunjukkan proses splitting SKPP oleh Sub Bagian Umum
  1020. // Non GPP Pelaksana Sub Bagian Umum
  1021. elseif($_GET['module'] == "prosessplitskppnongpp"

Large files files are truncated, but you can click here to view the full file