1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162 |
- using Azure.Cosmos;
- using Azure.Storage.Blobs.Models;
- using Azure.Storage.Sas;
- using DocumentFormat.OpenXml.Spreadsheet;
- using HTEXLib.COMM.Helpers;
- using HTEXLib.Models;
- using Microsoft.AspNetCore.Components;
- using Microsoft.Azure.Cosmos.Table;
- using Microsoft.Azure.Functions.Worker;
- using Microsoft.Azure.Functions.Worker.Http;
- using Microsoft.Extensions.Configuration;
- using Microsoft.Extensions.Hosting;
- using Microsoft.Extensions.Options;
- using OpenXmlPowerTools;
- using StackExchange.Redis;
- using System;
- using System.Collections.Generic;
- using System.Dynamic;
- using System.IO;
- using System.Linq;
- using System.Net;
- using System.Net.Http;
- using System.Net.Http.Json;
- using System.Reflection;
- using System.Security.Policy;
- using System.Text;
- using System.Text.Json;
- using System.Threading.Tasks;
- using System.Web;
- using TEAMModelOS.Models;
- using TEAMModelOS.SDK;
- using TEAMModelOS.SDK.DI;
- using TEAMModelOS.SDK.Extension;
- using TEAMModelOS.SDK.Models;
- using TEAMModelOS.SDK.Models.Service;
- using TEAMModelOS.SDK.Models.Table;
- using static TEAMModelOS.SDK.Models.Teacher;
- using static TEAMModelOS.SDK.Services.BlobService;
- namespace TEAMModelOS.FunctionV4
- {
- public class IESHttpTrigger
- {
- private readonly AzureCosmosFactory _azureCosmos;
- private readonly DingDing _dingDing;
- private readonly AzureStorageFactory _azureStorage;
- private readonly AzureRedisFactory _azureRedis;
- private readonly IHttpClientFactory _httpClient;
- private readonly Option _option;
- private readonly CoreAPIHttpService _coreAPIHttpService;
- private readonly IConfiguration _configuration;
- public IESHttpTrigger( AzureCosmosFactory azureCosmos, DingDing dingDing, CoreAPIHttpService coreAPIHttpService, AzureStorageFactory azureStorage
- , AzureRedisFactory azureRedis, IHttpClientFactory httpClient, IOptionsSnapshot<Option> option,
- IConfiguration configuration)
- {
- _azureCosmos = azureCosmos;
- _dingDing = dingDing;
- _azureStorage = azureStorage;
- _azureRedis = azureRedis;
- _httpClient = httpClient;
- _coreAPIHttpService = coreAPIHttpService;
- _option = option?.Value;
- _configuration = configuration;
- }
- /// <summary>
- /// </summary>
- /// <param name="req"></param>
- /// <param name="log"></param>
- /// <returns></returns>
- [Function("system-info-function")]
- public async Task<HttpResponseData> SystemInfo([HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = null)] HttpRequestData req)
- {
- var response = req.CreateResponse(HttpStatusCode.OK);
- Type attr = this.GetType();
- string currentDirectory = Path.GetDirectoryName(attr.Assembly.Location);
- Assembly assembly = Assembly.LoadFrom($"{currentDirectory}\\TEAMModelOS.FunctionV4.dll");
- var description = assembly.GetCustomAttribute<AssemblyDescriptionAttribute>().Description;
- //var v1 = Assembly.GetEntryAssembly().GetName().Version;
- //var v2 = Assembly.GetEntryAssembly().GetCustomAttribute<AssemblyFileVersionAttribute>().Version;
- // var description = Assembly.GetEntryAssembly().GetCustomAttribute<AssemblyDescriptionAttribute>().Description;
- var version = Assembly.GetEntryAssembly().GetCustomAttribute<AssemblyFileVersionAttribute>().Version;
- long nowtime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
- //Console.WriteLine($"Assembly.GetEntryAssembly().GetName().Version: " +
- // $"{Assembly.GetEntryAssembly().GetName().Version}");5.2107.12.1
- //Console.WriteLine($"Assembly.GetEntryAssembly().GetCustomAttribute<AssemblyFileVersionAttribute>().Version:" +
- // $"{Assembly.GetEntryAssembly().GetCustomAttribute<AssemblyFileVersionAttribute>().Version}");5.2107.12.1
- //Console.WriteLine($"Assembly.GetEntryAssembly().GetCustomAttribute<AssemblyInformationalVersionAttribute>().InformationalVersion:" +
- // $"{Assembly.GetEntryAssembly().GetCustomAttribute<AssemblyInformationalVersionAttribute>().InformationalVersion}");5.2107.12
- await response.WriteAsJsonAsync(new { version, description, nowtime });
- return response;
- }
- /// <summary>
- /// 空间不足发送通知
- /// </summary>
- /// <param name="req"></param>
- /// <param name="log"></param>
- /// <returns></returns>
- [Function("surplus-space-notify")]
- public async Task<HttpResponseData> SurplusSpaceNotify([HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = null)] HttpRequestData req) {
- var response = req.CreateResponse(HttpStatusCode.OK);
- string msg = "";
- try
- {
- string data = await new StreamReader(req.Body).ReadToEndAsync();
- var json = JsonDocument.Parse(data).RootElement;
- json.TryGetProperty("name", out JsonElement _name);
- json.TryGetProperty("scope", out JsonElement _scope);
- json.TryGetProperty("percent", out JsonElement _percent);
- double percent= _percent.GetDouble();
- string name = _name.ToString();
- string scope = _scope.ToString();
-
- int tag = 11;
- if (percent <= 10 && percent > 5)
- {
- tag = 10;
- }
- else if (percent <= 5 && percent > 0)
- {
- tag = 5;
- }
- else if (percent <= 0)
- {
- tag = 0;
- }
-
- List<IdNameCode> ids = new List<IdNameCode>();
- Teacher teacher = null;
- School school = null;
- if (scope.Equals("school", StringComparison.OrdinalIgnoreCase))
- {
- school = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>(name, new PartitionKey("Base"));
- string sql = $"select value c from c where c.code='Teacher-{name}' and c.status='join' and array_contains(c.roles,'admin') ";
- List<SchoolTeacher> adminTeachers = new List<SchoolTeacher>();
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School)
- .GetItemQueryIterator<SchoolTeacher>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{name}") }))
- {
- adminTeachers.Add(item);
- }
- if (adminTeachers.IsNotEmpty())
- {
- string sqlAdmin = $"select c.id,c.lang as code ,c.name from c where c.id in ({string.Join(",", adminTeachers.Select(z => $"'{z.id}'"))}) ";
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher)
- .GetItemQueryIterator<IdNameCode>(queryText: sqlAdmin, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Base") }))
- {
- ids.Add(item);
- }
- }
- }
- else
- {
- teacher= await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReadItemAsync<Teacher>(name, new PartitionKey("Base"));
- ids.Add(new IdNameCode
- {
- id = teacher.id,
- name = teacher.name,
- code = teacher.lang
- });
- }
- //如果已经扩容请忽略此通知!
- string key = scope.Equals("school", StringComparison.OrdinalIgnoreCase) ? $"Blob:Space:School:Notify:{name}" : $"Blob:Space:Private:Notify:{name}";
- foreach (var idnamecode in ids)
- {
- string filed = $"{idnamecode.id}-{tag}";
- BlobSpaceNotify? blobSpaceNotify = null;
- RedisValue value = await _azureRedis.GetRedisClient(8).HashGetAsync(key, filed);
- if (value != default && !value.IsNullOrEmpty)
- {
- blobSpaceNotify = value.ToString().ToObject<BlobSpaceNotify>();
- }
- if (tag < 11)
- {
- if (blobSpaceNotify == null)
- {
- if ("school".Equals(scope, StringComparison.OrdinalIgnoreCase))
- {
- _coreAPIHttpService.PushNotify(new List<IdNameCode> { idnamecode}, $"blob-space-school-notify", Constant.NotifyType_IES5_Management,
- new Dictionary<string, object> { { "tmdname", idnamecode.name }, { "schoolName", school.name }, { "percent", $"{tag}" }, { "schoolId", $"{school.id}" }, { "tmdid", idnamecode.id } },
- $"{Environment.GetEnvironmentVariable("Option:Location")}", _configuration, _dingDing, "");
- }
- else
- {
- _coreAPIHttpService.PushNotify(new List<IdNameCode> { idnamecode }, $"blob-space-private-notify", Constant.NotifyType_IES5_Management,
- new Dictionary<string, object> { { "tmdname", idnamecode.name }, { "percent", $"{tag}" }, { "tmdid", idnamecode.id } },
- $"{Environment.GetEnvironmentVariable("Option:Location")}", _configuration, _dingDing, "");
- }
- blobSpaceNotify = new BlobSpaceNotify { id = idnamecode.id, tag = tag, containerName = name, scope = scope, notifyIndex = Guid.NewGuid().ToString() };
- await _azureRedis.GetRedisClient(8).HashSetAsync(key, filed, blobSpaceNotify.ToJsonString());
- await _azureRedis.GetRedisClient(8).KeyExpireAsync(key, new TimeSpan(hours:7*24,minutes:0,seconds:0));
- }
- else {
- //已经发送过的不在提交
- }
- }
- else
- {
- if (blobSpaceNotify != null)
- {
- //撤销
- var index = blobSpaceNotify.notifyIndex;
- await _azureRedis.GetRedisClient(8).HashDeleteAsync(key, filed);
- _coreAPIHttpService.CancelNotify(index, $"{Environment.GetEnvironmentVariable("Option:Location")}", _configuration);
- }
-
- }
- }
-
- }
- catch (Exception ex) {
- await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")},空间不足,通知发送处理异常{ex.Message}\n{ex.StackTrace}", GroupNames.成都开发測試群組);
- }
- return response;
- }
- /// <summary>
- /// 区级艺术评价变更,异步同步已开启数据同步的学校。
- /// </summary>
- /// <param name="req"></param>
- /// <param name="log"></param>
- /// <returns></returns>
- [Function("area-artsetting-change")]
- public async Task<HttpResponseData> AreaArtSettingChange([HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = null)] HttpRequestData req) {
- var response = req.CreateResponse(HttpStatusCode.OK);
- string msg = "";
- try {
- string data = await new StreamReader(req.Body).ReadToEndAsync();
- var json = JsonDocument.Parse(data).RootElement;
- json.TryGetProperty("areaId", out JsonElement _areaId);
- string schoolSQL = $"select value c from c where c.areaId='{_areaId}'";
- List<School> schools = new List<School>();
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School)
- .GetItemQueryIterator<School>(queryText: schoolSQL, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Base") }))
- {
- schools.Add(item);
- }
- ArtSetting artSetting = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Normal).ReadItemAsync<ArtSetting>($"{_areaId}", new PartitionKey("ArtSetting"));
- foreach (var school in schools)
- {
- msg = school.ToJsonString();
- List<Period> periods = new List<Period>();
- var hastype_period = school.period.Where(p => !string.IsNullOrWhiteSpace(p.periodType));
- if (hastype_period.Any())
- {
- periods.AddRange(hastype_period);
- }
- var nottype_period = school.period.Where(p => string.IsNullOrWhiteSpace(p.periodType));
- if (nottype_period!=null && nottype_period.Count()>0)
- {
- foreach (var period in nottype_period)
- {
- if (period.name.Contains("小学"))
- {
- period.periodType= "primary";
- }
- if (period.name.Contains("初中"))
- {
- period.periodType = "junior";
- }
- if (period.name.Contains("高中"))
- {
- period.periodType = "senior";
- }
- if (string.IsNullOrWhiteSpace(period.periodType) && school.period.Count == 1)
- {
- if (school.name.Contains("小学"))
- {
- period.periodType = "primary";
-
- }
- if (school.name.Contains("初中"))
- {
- period.periodType = "junior";
- }
- if (school.name.Contains("高中"))
- {
- period.periodType = "senior";
- }
- }
- if (!string.IsNullOrWhiteSpace(period.periodType))
- {
- periods.Add(period);
- }
- }
- }
- foreach (var period in periods)
- {
- var dimension = artSetting.dimensions.FindAll(x => x.type.Intersect(new List<string> { period.periodType }).Any());
- var bindIds = period.subjects.Where(s => !string.IsNullOrWhiteSpace(s.bindId)).Select(x => x.bindId);
- //该学段未同步学科的。
- var unBindIds = dimension.Where(z => !string.IsNullOrWhiteSpace(z.subjectBind)).Select(x => x.subjectBind).ToHashSet().Except(bindIds);
- if (unBindIds.Any())
- {
- //尝试寻找同名学科且没有设置bindId的
- foreach (var unBindId in unBindIds)
- {
- var subjects = artSetting.dimensions.FindAll(d => !string.IsNullOrWhiteSpace(d.subjectBind) && !string.IsNullOrWhiteSpace(d.subject) && d.subjectBind.Equals(unBindId))?.Select(m => m.subject);
- if (subjects != null)
- {
- foreach (var subject in subjects)
- {
- //获取同名学科,且没绑定的
- var sub = period.subjects.FindAll(sub => sub.name.Contains(subject) && string.IsNullOrWhiteSpace(sub.bindId));
- if (sub.IsNotEmpty())
- {
- sub[0].bindId = unBindId;
- }
- else
- {
- period.subjects.Add(new Subject { id = Guid.NewGuid().ToString(), name = subject, bindId = unBindId, type = 1 });
- }
- break;
- }
- }
- }
- }
- var period_subjects = period.subjects.Where(s => !string.IsNullOrWhiteSpace(s.bindId));
- foreach (var subject in period_subjects)
- {
- var dim = dimension.Where(x => x.subjectBind.Equals(subject.bindId));
- if (dim.Any())
- {
- Knowledge old = null;
- string sql = $"select value(c) from c where c.periodId = '{period.id}'";
- string pk = $"Knowledge-{school.id}-{subject.id}";
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").
- GetItemQueryIterator<Knowledge>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey(pk) }))
- {
- old = item;
- break;
- }
- //同步知识块。
- if (old != null)
- {
- bool change = false;
- //如果之前的是1 来源于区级,后面因区级删除,应该还原为0。
- var oldBlocks = old.blocks.Select(x => x.name).ToHashSet();
- var dimBlocks = dim.SelectMany(d => d.blocks);
- //增加的
- var addBlocks = dimBlocks.Except(oldBlocks);
- //减少的
- var cutBlocks = oldBlocks.Except(dimBlocks);
- foreach (var add in addBlocks)
- {
- old.blocks.Add(new Block { name = add, source = 1 });
- change = true;
- }
- //减少的还原为0
- if (cutBlocks.Any())
- {
- old.blocks.ForEach(ob => {
- if (cutBlocks.Contains(ob.name))
- {
- ob.source = 0;
- change = true;
- }
- });
- }
- foreach (var db in dimBlocks) {
- old.blocks.ForEach(ob => {
- if (db.Equals(ob.name))
- {
- ob.source = 1;
- change = true;
- }
- });
- }
- if (change)
- {
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(old, old.id, new PartitionKey(old.code));
- }
- var count = new { pcount = old.points != null ? old.points.Count : 0, bcount = old.blocks != null ? old.blocks.Count : 0 };
- //处理知识点,知识块计数问题
- await _azureRedis.GetRedisClient(8).HashSetAsync($"Knowledge:Count:{old.owner}-{old.subjectId}", old.periodId, count.ToJsonString());
- }
- else
- {
- var blocks = dim.SelectMany(x => x.blocks).Select(bs => new Block { name = bs, source = 1 });
- if (blocks.Any())
- {
- var _new = new Knowledge
- {
- id = Guid.NewGuid().ToString(),
- pk = "Knowledge",
- code = pk,
- owner = school.id,
- periodId = period.id,
- subjectId = subject.id,
- blocks = blocks.ToList()
- };
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).CreateItemAsync(_new, new PartitionKey(_new.code));
- var count = new { pcount = _new.points != null ? _new.points.Count : 0, bcount = _new.blocks != null ? _new.blocks.Count : 0 };
- //处理知识点,知识块计数问题
- await _azureRedis.GetRedisClient(8).HashSetAsync($"Knowledge:Count:{_new.owner}-{_new.subjectId}", _new.periodId, count.ToJsonString());
- }
- }
- }
- }
- }
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(school, school.id, new PartitionKey(school.code));
- }
- return response;
- } catch (Exception ex) {
- await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")},area-artsetting-change,{ex.Message}\n{ex.StackTrace}\n{msg}", GroupNames.醍摩豆服務運維群組);
- }
- return response;
- }
- /// <summary>
- /// 行政班,学生毕业状态变更。
- /// </summary>
- /// <param name="req"></param>
- /// <param name="log"></param>
- /// <returns></returns>
- [Function("graduate-change")]
- public async Task<HttpResponseData> GraduateChange([HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = null)] HttpRequestData req) {
- var response = req.CreateResponse(HttpStatusCode.OK);
- dynamic jsondata =new ExpandoObject() ;
- try {
- string data = await new StreamReader(req.Body).ReadToEndAsync();
- var json = JsonDocument.Parse(data).RootElement;
- jsondata = json;
- //await _dingDing.SendBotMsg( "毕业状态变更:"+json.ToJsonString(), GroupNames.成都开发測試群組);
- string schoolId = null;
- if (json.TryGetProperty("schoolId", out JsonElement _schoolId))
- {
- schoolId = $"{_schoolId}";
- }
- if (string.IsNullOrEmpty(schoolId))
- {
- return response;
- }
- //计算毕业的
- if (json.TryGetProperty("graduate_classes", out JsonElement _graduate_classes))
- {
- List<Class> graduate_classes = _graduate_classes.ToObject<List<Class>>();
- if (graduate_classes.IsNotEmpty())
- {
- var ids = graduate_classes.Where(x => !string.IsNullOrWhiteSpace(x.id)).Select(x => $"'{x.id}'");
- List<Student> students = new List<Student>();
- string sql = $"select value c from c where (c.graduate = 0 or IS_DEFINED(c.graduate) = false) and c.classId in ({string.Join(",", ids)})";
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Student)
- .GetItemQueryIterator<Student>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Base-{schoolId}") }))
- {
- item.graduate = 1;
- students.Add(item);
- }
- foreach (var item in students)
- {
- item.graduate = 1;
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Student).ReplaceItemAsync<Student>(item, item.id, new PartitionKey($"Base-{schoolId}"));
- }
- foreach (var item in graduate_classes)
- {
- item.graduate = 1;
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync<Class>(item, item.id, new PartitionKey($"Class-{schoolId}"));
- }
- }
- }
- //未毕业的
- if (json.TryGetProperty("cancel_graduate_classes", out JsonElement _cancel_graduate_classes))
- {
- List<Class> cancel_graduate_classes = _cancel_graduate_classes.ToObject<List<Class>>();
- if (cancel_graduate_classes.IsNotEmpty())
- {
- var ids = cancel_graduate_classes.Where(x => !string.IsNullOrWhiteSpace(x.id)).Select(x => $"'{x.id}'");
- List<Student> students = new List<Student>();
- string sql = $"select value c from c where c.graduate =1 and c.classId in ({string.Join(",", ids)})";
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Student)
- .GetItemQueryIterator<Student>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Base-{schoolId}") }))
- {
- item.graduate = 0;
- students.Add(item);
- }
- foreach (var item in students)
- {
- item.graduate = 0;
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Student).ReplaceItemAsync<Student>(item, item.id, new PartitionKey($"Base-{schoolId}"));
- }
- foreach (var item in cancel_graduate_classes)
- {
- item.graduate = 0;
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync<Class>(item, item.id, new PartitionKey($"Class-{schoolId}"));
- }
- }
- }
- } catch (Exception ex) {
- await _dingDing.SendBotMsg($"graduate-change,{ex.Message}\n{ex.StackTrace}\n{jsondata.ToJsonString()}",GroupNames.醍摩豆服務運維群組);
- }
- return response;
- }
- /// <summary>
- /// 数据推送接口
- /// </summary>
- /// <param name="req"></param>
- /// <param name="log"></param>
- /// <returns></returns>
- [Function("lesson-tag-change")]
- public async Task<HttpResponseData> LessonTagChange([HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = null)] HttpRequestData req) {
- var response = req.CreateResponse(HttpStatusCode.OK);
- string data = await new StreamReader(req.Body).ReadToEndAsync();
- var json = JsonDocument.Parse(data).RootElement;
- List<TagOldNew> old_new = null;
- string school = null;
- if (json.TryGetProperty("school", out JsonElement _school))
- {
- school = _school.GetString();
- }
- if (json.TryGetProperty("old_new", out JsonElement _old_new))
- {
- old_new = _old_new.ToObject<List<TagOldNew>>();
- }
- if (old_new.IsNotEmpty() && !string.IsNullOrWhiteSpace(school))
- {
- foreach (var on in old_new)
- {
- List<LessonRecord> lessonRecords = new List<LessonRecord>();
- string sql = $"select value(c) from c where array_contains(c.category,'{on._old}') ";
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<LessonRecord>
- (queryText: sql.ToString(), requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"LessonRecord-{_school}") }))
- {
- lessonRecords.Add(item);
- }
- lessonRecords.ForEach(item =>
- {
- //修改标签
- if (!string.IsNullOrWhiteSpace(on._new))
- {
- for (int i = 0; i < item.category.Count; i++)
- {
- if (item.category[i].Equals(on._old))
- {
- item.category[i] = on._new;
- }
- }
- }
- else
- {
- //表示删除标签
- item.category.RemoveAll(x => x.Equals(on._old));
- }
- });
- foreach (var item in lessonRecords)
- {
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync(item, item.id, new PartitionKey(item.code));
- }
- }
- }
- await response.WriteAsJsonAsync(new { data = json });
- return response;
- }
- /// <summary>
- /// 数据推送接口
- /// </summary>
- /// <param name="req"></param>
- /// <param name="log"></param>
- /// <returns></returns>
- [Function("knowledge-change")]
- public async Task<HttpResponseData> KnowledgeChange([HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = null)] HttpRequestData req)
- {
- var response = req.CreateResponse(HttpStatusCode.OK);
- string data = await new StreamReader(req.Body).ReadToEndAsync();
- var json = JsonDocument.Parse(data).RootElement;
- List<TagOldNew> old_new = null;
- string school = null;
- if (json.TryGetProperty("school", out JsonElement _school))
- {
- school = _school.GetString();
- }
- if (json.TryGetProperty("old_new", out JsonElement _old_new))
- {
- old_new = _old_new.ToObject<List<TagOldNew>>();
- }
- if (old_new.IsNotEmpty() && !string.IsNullOrWhiteSpace(school))
- {
- foreach (var on in old_new)
- {
- List<ItemInfo> items = new List<ItemInfo>();
- string sql = $"select value(c) from c where array_contains(c.knowledge,'{on._old}') ";
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<ItemInfo>
- (queryText: sql.ToString(), requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Item-{_school}") }))
- {
- items.Add(item);
- }
- items.ForEach(item =>
- {
- //修改知识点
- if (!string.IsNullOrEmpty(on._new))
- {
- for (int i = 0; i < item.knowledge.Count; i++)
- {
- if (item.knowledge[i].Equals(on._old))
- {
- item.knowledge[i] = on._new;
- }
- }
- }
- else
- {
- //表示删除知识点
- item.knowledge.RemoveAll(x => x.Equals(on._old));
- }
- });
- foreach (var item in items)
- {
- ItemBlob itemBlob = null;
- try
- {
- BlobDownloadInfo blobDownloadResult = await _azureStorage.GetBlobContainerClient($"{school}").GetBlobClient($"/item/{item.id}/{item.id}.json").DownloadAsync();
- if (blobDownloadResult != null)
- {
- var blob = JsonDocument.Parse(blobDownloadResult.Content);
- itemBlob = blob.RootElement.ToObject<ItemBlob>();
- itemBlob.exercise.knowledge = item.knowledge;
- await _azureStorage.GetBlobContainerClient($"{school}").UploadFileByContainer(itemBlob.ToJsonString(), "item", $"{item.id}/{item.id}.json", true);
- }
- }
- catch (Exception ex)
- {
- itemBlob = null;
- }
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync(item, item.id, new PartitionKey(item.code));
- }
- }
- }
- await response.WriteAsJsonAsync(new { data = json });
- return response;
- }
- /// <summary>
- /// 在线人数记录
- /// </summary>
- /// <param name="msg"></param>
- /// <returns></returns>
- [Function("online-record")]
- public async Task<HttpResponseData> OnlineRecord([HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = null)] HttpRequestData req)
- {
- var response = req.CreateResponse(HttpStatusCode.OK);
- string data = await new StreamReader(req.Body).ReadToEndAsync();
- var json = JsonDocument.Parse(data).RootElement;
- try
- {
- string school = null;
- string scope = null;
- string id = null;
- string ip = null;
- int expire = 1;
- if (json.TryGetProperty("school", out JsonElement _school))
- school = _school.GetString();
- if (json.TryGetProperty("scope", out JsonElement _scope))
- scope = _scope.GetString();
- if (json.TryGetProperty("id", out JsonElement _id))
- id = _id.GetString();
- if (json.TryGetProperty("ip", out JsonElement _ip))
- ip = _ip.GetString();
- if (json.TryGetProperty("expire", out JsonElement _expire))
- expire = _expire.GetInt32();
- var table = _azureStorage.GetCloudTableClient().GetTableReference("IESLogin");
- var cosmosClient = _azureCosmos.GetCosmosClient();
- DateTimeOffset dateTime = DateTimeOffset.UtcNow;
- var dateHour = dateTime.ToString("yyyyMMddHH"); //获取当天的小时
- var dateDay = dateTime.ToString("yyyyMMdd"); //获取当天的日期
- var dateMonth = dateTime.ToString("yyyyMM");//获取当月的日期
- var currentHour = dateTime.Hour; //当前小时
- var currentDay = dateTime.Day; //当前天
- long Expire = dateTime.AddHours(expire).ToUnixTimeMilliseconds(); //token到期时间
- long now = dateTime.ToUnixTimeMilliseconds(); //当前时间戳
- DateTime hour = DateTime.UtcNow.AddHours(25); //25小时到期
- DateTime month = DateTime.UtcNow.AddDays(32); //一个月到期
- var delTbHour = dateTime.AddHours(-168).ToString("yyyyMMddHH"); //168小时前
- var delTbDay = dateTime.AddDays(-180).ToString("yyyyMMdd"); //180天前
- switch (scope)
- {
- case "teacher":
- try
- {
- Teacher teacher = await cosmosClient.GetContainer("TEAMModelOS", "Teacher").ReadItemAsync<Teacher>(id, new PartitionKey("Base"));
- teacher.loginInfos = new List<LoginInfo>() { new LoginInfo { expire = Expire, ip = ip, time = now } };
- await cosmosClient.GetContainer("TEAMModelOS", "Teacher").ReplaceItemAsync<Teacher>(teacher, teacher.id, new PartitionKey("Base"));
- }
- catch { }
- break;
- case "student":
- try
- {
- Student student = await cosmosClient.GetContainer("TEAMModelOS", Constant.Student).ReadItemAsync<Student>(id, new PartitionKey($"Base-{school}"));
- student.loginInfos = new List<LoginInfo>() { new LoginInfo { expire = Expire, ip = ip, time = now } };
- await cosmosClient.GetContainer("TEAMModelOS", Constant.Student).ReplaceItemAsync<Student>(student, student.id, new PartitionKey($"Base-{school}"));
- }
- catch { }
- break;
- case "tmduser":
- try
- {
- TmdUser tmdUser = await cosmosClient.GetContainer("TEAMModelOS", Constant.Student).ReadItemAsync<TmdUser>(id, new PartitionKey("Base"));
- tmdUser.loginInfos = new List<LoginInfo>() { new LoginInfo { expire = Expire, ip = ip, time = now } };
- await cosmosClient.GetContainer("TEAMModelOS", Constant.Student).ReplaceItemAsync<TmdUser>(tmdUser, tmdUser.id, new PartitionKey("Base"));
- }
- catch { }
- break;
- }
- //天
- SortedSetEntry[] dayCnt = null;
- //月
- SortedSetEntry[] monthCnt = null;
- try
- {
- await _azureRedis.GetRedisClient(8).SortedSetIncrementAsync($"Login:IES:{scope}:{dateDay}", $"{currentHour}", 1);//一天24小时 小时为单位
- await _azureRedis.GetRedisClient(8).SortedSetIncrementAsync($"Login:IES:{scope}:{dateMonth}", $"{currentDay}", 1); //一天的累计 天为单位
- var resDay = await _azureRedis.GetRedisClient(8).KeyTimeToLiveAsync($"Login:IES:{scope}:{dateDay}");
- if (resDay == null)
- await _azureRedis.GetRedisClient(8).KeyExpireAsync($"Login:IES:{scope}:{dateDay}", hour); //设置到期时间
- var rspMonth = await _azureRedis.GetRedisClient(8).KeyTimeToLiveAsync($"Login:IES:{scope}:{dateMonth}");
- if (rspMonth == null)
- await _azureRedis.GetRedisClient(8).KeyExpireAsync($"Login:IES:{scope}:{dateMonth}", month); //设置到期时间
- //保存当前小时统计
- dayCnt = _azureRedis.GetRedisClient(8).SortedSetRangeByScoreWithScores($"Login:IES:{scope}:{dateDay}");
- //保存当前的统计数据
- monthCnt = _azureRedis.GetRedisClient(8).SortedSetRangeByScoreWithScores($"Login:IES:{scope}:{dateMonth}");
- }
- catch { }
- if (dayCnt != null && dayCnt.Length > 0)
- {
- List<HourLogin> hourLogins = new();
- foreach (var dCnt in dayCnt)
- {
- if (((int)dCnt.Element) == currentHour)
- {
- var tphourLogins = await table.QueryWhereString<HourLogin>($"PartitionKey eq 'HourLogin' and RowKey eq '{dateHour}'");
- if (tphourLogins.Count > 0)
- {
- foreach (var hourLogin in tphourLogins)
- {
- if (scope.Equals("teacher"))
- hourLogin.Teacher = (int)dCnt.Score;
- else if (scope.Equals("student"))
- hourLogin.Student = (int)dCnt.Score;
- else
- hourLogin.TmdUser = (int)dCnt.Score;
- hourLogins.Add(hourLogin);
- }
- }
- else
- {
- HourLogin hourLogin = new() { PartitionKey = $"HourLogin", RowKey = dateHour, Hour = currentHour };
- if (scope.Equals("teacher"))
- {
- hourLogin.Teacher = 1;
- hourLogin.Student = 0;
- hourLogin.TmdUser = 0;
- }
- else if (scope.Equals("student"))
- {
- hourLogin.Teacher = 0;
- hourLogin.Student = 1;
- hourLogin.TmdUser = 0;
- }
- else
- {
- hourLogin.Teacher = 0;
- hourLogin.Student = 0;
- hourLogin.TmdUser = 1;
- }
- hourLogins.Add(hourLogin);
- }
- }
- }
- await table.SaveOrUpdateAll(hourLogins); //保存和更新保存当前小时登录次数
- }
- if (monthCnt != null && monthCnt.Length > 0)
- {
- List<DayLogin> dayLogins = new();
- foreach (var mCnt in monthCnt)
- {
- if (((int)mCnt.Element) == currentDay)
- {
- //保存当天的峰值
- var tbDays = await table.QueryWhereString<DayLogin>($"PartitionKey eq 'DayLogin' and RowKey eq '{dateDay}'");
- if (tbDays.Count > 0)
- {
- foreach (var dayLogin in tbDays)
- {
- if (scope.Equals("teacher"))
- dayLogin.Teacher = (int)mCnt.Score;
- else if (scope.Equals("student"))
- dayLogin.Student = (int)mCnt.Score;
- else
- dayLogin.TmdUser = (int)mCnt.Score;
- dayLogins.Add(dayLogin);
- }
- }
- else
- {
- //保存当月每天的峰值
- DayLogin dayLogin = new() { PartitionKey = $"DayLogin", RowKey = dateDay, Day = currentDay };
- if (scope.Equals("teacher"))
- {
- dayLogin.Teacher = 1;
- dayLogin.Student = 0;
- dayLogin.TmdUser = 0;
- }
- else if (scope.Equals("student"))
- {
- dayLogin.Teacher = 0;
- dayLogin.Student = 1;
- dayLogin.TmdUser = 0;
- }
- else
- {
- dayLogin.Teacher = 0;
- dayLogin.Student = 0;
- dayLogin.TmdUser = 1;
- }
- dayLogins.Add(dayLogin);
- }
- }
- }
- await table.SaveOrUpdateAll(dayLogins);// 保存当月每天在线数据
- }
- string tbHourSql = $"PartitionKey eq 'HourLogin' and RowKey le '{delTbHour}'";
- string tbDaySql = $"PartitionKey eq 'DayLogin' and RowKey le '{delTbDay}'";
- try
- {
- await table.DeleteStringWhere<HourLogin>(rowKey: tbHourSql); //删除168小时前的数据
- await table.DeleteStringWhere<DayLogin>(rowKey: tbDaySql); //删除180天前的数据
- }
- catch { }
- if (!string.IsNullOrWhiteSpace(school))
- {
- //天
- SortedSetEntry[] scDayCnt = null;
- //月
- SortedSetEntry[] scMonthCnt = null;
- try
- {
- await _azureRedis.GetRedisClient(8).SortedSetIncrementAsync($"Login:School:{school}:{scope}:{dateDay}", $"{currentHour}", 1);//当天当前小时在线人加1
- await _azureRedis.GetRedisClient(8).SortedSetIncrementAsync($"Login:School:{school}:{scope}:{dateMonth}", $"{currentDay}", 1); //当天的在线加1
- var reScDay = await _azureRedis.GetRedisClient(8).KeyTimeToLiveAsync($"Login:School:{school}:{scope}:{dateDay}");
- if (reScDay == null)
- await _azureRedis.GetRedisClient(8).KeyExpireAsync($"Login:School:{school}:{scope}:{dateDay}", hour); //设置到期时间
- var reScMonth = await _azureRedis.GetRedisClient(8).KeyTimeToLiveAsync($"Login:School:{school}:{scope}:{dateMonth}");
- if (reScMonth == null)
- await _azureRedis.GetRedisClient(8).KeyExpireAsync($"Login:School:{school}:{scope}:{dateMonth}", month); //设置到期时间
- //保存学校当天每小时的
- scDayCnt = _azureRedis.GetRedisClient(8).SortedSetRangeByScoreWithScores($"Login:School:{school}:{scope}:{dateDay}");
- //学校天峰值
- scMonthCnt = _azureRedis.GetRedisClient(8).SortedSetRangeByScoreWithScores($"Login:School:{school}:{scope}:{dateMonth}");
- }
- catch { }
- if (scDayCnt != null && scDayCnt.Length > 0)
- {
- List<HourLoginSchool> hourLoginSchools = new();
- foreach (var scDCnt in scDayCnt)
- {
- if (((int)scDCnt.Element) == currentHour)
- {
- var tmpHour = await table.QueryWhereString<HourLoginSchool>($"PartitionKey eq 'HourLogin-{school}' and RowKey eq '{dateHour}'");
- if (tmpHour.Count > 0)
- {
- foreach (var hLoginSc in tmpHour)
- {
- if (scope.Equals("teacher"))
- hLoginSc.Teacher = (int)scDCnt.Score;
- else if (scope.Equals("student"))
- hLoginSc.Student = (int)scDCnt.Score;
- else
- hLoginSc.TmdUser = (int)scDCnt.Score;
- hourLoginSchools.Add(hLoginSc);
- }
- }
- else
- {
- //学校小时峰值
- HourLoginSchool hourLoginSc = new() { PartitionKey = $"HourLogin-{school}", RowKey = dateHour, Hour = currentHour, School = school };
- if (scope.Equals("teacher"))
- {
- hourLoginSc.Teacher = 1;
- hourLoginSc.Student = 0;
- hourLoginSc.TmdUser = 0;
- }
- else if (scope.Equals("student"))
- {
- hourLoginSc.Teacher = 0;
- hourLoginSc.Student = 1;
- hourLoginSc.TmdUser = 0;
- }
- else
- {
- hourLoginSc.Teacher = 0;
- hourLoginSc.Student = 0;
- hourLoginSc.TmdUser = 1;
- }
- hourLoginSchools.Add(hourLoginSc);
- }
- }
- }
- await table.SaveOrUpdateAll(hourLoginSchools);
- }
- if (scMonthCnt != null && scMonthCnt.Length > 0)
- {
- List<DayLoginSchool> DayLoginSchools = new();
- foreach (var scMCnt in scMonthCnt)
- {
- if (((int)scMCnt.Element) == currentDay)
- {
- var tempDays = await table.QueryWhereString<DayLoginSchool>($"PartitionKey eq 'DayLogin-{school}' and RowKey eq '{dateDay}'");
- if (tempDays.Count > 0)
- {
- foreach (var dLoginSc in tempDays)
- {
- if (scope.Equals("teacher"))
- dLoginSc.Teacher = (int)scMCnt.Score;
- else if (scope.Equals("student"))
- dLoginSc.Student = (int)scMCnt.Score;
- else
- dLoginSc.TmdUser = (int)scMCnt.Score;
- DayLoginSchools.Add(dLoginSc);
- }
- }
- else
- {
- //学校天峰值
- DayLoginSchool dayLoginSc = new() { PartitionKey = $"DayLogin-{school}", RowKey = dateDay, Day = currentDay, School = school };
- if (scope.Equals("teacher"))
- {
- dayLoginSc.Teacher = 1;
- dayLoginSc.Student = 0;
- dayLoginSc.TmdUser = 0;
- }
- else if (scope.Equals("student"))
- {
- dayLoginSc.Teacher = 0;
- dayLoginSc.Student = 1;
- dayLoginSc.TmdUser = 0;
- }
- else
- {
- dayLoginSc.Teacher = 0;
- dayLoginSc.Student = 0;
- dayLoginSc.TmdUser = 1;
- }
- DayLoginSchools.Add(dayLoginSc);
- }
- }
- }
- await table.SaveOrUpdateAll(DayLoginSchools);//保存学校当月在线数据
- }
- string tbScHourSql = $"PartitionKey eq 'HourLogin-{school}' and RowKey le '{delTbHour}'";
- List<HourLogin> scHourLog = await table.QueryWhereString<HourLogin>(tbScHourSql);
- if (scHourLog.Count > 0)
- try
- {
- //await table.DeleteStringWhere<HourLogin>(tbScHourSql); //删除学校168小时前的数据
- await table.DeleteAll(scHourLog);
- }
- catch { }
- string tbScDaySql = $"PartitionKey eq 'DayLogin-{school}' and RowKey le '{delTbDay}'";
- List<DayLogin> scDayLog = await table.QueryWhereString<DayLogin>(tbScDaySql);
- if (scDayLog.Count > 0)
- try
- {
- //await table.DeleteStringWhere<DayLogin>(tbScDaySql); //删除学校180天前的数据
- await table.DeleteAll(scDayLog);
- }
- catch { }
- }
- await response.WriteAsJsonAsync(new { data = json });
- return response;
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"{Environment.GetEnvironmentVariable("Option:Location")}-online-record 人数记录异常{ex.Message}\n{ex.StackTrace}", GroupNames.成都开发測試群組);
- await response.WriteAsJsonAsync(new { data = json });
- return response;
- }
- }
- /// <summary>
- /// 艺术评测报告生成
- /// </summary>
- /// <param name="msg"></param>
- /// <returns></returns>
- //[Function("gen-art-pdf")]
- public async Task<HttpResponseData> GenArtPDF([HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = null)] HttpRequestData req) {
- var response = req.CreateResponse(HttpStatusCode.OK);
- try {
- string data = await new StreamReader(req.Body).ReadToEndAsync();
- var json = JsonDocument.Parse(data).RootElement;
- json.TryGetProperty("studentPdfs", out JsonElement _studentPdfs);
- json.TryGetProperty("artResults", out JsonElement _artResults);
- json.TryGetProperty("schoolCode", out JsonElement _schoolCode);
- List<ArtStudentPdf> studentPdfs = _studentPdfs.Deserialize<List<ArtStudentPdf>>();
- List<StudentArtResult> artResults = _artResults.Deserialize<List<StudentArtResult>>();
- List<Task<string>> uploads = new List<Task<string>>();
- studentPdfs.ForEach(x => {
- x.blob = $"art/{x.artId}/report/{x.studentId}.json";
- uploads.Add(_azureStorage.GetBlobContainerClient($"{_schoolCode}").UploadFileByContainer(x.ToJsonString(), "art", $"{x.artId}/report/{x.studentId}.json", true));
- });
- var uploadJsonUrls = await Task.WhenAll(uploads);
- var list = uploadJsonUrls.ToList();
- List<string> urls = new List<string>();
- (string uri, string sas) = _azureStorage.GetBlobContainerSAS($"{_schoolCode}", Azure.Storage.Sas.BlobContainerSasPermissions.Read);
- studentPdfs.ForEach(x => {
- string atrUrl = "https://teammodelos.blob.core.chinacloudapi.cn/0-public/art-report-template/report.html";
- var s = _azureStorage.GetBlobSAS($"{_schoolCode}", x.blob, BlobSasPermissions.Read);
- s = $"{HttpUtility.UrlEncode($"{s}", Encoding.UTF8)}";
- string url = $"{atrUrl}?url={s}&pdfpath={x.artId}/report/{x.studentId}";
- urls.Add(url);
- //var a = list.Find(l => l.Contains(x.studentId));
- //if (a != null) {
- // a = $"{HttpUtility.UrlEncode($"{a}?{sas}", Encoding.UTF8)}";
- // string url = $"{atrUrl}?url={a}&pdfpath={x.artId}/report/{x.studentId}";
- // urls.Add(url);
- //}
- });
- string env = "release";
- if (Environment.GetEnvironmentVariable("Option:Location").Contains("Test", StringComparison.CurrentCultureIgnoreCase) ||
- Environment.GetEnvironmentVariable("Option:Location").Contains("Dep", StringComparison.CurrentCultureIgnoreCase))
- {
- env = "develop";
- }
- int psize = 20;
- List<string> resUrls = new List<string>();
- if (urls.Count <= psize)
- {
- var screenshot = new ScreenshotDto
- {
- width = 1080,
- height = 1920,
- urls = urls,
- fileNameKey = "pdfpath",
- cnt = $"{_schoolCode}",
- root = "art",
- pagesize = 5,
- env = env
- };
- var st = screenshot.ToJsonString();
- await _dingDing.SendBotMsg($"艺术评测报告生成中:\n{st}", GroupNames.成都开发測試群組);
- var httpResponse = await _httpClient.CreateClient().PostAsJsonAsync("http://cdhabook.teammodel.cn:8805/screen/screenshot-pdf",
- screenshot
- );
-
- if (httpResponse.StatusCode == HttpStatusCode.OK)
- {
- JsonElement json_res = await httpResponse.Content.ReadFromJsonAsync<JsonElement>();
- resUrls = json_res.GetProperty("urls").Deserialize<List<string>>();
- await UpdatePdfBlob(artResults, resUrls);
- }
- }
- else {
- int pages = (urls.Count + psize) / psize;
- for (int i = 0; i < pages; i++) {
- var lists = urls.Skip((i) * psize).Take(psize).ToList();
- var screenshot = new ScreenshotDto
- {
- width = 1080,
- height = 1920,
- urls = lists,
- fileNameKey = "pdfpath",
- cnt = $"{_schoolCode}",
- root = "art",
- pagesize = 5,
- env = env
- };
- var st = screenshot.ToJsonString();
- // await _dingDing.SendBotMsg($"艺术评测报告生成中:\n{st}", GroupNames.成都开发測試群組);
- var httpResponse = await _httpClient.CreateClient().PostAsJsonAsync("http://cdhabook.teammodel.cn:8805/screen/screenshot-pdf",
- screenshot
- );
- if (httpResponse.StatusCode == HttpStatusCode.OK)
- {
- JsonElement json_res = await httpResponse.Content.ReadFromJsonAsync<JsonElement>();
- resUrls = json_res.GetProperty("urls").Deserialize<List<string>>();
- await UpdatePdfBlob(artResults, resUrls);
- }
- }
- }
- await response.WriteAsJsonAsync(new { data = new { count = studentPdfs.Count, resUrls } });
- } catch (Exception ex) {
- await _dingDing.SendBotMsg($"{ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
- }
- return response;
- }
- //https://teammodeltest.blob.core.chinacloudapi.cn/hbcn/art/e864a924-e644-42dc-87c4-e970e6185065/report/202201001.pdf
- private async Task UpdatePdfBlob(List<StudentArtResult> studentArts ,List<string> urls)
- {
- List<Task<ItemResponse<StudentArtResult>>> artResults =new List<Task<ItemResponse<StudentArtResult>>>();
- urls.ForEach(z => {
- var res = studentArts.FindAll(x => z.Contains(x.artId) && z.Contains($"{x.studentId}"));
- if (res.Any()) {
- if (string.IsNullOrWhiteSpace(res[0].blob)) {
- res[0].blob = $"art/{res[0].artId}/report/{res[0].studentId}.pdf";
- artResults.Add(_azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Student).ReplaceItemAsync(res[0], res[0].id, new PartitionKey(res[0].code)));
- }
- }
- });
- if (artResults.Any())
- {
- await Task.WhenAll(artResults);
- }
- }
- public class ScreenshotDto
- {
- public int width { get; set; } = 1920;
- public int height { get; set; } = 1080;
- public string? url { get; set; }
- /// <summary>
- /// 批量地址
- /// </summary>
- public List<string> urls { get; set; } = new List<string>();
- /// <summary>
- /// 提取参数的唯一id作为文件名
- /// </summary>
- public string? fileNameKey { get; set; }
- /// <summary>
- /// 存在哪个容器里
- /// </summary>
- public string? cnt { get; set; }
- public int delay { get; set; }
- public int pagesize { get; set; } = 5;
- public string? root { get; set; }
- public string? env { get; set; } = "release";
- public string? msgId { get; set; }
- }
- }
- }
|