<?php include 'db.php';
session_start();


// Fetch current user
$user_id = $_SESSION['user_id'];
$query = "SELECT * FROM users WHERE id = ?";
$stmt = $conn->prepare($query);
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
?> 
<!DOCTYPE html><html lang="en"><head>
  <meta charset="utf-8"><title>Manual Attendance Entry</title>
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <script src="js/hyper-config.js"></script>
  <link href="css/vendor.min.css" rel="stylesheet">
  <link href="css/app.min.css" rel="stylesheet" id="app-style">
  <link href="css/unicons.css" rel="stylesheet">
  <link href="css/remixicon.css" rel="stylesheet">
  <link href="css/materialdesignicons.min.css" rel="stylesheet">
   <link rel="shortcut icon" href="uploads/logo.jpeg">
</head><body>
<?php include 'hr-sidebar.php'; include 'hr-nav.php'; ?>

<div class="content-page"><div class="content"><div class="container-fluid">
  <h4 class="page-title mt-3">Add Attendance</h4>
  <?php
    $errors=[]; $success='';
    if($_SERVER['REQUEST_METHOD']=='POST'){
      $emp=$_POST['employee_id']; $date=$_POST['date'];
      $in=$_POST['login_time']; $out=$_POST['logout_time'];
      if(!$emp||!$date){$errors[]="Select employee and date";}
      if(empty($errors)){
        $diff = strtotime($out) - strtotime($in);
        $hours = $diff>0 ? round($diff/3600,2) : 0;
        $stmt=$conn->prepare("INSERT INTO attendance(employee_id,date,login_time,logout_time,total_hours) VALUES(?,?,?,?,?)");
        $stmt->bind_param("isssd",$emp,$date,$in,$out,$hours);
        if($stmt->execute()) $success="Saved!";
        else $errors[]="DB error";
        $stmt->close();
      }
    }
  ?>

  <div class="card"><div class="card-body">
    <?php if($success):?><div class="alert alert-success"><?=$success?></div><?php endif?>
    <?php if($errors):?><div class="alert alert-danger"><ul><?php foreach($errors as $e):?><li><?=$e?></li><?php endforeach?></ul></div><?php endif?>

    <form method="POST">
      <div class="row">
        <div class="col-md-3 mb-2"><label>Date</label><input type="date" name="date" class="form-control" required></div>
        <div class="col-md-3 mb-2"><label>Employee</label>
          <select name="employee_id" class="form-control" required>
            <option value="">Select</option>
            <?php $u=$conn->query("SELECT id,name FROM users ORDER BY name");
            while($r=$u->fetch_assoc()): ?>
            <option value="<?=$r['id']?>"><?=htmlspecialchars($r['name'])?></option>
            <?php endwhile;?>
          </select>
        </div>
        <div class="col-md-3 mb-2"><label>Login Time</label><input type="time" name="login_time" class="form-control" required></div>
        <div class="col-md-3 mb-2"><label>Logout Time</label><input type="time" name="logout_time" class="form-control" required></div>
      </div>
      <button type="submit" class="btn btn-primary">Save Attendance</button>
      <a href="attendance-management.php" class="btn btn-secondary">Back</a>
    </form>
  </div></div>
</div></div></div>
<?php include('includes/theme.php') ?>

<script src="js/vendor.min.js"></script>
<script src="js/app.js"></script>
</body></html>
