PageRenderTime 36ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 1ms

/kirisurat.php

https://bitbucket.org/metamorph/kppnadministration
PHP | 2145 lines | 1867 code | 219 blank | 59 comment | 129 complexity | c61e2e815e30133c035a5cb0596e9a5d MD5 | raw file
Possible License(s): GPL-2.0
  1. <?php
  2. global $timezone;
  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. // Modul perekaman data surat masuk secara manual
  9. elseif($_GET['module'] == 'terimasuratmasukmanual'){
  10. echo "<style type='text/css'>
  11. em { font-weight: bold; padding-right: 1em; vertical-align: top; }
  12. </style>
  13. <script>
  14. $(document).ready(function(){
  15. $('#form').validate();
  16. $('#tanggal').datepicker();
  17. });
  18. </script>
  19. <div id='stylized' class='myform'>
  20. <form id='form' name='form' method='post' enctype='multipart/form-data' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  21. <h1>Form perekaman data surat masuk manual</h1>
  22. <p>Data Surat Masuk Manual</p>
  23. <label>Nomor Agenda
  24. <span class='small'>Agd suratmasuk cth:1 atau 12</span>
  25. </label>
  26. <input type='text' id='noagenda' class='required' minlength='1' name='noagendaman' maxlength='10' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'nomorsuratmasuk')\" />
  27. <label>Nomor Surat
  28. <span class='small'>Isikan no.surat masuk</span>
  29. </label>
  30. <input type='text' id='nomorsuratmasuk' class='required' minlength='3' name='nomorsuratmasuk' maxlength='50' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tglsurat')\" />
  31. <label>Tanggal Surat
  32. <span class='small'>Isikan tgl.surat masuk</span>
  33. </label>
  34. <input type='text' id='tanggal' name='tglsurat' class= 'required' minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'asalsurat')\" />
  35. <label>Asal Surat
  36. <span class='small'>Isikan asal surat masuk</span>
  37. </label>
  38. <input type='text' id='asalsurat' name='asalsurat' class='required' minlength='1' maxlength='50' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tujuansurat')\" />
  39. <label>Tujuan Surat
  40. <span class='small'>Isikan tujuan surat masuk</span>
  41. </label>
  42. <input type='text' id='tujuansurat' name='tujuansurat' class='required' minlength='3' maxlength='50' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'perihal')\" />
  43. <label>Perihal
  44. <span class='small'>Isikan perihal surat masuk</span>
  45. </label>
  46. <input type='text' id='perihal' name='perihal' class='required' minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'file')\" />
  47. <label>Upload Surat
  48. <span class='small'>Pilih file surat masuk yang telah di-<i>scanning</i> (tanpa spasi)</span>
  49. </label>
  50. <input type='file' id='file' name='file' minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  51. <input type='submit' value='Rekam' class='button' id='submit' name='Insertdatasuratmasuk' />
  52. <div class='spacer'></div>
  53. </form>
  54. </div>";
  55. }
  56. // Modul Rekam Data Surat Masuk ==================================================================================//
  57. elseif($_GET['module']=='terimasuratmasuk'){
  58. $qMaxagd = mysql_query("SELECT MAX(noagenda) maxAgd FROM d_suratmasuk");
  59. $rMaxagd = mysql_fetch_array($qMaxagd);
  60. //penambahan setiap nomor agenda
  61. $noagd = $rMaxagd['maxAgd'];
  62. //kode nomor agenda, you can change here
  63. $jenAgd = 'AGD';
  64. $noUrut = (int) $noagd;
  65. $noUrut++;
  66. //hasil akhir nomor agenda
  67. $newAgd = $jenAgd.'-'.sprintf("%05s",$noUrut);
  68. echo "<style type='text/css'>
  69. em { font-weight: bold; padding-right: 1em; vertical-align: top; }
  70. </style>
  71. <script>
  72. $(document).ready(function(){
  73. $('#form').validate();
  74. $('#tanggal').datepicker();
  75. });
  76. </script>
  77. <div id='stylized' class='myform'>
  78. <form id='form' name='form' method='post' enctype='multipart/form-data' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  79. <h1>Form perekaman data surat masuk</h1>
  80. <p>Data Surat Masuk</p>
  81. <label>Nomor Agenda
  82. <span class='small'>Nomor agenda</span>
  83. </label>
  84. <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,'nomorsuratmasuk')\" />
  85. <label>Nomor Surat
  86. <span class='small'>Isikan no.surat masuk</span>
  87. </label>
  88. <input type='text' id='nomorsuratmasuk' class='required' minlength='3' name='nomorsuratmasuk' maxlength='50' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tglsurat')\" />
  89. <label>Tanggal Surat
  90. <span class='small'>Isikan tgl.surat masuk</span>
  91. </label>
  92. <input type='text' id='tanggal' name='tglsurat' class= 'required' minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'asalsurat')\" />
  93. <label>Asal Surat
  94. <span class='small'>Isikan asal surat masuk</span>
  95. </label>
  96. <input type='text' id='asalsurat' name='asalsurat' class='required' minlength='1' maxlength='50' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tujuansurat')\" />
  97. <label>Tujuan Surat
  98. <span class='small'>Isikan tujuan surat masuk</span>
  99. </label>
  100. <input type='text' id='tujuansurat' name='tujuansurat' class='required' minlength='3' maxlength='50' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'perihal')\" />
  101. <label>Perihal
  102. <span class='small'>Isikan perihal surat masuk</span>
  103. </label>
  104. <input type='text' id='perihal' name='perihal' class='required' minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'file')\" />
  105. <label>Upload Surat
  106. <span class='small'>Pilih file surat masuk yang telah di-<i>scanning</i> (tanpa spasi)</span>
  107. </label>
  108. <input type='file' id='file' name='file' minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  109. <input type='submit' value='Rekam' class='button' id='submit' name='Insertdatasuratmasuk' />
  110. <div class='spacer'></div>
  111. </form>
  112. </div>";
  113. }
  114. // Modul Form Perekaman Data Surat Masuk -----------------------------------------------------------------------------------------------------------------------------//
  115. elseif($_POST['Insertdatasuratmasuk'] == 'Rekam'){
  116. $NoAgenda = explode("-",$_POST['noagenda']);
  117. $kodeagenda = $NoAgenda[0];
  118. $noagenda = $NoAgenda[1];
  119. if($_POST['noagendaman']){
  120. $noagenda = sprintf("%05s",$_POST['noagendaman']);
  121. $kodeagenda = "AGD";
  122. }
  123. $nosuratmasuk = $_POST['nomorsuratmasuk'];
  124. $asalsurat = $_POST['asalsurat'];
  125. $tujuansurat = $_POST['tujuansurat'];
  126. $Tglsurat = $_POST['tglsurat'];
  127. $tglsurat = $helper->dateConvert($Tglsurat);
  128. $perihal = $_POST['perihal'];
  129. $username = $_SESSION[namauser];
  130. $timeloket = date("Y-m-d H:i:s");
  131. $lokasi_file =$_FILES['file']['tmp_name'];
  132. $nama_file =$_FILES['file']['name'];
  133. //statproses = 1 -- terima loket umum
  134. mysql_query("INSERT INTO d_suratmasuk(kodeagenda,noagenda,nomorsuratmasuk,asalsurat,tujuansurat,tglsurat,perihal,userloket,timeloket,file,statproses)
  135. VALUES('$kodeagenda','$noagenda','$nosuratmasuk','$asalsurat','$tujuansurat','$tglsurat','$perihal','$username','$timeloket','$nama_file','1')");
  136. // Setting untuk Unix/Linux, untuk windows silakan disesuaikan
  137. $direktori ='suratmasuk/'.basename($nama_file);
  138. move_uploaded_file($lokasi_file,$direktori);
  139. echo "<script type='text/javascript'>
  140. $(document).ready(function() {
  141. $('#promptkonfirmasi').dialog({
  142. modal: true
  143. });
  144. });
  145. </script>
  146. <div id='promptkonfirmasi' title='Konfirmasi Entri Data Surat Masuk'>
  147. <center><b>Data surat masuk dengan nomor surat: <font color='#ffff00'><i>" . $nosuratmasuk . "</i></font> dan perihal <font color='#ffff00'><i>" . $perihal . "</i></font> berhasil direkam</b></center>
  148. <br />
  149. <br />
  150. <table border='0' align='center'>
  151. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  152. <tr><td><input type='submit' name='konfirmasirekam' value='Kembali' /></td>
  153. </form>";
  154. }
  155. // Modul Cetak Disposisi ---------------------------------------------------------------------------------------------------------------------------------------------------------------------/
  156. elseif($_GET['module']=='cetakdisposisi'){
  157. $username = $_SESSION[namauser];
  158. echo "<div id='stylized' class='myform'>
  159. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  160. <h1>Cetak Disposisi Surat Masuk</h1>
  161. <p>Form ini digunakan untuk melakukan pencetakan disposisi</p>
  162. </form>
  163. </div>
  164. <br />
  165. <br />
  166. <div id='normaltable'>
  167. <table class='normaltable' width='100%'>
  168. <tr>
  169. <th width='10%' height='35'>No.</th>
  170. <th width='15%'>No. Agenda</th>
  171. <th width='15%'>No. Surat</th>
  172. <th width='15%'>Tgl. Surat</th>
  173. <th width='15%'>Asal Surat</th>
  174. <th width='15%'>Perihal</th>
  175. <th width='15%' colspan='3'>Tindakan</th>
  176. </tr>";
  177. $qDataSurat = mysql_query("SELECT statproses,idsurat,CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,date_format(date(tglsurat),'%d-%m-%Y') AS tglsurat,perihal,disposisi,batasselesai,um,pd,bp,vr,sk,sangatsegera,segera,biasa,setuju,tolak,telitipendapat,untukdiketahui,selesaikan,sesuaicatatan,untukperhatian,edarkan,jawab,perbaiki,bicarakandgsaya,bicarakanbersama,ingatkan,simpan,disiapkan,harapdihadiridiwakili FROM d_suratmasuk WHERE statproses<'4' ORDER BY statproses, noagenda DESC,nomorsuratmasuk")or die(mysql_error);
  178. $no =1;
  179. $oddcol = "#CCFF99";
  180. $evencol = "#CCDD88";
  181. while($rDataSurat = mysql_fetch_object($qDataSurat)){
  182. if($no % 2 == 0) {$color = $evencol;}
  183. else{$color = $oddcol;}
  184. echo "<tr bgcolor='$color'>
  185. <td height='45'>$no</td>
  186. <td>$rDataSurat->noagenda</td>
  187. <td>$rDataSurat->nomorsuratmasuk</td>
  188. <td>$rDataSurat->tglsurat</td>
  189. <td>$rDataSurat->asalsurat</td>
  190. <td>$rDataSurat->perihal</td>
  191. <td>
  192. <form name='form1' method='post' action='report/disposisisuratmasuk.php'>
  193. <input type='hidden' name='username' value='$username' />
  194. <input type='hidden' name='idsurat' value='$rDataSurat->idsurat' />
  195. <input type='hidden' name='noagenda' value='$rDataSurat->noagenda' />
  196. <input type='hidden' name='nomorsuratmasuk' value='$rDataSurat->nomorsuratmasuk' />
  197. <input type='hidden' name='tglsurat' value='$rDataSurat->tglsurat' />
  198. <input type='hidden' name='asalsurat' value='$rDataSurat->asalsurat' />
  199. <input type='hidden' name='perihal' value='$rDataSurat->perihal' />
  200. <input type='hidden' name='disposisi' value='$rDataSurat->disposisi' />
  201. <input type='hidden' name='batasselesai' value='$rDataSurat->batasselesai' />
  202. <input type='hidden' name='statproses' value='$rDataSurat->statproses' />
  203. <input type='hidden' name='um' value='$rDataSurat->um' />
  204. <input type='hidden' name='pd' value='$rDataSurat->pd' />
  205. <input type='hidden' name='bp' value='$rDataSurat->bp' />
  206. <input type='hidden' name='vr' value='$rDataSurat->vr' />
  207. <input type='hidden' name='sk' value='$rDataSurat->sk' />
  208. <input type='hidden' name='sangatsegera' value='$rDataSurat->sangatsegera' />
  209. <input type='hidden' name='segera' value='$rDataSurat->segera' />
  210. <input type='hidden' name='biasa' value='$rDataSurat->biasa' />
  211. <input type='hidden' name='setuju' value='$rDataSurat->setuju' />
  212. <input type='hidden' name='tolak' value='$rDataSurat->tolak' />
  213. <input type='hidden' name='telitipendapat' value='$rDataSurat->telitipendapat' />
  214. <input type='hidden' name='untukdiketahui' value='$rDataSurat->untukdiketahui' />
  215. <input type='hidden' name='selesaikan' value='$rDataSurat->selesaikan' />
  216. <input type='hidden' name='sesuaicatatan' value='$rDataSurat->sesuaicatatan' />
  217. <input type='hidden' name='untukperhatian' value='$rDataSurat->untukperhatian' />
  218. <input type='hidden' name='edarkan' value='$rDataSurat->edarkan' />
  219. <input type='hidden' name='jawab' value='$rDataSurat->jawab' />
  220. <input type='hidden' name='perbaiki' value='$rDataSurat->perbaiki' />
  221. <input type='hidden' name='bicarakandgsaya' value='$rDataSurat->bicarakandgsaya' />
  222. <input type='hidden' name='bicarakanbersama' value='$rDataSurat->bicarakanbersama' />
  223. <input type='hidden' name='ingatkan' value='$rDataSurat->ingatkan' />
  224. <input type='hidden' name='simpan' value='$rDataSurat->simpan' />
  225. <input type='hidden' name='disiapkan' value='$rDataSurat->disiapkan' />
  226. <input type='hidden' name='harapdihadiridiwakili' value='$rDataSurat->harapdihadiridiwakili' />
  227. <input type='submit' class='normaltablesubmit' name='reportcetakdisposisi' value='Cetak' onClick=\"setTimeout('location.reload(true);',1000); this.form.target='_blank'; return true;\" />
  228. </form>
  229. </td>
  230. </tr>";
  231. $no++;
  232. }
  233. echo "</table>
  234. </div>
  235. </form>";
  236. }
  237. // Modul Tabel Disposisi Pejabat/Kepala Kantor ========================================================================================//
  238. elseif($_GET['module']=='disposisiPejabat'){
  239. $username = $_SESSION[namauser];
  240. echo "<div id='stylized' class='myform'>
  241. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  242. <h1>Tabel Disposisi Surat Masuk</h1>
  243. <p>Form ini digunakan untuk melakukan pencatatan disposisi </p>
  244. </form>
  245. </div>
  246. <br />
  247. <br />
  248. <div id='normaltable'>
  249. <table class='normaltable' width='100%'>
  250. <tr>
  251. <th width='10%' height='35'>No.</th>
  252. <th width='15%'>No. Agenda</th>
  253. <th width='15%'>No. Surat</th>
  254. <th width='15%'>Tgl. Surat</th>
  255. <th width='15%'>Asal Surat</th>
  256. <th width='15%'>Perihal</th>
  257. <th width='15%' colspan='3'>Tindakan</th>
  258. </tr>";
  259. $qDataSurat = mysql_query("SELECT idsurat,CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,date_format(date(tglsurat),'%d-%m-%Y') AS tglsurat,perihal FROM d_suratmasuk WHERE statproses='2' ORDER BY statproses, noagenda DESC,nomorsuratmasuk")or die(mysql_error);
  260. $no =1;
  261. $oddcol = "#CCFF99";
  262. $evencol = "#CCDD88";
  263. while($rDataSurat = mysql_fetch_object($qDataSurat)){
  264. if($no % 2 == 0) {$color = $evencol;}
  265. else{$color = $oddcol;}
  266. echo "<tr bgcolor='$color'>
  267. <td height='45'>$no</td>
  268. <td>$rDataSurat->noagenda</td>
  269. <td>$rDataSurat->nomorsuratmasuk</td>
  270. <td>$rDataSurat->tglsurat</td>
  271. <td>$rDataSurat->asalsurat</td>
  272. <td>$rDataSurat->perihal</td>
  273. <td>
  274. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  275. <input type='hidden' name='username' value='$username' />
  276. <input type='hidden' name='idsurat' value='$rDataSurat->idsurat' />
  277. <input type='submit' class='normaltablesubmit' name='catatdisposisi' value='Disposisi' />
  278. </form>
  279. </td>
  280. </tr>";
  281. $no++;
  282. }
  283. echo "</table>
  284. </div>
  285. </form>";
  286. }
  287. // Modul Catat Disposisi ---------------------------------------------------------------------------------------//
  288. elseif($_POST['catatdisposisi']=='Disposisi') {
  289. $username = $_POST['username'];
  290. $idsurat = $_POST['idsurat'];
  291. echo " <script>
  292. $(document).ready(function(){
  293. $('#form').validate();
  294. $('#tanggal').datepicker();
  295. });
  296. </script>
  297. <div id='stylized' class='myform'>
  298. <form id='form' name='formShowBAArsip' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  299. <h1>Form rekam disposisi</h1>
  300. <p>Form ini digunakan Kepala Kantor untuk mencatat disposisi</p>
  301. <br />
  302. <label>Sangat Segera</label>
  303. <input type='checkbox' class='checkbox' name='sangatsegeraCek' />
  304. <label>Segera</label>
  305. <input type='checkbox' class='checkbox' name='segeraCek' />
  306. <label>Biasa</label>
  307. <input type='checkbox' class='checkbox' name='biasaCek' />
  308. <br />
  309. <br />
  310. <br />
  311. <br />
  312. <br />
  313. <p></p>
  314. <p class='header'>Disposisi Kepala Kantor Kepada</p>
  315. <label>Seksi Umum</label>
  316. <input type='checkbox' class='checkbox' name='seksiumCek' />
  317. <label>Seksi Pencairan Dana</label>
  318. <input type='checkbox' class='checkbox' name='seksipdCek' />
  319. <label>Seksi Bank Giro Pos</label>
  320. <input type='checkbox' class='checkbox' name='seksibpCek' />
  321. <label>Seksi Verak</label>
  322. <input type='checkbox' class='checkbox' name='seksivrCek' />
  323. <label>Sekretariat</label>
  324. <input type='checkbox' class='checkbox' name='sekretariatCek' />
  325. <br />
  326. <br />
  327. <br />
  328. <br />
  329. <br />
  330. <br />
  331. <p></p>
  332. <p class='header'>Petunjuk</p>
  333. <label>Setuju</label>
  334. <input type='checkbox' class='checkbox' name='setujuCek' />
  335. <label>Selesaikan</label>
  336. <input type='checkbox' class='checkbox' name='selesaikanCek' />
  337. <label>Jawab</label>
  338. <input type='checkbox' class='checkbox' name='jawabCek' />
  339. <label>Ingatkan</label>
  340. <input type='checkbox' class='checkbox' name='ingatkanCek' />
  341. <label>Tolak</label>
  342. <input type='checkbox' class='checkbox' name='tolakCek' />
  343. <label>Sesuai Catatan</label>
  344. <input type='checkbox' class='checkbox' name='sesuaicatatanCek' />
  345. <label>Perbaiki</label>
  346. <input type='checkbox' class='checkbox' name='perbaikiCek' />
  347. <label>Simpan</label>
  348. <input type='checkbox' class='checkbox' name='simpanCek' />
  349. <label>Teliti & Pendapat</label>
  350. <input type='checkbox' class='checkbox' name='telitipendapatCek' />
  351. <label>Untuk Perhatian</label>
  352. <input type='checkbox' class='checkbox' name='untukperhatianCek' />
  353. <label>Bicarakan Dengan Saya</label>
  354. <input type='checkbox' class='checkbox' name='bicarakandengansayaCek' />
  355. <label>Disiapkan</label>
  356. <input type='checkbox' class='checkbox' name='disiapkanCek' />
  357. <label>Untuk Diketahui</label>
  358. <input type='checkbox' class='checkbox' name='untukdiketahuiCek' />
  359. <label>Edarkan</label>
  360. <input type='checkbox' class='checkbox' name='edarkanCek' />
  361. <label>Bicarakan Bersama</label>
  362. <input type='checkbox' class='checkbox' name='bicarakanbersamaCek' />
  363. <label>Harap Dihadiri/Diwakili</label>
  364. <input type='checkbox' class='checkbox' name='harapdihadiridiwakiliCek' />
  365. <label>Catatan Disposisi</label>
  366. <textarea id='disposisi' rows='7' columns='3' name='disposisi' maxlength='300' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tanggal')\"></textarea>
  367. <label>Batas Waktu Tindak Lanjut
  368. <span class='small'>Isikan batas waktu tindak lanjut dengan surat tanggapan</span>
  369. </label>
  370. <input type='text' id='tanggal' name='batasselesai' minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  371. <input type='hidden' name='username' value='$username' />
  372. <input type='hidden' name='idsurat' value='$idsurat' />
  373. <input type='submit' value='Rekam' class='button' id='submit' name='rekamdisposisi' />
  374. <div class='spacer'></div>
  375. </form>
  376. </div>";
  377. }
  378. // Modul Simpan Disposisi -----------------------------------------------------------------------------------//
  379. elseif($_POST['rekamdisposisi']=='Rekam'){
  380. $idsurat = $_POST['idsurat'];
  381. $username = $_POST['username'];
  382. $seksium = $_POST['seksiumCek'];
  383. if($seksium == "on"){
  384. $seksium = "1";
  385. }
  386. else{
  387. $seksium = "0";
  388. }
  389. $seksipd = $_POST['seksipdCek'];
  390. if($seksipd == "on"){
  391. $seksipd = "1";
  392. }
  393. else{
  394. $seksipd = "0";
  395. }
  396. $seksibp = $_POST['seksibpCek'];
  397. if($seksibp == "on"){
  398. $seksibp = "1";
  399. }
  400. else{
  401. $seksibp = "0";
  402. }
  403. $seksivr = $_POST['seksivrCek'];
  404. if($seksivr == "on"){
  405. $seksivr = "1";
  406. }
  407. else{
  408. $seksivr = "0";
  409. }
  410. $sekretariat = $_POST['sekretariatCek'];
  411. if($sekretariat == "on")
  412. {
  413. $sekretariat = "1";
  414. }
  415. else
  416. {
  417. $sekretariat = "0";
  418. }
  419. $sangatsegera = $_POST['sangatsegeraCek'];
  420. if($sangatsegera == "on")
  421. {
  422. $sangatsegera = "1";
  423. }
  424. else
  425. {
  426. $sangatsegera = "0";
  427. }
  428. $segera = $_POST['segeraCek'];
  429. if($segera == "on")
  430. {
  431. $segera = "1";
  432. }
  433. else
  434. {
  435. $segera = "0";
  436. }
  437. $biasa = $_POST['biasaCek'];
  438. if($biasa == "on")
  439. {
  440. $biasa = "1";
  441. }
  442. else
  443. {
  444. $biasa = "0";
  445. }
  446. $setuju = $_POST['setujuCek'];
  447. if($setuju == "on")
  448. {
  449. $setuju = "1";
  450. }
  451. else
  452. {
  453. $setuju = "0";
  454. }
  455. $tolak = $_POST['tolakCek'];
  456. if($tolak == "on")
  457. {
  458. $tolak = "1";
  459. }
  460. else
  461. {
  462. $tolak = "0";
  463. }
  464. $telitipendapat = $_POST['telitipendapatCek'];
  465. if($telitipendapat == "on")
  466. {
  467. $telitipendapat = "1";
  468. }
  469. else
  470. {
  471. $telitipendapat = "0";
  472. }
  473. $untukdiketahui = $_POST['untukdiketahuiCek'];
  474. if($untukdiketahui == "on")
  475. {
  476. $untukdiketahui = "1";
  477. }
  478. else
  479. {
  480. $untukdiketahui = "0";
  481. }
  482. $selesaikan = $_POST['selesaikanCek'];
  483. if($selesaikan == "on")
  484. {
  485. $selesaikan = "1";
  486. }
  487. else
  488. {
  489. $selesaikan = "0";
  490. }
  491. $sesuaicatatan = $_POST['sesuaicatatanCek'];
  492. if($sesuaicatatan == "on")
  493. {
  494. $sesuaicatatan = "1";
  495. }
  496. else
  497. {
  498. $sesuaicatatan = "0";
  499. }
  500. $untukperhatian = $_POST['untukperhatianCek'];
  501. if($untukperhatian == "on")
  502. {
  503. $untukperhatian = "1";
  504. }
  505. else
  506. {
  507. $untukperhatian = "0";
  508. }
  509. $edarkan = $_POST['edarkanCek'];
  510. if($edarkan == "on")
  511. {
  512. $edarkan = "1";
  513. }
  514. else
  515. {
  516. $edarkan = "0";
  517. }
  518. $jawab = $_POST['jawabCek'];
  519. if($jawab == "on")
  520. {
  521. $jawab = "1";
  522. }
  523. else
  524. {
  525. $jawab = "0";
  526. }
  527. $perbaiki = $_POST['perbaikiCek'];
  528. if($perbaiki == "on")
  529. {
  530. $perbaiki = "1";
  531. }
  532. else
  533. {
  534. $perbaiki = "0";
  535. }
  536. $bicarakandgsaya = $_POST['bicarakandengansayaCek'];
  537. if($bicarakandgsaya == "on")
  538. {
  539. $bicarakandgsaya = "1";
  540. }
  541. else
  542. {
  543. $bicarakandgsaya = "0";
  544. }
  545. $bicarakanbersama = $_POST['bicarakanbersamaCek'];
  546. if($bicarakanbersama == "on")
  547. {
  548. $bicarakanbersama = "1";
  549. }
  550. else
  551. {
  552. $bicarakanbersama = "0";
  553. }
  554. $ingatkan = $_POST['ingatkanCek'];
  555. if($ingatkan == "on")
  556. {
  557. $ingatkan = "1";
  558. }
  559. else
  560. {
  561. $ingatkan = "0";
  562. }
  563. $simpan = $_POST['simpanCek'];
  564. if($simpan == "on")
  565. {
  566. $simpan = "1";
  567. }
  568. else
  569. {
  570. $simpan = "0";
  571. }
  572. $disiapkan = $_POST['disiapkanCek'];
  573. if($disiapkan == "on")
  574. {
  575. $disiapkan = "1";
  576. }
  577. else
  578. {
  579. $disiapkan = "0";
  580. }
  581. $harapdihadiridiwakili = $_POST['harapdihadiridiwakiliCek'];
  582. if($harapdihadiridiwakili == "on")
  583. {
  584. $harapdihadiridiwakili = "1";
  585. }
  586. else
  587. {
  588. $harapdihadiridiwakili = "0";
  589. }
  590. $disposisi = $_POST['disposisi'];
  591. $tanggal = $_POST['batasselesai'];
  592. $batasselesai = $helper->dateConvert($tanggal);
  593. $timepejabat= date("Y-m-d H:i:s");
  594. // query updating tables for Disposisi Kepala Kantor/Pejabat statproses=3
  595. mysql_query("UPDATE d_suratmasuk SET userpejabat='$username',timepejabat='$timepejabat',batasselesai='$batasselesai',disposisi='$disposisi',um='$seksium',pd='$seksipd',bp='$seksibp',vr='$seksivr',sk='$sekretariat',sangatsegera='$sangatsegera',segera='$segera',biasa='$biasa',setuju='$setuju',tolak='$tolak',telitipendapat='$telitipendapat',untukdiketahui='$untukdiketahui',selesaikan='$selesaikan',sesuaicatatan='$sesuaicatatan',untukperhatian='$untukperhatian',edarkan='$edarkan',jawab='$jawab',perbaiki='$perbaiki',bicarakandgsaya='$bicarakandgsaya',bicarakanbersama='$bicarakanbersama',ingatkan='$ingatkan',simpan='$simpan',disiapkan='$disiapkan',harapdihadiridiwakili='$harapdihadiridiwakili',statproses='2' WHERE idsurat='$idsurat'");
  596. // pop up for confirmation
  597. echo "<script type='text/javascript'>
  598. $(document).ready(function() {
  599. $('#promptkonfirmasi').dialog({
  600. modal: true
  601. });
  602. });
  603. </script>
  604. <div id='promptkonfirmasi' title='Konfirmasi Perekaman Disposisi'>
  605. <center><b>Disposisi untuk surat masuk dengan catatan disposisi: <font color='#ffff00'><i>" . $disposisi . "</i></font> berhasil disimpan</b></center>
  606. <br />
  607. <br />
  608. <table border='0' align='center'>
  609. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  610. <tr><td><input type='submit' name='konfirmasirekam' value='Kembali' /></td>
  611. </form>";
  612. }
  613. // Modul terima dan proses surat masuk untuk Kepala Seksi =====================================================================//
  614. elseif($_GET['module'] == "terimaprosessuratmasuk"){
  615. $username = $_SESSION[namauser];
  616. $Seksi = substr($_SESSION[seksi],1,2);
  617. $seksi = strtolower($Seksi);
  618. echo "<div id='stylized' class='myform'>
  619. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  620. <h1>Tabel Terima dan Proses Surat Masuk</h1>
  621. <p>Form ini digunakan untuk melakukan penerimaan dan pemrosesan surat masuk oleh kepala seksi </p>
  622. </form>
  623. </div>
  624. <br />
  625. <br />
  626. <div id='normaltable'>
  627. <table class='normaltable' width='100%'>
  628. <tr>
  629. <th width='10%' height='35'>No.</th>
  630. <th width='15%'>No. Agenda</th>
  631. <th width='15%'>No. Surat</th>
  632. <th width='15%'>Tgl. Surat</th>
  633. <th width='15%'>Asal Surat</th>
  634. <th width='15%'>Perihal</th>
  635. <th width='15%' colspan='3'>Tindakan</th>
  636. </tr>";
  637. $qDataSurat = mysql_query("SELECT idsurat,CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,date_format(date(tglsurat),'%d-%m-%Y') AS tglsurat,perihal FROM d_suratmasuk WHERE statproses='3' AND $seksi='1' ORDER BY statproses, noagenda DESC,nomorsuratmasuk")or die(mysql_error);
  638. $no =1;
  639. $oddcol = "#CCFF99";
  640. $evencol = "#CCDD88";
  641. while($rDataSurat = mysql_fetch_object($qDataSurat)){
  642. if($no % 2 == 0) {$color = $evencol;}
  643. else{$color = $oddcol;}
  644. echo "<tr bgcolor='$color'>
  645. <td height='45'>$no</td>
  646. <td>$rDataSurat->noagenda</td>
  647. <td>$rDataSurat->nomorsuratmasuk</td>
  648. <td>$rDataSurat->tglsurat</td>
  649. <td>$rDataSurat->asalsurat</td>
  650. <td>$rDataSurat->perihal</td>
  651. <td>
  652. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  653. <input type='hidden' name='username' value='$username' />
  654. <input type='hidden' name='idsurat' value='$rDataSurat->idsurat' />
  655. <input type='submit' class='normaltablesubmit' name='prosessurat' value='Terima' onClick=\"setTimeout('location.reload(true);',1000); return true;\" />
  656. </form>
  657. </td>
  658. </tr>";
  659. $no++;
  660. }
  661. echo "</table>
  662. </div>
  663. </form>";
  664. }
  665. // Modul eksekusi penerimaan surat masuk kepala seksi -----------------------------------------------------------------------------------//
  666. elseif($_POST['prosessurat']=='Terima'){
  667. $username = $_POST['username'];
  668. $idsurat = $_POST['idsurat'];
  669. $timekasi = date("Y-m-d H:i:s");
  670. $q = mysql_query("SELECT batasselesai FROM d_suratmasuk WHERE idsurat='$idsurat'");
  671. $r = mysql_fetch_object($q);
  672. if($r->batasselesai == "0000-00-00"){
  673. mysql_query("UPDATE d_suratmasuk SET userkasi='$username', timekasi='$timekasi', statproses='4' WHERE idsurat='$idsurat'");
  674. }else{
  675. mysql_query("UPDATE d_suratmasuk SET userkasi='$username', timekasi='$timekasi', statproses='5' WHERE idsurat='$idsurat'");
  676. }
  677. }
  678. // Modul tabel monitoring surat masuk kepala seksi dan kepala kantor ================================================================//
  679. elseif($_GET['module'] == "monitoringsuratmasuk"){
  680. $username = $_SESSION[namauser];
  681. $section = strtolower($_SESSION[seksi]);
  682. $Seksi = substr($_SESSION[seksi],1,2);
  683. $seksi = strtolower($Seksi);
  684. switch($section)
  685. {
  686. case "aum":
  687. $section = "um";
  688. break;
  689. case "apd":
  690. $section = "pd";
  691. break;
  692. case "avr":
  693. $section = "vr";
  694. break;
  695. case "abp":
  696. $section = "bp";
  697. break;
  698. }
  699. echo "<div id='stylizedtable' class='mytable'>
  700. <h1>Form monitoring surat masuk</h1>
  701. <p>Tayangan</p>
  702. <div id='stylizedtablesp2d'>
  703. <script type='text/javascript'>
  704. setTimeout('location.reload();',30000);
  705. </script>
  706. <table name='monitoringsuratmasuk' cellpadding='1' cellspacing='1'>
  707. <tr>
  708. <th width='10%'>No.Agenda</th>
  709. <th width='10%'>No.Surat</th>
  710. <th width='10%'>Tgl.Surat</th>
  711. <th width='20%'>Asal Surat</th>
  712. <th width='30%'>Perihal</th>
  713. <th width='10%'>Batas Selesai</th>
  714. <th width='10%'>File</th>
  715. <tr>
  716. <tr>
  717. <td bgcolor='#dbeeb8' colspan='6'></td>
  718. </tr>";
  719. $querykk = "SELECT idsurat,CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,date_format(date(tglsurat),'%d-%m-%Y') AS tglsurat,perihal,date_format(batasselesai,'%d-%m-%Y') AS batasselesai,file FROM d_suratmasuk WHERE batasselesai!='00-00-0000' AND (kodesuratkeluar='' OR nomorsuratkeluar='') ORDER BY statproses, noagenda DESC,nomorsuratmasuk";
  720. $querynotkk = "SELECT idsurat,CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,date_format(date(tglsurat),'%d-%m-%Y') AS tglsurat,perihal,date_format(batasselesai,'%d-%m-%Y') AS batasselesai,file FROM d_suratmasuk WHERE batasselesai!='00-00-0000' AND $section='1' AND (kodesuratkeluar='' OR nomorsuratkeluar='') ORDER BY statproses, noagenda DESC,nomorsuratmasuk";
  721. if($seksi == "k"){
  722. $querydata = $querykk;
  723. }else{
  724. $querydata = $querynotkk;
  725. }
  726. $qDataSurat = mysql_query($querydata)or die(mysql_error);
  727. while($rData = mysql_fetch_array($qDataSurat)){
  728. $noagenda = $rData['noagenda'];
  729. $nomorsuratmasuk= $rData['nomorsuratmasuk'];
  730. $tglsurat = $rData['tglsurat'];
  731. $asalsurat = $rData['asalsurat'];
  732. $perihal = $rData['perihal'];
  733. $file = $rData['file'];
  734. $batasselesai = $rData['batasselesai'];
  735. $now = date("d-m-Y");
  736. echo "
  737. <tr class='sp2d' height='60'>
  738. <td>$noagenda</td>
  739. <td><font color='#FFFFFF'>$nomorsuratmasuk</font></td>
  740. <td><font color='#FFFFFF'>$tglsurat</font></td>
  741. <td><font color='#33FFCC'>$asalsurat</font></td>
  742. <td>$perihal</td>
  743. <td>";
  744. switch($batasselesai){
  745. case 00-00-0000:
  746. echo "<b>$batasselesai</b>";
  747. break;
  748. case $batasselesai > $now:
  749. echo "<font color='#CEEC96'><b>$batasselesai</b></font>";
  750. break;
  751. case $batasselesai = $now:
  752. echo "<font color='#ffff00'><b>$batasselesai</b></font>";
  753. break;
  754. case $batasselesai > $now:
  755. echo "<font color='#ff0000'><b>$batasselesai</b></font>";
  756. break;
  757. }
  758. echo "</td>
  759. <td><b><i><a href='suratmasuk/$file' target='_blank'>$file</a></b></i></td>
  760. </tr>";
  761. }
  762. echo"</table>
  763. </div>
  764. </div>";
  765. }
  766. // Modul Form pencarian surat masuk =======================================================================================//
  767. elseif($_GET['module']=='searchsuratmasuk'){
  768. echo "<script type=\"text/javascript\">
  769. $(document).ready(function() {
  770. $('#tglawalsurat').datepicker({
  771. changeMonth: true,
  772. changeYear: true
  773. });
  774. });
  775. $(document).ready(function() {
  776. $('#tglakhirsurat').datepicker({
  777. changeMonth: true,
  778. changeYear: true
  779. });
  780. });
  781. $(document).ready(function() {
  782. $('#timeloket').datepicker({
  783. changeMonth: true,
  784. changeYear: true
  785. });
  786. });
  787. </script>
  788. <div id='stylized' class='myform'>
  789. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  790. <h1>Form multikategori pencarian data surat masuk</h1>
  791. <p>Form ini digunakan dalam pencarian data surat masuk</p>
  792. <label>Tgl.Terima Surat</label>
  793. <input type='checkbox' class='checkbox' name='timeloketCek' />
  794. <input type='text' id='timeloket' name='timeloket' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nomorsuratmasuk')\" />
  795. <label>Nomor Surat</label>
  796. <input type='checkbox' class='checkbox' name='nomorsuratmasukCek' />
  797. <input type='text' id='nomorsuratmasuk' minlength='3' name='nomorsuratmasuk' maxlength='20' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tglsurat')\" />
  798. <br />
  799. <br />
  800. <br />
  801. <br />
  802. <br />
  803. <br />
  804. <p><center><b>Range Tanggal Surat</b></center></p>
  805. <label>Tgl.Awal Surat</label>
  806. <input type='checkbox' class='checkbox' name='tglawalsuratCek' />
  807. <input type='text' id='tglawalsurat' name='tglawalsurat' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tglakhirsurat')\" />
  808. <label>Tgl.Akhir Surat</label>
  809. <input type='checkbox' class='checkbox' name='tglakhirsuratCek' />
  810. <input type='text' id='tglakhirsurat' name='tglakhirsurat' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'asalsurat')\" />
  811. <br />
  812. <br />
  813. <br />
  814. <br />
  815. <br />
  816. <br />
  817. <p></p>
  818. <label>Asal Surat</label>
  819. <input type='checkbox' class='checkbox' name='asalsuratCek' />
  820. <input type='text' id='asalsurat' name='asalsurat' maxlength='75' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'perihal')\" />
  821. <label>Perihal</label>
  822. <input type='checkbox' class='checkbox' name='perihalCek' />
  823. <input type='text' id='perihal' name='perihal' maxlength='120' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  824. <input type='submit' value='Cari' class='button' id='submit' name='cariDokSuratMasuk' />
  825. <div class='spacer'></div>
  826. </form>
  827. </div>";
  828. }
  829. // Modul Search Surat Masuk----------------------------------------------------------------------------------------------------------------------------------------------//
  830. elseif($_POST['cariDokSuratMasuk'] == "Cari"){
  831. $timeloketCek = $_POST['timeloketCek'];
  832. $Timeloket = $_POST['timeloket'];
  833. $timeloket = $helper->dateConvert($Timeloket);
  834. $nomorsuratmasukCek = $_POST['nomorsuratmasukCek'];
  835. $tglawalsuratCek = $_POST['tglawalsuratCek'];
  836. $tglakhirsuratCek = $_POST['tglakhirsuratCek'];
  837. $asalsuratCek = $_POST['asalsuratCek'];
  838. $perihalCek = $_POST['perihalCek'];
  839. $nomorsuratmasuk = $_POST['nomorsuratmasuk'];
  840. $Tglawalsurat = $_POST['tglawalsurat'];
  841. $Tglakhirsurat = $_POST['tglakhirsurat'];
  842. $tglawalsurat = $helper->dateConvert($Tglawalsurat);
  843. $tglakhirsurat = $helper->dateConvert($Tglakhirsurat);
  844. $asalsurat = $_POST['asalsurat'];
  845. $perihal = $_POST['perihal'];
  846. $bagianWhere="";
  847. if(isset($timeloketCek)){
  848. $timeloket;
  849. if(empty($bagianWhere)){
  850. $bagianWhere .= "date(timeloket)='$timeloket'";
  851. }
  852. }
  853. if(isset($nomorsuratmasukCek)){
  854. if(empty($bagianWhere)){
  855. $bagianWhere .= "nomorsuratmasuk='$nomorsuratmasuk'";
  856. }
  857. else{
  858. $bagianWhere .= " AND nomorsuratmasuk='$nomorsuratmasuk'";
  859. }
  860. }
  861. if(isset($tglawalsuratCek)){
  862. if(empty($bagianWhere)){
  863. $bagianWhere .= "tglsurat>='$tglawalsurat'";
  864. }
  865. else{
  866. $bagianWhere .= " AND tglsurat>='$tglawalsurat'";
  867. }
  868. }
  869. if(isset($tglakhirsuratCek)){
  870. if(empty($bagianWhere)){
  871. $bagianWhere .= "tglsurat<='$tglakhirsurat'";
  872. }
  873. else{
  874. $bagianWhere .= " AND tglsurat<='$tglakhirsurat'";
  875. }
  876. }
  877. if(isset($asalsuratCek)){
  878. if(empty($bagianWhere)){
  879. $bagianWhere .= "asalsurat REGEXP '$asalsurat'";
  880. }
  881. else{
  882. $bagianWhere .= " AND asalsurat REGEXP '$asalsurat'";
  883. }
  884. }
  885. if(isset($perihalCek)){
  886. if(empty($bagianWhere)){
  887. $bagianWhere .= "perihal REGEXP '$perihal'";
  888. }
  889. else{
  890. $bagianWhere .= " AND perihal REGEXP '$perihal'";
  891. }
  892. }
  893. $queryCek = "SELECT nomorsuratmasuk,tglsurat,asalsurat,perihal FROM d_suratmasuk WHERE ".$bagianWhere;
  894. $qCek = mysql_query($queryCek)or die(mysql_error());
  895. $rCek = mysql_fetch_row($qCek);
  896. if($rCek > 0){
  897. echo "<div id='stylized' class='myform'>
  898. <form id='form' name='formSearchSuratMasuk' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  899. <h1>Form hasil pencarian data surat masuk</h1>
  900. <p>Hasil pencarian data surat masuk</p>
  901. </form>
  902. </div>
  903. <br />
  904. <table class='normaltable' border='0'>
  905. <tr>
  906. <th width='6%'>No.</th>
  907. <th width='10%'>No. Surat</th>
  908. <th width='10%'>Tgl. Surat</th>
  909. <th width='24%'>Asal Surat</th>
  910. <th width='24%'>Perihal</th>
  911. <th width='15%'>Surat Tanggapan</th>
  912. <th width='10%'>File Surat Masuk</th>
  913. <th width='10%' colspan='2'>Action</th>
  914. </tr>";
  915. $query = "SELECT idsurat,nomorsuratmasuk,date_format(tglsurat,'%d-%m-%Y') AS tglsurat,asalsurat,perihal,CONCAT(nomorsuratkeluar,kodesuratkeluar) AS nomorsuratkeluar,file,um,pd,bp,vr,sk FROM d_suratmasuk WHERE ".$bagianWhere;
  916. $qCari = mysql_query($query)or die(mysql_error());
  917. $no = 1;
  918. $oddcol = "#CCFF99";
  919. $evencol = "#CCDD88";
  920. while($rCari = mysql_fetch_array($qCari)){
  921. if($no % 2 == 0) {$color = $evencol;}
  922. else{$color = $oddcol;}
  923. $idsurat = $rCari['idsurat'];
  924. $nomorsuratmasuk = $rCari['nomorsuratmasuk'];
  925. $tglsurat = $rCari['tglsurat'];
  926. $asalsurat = $rCari['asalsurat'];
  927. $perihal = $rCari['perihal'];
  928. $nomorsuratkeluar = $rCari['nomorsuratkeluar'];
  929. $file = $rCari['file'];
  930. echo"<tr bgcolor='$color'>
  931. <td>$no</td>
  932. <td>$nomorsuratmasuk</td>
  933. <td>$tglsurat</td>
  934. <td>$asalsurat</td>
  935. <td>$perihal</td>
  936. <td>$nomorsuratkeluar</td>
  937. <td><b><i><a href='suratmasuk/$file' target='_blank'>$file</a></b></i></td>
  938. <td><form method='post' action='".$_SERVER['PHP_SELF']."'><input type='hidden' name='idsurat' value='".$idsurat."' /><input type='submit' name='ubahsuratmasuk' value='Ubah' /></form></td>
  939. <td><form method='post' action='".$_SERVER['PHP_SELF']."'><input type='hidden' name='idsurat' value='".$idsurat."' /><input type='submit' name='hapussuratmasuk' value='Hapus' /></form></td>
  940. </tr>";
  941. $no++;
  942. }
  943. echo"</table>";
  944. }
  945. else{
  946. echo "<script type='text/javascript'>
  947. alert('Data tersebut tidak ditemukan');
  948. </script>";
  949. }
  950. }
  951. // Modul Ubah Surat Masuk ---------------------------------------------------------------
  952. elseif($_POST['ubahsuratmasuk'] == 'Ubah')
  953. {
  954. echo "<script type=\"text/javascript\">
  955. $(document).ready(function() {
  956. $('#tglsurat').datepicker();
  957. });
  958. </script>";
  959. $idsurat = $_POST['idsurat'];
  960. $qUpdate = mysql_query("SELECT idsurat,nomorsuratmasuk,date_format(tglsurat,'%d/%m/%Y') AS tglsurat,asalsurat,perihal,nomorsuratkeluar,kodesuratkeluar,file FROM d_suratmasuk WHERE idsurat='$idsurat'");
  961. $rUpdate = mysql_fetch_object($qUpdate);
  962. $idsurat = $rUpdate->idsurat;
  963. $nomorsuratmasuk = $rUpdate->nomorsuratmasuk;
  964. $tglsurat = $rUpdate->tglsurat;
  965. $asalsurat = $rUpdate->asalsurat;
  966. $perihal = $rUpdate->perihal;
  967. $nomorsuratkeluar = $rUpdate->nomorsuratkeluar;
  968. $kodesuratkeluar = $rUpdate->kodesuratkeluar;
  969. $file = $rUpdate->file;
  970. echo "<div id='stylized' class='myform'>
  971. <form id='form' name='form' method='post' enctype='multipart/form-data' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  972. <h1>Form update data surat masuk</h1>
  973. <p>Form ini digunakan untuk melakukan perubahan data surat masuk</p>
  974. <label>Nomor Surat Masuk</label>
  975. <input type='text' id='nomorsuratmasuk' minlength='3' name='nomorsuratmasuk' value='$nomorsuratmasuk' maxlength='20' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tglsurat')\" />
  976. <label>Tgl.Surat Masuk</label>
  977. <input type='text' id='tglsurat' name='tglsurat' value='$tglsurat' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'asalsurat')\" />
  978. <label>Asal Surat</label>
  979. <input type='text' id='asalsurat' name='asalsurat' value='$asalsurat' maxlength='75' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'perihal')\" />
  980. <label>Perihal</label>
  981. <input type='text' id='perihal' name='perihal' value='$perihal' maxlength='120' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'file')\" />
  982. <label>File
  983. <span class='small'>Apabila file yang diupload tidak berubah, biarkan kosong.</span>
  984. <span class='small'>File awal: <b>$file</b></span>
  985. </label>
  986. <input type='file' id='file' name='file' maxlength='45' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  987. <input type='hidden' value='$idsurat' name='idsurat' />
  988. <input type='submit' value='Simpan' class='button' id='submit' name='simpanUpdateSuratMasuk' />
  989. <div class='spacer'></div>
  990. </form>
  991. </div>";
  992. }
  993. // Simpan Hasil Update Surat Masuk--------------------------------------------------------------------
  994. elseif($_POST['simpanUpdateSuratMasuk'] == 'Simpan')
  995. {
  996. echo "<script type='text/javascript'>
  997. $(document).ready(function() {
  998. $('#promptkonfirmasi').dialog({
  999. modal: true
  1000. });
  1001. });
  1002. </script>";
  1003. $idsurat = $_POST['idsurat'];
  1004. $nomorsuratmasuk = $_POST['nomorsuratmasuk'];
  1005. $tglSurat = $_POST['tglsurat'];
  1006. $tglsurat = $helper->dateConvert($tglSurat);
  1007. $asalsurat = $_POST['asalsurat'];
  1008. $perihal = $_POST['perihal'];
  1009. $file = $_POST['file'];
  1010. $lokasi_file =$_FILES['file']['tmp_name'];
  1011. $nama_file =$_FILES['file']['name'];
  1012. if($file == 0)
  1013. {
  1014. $qUpdate = mysql_query("UPDATE d_suratmasuk SET nomorsuratmasuk='$nomorsuratmasuk',tglsurat='$tglsurat',asalsurat='$asalsurat',perihal='$perihal' WHERE idsurat=$idsurat");
  1015. echo "<div id='promptkonfirmasi' title='Konfirmasi Update Data Surat Masuk'>
  1016. <center><b>Data surat masuk dengan nomor surat: <font color='#ffff00'><i>" . $nosuratmasuk . "</i></font> dan perihal <font color='#ffff00'><i>" . $perihal . "</i></font> berhasil diubah</b></center>
  1017. <br />
  1018. <br />
  1019. <table border='0' align='center'>
  1020. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1021. <tr><td><input type='submit' name='konfirmasirekam' value='Kembali' /></td>
  1022. </form>";
  1023. }
  1024. else
  1025. {
  1026. $qUpdate = mysql_query("UPDATE d_suratmasuk SET nomorsuratmasuk='$nomorsuratmasuk',tglsurat='$tglsurat',asalsurat='$asalsurat',perihal='$perihal',file='$file' WHERE idsurat=$idsurat");
  1027. $direktori ='suratmasuk/'.basename($nama_file);
  1028. move_uploaded_file($lokasi_file,$direktori);
  1029. echo "<div id='promptkonfirmasi' title='Konfirmasi Update Data Surat Masuk'>
  1030. <center><b>Data surat masuk dengan nomor surat: <font color='#ffff00'><i>" . $nosuratmasuk . "</i></font> dan perihal <font color='#ffff00'><i>" . $perihal . "</i></font> berhasil diubah</b></center>
  1031. <br />
  1032. <br />
  1033. <table border='0' align='center'>
  1034. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1035. <tr><td><input type='submit' name='konfirmasirekam' value='Kembali' /></td>
  1036. </form>";
  1037. }
  1038. }
  1039. // Modul Hapus Surat Masuk ---------------------------------------------------------------------------
  1040. elseif($_POST['hapussuratmasuk'] == 'Hapus')
  1041. {
  1042. $idsurat = $_POST['idsurat'];
  1043. mysql_query("DELETE FROM d_suratmasuk WHERE idsurat='$idsurat'");
  1044. header("location: media.php?module=searchsuratmasuk");
  1045. }
  1046. // Modul Pengantar Surat Masuk ======================================================================//
  1047. elseif($_GET['module'] == 'pengantarsuratmasuk'){
  1048. echo "<style type='text/css'>
  1049. em { font-weight: bold; padding-right: 1em; vertical-align: top; }
  1050. </style>
  1051. <script>
  1052. $(document).ready(function(){
  1053. $('#form').validate();
  1054. });
  1055. $(document).ready(function(){
  1056. $('#form').validate();
  1057. $('#tglawal').datepicker();
  1058. });
  1059. $(document).ready(function(){
  1060. $('#form').validate();
  1061. $('#tglakhir').datepicker();
  1062. });
  1063. </script>
  1064. <div id='stylized' class='myform'>
  1065. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1066. <h1>Form pencetakan rekapitulasi surat masuk</h1>
  1067. <p>Form ini digunakan untuk melakukan pencetakan rekapitulasi surat masuk</p>
  1068. <h3>Range Tanggal Penerimaan Surat Masuk</h3>
  1069. <br />
  1070. <label>Tanggal Awal
  1071. <span class='small'>Isikan tgl awal</span>
  1072. </label>
  1073. <input type='text' id='tglawal' name='tglawal' class='required' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'statproses')\" />
  1074. <label>Tanggal Akhir
  1075. <span class='small'>Isikan tgl akhir</span>
  1076. </label>
  1077. <input type='text' id='tglakhir' name='tglakhir' class='required' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'seksi')\" />
  1078. <br />
  1079. <br />
  1080. <br />
  1081. <br />
  1082. <br />
  1083. <br />
  1084. <p></p>
  1085. <label>Seksi
  1086. <span class='small'>Seksi</span>
  1087. </label>
  1088. <select name='seksi' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" >
  1089. <option value='' selected='selected'>-- Pilih --</option>
  1090. <option value='all'>Semua Seksi</option>
  1091. <option value='um'>Sub Bagian Umum</option>
  1092. <option value='pd'>Seksi Pencairan Dana</option>
  1093. <option value='bp'>Seksi Bank/Giro Pos</option>
  1094. <option value='vr'>Seksi Verak</option>
  1095. </select>
  1096. <input type='submit' value='Tayang' class='button' id='submit' name='Tayangcetakrekapsuratmasuk' />
  1097. <div class='spacer'></div>
  1098. </form>
  1099. </div>";
  1100. }
  1101. // Tampilkan tabel pilihan cetak pengantar surat masuk ----------------------------------------------//
  1102. elseif($_POST['Tayangcetakrekapsuratmasuk'] == "Tayang"){
  1103. $tglawal = $helper->dateConvert($_POST['tglawal']);
  1104. $tglakhir = $helper->dateConvert($_POST['tglakhir']);
  1105. $seksi = $_POST['seksi'];
  1106. // query tiap seksi
  1107. if($seksi == "all"){
  1108. $query = "SELECT CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,DATE_FORMAT(tglsurat,'%d-%m-%Y') AS tglsurat,perihal,DATE(timeloket) FROM d_suratmasuk WHERE DATE(timeloket) BETWEEN '$tglawal' AND '$tglakhir' AND (um = '1' OR pd = '1' OR bp ='1' OR vr = '1')";
  1109. }elseif($seksi == "um"){
  1110. $query = "SELECT CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,DATE_FORMAT(tglsurat,'%d-%m-%Y') AS tglsurat,perihal,DATE(timeloket) FROM d_suratmasuk WHERE DATE(timeloket) BETWEEN '$tglawal' AND '$tglakhir' AND um = '1'";
  1111. }elseif($seksi == "pd"){
  1112. $query = "SELECT CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,DATE_FORMAT(tglsurat,'%d-%m-%Y') AS tglsurat,perihal,DATE(timeloket) FROM d_suratmasuk WHERE DATE(timeloket) BETWEEN '$tglawal' AND '$tglakhir' AND pd = '1'";
  1113. }elseif($seksi == "bp"){
  1114. $query = "SELECT CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,DATE_FORMAT(tglsurat,'%d-%m-%Y') AS tglsurat,perihal,DATE(timeloket) FROM d_suratmasuk WHERE DATE(timeloket) BETWEEN '$tglawal' AND '$tglakhir' AND bp ='1'";
  1115. }elseif($seksi == "vr"){
  1116. $query = "SELECT CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,DATE_FORMAT(tglsurat,'%d-%m-%Y') AS tglsurat,perihal,DATE(timeloket) FROM d_suratmasuk WHERE DATE(timeloket) BETWEEN '$tglawal' AND '$tglakhir' AND vr = '1'";
  1117. }
  1118. // query mengecek data
  1119. $qcek = mysql_query("SELECT nomorsuratmasuk FROM d_suratmasuk WHERE DATE(timeloket) BETWEEN '$tglawal' AND '$tglakhir'");
  1120. $rcek = mysql_num_rows($qcek);
  1121. if($tglawal > $tglakhir){
  1122. echo "<script type='text/javascript'>
  1123. alert('Tanggal awal Anda lebih besar daripada tanggal akhir, mohon perbaiki entri tanggal Anda!');
  1124. window.location.replace('media.php?module=pengantarsuratmasuk')
  1125. </script>";
  1126. }elseif($rcek < 1){
  1127. echo "<script type='text/javascript'>
  1128. alert('Data dimaksud pada range tanggal tidak ada, mohon perbaiki entri tanggal Anda!');
  1129. window.location.replace('media.php?module=pengantarsuratmasuk')
  1130. </script>";
  1131. }else{
  1132. echo "<div id='stylized' class='myform'>
  1133. <form id='form' name='formShowDataSuratMasuk' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1134. <h1>Tabel Pencetakan Rekapitulasi Surat Masuk</h1>
  1135. <p>Tabel yang menampilkan data surat masuk untuk keperluan pencetakan rekapitulasi surat masuk</p>
  1136. </form>
  1137. </div>
  1138. <br />
  1139. <form name='form1' method='post' action='report/reportcetaksuratmasuk.php'>
  1140. <table class='normaltable' border='0'>
  1141. <tr>
  1142. <th width='6%' height='40'>No.</th>
  1143. <th width='10%'>No.Agenda</th>
  1144. <th width='15%'>No.Surat</th>
  1145. <th width='15%'>Asal Surat</th>
  1146. <th width='10%'>Tgl.Surat</th>
  1147. <th width='30%'>Perihal</th>
  1148. <th width='5%'>Cek</th>
  1149. </tr>";
  1150. $q = mysql_query($query);
  1151. $no = 1;
  1152. $oddcol = "#CCFF99";
  1153. $evencol = "#CCDD88";
  1154. while($r = mysql_fetch_object($q)){
  1155. if($no % 2 == 0) {$color = $evencol;}
  1156. else{$color = $oddcol;}
  1157. echo"<tr bgcolor='$color'>
  1158. <td height='80'>$no</td>
  1159. <td>$r->noagenda</td>
  1160. <td>$r->nomorsuratmasuk</td>
  1161. <td>$r->asalsurat</td>
  1162. <td>$r->tglsurat</td>
  1163. <td>$r->perihal</td>
  1164. <td><input type='checkbox' class='checkbox' name='cetak$no' value='$no' />
  1165. </tr>";
  1166. $no++;
  1167. }
  1168. echo "</table>";
  1169. $n = 1;
  1170. $qData = mysql_query($query);
  1171. while($rData = mysql_fetch_array($qData)){
  1172. $noagenda = $rData['noagenda'];
  1173. $nomorsuratmasuk = $rData['nomorsuratmasuk'];
  1174. $asalsurat = $rData['asalsurat'];
  1175. $tglsurat = $rData['tglsurat'];
  1176. $perihal = $rData['perihal'];
  1177. echo "<input type='hidden' name='noagenda$n' value='$noagenda' />
  1178. <input type='hidden' name='nomorsuratmasuk$n' value='$nomorsuratmasuk' />
  1179. <input type='hidden' name='asalsurat$n' value='$asalsurat' />
  1180. <input type='hidden' name='tglsurat$n' value='$tglsurat' />
  1181. <input type='hidden' name='perihal$n' value='$perihal' />";
  1182. $n++;
  1183. }
  1184. $n = $n-1;
  1185. echo "<input type='hidden' name='jumldata' value='$n' />
  1186. <input type='submit' value='Cetak' class='button1' id='submit' name='cetakrekapsuratmasuk' onClick=\"this.form.target='_blank'; return true;\" />
  1187. </form>";
  1188. }
  1189. }
  1190. //Modul Form Surat Tanggapan ========================================================================//
  1191. elseif($_GET['module'] == 'surattanggapan'){
  1192. $username = $_SESSION[namauser];
  1193. $Seksi = $_SESSION[seksi];
  1194. $seksi = strtolower($Seksi);
  1195. $SeksiA = substr($_SESSION[seksi],1,2);
  1196. $seksiA = strtolower($SeksiA);
  1197. echo "<div id='stylized' class='myform'>
  1198. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1199. <h1>Tabel Surat Tanggapan</h1>
  1200. <p>Form ini digunakan untuk menampilkan data surat masuk yang memerlukan surat tanggapan</p>
  1201. </form>
  1202. </div>
  1203. <br />
  1204. <br />
  1205. <div id='normaltable'>
  1206. <table class='normaltable' width='100%'>
  1207. <tr>
  1208. <th width='10%' height='35'>No.</th>
  1209. <th width='15%'>No. Agenda</th>
  1210. <th width='15%'>No. Surat</th>
  1211. <th width='15%'>Tgl. Surat</th>
  1212. <th width='15%'>Asal Surat</th>
  1213. <th width='15%'>Perihal</th>
  1214. <th width='15%' colspan='3'>Tindakan</th>
  1215. </tr>";
  1216. $querykk = "SELECT idsurat,CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,date_format(date(tglsurat),'%d-%m-%Y') AS tglsurat,perihal,date_format(batasselesai,'%d-%m-%Y') AS batasselesai,file FROM d_suratmasuk WHERE batasselesai!='00-00-0000' AND (kodesuratkeluar='' OR nomorsuratkeluar='') AND statproses='5' ORDER BY statproses, noagenda DESC,nomorsuratmasuk";
  1217. $querynotkkA= "SELECT idsurat,CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,date_format(date(tglsurat),'%d-%m-%Y') AS tglsurat,perihal,date_format(batasselesai,'%d-%m-%Y') AS batasselesai,file FROM d_suratmasuk WHERE batasselesai!='00-00-0000' AND $seksiA='1' AND (kodesuratkeluar='' OR nomorsuratkeluar='') AND statproses='5' ORDER BY statproses, noagenda DESC,nomorsuratmasuk";
  1218. $querynotkk = "SELECT idsurat,CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,date_format(date(tglsurat),'%d-%m-%Y') AS tglsurat,perihal,date_format(batasselesai,'%d-%m-%Y') AS batasselesai,file FROM d_suratmasuk WHERE batasselesai!='00-00-0000' AND $seksi='1' AND (kodesuratkeluar='' OR nomorsuratkeluar='') AND statproses='5' ORDER BY statproses, noagenda DESC,nomorsuratmasuk";
  1219. if($seksiA == "k"){
  1220. $querydata = $querykk;
  1221. }
  1222. elseif($seksiA == "um" || $seksiA == "pd" || $seksiA == "bp" || $seksiA == "vr"){
  1223. $querydata = $querynotkkA;
  1224. }
  1225. else{
  1226. $querydata = $querynotkk;
  1227. }
  1228. $qDataSurat = mysql_query($querydata)or die(mysql_error);
  1229. $no =1;
  1230. $oddcol = "#CCFF99";
  1231. $evencol = "#CCDD88";
  1232. while($rDataSurat = mysql_fetch_object($qDataSurat)){
  1233. if($no % 2 == 0) {$color = $evencol;}
  1234. else{$color = $oddcol;}
  1235. echo "<tr bgcolor='$color'>
  1236. <td height='45'>$no</td>
  1237. <td>$rDataSurat->noagenda</td>
  1238. <td>$rDataSurat->nomorsuratmasuk</td>
  1239. <td>$rDataSurat->tglsurat</td>
  1240. <td>$rDataSurat->asalsurat</td>
  1241. <td>$rDataSurat->perihal</td>
  1242. <td>
  1243. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1244. <input type='hidden' name='username' value='$username' />
  1245. <input type='hidden' name='idsurat' value='$rDataSurat->idsurat' />
  1246. <input type='submit' class='normaltablesubmit' name='prosessurattanggapan' value='Proses' />
  1247. </form>
  1248. </td>
  1249. </tr>";
  1250. $no++;
  1251. }
  1252. echo "</table>
  1253. </div>
  1254. </form>";
  1255. }
  1256. // Modul pengambilan nomor surat tanggapan atas surat masuk ----------------------------------------------------------------------------------------//
  1257. elseif($_POST['prosessurattanggapan'] == 'Proses'){
  1258. $username = $_POST['username'];
  1259. $idsurat = $_POST['idsurat'];
  1260. echo "<style type='text/css'>
  1261. em { font-weight: bold; padding-right: 1em; vertical-align: top; }
  1262. </style>
  1263. <script>
  1264. $(document).ready(function(){
  1265. $('#form').validate();
  1266. $('#tanggal').datepicker();
  1267. });
  1268. </script>
  1269. <div id='stylized' class='myform'>
  1270. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1271. <h1>Form perekaman data surat keluar</h1>
  1272. <p><b>Step I</b> - Data Surat Keluar</p>
  1273. <label>Tanggapan Dari
  1274. <span class='small'>Isikan wewenang tanggapan</span>
  1275. </label>
  1276. <select name='seksi'>
  1277. <option value='' selected='selected'>-- Pilih --</option>
  1278. <option value='kk'>Kepala Kantor</option>
  1279. <option value='um'>Sub Bagian Umum</option>
  1280. <option value='pd'>Pencairan Dana</option>
  1281. <option value='bp'>Bank & Giro Pos</option>
  1282. <option value='vr'>Verifikasi & Akuntansi</option>
  1283. </select>
  1284. <label>Jenis Surat
  1285. <span class='small'>Isikan jenis nomor surat keluar</span>
  1286. </label>
  1287. <select name='nomorsuratkeluar'>
  1288. <option value='' selected='selected'>-- Pilih --</option>
  1289. <option value='S'>S</option>
  1290. <option value='SP'>SP</option>
  1291. <option value='SKPA'>SKPA</option>
  1292. <option value='SPK'>SPK</option>
  1293. <option value='SP2LK'>SP2LK</option>
  1294. <option value='SP2S'>SP2S</option>
  1295. <option value='SP3S'>SP3S</option>
  1296. <option value='SI'>SI</option>
  1297. <option value='SE'>SE</option>
  1298. <option value='ST'>ST</option>
  1299. <option value='SKU'>SKU</option>
  1300. <option value='BA'>BA</option>
  1301. <option value='BAST'>BAST</option>
  1302. <option value='KET'>KET</option>
  1303. <option value='KEP'>KEP</option>
  1304. <option value='ND'>ND</option>
  1305. <option value='NP'>NP</option>
  1306. <option value='PEM'>PEM</option>
  1307. <option value='PRIN'>PRIN</option>
  1308. <option value='UND'>UND</option>
  1309. </select>
  1310. <label>Tanggal Surat
  1311. <span class='small'>Isikan tgl.surat masuk</span>
  1312. </label>
  1313. <input type='text' id='tanggal' name='tglsurat' class= 'required' minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'asalsurat')\" />
  1314. <label>Tujuan Surat
  1315. <span class='small'>Isikan tujuan surat keluar</span>
  1316. </label>
  1317. <input type='text' id='tujuansurat' name='tujuansurat' class='required' minlength='3' maxlength='50' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'perihal')\" />
  1318. <label>Perihal
  1319. <span class='small'>Isikan perihal surat keluar</span>
  1320. </label>
  1321. <input type='text' id='perihal' name='perihal' class='required' minlength='2' maxlength='120' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  1322. <input type='hidden' name='username' value='$username' />
  1323. <input type='hidden' name='idsurat' value='$idsurat' />
  1324. <input type='submit' value='Rekam' class='button' id='submit' name='Ambilnomorsuratkeluar' />
  1325. <div class='spacer'></div>
  1326. </form>
  1327. </div>";
  1328. }
  1329. // Modul pengambilan nomor surat keluar ===================================================================================//
  1330. elseif($_POST['Ambilnomorsuratkeluar']=='Rekam'){
  1331. $username = $_POST['username'];
  1332. $idsurat = $_POST['idsurat'];
  1333. $seksi = $_POST['seksi'];
  1334. // query kode surat keluar
  1335. $qKodesuratkeluar = mysql_query("SELECT wpb,kp FROM t_kanwil WHERE aktif='1'");
  1336. $rKodesuratkeluar = mysql_fetch_object($qKodesuratkeluar);
  1337. $wpb = $rKodesuratkeluar->wpb;
  1338. $kp = $rKodesuratkeluar->kp;
  1339. $yearnow = date("Y");
  1340. // penomoran surat berdasarkan seksi
  1341. switch($seksi){
  1342. case kk:
  1343. $kodesuratkeluar = "/WPB." . $wpb . "/KP." . $kp . "/" . $yearnow;
  1344. break;
  1345. case um:
  1346. $kodesuratkeluar = "/WPB." . $wpb . "/KP." . $kp . "10/" . $yearnow;
  1347. break;
  1348. case pd:
  1349. $kodesuratkeluar = "/WPB." . $wpb . "/KP." . $kp . "21/" . $yearnow;
  1350. break;
  1351. case bp:
  1352. $kodesuratkeluar = "/WPB." . $wpb . "/KP." . $kp . "30/" . $yearnow;
  1353. break;
  1354. case vr:
  1355. $kodesuratkeluar = "/WPB." . $wpb . "/KP." . $kp . "40/" . $yearnow;
  1356. break;
  1357. }
  1358. $nomorsuratkeluar = $_POST['nomorsuratkeluar'];
  1359. // converting for mysql databases yyyy-mm-dd
  1360. $tglsurat = $helper->dateConvert($_POST['tglsurat']);
  1361. $tujuansurat = $_POST['tujuansurat'];
  1362. $perihal = $_POST['perihal'];
  1363. // query max nomor surat keluar
  1364. $qMaxnoklr = mysql_query("SELECT MAX(SUBSTRING_INDEX(SUBSTRING_INDEX(nomorsuratkeluar,'-',2),'-',-1)) maxNoklr FROM d_suratkeluar WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(nomorsuratkeluar,'-',1),'-',-1) = '$nomorsuratkeluar'");
  1365. $rMaxnoklr = mysql_fetch_array($qMaxnoklr);
  1366. // penambahan setiap nomor surat keluar
  1367. $noklr = $rMaxnoklr['maxNoklr'];
  1368. // casting to integer
  1369. $NoUrut = (int) substr($noklr,1,5);
  1370. $NoUrut++;
  1371. $newNoklr = $nomorsuratkeluar . "-" . sprintf("%05s", $NoUrut);
  1372. // nomor surat keluar final
  1373. $nomorsuratkeluar = $newNoklr . $kodesuratkeluar;
  1374. echo "<style type='text/css'>
  1375. em { font-weight: bold; padding-right: 1em; vertical-align: top; }
  1376. </style>
  1377. <script>
  1378. $(document).ready(function(){
  1379. $('#form').validate();
  1380. $('#tanggal').datepicker();
  1381. });
  1382. </script>
  1383. <div id='stylized' class='myform'>
  1384. <form id='form' name='form' method='post' enctype='multipart/form-data' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1385. <h1>Form perekaman data surat keluar</h1>
  1386. <p><b>Step II</b> - Data Surat Keluar</p>
  1387. <label>Nomor Surat
  1388. <span class='small'>Nomor Surat</span>
  1389. </label>
  1390. <input type='text' id='nomorsuratkeluar' minlength='3' name='nomorsuratkeluar' value='$nomorsuratkeluar' readonly='readonly' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'file')\" />
  1391. <label>Upload Surat
  1392. <span class='small'>Pilih file surat keluar yang telah di-<i>scanning</i> (tanpa spasi)</span>
  1393. </label>
  1394. <input type='file' id='file' name='file' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  1395. <input type='hidden' name='tglsurat' value='$tglsurat' />
  1396. <input type='hidden' name='tujuansurat' value='$tujuansurat' />
  1397. <input type='hidden' name='perihal' value='$perihal' />
  1398. <input type='hidden' name='username' value='$username' />
  1399. <input type='hidden' name='idsurat' value='$idsurat' />
  1400. <input type='submit' value='Rekam' class='button' id='submit' name='Insertdatasuratkeluar' />
  1401. <div class='spacer'></div>
  1402. </form>
  1403. </div>";
  1404. }
  1405. // Modul insert data surat keluar ===============================================================================//
  1406. elseif($_POST['Insertdatasuratkeluar']=='Rekam'){
  1407. $idsurat = $_POST['idsurat'];
  1408. $username = $_POST['username'];
  1409. $NomorSuratKeluar = $_POST['nomorsuratkeluar'];
  1410. $Nomorsuratkeluar = explode('/',$NomorSuratKeluar);
  1411. $nomorsuratkeluar = $Nomorsuratkeluar[0];
  1412. $kodesuratkeluar = $Nomorsuratkeluar[1] . "/" . $Nomorsuratkeluar[2] . "/" . $Nomorsuratkeluar[3];
  1413. $tglsurat = $_POST['tglsurat'];
  1414. $tujuansurat= $_POST['tujuansurat'];
  1415. $perihal = $_POST['perihal'];
  1416. $lokasi_file =$_FILES['file']['tmp_name'];
  1417. $nama_file =$_FILES['file']['name'];
  1418. $q = mysql_query("SELECT nomorsuratmasuk FROM d_suratmasuk WHERE idsurat='$idsurat'");
  1419. $r = mysql_fetch_object($q);
  1420. $nomorsuratmasuk= $r->nomorsuratmasuk;
  1421. $timepelaksana = date("Y-m-d H:i:s");
  1422. //insert to d_suratkeluar
  1423. mysql_query("INSERT INTO d_suratkeluar(nomorsuratkeluar,kodesuratkeluar,tujuansurat,tglsurat,perihal,nomorsuratmasuk,file,userpelaksana,timepelaksana)
  1424. VALUES('$nomorsuratkeluar','$kodesuratkeluar','$tujuansurat','$tglsurat','$perihal','$nomorsuratmasuk','$nama_file','$username','$timepelaksana')");
  1425. // Setting untuk Unix/Linux, untuk windows silakan disesuaikan
  1426. $direktori ='suratkeluar/'.basename($nama_file);
  1427. move_uploaded_file($lokasi_file,$direktori);
  1428. //update to d_suratmasuk
  1429. mysql_query("UPDATE d_suratmasuk SET nomorsuratkeluar='$nomorsuratkeluar',kodesuratkeluar='$kodesuratkeluar',statproses='6' WHERE idsurat='$idsurat'");
  1430. // pop up for confirmation
  1431. echo "<script type='text/javascript'>
  1432. $(document).ready(function() {
  1433. $('#promptkonfirmasi').dialog({
  1434. modal: true
  1435. });
  1436. });
  1437. </script>
  1438. <div id='promptkonfirmasi' title='Konfirmasi Perekaman Data Surat Keluar'>
  1439. <center><b>Data untuk surat keluar dengan nomor surat: <font color='#ffff00'><i>" . $NomorSuratKeluar . "</i></font> berhasil direkam</b></center>
  1440. <br />
  1441. <br />
  1442. <table border='0' align='center'>
  1443. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1444. <tr><td><input type='submit' name='konfirmasirekam' value='Kembali' /></td>
  1445. </form>";
  1446. }
  1447. // Modul surat keluar manual----------------------------------------------------------------------------------------//
  1448. elseif($_GET['module'] == 'suratkeluarmanual'){
  1449. $username = $_SESSION[namauser];
  1450. $seksi = strtolower(trim($_SESSION[seksi]));
  1451. echo "<style type='text/css'>
  1452. em { font-weight: bold; padding-right: 1em; vertical-align: top; }
  1453. </style>
  1454. <script>
  1455. $(document).ready(function(){
  1456. $('#form').validate();
  1457. $('#tanggal').datepicker();
  1458. });
  1459. </script>
  1460. <div id='stylized' class='myform'>
  1461. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1462. <h1>Form perekaman data surat keluar manual</h1>
  1463. <p><b>Step I</b> - Data Surat Keluar Manual</p>
  1464. <label>Seksi
  1465. <span class='small'>Seksi</span>
  1466. </label>
  1467. <select name='seksi'>
  1468. <option value='' selected='selected'>-- Pilih --</option>
  1469. <option value='kk'>Kepala Kantor</option>";
  1470. switch($seksi)
  1471. {
  1472. case "um":
  1473. echo "<option value='um'>Sub Bagian Umum</option>";
  1474. break;
  1475. case "aum":
  1476. echo "<option value='um'>Sub Bagian Umum</option>";
  1477. break;
  1478. case "pd":
  1479. echo "<option value='pd'>Pencairan Dana</option>";
  1480. break;
  1481. case "apd":
  1482. echo "<option value='pd'>Pencairan Dana</option>";
  1483. break;
  1484. case "bp":
  1485. echo "<option value='bp'>Bank & Giro Pos</option>";
  1486. break;
  1487. case "abp":
  1488. echo "<option value='bp'>Bank & Giro Pos</option>";
  1489. break;
  1490. case "vr":
  1491. echo "<option value='vr'>Verifikasi & Akuntansi</option>";
  1492. break;
  1493. case "avr":
  1494. echo "<option value='vr'>Verifikasi & Akuntansi</option>";
  1495. break;
  1496. }
  1497. echo "
  1498. </select>
  1499. <label>Jenis Surat
  1500. <span class='small'>Isikan jenis nomor surat keluar</span>
  1501. </label>
  1502. <select name='nomorsuratkeluar'>
  1503. <option value='' selected='selected'>-- Pilih --</option>
  1504. <option value='S'>S</option>
  1505. <option value='SP'>SP</option>
  1506. <option value='SKPA'>SKPA</option>
  1507. <option value='SPK'>SPK</option>
  1508. <option value='SP2LK'>SP2LK</option>
  1509. <option value='SP2S'>SP2S</option>
  1510. <option value='SP3S'>SP3S</option>
  1511. <option value='SI'>SI</option>
  1512. <option value='SE'>SE</option>
  1513. <option value='ST'>ST</option>
  1514. <option value='SKU'>SKU</option>
  1515. <option value='BA'>BA</option>
  1516. <option value='BAST'>BAST</option>
  1517. <option value='KET'>KET</option>
  1518. <option value='KEP'>KEP</option>
  1519. <option value='ND'>ND</option>
  1520. <option value='NP'>NP</option>
  1521. <option value='PEM'>PEM</option>
  1522. <option value='PRIN'>PRIN</option>
  1523. <option value='UND'>UND</option>
  1524. </select>
  1525. <label>Nomor Surat Keluar
  1526. <span class='small'>No. srt keluar contoh:1 atau 13</span>
  1527. </label>
  1528. <input type='text' id='nomorsurat' name='nomorsurat' class= 'required' minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tanggal')\" />
  1529. <label>Tanggal Surat
  1530. <span class='small'>Isikan tgl.surat keluar</span>
  1531. </label>
  1532. <input type='text' id='tanggal' name='tglsurat' class= 'required' minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'asalsurat')\" />
  1533. <label>Tujuan Surat
  1534. <span class='small'>Isikan tujuan surat keluar</span>
  1535. </label>
  1536. <input type='text' id='tujuansurat' name='tujuansurat' class='required' minlength='3' maxlength='50' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'perihal')\" />
  1537. <label>Perihal
  1538. <span class='small'>Isikan perihal surat keluar</span>
  1539. </label>
  1540. <input type='text' id='perihal' name='perihal' class='required' minlength='2' maxlength='120' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  1541. <input type='hidden' name='username' value='$username' />
  1542. <input type='submit' value='Rekam' class='button' id='submit' name='Ambilnomorsuratkeluarumum' />
  1543. <div class='spacer'></div>
  1544. </form>
  1545. </div>";
  1546. }
  1547. // Modul pengambilan nomor surat keluar----------------------------------------------------------------------------------------//
  1548. elseif($_GET['module'] == 'suratkeluar'){
  1549. $username = $_SESSION[namauser];
  1550. $seksi = strtolower(trim($_SESSION[seksi]));
  1551. echo "<style type='text/css'>
  1552. em { font-weight: bold; padding-right: 1em; vertical-align: top; }
  1553. </style>
  1554. <script>
  1555. $(document).ready(function(){
  1556. $('#form').validate();
  1557. $('#tanggal').datepicker();
  1558. });
  1559. </script>
  1560. <div id='stylized' class='myform'>
  1561. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1562. <h1>Form perekaman data surat keluar</h1>
  1563. <p><b>Step I</b> - Data Surat Keluar</p>
  1564. <label>Seksi
  1565. <span class='small'>Seksi</span>
  1566. </label>
  1567. <select name='seksi'>
  1568. <option value='' selected='selected'>-- Pilih --</option>
  1569. <option value='kk'>Kepala Kantor</option>";
  1570. switch($seksi)
  1571. {
  1572. case "um":
  1573. echo "<option value='um'>Sub Bagian Umum</option>";
  1574. break;
  1575. case "aum":
  1576. echo "<option value='um'>Sub Bagian Umum</option>";
  1577. break;
  1578. case "pd":
  1579. echo "<option value='pd'>Pencairan Dana</option>";
  1580. break;
  1581. case "bp":
  1582. echo "<option value='bp'>Bank & Giro Pos</option>";
  1583. break;
  1584. case "vr":
  1585. echo "<option value='vr'>Verifikasi & Akuntansi</option>";
  1586. break;
  1587. }
  1588. echo "
  1589. </select>
  1590. <label>Jenis Surat
  1591. <span class='small'>Isikan jenis nomor surat keluar</span>
  1592. </label>
  1593. <select name='nomorsuratkeluar'>
  1594. <option value='' selected='selected'>-- Pilih --</option>
  1595. <option value='S'>S</option>
  1596. <option value='SP'>SP</option>
  1597. <option value='SKPA'>SKPA</option>
  1598. <option value='SPK'>SPK</option>
  1599. <option value='SP2LK'>SP2LK</option>
  1600. <option value='SP2S'>SP2S</option>
  1601. <option value='SP3S'>SP3S</option>
  1602. <option value='SI'>SI</option>
  1603. <option value='SE'>SE</option>
  1604. <option value='ST'>ST</option>
  1605. <option value='SKU'>SKU</option>
  1606. <option value='BA'>BA</option>
  1607. <option value='BAST'>BAST</option>
  1608. <option value='KET'>KET</option>
  1609. <option value='KEP'>KEP</option>
  1610. <option value='ND'>ND</option>
  1611. <option value='NP'>NP</option>
  1612. <option value='PEM'>PEM</option>
  1613. <option value='PRIN'>PRIN</option>
  1614. <option value='UND'>UND</option>
  1615. </select>
  1616. <label>Tanggal Surat
  1617. <span class='small'>Isikan tgl.surat masuk</span>
  1618. </label>
  1619. <input type='text' id='tanggal' name='tglsurat' class= 'required' minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'asalsurat')\" />
  1620. <label>Tujuan Surat
  1621. <span class='small'>Isikan tujuan surat keluar</span>
  1622. </label>
  1623. <input type='text' id='tujuansurat' name='tujuansurat' class='required' minlength='3' maxlength='50' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'perihal')\" />
  1624. <label>Perihal
  1625. <span class='small'>Isikan perihal surat keluar</span>
  1626. </label>
  1627. <input type='text' id='perihal' name='perihal' class='required' minlength='2' maxlength='120' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  1628. <input type='hidden' name='username' value='$username' />
  1629. <input type='submit' value='Rekam' class='button' id='submit' name='Ambilnomorsuratkeluarumum' />
  1630. <div class='spacer'></div>
  1631. </form>
  1632. </div>";
  1633. }
  1634. // Modul pengambilan nomor surat keluar ===================================================================================//
  1635. elseif($_POST['Ambilnomorsuratkeluarumum']=='Rekam'){
  1636. $username = $_POST['username'];
  1637. $seksi = $_POST['seksi'];
  1638. // query kode surat keluar
  1639. $qKodesuratkeluar = mysql_query("SELECT wpb,kp FROM t_kanwil WHERE aktif='1'");
  1640. $rKodesuratkeluar = mysql_fetch_object($qKodesuratkeluar);
  1641. $wpb = $rKodesuratkeluar->wpb;
  1642. $kp = $rKodesuratkeluar->kp;
  1643. $yearnow = date("Y");
  1644. switch($seksi){
  1645. case kk:
  1646. $kodesuratkeluar = "/WPB." . $wpb . "/KP." . $kp . "/" . $yearnow;
  1647. break;
  1648. case um:
  1649. $kodesuratkeluar = "/WPB." . $wpb . "/KP." . $kp . "10/" . $yearnow;
  1650. break;
  1651. case pd:
  1652. $kodesuratkeluar = "/WPB." . $wpb . "/KP." . $kp . "21/" . $yearnow;
  1653. break;
  1654. case bp:
  1655. $kodesuratkeluar = "/WPB." . $wpb . "/KP." . $kp . "30/" . $yearnow;
  1656. break;
  1657. case vr:
  1658. $kodesuratkeluar = "/WPB." . $wpb . "/KP." . $kp . "40/" . $yearnow;
  1659. break;
  1660. }
  1661. $nomorsuratkeluar = $_POST['nomorsuratkeluar'];
  1662. // converting for mysql databases yyyy-mm-dd
  1663. $tglsurat = $helper->dateConvert($_POST['tglsurat']);
  1664. $tujuansurat = $_POST['tujuansurat'];
  1665. $perihal = $_POST['perihal'];
  1666. // query max nomor surat keluar
  1667. $qMaxnoklr = mysql_query("SELECT MAX(SUBSTRING_INDEX(SUBSTRING_INDEX(nomorsuratkeluar,'-',2),'-',-1)) maxNoklr FROM d_suratkeluar WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(nomorsuratkeluar,'-',1),'-',-1) = '$nomorsuratkeluar'");
  1668. $rMaxnoklr = mysql_fetch_array($qMaxnoklr);
  1669. // penambahan setiap nomor surat keluar
  1670. $noklr = $rMaxnoklr['maxNoklr'];
  1671. // casting to integer
  1672. $NoUrut = (int) substr($noklr,1,5);
  1673. $NoUrut++;
  1674. // if nomor manual
  1675. if($_POST['nomorsurat']){
  1676. $NoUrut = $_POST['nomorsurat'];
  1677. }
  1678. $newNoklr = $nomorsuratkeluar . "-" . sprintf("%05s", $NoUrut);
  1679. // nomor surat keluar final
  1680. $nomorsuratkeluar = $newNoklr . $kodesuratkeluar;
  1681. echo "<style type='text/css'>
  1682. em { font-weight: bold; padding-right: 1em; vertical-align: top; }
  1683. </style>
  1684. <script>
  1685. $(document).ready(function(){
  1686. $('#form').validate();
  1687. $('#tanggal').datepicker();
  1688. });
  1689. </script>
  1690. <div id='stylized' class='myform'>
  1691. <form id='form' name='form' method='post' enctype='multipart/form-data' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1692. <h1>Form perekaman data surat keluar</h1>
  1693. <p><b>Step II</b> - Data Surat Keluar</p>
  1694. <label>Nomor Surat
  1695. <span class='small'>Nomor Surat</span>
  1696. </label>
  1697. <input type='text' id='nomorsuratkeluar' minlength='3' name='nomorsuratkeluar' value='$nomorsuratkeluar' readonly='readonly' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'file')\" />
  1698. <label>Upload Surat
  1699. <span class='small'>Pilih file surat keluar yang telah di-<i>scanning</i> (tanpa spasi)</span>
  1700. </label>
  1701. <input type='file' id='file' name='file' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  1702. <input type='hidden' name='tglsurat' value='$tglsurat' />
  1703. <input type='hidden' name='tujuansurat' value='$tujuansurat' />
  1704. <input type='hidden' name='perihal' value='$perihal' />
  1705. <input type='hidden' name='username' value='$username' />
  1706. <input type='submit' value='Rekam' class='button' id='submit' name='Insertdatasuratkeluarumum' />
  1707. <div class='spacer'></div>
  1708. </form>
  1709. </div>";
  1710. }
  1711. // Modul insert data surat keluar umum ===============================================================================//
  1712. elseif($_POST['Insertdatasuratkeluarumum']=='Rekam'){
  1713. $idsurat = $_POST['idsurat'];
  1714. $username = $_POST['username'];
  1715. $NomorSuratKeluar = $_POST['nomorsuratkeluar'];
  1716. $Nomorsuratkeluar = explode('/',$NomorSuratKeluar);
  1717. $nomorsuratkeluar = $Nomorsuratkeluar[0];
  1718. $kodesuratkeluar = $Nomorsuratkeluar[1] . "/" . $Nomorsuratkeluar[2] . "/" . $Nomorsuratkeluar[3];
  1719. $tglsurat = $_POST['tglsurat'];
  1720. $tujuansurat= $_POST['tujuansurat'];
  1721. $perihal = $_POST['perihal'];
  1722. $lokasi_file =$_FILES['file']['tmp_name'];
  1723. $nama_file =$_FILES['file']['name'];
  1724. $q = mysql_query("SELECT nomorsuratmasuk FROM d_suratmasuk WHERE idsurat='$idsurat'");
  1725. $r = mysql_fetch_object($q);
  1726. $nomorsuratmasuk= $r->nomorsuratmasuk;
  1727. $timepelaksana = date("Y-m-d H:i:s");
  1728. //insert to d_suratkeluar
  1729. mysql_query("INSERT INTO d_suratkeluar(nomorsuratkeluar,kodesuratkeluar,tujuansurat,tglsurat,perihal,nomorsuratmasuk,file,userpelaksana,timepelaksana)
  1730. VALUES('$nomorsuratkeluar','$kodesuratkeluar','$tujuansurat','$tglsurat','$perihal','$nomorsuratmasuk','$nama_file','$username','$timepelaksana')");
  1731. // Setting untuk Unix/Linux, untuk windows silakan disesuaikan
  1732. $direktori ='suratkeluar/'.basename($nama_file);
  1733. move_uploaded_file($lokasi_file,$direktori);
  1734. // pop up for confirmation
  1735. echo "<script type='text/javascript'>
  1736. $(document).ready(function() {
  1737. $('#promptkonfirmasi').dialog({
  1738. modal: true
  1739. });
  1740. });
  1741. </script>
  1742. <div id='promptkonfirmasi' title='Konfirmasi Perekaman Data Surat Keluar'>
  1743. <center><b>Data untuk surat keluar dengan nomor surat: <font color='#ffff00'><i>" . $NomorSuratKeluar . "</i></font> berhasil direkam</b></center>
  1744. <br />
  1745. <br />
  1746. <table border='0' align='center'>
  1747. <form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1748. <tr><td><input type='submit' name='konfirmasirekam' value='Kembali' /></td>
  1749. </form>";
  1750. }
  1751. // Modul Form pencarian surat keluar =======================================================================================//
  1752. elseif($_GET['module']=='searchsuratkeluar'){
  1753. echo "<script type=\"text/javascript\">
  1754. $(document).ready(function() {
  1755. $('#tglawalsurat').datepicker({
  1756. changeMonth: true,
  1757. changeYear: true
  1758. });
  1759. });
  1760. $(document).ready(function() {
  1761. $('#tglakhirsurat').datepicker({
  1762. changeMonth: true,
  1763. changeYear: true
  1764. });
  1765. });
  1766. </script>
  1767. <div id='stylized' class='myform'>
  1768. <form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1769. <h1>Form multikategori pencarian data surat keluar</h1>
  1770. <p>Form ini digunakan dalam pencarian data surat keluar</p>
  1771. <label>Nomor Surat</label>
  1772. <input type='checkbox' class='checkbox' name='nomorsuratkeluarCek' />
  1773. <input type='text' id='nomorsuratkeluar' minlength='3' name='nomorsuratkeluar' maxlength='20' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tglsurat')\" />
  1774. <br />
  1775. <br />
  1776. <p><center><b>Range Tanggal Surat</b></center></p>
  1777. <label>Tgl.Awal Surat</label>
  1778. <input type='checkbox' class='checkbox' name='tglawalsuratCek' />
  1779. <input type='text' id='tglawalsurat' name='tglawalsurat' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tglakhirsurat')\" />
  1780. <label>Tgl.Akhir Surat</label>
  1781. <input type='checkbox' class='checkbox' name='tglakhirsuratCek' />
  1782. <input type='text' id='tglakhirsurat' name='tglakhirsurat' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'asalsurat')\" />
  1783. <br />
  1784. <br />
  1785. <br />
  1786. <br />
  1787. <br />
  1788. <br />
  1789. <p></p>
  1790. <label>Tujuan Surat</label>
  1791. <input type='checkbox' class='checkbox' name='tujuansuratCek' />
  1792. <input type='text' id='tujuansurat' name='tujuansurat' maxlength='75' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'perihal')\" />
  1793. <label>Perihal</label>
  1794. <input type='checkbox' class='checkbox' name='perihalCek' />
  1795. <input type='text' id='perihal' name='perihal' maxlength='120' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />
  1796. <input type='submit' value='Cari' class='button' id='submit' name='cariDokSuratKeluar' />
  1797. <div class='spacer'></div>
  1798. </form>
  1799. </div>";
  1800. }
  1801. // Modul Search Surat Keluar----------------------------------------------------------------------------------------------------------------------------------------------//
  1802. elseif($_POST['cariDokSuratKeluar'] == "Cari"){
  1803. $nomorsuratkeluarCek = $_POST['nomorsuratkeluarCek'];
  1804. $tglawalsuratCek = $_POST['tglawalsuratCek'];
  1805. $tglakhirsuratCek = $_POST['tglakhirsuratCek'];
  1806. $tujuansuratCek = $_POST['tujuansuratCek'];
  1807. $perihalCek = $_POST['perihalCek'];
  1808. $nomorsuratkeluar = $_POST['nomorsuratkeluar'];
  1809. $Tglawalsurat = $_POST['tglawalsurat'];
  1810. $tglawalsurat = $helper->dateConvert($Tglawalsurat);
  1811. $Tglakhirsurat = $_POST['tglakhirsurat'];
  1812. $tglakhirsurat = $helper->dateConvert($Tglakhirsurat);
  1813. $tujuansurat = $_POST['tujuansurat'];
  1814. $perihal = $_POST['perihal'];
  1815. $bagianWhere="";
  1816. if(isset($nomorsuratkeluarCek)){
  1817. $nomorsuratmasuk;
  1818. if(empty($bagianWhere)){
  1819. $bagianWhere .= "nomorsuratkeluar='$nomorsuratkeluar'";
  1820. }
  1821. }
  1822. if(isset($tglawalsuratCek)){
  1823. if(empty($bagianWhere)){
  1824. $bagianWhere .= "tglsurat>='$tglawalsurat'";
  1825. }
  1826. else{
  1827. $bagianWhere .= "AND tglsurat>='$tglawalsurat'";
  1828. }
  1829. }
  1830. if(isset($tglakhirsuratCek)){
  1831. if(empty($bagianWhere)){
  1832. $bagianWhere .= "tglsurat<='$tglakhirsurat'";
  1833. }
  1834. else{
  1835. $bagianWhere .= "AND tglsurat<='$tglakhirsurat'";
  1836. }
  1837. }
  1838. if(isset($tujuansuratCek)){
  1839. if(empty($bagianWhere)){
  1840. $bagianWhere .= "tujuansurat REGEXP '$tujuansurat'";
  1841. }
  1842. else{
  1843. $bagianWhere .= "AND tujuansurat REGEXP '$tujuansurat'";
  1844. }
  1845. }
  1846. if(isset($perihalCek)){
  1847. if(empty($bagianWhere)){
  1848. $bagianWhere .= "perihal REGEXP '$perihal'";
  1849. }
  1850. else{
  1851. $bagianWhere .= "AND perihal REGEXP '$perihal'";
  1852. }
  1853. }
  1854. $queryCek = "SELECT nomorsuratkeluar,tglsurat,tujuansurat,perihal FROM d_suratkeluar WHERE ".$bagianWhere;
  1855. $qCek = mysql_query($queryCek)or die(mysql_error());
  1856. $rCek = mysql_fetch_row($qCek);
  1857. if($rCek > 0){
  1858. echo "<div id='stylized' class='myform'>
  1859. <form id='form' name='formShowNoRakArsip' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>
  1860. <h1>Form hasil pencarian data surat keluar</h1>
  1861. <p>Hasil pencarian data surat keluar</p>
  1862. </form>
  1863. </div>
  1864. <br />
  1865. <table class='normaltable' border='0'>
  1866. <tr>
  1867. <th width='6%'>No.</th>
  1868. <th width='10%'>No. Surat</th>
  1869. <th width='10%'>Tgl. Surat</th>
  1870. <th width='24%'>Tujuan Surat</th>
  1871. <th width='24%'>Perihal</th>
  1872. <th width='15%'>Surat Masuk</th>
  1873. <th width='10%'>File Surat Keluar</th>
  1874. </tr>";
  1875. $query = "SELECT nomorsuratmasuk,date_format(tglsurat,'%d-%m-%Y') AS tglsurat,tujuansurat,perihal,CONCAT(nomorsuratkeluar,kodesuratkeluar) AS nomorsuratkeluar,file FROM d_suratkeluar WHERE ".$bagianWhere;
  1876. $qCari = mysql_query($query)or die(mysql_error());
  1877. $no = 1;
  1878. $oddcol = "#CCFF99";
  1879. $evencol = "#CCDD88";
  1880. while($rCari = mysql_fetch_array($qCari)){
  1881. if($no % 2 == 0) {$color = $evencol;}
  1882. else{$color = $oddcol;}
  1883. $nomorsuratmasuk = $rCari['nomorsuratmasuk'];
  1884. $tglsurat = $rCari['tglsurat'];
  1885. $tujuansurat = $rCari['tujuansurat'];
  1886. $perihal = $rCari['perihal'];
  1887. $nomorsuratkeluar = $rCari['nomorsuratkeluar'];
  1888. $file = $rCari['file'];
  1889. echo"<tr bgcolor='$color'>
  1890. <td>$no</td>
  1891. <td>$nomorsuratkeluar</td>
  1892. <td>$tglsurat</td>
  1893. <td>$tujuansurat</td>
  1894. <td>$perihal</td>
  1895. <td>$nomorsuratmasuk</td>
  1896. <td><b><i><a href='suratkeluar/$file' target='_blank'>$file</a></b></i></td>
  1897. </tr>";
  1898. $no++;
  1899. }
  1900. echo"</table>";
  1901. }
  1902. else{
  1903. echo "<script type='text/javascript'>
  1904. alert('Data tersebut tidak ditemukan');
  1905. </script>";
  1906. }
  1907. }
  1908. // Keluar Aplikasi ===============================================================================//
  1909. elseif($_GET['module'] == 'keluar'){
  1910. session_start();
  1911. session_destroy();
  1912. header('location: index.php');
  1913. }
  1914. ?>
  1915. <style>
  1916. .img{
  1917. border:2px solid #72a143;
  1918. padding:2px;
  1919. background:#ffeda5;
  1920. }
  1921. .img2{
  1922. border:2px solid #F0892C;
  1923. padding:2px;
  1924. background:#ffeda5;
  1925. }
  1926. </style>