public PhoneStatLabel[] GetStatLabel(DateTime start, DateTime end)
{
var sql = @"
SELECT DATE_FORMAT(`phones`.`created`, '%d.%m.%Y') AS `label`,
count(case status when 1 then 1 else null end) as created ,
count(case status when 2 then 1 else null end) as activated
FROM `phones`
WHERE (created <= @start and created > @end )
GROUP BY DATE_FORMAT(`phones`.`created`, '%d.%m.%Y')
ORDER BY `phones`.`created` DESC
";
using var connection = new MySqlConnection(_connection);
try
{
return connection.Query<PhoneStatLabel>(sql, new { start, end }).ToArray();
}
catch
{
return Array.Empty<PhoneStatLabel>();
}
}