protected override async Task OnApplicationMessageReceived(string ClientId, string Topic, string ContentType, uint QosLevel, byte[] payload)
{
try
{
string data = Encoding.UTF8.GetString(payload);
JObject jObj = JObject.Parse(data);
int groupId = jObj["groupid"].Value <int>();
int siteId = jObj["siteId"].Value <int>();
string deviceId = jObj["normalizedeviceid"].Value <string>();
string redisKey = CommonFactory.CreateRedisKey(siteId, groupId, deviceId);
HashEntry[] hashValues = CreateHashEntry(jObj);
await db.HashSetAsync(redisKey, hashValues);
//if(groupId == 4) // PV일 경우
//{
// float totalActivePower = jObj["EnergyTotalActivePower"].Value<float>();
// string sub_redis_key = CommonFactory.CreateRedisKey(siteId, groupId, "EnergyTotalActivePower");
// int deviceIndex = int.Parse(deviceId.TrimStart("PV".ToCharArray()));
// if(await db.KeyExistsAsync(sub_redis_key) == false)
// {
// await db.ListLeftPushAsync(sub_redis_key, new RedisValue[] { 0, 0, 0, 0 });
// }
// await db.ListSetByIndexAsync(sub_redis_key, deviceIndex - 1, totalActivePower);
//}
}
catch (Exception ex)
{
logger.LogError(ex, "Method: OnApplicationMessageReceived\n" + ex.Message);
}
}
private async Task <List <double> > ReadSiteStat(int siteId, int groupNo, string filter, string field)
{
List <double> result = new List <double>();
string target_redis_key = CommonFactory.CreateRedisKey(siteId, groupNo, filter);
var redis_keys = CommonFactory.SearchKeys(_redisConn, target_redis_key);
foreach (RedisKey pv_key in redis_keys)
{
double TotalActivePower = (double)await _redisDb.HashGetAsync(pv_key, field);
result.Add(TotalActivePower);
}
return(result);
}
public async Task <IActionResult> GetStatisticsCurrentValue(int lawcodelevel = 1)
{
JObject row_j = null;
try
{
IEnumerable <VwContractorsite> sites = GetAvaliableSites();
if (sites.Count() == 0)
{
return(Ok());
}
var group_sites = sites.GroupBy(MakeClusterKey(lawcodelevel), value => value);
IEnumerable <int> siteIds = sites.Select(x => x.SiteId);
JArray result = new JArray();
List <double> total_socs = new List <double>();
foreach (IGrouping <string, VwContractorsite> row in group_sites)
{
double total_energy_power = 0;
double total_actPwr_charging = 0;
double total_actPwr_discharging = 0;
List <double> socs = new List <double>();
List <double> sohs = new List <double>();
int first_siteid = -1;
foreach (VwContractorsite site in row)
{
if (first_siteid == -1)
{
first_siteid = site.SiteId;
}
// PV
string target_redis_key = CommonFactory.CreateRedisKey(site.SiteId, 4, "PV*");
var redis_keys = CommonFactory.SearchKeys(_redisConn, target_redis_key);
foreach (RedisKey pv_key in redis_keys)
{
double TotalActivePower = (double)await _redisDb.HashGetAsync(pv_key, "TotalActivePower");
total_energy_power += TotalActivePower;
}
// PCS
target_redis_key = CommonFactory.CreateRedisKey(site.SiteId, 1, "PCS*");
redis_keys = CommonFactory.SearchKeys(_redisConn, target_redis_key);
foreach (RedisKey key in redis_keys)
{
double TotalActivePower = (double)await _redisDb.HashGetAsync(key, "actPwrKw");
if (TotalActivePower > 0)
{
total_actPwr_discharging += TotalActivePower;
}
else
{
total_actPwr_charging += TotalActivePower;
}
}
// BMS
target_redis_key = CommonFactory.CreateRedisKey(site.SiteId, 2, "BMS*");
redis_keys = CommonFactory.SearchKeys(_redisConn, target_redis_key);
foreach (RedisKey key in redis_keys)
{
double soc = (double)await _redisDb.HashGetAsync(key, "bms_soc");
socs.Add(soc);
total_socs.Add(soc);
double soh = (double)await _redisDb.HashGetAsync(key, "bms_soh");
sohs.Add(soh);
}
}
JObject weather_obj = new JObject();
if (row.Count() > 0)
{
// Weather
weather_obj = await CommonFactory.RetriveWeather(row.FirstOrDefault().SiteId, _redisDb);
}
row_j = new JObject();
row_j.Add("LawCode", row.Key);
row_j.Add("total_pvpower", total_energy_power);
row_j.Add("total_charging", Math.Abs(total_actPwr_charging));
row_j.Add("total_discharging", total_actPwr_discharging);
row_j.Add("average_soc", socs.Count() > 0 ? socs.Average() : 0);
row_j.Add("average_soh", sohs.Count() > 0 ? sohs.Average() : 0);
row_j.Add("total_count", row.Count());
row_j.Add("weather", weather_obj);
result.Add(row_j);
}
JObject center_weather = await CommonFactory.RetriveWeather(0, _redisDb);
return(Ok(new { group = result, total_average_soc = total_socs.Average(), total_event_count = 0, total_sites_count = siteIds.Count(), controlcenter_weather = center_weather }));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
}
public async Task <IActionResult> GetStatisticsCurrentValueByRcc()
{
JObject row_j = null;
try
{
IQueryable <IGrouping <int, int> > idsGroup = GetRccCodeGroup();
JArray result = new JArray();
List <double> total_socs = new List <double>();
foreach (IGrouping <int, int> row in idsGroup)
{
double total_energy_power = 0;
double total_actPwr_charging = 0;
double total_actPwr_discharging = 0;
List <double> socs = new List <double>();
List <double> sohs = new List <double>();
JObject weather_obj = null;
foreach (int SiteId in row)
{
if (weather_obj == null)
{
weather_obj = await CommonFactory.RetriveWeather(SiteId, _redisDb);
}
// PV
string target_redis_key = CommonFactory.CreateRedisKey(SiteId, 4, "PV*");
var redis_keys = CommonFactory.SearchKeys(_redisConn, target_redis_key);
foreach (RedisKey pv_key in redis_keys)
{
double TotalActivePower = (double)await _redisDb.HashGetAsync(pv_key, "TotalActivePower");
total_energy_power += TotalActivePower;
}
// PCS
target_redis_key = CommonFactory.CreateRedisKey(SiteId, 1, "PCS*");
redis_keys = CommonFactory.SearchKeys(_redisConn, target_redis_key);
foreach (RedisKey key in redis_keys)
{
double TotalActivePower = (double)await _redisDb.HashGetAsync(key, "actPwrKw");
if (TotalActivePower > 0)
{
total_actPwr_discharging += TotalActivePower;
}
else
{
total_actPwr_charging += TotalActivePower;
}
}
// BMS
target_redis_key = CommonFactory.CreateRedisKey(SiteId, 2, "BMS*");
redis_keys = CommonFactory.SearchKeys(_redisConn, target_redis_key);
foreach (RedisKey key in redis_keys)
{
double soc = (double)await _redisDb.HashGetAsync(key, "bms_soc");
socs.Add(soc);
total_socs.Add(soc);
double soh = (double)await _redisDb.HashGetAsync(key, "bms_soh");
sohs.Add(soh);
}
}
row_j = new JObject();
row_j.Add("rcc", row.Key);
row_j.Add("total_pvpower", total_energy_power);
row_j.Add("total_charging", Math.Abs(total_actPwr_charging));
row_j.Add("total_discharging", total_actPwr_discharging);
row_j.Add("average_soc", socs.Count() > 0 ? socs.Average() : 0);
row_j.Add("average_soh", sohs.Count() > 0 ? sohs.Average() : 0);
row_j.Add("total_count", row.Count());
row_j.Add("weather", weather_obj);
result.Add(row_j);
}
JObject center_weather = await CommonFactory.RetriveWeather(0, _redisDb);
return(Ok(new { group = result, total_average_soc = total_socs.Average(), total_event_count = 0, controlcenter_weather = center_weather }));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
}