<?php include "konek.php"; ?>
<form action="" method="post">
<p style="font-weight:bold; font-family:Verdana, Arial, Helvetica, sans-serif; margin-left:50px">DAFTAR LAPORAN NOTA KENA PPH 2%</p>
<fieldset style="margin-left:50px; padding-left:20px; width:auto">
<table style="font-family:Verdana, Arial, Helvetica, sans-serif;" >
<tr><td>Filter Berdasarkan Nama PT. Gabungan</td><td>:</td>
<td>
<select name="angkutan" >
<option>- Pilih -</option>
                <?php
                $sql = mysql_query("select * from data_pa where jnspjk = 2 order by nama ASC ") or die (mysql_error());
                $cek = mysql_num_rows($sql);
                while($data = mysql_fetch_array($sql))
                    {
                        $id     = $data["id_pa"];
                        $nama   = $data["nama"];
                ?>
<option value="<?php echo $id;?>"><?php echo $nama;?></option>
               <?php }?>
</select>
</td>
<td><input type="submit" value="Laksanakan"></td>
</tr>
</table>
</fieldset>
</form>
<form action="ubah_status_pph.php" method="post">
<fieldset style="margin-left:50px; padding-left:20px; width:auto">
<div  class="tbl-header">
<table border="1px solid #000" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:14px;border-collapse:collapse;">
    <tr align="center" style="font-weight:bold; padding-left:5px; padding-right:5px;background-color:#fc0; ">
        <td>No.</td>
        <td width="89px">Tanggal</td>
        <td width="60px">No DM</td>
        <td width="150px">Nama</td>
        <td width="210px">ID</td>
        <td width="100px">Nilai PPH</td>
        <td width="116px">Status</td>
        <td width="80px">Perlakuan</td>
        <td width="123px">Masa Pajak</td>
        <td width="165px">No Pajak</td>
    </tr>
