PageRenderTime 62ms CodeModel.GetById 21ms 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

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

    

  1. <?php

    2. 

  2. 

    3. 

  3. global $timezone;

    4. 

  4. $timezone 	= "Asia/Jakarta";

    5. 

  5. if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);

    6. 

  6. 

    7. 

  7. // Halaman utama (Home)

    8. 

  8. if ($_GET['module']=='home'){

    9. 

  9. }

    10. 

  10. 

    11. 

  11. // Modul perekaman data surat masuk secara manual

    12. 

  12. elseif($_GET['module'] == 'terimasuratmasukmanual'){

    13. 

  13. echo "<style type='text/css'>

    14. 

  14. 			em { font-weight: bold; padding-right: 1em; vertical-align: top; }

    15. 

  15. 		</style>

    16. 

  16. 			<script>

    17. 

  17. 			$(document).ready(function(){

    18. 

  18. 				$('#form').validate();

    19. 

  19. 				$('#tanggal').datepicker();

    20. 

  20. 			});

    21. 

  21. 	

    22. 

  22. 		

    23. 

  23. 		</script>

    24. 

  24. 		<div id='stylized' class='myform'>

    25. 

  25. 			<form id='form' name='form' method='post'  enctype='multipart/form-data'  action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    26. 

  26. 			<h1>Form perekaman data surat masuk manual</h1>

    27. 

  27. 					<p>Data Surat Masuk Manual</p>

    28. 

  28. 					<label>Nomor Agenda

    29. 

  29. 					<span class='small'>Agd suratmasuk cth:1 atau 12</span>

    30. 

  30. 					</label>

    31. 

  31. 					<input type='text' id='noagenda' class='required' minlength='1' name='noagendaman' maxlength='10'  onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'nomorsuratmasuk')\" />

    32. 

  32. 	

    33. 

  33. 					<label>Nomor Surat

    34. 

  34. 					<span class='small'>Isikan no.surat masuk</span>

    35. 

  35. 					</label>

    36. 

  36. 					<input type='text' id='nomorsuratmasuk' class='required' minlength='3' name='nomorsuratmasuk' maxlength='50' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tglsurat')\" />

    37. 

  37. 					

    38. 

  38. 					<label>Tanggal Surat

    39. 

  39. 					<span class='small'>Isikan tgl.surat masuk</span>

    40. 

  40. 					</label>

    41. 

  41. 					<input type='text' id='tanggal' name='tglsurat'  class= 'required' minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'asalsurat')\" />

    42. 

  42. 					

    43. 

  43. 					<label>Asal Surat

    44. 

  44. 					<span class='small'>Isikan asal surat masuk</span>

    45. 

  45. 					</label>

    46. 

  46. 					<input type='text' id='asalsurat' name='asalsurat'  class='required' minlength='1' maxlength='50' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tujuansurat')\" />

    47. 

  47. 				

    48. 

  48. 					<label>Tujuan Surat

    49. 

  49. 					<span class='small'>Isikan tujuan surat masuk</span>

    50. 

  50. 					</label>

    51. 

  51. 					<input type='text' id='tujuansurat' name='tujuansurat'  class='required' minlength='3' maxlength='50' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'perihal')\" />

    52. 

  52. 					

    53. 

  53. 					<label>Perihal

    54. 

  54. 					<span class='small'>Isikan perihal surat masuk</span>

    55. 

  55. 					</label>

    56. 

  56. 					<input type='text' id='perihal' name='perihal'  class='required' minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'file')\" />

    57. 

  57. 					

    58. 

  58. 					<label>Upload Surat

    59. 

  59. 					<span class='small'>Pilih file surat masuk yang telah di-<i>scanning</i> (tanpa spasi)</span>

    60. 

  60. 					</label>

    61. 

  61. 					<input type='file' id='file' name='file'  minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />

    62. 

  62. 					

    63. 

  63. 					<input type='submit' value='Rekam' class='button' id='submit' name='Insertdatasuratmasuk' />

    64. 

  64. 					<div class='spacer'></div>

    65. 

  65. 				</form>

    66. 

  66. 		</div>";

    67. 

  67. }

    68. 

  68. 

    69. 

  69. // Modul Rekam Data Surat Masuk ==================================================================================//

    70. 

  70. elseif($_GET['module']=='terimasuratmasuk'){

    71. 

  71. 	$qMaxagd	= mysql_query("SELECT MAX(noagenda) maxAgd FROM d_suratmasuk");

    72. 

  72. 	$rMaxagd	= mysql_fetch_array($qMaxagd);

    73. 

  73. 	

    74. 

  74. 	//penambahan setiap nomor agenda

    75. 

  75. 	$noagd		= $rMaxagd['maxAgd'];

    76. 

  76. 	//kode nomor agenda, you can change here

    77. 

  77. 	$jenAgd		= 'AGD';

    78. 

  78. 	$noUrut		= (int) $noagd;

    79. 

  79. 	$noUrut++;

    80. 

  80. 	//hasil akhir nomor agenda

    81. 

  81. 	$newAgd	= $jenAgd.'-'.sprintf("%05s",$noUrut);

    82. 

  82. 	

    83. 

  83. 	echo "<style type='text/css'>

    84. 

  84. 			em { font-weight: bold; padding-right: 1em; vertical-align: top; }

    85. 

  85. 		</style>

    86. 

  86. 			<script>

    87. 

  87. 			$(document).ready(function(){

    88. 

  88. 				$('#form').validate();

    89. 

  89. 				$('#tanggal').datepicker();

    90. 

  90. 			});

    91. 

  91. 	

    92. 

  92. 		

    93. 

  93. 		</script>

    94. 

  94. 		<div id='stylized' class='myform'>

    95. 

  95. 			<form id='form' name='form' method='post'  enctype='multipart/form-data'  action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    96. 

  96. 			<h1>Form perekaman data surat masuk</h1>

    97. 

  97. 					<p>Data Surat Masuk</p>

    98. 

  98. 					<label>Nomor Agenda

    99. 

  99. 					<span class='small'>Nomor agenda</span>

    100. 

  100. 					</label>

    101. 

  101. 					<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')\" />

    102. 

  102. 	

    103. 

  103. 					<label>Nomor Surat

    104. 

  104. 					<span class='small'>Isikan no.surat masuk</span>

    105. 

  105. 					</label>

    106. 

  106. 					<input type='text' id='nomorsuratmasuk' class='required' minlength='3' name='nomorsuratmasuk' maxlength='50' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tglsurat')\" />

    107. 

  107. 					

    108. 

  108. 					<label>Tanggal Surat

    109. 

  109. 					<span class='small'>Isikan tgl.surat masuk</span>

    110. 

  110. 					</label>

    111. 

  111. 					<input type='text' id='tanggal' name='tglsurat'  class= 'required' minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'asalsurat')\" />

    112. 

  112. 					

    113. 

  113. 					<label>Asal Surat

    114. 

  114. 					<span class='small'>Isikan asal surat masuk</span>

    115. 

  115. 					</label>

    116. 

  116. 					<input type='text' id='asalsurat' name='asalsurat'  class='required' minlength='1' maxlength='50' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tujuansurat')\" />

    117. 

  117. 				

    118. 

  118. 					<label>Tujuan Surat

    119. 

  119. 					<span class='small'>Isikan tujuan surat masuk</span>

    120. 

  120. 					</label>

    121. 

  121. 					<input type='text' id='tujuansurat' name='tujuansurat'  class='required' minlength='3' maxlength='50' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'perihal')\" />

    122. 

  122. 					

    123. 

  123. 					<label>Perihal

    124. 

  124. 					<span class='small'>Isikan perihal surat masuk</span>

    125. 

  125. 					</label>

    126. 

  126. 					<input type='text' id='perihal' name='perihal'  class='required' minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'file')\" />

    127. 

  127. 					

    128. 

  128. 					<label>Upload Surat

    129. 

  129. 					<span class='small'>Pilih file surat masuk yang telah di-<i>scanning</i> (tanpa spasi)</span>

    130. 

  130. 					</label>

    131. 

  131. 					<input type='file' id='file' name='file'  minlength='2' maxlength='30' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />

    132. 

  132. 					

    133. 

  133. 					<input type='submit' value='Rekam' class='button' id='submit' name='Insertdatasuratmasuk' />

    134. 

  134. 					<div class='spacer'></div>

    135. 

  135. 				</form>

    136. 

  136. 		</div>";

    137. 

  137. }

    138. 

  138. // Modul Form Perekaman Data Surat Masuk -----------------------------------------------------------------------------------------------------------------------------//

    139. 

  139. elseif($_POST['Insertdatasuratmasuk'] == 'Rekam'){	

    140. 

  140. 	$NoAgenda		= explode("-",$_POST['noagenda']);

    141. 

  141. 	$kodeagenda		= $NoAgenda[0];

    142. 

  142. 	$noagenda		= $NoAgenda[1];

    143. 

  143. 	if($_POST['noagendaman']){

    144. 

  144. 		$noagenda	= sprintf("%05s",$_POST['noagendaman']);

    145. 

  145. 		$kodeagenda	= "AGD";

    146. 

  146. 	}

    147. 

  147. 	$nosuratmasuk	= $_POST['nomorsuratmasuk'];

    148. 

  148. 	$asalsurat		= $_POST['asalsurat'];

    149. 

  149. 	$tujuansurat	= $_POST['tujuansurat'];

    150. 

  150. 	$Tglsurat		= $_POST['tglsurat'];	

    151. 

  151. 	$tglsurat		= $helper->dateConvert($Tglsurat);

    152. 

  152. 	$perihal		= $_POST['perihal'];

    153. 

  153. 	$username		= $_SESSION[namauser];

    154. 

  154. 	$timeloket		= date("Y-m-d H:i:s");

    155. 

  155. 	

    156. 

  156. 	$lokasi_file	=$_FILES['file']['tmp_name'];

    157. 

  157. 	$nama_file		=$_FILES['file']['name'];

    158. 

  158. 	

    159. 

  159. 	//statproses = 1 -- terima loket umum

    160. 

  160. 	mysql_query("INSERT INTO d_suratmasuk(kodeagenda,noagenda,nomorsuratmasuk,asalsurat,tujuansurat,tglsurat,perihal,userloket,timeloket,file,statproses) 

    161. 

  161. 				VALUES('$kodeagenda','$noagenda','$nosuratmasuk','$asalsurat','$tujuansurat','$tglsurat','$perihal','$username','$timeloket','$nama_file','1')");

    162. 

  162. 	// Setting untuk Unix/Linux, untuk windows silakan disesuaikan

    163. 

  163. 	$direktori		='suratmasuk/'.basename($nama_file);

    164. 

  164. 	

    165. 

  165. 	move_uploaded_file($lokasi_file,$direktori);

    166. 

  166. 	

    167. 

  167. 	echo "<script type='text/javascript'>

    168. 

  168. 			$(document).ready(function() {

    169. 

  169. 				$('#promptkonfirmasi').dialog({

    170. 

  170. 					modal: true

    171. 

  171. 				});

    172. 

  172. 			});

    173. 

  173. 		</script>

    174. 

  174. 			<div id='promptkonfirmasi' title='Konfirmasi Entri Data Surat Masuk'>

    175. 

  175. 			<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>

    176. 

  176. 			<br />

    177. 

  177. 			<br />

    178. 

  178. 			<table border='0' align='center'>

    179. 

  179. 			<form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    180. 

  180. 				<tr><td><input type='submit' name='konfirmasirekam' value='Kembali'  /></td>

    181. 

  181. 			</form>";

    182. 

  182. }

    183. 

  183. 

    184. 

  184. // Modul Cetak Disposisi ---------------------------------------------------------------------------------------------------------------------------------------------------------------------/

    185. 

  185. elseif($_GET['module']=='cetakdisposisi'){

    186. 

  186. 	$username	= $_SESSION[namauser];

    187. 

  187. 	echo "<div id='stylized' class='myform'>

    188. 

  188. 			<form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    189. 

  189. 			<h1>Cetak Disposisi Surat Masuk</h1>

    190. 

  190. 					<p>Form ini digunakan untuk melakukan pencetakan disposisi</p>

    191. 

  191. 			</form>

    192. 

  192. 		</div>

    193. 

  193. 					<br />

    194. 

  194. 					<br />

    195. 

  195. 					<div id='normaltable'>

    196. 

  196. 			

    197. 

  197. 					<table class='normaltable' width='100%'>

    198. 

  198. 					<tr>

    199. 

  199. 					<th width='10%' height='35'>No.</th>

    200. 

  200. 					<th width='15%'>No. Agenda</th>

    201. 

  201. 					<th width='15%'>No. Surat</th>

    202. 

  202. 					<th width='15%'>Tgl. Surat</th>

    203. 

  203. 					<th width='15%'>Asal Surat</th>

    204. 

  204. 					<th width='15%'>Perihal</th>

    205. 

  205. 					<th width='15%' colspan='3'>Tindakan</th>

    206. 

  206. 					</tr>";

    207. 

  207. 			

    208. 

  208. 			$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);

    209. 

  209. 			$no	=1;

    210. 

  210. 			$oddcol			= "#CCFF99";

    211. 

  211. 			$evencol		= "#CCDD88";

    212. 

  212. 			while($rDataSurat	= mysql_fetch_object($qDataSurat)){

    213. 

  213. 				if($no % 2 == 0) {$color = $evencol;}

    214. 

  214. 				else{$color = $oddcol;}

    215. 

  215. 				echo "<tr bgcolor='$color'>

    216. 

  216. 						<td height='45'>$no</td>

    217. 

  217. 						<td>$rDataSurat->noagenda</td>

    218. 

  218. 						<td>$rDataSurat->nomorsuratmasuk</td>

    219. 

  219. 						<td>$rDataSurat->tglsurat</td>

    220. 

  220. 						<td>$rDataSurat->asalsurat</td>

    221. 

  221. 						<td>$rDataSurat->perihal</td>

    222. 

  222. 						<td>

    223. 

  223. 							<form name='form1' method='post' action='report/disposisisuratmasuk.php'>

    224. 

  224. 								<input type='hidden' name='username' value='$username' />

    225. 

  225. 								<input type='hidden' name='idsurat' value='$rDataSurat->idsurat' />

    226. 

  226. 								<input type='hidden' name='noagenda' value='$rDataSurat->noagenda' />

    227. 

  227. 								<input type='hidden' name='nomorsuratmasuk' value='$rDataSurat->nomorsuratmasuk' />

    228. 

  228. 								<input type='hidden' name='tglsurat' value='$rDataSurat->tglsurat' />

    229. 

  229. 								<input type='hidden' name='asalsurat' value='$rDataSurat->asalsurat' />

    230. 

  230. 								<input type='hidden' name='perihal' value='$rDataSurat->perihal' />

    231. 

  231. 								<input type='hidden' name='disposisi' value='$rDataSurat->disposisi' />

    232. 

  232. 								<input type='hidden' name='batasselesai' value='$rDataSurat->batasselesai' />

    233. 

  233. 								<input type='hidden' name='statproses' value='$rDataSurat->statproses' />

    234. 

  234. 								<input type='hidden' name='um' value='$rDataSurat->um' />

    235. 

  235. 								<input type='hidden' name='pd' value='$rDataSurat->pd' />

    236. 

  236. 								<input type='hidden' name='bp' value='$rDataSurat->bp' />

    237. 

  237. 								<input type='hidden' name='vr' value='$rDataSurat->vr' />

    238. 

  238. 								<input type='hidden' name='sk' value='$rDataSurat->sk' />

    239. 

  239. 								

    240. 

  240. 								<input type='hidden' name='sangatsegera' value='$rDataSurat->sangatsegera' />

    241. 

  241. 								<input type='hidden' name='segera' value='$rDataSurat->segera' />

    242. 

  242. 								<input type='hidden' name='biasa' value='$rDataSurat->biasa' />

    243. 

  243. 								<input type='hidden' name='setuju' value='$rDataSurat->setuju' />

    244. 

  244. 								<input type='hidden' name='tolak' value='$rDataSurat->tolak' />

    245. 

  245. 								<input type='hidden' name='telitipendapat' value='$rDataSurat->telitipendapat' />

    246. 

  246. 								<input type='hidden' name='untukdiketahui' value='$rDataSurat->untukdiketahui' />

    247. 

  247. 								<input type='hidden' name='selesaikan' value='$rDataSurat->selesaikan' />

    248. 

  248. 								<input type='hidden' name='sesuaicatatan' value='$rDataSurat->sesuaicatatan' />

    249. 

  249. 								<input type='hidden' name='untukperhatian' value='$rDataSurat->untukperhatian' />

    250. 

  250. 								<input type='hidden' name='edarkan' value='$rDataSurat->edarkan' />

    251. 

  251. 								<input type='hidden' name='jawab' value='$rDataSurat->jawab' />

    252. 

  252. 								<input type='hidden' name='perbaiki' value='$rDataSurat->perbaiki' />

    253. 

  253. 								<input type='hidden' name='bicarakandgsaya' value='$rDataSurat->bicarakandgsaya' />

    254. 

  254. 								<input type='hidden' name='bicarakanbersama' value='$rDataSurat->bicarakanbersama' />

    255. 

  255. 								<input type='hidden' name='ingatkan' value='$rDataSurat->ingatkan' />

    256. 

  256. 								<input type='hidden' name='simpan' value='$rDataSurat->simpan' />

    257. 

  257. 								<input type='hidden' name='disiapkan' value='$rDataSurat->disiapkan' />

    258. 

  258. 								<input type='hidden' name='harapdihadiridiwakili' value='$rDataSurat->harapdihadiridiwakili' />

    259. 

  259. 								

    260. 

  260. 								<input type='submit' class='normaltablesubmit' name='reportcetakdisposisi' value='Cetak' onClick=\"setTimeout('location.reload(true);',1000); this.form.target='_blank'; return true;\"  />

    261. 

  261. 							</form>

    262. 

  262. 						</td>

    263. 

  263. 					</tr>";

    264. 

  264. 				$no++;

    265. 

  265. 			}

    266. 

  266. 			echo "</table>

    267. 

  267. 					</div>

    268. 

  268. 					</form>";

    269. 

  269. 

    270. 

  270. }

    271. 

  271. 

    272. 

  272. // Modul Tabel Disposisi Pejabat/Kepala Kantor ========================================================================================//

    273. 

  273. elseif($_GET['module']=='disposisiPejabat'){

    274. 

  274. 	$username	= $_SESSION[namauser];

    275. 

  275. 	echo "<div id='stylized' class='myform'>

    276. 

  276. 			<form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    277. 

  277. 			<h1>Tabel Disposisi Surat Masuk</h1>

    278. 

  278. 					<p>Form ini digunakan untuk melakukan pencatatan disposisi </p>

    279. 

  279. 			</form>

    280. 

  280. 		</div>

    281. 

  281. 					<br />

    282. 

  282. 					<br />

    283. 

  283. 					<div id='normaltable'>

    284. 

  284. 			

    285. 

  285. 					<table class='normaltable' width='100%'>

    286. 

  286. 					<tr>

    287. 

  287. 					<th width='10%' height='35'>No.</th>

    288. 

  288. 					<th width='15%'>No. Agenda</th>

    289. 

  289. 					<th width='15%'>No. Surat</th>

    290. 

  290. 					<th width='15%'>Tgl. Surat</th>

    291. 

  291. 					<th width='15%'>Asal Surat</th>

    292. 

  292. 					<th width='15%'>Perihal</th>

    293. 

  293. 					<th width='15%' colspan='3'>Tindakan</th>

    294. 

  294. 					</tr>";

    295. 

  295. 			

    296. 

  296. 			$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);

    297. 

  297. 			$no	=1;

    298. 

  298. 			$oddcol			= "#CCFF99";

    299. 

  299. 			$evencol		= "#CCDD88";

    300. 

  300. 			while($rDataSurat	= mysql_fetch_object($qDataSurat)){

    301. 

  301. 				if($no % 2 == 0) {$color = $evencol;}

    302. 

  302. 				else{$color = $oddcol;}

    303. 

  303. 				echo "<tr bgcolor='$color'>

    304. 

  304. 						<td height='45'>$no</td>

    305. 

  305. 						<td>$rDataSurat->noagenda</td>

    306. 

  306. 						<td>$rDataSurat->nomorsuratmasuk</td>

    307. 

  307. 						<td>$rDataSurat->tglsurat</td>

    308. 

  308. 						<td>$rDataSurat->asalsurat</td>

    309. 

  309. 						<td>$rDataSurat->perihal</td>

    310. 

  310. 						<td>

    311. 

  311. 							<form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    312. 

  312. 								<input type='hidden' name='username' value='$username' />

    313. 

  313. 								<input type='hidden' name='idsurat' value='$rDataSurat->idsurat' />

    314. 

  314. 								<input type='submit' class='normaltablesubmit' name='catatdisposisi' value='Disposisi' />

    315. 

  315. 							</form>

    316. 

  316. 						</td>

    317. 

  317. 					</tr>";

    318. 

  318. 				$no++;

    319. 

  319. 			}

    320. 

  320. 			echo "</table>

    321. 

  321. 					</div>

    322. 

  322. 					</form>";

    323. 

  323. }

    324. 

  324. 

    325. 

  325. // Modul Catat Disposisi ---------------------------------------------------------------------------------------//

    326. 

  326. elseif($_POST['catatdisposisi']=='Disposisi') {

    327. 

  327. 	$username	= $_POST['username'];

    328. 

  328. 	$idsurat	= $_POST['idsurat'];

    329. 

  329. 	echo "	<script>

    330. 

  330. 			$(document).ready(function(){

    331. 

  331. 				$('#form').validate();

    332. 

  332. 				$('#tanggal').datepicker();

    333. 

  333. 			});

    334. 

  334. 		</script>

    335. 

  335. 	<div id='stylized' class='myform'>

    336. 

  336. 	<form id='form' name='formShowBAArsip' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    337. 

  337. 	<h1>Form rekam disposisi</h1> 

    338. 

  338. 		<p>Form ini digunakan Kepala Kantor untuk mencatat disposisi</p>

    339. 

  339. 		<br />	

    340. 

  340. 		

    341. 

  341. 			<label>Sangat Segera</label>

    342. 

  342. 			<input type='checkbox' class='checkbox' name='sangatsegeraCek' />

    343. 

  343. 			

    344. 

  344. 			<label>Segera</label>

    345. 

  345. 			<input type='checkbox' class='checkbox' name='segeraCek' />

    346. 

  346. 				

    347. 

  347. 			<label>Biasa</label>

    348. 

  348. 			<input type='checkbox' class='checkbox' name='biasaCek' />

    349. 

  349. 		

    350. 

  350. 		<br />

    351. 

  351. 		<br />

    352. 

  352. 		<br />

    353. 

  353. 		<br />

    354. 

  354. 		<br />	

    355. 

  355. 		<p></p>

    356. 

  356. 		<p class='header'>Disposisi Kepala Kantor Kepada</p>

    357. 

  357. 			<label>Seksi Umum</label>

    358. 

  358. 			<input type='checkbox' class='checkbox' name='seksiumCek' />

    359. 

  359. 					

    360. 

  360. 			<label>Seksi Pencairan Dana</label>

    361. 

  361. 			<input type='checkbox' class='checkbox' name='seksipdCek' />

    362. 

  362. 					

    363. 

  363. 			<label>Seksi Bank Giro Pos</label>

    364. 

  364. 			<input type='checkbox' class='checkbox' name='seksibpCek' />

    365. 

  365. 			

    366. 

  366. 			<label>Seksi Verak</label>

    367. 

  367. 			<input type='checkbox' class='checkbox' name='seksivrCek' />

    368. 

  368. 				

    369. 

  369. 			<label>Sekretariat</label>

    370. 

  370. 			<input type='checkbox' class='checkbox' name='sekretariatCek' />

    371. 

  371. 			<br />

    372. 

  372. 			<br />

    373. 

  373. 			<br />

    374. 

  374. 			<br />

    375. 

  375. 			<br />

    376. 

  376. 			<br />

    377. 

  377. 		

    378. 

  378. 		<p></p>	

    379. 

  379. 		<p class='header'>Petunjuk</p>	

    380. 

  380. 			<label>Setuju</label>

    381. 

  381. 			<input type='checkbox' class='checkbox' name='setujuCek' />

    382. 

  382. 			

    383. 

  383. 			<label>Selesaikan</label>

    384. 

  384. 			<input type='checkbox' class='checkbox' name='selesaikanCek' />

    385. 

  385. 			

    386. 

  386. 			<label>Jawab</label>

    387. 

  387. 			<input type='checkbox' class='checkbox' name='jawabCek' />

    388. 

  388. 			

    389. 

  389. 			<label>Ingatkan</label>

    390. 

  390. 			<input type='checkbox' class='checkbox' name='ingatkanCek' />

    391. 

  391. 			

    392. 

  392. 			<label>Tolak</label>

    393. 

  393. 			<input type='checkbox' class='checkbox' name='tolakCek' />

    394. 

  394. 			

    395. 

  395. 			<label>Sesuai Catatan</label>

    396. 

  396. 			<input type='checkbox' class='checkbox' name='sesuaicatatanCek' />

    397. 

  397. 			

    398. 

  398. 			<label>Perbaiki</label>

    399. 

  399. 			<input type='checkbox' class='checkbox' name='perbaikiCek' />

    400. 

  400. 			

    401. 

  401. 			<label>Simpan</label>

    402. 

  402. 			<input type='checkbox' class='checkbox' name='simpanCek' />

    403. 

  403. 			

    404. 

  404. 			<label>Teliti & Pendapat</label>

    405. 

  405. 			<input type='checkbox' class='checkbox' name='telitipendapatCek' />

    406. 

  406. 			

    407. 

  407. 			<label>Untuk Perhatian</label>

    408. 

  408. 			<input type='checkbox' class='checkbox' name='untukperhatianCek' />

    409. 

  409. 			

    410. 

  410. 			<label>Bicarakan Dengan Saya</label>

    411. 

  411. 			<input type='checkbox' class='checkbox' name='bicarakandengansayaCek' />

    412. 

  412. 			

    413. 

  413. 			<label>Disiapkan</label>

    414. 

  414. 			<input type='checkbox' class='checkbox' name='disiapkanCek' />

    415. 

  415. 			

    416. 

  416. 			<label>Untuk Diketahui</label>

    417. 

  417. 			<input type='checkbox' class='checkbox' name='untukdiketahuiCek' />

    418. 

  418. 			

    419. 

  419. 			<label>Edarkan</label>

    420. 

  420. 			<input type='checkbox' class='checkbox' name='edarkanCek' />

    421. 

  421. 			

    422. 

  422. 			<label>Bicarakan Bersama</label>

    423. 

  423. 			<input type='checkbox' class='checkbox' name='bicarakanbersamaCek' />

    424. 

  424. 			

    425. 

  425. 			<label>Harap Dihadiri/Diwakili</label>

    426. 

  426. 			<input type='checkbox' class='checkbox' name='harapdihadiridiwakiliCek' />

    427. 

  427. 			

    428. 

  428. 			<label>Catatan Disposisi</label>

    429. 

  429. 			<textarea id='disposisi' rows='7' columns='3' name='disposisi' maxlength='300' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tanggal')\"></textarea>

    430. 

  430. 		

    431. 

  431. 			<label>Batas Waktu Tindak Lanjut

    432. 

  432. 			<span class='small'>Isikan batas waktu tindak lanjut dengan surat tanggapan</span>

    433. 

  433. 			</label>

    434. 

  434. 			<input type='text' id='tanggal' name='batasselesai'  minlength='1' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />

    435. 

  435. 			

    436. 

  436. 

    437. 

  437. 			<input type='hidden' name='username' value='$username' />

    438. 

  438. 			<input type='hidden' name='idsurat' value='$idsurat' />

    439. 

  439. 			<input type='submit' value='Rekam' class='button' id='submit' name='rekamdisposisi' />

    440. 

  440. 		

    441. 

  441. 			<div class='spacer'></div>

    442. 

  442. 			</form>

    443. 

  443. 		</div>";			

    444. 

  444. }

    445. 

  445. 

    446. 

  446. // Modul Simpan Disposisi -----------------------------------------------------------------------------------//

    447. 

  447. elseif($_POST['rekamdisposisi']=='Rekam'){

    448. 

  448. 	$idsurat	= $_POST['idsurat'];

    449. 

  449. 	$username	= $_POST['username'];

    450. 

  450. 	$seksium	= $_POST['seksiumCek'];

    451. 

  451. 	if($seksium == "on"){ 

    452. 

  452. 		$seksium = "1";

    453. 

  453. 		}

    454. 

  454. 	else{

    455. 

  455. 		$seksium = "0";

    456. 

  456. 	}

    457. 

  457. 	$seksipd	= $_POST['seksipdCek'];

    458. 

  458. 	if($seksipd == "on"){ 

    459. 

  459. 		$seksipd = "1";

    460. 

  460. 		}

    461. 

  461. 	else{

    462. 

  462. 		$seksipd = "0";

    463. 

  463. 	}

    464. 

  464. 	$seksibp	= $_POST['seksibpCek'];

    465. 

  465. 	if($seksibp == "on"){ 

    466. 

  466. 		$seksibp = "1";

    467. 

  467. 		}

    468. 

  468. 	else{

    469. 

  469. 		$seksibp = "0";

    470. 

  470. 	}

    471. 

  471. 	$seksivr	= $_POST['seksivrCek'];

    472. 

  472. 	if($seksivr == "on"){ 

    473. 

  473. 		$seksivr = "1";

    474. 

  474. 		}

    475. 

  475. 	else{

    476. 

  476. 		$seksivr = "0";

    477. 

  477. 	}

    478. 

  478. 	$sekretariat = $_POST['sekretariatCek'];

    479. 

  479. 	if($sekretariat == "on")

    480. 

  480. 	{

    481. 

  481. 		$sekretariat = "1";

    482. 

  482. 	}

    483. 

  483. 	else

    484. 

  484. 	{

    485. 

  485. 		$sekretariat = "0";

    486. 

  486. 	}

    487. 

  487. 	$sangatsegera 	= $_POST['sangatsegeraCek'];

    488. 

  488. 	if($sangatsegera == "on")

    489. 

  489. 	{

    490. 

  490. 		$sangatsegera = "1";

    491. 

  491. 	}

    492. 

  492. 	else

    493. 

  493. 	{

    494. 

  494. 		$sangatsegera = "0";

    495. 

  495. 	}

    496. 

  496. 	$segera 		= $_POST['segeraCek'];

    497. 

  497. 	if($segera == "on")

    498. 

  498. 	{

    499. 

  499. 		$segera = "1";

    500. 

  500. 	}

    501. 

  501. 	else

    502. 

  502. 	{

    503. 

  503. 		$segera = "0";

    504. 

  504. 	}

    505. 

  505. 	$biasa 			= $_POST['biasaCek'];

    506. 

  506. 	if($biasa == "on")

    507. 

  507. 	{

    508. 

  508. 		$biasa = "1";

    509. 

  509. 	}

    510. 

  510. 	else

    511. 

  511. 	{

    512. 

  512. 		$biasa = "0";

    513. 

  513. 	}

    514. 

  514. 	$setuju 		= $_POST['setujuCek'];

    515. 

  515. 	if($setuju == "on")

    516. 

  516. 	{

    517. 

  517. 		$setuju = "1";

    518. 

  518. 	}

    519. 

  519. 	else

    520. 

  520. 	{

    521. 

  521. 		$setuju = "0";

    522. 

  522. 	}

    523. 

  523. 	$tolak 			= $_POST['tolakCek'];

    524. 

  524. 	if($tolak == "on")

    525. 

  525. 	{

    526. 

  526. 		$tolak = "1";

    527. 

  527. 	}

    528. 

  528. 	else

    529. 

  529. 	{

    530. 

  530. 		$tolak = "0";

    531. 

  531. 	}

    532. 

  532. 	$telitipendapat = $_POST['telitipendapatCek'];

    533. 

  533. 	if($telitipendapat == "on")

    534. 

  534. 	{

    535. 

  535. 		$telitipendapat = "1";

    536. 

  536. 	}

    537. 

  537. 	else 

    538. 

  538. 	{

    539. 

  539. 		$telitipendapat = "0";

    540. 

  540. 	}

    541. 

  541. 	$untukdiketahui	= $_POST['untukdiketahuiCek'];

    542. 

  542. 	if($untukdiketahui == "on")

    543. 

  543. 	{

    544. 

  544. 		$untukdiketahui = "1";

    545. 

  545. 	}

    546. 

  546. 	else

    547. 

  547. 	{

    548. 

  548. 		$untukdiketahui = "0";

    549. 

  549. 	}

    550. 

  550. 	$selesaikan 	= $_POST['selesaikanCek'];

    551. 

  551. 	if($selesaikan == "on")

    552. 

  552. 	{

    553. 

  553. 		$selesaikan = "1";

    554. 

  554. 	}

    555. 

  555. 	else

    556. 

  556. 	{

    557. 

  557. 		$selesaikan = "0";

    558. 

  558. 	}

    559. 

  559. 	$sesuaicatatan 	= $_POST['sesuaicatatanCek'];

    560. 

  560. 	if($sesuaicatatan == "on")

    561. 

  561. 	{

    562. 

  562. 		$sesuaicatatan = "1";

    563. 

  563. 	}

    564. 

  564. 	else

    565. 

  565. 	{

    566. 

  566. 		$sesuaicatatan = "0";

    567. 

  567. 	}

    568. 

  568. 	$untukperhatian	= $_POST['untukperhatianCek'];

    569. 

  569. 	if($untukperhatian == "on")

    570. 

  570. 	{

    571. 

  571. 		$untukperhatian = "1";

    572. 

  572. 	}

    573. 

  573. 	else

    574. 

  574. 	{

    575. 

  575. 		$untukperhatian = "0";

    576. 

  576. 	}

    577. 

  577. 	$edarkan		= $_POST['edarkanCek'];

    578. 

  578. 	if($edarkan == "on")

    579. 

  579. 	{

    580. 

  580. 		$edarkan = "1";

    581. 

  581. 	}

    582. 

  582. 	else

    583. 

  583. 	{

    584. 

  584. 		$edarkan = "0";

    585. 

  585. 	}

    586. 

  586. 	$jawab 			= $_POST['jawabCek'];

    587. 

  587. 	if($jawab == "on")

    588. 

  588. 	{

    589. 

  589. 		$jawab = "1";

    590. 

  590. 	}

    591. 

  591. 	else

    592. 

  592. 	{

    593. 

  593. 		$jawab = "0";

    594. 

  594. 	}

    595. 

  595. 	$perbaiki 		= $_POST['perbaikiCek'];

    596. 

  596. 	if($perbaiki == "on")

    597. 

  597. 	{

    598. 

  598. 		$perbaiki = "1";

    599. 

  599. 	}

    600. 

  600. 	else

    601. 

  601. 	{

    602. 

  602. 		$perbaiki = "0";

    603. 

  603. 	}

    604. 

  604. 	$bicarakandgsaya	= $_POST['bicarakandengansayaCek'];

    605. 

  605. 	if($bicarakandgsaya == "on")

    606. 

  606. 	{

    607. 

  607. 		$bicarakandgsaya = "1";

    608. 

  608. 	}

    609. 

  609. 	else

    610. 

  610. 	{

    611. 

  611. 		$bicarakandgsaya = "0";

    612. 

  612. 	}

    613. 

  613. 	$bicarakanbersama	= $_POST['bicarakanbersamaCek'];

    614. 

  614. 	if($bicarakanbersama == "on")

    615. 

  615. 	{

    616. 

  616. 		$bicarakanbersama = "1";

    617. 

  617. 	}

    618. 

  618. 	else

    619. 

  619. 	{

    620. 

  620. 		$bicarakanbersama = "0";

    621. 

  621. 	}

    622. 

  622. 	$ingatkan			= $_POST['ingatkanCek'];

    623. 

  623. 	if($ingatkan == "on")

    624. 

  624. 	{

    625. 

  625. 		$ingatkan = "1";

    626. 

  626. 	}

    627. 

  627. 	else

    628. 

  628. 	{

    629. 

  629. 		$ingatkan = "0";

    630. 

  630. 	}

    631. 

  631. 	$simpan			= $_POST['simpanCek'];

    632. 

  632. 	if($simpan == "on")

    633. 

  633. 	{

    634. 

  634. 		$simpan = "1";

    635. 

  635. 	}

    636. 

  636. 	else

    637. 

  637. 	{

    638. 

  638. 		$simpan = "0";

    639. 

  639. 	}

    640. 

  640. 	$disiapkan		= $_POST['disiapkanCek'];

    641. 

  641. 	if($disiapkan == "on")

    642. 

  642. 	{

    643. 

  643. 		$disiapkan = "1";

    644. 

  644. 	}

    645. 

  645. 	else

    646. 

  646. 	{

    647. 

  647. 		$disiapkan = "0";

    648. 

  648. 	}

    649. 

  649. 	$harapdihadiridiwakili = $_POST['harapdihadiridiwakiliCek'];

    650. 

  650. 	if($harapdihadiridiwakili == "on")

    651. 

  651. 	{

    652. 

  652. 		$harapdihadiridiwakili = "1";

    653. 

  653. 	}

    654. 

  654. 	else

    655. 

  655. 	{

    656. 

  656. 		$harapdihadiridiwakili = "0";

    657. 

  657. 	}

    658. 

  658. 	

    659. 

  659. 	$disposisi	= $_POST['disposisi'];

    660. 

  660. 	$tanggal	= $_POST['batasselesai'];	

    661. 

  661. 	$batasselesai = $helper->dateConvert($tanggal);

    662. 

  662. 	$timepejabat= date("Y-m-d H:i:s");

    663. 

  663. 	// query updating tables for Disposisi Kepala Kantor/Pejabat statproses=3

    664. 

  664. 	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'");

    665. 

  665. 	// pop up for confirmation

    666. 

  666. 	echo "<script type='text/javascript'>

    667. 

  667. 			$(document).ready(function() {

    668. 

  668. 				$('#promptkonfirmasi').dialog({

    669. 

  669. 					modal: true

    670. 

  670. 				});

    671. 

  671. 			});

    672. 

  672. 		</script>

    673. 

  673. 			<div id='promptkonfirmasi' title='Konfirmasi Perekaman Disposisi'>

    674. 

  674. 			<center><b>Disposisi untuk surat masuk dengan catatan disposisi: <font color='#ffff00'><i>" . $disposisi . "</i></font> berhasil disimpan</b></center>

    675. 

  675. 			<br />

    676. 

  676. 			<br />

    677. 

  677. 			<table border='0' align='center'>

    678. 

  678. 			<form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    679. 

  679. 				<tr><td><input type='submit' name='konfirmasirekam' value='Kembali'  /></td>

    680. 

  680. 			</form>";

    681. 

  681. }

    682. 

  682. 

    683. 

  683. // Modul terima dan proses surat masuk untuk Kepala Seksi =====================================================================//

    684. 

  684. elseif($_GET['module'] == "terimaprosessuratmasuk"){

    685. 

  685. 	$username	= $_SESSION[namauser];

    686. 

  686. 	$Seksi		= substr($_SESSION[seksi],1,2);

    687. 

  687. 	$seksi		= strtolower($Seksi);

    688. 

  688. 	echo "<div id='stylized' class='myform'>

    689. 

  689. 			<form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    690. 

  690. 			<h1>Tabel Terima dan Proses Surat Masuk</h1>

    691. 

  691. 					<p>Form ini digunakan untuk melakukan penerimaan dan pemrosesan surat masuk oleh kepala seksi </p>

    692. 

  692. 			</form>

    693. 

  693. 		</div>

    694. 

  694. 					<br />

    695. 

  695. 					<br />

    696. 

  696. 					<div id='normaltable'>

    697. 

  697. 			

    698. 

  698. 					<table class='normaltable' width='100%'>

    699. 

  699. 					<tr>

    700. 

  700. 					<th width='10%' height='35'>No.</th>

    701. 

  701. 					<th width='15%'>No. Agenda</th>

    702. 

  702. 					<th width='15%'>No. Surat</th>

    703. 

  703. 					<th width='15%'>Tgl. Surat</th>

    704. 

  704. 					<th width='15%'>Asal Surat</th>

    705. 

  705. 					<th width='15%'>Perihal</th>

    706. 

  706. 					<th width='15%' colspan='3'>Tindakan</th>

    707. 

  707. 					</tr>";

    708. 

  708. 			

    709. 

  709. 			$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);

    710. 

  710. 			$no	=1;

    711. 

  711. 			$oddcol			= "#CCFF99";

    712. 

  712. 			$evencol		= "#CCDD88";

    713. 

  713. 			while($rDataSurat	= mysql_fetch_object($qDataSurat)){

    714. 

  714. 				if($no % 2 == 0) {$color = $evencol;}

    715. 

  715. 				else{$color = $oddcol;}

    716. 

  716. 				echo "<tr bgcolor='$color'>

    717. 

  717. 						<td height='45'>$no</td>

    718. 

  718. 						<td>$rDataSurat->noagenda</td>

    719. 

  719. 						<td>$rDataSurat->nomorsuratmasuk</td>

    720. 

  720. 						<td>$rDataSurat->tglsurat</td>

    721. 

  721. 						<td>$rDataSurat->asalsurat</td>

    722. 

  722. 						<td>$rDataSurat->perihal</td>

    723. 

  723. 						<td>

    724. 

  724. 							<form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    725. 

  725. 								<input type='hidden' name='username' value='$username' />

    726. 

  726. 								<input type='hidden' name='idsurat' value='$rDataSurat->idsurat' />

    727. 

  727. 								<input type='submit' class='normaltablesubmit' name='prosessurat' value='Terima' onClick=\"setTimeout('location.reload(true);',1000); return true;\"  />

    728. 

  728. 							</form>

    729. 

  729. 						</td>

    730. 

  730. 					</tr>";

    731. 

  731. 				$no++;

    732. 

  732. 			}

    733. 

  733. 			echo "</table>

    734. 

  734. 					</div>

    735. 

  735. 					</form>";

    736. 

  736. 

    737. 

  737. }

    738. 

  738. // Modul eksekusi penerimaan surat masuk kepala seksi -----------------------------------------------------------------------------------//

    739. 

  739. elseif($_POST['prosessurat']=='Terima'){

    740. 

  740. 	$username	= $_POST['username'];

    741. 

  741. 	$idsurat	= $_POST['idsurat'];

    742. 

  742. 	$timekasi	= date("Y-m-d H:i:s");

    743. 

  743. 	$q			= mysql_query("SELECT batasselesai FROM d_suratmasuk WHERE idsurat='$idsurat'");

    744. 

  744. 	$r			= mysql_fetch_object($q);

    745. 

  745. 	if($r->batasselesai == "0000-00-00"){

    746. 

  746. 		mysql_query("UPDATE d_suratmasuk SET userkasi='$username', timekasi='$timekasi', statproses='4' WHERE idsurat='$idsurat'");

    747. 

  747. 	}else{

    748. 

  748. 		mysql_query("UPDATE d_suratmasuk SET userkasi='$username', timekasi='$timekasi', statproses='5' WHERE idsurat='$idsurat'");	

    749. 

  749. 	}

    750. 

  750. }

    751. 

  751. 

    752. 

  752. // Modul tabel monitoring surat masuk kepala seksi dan kepala kantor ================================================================//

    753. 

  753. elseif($_GET['module'] == "monitoringsuratmasuk"){

    754. 

  754. 	$username	= $_SESSION[namauser];

    755. 

  755. 	$section	= strtolower($_SESSION[seksi]);

    756. 

  756. 	$Seksi		= substr($_SESSION[seksi],1,2);

    757. 

  757. 	$seksi		= strtolower($Seksi);

    758. 

  758. 	switch($section)

    759. 

  759. 	{

    760. 

  760. 		case "aum":

    761. 

  761. 			$section = "um";

    762. 

  762. 			break;

    763. 

  763. 		case "apd":

    764. 

  764. 			$section = "pd";

    765. 

  765. 			break;

    766. 

  766. 		case "avr":

    767. 

  767. 			$section = "vr";

    768. 

  768. 			break;

    769. 

  769. 		case "abp":

    770. 

  770. 			$section = "bp";

    771. 

  771. 			break;

    772. 

  772. 	}

    773. 

  773. 	echo "<div id='stylizedtable' class='mytable'>

    774. 

  774. 			<h1>Form monitoring surat masuk</h1> 

    775. 

  775. 			<p>Tayangan</p>

    776. 

  776. 			<div id='stylizedtablesp2d'>	

    777. 

  777. 			<script type='text/javascript'>

    778. 

  778. 			setTimeout('location.reload();',30000);

    779. 

  779. 			</script>

    780. 

  780. 			<table name='monitoringsuratmasuk' cellpadding='1' cellspacing='1'>

    781. 

  781. 			<tr>	

    782. 

  782. 			<th width='10%'>No.Agenda</th>

    783. 

  783. 			<th width='10%'>No.Surat</th>

    784. 

  784. 			<th width='10%'>Tgl.Surat</th>

    785. 

  785. 			<th width='20%'>Asal Surat</th>

    786. 

  786. 			<th width='30%'>Perihal</th>

    787. 

  787. 			<th width='10%'>Batas Selesai</th>

    788. 

  788. 			<th width='10%'>File</th>

    789. 

  789. 			<tr>

    790. 

  790. 			<tr>

    791. 

  791. 			<td bgcolor='#dbeeb8' colspan='6'></td>	

    792. 

  792. 			</tr>";

    793. 

  793. 	$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";

    794. 

  794. 	$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";

    795. 

  795. 	if($seksi == "k"){

    796. 

  796. 			$querydata = $querykk;

    797. 

  797. 		}else{

    798. 

  798. 			$querydata = $querynotkk;

    799. 

  799. 		}

    800. 

  800. 	$qDataSurat		= mysql_query($querydata)or die(mysql_error);

    801. 

  801. 	while($rData	= mysql_fetch_array($qDataSurat)){

    802. 

  802. 		$noagenda		= $rData['noagenda'];

    803. 

  803. 		$nomorsuratmasuk= $rData['nomorsuratmasuk'];

    804. 

  804. 		$tglsurat		= $rData['tglsurat'];

    805. 

  805. 		$asalsurat		= $rData['asalsurat'];

    806. 

  806. 		$perihal		= $rData['perihal'];

    807. 

  807. 		$file			= $rData['file'];

    808. 

  808. 		$batasselesai	= $rData['batasselesai'];

    809. 

  809. 		$now			= date("d-m-Y");

    810. 

  810. 		echo "

    811. 

  811. 				<tr class='sp2d' height='60'>

    812. 

  812. 				<td>$noagenda</td>

    813. 

  813. 				<td><font color='#FFFFFF'>$nomorsuratmasuk</font></td>

    814. 

  814. 				<td><font color='#FFFFFF'>$tglsurat</font></td>

    815. 

  815. 				<td><font color='#33FFCC'>$asalsurat</font></td>

    816. 

  816. 				<td>$perihal</td>

    817. 

  817. 				<td>";

    818. 

  818. 					switch($batasselesai){

    819. 

  819. 						case 00-00-0000:

    820. 

  820. 						echo "<b>$batasselesai</b>";

    821. 

  821. 						break;

    822. 

  822. 						case $batasselesai > $now:

    823. 

  823. 						echo "<font color='#CEEC96'><b>$batasselesai</b></font>";

    824. 

  824. 						break;

    825. 

  825. 						case $batasselesai = $now:

    826. 

  826. 						echo "<font color='#ffff00'><b>$batasselesai</b></font>";

    827. 

  827. 						break;

    828. 

  828. 						case $batasselesai > $now:

    829. 

  829. 						echo "<font color='#ff0000'><b>$batasselesai</b></font>";

    830. 

  830. 						break;

    831. 

  831. 					}

    832. 

  832. 				echo "</td>

    833. 

  833. 				<td><b><i><a href='suratmasuk/$file' target='_blank'>$file</a></b></i></td>

    834. 

  834. 				</tr>";

    835. 

  835. 	}

    836. 

  836. 	echo"</table>

    837. 

  837. 			</div>

    838. 

  838. 			</div>";	

    839. 

  839. }

    840. 

  840. 

    841. 

  841. 

    842. 

  842. // Modul Form pencarian surat masuk =======================================================================================//

    843. 

  843. elseif($_GET['module']=='searchsuratmasuk'){

    844. 

  844. 	echo "<script type=\"text/javascript\">

    845. 

  845. 			$(document).ready(function() {

    846. 

  846. 					$('#tglawalsurat').datepicker({

    847. 

  847. 						changeMonth: true,

    848. 

  848. 						changeYear: true

    849. 

  849. 					});

    850. 

  850. 			});

    851. 

  851. 			$(document).ready(function() {

    852. 

  852. 					$('#tglakhirsurat').datepicker({

    853. 

  853. 						changeMonth: true,

    854. 

  854. 						changeYear: true

    855. 

  855. 					});

    856. 

  856. 			});

    857. 

  857. 			$(document).ready(function() {

    858. 

  858. 					$('#timeloket').datepicker({

    859. 

  859. 						changeMonth: true,

    860. 

  860. 						changeYear: true

    861. 

  861. 					});

    862. 

  862. 			});

    863. 

  863. 		</script>

    864. 

  864. 			<div id='stylized' class='myform'>

    865. 

  865. 			<form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    866. 

  866. 			<h1>Form multikategori pencarian data surat masuk</h1>

    867. 

  867. 			<p>Form ini digunakan dalam pencarian data surat masuk</p>

    868. 

  868. 			

    869. 

  869. 			<label>Tgl.Terima Surat</label>

    870. 

  870. 			<input type='checkbox' class='checkbox' name='timeloketCek' />

    871. 

  871. 			<input type='text' id='timeloket' name='timeloket' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'nomorsuratmasuk')\" />

    872. 

  872. 						

    873. 

  873. 			<label>Nomor Surat</label>

    874. 

  874. 			<input type='checkbox' class='checkbox' name='nomorsuratmasukCek' />

    875. 

  875. 			<input type='text' id='nomorsuratmasuk' minlength='3' name='nomorsuratmasuk' maxlength='20' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tglsurat')\" />

    876. 

  876. 			

    877. 

  877. 			<br />

    878. 

  878. 			<br />

    879. 

  879. 			<br />

    880. 

  880. 			<br />

    881. 

  881. 			<br />

    882. 

  882. 			<br />

    883. 

  883. 			<p><center><b>Range Tanggal Surat</b></center></p>

    884. 

  884. 			<label>Tgl.Awal Surat</label>

    885. 

  885. 			<input type='checkbox' class='checkbox' name='tglawalsuratCek' />

    886. 

  886. 			<input type='text' id='tglawalsurat' name='tglawalsurat' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'tglakhirsurat')\" />

    887. 

  887. 			

    888. 

  888. 			<label>Tgl.Akhir Surat</label>

    889. 

  889. 			<input type='checkbox' class='checkbox' name='tglakhirsuratCek' />

    890. 

  890. 			<input type='text' id='tglakhirsurat' name='tglakhirsurat' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'asalsurat')\" />

    891. 

  891. 			

    892. 

  892. 			<br />

    893. 

  893. 			<br />

    894. 

  894. 			<br />

    895. 

  895. 			<br />

    896. 

  896. 			<br />

    897. 

  897. 			<br />

    898. 

  898. 			<p></p>

    899. 

  899. 					

    900. 

  900. 			<label>Asal Surat</label>

    901. 

  901. 			<input type='checkbox' class='checkbox' name='asalsuratCek' />

    902. 

  902. 			<input type='text' id='asalsurat' name='asalsurat'  maxlength='75' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'perihal')\" />

    903. 

  903. 					

    904. 

  904. 			<label>Perihal</label>

    905. 

  905. 			<input type='checkbox' class='checkbox' name='perihalCek' />

    906. 

  906. 			<input type='text' id='perihal' name='perihal' maxlength='120' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />

    907. 

  907. 			

    908. 

  908. 			

    909. 

  909. 			<input type='submit' value='Cari' class='button' id='submit' name='cariDokSuratMasuk' />

    910. 

  910. 			<div class='spacer'></div>

    911. 

  911. 			</form>

    912. 

  912. 			</div>";

    913. 

  913. }

    914. 

  914. 

    915. 

  915. // Modul  Search Surat Masuk----------------------------------------------------------------------------------------------------------------------------------------------//

    916. 

  916. elseif($_POST['cariDokSuratMasuk'] == "Cari"){

    917. 

  917. 	$timeloketCek			= $_POST['timeloketCek'];

    918. 

  918. 	$Timeloket				= $_POST['timeloket'];

    919. 

  919. 	$timeloket				= $helper->dateConvert($Timeloket);

    920. 

  920. 	$nomorsuratmasukCek		= $_POST['nomorsuratmasukCek'];

    921. 

  921. 	$tglawalsuratCek		= $_POST['tglawalsuratCek'];

    922. 

  922. 	$tglakhirsuratCek		= $_POST['tglakhirsuratCek'];

    923. 

  923. 	$asalsuratCek			= $_POST['asalsuratCek'];

    924. 

  924. 	$perihalCek				= $_POST['perihalCek'];

    925. 

  925. 	$nomorsuratmasuk		= $_POST['nomorsuratmasuk'];

    926. 

  926. 	$Tglawalsurat			= $_POST['tglawalsurat'];

    927. 

  927. 	$Tglakhirsurat			= $_POST['tglakhirsurat'];

    928. 

  928. 	$tglawalsurat			= $helper->dateConvert($Tglawalsurat);

    929. 

  929. 	$tglakhirsurat			= $helper->dateConvert($Tglakhirsurat);

    930. 

  930. 	$asalsurat				= $_POST['asalsurat'];

    931. 

  931. 	$perihal				= $_POST['perihal'];

    932. 

  932. 	

    933. 

  933. 	$bagianWhere="";

    934. 

  934. 		

    935. 

  935. 	if(isset($timeloketCek)){

    936. 

  936. 		$timeloket;

    937. 

  937. 		if(empty($bagianWhere)){

    938. 

  938. 			$bagianWhere .= "date(timeloket)='$timeloket'";

    939. 

  939. 		}

    940. 

  940. 	}

    941. 

  941. 	if(isset($nomorsuratmasukCek)){

    942. 

  942. 		if(empty($bagianWhere)){

    943. 

  943. 			$bagianWhere .= "nomorsuratmasuk='$nomorsuratmasuk'";

    944. 

  944. 		}

    945. 

  945. 		else{

    946. 

  946. 			$bagianWhere .= " AND nomorsuratmasuk='$nomorsuratmasuk'";

    947. 

  947. 		}

    948. 

  948. 	}

    949. 

  949. 	if(isset($tglawalsuratCek)){

    950. 

  950. 		if(empty($bagianWhere)){

    951. 

  951. 			$bagianWhere .= "tglsurat>='$tglawalsurat'";

    952. 

  952. 		}

    953. 

  953. 		else{

    954. 

  954. 			$bagianWhere .= " AND tglsurat>='$tglawalsurat'";

    955. 

  955. 		}

    956. 

  956. 	}

    957. 

  957. 	if(isset($tglakhirsuratCek)){

    958. 

  958. 		if(empty($bagianWhere)){

    959. 

  959. 			$bagianWhere .= "tglsurat<='$tglakhirsurat'";

    960. 

  960. 		}

    961. 

  961. 		else{

    962. 

  962. 			$bagianWhere .= " AND tglsurat<='$tglakhirsurat'";

    963. 

  963. 		}

    964. 

  964. 	}

    965. 

  965. 	if(isset($asalsuratCek)){

    966. 

  966. 		if(empty($bagianWhere)){

    967. 

  967. 			$bagianWhere .= "asalsurat REGEXP '$asalsurat'";

    968. 

  968. 		}

    969. 

  969. 		else{

    970. 

  970. 			$bagianWhere .= " AND asalsurat REGEXP '$asalsurat'";

    971. 

  971. 		}

    972. 

  972. 	}

    973. 

  973. 	if(isset($perihalCek)){

    974. 

  974. 		if(empty($bagianWhere)){

    975. 

  975. 			$bagianWhere .= "perihal REGEXP '$perihal'";

    976. 

  976. 		}

    977. 

  977. 		else{

    978. 

  978. 			$bagianWhere .= " AND perihal REGEXP '$perihal'";

    979. 

  979. 		}

    980. 

  980. 	}

    981. 

  981. 

    982. 

  982. 	$queryCek	= "SELECT nomorsuratmasuk,tglsurat,asalsurat,perihal FROM d_suratmasuk WHERE ".$bagianWhere;

    983. 

  983. 	$qCek		= mysql_query($queryCek)or die(mysql_error());

    984. 

  984. 	$rCek		= mysql_fetch_row($qCek);

    985. 

  985. 

    986. 

  986. 	if($rCek > 0){

    987. 

  987. 		

    988. 

  988. 		echo "<div id='stylized' class='myform'>

    989. 

  989. 				<form id='form' name='formSearchSuratMasuk' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    990. 

  990. 				<h1>Form hasil pencarian data surat masuk</h1> 

    991. 

  991. 					<p>Hasil pencarian data surat masuk</p>

    992. 

  992. 					</form>

    993. 

  993. 					</div>

    994. 

  994. 					<br />	

    995. 

  995. 					<table class='normaltable' border='0'>

    996. 

  996. 					<tr>

    997. 

  997. 					<th width='6%'>No.</th>

    998. 

  998. 					<th width='10%'>No. Surat</th>

    999. 

  999. 					<th width='10%'>Tgl. Surat</th>

    1000. 

  1000. 					<th width='24%'>Asal Surat</th>

    1001. 

  1001. 					<th width='24%'>Perihal</th>

    1002. 

  1002. 					<th width='15%'>Surat Tanggapan</th>

    1003. 

  1003. 					<th width='10%'>File Surat Masuk</th>

    1004. 

  1004. 					<th width='10%' colspan='2'>Action</th>

    1005. 

  1005. 					</tr>";

    1006. 

  1006. 			

    1007. 

  1007. 			$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;

    1008. 

  1008. 			$qCari		= mysql_query($query)or die(mysql_error());

    1009. 

  1009. 			$no	= 1;

    1010. 

  1010. 			$oddcol		= "#CCFF99";

    1011. 

  1011. 			$evencol		= "#CCDD88";

    1012. 

  1012. 			while($rCari		= mysql_fetch_array($qCari)){

    1013. 

  1013. 				if($no % 2 == 0) {$color = $evencol;}

    1014. 

  1014. 				else{$color = $oddcol;}

    1015. 

  1015. 						$idsurat			= $rCari['idsurat'];

    1016. 

  1016. 						$nomorsuratmasuk	= $rCari['nomorsuratmasuk'];

    1017. 

  1017. 						$tglsurat			= $rCari['tglsurat'];

    1018. 

  1018. 						$asalsurat			= $rCari['asalsurat'];

    1019. 

  1019. 						$perihal			= $rCari['perihal'];

    1020. 

  1020. 						$nomorsuratkeluar	= $rCari['nomorsuratkeluar'];

    1021. 

  1021. 						$file				= $rCari['file'];

    1022. 

  1022. 					

    1023. 

  1023. 						echo"<tr bgcolor='$color'>

    1024. 

  1024. 								<td>$no</td>

    1025. 

  1025. 								<td>$nomorsuratmasuk</td>

    1026. 

  1026. 								<td>$tglsurat</td>

    1027. 

  1027. 								<td>$asalsurat</td>

    1028. 

  1028. 								<td>$perihal</td>

    1029. 

  1029. 								<td>$nomorsuratkeluar</td>

    1030. 

  1030. 								<td><b><i><a href='suratmasuk/$file' target='_blank'>$file</a></b></i></td>

    1031. 

  1031. 								<td><form method='post' action='".$_SERVER['PHP_SELF']."'><input type='hidden' name='idsurat' value='".$idsurat."' /><input type='submit' name='ubahsuratmasuk' value='Ubah' /></form></td>

    1032. 

  1032. 								<td><form method='post' action='".$_SERVER['PHP_SELF']."'><input type='hidden' name='idsurat' value='".$idsurat."' /><input type='submit' name='hapussuratmasuk' value='Hapus' /></form></td>

    1033. 

  1033. 							</tr>";

    1034. 

  1034. 						$no++;

    1035. 

  1035. 						}

    1036. 

  1036. 						echo"</table>";

    1037. 

  1037. 					

    1038. 

  1038. 	}

    1039. 

  1039. 	else{

    1040. 

  1040. 				echo "<script type='text/javascript'>

    1041. 

  1041. 						alert('Data tersebut tidak ditemukan');

    1042. 

  1042. 				</script>";			

    1043. 

  1043. 	}

    1044. 

  1044. }	

    1045. 

  1045. 

    1046. 

  1046. // Modul Ubah Surat Masuk ---------------------------------------------------------------

    1047. 

  1047. elseif($_POST['ubahsuratmasuk'] == 'Ubah')

    1048. 

  1048. {

    1049. 

  1049. 	echo "<script type=\"text/javascript\">

    1050. 

  1050. 			$(document).ready(function() {

    1051. 

  1051. 					$('#tglsurat').datepicker();

    1052. 

  1052. 			});

    1053. 

  1053. 		</script>";

    1054. 

  1054. 	$idsurat = $_POST['idsurat'];

    1055. 

  1055. 	

    1056. 

  1056. 	$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'");

    1057. 

  1057. 	$rUpdate = mysql_fetch_object($qUpdate);

    1058. 

  1058. 	

    1059. 

  1059. 	$idsurat			= $rUpdate->idsurat;

    1060. 

  1060. 	$nomorsuratmasuk 	= $rUpdate->nomorsuratmasuk;

    1061. 

  1061. 	$tglsurat			= $rUpdate->tglsurat;

    1062. 

  1062. 	$asalsurat			= $rUpdate->asalsurat;

    1063. 

  1063. 	$perihal			= $rUpdate->perihal;

    1064. 

  1064. 	$nomorsuratkeluar	= $rUpdate->nomorsuratkeluar;

    1065. 

  1065. 	$kodesuratkeluar	= $rUpdate->kodesuratkeluar;

    1066. 

  1066. 	$file				= $rUpdate->file;

    1067. 

  1067. 

    1068. 

  1068. 	

    1069. 

  1069. 		echo "<div id='stylized' class='myform'>

    1070. 

  1070. 			<form id='form' name='form' method='post' enctype='multipart/form-data' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    1071. 

  1071. 			<h1>Form update data surat masuk</h1>

    1072. 

  1072. 			<p>Form ini digunakan untuk melakukan perubahan data surat masuk</p>

    1073. 

  1073. 				

    1074. 

  1074. 			<label>Nomor Surat Masuk</label>

    1075. 

  1075. 			<input type='text' id='nomorsuratmasuk' minlength='3' name='nomorsuratmasuk' value='$nomorsuratmasuk' maxlength='20' onkeypress='return handleEnter(this, event)' onkeyup=\"moveOnMax(this,'tglsurat')\" />

    1076. 

  1076. 			

    1077. 

  1077. 			<label>Tgl.Surat Masuk</label>

    1078. 

  1078. 			<input type='text' id='tglsurat' name='tglsurat' value='$tglsurat' maxlength='10' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'asalsurat')\" />

    1079. 

  1079. 				

    1080. 

  1080. 			<label>Asal Surat</label>

    1081. 

  1081. 			<input type='text' id='asalsurat' name='asalsurat' value='$asalsurat' maxlength='75' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'perihal')\" />

    1082. 

  1082. 			

    1083. 

  1083. 			<label>Perihal</label>

    1084. 

  1084. 			<input type='text' id='perihal' name='perihal' value='$perihal' maxlength='120' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'file')\" />

    1085. 

  1085. 			

    1086. 

  1086. 			<label>File

    1087. 

  1087. 				<span class='small'>Apabila file yang diupload tidak berubah, biarkan kosong.</span>

    1088. 

  1088. 				<span class='small'>File awal: <b>$file</b></span>

    1089. 

  1089. 			</label>

    1090. 

  1090. 			<input type='file' id='file' name='file' maxlength='45' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" />

    1091. 

  1091. 			

    1092. 

  1092. 			<input type='hidden' value='$idsurat' name='idsurat' />

    1093. 

  1093. 			<input type='submit' value='Simpan' class='button' id='submit' name='simpanUpdateSuratMasuk' />

    1094. 

  1094. 			<div class='spacer'></div>

    1095. 

  1095. 			</form>

    1096. 

  1096. 			</div>";

    1097. 

  1097. }

    1098. 

  1098. // Simpan Hasil Update Surat Masuk--------------------------------------------------------------------

    1099. 

  1099. elseif($_POST['simpanUpdateSuratMasuk'] == 'Simpan')

    1100. 

  1100. {

    1101. 

  1101. 	echo "<script type='text/javascript'>

    1102. 

  1102. 		$(document).ready(function() {

    1103. 

  1103. 			$('#promptkonfirmasi').dialog({

    1104. 

  1104. 				modal: true

    1105. 

  1105. 			});

    1106. 

  1106. 		});

    1107. 

  1107. 	</script>";

    1108. 

  1108. 	

    1109. 

  1109. 	$idsurat			= $_POST['idsurat'];

    1110. 

  1110. 	$nomorsuratmasuk 	= $_POST['nomorsuratmasuk'];

    1111. 

  1111. 	$tglSurat 			= $_POST['tglsurat'];

    1112. 

  1112. 	$tglsurat			= $helper->dateConvert($tglSurat);

    1113. 

  1113. 	$asalsurat			= $_POST['asalsurat'];

    1114. 

  1114. 	$perihal			= $_POST['perihal'];

    1115. 

  1115. 	$file				= $_POST['file'];

    1116. 

  1116. 	

    1117. 

  1117. 	$lokasi_file	=$_FILES['file']['tmp_name'];

    1118. 

  1118. 	$nama_file		=$_FILES['file']['name'];

    1119. 

  1119. 	

    1120. 

  1120. 	

    1121. 

  1121. 	if($file == 0)

    1122. 

  1122. 	{

    1123. 

  1123. 		$qUpdate = mysql_query("UPDATE d_suratmasuk SET nomorsuratmasuk='$nomorsuratmasuk',tglsurat='$tglsurat',asalsurat='$asalsurat',perihal='$perihal' WHERE idsurat=$idsurat");

    1124. 

  1124. 		

    1125. 

  1125. 		echo "<div id='promptkonfirmasi' title='Konfirmasi Update Data Surat Masuk'>

    1126. 

  1126. 		<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>

    1127. 

  1127. 		<br />

    1128. 

  1128. 		<br />

    1129. 

  1129. 		<table border='0' align='center'>

    1130. 

  1130. 		<form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    1131. 

  1131. 			<tr><td><input type='submit' name='konfirmasirekam' value='Kembali'  /></td>

    1132. 

  1132. 		</form>";

    1133. 

  1133. 	}

    1134. 

  1134. 	else

    1135. 

  1135. 	{

    1136. 

  1136. 		$qUpdate = mysql_query("UPDATE d_suratmasuk SET nomorsuratmasuk='$nomorsuratmasuk',tglsurat='$tglsurat',asalsurat='$asalsurat',perihal='$perihal',file='$file' WHERE idsurat=$idsurat");

    1137. 

  1137. 		

    1138. 

  1138. 		$direktori		='suratmasuk/'.basename($nama_file);

    1139. 

  1139. 		move_uploaded_file($lokasi_file,$direktori);

    1140. 

  1140. 		

    1141. 

  1141. 		echo "<div id='promptkonfirmasi' title='Konfirmasi Update Data Surat Masuk'>

    1142. 

  1142. 		<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>

    1143. 

  1143. 		<br />

    1144. 

  1144. 		<br />

    1145. 

  1145. 		<table border='0' align='center'>

    1146. 

  1146. 		<form name='form1' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    1147. 

  1147. 			<tr><td><input type='submit' name='konfirmasirekam' value='Kembali'  /></td>

    1148. 

  1148. 		</form>";

    1149. 

  1149. 	}

    1150. 

  1150. }

    1151. 

  1151. // Modul Hapus Surat Masuk ---------------------------------------------------------------------------

    1152. 

  1152. elseif($_POST['hapussuratmasuk'] == 'Hapus')

    1153. 

  1153. {

    1154. 

  1154. 	$idsurat = $_POST['idsurat'];

    1155. 

  1155. 	

    1156. 

  1156. 	mysql_query("DELETE FROM d_suratmasuk WHERE idsurat='$idsurat'");

    1157. 

  1157. 	header("location: media.php?module=searchsuratmasuk");

    1158. 

  1158. }

    1159. 

  1159. 

    1160. 

  1160. // Modul Pengantar Surat Masuk ======================================================================//

    1161. 

  1161. elseif($_GET['module'] == 'pengantarsuratmasuk'){

    1162. 

  1162. 	echo "<style type='text/css'>

    1163. 

  1163. 			em { font-weight: bold; padding-right: 1em; vertical-align: top; }

    1164. 

  1164. 			</style>

    1165. 

  1165. 			<script>

    1166. 

  1166. 			$(document).ready(function(){

    1167. 

  1167. 				$('#form').validate();

    1168. 

  1168. 			});

    1169. 

  1169. 			

    1170. 

  1170. 			$(document).ready(function(){

    1171. 

  1171. 				$('#form').validate();

    1172. 

  1172. 				$('#tglawal').datepicker();

    1173. 

  1173. 			});

    1174. 

  1174. 			

    1175. 

  1175. 			$(document).ready(function(){

    1176. 

  1176. 				$('#form').validate();

    1177. 

  1177. 				$('#tglakhir').datepicker();

    1178. 

  1178. 			});

    1179. 

  1179. 	

    1180. 

  1180.   			</script>

    1181. 

  1181. 			<div id='stylized' class='myform'>

    1182. 

  1182. 			<form id='form' name='form' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    1183. 

  1183. 			<h1>Form pencetakan rekapitulasi surat masuk</h1>

    1184. 

  1184. 			<p>Form ini digunakan untuk melakukan pencetakan rekapitulasi surat masuk</p>

    1185. 

  1185. 			<h3>Range Tanggal Penerimaan Surat Masuk</h3>

    1186. 

  1186. 			<br />

    1187. 

  1187. 			

    1188. 

  1188. 				<label>Tanggal Awal

    1189. 

  1189. 				<span class='small'>Isikan tgl awal</span>

    1190. 

  1190. 				</label>

    1191. 

  1191. 				<input type='text' id='tglawal' name='tglawal'  class='required' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'statproses')\" />

    1192. 

  1192. 				

    1193. 

  1193. 				<label>Tanggal Akhir

    1194. 

  1194. 				<span class='small'>Isikan tgl akhir</span>

    1195. 

  1195. 				</label>

    1196. 

  1196. 				<input type='text' id='tglakhir' name='tglakhir'  class='required' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'seksi')\" />

    1197. 

  1197. 				

    1198. 

  1198. 				<br />

    1199. 

  1199. 				<br />

    1200. 

  1200. 				<br />

    1201. 

  1201. 				<br />

    1202. 

  1202. 				<br />

    1203. 

  1203. 				<br />

    1204. 

  1204. 			<p></p>

    1205. 

  1205. 			

    1206. 

  1206. 			<label>Seksi

    1207. 

  1207. 					<span class='small'>Seksi</span>

    1208. 

  1208. 					</label>

    1209. 

  1209. 					<select name='seksi' onkeypress='return handleEnter(this,event)' onkeyup=\"moveOnMax(this,'submit')\" >

    1210. 

  1210. 						<option value='' selected='selected'>-- Pilih --</option>

    1211. 

  1211. 						<option value='all'>Semua Seksi</option>

    1212. 

  1212. 						<option value='um'>Sub Bagian Umum</option>

    1213. 

  1213. 						<option value='pd'>Seksi Pencairan Dana</option>

    1214. 

  1214. 						<option value='bp'>Seksi Bank/Giro Pos</option>

    1215. 

  1215. 						<option value='vr'>Seksi Verak</option>

    1216. 

  1216. 					</select>

    1217. 

  1217. 					

    1218. 

  1218. 					<input type='submit' value='Tayang' class='button' id='submit' name='Tayangcetakrekapsuratmasuk'  />

    1219. 

  1219. 					<div class='spacer'></div>

    1220. 

  1220. 			</form>

    1221. 

  1221. 		</div>";

    1222. 

  1222. 	}

    1223. 

  1223. 	

    1224. 

  1224. // Tampilkan tabel pilihan cetak pengantar surat masuk ----------------------------------------------//

    1225. 

  1225. elseif($_POST['Tayangcetakrekapsuratmasuk'] == "Tayang"){

    1226. 

  1226. 	$tglawal 	= $helper->dateConvert($_POST['tglawal']);

    1227. 

  1227. 	$tglakhir	= $helper->dateConvert($_POST['tglakhir']);

    1228. 

  1228. 	$seksi		= $_POST['seksi'];

    1229. 

  1229. 	// query tiap seksi

    1230. 

  1230. 	if($seksi ==  "all"){

    1231. 

  1231. 		$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')";

    1232. 

  1232. 	}elseif($seksi == "um"){

    1233. 

  1233. 		$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'";

    1234. 

  1234. 	}elseif($seksi == "pd"){

    1235. 

  1235. 		$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'";

    1236. 

  1236. 	}elseif($seksi == "bp"){

    1237. 

  1237. 		$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'";

    1238. 

  1238. 	}elseif($seksi == "vr"){

    1239. 

  1239. 		$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'";

    1240. 

  1240. 	}

    1241. 

  1241. 	// query mengecek data

    1242. 

  1242. 	$qcek		= mysql_query("SELECT nomorsuratmasuk FROM d_suratmasuk WHERE DATE(timeloket) BETWEEN '$tglawal' AND '$tglakhir'");

    1243. 

  1243. 	$rcek		= mysql_num_rows($qcek);

    1244. 

  1244. 	if($tglawal > $tglakhir){

    1245. 

  1245. 		echo "<script type='text/javascript'>

    1246. 

  1246. 			alert('Tanggal awal Anda lebih besar daripada tanggal akhir, mohon perbaiki entri tanggal Anda!');

    1247. 

  1247. 			window.location.replace('media.php?module=pengantarsuratmasuk')

    1248. 

  1248. 		</script>";

    1249. 

  1249. 	}elseif($rcek < 1){

    1250. 

  1250. 		echo "<script type='text/javascript'>

    1251. 

  1251. 			alert('Data dimaksud pada range tanggal tidak ada, mohon perbaiki entri tanggal Anda!');

    1252. 

  1252. 			window.location.replace('media.php?module=pengantarsuratmasuk')

    1253. 

  1253. 		</script>";

    1254. 

  1254. 	}else{

    1255. 

  1255. 		

    1256. 

  1256. 		echo "<div id='stylized' class='myform'>

    1257. 

  1257. 	     <form id='form' name='formShowDataSuratMasuk' method='post' action='"; echo(htmlentities($_SERVER['PHP_SELF'])); echo "'>

    1258. 

  1258. 		     <h1>Tabel Pencetakan Rekapitulasi Surat Masuk</h1> 

    1259. 

  1259. 		     <p>Tabel yang menampilkan data surat masuk untuk keperluan pencetakan rekapitulasi surat masuk</p>

    1260. 

  1260. 	     </form>

    1261. 

  1261.      </div>

    1262. 

  1262.      <br />	

    1263. 

  1263. 				     

    1264. 

  1264.     <form name='form1' method='post' action='report/reportcetaksuratmasuk.php'>

    1265. 

  1265.      <table class='normaltable' border='0'>

    1266. 

  1266. 	     <tr>

    1267. 

  1267. 		     <th width='6%' height='40'>No.</th>

    1268. 

  1268. 		     <th width='10%'>No.Agenda</th>

    1269. 

  1269. 		     <th width='15%'>No.Surat</th>

    1270. 

  1270. 		     <th width='15%'>Asal Surat</th>

    1271. 

  1271. 		     <th width='10%'>Tgl.Surat</th>

    1272. 

  1272. 		     <th width='30%'>Perihal</th>

    1273. 

  1273. 		     <th width='5%'>Cek</th>

    1274. 

  1274. 	     </tr>";

    1275. 

  1275. 		

    1276. 

  1276. 		$q		= mysql_query($query);

    1277. 

  1277. 		$no	= 1;

    1278. 

  1278. 	    $oddcol		= "#CCFF99";

    1279. 

  1279. 	    $evencol		= "#CCDD88";

    1280. 

  1280. 		while($r 	= mysql_fetch_object($q)){

    1281. 

  1281. 			if($no % 2 == 0) {$color = $evencol;}

    1282. 

  1282. 			else{$color = $oddcol;}

    1283. 

  1283. 			echo"<tr bgcolor='$color'>

    1284. 

  1284. 		     <td height='80'>$no</td>

    1285. 

  1285. 		     <td>$r->noagenda</td>

    1286. 

  1286. 		     <td>$r->nomorsuratmasuk</td>

    1287. 

  1287. 		     <td>$r->asalsurat</td>

    1288. 

  1288. 		     <td>$r->tglsurat</td>

    1289. 

  1289. 		     <td>$r->perihal</td>

    1290. 

  1290. 		     <td>…
    1291.

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