TEAMModelOS/TEAMModelOS.FunctionV4/HttpTrigger/BIHttpTrigger.cs

//using System;
//using System.Collections.Generic;
//using System.Dynamic;
//using System.IO;
//using System.Linq;
//using System.Net;
//using System.Net.Http;
//using System.Text.Json;
//using System.Threading.Tasks;
//using Azure.Cosmos;
//using Azure.Storage.Blobs;
//using DocumentFormat.OpenXml.Bibliography;
//using MathNet.Numerics.LinearAlgebra.Double;
//using Microsoft.AspNetCore.Http;
//using Microsoft.Azure.Functions.Worker;
//using Microsoft.Azure.Functions.Worker.Http;
//using Microsoft.Extensions.Configuration;
//using NUnit.Framework.Constraints;
//using StackExchange.Redis;
//using TEAMModelOS.SDK.Context.Constant;
//using TEAMModelOS.SDK.DI;
//using TEAMModelOS.SDK.Extension;
//using TEAMModelOS.SDK.Models;
//using TEAMModelOS.SDK.Models.Cosmos.BI;
//using TEAMModelOS.SDK.Models.Cosmos.BI.BISchool;
//using TEAMModelOS.SDK.Models.Service.BI;
//using TEAMModelOS.SDK.Models.Service.BIStatsWay;

//namespace TEAMModelOS.FunctionV4
//{
//    public class BIHttpTrigger
//    {
//        private readonly AzureCosmosFactory _azureCosmos;
//        private readonly DingDing _dingDing;
//        private readonly AzureStorageFactory _azureStorage;
//        private readonly AzureRedisFactory _azureRedis;
//        private readonly IConfiguration _configuration;
//        private readonly IHttpClientFactory _httpClient;

//        public BIHttpTrigger(AzureCosmosFactory azureCosmos, DingDing dingDing, AzureStorageFactory azureStorage, AzureRedisFactory azureRedis, IConfiguration configuration, IHttpClientFactory httpClient)
//        {
//            _azureCosmos = azureCosmos;
//            _dingDing = dingDing;
//            _azureStorage = azureStorage;
//            _azureRedis = azureRedis;
//            _configuration = configuration;
//            _httpClient = httpClient;
//        }

//        /// <summary>
//        /// 学校信息BI中间件更新
//        /// </summary>
//        /// <param name="req"></param>
//        /// <returns></returns>
//        //[Function("set-sc-birelation")]
//        public async Task<HttpResponseData> upSchoolBIRelation([HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequestData req)
//        {
//            var response = req.CreateResponse(HttpStatusCode.OK);
//            dynamic jsondata = new ExpandoObject();
//            try
//            {
//                var cosmosClient = _azureCosmos.GetCosmosClient();
//                var tableClient = _azureStorage.GetCloudTableClient();
//                var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");

//                string data = await new StreamReader(req.Body).ReadToEndAsync();
//                var json = JsonDocument.Parse(data).RootElement;
//                School school = new();
//                jsondata = json;
//                if (json.TryGetProperty("school", out JsonElement _school))
//                {
//                    school = _school.ToObject<School>();
//                }
//                string type = "";

//                BIRelation bIRelation = new();
//                var resBiRel =  await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync(school.id, new PartitionKey("BIRel"));
//                if (resBiRel.Status == 200)
//                {
//                    using var fileJson = await JsonDocument.ParseAsync(resBiRel.ContentStream);
//                    bIRelation = fileJson.ToObject<BIRelation>();

//                }
//                else
//                    bIRelation.id = school.id;

//                string aName = null;
//                if (!string.IsNullOrEmpty($"{school.areaId}"))
//                    aName = await CosmosQueryHelper.GetStr(cosmosClient, "Normal", $"select value(c.name) from c where c.id='{school.areaId}'", "Base-Area");
//                bIRelation.name = school.name;
//                bIRelation.picture = school.picture;
//                bIRelation.region = school.region;
//                bIRelation.province = school.province;
//                bIRelation.city = school.city;
//                bIRelation.dist = school.dist;
//                bIRelation.address = school.address;
//                bIRelation.areaId = school.areaId;
//                bIRelation.size = school.size;
//                bIRelation.scale = school.scale;
//                bIRelation.upDate = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
//                bIRelation.areaName = aName;

