tede/gx_api/GxPress/Repository/GxPress.Repository.Implement/Media/MediaRepository.cs

using System.Linq;
using System.Collections.Generic;
using System.Threading.Tasks;
using AutoMapper;
using Datory;
using GxPress.Common.AppOptions;
using GxPress.Common.Tools;
using GxPress.Repository.Interface.Media;
using GxPress.Result.Media;
using Microsoft.Extensions.Options;
using System.Transactions;
using GxPress.Common.Exceptions;
using GxPress.Common.Page;
using GxPress.Request.Media;
using System;
using GxPress.EnumConst;
using GxPress.Request.ArticleGroup;
using Dapper;

namespace GxPress.Repository.Implement.Media
{
    public class MediaRepository : IMediaRepository
    {
        private readonly Repository<Entity.tede2.Media.Media> _repository;
        private readonly Repository<Entity.tede2.Media.MediaLibrary> mediaLibraryRepository;
        private readonly Repository<Entity.tede2.Media.MediaLable> mediaLableRepository;
        private readonly IMapper _mapper;
        private readonly string _connectionString;
        private readonly string _databaseTypestr;
        public MediaRepository(IOptionsMonitor<DatabaseOptions> dbOptionsAccessor, IMapper mapper)
        {
            _databaseTypestr = dbOptionsAccessor.CurrentValue.DatabaseType;
            _connectionString = dbOptionsAccessor.CurrentValue.ConnectionString;
            var databaseType =
                StringUtils.ToEnum<DatabaseType>(dbOptionsAccessor.CurrentValue.DatabaseType, DatabaseType.MySql);
            var database = new Database(databaseType, dbOptionsAccessor.CurrentValue.ConnectionString);
            _repository = new Repository<Entity.tede2.Media.Media>(database);
            mediaLibraryRepository = new Repository<Entity.tede2.Media.MediaLibrary>(database);
            mediaLableRepository = new Repository<Entity.tede2.Media.MediaLable>(database);
            _mapper = mapper;
        }

        public IDatabase Database => _repository.Database;
        public string TableName => _repository.TableName;
        public List<TableColumn> TableColumns => _repository.TableColumns;

        public async Task<MediaResult> GetAsync(int id)
        {
            var result = new MediaResult();
            //获取媒体
            var media = await _repository.GetAsync(id);
            result = _mapper.Map<MediaResult>(media);
            result.ImageUrls = StringUtils.AddDomain(result.ImageUrls);
            result.CategoryId = StringUtils.StringCollectionToStringList(media.CategoryId).ToList();
            result.CategoryName = StringUtils.StringCollectionToStringList(media.CategoryName).ToList();
            result.FullCategoryId = StringUtils.StringCollectionToStringList(media.FullCategoryId).ToList();
            //获取媒体库资源
            var mediaLibrarys = await mediaLibraryRepository.GetAllAsync(Q.Where(nameof(Entity.tede2.Media.MediaLibrary.MediaId), id));
            result.MediaLibraryResults = mediaLibrarys.ToList().Select(n => _mapper.Map<MediaLibraryResult>(n)).ToList();
            foreach (var item in result.MediaLibraryResults)
            {
                item.FileUrl = StringUtils.AddDomain(item.FileUrl);
            }
            //获取媒体标签
            var mediaLables = await mediaLableRepository.GetAllAsync(Q.Where(nameof(Entity.tede2.Media.MediaLable.MediaId), id));
            result.MediaLableResults = mediaLables.Select(n => _mapper.Map<MediaLableResult>(n)).ToList();
            return result;
        }
        /// <summary>
        /// 删除媒体
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public async Task<bool> DeleteAsync(int id)
        {
            try
            {
                using (var transactionScope = new TransactionScope())
                {
                    // //删除媒体库
                    // await mediaLibraryRepository.DeleteAsync(Q.Where(nameof(Entity.tede2.Media.MediaLibrary.MediaId), id));
                    // //删除媒体标签
                    // await mediaLableRepository.DeleteAsync(Q.Where(nameof(Entity.tede2.Media.MediaLable.MediaId), id));

                    await _repository.UpdateAsync(Q.Where(nameof(Entity.tede2.Media.Media.Id), id).Set(nameof(Entity.tede2.Media.Media.IsDelete), true));
                    transactionScope.Complete();
                }
            }
            catch (System.Exception ex)
            {
                throw new BusinessException(ex.Message);
            }
            return true;
        }
        /// <summary>
        /// 添加媒体
        /// </summary>
        /// <param name="result"></param>
        /// <returns></returns>
        public async Task<bool> InsertAsync(MediaResult result)
        {
            var model = _mapper.Map<Entity.tede2.Media.Media>(result);
            model.ImageUrls = StringUtils.RemoveDomain(result.ImageUrls);
            try
            {
                using (var transactionScope = new TransactionScope())
                {
                    model.AutoNumber = SnowflakeHelper.MakeSnowflake();
                    var categoryId = "";
                    foreach (var item in result.CategoryId)
                    {
                        categoryId += item.Split(",")[item.Split(",").Length - 1] + ",";
                    }
                    categoryId = categoryId.Remove(categoryId.Length - 1, 1);
                    model.CategoryId = categoryId;
                    model.FullCategoryId = StringUtils.ObjectCollectionToString(result.CategoryId);
                    var categoryName = "";
                    foreach (var item in result.CategoryName)
                    {
                        categoryName += item.Split(",")[item.Split(",").Length - 1] + ",";
                    }
                    categoryName = categoryName.Remove(categoryName.Length - 1, 1);
                    model.CategoryName = categoryName;
                    model.IsLibrary = result.MediaLibraryResults.Count > 0;
                    var id = await _repository.InsertAsync(model);
                    if (id > 0)
                    {
                        foreach (var item in result.MediaLibraryResults)
                        {
                            var mediaLibrary = _mapper.Map<Entity.tede2.Media.MediaLibrary>(item);
                            mediaLibrary.MediaId = id;
                            mediaLibrary.FileUrl = StringUtils.RemoveDomain(item.FileUrl);
                            await mediaLibraryRepository.InsertAsync(mediaLibrary);
                        }
                    }
                    //添加标签
                    foreach (var item in result.MediaLableResults)
                    {
                        var mediaLable = _mapper.Map<Entity.tede2.Media.MediaLable>(item);
                        mediaLable.MediaId = id;
                        await mediaLableRepository.InsertAsync(mediaLable);
                    }
                    if (result.Id == 0 && result.TeacherId == 0 && !string.IsNullOrEmpty(result.Author))
                    {
                        //新增名师

                    }
                    //提交事务
                    transactionScope.Complete();
                }
            }
            catch (System.Exception ex)
            {
                throw new Common.Exceptions.BusinessException(ex.Message);
            }

            return true;
        }

