TEAMModelOS/TEAMModelBI/Controllers/BISchool/BatchSchoolController.cs

using Azure.Cosmos;
using HTEXLib.COMM.Helpers;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Options;
using System;
using System.Collections.Generic;
using System.Dynamic;
using System.Linq;
using System.Text;
using System.Text.Json;
using System.Threading.Tasks;
using TEAMModelOS.Models;
using TEAMModelOS.SDK.DI;
using TEAMModelOS.SDK.Extension;
using TEAMModelOS.SDK.Models;
using TEAMModelOS.SDK.Models.Cosmos.BI;
using Microsoft.AspNetCore.Hosting;  //引用读取文件
using TEAMModelOS.SDK.Models.Service;
using System.IO;
using System.Net.Http;
using Microsoft.Extensions.Configuration;
using System.Net.Http.Json;
using System.Net;
using TEAMModelBI.Filter;
using TEAMModelBI.Tool.Extension;
using TEAMModelBI.Tool;
using TEAMModelBI.Models;

namespace TEAMModelBI.Controllers.BISchool
{
    [Route("batchschool")]
    [ApiController]
    public class BatchSchoolController : ControllerBase
    {
        private readonly AzureCosmosFactory _azureCosmos;
        private readonly DingDing _dingDing;
        private readonly Option _option;
        private readonly AzureStorageFactory _azureStorage;
        private readonly IWebHostEnvironment _environment; //读取文件
        private readonly IHttpClientFactory _http;
        //读取配置信息
        private readonly IConfiguration _configuration;
        public readonly string mobel = "学校";

        public BatchSchoolController(AzureCosmosFactory azureCosmos, DingDing dingDing, AzureStorageFactory azureStorage, IOptionsSnapshot<Option> option, IWebHostEnvironment hostingEnvironment, IConfiguration configuration, IHttpClientFactory http)
        {
            _azureCosmos = azureCosmos;
            _dingDing = dingDing;
            _azureStorage = azureStorage;
            _option = option?.Value;
            _environment = hostingEnvironment;
            _configuration = configuration;
            _http = http;
        }

        /// <summary>
        /// 获取BI权限列表
        /// </summary>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-teacher-authoritybilist")]
        public async Task<IActionResult> GetAuthorityBIList()
        {
            Dictionary<string, object> dic = new Dictionary<string, object> { { "PartitionKey", "authority-bi" } };
            var table = _azureStorage.GetCloudTableClient().GetTableReference("SchoolSetting");
            List<Authority> authorityBIList = await table.FindListByDict<Authority>(dic);

            return Ok(new { authorityBIList });
        }