//                if (resBiRel.Status == 200)
//                {
//                    await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<BIRelation>(bIRelation, bIRelation.id, new PartitionKey("BIRel"));
//                    type = "update";
//                }
//                else
//                {
//                    await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<BIRelation>(bIRelation, new PartitionKey("BIRel"));
//                    type = "add";
//                }

//                //保存操作记录
//                await AzureStorageBlobExtensions.SaveBILog(blobClient, tableClient, $"birelation-{type}", $"触发更新学校信息表中间件", _dingDing);
//            }
//            catch (Exception ex)
//            {
//                await _dingDing.SendBotMsg($"BIFunction, {Environment.GetEnvironmentVariable("Option:Location")}, upSchoolBIRelation(),{ex.Message}\n{ex.StackTrace}\n{jsondata.ToJsonString()}", GroupNames.成都开发測試群組);
//            }

//            return response;
//        }

//        /// <summary>
//        /// 统计学校的信息
//        /// </summary>
//        /// <param name="req"></param>
//        /// <returns></returns>
//        //[Function("stats-sc-info")]
//        public async Task<HttpResponseData> StatsSchoolInfo([HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequestData req)
//        {
//            var response = req.CreateResponse(HttpStatusCode.OK);

//            dynamic jsondata = new ExpandoObject();
//            try
//            {
//                string scId = null;
//                var cosmosClient = _azureCosmos.GetCosmosClient();
//                var redisClinet = _azureRedis.GetRedisClient(8);
//                var tableClient = _azureStorage.GetCloudTableClient();
//                var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");
//                string data = await new StreamReader(req.Body).ReadToEndAsync();
//                var json = JsonDocument.Parse(data).RootElement;
//                jsondata = json;
//                if (json.TryGetProperty("schoolId", out JsonElement _schoolId))
//                {
//                    scId = $"{_schoolId}";
//                }
//                if (string.IsNullOrEmpty(scId))
//                {
//                    return response;
//                }

//                bool locKey = await _azureRedis.GetRedisClient(8).KeyExistsAsync($"Train:Statistics:Lock:{scId}");
//                if (!locKey)
//                {
//                    await _azureRedis.GetRedisClient(8).SetAddAsync($"Train:Statistics:Lock:{scId}", new RedisValue(scId));
//                    DateTime minutes = DateTime.UtcNow.AddMinutes(15);   //15分钟
//                    await _azureRedis.GetRedisClient(8).KeyExpireAsync($"Train:Statistics:Lock:{scId}", minutes);

//                    bool isExist = true;
//                    StatsInfo statsInfo = new();
//                    var scDataStats = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{scId}", new PartitionKey("Stats"));
//                    if (scDataStats.Status == 200)
//                    {
//                        using var fileJson = await JsonDocument.ParseAsync(scDataStats.ContentStream);
//                        statsInfo = fileJson.ToObject<StatsInfo>();
//                    }
//                    else                    
//                        isExist = false;

//                    statsInfo = await SchoolStatsWay.GetSingleSc(cosmosClient,redisClinet, scId);
//                    statsInfo.witRoom = ((int)await SchoolStatsWay.GetShoolWisdomRoomCount(_azureCosmos, _azureRedis, _configuration, _httpClient,_dingDing, scId)); //智慧教师
//                    statsInfo.upTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();

//                    if (isExist)
//                        statsInfo = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<StatsInfo>(statsInfo, statsInfo.id, new PartitionKey("Stats"));
//                    else
//                        statsInfo = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<StatsInfo>(statsInfo, new PartitionKey("Stats"));
//                }

//                //保存操作记录
//                await AzureStorageBlobExtensions.SaveBILog(blobClient, tableClient, "trigger-schoolStats", $"触发更新统计数据库", _dingDing);
//            }
//            catch (Exception ex)
//            {
//                await _dingDing.SendBotMsg($"BIFunction,{Environment.GetEnvironmentVariable("Option:Location")}, StatsSchoolInfo() \n {ex.Message}\n{ex.StackTrace}\n{jsondata.ToJsonString()}", GroupNames.成都开发測試群組);
//            }

