TEAMModelOS/TEAMModelOS/Controllers/School/SchoolController.cs

using Azure.Cosmos;
using DocumentFormat.OpenXml.Spreadsheet;
using HTEXLib.COMM.Helpers;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.Options;
using Newtonsoft.Json;
using StackExchange.Redis;
using System;
using System.Collections.Generic;
using System.Dynamic;
using System.Globalization;
using System.IO;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Net.Http.Json;
using System.Text;
using System.Text.Json;
using System.Threading.Tasks;
using TEAMModelOS.Filter;
using TEAMModelOS.Models;
using TEAMModelOS.SDK;
using TEAMModelOS.SDK.DI;
using TEAMModelOS.SDK.Extension;
using TEAMModelOS.SDK.Models;
using TEAMModelOS.SDK.Models.Cosmos.School;
using TEAMModelOS.SDK.Models.Service.BI;

namespace TEAMModelOS.Controllers
{
    [ProducesResponseType(StatusCodes.Status200OK)]
    [ProducesResponseType(StatusCodes.Status400BadRequest)]

    [Route("school/init")]
    [ApiController]
    public class SchoolController : ControllerBase
    {

        public AzureCosmosFactory _azureCosmos;
        private readonly AzureStorageFactory _azureStorage;
        private readonly AzureRedisFactory _azureRedis;
        private readonly DingDing _dingDing;
        private readonly Option _option;
        int baseSpaceSize = 10; //學校保底空間大小(1G)
        private readonly double bytes = 1073741824;
        private readonly int redisAclassoneDbNum = 8; //AclassOne Redis DB號
        private readonly IConfiguration _configuration;
        private readonly CoreAPIHttpService _coreAPIHttpService;
        private readonly IHttpClientFactory _httpClient;
        private readonly HttpTrigger _httpTrigger;
        private readonly IWebHostEnvironment _environment;
        public SchoolController(IWebHostEnvironment environment, HttpTrigger httpTrigger, CoreAPIHttpService coreAPIHttpService, AzureCosmosFactory azureCosmos, AzureStorageFactory azureStorage, AzureRedisFactory azureRedis, DingDing dingDing, IOptionsSnapshot<Option> option, IConfiguration configuration, IHttpClientFactory httpClient)
        {
            _azureCosmos = azureCosmos;
            _azureStorage = azureStorage;
            _azureRedis = azureRedis;
            _dingDing = dingDing;
            _option = option?.Value;
            _configuration = configuration;
            _coreAPIHttpService = coreAPIHttpService;
            _httpClient = httpClient;
            _httpTrigger = httpTrigger;
            _environment = environment;
        }
        /// <summary>
        /// 修改学校信息
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("set-school-info")]
        [Authorize(Roles = "IES")]

        [AuthToken(Roles = "admin", Permissions = "train-appraise")]

