<?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);
$zyear = $myyear;

$vouch = $_GET['vouchno'];

$cond = '';
$lcond = '';
$formname = "Sale Returns";

$maindb = 'credmain';
$trandb = 'credtran';

$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[party]'")or die(mysqli_error($conn));
$showparty = mysqli_fetch_array($getparty);

$getsalesm = mysqli_query($conn, "SELECT `accode`,`name` From accmast WHERE `accode` = '$getdata[salesman]'")or die(mysqli_error($conn));
$showsalesm = mysqli_fetch_array($getsalesm);

$oms = $getdata['oms'];
?>

<!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>

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

<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 style="border:solid 1px;" class="col-md-12" >
                                <h1 style="margin-top:2px;margin-bottom: 11px;"><center><? Echo $getcmpname['pname']; ?></center></h1>
                                <center><?php echo $getcmpname['add1'] . " " . $getcmpname['add2'] . " " . $getcmpname['add3']; ?></center>
                                <center><?php echo "Email :" . $getcmpname['email'] . " &nbsp " . "Contact No :" . $getcmpname['tel'] . " " . $getcmpname['mobile']; ?></center>
                                <h5 style="margin-top:2px;margin-bottom: 2px;"><center><b><?php echo $formname; ?></b></center></h5>
                
                            </div>-->
            </div>
            <div style="border:solid 1px;border-collapse: collapse" class="col-md-12">

                <table class="table table-border table-hover" style="width:100%">
                    <tr>
                        <td style="text-align: center; width:50%;border:1px solid black"><b>Bill To Party</b></td>
                        <td style="text-align: center; width:50%;border:1px solid black"><b>Ship To Party</b></td>

                    </tr>
                    <tr>
                        <td style="text-align: center; width:50%;">
                            <div style="border-collapse: collapse" class="col-md-12">

                                <table class="table table-bordered table-hover" style="width:100%;border:1px solid black">
                                    <tr>
                                        <?php
                                        if ($getdata["nameprint"] != '') {
                                            $printname = $getdata["nameprint"];
                                            $printmobile = $getdata["printmobile"];
                                        } else {
                                            $printname = $showparty['name'];
                                            $printmobile = $showparty['mobile'];
                                        }
                                        ?>
                                        <td style="text-align: left; width:5%"><b>M/s.</b></td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:90%"><?php echo "$printname"; ?></td>

                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:7%">Address</td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:90%"><?php echo "$showparty[add1]  $showparty[add2]"; ?></td>
                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:7%">&nbsp;&nbsp;&nbsp;&nbsp;</td>
                                        <td style="width:1%"></td>
                                        <td style="text-align: left; width:90%"><?php echo "$showparty[add3]  $showparty[city] $showparty[pin]"; ?></td>
                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:7%">Mobile</td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:40%"><?php echo "$printmobile"; ?></td>

                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:17%">GST No.</td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:38%"><?php echo "$showparty[gstno]"; ?></td>

                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:10%">State</td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:30%"><?php echo "$showparty[state]"; ?></td>

                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:23%">State Code</td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:30%"><?php echo "$showparty[statecode]"; ?></td>
                                    </tr>

                                </table>
                            </div>


                        </td>
                        <td style="text-align: center; width:50%">
                            <div style="border-collapse: collapse" class="col-md-12">

                                <table class="table table-bordered table-hover" style="width:100%;border:1px solid black">
                                    <tr>
                                        <td style="text-align: left; width:5%"><b>M/s.</b></td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:90%"><?php echo "$printname"; ?></td>

                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:7%">Address</td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:90%"><?php echo "$showparty[add1]  $showparty[add2]"; ?></td>

                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:7%">&nbsp;&nbsp;&nbsp;&nbsp;</td>
                                        <td style="width:1%"></td>
                                        <td style="text-align: left; width:90%"><?php echo "$showparty[add3]  $showparty[city] $showparty[pin]"; ?></td>
                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:7%">Mobile</td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:40%"><?php echo "$printmobile"; ?></td>

                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:17%">GST No.</td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:38%"><?php echo "$showparty[gstno]"; ?></td>

                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:10%">State</td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:30%"><?php echo "$showparty[state]"; ?></td>

                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:23%">State Code</td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:30%"><?php echo "$showparty[statecode]"; ?></td>
                                    </tr>

                                </table>
                            </div>


                        </td>

                    </tr>
                    <tr style="">
                        <td style="text-align: center; width:50%;border:1px solid black;border-right: 1px solid black ">
                            <div style="border-collapse: collapse" class="col-md-12" >

                                <table class="table table-bordered table-hover" style="width:100%">
                                    <tr st>
                                        <td style="text-align: left; width:25%;"><b>Invoice No</b></td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:74%"><b><?php echo "BN/" . "$zyear" . "/$getdata[vouchno]"; ?></b></td>

                                    </tr>
                                    <tr>
                                        <td style="text-align: left; width:25%;"><b>Date</b></td>
                                        <td style="width:1%">:</td>
                                        <td style="text-align: left; width:74%"><b><?php echo "$getdata[vouchdt]"; ?></b></td>

                                    </tr>

                                </table>
                            </div>
                        </td>
                        <td style="text-align: center; width:50%;border:1px solid black">
                            <div style="border-collapse: collapse" class="col-md-12" >

                                <table class="table table-bordered table-hover" style="width:100%">
                                    <tr>
                                        <td style="text-align: left; width:35%;"><b>Team Member</b></td>
                                        <!--<td style="width:1%">:</td>-->
                                        <td style="text-align: left; width:65%"><?php echo "$showsalesm[name]"; ?></td>

                                    </tr>
                                    <?php
                                    if ($getdata['cashamt'] > 0) {
                                        $paytype = "Cash";
                                        If ($getdata['ccamt'] > 0) {
                                            $paytype = "$paytype" . "/CC";
                                        }

                                        If ($getdata['credamt'] > 0) {
                                            $paytype = "$paytype" . "/Credit";
                                        }
                                    } else {
                                        if ($getdata['ccamt'] > 0) {
                                            $paytype = "CC";

                                            If ($getdata['credamt'] > 0) {
                                                $paytype = "$paytype" . "/Credit";
                                            }
                                        } else {
                                            if ($getdata['credamt'] > 0) {
                                                $paytype = "Credit";
                                            }
                                        }
                                    }
                                    ?>
                                    <tr>
                                        <td style="text-align: left; width:24%;"><b>Paid By</b></td>
                                        <!--<td style="width:1%">:</td>-->
                                        <td style="text-align: left; width:90%"><h4 style="margin-top:0px;margin-bottom: 0px;"><?php echo $paytype ?></h4></td>

                                    </tr>

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

            $gcust = mysqli_query($conn, "SELECT * FROM `accmast` where accode = '$getdata[party]' ") or die(mysqli_error($conn));
            $cust = mysqli_fetch_array($gcust);
            ?>
            
                            <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>Invoice No</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>Address</b></td>
                                    <td style="width:1%">:</td>
                                    <td style="text-align: left; width:40%"><?php echo "$cust[add1]  $cust[add2]"; ?></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:10%">GST No.</td>
                                    <td style="width:1%">:</td>
                                    <td style="text-align: left; width:38%"><?php echo "$cust[gstno]"; ?></td>
                                    <td style="text-align: right ; width:27%">State</td>
                                    <td style="width:1%"></td>
                                    <td style="text-align: left; width:20%"><?php echo "$cust[state]"; ?></td>
                                </tr>
                                <tr>
                                    <td style="text-align: left; width:7%"><b>Mobile</b></td>
                                    <td style="width:1%">:</td>
                                    <td style="text-align: left; width:40%"><?php echo "$cust[mobile]"; ?></td>
                                    <td style="text-align: right ; width:30%">State Code</td>
                                    <td style="width:1%"></td>
                                    <td style="text-align: left; width:20%"><?php echo "$cust[statecode]"; ?></td>
                                </tr>
                                <tr>
                                    <td style="text-align: left; width:7%"><b>City</b></td>
                                    <td style="width:1%">:</td>
                                    <td style="text-align: left; width:40%"><?php echo "$cust[city]"; ?></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>
                <table  border="solid 1px" style="border-collapse: collapse; width:100%">
                    <tr>
                        <th style="width:3%; color:black;"><label>Sr.</label></th>
                        <th style="width:10%; color:black;"><label>Barcode</label></th>
                        <th style="width:30%; color:black;"><label>Item</label></th>
                        <th style="width:12%; color:black;"><label>Hsn Code</label></th>
                        <th style="width:10%; color:black; text-align: right;"><label>GST %</label></th>
                        <th style="width:10%; color:black; text-align: right;"><label>Qty.</label></th>
                        <th style="width:12%; color:black;"><label>Unit</label></th>
                        <!--<th style="width:10%; color:black; text-align: right;"><label>Mrp</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;
                    $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)) {
                        $getitem = mysqli_query($conn, "SELECT `name`,`code`,`nameprint`  From `item` WHERE `code` = $showtran[item] ")or die(mysqli_error($conn));
                        $showitem = mysqli_fetch_array($getitem);

                        $getuint = mysqli_query($conn, "SELECT `name`,`code`  From `unit` WHERE `code` = '$showtran[unit]' ")or die(mysqli_error($conn));
                        $showunit = mysqli_fetch_array($getuint);
                        $gstperc = $showtran['cgstrate'] * 2;
                        $gstamt = $showtran['cgstamt'] * 2;

                        $nameprint = $showitem["nameprint"];
                        $name = $showitem["name"];

                        if ($nameprint != '') {
                            $itemname = $nameprint;
                        } else {
                            $itemname = $name;
                        }


                        Echo"<tr style='height:24px'>";
                        Echo"<td style=''>$showtran[srno]</td>";
                        Echo"<td style=''>$showtran[item]</td>";
                        Echo"<td style=''>$itemname</td>";
                        Echo"<td style=''>$showtran[hsncode]</td>";
                        if ($oms == '') {
                            ?>
                            <td class="text-right bor" style=' text-align:right;'><? Echo $gstperc ?></td>
                        <?php } else { ?>
                            <td class="text-right bor" style=' text-align:right;'><? Echo $showtran['igstrate']; ?></td>
                            <?php
                        }
                        Echo"<td style='text-align: right;'>$showtran[qty]</td>";
                        Echo"<td style=''>$showtran[unit]</td>";
//                        Echo"<td style=' text-align:right;'>$showtran[mrp]</td>";
                        Echo"<td style=' text-align:right;'>$showtran[rate]</td>";
                        Echo"<td style=' text-align:right;'>$showtran[amount]</td>";
//                        Echo"<td style=' text-align:right;'>$showtran[discount]</td>";
//                        Echo"<td style=' text-align:right;'>$showtran[subtot]</td>";


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


                        Echo"</tr>";

                        $ctr++;
                        $ctab = $ctab + 1;
                    }
                    if ($ctab < 17) {
                        for ($i = $ctab; $i <= 17; $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>
                                <td class="border"></td>
                                <td class="border"></td>
        <!--                                <td class="border"></td>
                                <td class="border"></td>-->
                            </tr>      
                            <?php
                        }
                    }
                    ?>  

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

                    </tr>

                    <?php
                    if ($getdata['litemdisc'] > 0) {
                        ?> 
                        <tr>

                            <td colspan="7" 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="6" 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="6" 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="6" 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['couamt'] > 0) {
                        ?> 
                        <tr>
                            <td colspan="6" style="text-align: right; "class=" rnone">Add Courier <? Echo $getdata['coukg']; ?> /Kg.</td>
                            <td style="text-align: right; "class="lnone rnone"><? Echo $getdata['courate']; ?></td>
                            <td style="text-align: center;"class="lnone rnone ">Rate</td>
                            <td style="text-align: right; "class="lnone "><? Echo $getdata['couamt']; ?></td>
                        </tr>
                        <?php
                    }
                    if ($getdata['tottaxamt'] > 0) {
                        ?> 
                        <tr>
                            <td colspan="7" style="text-align: right;" class="rnone"> Taxable Value  </td>

                            <td style="text-align: right; " class="lnone rnone">   </td>
                            <!--<td class="lnone rnone"></td>-->
                            <td style="text-align: right;" class="lnone "> <? echo $getdata['tottaxamt']; ?>  </td>
                        </tr>
                        <?php
                    }
                    ?> 
                    <tr>
                        <td colspan="6">
                            <table  border="solid 1px" style="border-collapse: collapse; width:100%">
                                <tbody style="border-collapse: collapse;">

                                    <tr>

                                        <td style="width:25%;">Bank Name</td>
                                        <td style="width:75%;"><?= $getcmpname['bankname'] ?></td>
                                    </tr>

                                    <tr>

                                        <td style="width:25%;">A/c. Name</td>
                                        <td style="width:75%;"><?= $getcmpname['acname'] ?></td>
                                    </tr>
                                    <tr>

                                        <td style="width:25%;">Branch</td>
                                        <td style="width:75%;"><?= $getcmpname['branchname'] ?></td>
                                    </tr>
                                    <tr>

                                        <td style="width:25%;">Account No.</td>
                                        <td style="width:75%;"><?= $getcmpname['acno'] ?></td>
                                    </tr>
                                    <tr>

                                        <td style="width:25%;">IFSC Code</td>
                                        <td style="width:75%;"><?= $getcmpname['bankcode'] ?></td>
                                    </tr>
                                </tbody>
                            </table>
                        </td>
                        <td colspan="3" style="border:none;border-collapse: collapse; ">
                            <table  border="solid 1px" style="border-collapse: collapse; width:100%">
                                <tbody style="border-collapse: collapse;">

                                    <tr>

                                        <!--<td style="width:57px;">&nbsp;</td>-->
                                        <td style="width:32px;text-align: right">%</td>
                                        <td style="width:89px;text-align: right" >CGST</td>
                                        <td style="width:89px;text-align: right">SGST</td>
                                        <!--<td style="width:89px;text-align: right">IGST</td>-->
                                        <td style="width:99px;">&nbsp;</td>
                                    </tr>
                                    <?php
                                    Echo "<tr style='height: 21px'>";
