function getRecomandationNumber()
{
$objDbOperation = new DbOperation();
$this->check = 0;
$columnsName = "COUNT(lIsRecomanded)";
//database column name
$tablesName = "employeeleaveapplicationdetails";
//database table name
$conditions = "lIsRecomanded = 1 AND lIsApproved = 0";
// conditions, what we want to apply
$result = $objDbOperation->dbSelectAll($columnsName, $tablesName, $conditions);
//var_dump($result);
return $result;
}
function getRecomandedApplication()
{
$objDbOperation = new DbOperation();
$this->check = 0;
$columnsName = "ld.lType,emp.eFirstName,emp.eLastName,liv.lId,liv.lApplyDate,liv.lTotalLeaveDays,liv.lLeaveFromDate,liv.lLeaveToDate,liv.lTotalLeaveDaysRemain";
//database column name
$tablesName = "employeeleaveapplicationdetails liv INNER JOIN employeeinfo emp ON liv.lEmployeeCodeNumberWhoApply = emp.eEmployeeCodeNumber INNER JOIN leavedetails ld ON liv.lLeaveId = ld.lId";
//database table name
$conditions = "lIsRecomanded = 1 AND lIsApproved = 0";
// conditions, what we want to apply
$result = $objDbOperation->dbSelectAll($columnsName, $tablesName, $conditions);
//var_dump($result);
return $result;
}