//            return response;
//        }

//        public async Task<HttpResponseData> SetSchoolStatsInfo([HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequestData req)
//        {
//            var response = req.CreateResponse(HttpStatusCode.OK);
//            dynamic jsondata = new ExpandoObject();
//            string data = await new StreamReader(req.Body).ReadToEndAsync();
//            var json = JsonDocument.Parse(data).RootElement;
//            jsondata = json;
//            try
//            {
//                School school = null;
//                if (json.TryGetProperty("school", out JsonElement _school))
//                    school = _school.ToObject<School>();

//                DateTimeOffset dateOff = DateTimeOffset.UtcNow;
//                var cosmosClient = _azureCosmos.GetCosmosClient();
//                if (school != null)
//                {
//                    StatsInfo statsInfo = new();
//                    var resStats = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync($"{dateOff.Year}-{school.id}", new PartitionKey("Statistics"));
//                    if (resStats.Status == 200)
//                    {
//                        using var fileJson = await JsonDocument.ParseAsync(resStats.ContentStream);
//                        statsInfo = fileJson.ToObject<StatsInfo>();
//                    }
//                    else
//                    {
//                        double[] tchYear = new double[366];
//                        tchYear[0] = 1;
//                        statsInfo.id = $"{dateOff.Year}-{school.id}";
//                        statsInfo.year = dateOff.Year;
//                        statsInfo.stuYear = new double[366].ToList();
//                        statsInfo.tchYear = tchYear.ToList();
//                        statsInfo.tch = 1;
//                        statsInfo.weekTch = 1;
//                        statsInfo.monthTch = 1;
//                        statsInfo.tchUpTime = dateOff.ToUnixTimeMilliseconds();
//                        statsInfo.lesson.year = new double[366].ToList();
//                        statsInfo.lesson.yearInters = new double[366].ToList();
//                        statsInfo.activity.year = new double[366].ToList();
//                    }

//                    statsInfo.schoolId = school.id;
//                    statsInfo.name = school.name;
//                    statsInfo.picture = school.picture;
//                    statsInfo.size = school.size;
//                    statsInfo.scCreateTime = school.createTime;
//                    statsInfo.areaId = school.areaId;
//                    statsInfo.upTime = dateOff.ToUnixTimeMilliseconds();

//                    if (resStats.Status == 200)
//                        await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").ReplaceItemAsync<StatsInfo>(statsInfo, statsInfo.id, new PartitionKey("Statistics"));
//                    else
//                        await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").CreateItemAsync<StatsInfo>(statsInfo, new PartitionKey("Statistics"));
//                }

//            }
//            catch (Exception ex)
//            {
//                await _dingDing.SendBotMsg($"BIFunction,{Environment.GetEnvironmentVariable("Option:Location")}, SetSchoolStatsInfo() \n{ex.Message}\n{ex.StackTrace}\n{jsondata.ToJsonString()}", GroupNames.成都开发測試群組);
//            }

//            return response;
//        }

//        /// <summary>
//        /// 处理传过来的信息加入到统计信息中
//        /// </summary>
//        /// <param name="req"></param>
//        /// <returns></returns>
//        //[Function("set-scstats-type")]
//        public async Task<HttpResponseData> SetSchoolStatsType([HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequestData req) 
//        {
//            var response = req.CreateResponse(HttpStatusCode.OK);
//            dynamic jsondata = new ExpandoObject();
//            try
//            {
//                string data = await new StreamReader(req.Body).ReadToEndAsync();
//                var json = JsonDocument.Parse(data).RootElement;
//                jsondata = json;

//                var cosmosClient = _azureCosmos.GetCosmosClient();
//                string scId = null, type = null;
//                long careDate = 0;
//                int count = 0;
//                int interaction = 0;
//                int lessType = 0;

