/**
* Iterates through the given resultset, dispatching every single mail with the given priority.
* @param \System\Db\Database The database to use for the emailsystem queue
* @param SMTP The smtp to use
* @param \System\Db\DatabaseResult The results to iterate
* @param int The priority level
*/
private static final function iterateMailResults(\System\Db\Database $db, \System\Email\SMTP $smtp, \System\Db\DatabaseResult $results, $priority)
{
foreach ($results as $result) {
$attachQuery = new \System\Db\Query($db, \System\Email\SQL_EMAILSYSTEM_GET_ATTACH);
$attachQuery->bind($result->id, \System\Db\QueryType::TYPE_INTEGER);
$attachQuery->bind($priority, \System\Db\QueryType::TYPE_INTEGER);
$attachments = $db->query($attachQuery);
self::addToLog('Processing ' . $results->count() . ' ' . self::$priorityNames[$priority][0] . ' priority mails');
self::dispatchSingleMail($smtp, $result->from, self::convertAddressStringToArray($result->to), self::convertAddressStringToArray($result->cc), self::convertAddressStringToArray($result->bcc), $result->subject, $result->message, $attachments);
$query = new \System\Db\Query($db, \System\Email\SQL_EMAILSSYTEM_DELETEMAIL);
$query->bind(self::$priorityNames[$priority][1], \System\Db\QueryType::TYPE_QUERY);
$query->bind($result->id, \System\Db\QueryType::TYPE_INTEGER);
$db->query($query);
$query = new \System\Db\Query($db, \System\Email\SQL_EMAILSYSTEM_DELETEATTACH);
$query->bind($result->id, \System\Db\QueryType::TYPE_INTEGER);
$query->bind($priority, \System\Db\QueryType::TYPE_INTEGER);
$db->query($query);
}
}
/**
* Returns the global total amount of DB query execution time. This number is the total time over all queries executed on all
* connected database objects.
* @return string The total amount of execution time for all DB queries.
*/
public static final function getTotalQueryTime()
{
return \System\Db\DatabaseResult::getTotalQueryTime();
}
