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/21/c32637e6ce6db507f15d3e58b8845e69c1382d

Back
x��blob 5897�<?php session_start(); 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 all members and their task statuses based on assignments in `task_assignees` $query = " SELECT u.id AS user_id, u.name AS username, u.email, SUM(CASE WHEN t.status = 'Pending' THEN 1 ELSE 0 END) AS pending_tasks, SUM(CASE WHEN t.status = 'In Progress' THEN 1 ELSE 0 END) AS in_progress_tasks, SUM(CASE WHEN t.status = 'Complete' THEN 1 ELSE 0 END) AS complete_tasks FROM users u LEFT JOIN task_assignees ta ON u.id = ta.user_id LEFT JOIN tasks t ON ta.task_id = t.id GROUP BY u.id ORDER BY u.name ASC "; $result = $conn->query($query); // Fetch results as an associative array $members = []; if ($result) { while ($row = $result->fetch_assoc()) { $members[] = $row; } } $conn->close(); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Member View</title> <link href="https://cdn.jsdelivr.net/npm/tailwindcss@2.2.19/dist/tailwind.min.css" rel="stylesheet"> </head> <body class="bg-gray-100"> <div class="flex h-screen"> <!-- Include Sidenav --> <?php include 'sidenav.php'; ?> <!-- Main Content Area --> <div class="flex-1 flex flex-col"> <!-- Include Header --> <?php include 'header.php'; ?> <!-- Dashboard Content --> <main class="flex-1 p-6 bg-gray-100"> <div class="flex justify-between items-center mb-4"> <h2 class="text-2xl font-semibold">Member Task Overview</h2> <div> <a href="download_task_data.php" class="bg-blue-500 text-white px-4 py-2 rounded-md mr-2 hover:bg-blue-600">Download Task Data</a> <a href="download_member_data.php" class="bg-green-500 text-white px-4 py-2 rounded-md hover:bg-green-600">Download Member Data</a> </div> </div> <div class="bg-white shadow-md rounded-lg overflow-hidden"> <table class="min-w-full leading-normal"> <thead> <tr> <th class="px-5 py-3 border-b border-gray-200 bg-gray-50 text-left text-sm uppercase font-semibold text-gray-600">S.No</th> <th class="px-5 py-3 border-b border-gray-200 bg-gray-50 text-left text-sm uppercase font-semibold text-gray-600">Username</th> <th class="px-5 py-3 border-b border-gray-200 bg-gray-50 text-left text-sm uppercase font-semibold text-gray-600">Email</th> <th class="px-5 py-3 border-b border-gray-200 bg-gray-50 text-left text-sm uppercase font-semibold text-gray-600">Pending Tasks</th> <th class="px-5 py-3 border-b border-gray-200 bg-gray-50 text-left text-sm uppercase font-semibold text-gray-600">In Progress Tasks</th> <th class="px-5 py-3 border-b border-gray-200 bg-gray-50 text-left text-sm uppercase font-semibold text-gray-600">Complete Tasks</th> <th class="px-5 py-3 border-b border-gray-200 bg-gray-50 text-left text-sm uppercase font-semibold text-gray-600">Total Tasks</th> </tr> </thead> <tbody id="memberTable"> <?php if (!empty($members)): ?> <?php $sno = 1; // Initialize serial number counter ?> <?php foreach ($members as $member): ?> <?php // Calculate total tasks $total_tasks = ($member['pending_tasks'] ?? 0) + ($member['in_progress_tasks'] ?? 0) + ($member['complete_tasks'] ?? 0); ?> <tr> <td class="px-5 py-5 border-b border-gray-200 bg-white text-sm"> <p class="text-gray-900 whitespace-no-wrap"><?php echo $sno++; ?></p> </td> <td class="px-5 py-5 border-b border-gray-200 bg-white text-sm"> <p class="text-gray-900 whitespace-no-wrap"><?php echo htmlspecialchars($member['username']); ?></p> </td> <td class="px-5 py-5 border-b border-gray-200 bg-white text-sm"> <p class="text-gray-900 whitespace-no-wrap"><?php echo htmlspecialchars($member['email']); ?></p> </td> <td class="px-5 py-5 border-b border-gray-200 bg-white text-sm"> <p class="text-gray-900 whitespace-no-wrap"><?php echo $member['pending_tasks'] ?? 0; ?></p> </td> <td class="px-5 py-5 border-b border-gray-200 bg-white text-sm"> <p class="text-gray-900 whitespace-no-wrap"><?php echo $member['in_progress_tasks'] ?? 0; ?></p> </td> <td class="px-5 py-5 border-b border-gray-200 bg-white text-sm"> <p class="text-gray-900 whitespace-no-wrap"><?php echo $member['complete_tasks'] ?? 0; ?></p> </td> <td class="px-5 py-5 border-b border-gray-200 bg-white text-sm"> <p class="text-gray-900 whitespace-no-wrap"><?php echo $total_tasks; ?></p> </td> </tr> <?php endforeach; ?> <?php else: ?> <tr> <td colspan="7" class="px-5 py-5 border-b border-gray-200 bg-white text-sm text-center"> <p class="text-gray-500">No members found.</p> </td> </tr> <?php endif; ?> </tbody> </table> </div> </main> </div> </div> </body> </html>��V