123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443 |
- using Azure.Cosmos;
- using Azure.Storage.Blobs.Models;
- using Azure.Storage.Sas;
- using Microsoft.AspNetCore.Http;
- using Microsoft.AspNetCore.Mvc;
- using Microsoft.Extensions.Options;
- using System;
- using System.Collections.Generic;
- using System.Dynamic;
- using System.IdentityModel.Tokens.Jwt;
- using System.IO;
- using System.Linq;
- using System.Text.Json;
- using System.Threading.Tasks;
- using TEAMModelOS.Models;
- using TEAMModelOS.SDK.Models;
- using TEAMModelOS.SDK.DI;
- using TEAMModelOS.SDK.Extension;
- using TEAMModelOS.Filter;
- using TEAMModelOS.SDK.Models.Cosmos;
- using HTEXLib.COMM.Helpers;
- using TEAMModelOS.SDK.Models.Service;
- using Microsoft.Extensions.Configuration;
- using System.Net.Http;
- using TEAMModelOS.SDK;
- using static TEAMModelOS.SDK.Models.Teacher;
- using TEAMModelOS.Services;
- using Microsoft.AspNetCore.Authorization;
- using System.Diagnostics;
- using Microsoft.Extensions.Logging;
- using System.Text;
- using Microsoft.Azure.Cosmos.Table;
- using Microsoft.AspNetCore.Hosting;
- using DocumentFormat.OpenXml.Office2010.Excel;
- using DocumentFormat.OpenXml.Drawing.Charts;
- using static TEAMModelOS.Controllers.FixDataController;
- using IdCode = TEAMModelOS.SDK.Models.IdCode;
- using TEAMModelOS.SDK.Models.Service.BI;
- using TEAMModelOS.SDK.Services;
- namespace TEAMModelOS.Controllers
- {
- [ProducesResponseType(StatusCodes.Status200OK)]
- [ProducesResponseType(StatusCodes.Status400BadRequest)]
- [Route("teacher/init")]
- [ApiController]
- public class InitController : ControllerBase
- {
- private readonly AzureCosmosFactory _azureCosmos;
- private readonly AzureStorageFactory _azureStorage;
- private readonly AzureRedisFactory _azureRedis;
- private readonly DingDing _dingDing;
- private readonly Option _option;
- private readonly IConfiguration _configuration;
- private readonly CoreAPIHttpService _coreAPIHttpService;
- private readonly IPSearcher _searcher;
- private readonly ILogger<InitController> _logger;
- private readonly HttpTrigger _httpTrigger;
- private readonly IWebHostEnvironment _environment;
- public InitController(IWebHostEnvironment environment,ILogger<InitController> logger, IPSearcher searcher, CoreAPIHttpService coreAPIHttpService, AzureCosmosFactory azureCosmos, AzureStorageFactory azureStorage, AzureRedisFactory azureRedis, DingDing dingDing, IOptionsSnapshot<Option> option, IConfiguration configuration, HttpTrigger httpTrigger)
- {
- _searcher = searcher;
- _azureCosmos = azureCosmos;
- _azureStorage = azureStorage;
- _azureRedis = azureRedis;
- _dingDing = dingDing;
- _option = option?.Value;
- _configuration = configuration;
- _coreAPIHttpService = coreAPIHttpService;
- _logger = logger;
- _httpTrigger = httpTrigger;
- _environment = environment;
- }
- /// <summary>
- /// 修改教师信息
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [HttpPost("GetUserInfo")]
- //[Authorize(Roles = "IES")]
- public async Task<IActionResult> GetUserInfo(JsonElement request)
- {
- if (!request.TryGetProperty("key", out JsonElement key)) return BadRequest();
- var location = _option.Location;
- //https://api2-rc.teammodel.cn
- CoreUser core = await _coreAPIHttpService.GetUserInfo(new Dictionary<string, string>()
- { { "key",$"{key}" }
- }, location, _configuration
- );
- if (core != null)
- {
- var clientID = _configuration.GetValue<string>("HaBookAuth:CoreService:clientID");
- TmdidImplicit tmdidImplicit = await _coreAPIHttpService.Implicit(new Dictionary<string, string> { { "grant_type", "implicit" },
- { "client_id",clientID },
- { "account",core.id },
- { "nonce",Guid.NewGuid().ToString()} }, _option.Location, _configuration);
- if (tmdidImplicit != null && !string.IsNullOrEmpty(tmdidImplicit.id_token))
- {
- return Ok(new { coreUser = core, tmdidImplicit });
- }
- }
- return Ok(new { coreUser = core });
- }
- /// <summary>
- /// 修改教师信息
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [HttpPost("set-teacher-info")]
- [AuthToken(Roles = "admin,teacher,area")]
- [Authorize(Roles = "IES")]
- public async Task<IActionResult> SetTeacherInfo(JsonElement request)
- {
- var client = _azureCosmos.GetCosmosClient();
- var tableClient = _azureStorage.GetCloudTableClient();
- var blobClient = _azureStorage.GetBlobContainerClient(containerName: "0-public");
- if (!request.TryGetProperty("opt", out JsonElement _opt))
- {
- return BadRequest();
- }
- var (userid, name, _, school) = HttpContext.GetAuthTokenInfo();
- try
- {
-
- switch (true)
- {
- //修改常用语系
- case bool when $"{_opt}".Equals("UpdateLang", StringComparison.OrdinalIgnoreCase) && (request.TryGetProperty("lang", out JsonElement lang)):
- {
- Teacher teacher = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Teacher>(userid, new PartitionKey("Base"));
- if (!string.IsNullOrEmpty($"{lang}"))
- {
- teacher.lang = $"{lang}";
- await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacher, userid, new PartitionKey("Base"));
- return Ok(new { teacher, status = 1 });
- }
- else
- {
- return BadRequest(new { status = -1, msg = "语系参数为空!" });
- }
- }
- //修改默认学校
- case bool when $"{_opt}".Equals("UpdateDefaultSchool", StringComparison.OrdinalIgnoreCase) && (request.TryGetProperty("defaultSchool", out JsonElement _defaultSchool)):
- {
- Teacher teacher = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Teacher>(userid, new PartitionKey("Base"));
- if (teacher.schools.Select(x => x.schoolId).Contains($"{_defaultSchool}") && !string.IsNullOrEmpty($"{_defaultSchool}"))
- {
- teacher.defaultSchool = $"{_defaultSchool}";
- await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacher, userid, new PartitionKey("Base"));
- return Ok(new { teacher, status = 1 });
- }
- else
- {
- return BadRequest(new { status = -1, msg = "您未加入该学校!" });
- }
- }
- //修改教师的最大课例保存数量
- case bool when $"{_opt}".Equals("UpdateLessonLimit", StringComparison.OrdinalIgnoreCase) && (request.TryGetProperty("lessonLimit", out JsonElement _lessonLimit)):
- {
- Teacher teacher = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Teacher>(userid, new PartitionKey("Base"));
- teacher.lessonLimit = int.Parse($"{_lessonLimit}");
- await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacher, userid, new PartitionKey("Base"));
- return Ok(new { teacher, status = 1 });
- }
- //修改教师设置自动将课例发布给谁的设置
- case bool when $"{_opt}".Equals("UpdateLessonShow", StringComparison.OrdinalIgnoreCase) && (request.TryGetProperty("lessonShow", out JsonElement _lessonShow)):
- {
- Teacher teacher = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Teacher>(userid, new PartitionKey("Base"));
- teacher.lessonShow = _lessonShow.Deserialize<List<string>>();
- await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacher, userid, new PartitionKey("Base"));
- return Ok(new { teacher, status = 1 });
- }
- //设置教师的科目信息
- case bool when $"{_opt}".Equals("SetTeacherSubject", StringComparison.OrdinalIgnoreCase) && request.TryGetProperty("targerTecher", out JsonElement _targetTecher)
- && request.TryGetProperty("subjectIds", out JsonElement _subjectIds):
- if (_subjectIds.ValueKind.Equals(JsonValueKind.Array))
- {
- if (_targetTecher.ValueKind.Equals(JsonValueKind.Array))
- {
- List<string> targetTechers = _targetTecher.ToObject<List<string>>();
- List<SchoolTeacher> schoolTeachers = new List<SchoolTeacher>();
- foreach (string targetTecher in targetTechers)
- {
- try
- {
- SchoolTeacher schoolTeacher = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>($"{targetTecher}", new PartitionKey($"Teacher-{school}"));
- schoolTeacher.subjectIds = _subjectIds.ToObject<List<string>>();
- await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(schoolTeacher, $"{targetTecher}", new PartitionKey($"Teacher-{school}"));
- schoolTeachers.Add(schoolTeacher);
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/init/set-teacher-info:SetTeacherSubject()\n{ex.Message}\n{ex.StackTrace}{request.ToJsonString()}-{targetTecher}", GroupNames.醍摩豆服務運維群組);
- }
- }
- return Ok(new { status = 1, schoolTeachers });
- }
- else
- {
- try
- {
- SchoolTeacher schoolTeacher = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>($"{_targetTecher}", new PartitionKey($"Teacher-{school}"));
- schoolTeacher.subjectIds = _subjectIds.ToObject<List<string>>();
- await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(schoolTeacher, $"{_targetTecher}", new PartitionKey($"Teacher-{school}"));
- return Ok(new { status = 1, schoolTeacher });
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/init/set-teacher-info:SetTeacherSubject()\n{ex.Message}\n{ex.StackTrace}{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
- return Ok(new { error = -1, msg = "设置失败" });
- }
- }
- }
- else
- {
- return Ok(new { error = -1, msg = "设置失败" });
- }
- ///移交管理员
- case bool when $"{_opt}".Equals("TransferAdminRole", StringComparison.OrdinalIgnoreCase) && (request.TryGetProperty("targerTecher", out JsonElement _targetTecher)):
- if (!string.IsNullOrEmpty(school) && !string.IsNullOrEmpty($"{_targetTecher}"))
- {
- StringBuilder strMsg = new($"{name}【{userid}】将");
- SchoolTeacher schoolTeacher = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>(userid, new PartitionKey($"Teacher-{school}"));
-
- if (schoolTeacher.roles.IsNotEmpty() && schoolTeacher.roles.Contains("admin"))
- {
- schoolTeacher.roles.Remove("admin");
- SchoolTeacher newSchoolTeacher = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>($"{_targetTecher}", new PartitionKey($"Teacher-{school}"));
- if (!newSchoolTeacher.roles.Contains("admin"))
- {
- newSchoolTeacher.roles.Add("admin");
- newSchoolTeacher = await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(newSchoolTeacher, $"{_targetTecher}", new PartitionKey($"Teacher-{school}"));
- }
- await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(schoolTeacher, userid, new PartitionKey($"Teacher-{school}"));
- string code = "transfer-admin";
- School schoolBase = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>(school, new PartitionKey($"Base"));
- strMsg.Append($"学校{schoolBase.name}[{schoolBase.id}] 的管理员权限移交给");
-
- Teacher targetTeacher = await client.GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReadItemAsync<Teacher>($"{_targetTecher}", new PartitionKey($"Base"));
- strMsg.Append($"{targetTeacher.name}[{targetTeacher.id}]");
- _coreAPIHttpService.PushNotify(new List<IdNameCode> { new IdNameCode { id= targetTeacher.id,name= targetTeacher.name,code=targetTeacher.lang} }, "transfer-admin_school", Constant.NotifyType_IES5_Management,
- new Dictionary<string, object> { { "tmdname", name },{ "schoolName", schoolBase.name }, { "schoolId", $"{school}" } , { "tmdid", userid } }, _option.Location, _configuration, _dingDing, _environment.ContentRootPath);
- // _ = _azureStorage.SaveLog("transfer-admin-role", new { request, userid, name, school, schoolName = schoolBase.name, targetTecher = _targetTecher, }.ToJsonString(), bizId: $"{userid}-{schoolBase.id}-{_targetTecher}", httpContext: HttpContext, dingDing: _dingDing, scope: "school");
- //保存日志
- Dictionary<string, object> replaceData = new() { { "oName" ,$"{name}" }, { "oId", $"{userid}" }, { "scName", $"{schoolBase.name}" }, { "scId", $"{schoolBase.id}" } , { "tName", $"{targetTeacher.name}" }, { "tId", $"{targetTeacher.id}" } };
- _ = _azureStorage.SaveLogLang("transfer-admin-role", _environment.ContentRootPath, replaceData, _dingDing, bizId: $"{userid}-{schoolBase.id}-{_targetTecher}", httpContext: HttpContext, scope: "school");
- //保存管理员移交至BI
- await AzureStorageBlobExtensions.SaveBILog(blobClient, tableClient, "school-transfer-admin", strMsg?.ToString(), _dingDing, twebsite: "IES5", httpContext: HttpContext);
- var adminAdd = new HashSet<string>();
- adminAdd.Add(newSchoolTeacher.id);
- var adminRmv = new HashSet<string>();
- adminRmv.Add(schoolTeacher.id);
- string head_lang = "";
- if (HttpContext.Request.Headers.TryGetValue("lang", out var _lang))
- {
- head_lang = $"{_lang}";
- }
- string lang = !string.IsNullOrWhiteSpace(head_lang) ? head_lang : _option.Location.Contains("China") ? "zh-cn" : "en-us";
- await _coreAPIHttpService.AdminChange(new AdminChange { school = school, adminAdd = adminAdd, adminRmv = adminRmv,lang= lang,adminType= "master" },_option.Location,_configuration,_dingDing);
- return Ok(new { status = 1 });
- }
- else
- {
- return BadRequest(new { status = -1, msg = "当前登录账号没有admin权限" });
- }
- }
- else
- {
- return BadRequest(new { status = -1, msg = "参数异常!" });
- }
- //修改教师其他信息。
- case bool when $"{_opt}".Equals("UpdateMoreInfo", StringComparison.OrdinalIgnoreCase) && (request.TryGetProperty("teacherInfo", out JsonElement _teacherInfo)):
- var techinfo = _teacherInfo.Deserialize<UpdateTeacherInfo>();
- TeacherImport teacherImport = null;
- long now = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
- if (techinfo != null && ! string.IsNullOrWhiteSpace(techinfo.id)) {
- try
- {
- SchoolTeacher schoolTeacher = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<SchoolTeacher>(techinfo.id, new PartitionKey($"Teacher-{school}"));
- schoolTeacher.subjectIds =techinfo.subjectIds!=null ? techinfo.subjectIds : schoolTeacher.subjectIds;
- schoolTeacher.job = techinfo.job!=null ? techinfo.job : schoolTeacher.job;
- schoolTeacher.periodId = techinfo.periodId!=null ? techinfo.periodId : schoolTeacher.periodId;
- await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync<SchoolTeacher>(schoolTeacher, techinfo.id, new PartitionKey($"Teacher-{school}"));
- Azure.Response response = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemStreamAsync($"{school}", new PartitionKey("TeacherImport"));
- if (response.Status == 200)
- {
- teacherImport = JsonDocument.Parse(response.Content).RootElement.Deserialize<TeacherImport>();
- var teacherImportInfo= teacherImport.teachers.Find(x =>!string.IsNullOrWhiteSpace(x.id) && x.id.Equals(techinfo.id));
- if (teacherImportInfo == null)
- {
- teacherImport.teachers.Add(new ImportTeacher
- {
- time = now,
- status = schoolTeacher.status,
- name = schoolTeacher.name,
- iname = techinfo.iname,
- picture = schoolTeacher.picture,
- tmdid = schoolTeacher.id,
- note = techinfo.note,
- id = techinfo.id
- });
- }
- else
- {
- teacherImportInfo.tmdid = schoolTeacher.id;
- teacherImportInfo.picture = schoolTeacher.picture;
- teacherImportInfo.status = schoolTeacher.status;
- teacherImportInfo.name = schoolTeacher.name;
- teacherImportInfo.iname= techinfo.iname !=null ? techinfo.iname:teacherImportInfo.iname;
- teacherImportInfo.note = techinfo.note != null ? techinfo.note : teacherImportInfo.note;
- }
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(teacherImport, $"{school}", new PartitionKey("TeacherImport"));
- }
- else {
- teacherImport = new TeacherImport { id = $"{school}", code = "TeacherImport", pk = "TeacherImport", teachers = new List<ImportTeacher> { new ImportTeacher {
- time = now,
- status = schoolTeacher.status,
- name = schoolTeacher.name,
- iname = techinfo.iname,
- picture = schoolTeacher.picture,
- tmdid = schoolTeacher.id,
- note = techinfo.note,
- id = techinfo.id
- } } };
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).CreateItemAsync(teacherImport, new PartitionKey("TeacherImport"));
- }
- return Ok(new { status = 1 });
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/init/set-teacher-info:SetTeacherSubject()\n{ex.Message}\n{ex.StackTrace}{request.ToJsonString()}\n{school}", GroupNames.醍摩豆服務運維群組);
- }
- }
- return BadRequest(new { status = -1, msg = "参数异常!" });
- case bool when $"{_opt}".Equals("QuitSchool", StringComparison.OrdinalIgnoreCase) && request.TryGetProperty("schoolCode", out JsonElement _schoolCode) :
- School qschool= await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemAsync<School>($"{_schoolCode}", new PartitionKey("Base"));
- string sql = $"select value c from c where c.code='Teacher-{_schoolCode}' and c.status='join' and (c.id ='{userid}' or array_contains(c.roles,'admin'))";
- List<SchoolTeacher> adminTeachers = new List<SchoolTeacher>();
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).GetItemQueryIterator<SchoolTeacher>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Teacher-{_schoolCode}") }))
- {
- adminTeachers.Add(item);
- }
- var steacher= adminTeachers.Find(z => z.id.Equals(userid));
- if (steacher != null)
- {
- if (!steacher.roles.Contains("admin"))
- {
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).DeleteItemStreamAsync(steacher.id, new Azure.Cosmos.PartitionKey(steacher.code));
- Teacher qteacher = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReadItemAsync<Teacher>($"{userid}", new PartitionKey("Base"));
- var a = qteacher.schools.RemoveAll(z => z.schoolId.Equals($"{_schoolCode}"));
- if (a > 0)
- {
- qteacher.defaultSchool = null;
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReplaceItemAsync<Teacher>(qteacher, qteacher.id, new PartitionKey("Base"));
- }
- var tmdadmin = adminTeachers.FindAll(z => z.roles.Contains("admin") && !z.id.Equals(userid));
- if (tmdadmin.IsNotEmpty()) {
- List<IdNameCode> ids = new List<IdNameCode>();
- string sqlAdmin = $"select c.id,c.lang as code ,c.name from c where c.id in ({string.Join(",",tmdadmin.Select(z=>$"'{z.id}'"))}) ";
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher)
- .GetItemQueryIterator<IdNameCode>(queryText: sqlAdmin, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Base") }))
- {
- ids.Add(item);
- }
- _coreAPIHttpService.PushNotify(ids, $"quit_school", Constant.NotifyType_IES5_Management,
- new Dictionary<string, object> { { "tmdname", name }, { "schoolName", qschool.name }, { "schoolId", $"{_schoolCode}" }, { "tmdid", userid } }, _option.Location, _configuration, _dingDing, _environment.ContentRootPath);
- // return Ok(new { status =0, msg = "退出成功!"/*, msg = "申请成功!"*/ });
- }
-
- return Ok(new { status = 0, msg = "退出成功!" });
- }
- else
- {
- return Ok(new { status = 2, msg = "请先移交管理员后再退出学校!" });
- }
- }
- else {
- Teacher qteacher = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReadItemAsync<Teacher>($"{userid}", new PartitionKey("Base"));
- var a = qteacher.schools.RemoveAll(z => z.schoolId.Equals($"{_schoolCode}"));
- if (a > 0)
- {
- qteacher.defaultSchool = null;
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher).ReplaceItemAsync<Teacher>(qteacher,qteacher.id, new PartitionKey("Base"));
- return Ok(new { status = 4, msg = "退出成功!" });
- }
- else {
- return Ok(new { status = 1, msg = "未加入学校!" });
- }
- }
- }
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/init/set-teacher-info()\n{ex.Message}\n{ex.StackTrace}{request.ToJsonString()}\n{school}", GroupNames.醍摩豆服務運維群組);
- return BadRequest("teacher not exist");
- }
- return BadRequest();
- }
- public class UpdateTeacherInfo {
- public string id { get; set; }
- public string iname { get; set; }
- public string periodId { get; set; }
- public List<string> subjectIds { get; set; } = new List<string>();
- public string job { get; set; }
- public string note { get; set; }
- }
- //TODO 此API需處理對應前端返回的相關數據
- [ProducesDefaultResponseType]
- [Authorize(Roles = "IES")]
- [HttpPost("get-teacher-info")]
- public async Task<IActionResult> GetTeacherInfo(JsonElement request)
- {
- string head_lang = "";
- if (HttpContext.Request.Headers.TryGetValue("lang", out var _lang)) {
- head_lang = $"{_lang}";
- }
- string OAuthShow_domain = HttpContext?.Request?.Host.Host;
- if (OAuthShow_domain.Equals("teammodelos.chinacloudsites.cn"))
- {
- OAuthShow_domain = _option.HostName;
- }
- if (_option.Location.Equals("China"))
- {
- OAuthShow_domain = _option.HostName;
- }
- if (OAuthShow_domain.Equals("localhost"))
- {
- OAuthShow_domain = "test.teammodel.cn";
- }
- if (!request.TryGetProperty("id_token", out JsonElement id_token)) return BadRequest();
- var jwt = new JwtSecurityToken(id_token.GetString());
- //TODO 此驗證IdToken先簡單檢查,後面需向Core ID新API,驗證Token
- var id = jwt.Payload.Sub;
- jwt.Payload.TryGetValue("name", out object name);
- jwt.Payload.TryGetValue("picture", out object picture);
- jwt.Payload.TryGetValue("lang", out object _jwtlang);
- head_lang = !string.IsNullOrWhiteSpace($"{_jwtlang}") ? $"{_jwtlang}" : head_lang;
- (string ip, string region) = await LoginService.LoginIp(HttpContext, _searcher);
- try
- {
- Teacher teacher = null;
- TeacherInfo teacherInfo = await TeacherService.TeacherInfo(_azureCosmos, teacher, $"{name}", $"{picture}", id, _azureStorage, _option, _azureRedis, ip, _httpTrigger, $"{_lang}");
- teacherInfo.areas.ForEach(x => { if (x.setting != null) { x.setting.accessConfig = x.setting.accessConfig; } });
- LoginService.LoginLog(HttpContext, _option, _logger, _dingDing, ip, region, id, $"{name}", 200);
- int lessonLimit = teacherInfo.teacher.lessonLimit;
- if (teacherInfo.teacher.lessonLimit == 0)
- {
- //未设置的的采用系统设置的默认值30
- lessonLimit = Constant.private_lesson_limit;
- }
- var table = _azureStorage.GetCloudTableClient().GetTableReference("IESOAuth");
- List<string> Codes = new List<string>();
- if (!string.IsNullOrWhiteSpace(id))
- {
- Codes.Add($" Code {QueryComparisons.Equal} '{id}' ");
- }
- string qurey = $"PartitionKey {QueryComparisons.Equal} 'OAuthShow' and Domain {QueryComparisons.Equal} '{OAuthShow_domain}' and ( { string.Join(" or ", Codes)} ) ";
- var result = await table.ExecuteQuerySegmentedAsync(new TableQuery<OAuthShow>().Where(qurey), null);
- List<OAuthShow> shows = result.Results;
- string lang = !string.IsNullOrWhiteSpace(teacherInfo.teacher.lang) ? teacherInfo.teacher.lang : head_lang;
- //返回剩余空间
- (long usedSize, long teach, long total, long surplus, Dictionary<string, double?> catalog) space =
- await BlobService.GetSurplusSpace(teacher.id, "private", _option.Location, _azureCosmos, _azureRedis, _azureStorage, _dingDing, _httpTrigger);
- if (string.IsNullOrWhiteSpace(lang))
- {
- if (_option.Location.Contains("China"))
- {
- lang = "zh-cn";
- }
- else
- {
- lang = "en-us";
- }
- }
- else {
- if (lang.Equals("null")) {
- if (_option.Location.Contains("China"))
- {
- lang = "zh-cn";
- }
- else
- {
- lang = "en-us";
- }
- }
- }
- return Ok(new
- {
- lang=lang,
- privateShows = shows?.FindAll(x => x.Scope.Equals("private")).Select(x => new { x.Type, x.Status, x.Scope, x.Code }),
- location = _option.Location,
- teacherInfo.auth_token,
- teacherInfo.blob_uri,
- teacherInfo.blob_sas,
- teacherInfo.schools,
- teacherInfo.defaultschool,
- teacherInfo.defaultschoolPeriod,
- teacherInfo.courses,
- teacherInfo.total,
- teacherInfo.osblob_uri,
- teacherInfo.osblob_sas,
- teacherInfo.tsize,
- status = 200,
- teacherInfo.areas,
- lessonLimit,
- teacherInfo.teacher.lessonShow,
- privateSpace= new { size = space.usedSize, catalog = space.catalog, teach = space.teach, surplus = space.surplus, total = space.total },
- schoolSpace = new { size = 0, catalog = 0, teach = 0, surplus = 0, total = 0 }
- });
- }
- catch (CosmosException ex)
- {
- LoginService.LoginLog(HttpContext, _option, _logger, _dingDing, ip, region, id, $"{name}", 500);
- await _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/GetTeacherInfo()\n{ex.Message}\n{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
- return BadRequest();
- }
- catch (Exception ex)
- {
- LoginService.LoginLog(HttpContext, _option, _logger, _dingDing, ip, region, id, $"{name}", 500);
- _ = _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/GetTeacherInfo()\n{ex.Message}\n{ex.StackTrace}", GroupNames.醍摩豆服務運維群組);
- return BadRequest();
- }
- }
- //TODO 此API需處理對應前端返回的相關數據
- [ProducesDefaultResponseType]
- [Authorize(Roles = "IES")]
- [HttpPost("get-school-info")]
- public async Task<IActionResult> GetSchoolInfo(JsonElement request)
- {
- string OAuthShow_domain = HttpContext?.Request?.Host.Host;
- if (OAuthShow_domain.Equals("teammodelos.chinacloudsites.cn") ) {
- OAuthShow_domain = _option.HostName;
- }
- if (_option.Location.Equals("China"))
- {
- OAuthShow_domain = _option.HostName;
- }
- if (OAuthShow_domain.Equals("localhost")) {
- OAuthShow_domain = "test.teammodel.cn";
- }
- try
- {
- if (!request.TryGetProperty("id_token", out JsonElement id_token)) return BadRequest();
- if (!request.TryGetProperty("school_code", out JsonElement _school_code)) return BadRequest();
- string school_code = $"{_school_code}";
- var jwt = new JwtSecurityToken(id_token.GetString());
- var id = jwt.Payload.Sub;
- var client = _azureCosmos.GetCosmosClient();
- //權限token
- jwt.Payload.TryGetValue("name", out object name);
- jwt.Payload.TryGetValue("picture", out object picture);
- List<string> roles = new List<string>();
- List<string> permissions = new List<string>();
- int size = 0;
- Teacher teacher = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Teacher>(id, new PartitionKey("Base"));
- List<AreaDto> areas = new List<AreaDto>();
- HashSet<string> areaIds = new HashSet<string>();
- if (teacher.areas.IsNotEmpty())
- {
- teacher.areas.ForEach(x => {
- areaIds.Add(x.areaId);
- });
- }
- if (teacher.schools.IsNotEmpty())
- {
- teacher.schools.ForEach(x => {
- if (!string.IsNullOrEmpty(x.areaId))
- {
- areaIds.Add(x.areaId);
- }
- });
- }
- List<Area> areasDbs = new List<Area>();
- List<AreaSetting> areaSettings = new List<AreaSetting>();
- if (areaIds.Count > 0)
- {
- string queryText = $"select value(c) from c where c.id in ({string.Join(",", areaIds.Select(x => $"'{x}'"))})";
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Normal").GetItemQueryIterator<Area>(queryText: queryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base-Area") }))
- {
- areasDbs.Add(item);
- }
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Normal").GetItemQueryIterator<AreaSetting>(queryText: queryText, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("AreaSetting") }))
- {
- areaSettings.Add(item);
- }
- }
- if (teacher.areas.IsNotEmpty())
- {
- foreach (var areat in teacher.areas)
- {
- Area area = areasDbs.Find(x => x.id.Equals(areat.areaId));
- AreaSetting setting = null;
- if (area != null)
- {
- setting = areaSettings.Find(x => x.id.Equals(areat.areaId));
- }
- int access = 0;
- if (setting != null && !string.IsNullOrWhiteSpace(setting.accessConfig))
- {
- access = 1;
- }
- //if (setting != null)
- //{
- // setting.accessConfig = null;
- //}
- areas.Add(new AreaDto { areaId = area?.id, name = area?.name, standard = area?.standard, standardName = area?.standardName, setting = setting, access = access });
- }
- }
- if (school_code.Equals(teacher.defaultSchool) && teacher.schools.IsNotEmpty() && !teacher.schools.Select(x => x.schoolId).Contains(school_code))
- {
- school_code = teacher.schools[0].schoolId;
- teacher.defaultSchool = school_code;
- teacher = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacher, id, new PartitionKey("Base"));
- }
- var response = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync(id, new PartitionKey($"Teacher-{school_code}"));
- string defaultPeriodId = "";
- if (response.Status == 200)
- {
- using var json = await JsonDocument.ParseAsync(response.ContentStream);
- if (json.RootElement.TryGetProperty("size", out JsonElement _size) && _size.ValueKind == JsonValueKind.Number)
- {
- size = _size.GetInt32();
- }
- if (json.RootElement.TryGetProperty("periodId", out JsonElement _periodId))
- {
- defaultPeriodId =$"{_periodId}";
- }
- 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());
- }
- }
- }
- else //無此學校資料
- {
- }
- if (roles.Count == 0)
- {
- //助理,管家
- //roles.Add("assist");
- roles.Add("teacher");
- }
- //TODO JJ,调整为取得学校基础设置数据,取代下方學校學制、年級
- School school_base = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>($"{school_code}", new PartitionKey("Base"));
- foreach (var period in school_base.period)
- {
- try
- {
- await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<ItemCond>($"{period.id}", new PartitionKey($"ItemCond-{school_code}"));
- }
- catch (CosmosException)
- {
- ItemCond itemCond = new ItemCond
- {
- id = period.id,
- pk = "ItemCond",
- code = $"ItemCond-{school_code}",
- ttl = -1,
- };
- try
- {
- await client.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync<ItemCond>(itemCond, new PartitionKey($"ItemCond-{school_code}"));
- }
- catch (CosmosException ex) when (ex.Status == 409)
- {
- continue;
- }
- }
- }
- string currAreaId = "";
- dynamic currArea = new ExpandoObject();
- if (!string.IsNullOrEmpty(school_base.areaId))
- {
- try
- {
- Area area = areasDbs.Find(x => x.id.Equals(school_base.areaId));
- AreaSetting setting = null;
- if (area != null)
- {
- //setting =await client.GetContainer(Constant.TEAMModelOS, "Normal").ReadItemAsync<AreaSetting>(school_base.areaId, new PartitionKey("AreaSetting"));
- setting = areaSettings.Find(x => x.id.Equals(school_base.areaId));
- }
- int access = 0;
- AccessConfig accessConfig = null;
- if (setting != null && !string.IsNullOrWhiteSpace(setting.accessConfig))
- {
- access = 1;
- accessConfig = setting.accessConfig.ToObject<AccessConfig>();
- }
- //if (setting!=null&& !string.IsNullOrEmpty(setting.accessConfig)) {
- // setting.accessConfig = null;
- //}
- currArea = new
- {
- areaId = area?.id,
- name = area?.name,
- standard = area?.standard,
- standardName = area?.standardName,
- setting = setting,
- access = access,
- //submitType=accessConfig?.submitType,
- homeworkType = accessConfig != null && accessConfig.homeworkType.IsNotEmpty() ? accessConfig.homeworkType : new List<string> { "pdf" },
- };
- currAreaId = area?.id;
- }
- catch (CosmosException)
- {
- //数据库捞不到数据
- }
- }
- if (areas.Count > 0)
- {
- roles.Add("area");
- }
- //TODO JJ,更新Token时,在取得学校资讯时,没有传入schoolId
- var auth_token = JwtAuthExtension.CreateAuthToken(_option.HostName, id, name?.ToString(), picture?.ToString(), _option.JwtSecretKey, Website: "IES", scope: Constant.ScopeTeacher, schoolID: school_code.ToString(), areaId: currAreaId, standard: school_base.standard, roles: roles.ToArray(), permissions: permissions.ToArray(), expire: 1);
- //取得班级
- (List < Class > school_classes,_) = await SchoolService.DoGraduateClasses(_httpTrigger, _azureCosmos, null, school_base, _option,_dingDing);
- //取得教室
- List<Room> school_rooms = new List<Room>();
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<Room>(queryText: $"select value(c) from c ",
- requestOptions: new QueryRequestOptions() { PartitionKey = new Azure.Cosmos.PartitionKey($"Room-{school_code}") }))
- {
- school_rooms.Add(item);
- }
- //該老師排定的學校課程
- List<object> school_courses = new List<object>();
- var query = $"SELECT distinct value(c) FROM c JOIN A1 IN c.schedule where A1.teacherId='{id}'";
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{school_code}") }))
- {
- 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())
- {
- school_courses.Add(obj.ToObject<object>());
- }
- }
- }
- List<SchoolProductSumData> services = new List<SchoolProductSumData>();
- //获取HiTeachCC的授权
- int cc_avaliable = 0;
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<int>("select value count(1) from c where c.prodCode='LZLL6ZEI'",
- requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey($"Product-{school_code}") }))
- {
- cc_avaliable = item;
- }
- services.Add(new SchoolProductSumData { prodCode = "LZLL6ZEI", avaliable = cc_avaliable });
- Azure.Response productSumResponse = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync(school_code, new PartitionKey("ProductSum"));
- if (productSumResponse.Status == 200)
- {
- var doc = JsonDocument.Parse(productSumResponse.Content);
- //if (doc.RootElement.TryGetProperty("serial", out JsonElement serial))
- //{
- // serials = serial.ToObject<List<SchoolProductSumData>>();
- //}
- if (doc.RootElement.TryGetProperty("service", out JsonElement service))
- {
- services .AddRange(service.ToObject<List<SchoolProductSumData>>());
- }
- }
- //校本課綱 [式樣未定 先不取]
- //取得School Blob 容器位置及SAS
- string school_code_blob = school_code.ToLower();
- var container = _azureStorage.GetBlobContainerClient(school_code_blob);
- await container.CreateIfNotExistsAsync(PublicAccessType.None); //嘗試創建School容器,如存在則不做任何事,保障容器一定存在
- var (blob_uri, blob_sas) = (roles.Contains("admin") || permissions.Contains("schoolAc-upd")) ? _azureStorage.GetBlobContainerSAS(school_code_blob, BlobContainerSasPermissions.Write | BlobContainerSasPermissions.Read | BlobContainerSasPermissions.List | BlobContainerSasPermissions.Delete) : _azureStorage.GetBlobContainerSAS(school_code_blob, BlobContainerSasPermissions.Read | BlobContainerSasPermissions.List | BlobContainerSasPermissions.Write);
- ///https://teammodelstorage.blob.core.chinacloudapi.cn/teammodelos
- var (osblob_uri, osblob_sas) = roles.Contains("area") ? _azureStorage.GetBlobContainerSAS("teammodelos", BlobContainerSasPermissions.Write | BlobContainerSasPermissions.Read | BlobContainerSasPermissions.List | BlobContainerSasPermissions.Delete) : _azureStorage.GetBlobContainerSAS("teammodelos", BlobContainerSasPermissions.Read | BlobContainerSasPermissions.List);
- areas.ForEach(x => { { if (x.setting != null) { x.setting.accessConfig = x.setting.accessConfig; } } });
- int lessonLimit = teacher.lessonLimit;
- if (teacher.lessonLimit == 0)
- {
- //未设置的的采用系统设置的默认值30
- lessonLimit = Constant.private_lesson_limit;
- }
- var table = _azureStorage.GetCloudTableClient().GetTableReference("IESOAuth");
- List<string> Codes = new List<string>();
- if (!string.IsNullOrWhiteSpace(id))
- {
- Codes.Add($" Code {QueryComparisons.Equal} '{id}' ");
- }
- if (!string.IsNullOrWhiteSpace(school_code))
- {
- Codes.Add($" Code {QueryComparisons.Equal} '{school_code}' ");
- }
- if (!string.IsNullOrWhiteSpace(currAreaId))
- {
- Codes.Add($" Code {QueryComparisons.Equal} '{currAreaId}' ");
- }
-
- string tbqurey = $"PartitionKey {QueryComparisons.Equal} 'OAuthShow' and Domain {QueryComparisons.Equal} '{OAuthShow_domain}' and ( { string.Join(" or ", Codes)} ) ";
- var result = await table.ExecuteQuerySegmentedAsync(new TableQuery<OAuthShow>().Where(tbqurey), null);
- List<OAuthShow> shows = result.Results;
- List<OAuthShow> schoolShow = new List<OAuthShow>();
- List<OAuthShow> areaShow = new List<OAuthShow>();
- var schoolShows = shows?.Where(y => !y.Scope.Equals("private"));
-
- if (schoolShows.Any())
- {
-
- //剩下的area 和school 的。统一处理为school的,并去重。
- schoolShows.ToList().ForEach(y => { y.Scope = "school"; y.Code = school_code; });
- schoolShows.GroupBy(x => $"{x.Type}{x.Scope}").Select(s => new { key = s.Key, list = s.ToList() }).ToList().ForEach(z => {
- schoolShow.Add(z.list.First());
- });
- }
- //只有管理员才能进行艺术评价相关设置关联。
- List<IdCode> hasArt = new List<IdCode>();
- if (roles.Contains("admin"))
- {
- if (schoolShows.Where(x => x.Type.Equals("art")).Any())
- {
- school_base?.period.ForEach(x => {
- var has_music = x?.subjects.Find(x => !string.IsNullOrWhiteSpace(x.bindId) && x.bindId.Equals("subject_music"));
- if (has_music == null)
- {
- hasArt.Add(new IdCode { id = x.id, code = "subject_music" });
- }
- var has_painting = x.subjects.Find(x => !string.IsNullOrWhiteSpace(x.bindId) && x.bindId.Equals("subject_painting"));
- if (has_painting == null)
- {
- hasArt.Add(new IdCode { id = x.id, code = "subject_painting" });
- }
- });
- }
- }
- List<OAuthShow> areaShows = new List<OAuthShow>();
- //处理区级是否有艺术评价模组授权
- if (areas.IsNotEmpty())
- {
- List<string> area_Codes = new List<string>();
- areas.ForEach(x => {
- area_Codes.Add($" Code {QueryComparisons.Equal} '{x.areaId}' ");
- });
- string area_tbqurey = $"PartitionKey {QueryComparisons.Equal} 'OAuthShow' and Domain {QueryComparisons.Equal} '{OAuthShow_domain}' and Type {QueryComparisons.Equal} 'art' and ( {string.Join(" or ", area_Codes)} ) ";
- var area_result = await table.ExecuteQuerySegmentedAsync(new TableQuery<OAuthShow>().Where(area_tbqurey), null);
- areaShows = area_result.Results;
- }
- //返回剩余空间
- (long usedSize, long teach, long total, long surplus, Dictionary<string, double?> catalog) space =
- await BlobService.GetSurplusSpace(school_base.id, "school", _option.Location, _azureCosmos, _azureRedis, _azureStorage, _dingDing, _httpTrigger);
- //学校版本处理
- _ = BISchoolService.UpSchoolEdition(client, _dingDing, services.Select(s => s.prodCode).ToList(), $"{school_code}");
- return Ok(new
- {
- privateShows = shows?.FindAll(x => x.Scope.Equals("private")).Select(x => new { x.Type, x.Status, x.Scope, x.Code }),
- schoolShows = schoolShow.Select(x => new { x.Type, x.Status, x.Scope, x.Code }),
- areaShows = areaShows.Select(x => new { x.Type, x.Status, x.Scope, x.Code }),
- auth_token,
- blob_uri,
- blob_sas,
- school_base,
- school_courses,
- school_classes,
- school_rooms,
- size,
- osblob_uri,
- osblob_sas,
- status = 200,
- areas,
- currArea,
- lessonLimit,
- teacher.lessonShow,
- defaultPeriodId,
- productSum = new
- {
- //serial = serials,
- service = services
- }
- ,
- privateSpace = new { size = 0, catalog = 0, teach = 0, surplus = 0, total = 0 } ,
- schoolSpace = new { size = space.usedSize, catalog = space.catalog, teach = space.teach, surplus = space.surplus, total = space.total }
- });
- }
- catch (CosmosException ex)
- {
- HttpContext.Request.Headers.TryGetValue("referer", out var referer);
- HttpContext.Request.Headers.TryGetValue("sec-ch-ua", out var chua);
- HttpContext.Request.Headers.TryGetValue("sec-ch-ua-platform", out var platform);
- HttpContext.Request.Headers.TryGetValue("user-agent", out var useragent);
- await _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/init/get-school-info()\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}\nreferer:{referer}\nsec-ch-ua:{chua}\nsec-ch-ua-platform:{platform}\nuser-agent:{useragent}", GroupNames.醍摩豆服務運維群組);
- return BadRequest(new { status = ex.Status });
- }
- catch (Exception ex)
- {
- HttpContext.Request.Headers.TryGetValue("referer", out var referer);
- HttpContext.Request.Headers.TryGetValue("sec-ch-ua", out var chua);
- HttpContext.Request.Headers.TryGetValue("sec-ch-ua-platform", out var platform);
- HttpContext.Request.Headers.TryGetValue("user-agent", out var useragent);
- await _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/init/get-school-info()\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}\nreferer:{referer}\nsec-ch-ua:{chua}\nsec-ch-ua-platform:{platform}\nuser-agent:{useragent}", GroupNames.醍摩豆服務運維群組);
- return BadRequest(new { status = 500 });
- }
- }
- /// <summary>
- /// 取得學校所有列表
- /// </summary>
- /// <param name="request"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- //[AuthToken(Roles = "teacher")]
- [HttpPost("get-school-list")]
- public async Task<IActionResult> GetSchoolList(JsonElement request)
- {
- try
- {
- //輸入值
- string sqlSchoolId = (request.TryGetProperty("schoolId", out JsonElement reqSchoolId)) ? reqSchoolId.GetString() : string.Empty;
- bool sqlHasManager = (request.TryGetProperty("manager", out JsonElement reqHasManager)) ? reqHasManager.GetBoolean() : false;
- bool sqlHasMBaseModule = (request.TryGetProperty("base", out JsonElement reqHasBaseModule)) ? reqHasBaseModule.GetBoolean() : false;
- var client = _azureCosmos.GetCosmosClient();
- //有管理者的學校
- Dictionary<string, List<Dictionary<string, string>>> managerSchDic = new Dictionary<string, List<Dictionary<string, string>>>();
- string managerWhereOption = (!string.IsNullOrWhiteSpace(sqlSchoolId)) ? $" AND c.code = 'Teacher-{sqlSchoolId}'" : string.Empty;
- string managerSql = $"SELECT DISTINCT REPLACE(c.code, 'Teacher-', '') AS schoolId, c.id, c.name FROM c WHERE ARRAY_CONTAINS(c.roles, 'admin', true) AND c.pk = 'Teacher' AND c.status = 'join'{managerWhereOption}";
- await foreach (var item in client.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 schoolId = obj.GetProperty("schoolId").GetString(); //學校ID
- Dictionary<string, string> managerDic = new Dictionary<string, string>();
- managerDic.Add("id", id);
- managerDic.Add("name", name);
- if (managerSchDic.ContainsKey(schoolId))
- {
- managerSchDic[schoolId].Add(managerDic);
- }
- else
- {
- List<Dictionary<string, string>> managerList = new List<Dictionary<string, string>>();
- managerList.Add(managerDic);
- managerSchDic.Add(schoolId, managerList);
- }
- }
- }
- //有管理模組的學校
- List<string> baseModuleSchList = new List<string>();
- string baseModuleWhereOption = (!string.IsNullOrWhiteSpace(sqlSchoolId)) ? $" AND c.id = '{sqlSchoolId}'" : string.Empty;
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: $"SELECT c.id FROM c JOIN serviceProduct IN c.service.product WHERE serviceProduct.prodCode = 'IPDYZYLC'{baseModuleWhereOption}", 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 schoolId = obj.GetProperty("id").GetString(); //學校ID
- baseModuleSchList.Add(schoolId);
- }
- }
- //學校資料
- List<object> schools = new List<object>();
- string schoolWhereOption = (!string.IsNullOrWhiteSpace(sqlSchoolId)) ? $" WHERE c.id = '{sqlSchoolId}'" : string.Empty;
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: $"SELECT c.id, c.name, c.region, c.province, c.city, c.picture FROM c {schoolWhereOption}", requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("Base") }))
- {
- var jsons = await JsonDocument.ParseAsync(item.ContentStream);
- if (jsons.RootElement.TryGetProperty("_count", out JsonElement count) && count.GetUInt16() > 0)
- {
- foreach (var obj in jsons.RootElement.GetProperty("Documents").EnumerateArray())
- {
- dynamic schoolExtobj = new ExpandoObject();
- schoolExtobj.id = obj.GetProperty("id").GetString(); //學校ID
- schoolExtobj.name = obj.GetProperty("name");
- schoolExtobj.region = obj.GetProperty("region");
- schoolExtobj.province = obj.GetProperty("province");
- schoolExtobj.city = obj.GetProperty("city");
- schoolExtobj.picture = obj.GetProperty("picture");
- if (managerSchDic.ContainsKey(schoolExtobj.id))
- {
- schoolExtobj.hasManager = true;
- schoolExtobj.managers = managerSchDic[schoolExtobj.id];
- }
- else
- {
- schoolExtobj.hasManager = false;
- schoolExtobj.managers = new List<object>();
- }
- schoolExtobj.hasBaseModule = (baseModuleSchList.Contains(schoolExtobj.id)) ? true : false;
- //學校輸出結果加入篩選
- if ((sqlHasManager && sqlHasMBaseModule) && (schoolExtobj.hasManager && schoolExtobj.hasBaseModule))
- {
- schools.Add(schoolExtobj);
- }
- else if (sqlHasManager && schoolExtobj.hasManager)
- {
- schools.Add(schoolExtobj);
- }
- else if (sqlHasMBaseModule && schoolExtobj.hasBaseModule)
- {
- schools.Add(schoolExtobj);
- }
- else if (!sqlHasManager && !sqlHasMBaseModule)
- {
- schools.Add(schoolExtobj);
- }
- }
- }
- }
- return Ok(new { schools });
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/init/get-school-info()\n{ex.Message}\n{ex.StackTrace}{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
- return BadRequest();
- }
- }
- /// <summary>
- /// 申請或同意邀請加入學校
- /// </summary>
- ///
- /// <param name="request"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [AuthToken(Roles = "teacher")]
- [HttpPost("join-school")]
- [Authorize(Roles = "IES")]
- public async Task<IActionResult> JoinSchool(JsonElement request)
- {
- try
- {
- if (!request.TryGetProperty("grant_type", out JsonElement grant_type)) return BadRequest(); //"invite":學校邀請 "request":老師申請 "join":"成為學校老師",leave 离开,cancel 取消。
- if (!request.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
- if (!request.TryGetProperty("school_name", out JsonElement school_name)) return BadRequest();
- ///当邀请某个老师加入学校则需要知道是谁邀请的
- //if (!request.TryGetProperty("school_admin", out JsonElement school_admin)) return BadRequest();
- string authtoken = HttpContext.GetXAuth("AuthToken");
- if (string.IsNullOrEmpty(authtoken)) return BadRequest();
- var jwt = new JwtSecurityToken(authtoken);
- var id = jwt.Payload.Sub;
- var schoolcode = jwt.Payload.Azp;
- var Claims = jwt.Payload.Claims;
- jwt.Payload.TryGetValue("name", out object name);
- jwt.Payload.TryGetValue("picture", out object picture);
- var client = _azureCosmos.GetCosmosClient();
- //在老師表找出老師,處理該學校狀態 (老師基本資料應該要存在)
- Teacher teacher = await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReadItemAsync<Teacher>(id, new PartitionKey("Base"));
- if (teacher.schools == null)
- teacher.schools = new List<Teacher.TeacherSchool>();
- var school = teacher.schools?.FirstOrDefault(x => x.schoolId.Equals(school_code.GetString(), StringComparison.OrdinalIgnoreCase));
- School schoolBase = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>($"{school_code}", new PartitionKey("Base"));
- if (school != null)
- school.status = grant_type.GetString();
- else
- {
- long now = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
- teacher.schools.Add(new Teacher.TeacherSchool() { areaId = schoolBase.areaId, picture = schoolBase.picture, schoolId = school_code.GetString(), name = school_name.GetString(), status = grant_type.GetString(), time = now });
- }
- if (grant_type.GetString().Equals("leave") || grant_type.GetString().Equals("cancel"))
- {
- if (teacher.schools.IsNotEmpty())
- {
- //获取之前已经加入的学校或者申请的学校
- var inSchools = teacher.schools.Where(x => x.schoolId == school_code.GetString()).ToList();
- if (inSchools.IsNotEmpty())
- {
- inSchools.ForEach(x => teacher.schools.Remove(x));
- }
- }
- if (teacher.schools.Count > 0 && teacher.size <= 1)
- {
- teacher.size = 2;
- }
- if (!string.IsNullOrEmpty(teacher.defaultSchool) && teacher.defaultSchool.Equals($"{school_code}"))
- {
- if (teacher.schools.IsNotEmpty())
- {
- teacher.defaultSchool = teacher.schools[0].schoolId;
- }
- else
- {
- teacher.defaultSchool = null;
- }
- }
- await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacher, id, new PartitionKey("Base"));
- var sresponse = await client.GetContainer(Constant.TEAMModelOS, "School").DeleteItemStreamAsync(id, new PartitionKey($"Teacher-{school_code}"));
- Azure.Response response = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemStreamAsync($"{school_code}", new PartitionKey("TeacherImport"));
- TeacherImport teacherImport = null;
- if (response.Status == 200)
- {
- teacherImport = JsonDocument.Parse(response.Content).RootElement.Deserialize<TeacherImport>();
- var tchs = teacherImport?.teachers?.RemoveAll(x => !string.IsNullOrWhiteSpace(x.id) && x.id.Equals(id));
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(teacherImport, $"{school_code}", new PartitionKey("TeacherImport"));
- }
- return Ok(new { stauts = 1 });
- }
- else
- {
- var dft = new List<string>() { "content-read", "exercise-read", "knowledge-read", "syllabus-read" };
- if (teacher.schools.Count > 0 && teacher.size <= 1)
- {
- teacher.size = 2;
- }
- await client.GetContainer(Constant.TEAMModelOS, "Teacher").ReplaceItemAsync<Teacher>(teacher, id, new PartitionKey("Base"));
- //在學校表處理該學校教師帳號的狀態
- var sresponse = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemStreamAsync(id, new PartitionKey($"Teacher-{school_code}"));
- if (sresponse.Status == 200)
- {
- using var json = await JsonDocument.ParseAsync(sresponse.ContentStream);
- SchoolTeacher steacher = json.ToObject<SchoolTeacher>();
- steacher.status = grant_type.GetString();
- if (grant_type.ToString().Equals("join"))
- {
- if (steacher.permissions.IsNotEmpty())
- {
- foreach (var d in dft)
- {
- if (!steacher.permissions.Contains(d))
- {
- steacher.permissions.Add(d);
- }
- }
- }
- else
- {
- steacher.permissions = dft;
- }
- }
- var response = await client.GetContainer(Constant.TEAMModelOS, "School").ReplaceItemAsync(steacher, id, new PartitionKey($"Teacher-{school_code}"));
- }
- else
- {
- SchoolTeacher st = new SchoolTeacher()
- {
- pk = "Teacher",
- code = $"Teacher-{school_code}",
- createTime = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds(),
- id = id,
- name = name.ToString(),
- picture = picture?.ToString(),
- permissions = grant_type.ToString().Equals("join") ? dft : null,
- roles = new List<string>() { "teacher" },
- size = 0,
- status = grant_type.GetString()
- };
- var response = await client.GetContainer(Constant.TEAMModelOS, "School").CreateItemAsync(st, new PartitionKey($"Teacher-{school_code}"));
- }
- Azure.Response responseImport = await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReadItemStreamAsync($"{school_code}", new PartitionKey("TeacherImport"));
- TeacherImport teacherImport = null;
- if ($"{grant_type}".Equals("request"))
- {
- if (responseImport.Status == 200)
- {
- teacherImport = JsonDocument.Parse(responseImport.Content).RootElement.Deserialize<TeacherImport>();
- var tchs = teacherImport?.teachers?.FindAll(x => !string.IsNullOrWhiteSpace(x.iname) && x.iname.Equals($"{name}") && string.IsNullOrWhiteSpace(x.id));
- if (tchs.IsNotEmpty())
- {
- var tch = tchs[0];
- string ujson = null;
- var content = new StringContent(new List<string> { $"{id}" }.ToJsonString(), Encoding.UTF8, "application/json");
- ujson = await _coreAPIHttpService.GetUserInfos(content);
- List<CoreUser> coreUsers = new List<CoreUser>();
- if (!string.IsNullOrWhiteSpace(ujson))
- {
- coreUsers = ujson.ToObject<List<CoreUser>>();
- }
- if (coreUsers.IsNotEmpty())
- {
- tch.phone = coreUsers[0].mobile;
- tch.email = coreUsers[0].mail;
- }
- tch.id = $"{id}";
- tch.picture = $"{picture}";
- tch.status = $"{grant_type}";
- tch.time = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
- tch.tmdid = id;
- tch.name = $"{name }";
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(teacherImport, $"{school_code}", new PartitionKey("TeacherImport"));
- }
- }
- }
- if (grant_type.ToString().Equals("join"))
- {
- if (responseImport.Status == 200)
- {
- teacherImport = JsonDocument.Parse(responseImport.Content).RootElement.Deserialize<TeacherImport>();
- teacherImport?.teachers.ForEach(x => {
- if (!string.IsNullOrWhiteSpace(x.id) && !string.IsNullOrWhiteSpace(teacher.id) && x.id.Equals(teacher.id))
- {
- x.name = teacher.name;
- x.status = "join";
- x.time = DateTimeOffset.UtcNow.ToUnixTimeMilliseconds();
- x.picture = teacher.picture;
- }
- });
- await _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.School).ReplaceItemAsync(teacherImport, $"{school_code}", new PartitionKey("TeacherImport"));
- await TmdUserService.JoinSchool(client, teacher.id, teacher.picture, teacher.name, school.schoolId, school.name);
- }
- }
- List<SchoolTeacher> teachers = new List<SchoolTeacher>();
- var queryslt = $"SELECT value(c) FROM c join A1 in c.roles where A1 in ('admin')";
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<SchoolTeacher>(queryText: queryslt, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Teacher-{school_code}") }))
- {
- teachers.Add(item);
- }
- string code = grant_type.GetString();
- if (grant_type.GetString().Equals("join"))
- {
- code = "invite-join";
- }
- if (teachers.IsNotEmpty()) {
- string sql = $"select c.id, c.name ,c.lang as code from c where c.id in ({string.Join(",", teachers.Select(x => $"'{x.id}'"))})";
- List<IdNameCode> idNameCodes = new List<IdNameCode>();
- await foreach (var item in _azureCosmos.GetCosmosClient().GetContainer(Constant.TEAMModelOS, Constant.Teacher)
- .GetItemQueryIterator<IdNameCode>(queryText: sql, requestOptions: new QueryRequestOptions { PartitionKey = new PartitionKey("Base") }))
- {
- idNameCodes.Add(item);
- }
- _coreAPIHttpService.PushNotify(idNameCodes, $"{code}_school", Constant.NotifyType_IES5_Management,
- new Dictionary<string, object> {{ "tmdname", name }, { "schoolName", schoolBase.name }, { "schoolId",$"{school_code}" },{ "tmdid",id} }, _option.Location,_configuration,_dingDing, _environment.ContentRootPath) ;
- }
- return Ok(new { stauts = 1 });
- }
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"TEAMModel,{_option.Location},Init/JoinSchool()\n{ex.Message}\n{ex.StackTrace}\n{request.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
- return BadRequest();
- }
- }
- /// <summary>
- /// 通过学段获取学校班级、教室信息; 教师id获取课程信息
- /// </summary>
- /// <param name="jsonElement"></param>
- /// <returns></returns>
- [ProducesDefaultResponseType]
- [HttpPost("get-info-prdid")]
- [Authorize(Roles="IES")]
- public async Task<IActionResult> GetInfoByPeriodId(JsonElement jsonElement)
- {
- string OAuthShow_domain = HttpContext?.Request?.Host.Host;
- if (OAuthShow_domain.Equals("teammodelos.chinacloudsites.cn"))
- {
- OAuthShow_domain = _option.HostName;
- }
- if (_option.Location.Equals("China"))
- {
- OAuthShow_domain = _option.HostName;
- }
- if (OAuthShow_domain.Equals("localhost"))
- {
- OAuthShow_domain = "test.teammodel.cn";
- }
- try
- {
- if (!jsonElement.TryGetProperty("id_token", out JsonElement id_token)) return BadRequest();
- if (!jsonElement.TryGetProperty("school_code", out JsonElement school_code)) return BadRequest();
- jsonElement.TryGetProperty("periodId", out JsonElement _periodId);
- var jwt = new JwtSecurityToken(id_token.GetString());
- var tchId = jwt.Payload.Sub;
- var client = _azureCosmos.GetCosmosClient();
- string periodId = null;
- if (!string.IsNullOrEmpty($"{_periodId}"))
- periodId = $"{_periodId}";
- else
- {
- School school_base = await client.GetContainer(Constant.TEAMModelOS, "School").ReadItemAsync<School>($"{school_code}", new PartitionKey("Base"));
- periodId = school_base.period[0].id;
- }
- //获取班级信息
- List<object> school_Classes = new();
- string classesSql = $"SELECT c.id,c.x,c.y,c.name,c.year,c.teacher,c.periodId,c.gradeId,c.room,c.sn,c.no,c.style,c.status,c.openType,c.school, c.graduate, ARRAY_LENGTH(c.students) AS studCount FROM c where c.graduate = 0 or IS_DEFINED(c.graduate) = false and c.periodId='{periodId}'";
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: classesSql, 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())
- {
- school_Classes.Add(classeinfo.ToObject<object>());
- }
- }
- //获取教师的课程
- List<object> school_Courses = new();
- var query = $"SELECT value(c) FROM c JOIN A1 IN c.schedule where A1.teacherId='{tchId}' and c.period.id='{periodId}'";
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryStreamIterator(queryText: query, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Course-{school_code}") }))
- {
- 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())
- {
- school_Courses.Add(obj.ToObject<object>());
- }
- }
- }
- //获取教室
- List<Room> school_Rooms = new();
- //string roomSql = $"select value(c) from c where c.periodId = '{periodId}'"; //注释原因:教室暂时不绑定学段信息
- string roomSql = $"select value(c) from c";
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<Room>(queryText: roomSql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"Room-{school_code}") }))
- {
- school_Rooms.Add(item);
- }
- //获取学校行政班
- List<GroupListDto> school_GroupList = new();
- string glSql = $"select c.id,c.code,c.name,c.no,c.periodId,c.scope,c.school,c.creatorId,c.type,c.year,c.tcount,c.scount,c.leader ,c.froms ,c.joinLock from c";
- string schoolglSql = $"{glSql} where c.periodId ='{periodId}'";
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "School").GetItemQueryIterator<GroupListDto>(queryText: schoolglSql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey($"GroupList-{school_code}") }))
- {
- school_GroupList.Add(item);
- }
- //获取个人行政班
- List<GroupListDto> personal_GroupList = new();
- string pglSql = $"{glSql} where c.creatorId='{tchId}'";
- await foreach (var item in client.GetContainer(Constant.TEAMModelOS, "Teacher").GetItemQueryIterator<GroupListDto>(queryText: pglSql, requestOptions: new QueryRequestOptions() { PartitionKey = new PartitionKey("GroupList") }))
- {
- personal_GroupList.Add(item);
- }
- return Ok(new { status = 200, school_Classes, school_Courses, school_Rooms, school_GroupList, personal_GroupList });
- }
- catch (Exception ex)
- {
- await _dingDing.SendBotMsg($"IES5,{_option.Location},Teacher/init/get-info-prdid()\n{ex.Message}\n{ex.StackTrace}\n{jsonElement.ToJsonString()}", GroupNames.醍摩豆服務運維群組);
- return BadRequest(new { status = 500 });
- }
- }
- //課綱的model先記在下面,待式樣確定後再轉換
- private List<SyllabusNode> CreateSyllabusTree(List<Syllabus> syllabuses)
- {
- List<SyllabusNode> nodes = new List<SyllabusNode>();
- foreach (var syllabus in syllabuses)
- {
- if (syllabus.pid.Equals(""))
- nodes.Add(new SyllabusNode { id = syllabus.id, name = syllabus.name });
- else
- {
- CreateNode(nodes, syllabus);
- }
- }
- return nodes;
- }
- private void CreateNode(List<SyllabusNode> nodes, Syllabus parent)
- {
- foreach (var node in nodes)
- {
- if (node.id == parent.pid)
- {
- node.children.Add(new SyllabusNode { id = parent.id, name = parent.name });
- }
- else
- {
- CreateNode(node.children, parent);
- }
- }
- }
- public class SyllabusRole
- {
- public string id { get; set; }
- public string name { get; set; }
- public object period { get; set; }
- public object semester { get; set; }
- public object grade { get; set; }
- public object subject { get; set; }
- public int resourceCount { get; set; }
- public int itemCount { get; set; }
- public object structure { get; set; }
- }
- public class Syllabus
- {
- public string id { get; set; }
- public string name { get; set; }
- public string pid { get; set; }
- public int order { get; set; }
- }
- public class SyllabusNode
- {
- public string id { get; set; }
- public string name { get; set; }
- public List<SyllabusNode> children { get; set; }
- public SyllabusNode()
- {
- children = new List<SyllabusNode>();
- }
- }
- }
- }
|