BIHttpTrigger.cs 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Dynamic;
  4. using System.IO;
  5. using System.Linq;
  6. using System.Net;
  7. using System.Net.Http;
  8. using System.Text.Json;
  9. using System.Threading.Tasks;
  10. using Azure.Cosmos;
  11. using Azure.Storage.Blobs;
  12. using DocumentFormat.OpenXml.Bibliography;
  13. using MathNet.Numerics.LinearAlgebra.Double;
  14. using Microsoft.AspNetCore.Http;
  15. using Microsoft.Azure.Functions.Worker;
  16. using Microsoft.Azure.Functions.Worker.Http;
  17. using NUnit.Framework.Constraints;
  18. using StackExchange.Redis;
  19. using TEAMModelOS.SDK.Context.Constant;
  20. using TEAMModelOS.SDK.DI;
  21. using TEAMModelOS.SDK.Extension;
  22. using TEAMModelOS.SDK.Models;
  23. using TEAMModelOS.SDK.Models.Cosmos.BI;
  24. using TEAMModelOS.SDK.Models.Cosmos.BI.BISchool;
  25. using TEAMModelOS.SDK.Models.Service.BI;
  26. using TEAMModelOS.SDK.Models.Service.BIStatsWay;
  27. namespace TEAMModelOS.FunctionV4.HttpTrigger
  28. {
  29. public class BIHttpTrigger
  30. {
  31. private readonly AzureCosmosFactory _azureCosmos;
  32. private readonly DingDing _dingDing;
  33. private readonly AzureStorageFactory _azureStorage;
  34. private readonly AzureRedisFactory _azureRedis;
  35. public BIHttpTrigger(AzureCosmosFactory azureCosmos, DingDing dingDing, AzureStorageFactory azureStorage, AzureRedisFactory azureRedis)
  36. {
  37. _azureCosmos = azureCosmos;
  38. _dingDing = dingDing;
  39. _azureStorage = azureStorage;
  40. _azureRedis = azureRedis;
  41. }
  42. /// <summary>
  43. /// 学校信息BI中间件更新
  44. /// </summary>
  45. /// <param name="req"></param>
  46. /// <returns></returns>
  47. [Function("set-sc-birelation")]
  48. public async Task<HttpResponseData> upSchoolBIRelation([HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequestData req)
  49. {
  50. var response = req.CreateResponse(HttpStatusCode.OK);
  51. dynamic jsondata = new ExpandoObject();
  52. try
  53. {
  54. var cosmosClient = _azureCosmos.GetCosmosClient();
  55. var tableClient = _azureStorage.GetCloudTableClient();
  56. var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");
  57. string data = await new StreamReader(req.Body).ReadToEndAsync();
  58. var json = JsonDocument.Parse(data).RootElement;
  59. School school = new();
  60. jsondata = json;
  61. if (json.TryGetProperty("school", out JsonElement _school))
  62. {
  63. school = _school.ToObject<School>();
  64. }
  65. string type = "";
  66. BIRelation bIRelation = new();
  67. var resBiRel = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync(school.id, new PartitionKey("BIRel"));
  68. if (resBiRel.Status == 200)
  69. {
  70. using var fileJson = await JsonDocument.ParseAsync(resBiRel.ContentStream);
  71. bIRelation = fileJson.ToObject<BIRelation>();
  72. }
  73. else
  74. bIRelation.id = school.id;
  75. string aName = null;
  76. if (!string.IsNullOrEmpty($"{school.areaId}"))
  77. aName = await CosmosQueryHelper.GetStr(cosmosClient, "Normal", $"select value(c.name) from c where c.id='{school.areaId}'", "Base-Area");
  78. bIRelation.name = school.name;
  79. bIRelation.picture = school.picture;
  80. bIRelation.region = school.region;
  81. bIRelation.province = school.province;
  82. bIRelation.city = school.city;
  83. bIRelation.dist = school.dist;
  84. bIRelation.address = school.address;
  85. bIRelation.areaId = school.areaId;
  86. bIRelation.size = school.size;
  87. bIRelation.scale = school.scale;
  88. bIRelation.upDate = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  89. bIRelation.areaName = aName;
  90. if (resBiRel.Status == 200)
  91. {
  92. await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<BIRelation>(bIRelation, bIRelation.id, new PartitionKey("BIRel"));
  93. type = "update";
  94. }
  95. else
  96. {
  97. await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<BIRelation>(bIRelation, new PartitionKey("BIRel"));
  98. type = "add";
  99. }
  100. //保存操作记录
  101. await AzureStorageBlobExtensions.SaveBILog(blobClient, tableClient, $"birelation-{type}", $"触发更新学校信息表中间件", _dingDing);
  102. }
  103. catch (Exception ex)
  104. {
  105. await _dingDing.SendBotMsg($"BIFunction, upSchoolBIRelation(),{ex.Message}\n{ex.StackTrace}\n{jsondata.ToJsonString()}", GroupNames.成都开发測試群組);
  106. }
  107. return response;
  108. }
  109. /// <summary>
  110. /// 统计学校的信息
  111. /// </summary>
  112. /// <param name="req"></param>
  113. /// <returns></returns>
  114. //[Function("stats-sc-info")]
  115. public async Task<HttpResponseData> StatsSchoolInfo([HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequestData req)
  116. {
  117. var response = req.CreateResponse(HttpStatusCode.OK);
  118. dynamic jsondata = new ExpandoObject();
  119. try
  120. {
  121. string scId = null;
  122. var cosmosClient = _azureCosmos.GetCosmosClient();
  123. var redisClinet = _azureRedis.GetRedisClient(8);
  124. var tableClient = _azureStorage.GetCloudTableClient();
  125. var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");
  126. string data = await new StreamReader(req.Body).ReadToEndAsync();
  127. var json = JsonDocument.Parse(data).RootElement;
  128. jsondata = json;
  129. if (json.TryGetProperty("schoolId", out JsonElement _schoolId))
  130. {
  131. scId = $"{_schoolId}";
  132. }
  133. if (string.IsNullOrEmpty(scId))
  134. {
  135. return response;
  136. }
  137. bool locKey = await _azureRedis.GetRedisClient(8).KeyExistsAsync($"Train:Statistics:Lock:{scId}");
  138. if (!locKey)
  139. {
  140. await _azureRedis.GetRedisClient(8).SetAddAsync($"Train:Statistics:Lock:{scId}", new RedisValue(scId));
  141. DateTime minutes = DateTime.UtcNow.AddMinutes(15); //15分钟
  142. await _azureRedis.GetRedisClient(8).KeyExpireAsync($"Train:Statistics:Lock:{scId}", minutes);
  143. bool isExist = true;
  144. StatsInfo statsInfo = new();
  145. var scDataStats = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{scId}", new PartitionKey("Stats"));
  146. if (scDataStats.Status == 200)
  147. {
  148. using var fileJson = await JsonDocument.ParseAsync(scDataStats.ContentStream);
  149. statsInfo = fileJson.ToObject<StatsInfo>();
  150. }
  151. else
  152. isExist = false;
  153. statsInfo = await SchoolStatsWay.GetSingleSc(cosmosClient,redisClinet, scId);
  154. statsInfo.upTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  155. if (isExist)
  156. statsInfo = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<StatsInfo>(statsInfo, statsInfo.id, new PartitionKey("Stats"));
  157. else
  158. statsInfo = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<StatsInfo>(statsInfo, new PartitionKey("Stats"));
  159. }
  160. //保存操作记录
  161. await AzureStorageBlobExtensions.SaveBILog(blobClient, tableClient, "trigger-schoolStats", $"触发更新统计数据库", _dingDing);
  162. }
  163. catch (Exception ex)
  164. {
  165. await _dingDing.SendBotMsg($"BIFunction, StatsSchoolInfo() \n {ex.Message}\n{ex.StackTrace}\n{jsondata.ToJsonString()}", GroupNames.成都开发測試群組);
  166. }
  167. return response;
  168. }
  169. public async Task<HttpResponseData> SetSchoolStatsInfo([HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequestData req)
  170. {
  171. var response = req.CreateResponse(HttpStatusCode.OK);
  172. dynamic jsondata = new ExpandoObject();
  173. string data = await new StreamReader(req.Body).ReadToEndAsync();
  174. var json = JsonDocument.Parse(data).RootElement;
  175. jsondata = json;
  176. try
  177. {
  178. School school = null;
  179. if (json.TryGetProperty("school", out JsonElement _school))
  180. school = _school.ToObject<School>();
  181. DateTimeOffset dateOff = DateTimeOffset.UtcNow;
  182. var cosmosClient = _azureCosmos.GetCosmosClient();
  183. if (school != null)
  184. {
  185. StatsInfo statsInfo = new();
  186. var resStats = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{dateOff.Year}-{school.id}", new PartitionKey("Statistics"));
  187. if (resStats.Status == 200)
  188. {
  189. using var fileJson = await JsonDocument.ParseAsync(resStats.ContentStream);
  190. statsInfo = fileJson.ToObject<StatsInfo>();
  191. }
  192. else
  193. {
  194. double[] tchYear = new double[366];
  195. tchYear[0] = 1;
  196. statsInfo.id = $"{dateOff.Year}-{school.id}";
  197. statsInfo.year = dateOff.Year;
  198. statsInfo.stuYear = new double[366].ToList();
  199. statsInfo.tchYear = tchYear.ToList();
  200. statsInfo.tch = 1;
  201. statsInfo.weekTch = 1;
  202. statsInfo.monthTch = 1;
  203. statsInfo.tchUpTime = dateOff.ToUnixTimeMilliseconds();
  204. statsInfo.lesson.year = new double[366].ToList();
  205. statsInfo.lesson.yearInters = new double[366].ToList();
  206. statsInfo.activity.year = new double[366].ToList();
  207. }
  208. statsInfo.schoolId = school.id;
  209. statsInfo.name = school.name;
  210. statsInfo.picture = school.picture;
  211. statsInfo.size = school.size;
  212. statsInfo.scCreateTime = school.createTime;
  213. statsInfo.areaId = school.areaId;
  214. statsInfo.upTime = dateOff.ToUnixTimeMilliseconds();
  215. if (resStats.Status == 200)
  216. await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<StatsInfo>(statsInfo, statsInfo.id, new PartitionKey("Statistics"));
  217. else
  218. await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<StatsInfo>(statsInfo, new PartitionKey("Statistics"));
  219. }
  220. }
  221. catch (Exception ex)
  222. {
  223. await _dingDing.SendBotMsg($"BIFunction, SetSchoolStatsInfo() \n{ex.Message}\n{ex.StackTrace}\n{jsondata.ToJsonString()}", GroupNames.成都开发測試群組);
  224. }
  225. return response;
  226. }
  227. /// <summary>
  228. /// 处理传过来的信息加入到统计信息中
  229. /// </summary>
  230. /// <param name="req"></param>
  231. /// <returns></returns>
  232. [Function("set-scstats-type")]
  233. public async Task<HttpResponseData> SetSchoolStatsType([HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequestData req)
  234. {
  235. var response = req.CreateResponse(HttpStatusCode.OK);
  236. dynamic jsondata = new ExpandoObject();
  237. try
  238. {
  239. string data = await new StreamReader(req.Body).ReadToEndAsync();
  240. var json = JsonDocument.Parse(data).RootElement;
  241. jsondata = json;
  242. var cosmosClient = _azureCosmos.GetCosmosClient();
  243. string scId = null, type = null;
  244. long careDate = 0;
  245. int all = 0;
  246. int interaction = 0;
  247. int lessType = 0;
  248. DateTimeOffset dateOff = DateTimeOffset.UtcNow;
  249. if (json.TryGetProperty("scId", out JsonElement _schoolId))
  250. scId = $"{_schoolId}";
  251. if (json.TryGetProperty("type", out JsonElement _type))
  252. type = $"{_type}";
  253. if (string.IsNullOrEmpty($"{_schoolId}") && string.IsNullOrEmpty($"{_type}"))
  254. {
  255. await _dingDing.SendBotMsg($"set-scstats-type, {json}", GroupNames.成都开发測試群組);
  256. return response;
  257. }
  258. if (json.TryGetProperty("cnt", out JsonElement _cnt))
  259. all = _cnt.GetInt32();
  260. if (json.TryGetProperty("interaction", out JsonElement _interaction))
  261. interaction = _interaction.GetInt32();
  262. if (json.TryGetProperty("lessType", out JsonElement _lessType))
  263. lessType = _lessType.GetInt32();
  264. if (json.TryGetProperty("date", out JsonElement _date))
  265. careDate = _date.GetInt64();
  266. else
  267. careDate = dateOff.ToUnixTimeMilliseconds();
  268. var (lastWeekS, lastWeekE) = TimeHelper.GetStartOrEnd(dateOff, "lastweek"); //计算上周开始/结束时间
  269. var (weekS, weekE) = TimeHelper.GetStartOrEnd(dateOff, "week"); //计算本周开始/结束时间
  270. var (lastMonthS, lastMonthE) = TimeHelper.GetStartOrEnd(dateOff, "lastMonth"); //上月开始/结束时间
  271. var (monthS, monthE) = TimeHelper.GetStartOrEnd(dateOff, "month"); //本月开始/结束时间
  272. var (lastTermS, lastTermE) = TimeHelper.GetStartOrEnd(dateOff, "lastterm"); //计算上学期开始/结束时间
  273. var (termS, termE) = TimeHelper.GetStartOrEnd(dateOff, "term"); //计算本学期开始/结束时间
  274. var (weekDayS, weekDayE) = TimeHelper.GetLongToTime(weekS, weekE);
  275. var (lWeekDayS, lWeekDayE) = TimeHelper.GetLongToTime(lastWeekS, lastWeekE);
  276. var (lTermDayS, lTermDayE) = TimeHelper.GetLongToTime(lastTermS, lastTermE);
  277. var (termDayS, termDayE) = TimeHelper.GetLongToTime(lastTermS, lastTermE);
  278. var (lMonthS, lMonthE) = TimeHelper.GetLongToTime(lastMonthS, lastMonthE);
  279. var (monthDayS, monthDayE) = TimeHelper.GetLongToTime(monthS, monthE);
  280. var lastDay = dateOff.AddDays(-1);
  281. int lmthDay = TimeHelper.GetDateDay(lMonthE);
  282. StatsInfo statsInfo = new();
  283. var resStsInfo = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{dateOff.Year}-{scId}", new PartitionKey("Statistics"));
  284. if (resStsInfo.Status == 200)
  285. {
  286. using var fileJson = await JsonDocument.ParseAsync(resStsInfo.ContentStream);
  287. statsInfo = fileJson.ToObject<StatsInfo>();
  288. }
  289. else
  290. {
  291. var resLastStsInfo = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{dateOff.Year - 1}-{scId}", new PartitionKey("Statistics"));
  292. if (resLastStsInfo.Status == 200)
  293. {
  294. using var fileJson = await JsonDocument.ParseAsync(resStsInfo.ContentStream);
  295. statsInfo = fileJson.ToObject<StatsInfo>();
  296. statsInfo.id = $"{dateOff.Year}-{scId}";
  297. statsInfo.year = dateOff.Year;
  298. statsInfo.stuYear = new double[366].ToList();
  299. statsInfo.tchYear = new double[366].ToList();
  300. statsInfo.lesson.year = new double[366].ToList();
  301. statsInfo.lesson.yearInters = new double[366].ToList();
  302. statsInfo.activity.year = new double[366].ToList();
  303. }
  304. else
  305. {
  306. ScBase scBase = await cosmosClient.GetContainer("TEAMModelOS", "School").ReadItemAsync<ScBase>(scId, new PartitionKey("Base"));
  307. statsInfo.id = $"{dateOff.Year}-{scBase.id}";
  308. statsInfo.schoolId = scBase.id;
  309. statsInfo.name = scBase.name;
  310. statsInfo.picture = scBase.picture;
  311. statsInfo.size = scBase.size;
  312. statsInfo.scCreateTime = scBase.createTime;
  313. statsInfo.areaId = scBase.areaId;
  314. statsInfo.upTime = careDate;
  315. }
  316. }
  317. switch ($"{type}")
  318. {
  319. case "Exam":
  320. statsInfo.activity.exam += all;
  321. break;
  322. case "Survey":
  323. statsInfo.activity.survey += all;
  324. break;
  325. case "Vote":
  326. statsInfo.activity.vote += all;
  327. break;
  328. case "Homework":
  329. statsInfo.activity.homework += all;
  330. break;
  331. case "Less":
  332. //课例
  333. statsInfo.lesson.year[dateOff.DayOfYear] += all;
  334. statsInfo.lesson.all += all;
  335. if (lessType == 0)
  336. statsInfo.lesson.open += all;
  337. else
  338. statsInfo.lesson.less += all;
  339. statsInfo.lesson.lastDay = ((int)statsInfo.lesson.year[lastDay.DayOfYear]);
  340. statsInfo.lesson.day = ((int)statsInfo.lesson.year[dateOff.DayOfYear]);
  341. var lessList = DenseMatrix.OfColumns(new List<List<double>>() { statsInfo.lesson.year });
  342. statsInfo.lesson.lastWeek = ((int)lessList.SubMatrix(lWeekDayS.DayOfYear, 7, 0, lessList.ColumnCount).ColumnSums().Sum());
  343. statsInfo.lesson.week = ((int)lessList.SubMatrix(weekDayS.DayOfYear, (dateOff.DayOfYear - weekDayS.DayOfYear), 0, lessList.ColumnCount).ColumnSums().Sum());
  344. if (lastTermS <= statsInfo.lesson.upTime && statsInfo.lesson.upTime <= lastTermE)
  345. {
  346. if (lTermDayS.Year < dateOff.Year)
  347. {
  348. var lastLessSts = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{lTermDayS.Year}-{scId}", new PartitionKey("Statistics"));
  349. if (lastLessSts.Status == 200)
  350. {
  351. using var fileJson = await JsonDocument.ParseAsync(lastLessSts.ContentStream);
  352. var tempSts = fileJson.ToObject<StatsInfo>();
  353. var actYer = DenseMatrix.OfColumns(new List<List<double>>() { tempSts.lesson.year, statsInfo.lesson.year });
  354. statsInfo.lesson.lastTerm = ((int)actYer.SubMatrix(lTermDayS.DayOfYear, lTermDayE.DayOfYear, 0, 1).ColumnSums().Sum());
  355. }
  356. }
  357. }
  358. if (termS <= statsInfo.lesson.upTime && statsInfo.lesson.upTime <= termE)
  359. {
  360. if (termDayS.Year < dateOff.Year)
  361. {
  362. var lastSts = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{termDayS.Year}-{scId}", new PartitionKey("Statistics"));
  363. if (lastSts.Status == 200)
  364. {
  365. using var fileJson = await JsonDocument.ParseAsync(lastSts.ContentStream);
  366. var tempSts = fileJson.ToObject<StatsInfo>();
  367. var actYer = DenseMatrix.OfColumns(new List<List<double>>() { tempSts.lesson.year, statsInfo.lesson.year });
  368. statsInfo.lesson.term = ((int)actYer.SubMatrix(termDayS.DayOfYear, termDayE.DayOfYear, 0, 1).ColumnSums().Sum());
  369. }
  370. else
  371. statsInfo.lesson.term += all;
  372. }
  373. }
  374. statsInfo.lesson.lastMonth = ((int)lessList.SubMatrix(lMonthS.DayOfYear, lmthDay, 0, lessList.ColumnCount).ColumnSums().Sum());
  375. statsInfo.lesson.month += ((int)lessList.SubMatrix(monthDayS.DayOfYear, (dateOff.DayOfYear - monthDayS.DayOfYear), 0, lessList.ColumnCount).ColumnSums().Sum());
  376. //课例互动
  377. statsInfo.lesson.yearInters[dateOff.DayOfYear] += interaction;
  378. statsInfo.lesson.allInter += interaction;
  379. statsInfo.lesson.lastDayInter = ((int)statsInfo.lesson.yearInters[lastDay.DayOfYear]);
  380. statsInfo.lesson.dayInter = ((int)statsInfo.lesson.yearInters[dateOff.DayOfYear]);
  381. var interList = DenseMatrix.OfColumns(new List<List<double>>() { statsInfo.lesson.yearInters });
  382. statsInfo.lesson.lastMonthInter = ((int)interList.SubMatrix(lMonthS.DayOfYear, lmthDay, 0, interList.ColumnCount).ColumnSums().Sum());
  383. statsInfo.lesson.monthInter += ((int)interList.SubMatrix(monthDayS.DayOfYear, (dateOff.DayOfYear - monthDayS.DayOfYear), 0, interList.ColumnCount).ColumnSums().Sum());
  384. if (lastTermS <= statsInfo.lesson.upTime && statsInfo.lesson.upTime <= lastTermE)
  385. {
  386. if (lTermDayS.Year < dateOff.Year)
  387. {
  388. var lastSts = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{lTermDayS.Year}-{scId}", new PartitionKey("Statistics"));
  389. if (lastSts.Status == 200)
  390. {
  391. using var fileJson = await JsonDocument.ParseAsync(lastSts.ContentStream);
  392. var tempSts = fileJson.ToObject<StatsInfo>();
  393. statsInfo.lesson.lastYearInter = ((int)tempSts.lesson.yearInters.Sum());
  394. }
  395. else
  396. statsInfo.lesson.lastYearInter = 0;
  397. }
  398. }
  399. statsInfo.lesson.upTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  400. break;
  401. case "stu":
  402. statsInfo.stuYear[dateOff.DayOfYear] += all;
  403. statsInfo.stu += all;
  404. statsInfo.dayStu = ((int)statsInfo.stuYear[dateOff.DayOfYear]);
  405. var stuList = DenseMatrix.OfColumns(new List<List<double>>() { statsInfo.stuYear });
  406. statsInfo.weekStu = ((int)stuList.SubMatrix(weekDayS.DayOfYear, (dateOff.DayOfYear - weekDayS.DayOfYear), 0, stuList.ColumnCount).ColumnSums().Sum());
  407. statsInfo.monthStu = ((int)stuList.SubMatrix(monthDayS.DayOfYear, (dateOff.DayOfYear - monthDayS.DayOfYear), 0, stuList.ColumnCount).ColumnSums().Sum());
  408. statsInfo.stuUpTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  409. break;
  410. case "tch":
  411. statsInfo.tchYear[dateOff.DayOfYear] += all;
  412. statsInfo.tch += all;
  413. statsInfo.dayTch = ((int)statsInfo.tchYear[dateOff.DayOfYear]);
  414. var tchList = DenseMatrix.OfColumns(new List<List<double>>() { statsInfo.tchYear });
  415. statsInfo.weekTch = ((int)tchList.SubMatrix(weekDayS.DayOfYear, (dateOff.DayOfYear - weekDayS.DayOfYear), 0, tchList.ColumnCount).ColumnSums().Sum());
  416. statsInfo.monthTch = ((int)tchList.SubMatrix(monthDayS.DayOfYear, (dateOff.DayOfYear - monthDayS.DayOfYear), 0, tchList.ColumnCount).ColumnSums().Sum());
  417. statsInfo.tchUpTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  418. break;
  419. }
  420. if ($"{type}".Equals("Exam") || $"{type}".Equals("Survey") || $"{type}".Equals("Vote") || $"{type}".Equals("Homework"))
  421. {
  422. statsInfo.activity.all += all;
  423. statsInfo.activity.year[dateOff.DayOfYear] += all;
  424. DenseMatrix matris = DenseMatrix.OfColumns(new List<List<double>>() { statsInfo.activity.year });
  425. statsInfo.activity.lastDay = ((int)statsInfo.activity.year[lastDay.DayOfYear]);
  426. statsInfo.activity.dayCnt = ((int)statsInfo.activity.year[dateOff.DayOfYear]);
  427. statsInfo.activity.lastWeek = ((int)matris.SubMatrix(lWeekDayS.DayOfYear, 7, 0, matris.ColumnCount).ColumnSums().Sum());
  428. statsInfo.activity.week = ((int)matris.SubMatrix(weekDayS.DayOfYear, weekDayE.DayOfYear - weekDayS.DayOfYear, 0, matris.ColumnCount).ColumnSums().Sum());
  429. if (lastTermS <= statsInfo.activity.upTime && statsInfo.activity.upTime <= lastTermE)
  430. {
  431. if (lTermDayS.Year < dateOff.Year)
  432. {
  433. var lastSts = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{lTermDayS.Year}-{scId}", new PartitionKey("Statistics"));
  434. if (lastSts.Status == 200)
  435. {
  436. using var fileJson = await JsonDocument.ParseAsync(lastSts.ContentStream);
  437. var tempSts = fileJson.ToObject<StatsInfo>();
  438. var actYer = DenseMatrix.OfColumns(new List<List<double>>() { tempSts.activity.year, statsInfo.activity.year });
  439. statsInfo.activity.lastTerm = ((int)actYer.SubMatrix(lTermDayS.DayOfYear, lTermDayE.DayOfYear, 0, 1).ColumnSums().Sum());
  440. }
  441. else
  442. statsInfo.activity.lastTerm = 0;
  443. }
  444. }
  445. if (termS <= statsInfo.activity.upTime && statsInfo.activity.upTime <= termE)
  446. {
  447. if (termDayS.Year < dateOff.Year)
  448. {
  449. var lastSts = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{termDayS.Year}-{scId}", new PartitionKey("Statistics"));
  450. if (lastSts.Status == 200)
  451. {
  452. using var fileJson = await JsonDocument.ParseAsync(lastSts.ContentStream);
  453. var tempSts = fileJson.ToObject<StatsInfo>();
  454. var actYer = DenseMatrix.OfColumns(new List<List<double>>() { tempSts.activity.year, statsInfo.activity.year });
  455. statsInfo.activity.term = ((int)actYer.SubMatrix(termDayS.DayOfYear, termDayE.DayOfYear, 0, 1).ColumnSums().Sum());
  456. }
  457. else
  458. statsInfo.activity.term += all;
  459. }
  460. else
  461. {
  462. var actYer = DenseMatrix.OfColumns(new List<List<double>>() { statsInfo.activity.year });
  463. statsInfo.activity.term = ((int)actYer.SubMatrix(termDayS.DayOfYear, termDayE.DayOfYear, 0, 1).ColumnSums().Sum());
  464. }
  465. }
  466. statsInfo.activity.lastMonth = ((int)matris.SubMatrix(lMonthS.DayOfYear, lmthDay, 0, matris.ColumnCount).ColumnSums().Sum());
  467. statsInfo.activity.month += ((int)matris.SubMatrix(monthDayS.DayOfYear, (dateOff.DayOfYear - monthDayS.DayOfYear), 0, matris.ColumnCount).ColumnSums().Sum());
  468. statsInfo.activity.upTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  469. }
  470. if (resStsInfo.Status == 200)
  471. statsInfo = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<StatsInfo>(statsInfo, scId, new PartitionKey("Statistics"));
  472. else
  473. statsInfo = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<StatsInfo>(statsInfo, new PartitionKey("Statistics"));
  474. }
  475. catch (Exception ex)
  476. {
  477. await _dingDing.SendBotMsg($"BIFunction, SetSchoolStatsType() \n{ex.Message}\n{ex.StackTrace}\n{jsondata.ToJsonString()}", GroupNames.成都开发測試群組);
  478. }
  479. return response;
  480. }
  481. }
  482. }