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; }