AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.ApprovalFlow/Service/ApprovalFlow/ApprovalFlowService.cs

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

using System.Text.Json;

namespace Admin.NET.Plugin.ApprovalFlow.Service;

/// <summary>
/// 审批流程服务
/// </summary>
[ApiDescriptionSettings(ApprovalFlowConst.GroupName, Order = 100)]
public class ApprovalFlowService : IDynamicApiController, ITransient
{
    private readonly SqlSugarRepository<ApprovalFlow> _approvalFlowRep;
    private readonly SqlSugarRepository<ApprovalFlowVersion> _versionRep;
    private readonly SqlSugarRepository<SysUser> _sysUserRep;
    private readonly UserManager _userManager;

    public ApprovalFlowService(
        SqlSugarRepository<ApprovalFlow> approvalFlowRep,
        SqlSugarRepository<ApprovalFlowVersion> versionRep,
        SqlSugarRepository<SysUser> sysUserRep,
        UserManager userManager)
    {
        _approvalFlowRep = approvalFlowRep;
        _versionRep = versionRep;
        _sysUserRep = sysUserRep;
        _userManager = userManager;
    }

    /// <summary>
    /// 分页查询审批流
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpPost]
    [ApiDescriptionSettings(Name = "Page")]
    public async Task<SqlSugarPagedList<ApprovalFlowOutput>> Page(ApprovalFlowInput input)
    {
        return await _approvalFlowRep.AsQueryable()
            .WhereIF(!string.IsNullOrWhiteSpace(input.Keyword), u => u.Code.Contains(input.Keyword.Trim()) || u.Name.Contains(input.Keyword.Trim()) || u.Remark.Contains(input.Keyword.Trim()))
            .WhereIF(!string.IsNullOrWhiteSpace(input.Code), u => u.Code.Contains(input.Code.Trim()))
            .WhereIF(!string.IsNullOrWhiteSpace(input.Name), u => u.Name.Contains(input.Name.Trim()))
            .WhereIF(!string.IsNullOrWhiteSpace(input.Remark), u => u.Remark.Contains(input.Remark.Trim()))
            .Select<ApprovalFlowOutput>()
            .ToPagedListAsync(input.Page, input.PageSize);
    }

    /// <summary>
    /// 增加审批流
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [ApiDescriptionSettings(Name = "Add"), HttpPost]
    public async Task<long> Add(AddApprovalFlowInput input)
    {
        var entity = input.Adapt<ApprovalFlow>();
        if (input.Code == null)
        {
            entity.Code = await LastCode("");
        }
        await _approvalFlowRep.InsertAsync(entity);
        return entity.Id;
    }

    /// <summary>
    /// 更新审批流
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [ApiDescriptionSettings(Name = "Update"), HttpPost]
    public async Task Update(UpdateApprovalFlowInput input)
    {
        var entity = input.Adapt<ApprovalFlow>();
        await _approvalFlowRep.AsUpdateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync();
    }

    /// <summary>
    /// 删除审批流
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [ApiDescriptionSettings(Name = "Delete"), HttpPost]
    public async Task Delete(DeleteApprovalFlowInput input)
    {
        var entity = await _approvalFlowRep.GetByIdAsync(input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002);
        await _approvalFlowRep.FakeDeleteAsync(entity);  // 假删除
    }

    /// <summary>
    /// 获取审批流
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    public async Task<ApprovalFlow> GetDetail([FromQuery] QueryByIdApprovalFlowInput input)
    {
        return await _approvalFlowRep.GetByIdAsync(input.Id);
    }

    /// <summary>
    /// 根据编码获取审批流信息
    /// </summary>
    /// <param name="code"></param>
    /// <returns></returns>
    public async Task<ApprovalFlow> GetInfo([FromQuery] string code)
    {
        return await _approvalFlowRep.GetFirstAsync(u => u.Code == code);
    }

    /// <summary>
    /// 获取审批流列表
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    public async Task<List<ApprovalFlowOutput>> GetList([FromQuery] ApprovalFlowInput input)
    {
        return await _approvalFlowRep.AsQueryable().Select<ApprovalFlowOutput>().ToListAsync();
    }

    /// <summary>
    /// 搜索审批人候选用户
    /// </summary>
    [HttpGet]
    [ApiDescriptionSettings(Name = "CandidateUsers")]
    [DisplayName("搜索审批人候选用户")]
    public async Task<List<ApprovalCandidateUserOutput>> CandidateUsers([FromQuery] ApprovalCandidateUserInput input)
    {
        var keyword = input.Keyword?.Trim();
        var pageSize = input.PageSize is > 0 and <= 100 ? input.PageSize : 20;
        var keywordId = long.TryParse(keyword, out var parsedId) ? parsedId : 0;

        return await _sysUserRep.AsQueryable()
            .Where(u => u.TenantId == _userManager.TenantId)
            .Where(u => u.AccountType != AccountTypeEnum.SuperAdmin)
            .WhereIF(!string.IsNullOrWhiteSpace(keyword), u =>
                u.Id == keywordId ||
                u.Account.Contains(keyword!) ||
                u.RealName.Contains(keyword!))
            .OrderBy(u => new { u.OrderNo, u.Id })
            .Select(u => new ApprovalCandidateUserOutput
            {
                Id = u.Id,
                Account = u.Account,
                RealName = u.RealName,
            })
            .Take(pageSize)
            .ToListAsync();
    }

    /// <summary>
    /// 获取今天创建的最大编号
    /// </summary>
    /// <param name="prefix"></param>
    /// <returns></returns>
    private async Task<string> LastCode(string prefix)
    {
        var today = DateTime.Now.Date;
        var count = await _approvalFlowRep.AsQueryable().Where(u => u.CreateTime >= today).CountAsync();
        return prefix + DateTime.Now.ToString("yyMMdd") + string.Format("{0:d2}", count + 1);
    }

    /// <summary>
    /// 发布流程（Version+1, IsPublished=true）
    /// </summary>
    [ApiDescriptionSettings(Name = "Publish"), HttpPost]
    [DisplayName("发布审批流")]
    public async Task Publish([FromBody] BaseIdInput input)
    {
        var entity = await _approvalFlowRep.GetByIdAsync(input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002);
        if (string.IsNullOrWhiteSpace(entity.FlowJson))
            throw Oops.Oh("请先设计流程图再发布");
        if (string.IsNullOrWhiteSpace(entity.BizType))
            throw Oops.Oh("请先设置业务类型再发布");

        entity.Version += 1;
        entity.IsPublished = true;
        await _approvalFlowRep.AsUpdateable(entity)
            .UpdateColumns(u => new { u.Version, u.IsPublished })
            .ExecuteCommandAsync();

        await _versionRep.InsertAsync(new ApprovalFlowVersion
        {
            FlowId = entity.Id,
            Version = entity.Version,
            FlowJson = entity.FlowJson,
            FormJson = entity.FormJson,
            PublishTime = DateTime.Now,
            PublisherName = _userManager.RealName,
        });
    }

    /// <summary>
    /// 获取流程版本历史
    /// </summary>
    [HttpGet]
    [ApiDescriptionSettings(Name = "VersionHistory")]
    [DisplayName("获取版本历史")]
    public async Task<List<FlowVersionOutput>> VersionHistory([FromQuery] long flowId)
    {
        return await _versionRep.AsQueryable()
            .Where(v => v.FlowId == flowId)
            .OrderByDescending(v => v.Version)
            .Select(v => new FlowVersionOutput
            {
                Id = v.Id,
                Version = v.Version,
                PublishTime = v.PublishTime,
                PublisherName = v.PublisherName,
            })
            .ToListAsync();
    }

    /// <summary>
    /// 获取指定版本详情（含 FlowJson）
    /// </summary>
    [HttpGet]
    [ApiDescriptionSettings(Name = "VersionDetail")]
    [DisplayName("获取版本详情")]
    public async Task<ApprovalFlowVersion?> VersionDetail([FromQuery] long versionId)
    {
        return await _versionRep.GetByIdAsync(versionId);
    }

    /// <summary>
    /// 回退到指定版本（将该版本的 FlowJson/FormJson 复制回主记录）
    /// </summary>
    [HttpPost]
    [ApiDescriptionSettings(Name = "RevertVersion")]
    [DisplayName("回退版本")]
    public async Task RevertVersion([FromBody] BaseIdInput input)
    {
        var version = await _versionRep.GetByIdAsync(input.Id)
            ?? throw Oops.Oh("版本记录不存在");

        var flow = await _approvalFlowRep.GetByIdAsync(version.FlowId)
            ?? throw Oops.Oh("流程不存在");

        flow.FlowJson = version.FlowJson;
        flow.FormJson = version.FormJson;
        flow.IsPublished = false;
        await _approvalFlowRep.AsUpdateable(flow)
            .UpdateColumns(u => new { u.FlowJson, u.FormJson, u.IsPublished })
            .ExecuteCommandAsync();
    }

    /// <summary>
    /// 获取业务类型列表
    /// </summary>
    [HttpGet]
    [ApiDescriptionSettings(Name = "BizTypes")]
    [DisplayName("获取业务类型列表")]
    public async Task<List<string>> GetBizTypes()
    {
        return await _approvalFlowRep.AsQueryable()
            .Where(u => !string.IsNullOrWhiteSpace(u.BizType) && !u.IsDelete)
            .Select(u => u.BizType!)
            .Distinct()
            .ToListAsync();
    }

    /// <summary>
    /// 获取指定业务类型的最新已发布流程定义
    /// </summary>
    [HttpGet]
    [ApiDescriptionSettings(Name = "PublishedByBizType")]
    [DisplayName("获取已发布流程")]
    public async Task<ApprovalFlowOutput?> GetPublishedByBizType([FromQuery] string bizType)
    {
        return await _approvalFlowRep.AsQueryable()
            .Where(u => u.BizType == bizType && u.IsPublished && !u.IsDelete)
            .OrderByDescending(u => u.Version)
            .Select<ApprovalFlowOutput>()
            .FirstAsync();
    }

    [HttpGet]
    [ApiDescriptionSettings(Name = "FlowList")]
    [DisplayName("获取审批流结构")]
    public async Task<dynamic> FlowList([FromQuery] string code)
    {
        var result = await _approvalFlowRep.AsQueryable().Where(u => u.Code == code).Select<ApprovalFlowOutput>().FirstAsync();
        var FlowJson = result.FlowJson != null ? JsonSerializer.Deserialize<ApprovalFlowItem>(result.FlowJson) : new ApprovalFlowItem();
        var FormJson = result.FormJson != null ? JsonSerializer.Deserialize<ApprovalFormItem>(result.FormJson) : new ApprovalFormItem();
        return new
        {
            FlowJson,
            FormJson
        };
    }

    [HttpGet]
    [ApiDescriptionSettings(Name = "FormRoutes")]
    [DisplayName("获取审批流规则")]
    public async Task<List<string>> FormRoutes()
    {
        var results = await _approvalFlowRep.AsQueryable().Select<ApprovalFlowOutput>().ToListAsync();
        var list = new List<string>();
        foreach (var item in results)
        {
            if (string.IsNullOrWhiteSpace(item.FormJson))
                continue;
            var formJson = JsonSerializer.Deserialize<ApprovalFormItem>(item.FormJson);
            if (formJson != null && !string.IsNullOrEmpty(formJson.Route))
                list.Add(formJson.Route);
        }
        return list;
    }
}