ManageController.cs 46 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860
  1. using ICSharpCode.SharpZipLib.GZip;
  2. using IES.ExamLibrary.Models;
  3. using IES.ExamServer.DI;
  4. using IES.ExamServer.DI.SignalRHost;
  5. using IES.ExamServer.Filters;
  6. using IES.ExamServer.Helper;
  7. using IES.ExamServer.Helpers;
  8. using IES.ExamServer.Models;
  9. using IES.ExamServer.Services;
  10. using Microsoft.AspNetCore.Http;
  11. using Microsoft.AspNetCore.Mvc;
  12. using Microsoft.AspNetCore.SignalR;
  13. using Microsoft.Extensions.Caching.Memory;
  14. using Microsoft.Extensions.Configuration;
  15. using System;
  16. using System.Diagnostics.Eventing.Reader;
  17. using System.Diagnostics.Metrics;
  18. using System.Linq.Expressions;
  19. using System.Net.Http;
  20. using System.Net.Http.Json;
  21. using System.Security.Cryptography.X509Certificates;
  22. using System.Text.Json;
  23. using System.Text.Json.Nodes;
  24. using System.Text.RegularExpressions;
  25. using static IES.ExamServer.Services.ManageService;
  26. using static System.Reflection.Metadata.BlobBuilder;
  27. namespace IES.ExamServer.Controllers
  28. {
  29. [ApiController]
  30. [Route("manage")]
  31. public class ManageController : BaseController
  32. {
  33. private readonly IConfiguration _configuration;
  34. private readonly IHttpClientFactory _httpClientFactory;
  35. private readonly IMemoryCache _memoryCache;
  36. private readonly ILogger<ManageController> _logger;
  37. private readonly LiteDBFactory _liteDBFactory;
  38. private readonly CenterServiceConnectionService _connectionService;
  39. private readonly int DelayMicro = 10;//微观数据延迟
  40. private readonly int DelayMacro = 100;//宏观数据延迟
  41. private readonly IHubContext<SignalRExamServerHub> _signalRExamServerHub;
  42. private readonly DataQueue _dataQueue;
  43. public ManageController(LiteDBFactory liteDBFactory, ILogger<ManageController> logger, IConfiguration configuration,
  44. IHttpClientFactory httpClientFactory, IMemoryCache memoryCache, CenterServiceConnectionService connectionService,
  45. IHubContext<SignalRExamServerHub> signalRExamServerHub, DataQueue dataQueue)
  46. {
  47. _logger = logger;
  48. _configuration=configuration;
  49. _httpClientFactory=httpClientFactory;
  50. _memoryCache=memoryCache;
  51. _liteDBFactory=liteDBFactory;
  52. _connectionService=connectionService;
  53. _signalRExamServerHub=signalRExamServerHub;
  54. _dataQueue=dataQueue;
  55. }
  56. /// <summary>
  57. /// 导出数据
  58. ///通过线上回传数据需要鉴权验证等操作。
  59. ///通过离线包回传数据需要加密操作
  60. /// </summary>
  61. /// <param name="json"></param>
  62. /// <returns></returns>
  63. [HttpPost("export-evaluation-result")]
  64. [AuthToken("admin", "teacher", "visitor")]
  65. public IActionResult ExportEvaluationResult(JsonNode json)
  66. {
  67. string evaluationId = $"{json["evaluationId"]}";
  68. string shortCode = $"{json["shortCode"]}";
  69. string openCode = $"{json["openCode"]}";
  70. string? loginToken = HttpContext.GetXAuth("AuthToken");
  71. EvaluationClient? evaluationClient = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationClient>()
  72. .FindOne(x => x.id!.Equals(evaluationId) && x.openCode!.Equals(openCode));
  73. //已作答
  74. int answerCount = 0;
  75. //未作答
  76. int absentCount = 0;
  77. List<SubjectPushData> subjectPushDatas = new List<SubjectPushData>();
  78. List<SubjectPushData> subjectPushNew = new List<SubjectPushData>();
  79. if (evaluationClient!=null)
  80. {
  81. var datas = _liteDBFactory.GetLiteDatabase().GetCollection<SubjectPushData>()
  82. .Find(x => !string.IsNullOrWhiteSpace(x.evaluationId) && x.evaluationId!.Equals(evaluationId)).ToList();
  83. if (datas.IsNotEmpty())
  84. {
  85. subjectPushDatas.AddRange(datas);
  86. }
  87. var data = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationStudentResult>()
  88. .Find(x => !string.IsNullOrWhiteSpace(x.evaluationId) && x.evaluationId.Equals(evaluationId));
  89. if (data.IsNotEmpty())
  90. {
  91. foreach (var item in data)
  92. {
  93. foreach (var subjectResult in item.subjectResults)
  94. {
  95. if (subjectResult.finished==1)
  96. {
  97. SubjectPushData subjectPushData = new SubjectPushData(subjectResult, item);
  98. subjectPushData.loginToken=loginToken;
  99. if (!datas.Exists(x => x.id!.Equals(subjectPushData.id)))
  100. {
  101. //数据丢失导致的推送SubjectPushData 没有被保存的问题
  102. subjectPushDatas.Add(subjectPushData);
  103. subjectPushNew.Add(subjectPushData);
  104. }
  105. }
  106. else { absentCount++; }
  107. }
  108. }
  109. }
  110. if (subjectPushNew.IsNotEmpty())
  111. {
  112. _liteDBFactory.GetLiteDatabase().GetCollection<SubjectPushData>().Upsert(subjectPushNew);
  113. }
  114. }
  115. answerCount=subjectPushDatas.Count(x => x.finished==1 && x.answers.IsNotEmpty());
  116. absentCount+=subjectPushDatas.Count()-answerCount;
  117. //TODO 以及增加 作答文件的相关数据。
  118. return Ok(new { answerCount, absentCount, subjectPushDatas });
  119. }
  120. /// <summary>
  121. /// 手动推送
  122. ///通过线上回传数据需要鉴权验证等操作。
  123. ///通过离线包回传数据需要加密操作
  124. /// </summary>
  125. /// <param name="json"></param>
  126. /// <returns></returns>
  127. [HttpPost("manual-push")]
  128. [AuthToken("admin", "teacher", "visitor")]
  129. public async Task<IActionResult> ManualPush(JsonNode json)
  130. {
  131. string evaluationId = $"{json["evaluationId"]}";
  132. //string shortCode = $"{json["shortCode"]}";
  133. string openCode = $"{json["openCode"]}";
  134. string deviceId = $"{json["deviceId"]}";
  135. EvaluationClient? evaluationClient = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationClient>()
  136. .FindOne(x => x.id!.Equals(evaluationId) && x.openCode!.Equals(openCode));
  137. int count = 0;
  138. string? loginToken = HttpContext.GetXAuth("AuthToken");
  139. if (evaluationClient!=null)
  140. {
  141. var datas = _liteDBFactory.GetLiteDatabase().GetCollection<SubjectPushData>()
  142. .Find(x => !string.IsNullOrWhiteSpace(x.evaluationId) && x.evaluationId!.Equals(evaluationId)).ToList();
  143. if (datas.IsNotEmpty())
  144. {
  145. foreach (var item in datas)
  146. {
  147. if (item.pushed<=1 && item.finished==1)
  148. {
  149. item.order=count;
  150. item.loginToken=loginToken;
  151. count++;
  152. //_logger.LogInformation($"推送数据加入队列=>>序号:{subjectPushData.order}--学号:{item.studentId}--姓名:{item.studentName}--科目:{subjectResult.subjectName}");
  153. await _dataQueue.TryAddAsync(item);
  154. }
  155. }
  156. }
  157. var data = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationStudentResult>()
  158. .Find(x =>!string.IsNullOrWhiteSpace(x.evaluationId) && x.evaluationId.Equals(evaluationId) );
  159. List<SubjectPushData> subjectPushDatas = new List<SubjectPushData>();
  160. if (data.IsNotEmpty())
  161. {
  162. foreach (var item in data)
  163. {
  164. foreach (var subjectResult in item.subjectResults)
  165. {
  166. if ( subjectResult.finished==1)
  167. {
  168. SubjectPushData subjectPushData= new SubjectPushData(subjectResult, item);
  169. subjectPushData.order=count;
  170. subjectPushData.loginToken=loginToken;
  171. if (!datas.Exists(x => x.id!.Equals(subjectPushData.id)))
  172. {
  173. //数据丢失导致的推送SubjectPushData 没有被保存的问题
  174. subjectPushDatas.Add(subjectPushData);
  175. //未被推送的数据
  176. if (subjectPushData.pushed<=1 && subjectPushData.finished==1)
  177. {
  178. count++;
  179. subjectPushData.pushed=1;
  180. await _dataQueue.TryAddAsync(subjectPushData);
  181. }
  182. }
  183. }
  184. }
  185. }
  186. }
  187. if (subjectPushDatas.IsNotEmpty())
  188. {
  189. _liteDBFactory.GetLiteDatabase().GetCollection<SubjectPushData>().Upsert(subjectPushDatas);
  190. }
  191. }
  192. return Ok(new { code=200, message="推送成功!", count });
  193. }
  194. /// <summary>
  195. /// 清理缓存,列出缓存占用空间,type =list列出,type=clear清理,不能清理近期及正在激活的数据,并且提示清理中暂未上传或者导出的数据。
  196. /// </summary>
  197. /// <param name="json"></param>
  198. /// <returns></returns>
  199. [HttpPost("clean-cache")]
  200. [AuthToken("admin", "teacher", "visitor")]
  201. public async Task<IActionResult> CleanCache(JsonNode json)
  202. {
  203. return Ok();
  204. }
  205. //C#.NET 6 后端与前端流式通信
  206. //https://www.doubao.com/chat/collection/687687510791426?type=Thread
  207. //下载日志记录:1.步骤,检查,2.获取描述信息,3.分类型,4下载文件,5.前端处理,6.返回结果 , 正在下载...==> [INFO]https://www.doubao.com/chat/collection/687687510791426?type=Thread [Size=180kb] Ok...
  208. //进度条 展示下载文件总大小和已下载,末尾展示 文件总个数和已下载个数
  209. //https://cdnjs.cloudflare.com/ajax/libs/microsoft-signalr/8.0.7/signalr.min.js
  210. /* int data = 0,blob=0, groupList=0
  211. {
  212. "evaluationId":"idssss",
  213. "shortCode":"1234567890",
  214. "ownerId":"hbcn/tmdid",
  215. "data":1,
  216. "blob":1,
  217. "groupList":1
  218. }
  219. */
  220. //如果要访问中心,则需要教师登录联网。
  221. [HttpPost("download-package-music")]
  222. [AuthToken("admin", "teacher", "visitor")]
  223. public async Task<IActionResult> DownloadPackageMusic(JsonNode json)
  224. {
  225. return Ok();
  226. }
  227. [HttpPost("download-package")]
  228. [AuthToken("admin", "teacher", "visitor")]
  229. public async Task<IActionResult> DownloadPackage(JsonNode json)
  230. {
  231. var token = GetAuthTokenInfo();
  232. //检查试卷文件完整性
  233. List<string> successMsgs = new List<string>();
  234. List<string> errorMsgs = new List<string>();
  235. EvaluationCheckFileResult result = new EvaluationCheckFileResult() { successMsgs=successMsgs, errorMsgs=errorMsgs };
  236. if (token.scope.Equals(ExamConstant.ScopeTeacher) || token.scope.Equals(ExamConstant.ScopeVisitor))
  237. {
  238. if (_connectionService.centerIsConnected)
  239. {
  240. Teacher? teacher = _liteDBFactory.GetLiteDatabase().GetCollection<Teacher>().FindOne(x => x.id!.Equals(token.id));
  241. string id = $"{json["evaluationId"]}";
  242. string shortCode = $"{json["shortCode"]}";
  243. string deviceId = $"{json["deviceId"]}";
  244. EvaluationClient? evaluationClient = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationClient>().FindOne(x => x.id!.Equals(id) && x.shortCode!.Equals(shortCode));
  245. if (teacher != null && evaluationClient!= null)
  246. {
  247. var dataInfo= await GetEvaluationFromCenter(GetXAuthToken(), _configuration, _httpClientFactory, shortCode, evaluationClient.id!);
  248. if (dataInfo.centerCode.Equals("200")&& dataInfo.evaluationCloud!=null)
  249. {
  250. string? CenterUrl = _configuration.GetValue<string>("ExamServer:CenterUrl");
  251. var client = _httpClientFactory.CreateClient();
  252. if (client.DefaultRequestHeaders.Contains(Constant._X_Auth_AuthToken))
  253. {
  254. client.DefaultRequestHeaders.Remove(Constant._X_Auth_AuthToken);
  255. }
  256. client.DefaultRequestHeaders.Add(Constant._X_Auth_AuthToken, teacher.x_auth_token);
  257. HttpResponseMessage message = await client.PostAsJsonAsync($"{CenterUrl}/blob/sas-read", new { containerName = $"{dataInfo.evaluationCloud.ownerId}" });
  258. string sas = string.Empty;
  259. string url = string.Empty;
  260. string cnt = string.Empty;
  261. if (message.IsSuccessStatusCode)
  262. {
  263. //url sas timeout name
  264. string content = await message.Content.ReadAsStringAsync();
  265. JsonNode? jsonNode = content.ToObject<JsonNode>();
  266. if (jsonNode != null)
  267. {
  268. sas = $"{jsonNode["sas"]}";
  269. cnt = $"{jsonNode["name"]}";
  270. url = $"{jsonNode["url"]}";
  271. }
  272. }
  273. var httpClient = _httpClientFactory.CreateClient();
  274. string packagePath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "package");
  275. string evaluationPath = Path.Combine(packagePath, dataInfo.evaluationCloud.id!);
  276. //删除文件夹
  277. FileHelper.DeleteFolder(evaluationPath);
  278. string evaluationDataPath = Path.Combine(evaluationPath, "data");
  279. if (!Directory.Exists(evaluationDataPath))
  280. {
  281. Directory.CreateDirectory(evaluationDataPath);
  282. }
  283. string evaluationData = string.Empty;
  284. {
  285. //evaluation
  286. string evaluationUrl = $"{url}/{cnt}/package/{json["evaluationId"]}/data/evaluation.json?{sas}";
  287. HttpResponseMessage dataMessage = await httpClient.GetAsync(evaluationUrl);
  288. if (dataMessage.IsSuccessStatusCode)
  289. {
  290. var content = await dataMessage.Content.ReadAsStringAsync();
  291. evaluationData=content;
  292. string path_evaluation = Path.Combine(evaluationDataPath, "evaluation.json");
  293. await System.IO.File.WriteAllTextAsync(path_evaluation, content);
  294. successMsgs.Add("评测信息文件evaluation.json文件下载成功!");
  295. }
  296. else
  297. {
  298. errorMsgs.Add("评测信息文件evaluation.json文件下载失败!");
  299. }
  300. }
  301. {
  302. //source.json
  303. string sourceUrl = $"{url}/{cnt}/package/{json["evaluationId"]}/data/source.json?{sas}";
  304. HttpResponseMessage dataMessage = await httpClient.GetAsync(sourceUrl);
  305. if (dataMessage.IsSuccessStatusCode)
  306. {
  307. var content = await dataMessage.Content.ReadAsStringAsync();
  308. string path_source = Path.Combine(evaluationDataPath, "source.json");
  309. await System.IO.File.WriteAllTextAsync(path_source, content);
  310. successMsgs.Add("评测数据原始文件source.json文件下载成功!");
  311. }
  312. else
  313. {
  314. errorMsgs.Add("评测数据原始文件source.json文件下载失败!");
  315. }
  316. }
  317. {
  318. //grouplist.json
  319. string grouplistUrl = $"{url}/{cnt}/package/{json["evaluationId"]}/data/grouplist.json?{sas}";
  320. HttpResponseMessage groupListMessage = await httpClient.GetAsync(grouplistUrl);
  321. if (groupListMessage.IsSuccessStatusCode)
  322. {
  323. var content = await groupListMessage.Content.ReadAsStringAsync();
  324. string path_groupList = Path.Combine(evaluationDataPath, "grouplist.json");
  325. await System.IO.File.WriteAllTextAsync(path_groupList, content);
  326. successMsgs.Add("评测名单grouplist.json文件下载成功!");
  327. }
  328. else
  329. {
  330. errorMsgs.Add("评测名单grouplist.json文件下载失败!");
  331. }
  332. }
  333. {
  334. //下载试卷文件
  335. List<EvaluationExam>? evaluationExams = evaluationData.ToObject<JsonNode>()?["evaluationExams"]?.ToObject<List<EvaluationExam>>();
  336. foreach (var evaluationExam in evaluationExams!)
  337. {
  338. foreach (var evaluationPaper in evaluationExam.papers)
  339. {
  340. string path_paper = Path.Combine(evaluationPath, $"papers/{evaluationPaper.paperId}");
  341. if (!Directory.Exists(path_paper))
  342. {
  343. Directory.CreateDirectory(path_paper);
  344. }
  345. //最多开启10个线程并行下载
  346. var parallelOptions = new ParallelOptions { MaxDegreeOfParallelism = 5 };
  347. // 使用 Parallel.ForEachAsync 并行处理每个 blob
  348. await Parallel.ForEachAsync(evaluationPaper.blobs, parallelOptions, async (blob, cancellationToken) =>
  349. {
  350. try
  351. {
  352. // 下载 Blob 文件到本地
  353. httpClient.Timeout = TimeSpan.FromSeconds(300);
  354. HttpResponseMessage blobMessage = await httpClient.GetAsync($"{url}/{cnt}/{blob.path}?{sas}", cancellationToken);
  355. if (blobMessage.IsSuccessStatusCode)
  356. {
  357. byte[] bytes = await blobMessage.Content.ReadAsByteArrayAsync(cancellationToken);
  358. string? extension = Path.GetExtension(blob.path);
  359. if (extension!=null)
  360. {
  361. if (extension.Equals(extension.ToUpper()))
  362. {
  363. string? fileNameWithoutExtension = Path.GetFileNameWithoutExtension(blob.path);
  364. await System.IO.File.WriteAllBytesAsync(Path.Combine(path_paper, $"{fileNameWithoutExtension!}_1{extension}"), bytes, cancellationToken);
  365. }
  366. else
  367. {
  368. string? fileName = Path.GetFileName(blob.path);
  369. await System.IO.File.WriteAllBytesAsync(Path.Combine(path_paper, fileName!), bytes, cancellationToken);
  370. }
  371. }
  372. }
  373. else
  374. {
  375. string? error = await blobMessage.Content.ReadAsStringAsync(cancellationToken);
  376. errorMsgs.Add($"{evaluationExam.subjectName},{evaluationPaper.paperName},{blob.path}文件下载失败,{blobMessage.StatusCode},{error}");
  377. // Console.WriteLine($"Error downloading {blob.path},{blobMessage.StatusCode},{error}");
  378. }
  379. }
  380. catch (Exception ex)
  381. {
  382. errorMsgs.Add($"{evaluationExam.subjectName},{evaluationPaper.paperName},{blob.path}文件下载错误,{ex.Message}");
  383. // 处理异常
  384. //Console.WriteLine($"Error downloading {blob.path}: {ex.Message}");
  385. }
  386. });
  387. }
  388. }
  389. }
  390. _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationClient>().Upsert(dataInfo.evaluationCloud!);
  391. (successMsgs, errorMsgs) = await ManageService.CheckFile(dataInfo.evaluationCloud!, successMsgs, errorMsgs, _signalRExamServerHub, _memoryCache, _logger, deviceId, evaluationPath);
  392. //下载完成后,对数据进行检查,然后在加密压缩。
  393. string zipPath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "zip");
  394. if (!Directory.Exists(zipPath))
  395. {
  396. Directory.CreateDirectory(zipPath);
  397. }
  398. string zipFilePath = Path.Combine(zipPath, $"{dataInfo.evaluationCloud.id}-{dataInfo.evaluationCloud.blobHash}.zip");
  399. var zipInfo = ZipHelper.CreatePasswordProtectedZip(evaluationPath, zipFilePath, dataInfo.evaluationCloud.openCode!);
  400. if (zipInfo.res)
  401. {
  402. successMsgs.Add("评测数据压缩包创建成功!");
  403. }
  404. else
  405. {
  406. errorMsgs.Add("评测数据压缩包创建失败!");
  407. }
  408. }
  409. else {
  410. errorMsgs.Add($"云端数据检测结果:{dataInfo. centerMsg},状态:{dataInfo. centerCode}");
  411. }
  412. }
  413. else
  414. {
  415. string teacherMsg = teacher==null ? "未找到教师信息" : "";
  416. string evaluationMsg = evaluationClient==null ? "未找到评测信息" : "";
  417. errorMsgs.Add($"用户信息或未找到评测信息!{teacherMsg}{evaluationMsg}");
  418. }
  419. }
  420. else {
  421. errorMsgs.Add($"云端数据中心未连接");
  422. }
  423. }
  424. else
  425. {
  426. errorMsgs.Add($"请使用教师或访客账号登录!");
  427. }
  428. result.checkError=result.errorMsgs.Count();
  429. result.checkSuccess=result.successMsgs.Count();
  430. result.checkTotal=result.checkSuccess+result.checkError;
  431. if (result.errorMsgs.Count()==0)
  432. {
  433. return Ok(new { code = 200, msg = "下载成功!", result });
  434. }
  435. else {
  436. return Ok(new { code = 1, msg = "下载失败!", result });
  437. }
  438. }
  439. /// <summary>
  440. /// 输入开卷码,查询评测信息,并返回数据。
  441. /// </summary>
  442. /// <param name="json"></param>
  443. /// <returns></returns>
  444. [HttpPost("open-evaluation")]
  445. [AuthToken("admin", "teacher", "visitor")]
  446. public async Task<IActionResult> OpenEvaluation(JsonNode json)
  447. {
  448. string deviceId = $"{json["deviceId"]}";
  449. string evaluationId = $"{json["evaluationId"]}";
  450. string openCode = $"{json["openCode"]}";
  451. string shortCode = $"{json["shortCode"]}";
  452. var token = GetAuthTokenInfo();
  453. List<string> successMsgs = new List<string>();
  454. List<string> errorMsgs = new List<string>();
  455. EvaluationCheckFileResult result = new EvaluationCheckFileResult() { successMsgs=successMsgs, errorMsgs =errorMsgs };
  456. if (!string.IsNullOrEmpty(openCode) && !string.IsNullOrEmpty(evaluationId))
  457. {
  458. EvaluationClient? evaluationLocal = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationClient>().FindOne(x => x.id!.Equals(evaluationId) && x.openCode!.Equals(openCode) && x.shortCode!.Equals(shortCode));
  459. if (evaluationLocal!=null)
  460. {
  461. //ManageService.CheckData(evaluationLocal, null, successMsgs, errorMsgs, _liteDBFactory);
  462. await _signalRExamServerHub.SendMessage(_memoryCache, _logger, deviceId, Constant._Message_grant_type_check_file,
  463. new MessageContent { dataId=evaluationLocal.id, dataName=evaluationLocal.name, messageType=Constant._Message_type_message, status=0, content="开始检查评测信息文件.." });
  464. //判断文件包的压缩包是否存在。
  465. string zipPath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "zip");
  466. //校验本地文件数据
  467. string packagePath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "package");
  468. string evaluationPath = Path.Combine(packagePath, evaluationLocal.id!);
  469. if (System.IO.File.Exists(Path.Combine(zipPath, $"{evaluationLocal.id}-{evaluationLocal.blobHash}.zip")))
  470. {
  471. string key = $"{Constant._KeyEvaluationZipExtract}:{evaluationId}:{openCode}";
  472. successMsgs.Add("加载评测试卷文件包!");
  473. //string keyData = _memoryCache.Get<string>(key);
  474. //if (!string.IsNullOrWhiteSpace(keyData))
  475. //{
  476. //}
  477. //else {
  478. //}
  479. //删除文件夹
  480. FileHelper.DeleteFolder(evaluationPath);
  481. if (!Directory.Exists(evaluationPath))
  482. {
  483. Directory.CreateDirectory(evaluationPath);
  484. }
  485. //解压文件包
  486. var extractRes = ZipHelper.ExtractPasswordProtectedZip(Path.Combine(zipPath, $"{evaluationLocal.id}-{evaluationLocal.blobHash}.zip"), evaluationPath, evaluationLocal.openCode!);
  487. if (extractRes.res)
  488. {
  489. _memoryCache.Set(key,key,TimeSpan.FromSeconds(30));
  490. successMsgs.Add("评测试卷文件包解压成功!");
  491. (successMsgs, errorMsgs) = await ManageService.CheckFile(evaluationLocal, successMsgs, errorMsgs, _signalRExamServerHub, _memoryCache, _logger, deviceId, evaluationPath);
  492. }
  493. else {
  494. errorMsgs.Add("评测试卷文件包解压失败!");
  495. //return Ok(new { code = 3, msg = "评测试卷文件包解压失败!" });
  496. }
  497. }
  498. else {
  499. errorMsgs.Add("评测试卷文件包不存在!");
  500. //return Ok(new { code = 3, msg = "评测试卷文件包不存在!" });
  501. }
  502. }
  503. else {
  504. errorMsgs.Add("未找到评测信息!");
  505. // return Ok(new { code = 2, msg = "未找到评测信息!" });
  506. }
  507. }
  508. else
  509. {
  510. errorMsgs.Add("评测ID或提取码均未填写!");
  511. // return Ok(new { code = 1, msg = "评测ID或提取码均未填写!" });
  512. }
  513. result.checkTotal = result.errorMsgs.Count() + result.successMsgs.Count();
  514. result.checkError= result.errorMsgs.Count();
  515. result.checkSuccess = result.successMsgs.Count();
  516. if (result.errorMsgs.Count()==0)
  517. {
  518. return Ok(new { code = 200, msg = "校验成功!", result });
  519. }
  520. else
  521. {
  522. return Ok(new { code = 1, msg = "校验失败!", result });
  523. }
  524. }
  525. /// <summary>
  526. /// 检查数据包是否有更新,zip是否存在,数据文件是否完整,名单文件是否完整。
  527. /// 如果有智音模块,则需要检查智音音乐缓存是否完整。
  528. /// </summary>
  529. /// <param name="json"></param>
  530. /// <returns></returns>
  531. [HttpPost("check-evaluation")]
  532. [AuthToken("admin", "teacher", "visitor")]
  533. public async Task<IActionResult> CheckEvaluation(JsonNode json)
  534. {
  535. string shortCode = $"{json["shortCode"]}";
  536. string evaluationId = $"{json["evaluationId"]}";
  537. string checkCenter = $"{json["checkCenter"]}";
  538. string deviceId = $"{json["deviceId"]}";
  539. string centerCode = string.Empty, centerMsg = string.Empty;
  540. Expression<Func<EvaluationClient, bool>> predicate = x => true;
  541. var token = GetAuthTokenInfo();
  542. if (!string.IsNullOrEmpty(shortCode) || !string.IsNullOrEmpty(evaluationId))
  543. {
  544. if (!string.IsNullOrEmpty(shortCode))
  545. {
  546. predicate= predicate.And(x => !string.IsNullOrWhiteSpace(x.shortCode) && x.shortCode.Equals(shortCode));
  547. }
  548. if (!string.IsNullOrWhiteSpace(evaluationId))
  549. {
  550. predicate= predicate.And(x => x.id!.Equals(evaluationId));
  551. }
  552. }
  553. else
  554. {
  555. return Ok(new { code = 400, msg = "评测ID或提取码均未填写!" });
  556. }
  557. IEnumerable<EvaluationClient>? evaluationClients = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationClient>().Find(predicate);
  558. EvaluationClient? evaluationLocal = null;
  559. EvaluationClient? evaluationCloud = null;
  560. if (evaluationClients!=null && evaluationClients.Count()>0)
  561. {
  562. evaluationLocal= evaluationClients.First();
  563. }
  564. List<string> successMsgs = new List<string>();
  565. List<string> errorMsgs = new List<string>();
  566. //从数据中心搜索
  567. if ("1".Equals($"{checkCenter}"))
  568. {
  569. if (_connectionService.centerIsConnected)
  570. {
  571. if (token.scope.Equals(ExamConstant.ScopeTeacher) || token.scope.Equals(ExamConstant.ScopeVisitor))//由于已经绑定学校,访客教师也可以访问中心。
  572. {
  573. Teacher? teacher = _liteDBFactory.GetLiteDatabase().GetCollection<Teacher>().FindOne(x => x.id!.Equals(token.id));
  574. if (teacher != null)
  575. {
  576. (evaluationCloud, centerCode, centerMsg)= await ManageService.GetEvaluationFromCenter(GetXAuthToken(), _configuration,_httpClientFactory,shortCode,evaluationId);
  577. }
  578. else
  579. {
  580. centerCode = $"401";
  581. centerMsg = "当前登录账号未找到";
  582. }
  583. }
  584. }
  585. else
  586. {
  587. centerCode = $"404";
  588. centerMsg = "云端数据中心未连接";
  589. }
  590. if (centerCode.Equals("200"))
  591. {
  592. successMsgs.Add($"云端数据检测结果:{centerMsg},状态:{centerCode}");
  593. }
  594. else
  595. {
  596. errorMsgs.Add($"云端数据检测结果:{centerMsg},状态:{centerCode}");
  597. }
  598. }
  599. EvaluationCheckDataResult checkDataResult;
  600. (checkDataResult, evaluationLocal) = ManageService.CheckData( evaluationLocal, evaluationCloud, successMsgs, errorMsgs, _liteDBFactory);
  601. Dictionary<string, object?>? evaluation = null;
  602. if (evaluationLocal!=null)
  603. {
  604. string zipPath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "zip");
  605. //判断文件包的压缩包是否存在。
  606. if (!System.IO.File.Exists(Path.Combine(zipPath, $"{evaluationLocal.id}-{evaluationLocal.blobHash}.zip")))
  607. {
  608. checkDataResult.zip =1;
  609. checkDataResult.blob=1;
  610. checkDataResult.data=1;
  611. checkDataResult.groupList=1;
  612. checkDataResult.blobSize=evaluationLocal.blobSize;
  613. checkDataResult.dataSize=evaluationLocal.dataSize;
  614. checkDataResult.studentCount=evaluationLocal.studentCount;
  615. errorMsgs.Add($"评测文件包压缩包不存在,需要重新下载评测!");
  616. }
  617. var properties = evaluationLocal.GetType().GetProperties();
  618. evaluation = new Dictionary<string, object?>();
  619. foreach (var property in properties)
  620. {
  621. if (!property.Name.Equals("openCode"))
  622. {
  623. evaluation[property.Name] = property.GetValue(evaluationLocal);
  624. }
  625. }
  626. }
  627. return Ok(new
  628. {
  629. code = 200,
  630. evaluation = evaluation,
  631. result = checkDataResult
  632. });
  633. }
  634. /// <summary>
  635. /// 获取当前评测的开考设置信息
  636. /// </summary>
  637. /// <param name="json"></param>
  638. /// <returns></returns>
  639. [HttpPost("list-evaluation-round")]
  640. [AuthToken("admin", "teacher", "visitor")]
  641. public IActionResult ListEvaluationRound(JsonNode json)
  642. {
  643. string evaluationId = $"{json["evaluationId"]}";
  644. string openCode = $"{json["openCode"]}";
  645. string shortCode = $"{json["shortCode"]}";
  646. EvaluationClient? evaluationClient = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationClient>()
  647. .FindOne(x => x.id!.Equals(evaluationId) && x.shortCode!.Equals(shortCode) && x.openCode!.Equals(openCode));
  648. if (evaluationClient!=null)
  649. {
  650. IEnumerable<EvaluationRoundSetting>? settings = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationRoundSetting>().Find(x => x.evaluationId!.Equals(evaluationClient.id)).OrderByDescending(x => x.activate).ThenByDescending(x => x.startline).ThenByDescending(x => x.createTime);
  651. if (settings.IsNotEmpty())
  652. {
  653. return Ok(new { code = 200, msg = "OK", settings = settings });
  654. }
  655. else
  656. {
  657. return Ok(new { code = 2, msg = "未设置开考信息!" });
  658. }
  659. }
  660. else
  661. {
  662. return Ok(new { code = 1, msg = "未找到评测信息!" });
  663. }
  664. }
  665. /// <summary>
  666. /// 获取当前评测的开考设置信息
  667. /// </summary>
  668. /// <param name="json"></param>
  669. /// <returns></returns>
  670. [HttpPost("load-evaluation-round")]
  671. [AuthToken("admin", "teacher", "visitor")]
  672. public IActionResult LoadEvaluationRound(JsonNode json)
  673. {
  674. string evaluationId = $"{json["evaluationId"]}";
  675. string openCode = $"{json["openCode"]}";
  676. string shortCode = $"{json["shortCode"]}";
  677. string settingId = $"{json["settingId"]}";
  678. EvaluationClient? evaluationClient = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationClient>()
  679. .FindOne(x => x.id!.Equals(evaluationId) && x.shortCode!.Equals(shortCode) && x.openCode!.Equals(openCode));
  680. EvaluationRoundSetting? setting = null;
  681. if (evaluationClient!=null)
  682. {
  683. setting = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationRoundSetting>().FindOne(x =>x.id!.Equals(settingId) && x.evaluationId!.Equals(evaluationClient.id));
  684. if (setting!=null)
  685. {
  686. IEnumerable<EvaluationStudentResult>? results = null;
  687. var members = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationMember>().Find(x => x.evaluationId!.Equals(evaluationClient.id) && x.roundId!.Equals(setting.id));
  688. //并获取学生的作答信息
  689. //顺便返回本轮的学生名单
  690. if (members!=null && members.Count()>0)
  691. {
  692. results = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationStudentResult>()
  693. .Find(x => members.Select(x => x.id).Contains(x.studentId)&&!string.IsNullOrWhiteSpace(x.evaluationId) && x.evaluationId.Equals(evaluationClient.id));
  694. if (results.Count()==members.Count())
  695. {
  696. return Ok(new { code = 200, setting, results });
  697. }
  698. else {
  699. return Ok(new { code = 200,msg="学生作答信息数量不匹配", setting, results });
  700. }
  701. }
  702. else
  703. {
  704. return Ok(new { code = 200,msg="未分配学生名单,或名单没有学生!", setting , results });
  705. }
  706. }
  707. else
  708. {
  709. return Ok(new { code = 2, msg = "未设置开考信息!" });
  710. }
  711. }
  712. else {
  713. return Ok(new { code = 1, msg = "未找到评测信息!" });
  714. }
  715. }
  716. /// <summary>
  717. /// 设置评测开考信息(本轮名单,计时规则,分配试卷等)
  718. /// </summary>
  719. /// <param name="json"></param>
  720. /// <returns></returns>
  721. [HttpPost("setting-evaluation-round")]
  722. [AuthToken("admin", "teacher", "visitor")]
  723. public IActionResult SettingEvaluationRound(JsonNode json)
  724. {
  725. EvaluationRoundSetting? setting = json.ToObject<EvaluationRoundSetting>();
  726. if (setting!=null)
  727. {
  728. var db = _liteDBFactory.GetLiteDatabase();
  729. var collection = db.GetCollection<EvaluationClient>() ;
  730. //&& x.openCode!.Equals($"{json["openCode"]}")&& x.shortCode!.Equals($"{json["shortCode"]}")
  731. string shortCode = $"{json["shortCode"]}";
  732. string openCode = $"{json["openCode"]}";
  733. EvaluationClient ? evaluationClient = collection.FindOne(x => x.id!.Equals(setting.evaluationId)
  734. && !string.IsNullOrWhiteSpace(x.shortCode) && x.shortCode.Equals(x.shortCode)
  735. && !string.IsNullOrWhiteSpace(x.openCode) && x.openCode.Equals(openCode) );
  736. if (evaluationClient!=null)
  737. {
  738. IEnumerable<EvaluationRoundSetting> settings = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationRoundSetting>().Find(x => x.evaluationId!.Equals(evaluationClient.id));
  739. if (settings != null && settings.Count() > 0)
  740. {
  741. var datas = settings.ToList();
  742. foreach (EvaluationRoundSetting item in datas)
  743. {
  744. item.activate = 0;
  745. }
  746. _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationRoundSetting>().Upsert(datas);
  747. }
  748. /// 判断是否包含所有分组
  749. bool isAllContained = setting.groupList.All(x => evaluationClient.grouplist.Any(y => y.id == x.id));
  750. if (isAllContained && evaluationClient.grouplist.IsNotEmpty())
  751. {
  752. var ids= setting.groupList.Select(x => x.id).OrderBy(x=>x);
  753. //增加排序,保证id的唯一性
  754. setting.id=ShaHashHelper.GetSHA1($"{evaluationClient.id}_{string.Join("", ids) }");
  755. setting.createTime= DateTimeOffset.Now.ToUnixTimeMilliseconds();
  756. _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationRoundSetting>().Upsert(setting);
  757. _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationClient>().Upsert(evaluationClient);
  758. /// 分配试卷
  759. var(roundStudentPapers, members, results, code, msg)= ManageService.AssignStudentPaper(evaluationClient, setting,_connectionService, _liteDBFactory, _logger);
  760. //var (roundStudentPapers, members, results,code,msg) = AssignStudentPaper(evaluationClient, setting);
  761. return Ok(new { code = code, msg =msg , setting, results, roundStudentPapers });
  762. }
  763. else
  764. {
  765. return Ok(new { code = 3, msg = "开考名单不在当前评测中!" });
  766. }
  767. }
  768. else { return Ok(new { code = 2, msg = "未找到评测,请确认评测ID、提取码、开卷码是否正确!" }); }
  769. }
  770. else
  771. {
  772. return Ok(new { code = 1, msg = "未完善设置信息!" });
  773. }
  774. }
  775. /// <summary>
  776. /// 加载本地的活动列表
  777. /// </summary>
  778. /// <param name="json"></param>
  779. /// <returns></returns>
  780. [HttpPost("list-local-evaluation")]
  781. [AuthToken("admin", "teacher", "visitor")]
  782. public IActionResult ListLocalEvaluation(JsonNode json)
  783. {
  784. if (!string.IsNullOrWhiteSpace($"{_connectionService.serverDevice?.school?.id}"))
  785. {
  786. string code = $"{_connectionService!.serverDevice!.school!.id}";
  787. IEnumerable<EvaluationClient>? evaluationClients = _liteDBFactory.GetLiteDatabase().GetCollection<EvaluationClient>().Find(x => x.ownerId!.Equals(code)).OrderByDescending(x => x.stime);
  788. if (evaluationClients != null)
  789. {
  790. var result = evaluationClients.Select(client =>
  791. {
  792. var properties = client.GetType().GetProperties();
  793. var anonymousObject = new Dictionary<string, object?>();
  794. foreach (var property in properties)
  795. {
  796. if (!property.Name.Equals("openCode"))
  797. {
  798. anonymousObject[property.Name] = property.GetValue(client);
  799. }
  800. }
  801. return anonymousObject;
  802. });
  803. return Ok(new { code = 200, evaluation = result });
  804. }
  805. else
  806. {
  807. return Ok(new { code = 200, evaluation = new List<EvaluationClient>() });
  808. }
  809. }
  810. else
  811. {
  812. return Ok(new { code = 200, evaluation = new List<EvaluationClient>() });
  813. }
  814. }
  815. }
  816. }