Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/mail

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: att.php

<?php
// Set the default timezone to India (Kolkata/Chennai)
date_default_timezone_set('Asia/Kolkata');

// Database configuration
$servername = "localhost";
$username = "u329947844_ems";
$password = "Hifi11@ems";
$database = "u329947844_ems";

// Create connection
$conn = new mysqli($servername, $username, $password, $database);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Get current date and time in Indian timezone
$currentDate = date('Y-m-d');
$currentDateTime = date('Y-m-d H:i:s');

// Arrays to track employees with and without tasks
$employeesWithTasks = [];
$employeesWithoutTasks = [];

// Query to get all active employees except HIFI 11 ADMIN
$employeesQuery = "SELECT id, name, email FROM employees WHERE status = 'active' AND name != 'HIFI 11 ADMIN'";
$employeesResult = $conn->query($employeesQuery);

if ($employeesResult->num_rows > 0) {
 while ($employee = $employeesResult->fetch_assoc()) {
 $employeeId = $employee['id'];
 $employeeName = $employee['name'];
 $employeeEmail = $employee['email'];
 
 // Query to get today's tasks for this employee
 $tasksQuery = "SELECT t.task_name, t.project_name, t.status, t.priority 
 FROM tasks t
 WHERE (t.assigned_to LIKE '%($employeeId)%' OR t.assigned_to LIKE '%$employeeId%')
 AND (t.start_date <= '$currentDate' AND t.due_date >= '$currentDate')
 ORDER BY FIELD(t.priority, 'Urgent', 'High', 'Medium', 'Low')";
 
 $tasksResult = $conn->query($tasksQuery);
 
 if ($tasksResult->num_rows > 0) {
 // Track employees with tasks
 $employeesWithTasks[] = $employeeName;
 
 // Start building the email content
 $subject = "Daily Task Reminder - " . date('F j, Y');
 
 // HTML email content
 $message = "<html><body>";
 $message .= "Dear $employeeName,";
 $message .= "Here are your tasks for today (" . date('l, F j, Y') . "):";
 $message .= "Current Time: " . date('h:i A') . " (IST)";
 $message .= "<table border='1' cellpadding='5' cellspacing='0' style='border-collapse: collapse; width: 100%;'>";
 $message .= "<tr style='background-color: #f2f2f2;'><th>Project</th><th>Task</th><th>Status</th><th>Priority</th><th>Action</th></tr>";
 
 // Variable to track if there are any pending tasks
 $hasPendingTasks = false;
 
 // Store tasks to process them twice (for display and status check)
 $tasks = [];
 while ($task = $tasksResult->fetch_assoc()) {
 $tasks[] = $task;
 if ($task['status'] == 'Pending') {
 $hasPendingTasks = true;
 }
 }
 
 // Display all tasks
 foreach ($tasks as $task) {
 $priorityColor = '';
 switch($task['priority']) {
 case 'Urgent': $priorityColor = 'red'; break;
 case 'High': $priorityColor = 'orange'; break;
 case 'Medium': $priorityColor = 'blue'; break;
 default: $priorityColor = 'green';
 }
 
 $actionMessage = '';
 if ($task['status'] == 'Pending') {
 $actionMessage = "Please call the Manager and explain why this task was not completed";
 } elseif ($task['status'] == 'Completed') {
 $actionMessage = "Great job! Thank you for completing this task";
 }
 
 $message .= "<tr>";
 $message .= "<td>" . htmlspecialchars($task['project_name']) . "</td>";
 $message .= "<td>" . htmlspecialchars($task['task_name']) . "</td>";
 $message .= "<td>" . htmlspecialchars($task['status']) . "</td>";
 $message .= "<td style='color: $priorityColor;'>" . htmlspecialchars($task['priority']) . "</td>";
 $message .= "<td>$actionMessage</td>";
 $message .= "</tr>";
 }
 
 $message .= "</table>";
 
 // Add general message based on task statuses
 if ($hasPendingTasks) {
 $message .= "Note: You have pending tasks that require immediate attention. Please contact your manager to explain the delays.";
 } else {
 $message .= "You're doing great! Keep up the good work!";
 }
 
 $message .= "Best regards, HIFI11 Team";
 $message .= "Email generated on: $currentDateTime (IST)";
 $message .= "</body></html>";
 
 // Set email headers for HTML content
 $headers = "From: Hifi11-Technologies@hifi11.in\r\n";
 $headers .= "Reply-To: no-reply@hifi11.in\r\n";
 $headers .= "MIME-Version: 1.0\r\n";
 $headers .= "Content-Type: text/html; charset=UTF-8\r\n";
 $headers .= "X-Mailer: PHP/" . phpversion();
 
 // Send the email
 $mailSent = mail($employeeEmail, $subject, $message, $headers);
 
 // Log the result with Indian timestamp
 $logMessage = date('Y-m-d H:i:s') . " IST - Email " . ($mailSent ? "sent" : "failed") . 
 " to $employeeEmail (" . $employeeName . ") with " . count($tasks) . " tasks\n";
 file_put_contents('mail_log.txt', $logMessage, FILE_APPEND);
 
 if ($mailSent) {
 echo "[" . date('H:i:s') . " IST] Email sent successfully to $employeeName ($employeeEmail) with " . count($tasks) . " tasks ";
 } else {
 echo "[" . date('H:i:s') . " IST] Failed to send email to $employeeName ($employeeEmail) ";
 }
 } else {
 // Track employees without tasks (excluding HIFI 11 ADMIN)
 $employeesWithoutTasks[] = $employeeName;
 
 // No tasks for this employee today - don't send email
 $logMessage = date('Y-m-d H:i:s') . " IST - No tasks found for $employeeEmail (" . $employeeName . "), no email sent\n";
 file_put_contents('mail_log.txt', $logMessage, FILE_APPEND);
 echo "[" . date('H:i:s') . " IST] No tasks found for $employeeName, no email sent ";
 }
 }
 
 // Send summary emails about employees without tasks
 if (!empty($employeesWithoutTasks)) {
 // Common email headers
 $headers = "From: Hifi11-Technologies@hifi11.in\r\n";
 $headers .= "Reply-To: no-reply@hifi11.in\r\n";
 $headers .= "MIME-Version: 1.0\r\n";
 $headers .= "Content-Type: text/html; charset=UTF-8\r\n";
 $headers .= "X-Mailer: PHP/" . phpversion();

// 1. Email to Manager
 $managerEmail = "rakeshannadurai07@gmail.com";
 $managerSubject = "Action Required: Unassigned Tasks Report - " . date('F j, Y');
 
 $managerMessage = "<html><body>";
 $managerMessage .= "Dear Manager,";
 $managerMessage .= "The following employees did not receive any task assignments for today (" . date('l, F j, Y') . "):";
 $managerMessage .= "<ul>";
 foreach ($employeesWithoutTasks as $employee) {
 $managerMessage .= "<li>$employee</li>";
 }
 $managerMessage .= "</ul>";
 $managerMessage .= "Action Required: Please provide an explanation to Chief executive officer for why these employees were not assigned tasks today.";
 $managerMessage .= "Employees with tasks today: " . (empty($employeesWithTasks) ? "None" : implode(", ", $employeesWithTasks)) . "";
 $managerMessage .= "Best regards, HIFI11 Team";
 $managerMessage .= "Email generated on: $currentDateTime (IST)";
 $managerMessage .= "</body></html>";
 
 $mailSent = mail($managerEmail, $managerSubject, $managerMessage, $headers);
 if ($mailSent) {
 echo "[" . date('H:i:s') . " IST] Manager notification sent successfully ";
 } else {
 echo "[" . date('H:i:s') . " IST] Failed to send manager notification ";
 }

// 2. Email to Admin (different content)
 $adminEmail = "ariharasudhan912003@gmail.com";
 $adminSubject = "Notification: Unassigned Tasks Alert - " . date('F j, Y');
 
 $adminMessage = "<html><body>";
 $adminMessage .= "Dear Admin,";
 $adminMessage .= "Please note that the following employees were not assigned any tasks for today (" . date('l, F j, Y') . "):";
 $adminMessage .= "<ul>";
 foreach ($employeesWithoutTasks as $employee) {
 $adminMessage .= "<li>$employee</li>";
 }
 $adminMessage .= "</ul>";
 $adminMessage .= "The manager has been requested to provide an explanation for these unassigned tasks.";
 $adminMessage .= "For your reference, employees with tasks today: " . (empty($employeesWithTasks) ? "None" : implode(", ", $employeesWithTasks)) . "";
 $adminMessage .= "Best regards, HIFI11 Team";
 $adminMessage .= "Email generated on: $currentDateTime (IST)";
 $adminMessage .= "</body></html>";
 
 $mailSent = mail($adminEmail, $adminSubject, $adminMessage, $headers);
 if ($mailSent) {
 echo "[" . date('H:i:s') . " IST] Admin notification sent successfully ";
 } else {
 echo "[" . date('H:i:s') . " IST] Failed to send admin notification ";
 }
 }
} else {
 echo "[" . date('H:i:s') . " IST] No active employees found in the database. ";
}

