TeacherController.cs 7.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162
  1. using Azure.Cosmos;
  2. using Microsoft.AspNetCore.Http;
  3. using Microsoft.AspNetCore.Mvc;
  4. using Microsoft.Extensions.Options;
  5. using System;
  6. using System.Collections.Generic;
  7. using System.IdentityModel.Tokens.Jwt;
  8. using System.IO;
  9. using System.Linq;
  10. using System.Text;
  11. using System.Text.Json;
  12. using System.Threading.Tasks;
  13. using TEAMModelOS.Models;
  14. using TEAMModelOS.Models.Dto;
  15. using TEAMModelOS.SDK.Models;
  16. using TEAMModelOS.SDK;
  17. using TEAMModelOS.SDK.DI;
  18. using TEAMModelOS.SDK.DI.AzureCosmos.Inner;
  19. using TEAMModelOS.SDK.Extension;
  20. using TEAMModelOS.SDK.Helper.Common.StringHelper;
  21. using System.Dynamic;
  22. using Azure;
  23. using TEAMModelOS.SDK.Models.Cosmos.Common;
  24. using Azure.Messaging.ServiceBus;
  25. using Microsoft.Extensions.Configuration;
  26. using TEAMModelOS.Filter;
  27. using Azure.Storage.Blobs.Models;
  28. using HTEXLib.COMM.Helpers;
  29. using Microsoft.AspNetCore.Authorization;
  30. using System.Net.Http;
  31. namespace TEAMModelAPI.Controllers
  32. {
  33. [Route("school")]
  34. [ApiController]
  35. public class TeacherController : ControllerBase
  36. {
  37. private AzureCosmosFactory _azureCosmos;
  38. private readonly DingDing _dingDing;
  39. private readonly Option _option;
  40. private readonly AzureServiceBusFactory _serviceBus;
  41. private readonly AzureStorageFactory _azureStorage;
  42. public IConfiguration _configuration { get; set; }
  43. private readonly CoreAPIHttpService _coreAPIHttpService;
  44. public TeacherController(CoreAPIHttpService coreAPIHttpService, AzureCosmosFactory azureCosmos, DingDing dingDing, IOptionsSnapshot<Option> option, AzureServiceBusFactory serviceBus, AzureStorageFactory azureStorage, IConfiguration configuration)
  45. {
  46. _azureCosmos = azureCosmos;
  47. _dingDing = dingDing;
  48. _option = option?.Value;
  49. _serviceBus = serviceBus;
  50. _configuration = configuration;
  51. _azureStorage = azureStorage;
  52. _coreAPIHttpService = coreAPIHttpService;
  53. }
  54. /// <summary>
  55. /// 获取学校教师列表
  56. /// </summary>
  57. /// <param name="request"></param>
  58. /// <returns></returns>
  59. [ProducesDefaultResponseType]
  60. [HttpPost("get-teacher-list")]
  61. [ApiToken(Auth = "1501", Name = "学校教师列表", RW = "R", Limit = false)]
  62. public async Task<IActionResult> GetTeacherList(JsonElement json)
  63. {
  64. json.TryGetProperty("searchKey", out JsonElement _searchKey);
  65. List<CoreUser> coreUsers = new List<CoreUser>();
  66. IEnumerable<string> unexist = null ;
  67. if (_searchKey.ValueKind.Equals(JsonValueKind.Array))
  68. {
  69. List<string> searchKey= _searchKey.ToObject<List<string>>();
  70. var keys = searchKey.Where(x => !string.IsNullOrWhiteSpace(x));
  71. var content = new StringContent(keys.ToJsonString(), Encoding.UTF8, "application/json");
  72. string ujson = await _coreAPIHttpService.GetUserInfos(content);
  73. if (!string.IsNullOrWhiteSpace(ujson))
  74. {
  75. coreUsers = ujson.ToObject<List<CoreUser>>();
  76. }
  77. if (coreUsers.Any())
  78. {
  79. unexist = searchKey.Except(coreUsers.Select(x => x.searchKey));
  80. }
  81. else {
  82. return Ok(new { error = 1, msg = "没有找到对应的教师信息!" });
  83. }
  84. }
  85. var (id, school) = HttpContext.GetApiTokenInfo();
  86. List<SchoolTeacher> teachers = new List<SchoolTeacher>();
  87. string insql = "";
  88. if (coreUsers.Any()) {
  89. insql = $" and c.id in ({string.Join(",", coreUsers.Select(x => $"'{ x.id}'"))}) ";
  90. }
  91. string sql = $"select c.id,c.name ,c.picture,c.job ,c.subjectIds,c.roles from c where c.status='join' {insql}";
  92. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<SchoolTeacher>
  93. (queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{school}") }))
  94. {
  95. teachers.Add(item);
  96. }
  97. var teacherIds= coreUsers.Select(x => x.id).Except(teachers.Select(x => x.id));
  98. List<CoreUser> unjoined = coreUsers.FindAll(x => teacherIds.Contains(x.id));
  99. List<dynamic> tchs= new List<dynamic>();
  100. teachers.Select(x => new { x.id, x.name, x.picture, x.job, x.subjectIds, x.roles }).ToList().ForEach(x => {
  101. var coreUser= coreUsers.Find(c=>c.id.Equals(x.id));
  102. if (coreUser != null) {
  103. tchs.Add(new {x.id,x.name,x.picture,x.job,x.subjectIds,x.roles,coreUser.searchKey });
  104. }
  105. });
  106. return Ok(new
  107. {
  108. teachers = tchs,
  109. unjoined= unjoined.Select(x => new {x.id,x.name,x.picture,x.searchKey}),
  110. unexist= unexist
  111. });
  112. }
  113. /// <summary>
  114. /// 获取学校教师信息
  115. /// </summary>
  116. /// <returns></returns>
  117. [ProducesDefaultResponseType]
  118. [HttpPost("get-teacher-info")]
  119. [ApiToken(Auth = "1502", Name = "学校教师信息", RW = "R", Limit = false)]
  120. public async Task<IActionResult> GetTeacherInfo(JsonElement json)
  121. {
  122. json.TryGetProperty("tmdid", out JsonElement _tmdid);
  123. var (id, school) = HttpContext.GetApiTokenInfo();
  124. Azure.Response responseSchoolTch = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School")
  125. .ReadItemStreamAsync($"{_tmdid}", new PartitionKey($"Teacher-{school}"));
  126. Azure.Response responseTch = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher")
  127. .ReadItemStreamAsync($"{_tmdid}", new PartitionKey($"Base"));
  128. Teacher teacher = null;
  129. if (responseTch.Status == 200)
  130. {
  131. teacher = JsonDocument.Parse(responseTch.Content).RootElement.Deserialize<Teacher>();
  132. }
  133. else
  134. {
  135. return Ok(new { error = 3, msg = "账号未创建!" });
  136. }
  137. if (responseSchoolTch.Status == 200 && teacher != null)
  138. {
  139. SchoolTeacher schoolTeacher = JsonDocument.Parse(responseSchoolTch.Content).RootElement.Deserialize<SchoolTeacher>();
  140. if (schoolTeacher.status.Equals("join"))
  141. {
  142. return Ok(new { teacher.id, teacher.name, teacher.picture, schoolTeacher.job, schoolTeacher.status, schoolTeacher.roles, schoolTeacher.subjectIds, school = teacher.schools?.Find(x => x.schoolId.Equals(school)) });
  143. }
  144. else
  145. {
  146. return Ok(new { error = 2, msg = "教师未加入学校!" });
  147. }
  148. }
  149. else
  150. {
  151. return Ok(new { error = 1, msg = "教师未就职该学校!" });
  152. }
  153. }
  154. }
  155. }