SchoolController.cs 168 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879
  1. using Azure.Cosmos;
  2. using DocumentFormat.OpenXml.Spreadsheet;
  3. using HTEXLib.COMM.Helpers;
  4. using Microsoft.AspNetCore.Authorization;
  5. using Microsoft.AspNetCore.Hosting;
  6. using Microsoft.AspNetCore.Http;
  7. using Microsoft.AspNetCore.Mvc;
  8. using Microsoft.Extensions.Configuration;
  9. using Microsoft.Extensions.Options;
  10. using Newtonsoft.Json;
  11. using StackExchange.Redis;
  12. using System;
  13. using System.Collections.Generic;
  14. using System.Dynamic;
  15. using System.Globalization;
  16. using System.IO;
  17. using System.Linq;
  18. using System.Net;
  19. using System.Net.Http;
  20. using System.Net.Http.Headers;
  21. using System.Net.Http.Json;
  22. using System.Text;
  23. using System.Text.Json;
  24. using System.Threading.Tasks;
  25. using TEAMModelOS.Filter;
  26. using TEAMModelOS.Models;
  27. using TEAMModelOS.SDK;
  28. using TEAMModelOS.SDK.Context.Constant;
  29. using TEAMModelOS.SDK.DI;
  30. using TEAMModelOS.SDK.Extension;
  31. using TEAMModelOS.SDK.Models;
  32. using TEAMModelOS.SDK.Models.Cosmos.BI;
  33. using TEAMModelOS.SDK.Models.Cosmos.School;
  34. using TEAMModelOS.SDK.Models.Service.BI;
  35. using static TEAMModelOS.SDK.Models.Teacher;
  36. namespace TEAMModelOS.Controllers
  37. {
  38. [ProducesResponseType(StatusCodes.Status200OK)]
  39. [ProducesResponseType(StatusCodes.Status400BadRequest)]
  40. [Route("school/init")]
  41. [ApiController]
  42. public class SchoolController : ControllerBase
  43. {
  44. public AzureCosmosFactory _azureCosmos;
  45. private readonly AzureStorageFactory _azureStorage;
  46. private readonly AzureRedisFactory _azureRedis;
  47. private readonly DingDing _dingDing;
  48. private readonly Option _option;
  49. int baseSpaceSize = 10; //學校保底空間大小(1G)
  50. private readonly double bytes = 1073741824;
  51. private readonly int redisAclassoneDbNum = 8; //AclassOne Redis DB號
  52. private readonly IConfiguration _configuration;
  53. private readonly CoreAPIHttpService _coreAPIHttpService;
  54. private readonly IHttpClientFactory _httpClient;
  55. private readonly HttpTrigger _httpTrigger;
  56. private readonly IWebHostEnvironment _environment;
  57. public SchoolController(IWebHostEnvironment environment, HttpTrigger httpTrigger, CoreAPIHttpService coreAPIHttpService, AzureCosmosFactory azureCosmos, AzureStorageFactory azureStorage, AzureRedisFactory azureRedis, DingDing dingDing, IOptionsSnapshot<Option> option, IConfiguration configuration, IHttpClientFactory httpClient)
  58. {
  59. _azureCosmos = azureCosmos;
  60. _azureStorage = azureStorage;
  61. _azureRedis = azureRedis;
  62. _dingDing = dingDing;
  63. _option = option?.Value;
  64. _configuration = configuration;
  65. _coreAPIHttpService = coreAPIHttpService;
  66. _httpClient = httpClient;
  67. _httpTrigger = httpTrigger;
  68. _environment = environment;
  69. }
  70. /// <summary>
  71. /// 修改学校信息
  72. /// </summary>
  73. /// <param name="request"></param>
  74. /// <returns></returns>
  75. [ProducesDefaultResponseType]
  76. [HttpPost("set-school-info")]
  77. [Authorize(Roles = "IES")]
  78. [AuthToken(Roles = "admin", Permissions = "train-appraise")]
  79. public async Task<IActionResult> SetTeacherInfo(JsonElement request)
  80. {
  81. var client = _azureCosmos.GetCosmosClient();
  82. if (!request.TryGetProperty("opt", out JsonElement _opt))
  83. {
  84. return BadRequest();
  85. }
  86. var (userid, name, _, school) = HttpContext.GetAuthTokenInfo();
  87. try
  88. {
  89. SchoolTeacher teacher = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>(userid, new PartitionKey($"Teacher-{school}"));
  90. switch (true)
  91. {
  92. //修改互评开关
  93. case bool when $"{_opt}".Equals("modify-hpappraise", StringComparison.OrdinalIgnoreCase):
  94. int hpappraise = -1;
  95. if (request.TryGetProperty("hpappraise", out JsonElement _hpappraise))
  96. {
  97. int.TryParse($"{_hpappraise}", out hpappraise);
  98. }
  99. if (hpappraise != -1)
  100. {
  101. School schoolData = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>(school, new PartitionKey("Base"));
  102. schoolData.hpappraise = hpappraise;
  103. await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(schoolData, school, new PartitionKey("Base"));
  104. return Ok(new { status = 200 });
  105. }
  106. else
  107. {
  108. return Ok(new { error = 1, msg = "参数异常!" });
  109. }
  110. default:
  111. return Ok(new { error = 1, msg = "参数异常!" });
  112. }
  113. }
  114. catch (Exception ex)
  115. {
  116. await _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/init/set-teacher-info()\n{ex.Message}\n{ex.StackTrace}{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  117. return Ok(new { error = 1, msg = "参数异常!" });
  118. }
  119. }
  120. /// <summary>
  121. /// 保存或更新学校
  122. /// </summary>
  123. /// <param name="request"></param>
  124. /// <returns></returns>
  125. [ProducesDefaultResponseType]
  126. //[AuthToken(Roles = "admin")]
  127. [HttpPost("upsert")]
  128. [AuthToken(Roles = "teacher,admin,student")]
  129. #if !DEBUG
  130. [Authorize(Roles = "IES")]
  131. #endif
  132. public async Task<IActionResult> Upsert(School school)
  133. {
  134. var (userid, name, _, _school) = HttpContext.GetAuthTokenInfo();
  135. try
  136. {
  137. var tableClient = _azureStorage.GetCloudTableClient();
  138. var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");
  139. School schoolInfo = new();
  140. var client = _azureCosmos.GetCosmosClient();
  141. var schoolContainer = client.GetContainer(Constant.TEAMModelOS, "School");
  142. var response = await schoolContainer.ReadItemStreamAsync(school.id, new PartitionKey($"Base"));
  143. if (response.Status == 200)
  144. {
  145. School db_school = JsonDocument.Parse(response.Content).RootElement.Deserialize<School>();
  146. //计算 比较更改前后 学段的年级变化的学段,并重新处理行政班的毕业状态。
  147. //开启课例设置是否变更
  148. if (db_school.openLessonRecord != school.openLessonRecord)
  149. {
  150. string opentype = "close-lesson-record";
  151. string openstr = "关闭";
  152. if (school.openLessonRecord)
  153. {
  154. openstr = "开启";
  155. opentype = "open-lesson-record";
  156. }
  157. StringBuilder strMsg = new($"{name}【{userid}】{openstr}【{school.name}-{school.id}】的课堂记录菜单");
  158. //
  159. await _azureStorage.SaveLog(opentype, strMsg?.ToString(), _dingDing, "school", httpContext: HttpContext);
  160. }
  161. //变更后
  162. List<KeyValuePair<string, int>> period_gradeCount = new List<KeyValuePair<string, int>>();
  163. school.period.ForEach(z => { period_gradeCount.Add(new KeyValuePair<string, int>(z.id, z.grades.Count)); });
  164. //变更前
  165. List<KeyValuePair<string, int>> dbperiod_gradeCount = new List<KeyValuePair<string, int>>();
  166. db_school.period.ForEach(z => { dbperiod_gradeCount.Add(new KeyValuePair<string, int>(z.id, z.grades.Count)); });
  167. List<string> periodIds = new List<string>();
  168. period_gradeCount.ForEach(x =>
  169. {
  170. var gradeCount = dbperiod_gradeCount.Find(y => x.Key.Equals(y.Key));
  171. if (!string.IsNullOrWhiteSpace(gradeCount.Key))
  172. {
  173. if (gradeCount.Value != x.Value)
  174. {
  175. periodIds.Add(x.Key);
  176. }
  177. }
  178. });
  179. await SchoolService.DoGraduateClasses(_httpTrigger, _azureCosmos, periodIds, school, _option, _dingDing);
  180. //变更教师关联的学校基本信息
  181. string sql = $"SELECT distinct value(c) FROM c join A1 in c.schools where A1.schoolId='{school.id}'";
  182. List<Teacher> teachers = new List<Teacher>();
  183. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIterator<Teacher>(sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey("Base") }))
  184. {
  185. teachers.Add(item);
  186. }
  187. foreach (var item in teachers)
  188. {
  189. Teacher.TeacherSchool teacherSchool = item.schools.Find(x => x.schoolId.Equals(school.id));
  190. if (teacherSchool != null)
  191. {
  192. teacherSchool.name = school.name;
  193. teacherSchool.picture = school.picture;
  194. teacherSchool.areaId = school.areaId;
  195. }
  196. await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync(item, item.id, new PartitionKey($"Base"));
  197. }
  198. schoolInfo = await schoolContainer.UpsertItemAsync(school, new PartitionKey($"Base"));
  199. }
  200. else
  201. {
  202. school.code = "Base";
  203. schoolInfo = await schoolContainer.CreateItemAsync(school, new PartitionKey($"Base"));
  204. }
  205. //创建/修改学校信息中间件
  206. //_ = _httpTrigger.RequestHttpTrigger(new { school = $"{school}" }, _option.Location, "set-sc-birelation");
  207. await BIStats.SetSchoolBIRelation(client, blobClient, tableClient, _dingDing, schoolInfo);
  208. return Ok(new { schoolInfo });
  209. }
  210. catch (Exception ex)
  211. {
  212. await _dingDing.SendBotMsg($"CoreAPI2,{_option.Location},school/upsert()\n{ex.Message}\n{ex.StackTrace}\n", GroupNames.醍摩豆服務運維群組);
  213. return BadRequest();
  214. }
  215. }
  216. /// <summary>
  217. /// 查找学校
  218. /// </summary>
  219. /// <param name="request"></param>
  220. /// <returns></returns>
  221. [ProducesDefaultResponseType]
  222. //[AuthToken(Roles = "teacher")]
  223. [HttpPost("find")]
  224. [AuthToken(Roles = "teacher,admin,student")]
  225. #if !DEBUG
  226. [Authorize(Roles = "IES")]
  227. #endif
  228. public async Task<IActionResult> Find(JsonElement request)
  229. {
  230. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  231. var client = _azureCosmos.GetCosmosClient();
  232. List<School> schools = new();
  233. 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}'";
  234. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
  235. {
  236. using var json = await JsonDocument.ParseAsync(item.ContentStream);
  237. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  238. {
  239. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  240. {
  241. schools.Add(obj.ToObject<School>());
  242. }
  243. }
  244. }
  245. return Ok(new { schools });
  246. /* ResponseBuilder builder = ResponseBuilder.custom();
  247. if (request.TryGetProperty("code", out JsonElement code) &&! string.IsNullOrEmpty(code.ToString()))
  248. {
  249. List<School> sc = await _azureCosmos.FindByDict<School>(request);
  250. return builder.Data(sc).build();
  251. }
  252. else {
  253. return builder.Data(null).build();
  254. }*/
  255. }
  256. /// <summary>
  257. /// 取得所有學校(只取基本資料)
  258. /// </summary>
  259. /// <param name="request"></param>
  260. /// <returns></returns>
  261. [ProducesDefaultResponseType]
  262. [HttpPost("get-all-school-base")]
  263. [AuthToken(Roles = "teacher,admin,student")]
  264. #if !DEBUG
  265. [Authorize(Roles = "IES")]
  266. #endif
  267. public async Task<IActionResult> GetAllSchoolBaesInfo(JsonElement request)
  268. {
  269. var client = _azureCosmos.GetCosmosClient();
  270. List<object> schools = new();
  271. 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") }))
  272. {
  273. using var json = await JsonDocument.ParseAsync(item.ContentStream);
  274. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  275. {
  276. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  277. {
  278. schools.Add(obj.ToObject<object>());
  279. }
  280. }
  281. }
  282. return Ok(new { schools });
  283. }
  284. /// <summary>
  285. /// 取得某學校基本資料
  286. /// </summary>
  287. /// <param name="request"></param>
  288. /// <returns></returns>
  289. [ProducesDefaultResponseType]
  290. [HttpPost("get-school-base")]
  291. [AuthToken(Roles = "teacher,admin,student")]
  292. #if !DEBUG
  293. [Authorize(Roles = "IES")]
  294. #endif
  295. public async Task<IActionResult> GetSchoolBaesInfo(JsonElement request)
  296. {
  297. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  298. var client = _azureCosmos.GetCosmosClient();
  299. var schoolContainer = client.GetContainer(Constant.TEAMModelOS, "School");
  300. //取得學校學制、年級、教室
  301. List<object> classes = new List<object>();
  302. 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}") }))
  303. {
  304. var jsonc = await JsonDocument.ParseAsync(item.ContentStream);
  305. foreach (var classeinfo in jsonc.RootElement.GetProperty("Documents").EnumerateArray())
  306. {
  307. dynamic classExtobj = new ExpandoObject();
  308. classExtobj.id = classeinfo.GetProperty("id");
  309. classExtobj.name = classeinfo.GetProperty("name");
  310. classExtobj.gradeId = classeinfo.GetProperty("gradeId");
  311. classes.Add(classExtobj);
  312. }
  313. }
  314. List<object> periods = new List<object>();
  315. List<object> grades = new List<object>();
  316. var responsesch = await schoolContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey($"Base"));
  317. if (responsesch.Status == 200)
  318. {
  319. var jsons = await JsonDocument.ParseAsync(responsesch.ContentStream);
  320. if (jsons.RootElement.TryGetProperty("period", out JsonElement periodJobj))
  321. {
  322. foreach (var periodinfo in periodJobj.EnumerateArray())
  323. {
  324. dynamic periodExtobj = new ExpandoObject();
  325. periodExtobj.id = periodinfo.GetProperty("id");
  326. periodExtobj.name = periodinfo.GetProperty("name");
  327. periods.Add(periodExtobj);
  328. if (periodinfo.TryGetProperty("grades", out JsonElement gradesJobj))
  329. {
  330. foreach (var gradeinfo in gradesJobj.EnumerateArray())
  331. {
  332. dynamic gradeExtobj = new ExpandoObject();
  333. gradeExtobj.id = gradeinfo.GetProperty("id");
  334. gradeExtobj.name = gradeinfo.GetProperty("name");
  335. gradeExtobj.periodId = periodinfo.GetProperty("id");
  336. grades.Add(gradeExtobj);
  337. }
  338. }
  339. }
  340. }
  341. }
  342. return Ok(new { periods, grades, classes });
  343. }
  344. /// <summary>
  345. /// 取得某學校產品購買紀錄
  346. /// </summary>
  347. /// <param name="request"></param>
  348. /// <returns></returns>
  349. [ProducesDefaultResponseType]
  350. [HttpPost("get-school-product")]
  351. [AuthToken(Roles = "teacher,admin,student")]
  352. #if !DEBUG
  353. [Authorize(Roles = "IES")]
  354. #endif
  355. public async Task<IActionResult> GetSchoolProductInfo(JsonElement request)
  356. {
  357. try
  358. {
  359. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  360. var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
  361. var r8 = _azureRedis.GetRedisClient(8);
  362. List<SchoolProductSerial> serial = new(); //承接DB資料用:序號
  363. List<SerialInfoBaseWithdeviceBoundExt> serialResult = new(); //最後要輸出的序號結果
  364. List<SchoolProductService> serviceProduct = new(); //承接DB資料用:服務
  365. List<SchoolProductOrder> serviceOrder = new(); //服務各產品購買紀錄
  366. List<SchoolProductSumDataService> serviceSum = new(); //服務各產品購買紀錄
  367. List<SchoolProductHard> hard = new(); //承接DB資料用:硬體
  368. SchoolProductSum productSum = new(); //承接DB資料用:產品目前狀態
  369. List<SchoolProductSumProdInfo> prodinfo = new(); //產品資訊列表(名稱、八碼)
  370. List<deviceForCoreService> uuidList = new(); //要向CoreService詢問deviceID及硬體資訊的UUID列表
  371. long UTCNow = DateTimeOffset.UtcNow.ToUnixTimeSeconds();
  372. ////取得各產品目前可得數量
  373. var response = await db.ReadItemStreamAsync(school_code.ToString(), new PartitionKey($"ProductSum"));
  374. if (response.Status == 200)
  375. {
  376. using var json = await JsonDocument.ParseAsync(response.ContentStream);
  377. productSum = json.ToObject<SchoolProductSum>();
  378. prodinfo = productSum.prodinfo;
  379. serviceSum = productSum.service;
  380. }
  381. //軟體
  382. List<string> serialPermitList = getSerialPermitProdcodeList();
  383. string serialPermitJsonStr = JsonConvert.SerializeObject(serialPermitList);
  384. string serialQueryText = $"SELECT * FROM c WHERE c.dataType = 'serial' AND ARRAY_CONTAINS({serialPermitJsonStr}, c.prodCode)";
  385. await foreach (var itemsr in db.GetItemQueryStreamIterator(queryText: serialQueryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
  386. {
  387. using var json = await JsonDocument.ParseAsync(itemsr.ContentStream);
  388. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  389. {
  390. deviceForCoreService uuidForCore;
  391. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  392. {
  393. serial.Add(obj.ToObject<SchoolProductSerial>());
  394. if (obj.TryGetProperty("deviceBound", out JsonElement deviceBoundJobj) && !string.IsNullOrWhiteSpace(deviceBoundJobj.ToString()))
  395. {
  396. foreach (var deviceBoundTmpRow in deviceBoundJobj.EnumerateArray())
  397. {
  398. uuidForCore = new deviceForCoreService();
  399. uuidForCore.sn = (!string.IsNullOrWhiteSpace(Convert.ToString(obj.GetProperty("serial")))) ? Convert.ToString(obj.GetProperty("serial")) : null;
  400. uuidForCore.uuid1 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("uuid")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("uuid")) : null;
  401. uuidForCore.uuid2 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("uuid2")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("uuid2")) : null;
  402. //uuidForCore.device_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("deviceId")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("deviceId")) : null;
  403. uuidForCore.device_id = null; //[2023.6.9]迴避帶deviceId向CS取得device時資訊會重複問題
  404. uuidForCore.class_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("classId")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("classId")) : null;
  405. uuidList.Add(uuidForCore);
  406. }
  407. }
  408. }
  409. }
  410. }
  411. ////取得DeviceInfo From Core 並更新序號資料
  412. List<deviceFromCoreService> coreUuidList = (List<deviceFromCoreService>)GetDeviceFromCoreAsync(uuidList).GetAwaiter().GetResult();
  413. List<deviceBoundExt> deviceBoundArray;
  414. List<deviceFromCoreService> coreUuid;
  415. deviceForCoreService deviceBoundRow;
  416. deviceBoundExt deviceBoundExt;
  417. deviceBound serialDeviceBoundRow;
  418. SerialInfoBaseWithdeviceBoundExt serialResultRow;
  419. List<SchoolProductSerial> updSchoolProductSerialList = new List<SchoolProductSerial>(); //更新學校產品序號用
  420. foreach (SchoolProductSerial serialRow in serial)
  421. {
  422. deviceBoundArray = new List<deviceBoundExt>();
  423. coreUuid = coreUuidList
  424. .Where((deviceFromCoreService x) => x.sn == serialRow.serial)
  425. .ToList();
  426. foreach (deviceFromCoreService deviceRow in coreUuid)
  427. {
  428. if (!string.IsNullOrWhiteSpace(deviceRow.uuid1) || !string.IsNullOrWhiteSpace(deviceRow.uuid2) || !string.IsNullOrWhiteSpace(deviceRow.device_id)) //uuid1、uuid2、device_id 任一欄有值
  429. {
  430. //前端顯示用
  431. deviceBoundRow = uuidList.Where(u => u.sn == deviceRow.sn && u.uuid1 == deviceRow.uuid1 && u.uuid2 == deviceRow.uuid2).FirstOrDefault();
  432. deviceBoundExt = new deviceBoundExt();
  433. deviceBoundExt.uuid = deviceBoundRow.uuid1;
  434. deviceBoundExt.uuid2 = deviceBoundRow.uuid2;
  435. deviceBoundExt.classId = deviceBoundRow.class_id;
  436. deviceBoundExt.deviceId = deviceRow.device_id;
  437. deviceBoundExt.os = deviceRow.os;
  438. deviceBoundExt.ip = deviceRow.local_ip;
  439. deviceBoundExt.cpu = deviceRow.cpu;
  440. deviceBoundExt.pcname = deviceRow.pc_name;
  441. deviceBoundExt.osver = deviceRow.os_ver;
  442. deviceBoundArray.Add(deviceBoundExt);
  443. //DB更新用序號資料:比對IES5序號硬體列 與 CS拿到的硬體列,若吻合者將IES5序號硬體列的deviceId寫入
  444. //比對法: [IES5]UUID1==[CS]UUID2 || [IES5]UUID2==[CS]UUID1 ※null與空白算為相同
  445. serialDeviceBoundRow = serialRow.deviceBound.Where(d =>
  446. ((d.uuid == deviceBoundRow.uuid1 || (string.IsNullOrEmpty(d.uuid) && string.IsNullOrEmpty(deviceBoundRow.uuid1))) && (d.uuid2 == deviceBoundRow.uuid2 || (string.IsNullOrEmpty(d.uuid2) && string.IsNullOrEmpty(deviceBoundRow.uuid2)))) ||
  447. ((d.uuid == deviceBoundRow.uuid2 || (string.IsNullOrEmpty(d.uuid) && string.IsNullOrEmpty(deviceBoundRow.uuid2))) && (d.uuid2 == deviceBoundRow.uuid1 || (string.IsNullOrEmpty(d.uuid2) && string.IsNullOrEmpty(deviceBoundRow.uuid1))))
  448. ).FirstOrDefault();
  449. if (serialDeviceBoundRow != null)
  450. {
  451. serialDeviceBoundRow.deviceId = deviceRow.device_id;
  452. }
  453. }
  454. }
  455. if (deviceBoundArray.Count.Equals(0)) //無法取得CS的硬體資訊,則用序號的硬體資訊帶入
  456. {
  457. if (serialRow.deviceBound != null)
  458. {
  459. foreach (deviceBound serialRowDeviceBound in serialRow.deviceBound)
  460. {
  461. if (!string.IsNullOrEmpty(serialRowDeviceBound.uuid) || !string.IsNullOrEmpty(serialRowDeviceBound.uuid2))
  462. {
  463. deviceBoundExt = new deviceBoundExt();
  464. deviceBoundExt.uuid = serialRowDeviceBound.uuid;
  465. deviceBoundExt.uuid2 = serialRowDeviceBound.uuid2;
  466. deviceBoundExt.classId = serialRowDeviceBound.classId;
  467. deviceBoundExt.deviceId = serialRowDeviceBound.deviceId;
  468. deviceBoundArray.Add(deviceBoundExt);
  469. }
  470. }
  471. }
  472. }
  473. //序號更新
  474. updSchoolProductSerialList.Add(serialRow);
  475. //await db.ReplaceItemAsync<SchoolProductSerial>(serialRow, serialRow.id, new PartitionKey($"Product-{school_code}"));
  476. //回傳值
  477. serialResultRow = new SerialInfoBaseWithdeviceBoundExt();
  478. serialResultRow.code = serialRow.code;
  479. serialResultRow.id = serialRow.id;
  480. serialResultRow.dataType = serialRow.dataType;
  481. serialResultRow.serial = serialRow.serial;
  482. serialResultRow.prodCode = serialRow.prodCode;
  483. serialResultRow.clientQty = serialRow.clientQty;
  484. serialResultRow.orderDate = serialRow.orderDate;
  485. serialResultRow.regDate = serialRow.regDate;
  486. serialResultRow.startDate = serialRow.startDate;
  487. serialResultRow.endDate = serialRow.endDate;
  488. serialResultRow.deviceMax = serialRow.deviceMax;
  489. serialResultRow.expireStatus = serialRow.expireStatus;
  490. serialResultRow.status = serialRow.status;
  491. serialResultRow.deviceBound = deviceBoundArray;
  492. if (serialRow.aprule != null)
  493. {
  494. string apruleJsonString = serialRow.aprule.ToJsonString();
  495. var apruleDc = JsonDocument.Parse(apruleJsonString);
  496. serialResultRow.aprule = (apruleDc.RootElement.TryGetProperty("json", out JsonElement apruleJson)) ? apruleJson : null;
  497. }
  498. else serialResultRow.aprule = null;
  499. serialResult.Add(serialResultRow);
  500. }
  501. //服務
  502. List<SchoolProductSumDataService> service = new List<SchoolProductSumDataService>();
  503. SchoolProductSum schoolProductSum;
  504. await foreach (var items in db.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.id = '{school_code}'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProductSum") }))
  505. {
  506. using var json = await JsonDocument.ParseAsync(items.ContentStream);
  507. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  508. {
  509. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  510. {
  511. schoolProductSum = obj.ToObject<SchoolProductSum>();
  512. service = schoolProductSum.service;
  513. }
  514. }
  515. }
  516. if (service.Count > 0)
  517. {
  518. SchoolProductOrder spOrderRow;
  519. foreach (SchoolProductSumDataService serviceRow in service)
  520. {
  521. spOrderRow = new SchoolProductOrder();
  522. spOrderRow.prodCode = serviceRow.prodCode;
  523. spOrderRow.avaliable = serviceRow.avaliable;
  524. spOrderRow.avaliableStartDate = serviceRow.startDate;
  525. spOrderRow.avaliableEndDate = serviceRow.endDate;
  526. serviceOrder.Add(spOrderRow);
  527. }
  528. }
  529. #region 產品購買履歷廢除部分
  530. ////(服務)取得各產品購買履歷
  531. //await foreach (var itemsv in clientContainer.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.dataType = 'service'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
  532. //{
  533. // using var json = await JsonDocument.ParseAsync(itemsv.ContentStream);
  534. // if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  535. // {
  536. // foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  537. // {
  538. // SchoolProductService serviceProductRow = obj.ToObject<SchoolProductService>();
  539. // serviceProduct.Add(serviceProductRow);
  540. // }
  541. // }
  542. //}
  543. ////(服務)產品購買履歷整形
  544. //IEnumerable<SchoolProductService> serviceProductOrder = serviceProduct.OrderBy(sp => sp.startDate);
  545. //foreach (SchoolProductService serviceProductRow in serviceProduct)
  546. //{
  547. // //取得此產品現在可用數
  548. // SchoolProductSumDataService serviceSumNow = serviceSum.Where(ss => ss.prodCode.Equals(serviceProductRow.prodCode)).FirstOrDefault();
  549. // int serviceAvaliableNow = (serviceSumNow != null) ? serviceSumNow.avaliable : 0;
  550. // long serviceAvaliableStartDate = (serviceSumNow != null) ? serviceSumNow.startDate : 0;
  551. // long serviceAvaliableEndDate = (serviceSumNow != null) ? serviceSumNow.endDate : 0;
  552. // //取得此產品購買履歷
  553. // SchoolProductOrder serviceOrderNow = serviceOrder.Where(so => so.prodCode == serviceProductRow.prodCode).FirstOrDefault();
  554. // if (serviceOrderNow == null) //無此產品項
  555. // {
  556. // SchoolProductOrder serviceOrderRow = new SchoolProductOrder();
  557. // serviceOrderRow.prodCode = serviceProductRow.prodCode;
  558. // serviceOrderRow.order = new List<SchoolProductOrderList>();
  559. // SchoolProductOrderList serviceOrderRowOrderList = new SchoolProductOrderList();
  560. // serviceOrderRowOrderList.id = serviceProductRow.id;
  561. // serviceOrderRowOrderList.orderDate = serviceProductRow.orderDate;
  562. // serviceOrderRowOrderList.startDate = serviceProductRow.startDate;
  563. // serviceOrderRowOrderList.endDate = serviceProductRow.endDate;
  564. // serviceOrderRowOrderList.number = serviceProductRow.number;
  565. // serviceOrderRowOrderList.unit = serviceProductRow.unit;
  566. // serviceOrderRow.order.Add(serviceOrderRowOrderList);
  567. // serviceOrderRow.avaliable = serviceAvaliableNow;
  568. // serviceOrderRow.avaliableStartDate = serviceAvaliableStartDate;
  569. // serviceOrderRow.avaliableEndDate = serviceAvaliableEndDate;
  570. // serviceOrder.Add(serviceOrderRow);
  571. // }
  572. // else //有此產品項 => 看是否有此購買紀錄
  573. // {
  574. // //記入可用起始終止日
  575. // serviceOrderNow.avaliableStartDate = serviceAvaliableStartDate;
  576. // serviceOrderNow.avaliableEndDate = serviceAvaliableEndDate;
  577. // //記入購買紀錄
  578. // SchoolProductOrderList SchoolProductOrderListNow = serviceOrderNow.order.Where(Sol => Sol.id.Equals(serviceProductRow.id)).FirstOrDefault();
  579. // if (SchoolProductOrderListNow == null) //無此購買紀錄
  580. // {
  581. // SchoolProductOrderList serviceOrderRowOrderList = new SchoolProductOrderList();
  582. // serviceOrderRowOrderList.id = serviceProductRow.id;
  583. // serviceOrderRowOrderList.orderDate = serviceProductRow.orderDate;
  584. // serviceOrderRowOrderList.startDate = serviceProductRow.startDate;
  585. // serviceOrderRowOrderList.endDate = serviceProductRow.endDate;
  586. // serviceOrderRowOrderList.number = serviceProductRow.number;
  587. // serviceOrderRowOrderList.unit = serviceProductRow.unit;
  588. // serviceOrderNow.order.Add(serviceOrderRowOrderList);
  589. // }
  590. // }
  591. //}
  592. #endregion
  593. //硬體
  594. await foreach (var itemhd in db.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.dataType = 'hard'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
  595. {
  596. using var json = await JsonDocument.ParseAsync(itemhd.ContentStream);
  597. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  598. {
  599. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  600. {
  601. hard.Add(obj.ToObject<SchoolProductHard>());
  602. }
  603. }
  604. }
  605. //空間計算
  606. ////取得教師分配空間
  607. long teach = 0;
  608. var querysp = $"SELECT SUM(c.size) as size FROM c";
  609. await foreach (var item in db.GetItemQueryStreamIterator(queryText: querysp, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
  610. {
  611. var jsonts = await JsonDocument.ParseAsync(item.ContentStream);
  612. foreach (var obj in jsonts.RootElement.GetProperty("Documents").EnumerateArray())
  613. {
  614. teach = obj.GetProperty("size").GetInt64() * 1073741824; //G換算
  615. }
  616. }
  617. ////學校已使用空間
  618. long blobsize = 0;
  619. RedisValue value = default;
  620. value = r8.HashGet($"Blob:Record", $"{school_code}");
  621. if (value != default && !value.IsNullOrEmpty)
  622. {
  623. JsonElement record = value.ToString().ToObject<JsonElement>();
  624. if (record.TryGetInt64(out blobsize))
  625. {
  626. }
  627. }
  628. ////各項空間數值取得
  629. Dictionary<string, double> catalog = new();
  630. SortedSetEntry[] Scores = _azureRedis.GetRedisClient(8).SortedSetRangeByScoreWithScores($"Blob:Catalog:{school_code}");
  631. if (Scores != null)
  632. {
  633. foreach (var score in Scores)
  634. {
  635. double val = score.Score;
  636. string key = score.Element.ToString();
  637. catalog.Add(key, val);
  638. }
  639. }
  640. dynamic space = new ExpandoObject();
  641. space.size = blobsize;
  642. space.teach = teach;
  643. space.catalog = catalog;
  644. //取得購買紀錄
  645. List<object> order = await GetOrderHisFromCoreBBAsync(school_code.GetString());
  646. //取得CC授權使用狀態
  647. var hashs = await r8.HashGetAllAsync($"CC:License:{school_code.GetString()}");
  648. var ccuser = hashs.Select(x => JsonDocument.Parse(x.Value.ToString())).ToList();
  649. //更新學校產品序號
  650. _ = UpdupdSchoolProductSerialListAsync(updSchoolProductSerialList, school_code.GetString());
  651. return Ok(new { serial = serialResult, service = serviceOrder, hard, space, order, ccuser });
  652. }
  653. catch (Exception ex)
  654. {
  655. return BadRequest();
  656. }
  657. }
  658. [ProducesDefaultResponseType]
  659. [HttpPost("get-teach-count")]
  660. //[AuthToken(Roles = "teacher,admin,student")]
  661. #if !DEBUG
  662. [Authorize(Roles = "IES")]
  663. #endif
  664. public async Task<IActionResult> GetTeacCount(JsonElement request)
  665. {
  666. try
  667. {
  668. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  669. var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
  670. var r8 = _azureRedis.GetRedisClient(8);
  671. List<SchoolProductSerial> serial = new(); //承接DB資料用:序號
  672. List<deviceForCoreService> uuidList = new(); //要向CoreService詢問deviceID及硬體資訊的UUID列表
  673. long UTCNow = DateTimeOffset.UtcNow.ToUnixTimeSeconds();
  674. //軟體
  675. List<string> serialPermitList = getSerialPermitProdcodeList();
  676. string serialPermitJsonStr = JsonConvert.SerializeObject(serialPermitList);
  677. string serialQueryText = $"SELECT * FROM c WHERE c.dataType = 'serial' AND ARRAY_CONTAINS({serialPermitJsonStr}, c.prodCode)";
  678. await foreach (var itemsr in db.GetItemQueryStreamIterator(queryText: serialQueryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
  679. {
  680. using var json = await JsonDocument.ParseAsync(itemsr.ContentStream);
  681. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  682. {
  683. deviceForCoreService uuidForCore;
  684. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  685. {
  686. serial.Add(obj.ToObject<SchoolProductSerial>());
  687. if (obj.TryGetProperty("deviceBound", out JsonElement deviceBoundJobj) && !string.IsNullOrWhiteSpace(deviceBoundJobj.ToString()))
  688. {
  689. foreach (var deviceBoundTmpRow in deviceBoundJobj.EnumerateArray())
  690. {
  691. uuidForCore = new deviceForCoreService
  692. {
  693. sn = (!string.IsNullOrWhiteSpace(Convert.ToString(obj.GetProperty("serial")))) ? Convert.ToString(obj.GetProperty("serial")) : null,
  694. uuid1 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("uuid")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("uuid")) : null,
  695. uuid2 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("uuid2")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("uuid2")) : null,
  696. device_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("deviceId")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("deviceId")) : null,
  697. class_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("classId")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("classId")) : null
  698. };
  699. uuidList.Add(uuidForCore);
  700. }
  701. }
  702. }
  703. }
  704. }
  705. ////取得DeviceInfo From Core 並更新序號資料
  706. List<deviceFromCoreService> coreUuidList = (List<deviceFromCoreService>)GetDeviceFromCoreAsync(uuidList).GetAwaiter().GetResult();
  707. List<deviceBoundExt> deviceBoundArray;
  708. List<deviceBoundExt> counts = new();
  709. List<deviceFromCoreService> coreUuid;
  710. deviceForCoreService deviceBoundRow;
  711. deviceBoundExt deviceBoundExt;
  712. List<SchoolProductSerial> updSchoolProductSerialList = new List<SchoolProductSerial>(); //更新學校產品序號用
  713. foreach (SchoolProductSerial serialRow in serial)
  714. {
  715. deviceBoundArray = new List<deviceBoundExt>();
  716. coreUuid = coreUuidList
  717. .Where((deviceFromCoreService x) => x.sn == serialRow.serial)
  718. .ToList();
  719. foreach (deviceFromCoreService deviceRow in coreUuid)
  720. {
  721. if (!string.IsNullOrWhiteSpace(deviceRow.uuid1) || !string.IsNullOrWhiteSpace(deviceRow.uuid2) || !string.IsNullOrWhiteSpace(deviceRow.device_id)) //uuid1、uuid2、device_id 任一欄有值
  722. {
  723. //前端顯示用
  724. deviceBoundRow = uuidList.Where(u => u.sn == deviceRow.sn && u.uuid1 == deviceRow.uuid1 && u.uuid2 == deviceRow.uuid2).FirstOrDefault();
  725. deviceBoundExt = new deviceBoundExt
  726. {
  727. uuid = deviceBoundRow.uuid1,
  728. uuid2 = deviceBoundRow.uuid2,
  729. classId = deviceBoundRow.class_id,
  730. deviceId = deviceRow.device_id,
  731. os = deviceRow.os,
  732. ip = deviceRow.local_ip,
  733. cpu = deviceRow.cpu,
  734. pcname = deviceRow.pc_name,
  735. osver = deviceRow.os_ver
  736. };
  737. deviceBoundArray.Add(deviceBoundExt);
  738. }
  739. }
  740. if (deviceBoundArray.Count.Equals(0)) //無法取得CS的硬體資訊,則用序號的硬體資訊帶入
  741. {
  742. if (serialRow.deviceBound != null)
  743. {
  744. foreach (deviceBound serialRowDeviceBound in serialRow.deviceBound)
  745. {
  746. if (!string.IsNullOrEmpty(serialRowDeviceBound.uuid) || !string.IsNullOrEmpty(serialRowDeviceBound.uuid2))
  747. {
  748. deviceBoundExt = new deviceBoundExt
  749. {
  750. uuid = serialRowDeviceBound.uuid,
  751. uuid2 = serialRowDeviceBound.uuid2,
  752. classId = serialRowDeviceBound.classId,
  753. deviceId = serialRowDeviceBound.deviceId
  754. };
  755. deviceBoundArray.Add(deviceBoundExt);
  756. }
  757. }
  758. }
  759. }
  760. //序號更新
  761. //updSchoolProductSerialList.Add(serialRow);
  762. counts.AddRange(deviceBoundArray);
  763. //await db.ReplaceItemAsync<SchoolProductSerial>(serialRow, serialRow.id, new PartitionKey($"Product-{school_code}"));
  764. }
  765. //取得CC授權使用狀態
  766. var hashs = await r8.HashGetAllAsync($"CC:License:{school_code.GetString()}");
  767. var ccuser = hashs.Select(x => JsonDocument.Parse(x.Value.ToString())).ToList();
  768. //更新學校產品序號
  769. //_ = UpdupdSchoolProductSerialListAsync(updSchoolProductSerialList, school_code.GetString());
  770. double Teachs = counts.Count + ccuser.Count;
  771. return Ok(new { Teachs });
  772. }
  773. catch (Exception ex)
  774. {
  775. return BadRequest();
  776. }
  777. }
  778. //集體變更學校序號產品 (效能增進對策)
  779. private async Task UpdupdSchoolProductSerialListAsync(List<SchoolProductSerial> serialList, string schoolCode)
  780. {
  781. var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
  782. foreach (SchoolProductSerial serialRow in serialList)
  783. {
  784. await db.ReplaceItemAsync<SchoolProductSerial>(serialRow, serialRow.id, new PartitionKey($"Product-{schoolCode}"));
  785. }
  786. }
  787. /// <summary>
  788. /// 取得CoreDevice資訊
  789. /// </summary>
  790. /// <param name="request"></param>
  791. /// <returns></returns>
  792. private async Task<List<deviceFromCoreService>> GetDeviceFromCoreAsync(List<deviceForCoreService> uuidList)
  793. {
  794. List<deviceFromCoreService> result = new List<deviceFromCoreService>();
  795. try
  796. {
  797. string url = _configuration.GetValue<string>("HaBookAuth:CoreService:deviceinfo");
  798. string AccessToken = await getCoreAccessToken();
  799. var client = _httpClient.CreateClient();
  800. client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
  801. string uuidListJson = JsonConvert.SerializeObject(uuidList);
  802. var content = new StringContent(uuidListJson, Encoding.UTF8, "application/json");
  803. HttpResponseMessage responseMessage = await client.PostAsync(url, content);
  804. if (responseMessage.StatusCode == HttpStatusCode.OK)
  805. {
  806. string responseBody = responseMessage.Content.ReadAsStringAsync().Result;
  807. result = System.Text.Json.JsonSerializer.Deserialize<List<deviceFromCoreService>>(responseBody.ToString());
  808. }
  809. return result;
  810. }
  811. catch (Exception ex)
  812. {
  813. return result;
  814. }
  815. }
  816. /// <summary>
  817. /// 取得CoreBB學校訂單履歷資訊
  818. /// </summary>
  819. /// <param name="request"></param>
  820. /// <returns></returns>
  821. private async Task<List<object>> GetOrderHisFromCoreBBAsync(string schoolCode)
  822. {
  823. List<object> result = new List<object>();
  824. try
  825. {
  826. string url = _configuration.GetValue<string>("HaBookAuth:CoreBBAPI") + "/ies5/get-school-order";
  827. string AccessToken = await getCoreAccessToken();
  828. var client = _httpClient.CreateClient();
  829. client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
  830. string paramJson = JsonConvert.SerializeObject(new { school_code = schoolCode });
  831. var content = new StringContent(paramJson, Encoding.UTF8, "application/json");
  832. HttpResponseMessage responseMessage = await client.PostAsync(url, content);
  833. if (responseMessage.StatusCode == HttpStatusCode.OK)
  834. {
  835. string responseBody = responseMessage.Content.ReadAsStringAsync().Result;
  836. result = System.Text.Json.JsonSerializer.Deserialize<List<object>>(responseBody.ToString());
  837. }
  838. return result;
  839. }
  840. catch (Exception ex)
  841. {
  842. return result;
  843. }
  844. }
  845. private async Task<string> getCoreAccessToken()
  846. {
  847. string AccessToken = "";
  848. try
  849. {
  850. string Url = _configuration.GetValue<string>("HaBookAuth:CoreAPI") + "/oauth2/token";
  851. string GrantType = "device";
  852. string ClientID = _configuration.GetValue<string>("HaBookAuth:CoreService:clientID");
  853. string Secret = _configuration.GetValue<string>("HaBookAuth:CoreService:clientSecret");
  854. var content = new { grant_type = GrantType, client_id = ClientID, client_secret = Secret };
  855. var response = await _httpClient.CreateClient().PostAsJsonAsync($"{Url}", content);
  856. if (response.IsSuccessStatusCode)
  857. {
  858. string responseBody = response.Content.ReadAsStringAsync().Result;
  859. using (JsonDocument document = JsonDocument.Parse(responseBody.ToString()))
  860. {
  861. if (document.RootElement.TryGetProperty("access_token", out JsonElement AccessTokenObj))
  862. {
  863. AccessToken = AccessTokenObj.ToString();
  864. }
  865. }
  866. }
  867. return AccessToken;
  868. }
  869. catch (Exception ex)
  870. {
  871. return AccessToken;
  872. }
  873. }
  874. /// <summary>
  875. /// 計算各產品的初始結束時間及可用數
  876. /// </summary>
  877. /// <param name="mainPeriodList">active的主周期</param>
  878. /// <param name="periodList">附屬周期</param>
  879. /// <param name="serviceProduct">產品資訊</param>
  880. /// <returns></returns>
  881. private ServiceProductResult CalServiceProductAuth(List<ServiceMainPeriod> mainPeriodList, List<ServicePeriod> periodList, ServiceProduct serviceProduct)
  882. {
  883. periodZone periodZoneResult = new periodZone();
  884. List<periodZone> periodZone = new List<periodZone>();
  885. //篩選出產品有的副週期
  886. List<string> existPeriodIdList = new List<string>();
  887. if (serviceProduct.auth.Count > 0)
  888. {
  889. foreach (ServiceProductAuth serviceProductAuthRow in serviceProduct.auth)
  890. {
  891. if (!string.IsNullOrWhiteSpace(serviceProductAuthRow.periodId) && !existPeriodIdList.Contains(serviceProductAuthRow.periodId))
  892. {
  893. existPeriodIdList.Add(serviceProductAuthRow.periodId);
  894. }
  895. }
  896. }
  897. List<ServicePeriod> periodOrder = periodList.Where(p => existPeriodIdList.Contains(p.periodId)).OrderBy(p => Int32.Parse(p.periodId)).ToList();
  898. //combine period
  899. if (periodOrder.Count() > 0)
  900. {
  901. //篩選出主週期(複數active主週期對策) ※最終篩出唯一一組 篩選原則:(1)由此產品有的副週期ID篩出 (2)若還有複數筆,則期間長者勝出
  902. List<string> existMainPeriodIdList = new List<string>();
  903. foreach (ServicePeriod periodRow in periodOrder)
  904. {
  905. if (!existMainPeriodIdList.Contains(periodRow.mainPeriodId))
  906. {
  907. existMainPeriodIdList.Add(periodRow.mainPeriodId);
  908. }
  909. }
  910. ServiceMainPeriod mainPeriod = mainPeriodList.Where(w => existMainPeriodIdList.Contains(w.mainPeriodId)).OrderByDescending(w => w.endDate - w.startDate).First();
  911. List<ServicePeriod> periods = periodOrder.Where(p => p.mainPeriodId == mainPeriod.mainPeriodId).ToList();
  912. //combine period,compare to mainPeriod start, end
  913. periodZone = combinePeriodZone(periods);
  914. periodZoneResult.startDate = (periodZone[0].startDate > mainPeriod.startDate) ? periodZone[0].startDate : mainPeriod.startDate;
  915. periodZoneResult.endDate = (periodZone[0].endDate < mainPeriod.endDate) ? periodZone[0].endDate : mainPeriod.endDate;
  916. }
  917. //return
  918. ServiceProductResult serviceProductResult = new ServiceProductResult();
  919. if ((serviceProduct.noperiod && periodZoneResult.startDate == 0 && periodZoneResult.endDate == 0) || (!serviceProduct.noperiod && periodZoneResult.startDate > 0 && periodZoneResult.endDate > 0))
  920. {
  921. serviceProductResult.prodCode = serviceProduct.prodCode;
  922. serviceProductResult.noperiod = serviceProduct.noperiod;
  923. serviceProductResult.serviceType = serviceProduct.serviceType;
  924. serviceProductResult.startDate = periodZoneResult.startDate;
  925. serviceProductResult.endDate = periodZoneResult.endDate;
  926. serviceProductResult.avaliable = serviceProduct.avaliable;
  927. }
  928. return serviceProductResult;
  929. }
  930. /// <summary>
  931. /// 軟體序號解綁API
  932. /// </summary>
  933. /// <param name="id_token">ID Token</param>
  934. /// <param name="uuid">硬體識別碼1</param>
  935. /// <param name="uuid2">硬體識別碼2</param>
  936. /// <param name="serial">產品資訊</param>
  937. /// <returns></returns>
  938. [ProducesDefaultResponseType]
  939. [HttpPost("unbind-serial")]
  940. [Authorize(Roles = "IES")]
  941. [AuthToken(Roles = "admin,teacher")]
  942. public async Task<IActionResult> UnbindSerial(JsonElement request)
  943. {
  944. try
  945. {
  946. //輸入參數
  947. if (!request.TryGetProperty("serial", out JsonElement serialJson)) return BadRequest();
  948. var (id, name, _, _) = HttpContext.GetAuthTokenInfo(); //取得IDToken資訊
  949. request.TryGetProperty("uuid", out JsonElement uuidJson);
  950. request.TryGetProperty("uuid2", out JsonElement uuid2Json);
  951. string serial = serialJson.ToString();
  952. string uuid = uuidJson.ToString();
  953. string uuid2 = uuid2Json.ToString();
  954. if (string.IsNullOrEmpty(serial) && (string.IsNullOrEmpty(uuid) || string.IsNullOrEmpty(uuid2)))
  955. {
  956. return BadRequest();
  957. }
  958. string lang = "en-US";
  959. var content = new
  960. {
  961. lang = lang,
  962. serial = serial,
  963. uuid = uuid,
  964. uuid2 = uuid2,
  965. olduuid = "",
  966. pcname = "",
  967. dp = "IES5",
  968. user = new
  969. {
  970. id = $"{id}",
  971. name = $"{name}"
  972. }
  973. };
  974. //呼叫BB解綁API
  975. object result = new { };
  976. bool unbindFlg = false; //解綁是否成功 true:成功 false:失敗
  977. string url = _configuration.GetValue<string>("HaBookAuth:CoreBBAPI") + "/bbauthapi/srunbind";
  978. string AccessToken = await getCoreAccessToken();
  979. var client = _httpClient.CreateClient();
  980. client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
  981. HttpResponseMessage response = await client.PostAsJsonAsync(url, content);
  982. if (response.StatusCode == HttpStatusCode.OK)
  983. {
  984. string responseBody = await response.Content.ReadAsStringAsync();
  985. //result = System.Text.Json.JsonSerializer.Deserialize<object>(responseBody.ToString());
  986. var unbindResult = JsonDocument.Parse(responseBody);
  987. unbindResult.RootElement.TryGetProperty("status", out JsonElement statusJson);
  988. int status = statusJson.GetInt32();
  989. unbindResult.RootElement.TryGetProperty("error", out JsonElement errorJson);
  990. string error = errorJson.GetString();
  991. if (unbindResult.RootElement.TryGetProperty("prod", out JsonElement prodJson))
  992. {
  993. if (!prodJson.ValueKind.Equals(JsonValueKind.Null))
  994. {
  995. if (prodJson.TryGetProperty("auth_unbind_req", out JsonElement unbindReqJson))
  996. {
  997. if (!unbindReqJson.ValueKind.Equals(JsonValueKind.Undefined) && !unbindReqJson.ValueKind.Equals(JsonValueKind.Null))
  998. {
  999. unbindFlg = true;
  1000. }
  1001. }
  1002. }
  1003. }
  1004. result = (unbindFlg) ? new { status = 0, error = "" } : new { status = status, error = error };
  1005. }
  1006. else
  1007. {
  1008. result = new
  1009. {
  1010. status = 1,
  1011. error = $"Unbind serial: {serial} fail."
  1012. };
  1013. }
  1014. return Ok(result);
  1015. }
  1016. catch (Exception ex)
  1017. {
  1018. return BadRequest();
  1019. }
  1020. }
  1021. [ProducesDefaultResponseType]
  1022. [HttpPost("get-auth-hitcc")]
  1023. [Authorize(Roles = "IES")]
  1024. public async Task<IActionResult> GetHiteachCCAuth(JsonElement request)
  1025. {
  1026. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  1027. var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
  1028. var r8 = _azureRedis.GetRedisClient(8);
  1029. long now = DateTimeOffset.UtcNow.ToUnixTimeSeconds();
  1030. //取得HiTeachCC的有效授權
  1031. int avaliable = 0;
  1032. int dmax = 0;
  1033. int client = 0;
  1034. 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)",
  1035. requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Product-{school_code}") }))
  1036. {
  1037. var json = await JsonDocument.ParseAsync(item.ContentStream);
  1038. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  1039. {
  1040. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  1041. {
  1042. dmax = obj.GetProperty("deviceMax").GetInt32();
  1043. client = obj.GetProperty("clientQty").GetInt32();
  1044. }
  1045. }
  1046. }
  1047. //取得CC授權使用狀態
  1048. var hashs = await r8.HashGetAllAsync($"CC:License:{school_code.GetString()}");
  1049. var ccuser = hashs.Select(x => JsonDocument.Parse(x.Value.ToString())).ToList();
  1050. avaliable = dmax - ccuser.Count;
  1051. return Ok(new { dmax = dmax, client = client, avaliable = avaliable, ccuser = ccuser });
  1052. }
  1053. /// <summary>
  1054. /// 計算各產品的購買歷史紀錄 [舊制,不使用]
  1055. /// </summary>
  1056. /// <param name="mainPeriodList">所有的主周期</param>
  1057. /// <param name="periodList">所有附屬周期</param>
  1058. /// <param name="serviceProduct">產品資訊</param>
  1059. /// <returns></returns>
  1060. private List<ServiceProductAuthHistoryStartEnd> CalServiceProductOrderHistory(List<ServiceMainPeriod> mainPeriodList, List<ServicePeriod> periodList, ServiceProduct serviceProduct)
  1061. {
  1062. List<ServiceProductAuthHistoryStartEnd> serviceProductOrderStartEndList = new List<ServiceProductAuthHistoryStartEnd>();
  1063. //GROUP BY orderId
  1064. if (serviceProduct.auth.Count > 0)
  1065. {
  1066. List<ServiceProductAuthHistory> serviceProductOrderList = new List<ServiceProductAuthHistory>();
  1067. foreach (ServiceProductAuth serviceProductAuthRow in serviceProduct.auth)
  1068. {
  1069. ServiceProductAuthHistory existServiceProductAuthHistory = serviceProductOrderList.Where(a => a.orderId == serviceProductAuthRow.orderId).FirstOrDefault();
  1070. if (existServiceProductAuthHistory != null)
  1071. {
  1072. if (!existServiceProductAuthHistory.periodIdList.Contains(serviceProductAuthRow.periodId))
  1073. {
  1074. existServiceProductAuthHistory.periodIdList.Add(serviceProductAuthRow.periodId);
  1075. }
  1076. }
  1077. else
  1078. {
  1079. ServiceProductAuthHistory serviceProductAuthHistoryRow = new ServiceProductAuthHistory();
  1080. serviceProductAuthHistoryRow.orderId = serviceProductAuthRow.orderId;
  1081. int y = Int32.Parse(serviceProductAuthRow.orderId.Substring(0, 4));
  1082. int m = Int32.Parse(serviceProductAuthRow.orderId.Substring(4, 2));
  1083. int d = Int32.Parse(serviceProductAuthRow.orderId.Substring(6, 2));
  1084. serviceProductAuthHistoryRow.orderDate = new DateTimeOffset(y, m, d, 0, 0, 0, TimeSpan.Zero).ToUnixTimeSeconds();
  1085. serviceProductAuthHistoryRow.number = serviceProductAuthRow.number;
  1086. serviceProductAuthHistoryRow.unit = serviceProductAuthRow.unit;
  1087. serviceProductAuthHistoryRow.periodIdList = new List<string>();
  1088. serviceProductAuthHistoryRow.periodIdList.Add(serviceProductAuthRow.periodId);
  1089. serviceProductOrderList.Add(serviceProductAuthHistoryRow);
  1090. }
  1091. }
  1092. foreach (ServiceProductAuthHistory serviceProductOrderRow in serviceProductOrderList)
  1093. {
  1094. ServiceProductAuthHistoryStartEnd ServiceProductAuthHistoryStartEndRow = new ServiceProductAuthHistoryStartEnd();
  1095. //combine period
  1096. List<ServicePeriod> periodOrder = periodList.Where((ServicePeriod x) => serviceProductOrderRow.periodIdList.Contains(x.periodId)).OrderBy(p => Int32.Parse(p.periodId)).ToList();
  1097. List<periodZone> periodZone = combinePeriodZone(periodOrder);
  1098. ServiceProductAuthHistoryStartEndRow.startDate = periodZone[0].startDate;
  1099. ServiceProductAuthHistoryStartEndRow.endDate = periodZone[0].endDate;
  1100. ServiceProductAuthHistoryStartEndRow.orderId = serviceProductOrderRow.orderId;
  1101. ServiceProductAuthHistoryStartEndRow.orderDate = serviceProductOrderRow.orderDate;
  1102. ServiceProductAuthHistoryStartEndRow.number = serviceProductOrderRow.number;
  1103. ServiceProductAuthHistoryStartEndRow.unit = serviceProductOrderRow.unit;
  1104. serviceProductOrderStartEndList.Add(ServiceProductAuthHistoryStartEndRow);
  1105. }
  1106. }
  1107. //return
  1108. return serviceProductOrderStartEndList;
  1109. }
  1110. //子週期合併開始結束時間
  1111. private List<periodZone> combinePeriodZone(List<ServicePeriod> periods)
  1112. {
  1113. List<periodZone> periodZone = new List<periodZone>();
  1114. foreach (ServicePeriod periodRow in periods)
  1115. {
  1116. if (periodZone.Count == 0)
  1117. {
  1118. periodZone periodZoneNew = new periodZone();
  1119. periodZoneNew.startDate = periodRow.startDate;
  1120. periodZoneNew.endDate = periodRow.endDate;
  1121. periodZone.Add(periodZoneNew);
  1122. }
  1123. else
  1124. {
  1125. bool zoneExistFlg = false;
  1126. for (int i = 0; i < periodZone.Count; i++) //考慮到副週期可能斷成數個block,整合後取第一個
  1127. {
  1128. if (periodRow.startDate <= periodZone[i].endDate + 10 && periodZone[i].endDate + 10 < periodRow.endDate)
  1129. {
  1130. periodZone[i].endDate = periodRow.endDate;
  1131. zoneExistFlg = true;
  1132. }
  1133. else if (periodZone[i].startDate <= periodRow.endDate + 10 && periodRow.endDate + 10 < periodZone[i].endDate)
  1134. {
  1135. periodZone[i].startDate = periodRow.startDate;
  1136. zoneExistFlg = true;
  1137. }
  1138. }
  1139. if (!zoneExistFlg)
  1140. {
  1141. periodZone periodZoneNew = new periodZone();
  1142. periodZoneNew.startDate = periodRow.startDate;
  1143. periodZoneNew.endDate = periodRow.endDate;
  1144. periodZone.Add(periodZoneNew);
  1145. }
  1146. }
  1147. }
  1148. return periodZone;
  1149. }
  1150. /*
  1151. /// <summary>
  1152. /// 取得某學校AClassOne授權及使用資料
  1153. /// </summary>
  1154. /// <param name="request"></param>
  1155. /// <returns></returns>
  1156. /// 目前產品DB樣式未定,暫時依照舊樣式建構
  1157. [ProducesDefaultResponseType]
  1158. [HttpPost("get-school-aclassone")]
  1159. public async Task<IActionResult> GetSchoolAclassoneInfo(JsonElement request)
  1160. {
  1161. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  1162. var clientContainer = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
  1163. var response = await clientContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey("Product"));
  1164. int total = 0; //可分配總數
  1165. int staNum = 0; //固定分配數
  1166. int dyncNum = 0; //動態分配數
  1167. List<string> staIds = new List<string>(); //固定分配學生ID列
  1168. List<string> dyncIds = new List<string>(); //動態分配學生ID列
  1169. if (response.Status == 200)
  1170. {
  1171. var json = await JsonDocument.ParseAsync(response.ContentStream);
  1172. if (json.RootElement.TryGetProperty("service", out JsonElement serviceJobj))
  1173. {
  1174. //取得active主週期
  1175. List<ServiceMainPeriod> activeMainPeriod = new List<ServiceMainPeriod>();
  1176. if (serviceJobj.TryGetProperty("mainperiod", out JsonElement mainperiodJobj) && mainperiodJobj.ValueKind != JsonValueKind.Null)
  1177. {
  1178. foreach (var mainperiodRow in mainperiodJobj.EnumerateArray())
  1179. {
  1180. if (mainperiodRow.GetProperty("active").GetBoolean())
  1181. {
  1182. activeMainPeriod.Add(mainperiodRow.ToObject<ServiceMainPeriod>());
  1183. }
  1184. }
  1185. }
  1186. //取得active主週期的副週期
  1187. List<ServicePeriod> activePeriodOfMain = new List<ServicePeriod>();
  1188. if (serviceJobj.TryGetProperty("period", out JsonElement periodJobj) && mainperiodJobj.ValueKind != JsonValueKind.Null)
  1189. {
  1190. foreach (var periodRow in periodJobj.EnumerateArray())
  1191. {
  1192. foreach (ServiceMainPeriod mainPeriodRow in activeMainPeriod)
  1193. {
  1194. if (periodRow.GetProperty("mainPeriodId").ToString() == mainPeriodRow.mainPeriodId)
  1195. {
  1196. activePeriodOfMain.Add(periodRow.ToObject<ServicePeriod>());
  1197. }
  1198. }
  1199. }
  1200. }
  1201. //取得AClassOne可用數量
  1202. if (serviceJobj.TryGetProperty("product", out JsonElement serviceProductJobj) && serviceProductJobj.ValueKind != JsonValueKind.Null)
  1203. {
  1204. foreach (var serviceProductRow in serviceProductJobj.EnumerateArray())
  1205. {
  1206. //AClassOne買斷、週期
  1207. string prodCode = serviceProductRow.GetProperty("prodCode").GetString();
  1208. if (prodCode .Equals("RYGVCPLY") || prodCode .Equals("AEGMCPLY"))
  1209. {
  1210. ServiceProductResult serviceProductResultRow = CalServiceProductAuth(activeMainPeriod, activePeriodOfMain, serviceProductRow.ToObject<ServiceProduct>());
  1211. total += serviceProductResultRow.avaliable;
  1212. }
  1213. }
  1214. }
  1215. //取得AClassOne固定分配數、動態分配數、固定分配學生ID
  1216. if (json.RootElement.TryGetProperty("aclassone", out JsonElement aclassoneJobj))
  1217. {
  1218. if (aclassoneJobj.ValueKind != JsonValueKind.Null)
  1219. {
  1220. if (aclassoneJobj.TryGetProperty("ids", out JsonElement ids) && ids.ValueKind != JsonValueKind.Null)
  1221. {
  1222. staIds = System.Text.Json.JsonSerializer.Deserialize<List<string>>(ids.ToJsonString());
  1223. staNum = staIds.Count;
  1224. }
  1225. }
  1226. dyncIds = GetSchoolDynamicAclassOneIDList(school_code.GetString());
  1227. dyncNum = dyncIds.Count;
  1228. }
  1229. }
  1230. }
  1231. return Ok(new { total, staNum, dyncNum, staIds, dyncIds });
  1232. }
  1233. */
  1234. /// <summary>
  1235. /// 取得某學校AClassOne動態可使用數
  1236. /// </summary>
  1237. public int GetSchoolDynamicAclassOne(string schoolCode)
  1238. {
  1239. try
  1240. {
  1241. int result = 0;
  1242. string key = schoolCode + ":" + "AclassOne" + ":" + "dynamic";
  1243. var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
  1244. var dyncount = redisClient.StringGet(key);
  1245. if (redisClient.KeyExists(key))
  1246. {
  1247. result = Int32.Parse(redisClient.StringGet(key));
  1248. }
  1249. return result;
  1250. }
  1251. catch (Exception ex)
  1252. {
  1253. return 0;
  1254. }
  1255. }
  1256. /// <summary>
  1257. /// 取得某學校AClassOne動態已取用的ID List
  1258. /// </summary>
  1259. public List<string> GetSchoolDynamicAclassOneIDList(string schoolCode)
  1260. {
  1261. string key = schoolCode + ":" + "AclassOne" + ":" + "dynamicIds";
  1262. var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
  1263. RedisValue[] redisResult = redisClient.SetMembers(key);
  1264. List<string> result = Array.ConvertAll(redisResult, x => (string)x).ToList();
  1265. return result;
  1266. }
  1267. public long GetSchoolDynamicAclassOneIDCount(string schoolCode)
  1268. {
  1269. string key = schoolCode + ":" + "AclassOne" + ":" + "dynamicIds";
  1270. var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
  1271. long result = redisClient.SetLength(key);
  1272. return result;
  1273. }
  1274. /// <summary>
  1275. /// [測試用]放入某學校的AClassOne動態學生ID
  1276. /// </summary>
  1277. [ProducesDefaultResponseType]
  1278. [HttpPost("set-school-aclassone-dync")]
  1279. [AuthToken(Roles = "teacher,admin,student")]
  1280. #if !DEBUG
  1281. [Authorize(Roles = "IES")]
  1282. #endif
  1283. public IActionResult SetSchoolAclassoneDync(JsonElement request)
  1284. {
  1285. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  1286. request.TryGetProperty("student_id", out JsonElement student_id);
  1287. var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
  1288. string key1 = school_code + ":" + "AclassOne" + ":" + "dynamicIds";
  1289. RedisValue[] redisIdsOriginal = redisClient.SetMembers(key1);
  1290. var resultIdsOriginal = Array.ConvertAll(redisIdsOriginal, x => (string)x).ToList();
  1291. redisClient.SetAdd(key1, student_id.GetString());
  1292. RedisValue[] redisIds = redisClient.SetMembers(key1);
  1293. var resultIds = Array.ConvertAll(redisIds, x => (string)x).ToList();
  1294. string key2 = school_code + ":" + "AclassOne" + ":" + "dynamic";
  1295. if (resultIds.Count > resultIdsOriginal.Count)
  1296. {
  1297. redisClient.StringDecrement(key2, 1);
  1298. }
  1299. string resultCount = redisClient.StringGet(key2);
  1300. return Ok(new { resultIds, resultCount });
  1301. }
  1302. /// <summary>
  1303. /// 設定某學校AClassOne固定分配授權學生
  1304. /// </summary>
  1305. /// <param name="request"></param>
  1306. /// <returns></returns>
  1307. [ProducesDefaultResponseType]
  1308. [HttpPost("set-school-aclasson-sta")]
  1309. [AuthToken(Roles = "teacher,admin,student")]
  1310. #if !DEBUG
  1311. [Authorize(Roles = "IES")]
  1312. #endif
  1313. public async Task<IActionResult> SetSchoolAclassoneStatic(JsonElement request)
  1314. {
  1315. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  1316. if (!request.TryGetProperty("student_ids", out JsonElement student_ids)) return BadRequest();
  1317. try
  1318. {
  1319. List<string> studentIds = System.Text.Json.JsonSerializer.Deserialize<List<string>>(student_ids.ToJsonString()); //新的學生ID列
  1320. /* ERROR CODE定義:
  1321. * 0: 無錯誤
  1322. * 1: AClassOne授權數不足或無AClassOne授權
  1323. */
  1324. int status = 0;
  1325. string err = "";
  1326. var clientContainer = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
  1327. var response = await clientContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey("Product"));
  1328. if (response.Status == 200)
  1329. {
  1330. int total = 0; //(回傳值)可分配總數
  1331. int staNum = 0; //(回傳值)固定分配數
  1332. int dyncNum = 0; //(回傳值)動態分配數
  1333. List<string> staIds = new List<string>(); //(回傳值)固定學生ID列
  1334. List<string> dyncIds = new List<string>(); //(回傳值)動態學生ID列
  1335. using (Stream stream = response.ContentStream)
  1336. {
  1337. using (StreamReader streamReader = new StreamReader(stream))
  1338. {
  1339. string content = streamReader.ReadToEnd();
  1340. SchoolProduct schoolProduct = System.Text.Json.JsonSerializer.Deserialize<SchoolProduct>(content);
  1341. if (schoolProduct.aclassone != null) //有AClassOne產品授權,schoolProduct.aclassone不會為null
  1342. {
  1343. total = schoolProduct.aclassone.total;
  1344. List<string> studentIdsInDB = schoolProduct.aclassone.ids; //舊的學生ID列
  1345. int totalInDB = schoolProduct.aclassone.total;
  1346. //STEP1 驗證所給的ID數是否超過AClassOne總數
  1347. if (studentIds.Count > totalInDB)
  1348. {
  1349. status = 1;
  1350. err = "AclassOne numbers is not enouth.";
  1351. return Ok(new { status, err });
  1352. }
  1353. //STEP2 將學生ID放入 School.Product.aclassone.ids,更新aclassone.used
  1354. staIds = schoolProduct.aclassone.ids = studentIds;
  1355. staNum = schoolProduct.aclassone.used = studentIds.Count;
  1356. ////Update
  1357. await clientContainer.ReplaceItemAsync<SchoolProduct>(schoolProduct, schoolProduct.id, new PartitionKey("Product"));
  1358. //STEP3更新Redis.hbcn:AclassOne:dynamic ※註:只更新動態ID可用數,不更動動態ID列表,所以若可用數為0,當天被動態分配到的學生仍可使用至今日0時才會被清掉
  1359. int dynamicAclassCount = totalInDB - studentIds.Count; //動態可使用數
  1360. dyncNum = (int)GetSchoolDynamicAclassOneIDCount(school_code.GetString()); //動態ID已使用數
  1361. var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
  1362. string keys = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamic";
  1363. int updDynAclassCount = (dynamicAclassCount - dyncNum > 0) ? dynamicAclassCount - dyncNum : 0;
  1364. redisClient.StringSet(keys, updDynAclassCount);
  1365. string keyd = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamicIds";
  1366. RedisValue[] redisIds = redisClient.SetMembers(keyd);
  1367. dyncIds = Array.ConvertAll(redisIds, x => (string)x).ToList();
  1368. return Ok(new { status, err, total, staNum, dyncNum, staIds, dyncIds });
  1369. }
  1370. else
  1371. {
  1372. status = 1;
  1373. err = "AClassOne has no authorization.";
  1374. return Ok(new { status, err });
  1375. }
  1376. }
  1377. }
  1378. }
  1379. else
  1380. {
  1381. return BadRequest();
  1382. }
  1383. }
  1384. catch (Exception ex)
  1385. {
  1386. return BadRequest();
  1387. }
  1388. }
  1389. /// <summary>
  1390. /// 回收某學校AClassOne固定分配、動態分配授權學生
  1391. /// </summary>
  1392. /// <param name="request"></param>
  1393. /// <returns></returns>
  1394. [ProducesDefaultResponseType]
  1395. [HttpPost("recall-school-aclasson")]
  1396. [AuthToken(Roles = "teacher,admin,student")]
  1397. #if !DEBUG
  1398. [Authorize(Roles = "IES")]
  1399. #endif
  1400. public async Task<IActionResult> RecallSchoolAclassone(JsonElement request)
  1401. {
  1402. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  1403. string action = "all"; //預設回收:固定及動態均回收 sta:回收固定 dync:回收動態
  1404. if (request.TryGetProperty("mode", out JsonElement mode))
  1405. {
  1406. if (mode.GetString().Equals("sta") || mode.GetString().Equals("dync"))
  1407. {
  1408. action = mode.GetString();
  1409. }
  1410. }
  1411. int status = 0;
  1412. string err = "";
  1413. var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
  1414. string keys = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamic";
  1415. string keyd = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamicIds";
  1416. var clientContainer = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
  1417. var response = await clientContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey("Product"));
  1418. if (response.Status == 200)
  1419. {
  1420. int total = 0; //(回傳值)可分配總數
  1421. int staNum = 0; //(回傳值)固定分配數
  1422. int dyncNum = 0; //(回傳值)動態分配數
  1423. List<string> staIds = new List<string>(); //(回傳值)固定學生ID列
  1424. List<string> dyncIds = new List<string>(); //(回傳值)動態學生ID列
  1425. using (Stream stream = response.ContentStream)
  1426. {
  1427. using (StreamReader streamReader = new StreamReader(stream))
  1428. {
  1429. string content = streamReader.ReadToEnd();
  1430. SchoolProduct schoolProduct = System.Text.Json.JsonSerializer.Deserialize<SchoolProduct>(content);
  1431. if (schoolProduct.aclassone != null) //有AClassOne產品授權,schoolProduct.aclassone不會為null
  1432. {
  1433. total = schoolProduct.aclassone.total;
  1434. staNum = schoolProduct.aclassone.used;
  1435. staIds = schoolProduct.aclassone.ids;
  1436. dyncNum = (int)GetSchoolDynamicAclassOneIDCount(school_code.GetString());
  1437. dyncIds = GetSchoolDynamicAclassOneIDList(school_code.GetString());
  1438. switch (action)
  1439. {
  1440. case "sta":
  1441. staIds = schoolProduct.aclassone.ids = new List<string>();
  1442. staNum = schoolProduct.aclassone.used = 0;
  1443. await clientContainer.ReplaceItemAsync<SchoolProduct>(schoolProduct, schoolProduct.id, new PartitionKey("Product"));
  1444. int updDynAclassCount = (total - dyncNum > 0) ? total - dyncNum : 0;
  1445. redisClient.StringSet(keys, updDynAclassCount);
  1446. break;
  1447. case "dync": //動態回收
  1448. dyncNum = 0;
  1449. dyncIds = new List<string>();
  1450. redisClient.StringSet(keys, total - staNum);
  1451. redisClient.KeyDelete(keyd);
  1452. break;
  1453. case "all": //全回收
  1454. staIds = schoolProduct.aclassone.ids = new List<string>();
  1455. staNum = schoolProduct.aclassone.used = 0;
  1456. await clientContainer.ReplaceItemAsync<SchoolProduct>(schoolProduct, schoolProduct.id, new PartitionKey("Product"));
  1457. dyncNum = 0;
  1458. dyncIds = new List<string>();
  1459. redisClient.StringSet(keys, total);
  1460. redisClient.KeyDelete(keyd);
  1461. break;
  1462. }
  1463. return Ok(new { status, err, total, staNum, dyncNum, staIds, dyncIds });
  1464. }
  1465. else
  1466. {
  1467. status = 1;
  1468. err = "AClassOne has no authorization.";
  1469. return Ok(new { status, err });
  1470. }
  1471. }
  1472. }
  1473. }
  1474. else
  1475. {
  1476. return BadRequest();
  1477. }
  1478. }
  1479. /// <summary>
  1480. /// 教師空間
  1481. /// </summary>
  1482. [ProducesDefaultResponseType]
  1483. [HttpPost("teacher-space")]
  1484. [AuthToken(Roles = "teacher,admin,student")]
  1485. #if !DEBUG
  1486. [Authorize(Roles = "IES")]
  1487. #endif
  1488. public async Task<IActionResult> TeacherSpace(JsonElement request)
  1489. {
  1490. // 必要檢查
  1491. if (!request.TryGetProperty("school_code", out JsonElement code)) return BadRequest();
  1492. if (!request.TryGetProperty("action", out JsonElement type)) return BadRequest();
  1493. long usedSpace = 0;//已被使用的空間量(G)
  1494. School school = null;
  1495. string school_code = code.ToString(); // 學校簡碼
  1496. try
  1497. {
  1498. // [變數宣告]
  1499. string action = type.ToString(); // 功能分類
  1500. string queryText = ""; // 統一sql文記憶體
  1501. // response
  1502. string status = "0";
  1503. string err = "";
  1504. List<string> errTeachers = new List<string>();
  1505. RedisValue value = _azureRedis.GetRedisClient(8).HashGet($"Blob:Record", school_code);
  1506. if (value != default && !value.IsNullOrEmpty)
  1507. {
  1508. JsonElement record = value.ToString().ToObject<JsonElement>();
  1509. if (record.TryGetInt64(out usedSpace))
  1510. {
  1511. }
  1512. usedSpace = Convert.ToInt64(Math.Ceiling(usedSpace / bytes));
  1513. }
  1514. else
  1515. {
  1516. //[學校空間]
  1517. //var blobClient = _azureStorage.GetBlobContainerClient(school_code.ToString());
  1518. //long? docSize = await blobClient.GetBlobsSize("doc");
  1519. //long? videoSize = await blobClient.GetBlobsSize("video");
  1520. //long? imageSize = await blobClient.GetBlobsSize("image");
  1521. //long? paperSize = await blobClient.GetBlobsSize("paper");
  1522. //long? itemSize = await blobClient.GetBlobsSize("item");
  1523. //long? otherSize = await blobClient.GetBlobsSize("other");
  1524. //long? voteSize = await blobClient.GetBlobsSize("vote");
  1525. //long? surveySize = await blobClient.GetBlobsSize("survey");
  1526. //long? audioSize = await blobClient.GetBlobsSize("audio");
  1527. //long? resSize = await blobClient.GetBlobsSize("res");
  1528. //long? tempSize = await blobClient.GetBlobsSize("temp");
  1529. //long? thumSize = await blobClient.GetBlobsSize("thum");
  1530. //long? syllabusSize = await blobClient.GetBlobsSize("syllabus");
  1531. //long? examSize = await blobClient.GetBlobsSize("exam");
  1532. //long? recordsSize = await blobClient.GetBlobsSize("records");
  1533. //long? yxptSize = await blobClient.GetBlobsSize("yxpt");
  1534. //long? trainSize = await blobClient.GetBlobsSize("train");
  1535. //long? homeworkSize = await blobClient.GetBlobsSize("homework");
  1536. //long? avatarSize = await blobClient.GetBlobsSize("avatar");
  1537. //docSize = docSize != null ? docSize : 0;
  1538. //videoSize = videoSize != null ? videoSize : 0;
  1539. //imageSize = imageSize != null ? imageSize : 0;
  1540. //paperSize = paperSize != null ? paperSize : 0;
  1541. //itemSize = itemSize != null ? itemSize : 0;
  1542. //otherSize = otherSize != null ? otherSize : 0;
  1543. //voteSize = voteSize != null ? voteSize : 0;
  1544. //surveySize = surveySize != null ? surveySize : 0;
  1545. //audioSize = audioSize != null ? audioSize : 0;
  1546. //resSize = resSize != null ? resSize : 0;
  1547. //tempSize = tempSize != null ? tempSize : 0;
  1548. //thumSize = thumSize != null ? thumSize : 0;
  1549. //syllabusSize = syllabusSize != null ? syllabusSize : 0;
  1550. //examSize = examSize != null ? examSize : 0;
  1551. //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)));
  1552. }
  1553. long avaliable = this.baseSpaceSize; // (G) 目前學校申請空間總數
  1554. long teacherSpace = 0; // 教師可設定的空間量(G)
  1555. school = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>(school_code, new PartitionKey("Base"));
  1556. if (school.size <= 0)
  1557. {
  1558. school.size = baseSpaceSize;
  1559. }
  1560. avaliable = school.size;
  1561. // 取得學校目前的總空間數(G)
  1562. teacherSpace = avaliable - usedSpace;
  1563. List<SchoolTeacher> teachersInschool = new List<SchoolTeacher>();
  1564. switch (action)
  1565. {
  1566. case "baseSpace": // 現在的教師空間
  1567. return Ok(new
  1568. {
  1569. status,
  1570. avaliable = avaliable.ToString(),
  1571. usedSpace = usedSpace.ToString()
  1572. });
  1573. case "upd": // 修改教師空間
  1574. // [二次檢核]
  1575. if (!request.TryGetProperty("teachers", out JsonElement _teachers)) return BadRequest();
  1576. List<Teacher> teachers = _teachers.Deserialize<List<Teacher>>();
  1577. // 教師設定總數
  1578. int setSpaceTotal = 0;
  1579. // 教師List
  1580. var ids = teachers.Select(x => x.id);
  1581. int notInSpaceTotal = 0;
  1582. string notinsql = $"select value(sum(c.size)) from c ";
  1583. if (ids.Any())
  1584. {
  1585. notinsql = $"select value(sum(c.size)) from c where c.id not in ({string.Join(",", ids.Select(o => $"'{o}'"))})";
  1586. }
  1587. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<int>(queryText: notinsql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
  1588. {
  1589. notInSpaceTotal = item;
  1590. break;
  1591. }
  1592. setSpaceTotal = notInSpaceTotal + teachers.Select(x => x.size).Sum();
  1593. // 檢核總數是否超過
  1594. if (setSpaceTotal > teacherSpace)
  1595. {
  1596. status = "1"; // 要設定的空間總數大於目前學校有的
  1597. err = $"設定總量({setSpaceTotal}G)超過目前空間({teacherSpace}G)";
  1598. return Ok(new { status, err });
  1599. }
  1600. queryText = $"select * from c where c.id in ({string.Join(",", ids.Select(o => $"'{o}'"))})";
  1601. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: queryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
  1602. {
  1603. using var jsoncm = await JsonDocument.ParseAsync(item.ContentStream);
  1604. foreach (var obj in jsoncm.RootElement.GetProperty("Documents").EnumerateArray())
  1605. {
  1606. teachersInschool.Add(obj.ToObject<SchoolTeacher>());
  1607. }
  1608. }
  1609. foreach (var obj in teachers)
  1610. {
  1611. SchoolTeacher teacher = teachersInschool.Where(t => !string.IsNullOrWhiteSpace(t.id) && !string.IsNullOrWhiteSpace(obj.id) && t.id == obj.id).FirstOrDefault<SchoolTeacher>();
  1612. if (teacher != null)
  1613. {
  1614. int orgTeacherSize = teacher.size;
  1615. if (teacher.size != obj.size)
  1616. {
  1617. int bsize = teacher.size;
  1618. int asize = obj.size;
  1619. teacher.size = obj.size;
  1620. List<IdNameCode> nameCodes = new List<IdNameCode> { new IdNameCode { id = obj.id, name = obj.name, code = obj.lang } };
  1621. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(teacher, obj.id, new PartitionKey($"Teacher-{school_code}"));
  1622. var schoolData = obj.schools.Find(z => z.schoolId.Equals($"{school_code}"));
  1623. if (schoolData != null)
  1624. {
  1625. _coreAPIHttpService.PushNotify(nameCodes, "teacher_space-change", Constant.NotifyType_IES5_Management,
  1626. new Dictionary<string, object> { { "tmdname", teacher.name }, { "tmdid", teacher.id }, { "schoolName", schoolData.name }, { "bsize", bsize }, { "asize", asize } }
  1627. , _option.Location, _configuration, _dingDing, _environment.ContentRootPath);
  1628. }
  1629. }
  1630. }
  1631. }
  1632. return Ok(new { status, err, errTeachers });
  1633. case "retract": // 收回教師空間
  1634. // [取得DB資料]
  1635. queryText = "select * from c ";
  1636. string record = "0";
  1637. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: queryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
  1638. {
  1639. using var jsoncm = await JsonDocument.ParseAsync(item.ContentStream);
  1640. if (jsoncm.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  1641. {
  1642. // 修改的筆數
  1643. record = count.ToString();
  1644. //List<SchoolTeacher> teachersInschool = new List<SchoolTeacher>();
  1645. foreach (var obj in jsoncm.RootElement.GetProperty("Documents").EnumerateArray())
  1646. {
  1647. teachersInschool.Add(obj.ToObject<SchoolTeacher>());
  1648. }
  1649. foreach (SchoolTeacher teacher in teachersInschool)
  1650. {
  1651. // 修改DB裡School的老師size
  1652. int teacherSizeInSchool = teacher.size;
  1653. teacher.size = 0;
  1654. // 修改DB裡Teacher的size
  1655. var response = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemStreamAsync(teacher.id, new PartitionKey("Base"));
  1656. if (response.Status == 200)
  1657. {
  1658. var json = await JsonDocument.ParseAsync(response.ContentStream);
  1659. //軟體
  1660. Teacher teacherHimself = json.ToObject<Teacher>();
  1661. // teacherHimself.size -= teacherSizeInSchool;
  1662. // 最後一起修改
  1663. //huanghb 2021,7.21修改 ,不用再统计到Teacher-Base中 ,Teacher-Base只记录教师自己的空间大小,并包含其他学校赠与的空间,其他学校的赠与空间放在School 表的Teacher-hbcn(SchoolTeacher)中SchoolTeacher
  1664. //,并在教师登陆的时候 一并计算个人空间和总空间大小。其中总空间大小包含(个人空间+多个学校累加的空间大小,并且如果退出或者被移除Teacher-Base 的"schools": [],为空,则已经实现自动回收)
  1665. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(teacher, teacher.id, new PartitionKey($"Teacher-{school_code}"));
  1666. //await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacherHimself, teacherHimself.id, new PartitionKey("Base"));
  1667. List<IdNameCode> nameCodes = new List<IdNameCode> { new IdNameCode { id = teacherHimself.id, name = teacherHimself.name, code = teacherHimself.lang } };
  1668. var schoolData = teacherHimself.schools.Find(z => z.schoolId.Equals($"{school_code}"));
  1669. _coreAPIHttpService.PushNotify(nameCodes, "teacher_space-retract", Constant.NotifyType_IES5_Management,
  1670. new Dictionary<string, object> { { "tmdname", teacher.name }, { "tmdid", teacher.id }, { "schoolName", schoolData.name } }
  1671. , _option.Location, _configuration, _dingDing, _environment.ContentRootPath);
  1672. }
  1673. else
  1674. {
  1675. status = "3";
  1676. err = "有老師不存在於 Teacher 的DB";
  1677. }
  1678. }
  1679. }
  1680. }
  1681. return Ok(new { status, record });
  1682. default:
  1683. return BadRequest(); // 不存在的功能BadRequest
  1684. }
  1685. }
  1686. catch (CosmosException ex)
  1687. {
  1688. await _dingDing.SendBotMsg($"OS,{_option.Location},schoool/teacher-space\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  1689. return BadRequest();
  1690. }
  1691. catch (Exception ex)
  1692. {
  1693. await _dingDing.SendBotMsg($"OS,{_option.Location},schoool/teacher-space\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  1694. return BadRequest();
  1695. }
  1696. finally
  1697. {
  1698. if (school != null)
  1699. {
  1700. string sql = "select value sum(c.size ) from c ";
  1701. int teachSize = 0;
  1702. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<int>(queryText: sql,
  1703. requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
  1704. {
  1705. teachSize += item;
  1706. }
  1707. school.tsize = teachSize;
  1708. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(school, school.id, new PartitionKey("Base"));
  1709. }
  1710. }
  1711. }
  1712. [ProducesDefaultResponseType]
  1713. [HttpPost("teacher-import-manage")]
  1714. [Authorize(Roles = "IES")]
  1715. [AuthToken(Roles = "admin,teacher")]
  1716. public async Task<IActionResult> TeacherImportManage(JsonElement request)
  1717. {
  1718. (string adminId, string adminName, string pic, string schoolId) = HttpContext.GetAuthTokenInfo();
  1719. if (!request.TryGetProperty("opt", out JsonElement _opt)) { return BadRequest(); }
  1720. if (!request.TryGetProperty("schoolId", out JsonElement _schoolId)) { return BadRequest(); }
  1721. long now = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  1722. TeacherImport teacherImport = null;
  1723. List<SchoolTeacher> idsInSchool = new List<SchoolTeacher>();
  1724. List<CoreUser> coreUsers = new List<CoreUser>();
  1725. switch ($"{_opt}")
  1726. {
  1727. case "upsert":
  1728. if (!request.TryGetProperty("teachers", out JsonElement _teachers) || !_teachers.ValueKind.Equals(JsonValueKind.Array)) { return BadRequest(); }
  1729. List<ImportTeacher> teachers = _teachers.ToObject<List<ImportTeacher>>();
  1730. var tmdids = teachers.Where(x => !string.IsNullOrWhiteSpace(x.tmdid)).Select(z => z.tmdid);
  1731. var phones = teachers.Where(x => !string.IsNullOrWhiteSpace(x.phone)).Select(z => z.phone);
  1732. var emails = teachers.Where(x => !string.IsNullOrWhiteSpace(x.email)).Select(z => z.email);
  1733. List<string> keys = new List<string>();
  1734. if (tmdids.Any())
  1735. {
  1736. keys.AddRange(tmdids);
  1737. }
  1738. if (phones.Any())
  1739. {
  1740. keys.AddRange(phones);
  1741. }
  1742. if (emails.Any())
  1743. {
  1744. keys.AddRange(emails);
  1745. }
  1746. teachers.ForEach(x => { x.status = "import"; x.time = now; x.iname = x.name; x.name = null; });
  1747. if (keys.Any())
  1748. {
  1749. try
  1750. {
  1751. var content = new StringContent(keys.ToJsonString(), Encoding.UTF8, "application/json");
  1752. string json = await _coreAPIHttpService.GetUserInfos(content);
  1753. if (!string.IsNullOrWhiteSpace(json))
  1754. {
  1755. coreUsers = json.ToObject<List<CoreUser>>();
  1756. }
  1757. }
  1758. catch (Exception ex)
  1759. {
  1760. await _dingDing.SendBotMsg($"{_option.Location},导入名单时,查验key信息错误{ex.Message}\n{ex.StackTrace}\n\n{keys.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  1761. }
  1762. }
  1763. if (coreUsers.Any())
  1764. {
  1765. string sql = $"select c.id,c.status from c where c.id in ({string.Join(",", coreUsers.Select(x => $"'{x.id}'"))}) ";
  1766. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School)
  1767. .GetItemQueryIterator<SchoolTeacher>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{_schoolId}") }))
  1768. {
  1769. idsInSchool.Add(item);
  1770. }
  1771. }
  1772. List<IdNameCode> inviteids = new List<IdNameCode>();
  1773. School schoolBase = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>($"{_schoolId}", new PartitionKey("Base"));
  1774. if (coreUsers.Any())
  1775. {
  1776. foreach (var t in teachers)
  1777. {
  1778. if (!string.IsNullOrWhiteSpace(t.tmdid))
  1779. {
  1780. CoreUser coreUser = coreUsers.Find(x => x.id.Equals(t.tmdid));
  1781. if (coreUser != null)
  1782. {
  1783. t.id = coreUser.id;
  1784. t.name = coreUser.name;
  1785. t.picture = coreUser.picture;
  1786. t.tmdid = coreUser.id;
  1787. if (!string.IsNullOrWhiteSpace(coreUser.mobile))
  1788. {
  1789. t.phone = coreUser.mobile;
  1790. }
  1791. if (!string.IsNullOrWhiteSpace(coreUser.mail))
  1792. {
  1793. t.email = coreUser.mail;
  1794. }
  1795. }
  1796. }
  1797. if (string.IsNullOrWhiteSpace(t.id))
  1798. {
  1799. if (!string.IsNullOrWhiteSpace(t.phone))
  1800. {
  1801. CoreUser coreUser = coreUsers.Find(x => !string.IsNullOrWhiteSpace(x.mobile) && x.mobile.Equals(t.phone));
  1802. if (coreUser != null)
  1803. {
  1804. t.id = coreUser.id;
  1805. t.name = coreUser.name;
  1806. t.picture = coreUser.picture;
  1807. t.tmdid = coreUser.id;
  1808. if (!string.IsNullOrWhiteSpace(coreUser.mobile))
  1809. {
  1810. t.phone = coreUser.mobile;
  1811. }
  1812. if (!string.IsNullOrWhiteSpace(coreUser.mail))
  1813. {
  1814. t.email = coreUser.mail;
  1815. }
  1816. }
  1817. }
  1818. }
  1819. if (string.IsNullOrWhiteSpace(t.id))
  1820. {
  1821. if (!string.IsNullOrWhiteSpace(t.email))
  1822. {
  1823. CoreUser coreUser = coreUsers.Find(x => !string.IsNullOrWhiteSpace(x.mail) && x.mail.Equals(t.email));
  1824. if (coreUser != null)
  1825. {
  1826. t.id = coreUser.id;
  1827. t.name = coreUser.name;
  1828. t.picture = coreUser.picture;
  1829. t.tmdid = coreUser.id;
  1830. if (!string.IsNullOrWhiteSpace(coreUser.mobile))
  1831. {
  1832. t.phone = coreUser.mobile;
  1833. }
  1834. if (!string.IsNullOrWhiteSpace(coreUser.mail))
  1835. {
  1836. t.email = coreUser.mail;
  1837. }
  1838. }
  1839. }
  1840. }
  1841. if (!string.IsNullOrWhiteSpace(t.id))
  1842. {
  1843. SchoolTeacher teacher = idsInSchool.Find(x => x.id.Equals(t.id));
  1844. if (teacher != null)
  1845. {
  1846. t.status = teacher.status;
  1847. }
  1848. else
  1849. {
  1850. t.status = "invite";
  1851. teacher = new SchoolTeacher
  1852. {
  1853. id = t.id,
  1854. name = t.name,
  1855. permissions = new List<string>(),
  1856. picture = t.picture,
  1857. job = null,
  1858. roles = new List<string> { "teacher" },
  1859. status = "invite",
  1860. createTime = now,
  1861. size = 0,
  1862. subjectIds = new List<string>(),
  1863. pk = "Teacher",
  1864. code = $"Teacher-{_schoolId}"
  1865. };
  1866. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).CreateItemAsync(teacher, new PartitionKey(teacher.code));
  1867. Azure.Response responseTeacher = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReadItemStreamAsync(t.id, new PartitionKey("Base"));
  1868. if (responseTeacher.Status == 200)
  1869. {
  1870. Teacher teacherBase = JsonDocument.Parse(responseTeacher.Content).RootElement.Deserialize<Teacher>();
  1871. inviteids.Add(new IdNameCode { id = teacherBase.id, name = teacherBase.name, code = teacherBase.lang });
  1872. var school = teacherBase.schools?.Find(x => x.schoolId.Equals($"{_schoolId}"));
  1873. if (teacherBase.schools.IsNotEmpty())
  1874. {
  1875. if (school == null)
  1876. {
  1877. teacherBase.schools.Add(new Teacher.TeacherSchool { schoolId = schoolBase.id, name = schoolBase.name, picture = schoolBase.picture, areaId = schoolBase.areaId, time = now, status = "invite" });
  1878. }
  1879. }
  1880. else
  1881. {
  1882. 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" } };
  1883. }
  1884. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReplaceItemAsync(teacherBase, teacherBase.id, new PartitionKey("Base"));
  1885. }
  1886. else
  1887. {
  1888. Teacher teacherBase = new Teacher
  1889. {
  1890. createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds(),
  1891. id = t.id,
  1892. name = t.name,
  1893. picture = t.picture,
  1894. size = 2,
  1895. code = "Base",
  1896. pk = "Base",
  1897. schools = new List<Teacher.TeacherSchool> {
  1898. new Teacher.TeacherSchool {
  1899. schoolId= schoolBase.id,
  1900. name= schoolBase.name,picture= schoolBase.picture, areaId= schoolBase.areaId,time=now,status= "invite" },
  1901. }
  1902. };
  1903. inviteids.Add(new IdNameCode { id = teacherBase.id, name = teacherBase.name, code = teacherBase.lang });
  1904. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).CreateItemAsync(teacherBase, new PartitionKey("Base"));
  1905. }
  1906. }
  1907. }
  1908. }
  1909. }
  1910. Azure.Response response = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemStreamAsync($"{_schoolId}", new PartitionKey("TeacherImport"));
  1911. if (response.Status == 200)
  1912. {
  1913. teacherImport = JsonDocument.Parse(response.Content).RootElement.Deserialize<TeacherImport>();
  1914. if (teacherImport != null && teacherImport.teachers.Any())
  1915. {
  1916. teachers.ForEach(x =>
  1917. {
  1918. ImportTeacher tch = null;
  1919. if (string.IsNullOrWhiteSpace(x.id))
  1920. {
  1921. tch = teacherImport.teachers.Find(t => !string.IsNullOrWhiteSpace(t.iname) && t.iname.Equals(x.iname));
  1922. }
  1923. else
  1924. {
  1925. tch = teacherImport.teachers.Find(t => !string.IsNullOrWhiteSpace(x.id) && !string.IsNullOrWhiteSpace(t.id) && t.id.Equals(x.id));
  1926. }
  1927. if (tch != null)
  1928. {
  1929. tch.time = now;
  1930. tch.status = x.status;
  1931. tch.name = x.name;
  1932. tch.iname = x.iname;
  1933. tch.picture = x.picture;
  1934. tch.phone = x.phone;
  1935. tch.tmdid = x.tmdid;
  1936. tch.email = x.email;
  1937. tch.note = x.note;
  1938. tch.id = x.id;
  1939. }
  1940. else
  1941. {
  1942. teacherImport.teachers.Add(new ImportTeacher
  1943. {
  1944. time = now,
  1945. status = x.status,
  1946. name = x.name,
  1947. iname = x.iname,
  1948. picture = x.picture,
  1949. phone = x.phone,
  1950. tmdid = x.tmdid,
  1951. email = x.email,
  1952. note = x.note,
  1953. id = x.id
  1954. });
  1955. }
  1956. });
  1957. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(teacherImport, $"{_schoolId}", new PartitionKey("TeacherImport"));
  1958. }
  1959. else
  1960. {
  1961. teacherImport = new TeacherImport { id = $"{_schoolId}", code = "TeacherImport", pk = "TeacherImport", teachers = teachers };
  1962. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(teacherImport, $"{_schoolId}", new PartitionKey("TeacherImport"));
  1963. }
  1964. }
  1965. else
  1966. {
  1967. teacherImport = new TeacherImport { id = $"{_schoolId}", code = "TeacherImport", pk = "TeacherImport", teachers = teachers };
  1968. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).CreateItemAsync(teacherImport, new PartitionKey("TeacherImport"));
  1969. }
  1970. if (inviteids.Any())
  1971. {
  1972. string bizcode = "invite";
  1973. _coreAPIHttpService.PushNotify(inviteids, $"{bizcode}_school", Constant.NotifyType_IES5_Management,
  1974. new Dictionary<string, object> { { "tmdname", adminName }, { "schoolName", schoolBase.name }, { "schoolId", $"{_schoolId}" }, { "tmdid", adminId } }, _option.Location, _configuration, _dingDing, _environment.ContentRootPath);
  1975. }
  1976. break;
  1977. }
  1978. return Ok(new { teacherImport });
  1979. }
  1980. //取得學校IOT資料
  1981. [ProducesDefaultResponseType]
  1982. [HttpPost("get-school-iot")]
  1983. [Authorize(Roles = "IES")]
  1984. [AuthToken(Roles = "admin,teacher")]
  1985. public async Task<IActionResult> getSchoolIotData(JsonElement request)
  1986. {
  1987. try
  1988. {
  1989. if (!request.TryGetProperty("schoolId", out JsonElement _schoolId)) return BadRequest();
  1990. string periodId = (request.TryGetProperty("periodId", out JsonElement _periodId)) ? _periodId.ToString() : string.Empty;
  1991. var sdate = (request.TryGetProperty("sdate", out JsonElement _sdate)) ? TimeHelper.GetDateTime(_sdate.GetString(), "yyyy-MM-dd") : (0, 0, 0, 0, 0);
  1992. var edate = (request.TryGetProperty("edate", out JsonElement _edate)) ? TimeHelper.GetDateTime(_edate.GetString(), "yyyy-MM-dd") : (0, 0, 0, 0, 0);
  1993. //取得學校基本資訊
  1994. School schoolBase = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>($"{_schoolId}", new PartitionKey("Base"));
  1995. if (string.IsNullOrWhiteSpace(schoolBase.id)) return BadRequest();
  1996. string schName = schoolBase.name;
  1997. string schRegion = schoolBase.region;
  1998. string schProvince = schoolBase.province;
  1999. string schCity = schoolBase.city;
  2000. string schDist = schoolBase.dist;
  2001. string schAreaId = schoolBase.areaId;
  2002. string schType = schoolBase.code;
  2003. var period = (!string.IsNullOrWhiteSpace(periodId)) ? schoolBase.period.Find(x => x.id.Equals($"{periodId}")) : schoolBase.period[0];
  2004. if (period == null) period = schoolBase.period[0];
  2005. (Semester currSemester, int studyYear, DateTimeOffset curr, DateTimeOffset date, DateTimeOffset nextSemester) info = SchoolService.GetSemester(period);
  2006. string semesterId = info.currSemester.id;
  2007. var datetime = DateTimeOffset.UtcNow;
  2008. int studyYear = info.studyYear;
  2009. int dateFromYear = (!sdate.Item1.Equals(0)) ? sdate.Item1 : studyYear;
  2010. int dateFromMonth = (!sdate.Item2.Equals(0)) ? sdate.Item2 : info.currSemester.month;
  2011. int dateFromDay = (!sdate.Item3.Equals(0)) ? sdate.Item3 : info.currSemester.day;
  2012. int dateToYear = (!edate.Item1.Equals(0)) ? edate.Item1 : datetime.Year;
  2013. int dateToMonth = (!edate.Item2.Equals(0)) ? edate.Item2 : datetime.Month;
  2014. int dateToDay = (!edate.Item3.Equals(0)) ? edate.Item3 : datetime.Day;
  2015. //教室數
  2016. int classCnt = 0;
  2017. string sql = $"SELECT VALUE COUNT(c.id) FROM c";
  2018. await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Class-{_schoolId}") }))
  2019. {
  2020. classCnt = items;
  2021. }
  2022. //總教師數
  2023. int teacherCnt = 0;
  2024. sql = $"SELECT VALUE COUNT(c.id) FROM c";
  2025. await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{_schoolId}") }))
  2026. {
  2027. teacherCnt = items;
  2028. }
  2029. //學生數 用學段篩選 未畢業
  2030. int studentCnt = 0;
  2031. string sql_studentCnt = $"SELECT count(1) as stus FROM c where c.periodId = '{periodId}' and (c.graduate = 0 OR IS_DEFINED(c.graduate) = false) ";
  2032. await foreach (var items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Student").GetItemQueryStreamIterator(queryText: sql_studentCnt, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Base-{_schoolId}") }))
  2033. {
  2034. using var json = await JsonDocument.ParseAsync(items.ContentStream);
  2035. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  2036. {
  2037. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  2038. {
  2039. if (obj.TryGetProperty("stus", out JsonElement stus))
  2040. {
  2041. studentCnt = stus.GetInt32();
  2042. }
  2043. }
  2044. }
  2045. }
  2046. //HiTeach硬體授權數
  2047. int deviceAuthCnt = 0;
  2048. //List<string> serialPermitList = getSerialPermitProdcodeList();
  2049. List<string> serialPermitList = new List<string>() { "J223IZ6M", "3222C6D2", "J223IZAM", "J2236ZCX", "3222DNG2", "3222IAVN", "BYJ6LZ6Z" };
  2050. string serialPermitJsonStr = JsonConvert.SerializeObject(serialPermitList);
  2051. string serialQueryText = $"SELECT VALUE SUM(c.deviceMax) FROM c WHERE c.dataType = 'serial' AND ARRAY_CONTAINS({serialPermitJsonStr}, c.prodCode) AND c.expireStatus = 'A'";
  2052. await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: serialQueryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{_schoolId}") }))
  2053. {
  2054. deviceAuthCnt = items;
  2055. }
  2056. //取得產品分析資訊
  2057. List<string> tmidList = new List<string>(); ///TMID列表
  2058. int stuShow = 0; ///學生人次
  2059. long stuLessonLengMin = 0; ///學生參與總時間數(分)
  2060. int lessonRecord = 0; ///課堂數
  2061. long lessonLengMin = 0; ///課堂時間數(分)
  2062. int mission = 0; ///課中統計-任務數
  2063. int missionFin = 0; ///課中統計-作品數
  2064. int item = 0; ///課中統計-題目數
  2065. int interact = 0; ///課中統計-互動次數
  2066. int lTypeCoop = 0; ///學習型態: 合作
  2067. int lTypeIact = 0; ///學習型態: 互動
  2068. int lTypeMis = 0; ///學習型態: 任務
  2069. int lTypeTst = 0; ///學習型態: 測驗
  2070. int lTypeDif = 0; ///學習型態: 差異化
  2071. List<string> deviceList = new List<string>(); ///設備統計(教室數統計)
  2072. List<string> htcDevList = new List<string>(); ///設備統計-HiTeach Device list
  2073. List<string> htaDevList = new List<string>(); ///設備統計-HiTA Device list
  2074. List<string> htccDevList = new List<string>(); ///設備統計-HiTeachCC Device list
  2075. DateTimeOffset dateTimeFrom = new DateTimeOffset(dateFromYear, dateFromMonth, dateFromDay, 0, 0, 0, TimeSpan.Zero);
  2076. DateTimeOffset dateTimeTo = new DateTimeOffset(dateToYear, dateToMonth, dateToDay, 23, 59, 59, TimeSpan.Zero);
  2077. long dateTimeFromSec = dateTimeFrom.ToUnixTimeSeconds();
  2078. long dateTimeToSec = dateTimeTo.ToUnixTimeSeconds();
  2079. List<ProdAnalysisApiResult> iotData = new List<ProdAnalysisApiResult>();
  2080. sql = $"SELECT * FROM c WHERE c.schoolId = '{_schoolId}' AND c.dateUnit = 'day' AND c.dateTime >= {dateTimeFromSec} AND c.dateTime <= {dateTimeToSec}";
  2081. await foreach (var items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryStreamIterator(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
  2082. {
  2083. var json = await JsonDocument.ParseAsync(items.ContentStream);
  2084. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  2085. {
  2086. ProdAnalysisApiResult data = obj.ToObject<ProdAnalysisApiResult>();
  2087. data.school.name = schName;
  2088. data.school.region = schRegion;
  2089. data.school.province = schProvince;
  2090. data.school.city = schCity;
  2091. data.school.dist = schDist;
  2092. data.school.areaId = schAreaId;
  2093. data.school.type = schType;
  2094. iotData.Add(data);
  2095. tmidList = tmidList.Union(data.tmidList).ToList();
  2096. stuShow += data.stuShow;
  2097. stuLessonLengMin += data.stuLessonLengMin;
  2098. lessonRecord += data.lessonRecord;
  2099. lessonLengMin += data.lessonLengMin;
  2100. mission += data.mission;
  2101. missionFin += data.missionFin;
  2102. item += data.item;
  2103. interact += data.interact;
  2104. deviceList = deviceList.Union(data.deviceList).ToList();
  2105. if (data.toolType.Equals("HiTeach")) htcDevList = htcDevList.Union(data.deviceList).ToList();
  2106. if (data.toolType.Equals("HiTA")) htaDevList = htaDevList.Union(data.deviceList).ToList();
  2107. if (data.toolType.Equals("HiTeachCC")) htccDevList = htccDevList.Union(data.deviceList).ToList();
  2108. lTypeCoop += data.lTypeCoop;
  2109. lTypeIact += data.lTypeIact;
  2110. lTypeMis += data.lTypeMis;
  2111. lTypeTst += data.lTypeTst;
  2112. lTypeDif += data.lTypeDif;
  2113. }
  2114. }
  2115. int teacherShow = tmidList.Count; ///老師使用人次
  2116. int htcDevCnt = htcDevList.Count; ///設備統計-HiTeach上線數
  2117. int htcDevTotalCnt = 0; ///設備統計-HiTeach總設備數
  2118. 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')";
  2119. await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
  2120. {
  2121. htcDevTotalCnt = items;
  2122. }
  2123. int htaDevCnt = htaDevList.Count; ///設備統計-HiTA上線數
  2124. int htaDevTotalCnt = 0; ///設備統計-HiTA總設備數
  2125. 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')";
  2126. await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
  2127. {
  2128. htaDevTotalCnt = items;
  2129. }
  2130. int htccDevCnt = htccDevList.Count; ///設備統計-HiTeachCC上線數
  2131. 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 });
  2132. }
  2133. catch (Exception ex)
  2134. {
  2135. await _dingDing.SendBotMsg($"OS,{_option.Location},school/init/get-school-iot\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  2136. return BadRequest();
  2137. }
  2138. }
  2139. [ProducesDefaultResponseType]
  2140. [HttpPost("get-area-iot")]
  2141. [Authorize(Roles = "IES")]
  2142. [AuthToken(Roles = "admin,teacher")]
  2143. public async Task<IActionResult> getAreaIotData(JsonElement request)
  2144. {
  2145. try
  2146. {
  2147. //回傳值定義
  2148. IotStatisticsArea areaIot = new IotStatisticsArea(); //學區IOT統計結果
  2149. List<IotStatisticsSch> schoolIotResult = new List<IotStatisticsSch>(); //學校IOT統計結果
  2150. List<ProdAnalysisApiResult> iotData = new List<ProdAnalysisApiResult>(); //IOT資料
  2151. string err = string.Empty;
  2152. //取得ID
  2153. var (tmid, name, _, _school) = HttpContext.GetAuthTokenInfo();
  2154. if(string.IsNullOrWhiteSpace(tmid)) return BadRequest();
  2155. Teacher tmidInfo = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReadItemAsync<Teacher>(tmid, new PartitionKey("Base"));
  2156. //區管理者權限驗證 (有給areaId則驗)
  2157. string areaId = (request.TryGetProperty("areaId", out JsonElement _areaId)) ? _areaId.GetString() : string.Empty;
  2158. if(!string.IsNullOrWhiteSpace(areaId))
  2159. {
  2160. TeacherArea hasAreaAdmin = tmidInfo.areas.Where(a => a.areaId.Equals(areaId)).FirstOrDefault();
  2161. if(hasAreaAdmin == null || !hasAreaAdmin.status.Equals("join"))
  2162. {
  2163. err = "Permission denied.";
  2164. return Ok(new { err, area = areaIot, school = schoolIotResult, iotData });
  2165. }
  2166. }
  2167. //學校資料取得
  2168. if (!request.TryGetProperty("schoolIds", out JsonElement _schoolIds)) return BadRequest();
  2169. List<string> schoolIds = _schoolIds.ToObject<List<string>>();
  2170. List<string> periodIds = (request.TryGetProperty("periodIds", out JsonElement _periodIds)) ? _periodIds.ToObject<List<string>>() : new List<string>();
  2171. Dictionary<string, string> schPeriodDic = new Dictionary<string, string>(); //學校ID => 學段ID 字典製作
  2172. if (schoolIds.Count > 0 && periodIds.Count > 0)
  2173. {
  2174. for (var i = 0; i < schoolIds.Count; i++)
  2175. {
  2176. if (periodIds.Count > i && periodIds[i] != null)
  2177. {
  2178. schPeriodDic.Add(schoolIds[i], periodIds[i]);
  2179. }
  2180. }
  2181. }
  2182. var sdate = (request.TryGetProperty("sdate", out JsonElement _sdate)) ? TimeHelper.GetDateTime(_sdate.GetString(), "yyyy-MM-dd") : (0, 0, 0, 0, 0);
  2183. var edate = (request.TryGetProperty("edate", out JsonElement _edate)) ? TimeHelper.GetDateTime(_edate.GetString(), "yyyy-MM-dd") : (0, 0, 0, 0, 0);
  2184. //取得學校基本資訊
  2185. string schoolIdsJsonStr = JsonConvert.SerializeObject(schoolIds);
  2186. string sql = $"SELECT * FROM c WHERE ARRAY_CONTAINS({schoolIdsJsonStr}, c.id)";
  2187. List<School> schools = new List<School>();
  2188. await foreach (var items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryStreamIterator(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Base") }))
  2189. {
  2190. using var json = await JsonDocument.ParseAsync(items.ContentStream);
  2191. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  2192. {
  2193. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  2194. {
  2195. schools.Add(obj.ToObject<School>());
  2196. }
  2197. }
  2198. }
  2199. if (schools.Count.Equals(0))
  2200. {
  2201. return Ok(new { err, area = areaIot, school = schoolIotResult, iotData });
  2202. }
  2203. //取得各校IOT相關統計值
  2204. Dictionary<string, IotStatisticsSch> schIot = new Dictionary<string, IotStatisticsSch>(); //各校IOT統計項
  2205. List<string> serialPermitList = new List<string>() { "J223IZ6M", "3222C6D2", "J223IZAM", "J2236ZCX", "3222DNG2", "3222IAVN", "BYJ6LZ6Z" };
  2206. string serialPermitJsonStr = JsonConvert.SerializeObject(serialPermitList);
  2207. foreach (School school in schools)
  2208. {
  2209. string schName = school.name;
  2210. string schRegion = school.region;
  2211. string schProvince = school.province;
  2212. string schCity = school.city;
  2213. string schDist = school.dist;
  2214. string schAreaId = school.areaId;
  2215. string schType = school.code;
  2216. Period period = (schPeriodDic.ContainsKey(school.id)) ? school.period.Find(x => x.id.Equals($"{schPeriodDic[school.id]}")) : school.period[0];
  2217. if (period == null) period = school.period[0];
  2218. (Semester currSemester, int studyYear, DateTimeOffset curr, DateTimeOffset date, DateTimeOffset nextSemester) info = SchoolService.GetSemester(period);
  2219. string semesterId = info.currSemester.id;
  2220. var datetime = DateTimeOffset.UtcNow;
  2221. int studyYear = info.studyYear;
  2222. int dateFromYear = (!sdate.Item1.Equals(0)) ? sdate.Item1 : studyYear;
  2223. int dateFromMonth = (!sdate.Item2.Equals(0)) ? sdate.Item2 : info.currSemester.month;
  2224. int dateFromDay = (!sdate.Item3.Equals(0)) ? sdate.Item3 : info.currSemester.day;
  2225. int dateToYear = (!edate.Item1.Equals(0)) ? edate.Item1 : datetime.Year;
  2226. int dateToMonth = (!edate.Item2.Equals(0)) ? edate.Item2 : datetime.Month;
  2227. int dateToDay = (!edate.Item3.Equals(0)) ? edate.Item3 : datetime.Day;
  2228. DateTimeOffset dateTimeFrom = new DateTimeOffset(dateFromYear, dateFromMonth, dateFromDay, 0, 0, 0, TimeSpan.Zero);
  2229. DateTimeOffset dateTimeTo = new DateTimeOffset(dateToYear, dateToMonth, dateToDay, 23, 59, 59, TimeSpan.Zero);
  2230. long dateTimeFromSec = dateTimeFrom.ToUnixTimeSeconds();
  2231. long dateTimeToSec = dateTimeTo.ToUnixTimeSeconds();
  2232. //學校IOT 初始化
  2233. if (!schIot.ContainsKey(school.id))
  2234. {
  2235. schIot.Add(school.id, new IotStatisticsSch());
  2236. schIot[school.id].schId = school.id;
  2237. schIot[school.id].schName = schName;
  2238. schIot[school.id].sdate = $"{dateFromYear}-{dateFromMonth}-{dateFromDay}";
  2239. schIot[school.id].edate = $"{dateToYear}-{dateToMonth}-{dateToDay}";
  2240. }
  2241. //教室數(今年)
  2242. sql = $"SELECT VALUE COUNT(c.id) FROM c WHERE c.year = {studyYear}";
  2243. 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}") }))
  2244. {
  2245. areaIot.classCnt += items;
  2246. schIot[school.id].classCnt = items;
  2247. }
  2248. //總教師數
  2249. sql = $"SELECT VALUE COUNT(c.id) FROM c";
  2250. 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}") }))
  2251. {
  2252. areaIot.teacherCnt += items;
  2253. schIot[school.id].teacherCnt = items;
  2254. }
  2255. //學生數(今年)
  2256. // 加上篩選學段的邏輯 去除之前的廢資料
  2257. StringBuilder sb = new();
  2258. sb.Append("(");
  2259. for (int i = 0; i < school.period.Count; i++)
  2260. {
  2261. sb.Append("'");
  2262. sb.Append(school.period[i].id);
  2263. sb.Append("'");
  2264. if (i != school.period.Count - 1) { sb.Append(", "); }
  2265. }
  2266. sb.Append(")");
  2267. 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) ";
  2268. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Student").GetItemQueryStreamIterator(queryText: sql_studentCnt, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Base-{school.id}") }))
  2269. {
  2270. using var json = await JsonDocument.ParseAsync(item.ContentStream);
  2271. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  2272. {
  2273. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  2274. {
  2275. if (obj.TryGetProperty("stus", out JsonElement stus))
  2276. {
  2277. areaIot.studentCnt += stus.GetInt32();
  2278. schIot[school.id].studentCnt = stus.GetInt32();
  2279. }
  2280. }
  2281. }
  2282. }
  2283. //HiTeach硬體授權數
  2284. sql = $"SELECT VALUE SUM(c.deviceMax) FROM c WHERE c.dataType = 'serial' AND ARRAY_CONTAINS({serialPermitJsonStr}, c.prodCode) AND c.expireStatus = 'A'";
  2285. 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}") }))
  2286. {
  2287. areaIot.deviceAuthCnt += items;
  2288. schIot[school.id].deviceAuthCnt = items;
  2289. }
  2290. //IOT
  2291. sql = $"SELECT * FROM c WHERE c.schoolId = '{school.id}' AND c.dateUnit = 'day' AND c.dateTime >= {dateTimeFromSec} AND c.dateTime <= {dateTimeToSec}";
  2292. await foreach (var items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryStreamIterator(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
  2293. {
  2294. var json = await JsonDocument.ParseAsync(items.ContentStream);
  2295. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  2296. {
  2297. ProdAnalysisApiResult data = obj.ToObject<ProdAnalysisApiResult>();
  2298. data.school.name = schName;
  2299. data.school.region = schRegion;
  2300. data.school.province = schProvince;
  2301. data.school.city = schCity;
  2302. data.school.dist = schDist;
  2303. data.school.areaId = schAreaId;
  2304. data.school.type = schType;
  2305. iotData.Add(data);
  2306. //學校IOT統計
  2307. schIot[school.id].tmidList = schIot[school.id].tmidList.Union(data.tmidList).ToList();
  2308. schIot[school.id].stuShow += data.stuShow;
  2309. schIot[school.id].stuLessonLengMin += data.stuLessonLengMin;
  2310. schIot[school.id].lessonRecord += data.lessonRecord;
  2311. schIot[school.id].lessonLengMin += data.lessonLengMin;
  2312. schIot[school.id].mission += data.mission;
  2313. schIot[school.id].missionFin += data.missionFin;
  2314. schIot[school.id].item += data.item;
  2315. schIot[school.id].interact += data.interact;
  2316. if (data.toolType.Equals("HiTeach")) schIot[school.id].htcDevList = schIot[school.id].htcDevList.Union(data.deviceList).ToList();
  2317. if (data.toolType.Equals("HiTA")) schIot[school.id].htaDevList = schIot[school.id].htaDevList.Union(data.deviceList).ToList();
  2318. if (data.toolType.Equals("HiTeachCC")) schIot[school.id].htccDevList = schIot[school.id].htccDevList.Union(data.deviceList).ToList();
  2319. schIot[school.id].lTypeCoop += data.lTypeCoop;
  2320. schIot[school.id].lTypeIact += data.lTypeIact;
  2321. schIot[school.id].lTypeMis += data.lTypeMis;
  2322. schIot[school.id].lTypeTst += data.lTypeTst;
  2323. schIot[school.id].lTypeDif += data.lTypeDif;
  2324. }
  2325. }
  2326. ///設備統計-HiTeach總設備數
  2327. 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')";
  2328. await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
  2329. {
  2330. schIot[school.id].htcDevTotalCnt = items;
  2331. }
  2332. ///設備統計-HiTA總設備數
  2333. 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')";
  2334. await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
  2335. {
  2336. schIot[school.id].htaDevTotalCnt = items;
  2337. }
  2338. schIot[school.id].tmidCnt = schIot[school.id].tmidList.Count; ///老師使用人次
  2339. schIot[school.id].htcDevCnt = schIot[school.id].htcDevList.Count; ///設備統計-HiTeach上線數
  2340. schIot[school.id].htaDevCnt = schIot[school.id].htaDevList.Count; ///設備統計-HiTA上線數
  2341. schIot[school.id].htccDevCnt = schIot[school.id].htccDevList.Count; ///設備統計-HiTeachCC上線數
  2342. }
  2343. //輸出整形
  2344. foreach (KeyValuePair<string, IotStatisticsSch> schIotItem in schIot)
  2345. {
  2346. IotStatisticsSch schIotData = schIotItem.Value;
  2347. //學校
  2348. schoolIotResult.Add(schIotData);
  2349. //學區
  2350. areaIot.sdate = (string.IsNullOrWhiteSpace(areaIot.sdate)) ? schIotData.sdate : (DateTime.Parse(schIotData.sdate, CultureInfo.InvariantCulture) < DateTime.Parse(areaIot.sdate, CultureInfo.InvariantCulture)) ? schIotData.sdate : areaIot.sdate;
  2351. areaIot.edate = (string.IsNullOrWhiteSpace(areaIot.edate)) ? schIotData.edate : (DateTime.Parse(schIotData.edate, CultureInfo.InvariantCulture) > DateTime.Parse(areaIot.edate, CultureInfo.InvariantCulture)) ? schIotData.edate : areaIot.edate;
  2352. areaIot.tmidList = areaIot.tmidList.Union(schIotData.tmidList).ToList();
  2353. areaIot.tmidCnt = areaIot.tmidList.Count;
  2354. areaIot.stuShow += schIotData.stuShow;
  2355. areaIot.stuLessonLengMin += schIotData.stuLessonLengMin;
  2356. areaIot.lessonRecord += schIotData.lessonRecord;
  2357. areaIot.lessonLengMin += schIotData.lessonLengMin;
  2358. areaIot.mission += schIotData.mission;
  2359. areaIot.missionFin += schIotData.missionFin;
  2360. areaIot.item += schIotData.item;
  2361. areaIot.interact += schIotData.interact;
  2362. areaIot.htcDevList = areaIot.htcDevList.Union(schIotData.htcDevList).ToList();
  2363. areaIot.htcDevCnt = areaIot.htcDevList.Count;
  2364. areaIot.htaDevList = areaIot.htaDevList.Union(schIotData.htaDevList).ToList();
  2365. areaIot.htaDevCnt = areaIot.htaDevList.Count;
  2366. areaIot.htccDevList = areaIot.htccDevList.Union(schIotData.htccDevList).ToList();
  2367. areaIot.htccDevCnt = areaIot.htccDevList.Count;
  2368. areaIot.lTypeCoop += schIotData.lTypeCoop;
  2369. areaIot.lTypeIact += schIotData.lTypeIact;
  2370. areaIot.lTypeMis += schIotData.lTypeMis;
  2371. areaIot.lTypeTst += schIotData.lTypeTst;
  2372. areaIot.lTypeDif += schIotData.lTypeDif;
  2373. }
  2374. return Ok(new { err, area = areaIot, school = schoolIotResult, iotData });
  2375. }
  2376. catch (Exception ex)
  2377. {
  2378. await _dingDing.SendBotMsg($"OS,{_option.Location},school/init/get-school-iot\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  2379. return BadRequest();
  2380. }
  2381. }
  2382. //新学年8.1号开学 ,第二学期开学2.17,设置提示区间60天
  2383. //2023-8-7 type = "studyYearStarted";新学年已经开始
  2384. //2023-10-7 type = "";不提示
  2385. //2024-1-20 type = "semesterEnding";本学期即将结束
  2386. //2024-3-20 type = "semesterStarted";新学期已经开始
  2387. //2024-4-20 type = "";不提示
  2388. //2024-7-20 type = "studyYearEnding";本学年即将结束
  2389. /// <
  2390. /// summary>
  2391. /// 检查当前学期的开学时间和学期结束时间
  2392. /// </summary>
  2393. /// <param name="json"></param>
  2394. /// <returns></returns>
  2395. [ProducesDefaultResponseType]
  2396. [HttpPost("check-semesters")]
  2397. #if !DEBUG
  2398. [AuthToken(Roles = "teacher,admin")]
  2399. [Authorize(Roles = "IES")]
  2400. #endif
  2401. public async Task<IActionResult> CheckSemesters(JsonElement json)
  2402. {
  2403. if (!json.TryGetProperty("schoolId", out JsonElement _schoolId)) { return BadRequest(); }
  2404. if (!json.TryGetProperty("periodId", out JsonElement _periodId)) { return BadRequest(); }
  2405. School school = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>(_schoolId.GetString(), new PartitionKey("Base"));
  2406. var period = school.period.Find(z => z.id.Equals(_periodId.GetString()));
  2407. if (period != null)
  2408. {
  2409. var semesterInfo = SchoolService.GetSemester(period, DateTimeOffset.Now.ToUnixTimeMilliseconds());
  2410. // var semesterInfo = SchoolService.GetSemester(period, time:$"{_time}");
  2411. var start = period.semesters.Where(z => z.start == 1).FirstOrDefault();
  2412. if (start != null)
  2413. {
  2414. var alreadySemester = semesterInfo.date.Subtract(semesterInfo.currSemesterDate);
  2415. var soonSemester = semesterInfo.nextSemester.Subtract(semesterInfo.date);
  2416. var semesterStarted = Math.Abs((int)alreadySemester.TotalDays);
  2417. var semesterEnding = Math.Abs((int)soonSemester.TotalDays);
  2418. string currStudyYear = $"{semesterInfo.studyYear}-{start.month}-{start.day}";
  2419. string nextStudyYear = $"{(semesterInfo.studyYear + 1)}-{start.month}-{start.day}";
  2420. DateTimeOffset.TryParse(currStudyYear, out DateTimeOffset currYear);
  2421. DateTimeOffset.TryParse(nextStudyYear, out DateTimeOffset nextYear);
  2422. var alreadyYear = semesterInfo.date.Subtract(currYear);
  2423. var soonYear = nextYear.Subtract(semesterInfo.date);
  2424. var studyYearStarted = Math.Abs((int)alreadyYear.TotalDays);
  2425. var studyYearEnding = Math.Abs((int)soonYear.TotalDays);
  2426. string type = string.Empty;
  2427. //开始天数小于60天
  2428. if (semesterStarted <= 60)
  2429. {
  2430. type = "semesterStarted";
  2431. }
  2432. //结束天数小于60天
  2433. if (semesterEnding <= 60)
  2434. {
  2435. type = "semesterEnding";
  2436. }
  2437. //开始天数小于60天
  2438. if (studyYearStarted <= 60)
  2439. {
  2440. type = "studyYearStarted";
  2441. }
  2442. //结束天数小于60天
  2443. if (studyYearEnding <= 60)
  2444. {
  2445. type = "studyYearEnding";
  2446. }
  2447. string key = $"SemesterStudyYearNotify:{_schoolId}:{semesterInfo.studyYear}:{semesterInfo.currSemester.id}:{type}";
  2448. var keyExists = await _azureRedis.GetRedisClient(8).KeyExistsAsync(key);
  2449. if (keyExists)
  2450. {
  2451. var data = await _azureRedis.GetRedisClient(8).StringGetAsync(key);
  2452. if (data.HasValue)
  2453. {
  2454. SemesterStudyYearNotify notify = data.ToString().ToObject<SemesterStudyYearNotify>();
  2455. if (notify.ignore == 1)
  2456. {
  2457. //忽略提示
  2458. type = "";
  2459. }
  2460. else
  2461. {
  2462. //已经处理过的不再处理
  2463. if (notify.process == 1)
  2464. {
  2465. type = "";
  2466. }
  2467. }
  2468. }
  2469. }
  2470. else
  2471. {
  2472. await _azureRedis.GetRedisClient(8).StringSetAsync(key, new SemesterStudyYearNotify { studyYear = semesterInfo.studyYear, semester = semesterInfo.currSemester.id, ignore = 0, type = type }.ToJsonString());
  2473. //60天 * 24 =1440小时
  2474. await _azureRedis.GetRedisClient(8).KeyExpireAsync(key, new TimeSpan(1440, 0, 0));
  2475. }
  2476. if (!string.IsNullOrWhiteSpace(type))
  2477. {
  2478. if (type.Contains("Ending", StringComparison.OrdinalIgnoreCase))
  2479. {
  2480. string sql = $"";
  2481. }
  2482. if (type.Contains("Started", StringComparison.OrdinalIgnoreCase))
  2483. {
  2484. }
  2485. }
  2486. return Ok(new { code = 1, studyYearStarted, studyYearEnding, semesterStarted, semesterEnding, type, key });
  2487. }
  2488. }
  2489. return Ok(new { code = -1, msg = "不需要提示" });
  2490. }
  2491. /// <summary>
  2492. /// 学校dashboard统计資料
  2493. /// </summary>
  2494. /// <param name="jsonElement"></param>
  2495. /// <returns></returns>
  2496. [ProducesDefaultResponseType]
  2497. [HttpPost("get-scstats")]
  2498. #if !DEBUG
  2499. [AuthToken(Roles = "teacher,admin")]
  2500. [Authorize(Roles = "IES")]
  2501. #endif
  2502. public async Task<IActionResult> GetSchoolStats(JsonElement jsonElement)
  2503. {
  2504. if (!jsonElement.TryGetProperty("schoolId", out JsonElement scId)) return BadRequest();
  2505. var cosmosClient = _azureCosmos.GetCosmosClient();
  2506. try
  2507. {
  2508. //0.學校基本資料取得
  2509. AnSchool school = new();
  2510. var respSc = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{scId}", new PartitionKey($"Base"));
  2511. if (respSc.Status == 200)
  2512. {
  2513. using var fileJson = await JsonDocument.ParseAsync(respSc.ContentStream);
  2514. school = fileJson.ToObject<AnSchool>();
  2515. }
  2516. else
  2517. return Ok(new { state = RespondCode.NotFound, msg = $"未找到id:{scId};相关的学校,请检查" });
  2518. //學校授權產品碼
  2519. var responseProduct = await cosmosClient.GetContainer("TEAMModelOS", "School").ReadItemStreamAsync(school.id, new PartitionKey("ProductSum"));
  2520. if (responseProduct.Status == 200)
  2521. {
  2522. using var json = await JsonDocument.ParseAsync(responseProduct.ContentStream);
  2523. if (json.RootElement.TryGetProperty("serial", out JsonElement _serial) && !_serial.ValueKind.Equals(JsonValueKind.Null))
  2524. {
  2525. school.serial = _serial.ToObject<List<SchoolProductSumData>>().Select(x => x.prodCode).ToList();
  2526. }
  2527. if (json.RootElement.TryGetProperty("service", out JsonElement _service) && !_service.ValueKind.Equals(JsonValueKind.Null))
  2528. {
  2529. school.service = _service.ToObject<List<SchoolProductSumData>>().Select(x => x.prodCode).ToList();
  2530. }
  2531. if (json.RootElement.TryGetProperty("hard", out JsonElement _hard) && !_hard.ValueKind.Equals(JsonValueKind.Null))
  2532. {
  2533. school.hard = _hard.ToObject<List<SchoolProductSumDataHard>>().Select(x => x.prodCode).ToList();
  2534. }
  2535. }
  2536. //回傳值定義
  2537. ScStats scStats = new();
  2538. List<LessonRecord> records = new();
  2539. //1.學校統計資料
  2540. StatsInfo statsInfo = null;
  2541. List<LastYearLessAndAct> lastYear = new();
  2542. var scDataStats = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Common").ReadItemStreamAsync($"{DateTimeOffset.UtcNow.Year}-{scId}", new PartitionKey("Statistics"));
  2543. if (scDataStats.Status == 200)
  2544. {
  2545. using var fileJson = await JsonDocument.ParseAsync(scDataStats.ContentStream);
  2546. statsInfo = fileJson.ToObject<StatsInfo>();
  2547. 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") }))
  2548. {
  2549. lastYear.Add(item);
  2550. }
  2551. }
  2552. else
  2553. {
  2554. scStats.id = $"{DateTimeOffset.UtcNow.Year}-{school.id}";
  2555. scStats.schoolId = school.id;
  2556. scStats.name = school.name;
  2557. scStats.picture = school.picture;
  2558. scStats.areaId = school.areaId;
  2559. }
  2560. DateTimeOffset dateTime = DateTimeOffset.UtcNow;
  2561. long now = dateTime.ToUnixTimeMilliseconds();
  2562. if (statsInfo != null)
  2563. {
  2564. scStats.id = statsInfo.id;
  2565. scStats.schoolId = statsInfo.schoolId;
  2566. scStats.name = statsInfo.name;
  2567. scStats.picture = statsInfo.picture;
  2568. scStats.areaId = statsInfo.areaId;
  2569. scStats.tch = statsInfo.tch;
  2570. scStats.dayTch = statsInfo.dayTch;
  2571. scStats.weekTch = statsInfo.weekTch;
  2572. scStats.monthTch = statsInfo.monthTch;
  2573. scStats.stu = statsInfo.stu;
  2574. scStats.dayStu = statsInfo.dayStu;
  2575. scStats.weekStu = statsInfo.weekStu;
  2576. scStats.monthStu = statsInfo.monthStu;
  2577. scStats.room = statsInfo.room;
  2578. scStats.witRoom = statsInfo.witRoom;
  2579. scStats.resourceCnt = statsInfo.resourceCnt;
  2580. scStats.size = statsInfo.size;
  2581. scStats.scCreateTime = statsInfo.scCreateTime;
  2582. scStats.upTime = statsInfo.upTime;
  2583. scStats.lessStats.all = statsInfo.lesson.all;
  2584. scStats.lessStats.open = statsInfo.lesson.open;
  2585. scStats.lessStats.less = statsInfo.lesson.less;
  2586. scStats.lessStats.lastDay = statsInfo.lesson.lastDay;
  2587. scStats.lessStats.day = statsInfo.lesson.day;
  2588. scStats.lessStats.lastWeek = statsInfo.lesson.lastWeek;
  2589. scStats.lessStats.week = statsInfo.lesson.week;
  2590. scStats.lessStats.lastTerm = statsInfo.lesson.lastTerm;
  2591. scStats.lessStats.term = statsInfo.lesson.term;
  2592. scStats.lessStats.month = statsInfo.lesson.month;
  2593. scStats.lessStats.lastMonth = statsInfo.lesson.lastMonth;
  2594. scStats.lessStats.lastDayInter = statsInfo.lesson.lastDayInter;
  2595. scStats.lessStats.dayInter = statsInfo.lesson.dayInter;
  2596. scStats.lessStats.lastMonthInter = statsInfo.lesson.lastMonthInter;
  2597. scStats.lessStats.monthInter = statsInfo.lesson.monthInter;
  2598. scStats.lessStats.lastYear = ((int)BICommonWay.ManyDoubleMerge(lastYear.Select(s => s.lesson.year).Where(w => w.Count > 0).ToList()).Sum());
  2599. scStats.lessStats.lastYearInter = statsInfo.lesson.lastYearInter;
  2600. scStats.lessStats.yearInter = statsInfo.lesson.yearInter;
  2601. scStats.lessStats.yearInters = TimeHelper.GetYearMonth(statsInfo.lesson.yearInters, dateTime.Year, dateTime.Month);
  2602. scStats.lessStats.year = TimeHelper.GetYearMonth(statsInfo.lesson.year, dateTime.Year, dateTime.Month);
  2603. scStats.actStats.all = statsInfo.activity.all;
  2604. scStats.actStats.exam = statsInfo.activity.exam;
  2605. scStats.actStats.survey = statsInfo.activity.survey;
  2606. scStats.actStats.vote = statsInfo.activity.vote;
  2607. scStats.actStats.homework = statsInfo.activity.homework;
  2608. scStats.actStats.lastDay = statsInfo.activity.lastDay;
  2609. scStats.actStats.dayCnt = statsInfo.activity.dayCnt;
  2610. scStats.actStats.lastWeek = statsInfo.activity.lastWeek;
  2611. scStats.actStats.week = statsInfo.activity.week;
  2612. scStats.actStats.lastTerm = statsInfo.activity.lastTerm;
  2613. scStats.actStats.term = statsInfo.activity.term;
  2614. scStats.actStats.lastMonth = statsInfo.activity.lastMonth;
  2615. scStats.actStats.month = statsInfo.activity.month;
  2616. scStats.actStats.lastYear = ((int)BICommonWay.ManyDoubleMerge(lastYear.Select(s => s.activity.year).Where(w => w.Count > 0).ToList()).Sum());
  2617. scStats.actStats.year = TimeHelper.GetYearMonth(statsInfo.activity.year, dateTime.Year, dateTime.Month);
  2618. if (statsInfo.study != null)
  2619. {
  2620. scStats.srStats.learnTime = statsInfo.study.learnTime;
  2621. scStats.srStats.online = statsInfo.study.online;
  2622. scStats.srStats.offline = statsInfo.study.offline;
  2623. scStats.srStats.classRoom = statsInfo.study.classRoom;
  2624. scStats.srStats.submit = statsInfo.study.submit;
  2625. scStats.srStats.notStarted = statsInfo.study.notStarted;
  2626. scStats.srStats.ongoing = statsInfo.study.ongoing;
  2627. scStats.srStats.finish = statsInfo.study.finish;
  2628. }
  2629. }
  2630. //2.課堂紀錄相關
  2631. var (dayS, dayE) = TimeHelper.GetStartOrEnd(dateTime); //今天开始时间
  2632. var (weekS, weekE) = TimeHelper.GetStartOrEnd(dateTime, "week"); //计算本周开始/结束时间
  2633. var (monthS, monthE) = TimeHelper.GetStartOrEnd(dateTime, "month"); //本月开始/结束时间
  2634. var (yearS, yearE) = TimeHelper.GetStartOrEnd(dateTime, "year"); //本年开始/结束时间
  2635. 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}") }))
  2636. {
  2637. records.Add(item);
  2638. }
  2639. //試題數
  2640. double itemCount = 0;
  2641. 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}") }))
  2642. {
  2643. using var json = await JsonDocument.ParseAsync(item.ContentStream);
  2644. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  2645. {
  2646. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  2647. {
  2648. if (obj.TryGetProperty("items", out JsonElement items))
  2649. {
  2650. itemCount = items.GetDouble();
  2651. }
  2652. }
  2653. }
  2654. }
  2655. //試卷數
  2656. double paperCount = 0;
  2657. 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}") }))
  2658. {
  2659. using var json = await JsonDocument.ParseAsync(item.ContentStream);
  2660. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  2661. {
  2662. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  2663. {
  2664. if (obj.TryGetProperty("papers", out JsonElement papers))
  2665. {
  2666. paperCount = papers.GetDouble();
  2667. }
  2668. }
  2669. }
  2670. }
  2671. //課堂紀錄資料
  2672. double resourcesCount = itemCount + paperCount; //线上资源
  2673. double attendCount = records.Select(c => c.attendCount).Sum(); //学生参加人数
  2674. double clientInteractionCount = records.Select(c => c.clientInteractionCount).Sum(); //互动总次数
  2675. double workCount = records.Select(c => c.collateCount).Sum();//课堂任务总次数
  2676. double interactionCount = records.Select(c => c.interactionCount).Sum(); //课堂提问中题数
  2677. double duration = records.Select(c => c.duration).Sum(); //课堂总时长
  2678. double dayCnt = records.Where(c => c.startTime >= dayS && c.startTime <= dayE).Count(); //今天课例数
  2679. double weekCnt = records.Where(c => c.startTime >= weekS && c.startTime <= weekE).Count(); //本周课例数
  2680. double monthCnt = records.Where(c => c.startTime >= monthS && c.startTime <= monthE).Count(); //本月课例数
  2681. double yearCnt = records.Where(c => c.startTime >= yearS && c.startTime <= yearE).Count(); //本年课例数
  2682. //各年級課例數、各科目課例數
  2683. List<(string name, string periodId, int count)> grades = LessonStatisWay.GetGradeCount(records); //取得各年级统计课例
  2684. var subs = records.GroupBy(x => x.subjectId).Where(y => !string.IsNullOrEmpty(y.Key)).Select(y => new { key = y.Key, count = y.ToList().Count }).ToList();
  2685. var gradeCnt = grades.Select(x => new { x.name, x.periodId, value = x.count }); //各年級課例數
  2686. var subCnt = subs.Select(x => new { name = x.key, value = x.count }); //科目課例數
  2687. object lessonStats = new { cnt = records.Count, dayCnt, weekCnt, monthCnt, yearCnt, resourcesCount, attendCount, clientInteractionCount, workCount, interactionCount, duration, gradeCnt, subCnt };
  2688. return Ok(new { state = RespondCode.Ok, school, scStats, lessonStats });
  2689. }
  2690. catch (Exception ex)
  2691. {
  2692. await _dingDing.SendBotMsg($"IES5,{_option.Location} /school/get-scstats() \n {ex.Message}\n{ex.StackTrace}", GroupNames.成都开发測試群組);
  2693. return BadRequest();
  2694. }
  2695. }
  2696. //取得序號產品准許使用產品代碼列表
  2697. public static List<string> getSerialPermitProdcodeList()
  2698. {
  2699. List<string> allowProdCode = new List<string>(); //軟體許可產品列:HiTeach STD、TBL、PRO、HiTeach5;
  2700. allowProdCode.Add("J223IZ6M"); //HiTeach STD
  2701. allowProdCode.Add("3222C6D2"); //HiTeach TBL
  2702. allowProdCode.Add("J223IZAM"); //HiTeach PRO
  2703. allowProdCode.Add("J2236ZCX"); //HiTeach Lite
  2704. allowProdCode.Add("3222DNG2"); //HiTeach Mobile
  2705. allowProdCode.Add("3222IAVN"); //HiTeach Premium
  2706. allowProdCode.Add("BYJ6LZ6Z"); //HiTeach5
  2707. allowProdCode.Add("LZLL6ZEI"); //HiTeachCC
  2708. return allowProdCode;
  2709. }
  2710. }
  2711. public class SemesterStudyYearNotify
  2712. {
  2713. /// <summary>
  2714. /// 当前学年
  2715. /// </summary>
  2716. public int studyYear { get; set; }
  2717. /// <summary>
  2718. /// 当前学期
  2719. /// </summary>
  2720. public string semester { get; set; }
  2721. /// <summary>
  2722. /// 是否选择忽略 0未忽略,1 已经忽略
  2723. /// </summary>
  2724. public int ignore { get; set; } = 0;
  2725. /// <summary>
  2726. /// 提示类型
  2727. /// </summary>
  2728. public string type { get; set; }
  2729. /// <summary>
  2730. /// 是否已经处理 0未处理,1已处理
  2731. /// </summary>
  2732. public int process { get; set; }
  2733. /// <summary>
  2734. /// 学年已经开始多少天
  2735. /// </summary>
  2736. public int studyYearStarted { get; set; }
  2737. /// <summary>
  2738. /// 学年即将结束
  2739. /// </summary>
  2740. public int studyYearEnding { get; set; }
  2741. /// <summary>
  2742. /// 学期已经开始多少天
  2743. /// </summary>
  2744. public int semesterStarted { get; set; }
  2745. /// <summary>
  2746. /// 学期即将结束
  2747. /// </summary>
  2748. public int semesterEnding { get; set; }
  2749. }
  2750. }