<?php
session_start();
$dbtype = "root";
require("includes/dbconnect.php");
require("includes/config.php");
require("includes/function.php");

$zdir = $dbname;
$zcomp = 1;
$zdbroot = $zdir;
$focusfield = "user";
$zroot = $_SESSION["zdbroot"];
$zroot1 = substr($zroot, 0, -4);
if (isset($_POST["submit"])) {
    $udbf = $zdbroot . "usermain";

    $login = mysqli_query($conn, "SELECT * FROM `usermain` WHERE `username` = '" . mysqli_real_escape_string($conn, $_POST['user']) . "'
                         AND `password` = '" . mysqli_real_escape_string($conn, $_POST['pass']) . "'") or die(mysqli_error($conn));

//    $_SESSION["username_" . $dbname] = $login["user"];

    $_SESSION["zdbroot"] = $zdbroot;
    $_SESSION["zdir"] = $zdir;

    $_SESSION["zcompany"] = '';

    if (mysqli_num_rows($login) == 1) {

        $_SESSION['username_' . $dbname] = $_POST["user"];
        $_SESSION['logged-in'] = true;
        $getuser_dtl = mysqli_fetch_object($login);
        $admin = $getuser_dtl->admin;
        $usertype = $getuser_dtl->usertype;
        $_SESSION["admin_" . $dbname] = $admin;
        $_SESSION["usertype_" . $dbname] = $usertype;
        $_SESSION["zdbyear_$dbname"] = $dbyear;


        $year1 = mysqli_query($conn, "SELECT DATE_FORMAT(`startdate`, '%d-%m-%Y') as mfrdt, DATE_FORMAT(`lastdate`, '%d-%m-%Y') as mtodt,finyear FROM `compyear`") OR die(mysqli_error($conn));
        $cyear = mysqli_fetch_array($year1);
        $zsdate = $cyear['mfrdt'];
        $zedate = $cyear['mtodt'];
        $myr = $cyear['finyear'];

        $_SESSION["tit_" . $dbname] = $myr;
        $mdb = $_SESSION["zdbyear_" . $dbname];
        $_SESSION["zdbyear_" . $zsdate] = $zsdate;
        $_SESSION["zdbyear_" . $zedate] = $zedate;
        $_SESSION[$myyear] = $myr;
        $_SESSION["myyear_" . $dbname] = $myr;
//        browse($_SESSION["zdbyear_" . $dbname]);

        header("Location: comp.php");

//        header("Location: year.php");
    } else {

        print '<script type="text/javascript">';
        print 'alert("Invalid Login Credentials")';
        print '</script>';
    }
}
include("includes/linkshead.php");
?>
</head>

<body class="animated fadeIn">
    <section id="login-container">
        <div class="row text-center">

        </div>
        <div class="row">
            <div class="col-md-3" id="login-wrapper">
                <div class="panel panel-primary animated flipInY">
                    <div class="panel-heading">
                        <!--<h3 class="panel-title">-->     
                            <img src="images/LeoLogoNewBg.png" style="height:70px;width:100%">
                        <!--</h3>-->      
                    </div>
                    <div class="panel-body">
                        <p> Login to access your account.</p>
                        <form class="form-horizontal" action='' method="POST">
                            <div class="form-group">
                                <div class="col-md-12">
                                    <input type="text" class="form-control" id="email" placeholder="Username" name='user' autofocus>
                                    <i class="fa fa-user"></i>
                                </div>
                            </div>
                            <div class="form-group">
                                <div class="col-md-12">
                                    <input type="password" class="form-control" id="password" placeholder="Password" name='pass'>
                                    <i class="fa fa-lock"></i>
                                </div>
                            </div>
                            <div class="form-group">
                                <div class="col-md-12">
                                    <input type='submit' name='submit' value="SUBMIT" class="btn btn-primary btn-block" >
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>

    </section>
    <?php include("includes/linksfoot.php") ?>
</body>
</html>