//                                    Echo "<td class='text-right' style='text-align: right;'><b>&nbsp;</b></td>";
                                    Echo "<td class='text-right' style='text-align: right;'><b>5%</b></td>";
                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[cgst5]</td>";
                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[sgst5]</td>";
//                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[igst5]</td>";
                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[totgst5]</td>";
                                    Echo "</tr>";
                                    Echo "<tr style='height: 21px'>";
//                                    Echo "<td class='text-right'><b>&nbsp;</b></td>";
                                    Echo "<td class='text-right' style='text-align: right;'><b>12%</b></td>";
                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[cgst12]</td>";
                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[sgst12]</td>";
//                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[igst12]</td>";
                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[totgst12]</td>";
                                    Echo "</tr>";
                                    Echo "<tr style='height: 21px'>";
//                                    Echo "<td class='text-right'><b>&nbsp;</b></td>";
                                    Echo "<td class='text-right' style='text-align: right;'><b>18%</b></td>";
                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[cgst18]</td>";
                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[sgst18]</td>";
//                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[igst18]</td>";
                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[totgst18]</td>";
                                    Echo "</tr>";
                                    Echo "<tr style='height: 21px'>";
//                                    Echo "<td class='text-right'><b>&nbsp;</b></td>";
                                    Echo "<td class='text-right' style='text-align: right;'><b>28%</b></td>";
                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[cgst28]</td>";
                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[sgst28]</td>";
