/**
*
* Get the mail stats
*
* @param $id
*
* @return array
*/
public static function getStatsMail($id)
{
$return = (array) BackendModel::getContainer()->get('database')->getRecord('SELECT i.*, UNIX_TIMESTAMP(i.start_time) AS date, COUNT(DISTINCT u.user_id) AS users
FROM mailengine_stats_mail AS i
LEFT JOIN mailengine_stats_mail_users AS u ON u.send_id = i.id
WHERE i.id = ?
GROUP BY i.id', array((int) $id));
$returnOpened = (array) BackendModel::getContainer()->get('database')->getRecord('SELECT i.*, COUNT(DISTINCT o.user_id) AS opened
FROM mailengine_stats_mail AS i
LEFT JOIN mailengine_stats_mail_opened AS o ON o.send_id = i.id
WHERE i.id = ?
GROUP BY i.id', array((int) $id));
//--Format date
$return["date"] = BackendDataGridFunctions::getLongDate($return["date"]);
$return["percentage"] = BackendTemplateModifiers::formatNumber(round($returnOpened["opened"] / $return['users'] * 100, 0));
return $return;
}
