AbilityTaskMgmtController.cs 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292
  1. using Microsoft.AspNetCore.Http;
  2. using Microsoft.AspNetCore.Mvc;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Linq;
  6. using System.Threading.Tasks;
  7. using Microsoft.Extensions.Configuration;
  8. using TEAMModelOS.SDK.DI;
  9. using TEAMModelOS.Models;
  10. using Microsoft.Extensions.Options;
  11. using System.Text.Json;
  12. using TEAMModelOS.SDK.Models;
  13. using Azure.Cosmos;
  14. using HTEXLib.COMM.Helpers;
  15. using TEAMModelOS.SDK.Models.Cosmos.Common;
  16. using System.Text;
  17. using TEAMModelBI.Filter;
  18. using TEAMModelOS.SDK.Services;
  19. using TEAMModelBI.Tool.Extension;
  20. using TEAMModelOS.SDK.Extension;
  21. using TEAMModelOS.SDK.Context.BI;
  22. namespace TEAMModelBI.Controllers.BINormal
  23. {
  24. [Route("biabilitytask")]
  25. [ApiController]
  26. public class AbilityTaskMgmtController : ControllerBase
  27. {
  28. //获取配置信息
  29. private readonly IConfiguration _configuration;
  30. //数据容器
  31. private readonly AzureCosmosFactory _azureCosmos;
  32. //文件容器
  33. private readonly AzureStorageFactory _azureStorage;
  34. //钉钉提示信息
  35. private readonly DingDing _dingDing;
  36. private readonly Option _option;
  37. public AbilityTaskMgmtController(IConfiguration configuration, AzureCosmosFactory azureCosmos, DingDing dingDing, IOptionsSnapshot<Option> option, AzureStorageFactory azureStorage)
  38. {
  39. _configuration = configuration;
  40. _azureCosmos = azureCosmos;
  41. _dingDing = dingDing;
  42. _option = option?.Value;
  43. _azureStorage = azureStorage;
  44. }
  45. /// <summary>
  46. /// 依据区级标准和能力编号查询能力点信息 章节集合 //已对接
  47. /// </summary>
  48. /// <param name="jsonElement"></param>
  49. /// <returns></returns>
  50. [ProducesDefaultResponseType]
  51. [HttpPost("get-abilitytasksid")]
  52. public async Task<IActionResult> GetAbilityTasksId(JsonElement jsonElement)
  53. {
  54. try
  55. {
  56. if (!jsonElement.TryGetProperty("standard", out JsonElement standard)) return BadRequest();
  57. if (!jsonElement.TryGetProperty("abilityId", out JsonElement abilityId)) return BadRequest();
  58. jsonElement.TryGetProperty("site", out JsonElement site);
  59. var cosmosClient = _azureCosmos.GetCosmosClient();
  60. if ($"{site}".Equals(BIConst.Global))
  61. cosmosClient = _azureCosmos.GetCosmosClient(name: BIConst.Global);
  62. Ability ability = null;
  63. List<AbilityTaskTreeNode> abilityTaskTreeNodes = new();//原始数据未排序
  64. List<AbilityTaskTreeNode> redtAbilityTaskTreeNodes = new();//排序后的数据
  65. int rnodeCount = 0;
  66. try
  67. {
  68. ability = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").ReadItemAsync<Ability>($"{abilityId}", new PartitionKey($"Ability-{standard}"));
  69. }
  70. catch
  71. {
  72. return Ok(new { state = 400,message="该ID未找到章节" });
  73. }
  74. await foreach (var item in cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").GetItemQueryIterator<AbilityTask>(queryText: $"select value(c) from c where c.abilityId='{abilityId}'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"AbilityTask-{standard}") }))
  75. {
  76. var rns = item.children.Select(x => x.rnodes);
  77. if (rns != null)
  78. {
  79. var list = rns.ToList();
  80. list.ForEach(x => { if (x.IsNotEmpty()) { rnodeCount += 1; } });
  81. }
  82. List<AbilityTaskTree> trees = AbilityService.ListToTree(item.children);
  83. AbilityTaskTreeNode abilityTaskTreeNode = new() { id = item.id, scope = item.scope, trees = trees, abilityId = item.abilityId, auth = item.auth, codeval = ability.school };
  84. abilityTaskTreeNodes.Add(abilityTaskTreeNode);
  85. }
  86. if (ability.abilityTaskIds.IsNotEmpty())
  87. {
  88. ability.abilityTaskIds.ForEach(x =>
  89. {
  90. for (int i = 0; i < abilityTaskTreeNodes.Count; i++)
  91. {
  92. if (abilityTaskTreeNodes[i].id.Equals(x))
  93. {
  94. redtAbilityTaskTreeNodes.Add(abilityTaskTreeNodes[i]);
  95. abilityTaskTreeNodes.RemoveAt(i);
  96. }
  97. }
  98. });
  99. redtAbilityTaskTreeNodes.AddRange(abilityTaskTreeNodes);
  100. return Ok(new { state = 200, abilityTaskTreeNodes = redtAbilityTaskTreeNodes });
  101. }
  102. else
  103. {
  104. return Ok(new { state = 200, abilityTaskTreeNodes = abilityTaskTreeNodes, rnodeCount });
  105. }
  106. }
  107. catch (Exception ex)
  108. {
  109. await _dingDing.SendBotMsg($"BI,{_option.Location} /biabilitytask/get-abilitytasksid \n {ex.Message}\n{ex.StackTrace}", GroupNames.成都开发測試群組);
  110. return BadRequest();
  111. }
  112. }
  113. /// <summary>
  114. /// 修改和新增章节数据 //已对接
  115. /// </summary>
  116. /// <param name="abilityTask"></param>
  117. /// <returns></returns>
  118. [ProducesDefaultResponseType]
  119. [AuthToken(Roles= "admin,assist")]
  120. [HttpPost("upd-abilitytask")]
  121. public async Task<IActionResult> UpdAbilityTask(RecordAbilityTask recordAbilityTask, [FromHeader] string site)//AbilityTask abilityTask)
  122. {
  123. try
  124. {
  125. var (_tmdId, _tmdName, pic, did, dname, dpic) = HttpJwtAnalysis.JwtXAuthBI(HttpContext.GetXAuth("AuthToken"), _option);
  126. var cosmosClient = _azureCosmos.GetCosmosClient();
  127. var tableClient = _azureStorage.GetCloudTableClient();
  128. var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");
  129. if ($"{site}".Equals(BIConst.Global))
  130. {
  131. cosmosClient = _azureCosmos.GetCosmosClient(name: BIConst.Global);
  132. tableClient = _azureStorage.GetCloudTableClient(BIConst.Global);
  133. blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public", BIConst.Global);
  134. }
  135. StringBuilder msgBuilder = new($"{_tmdName}【{_tmdId}】");
  136. string type = null;
  137. long now = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  138. foreach (var abilityTaskTree in recordAbilityTask.abilityTask)
  139. {
  140. if (!string.IsNullOrEmpty(abilityTaskTree.id))
  141. {
  142. AbilityTask abilityTask = null;
  143. try
  144. {
  145. abilityTask = await cosmosClient.GetContainer("TEAMModelOS", "Normal").ReadItemAsync<AbilityTask>(abilityTaskTree.id, new PartitionKey($"AbilityTask-{recordAbilityTask.standard}"));
  146. }
  147. catch
  148. {
  149. }
  150. if (abilityTask == null)
  151. {
  152. if (abilityTaskTree.trees.IsNotEmpty())
  153. {
  154. abilityTaskTree.trees.ForEach(x => x.id = abilityTaskTree.id);
  155. }
  156. List<Tnode> nodes = new();
  157. AbilityService.TreeToList(abilityTaskTree.trees, nodes, now);
  158. abilityTask = new();
  159. abilityTask.id = abilityTaskTree.id;
  160. abilityTask.children = nodes;
  161. abilityTask.code = $"AbilityTask-{recordAbilityTask.standard}";
  162. abilityTask.pk = "AbilityTask";
  163. abilityTask.ttl = -1;
  164. abilityTask.abilityId = abilityTaskTree.abilityId;
  165. abilityTask.scope = abilityTaskTree.scope;
  166. abilityTask.codeval = $"{recordAbilityTask.standard}";
  167. abilityTask.standard = $"{recordAbilityTask.standard}";
  168. await _azureCosmos.GetCosmosClient().GetContainer("TEAMModelOS", "Normal").CreateItemAsync<AbilityTask>(abilityTask, new Azure.Cosmos.PartitionKey($"AbilityTask-{recordAbilityTask.standard}"));
  169. msgBuilder.Append($"新增章节功能,章节ID:{abilityTask.id} 分区键:{abilityTask.code}");
  170. type = "abilityTask-add";
  171. }
  172. else
  173. {
  174. if (abilityTaskTree.trees.IsNotEmpty())
  175. {
  176. abilityTaskTree.trees.ForEach(x => x.id = abilityTaskTree.id);
  177. }
  178. List<Tnode> nodes = new();
  179. AbilityService.TreeToList(abilityTaskTree.trees, nodes, now);
  180. abilityTask.children = nodes;
  181. abilityTaskTree.auth = abilityTask.auth;
  182. await _azureCosmos.GetCosmosClient().GetContainer("TEAMModelOS", "Normal").ReplaceItemAsync<AbilityTask>(abilityTask, abilityTask.id, new Azure.Cosmos.PartitionKey($"AbilityTask-{recordAbilityTask.standard}"));
  183. msgBuilder.Append($"修改章节功能,章节ID:{abilityTask.id} 分区键:{abilityTask.code}");
  184. type = "abilityTask-update";
  185. }
  186. }
  187. else
  188. {
  189. string id = Guid.NewGuid().ToString();
  190. abilityTaskTree.id = id;
  191. if (abilityTaskTree.trees.IsNotEmpty())
  192. {
  193. abilityTaskTree.trees.ForEach(x => x.id = abilityTaskTree.id);
  194. }
  195. List<Tnode> nodes = new();
  196. AbilityService.TreeToList(abilityTaskTree.trees, nodes, now);
  197. AbilityTask abilityTask = new()
  198. {
  199. id = id,
  200. code = $"AbilityTask-{recordAbilityTask.standard}",
  201. pk = "AbilityTask",
  202. ttl = -1,
  203. abilityId = abilityTaskTree.abilityId,
  204. children = nodes,
  205. scope = abilityTaskTree.scope,
  206. codeval = $"{recordAbilityTask.standard}",
  207. standard = $"{recordAbilityTask.standard}"
  208. };
  209. await _azureCosmos.GetCosmosClient().GetContainer("TEAMModelOS", "Normal").CreateItemAsync<AbilityTask>(abilityTask, new Azure.Cosmos.PartitionKey($"AbilityTask-{recordAbilityTask.standard}"));
  210. msgBuilder.Append($"新增章节功能,章节ID:{abilityTask.id} 分区键:{abilityTask.code}");
  211. type = "abilityTask-add";
  212. }
  213. }
  214. //保存操作记录
  215. await AzureStorageBlobExtensions.SaveBILog(blobClient, tableClient, type, msgBuilder?.ToString(), _dingDing, httpContext: HttpContext);
  216. return Ok(new { state = 200, recordAbilityTask });
  217. }
  218. catch (Exception ex)
  219. {
  220. await _dingDing.SendBotMsg($"BI,{_option.Location} /biabilitytask/upd-abilitytask \n {ex.Message}\n{ex.StackTrace}", GroupNames.成都开发測試群組);
  221. return BadRequest();
  222. }
  223. }
  224. /// <summary>
  225. /// 依据id删除章节 //已对接
  226. /// </summary>
  227. /// <param name="jsonElement"></param>
  228. /// <returns></returns>
  229. [ProducesDefaultResponseType]
  230. [AuthToken(Roles = "admin,rdc,assist,sales")]
  231. [HttpPost("del-abilitytask")]
  232. public async Task<IActionResult> DelAbilityTask(JsonElement jsonElement)
  233. {
  234. try
  235. {
  236. if (!jsonElement.TryGetProperty("standard", out JsonElement standard)) return BadRequest();
  237. if (!jsonElement.TryGetProperty("id", out JsonElement id)) return BadRequest();
  238. jsonElement.TryGetProperty("site", out JsonElement site);
  239. var (_tmdId, _tmdName, pic, did, dname, dpic) = HttpJwtAnalysis.JwtXAuthBI(HttpContext.GetXAuth("AuthToken"), _option);
  240. var cosmosClient = _azureCosmos.GetCosmosClient();
  241. var tableClient = _azureStorage.GetCloudTableClient();
  242. var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");
  243. if ($"{site}".Equals(BIConst.Global))
  244. {
  245. cosmosClient = _azureCosmos.GetCosmosClient(name: BIConst.Global);
  246. tableClient = _azureStorage.GetCloudTableClient(BIConst.Global);
  247. blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public", BIConst.Global);
  248. }
  249. var response = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").DeleteItemStreamAsync(id.ToString(), new PartitionKey($"AbilityTask-{standard}"));
  250. string msg = $"{_tmdName}【{_tmdId}】删除册别,删除状态:{response.Status},删除ID:{id}";
  251. //保存操作记录
  252. await AzureStorageBlobExtensions.SaveBILog(blobClient, tableClient, "abilitytask-del", msg, _dingDing, httpContext: HttpContext);
  253. if (response.Status == 204)
  254. return Ok(new { state = 200 });
  255. else
  256. return Ok(new { state = response.Status });
  257. }
  258. catch (Exception ex)
  259. {
  260. await _dingDing.SendBotMsg($"BI,{_option.Location} /biabilitytask/del-abilitytask \n {ex.Message}\n{ex.StackTrace} ", GroupNames.成都开发測試群組);
  261. return Ok(new { state = 404 });
  262. }
  263. }
  264. public record RecordAbilityTask()
  265. {
  266. public string standard { get; set; }
  267. /// <summary>
  268. /// 章节信息
  269. /// </summary>
  270. //public List<AbilityTask> abilityTask { get; set; }
  271. public List<AbilityTaskTreeNode> abilityTask { get; set; }
  272. }
  273. }
  274. }