MessageTable::getDailyCount

static function getDailyCount($senderId, $fromId)
{
	$connection = Application::getConnection();
	$helper = $connection->getSqlHelper();
	$today = date('Y-m-d') . ' 00:00:00';

	$senderId = $helper->forSql((string)$senderId);
	$fromId = $helper->forSql((string)$fromId);

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

	$result = $connection->query($strSql)->fetch();
	return is_array($result) ? (int)$result['CNT'] : 0;
}