// Admin.NET 项目的版权、商标、专利和其他相关权利均受相应法律法规的保护。使用本项目应遵守相关法律法规和许可证的要求。
//
// 本项目主要遵循 MIT 许可证和 Apache 许可证（版本 2.0）进行分发和使用。许可证位于源代码树根目录中的 LICENSE-MIT 和 LICENSE-APACHE 文件。
//
// 不得利用本项目从事危害国家安全、扰乱社会秩序、侵犯他人合法权益等法律法规禁止的活动！任何基于本项目二次开发而产生的一切法律纠纷和责任，我们不承担任何责任！

using Admin.NET.Core.Service;
using Microsoft.AspNetCore.Http;

using Furion.DatabaseAccessor;
using Furion.FriendlyException;
using Mapster;
using SqlSugar;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using Microsoft.AspNetCore.Mvc;
using Admin.NET.Application;
using Admin.NET.Core;
using FZCZTB.NET.MD;
using Furion.DynamicApiController;
using Furion.DependencyInjection;
using System.Collections.Generic;
using System.Linq;
using NewLife.Xml;
using AngleSharp.Dom;
using DocumentFormat.OpenXml.Office2010.ExcelAc;
using Furion;
using System.Security.Claims;
using Microsoft.AspNetCore.Authorization;
using RazorEngine.Compilation.ImpromptuInterface;
using MimeKit;
using static FZCZTB.TSCL.Application.ChangeTenderOrderOut;
using FZFCGDD.ORDER.Application.Service.Neirongfabu.Dto;
namespace FZCZTB.TSCL.Application;

/// <summary>
/// 内容发布接口 🧩
/// </summary>
[ApiDescriptionSettings(ApplicationConst.GroupNameDD, Order = 100)]
public class NeirongfabuService : IDynamicApiController, ITransient
{
    private readonly SqlSugarRepository<SysDictData> _sysDictDataRep;
    private readonly SqlSugarRepository<Neirongfabu> _neirongfabu;
    private readonly ISqlSugarClient _sqlSugarClient;

    public NeirongfabuService(SqlSugarRepository<SysDictData> sysDictDataRep
     , SqlSugarRepository<Neirongfabu> neirongfabu
        , ISqlSugarClient sqlSugarClient)
    {
      
        _sysDictDataRep = sysDictDataRep;
        _neirongfabu = neirongfabu;
        _sqlSugarClient = sqlSugarClient;


    }


    /// <summary>
    /// 获取内容类型集合 🔖
    /// </summary>
    /// <returns></returns>
    [DisplayName("获取内容类型集合")]
    [ApiDescriptionSettings(Name = "GetLeirongneixingList"), HttpGet]
    [AllowAnonymous]
    public async Task<List<SysDictData>> GetLeirongneixingList()
    {
        return await GetDataListByCode("Leirongneixing");
    }


    /// <summary>
    /// 获取字典值集合 🔖
    /// </summary>
    /// <param name="typeId"></param>
    /// <param name="code"></param>
    /// <returns></returns>
    [NonAction]
    public async Task<List<SysDictData>> GetDataListByCode(string code)
    {
        if (string.IsNullOrWhiteSpace(code))
            throw Oops.Oh(ErrorCodeEnum.D3011);

        var dictType = await _sysDictDataRep.Change<SysDictType>().AsQueryable()
            .Where(u => u.Status == StatusEnum.Enable)
            .WhereIF(!string.IsNullOrWhiteSpace(code), u => u.Code == code)
            .FirstAsync();
        if (dictType == null) return null;



        var dictDataList = await _sysDictDataRep.AsQueryable()
                    .Where(u => u.DictTypeId == dictType.Id)
                    .Where(u => u.Status == StatusEnum.Enable)
                    .OrderBy(u => new { u.OrderNo, u.Value, u.Code })
                    .ToListAsync();
        return dictDataList;
    }



    /// <summary>
    /// 分页查询内容发布 🔖
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [DisplayName("分页查询内容发布")]
    [ApiDescriptionSettings(Name = "Page"), HttpPost]
    public async Task<SqlSugarPagedList<NeirongfabuOutput>> Page(PageNeirongfabuInput input)
    {
        long userId = 0;
        long.TryParse(App.User?.FindFirst(ClaimConst.UserId)?.Value, out userId);

        var query = _neirongfabu.AsQueryable()
                        .WhereIF(input.CreateDateRange != null && input.CreateDateRange.Length == 2, u => u.FabuDate >= input.CreateDateRange[0] && u.FabuDate <= input.CreateDateRange[1])
              .WhereIF(input.Leirongneixing.HasValue, u => u.Leirongneixing == input.Leirongneixing)
                        .WhereIF(!string.IsNullOrWhiteSpace(input.NeirongTittle), u => u.NeirongTittle.Contains(input.NeirongTittle.Trim()))


            .Select(x => new NeirongfabuOutput
            {
                Id = x.Id,
                Leirongneixing = x.Leirongneixing,
                IsFabu = x.IsFabu,
                IsShouyexianshi = x.IsShouyexianshi,
                NeirongTittle = x.NeirongTittle,
                Fengmiantupian = x.Fengmiantupian,
                Sort = x.Sort,
                FabuDate = x.FabuDate,
                NeirongZhaiyao = x.NeirongZhaiyao,
                // NeirongMiaoshu = x.NeirongMiaoshu,
                CreateTime = x.CreateTime,
                UpdateTime = x.UpdateTime,
                CreateUserId = x.CreateUserId,
                CreateUserName = x.CreateUserName,
                UpdateUserId = x.UpdateUserId,
                UpdateUserName = x.UpdateUserName,
            });

        var pagedList = await query.OrderBuilder(input, "", "Sort", false).ToPagedListAsync(input.Page, input.PageSize);

        var sysDictDatas = await GetDataListByCode("Leirongneixing");

        foreach (var neirongfabuOutput in pagedList.Items)
        {
            var sysDictData = sysDictDatas.Where(x => x.Value == neirongfabuOutput.Leirongneixing.Value.ToString()).FirstOrDefault();
            if (sysDictData != null)
            {
                neirongfabuOutput.LeirongneixingName = sysDictData.Label;
            }

            if(neirongfabuOutput.IsFabu.HasValue && neirongfabuOutput.IsFabu.Value)
            {
                neirongfabuOutput.IsFabuName = "是";
            }
            else
            {
                neirongfabuOutput.IsFabuName = "否";
            }

            if (neirongfabuOutput.IsShouyexianshi.HasValue && neirongfabuOutput.IsShouyexianshi.Value)
            {
                neirongfabuOutput.IsShouyexianshiName = "是";
            }
            else
            {
                neirongfabuOutput.IsShouyexianshiName = "否";
            }
        }

        return pagedList;
    }

