ActivityService.cs 38 KB

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