        /// <summary>
        /// 通过教师的id和学校的code查询权限
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-teacherroles")]
        public async Task<IActionResult> GetTeacherRoles(JsonElement jsonElement)
        {
            try
            {
                if (!jsonElement.TryGetProperty("id", out JsonElement id)) return Ok(new { state = 1, message = "参数错误！" });
                if (!jsonElement.TryGetProperty("schoolcode", out JsonElement schoolcode)) return Ok(new { state = 1, message = "参数错误！" });

                var client = _azureCosmos.GetCosmosClient();
                string sqltxt = $"select * from c where c.id='{id}'";

                List<string> roles = new List<string>();//角色列表
                List<string> permissions = new List<string>();//权限列表

                var schoolRoles = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{id}", new PartitionKey($"Teacher-{schoolcode}"));
                if (schoolRoles.Status == 200)
                {
                    using var json = await JsonDocument.ParseAsync(schoolRoles.ContentStream);
                    if (json.RootElement.TryGetProperty("roles", out JsonElement _roles) && _roles.ValueKind != JsonValueKind.Null)
                    {
                        foreach (var obj in _roles.EnumerateArray())
                        {
                            roles.Add(obj.GetString());
                        }
                    }
                    if (json.RootElement.TryGetProperty("permissions", out JsonElement _permissions) && _permissions.ValueKind != JsonValueKind.Null)
                    {
                        foreach (var obj in _permissions.EnumerateArray())
                        {
                            permissions.Add(obj.GetString());
                        }
                    }
                }

                return Ok(new { state = 200, roles = roles, permissions = permissions });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI，{_option.Location},  /batchschool/get-teacherroles \n{ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();

            }
        }

        /// <summary>
        /// 依据传输的数据更新和删除权限
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [AuthToken(Roles = "assist")]
        [HttpPost("upd-permissions")]
        public async Task<IActionResult> SetSchoolPermissions(JsonElement jsonElement)
        {
            try
            {
                if (!jsonElement.TryGetProperty("ids", out JsonElement ids)) return Ok(new { state = 1, message = "ids参数错误！" });
                if (!jsonElement.TryGetProperty("school_code", out JsonElement school_code)) return Ok(new { state = 1, message = "school_code参数错误！" });
                if (!jsonElement.TryGetProperty("mode", out JsonElement mode)) return Ok(new { state = 1, message = "mode参数错误！" });     //del删除权限  up更新权限
                if (!jsonElement.TryGetProperty("paramPower", out JsonElement paramPower)) return Ok(new { state = 1, message = "paramPower参数错误！" });
                
                var (_tmdId, _tmdName, pic, did, dname, dpic) = HttpJwtAnalysis.JwtXAuthBI(HttpContext.GetXAuth("AuthToken"), _option);
                List<Exist> havepower = new(); //已存在的
                var client = _azureCosmos.GetCosmosClient();

                StringBuilder stringBuilder = new StringBuilder($"{_tmdName}【{_tmdId}】账户操作：");
                //更新权限
                foreach (var id in ids.EnumerateArray())
                {
                    SchoolTeacher st = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>($"{id}", new PartitionKey($"Teacher-{school_code}"));

                    if (mode.GetString().Equals("del"))
                    {
                        stringBuilder.Append($"{st.name}【{st.id}】的权限，删除权限有：");
                        foreach (var pm in paramPower.EnumerateArray())
                        {
                            var bools = st.permissions.Find(x => x.Equals($"{pm}"));
                            if (!string.IsNullOrEmpty($"{bools}"))
                            {
                                st.permissions.RemoveAll(x => x.Equals($"{bools}"));
                                stringBuilder.Append(pm);
                            }
                        }
                    }
                    else if (mode.GetString().Equals("up"))
                    {
                        stringBuilder.Append($"{st.name}【{st.id}】的权限，更新权限有：");
                        var stes = st.roles.Find(x => x.Equals("assistant"));
                        if (string.IsNullOrEmpty($"{stes}"))
                        {
                            st.roles.Add("assistant");
                        }
                        foreach (var pm in paramPower.EnumerateArray())
                        {
                            var bools = st.permissions.Find(x => x.Equals($"{pm}"));
                            if (!string.IsNullOrEmpty($"{bools}"))
                            {
                                havepower.Add(new Exist { ID = id.GetString(), name = bools });
                            }
                            else
                            {
                                st.permissions.Add(pm.GetString());
                                stringBuilder.Append(pm);
                            }
                        }
                        if (havepower.Count > 0)
                        {
                            stringBuilder.Append($"；已存在的权限:{havepower}");
                        }
                    }
                    else { return Ok(new { state = 1, message = "mode参数错误！" }); }
                    await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(st, id.GetString(), new PartitionKey($"Teacher-{school_code}"));
                }

                //保存操作记录
                await _azureStorage.SaveBILog("school-update", stringBuilder?.ToString(), _dingDing, httpContext: HttpContext);

                return Ok(new { state = 200, havepower });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI，{_option.Location}, /batchschool/upd-permissions \n{ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 批量创校
        /// </summary>
        /// <param name="school"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [AuthToken(Roles = "assist")]
        [HttpPost("batch-school")]
        public async Task<IActionResult> BatchCreateSchool(FoundSchools foundSchools)
        {
            try
            {
                var (_tmdId, _tmdName, pic, did, dname, dpic) = HttpJwtAnalysis.JwtXAuthBI(HttpContext.GetXAuth("AuthToken"), _option);

                List<BISchool> schools = new List<BISchool>();
                StringBuilder stringBuilder = new StringBuilder($"{_tmdName}【{_tmdId}】使用批量创校功能：");

                if (foundSchools.biSchools.Count > 0)
                {
                    var cosmosClient = _azureCosmos.GetCosmosClient();
                    foreach (BISchool bischool in foundSchools.biSchools)
                    {
                        string tempTmdId = null;
                        HttpClient httpClient = _http.CreateClient();
                        string url = _configuration.GetValue<string>("HaBookAuth:CoreId:userinfo");
                        List<string> mobile = new List<string>() { bischool.admin };
                        HttpResponseMessage responseMessage = await httpClient.PostAsJsonAsync(url, mobile);
                        if (responseMessage.StatusCode == HttpStatusCode.OK)
                        {
                            string temp = responseMessage.Content.ReadAsStringAsync().Result;
                            List<JsonElement> json_id = temp.ToObject<List<JsonElement>>();
                            foreach (var item in json_id)
                            {
                                tempTmdId = item.GetProperty("id").ToString();
                            }
                        }

                        string tmdId = !string.IsNullOrEmpty(tempTmdId) ? tempTmdId : bischool.admin;

                        CreateSchoolInfo createSchoolInfo = new CreateSchoolInfo()
                        {
                            province = bischool.province,
                            id = "",
                            name = bischool.name,
                            city = bischool.city,
                            aname = "",
                            createCount = 0,
                        };

                        //生成学校ID
                        bool tempStaus = true;
                        do
                        {
                            createSchoolInfo = await SchoolCode.GenerateSchoolCode(createSchoolInfo, _dingDing, _environment);
                            var schoolStatu = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync($"{createSchoolInfo.id}", new PartitionKey($"Base"));
                            if (schoolStatu.Status != 200) tempStaus = false;
                            else createSchoolInfo.createCount = createSchoolInfo.createCount >= 3 ? createSchoolInfo.createCount = 3 : createSchoolInfo.createCount += 1;
                        } while (tempStaus);

                        if (createSchoolInfo.id != null)
                        {
                            string campusId = Guid.NewGuid().ToString();
                            School upSchool = new School
                            {
                                id = createSchoolInfo.id,
                                name = bischool.name,
                                size = bischool.size == 0 ? 100 : bischool.size,
                                code = "Base",
                                campuses = new List<Campus> { new Campus { name = bischool.name, id = campusId } },
                                region = bischool.region,
                                province = bischool.province,
                                city = bischool.city,
                                dist = bischool.dist,
                                address = bischool.address,
                                picture = "https://teammodelstorage.blob.core.chinacloudapi.cn/0-public/school/bbf54fb3-3fc8-43ae-a358-107281c174cc.png",
                                timeZone = new TEAMModelOS.SDK.Models.TimeZone { label = "(UTC+08:00) 北京，重庆，香港特别行政区，乌鲁木齐", value = "+08:00" },
                                type = bischool.type,
                                pk = "School",
                                ttl = -1,
                                areaId = string.IsNullOrEmpty(bischool.areaId) ? "" : bischool.areaId,
                                schoolCode = createSchoolInfo.id,
                                period = PresetSchoolPeriod(bischool.period, foundSchools.lang, campusId),
                                scale = bischool.size >= 300 ? 500 : 0
                            };

                            stringBuilder.Append($"创建学校：{upSchool.name}【{upSchool.id}】");
                            //创建学校
                            await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<School>(upSchool, new PartitionKey(upSchool.code));
                            Teacher teacher = null;
                            try
                            {
                                //查询该教师是否存在
                                teacher = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Teacher>($"{tmdId}", new PartitionKey("Base"));
                            }
                            catch
                            {
                            }
                            if (teacher != null)
                            {
                                //教师存在，在该教师信息中添加要管理的学校信息
                                teacher.schools.Add(new Teacher.TeacherSchool { areaId = string.IsNullOrEmpty(bischool.areaId) ? "" : bischool.areaId, schoolId = createSchoolInfo.id, name = bischool.name, status = "join", time = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds() });
                                //await cosmosClient.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacher, tmdId, new PartitionKey("Base"));
                                SchoolTeacher schoolTeacher = new SchoolTeacher
                                {
                                    id = tmdId,
                                    code = $"Teacher-{createSchoolInfo.id}",
                                    roles = new List<string> { "admin", "teacher" },
                                    job = "管理员",
                                    name = teacher.name,
                                    picture = teacher.picture,
                                    status = "join",
                                    createTime = DateTimeOffset.UtcNow.ToUnixTimeSeconds(),
                                    pk = "Teacher",
                                    ttl = -1
                                };

                                stringBuilder.Append($"教师信息：{schoolTeacher.name}【{schoolTeacher.id}】，教师权限：{string.Join(",", schoolTeacher.roles)}");
                                await cosmosClient.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacher, teacher.id, new PartitionKey(teacher.code));
                                await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<SchoolTeacher>(schoolTeacher, new PartitionKey(schoolTeacher.code));
                            }
                            else
                            {
                                //不存在 新建教师和新建要管理的学校信息
                                Teacher addteacher = new Teacher
                                {
                                    id = tmdId,
                                    pk = "Base",
                                    code = "Base",
                                    name = $"{bischool.name}-管理员"?.ToString(),
                                    picture = "",
                                    //创建账号并第一次登录IES5则默认赠送1G
                                    size = 1,
                                    defaultSchool = createSchoolInfo.id,
                                    schools = new List<Teacher.TeacherSchool>() { new Teacher.TeacherSchool { schoolId = createSchoolInfo.id, name = bischool.name, status = "join", time = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds() } }
                                };

                                stringBuilder.Append($"没有该教师信息创建的教师信息：{addteacher.name}【{addteacher.id}】");
                                await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, "Teacher").CreateItemAsync<Teacher>(addteacher, new PartitionKey("Base"));
                                SchoolTeacher schoolTeacher = new SchoolTeacher
                                {
                                    id = tmdId,
                                    code = $"Teacher-{createSchoolInfo.id}",
                                    roles = new List<string> { "admin", "teacher" },
                                    job = "管理员",
                                    name = $"{tmdId}-管理员",
                                    picture = "",
                                    status = "join",
                                    createTime = DateTimeOffset.UtcNow.ToUnixTimeSeconds(),
                                    pk = "Teacher",
                                    ttl = -1
                                };

                                stringBuilder.Append($"教师权限：{string.Join(",", schoolTeacher.roles)}");
                                await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<SchoolTeacher>(schoolTeacher, new PartitionKey(schoolTeacher.code));
                            }
                        }
                    }
                }
                else return Ok(new { state = 1, message = "创校信息为空" });

                //保存操作记录
                await _azureStorage.SaveBILog("school-batchAdd", stringBuilder?.ToString(), _dingDing, httpContext: HttpContext);

                if (schools.Count > 0)
                    return Ok(new { state = 201, message = "已有部分学校批量创建成功；学校编号已经重复！请检查学校编号！", schools });
                else
                    return Ok(new { state = 200, message = "批量创校已全部完成" });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI，{_option.Location} /batchschool/batch-school \n {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 依据学校编号查询学校信息；若是没有传学校编号，则查询所有学校信息
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-schoolsinfo")]
        public async Task<IActionResult> GetSchoolsInfo(JsonElement jsonElement)
        {
            try
            {
                jsonElement.TryGetProperty("schoolCode", out JsonElement _schoolCode);
                var cosmosClient = _azureCosmos.GetCosmosClient();
                List<SchoolAssist> schoolAssists = new();
                //StringBuilder stringBuilder = new StringBuilder("select value(c) from c");
                StringBuilder stringBuilder = new StringBuilder("select c.id,c.code,c.schoolCode,c.name,c.region,c.province,c.city,c.dist,c.size,c.address,c.picture,c.type,c.scale,c.areaId,c.standard from c");

                if (!string.IsNullOrEmpty($"{_schoolCode}"))
                {
                    stringBuilder.Append($" where c.id='{_schoolCode}'");
                }

                //await foreach (var itemSchool in cosmosClient.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<School>(queryText: stringBuilder.ToString(), requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
                //{
                //    SchoolAssist schoolAssist = new()
                //    {
                //        id = itemSchool.id,
                //        code = itemSchool.code,
                //        schoolCode = itemSchool.schoolCode,
                //        name = itemSchool.name,
                //        region = itemSchool.region,
                //        province = itemSchool.province,
                //        city = itemSchool.city,
                //        dist = itemSchool.dist,
                //        size = itemSchool.size,
                //        address = itemSchool.address,
                //        picture = itemSchool.picture,
                //        type = itemSchool.type,
                //        scale = itemSchool.scale,
                //        areaId = itemSchool.areaId,
                //        standard = itemSchool.standard
                //    };

                //    var response = await cosmosClient.GetContainer("TEAMModelOS", "School").ReadItemStreamAsync(itemSchool.id, new PartitionKey("ProductSum"));
                //    if (response.Status == 200)
                //    {
                //        using var json = await JsonDocument.ParseAsync(response.ContentStream);
                //        schoolAssist.serial = json.RootElement.GetProperty("serial").GetArrayLength();
                //        schoolAssist.service = json.RootElement.GetProperty("service").GetArrayLength();
                //        schoolAssist.hard = json.RootElement.GetProperty("hard").GetArrayLength();
                //    }

                //    schoolAssist.assists = await CommonFind.FindSchoolRoles(cosmosClient, itemSchool.id, "assist");

                //    schoolAssists.Add(schoolAssist);
                //}
                //return Ok(new { state = 200, schoolAssists });

                await foreach (var itemSchool in cosmosClient.GetContainer("TEAMModelOS", "School").GetItemQueryStreamIterator(queryText: stringBuilder.ToString(), requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
                {
                    using var jsonSchool = await JsonDocument.ParseAsync(itemSchool.ContentStream);
                    foreach (var objSchool in jsonSchool.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        var schoolId = objSchool.GetProperty("id").GetString();
                        SchoolAssist schoolAssist = new()
                        {
                            id = schoolId,
                            code = objSchool.GetProperty("code").GetString(),
                            schoolCode = objSchool.GetProperty("schoolCode").GetString(),
                            name = objSchool.GetProperty("name").GetString(),
                            region = objSchool.GetProperty("region").GetString(),
                            province = objSchool.GetProperty("province").GetString(),
                            city = objSchool.GetProperty("city").GetString(),
                            dist = objSchool.GetProperty("dist").GetString(),
                            size = objSchool.GetProperty("size").GetInt32(),
                            address = objSchool.GetProperty("address").GetString(),
                            picture = objSchool.GetProperty("picture").GetString(),
                            type = objSchool.GetProperty("type").GetInt32(),
                            //scale = objSchool.GetProperty("scale").GetInt32(),
                            areaId = objSchool.GetProperty("areaId").GetString(),
                            standard = objSchool.GetProperty("standard").GetString(),
                        };

                        try { schoolAssist.scale = objSchool.GetProperty("scale").GetInt32(); }
                        catch { schoolAssist.scale = 0; }

                        //var response = await cosmosClient.GetContainer("TEAMModelOS", "School").ReadItemStreamAsync(schoolId, new PartitionKey("ProductSum"));
                        //if (response.Status == 200)
                        //{
                        //    using var json = await JsonDocument.ParseAsync(response.ContentStream);
                        //    schoolAssist.serial = json.RootElement.GetProperty("serial").GetArrayLength();
                        //    schoolAssist.service = json.RootElement.GetProperty("service").GetArrayLength();
                        //    schoolAssist.hard = json.RootElement.GetProperty("hard").GetArrayLength();
                        //}

                        //schoolAssist.assists = await CommonFind.FindSchoolRoles(cosmosClient, schoolId, "assist");
                        schoolAssists.Add(schoolAssist);
                    }
                }

                List<SchoolAssist> tempSchoolAssists = new();
                await foreach (var temp in GetSchools(cosmosClient, schoolAssists)) 
                {
                    tempSchoolAssists.AddRange(temp);
                }

                return Ok(new { state = 200, schoolAssists = tempSchoolAssists });

            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI,{_option.Location}  /batchschool/get-schoolsinfo  \n {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 使用yieId 关键字 本地效率未测出
        /// </summary>
        /// <param name="cosmosClient"></param>
        /// <param name="schoolAssists"></param>
        /// <returns></returns>
        private async IAsyncEnumerable<List<SchoolAssist>> GetSchools(CosmosClient cosmosClient,List<SchoolAssist> schoolAssists)
        {
            List<SchoolAssist> tempSchoolAssists = new();
            foreach (var temp in schoolAssists)
            {
                var response = await cosmosClient.GetContainer("TEAMModelOS", "School").ReadItemStreamAsync(temp.id, new PartitionKey("ProductSum"));
                if (response.Status == 200)
                {
                    using var json = await JsonDocument.ParseAsync(response.ContentStream);
                    temp.serial = json.RootElement.GetProperty("serial").GetArrayLength();
                    temp.service = json.RootElement.GetProperty("service").GetArrayLength();
                    temp.hard = json.RootElement.GetProperty("hard").GetArrayLength();
                }

                temp.assists = await CommonFind.FindSchoolRoles(cosmosClient, temp.id, "assist");
                tempSchoolAssists.Add(temp);
            }

           yield return tempSchoolAssists;
        }

        /// <summary>
        /// 取得学校所有顾问列表
        /// </summary>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-schoolassist")]
        public async Task<IActionResult> GetSchoolAssist(JsonElement jsonElement)
        {
            try
            {
                string schoolId = (jsonElement.TryGetProperty("schoolId", out JsonElement _schoolId)) ? _schoolId.GetString() : string.Empty;

                Dictionary<string, List<Dictionary<string, string>>> haveSchoolManger = new Dictionary<string, List<Dictionary<string, string>>>();

                string managerWhereOption = (!string.IsNullOrWhiteSpace(schoolId)) ? $" AND c.code = 'Teacher-{schoolId}'" : string.Empty;
                //查询学校的顾问
                string managerSql = $"SELECT DISTINCT REPLACE(c.code, 'Teacher-', '') AS schoolId, c.id, c.name FROM c WHERE ARRAY_CONTAINS(c.roles, 'assist', true) AND c.pk = 'Teacher' AND c.status = 'join'{managerWhereOption}";
                var cosmosClent = _azureCosmos.GetCosmosClient();
                await foreach (var item in cosmosClent.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: managerSql, requestOptions: new QueryRequestOptions() { }))
                {
                    using var json = await JsonDocument.ParseAsync(item.ContentStream);
                    foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        string id = obj.GetProperty("id").GetString(); //管理员ID
                        string name = obj.GetProperty("name").GetString(); //管理员姓名
                        string tempSchoolId = obj.GetProperty("schoolId").GetString(); //学校ID
                        Dictionary<string, string> managerDic = new Dictionary<string, string>();
                        managerDic.Add("id", id);
                        managerDic.Add("name", name);
                        if (haveSchoolManger.ContainsKey(tempSchoolId))
                        {
                            haveSchoolManger[tempSchoolId].Add(managerDic);
                        }
                        else
                        {
                            List<Dictionary<string, string>> managerList = new List<Dictionary<string, string>>();
                            managerList.Add(managerDic);
                            haveSchoolManger.Add(tempSchoolId, managerList);
                        }
                    }
                }

                //管理模组学校
                List<string> baseModuleSchoos = new List<string>();
                string baseWhereOption = (!string.IsNullOrEmpty(schoolId)) ? $" and c.id='{schoolId}'" : string.Empty;
                await foreach (var item in cosmosClent.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: $"select c.id from c join serviceProduct in c.service.product where serviceProduct.prodCode = 'IPDYZYLC' {baseWhereOption}", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Product") }))
                {
                    using var json = await JsonDocument.ParseAsync(item.ContentStream);
                    foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        string tempSchoolId = obj.GetProperty("id").GetString();  //学校ID
                        baseModuleSchoos.Add(tempSchoolId);
                    }
                }

                //学校信息
                List<object> schools = new List<object>();
                string schoolWhereOption = (!string.IsNullOrEmpty(schoolId)) ? $" where c.id='{schoolId}'" : string.Empty;
                await foreach (var item in cosmosClent.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: $"select c.id,c.name,c.period,c.schoolCode,c.region,c.province,c.city,c.picture from c {schoolWhereOption}", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
                {
                    using var json = await JsonDocument.ParseAsync(item.ContentStream);
                    foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                    {
                        dynamic schoolExpando = new ExpandoObject();
                        schoolExpando.id = obj.GetProperty("id").GetString();
                        schoolExpando.name = obj.GetProperty("name").GetString();
                        //schoolExpando.period = obj.GetProperty("period");
                        schoolExpando.schoolCode = obj.GetProperty("schoolCode").GetString();
                        schoolExpando.region = obj.GetProperty("region").GetString();
                        schoolExpando.province = obj.GetProperty("province").GetString();
                        schoolExpando.city = obj.GetProperty("city").GetString();
                        schoolExpando.picture = obj.GetProperty("picture").GetString();
                        if (haveSchoolManger.ContainsKey(schoolExpando.id))
                        {
                            schoolExpando.hasMarger = true;
                            schoolExpando.managers = haveSchoolManger[schoolExpando.id];
                        }
                        else
                        {
                            schoolExpando.hasMarger = false;
                            schoolExpando.managers = new List<object>();
                        }
                        schoolExpando.hasBaseModule = (baseModuleSchoos.Contains(schoolExpando.id)) ? true : false;
                        schools.Add(schoolExpando);
                    }
                }

                return Ok(new { state = 200, schools });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI,{_option.Location}  /batchschool/get-schools \n {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 修改学校信息和顾问信息
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [AuthToken(Roles = "assist")]
        [HttpPost("upd-schoolassist")]
        public async Task<IActionResult> UpdSchoolAssist(JsonElement jsonElement)
        {
            try
            {
                if (!jsonElement.TryGetProperty("schoolId", out JsonElement _schoolId)) return BadRequest();
                if (!jsonElement.TryGetProperty("name", out JsonElement schoolName)) return BadRequest();
                if (!jsonElement.TryGetProperty("areaId", out JsonElement areaId)) return BadRequest();
                if (!jsonElement.TryGetProperty("standard", out JsonElement standard)) return BadRequest();
                //if (!jsonElement.TryGetProperty("period", out JsonElement period)) return BadRequest();
                if (!jsonElement.TryGetProperty("picture", out JsonElement picture)) return BadRequest();
                if (!jsonElement.TryGetProperty("size", out JsonElement size)) return BadRequest();
                if (!jsonElement.TryGetProperty("scale", out JsonElement scale)) return BadRequest();
                if (!jsonElement.TryGetProperty("assistId", out JsonElement _assistId)) return BadRequest();
                if (!jsonElement.TryGetProperty("type", out JsonElement _type)) return BadRequest();

                var (_tmdId, _tmdName, pic, did, dname, dpic) = HttpJwtAnalysis.JwtXAuthBI(HttpContext.GetXAuth("AuthToken"), _option);

                List<string> assistId = _assistId.ToObject<List<string>>();
                //List<string> periodS = period.ToObject<List<string>>();

                Dictionary<string, List<Dictionary<string, string>>> haveSchoolManger = new Dictionary<string, List<Dictionary<string, string>>>();

                var cosmosClient = _azureCosmos.GetCosmosClient();
                School tempShool = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>($"{_schoolId}", new PartitionKey("Base"));
                if (tempShool != null)
                {
                    List<Period> periods = new List<Period>();
                    string campusId = Guid.NewGuid().ToString();
                    //periodS.ForEach(x =>
                    //{
                    //    periods.Add(new Period { id = Guid.NewGuid().ToString(), name = x.ToString(), campusId = campusId });
                    //});

                    //tempShool.period = periods;
                    tempShool.size = !string.IsNullOrEmpty($"{size}") ? int.Parse($"{size}") : tempShool.size;
                    tempShool.scale = !string.IsNullOrEmpty($"{scale}") ? int.Parse($"{scale}") : tempShool.scale;
                    tempShool.picture = $"{picture}";
                    tempShool.type = int.Parse($"{_type}");
                    tempShool.name = $"{schoolName}";
                    tempShool.areaId = $"{areaId}";
                    tempShool.standard = $"{standard}";

                    //修改学校
                    await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<School>(tempShool, tempShool.id, new PartitionKey("Base"));

                    //修改学校教师关联的信息
                    string sql = $"SELECT distinct value(c) FROM c join A1 in c.schools where A1.schoolId='{tempShool.id}'";
                    List<Teacher> teachers = new List<Teacher>();
                    await foreach (var item in cosmosClient.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(tempShool.id));
                        if (teacherSchool != null)
                        {
                            teacherSchool.name = tempShool.name;
                            teacherSchool.picture = tempShool.picture;
                            teacherSchool.areaId = tempShool.areaId;
                        }
                        await cosmosClient.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync(item, item.id, new PartitionKey($"Base"));
                    }

                    //修改学校顾问
                    string sqlTxt = $"SELECT value(c) From c WHERE ARRAY_CONTAINS(c.roles,'assist',true)";
                    List<SchoolTeacher> schoolTeachers = new List<SchoolTeacher>();
                    await foreach (var item in cosmosClient.GetContainer("TEAMModelOS", "School").GetItemQueryIterator<SchoolTeacher>(queryText: sqlTxt, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{tempShool.id}") }))
                    {
                        if (!assistId.Contains(item.id)) 
                        {
                            if (item.roles.Contains("assist"))
                            {
                                item.roles.Remove("assist");
                                if (item.roles.Count > 0)
                                {
                                    await cosmosClient.GetContainer("TEAMModelOS", "School").ReplaceItemAsync<SchoolTeacher>(item, item.id, new PartitionKey(item.code));
                                }
                                else
                                {
                                    await cosmosClient.GetContainer("TEAMModelOS", "School").DeleteItemAsync<SchoolTeacher>(item.id, new PartitionKey(item.code));
                                }
                            }
                        }                   
                    }

                    if (assistId.Count > 0)
                    {
                        foreach (var itemTeacher in assistId)
                        {
                            Teacher tempTeacher = await cosmosClient.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Teacher>($"{itemTeacher}", new PartitionKey("Base"));
                            if (tempTeacher != null)
                            {
                                var haveTeacher = tempTeacher.schools.Find(x => x.schoolId.Equals($"{_schoolId}"));
                                if (haveTeacher != null)
                                {
                                    //查询该教师是否存在该校
                                    SchoolTeacher schoolTeacher = null;
                                    try
                                    {
                                        schoolTeacher = await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>($"{itemTeacher}", new PartitionKey($"Teacher-{tempShool.id}"));
                                    }
                                    catch
                                    {
                                    }

                                    if (schoolTeacher != null)
                                    {
                                        if (!schoolTeacher.roles.Contains("assist"))
                                        {
                                            schoolTeacher.roles.Add("assist");
                                            //添加顾问权限
                                            await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(schoolTeacher, schoolTeacher.id, new PartitionKey($"Teacher-{tempShool.id}"));
                                        }
                                    }
                                    else
                                    {
                                        SchoolTeacher addSchoolTeacher = new SchoolTeacher
                                        {
                                            id = itemTeacher,
                                            code = $"Teacher-{tempShool.id}",
                                            pk = "Teacher",
                                            status = "join",
                                            roles = new List<string>() { "assist" },
                                            name = tempTeacher.name,
                                            job = $"{tempShool.name}-顾问",
                                            size = 0,
                                            createTime = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
                                        };
                                        //添加学校顾问
                                        await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<SchoolTeacher>(addSchoolTeacher, new PartitionKey($"Teacher-{tempShool.id}"));
                                    }
                                }
                                else
                                {
                                    Teacher.TeacherSchool teacherSchool = new Teacher.TeacherSchool
                                    {
                                        schoolId = tempShool.id,
                                        name = tempShool.name,
                                        status = "join",
                                        time = DateTimeOffset.UtcNow.ToUnixTimeSeconds(),
                                        picture = tempShool.picture,
                                        areaId = tempShool.areaId
                                    };
                                    tempTeacher.schools.Add(teacherSchool);
                                    //给醍摩豆顾问添加学校
                                    await cosmosClient.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(tempTeacher, tempTeacher.id, new PartitionKey($"Base"));

                                    //不存在则在原来的基础上添加顾问角色
                                    SchoolTeacher addSchoolTeacher = new SchoolTeacher
                                    {
                                        id = itemTeacher,
                                        code = $"Teacher-{tempShool.id}",
                                        pk = "Teacher",
                                        status = "join",
                                        roles = new List<string>() { "assist" },
                                        name = tempTeacher.name,
                                        job = $"{tempShool.name}-顾问",
                                        size = 0,
                                        createTime = DateTimeOffset.UtcNow.ToUnixTimeSeconds()
                                    };
                                    //添加学校学校顾问
                                    await cosmosClient.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<SchoolTeacher>(addSchoolTeacher, new PartitionKey($"Teacher-{tempShool.id}"));
                                }
                            }
                        }
                    }
                }

                //保存操作记录
                await _azureStorage.SaveBILog("TeacherRoles-update", $"{_tmdName}【{_tmdId}】修改学校功能，修改的学校:{_schoolId},{_type},{picture},{size},{string.Join("|", assistId.ToArray())}", _dingDing, httpContext: HttpContext);


                return Ok(new { state = 200 });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI,  {_option.Location}   /batchschool/upd-schoolassist   \n  {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 查询区域的学校
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [ProducesDefaultResponseType]
        [HttpPost("get-schooldist")]
        public async Task<IActionResult> GetSchoolDist(JsonElement jsonElement)
        {
            try
            {
                if (!jsonElement.TryGetProperty("dist", out JsonElement _dist)) return BadRequest();

                var cosmosClient = _azureCosmos.GetCosmosClient();
                string sqltxt = $"SELECT * FROM c where c.dist='{_dist}'";

                List<School> schools = new List<School>();

                await foreach (var item in cosmosClient.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<School>(queryText: sqltxt, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
                {
                    schools.Add(item);
                }

                return Ok(new { state = 200, schools });
            }
            catch (Exception ex)
            {
                await _dingDing.SendBotMsg($"BI,{_option.Location}   /batchschool/get-schooldist  \n  {ex.Message}{ex.StackTrace}", GroupNames.成都开发測試群組);
                return BadRequest();
            }
        }

        /// <summary>
        /// 分页学校和顾问信息
        /// </summary>
        /// <param name="jsonElement"></param>
        /// <returns></returns>
        [HttpPost("get-schools")]
        public async Task<IActionResult> GetSchools(JsonElement jsonElement) 
        {
            //List<School> schools = new List<School>();
            List<SchoolAssist> schoolAssists = new List<SchoolAssist>();
            var cosmosClient = _azureCosmos.GetCosmosClient();
            if (!jsonElement.TryGetProperty("endPosition", out JsonElement endPosition)) return BadRequest();
            if (!jsonElement.TryGetProperty("pageSize", out JsonElement pageSize)) return BadRequest();

            string sqltxt = $"SELECT * FROM c order by c.id offset {endPosition} limit {pageSize}";

            await foreach (var itemSchool in cosmosClient.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<School>(queryText: sqltxt, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
            {
                SchoolAssist schoolAssist = new SchoolAssist()
                {
                    id = itemSchool.id,
                    code = itemSchool.code,
                    schoolCode = itemSchool.schoolCode,
                    name = itemSchool.name,
                    region = itemSchool.region,
                    province = itemSchool.province,
                    city = itemSchool.city,
                    dist = itemSchool.dist,
                    size = itemSchool.size,
                    address = itemSchool.address,
                    picture = itemSchool.picture,
                    type = itemSchool.type,
                    scale = itemSchool.scale,
                    areaId = itemSchool.areaId,
                    standard = itemSchool.standard
                };

                schoolAssist.assists = await CommonFind.FindSchoolRoles(cosmosClient, itemSchool.id, "assist");

                //List<Assist> assists = new List<Assist>();
                ////查询学校的顾问
                //string managerSql = $"SELECT DISTINCT REPLACE(c.code, 'Teacher-', '') AS schoolId, c.id, c.name FROM c WHERE ARRAY_CONTAINS(c.roles, 'assist', true) AND c.pk = 'Teacher' AND c.status = 'join' AND c.code = 'Teacher-{itemSchool.id}'";
                //var cosmosClent = _azureCosmos.GetCosmosClient();
                //await foreach (var item in cosmosClent.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: managerSql, requestOptions: new QueryRequestOptions() { }))
                //{
                //    using var json = await JsonDocument.ParseAsync(item.ContentStream);
                //    foreach (var obj in json.RootElement.GetProperty("Documents").EnumerateArray())
                //    {
                //        Assist assist = new Assist
                //        {
                //            tmdId = obj.GetProperty("id").GetString(),
                //            tmdName = obj.GetProperty("name").GetString()
                //        };

                //        assists.Add(assist);
                //    }
                //}
                //schoolAssist.assists = assists;

                schoolAssists.Add(schoolAssist);
            }

            return Ok(new { state = 200, schoolAssists });
        }


        #region   预设学校基础信息 多语言
        /// <summary>
        /// 预设学校基础信息 多语言
        /// </summary>
        /// <param name="period"></param>
        /// <param name="Language"></param>
        /// <param name="campusId"></param>
        /// <returns></returns>
        public List<Period> PresetSchoolPeriod(List<string> period, string Language, string campusId)
        {
            var builder = $"{_environment.ContentRootPath}/JsonFile/Preset/LangSchoolConfig.json";
            StreamReader streamReader = new StreamReader(new FileStream(builder, FileMode.Open, FileAccess.Read, FileShare.ReadWrite), Encoding.UTF8);
            StringBuilder stringBuilder = new StringBuilder();
            string text;
            while ((text = streamReader.ReadLine()) != null)
            {
                stringBuilder.Append(text.ToString());
            }
            streamReader.Close();
            string input = stringBuilder.ToString();
            List<SchoolConfig> schoolConfigs = input.ToObject<List<SchoolConfig>>();
            SchoolConfig schoolConfig = schoolConfigs.Find(x => x.Lang.Contains($"{Language}"));
           
            if (schoolConfig == null)
            {
                if (Language.Contains("en"))
                    schoolConfig = schoolConfigs.Find(x => x.Lang.Contains("en-US"));
                else
                    schoolConfig = schoolConfigs.Find(x => x.Lang.Contains("zh-CN"));
            }

            List<Period> periods = new List<Period>();
            period.ForEach(x =>
            {
                periods.Add(new Period
                {
                    id = Guid.NewGuid().ToString(),
                    name = x,
                    campusId = campusId,
                    semesters = new List<Semester>() { new Semester { name = schoolConfig.semester[0].term, start = schoolConfig.semester[0].start, month = schoolConfig.semester[0].month, day = schoolConfig.semester[0].day, id = Guid.NewGuid().ToString() },
                        new Semester { name = schoolConfig.semester[1].term, start = schoolConfig.semester[1].start, month = schoolConfig.semester[1].month, day = schoolConfig.semester[1].day, id = Guid.NewGuid().ToString() } },
                    subjects = new List<Subject>() {
                        new Subject { id=Guid.NewGuid().ToString(),name=schoolConfig.PresetSubject[0].name,type=schoolConfig.PresetSubject[0].type },
                        new Subject { id=Guid.NewGuid().ToString(),name=schoolConfig.PresetSubject[1].name,type=schoolConfig.PresetSubject[1].type },
                        new Subject { id=Guid.NewGuid().ToString(),name=schoolConfig.PresetSubject[2].name,type=schoolConfig.PresetSubject[2].type }
                    },
                    grades = schoolConfig.grades,
                    analysis = new Analysis()
                    {
                        type = new List<ExamSimple>() { new ExamSimple { id = Guid.NewGuid().ToString(), name = schoolConfig.PresetExam[0].type[0].name },
                        new ExamSimple { id = Guid.NewGuid().ToString(), name =  schoolConfig.PresetExam[0].type[1].name },
                        new ExamSimple { id = Guid.NewGuid().ToString(), name =  schoolConfig.PresetExam[0].type[2].name },
                        new ExamSimple { id = Guid.NewGuid().ToString(), name =  schoolConfig.PresetExam[0].type[3].name } },
                        income = schoolConfig.PresetExam[0].income,
                        eugenics = schoolConfig.PresetExam[0].eugenics,
                        touch = schoolConfig.PresetExam[0].touch
                    }
                });
            });

            return periods;
        }

        public record SchoolConfig
        {
            public string Lang { get; set; }
            public List<semester> semester { get; set; }
            public List<string> grades { get; set; }
            public List<PresetSubject> PresetSubject { get; set; }
            public List<PresetExam> PresetExam { get; set; }
        }

        public record semester
        {
            public string id { get; set; } = Guid.NewGuid().ToString();
            public string term { get; set; }
            public int start { get; set; }
            public int month { get; set; }
            public int day { get; set; }
        }

        public record PresetSubject
        {
            public string id { get; set; } = Guid.NewGuid().ToString();
            public string name { get; set; }

            public int type { get; set; }
        }

        public record PresetExam
        {
            public List<StudyType> type { get; set; }

            public int income { get; set; }

            public int eugenics { get; set; }

            public int touch { get; set; }
        }

        public record StudyType
        {
            public string id { get; set; } = Guid.NewGuid().ToString();
            public string name { get; set; }
        }

        #endregion

        public class SchoolAssist
        {
            public string id { get; set; }
            public string code { get; set; }
            public string schoolCode { get; set; }
            public string name { get; set; }
            public string region { get; set; }
            public string province { get; set; }
            public string city { get; set; }
            public string dist { get; set; }
            public int size { get; set; }
            public string address { get; set; }
            public string picture { get; set; }
            public int type { get; set; }
            public int scale { get; set; }
            public string standard { get; set; }
            public string areaId { get; set; }
            public List<SchoolTeacherRoles> assists { get; set; }
            public int serial { get; set; } //软体
            public int service { get; set; } //服务
            public int hard { get; set; } //硬体
            //public List<SchoolProductSumData> serial { get; set; } //软体
            //public List<SchoolProductSumData> service { get; set; } //服务
            //public List<SchoolProductSumDataHard> hard { get; set; } //硬体

        }


        /// <summary>
        /// 创建多个学校实体
        /// </summary>
        public record FoundSchools()
        {
            /// <summary>
            /// 语系
            /// </summary>
            public string lang { get; set; }

            /// <summary>
            /// 批量创校的数据结构
            /// </summary>
            public List<BISchool> biSchools { get; set; } = new List<BISchool>();
        }

        /// <summary>
        /// 批量创校的数据结构
        /// </summary>
        public record BISchool()
        {
            /// <summary>
            /// 学校名称
            /// </summary>
            public string name { get; set; }
            /// <summary>
            /// 学校管理员
            /// </summary>
            public string admin { get; set; }
            /// <summary>
            /// 学校的学段
            /// </summary>
            public List<string> period { get; set; }
            /// <summary>
            /// 学校空间大小
            /// </summary>
            public int size { get; set; }
            /// <summary>
            /// 地区
            /// </summary>
            public string region { get; set; }
            /// <summary>
            /// 省份
            /// </summary>
            public string province { get; set; }
            /// <summary>
            /// 城市
            /// </summary>
            public string city { get; set; }
            /// <summary>
            /// 县，区，郡
            /// </summary>
            public string dist { get; set; }

            /// <summary>
            /// 学校详细地址
            /// </summary>
            public string address { get; set; }
            /// <summary>
            /// 学校类型
            /// </summary>
            public int type { get; set; }
            /// <summary>
            /// 区域ID
            /// </summary>
            public string areaId { get; set; }
        }

        public record Exist()
        {
            public string ID { get; set; }
            public string name { get; set; }
        }


    }
}