PageRenderTime 44ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

/bankpos/update_sispen.php

https://bitbucket.org/metamorph/kppnadministration
PHP | 154 lines | 135 code | 17 blank | 2 comment | 16 complexity | a74657a41972dfcaded898f230981811 MD5 | raw file
Possible License(s): GPL-2.0 
    

  1. <?php
    2. 

  2. include "koneksi.php";
    3. 

  3. $tgl		= $_POST[tgl];
    4. 

  4. $bln		= $_POST[bln];
    5. 

  5. $thn		= $_POST[thn];
    6. 

  6. $tanggal	= "$thn-$bln-$tgl";
    7. 

  7. $Tgl		= $_POST[Tgl];
    8. 

  8. $Bln		= $_POST[Bln];
    9. 

  9. $Thn		= $_POST[Thn];
    10. 

  10. $Tanggal	= "$Thn-$Bln-$Tgl";
    11. 

  11. $Akun		= $_POST[akun];
    12. 

  12. 

  13. $q			= mysql_query("SELECT DISTINCT tgbuku,kdntpp,nmwajbay,kdnpwp,kddept,kdunit,kdsatker,kdfungsi,kdsfungsi,kdprogram,kdgiat,kdsgiat,kdctarik,kdsdana,kddekon,kdmap FROM d_sispen WHERE tgbuku BETWEEN '$tanggal' AND '$Tanggal' AND LEFT(kdmap,1)='$Akun' AND (kddept='' OR kdunit='' OR kdsatker='' OR kdfungsi='' OR kdsfungsi='' OR kdprogram='' OR kdgiat='' OR kdsgiat='' OR kdctarik='' OR kddekon='' OR kdsdana='')");
    14. 

  14. $R			= mysql_fetch_array($q);	
    15. 

  15. 

  16. if($R[kddept]='' || $R[kdunit]='' || $R[kdsatker]='' || $R[kdfungsi]='' || $R[kdsfungsi]='' || $R[kdprogram]='' || $R[kdgiat]='' || $R[kdsgiat]='' || $R[kdctarik]='' || $R[kdsdana]='' || $R[kddekon]=''){
    17. 

  17. 	echo "<script language='javascript'>
    18. 

  18. 	window.alert('Data Sispen Telah Terisi Semua');
    19. 

  19. 	history.back(-1);
    20. 

  20. 	</script>";
    21. 

  21. 	}
    22. 

  22. 

  23. elseif($R[kdmap]=='') {	
    24. 

  24. 	echo "<script language='javascript'>
    25. 

  25. 	window.alert('Data Kelompok Akun $Akun Tidak Ada');
    26. 

  26. 	history.back(-1);
    27. 

  27. 	</script>";
    28. 

  28. 	}
    29. 

  29. 	
    30. 

  30. else {
    31. 

  31. 	
    32. 

  32. 		if($Akun=='5' || $Akun=='6'){
    33. 

  33. 			
    34. 

  34. 

  35. 			echo '<form action="updating_sispen.php" method="post">
    36. 

  36. 			<table border="1" align="center" width="85%">
    37. 

  37. 			<tr>
    38. 

  38. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">No.</th>
    39. 

  39. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">NTPN</th>
    40. 

  40. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">Wajib Pajak</th>
    41. 

  41. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">Akun</th>
    42. 

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

  43. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">C.Tarik</th>
    44. 

  44. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">S.D.</th>
    45. 

  45. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">Fs</th>
    46. 

  46. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">sFs</th>
    47. 

  47. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">Prog</th>
    48. 

  48. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">Keg</th>
    49. 

  49. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">sKeg</th>
    50. 

  50. 			</tr>';
    51. 

    52. 

  52. 			$query	= mysql_query("SELECT DISTINCT tgbuku,kdntpp,nmwajbay,kdnpwp,kdfungsi,kdsfungsi,kdprogram,kdgiat,kdsgiat,kdctarik,kdsdana,kddekon,kdmap FROM d_sispen WHERE tgbuku BETWEEN '$tanggal' AND '$Tanggal' AND LEFT(kdmap,1)='$Akun' AND (kdfungsi='' OR kdsfungsi='' OR kdprogram='' OR kdgiat='' OR kdsgiat='' OR kdctarik='' OR kddekon='' OR kdsdana='') ORDER BY kdmap");
    53. 

  53. 			$no		= 1;
    54. 

  54. 			while($r	= mysql_fetch_array($query)) {
    55. 

  55. 				$tgbuku	= $r[tgbuku];
    56. 

  56. 				$ntpn		= $r[kdntpp];
    57. 

  57. 				$wp		= $r[nmwajbay];
    58. 

  58. 				$akun		= $r[kdmap];
    59. 

  59. 				$npwp		= $r[kdnpwp];
    60. 

  60. 				$fungsi	= $r[kdfungsi];
    61. 

  61. 				$sfung	= $r[kdsfungsi];
    62. 

  62. 				$prog		= $r[kdprogram];
    63. 

  63. 				$giat		= $r[kdgiat];
    64. 

  64. 				$sgiat	= $r[kdsgiat];
    65. 

  65. 				$ctarik	= $r[kdctarik];
    66. 

  66. 				$sdana	= $r[kdsdana];
    67. 

  67. 				$dekon	= $r[kddekon];
    68. 

  68. 			
    69. 

  69. 	
    70. 

  70. 			echo "<tr align='middle' valign='middle'>
    71. 

  71. 			<td align='center' valign='middle'>$no</td>
    72. 

  72. 			<td align='center' valign='middle'><input type='text' name='kdntpp$no' value='$ntpn' size='14' readonly='readonly' /></td>
    73. 

  73. 			<td align='center' valign='middle'>$wp</td>
    74. 

  74. 			<td align='center' valign='middle'>$akun</td>
    75. 

  75. 			<td align='center' valign='middle'><input type='text' name='kddekon$no' value='$dekon' size='2' maxlength='2' /></td>
    76. 

  76. 			<td align='center' valign='middle'><input type='text' name='kdctarik$no' value='$ctarik' size='2' maxlength='1' /></td>
    77. 

  77. 			<td align='center' valign='middle'><input type='text' name='kdsdana$no' value='$sdana' size='2' maxlength='2' /></td>
    78. 

  78. 			<td align='center' valign='middle'><input type='text' name='kdfungsi$no' value='$fungsi' size='2' maxlength='2' /></td>
    79. 

  79. 			<td align='center' valign='middle'><input type='text' name='kdsfungsi$no' value='$sfung' size='2' maxlength='2' /></td>
    80. 

  80. 			<td align='center' valign='middle'><input type='text' name='kdprogram$no' value='$prog' size='2' maxlength='2' /></td>
    81. 

  81. 			<td align='center' valign='middle'><input type='text' name='kdgiat$no' value='$giat' size='3' maxlength='4' /></td>
    82. 

  82. 			<td align='center' valign='middle'><input type='text' name='kdsgiat$no' value='$sgiat' size='3' maxlength='2' /></td>";
    83. 

  83. 			$no++;
    84. 

  84. 			}	
    85. 

  85. 

  86. 			//jumlah banyaknya data
    87. 

  87. 			echo "</tr>
    88. 

  88. 			</table>
    89. 

  89. 			<br />
    90. 

  90. 			<input type='hidden' name='jumldata' value='$no-1;' />
    91. 

  91. 			<input type='hidden' name='akun' value='$Akun' />
    92. 

  92. 			<center><input type='submit' name='submit' value='Update' /></center>
    93. 

  93. 			</form>";
    94. 

  94. 		}
    95. 

  95. 		
    96. 

  96. 	elseif($Akun=='4' || $Akun=='7' || $Akun=='8') {
    97. 

  97. 		echo '<form action="updating_sispen.php" method="post">
    98. 

  98. 			<table border="1" align="center" width="85%">
    99. 

  99. 			<tr>
    100. 

  100. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">No.</th>
    101. 

  101. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">NTPN</th>
    102. 

  102. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">Wajib Pajak</th>
    103. 

  103. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">Akun</th>
    104. 

  104. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">Dept</th>
    105. 

  105. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">Unit</th>
    106. 

  106. 			<th height="50" align="center" valign="middle"  nowrap="nowrap">Satker</th>
    107. 

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

  108. 			</tr>';
    109. 

  109. 			
    110. 

  110. 			$queryp	= mysql_query("SELECT DISTINCT tgbuku,kdntpp,nmwajbay,kdnpwp,kddept,kdunit,kdsatker,kdfungsi,kdsfungsi,kdprogram,kdgiat,kdsgiat,kdctarik,kdsdana,kddekon,kdmap FROM d_sispen WHERE tgbuku BETWEEN '$tanggal' AND '$Tanggal' AND LEFT(kdmap,1)='$Akun' AND (kddept='' OR kdunit='' OR kdsatker='' OR kddekon='') ORDER BY kdmap");
    111. 

  111. 			$no		= 1;
    112. 

  112. 			while($h	= mysql_fetch_array($queryp)) {
    113. 

  113. 				$tgbuku	= $h[tgbuku];
    114. 

  114. 				$ntpn		= $h[kdntpp];
    115. 

  115. 				$wp		= $h[nmwajbay];
    116. 

  116. 				$akun		= $h[kdmap];
    117. 

  117. 				$dept		= $h[kddept];
    118. 

  118. 				$unit		= $h[kdunit];
    119. 

  119. 				$satker	= $h[kdsatker];
    120. 

  120. 				$npwp		= $h[kdnpwp];
    121. 

  121. 				$fungsi	= $h[kdfungsi];
    122. 

  122. 				$sfung	= $h[kdsfungsi];
    123. 

  123. 				$prog		= $h[kdprogram];
    124. 

  124. 				$giat		= $h[kdgiat];
    125. 

  125. 				$ctarik	= $h[kdctarik];
    126. 

  126. 				$sdana	= $h[kdsdana];
    127. 

  127. 				$dekon	= $h[kddekon];
    128. 

  128. 			
    129. 

  129. 			
    130. 

  130. 			echo "<tr align='middle' valign='middle'>
    131. 

  131. 			<td align='center' valign='middle'>$no</td>
    132. 

  132. 			<td align='center' valign='middle'><input type='text' name='kdntpp$no' value='$ntpn' size='14' readonly='readonly' /></td>
    133. 

  133. 			<td align='center' valign='middle'>$wp</td>
    134. 

  134. 			<td align='center' valign='middle'>$akun</td>
    135. 

  135. 			<td align='center' valign='middle'><input type='text' name='kddept$no' value='$dept' size='2' maxlength='3' /></td>
    136. 

  136. 			<td align='center' valign='middle'><input type='text' name='kdunit$no' value='$unit' size='2' maxlength='2' /></td>
    137. 

  137. 			<td align='center' valign='middle'><input type='text' name='kdsatker$no' value='$satker' size='4' maxlength='6' /></td>
    138. 

  138. 			<td align='center' valign='middle'><input type='text' name='kddekon$no' value='$dekon' size='2' maxlength='2' /></td>";
    139. 

  139. 			$no++;
    140. 

  140. 			}	
    141. 

  141. 

  142. 			//jumlah banyaknya data
    143. 

  143. 			echo "</tr>
    144. 

  144. 			</table>
    145. 

  145. 			<br />
    146. 

  146. 			<input type='hidden' name='jumldata' value='$no-1;' />
    147. 

  147. 			<input type='hidden' name='akun' value='$Akun' />
    148. 

  148. 			<center><input type='submit' name='submit' value='Update' /></center>
    149. 

  149. 			</form>";
    150. 

  150. 		}
    151. 

  151. 	
    152. 

  152. }	
    153. 

  153. mysql_close($link);		
    154. 

  154. ?>
    155. 

  155.