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

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

$myyear = $_SESSION[$myyear];
mysqli_select_db($conn, $zdb);
$cond = '';
$lcond = '';
$formname = "Purchase";
$maindb = 'pgstmain';
$trandb = 'pgsttran';
$vouch = $_GET['vouchno'];

$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 `accode`,`name`, `add1`, `add2`, `add3`, `mobile`, `gstno` From accmast WHERE `accode` = '$getdata[party]'") or die(mysqli_error($conn));
$showparty = mysqli_fetch_array($getparty);
?>

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

<style>
    @media print {
        .noprint {
            display: none;
        }
    }

    body {
        width: 100%;
        height: 100%;
        margin: 0;
        padding: 0;
        font: 12pt "Tahoma";
    }

    * {
        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;

    }

    .subpage {
        padding: 0cm;
        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>

<!--<link href="MyStyle/rep_format.css" rel="stylesheet">-->

<body id="main_container">
    <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">
                <h3><center><? echo $getcmpname['pname']; ?></center></h3>
                <center><?php echo $getcmpname['add1'] . " " . $getcmpname['add2'] . " " . $getcmpname['add3']; ?></center>
                <center><?php echo "Email :" . $getcmpname['email'] . " &nbsp " . "Contact No :" . $getcmpname['tel'] . "/" . $getcmpname['mobile']; ?></center>
                <center>GST No. : <?= $getcmpname['gst']; ?></center>
                <h5><center><b><?php echo $formname; ?></b></center></h5>
            </div>

            <div style="border:solid 1px;" class="col-md-12" style="padding-left: 1px ; padding-right: 1px">
                <?php
                mysqli_select_db($conn, $zdb);

                ?>
                <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:7%"><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%"><?php echo "$getdata[vouchdt]"; ?></td>
                    </tr>
                    <tr>
                        <td style="text-align: left; width:7%"></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>Invoice No.</b></td>
                        <td style="width:1%">:</td>
                        <td style="text-align: left; width:20%"><?= $getdata["invno"] ?></td>
                    </tr>
                    <tr>
                        <td style="text-align: left; width:9%"><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%"><b>Mobile</b></td>
                        <td style="width:1%">:</td>
                        <td style="text-align: left; width:20%"><?php echo "$showparty[mobile]"; ?></td>
                    </tr>
                </table>
            </div>

            <div>
                <table border="solid 1px" style="border-collapse: collapse; width:100%">
                    <tr>
                        <th style="width:5%; color:black; text-align: right;"><label>Sr.</label></th>
                        <th style="width:35%; color:black;"><label>Item</label></th>
                        <th style="width:10%; color:black;"><label>Size</label></th>
                        <th style="width:10%; color:black;"><label>HSN</label></th>
                        <th style="width:10%; 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:13%; color:black; text-align: right;"><label>Amount</label></th>
                    </tr>

                    <?php
                    $ctr = 0;
                    $ctab = 0;

                    $gettran = mysqli_query($conn, "SELECT c.name AS color, t.size AS size, t.hsncode AS hsncode, t.srno AS srno, t.qty AS qty,
                        t.unit AS unit, t.rate AS rate, t.amount AS amount, i.name AS item FROM `$trandb`t
                        LEFT JOIN `color` c ON c.code = t.color
                        LEFT JOIN `item` i ON i.code = t.itemcode
                        WHERE `vouchno`='$vouch' order by srno") or die(mysqli_error($conn));
                    while ($showtran = mysqli_fetch_array($gettran)) {

                        echo "<tr>";
                        echo "<td style='text-align: right;'>$showtran[srno]</td>";
                        echo "<td>$showtran[item]</td>";
                        echo "<td>$showtran[size]</td>";
                        echo "<td style='text-align: right;'>$showtran[hsncode]</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>";

                        $ctr++;
                        $ctab = $ctab + 1;
                    }
                    if ($ctab < 15) {
                        for ($i = $ctab; $i <= 15; $i++) {
                            $ctab = $ctab + 1;
                    ?>
                            <tr style="height:26px;">
                                <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>
                        <td colspan="2" style="border:none"><? echo "$getdata[remark1]" . " &nbsp;" . "$getdata[remark2]"; ?></td>
                        <td colspan="4" style="text-align: right;border:none"> Subtotal </td>
                        <td style="text-align: right;border-left: none;"> <? echo  $getdata['subtotal']; ?> </td>
                    </tr>
                    <!-- less item discount -->
                    <?php
                    if ($getdata['litemdisc'] > 0) {
                    ?>
                        <tr>
                            <td colspan="6" style="text-align: right; " class="lnone rnone"> Less Item Discount </td>
                            <td style="text-align: right; " class="lnone "> <? echo  $getdata['litemdisc']; ?> </td>
                        </tr>
                    <?php } ?>

                    <?php
                    if ($getdata['tottaxamt'] > 0) {
                    ?>
                        <tr>
                            <td colspan="6" style="text-align: right;" class="lnone rnone"> Taxable Value </td>
                            <td style="text-align: right;" class="lnone"> <? echo $getdata['tottaxamt']; ?> </td>
                        </tr>
                    <?php } ?>

                    <?php
                    // $totalgstamt =  $getdata['totgst5'] + $getdata['totgst12'] + $getdata['totgst18'] + $getdata['totgst28'];
                    // if ($totalgstamt > 0) {
                    ?>
                        <!-- <tr>
                            <td colspan="6" style="text-align: right;" class="lnone rnone"> Total GST </td>
                            <td style="text-align: right;" class="lnone"> <? echo $totalgstamt; ?> </td>
                        </tr> -->
                    <?php //} 
                    if ($getdata['totgst5'] . $getdata['totgst12'] . $getdata['totgst18'] . $getdata['totgst28'] > 0) {
                    ?>
                        <tr>
                            <td class="border" colspan="3"></td>
                            <th style='text-align:right'>CGST</th>
                            <th style='text-align:right'>SGST</th>
                            <th style='text-align:right'>IGST</th>
                            <th style='text-align:right'>Total</th>
                        </tr>
                        
                    <?php

                        echo "<tr>";
                        echo "<td style='text-align:right' colspan='3'><b>5%</b></td>";
                        echo "<td style='text-align:right'>$getdata[cgst5]</td>";
                        echo "<td style='text-align:right'>$getdata[sgst5]</td>";
                        echo "<td style='text-align:right'>$getdata[igst5]</td>";
                        echo "<td style='text-align:right'>$getdata[totgst5]</td>";
                        echo "</tr>";
                        echo "<tr>";
                        echo "<td style='text-align:right' colspan='3'><b>12%</b></td>";
                        echo "<td style='text-align:right'>$getdata[cgst12]</td>";
                        echo "<td style='text-align:right'>$getdata[sgst12]</td>";
                        echo "<td style='text-align:right'>$getdata[igst12]</td>";
                        echo "<td style='text-align:right'>$getdata[totgst12]</td>";
                        echo "</tr>";
                        echo "<tr>";
                        echo "<td style='text-align:right' colspan='3'><b>18%</b></td>";
                        echo "<td style='text-align:right'>$getdata[cgst18]</td>";
                        echo "<td style='text-align:right'>$getdata[sgst18]</td>";
                        echo "<td style='text-align:right'>$getdata[igst18]</td>";
                        echo "<td style='text-align:right'>$getdata[totgst18]</td>";
                        echo "</tr>";
                        echo "<tr>";
                        echo "<td style='text-align:right' colspan='3'><b>28%</b></td>";
                        echo "<td style='text-align:right'>$getdata[cgst28]</td>";
                        echo "<td style='text-align:right'>$getdata[sgst28]</td>";
                        echo "<td style='text-align:right'>$getdata[igst28]</td>";
                        echo "<td style='text-align:right'>$getdata[totgst28]</td>";
                        echo "</tr>";
                    }
                    ?>

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

                    <?php
                    if ($getdata['roundoff'] > 0) {
                    ?>
                        <tr>
                            <td colspan="6" style="text-align: right;" class="rnone"> Round Off </td>
                            <td style="text-align: right;" class="lnone"> <? echo $getdata['roundoff']; ?> </td>
                        </tr>
                    <?php } ?>

                    <?php
                    if ($getdata['netamt'] > 0) {
                    ?>
                        <tr>
                            <td colspan="6" style="text-align: right;" class="rnone"> Bill Amount (Rs.) </td>
                            <td style="text-align: right;" class="lnone"> <? echo $getdata['netamt']; ?> </td>
                        </tr>
                    <?php } ?>

                    <tr>
                        <td colspan="9">
                            Amount In Words : Rupees
                            <?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[pname]"; ?></div>
                            <br>
                            <br>
                            <br>
                            <div style=" margin-left: 51px; font-size: 11px">AUTHORISED SIGNATORY</div>
                        </td>
                    </tr>
                </table>
            </div>
        </div>
        <!--</div>-->
    </div>
    <?php
    include("includes/linksfoot.php");
    ?>
    <script>
        $(function() {
            formGeneral();
        });
    </script>
</body>

</html>