<?php

//session_start();
include 'dbConnect.php';
function loginaction(){
    include 'dbConnect.php';
    $time = time();

    //$_SESSION['login']['user_type'] = $user[0]['operator_title'];
    //    $_SESSION['login']['token'] = $company[0]['token'];
    //    $_SESSION['login']['operator_token'] = $user[0]['auth_key'];
    //    $_SESSION['login']['operator_name'] = $user[0]['operator_name'];
    //    $_SESSION['login']['online_photo'] = $user[0]['online_avatar'];
    //    if(isset($user[0]['users'])){
    //    $_SESSION['login']['users'] = $user[0]['users'];
    //    } else if(!isset($user[0]['users'])) {
    //    $_SESSION['login']['users']='c';
    //    }
    //
    //    if($user[0]['users'] == 'a'){
    //    $_SESSION['administrace']='admin';
    //    } else if($user[0]['users'] == 'b') {
    //    $_SESSION['administrace']='lead';
    //    } else if($user[0]['users'] == 'c'){
    //    $_SESSION['administrace']='adv';
    //    } else if( is_null($user[0]['users'])){
    //    $_SESSION['administrace']='adv';
    //    }

        //setcookie("tmp_operator_id", $_SESSION['login']['operator_id'], time()+3600, "/");
        //setcookie("tmp_company_id", $_SESSION['login']['company_id'], time()+3600, "/");
        //setcookie("tmp_user_type", $_SESSION['login']['user_type'], time()+3600, "/");
        //setcookie("tmp_oper_token", $_SESSION['login']['operator_token'], time()+3600, "/");
        //setcookie("tmp_token", $_SESSION['login']['token'], time()+3600, "/");
        //setcookie("tmp_users", $user[0]['users'], time()+3600, "/");
        //setcookie("tmp_name", $user[0]['operator_name'], time()+3600, "/");
        //setcookie("tmp_online_photo", $user[0]['online_avatar'], time()+3600, "/");


    if(isset($_REQUEST['login'])){
    //if(isset($_GET['Key'])){
        //$myusername = $_GET['operator_id'];
        $key = $_REQUEST['telegram_key'];
        $username=$_REQUEST['user'];
        $password=$_REQUEST['pass'];


        $query = $db->prepare("SELECT operators.operator_id, telegramlog.telegram_key FROM
         telegramlog LEFT JOIN operators ON telegramlog.operator_id = operators.operator_id WHERE telegramlog.telegram_key = ? and key_time > ? ;");
        $query->execute(array($key,$time));
        $result = $query->fetchAll();

        $squery = $db->prepare("SELECT * FROM operators WHERE email = ? and heslo = ?;");
        $sResult = $squery->execute(array($username,$password));


        $json = json_decode($json);
        if($result){
            header('location: user.php');
        }
        elseif($sResult){
            while($row = $squery ->fetch(PDO::FETCH_ASSOC)){
                echo '<script type="text/javascript">alert("You are logged in as user '. $row['users'] . '")</script>';

               if($row['users']=="a"){
                    header('location: admin.php');
                }
                elseif($row['users']=="b"){
                    header('location: leader.php');
                }
                elseif($row['users']=="c"){
                    header('location: user.php');
                }
                else {
                    echo 'no result';
                }
            }
        }
        else{
            echo ' no result';
        }
    }
    else if($_SERVER['REQUEST_METHOD'] == 'POST'){
        echo "$randomString";
        if(isset($_GET['token'])) {

            if ($_GET['token'] == "yes") {


                $newtoken = generateRandomString();
                $time = (time()) + 61;
                $pquery= $db ->prepare ("UPDATE telegramlog SET telegram_key = ? and key_time = ?   WHERE telegram_key = ? ;");
                $presult = $pquery ->execute (array($newtoken, $time,$key));
            }
        }
    }
    function generateRandomString($length) {
        $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
        $charactersLength = strlen($characters);
        $randomString = '';

        for ($i = 0; $i < $length; $i++) {
            $randomString .= $characters[rand(0, $charactersLength - 1)];
        }
        return $randomString;
    }
    function verifytime($variable){



    }
}


loginaction();
?>