    /// <summary>
    /// 获取内容发布详情 ℹ️
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [DisplayName("获取内容发布详情")]
    [ApiDescriptionSettings(Name = "Detail"), HttpGet]
    public async Task<NeirongfabuOutput> Detail([FromQuery] QueryByIdTenderOrderInput input)
    {
        var Leirongneixing = await GetDataListByCode("Leirongneixing");
        
        var neirongfabuOutput = await _neirongfabu.AsQueryable().Where(x => x.Id == input.Id).Select<NeirongfabuOutput>().FirstAsync();
        if (neirongfabuOutput != null)
        {
            
            if (neirongfabuOutput.Leirongneixing.HasValue)
            {
                neirongfabuOutput.LeirongneixingName = Leirongneixing.Where(x => x.Value == neirongfabuOutput.Leirongneixing.Value.ToString()).Select(x => x.Label).FirstOrDefault() ?? "";
            }
            if (neirongfabuOutput.IsFabu.HasValue && neirongfabuOutput.IsFabu.Value)
            {
                neirongfabuOutput.IsFabuName = "是";
            }
            else
            {
                neirongfabuOutput.IsFabuName = "否";
            }

            if (neirongfabuOutput.IsShouyexianshi.HasValue && neirongfabuOutput.IsShouyexianshi.Value)
            {
                neirongfabuOutput.IsShouyexianshiName = "是";
            }
            else
            {
                neirongfabuOutput.IsShouyexianshiName = "否";
            }
        }
 


        return neirongfabuOutput;
    }

    /// <summary>
    /// 新增内容发布 ➕
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [DisplayName("新增内容发布")]
    [ApiDescriptionSettings(Name = "Add"), HttpPost]
    public async Task<bool> Add(NeirongfabuInput input)
    {
        var entity = input.Adapt<Neirongfabu>();
        entity.Id = Guid.NewGuid();
        long userId = 0;
        long? usertrueId = null;
        if (long.TryParse(App.User?.FindFirst(ClaimConst.UserId)?.Value, out userId))
        {
            usertrueId = userId;
        }
        var RealName = App.User?.FindFirstValue(ClaimConst.RealName);
        entity.CreateTime = DateTime.Now;
        entity.UpdateTime = DateTime.Now;
        entity.CreateUserId = usertrueId;
        entity.CreateUserName = RealName;
        entity.UpdateUserId = usertrueId;
        entity.UpdateUserName = RealName;

        return await _neirongfabu.InsertAsync(entity);
    }

    /// <summary>
    /// 修改内容发布 ✏️
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [DisplayName("修改内容发布")]
    [ApiDescriptionSettings(Name = "Update"), HttpPost]
    public async Task Update(NeirongfabuInput input)
    {
        var entity = input.Adapt<Neirongfabu>();
        long userId = 0;
        long? usertrueId = null;
        if (long.TryParse(App.User?.FindFirst(ClaimConst.UserId)?.Value, out userId))
        {
            usertrueId = userId;
        }
        var RealName = App.User?.FindFirstValue(ClaimConst.RealName);
        entity.UpdateTime = DateTime.Now;
        entity.UpdateUserId = usertrueId;
        entity.UpdateUserName = RealName;
        await _neirongfabu.UpdateAsync(entity);
    }

    /// <summary>
    /// 删除内容发布 ❌
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [DisplayName("删除内容发布")]
    [ApiDescriptionSettings(Name = "Delete"), HttpPost]
    public async Task Delete(DeleteTenderOrderInput input)
    {
        //var entity = await _TenderOrderRep.GetFirstAsync(u => u.Id == input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002);
        var entity = await _sqlSugarClient.Queryable<Neirongfabu>().Where(x => x.Id == input.Id).FirstAsync() ?? throw Oops.Oh(ErrorCodeEnum.D1002);
        //await _TenderOrderRep.FakeDeleteAsync(entity);   //假删除
        await _neirongfabu.DeleteAsync(entity);   //真删除
    }

    /// <summary>
    /// 批量删除内容发布 ❌
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [DisplayName("批量删除内容发布")]
    [ApiDescriptionSettings(Name = "BatchDelete"), HttpPost]
    public async Task<bool> BatchDelete([Required(ErrorMessage = "主键列表不能为空")] List<DeleteTenderOrderInput> input)
    {
        var exp = Expressionable.Create<Neirongfabu>();
        foreach (var row in input) exp = exp.Or(it => it.Id == row.Id);
        var list = await _neirongfabu.AsQueryable().Where(exp.ToExpression()).ToListAsync();

        // return await _TenderOrderRep.FakeDeleteAsync(list);   //假删除
        return await _neirongfabu.DeleteAsync(list);   //真删除
    }



}