SchoolController.cs 143 KB

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