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/af/b9d9097670668bb8d3cbb4e63aaf1299192bf3

Back
x�C?�blob 17333�<?php session_start(); include 'config.php'; // Include your database connection // Check if user is logged in if (!isset($_SESSION['user_email'])) { header('Location: login.php'); exit; } // Fetch the logged-in user's role and email $user_email = $_SESSION['user_email']; $user_query = $conn->prepare("SELECT role, name FROM users WHERE email = ?"); $user_query->bind_param("s", $user_email); $user_query->execute(); $user_query->bind_result($user_role, $user_name); $user_query->fetch(); $user_query->close(); // Get status filter from URL parameters (default to "All") $status_filter = isset($_GET['status']) ? $_GET['status'] : 'All'; $status_filter_sql = ($status_filter === 'All') ? '%' : $status_filter; // Get the selected "Assigned To" filter from URL parameters $selected_member = isset($_GET['member']) ? $_GET['member'] : ''; $selected_member_sql = ($selected_member === '') ? '%' : $selected_member; // Get the selected "Assigned By" filter from URL parameters $selected_assigner = isset($_GET['assigner']) ? $_GET['assigner'] : ''; $selected_assigner_sql = ($selected_assigner === '') ? '%' : $selected_assigner; // Get the selected "Created At" filter from URL parameters $created_at_filter = isset($_GET['created_at']) ? $_GET['created_at'] : ''; $created_at_filter_sql = ($created_at_filter === '') ? '%' : $created_at_filter; // Fetch all members for the "Assigned To" filter dropdown $members_query = "SELECT name FROM users"; $members_result = $conn->query($members_query); $members = []; if ($members_result->num_rows > 0) { while ($row = $members_result->fetch_assoc()) { $members[] = $row['name']; } } // Fetch all users who are Admin or Manager for the "Assigned By" filter dropdown $assigners_query = "SELECT name FROM users WHERE role IN ('Admin', 'Manager')"; $assigners_result = $conn->query($assigners_query); $assigners = []; if ($assigners_result->num_rows > 0) { while ($row = $assigners_result->fetch_assoc()) { $assigners[] = $row['name']; } } // Modify the query based on role if ($user_role === 'Admin') { // Admin can see all tasks, filtered by "Assigned By", "Assigned To", and "Created At" $query = " SELECT t.name AS task_name, t.description, t.project_list, t.due_date, t.created_by, t.created_at, t.status, t.task_priority, t.task_category, t.reminder_time, t.location, t.task_link, t.file_path, GROUP_CONCAT(u.name SEPARATOR ', ') AS assigned_to FROM tasks t LEFT JOIN task_assignees ta ON t.id = ta.task_id LEFT JOIN users u ON ta.user_id = u.id WHERE t.status LIKE ? AND t.created_by LIKE ? AND (u.name LIKE ? OR ? = '%') AND DATE(t.created_at) LIKE ? GROUP BY t.id "; $stmt = $conn->prepare($query); $stmt->bind_param("sssss", $status_filter_sql, $selected_assigner_sql, $selected_member_sql, $selected_member_sql, $created_at_filter_sql); } else if ($user_role === 'Manager') { // Manager can only see tasks they created, with filters for "Assigned By", "Assigned To", and "Created At" $query = " SELECT t.name AS task_name, t.description, t.project_list, t.due_date, t.created_by, t.created_at, t.status, t.task_priority, t.task_category, t.reminder_time, t.location, t.task_link, t.file_path, GROUP_CONCAT(u.name SEPARATOR ', ') AS assigned_to FROM tasks t LEFT JOIN task_assignees ta ON t.id = ta.task_id LEFT JOIN users u ON ta.user_id = u.id WHERE t.status LIKE ? AND t.created_by = ? AND (u.name LIKE ? OR ? = '%') AND DATE(t.created_at) LIKE ? GROUP BY t.id "; $stmt = $conn->prepare($query); $stmt->bind_param("sssss", $status_filter_sql, $user_name, $selected_member_sql, $selected_member_sql, $created_at_filter_sql); } $stmt->execute(); $result = $stmt->get_result(); $tasks = []; if ($result->num_rows > 0) { // Fetch all tasks and their assigned users while ($row = $result->fetch_assoc()) { $file_paths = !empty($row['file_path']) ? json_decode($row['file_path'], true) : []; // Decode JSON $tasks[] = [ 'task_name' => $row['task_name'] ?? '', 'description' => $row['description'] ?? '', 'project_list' => $row['project_list'] ?? '', 'due_date' => $row['due_date'] ?? 'No due date', 'created_by' => $row['created_by'] ?? '', 'created_at' => $row['created_at'] ?? '', 'assigned_to' => $row['assigned_to'] ?? 'No users assigned', 'status' => $row['status'] ?? 'No status', 'task_priority' => $row['task_priority'] ?? 'Medium', 'task_category' => $row['task_category'] ?? '', 'reminder_time' => $row['reminder_time'] ?? '', 'location' => $row['location'] ?? '', 'task_link' => $row['task_link'] ?? '', 'file_paths' => $file_paths, // Store decoded file paths array ]; } } $stmt->close(); $conn->close(); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="icon" href="favicon.ico" type="image/x-icon"> <title>All Tasks - Techcadd </title> <link href="https://cdn.jsdelivr.net/npm/tailwindcss@2.2.19/dist/tailwind.min.css" rel="stylesheet"> <style> .nav-tab { padding: 10px 20px; font-weight: 600; cursor: pointer; transition: color 0.3s; } .nav-tab-active { color: #2563eb; border-bottom: 2px solid #2563eb; } .nav-tab-inactive { color: #6b7280; border-bottom: 2px solid transparent; } .nav-tab:hover { color: #2563eb; } </style> </head> <body class="bg-gray-100"> <div class="flex min-h-full"> <!-- Include Sidebar --> <?php include 'sidenav.php'; ?> <div class="flex-1 flex flex-col"> <!-- Include Header --> <?php include 'header.php'; ?> <!-- Main Content Area --> <main class="flex-1 p-6 bg-gray-100"> <div class="container mx-auto"> <div class="bg-white p-6 rounded-lg shadow-lg"> <h2 class="text-2xl font-semibold mb-4 text-gray-700">All Tasks</h2> <!-- Navigation Tabs for Task Status --> <nav class="flex space-x-4 mb-6"> <a href="?status=All<?php echo isset($_GET['member']) ? '&member=' . urlencode($_GET['member']) : ''; ?>" class="nav-tab <?php echo ($status_filter === 'All') ? 'nav-tab-active' : 'nav-tab-inactive'; ?>">All</a> <a href="?status=In Progress<?php echo isset($_GET['member']) ? '&member=' . urlencode($_GET['member']) : ''; ?>" class="nav-tab <?php echo ($status_filter === 'In Progress') ? 'nav-tab-active' : 'nav-tab-inactive'; ?>">In Progress</a> <a href="?status=Complete<?php echo isset($_GET['member']) ? '&member=' . urlencode($_GET['member']) : ''; ?>" class="nav-tab <?php echo ($status_filter === 'Complete') ? 'nav-tab-active' : 'nav-tab-inactive'; ?>">Complete</a> <a href="?status=Pending<?php echo isset($_GET['member']) ? '&member=' . urlencode($_GET['member']) : ''; ?>" class="nav-tab <?php echo ($status_filter === 'Pending') ? 'nav-tab-active' : 'nav-tab-inactive'; ?>">Pending</a> </nav> <!-- Member Filter Dropdown --> <form method="GET" class="mb-6"> <label for="assigner" class="m-3">Filter by Assigned By:</label> <select name="assigner" id="assigner" onchange="this.form.submit()" class="border border-gray-300 rounded p-2"> <option value="">All Assigners</option> <?php foreach ($assigners as $assigner): ?> <option value="<?php echo htmlspecialchars($assigner); ?>" <?php echo (isset($_GET['assigner']) && $_GET['assigner'] === $assigner) ? 'selected' : ''; ?>> <?php echo htmlspecialchars($assigner); ?> </option> <?php endforeach; ?> </select> <label for="member" class="m-3">Filter by Assigned To:</label> <select name="member" id="member" onchange="this.form.submit()" class="border border-gray-300 rounded p-2"> <option value="">All Members</option> <?php foreach ($members as $member): ?> <option value="<?php echo htmlspecialchars($member); ?>" <?php echo (isset($_GET['member']) && $_GET['member'] === $member) ? 'selected' : ''; ?>> <?php echo htmlspecialchars($member); ?> </option> <?php endforeach; ?> </select> <label for="created_at" class="m-3">Filter by Created At:</label> <input type="date" name="created_at" id="created_at" class="border border-gray-300 rounded p-2" value="<?php echo isset($_GET['created_at']) ? htmlspecialchars($_GET['created_at']) : ''; ?>" onchange="this.form.submit()" /> <input type="hidden" name="status" value="<?php echo htmlspecialchars($status_filter); ?>"> </form> <!-- Display the total number of tasks based on filters --> <p class="text-lg font-medium text-gray-600 mb-4"> <?php echo count($tasks); ?> tasks found </p> <!-- Display task updates based on the selected filters --> <?php if (empty($tasks)): ?> <p class="text-gray-500">No task updates found.</p> <?php else: ?> <?php $current_date = date('Y-m-d'); ?> <ul class="divide-y divide-gray-200"> <?php foreach ($tasks as $task): ?> <?php $is_overdue = ($task['due_date'] < $current_date && $task['status'] !== 'Complete'); ?> <li class="py-4" onclick="openModal(this)" data-task-name="<?php echo htmlspecialchars($task['task_name']); ?>" data-description="<?php echo htmlspecialchars($task['description']); ?>" data-project-list="<?php echo htmlspecialchars($task['project_list']); ?>" data-due-date="<?php echo htmlspecialchars($task['due_date']); ?>" data-assigned-to="<?php echo htmlspecialchars($task['assigned_to']); ?>" data-created-by="<?php echo htmlspecialchars($task['created_by']); ?>" data-created-at="<?php echo htmlspecialchars($task['created_at']); ?>" data-status="<?php echo htmlspecialchars($task['status']); ?>" data-task-priority="<?php echo htmlspecialchars($task['task_priority']); ?>" data-task-category="<?php echo htmlspecialchars($task['task_category']); ?>" data-reminder-time="<?php echo htmlspecialchars($task['reminder_time']); ?>" data-location="<?php echo htmlspecialchars($task['location']); ?>" data-task-link="<?php echo htmlspecialchars($task['task_link']); ?>" data-file-paths='<?php echo json_encode($task['file_paths']); ?>'> <div class="flex justify-between"> <div> <h3 class="text-xl font-semibold text-gray-800 cursor-pointer"> <?php echo htmlspecialchars($task['task_name']); ?> </h3> <p class="text-sm <?php echo $is_overdue ? 'text-red-500' : 'text-gray-500'; ?>"> Due Date: <?php echo htmlspecialchars($task['due_date']); ?> <?php if ($is_overdue): ?> <span class="ml-2 inline-block bg-red-500 text-white text-xs px-2 py-1 rounded-full">Overdue</span> <?php endif; ?> </p> <p class="text-sm text-gray-500">Assigned to: <?php echo htmlspecialchars($task['assigned_to']); ?></p> </div> <div> <span class="inline-block bg-<?php echo ($task['status'] === 'Complete') ? 'green' : ($task['status'] === 'Pending' ? 'yellow' : 'red'); ?>-200 text-<?php echo ($task['status'] === 'Complete') ? 'green' : ($task['status'] === 'Pending' ? 'yellow' : 'red'); ?>-700 px-3 py-1 rounded-full text-sm font-semibold"> <?php echo htmlspecialchars($task['status']); ?> </span> </div> </div> </li> <?php endforeach; ?> </ul> <?php endif; ?> </div> </div> </main> </div> </div> <!-- Task Detail Modal --> <div id="taskModal" class="fixed inset-0 z-50 hidden overflow-y-auto"> <div class="flex items-center justify-center min-h-screen p-4"> <div class="bg-white rounded-lg shadow-lg w-full max-w-3xl"> <div class="p-4 border-b"> <h3 class="text-lg font-semibold" id="modalTaskName">Task Name</h3> </div> <div class="p-4"> <p><strong>Description:</strong> <span id="modalDescription"></span></p> <DIV style="display: none;"> <p><strong>Project:</strong> <span id="modalProjectList"></span></p> </DIV> <p><strong>Due Date:</strong> <span id="modalDueDate"></span></p> <p><strong>Assignee:</strong> <span id="modalAssignee"></span></p> <p><strong>Created By:</strong> <span id="modalCreatedBy"></span></p> <p><strong>Created At:</strong> <span id="modalCreatedAt"></span></p> <p><strong>Status:</strong> <span id="modalStatus"></span></p> <p><strong>Priority:</strong> <span id="modalTaskPriority"></span></p> <p><strong>Category:</strong> <span id="modalTaskCategory"></span></p> <p><strong>Reminder Time:</strong> <span id="modalReminderTime"></span></p> <p><strong>Location:</strong> <span id="modalLocation"></span></p> <p><strong>Task Link:</strong> <a id="modalTaskLink" href="#" target="_blank" class="text-blue-500">View Task</a></p> <p><strong>Files:</strong></p> <ul id="modalFilePaths"></ul> </div> <div class="p-4 border-t"> <button onclick="closeModal()" class="w-full bg-blue-600 text-white py-2 rounded-lg">Close</button> </div> </div> </div> </div> <script> function openModal(taskElement) { // Set other task details as before document.getElementById('modalTaskName').innerText = taskElement.dataset.taskName; document.getElementById('modalDescription').innerHTML = taskElement.dataset.description; document.getElementById('modalProjectList').innerText = taskElement.dataset.projectList; document.getElementById('modalDueDate').innerText = taskElement.dataset.dueDate; document.getElementById('modalAssignee').innerText = taskElement.dataset.assignedTo; document.getElementById('modalCreatedBy').innerText = taskElement.dataset.createdBy; document.getElementById('modalCreatedAt').innerText = taskElement.dataset.createdAt; document.getElementById('modalStatus').innerText = taskElement.dataset.status; document.getElementById('modalTaskPriority').innerText = taskElement.dataset.taskPriority; document.getElementById('modalTaskCategory').innerText = taskElement.dataset.taskCategory; document.getElementById('modalReminderTime').innerText = taskElement.dataset.reminderTime; document.getElementById('modalLocation').innerText = taskElement.dataset.location; // Decode the JSON string of file paths into an array let filePaths = JSON.parse(taskElement.dataset.filePaths \|\| "[]"); let fileLinks = filePaths.map(path => `<li><a href="${path}" target="_blank" class="text-blue-500 hover:text-blue-700 hover:underline transition duration-200 ">View File</a></li>`).join(''); // Display file links in the modal document.getElementById('modalFilePaths').innerHTML = fileLinks \|\| 'No files attached'; // Show the modal document.getElementById('taskModal').classList.remove('hidden'); } function closeModal() { document.getElementById('taskModal').classList.add('hidden'); } </script> </body> </html> ��\