function leaveDue($applicantUserCodeNumber, $livLeaveId)
{
$objForLeaveDaysRemain = new DbOperation();
$result = $objForLeaveDaysRemain->leaveDaysRemainForOneUser($applicantUserCodeNumber, $livLeaveId);
if (mysqli_fetch_array($result) == null) {
$objForLeaveDaysRemain = new DbOperation();
$leaveTotal = $objForLeaveDaysRemain->forLeaveDays($livLeaveId);
while ($rowTotal = mysqli_fetch_array($leaveTotal)) {
$livTotalLeaveDaysRemain = $rowTotal['lTotalDays'];
}
//echo "From If : TotalLeaveDaysRemain = ".$livTotalLeaveDaysRemain."<br/>";
return $livTotalLeaveDaysRemain;
} else {
$objForLeaveDaysRemain = new DbOperation();
$result = $objForLeaveDaysRemain->leaveDaysRemainForOneUser($applicantUserCodeNumber, $livLeaveId);
while ($row = mysqli_fetch_array($result)) {
$livTotalLeaveDaysRemain = $row['lTotalLeaveDaysRemain'];
}
//echo "From Else : TotalLeaveDaysRemain = ".$livTotalLeaveDaysRemain."<br/>";
return $livTotalLeaveDaysRemain;
}
$objDbOperation = new DbOperation();
$this->check = 0;
$columnsName = "lTotalLeaveDaysRemain";
//database column name
$tablesName = "employeeleaveapplicationdetails";
//database table name
$conditions = "WHERE lLeaveId = " . $livLeaveId . " ORDER BY lId DESC LIMIT 1";
// conditions, what we want to apply
$result = $objDbOperation->dbJoinSingleSelect($columnsName, $tablesName, $conditions);
//var_dump($result);
return $result;
}
