<!DOCTYPE HTML>
<?php 
include('config.php');

$ven_autoid = $_POST['ven_autoid'];
$pagename = "Lap Pembelian";

$fdate = dtosql($_POST['fdate']);
$tdate = dtosql($_POST['tdate']);

	$filter_q = "";
    foreach($ven_autoid as $value)
    {
		if($value){
			$txt = " a.ven_autoid = '$value' or";	
			$filter_q = $filter_q.$txt;
		}
		
    }


	if($filter_q){
		$filter_query = " AND ( ".substr_replace($filter_q ,"", -2)." )";
	}
?>
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title><?php echo $pagename?></title>
    <?php include('../../common/script_css.php');?>

</head>
<body class="print_body">
<?php include('../../sys/navprint.php')?>
<div>
    <table class="table" width="1600" border="1" bordercolor="#CCCCCC" style="font-size:12px">
    <thead>
    	<tr class="bold">
        	<td colspan="12">
            Laporan Pembelian
            <br>
            <?php echo iddate($fdate)?> -  <?php echo iddate($tdate)?> 
            </td>
        </tr>
    	<tr class="bold">
        	<td style="width:30px;">No</td>
        	<td style="width:120px;">No PO</td>
        	<td style="width:120px;">Tanggal</td>            
        	<td style="width:220px;">Nama Vendor</td>
            <td style="width:100px;">Kode Produk</td>
            <td style="width:320px;">Nama Produk</td>
            <td class="tr" style="width:100px">Harga</td>
            <td class="tr" style="width:80px">Qty</td>
            <td class="tr" style="width:80px">Disc</td>
            <td class="tr" style="width:120px">Subtotal</td>
	</tr>
	</thead>

<?php
$i = 1;
$gtotal_qty = 0;
$gtotal_amount = 0;

  $sql = " SELECT * FROM poheader a, podetail b, mst_product c
  			WHERE a.po_autoid = b.po_autoid AND b.pm_autoid = c.pm_autoid AND
			(a.po_transdate BETWEEN '$fdate' AND '$tdate') $filter_query ORDER BY a.po_transdate";
  $dcon = $conn->query($sql) or die($sql);
  while($rs = $dcon->fetch_assoc()){
		
	$disc_amt = $rs['pod_price'] - $rs['pod_nett_price'];
	
	$disc_per =  ($disc_amt / $rs['pod_price']) * 100;

?> 
	<tr>
    	<td><?php echo $i?></td>
        <td><?php echo $rs['po_transno']?></td>
        <td><?php echo dtostr($rs['po_transdate'])?></td>
        <td><?php echo $rs['ven_name']?></td>
        <td><?php echo $rs['pm_code']?></td>
        <td><?php echo $rs['pm_name']?></td>
        <td class="tr"><?php echo $rs['pod_price']?></td>
        <td class="tr"><?php echo $rs['pod_qty']?></td>
        <td class="tr">
			<?php if($disc_amt>0){?>
				<?php echo $disc_amt?> ( <?php echo $disc_per?> %)
	        <?php } else { echo 0; }?>
        </td>
        <td class="tr"><?php echo $rs['pod_subtotal']?></td>
	</tr>
<?php 
$i = $i + 1;
$gtotal_qty 	= $gtotal_qty + $rs['pod_qty'];
$gtotal_amount 	= $gtotal_amount + $rs['pod_subtotal'];
} ?>
	<tr class="bold">
    	<td colspan="7" class="tr">Jumlah</td>
        <td class="tr"><?php echo $gtotal_qty?></td>
        <td></td>
        <td class="tr"><?php echo $gtotal_amount?></td>
	</tr>

</div>
</body>

</html>