<?php
// ini_set('display_errors', '1');
// ini_set('display_startup_errors', '1');
// error_reporting(E_ALL);

session_start();

if (isset($_SESSION["loggedin"]) && $_SESSION["loggedin"] === true) {
    header("location: dashboard.php");
    exit;
}

require_once "config.php";
function team($id,$conn){
    $teamarr=array();
    
    $sql_employee_junior = "SELECT employee_id, email, password FROM employees WHERE reporting_to in ($id)";
    $result = mysqli_query($conn, $sql_employee_junior);
    //print_r($result);
    if (mysqli_num_rows($result) > 0) {
        while ($row = mysqli_fetch_assoc($result)) {
            $tID=$row['employee_id'];
            $teamarr[]=$tID;
            $trr=  implode(",",$teamarr);
        }
        team($trr,$conn);
    }

    
    // $trr=  implode(",",$teamarr);
    // exit;
    
    return $trr;
}
$username = $password = "";
$username_err = $password_err = $max_attempt_err = "";
$branch_options = [];

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    if (empty(trim($_POST["username"]))) {
        $username_err = "Please enter username.";
    } else {
        $username = trim($_POST["username"]);
    }

    if (empty(trim($_POST["password"]))) {
        $password_err = "Please enter your password.";
    } else {
        $password = trim($_POST["password"]);
    }

    if (empty($username_err) && empty($password_err)) {
        $sql = "SELECT id, username, password, login_attempts, is_locked FROM users WHERE username = ?";
        if ($stmt = mysqli_prepare($conn, $sql)) {
            mysqli_stmt_bind_param($stmt, "s", $param_username);
            $param_username = $username;

            if (mysqli_stmt_execute($stmt)) {
                mysqli_stmt_store_result($stmt);
                if (mysqli_stmt_num_rows($stmt) == 1) {
                    mysqli_stmt_bind_result($stmt, $id, $username, $hashed_password, $login_attempts, $is_locked);

                    if (mysqli_stmt_fetch($stmt)) {
                        if ($is_locked) {
                            $max_attempt_err = "Your account has been locked due to multiple failed login attempts.";
                        } elseif (password_verify($password, $hashed_password)) {
                            session_start();
                            
                            $_SESSION["loggedin"] = true;
                            $_SESSION["id"] = $id;
                            $_SESSION["username"] = $username;
                            $_SESSION["userType"] = 'Admin';

                            $ip_address = $_SERVER['REMOTE_ADDR'];
                            $update_sql = "UPDATE users SET last_login_ip = ?, last_login_time = NOW(), login_attempts = 0 WHERE id = ?";
                            if ($update_stmt = mysqli_prepare($conn, $update_sql)) {
                                mysqli_stmt_bind_param($update_stmt, "si", $ip_address, $id);
                                mysqli_stmt_execute($update_stmt);
                                mysqli_stmt_close($update_stmt);
                            }

                            header("location: dashboard.php");
                            exit;
                        } else {
                            $password_err = "The password you entered was not valid.";
                            $update_attempts_sql = "UPDATE users SET login_attempts = login_attempts + 1 WHERE id = ?";
                            if ($update_stmt = mysqli_prepare($conn, $update_attempts_sql)) {
                                mysqli_stmt_bind_param($update_stmt, "i", $id);
                                mysqli_stmt_execute($update_stmt);
                                mysqli_stmt_close($update_stmt);
                            }

                            if ($login_attempts + 1 >= 5) {
                                $lock_account_sql = "UPDATE users SET is_locked = TRUE WHERE id = ?";
                                if ($lock_stmt = mysqli_prepare($conn, $lock_account_sql)) {
                                    mysqli_stmt_bind_param($lock_stmt, "i", $id);
                                    mysqli_stmt_execute($lock_stmt);
                                    mysqli_stmt_close($lock_stmt);
                                }
                                $max_attempt_err = "Your account has been locked due to multiple failed login attempts.";
                            }
                        }
                    }
                } else {
                    $sql_employee = "SELECT employee_id, email, password FROM employees WHERE email = ?";
                    if ($stmt_employee = mysqli_prepare($conn, $sql_employee)) {
                        mysqli_stmt_bind_param($stmt_employee, "s", $param_email);
                        $param_email = $username;

                        if (mysqli_stmt_execute($stmt_employee)) {
                            mysqli_stmt_store_result($stmt_employee);
                            if (mysqli_stmt_num_rows($stmt_employee) == 1) {
                                mysqli_stmt_bind_result($stmt_employee, $employee_id, $email, $hashed_password);

                                if (mysqli_stmt_fetch($stmt_employee)) {
                                    if (password_verify($password, $hashed_password)) {
                                        $teamarr=array($employee_id);
                                       $tid= implode(",",$teamarr);
                                       // $tid;
                                        $tr=team($tid,$conn);
                                        //  echo 'hhh'. $tr;exit;
                                        $_SESSION["loggedin"] = true;
                                        $_SESSION["employee_id"] = $employee_id;
                                        $_SESSION["email"] = $email;
                                        $_SESSION["userType"] = 'Employee';
                                        $_SESSION["team_members"] = $tr;


                                        $branch_sql = "SELECT branch_id, branch_name FROM branches WHERE FIND_IN_SET(branch_id, (SELECT branch_id FROM employees WHERE employee_id = ?))";
                                        if ($branch_stmt = mysqli_prepare($conn, $branch_sql)) {
                                            mysqli_stmt_bind_param($branch_stmt, "i", $employee_id);
                                            mysqli_stmt_execute($branch_stmt);
                                        
                                            mysqli_stmt_bind_result($branch_stmt, $branch_id, $branch_name);
                                        
                                            $branch_options = [];
                                            while (mysqli_stmt_fetch($branch_stmt)) {
                                                $branch_options[] = [
                                                    'branch_id' => $branch_id,
                                                    'branch_name' => $branch_name
                                                ];
                                            }
                                        
                                            mysqli_stmt_close($branch_stmt);
                                        }
                                        
                                        if (count($branch_options) > 1) {
                                            header("Location: branch_selection.php");
                                        } else {
                                            header("Location: dashboard.php");
                                        }
                                        exit;
                                    } else {
                                        $password_err = "The password you entered was not valid.";
                                    }
                                }
                            } else {
                                $username_err = "No account found with that username.";
                            }
                        }
                        mysqli_stmt_close($stmt_employee);
                    }
                }
            } else {
                echo "Oops! Something went wrong. Please try again later.";
            }
            mysqli_stmt_close($stmt);
        }
    }
}
?>
<!DOCTYPE html>
<html>
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<head>
  <title>DCL</title>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  
  <!-- CSRF Token -->
  <meta name="_token" content="hjNpe8ZTnCKGglKMW9sw81G1NiWyGTLydjvmiHIS">
  
  <link rel="shortcut icon" href="../favicon.ico">

  <!-- plugin css -->
  <link media="all" type="text/css" rel="stylesheet" href="assets/plugins/%40mdi/font/css/materialdesignicons.min.css">
  <link media="all" type="text/css" rel="stylesheet" href="assets/plugins/perfect-scrollbar/perfect-scrollbar.css">
  <!-- end plugin css -->

  <!-- plugin css -->
    <!-- end plugin css -->

  <!-- common css -->
  <link media="all" type="text/css" rel="stylesheet" href="css/app.css">
  <!-- end common css -->

  </head>
