File manager

AAAA
AAAA

Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): Failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home2/techcff9/techcadd.com/wp-acc.php on line 90
File manager

File manager - Edit - /home2/techcff9/techcadd.com/.git/objects/8f/94b53e8d3a8a44a49e9a8da8d175d34aa119cb

Back
x^��blob 3924�<?php include 'config.php'; // Include your database connection file // Check if user is logged in if (!isset($_SESSION['user_email'])) { header('Location: login.php'); exit; } // Fetch user info from session $user_email = $_SESSION['user_email']; $query = "SELECT id, name FROM users WHERE email = ?"; $stmt = $conn->prepare($query); $stmt->bind_param("s", $user_email); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { $user = $result->fetch_assoc(); $user_id = $user['id']; // Get user ID for leave filtering } else { // If no user found, log them out session_destroy(); header('Location: login.php'); exit; } // Get current month and year $currentMonth = date('m'); $currentYear = date('Y'); // Query to count leave requests by status and type for the logged-in user $query = " SELECT status, leave_type, COUNT(*) AS total FROM leave_requests WHERE user_id = ? AND MONTH(start_date) = ? AND YEAR(start_date) = ? GROUP BY status, leave_type"; $stmt = $conn->prepare($query); $stmt->bind_param("iii", $user_id, $currentMonth, $currentYear); $stmt->execute(); $result = $stmt->get_result(); // Initialize leave data structure $data = [ 'approved' => ['total' => 0, 'full_day' => 0, 'half_day' => 0, 'short_leave' => 0], 'rejected' => ['total' => 0, 'full_day' => 0, 'half_day' => 0, 'short_leave' => 0], 'pending' => ['total' => 0, 'full_day' => 0, 'half_day' => 0, 'short_leave' => 0], ]; // Populate leave data while ($row = $result->fetch_assoc()) { $status = strtolower($row['status']); $type = strtolower($row['leave_type']); $data[$status]['total'] += $row['total']; $data[$status][$type] += $row['total']; } $stmt->close(); ?> <div class="grid grid-cols-3 gap-4 mb-6"> <!-- Approved Leaves Card --> <div class="bg-green-100 text-green-800 p-4 rounded-lg shadow"> <h3 class="text-lg font-semibold">Approved Leaves</h3> <p class="text-3xl font-bold approved-leaves"><?= $data['approved']['total'] ?></p> <div class="mt-2"> <p class="text-sm">Full Day: <span class="approved-full-day"><?= $data['approved']['full_day'] ?></span></p> <p class="text-sm">Half Day: <span class="approved-half-day"><?= $data['approved']['half_day'] ?></span></p> <p class="text-sm">Short Leave: <span class="approved-short-leave"><?= $data['approved']['short_leave'] ?></span></p> </div> </div> <!-- Rejected Leaves Card --> <div class="bg-red-100 text-red-800 p-4 rounded-lg shadow"> <h3 class="text-lg font-semibold">Rejected Leaves</h3> <p class="text-3xl font-bold rejected-leaves"><?= $data['rejected']['total'] ?></p> <div class="mt-2"> <p class="text-sm">Full Day: <span class="rejected-full-day"><?= $data['rejected']['full_day'] ?></span></p> <p class="text-sm">Half Day: <span class="rejected-half-day"><?= $data['rejected']['half_day'] ?></span></p> <p class="text-sm">Short Leave: <span class="rejected-short-leave"><?= $data['rejected']['short_leave'] ?></span></p> </div> </div> <!-- Pending Leaves Card --> <div class="bg-yellow-100 text-yellow-800 p-4 rounded-lg shadow"> <h3 class="text-lg font-semibold">Pending Leaves</h3> <p class="text-3xl font-bold pending-leaves"><?= $data['pending']['total'] ?></p> <div class="mt-2"> <p class="text-sm">Full Day: <span class="pending-full-day"><?= $data['pending']['full_day'] ?></span></p> <p class="text-sm">Half Day: <span class="pending-half-day"><?= $data['pending']['half_day'] ?></span></p> <p class="text-sm">Short Leave: <span class="pending-short-leave"><?= $data['pending']['short_leave'] ?></span></p> </div> </div> </div> ��H