<?php

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



    if(isset($_REQUEST['login'])){
        $key = $_GET['telegram_key'];

        $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 = ?, key_time = ? ;");
        $query->execute(array($key,$time));
        $result = $query->fetchAll();

        if(isset($_REQUEST['error'])){
            $error= $_REQUEST['error'];
            echo errorDefine($err);
        }

        statements ($row,$sResult,$result,$time,$squery);

    }
    else if (isset($_REQUEST['loginnorm'])){
        $username=$_REQUEST['user'];
        $password=$_REQUEST['pass'];
        if(isset($_REQUEST['error'])){
            $error= $_REQUEST['error'];
            echo errorDefine($err);
        }

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


        statements($row,$sResult,$result,$time,$squery);
    }
    else if($_SERVER['REQUEST_METHOD'] == 'POST'){

        if(isset($_GET['token'])) {

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


                $newtoken = generateRandomString();
                $time = time() + (0 * 0 * 0 * 60);
                $pquery= $db ->prepare ("UPDATE telegramlog SET telegram_key = ? and key_time = ?  WHERE telegram_key = ? ;");
                $presult = $pquery ->execute (array($newtoken, $time,$key));
            }

        }
    }

    //external
    //$error = errorDefine(2);
   // echo $error;
    //funkce se string bude volaná na jiné stránce
    //if isset get error


}
function generateRandomString($length) {
    $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
    $charactersLength = strlen($characters);
    $randomString = '';

    for ($i = 0; $i < $length; $i++) {
        $randomString .= $characters[rand(0, $charactersLength - 1)];
    }
    return $randomString;
}
function errorDefine($err){
    if ($err=="1"){
        $deferr="Čas vypršel";
    }
    else if ($err=="2"){
        $deferr="Špatné příhlášení";
    }
    else if ($err=="3"){
        $deferr="Vyplňte všechna pole";
    }
    return $deferr;
}



function statements($row,$sResult,$result,$time,$squery){
    if($time > $row['key_time']){
        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{
            header("location: function.php?error=2");
        }
        }
    }
        else if ($time < $row['key_time']) {
            header("location: function.php?error=1");
        }
        if('empty'){
           header("location: function.php?error=3");
        }
}

loginaction();
?>