<?php
require("includes/check_auth_user.php");
require("includes/dbconnect.php");
include('includes/function.php');

ini_set('display_errors', 1);
error_reporting(E_ERROR);

$admin = $_SESSION["admin_" . $dbname];
$zdb = $_SESSION["zdbyear_" . $dbname];
$zroot = $_SESSION["zdir"];
$zcomp = $_SESSION["comp_" . $dbname];

$myyear = $_SESSION[$myyear];
mysqli_select_db($conn, $zdb);
$zyear = $myyear;

$vouch = $_GET['vouchno'];

$cond = '';
$lcond = '';
$formname = "Credit Note - Raw Material";

$maindb = 'credrawmain';
$trandb = 'credrawtran';

$getqry = mysqli_query($conn, "SELECT *, DATE_FORMAT(`vouchdt`, '%d-%m-%Y')as vouchdt   FROM `$maindb` WHERE vouchno='$vouch' ORDER BY `vouchno`") or die(mysqli_error($conn));
$getdata = mysqli_fetch_array($getqry);

$cmpname = mysqli_query($conn, "SELECT * From $zroot.`company` where `code`='$zcomp'") or die(mysqli_error($conn));
$getcmpname = mysqli_fetch_array($cmpname);

$getparty = mysqli_query($conn, "SELECT * From accmast WHERE `accode` = '$getdata[broker]'") or die(mysqli_error($conn));
$showparty = mysqli_fetch_array($getparty);

$getbroker = mysqli_query($conn, "SELECT * From accmast WHERE `accode` = '$getdata[broker]'") or die(mysqli_error($conn));
$showbroker = mysqli_fetch_array($getbroker);

// $gettran2 = mysqli_query($conn, "SELECT irno,qrcode FROM `gsteinvoicecred` WHERE invno='$getdata[vouchno]' AND frm = 'P' ") or die(mysqli_error($conn));
// $fettran2 = mysqli_fetch_array($gettran2);
$oms = $getdata['oms'];

if ($getdata['mirnno'] != "") {
    $irno = $getdata['mirnno'];
} else {
    $irno = $fettran2['irno'];
}
?>

<!DOCTYPE HTML>
<html lang="en-US">


<?php
//        include("includes/files.php");
//        include("includes/tabsuf.php");
?>
<style>
    body {
        width: 100%;
        height: 100%;
        margin: 0;
        padding: 0;
        /*background-color: #FAFAFA;*/
        font: 10pt "Verdana";
    }

    @media print {
        .noprint {
            display: none;
        }
    }

    * {
        box-sizing: border-box;
        -moz-box-sizing: border-box;
    }

    .page {
        width: 210mm;
        min-height: 297mm;
        padding: 4mm;
        margin: 10mm auto;
        border: 1px #D3D3D3 solid;
        border-radius: 5px;
        /*background: white;*/

    }

    .subpage {
        padding: 0cm;
        /*        border: 1px solid;*/
        height: 288mm;
        outline: 2cm #ffffff solid;
    }

    @page {
        size: A4;
        margin: 0;
    }

    @media print {

        html,
        body {
            width: 210mm;
            height: 297mm;
        }

        .page {
            margin: 0;
            border: initial;
            border-radius: initial;
            width: initial;
            min-height: initial;
            box-shadow: initial;
            background: initial;
            page-break-after: always;
        }
    }

    .numeric {
        text-align: right;
    }

    .rnone {
        border-right: none;
    }

    .lnone {
        border-left: none;
    }
</style>
</head>

