//Grab Graph Stats between an interval of time using unix time and specify the interval between each data point in seconds for a specific camera.
//For example, between 1514808000 (01/01/2018 @ 12:00pm (UTC)) and 1517486400 (02/01/2018 @ 12:00pm (UTC)) with each point 3600 seconds apart (1 hour)
public GraphStatistics GetGraphStatisticsByInterval(int cameraId, int startDate, int endDate, int interval)
{
GraphStatistics graphStatistics = new GraphStatistics();
List <string[]> maxStats = new List <string[]>();
DateTime epoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
DateTime end = epoch.AddSeconds(endDate);
DateTime start = end.AddSeconds(interval * -1);
for (int i = endDate; i > startDate; i = i - interval)
{
DatabaseGraphStat value = _databaseQueryService.getGraphStatByTimeInterval(cameraId, start, end);
int epochUnixTime = (int)(value.End - new DateTime(1970, 1, 1)).TotalSeconds;
maxStats.Add(new string[2] {
epochUnixTime.ToString(), value.MaximumDetectedObjects.ToString()
});
start = start.AddSeconds(interval);
end = end.AddSeconds(interval);
}
// maxStats.Add(new string[2] { "dateTime", "People" });
maxStats.Reverse();
graphStatistics.Stats = maxStats.ToArray();
return(graphStatistics);
}
public void setup()
{
for (int c = 0; c < 3; c++)
{
DatabaseGraphStat graphStat = new DatabaseGraphStat
{
AverageDetectedObjects = 20 + c,
MaximumDetectedObjects = 15 + c + 1,
MinimumDetectedObjects = 2 + c + 2,
Start = new DateTime(2018, 1, c + 1, 12, 0, 0, 0),
End = new DateTime(2018, 1, c + 2, 12, 0, 0, 0),
};
graphStats[c] = graphStat;
}
}
public GraphStatistics GetYearlyGraphStatistics(int cameraId)
{
GraphStatistics graphStatistics = new GraphStatistics();
List <string[]> maxStats = new List <string[]>();
//using a placeholder time right now since we dont have data coming in at the same time.
//Ideally the end datetime should be the current datetime and the add seconds should be bigger for yearly
DateTime end = new DateTime(2018, 4, 11, 14, 53, 18);
DateTime start = end.AddSeconds(-5);
for (int i = 0; i < 200; i++)
{
DatabaseGraphStat value = _databaseQueryService.getGraphStatByTimeInterval(cameraId, start, end);
int epoch = (int)(value.End - new DateTime(1970, 1, 1)).TotalSeconds;
maxStats.Add(new string[2] {
epoch.ToString(), value.MaximumDetectedObjects.ToString()
});
start = start.AddSeconds(5);
end = end.AddSeconds(5);
}
graphStatistics.Stats = maxStats.ToArray();
return(graphStatistics);
}