// ================= ATTENDANCE REPORT SECTION =================

// Array to store attendance records
$attendanceRecords = [];

// Query to get today's attendance records for all active employees except HIFI 11 ADMIN
$attendanceQuery = "SELECT e.name, a.date, a.status, a.check_in, a.check_out, a.notes 
                    FROM attendance a 
                    JOIN employees e ON a.employee_id = e.id 
                    WHERE a.date = '$currentDate' AND e.status = 'active' AND e.name != 'HIFI 11 ADMIN'";
$attendanceResult = $conn->query($attendanceQuery);

if ($attendanceResult->num_rows > 0) {
    while ($attendance = $attendanceResult->fetch_assoc()) {
        $attendanceRecords[] = $attendance;
    }
}

// Prepare email to admin
$attendanceAdminEmail = "ariharasudhan912003@gmail.com";
$attendanceSubject = "Daily Attendance Report - " . date('F j, Y');

// HTML email content
$attendanceMessage = "<html><body>";
$attendanceMessage .= "Dear Admin,";
$attendanceMessage .= "<h3>Today's Attendance Records</h3>";
$attendanceMessage .= "Below are the attendance records for today (" . date('l, F j, Y') . "):";

if (!empty($attendanceRecords)) {
 $attendanceMessage .= "<table border='1' cellpadding='5' cellspacing='0' style='border-collapse: collapse; width: 100%;'>";
 $attendanceMessage .= "<tr style='background-color: #f2f2f2;'><th>Employee</th><th>Date</th><th>Status</th><th>Check In</th><th>Check Out</th><th>Notes</th></tr>";
 foreach ($attendanceRecords as $record) {
 $statusColor = '';
 switch($record['status']) {
 case 'present': $statusColor = 'green'; break;
 case 'absent': $statusColor = 'red'; break;
 case 'half_day': $statusColor = 'orange'; break;
 case 'leave': $statusColor = 'blue'; break;
 }
 $attendanceMessage .= "<tr>";
 $attendanceMessage .= "<td>" . htmlspecialchars($record['name']) . "</td>";
 $attendanceMessage .= "<td>" . htmlspecialchars($record['date']) . "</td>";
 $attendanceMessage .= "<td style='color: $statusColor;'>" . htmlspecialchars($record['status']) . "</td>";
 $attendanceMessage .= "<td>" . ($record['check_in'] ? htmlspecialchars($record['check_in']) : '-') . "</td>";
 $attendanceMessage .= "<td>" . ($record['check_out'] ? htmlspecialchars($record['check_out']) : '-') . "</td>";
 $attendanceMessage .= "<td>" . ($record['notes'] ? htmlspecialchars($record['notes']) : '-') . "</td>";
 $attendanceMessage .= "</tr>";
 }
 $attendanceMessage .= "</table>";
} else {
 $attendanceMessage .= "No attendance records found for today.";
}

$attendanceMessage .= "Best regards, HIFI11 Team";
$attendanceMessage .= "Email generated on: $currentDateTime (IST)";
$attendanceMessage .= "</body></html>";

// Set email headers for HTML content
$headers = "From: Hifi11-Technologies@hifi11.in\r\n";
$headers .= "Reply-To: no-reply@hifi11.in\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=UTF-8\r\n";
$headers .= "X-Mailer: PHP/" . phpversion();

// Send the email to admin
$mailSent = mail($attendanceAdminEmail, $attendanceSubject, $attendanceMessage, $headers);

// Log the result with Indian timestamp
$logMessage = date('Y-m-d H:i:s') . " IST - Admin attendance email " . ($mailSent ? "sent" : "failed") . 
              " to $attendanceAdminEmail with " . count($attendanceRecords) . " records\n";
file_put_contents('mail_log.txt', $logMessage, FILE_APPEND);

if ($mailSent) {
 echo "[" . date('H:i:s') . " IST] Admin attendance email sent successfully with " . count($attendanceRecords) . " records ";
} else {
 echo "[" . date('H:i:s') . " IST] Failed to send admin attendance email ";
}

// Close connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: att.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation