TEAMModelHTEX/HTEX.Complex/Service/SystemService.cs

using Azure.Storage.Blobs.Models;
using HTEX.Complex.Service.AzureRedis;
using Newtonsoft.Json.Linq;
using System.Buffers;
using System.Collections.Concurrent;
using System.IdentityModel.Tokens.Jwt;
using System.Reflection.Metadata;
using System.Text.Encodings.Web;
using System.Text;
using System.Text.Json;
using System.Text.RegularExpressions;
using TEAMModelOS.SDK;

namespace HTEX.Complex.Service
{
    public static class SystemService
    {
        public   const double timeWeight = 0.7;
        public const double countWeight = 0.3;
        static double GetUserDuration(List<long> times)
        {
            if (times.IsNotEmpty())
            {
                if (times.Count>=2)
                {
                    double totalDuration = 0;
                    //  DateTime lastTime = DateTimeOffset.FromUnixTimeMilliseconds((long)jsonData[0]["time"]).UtcDateTime;
                    long ltime = times[0];
                    for (int i = 1; i < times.Count; i++)
                    {
                        long ctime = times[i];
                        //DateTime currentTime = DateTimeOffset.FromUnixTimeMilliseconds((long)jsonData[i]["time"]).UtcDateTime;
                        long timeDifference = ctime - ltime;

                        ///如果一小时内连续操作，则按真实时间累计
                        if (timeDifference < 3600000)
                        {
                            totalDuration += timeDifference;
                        }
                        else
                        { ///如果一小时内没有连续操作，则按象征性加10秒，以确保数据有效性。 如果因为一小时没有操作，则表示没有新的接口再次请求，当即就已经退出系统。否则后续仍然会有接口进入，并且带有时间戳
                            totalDuration += 10000;
                        }

                        ltime = ctime;

                    }
                    return totalDuration;
                }
                else { return 10000; }
            }
            else
            {
                return 0;
            }
        }




        public static List<SchoolStick> CountSchoolStickiness(IEnumerable<IGrouping<string, ApiVisit>> schoolApiVisits, IEnumerable<ApiVisit> apiVisits, List<SchoolStick> bygoneStickiness)
        {
            List<SchoolStick> schoolStickiness = new List<SchoolStick>();

            //用于做标准化值的最大最小度量值



            double max_sch_hita_c = 0, max_sch_hiteach_c = 0, max_sch_ies5Tch_c = 0, max_sch_otherTch_c = 0, max_sch_ies5Stu_c = 0, max_sch_otherStu_c = 0;
            double max_sch_hita_d = 0, max_sch_hiteach_d = 0, max_sch_ies5Tch_d = 0, max_sch_otherTch_d = 0, max_sch_ies5Stu_d = 0, max_sch_otherStu_d = 0;
            double min_sch_hita_c = 0, min_sch_hiteach_c = 0, min_sch_ies5Tch_c = 0, min_sch_otherTch_c = 0, min_sch_ies5Stu_c = 0, min_sch_otherStu_c = 0;
            double min_sch_hita_d = 0, min_sch_hiteach_d = 0, min_sch_ies5Tch_d = 0, min_sch_otherTch_d = 0, min_sch_ies5Stu_d = 0, min_sch_otherStu_d = 0;


            double max_tch_hita_c = 0, max_tch_hiteach_c = 0, max_tch_ies5Tch_c = 0, max_tch_otherTch_c = 0;
            double max_tch_hita_d = 0, max_tch_hiteach_d = 0, max_tch_ies5Tch_d = 0, max_tch_otherTch_d = 0;
            double min_tch_hita_c = 0, min_tch_hiteach_c = 0, min_tch_ies5Tch_c = 0, min_tch_otherTch_c = 0;
            double min_tch_hita_d = 0, min_tch_hiteach_d = 0, min_tch_ies5Tch_d = 0, min_tch_otherTch_d = 0;

            foreach (var chinaSchoolKey in schoolApiVisits)
            {
                SchoolStick stickiness = new SchoolStick()
                {
                    id = chinaSchoolKey.Key

                };
                var teachers = chinaSchoolKey.ToList().Where(x => !string.IsNullOrWhiteSpace(x.userId) && !string.IsNullOrWhiteSpace(x.scope) && x.scope.Equals("teacher")).GroupBy(x => x.userId);
                double hitaTime = 0, hiteachTime = 0, ies5TchTime = 0, otherTchTime = 0, ies5StuTime = 0, otherStuTime = 0;
                int hitaTch = 0, hiteachTch = 0, ies5Tch = 0, otherTch = 0, ies5Stu = 0, otherStu = 0;
                double hitaCount = 0, hiteachCount = 0, ies5TchCount = 0, otherTchCount = 0, ies5StuCount = 0, otherStuCount = 0;
                double lessonCount = chinaSchoolKey.ToList().Where(x => x.path.Contains("hiteach/create-lesson")).Count();
                int teacherCount = teachers.Count();


                double max_stu_ies5Stu_c = 0, max_stu_otherStu_c = 0;
                double max_stu_ies5Stu_d = 0, max_stu_otherStu_d = 0;
                double min_stu_ies5Stu_c = 0, min_stu_otherStu_c = 0;
                double min_stu_ies5Stu_d = 0, min_stu_otherStu_d = 0;


                foreach (var user in teachers)
                {
                    TchStick tchStick = new TchStick()
                    {
                        id = user.Key,
                        school= chinaSchoolKey.Key
                    };

                    //HiTA
                    var teacherHitaVisit = apiVisits.Where(x => !string.IsNullOrWhiteSpace(x.userId)  && x.userId.Equals(user.Key) && x.client.Equals("hita"));
                    var teacherHitaVisitCount = teacherHitaVisit.Count();
                    if (teacherHitaVisitCount>0)
                    { hitaTch+=1; }
                    var teacherHitaVisitTime = GetUserDuration(teacherHitaVisit.OrderBy(x => x.time).Select(x => x.time).ToList());
                    hitaCount+=teacherHitaVisitCount;
                    hitaTime+=teacherHitaVisitTime;
                    tchStick.hita.count.value=teacherHitaVisitCount;
                    tchStick.hita.duration.value=teacherHitaVisitTime;
                    //Other
                    var teacherOtherVisit = user.Where(x => !x.client.Equals("hita")&&!x.client.Equals("hiteach")&&!x.client.Equals("ies5"));
                    var teacherOtherVisitCount = teacherOtherVisit.Count();
                    var teacherOtherVisitTime = GetUserDuration(teacherOtherVisit.OrderBy(x => x.time).Select(x => x.time).ToList());
                    if (teacherOtherVisitCount>0)
                    { otherTch+=1; }
                    otherTchCount+=teacherOtherVisitCount;
                    otherTchTime+=teacherOtherVisitTime;

                    tchStick.otherTch.count.value=teacherOtherVisitCount;
                    tchStick.otherTch.duration.value=teacherOtherVisitTime;
                    //HiTeach
                    //教师访问hiteach 不带学校信息的
                    var teacherHiteachVisit = apiVisits.Where(x => !string.IsNullOrWhiteSpace(x.userId)  && x.userId.Equals(user.Key) && x.client.Equals("hiteach")  && string.IsNullOrWhiteSpace(x.school));
                    //教师访问hiteach 包含学校信息的
                    var teacherHiteachSchoolVisit = user.Where(x => x.client.Equals("hiteach"));
                    //教师所有的Hiteach访问
                    List<ApiVisit> teacherHiteachAllVisit = new List<ApiVisit>();
                    teacherHiteachAllVisit.AddRange(teacherHiteachVisit);
                    teacherHiteachAllVisit.AddRange(teacherHiteachSchoolVisit);
                    var teacherHiteachAllVisitCount = teacherHiteachAllVisit.Count();
                    if (teacherHiteachAllVisitCount>0)
                    { hiteachTch+=1; }
                    var teacherHiteachAllVisitTime = GetUserDuration(teacherHiteachAllVisit.OrderBy(x => x.time).Select(x => x.time).ToList());
                    hiteachCount+=teacherHiteachAllVisitCount;
                    hiteachTime+=teacherHiteachAllVisitTime;

                    tchStick.hiteach.count.value=teacherHiteachAllVisitCount;
                    tchStick.hiteach.duration.value=teacherHiteachAllVisitTime;
                    //IES5
                    var teacherIes5Visit = user.Where(x => x.client.Equals("ies5"));
                    var teacherIes5VisitCount = teacherIes5Visit.Count();
                    if (teacherIes5VisitCount>0)
                    { ies5Tch+=1; }
                    var teacherIes5VisitTime = GetUserDuration(teacherIes5Visit.OrderBy(x => x.time).Select(x => x.time).ToList());
                    ies5TchCount+=teacherIes5VisitCount;
                    ies5TchTime+=teacherIes5VisitTime;

                    tchStick.ies5Tch.count.value=teacherIes5VisitCount;
                    tchStick.ies5Tch.duration.value=teacherIes5VisitTime;
                    double lessonCountTch = chinaSchoolKey.ToList().Where(x => x.path.Contains("hiteach/create-lesson") && x.userId.Equals(user.Key)).Count();
                    tchStick.lesson.value=lessonCountTch;

                    tchStick.teacher.count.value=tchStick.hita.count.value+tchStick.hiteach.count.value+tchStick.ies5Tch.count.value+tchStick.otherTch.count.value;
                    tchStick.teacher.duration.value=tchStick.hita.duration.value+tchStick.hiteach.duration.value+tchStick.ies5Tch.duration.value+tchStick.otherTch.duration.value;

                    tchStick.hita.userCount=1;
                    tchStick.hiteach.userCount=1;
                    tchStick.ies5Tch.userCount=1;
                    tchStick.otherTch.userCount=1;
                    tchStick.teacher.userCount=1;


                    //if (tchStick.hita.count.value>0  && tchStick.hita.duration.value>0)
                    //{
                    //    tchStick.hita.stick.value= (tchStick.hita.duration.value/1000/tchStick.hita.count.value * tchStick.hita.count.value/tchStick.teacher.count.value);
                    //}
                    //if (tchStick.ies5Tch.count.value>0  && tchStick.ies5Tch.duration.value>0)
                    //{
                    //    tchStick.ies5Tch.stick.value= (tchStick.ies5Tch.duration.value/1000/tchStick.ies5Tch.count.value * tchStick.ies5Tch.count.value/tchStick.teacher.count.value);
                    //}
                    //if (tchStick.otherTch.count.value>0  && tchStick.otherTch.duration.value>0)
                    //{
                    //    tchStick.otherTch.stick.value= (tchStick.otherTch.duration.value/1000/tchStick.otherTch.count.value);
                    //}
                    //if (tchStick.hiteach.count.value>0  && tchStick.hiteach.duration.value>0)
                    //{
                    //    tchStick.hiteach.stick.value= (tchStick.hiteach.duration.value/1000/tchStick.hiteach.count.value)+(tchStick.lesson.value*100);
                    //}
                    //if (tchStick.teacher.count.value>0  && tchStick.teacher.duration.value>0)
                    //{
                    //    tchStick.teacher.stick.value= (tchStick.teacher.duration.value/1000/tchStick.teacher.count.value)+ (tchStick.lesson.value*100);
                    //}

                    #region

                    if (tchStick.hita.count.value>0)
                    {
                        if (min_tch_hita_c ==0)
                        {
                            min_tch_hita_c= tchStick.hita.count.value;
                        }
                        else if (min_tch_hita_c>tchStick.hita.count.value)
                        {
                            min_tch_hita_c=tchStick.hita.count.value;
                        }
                        if (tchStick.hita.count.value>max_tch_hita_c)
                        {
                            max_tch_hita_c= tchStick.hita.count.value;
                        }
                    }

                    if (tchStick.hiteach.count.value>0)
                    {
                        if (min_tch_hiteach_c ==0)
                        {
                            min_tch_hiteach_c= tchStick.hiteach.count.value;
                        }
                        else if (min_tch_hiteach_c>tchStick.hiteach.count.value)
                        {
                            min_tch_hiteach_c=tchStick.hiteach.count.value;
                        }
                        if (tchStick.hiteach.count.value>max_tch_hiteach_c)
                        {
                            max_tch_hiteach_c= tchStick.hiteach.count.value;
                        }
                    }
                    if (tchStick.ies5Tch.count.value>0)
                    {
                        if (min_tch_ies5Tch_c ==0)
                        {
                            min_tch_ies5Tch_c= tchStick.ies5Tch.count.value;
                        }
                        else if (min_tch_ies5Tch_c>tchStick.ies5Tch.count.value)
                        {
                            min_tch_ies5Tch_c=tchStick.ies5Tch.count.value;
                        }
                        if (tchStick.ies5Tch.count.value>max_tch_ies5Tch_c)
                        {
                            max_tch_ies5Tch_c= tchStick.ies5Tch.count.value;
                        }
                    }
                    if (tchStick.otherTch.count.value>0)
                    {
                        if (min_tch_otherTch_c ==0)
                        {
                            min_tch_otherTch_c= tchStick.otherTch.count.value;
                        }
                        else if (min_tch_otherTch_c>tchStick.otherTch.count.value)
                        {
                            min_tch_otherTch_c=tchStick.otherTch.count.value;
                        }
                        if (tchStick.otherTch.count.value>max_tch_otherTch_c)
                        {
                            max_tch_otherTch_c= tchStick.otherTch.count.value;
                        }
                    }
                    if (tchStick.hita.duration.value>0)
                    {
                        if (min_tch_hita_d ==0)
                        {
                            min_tch_hita_d= tchStick.hita.duration.value;
                        }
                        else if (min_tch_hita_d>tchStick.hita.duration.value)
                        {
                            min_tch_hita_d=tchStick.hita.duration.value;
                        }
                        if (tchStick.hita.duration.value>max_tch_hita_d)
                        {
                            max_tch_hita_d= tchStick.hita.duration.value;
                        }
                    }

                    if (tchStick.hiteach.duration.value>0)
                    {
                        if (min_tch_hiteach_d ==0)
                        {
                            min_tch_hiteach_d= tchStick.hiteach.duration.value;
                        }
                        else if (min_tch_hiteach_d>tchStick.hiteach.duration.value)
                        {
                            min_tch_hiteach_d=tchStick.hiteach.duration.value;
                        }
                        if (tchStick.hiteach.duration.value>max_tch_hiteach_d)
                        {
                            max_tch_hiteach_d= tchStick.hiteach.duration.value;
                        }
                    }
                    if (tchStick.ies5Tch.duration.value>0)
                    {
                        if (min_tch_ies5Tch_d ==0)
                        {
                            min_tch_ies5Tch_d= tchStick.ies5Tch.duration.value;
                        }
                        else if (min_tch_ies5Tch_d>tchStick.ies5Tch.duration.value)
                        {
                            min_tch_ies5Tch_d=tchStick.ies5Tch.duration.value;
                        }
                        if (tchStick.ies5Tch.duration.value>max_tch_ies5Tch_d)
                        {
                            max_tch_ies5Tch_d= tchStick.ies5Tch.duration.value;
                        }
                    }
                    if (tchStick.otherTch.duration.value>0)
                    {
                        if (min_tch_otherTch_d ==0)
                        {
                            min_tch_otherTch_d= tchStick.otherTch.duration.value;
                        }
                        else if (min_tch_otherTch_d>tchStick.otherTch.duration.value)
                        {
                            min_tch_otherTch_d=tchStick.otherTch.duration.value;
                        }
                        if (tchStick.otherTch.duration.value>max_tch_otherTch_d)
                        {
                            max_tch_otherTch_d= tchStick.otherTch.duration.value;
                        }
                    }
                    #endregion
                    stickiness.tchSticks.Add(tchStick);
                }
                var student = chinaSchoolKey.ToList().Where(x => !string.IsNullOrWhiteSpace(x.userId) && !string.IsNullOrWhiteSpace(x.scope) && (x.scope.Equals("student")||x.scope.Equals("tmduser"))).GroupBy(x => x.userId);
                var studentCount = student.Count();
                foreach (var user in student)
                {
                    StuStick stuStick = new StuStick
                    {
                        id=user.Key,
                        school=chinaSchoolKey.Key
                    };
                    var studentOtherVisit = user.Where(x => !x.client.Equals("ies5"));
                    var studentOtherVisitCount = studentOtherVisit.Count();
                    if (studentOtherVisitCount>0)
                    { otherStu+=1; }
                    double studentOtherVisitTime = GetUserDuration(studentOtherVisit.OrderBy(x => x.time).Select(x => x.time).ToList());
                    var studentIes5Visit = user.Where(x => x.client.Equals("ies5"));
                    var studentIes5VisitCount = studentIes5Visit.Count();
                    if (studentIes5VisitCount>0)
                    { ies5Stu+=1; }
                    double studentIes5VisitTime = GetUserDuration(studentIes5Visit.OrderBy(x => x.time).Select(x => x.time).ToList());
                    ies5StuCount+=studentIes5VisitCount;
                    ies5StuTime+=studentIes5VisitTime;
                    otherStuCount+=studentOtherVisitCount;
                    otherStuTime+=studentOtherVisitTime;

                    stuStick.ies5Stu.count.value=studentIes5VisitCount;
                    stuStick.ies5Stu.duration.value=studentIes5VisitTime;
                    stuStick.otherStu.count.value=studentOtherVisitCount;
                    stuStick.otherStu.duration.value=studentOtherVisitTime;
                    stuStick.student.count.value= stuStick.ies5Stu.count.value+stuStick.otherStu.count.value;
                    stuStick.student.duration.value= stuStick.ies5Stu.duration.value+stuStick.otherStu.duration.value;
                    stuStick.ies5Stu.userCount=1;
                    stuStick.otherStu.userCount=1;
                    stuStick.student.userCount=1;
                    //if (stuStick.ies5Stu.count.value>0  && stuStick.ies5Stu.duration.value>0)
                    //{
                    //    stuStick.ies5Stu.stick.value= (stuStick.ies5Stu.duration.value/1000/stuStick.ies5Stu.count.value);
                    //}

                    //if (stuStick.otherStu.count.value>0  && stuStick.otherStu.duration.value>0)
                    //{
                    //    stuStick.otherStu.stick.value=(stuStick.otherStu.duration.value/1000/stuStick.otherStu.count.value);
                    //}
                    //if (stuStick.student.count.value>0  && stuStick.student.duration.value>0)
                    //{
                    //    stuStick.student.stick.value=(stuStick.student.duration.value/1000/stuStick.student.count.value);
                    //}
                    #region


                    if (stuStick.otherStu.count.value>0)
                    {
                        if (min_stu_otherStu_c ==0)
                        {
                            min_stu_otherStu_c= stuStick.otherStu.count.value;
                        }
                        else if (min_stu_otherStu_c>stuStick.otherStu.count.value)
                        {
                            min_stu_otherStu_c=stuStick.otherStu.count.value;
                        }
                        if (stuStick.otherStu.count.value>max_stu_otherStu_c)
                        {
                            max_stu_otherStu_c= stuStick.otherStu.count.value;
                        }
                    }

                    if (stuStick.ies5Stu.count.value>0)
                    {
                        if (min_stu_ies5Stu_c ==0)
                        {
                            min_stu_ies5Stu_c= stuStick.ies5Stu.count.value;
                        }
                        else if (min_stu_ies5Stu_c>stuStick.ies5Stu.count.value)
                        {
                            min_stu_ies5Stu_c=stuStick.ies5Stu.count.value;
                        }
                        if (stuStick.ies5Stu.count.value>max_stu_ies5Stu_c)
                        {
                            max_stu_ies5Stu_c= stuStick.ies5Stu.count.value;
                        }
                    }


                    if (stuStick.otherStu.duration.value>0)
                    {
                        if (min_stu_otherStu_d ==0)
                        {
                            min_stu_otherStu_d= stuStick.otherStu.duration.value;
                        }
                        else if (min_stu_otherStu_d>stuStick.otherStu.duration.value)
                        {
                            min_stu_otherStu_d=stuStick.otherStu.duration.value;
                        }
                        if (stuStick.otherStu.duration.value>max_stu_otherStu_d)
                        {
                            max_stu_otherStu_d= stuStick.otherStu.duration.value;
                        }
                    }

                    if (stuStick.ies5Stu.duration.value>0)
                    {
                        if (min_stu_ies5Stu_d ==0)
                        {
                            min_stu_ies5Stu_d= stuStick.ies5Stu.duration.value;
                        }
                        else if (min_stu_ies5Stu_d>stuStick.ies5Stu.duration.value)
                        {
                            min_stu_ies5Stu_d=stuStick.ies5Stu.duration.value;
                        }
                        if (stuStick.ies5Stu.duration.value>max_stu_ies5Stu_d)
                        {
                            max_stu_ies5Stu_d= stuStick.ies5Stu.duration.value;
                        }
                    }
                    #endregion

                    stickiness.stuSticks.Add(stuStick);
                }
                //时长
                stickiness.hita.duration.value=hitaTime;
                stickiness.hiteach.duration.value=hiteachTime;
                stickiness.otherTch.duration.value=otherTchTime;
                stickiness.ies5Tch.duration.value=ies5TchTime;
                stickiness.ies5Stu.duration.value=ies5StuTime;
                stickiness.otherStu.duration.value=otherStuTime;
                stickiness.teacher.duration.value=hitaTime+hiteachTime+otherTchTime+ies5TchTime;
                stickiness.student.duration.value=otherStuTime+ies5StuTime;

                //用户数
                stickiness.hita.userCount=hitaTch;
                stickiness.hiteach.userCount=hiteachTch;
                stickiness.ies5Tch.userCount=ies5Tch;
                stickiness.otherTch.userCount=otherTch;
                stickiness.ies5Stu.userCount=ies5Stu;
                stickiness.otherStu.userCount=otherStu;
                stickiness.teacher.userCount=teacherCount;
                stickiness.student.userCount=studentCount;
                //访问数
                stickiness.hita.count.value=hitaCount;
                stickiness.hiteach.count.value=hiteachCount;
                stickiness.ies5Tch.count.value=ies5TchCount;
                stickiness.otherTch.count.value=otherTchCount;
                stickiness.ies5Stu.count.value=ies5StuCount;
                stickiness.otherStu.count.value=otherStuCount;
                stickiness.teacher.count.value=hitaCount+hiteachCount+ies5TchCount+otherTchCount;
                stickiness.student.count.value=ies5StuCount+otherStuCount;
                //开课数
                stickiness.lesson.value=lessonCount;

                //if (stickiness.hita.count.value>0  && stickiness.hita.duration.value>0)
                //{
                //    stickiness.hita.stick.value=(stickiness.hita.userCount* stickiness.hita.count.value)/(stickiness.hita.duration.value/1000/stickiness.hita.count.value);
                //}
                //if (stickiness.ies5Stu.count.value>0  && stickiness.ies5Stu.duration.value>0)
                //{
                //    stickiness.ies5Stu.stick.value=(stickiness.ies5Stu.userCount* stickiness.ies5Stu.count.value)/(stickiness.ies5Stu.duration.value/1000/stickiness.ies5Stu.count.value);
                //}
                //if (stickiness.ies5Tch.count.value>0  && stickiness.ies5Tch.duration.value>0)
                //{
                //    stickiness.ies5Tch.stick.value=(stickiness.ies5Tch.userCount* stickiness.ies5Tch.count.value)/(stickiness.ies5Tch.duration.value/1000/stickiness.ies5Tch.count.value);
                //}
                //if (stickiness.otherStu.count.value>0  && stickiness.otherStu.duration.value>0)
                //{
                //    stickiness.otherStu.stick.value=(stickiness.otherStu.userCount* stickiness.otherStu.count.value)/(stickiness.otherStu.duration.value/1000/stickiness.otherStu.count.value);
                //}
                //if (stickiness.otherTch.count.value>0  && stickiness.otherTch.duration.value>0)
                //{
                //    stickiness.otherTch.stick.value=(stickiness.otherTch.userCount* stickiness.otherTch.count.value)/(stickiness.otherTch.duration.value/1000/stickiness.otherTch.count.value);
                //}
                //if (stickiness.hiteach.count.value>0  && stickiness.hiteach.duration.value>0)
                //{
                //    stickiness.hiteach.stick.value=(stickiness.hiteach.userCount* stickiness.hiteach.count.value)/(stickiness.hiteach.duration.value/1000/stickiness.hiteach.count.value)+stickiness.lesson.value;
                //}
                //if (stickiness.teacher.count.value>0  && stickiness.teacher.duration.value>0)
                //{
                //    stickiness.teacher.stick.value=(stickiness.teacher.userCount* stickiness.teacher.count.value)/(stickiness.teacher.duration.value/1000/stickiness.teacher.count.value)+ stickiness.lesson.value;
                //}
                //if (stickiness.student.count.value>0  && stickiness.student.duration.value>0)
                //{
                //    stickiness.student.stick.value=(stickiness.student.userCount* stickiness.student.count.value)/(stickiness.student.duration.value/1000/stickiness.student.count.value)+ stickiness.lesson.value;
                //}
                #region

                if (stickiness.hita.count.value>0)
                {
                    if (min_sch_hita_c ==0)
                    {
                        min_sch_hita_c= stickiness.hita.count.value;
                    }
                    else if (min_sch_hita_c>stickiness.hita.count.value)
                    {
                        min_sch_hita_c=stickiness.hita.count.value;
                    }
                    if (stickiness.hita.count.value>max_sch_hita_c)
                    {
                        max_sch_hita_c= stickiness.hita.count.value;
                    }
                }

                if (stickiness.hiteach.count.value>0)
                {
                    if (min_sch_hiteach_c ==0)
                    {
                        min_sch_hiteach_c= stickiness.hiteach.count.value;
                    }
                    else if (min_sch_hiteach_c>stickiness.hiteach.count.value)
                    {
                        min_sch_hiteach_c=stickiness.hiteach.count.value;
                    }
                    if (stickiness.hiteach.count.value>max_sch_hiteach_c)
                    {
                        max_sch_hiteach_c= stickiness.hiteach.count.value;
                    }
                }
                if (stickiness.ies5Tch.count.value>0)
                {
                    if (min_sch_ies5Tch_c ==0)
                    {
                        min_sch_ies5Tch_c= stickiness.ies5Tch.count.value;
                    }
                    else if (min_sch_ies5Tch_c>stickiness.ies5Tch.count.value)
                    {
                        min_sch_ies5Tch_c=stickiness.ies5Tch.count.value;
                    }
                    if (stickiness.ies5Tch.count.value>max_sch_ies5Tch_c)
                    {
                        max_sch_ies5Tch_c= stickiness.ies5Tch.count.value;
                    }
                }
                if (stickiness.otherTch.count.value>0)
                {
                    if (min_sch_otherTch_c ==0)
                    {
                        min_sch_otherTch_c= stickiness.otherTch.count.value;
                    }
                    else if (min_sch_otherTch_c>stickiness.otherTch.count.value)
                    {
                        min_sch_otherTch_c=stickiness.otherTch.count.value;
                    }
                    if (stickiness.otherTch.count.value>max_sch_otherTch_c)
                    {
                        max_sch_otherTch_c= stickiness.otherTch.count.value;
                    }
                }


                if (stickiness.otherStu.count.value>0)
                {
                    if (min_sch_otherStu_c ==0)
                    {
                        min_sch_otherStu_c= stickiness.otherStu.count.value;
                    }
                    else if (min_sch_otherStu_c>stickiness.otherStu.count.value)
                    {
                        min_sch_otherStu_c=stickiness.otherStu.count.value;
                    }
                    if (stickiness.otherStu.count.value>max_sch_otherStu_c)
                    {
                        max_sch_otherStu_c= stickiness.otherStu.count.value;
                    }
                }

                if (stickiness.ies5Stu.count.value>0)
                {
                    if (min_sch_ies5Stu_c ==0)
                    {
                        min_sch_ies5Stu_c= stickiness.ies5Stu.count.value;
                    }
                    else if (min_sch_ies5Stu_c>stickiness.ies5Stu.count.value)
                    {
                        min_sch_ies5Stu_c=stickiness.ies5Stu.count.value;
                    }
                    if (stickiness.ies5Stu.count.value>max_sch_ies5Stu_c)
                    {
                        max_sch_ies5Stu_c= stickiness.ies5Stu.count.value;
                    }
                }
                if (stickiness.hita.duration.value>0)
                {
                    if (min_sch_hita_d ==0)
                    {
                        min_sch_hita_d= stickiness.hita.duration.value;
                    }
                    else if (min_sch_hita_d>stickiness.hita.duration.value)
                    {
                        min_sch_hita_d=stickiness.hita.duration.value;
                    }
                    if (stickiness.hita.duration.value>max_sch_hita_d)
                    {
                        max_sch_hita_d= stickiness.hita.duration.value;
                    }
                }

                if (stickiness.hiteach.duration.value>0)
                {
                    if (min_sch_hiteach_d ==0)
                    {
                        min_sch_hiteach_d= stickiness.hiteach.duration.value;
                    }
                    else if (min_sch_hiteach_d>stickiness.hiteach.duration.value)
                    {
                        min_sch_hiteach_d=stickiness.hiteach.duration.value;
                    }
                    if (stickiness.hiteach.duration.value>max_sch_hiteach_d)
                    {
                        max_sch_hiteach_d= stickiness.hiteach.duration.value;
                    }
                }
                if (stickiness.ies5Tch.duration.value>0)
                {
                    if (min_sch_ies5Tch_d ==0)
                    {
                        min_sch_ies5Tch_d= stickiness.ies5Tch.duration.value;
                    }
                    else if (min_sch_ies5Tch_d>stickiness.ies5Tch.duration.value)
                    {
                        min_sch_ies5Tch_d=stickiness.ies5Tch.duration.value;
                    }
                    if (stickiness.ies5Tch.duration.value>max_sch_ies5Tch_d)
                    {
                        max_sch_ies5Tch_d= stickiness.ies5Tch.duration.value;
                    }
                }
                if (stickiness.otherTch.duration.value>0)
                {
                    if (min_sch_otherTch_d ==0)
                    {
                        min_sch_otherTch_d= stickiness.otherTch.duration.value;
                    }
                    else if (min_sch_otherTch_d>stickiness.otherTch.duration.value)
                    {
                        min_sch_otherTch_d=stickiness.otherTch.duration.value;
                    }
                    if (stickiness.otherTch.duration.value>max_sch_otherTch_d)
                    {
                        max_sch_otherTch_d= stickiness.otherTch.duration.value;
                    }
                }


                if (stickiness.otherStu.duration.value>0)
                {
                    if (min_sch_otherStu_d ==0)
                    {
                        min_sch_otherStu_d= stickiness.otherStu.duration.value;
                    }
                    else if (min_sch_otherStu_d>stickiness.otherStu.duration.value)
                    {
                        min_sch_otherStu_d=stickiness.otherStu.duration.value;
                    }
                    if (stickiness.otherStu.duration.value>max_sch_otherStu_d)
                    {
                        max_sch_otherStu_d= stickiness.otherStu.duration.value;
                    }
                }

                if (stickiness.ies5Stu.duration.value>0)
                {
                    if (min_sch_ies5Stu_d ==0)
                    {
                        min_sch_ies5Stu_d= stickiness.ies5Stu.duration.value;
                    }
                    else if (min_sch_ies5Stu_d>stickiness.ies5Stu.duration.value)
                    {
                        min_sch_ies5Stu_d=stickiness.ies5Stu.duration.value;
                    }
                    if (stickiness.ies5Stu.duration.value>max_sch_ies5Stu_d)
                    {
                        max_sch_ies5Stu_d= stickiness.ies5Stu.duration.value;
                    }
                }
                #endregion
                var bygoneStickinessSchool = bygoneStickiness?.Find(x => x.id.Equals(chinaSchoolKey.Key));
                stickiness.tchSticks= OrderByTchStick(stickiness.tchSticks, bygoneStickinessSchool?.tchSticks);
                stickiness.stuSticks= OrderByStuStick(stickiness.stuSticks, bygoneStickinessSchool?.stuSticks);
                schoolStickiness.Add(stickiness);

            


            }

            return OrderBySchoolStick(schoolStickiness, bygoneStickiness);
        }
        private static List<StuStick> OrderByStuStick(List<StuStick> currentStickiness, List<StuStick>? bygoneStickiness)
        {
            // 假设visit已经填充了数据

            #region
            var rank_tmd_count = currentStickiness.Select(x => x.student.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_ies5Stu_count = currentStickiness.Select(x => x.ies5Stu.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_otherStu_count = currentStickiness.Select(x => x.otherStu.count.value).Distinct().OrderByDescending(v => v).ToList();
            #endregion
            #region
            var rank_tmd_duration = currentStickiness.Select(x => x.student.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_ies5Stu_duration = currentStickiness.Select(x => x.ies5Stu.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_otherStu_duration = currentStickiness.Select(x => x.otherStu.duration.value).Distinct().OrderByDescending(v => v).ToList();
            #endregion

            #region
            var rank_tmd_stick = currentStickiness.Select(x => x.student.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_ies5Stu_stick = currentStickiness.Select(x => x.ies5Stu.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_otherStu_stick = currentStickiness.Select(x => x.otherStu.stick.value).Distinct().OrderByDescending(v => v).ToList();
            #endregion
            currentStickiness.ForEach(x =>
            {
                #region
                if (x.student.count.value>0)
                {
                    int index_tmd_count = rank_tmd_count.FindIndex(i => i==x.student.count.value);
                    if (index_tmd_count!=-1)
                    {
                        x.student.count.rank = index_tmd_count + 1;
                    }
                }

                if (x.ies5Stu.count.value>0)
                {
                    int index_ies5Stu_count = rank_ies5Stu_count.FindIndex(i => i==x.ies5Stu.count.value);
                    if (index_ies5Stu_count!=-1)
                    {
                        x.ies5Stu.count.rank = index_ies5Stu_count + 1;
                    }
                }

                if (x.otherStu.count.value>0)
                {
                    int index_otherStu_count = rank_otherStu_count.FindIndex(i => i==x.otherStu.count.value);
                    if (index_otherStu_count!=-1)
                    {
                        x.otherStu.count.rank = index_otherStu_count + 1;
                    }
                }

                #endregion
                #region
                if (x.student.duration.value> 0)
                {
                    int index_tmd_duration = rank_tmd_duration.FindIndex(i => i==x.student.duration.value);
                    if (index_tmd_duration!=-1)
                    {
                        x.student.duration.rank = index_tmd_duration + 1;
                    }
                }


                if (x.ies5Stu.duration.value>0)
                {
                    int index_ies5Stu_duration = rank_ies5Stu_duration.FindIndex(i => i==x.ies5Stu.duration.value);
                    if (index_ies5Stu_duration!=-1)
                    {
                        x.ies5Stu.duration.rank = index_ies5Stu_duration + 1;
                    }
                }
                if (x.otherStu.duration.value>0)
                {
                    int index_otherStu_duration = rank_otherStu_duration.FindIndex(i => i==x.otherStu.duration.value);
                    if (index_otherStu_duration!=-1)
                    {
                        x.otherStu.duration.rank = index_otherStu_duration + 1;
                    }
                }

                #endregion
                #region
                if (x.student.stick.value>0)
                {
                    int index_tmd_stick = rank_tmd_stick.FindIndex(i => i==x.student.stick.value);
                    if (index_tmd_stick!=-1)
                    {
                        x.student.stick.rank = index_tmd_stick + 1;
                    }
                }
                if (x.ies5Stu.stick.value>0)
                {
                    int index_ies5Stu_stick = rank_ies5Stu_stick.FindIndex(i => i==x.ies5Stu.stick.value);
                    if (index_ies5Stu_stick!=-1)
                    {
                        x.ies5Stu.stick.rank = index_ies5Stu_stick + 1;
                    }
                }

                if (x.otherStu.stick.value>0)
                {
                    int index_otherStu_stick = rank_otherStu_stick.FindIndex(i => i==x.otherStu.stick.value);
                    if (index_otherStu_stick!=-1)
                    {
                        x.otherStu.stick.rank = index_otherStu_stick + 1;
                    }
                }
                #endregion
                var bygone = bygoneStickiness?.Find(y => y.id.Equals(x.id));
                if (bygone!=null)
                {
                    #region tmd
                    //人数上升下降
                    x.student.userUpdown= x.student.userCount-bygone.student.userCount;
                    //访问数量上升下降
                    x.student.count.range= x.student.count.value-bygone.student.count.value;
                    //访问数量排名上升下降
                    x.student.count.updown= -(x.student.count.rank-bygone.student.count.rank);
                    //停留时长上升下降
                    x.student.duration.range=x.student.duration.value-bygone.student.duration.value;
                    //停留时长排名上升下降
                    x.student.duration.updown=-(x.student.duration.rank-bygone.student.duration.rank);
                    //访问指数上升下降
                    x.student.stick.range=x.student.stick.value-bygone.student.stick.value;
                    //访问指数排名上升下降
                    x.student.stick.updown=-(x.student.stick.rank-bygone.student.stick.rank);
                    #endregion


                    #region otherStu
                    //人数上升下降
                    x.otherStu.userUpdown= x.otherStu.userCount-bygone.otherStu.userCount;
                    //访问数量上升下降
                    x.otherStu.count.range= x.otherStu.count.value-bygone.otherStu.count.value;
                    //访问数量排名上升下降
                    x.otherStu.count.updown= -(x.otherStu.count.rank-bygone.otherStu.count.rank);
                    //停留时长上升下降
                    x.otherStu.duration.range=x.otherStu.duration.value-bygone.otherStu.duration.value;
                    //停留时长排名上升下降
                    x.otherStu.duration.updown=-(x.otherStu.duration.rank - bygone.otherStu.duration.rank);
                    //访问指数上升下降
                    x.otherStu.stick.range=x.otherStu.stick.value-bygone.otherStu.stick.value;
                    //访问指数排名上升下降
                    x.otherStu.stick.updown=-(x.otherStu.stick.rank - bygone.otherStu.stick.rank);
                    #endregion

                    #region ies5Stu
                    //人数上升下降
                    x.ies5Stu.userUpdown= x.ies5Stu.userCount-bygone.ies5Stu.userCount;
                    //访问数量上升下降
                    x.ies5Stu.count.range= x.ies5Stu.count.value-bygone.ies5Stu.count.value;
                    //访问数量排名上升下降
                    x.ies5Stu.count.updown= -(x.ies5Stu.count.rank - bygone.ies5Stu.count.rank);
                    //停留时长上升下降
                    x.ies5Stu.duration.range=x.ies5Stu.duration.value-bygone.ies5Stu.duration.value;
                    //停留时长排名上升下降
                    x.ies5Stu.duration.updown=-(x.ies5Stu.duration.rank - bygone.ies5Stu.duration.rank);
                    //访问指数上升下降
                    x.ies5Stu.stick.range=x.ies5Stu.stick.value-bygone.ies5Stu.stick.value;
                    //访问指数排名上升下降
                    x.ies5Stu.stick.updown=-(x.ies5Stu.stick.rank - bygone.ies5Stu.stick.rank);
                    #endregion
                }
                else
                {
                    #region tmd
                    //人数上升下降
                    x.student.userUpdown= x.student.userCount;
                    //访问数量上升下降
                    x.student.count.range= x.student.count.value;
                    //访问数量排名上升下降
                    x.student.count.updown= x.student.count.rank;
                    //停留时长上升下降
                    x.student.duration.range=x.student.duration.value;
                    //停留时长排名上升下降
                    x.student.duration.updown=x.student.duration.rank;
                    //访问指数上升下降
                    x.student.stick.range=x.student.stick.value;
                    //访问指数排名上升下降
                    x.student.stick.updown=x.student.stick.rank;
                    #endregion


                    #region otherStu
                    //人数上升下降
                    x.otherStu.userUpdown= x.otherStu.userCount;
                    //访问数量上升下降
                    x.otherStu.count.range= x.otherStu.count.value;
                    //访问数量排名上升下降
                    x.otherStu.count.updown= x.otherStu.count.rank;
                    //停留时长上升下降
                    x.otherStu.duration.range=x.otherStu.duration.value;
                    //停留时长排名上升下降
                    x.otherStu.duration.updown=x.otherStu.duration.rank;
                    //访问指数上升下降
                    x.otherStu.stick.range=x.otherStu.stick.value;
                    //访问指数排名上升下降
                    x.otherStu.stick.updown=x.otherStu.stick.rank;
                    #endregion

                    #region ies5Stu
                    //人数上升下降
                    x.ies5Stu.userUpdown= x.ies5Stu.userCount;
                    //访问数量上升下降
                    x.ies5Stu.count.range= x.ies5Stu.count.value;
                    //访问数量排名上升下降
                    x.ies5Stu.count.updown= x.ies5Stu.count.rank;
                    //停留时长上升下降
                    x.ies5Stu.duration.range=x.ies5Stu.duration.value;
                    //停留时长排名上升下降
                    x.ies5Stu.duration.updown=x.ies5Stu.duration.rank;
                    //访问指数上升下降
                    x.ies5Stu.stick.range=x.ies5Stu.stick.value;
                    //访问指数排名上升下降
                    x.ies5Stu.stick.updown=x.ies5Stu.stick.rank;
                    #endregion
                }
            });

            //当前时间没有的
            var disappears = bygoneStickiness?.Where(x => x.student.stick.value!=0).ExceptBy(currentStickiness.Select(x => x.id), y => y.id);
            if (disappears!=null && disappears.Count()>0)
            {
                double rank_tmd_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.student.stick.rank).Max() : 0;
                double rank_tmd_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.student.count.rank).Max() : 0;
                double rank_tmd_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.student.duration.rank).Max() : 0;

                double rank_ies5Stu_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.ies5Stu.stick.rank).Max() : 0;
                double rank_ies5Stu_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.ies5Stu.count.rank).Max() : 0;
                double rank_ies5Stu_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.ies5Stu.duration.rank).Max() : 0;


                double rank_otherStu_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.otherStu.stick.rank).Max() : 0;
                double rank_otherStu_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.otherStu.count.rank).Max() : 0;
                double rank_otherStu_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.otherStu.duration.rank).Max() : 0;


                foreach (var disappear in disappears)
                {
                    //下降
                    // y 5 t0
                    disappear.student.stick.updown= -disappear.student.stick.rank;
                    disappear.student.stick.range= -disappear.student.stick.value;
                    disappear.student.stick.value=0;
                    disappear.student.stick.rank=rank_tmd_stick_Max+1;

                    disappear.ies5Stu.stick.updown= -disappear.ies5Stu.stick.rank;
                    disappear.ies5Stu.stick.range= -disappear.ies5Stu.stick.value;
                    disappear.ies5Stu.stick.value=0;
                    disappear.ies5Stu.stick.rank=rank_ies5Stu_stick_Max+1;

                    disappear.otherStu.stick.updown= -disappear.otherStu.stick.rank;
                    disappear.otherStu.stick.range= -disappear.otherStu.stick.value;
                    disappear.otherStu.stick.value=0;
                    disappear.otherStu.stick.rank=rank_otherStu_stick_Max+1;

                    disappear.student.count.updown= -disappear.student.count.rank;
                    disappear.student.count.range= -disappear.student.count.value;
                    disappear.student.count.value=0;
                    disappear.student.count.rank=rank_tmd_count_Max+1;

                    disappear.ies5Stu.count.updown= -disappear.ies5Stu.count.rank;
                    disappear.ies5Stu.count.range= -disappear.ies5Stu.count.value;
                    disappear.ies5Stu.count.value=0;
                    disappear.ies5Stu.count.rank=rank_ies5Stu_count_Max+1;

                    disappear.otherStu.count.updown= -disappear.otherStu.count.rank;
                    disappear.otherStu.count.range= -disappear.otherStu.count.value;
                    disappear.otherStu.count.value=0;
                    disappear.otherStu.count.rank=rank_otherStu_count_Max+1;



                    disappear.student.duration.updown= -disappear.student.duration.rank;
                    disappear.student.duration.range= -disappear.student.duration.value;
                    disappear.student.duration.value=0;
                    disappear.student.duration.rank=rank_tmd_duration_Max+1;


                    disappear.ies5Stu.duration.updown= -disappear.ies5Stu.duration.rank;
                    disappear.ies5Stu.duration.range= -disappear.ies5Stu.duration.value;
                    disappear.ies5Stu.duration.value=0;
                    disappear.ies5Stu.duration.rank=rank_ies5Stu_duration_Max+1;

                    disappear.otherStu.duration.updown= -disappear.otherStu.duration.rank;
                    disappear.otherStu.duration.range= -disappear.otherStu.duration.value;
                    disappear.otherStu.duration.value=0;
                    disappear.otherStu.duration.rank=rank_otherStu_duration_Max+1;
                    currentStickiness.Add(disappear);
                }
            }

            currentStickiness= currentStickiness.OrderByDescending(x => x.student.stick.value).ToList();
            return currentStickiness;
        }
        private static List<TchStick> OrderByTchStick(List<TchStick> currentStickiness, List<TchStick>? bygoneStickiness)
        {
            // 假设visit已经填充了数据

            #region
            var rank_tmd_count = currentStickiness.Select(x => x.teacher.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_hita_count = currentStickiness.Select(x => x.hita.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_hiteach_count = currentStickiness.Select(x => x.hiteach.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_ies5Tch_count = currentStickiness.Select(x => x.ies5Tch.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_otherTch_count = currentStickiness.Select(x => x.otherTch.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_lesson_count = currentStickiness.Select(x => x.lesson.value).Distinct().OrderByDescending(v => v).ToList();
            #endregion
            #region
            var rank_tmd_duration = currentStickiness.Select(x => x.teacher.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_hita_duration = currentStickiness.Select(x => x.hita.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_hiteach_duration = currentStickiness.Select(x => x.hiteach.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_ies5Tch_duration = currentStickiness.Select(x => x.ies5Tch.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_otherTch_duration = currentStickiness.Select(x => x.otherTch.duration.value).Distinct().OrderByDescending(v => v).ToList();
            #endregion

            #region
            var rank_tmd_stick = currentStickiness.Select(x => x.teacher.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_hita_stick = currentStickiness.Select(x => x.hita.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_hiteach_stick = currentStickiness.Select(x => x.hiteach.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_ies5Tch_stick = currentStickiness.Select(x => x.ies5Tch.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_otherTch_stick = currentStickiness.Select(x => x.otherTch.stick.value).Distinct().OrderByDescending(v => v).ToList();
            #endregion
            currentStickiness.ForEach(x =>
            {
                #region
                int index_tmd_count = rank_tmd_count.FindIndex(i => i==x.teacher.count.value);
                if (index_tmd_count!=-1)
                {
                    x.teacher.count.rank = index_tmd_count + 1;
                }
                int index_hita_count = rank_hita_count.FindIndex(i => i==x.hita.count.value);
                if (index_hita_count!=-1)
                {
                    x.hita.count.rank = index_hita_count + 1;
                }
                int index_hiteach_count = rank_hiteach_count.FindIndex(i => i==x.hiteach.count.value);
                if (index_hiteach_count!=-1)
                {
                    x.hiteach.count.rank = index_hiteach_count + 1;
                }
                int index_ies5Tch_count = rank_ies5Tch_count.FindIndex(i => i==x.ies5Tch.count.value);
                if (index_ies5Tch_count!=-1)
                {
                    x.ies5Tch.count.rank = index_ies5Tch_count + 1;
                }
                int index_otherTch_count = rank_otherTch_count.FindIndex(i => i==x.otherTch.count.value);
                if (index_otherTch_count!=-1)
                {
                    x.otherTch.count.rank = index_otherTch_count + 1;
                }

                int index_lesson_count = rank_lesson_count.FindIndex(i => i==x.lesson.value);
                if (index_lesson_count!=-1)
                {
                    x.lesson.rank = index_lesson_count + 1;
                }
                #endregion
                #region
                int index_tmd_duration = rank_tmd_duration.FindIndex(i => i==x.teacher.duration.value);
                if (index_tmd_duration!=-1)
                {
                    x.teacher.duration.rank = index_tmd_duration + 1;
                }
                int index_hita_duration = rank_hita_duration.FindIndex(i => i==x.hita.duration.value);
                if (index_hita_duration!=-1)
                {
                    x.hita.duration.rank = index_hita_duration + 1;
                }
                int index_hiteach_duration = rank_hiteach_duration.FindIndex(i => i==x.hiteach.duration.value);
                if (index_hiteach_duration!=-1)
                {
                    x.hiteach.duration.rank = index_hiteach_duration + 1;
                }
                int index_ies5Tch_duration = rank_ies5Tch_duration.FindIndex(i => i==x.ies5Tch.duration.value);
                if (index_ies5Tch_duration!=-1)
                {
                    x.ies5Tch.duration.rank = index_ies5Tch_duration + 1;
                }
                int index_otherTch_duration = rank_otherTch_duration.FindIndex(i => i==x.otherTch.duration.value);
                if (index_otherTch_duration!=-1)
                {
                    x.otherTch.duration.rank = index_otherTch_duration + 1;
                }


                #endregion
                #region
                int index_tmd_stick = rank_tmd_stick.FindIndex(i => i==x.teacher.stick.value);
                if (index_tmd_stick!=-1)
                {
                    x.teacher.stick.rank = index_tmd_stick + 1;
                }
                int index_hita_stick = rank_hita_stick.FindIndex(i => i==x.hita.stick.value);
                if (index_hita_stick!=-1)
                {
                    x.hita.stick.rank = index_hita_stick + 1;
                }
                int index_hiteach_stick = rank_hiteach_stick.FindIndex(i => i==x.hiteach.stick.value);
                if (index_hiteach_stick!=-1)
                {
                    x.hiteach.stick.rank = index_hiteach_stick + 1;
                }
                int index_ies5Tch_stick = rank_ies5Tch_stick.FindIndex(i => i==x.ies5Tch.stick.value);
                if (index_ies5Tch_stick!=-1)
                {
                    x.ies5Tch.stick.rank = index_ies5Tch_stick + 1;
                }
                int index_otherTch_stick = rank_otherTch_stick.FindIndex(i => i==x.otherTch.stick.value);
                if (index_otherTch_stick!=-1)
                {
                    x.otherTch.stick.rank = index_otherTch_stick + 1;
                }
                #endregion

                var bygone = bygoneStickiness?.Find(y => y.id.Equals(x.id));
                if (bygone!=null)
                {
                    #region
                    x.lesson.range=x.lesson.value-bygone.lesson.value;
                    x.lesson.updown=x.lesson.rank-bygone.lesson.rank;
                    #endregion
                    #region tmd
                    //人数上升下降
                    x.teacher.userUpdown= x.teacher.userCount-bygone.teacher.userCount;
                    //访问数量上升下降
                    x.teacher.count.range= x.teacher.count.value-bygone.teacher.count.value;
                    //访问数量排名上升下降
                    x.teacher.count.updown= -(x.teacher.count.rank - bygone.teacher.count.rank);
                    //停留时长上升下降
                    x.teacher.duration.range=x.teacher.duration.value-bygone.teacher.duration.value;
                    //停留时长排名上升下降
                    x.teacher.duration.updown=-(x.teacher.duration.rank - bygone.teacher.duration.rank);
                    //访问指数上升下降
                    x.teacher.stick.range=x.teacher.stick.value-bygone.teacher.stick.value;
                    //访问指数排名上升下降
                    x.teacher.stick.updown=-(x.teacher.stick.rank - bygone.teacher.stick.rank);
                    #endregion

                    #region hita
                    //人数上升下降
                    x.hita.userUpdown= x.hita.userCount-bygone.hita.userCount;
                    //访问数量上升下降
                    x.hita.count.range= x.hita.count.value-bygone.hita.count.value;
                    //访问数量排名上升下降
                    x.hita.count.updown= -(x.hita.count.rank - bygone.hita.count.rank);
                    //停留时长上升下降
                    x.hita.duration.range=x.hita.duration.value-bygone.hita.duration.value;
                    //停留时长排名上升下降
                    x.hita.duration.updown=-(x.hita.duration.rank - bygone.hita.duration.rank);
                    //访问指数上升下降
                    x.hita.stick.range=x.hita.stick.value-bygone.hita.stick.value;
                    //访问指数排名上升下降
                    x.hita.stick.updown=-(x.hita.stick.rank - bygone.hita.stick.rank);
                    #endregion

                    #region hiteach
                    //人数上升下降
                    x.hiteach.userUpdown= x.hiteach.userCount-bygone.hiteach.userCount;
                    //访问数量上升下降
                    x.hiteach.count.range= x.hiteach.count.value-bygone.hiteach.count.value;
                    //访问数量排名上升下降
                    x.hiteach.count.updown= -(x.hiteach.count.rank - bygone.hiteach.count.rank);
                    //停留时长上升下降
                    x.hiteach.duration.range=x.hiteach.duration.value-bygone.hiteach.duration.value;
                    //停留时长排名上升下降
                    x.hiteach.duration.updown=-(x.hiteach.duration.rank - bygone.hiteach.duration.rank);
                    //访问指数上升下降
                    x.hiteach.stick.range=x.hiteach.stick.value-bygone.hiteach.stick.value;
                    //访问指数排名上升下降
                    x.hiteach.stick.updown=-(x.hiteach.stick.rank - bygone.hiteach.stick.rank);
                    #endregion

                    #region otherTch
                    //人数上升下降
                    x.otherTch.userUpdown= x.otherTch.userCount-bygone.otherTch.userCount;
                    //访问数量上升下降
                    x.otherTch.count.range= x.otherTch.count.value-bygone.otherTch.count.value;
                    //访问数量排名上升下降
                    x.otherTch.count.updown= -(x.otherTch.count.rank - bygone.otherTch.count.rank);
                    //停留时长上升下降
                    x.otherTch.duration.range=x.otherTch.duration.value-bygone.otherTch.duration.value;
                    //停留时长排名上升下降
                    x.otherTch.duration.updown=-(x.otherTch.duration.rank - bygone.otherTch.duration.rank);
                    //访问指数上升下降
                    x.otherTch.stick.range=x.otherTch.stick.value-bygone.otherTch.stick.value;
                    //访问指数排名上升下降
                    x.otherTch.stick.updown=-(x.otherTch.stick.rank - bygone.otherTch.stick.rank);
                    #endregion



                    #region ies5Tch
                    //人数上升下降
                    x.ies5Tch.userUpdown= x.ies5Tch.userCount-bygone.ies5Tch.userCount;
                    //访问数量上升下降
                    x.ies5Tch.count.range= x.ies5Tch.count.value-bygone.ies5Tch.count.value;
                    //访问数量排名上升下降
                    x.ies5Tch.count.updown= -(x.ies5Tch.count.rank - bygone.ies5Tch.count.rank);
                    //停留时长上升下降
                    x.ies5Tch.duration.range=x.ies5Tch.duration.value-bygone.ies5Tch.duration.value;
                    //停留时长排名上升下降
                    x.ies5Tch.duration.updown=-(x.ies5Tch.duration.rank - bygone.ies5Tch.duration.rank);
                    //访问指数上升下降
                    x.ies5Tch.stick.range=x.ies5Tch.stick.value-bygone.ies5Tch.stick.value;
                    //访问指数排名上升下降
                    x.ies5Tch.stick.updown=-(x.ies5Tch.stick.rank - bygone.ies5Tch.stick.rank);
                    #endregion 
                }
                else
                {
                    #region
                    x.lesson.range=x.lesson.value;
                    x.lesson.updown=x.lesson.rank;
                    #endregion
                    #region tmd
                    //人数上升下降
                    x.teacher.userUpdown= x.teacher.userCount;
                    //访问数量上升下降
                    x.teacher.count.range= x.teacher.count.value;
                    //访问数量排名上升下降
                    x.teacher.count.updown= x.teacher.count.rank;
                    //停留时长上升下降
                    x.teacher.duration.range=x.teacher.duration.value;
                    //停留时长排名上升下降
                    x.teacher.duration.updown=x.teacher.duration.rank;
                    //访问指数上升下降
                    x.teacher.stick.range=x.teacher.stick.value;
                    //访问指数排名上升下降
                    x.teacher.stick.updown=x.teacher.stick.rank;
                    #endregion

                    #region hita
                    //人数上升下降
                    x.hita.userUpdown= x.hita.userCount;
                    //访问数量上升下降
                    x.hita.count.range= x.hita.count.value;
                    //访问数量排名上升下降
                    x.hita.count.updown= x.hita.count.rank;
                    //停留时长上升下降
                    x.hita.duration.range=x.hita.duration.value;
                    //停留时长排名上升下降
                    x.hita.duration.updown=x.hita.duration.rank;
                    //访问指数上升下降
                    x.hita.stick.range=x.hita.stick.value;
                    //访问指数排名上升下降
                    x.hita.stick.updown=x.hita.stick.rank;
                    #endregion

                    #region hiteach
                    //人数上升下降
                    x.hiteach.userUpdown= x.hiteach.userCount;
                    //访问数量上升下降
                    x.hiteach.count.range= x.hiteach.count.value;
                    //访问数量排名上升下降
                    x.hiteach.count.updown= x.hiteach.count.rank;
                    //停留时长上升下降
                    x.hiteach.duration.range=x.hiteach.duration.value;
                    //停留时长排名上升下降
                    x.hiteach.duration.updown=x.hiteach.duration.rank;
                    //访问指数上升下降
                    x.hiteach.stick.range=x.hiteach.stick.value;
                    //访问指数排名上升下降
                    x.hiteach.stick.updown=x.hiteach.stick.rank;
                    #endregion

                    #region otherTch
                    //人数上升下降
                    x.otherTch.userUpdown= x.otherTch.userCount;
                    //访问数量上升下降
                    x.otherTch.count.range= x.otherTch.count.value;
                    //访问数量排名上升下降
                    x.otherTch.count.updown= x.otherTch.count.rank;
                    //停留时长上升下降
                    x.otherTch.duration.range=x.otherTch.duration.value;
                    //停留时长排名上升下降
                    x.otherTch.duration.updown=x.otherTch.duration.rank;
                    //访问指数上升下降
                    x.otherTch.stick.range=x.otherTch.stick.value;
                    //访问指数排名上升下降
                    x.otherTch.stick.updown=x.otherTch.stick.rank;
                    #endregion


                    #region ies5Tch
                    //人数上升下降
                    x.ies5Tch.userUpdown= x.ies5Tch.userCount;
                    //访问数量上升下降
                    x.ies5Tch.count.range= x.ies5Tch.count.value;
                    //访问数量排名上升下降
                    x.ies5Tch.count.updown= x.ies5Tch.count.rank;
                    //停留时长上升下降
                    x.ies5Tch.duration.range=x.ies5Tch.duration.value;
                    //停留时长排名上升下降
                    x.ies5Tch.duration.updown=x.ies5Tch.duration.rank;
                    //访问指数上升下降
                    x.ies5Tch.stick.range=x.ies5Tch.stick.value;
                    //访问指数排名上升下降
                    x.ies5Tch.stick.updown=x.ies5Tch.stick.rank;
                    #endregion
                }
            });

            //当前时间没有的
            var disappears = bygoneStickiness?.Where(x => x.teacher.stick.value!=0).ExceptBy(currentStickiness.Select(x => x.id), y => y.id);
            if (disappears!=null && disappears.Count()>0)
            {
                double rank_tmd_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.teacher.stick.rank).Max() : 0;
                double rank_tmd_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.teacher.count.rank).Max() : 0;
                double rank_tmd_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.teacher.duration.rank).Max() : 0;

                double rank_hiteach_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.hiteach.stick.rank).Max() : 0;
                double rank_hiteach_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.hiteach.count.rank).Max() : 0;
                double rank_hiteach_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.hiteach.duration.rank).Max() : 0;

                double rank_hita_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.hita.stick.rank).Max() : 0;
                double rank_hita_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.hita.count.rank).Max() : 0;
                double rank_hita_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.hita.duration.rank).Max() : 0;

                double rank_ies5Tch_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.ies5Tch.stick.rank).Max() : 0;
                double rank_ies5Tch_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.ies5Tch.count.rank).Max() : 0;
                double rank_ies5Tch_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.ies5Tch.duration.rank).Max() : 0;


                double rank_otherTch_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.otherTch.stick.rank).Max() : 0;
                double rank_otherTch_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.otherTch.count.rank).Max() : 0;
                double rank_otherTch_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.otherTch.duration.rank).Max() : 0;

                double rank_lesson_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.lesson.rank).Max() : 0;


                foreach (var disappear in disappears)
                {
                    disappear.lesson.updown=-disappear.lesson.rank;
                    disappear.lesson.range=-disappear.lesson.value;
                    disappear.lesson.value=0;
                    disappear.lesson.rank=rank_lesson_Max+1;

                    //下降
                    // y 5 t0
                    disappear.teacher.stick.updown= -disappear.teacher.stick.rank;
                    disappear.teacher.stick.range= -disappear.teacher.stick.value;
                    disappear.teacher.stick.value=0;
                    disappear.teacher.stick.rank=rank_tmd_stick_Max+1;

                    disappear.hiteach.stick.updown= -disappear.hiteach.stick.rank;
                    disappear.hiteach.stick.range= -disappear.hiteach.stick.value;
                    disappear.hiteach.stick.value=0;
                    disappear.hiteach.stick.rank=rank_hiteach_stick_Max+1;


                    disappear.hita.stick.updown= -disappear.hita.stick.rank;
                    disappear.hita.stick.range= -disappear.hita.stick.value;
                    disappear.hita.stick.value=0;
                    disappear.hita.stick.rank=rank_hita_stick_Max+1;

                    disappear.ies5Tch.stick.updown= -disappear.ies5Tch.stick.rank;
                    disappear.ies5Tch.stick.range= -disappear.ies5Tch.stick.value;
                    disappear.ies5Tch.stick.value=0;
                    disappear.ies5Tch.stick.rank=rank_ies5Tch_stick_Max+1;

                    disappear.otherTch.stick.updown= -disappear.otherTch.stick.rank;
                    disappear.otherTch.stick.range= -disappear.otherTch.stick.value;
                    disappear.otherTch.stick.value=0;
                    disappear.otherTch.stick.rank=rank_otherTch_stick_Max+1;

                    disappear.teacher.count.updown= -disappear.teacher.count.rank;
                    disappear.teacher.count.range= -disappear.teacher.count.value;
                    disappear.teacher.count.value=0;
                    disappear.teacher.count.rank=rank_tmd_count_Max+1;

                    disappear.hiteach.count.updown= -disappear.hiteach.count.rank;
                    disappear.hiteach.count.range= -disappear.hiteach.count.value;
                    disappear.hiteach.count.value=0;
                    disappear.hiteach.count.rank=rank_hiteach_count_Max+1;


                    disappear.hita.count.updown= -disappear.hita.count.rank;
                    disappear.hita.count.range= -disappear.hita.count.value;
                    disappear.hita.count.value=0;
                    disappear.hita.count.rank=rank_hita_count_Max+1;


                    disappear.ies5Tch.count.updown= -disappear.ies5Tch.count.rank;
                    disappear.ies5Tch.count.range= -disappear.ies5Tch.count.value;
                    disappear.ies5Tch.count.value=0;
                    disappear.ies5Tch.count.rank=rank_ies5Tch_count_Max+1;


                    disappear.otherTch.count.updown= -disappear.otherTch.count.rank;
                    disappear.otherTch.count.range= -disappear.otherTch.count.value;
                    disappear.otherTch.count.value=0;
                    disappear.otherTch.count.rank=rank_otherTch_count_Max+1;


                    disappear.teacher.duration.updown= -disappear.teacher.duration.rank;
                    disappear.teacher.duration.range= -disappear.teacher.duration.value;
                    disappear.teacher.duration.value=0;
                    disappear.teacher.duration.rank=rank_tmd_duration_Max+1;

                    disappear.hiteach.duration.updown= -disappear.hiteach.duration.rank;
                    disappear.hiteach.duration.range= -disappear.hiteach.duration.value;
                    disappear.hiteach.duration.value=0;
                    disappear.hiteach.duration.rank=rank_hiteach_duration_Max+1;


                    disappear.hita.duration.updown= -disappear.hita.duration.rank;
                    disappear.hita.duration.range= -disappear.hita.duration.value;
                    disappear.hita.duration.value=0;
                    disappear.hita.duration.rank=rank_hita_duration_Max+1;


                    disappear.ies5Tch.duration.updown= -disappear.ies5Tch.duration.rank;
                    disappear.ies5Tch.duration.range= -disappear.ies5Tch.duration.value;
                    disappear.ies5Tch.duration.value=0;
                    disappear.ies5Tch.duration.rank=rank_ies5Tch_duration_Max+1;


                    disappear.otherTch.duration.updown= -disappear.otherTch.duration.rank;
                    disappear.otherTch.duration.range= -disappear.otherTch.duration.value;
                    disappear.otherTch.duration.value=0;
                    disappear.otherTch.duration.rank=rank_otherTch_duration_Max+1;

                    currentStickiness.Add(disappear);
                }
            }
            currentStickiness= currentStickiness.OrderByDescending(x => x.teacher.stick.value).ToList();
            return currentStickiness;
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="currentStickiness">现在的</param>
        /// <param name="bygoneStickiness">过去的</param>
        /// <returns></returns>
        private static List<SchoolStick> OrderBySchoolStick(List<SchoolStick> currentStickiness, List<SchoolStick>? bygoneStickiness)
        {
            // 假设visit已经填充了数据

            #region
            var rank_teacher_count = currentStickiness.Select(x => x.teacher.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_student_count = currentStickiness.Select(x => x.student.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_hita_count = currentStickiness.Select(x => x.hita.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_hiteach_count = currentStickiness.Select(x => x.hiteach.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_ies5Tch_count = currentStickiness.Select(x => x.ies5Tch.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_otherTch_count = currentStickiness.Select(x => x.otherTch.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_ies5Stu_count = currentStickiness.Select(x => x.ies5Stu.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_otherStu_count = currentStickiness.Select(x => x.otherStu.count.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_lesson_count = currentStickiness.Select(x => x.lesson.value).Distinct().OrderByDescending(v => v).ToList();
            #endregion
            #region
            var rank_teacher_duration = currentStickiness.Select(x => x.teacher.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_student_duration = currentStickiness.Select(x => x.student.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_hita_duration = currentStickiness.Select(x => x.hita.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_hiteach_duration = currentStickiness.Select(x => x.hiteach.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_ies5Tch_duration = currentStickiness.Select(x => x.ies5Tch.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_otherTch_duration = currentStickiness.Select(x => x.otherTch.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_ies5Stu_duration = currentStickiness.Select(x => x.ies5Stu.duration.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_otherStu_duration = currentStickiness.Select(x => x.otherStu.duration.value).Distinct().OrderByDescending(v => v).ToList();
            #endregion

            #region
            var rank_teacher_stick = currentStickiness.Select(x => x.teacher.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_student_stick = currentStickiness.Select(x => x.student.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_hita_stick = currentStickiness.Select(x => x.hita.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_hiteach_stick = currentStickiness.Select(x => x.hiteach.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_ies5Tch_stick = currentStickiness.Select(x => x.ies5Tch.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_otherTch_stick = currentStickiness.Select(x => x.otherTch.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_ies5Stu_stick = currentStickiness.Select(x => x.ies5Stu.stick.value).Distinct().OrderByDescending(v => v).ToList();
            var rank_otherStu_stick = currentStickiness.Select(x => x.otherStu.stick.value).Distinct().OrderByDescending(v => v).ToList();
            #endregion
            currentStickiness.ForEach(x =>
            {
                #region
                if (x.teacher.count.value>0)
                {
                    int index_teacher_count = rank_teacher_count.FindIndex(i => i==x.teacher.count.value);
                    if (index_teacher_count!=-1)
                    {
                        x.teacher.count.rank = index_teacher_count + 1;
                    }
                }
                if (x.student.count.value>0)
                {
                    int index_student_count = rank_student_count.FindIndex(i => i==x.student.count.value);
                    if (index_student_count!=-1)
                    {
                        x.student.count.rank = index_student_count + 1;
                    }
                }
                if (x.hita.count.value>0)
                {
                    int index_hita_count = rank_hita_count.FindIndex(i => i==x.hita.count.value);
                    if (index_hita_count!=-1)
                    {
                        x.hita.count.rank = index_hita_count + 1;
                    }
                }

                if (x.hiteach.count.value>0)
                {
                    int index_hiteach_count = rank_hiteach_count.FindIndex(i => i==x.hiteach.count.value);
                    if (index_hiteach_count!=-1)
                    {
                        x.hiteach.count.rank = index_hiteach_count + 1;
                    }
                }
                if (x.ies5Tch.count.value>0)
                {
                    int index_ies5Tch_count = rank_ies5Tch_count.FindIndex(i => i==x.ies5Tch.count.value);
                    if (index_ies5Tch_count!=-1)
                    {
                        x.ies5Tch.count.rank = index_ies5Tch_count + 1;
                    }
                }
                if (x.otherTch.count.value>0)
                {
                    int index_otherTch_count = rank_otherTch_count.FindIndex(i => i==x.otherTch.count.value);
                    if (index_otherTch_count!=-1)
                    {
                        x.otherTch.count.rank = index_otherTch_count + 1;
                    }
                }
                if (x.ies5Stu.count.value>0)
                {
                    int index_ies5Stu_count = rank_ies5Stu_count.FindIndex(i => i==x.ies5Stu.count.value);
                    if (index_ies5Stu_count!=-1)
                    {
                        x.ies5Stu.count.rank = index_ies5Stu_count + 1;
                    }
                }
                if (x.otherStu.count.value>0)
                {
                    int index_otherStu_count = rank_otherStu_count.FindIndex(i => i==x.otherStu.count.value);
                    if (index_otherStu_count!=-1)
                    {
                        x.otherStu.count.rank = index_otherStu_count + 1;
                    }
                }
                if (x.lesson.value>0)
                {
                    int index_lesson_count = rank_lesson_count.FindIndex(i => i==x.lesson.value);
                    if (index_lesson_count!=-1)
                    {
                        x.lesson.rank = index_lesson_count + 1;
                    }
                }
                #endregion
                #region
                if (x.teacher.duration.value>0)
                {
                    int index_teacher_duration = rank_teacher_duration.FindIndex(i => i==x.teacher.duration.value);
                    if (index_teacher_duration!=-1)
                    {
                        x.teacher.duration.rank = index_teacher_duration + 1;
                    }
                }
                if (x.student.duration.value>0)
                {
                    int index_student_duration = rank_student_duration.FindIndex(i => i==x.student.duration.value);
                    if (index_student_duration!=-1)
                    {
                        x.student.duration.rank = index_student_duration + 1;
                    }
                }
                if (x.hita.duration.value>0)
                {
                    int index_hita_duration = rank_hita_duration.FindIndex(i => i==x.hita.duration.value);
                    if (index_hita_duration!=-1)
                    {
                        x.hita.duration.rank = index_hita_duration + 1;
                    }
                }
                if (x.hiteach.duration.value>0)
                {
                    int index_hiteach_duration = rank_hiteach_duration.FindIndex(i => i==x.hiteach.duration.value);
                    if (index_hiteach_duration!=-1)
                    {
                        x.hiteach.duration.rank = index_hiteach_duration + 1;
                    }
                }

                if (x.ies5Tch.duration.value>0)
                {
                    int index_ies5Tch_duration = rank_ies5Tch_duration.FindIndex(i => i==x.ies5Tch.duration.value);
                    if (index_ies5Tch_duration!=-1)
                    {
                        x.ies5Tch.duration.rank = index_ies5Tch_duration + 1;
                    }
                }

                if (x.otherTch.duration.value>0)
                {
                    int index_otherTch_duration = rank_otherTch_duration.FindIndex(i => i==x.otherTch.duration.value);
                    if (index_otherTch_duration!=-1)
                    {
                        x.otherTch.duration.rank = index_otherTch_duration + 1;
                    }
                }

                if (x.ies5Stu.duration.value>0)
                {
                    int index_ies5Stu_duration = rank_ies5Stu_duration.FindIndex(i => i==x.ies5Stu.duration.value);
                    if (index_ies5Stu_duration!=-1)
                    {
                        x.ies5Stu.duration.rank = index_ies5Stu_duration + 1;
                    }
                }

                if (x.otherStu.duration.value>0)
                {
                    int index_otherStu_duration = rank_otherStu_duration.FindIndex(i => i==x.otherStu.duration.value);
                    if (index_otherStu_duration!=-1)
                    {
                        x.otherStu.duration.rank = index_otherStu_duration + 1;
                    }
                }

                #endregion
                #region

                if (x.teacher.stick.value>0)
                {
                    int index_teacher_stick = rank_teacher_stick.FindIndex(i => i==x.teacher.stick.value);
                    if (index_teacher_stick!=-1)
                    {
                        x.teacher.stick.rank = index_teacher_stick + 1;
                    }
                }
                if (x.student.stick.value>0)
                {
                    int index_student_stick = rank_student_stick.FindIndex(i => i==x.student.stick.value);
                    if (index_student_stick!=-1)
                    {
                        x.student.stick.rank = index_student_stick + 1;
                    }
                }

                if (x.hita.stick.value>0)
                {
                    int index_hita_stick = rank_hita_stick.FindIndex(i => i==x.hita.stick.value);
                    if (index_hita_stick!=-1)
                    {
                        x.hita.stick.rank = index_hita_stick + 1;
                    }
                }

                if (x.hiteach.stick.value>0)
                {
                    int index_hiteach_stick = rank_hiteach_stick.FindIndex(i => i==x.hiteach.stick.value);
                    if (index_hiteach_stick!=-1)
                    {
                        x.hiteach.stick.rank = index_hiteach_stick + 1;
                    }
                }

                if (x.ies5Tch.stick.value>0)
                {
                    int index_ies5Tch_stick = rank_ies5Tch_stick.FindIndex(i => i==x.ies5Tch.stick.value);
                    if (index_ies5Tch_stick!=-1)
                    {
                        x.ies5Tch.stick.rank = index_ies5Tch_stick + 1;
                    }
                }

                if (x.otherTch.stick.value>0)
                {
                    int index_otherTch_stick = rank_otherTch_stick.FindIndex(i => i==x.otherTch.stick.value);
                    if (index_otherTch_stick!=-1)
                    {
                        x.otherTch.stick.rank = index_otherTch_stick + 1;
                    }
                }

                if (x.ies5Stu.stick.value>0)
                {
                    int index_ies5Stu_stick = rank_ies5Stu_stick.FindIndex(i => i==x.ies5Stu.stick.value);
                    if (index_ies5Stu_stick!=-1)
                    {
                        x.ies5Stu.stick.rank = index_ies5Stu_stick + 1;
                    }
                }

                if (x.otherStu.stick.value>0)
                {
                    int index_otherStu_stick = rank_otherStu_stick.FindIndex(i => i==x.otherStu.stick.value);
                    if (index_otherStu_stick!=-1)
                    {
                        x.otherStu.stick.rank = index_otherStu_stick + 1;
                    }
                }
                #endregion

                var bygone = bygoneStickiness?.Find(y => y.id.Equals(x.id));
                if (bygone!=null)
                {
                    #region
                    x.lesson.range=x.lesson.value-bygone.lesson.value;
                    x.lesson.updown=x.lesson.rank-bygone.lesson.rank;
                    #endregion
                    #region student
                    //人数上升下降
                    x.student.userUpdown= x.student.userCount-bygone.student.userCount;
                    //访问数量上升下降
                    x.student.count.range= x.student.count.value-bygone.student.count.value;
                    //访问数量排名上升下降
                    x.student.count.updown= -(x.student.count.rank - bygone.student.count.rank);
                    //停留时长上升下降
                    x.student.duration.range=x.student.duration.value-bygone.student.duration.value;
                    //停留时长排名上升下降
                    x.student.duration.updown=-(x.student.duration.rank - bygone.student.duration.rank);
                    //访问指数上升下降
                    x.student.stick.range=x.student.stick.value-bygone.student.stick.value;
                    //访问指数排名上升下降
                    x.student.stick.updown=-(x.student.stick.rank - bygone.student.stick.rank);
                    #endregion
                    #region teacher
                    //人数上升下降
                    x.teacher.userUpdown= x.teacher.userCount-bygone.teacher.userCount;
                    //访问数量上升下降
                    x.teacher.count.range= x.teacher.count.value-bygone.teacher.count.value;
                    //访问数量排名上升下降
                    x.teacher.count.updown= -(x.teacher.count.rank - bygone.teacher.count.rank);
                    //停留时长上升下降
                    x.teacher.duration.range=x.teacher.duration.value-bygone.teacher.duration.value;
                    //停留时长排名上升下降
                    x.teacher.duration.updown=-(x.teacher.duration.rank - bygone.teacher.duration.rank);
                    //访问指数上升下降
                    x.teacher.stick.range=x.teacher.stick.value-bygone.teacher.stick.value;
                    //访问指数排名上升下降
                    x.teacher.stick.updown=-(x.teacher.stick.rank - bygone.teacher.stick.rank);
                    #endregion
                    #region hita
                    //人数上升下降
                    x.hita.userUpdown= x.hita.userCount-bygone.hita.userCount;
                    //访问数量上升下降
                    x.hita.count.range= x.hita.count.value-bygone.hita.count.value;
                    //访问数量排名上升下降
                    x.hita.count.updown= -(x.hita.count.rank - bygone.hita.count.rank);
                    //停留时长上升下降
                    x.hita.duration.range=x.hita.duration.value-bygone.hita.duration.value;
                    //停留时长排名上升下降
                    x.hita.duration.updown=-(x.hita.duration.rank - bygone.hita.duration.rank);
                    //访问指数上升下降
                    x.hita.stick.range=x.hita.stick.value-bygone.hita.stick.value;
                    //访问指数排名上升下降
                    x.hita.stick.updown=-(x.hita.stick.rank - bygone.hita.stick.rank);
                    #endregion

                    #region hiteach
                    //人数上升下降
                    x.hiteach.userUpdown= x.hiteach.userCount-bygone.hiteach.userCount;
                    //访问数量上升下降
                    x.hiteach.count.range= x.hiteach.count.value-bygone.hiteach.count.value;
                    //访问数量排名上升下降
                    x.hiteach.count.updown= -(x.hiteach.count.rank - bygone.hiteach.count.rank);
                    //停留时长上升下降
                    x.hiteach.duration.range=x.hiteach.duration.value-bygone.hiteach.duration.value;
                    //停留时长排名上升下降
                    x.hiteach.duration.updown=-(x.hiteach.duration.rank - bygone.hiteach.duration.rank);
                    //访问指数上升下降
                    x.hiteach.stick.range=x.hiteach.stick.value-bygone.hiteach.stick.value;
                    //访问指数排名上升下降
                    x.hiteach.stick.updown=-(x.hiteach.stick.rank - bygone.hiteach.stick.rank);
                    #endregion

                    #region otherTch
                    //人数上升下降
                    x.otherTch.userUpdown= x.otherTch.userCount-bygone.otherTch.userCount;
                    //访问数量上升下降
                    x.otherTch.count.range= x.otherTch.count.value-bygone.otherTch.count.value;
                    //访问数量排名上升下降
                    x.otherTch.count.updown= -(x.otherTch.count.rank - bygone.otherTch.count.rank);
                    //停留时长上升下降
                    x.otherTch.duration.range=x.otherTch.duration.value-bygone.otherTch.duration.value;
                    //停留时长排名上升下降
                    x.otherTch.duration.updown=-(x.otherTch.duration.rank - bygone.otherTch.duration.rank);
                    //访问指数上升下降
                    x.otherTch.stick.range=x.otherTch.stick.value-bygone.otherTch.stick.value;
                    //访问指数排名上升下降
                    x.otherTch.stick.updown=-(x.otherTch.stick.rank - bygone.otherTch.stick.rank);
                    #endregion

                    #region otherStu
                    //人数上升下降
                    x.otherStu.userUpdown= x.otherStu.userCount-bygone.otherStu.userCount;
                    //访问数量上升下降
                    x.otherStu.count.range= x.otherStu.count.value-bygone.otherStu.count.value;
                    //访问数量排名上升下降
                    x.otherStu.count.updown= -(x.otherStu.count.rank - bygone.otherStu.count.rank);
                    //停留时长上升下降
                    x.otherStu.duration.range=x.otherStu.duration.value-bygone.otherStu.duration.value;
                    //停留时长排名上升下降
                    x.otherStu.duration.updown=-(x.otherStu.duration.rank - bygone.otherStu.duration.rank);
                    //访问指数上升下降
                    x.otherStu.stick.range=x.otherStu.stick.value-bygone.otherStu.stick.value;
                    //访问指数排名上升下降
                    x.otherStu.stick.updown=-(x.otherStu.stick.rank - bygone.otherStu.stick.rank);
                    #endregion

                    #region ies5Stu
                    //人数上升下降
                    x.ies5Stu.userUpdown= x.ies5Stu.userCount-bygone.ies5Stu.userCount;
                    //访问数量上升下降
                    x.ies5Stu.count.range= x.ies5Stu.count.value-bygone.ies5Stu.count.value;
                    //访问数量排名上升下降
                    x.ies5Stu.count.updown= -(x.ies5Stu.count.rank - bygone.ies5Stu.count.rank);
                    //停留时长上升下降
                    x.ies5Stu.duration.range=x.ies5Stu.duration.value-bygone.ies5Stu.duration.value;
                    //停留时长排名上升下降
                    x.ies5Stu.duration.updown=-(x.ies5Stu.duration.rank - bygone.ies5Stu.duration.rank);
                    //访问指数上升下降
                    x.ies5Stu.stick.range=x.ies5Stu.stick.value-bygone.ies5Stu.stick.value;
                    //访问指数排名上升下降
                    x.ies5Stu.stick.updown=-(x.ies5Stu.stick.rank - bygone.ies5Stu.stick.rank);
                    #endregion

                    #region ies5Tch
                    //人数上升下降
                    x.ies5Tch.userUpdown= x.ies5Tch.userCount-bygone.ies5Tch.userCount;
                    //访问数量上升下降
                    x.ies5Tch.count.range= x.ies5Tch.count.value-bygone.ies5Tch.count.value;
                    //访问数量排名上升下降
                    x.ies5Tch.count.updown= -(x.ies5Tch.count.rank - bygone.ies5Tch.count.rank);
                    //停留时长上升下降
                    x.ies5Tch.duration.range=x.ies5Tch.duration.value-bygone.ies5Tch.duration.value;
                    //停留时长排名上升下降
                    x.ies5Tch.duration.updown=-(x.ies5Tch.duration.rank - bygone.ies5Tch.duration.rank);
                    //访问指数上升下降
                    x.ies5Tch.stick.range=x.ies5Tch.stick.value-bygone.ies5Tch.stick.value;
                    //访问指数排名上升下降
                    x.ies5Tch.stick.updown=-(x.ies5Tch.stick.rank - bygone.ies5Tch.stick.rank);
                    #endregion 
                }
                else
                {
                    #region
                    x.lesson.range=x.lesson.value;
                    x.lesson.updown=x.lesson.rank;
                    #endregion
                    #region teacher
                    //人数上升下降
                    x.teacher.userUpdown= x.teacher.userCount;
                    //访问数量上升下降
                    x.teacher.count.range= x.teacher.count.value;
                    //访问数量排名上升下降
                    x.teacher.count.updown= x.teacher.count.rank;
                    //停留时长上升下降
                    x.teacher.duration.range=x.teacher.duration.value;
                    //停留时长排名上升下降
                    x.teacher.duration.updown=x.teacher.duration.rank;
                    //访问指数上升下降
                    x.teacher.stick.range=x.teacher.stick.value;
                    //访问指数排名上升下降
                    x.teacher.stick.updown=x.teacher.stick.rank;
                    #endregion
                    #region student
                    //人数上升下降
                    x.student.userUpdown= x.student.userCount;
                    //访问数量上升下降
                    x.student.count.range= x.student.count.value;
                    //访问数量排名上升下降
                    x.student.count.updown= x.student.count.rank;
                    //停留时长上升下降
                    x.student.duration.range=x.student.duration.value;
                    //停留时长排名上升下降
                    x.student.duration.updown=x.student.duration.rank;
                    //访问指数上升下降
                    x.student.stick.range=x.student.stick.value;
                    //访问指数排名上升下降
                    x.student.stick.updown=x.student.stick.rank;
                    #endregion
                    #region hita
                    //人数上升下降
                    x.hita.userUpdown= x.hita.userCount;
                    //访问数量上升下降
                    x.hita.count.range= x.hita.count.value;
                    //访问数量排名上升下降
                    x.hita.count.updown= x.hita.count.rank;
                    //停留时长上升下降
                    x.hita.duration.range=x.hita.duration.value;
                    //停留时长排名上升下降
                    x.hita.duration.updown=x.hita.duration.rank;
                    //访问指数上升下降
                    x.hita.stick.range=x.hita.stick.value;
                    //访问指数排名上升下降
                    x.hita.stick.updown=x.hita.stick.rank;
                    #endregion

                    #region hiteach
                    //人数上升下降
                    x.hiteach.userUpdown= x.hiteach.userCount;
                    //访问数量上升下降
                    x.hiteach.count.range= x.hiteach.count.value;
                    //访问数量排名上升下降
                    x.hiteach.count.updown= x.hiteach.count.rank;
                    //停留时长上升下降
                    x.hiteach.duration.range=x.hiteach.duration.value;
                    //停留时长排名上升下降
                    x.hiteach.duration.updown=x.hiteach.duration.rank;
                    //访问指数上升下降
                    x.hiteach.stick.range=x.hiteach.stick.value;
                    //访问指数排名上升下降
                    x.hiteach.stick.updown=x.hiteach.stick.rank;
                    #endregion

                    #region otherTch
                    //人数上升下降
                    x.otherTch.userUpdown= x.otherTch.userCount;
                    //访问数量上升下降
                    x.otherTch.count.range= x.otherTch.count.value;
                    //访问数量排名上升下降
                    x.otherTch.count.updown= x.otherTch.count.rank;
                    //停留时长上升下降
                    x.otherTch.duration.range=x.otherTch.duration.value;
                    //停留时长排名上升下降
                    x.otherTch.duration.updown=x.otherTch.duration.rank;
                    //访问指数上升下降
                    x.otherTch.stick.range=x.otherTch.stick.value;
                    //访问指数排名上升下降
                    x.otherTch.stick.updown=x.otherTch.stick.rank;
                    #endregion

                    #region otherStu
                    //人数上升下降
                    x.otherStu.userUpdown= x.otherStu.userCount;
                    //访问数量上升下降
                    x.otherStu.count.range= x.otherStu.count.value;
                    //访问数量排名上升下降
                    x.otherStu.count.updown= x.otherStu.count.rank;
                    //停留时长上升下降
                    x.otherStu.duration.range=x.otherStu.duration.value;
                    //停留时长排名上升下降
                    x.otherStu.duration.updown=x.otherStu.duration.rank;
                    //访问指数上升下降
                    x.otherStu.stick.range=x.otherStu.stick.value;
                    //访问指数排名上升下降
                    x.otherStu.stick.updown=x.otherStu.stick.rank;
                    #endregion

                    #region ies5Stu
                    //人数上升下降
                    x.ies5Stu.userUpdown= x.ies5Stu.userCount;
                    //访问数量上升下降
                    x.ies5Stu.count.range= x.ies5Stu.count.value;
                    //访问数量排名上升下降
                    x.ies5Stu.count.updown= x.ies5Stu.count.rank;
                    //停留时长上升下降
                    x.ies5Stu.duration.range=x.ies5Stu.duration.value;
                    //停留时长排名上升下降
                    x.ies5Stu.duration.updown=x.ies5Stu.duration.rank;
                    //访问指数上升下降
                    x.ies5Stu.stick.range=x.ies5Stu.stick.value;
                    //访问指数排名上升下降
                    x.ies5Stu.stick.updown=x.ies5Stu.stick.rank;
                    #endregion

                    #region ies5Tch
                    //人数上升下降
                    x.ies5Tch.userUpdown= x.ies5Tch.userCount;
                    //访问数量上升下降
                    x.ies5Tch.count.range= x.ies5Tch.count.value;
                    //访问数量排名上升下降
                    x.ies5Tch.count.updown= x.ies5Tch.count.rank;
                    //停留时长上升下降
                    x.ies5Tch.duration.range=x.ies5Tch.duration.value;
                    //停留时长排名上升下降
                    x.ies5Tch.duration.updown=x.ies5Tch.duration.rank;
                    //访问指数上升下降
                    x.ies5Tch.stick.range=x.ies5Tch.stick.value;
                    //访问指数排名上升下降
                    x.ies5Tch.stick.updown=x.ies5Tch.stick.rank;
                    #endregion
                }
            });
            //当前时间没有的
            var disappears = bygoneStickiness?.Where(x => x.teacher.stick.value!=0).ExceptBy(currentStickiness.Select(x => x.id), y => y.id);
            if (disappears!=null && disappears.Count()>0)
            {

                double rank_student_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.student.stick.rank).Max() : 0;
                double rank_student_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.student.count.rank).Max() : 0;
                double rank_student_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.student.duration.rank).Max() : 0;

                double rank_teacher_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.teacher.stick.rank).Max() : 0;
                double rank_teacher_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.teacher.count.rank).Max() : 0;
                double rank_teacher_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.teacher.duration.rank).Max() : 0;

                double rank_hiteach_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.hiteach.stick.rank).Max() : 0;
                double rank_hiteach_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.hiteach.count.rank).Max() : 0;
                double rank_hiteach_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.hiteach.duration.rank).Max() : 0;

                double rank_hita_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.hita.stick.rank).Max() : 0;
                double rank_hita_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.hita.count.rank).Max() : 0;
                double rank_hita_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.hita.duration.rank).Max() : 0;

                double rank_ies5Stu_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.ies5Stu.stick.rank).Max() : 0;
                double rank_ies5Stu_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.ies5Stu.count.rank).Max() : 0;
                double rank_ies5Stu_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.ies5Stu.duration.rank).Max() : 0;

                double rank_ies5Tch_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.ies5Tch.stick.rank).Max() : 0;
                double rank_ies5Tch_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.ies5Tch.count.rank).Max() : 0;
                double rank_ies5Tch_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.ies5Tch.duration.rank).Max() : 0;

                double rank_otherStu_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.otherStu.stick.rank).Max() : 0;
                double rank_otherStu_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.otherStu.count.rank).Max() : 0;
                double rank_otherStu_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.otherStu.duration.rank).Max() : 0;

                double rank_otherTch_stick_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.otherTch.stick.rank).Max() : 0;
                double rank_otherTch_count_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.otherTch.count.rank).Max() : 0;
                double rank_otherTch_duration_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.otherTch.duration.rank).Max() : 0;

                double rank_lesson_Max = currentStickiness.Count()>0 ? currentStickiness.Select(x => x.lesson.rank).Max() : 0;


                foreach (var disappear in disappears)
                {
                    disappear.lesson.updown=-disappear.lesson.rank;
                    disappear.lesson.range=-disappear.lesson.value;
                    disappear.lesson.value=0;
                    disappear.lesson.rank=rank_lesson_Max+1;

                    //下降
                    // y 5 t0

                    disappear.teacher.stick.updown= -disappear.teacher.stick.rank;
                    disappear.teacher.stick.range= -disappear.teacher.stick.value;
                    disappear.teacher.stick.value=0;
                    disappear.teacher.stick.rank=rank_teacher_stick_Max+1;
                    disappear.student.stick.updown= -disappear.student.stick.rank;
                    disappear.student.stick.range= -disappear.student.stick.value;
                    disappear.student.stick.value=0;
                    disappear.student.stick.rank=rank_student_stick_Max+1;

                    disappear.hiteach.stick.updown= -disappear.hiteach.stick.rank;
                    disappear.hiteach.stick.range= -disappear.hiteach.stick.value;
                    disappear.hiteach.stick.value=0;
                    disappear.hiteach.stick.rank=rank_hiteach_stick_Max+1;


                    disappear.hita.stick.updown= -disappear.hita.stick.rank;
                    disappear.hita.stick.range= -disappear.hita.stick.value;
                    disappear.hita.stick.value=0;
                    disappear.hita.stick.rank=rank_hita_stick_Max+1;

                    disappear.ies5Stu.stick.updown= -disappear.ies5Stu.stick.rank;
                    disappear.ies5Stu.stick.range= -disappear.ies5Stu.stick.value;
                    disappear.ies5Stu.stick.value=0;
                    disappear.ies5Stu.stick.rank=rank_ies5Stu_stick_Max+1;

                    disappear.ies5Tch.stick.updown= -disappear.ies5Tch.stick.rank;
                    disappear.ies5Tch.stick.range= -disappear.ies5Tch.stick.value;
                    disappear.ies5Tch.stick.value=0;
                    disappear.ies5Tch.stick.rank=rank_ies5Tch_stick_Max+1;

                    disappear.otherStu.stick.updown= -disappear.otherStu.stick.rank;
                    disappear.otherStu.stick.range= -disappear.otherStu.stick.value;
                    disappear.otherStu.stick.value=0;
                    disappear.otherStu.stick.rank=rank_otherStu_stick_Max+1;

                    disappear.otherTch.stick.updown= -disappear.otherTch.stick.rank;
                    disappear.otherTch.stick.range= -disappear.otherTch.stick.value;
                    disappear.otherTch.stick.value=0;
                    disappear.otherTch.stick.rank=rank_otherTch_stick_Max+1;

                    disappear.teacher.count.updown= -disappear.teacher.count.rank;
                    disappear.teacher.count.range= -disappear.teacher.count.value;
                    disappear.teacher.count.value=0;
                    disappear.teacher.count.rank=rank_teacher_count_Max+1;

                    disappear.student.count.updown= -disappear.student.count.rank;
                    disappear.student.count.range= -disappear.student.count.value;
                    disappear.student.count.value=0;
                    disappear.student.count.rank=rank_student_count_Max+1;



                    disappear.hiteach.count.updown= -disappear.hiteach.count.rank;
                    disappear.hiteach.count.range= -disappear.hiteach.count.value;
                    disappear.hiteach.count.value=0;
                    disappear.hiteach.count.rank=rank_hiteach_count_Max+1;


                    disappear.hita.count.updown= -disappear.hita.count.rank;
                    disappear.hita.count.range= -disappear.hita.count.value;
                    disappear.hita.count.value=0;
                    disappear.hita.count.rank=rank_hita_count_Max+1;

                    disappear.ies5Stu.count.updown= -disappear.ies5Stu.count.rank;
                    disappear.ies5Stu.count.range= -disappear.ies5Stu.count.value;
                    disappear.ies5Stu.count.value=0;
                    disappear.ies5Stu.count.rank=rank_ies5Stu_count_Max+1;

                    disappear.ies5Tch.count.updown= -disappear.ies5Tch.count.rank;
                    disappear.ies5Tch.count.range= -disappear.ies5Tch.count.value;
                    disappear.ies5Tch.count.value=0;
                    disappear.ies5Tch.count.rank=rank_ies5Tch_count_Max+1;

                    disappear.otherStu.count.updown= -disappear.otherStu.count.rank;
                    disappear.otherStu.count.range= -disappear.otherStu.count.value;
                    disappear.otherStu.count.value=0;
                    disappear.otherStu.count.rank=rank_otherStu_count_Max+1;

                    disappear.otherTch.count.updown= -disappear.otherTch.count.rank;
                    disappear.otherTch.count.range= -disappear.otherTch.count.value;
                    disappear.otherTch.count.value=0;
                    disappear.otherTch.count.rank=rank_otherTch_count_Max+1;


                    disappear.teacher.duration.updown= -disappear.teacher.duration.rank;
                    disappear.teacher.duration.range= -disappear.teacher.duration.value;
                    disappear.teacher.duration.value=0;
                    disappear.teacher.duration.rank=rank_teacher_duration_Max+1;


                    disappear.student.duration.updown= -disappear.student.duration.rank;
                    disappear.student.duration.range= -disappear.student.duration.value;
                    disappear.student.duration.value=0;
                    disappear.student.duration.rank=rank_student_duration_Max+1;

                    disappear.hiteach.duration.updown= -disappear.hiteach.duration.rank;
                    disappear.hiteach.duration.range= -disappear.hiteach.duration.value;
                    disappear.hiteach.duration.value=0;
                    disappear.hiteach.duration.rank=rank_hiteach_duration_Max+1;


                    disappear.hita.duration.updown= -disappear.hita.duration.rank;
                    disappear.hita.duration.range= -disappear.hita.duration.value;
                    disappear.hita.duration.value=0;
                    disappear.hita.duration.rank=rank_hita_duration_Max+1;

                    disappear.ies5Stu.duration.updown= -disappear.ies5Stu.duration.rank;
                    disappear.ies5Stu.duration.range= -disappear.ies5Stu.duration.value;
                    disappear.ies5Stu.duration.value=0;
                    disappear.ies5Stu.duration.rank=rank_ies5Stu_duration_Max+1;

                    disappear.ies5Tch.duration.updown= -disappear.ies5Tch.duration.rank;
                    disappear.ies5Tch.duration.range= -disappear.ies5Tch.duration.value;
                    disappear.ies5Tch.duration.value=0;
                    disappear.ies5Tch.duration.rank=rank_ies5Tch_duration_Max+1;

                    disappear.otherStu.duration.updown= -disappear.otherStu.duration.rank;
                    disappear.otherStu.duration.range= -disappear.otherStu.duration.value;
                    disappear.otherStu.duration.value=0;
                    disappear.otherStu.duration.rank=rank_otherStu_duration_Max+1;

                    disappear.otherTch.duration.updown= -disappear.otherTch.duration.rank;
                    disappear.otherTch.duration.range= -disappear.otherTch.duration.value;
                    disappear.otherTch.duration.value=0;
                    disappear.otherTch.duration.rank=rank_otherTch_duration_Max+1;
                    currentStickiness.Add(disappear);
                }
            }
            currentStickiness = currentStickiness.OrderByDescending(x => x.teacher.stick.value).ToList();
            return currentStickiness;
        }

        /// <summary>
        /// 结算访问日志
        /// </summary>
        public static async Task
            VisitSettle(List<string> times, AzureStorageFactory _azureStorage, AzureRedisFactory _azureRedis, Region2LongitudeLatitudeTranslator _longitudeLatitudeTranslator, IPSearcher _ipSearcher, string force)
        {


            foreach (var timeDate in times)
            {
                List<Stick> chinaSticks = new List<Stick>();
                List<Stick> globalSticks = new List<Stick>();
                if (DateTimeOffset.TryParse(timeDate, out DateTimeOffset date))
                {
                    var blobClientChina = _azureStorage.GetBlobContainerClient("0-service-log").GetBlobClient($"http-log/{date:yyyy}/{date:MM}/{date:dd}/cday.json");
                    var blobClientGlobal = _azureStorage.GetBlobContainerClient("0-service-log").GetBlobClient($"http-log/{date:yyyy}/{date:MM}/{date:dd}/gday.json");
                    bool g = true, c = true;
                    if (blobClientChina.Exists() && force.Equals("0"))
                    {
                        c=false;
                        BlobDownloadResult result = await _azureStorage.GetBlobContainerClient("0-service-log").GetBlobClient($"http-log/{date:yyyy}/{date:MM}/{date:dd}/cday.json").DownloadContentAsync();
                        var contentBygone = result.Content.ToString();
                        var chinaStick = contentBygone.ToObject<Stick>();
                        chinaSticks.Add(chinaStick);
                    }
                    if (blobClientGlobal.Exists()&& force.Equals("0"))
                    {
                        g=false;
                        BlobDownloadResult result = await _azureStorage.GetBlobContainerClient("0-service-log").GetBlobClient($"http-log/{date:yyyy}/{date:MM}/{date:dd}/gday.json").DownloadContentAsync();
                        var contentBygone = result.Content.ToString();
                        var globalStick = contentBygone.ToObject<Stick>();
                        globalSticks.Add(globalStick);
                    }
                    if (g||c)
                    {
                        BlobDownloadResult result = await _azureStorage.GetBlobContainerClient("0-service-log").GetBlobClient($"http-log/{date:yyyy}/{date:MM}/{date:dd}/index.log").DownloadContentAsync();
                        var content = result.Content.ToString();
                        content= content.Substring(0, content.Length-2);
                        if (content.EndsWith("}"))
                        {
                            content=$"[{content}]";
                        }
                        else
                        {
                            content=$"[{content}}}]";
                        }
                        List<ApiVisit> apiVisits = new List<ApiVisit>();
                        apiVisits.AddRange(content.ToObject<List<ApiVisit>>());
                        var dateNow = DateTimeOffset.Now.GetGMTTime(8);
                        if ($"{dateNow:yyyy-MM-dd}".Equals($"{date:yyyy-MM-dd}"))
                        {   //当前小时一致的
                            BlobDownloadResult resultHour = await _azureStorage.GetBlobContainerClient("0-service-log").GetBlobClient($"http-log/{date:yyyy}/{date:MM}/{date:dd}/{date:HH}.log").DownloadContentAsync();
                            var contentHour = resultHour.Content.ToString();
                            contentHour= contentHour.Substring(0, contentHour.Length-2);
                            if (contentHour.EndsWith("}"))
                            {
                                contentHour=$"[{contentHour}]";
                            }
                            else
                            {
                                contentHour=$"[{contentHour}}}]";
                            }
                            var httpLog = contentHour.ToObject<List<HttpLog>>();
                            (ConcurrentBag<ApiVisit> visits, ConcurrentBag<(string uuid, HttpLog httpLog, List<string> tmdid, List<string> school)> uuidInfo) = await SystemService.ConvertHttpLog(httpLog, _azureRedis, _ipSearcher, _longitudeLatitudeTranslator, dateNow, false);
                            apiVisits.AddRange(visits);
                        }

                        if (c)
                        {
                            Stick apiVisitsBygone = await GetBygoneSettleData(_azureStorage, date, "China");
                            //大陆学校
                            var chinaApiVisits = apiVisits.Where(x => x.hostName.Equals("大陆站"));
                            var chinaSchoolVisits = apiVisits.Where(x => !string.IsNullOrWhiteSpace(x.school) && x.hostName.Equals("大陆站")).GroupBy(x => x.school);
                            List<SchoolStick> chinaStickiness = CountSchoolStickiness(chinaSchoolVisits, chinaApiVisits, apiVisitsBygone.schoolSticks);
                            Stick stickc = new Stick();
                            stickc.schoolSticks=chinaStickiness;
                            chinaSticks.Add(stickc);
                            if (!$"{dateNow:yyyy-MM-dd}".Equals($"{date:yyyy-MM-dd}"))
                            {
                               await _azureStorage.GetBlobContainerClient("0-service-log").UploadFileByContainer(stickc.ToJsonString(), "http-log", $"{date:yyyy}/{date:MM}/{date:dd}/cday.json", true);
                            }
                        }
                        if (g)
                        {
                            Stick apiVisitsBygone = await GetBygoneSettleData(_azureStorage, date, "Global");
                            //国际学校
                            var globalApiVisits = apiVisits.Where(x => x.hostName.Equals("国际站"));
                            var globalSchoolVisits = apiVisits.Where(x => !string.IsNullOrWhiteSpace(x.school) && x.hostName.Equals("国际站")).GroupBy(x => x.school);
                            List<SchoolStick> globalStickiness = CountSchoolStickiness(globalSchoolVisits, globalApiVisits, apiVisitsBygone.schoolSticks);
                            Stick stickg = new Stick();
                            stickg.schoolSticks=globalStickiness;
                            globalSticks.Add(stickg);
                            //如果是当天的 ，则不能保存
                            if (!$"{dateNow:yyyy-MM-dd}".Equals($"{date:yyyy-MM-dd}"))
                            {
                                await _azureStorage.GetBlobContainerClient("0-service-log").UploadFileByContainer(stickg.ToJsonString(), "http-log", $"{date:yyyy}/{date:MM}/{date:dd}/gday.json", true);
                            }
                        }
                    }
                    else
                    {
                        continue;
                    }
                }

            }
        }


        public static async Task<Stick> GetBygoneSettleData(AzureStorageFactory _azureStorage, DateTimeOffset date, string cg)
        {
            //过去一天的数据
            var bygone = date.AddDays(-1);
            Stick apiVisitsBygone = new Stick();
            try
            {
                cg=cg.Contains("China", StringComparison.OrdinalIgnoreCase) ? "cday.json" : "gday.json";
                BlobDownloadResult chinaResultBygone = await _azureStorage.GetBlobContainerClient("0-service-log").GetBlobClient($"http-log/{bygone:yyyy}/{bygone:MM}/{bygone:dd}/{cg}").DownloadContentAsync();
                var contentBygone = chinaResultBygone.Content.ToString();
                apiVisitsBygone= contentBygone.ToObject<Stick>();
            }
            catch
            { //可能出现异常，因为文件不存在。第一次初始化，前一天的数据没有 }
            }

            return apiVisitsBygone;
        }
        public static async Task<(ConcurrentBag<ApiVisit> visits, ConcurrentBag<(string uuid, HttpLog httpLog, List<string> tmdid, List<string> school)> uuidInfo)>
            ConvertHttpLog(List<HttpLog> logs, AzureRedisFactory _azureRedis, IPSearcher _ipSearcher, Region2LongitudeLatitudeTranslator _longitudeLatitudeTranslator, DateTimeOffset gmt8Time, bool test = false)
        {
            ConcurrentBag<ApiVisit> visits = new ConcurrentBag<ApiVisit>();
            ConcurrentBag<(string uuid, HttpLog httpLog, List<string> tmdid, List<string> school)> uuidInfo = new ConcurrentBag<(string uuid, HttpLog httpLog, List<string> tmdid, List<string> school)>();
            object lockObj = new object();

            await Parallel.ForEachAsync(logs, async (log, _) =>
            {
                if (!log.path.Contains("."))
                {
                    string uuid = Guid.NewGuid().ToString();
                    List<string> schoolMatch = new List<string>();
                    List<string> useridMatch = new List<string>();
                    var vist = new ApiVisit()
                    {
                        id=uuid,
                        ip=log.ip,
                        tid=log.tid,
                        time= log.time,
                        userId= log.id,
                        picture=log.picture,
                        school= log.school,
                        tname= log.name,
                        path = log.path,
                        client=log.p.Equals("os", StringComparison.OrdinalIgnoreCase) ? "ies5" : log.p,
                        scope=log.scope,
                        host= log.host,
                        hostName=log.hostName,
                        l=log.l,
                        year = $"{gmt8Time:yyyy}",
                        month = $"{gmt8Time:MM}",
                        day = $"{gmt8Time:dd}",
                        hour =$"{gmt8Time:HH}"
                    };
                    if (test)
                    {
                        var time = DateTimeOffset.FromUnixTimeMilliseconds(log.time);
                        //本地调试时间
                        if (vist.ip.Equals("0.0.0.1"))
                        {
                            time= time.AddHours(8);
                        }
                        vist.year = $"{time:yyyy}";
                        vist.month = $"{time:MM}";
                        vist.day = $"{time:dd}";
                        vist.hour =$"{time:HH}";
                    }
                    if (string.IsNullOrWhiteSpace(vist.userId))
                    {

                        //var jsonPathContext = new JsonPathContext();
                        //jsonPathContext.ValueSystem= new JsonTextValueSystem();
                        string path = "$..['id_token','idToken','idtoken','tmdid','id','teacherId','teacher','tid','tId','userid','userId','creatorId','creator','code','studentId','student','studentid']";

                        if (!log.param.ValueKind.Equals(JsonValueKind.Null))
                        {
                            JObject jsonObject = JObject.Parse(log.param.GetRawText());
                            //var nodes_path = jsonPathContext.SelectNodes(log.param, path);

                            var nodes_path = jsonObject.SelectTokens(path);
                            foreach (var node in nodes_path)
                            {
                                // 只获取是字符串的 
                                if (node.Type.Equals(JTokenType.String))
                                {
                                    switch (true)
                                    {
                                        case bool when node.Path.Contains("id_token")||node.Path.Contains("idToken")||node.Path.Contains("idtoken"):
                                            {
                                                try
                                                {
                                                    var jwt = new JwtSecurityToken($"{node}");
                                                    string id = jwt.Payload.Sub;
                                                    var name = jwt.Claims.FirstOrDefault(claim => claim.Type.Equals("name"))?.Value;
                                                    var picture = jwt.Claims.FirstOrDefault(claim => claim.Type.Equals("picture"))?.Value;
                                                    if (!string.IsNullOrWhiteSpace(id) && long.TryParse(id, out long _id))
                                                    {
                                                        vist.userId=id;
                                                        vist.scope="teacher";
                                                        vist.tname=name;
                                                        vist.picture=picture;
                                                        useridMatch.Add(id);
                                                    }
                                                }
                                                catch (Exception ex) { }
                                                break;
                                            }
                                        case bool when node.Path.Contains("tmdid")||node.Path.Contains("id")||node.Path.Contains("teacherId")
                                        ||node.Path.Contains("teacher")||node.Path.Contains("tid")||node.Path.Contains("tId")||node.Path.Contains("userid")
                                        ||node.Path.Contains("userId"):
                                            {
                                                if (!string.IsNullOrWhiteSpace($"{node}") && long.TryParse($"{node}", out long _id))
                                                {
                                                    vist.userId=$"{node}";
                                                    vist.scope="teacher";
                                                    useridMatch.Add($"{node}");

                                                }
                                                break;
                                            }
                                        case bool when node.Path.Contains("studentId")||node.Path.Contains("student")||node.Path.Contains("studentid"):
                                            {
                                                if (!string.IsNullOrWhiteSpace($"{node}") && long.TryParse($"{node}", out long _id))
                                                {
                                                    vist.userId=$"{node}";
                                                    vist.scope="student";
                                                    useridMatch.Add($"{node}");

                                                }
                                                break;
                                            }
                                        case bool when node.Path.Contains("code"):
                                            {
                                                if (!string.IsNullOrWhiteSpace($"{node}"))
                                                {
                                                    if (long.TryParse($"{node}", out long _id))
                                                    {
                                                        vist.userId=$"{node}";
                                                        useridMatch.Add($"{node}");
                                                    }
                                                    else
                                                    {
                                                        string[] codes = $"{node}".Split("-");
                                                        foreach (var _code in codes)
                                                        {
                                                            if (long.TryParse(_code, out long _codeid))
                                                            {
                                                                vist.userId=$"{node}";
                                                                useridMatch.Add($"{_code}");
                                                                break;
                                                            }
                                                        }
                                                    }
                                                }
                                                break;
                                            }
                                    }
                                }
                            }

                            if (log.path.Contains("process-notify", StringComparison.OrdinalIgnoreCase))
                            {
                                string s = log.param.ToJsonString().Replace("\\", "");
                                Regex regextmdid = new Regex("\"tmdid\":\"(\\d+)\"");
                                Match matchtmdid = regextmdid.Match(s);
                                if (matchtmdid.Success)
                                {
                                    var t = matchtmdid.Groups[1].Value;

                                    if (!string.IsNullOrWhiteSpace(t))
                                    {
                                        vist.userId=t;
                                        vist.scope="teacher";
                                        useridMatch.Add(t);
                                    }
                                }
                                Regex regexname = new Regex("\"tmdname\":\"(.+?)\"");
                                Match matchname = regexname.Match(s);
                                if (matchname.Success)
                                {
                                    var t = matchname.Groups[1].Value;
                                    if (!string.IsNullOrWhiteSpace(t))
                                    {
                                        vist.tname=t;
                                    }
                                }
                            }
                        }
                    }
                    else
                    {
                        if (string.IsNullOrWhiteSpace($"{vist.scope}"))
                        {
                            vist.scope="teacher";
                            uuidInfo.Add((uuid, log, new List<string>() { vist.userId }, new List<string>()));
                        }
                    }
                    if (string.IsNullOrWhiteSpace(vist.school) || vist.school.Equals("true") || vist.school.Equals("false"))
                    {
                        vist.school="";
                        string path = "$..['school','id','schoolId','schoolid','schoolCode','school_code','schoolcode','code']";
                        if (!log.param.ValueKind.Equals(JsonValueKind.Null))
                        {
                            JObject jsonObject = JObject.Parse(log.param.GetRawText());
                            var nodes_path = jsonObject.SelectTokens(path);
                            foreach (var node in nodes_path)
                            {
                                // 只获取是字符串的 
                                if (node.Type.Equals(JTokenType.String))
                                {
                                    switch (true)
                                    {
                                        case bool when node.Path.Contains("school")||node.Path.Contains("id")||node.Path.Contains("schoolId")
                                        ||node.Path.Contains("schoolid")||node.Path.Contains("schoolCode")||node.Path.Contains("school_code")||node.Path.Contains("schoolcode"):
                                            {
                                                if (!$"{node}".Contains("-")&&  $"{node}".Length<=8 && $"{node}".Length>=1)
                                                {
                                                    vist.school=$"{node}";
                                                    schoolMatch.Add($"{node}");
                                                }
                                                break;
                                            }
                                        case bool when node.Path.Contains("code"):
                                            {
                                                if (!$"{node}".Contains("-")&&  $"{node}".Length<=8&& $"{node}".Length>=1)
                                                {
                                                    vist.school=$"{node}";
                                                    schoolMatch.Add($"{node}");
                                                }
                                                else
                                                {
                                                    string[] codes = $"{node}".Split("-");
                                                    foreach (var _code in codes)
                                                    {
                                                        if ($"{_code}".Length<=8  && $"{_code}".Length>=1)
                                                        {
                                                            vist.school=$"{_code}";
                                                            schoolMatch.Add($"{_code}");
                                                            break;
                                                        }
                                                    }
                                                }
                                                break;
                                            }
                                    }
                                }

                            }
                            if (log.path.Contains("process-notify", StringComparison.OrdinalIgnoreCase))
                            {
                                string s = log.param.ToJsonString().Replace("\\", "");
                                Regex regexname = new Regex("\"schoolId\":\"(.+?)\"");
                                Match matchname = regexname.Match(s);
                                if (matchname.Success)
                                {
                                    var t = matchname.Groups[1].Value;
                                    if (!string.IsNullOrWhiteSpace(t))
                                    {
                                        vist.school=t;
                                    }
                                }
                            }
                        }

                    }
                    //处理 client
                    {
                        if (!string.IsNullOrWhiteSpace(log.client))
                        {
                            if (log.client.Equals("IES", StringComparison.OrdinalIgnoreCase))
                            {
                                vist.client="ies5";
                            }
                            if (log.client.Equals("AClassONE", StringComparison.OrdinalIgnoreCase))
                            {
                                vist.client="aclassone";
                            }
                            if (log.client.Equals("BB", StringComparison.OrdinalIgnoreCase))
                            {
                                vist.client="habb";
                            }
                            if (log.client.Equals("HiTool", StringComparison.OrdinalIgnoreCase) ||log.client.Equals("HiTools", StringComparison.OrdinalIgnoreCase))
                            {
                                vist.client="hiscan";
                            }
                            if (log.client.Equals("HiTA", StringComparison.OrdinalIgnoreCase))
                            {
                                vist.client="hita";
                                vist.scope="teacher";
                            }
                            if (log.client.Equals("HiTeachCC", StringComparison.OrdinalIgnoreCase))
                            {
                                vist.client="hiteachcc";
                            }
                            if (log.client.Equals("HiTeach", StringComparison.OrdinalIgnoreCase))
                            {
                                vist.scope="teacher";
                                vist.client="hiteach";
                            }
                            if (log.client.Equals("Open", StringComparison.OrdinalIgnoreCase))
                            {
                                vist.client="open";
                            }
                        }
                    }
                    //补全站点
                    {
                        if (
                            (log.host.Equals("wwww.teammodel.net")||log.host.Equals("ies5-rc.teammodel.net")))
                        {
                            vist.hostName="国际站";
                            vist.host="www.teammodel.net";
                            vist.client="ies5";
                            vist.l="Global";
                        }
                        else if (
                             log.host.Equals("teammodelos-yx.chinacloudsites.cn")||log.host.Equals("teammodelos.chinacloudsites.cn")
                             ||log.host.Equals("yx.teammodel.cn")||log.host.Equals("teammodelos-rc.chinacloudsites.cn")||log.host.Equals("rc.teammodel.cn")|| log.host.Equals("www.teammodel.cn"))
                        {
                            vist.hostName="大陆站";
                            vist.host="www.teammodel.cn";
                            vist.client="ies5"; vist.l="China";
                        }
                        else if ((log.host.Contains("localhost")  &&  log.p.Equals("os"))|| log.host.Equals("teammodelos-test.chinacloudsites.cn") ||log.host.Equals("test.teammodel.cn"))
                        {
                            vist.hostName="测试站";
                            vist.host="test.teammodel.cn";
                            vist.client="ies5";
                            vist.l="China";
                        }
                        else if (
                           (log.host.Equals("scyx.teammodel.cn")  ||log.host.Equals("jinniu.teammodel.cn")))
                        {
                            vist.hostName="研修2.0";
                            vist.host="scyx.teammodel.cn";
                            vist.client="ability"; vist.l="China";
                        }
                        else if (
                            log.host.Equals("open.teammodel.cn")||log.host.Equals("open-test.teammodel.cn")  ||log.host.Equals("zhiyin-test.teammodel.cn"))
                        {
                            vist.hostName="开放平台";
                            vist.host="open.teammodel.cn";
                            vist.client="open";
                            vist.l="China";
                        }
                        else if ((log.host.Equals("bi-rc.teammodel.net") || log.host.Equals("bi.teammodel.net")))
                        {
                            vist.hostName="国际站";
                            vist.host="bi.teammodel.net";
                            vist.client="bi";
                            vist.scope="admin";
                            vist.l="Global";
                        }
                        else if (log.host.Equals("teammodelbi.chinacloudsites.cn") ||log.host.Equals("bi.teammodel.cn"))
                        {
                            vist.hostName="大陆站";
                            vist.host="bi.teammodel.cn";
                            vist.client="bi";
                            vist.scope="admin";
                            vist.l="China";
                        }
                        else if (log.host.Equals("bitest.teammodel.cn")||log.host.Equals("teammodelbi-test.chinacloudsites.cn")||(log.host.Contains("localhost")  && (log.p.Equals("bi"))))
                        {
                            vist.hostName="测试站";
                            vist.host="testbi.teammodel.cn";
                            vist.client="bi";
                            vist.scope="admin";
                            vist.l="China";
                        }
                        else if (
                            log.host.Equals("teamcontest.chinacloudsites.cn")||log.host.Equals("contest.chinacloudsites.cn")||log.host.Equals("contest-test.chinacloudsites.cn"))
                        {
                            vist.hostName="大陆站";
                            vist.host="contest.teammodel.cn";
                            vist.client="contest"; vist.l="China";
                        }
                        else if (
                             log.host.Equals("hiteachcc.chinacloudsites.cn"))
                        {
                            vist.hostName="正式站";
                            vist.host="hiteachcc.teammodel.cn";
                            vist.client="hiteachcc";
                            vist.l="China";
                        }
                        else if (log.host.Equals("appraisal.chinacloudsites.cn"))
                        {
                            vist.hostName="大陆站";
                            vist.host="appraisal.teammodel.cn";
                            vist.client="appraisal";
                            vist.l="China";
                        }
                        else if ((log.host.Contains("localhost")  &&  log.p.Equals("appraisal"))||log.host.Equals("appraisal-test.teammodel.cn")  ||log.host.Equals("appraisal-test.chinacloudsites.cn"))
                        {
                            vist.hostName="测试站";
                            vist.host="appraisal-test.teammodel.cn";
                            vist.client="appraisal";
                            vist.l="China";
                        }
                        else
                        {
                            if (!string.IsNullOrWhiteSpace(log.p))
                            {
                                vist.client=log.p.Equals("os", StringComparison.OrdinalIgnoreCase) ? "ies5" : log.p;
                            }
                            else
                            {
                                vist.client="other";
                            }
                            if (log.host.EndsWith(".cn"))
                            {
                                vist.hostName="大陆站";
                                vist.l="China";
                            }
                            else if (log.host.EndsWith(".net"))
                            {
                                vist.hostName="国际站";
                                vist.l="Global";
                            }
                            else
                            {
                                vist.hostName="其他";
                                vist.l="其他";

                            }

                        }
                    }

                    //补全产品端
                    {
                        //研修2.0
                        if (log.path.Contains("research")  || log.path.Contains("study")  || log.path.Contains("standard-file"))
                        {
                            vist.client="ability";
                        }
                        if (log.path.Contains("teacher"))
                        {
                            vist.scope="teacher";
                        }
                        if (log.path.Contains("tmduser"))
                        {
                            vist.scope="tmduser";
                        }
                        if (log.path.Contains("student/login"))
                        {
                            vist.scope="student";
                        }
                        if (log.path.StartsWith("/activity"))
                        {
                            vist.client="contest";
                        }
                        //小程序
                        if (log.path.Contains("aclassone"))
                        {
                            vist.client="aclassone";
                        }
                        //  /// <summary>
                        /// ExamInfo  qamode   書面問答類型 0:書面問答 1:紙本測驗 2:艺术评测
                        /// </summary>
                        //艺术评测
                        if (log.path.Contains("art") ||log.path.Contains("aclassone/find-children-activity")  ||log.path.Contains("aclassone/find-teacher-activity") ||log.path.Contains("aclassone/find-summary-activity") ||log.path.Contains("aclassone/upload-all") ||log.path.Contains("aclassone/delete"))
                        {
                            vist.client="art";
                        }
                        if (log.path.Contains("common/exam/upsert-record"))
                        {
                            JObject jobject = JObject.Parse(log.param.GetRawText());
                            var jtokens = jobject.SelectTokens("$..artId");
                            if (jtokens!=null && jtokens.Count()>0)
                            {
                                vist.client="art";
                                vist.scope="student";
                            }
                        }
                        if (log.path.Contains("habb"))
                        {
                            vist.client="habb";
                        }
                        //阅卷客户端
                        if (log.path.Contains("hiscan"))
                        {
                            vist.client="hiscan";
                        }
                        if (log.path.Contains("hita"))
                        {
                            vist.client="hita";
                        }
                        if (log.path.Contains("hiteachcc"))
                        {
                            vist.client="hiteachcc";
                        }
                        if (log.path.Contains("sokrate"))
                        {
                            vist.client="sokrate";
                        }
                        if (log.path.Contains("sokrate") || log.path.Contains("score"))
                        {
                            vist.client="sokrate";
                        }
                        if (log.path.Contains("hiteach"))
                        {
                            vist.client="hiteach";
                        }
                        ///IES开放平台
                        if (log.path.Contains("business")  || log.path.Contains("biz") || log.path.Contains("openapi-config")  || log.path.Contains("open-api"))
                        {
                            vist.client="open";
                        }
                        //从token的role 能否获取 开放平台
                        //单点登录及第三方接口
                        if (log.path.Contains("lepei") || log.path.Contains("sc/")  || log.path.Contains("/sso") || log.path.Contains("sc-init")|| log.path.Contains("moofen") || log.path.Contains("data-push") || log.path.Contains("xkw")|| log.path.Contains("tianbo")
                            || log.path.Contains("oauth/check-bind")|| log.path.Contains("dingding")  || log.path.Contains("wechat")
                            )
                        {
                            vist.client="sso-third";
                        }
                    }

                    //处理IP转地区
                    var region = await _ipSearcher.SearchIpAsync(vist.ip);
                    if (string.IsNullOrWhiteSpace(region))
                    {
                        region="未知IP·未知IP·未知IP";
                    }
                    if (!string.IsNullOrWhiteSpace(region))
                    {
                        region=   region.Replace("省·", "·").Replace("市·", "·").Replace("特别行政区·", "·").Replace("藏族羌族自治州·", "·");
                        var regions = region.Split("·");
                        if (regions.Length==4)
                        {
                            vist.area=  regions[0];
                            vist.province   = regions[1];
                            vist.city = regions[2];
                        }
                        if (regions.Length==3)
                        {
                            vist.area=  regions[0];
                            vist.province   = regions[1];
                        }
                        if (regions.Length==2)
                        {
                            vist.area=  regions[0];
                            vist.province   = regions[1];
                        }
                        if (regions.Length==1)
                        {
                            vist.area=  regions[0];
                        }
                    }

                    //处理地区转经纬度
                    {
                        IEnumerable<JToken> tokens = default;
                        if (!string.IsNullOrWhiteSpace(vist.city) && !string.IsNullOrWhiteSpace(vist.province)  && !string.IsNullOrWhiteSpace(vist.area))
                        {
                            tokens= _longitudeLatitudeTranslator.regionJson.SelectTokens($"$..[?(@.province=~ /.*{vist.province}/i && @.city=~ /.*{vist.city}/i)]");
                            if (!(tokens.Any() && tokens.Count()>0))
                            {
                                tokens= _longitudeLatitudeTranslator.regionJson.SelectTokens($"$..[?(@.province=~ /.*{vist.city}/i && @.city=~ /.*{vist.province}/i)]");
                                if (!(tokens.Any() && tokens.Count()>0))
                                {
                                    tokens= _longitudeLatitudeTranslator.regionJson.SelectTokens($"$..[?(@.province=~ /.*{vist.city}/i || @.city=~ /.*{vist.city}/i)]");
                                }
                                if (!(tokens.Any() && tokens.Count()>0))
                                {
                                    tokens= _longitudeLatitudeTranslator.regionJson.SelectTokens($"$..[?(@.province=~ /.*{vist.province}/i||@.city=~ /.*{vist.province}/i)]");
                                }
                            }

                        }
                        else if (string.IsNullOrWhiteSpace(vist.city) && !string.IsNullOrWhiteSpace(vist.province) && !string.IsNullOrWhiteSpace(vist.area))
                        {
                            if (vist.area.Equals("中国"))
                            {
                                tokens= _longitudeLatitudeTranslator.regionJson.SelectTokens($"$..[?(@.province=~ /.*{vist.province}/i)]");
                                if (!(tokens.Any() && tokens.Count()>0))
                                {
                                    tokens= _longitudeLatitudeTranslator.regionJson.SelectTokens($"$..[?(@.city=~ /.*{vist.province}/i)]");
                                }
                            }
                            else
                            {
                                tokens= _longitudeLatitudeTranslator.regionJson.SelectTokens($"$..[?(@.city=~ /.*{vist.province}/i || @.province=~ /.*{vist.province}/i)]");
                            }
                        }
                        else if (!string.IsNullOrWhiteSpace(vist.city) && string.IsNullOrWhiteSpace(vist.province)&& !string.IsNullOrWhiteSpace(vist.area))
                        {
                            if (vist.area.Equals("中国"))
                            {
                                tokens= _longitudeLatitudeTranslator.regionJson.SelectTokens($"$..[?(@.province=~ /.*{vist.city}/i)]");
                                if (!(tokens.Any() && tokens.Count()>0))
                                {
                                    tokens= _longitudeLatitudeTranslator.regionJson.SelectTokens($"$..[?(@.city=~ /.*{vist.province}/i)]");
                                }
                            }
                            else
                            {
                                tokens=  _longitudeLatitudeTranslator.regionJson.SelectTokens($"$..[?(@.city=~ /.*{vist.city}/i || @.city=~ /.*{vist.province}/i)]");
                            }
                        }
                        else if (string.IsNullOrWhiteSpace(vist.city) && string.IsNullOrWhiteSpace(vist.province)&& !string.IsNullOrWhiteSpace(vist.area))
                        {
                            tokens=  _longitudeLatitudeTranslator.regionJson.SelectTokens($"$..[?(@.country=~ /.*{vist.area}/i && @.m=='1')]");
                        }
                        if (tokens!=null &&   tokens.Any())
                        {
                            List<RegionLngLat> regionLngLats = new List<RegionLngLat>();
                            foreach (JToken token in tokens)
                            {
                                regionLngLats.Add(token.ToString().ToObject<RegionLngLat>());
                            }
                            var points = regionLngLats.FindAll(x => string.IsNullOrWhiteSpace(x.area));
                            if (!points.IsNotEmpty())
                            {
                                points= regionLngLats.FindAll(x => !string.IsNullOrWhiteSpace(x.m) && x.m.Equals("1"));
                            }

                            if (string.IsNullOrWhiteSpace(vist.city))
                            {
                                vist.city=points?.FirstOrDefault()?.city;
                                if (!string.IsNullOrWhiteSpace(vist.city)  && vist.city.EndsWith("市"))
                                {
                                    vist.city=vist.city.Replace("市", "");
                                }
                            }
                            vist.lat=points?.FirstOrDefault()?.lat;
                            vist.lng=points?.FirstOrDefault()?.lng;

                        }
                        else
                        {
                            if (vist.area.Equals("内网IP"))
                            {
                                if (vist.host.Contains(".cn") || vist.host.Contains("localhost"))
                                {
                                    vist.lat="30.655821878416408";
                                    vist.lng="104.08153351042463";
                                    vist.area="中国";
                                    vist.province="四川";
                                    vist.city="成都";
                                }
                                else
                                {
                                    vist.lat="25.044332";
                                    vist.lng="121.509062";
                                    vist.area="中国";
                                    vist.province="台湾";
                                    vist.city="台湾";
                                }

                            }
                            else
                            {
                                vist.lat="30.655821878416408";
                                vist.lng="104.08153351042463";
                                vist.area="中国";
                                vist.province="四川";
                                vist.city="成都";
                            }
                        }

                    }

                    uuidInfo.Add((uuid, log, useridMatch, schoolMatch));
                    visits.Add(vist);
                }
            }
);

            List<(string tmd, bool exists, string scope)> tmdexists = new List<(string tmd, bool exists, string scope)>();
            List<(string sch, bool exists)> schexists = new List<(string sch, bool exists)>();
            var tmds = uuidInfo.SelectMany(x => x.tmdid).ToHashSet();
            if (tmds.Any())
            {
                foreach (var tmd in tmds)

                {
                    var exists = await _azureRedis.GetRedisClient(8).KeyExistsAsync($"Blob:Catalog:{tmd}");
                    if (exists)
                    {
                        tmdexists.Add((tmd, exists, "teacher"));
                    }
                    else
                    {
                        exists = await _azureRedis.GetRedisClient(8).KeyExistsAsync($"Login:School:hbcn:student:{tmd}");
                        tmdexists.Add((tmd, exists, "student"));
                    }
                }

            }
            var schs = uuidInfo.SelectMany(x => x.school).ToHashSet();
            if (schs.Any())
            {
                foreach (var sch in schs)
                {
                    var exists = await _azureRedis.GetRedisClient(8).KeyExistsAsync($"Blob:Catalog:{sch}");
                    schexists.Add((sch, exists));
                }
            }
            foreach (var item in uuidInfo)
            {
                foreach (var tmd in item.tmdid)
                {
                    var tmdext = tmdexists.Find(x => x.tmd.Equals(tmd));
                    if (tmdext.tmd!= null  && tmdext.exists)
                    {
                        var vist = visits.Where(x => x.id.Equals(item.uuid));
                        foreach (var vi in vist)
                        {
                            vi.userId=tmd;
                            if (string.IsNullOrWhiteSpace(vi.scope))
                            {
                                vi.scope=tmdext.scope;
                            }
                        }
                        break;
                    }
                }
                foreach (var sch in item.school)
                {
                    var schext = schexists.Find(x => x.sch.Equals(sch));
                    if (schext.sch!= null  && schext.exists)
                    {
                        var vist = visits.Where(x => x.id.Equals(item.uuid));
                        foreach (var vi in vist)
                        {
                            vi.school=sch;
                        }
                        break;
                    }
                }
            }
            return (visits, uuidInfo);
        }
        public class ApiVisit
        {
            public string id { get; set; }
            public string path { get; set; }
            /// <summary>
            /// 细分
            /// ies5 ,hiteach,hita,cc,bi,contest,open,aclassone,sokrates,ability,art
            /// 产品端
            /// </summary>
            public string client { get; set; }
            /// <summary>
            /// 具体功能
            /// </summary>
           // public string func { get; set; }

            public string userId { get; set; }
            public string picture { get; set; }
            public string scope { get; set; }
            public string tname { get; set; }
            public string school { get; set; }
            public string ip { get; set; }
            //public string region { get; set; }
            public string area { get; set; }
            public string province { get; set; }
            public string city { get; set; } = "";
            public long time { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string host { get; set; }
            public string hostName { get; set; } = "其他";
            /// <summary>
            /// tokenid
            /// </summary>
            public string tid { get; set; }
            public string year { get; set; }
            public string month { get; set; }
            public string day { get; set; }
            public string hour { get; set; }
            //public RegionLngLat point { get; set; }
            public string lat { get; set; }
            public string lng { get; set; }
            public string l { get; set; }
        }

        public class HttpLog
        {
            public string ip { get; set; }
            public long time { get; set; }
            public string host { get; set; }
            public string hostName = "其他";
            public string tid { get; set; }
            public string path { get; set; }
            public string client { get; set; }
            public JsonElement param { get; set; }
            public string id { get; set; }
            public string name { get; set; }
            public string picture { get; set; }
            public string school { get; set; }
            public string p { get; set; }
            // public string ua { get; set; }
            // public string referer { get; set;  }
            public string scope { get; set; }
            public string year { get; set; }
            public string month { get; set; }
            public string day { get; set; }
            public string hour { get; set; }
            public string l { get; set; }

        }
        public record RegionLngLat
        {
            public string country { get; set; }
            public string province { get; set; }
            public string city { get; set; }
            public string lat { get; set; }
            public string lng { get; set; }
            public string area { get; set; }
            public string m { get; set; } = "0";
        }

        public class CountData
        {
            public string pk { get; set; } = "";
            public string sk { get; set; } = "";
            public string sp { get; set; } = "";
            public int count { get; set; }
        }

        public class SchoolStick
        {

            /// <summary>
            /// 名字
            /// </summary>
            public string name { get; set; }
            public string picture { get; set; }
            /// <summary>
            /// 编码
            /// </summary>
            public string id { get; set; }
            public string last { get; set; }

            #region teacher
            public ClientStick teacher { get; set; } = new ClientStick();
            #endregion
            #region student
            public ClientStick student { get; set; } = new ClientStick();
            #endregion

            #region hiteach
            public ClientStick hiteach { get; set; } = new ClientStick();
            public Indicator lesson { get; set; } = new Indicator();
            #endregion

            #region hita
            public ClientStick hita { get; set; } = new ClientStick();
            #endregion

            #region ies5Teacher
            public ClientStick ies5Tch { get; set; } = new ClientStick();
            #endregion

            #region otherTeacher

            public ClientStick otherTch { get; set; } = new ClientStick();
            #endregion

            #region ies5Student
            public ClientStick ies5Stu { get; set; } = new ClientStick();
            #endregion

            #region otherStudent
            public ClientStick otherStu { get; set; } = new ClientStick();
            #endregion

            public List<TchStick> tchSticks { get; set; } = new List<TchStick>();
            public List<StuStick> stuSticks { get; set; } = new List<StuStick>();
        }
        public class TchStick
        {
            public string school { get; set; }
            /// <summary>
            /// 名字
            /// </summary>
            public string name { get; set; }
            public string picture { get; set; }
            /// <summary>
            /// 编码
            /// </summary>
            public string id { get; set; }
            public string last { get; set; }

            #region tmd
            public ClientStick teacher { get; set; } = new ClientStick();
            #endregion


            #region hiteach
            public ClientStick hiteach { get; set; } = new ClientStick();
            public Indicator lesson { get; set; } = new Indicator();
            #endregion

            #region hita
            public ClientStick hita { get; set; } = new ClientStick();
            #endregion

            #region ies5Teacher
            public ClientStick ies5Tch { get; set; } = new ClientStick();
            #endregion

            #region otherTeacher

            public ClientStick otherTch { get; set; } = new ClientStick();
            #endregion



        }
        public class StuStick
        {
            public string school { get; set; }

            /// <summary>
            /// 名字
            /// </summary>
            public string name { get; set; }
            public string picture { get; set; }
            /// <summary>
            /// 编码
            /// </summary>
            public string id { get; set; }
            public string last { get; set; }

            #region tmd
            public ClientStick student { get; set; } = new ClientStick();
            #endregion
            #region ies5Student
            public ClientStick ies5Stu { get; set; } = new ClientStick();
            #endregion

            #region otherStudent
            public ClientStick otherStu { get; set; } = new ClientStick();
            #endregion
        }
        public class ClientStick
        {
            public int userCount { get; set; }
            public int userUpdown { get; set; }

            public Indicator stick { get; set; } = new Indicator();
            public Indicator duration { get; set; } = new Indicator();
            public Indicator count { get; set; } = new Indicator();
        }
        public class Indicator
        {
            /// <summary>
            /// 值
            /// </summary>
            public double value { get; set; } = 0;
            /// <summary>
            /// 值的增减浮动
            /// </summary>
            public double range { get; set; } = 0;
            /// <summary>
            /// 排名
            /// </summary>
            public double rank { get; set; } = 0;
            /// <summary>
            /// 排名的上升下降
            /// </summary>
            public double updown { get; set; } = 0;
        }
        public class Stick
        {
            public List<SchoolStick> schoolSticks { get; set; } = new List<SchoolStick>();
            public List<TchStick> tchSticks { get; set; } = new List<TchStick>();
        }
        public class Product
        {
            public string Name { get; set; }
            public double VisitDuration { get; set; }
            public double VisitCount { get; set; }


            public double CalculateProductIndex(double timeWeight, double countWeight,double minVisitDuration, double maxVisitDuration, double minVisitCount, double maxVisitCount) 
            {
                // 计算访问时长的Min-Max标准化值
                double standardizedVisitDuration = (maxVisitDuration - minVisitDuration)!=0?(VisitDuration - minVisitDuration) / (maxVisitDuration - minVisitDuration):0;
                // 计算访问次数的Min-Max标准化值
                double standardizedVisitCount = (maxVisitCount - minVisitCount)!=0?(VisitCount - minVisitCount) / (maxVisitCount - minVisitCount):0;
                // 计算加权综合指数
                double comprehensiveIndex = timeWeight * standardizedVisitDuration + countWeight * standardizedVisitCount;
                return Math.Round(comprehensiveIndex,4);
            }
        }
    }
}