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));
            }
        }