SchoolController.cs 101 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800
  1. using Microsoft.AspNetCore.Mvc;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. using TEAMModelOS.Models;
  7. using TEAMModelOS.SDK;
  8. using TEAMModelOS.SDK.DI;
  9. using System.Text.Json;
  10. using TEAMModelOS.SDK.Models;
  11. using TEAMModelOS.SDK.Extension;
  12. using Azure.Cosmos;
  13. using Microsoft.AspNetCore.Http;
  14. using Microsoft.Extensions.Options;
  15. using System.IO;
  16. using System.Dynamic;
  17. using System.Net.Http;
  18. using System.Net;
  19. using Newtonsoft.Json;
  20. using System.Linq;
  21. using StackExchange.Redis;
  22. using Microsoft.Extensions.Configuration;
  23. using TEAMModelOS.Filter;
  24. using Microsoft.AspNetCore.Authorization;
  25. using System.Net.Http.Headers;
  26. using System.Net.Http.Json;
  27. using HTEXLib.COMM.Helpers;
  28. using System.IdentityModel.Tokens.Jwt;
  29. using TEAMModelOS.SDK.DI.CoreAPI;
  30. namespace TEAMModelOS.Controllers
  31. {
  32. [ProducesResponseType(StatusCodes.Status200OK)]
  33. [ProducesResponseType(StatusCodes.Status400BadRequest)]
  34. [Route("school/init")]
  35. [ApiController]
  36. public class SchoolController : ControllerBase
  37. {
  38. public AzureCosmosFactory _azureCosmos;
  39. private readonly AzureStorageFactory _azureStorage;
  40. private readonly AzureRedisFactory _azureRedis;
  41. private readonly DingDing _dingDing;
  42. private readonly Option _option;
  43. int baseSpaceSize = 10; //學校保底空間大小(1G)
  44. private readonly double bytes = 1073741824;
  45. private readonly int redisAclassoneDbNum = 8; //AclassOne Redis DB號
  46. private readonly IConfiguration _configuration;
  47. private readonly CoreAPIHttpService _coreAPIHttpService;
  48. private readonly NotificationService _notificationService;
  49. private readonly HttpClient _httpClient;
  50. private readonly HttpTrigger _httpTrigger;
  51. public SchoolController(HttpTrigger httpTrigger,CoreAPIHttpService coreAPIHttpService, NotificationService notificationService, AzureCosmosFactory azureCosmos, AzureStorageFactory azureStorage, AzureRedisFactory azureRedis, DingDing dingDing, IOptionsSnapshot<Option> option, IConfiguration configuration, HttpClient httpClient)
  52. {
  53. _azureCosmos = azureCosmos;
  54. _azureStorage = azureStorage;
  55. _azureRedis = azureRedis;
  56. _dingDing = dingDing;
  57. _option = option?.Value;
  58. _configuration = configuration;
  59. _coreAPIHttpService = coreAPIHttpService;
  60. _notificationService = notificationService;
  61. _httpClient = httpClient;
  62. _httpTrigger = httpTrigger;
  63. }
  64. /// <summary>
  65. /// 修改学校信息
  66. /// </summary>
  67. /// <param name="request"></param>
  68. /// <returns></returns>
  69. [ProducesDefaultResponseType]
  70. [HttpPost("set-school-info")]
  71. [Authorize(Roles = "IES")]
  72. [AuthToken(Roles = "admin", Permissions = "train-appraise")]
  73. public async Task<IActionResult> SetTeacherInfo(JsonElement request)
  74. {
  75. var client = _azureCosmos.GetCosmosClient();
  76. if (!request.TryGetProperty("opt", out JsonElement _opt))
  77. {
  78. return BadRequest();
  79. }
  80. var (userid, name, _, school) = HttpContext.GetAuthTokenInfo();
  81. try
  82. {
  83. SchoolTeacher teacher = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>(userid, new PartitionKey($"Teacher-{school}"));
  84. switch (true)
  85. {
  86. //修改互评开关
  87. case bool when $"{_opt}".Equals("modify-hpappraise", StringComparison.OrdinalIgnoreCase):
  88. int hpappraise = -1;
  89. if (request.TryGetProperty("hpappraise", out JsonElement _hpappraise))
  90. {
  91. int.TryParse($"{_hpappraise}", out hpappraise);
  92. }
  93. if (hpappraise != -1)
  94. {
  95. School schoolData = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>(school, new PartitionKey("Base"));
  96. schoolData.hpappraise = hpappraise;
  97. await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(schoolData, school, new PartitionKey("Base"));
  98. return Ok(new { status = 200 });
  99. }
  100. else
  101. {
  102. return Ok(new { error = 1, msg = "参数异常!" });
  103. }
  104. default:
  105. return Ok(new { error = 1, msg = "参数异常!" });
  106. }
  107. }
  108. catch (Exception ex)
  109. {
  110. await _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/init/set-teacher-info()\n{ex.Message}\n{ex.StackTrace}{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  111. return Ok(new { error = 1, msg = "参数异常!" });
  112. }
  113. }
  114. /// <summary>
  115. /// 保存或更新学校
  116. /// </summary>
  117. /// <param name="request"></param>
  118. /// <returns></returns>
  119. [ProducesDefaultResponseType]
  120. //[AuthToken(Roles = "admin")]
  121. [HttpPost("upsert")]
  122. [Authorize(Roles = "IES")]
  123. public async Task<IActionResult> Upsert(School school)
  124. {
  125. var (_, _, _, _school) = HttpContext.GetAuthTokenInfo();
  126. try
  127. {
  128. School schoolInfo = new ();
  129. var client = _azureCosmos.GetCosmosClient();
  130. var schoolContainer = client.GetContainer(Constant.TEAMModelOS, "School");
  131. var response = await schoolContainer.ReadItemStreamAsync(school.id, new PartitionKey($"Base"));
  132. if (response.Status == 200)
  133. {
  134. School db_school = JsonDocument.Parse(response.Content).RootElement.Deserialize<School>();
  135. //计算 比较更改前后 学段的年级变化的学段,并重新处理行政班的毕业状态。
  136. //变更后
  137. List<KeyValuePair<string, int>> period_gradeCount = new List<KeyValuePair<string, int>>();
  138. school.period.ForEach(z => { period_gradeCount.Add(new KeyValuePair<string, int>(z.id, z.grades.Count)); });
  139. //变更前
  140. List<KeyValuePair<string, int>> dbperiod_gradeCount = new List<KeyValuePair<string, int>>();
  141. db_school.period.ForEach(z => { dbperiod_gradeCount.Add(new KeyValuePair<string, int>(z.id, z.grades.Count)); });
  142. List<string> periodIds = new List<string>();
  143. period_gradeCount.ForEach(x => {
  144. var gradeCount = dbperiod_gradeCount.Find(y => x.Key.Equals(y.Key));
  145. if (!string.IsNullOrWhiteSpace(gradeCount.Key)) {
  146. if (gradeCount.Value != x.Value) {
  147. periodIds.Add(x.Key);
  148. }
  149. }
  150. });
  151. await SchoolService.DoGraduateClasses(_httpTrigger, _azureCosmos, periodIds, school, _option);
  152. //变更教师关联的学校基本信息
  153. string sql = $"SELECT distinct value(c) FROM c join A1 in c.schools where A1.schoolId='{school.id}'";
  154. List<Teacher> teachers = new List<Teacher>();
  155. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIterator<Teacher>(sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey("Base") }))
  156. {
  157. teachers.Add(item);
  158. }
  159. foreach (var item in teachers)
  160. {
  161. Teacher.TeacherSchool teacherSchool = item.schools.Find(x => x.schoolId.Equals(school.id));
  162. if (teacherSchool != null)
  163. {
  164. teacherSchool.name = school.name;
  165. teacherSchool.picture = school.picture;
  166. teacherSchool.areaId = school.areaId;
  167. }
  168. await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync(item, item.id, new PartitionKey($"Base"));
  169. }
  170. schoolInfo = await schoolContainer.UpsertItemAsync(school, new PartitionKey($"Base"));
  171. }
  172. else
  173. {
  174. school.code = "Base";
  175. schoolInfo = await schoolContainer.CreateItemAsync(school, new PartitionKey($"Base"));
  176. }
  177. return Ok(new { schoolInfo });
  178. }
  179. catch (Exception ex)
  180. {
  181. await _dingDing.SendBotMsg($"CoreAPI2,{_option.Location},school/upsert()\n{ex.Message}\n{ex.StackTrace}\n", GroupNames.醍摩豆服務運維群組);
  182. return BadRequest();
  183. }
  184. }
  185. /// <summary>
  186. /// 查找学校
  187. /// </summary>
  188. /// <param name="request"></param>
  189. /// <returns></returns>
  190. [ProducesDefaultResponseType]
  191. //[AuthToken(Roles = "teacher")]
  192. [HttpPost("find")]
  193. [Authorize(Roles = "IES")]
  194. public async Task<IActionResult> Find(JsonElement request)
  195. {
  196. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  197. var client = _azureCosmos.GetCosmosClient();
  198. List<School> schools = new ();
  199. 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}'";
  200. await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
  201. {
  202. using var json = await JsonDocument.ParseAsync(item.ContentStream);
  203. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  204. {
  205. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  206. {
  207. schools.Add(obj.ToObject<School>());
  208. }
  209. }
  210. }
  211. return Ok(new { schools });
  212. /* ResponseBuilder builder = ResponseBuilder.custom();
  213. if (request.TryGetProperty("code", out JsonElement code) &&! string.IsNullOrEmpty(code.ToString()))
  214. {
  215. List<School> sc = await _azureCosmos.FindByDict<School>(request);
  216. return builder.Data(sc).build();
  217. }
  218. else {
  219. return builder.Data(null).build();
  220. }*/
  221. }
  222. /// <summary>
  223. /// 取得所有學校(只取基本資料)
  224. /// </summary>
  225. /// <param name="request"></param>
  226. /// <returns></returns>
  227. [ProducesDefaultResponseType]
  228. [HttpPost("get-all-school-base")]
  229. public async Task<IActionResult> GetAllSchoolBaesInfo(JsonElement request)
  230. {
  231. var client = _azureCosmos.GetCosmosClient();
  232. List<object> schools = new ();
  233. 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") }))
  234. {
  235. using var json = await JsonDocument.ParseAsync(item.ContentStream);
  236. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  237. {
  238. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  239. {
  240. schools.Add(obj.ToObject<object>());
  241. }
  242. }
  243. }
  244. return Ok(new { schools });
  245. }
  246. /// <summary>
  247. /// 取得某學校基本資料
  248. /// </summary>
  249. /// <param name="request"></param>
  250. /// <returns></returns>
  251. [ProducesDefaultResponseType]
  252. [HttpPost("get-school-base")]
  253. public async Task<IActionResult> GetSchoolBaesInfo(JsonElement request)
  254. {
  255. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  256. var client = _azureCosmos.GetCosmosClient();
  257. var schoolContainer = client.GetContainer(Constant.TEAMModelOS, "School");
  258. //取得學校學制、年級、教室
  259. List<object> classes = new List<object>();
  260. 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}") }))
  261. {
  262. var jsonc = await JsonDocument.ParseAsync(item.ContentStream);
  263. foreach (var classeinfo in jsonc.RootElement.GetProperty("Documents").EnumerateArray())
  264. {
  265. dynamic classExtobj = new ExpandoObject();
  266. classExtobj.id = classeinfo.GetProperty("id");
  267. classExtobj.name = classeinfo.GetProperty("name");
  268. classExtobj.gradeId = classeinfo.GetProperty("gradeId");
  269. classes.Add(classExtobj);
  270. }
  271. }
  272. List<object> periods = new List<object>();
  273. List<object> grades = new List<object>();
  274. var responsesch = await schoolContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey($"Base"));
  275. if (responsesch.Status == 200)
  276. {
  277. var jsons = await JsonDocument.ParseAsync(responsesch.ContentStream);
  278. if (jsons.RootElement.TryGetProperty("period", out JsonElement periodJobj))
  279. {
  280. foreach (var periodinfo in periodJobj.EnumerateArray())
  281. {
  282. dynamic periodExtobj = new ExpandoObject();
  283. periodExtobj.id = periodinfo.GetProperty("id");
  284. periodExtobj.name = periodinfo.GetProperty("name");
  285. periods.Add(periodExtobj);
  286. if (periodinfo.TryGetProperty("grades", out JsonElement gradesJobj))
  287. {
  288. foreach (var gradeinfo in gradesJobj.EnumerateArray())
  289. {
  290. dynamic gradeExtobj = new ExpandoObject();
  291. gradeExtobj.id = gradeinfo.GetProperty("id");
  292. gradeExtobj.name = gradeinfo.GetProperty("name");
  293. gradeExtobj.periodId = periodinfo.GetProperty("id");
  294. grades.Add(gradeExtobj);
  295. }
  296. }
  297. }
  298. }
  299. }
  300. return Ok(new { periods, grades, classes });
  301. }
  302. /// <summary>
  303. /// 取得某學校產品購買紀錄
  304. /// </summary>
  305. /// <param name="request"></param>
  306. /// <returns></returns>
  307. [ProducesDefaultResponseType]
  308. [HttpPost("get-school-product")]
  309. //[AuthToken(Roles = "admin,teacher")]
  310. //[Authorize(Roles = "IES")]
  311. public async Task<IActionResult> GetSchoolProductInfo(JsonElement request)
  312. {
  313. try
  314. {
  315. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  316. var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
  317. var r8 = _azureRedis.GetRedisClient(8);
  318. List<SchoolProductSerial> serial = new (); //承接DB資料用:序號
  319. List<SerialInfoBaseWithdeviceBoundExt> serialResult = new (); //最後要輸出的序號結果
  320. List<SchoolProductService> serviceProduct = new (); //承接DB資料用:服務
  321. List<SchoolProductOrder> serviceOrder = new(); //服務各產品購買紀錄
  322. List<SchoolProductSumDataService> serviceSum = new (); //服務各產品購買紀錄
  323. List<SchoolProductHard> hard = new (); //承接DB資料用:硬體
  324. SchoolProductSum productSum = new (); //承接DB資料用:產品目前狀態
  325. List<SchoolProductSumProdInfo> prodinfo = new (); //產品資訊列表(名稱、八碼)
  326. List<deviceForCoreService> uuidList = new (); //要向CoreService詢問deviceID及硬體資訊的UUID列表
  327. long UTCNow = DateTimeOffset.UtcNow.ToUnixTimeSeconds();
  328. ////取得各產品目前可得數量
  329. var response = await db.ReadItemStreamAsync(school_code.ToString(), new PartitionKey($"ProductSum"));
  330. if (response.Status == 200)
  331. {
  332. using var json = await JsonDocument.ParseAsync(response.ContentStream);
  333. productSum = json.ToObject<SchoolProductSum>();
  334. prodinfo = productSum.prodinfo;
  335. serviceSum = productSum.service;
  336. }
  337. //軟體
  338. await foreach (var itemsr in db.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.dataType = 'serial'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
  339. {
  340. using var json = await JsonDocument.ParseAsync(itemsr.ContentStream);
  341. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  342. {
  343. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  344. {
  345. serial.Add(obj.ToObject<SchoolProductSerial>());
  346. if (obj.TryGetProperty("deviceBound", out JsonElement deviceBoundJobj) && !string.IsNullOrWhiteSpace(deviceBoundJobj.ToString()))
  347. {
  348. foreach (var deviceBoundRow in deviceBoundJobj.EnumerateArray())
  349. {
  350. deviceForCoreService uuidForCore = new deviceForCoreService();
  351. uuidForCore.sn = (!string.IsNullOrWhiteSpace(Convert.ToString(obj.GetProperty("serial")))) ? Convert.ToString(obj.GetProperty("serial")) : null;
  352. uuidForCore.uuid1 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundRow.GetProperty("uuid")))) ? Convert.ToString(deviceBoundRow.GetProperty("uuid")) : null;
  353. uuidForCore.uuid2 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundRow.GetProperty("uuid2")))) ? Convert.ToString(deviceBoundRow.GetProperty("uuid2")) : null;
  354. uuidForCore.device_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundRow.GetProperty("deviceId")))) ? Convert.ToString(deviceBoundRow.GetProperty("deviceId")) : null;
  355. uuidForCore.class_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundRow.GetProperty("classId")))) ? Convert.ToString(deviceBoundRow.GetProperty("classId")) : null;
  356. uuidList.Add(uuidForCore);
  357. }
  358. }
  359. }
  360. }
  361. }
  362. ////取得DeviceInfo From Core 並更新序號資料
  363. List<deviceFromCoreService> coreUuidList = (List<deviceFromCoreService>)GetDeviceFromCoreAsync(uuidList).GetAwaiter().GetResult();
  364. foreach (SchoolProductSerial serialRow in serial)
  365. {
  366. var deviceBoundArray = new List<deviceBoundExt>();
  367. List<deviceFromCoreService> coreUuid = coreUuidList
  368. .Where((deviceFromCoreService x) => x.sn == serialRow.serial)
  369. .ToList();
  370. foreach (deviceFromCoreService deviceRow in coreUuid)
  371. {
  372. if (!string.IsNullOrWhiteSpace(deviceRow.uuid1) || !string.IsNullOrWhiteSpace(deviceRow.uuid2) || !string.IsNullOrWhiteSpace(deviceRow.device_id)) //uuid1、uuid2、device_id 任一欄有值
  373. {
  374. //前端顯示用
  375. deviceForCoreService deviceBoundRow = uuidList.Where(u => u.sn == deviceRow.sn && u.uuid1 == deviceRow.uuid1 && u.uuid2 == deviceRow.uuid2).FirstOrDefault();
  376. deviceBoundExt deviceBoundExt = new deviceBoundExt();
  377. deviceBoundExt.uuid = deviceBoundRow.uuid1;
  378. deviceBoundExt.uuid2 = deviceBoundRow.uuid2;
  379. deviceBoundExt.classId = deviceBoundRow.class_id;
  380. deviceBoundExt.deviceId = deviceRow.device_id;
  381. deviceBoundExt.os = deviceRow.os;
  382. deviceBoundExt.ip = deviceRow.local_ip;
  383. deviceBoundExt.cpu = deviceRow.cpu;
  384. deviceBoundExt.pcname = deviceRow.pc_name;
  385. deviceBoundExt.osver = deviceRow.os_ver;
  386. deviceBoundArray.Add(deviceBoundExt);
  387. //DB更新用
  388. deviceBound serialDeviceBoundRow = serialRow.deviceBound.Where(d => (d.uuid == deviceBoundRow.uuid1 && d.uuid2 == deviceBoundRow.uuid2) || (d.uuid == deviceBoundRow.uuid2 && d.uuid2 == deviceBoundRow.uuid1)).FirstOrDefault();
  389. if (serialDeviceBoundRow != null)
  390. {
  391. serialDeviceBoundRow.deviceId = deviceRow.device_id;
  392. }
  393. }
  394. }
  395. if (deviceBoundArray.Count.Equals(0)) //無法取得CS的硬體資訊,則用序號的硬體資訊帶入
  396. {
  397. if (serialRow.deviceBound != null)
  398. {
  399. foreach (deviceBound serialRowDeviceBound in serialRow.deviceBound)
  400. {
  401. if (!string.IsNullOrEmpty(serialRowDeviceBound.uuid) || !string.IsNullOrEmpty(serialRowDeviceBound.uuid2))
  402. {
  403. deviceBoundExt deviceBoundExt = new deviceBoundExt();
  404. deviceBoundExt.uuid = serialRowDeviceBound.uuid;
  405. deviceBoundExt.uuid2 = serialRowDeviceBound.uuid2;
  406. deviceBoundExt.classId = serialRowDeviceBound.classId;
  407. deviceBoundExt.deviceId = serialRowDeviceBound.deviceId;
  408. deviceBoundArray.Add(deviceBoundExt);
  409. }
  410. }
  411. }
  412. }
  413. //序號更新
  414. await db.ReplaceItemAsync<SchoolProductSerial>(serialRow, serialRow.id, new PartitionKey($"Product-{school_code}"));
  415. //回傳值
  416. SerialInfoBaseWithdeviceBoundExt serialResultRow = new SerialInfoBaseWithdeviceBoundExt();
  417. serialResultRow.code = serialRow.code;
  418. serialResultRow.id = serialRow.id;
  419. serialResultRow.dataType = serialRow.dataType;
  420. serialResultRow.serial = serialRow.serial;
  421. serialResultRow.prodCode = serialRow.prodCode;
  422. serialResultRow.clientQty = serialRow.clientQty;
  423. serialResultRow.orderDate = serialRow.orderDate;
  424. serialResultRow.regDate = serialRow.regDate;
  425. serialResultRow.startDate = serialRow.startDate;
  426. serialResultRow.endDate = serialRow.endDate;
  427. serialResultRow.deviceMax = serialRow.deviceMax;
  428. serialResultRow.expireStatus = serialRow.expireStatus;
  429. serialResultRow.status = serialRow.status;
  430. serialResultRow.deviceBound = deviceBoundArray;
  431. if (serialRow.aprule != null)
  432. {
  433. string apruleJsonString = serialRow.aprule.ToJsonString();
  434. var apruleDc = JsonDocument.Parse(apruleJsonString);
  435. serialResultRow.aprule = (apruleDc.RootElement.TryGetProperty("json", out JsonElement apruleJson)) ? apruleJson : null;
  436. }
  437. else serialResultRow.aprule = null;
  438. serialResult.Add(serialResultRow);
  439. }
  440. //服務
  441. List<SchoolProductSumDataService> service = new List<SchoolProductSumDataService>();
  442. await foreach (var items in db.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.id = '{school_code}'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProductSum") }))
  443. {
  444. using var json = await JsonDocument.ParseAsync(items.ContentStream);
  445. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  446. {
  447. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  448. {
  449. SchoolProductSum schoolProductSum = obj.ToObject<SchoolProductSum>();
  450. service = schoolProductSum.service;
  451. }
  452. }
  453. }
  454. if (service.Count > 0)
  455. {
  456. foreach (SchoolProductSumDataService serviceRow in service)
  457. {
  458. SchoolProductOrder spOrderRow = new SchoolProductOrder();
  459. spOrderRow.prodCode = serviceRow.prodCode;
  460. spOrderRow.avaliable = serviceRow.avaliable;
  461. spOrderRow.avaliableStartDate = serviceRow.startDate;
  462. spOrderRow.avaliableEndDate = serviceRow.endDate;
  463. serviceOrder.Add(spOrderRow);
  464. }
  465. }
  466. #region 產品購買履歷廢除部分
  467. ////(服務)取得各產品購買履歷
  468. //await foreach (var itemsv in clientContainer.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.dataType = 'service'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
  469. //{
  470. // using var json = await JsonDocument.ParseAsync(itemsv.ContentStream);
  471. // if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  472. // {
  473. // foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  474. // {
  475. // SchoolProductService serviceProductRow = obj.ToObject<SchoolProductService>();
  476. // serviceProduct.Add(serviceProductRow);
  477. // }
  478. // }
  479. //}
  480. ////(服務)產品購買履歷整形
  481. //IEnumerable<SchoolProductService> serviceProductOrder = serviceProduct.OrderBy(sp => sp.startDate);
  482. //foreach (SchoolProductService serviceProductRow in serviceProduct)
  483. //{
  484. // //取得此產品現在可用數
  485. // SchoolProductSumDataService serviceSumNow = serviceSum.Where(ss => ss.prodCode.Equals(serviceProductRow.prodCode)).FirstOrDefault();
  486. // int serviceAvaliableNow = (serviceSumNow != null) ? serviceSumNow.avaliable : 0;
  487. // long serviceAvaliableStartDate = (serviceSumNow != null) ? serviceSumNow.startDate : 0;
  488. // long serviceAvaliableEndDate = (serviceSumNow != null) ? serviceSumNow.endDate : 0;
  489. // //取得此產品購買履歷
  490. // SchoolProductOrder serviceOrderNow = serviceOrder.Where(so => so.prodCode == serviceProductRow.prodCode).FirstOrDefault();
  491. // if (serviceOrderNow == null) //無此產品項
  492. // {
  493. // SchoolProductOrder serviceOrderRow = new SchoolProductOrder();
  494. // serviceOrderRow.prodCode = serviceProductRow.prodCode;
  495. // serviceOrderRow.order = new List<SchoolProductOrderList>();
  496. // SchoolProductOrderList serviceOrderRowOrderList = new SchoolProductOrderList();
  497. // serviceOrderRowOrderList.id = serviceProductRow.id;
  498. // serviceOrderRowOrderList.orderDate = serviceProductRow.orderDate;
  499. // serviceOrderRowOrderList.startDate = serviceProductRow.startDate;
  500. // serviceOrderRowOrderList.endDate = serviceProductRow.endDate;
  501. // serviceOrderRowOrderList.number = serviceProductRow.number;
  502. // serviceOrderRowOrderList.unit = serviceProductRow.unit;
  503. // serviceOrderRow.order.Add(serviceOrderRowOrderList);
  504. // serviceOrderRow.avaliable = serviceAvaliableNow;
  505. // serviceOrderRow.avaliableStartDate = serviceAvaliableStartDate;
  506. // serviceOrderRow.avaliableEndDate = serviceAvaliableEndDate;
  507. // serviceOrder.Add(serviceOrderRow);
  508. // }
  509. // else //有此產品項 => 看是否有此購買紀錄
  510. // {
  511. // //記入可用起始終止日
  512. // serviceOrderNow.avaliableStartDate = serviceAvaliableStartDate;
  513. // serviceOrderNow.avaliableEndDate = serviceAvaliableEndDate;
  514. // //記入購買紀錄
  515. // SchoolProductOrderList SchoolProductOrderListNow = serviceOrderNow.order.Where(Sol => Sol.id.Equals(serviceProductRow.id)).FirstOrDefault();
  516. // if (SchoolProductOrderListNow == null) //無此購買紀錄
  517. // {
  518. // SchoolProductOrderList serviceOrderRowOrderList = new SchoolProductOrderList();
  519. // serviceOrderRowOrderList.id = serviceProductRow.id;
  520. // serviceOrderRowOrderList.orderDate = serviceProductRow.orderDate;
  521. // serviceOrderRowOrderList.startDate = serviceProductRow.startDate;
  522. // serviceOrderRowOrderList.endDate = serviceProductRow.endDate;
  523. // serviceOrderRowOrderList.number = serviceProductRow.number;
  524. // serviceOrderRowOrderList.unit = serviceProductRow.unit;
  525. // serviceOrderNow.order.Add(serviceOrderRowOrderList);
  526. // }
  527. // }
  528. //}
  529. #endregion
  530. //硬體
  531. await foreach (var itemhd in db.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.dataType = 'hard'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
  532. {
  533. using var json = await JsonDocument.ParseAsync(itemhd.ContentStream);
  534. if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  535. {
  536. foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
  537. {
  538. hard.Add(obj.ToObject<SchoolProductHard>());
  539. }
  540. }
  541. }
  542. //空間計算
  543. ////取得教師分配空間
  544. long teach = 0;
  545. var querysp = $"SELECT SUM(c.size) as size FROM c";
  546. await foreach (var item in db.GetItemQueryStreamIterator(queryText: querysp, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
  547. {
  548. var jsonts = await JsonDocument.ParseAsync(item.ContentStream);
  549. foreach (var obj in jsonts.RootElement.GetProperty("Documents").EnumerateArray())
  550. {
  551. teach = obj.GetProperty("size").GetInt64() * 1073741824; //G換算
  552. }
  553. }
  554. ////學校已使用空間
  555. long blobsize = 0;
  556. RedisValue value = default;
  557. value = r8.HashGet($"Blob:Record", $"{school_code}");
  558. if (value != default && !value.IsNullOrEmpty)
  559. {
  560. JsonElement record = value.ToString().ToObject<JsonElement>();
  561. if (record.TryGetInt64(out blobsize))
  562. {
  563. }
  564. }
  565. ////各項空間數值取得
  566. Dictionary<string, double> catalog = new();
  567. SortedSetEntry[] Scores = _azureRedis.GetRedisClient(8).SortedSetRangeByScoreWithScores($"Blob:Catalog:{school_code}");
  568. if (Scores != null)
  569. {
  570. foreach (var score in Scores)
  571. {
  572. double val = score.Score;
  573. string key = score.Element.ToString();
  574. catalog.Add(key, val);
  575. }
  576. }
  577. dynamic space = new ExpandoObject();
  578. space.size = blobsize;
  579. space.teach = teach;
  580. space.catalog = catalog;
  581. //取得購買紀錄
  582. List<object> order = await GetOrderHisFromCoreBBAsync(school_code.GetString());
  583. //取得CC授權使用狀態
  584. var hashs = await r8.HashGetAllAsync($"CC:License:{school_code.GetString()}");
  585. var ccuser = hashs.Select(x => JsonDocument.Parse(x.Value.ToString())).ToList();
  586. return Ok(new { serial = serialResult, service = serviceOrder, hard, space, order , ccuser });
  587. }
  588. catch (Exception ex)
  589. {
  590. return BadRequest();
  591. }
  592. }
  593. /// <summary>
  594. /// 取得CoreDevice資訊
  595. /// </summary>
  596. /// <param name="request"></param>
  597. /// <returns></returns>
  598. private async Task<List<deviceFromCoreService>> GetDeviceFromCoreAsync(List<deviceForCoreService> uuidList)
  599. {
  600. List<deviceFromCoreService> result = new List<deviceFromCoreService>();
  601. try
  602. {
  603. string url = _configuration.GetValue<string>("HaBookAuth:CoreService:deviceinfo");
  604. string AccessToken = await getCoreAccessToken();
  605. _httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
  606. string uuidListJson = JsonConvert.SerializeObject(uuidList);
  607. var content = new StringContent(uuidListJson, Encoding.UTF8, "application/json");
  608. HttpResponseMessage responseMessage = await _httpClient.PostAsync(url, content);
  609. if (responseMessage.StatusCode == HttpStatusCode.OK)
  610. {
  611. string responseBody = responseMessage.Content.ReadAsStringAsync().Result;
  612. result = System.Text.Json.JsonSerializer.Deserialize<List<deviceFromCoreService>>(responseBody.ToString());
  613. }
  614. return result;
  615. }
  616. catch (Exception ex)
  617. {
  618. return result;
  619. }
  620. }
  621. /// <summary>
  622. /// 取得CoreBB學校訂單履歷資訊
  623. /// </summary>
  624. /// <param name="request"></param>
  625. /// <returns></returns>
  626. private async Task<List<object>> GetOrderHisFromCoreBBAsync(string schoolCode)
  627. {
  628. List<object> result = new List<object>();
  629. try
  630. {
  631. string url = _configuration.GetValue<string>("HaBookAuth:CoreBBAPI") + "/ies5/get-school-order";
  632. string AccessToken = await getCoreAccessToken();
  633. _httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
  634. string paramJson = JsonConvert.SerializeObject(new { school_code = schoolCode });
  635. var content = new StringContent(paramJson, Encoding.UTF8, "application/json");
  636. HttpResponseMessage responseMessage = await _httpClient.PostAsync(url, content);
  637. if (responseMessage.StatusCode == HttpStatusCode.OK)
  638. {
  639. string responseBody = responseMessage.Content.ReadAsStringAsync().Result;
  640. result = System.Text.Json.JsonSerializer.Deserialize<List<object>>(responseBody.ToString());
  641. }
  642. return result;
  643. }
  644. catch (Exception ex)
  645. {
  646. return result;
  647. }
  648. }
  649. private async Task<string> getCoreAccessToken()
  650. {
  651. string AccessToken = "";
  652. try
  653. {
  654. string Url = _configuration.GetValue<string>("HaBookAuth:CoreAPI") + "/oauth2/token";
  655. string GrantType = "device";
  656. string ClientID = _configuration.GetValue<string>("HaBookAuth:CoreService:clientID");
  657. string Secret = _configuration.GetValue<string>("HaBookAuth:CoreService:clientSecret");
  658. var content = new { grant_type = GrantType, client_id = ClientID, client_secret = Secret };
  659. var response = await _httpClient.PostAsJsonAsync($"{Url}", content);
  660. if (response.IsSuccessStatusCode)
  661. {
  662. string responseBody = response.Content.ReadAsStringAsync().Result;
  663. using (JsonDocument document = JsonDocument.Parse(responseBody.ToString()))
  664. {
  665. if (document.RootElement.TryGetProperty("access_token", out JsonElement AccessTokenObj))
  666. {
  667. AccessToken = AccessTokenObj.ToString();
  668. }
  669. }
  670. }
  671. return AccessToken;
  672. }
  673. catch (Exception ex)
  674. {
  675. return AccessToken;
  676. }
  677. }
  678. /// <summary>
  679. /// 計算各產品的初始結束時間及可用數
  680. /// </summary>
  681. /// <param name="mainPeriodList">active的主周期</param>
  682. /// <param name="periodList">附屬周期</param>
  683. /// <param name="serviceProduct">產品資訊</param>
  684. /// <returns></returns>
  685. private ServiceProductResult CalServiceProductAuth(List<ServiceMainPeriod> mainPeriodList, List<ServicePeriod> periodList, ServiceProduct serviceProduct)
  686. {
  687. periodZone periodZoneResult = new periodZone();
  688. List<periodZone> periodZone = new List<periodZone>();
  689. //篩選出產品有的副週期
  690. List<string> existPeriodIdList = new List<string>();
  691. if (serviceProduct.auth.Count > 0)
  692. {
  693. foreach (ServiceProductAuth serviceProductAuthRow in serviceProduct.auth)
  694. {
  695. if (!string.IsNullOrWhiteSpace(serviceProductAuthRow.periodId) && !existPeriodIdList.Contains(serviceProductAuthRow.periodId))
  696. {
  697. existPeriodIdList.Add(serviceProductAuthRow.periodId);
  698. }
  699. }
  700. }
  701. List<ServicePeriod> periodOrder = periodList.Where(p => existPeriodIdList.Contains(p.periodId)).OrderBy(p => Int32.Parse(p.periodId)).ToList();
  702. //combine period
  703. if (periodOrder.Count() > 0)
  704. {
  705. //篩選出主週期(複數active主週期對策) ※最終篩出唯一一組 篩選原則:(1)由此產品有的副週期ID篩出 (2)若還有複數筆,則期間長者勝出
  706. List<string> existMainPeriodIdList = new List<string>();
  707. foreach (ServicePeriod periodRow in periodOrder)
  708. {
  709. if (!existMainPeriodIdList.Contains(periodRow.mainPeriodId))
  710. {
  711. existMainPeriodIdList.Add(periodRow.mainPeriodId);
  712. }
  713. }
  714. ServiceMainPeriod mainPeriod = mainPeriodList.Where(w => existMainPeriodIdList.Contains(w.mainPeriodId)).OrderByDescending(w => w.endDate - w.startDate).First();
  715. List<ServicePeriod> periods = periodOrder.Where(p => p.mainPeriodId == mainPeriod.mainPeriodId).ToList();
  716. //combine period,compare to mainPeriod start, end
  717. periodZone = combinePeriodZone(periods);
  718. periodZoneResult.startDate = (periodZone[0].startDate > mainPeriod.startDate) ? periodZone[0].startDate : mainPeriod.startDate;
  719. periodZoneResult.endDate = (periodZone[0].endDate < mainPeriod.endDate) ? periodZone[0].endDate : mainPeriod.endDate;
  720. }
  721. //return
  722. ServiceProductResult serviceProductResult = new ServiceProductResult();
  723. if ((serviceProduct.noperiod && periodZoneResult.startDate == 0 && periodZoneResult.endDate == 0) || (!serviceProduct.noperiod && periodZoneResult.startDate > 0 && periodZoneResult.endDate > 0))
  724. {
  725. serviceProductResult.prodCode = serviceProduct.prodCode;
  726. serviceProductResult.noperiod = serviceProduct.noperiod;
  727. serviceProductResult.serviceType = serviceProduct.serviceType;
  728. serviceProductResult.startDate = periodZoneResult.startDate;
  729. serviceProductResult.endDate = periodZoneResult.endDate;
  730. serviceProductResult.avaliable = serviceProduct.avaliable;
  731. }
  732. return serviceProductResult;
  733. }
  734. /// <summary>
  735. /// 軟體序號解綁API
  736. /// </summary>
  737. /// <param name="id_token">ID Token</param>
  738. /// <param name="uuid">硬體識別碼1</param>
  739. /// <param name="uuid2">硬體識別碼2</param>
  740. /// <param name="serial">產品資訊</param>
  741. /// <returns></returns>
  742. [ProducesDefaultResponseType]
  743. [HttpPost("unbind-serial")]
  744. [Authorize(Roles = "IES")]
  745. [AuthToken(Roles = "admin,teacher")]
  746. public async Task<IActionResult> UnbindSerial(JsonElement request)
  747. {
  748. try
  749. {
  750. //輸入參數
  751. if (!request.TryGetProperty("serial", out JsonElement serialJson)) return BadRequest();
  752. var (id, name, _, _) = HttpContext.GetAuthTokenInfo(); //取得IDToken資訊
  753. request.TryGetProperty("uuid", out JsonElement uuidJson);
  754. request.TryGetProperty("uuid2", out JsonElement uuid2Json);
  755. string serial = serialJson.ToString();
  756. string uuid = uuidJson.ToString();
  757. string uuid2 = uuid2Json.ToString();
  758. if (string.IsNullOrEmpty(serial) && (string.IsNullOrEmpty(uuid) || string.IsNullOrEmpty(uuid2)))
  759. {
  760. return BadRequest();
  761. }
  762. string lang = "en-US";
  763. var content = new
  764. {
  765. lang = lang,
  766. serial = serial,
  767. uuid = uuid,
  768. uuid2 = uuid2,
  769. olduuid = "",
  770. pcname = "",
  771. dp = "IES5",
  772. user = new
  773. {
  774. id = $"{id}",
  775. name = $"{name}"
  776. }
  777. };
  778. //呼叫BB解綁API
  779. object result = new { };
  780. bool unbindFlg = false; //解綁是否成功 true:成功 false:失敗
  781. string url = _configuration.GetValue<string>("HaBookAuth:CoreBBAPI") + "/bbauthapi/srunbind";
  782. string AccessToken = await getCoreAccessToken();
  783. _httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
  784. HttpResponseMessage response = await _httpClient.PostAsJsonAsync(url, content);
  785. if (response.StatusCode == HttpStatusCode.OK)
  786. {
  787. string responseBody = await response.Content.ReadAsStringAsync();
  788. //result = System.Text.Json.JsonSerializer.Deserialize<object>(responseBody.ToString());
  789. var unbindResult = JsonDocument.Parse(responseBody);
  790. unbindResult.RootElement.TryGetProperty("status", out JsonElement statusJson);
  791. int status = statusJson.GetInt32();
  792. unbindResult.RootElement.TryGetProperty("error", out JsonElement errorJson);
  793. string error = errorJson.GetString();
  794. if (unbindResult.RootElement.TryGetProperty("prod", out JsonElement prodJson))
  795. {
  796. if (!prodJson.ValueKind.Equals(JsonValueKind.Null))
  797. {
  798. if (prodJson.TryGetProperty("auth_unbind_req", out JsonElement unbindReqJson))
  799. {
  800. if (!unbindReqJson.ValueKind.Equals(JsonValueKind.Undefined) && !unbindReqJson.ValueKind.Equals(JsonValueKind.Null))
  801. {
  802. unbindFlg = true;
  803. }
  804. }
  805. }
  806. }
  807. result = (unbindFlg) ? new { status = 0, error = "" } : new { status = status, error = error };
  808. }
  809. else
  810. {
  811. result = new
  812. {
  813. status = 1,
  814. error = $"Unbind serial: {serial} fail."
  815. };
  816. }
  817. return Ok(result);
  818. }
  819. catch (Exception ex)
  820. {
  821. return BadRequest();
  822. }
  823. }
  824. /// <summary>
  825. /// 計算各產品的購買歷史紀錄 [舊制,不使用]
  826. /// </summary>
  827. /// <param name="mainPeriodList">所有的主周期</param>
  828. /// <param name="periodList">所有附屬周期</param>
  829. /// <param name="serviceProduct">產品資訊</param>
  830. /// <returns></returns>
  831. private List<ServiceProductAuthHistoryStartEnd> CalServiceProductOrderHistory(List<ServiceMainPeriod> mainPeriodList, List<ServicePeriod> periodList, ServiceProduct serviceProduct)
  832. {
  833. List<ServiceProductAuthHistoryStartEnd> serviceProductOrderStartEndList = new List<ServiceProductAuthHistoryStartEnd>();
  834. //GROUP BY orderId
  835. if (serviceProduct.auth.Count > 0)
  836. {
  837. List<ServiceProductAuthHistory> serviceProductOrderList = new List<ServiceProductAuthHistory>();
  838. foreach (ServiceProductAuth serviceProductAuthRow in serviceProduct.auth)
  839. {
  840. ServiceProductAuthHistory existServiceProductAuthHistory = serviceProductOrderList.Where(a => a.orderId == serviceProductAuthRow.orderId).FirstOrDefault();
  841. if (existServiceProductAuthHistory != null)
  842. {
  843. if (!existServiceProductAuthHistory.periodIdList.Contains(serviceProductAuthRow.periodId))
  844. {
  845. existServiceProductAuthHistory.periodIdList.Add(serviceProductAuthRow.periodId);
  846. }
  847. }
  848. else
  849. {
  850. ServiceProductAuthHistory serviceProductAuthHistoryRow = new ServiceProductAuthHistory();
  851. serviceProductAuthHistoryRow.orderId = serviceProductAuthRow.orderId;
  852. int y = Int32.Parse(serviceProductAuthRow.orderId.Substring(0, 4));
  853. int m = Int32.Parse(serviceProductAuthRow.orderId.Substring(4, 2));
  854. int d = Int32.Parse(serviceProductAuthRow.orderId.Substring(6, 2));
  855. serviceProductAuthHistoryRow.orderDate = new DateTimeOffset(y, m, d, 0, 0, 0, TimeSpan.Zero).ToUnixTimeSeconds();
  856. serviceProductAuthHistoryRow.number = serviceProductAuthRow.number;
  857. serviceProductAuthHistoryRow.unit = serviceProductAuthRow.unit;
  858. serviceProductAuthHistoryRow.periodIdList = new List<string>();
  859. serviceProductAuthHistoryRow.periodIdList.Add(serviceProductAuthRow.periodId);
  860. serviceProductOrderList.Add(serviceProductAuthHistoryRow);
  861. }
  862. }
  863. foreach (ServiceProductAuthHistory serviceProductOrderRow in serviceProductOrderList)
  864. {
  865. ServiceProductAuthHistoryStartEnd ServiceProductAuthHistoryStartEndRow = new ServiceProductAuthHistoryStartEnd();
  866. //combine period
  867. List<ServicePeriod> periodOrder = periodList.Where((ServicePeriod x) => serviceProductOrderRow.periodIdList.Contains(x.periodId)).OrderBy(p => Int32.Parse(p.periodId)).ToList();
  868. List<periodZone> periodZone = combinePeriodZone(periodOrder);
  869. ServiceProductAuthHistoryStartEndRow.startDate = periodZone[0].startDate;
  870. ServiceProductAuthHistoryStartEndRow.endDate = periodZone[0].endDate;
  871. ServiceProductAuthHistoryStartEndRow.orderId = serviceProductOrderRow.orderId;
  872. ServiceProductAuthHistoryStartEndRow.orderDate = serviceProductOrderRow.orderDate;
  873. ServiceProductAuthHistoryStartEndRow.number = serviceProductOrderRow.number;
  874. ServiceProductAuthHistoryStartEndRow.unit = serviceProductOrderRow.unit;
  875. serviceProductOrderStartEndList.Add(ServiceProductAuthHistoryStartEndRow);
  876. }
  877. }
  878. //return
  879. return serviceProductOrderStartEndList;
  880. }
  881. //子週期合併開始結束時間
  882. private List<periodZone> combinePeriodZone(List<ServicePeriod> periods)
  883. {
  884. List<periodZone> periodZone = new List<periodZone>();
  885. foreach (ServicePeriod periodRow in periods)
  886. {
  887. if (periodZone.Count == 0)
  888. {
  889. periodZone periodZoneNew = new periodZone();
  890. periodZoneNew.startDate = periodRow.startDate;
  891. periodZoneNew.endDate = periodRow.endDate;
  892. periodZone.Add(periodZoneNew);
  893. }
  894. else
  895. {
  896. bool zoneExistFlg = false;
  897. for (int i = 0; i < periodZone.Count; i++) //考慮到副週期可能斷成數個block,整合後取第一個
  898. {
  899. if (periodRow.startDate <= periodZone[i].endDate + 10 && periodZone[i].endDate + 10 < periodRow.endDate)
  900. {
  901. periodZone[i].endDate = periodRow.endDate;
  902. zoneExistFlg = true;
  903. }
  904. else if (periodZone[i].startDate <= periodRow.endDate + 10 && periodRow.endDate + 10 < periodZone[i].endDate)
  905. {
  906. periodZone[i].startDate = periodRow.startDate;
  907. zoneExistFlg = true;
  908. }
  909. }
  910. if (!zoneExistFlg)
  911. {
  912. periodZone periodZoneNew = new periodZone();
  913. periodZoneNew.startDate = periodRow.startDate;
  914. periodZoneNew.endDate = periodRow.endDate;
  915. periodZone.Add(periodZoneNew);
  916. }
  917. }
  918. }
  919. return periodZone;
  920. }
  921. /*
  922. /// <summary>
  923. /// 取得某學校AClassOne授權及使用資料
  924. /// </summary>
  925. /// <param name="request"></param>
  926. /// <returns></returns>
  927. /// 目前產品DB樣式未定,暫時依照舊樣式建構
  928. [ProducesDefaultResponseType]
  929. [HttpPost("get-school-aclassone")]
  930. public async Task<IActionResult> GetSchoolAclassoneInfo(JsonElement request)
  931. {
  932. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  933. var clientContainer = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
  934. var response = await clientContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey("Product"));
  935. int total = 0; //可分配總數
  936. int staNum = 0; //固定分配數
  937. int dyncNum = 0; //動態分配數
  938. List<string> staIds = new List<string>(); //固定分配學生ID列
  939. List<string> dyncIds = new List<string>(); //動態分配學生ID列
  940. if (response.Status == 200)
  941. {
  942. var json = await JsonDocument.ParseAsync(response.ContentStream);
  943. if (json.RootElement.TryGetProperty("service", out JsonElement serviceJobj))
  944. {
  945. //取得active主週期
  946. List<ServiceMainPeriod> activeMainPeriod = new List<ServiceMainPeriod>();
  947. if (serviceJobj.TryGetProperty("mainperiod", out JsonElement mainperiodJobj) && mainperiodJobj.ValueKind != JsonValueKind.Null)
  948. {
  949. foreach (var mainperiodRow in mainperiodJobj.EnumerateArray())
  950. {
  951. if (mainperiodRow.GetProperty("active").GetBoolean())
  952. {
  953. activeMainPeriod.Add(mainperiodRow.ToObject<ServiceMainPeriod>());
  954. }
  955. }
  956. }
  957. //取得active主週期的副週期
  958. List<ServicePeriod> activePeriodOfMain = new List<ServicePeriod>();
  959. if (serviceJobj.TryGetProperty("period", out JsonElement periodJobj) && mainperiodJobj.ValueKind != JsonValueKind.Null)
  960. {
  961. foreach (var periodRow in periodJobj.EnumerateArray())
  962. {
  963. foreach (ServiceMainPeriod mainPeriodRow in activeMainPeriod)
  964. {
  965. if (periodRow.GetProperty("mainPeriodId").ToString() == mainPeriodRow.mainPeriodId)
  966. {
  967. activePeriodOfMain.Add(periodRow.ToObject<ServicePeriod>());
  968. }
  969. }
  970. }
  971. }
  972. //取得AClassOne可用數量
  973. if (serviceJobj.TryGetProperty("product", out JsonElement serviceProductJobj) && serviceProductJobj.ValueKind != JsonValueKind.Null)
  974. {
  975. foreach (var serviceProductRow in serviceProductJobj.EnumerateArray())
  976. {
  977. //AClassOne買斷、週期
  978. string prodCode = serviceProductRow.GetProperty("prodCode").GetString();
  979. if (prodCode .Equals("RYGVCPLY") || prodCode .Equals("AEGMCPLY"))
  980. {
  981. ServiceProductResult serviceProductResultRow = CalServiceProductAuth(activeMainPeriod, activePeriodOfMain, serviceProductRow.ToObject<ServiceProduct>());
  982. total += serviceProductResultRow.avaliable;
  983. }
  984. }
  985. }
  986. //取得AClassOne固定分配數、動態分配數、固定分配學生ID
  987. if (json.RootElement.TryGetProperty("aclassone", out JsonElement aclassoneJobj))
  988. {
  989. if (aclassoneJobj.ValueKind != JsonValueKind.Null)
  990. {
  991. if (aclassoneJobj.TryGetProperty("ids", out JsonElement ids) && ids.ValueKind != JsonValueKind.Null)
  992. {
  993. staIds = System.Text.Json.JsonSerializer.Deserialize<List<string>>(ids.ToJsonString());
  994. staNum = staIds.Count;
  995. }
  996. }
  997. dyncIds = GetSchoolDynamicAclassOneIDList(school_code.GetString());
  998. dyncNum = dyncIds.Count;
  999. }
  1000. }
  1001. }
  1002. return Ok(new { total, staNum, dyncNum, staIds, dyncIds });
  1003. }
  1004. */
  1005. /// <summary>
  1006. /// 取得某學校AClassOne動態可使用數
  1007. /// </summary>
  1008. public int GetSchoolDynamicAclassOne(string schoolCode)
  1009. {
  1010. try
  1011. {
  1012. int result = 0;
  1013. string key = schoolCode + ":" + "AclassOne" + ":" + "dynamic";
  1014. var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
  1015. var dyncount = redisClient.StringGet(key);
  1016. if (redisClient.KeyExists(key))
  1017. {
  1018. result = Int32.Parse(redisClient.StringGet(key));
  1019. }
  1020. return result;
  1021. }
  1022. catch (Exception ex)
  1023. {
  1024. return 0;
  1025. }
  1026. }
  1027. /// <summary>
  1028. /// 取得某學校AClassOne動態已取用的ID List
  1029. /// </summary>
  1030. public List<string> GetSchoolDynamicAclassOneIDList(string schoolCode)
  1031. {
  1032. string key = schoolCode + ":" + "AclassOne" + ":" + "dynamicIds";
  1033. var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
  1034. RedisValue[] redisResult = redisClient.SetMembers(key);
  1035. List<string> result = Array.ConvertAll(redisResult, x => (string)x).ToList();
  1036. return result;
  1037. }
  1038. public long GetSchoolDynamicAclassOneIDCount(string schoolCode)
  1039. {
  1040. string key = schoolCode + ":" + "AclassOne" + ":" + "dynamicIds";
  1041. var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
  1042. long result = redisClient.SetLength(key);
  1043. return result;
  1044. }
  1045. /// <summary>
  1046. /// [測試用]放入某學校的AClassOne動態學生ID
  1047. /// </summary>
  1048. [ProducesDefaultResponseType]
  1049. [HttpPost("set-school-aclassone-dync")]
  1050. public IActionResult SetSchoolAclassoneDync(JsonElement request)
  1051. {
  1052. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  1053. request.TryGetProperty("student_id", out JsonElement student_id);
  1054. var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
  1055. string key1 = school_code + ":" + "AclassOne" + ":" + "dynamicIds";
  1056. RedisValue[] redisIdsOriginal = redisClient.SetMembers(key1);
  1057. var resultIdsOriginal = Array.ConvertAll(redisIdsOriginal, x => (string)x).ToList();
  1058. redisClient.SetAdd(key1, student_id.GetString());
  1059. RedisValue[] redisIds = redisClient.SetMembers(key1);
  1060. var resultIds = Array.ConvertAll(redisIds, x => (string)x).ToList();
  1061. string key2 = school_code + ":" + "AclassOne" + ":" + "dynamic";
  1062. if (resultIds.Count > resultIdsOriginal.Count)
  1063. {
  1064. redisClient.StringDecrement(key2, 1);
  1065. }
  1066. string resultCount = redisClient.StringGet(key2);
  1067. return Ok(new { resultIds, resultCount });
  1068. }
  1069. /// <summary>
  1070. /// 設定某學校AClassOne固定分配授權學生
  1071. /// </summary>
  1072. /// <param name="request"></param>
  1073. /// <returns></returns>
  1074. [ProducesDefaultResponseType]
  1075. [HttpPost("set-school-aclasson-sta")]
  1076. public async Task<IActionResult> SetSchoolAclassoneStatic(JsonElement request)
  1077. {
  1078. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  1079. if (!request.TryGetProperty("student_ids", out JsonElement student_ids)) return BadRequest();
  1080. try
  1081. {
  1082. List<string> studentIds = System.Text.Json.JsonSerializer.Deserialize<List<string>>(student_ids.ToJsonString()); //新的學生ID列
  1083. /* ERROR CODE定義:
  1084. * 0: 無錯誤
  1085. * 1: AClassOne授權數不足或無AClassOne授權
  1086. */
  1087. int status = 0;
  1088. string err = "";
  1089. var clientContainer = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
  1090. var response = await clientContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey("Product"));
  1091. if (response.Status == 200)
  1092. {
  1093. int total = 0; //(回傳值)可分配總數
  1094. int staNum = 0; //(回傳值)固定分配數
  1095. int dyncNum = 0; //(回傳值)動態分配數
  1096. List<string> staIds = new List<string>(); //(回傳值)固定學生ID列
  1097. List<string> dyncIds = new List<string>(); //(回傳值)動態學生ID列
  1098. using (Stream stream = response.ContentStream)
  1099. {
  1100. using (StreamReader streamReader = new StreamReader(stream))
  1101. {
  1102. string content = streamReader.ReadToEnd();
  1103. SchoolProduct schoolProduct = System.Text.Json.JsonSerializer.Deserialize<SchoolProduct>(content);
  1104. if (schoolProduct.aclassone != null) //有AClassOne產品授權,schoolProduct.aclassone不會為null
  1105. {
  1106. total = schoolProduct.aclassone.total;
  1107. List<string> studentIdsInDB = schoolProduct.aclassone.ids; //舊的學生ID列
  1108. int totalInDB = schoolProduct.aclassone.total;
  1109. //STEP1 驗證所給的ID數是否超過AClassOne總數
  1110. if (studentIds.Count > totalInDB)
  1111. {
  1112. status = 1;
  1113. err = "AclassOne numbers is not enouth.";
  1114. return Ok(new { status, err });
  1115. }
  1116. //STEP2 將學生ID放入 School.Product.aclassone.ids,更新aclassone.used
  1117. staIds = schoolProduct.aclassone.ids = studentIds;
  1118. staNum = schoolProduct.aclassone.used = studentIds.Count;
  1119. ////Update
  1120. await clientContainer.ReplaceItemAsync<SchoolProduct>(schoolProduct, schoolProduct.id, new PartitionKey("Product"));
  1121. //STEP3更新Redis.hbcn:AclassOne:dynamic ※註:只更新動態ID可用數,不更動動態ID列表,所以若可用數為0,當天被動態分配到的學生仍可使用至今日0時才會被清掉
  1122. int dynamicAclassCount = totalInDB - studentIds.Count; //動態可使用數
  1123. dyncNum = (int)GetSchoolDynamicAclassOneIDCount(school_code.GetString()); //動態ID已使用數
  1124. var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
  1125. string keys = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamic";
  1126. int updDynAclassCount = (dynamicAclassCount - dyncNum > 0) ? dynamicAclassCount - dyncNum : 0;
  1127. redisClient.StringSet(keys, updDynAclassCount);
  1128. string keyd = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamicIds";
  1129. RedisValue[] redisIds = redisClient.SetMembers(keyd);
  1130. dyncIds = Array.ConvertAll(redisIds, x => (string)x).ToList();
  1131. return Ok(new { status, err, total, staNum, dyncNum, staIds, dyncIds });
  1132. }
  1133. else
  1134. {
  1135. status = 1;
  1136. err = "AClassOne has no authorization.";
  1137. return Ok(new { status, err });
  1138. }
  1139. }
  1140. }
  1141. }
  1142. else
  1143. {
  1144. return BadRequest();
  1145. }
  1146. }
  1147. catch (Exception ex)
  1148. {
  1149. return BadRequest();
  1150. }
  1151. }
  1152. /// <summary>
  1153. /// 回收某學校AClassOne固定分配、動態分配授權學生
  1154. /// </summary>
  1155. /// <param name="request"></param>
  1156. /// <returns></returns>
  1157. [ProducesDefaultResponseType]
  1158. [HttpPost("recall-school-aclasson")]
  1159. public async Task<IActionResult> RecallSchoolAclassone(JsonElement request)
  1160. {
  1161. if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
  1162. string action = "all"; //預設回收:固定及動態均回收 sta:回收固定 dync:回收動態
  1163. if (request.TryGetProperty("mode", out JsonElement mode))
  1164. {
  1165. if (mode.GetString().Equals("sta") || mode.GetString().Equals("dync"))
  1166. {
  1167. action = mode.GetString();
  1168. }
  1169. }
  1170. int status = 0;
  1171. string err = "";
  1172. var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
  1173. string keys = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamic";
  1174. string keyd = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamicIds";
  1175. var clientContainer = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
  1176. var response = await clientContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey("Product"));
  1177. if (response.Status == 200)
  1178. {
  1179. int total = 0; //(回傳值)可分配總數
  1180. int staNum = 0; //(回傳值)固定分配數
  1181. int dyncNum = 0; //(回傳值)動態分配數
  1182. List<string> staIds = new List<string>(); //(回傳值)固定學生ID列
  1183. List<string> dyncIds = new List<string>(); //(回傳值)動態學生ID列
  1184. using (Stream stream = response.ContentStream)
  1185. {
  1186. using (StreamReader streamReader = new StreamReader(stream))
  1187. {
  1188. string content = streamReader.ReadToEnd();
  1189. SchoolProduct schoolProduct = System.Text.Json.JsonSerializer.Deserialize<SchoolProduct>(content);
  1190. if (schoolProduct.aclassone != null) //有AClassOne產品授權,schoolProduct.aclassone不會為null
  1191. {
  1192. total = schoolProduct.aclassone.total;
  1193. staNum = schoolProduct.aclassone.used;
  1194. staIds = schoolProduct.aclassone.ids;
  1195. dyncNum = (int)GetSchoolDynamicAclassOneIDCount(school_code.GetString());
  1196. dyncIds = GetSchoolDynamicAclassOneIDList(school_code.GetString());
  1197. switch (action)
  1198. {
  1199. case "sta":
  1200. staIds = schoolProduct.aclassone.ids = new List<string>();
  1201. staNum = schoolProduct.aclassone.used = 0;
  1202. await clientContainer.ReplaceItemAsync<SchoolProduct>(schoolProduct, schoolProduct.id, new PartitionKey("Product"));
  1203. int updDynAclassCount = (total - dyncNum > 0) ? total - dyncNum : 0;
  1204. redisClient.StringSet(keys, updDynAclassCount);
  1205. break;
  1206. case "dync": //動態回收
  1207. dyncNum = 0;
  1208. dyncIds = new List<string>();
  1209. redisClient.StringSet(keys, total - staNum);
  1210. redisClient.KeyDelete(keyd);
  1211. break;
  1212. case "all": //全回收
  1213. staIds = schoolProduct.aclassone.ids = new List<string>();
  1214. staNum = schoolProduct.aclassone.used = 0;
  1215. await clientContainer.ReplaceItemAsync<SchoolProduct>(schoolProduct, schoolProduct.id, new PartitionKey("Product"));
  1216. dyncNum = 0;
  1217. dyncIds = new List<string>();
  1218. redisClient.StringSet(keys, total);
  1219. redisClient.KeyDelete(keyd);
  1220. break;
  1221. }
  1222. return Ok(new { status, err, total, staNum, dyncNum, staIds, dyncIds });
  1223. }
  1224. else
  1225. {
  1226. status = 1;
  1227. err = "AClassOne has no authorization.";
  1228. return Ok(new { status, err });
  1229. }
  1230. }
  1231. }
  1232. }
  1233. else
  1234. {
  1235. return BadRequest();
  1236. }
  1237. }
  1238. /// <summary>
  1239. /// 教師空間
  1240. /// </summary>
  1241. [ProducesDefaultResponseType]
  1242. [HttpPost("teacher-space")]
  1243. [Authorize(Roles = "IES")]
  1244. public async Task<IActionResult> TeacherSpace(JsonElement request)
  1245. {
  1246. // 必要檢查
  1247. if (!request.TryGetProperty("school_code", out JsonElement code)) return BadRequest();
  1248. if (!request.TryGetProperty("action", out JsonElement type)) return BadRequest();
  1249. long usedSpace = 0;//已被使用的空間量(G)
  1250. School school = null;
  1251. string school_code = code.ToString(); // 學校簡碼
  1252. try
  1253. {
  1254. // [變數宣告]
  1255. string action = type.ToString(); // 功能分類
  1256. string queryText = ""; // 統一sql文記憶體
  1257. // response
  1258. string status = "0";
  1259. string err = "";
  1260. List<string> errTeachers = new List<string>();
  1261. RedisValue value = _azureRedis.GetRedisClient(8).HashGet($"Blob:Record", school_code);
  1262. if (value != default && !value.IsNullOrEmpty)
  1263. {
  1264. JsonElement record = value.ToString().ToObject<JsonElement>();
  1265. if (record.TryGetInt64(out usedSpace))
  1266. {
  1267. }
  1268. usedSpace = Convert.ToInt64(Math.Ceiling(usedSpace / bytes));
  1269. }
  1270. else
  1271. {
  1272. //[學校空間]
  1273. var blobClient = _azureStorage.GetBlobContainerClient(school_code.ToString());
  1274. long? docSize = await blobClient.GetBlobsSize("doc");
  1275. long? videoSize = await blobClient.GetBlobsSize("video");
  1276. long? imageSize = await blobClient.GetBlobsSize("image");
  1277. long? paperSize = await blobClient.GetBlobsSize("paper");
  1278. long? itemSize = await blobClient.GetBlobsSize("item");
  1279. long? otherSize = await blobClient.GetBlobsSize("other");
  1280. long? voteSize = await blobClient.GetBlobsSize("vote");
  1281. long? surveySize = await blobClient.GetBlobsSize("survey");
  1282. long? audioSize = await blobClient.GetBlobsSize("audio");
  1283. long? resSize = await blobClient.GetBlobsSize("res");
  1284. long? tempSize = await blobClient.GetBlobsSize("temp");
  1285. long? thumSize = await blobClient.GetBlobsSize("thum");
  1286. long? syllabusSize = await blobClient.GetBlobsSize("syllabus");
  1287. long? examSize = await blobClient.GetBlobsSize("exam");
  1288. long? recordsSize = await blobClient.GetBlobsSize("records");
  1289. long? yxptSize = await blobClient.GetBlobsSize("yxpt");
  1290. long? trainSize = await blobClient.GetBlobsSize("train");
  1291. long? homeworkSize = await blobClient.GetBlobsSize("homework");
  1292. long? avatarSize = await blobClient.GetBlobsSize("avatar");
  1293. docSize = docSize != null ? docSize : 0;
  1294. videoSize = videoSize != null ? videoSize : 0;
  1295. imageSize = imageSize != null ? imageSize : 0;
  1296. paperSize = paperSize != null ? paperSize : 0;
  1297. itemSize = itemSize != null ? itemSize : 0;
  1298. otherSize = otherSize != null ? otherSize : 0;
  1299. voteSize = voteSize != null ? voteSize : 0;
  1300. surveySize = surveySize != null ? surveySize : 0;
  1301. audioSize = audioSize != null ? audioSize : 0;
  1302. resSize = resSize != null ? resSize : 0;
  1303. tempSize = tempSize != null ? tempSize : 0;
  1304. thumSize = thumSize != null ? thumSize : 0;
  1305. syllabusSize = syllabusSize != null ? syllabusSize : 0;
  1306. examSize = examSize != null ? examSize : 0;
  1307. 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)));
  1308. }
  1309. long avaliable = this.baseSpaceSize; // (G) 目前學校申請空間總數
  1310. long teacherSpace = 0; // 教師可設定的空間量(G)
  1311. school = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>(school_code, new PartitionKey("Base"));
  1312. if (school.size <= 0)
  1313. {
  1314. school.size = baseSpaceSize;
  1315. }
  1316. avaliable = school.size;
  1317. // 取得學校目前的總空間數(G)
  1318. teacherSpace = avaliable - usedSpace;
  1319. List<SchoolTeacher> teachersInschool = new List<SchoolTeacher>();
  1320. switch (action)
  1321. {
  1322. case "baseSpace": // 現在的教師空間
  1323. return Ok(new
  1324. {
  1325. status,
  1326. avaliable = avaliable.ToString(),
  1327. usedSpace = usedSpace.ToString()
  1328. });
  1329. case "upd": // 修改教師空間
  1330. // [二次檢核]
  1331. if (!request.TryGetProperty("teachers", out JsonElement _teachers)) return BadRequest();
  1332. List<Teacher> teachers = _teachers.Deserialize<List<Teacher>>();
  1333. // 教師設定總數
  1334. int setSpaceTotal = 0;
  1335. // 教師List
  1336. var ids = teachers.Select(x => x.id);
  1337. int notInSpaceTotal = 0;
  1338. string notinsql = $"select value(sum(c.size)) from c ";
  1339. if (ids.Any())
  1340. {
  1341. notinsql = $"select value(sum(c.size)) from c where c.id not in ({string.Join(",", ids.Select(o => $"'{o}'"))})";
  1342. }
  1343. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<int>(queryText: notinsql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
  1344. {
  1345. notInSpaceTotal = item;
  1346. break;
  1347. }
  1348. setSpaceTotal = notInSpaceTotal + teachers.Select(x => x.size).Sum();
  1349. // 檢核總數是否超過
  1350. if (setSpaceTotal > teacherSpace)
  1351. {
  1352. status = "1"; // 要設定的空間總數大於目前學校有的
  1353. err = $"設定總量({setSpaceTotal}G)超過目前空間({teacherSpace}G)";
  1354. return Ok(new { status, err });
  1355. }
  1356. queryText = $"select * from c where c.id in ({string.Join(",", ids.Select(o => $"'{o}'"))})";
  1357. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: queryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
  1358. {
  1359. using var jsoncm = await JsonDocument.ParseAsync(item.ContentStream);
  1360. foreach (var obj in jsoncm.RootElement.GetProperty("Documents").EnumerateArray())
  1361. {
  1362. teachersInschool.Add(obj.ToObject<SchoolTeacher>());
  1363. }
  1364. }
  1365. foreach (var obj in teachers)
  1366. {
  1367. SchoolTeacher teacher = teachersInschool.Where(t => t.id == obj.id).FirstOrDefault<SchoolTeacher>();
  1368. int orgTeacherSize = teacher.size;
  1369. teacher.size = obj.size;
  1370. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(teacher, obj.id, new PartitionKey($"Teacher-{school_code}"));
  1371. }
  1372. return Ok(new { status, err, errTeachers });
  1373. case "retract": // 收回教師空間
  1374. // [取得DB資料]
  1375. queryText = "select * from c ";
  1376. string record = "0";
  1377. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: queryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
  1378. {
  1379. using var jsoncm = await JsonDocument.ParseAsync(item.ContentStream);
  1380. if (jsoncm.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
  1381. {
  1382. // 修改的筆數
  1383. record = count.ToString();
  1384. //List<SchoolTeacher> teachersInschool = new List<SchoolTeacher>();
  1385. foreach (var obj in jsoncm.RootElement.GetProperty("Documents").EnumerateArray())
  1386. {
  1387. teachersInschool.Add(obj.ToObject<SchoolTeacher>());
  1388. }
  1389. foreach (SchoolTeacher teacher in teachersInschool)
  1390. {
  1391. // 修改DB裡School的老師size
  1392. int teacherSizeInSchool = teacher.size;
  1393. teacher.size = 0;
  1394. // 修改DB裡Teacher的size
  1395. var response = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemStreamAsync(teacher.id, new PartitionKey("Base"));
  1396. if (response.Status == 200)
  1397. {
  1398. // var json = await JsonDocument.ParseAsync(response.ContentStream);
  1399. //軟體
  1400. // Teacher teacherHimself = json.ToObject<Teacher>();
  1401. // teacherHimself.size -= teacherSizeInSchool;
  1402. // 最後一起修改
  1403. //huanghb 2021,7.21修改 ,不用再统计到Teacher-Base中 ,Teacher-Base只记录教师自己的空间大小,并包含其他学校赠与的空间,其他学校的赠与空间放在School 表的Teacher-hbcn(SchoolTeacher)中SchoolTeacher
  1404. //,并在教师登陆的时候 一并计算个人空间和总空间大小。其中总空间大小包含(个人空间+多个学校累加的空间大小,并且如果退出或者被移除Teacher-Base 的"schools": [],为空,则已经实现自动回收)
  1405. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(teacher, teacher.id, new PartitionKey($"Teacher-{school_code}"));
  1406. //await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacherHimself, teacherHimself.id, new PartitionKey("Base"));
  1407. }
  1408. else
  1409. {
  1410. status = "3";
  1411. err = "有老師不存在於 Teacher 的DB";
  1412. }
  1413. }
  1414. }
  1415. }
  1416. return Ok(new { status, record });
  1417. default:
  1418. return BadRequest(); // 不存在的功能BadRequest
  1419. }
  1420. }
  1421. catch (CosmosException ex)
  1422. {
  1423. await _dingDing.SendBotMsg($"OS,{_option.Location},schoool/teacher-space\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  1424. return BadRequest();
  1425. }
  1426. catch (Exception ex)
  1427. {
  1428. await _dingDing.SendBotMsg($"OS,{_option.Location},schoool/teacher-space\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  1429. return BadRequest();
  1430. }
  1431. finally
  1432. {
  1433. if (school != null)
  1434. {
  1435. string sql = "select value sum(c.size ) from c ";
  1436. int teachSize = 0;
  1437. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<int>(queryText: sql,
  1438. requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
  1439. {
  1440. teachSize += item;
  1441. }
  1442. school.tsize = teachSize;
  1443. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(school, school.id, new PartitionKey("Base"));
  1444. }
  1445. }
  1446. }
  1447. [ProducesDefaultResponseType]
  1448. [HttpPost("teacher-import-manage")]
  1449. [Authorize(Roles = "IES")]
  1450. [AuthToken(Roles = "admin,teacher")]
  1451. public async Task<IActionResult> TeacherImportManage(JsonElement request)
  1452. {
  1453. (string adminId, string adminName, string pic, string schoolId) = HttpContext.GetAuthTokenInfo();
  1454. if (!request.TryGetProperty("opt", out JsonElement _opt)) { return BadRequest(); }
  1455. if (!request.TryGetProperty("schoolId", out JsonElement _schoolId)) { return BadRequest(); }
  1456. long now = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
  1457. TeacherImport teacherImport = null;
  1458. List<SchoolTeacher> idsInSchool = new List<SchoolTeacher>();
  1459. List<CoreUser> coreUsers = new List<CoreUser>();
  1460. switch ($"{_opt}")
  1461. {
  1462. case "upsert":
  1463. if (!request.TryGetProperty("teachers", out JsonElement _teachers) || !_teachers.ValueKind.Equals(JsonValueKind.Array)) { return BadRequest(); }
  1464. List<ImportTeacher> teachers = _teachers.ToObject<List<ImportTeacher>>();
  1465. var tmdids = teachers.Where(x => !string.IsNullOrWhiteSpace(x.tmdid)).Select(z => z.tmdid);
  1466. var phones = teachers.Where(x => !string.IsNullOrWhiteSpace(x.phone)).Select(z => z.phone);
  1467. var emails = teachers.Where(x => !string.IsNullOrWhiteSpace(x.email)).Select(z => z.email);
  1468. List<string> keys = new List<string>();
  1469. if (tmdids.Any())
  1470. {
  1471. keys.AddRange(tmdids);
  1472. }
  1473. if (phones.Any())
  1474. {
  1475. keys.AddRange(phones);
  1476. }
  1477. if (emails.Any())
  1478. {
  1479. keys.AddRange(emails);
  1480. }
  1481. teachers.ForEach(x => { x.status = "import"; x.time = now; x.iname = x.name; x.name = null; });
  1482. if (keys.Any())
  1483. {
  1484. try
  1485. {
  1486. var content = new StringContent(keys.ToJsonString(), Encoding.UTF8, "application/json");
  1487. string json = await _coreAPIHttpService.GetUserInfos(content);
  1488. if (!string.IsNullOrWhiteSpace(json))
  1489. {
  1490. coreUsers = json.ToObject<List<CoreUser>>();
  1491. }
  1492. }
  1493. catch (Exception ex)
  1494. {
  1495. await _dingDing.SendBotMsg($"{_option.Location},导入名单时,查验key信息错误{ex.Message}\n{ex.StackTrace}\n\n{keys.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
  1496. }
  1497. }
  1498. if (coreUsers.Any())
  1499. {
  1500. string sql = $"select c.id,c.status from c where c.id in ({string.Join(",", coreUsers.Select(x => $"'{x.id}'"))}) ";
  1501. await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School)
  1502. .GetItemQueryIterator<SchoolTeacher>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{_schoolId}") }))
  1503. {
  1504. idsInSchool.Add(item);
  1505. }
  1506. }
  1507. List<string> inviteids = new List<string>();
  1508. School schoolBase = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>($"{_schoolId}", new PartitionKey("Base"));
  1509. if (coreUsers.Any())
  1510. {
  1511. foreach (var t in teachers)
  1512. {
  1513. if (!string.IsNullOrWhiteSpace(t.tmdid))
  1514. {
  1515. CoreUser coreUser = coreUsers.Find(x => x.id.Equals(t.tmdid));
  1516. if (coreUser != null)
  1517. {
  1518. t.id = coreUser.id;
  1519. t.name = coreUser.name;
  1520. t.picture = coreUser.picture;
  1521. t.tmdid = coreUser.id;
  1522. if (!string.IsNullOrWhiteSpace(coreUser.mobile))
  1523. {
  1524. t.phone = coreUser.mobile;
  1525. }
  1526. if (!string.IsNullOrWhiteSpace(coreUser.mail))
  1527. {
  1528. t.email = coreUser.mail;
  1529. }
  1530. }
  1531. }
  1532. if (string.IsNullOrWhiteSpace(t.id))
  1533. {
  1534. if (!string.IsNullOrWhiteSpace(t.phone))
  1535. {
  1536. CoreUser coreUser = coreUsers.Find(x => !string.IsNullOrWhiteSpace(x.mobile) && x.mobile.Equals(t.phone));
  1537. if (coreUser != null)
  1538. {
  1539. t.id = coreUser.id;
  1540. t.name = coreUser.name;
  1541. t.picture = coreUser.picture;
  1542. t.tmdid = coreUser.id;
  1543. if (!string.IsNullOrWhiteSpace(coreUser.mobile))
  1544. {
  1545. t.phone = coreUser.mobile;
  1546. }
  1547. if (!string.IsNullOrWhiteSpace(coreUser.mail))
  1548. {
  1549. t.email = coreUser.mail;
  1550. }
  1551. }
  1552. }
  1553. }
  1554. if (string.IsNullOrWhiteSpace(t.id))
  1555. {
  1556. if (!string.IsNullOrWhiteSpace(t.email))
  1557. {
  1558. CoreUser coreUser = coreUsers.Find(x => !string.IsNullOrWhiteSpace(x.mail) && x.mail.Equals(t.email));
  1559. if (coreUser != null)
  1560. {
  1561. t.id = coreUser.id;
  1562. t.name = coreUser.name;
  1563. t.picture = coreUser.picture;
  1564. t.tmdid = coreUser.id;
  1565. if (!string.IsNullOrWhiteSpace(coreUser.mobile))
  1566. {
  1567. t.phone = coreUser.mobile;
  1568. }
  1569. if (!string.IsNullOrWhiteSpace(coreUser.mail))
  1570. {
  1571. t.email = coreUser.mail;
  1572. }
  1573. }
  1574. }
  1575. }
  1576. if (!string.IsNullOrWhiteSpace(t.id))
  1577. {
  1578. SchoolTeacher teacher = idsInSchool.Find(x => x.id.Equals(t.id));
  1579. if (teacher != null)
  1580. {
  1581. t.status = teacher.status;
  1582. }
  1583. else
  1584. {
  1585. t.status = "invite";
  1586. teacher = new SchoolTeacher
  1587. {
  1588. id = t.id,
  1589. name = t.name,
  1590. permissions = new List<string>(),
  1591. picture = t.picture,
  1592. job = null,
  1593. roles = new List<string> { "teacher" },
  1594. status = "invite",
  1595. createTime = now,
  1596. size = 0,
  1597. subjectIds = new List<string>(),
  1598. pk = "Teacher",
  1599. code = $"Teacher-{_schoolId}"
  1600. };
  1601. inviteids.Add(t.id);
  1602. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).CreateItemAsync(teacher, new PartitionKey(teacher.code));
  1603. Azure.Response responseTeacher = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReadItemStreamAsync(t.id, new PartitionKey("Base"));
  1604. if (responseTeacher.Status == 200)
  1605. {
  1606. Teacher teacherBase = JsonDocument.Parse(responseTeacher.Content).RootElement.Deserialize<Teacher>();
  1607. var school = teacherBase.schools?.Find(x => x.schoolId.Equals($"{_schoolId}"));
  1608. if (teacherBase.schools.IsNotEmpty())
  1609. {
  1610. if (school == null)
  1611. {
  1612. teacherBase.schools.Add(new Teacher.TeacherSchool { schoolId = schoolBase.id, name = schoolBase.name, picture = schoolBase.picture, areaId = schoolBase.areaId, time = now, status = "invite" });
  1613. }
  1614. }
  1615. else
  1616. {
  1617. 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" } };
  1618. }
  1619. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReplaceItemAsync(teacherBase, teacherBase.id, new PartitionKey("Base"));
  1620. }
  1621. else
  1622. {
  1623. Teacher teacherBase = new Teacher
  1624. {
  1625. createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds(),
  1626. id = t.id,
  1627. name = t.name,
  1628. picture = t.picture,
  1629. size = 2,
  1630. code = "Base",
  1631. pk = "Base",
  1632. schools = new List<Teacher.TeacherSchool> {
  1633. new Teacher.TeacherSchool {schoolId= schoolBase.id,name= schoolBase.name,picture= schoolBase.picture, areaId= schoolBase.areaId,time=now,status= "invite" },
  1634. }
  1635. };
  1636. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).CreateItemAsync(teacherBase, new PartitionKey("Base"));
  1637. }
  1638. }
  1639. }
  1640. }
  1641. }
  1642. Azure.Response response = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemStreamAsync($"{_schoolId}", new PartitionKey("TeacherImport"));
  1643. if (response.Status == 200)
  1644. {
  1645. teacherImport = JsonDocument.Parse(response.Content).RootElement.Deserialize<TeacherImport>();
  1646. if (teacherImport != null && teacherImport.teachers.Any())
  1647. {
  1648. teachers.ForEach(x =>
  1649. {
  1650. ImportTeacher tch = null;
  1651. if (string.IsNullOrWhiteSpace(x.id))
  1652. {
  1653. tch = teacherImport.teachers.Find(t => t.iname.Equals(x.iname));
  1654. }
  1655. else
  1656. {
  1657. tch = teacherImport.teachers.Find(t => !string.IsNullOrWhiteSpace(x.id) && !string.IsNullOrWhiteSpace(t.id) && t.id.Equals(x.id));
  1658. }
  1659. if (tch != null)
  1660. {
  1661. tch.time = now;
  1662. tch.status = x.status;
  1663. tch.name = x.name;
  1664. tch.iname = x.iname;
  1665. tch.picture = x.picture;
  1666. tch.phone = x.phone;
  1667. tch.tmdid = x.tmdid;
  1668. tch.email = x.email;
  1669. tch.note = x.note;
  1670. tch.id = x.id;
  1671. }
  1672. else
  1673. {
  1674. teacherImport.teachers.Add(new ImportTeacher
  1675. {
  1676. time = now,
  1677. status = x.status,
  1678. name = x.name,
  1679. iname = x.iname,
  1680. picture = x.picture,
  1681. phone = x.phone,
  1682. tmdid = x.tmdid,
  1683. email = x.email,
  1684. note = x.note,
  1685. id = x.id
  1686. });
  1687. }
  1688. });
  1689. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(teacherImport, $"{_schoolId}", new PartitionKey("TeacherImport"));
  1690. }
  1691. else
  1692. {
  1693. teacherImport = new TeacherImport { id = $"{_schoolId}", code = "TeacherImport", pk = "TeacherImport", teachers = teachers };
  1694. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(teacherImport, $"{_schoolId}", new PartitionKey("TeacherImport"));
  1695. }
  1696. }
  1697. else
  1698. {
  1699. teacherImport = new TeacherImport { id = $"{_schoolId}", code = "TeacherImport", pk = "TeacherImport", teachers = teachers };
  1700. await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).CreateItemAsync(teacherImport, new PartitionKey("TeacherImport"));
  1701. }
  1702. if (inviteids.Any())
  1703. {
  1704. string bizcode = "invite";
  1705. Notification notification = new Notification
  1706. {
  1707. hubName = "hita",
  1708. type = "msg",
  1709. from = $"ies5:{_option.Location}:private",
  1710. to = inviteids.Select(x => x).ToList(),
  1711. label = $"{bizcode}_school",
  1712. body = new { location = _option.Location, biz = bizcode, tmdid = adminId, tmdname = adminName, schoolcode = $"{_schoolId}", schoolname = $"{schoolBase.name}", status = 1, time = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds() }.ToJsonString(),
  1713. expires = DateTimeOffset.UtcNow.AddDays(7).ToUnixTimeSeconds()
  1714. };
  1715. var url = _configuration.GetValue<string>("HaBookAuth:CoreService:sendnotification");
  1716. var clientID = _configuration.GetValue<string>("HaBookAuth:CoreService:clientID");
  1717. var clientSecret = _configuration.GetValue<string>("HaBookAuth:CoreService:clientSecret");
  1718. var location = _option.Location;
  1719. var code = await _notificationService.SendNotification(clientID, clientSecret, location, url, notification);
  1720. }
  1721. break;
  1722. }
  1723. return Ok(new { teacherImport });
  1724. }
  1725. }
  1726. }