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.29 TB

🔧 Quick Actions

✏️ Editing: intern-mail.php

<?php
// Database connection parameters
$host = "localhost";
$username = "u329947844_ems"; // Replace with your database username
$password = "Hifi11@ems"; // Replace with your database password
$database = "u329947844_ems";
$port = 3306;

// Create a connection to the database
$conn = new mysqli($host, $username, $password, $database, $port);

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

// Get current date
$current_date = date('Y-m-d');

// Email configuration
$from = "no-reply@hifi11.in"; // Replace with your sender email
$headers = "From: Hifi11 Team <$from>\r\n";
$headers .= "Reply-To: support@hifi11.in\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=UTF-8\r\n";
$cc_email = "ariharasudhan912003@gmail.com"; // CC email address

// Fetch Project Manager (Intern) email
$pm_query = "SELECT email FROM interns WHERE role = 'Project Manager (Intern)' AND status = 'active' LIMIT 1";
$pm_result = $conn->query($pm_query);
$pm_email = $pm_result->num_rows > 0 ? $pm_result->fetch_assoc()['email'] : null;

// Fetch all Developer (Intern) interns
$intern_query = "SELECT id, intern_id, name, email FROM interns WHERE role = 'Developer (Intern)' AND status = 'active'";
$intern_result = $conn->query($intern_query);

$no_task_interns = []; // Array to store interns with no tasks
$attendance_data = []; // Array to store attendance data

if ($intern_result->num_rows > 0) {
    while ($intern = $intern_result->fetch_assoc()) {
        $intern_id = $intern['intern_id'];
        $name = $intern['name'];
        $email = $intern['email'];

// Fetch tasks for the current day for this intern
        $task_query = "SELECT task_name, project_name, priority, status, task_link, task_source 
                       FROM interns_tasks 
                       WHERE assigned_to = '$intern_id' 
                       AND start_date = '$current_date'";
        $task_result = $conn->query($task_query);

// Prepare email for tasks
 if ($task_result->num_rows > 0) {
 $task_list = "<ul>";
 while ($task = $task_result->fetch_assoc()) {
 $task_list .= "<li>";
 $task_list .= "Task: {$task['task_name']} ";
 $task_list .= "Project: {$task['project_name']} ";
 $task_list .= "Priority: {$task['priority']} ";
 $task_list .= "Status: {$task['status']} ";
 if ($task['task_link']) {
 $task_list .= "Task Link: <a href='{$task['task_link']}'>{$task['task_link']}</a> ";
 }
 if ($task['task_source']) {
 $task_list .= "Task Source: {$task['task_source']} ";
 }
 $task_list .= "</li> ";
 }
 $task_list .= "</ul>";

// Task email body
 $task_subject = "Your Tasks for Today ($current_date)";
 $task_message = "
 <html>
 <head>
 <title>Your Tasks for Today</title>
 </head>
 <body>
 <h2>Hello $name,</h2>
 Here are your tasks for today ($current_date):
 $task_list
 Please ensure to complete your tasks by the due date and update the status in the portal.
 If you have any questions, contact your mentor or manager at <a href='mailto:support@hifi11.in'>support@hifi11.in</a>.
 Best regards, The Hifi11 Team
 </body>
 </html>";

// Send task email to intern
 if (mail($email, $task_subject, $task_message, $headers)) {
 echo "Task email sent successfully to $name ($email) ";
 } else {
 echo "Failed to send task email to $name ($email) ";
 }
 } else {
 // Add intern to no-task list
 $no_task_interns[] = $name;
 }

// Fetch attendance for the current day for this intern
        $attendance_query = "SELECT status, check_in, check_out, notes, approval_status 
                             FROM intern_attendance 
                             WHERE intern_id = {$intern['id']} 
                             AND date = '$current_date'";
        $attendance_result = $conn->query($attendance_query);

if ($attendance_result->num_rows > 0) {
            $attendance = $attendance_result->fetch_assoc();
            $attendance_data[] = [
                'name' => $name,
                'status' => $attendance['status'],
                'check_in' => $attendance['check_in'] ?: 'N/A',
                'check_out' => $attendance['check_out'] ?: 'N/A',
                'notes' => $attendance['notes'] ?: 'None',
                'approval_status' => $attendance['approval_status']
            ];
        } else {
            $attendance_data[] = [
                'name' => $name,
                'status' => 'Not Recorded',
                'check_in' => 'N/A',
                'check_out' => 'N/A',
                'notes' => 'None',
                'approval_status' => 'N/A'
            ];
        }
    }
}

