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

$formname = "Certificate Received";
$action = "certrecv_fr.php";

$admin = $_SESSION["admin_" . $dbname];
$zdb = $_SESSION["zdbyear_" . $dbname];


$pname = $_SESSION["name"];

$zyear = right($zdb, 4);
$mfrdate = getzdates($zyear, 'S');
$mtodate = getzdates($zyear, 'E');

$myyear = $_SESSION[$myyear];
mysqli_select_db($conn,$zdb);


include("includes/linkshead.php");
?>
<!--<script src="MyScript/certrecv.js" type="text/javascript"></script>-->

</head>
<body>
    <!--    <div id="preloader" class="col-lg-12 text-center">
            <h3 class="text-center">Loading</h3>
            <div id="status">&nbsp;</div>
        </div>-->
    <form action='<?= $action; ?>' method='POST'>
        <!-- Default box --> 
        <div class="row" id="data">
            <div class="col-lg-6">
                <div class="panel panel-default">
                    <div class="panel-heading">
                        <h3 class="panel-title"><?php Echo $formname; ?></h3>
                        <div class="actions pull-right">
                            <i class="fa fa-chevron-down"></i>
                            <i class="fa fa-times"></i>
                        </div>
                    </div>
                    <div class="panel-body">
                        <div class="row">
                            <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right pad">
                                <label class="label-control marg">Voucher</label>
                            </div>
                            <div class="col-lg-2 col-md-2 col-sm-2 col-xs-2 pad">
                                <select class='form-control vouchno' name='vouchno' style="width:297px;height:33px;" >
                                    <option value=""></option>
                                    <?php
//                                    $mown = mysqli_query($conn,"SELECT code, `user` FROM `passmain` WHERE `grpcode`='010' ORDER BY `name`") or die(mysqli_error($conn));
                                    $mown = mysqli_query($conn,"SELECT  `vouchno` FROM `visamain`  ORDER BY `vouchno`") or die(mysqli_error($conn));
                                    while ($trow = mysqli_fetch_array($mown)) {
                                        echo "<option value='$trow[vouchno]'>$trow[vouchno]</option>";
                                    }
                                    ?>
                                </select>
                            </div>
                        </div>
<!--                        <div class="row">
                            <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right pad">
                                <label class="label-control marg">Name</label>
                            </div>
                            <div class="col-lg-2 col-md-2 col-sm-2 col-xs-2 pad">
                                <select   class='form-control name' name='name' style="width:297px;height:33px;" >
                                    <option value=""></option>
                                    <?php
//                                    $mown = mysqli_query($conn,"SELECT code, `user` FROM `passmain` WHERE `grpcode`='010' ORDER BY `name`") or die(mysqli_error($conn));
                                    $mown1 = mysqli_query($conn,"SELECT `vouchno`, `name` FROM `visamain`  ORDER BY `name`") or die(mysqli_error($conn));
                                    while ($trow1 = mysqli_fetch_array($mown1)) {
                                        echo "<option value='$trow1[name]'>$trow1[name]</option>";
                                    }
                                    ?>
                                </select>
                            </div>
                        </div>-->
<!--                        <div class="row">
                            <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3 text-right pad">
                                <label class="label-control marg">Mobile</label>
                            </div>
                            <div class="col-lg-2 col-md-2 col-sm-2 col-xs-2 pad">
                                <select class='form-control mobile' name='mobile' style="width:297px;height:33px;" >
                                    <option value=""></option>
                                    <?php
//                                    $mown = mysqli_query($conn,"SELECT code, `user` FROM `passmain` WHERE `grpcode`='010' ORDER BY `name`") or die(mysqli_error($conn));
                                    $mown2 = mysqli_query($conn,"SELECT  `mobile` FROM `visamain` where mobile!=''  ORDER BY `mobile`") or die(mysqli_error($conn));
                                    while ($trow2 = mysqli_fetch_array($mown2)) {
                                        echo "<option value='$trow2[mobile]'>$trow2[mobile]</option>";
                                    }
                                    ?>
                                </select>
                            </div>
                        </div>-->

                    </div>
                    <div class="panel-footer">
                        <?php include("includes/but_rep.php"); ?>
                    </div>
                </div>
            </div>
        </div>
    </form>
 
    <?php include("includes/linksfoot.php"); ?>
</body>
</html>