<body id="main_container">
    <!-- <body id="main_container" onload="window.print();"> -->
    <div class="book">
        <button class="btn btn-primary goBack noprint" onclick="window.close()"
            style="float: right;width: 150px;height:35px;background-color: white;color:#A0B1BA;">Go Back</button>
        <div class="page">
            <!--<div class="subpage">-->
            <!--   ************Header************  -->
            <div style="border:solid 1px;" class="col-md-12">
                <center>
                    <p style="margin-top:2px;margin-bottom: 2px;font-size:11px; "><u>Subject To Mumbai Jurisdiction</u>
                    </p>
                </center>

                <?php include("includes/head_print.php"); ?>


            </div>

            <div style="border:solid 1px;" class="col-md-12" style="padding-left: 1px ; padding-right: 1px">
                <table class="table table-border table-hover" style="width:100%">
                    <tr>
                        <td style="text-align: left; width:5%"><b>M/s.</b></td>
                        <td style="width:1%">:</td>
                        <td style="text-align: left; width:40%"><?php echo $showparty['name']; ?></td>
                        <td style="text-align: right ; width:30%"><b>Voucher</b></td>
                        <td style="width:1%">:</td>
                        <td style="text-align: left; width:20%"><?php echo $getdata['vouchno']; ?></td>
                    </tr>
                    <tr>
                        <td style="text-align: left; width:5%"><b>Shop.</b></td>
                        <td style="width:1%">:</td>
                        <td style="text-align: left; width:40%"><?php echo $showparty['add1']; ?></td>
                        <td style="text-align: right ; width:30%"><b>Date</b></td>
                        <td style="width:1%">:</td>
                        <td style="text-align: left; width:20%; margin-right: 15px;"><?php echo $getdata['vouchdt']; ?>
                        </td>
                    </tr>
                    <tr>
                        <td style="text-align: left; width:5%"></td>
                        <td style="width:1%"></td>
                        <td style="text-align: left; width:40%"><?php echo $showparty['add2'] . $showparty['add3']; ?>
                        </td>
                        <td style="text-align: right ; width:30%"><b>Against Inv No.</b></td>
                        <td style="width:1%">:</td>
                        <td style="text-align: left; width:20%"><?php echo $getdata['invno'] ?></td>
                    </tr>
                    <tr>
                        <td style="text-align: left; width:5%"><b>Mobile</b></td>
                        <td style="width:1%">:</td>
                        <td style="text-align: left; width:40%"><?php echo $showparty['mobile']; ?></td>
                        <td style="text-align: right ; width:30%"><b>Invoice Date </b></td>
                        <td style="width:1%">:</td>
                        <td style="text-align: left; width:20%"><?php echo $getdata['invdt'] ?></td>
                    </tr>
                    <tr>
                        <td style="text-align: left; width:10%"><b>GST No: </b></td>
                        <td style="width:1%">:</td>
                        <td style="text-align: left; width:40%"><?php echo $showparty['gstno']; ?></td>
                        <td style="text-align: right ; width:30%"></td>
                        <td style="width:1%"></td>
                        <td style="text-align: left; width:20%"></td>
                    </tr>
                </table>
            </div>

            <div>
                <div>
                    <table border="solid 1px" style="border-collapse: collapse; width:100%">
                        <tr>
                            <th style="width:3%; color:black;"><label>Sr.</label></th>
                            <th style="width:25%; color:black;"><label>Material.</label></th>
                            <th style="width:15%; color:black;"><label>Color</label></th>
                            <th style="width:9%; color:black;"><label>Lot</label></th>
                            <th style="width:9%; color:black; text-align: right;"><label>Qty</label></th>
                            <th style="width:10%; color:black; text-align: right;"><label>Rate</label></th>
                            <th style="width:10%; color:black; text-align: right;"><label>Amount</label></th>
                        </tr>

                        <?php
                        $ctr = 0;
                        $ctab = 0;
                        $totqty = 0;
                        $gettran = mysqli_query($conn, "SELECT * FROM `$trandb` WHERE `vouchno`='$vouch' order by srno") or die(mysqli_error($conn));
                        while ($showtran = mysqli_fetch_array($gettran)) {
                            $finditem = mysqli_query($conn, "SELECT `code`,`name` FROM `rawmat` WHERE `code`='$showtran[item]'") or die(mysqli_error($conn));
                            $fitem = mysqli_fetch_array($finditem);

                            $getcolor = mysqli_query($conn, "SELECT `code`, `name` FROM `color` WHERE `code` = '$showtran[color]'") or die(mysqli_error($conn));
                            $showcolor = mysqli_fetch_array($getcolor);

                            echo "<tr style='height:24px'>";
                            echo "<td style=''>$showtran[srno]</td>";
                            echo "<td>$fitem[name]</td>";
                            echo "<td>$showcolor[name]</td>";
                            echo "<td>$showtran[lot]</td>";
                            echo "<td style='text-align: right;'>$showtran[qty]</td>";
                            echo "<td style='text-align: right;'>$showtran[rate]</td>";
                            echo "<td style='text-align: right;'>$showtran[amount]</td>";
                            echo "</tr>";

                            $totqty = $totqty + $showtran['qty'];

                            $ctr++;
                            $ctab = $ctab + 1;
                        }
                        if ($ctab < 16) {
                            for ($i = $ctab; $i <= 16; $i++) {
                                $ctab = $ctab + 1;
                                ?>
                                <tr style="height:24px;">
                                    <td class="border"></td>
                                    <td class="border"></td>
                                    <td class="border"></td>
                                    <td class="border"></td>
                                    <td class="border"></td>
                                    <td class="border"></td>
                                    <td class="border"></td>
                                </tr>
                                <?php
                            }
                        }
                        ?>

                        <tr style="">
                            <td colspan="3" style="border:none">
                                <? echo "$getdata[remark1]" . " &nbsp;" . "$getdata[remark2]"; ?>
                            </td>
                            <td style="text-align: right; ">Total </td>
                            <td style="text-align: right; "><? echo $totqty; ?> </td>
                            <td style="text-align: right;"> Subtotal </td>
                            <td style="text-align: right;border-left: none;"> <? echo $getdata['subtotal']; ?> </td>
                        </tr>

                        <?php
                        if ($getdata['litemdisc'] > 0) {
                            ?>
                            <tr>
                                <td colspan="5" style="text-align: right; " class="lnone rnone"> Less Item Discount </td>
                                <td style="text-align: right; " class="lnone rnone"> </td>
                                <!--<td class="lnone rnone"></td>-->
                                <td style="text-align: right; " class="lnone "> <? echo $getdata['litemdisc']; ?> </td>
                            </tr>
                            <?php
                        }
                        if ($getdata['cdiscamt'] > 0) {
                            ?>
                            <tr>
                                <td colspan="5" style="text-align: right;" class=" rnone"> Less Cash Discount </td>
                                <td style="text-align: right;" class="lnone rnone"> <? echo $getdata['cdiscperc']; ?> </td>
                                <td class="lnone rnone">%</td>
                                <td style="text-align: right; " class="lnone "> <? echo $getdata['cdiscamt']; ?> </td>
                            </tr>
                            <?php
                        }

                        if ($getdata['taxdisc'] > 0) {
                            ?>
                            <tr>
                                <td colspan="5" style="text-align: right;" class="rnone"> Less Discount </td>
                                <td style="text-align: right; " class="lnone rnone"> </td>
                                <td class="lnone rnone"></td>
                                <td style="text-align: right;" class="lnone "> <? echo $getdata['taxdisc']; ?> </td>
                            </tr>
                            <?php
                        }
                        if ($getdata['lesother'] > 0) {
                            ?>
                            <tr>
                                <td colspan="5" style="text-align: right;" class="rnone"> Less Other</td>
                                <td style="text-align: right; " class="lnone rnone"> </td>
                                <td class="lnone rnone"></td>
                                <td style="text-align: right;" class="lnone "> <? echo $getdata['lesother']; ?> </td>
                            </tr>
                            <?php
                        }

                        if ($getdata['totalamount'] > 0) { ?>
                            <tr>
                                <td colspan="3" class=" rnone"></td>
                                <td colspan="2" style="text-align: right; " class=" rnone"><b>Total Amount</b></td>
                                <td style="text-align: right; " class="lnone rnone"><b></b></td>
                                <td style="text-align: right; " class="lnone "><b><? echo $getdata['totalamount']; ?></b>
                                </td>
                            </tr>
                        <?php }

                        if ($getdata['roundoff'] > 0) { ?>
                            <tr>
                                <td colspan="3" class=" rnone"></td>
                                <td colspan="2" style="text-align: right; " class=" rnone"><b>RoundOff</b></td>
                                <td style="text-align: right; " class="lnone rnone"><b></b></td>
                                <td style="text-align: right; " class="lnone "><b><? echo $getdata['roundoff']; ?></b>
                                </td>
                            </tr>
                        <?php } ?>
                        <tr>
                            <td colspan="3" class=" rnone"></td>
                            <td colspan="2" style="text-align: right; " class=" rnone"><b>Net Amount</b></td>
                            <td style="text-align: right; " class="lnone rnone"><b></b></td>
                            <td style="text-align: right; " class="lnone "><b><? echo $getdata['netamt']; ?></b>
                            </td>
                        </tr>


                        <!-- <tr>
                            <td colspan="12">
                                Amount In Words:
                                <?php echo rsword(round($getdata['netamt'])); ?>
                            </td>
                        </tr> -->

                    </table>
                </div>

                <div>
                    <table class="border">
                        <tr>
                            <td class="border" style="width: 541px; font-size: 14px;">
                                <!--<img src="images/taximg.png">-->
                            </td>
                            <td class="border" style="width: 216px">
                                <?php
                                require("includes/dbconnect.php");
                                ?>
                                <div style=" text-align:right; font-size: 14px; font-weight: 900">
                                    <? echo "For $getcmpname[name]"; ?>
                                </div>
                                <br>
                                <br>
                                <br>
                                <div style=" margin-left: 51px; font-size: 11px">AUTHORISED SIGNATORY</div>
                            </td>
                        </tr>
                    </table>
                </div>

            </div>

        </div>
        <?php
        include("includes/linksfoot.php");
        ?>
        <script>
            $(function () {
                formGeneral();
            });
        </script>
</body>

</html>