//                DateTimeOffset cuurDateOff = DateTimeOffset.UtcNow;
//                DateTimeOffset dateOff = DateTimeOffset.UtcNow;
//                if (json.TryGetProperty("scId", out JsonElement _schoolId))
//                    scId = $"{_schoolId}";
//                if (json.TryGetProperty("type", out JsonElement _type))
//                    type = $"{_type}";
//                if (string.IsNullOrEmpty($"{_schoolId}") && string.IsNullOrEmpty($"{_type}"))
//                {
//                    await _dingDing.SendBotMsg($"set-scstats-type, {json}", GroupNames.成都开发測試群組);
//                    return response;
//                }
//                if (json.TryGetProperty("cnt", out JsonElement _cnt))
//                    count = _cnt.GetInt32();

//                if (json.TryGetProperty("interaction", out JsonElement _interaction))
//                    interaction = _interaction.GetInt32();
//                if (json.TryGetProperty("lessType", out JsonElement _lessType))
//                    lessType = _lessType.GetInt32();

//                if (json.TryGetProperty("date", out JsonElement _date))
//                    careDate = _date.GetInt64();
//                else
//                    careDate = dateOff.ToUnixTimeMilliseconds();
//                var (lastWeekS, lastWeekE) = TimeHelper.GetStartOrEnd(dateOff, "lastweek");   //计算上周开始/结束时间
//                var (weekS, weekE) = TimeHelper.GetStartOrEnd(dateOff, "week");             //计算本周开始/结束时间
//                var (lastMonthS, lastMonthE) = TimeHelper.GetStartOrEnd(dateOff, "lastMonth");   //上月开始/结束时间
//                var (monthS, monthE) = TimeHelper.GetStartOrEnd(dateOff, "month");             //本月开始/结束时间
//                var (lastTermS, lastTermE) = TimeHelper.GetStartOrEnd(dateOff, "lastterm");   //计算上学期开始/结束时间
//                var (termS, termE) = TimeHelper.GetStartOrEnd(dateOff, "term");   //计算本学期开始/结束时间

//                var (yearS, yearE) = TimeHelper.GetStartOrEnd(cuurDateOff, "year");   //计算本学期开始/结束时间

//                var (weekDayS, weekDayE) = TimeHelper.GetLongToTime(weekS, weekE);
//                var (lWeekDayS, lWeekDayE) = TimeHelper.GetLongToTime(lastWeekS, lastWeekE);
//                var (lTermDayS, lTermDayE) = TimeHelper.GetLongToTime(lastTermS, lastTermE);
//                var (termDayS, termDayE) = TimeHelper.GetLongToTime(lastTermS, lastTermE);
//                var (lMonthS, lMonthE) = TimeHelper.GetLongToTime(lastMonthS, lastMonthE);
//                var (monthDayS, monthDayE) = TimeHelper.GetLongToTime(monthS, monthE);
//                var lastDay = dateOff.AddDays(-1);
//                int lmthDay = TimeHelper.GetDateDay(lMonthE);
//                StatsInfo statsInfo = new();

//                var resStsInfo = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync($"{dateOff.Year}-{scId}", new PartitionKey("Statistics"));
//                if (resStsInfo.Status == 200)
//                {
//                    using var fileJson = await JsonDocument.ParseAsync(resStsInfo.ContentStream);
//                    statsInfo = fileJson.ToObject<StatsInfo>();
//                }
//                else
//                {
//                    var resLastStsInfo = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync($"{dateOff.Year - 1}-{scId}", new PartitionKey("Statistics"));
//                    if (resLastStsInfo.Status == 200)
//                    {
//                        using var fileJson = await JsonDocument.ParseAsync(resStsInfo.ContentStream);
//                        statsInfo = fileJson.ToObject<StatsInfo>();
//                        statsInfo.id = $"{dateOff.Year}-{scId}";
//                        statsInfo.year = dateOff.Year;
//                        statsInfo.stuYear = new double[366].ToList();
//                        statsInfo.tchYear = new double[366].ToList();
//                        statsInfo.lesson.year = new double[366].ToList();
//                        statsInfo.lesson.yearInters = new double[366].ToList();
//                        statsInfo.activity.year = new double[366].ToList();
//                    }
//                    else
//                    {
//                        ScBase scBase = await cosmosClient.GetContainer("TEAMModelOS", "Common").ReadItemAsync<ScBase>(scId, new PartitionKey("Base"));
//                        statsInfo.id = $"{dateOff.Year}-{scBase.id}";
//                        statsInfo.schoolId = scBase.id;
//                        statsInfo.name = scBase.name;
//                        statsInfo.picture = scBase.picture;
//                        statsInfo.size = scBase.size;
//                        statsInfo.scCreateTime = scBase.createTime;
//                        statsInfo.areaId = scBase.areaId;
//                        statsInfo.upTime = careDate;
//                    }
//                }

