<?php
 $PageSecurity = 2;
include('includes/DefineSuppTransClass.php');
include('includes/DefinePOClass.php');
include('includes/SQL_CommonFunctions.inc');
include('includes/session.inc');
include('includes/function_lib.php');

  $function_filter[]=$_REQUEST['sitecode'];
	$function_filter[]=$_REQUEST['godown'];
	$function_filter[]=date('Y-m-d'); 
	$function_filter[]=date('Y-m-d');  
   
   //***************  stock function ********************//
   
   function openingBalance($function_filter,$item)
							{
								global $db;
								$site=$function_filter[0];
								$store=$function_filter[1];
								$from=$function_filter[2];								
								if($site!='')
								$filter[]="site = '".$site."'";
								if($store!='')
								$filter[]="store = '".$store."'";
								if($from!='--' && $to!='--')
								$filter[]="reveive_date <= '".$from."'";
								if($item!='')
								$filter[]="itemcode = '".$item."'";
								
								$filter=implode(' and ',$filter);
								 $sql1="Select stock, rate from opening_stockitemwise where $filter";
								$result1=DB_query($sql1,$db);
								$myrow1=DB_fetch_array($result1);
								return $myrow1['stock'];
							}
                      
					   
					   

						////1. MRN/////
                     function receivedMRN($function_filter,$item)
						{
							global $db;
							$site=$function_filter[0];
							$store=$function_filter[1];
							$from=$function_filter[2];
							if($site!='')
							$filter[]="addmrn.site = '".$site."'";
							if($store!='')
							$filter[]="addmrn.StoreCode = '".$store."'";
							if($item!='')
							$filter[]="addmrnqty.mst_itemid = '".$item."'";
							
							$filter=implode(' and ',$filter);
							 $sql1="Select SUM(addmrnqty.reciveqty) from addmrn left join addmrnqty 
							       on(addmrn.id=addmrnqty.issue_id) where Cancel_Status='N' and $filter ";
							$result1=DB_query($sql1,$db);
							$myrow1=DB_fetch_array($result1);
							return $myrow1['SUM(addmrnqty.reciveqty)'];
						}
						

							////1. Issue Slip/////
                         function issueSlip($function_filter,$item)
							{
								global $db;
								$site=$function_filter[0];
								$store=$function_filter[1];
								$from=$function_filter[2];
								if($site!='')
								$filter[]="addissue.site = '".$site."'";
								if($store!='')
								$filter[]="addissue.mst_storeid = '".$store."'";
								if($item!='')
								$filter[]="issueqty.mst_itemid = '".$item."'";
								
								
								$filter=implode(' and ',$filter);
							
								 $sql1="Select SUM(issueqty.issueqty) from addissue left join 
								 issueqty on(addissue.id=issueqty.issue_id) where $filter";
								$result1=DB_query($sql1,$db);
								$myrow1=DB_fetch_array($result1);
								
								return $myrow1['SUM(issueqty.issueqty)'];
							}






                                     ////2. Material return/////
						function receivedReturn($function_filter,$item)
						{
							global $db;
							$site=$function_filter[0];
							$store=$function_filter[1];
							$from=$function_filter[2];
							$to=$function_filter[3];
							
							if($site!='')
							$filter[]="material_return.site = '".$site."'";
							if($store!='')
							$filter[]="material_return.store = '".$store."'";
							if($from!='--' && $to!='--')
							$filter[]="material_return.returndate <= '".$from."'";
							if($item!='')
							$filter[]="material_return_details.itemid = '".$item."'";
							
							$filter=implode(' and ',$filter);
							 $sql1="Select SUM(material_return_details.receiveqty) 
							 from material_return left join material_return_details 
							 on(material_return.id=material_return_details.parentId) where $filter";
						 
							
							$result1=DB_query($sql1,$db);
							$myrow1=DB_fetch_array($result1);
							return $myrow1['SUM(material_return_details.receiveqty)'];
						}
						
						
						       ////////////site to site receive//////
						function receivedSiteToSite($function_filter,$item)
						{
							global $db;
							$site=$function_filter[0];
							$store=$function_filter[1];
							$from=$function_filter[2];
							$to=$function_filter[3];
							
							if($site!='')
							$filter[]="transfer_receipt.Received_to = '".$site."'";
							if($store!='')
							$filter[]="transfer_receipt.Received_store = '".$store."'";
							if($from!='--' && $to!='--')
							$filter[]="transfer_receipt.MRNDate <= '".$from."' ";
							if($item!='')
							$filter[]="transfer_receipt_details.itemid = '".$item."'";
							
							$filter=implode(' and ',$filter);
							
							 $sql1="Select SUM(transfer_receipt_details.reciveqty) 
							 from transfer_receipt left join transfer_receipt_details 
							 on(transfer_receipt.id=transfer_receipt_details.transfer_receipt_id) where $filter";
							$result1=DB_query($sql1,$db);
							$myrow1=DB_fetch_array($result1);
							return $myrow1['SUM(transfer_receipt_details.reciveqty)'];
						}
						
						
						////2. Site to site transfer issue/////
						function issueSiteToSite($function_filter,$item)
						{
							global $db;
						 
							$site=$function_filter[0];
							$store=$function_filter[1];
							$from=$function_filter[2];
							$to=$function_filter[3];
							
							if($site!='')
							$filter[]="transfer_issue.sitecode = '".$site."'";
							if($store!='')
							$filter[]="transfer_issue.fromstore = '".$store."'";
							if($from!='--' && $to!='--')
							$filter[]="transfer_issue.issuedate <= '".$from."'";
							if($item!='')
							$filter[]="transfer_issue_details.itemid = '".$item."'";
							
							$filter=implode(' and ',$filter);
								 $sql1="Select SUM(transfer_issue_details.issueqty) 
								  from transfer_issue left join transfer_issue_details 
								  on(transfer_issue.id=transfer_issue_details.transfer_issue_id) where $filter";
							$result1=DB_query($sql1,$db);
							$myrow1=DB_fetch_array($result1);
							$return_array=$myrow1['SUM(transfer_issue_details.issueqty)'];
							//$avg_rate=$myrow1['SUM(transfer_issue_details.rate)'];
							//$return_array[]=$avg_rate;
							return $return_array;
							
						}
						////3. Material return to vendor///
						function issueMatarialReturn($function_filter,$item)
						{
							global $db;
							$site=$function_filter[0];
							$store=$function_filter[1];
							$from=$function_filter[2];
							$to=$function_filter[3];
							
							if($site!='')
							$filter[]="inv_material_return.sitecode = '".$site."'";
							if($store!='')
							$filter[]="inv_material_return.storecode = '".$store."'";
							if($from!='--' && $to!='--')
							$filter[]="inv_material_return.Reqdate <= '".$from."' ";
							if($item!='')
							$filter[]="inv_material_return_details.itemid = '".$item."'";
							
							$filter=implode(' and ',$filter);
							
						  $sql1="Select SUM(inv_material_return_details.ReturnQty) 
						  from inv_material_return left join inv_material_return_details 
						  on(inv_material_return.id=inv_material_return_details.parentId) where $filter";
							$result1=DB_query($sql1,$db);
							$myrow1=DB_fetch_array($result1);
							return $myrow1['SUM(inv_material_return_details.ReturnQty)'];
						}
						
						function Rgpchallan($function_filter,$item)
					  {
					  
					      global $db;
							$site=$function_filter[0];
							$store=$function_filter[1];
							$from=$function_filter[2];
							$to=$function_filter[2];
							
							if($site!='')
							$filter[]="rgp_tab.branch = '".$site."'";
							if($store!='')
							$filter[]="rgp_tab.store = '".$store."'";
							if($from!='--' && $to!='--')
							$filter[]="rgp_tab.date <= '".$from."'";
							if($item!='')
							$filter[]="rgp_tab_details.mst_itemid = '".$item."'";
							
							$filter=implode(' and ',$filter);
							
							  $sql1="Select SUM(rgp_tab_details.qty) 
							  from rgp_tab left join rgp_tab_details 
							  on(rgp_tab.id=rgp_tab_details.parent_id) where $filter";
							$result1=DB_query($sql1,$db);
							$myrow1=DB_fetch_array($result1);
							return $myrow1['SUM(rgp_tab_details.qty)'];
					  
					  
					  		
					  }	
					   function Rgpreturn($function_filter,$item)
					    {
					  
					        global $db;
							$site=$function_filter[0];
							$store=$function_filter[1];
							$from=$function_filter[2];
							$to=$function_filter[2];
							
							if($site!='')
							$filter[]="rgp_return.branch = '".$site."'";
							if($store!='')
							$filter[]="rgp_return.store = '".$store."'";
							if($from!='--' && $to!='--')
							$filter[]="rgp_return.return_date <= '".$from."' ";
							if($item!='')
							$filter[]="rgp_return_details.item_id = '".$item."'";
							
							$filter=implode(' and ',$filter);
							
							  $sql1="Select SUM(rgp_return_details.qty) 
							  from rgp_return left join rgp_return_details 
							  on(rgp_return.id=rgp_return_details.parent_id) where $filter";
							$result1=DB_query($sql1,$db);
							$myrow1=DB_fetch_array($result1);
							return $myrow1['SUM(rgp_return_details.qty)'];
					  
					  
					  		
					  }	
					  
					  function Nrgp($function_filter,$item)
					    {					  
					        global $db;
							$site=$function_filter[0];
							$store=$function_filter[1];
							$from=$function_filter[2];
							$to=$function_filter[2];
							
							if($site!='')
							$filter[]="nrgp_challan.branch = '".$site."'";
							if($store!='')
							$filter[]="nrgp_challan.store = '".$store."'";
							if($from!='--' && $to!='--')
							$filter[]="nrgp_challan.date <= '".$from."' ";
							if($item!='')
							$filter[]="nrgp_challan_details.item_code = '".$item."'";
							
							$filter=implode(' and ',$filter);
							
							  $sql1="Select SUM(nrgp_challan_details.qty) 
							  from nrgp_challan left join nrgp_challan_details 
							  on(nrgp_challan.id=nrgp_challan_details.parant_id) where $filter";
							$result1=DB_query($sql1,$db);
							$myrow1=DB_fetch_array($result1);
							return $myrow1['SUM(nrgp_challan_details.qty)'];
					  
					  
					  		
					  }	
						function FinishedMR($function_filter,$item)
					    {					  
					        global $db;
							$site=$function_filter[0];
							$store=$function_filter[1];
							$from=$function_filter[2];
														
							if($site!='')
							$filter[]="finished_recieved.site = '".$site."'";
							if($store!='')
							$filter[]="finished_recieved.store = '".$store."'";
							if($from!='--' && $to!='--')
							$filter[]="finished_recieved.recieved_date <= '".$from."' ";
							if($item!='')
							$filter[]="finished_recieved_details.mst_itemid = '".$item."'";
							
							$filter=implode(' and ',$filter);
							
							   $sql1="Select SUM(finished_recieved_details.reciveqty) 
							  from finished_recieved left join finished_recieved_details 
							  on(finished_recieved.id=finished_recieved_details.finished_recieved_id) where $filter";
							$result1=DB_query($sql1,$db);
							$myrow1=DB_fetch_array($result1);
							return $myrow1['SUM(finished_recieved_details.reciveqty)'];
					  
					  
					  		
					  }			
					  
					  
					  function disptch($function_filter,$item)
					  {
					   global $db;
							$site=$function_filter[0];
							$store=$function_filter[1];
							$from=$function_filter[2];
														
							if($site!='')
							$filter[]="dispatch.site = '".$site."'";
							if($store!='')
							$filter[]="dispatch.store = '".$store."'";
							if($from!='--' && $to!='--')
							$filter[]="dispatch.dispatchDate <= '".$from."' ";
							if($item!='')
							$filter[]="dispatch_details.item = '".$item."'";
							
							$filter=implode(' and ',$filter);
							
							
							
							
							     $sql1="Select SUM(dispatch_details.dispatchQty)  from 
							  dispatch_details INNER JOIN dispatch 
								ON dispatch.id=dispatch_details.parentId 
								where $filter";
							$result1=DB_query($sql1,$db);
							$myrow1=DB_fetch_array($result1);
							return $myrow1['SUM(dispatch_details.dispatchQty)'];
					  
					  
					  
					  }	
                 
                 //***************************************//
	
	
	
    $id=$_REQUEST['salid'];
   $itemid1=explode("-",$_REQUEST['salid']) ;
    $itemid=$itemid1[1];
   if($itemid!='')
   {
?>			
   
   <table width="100%" border="1" cellpadding="3" cellspacing="0" style="border-collapse:collapse; border:#666666 solid 1px;">
    <tr class="row1">
    <th>Sr.No.</td>
	 <th></th>
    <th>Part Code</th>
    <th>Part Name</th>  
    <th>UOM</th>
	 <th>Stock Qty</th>
     <th>Qty</th>    
  </tr>
  <tbody id="dataTable">
  <?php
  $itemname=$s->getField('item_master','id',$itemid,'item_name');
  $unit=$s->getField('item_master','id',$itemid,'mst_unitid');
  $qty=$s->GetFieldValue("qc_shop_floor","jobid='".$itemid1[0]."' and scrap_item_id='".$itemid."'","rejectqty");
  
                   $op=openingBalance($function_filter,$itemid);
							//echo "openingBalance"."<br>";
							 $in_1=receivedMRN($function_filter,$itemid);
							//echo "receivedMRN"."<br>";
							 $out_1=issueSlip($function_filter,$itemid);
							//echo "issueSlip"."<br>";
							 $out_2=issueSiteToSite($function_filter,$itemid);		
							//echo "issuesitetosite"."<br>";
							 $in_2=receivedSiteToSite($function_filter,$itemid);
							//echo " receivesitetosite"."<br>";
							 $out_3=issueMatarialReturn($function_filter,$itemid);
							//echo "issuematerialreturn"."<br>";
							 $in_3=receivedReturn($function_filter,$itemid);	
							//echo "receivedReturn"."<br>";
							 $out_4=Rgpchallan($function_filter,$itemid);
							//echo "Rgpchallan"."<br>";
							 $out_5=Nrgp($function_filter,$itemid);
							//echo "Nrgp"."<br>";
							//echo $out_6=invoice($function_filter,$itemid);
							//echo "invoice"."<br>";
							 $out_7=disptch($function_filter,$itemid);
							//echo "disptch"."<br>";
							 $in_4=Rgpreturn($function_filter,$itemid);
							//echo "Rgpreturn"."<br>";	 
							 $in_5=FinishedMR($function_filter,$itemid);
							//echo "FinishedMR"."<br>";	
                            $invalue=($op+$in_1+$in_2+$in_3+$in_4+$in_5);

                           $outvalue=($out_1+$out_2+$out_3+$out_4+$out_5+$out_7);
                          $tot=$invalue-$outvalue;
  
  
  
  
  ?>
  <tr  class="row1">
  <td ><input name="delitem[]" type="checkbox"  id="delitem" /></td>
<td ><input  type="hidden"   readonly="" value="<?php echo $itemid; ?> "  id="itemdataid"  
             name="itemdataid[]" /></td>
<td ><input type="text"  tabindex="" id="itemcode" name="itemcode[]" 
            value="<?php echo $s->getField('item_master','id',$itemid,'StockID'); ?>"/></td>
<td ><input type="text" name="desc[]"  id="descriptions" size="25"  value="<?php echo $s->getField('item_master','id',$itemid,'item_name'); ?>" readonly /></td>
 
 <td ><input type="text" name="uom[]" id="uom" value="<?php echo $s->getField('unitsofmeasure','unitid',$unit,'unitname'); ?>" readonly  size="30"/>  </td>
  <td ><input type="text" name="stock[]" id="stock" value="<?php echo $tot; ?>" readonly  size="30"/>  </td>
   <td ><input  type="text" name="reciveqty[]"  id="reciveqty" size="30"   value="<?php echo $qty; ?>"   /></td>
    
          </tr>
   </tbody>
</table>
			
   <?php } ?>		
