<?php 
ini_set('session.gc_maxlifetime', 30 * 60 * 60 * 60);
session_start();
date_default_timezone_set('Asia/Colombo'); 
require_once ("connectioni.php");

$sql_item = mysqli_query($GLOBALS['dbinv'],"select * from s_mas where brand_name = '". $_GET["brand"] . "' order by STK_NO") or die(mysqli_error());				
while($row_item = mysqli_fetch_array($sql_item)){	
 $totqty=0;
	
		$M_BAL = 0;

      	$sql = mysqli_query($GLOBALS['dbinv'],"select * from s_trn_stores where (SDATE >= '2017-04-04') and STK_NO='".$row_item["STK_NO"]."' ORDER BY SDATE,id") or die(mysqli_error());


		$i = 0;
		while($row = mysqli_fetch_array($sql)){
			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;
		}
	 	$totqty=$totqty+$M_BAL;
  	
	
	$sql1 = mysqli_query($GLOBALS['dbinv'],"update s_mas set QTYINHAND_STORES=".$totqty." where STK_NO='".$row_item["STK_NO"]."' ") or die(mysqli_error());
	//$sql1 = mysqli_query($GLOBALS['dbinv'],"update s_submas_stores set QTYINHAND=".$totqty." where STK_NO='".$row_item["STK_NO"]."' and sto_code = '1' ") or die(mysqli_error());
	
}
	 
 

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
		<title>Stock Report</title>

		<style>
			table {
				border-collapse: collapse;
			}
			table, th {
				border: 1px solid black;
				font-family: Arial, Helvetica, sans-serif;
				padding: 5px;
			}
			th {
				font-weight: bold;
				font-size: 12x;
			}
			td {
				font-size: 12px;
				border-bottom: dashed;
				border-width: thin;
				font-family: Arial, Helvetica, sans-serif;
				padding: 5px;
			}
		</style>

	</head>

	<body>
		<?php

		

		$sql = "delete from tmpstk";
		$result = mysqli_query($GLOBALS['dbinv'], $sql);

		$sql_head = "select * from invpara";
		$result_head = mysqli_query($GLOBALS['dbinv'], $sql_head);
		$row_head = mysqli_fetch_array($result_head);

		echo "<center><span class=\"style1\"><b>" . $row_head["COMPANY"] . "</b></center><br>";

		function cost() {
			require_once ("connectioni.php");

			if ($_GET["department"] == "All") {
				if ($_GET["brand"] != "All") {$sql = "select * from s_mas where BRAND_NAME='" . $_GET["brand"] . "' and QTYINHAND_STORES!=0  ";
				}
				if ($_GET["brand"] == "All") {$sql = "select * from s_mas where QTYINHAND_STORES!=0  ";
				}
			}

			if ($_GET["department"] != "All") {
				if ($_GET["brand"] != "All") { $sql = "select * from viewsubmas where BRAND_NAME='" . $_GET["brand"] . "' and QTYINHAND_STORES!=0  ";
				}
				if ($_GET["brand"] == "All") { $sql = "select * from viewsubmas where QTYINHAND_STORES!=0 ";
				}
			}

			if ($_GET['chkmin'] == on) {
				$sql = $sql . " and QTYINHAND_STORES <0 ";
			}

			$sql = $sql . " ORDER BY BRAND_NAME, DESCRIPT, GROUP1, GROUP2, model ";
			
			

			echo "<center><b>Stock Report On " . date("Y-m-d") . " Brand - " . $_GET["brand"] . " Department - " . $_GET["department"] . "</b><br>";

			echo "<center><table border=1><tr>
		<th>Item</th><th>Description</th><th>Part No</th><th>Qty in hand </th><th>Cost</th><th>Total Cost</th></tr>";

			$totstk = 0;
			$cost = 0;
			//echo $sql;
			$result = mysqli_query($GLOBALS['dbinv'], $sql);
			while ($rows = mysqli_fetch_array($result)) {
				if ($brand != $rows["BRAND_NAME"]) {
					echo "
			<th colspan=6 align=left><b>" . $rows["BRAND_NAME"] . "</b></th></tr>";
					$brand = $rows["BRAND_NAME"];
				}

				if ($_SESSION['dev'] == '1') {
					echo "<tr><td>" . $rows["STK_NO"] . "</td><td>" . $rows["DESCRIPT"] . "</td><td>" . $rows["PART_NO"] . "</td><td align=\"right\">" . number_format($rows["QTYINHAND_STORES"], 0, ".", ",") . "</td><td align=\"right\">" . number_format($rows["COST"], 2, ".", ",") . "</td><td align=\"right\">" . number_format(($rows["QTYINHAND_STORES"] * $rows["COST"]), 2, ".", ",") . "</td></tr>";
					$totstk = $totstk + $rows["QTYINHAND_STORES"];
					$cost = $cost + ($rows["QTYINHAND_STORES"] * $rows["COST"]);

				} else if ($_SESSION['dev'] == '0') {

					echo "<tr><td>" . $rows["STK_NO"] . "</td><td>" . $rows["DESCRIPT"] . "</td><td>" . $rows["PART_NO"] . "</td><td align=\"right\">" . number_format($rows["QTYINHAND_STORES"], 0, ".", ",") . "</td><td align=\"right\">" . number_format($rows["acc_cost"], 2, ".", ",") . "</td><td align=\"right\">" . number_format(($rows["QTYINHAND_STORES"] * $rows["acc_cost"]), 2, ".", ",") . "</td></tr>";
					$totstk = $totstk + $rows["QTYINHAND_STORES"];
					$cost = $cost + ($rows["QTYINHAND_STORES"] * $rows["acc_cost"]);
				}
			}

			echo "<tr><td colspan=3>" . $rows["STK_NO"] . "</td><td align=\"right\"><b>" . number_format($totstk, 0, ".", ",") . "</b></td><td align=\"right\">&nbsp;</td><td align=\"right\"><b>" . number_format($cost, 2, ".", ",") . "</b></td></tr>";
			echo "</table>";
		}

		function selling() {
			require_once ("connectioni.php");

			if ($_GET["brand"] != "All") { $sql = "select * from s_mas where BRAND_NAME='" . $_GET["brand"] . "' and QTYINHAND_STORES!=0  ORDER BY DESCRIPT, GROUP1, model, GROUP2 ";
			}
			if ($_GET["brand"] == "All") { $sql = "select * from s_mas where QTYINHAND_STORES!=0  ORDER BY BRAND_NAME, DESCRIPT, GROUP1, model, GROUP2 ";
			}

			echo "<center><table border=1><tr>
		<th>Item</th><th>Description</th><th>Part No</th><th>Qty in hand </th><th>Selling</th><th>Total</th></tr>";
			$QTYINHAND_STORES = 0;
			$tot = 0;

			$result = mysqli_query($GLOBALS['dbinv'], $sql);
			while ($rows = mysqli_fetch_array($result)) {
				if ($brand != $rows["BRAND_NAME"]) {
					echo "
			<th colspan=7 align=left><b>" . $rows["BRAND_NAME"] . "</b></th></tr>";
					$brand = $rows["BRAND_NAME"];
				}

				echo "<tr><td>" . $rows["STK_NO"] . "</td><td>" . $rows["DESCRIPT"] . "</td><td>" . $rows["PART_NO"] . "</td><td align=\"right\">" . number_format($rows["QTYINHAND_STORES"], 0, ".", ",") . "</td><td align=\"right\">" . number_format($rows["SELLING"], 2, ".", ",") . "</td><td align=\"right\">" . number_format($rows["QTYINHAND_STORES"] * $rows["SELLING"], 2, ".", ",") . "</td></tr>";
				$QTYINHAND_STORES = $QTYINHAND_STORES + $rows["QTYINHAND_STORES"];
				$tot = $tot + ($rows["SELLING"] * $rows["QTYINHAND_STORES"]);
			}

			echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td align=\"right\"><b>" . number_format($QTYINHAND_STORES, 0, ".", ",") . "</b></td><td align=\"right\">&nbsp;</td><td align=\"right\"><b>" . number_format($tot, 2, ".", ",") . "</b></td></tr>";
			echo "</table>";

		}

		function print_rep() {
			require_once ("connectioni.php");

			if ($_GET["brand"] != "All") { $sql = "select * from s_mas where BRAND_NAME='" . $_GET["brand"] . "' and QTYINHAND_STORES!=0 ORDER BY  DESCRIPT, GROUP1, model, GROUP2 ";
			}
			if ($_GET["brand"] == "All") { $sql = "select * from s_mas where QTYINHAND_STORES!=0 ORDER BY BRAND_NAME, DESCRIPT, GROUP1, model, GROUP2 ";
			}

			echo "<center><table border=1><tr>
		<th>Item</th><th>Description</th><th>Part No</th><th>Qty in hand </th><th>Surplus</th><th>Selling</th></tr>";

			$QTYINHAND_STORES = 0;
			$result = mysqli_query($GLOBALS['dbinv'], $sql);
			while ($rows = mysqli_fetch_array($result)) {

				if ($_GET['cmb_t']=="All") {
				$sql = "select * from brand_mas where barnd_name ='" . $rows["BRAND_NAME"] . "'";
				} else {
				$sql = "select * from brand_mas where barnd_name ='" . $rows["BRAND_NAME"] . "' and costcenter='" . $_GET['cmb_t'] . "'";	
				}
				$resultbc = mysqli_query($GLOBALS['dbinv'], $sql);
				if ($rowsbc = mysqli_fetch_array($resultbc)) {
					if ($brand != $rows["BRAND_NAME"]) {
						echo "
			<th colspan=7 align=left><b>" . $rows["BRAND_NAME"] . "</b></th></tr>";
						$brand = $rows["BRAND_NAME"];
					}

					echo "<tr><td>" . $rows["STK_NO"] . "</td>
		<td>" . $rows["DESCRIPT"] . "</td>
		<td>" . $rows["PART_NO"] . "</td>
		<td align=\"right\">" . number_format($rows["QTYINHAND_STORES"], 0, ".", ",") . "</td>";

					$date = date("Y-m-d");
					$date = strtotime(date("Y-m-d", strtotime($date)) . " -91 days");
					$dt = date("Y-m-d", $date);

					$sql_rs = "select sum(REC_QTY) as stk from s_purtrn where STK_NO='" . $rows["STK_NO"] . "' and CANCEL='0' and SDATE > '" . $dt . "' ";
					
					$result_rs = mysqli_query($GLOBALS['dbinv'], $sql_rs);
					$row_rs = mysqli_fetch_array($result_rs);
					$mnewstk = 0;
					$munsold = 0;

					if (!is_null($row_rs["stk"])) {
						$mnewstk = $row_rs["stk"];
					}
					
					if ($rows["QTYINHAND_STORES"] > $mnewstk) {
						$munsold = $rows["QTYINHAND_STORES"] - $mnewstk;
					}
					
		echo "<td align=\"right\">" . number_format($munsold, 0, ".", ",") . "</td>";			
		echo "<td align=\"right\">" . number_format($rows["SELLING"], 0, ".", ",") . "</td>";
					echo "</tr>";
					$QTYINHAND_STORES = $QTYINHAND_STORES + $rows["QTYINHAND_STORES"];
				}
			}
			echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td align=\"right\"><b>" . number_format($QTYINHAND_STORES, 0, ".", ",") . "</b></td></tr>";

			echo "</table>";
		}

		function printit_print() {
			require_once ("connectioni.php");

			echo "<center>Stock Report On " . date("Y-m-d") . " &nbsp;&nbsp;&nbsp;&nbsp;Brand :" . $_GET["brand"] . "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Department : " . $_GET["department"] . "<center>";

			if ($_GET["stype"] == "Print") {
				$sql = "select * from tmpstk where QTYINHAND_STORES!=0 order by BRAND,STK_NO";
			} else {
				$sql = "select * from tmpstk where QTYINHAND_STORES!=0 and TOTCOST!=0 order by BRAND,STK_NO";
			}

			//echo $sql;
			//echo "<center><table border=1><tr>
			//	<th>Item</th><th>Description</th><th>Part No</th><th>Qty in hand </th><th>Cost</th><th>Total</th></tr>
			//	<th></th><th><b>".$_GET["brand"]."</b></th><th></th><th></th><th></th><th></th></tr>";

			echo "<center><table border=1><tr>
		<th>Item</th><th>Description</th><th>Part No</th><th>Qty in hand </th></tr>
		<th></th><th><b>" . $_GET["brand"] . "</b></th><th></th><th></th></tr>";

			$QTYINHAND_STORES = 0;
			$TOTCOST = 0;
			$mbrand = "";
			//echo $sql;
			$result = mysqli_query($GLOBALS['dbinv'], $sql);
			while ($rows = mysqli_fetch_array($result)) {

				if ($rows['BRAND'] != $mbrand) {
					echo "<tr><th align='left' colspan='4'>" . $rows["BRAND"] . "</th></tr>";
				}

				echo "<tr><td>" . $rows["STK_NO"] . "</td>";
				echo "<td>" . $rows["DESCRIPT"] . "</td>";
				echo "<td>" . $rows["PARTNO"] . "</td>";
				echo "<td align=\"right\">" . number_format($rows["QTYINHAND_STORES"], 0, ".", ",") . "</td></tr>";
				$QTYINHAND_STORES = $QTYINHAND_STORES + $rows["QTYINHAND_STORES"];
				$TOTCOST = $TOTCOST + $rows["TOTCOST"];
				$mbrand = $rows['BRAND'];

			}

			//echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td align=\"right\"><b>".number_format($QTYINHAND_STORES, 2, ".", ",")."</b></td><td align=\"right\">&nbsp;</td><td align=\"right\"><b>".number_format($TOTCOST, 2, ".", ",")."</b></td></tr>";
			echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td align=\"right\"><b>" . number_format($QTYINHAND_STORES, 2, ".", ",") . "</b></td></tr>";

			echo "</table>";
		}

		function printit() {

			require_once ("connectioni.php");

			//$sql = "select * from tmpstk where QTYINHAND_STORES!=0 and TOTCOST!=0  order by GROUP1";
			$sql = "select * from tmpstk where QTYINHAND_STORES!=0   order by DESCRIPT";

			echo "<center>Sales Summery Report On " . date("Y-m-d") . " &nbsp;&nbsp;&nbsp;&nbsp;Brand :" . $_GET["brand"] . "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Department : " . $_GET["department"] . "<center>";

			echo "<center><table border=1><tr>
		<th>Item</th><th>Description</th><th>Part No</th><th>Qty in hand </th>";
		if ($_GET["stype"] =="Cost") {
		echo "<th>Cost</th>";
		}
		
		echo "<th>Selling</th>";
		
		if ($_GET["stype"] =="Cost") {
		echo "<th>Total Cost</th>";
		}
		echo "</tr>
		<th></th><th><b>" . $_GET["brand"] . "</b></th><th></th><th></th><th></th><th></th><th></th></tr>";

			$QTYINHAND_STORES = 0;
			$TOTCOST = 0;
			//echo $sql;
			$result = mysqli_query($GLOBALS['dbinv'], $sql);
			while ($rows = mysqli_fetch_array($result)) {
				
				$sql1 = "select * from s_mas where STK_NO='" . $rows["STK_NO"] . "'";
					$result1 = mysqli_query($GLOBALS['dbinv'], $sql1);
					if ($rows1 = mysqli_fetch_array($result1)) {
						echo "<tr><td>" . $rows["STK_NO"] . "</td>
								  <td>" . $rows["DESCRIPT"] . "</td>
								  <td>" . $rows["PARTNO"] . "</td>
								  <td align=\"right\">" . number_format($rows["QTYINHAND_STORES"], 0, ".", ",") . "</td>";
						if ($_GET["stype"] =="Cost") {		  
						echo	  "<td align=\"right\">" . number_format($rows["COST"], 2, ".", ",") . "</td>";
						}
						echo	  "<td align=\"right\">" . number_format($rows1["SELLING"], 2, ".", ",") . "</td>";
						if ($_GET["stype"] =="Cost") {	
						echo	  "<td align=\"right\">" . number_format($rows["TOTCOST"], 2, ".", ",") . "</td>";
						}
						echo 	 "</tr>";
								  
						$QTYINHAND_STORES = $QTYINHAND_STORES + $rows["QTYINHAND_STORES"];
						$TOTCOST = $TOTCOST + $rows["TOTCOST"];
						
					}	
			}

			echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td align=\"right\"><b>" . number_format($QTYINHAND_STORES, 0, ".", ",") . "</b></td><td align=\"right\">&nbsp;</td><td></td><td align=\"right\"><b>" . number_format($TOTCOST, 2, ".", ",") . "</b></td></tr>";
			echo "</table>";
		}

		function printit_selling() {
			require_once ("connectioni.php");

			//$sql = "select * from tmpstk where QTYINHAND_STORES!=0 and TOTCOST!=0  order by GROUP1";
			$sql = "select * from tmpstk where QTYINHAND_STORES!=0  order by DESCRIPT";

			echo "<center>Sales Summery Report On " . date("Y-m-d") . " &nbsp;&nbsp;&nbsp;&nbsp;Brand :" . $_GET["brand"] . "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Department : " . $_GET["department"] . "<center>";

			echo "<center><table border=1><tr>
		<th>Item</th><th>Description</th><th>Part No</th><th>Qty in hand </th><th>Selling</th><th>Total</th></tr>
		<th></th><th><b>" . $_GET["brand"] . "</b></th><th></th><th></th><th></th><th></th></tr>";

			$QTYINHAND_STORES = 0;
			$TOTCOST = 0;
			//echo $sql;
			$result = mysqli_query($GLOBALS['dbinv'], $sql);
			while ($rows = mysqli_fetch_array($result)) {
				echo "<tr><td>" . $rows["STK_NO"] . "</td><td>" . $rows["DESCRIPT"] . "</td><td>" . $rows["PARTNO"] . "</td><td align=\"right\">" . number_format($rows["QTYINHAND_STORES"], 0, ".", ",") . "</td><td align=\"right\">" . number_format($rows["COST"], 2, ".", ",") . "</td><td align=\"right\">" . number_format($rows["TOTCOST"], 2, ".", ",") . "</td></tr>";
				$QTYINHAND_STORES = $QTYINHAND_STORES + $rows["QTYINHAND_STORES"];
				$TOTCOST = $TOTCOST + $rows["TOTCOST"];
			}

			echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td align=\"right\"><b>" . number_format($QTYINHAND_STORES, 0, ".", ",") . "</b></td><td align=\"right\">&nbsp;</td><td align=\"right\"><b>" . number_format($TOTCOST, 2, ".", ",") . "</b></td></tr>";
			echo "</table>";
		}

		if ($_GET["department"] == "All") {

			if ($_GET["chkitem"] != "on") {
				if ($_GET["stype"] == "Cost") {

					cost();
				} else if ($_GET["stype"] == "Selling") {

					selling();
				} else {

					print_rep();
				}
			} else {

				$sql = "select itemcode, name from tmpitem";
				$result = mysqli_query($GLOBALS['dbinv'], $sql);
				while ($rows = mysqli_fetch_array($result)) {

					$sql1 = "select * from s_mas where STK_NO='" . $rows["itemcode"] . "'";
					$result1 = mysqli_query($GLOBALS['dbinv'], $sql1);
					if ($rows1 = mysqli_fetch_array($result1)) {
						$costval = 0;
						if ($_GET["stype"] == "Cost") {
							if ($_SESSION['dev'] == '1') {
								if (!is_null($rows1["acc_cost"])) {$costval = $rows1["acc_cost"];
								}
							} else if ($_SESSION['dev'] == '0') {
								if (!is_null($rows1["acc_cost"])) {$costval = $rows1["acc_cost"];
								}
							}
						} else {
							if (!is_null($rows1["selling"])) {$costval = $rows1["selling"];
							}
						}

						$sql2 = "Insert into tmpstk (STK_NO, DESCRIPT, PARTNO, COST, TOTCOST, QTYINHAND_STORES, group1) values ('" . $rows1["STK_NO"] . "', '" . $rows1["DESCRIPT"] . "', '" . $rows1["PART_NO"] . "', " . $costval . ", " . $costval * $rows1["QTYINHAND_STORES"] . ", " . $rows1["QTYINHAND_STORES"] . ", '" . $rows1["GROUP1"] . "')";

						$result2 = mysqli_query($GLOBALS['dbinv'], $sql2);
						$costval = 0;
					}

				}

				if ($_GET["stype"] == "Print") {

					printit_print();
				} else {
					//echo "printit";
					printit();
				}

			}

		} else {

			if ($_GET["chkitem"] != "on") {

				if ($_GET["brand"] != "All") {$sql = "select * from viewsubmas where BRAND_NAME='" . $_GET["brand"] . "' and STO_CODE='" . ($_GET["department"]) . "' and QTYINHAND_STORES!=0  ORDER BY STK_NO, GROUP1, GROUP2, model ";
				}

				if ($_GET["brand"] == "All") {$sql = "select * from viewsubmas where STO_CODE='" . ($_GET["department"]) . "' and QTYINHAND_STORES!=0  ORDER BY  STK_NO, GROUP1, GROUP2, model ";
				}
				//echo $sql;
				$result = mysqli_query($GLOBALS['dbinv'], $sql);
				while ($rows = mysqli_fetch_array($result)) {
					$costval = 0;
					if ($_GET["stype"] == "Cost") {
						if ($_SESSION['dev'] == '1') {
							if (!is_null($rows["COST"])) { 
								$costval = $rows["COST"];
							}
						} else if ($_SESSION['dev'] == '0') {
							if (!is_null($rows["acc_cost"])) { 
								$costval = $rows["acc_cost"];
							}
						}
					} else {
						if (!is_null($rows["SELLING"])) { $costval = $rows["SELLING"];
						}
					}

					if ($_GET['cmb_t']=="All") {
						$sql = "select * from brand_mas where barnd_name ='" . $rows["BRAND_NAME"] . "'";
					} else {
						$sql = "select * from brand_mas where barnd_name ='" . $rows["BRAND_NAME"] . "' and costcenter='" . $_GET['cmb_t'] . "'";	
					}
					$resultbc = mysqli_query($GLOBALS['dbinv'], $sql);
					if ($rowsbc = mysqli_fetch_array($resultbc)) {
						$sql1 = "Insert into tmpstk (STK_NO, DESCRIPT, PARTNO, COST, TOTCOST, QTYINHAND_STORES, BRAND, group1) values ('" . $rows["STK_NO"] . "', '" . $rows["DESCRIPT1"] . "', '" . $rows["PART_NO"] . "', " . $costval . ", " . $costval * $rows["QTYINHAND_STORES"] . ", " . $rows["QTYINHAND_STORES"] . ", '" . $rows["BRAND_NAME"] . "', '" . $rows["GROUP1"] . "')";
						$result1 = mysqli_query($GLOBALS['dbinv'], $sql1);
					}
					
					$costval = 0;

				}

				if ($_GET["stype"] == "Print") {
					printit_print();
				} else if ($_GET["stype"] == "Selling") {
					printit_selling();
				} else {
					printit();
				}

			} else {

				$sql = "select * from tmpitem";
				$result = mysqli_query($GLOBALS['dbinv'], $sql);
				while ($rows = mysqli_fetch_array($result)) {
					$sql1 = "select * from s_mas where STK_NO='" . $rows["itemcode"] . "'";
					$result1 = mysqli_query($GLOBALS['dbinv'], $sql1);
					if ($rows1 = mysqli_fetch_array($result1)) {
						$sql2 = "select QTYINHAND_STORES from s_submas where STK_NO='" . $rows["itemcode"] . "' and STO_CODE='" . intval($_GET["department"]) . "'";
						$result2 = mysqli_query($GLOBALS['dbinv'], $sql2);
						if ($rows2 = mysqli_fetch_array($result2)) {
							$costval = 0;
							if ($_GET["stype"] = "Cost") {
								if ($_SESSION['dev'] == '1') {
									$costval = $rows1["COST"];
								} else if ($_SESSION['dev'] == '0') {
									$costval = $rows1["acc_cost"];
								}
							} else {
								$costval = $rows1["SELLING"];
							}

							$sql3 = "Insert into tmpstk (STK_NO, DESCRIPT, PARTNO, TOTCOST, QTYINHAND, BRAND, group1) values 
					('" . $rows1["STK_NO"] . "', '" . $rows1["DESCRIPT"] . "', '" . $rows1["PART_NO"] . "', " . $costval . ", " . $costval * $rows2["QTYINHAND_STORES"] . ", " . $rows2["QTYINHAND_STORES"] . ", '" . $rows1["BRAND_NAME"] . "', '" . $rows1["GROUP1"] . "')";
							$result3 = mysqli_query($GLOBALS['dbinv'], $sql3);
							$costval = 0;

						}
					}
				}

				if ($_GET["stype"] == "Print") {
					printit_print();
				} else if ($_GET["stype"] == "Selling") {
					printit_selling();
				} else {
					printit();
				}
			}
		}
	?>
	</body>
</html>
