$date3 = date_create($livEmpFrom);
$date4 = date_create($livEmpTo);
$difference = date_diff($date3, $date4);
$livTotalLeaveDays = $difference->format("%a");
$objForLeaveDaysRemain = new LeaveApplication();
$result = $objForLeaveDaysRemain->forLeaveDaysRemain($livLeaveId);
if (mysqli_fetch_array($result) == null) {
$objForLeaveDaysRemain = new LeaveApplication();
$leaveTotal = $objForLeaveDaysRemain->forLeaveDays($livLeaveId);
while ($rowTotal = mysqli_fetch_array($leaveTotal)) {
$livTotalLeaveDaysRemain = $rowTotal['lTotalDays'] - $livTotalLeaveDays;
}
//echo "From If : TotalLeaveDaysRemain = ".$livTotalLeaveDaysRemain."<br/>";
} else {
$objForLeaveDaysRemain = new LeaveApplication();
$result = $objForLeaveDaysRemain->forLeaveDaysRemain($livLeaveId);
while ($row = mysqli_fetch_array($result)) {
$livTotalLeaveDaysRemain = $row['lTotalLeaveDaysRemain'] - $livTotalLeaveDays;
//echo "From Else : TotalLeaveDaysRemain = ".$livTotalLeaveDaysRemain."<br/>";
}
}
$livEmpReason = $_POST["livEmpReason"];
$livAltEmpCode = $_POST["livAltEmployeeCode"];
$livIsApproved = 0;
$livIsRecomanded = 0;
//echo "<br/>".$livEmpCode."<br/>".$livDate."<br/>".$livLeaveId."<br/>".$livEmpAddress."<br/>".$livEmpFrom."<br/>".$livEmpTo."<br/> Apply for :".$livTotalLeaveDays."<br/> Now days Remain : ".$livTotalLeaveDaysRemain."<br/>".$livEmpReason."<br/>".$livAltEmpCode."<br/>".$livIsApproved;
$objLeaveApplication = new LeaveApplication();
$objLeaveApplication->applyForLeave($livEmpCode, $livDate, $livLeaveId, $livEmpAddress, $livEmpFrom, $livEmpTo, $livTotalLeaveDays, $livTotalLeaveDaysRemain, $livEmpReason, $livAltEmpCode, $livIsApproved, $livIsRecomanded);
if ($objLeaveApplication->CreatedOrNot) {
//echo "hi";
$objempLastApplicationId = new LeaveApplication();
