<?php 
session_start();
ob_start(); 
include "header.php";
//$objIms->Semifinisheditem_alter();
?>



<?php

if(isset($_GET["uid"]))
{
$uid=$_GET["uid"];
$rsr=$objIms->getRows("tbl_purchase_return_mstr","md5(id)='$uid' and session_login_id = '".$_SESSION['login_id']."'");
$purretmas_id=$rsr["id"];
$pur_id=$rsr["purchasemstr_id"];
$return_no=$rsr["return_no"];
$return_date=$objIms->IntToDate($rsr["ret_date"]);

$rs=$objIms->getRows("view_purchase_supplier","id='$pur_id' and session_login_id = '".$_SESSION['login_id']."'");
$order_no=$rs["order_no"];
$purchase_date=$objIms->IntToDate($rs["purchase_date"]);
$supplier_name=$rs["supplier_name"];

$sql_acc="select *  from tbl_account where mas_id=$pur_id and sales_type='Purchase' and session_login_id = '".$_SESSION['login_id']."' order by id asc";
$res_acc=mysql_query($sql_acc);
$rsacc=mysql_fetch_array($res_acc);
$discount=$rsacc["discount"];				

}


	
?>

		 <style>
			select.error { background-color:#ffa8a8; border: 1px dotted red;  }
			input.error{ background-color:#ffa8a8;   }
			textarea.error{ background-color:#ffa8a8; border: 1px dotted red;  }
         </style>
		 
        


<style type="text/css">
<!--
.table_bg{ border:#CCCCCC solid 1px; border-radius:5px; height:auto; width:auto; padding:20px; margin-bottom:10px;}


-->
</style>
<!-- Page wrapper  -->
        <div class="page-wrapper">
           
            <!-- Container fluid  -->
            <div class="container-fluid">
                <!-- Start Page Content -->
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
							
							<h3>Purchase Return Detail <span style="float:right"><button onclick="goBack()" class="btn btn-info btn-sm">Go Back</button><script>
function goBack() {
    window.history.back();
}
</script></span></h3>
	
                                <div class="table-responsive m-t-40">
<form id="form1" name="form1" method="post" action="">
<table width="100%" cellpadding="4">
  <tr>
    <td height="38" nowrap="nowrap" bgcolor="#FFFFFF" ><strong>Return No. </strong></td>
    <td nowrap="nowrap" bgcolor="#FFFFFF" ><strong>:</strong></td>
    <td nowrap="nowrap" bgcolor="#FFFFFF" ><?=$return_no?></td>
    <td height="38" nowrap="nowrap"><strong>Return Date </strong></td>
    <td><strong>:</strong></td>
    <td><?=$return_date?></td>
  </tr>
  <tr>
    <td height="38" nowrap="nowrap" bgcolor="#FFFFFF" ><strong>Order   No</strong></td>
    <td nowrap="nowrap" bgcolor="#FFFFFF" ><strong>:</strong></td>
    <td nowrap="nowrap" bgcolor="#FFFFFF" ><?php echo $order_no;?></td>
    <td width="8%" height="38" nowrap="nowrap"><strong>Supplier Name<span style="color:#F00; font-weight:bold;">*</span> </strong></td>
    <td width="2%"><strong>:</strong></td>
    <td width="31%"><?php echo $supplier_name;?></td>
    </tr>
  <tr>
    <td width="7%" height="34" nowrap="nowrap" bgcolor="#FFFFFF" ><strong>Order Date </strong></td>
    <td width="1%" nowrap="nowrap" bgcolor="#FFFFFF" ><strong>:</strong></td>
    <td width="28%" nowrap="nowrap" bgcolor="#FFFFFF" >
       <?php echo $purchase_date;?></td>
    <td nowrap="nowrap">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    </tr>
</table>


     <div class="panel">
            <div class="panel-heading"><strong>Item List of Purchase </strong></div>
            <p>&nbsp;</p>
            <table width="100%" class="table table-striped">
		
            <?php 
				 $sql_viewtmp="select *  from view_purchasereturn_det where purretmas_id=$purretmas_id and session_login_id = '".$_SESSION['login_id']."'";
				$res_viewtmp=mysql_query($sql_viewtmp);
				if(mysql_num_rows($res_viewtmp)>0)
				{ 
					$i=1;
					$sums=0;
					?>
                     
                     <tr height="32" align="left">
            <th nowrap="nowrap" width="7%">Si No</th>
            <th nowrap="nowrap" width="40%">Item Name</th>
           
            <th nowrap="nowrap" width="20%">Unit Name </th>
            <th nowrap="nowrap" width="20%">Ret Qty</th>
            <th nowrap="nowrap" width="20%">Sell Price(Per) </th>
            <th nowrap="nowrap" width="20%">Pur Price(Per)</th>
            <th nowrap="nowrap">Total</th>
            <th nowrap="nowrap">Discount</th>
            <th width="20%" nowrap="nowrap">CGST(%)</th>
           <!-- <th width="20%" nowrap="nowrap">CGST </th>-->
            <th width="20%" nowrap="nowrap">SGST(%)</th>
            <!--<th width="20%" nowrap="nowrap">SGST</th>-->
            <th width="20%" nowrap="nowrap">IGST(%)</th>
            <!--<th width="20%" nowrap="nowrap">IGST</th>-->
            <th nowrap="nowrap" width="20%">Total Price</th>
            </tr>
            <?php
				while($rows=mysql_fetch_assoc($res_viewtmp))
					{
						
						
						
						
							
							
			?>
           
            <tr height="32">
            <td nowrap="nowrap" width="7%"><?php echo $i;?></td>
           
		    <td nowrap="nowrap" width="40%"><?php echo $rows["item_name"];?></td>
            
            <td nowrap="nowrap" width="20%"><?php echo $rows["unit_name"];?></td>
            <td nowrap="nowrap" width="20%"><?php echo $rows["ret_qty"];?></td>
            <td nowrap="nowrap" width="20%"><?php echo $rows["sell_price"];?></td>
            <td nowrap="nowrap" width="20%"><?php echo $rows["pur_price"];?></td>
            <td nowrap="nowrap"><?php  $totsum=($rows["ret_qty"]*$rows["pur_price"]); echo number_format($totsum,2);?></td>
            <td nowrap="nowrap"><?php  $discount=$totsum*($rows["discount"]/100); echo number_format($discount,2); $totprice=($totsum-$discount);?></td>
            <td width="20%" nowrap="nowrap"><?php echo $rows["cgst"];?></td>
            <!--<td width="20%" nowrap="nowrap"><?php  $cgst=$totprice*($rows["cgst"]/100); echo number_format($cgst,2);?></td>-->
            <td width="20%" nowrap="nowrap"><?php echo $rows["sgst"];?></td>
           <!-- <td width="20%" nowrap="nowrap"><?php  $sgst=$totprice*($rows["sgst"]/100); echo number_format($sgst,2);?></td>-->
            <td width="20%" nowrap="nowrap"><?php echo $rows["igst"];?></td>
           <!-- <td width="20%" nowrap="nowrap"><?php  $igst=$totprice*($rows["igst"]/100); echo number_format($igst,2);?></td>-->
            <td nowrap="nowrap"><?php  $totamt=$totprice+$cgst+$sgst+$igst; echo number_format($totamt,2);?></td>
            </tr>  <?php $sums=$sums+($totamt);$i++;} ?>   
            <tr height="32">
              <td nowrap="nowrap">&nbsp;</td>
              <td colspan="10" nowrap="nowrap"><div align="right"><strong>Sum Total : </strong></div></td>
              <td nowrap="nowrap"><?php echo number_format($sums,2);?></td>
              </tr> 
            <?php }?>
           </table>
		   
		   <?php
		  $sum_total=$sums;
  		 $str="SELECT * FROM tbl_purchase_tax where pur_mstr_id=$pur_id and session_login_id = '".$_SESSION['login_id']."'";
		$query_tax=mysql_query($str);
		 $tot_tax=0;
		 if(mysql_num_rows($query_tax)>0)
		 {?>
		 <table width="100%" class="table table-bordered">
		 <?php
		while($row_tax=mysql_fetch_array($query_tax)){
   ?>

            <tr>
              
              <td width="31%"><?php $whr_tax="id='".$row_tax['tax_id']."'";
								 $tax_name=$objIms->getRows("tbl_tax_mstr",$whr_tax);
								echo $tax_name['tax_name'] ?> </td>
               <td width="41%"><?=$tax_name["tax_percent"]; ?>%</td>
             
              <td width="15%"><?php $tax_sum=($tax_name['tax_percent']*$sum_total)/100; echo number_format($tax_sum,2);?></td>
            </tr>
            <?php  $tot_tax+=$tax_sum;}?>
            
    </table>
          <?php  }
		 
        
		$nettot=@$sum_total+@$tot_tax;?>
       
        
      
        
        <table width="100%" class="table table-bordered">
          <tr>
            <td width="85%"><div align="right"><strong>Grand Total</strong></div></td>
            <td width="15%"><?php  $nettot=@$nettot; echo number_format($nettot,2);?></td>
          </tr>
		  
          <tr>
            <td><div align="right"><strong>Round Off</strong></div></td>
            <td> <?php echo number_format(round($nettot),2);?></td>
          </tr>
        </table>
    </div>
	 <?php 
				$sql_viewd="select *  from tbl_account where session_login_id = '".$_SESSION['login_id']."' and mas_id=$purretmas_id and sales_type='Purchase Return' and cash_type='Cash' and clear=1";
				$res_viewd=mysql_query($sql_viewd);
				if(mysql_num_rows($res_viewd)>0)
				{ 
					$u=1;
					
					?>
                     <table width="100%" class="table table-striped">
                     <tr height="32" align="left">
            <th nowrap="nowrap" width="18%">Si No</th>
            <th nowrap="nowrap" width="66%">Transaction Date </th>
           
            
            <th nowrap="nowrap" width="16%">Given Amount </th>
            </tr>
            <?php
			$dr=0;
				while($rowsd=mysql_fetch_assoc($res_viewd))
					{
						
						
						
						
							
							
			?>
           
            <tr height="32">
            <td nowrap="nowrap" width="18%"><?php echo $u;?></td>
           
		    <td nowrap="nowrap" width="66%"><?php echo $objIms->IntToDate($rowsd["trans_date"]);?></td>
            
           
            <td nowrap="nowrap" width="16%"><?php echo $Dr_Amt=($rowsd["Cr_Amt"]);?></td>
            </tr>  <?php $dr=$dr+($Dr_Amt);$u++;} ?>   
            <tr height="32">
              <td nowrap="nowrap">&nbsp;</td>
              <td nowrap="nowrap"><div align="right"><strong>Total Paid: </strong></div></td>
              <td nowrap="nowrap"><?php echo $dr;?>	</td>
              </tr> 
           </table>
    <?php }?>
		

   
<p></p>
		<br />
        

</form></div>
                        </div>
                    </div>
                </div>
                <!-- End PAge Content -->
            </div>
            <!-- End Container fluid  -->
<?php include 'footer.php' ?>
 <script src="../js/lib/datatables/datatables.min.js"></script>
    <script src="../js/lib/datatables/cdn.datatables.net/buttons/1.2.2/js/dataTables.buttons.min.js"></script>
    <script src="../js/lib/datatables/cdn.datatables.net/buttons/1.2.2/js/buttons.flash.min.js"></script>
    <script src="../js/lib/datatables/cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
    <script src="../js/lib/datatables/cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/pdfmake.min.js"></script>
    <script src="../js/lib/datatables/cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/vfs_fonts.js"></script>
    <script src="../js/lib/datatables/cdn.datatables.net/buttons/1.2.2/js/buttons.html5.min.js"></script>
    <script src="../js/lib/datatables/cdn.datatables.net/buttons/1.2.2/js/buttons.print.min.js"></script>
    <script src="../js/lib/datatables/datatables-init.js"></script>		