ScsStudyApisService.cs 57 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028
  1. using Azure.Cosmos;
  2. using HTEXLib.COMM.Helpers;
  3. using HTEXLib.Helpers.ShapeHelpers;
  4. using Microsoft.Extensions.Configuration;
  5. using Microsoft.Extensions.DependencyInjection;
  6. using Microsoft.Extensions.Options;
  7. using System;
  8. using System.Collections.Generic;
  9. using System.IO;
  10. using System.Linq;
  11. using System.Net;
  12. using System.Net.Http;
  13. using System.Text;
  14. using System.Text.Json;
  15. using System.Threading.Tasks;
  16. using TEAMModelOS.SDK.Extension;
  17. using TEAMModelOS.SDK.Models;
  18. namespace TEAMModelOS.SDK.DI
  19. {
  20. public static class ScsStudyApisExtensions
  21. {
  22. public static IServiceCollection AddScsStudyApisService(this IServiceCollection services, IConfiguration _configuration, string name = "Default")
  23. {
  24. if(services == null) throw new ArgumentNullException(nameof(services));
  25. string location = _configuration.GetValue<string>("Option:Location");
  26. string url = _configuration.GetValue<string>("HaBookAuth:CoreAPI");
  27. var clientID = _configuration.GetValue<string>("HaBookAuth:CoreService:clientID");
  28. var clientSecret = _configuration.GetValue<string>("HaBookAuth:CoreService:clientSecret");
  29. services.AddScoped<ScsStudyApisService>();
  30. return services;
  31. }
  32. }
  33. public class ScsStudyApisServiceOptions
  34. {
  35. public string location { get; set; }
  36. public string url { get; set; }
  37. public string clientID { get; set; }
  38. public string clientSecret { get; set; }
  39. }
  40. public class ScsStudyApisService
  41. {
  42. private readonly AzureCosmosFactory _azureCosmos;
  43. private readonly DingDing _dingDing;
  44. private readonly AzureStorageFactory _azureStorage;
  45. private readonly AzureRedisFactory _azureRedis;
  46. private readonly ThirdApisService _thirdApisService;
  47. public static string Code { get; set; }
  48. public static Dictionary<string, object> parameterMap = null;
  49. //private readonly IWebHostEnvironment _environment;
  50. public bool check = true;
  51. private SnowflakeId _snowflakeId;
  52. private readonly HttpClient _httpClient;
  53. public readonly IOptionsMonitor<ScsStudyApisServiceOptions> options;
  54. //private readonly IConfiguration _configuration;
  55. // private readonly DI.DingDing _dingDing;
  56. //public readonly Option _option;
  57. public ScsStudyApisService(AzureCosmosFactory azureCosmos, DingDing dingDing, AzureStorageFactory azureStorage, ThirdApisService thirdApisService, AzureRedisFactory azureRedis, HttpClient httpClient, IOptionsMonitor<ScsStudyApisServiceOptions> optionsMonitor, SnowflakeId snowflakeId)
  58. {
  59. _azureCosmos = azureCosmos;
  60. _dingDing = dingDing;
  61. _azureStorage = azureStorage;
  62. _azureRedis = azureRedis;
  63. _thirdApisService = thirdApisService;
  64. _httpClient = httpClient;
  65. options = optionsMonitor;
  66. //_environment = environment;
  67. _snowflakeId = snowflakeId;
  68. //_option = option?.Value;
  69. //_configuration = configuration;
  70. //_dingDing = dingDing;
  71. }
  72. /// <summary>
  73. /// 5.3.1.1获取项目列表
  74. /// </summary>
  75. /// <param name="areaId"></param>
  76. /// <param name="_accessConfig"></param>
  77. /// <returns></returns>
  78. public async Task<(int state,string json)> GetProjectInfoByTrainComIDV2(string areaId, string accessConfig)
  79. {
  80. List<ScProject> projects = new();
  81. //var response = req.CreateResponse(HttpStatusCode.OK);
  82. //List<ScProject> projects = new List<ScProject>();
  83. //string data = await new StreamReader(req.Body).ReadToEndAsync();
  84. //JsonElement accessConfig = data.ToObject<JsonElement>().GetProperty("accessConfig");
  85. //ScAccessConfig config = $"{accessConfig}".ToObject<ScAccessConfig>();
  86. //string areaId = null;
  87. //if (data.ToObject<JsonElement>().TryGetProperty("areaId", out JsonElement _areaId))
  88. //{
  89. // areaId = $"{_areaId}";
  90. //}
  91. ScAccessConfig config = accessConfig.ToObject<JsonElement>().ToObject<ScAccessConfig>();
  92. Code = "GetProjectInfoByTrainComID";
  93. parameterMap = new Dictionary<string, object>();
  94. parameterMap.Add("TrainComID", config.trainComID);
  95. ScsResult result = new() { bizcode = Code, title = "5.3.1.1获取项目列表" };
  96. try
  97. {
  98. result = await _thirdApisService.Post(config.url, Code, config.passKey, config.privateKey, parameterMap);
  99. if (result.result)
  100. {
  101. projects = result.content.ToObject<List<ScProject>>();
  102. }
  103. else
  104. {
  105. }
  106. //await response.WriteAsJsonAsync(new { data = projects.ToJsonString() });
  107. return (200, projects.ToJsonString());
  108. }
  109. catch (Exception ex)
  110. {
  111. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")},IES5.ScApisService:GetProjectInfoByTrainComID\n{ex.Message}\n{ex.StackTrace}\n{result.ToJsonString()}\n{areaId}\n{accessConfig} \n", GroupNames.醍摩豆服務運維群組);
  112. //await response.WriteAsJsonAsync(new { data = projects.ToJsonString() });
  113. return (500, projects.ToJsonString());
  114. }
  115. }
  116. /// <summary>
  117. /// 5.3.1.1获取项目列表
  118. /// </summary>
  119. /// <param name="areaId"></param>
  120. /// <param name="_accessConfig"></param>
  121. /// <returns></returns>
  122. public async Task<(int state, string json)> GetProjectInfoByTrainComID(string areaId, string accessConfig)
  123. {
  124. List<ScProject> projects = new();
  125. ScAccessConfig config = accessConfig.ToObject<JsonElement>().ToObject<ScAccessConfig>();
  126. Code = "GetProjectInfoByTrainComID";
  127. parameterMap = new Dictionary<string, object>();
  128. parameterMap.Add("TrainComID", config.trainComID);
  129. ScsResult result = new() { bizcode = Code, title = "5.3.1.1获取项目列表" };
  130. try
  131. {
  132. result = await _thirdApisService.Post(config.url, Code, config.passKey, config.privateKey, parameterMap);
  133. if (result.result)
  134. {
  135. projects = result.content.ToObject<List<ScProject>>();
  136. }
  137. else
  138. {
  139. }
  140. //await response.WriteAsJsonAsync(new { data = projects.ToJsonString() });
  141. return (200, projects.ToJsonString());
  142. }
  143. catch (Exception ex)
  144. {
  145. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")},IES5.ScApisService:GetProjectInfoByTrainComID\n{ex.Message}\n{ex.StackTrace}\n{result.ToJsonString()}\n{areaId}\n{accessConfig}\n", GroupNames.醍摩豆服務運維群組);
  146. //await response.WriteAsJsonAsync(new { data = projects.ToJsonString() });
  147. return (500, projects.ToJsonString());
  148. }
  149. }
  150. /// <summary>
  151. /// 5.3.1.18根据机构ID、项目ID、子项目ID返回学校列表
  152. /// </summary>
  153. /// <param name="areaId"></param>
  154. /// <param name="_accessConfig"></param>
  155. /// <returns></returns>
  156. public async Task<(int state, string json)> GetSchoolList(string areaId, string accessConfig)
  157. {
  158. List<ScSchool> scSchools = new();
  159. ScAccessConfig config = accessConfig.ToObject<JsonElement>().ToObject<ScAccessConfig>();
  160. Code = "GetSchoolList";
  161. parameterMap = new Dictionary<string, object>();
  162. parameterMap.Add("TrainComID", config.trainComID);
  163. List<ScsResult> results = new();
  164. try
  165. {
  166. if (config.p.IsNotEmpty())
  167. {
  168. foreach (var ps in config.p)
  169. {
  170. if (ps.status == 1)
  171. {
  172. parameterMap["ProjectID"] = ps.pd;
  173. parameterMap["ProjectItemID"] = ps.pid;
  174. ScsResult result = new ScsResult { bizcode = Code, title = " 5.3.1.18根据机构ID、项目ID、子项目ID返回学校列表" };
  175. result = await _thirdApisService.Post(config.url, Code, config.passKey, config.privateKey, parameterMap);
  176. if (result.result)
  177. {
  178. List<ScSchool> schools = result.content.ToObject<List<ScSchool>>();
  179. if (schools.IsNotEmpty())
  180. {
  181. //schools.ForEach(x => { x.ProjectID = int.Parse(ps.pd); x.ProjectItemID = int.Parse(ps.pid); });
  182. scSchools.AddRange(schools);
  183. }
  184. }
  185. results.Add(result);
  186. }
  187. }
  188. }
  189. //await response.WriteAsJsonAsync(new { data = scSchools.ToJsonString() });
  190. return (200, scSchools.ToJsonString());
  191. }
  192. catch (Exception ex)
  193. {
  194. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")},IES5.ScApisService:GetSchoolList\n{ex.Message}\n{ex.StackTrace}\n{results.ToJsonString()}\n{areaId}\n{accessConfig}\n", GroupNames.醍摩豆服務運維群組);
  195. //await response.WriteAsJsonAsync(new { data = scSchools.ToJsonString() });
  196. return (500, scSchools.ToJsonString());
  197. }
  198. }
  199. /// <summary>
  200. /// 5.3.1.2获取学员名单
  201. /// </summary>
  202. /// <param name="areaId"></param>
  203. /// <param name="accessConfig"></param>
  204. /// <returns></returns>
  205. public async Task<(int state, string json)> GetTeachersListByProject(string areaId, string accessConfig)
  206. {
  207. List<ScTeacher> scTeachers = new();
  208. ScAccessConfig config = accessConfig.ToObject<JsonElement>().ToObject<ScAccessConfig>();
  209. Code = "GetTeachersListByProject";
  210. parameterMap = new Dictionary<string, object>();
  211. parameterMap.Add("TrainComID", config.trainComID);
  212. List<ScsResult> results = new List<ScsResult>();
  213. try
  214. {
  215. if (config.p.IsNotEmpty())
  216. {
  217. foreach (var ps in config.p)
  218. {
  219. if (ps.status == 1)
  220. {
  221. parameterMap["ProjectID"] = ps.pd;
  222. parameterMap["ProjectItemID"] = ps.pid;
  223. ScsResult result = new ScsResult { bizcode = Code, title = "5.3.1.2获取学员名单" };
  224. result = await _thirdApisService.Post(config.url, Code, config.passKey, config.privateKey, parameterMap);
  225. if (result.result)
  226. {
  227. List<ScTeacher> teachers = result.content.ToObject<List<ScTeacher>>();
  228. if (teachers.IsNotEmpty())
  229. {
  230. scTeachers.AddRange(teachers);
  231. }
  232. }
  233. results.Add(result);
  234. }
  235. }
  236. }
  237. //await response.WriteAsJsonAsync(new { data = scTeachers.ToJsonString() });
  238. return (200, scTeachers.ToJsonString());
  239. }
  240. catch (Exception ex)
  241. {
  242. await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")},IES5.ScApisService:GetTeachersListByProject\n{ex.Message}\n{ex.StackTrace}\n{results.ToJsonString()}\n{areaId}\n{accessConfig}", GroupNames.醍摩豆服務運維群組);
  243. //await response.WriteAsJsonAsync(new { data = scTeachers.ToJsonString() });
  244. return (500, scTeachers.ToJsonString());
  245. }
  246. }
  247. /// <summary>
  248. /// 5.3.1.20获取学校设置的可选能力点
  249. /// </summary>
  250. /// <param name="areaId"></param>
  251. /// <param name="accessConfig"></param>
  252. /// <param name="schoolCode"></param>
  253. /// <returns></returns>
  254. public async Task<(int state, string json)> GetSchoolDiagnosis(string areaId, string accessConfig, string schoolCode)
  255. {
  256. List<ScsProjectDiagnosis> projects = new();
  257. ScAccessConfig config = accessConfig.ToObject<JsonElement>().ToObject<ScAccessConfig>();
  258. Code = "GetSchoolDiagnosis";
  259. var table = _azureStorage.GetCloudTableClient().GetTableReference("ScYxpt");
  260. parameterMap = new Dictionary<string, object>();
  261. parameterMap.Add("TrainComID", config.trainComID);
  262. List<ScsResult> results = new List<ScsResult>();
  263. try
  264. {
  265. if (config.p.IsNotEmpty())
  266. {
  267. foreach (var ps in config.p)
  268. {
  269. if (ps.status == 1)
  270. {
  271. parameterMap["ProjectID"] = ps.pd;
  272. parameterMap["ProjectItemID"] = ps.pid;
  273. parameterMap["SchoolID"] = $"{schoolCode}";
  274. parameterMap["School"] = $"{schoolCode}";
  275. ScsResult result = new ScsResult { bizcode = Code, title = " 5.3.1.20获取学校设置的可选能力点" };
  276. result = await _thirdApisService.Post(config.url, Code, config.passKey, config.privateKey, parameterMap);
  277. if (result.result)
  278. {
  279. List<ScPDiagnosis> diagnoses = result.content.ToObject<List<ScPDiagnosis>>();
  280. if (diagnoses.IsNotEmpty())
  281. {
  282. projects.Add(new ScsProjectDiagnosis { project = ps, diagnoses = diagnoses, });
  283. await table.SaveOrUpdate<ScProjectDiagnosis>(new ScProjectDiagnosis
  284. {
  285. schoolCode = $"{schoolCode}",
  286. areaId = areaId,
  287. ProjectID = int.Parse(ps.pd),
  288. ProjectItemID = int.Parse(ps.pid),
  289. RowKey = $"{ps.pid}-{schoolCode}",
  290. PartitionKey = "ScSchoolDiagnosis",
  291. abilityNos = diagnoses.ToJsonString()
  292. });
  293. }
  294. }
  295. else
  296. {
  297. List<ScProjectDiagnosis> teacherDiagnoses = await table.FindListByDict<ScProjectDiagnosis>(new Dictionary<string, object> { { "PartitionKey", "ScSchoolDiagnosis" }, { "RowKey", $"{ps.pid}-{schoolCode}" } });
  298. if (teacherDiagnoses.IsNotEmpty())
  299. {
  300. projects.Add(new ScsProjectDiagnosis { project = ps, diagnoses = teacherDiagnoses[0].abilityNos.ToObject<List<ScPDiagnosis>>() });
  301. }
  302. }
  303. results.Add(result);
  304. }
  305. }
  306. }
  307. //await response.WriteAsJsonAsync(new { data = projects.ToJsonString() });
  308. return (200,projects.ToJsonString());
  309. }
  310. catch (Exception ex)
  311. {
  312. //await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")},IES5.ScApisService:GetSchoolDiagnosis\n{ex.Message}\n{ex.StackTrace}\n{results.ToJsonString()}\n{data}", GroupNames.醍摩豆服務運維群組);
  313. if (config.p.IsNotEmpty())
  314. {
  315. foreach (var ps in config.p)
  316. {
  317. List<ScProjectDiagnosis> teacherDiagnoses = await table.FindListByDict<ScProjectDiagnosis>(new Dictionary<string, object> { { "PartitionKey", "ScSchoolDiagnosis" }, { "RowKey", $"{ps.pid}-{schoolCode}" } });
  318. if (teacherDiagnoses.IsNotEmpty())
  319. {
  320. projects.Add(new ScsProjectDiagnosis { project = ps, diagnoses = teacherDiagnoses[0].abilityNos.ToObject<List<ScPDiagnosis>>() });
  321. }
  322. }
  323. }
  324. //await response.WriteAsJsonAsync(new { data = projects.ToJsonString() });
  325. return (500,projects.ToJsonString());
  326. }
  327. }
  328. /// <summary>
  329. /// 5.3.1.19获取项目设置的可选能力点
  330. /// </summary>
  331. /// <param name="areaId"></param>
  332. /// <param name="accessConfig"></param>
  333. /// <returns></returns>
  334. public async Task<(int state, string json)> GetProjectDiagnosis(string areaId, string accessConfig)
  335. {
  336. List<ScsProjectDiagnosis> projects = new();
  337. ScAccessConfig config = accessConfig.ToObject<JsonElement>().ToObject<ScAccessConfig>();
  338. Code = "GetProjectDiagnosis";
  339. var table = _azureStorage.GetCloudTableClient().GetTableReference("ScYxpt");
  340. parameterMap = new Dictionary<string, object>();
  341. parameterMap.Add("TrainComID", config.trainComID);
  342. List<ScsResult> results = new();
  343. try
  344. {
  345. if (config.p.IsNotEmpty())
  346. {
  347. foreach (var ps in config.p)
  348. {
  349. if (ps.status == 1)
  350. {
  351. parameterMap["ProjectID"] = ps.pd;
  352. parameterMap["ProjectItemID"] = ps.pid;
  353. ScsResult result = new ScsResult { bizcode = Code, title = "5.3.1.19获取项目设置的可选能力点" };
  354. result = await _thirdApisService.Post(config.url, Code, config.passKey, config.privateKey, parameterMap);
  355. if (result.result)
  356. {
  357. List<ScPDiagnosis> diagnoses = result.content.ToObject<List<ScPDiagnosis>>();
  358. if (diagnoses.IsNotEmpty())
  359. {
  360. projects.Add(new ScsProjectDiagnosis { project = ps, diagnoses = diagnoses });
  361. await table.SaveOrUpdate<ScProjectDiagnosis>(new ScProjectDiagnosis { areaId = areaId, RowKey = $"{ps.pid}", PartitionKey = "ScProjectDiagnosis", abilityNos = diagnoses.ToJsonString() });
  362. }
  363. }
  364. else
  365. {
  366. List<ScProjectDiagnosis> teacherDiagnoses = await table.FindListByDict<ScProjectDiagnosis>(new Dictionary<string, object> { { "PartitionKey", "ScProjectDiagnosis" }, { "RowKey", $"{ps.pid}" } });
  367. if (teacherDiagnoses.IsNotEmpty())
  368. {
  369. projects.Add(new ScsProjectDiagnosis { project = ps, diagnoses = teacherDiagnoses[0].abilityNos.ToObject<List<ScPDiagnosis>>() });
  370. }
  371. }
  372. results.Add(result);
  373. }
  374. }
  375. }
  376. //await response.WriteAsJsonAsync(new { data = projects.ToJsonString() });
  377. return (200, projects.ToJsonString());
  378. }
  379. catch (Exception ex)
  380. {
  381. if (config.p.IsNotEmpty())
  382. {
  383. foreach (var ps in config.p)
  384. {
  385. //await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")},IES5.ScApisService:GetProjectDiagnosis\n{ex.Message}\n{ex.StackTrace}\n{results.ToJsonString()}\n{data}", GroupNames.醍摩豆服務運維群組);
  386. List<ScProjectDiagnosis> teacherDiagnoses = await table.FindListByDict<ScProjectDiagnosis>(new Dictionary<string, object> { { "PartitionKey", "ScProjectDiagnosis" }, { "RowKey", $"{ps.pid}" } });
  387. if (teacherDiagnoses.IsNotEmpty())
  388. {
  389. projects.Add(new ScsProjectDiagnosis { project = ps, diagnoses = teacherDiagnoses[0].abilityNos.ToObject<List<ScPDiagnosis>>() });
  390. }
  391. }
  392. }
  393. //await response.WriteAsJsonAsync(new { data = projects.ToJsonString() });
  394. return (500, projects.ToJsonString());
  395. }
  396. }
  397. /// <summary>
  398. /// 5.3.1.3通过项目编号获取学员测评能力项V2
  399. /// </summary>
  400. /// <param name="areaId"></param>
  401. /// <param name="accessConfig"></param>
  402. /// <param name="pxid"></param>
  403. /// <param name="schoolCode"></param>
  404. /// <returns></returns>
  405. public async Task<(int state, string json)> GetDiagnosisListByProject_V2(string areaId, string accessConfig, string pxid, string schoolCode)
  406. {
  407. List<string> abilityNos = new();
  408. var table = _azureStorage.GetCloudTableClient().GetTableReference("ScYxpt");
  409. ScAccessConfig config = accessConfig.ToObject<JsonElement>().ToObject<ScAccessConfig>();
  410. Code = "GetDiagnosisListByProject_V2";
  411. parameterMap = new Dictionary<string, object>();
  412. parameterMap.Add("TrainComID", config.trainComID);
  413. parameterMap.Add("PXID", pxid);
  414. ScsResult result = new() { bizcode = Code, title = "5.3.1.3通过项目编号获取学员测评能力项V2" };
  415. try
  416. {
  417. result = await _thirdApisService.Post(config.url, Code, config.passKey, config.privateKey, parameterMap);
  418. if (result.result)
  419. {
  420. List<ScDiagnosis> diagnoses = result.content.ToObject<List<ScDiagnosis>>();
  421. if (diagnoses != null)
  422. {
  423. abilityNos = diagnoses.Select(x => x.DiagnosisDicNum).ToList();
  424. }
  425. if (abilityNos.IsNotEmpty())
  426. {
  427. await table.SaveOrUpdate<ScTeacherDiagnosis>(new ScTeacherDiagnosis { areaId = areaId, schoolCode = $"{schoolCode}", RowKey = $"{pxid}", PartitionKey = "ScTeacherDiagnosis", abilityNos = abilityNos.ToJsonString() });
  428. }
  429. }
  430. else
  431. {
  432. List<ScTeacherDiagnosis> teacherDiagnoses = await table.FindListByDict<ScTeacherDiagnosis>(new Dictionary<string, object> { { "PartitionKey", "ScTeacherDiagnosis" }, { "RowKey", $"{pxid}" } });
  433. if (teacherDiagnoses.IsNotEmpty())
  434. {
  435. abilityNos = teacherDiagnoses[0].abilityNos.ToObject<List<string>>();
  436. }
  437. }
  438. //await response.WriteAsJsonAsync(new { data = abilityNos.ToJsonString() });
  439. return (200, abilityNos.ToJsonString());
  440. }
  441. catch (Exception ex)
  442. {
  443. //await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")},IES5.ScApisService:getDiagnosisListByProject_V2\n{ex.Message}\n{ex.StackTrace}\n{result.ToJsonString()}\n{data}", GroupNames.醍摩豆服務運維群組);
  444. List<ScTeacherDiagnosis> teacherDiagnoses = await table.FindListByDict<ScTeacherDiagnosis>(new Dictionary<string, object> { { "PartitionKey", "ScTeacherDiagnosis" }, { "RowKey", $"{pxid}" } });
  445. if (teacherDiagnoses.IsNotEmpty())
  446. {
  447. abilityNos = teacherDiagnoses[0].abilityNos.ToObject<List<string>>();
  448. }
  449. //await response.WriteAsJsonAsync(new { data = abilityNos.ToJsonString() });
  450. return (500, abilityNos.ToJsonString());
  451. }
  452. }
  453. /// <summary>
  454. /// 5.3.1.11获取跳转学员信息,用于sso单点,后端验证。
  455. /// </summary>
  456. /// <param name="areaId"></param>
  457. /// <param name="accessConfig"></param>
  458. /// <param name="pxid"></param>
  459. /// <param name="tid"></param>
  460. /// <returns></returns>
  461. public async Task<(int state, string json)> GetSingleTeacherByProject(string areaId, string accessConfig, string pxid, string tid)
  462. {
  463. string teacher = null;
  464. ScAccessConfig config = accessConfig.ToObject<JsonElement>().ToObject<ScAccessConfig>();
  465. Code = "GetSingleTeacherByProject";
  466. parameterMap = new Dictionary<string, object>();
  467. parameterMap.Add("TrainComID", config.trainComID);
  468. parameterMap.Add("Pxid", $"{pxid}");
  469. parameterMap.Add("Tid", $"{tid}");
  470. ScsResult result = new ScsResult { bizcode = Code, title = "5.3.1.11获取跳转学员信息,用于sso单点,后端验证。" };
  471. try
  472. {
  473. ///{“result”:true,”reason”:null,”content”:”{“PXID”:””,”TID”:””,”TeacherName”:””,”ProjectTitle”:””,”ProjectItemTitle”:””,”CityName”:””,
  474. ///”DisName”:””,”SchoolName”:””,”Sex”:””,”PXXK”:””,”PXXD”:””,”TeacherXK”:””,”TeacherXD”:””,”Email”:””}”,”pagecount”:1}
  475. result = await _thirdApisService.Post(config.url, Code, config.passKey, config.privateKey, parameterMap);
  476. if (result.result)
  477. {
  478. teacher = result.content;
  479. }
  480. //await response.WriteAsJsonAsync(new { data = teacher });
  481. return (200, teacher);
  482. }
  483. catch (Exception ex)
  484. {
  485. //await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")},IES5.ScApisService:GetSingleTeacherByProject\n{ex.Message}\n{ex.StackTrace}\n{result.ToJsonString()}\n{data}", GroupNames.醍摩豆服務運維群組);
  486. //await response.WriteAsJsonAsync(new { data = teacher });
  487. return (200, teacher);
  488. }
  489. }
  490. /// <summary>
  491. /// 数据推送接口
  492. /// </summary>
  493. /// <param name="areaId"></param>
  494. /// <param name="accessConfig"></param>
  495. /// <param name="school"></param>
  496. /// <param name="pushTeachers"></param>
  497. /// <returns></returns>
  498. public async Task<(int state, string json)> SchoolDataPush(string accessConfig, string school, List<string> pushTeachers)
  499. {
  500. dynamic dynamic = null;
  501. ScAccessConfig config = accessConfig.ToObject<JsonElement>().ToObject<ScAccessConfig>();
  502. StringBuilder queryText = new StringBuilder($"SELECT distinct value(c) FROM c where c.type='yxtrain'");
  503. List<GroupList> yxtrain = new List<GroupList>();
  504. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<GroupList>(queryText: queryText.ToString(),
  505. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"GroupList-{school}") }))
  506. {
  507. yxtrain.Add(item);
  508. }
  509. List<TeacherTrain> trains = new List<TeacherTrain>();
  510. var members = yxtrain.SelectMany(x => x.members).ToList();
  511. //指定推送一部分的教师
  512. if (pushTeachers.IsNotEmpty())
  513. {
  514. members = members.FindAll(x => pushTeachers.Contains(x.id));
  515. }
  516. if (members.IsNotEmpty())
  517. {
  518. queryText = new StringBuilder($"SELECT distinct value(c) FROM c where 1=1 and c.id in ({string.Join(",", members.Select(x => $"'{x.id}'"))}) ");
  519. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIterator<TeacherTrain>(queryText: queryText.ToString(), requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"TeacherTrain-{school}") }))
  520. {
  521. trains.Add(item);
  522. }
  523. }
  524. //string sql = $" SELECT value(c) FROM c join a in c.binds where ARRAY_LENGTH(c.binds)>0 and a.type='{config.config}' ";
  525. //List<Teacher> teachers = new List<Teacher>();
  526. //await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIterator<Teacher>(queryText: sql,
  527. // requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Base") }))
  528. //{
  529. // teachers.Add(item);
  530. //}
  531. var table = _azureStorage.GetCloudTableClient().GetTableReference("ScYxpt");
  532. List<ScTeacher> scTeachers = await table.FindListByDict<ScTeacher>(new Dictionary<string, object> { { "PartitionKey", "ScTeacher" }, { "schoolCode", $"{school}" } });
  533. List<ScTeacherDiagnosis> scTeacherDiagnoses = await table.FindListByDict<ScTeacherDiagnosis>(new Dictionary<string, object> { { "PartitionKey", "ScTeacherDiagnosis" }, { "schoolCode", $"{school}" } });
  534. List<KeyValuePair<TeacherTrain, string>> trainsNO = new List<KeyValuePair<TeacherTrain, string>>();
  535. List<ScsResult> results = new List<ScsResult>();
  536. Dictionary<string, Dictionary<string, object>> pushDatas = new Dictionary<string, Dictionary<string, object>>();
  537. int pages = (trains.Count + 19) / 20; //pages = (total + max -1) / max;
  538. for (int i = 0; i < pages; i++)
  539. {
  540. List<TeacherTrain> lists = trains.Skip((i) * 20).Take(20).ToList();
  541. //5.3.1.12学员培训基本情况批量回写-UpdateTeacherListSituation
  542. List<TeacherTrain> trains53112OK = new List<TeacherTrain>();
  543. ScsResult UpdateTeacherListSituation = null;
  544. Dictionary<string, object> parameterContent53112 = new Dictionary<string, object>();
  545. List<Dictionary<string, object>> list53112 = new List<Dictionary<string, object>>();
  546. parameterContent53112.Add("TrainComID", config.trainComID);
  547. parameterContent53112.Add("List", list53112);
  548. //5.3.1.13学员能力点测评结果批量回写-UpdateTeacherListDiagnosis 300条限制
  549. List<TeacherTrain> trains53113OK = new List<TeacherTrain>();
  550. ScsResult UpdateTeacherListDiagnosis = null;
  551. Dictionary<string, object> parameterContent53113 = new Dictionary<string, object>();
  552. List<Dictionary<string, object>> list53113 = new List<Dictionary<string, object>>();
  553. parameterContent53113.Add("TrainComID", config.trainComID);
  554. parameterContent53113.Add("List", list53113);
  555. //5.3.1.17学员课堂实录批量回写-UploadKTSLList 300条限制
  556. List<TeacherTrain> trains53117OK = new List<TeacherTrain>();
  557. ScsResult UploadKTSLList = null;
  558. Dictionary<string, object> parameterContent53117 = new Dictionary<string, object>();
  559. List<Dictionary<string, object>> list53117 = new List<Dictionary<string, object>>();
  560. parameterContent53117.Add("TrainComID", config.trainComID);
  561. parameterContent53117.Add("List", list53117);
  562. //5.3.1.22学员校本教研PDF(每人可以返回多条)批量回写-UploadSBTARPDFListV2 100条限制
  563. List<TeacherTrain> trains53122OK = new List<TeacherTrain>();
  564. ScsResult UploadSBTARPDFListV2 = null;
  565. Dictionary<string, object> parameterContent53122 = new Dictionary<string, object>();
  566. List<Dictionary<string, object>> list53122 = new List<Dictionary<string, object>>();
  567. parameterContent53122.Add("TrainComID", config.trainComID);
  568. parameterContent53122.Add("List", list53122);
  569. //装载数据
  570. foreach (var x in lists)
  571. {
  572. List<CodeValue> msgs = new List<CodeValue>();
  573. List<ScTeacher> teacher = scTeachers.FindAll(t => !string.IsNullOrWhiteSpace(t.tmdid) && t.tmdid.Equals(x.id));
  574. foreach (var t in teacher)
  575. {
  576. List<PushFail> fails = new List<PushFail>();
  577. Dictionary<string, object> pushData = new Dictionary<string, object>();
  578. string json = scTeacherDiagnoses.ToJsonString();
  579. ScTeacherDiagnosis diagnosis = scTeacherDiagnoses.Find(x => x.RowKey.Equals($"{t.PXID}"));
  580. (int t53112OK, List<CodeValue> msgs53112) = check53112(x, msgs);
  581. (int t53113OK, List<CodeValue> msgs53113, List<AbilitySub> abilitySubs) = await check53113(x, diagnosis, msgs);
  582. (int t53117OK, List<CodeValue> msgs53117) = check53117(x, msgs);
  583. (int t53122OK, List<CodeValue> msgs53122) = check53122(x, msgs);
  584. //5.3.1.12学员培训基本情况批量回写-UpdateTeacherListSituation
  585. if (t53112OK == 1)
  586. {
  587. Dictionary<string, object> parameterMapData = new Dictionary<string, object>();
  588. parameterMapData.Add("PXID", $"{t.PXID}");
  589. parameterMapData.Add("TID", $"{t.TID}");
  590. parameterMapData.Add("TeacherName", $"{t.TeacherName}");
  591. parameterMapData.Add("CourseHour", $"{x.totalTime}");
  592. parameterMapData.Add("ResearchText", $"{x.summary}");
  593. /// <summary>
  594. ///省上标准 最终结果 0未认定,1合格,2优秀,3不合格,4其他
  595. ///系统标准 -2 其他 -1 未认定,0不合格,1合格,2优秀
  596. /// </summary>
  597. string ComPassed = "0";
  598. switch (x.finalScore)
  599. {
  600. case -2:
  601. ComPassed = "4";
  602. break;
  603. case -1:
  604. ComPassed = "0";
  605. break;
  606. case 0:
  607. ComPassed = "3";
  608. break;
  609. case 1:
  610. ComPassed = "1";
  611. break;
  612. case 2:
  613. ComPassed = "2";
  614. break;
  615. default:
  616. ComPassed = "4";
  617. break;
  618. }
  619. parameterMapData.Add("ComPassed", ComPassed);//0、未认定 1、合格 2、优秀 3、不合格 4、其他
  620. pushData.Add("success-UpdateTeacherListSituation", parameterMapData);
  621. list53112.Add(parameterMapData);
  622. }
  623. else
  624. {
  625. pushData.Add("fail-UpdateTeacherListSituation", new PushFail { tmdid = t.tmdid, name = t.TeacherName, msgs = msgs53112 });
  626. fails.Add(new PushFail { tmdid = t.tmdid, name = t.TeacherName, msgs = msgs53112 });
  627. }
  628. //5.3.1.13学员能力点测评结果批量回写-UpdateTeacherListDiagnosis
  629. if (t53113OK == 1)
  630. {
  631. List<Dictionary<string, object>> parameterMapDatas = new List<Dictionary<string, object>>();
  632. x.currency.teacherAilities.ForEach(a => {
  633. Dictionary<string, object> parameterMapData = new Dictionary<string, object>();
  634. parameterMapData.Add("PXID", $"{t.PXID}");
  635. parameterMapData.Add("TID", $"{t.TID}");
  636. parameterMapData.Add("DiagnosisNum", $"{a.no}");
  637. //0"未认定", 1"合格", 2"优秀", 3"不合格"
  638. //系统 -1 未认定,0 不合格,1 合格,2 优秀
  639. string zpscore = "0";
  640. switch (a.zpscore)
  641. {
  642. case -1:
  643. zpscore = "0";
  644. break;
  645. case 0:
  646. zpscore = "3";
  647. break;
  648. case 1:
  649. zpscore = "1";
  650. break;
  651. case 2:
  652. zpscore = "2";
  653. break;
  654. default:
  655. zpscore = "0";
  656. break;
  657. }
  658. string hpscore = "0";
  659. switch (a.hpscore)
  660. {
  661. case -1:
  662. hpscore = "0";
  663. break;
  664. case 0:
  665. hpscore = "3";
  666. break;
  667. case 1:
  668. hpscore = "1";
  669. break;
  670. case 2:
  671. hpscore = "2";
  672. break;
  673. default:
  674. hpscore = "0";
  675. break;
  676. }
  677. string xzpresult = "0";
  678. switch (a.xzscore)
  679. {
  680. case -1:
  681. xzpresult = "0";
  682. break;
  683. case 0:
  684. xzpresult = "3";
  685. break;
  686. case 1:
  687. xzpresult = "1";
  688. break;
  689. case 2:
  690. xzpresult = "2";
  691. break;
  692. default:
  693. xzpresult = "0";
  694. break;
  695. }
  696. parameterMapData.Add("zpresult", zpscore);
  697. parameterMapData.Add("hpresult", hpscore);
  698. parameterMapData.Add("xzpresult", xzpresult);
  699. List<Dictionary<string, object>> pfiles = new List<Dictionary<string, object>>();
  700. parameterMapData.Add("pfiles", pfiles);
  701. AbilitySub abilitySub = abilitySubs.Find(sub => sub.id.Equals(a.id));
  702. if (abilitySub != null)
  703. {
  704. abilitySub.uploads.ForEach(upload => {
  705. upload.urls.ForEach(url => {
  706. Dictionary<string, object> pfileMap = new Dictionary<string, object>();
  707. pfileMap.Add("url", url.url);
  708. pfileMap.Add("fileName", url.name);
  709. pfileMap.Add("fileSize", url.size);
  710. pfileMap.Add("md5", url.hash);
  711. string fileext = url.url.Substring(url.url.LastIndexOf(".") > 0 ? url.url.LastIndexOf(".") + 1 : 0);
  712. pfileMap.Add("fileType", fileext);
  713. pfiles.Add(pfileMap);
  714. });
  715. });
  716. }
  717. list53113.Add(parameterMapData);
  718. parameterMapDatas.Add(parameterMapData);
  719. });
  720. pushData.Add("success-UpdateTeacherListDiagnosis", parameterMapDatas);
  721. }
  722. else
  723. {
  724. pushData.Add("fail-UpdateTeacherListDiagnosis", new PushFail { tmdid = t.tmdid, name = t.TeacherName, msgs = msgs53113 });
  725. fails.Add(new PushFail { tmdid = t.tmdid, name = t.TeacherName, msgs = msgs53113 });
  726. }
  727. //5.3.1.17学员课堂实录批量回写-UploadKTSLList
  728. if (t53117OK == 1)
  729. {
  730. List<Dictionary<string, object>> parameterMapDatas = new List<Dictionary<string, object>>();
  731. x.teacherClasses.ForEach(clss =>
  732. {
  733. Dictionary<string, object> parameterMapData = new Dictionary<string, object>();
  734. parameterMapData.Add("PXID", $"{t.PXID}");
  735. parameterMapData.Add("TID", $"{t.TID}");
  736. parameterMapData.Add("url", clss.url);//添加访问授权
  737. parameterMapData.Add("url2", clss.url);
  738. parameterMapData.Add("fileName", clss.name);
  739. parameterMapData.Add("fileSize", clss.size);
  740. parameterMapData.Add("md5", clss.hash);
  741. string fileext = clss.url.Substring(clss.url.LastIndexOf(".") > 0 ? clss.url.LastIndexOf(".") + 1 : 0);
  742. parameterMapData.Add("fileType", fileext);
  743. list53117.Add(parameterMapData);
  744. parameterMapDatas.Add(parameterMapData);
  745. });
  746. pushData.Add("success-UploadKTSLList", parameterMapDatas);
  747. }
  748. else
  749. {
  750. pushData.Add("fail-UploadKTSLList", new PushFail { tmdid = t.tmdid, name = t.TeacherName, msgs = msgs53117 });
  751. fails.Add(new PushFail { tmdid = t.tmdid, name = t.TeacherName, msgs = msgs53117 });
  752. }
  753. //5.3.1.22学员校本教研PDF(每人可以返回多条)批量回写-UploadSBTARPDFListV2
  754. if (t53122OK == 1)
  755. {
  756. Dictionary<string, object> parameterMapData = new Dictionary<string, object>();
  757. parameterMapData.Add("PXID", $"{t.PXID}");
  758. parameterMapData.Add("TID", $"{t.TID}");
  759. List<Dictionary<string, object>> files = new List<Dictionary<string, object>>();
  760. x.offlineRecords.ForEach(record => {
  761. if (!string.IsNullOrWhiteSpace(record.url))
  762. {
  763. Dictionary<string, object> fileMap = new Dictionary<string, object>();
  764. fileMap.Add("url", record.url);
  765. fileMap.Add("fileName", record.name);
  766. fileMap.Add("fileSize", record.size);
  767. fileMap.Add("md5", record.hash);
  768. string fileext = record.url.Substring(record.url.LastIndexOf(".") > 0 ? record.url.LastIndexOf(".") + 1 : 0);
  769. fileMap.Add("fileType", fileext);
  770. files.Add(fileMap);
  771. }
  772. });
  773. parameterMapData.Add("files", files);
  774. list53122.Add(parameterMapData);
  775. pushData.Add("success-UploadSBTARPDFListV2", parameterMapData);
  776. }
  777. else
  778. {
  779. pushData.Add("fail-UploadSBTARPDFListV2", new PushFail { tmdid = t.tmdid, name = t.TeacherName, msgs = msgs53122 });
  780. fails.Add(new PushFail { tmdid = t.tmdid, name = t.TeacherName, msgs = msgs53122 });
  781. }
  782. pushDatas.Add(t.tmdid, pushData);
  783. }
  784. }
  785. //推送数据
  786. UpdateTeacherListSituation = await _thirdApisService.Post(config.url, "UpdateTeacherListSituation", config.passKey, config.privateKey, parameterContent53112);
  787. UpdateTeacherListSituation.bizcode = "UpdateTeacherListSituation";
  788. UpdateTeacherListSituation.title = "5.3.1.12学员培训基本情况批量回写";
  789. UpdateTeacherListDiagnosis = await _thirdApisService.Post(config.url, "UpdateTeacherListDiagnosis", config.passKey, config.privateKey, parameterContent53113);
  790. UpdateTeacherListDiagnosis.bizcode = "UpdateTeacherListDiagnosis";
  791. UpdateTeacherListDiagnosis.title = "5.3.1.13学员能力点测评结果批量回写";
  792. UploadKTSLList = await _thirdApisService.Post(config.url, "UploadKTSLList", config.passKey, config.privateKey, parameterContent53117);
  793. UploadKTSLList.bizcode = "UploadKTSLList";
  794. UploadKTSLList.title = "5.3.1.17学员课堂实录批量回写";
  795. UploadSBTARPDFListV2 = await _thirdApisService.Post(config.url, "UploadSBTARPDFListV2", config.passKey, config.privateKey, parameterContent53122);
  796. UploadSBTARPDFListV2.bizcode = "UploadSBTARPDFListV2";
  797. UploadSBTARPDFListV2.title = "5.3.1.22学员校本教研PDF(每人可以返回多条)批量回写";
  798. results.Add(UpdateTeacherListSituation);
  799. results.Add(UpdateTeacherListDiagnosis);
  800. results.Add(UploadKTSLList);
  801. results.Add(UploadSBTARPDFListV2);
  802. }
  803. //await response.WriteAsJsonAsync(new { data = new { results, pushDatas } });
  804. dynamic = new { results, pushDatas };
  805. return (200, dynamic.ToJsonString());
  806. }
  807. //5.3.1.22学员校本教研PDF(每人可以返回多条)批量回写-UploadSBTARPDFListV2
  808. public (int t53122OK, List<CodeValue> msgs) check53122(TeacherTrain teacherTrain, List<CodeValue> msgs)
  809. {
  810. int t53122OK = 1;
  811. if (teacherTrain.offlineRecords.Count <= 0)
  812. {
  813. msgs.Add(new CodeValue("offlineRecord-count", $"文件个数为0"));
  814. }
  815. var hasUrl = teacherTrain.offlineRecords.Where(x => !string.IsNullOrWhiteSpace(x.url) && x.size > 0);
  816. if (!hasUrl.Any())
  817. {
  818. msgs.Add(new CodeValue("offlineRecord-url", $"需要上传的校本研修作业至少有一个。"));
  819. }
  820. //不需要检查每一个校本研修的文件记录。
  821. //teacherTrain.offlineRecords.ForEach(x => {
  822. // if (string.IsNullOrEmpty(x.url)) {
  823. // msgs.Add(new CodeValue("offlineRecord-url", $"链接为空"));
  824. // }
  825. // if (x.size<=0)
  826. // {
  827. // msgs.Add(new CodeValue("offlineRecord-size", $"文件大小"));
  828. // }
  829. //});
  830. return (t53122OK, msgs);
  831. }
  832. //5.3.1.17学员课堂实录批量回写-UploadKTSLList
  833. public (int t53117OK, List<CodeValue> msgs) check53117(TeacherTrain teacherTrain, List<CodeValue> msgs)
  834. {
  835. //校验 基本情况是否满足
  836. int t53117OK = 1;
  837. if (teacherTrain.classTime <= 0)
  838. {
  839. msgs.Add(new CodeValue("classTime", $"未获得学时:{teacherTrain.classTime}"));
  840. t53117OK = 0;
  841. }
  842. if (teacherTrain.teacherClasses.Count() <= 0)
  843. {
  844. msgs.Add(new CodeValue("teacherClasses", $"未上传课堂实录:{teacherTrain.teacherClasses.Count()}个视频"));
  845. t53117OK = 0;
  846. }
  847. teacherTrain.teacherClasses.ForEach(x => {
  848. if (string.IsNullOrWhiteSpace(x.url))
  849. {
  850. t53117OK = 0;
  851. msgs.Add(new CodeValue("teacherClasses", $"课堂实录链接无效"));
  852. }
  853. });
  854. return (t53117OK, msgs);
  855. }
  856. //5.3.1.12学员培训基本情况批量回写-UpdateTeacherListSituation
  857. public (int t53112OK, List<CodeValue> msgs) check53112(TeacherTrain teacherTrain, List<CodeValue> msgs)
  858. {
  859. //校验 基本情况是否满足
  860. int t53112OK = 1;
  861. if (teacherTrain.finalScore < 0)
  862. {
  863. //总体认定结果0、未认定 1、合格 2、优秀 3、不合格 4、其他
  864. msgs.Add(new CodeValue("finalScore", $"最终评定结果参数:{teacherTrain.finalScore}"));
  865. t53112OK = 0;
  866. }
  867. //if (string.IsNullOrEmpty(teacherTrain.summary) || teacherTrain.summary.Length > 300)
  868. //{
  869. // string msg = string.IsNullOrEmpty(teacherTrain.summary) ? "未填写" : teacherTrain.summary.Length > 300 ? "字数超过300." : "";
  870. // msgs.Add(new CodeValue("summary", $"教师培训总结:{msg}"));
  871. // t53112OK = 0;
  872. //}
  873. if (!string.IsNullOrEmpty(teacherTrain.summary) && teacherTrain.summary.Length > 300)
  874. {
  875. //string msg = string.IsNullOrEmpty(teacherTrain.summary) ? "未填写" : teacherTrain.summary.Length > 300 ? "字数超过300." : "";
  876. msgs.Add(new CodeValue("summary", $"教师培训总结:字数超过300."));
  877. t53112OK = 0;
  878. }
  879. if (teacherTrain.totalTime <= 0)
  880. {
  881. msgs.Add(new CodeValue("totalTime", $"未获得学时:{teacherTrain.totalTime}"));
  882. t53112OK = 0;
  883. }
  884. return (t53112OK, msgs);
  885. }
  886. //5.3.1.13学员能力点测评结果批量回写-UpdateTeacherListDiagnosis
  887. public async Task<(int t53113OK, List<CodeValue> msgs, List<AbilitySub> abilitySubs)> check53113(TeacherTrain teacherTrain, ScTeacherDiagnosis diagnosis, List<CodeValue> msgs)
  888. {
  889. //校验 基本情况是否满足
  890. int t53113OK = 1;
  891. List<AbilitySub> abilitySubs = new List<AbilitySub>();
  892. if (teacherTrain.currency.videoTime < 0)
  893. {
  894. msgs.Add(new CodeValue("videoTime", $"视频学习时长:{teacherTrain.currency.videoTime}"));
  895. t53113OK = 0;
  896. }
  897. if (teacherTrain.currency.submitTime < 0)
  898. {
  899. msgs.Add(new CodeValue("submitTime", $"认证材料学习:{teacherTrain.currency.submitTime}"));
  900. t53113OK = 0;
  901. }
  902. if (teacherTrain.currency.teacherAilities.Count <= 0)
  903. {
  904. msgs.Add(new CodeValue("teacherAilities", $"已学习能力点:0"));
  905. t53113OK = 0;
  906. }
  907. if (diagnosis != null)
  908. {
  909. if (!string.IsNullOrWhiteSpace(diagnosis.abilityNos))
  910. {
  911. List<string> nos = diagnosis.abilityNos.ToObject<List<string>>();
  912. if (nos.Count > 0 && teacherTrain.currency.teacherAilities.Count > 0)
  913. {
  914. var notin = nos.Except(teacherTrain.currency.teacherAilities.Select(x => x.no).Where(z => !string.IsNullOrWhiteSpace(z)));
  915. if (notin.Any())
  916. {
  917. msgs.Add(new CodeValue("diagnosisNos", $"省平台勾选的能力点编号为学习完成:省平台:{string.Join(",", nos.OrderBy(x => x))}" + $" ,已学习:{string.Join(",", teacherTrain.currency.teacherAilities.Select(x => x.no).OrderBy(x => x))} "));
  918. t53113OK = 0;
  919. }
  920. else
  921. {
  922. string insql = "";
  923. if (teacherTrain.currency.teacherAilities.IsNotEmpty())
  924. {
  925. var abilites = teacherTrain.currency.teacherAilities.Where(c => !string.IsNullOrWhiteSpace(c.no) && nos.Contains(c.no));
  926. insql = $" where c.id in ({string.Join(",", abilites.Select(o => $"'{o.id}'"))})";
  927. }
  928. //认证材料
  929. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer("TEAMModelOS", "Teacher")
  930. .GetItemQueryIterator<AbilitySub>(queryText: $"select value(c) from c {insql}", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"AbilitySub-{teacherTrain.school}-{teacherTrain.id}") }))
  931. {
  932. abilitySubs.Add(item);
  933. }
  934. teacherTrain.currency.teacherAilities.ForEach(x => {
  935. var abilitySub = abilitySubs.Find(z => z.id.Equals(x.id));
  936. if (abilitySub == null || !abilitySub.uploads.Any())
  937. {
  938. t53113OK = 0;
  939. msgs.Add(new CodeValue("uploads", $"未上传认证材料:{x.no},{x.name}"));
  940. }
  941. if (x.zpscore <= 0)
  942. {
  943. t53113OK = 0;
  944. msgs.Add(new CodeValue("zpscore", $"认证材料,没有完成自评:{x.no},{x.name},{x.zpscore}"));
  945. }
  946. if (x.hpscore <= 0)
  947. {
  948. t53113OK = 0;
  949. msgs.Add(new CodeValue("hpscore", $"认证材料,没有完成互评:{x.no},{x.name},{x.hpscore}"));
  950. }
  951. if (x.xzscore <= 0)
  952. {
  953. t53113OK = 0;
  954. msgs.Add(new CodeValue("xzscore", $"认证材料,没有完成小组评:{x.no},{x.name},{x.xzscore}"));
  955. }
  956. });
  957. if (t53113OK != 1)
  958. {
  959. msgs.Add(new CodeValue("diagnosisNos", $"省平台勾选的能力点编号为学习完成:省平台:{string.Join(",", nos.OrderBy(x => x))}" + $" ,已学习:{string.Join(",", teacherTrain.currency.teacherAilities.Select(x => x.no).OrderBy(x => x))} "));
  960. }
  961. }
  962. }
  963. else
  964. {
  965. msgs.Add(new CodeValue("teacherAilities", $"未同步省平台挑选的能力点"));
  966. t53113OK = 0;
  967. }
  968. }
  969. else
  970. {
  971. msgs.Add(new CodeValue("teacherAilities", $"未同步省平台挑选的能力点"));
  972. t53113OK = 0;
  973. }
  974. }
  975. else
  976. {
  977. msgs.Add(new CodeValue("teacherAilities", $"未同步省平台挑选的能力点"));
  978. t53113OK = 0;
  979. }
  980. return (t53113OK, msgs, abilitySubs);
  981. }
  982. }
  983. }