AbilityTaskMgmtController.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234
  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.Services.Common;
  16. using TEAMModelOS.SDK.Models.Cosmos.BI;
  17. namespace TEAMModeBI.Controllers.BIAbility
  18. {
  19. [Route("biabilitytask")]
  20. [ApiController]
  21. public class AbilityTaskMgmtController : ControllerBase
  22. {
  23. //获取配置信息
  24. private readonly IConfiguration _configuration;
  25. //数据容器
  26. private readonly AzureCosmosFactory _azureCosmos;
  27. //文件容器
  28. private readonly AzureStorageFactory _azureStorage;
  29. //钉钉提示信息
  30. private readonly DingDing _dingDing;
  31. private readonly Option _option;
  32. public AbilityTaskMgmtController(IConfiguration configuration, AzureCosmosFactory azureCosmos, DingDing dingDing, IOptionsSnapshot<Option> option, AzureStorageFactory azureStorage)
  33. {
  34. _azureCosmos = azureCosmos;
  35. _dingDing = dingDing;
  36. _option = option?.Value;
  37. _azureStorage = azureStorage;
  38. }
  39. /// <summary>
  40. /// 依据区级标准和能力编号查询能力点信息 章节集合
  41. /// </summary>
  42. /// <param name="jsonElement"></param>
  43. /// <returns></returns>
  44. [ProducesDefaultResponseType]
  45. [HttpPost("get-abilitytasksid")]
  46. public async Task<IActionResult> GetAbilityTasksId(JsonElement jsonElement)
  47. {
  48. try
  49. {
  50. if (!jsonElement.TryGetProperty("standard", out JsonElement standard)) return BadRequest();
  51. if (!jsonElement.TryGetProperty("abilityId", out JsonElement abilityId)) return BadRequest();
  52. var cosmosClient = _azureCosmos.GetCosmosClient();
  53. Ability ability = null;
  54. List<AbilityTaskTreeNode> abilityTaskTreeNodes = new List<AbilityTaskTreeNode>();//原始数据未排序
  55. List<AbilityTaskTreeNode> redtAbilityTaskTreeNodes = new List<AbilityTaskTreeNode>();//排序后的数据
  56. int rnodeCount = 0;
  57. ability = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").ReadItemAsync<Ability>($"{abilityId}", new PartitionKey($"Ability-{standard}"));
  58. 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}") }))
  59. {
  60. var rns = item.children.Select(x => x.rnodes);
  61. if (rns != null)
  62. {
  63. var list = rns.ToList();
  64. list.ForEach(x => { if (x.IsNotEmpty()) { rnodeCount += 1; } });
  65. }
  66. List<AbilityTaskTree> trees = AbilityService.ListToTree(item.children);
  67. AbilityTaskTreeNode abilityTaskTreeNode = new AbilityTaskTreeNode() { id = item.id, scope = item.scope, trees = trees, abilityId = item.abilityId, auth = item.auth, codeval = ability.school };
  68. abilityTaskTreeNodes.Add(abilityTaskTreeNode);
  69. }
  70. if (ability.abilityTaskIds.IsNotEmpty())
  71. {
  72. ability.abilityTaskIds.ForEach(x =>
  73. {
  74. for (int i = 0; i < abilityTaskTreeNodes.Count; i++)
  75. {
  76. if (abilityTaskTreeNodes[i].id.Equals(x))
  77. {
  78. redtAbilityTaskTreeNodes.Add(abilityTaskTreeNodes[i]);
  79. abilityTaskTreeNodes.RemoveAt(i);
  80. }
  81. }
  82. });
  83. redtAbilityTaskTreeNodes.AddRange(abilityTaskTreeNodes);
  84. return Ok(new { state = 200, abilityTaskTreeNodes = redtAbilityTaskTreeNodes });
  85. }
  86. else
  87. {
  88. return Ok(new { state = 200, abilityTaskTreeNodes = abilityTaskTreeNodes, rnodeCount });
  89. }
  90. }
  91. catch (Exception ex)
  92. {
  93. await _dingDing.SendBotMsg($"BI,{_option.Location} /biabilitytask/get-abilitytasksid \n {ex.Message}{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
  94. return BadRequest();
  95. }
  96. }
  97. /// <summary>
  98. /// 修改和新增章节下的节点数据
  99. /// </summary>
  100. /// <param name="abilityTask"></param>
  101. /// <returns></returns>
  102. [ProducesDefaultResponseType]
  103. [HttpPost("upd-abilitytask")]
  104. public async Task<IActionResult> UpdAbilityTask(RecordAbilityTask recordAbilityTask)//AbilityTask abilityTask)
  105. {
  106. AbilityTask abilityTask = recordAbilityTask.abilityTask;
  107. var cosmosClient = _azureCosmos.GetCosmosClient();
  108. //操作记录
  109. OperateLog operateLog = new OperateLog();
  110. string blobOrTable = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds().ToString();
  111. operateLog.PartitionKey = "OperateLog-BI";
  112. operateLog.RowKey = blobOrTable;
  113. operateLog.recordID = blobOrTable;
  114. operateLog.platformSource = "BI";
  115. operateLog.tmdId = $"{recordAbilityTask.tmdId}";
  116. operateLog.tmdName = $"{recordAbilityTask.tmdName}";
  117. //修改
  118. if (abilityTask.id != null)
  119. {
  120. try
  121. {
  122. //AbilityTask tempAbilityTask = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").ReadItemAsync<AbilityTask>(abilityTask.id, new PartitionKey($"AbilityTask-{abilityTask.standard}"));
  123. AbilityTask AbilityTask = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").ReplaceItemAsync<AbilityTask>(abilityTask,abilityTask.id, new PartitionKey($"AbilityTask-{abilityTask.standard}"));
  124. operateLog.operateDescribe = $"{recordAbilityTask.tmdName}【{recordAbilityTask.tmdId}】已操作修改章节功能,章节ID和分区键{abilityTask.id}And{abilityTask.code} ";
  125. operateLog.visitApi = "biabilitytask/upd-abilitytask";
  126. operateLog.operateTime = DateTime.Now;
  127. await _azureStorage.Save<OperateLog>(operateLog);
  128. return Ok(new { state = 200, abilityTask = AbilityTask });
  129. }
  130. catch (Exception ex)
  131. {
  132. await _dingDing.SendBotMsg($"BI,{_option.Location} biabilitytask/upd-abilitytask \n {ex.Message}{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
  133. return BadRequest();
  134. }
  135. }
  136. //新增
  137. else
  138. {
  139. try
  140. {
  141. AbilityTask tempAbilityTask = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").CreateItemAsync<AbilityTask>(abilityTask, new PartitionKey($"AbilityTask-{abilityTask.standard}"));
  142. operateLog.operateDescribe = $"{recordAbilityTask.tmdName}【{recordAbilityTask.tmdId}】已操作新增章节功能,章节ID和分区键{tempAbilityTask.id}And{tempAbilityTask.code} ";
  143. operateLog.visitApi = "biabilitytask/upd-abilitytask";
  144. operateLog.operateTime = DateTime.Now;
  145. await _azureStorage.Save<OperateLog>(operateLog);
  146. return Ok(new { state = 200, abilityTask = tempAbilityTask });
  147. }
  148. catch (Exception ex)
  149. {
  150. await _dingDing.SendBotMsg($"BI,{_option.Location} biabilitytask/upd-abilitytask \n {ex.Message}{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
  151. return BadRequest();
  152. }
  153. }
  154. }
  155. /// <summary>
  156. /// 依据id删除章节
  157. /// </summary>
  158. /// <param name="jsonElement"></param>
  159. /// <returns></returns>
  160. [ProducesDefaultResponseType]
  161. [HttpPost("del-abilitytask")]
  162. public async Task<IActionResult> DelAbilityTask(JsonElement jsonElement)
  163. {
  164. try
  165. {
  166. if (!jsonElement.TryGetProperty("standard", out JsonElement standard)) return BadRequest();
  167. if (!jsonElement.TryGetProperty("id", out JsonElement id)) return BadRequest();
  168. if (!jsonElement.TryGetProperty("tmdId", out JsonElement _tmdId)) return BadRequest(); //醍摩豆账户
  169. if (!jsonElement.TryGetProperty("tmdName", out JsonElement _tmdName)) return BadRequest(); //醍摩豆账号名称
  170. //操作记录
  171. string blobOrTable = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds().ToString();
  172. OperateLog operateLog = new OperateLog
  173. {
  174. PartitionKey = "OperateLog-BI",
  175. RowKey = blobOrTable,
  176. recordID = blobOrTable,
  177. platformSource = "BI",
  178. tmdId = $"{_tmdId}",
  179. tmdName = $"{_tmdName}",
  180. visitApi = "/biabilitytask/delabilitytask",
  181. operateTime = DateTime.Now,
  182. operateDescribe = $"{_tmdName}【{_tmdId}】已操作删除册别,删除ID:{id}"
  183. };
  184. var cosmosClient = _azureCosmos.GetCosmosClient();
  185. var response = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").DeleteItemStreamAsync(id.ToString(), new PartitionKey($"AbilityTask-{standard}"));
  186. await _azureStorage.Save<OperateLog>(operateLog);//保存操作记录
  187. return Ok(new { state = response.Status });
  188. }
  189. catch (Exception ex)
  190. {
  191. await _dingDing.SendBotMsg($"BI,{_option.Location} /biabilitytask/delabilitytask \n {ex.Message} {ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
  192. return BadRequest();
  193. }
  194. }
  195. public record RecordAbilityTask()
  196. {
  197. /// <summary>
  198. /// 醍摩豆账户ID
  199. /// </summary>
  200. public string tmdId { get; set; }
  201. /// <summary>
  202. /// 醍摩豆账户名称
  203. /// </summary>
  204. public string tmdName { get; set; }
  205. /// <summary>
  206. /// 章节信息
  207. /// </summary>
  208. public AbilityTask abilityTask { get; set; }
  209. }
  210. }
  211. }