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

$formname = 'Bank Receipt';
$maindb = 'bankrecp';
$file = 'bankrecp_fr.php';
$source = "BR";

$zcomp = $_SESSION["comp_" . $dbname];

$zdb = $_SESSION["zdbyear_" . $dbname];
mysqli_select_db($conn, $zdb);

//$zdb1 = 'cepheisy_sis_zyc_1_1516';
$mht = 'height:20px;';

$admin = $_SESSION["admin_" . $dbname];
$vouchno = $_REQUEST["vouchno"];
$mainqry = mysqli_query($conn, "SELECT *, DATE_FORMAT(`vouchdt`, '%d-%m-%Y') AS vouchdt FROM `$maindb` WHERE vouchno='$vouchno'") or die(mysqli_error($conn));
$getmdata = mysqli_fetch_array($mainqry) or die(mysqli_error($conn));
$cmpname = mysqli_query($conn, "SELECT * From $zroot.`company` where `code`='$zcomp'")or die(mysqli_error($conn));
$getcmpname = mysqli_fetch_array($cmpname);
?>


<html lang="en-US">

</head>
<style>
    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: 140mm;
        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;
        }
    }
    .border{
        border: 1px solid;
    }
</style>

<body id="main_container">
    <div class="book">
        <div class="page">
            <!--<div class="subpage">-->
            <!--   ************Header************  -->
            <div class="col-md-12" >
                <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>
            <hr style="border-top: dotted 1px;" />
            <!--<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`=$getmdata[party]") or die(mysqli_error($conn));
            $cust = mysqli_fetch_array($gcust);
            ?>
            <table width="100%">
                <tr>

                    <td style="text-align: left;">
                        Receipt.No:
                        <b><?php echo "$getmdata[vouchno]"; ?> 
                    </td>
                    <td style="text-align: center;">
                        Date: 
                        <b><?php echo "$getmdata[vouchdt]"; ?> 
                    </td>                                
                </tr>
                <br>
                <!--                        </table><br>
                                        <table width="100%">-->
                <tr>

                    <td style="text-align: left;">
                        Received thanks from  <b><?php echo "$cust[name]"; ?>
                    </td>
                </tr>                       
            </table>
            <table width="100%">

                <tr>                      
                    <td style="text-align: left;">
                        <br>The Sum of <b><?php echo "Rs.$getmdata[amount]"; ?>
                            <b>(<?php echo rsword(round($getmdata["amount"])); ?>)
                                </td>
                                </tr> 
                                </table>
                                <table width="100%">

                                    <tr>                      
                                        <td style="text-align: left;">
                                            <br>Paid by cheque... <b><?php echo "$getmdata[chqno]"; ?> 
                                        </td>
                                        <td style="text-align: left;">
                                            <br>Date <b><?php echo "$getmdata[chqdate]"; ?>

                                        </td>                                
                                    </tr>
                                    <tr>                      
                                        <td style="text-align: left;">
                                            <b><?php echo "$getmdata[narration]"; ?> 
                                        </td>
                                    </tr>
                                    <tr>                      
                                        <td style="text-align: left;">
                                            <br>Cheque subject to realisation.                                    
                                        </td>
                                    </tr>
                                    <tr style="height:40px">
                                        <td>
                                            <div></div>
                                            </br>
                                            </br>
                                            </br>
                                            </br>

                                        </td>
                                    </tr>

                                    <tr>
                                        <td style="text-align: left; width:50%;">
                                            <!--                      <div style="width:0px;height:0px;"></div>       -->

                                            <hr   align="left" style="border: 1px solid black; width:50%"/>
                                            <b>Authorised Signatory</b>
                                        </td>
                                        <td style="text-align: center; width:50%;">
                                            <!--                        <div style="width:150px;height:150px;border:1px solid #000;"></div>    -->
                                            <hr style="border: 1px solid black; width:70%"/>
                                            <b>Received By/Account Holder</b>
                                        </td>
                                    </tr>                    
                                </table>
                                <!--<div>-->

                                </table>
                                </div>        


                                </div>
                                <hr style="border-top: dotted 1px;" />

                                <!--<div>-->




                                <!--</div>-->

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