//                switch ($"{type}")
//                {
//                    case "Exam":
//                        statsInfo.activity.exam += count;
//                        break;
//                    case "Survey":
//                        statsInfo.activity.survey += count;
//                        break;
//                    case "Vote":
//                        statsInfo.activity.vote += count;
//                        break;
//                    case "Homework":
//                        statsInfo.activity.homework += count;
//                        break;
//                    case "Less":
//                        //课例
//                        statsInfo.lesson.year[dateOff.DayOfYear] += count;
//                        statsInfo.lesson.all += count;

//                        if (lessType == 0)
//                            statsInfo.lesson.open += count;
//                        else
//                            statsInfo.lesson.less += count;

//                        statsInfo.lesson.lastDay = ((int)statsInfo.lesson.year[lastDay.DayOfYear]);
//                        statsInfo.lesson.day = ((int)statsInfo.lesson.year[dateOff.DayOfYear]);

//                        var lessList = DenseMatrix.OfColumns(new List<List<double>>() { statsInfo.lesson.year });
//                        statsInfo.lesson.lastWeek = ((int)lessList.SubMatrix(lWeekDayS.DayOfYear, 7, 0, lessList.ColumnCount).ColumnSums().Sum());
//                        statsInfo.lesson.week = ((int)lessList.SubMatrix(weekDayS.DayOfYear, (dateOff.DayOfYear - weekDayS.DayOfYear), 0, lessList.ColumnCount).ColumnSums().Sum());

//                        if (lastTermS <= statsInfo.lesson.upTime && statsInfo.lesson.upTime <= lastTermE)
//                        {
//                            if (lTermDayS.Year < dateOff.Year)
//                            {
//                                var lastLessSts = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync($"{lTermDayS.Year}-{scId}", new PartitionKey("Statistics"));
//                                if (lastLessSts.Status == 200)
//                                {
//                                    using var fileJson = await JsonDocument.ParseAsync(lastLessSts.ContentStream);
//                                    var tempSts = fileJson.ToObject<StatsInfo>();
//                                    var actYer = DenseMatrix.OfColumns(new List<List<double>>() { tempSts.lesson.year, statsInfo.lesson.year });
//                                    statsInfo.lesson.lastTerm = ((int)actYer.SubMatrix(lTermDayS.DayOfYear, lTermDayE.DayOfYear, 0, 1).ColumnSums().Sum());
//                                }
//                            }
//                        }

//                        if (termS <= statsInfo.lesson.upTime && statsInfo.lesson.upTime <= termE)
//                        {
//                            if (termDayS.Year < dateOff.Year)
//                            {
//                                var lastSts = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync($"{termDayS.Year}-{scId}", new PartitionKey("Statistics"));
//                                if (lastSts.Status == 200)
//                                {
//                                    using var fileJson = await JsonDocument.ParseAsync(lastSts.ContentStream);
//                                    var tempSts = fileJson.ToObject<StatsInfo>();
//                                    var actYer = DenseMatrix.OfColumns(new List<List<double>>() { tempSts.lesson.year, statsInfo.lesson.year });
//                                    statsInfo.lesson.term = ((int)actYer.SubMatrix(termDayS.DayOfYear, termDayE.DayOfYear, 0, 1).ColumnSums().Sum());
//                                }
//                                else
//                                    statsInfo.lesson.term += count;
//                            }
//                        }

//                        statsInfo.lesson.lastMonth = ((int)lessList.SubMatrix(lMonthS.DayOfYear, lmthDay, 0, lessList.ColumnCount).ColumnSums().Sum());
//                        statsInfo.lesson.month += ((int)lessList.SubMatrix(monthDayS.DayOfYear, (dateOff.DayOfYear - monthDayS.DayOfYear), 0, lessList.ColumnCount).ColumnSums().Sum());

