SHARE
TWEET

Untitled

oodz May 22nd, 2018 62 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php include "konek.php"; ?>
  2. <form action="" method="post">
  3. <p style="font-weight:bold; font-family:Verdana, Arial, Helvetica, sans-serif; margin-left:50px">DAFTAR LAPORAN NOTA KENA PPH 2%</p>
  4. <fieldset style="margin-left:50px; padding-left:20px; width:auto">
  5. <table style="font-family:Verdana, Arial, Helvetica, sans-serif;" >
  6. <tr><td>Filter Berdasarkan Nama PT. Gabungan</td><td>:</td>
  7. <td>
  8. <select name="angkutan" >
  9. <option>- Pilih -</option>
  10.                 <?php
  11.                 $sql = mysql_query("select * from data_pa where jnspjk = 2 order by nama ASC ") or die (mysql_error());
  12.                 $cek = mysql_num_rows($sql);
  13.                 while($data = mysql_fetch_array($sql))
  14.                     {
  15.                         $id     = $data["id_pa"];
  16.                         $nama   = $data["nama"];
  17.                 ?>
  18. <option value="<?php echo $id;?>"><?php echo $nama;?></option>
  19.                <?php }?>
  20. </select>
  21. </td>
  22. <td><input type="submit" value="Laksanakan"></td>
  23. </tr>
  24. </table>
  25. </fieldset>
  26. </form>
  27. <form action="ubah_status_pph.php" method="post">
  28. <fieldset style="margin-left:50px; padding-left:20px; width:auto">
  29. <div  class="tbl-header">
  30. <table border="1px solid #000" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:14px;border-collapse:collapse;">
  31.     <tr align="center" style="font-weight:bold; padding-left:5px; padding-right:5px;background-color:#fc0; ">
  32.         <td>No.</td>
  33.         <td width="89px">Tanggal</td>
  34.         <td width="60px">No DM</td>
  35.         <td width="150px">Nama</td>
  36.         <td width="210px">ID</td>
  37.         <td width="100px">Nilai PPH</td>
  38.         <td width="116px">Status</td>
  39.         <td width="80px">Perlakuan</td>
  40.         <td width="123px">Masa Pajak</td>
  41.         <td width="165px">No Pajak</td>
  42.     </tr>
  43. </table>
  44. </div>
  45. <div  class="tbl-content">  
  46. <table border="1px solid #000" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:13px;border-collapse:collapse;">
  47. <?php
  48.     if (isset($_POST['angkutan']))
  49.     {
  50.         $tabel  = "select * from pembayaran p inner join gd_total gd on p.id_tx = gd.id_tx WHERE gd.status_byr='Telah di Cek' and p.id_pa = ".$_POST['angkutan'];
  51.         $i=1;
  52.         $c = 0;
  53.         $total = 0;
  54.         $totalnya = 0;
  55.         $totalnya2 = 0;
  56.         $jdtotalnya = 0;
  57.         $jdtotalnya2 = 0;
  58.  
  59.         $result = mysql_query($tabel) or die('Error, daftar angkutan failed. ' . mysql_error());  
  60.        
  61.         if (mysql_num_rows($result) == 0)
  62.             {  
  63.                 echo '<p></p><p style="font-family:Verdana, Arial, Helvetica, sans-serif"><b>Pencarian tidak ditemukan</b></p>';  
  64.             }
  65.         else
  66.             {  
  67.                 echo '<p></p>'; ?>
  68.                    
  69.         <?php
  70.             while ($row = mysql_fetch_array($result))
  71.                 {  
  72.                     $tglinput       = $row['tgl_input'];
  73.                             $tgl        = explode('-',$tglinput);
  74.                             $tanggal    = $tgl[2].'-'.$tgl[1].'-'.$tgl[0];
  75.                             $cb = $tgl[1];
  76.                             $bln = array("01"=>"I","02"=>"II","03"=>"III","04"=>"IV","05"=>"V","06"=>"VI","07"=>"VII","08"=>"VIII","09"=>"IX","10"=>"X","11"=>"XI","12"=>"XII");
  77.                             $cbx = $bln["$cb"];
  78.                     $id_datatruk    = sprintf('%04d',$row["id_gdtot"]);
  79.                     $id_dttruk      = sprintf('%04d',$id_datatruk);
  80.                     $ket8           = "$id_dttruk/NOTA-PAJBSMG/$cbx/$tgl[0]";
  81.                     $c = $c + 1;
  82.                     $idx = $row['id_pa'];
  83.                     $id_detail = $row['id_pem'];
  84.                     $i = $id_detail;
  85.                     $tgl_muat = $row['tglmuat'];
  86.                     $tgl = explode('-',$tgl_muat);
  87.                             $tanggal = $tgl[2].'-'.$tgl[1].'-'.$tgl[0];
  88.                     $pph = number_format($row["nilaipjk"],0,',','.');
  89.                     $pphx = $row["nilaipjk"];
  90.                     $total += $pphx;
  91.                     $totalx = number_format($total,0,',','.');
  92.                     $nodm =  $row["nodm"];
  93.                     $status =  $row["status_setorpjk"];
  94.                     $nopjkx =  $row["nopjk"];
  95.                     $nopjk  = sprintf('%03d',$nopjkx);
  96.                         if($status == "Belum di Setor")
  97.                             {   $pphnya = $row["nilaipjk"];
  98.                                 $totalnya += $pphnya;
  99.                                 $jdtotalnya = number_format($totalnya,0,',','.'); }
  100.                                  
  101.                         else
  102.                             {    $pphnya2 = $row["nilaipjk"];
  103.                                  $totalnya2 += $pphnya2;
  104.                                  $jdtotalnya2 = number_format($totalnya2,0,',','.'); }
  105.  
  106.    ?>
  107.    <tr>
  108.     <td width="20px"><?php echo $c; ?>.</td>
  109.     <td><?php echo "$tanggal"; ?></td>
  110.     <td align="center" width="60px"><?php echo "$nodm"; ?></td>
  111.     <td width="150px"><?php echo $row['nama']; ?></td>
  112.     <td width="210px"><?php echo $ket8; ?></td>
  113.     <td align="right" style="padding-right:5px" width="100px">Rp <?php echo "$pph"; ?></td>
  114.     <td align="right" style="padding-right:5px" width="110px"><?php echo "$status"; ?></td>
  115.     <td align="right" style="padding-right:5px" width="75px">
  116.     <input name="id_tempnm[<?php $i; ?>]" type="hidden" value="<?php echo $row['id_tx'];?>" />
  117.     <?php
  118.     if($status == "Telah di Setor")
  119.         {?>Beres<input name="" type="checkbox" value="" checked  disabled="disabled" style="background-color:#99FF00"/>
  120.     <?php   }
  121.     else
  122.         {?>
  123.             Setor<input name="status[<?php $i; ?>]" type="checkbox" value="<?php echo "$id_detail";?>" />
  124.         <?php }?>
  125.     </td>
  126.     <td align="right" style="padding-right:5px" width="120px">
  127.     <?php
  128.     if($status == "Telah di Setor")
  129.         {      
  130.         $masapjk = $row["masapjk"];
  131.         $masa = explode('-',$masapjk);
  132.         $ms = $masa[0].'-'.$masa[1];
  133.         $cb = $masa[0];
  134.         $bln = array("01"=>"I","02"=>"II","03"=>"III","04"=>"IV","05"=>"V","06"=>"VI","07"=>"VII","08"=>"VIII","09"=>"IX","10"=>"X","11"=>"XI","12"=>"XII");
  135.         $cbx = $bln["$cb"];
  136.  echo "$masapjk"; ?>
  137.     <?php   }
  138.     else
  139.         {?>
  140.             <select name="bulan[<?php $i; ?>]">
  141.             <option selected="selected" ><?php echo date('m'); ?> </option>
  142.             <?php
  143.                 for($bln = 1; $bln <= 12; $bln++) {
  144.                  $bln_leng = strlen($bln);
  145.                  if($bln_leng == 1)
  146.                     $x = "0".$bln;
  147.                   else
  148.                     $x = $bln; 
  149.                     echo '<option>'.$x.'</option>';
  150.                 }
  151.             ?>
  152.             </select>.
  153.             <select name="tahun[<?php $i; ?>]">
  154.             <?php
  155.                 for($thn = date('Y'); $thn < date('Y') + 3; $thn++) {
  156.                     echo '<option>'.$thn.'</option>';
  157.                 }
  158.             ?>
  159.             </select>
  160.         <?php }?>
  161.     </td>
  162.     <td align="right" style="padding-right:5px" width="160px">
  163.     <?php
  164.     if($status == "Telah di Setor")
  165.         {?> <?php echo "$nopjk/PAJBSMG/$cbx/$masa[1]"; ?>
  166.     <?php   }
  167.     else
  168.         {
  169.         ?><input name="nopjk[<?php $i; ?>]" type="hidden" value="" />
  170.         <?php }?>
  171.  
  172.     </td>
  173.    </tr>
  174.  
  175.   <?php
  176.                 }  
  177.  ?> </table></div>
  178. <table border="1px solid #000" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:14px;border-collapse:collapse; margin-left:5px">  
  179. <tr >
  180.    <td align="right" width="541px"><b>Total Keseluruhan :</b></td>
  181.     <td align="right" style="padding-right:5px; float:"> <b>Rp <?php echo $totalx; ?></b></td>
  182. </tr>
  183. <tr>
  184.    <td align="right" bgcolor='#FF9900'><b>Total PPh yg blm di Setor :</b></td>
  185.     <td align="right" style="padding-right:5px; float:" bgcolor="#FF9900"> <b>Rp <?php echo $jdtotalnya; ?></b></td>
  186. </tr>
  187. <tr>
  188.    <td align="right"><b>Total PPh yg Sdh di Setor :</b></td>
  189.     <td align="right" style="padding-right:5px; float:"> <b>Rp <?php echo $jdtotalnya2; ?></b></td>
  190. </tr>
  191.    
  192. <?php
  193.  }}
  194. ?>
  195. <tr>
  196.     <td colspan="6" align="right" style="padding-right:10px">Simpan Perubahan <b>STATUS</b></td>
  197.     <td align="center"><input name="simpan" type="submit" src="simpan.png" width="100px" value="simpan" title="Simpan perubahan status"/></td>
  198. </tr>
  199.  </table>
  200.  </p>
  201. </fieldset>
  202. </form>
  203. <p style="margin-left:50px">
  204. <fieldset style="margin-left:50px; padding-left:20px; width:auto">
  205. <table style="font-family:Verdana, Arial, Helvetica, sans-serif">
  206. <tr>
  207. <td>Print data Pajak yang mau di setor :</td>
  208. <td style="margin-left:50px">
  209. <input type='button' src='print.jpg' width='55' value='print' onclick="window.open('printpph.php?token=<?php echo $idx; ?>','nama_window_pop_up','size=800,height=800,scrollbars=yes,resizeable=no')" title="Print"></td>
  210. <td ><input name="image" type='button' style="margin-left:30px" title="Kembali ke halaman sebelumnya" onclick="history.back(-1)" value='back' src='back.png' width='80' /></td>
  211. </tr></table>
  212. </fieldset>
  213. </p>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top