public static function getCurrentInvoices($userID)
{
$query = MySQL::getInstance()->prepare("SELECT invoiceID, downloadID, amount, UNIX_TIMESTAMP(dueDate) as dueDate, isPending FROM AuthUserInvoices WHERE userID=:userID AND isPaid=0 ORDER BY dueDate");
$query->bindValue(':userID', $userID);
$query->execute();
return $query->fetchAll(PDO::FETCH_ASSOC);
}
public static function delPaymentProfile($userID, $paymentProfileID)
{
$query = MySQL::getInstance()->prepare("DELETE FROM AuthUserPaymentProfiles WHERE userID=:userID AND paymentProfileID=:paymentProfileID");
$query->bindValue(':userID', $userID);
$query->bindValue(':paymentProfileID', $paymentProfileID);
$query->execute();
return $query->rowCount();
}
public static function getEmailVariable($emailKey, $emailLang)
{
$query = MySQL::getInstance()->prepare("SELECT emailText FROM EmailVariables WHERE emailKey=:emailKey AND emailLang=:emailLang");
$query->bindValue(':emailKey', $emailKey);
$query->bindValue(':emailLang', $emailLang);
$query->execute();
$temp = $query->fetch(PDO::FETCH_ASSOC);
return $temp['emailText'];
}
public static function getAvailablePaymentMethods()
{
$query = MySQL::getInstance()->prepare("SELECT paymentMethodID, paymentMethodName FROM AvailablePaymentMethods WHERE paymentMethodAvailable=1");
$query->execute();
return $query->fetchAll(PDO::FETCH_ASSOC);
}
public static function getAvailableFactors()
{
$query = MySQL::getInstance()->prepare("SELECT factorID, factorType, factorDesc, available FROM AvailableFactors");
$query->execute();
return $query->fetchAll(PDO::FETCH_ASSOC);
}
public static function delAuthUserSessions($userID)
{
$query = MySQL::getInstance()->prepare("DELETE FROM AuthUserSessions WHERE userID=:userID");
$query->bindValue(':userID', $userID);
return $query->execute();
}
public static function getAvailablePackages()
{
$query = MySQL::getInstance()->prepare("SELECT packageID, packageGroup, packageName, packageDesc, packageCycle, packageCyclePrice FROM AvailablePackages WHERE packageAvailable=1 ORDER BY packageGroup, packageID");
$query->execute();
return $query->fetchAll(PDO::FETCH_ASSOC);
}
