function GetUnprocessedPoints()
{
$query = "select a.CardNumber, a.SessionID, c.Amount, a.POSAccountNo, c.ID, c.TransactionType, a.ServiceID\n\n from tbl_rewardsession a\n\n -- inner join pos.ptbl_player_sessionhistory_stnmgr b\n -- on a.SessionID = b.PK_PlayerSessionHistoryID\n\n inner join {$this->TableName} c\n on c.SessionID = a.SessionID\n\n where c.Status = 0\n and a.ServiceID = c.ServiceID\n ;";
return parent::RunQuery($query);
}
function GetDailyIssuedCardCount($whatdate)
{
$query = "select count(ID)\n from PegsLoyaltyDB.tbl_Cards\n Where `Status` = 'A'\n and DateIssued = '{$whatdate}'\n order by DateIssued";
return parent::RunQuery($query);
}
function SelectByCardType($cardtype)
{
$query = "select * from {$this->TableName}\n where `CardTypeID_FK` = '{$cardtype}'\n and `Status` = 'A';\n ";
return parent::RunQuery($query);
}