<body data-base-url="https://demo.bootstrapdash.com/justdo-laravel-pro/template/vertical-compact">

  <div class="container-scroller" id="app">
    <div class="container-fluid page-body-wrapper full-page-wrapper">
      
        <div class="content-wrapper d-flex align-items-center auth">
          <div class="row flex-grow">
            <div class="col-lg-4 mx-auto">
              <div class="auth-form-light text-left p-5">
                <div class="brand-logo">
                  <img src="assets/images/logo.webp" class="w-100">
                </div>
                <h4>Hello! let's get started</h4>
                <!--<a href="employee-login.php" class="font-weight-light">Employee Login</a>-->
                <form class="pt-3" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">
                    <div class="form-group">
                        <input type="text" class="form-control form-control-lg" name="username" id="username" placeholder="Username" value="<?php echo $username; ?>">
                        <span class="text-danger pt-2"><?php echo $username_err; ?></span>
                    </div>
                    <div class="form-group">
                        <input type="password" class="form-control form-control-lg" name="password" id="password" placeholder="Password">
                        <span class="text-danger pt-2"><?php echo $password_err; ?></span>
                    </div>
                    <div class="mt-3">
                        <input class="btn btn-block btn-primary btn-lg font-weight-medium auth-form-btn" type="submit" value="Login">
                    </div>
                    <span class="text-danger pt-2"><?php echo $max_attempt_err; ?></span>
                </form>
              </div>
            </div>
          </div>
        </div>

    </div>
  </div>

    <!-- base js -->
    <script src="js/app.js"></script>

    </body>

</html>
