<?php  session_start();

/*
	include_once("config.inc.php");
	include_once("DBConnector1.php");
	$letters = $_GET['letters'];
	
	$sql="SELECT * FROM mast_family where name like '".$letters."%'";
		$result =$db->RunQuery($sql);
			
			
			while($row = mysqli_fetch_array($result))
			{
			
			echo $row["name"];
			
			}
			
		*/	
		
		



	include_once("connectioni.php");


$sql_item = mysqli_query($GLOBALS['dbinv'],"select * from s_mas where BRAND_NAME='CHENG SHING' order by STK_NO") or die(mysqli_error($GLOBALS['dbinv']));				
while($row_item = mysqli_fetch_array($sql_item)){	
 $totqty=0;
  //echo $row_item["STK_NO"]."-";
  	$department=0;
  	$sql_sto = mysqli_query($GLOBALS['dbinv'],"select * from s_stomas order by CODE") or die(mysqli_error($GLOBALS['dbinv']));				
  	while($row_sto = mysqli_fetch_array($sql_sto)){	
		
		 $M_BAL = 0;
		// department wise/////////////////////////////////////
   		$sql = mysqli_query($GLOBALS['dbinv'],"select * from s_trn where  ( SDATE <  '2013-04-02') and STK_NO='".$row_item["STK_NO"]."' and DEPARTMENT='".$row_sto["CODE"]."' ORDER by SDATE") or die(mysqli_error($GLOBALS['dbinv']));
		//echo "select * from s_trn where  ( SDATE <  '2014-04-02') and STK_NO='".$row_item["STK_NO"]."' and DEPARTMENT='".$row_sto["CODE"]."' ORDER by SDATE";
	
	
	
	
		while($row = mysqli_fetch_array($sql)){
   
   	//===stock out
   			if (($row["LEDINDI"] == "INV") or ($row["LEDINDI"] == "ORC") or ($row["LEDINDI"] == "GINI") or ($row["LEDINDI"] == "ARR") or ($row["LEDINDI"] == "IOU")){
      			$M_BAL = $M_BAL - $row["QTY"];
			
   			}
    
	//====stock in
   			if (($row["LEDINDI"] == "ARN") or ($row["LEDINDI"] == "GINR") or ($row["LEDINDI"] == "CRN") or ($row["LEDINDI"] == "GRN") or ($row["LEDINDI"] == "IIN")){
      			$M_BAL = $M_BAL + $row["QTY"];
   			}
   

      		if ($row["LEDINDI"] == "TRN"){
         		$M_BAL = $row["QTY"];
      		}
    	//}
   		}


   		
		
      	$sql = mysqli_query($GLOBALS['dbinv'],"select * from s_trn where (SDATE >= '2013-04-02') and STK_NO='".$row_item["STK_NO"]."' and DEPARTMENT = '".$row_sto["CODE"]."' ORDER BY SDATE") or die(mysqli_error($GLOBALS['dbinv']));
		//echo "select * from s_trn where (SDATE >= '2014-04-02') and STK_NO='".$row_item["STK_NO"]."' and DEPARTMENT = '".$row_sto["CODE"]."' ORDER BY SDATE";
			
	

		$i = 0;
		while($row = mysqli_fetch_array($sql)){



    		$refno=$row["REFNO"];
			$sdate=$row["SDATE"];
			$doc_type="";
			$fcolor="";
	
	
	
			if ($row["LEDINDI"]=="TRN"){
				
				$M_BAL = $row["QTY"];
   			}
	
	
    	//==stock out
			$qty4="";
    		if (($row["LEDINDI"] == "INV") or ($row["LEDINDI"] == "ORC") or ($row["LEDINDI"] == "GINI") or ($row["LEDINDI"] == "ARR") or ($row["LEDINDI"] == "IOU")) {
       			$qty4 = $row["QTY"];
       			$M_BAL = $M_BAL - $row["QTY"];;
    		}
    
    	//===stock in
			$qty3="";
    		if (($row["LEDINDI"] == "ARN") or ($row["LEDINDI"] == "GINR") or ($row["LEDINDI"] == "CRN") or ($row["LEDINDI"] == "GRN") or ($row["LEDINDI"] == "IIN")){
       			$qty3 = $row["QTY"];
       			$M_BAL = $M_BAL + $row["QTY"];
    		}
    		$qty5 = $M_BAL;
						           
   						
    		$i = $i + 1;
		}
		//$department=$department+$M_BAL;
  			
	
	//$department=$M_BAL;
	
	/*
		// All/////////////////////////////////////
   		//$sql = mysqli_query($GLOBALS['dbinv'],"select * from s_trn where  ( SDATE <  '2013-04-02') and STK_NO='".$row_item["STK_NO"]."' and DEPARTMENT='".$row_sto["CODE"]."' ORDER by SDATE") or die(mysqli_error($GLOBALS['dbinv']));
	$sql = mysqli_query($GLOBALS['dbinv'],"select * from s_trn where  ( SDATE <  '2014-04-02') and STK_NO='".$row_item["STK_NO"]."' and LEDINDI!='GINR' and LEDINDI!='GINI' and LEDINDI!='VGI' and LEDINDI!='VGR' ORDER BY SDATE") or die(mysqli_error($GLOBALS['dbinv']));
	
	
	
	$M_BAL = 0;
	while($row = mysqli_fetch_array($sql)){
   
   	//===stock out
   		if (($row["LEDINDI"] == "INV") or ($row["LEDINDI"] == "ORC") or ($row["LEDINDI"] == "GINI") or ($row["LEDINDI"] == "ARR") or ($row["LEDINDI"] == "IOU")){
      		$M_BAL = $M_BAL - $row["QTY"];
			
   		}
    
	//====stock in
   		if (($row["LEDINDI"] == "ARN") or ($row["LEDINDI"] == "GINR") or ($row["LEDINDI"] == "CRN") or ($row["LEDINDI"] == "GRN") or ($row["LEDINDI"] == "IIN")){
      		$M_BAL = $M_BAL + $row["QTY"];
   		}
   

      	if ($row["LEDINDI"] == "TRN"){
         	$M_BAL = $row["QTY"];
      	}
    	//}
   	}


		
	$sql = mysqli_query($GLOBALS['dbinv'],"select *from s_trn where  (SDATE >=  '2014-04-02') and STK_NO='".$row_item["STK_NO"]."'and LEDINDI!='GINR' and LEDINDI!='GINI' and LEDINDI!='VGI' and LEDINDI!='VGR' ORDER BY SDATE") or die(mysqli_error($GLOBALS['dbinv']));	
	




	$i = 0;
	while($row = mysqli_fetch_array($sql)){



    	$refno=$row["REFNO"];
		$sdate=$row["SDATE"];
		$doc_type="";
		$fcolor="";
	
	
		if ($row["LEDINDI"]=="INV"){
			$doc_type="Sales Invoice";
			$fcolor="#330066";
		}

	
		if ($row["LEDINDI"]=="TRN"){
			$doc_type="Inventory";
			$fcolor="#996600";
			$M_BAL = $row["QTY"];
   		}
	
	
    	//==stock out
		$qty4="";
    	if (($row["LEDINDI"] == "INV") or ($row["LEDINDI"] == "ORC") or ($row["LEDINDI"] == "GINI") or ($row["LEDINDI"] == "ARR") or ($row["LEDINDI"] == "IOU")) {
       		$qty4 = $row["QTY"];
       		$M_BAL = $M_BAL - $row["QTY"];;
    	}
    
    	//===stock in
		$qty3="";
    	if (($row["LEDINDI"] == "ARN") or ($row["LEDINDI"] == "GINR") or ($row["LEDINDI"] == "CRN") or ($row["LEDINDI"] == "GRN") or ($row["LEDINDI"] == "IIN")){
       		$qty3 = $row["QTY"];
       		$M_BAL = $M_BAL + $row["QTY"];
    	}
    	$qty5 = $M_BAL;
 
  
    	$i = $i + 1;
	}*/
	
	//if ($department!=$M_BAL){
	//	echo $row_item["STK_NO"]."-".$department."/".$M_BAL."</br>";
	//}
	$sql1 = mysqli_query($GLOBALS['dbinv'],"update s_submas set QTYINHAND=".$M_BAL." where STO_CODE='".$row_sto["CODE"]."' and STK_NO='".$row_item["STK_NO"]."'") or die(mysqli_error($GLOBALS['dbinv']));
	echo "update s_submas set QTYINHAND=".$M_BAL." where STO_CODE='".$row_sto["CODE"]."' and STK_NO='".$row_item["STK_NO"]."'</br>";
	
	$totqty=$totqty+$M_BAL;
  }	
	//echo $row_sto["CODE"]."-".$row_item["STK_NO"]."-".$M_BAL."</br>";

	$sql1 = mysqli_query($GLOBALS['dbinv'],"update s_mas set QTYINHAND=".$totqty." where STK_NO='".$row_item["STK_NO"]."' ") or die(mysqli_error($GLOBALS['dbinv']));
	echo "update s_mas set QTYINHAND=".$totqty." where STK_NO='".$row_item["STK_NO"]."'</br>";
}
	
?>
