ActivityService.cs 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671
  1. using Azure;
  2. using Azure.Cosmos;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.IO;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Text.Json;
  9. using System.Threading.Tasks;
  10. using TEAMModelOS.SDK.DI;
  11. using TEAMModelOS.SDK.Extension;
  12. using TEAMModelOS.SDK;
  13. using TEAMModelOS.SDK.Models;
  14. using TEAMModelOS.SDK.Models.Cosmos.Common;
  15. using TEAMModelOS.SDK.Models.Service;
  16. using HTEXLib.COMM.Helpers;
  17. namespace TEAMModelOS.SDK
  18. {
  19. public class ActivityService
  20. {
  21. public static async Task FixActivity(CosmosClient client, DingDing _dingDing, GroupChange groupChange, string type)
  22. {
  23. try
  24. {
  25. var query = $"SELECT distinct c.owner, c.id,c.code, c.classes,c.stuLists,c.subjects,c.progress,c.scope,c.startTime,c.school,c.creatorId,c.name,c.pk ,c.endTime FROM c " +
  26. $"where (c.status<>404 or IS_DEFINED(c.status) = false ) and c.pk='{type}' " +
  27. $" and (( array_contains(c.classes,'{groupChange.listid}')) or ( array_contains(c.stuLists,'{groupChange.listid}'))or ( array_contains(c.tchLists,'{groupChange.listid}')))";
  28. //$"and A1 in('{groupChange.listid}') ";
  29. List<MQActivity> datas = new List<MQActivity>();
  30. List<string> classId = new List<string>();
  31. classId.Add(groupChange.listid);
  32. if (groupChange.scope.Equals("school", StringComparison.OrdinalIgnoreCase) && !string.IsNullOrEmpty(groupChange.school))
  33. {
  34. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<MQActivity>(queryText: query,
  35. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"{type}-{groupChange.school}") }))
  36. {
  37. datas.Add(item);
  38. }
  39. ///还要处理该学校每个老师发布的班级的
  40. List<SchoolTeacher> teachers = new List<SchoolTeacher>();
  41. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<SchoolTeacher>(queryText: $"SELECT c.id, c.name FROM c",
  42. requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{groupChange.school}") }))
  43. {
  44. teachers.Add(item);
  45. }
  46. foreach (var techer in teachers)
  47. {
  48. var queryTech = $"SELECT distinct c.owner, c.id,c.code, c.classes,c.stuLists,c.subjects,c.progress,c.scope,c.startTime,c.school,c.creatorId,c.name,c.pk ,c.endTime FROM c " +
  49. $" where (c.status<>404 or IS_DEFINED(c.status) = false ) and c.school='{groupChange.school}' and c.pk='{type}'" +
  50. $" and (( array_contains(c.classes,'{groupChange.listid}')) or ( array_contains(c.stuLists,'{groupChange.listid}')))";
  51. // $" and A1 in('{groupChange.listid}') ";
  52. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<MQActivity>(queryText: queryTech,
  53. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"{type}-{techer.id}") }))
  54. {
  55. datas.Add(item);
  56. }
  57. }
  58. }
  59. if (groupChange.scope.Equals("private", StringComparison.OrdinalIgnoreCase) && !string.IsNullOrEmpty(groupChange.creatorId))
  60. {
  61. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<MQActivity>(queryText: query,
  62. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"{type}-{groupChange.creatorId}") }))
  63. {
  64. datas.Add(item);
  65. }
  66. }
  67. long nowtime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  68. foreach (MQActivity activity in datas)
  69. {
  70. //已经完结的不再允许加入,还未开始的。
  71. if (string.IsNullOrEmpty(activity.progress) || activity.progress.Equals("finish") || activity.progress.Equals("pending"))
  72. {
  73. continue;
  74. }
  75. //classId = ExamService.getClasses(activity.classes, activity.stuLists);
  76. List<ExamClassResult> classResults = new List<ExamClassResult>();
  77. List<PaperSimple> standerAnswers = new List<PaperSimple>();
  78. if (type.Equals("Exam"))
  79. {
  80. if (groupChange.scope.Equals("school"))
  81. {
  82. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<ExamClassResult>(queryText: $"select value(c) from c where c.examId = '{activity.id}'",
  83. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"ExamClassResult-{groupChange.school}") }))
  84. {
  85. classResults.Add(item);
  86. }
  87. }
  88. else
  89. {
  90. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<ExamClassResult>(queryText: $"select value(c) from c where c.examId = '{activity.id}'",
  91. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"ExamClassResult-{groupChange.creatorId}") }))
  92. {
  93. classResults.Add(item);
  94. }
  95. }
  96. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<PaperSimple>(
  97. queryText: $"select A0.answers from c join A0 in c.papers where c.id = '{activity.id}'",
  98. requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"{activity.code}") }))
  99. {
  100. standerAnswers.Add(item);
  101. }
  102. }
  103. //stujoin新加入名单的
  104. foreach (Member member in groupChange.stujoin)
  105. {
  106. ExamInfo info = await updateClassResulte(client, classResults, standerAnswers, member, groupChange,activity);
  107. var stucourse = new StuActivity
  108. {
  109. id = activity.id,
  110. scode = activity.code,
  111. name = activity.name,
  112. source = type.Equals("Exam") ? info.source :"",
  113. ext = type.Equals("Exam") ? new Dictionary<string, JsonElement>() { { "type", info.type.ToJsonString().ToObject<JsonElement>() }, { "subjects", info.subjects.ToJsonString().ToObject<JsonElement>() } } : new Dictionary<string, JsonElement>(),
  114. code = $"Activity-{member.code.Replace("Base-", "")}-{member.id}",
  115. scope = activity.scope,
  116. school = activity.school,
  117. creatorId = activity.creatorId,
  118. pk = "Activity",
  119. type = type,
  120. subjects = activity.pk.ToLower().Equals("exam") && activity.subjects.IsNotEmpty() ? new List<string>() { activity.subjects[0].id } : new List<string>() { "" },
  121. startTime = activity.startTime,
  122. endTime = activity.endTime,
  123. blob = activity.blob,
  124. owner = activity.owner,
  125. createTime = nowtime,
  126. taskStatus = -1,
  127. classIds = classId
  128. };
  129. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  130. }
  131. //tmdjoin新加入的
  132. foreach (Member member in groupChange.tmdjoin)
  133. {
  134. ExamInfo info = await updateClassResulte(client, classResults, standerAnswers, member, groupChange,activity);
  135. var stucourse = new StuActivity
  136. {
  137. id = activity.id,
  138. scode = activity.code,
  139. name = activity.name,
  140. source = type.Equals("Exam") ? info.source : "",
  141. ext = type.Equals("Exam") ? new Dictionary<string, JsonElement>() { { "type", info.type.ToJsonString().ToObject<JsonElement>() }, { "subjects", info.subjects.ToJsonString().ToObject<JsonElement>() } } : new Dictionary<string, JsonElement>(),
  142. code = $"Activity-{member.id}",
  143. scope = activity.scope,
  144. school = activity.school,
  145. creatorId = activity.creatorId,
  146. pk = "Activity",
  147. type = type,
  148. subjects = activity.pk.ToLower().Equals("exam") && activity.subjects.IsNotEmpty() ? new List<string>() { activity.subjects[0].id } : new List<string>() { "" },
  149. startTime = activity.startTime,
  150. endTime = activity.endTime,
  151. blob = activity.blob,
  152. owner = activity.owner,
  153. createTime = nowtime,
  154. taskStatus = -1,
  155. classIds = classId
  156. };
  157. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  158. }
  159. //tchjoin新加入的
  160. foreach (Member member in groupChange.tchjoin)
  161. {
  162. //await updateClassResulte(client, classResults, standerAnswers, member.id);
  163. var stucourse = new StuActivity
  164. {
  165. id = activity.id,
  166. scode = activity.code,
  167. name = activity.name,
  168. code = $"Activity-{member.id}",
  169. scope = activity.scope,
  170. school = activity.school,
  171. creatorId = activity.creatorId,
  172. pk = "Activity",
  173. type = type,
  174. subjects = activity.pk.ToLower().Equals("exam") && activity.subjects.IsNotEmpty() ? new List<string>() { activity.subjects[0].id } : new List<string>() { "" },
  175. startTime = activity.startTime,
  176. endTime = activity.endTime,
  177. blob = activity.blob,
  178. owner = activity.owner,
  179. createTime = nowtime,
  180. taskStatus = -1,
  181. classIds = classId
  182. };
  183. await client.GetContainer(Constant.TEAMModelOS, "Teacher").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  184. }
  185. foreach (Member member in groupChange.stuleave)
  186. {
  187. try
  188. {
  189. await updateClassResulte(client, classResults, standerAnswers, member, groupChange,activity);
  190. StuActivity stuActivity = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.code.Replace("Base-", "")}-{member.id}"));
  191. stuActivity.classIds.Remove(groupChange.listid);
  192. if (stuActivity.classIds.IsNotEmpty())
  193. {
  194. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuActivity>(stuActivity, activity.id, new PartitionKey(stuActivity.code));
  195. }
  196. else
  197. {
  198. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.code.Replace("Base-", "")}-{member.id}"));
  199. }
  200. }
  201. catch (CosmosException)
  202. {
  203. continue;
  204. // 继续执行 删除失败
  205. }
  206. }
  207. foreach (Member member in groupChange.tmdleave)
  208. {
  209. try
  210. {
  211. await updateClassResulte(client, classResults, standerAnswers, member, groupChange,activity);
  212. StuActivity stuActivity = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.id}"));
  213. stuActivity.classIds.Remove(groupChange.listid);
  214. if (stuActivity.classIds.IsNotEmpty())
  215. {
  216. await client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync<StuActivity>(stuActivity, activity.id, new PartitionKey(stuActivity.code));
  217. }
  218. else
  219. {
  220. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.id}"));
  221. }
  222. }
  223. catch (CosmosException)
  224. {
  225. continue;
  226. // 继续执行 删除失败
  227. }
  228. }
  229. foreach (Member member in groupChange.tchleave)
  230. {
  231. try
  232. {
  233. StuActivity stuActivity = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.id}"));
  234. stuActivity.classIds.Remove(groupChange.listid);
  235. if (stuActivity.classIds.IsNotEmpty())
  236. {
  237. await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<StuActivity>(stuActivity, activity.id, new PartitionKey(stuActivity.code));
  238. }
  239. else
  240. {
  241. await client.GetContainer(Constant.TEAMModelOS, "Teacher").DeleteItemAsync<StuActivity>(activity.id, new PartitionKey($"Activity-{member.id}"));
  242. }
  243. }
  244. catch (CosmosException)
  245. {
  246. continue;
  247. // 继续执行 删除失败
  248. }
  249. }
  250. }
  251. }
  252. catch (CosmosException e)
  253. {
  254. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixActivity\n{e.Message}\n{e.StackTrace}CosmosException{e.Status}", GroupNames.成都开发測試群組);
  255. }
  256. catch (Exception ex)
  257. {
  258. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixActivity\n{ex.Message}{ex.StackTrace}{groupChange.ToJsonString()}{type}", GroupNames.醍摩豆服務運維群組);
  259. }
  260. }
  261. public static async Task FixStuCourse(CosmosClient client, DingDing _dingDing, GroupChange groupChange)
  262. {
  263. //1.查找学校或教师的课程是否包含该名单的课程。
  264. var query = $"select distinct c.code,c.id,c.no,c.name,c.scope, c.creatorId,c.school from c join A0 in c.schedule where A0.stulist = '{groupChange.listid}'";
  265. List<Course> courses = new List<Course>();
  266. if (groupChange.scope.Equals("school") && !string.IsNullOrEmpty(groupChange.school))
  267. {
  268. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<Course>(queryText: query,
  269. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"Course-{groupChange.school}") }))
  270. {
  271. courses.Add(item);
  272. }
  273. }
  274. if (groupChange.scope.Equals("private") && !string.IsNullOrEmpty(groupChange.creatorId))
  275. {
  276. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIterator<Course>(queryText: query,
  277. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"Course-{groupChange.creatorId}") }))
  278. {
  279. courses.Add(item);
  280. }
  281. }
  282. long nowtime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  283. // await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixStuCourse\n名单发生变更 需要处理的课程\n{courses.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  284. //2.获取课程的id 并尝试添加或移除对应的学生课程记录StuCourse。
  285. foreach (var course in courses)
  286. {
  287. //学生新加入名单的
  288. foreach (Member member in groupChange.stujoin)
  289. {
  290. var stucourse = new StuCourse
  291. {
  292. id = course.id,
  293. scode = course.code,
  294. name = course.name,
  295. code = $"StuCourse-{member.code.Replace("Base-", "")}-{member.id}",
  296. scope = course.scope,
  297. school = course.school,
  298. creatorId = course.creatorId,
  299. pk = "StuCourse",
  300. stulist = new List<string> { groupChange.listid },
  301. createTime = nowtime
  302. };
  303. // await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixStuCourse\n名单发生变更 新建课程中间表\n{stucourse.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  304. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  305. }
  306. //tmd新加入的
  307. foreach (Member member in groupChange.tmdjoin)
  308. {
  309. var stucourse = new StuCourse
  310. {
  311. id = course.id,
  312. scode = course.code,
  313. name = course.name,
  314. code = $"StuCourse-{member.id}",
  315. scope = course.scope,
  316. school = course.school,
  317. creatorId = course.creatorId,
  318. pk = "StuCourse",
  319. stulist = new List<string> { groupChange.listid },
  320. createTime = nowtime
  321. };
  322. // await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-GroupListService-FixStuCourse\n名单发生变更 新建课程中间表\n{stucourse.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  323. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  324. }
  325. //移除名单的。 在点击相关的课程,再去二次校验是否存在,不存在则再去删除。
  326. foreach (var delStu in groupChange.stuleave)
  327. {
  328. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemStreamAsync(course.id, new PartitionKey($"StuCourse-{delStu.code.Replace("Base-", "")}-{delStu.id}"));
  329. }
  330. foreach (var delTmd in groupChange.tmdleave)
  331. {
  332. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemStreamAsync(course.id, new PartitionKey($"StuCourse-{delTmd}"));
  333. }
  334. }
  335. }
  336. public static async Task<string> SaveStuActivity(CosmosClient client, DingDing _dingDing, List<StuActivity> stuActivities, List<StuActivity> tmdActivities, List<StuActivity> tchActivities)
  337. {
  338. try
  339. {
  340. if (stuActivities.IsNotEmpty())
  341. {
  342. foreach (var x in stuActivities)
  343. {
  344. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(x, new PartitionKey(x.code));
  345. }
  346. }
  347. if (tmdActivities.IsNotEmpty())
  348. {
  349. foreach (var x in tmdActivities)
  350. {
  351. await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(x, new PartitionKey(x.code));
  352. }
  353. }
  354. if (tchActivities.IsNotEmpty())
  355. {
  356. foreach (var x in tchActivities)
  357. {
  358. await client.GetContainer(Constant.TEAMModelOS, "Teacher").UpsertItemAsync(x, new PartitionKey(x.code));
  359. }
  360. }
  361. }
  362. catch (Exception ex)
  363. {
  364. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-OS,TriggerStuActivity-SaveStuActivity\n{ex.Message}\n{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
  365. }
  366. return "";
  367. }
  368. public static async Task RefreshStuActivity(CoreAPIHttpService _coreAPIHttpService, CosmosClient client, DingDing _dingDing, string id, string code)
  369. {
  370. MQActivity activity = null;
  371. try
  372. {
  373. var aactivity = await client.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync(id, new Azure.Cosmos.PartitionKey(code));
  374. using var da = await JsonDocument.ParseAsync(aactivity.ContentStream);
  375. activity = da.ToObject<MQActivity>();
  376. }
  377. catch (CosmosException)
  378. {
  379. activity = null;
  380. }
  381. if (activity != null)
  382. {
  383. List<Task<ItemResponse<StuActivity>>> tasks = new List<Task<ItemResponse<StuActivity>>>();
  384. List<string> classes = ExamService.getClasses(activity.classes, activity.stuLists);
  385. (List<RMember> tmdIds, List<RGroupList> classLists) = await GroupListService.GetStutmdidListids(_coreAPIHttpService, client, _dingDing, classes, activity.school);
  386. var students = tmdIds.FindAll(x => x.type == 2);
  387. var tmdids = tmdIds.FindAll(x => x.type == 1);
  388. if (tmdids.IsNotEmpty())
  389. {
  390. foreach (RMember tmdid in tmdids)
  391. {
  392. var response = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemStreamAsync(activity.id, new PartitionKey($"Activity-{tmdid.id}"));
  393. if (response.Status == 200)
  394. {
  395. using var json = await JsonDocument.ParseAsync(response.ContentStream);
  396. StuActivity stu = json.ToObject<StuActivity>();
  397. stu.id = activity.id;
  398. stu.scode = activity.code;
  399. stu.name = activity.name;
  400. stu.source = activity.source;
  401. stu.scope = activity.scope;
  402. stu.school = activity.school;
  403. stu.creatorId = activity.creatorId;
  404. stu.type = activity.pk;
  405. stu.subjects = activity.pk.ToLower().Equals("exam") && activity.subjects.IsNotEmpty() ? new List<string>() { activity.subjects[0].id } : new List<string>() { "" };
  406. stu.startTime = activity.startTime;
  407. stu.endTime = activity.endTime;
  408. stu.blob = activity.blob;
  409. stu.owner = activity.owner;
  410. stu.createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  411. tasks.Add(client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync(stu, stu.id, new PartitionKey(stu.code)));
  412. }
  413. }
  414. }
  415. if (students.IsNotEmpty())
  416. {
  417. foreach (RMember student in students)
  418. {
  419. var response = await client.GetContainer(Constant.TEAMModelOS, "Student").ReadItemStreamAsync(activity.id, new PartitionKey($"Activity-{activity.school}-{student.id}"));
  420. if (response.Status == 200)
  421. {
  422. using var json = await JsonDocument.ParseAsync(response.ContentStream);
  423. StuActivity stu = json.ToObject<StuActivity>();
  424. stu.id = activity.id;
  425. stu.scode = activity.code;
  426. stu.name = activity.name;
  427. stu.source = activity.source;
  428. stu.scope = activity.scope;
  429. stu.school = activity.school;
  430. stu.creatorId = activity.creatorId;
  431. stu.type = activity.pk;
  432. stu.subjects = activity.pk.ToLower().Equals("exam") && activity.subjects.IsNotEmpty() ? new List<string>() { activity.subjects[0].id } : new List<string>() { "" };
  433. stu.startTime = activity.startTime;
  434. stu.endTime = activity.endTime;
  435. stu.blob = activity.blob;
  436. stu.owner = activity.owner;
  437. stu.createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  438. tasks.Add(client.GetContainer(Constant.TEAMModelOS, "Student").ReplaceItemAsync(stu, stu.id, new PartitionKey(stu.code)));
  439. }
  440. //await client.GetContainer(Constant.TEAMModelOS, "Student").UpsertItemAsync(stucourse, new PartitionKey(stucourse.code));
  441. }
  442. }
  443. await Task.WhenAll(tasks);
  444. }
  445. }
  446. public static async Task<ExamInfo> updateClassResulte(CosmosClient client, List<ExamClassResult> classResults, List<PaperSimple> standerAnswers, Member member ,GroupChange change,MQActivity activity)
  447. {
  448. ExamInfo info = new();
  449. try
  450. {
  451. if (classResults.Count > 0)
  452. {
  453. info = await client.GetContainer(Constant.TEAMModelOS, "Common").ReadItemAsync<ExamInfo>(classResults[0].examId, new PartitionKey($"{activity.code}"));
  454. foreach (var item in classResults)
  455. {
  456. if (item.info.id.Equals(change.listid))
  457. {
  458. int index = item.studentIds.IndexOf(member.id);
  459. if (index == -1)
  460. {
  461. List<List<string>> standard = new List<List<string>>();
  462. foreach (PaperSimple simple in standerAnswers)
  463. {
  464. standard = simple.answers;
  465. }
  466. List<double> ansPoint = new List<double>();
  467. List<List<string>> anc = new List<List<string>>();
  468. List<List<Details>> mark = new List<List<Details>>();
  469. foreach (List<string> num in standard)
  470. {
  471. List<string> newAns = new List<string>();
  472. foreach (string san in num)
  473. {
  474. newAns.Add(san);
  475. }
  476. anc.Add(newAns);
  477. ansPoint.Add(-1);
  478. mark.Add(new List<Details>());
  479. }
  480. item.mark.Add(mark);
  481. item.ans.Add(anc);
  482. item.studentIds.Add(member.id);
  483. item.studentScores.Add(ansPoint);
  484. item.studentAnswers.Add(new List<string>());
  485. item.sum.Add(0);
  486. //item.scIds.Add(member.code??"");
  487. item.status.Add(0);
  488. }
  489. else
  490. {
  491. item.mark.RemoveAt(index);
  492. item.ans.RemoveAt(index);
  493. item.studentIds.RemoveAt(index);
  494. item.studentScores.RemoveAt(index);
  495. item.studentAnswers.RemoveAt(index);
  496. item.sum.RemoveAt(index);
  497. //item.scIds.RemoveAt(index);
  498. item.status.RemoveAt(index);
  499. }
  500. try
  501. {
  502. bool isAns = item.studentScores.Exists(s => s.Contains(-1));
  503. if (!isAns)
  504. {
  505. //整合名单
  506. List<string> classes = ExamService.getClasses(info.classes, info.stuLists);
  507. item.progress = true;
  508. info.subjects.ForEach(s =>
  509. {
  510. if (s.classCount != classes.Count)
  511. {
  512. if (s.id.Equals(item.subjectId))
  513. {
  514. s.classCount += 1;
  515. }
  516. }
  517. });
  518. }
  519. long nowTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  520. info.updateTime = nowTime;
  521. await client.GetContainer(Constant.TEAMModelOS, "Common").ReplaceItemAsync(info, info.id, new PartitionKey($"{info.code}"));
  522. }
  523. catch (Exception e)
  524. {
  525. }
  526. }
  527. await client.GetContainer(Constant.TEAMModelOS, "Common").ReplaceItemAsync(item, item.id, new PartitionKey($"{item.code}"));
  528. }
  529. }
  530. }
  531. catch (Exception e)
  532. {
  533. }
  534. return info;
  535. }
  536. public static async Task DeleteActivity(CoreAPIHttpService _coreAPIHttpService, CosmosClient client, DingDing _dingDing, ActivityList activityList)
  537. {
  538. List<(string pId, List<string> gid)> ps = new List<(string pId, List<string> gid)>();
  539. if (activityList.groupLists.Count > 0)
  540. {
  541. var group = activityList.groupLists;
  542. foreach (var keys in group)
  543. {
  544. foreach (KeyValuePair<string, List<string>> pp in keys)
  545. {
  546. ps.Add((pp.Key, pp.Value));
  547. }
  548. }
  549. }
  550. List<string> classes = ExamService.getClasses(activityList.classes, activityList.stuLists);
  551. (List<RMember> tmdIds, List<RGroupList> classLists) = await GroupListService.GetStutmdidListids(_coreAPIHttpService, client, _dingDing, classes, activityList.school, ps);
  552. var addStudentsCls = tmdIds.FindAll(x => x.type == 2);
  553. var addTmdidsCls = tmdIds.FindAll(x => x.type == 1);
  554. List<string> tmds = new List<string>();
  555. if (addTmdidsCls.IsNotEmpty())
  556. {
  557. tmds.AddRange(addTmdidsCls.Select(x => x.id).ToList());
  558. }
  559. List<StuActivity> stuActivities = new List<StuActivity>();
  560. List<StuActivity> tmdActivities = new List<StuActivity>();
  561. List<StuActivity> tchActivities = new List<StuActivity>();
  562. if (tmds.IsNotEmpty())
  563. {
  564. tmds.ForEach(x =>
  565. {
  566. tmdActivities.Add(new StuActivity
  567. {
  568. id = activityList.id,
  569. code = $"Activity-{x}",
  570. });
  571. });
  572. }
  573. if (addStudentsCls.IsNotEmpty())
  574. {
  575. addStudentsCls.ForEach(x =>
  576. {
  577. stuActivities.Add(new StuActivity
  578. {
  579. id = activityList.id,
  580. code = $"Activity-{x.code.Replace("Base-", "")}-{x.id}",
  581. });
  582. });
  583. }
  584. (List<RMember> tchList, List<RGroupList> classInfos) = await GroupListService.GetStutmdidListids(_coreAPIHttpService, client, _dingDing, activityList.tchLists, activityList.school, ps);
  585. (string standard, List<string> tmdids, string school, List<string> update, int statistics) list = (null, null, null, new List<string> { StatisticsService.TeacherVote }, 0);
  586. if (tchList.IsNotEmpty())
  587. {
  588. list.tmdids = tchList.Select(x => x.id).ToList();
  589. School school = null;
  590. if (!string.IsNullOrEmpty(activityList.school))
  591. {
  592. school = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>(activityList.school, new Azure.Cosmos.PartitionKey("Base"));
  593. list.school = school.id;
  594. list.standard = school.standard;
  595. }
  596. tchList.ForEach(x =>
  597. {
  598. tchActivities.Add(new StuActivity
  599. {
  600. id = activityList.id,
  601. code = $"Activity-{x.id}",
  602. });
  603. });
  604. }
  605. await ActivityService.DeleteStuActivity(client, _dingDing, stuActivities, tmdActivities, tchActivities);
  606. }
  607. public static async Task<string> DeleteStuActivity(CosmosClient client, DingDing _dingDing, List<StuActivity> stuActivities, List<StuActivity> tmdActivities, List<StuActivity> tchActivities)
  608. {
  609. try
  610. {
  611. if (stuActivities.IsNotEmpty())
  612. {
  613. foreach (var x in stuActivities)
  614. {
  615. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemStreamAsync(x.id, new PartitionKey(x.code));
  616. }
  617. }
  618. if (tmdActivities.IsNotEmpty())
  619. {
  620. foreach (var x in tmdActivities)
  621. {
  622. await client.GetContainer(Constant.TEAMModelOS, "Student").DeleteItemStreamAsync(x.id, new PartitionKey(x.code));
  623. }
  624. }
  625. if (tchActivities.IsNotEmpty())
  626. {
  627. foreach (var x in tchActivities)
  628. {
  629. await client.GetContainer(Constant.TEAMModelOS, "Teacher").DeleteItemStreamAsync(x.id, new PartitionKey(x.code));
  630. }
  631. }
  632. }
  633. catch (Exception ex)
  634. {
  635. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-OS,TriggerStuActivity-DeleteStuActivity\n{ex.Message}\n{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
  636. }
  637. return "";
  638. }
  639. }
  640. public class ActivityList
  641. {
  642. public string id { get; set; }
  643. public string school { get; set; }
  644. /// <summary>
  645. /// 行政班
  646. /// </summary>
  647. public List<string> classes { get; set; } = new List<string>();
  648. /// <summary>
  649. /// 学生名单(包含自定义个人学生名单,学校教学班)
  650. /// </summary>
  651. public List<string> stuLists { get; set; } = new List<string>();
  652. /// <summary>
  653. /// 教研组名单
  654. /// </summary>
  655. public List<string> tchLists { get; set; } = new List<string>();
  656. public List<Dictionary<string, List<string>>> groupLists { get; set; } = new List<Dictionary<string, List<string>>>();
  657. }
  658. }