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

$formname = 'Expense Entry  Receipt';
$maindb = 'expentry_pe';
$file = 'expheadentry_print.php';
$source = "CR";
$zdb = $_SESSION["zdbyear_" . $dbname];
// mysqli_select_db($conn, $zdb);
$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);
?>

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


</head>
<style>
    body {
        width: 100%;
        height: 100%;
        margin: 0;
        padding: 0;
        font: 12pt "Tahoma";
    }

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

    .page {
        width: 195mm;
        min-height: 100mm;
        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: 240mm;
        }

        .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="col-md-12">
                <?php
                require("includes/dbconnect.php");
                $comp = mysqli_query($conn, "SELECT * FROM `company`") or die(mysqli_error($conn));
                $zcomp = mysqli_fetch_assoc($comp);
                ?>
                <b>
                    <center><?php echo $zcomp['compname']; ?></center>
                </b>
                <h5>
                    <center><?php echo $formname; ?></center>
                </h5>
            </div>

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

            $getexp = mysqli_query($conn, "SELECT `name` FROM `accmast_pe` WHERE `accode`='$getmdata[expense]'") or die(mysqli_error($conn));
            $fetexp = mysqli_fetch_array($getexp);
            $expense = $fetexp['name'];
            ?>

            <table width="100%">
                <tr style="height:40px">
                    <td style="text-align: left;">
                        <b>Date:</b>
                        <?php echo "$getmdata[vouchdt]"; ?>
                    </td>
                    <td style="text-align: center;">
                        <b>Time:</b>
                        <?php echo date("g:i A",strtotime($getmdata['time'])); ?>
                    </td>
                </tr>

                <tr style="height:40px">
                    <td colspan="2"><b>Expense :</b>
                        <?php echo "$expense"; ?>
                    </td>
                </tr>


                <tr style="height:40px">
                    <td colspan="2"><b>Amount : </b><? echo "Rs. $getmdata[amount]"; ?>
                        (<?php echo rsword(round($getmdata["amount"])); ?>)
                    </td>
                </tr>

                <?php
                if ($getmdata['paidby'] == "C") {
                    $ptyped = "CASH";
                } else if ($getmdata['paidby'] == "R") {
                    $ptyped = "CREDIT";
                } else if ($getmdata['paidby'] == "U") {
                    $ptyped = "UPI";
                }
                ?>

                <tr style="height:40px">
                    <td colspan="2"><b>Paidby : </b><?= "$ptyped"; ?>
                    </td>
                </tr>

                <tr style="height:40px">
                    <td colspan="2"><b>Payee : </b><?= "$getmdata[payee]"; ?>
                    </td>
                </tr>

                <tr style="height:40px">
                    <td colspan="2"><b>Remark : </b><?= "$getmdata[remark]"; ?>
                    </td>
                </tr>

                <tr style="height:40px">
                    <td>
                        <div></div>
                        </br>
                        </br>
                        </br>
                        </br>
                    </td>
                </tr>

                <!-- <tr>
                     <td style="text-align: left; width:50%;">
                     <hr   align="left" style="border: 1px solid black; width:50%"/>
                            <b>Authorised Signatory</b>
                       </td>
                       <td style="text-align: center; width:50%;">
                        <hr style="border: 1px solid black; width:70%"/>
                            <b>Received By/Account Holder</b>
                         </td>
                    </tr>   -->
            </table>
            </table>
        </div>
    </div>
    <?php
    include("includes/linksfoot.php");
    ?>
    <script>
        $(function() {
            formGeneral();
        });
    </script>
</body>

</html>