public static function getAllUsers()
{
if (Database::connectify()) {
$stmt = Database::connectify()->prepare("select fullname,email,username from tblUser");
$stmt->execute();
return $stmt;
}
}
public static function getLoanHistory($userid = '')
{
if (Database::connectify()) {
$stmt = Database::connectify()->prepare("View_LoanHistory :IDNo");
$stmt->bindparam(':IDNo', $userid);
$stmt->execute();
return $stmt->fetchAll();
}
}
public static function getSubsidiaryDetails($userid, $refno)
{
if (Database::connectify()) {
$stmt = Database::connectify()->prepare("ViewCreditDetails :EmployeeNo,:RefNo");
$stmt->bindparam(':EmployeeNo', $userid);
$stmt->bindparam(':RefNo', $refno);
$stmt->execute();
return $stmt->fetchAll();
}
}