//                        //课例互动
//                        statsInfo.lesson.yearInters[dateOff.DayOfYear] += interaction;
//                        statsInfo.lesson.allInter += interaction;
//                        statsInfo.lesson.lastDayInter = ((int)statsInfo.lesson.yearInters[lastDay.DayOfYear]);
//                        statsInfo.lesson.dayInter = ((int)statsInfo.lesson.yearInters[dateOff.DayOfYear]);

//                        var interList = DenseMatrix.OfColumns(new List<List<double>>() { statsInfo.lesson.yearInters });
//                        statsInfo.lesson.lastMonthInter = ((int)interList.SubMatrix(lMonthS.DayOfYear, lmthDay, 0, interList.ColumnCount).ColumnSums().Sum());
//                        statsInfo.lesson.monthInter += ((int)interList.SubMatrix(monthDayS.DayOfYear, (dateOff.DayOfYear - monthDayS.DayOfYear), 0, interList.ColumnCount).ColumnSums().Sum());

//                        if (lastTermS <= statsInfo.lesson.upTime && statsInfo.lesson.upTime <= lastTermE)
//                        {
//                            if (lTermDayS.Year < dateOff.Year)
//                            {
//                                var lastSts = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync($"{lTermDayS.Year}-{scId}", new PartitionKey("Statistics"));
//                                if (lastSts.Status == 200)
//                                {
//                                    using var fileJson = await JsonDocument.ParseAsync(lastSts.ContentStream);
//                                    var tempSts = fileJson.ToObject<StatsInfo>();
//                                    statsInfo.lesson.lastYearInter = ((int)tempSts.lesson.yearInters.Sum());
//                                }
//                                else
//                                    statsInfo.lesson.lastYearInter = 0;
//                            }
//                        }

//                        statsInfo.lesson.upTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
//                        break;
//                    case "Student":
//                        statsInfo.stuYear[dateOff.DayOfYear] += count;
//                        statsInfo.stu += count;

//                        statsInfo.dayStu = ((int)statsInfo.stuYear[dateOff.DayOfYear]);
//                        var stuList = DenseMatrix.OfColumns(new List<List<double>>() { statsInfo.stuYear });
//                        statsInfo.weekStu = ((int)stuList.SubMatrix(weekDayS.DayOfYear, (dateOff.DayOfYear - weekDayS.DayOfYear), 0, stuList.ColumnCount).ColumnSums().Sum());
//                        statsInfo.monthStu = ((int)stuList.SubMatrix(monthDayS.DayOfYear, (dateOff.DayOfYear - monthDayS.DayOfYear), 0, stuList.ColumnCount).ColumnSums().Sum());

//                        statsInfo.stuUpTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
//                        break;
//                    case "Teacher":

//                        statsInfo.tchYear[dateOff.DayOfYear] += count;
//                        statsInfo.tch += count;

//                        statsInfo.dayTch = ((int)statsInfo.tchYear[dateOff.DayOfYear]);
//                        var tchList = DenseMatrix.OfColumns(new List<List<double>>() { statsInfo.tchYear });
//                        statsInfo.weekTch = ((int)tchList.SubMatrix(weekDayS.DayOfYear, (dateOff.DayOfYear - weekDayS.DayOfYear), 0, tchList.ColumnCount).ColumnSums().Sum());
//                        statsInfo.monthTch = ((int)tchList.SubMatrix(monthDayS.DayOfYear, (dateOff.DayOfYear - monthDayS.DayOfYear), 0, tchList.ColumnCount).ColumnSums().Sum());

//                        statsInfo.tchUpTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
//                        break;
//                }

