📁 File Manager
Editing:
/home/wedigitalindia/public_html/demo.wedigitalindia.com/dcl-erp/index.php
<?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>
Save
Cancel