12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879 |
- using Azure.Cosmos;
- using DocumentFormat.OpenXml.Spreadsheet;
- using HTEXLib.COMM.Helpers;
- using Microsoft.AspNetCore.Authorization;
- using Microsoft.AspNetCore.Hosting;
- using Microsoft.AspNetCore.Http;
- using Microsoft.AspNetCore.Mvc;
- using Microsoft.Extensions.Configuration;
- using Microsoft.Extensions.Options;
- using Newtonsoft.Json;
- using StackExchange.Redis;
- using System;
- using System.Collections.Generic;
- using System.Dynamic;
- using System.Globalization;
- using System.IO;
- using System.Linq;
- using System.Net;
- using System.Net.Http;
- using System.Net.Http.Headers;
- using System.Net.Http.Json;
- using System.Text;
- using System.Text.Json;
- using System.Threading.Tasks;
- using TEAMModelOS.Filter;
- using TEAMModelOS.Models;
- using TEAMModelOS.SDK;
- using TEAMModelOS.SDK.Context.Constant;
- using TEAMModelOS.SDK.DI;
- using TEAMModelOS.SDK.Extension;
- using TEAMModelOS.SDK.Models;
- using TEAMModelOS.SDK.Models.Cosmos.BI;
- using TEAMModelOS.SDK.Models.Cosmos.School;
- using TEAMModelOS.SDK.Models.Service.BI;
- using static TEAMModelOS.SDK.Models.Teacher;
- namespace TEAMModelOS.Controllers
- {
- [ProducesResponseType(StatusCodes.Status200OK)]
- [ProducesResponseType(StatusCodes.Status400BadRequest)]
- [Route("school/init")]
- [ApiController]
- public class SchoolController : ControllerBase
- {
- public AzureCosmosFactory _azureCosmos;
- private readonly AzureStorageFactory _azureStorage;
- private readonly AzureRedisFactory _azureRedis;
- private readonly DingDing _dingDing;
- private readonly Option _option;
- int baseSpaceSize = 10; //學校保底空間大小(1G)
- private readonly double bytes = 1073741824;
- private readonly int redisAclassoneDbNum = 8; //AclassOne Redis DB號
- private readonly IConfiguration _configuration;
- private readonly CoreAPIHttpService _coreAPIHttpService;
- private readonly IHttpClientFactory _httpClient;
- private readonly HttpTrigger _httpTrigger;
- private readonly IWebHostEnvironment _environment;
- public SchoolController(IWebHostEnvironment environment, HttpTrigger httpTrigger, CoreAPIHttpService coreAPIHttpService, AzureCosmosFactory azureCosmos, AzureStorageFactory azureStorage, AzureRedisFactory azureRedis, DingDing dingDing, IOptionsSnapshot<Option> option, IConfiguration configuration, IHttpClientFactory httpClient)
- {
- _azureCosmos = azureCosmos;
- _azureStorage = azureStorage;
- _azureRedis = azureRedis;
- _dingDing = dingDing;
- _option = option?.Value;
- _configuration = configuration;
- _coreAPIHttpService = coreAPIHttpService;
- _httpClient = httpClient;
- _httpTrigger = httpTrigger;
- _environment = environment;
- }
- /// <summary>
- /// 修改学校信息
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [HttpPost("set-school-info")]
- [Authorize(Roles = "IES")]
- [AuthToken(Roles = "admin", Permissions = "train-appraise")]
- public async Task<IActionResult> SetTeacherInfo(JsonElement request)
- {
- var client = _azureCosmos.GetCosmosClient();
- if (!request.TryGetProperty("opt", out JsonElement _opt))
- {
- return BadRequest();
- }
- var (userid, name, _, school) = HttpContext.GetAuthTokenInfo();
- try
- {
- SchoolTeacher teacher = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>(userid, new PartitionKey($"Teacher-{school}"));
- switch (true)
- {
- //修改互评开关
- case bool when $"{_opt}".Equals("modify-hpappraise", StringComparison.OrdinalIgnoreCase):
- int hpappraise = -1;
- if (request.TryGetProperty("hpappraise", out JsonElement _hpappraise))
- {
- int.TryParse($"{_hpappraise}", out hpappraise);
- }
- if (hpappraise != -1)
- {
- School schoolData = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>(school, new PartitionKey("Base"));
- schoolData.hpappraise = hpappraise;
- await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(schoolData, school, new PartitionKey("Base"));
- return Ok(new { status = 200 });
- }
- else
- {
- return Ok(new { error = 1, msg = "参数异常!" });
- }
- default:
- return Ok(new { error = 1, msg = "参数异常!" });
- }
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/init/set-teacher-info()\n{ex.Message}\n{ex.StackTrace}{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
- return Ok(new { error = 1, msg = "参数异常!" });
- }
- }
- /// <summary>
- /// 保存或更新学校
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- //[AuthToken(Roles = "admin")]
- [HttpPost("upsert")]
- [AuthToken(Roles = "teacher,admin,student")]
- #if !DEBUG
- [Authorize(Roles = "IES")]
- #endif
- public async Task<IActionResult> Upsert(School school)
- {
- var (userid, name, _, _school) = HttpContext.GetAuthTokenInfo();
- try
- {
- var tableClient = _azureStorage.GetCloudTableClient();
- var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");
- School schoolInfo = new();
- var client = _azureCosmos.GetCosmosClient();
- var schoolContainer = client.GetContainer(Constant.TEAMModelOS, "School");
- var response = await schoolContainer.ReadItemStreamAsync(school.id, new PartitionKey($"Base"));
- if (response.Status == 200)
- {
- School db_school = JsonDocument.Parse(response.Content).RootElement.Deserialize<School>();
- //计算 比较更改前后 学段的年级变化的学段,并重新处理行政班的毕业状态。
- //开启课例设置是否变更
- if (db_school.openLessonRecord != school.openLessonRecord)
- {
- string opentype = "close-lesson-record";
- string openstr = "关闭";
- if (school.openLessonRecord)
- {
- openstr = "开启";
- opentype = "open-lesson-record";
- }
- StringBuilder strMsg = new($"{name}【{userid}】{openstr}【{school.name}-{school.id}】的课堂记录菜单");
- //
- await _azureStorage.SaveLog(opentype, strMsg?.ToString(), _dingDing, "school", httpContext: HttpContext);
- }
- //变更后
- List<KeyValuePair<string, int>> period_gradeCount = new List<KeyValuePair<string, int>>();
- school.period.ForEach(z => { period_gradeCount.Add(new KeyValuePair<string, int>(z.id, z.grades.Count)); });
- //变更前
- List<KeyValuePair<string, int>> dbperiod_gradeCount = new List<KeyValuePair<string, int>>();
- db_school.period.ForEach(z => { dbperiod_gradeCount.Add(new KeyValuePair<string, int>(z.id, z.grades.Count)); });
- List<string> periodIds = new List<string>();
- period_gradeCount.ForEach(x =>
- {
- var gradeCount = dbperiod_gradeCount.Find(y => x.Key.Equals(y.Key));
- if (!string.IsNullOrWhiteSpace(gradeCount.Key))
- {
- if (gradeCount.Value != x.Value)
- {
- periodIds.Add(x.Key);
- }
- }
- });
- await SchoolService.DoGraduateClasses(_httpTrigger, _azureCosmos, periodIds, school, _option, _dingDing);
- //变更教师关联的学校基本信息
- string sql = $"SELECT distinct value(c) FROM c join A1 in c.schools where A1.schoolId='{school.id}'";
- List<Teacher> teachers = new List<Teacher>();
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIterator<Teacher>(sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey("Base") }))
- {
- teachers.Add(item);
- }
- foreach (var item in teachers)
- {
- Teacher.TeacherSchool teacherSchool = item.schools.Find(x => x.schoolId.Equals(school.id));
- if (teacherSchool != null)
- {
- teacherSchool.name = school.name;
- teacherSchool.picture = school.picture;
- teacherSchool.areaId = school.areaId;
- }
- await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync(item, item.id, new PartitionKey($"Base"));
- }
- schoolInfo = await schoolContainer.UpsertItemAsync(school, new PartitionKey($"Base"));
- }
- else
- {
- school.code = "Base";
- schoolInfo = await schoolContainer.CreateItemAsync(school, new PartitionKey($"Base"));
- }
- //创建/修改学校信息中间件
- //_ = _httpTrigger.RequestHttpTrigger(new { school = $"{school}" }, _option.Location, "set-sc-birelation");
- await BIStats.SetSchoolBIRelation(client, blobClient, tableClient, _dingDing, schoolInfo);
- return Ok(new { schoolInfo });
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"CoreAPI2,{_option.Location},school/upsert()\n{ex.Message}\n{ex.StackTrace}\n", GroupNames.醍摩豆服務運維群組);
- return BadRequest();
- }
- }
- /// <summary>
- /// 查找学校
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- //[AuthToken(Roles = "teacher")]
- [HttpPost("find")]
- [AuthToken(Roles = "teacher,admin,student")]
- #if !DEBUG
- [Authorize(Roles = "IES")]
- #endif
- public async Task<IActionResult> Find(JsonElement request)
- {
- if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
- var client = _azureCosmos.GetCosmosClient();
- List<School> schools = new();
- var query = $"select c.id,c.pk,c.code, c.name,c.region,c.province,c.city,c.timeZone,c.picture,c.size,c.period,c.campuses from c where c.id ='{school_code}'";
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
- {
- using var json = await JsonDocument.ParseAsync(item.ContentStream);
- if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- schools.Add(obj.ToObject<School>());
- }
- }
- }
- return Ok(new { schools });
- /* ResponseBuilder builder = ResponseBuilder.custom();
- if (request.TryGetProperty("code", out JsonElement code) &&! string.IsNullOrEmpty(code.ToString()))
- {
- List<School> sc = await _azureCosmos.FindByDict<School>(request);
- return builder.Data(sc).build();
- }
- else {
- return builder.Data(null).build();
- }*/
- }
- /// <summary>
- /// 取得所有學校(只取基本資料)
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [HttpPost("get-all-school-base")]
- [AuthToken(Roles = "teacher,admin,student")]
- #if !DEBUG
- [Authorize(Roles = "IES")]
- #endif
- public async Task<IActionResult> GetAllSchoolBaesInfo(JsonElement request)
- {
- var client = _azureCosmos.GetCosmosClient();
- List<object> schools = new();
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: $"SELECT c.id, c.code, c.name, c.region, c.province, c.city, c.address, c.picture FROM c ", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Base") }))
- {
- using var json = await JsonDocument.ParseAsync(item.ContentStream);
- if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- schools.Add(obj.ToObject<object>());
- }
- }
- }
- return Ok(new { schools });
- }
- /// <summary>
- /// 取得某學校基本資料
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [HttpPost("get-school-base")]
- [AuthToken(Roles = "teacher,admin,student")]
- #if !DEBUG
- [Authorize(Roles = "IES")]
- #endif
- public async Task<IActionResult> GetSchoolBaesInfo(JsonElement request)
- {
- if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
- var client = _azureCosmos.GetCosmosClient();
- var schoolContainer = client.GetContainer(Constant.TEAMModelOS, "School");
- //取得學校學制、年級、教室
- List<object> classes = new List<object>();
- await foreach (var item in schoolContainer.GetItemQueryStreamIterator(queryText: $"SELECT c.id, c.name, c.gradeId FROM c", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Class-{school_code}") }))
- {
- var jsonc = await JsonDocument.ParseAsync(item.ContentStream);
- foreach (var classeinfo in jsonc.RootElement.GetProperty("Documents").EnumerateArray())
- {
- dynamic classExtobj = new ExpandoObject();
- classExtobj.id = classeinfo.GetProperty("id");
- classExtobj.name = classeinfo.GetProperty("name");
- classExtobj.gradeId = classeinfo.GetProperty("gradeId");
- classes.Add(classExtobj);
- }
- }
- List<object> periods = new List<object>();
- List<object> grades = new List<object>();
- var responsesch = await schoolContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey($"Base"));
- if (responsesch.Status == 200)
- {
- var jsons = await JsonDocument.ParseAsync(responsesch.ContentStream);
- if (jsons.RootElement.TryGetProperty("period", out JsonElement periodJobj))
- {
- foreach (var periodinfo in periodJobj.EnumerateArray())
- {
- dynamic periodExtobj = new ExpandoObject();
- periodExtobj.id = periodinfo.GetProperty("id");
- periodExtobj.name = periodinfo.GetProperty("name");
- periods.Add(periodExtobj);
- if (periodinfo.TryGetProperty("grades", out JsonElement gradesJobj))
- {
- foreach (var gradeinfo in gradesJobj.EnumerateArray())
- {
- dynamic gradeExtobj = new ExpandoObject();
- gradeExtobj.id = gradeinfo.GetProperty("id");
- gradeExtobj.name = gradeinfo.GetProperty("name");
- gradeExtobj.periodId = periodinfo.GetProperty("id");
- grades.Add(gradeExtobj);
- }
- }
- }
- }
- }
- return Ok(new { periods, grades, classes });
- }
- /// <summary>
- /// 取得某學校產品購買紀錄
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [HttpPost("get-school-product")]
- [AuthToken(Roles = "teacher,admin,student")]
- #if !DEBUG
- [Authorize(Roles = "IES")]
- #endif
- public async Task<IActionResult> GetSchoolProductInfo(JsonElement request)
- {
- try
- {
- if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
- var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
- var r8 = _azureRedis.GetRedisClient(8);
- List<SchoolProductSerial> serial = new(); //承接DB資料用:序號
- List<SerialInfoBaseWithdeviceBoundExt> serialResult = new(); //最後要輸出的序號結果
- List<SchoolProductService> serviceProduct = new(); //承接DB資料用:服務
- List<SchoolProductOrder> serviceOrder = new(); //服務各產品購買紀錄
- List<SchoolProductSumDataService> serviceSum = new(); //服務各產品購買紀錄
- List<SchoolProductHard> hard = new(); //承接DB資料用:硬體
- SchoolProductSum productSum = new(); //承接DB資料用:產品目前狀態
- List<SchoolProductSumProdInfo> prodinfo = new(); //產品資訊列表(名稱、八碼)
- List<deviceForCoreService> uuidList = new(); //要向CoreService詢問deviceID及硬體資訊的UUID列表
- long UTCNow = DateTimeOffset.UtcNow.ToUnixTimeSeconds();
- ////取得各產品目前可得數量
- var response = await db.ReadItemStreamAsync(school_code.ToString(), new PartitionKey($"ProductSum"));
- if (response.Status == 200)
- {
- using var json = await JsonDocument.ParseAsync(response.ContentStream);
- productSum = json.ToObject<SchoolProductSum>();
- prodinfo = productSum.prodinfo;
- serviceSum = productSum.service;
- }
- //軟體
- List<string> serialPermitList = getSerialPermitProdcodeList();
- string serialPermitJsonStr = JsonConvert.SerializeObject(serialPermitList);
- string serialQueryText = $"SELECT * FROM c WHERE c.dataType = 'serial' AND ARRAY_CONTAINS({serialPermitJsonStr}, c.prodCode)";
- await foreach (var itemsr in db.GetItemQueryStreamIterator(queryText: serialQueryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
- {
- using var json = await JsonDocument.ParseAsync(itemsr.ContentStream);
- if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- deviceForCoreService uuidForCore;
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- serial.Add(obj.ToObject<SchoolProductSerial>());
- if (obj.TryGetProperty("deviceBound", out JsonElement deviceBoundJobj) && !string.IsNullOrWhiteSpace(deviceBoundJobj.ToString()))
- {
- foreach (var deviceBoundTmpRow in deviceBoundJobj.EnumerateArray())
- {
- uuidForCore = new deviceForCoreService();
- uuidForCore.sn = (!string.IsNullOrWhiteSpace(Convert.ToString(obj.GetProperty("serial")))) ? Convert.ToString(obj.GetProperty("serial")) : null;
- uuidForCore.uuid1 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("uuid")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("uuid")) : null;
- uuidForCore.uuid2 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("uuid2")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("uuid2")) : null;
- //uuidForCore.device_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("deviceId")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("deviceId")) : null;
- uuidForCore.device_id = null; //[2023.6.9]迴避帶deviceId向CS取得device時資訊會重複問題
- uuidForCore.class_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("classId")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("classId")) : null;
- uuidList.Add(uuidForCore);
- }
- }
- }
- }
- }
- ////取得DeviceInfo From Core 並更新序號資料
- List<deviceFromCoreService> coreUuidList = (List<deviceFromCoreService>)GetDeviceFromCoreAsync(uuidList).GetAwaiter().GetResult();
- List<deviceBoundExt> deviceBoundArray;
- List<deviceFromCoreService> coreUuid;
- deviceForCoreService deviceBoundRow;
- deviceBoundExt deviceBoundExt;
- deviceBound serialDeviceBoundRow;
- SerialInfoBaseWithdeviceBoundExt serialResultRow;
- List<SchoolProductSerial> updSchoolProductSerialList = new List<SchoolProductSerial>(); //更新學校產品序號用
- foreach (SchoolProductSerial serialRow in serial)
- {
- deviceBoundArray = new List<deviceBoundExt>();
- coreUuid = coreUuidList
- .Where((deviceFromCoreService x) => x.sn == serialRow.serial)
- .ToList();
- foreach (deviceFromCoreService deviceRow in coreUuid)
- {
- if (!string.IsNullOrWhiteSpace(deviceRow.uuid1) || !string.IsNullOrWhiteSpace(deviceRow.uuid2) || !string.IsNullOrWhiteSpace(deviceRow.device_id)) //uuid1、uuid2、device_id 任一欄有值
- {
- //前端顯示用
- deviceBoundRow = uuidList.Where(u => u.sn == deviceRow.sn && u.uuid1 == deviceRow.uuid1 && u.uuid2 == deviceRow.uuid2).FirstOrDefault();
- deviceBoundExt = new deviceBoundExt();
- deviceBoundExt.uuid = deviceBoundRow.uuid1;
- deviceBoundExt.uuid2 = deviceBoundRow.uuid2;
- deviceBoundExt.classId = deviceBoundRow.class_id;
- deviceBoundExt.deviceId = deviceRow.device_id;
- deviceBoundExt.os = deviceRow.os;
- deviceBoundExt.ip = deviceRow.local_ip;
- deviceBoundExt.cpu = deviceRow.cpu;
- deviceBoundExt.pcname = deviceRow.pc_name;
- deviceBoundExt.osver = deviceRow.os_ver;
- deviceBoundArray.Add(deviceBoundExt);
- //DB更新用序號資料:比對IES5序號硬體列 與 CS拿到的硬體列,若吻合者將IES5序號硬體列的deviceId寫入
- //比對法: [IES5]UUID1==[CS]UUID2 || [IES5]UUID2==[CS]UUID1 ※null與空白算為相同
- serialDeviceBoundRow = serialRow.deviceBound.Where(d =>
- ((d.uuid == deviceBoundRow.uuid1 || (string.IsNullOrEmpty(d.uuid) && string.IsNullOrEmpty(deviceBoundRow.uuid1))) && (d.uuid2 == deviceBoundRow.uuid2 || (string.IsNullOrEmpty(d.uuid2) && string.IsNullOrEmpty(deviceBoundRow.uuid2)))) ||
- ((d.uuid == deviceBoundRow.uuid2 || (string.IsNullOrEmpty(d.uuid) && string.IsNullOrEmpty(deviceBoundRow.uuid2))) && (d.uuid2 == deviceBoundRow.uuid1 || (string.IsNullOrEmpty(d.uuid2) && string.IsNullOrEmpty(deviceBoundRow.uuid1))))
- ).FirstOrDefault();
- if (serialDeviceBoundRow != null)
- {
- serialDeviceBoundRow.deviceId = deviceRow.device_id;
- }
- }
- }
- if (deviceBoundArray.Count.Equals(0)) //無法取得CS的硬體資訊,則用序號的硬體資訊帶入
- {
- if (serialRow.deviceBound != null)
- {
- foreach (deviceBound serialRowDeviceBound in serialRow.deviceBound)
- {
- if (!string.IsNullOrEmpty(serialRowDeviceBound.uuid) || !string.IsNullOrEmpty(serialRowDeviceBound.uuid2))
- {
- deviceBoundExt = new deviceBoundExt();
- deviceBoundExt.uuid = serialRowDeviceBound.uuid;
- deviceBoundExt.uuid2 = serialRowDeviceBound.uuid2;
- deviceBoundExt.classId = serialRowDeviceBound.classId;
- deviceBoundExt.deviceId = serialRowDeviceBound.deviceId;
- deviceBoundArray.Add(deviceBoundExt);
- }
- }
- }
- }
- //序號更新
- updSchoolProductSerialList.Add(serialRow);
- //await db.ReplaceItemAsync<SchoolProductSerial>(serialRow, serialRow.id, new PartitionKey($"Product-{school_code}"));
- //回傳值
- serialResultRow = new SerialInfoBaseWithdeviceBoundExt();
- serialResultRow.code = serialRow.code;
- serialResultRow.id = serialRow.id;
- serialResultRow.dataType = serialRow.dataType;
- serialResultRow.serial = serialRow.serial;
- serialResultRow.prodCode = serialRow.prodCode;
- serialResultRow.clientQty = serialRow.clientQty;
- serialResultRow.orderDate = serialRow.orderDate;
- serialResultRow.regDate = serialRow.regDate;
- serialResultRow.startDate = serialRow.startDate;
- serialResultRow.endDate = serialRow.endDate;
- serialResultRow.deviceMax = serialRow.deviceMax;
- serialResultRow.expireStatus = serialRow.expireStatus;
- serialResultRow.status = serialRow.status;
- serialResultRow.deviceBound = deviceBoundArray;
- if (serialRow.aprule != null)
- {
- string apruleJsonString = serialRow.aprule.ToJsonString();
- var apruleDc = JsonDocument.Parse(apruleJsonString);
- serialResultRow.aprule = (apruleDc.RootElement.TryGetProperty("json", out JsonElement apruleJson)) ? apruleJson : null;
- }
- else serialResultRow.aprule = null;
- serialResult.Add(serialResultRow);
- }
- //服務
- List<SchoolProductSumDataService> service = new List<SchoolProductSumDataService>();
- SchoolProductSum schoolProductSum;
- await foreach (var items in db.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.id = '{school_code}'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProductSum") }))
- {
- using var json = await JsonDocument.ParseAsync(items.ContentStream);
- if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- schoolProductSum = obj.ToObject<SchoolProductSum>();
- service = schoolProductSum.service;
- }
- }
- }
- if (service.Count > 0)
- {
- SchoolProductOrder spOrderRow;
- foreach (SchoolProductSumDataService serviceRow in service)
- {
- spOrderRow = new SchoolProductOrder();
- spOrderRow.prodCode = serviceRow.prodCode;
- spOrderRow.avaliable = serviceRow.avaliable;
- spOrderRow.avaliableStartDate = serviceRow.startDate;
- spOrderRow.avaliableEndDate = serviceRow.endDate;
- serviceOrder.Add(spOrderRow);
- }
- }
- #region 產品購買履歷廢除部分
- ////(服務)取得各產品購買履歷
- //await foreach (var itemsv in clientContainer.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.dataType = 'service'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
- //{
- // using var json = await JsonDocument.ParseAsync(itemsv.ContentStream);
- // if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- // {
- // foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- // {
- // SchoolProductService serviceProductRow = obj.ToObject<SchoolProductService>();
- // serviceProduct.Add(serviceProductRow);
- // }
- // }
- //}
- ////(服務)產品購買履歷整形
- //IEnumerable<SchoolProductService> serviceProductOrder = serviceProduct.OrderBy(sp => sp.startDate);
- //foreach (SchoolProductService serviceProductRow in serviceProduct)
- //{
- // //取得此產品現在可用數
- // SchoolProductSumDataService serviceSumNow = serviceSum.Where(ss => ss.prodCode.Equals(serviceProductRow.prodCode)).FirstOrDefault();
- // int serviceAvaliableNow = (serviceSumNow != null) ? serviceSumNow.avaliable : 0;
- // long serviceAvaliableStartDate = (serviceSumNow != null) ? serviceSumNow.startDate : 0;
- // long serviceAvaliableEndDate = (serviceSumNow != null) ? serviceSumNow.endDate : 0;
- // //取得此產品購買履歷
- // SchoolProductOrder serviceOrderNow = serviceOrder.Where(so => so.prodCode == serviceProductRow.prodCode).FirstOrDefault();
- // if (serviceOrderNow == null) //無此產品項
- // {
- // SchoolProductOrder serviceOrderRow = new SchoolProductOrder();
- // serviceOrderRow.prodCode = serviceProductRow.prodCode;
- // serviceOrderRow.order = new List<SchoolProductOrderList>();
- // SchoolProductOrderList serviceOrderRowOrderList = new SchoolProductOrderList();
- // serviceOrderRowOrderList.id = serviceProductRow.id;
- // serviceOrderRowOrderList.orderDate = serviceProductRow.orderDate;
- // serviceOrderRowOrderList.startDate = serviceProductRow.startDate;
- // serviceOrderRowOrderList.endDate = serviceProductRow.endDate;
- // serviceOrderRowOrderList.number = serviceProductRow.number;
- // serviceOrderRowOrderList.unit = serviceProductRow.unit;
- // serviceOrderRow.order.Add(serviceOrderRowOrderList);
- // serviceOrderRow.avaliable = serviceAvaliableNow;
- // serviceOrderRow.avaliableStartDate = serviceAvaliableStartDate;
- // serviceOrderRow.avaliableEndDate = serviceAvaliableEndDate;
- // serviceOrder.Add(serviceOrderRow);
- // }
- // else //有此產品項 => 看是否有此購買紀錄
- // {
- // //記入可用起始終止日
- // serviceOrderNow.avaliableStartDate = serviceAvaliableStartDate;
- // serviceOrderNow.avaliableEndDate = serviceAvaliableEndDate;
- // //記入購買紀錄
- // SchoolProductOrderList SchoolProductOrderListNow = serviceOrderNow.order.Where(Sol => Sol.id.Equals(serviceProductRow.id)).FirstOrDefault();
- // if (SchoolProductOrderListNow == null) //無此購買紀錄
- // {
- // SchoolProductOrderList serviceOrderRowOrderList = new SchoolProductOrderList();
- // serviceOrderRowOrderList.id = serviceProductRow.id;
- // serviceOrderRowOrderList.orderDate = serviceProductRow.orderDate;
- // serviceOrderRowOrderList.startDate = serviceProductRow.startDate;
- // serviceOrderRowOrderList.endDate = serviceProductRow.endDate;
- // serviceOrderRowOrderList.number = serviceProductRow.number;
- // serviceOrderRowOrderList.unit = serviceProductRow.unit;
- // serviceOrderNow.order.Add(serviceOrderRowOrderList);
- // }
- // }
- //}
- #endregion
- //硬體
- await foreach (var itemhd in db.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.dataType = 'hard'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
- {
- using var json = await JsonDocument.ParseAsync(itemhd.ContentStream);
- if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- hard.Add(obj.ToObject<SchoolProductHard>());
- }
- }
- }
- //空間計算
- ////取得教師分配空間
- long teach = 0;
- var querysp = $"SELECT SUM(c.size) as size FROM c";
- await foreach (var item in db.GetItemQueryStreamIterator(queryText: querysp, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
- {
- var jsonts = await JsonDocument.ParseAsync(item.ContentStream);
- foreach (var obj in jsonts.RootElement.GetProperty("Documents").EnumerateArray())
- {
- teach = obj.GetProperty("size").GetInt64() * 1073741824; //G換算
- }
- }
- ////學校已使用空間
- long blobsize = 0;
- RedisValue value = default;
- value = r8.HashGet($"Blob:Record", $"{school_code}");
- if (value != default && !value.IsNullOrEmpty)
- {
- JsonElement record = value.ToString().ToObject<JsonElement>();
- if (record.TryGetInt64(out blobsize))
- {
- }
- }
- ////各項空間數值取得
- Dictionary<string, double> catalog = new();
- SortedSetEntry[] Scores = _azureRedis.GetRedisClient(8).SortedSetRangeByScoreWithScores($"Blob:Catalog:{school_code}");
- if (Scores != null)
- {
- foreach (var score in Scores)
- {
- double val = score.Score;
- string key = score.Element.ToString();
- catalog.Add(key, val);
- }
- }
- dynamic space = new ExpandoObject();
- space.size = blobsize;
- space.teach = teach;
- space.catalog = catalog;
- //取得購買紀錄
- List<object> order = await GetOrderHisFromCoreBBAsync(school_code.GetString());
- //取得CC授權使用狀態
- var hashs = await r8.HashGetAllAsync($"CC:License:{school_code.GetString()}");
- var ccuser = hashs.Select(x => JsonDocument.Parse(x.Value.ToString())).ToList();
- //更新學校產品序號
- _ = UpdupdSchoolProductSerialListAsync(updSchoolProductSerialList, school_code.GetString());
- return Ok(new { serial = serialResult, service = serviceOrder, hard, space, order, ccuser });
- }
- catch (Exception ex)
- {
- return BadRequest();
- }
- }
- [ProducesDefaultResponseType]
- [HttpPost("get-teach-count")]
- //[AuthToken(Roles = "teacher,admin,student")]
- #if !DEBUG
- [Authorize(Roles = "IES")]
- #endif
- public async Task<IActionResult> GetTeacCount(JsonElement request)
- {
- try
- {
- if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
- var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
- var r8 = _azureRedis.GetRedisClient(8);
- List<SchoolProductSerial> serial = new(); //承接DB資料用:序號
- List<deviceForCoreService> uuidList = new(); //要向CoreService詢問deviceID及硬體資訊的UUID列表
- long UTCNow = DateTimeOffset.UtcNow.ToUnixTimeSeconds();
- //軟體
- List<string> serialPermitList = getSerialPermitProdcodeList();
- string serialPermitJsonStr = JsonConvert.SerializeObject(serialPermitList);
- string serialQueryText = $"SELECT * FROM c WHERE c.dataType = 'serial' AND ARRAY_CONTAINS({serialPermitJsonStr}, c.prodCode)";
- await foreach (var itemsr in db.GetItemQueryStreamIterator(queryText: serialQueryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
- {
- using var json = await JsonDocument.ParseAsync(itemsr.ContentStream);
- if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- deviceForCoreService uuidForCore;
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- serial.Add(obj.ToObject<SchoolProductSerial>());
- if (obj.TryGetProperty("deviceBound", out JsonElement deviceBoundJobj) && !string.IsNullOrWhiteSpace(deviceBoundJobj.ToString()))
- {
- foreach (var deviceBoundTmpRow in deviceBoundJobj.EnumerateArray())
- {
- uuidForCore = new deviceForCoreService
- {
- sn = (!string.IsNullOrWhiteSpace(Convert.ToString(obj.GetProperty("serial")))) ? Convert.ToString(obj.GetProperty("serial")) : null,
- uuid1 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("uuid")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("uuid")) : null,
- uuid2 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("uuid2")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("uuid2")) : null,
- device_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("deviceId")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("deviceId")) : null,
- class_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("classId")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("classId")) : null
- };
- uuidList.Add(uuidForCore);
- }
- }
- }
- }
- }
- ////取得DeviceInfo From Core 並更新序號資料
- List<deviceFromCoreService> coreUuidList = (List<deviceFromCoreService>)GetDeviceFromCoreAsync(uuidList).GetAwaiter().GetResult();
- List<deviceBoundExt> deviceBoundArray;
- List<deviceBoundExt> counts = new();
- List<deviceFromCoreService> coreUuid;
- deviceForCoreService deviceBoundRow;
- deviceBoundExt deviceBoundExt;
- List<SchoolProductSerial> updSchoolProductSerialList = new List<SchoolProductSerial>(); //更新學校產品序號用
- foreach (SchoolProductSerial serialRow in serial)
- {
- deviceBoundArray = new List<deviceBoundExt>();
- coreUuid = coreUuidList
- .Where((deviceFromCoreService x) => x.sn == serialRow.serial)
- .ToList();
- foreach (deviceFromCoreService deviceRow in coreUuid)
- {
- if (!string.IsNullOrWhiteSpace(deviceRow.uuid1) || !string.IsNullOrWhiteSpace(deviceRow.uuid2) || !string.IsNullOrWhiteSpace(deviceRow.device_id)) //uuid1、uuid2、device_id 任一欄有值
- {
- //前端顯示用
- deviceBoundRow = uuidList.Where(u => u.sn == deviceRow.sn && u.uuid1 == deviceRow.uuid1 && u.uuid2 == deviceRow.uuid2).FirstOrDefault();
- deviceBoundExt = new deviceBoundExt
- {
- uuid = deviceBoundRow.uuid1,
- uuid2 = deviceBoundRow.uuid2,
- classId = deviceBoundRow.class_id,
- deviceId = deviceRow.device_id,
- os = deviceRow.os,
- ip = deviceRow.local_ip,
- cpu = deviceRow.cpu,
- pcname = deviceRow.pc_name,
- osver = deviceRow.os_ver
- };
- deviceBoundArray.Add(deviceBoundExt);
- }
- }
- if (deviceBoundArray.Count.Equals(0)) //無法取得CS的硬體資訊,則用序號的硬體資訊帶入
- {
- if (serialRow.deviceBound != null)
- {
- foreach (deviceBound serialRowDeviceBound in serialRow.deviceBound)
- {
- if (!string.IsNullOrEmpty(serialRowDeviceBound.uuid) || !string.IsNullOrEmpty(serialRowDeviceBound.uuid2))
- {
- deviceBoundExt = new deviceBoundExt
- {
- uuid = serialRowDeviceBound.uuid,
- uuid2 = serialRowDeviceBound.uuid2,
- classId = serialRowDeviceBound.classId,
- deviceId = serialRowDeviceBound.deviceId
- };
- deviceBoundArray.Add(deviceBoundExt);
- }
- }
- }
- }
- //序號更新
- //updSchoolProductSerialList.Add(serialRow);
- counts.AddRange(deviceBoundArray);
- //await db.ReplaceItemAsync<SchoolProductSerial>(serialRow, serialRow.id, new PartitionKey($"Product-{school_code}"));
- }
- //取得CC授權使用狀態
- var hashs = await r8.HashGetAllAsync($"CC:License:{school_code.GetString()}");
- var ccuser = hashs.Select(x => JsonDocument.Parse(x.Value.ToString())).ToList();
- //更新學校產品序號
- //_ = UpdupdSchoolProductSerialListAsync(updSchoolProductSerialList, school_code.GetString());
- double Teachs = counts.Count + ccuser.Count;
- return Ok(new { Teachs });
- }
- catch (Exception ex)
- {
- return BadRequest();
- }
- }
- //集體變更學校序號產品 (效能增進對策)
- private async Task UpdupdSchoolProductSerialListAsync(List<SchoolProductSerial> serialList, string schoolCode)
- {
- var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
- foreach (SchoolProductSerial serialRow in serialList)
- {
- await db.ReplaceItemAsync<SchoolProductSerial>(serialRow, serialRow.id, new PartitionKey($"Product-{schoolCode}"));
- }
- }
- /// <summary>
- /// 取得CoreDevice資訊
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- private async Task<List<deviceFromCoreService>> GetDeviceFromCoreAsync(List<deviceForCoreService> uuidList)
- {
- List<deviceFromCoreService> result = new List<deviceFromCoreService>();
- try
- {
- string url = _configuration.GetValue<string>("HaBookAuth:CoreService:deviceinfo");
- string AccessToken = await getCoreAccessToken();
- var client = _httpClient.CreateClient();
- client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
- string uuidListJson = JsonConvert.SerializeObject(uuidList);
- var content = new StringContent(uuidListJson, Encoding.UTF8, "application/json");
- HttpResponseMessage responseMessage = await client.PostAsync(url, content);
- if (responseMessage.StatusCode == HttpStatusCode.OK)
- {
- string responseBody = responseMessage.Content.ReadAsStringAsync().Result;
- result = System.Text.Json.JsonSerializer.Deserialize<List<deviceFromCoreService>>(responseBody.ToString());
- }
- return result;
- }
- catch (Exception ex)
- {
- return result;
- }
- }
- /// <summary>
- /// 取得CoreBB學校訂單履歷資訊
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- private async Task<List<object>> GetOrderHisFromCoreBBAsync(string schoolCode)
- {
- List<object> result = new List<object>();
- try
- {
- string url = _configuration.GetValue<string>("HaBookAuth:CoreBBAPI") + "/ies5/get-school-order";
- string AccessToken = await getCoreAccessToken();
- var client = _httpClient.CreateClient();
- client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
- string paramJson = JsonConvert.SerializeObject(new { school_code = schoolCode });
- var content = new StringContent(paramJson, Encoding.UTF8, "application/json");
- HttpResponseMessage responseMessage = await client.PostAsync(url, content);
- if (responseMessage.StatusCode == HttpStatusCode.OK)
- {
- string responseBody = responseMessage.Content.ReadAsStringAsync().Result;
- result = System.Text.Json.JsonSerializer.Deserialize<List<object>>(responseBody.ToString());
- }
- return result;
- }
- catch (Exception ex)
- {
- return result;
- }
- }
- private async Task<string> getCoreAccessToken()
- {
- string AccessToken = "";
- try
- {
- string Url = _configuration.GetValue<string>("HaBookAuth:CoreAPI") + "/oauth2/token";
- string GrantType = "device";
- string ClientID = _configuration.GetValue<string>("HaBookAuth:CoreService:clientID");
- string Secret = _configuration.GetValue<string>("HaBookAuth:CoreService:clientSecret");
- var content = new { grant_type = GrantType, client_id = ClientID, client_secret = Secret };
- var response = await _httpClient.CreateClient().PostAsJsonAsync($"{Url}", content);
- if (response.IsSuccessStatusCode)
- {
- string responseBody = response.Content.ReadAsStringAsync().Result;
- using (JsonDocument document = JsonDocument.Parse(responseBody.ToString()))
- {
- if (document.RootElement.TryGetProperty("access_token", out JsonElement AccessTokenObj))
- {
- AccessToken = AccessTokenObj.ToString();
- }
- }
- }
- return AccessToken;
- }
- catch (Exception ex)
- {
- return AccessToken;
- }
- }
- /// <summary>
- /// 計算各產品的初始結束時間及可用數
- /// </summary>
- /// <param name="mainPeriodList">active的主周期</param>
- /// <param name="periodList">附屬周期</param>
- /// <param name="serviceProduct">產品資訊</param>
- /// <returns></returns>
- private ServiceProductResult CalServiceProductAuth(List<ServiceMainPeriod> mainPeriodList, List<ServicePeriod> periodList, ServiceProduct serviceProduct)
- {
- periodZone periodZoneResult = new periodZone();
- List<periodZone> periodZone = new List<periodZone>();
- //篩選出產品有的副週期
- List<string> existPeriodIdList = new List<string>();
- if (serviceProduct.auth.Count > 0)
- {
- foreach (ServiceProductAuth serviceProductAuthRow in serviceProduct.auth)
- {
- if (!string.IsNullOrWhiteSpace(serviceProductAuthRow.periodId) && !existPeriodIdList.Contains(serviceProductAuthRow.periodId))
- {
- existPeriodIdList.Add(serviceProductAuthRow.periodId);
- }
- }
- }
- List<ServicePeriod> periodOrder = periodList.Where(p => existPeriodIdList.Contains(p.periodId)).OrderBy(p => Int32.Parse(p.periodId)).ToList();
- //combine period
- if (periodOrder.Count() > 0)
- {
- //篩選出主週期(複數active主週期對策) ※最終篩出唯一一組 篩選原則:(1)由此產品有的副週期ID篩出 (2)若還有複數筆,則期間長者勝出
- List<string> existMainPeriodIdList = new List<string>();
- foreach (ServicePeriod periodRow in periodOrder)
- {
- if (!existMainPeriodIdList.Contains(periodRow.mainPeriodId))
- {
- existMainPeriodIdList.Add(periodRow.mainPeriodId);
- }
- }
- ServiceMainPeriod mainPeriod = mainPeriodList.Where(w => existMainPeriodIdList.Contains(w.mainPeriodId)).OrderByDescending(w => w.endDate - w.startDate).First();
- List<ServicePeriod> periods = periodOrder.Where(p => p.mainPeriodId == mainPeriod.mainPeriodId).ToList();
- //combine period,compare to mainPeriod start, end
- periodZone = combinePeriodZone(periods);
- periodZoneResult.startDate = (periodZone[0].startDate > mainPeriod.startDate) ? periodZone[0].startDate : mainPeriod.startDate;
- periodZoneResult.endDate = (periodZone[0].endDate < mainPeriod.endDate) ? periodZone[0].endDate : mainPeriod.endDate;
- }
- //return
- ServiceProductResult serviceProductResult = new ServiceProductResult();
- if ((serviceProduct.noperiod && periodZoneResult.startDate == 0 && periodZoneResult.endDate == 0) || (!serviceProduct.noperiod && periodZoneResult.startDate > 0 && periodZoneResult.endDate > 0))
- {
- serviceProductResult.prodCode = serviceProduct.prodCode;
- serviceProductResult.noperiod = serviceProduct.noperiod;
- serviceProductResult.serviceType = serviceProduct.serviceType;
- serviceProductResult.startDate = periodZoneResult.startDate;
- serviceProductResult.endDate = periodZoneResult.endDate;
- serviceProductResult.avaliable = serviceProduct.avaliable;
- }
- return serviceProductResult;
- }
- /// <summary>
- /// 軟體序號解綁API
- /// </summary>
- /// <param name="id_token">ID Token</param>
- /// <param name="uuid">硬體識別碼1</param>
- /// <param name="uuid2">硬體識別碼2</param>
- /// <param name="serial">產品資訊</param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [HttpPost("unbind-serial")]
- [Authorize(Roles = "IES")]
- [AuthToken(Roles = "admin,teacher")]
- public async Task<IActionResult> UnbindSerial(JsonElement request)
- {
- try
- {
- //輸入參數
- if (!request.TryGetProperty("serial", out JsonElement serialJson)) return BadRequest();
- var (id, name, _, _) = HttpContext.GetAuthTokenInfo(); //取得IDToken資訊
- request.TryGetProperty("uuid", out JsonElement uuidJson);
- request.TryGetProperty("uuid2", out JsonElement uuid2Json);
- string serial = serialJson.ToString();
- string uuid = uuidJson.ToString();
- string uuid2 = uuid2Json.ToString();
- if (string.IsNullOrEmpty(serial) && (string.IsNullOrEmpty(uuid) || string.IsNullOrEmpty(uuid2)))
- {
- return BadRequest();
- }
- string lang = "en-US";
- var content = new
- {
- lang = lang,
- serial = serial,
- uuid = uuid,
- uuid2 = uuid2,
- olduuid = "",
- pcname = "",
- dp = "IES5",
- user = new
- {
- id = $"{id}",
- name = $"{name}"
- }
- };
- //呼叫BB解綁API
- object result = new { };
- bool unbindFlg = false; //解綁是否成功 true:成功 false:失敗
- string url = _configuration.GetValue<string>("HaBookAuth:CoreBBAPI") + "/bbauthapi/srunbind";
- string AccessToken = await getCoreAccessToken();
- var client = _httpClient.CreateClient();
- client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
- HttpResponseMessage response = await client.PostAsJsonAsync(url, content);
- if (response.StatusCode == HttpStatusCode.OK)
- {
- string responseBody = await response.Content.ReadAsStringAsync();
- //result = System.Text.Json.JsonSerializer.Deserialize<object>(responseBody.ToString());
- var unbindResult = JsonDocument.Parse(responseBody);
- unbindResult.RootElement.TryGetProperty("status", out JsonElement statusJson);
- int status = statusJson.GetInt32();
- unbindResult.RootElement.TryGetProperty("error", out JsonElement errorJson);
- string error = errorJson.GetString();
- if (unbindResult.RootElement.TryGetProperty("prod", out JsonElement prodJson))
- {
- if (!prodJson.ValueKind.Equals(JsonValueKind.Null))
- {
- if (prodJson.TryGetProperty("auth_unbind_req", out JsonElement unbindReqJson))
- {
- if (!unbindReqJson.ValueKind.Equals(JsonValueKind.Undefined) && !unbindReqJson.ValueKind.Equals(JsonValueKind.Null))
- {
- unbindFlg = true;
- }
- }
- }
- }
- result = (unbindFlg) ? new { status = 0, error = "" } : new { status = status, error = error };
- }
- else
- {
- result = new
- {
- status = 1,
- error = $"Unbind serial: {serial} fail."
- };
- }
- return Ok(result);
- }
- catch (Exception ex)
- {
- return BadRequest();
- }
- }
- [ProducesDefaultResponseType]
- [HttpPost("get-auth-hitcc")]
- [Authorize(Roles = "IES")]
- public async Task<IActionResult> GetHiteachCCAuth(JsonElement request)
- {
- if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
- var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
- var r8 = _azureRedis.GetRedisClient(8);
- long now = DateTimeOffset.UtcNow.ToUnixTimeSeconds();
- //取得HiTeachCC的有效授權
- int avaliable = 0;
- int dmax = 0;
- int client = 0;
- await foreach (var item in db.GetItemQueryStreamIterator($"SELECT c.clientQty, c.deviceMax FROM c WHERE c.prodCode='LZLL6ZEI' AND (c.endDate >= {now} OR c.endDate = 0)",
- requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Product-{school_code}") }))
- {
- var json = await JsonDocument.ParseAsync(item.ContentStream);
- if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- dmax = obj.GetProperty("deviceMax").GetInt32();
- client = obj.GetProperty("clientQty").GetInt32();
- }
- }
- }
- //取得CC授權使用狀態
- var hashs = await r8.HashGetAllAsync($"CC:License:{school_code.GetString()}");
- var ccuser = hashs.Select(x => JsonDocument.Parse(x.Value.ToString())).ToList();
- avaliable = dmax - ccuser.Count;
- return Ok(new { dmax = dmax, client = client, avaliable = avaliable, ccuser = ccuser });
- }
- /// <summary>
- /// 計算各產品的購買歷史紀錄 [舊制,不使用]
- /// </summary>
- /// <param name="mainPeriodList">所有的主周期</param>
- /// <param name="periodList">所有附屬周期</param>
- /// <param name="serviceProduct">產品資訊</param>
- /// <returns></returns>
- private List<ServiceProductAuthHistoryStartEnd> CalServiceProductOrderHistory(List<ServiceMainPeriod> mainPeriodList, List<ServicePeriod> periodList, ServiceProduct serviceProduct)
- {
- List<ServiceProductAuthHistoryStartEnd> serviceProductOrderStartEndList = new List<ServiceProductAuthHistoryStartEnd>();
- //GROUP BY orderId
- if (serviceProduct.auth.Count > 0)
- {
- List<ServiceProductAuthHistory> serviceProductOrderList = new List<ServiceProductAuthHistory>();
- foreach (ServiceProductAuth serviceProductAuthRow in serviceProduct.auth)
- {
- ServiceProductAuthHistory existServiceProductAuthHistory = serviceProductOrderList.Where(a => a.orderId == serviceProductAuthRow.orderId).FirstOrDefault();
- if (existServiceProductAuthHistory != null)
- {
- if (!existServiceProductAuthHistory.periodIdList.Contains(serviceProductAuthRow.periodId))
- {
- existServiceProductAuthHistory.periodIdList.Add(serviceProductAuthRow.periodId);
- }
- }
- else
- {
- ServiceProductAuthHistory serviceProductAuthHistoryRow = new ServiceProductAuthHistory();
- serviceProductAuthHistoryRow.orderId = serviceProductAuthRow.orderId;
- int y = Int32.Parse(serviceProductAuthRow.orderId.Substring(0, 4));
- int m = Int32.Parse(serviceProductAuthRow.orderId.Substring(4, 2));
- int d = Int32.Parse(serviceProductAuthRow.orderId.Substring(6, 2));
- serviceProductAuthHistoryRow.orderDate = new DateTimeOffset(y, m, d, 0, 0, 0, TimeSpan.Zero).ToUnixTimeSeconds();
- serviceProductAuthHistoryRow.number = serviceProductAuthRow.number;
- serviceProductAuthHistoryRow.unit = serviceProductAuthRow.unit;
- serviceProductAuthHistoryRow.periodIdList = new List<string>();
- serviceProductAuthHistoryRow.periodIdList.Add(serviceProductAuthRow.periodId);
- serviceProductOrderList.Add(serviceProductAuthHistoryRow);
- }
- }
- foreach (ServiceProductAuthHistory serviceProductOrderRow in serviceProductOrderList)
- {
- ServiceProductAuthHistoryStartEnd ServiceProductAuthHistoryStartEndRow = new ServiceProductAuthHistoryStartEnd();
- //combine period
- List<ServicePeriod> periodOrder = periodList.Where((ServicePeriod x) => serviceProductOrderRow.periodIdList.Contains(x.periodId)).OrderBy(p => Int32.Parse(p.periodId)).ToList();
- List<periodZone> periodZone = combinePeriodZone(periodOrder);
- ServiceProductAuthHistoryStartEndRow.startDate = periodZone[0].startDate;
- ServiceProductAuthHistoryStartEndRow.endDate = periodZone[0].endDate;
- ServiceProductAuthHistoryStartEndRow.orderId = serviceProductOrderRow.orderId;
- ServiceProductAuthHistoryStartEndRow.orderDate = serviceProductOrderRow.orderDate;
- ServiceProductAuthHistoryStartEndRow.number = serviceProductOrderRow.number;
- ServiceProductAuthHistoryStartEndRow.unit = serviceProductOrderRow.unit;
- serviceProductOrderStartEndList.Add(ServiceProductAuthHistoryStartEndRow);
- }
- }
- //return
- return serviceProductOrderStartEndList;
- }
- //子週期合併開始結束時間
- private List<periodZone> combinePeriodZone(List<ServicePeriod> periods)
- {
- List<periodZone> periodZone = new List<periodZone>();
- foreach (ServicePeriod periodRow in periods)
- {
- if (periodZone.Count == 0)
- {
- periodZone periodZoneNew = new periodZone();
- periodZoneNew.startDate = periodRow.startDate;
- periodZoneNew.endDate = periodRow.endDate;
- periodZone.Add(periodZoneNew);
- }
- else
- {
- bool zoneExistFlg = false;
- for (int i = 0; i < periodZone.Count; i++) //考慮到副週期可能斷成數個block,整合後取第一個
- {
- if (periodRow.startDate <= periodZone[i].endDate + 10 && periodZone[i].endDate + 10 < periodRow.endDate)
- {
- periodZone[i].endDate = periodRow.endDate;
- zoneExistFlg = true;
- }
- else if (periodZone[i].startDate <= periodRow.endDate + 10 && periodRow.endDate + 10 < periodZone[i].endDate)
- {
- periodZone[i].startDate = periodRow.startDate;
- zoneExistFlg = true;
- }
- }
- if (!zoneExistFlg)
- {
- periodZone periodZoneNew = new periodZone();
- periodZoneNew.startDate = periodRow.startDate;
- periodZoneNew.endDate = periodRow.endDate;
- periodZone.Add(periodZoneNew);
- }
- }
- }
- return periodZone;
- }
- /*
- /// <summary>
- /// 取得某學校AClassOne授權及使用資料
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- /// 目前產品DB樣式未定,暫時依照舊樣式建構
- [ProducesDefaultResponseType]
- [HttpPost("get-school-aclassone")]
- public async Task<IActionResult> GetSchoolAclassoneInfo(JsonElement request)
- {
- if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
- var clientContainer = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
- var response = await clientContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey("Product"));
- int total = 0; //可分配總數
- int staNum = 0; //固定分配數
- int dyncNum = 0; //動態分配數
- List<string> staIds = new List<string>(); //固定分配學生ID列
- List<string> dyncIds = new List<string>(); //動態分配學生ID列
- if (response.Status == 200)
- {
- var json = await JsonDocument.ParseAsync(response.ContentStream);
- if (json.RootElement.TryGetProperty("service", out JsonElement serviceJobj))
- {
- //取得active主週期
- List<ServiceMainPeriod> activeMainPeriod = new List<ServiceMainPeriod>();
- if (serviceJobj.TryGetProperty("mainperiod", out JsonElement mainperiodJobj) && mainperiodJobj.ValueKind != JsonValueKind.Null)
- {
- foreach (var mainperiodRow in mainperiodJobj.EnumerateArray())
- {
- if (mainperiodRow.GetProperty("active").GetBoolean())
- {
- activeMainPeriod.Add(mainperiodRow.ToObject<ServiceMainPeriod>());
- }
- }
- }
- //取得active主週期的副週期
- List<ServicePeriod> activePeriodOfMain = new List<ServicePeriod>();
- if (serviceJobj.TryGetProperty("period", out JsonElement periodJobj) && mainperiodJobj.ValueKind != JsonValueKind.Null)
- {
- foreach (var periodRow in periodJobj.EnumerateArray())
- {
- foreach (ServiceMainPeriod mainPeriodRow in activeMainPeriod)
- {
- if (periodRow.GetProperty("mainPeriodId").ToString() == mainPeriodRow.mainPeriodId)
- {
- activePeriodOfMain.Add(periodRow.ToObject<ServicePeriod>());
- }
- }
- }
- }
- //取得AClassOne可用數量
- if (serviceJobj.TryGetProperty("product", out JsonElement serviceProductJobj) && serviceProductJobj.ValueKind != JsonValueKind.Null)
- {
- foreach (var serviceProductRow in serviceProductJobj.EnumerateArray())
- {
- //AClassOne買斷、週期
- string prodCode = serviceProductRow.GetProperty("prodCode").GetString();
- if (prodCode .Equals("RYGVCPLY") || prodCode .Equals("AEGMCPLY"))
- {
- ServiceProductResult serviceProductResultRow = CalServiceProductAuth(activeMainPeriod, activePeriodOfMain, serviceProductRow.ToObject<ServiceProduct>());
- total += serviceProductResultRow.avaliable;
- }
- }
- }
- //取得AClassOne固定分配數、動態分配數、固定分配學生ID
- if (json.RootElement.TryGetProperty("aclassone", out JsonElement aclassoneJobj))
- {
- if (aclassoneJobj.ValueKind != JsonValueKind.Null)
- {
- if (aclassoneJobj.TryGetProperty("ids", out JsonElement ids) && ids.ValueKind != JsonValueKind.Null)
- {
- staIds = System.Text.Json.JsonSerializer.Deserialize<List<string>>(ids.ToJsonString());
- staNum = staIds.Count;
- }
- }
- dyncIds = GetSchoolDynamicAclassOneIDList(school_code.GetString());
- dyncNum = dyncIds.Count;
- }
- }
- }
- return Ok(new { total, staNum, dyncNum, staIds, dyncIds });
- }
- */
- /// <summary>
- /// 取得某學校AClassOne動態可使用數
- /// </summary>
- public int GetSchoolDynamicAclassOne(string schoolCode)
- {
- try
- {
- int result = 0;
- string key = schoolCode + ":" + "AclassOne" + ":" + "dynamic";
- var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
- var dyncount = redisClient.StringGet(key);
- if (redisClient.KeyExists(key))
- {
- result = Int32.Parse(redisClient.StringGet(key));
- }
- return result;
- }
- catch (Exception ex)
- {
- return 0;
- }
- }
- /// <summary>
- /// 取得某學校AClassOne動態已取用的ID List
- /// </summary>
- public List<string> GetSchoolDynamicAclassOneIDList(string schoolCode)
- {
- string key = schoolCode + ":" + "AclassOne" + ":" + "dynamicIds";
- var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
- RedisValue[] redisResult = redisClient.SetMembers(key);
- List<string> result = Array.ConvertAll(redisResult, x => (string)x).ToList();
- return result;
- }
- public long GetSchoolDynamicAclassOneIDCount(string schoolCode)
- {
- string key = schoolCode + ":" + "AclassOne" + ":" + "dynamicIds";
- var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
- long result = redisClient.SetLength(key);
- return result;
- }
- /// <summary>
- /// [測試用]放入某學校的AClassOne動態學生ID
- /// </summary>
- [ProducesDefaultResponseType]
- [HttpPost("set-school-aclassone-dync")]
- [AuthToken(Roles = "teacher,admin,student")]
- #if !DEBUG
- [Authorize(Roles = "IES")]
- #endif
- public IActionResult SetSchoolAclassoneDync(JsonElement request)
- {
- if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
- request.TryGetProperty("student_id", out JsonElement student_id);
- var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
- string key1 = school_code + ":" + "AclassOne" + ":" + "dynamicIds";
- RedisValue[] redisIdsOriginal = redisClient.SetMembers(key1);
- var resultIdsOriginal = Array.ConvertAll(redisIdsOriginal, x => (string)x).ToList();
- redisClient.SetAdd(key1, student_id.GetString());
- RedisValue[] redisIds = redisClient.SetMembers(key1);
- var resultIds = Array.ConvertAll(redisIds, x => (string)x).ToList();
- string key2 = school_code + ":" + "AclassOne" + ":" + "dynamic";
- if (resultIds.Count > resultIdsOriginal.Count)
- {
- redisClient.StringDecrement(key2, 1);
- }
- string resultCount = redisClient.StringGet(key2);
- return Ok(new { resultIds, resultCount });
- }
- /// <summary>
- /// 設定某學校AClassOne固定分配授權學生
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [HttpPost("set-school-aclasson-sta")]
- [AuthToken(Roles = "teacher,admin,student")]
- #if !DEBUG
- [Authorize(Roles = "IES")]
- #endif
- public async Task<IActionResult> SetSchoolAclassoneStatic(JsonElement request)
- {
- if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
- if (!request.TryGetProperty("student_ids", out JsonElement student_ids)) return BadRequest();
- try
- {
- List<string> studentIds = System.Text.Json.JsonSerializer.Deserialize<List<string>>(student_ids.ToJsonString()); //新的學生ID列
- /* ERROR CODE定義:
- * 0: 無錯誤
- * 1: AClassOne授權數不足或無AClassOne授權
- */
- int status = 0;
- string err = "";
- var clientContainer = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
- var response = await clientContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey("Product"));
- if (response.Status == 200)
- {
- int total = 0; //(回傳值)可分配總數
- int staNum = 0; //(回傳值)固定分配數
- int dyncNum = 0; //(回傳值)動態分配數
- List<string> staIds = new List<string>(); //(回傳值)固定學生ID列
- List<string> dyncIds = new List<string>(); //(回傳值)動態學生ID列
- using (Stream stream = response.ContentStream)
- {
- using (StreamReader streamReader = new StreamReader(stream))
- {
- string content = streamReader.ReadToEnd();
- SchoolProduct schoolProduct = System.Text.Json.JsonSerializer.Deserialize<SchoolProduct>(content);
- if (schoolProduct.aclassone != null) //有AClassOne產品授權,schoolProduct.aclassone不會為null
- {
- total = schoolProduct.aclassone.total;
- List<string> studentIdsInDB = schoolProduct.aclassone.ids; //舊的學生ID列
- int totalInDB = schoolProduct.aclassone.total;
- //STEP1 驗證所給的ID數是否超過AClassOne總數
- if (studentIds.Count > totalInDB)
- {
- status = 1;
- err = "AclassOne numbers is not enouth.";
- return Ok(new { status, err });
- }
- //STEP2 將學生ID放入 School.Product.aclassone.ids,更新aclassone.used
- staIds = schoolProduct.aclassone.ids = studentIds;
- staNum = schoolProduct.aclassone.used = studentIds.Count;
- ////Update
- await clientContainer.ReplaceItemAsync<SchoolProduct>(schoolProduct, schoolProduct.id, new PartitionKey("Product"));
- //STEP3更新Redis.hbcn:AclassOne:dynamic ※註:只更新動態ID可用數,不更動動態ID列表,所以若可用數為0,當天被動態分配到的學生仍可使用至今日0時才會被清掉
- int dynamicAclassCount = totalInDB - studentIds.Count; //動態可使用數
- dyncNum = (int)GetSchoolDynamicAclassOneIDCount(school_code.GetString()); //動態ID已使用數
- var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
- string keys = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamic";
- int updDynAclassCount = (dynamicAclassCount - dyncNum > 0) ? dynamicAclassCount - dyncNum : 0;
- redisClient.StringSet(keys, updDynAclassCount);
- string keyd = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamicIds";
- RedisValue[] redisIds = redisClient.SetMembers(keyd);
- dyncIds = Array.ConvertAll(redisIds, x => (string)x).ToList();
- return Ok(new { status, err, total, staNum, dyncNum, staIds, dyncIds });
- }
- else
- {
- status = 1;
- err = "AClassOne has no authorization.";
- return Ok(new { status, err });
- }
- }
- }
- }
- else
- {
- return BadRequest();
- }
- }
- catch (Exception ex)
- {
- return BadRequest();
- }
- }
- /// <summary>
- /// 回收某學校AClassOne固定分配、動態分配授權學生
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [HttpPost("recall-school-aclasson")]
- [AuthToken(Roles = "teacher,admin,student")]
- #if !DEBUG
- [Authorize(Roles = "IES")]
- #endif
- public async Task<IActionResult> RecallSchoolAclassone(JsonElement request)
- {
- if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
- string action = "all"; //預設回收:固定及動態均回收 sta:回收固定 dync:回收動態
- if (request.TryGetProperty("mode", out JsonElement mode))
- {
- if (mode.GetString().Equals("sta") || mode.GetString().Equals("dync"))
- {
- action = mode.GetString();
- }
- }
- int status = 0;
- string err = "";
- var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
- string keys = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamic";
- string keyd = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamicIds";
- var clientContainer = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
- var response = await clientContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey("Product"));
- if (response.Status == 200)
- {
- int total = 0; //(回傳值)可分配總數
- int staNum = 0; //(回傳值)固定分配數
- int dyncNum = 0; //(回傳值)動態分配數
- List<string> staIds = new List<string>(); //(回傳值)固定學生ID列
- List<string> dyncIds = new List<string>(); //(回傳值)動態學生ID列
- using (Stream stream = response.ContentStream)
- {
- using (StreamReader streamReader = new StreamReader(stream))
- {
- string content = streamReader.ReadToEnd();
- SchoolProduct schoolProduct = System.Text.Json.JsonSerializer.Deserialize<SchoolProduct>(content);
- if (schoolProduct.aclassone != null) //有AClassOne產品授權,schoolProduct.aclassone不會為null
- {
- total = schoolProduct.aclassone.total;
- staNum = schoolProduct.aclassone.used;
- staIds = schoolProduct.aclassone.ids;
- dyncNum = (int)GetSchoolDynamicAclassOneIDCount(school_code.GetString());
- dyncIds = GetSchoolDynamicAclassOneIDList(school_code.GetString());
- switch (action)
- {
- case "sta":
- staIds = schoolProduct.aclassone.ids = new List<string>();
- staNum = schoolProduct.aclassone.used = 0;
- await clientContainer.ReplaceItemAsync<SchoolProduct>(schoolProduct, schoolProduct.id, new PartitionKey("Product"));
- int updDynAclassCount = (total - dyncNum > 0) ? total - dyncNum : 0;
- redisClient.StringSet(keys, updDynAclassCount);
- break;
- case "dync": //動態回收
- dyncNum = 0;
- dyncIds = new List<string>();
- redisClient.StringSet(keys, total - staNum);
- redisClient.KeyDelete(keyd);
- break;
- case "all": //全回收
- staIds = schoolProduct.aclassone.ids = new List<string>();
- staNum = schoolProduct.aclassone.used = 0;
- await clientContainer.ReplaceItemAsync<SchoolProduct>(schoolProduct, schoolProduct.id, new PartitionKey("Product"));
- dyncNum = 0;
- dyncIds = new List<string>();
- redisClient.StringSet(keys, total);
- redisClient.KeyDelete(keyd);
- break;
- }
- return Ok(new { status, err, total, staNum, dyncNum, staIds, dyncIds });
- }
- else
- {
- status = 1;
- err = "AClassOne has no authorization.";
- return Ok(new { status, err });
- }
- }
- }
- }
- else
- {
- return BadRequest();
- }
- }
- /// <summary>
- /// 教師空間
- /// </summary>
- [ProducesDefaultResponseType]
- [HttpPost("teacher-space")]
- [AuthToken(Roles = "teacher,admin,student")]
- #if !DEBUG
- [Authorize(Roles = "IES")]
- #endif
- public async Task<IActionResult> TeacherSpace(JsonElement request)
- {
- // 必要檢查
- if (!request.TryGetProperty("school_code", out JsonElement code)) return BadRequest();
- if (!request.TryGetProperty("action", out JsonElement type)) return BadRequest();
- long usedSpace = 0;//已被使用的空間量(G)
- School school = null;
- string school_code = code.ToString(); // 學校簡碼
- try
- {
- // [變數宣告]
- string action = type.ToString(); // 功能分類
- string queryText = ""; // 統一sql文記憶體
- // response
- string status = "0";
- string err = "";
- List<string> errTeachers = new List<string>();
- RedisValue value = _azureRedis.GetRedisClient(8).HashGet($"Blob:Record", school_code);
- if (value != default && !value.IsNullOrEmpty)
- {
- JsonElement record = value.ToString().ToObject<JsonElement>();
- if (record.TryGetInt64(out usedSpace))
- {
- }
- usedSpace = Convert.ToInt64(Math.Ceiling(usedSpace / bytes));
- }
- else
- {
- //[學校空間]
- //var blobClient = _azureStorage.GetBlobContainerClient(school_code.ToString());
- //long? docSize = await blobClient.GetBlobsSize("doc");
- //long? videoSize = await blobClient.GetBlobsSize("video");
- //long? imageSize = await blobClient.GetBlobsSize("image");
- //long? paperSize = await blobClient.GetBlobsSize("paper");
- //long? itemSize = await blobClient.GetBlobsSize("item");
- //long? otherSize = await blobClient.GetBlobsSize("other");
- //long? voteSize = await blobClient.GetBlobsSize("vote");
- //long? surveySize = await blobClient.GetBlobsSize("survey");
- //long? audioSize = await blobClient.GetBlobsSize("audio");
- //long? resSize = await blobClient.GetBlobsSize("res");
- //long? tempSize = await blobClient.GetBlobsSize("temp");
- //long? thumSize = await blobClient.GetBlobsSize("thum");
- //long? syllabusSize = await blobClient.GetBlobsSize("syllabus");
- //long? examSize = await blobClient.GetBlobsSize("exam");
- //long? recordsSize = await blobClient.GetBlobsSize("records");
- //long? yxptSize = await blobClient.GetBlobsSize("yxpt");
- //long? trainSize = await blobClient.GetBlobsSize("train");
- //long? homeworkSize = await blobClient.GetBlobsSize("homework");
- //long? avatarSize = await blobClient.GetBlobsSize("avatar");
- //docSize = docSize != null ? docSize : 0;
- //videoSize = videoSize != null ? videoSize : 0;
- //imageSize = imageSize != null ? imageSize : 0;
- //paperSize = paperSize != null ? paperSize : 0;
- //itemSize = itemSize != null ? itemSize : 0;
- //otherSize = otherSize != null ? otherSize : 0;
- //voteSize = voteSize != null ? voteSize : 0;
- //surveySize = surveySize != null ? surveySize : 0;
- //audioSize = audioSize != null ? audioSize : 0;
- //resSize = resSize != null ? resSize : 0;
- //tempSize = tempSize != null ? tempSize : 0;
- //thumSize = thumSize != null ? thumSize : 0;
- //syllabusSize = syllabusSize != null ? syllabusSize : 0;
- //examSize = examSize != null ? examSize : 0;
- //usedSpace = Convert.ToInt64(Math.Ceiling((double)((avatarSize + homeworkSize + trainSize + yxptSize + recordsSize + docSize + videoSize + imageSize + paperSize + itemSize + otherSize + voteSize + audioSize + resSize + tempSize + thumSize + syllabusSize + examSize) / bytes)));
- }
- long avaliable = this.baseSpaceSize; // (G) 目前學校申請空間總數
- long teacherSpace = 0; // 教師可設定的空間量(G)
- school = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>(school_code, new PartitionKey("Base"));
- if (school.size <= 0)
- {
- school.size = baseSpaceSize;
- }
- avaliable = school.size;
- // 取得學校目前的總空間數(G)
- teacherSpace = avaliable - usedSpace;
- List<SchoolTeacher> teachersInschool = new List<SchoolTeacher>();
- switch (action)
- {
- case "baseSpace": // 現在的教師空間
- return Ok(new
- {
- status,
- avaliable = avaliable.ToString(),
- usedSpace = usedSpace.ToString()
- });
- case "upd": // 修改教師空間
- // [二次檢核]
- if (!request.TryGetProperty("teachers", out JsonElement _teachers)) return BadRequest();
- List<Teacher> teachers = _teachers.Deserialize<List<Teacher>>();
- // 教師設定總數
- int setSpaceTotal = 0;
- // 教師List
- var ids = teachers.Select(x => x.id);
- int notInSpaceTotal = 0;
- string notinsql = $"select value(sum(c.size)) from c ";
- if (ids.Any())
- {
- notinsql = $"select value(sum(c.size)) from c where c.id not in ({string.Join(",", ids.Select(o => $"'{o}'"))})";
- }
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<int>(queryText: notinsql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
- {
- notInSpaceTotal = item;
- break;
- }
- setSpaceTotal = notInSpaceTotal + teachers.Select(x => x.size).Sum();
- // 檢核總數是否超過
- if (setSpaceTotal > teacherSpace)
- {
- status = "1"; // 要設定的空間總數大於目前學校有的
- err = $"設定總量({setSpaceTotal}G)超過目前空間({teacherSpace}G)";
- return Ok(new { status, err });
- }
- queryText = $"select * from c where c.id in ({string.Join(",", ids.Select(o => $"'{o}'"))})";
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: queryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
- {
- using var jsoncm = await JsonDocument.ParseAsync(item.ContentStream);
- foreach (var obj in jsoncm.RootElement.GetProperty("Documents").EnumerateArray())
- {
- teachersInschool.Add(obj.ToObject<SchoolTeacher>());
- }
- }
- foreach (var obj in teachers)
- {
- SchoolTeacher teacher = teachersInschool.Where(t => !string.IsNullOrWhiteSpace(t.id) && !string.IsNullOrWhiteSpace(obj.id) && t.id == obj.id).FirstOrDefault<SchoolTeacher>();
- if (teacher != null)
- {
- int orgTeacherSize = teacher.size;
- if (teacher.size != obj.size)
- {
- int bsize = teacher.size;
- int asize = obj.size;
- teacher.size = obj.size;
- List<IdNameCode> nameCodes = new List<IdNameCode> { new IdNameCode { id = obj.id, name = obj.name, code = obj.lang } };
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(teacher, obj.id, new PartitionKey($"Teacher-{school_code}"));
- var schoolData = obj.schools.Find(z => z.schoolId.Equals($"{school_code}"));
- if (schoolData != null)
- {
- _coreAPIHttpService.PushNotify(nameCodes, "teacher_space-change", Constant.NotifyType_IES5_Management,
- new Dictionary<string, object> { { "tmdname", teacher.name }, { "tmdid", teacher.id }, { "schoolName", schoolData.name }, { "bsize", bsize }, { "asize", asize } }
- , _option.Location, _configuration, _dingDing, _environment.ContentRootPath);
- }
- }
- }
- }
- return Ok(new { status, err, errTeachers });
- case "retract": // 收回教師空間
- // [取得DB資料]
- queryText = "select * from c ";
- string record = "0";
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: queryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
- {
- using var jsoncm = await JsonDocument.ParseAsync(item.ContentStream);
- if (jsoncm.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- // 修改的筆數
- record = count.ToString();
- //List<SchoolTeacher> teachersInschool = new List<SchoolTeacher>();
- foreach (var obj in jsoncm.RootElement.GetProperty("Documents").EnumerateArray())
- {
- teachersInschool.Add(obj.ToObject<SchoolTeacher>());
- }
- foreach (SchoolTeacher teacher in teachersInschool)
- {
- // 修改DB裡School的老師size
- int teacherSizeInSchool = teacher.size;
- teacher.size = 0;
- // 修改DB裡Teacher的size
- var response = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemStreamAsync(teacher.id, new PartitionKey("Base"));
- if (response.Status == 200)
- {
- var json = await JsonDocument.ParseAsync(response.ContentStream);
- //軟體
- Teacher teacherHimself = json.ToObject<Teacher>();
- // teacherHimself.size -= teacherSizeInSchool;
- // 最後一起修改
- //huanghb 2021,7.21修改 ,不用再统计到Teacher-Base中 ,Teacher-Base只记录教师自己的空间大小,并包含其他学校赠与的空间,其他学校的赠与空间放在School 表的Teacher-hbcn(SchoolTeacher)中SchoolTeacher
- //,并在教师登陆的时候 一并计算个人空间和总空间大小。其中总空间大小包含(个人空间+多个学校累加的空间大小,并且如果退出或者被移除Teacher-Base 的"schools": [],为空,则已经实现自动回收)
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(teacher, teacher.id, new PartitionKey($"Teacher-{school_code}"));
- //await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacherHimself, teacherHimself.id, new PartitionKey("Base"));
- List<IdNameCode> nameCodes = new List<IdNameCode> { new IdNameCode { id = teacherHimself.id, name = teacherHimself.name, code = teacherHimself.lang } };
- var schoolData = teacherHimself.schools.Find(z => z.schoolId.Equals($"{school_code}"));
- _coreAPIHttpService.PushNotify(nameCodes, "teacher_space-retract", Constant.NotifyType_IES5_Management,
- new Dictionary<string, object> { { "tmdname", teacher.name }, { "tmdid", teacher.id }, { "schoolName", schoolData.name } }
- , _option.Location, _configuration, _dingDing, _environment.ContentRootPath);
- }
- else
- {
- status = "3";
- err = "有老師不存在於 Teacher 的DB";
- }
- }
- }
- }
- return Ok(new { status, record });
- default:
- return BadRequest(); // 不存在的功能BadRequest
- }
- }
- catch (CosmosException ex)
- {
- await _dingDing.SendBotMsg($"OS,{_option.Location},schoool/teacher-space\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
- return BadRequest();
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"OS,{_option.Location},schoool/teacher-space\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
- return BadRequest();
- }
- finally
- {
- if (school != null)
- {
- string sql = "select value sum(c.size ) from c ";
- int teachSize = 0;
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<int>(queryText: sql,
- requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
- {
- teachSize += item;
- }
- school.tsize = teachSize;
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(school, school.id, new PartitionKey("Base"));
- }
- }
- }
- [ProducesDefaultResponseType]
- [HttpPost("teacher-import-manage")]
- [Authorize(Roles = "IES")]
- [AuthToken(Roles = "admin,teacher")]
- public async Task<IActionResult> TeacherImportManage(JsonElement request)
- {
- (string adminId, string adminName, string pic, string schoolId) = HttpContext.GetAuthTokenInfo();
- if (!request.TryGetProperty("opt", out JsonElement _opt)) { return BadRequest(); }
- if (!request.TryGetProperty("schoolId", out JsonElement _schoolId)) { return BadRequest(); }
- long now = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
- TeacherImport teacherImport = null;
- List<SchoolTeacher> idsInSchool = new List<SchoolTeacher>();
- List<CoreUser> coreUsers = new List<CoreUser>();
- switch ($"{_opt}")
- {
- case "upsert":
- if (!request.TryGetProperty("teachers", out JsonElement _teachers) || !_teachers.ValueKind.Equals(JsonValueKind.Array)) { return BadRequest(); }
- List<ImportTeacher> teachers = _teachers.ToObject<List<ImportTeacher>>();
- var tmdids = teachers.Where(x => !string.IsNullOrWhiteSpace(x.tmdid)).Select(z => z.tmdid);
- var phones = teachers.Where(x => !string.IsNullOrWhiteSpace(x.phone)).Select(z => z.phone);
- var emails = teachers.Where(x => !string.IsNullOrWhiteSpace(x.email)).Select(z => z.email);
- List<string> keys = new List<string>();
- if (tmdids.Any())
- {
- keys.AddRange(tmdids);
- }
- if (phones.Any())
- {
- keys.AddRange(phones);
- }
- if (emails.Any())
- {
- keys.AddRange(emails);
- }
- teachers.ForEach(x => { x.status = "import"; x.time = now; x.iname = x.name; x.name = null; });
- if (keys.Any())
- {
- try
- {
- var content = new StringContent(keys.ToJsonString(), Encoding.UTF8, "application/json");
- string json = await _coreAPIHttpService.GetUserInfos(content);
- if (!string.IsNullOrWhiteSpace(json))
- {
- coreUsers = json.ToObject<List<CoreUser>>();
- }
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"{_option.Location},导入名单时,查验key信息错误{ex.Message}\n{ex.StackTrace}\n\n{keys.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
- }
- }
- if (coreUsers.Any())
- {
- string sql = $"select c.id,c.status from c where c.id in ({string.Join(",", coreUsers.Select(x => $"'{x.id}'"))}) ";
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School)
- .GetItemQueryIterator<SchoolTeacher>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{_schoolId}") }))
- {
- idsInSchool.Add(item);
- }
- }
- List<IdNameCode> inviteids = new List<IdNameCode>();
- School schoolBase = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>($"{_schoolId}", new PartitionKey("Base"));
- if (coreUsers.Any())
- {
- foreach (var t in teachers)
- {
- if (!string.IsNullOrWhiteSpace(t.tmdid))
- {
- CoreUser coreUser = coreUsers.Find(x => x.id.Equals(t.tmdid));
- if (coreUser != null)
- {
- t.id = coreUser.id;
- t.name = coreUser.name;
- t.picture = coreUser.picture;
- t.tmdid = coreUser.id;
- if (!string.IsNullOrWhiteSpace(coreUser.mobile))
- {
- t.phone = coreUser.mobile;
- }
- if (!string.IsNullOrWhiteSpace(coreUser.mail))
- {
- t.email = coreUser.mail;
- }
- }
- }
- if (string.IsNullOrWhiteSpace(t.id))
- {
- if (!string.IsNullOrWhiteSpace(t.phone))
- {
- CoreUser coreUser = coreUsers.Find(x => !string.IsNullOrWhiteSpace(x.mobile) && x.mobile.Equals(t.phone));
- if (coreUser != null)
- {
- t.id = coreUser.id;
- t.name = coreUser.name;
- t.picture = coreUser.picture;
- t.tmdid = coreUser.id;
- if (!string.IsNullOrWhiteSpace(coreUser.mobile))
- {
- t.phone = coreUser.mobile;
- }
- if (!string.IsNullOrWhiteSpace(coreUser.mail))
- {
- t.email = coreUser.mail;
- }
- }
- }
- }
- if (string.IsNullOrWhiteSpace(t.id))
- {
- if (!string.IsNullOrWhiteSpace(t.email))
- {
- CoreUser coreUser = coreUsers.Find(x => !string.IsNullOrWhiteSpace(x.mail) && x.mail.Equals(t.email));
- if (coreUser != null)
- {
- t.id = coreUser.id;
- t.name = coreUser.name;
- t.picture = coreUser.picture;
- t.tmdid = coreUser.id;
- if (!string.IsNullOrWhiteSpace(coreUser.mobile))
- {
- t.phone = coreUser.mobile;
- }
- if (!string.IsNullOrWhiteSpace(coreUser.mail))
- {
- t.email = coreUser.mail;
- }
- }
- }
- }
- if (!string.IsNullOrWhiteSpace(t.id))
- {
- SchoolTeacher teacher = idsInSchool.Find(x => x.id.Equals(t.id));
- if (teacher != null)
- {
- t.status = teacher.status;
- }
- else
- {
- t.status = "invite";
- teacher = new SchoolTeacher
- {
- id = t.id,
- name = t.name,
- permissions = new List<string>(),
- picture = t.picture,
- job = null,
- roles = new List<string> { "teacher" },
- status = "invite",
- createTime = now,
- size = 0,
- subjectIds = new List<string>(),
- pk = "Teacher",
- code = $"Teacher-{_schoolId}"
- };
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).CreateItemAsync(teacher, new PartitionKey(teacher.code));
- Azure.Response responseTeacher = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReadItemStreamAsync(t.id, new PartitionKey("Base"));
- if (responseTeacher.Status == 200)
- {
- Teacher teacherBase = JsonDocument.Parse(responseTeacher.Content).RootElement.Deserialize<Teacher>();
- inviteids.Add(new IdNameCode { id = teacherBase.id, name = teacherBase.name, code = teacherBase.lang });
- var school = teacherBase.schools?.Find(x => x.schoolId.Equals($"{_schoolId}"));
- if (teacherBase.schools.IsNotEmpty())
- {
- if (school == null)
- {
- teacherBase.schools.Add(new Teacher.TeacherSchool { schoolId = schoolBase.id, name = schoolBase.name, picture = schoolBase.picture, areaId = schoolBase.areaId, time = now, status = "invite" });
- }
- }
- else
- {
- teacherBase.schools = new List<Teacher.TeacherSchool> { new Teacher.TeacherSchool { schoolId = schoolBase.id, name = schoolBase.name, picture = schoolBase.picture, areaId = schoolBase.areaId, time = now, status = "invite" } };
- }
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReplaceItemAsync(teacherBase, teacherBase.id, new PartitionKey("Base"));
- }
- else
- {
- Teacher teacherBase = new Teacher
- {
- createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds(),
- id = t.id,
- name = t.name,
- picture = t.picture,
- size = 2,
- code = "Base",
- pk = "Base",
- schools = new List<Teacher.TeacherSchool> {
- new Teacher.TeacherSchool {
- schoolId= schoolBase.id,
- name= schoolBase.name,picture= schoolBase.picture, areaId= schoolBase.areaId,time=now,status= "invite" },
- }
- };
- inviteids.Add(new IdNameCode { id = teacherBase.id, name = teacherBase.name, code = teacherBase.lang });
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).CreateItemAsync(teacherBase, new PartitionKey("Base"));
- }
- }
- }
- }
- }
- Azure.Response response = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemStreamAsync($"{_schoolId}", new PartitionKey("TeacherImport"));
- if (response.Status == 200)
- {
- teacherImport = JsonDocument.Parse(response.Content).RootElement.Deserialize<TeacherImport>();
- if (teacherImport != null && teacherImport.teachers.Any())
- {
- teachers.ForEach(x =>
- {
- ImportTeacher tch = null;
- if (string.IsNullOrWhiteSpace(x.id))
- {
- tch = teacherImport.teachers.Find(t => !string.IsNullOrWhiteSpace(t.iname) && t.iname.Equals(x.iname));
- }
- else
- {
- tch = teacherImport.teachers.Find(t => !string.IsNullOrWhiteSpace(x.id) && !string.IsNullOrWhiteSpace(t.id) && t.id.Equals(x.id));
- }
- if (tch != null)
- {
- tch.time = now;
- tch.status = x.status;
- tch.name = x.name;
- tch.iname = x.iname;
- tch.picture = x.picture;
- tch.phone = x.phone;
- tch.tmdid = x.tmdid;
- tch.email = x.email;
- tch.note = x.note;
- tch.id = x.id;
- }
- else
- {
- teacherImport.teachers.Add(new ImportTeacher
- {
- time = now,
- status = x.status,
- name = x.name,
- iname = x.iname,
- picture = x.picture,
- phone = x.phone,
- tmdid = x.tmdid,
- email = x.email,
- note = x.note,
- id = x.id
- });
- }
- });
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(teacherImport, $"{_schoolId}", new PartitionKey("TeacherImport"));
- }
- else
- {
- teacherImport = new TeacherImport { id = $"{_schoolId}", code = "TeacherImport", pk = "TeacherImport", teachers = teachers };
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(teacherImport, $"{_schoolId}", new PartitionKey("TeacherImport"));
- }
- }
- else
- {
- teacherImport = new TeacherImport { id = $"{_schoolId}", code = "TeacherImport", pk = "TeacherImport", teachers = teachers };
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).CreateItemAsync(teacherImport, new PartitionKey("TeacherImport"));
- }
- if (inviteids.Any())
- {
- string bizcode = "invite";
- _coreAPIHttpService.PushNotify(inviteids, $"{bizcode}_school", Constant.NotifyType_IES5_Management,
- new Dictionary<string, object> { { "tmdname", adminName }, { "schoolName", schoolBase.name }, { "schoolId", $"{_schoolId}" }, { "tmdid", adminId } }, _option.Location, _configuration, _dingDing, _environment.ContentRootPath);
- }
- break;
- }
- return Ok(new { teacherImport });
- }
- //取得學校IOT資料
- [ProducesDefaultResponseType]
- [HttpPost("get-school-iot")]
- [Authorize(Roles = "IES")]
- [AuthToken(Roles = "admin,teacher")]
- public async Task<IActionResult> getSchoolIotData(JsonElement request)
- {
- try
- {
- if (!request.TryGetProperty("schoolId", out JsonElement _schoolId)) return BadRequest();
- string periodId = (request.TryGetProperty("periodId", out JsonElement _periodId)) ? _periodId.ToString() : string.Empty;
- var sdate = (request.TryGetProperty("sdate", out JsonElement _sdate)) ? TimeHelper.GetDateTime(_sdate.GetString(), "yyyy-MM-dd") : (0, 0, 0, 0, 0);
- var edate = (request.TryGetProperty("edate", out JsonElement _edate)) ? TimeHelper.GetDateTime(_edate.GetString(), "yyyy-MM-dd") : (0, 0, 0, 0, 0);
- //取得學校基本資訊
- School schoolBase = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>($"{_schoolId}", new PartitionKey("Base"));
- if (string.IsNullOrWhiteSpace(schoolBase.id)) return BadRequest();
- string schName = schoolBase.name;
- string schRegion = schoolBase.region;
- string schProvince = schoolBase.province;
- string schCity = schoolBase.city;
- string schDist = schoolBase.dist;
- string schAreaId = schoolBase.areaId;
- string schType = schoolBase.code;
- var period = (!string.IsNullOrWhiteSpace(periodId)) ? schoolBase.period.Find(x => x.id.Equals($"{periodId}")) : schoolBase.period[0];
- if (period == null) period = schoolBase.period[0];
- (Semester currSemester, int studyYear, DateTimeOffset curr, DateTimeOffset date, DateTimeOffset nextSemester) info = SchoolService.GetSemester(period);
- string semesterId = info.currSemester.id;
- var datetime = DateTimeOffset.UtcNow;
- int studyYear = info.studyYear;
- int dateFromYear = (!sdate.Item1.Equals(0)) ? sdate.Item1 : studyYear;
- int dateFromMonth = (!sdate.Item2.Equals(0)) ? sdate.Item2 : info.currSemester.month;
- int dateFromDay = (!sdate.Item3.Equals(0)) ? sdate.Item3 : info.currSemester.day;
- int dateToYear = (!edate.Item1.Equals(0)) ? edate.Item1 : datetime.Year;
- int dateToMonth = (!edate.Item2.Equals(0)) ? edate.Item2 : datetime.Month;
- int dateToDay = (!edate.Item3.Equals(0)) ? edate.Item3 : datetime.Day;
- //教室數
- int classCnt = 0;
- string sql = $"SELECT VALUE COUNT(c.id) FROM c";
- await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Class-{_schoolId}") }))
- {
- classCnt = items;
- }
- //總教師數
- int teacherCnt = 0;
- sql = $"SELECT VALUE COUNT(c.id) FROM c";
- await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{_schoolId}") }))
- {
- teacherCnt = items;
- }
- //學生數 用學段篩選 未畢業
- int studentCnt = 0;
- string sql_studentCnt = $"SELECT count(1) as stus FROM c where c.periodId = '{periodId}' and (c.graduate = 0 OR IS_DEFINED(c.graduate) = false) ";
- await foreach (var items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Student").GetItemQueryStreamIterator(queryText: sql_studentCnt, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Base-{_schoolId}") }))
- {
- using var json = await JsonDocument.ParseAsync(items.ContentStream);
- if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- if (obj.TryGetProperty("stus", out JsonElement stus))
- {
- studentCnt = stus.GetInt32();
- }
- }
- }
- }
- //HiTeach硬體授權數
- int deviceAuthCnt = 0;
- //List<string> serialPermitList = getSerialPermitProdcodeList();
- List<string> serialPermitList = new List<string>() { "J223IZ6M", "3222C6D2", "J223IZAM", "J2236ZCX", "3222DNG2", "3222IAVN", "BYJ6LZ6Z" };
- string serialPermitJsonStr = JsonConvert.SerializeObject(serialPermitList);
- string serialQueryText = $"SELECT VALUE SUM(c.deviceMax) FROM c WHERE c.dataType = 'serial' AND ARRAY_CONTAINS({serialPermitJsonStr}, c.prodCode) AND c.expireStatus = 'A'";
- await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: serialQueryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{_schoolId}") }))
- {
- deviceAuthCnt = items;
- }
- //取得產品分析資訊
- List<string> tmidList = new List<string>(); ///TMID列表
- int stuShow = 0; ///學生人次
- long stuLessonLengMin = 0; ///學生參與總時間數(分)
- int lessonRecord = 0; ///課堂數
- long lessonLengMin = 0; ///課堂時間數(分)
- int mission = 0; ///課中統計-任務數
- int missionFin = 0; ///課中統計-作品數
- int item = 0; ///課中統計-題目數
- int interact = 0; ///課中統計-互動次數
- int lTypeCoop = 0; ///學習型態: 合作
- int lTypeIact = 0; ///學習型態: 互動
- int lTypeMis = 0; ///學習型態: 任務
- int lTypeTst = 0; ///學習型態: 測驗
- int lTypeDif = 0; ///學習型態: 差異化
- List<string> deviceList = new List<string>(); ///設備統計(教室數統計)
- List<string> htcDevList = new List<string>(); ///設備統計-HiTeach Device list
- List<string> htaDevList = new List<string>(); ///設備統計-HiTA Device list
- List<string> htccDevList = new List<string>(); ///設備統計-HiTeachCC Device list
- DateTimeOffset dateTimeFrom = new DateTimeOffset(dateFromYear, dateFromMonth, dateFromDay, 0, 0, 0, TimeSpan.Zero);
- DateTimeOffset dateTimeTo = new DateTimeOffset(dateToYear, dateToMonth, dateToDay, 23, 59, 59, TimeSpan.Zero);
- long dateTimeFromSec = dateTimeFrom.ToUnixTimeSeconds();
- long dateTimeToSec = dateTimeTo.ToUnixTimeSeconds();
- List<ProdAnalysisApiResult> iotData = new List<ProdAnalysisApiResult>();
- sql = $"SELECT * FROM c WHERE c.schoolId = '{_schoolId}' AND c.dateUnit = 'day' AND c.dateTime >= {dateTimeFromSec} AND c.dateTime <= {dateTimeToSec}";
- await foreach (var items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryStreamIterator(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
- {
- var json = await JsonDocument.ParseAsync(items.ContentStream);
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- ProdAnalysisApiResult data = obj.ToObject<ProdAnalysisApiResult>();
- data.school.name = schName;
- data.school.region = schRegion;
- data.school.province = schProvince;
- data.school.city = schCity;
- data.school.dist = schDist;
- data.school.areaId = schAreaId;
- data.school.type = schType;
- iotData.Add(data);
- tmidList = tmidList.Union(data.tmidList).ToList();
- stuShow += data.stuShow;
- stuLessonLengMin += data.stuLessonLengMin;
- lessonRecord += data.lessonRecord;
- lessonLengMin += data.lessonLengMin;
- mission += data.mission;
- missionFin += data.missionFin;
- item += data.item;
- interact += data.interact;
- deviceList = deviceList.Union(data.deviceList).ToList();
- if (data.toolType.Equals("HiTeach")) htcDevList = htcDevList.Union(data.deviceList).ToList();
- if (data.toolType.Equals("HiTA")) htaDevList = htaDevList.Union(data.deviceList).ToList();
- if (data.toolType.Equals("HiTeachCC")) htccDevList = htccDevList.Union(data.deviceList).ToList();
- lTypeCoop += data.lTypeCoop;
- lTypeIact += data.lTypeIact;
- lTypeMis += data.lTypeMis;
- lTypeTst += data.lTypeTst;
- lTypeDif += data.lTypeDif;
- }
- }
- int teacherShow = tmidList.Count; ///老師使用人次
- int htcDevCnt = htcDevList.Count; ///設備統計-HiTeach上線數
- int htcDevTotalCnt = 0; ///設備統計-HiTeach總設備數
- sql = $"SELECT VALUE COUNT(1) FROM (SELECT DISTINCT x FROM c JOIN x IN c.deviceList WHERE c.schoolId = '{_schoolId}' AND c.dateUnit = 'day' AND c.toolType = 'HiTeach')";
- await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
- {
- htcDevTotalCnt = items;
- }
- int htaDevCnt = htaDevList.Count; ///設備統計-HiTA上線數
- int htaDevTotalCnt = 0; ///設備統計-HiTA總設備數
- sql = $"SELECT VALUE COUNT(1) FROM (SELECT DISTINCT x FROM c JOIN x IN c.deviceList WHERE c.schoolId = '{_schoolId}' AND c.dateUnit = 'day' AND c.toolType = 'HiTA')";
- await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
- {
- htaDevTotalCnt = items;
- }
- int htccDevCnt = htccDevList.Count; ///設備統計-HiTeachCC上線數
- return Ok(new { sdate = $"{dateFromYear}-{dateFromMonth}-{dateFromDay}", edate = $"{dateToYear}-{dateToMonth}-{dateToDay}", classCnt, teacherCnt, teacherShow, tmidList, studentCnt, deviceAuthCnt, stuShow, stuLessonLengMin, lessonRecord, lessonLengMin, mission, missionFin, item, interact, deviceList, htcDevCnt, htcDevTotalCnt, htaDevCnt, htaDevTotalCnt, htccDevCnt, lTypeCoop, lTypeIact, lTypeMis, lTypeTst, lTypeDif, iotData });
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"OS,{_option.Location},school/init/get-school-iot\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
- return BadRequest();
- }
- }
- [ProducesDefaultResponseType]
- [HttpPost("get-area-iot")]
- [Authorize(Roles = "IES")]
- [AuthToken(Roles = "admin,teacher")]
- public async Task<IActionResult> getAreaIotData(JsonElement request)
- {
- try
- {
- //回傳值定義
- IotStatisticsArea areaIot = new IotStatisticsArea(); //學區IOT統計結果
- List<IotStatisticsSch> schoolIotResult = new List<IotStatisticsSch>(); //學校IOT統計結果
- List<ProdAnalysisApiResult> iotData = new List<ProdAnalysisApiResult>(); //IOT資料
- string err = string.Empty;
- //取得ID
- var (tmid, name, _, _school) = HttpContext.GetAuthTokenInfo();
- if(string.IsNullOrWhiteSpace(tmid)) return BadRequest();
- Teacher tmidInfo = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReadItemAsync<Teacher>(tmid, new PartitionKey("Base"));
- //區管理者權限驗證 (有給areaId則驗)
- string areaId = (request.TryGetProperty("areaId", out JsonElement _areaId)) ? _areaId.GetString() : string.Empty;
- if(!string.IsNullOrWhiteSpace(areaId))
- {
- TeacherArea hasAreaAdmin = tmidInfo.areas.Where(a => a.areaId.Equals(areaId)).FirstOrDefault();
- if(hasAreaAdmin == null || !hasAreaAdmin.status.Equals("join"))
- {
- err = "Permission denied.";
- return Ok(new { err, area = areaIot, school = schoolIotResult, iotData });
- }
- }
- //學校資料取得
- if (!request.TryGetProperty("schoolIds", out JsonElement _schoolIds)) return BadRequest();
- List<string> schoolIds = _schoolIds.ToObject<List<string>>();
- List<string> periodIds = (request.TryGetProperty("periodIds", out JsonElement _periodIds)) ? _periodIds.ToObject<List<string>>() : new List<string>();
- Dictionary<string, string> schPeriodDic = new Dictionary<string, string>(); //學校ID => 學段ID 字典製作
- if (schoolIds.Count > 0 && periodIds.Count > 0)
- {
- for (var i = 0; i < schoolIds.Count; i++)
- {
- if (periodIds.Count > i && periodIds[i] != null)
- {
- schPeriodDic.Add(schoolIds[i], periodIds[i]);
- }
- }
- }
- var sdate = (request.TryGetProperty("sdate", out JsonElement _sdate)) ? TimeHelper.GetDateTime(_sdate.GetString(), "yyyy-MM-dd") : (0, 0, 0, 0, 0);
- var edate = (request.TryGetProperty("edate", out JsonElement _edate)) ? TimeHelper.GetDateTime(_edate.GetString(), "yyyy-MM-dd") : (0, 0, 0, 0, 0);
- //取得學校基本資訊
- string schoolIdsJsonStr = JsonConvert.SerializeObject(schoolIds);
- string sql = $"SELECT * FROM c WHERE ARRAY_CONTAINS({schoolIdsJsonStr}, c.id)";
- List<School> schools = new List<School>();
- await foreach (var items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryStreamIterator(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Base") }))
- {
- using var json = await JsonDocument.ParseAsync(items.ContentStream);
- if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- schools.Add(obj.ToObject<School>());
- }
- }
- }
- if (schools.Count.Equals(0))
- {
- return Ok(new { err, area = areaIot, school = schoolIotResult, iotData });
- }
- //取得各校IOT相關統計值
- Dictionary<string, IotStatisticsSch> schIot = new Dictionary<string, IotStatisticsSch>(); //各校IOT統計項
- List<string> serialPermitList = new List<string>() { "J223IZ6M", "3222C6D2", "J223IZAM", "J2236ZCX", "3222DNG2", "3222IAVN", "BYJ6LZ6Z" };
- string serialPermitJsonStr = JsonConvert.SerializeObject(serialPermitList);
- foreach (School school in schools)
- {
- string schName = school.name;
- string schRegion = school.region;
- string schProvince = school.province;
- string schCity = school.city;
- string schDist = school.dist;
- string schAreaId = school.areaId;
- string schType = school.code;
- Period period = (schPeriodDic.ContainsKey(school.id)) ? school.period.Find(x => x.id.Equals($"{schPeriodDic[school.id]}")) : school.period[0];
- if (period == null) period = school.period[0];
- (Semester currSemester, int studyYear, DateTimeOffset curr, DateTimeOffset date, DateTimeOffset nextSemester) info = SchoolService.GetSemester(period);
- string semesterId = info.currSemester.id;
- var datetime = DateTimeOffset.UtcNow;
- int studyYear = info.studyYear;
- int dateFromYear = (!sdate.Item1.Equals(0)) ? sdate.Item1 : studyYear;
- int dateFromMonth = (!sdate.Item2.Equals(0)) ? sdate.Item2 : info.currSemester.month;
- int dateFromDay = (!sdate.Item3.Equals(0)) ? sdate.Item3 : info.currSemester.day;
- int dateToYear = (!edate.Item1.Equals(0)) ? edate.Item1 : datetime.Year;
- int dateToMonth = (!edate.Item2.Equals(0)) ? edate.Item2 : datetime.Month;
- int dateToDay = (!edate.Item3.Equals(0)) ? edate.Item3 : datetime.Day;
- DateTimeOffset dateTimeFrom = new DateTimeOffset(dateFromYear, dateFromMonth, dateFromDay, 0, 0, 0, TimeSpan.Zero);
- DateTimeOffset dateTimeTo = new DateTimeOffset(dateToYear, dateToMonth, dateToDay, 23, 59, 59, TimeSpan.Zero);
- long dateTimeFromSec = dateTimeFrom.ToUnixTimeSeconds();
- long dateTimeToSec = dateTimeTo.ToUnixTimeSeconds();
- //學校IOT 初始化
- if (!schIot.ContainsKey(school.id))
- {
- schIot.Add(school.id, new IotStatisticsSch());
- schIot[school.id].schId = school.id;
- schIot[school.id].schName = schName;
- schIot[school.id].sdate = $"{dateFromYear}-{dateFromMonth}-{dateFromDay}";
- schIot[school.id].edate = $"{dateToYear}-{dateToMonth}-{dateToDay}";
- }
- //教室數(今年)
- sql = $"SELECT VALUE COUNT(c.id) FROM c WHERE c.year = {studyYear}";
- await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Class-{school.id}") }))
- {
- areaIot.classCnt += items;
- schIot[school.id].classCnt = items;
- }
- //總教師數
- sql = $"SELECT VALUE COUNT(c.id) FROM c";
- await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{school.id}") }))
- {
- areaIot.teacherCnt += items;
- schIot[school.id].teacherCnt = items;
- }
- //學生數(今年)
- // 加上篩選學段的邏輯 去除之前的廢資料
- StringBuilder sb = new();
- sb.Append("(");
- for (int i = 0; i < school.period.Count; i++)
- {
- sb.Append("'");
- sb.Append(school.period[i].id);
- sb.Append("'");
- if (i != school.period.Count - 1) { sb.Append(", "); }
- }
- sb.Append(")");
- string sql_studentCnt = $"SELECT count(1) as stus FROM c where c.periodId in {sb.ToString()} and (c.graduate = 0 OR IS_DEFINED(c.graduate) = false) ";
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Student").GetItemQueryStreamIterator(queryText: sql_studentCnt, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Base-{school.id}") }))
- {
- using var json = await JsonDocument.ParseAsync(item.ContentStream);
- if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- if (obj.TryGetProperty("stus", out JsonElement stus))
- {
- areaIot.studentCnt += stus.GetInt32();
- schIot[school.id].studentCnt = stus.GetInt32();
- }
- }
- }
- }
- //HiTeach硬體授權數
- sql = $"SELECT VALUE SUM(c.deviceMax) FROM c WHERE c.dataType = 'serial' AND ARRAY_CONTAINS({serialPermitJsonStr}, c.prodCode) AND c.expireStatus = 'A'";
- await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school.id}") }))
- {
- areaIot.deviceAuthCnt += items;
- schIot[school.id].deviceAuthCnt = items;
- }
- //IOT
- sql = $"SELECT * FROM c WHERE c.schoolId = '{school.id}' AND c.dateUnit = 'day' AND c.dateTime >= {dateTimeFromSec} AND c.dateTime <= {dateTimeToSec}";
- await foreach (var items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryStreamIterator(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
- {
- var json = await JsonDocument.ParseAsync(items.ContentStream);
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- ProdAnalysisApiResult data = obj.ToObject<ProdAnalysisApiResult>();
- data.school.name = schName;
- data.school.region = schRegion;
- data.school.province = schProvince;
- data.school.city = schCity;
- data.school.dist = schDist;
- data.school.areaId = schAreaId;
- data.school.type = schType;
- iotData.Add(data);
- //學校IOT統計
- schIot[school.id].tmidList = schIot[school.id].tmidList.Union(data.tmidList).ToList();
- schIot[school.id].stuShow += data.stuShow;
- schIot[school.id].stuLessonLengMin += data.stuLessonLengMin;
- schIot[school.id].lessonRecord += data.lessonRecord;
- schIot[school.id].lessonLengMin += data.lessonLengMin;
- schIot[school.id].mission += data.mission;
- schIot[school.id].missionFin += data.missionFin;
- schIot[school.id].item += data.item;
- schIot[school.id].interact += data.interact;
- if (data.toolType.Equals("HiTeach")) schIot[school.id].htcDevList = schIot[school.id].htcDevList.Union(data.deviceList).ToList();
- if (data.toolType.Equals("HiTA")) schIot[school.id].htaDevList = schIot[school.id].htaDevList.Union(data.deviceList).ToList();
- if (data.toolType.Equals("HiTeachCC")) schIot[school.id].htccDevList = schIot[school.id].htccDevList.Union(data.deviceList).ToList();
- schIot[school.id].lTypeCoop += data.lTypeCoop;
- schIot[school.id].lTypeIact += data.lTypeIact;
- schIot[school.id].lTypeMis += data.lTypeMis;
- schIot[school.id].lTypeTst += data.lTypeTst;
- schIot[school.id].lTypeDif += data.lTypeDif;
- }
- }
- ///設備統計-HiTeach總設備數
- sql = $"SELECT VALUE COUNT(1) FROM (SELECT DISTINCT x FROM c JOIN x IN c.deviceList WHERE c.schoolId = '{school.id}' AND c.dateUnit = 'day' AND c.toolType = 'HiTeach')";
- await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
- {
- schIot[school.id].htcDevTotalCnt = items;
- }
- ///設備統計-HiTA總設備數
- sql = $"SELECT VALUE COUNT(1) FROM (SELECT DISTINCT x FROM c JOIN x IN c.deviceList WHERE c.schoolId = '{school.id}' AND c.dateUnit = 'day' AND c.toolType = 'HiTA')";
- await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
- {
- schIot[school.id].htaDevTotalCnt = items;
- }
- schIot[school.id].tmidCnt = schIot[school.id].tmidList.Count; ///老師使用人次
- schIot[school.id].htcDevCnt = schIot[school.id].htcDevList.Count; ///設備統計-HiTeach上線數
- schIot[school.id].htaDevCnt = schIot[school.id].htaDevList.Count; ///設備統計-HiTA上線數
- schIot[school.id].htccDevCnt = schIot[school.id].htccDevList.Count; ///設備統計-HiTeachCC上線數
- }
- //輸出整形
-
- foreach (KeyValuePair<string, IotStatisticsSch> schIotItem in schIot)
- {
- IotStatisticsSch schIotData = schIotItem.Value;
- //學校
- schoolIotResult.Add(schIotData);
- //學區
- areaIot.sdate = (string.IsNullOrWhiteSpace(areaIot.sdate)) ? schIotData.sdate : (DateTime.Parse(schIotData.sdate, CultureInfo.InvariantCulture) < DateTime.Parse(areaIot.sdate, CultureInfo.InvariantCulture)) ? schIotData.sdate : areaIot.sdate;
- areaIot.edate = (string.IsNullOrWhiteSpace(areaIot.edate)) ? schIotData.edate : (DateTime.Parse(schIotData.edate, CultureInfo.InvariantCulture) > DateTime.Parse(areaIot.edate, CultureInfo.InvariantCulture)) ? schIotData.edate : areaIot.edate;
- areaIot.tmidList = areaIot.tmidList.Union(schIotData.tmidList).ToList();
- areaIot.tmidCnt = areaIot.tmidList.Count;
- areaIot.stuShow += schIotData.stuShow;
- areaIot.stuLessonLengMin += schIotData.stuLessonLengMin;
- areaIot.lessonRecord += schIotData.lessonRecord;
- areaIot.lessonLengMin += schIotData.lessonLengMin;
- areaIot.mission += schIotData.mission;
- areaIot.missionFin += schIotData.missionFin;
- areaIot.item += schIotData.item;
- areaIot.interact += schIotData.interact;
- areaIot.htcDevList = areaIot.htcDevList.Union(schIotData.htcDevList).ToList();
- areaIot.htcDevCnt = areaIot.htcDevList.Count;
- areaIot.htaDevList = areaIot.htaDevList.Union(schIotData.htaDevList).ToList();
- areaIot.htaDevCnt = areaIot.htaDevList.Count;
- areaIot.htccDevList = areaIot.htccDevList.Union(schIotData.htccDevList).ToList();
- areaIot.htccDevCnt = areaIot.htccDevList.Count;
- areaIot.lTypeCoop += schIotData.lTypeCoop;
- areaIot.lTypeIact += schIotData.lTypeIact;
- areaIot.lTypeMis += schIotData.lTypeMis;
- areaIot.lTypeTst += schIotData.lTypeTst;
- areaIot.lTypeDif += schIotData.lTypeDif;
- }
- return Ok(new { err, area = areaIot, school = schoolIotResult, iotData });
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"OS,{_option.Location},school/init/get-school-iot\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
- return BadRequest();
- }
- }
- //新学年8.1号开学 ,第二学期开学2.17,设置提示区间60天
- //2023-8-7 type = "studyYearStarted";新学年已经开始
- //2023-10-7 type = "";不提示
- //2024-1-20 type = "semesterEnding";本学期即将结束
- //2024-3-20 type = "semesterStarted";新学期已经开始
- //2024-4-20 type = "";不提示
- //2024-7-20 type = "studyYearEnding";本学年即将结束
- /// <
- /// summary>
- /// 检查当前学期的开学时间和学期结束时间
- /// </summary>
- /// <param name="json"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [HttpPost("check-semesters")]
- #if !DEBUG
- [AuthToken(Roles = "teacher,admin")]
- [Authorize(Roles = "IES")]
- #endif
- public async Task<IActionResult> CheckSemesters(JsonElement json)
- {
- if (!json.TryGetProperty("schoolId", out JsonElement _schoolId)) { return BadRequest(); }
- if (!json.TryGetProperty("periodId", out JsonElement _periodId)) { return BadRequest(); }
- School school = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>(_schoolId.GetString(), new PartitionKey("Base"));
- var period = school.period.Find(z => z.id.Equals(_periodId.GetString()));
- if (period != null)
- {
- var semesterInfo = SchoolService.GetSemester(period, DateTimeOffset.Now.ToUnixTimeMilliseconds());
- // var semesterInfo = SchoolService.GetSemester(period, time:$"{_time}");
- var start = period.semesters.Where(z => z.start == 1).FirstOrDefault();
- if (start != null)
- {
- var alreadySemester = semesterInfo.date.Subtract(semesterInfo.currSemesterDate);
- var soonSemester = semesterInfo.nextSemester.Subtract(semesterInfo.date);
- var semesterStarted = Math.Abs((int)alreadySemester.TotalDays);
- var semesterEnding = Math.Abs((int)soonSemester.TotalDays);
- string currStudyYear = $"{semesterInfo.studyYear}-{start.month}-{start.day}";
- string nextStudyYear = $"{(semesterInfo.studyYear + 1)}-{start.month}-{start.day}";
- DateTimeOffset.TryParse(currStudyYear, out DateTimeOffset currYear);
- DateTimeOffset.TryParse(nextStudyYear, out DateTimeOffset nextYear);
- var alreadyYear = semesterInfo.date.Subtract(currYear);
- var soonYear = nextYear.Subtract(semesterInfo.date);
- var studyYearStarted = Math.Abs((int)alreadyYear.TotalDays);
- var studyYearEnding = Math.Abs((int)soonYear.TotalDays);
- string type = string.Empty;
- //开始天数小于60天
- if (semesterStarted <= 60)
- {
- type = "semesterStarted";
- }
- //结束天数小于60天
- if (semesterEnding <= 60)
- {
- type = "semesterEnding";
- }
- //开始天数小于60天
- if (studyYearStarted <= 60)
- {
- type = "studyYearStarted";
- }
- //结束天数小于60天
- if (studyYearEnding <= 60)
- {
- type = "studyYearEnding";
- }
- string key = $"SemesterStudyYearNotify:{_schoolId}:{semesterInfo.studyYear}:{semesterInfo.currSemester.id}:{type}";
- var keyExists = await _azureRedis.GetRedisClient(8).KeyExistsAsync(key);
- if (keyExists)
- {
- var data = await _azureRedis.GetRedisClient(8).StringGetAsync(key);
- if (data.HasValue)
- {
- SemesterStudyYearNotify notify = data.ToString().ToObject<SemesterStudyYearNotify>();
- if (notify.ignore == 1)
- {
- //忽略提示
- type = "";
- }
- else
- {
- //已经处理过的不再处理
- if (notify.process == 1)
- {
- type = "";
- }
- }
- }
- }
- else
- {
- await _azureRedis.GetRedisClient(8).StringSetAsync(key, new SemesterStudyYearNotify { studyYear = semesterInfo.studyYear, semester = semesterInfo.currSemester.id, ignore = 0, type = type }.ToJsonString());
- //60天 * 24 =1440小时
- await _azureRedis.GetRedisClient(8).KeyExpireAsync(key, new TimeSpan(1440, 0, 0));
- }
- if (!string.IsNullOrWhiteSpace(type))
- {
- if (type.Contains("Ending", StringComparison.OrdinalIgnoreCase))
- {
- string sql = $"";
- }
- if (type.Contains("Started", StringComparison.OrdinalIgnoreCase))
- {
- }
- }
- return Ok(new { code = 1, studyYearStarted, studyYearEnding, semesterStarted, semesterEnding, type, key });
- }
- }
- return Ok(new { code = -1, msg = "不需要提示" });
- }
- /// <summary>
- /// 学校dashboard统计資料
- /// </summary>
- /// <param name="jsonElement"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [HttpPost("get-scstats")]
- #if !DEBUG
- [AuthToken(Roles = "teacher,admin")]
- [Authorize(Roles = "IES")]
- #endif
- public async Task<IActionResult> GetSchoolStats(JsonElement jsonElement)
- {
- if (!jsonElement.TryGetProperty("schoolId", out JsonElement scId)) return BadRequest();
- var cosmosClient = _azureCosmos.GetCosmosClient();
- try
- {
- //0.學校基本資料取得
- AnSchool school = new();
- var respSc = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{scId}", new PartitionKey($"Base"));
- if (respSc.Status == 200)
- {
- using var fileJson = await JsonDocument.ParseAsync(respSc.ContentStream);
- school = fileJson.ToObject<AnSchool>();
- }
- else
- return Ok(new { state = RespondCode.NotFound, msg = $"未找到id:{scId};相关的学校,请检查" });
- //學校授權產品碼
- var responseProduct = await cosmosClient.GetContainer("TEAMModelOS", "School").ReadItemStreamAsync(school.id, new PartitionKey("ProductSum"));
- if (responseProduct.Status == 200)
- {
- using var json = await JsonDocument.ParseAsync(responseProduct.ContentStream);
- if (json.RootElement.TryGetProperty("serial", out JsonElement _serial) && !_serial.ValueKind.Equals(JsonValueKind.Null))
- {
- school.serial = _serial.ToObject<List<SchoolProductSumData>>().Select(x => x.prodCode).ToList();
- }
- if (json.RootElement.TryGetProperty("service", out JsonElement _service) && !_service.ValueKind.Equals(JsonValueKind.Null))
- {
- school.service = _service.ToObject<List<SchoolProductSumData>>().Select(x => x.prodCode).ToList();
- }
- if (json.RootElement.TryGetProperty("hard", out JsonElement _hard) && !_hard.ValueKind.Equals(JsonValueKind.Null))
- {
- school.hard = _hard.ToObject<List<SchoolProductSumDataHard>>().Select(x => x.prodCode).ToList();
- }
- }
- //回傳值定義
- ScStats scStats = new();
- List<LessonRecord> records = new();
- //1.學校統計資料
- StatsInfo statsInfo = null;
- List<LastYearLessAndAct> lastYear = new();
- var scDataStats = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync($"{DateTimeOffset.UtcNow.Year}-{scId}", new PartitionKey("Statistics"));
- if (scDataStats.Status == 200)
- {
- using var fileJson = await JsonDocument.ParseAsync(scDataStats.ContentStream);
- statsInfo = fileJson.ToObject<StatsInfo>();
- await foreach (var item in cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").GetItemQueryIterator<LastYearLessAndAct>(queryText: $"select c.activity,c.lesson from c where c.id='{DateTimeOffset.UtcNow.Year - 1}-{scId}'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Statistics") }))
- {
- lastYear.Add(item);
- }
- }
- else
- {
- scStats.id = $"{DateTimeOffset.UtcNow.Year}-{school.id}";
- scStats.schoolId = school.id;
- scStats.name = school.name;
- scStats.picture = school.picture;
- scStats.areaId = school.areaId;
- }
- DateTimeOffset dateTime = DateTimeOffset.UtcNow;
- long now = dateTime.ToUnixTimeMilliseconds();
- if (statsInfo != null)
- {
- scStats.id = statsInfo.id;
- scStats.schoolId = statsInfo.schoolId;
- scStats.name = statsInfo.name;
- scStats.picture = statsInfo.picture;
- scStats.areaId = statsInfo.areaId;
- scStats.tch = statsInfo.tch;
- scStats.dayTch = statsInfo.dayTch;
- scStats.weekTch = statsInfo.weekTch;
- scStats.monthTch = statsInfo.monthTch;
- scStats.stu = statsInfo.stu;
- scStats.dayStu = statsInfo.dayStu;
- scStats.weekStu = statsInfo.weekStu;
- scStats.monthStu = statsInfo.monthStu;
- scStats.room = statsInfo.room;
- scStats.witRoom = statsInfo.witRoom;
- scStats.resourceCnt = statsInfo.resourceCnt;
- scStats.size = statsInfo.size;
- scStats.scCreateTime = statsInfo.scCreateTime;
- scStats.upTime = statsInfo.upTime;
- scStats.lessStats.all = statsInfo.lesson.all;
- scStats.lessStats.open = statsInfo.lesson.open;
- scStats.lessStats.less = statsInfo.lesson.less;
- scStats.lessStats.lastDay = statsInfo.lesson.lastDay;
- scStats.lessStats.day = statsInfo.lesson.day;
- scStats.lessStats.lastWeek = statsInfo.lesson.lastWeek;
- scStats.lessStats.week = statsInfo.lesson.week;
- scStats.lessStats.lastTerm = statsInfo.lesson.lastTerm;
- scStats.lessStats.term = statsInfo.lesson.term;
- scStats.lessStats.month = statsInfo.lesson.month;
- scStats.lessStats.lastMonth = statsInfo.lesson.lastMonth;
- scStats.lessStats.lastDayInter = statsInfo.lesson.lastDayInter;
- scStats.lessStats.dayInter = statsInfo.lesson.dayInter;
- scStats.lessStats.lastMonthInter = statsInfo.lesson.lastMonthInter;
- scStats.lessStats.monthInter = statsInfo.lesson.monthInter;
- scStats.lessStats.lastYear = ((int)BICommonWay.ManyDoubleMerge(lastYear.Select(s => s.lesson.year).Where(w => w.Count > 0).ToList()).Sum());
- scStats.lessStats.lastYearInter = statsInfo.lesson.lastYearInter;
- scStats.lessStats.yearInter = statsInfo.lesson.yearInter;
- scStats.lessStats.yearInters = TimeHelper.GetYearMonth(statsInfo.lesson.yearInters, dateTime.Year, dateTime.Month);
- scStats.lessStats.year = TimeHelper.GetYearMonth(statsInfo.lesson.year, dateTime.Year, dateTime.Month);
- scStats.actStats.all = statsInfo.activity.all;
- scStats.actStats.exam = statsInfo.activity.exam;
- scStats.actStats.survey = statsInfo.activity.survey;
- scStats.actStats.vote = statsInfo.activity.vote;
- scStats.actStats.homework = statsInfo.activity.homework;
- scStats.actStats.lastDay = statsInfo.activity.lastDay;
- scStats.actStats.dayCnt = statsInfo.activity.dayCnt;
- scStats.actStats.lastWeek = statsInfo.activity.lastWeek;
- scStats.actStats.week = statsInfo.activity.week;
- scStats.actStats.lastTerm = statsInfo.activity.lastTerm;
- scStats.actStats.term = statsInfo.activity.term;
- scStats.actStats.lastMonth = statsInfo.activity.lastMonth;
- scStats.actStats.month = statsInfo.activity.month;
- scStats.actStats.lastYear = ((int)BICommonWay.ManyDoubleMerge(lastYear.Select(s => s.activity.year).Where(w => w.Count > 0).ToList()).Sum());
- scStats.actStats.year = TimeHelper.GetYearMonth(statsInfo.activity.year, dateTime.Year, dateTime.Month);
- if (statsInfo.study != null)
- {
- scStats.srStats.learnTime = statsInfo.study.learnTime;
- scStats.srStats.online = statsInfo.study.online;
- scStats.srStats.offline = statsInfo.study.offline;
- scStats.srStats.classRoom = statsInfo.study.classRoom;
- scStats.srStats.submit = statsInfo.study.submit;
- scStats.srStats.notStarted = statsInfo.study.notStarted;
- scStats.srStats.ongoing = statsInfo.study.ongoing;
- scStats.srStats.finish = statsInfo.study.finish;
- }
- }
- //2.課堂紀錄相關
- var (dayS, dayE) = TimeHelper.GetStartOrEnd(dateTime); //今天开始时间
- var (weekS, weekE) = TimeHelper.GetStartOrEnd(dateTime, "week"); //计算本周开始/结束时间
- var (monthS, monthE) = TimeHelper.GetStartOrEnd(dateTime, "month"); //本月开始/结束时间
- var (yearS, yearE) = TimeHelper.GetStartOrEnd(dateTime, "year"); //本年开始/结束时间
- await foreach (var item in cosmosClient.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<LessonRecord>(queryText: "select value(c) from c ", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"LessonRecord-{scId}") }))
- {
- records.Add(item);
- }
- //試題數
- double itemCount = 0;
- await foreach (var item in cosmosClient.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: $"SELECT count(1) as items FROM c where c.scope = 'school' ", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Item-{scId}") }))
- {
- using var json = await JsonDocument.ParseAsync(item.ContentStream);
- if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- if (obj.TryGetProperty("items", out JsonElement items))
- {
- itemCount = items.GetDouble();
- }
- }
- }
- }
- //試卷數
- double paperCount = 0;
- await foreach (var item in cosmosClient.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: $"SELECT count(1) as papers FROM c where c.scope = 'school' ", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Paper-{scId}") }))
- {
- using var json = await JsonDocument.ParseAsync(item.ContentStream);
- if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
- {
- if (obj.TryGetProperty("papers", out JsonElement papers))
- {
- paperCount = papers.GetDouble();
- }
- }
- }
- }
- //課堂紀錄資料
- double resourcesCount = itemCount + paperCount; //线上资源
- double attendCount = records.Select(c => c.attendCount).Sum(); //学生参加人数
- double clientInteractionCount = records.Select(c => c.clientInteractionCount).Sum(); //互动总次数
- double workCount = records.Select(c => c.collateCount).Sum();//课堂任务总次数
- double interactionCount = records.Select(c => c.interactionCount).Sum(); //课堂提问中题数
- double duration = records.Select(c => c.duration).Sum(); //课堂总时长
- double dayCnt = records.Where(c => c.startTime >= dayS && c.startTime <= dayE).Count(); //今天课例数
- double weekCnt = records.Where(c => c.startTime >= weekS && c.startTime <= weekE).Count(); //本周课例数
- double monthCnt = records.Where(c => c.startTime >= monthS && c.startTime <= monthE).Count(); //本月课例数
- double yearCnt = records.Where(c => c.startTime >= yearS && c.startTime <= yearE).Count(); //本年课例数
- //各年級課例數、各科目課例數
- List<(string name, string periodId, int count)> grades = LessonStatisWay.GetGradeCount(records); //取得各年级统计课例
- var subs = records.GroupBy(x => x.subjectId).Where(y => !string.IsNullOrEmpty(y.Key)).Select(y => new { key = y.Key, count = y.ToList().Count }).ToList();
- var gradeCnt = grades.Select(x => new { x.name, x.periodId, value = x.count }); //各年級課例數
- var subCnt = subs.Select(x => new { name = x.key, value = x.count }); //科目課例數
-
- object lessonStats = new { cnt = records.Count, dayCnt, weekCnt, monthCnt, yearCnt, resourcesCount, attendCount, clientInteractionCount, workCount, interactionCount, duration, gradeCnt, subCnt };
- return Ok(new { state = RespondCode.Ok, school, scStats, lessonStats });
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"IES5,{_option.Location} /school/get-scstats() \n {ex.Message}\n{ex.StackTrace}", GroupNames.成都开发測試群組);
- return BadRequest();
- }
- }
- //取得序號產品准許使用產品代碼列表
- public static List<string> getSerialPermitProdcodeList()
- {
- List<string> allowProdCode = new List<string>(); //軟體許可產品列:HiTeach STD、TBL、PRO、HiTeach5;
- allowProdCode.Add("J223IZ6M"); //HiTeach STD
- allowProdCode.Add("3222C6D2"); //HiTeach TBL
- allowProdCode.Add("J223IZAM"); //HiTeach PRO
- allowProdCode.Add("J2236ZCX"); //HiTeach Lite
- allowProdCode.Add("3222DNG2"); //HiTeach Mobile
- allowProdCode.Add("3222IAVN"); //HiTeach Premium
- allowProdCode.Add("BYJ6LZ6Z"); //HiTeach5
- allowProdCode.Add("LZLL6ZEI"); //HiTeachCC
- return allowProdCode;
- }
- }
- public class SemesterStudyYearNotify
- {
- /// <summary>
- /// 当前学年
- /// </summary>
- public int studyYear { get; set; }
- /// <summary>
- /// 当前学期
- /// </summary>
- public string semester { get; set; }
- /// <summary>
- /// 是否选择忽略 0未忽略,1 已经忽略
- /// </summary>
- public int ignore { get; set; } = 0;
- /// <summary>
- /// 提示类型
- /// </summary>
- public string type { get; set; }
- /// <summary>
- /// 是否已经处理 0未处理,1已处理
- /// </summary>
- public int process { get; set; }
- /// <summary>
- /// 学年已经开始多少天
- /// </summary>
- public int studyYearStarted { get; set; }
- /// <summary>
- /// 学年即将结束
- /// </summary>
- public int studyYearEnding { get; set; }
- /// <summary>
- /// 学期已经开始多少天
- /// </summary>
- public int semesterStarted { get; set; }
- /// <summary>
- /// 学期即将结束
- /// </summary>
- public int semesterEnding { get; set; }
- }
- }
|