//                if ($"{type}".Equals("Exam") || $"{type}".Equals("Survey") || $"{type}".Equals("Vote") || $"{type}".Equals("Homework"))
//                {
//                    statsInfo.activity.all += count;
//                    if (careDate >= yearS && careDate <= yearE)
//                    {
//                        if (count > 0)
//                        {
//                            statsInfo.activity.year[dateOff.DayOfYear] += count;
//                            DenseMatrix matris = DenseMatrix.OfColumns(new List<List<double>>() { statsInfo.activity.year });
//                            statsInfo.activity.lastDay = ((int)statsInfo.activity.year[lastDay.DayOfYear]);
//                            statsInfo.activity.dayCnt = ((int)statsInfo.activity.year[dateOff.DayOfYear]);
//                            statsInfo.activity.lastWeek = ((int)matris.SubMatrix(lWeekDayS.DayOfYear, 7, 0, matris.ColumnCount).ColumnSums().Sum());
//                            statsInfo.activity.week = ((int)matris.SubMatrix(weekDayS.DayOfYear, weekDayE.DayOfYear - weekDayS.DayOfYear, 0, matris.ColumnCount).ColumnSums().Sum());
//                            if (lastTermS <= statsInfo.activity.upTime && statsInfo.activity.upTime <= lastTermE)
//                            {
//                                if (lTermDayS.Year < dateOff.Year)
//                                {
//                                    var lastSts = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync($"{lTermDayS.Year}-{scId}", new PartitionKey("Statistics"));
//                                    if (lastSts.Status == 200)
//                                    {
//                                        using var fileJson = await JsonDocument.ParseAsync(lastSts.ContentStream);
//                                        var tempSts = fileJson.ToObject<StatsInfo>();
//                                        var actYer = DenseMatrix.OfColumns(new List<List<double>>() { tempSts.activity.year, statsInfo.activity.year });
//                                        statsInfo.activity.lastTerm = ((int)actYer.SubMatrix(lTermDayS.DayOfYear, lTermDayE.DayOfYear, 0, 1).ColumnSums().Sum());
//                                    }
//                                    else
//                                        statsInfo.activity.lastTerm = 0;
//                                }
//                            }

//                            if (termS <= statsInfo.activity.upTime && statsInfo.activity.upTime <= termE)
//                            {
//                                if (termDayS.Year < dateOff.Year)
//                                {
//                                    var lastSts = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync($"{termDayS.Year}-{scId}", new PartitionKey("Statistics"));
//                                    if (lastSts.Status == 200)
//                                    {
//                                        using var fileJson = await JsonDocument.ParseAsync(lastSts.ContentStream);
//                                        var tempSts = fileJson.ToObject<StatsInfo>();
//                                        var actYer = DenseMatrix.OfColumns(new List<List<double>>() { tempSts.activity.year, statsInfo.activity.year });
//                                        statsInfo.activity.term = ((int)actYer.SubMatrix(termDayS.DayOfYear, termDayE.DayOfYear, 0, 1).ColumnSums().Sum());
//                                    }
//                                    else
//                                        statsInfo.activity.term += count;
//                                }
//                                else
//                                {
//                                    var actYer = DenseMatrix.OfColumns(new List<List<double>>() { statsInfo.activity.year });
//                                    statsInfo.activity.term = ((int)actYer.SubMatrix(termDayS.DayOfYear, termDayE.DayOfYear, 0, 1).ColumnSums().Sum());
//                                }
//                            }

//                            statsInfo.activity.lastMonth = ((int)matris.SubMatrix(lMonthS.DayOfYear, lmthDay, 0, matris.ColumnCount).ColumnSums().Sum());
//                            statsInfo.activity.month += ((int)matris.SubMatrix(monthDayS.DayOfYear, (dateOff.DayOfYear - monthDayS.DayOfYear), 0, matris.ColumnCount).ColumnSums().Sum());
//                            statsInfo.activity.upTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
//                        }
//                    }

//                }

//                if (resStsInfo.Status == 200)
//                    statsInfo = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").ReplaceItemAsync<StatsInfo>(statsInfo, scId, new PartitionKey("Statistics"));
//                else
//                    statsInfo = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").CreateItemAsync<StatsInfo>(statsInfo, new PartitionKey("Statistics"));
//            }
//            catch (Exception ex)
//            {
//                await _dingDing.SendBotMsg($"BIFunction,{Environment.GetEnvironmentVariable("Option:Location")}, SetSchoolStatsType() \n{ex.Message}\n{ex.StackTrace}\n{jsondata.ToJsonString()}", GroupNames.成都开发測試群組);
//            }

//            return response;
//        }

//    }
//}