<?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);

$vouch = $_GET['vouchno'];

$cond = '';
$lcond = '';
//browse("work in progress");
$formname = "Debit Note";

$maindb = 'debrawmain';
$trandb = 'debrawtran';



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

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


    <?php
//        include("includes/files.php");
//        include("includes/tabsuf.php");
    ?>
    <style>
        @media print {
            .noprint {
                display: none;
            }
        }
        body {
            width: 100%;
            height: 100%;
            margin: 0;
            padding: 0;
            /*background-color: #FAFAFA;*/
            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;
            /*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">

    <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['name']; ?></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>
                <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);

                $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>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 "$cust[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 "$cust[add2] $cust[add3]"; ?></td>
                        <td style="text-align: right ; width:30%"></td>
                        <td style="width:1%"></td>
                        <td style="text-align: left; width:20%"></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%"></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: 1%' class='text-right'>Sr.</th>
                                        <th style='width: 20%'>Material</th>
                                        <th style='width: 7%'>Color</th>
                                        <th style='width: 4%' class=''>Lot</th>
                                        <th style='width: 4%' class='text-right'>Rolls</th>
                                        <th style='width: 5%' class='text-right'>Yard</th>
                                        <th style='width: 5%' class='text-right'>Qty.</th>
                                        <th style='width: 4%'>Unit</th>
                                        <th style='width: 5%' class='text-right'>Rate</th>
                                        <th style='width: 8%' class='text-right'>Amount</th>
                    </tr>

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

                          $findcolor = mysqli_query($conn, "SELECT `code`,`name` FROM `color` WHERE `code`='$tran[color]'") or die(mysqli_error($conn));
                          $fcolor = mysqli_fetch_array($findcolor);

                          $item = $fitem['name']; 
                          $color = $fcolor['name']; 
                        Echo"<tr>";
                        Echo"<td style=''>$tran[srno]</td>";
                        Echo"<td style=''>$item</td>";
                        Echo"<td style=''>$color</td>";
                        Echo"<td style=''>$tran[lot]</td>";
                        Echo"<td style='text-align:right;'>$tran[meters]</td>";
                        Echo"<td style='text-align:right;'>$tran[yard]</td>";
                        Echo"<td style='text-align:right;'>$tran[qty]</td>";
                        Echo"<td style=''>$tran[unit]</td>";
                        Echo"<td style=' text-align:right;'>$tran[rate]</td>";
                        Echo"<td style=' text-align:right;'>$tran[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>
                                <td class="border"></td>
                                <td class="border"></td>
                                <td class="border"></td>
                            </tr>      
                            <?php
                        }
                    }
                    ?>  

                    <tr style="">
                        <td></td>
                        <td></td>
                        <td></td>
                        <td style="text-align: right;"><b>Total</b></td>
                        <td style="text-align: right;"><b> <? echo $getdata['totmtrs']; ?> </b> </td>
                        <td style="text-align: right;"><b> <? echo $getdata['totyard']; ?> </b> </td>
                        <td style="text-align: right;"><b> <? echo $getdata['totqty']; ?> </b> </td>
                        <td></td>
                        <td></td>
                        <td style="text-align: right;"><b> <? echo $getdata['subtotal']; ?> </b> </td>

                    </tr>
                    <?php
                    
                    if ($getdata['lesother'] > 0) {
                        ?> 
                        <tr>
                            <td style="text-align: right;"class="lnone rnone" colspan="9"> Less Other  </td>
                            <td style="text-align: right; "class=""> <? Echo $getdata['lesother']; ?>  </td>
                        </tr>
                        <?php
                    }
                    if ($getdata['tottaxamt'] > 0) {
                        ?> 
                        <tr>
                            <td style="text-align: right;"class="lnone rnone" colspan="9">Taxable Value</td>
                            <td style="text-align: right; "class=""> <? Echo $getdata['tottaxamt']; ?>  </td>
                        </tr>
                        <?php
                    }
                    if ($getdata['roundoff'] > 0) {
                        ?> 
                        <tr>
                            <td style="text-align: right;"class="lnone rnone" colspan="9">Round Off</td>
                            <td style="text-align: right; "class=""> <? Echo $getdata['roundoff']; ?>  </td>
                        </tr>
                        <?php
                    }
                   
                    if ($getdata['totgst5'].$getdata['totgst12'].$getdata['totgst18'].$getdata['totgst28'] > 0) { 
                    ?>
                    <tr>
                        <td class="border"  colspan="6"></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>
                    <?
                    
                   
                    Echo "<tr>";
                    Echo "<td style='text-align:right' colspan='6'><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='6'><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='6'><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='6'><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['netamt'] > 0) {
                        ?> 
                    <tr>
                        <td class="" style="text-align: right;"colspan="9"><b>Total Amount</b></td>
                        <td style="text-align: right;" class=""><b><? Echo $getdata['netamt']; ?></b></td>
                    </tr>
                    <?php } ?>
                    <tr>
                        <td colspan="10">
                            Rupees 
                            <?php echo rsword(round($getdata['netamt'])); ?>
                        </td>
                    </tr>
                    <?php
                    if ($getdata['remark1'] != '') {
                        ?>
                    <tr>
                        <td colspan="10"><b>Remarks:</b> &nbsp;&nbsp;<? Echo $getdata['remark1']; ?> </td>
                    </tr>
                    <tr>
                        <td colspan="10" style="padding-left:90px"><? Echo $getdata['remark2']; ?> </td>
                    </tr>
                    <?php }?>
                </table>
            </div>

            <div>
                <table class="border">
                    <tr>
                        <td class="border" style="width: 500px; font-size: 14px;">
                            <!--<img src="images/taximg.png">-->
                        </td>
                        <td class="border" style="width: 257px">
                            <?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>-->
    </div>
    <?php
    include("includes/linksfoot.php");
    ?>
    <script>
        $(function () {
            formGeneral();
        });
    </script>
</body>
</html>
