AbilityMgmtController.cs 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336
  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.SDK.Models;
  10. using TEAMModelOS.Models;
  11. using Microsoft.Extensions.Options;
  12. using System.Text.Json;
  13. using Azure.Cosmos;
  14. using HTEXLib.COMM.Helpers;
  15. using System.Text;
  16. using TEAMModelOS.SDK.Models.Cosmos.BI;
  17. using TEAMModelOS.SDK.Extension;
  18. using TEAMModelBI.Filter;
  19. using TEAMModelBI.Tool.Extension;
  20. using TEAMModelBI.DI.BIAzureStorage;
  21. using TEAMModelOS.SDK.Context.BI;
  22. namespace TEAMModelBI.Controllers.BIAbility
  23. {
  24. [Route("biabilitymgmt")]
  25. [ApiController]
  26. public class AbilityMgmtController : ControllerBase
  27. {
  28. //获取配置信息
  29. private readonly IConfiguration _configuration;
  30. //数据容器
  31. private readonly AzureCosmosFactory _azureCosmos;
  32. //钉钉提示信息
  33. private readonly DingDing _dingDing;
  34. private readonly Option _option;
  35. private readonly AzureStorageFactory _azureStorage;
  36. public AbilityMgmtController(IConfiguration configuration, AzureCosmosFactory azureCosmos, DingDing dingDing, IOptionsSnapshot<Option> option, AzureStorageFactory azureStorage)
  37. {
  38. _configuration = configuration;
  39. _azureCosmos = azureCosmos;
  40. _dingDing = dingDing;
  41. _option = option?.Value;
  42. _azureStorage = azureStorage;
  43. }
  44. /// <summary>
  45. /// 依据区级的标准编号获取标准的编号集合
  46. /// </summary>
  47. /// <param name="jsonElement"></param>
  48. /// <returns></returns>
  49. [ProducesDefaultResponseType]
  50. [HttpPost("get-abilitys")]
  51. public async Task<IActionResult> GetAbilitysByStandard(JsonElement jsonElement)
  52. {
  53. try
  54. {
  55. if (!jsonElement.TryGetProperty("standard", out JsonElement standard)) return BadRequest();
  56. jsonElement.TryGetProperty("site", out JsonElement site);
  57. var cosmosClient = _azureCosmos.GetCosmosClient();
  58. if ($"{site}".Equals(BIConst.Global))
  59. cosmosClient = _azureCosmos.GetCosmosClient(name: BIConst.Global);
  60. List<Ability> abilities = new List<Ability>();
  61. string sqltxt = "select value(c) from c";
  62. await foreach (var item in cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").GetItemQueryIterator<Ability>(queryText: sqltxt, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Ability-{standard}") }))
  63. {
  64. abilities.Add(item);
  65. }
  66. return Ok(new { state = 200, abilities });
  67. }
  68. catch (Exception ex)
  69. {
  70. await _dingDing.SendBotMsg($"BI,{_option.Location} /biabilitymgmt/get-abilitysbystandard \n {ex.Message}\n{ex.StackTrace}", GroupNames.成都开发測試群組);
  71. return BadRequest();
  72. }
  73. }
  74. /// <summary>
  75. /// 依据能力标准的编号查询某个能力标准信息
  76. /// </summary>
  77. /// <param name="jsonElement"></param>
  78. /// <returns></returns>
  79. [ProducesDefaultResponseType]
  80. [HttpPost("get-abulityid")]
  81. public async Task<IActionResult> GetAbilityByID(JsonElement jsonElement)
  82. {
  83. try
  84. {
  85. if (!jsonElement.TryGetProperty("standard", out JsonElement standard)) return BadRequest();
  86. if (!jsonElement.TryGetProperty("abilityId", out JsonElement abilityId)) return BadRequest();
  87. jsonElement.TryGetProperty("site", out JsonElement site);
  88. var cosmosClient = _azureCosmos.GetCosmosClient();
  89. if ($"{site}".Equals(BIConst.Global))
  90. cosmosClient = _azureCosmos.GetCosmosClient(name: BIConst.Global);
  91. Ability ability = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").ReadItemAsync<Ability>($"{abilityId}", new PartitionKey($"Ability-{standard}"));
  92. return Ok(new { state = 200, ability = ability });
  93. }
  94. catch (Exception ex)
  95. {
  96. await _dingDing.SendBotMsg($"BI,{_option.Location} /biabilitymgmt/get-abulityid \n {ex.Message}\n{ex.StackTrace}", GroupNames.成都开发測試群組);
  97. return BadRequest();
  98. }
  99. }
  100. /// <summary>
  101. /// 依据区标准点和ID 删除册别
  102. /// </summary>
  103. /// <param name="jsonElement"></param>
  104. /// <returns></returns>
  105. [ProducesDefaultResponseType]
  106. [AuthToken(Roles = "admin,rdc,assist,sales")]
  107. [HttpPost("del-ability")]
  108. public async Task<IActionResult> DelAbility(JsonElement jsonElement)
  109. {
  110. try
  111. {
  112. if (!jsonElement.TryGetProperty("standard", out JsonElement standard)) return BadRequest();
  113. if (!jsonElement.TryGetProperty("id", out JsonElement id)) return BadRequest();
  114. jsonElement.TryGetProperty("site", out JsonElement site);
  115. var (_tmdId, _tmdName, pic, did, dname, dpic) = HttpJwtAnalysis.JwtXAuthBI(HttpContext.GetXAuth("AuthToken"), _option);
  116. if (string.IsNullOrEmpty($"{standard}"))
  117. {
  118. return Ok(new { state = 0,message= "standard 参数异常" });
  119. }
  120. var cosmosClient = _azureCosmos.GetCosmosClient();
  121. var tableClient = _azureStorage.GetCloudTableClient();
  122. var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");
  123. if ($"{site}".Equals(BIConst.Global))
  124. {
  125. cosmosClient = _azureCosmos.GetCosmosClient(name: BIConst.Global);
  126. tableClient = _azureStorage.GetCloudTableClient(BIConst.Global);
  127. blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public", BIConst.Global);
  128. }
  129. List<AbilityTask> syllabus = new List<AbilityTask>();
  130. string sql = $"select value(c) from c where c.abilityId='{id}'";
  131. var response = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").DeleteItemStreamAsync(id.ToString(), new PartitionKey($"Ability-{standard}"));
  132. await foreach (var item in cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").GetItemQueryIterator<AbilityTask>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"AbilityTask-{standard}") }))
  133. {
  134. syllabus.Add(item);
  135. }
  136. if (syllabus.IsNotEmpty())
  137. {
  138. var sresponse = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").DeleteItemsStreamAsync(syllabus.Select(x => x.id).ToList(), $"AbilityTask-{standard}");
  139. }
  140. if (response.Status == 200)
  141. {
  142. //保存操作记录
  143. //await _azureStorage.SaveBILog("abilityTask-del", $"{_tmdName}【{_tmdId}】删除册别,删除ID:{id}", _dingDing, httpContext: HttpContext);
  144. await AzureStorageBlobExtensions.SaveBILog(blobClient, tableClient, "abilityTask-del", $"{_tmdName}【{_tmdId}】删除册别,删除ID:{id}", _dingDing, httpContext: HttpContext);
  145. return Ok(new { state = 200 });
  146. }
  147. else return Ok(new { state = response.Status });
  148. }
  149. catch (Exception ex)
  150. {
  151. await _dingDing.SendBotMsg($"BI,{_option.Location} /biabilitymgmt/del-ability \n {ex.Message}\n{ex.StackTrace}", GroupNames.成都开发測試群組);
  152. return BadRequest();
  153. }
  154. }
  155. /// <summary>
  156. /// 更新和新增册别信息
  157. /// </summary>
  158. /// <param name="request"></param>
  159. /// <returns></returns>
  160. [ProducesDefaultResponseType]
  161. [AuthToken(Roles = "admin,rdc,assist,sales")]
  162. [HttpPost("upd-ability")]
  163. public async Task<IActionResult> UpdAbility(Ability ability, [FromHeader] string site)
  164. {
  165. try
  166. {
  167. var (_tmdId, _tmdName, pic, did, dname, dpic) = HttpJwtAnalysis.JwtXAuthBI(HttpContext.GetXAuth("AuthToken"), _option);
  168. StringBuilder stringBuilder = new StringBuilder($"{_tmdName}【{_tmdId}】");
  169. //Ability ability = recordAbility.ability;
  170. ability.pk = "Ability";
  171. ability.ttl = -1;
  172. Ability tempAbility = new Ability();
  173. if (!string.IsNullOrEmpty(ability.code) && !string.IsNullOrEmpty(ability.standard))
  174. {
  175. ability.code = ability.code.StartsWith("Ability-") ? ability.code : $"Ability-{ability.code}";
  176. }
  177. else return Ok(new { state = 0, message = "参数异常" });
  178. var azureClient = _azureCosmos.GetCosmosClient();
  179. var tableClient = _azureStorage.GetCloudTableClient();
  180. var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");
  181. if ($"{site}".Equals(BIConst.Global))
  182. {
  183. azureClient = _azureCosmos.GetCosmosClient(name: BIConst.Global);
  184. tableClient = _azureStorage.GetCloudTableClient(BIConst.Global);
  185. blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public", BIConst.Global);
  186. }
  187. string tempType = "";
  188. //新增册别
  189. if (string.IsNullOrEmpty(ability.id))
  190. {
  191. ability.comid = Guid.NewGuid().ToString();
  192. StringBuilder sqltxt = new StringBuilder("select value(c) from c where c.status = 1 ");
  193. if (!string.IsNullOrEmpty(ability.dimension))
  194. {
  195. sqltxt.Append($" and c.dimension = '{ability.dimension}' and c.name = '{ability.name}' and c.no = '{ability.no}' ");
  196. List<Ability> abilities = new List<Ability>();
  197. await foreach (var item in azureClient.GetContainer(Constant.TEAMModelOS, "Normal").GetItemQueryIterator<Ability>(queryText: sqltxt.ToString(), requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey(ability.code) }))
  198. {
  199. abilities.Add(item);
  200. }
  201. if (abilities.Count > 0)
  202. {
  203. return Ok(new { state = 1, message = "数据已存在" });
  204. }
  205. }
  206. else
  207. {
  208. return Ok(new { state = 2, mesages = "参数异常" });
  209. }
  210. ability.id = Guid.NewGuid().ToString();
  211. ability.creatorId = string.IsNullOrEmpty($"{ability.creatorId}") ? $"{_tmdId}" : ability.creatorId;
  212. ability.creatorName = string.IsNullOrEmpty($"{ability.creatorName}") ? $"{_tmdName}" : ability.creatorName;
  213. tempAbility = await azureClient.GetContainer("TEAMModelOS", "Normal").CreateItemAsync(ability, new PartitionKey(ability.code));
  214. stringBuilder.Append($"新增册别信息,册别编号:{tempAbility.id},册别名称:{tempAbility.name}");
  215. tempType = "ability-add";
  216. }
  217. //更新册别
  218. else
  219. {
  220. try
  221. {
  222. tempAbility = await azureClient.GetContainer(Constant.TEAMModelOS, "Normal").ReplaceItemAsync<Ability>(ability, ability.id, new PartitionKey(ability.code));
  223. stringBuilder.Append($"更新册别信息,册别编号:{tempAbility.id},册别名称:{tempAbility.name}");
  224. tempType = "ability-update";
  225. }
  226. catch (Exception ex)
  227. {
  228. await _dingDing.SendBotMsg($"BI,{_option.Location} /biabilitymgmt/upd-ability \n {ex.Message}\n{ex.StackTrace}", GroupNames.成都开发測試群組);
  229. return BadRequest();
  230. }
  231. }
  232. //保存操作记录
  233. //await _azureStorage.SaveBILog(tempType?.ToString(), stringBuilder?.ToString(), _dingDing, httpContext: HttpContext);
  234. await AzureStorageBlobExtensions.SaveBILog(blobClient, tableClient, tempType?.ToString(), stringBuilder?.ToString(), _dingDing, httpContext: HttpContext);
  235. return Ok(new { state = 200, Ability = tempAbility });
  236. }
  237. catch (Exception ex)
  238. {
  239. await _dingDing.SendBotMsg($"BI,{_option.Location} biabilitymgmt/upd-ability \n {ex.Message}\n{ex.StackTrace}", GroupNames.成都开发測試群組);
  240. return BadRequest();
  241. }
  242. }
  243. /// <summary>
  244. /// 修改是否必修的接口
  245. /// </summary>
  246. /// <param name="jsonElement"></param>
  247. /// <returns></returns>
  248. [ProducesDefaultResponseType]
  249. [AuthToken(Roles = "admin,rdc,assist,sales")]
  250. [HttpPost("upd-currency")]
  251. public async Task<IActionResult> UpdateCurrency(JsonElement jsonElement)
  252. {
  253. try
  254. {
  255. if (!jsonElement.TryGetProperty("isRequired", out JsonElement isRequired)) return BadRequest(); //是否是必修集合
  256. jsonElement.TryGetProperty("site", out JsonElement site);
  257. var (_tmdId, _tmdName, pic, did, dname, dpic) = HttpJwtAnalysis.JwtXAuthBI(HttpContext.GetXAuth("AuthToken"), _option);
  258. var currencys = isRequired.ToObject<List<IsRequired>>();
  259. var cosmosClient = _azureCosmos.GetCosmosClient();
  260. var tableClient = _azureStorage.GetCloudTableClient();
  261. var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");
  262. if ($"{site}".Equals(BIConst.Global))
  263. {
  264. cosmosClient = _azureCosmos.GetCosmosClient(name: BIConst.Global);
  265. tableClient = _azureStorage.GetCloudTableClient(BIConst.Global);
  266. blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public", BIConst.Global);
  267. }
  268. foreach (var item in currencys)
  269. {
  270. Ability ability = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").ReadItemAsync<Ability>(item.abilityId, new PartitionKey($"Ability-{item.standard}"));
  271. ability.currency = item.currency;
  272. await cosmosClient.GetContainer(Constant.TEAMModelOS, "Normal").ReplaceItemAsync(ability, ability.id, new PartitionKey(ability.code));
  273. }
  274. //保存操作记录
  275. //await _azureStorage.SaveBILog("ability-update", $"{_tmdName}【{_tmdId}】设置是否必修状态。标准:{currencys[0].standard}", _dingDing, httpContext: HttpContext);
  276. await AzureStorageBlobExtensions.SaveBILog(blobClient, tableClient, "ability-update", $"{_tmdName}【{_tmdId}】设置是否必修状态。标准:{currencys[0].standard}", _dingDing, httpContext: HttpContext);
  277. return Ok(new { state = 200, currencys });
  278. }
  279. catch (Exception ex)
  280. {
  281. await _dingDing.SendBotMsg($"BI,{_option.Location} /biabilitymgmt/upd-currency \n {ex.Message}\n{ex.StackTrace}", GroupNames.成都开发測試群組);
  282. return BadRequest();
  283. }
  284. }
  285. public record IsRequired()
  286. {
  287. public string abilityId { get; set; }
  288. public string standard { get; set; }
  289. public int currency { get; set; }
  290. }
  291. /// <summary>
  292. /// 新增和修改是使用
  293. /// </summary>
  294. public record RecordAbility()
  295. {
  296. public string tmdId { get; set; }
  297. public string tmdName { get; set; }
  298. public Ability ability { get; set; }
  299. }
  300. }
  301. }