//                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[igst28]</td>";
                                    Echo "<td class='text-right' style='text-align: right;'>$getdata[totgst28]</td>";
                                    Echo "</tr>";
                                    ?>
                                </tbody>
                            </table>
                        </td>
                    </tr>





                    <?php
                    if ($getdata['netamt'] > 0) {
                        ?> 
                        <tr>
                            <td colspan="5" style="text-align:  " class=" rnone">GST No:<?php Echo $getcmpname['gst']; ?></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['netamt']; ?></b></td>
                        </tr>
                        <?php
                    }
                    ?>
                    <tr>
                        <td colspan="9">
                            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;">
                            <p style="font-size:10px"> I / We hereby certify that  my/our 
                                registration certificate under Rule 1 of GST invoice rules  
                                2017 is in force on which the sale of the goods specified in 
                                this  tax invoice is made by me/us  and that the transaction
                                of sale covered  by  this  tax invoice has been effected by 
                                me / us and it shall be accounted of in the turnover of sales
                                while filling of return and the due tax, if any,  payable  on 
                                the sale has been paid or shall be paid.</p>  
                                <!--<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: 75px; font-size: 10px">AUTHORISED SIGNATORY</div>
                        </td>
                    </tr>
                </table>
            </div>
        </div>    
        <!--</div>-->
    </div>
    <?php
    include("includes/linksfoot.php");
    ?>
    <script>
        $(function () {
            formGeneral();
        });
    </script>
</body>
</html>
