SyllabusController.cs 10.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211
  1. using Microsoft.AspNetCore.Mvc;
  2. using System.Collections.Generic;
  3. using System.Threading.Tasks;
  4. using TEAMModelOS.SDK;
  5. using TEAMModelOS.SDK.DI;
  6. using TEAMModelOS.SDK.Helper.Common.CollectionHelper;
  7. using System;
  8. using TEAMModelOS.SDK.Helper.Common.JsonHelper;
  9. using System.Linq;
  10. using TEAMModelOS.Models;
  11. using System.Text.Json;
  12. using TEAMModelOS.SDK.Extension;
  13. using TEAMModelOS.SDK.Models;
  14. using Microsoft.AspNetCore.Http;
  15. using TEAMModelOS.SDK.Models.Cosmos.Common;
  16. using Azure.Cosmos;
  17. using TEAMModelOS.Services.Common;
  18. using Microsoft.Extensions.Options;
  19. namespace TEAMModelOS.Controllers
  20. {
  21. [ProducesResponseType(StatusCodes.Status200OK)]
  22. [ProducesResponseType(StatusCodes.Status400BadRequest)]
  23. //[Authorize(Roles = "IES5")]
  24. [Route("common/syllabus")]
  25. [ApiController]
  26. //[Authorize]
  27. public class SyllabusController : ControllerBase
  28. {
  29. private readonly AzureCosmosFactory _azureCosmos;
  30. private readonly Option _option;
  31. private readonly DingDing _dingDing;
  32. public SyllabusController(AzureCosmosFactory azureCosmos, DingDing dingDing, IOptionsSnapshot<Option> option)
  33. {
  34. _azureCosmos = azureCosmos;
  35. _dingDing = dingDing;
  36. _option = option?.Value;
  37. }
  38. /// <summary>
  39. /// 批量保存或更新课纲
  40. ///
  41. /// </summary>
  42. /// <param name="request"></param>
  43. /// <returns></returns>
  44. [ProducesDefaultResponseType]
  45. [HttpPost("upsert-tree")]
  46. public async Task<IActionResult> SaveOrUpdateAsTree(List<SyllabusTreeNode> request)
  47. {
  48. foreach (SyllabusTreeNode syllabusTree in request) {
  49. List<Tnode> nodes = new List<Tnode>();
  50. SyllabusService.TreeToList(syllabusTree.trees, nodes);
  51. if (!string.IsNullOrEmpty(syllabusTree.id))
  52. {
  53. Syllabus syllabus = null;
  54. if (syllabusTree.scope == "school")
  55. {
  56. try
  57. {
  58. syllabus = await _azureCosmos.GetCosmosClient().GetContainer("TEAMModelOS", "School").ReadItemAsync<Syllabus>(syllabusTree.id, new Azure.Cosmos.PartitionKey($"Syllabus-{syllabusTree.volumeId}"));
  59. }
  60. catch
  61. {
  62. }
  63. if (syllabus == null)
  64. {
  65. syllabus = new Syllabus();
  66. syllabus.id = syllabusTree.id;
  67. syllabus.children = nodes;
  68. syllabus.code = $"Syllabus-{syllabusTree.volumeId}";
  69. syllabus.pk = "Syllabus";
  70. syllabus.ttl = -1;
  71. syllabus.volumeId = syllabusTree.volumeId;
  72. syllabus.scope = syllabusTree.scope;
  73. await _azureCosmos.GetCosmosClient().GetContainer("TEAMModelOS", "School").CreateItemAsync<Syllabus>(syllabus, new Azure.Cosmos.PartitionKey($"Syllabus-{syllabusTree.volumeId}"));
  74. }
  75. else
  76. {
  77. syllabus.children = nodes;
  78. syllabusTree.auth = syllabus.auth;
  79. await _azureCosmos.GetCosmosClient().GetContainer("TEAMModelOS", "School").ReplaceItemAsync<Syllabus>(syllabus,syllabus.id, new Azure.Cosmos.PartitionKey($"Syllabus-{syllabusTree.volumeId}"));
  80. }
  81. }
  82. else {
  83. try
  84. {
  85. syllabus = await _azureCosmos.GetCosmosClient().GetContainer("TEAMModelOS", "Teacher").ReadItemAsync<Syllabus>(syllabusTree.id, new Azure.Cosmos.PartitionKey($"Syllabus-{syllabusTree.volumeId}"));
  86. }
  87. catch
  88. {
  89. }
  90. if (syllabus == null)
  91. {
  92. syllabus = new Syllabus();
  93. syllabus.id = syllabusTree.id;
  94. syllabus.children = nodes;
  95. syllabus.code = $"Syllabus-{syllabusTree.volumeId}";
  96. syllabus.pk = "Syllabus";
  97. syllabus.ttl = -1;
  98. syllabus.volumeId = syllabusTree.volumeId;
  99. syllabus.scope = syllabusTree.scope;
  100. await _azureCosmos.GetCosmosClient().GetContainer("TEAMModelOS", "Teacher").CreateItemAsync<Syllabus>(syllabus, new Azure.Cosmos.PartitionKey($"Syllabus-{syllabusTree.volumeId}"));
  101. }
  102. else
  103. {
  104. syllabus.children = nodes;
  105. syllabusTree.auth = syllabus.auth;
  106. await _azureCosmos.GetCosmosClient().GetContainer("TEAMModelOS", "Teacher").UpsertItemAsync<Syllabus>(syllabus, new Azure.Cosmos.PartitionKey($"Syllabus-{syllabusTree.volumeId}"));
  107. }
  108. }
  109. }
  110. else {
  111. string id = Guid.NewGuid().ToString();
  112. syllabusTree.id = id;
  113. Syllabus syllabus = new Syllabus {
  114. id = id,
  115. code = $"Syllabus-{syllabusTree.volumeId}",
  116. pk = "Syllabus",
  117. ttl = -1,
  118. volumeId=syllabusTree.volumeId,
  119. children=nodes,
  120. scope = syllabusTree.scope
  121. };
  122. if (syllabusTree.scope == "school") {
  123. await _azureCosmos.GetCosmosClient().GetContainer("TEAMModelOS", "School").CreateItemAsync<Syllabus>(syllabus, new Azure.Cosmos.PartitionKey($"Syllabus-{syllabusTree.volumeId}"));
  124. } else {
  125. await _azureCosmos.GetCosmosClient().GetContainer("TEAMModelOS", "Teacher").CreateItemAsync<Syllabus>(syllabus, new Azure.Cosmos.PartitionKey($"Syllabus-{syllabusTree.volumeId}"));
  126. }
  127. }
  128. }
  129. return Ok(request);
  130. }
  131. /*
  132. {"code":"册别code:0baf00db-0768-4b62-a8f7-280f6bcebf71","scope":"school"}
  133. */
  134. /// <summary>
  135. /// 查找课纲
  136. /// </summary>
  137. /// <param name="request"></param>
  138. /// <returns></returns>
  139. [ProducesDefaultResponseType]
  140. [HttpPost("find-id")]
  141. public async Task<IActionResult> Find(JsonElement request)
  142. {
  143. var client = _azureCosmos.GetCosmosClient();
  144. if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
  145. if (!request.TryGetProperty("scope", out JsonElement scope)) return BadRequest();
  146. List<SyllabusTreeNode> treeNodes = new List<SyllabusTreeNode>();
  147. try {
  148. if (scope.ToString().Equals("school"))
  149. {
  150. await foreach (var item in client.GetContainer("TEAMModelOS", "School").GetItemQueryIterator<Syllabus>(queryText: $"select value(c) from c ",
  151. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"Syllabus-{code}") }))
  152. {
  153. List<SyllabusTree> trees = SyllabusService.ListToTree(item.children);
  154. SyllabusTreeNode tree = new SyllabusTreeNode() { id = item.id, scope =item.scope, trees = trees ,volumeId=item.volumeId,auth=item.auth};
  155. treeNodes.Add(tree);
  156. }
  157. }
  158. else
  159. {
  160. await foreach (var item in client.GetContainer("TEAMModelOS", "Teacher").GetItemQueryIterator<Syllabus>(queryText: $"select value(c) from c ",
  161. requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"Syllabus-{code}") }))
  162. {
  163. List<SyllabusTree> trees = SyllabusService.ListToTree(item.children);
  164. SyllabusTreeNode tree = new SyllabusTreeNode() { id = item.id, scope = item.scope, trees = trees, volumeId = item.volumeId, auth = item.auth };
  165. treeNodes.Add(tree);
  166. }
  167. }
  168. return Ok(new { tree= treeNodes });
  169. } catch (Exception ex) {
  170. await _dingDing.SendBotMsg($"OS,{_option.Location},common/syllabus/find-id\n{ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
  171. return Ok(new { tree= treeNodes });
  172. }
  173. }
  174. /*
  175. {"id":"章节id","code":"册别id","scope":"school/private"}
  176. */
  177. /// <summary>
  178. /// 删除章节
  179. /// </summary>
  180. /// <param name="request"></param>
  181. /// <returns></returns>
  182. [ProducesDefaultResponseType]
  183. [HttpPost("delete")]
  184. public async Task<IActionResult> Delete(JsonElement request)
  185. {
  186. if (!request.TryGetProperty("id", out JsonElement id)) return BadRequest();
  187. if (!request.TryGetProperty("code", out JsonElement code)) return BadRequest();
  188. if (!request.TryGetProperty("scope", out JsonElement scope)) return BadRequest();
  189. var client = _azureCosmos.GetCosmosClient();
  190. if (scope.ToString().Equals("school"))
  191. {
  192. var response = await client.GetContainer("TEAMModelOS", "School").DeleteItemStreamAsync(id.ToString(), new PartitionKey($"Syllabus-{code}"));
  193. return Ok(new { code = response.Status });
  194. }
  195. else
  196. {
  197. var response = await client.GetContainer("TEAMModelOS", "Teacher").DeleteItemStreamAsync(id.ToString(), new PartitionKey($"Syllabus-{code}"));
  198. return Ok(new { code = response.Status });
  199. }
  200. }
  201. }
  202. }