<?php
ini_set('session.gc_maxlifetime', 30 * 60 * 60 * 60);
session_start();
date_default_timezone_set('Asia/Colombo');
?>
<!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
        if ($_GET['lockite'] == on) {
            require_once ("connectioni.php");

            $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>";

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

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

            echo "<center><b>Locked Stock Item 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"];
                }


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

            echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td align=\"right\"><b>" . number_format($QTYINHAND, 0, ".", ",") . "</b></td><td align=\"right\">&nbsp;</td><td align=\"right\"><b>" . number_format($tot, 2, ".", ",") . "</b></td></tr>";
            echo "</table>";
        } else {
            require_once ("connectioni.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!=0  ";
                    }
                    if ($_GET["brand"] == "All") {
                        $sql = "select * from s_mas where QTYINHAND!=0  ";
                    }
                }

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

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

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

// echo $sql;

                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"];
                    }
// echo $_SESSION['dev'];
                    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"], 0, ".", ",") . "</td><td align=\"right\">" . number_format($rows["COST1"], 2, ".", ",") . "</td><td align=\"right\">" . number_format(($rows["QTYINHAND"] * $rows["COST1"]), 2, ".", ",") . "</td></tr>";
                        $totstk = $totstk + $rows["QTYINHAND"];
                        $cost = $cost + ($rows["QTYINHAND"] * $rows["COST1"]);
                    } 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"], 0, ".", ",") . "</td><td align=\"right\">" . number_format($rows["COST1"], 2, ".", ",") . "</td><td align=\"right\">" . number_format(($rows["QTYINHAND"] * $rows["COST1"]), 2, ".", ",") . "</td></tr>";
                        $totstk = $totstk + $rows["QTYINHAND"];
                        $cost = $cost + ($rows["QTYINHAND"] * $rows["COST1"]);
                    }
                }

                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!=0  ORDER BY DESCRIPT, GROUP1, model, GROUP2 ";
                }
                if ($_GET["brand"] == "All") {
                    $sql = "select * from s_mas where QTYINHAND!=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 = 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"], 0, ".", ",") . "</td><td align=\"right\">" . number_format($rows["SELLING"], 2, ".", ",") . "</td><td align=\"right\">" . number_format($rows["QTYINHAND"] * $rows["SELLING"], 2, ".", ",") . "</td></tr>";
                    $QTYINHAND = $QTYINHAND + $rows["QTYINHAND"];
                    $tot = $tot + ($rows["SELLING"] * $rows["QTYINHAND"]);
                }

                echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td align=\"right\"><b>" . number_format($QTYINHAND, 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!=0 ORDER BY  DESCRIPT, GROUP1, model, GROUP2 ";
                }
                if ($_GET["brand"] == "All") {
                    $sql = "select * from s_mas where QTYINHAND!=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 = 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"], 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"] > $mnewstk) {
                            $munsold = $rows["QTYINHAND"] - $mnewstk;
                        }

                        echo "<td align=\"right\">" . number_format($munsold, 0, ".", ",") . "</td>";
                        echo "<td align=\"right\">" . number_format($rows["SELLING"], 0, ".", ",") . "</td>";
                        echo "</tr>";
                        $QTYINHAND = $QTYINHAND + $rows["QTYINHAND"];
                    }
                }
                echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td align=\"right\"><b>" . number_format($QTYINHAND, 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!=0 order by BRAND,STK_NO";
                } else {
                    $sql = "select * from tmpstk where QTYINHAND!=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 = 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"], 0, ".", ",") . "</td></tr>";
                    $QTYINHAND = $QTYINHAND + $rows["QTYINHAND"];
                    $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, 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, 2, ".", ",") . "</b></td></tr>";

                echo "</table>";
            }

            function printit() {

                require_once ("connectioni.php");

                //$sql = "select * from tmpstk where QTYINHAND!=0 and TOTCOST!=0  order by GROUP1";
                $sql = "select * from tmpstk where QTYINHAND!=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 = 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"], 0, ".", ",") . "</td>";
                        if ($_GET["stype"] == "Cost") {
                            echo "<td align=\"right\">" . number_format($rows["COST1"], 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 = $QTYINHAND + $rows["QTYINHAND"];
                        $TOTCOST = $TOTCOST + $rows["TOTCOST"];
                    }
                }

                echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td align=\"right\"><b>" . number_format($QTYINHAND, 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!=0 and TOTCOST!=0  order by GROUP1";
                $sql = "select * from tmpstk where QTYINHAND!=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 = 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"], 0, ".", ",") . "</td><td align=\"right\">" . number_format($rows["COST"], 2, ".", ",") . "</td><td align=\"right\">" . number_format($rows["TOTCOST"], 2, ".", ",") . "</td></tr>";
                    $QTYINHAND = $QTYINHAND + $rows["QTYINHAND"];
                    $TOTCOST = $TOTCOST + $rows["TOTCOST"];
                }

                echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td align=\"right\"><b>" . number_format($QTYINHAND, 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["COST1"])) {
                                        $costval = $rows1["COST1"];
                                    }
                                } else if ($_SESSION['dev'] == '0') {
                                    if (!is_null($rows1["COST1"])) {
                                        $costval = $rows1["COST1"];
                                    }
                                }
                            } else {
                                if (!is_null($rows1["selling"])) {
                                    $costval = $rows1["selling"];
                                }
                            }

                            $sql2 = "Insert into tmpstk (STK_NO, DESCRIPT, PARTNO, COST, TOTCOST, QTYINHAND, group1) values ('" . $rows1["STK_NO"] . "', '" . $rows1["DESCRIPT"] . "', '" . $rows1["PART_NO"] . "', " . $costval . ", " . $costval * $rows1["QTYINHAND"] . ", " . $rows1["QTYINHAND"] . ", '" . $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!=0  ORDER BY STK_NO, GROUP1, GROUP2, model ";
                    }

                    if ($_GET["brand"] == "All") {
                        $sql = "select * from viewsubmas where STO_CODE='" . ($_GET["department"]) . "' and QTYINHAND!=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["COST1"])) {
                                    $costval = $rows["COST1"];
                                }
                            } else if ($_SESSION['dev'] == '0') {
                                if (!is_null($rows["COST1"])) {
                                    $costval = $rows["COST1"];
                                }
                            }
                        } 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, BRAND, group1) values ('" . $rows["STK_NO"] . "', '" . $rows["DESCRIPT1"] . "', '" . $rows["PART_NO"] . "', " . $costval . ", " . $costval * $rows["QTYINHAND"] . ", " . $rows["QTYINHAND"] . ", '" . $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 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["COST1"];
                                    } else if ($_SESSION['dev'] == '0') {
                                        $costval = $rows1["COST1"];
                                    }
                                } 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"] . ", " . $rows2["QTYINHAND"] . ", '" . $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>