        /// <summary>
        /// 获取媒体
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public async Task<MediaNoteResult> GetAsync(SqlKata.Query query)
        {
            query.Select(nameof(Entity.tede2.Media.Media.Id));
            query.Select(nameof(Entity.tede2.Media.Media.Title));
            query.Select(nameof(Entity.tede2.Media.Media.Author));
            query.Select(nameof(Entity.tede2.Media.Media.ImageUrls));
            return await _repository.GetAsync<MediaNoteResult>(query);
        }
        public async Task<bool> UpdateAsync(Entity.tede2.Media.Media note)
        {
            return await _repository.UpdateAsync(note);
        }
        public async Task<bool> UpdateAsync(SqlKata.Query query)
        {
            return await _repository.UpdateAsync(query) > 0;
        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        public async Task<PagedList<Entity.tede2.Media.Media>> GetAllAsync(MediaSearchRequest request)
        {
            var result = new PagedList<Entity.tede2.Media.Media>();
            var query = Q.NewQuery();
            if (!string.IsNullOrEmpty(request.KeyWord))
            {
                query.OrWhereLike(nameof(Entity.tede2.Media.Media.Title), $"%{request.KeyWord}%");
                query.OrWhereLike(nameof(Entity.tede2.Media.Media.Creator), $"%{request.KeyWord}%");
            }
            if (request.IsDelete > 0)
                query.Where(nameof(Entity.tede2.Media.Media.IsDelete), request.IsDelete == 1);
            if (request.MediaType > 0)
                query.Where(nameof(Entity.tede2.Media.Media.MediaType), request.MediaType);
            if (request.LibraryType > 0)
                query.Where(nameof(Entity.tede2.Media.Media.IsLibrary), request.LibraryType == 1);
            if (!string.IsNullOrEmpty(request.BeginTime) && !string.IsNullOrEmpty(request.EndTime))
            {
                if (DateTime.TryParse(request.BeginTime, out var beginTime) && DateTime.TryParse(request.EndTime, out var endTime))
                {
                    query.WhereDate(nameof(Entity.tede2.Media.Media.CreatedDate), ">=", beginTime);
                    query.WhereDate(nameof(Entity.tede2.Media.Media.CreatedDate), "<=", endTime);
                }
            }
            if (request.IsChecked > 0)
                query.Where(nameof(Entity.tede2.Media.Media.IsChecked), request.IsChecked == 1);
            result.Total = await _repository.CountAsync(query);
            //排序
            if (string.IsNullOrEmpty(request.Sort))
                query.OrderByDesc(nameof(Entity.tede2.Media.Media.CreatedDate));
            else if (request.Sort.Equals("SellAmount"))
                query.OrderByDesc(nameof(Entity.tede2.Media.Media.SellAmount));
            else if (request.Sort.Equals("ReadCount"))
                query.OrderByDesc(nameof(Entity.tede2.Media.Media.ReadCount));
            var item = await _repository.GetAllAsync(query.ForPage(request.Page, request.PerPage));
            result.Items = item;
            return result;
        }

        /// <summary>
        /// 根据IDs
        /// </summary>
        /// <returns></returns>
        public async Task<IEnumerable<MediaCathedraResult>> GetMediaByLableIdsAsync(MediaIdsRequest request)
        {
            if (request.Ids.Count > 0)
            {
                var str = "";
                foreach (var item in request.Ids)
                    str += item + ",";
                str = str.Remove(str.Length - 1, 1);
                var sql = $@"SELECT 
                            Id,ImageUrls,Title,Author,MediaType,ReadCount,CreatedDate
                        FROM
                            tede_media
                        WHERE
                            id IN ({str})
                        ORDER BY RAND() LIMIT {request.Limit}";

                var databaseType = _databaseTypestr.ToEnum<DatabaseType>(DatabaseType.MySql);
                var database = new Database(databaseType, _connectionString);
                var connection = database.GetConnection();
                return await connection.QueryAsync<MediaCathedraResult>(sql);
            }
            return null;
        }
        /// <summary>
        /// 根据IDs
        /// </summary>
        /// <returns></returns>
        public async Task<PagedList<MediaCathedraResult>> GetMediaByLableIdAsync(MediaLableIdRequest request)
        {
            var result = new PagedList<MediaCathedraResult>();
            if (request.Ids.Count > 0)
            {
                var str = "";
                foreach (var item in request.Ids)
                    str += item + ",";
                str = str.Remove(str.Length - 1, 1);
                var sql = $@"SELECT 
                            Id,ImageUrls,Title,Author,MediaType,ReadCount,CreatedDate
                        FROM
                            tede_media
                        WHERE
                            id IN ({str})
                        ORDER BY CreatedDate desc  LIMIT {(request.Page - 1) * request.PerPage},{request.PerPage}";

                var databaseType = _databaseTypestr.ToEnum<DatabaseType>(DatabaseType.MySql);
                var database = new Database(databaseType, _connectionString);
                var connection = database.GetConnection();
                result.Items = await connection.QueryAsync<MediaCathedraResult>(sql);
                sql = $@"SELECT  count(1) FROM tede_media WHERE id IN ({str})";
                result.Total = await connection.ExecuteScalarAsync<int>(sql);
            }
            return result;
        }
        public async Task<bool> UpdateAsync(MediaResult result)
        {
            //var model = _mapper.Map<Entity.tede2.Media.Media>(result);
            try
            {
                using (var transactionScope = new TransactionScope())
                {
                    var model = await _repository.GetAsync(result.Id);
                    if (result.CategoryId != null && result.CategoryId.Count > 0)
                    {
                        var categoryId = "";
                        foreach (var item in result.CategoryId)
                            categoryId += item.Split(",")[item.Split(",").Length - 1] + ",";
                        categoryId = categoryId.Remove(categoryId.Length - 1, 1);
                        model.CategoryId = categoryId;
                        model.FullCategoryId = StringUtils.ObjectCollectionToString(result.CategoryId);
                    }
                    if (result.CategoryName != null && result.CategoryName.Count > 0)
                    {
                        var categoryName = "";
                        foreach (var item in result.CategoryName)
                            categoryName += item.Split(",")[item.Split(",").Length - 1] + ",";
                        categoryName = categoryName.Remove(categoryName.Length - 1, 1);
                        model.CategoryName = categoryName;
                    }
                    if (result.AdminId > 0)
                        model.AdminId = result.AdminId;
                    if (!string.IsNullOrEmpty(result.Creator))
                        model.Creator = result.Creator;
                    if (result.MediaType > 0)
                        model.MediaType = result.MediaType;
                    if (!string.IsNullOrEmpty(result.Title))
                        model.Title = result.Title;
                    if (!string.IsNullOrEmpty(result.ImageUrls))
                        model.ImageUrls = result.ImageUrls;
                    if (!string.IsNullOrEmpty(result.Summary))
                        model.Summary = result.Summary;
                    if (!string.IsNullOrEmpty(result.Author))
                        model.Author = result.Author;
                    if (result.TeacherId > 0)
                        model.TeacherId = result.TeacherId;
                    if (!string.IsNullOrEmpty(result.Source))
                        model.Source = result.Source;
                    if (!string.IsNullOrEmpty(result.Blocks))
                        model.Blocks = result.Blocks;
                    if (result.IsChecked > 0)
                        model.IsChecked = result.IsChecked == 1;
                    if (!string.IsNullOrEmpty(result.AddDate))
                        model.AddDate = Convert.ToDateTime(result.AddDate);
                    if (model.Sort > 0)
                        model.Sort = result.Sort;
                    if (model.ReadCount > 0)
                        model.ReadCount = result.ReadCount;
                    if (result.IsTop > 0)
                        model.IsTop = result.IsTop == 1;
                    if (result.LableId > 0)
                        model.LableId = result.LableId;
                    if (result.IsRecommend > 0)
                        model.IsRecommend = result.IsRecommend == 1;
                    if (!string.IsNullOrEmpty(result.Press))
                        model.Press = result.Press;
                    if (!string.IsNullOrEmpty(result.PublishTime))
                        model.PublishTime = result.PublishTime;
                    if (result.IosDiscountPrice > 0)
                        model.IosDiscountPrice = result.IosDiscountPrice;
                    if (result.IosPrice > 0)
                        model.IosPrice = result.IosPrice;
                    if (result.OtherDiscountPrice > 0)
                        model.OtherDiscountPrice = result.OtherDiscountPrice;
                    if (result.OtherPrice > 0)
                        model.OtherPrice = result.OtherPrice;
                    if (result.FreeProportion > 0)
                        model.FreeProportion = result.FreeProportion;
                    if (result.AttachType > 0)
                        model.AttachType = result.AttachType;
                    if (result.AttachId > 0)
                        model.AttachId = result.AttachId;
                    if (result.MediaId > 0)
                        model.MediaId = result.MediaId;
                    if (!string.IsNullOrEmpty(result.MediaTitle))
                        model.MediaTitle = result.MediaTitle;
                    if (!string.IsNullOrEmpty(result.JournalsYear))
                        model.JournalsYear = result.JournalsYear;
                    if (result.JournalsCategory > 0)
                        model.JournalsCategory = result.JournalsCategory;
                    if (result.IsExercises > 0)
                        model.IsExercises = result.IsExercises == 1;
                    if (result.AppCategoryId > 0)
                        model.AppCategoryId = result.AppCategoryId;
                    await _repository.UpdateAsync(model);
                    if (result.MediaLibraryResults != null && result.MediaLibraryResults.Count > 0)
                    {
                        model.IsLibrary = result.MediaLibraryResults.Count > 0;
                        //删除媒体库
                        await mediaLibraryRepository.DeleteAsync(Q.Where(nameof(Entity.tede2.Media.MediaLibrary.MediaId), result.Id));
                        foreach (var item in result.MediaLibraryResults)
                        {
                            var mediaLibrary = _mapper.Map<Entity.tede2.Media.MediaLibrary>(item);
                            mediaLibrary.MediaId = result.Id;
                            mediaLibrary.FileUrl = StringUtils.RemoveDomain(mediaLibrary.FileUrl);
                            await mediaLibraryRepository.InsertAsync(mediaLibrary);
                        }
                    }
                    if (result.MediaLableResults != null && result.MediaLableResults.Count > 0)
                    {
                        //删除媒体标签
                        await mediaLableRepository.DeleteAsync(Q.Where(nameof(Entity.tede2.Media.MediaLable.MediaId), result.Id));
                        //添加标签
                        foreach (var item in result.MediaLableResults)
                        {
                            var mediaLable = _mapper.Map<Entity.tede2.Media.MediaLable>(item);
                            mediaLable.MediaId = result.Id;
                            await mediaLableRepository.InsertAsync(mediaLable);
                        }
                    }
                    //提交事务
                    transactionScope.Complete();
                }
            }
            catch (System.Exception ex)
            {
                throw new Common.Exceptions.BusinessException(ex.Message);
            }

            return true;
        }
        public async Task<int> CountAsync(string beginTime, string endTime)
        {
            return await _repository.CountAsync(Q.WhereDate(nameof(Entity.tede2.Media.Media.CreatedDate), ">=", beginTime).WhereDate(nameof(Entity.tede2.Media.Media.CreatedDate), "<=", endTime));
        }
        public async Task<int> CountAsync(SqlKata.Query query)
        {
            return await _repository.CountAsync(query);
        }

        public async Task<Entity.tede2.Media.Media> GetAsync(string autoNumber)
        {
            return await _repository.GetAsync(Q.Where(nameof(Entity.tede2.Media.Media.AutoNumber), autoNumber));
        }

        /// <summary>
        /// 获取书籍
        /// </summary>
        /// <param name="mediaId"></param>
        /// <returns></returns>
        public async Task<BookMediaResult> GetBookMediaResultAsync(int mediaId)
        {
            var result = await _repository.GetAsync(Q.Where(nameof(Entity.tede2.Media.Media.Id), mediaId).Where(nameof(Entity.tede2.Media.Media.IsChecked), true).Where(nameof(Entity.tede2.Media.Media.IsDelete), false));
            return _mapper.Map<BookMediaResult>(result);
        }
        /// <summary>
        /// 获取视频
        /// </summary>
        /// <param name="mediaId"></param>
        /// <returns></returns>
        public async Task<VideoMediaResult> GetVideoMediaResultAsync(int mediaId)
        {
            var result = await _repository.GetAsync(Q.Where(nameof(Entity.tede2.Media.Media.Id), mediaId).Where(nameof(Entity.tede2.Media.Media.IsChecked), true).Where(nameof(Entity.tede2.Media.Media.IsDelete), false));
            return _mapper.Map<VideoMediaResult>(result);
        }
        /// <summary>
        /// 根据
        /// </summary>
        /// <param name="mediaIds"></param>
        /// <returns></returns>
        public async Task<IEnumerable<NavigationMediaResult>> GetNavigationMediaResults(IEnumerable<int> mediaIds, int page = 1, int pageSize = 10)
        {
            //获取媒体
            var query = Q.NewQuery();
            query.Select(nameof(Entity.tede2.Media.Media.Id));
            query.Select(nameof(Entity.tede2.Media.Media.ImageUrls));
            query.Select(nameof(Entity.tede2.Media.Media.Title));
            query.Select(nameof(Entity.tede2.Media.Media.Summary));
            query.Select(nameof(Entity.tede2.Media.Media.TeacherId));
            query.Select(nameof(Entity.tede2.Media.Media.AutoNumber));
            query.Select(nameof(Entity.tede2.Media.Media.Author));
            query.Select(nameof(Entity.tede2.Media.Media.MediaType));
            query.Select(nameof(Entity.tede2.Media.Media.ReadCount));
            query.Select(nameof(Entity.tede2.Media.Media.CreatedDate));
            query.Select(nameof(Entity.tede2.Media.Media.CollectCount));
            query.WhereIn(nameof(Entity.tede2.Media.Media.Id), mediaIds);
            query.Where(nameof(Entity.tede2.Media.Media.IsChecked), true);
            query.Where(nameof(Entity.tede2.Media.Media.IsDelete), false);
            query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsTop));
            query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsRecommend));
            query.OrderByDesc(nameof(Entity.tede2.Media.Media.LastModifiedDate));
            query.ForPage(page, pageSize);
            return await _repository.GetAllAsync<NavigationMediaResult>(query);
        }
        /// <summary>
        /// 猜你喜欢
        /// </summary>
        /// <param name="mediaIds"></param>
        /// <returns></returns>
        public async Task<IEnumerable<NavigationMediaResult>> GetlikeMediaResults()
        {
            //获取媒体
            var query = Q.NewQuery();
            query.Select(nameof(Entity.tede2.Media.Media.Id));
            query.Select(nameof(Entity.tede2.Media.Media.ImageUrls));
            query.Select(nameof(Entity.tede2.Media.Media.Title));
            query.Select(nameof(Entity.tede2.Media.Media.Summary));
            query.Select(nameof(Entity.tede2.Media.Media.TeacherId));
            query.Select(nameof(Entity.tede2.Media.Media.AutoNumber));
            query.Select(nameof(Entity.tede2.Media.Media.Author));
            query.Select(nameof(Entity.tede2.Media.Media.MediaType));
            query.Where(nameof(Entity.tede2.Media.Media.IsTop), true);
            query.Where(nameof(Entity.tede2.Media.Media.IsChecked), true);
            query.Where(nameof(Entity.tede2.Media.Media.IsDelete), false);
            query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsTop));
            query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsRecommend));
            query.ForPage(1, 10);
            return await _repository.GetAllAsync<NavigationMediaResult>(query);
        }
        /// <summary>
        /// 推荐
        /// </summary>
        /// <param name="mediaIds"></param>
        /// <returns></returns>
        public async Task<IEnumerable<NavigationMediaResult>> GetRecommendMediaResults()
        {
            //获取媒体
            var query = Q.NewQuery();
            query.Select(nameof(Entity.tede2.Media.Media.Id));
            query.Select(nameof(Entity.tede2.Media.Media.ImageUrls));
            query.Select(nameof(Entity.tede2.Media.Media.Title));
            query.Select(nameof(Entity.tede2.Media.Media.Summary));
            query.Select(nameof(Entity.tede2.Media.Media.TeacherId));
            query.Select(nameof(Entity.tede2.Media.Media.AutoNumber));
            query.Select(nameof(Entity.tede2.Media.Media.Author));
            query.Select(nameof(Entity.tede2.Media.Media.MediaType));
            query.Where(nameof(Entity.tede2.Media.Media.IsRecommend), true);
            query.Where(nameof(Entity.tede2.Media.Media.IsChecked), true);
            query.Where(nameof(Entity.tede2.Media.Media.IsDelete), false);
            query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsTop));
            query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsRecommend));
            query.ForPage(1, 10);
            return await _repository.GetAllAsync<NavigationMediaResult>(query);
        }
        /// <summary>
        /// 排行榜
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        public async Task<IEnumerable<RankingListResult>> GetRankingListResults(RankingListRequest request)
        {
            //获取媒体
            var query = Q.NewQuery();
            query.Select(nameof(Entity.tede2.Media.Media.Id));
            query.Select(nameof(Entity.tede2.Media.Media.ImageUrls));
            query.Select(nameof(Entity.tede2.Media.Media.Title));
            query.Select(nameof(Entity.tede2.Media.Media.Summary));
            query.Select(nameof(Entity.tede2.Media.Media.TeacherId));
            query.Select(nameof(Entity.tede2.Media.Media.AutoNumber));
            query.Select(nameof(Entity.tede2.Media.Media.Author));
            query.Select(nameof(Entity.tede2.Media.Media.MediaType));
            query.Select(nameof(Entity.tede2.Media.Media.Summary));
            query.Select(nameof(Entity.tede2.Media.Media.CommentScore));
            query.Select(nameof(Entity.tede2.Media.Media.CreatedDate));
            query.Select(nameof(Entity.tede2.Media.Media.ReadCount));
            //1 热搜 2热书榜 3 课程榜 4Top 100 新书 5文献头条  6试听榜 7大众热评 8Top 100 专著
            if (request.DataTypeValue > 0)
            {
                //1 热搜
                if (request.DataTypeValue == RankingListConst.HotSearch.GetHashCode())
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.ReadCount));
                //2热书榜
                if (request.DataTypeValue == RankingListConst.ReadBook.GetHashCode())
                {
                    query.Where(nameof(Entity.tede2.Media.Media.MediaType), ResourceTypeConst.Book.GetHashCode());
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.ReadCount));
                }
                //3 课程榜
                if (request.DataTypeValue == RankingListConst.Article.GetHashCode())
                {
                    query.Where(nameof(Entity.tede2.Media.Media.MediaType), ResourceTypeConst.Article.GetHashCode());
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.ReadCount));
                }
                //Top 100 新书
                if (request.DataTypeValue == RankingListConst.NewBook.GetHashCode())
                {
                    query.Where(nameof(Entity.tede2.Media.Media.MediaType), ResourceTypeConst.Book.GetHashCode());
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.CreatedDate));
                }
                //文献头条
                if (request.DataTypeValue == RankingListConst.ArticleTop.GetHashCode())
                {
                    query.Where(nameof(Entity.tede2.Media.Media.MediaType), ResourceTypeConst.Article.GetHashCode());
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsTop));
                }
                if (request.DataTypeValue == RankingListConst.Audio.GetHashCode())
                {
                    query.Where(nameof(Entity.tede2.Media.Media.MediaType), ResourceTypeConst.Audio.GetHashCode());
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.ReadCount));
                }
                if (request.DataTypeValue == RankingListConst.HotComment.GetHashCode())
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.CommentScore));
                if (request.DataTypeValue == RankingListConst.CollectionBook.GetHashCode())
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.CollectCount));
            }
            query.Where(nameof(Entity.tede2.Media.Media.IsChecked), true);
            query.Where(nameof(Entity.tede2.Media.Media.IsDelete), false);
            query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsTop));
            query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsRecommend));
            query.ForPage(request.Page, request.PerPage);
            return await _repository.GetAllAsync<RankingListResult>(query);
        }
        /// <summary>
        /// 排行榜分页
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        public async Task<PagedList<RankingListResult>> GetRankingPageListResults(RankingListRequest request)
        {
            var result = new PagedList<RankingListResult>();
            //获取媒体
            var query = Q.NewQuery();
            query.Select(nameof(Entity.tede2.Media.Media.Id));
            query.Select(nameof(Entity.tede2.Media.Media.ImageUrls));
            query.Select(nameof(Entity.tede2.Media.Media.Title));
            query.Select(nameof(Entity.tede2.Media.Media.Summary));
            query.Select(nameof(Entity.tede2.Media.Media.TeacherId));
            query.Select(nameof(Entity.tede2.Media.Media.AutoNumber));
            query.Select(nameof(Entity.tede2.Media.Media.Author));
            query.Select(nameof(Entity.tede2.Media.Media.MediaType));
            query.Select(nameof(Entity.tede2.Media.Media.Summary));
            query.Select(nameof(Entity.tede2.Media.Media.CommentScore));
            query.Select(nameof(Entity.tede2.Media.Media.CreatedDate));
            query.Select(nameof(Entity.tede2.Media.Media.ReadCount));
            if (!string.IsNullOrEmpty(request.KeyWord))
                query.WhereLike(nameof(Entity.tede2.Media.Media.Title), $"%{request.KeyWord}%");
            //1 热搜 2热书榜 3 课程榜 4Top 100 新书 5文献头条  6试听榜 7大众热评 8Top 100 专著
            if (request.DataTypeValue > 0)
            {
                //1 热搜
                if (request.DataTypeValue == RankingListConst.HotSearch.GetHashCode())
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.ReadCount));
                //2热书榜
                if (request.DataTypeValue == RankingListConst.ReadBook.GetHashCode())
                {
                    query.Where(nameof(Entity.tede2.Media.Media.MediaType), ResourceTypeConst.Book.GetHashCode());
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.ReadCount));
                }
                //3 课程榜
                if (request.DataTypeValue == RankingListConst.Article.GetHashCode())
                {
                    query.Where(nameof(Entity.tede2.Media.Media.MediaType), ResourceTypeConst.Article.GetHashCode());
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.ReadCount));
                }
                //Top 100 新书
                if (request.DataTypeValue == RankingListConst.NewBook.GetHashCode())
                {
                    query.Where(nameof(Entity.tede2.Media.Media.MediaType), ResourceTypeConst.Book.GetHashCode());
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.CreatedDate));
                }
                //文献头条
                if (request.DataTypeValue == RankingListConst.ArticleTop.GetHashCode())
                {
                    query.Where(nameof(Entity.tede2.Media.Media.MediaType), ResourceTypeConst.Article.GetHashCode());
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsTop));
                }
                if (request.DataTypeValue == RankingListConst.Audio.GetHashCode())
                {
                    query.Where(nameof(Entity.tede2.Media.Media.MediaType), ResourceTypeConst.Audio.GetHashCode());
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.ReadCount));
                }
                if (request.DataTypeValue == RankingListConst.HotComment.GetHashCode())
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.CommentScore));
                if (request.DataTypeValue == RankingListConst.CollectionBook.GetHashCode())
                    query.OrderByDesc(nameof(Entity.tede2.Media.Media.CollectCount));
            }
            query.Where(nameof(Entity.tede2.Media.Media.IsChecked), true);
            query.Where(nameof(Entity.tede2.Media.Media.IsDelete), false);
            result.Total = await _repository.CountAsync(query);
            query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsTop));
            query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsRecommend));
            query.ForPage(request.Page, request.PerPage);
            result.Items = await _repository.GetAllAsync<RankingListResult>(query);
            return result;
        }
        /// <summary>
        /// 大咖讲座
        /// </summary>
        /// <returns></returns>
        public async Task<IEnumerable<MediaCathedraResult>> GetMediasByTeacherAsync(ArticleGroupRequest request)
        {
            var query = Q.NewQuery();
            query.Select(nameof(Entity.tede2.Media.Media.Id));
            query.Select(nameof(Entity.tede2.Media.Media.ImageUrls));
            query.Select(nameof(Entity.tede2.Media.Media.Title));
            query.Select(nameof(Entity.tede2.Media.Media.Author));
            query.Select(nameof(Entity.tede2.Media.Media.MediaType));
            query.Select(nameof(Entity.tede2.Media.Media.ReadCount));
            query.Select(nameof(Entity.tede2.Media.Media.CreatedDate));
            query.Where(nameof(Entity.tede2.Media.Media.TeacherId), ">", 0);
            query.Where(nameof(Entity.tede2.Media.Media.MediaType), GxPress.EnumConst.AllTypeConst.Video.GetHashCode());
            if (!string.IsNullOrEmpty(request.Sort))
            {
                query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsTop));
                query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsRecommend));
            }
            else
                query.OrderByDesc(nameof(Entity.tede2.Media.Media.CreatedDate));
            query.ForPage(request.Page, request.PerPage);
            return await _repository.GetAllAsync<MediaCathedraResult>(query);
        }
        /// <summary>
        /// 大咖讲座
        /// </summary>
        /// <returns></returns>
        public async Task<int> GetMediasByTeacherCountAsync(ArticleGroupRequest request)
        {
            var query = Q.NewQuery();
            query.Where(nameof(Entity.tede2.Media.Media.TeacherId), ">", 0);
            query.Where(nameof(Entity.tede2.Media.Media.MediaType), GxPress.EnumConst.AllTypeConst.Video.GetHashCode());
            return await _repository.CountAsync(query);
        }

        /// <summary>
        /// 每日技能分页
        /// </summary>
        /// <returns></returns>
        public async Task<PagedList<MediaCathedraResult>> GetDaySkillsAsync(MediaDayWeBookRequest request)
        {
            var resut = new PagedList<MediaCathedraResult>();
            var query = Q.NewQuery();
            query.Select(nameof(Entity.tede2.Media.Media.Id));
            query.Select(nameof(Entity.tede2.Media.Media.ImageUrls));
            query.Select(nameof(Entity.tede2.Media.Media.Title));
            query.Select(nameof(Entity.tede2.Media.Media.Author));
            query.Select(nameof(Entity.tede2.Media.Media.MediaType));
            query.Select(nameof(Entity.tede2.Media.Media.ReadCount));
            query.Select(nameof(Entity.tede2.Media.Media.CreatedDate));
            query.Where(nameof(Entity.tede2.Media.Media.IsExercises), true);
            query.Where(nameof(Entity.tede2.Media.Media.MediaType), request.TypeValue);
            resut.Total = await _repository.CountAsync(query);
            if (!string.IsNullOrEmpty(request.Sort))
            {
                query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsTop));
                query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsRecommend));
            }
            else
                query.OrderByDesc(nameof(Entity.tede2.Media.Media.CreatedDate));
            query.ForPage(request.Page, request.PerPage);
            resut.Items = await _repository.GetAllAsync<MediaCathedraResult>(query);
            return resut;
        }

        /// <summary>
        /// 每日技能
        /// </summary>
        /// <returns></returns>
        public async Task<SkillInfo> GetRandomDaySkillAsync()
        {
            var sql = $@"SELECT 
                            Id,Blocks,MediaType
                        FROM
                            tede_media where IsExercises=1 and MediaType={AllTypeConst.Article.GetHashCode()}
                        ORDER BY RAND() LIMIT 1";
            var databaseType = _databaseTypestr.ToEnum<DatabaseType>(DatabaseType.MySql);
            var database = new Database(databaseType, _connectionString);
            var connection = database.GetConnection();
            return await connection.QueryFirstOrDefaultAsync<SkillInfo>(sql);
        }
        /// <summary>
        /// 猜你喜欢
        /// </summary>
        /// <returns></returns>
        public async Task<IEnumerable<MediaCathedraResult>> GetUserLikeAsync()
        {
            var sql = $@"SELECT 
                            Id,ImageUrls,Title,Author,MediaType,ReadCount,CreatedDate
                        FROM
                            tede_media where IsChecked=1 and MediaType={AllTypeConst.Book.GetHashCode()}
                        ORDER BY RAND() LIMIT 3";
            var databaseType = _databaseTypestr.ToEnum<DatabaseType>(DatabaseType.MySql);
            var database = new Database(databaseType, _connectionString);
            var connection = database.GetConnection();
            return await connection.QueryAsync<MediaCathedraResult>(sql);
        }

        /// <summary>
        /// 导航内容
        /// </summary>
        /// <returns></returns>
        public async Task<PagedList<MediaCathedraResult>> GetContentNavigationAsync(MediaContentNavigationRequest request)
        {
            var resut = new PagedList<MediaCathedraResult>();
            var query = Q.NewQuery();
            query.Select(nameof(Entity.tede2.Media.Media.Id));
            query.Select(nameof(Entity.tede2.Media.Media.ImageUrls));
            query.Select(nameof(Entity.tede2.Media.Media.Title));
            query.Select(nameof(Entity.tede2.Media.Media.Author));
            query.Select(nameof(Entity.tede2.Media.Media.MediaType));
            query.Select(nameof(Entity.tede2.Media.Media.ReadCount));
            query.Select(nameof(Entity.tede2.Media.Media.CreatedDate));
            query.Where(nameof(Entity.tede2.Media.Media.MediaType), GxPress.EnumConst.AllTypeConst.Book.GetHashCode());
            if (request.MediaIds.Count() > 0)
                query.WhereIn(nameof(Entity.tede2.Media.Media.Id), request.MediaIds);
            resut.Total = await _repository.CountAsync(query);
            if (!string.IsNullOrEmpty(request.Sort))
            {
                query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsTop));
                query.OrderByDesc(nameof(Entity.tede2.Media.Media.IsRecommend));
            }
            else
                query.OrderByDesc(nameof(Entity.tede2.Media.Media.CreatedDate));
            query.ForPage(request.Page, request.PerPage);
            resut.Items = await _repository.GetAllAsync<MediaCathedraResult>(query);
            return resut;
        }
    }
}