/**
* Truncate email_queue table
* @return void
*/
public static function Truncate()
{
// Get the Database Object for this Class
$objDatabase = EmailQueue::GetDatabase();
// Perform the Query
$objDatabase->NonQuery('
TRUNCATE `email_queue`');
}
/**
* Gets the historical journal for an object from the log database.
* Objects will have VirtualAttributes available to lookup login, date, and action information from the journal object.
* @param integer intEmailQueueId
* @return EmailQueue[]
*/
public static function GetJournalForId($intEmailQueueId)
{
$objDatabase = EmailQueue::GetDatabase()->JournalingDatabase;
$objResult = $objDatabase->Query('SELECT * FROM email_queue WHERE email_queue_id = ' . $objDatabase->SqlVariable($intEmailQueueId) . ' ORDER BY __sys_date');
return EmailQueue::InstantiateDbResult($objResult);
}