// Prepare and send email for interns with no tasks
if (!empty($no_task_interns) && $pm_email) {
 $no_task_list = "<ul>";
 foreach ($no_task_interns as $intern_name) {
 $no_task_list .= "<li>$intern_name</li>";
 }
 $no_task_list .= "</ul>";

$no_task_subject = "Interns with No Tasks Assigned for $current_date";
 $no_task_message = "
 <html>
 <head>
 <title>Interns with No Tasks Assigned</title>
 </head>
 <body>
 <h2>Hello Project Manager,</h2>
 The following Developer (Intern) interns have no tasks assigned for today ($current_date):
 $no_task_list
 Please provide the reason for not assigning tasks to these interns and report to the General Manager, Mr. Rakesh, at <a href='mailto:rakeshannadurai07@gmail.com'>rakeshannadurai07@gmail.com</a>.
 Best regards, The Hifi11 Team
 </body>
 </html>";

// Add CC to headers
    $no_task_headers = $headers . "Cc: $cc_email\r\n";

// Send email to Project Manager and CC to ariharasudhan912003@gmail.com
 if (mail($pm_email, $no_task_subject, $no_task_message, $no_task_headers)) {
 echo "No-task email sent successfully to Project Manager ($pm_email) and CC ($cc_email) ";
 } else {
 echo "Failed to send no-task email to Project Manager ($pm_email) ";
 }
} elseif (empty($no_task_interns)) {
 echo "All Developer (Intern) interns have tasks assigned for $current_date. ";
} else {
 echo "Project Manager (Intern) email not found. ";
}

// Prepare and send attendance email
if ($pm_email && !empty($attendance_data)) {
 $attendance_list = "<table border='1' style='border-collapse: collapse;'>
 <tr>
 <th>Name</th>
 <th>Status</th>
 <th>Check In</th>
 <th>Check Out</th>
 </tr>";
 foreach ($attendance_data as $attendance) {
 $attendance_list .= "<tr>
 <td>{$attendance['name']}</td>
 <td>{$attendance['status']}</td>
 <td>{$attendance['check_in']}</td>
 <td>{$attendance['check_out']}</td>
 </tr>";
 }
 $attendance_list .= "</table>";

$attendance_subject = "Developer (Intern) Attendance for $current_date";
 $attendance_message = "
 <html>
 <head>
 <title>Intern Attendance Report</title>
 </head>
 <body>
 <h2>Hello Project Manager,</h2>
 Below is the attendance report for Developer (Intern) interns for today ($current_date):
 $attendance_list
 Please review the attendance details and take necessary actions.
 Best regards, The Hifi11 Team
 </body>
 </html>";

// Add CC to headers
    $attendance_headers = $headers . "Cc: $cc_email\r\n";

// Send attendance email to Project Manager and CC to ariharasudhan912003@gmail.com
 if (mail($pm_email, $attendance_subject, $attendance_message, $attendance_headers)) {
 echo "Attendance email sent successfully to Project Manager ($pm_email) and CC ($cc_email) ";
 } else {
 echo "Failed to send attendance email to Project Manager ($pm_email) ";
 }
} else {
 echo "No attendance data or Project Manager (Intern) email found. ";
}

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: intern-mail.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation