$livUserLeaveType = $_POST['userLeaveType'];
$livApplicationUpdateBy = $_SESSION['officeUserName'];
$date1 = date_create($livUserLeaveFrom);
$date2 = date_create($livUserLeaveTo);
$diff = date_diff($date1, $date2);
$lTotalLeaveDays = $diff->format("%a");
//echo "Apply For : ".$lTotalLeaveDays." days <br/>";
$objForApplicantLeaveTypeAndCode = new LeaveApplication();
$applicantLeaveTypeAndCode = $objForApplicantLeaveTypeAndCode->getApplicantLeaveTypeAndCode($livUserId);
while ($row = mysqli_fetch_array($applicantLeaveTypeAndCode)) {
$livUserOldLeaveType = $row['lLeaveId'];
$livUserCode = $row['lEmployeeCodeNumberWhoApply'];
}
if ($livUserLeaveType == $livUserOldLeaveType) {
$objForLeaveDaysRemain = new LeaveApplication();
$result = $objForLeaveDaysRemain->lastTotalAndReaminLeaveDays($livUserId);
while ($orw = mysqli_fetch_array($result)) {
$SUB = $lTotalLeaveDays - $orw['lTotalLeaveDays'];
//echo "From while : TotalLeaveDays = ".$SUB."<br/>";
$lTotalLeaveDaysRemain = $orw['lTotalLeaveDaysRemain'] - $SUB;
//echo "From while : TotalLeaveDaysRemain = ".$lTotalLeaveDaysRemain."<br/>";
}
} else {
$objForLeaveDaysRemain = new LeaveApplication();
$result = $objForLeaveDaysRemain->forNewLeaveDaysRemain($livUserCode, $livUserLeaveType);
if (mysqli_fetch_array($result) == null) {
$objForLeaveDaysRemain = new LeaveApplication();
$leaveTotal = $objForLeaveDaysRemain->forLeaveDays($livUserLeaveType);
while ($rowTotal = mysqli_fetch_array($leaveTotal)) {
$lTotalLeaveDaysRemain = $rowTotal['lTotalDays'] - $lTotalLeaveDays;
}
