TEAMModelOS/TEAMModelOS.SDK/Models/Cosmos/School/ScoreCalc.cs

using DocumentFormat.OpenXml.Spreadsheet;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace TEAMModelOS.SDK.Models.Cosmos.School
{
    /// <summary>
    /// 成績計算總覽
    /// </summary>
    public class ScoreCalcBase : CosmosEntity
    {
        public ScoreCalcBase()
        {
            pk = "ScoreCalc";
            members = new List<ScoreCalcMember>();
            //scores = new List<double>();
            //scoresOrg = new List<double>();
            editScores = new List<double>();
        }
        /// <summary>
        /// 名稱
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 課程ID
        /// </summary>
        public string courseId { get; set; }
        /// <summary>
        /// 班級ID(行政班)
        /// </summary>
        public string classId { get; set; }
        /// <summary>
        /// 班級ID(選課班、個人課程ID)
        /// </summary>
        public string grouplistId { get; set; }
        /// <summary>
        /// 成員名單
        /// </summary>
        public List<ScoreCalcMember> members { get; set; }
        /// <summary>
        /// 各成員成績總覽
        /// </summary>
        //public List<double> scores { get; set; }
        /// <summary>
        /// 各成員成績總覽最初系統計算結果
        /// </summary>
        //public List<double> scoresOrg { get; set; }
        /// <summary>
        /// 各學生最後成績的加減分
        /// </summary>
        public List<double> editScores { get; set; }
        /// <summary>
        /// 總覽分項權重類型 count:加權 | percentage:百分比
        /// </summary>
        public string rateType { get; set; }
    }
    /// <summary>
    /// 成績計算總覽分項-活動基底Class
    /// </summary>
    public class ScoreCalcActivityBase : CosmosEntity
    {
        public ScoreCalcActivityBase()
        {
            pk = "ScoreCalcAct";
            itemRates = new List<double>();
            //itemScores = new List<double>();
            //itemScoresOrg = new List<double>();
            //stuScores = new List<double>();            
        }
        /// <summary>
        /// 成績計算ID
        /// </summary>
        public string scorecalcId { get; set; }
        /// <summary>
        /// 活動名稱
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 類型 exam:評量 | homework:作業 | lessonrecord:課堂紀錄
        /// </summary>
        public string type { get; set; }
        /// <summary>
        /// 總加權數
        /// </summary>
        public double rate { get; set; }
        /// <summary>
        /// 個學生最後成績的加減分
        /// </summary>
        public List<double> editScores { get; set; }
        /// <summary>
        /// 各活動權重
        /// </summary>
        public List<double> itemRates { get; set; }
        /// <summary>
        /// 各活動權重類型 count:加權 | percentage:百分比
        /// </summary>
        //public string itemRateType { get; set; }
        /// <summary>
        /// 各活動分數最終結果 - 一門課全部學生的平均 - 編輯後
        /// </summary>
        //public List<double> itemScores { get; set; }
        /// <summary>
        /// 各活動分數最初系統計算結果 - 一門課全部學生的平均 - 原始
        /// </summary>
        //public List<double> itemScoresOrg { get; set; }
        /// <summary>
        /// 最終成績 - 一個項目總平均 - 編輯後
        /// </summary>
        //public double score { get; set; }
        /// <summary>
        /// 最終成績系統計算結果 - 一個項目總平均 - 原始
        /// </summary>
        //public double scoreOrg { get; set; }

        /// <summary>
        /// 各學生所有活動結算成績 - 此項目所有學生的計算後分數
        /// </summary>
        //public List<double> stuScores { get; set; }

    }
    /// <summary>
    /// 成績計算總覽分項-評量、作業
    /// </summary>
    public class ScoreCalcActivity : ScoreCalcActivityBase
    {
        public ScoreCalcActivity()
        {
            items = new List<ScoreCalcActivityItems>();
            stuActScores = new List<List<double>>();
            stuActScoresOrg = new List<List<double>>();
        }
        /// <summary>
        /// 被選取的活動列表
        /// </summary>
        public List<ScoreCalcActivityItems> items { get; set; }
        /// <summary>
        /// 各活動所屬學生成績
        /// </summary>
        public List<List<double>> stuActScores { get; set; }
        /// <summary>
        /// 各活動所屬學生成績最初系統計算結果
        /// </summary>
        public List<List<double>> stuActScoresOrg { get; set; }
    }
    /// <summary>
    /// 成績計算總覽分項-課堂紀錄
    /// </summary>
    public class ScoreCalcLsRecord : ScoreCalcActivityBase
    {
        public ScoreCalcLsRecord()
        {
            items = new List<ScoreCalcActivityItems>();

            stuActAttendOrgVals = new List<List<double>>();
            stuActAttendScores = new List<List<double>>();
            //stuAttendScores = new List<double>();
            stuActPointOrgVals = new List<List<double>>();
            stuActPointScores = new List<List<double>>();
            //stuPointScores = new List<double>();
            stuActItactOrgVals = new List<List<double>>();
            stuActItactScores = new List<List<double>>();
            //stuItactScores = new List<double>();
        }
        /// <summary>
        /// 出席加權數
        /// </summary>
        public double attendRate { get; set; }
        /// <summary>
        /// 記分板加權數
        /// </summary>
        public double pointRate { get; set; }
        /// <summary>
        /// 互動加權數
        /// </summary>
        public double itactRate { get; set; }
        /// <summary>
        /// 總加權數
        /// </summary>
        /// <summary>
        /// 被選取的課堂紀錄列表
        /// </summary>
        public List<ScoreCalcActivityItems> items { get; set; }

        #region ==========出席==========
        /// <summary>
        /// 課堂紀錄出席 採用的公式ID (依照items順序 第一個課堂紀錄公式 第二個...)
        /// </summary>
        public string stuAttendFunctionId { get; set; }
        /// <summary>
        /// 各學生各課堂紀錄出席 系統原值
        /// </summary>
        public List<List<double>> stuActAttendOrgVals { get; set; }
        /// <summary>
        /// 各學生各課堂紀錄出席 分數
        /// </summary>
        public List<List<double>> stuActAttendScores { get; set; }
        /// <summary>
        /// 各學生所有課堂紀錄出席 分數
        /// </summary>
        //public List<double> stuAttendScores { get; set; }
        #endregion

        #region ==========記分板==========
        /// <summary>
        /// 課堂紀錄記分板 採用的公式ID
        /// </summary>
        public string stuPointFunctionId { get; set; }
        /// <summary>
        /// 各學生各課堂紀錄記分板 系統原值
        /// </summary>
        public List<List<double>> stuActPointOrgVals { get; set; }
        /// <summary>
        /// 各學生各課堂紀錄記分板 分數
        /// </summary>
        public List<List<double>> stuActPointScores { get; set; }
        /// <summary>
        /// 各學生所有課堂紀錄記分板 分數
        /// </summary>
        //public List<double> stuPointScores { get; set; }
        #endregion

        #region ==========互動==========
        /// <summary>
        /// 課堂紀錄互動 採用的公式ID
        /// </summary>
        public string stuItactFunctionId { get; set; }
        /// <summary>
        /// 各學生各課堂紀錄互動 系統原值
        /// </summary>
        public List<List<double>> stuActItactOrgVals { get; set; }
        /// <summary>
        /// 各學生各課堂紀錄互動 分數
        /// </summary>
        public List<List<double>> stuActItactScores { get; set; }
        /// <summary>
        /// 各學生所有課堂紀錄互動 分數
        /// </summary>
        //public List<double> stuItactScores { get; set; }
        #endregion

    }

    public class ScoreCalcMember
    {
        /// <summary>
        /// ID(學生ID、TMID)
        /// </summary>
        public string id { get; set; }
        public string name { get; set; }
        /// <summary>
        /// 座號
        /// </summary>
        public string no { get; set; }
    }

    /// <summary>
    /// 測驗、作業
    /// </summary>
    public class ScoreCalcActivityItems
    {
        /// <summary>
        /// 活動ID (測驗:examId 作業:homeworkId)
        /// </summary>
        public string id { get; set; }
        /// <summary>
        /// 活動分區鍵
        /// </summary>
        public string code { get; set; }
        /// <summary>
        /// 發布對象 學校(school)/個人(private)
        /// </summary>
        //public string scope { get; set; }
        /// <summary>
        /// (評量專有)擁有者 學校(school)/個人(teacher)
        /// </summary>
        //public string owner { get; set; }

        /// <summary>
        /// 活動名稱
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 活動進度 pending 待发布 | going 已发布 | finish 已结束
        /// </summary>
        //public string progress { get; set; }
        /// <summary>
        /// 活動評分狀態(評量專用) 0未评分，1已评分
        /// </summary>
        //public int sStatus { get; set; } = 0;
        /// <summary>
        /// 評測類型(評量專用) 0:線上評量 | 1:課中評量 | 2.卷卡合一
        /// </summary>
        //public string source { get; set; }
        /// <summary>
        /// 創建時間 (milliseconds 13位數)
        /// </summary>
        public long createTime { get; set; }
        /// <summary>
        /// 是否使用(是否被勾選) true:使用
        /// </summary>
        public bool use { get; set; }
    }
    /// <summary>
    /// 老師成績計算公式 code:"ScoreCalcFunc-{TMID}"
    /// </summary>
    public class ScoreCalcFunc : CosmosEntity
    {
        public ScoreCalcFunc()
        {
            pk = "ScoreCalcActFormula";
            keyvals = new List<ScoreCalcFuncTemplateKeyval>();
        }

        public string name { get; set; }
        public string scorecalcActId { get; set; }
        /// <summary>
        /// 類型 exam:評量 | homework:作業 | lessonrecord:課堂紀錄
        /// </summary>
        public string type { get; set; }
        /// <summary>
        /// 種類 attend:出席 | point:得分版 | interaction:互動
        /// </summary>
        public string method { get; set; }
        /// <summary>
        /// 模板 simpleAttend: 簡單出席計算法 | attendRate:出席率計算法 | custom:自訂
        /// </summary>
        public string template { get; set; }
        /// <summary>
        /// 公式鍵值定義
        /// </summary>
        public List<ScoreCalcFuncTemplateKeyval> keyvals { get; set; }
        /// <summary>
        /// 公式內容
        /// </summary>
        public string content { get; set; }
    }
    public class ScoreCalcFuncTemplateKeyval
    {
        public string key { get; set; }
        public string val { get; set; }
        //public string type { get; set; }
        //public string describe { get; set; }
    }
    /// <summary>
    /// 評量活動取系統資料
    /// </summary>
    public class ExamItem
    {
        /// <summary>
        /// 評量id
        /// </summary>
        public string examId { get; set; }
        /// <summary>
        /// 評量名稱
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 評量學生Id列表
        /// </summary>
        public List<string> studentIds { get; set; }
        /// <summary>
        /// 評量分數列表
        /// </summary>
        public List<double> sum { get; set; }
    }
    /// <summary>
    /// 取作業活動Id
    /// </summary>
    public class HomeworkItem
    {
        /// <summary>
        /// 作業id
        /// </summary>
        public string id { get; set; }
        /// <summary>
        /// 作業名稱
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 作業代碼 包含學生座號
        /// </summary>
        public string code { get; set; }
        /// <summary>
        /// 分數
        /// </summary>
        public double score { get; set; }
        /// <summary>
        /// pk
        /// </summary>
        public string pk { get; set; }
        /// <summary>
        /// school id
        /// </summary>
        public string school { get; set; }
    }

    #region （四）更新成績統計首頁表資料用
    /// <summary>
    /// 更新成績統計首頁表資料 參數
    /// </summary>
    public class UpdateSscoreCalcRq
    {
        public UpdateSscoreCalcRq()
        {
            ScoreCalcAct = new List<ScoreCalcAct>();
            editScores = new List<double>();
        }
        /// <summary>
        /// 成績統計id
        /// </summary>
        public string id { get; set; }
        /// <summary>
        /// teammodelId
        /// </summary>
        public string teammodelId { get; set; }

        /// <summary>
        /// 成績統計名稱
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 成績統計名稱
        /// </summary>
        public List<ScoreCalcAct> ScoreCalcAct { get; set; }

        /// <summary>
        /// 成績統計的加減分
        /// </summary>
        public List<double> editScores { get; set; }
    }
    /// <summary>
    /// 更新成績統計首頁表資料 參數ScoreCalcAct
    /// </summary>
    public class ScoreCalcAct
    {
        public ScoreCalcAct()
        {
            editScores = new List<double>();
        }
        /// <summary>
        /// 項目id
        /// </summary>
        public string id { get; set; }
        /// <summary>
        /// 項目類別
        /// </summary>
        public string type { get; set; }
        /// <summary>
        /// 出席比重
        /// </summary>
        public double attendRate { get; set; }
        /// <summary>
        /// 記分比重
        /// </summary>
        public double pointRate { get; set; }
        /// <summary>
        /// 互動比重
        /// </summary>
        public double itactRate { get; set; }
        /// <summary>
        /// 總比重
        /// </summary>
        public double rate { get; set; }
        /// <summary>
        /// 項目成績的加減分
        /// </summary>
        public List<double> editScores { get; set; }
    }

    #endregion

    // 取物件Id用
    public class ItemId
    {
        /// <summary>
        /// id
        /// </summary>
        public string id { get; set; }
    }

    #region （六）更新公式設定(一次可以處理多個公式)資料用
    /// <summary>
    /// 更新公式資料 參數
    /// </summary>
    public class UpdateFormulaRq
    {
        public UpdateFormulaRq()
        {
            scoreCalcFunc = new List<ScoreCalcFuncRq>();
        }
        /// <summary>
        /// 項目id
        /// </summary>
        public string scoreCalcActId { get; set; }
        /// <summary>
        /// teammodelId
        /// </summary>
        public string teammodelId { get; set; }
        /// <summary>
        /// 種類 attend:出席 | point:得分版 | interaction:互動
        /// </summary>
        public string method { get; set; }
        /// <summary>
        /// 公式資料列表
        /// </summary>        
        public List<ScoreCalcFuncRq> scoreCalcFunc { get; set; }
    }

    /// <summary>
    /// 更新公式資料用的 細項參數
    /// </summary>
    public class ScoreCalcFuncRq: ScoreCalcFunc
    {
        /// <summary>
        /// 是否為使用中的公式
        /// </summary>
        public bool use { get; set; }
    }

    #endregion

    #region （九）更新項目及子項目資料
    /// <summary>
    /// Request 參數
    /// </summary>
    public class UpdateScoreCalcActRqBase
    {
        /// <summary>
        /// 活動id
        /// </summary>
        public string scoreCalcActId { get; set; }
        /// <summary>
        /// 活動名稱
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 活動加權數
        /// </summary>
        public double rate { get; set; }
    }
    
    public class UpdateActivityActRq : UpdateScoreCalcActRqBase
    {
        public UpdateActivityActRq()
        {
            items = new List<SubActActivity>();
        }
        /// <summary>
        /// 活動子項目資料列表
        /// </summary>
        public List<SubActActivity> items { get; set; }
    }
   
    public class UpdateLsRecordActRq : UpdateScoreCalcActRqBase
    {
        public UpdateLsRecordActRq()
        {
            items = new List<SubActLsRecord>();
        }             
        /// <summary>
        /// 子項目資料列表
        /// </summary>
        public List<SubActLsRecord> items { get; set; }
    }
    #endregion

    #region（十三）匯出原始成績資料
    /// <summary>
    /// 原始成績Base
    /// </summary>
    public class ExportOrgDataBase
    {       
        /// <summary>
        /// 名稱
        /// </summary>
        public string name { get; set; }
    }
    /// <summary>
    /// 活動成績大項
    /// </summary>
    public class ExportOrgActivityData : ExportOrgDataBase
    {
        public ExportOrgActivityData()
        {
            data = new List<ActivityScores>();
        }
        /// <summary>
        /// 活動子項目資料列表
        /// </summary>
        public List<ActivityScores> data { get; set; }
    }
    /// <summary>
    /// 課堂成績大項
    /// </summary>
    public class ExportOrgLsRecordData  : ExportOrgDataBase
    {
        public ExportOrgLsRecordData()
        {
            data = new List<LessonScores>();
        }
        /// <summary>
        /// 課程原始分數資料
        /// </summary>
        public List<LessonScores> data { get; set; }
    }

    /// <summary>
    /// 課堂分數欄位
    /// </summary>
    public class LessonScores
    {
        /// <summary>
        /// 學生id
        /// </summary>
        public string id { get; set; }
        /// <summary>
        /// 名稱
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 座號
        /// </summary>
        public string no { get; set; }
        /// <summary>
        /// 出席
        /// </summary>
        public double attend { get; set; }
        /// <summary>
        /// 記分板
        /// </summary>
        public double point { get; set; }
        /// <summary>
        ///互動
        /// </summary>
        public double interaction { get; set; }
    }
    /// <summary>
    /// 活動分數欄位
    /// </summary>
    public class ActivityScores
    {
        /// <summary>
        /// 學生id
        /// </summary>
        public string id { get; set; }
        /// <summary>
        /// 名稱
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 座號
        /// </summary>
        public string no { get; set; }
        /// <summary>
        /// 分數
        /// </summary>
        public double score { get; set; }
    }
    #endregion

    #region （十二）登錄指定子項目成績資料用

    /// <summary>
    /// 更新成績 參數
    /// </summary>
    public class UpdateScoreBase
    {
        /// <summary>
        /// 活動項目id
        /// </summary>
        public string scoreCalcActId { get; set; }
        /// <summary>
        /// teammodelId
        /// </summary>
        public string teammodelId { get; set; }
        /// <summary>
        /// 子項目id
        /// </summary>
        public string id { get; set; }
    }
    /// <summary>
    /// 更新課堂子項目成績 參數
    /// </summary>
    public class UpdateScoreLessonRq: UpdateScoreBase
    {
        public UpdateScoreLessonRq()
        {
            stuActAttendScores = new List<double>();
            stuActPointScores = new List<double>();
            stuActItactScores = new List<double>();
        }
        /// <summary>
        /// 出席分數
        /// </summary>
        public List<double> stuActAttendScores { get; set; }
        /// <summary>
        /// 記分板分數
        /// </summary>
        public List<double> stuActPointScores { get; set; }
        /// <summary>
        /// 互動分數
        /// </summary>
        public List<double> stuActItactScores { get; set; }
    }

    /// <summary>
    /// 更新活動子項目成績 參數
    /// </summary>
    public class UpdateScoreActivityRq : UpdateScoreBase
    {
        public UpdateScoreActivityRq()
        {
            scores = new List<double>();
        }
        /// <summary>
        /// 分數
        /// </summary>
        public List<double> scores { get; set; }
    }

    #endregion


    #region API回傳資料用

    #region （二）查詢成績統計首頁表資料用
    /// <summary>
    /// 查詢總表-活動資料的Base
    /// </summary>
    public class ScoreCalcActDtoBase
    {
        public ScoreCalcActDtoBase()
        {
            editScores = new List<double>();
        }
        /// <summary>
        /// 活動id
        /// </summary>
        public string id { get; set; }
        /// <summary>
        /// 活動名稱
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 類型 exam:評量 | homework:作業 | lessonrecord:課堂紀錄
        /// </summary>
        public string type { get; set; }
        /// <summary>
        /// 活動加權數
        /// </summary>
        public double rate { get; set; }
        /// <summary>
        /// 個學生最後成績的加減分
        /// </summary>
        public List<double> editScores { get; set; }
    }
    /// <summary>
    /// 查詢總表-活動資料的詳細列表資料
    /// </summary>
    public class ScoreCalcActivityActDto : ScoreCalcActDtoBase
    {
        public ScoreCalcActivityActDto()
        {
            items = new List<SubActActivity>();
        }
        /// <summary>
        /// 活動子項目資料列表
        /// </summary>
        public List<SubActActivity> items { get; set; }
    }
    /// <summary>
    /// 查詢總表-活動資料課堂紀錄的詳細列表資料
    /// </summary>
    public class ScoreCalcLsRecordActDto : ScoreCalcActDtoBase
    {
        public ScoreCalcLsRecordActDto()
        {
            items = new List<SubActLsRecord>();
            attendStates = new List<AttendStatesCalc>();
        }
        /// <summary>
        /// 出席占比重
        /// </summary>
        public double attendRate { get; set; }
        /// <summary>
        /// 記分板占比重
        /// </summary>
        public double pointRate { get; set; }
        /// <summary>
        /// 互動占比重
        /// </summary>
        public double itactRate { get; set; }
        /// <summary>
        /// 出席公式
        /// </summary>
        public string stuAttendFunctionId { get; set; }
        /// <summary>
        /// 記分公式
        /// </summary>
        public string stuPointFunctionId { get; set; }
        /// <summary>
        /// 互動公式
        /// </summary>
        public string stuItactFunctionId { get; set; }
        /// <summary>
        /// 出席狀態統計資料
        /// </summary>
        public List<AttendStatesCalc> attendStates { get; set; }
        /// <summary>
        /// 子項目資料列表
        /// </summary>
        public List<SubActLsRecord> items { get; set; }
    }
    /// <summary>
    /// 統計出席狀態
    /// Uncall,0(未點名)
    /// Attended,1(出席)
    /// Absent,2(缺席)
    /// DayOff,3(請假)
    /// Absent_Sick,4(病假)
    /// Absent_Personal,5(事假)
    /// Absent_Official,6(公假)
    /// </summary>
    public class AttendStatesCalc
    {
        /// <summary>
        /// 病假次數
        /// </summary>
        public int Absent_Sick { get; set; }
        /// <summary>
        /// 缺席次數
        /// </summary>
        public int Absent { get; set; }
        /// <summary>
        /// 事假次數
        /// </summary>
        public int Absent_Personal { get; set; }
        /// <summary>
        /// 公假次數
        /// </summary>
        public int Absent_Official { get; set; }
    }
    /// <summary>
    /// 子項目欄位的Base
    /// </summary>
    public class SubActBase
    {
        /// <summary>
        /// 子項目id
        /// </summary>
        public string id { get; set; }
        /// <summary>
        /// 子項目名稱
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 子項目加權數
        /// </summary>
        public double rate { get; set; }
        /// <summary>
        /// 是否為勾選的項目
        /// </summary>
        public bool use { get; set; }

    }
    /// <summary>
    /// 活動子項目欄位
    /// </summary>
    public class SubActActivity : SubActBase
    {
        public SubActActivity()
        {
            scores = new List<double>();
        }
        public List<double> scores { get; set; }
    }
    /// <summary>
    /// 課堂紀錄子項目欄位
    /// </summary>
    public class SubActLsRecord : SubActBase
    {
        public SubActLsRecord()
        {
            stuActAttendScores = new List<double>();
            stuActPointScores = new List<double>();
            stuActItactScores = new List<double>();
        }
        /// <summary>
        /// 出席分數
        /// </summary>
        public List<double> stuActAttendScores { get; set; }
        /// <summary>
        /// 記分板分數
        /// </summary>
        public List<double> stuActPointScores { get; set; }
        /// <summary>
        /// 互動分數
        /// </summary>
        public List<double> stuActItactScores { get; set; }
    }
    /// <summary>
    /// 成績統計列表用資料
    /// </summary>
    public class Calc
    {
        /// <summary>
        /// 成績統計id
        /// </summary>
        public string id { get; set; }
        /// <summary>
        /// 成績統計名稱
        /// </summary>
        public string name { get; set; }
    }
    #endregion

    #endregion
}