MessageTable::getAllDailyCount

static function getAllDailyCount()
{
	$connection = Application::getConnection();
	$today = date('Y-m-d') . ' 00:00:00';

	$strSql = "SELECT SENDER_ID, MESSAGE_FROM, COUNT(*) CNT
		FROM b_messageservice_message
		WHERE SUCCESS_EXEC = 'Y'
		AND DATE_EXEC >= '{$today}'
		GROUP BY SENDER_ID, MESSAGE_FROM";

	$result = $connection->query($strSql);
	$counts = array();

	while ($row = $result->fetch())
	{
		$id = $row['SENDER_ID'] .':'. $row['MESSAGE_FROM'];
		$counts[$id] = (int)$row['CNT'];
	}

	return $counts;
}