/** * * 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; }