        public async Task<IActionResult> SetTeacherInfo(JsonElement request)
        {
            var client = _azureCosmos.GetCosmosClient();

            if (!request.TryGetProperty("opt", out JsonElement _opt))
            {
                return BadRequest();
            }
            var (userid, name, _, school) = HttpContext.GetAuthTokenInfo();
            try
            {
                SchoolTeacher teacher = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>(userid, new PartitionKey($"Teacher-{school}"));
                switch (true)
                {
                    //修改互评开关
                    case bool when $"{_opt}".Equals("modify-hpappraise", StringComparison.OrdinalIgnoreCase):
                        int hpappraise = -1;
                        if (request.TryGetProperty("hpappraise", out JsonElement _hpappraise))
                        {
                            int.TryParse($"{_hpappraise}", out hpappraise);
                        }
                        if (hpappraise != -1)
                        {
                            School schoolData = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>(school, new PartitionKey("Base"));
                            schoolData.hpappraise = hpappraise;
                            await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(schoolData, school, new PartitionKey("Base"));
                            return Ok(new { status = 200 });
                        }
                        else
                        {
                            return Ok(new { error = 1, msg = "参数异常！" });
                        }

                    default:
                        return Ok(new { error = 1, msg = "参数异常！" });

                }
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"IES5，{_option.Location}，Teacher/init/set-teacher-info()\n{ex.Message}\n{ex.StackTrace}{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
                return Ok(new { error = 1, msg = "参数异常！" });

            }
        }
        /// <summary>
        /// 保存或更新学校
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        //[AuthToken(Roles = "admin")]
        [HttpPost("upsert")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif

        public async Task<IActionResult> Upsert(School school)
        {
            var (userid, name, _, _school) = HttpContext.GetAuthTokenInfo();
            try
            {
                var tableClient = _azureStorage.GetCloudTableClient();
                var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");
                School schoolInfo = new();
                var client = _azureCosmos.GetCosmosClient();
                var schoolContainer = client.GetContainer(Constant.TEAMModelOS, "School");
                var response = await schoolContainer.ReadItemStreamAsync(school.id, new PartitionKey($"Base"));
                if (response.Status == 200)
                {
                    School db_school = JsonDocument.Parse(response.Content).RootElement.Deserialize<School>();
                    //计算 比较更改前后 学段的年级变化的学段，并重新处理行政班的毕业状态。
                    //开启课例设置是否变更
                    if (db_school.openLessonRecord != school.openLessonRecord)
                    {
                        string opentype = "close-lesson-record";
                        string openstr = "关闭";
                        if (school.openLessonRecord)
                        {
                            openstr = "开启";
                            opentype = "open-lesson-record";
                        }
                        StringBuilder strMsg = new($"{name}【{userid}】{openstr}【{school.name}-{school.id}】的课堂记录菜单");
                        //
                        await _azureStorage.SaveLog(opentype, strMsg?.ToString(), _dingDing, "school", httpContext: HttpContext);
                    }

                    //变更后
                    List<KeyValuePair<string, int>> period_gradeCount = new List<KeyValuePair<string, int>>();
                    school.period.ForEach(z => { period_gradeCount.Add(new KeyValuePair<string, int>(z.id, z.grades.Count)); });
                    //变更前
                    List<KeyValuePair<string, int>> dbperiod_gradeCount = new List<KeyValuePair<string, int>>();
                    db_school.period.ForEach(z => { dbperiod_gradeCount.Add(new KeyValuePair<string, int>(z.id, z.grades.Count)); });
                    List<string> periodIds = new List<string>();
                    period_gradeCount.ForEach(x =>
                    {
                        var gradeCount = dbperiod_gradeCount.Find(y => x.Key.Equals(y.Key));
                        if (!string.IsNullOrWhiteSpace(gradeCount.Key))
                        {
                            if (gradeCount.Value != x.Value)
                            {
                                periodIds.Add(x.Key);
                            }
                        }
                    });
                    await SchoolService.DoGraduateClasses(_httpTrigger, _azureCosmos, periodIds, school, _option, _dingDing);
                    //变更教师关联的学校基本信息
                    string sql = $"SELECT distinct value(c) FROM c join A1 in c.schools where A1.schoolId='{school.id}'";
                    List<Teacher> teachers = new List<Teacher>();
                    await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIterator<Teacher>(sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey("Base") }))
                    {
                        teachers.Add(item);
                    }

                    foreach (var item in teachers)
                    {
                        Teacher.TeacherSchool teacherSchool = item.schools.Find(x => x.schoolId.Equals(school.id));
                        if (teacherSchool != null)
                        {
                            teacherSchool.name = school.name;
                            teacherSchool.picture = school.picture;
                            teacherSchool.areaId = school.areaId;
                        }
                        await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync(item, item.id, new PartitionKey($"Base"));
                    }
                    schoolInfo = await schoolContainer.UpsertItemAsync(school, new PartitionKey($"Base"));
                }
                else
                {
                    school.code = "Base";
                    schoolInfo = await schoolContainer.CreateItemAsync(school, new PartitionKey($"Base"));
                }

                //创建/修改学校信息中间件
                //_ = _httpTrigger.RequestHttpTrigger(new { school = $"{school}" }, _option.Location, "set-sc-birelation");

                await BIStats.SetSchoolBIRelation(client, blobClient, tableClient, _dingDing, schoolInfo);

                return Ok(new { schoolInfo });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"CoreAPI2，{_option.Location}，school/upsert()\n{ex.Message}\n{ex.StackTrace}\n", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }
        }
        /// <summary>
        /// 查找学校
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        //[AuthToken(Roles = "teacher")]
        [HttpPost("find")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> Find(JsonElement request)
        {
            if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
            var client = _azureCosmos.GetCosmosClient();
            List<School> schools = new();
            var query = $"select c.id,c.pk,c.code, c.name,c.region,c.province,c.city,c.timeZone,c.picture,c.size,c.period,c.campuses from c where c.id ='{school_code}'";
            await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
            {
                using var json = await JsonDocument.ParseAsync(item.ContentStream);

                if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                {
                    foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        schools.Add(obj.ToObject<School>());
                    }
                }
            }

            return Ok(new { schools });
            /* ResponseBuilder builder = ResponseBuilder.custom();

             if (request.TryGetProperty("code", out JsonElement code) &&! string.IsNullOrEmpty(code.ToString()))
             {
                 List<School> sc = await _azureCosmos.FindByDict<School>(request);
                 return builder.Data(sc).build();
             }
             else {
                 return builder.Data(null).build();
             }*/
        }
        /// <summary>
        /// 取得所有學校(只取基本資料)
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-all-school-base")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> GetAllSchoolBaesInfo(JsonElement request)
        {
            var client = _azureCosmos.GetCosmosClient();
            List<object> schools = new();
            await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: $"SELECT c.id, c.code, c.name, c.region, c.province, c.city, c.address, c.picture FROM c ", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Base") }))
            {
                using var json = await JsonDocument.ParseAsync(item.ContentStream);
                if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                {
                    foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        schools.Add(obj.ToObject<object>());
                    }
                }
            }
            return Ok(new { schools });
        }

        /// <summary>
        /// 取得某學校基本資料 
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-school-base")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> GetSchoolBaesInfo(JsonElement request)
        {
            if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();

            var client = _azureCosmos.GetCosmosClient();
            var schoolContainer = client.GetContainer(Constant.TEAMModelOS, "School");
            //取得學校學制、年級、教室
            List<object> classes = new List<object>();
            await foreach (var item in schoolContainer.GetItemQueryStreamIterator(queryText: $"SELECT c.id, c.name, c.gradeId FROM c", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Class-{school_code}") }))
            {
                var jsonc = await JsonDocument.ParseAsync(item.ContentStream);
                foreach (var classeinfo in jsonc.RootElement.GetProperty("Documents").EnumerateArray())
                {
                    dynamic classExtobj = new ExpandoObject();
                    classExtobj.id = classeinfo.GetProperty("id");
                    classExtobj.name = classeinfo.GetProperty("name");
                    classExtobj.gradeId = classeinfo.GetProperty("gradeId");
                    classes.Add(classExtobj);
                }
            }
            List<object> periods = new List<object>();
            List<object> grades = new List<object>();
            var responsesch = await schoolContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey($"Base"));
            if (responsesch.Status == 200)
            {
                var jsons = await JsonDocument.ParseAsync(responsesch.ContentStream);
                if (jsons.RootElement.TryGetProperty("period", out JsonElement periodJobj))
                {
                    foreach (var periodinfo in periodJobj.EnumerateArray())
                    {
                        dynamic periodExtobj = new ExpandoObject();
                        periodExtobj.id = periodinfo.GetProperty("id");
                        periodExtobj.name = periodinfo.GetProperty("name");
                        periods.Add(periodExtobj);
                        if (periodinfo.TryGetProperty("grades", out JsonElement gradesJobj))
                        {
                            foreach (var gradeinfo in gradesJobj.EnumerateArray())
                            {
                                dynamic gradeExtobj = new ExpandoObject();
                                gradeExtobj.id = gradeinfo.GetProperty("id");
                                gradeExtobj.name = gradeinfo.GetProperty("name");
                                gradeExtobj.periodId = periodinfo.GetProperty("id");
                                grades.Add(gradeExtobj);
                            }
                        }
                    }
                }
            }
            return Ok(new { periods, grades, classes });
        }
        /// <summary>
        /// 取得某學校產品購買紀錄
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-school-product")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> GetSchoolProductInfo(JsonElement request)
        {
            try
            {
                if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
                var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
                var r8 = _azureRedis.GetRedisClient(8);

                List<SchoolProductSerial> serial = new(); //承接DB資料用：序號
                List<SerialInfoBaseWithdeviceBoundExt> serialResult = new(); //最後要輸出的序號結果
                List<SchoolProductService> serviceProduct = new(); //承接DB資料用：服務
                List<SchoolProductOrder> serviceOrder = new(); //服務各產品購買紀錄
                List<SchoolProductSumDataService> serviceSum = new(); //服務各產品購買紀錄
                List<SchoolProductHard> hard = new(); //承接DB資料用：硬體
                SchoolProductSum productSum = new(); //承接DB資料用：產品目前狀態 
                List<SchoolProductSumProdInfo> prodinfo = new(); //產品資訊列表(名稱、八碼)
                List<deviceForCoreService> uuidList = new(); //要向CoreService詢問deviceID及硬體資訊的UUID列表
                long UTCNow = DateTimeOffset.UtcNow.ToUnixTimeSeconds();

                ////取得各產品目前可得數量
                var response = await db.ReadItemStreamAsync(school_code.ToString(), new PartitionKey($"ProductSum"));
                if (response.Status == 200)
                {
                    using var json = await JsonDocument.ParseAsync(response.ContentStream);
                    productSum = json.ToObject<SchoolProductSum>();
                    prodinfo = productSum.prodinfo;
                    serviceSum = productSum.service;
                }

                //軟體
                List<string> serialPermitList = getSerialPermitProdcodeList();
                string serialPermitJsonStr = JsonConvert.SerializeObject(serialPermitList);
                string serialQueryText = $"SELECT * FROM c WHERE c.dataType = 'serial' AND ARRAY_CONTAINS({serialPermitJsonStr}, c.prodCode)";
                await foreach (var itemsr in db.GetItemQueryStreamIterator(queryText: serialQueryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
                {
                    using var json = await JsonDocument.ParseAsync(itemsr.ContentStream);
                    if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                    {
                        deviceForCoreService uuidForCore;
                        foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                        {
                            serial.Add(obj.ToObject<SchoolProductSerial>());
                            if (obj.TryGetProperty("deviceBound", out JsonElement deviceBoundJobj) && !string.IsNullOrWhiteSpace(deviceBoundJobj.ToString()))
                            {
                                foreach (var deviceBoundTmpRow in deviceBoundJobj.EnumerateArray())
                                {
                                    uuidForCore = new deviceForCoreService();
                                    uuidForCore.sn = (!string.IsNullOrWhiteSpace(Convert.ToString(obj.GetProperty("serial")))) ? Convert.ToString(obj.GetProperty("serial")) : null;
                                    uuidForCore.uuid1 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("uuid")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("uuid")) : null;
                                    uuidForCore.uuid2 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("uuid2")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("uuid2")) : null;
                                    //uuidForCore.device_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("deviceId")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("deviceId")) : null;
                                    uuidForCore.device_id = null; //[2023.6.9]迴避帶deviceId向CS取得device時資訊會重複問題
                                    uuidForCore.class_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("classId")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("classId")) : null;
                                    uuidList.Add(uuidForCore);
                                }
                            }
                        }
                    }
                }
                ////取得DeviceInfo From Core 並更新序號資料
                List<deviceFromCoreService> coreUuidList = (List<deviceFromCoreService>)GetDeviceFromCoreAsync(uuidList).GetAwaiter().GetResult();
                List<deviceBoundExt> deviceBoundArray;
                List<deviceFromCoreService> coreUuid;
                deviceForCoreService deviceBoundRow;
                deviceBoundExt deviceBoundExt;
                deviceBound serialDeviceBoundRow;
                SerialInfoBaseWithdeviceBoundExt serialResultRow;
                List<SchoolProductSerial> updSchoolProductSerialList = new List<SchoolProductSerial>(); //更新學校產品序號用
                foreach (SchoolProductSerial serialRow in serial)
                {
                    deviceBoundArray = new List<deviceBoundExt>();
                    coreUuid = coreUuidList
                           .Where((deviceFromCoreService x) => x.sn == serialRow.serial)
                           .ToList();
                    foreach (deviceFromCoreService deviceRow in coreUuid)
                    {
                        if (!string.IsNullOrWhiteSpace(deviceRow.uuid1) || !string.IsNullOrWhiteSpace(deviceRow.uuid2) || !string.IsNullOrWhiteSpace(deviceRow.device_id)) //uuid1、uuid2、device_id 任一欄有值
                        {
                            //前端顯示用
                            deviceBoundRow = uuidList.Where(u => u.sn == deviceRow.sn && u.uuid1 == deviceRow.uuid1 && u.uuid2 == deviceRow.uuid2).FirstOrDefault();
                            deviceBoundExt = new deviceBoundExt();
                            deviceBoundExt.uuid = deviceBoundRow.uuid1;
                            deviceBoundExt.uuid2 = deviceBoundRow.uuid2;
                            deviceBoundExt.classId = deviceBoundRow.class_id;
                            deviceBoundExt.deviceId = deviceRow.device_id;
                            deviceBoundExt.os = deviceRow.os;
                            deviceBoundExt.ip = deviceRow.local_ip;
                            deviceBoundExt.cpu = deviceRow.cpu;
                            deviceBoundExt.pcname = deviceRow.pc_name;
                            deviceBoundExt.osver = deviceRow.os_ver;
                            deviceBoundArray.Add(deviceBoundExt);
                            //DB更新用序號資料：比對IES5序號硬體列 與 CS拿到的硬體列，若吻合者將IES5序號硬體列的deviceId寫入
                            //比對法： [IES5]UUID1==[CS]UUID2 || [IES5]UUID2==[CS]UUID1 ※null與空白算為相同
                            serialDeviceBoundRow = serialRow.deviceBound.Where(d =>
                                ((d.uuid == deviceBoundRow.uuid1 || (string.IsNullOrEmpty(d.uuid) && string.IsNullOrEmpty(deviceBoundRow.uuid1))) && (d.uuid2 == deviceBoundRow.uuid2 || (string.IsNullOrEmpty(d.uuid2) && string.IsNullOrEmpty(deviceBoundRow.uuid2)))) ||
                                ((d.uuid == deviceBoundRow.uuid2 || (string.IsNullOrEmpty(d.uuid) && string.IsNullOrEmpty(deviceBoundRow.uuid2))) && (d.uuid2 == deviceBoundRow.uuid1 || (string.IsNullOrEmpty(d.uuid2) && string.IsNullOrEmpty(deviceBoundRow.uuid1))))
                            ).FirstOrDefault();
                            if (serialDeviceBoundRow != null)
                            {
                                serialDeviceBoundRow.deviceId = deviceRow.device_id;
                            }
                        }
                    }
                    if (deviceBoundArray.Count.Equals(0)) //無法取得CS的硬體資訊，則用序號的硬體資訊帶入
                    {
                        if (serialRow.deviceBound != null)
                        {
                            foreach (deviceBound serialRowDeviceBound in serialRow.deviceBound)
                            {
                                if (!string.IsNullOrEmpty(serialRowDeviceBound.uuid) || !string.IsNullOrEmpty(serialRowDeviceBound.uuid2))
                                {
                                    deviceBoundExt = new deviceBoundExt();
                                    deviceBoundExt.uuid = serialRowDeviceBound.uuid;
                                    deviceBoundExt.uuid2 = serialRowDeviceBound.uuid2;
                                    deviceBoundExt.classId = serialRowDeviceBound.classId;
                                    deviceBoundExt.deviceId = serialRowDeviceBound.deviceId;
                                    deviceBoundArray.Add(deviceBoundExt);
                                }
                            }
                        }
                    }
                    //序號更新
                    updSchoolProductSerialList.Add(serialRow);
                    //await db.ReplaceItemAsync<SchoolProductSerial>(serialRow, serialRow.id, new PartitionKey($"Product-{school_code}"));

                    //回傳值
                    serialResultRow = new SerialInfoBaseWithdeviceBoundExt();
                    serialResultRow.code = serialRow.code;
                    serialResultRow.id = serialRow.id;
                    serialResultRow.dataType = serialRow.dataType;
                    serialResultRow.serial = serialRow.serial;
                    serialResultRow.prodCode = serialRow.prodCode;
                    serialResultRow.clientQty = serialRow.clientQty;
                    serialResultRow.orderDate = serialRow.orderDate;
                    serialResultRow.regDate = serialRow.regDate;
                    serialResultRow.startDate = serialRow.startDate;
                    serialResultRow.endDate = serialRow.endDate;
                    serialResultRow.deviceMax = serialRow.deviceMax;
                    serialResultRow.expireStatus = serialRow.expireStatus;
                    serialResultRow.status = serialRow.status;
                    serialResultRow.deviceBound = deviceBoundArray;
                    if (serialRow.aprule != null)
                    {
                        string apruleJsonString = serialRow.aprule.ToJsonString();
                        var apruleDc = JsonDocument.Parse(apruleJsonString);
                        serialResultRow.aprule = (apruleDc.RootElement.TryGetProperty("json", out JsonElement apruleJson)) ? apruleJson : null;
                    }
                    else serialResultRow.aprule = null;
                    serialResult.Add(serialResultRow);
                }

                //服務
                List<SchoolProductSumDataService> service = new List<SchoolProductSumDataService>();
                SchoolProductSum schoolProductSum;
                await foreach (var items in db.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.id = '{school_code}'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProductSum") }))
                {
                    using var json = await JsonDocument.ParseAsync(items.ContentStream);
                    if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                    {
                        foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                        {
                            schoolProductSum = obj.ToObject<SchoolProductSum>();
                            service = schoolProductSum.service;
                        }
                    }
                }
                if (service.Count > 0)
                {
                    SchoolProductOrder spOrderRow;
                    foreach (SchoolProductSumDataService serviceRow in service)
                    {
                        spOrderRow = new SchoolProductOrder();
                        spOrderRow.prodCode = serviceRow.prodCode;
                        spOrderRow.avaliable = serviceRow.avaliable;
                        spOrderRow.avaliableStartDate = serviceRow.startDate;
                        spOrderRow.avaliableEndDate = serviceRow.endDate;
                        serviceOrder.Add(spOrderRow);
                    }
                }

                #region 產品購買履歷廢除部分
                ////(服務)取得各產品購買履歷
                //await foreach (var itemsv in clientContainer.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.dataType = 'service'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
                //{
                //    using var json = await JsonDocument.ParseAsync(itemsv.ContentStream);
                //    if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                //    {
                //        foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                //        {
                //            SchoolProductService serviceProductRow = obj.ToObject<SchoolProductService>();
                //            serviceProduct.Add(serviceProductRow);
                //        }
                //    }
                //}
                ////(服務)產品購買履歷整形
                //IEnumerable<SchoolProductService> serviceProductOrder = serviceProduct.OrderBy(sp => sp.startDate);
                //foreach (SchoolProductService serviceProductRow in serviceProduct)
                //{
                //    //取得此產品現在可用數
                //    SchoolProductSumDataService serviceSumNow = serviceSum.Where(ss => ss.prodCode.Equals(serviceProductRow.prodCode)).FirstOrDefault();
                //    int serviceAvaliableNow = (serviceSumNow != null) ? serviceSumNow.avaliable : 0;
                //    long serviceAvaliableStartDate = (serviceSumNow != null) ? serviceSumNow.startDate : 0;
                //    long serviceAvaliableEndDate = (serviceSumNow != null) ? serviceSumNow.endDate : 0;
                //    //取得此產品購買履歷
                //    SchoolProductOrder serviceOrderNow = serviceOrder.Where(so => so.prodCode == serviceProductRow.prodCode).FirstOrDefault();
                //    if (serviceOrderNow == null) //無此產品項
                //    {
                //        SchoolProductOrder serviceOrderRow = new SchoolProductOrder();
                //        serviceOrderRow.prodCode = serviceProductRow.prodCode;
                //        serviceOrderRow.order = new List<SchoolProductOrderList>();
                //        SchoolProductOrderList serviceOrderRowOrderList = new SchoolProductOrderList();
                //        serviceOrderRowOrderList.id = serviceProductRow.id;
                //        serviceOrderRowOrderList.orderDate = serviceProductRow.orderDate;
                //        serviceOrderRowOrderList.startDate = serviceProductRow.startDate;
                //        serviceOrderRowOrderList.endDate = serviceProductRow.endDate;
                //        serviceOrderRowOrderList.number = serviceProductRow.number;
                //        serviceOrderRowOrderList.unit = serviceProductRow.unit;
                //        serviceOrderRow.order.Add(serviceOrderRowOrderList);
                //        serviceOrderRow.avaliable = serviceAvaliableNow;
                //        serviceOrderRow.avaliableStartDate = serviceAvaliableStartDate;
                //        serviceOrderRow.avaliableEndDate = serviceAvaliableEndDate;
                //        serviceOrder.Add(serviceOrderRow);
                //    }
                //    else //有此產品項 => 看是否有此購買紀錄
                //    {
                //        //記入可用起始終止日
                //        serviceOrderNow.avaliableStartDate = serviceAvaliableStartDate;
                //        serviceOrderNow.avaliableEndDate = serviceAvaliableEndDate;
                //        //記入購買紀錄
                //        SchoolProductOrderList SchoolProductOrderListNow = serviceOrderNow.order.Where(Sol => Sol.id.Equals(serviceProductRow.id)).FirstOrDefault();
                //        if (SchoolProductOrderListNow == null) //無此購買紀錄
                //        {
                //            SchoolProductOrderList serviceOrderRowOrderList = new SchoolProductOrderList();
                //            serviceOrderRowOrderList.id = serviceProductRow.id;
                //            serviceOrderRowOrderList.orderDate = serviceProductRow.orderDate;
                //            serviceOrderRowOrderList.startDate = serviceProductRow.startDate;
                //            serviceOrderRowOrderList.endDate = serviceProductRow.endDate;
                //            serviceOrderRowOrderList.number = serviceProductRow.number;
                //            serviceOrderRowOrderList.unit = serviceProductRow.unit;
                //            serviceOrderNow.order.Add(serviceOrderRowOrderList);
                //        }
                //    }
                //}
                #endregion

                //硬體
                await foreach (var itemhd in db.GetItemQueryStreamIterator(queryText: $"SELECT * FROM c WHERE c.dataType = 'hard'", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
                {
                    using var json = await JsonDocument.ParseAsync(itemhd.ContentStream);
                    if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                    {
                        foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                        {
                            hard.Add(obj.ToObject<SchoolProductHard>());
                        }
                    }
                }

                //空間計算
                ////取得教師分配空間
                long teach = 0;
                var querysp = $"SELECT SUM(c.size) as size FROM c";
                await foreach (var item in db.GetItemQueryStreamIterator(queryText: querysp, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
                {
                    var jsonts = await JsonDocument.ParseAsync(item.ContentStream);
                    foreach (var obj in jsonts.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        teach = obj.GetProperty("size").GetInt64() * 1073741824; //G換算
                    }
                }
                ////學校已使用空間
                long blobsize = 0;
                RedisValue value = default;
                value = r8.HashGet($"Blob:Record", $"{school_code}");
                if (value != default && !value.IsNullOrEmpty)
                {
                    JsonElement record = value.ToString().ToObject<JsonElement>();
                    if (record.TryGetInt64(out blobsize))
                    {
                    }
                }
                ////各項空間數值取得
                Dictionary<string, double> catalog = new();
                SortedSetEntry[] Scores = _azureRedis.GetRedisClient(8).SortedSetRangeByScoreWithScores($"Blob:Catalog:{school_code}");
                if (Scores != null)
                {
                    foreach (var score in Scores)
                    {
                        double val = score.Score;
                        string key = score.Element.ToString();
                        catalog.Add(key, val);
                    }
                }
                dynamic space = new ExpandoObject();
                space.size = blobsize;
                space.teach = teach;
                space.catalog = catalog;

                //取得購買紀錄
                List<object> order = await GetOrderHisFromCoreBBAsync(school_code.GetString());

                //取得CC授權使用狀態
                var hashs = await r8.HashGetAllAsync($"CC:License:{school_code.GetString()}");
                var ccuser = hashs.Select(x => JsonDocument.Parse(x.Value.ToString())).ToList();

                //更新學校產品序號
                _ = UpdupdSchoolProductSerialListAsync(updSchoolProductSerialList, school_code.GetString());
                return Ok(new { serial = serialResult, service = serviceOrder, hard, space, order, ccuser });
            }
            catch (Exception ex)
            {
                return BadRequest();
            }
        }

        [ProducesDefaultResponseType]
        [HttpPost("get-teach-count")]
        //[AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> GetTeacCount(JsonElement request)
        {
            try
            {
                if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
                var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
                var r8 = _azureRedis.GetRedisClient(8);

                List<SchoolProductSerial> serial = new(); //承接DB資料用：序號
                List<deviceForCoreService> uuidList = new(); //要向CoreService詢問deviceID及硬體資訊的UUID列表
                long UTCNow = DateTimeOffset.UtcNow.ToUnixTimeSeconds();

                //軟體
                List<string> serialPermitList = getSerialPermitProdcodeList();
                string serialPermitJsonStr = JsonConvert.SerializeObject(serialPermitList);
                string serialQueryText = $"SELECT * FROM c WHERE c.dataType = 'serial' AND ARRAY_CONTAINS({serialPermitJsonStr}, c.prodCode)";
                await foreach (var itemsr in db.GetItemQueryStreamIterator(queryText: serialQueryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school_code}") }))
                {
                    using var json = await JsonDocument.ParseAsync(itemsr.ContentStream);
                    if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                    {
                        deviceForCoreService uuidForCore;
                        foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                        {
                            serial.Add(obj.ToObject<SchoolProductSerial>());
                            if (obj.TryGetProperty("deviceBound", out JsonElement deviceBoundJobj) && !string.IsNullOrWhiteSpace(deviceBoundJobj.ToString()))
                            {
                                foreach (var deviceBoundTmpRow in deviceBoundJobj.EnumerateArray())
                                {
                                    uuidForCore = new deviceForCoreService
                                    {
                                        sn = (!string.IsNullOrWhiteSpace(Convert.ToString(obj.GetProperty("serial")))) ? Convert.ToString(obj.GetProperty("serial")) : null,
                                        uuid1 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("uuid")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("uuid")) : null,
                                        uuid2 = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("uuid2")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("uuid2")) : null,
                                        device_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("deviceId")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("deviceId")) : null,
                                        class_id = (!string.IsNullOrWhiteSpace(Convert.ToString(deviceBoundTmpRow.GetProperty("classId")))) ? Convert.ToString(deviceBoundTmpRow.GetProperty("classId")) : null
                                    };
                                    uuidList.Add(uuidForCore);
                                }
                            }
                        }
                    }
                }
                ////取得DeviceInfo From Core 並更新序號資料
                List<deviceFromCoreService> coreUuidList = (List<deviceFromCoreService>)GetDeviceFromCoreAsync(uuidList).GetAwaiter().GetResult();
                List<deviceBoundExt> deviceBoundArray;
                List<deviceBoundExt> counts = new();
                List<deviceFromCoreService> coreUuid;
                deviceForCoreService deviceBoundRow;
                deviceBoundExt deviceBoundExt;
                List<SchoolProductSerial> updSchoolProductSerialList = new List<SchoolProductSerial>(); //更新學校產品序號用
                foreach (SchoolProductSerial serialRow in serial)
                {
                    deviceBoundArray = new List<deviceBoundExt>();
                    coreUuid = coreUuidList
                           .Where((deviceFromCoreService x) => x.sn == serialRow.serial)
                           .ToList();
                    foreach (deviceFromCoreService deviceRow in coreUuid)
                    {
                        if (!string.IsNullOrWhiteSpace(deviceRow.uuid1) || !string.IsNullOrWhiteSpace(deviceRow.uuid2) || !string.IsNullOrWhiteSpace(deviceRow.device_id)) //uuid1、uuid2、device_id 任一欄有值
                        {
                            //前端顯示用
                            deviceBoundRow = uuidList.Where(u => u.sn == deviceRow.sn && u.uuid1 == deviceRow.uuid1 && u.uuid2 == deviceRow.uuid2).FirstOrDefault();
                            deviceBoundExt = new deviceBoundExt
                            {
                                uuid = deviceBoundRow.uuid1,
                                uuid2 = deviceBoundRow.uuid2,
                                classId = deviceBoundRow.class_id,
                                deviceId = deviceRow.device_id,
                                os = deviceRow.os,
                                ip = deviceRow.local_ip,
                                cpu = deviceRow.cpu,
                                pcname = deviceRow.pc_name,
                                osver = deviceRow.os_ver
                            };
                            deviceBoundArray.Add(deviceBoundExt);
                        }
                    }
                    if (deviceBoundArray.Count.Equals(0)) //無法取得CS的硬體資訊，則用序號的硬體資訊帶入
                    {
                        if (serialRow.deviceBound != null)
                        {
                            foreach (deviceBound serialRowDeviceBound in serialRow.deviceBound)
                            {
                                if (!string.IsNullOrEmpty(serialRowDeviceBound.uuid) || !string.IsNullOrEmpty(serialRowDeviceBound.uuid2))
                                {
                                    deviceBoundExt = new deviceBoundExt
                                    {
                                        uuid = serialRowDeviceBound.uuid,
                                        uuid2 = serialRowDeviceBound.uuid2,
                                        classId = serialRowDeviceBound.classId,
                                        deviceId = serialRowDeviceBound.deviceId
                                    };
                                    deviceBoundArray.Add(deviceBoundExt);
                                }
                            }
                        }
                    }
                    //序號更新
                    //updSchoolProductSerialList.Add(serialRow);
                    counts.AddRange(deviceBoundArray);
                    //await db.ReplaceItemAsync<SchoolProductSerial>(serialRow, serialRow.id, new PartitionKey($"Product-{school_code}"));
                }
                //取得CC授權使用狀態
                var hashs = await r8.HashGetAllAsync($"CC:License:{school_code.GetString()}");
                var ccuser = hashs.Select(x => JsonDocument.Parse(x.Value.ToString())).ToList();

                //更新學校產品序號
                //_ = UpdupdSchoolProductSerialListAsync(updSchoolProductSerialList, school_code.GetString());
                double Teachs = counts.Count + ccuser.Count;
                return Ok(new { Teachs });
            }
            catch (Exception ex)
            {
                return BadRequest();
            }
        }

        //集體變更學校序號產品 (效能增進對策)
        private async Task UpdupdSchoolProductSerialListAsync(List<SchoolProductSerial> serialList, string schoolCode)
        {
            var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
            foreach (SchoolProductSerial serialRow in serialList)
            {
                await db.ReplaceItemAsync<SchoolProductSerial>(serialRow, serialRow.id, new PartitionKey($"Product-{schoolCode}"));
            }
        }

        /// <summary>
        /// 取得CoreDevice資訊
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        private async Task<List<deviceFromCoreService>> GetDeviceFromCoreAsync(List<deviceForCoreService> uuidList)
        {
            List<deviceFromCoreService> result = new List<deviceFromCoreService>();
            try
            {
                string url = _configuration.GetValue<string>("HaBookAuth:CoreService:deviceinfo");
                string AccessToken = await getCoreAccessToken();
                var client = _httpClient.CreateClient();
                client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
                string uuidListJson = JsonConvert.SerializeObject(uuidList);
                var content = new StringContent(uuidListJson, Encoding.UTF8, "application/json");
                HttpResponseMessage responseMessage = await client.PostAsync(url, content);
                if (responseMessage.StatusCode == HttpStatusCode.OK)
                {
                    string responseBody = responseMessage.Content.ReadAsStringAsync().Result;
                    result = System.Text.Json.JsonSerializer.Deserialize<List<deviceFromCoreService>>(responseBody.ToString());
                }
                return result;
            }
            catch (Exception ex)
            {
                return result;
            }
        }

        /// <summary>
        /// 取得CoreBB學校訂單履歷資訊
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        private async Task<List<object>> GetOrderHisFromCoreBBAsync(string schoolCode)
        {
            List<object> result = new List<object>();
            try
            {
                string url = _configuration.GetValue<string>("HaBookAuth:CoreBBAPI") + "/ies5/get-school-order";
                string AccessToken = await getCoreAccessToken();
                var client = _httpClient.CreateClient();
                client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
                string paramJson = JsonConvert.SerializeObject(new { school_code = schoolCode });
                var content = new StringContent(paramJson, Encoding.UTF8, "application/json");
                HttpResponseMessage responseMessage = await client.PostAsync(url, content);
                if (responseMessage.StatusCode == HttpStatusCode.OK)
                {
                    string responseBody = responseMessage.Content.ReadAsStringAsync().Result;
                    result = System.Text.Json.JsonSerializer.Deserialize<List<object>>(responseBody.ToString());
                }
                return result;
            }
            catch (Exception ex)
            {
                return result;
            }
        }

        private async Task<string> getCoreAccessToken()
        {
            string AccessToken = "";
            try
            {
                string Url = _configuration.GetValue<string>("HaBookAuth:CoreAPI") + "/oauth2/token";
                string GrantType = "device";
                string ClientID = _configuration.GetValue<string>("HaBookAuth:CoreService:clientID");
                string Secret = _configuration.GetValue<string>("HaBookAuth:CoreService:clientSecret");
                var content = new { grant_type = GrantType, client_id = ClientID, client_secret = Secret };
                var response = await _httpClient.CreateClient().PostAsJsonAsync($"{Url}", content);
                if (response.IsSuccessStatusCode)
                {
                    string responseBody = response.Content.ReadAsStringAsync().Result;
                    using (JsonDocument document = JsonDocument.Parse(responseBody.ToString()))
                    {
                        if (document.RootElement.TryGetProperty("access_token", out JsonElement AccessTokenObj))
                        {
                            AccessToken = AccessTokenObj.ToString();
                        }
                    }
                }
                return AccessToken;
            }
            catch (Exception ex)
            {
                return AccessToken;
            }
        }

        /// <summary>
        /// 計算各產品的初始結束時間及可用數
        /// </summary>
        /// <param name="mainPeriodList">active的主周期</param>
        /// <param name="periodList">附屬周期</param>
        /// <param name="serviceProduct">產品資訊</param>
        /// <returns></returns>
        private ServiceProductResult CalServiceProductAuth(List<ServiceMainPeriod> mainPeriodList, List<ServicePeriod> periodList, ServiceProduct serviceProduct)
        {
            periodZone periodZoneResult = new periodZone();
            List<periodZone> periodZone = new List<periodZone>();
            //篩選出產品有的副週期
            List<string> existPeriodIdList = new List<string>();
            if (serviceProduct.auth.Count > 0)
            {
                foreach (ServiceProductAuth serviceProductAuthRow in serviceProduct.auth)
                {
                    if (!string.IsNullOrWhiteSpace(serviceProductAuthRow.periodId) && !existPeriodIdList.Contains(serviceProductAuthRow.periodId))
                    {
                        existPeriodIdList.Add(serviceProductAuthRow.periodId);
                    }
                }
            }
            List<ServicePeriod> periodOrder = periodList.Where(p => existPeriodIdList.Contains(p.periodId)).OrderBy(p => Int32.Parse(p.periodId)).ToList();

            //combine period
            if (periodOrder.Count() > 0)
            {

                //篩選出主週期(複數active主週期對策) ※最終篩出唯一一組 篩選原則：(1)由此產品有的副週期ID篩出 (2)若還有複數筆，則期間長者勝出
                List<string> existMainPeriodIdList = new List<string>();
                foreach (ServicePeriod periodRow in periodOrder)
                {
                    if (!existMainPeriodIdList.Contains(periodRow.mainPeriodId))
                    {
                        existMainPeriodIdList.Add(periodRow.mainPeriodId);
                    }
                }
                ServiceMainPeriod mainPeriod = mainPeriodList.Where(w => existMainPeriodIdList.Contains(w.mainPeriodId)).OrderByDescending(w => w.endDate - w.startDate).First();
                List<ServicePeriod> periods = periodOrder.Where(p => p.mainPeriodId == mainPeriod.mainPeriodId).ToList();

                //combine period，compare to mainPeriod start, end
                periodZone = combinePeriodZone(periods);
                periodZoneResult.startDate = (periodZone[0].startDate > mainPeriod.startDate) ? periodZone[0].startDate : mainPeriod.startDate;
                periodZoneResult.endDate = (periodZone[0].endDate < mainPeriod.endDate) ? periodZone[0].endDate : mainPeriod.endDate;
            }

            //return
            ServiceProductResult serviceProductResult = new ServiceProductResult();
            if ((serviceProduct.noperiod && periodZoneResult.startDate == 0 && periodZoneResult.endDate == 0) || (!serviceProduct.noperiod && periodZoneResult.startDate > 0 && periodZoneResult.endDate > 0))
            {
                serviceProductResult.prodCode = serviceProduct.prodCode;
                serviceProductResult.noperiod = serviceProduct.noperiod;
                serviceProductResult.serviceType = serviceProduct.serviceType;
                serviceProductResult.startDate = periodZoneResult.startDate;
                serviceProductResult.endDate = periodZoneResult.endDate;
                serviceProductResult.avaliable = serviceProduct.avaliable;
            }

            return serviceProductResult;
        }

        /// <summary>
        /// 軟體序號解綁API
        /// </summary>
        /// <param name="id_token">ID Token</param>
        /// <param name="uuid">硬體識別碼1</param>
        /// <param name="uuid2">硬體識別碼2</param>
        /// <param name="serial">產品資訊</param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("unbind-serial")]
        [Authorize(Roles = "IES")]
        [AuthToken(Roles = "admin,teacher")]
        public async Task<IActionResult> UnbindSerial(JsonElement request)
        {
            try
            {
                //輸入參數
                if (!request.TryGetProperty("serial", out JsonElement serialJson)) return BadRequest();
                var (id, name, _, _) = HttpContext.GetAuthTokenInfo(); //取得IDToken資訊

                request.TryGetProperty("uuid", out JsonElement uuidJson);
                request.TryGetProperty("uuid2", out JsonElement uuid2Json);
                string serial = serialJson.ToString();
                string uuid = uuidJson.ToString();
                string uuid2 = uuid2Json.ToString();
                if (string.IsNullOrEmpty(serial) && (string.IsNullOrEmpty(uuid) || string.IsNullOrEmpty(uuid2)))
                {
                    return BadRequest();
                }
                string lang = "en-US";
                var content = new
                {
                    lang = lang,
                    serial = serial,
                    uuid = uuid,
                    uuid2 = uuid2,
                    olduuid = "",
                    pcname = "",
                    dp = "IES5",
                    user = new
                    {
                        id = $"{id}",
                        name = $"{name}"
                    }
                };

                //呼叫BB解綁API
                object result = new { };
                bool unbindFlg = false; //解綁是否成功 true:成功 false:失敗
                string url = _configuration.GetValue<string>("HaBookAuth:CoreBBAPI") + "/bbauthapi/srunbind";
                string AccessToken = await getCoreAccessToken();
                var client = _httpClient.CreateClient();
                client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
                HttpResponseMessage response = await client.PostAsJsonAsync(url, content);
                if (response.StatusCode == HttpStatusCode.OK)
                {
                    string responseBody = await response.Content.ReadAsStringAsync();
                    //result = System.Text.Json.JsonSerializer.Deserialize<object>(responseBody.ToString());
                    var unbindResult = JsonDocument.Parse(responseBody);
                    unbindResult.RootElement.TryGetProperty("status", out JsonElement statusJson);
                    int status = statusJson.GetInt32();
                    unbindResult.RootElement.TryGetProperty("error", out JsonElement errorJson);
                    string error = errorJson.GetString();
                    if (unbindResult.RootElement.TryGetProperty("prod", out JsonElement prodJson))
                    {
                        if (!prodJson.ValueKind.Equals(JsonValueKind.Null))
                        {
                            if (prodJson.TryGetProperty("auth_unbind_req", out JsonElement unbindReqJson))
                            {
                                if (!unbindReqJson.ValueKind.Equals(JsonValueKind.Undefined) && !unbindReqJson.ValueKind.Equals(JsonValueKind.Null))
                                {
                                    unbindFlg = true;
                                }
                            }
                        }
                    }
                    result = (unbindFlg) ? new { status = 0, error = "" } : new { status = status, error = error };
                }
                else
                {
                    result = new
                    {
                        status = 1,
                        error = $"Unbind serial: {serial} fail."
                    };
                }
                return Ok(result);
            }
            catch (Exception ex)
            {
                return BadRequest();
            }
        }

        [ProducesDefaultResponseType]
        [HttpPost("get-auth-hitcc")]
        [Authorize(Roles = "IES")]
        public async Task<IActionResult> GetHiteachCCAuth(JsonElement request)
        {
            if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
            var db = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
            var r8 = _azureRedis.GetRedisClient(8);
            long now = DateTimeOffset.UtcNow.ToUnixTimeSeconds();
            //取得HiTeachCC的有效授權
            int avaliable = 0;
            int dmax = 0;
            int client = 0;
            await foreach (var item in db.GetItemQueryStreamIterator($"SELECT c.clientQty, c.deviceMax FROM c WHERE c.prodCode='LZLL6ZEI' AND (c.endDate >= {now} OR c.endDate = 0)",
                requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Product-{school_code}") }))
            {
                var json = await JsonDocument.ParseAsync(item.ContentStream);
                if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                {
                    foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        dmax = obj.GetProperty("deviceMax").GetInt32();
                        client = obj.GetProperty("clientQty").GetInt32();
                    }
                }
            }
            //取得CC授權使用狀態
            var hashs = await r8.HashGetAllAsync($"CC:License:{school_code.GetString()}");
            var ccuser = hashs.Select(x => JsonDocument.Parse(x.Value.ToString())).ToList();
            avaliable = dmax - ccuser.Count;

            return Ok(new { dmax = dmax, client = client, avaliable = avaliable, ccuser = ccuser });
        }

        /// <summary>
        /// 計算各產品的購買歷史紀錄 [舊制，不使用]
        /// </summary>
        /// <param name="mainPeriodList">所有的主周期</param>
        /// <param name="periodList">所有附屬周期</param>
        /// <param name="serviceProduct">產品資訊</param>
        /// <returns></returns>
        private List<ServiceProductAuthHistoryStartEnd> CalServiceProductOrderHistory(List<ServiceMainPeriod> mainPeriodList, List<ServicePeriod> periodList, ServiceProduct serviceProduct)
        {
            List<ServiceProductAuthHistoryStartEnd> serviceProductOrderStartEndList = new List<ServiceProductAuthHistoryStartEnd>();

            //GROUP BY orderId
            if (serviceProduct.auth.Count > 0)
            {
                List<ServiceProductAuthHistory> serviceProductOrderList = new List<ServiceProductAuthHistory>();
                foreach (ServiceProductAuth serviceProductAuthRow in serviceProduct.auth)
                {
                    ServiceProductAuthHistory existServiceProductAuthHistory = serviceProductOrderList.Where(a => a.orderId == serviceProductAuthRow.orderId).FirstOrDefault();
                    if (existServiceProductAuthHistory != null)
                    {
                        if (!existServiceProductAuthHistory.periodIdList.Contains(serviceProductAuthRow.periodId))
                        {
                            existServiceProductAuthHistory.periodIdList.Add(serviceProductAuthRow.periodId);
                        }
                    }
                    else
                    {
                        ServiceProductAuthHistory serviceProductAuthHistoryRow = new ServiceProductAuthHistory();
                        serviceProductAuthHistoryRow.orderId = serviceProductAuthRow.orderId;
                        int y = Int32.Parse(serviceProductAuthRow.orderId.Substring(0, 4));
                        int m = Int32.Parse(serviceProductAuthRow.orderId.Substring(4, 2));
                        int d = Int32.Parse(serviceProductAuthRow.orderId.Substring(6, 2));
                        serviceProductAuthHistoryRow.orderDate = new DateTimeOffset(y, m, d, 0, 0, 0, TimeSpan.Zero).ToUnixTimeSeconds();
                        serviceProductAuthHistoryRow.number = serviceProductAuthRow.number;
                        serviceProductAuthHistoryRow.unit = serviceProductAuthRow.unit;
                        serviceProductAuthHistoryRow.periodIdList = new List<string>();
                        serviceProductAuthHistoryRow.periodIdList.Add(serviceProductAuthRow.periodId);
                        serviceProductOrderList.Add(serviceProductAuthHistoryRow);
                    }
                }

                foreach (ServiceProductAuthHistory serviceProductOrderRow in serviceProductOrderList)
                {
                    ServiceProductAuthHistoryStartEnd ServiceProductAuthHistoryStartEndRow = new ServiceProductAuthHistoryStartEnd();
                    //combine period
                    List<ServicePeriod> periodOrder = periodList.Where((ServicePeriod x) => serviceProductOrderRow.periodIdList.Contains(x.periodId)).OrderBy(p => Int32.Parse(p.periodId)).ToList();
                    List<periodZone> periodZone = combinePeriodZone(periodOrder);
                    ServiceProductAuthHistoryStartEndRow.startDate = periodZone[0].startDate;
                    ServiceProductAuthHistoryStartEndRow.endDate = periodZone[0].endDate;
                    ServiceProductAuthHistoryStartEndRow.orderId = serviceProductOrderRow.orderId;
                    ServiceProductAuthHistoryStartEndRow.orderDate = serviceProductOrderRow.orderDate;
                    ServiceProductAuthHistoryStartEndRow.number = serviceProductOrderRow.number;
                    ServiceProductAuthHistoryStartEndRow.unit = serviceProductOrderRow.unit;
                    serviceProductOrderStartEndList.Add(ServiceProductAuthHistoryStartEndRow);
                }
            }
            //return
            return serviceProductOrderStartEndList;
        }

        //子週期合併開始結束時間
        private List<periodZone> combinePeriodZone(List<ServicePeriod> periods)
        {
            List<periodZone> periodZone = new List<periodZone>();
            foreach (ServicePeriod periodRow in periods)
            {
                if (periodZone.Count == 0)
                {
                    periodZone periodZoneNew = new periodZone();
                    periodZoneNew.startDate = periodRow.startDate;
                    periodZoneNew.endDate = periodRow.endDate;
                    periodZone.Add(periodZoneNew);
                }
                else
                {
                    bool zoneExistFlg = false;
                    for (int i = 0; i < periodZone.Count; i++) //考慮到副週期可能斷成數個block，整合後取第一個
                    {
                        if (periodRow.startDate <= periodZone[i].endDate + 10 && periodZone[i].endDate + 10 < periodRow.endDate)
                        {
                            periodZone[i].endDate = periodRow.endDate;
                            zoneExistFlg = true;
                        }
                        else if (periodZone[i].startDate <= periodRow.endDate + 10 && periodRow.endDate + 10 < periodZone[i].endDate)
                        {
                            periodZone[i].startDate = periodRow.startDate;
                            zoneExistFlg = true;
                        }
                    }
                    if (!zoneExistFlg)
                    {
                        periodZone periodZoneNew = new periodZone();
                        periodZoneNew.startDate = periodRow.startDate;
                        periodZoneNew.endDate = periodRow.endDate;
                        periodZone.Add(periodZoneNew);
                    }
                }
            }
            return periodZone;
        }
        /*
        /// <summary>
        /// 取得某學校AClassOne授權及使用資料 
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        /// 目前產品DB樣式未定，暫時依照舊樣式建構
        [ProducesDefaultResponseType]
        [HttpPost("get-school-aclassone")]
        public async Task<IActionResult> GetSchoolAclassoneInfo(JsonElement request)
        {
            if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();

            var clientContainer = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
            var response = await clientContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey("Product"));
            int total = 0; //可分配總數
            int staNum = 0; //固定分配數
            int dyncNum = 0; //動態分配數
            List<string> staIds = new List<string>(); //固定分配學生ID列
            List<string> dyncIds = new List<string>(); //動態分配學生ID列
            if (response.Status == 200)
            {
                var json = await JsonDocument.ParseAsync(response.ContentStream);
                if (json.RootElement.TryGetProperty("service", out JsonElement serviceJobj))
                {
                    //取得active主週期
                    List<ServiceMainPeriod> activeMainPeriod = new List<ServiceMainPeriod>();
                    if (serviceJobj.TryGetProperty("mainperiod", out JsonElement mainperiodJobj) && mainperiodJobj.ValueKind != JsonValueKind.Null)
                    {
                        foreach (var mainperiodRow in mainperiodJobj.EnumerateArray())
                        {
                            if (mainperiodRow.GetProperty("active").GetBoolean())
                            {
                                activeMainPeriod.Add(mainperiodRow.ToObject<ServiceMainPeriod>());
                            }
                        }
                    }
                    //取得active主週期的副週期
                    List<ServicePeriod> activePeriodOfMain = new List<ServicePeriod>();
                    if (serviceJobj.TryGetProperty("period", out JsonElement periodJobj) && mainperiodJobj.ValueKind != JsonValueKind.Null)
                    {
                        foreach (var periodRow in periodJobj.EnumerateArray())
                        {
                            foreach (ServiceMainPeriod mainPeriodRow in activeMainPeriod)
                            {
                                if (periodRow.GetProperty("mainPeriodId").ToString() == mainPeriodRow.mainPeriodId)
                                {
                                    activePeriodOfMain.Add(periodRow.ToObject<ServicePeriod>());
                                }
                            }
                        }
                    }
                    //取得AClassOne可用數量
                    if (serviceJobj.TryGetProperty("product", out JsonElement serviceProductJobj) && serviceProductJobj.ValueKind != JsonValueKind.Null)
                    {
                        foreach (var serviceProductRow in serviceProductJobj.EnumerateArray())
                        {
                            //AClassOne買斷、週期
                            string prodCode = serviceProductRow.GetProperty("prodCode").GetString();
                            if (prodCode .Equals("RYGVCPLY") || prodCode .Equals("AEGMCPLY"))
                            {
                                ServiceProductResult serviceProductResultRow = CalServiceProductAuth(activeMainPeriod, activePeriodOfMain, serviceProductRow.ToObject<ServiceProduct>());
                                total += serviceProductResultRow.avaliable;
                            }
                        }
                    }
                    //取得AClassOne固定分配數、動態分配數、固定分配學生ID
                    if (json.RootElement.TryGetProperty("aclassone", out JsonElement aclassoneJobj))
                    {
                        if (aclassoneJobj.ValueKind != JsonValueKind.Null)
                        {
                            if (aclassoneJobj.TryGetProperty("ids", out JsonElement ids) && ids.ValueKind != JsonValueKind.Null)
                            {
                                staIds = System.Text.Json.JsonSerializer.Deserialize<List<string>>(ids.ToJsonString());
                                staNum = staIds.Count;
                            }
                        }
                        dyncIds = GetSchoolDynamicAclassOneIDList(school_code.GetString());
                        dyncNum = dyncIds.Count;
                    }
                }
            }

            return Ok(new { total, staNum, dyncNum, staIds, dyncIds });
        }
        */

        /// <summary>
        /// 取得某學校AClassOne動態可使用數 
        /// </summary>
        public int GetSchoolDynamicAclassOne(string schoolCode)
        {
            try
            {
                int result = 0;
                string key = schoolCode + ":" + "AclassOne" + ":" + "dynamic";
                var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
                var dyncount = redisClient.StringGet(key);
                if (redisClient.KeyExists(key))
                {
                    result = Int32.Parse(redisClient.StringGet(key));
                }
                return result;
            }
            catch (Exception ex)
            {
                return 0;
            }
        }
        /// <summary>
        /// 取得某學校AClassOne動態已取用的ID List 
        /// </summary>
        public List<string> GetSchoolDynamicAclassOneIDList(string schoolCode)
        {
            string key = schoolCode + ":" + "AclassOne" + ":" + "dynamicIds";
            var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
            RedisValue[] redisResult = redisClient.SetMembers(key);
            List<string> result = Array.ConvertAll(redisResult, x => (string)x).ToList();
            return result;
        }

        public long GetSchoolDynamicAclassOneIDCount(string schoolCode)
        {
            string key = schoolCode + ":" + "AclassOne" + ":" + "dynamicIds";
            var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
            long result = redisClient.SetLength(key);
            return result;
        }

        /// <summary>
        /// [測試用]放入某學校的AClassOne動態學生ID 
        /// </summary>
        [ProducesDefaultResponseType]
        [HttpPost("set-school-aclassone-dync")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public IActionResult SetSchoolAclassoneDync(JsonElement request)
        {
            if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
            request.TryGetProperty("student_id", out JsonElement student_id);
            var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
            string key1 = school_code + ":" + "AclassOne" + ":" + "dynamicIds";
            RedisValue[] redisIdsOriginal = redisClient.SetMembers(key1);
            var resultIdsOriginal = Array.ConvertAll(redisIdsOriginal, x => (string)x).ToList();
            redisClient.SetAdd(key1, student_id.GetString());
            RedisValue[] redisIds = redisClient.SetMembers(key1);
            var resultIds = Array.ConvertAll(redisIds, x => (string)x).ToList();
            string key2 = school_code + ":" + "AclassOne" + ":" + "dynamic";
            if (resultIds.Count > resultIdsOriginal.Count)
            {
                redisClient.StringDecrement(key2, 1);
            }
            string resultCount = redisClient.StringGet(key2);
            return Ok(new { resultIds, resultCount });
        }

        /// <summary>
        /// 設定某學校AClassOne固定分配授權學生
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("set-school-aclasson-sta")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> SetSchoolAclassoneStatic(JsonElement request)
        {
            if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
            if (!request.TryGetProperty("student_ids", out JsonElement student_ids)) return BadRequest();
            try
            {
                List<string> studentIds = System.Text.Json.JsonSerializer.Deserialize<List<string>>(student_ids.ToJsonString()); //新的學生ID列

                /* ERROR CODE定義：
                 * 0: 無錯誤
                 * 1: AClassOne授權數不足或無AClassOne授權
                 */
                int status = 0;
                string err = "";
                var clientContainer = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
                var response = await clientContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey("Product"));
                if (response.Status == 200)
                {
                    int total = 0; //(回傳值)可分配總數
                    int staNum = 0; //(回傳值)固定分配數
                    int dyncNum = 0; //(回傳值)動態分配數
                    List<string> staIds = new List<string>(); //(回傳值)固定學生ID列
                    List<string> dyncIds = new List<string>(); //(回傳值)動態學生ID列
                    using (Stream stream = response.ContentStream)
                    {
                        using (StreamReader streamReader = new StreamReader(stream))
                        {
                            string content = streamReader.ReadToEnd();
                            SchoolProduct schoolProduct = System.Text.Json.JsonSerializer.Deserialize<SchoolProduct>(content);
                            if (schoolProduct.aclassone != null) //有AClassOne產品授權，schoolProduct.aclassone不會為null
                            {
                                total = schoolProduct.aclassone.total;
                                List<string> studentIdsInDB = schoolProduct.aclassone.ids; //舊的學生ID列
                                int totalInDB = schoolProduct.aclassone.total;
                                //STEP1 驗證所給的ID數是否超過AClassOne總數
                                if (studentIds.Count > totalInDB)
                                {
                                    status = 1;
                                    err = "AclassOne numbers is not enouth.";
                                    return Ok(new { status, err });
                                }
                                //STEP2 將學生ID放入 School.Product.aclassone.ids，更新aclassone.used
                                staIds = schoolProduct.aclassone.ids = studentIds;
                                staNum = schoolProduct.aclassone.used = studentIds.Count;
                                ////Update
                                await clientContainer.ReplaceItemAsync<SchoolProduct>(schoolProduct, schoolProduct.id, new PartitionKey("Product"));
                                //STEP3更新Redis.hbcn:AclassOne:dynamic ※註：只更新動態ID可用數，不更動動態ID列表，所以若可用數為0，當天被動態分配到的學生仍可使用至今日0時才會被清掉
                                int dynamicAclassCount = totalInDB - studentIds.Count; //動態可使用數
                                dyncNum = (int)GetSchoolDynamicAclassOneIDCount(school_code.GetString()); //動態ID已使用數
                                var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
                                string keys = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamic";
                                int updDynAclassCount = (dynamicAclassCount - dyncNum > 0) ? dynamicAclassCount - dyncNum : 0;
                                redisClient.StringSet(keys, updDynAclassCount);
                                string keyd = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamicIds";
                                RedisValue[] redisIds = redisClient.SetMembers(keyd);
                                dyncIds = Array.ConvertAll(redisIds, x => (string)x).ToList();

                                return Ok(new { status, err, total, staNum, dyncNum, staIds, dyncIds });
                            }
                            else
                            {
                                status = 1;
                                err = "AClassOne has no authorization.";
                                return Ok(new { status, err });
                            }
                        }
                    }
                }
                else
                {
                    return BadRequest();
                }
            }
            catch (Exception ex)
            {
                return BadRequest();
            }
        }

        /// <summary>
        /// 回收某學校AClassOne固定分配、動態分配授權學生
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("recall-school-aclasson")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> RecallSchoolAclassone(JsonElement request)
        {
            if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
            string action = "all"; //預設回收：固定及動態均回收  sta:回收固定 dync:回收動態
            if (request.TryGetProperty("mode", out JsonElement mode))
            {
                if (mode.GetString().Equals("sta") || mode.GetString().Equals("dync"))
                {
                    action = mode.GetString();
                }
            }
            int status = 0;
            string err = "";
            var redisClient = _azureRedis.GetRedisClient(redisAclassoneDbNum);
            string keys = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamic";
            string keyd = school_code.GetString() + ":" + "AclassOne" + ":" + "dynamicIds";
            var clientContainer = _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School");
            var response = await clientContainer.ReadItemStreamAsync(school_code.ToString(), new PartitionKey("Product"));
            if (response.Status == 200)
            {
                int total = 0; //(回傳值)可分配總數
                int staNum = 0; //(回傳值)固定分配數
                int dyncNum = 0; //(回傳值)動態分配數
                List<string> staIds = new List<string>(); //(回傳值)固定學生ID列
                List<string> dyncIds = new List<string>(); //(回傳值)動態學生ID列
                using (Stream stream = response.ContentStream)
                {
                    using (StreamReader streamReader = new StreamReader(stream))
                    {
                        string content = streamReader.ReadToEnd();
                        SchoolProduct schoolProduct = System.Text.Json.JsonSerializer.Deserialize<SchoolProduct>(content);
                        if (schoolProduct.aclassone != null) //有AClassOne產品授權，schoolProduct.aclassone不會為null
                        {
                            total = schoolProduct.aclassone.total;
                            staNum = schoolProduct.aclassone.used;
                            staIds = schoolProduct.aclassone.ids;
                            dyncNum = (int)GetSchoolDynamicAclassOneIDCount(school_code.GetString());
                            dyncIds = GetSchoolDynamicAclassOneIDList(school_code.GetString());
                            switch (action)
                            {
                                case "sta":
                                    staIds = schoolProduct.aclassone.ids = new List<string>();
                                    staNum = schoolProduct.aclassone.used = 0;
                                    await clientContainer.ReplaceItemAsync<SchoolProduct>(schoolProduct, schoolProduct.id, new PartitionKey("Product"));
                                    int updDynAclassCount = (total - dyncNum > 0) ? total - dyncNum : 0;
                                    redisClient.StringSet(keys, updDynAclassCount);
                                    break;
                                case "dync": //動態回收
                                    dyncNum = 0;
                                    dyncIds = new List<string>();
                                    redisClient.StringSet(keys, total - staNum);
                                    redisClient.KeyDelete(keyd);
                                    break;
                                case "all": //全回收
                                    staIds = schoolProduct.aclassone.ids = new List<string>();
                                    staNum = schoolProduct.aclassone.used = 0;
                                    await clientContainer.ReplaceItemAsync<SchoolProduct>(schoolProduct, schoolProduct.id, new PartitionKey("Product"));
                                    dyncNum = 0;
                                    dyncIds = new List<string>();
                                    redisClient.StringSet(keys, total);
                                    redisClient.KeyDelete(keyd);
                                    break;
                            }
                            return Ok(new { status, err, total, staNum, dyncNum, staIds, dyncIds });
                        }
                        else
                        {
                            status = 1;
                            err = "AClassOne has no authorization.";
                            return Ok(new { status, err });
                        }
                    }
                }
            }
            else
            {
                return BadRequest();
            }
        }

        /// <summary>
        /// 教師空間
        /// </summary>
        [ProducesDefaultResponseType]
        [HttpPost("teacher-space")]
        [AuthToken(Roles = "teacher,admin,student")]

#if !DEBUG
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> TeacherSpace(JsonElement request)
        {
            // 必要檢查
            if (!request.TryGetProperty("school_code", out JsonElement code)) return BadRequest();
            if (!request.TryGetProperty("action", out JsonElement type)) return BadRequest();
            long usedSpace = 0;//已被使用的空間量(G)
            School school = null;
            string school_code = code.ToString(); // 學校簡碼
            try
            {
                // [變數宣告]

                string action = type.ToString();  // 功能分類
                string queryText = ""; // 統一sql文記憶體

                // response
                string status = "0";
                string err = "";
                List<string> errTeachers = new List<string>();
                RedisValue value = _azureRedis.GetRedisClient(8).HashGet($"Blob:Record", school_code);
                if (value != default && !value.IsNullOrEmpty)
                {
                    JsonElement record = value.ToString().ToObject<JsonElement>();
                    if (record.TryGetInt64(out usedSpace))
                    {
                    }
                    usedSpace = Convert.ToInt64(Math.Ceiling(usedSpace / bytes));
                }
                else
                {
                    //[學校空間]
                    //var blobClient = _azureStorage.GetBlobContainerClient(school_code.ToString());
                    //long? docSize = await blobClient.GetBlobsSize("doc");
                    //long? videoSize = await blobClient.GetBlobsSize("video");
                    //long? imageSize = await blobClient.GetBlobsSize("image");
                    //long? paperSize = await blobClient.GetBlobsSize("paper");
                    //long? itemSize = await blobClient.GetBlobsSize("item");
                    //long? otherSize = await blobClient.GetBlobsSize("other");
                    //long? voteSize = await blobClient.GetBlobsSize("vote");
                    //long? surveySize = await blobClient.GetBlobsSize("survey");
                    //long? audioSize = await blobClient.GetBlobsSize("audio");
                    //long? resSize = await blobClient.GetBlobsSize("res");
                    //long? tempSize = await blobClient.GetBlobsSize("temp");
                    //long? thumSize = await blobClient.GetBlobsSize("thum");
                    //long? syllabusSize = await blobClient.GetBlobsSize("syllabus");
                    //long? examSize = await blobClient.GetBlobsSize("exam");
                    //long? recordsSize = await blobClient.GetBlobsSize("records");
                    //long? yxptSize = await blobClient.GetBlobsSize("yxpt");
                    //long? trainSize = await blobClient.GetBlobsSize("train");
                    //long? homeworkSize = await blobClient.GetBlobsSize("homework");
                    //long? avatarSize = await blobClient.GetBlobsSize("avatar");
                    //docSize = docSize != null ? docSize : 0;
                    //videoSize = videoSize != null ? videoSize : 0;
                    //imageSize = imageSize != null ? imageSize : 0;
                    //paperSize = paperSize != null ? paperSize : 0;
                    //itemSize = itemSize != null ? itemSize : 0;
                    //otherSize = otherSize != null ? otherSize : 0;
                    //voteSize = voteSize != null ? voteSize : 0;
                    //surveySize = surveySize != null ? surveySize : 0;
                    //audioSize = audioSize != null ? audioSize : 0;
                    //resSize = resSize != null ? resSize : 0;
                    //tempSize = tempSize != null ? tempSize : 0;
                    //thumSize = thumSize != null ? thumSize : 0;
                    //syllabusSize = syllabusSize != null ? syllabusSize : 0;
                    //examSize = examSize != null ? examSize : 0;
                    //usedSpace = Convert.ToInt64(Math.Ceiling((double)((avatarSize + homeworkSize + trainSize + yxptSize + recordsSize + docSize + videoSize + imageSize + paperSize + itemSize + otherSize + voteSize + audioSize + resSize + tempSize + thumSize + syllabusSize + examSize) / bytes)));
                }
                long avaliable = this.baseSpaceSize; // (G) 目前學校申請空間總數
                long teacherSpace = 0; // 教師可設定的空間量(G)
                school = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>(school_code, new PartitionKey("Base"));
                if (school.size <= 0)
                {
                    school.size = baseSpaceSize;
                }
                avaliable = school.size;
                // 取得學校目前的總空間數(G)
                teacherSpace = avaliable - usedSpace;
                List<SchoolTeacher> teachersInschool = new List<SchoolTeacher>();
                switch (action)
                {
                    case "baseSpace": // 現在的教師空間
                        return Ok(new
                        {
                            status,
                            avaliable = avaliable.ToString(),
                            usedSpace = usedSpace.ToString()
                        });
                    case "upd": // 修改教師空間
                                // [二次檢核]

                        if (!request.TryGetProperty("teachers", out JsonElement _teachers)) return BadRequest();
                        List<Teacher> teachers = _teachers.Deserialize<List<Teacher>>();

                        // 教師設定總數
                        int setSpaceTotal = 0;

                        // 教師List

                        var ids = teachers.Select(x => x.id);
                        int notInSpaceTotal = 0;
                        string notinsql = $"select value(sum(c.size)) from c ";
                        if (ids.Any())
                        {
                            notinsql = $"select value(sum(c.size)) from c where c.id  not in ({string.Join(",", ids.Select(o => $"'{o}'"))})";
                        }

                        await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<int>(queryText: notinsql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
                        {
                            notInSpaceTotal = item;
                            break;
                        }
                        setSpaceTotal = notInSpaceTotal + teachers.Select(x => x.size).Sum();
                        // 檢核總數是否超過
                        if (setSpaceTotal > teacherSpace)
                        {
                            status = "1"; // 要設定的空間總數大於目前學校有的
                            err = $"設定總量({setSpaceTotal}G)超過目前空間({teacherSpace}G)";
                            return Ok(new { status, err });
                        }
                        queryText = $"select * from c where c.id in ({string.Join(",", ids.Select(o => $"'{o}'"))})";

                        await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: queryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
                        {
                            using var jsoncm = await JsonDocument.ParseAsync(item.ContentStream);
                            foreach (var obj in jsoncm.RootElement.GetProperty("Documents").EnumerateArray())
                            {
                                teachersInschool.Add(obj.ToObject<SchoolTeacher>());
                            }
                        }
                        foreach (var obj in teachers)
                        {
                            SchoolTeacher teacher = teachersInschool.Where(t => !string.IsNullOrWhiteSpace(t.id) && !string.IsNullOrWhiteSpace(obj.id) && t.id == obj.id).FirstOrDefault<SchoolTeacher>();
                            if (teacher != null)
                            {
                                int orgTeacherSize = teacher.size;

                                if (teacher.size != obj.size)
                                {
                                    int bsize = teacher.size;
                                    int asize = obj.size;
                                    teacher.size = obj.size;
                                    List<IdNameCode> nameCodes = new List<IdNameCode> { new IdNameCode { id = obj.id, name = obj.name, code = obj.lang } };

                                    await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(teacher, obj.id, new PartitionKey($"Teacher-{school_code}"));
                                    var schoolData = obj.schools.Find(z => z.schoolId.Equals($"{school_code}"));
                                    if (schoolData != null)
                                    {
                                        _coreAPIHttpService.PushNotify(nameCodes, "teacher_space-change", Constant.NotifyType_IES5_Management,
                                       new Dictionary<string, object> { { "tmdname", teacher.name }, { "tmdid", teacher.id }, { "schoolName", schoolData.name }, { "bsize", bsize }, { "asize", asize } }
                                         , _option.Location, _configuration, _dingDing, _environment.ContentRootPath);
                                    }
                                }
                            }
                        }
                        return Ok(new { status, err, errTeachers });
                    case "retract": // 收回教師空間
                        // [取得DB資料]
                        queryText = "select * from c ";
                        string record = "0";

                        await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: queryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
                        {
                            using var jsoncm = await JsonDocument.ParseAsync(item.ContentStream);
                            if (jsoncm.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                            {
                                // 修改的筆數
                                record = count.ToString();
                                //List<SchoolTeacher> teachersInschool = new List<SchoolTeacher>();
                                foreach (var obj in jsoncm.RootElement.GetProperty("Documents").EnumerateArray())
                                {
                                    teachersInschool.Add(obj.ToObject<SchoolTeacher>());
                                }

                                foreach (SchoolTeacher teacher in teachersInschool)
                                {
                                    // 修改DB裡School的老師size
                                    int teacherSizeInSchool = teacher.size;
                                    teacher.size = 0;


                                    // 修改DB裡Teacher的size
                                    var response = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemStreamAsync(teacher.id, new PartitionKey("Base"));
                                    if (response.Status == 200)
                                    {
                                        var json = await JsonDocument.ParseAsync(response.ContentStream);

                                        //軟體
                                        Teacher teacherHimself = json.ToObject<Teacher>();
                                        // teacherHimself.size -= teacherSizeInSchool;

                                        // 最後一起修改


                                        //huanghb 2021，7.21修改 ，不用再统计到Teacher-Base中 ，Teacher-Base只记录教师自己的空间大小，并包含其他学校赠与的空间，其他学校的赠与空间放在School 表的Teacher-hbcn（SchoolTeacher）中SchoolTeacher
                                        //，并在教师登陆的时候 一并计算个人空间和总空间大小。其中总空间大小包含（个人空间+多个学校累加的空间大小，并且如果退出或者被移除Teacher-Base 的"schools": [],为空，则已经实现自动回收）
                                        await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(teacher, teacher.id, new PartitionKey($"Teacher-{school_code}"));
                                        //await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacherHimself, teacherHimself.id, new PartitionKey("Base"));
                                        List<IdNameCode> nameCodes = new List<IdNameCode> { new IdNameCode { id = teacherHimself.id, name = teacherHimself.name, code = teacherHimself.lang } };
                                        var schoolData = teacherHimself.schools.Find(z => z.schoolId.Equals($"{school_code}"));
                                        _coreAPIHttpService.PushNotify(nameCodes, "teacher_space-retract", Constant.NotifyType_IES5_Management,
                                        new Dictionary<string, object> { { "tmdname", teacher.name }, { "tmdid", teacher.id }, { "schoolName", schoolData.name } }
                                          , _option.Location, _configuration, _dingDing, _environment.ContentRootPath);
                                    }
                                    else
                                    {
                                        status = "3";
                                        err = "有老師不存在於 Teacher 的DB";
                                    }
                                }
                            }
                        }

                        return Ok(new { status, record });
                    default:
                        return BadRequest(); // 不存在的功能BadRequest
                }
            }
            catch (CosmosException ex)
            {
                await _dingDing.SendBotMsg($"OS，{_option.Location}，schoool/teacher-space\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"OS，{_option.Location}，schoool/teacher-space\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }
            finally
            {
                if (school != null)
                {
                    string sql = "select value sum(c.size ) from c  ";
                    int teachSize = 0;
                    await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<int>(queryText: sql,
                        requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
                    {
                        teachSize += item;
                    }
                    school.tsize = teachSize;
                    await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(school, school.id, new PartitionKey("Base"));
                }
            }
        }
        [ProducesDefaultResponseType]
        [HttpPost("teacher-import-manage")]
        [Authorize(Roles = "IES")]
        [AuthToken(Roles = "admin,teacher")]
        public async Task<IActionResult> TeacherImportManage(JsonElement request)
        {
            (string adminId, string adminName, string pic, string schoolId) = HttpContext.GetAuthTokenInfo();
            if (!request.TryGetProperty("opt", out JsonElement _opt)) { return BadRequest(); }
            if (!request.TryGetProperty("schoolId", out JsonElement _schoolId)) { return BadRequest(); }
            long now = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
            TeacherImport teacherImport = null;
            List<SchoolTeacher> idsInSchool = new List<SchoolTeacher>();
            List<CoreUser> coreUsers = new List<CoreUser>();
            switch ($"{_opt}")
            {
                case "upsert":
                    if (!request.TryGetProperty("teachers", out JsonElement _teachers) || !_teachers.ValueKind.Equals(JsonValueKind.Array)) { return BadRequest(); }
                    List<ImportTeacher> teachers = _teachers.ToObject<List<ImportTeacher>>();
                    var tmdids = teachers.Where(x => !string.IsNullOrWhiteSpace(x.tmdid)).Select(z => z.tmdid);
                    var phones = teachers.Where(x => !string.IsNullOrWhiteSpace(x.phone)).Select(z => z.phone);
                    var emails = teachers.Where(x => !string.IsNullOrWhiteSpace(x.email)).Select(z => z.email);
                    List<string> keys = new List<string>();
                    if (tmdids.Any())
                    {
                        keys.AddRange(tmdids);
                    }
                    if (phones.Any())
                    {
                        keys.AddRange(phones);
                    }
                    if (emails.Any())
                    {
                        keys.AddRange(emails);
                    }
                    teachers.ForEach(x => { x.status = "import"; x.time = now; x.iname = x.name; x.name = null; });
                    if (keys.Any())
                    {
                        try
                        {
                            var content = new StringContent(keys.ToJsonString(), Encoding.UTF8, "application/json");
                            string json = await _coreAPIHttpService.GetUserInfos(content);
                            if (!string.IsNullOrWhiteSpace(json))
                            {
                                coreUsers = json.ToObject<List<CoreUser>>();
                            }
                        }
                        catch (Exception ex)
                        {
                            await _dingDing.SendBotMsg($"{_option.Location},导入名单时，查验key信息错误{ex.Message}\n{ex.StackTrace}\n\n{keys.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
                        }
                    }
                    if (coreUsers.Any())
                    {
                        string sql = $"select c.id,c.status from c where c.id in ({string.Join(",", coreUsers.Select(x => $"'{x.id}'"))}) ";

                        await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School)
                            .GetItemQueryIterator<SchoolTeacher>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{_schoolId}") }))
                        {
                            idsInSchool.Add(item);
                        }

                    }
                    List<IdNameCode> inviteids = new List<IdNameCode>();
                    School schoolBase = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>($"{_schoolId}", new PartitionKey("Base"));
                    if (coreUsers.Any())
                    {
                        foreach (var t in teachers)
                        {
                            if (!string.IsNullOrWhiteSpace(t.tmdid))
                            {
                                CoreUser coreUser = coreUsers.Find(x => x.id.Equals(t.tmdid));
                                if (coreUser != null)
                                {
                                    t.id = coreUser.id;
                                    t.name = coreUser.name;
                                    t.picture = coreUser.picture;
                                    t.tmdid = coreUser.id;
                                    if (!string.IsNullOrWhiteSpace(coreUser.mobile))
                                    {
                                        t.phone = coreUser.mobile;
                                    }
                                    if (!string.IsNullOrWhiteSpace(coreUser.mail))
                                    {
                                        t.email = coreUser.mail;
                                    }
                                }
                            }
                            if (string.IsNullOrWhiteSpace(t.id))
                            {
                                if (!string.IsNullOrWhiteSpace(t.phone))
                                {
                                    CoreUser coreUser = coreUsers.Find(x => !string.IsNullOrWhiteSpace(x.mobile) && x.mobile.Equals(t.phone));
                                    if (coreUser != null)
                                    {
                                        t.id = coreUser.id;
                                        t.name = coreUser.name;
                                        t.picture = coreUser.picture;
                                        t.tmdid = coreUser.id;
                                        if (!string.IsNullOrWhiteSpace(coreUser.mobile))
                                        {
                                            t.phone = coreUser.mobile;
                                        }
                                        if (!string.IsNullOrWhiteSpace(coreUser.mail))
                                        {
                                            t.email = coreUser.mail;
                                        }
                                    }
                                }
                            }
                            if (string.IsNullOrWhiteSpace(t.id))
                            {
                                if (!string.IsNullOrWhiteSpace(t.email))
                                {
                                    CoreUser coreUser = coreUsers.Find(x => !string.IsNullOrWhiteSpace(x.mail) && x.mail.Equals(t.email));
                                    if (coreUser != null)
                                    {
                                        t.id = coreUser.id;
                                        t.name = coreUser.name;
                                        t.picture = coreUser.picture;
                                        t.tmdid = coreUser.id;
                                        if (!string.IsNullOrWhiteSpace(coreUser.mobile))
                                        {
                                            t.phone = coreUser.mobile;
                                        }
                                        if (!string.IsNullOrWhiteSpace(coreUser.mail))
                                        {
                                            t.email = coreUser.mail;
                                        }
                                    }
                                }
                            }
                            if (!string.IsNullOrWhiteSpace(t.id))
                            {
                                SchoolTeacher teacher = idsInSchool.Find(x => x.id.Equals(t.id));
                                if (teacher != null)
                                {
                                    t.status = teacher.status;
                                }
                                else
                                {
                                    t.status = "invite";
                                    teacher = new SchoolTeacher
                                    {
                                        id = t.id,
                                        name = t.name,
                                        permissions = new List<string>(),
                                        picture = t.picture,
                                        job = null,
                                        roles = new List<string> { "teacher" },
                                        status = "invite",
                                        createTime = now,
                                        size = 0,
                                        subjectIds = new List<string>(),
                                        pk = "Teacher",
                                        code = $"Teacher-{_schoolId}"
                                    };

                                    await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).CreateItemAsync(teacher, new PartitionKey(teacher.code));
                                    Azure.Response responseTeacher = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReadItemStreamAsync(t.id, new PartitionKey("Base"));
                                    if (responseTeacher.Status == 200)
                                    {
                                        Teacher teacherBase = JsonDocument.Parse(responseTeacher.Content).RootElement.Deserialize<Teacher>();
                                        inviteids.Add(new IdNameCode { id = teacherBase.id, name = teacherBase.name, code = teacherBase.lang });
                                        var school = teacherBase.schools?.Find(x => x.schoolId.Equals($"{_schoolId}"));
                                        if (teacherBase.schools.IsNotEmpty())
                                        {
                                            if (school == null)
                                            {
                                                teacherBase.schools.Add(new Teacher.TeacherSchool { schoolId = schoolBase.id, name = schoolBase.name, picture = schoolBase.picture, areaId = schoolBase.areaId, time = now, status = "invite" });
                                            }
                                        }
                                        else
                                        {
                                            teacherBase.schools = new List<Teacher.TeacherSchool> { new Teacher.TeacherSchool { schoolId = schoolBase.id, name = schoolBase.name, picture = schoolBase.picture, areaId = schoolBase.areaId, time = now, status = "invite" } };
                                        }
                                        await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReplaceItemAsync(teacherBase, teacherBase.id, new PartitionKey("Base"));
                                    }
                                    else
                                    {
                                        Teacher teacherBase = new Teacher
                                        {
                                            createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds(),
                                            id = t.id,
                                            name = t.name,
                                            picture = t.picture,
                                            size = 2,
                                            code = "Base",
                                            pk = "Base",
                                            schools = new List<Teacher.TeacherSchool> {
                                                new Teacher.TeacherSchool {
                                                    schoolId= schoolBase.id,
                                                    name= schoolBase.name,picture= schoolBase.picture, areaId= schoolBase.areaId,time=now,status= "invite" },
                                            }
                                        };
                                        inviteids.Add(new IdNameCode { id = teacherBase.id, name = teacherBase.name, code = teacherBase.lang });
                                        await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).CreateItemAsync(teacherBase, new PartitionKey("Base"));
                                    }

                                }
                            }
                        }
                    }

                    Azure.Response response = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemStreamAsync($"{_schoolId}", new PartitionKey("TeacherImport"));
                    if (response.Status == 200)
                    {
                        teacherImport = JsonDocument.Parse(response.Content).RootElement.Deserialize<TeacherImport>();
                        if (teacherImport != null && teacherImport.teachers.Any())
                        {
                            teachers.ForEach(x =>
                            {
                                ImportTeacher tch = null;
                                if (string.IsNullOrWhiteSpace(x.id))
                                {
                                    tch = teacherImport.teachers.Find(t => !string.IsNullOrWhiteSpace(t.iname) && t.iname.Equals(x.iname));
                                }
                                else
                                {
                                    tch = teacherImport.teachers.Find(t => !string.IsNullOrWhiteSpace(x.id) && !string.IsNullOrWhiteSpace(t.id) && t.id.Equals(x.id));
                                }
                                if (tch != null)
                                {
                                    tch.time = now;
                                    tch.status = x.status;
                                    tch.name = x.name;
                                    tch.iname = x.iname;
                                    tch.picture = x.picture;
                                    tch.phone = x.phone;
                                    tch.tmdid = x.tmdid;
                                    tch.email = x.email;
                                    tch.note = x.note;
                                    tch.id = x.id;
                                }
                                else
                                {
                                    teacherImport.teachers.Add(new ImportTeacher
                                    {
                                        time = now,
                                        status = x.status,
                                        name = x.name,
                                        iname = x.iname,
                                        picture = x.picture,
                                        phone = x.phone,
                                        tmdid = x.tmdid,
                                        email = x.email,
                                        note = x.note,
                                        id = x.id
                                    });
                                }
                            });
                            await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(teacherImport, $"{_schoolId}", new PartitionKey("TeacherImport"));
                        }
                        else
                        {
                            teacherImport = new TeacherImport { id = $"{_schoolId}", code = "TeacherImport", pk = "TeacherImport", teachers = teachers };
                            await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(teacherImport, $"{_schoolId}", new PartitionKey("TeacherImport"));
                        }
                    }
                    else
                    {
                        teacherImport = new TeacherImport { id = $"{_schoolId}", code = "TeacherImport", pk = "TeacherImport", teachers = teachers };
                        await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).CreateItemAsync(teacherImport, new PartitionKey("TeacherImport"));
                    }


                    if (inviteids.Any())
                    {
                        string bizcode = "invite";
                        _coreAPIHttpService.PushNotify(inviteids, $"{bizcode}_school", Constant.NotifyType_IES5_Management,
                        new Dictionary<string, object> { { "tmdname", adminName }, { "schoolName", schoolBase.name }, { "schoolId", $"{_schoolId}" }, { "tmdid", adminId } }, _option.Location, _configuration, _dingDing, _environment.ContentRootPath);
                    }
                    break;
            }
            return Ok(new { teacherImport });

        }
        //取得學校IOT資料
        [ProducesDefaultResponseType]
        [HttpPost("get-school-iot")]
        [Authorize(Roles = "IES")]
        [AuthToken(Roles = "teacher")]
        public async Task<IActionResult> getSchoolIotData(JsonElement request)
        {
            try
            {
                if (!request.TryGetProperty("schoolId", out JsonElement _schoolId)) return BadRequest();
                string periodId = (request.TryGetProperty("periodId", out JsonElement _periodId)) ? _periodId.ToString() : string.Empty;
                var sdate = (request.TryGetProperty("sdate", out JsonElement _sdate)) ? TimeHelper.GetDateTime(_sdate.GetString(), "yyyy-MM-dd") : (0, 0, 0, 0, 0);
                var edate = (request.TryGetProperty("edate", out JsonElement _edate)) ? TimeHelper.GetDateTime(_edate.GetString(), "yyyy-MM-dd") : (0, 0, 0, 0, 0);
                //取得學校基本資訊
                School schoolBase = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>($"{_schoolId}", new PartitionKey("Base"));
                if (string.IsNullOrWhiteSpace(schoolBase.id)) return BadRequest();
                string schName = schoolBase.name;
                string schRegion = schoolBase.region;
                string schProvince = schoolBase.province;
                string schCity = schoolBase.city;
                string schDist = schoolBase.dist;
                string schAreaId = schoolBase.areaId;
                string schType = schoolBase.code;
                var period = (!string.IsNullOrWhiteSpace(periodId)) ? schoolBase.period.Find(x => x.id.Equals($"{periodId}")) : schoolBase.period[0];
                if (period == null) period = schoolBase.period[0];
                (Semester currSemester, int studyYear, DateTimeOffset curr, DateTimeOffset date, DateTimeOffset nextSemester) info = SchoolService.GetSemester(period);
                string semesterId = info.currSemester.id;
                var datetime = DateTimeOffset.UtcNow;
                int studyYear = info.studyYear;
                int dateFromYear = (!sdate.Item1.Equals(0)) ? sdate.Item1 : studyYear;
                int dateFromMonth = (!sdate.Item2.Equals(0)) ? sdate.Item2 : info.currSemester.month;
                int dateFromDay = (!sdate.Item3.Equals(0)) ? sdate.Item3 : info.currSemester.day;
                int dateToYear = (!edate.Item1.Equals(0)) ? edate.Item1 : datetime.Year;
                int dateToMonth = (!edate.Item2.Equals(0)) ? edate.Item2 : datetime.Month;
                int dateToDay = (!edate.Item3.Equals(0)) ? edate.Item3 : datetime.Day;
                //教室數(今年)
                int classCnt = 0;
                string sql = $"SELECT VALUE COUNT(c.id) FROM c WHERE c.year = {studyYear}";
                await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Class-{_schoolId}") }))
                {
                    classCnt = items;
                }
                //總教師數
                int teacherCnt = 0;
                sql = $"SELECT VALUE COUNT(c.id) FROM c";
                await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{_schoolId}") }))
                {
                    teacherCnt = items;
                }
                //學生數(今年) 用學段篩選
                int studentCnt = 0;              
                string sql_studentCnt = $"SELECT count(1) as stus FROM c where c.periodId = '{periodId}' and (c.graduate = 0 OR IS_DEFINED(c.graduate) = false) ";
                await foreach (var items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Student").GetItemQueryStreamIterator(queryText: sql_studentCnt, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Base-{_schoolId}") }))
                {
                    using var json = await JsonDocument.ParseAsync(items.ContentStream);
                    if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                    {
                        foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                        {
                            if (obj.TryGetProperty("stus", out JsonElement stus))
                            {
                                studentCnt = stus.GetInt32();

                            }
                        }
                    }

                }
                //HiTeach硬體授權數
                int deviceAuthCnt = 0;
                //List<string> serialPermitList = getSerialPermitProdcodeList();
                List<string> serialPermitList = new List<string>() { "J223IZ6M", "3222C6D2", "J223IZAM", "J2236ZCX", "3222DNG2", "3222IAVN", "BYJ6LZ6Z" };
                string serialPermitJsonStr = JsonConvert.SerializeObject(serialPermitList);
                string serialQueryText = $"SELECT VALUE SUM(c.deviceMax) FROM c WHERE c.dataType = 'serial' AND ARRAY_CONTAINS({serialPermitJsonStr}, c.prodCode) AND c.expireStatus = 'A'";
                await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: serialQueryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{_schoolId}") }))
                {
                    deviceAuthCnt = items;
                }

                //取得產品分析資訊
                List<string> tmidList = new List<string>(); ///TMID列表
                int stuShow = 0; ///學生人次
                long stuLessonLengMin = 0; ///學生參與總時間數(分)
                int lessonRecord = 0; ///課堂數
                long lessonLengMin = 0; ///課堂時間數(分)
                int mission = 0; ///課中統計-任務數
                int missionFin = 0; ///課中統計-作品數
                int item = 0; ///課中統計-題目數
                int interact = 0; ///課中統計-互動次數
                int lTypeCoop = 0; ///學習型態: 合作
                int lTypeIact = 0; ///學習型態: 互動
                int lTypeMis = 0; ///學習型態: 任務
                int lTypeTst = 0; ///學習型態: 測驗
                int lTypeDif = 0; ///學習型態: 差異化
                List<string> deviceList = new List<string>(); ///設備統計(教室數統計)
                List<string> htcDevList = new List<string>(); ///設備統計-HiTeach Device list
                List<string> htaDevList = new List<string>(); ///設備統計-HiTA Device list
                List<string> htccDevList = new List<string>(); ///設備統計-HiTeachCC Device list
                DateTimeOffset dateTimeFrom = new DateTimeOffset(dateFromYear, dateFromMonth, dateFromDay, 0, 0, 0, TimeSpan.Zero);
                DateTimeOffset dateTimeTo = new DateTimeOffset(dateToYear, dateToMonth, dateToDay, 23, 59, 59, TimeSpan.Zero);
                long dateTimeFromSec = dateTimeFrom.ToUnixTimeSeconds();
                long dateTimeToSec = dateTimeTo.ToUnixTimeSeconds();
                List<ProdAnalysisApiResult> iotData = new List<ProdAnalysisApiResult>();
                sql = $"SELECT * FROM c WHERE c.schoolId = '{_schoolId}' AND c.dateUnit = 'day' AND c.dateTime >= {dateTimeFromSec} AND c.dateTime <= {dateTimeToSec}";
                await foreach (var items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryStreamIterator(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
                {
                    var json = await JsonDocument.ParseAsync(items.ContentStream);
                    foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        ProdAnalysisApiResult data = obj.ToObject<ProdAnalysisApiResult>();
                        data.school.name = schName;
                        data.school.region = schRegion;
                        data.school.province = schProvince;
                        data.school.city = schCity;
                        data.school.dist = schDist;
                        data.school.areaId = schAreaId;
                        data.school.type = schType;
                        iotData.Add(data);
                        tmidList = tmidList.Union(data.tmidList).ToList();
                        stuShow += data.stuShow;
                        stuLessonLengMin += data.stuLessonLengMin;
                        lessonRecord += data.lessonRecord;
                        lessonLengMin += data.lessonLengMin;
                        mission += data.mission;
                        missionFin += data.missionFin;
                        item += data.item;
                        interact += data.interact;
                        deviceList = deviceList.Union(data.deviceList).ToList();
                        if (data.toolType.Equals("HiTeach")) htcDevList = htcDevList.Union(data.deviceList).ToList();
                        if (data.toolType.Equals("HiTA")) htaDevList = htaDevList.Union(data.deviceList).ToList();
                        if (data.toolType.Equals("HiTeachCC")) htccDevList = htccDevList.Union(data.deviceList).ToList();
                        lTypeCoop += data.lTypeCoop;
                        lTypeIact += data.lTypeIact;
                        lTypeMis += data.lTypeMis;
                        lTypeTst += data.lTypeTst;
                        lTypeDif += data.lTypeDif;
                    }
                }
                int teacherShow = tmidList.Count; ///老師使用人次
                int htcDevCnt = htcDevList.Count; ///設備統計-HiTeach上線數
                int htcDevTotalCnt = 0; ///設備統計-HiTeach總設備數
                sql = $"SELECT VALUE COUNT(1) FROM (SELECT DISTINCT x FROM c JOIN x IN c.deviceList WHERE c.schoolId = '{_schoolId}' AND c.dateUnit = 'day' AND c.toolType = 'HiTeach')";
                await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
                {
                    htcDevTotalCnt = items;
                }
                int htaDevCnt = htaDevList.Count; ///設備統計-HiTA上線數
                int htaDevTotalCnt = 0; ///設備統計-HiTA總設備數
                sql = $"SELECT VALUE COUNT(1) FROM (SELECT DISTINCT x FROM c JOIN x IN c.deviceList WHERE c.schoolId = '{_schoolId}' AND c.dateUnit = 'day' AND c.toolType = 'HiTA')";
                await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
                {
                    htaDevTotalCnt = items;
                }
                int htccDevCnt = htccDevList.Count; ///設備統計-HiTeachCC上線數

                return Ok(new { sdate = $"{dateFromYear}-{dateFromMonth}-{dateFromDay}", edate = $"{dateToYear}-{dateToMonth}-{dateToDay}", classCnt, teacherCnt, teacherShow, tmidList, studentCnt, deviceAuthCnt, stuShow, stuLessonLengMin, lessonRecord, lessonLengMin, mission, missionFin, item, interact, deviceList, htcDevCnt, htcDevTotalCnt, htaDevCnt, htaDevTotalCnt, htccDevCnt, lTypeCoop, lTypeIact, lTypeMis, lTypeTst, lTypeDif, iotData });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"OS，{_option.Location}，school/init/get-school-iot\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }
        }
        [ProducesDefaultResponseType]
        [HttpPost("get-area-iot")]
        [Authorize(Roles = "IES")]
        [AuthToken(Roles = "admin")]
        public async Task<IActionResult> getAreaIotData(JsonElement request)
        {
            try
            {
                if (!request.TryGetProperty("schoolIds", out JsonElement _schoolIds)) return BadRequest();
                List<string> schoolIds = _schoolIds.ToObject<List<string>>();
                List<string> periodIds = (request.TryGetProperty("periodIds", out JsonElement _periodIds)) ? _periodIds.ToObject<List<string>>() : new List<string>();
                Dictionary<string, string> schPeriodDic = new Dictionary<string, string>(); //學校ID => 學段ID 字典製作
                if (schoolIds.Count > 0 && periodIds.Count > 0)
                {
                    for (var i = 0; i < schoolIds.Count; i++)
                    {
                        if (periodIds.Count > i && periodIds[i] != null)
                        {
                            schPeriodDic.Add(schoolIds[i], periodIds[i]);
                        }
                    }
                }
                var sdate = (request.TryGetProperty("sdate", out JsonElement _sdate)) ? TimeHelper.GetDateTime(_sdate.GetString(), "yyyy-MM-dd") : (0, 0, 0, 0, 0);
                var edate = (request.TryGetProperty("edate", out JsonElement _edate)) ? TimeHelper.GetDateTime(_edate.GetString(), "yyyy-MM-dd") : (0, 0, 0, 0, 0);
                //取得學校基本資訊
                string schoolIdsJsonStr = JsonConvert.SerializeObject(schoolIds);
                string sql = $"SELECT * FROM c WHERE ARRAY_CONTAINS({schoolIdsJsonStr}, c.id)";
                List<School> schools = new List<School>();
                await foreach (var items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryStreamIterator(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Base") }))
                {
                    using var json = await JsonDocument.ParseAsync(items.ContentStream);
                    if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                    {
                        foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                        {
                            schools.Add(obj.ToObject<School>());
                        }
                    }
                }
                if (schools.Count.Equals(0)) return BadRequest();
                //取得各校IOT相關統計值
                IotStatisticsArea areaIot = new IotStatisticsArea(); //學區IOT統計項
                Dictionary<string, IotStatisticsSch> schIot = new Dictionary<string, IotStatisticsSch>(); //各校IOT統計項
                List<ProdAnalysisApiResult> iotData = new List<ProdAnalysisApiResult>(); //IOT資料
                List<string> serialPermitList = new List<string>() { "J223IZ6M", "3222C6D2", "J223IZAM", "J2236ZCX", "3222DNG2", "3222IAVN", "BYJ6LZ6Z" };
                string serialPermitJsonStr = JsonConvert.SerializeObject(serialPermitList);
                foreach (School school in schools)
                {
                    string schName = school.name;
                    string schRegion = school.region;
                    string schProvince = school.province;
                    string schCity = school.city;
                    string schDist = school.dist;
                    string schAreaId = school.areaId;
                    string schType = school.code;
                    Period period = (schPeriodDic.ContainsKey(school.id)) ? school.period.Find(x => x.id.Equals($"{schPeriodDic[school.id]}")) : school.period[0];
                    if (period == null) period = school.period[0];
                    (Semester currSemester, int studyYear, DateTimeOffset curr, DateTimeOffset date, DateTimeOffset nextSemester) info = SchoolService.GetSemester(period);
                    string semesterId = info.currSemester.id;
                    var datetime = DateTimeOffset.UtcNow;
                    int studyYear = info.studyYear;
                    int dateFromYear = (!sdate.Item1.Equals(0)) ? sdate.Item1 : studyYear;
                    int dateFromMonth = (!sdate.Item2.Equals(0)) ? sdate.Item2 : info.currSemester.month;
                    int dateFromDay = (!sdate.Item3.Equals(0)) ? sdate.Item3 : info.currSemester.day;
                    int dateToYear = (!edate.Item1.Equals(0)) ? edate.Item1 : datetime.Year;
                    int dateToMonth = (!edate.Item2.Equals(0)) ? edate.Item2 : datetime.Month;
                    int dateToDay = (!edate.Item3.Equals(0)) ? edate.Item3 : datetime.Day;
                    DateTimeOffset dateTimeFrom = new DateTimeOffset(dateFromYear, dateFromMonth, dateFromDay, 0, 0, 0, TimeSpan.Zero);
                    DateTimeOffset dateTimeTo = new DateTimeOffset(dateToYear, dateToMonth, dateToDay, 23, 59, 59, TimeSpan.Zero);
                    long dateTimeFromSec = dateTimeFrom.ToUnixTimeSeconds();
                    long dateTimeToSec = dateTimeTo.ToUnixTimeSeconds();
                    //學校IOT 初始化
                    if (!schIot.ContainsKey(school.id))
                    {
                        schIot.Add(school.id, new IotStatisticsSch());
                        schIot[school.id].schId = school.id;
                        schIot[school.id].schName = schName;
                        schIot[school.id].sdate = $"{dateFromYear}-{dateFromMonth}-{dateFromDay}";
                        schIot[school.id].edate = $"{dateToYear}-{dateToMonth}-{dateToDay}";
                    }

                    //教室數(今年)
                    sql = $"SELECT VALUE COUNT(c.id) FROM c WHERE c.year = {studyYear}";
                    await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Class-{school.id}") }))
                    {
                        areaIot.classCnt += items;
                        schIot[school.id].classCnt = items;
                    }
                    //總教師數
                    sql = $"SELECT VALUE COUNT(c.id) FROM c";
                    await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{school.id}") }))
                    {
                        areaIot.teacherCnt += items;
                        schIot[school.id].teacherCnt = items;
                    }
                    //學生數(今年)                  
                    // 加上篩選學段的邏輯  去除之前的廢資料 
                    StringBuilder sb = new();
                    sb.Append("(");
                    for (int i = 0; i < school.period.Count; i++)
                    {
                        sb.Append("'");
                        sb.Append(school.period[i].id);
                        sb.Append("'");
                        if (i != school.period.Count - 1) { sb.Append(", "); }
                    }
                    sb.Append(")");
                    string sql_studentCnt = $"SELECT count(1) as stus FROM c where c.periodId in {sb.ToString()}  and (c.graduate = 0 OR IS_DEFINED(c.graduate) = false) ";

                    await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Student").GetItemQueryStreamIterator(queryText: sql_studentCnt, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Base-{school.id}") }))
                    {
                        using var json = await JsonDocument.ParseAsync(item.ContentStream);
                        if (json.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
                        {
                            foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                            {
                                if (obj.TryGetProperty("stus", out JsonElement stus))
                                {                                    
                                    areaIot.studentCnt += stus.GetInt32();
                                    schIot[school.id].studentCnt = stus.GetInt32();
                                }
                            }
                        }

                    }


                    //HiTeach硬體授權數
                    sql = $"SELECT VALUE SUM(c.deviceMax) FROM c WHERE c.dataType = 'serial' AND ARRAY_CONTAINS({serialPermitJsonStr}, c.prodCode) AND c.expireStatus = 'A'";
                    await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Product-{school.id}") }))
                    {
                        areaIot.deviceAuthCnt += items;
                        schIot[school.id].deviceAuthCnt = items;
                    }
                    //IOT
                    sql = $"SELECT * FROM c WHERE c.schoolId = '{school.id}' AND c.dateUnit = 'day' AND c.dateTime >= {dateTimeFromSec} AND c.dateTime <= {dateTimeToSec}";
                    await foreach (var items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryStreamIterator(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
                    {
                        var json = await JsonDocument.ParseAsync(items.ContentStream);
                        foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                        {
                            ProdAnalysisApiResult data = obj.ToObject<ProdAnalysisApiResult>();
                            data.school.name = schName;
                            data.school.region = schRegion;
                            data.school.province = schProvince;
                            data.school.city = schCity;
                            data.school.dist = schDist;
                            data.school.areaId = schAreaId;
                            data.school.type = schType;
                            iotData.Add(data);
                            //學校IOT統計
                            schIot[school.id].tmidList = schIot[school.id].tmidList.Union(data.tmidList).ToList();
                            schIot[school.id].stuShow += data.stuShow;
                            schIot[school.id].stuLessonLengMin += data.stuLessonLengMin;
                            schIot[school.id].lessonRecord += data.lessonRecord;
                            schIot[school.id].lessonLengMin += data.lessonLengMin;
                            schIot[school.id].mission += data.mission;
                            schIot[school.id].missionFin += data.missionFin;
                            schIot[school.id].item += data.item;
                            schIot[school.id].interact += data.interact;
                            if (data.toolType.Equals("HiTeach")) schIot[school.id].htcDevList = schIot[school.id].htcDevList.Union(data.deviceList).ToList();
                            if (data.toolType.Equals("HiTA")) schIot[school.id].htaDevList = schIot[school.id].htaDevList.Union(data.deviceList).ToList();
                            if (data.toolType.Equals("HiTeachCC")) schIot[school.id].htccDevList = schIot[school.id].htccDevList.Union(data.deviceList).ToList();
                            schIot[school.id].lTypeCoop += data.lTypeCoop;
                            schIot[school.id].lTypeIact += data.lTypeIact;
                            schIot[school.id].lTypeMis += data.lTypeMis;
                            schIot[school.id].lTypeTst += data.lTypeTst;
                            schIot[school.id].lTypeDif += data.lTypeDif;
                        }
                    }
                    ///設備統計-HiTeach總設備數
                    sql = $"SELECT VALUE COUNT(1) FROM (SELECT DISTINCT x FROM c JOIN x IN c.deviceList WHERE c.schoolId = '{school.id}' AND c.dateUnit = 'day' AND c.toolType = 'HiTeach')";
                    await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
                    {
                        schIot[school.id].htcDevTotalCnt = items;
                    }
                    ///設備統計-HiTA總設備數
                    sql = $"SELECT VALUE COUNT(1) FROM (SELECT DISTINCT x FROM c JOIN x IN c.deviceList WHERE c.schoolId = '{school.id}' AND c.dateUnit = 'day' AND c.toolType = 'HiTA')";
                    await foreach (int items in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<int>(queryText: sql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"ProdAnalysis") }))
                    {
                        schIot[school.id].htaDevTotalCnt = items;
                    }
                    schIot[school.id].tmidCnt = schIot[school.id].tmidList.Count; ///老師使用人次
                    schIot[school.id].htcDevCnt = schIot[school.id].htcDevList.Count; ///設備統計-HiTeach上線數
                    schIot[school.id].htaDevCnt = schIot[school.id].htaDevList.Count; ///設備統計-HiTA上線數
                    schIot[school.id].htccDevCnt = schIot[school.id].htccDevList.Count; ///設備統計-HiTeachCC上線數
                }

                //輸出整形
                List<IotStatisticsSch> schoolIotResult = new List<IotStatisticsSch>();
                foreach (KeyValuePair<string, IotStatisticsSch> schIotItem in schIot)
                {
                    IotStatisticsSch schIotData = schIotItem.Value;
                    //學校
                    schoolIotResult.Add(schIotData);
                    //學區
                    areaIot.sdate = (string.IsNullOrWhiteSpace(areaIot.sdate)) ? schIotData.sdate : (DateTime.Parse(schIotData.sdate, CultureInfo.InvariantCulture) < DateTime.Parse(areaIot.sdate, CultureInfo.InvariantCulture)) ? schIotData.sdate : areaIot.sdate;
                    areaIot.edate = (string.IsNullOrWhiteSpace(areaIot.edate)) ? schIotData.edate : (DateTime.Parse(schIotData.edate, CultureInfo.InvariantCulture) > DateTime.Parse(areaIot.edate, CultureInfo.InvariantCulture)) ? schIotData.edate : areaIot.edate;
                    areaIot.tmidList = areaIot.tmidList.Union(schIotData.tmidList).ToList();
                    areaIot.tmidCnt = areaIot.tmidList.Count;
                    areaIot.stuShow += schIotData.stuShow;
                    areaIot.stuLessonLengMin += schIotData.stuLessonLengMin;
                    areaIot.lessonRecord += schIotData.lessonRecord;
                    areaIot.lessonLengMin += schIotData.lessonLengMin;
                    areaIot.mission += schIotData.mission;
                    areaIot.missionFin += schIotData.missionFin;
                    areaIot.item += schIotData.item;
                    areaIot.interact += schIotData.interact;
                    areaIot.htcDevList = areaIot.htcDevList.Union(schIotData.htcDevList).ToList();
                    areaIot.htcDevCnt = areaIot.htcDevList.Count;
                    areaIot.htaDevList = areaIot.htaDevList.Union(schIotData.htaDevList).ToList();
                    areaIot.htaDevCnt = areaIot.htaDevList.Count;
                    areaIot.htccDevList = areaIot.htccDevList.Union(schIotData.htccDevList).ToList();
                    areaIot.htccDevCnt = areaIot.htccDevList.Count;
                    areaIot.lTypeCoop += schIotData.lTypeCoop;
                    areaIot.lTypeIact += schIotData.lTypeIact;
                    areaIot.lTypeMis += schIotData.lTypeMis;
                    areaIot.lTypeTst += schIotData.lTypeTst;
                    areaIot.lTypeDif += schIotData.lTypeDif;
                }

                return Ok(new { area = areaIot, school = schoolIotResult, iotData });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"OS，{_option.Location}，school/init/get-school-iot\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
                return BadRequest();
            }
        }

        //新学年8.1号开学 ,第二学期开学2.17,设置提示区间60天
        //2023-8-7   type = "studyYearStarted";新学年已经开始
        //2023-10-7  type = "";不提示
        //2024-1-20  type = "semesterEnding";本学期即将结束
        //2024-3-20  type = "semesterStarted";新学期已经开始
        //2024-4-20  type = "";不提示
        //2024-7-20  type = "studyYearEnding";本学年即将结束
        /// <
        /// summary>
        /// 检查当前学期的开学时间和学期结束时间 
        /// </summary>
        /// <param name="json"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]

        [HttpPost("check-semesters")]
#if !DEBUG
[AuthToken(Roles = "teacher,admin")]
        [Authorize(Roles = "IES")]
#endif
        public async Task<IActionResult> CheckSemesters(JsonElement json)
        {
            if (!json.TryGetProperty("schoolId", out JsonElement _schoolId)) { return BadRequest(); }
            if (!json.TryGetProperty("periodId", out JsonElement _periodId)) { return BadRequest(); }
            School school = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>(_schoolId.GetString(), new PartitionKey("Base"));
            var period = school.period.Find(z => z.id.Equals(_periodId.GetString()));
            if (period != null)
            {
                var semesterInfo = SchoolService.GetSemester(period, DateTimeOffset.Now.ToUnixTimeMilliseconds());
                // var semesterInfo = SchoolService.GetSemester(period, time:$"{_time}");
                var start = period.semesters.Where(z => z.start == 1).FirstOrDefault();
                if (start != null)
                {

                    var alreadySemester = semesterInfo.date.Subtract(semesterInfo.currSemesterDate);
                    var soonSemester = semesterInfo.nextSemester.Subtract(semesterInfo.date);
                    var semesterStarted = Math.Abs((int)alreadySemester.TotalDays);
                    var semesterEnding = Math.Abs((int)soonSemester.TotalDays);

                    string currStudyYear = $"{semesterInfo.studyYear}-{start.month}-{start.day}";
                    string nextStudyYear = $"{(semesterInfo.studyYear + 1)}-{start.month}-{start.day}";
                    DateTimeOffset.TryParse(currStudyYear, out DateTimeOffset currYear);
                    DateTimeOffset.TryParse(nextStudyYear, out DateTimeOffset nextYear);
                    var alreadyYear = semesterInfo.date.Subtract(currYear);
                    var soonYear = nextYear.Subtract(semesterInfo.date);
                    var studyYearStarted = Math.Abs((int)alreadyYear.TotalDays);
                    var studyYearEnding = Math.Abs((int)soonYear.TotalDays);
                    string type = string.Empty;
                    //开始天数小于60天
                    if (semesterStarted <= 60)
                    {
                        type = "semesterStarted";
                    }
                    //结束天数小于60天
                    if (semesterEnding <= 60)
                    {
                        type = "semesterEnding";

                    }
                    //开始天数小于60天
                    if (studyYearStarted <= 60)
                    {
                        type = "studyYearStarted";
                    }
                    //结束天数小于60天
                    if (studyYearEnding <= 60)
                    {
                        type = "studyYearEnding";
                    }
                    string key = $"SemesterStudyYearNotify:{_schoolId}:{semesterInfo.studyYear}:{semesterInfo.currSemester.id}:{type}";
                    var keyExists = await _azureRedis.GetRedisClient(8).KeyExistsAsync(key);
                    if (keyExists)
                    {
                        var data = await _azureRedis.GetRedisClient(8).StringGetAsync(key);
                        if (data.HasValue)
                        {
                            SemesterStudyYearNotify notify = data.ToString().ToObject<SemesterStudyYearNotify>();
                            if (notify.ignore == 1)
                            {
                                //忽略提示
                                type = "";
                            }
                            else
                            {
                                //已经处理过的不再处理
                                if (notify.process == 1)
                                {
                                    type = "";
                                }
                            }
                        }
                    }
                    else
                    {
                        await _azureRedis.GetRedisClient(8).StringSetAsync(key, new SemesterStudyYearNotify { studyYear = semesterInfo.studyYear, semester = semesterInfo.currSemester.id, ignore = 0, type = type }.ToJsonString());
                        //60天 * 24 =1440小时
                        await _azureRedis.GetRedisClient(8).KeyExpireAsync(key, new TimeSpan(1440, 0, 0));
                    }
                    if (!string.IsNullOrWhiteSpace(type))
                    {
                        if (type.Contains("Ending", StringComparison.OrdinalIgnoreCase))
                        {
                            string sql = $"";

                        }
                        if (type.Contains("Started", StringComparison.OrdinalIgnoreCase))
                        {

                        }
                    }
                    return Ok(new { code = 1, studyYearStarted, studyYearEnding, semesterStarted, semesterEnding, type, key });
                }
            }
            return Ok(new { code = -1, msg = "不需要提示" });
        }

        //取得序號產品准許使用產品代碼列表
        public static List<string> getSerialPermitProdcodeList()
        {
            List<string> allowProdCode = new List<string>(); //軟體許可產品列：HiTeach STD、TBL、PRO、HiTeach5；
            allowProdCode.Add("J223IZ6M"); //HiTeach STD
            allowProdCode.Add("3222C6D2"); //HiTeach TBL
            allowProdCode.Add("J223IZAM"); //HiTeach PRO
            allowProdCode.Add("J2236ZCX"); //HiTeach Lite
            allowProdCode.Add("3222DNG2"); //HiTeach Mobile
            allowProdCode.Add("3222IAVN"); //HiTeach Premium
            allowProdCode.Add("BYJ6LZ6Z"); //HiTeach5
            allowProdCode.Add("LZLL6ZEI"); //HiTeachCC
            return allowProdCode;
        }
    }
    public class SemesterStudyYearNotify
    {
        /// <summary>
        /// 当前学年
        /// </summary>
        public int studyYear { get; set; }
        /// <summary>
        /// 当前学期
        /// </summary>
        public string semester { get; set; }
        /// <summary>
        /// 是否选择忽略 0未忽略，1 已经忽略
        /// </summary>
        public int ignore { get; set; } = 0;
        /// <summary>
        /// 提示类型
        /// </summary>
        public string type { get; set; }
        /// <summary>
        /// 是否已经处理 0未处理，1已处理
        /// </summary>
        public int process { get; set; }
        /// <summary>
        /// 学年已经开始多少天
        /// </summary>
        public int studyYearStarted { get; set; }
        /// <summary>
        /// 学年即将结束
        /// </summary>
        public int studyYearEnding { get; set; }
        /// <summary>
        /// 学期已经开始多少天
        /// </summary>
        public int semesterStarted { get; set; }
        /// <summary>
        /// 学期即将结束
        /// </summary>
        public int semesterEnding { get; set; }
    }
}