</table>
</div>
<div  class="tbl-content">
<table border="1px solid #000" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:13px;border-collapse:collapse;">
<?php
    if (isset($_POST['angkutan']))
    {
        $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'];
        $i=1;
        $c = 0;
        $total = 0;
        $totalnya = 0;
        $totalnya2 = 0;
        $jdtotalnya = 0;
        $jdtotalnya2 = 0;

        $result = mysql_query($tabel) or die('Error, daftar angkutan failed. ' . mysql_error());

        if (mysql_num_rows($result) == 0)
            {
                echo '<p></p><p style="font-family:Verdana, Arial, Helvetica, sans-serif"><b>Pencarian tidak ditemukan</b></p>';
            }
        else
            {
                echo '<p></p>'; ?>

        <?php
            while ($row = mysql_fetch_array($result))
                {
                    $tglinput       = $row['tgl_input'];
                            $tgl        = explode('-',$tglinput);
                            $tanggal    = $tgl[2].'-'.$tgl[1].'-'.$tgl[0];
                            $cb = $tgl[1];
                            $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");
                            $cbx = $bln["$cb"];
                    $id_datatruk    = sprintf('%04d',$row["id_gdtot"]);
                    $id_dttruk      = sprintf('%04d',$id_datatruk);
                    $ket8           = "$id_dttruk/NOTA-PAJBSMG/$cbx/$tgl[0]";
                    $c = $c + 1;
                    $idx = $row['id_pa'];
                    $id_detail = $row['id_pem'];
                    $i = $id_detail;
                    $tgl_muat = $row['tglmuat'];
                    $tgl = explode('-',$tgl_muat);
                            $tanggal = $tgl[2].'-'.$tgl[1].'-'.$tgl[0];
                    $pph = number_format($row["nilaipjk"],0,',','.');
                    $pphx = $row["nilaipjk"];
                    $total += $pphx;
                    $totalx = number_format($total,0,',','.');
                    $nodm =  $row["nodm"];
                    $status =  $row["status_setorpjk"];
                    $nopjkx =  $row["nopjk"];
                    $nopjk  = sprintf('%03d',$nopjkx);
                        if($status == "Belum di Setor")
                            {   $pphnya = $row["nilaipjk"];
                                $totalnya += $pphnya;
                                $jdtotalnya = number_format($totalnya,0,',','.'); }

                        else
                            {    $pphnya2 = $row["nilaipjk"];
                                 $totalnya2 += $pphnya2;
                                 $jdtotalnya2 = number_format($totalnya2,0,',','.'); }

   ?>
   <tr>
    <td width="20px"><?php echo $c; ?>.</td>
    <td><?php echo "$tanggal"; ?></td>
    <td align="center" width="60px"><?php echo "$nodm"; ?></td>
    <td width="150px"><?php echo $row['nama']; ?></td>
    <td width="210px"><?php echo $ket8; ?></td>
    <td align="right" style="padding-right:5px" width="100px">Rp <?php echo "$pph"; ?></td>
    <td align="right" style="padding-right:5px" width="110px"><?php echo "$status"; ?></td>
    <td align="right" style="padding-right:5px" width="75px">
    <input name="id_tempnm[<?php $i; ?>]" type="hidden" value="<?php echo $row['id_tx'];?>" />
    <?php
    if($status == "Telah di Setor")
        {?>Beres<input name="" type="checkbox" value="" checked  disabled="disabled" style="background-color:#99FF00"/>
    <?php   }
    else
        {?>
            Setor<input name="status[<?php $i; ?>]" type="checkbox" value="<?php echo "$id_detail";?>" />
        <?php }?>
    </td>
    <td align="right" style="padding-right:5px" width="120px">
    <?php
    if($status == "Telah di Setor")
        {
        $masapjk = $row["masapjk"];
        $masa = explode('-',$masapjk);
        $ms = $masa[0].'-'.$masa[1];
        $cb = $masa[0];
        $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");
        $cbx = $bln["$cb"];
 echo "$masapjk"; ?>
    <?php   }
    else
        {?>
            <select name="bulan[<?php $i; ?>]">
            <option selected="selected" ><?php echo date('m'); ?> </option>
            <?php
                for($bln = 1; $bln <= 12; $bln++) {
                 $bln_leng = strlen($bln);
                 if($bln_leng == 1)
                    $x = "0".$bln;
                  else
                    $x = $bln;
                    echo '<option>'.$x.'</option>';
                }
            ?>
            </select>.
            <select name="tahun[<?php $i; ?>]">
            <?php
                for($thn = date('Y'); $thn < date('Y') + 3; $thn++) {
                    echo '<option>'.$thn.'</option>';
                }
            ?>
            </select>
        <?php }?>
    </td>
    <td align="right" style="padding-right:5px" width="160px">
    <?php
    if($status == "Telah di Setor")
        {?> <?php echo "$nopjk/PAJBSMG/$cbx/$masa[1]"; ?>
    <?php   }
    else
        {
        ?><input name="nopjk[<?php $i; ?>]" type="hidden" value="" />
        <?php }?>

    </td>
   </tr>

  <?php
                }
 ?> </table></div>
<table border="1px solid #000" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:14px;border-collapse:collapse; margin-left:5px">
<tr >
   <td align="right" width="541px"><b>Total Keseluruhan :</b></td>
    <td align="right" style="padding-right:5px; float:"> <b>Rp <?php echo $totalx; ?></b></td>
</tr>
<tr>
   <td align="right" bgcolor='#FF9900'><b>Total PPh yg blm di Setor :</b></td>
    <td align="right" style="padding-right:5px; float:" bgcolor="#FF9900"> <b>Rp <?php echo $jdtotalnya; ?></b></td>
</tr>
<tr>
   <td align="right"><b>Total PPh yg Sdh di Setor :</b></td>
    <td align="right" style="padding-right:5px; float:"> <b>Rp <?php echo $jdtotalnya2; ?></b></td>
</tr>

<?php
 }}
?>
<tr>
    <td colspan="6" align="right" style="padding-right:10px">Simpan Perubahan <b>STATUS</b></td>
    <td align="center"><input name="simpan" type="submit" src="simpan.png" width="100px" value="simpan" title="Simpan perubahan status"/></td>
</tr>
 </table>
 </p>
</fieldset>
</form>
<p style="margin-left:50px">
<fieldset style="margin-left:50px; padding-left:20px; width:auto">
<table style="font-family:Verdana, Arial, Helvetica, sans-serif">
<tr>
<td>Print data Pajak yang mau di setor :</td>
<td style="margin-left:50px">
<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>
<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>
</tr></table>
</fieldset>
</p>