/bankpos/updating_sispen.php

https://bitbucket.org/metamorph/kppnadministration · PHP · 138 lines · 116 code · 21 blank · 1 comment · 21 complexity · 6a42f2435de54109df738a81078a1d8c MD5 · raw file 

    

  1. <?php
    2. 

  2. include "koneksi.php";
    3. 

  3. 

  4. $jumldata	= $_POST['jumldata'];
    5. 

  5. $Akun			= $_POST['akun'];
    6. 

  6. if($Akun=='4' || $Akun=='7' || $Akun=='8') { 
    7. 

  7. 

  8. 			echo '<table cellpadding="1" cellspacing="1" border="1" align="center" valign="middle" width="80%">
    9. 

  9. 			<tr align="middle" valign="middle">
    10. 

  10. 			<th height="50" width="5%" align="center" valign="middle"  nowrap="nowrap">No.</th>
    11. 

  11. 			<th height="50" width="19%" align="center" valign="middle"  nowrap="nowrap">NTPN</th>
    12. 

  12. 			<th height="50" width="44%" align="center" valign="middle"  nowrap="nowrap">Wajib Pajak</th>	
    13. 

  13. 			<th height="50" width="8%" align="center" valign="middle"  nowrap="nowrap">Akun</th>
    14. 

  14. 			<th height="50" width="6%" align="center" valign="middle"  nowrap="nowrap">Dept</th>
    15. 

  15. 			<th height="50" width="5%" align="center" valign="middle"  nowrap="nowrap">Unit</th>
    16. 

  16. 			<th height="50" width="8%" align="center" valign="middle"  nowrap="nowrap">Satker</th>
    17. 

  17. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">J.K.</th>
    18. 

  18. 			</tr>
    19. 

  19. 			</table>';
    20. 

  20. 			}
    21. 

  21. 			
    22. 

  22. else {
    23. 

  23. 	
    24. 

  24. 	echo '<table cellpadding="1" cellspacing="1" border="1" align="center" valign="middle" width="80%">
    25. 

  25. 			<tr align="middle" valign="middle">
    26. 

  26. 			<th height="50" width="3%" align="center" valign="middle"  nowrap="nowrap">No.</th>
    27. 

  27. 			<th height="50" width="19%" align="center" valign="middle"  nowrap="nowrap">NTPN</th>
    28. 

  28. 			<th height="50" width="44%" align="center" valign="middle"  nowrap="nowrap">Wajib Pajak</th>	
    29. 

  29. 			<th height="50" width="8%" align="center" valign="middle"  nowrap="nowrap">Akun</th>
    30. 

  30. 			<th height="50" width="5%" align="center" valign="middle"  nowrap="nowrap">Fs</th>
    31. 

  31. 			<th height="50" width="5%" align="center" valign="middle"  nowrap="nowrap">sFs</th>
    32. 

  32. 			<th height="50" width="5%" align="center" valign="middle"  nowrap="nowrap">Prog</th>
    33. 

  33. 			<th height="50" width="5%" align="center" valign="middle"  nowrap="nowrap">Keg</th>
    34. 

  34. 			<th height="50" width="5%" align="center" valign="middle"  nowrap="nowrap">sKeg</th>
    35. 

  35. 			<th height="50" width="5%" align="center" valign="middle"  nowrap="nowrap">C.T.</th>
    36. 

  36. 			<th height="50" width="5%" align="center" valign="middle"  nowrap="nowrap">S.D.</th>
    37. 

  37. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">J.K.</th>
    38. 

  38. 			</tr>
    39. 

  39. 			</table>';
    40. 

  40. 			}			
    41. 

  41. 				
    42. 

  42. 

  43. //looping sebanyak jumldata
    44. 

  44. for($i = 1; $i <= $jumldata; $i++) { 
    45. 

  45. 

  46. 	$ntpn			= $_POST['kdntpp'.$i];
    47. 

  47. 	$dekon		= strtoupper($_POST['kddekon'.$i]);
    48. 

  48. 	$ctarik		= $_POST['kdctarik'.$i];
    49. 

  49. 	$sdana		= $_POST['kdsdana'.$i];
    50. 

  50. 	$fungsi		= $_POST['kdfungsi'.$i];
    51. 

  51. 	$sfung		= $_POST['kdsfungsi'.$i];
    52. 

  52. 	$prog			= $_POST['kdprogram'.$i];
    53. 

  53. 	$giat			= $_POST['kdgiat'.$i];
    54. 

  54. 	$sgiat		= $_POST['kdsgiat'.$i];
    55. 

  55. 	$dept			= $_POST['kddept'.$i];
    56. 

  56. 	$unit			= $_POST['kdunit'.$i];
    57. 

  57. 	$satker		= $_POST['kdsatker'.$i];
    58. 

  58. 	
    59. 

  59. 	
    60. 

  60. 	if($Akun=='4' || $Akun=='7' || $Akun=='8'){
    61. 

  61. 		
    62. 

  62. 		if($dekon!='' || $dept!='' || $unit!='' || $satker!=''){
    63. 

  63. 			$update	= mysql_query("UPDATE d_sispen SET kddekon='$dekon',kddept='$dept',kdunit='$unit',kdsatker='$satker' WHERE kdntpp='$ntpn'");
    64. 

  64. 						
    65. 

  65. 			$query	= mysql_query("SELECT DISTINCT kdntpp,nmwajbay,kdnpwp,kddept,kdunit,kdsatker,kdfungsi,kdsfungsi,kdprogram,kdgiat,kdsgiat,kdctarik,kdsdana,kddekon,kdmap FROM d_sispen WHERE kdntpp='$ntpn' AND LEFT(kdmap,1)='$Akun' ORDER BY kdmap");	
    66. 

  66. 			while($r	= mysql_fetch_array($query)) {	
    67. 

  67. 			
    68. 

  68. 			$ntpn		= $r['kdntpp'];
    69. 

  69. 			$wp		= $r['nmwajbay'];
    70. 

  70. 			$akun		= $r['kdmap'];
    71. 

  71. 			$dept		= $r['kddept'];
    72. 

  72. 			$unit		= $r['kdunit'];
    73. 

  73. 			$satker	= $r['kdsatker'];
    74. 

  74. 			$dekon	= $r['kddekon'];
    75. 

  75. 			
    76. 

  76. 			echo "<table cellpadding='1' cellspacing='1' border='1' align='center' valign='middle' width='80%'>
    77. 

  77. 			<tr align='middle' valign='middle'>
    78. 

  78. 			<td width='5%'  align='center' valign='middle'>$i</td>
    79. 

  79. 			<td width='19%' align='center' valign='middle'>$ntpn</td>
    80. 

  80. 			<td width='44%' align='center' valign='middle'>$wp</td>
    81. 

  81. 			<td width='8%'  align='center' valign='middle'>$akun</td>
    82. 

  82. 			<td width='6%'  align='center' valign='middle'><input type='text' name='kddept$i' value='$dept' size='2' maxlength='3' readonly='readonly' /></td>
    83. 

  83. 			<td width='5%'  align='center' valign='middle'><input type='text' name='kdunit$i' value='$unit' size='2' maxlength='2' readonly='readonly' /></td>
    84. 

  84. 			<td width='8%'  align='center' valign='middle'><input type='text' name='kdsatker$i' value='$satker' size='4' maxlength='6' readonly='readonly' /></td>
    85. 

  85. 			<td align='center' valign='middle'><input type='text' name='kddekon$i' value='$dekon' size='2' maxlength='2' readonly='readonly' /></td>";
    86. 

  86. 			}	
    87. 

  87. 

  88. 			echo "</tr>
    89. 

  89. 			</table>";
    90. 

  90. 		}
    91. 

  91. 	}
    92. 

  92. 	
    93. 

  93. 	elseif($Akun=='5' || $Akun=='6') { 
    94. 

  94. 		
    95. 

  95. 			if($fungsi!='' || $sfung!='' || $prog!='' || $giat!='' || $sgiat!='' || $ctarik!='' || $sdana!='' || $dekon!=''){
    96. 

  96. 			$update	= mysql_query("UPDATE d_sispen SET kdfungsi='$fungsi',kdsfungsi='$sfung',kdprogram='$prog',kdgiat='$giat',kdsgiat='$sgiat',kdctarik='$ctarik',kdsdana='$sdana',kddekon='$dekon' WHERE kdntpp='$ntpn'");
    97. 

  97. 						
    98. 

  98. 			$query	= mysql_query("SELECT DISTINCT kdntpp,nmwajbay,kdnpwp,kddept,kdunit,kdsatker,kdfungsi,kdsfungsi,kdprogram,kdgiat,kdsgiat,kdctarik,kdsdana,kddekon,kdmap FROM d_sispen WHERE kdntpp='$ntpn' AND LEFT(kdmap,1)='$Akun' ORDER BY kdmap");	
    99. 

  99. 			while($r	= mysql_fetch_array($query)) {	
    100. 

  100. 			
    101. 

  101. 			$ntpn		= $r['kdntpp'];
    102. 

  102. 			$wp		= $r['nmwajbay'];
    103. 

  103. 			$akun		= $r['kdmap'];
    104. 

  104. 			$fungsi	= $r['kdfungsi'];
    105. 

  105. 			$sfung	= $r['kdsfungsi'];
    106. 

  106. 			$prog		= $r['kdprogram'];
    107. 

  107. 			$giat		= $r['kdgiat'];
    108. 

  108. 			$sgiat	= $r['kdsgiat'];
    109. 

  109. 			$ctarik	= $r['kdctarik'];
    110. 

  110. 			$sdana	= $r['kdsdana'];
    111. 

  111. 			$dekon	= $r['kddekon'];
    112. 

  112. 

  113. 			echo "<table cellpadding='1' cellspacing='1' border='1' align='center' valign='middle' width='80%'>
    114. 

  114. 			<tr align='middle' valign='middle'>
    115. 

  115. 			<td width='5%' align='center' valign='middle' nowrap='nowrap'>$i</td>
    116. 

  116. 			<td width='19%' align='center' valign='middle' nowrap='nowrap'>$ntpn</td>
    117. 

  117. 			<td width='44%' align='center' valign='middle' nowrap='nowrap'>$wp</td>
    118. 

  118. 			<td width='8%' align='center' valign='middle' nowrap='nowrap'>$akun</td>
    119. 

  119. 			<td width='5%' align='center' valign='middle' nowrap='nowrap'><input type='text' name='kdfungsi$i' value='$fungsi' size='2' maxlength='2' readonly='readonly' /></td>
    120. 

  120. 			<td width='5%'  align='center' valign='middle' nowrap='nowrap'><input type='text' name='kdsfung$i' value='$sfung' size='2' maxlength='2' readonly='readonly' /></td>
    121. 

  121. 			<td width='5%'  align='center' valign='middle' nowrap='nowrap'><input type='text' name='kdprogram$i' value='$prog' size='2' maxlength='2' readonly='readonly' /></td>
    122. 

  122. 			<td width='5%'  align='center' valign='middle' nowrap='nowrap'><input type='text' name='kdgiat$i' value='$giat' size='2' maxlength='2' readonly='readonly' /></td>
    123. 

  123. 			<td width='5%'  align='center' valign='middle' nowrap='nowrap'><input type='text' name='kdsgiat$i' value='$sgiat' size='2' maxlength='4' readonly='readonly' /></td>
    124. 

  124. 			<td width='5%'  align='center' valign='middle' nowrap='nowrap'><input type='text' name='kdctarik$i' value='$ctarik' size='2' maxlength='1' readonly='readonly' /></td>
    125. 

  125. 			<td width='5%'  align='center' valign='middle' nowrap='nowrap'><input type='text' name='kdsdana$i' value='$sdana' size='2' maxlength='2' readonly='readonly' /></td>
    126. 

  126. 			<td align='center' valign='middle' nowrap='nowrap'><input type='text' name='kddekon$i' value='$dekon' size='2' maxlength='2' readonly='readonly' /></td>";
    127. 

  127. 			}	
    128. 

  128. 

  129. 			echo "</tr>
    130. 

  130. 			</table>";
    131. 

  131. 		}
    132. 

  132. 	}
    133. 

  133. }
    134. 

  134. mysql_close($link);
    135. 

  135. echo '<br />
    136. 

  136. <center><input type="button" name="button" value="Kembali" onclick="history.go(-2)" /></center>';
    137. 

  137. ?>
    138.