using Admin.NET.Plugin.AiDOP.Dto.DataPlatform;
using Admin.NET.Plugin.AiDOP.Entity.DataPlatform;
using Admin.NET.Plugin.AiDOP.Order;

namespace Admin.NET.Plugin.AiDOP.DataPlatform;

/// <summary>
/// 数据中台同步配置中心 API。
/// </summary>
[ApiDescriptionSettings(Order = 323, Description = "数据中台同步配置中心")]
[Route("api/DataPlatform")]
[NonUnify]
public class MdpSyncTaskConfigService : IDynamicApiController, ITransient
{
    private static readonly HashSet<string> ProtectedTaskCodes = new(StringComparer.OrdinalIgnoreCase)
    {
        "S1_MDP_SYNC_TRANSFORM",
        "S2_MDP_SYNC_TRANSFORM",
        "S3_MDP_SYNC_TRANSFORM",
        "S4_MDP_SYNC_TRANSFORM",
        "S5_MDP_SYNC_TRANSFORM",
        "S5_PURCHASE_RECEIPT_INBOUND",
        "S6_MDP_SYNC_TRANSFORM",
        "S6_IPQC_INSPECTION_INBOUND",
        "S7_MDP_SYNC_TRANSFORM",
        "S7_PRODUCTION_RECEIPT_INBOUND"
    };

    private readonly ISqlSugarClient _db;
    private readonly UserManager _userManager;
    private readonly MdpDbSyncScheduleBinder _scheduleBinder;
    private readonly MdpDbEntityOperationService _dbOperations;
    private readonly MdpDbSyncNeutralProjection _neutralProjection;
    private readonly MdpDbSyncRebuildTrigger _rebuildTrigger;

    public MdpSyncTaskConfigService(
        ISqlSugarClient db,
        UserManager userManager,
        MdpDbSyncScheduleBinder scheduleBinder,
        MdpDbEntityOperationService dbOperations,
        MdpDbSyncNeutralProjection neutralProjection,
        MdpDbSyncRebuildTrigger rebuildTrigger)
    {
        _db = db;
        _userManager = userManager;
        _scheduleBinder = scheduleBinder;
        _dbOperations = dbOperations;
        _neutralProjection = neutralProjection;
        _rebuildTrigger = rebuildTrigger;
    }

    [DisplayName("同步任务列表")]
    [HttpGet("sync-tasks")]
    public async Task<object> GetList([FromQuery] MdpSyncTaskListQuery input)
    {
        var tenantId = _userManager.TenantId;
        var page = input.Page <= 0 ? 1 : input.Page;
        var pageSize = input.PageSize <= 0 ? 10 : input.PageSize;
        var offset = (page - 1) * pageSize;
        var where = new List<string> { "(t.tenant_id = @TenantId OR t.tenant_id = 0)", "t.status = 1" };
        var pars = new List<SugarParameter> { new("@TenantId", tenantId) };

        if (!string.IsNullOrWhiteSpace(input.Keyword))
        {
            where.Add("(t.task_code LIKE @Keyword OR t.task_name LIKE @Keyword OR t.business_domain_name LIKE @Keyword)");
            pars.Add(new SugarParameter("@Keyword", $"%{input.Keyword.Trim()}%"));
        }
        if (!string.IsNullOrWhiteSpace(input.BusinessDomainCode))
        {
            where.Add("t.business_domain_code = @BusinessDomainCode");
            pars.Add(new SugarParameter("@BusinessDomainCode", input.BusinessDomainCode.Trim()));
        }
        if (input.Status.HasValue)
        {
            where[1] = "t.status = @Status";
            pars.Add(new SugarParameter("@Status", input.Status.Value));
        }

        var whereSql = string.Join(" AND ", where);
        var total = await _db.Ado.GetIntAsync($"SELECT COUNT(1) FROM mdp_sync_task t WHERE {whereSql}", pars);
        var list = await _db.Ado.SqlQueryAsync<MdpSyncTaskListRow>(
            $"""
            SELECT t.id AS Id, t.tenant_id AS TenantId, t.task_code AS TaskCode, t.task_name AS TaskName,
                   t.task_type AS TaskType, t.business_domain_code AS BusinessDomainCode,
                   t.business_domain_name AS BusinessDomainName, t.consumer_modules AS ConsumerModules,
                   t.source_system_code AS SourceSystemCode, t.service_key AS ServiceKey,
                   t.job_code AS JobCode, t.schedule_job_id AS ScheduleJobId, t.status AS Status,
                   t.config_version AS ConfigVersion, t.description AS Description,
                   sch.schedule_mode AS ScheduleMode,
                   IFNULL(sch.auto_enabled, 1) AS AutoEnabled,
                   IFNULL(sch.manual_enabled, 1) AS ManualEnabled,
                   run.status AS LastRunStatus, run.start_time AS LastRunTime
            FROM mdp_sync_task t
            LEFT JOIN mdp_sync_task_schedule sch
              ON sch.tenant_id = t.tenant_id AND sch.task_code = t.task_code
            LEFT JOIN (
                SELECT job_code, MAX(start_time) AS last_run_time
                FROM mdp_transform_run_log
                WHERE {MdpMonitorService.BuildMdpRunLogTenantWhere(tenantId)}
                GROUP BY job_code
            ) latest ON latest.job_code = IFNULL(t.job_code, t.task_code)
            LEFT JOIN mdp_transform_run_log run
              ON run.job_code = latest.job_code AND run.start_time = latest.last_run_time
            WHERE {whereSql}
            ORDER BY t.task_code
            LIMIT {pageSize} OFFSET {offset}
            """,
            pars);

        return new { total, page, pageSize, list };
    }

    [DisplayName("同步任务详情")]
    [HttpGet("sync-tasks/{id:long}")]
    public async Task<object> GetDetail(long id)
    {
        var tenantId = _userManager.TenantId;
        var row = await _db.Ado.SqlQuerySingleAsync<MdpSyncTaskListRow>(
            $"""
            SELECT t.id AS Id, t.tenant_id AS TenantId, t.task_code AS TaskCode, t.task_name AS TaskName,
                   t.task_type AS TaskType, t.business_domain_code AS BusinessDomainCode,
                   t.business_domain_name AS BusinessDomainName, t.consumer_modules AS ConsumerModules,
                   t.source_system_code AS SourceSystemCode, t.service_key AS ServiceKey,
                   t.job_code AS JobCode, t.schedule_job_id AS ScheduleJobId, t.status AS Status,
                   t.config_version AS ConfigVersion, t.description AS Description,
                   sch.schedule_mode AS ScheduleMode,
                   IFNULL(sch.auto_enabled, 1) AS AutoEnabled,
                   IFNULL(sch.manual_enabled, 1) AS ManualEnabled,
                   run.status AS LastRunStatus, run.start_time AS LastRunTime
            FROM mdp_sync_task t
            LEFT JOIN mdp_sync_task_schedule sch
              ON sch.tenant_id = t.tenant_id AND sch.task_code = t.task_code
            LEFT JOIN (
                SELECT job_code, MAX(start_time) AS last_run_time
                FROM mdp_transform_run_log
                WHERE {MdpMonitorService.BuildMdpRunLogTenantWhere(tenantId)}
                GROUP BY job_code
            ) latest ON latest.job_code = IFNULL(t.job_code, t.task_code)
            LEFT JOIN mdp_transform_run_log run
              ON run.job_code = latest.job_code AND run.start_time = latest.last_run_time
            WHERE t.id = @Id AND (t.tenant_id = @TenantId OR t.tenant_id = 0)
            LIMIT 1
            """,
            new SugarParameter("@Id", id),
            new SugarParameter("@TenantId", tenantId));

        if (row == null)
            throw Oops.Oh("同步任务不存在");
        return row;
    }

    [DisplayName("立即执行数据库同步任务")]
    [HttpPost("sync-tasks/{taskCode}/run")]
    public async Task<object> RunDbSyncTask(
        string taskCode,
        [FromBody] MdpSyncTaskRunInput input,
        CancellationToken cancellationToken)
    {
        var tenantId = _userManager.TenantId;
        if (tenantId <= 0)
            throw Oops.Oh("无法解析当前租户");
        if (string.IsNullOrWhiteSpace(input.Reason))
            throw Oops.Oh("请填写执行原因");

        var task = await EnsureTaskExistsAsync(taskCode, tenantId);
        if (!string.Equals(task.TaskType, "DB_SYNC", StringComparison.OrdinalIgnoreCase))
            throw Oops.Oh("只有方式甲数据库同步任务支持该操作");

        var mode = (input.Mode ?? "INCR").Trim().ToUpperInvariant();
        if (mode is not ("FULL" or "INCR" or "ROLLING"))
            throw Oops.Oh("执行模式只能是 FULL、INCR 或 ROLLING");

        var jobCode = string.IsNullOrWhiteSpace(task.JobCode) ? task.TaskCode : task.JobCode;
        var entities = await _db.Queryable<MdpEntity>()
            .Where(x => x.Status == 1
                        && (x.TenantId == tenantId || x.TenantId == 0)
                        && (x.JobId == task.TaskCode || x.JobId == jobCode))
            .OrderByDescending(x => x.TenantId)
            .OrderBy(x => x.EntityCode)
            .ToListAsync(cancellationToken);
        if (entities.Count == 0)
            throw Oops.Oh("任务没有已启用的同步实体");

        var results = new List<object>();
        foreach (var entity in entities
                     .GroupBy(x => x.EntityCode, StringComparer.OrdinalIgnoreCase)
                     .Select(x => x.First()))
        {
            cancellationToken.ThrowIfCancellationRequested();
            var result = await _dbOperations.RunEntityAsync(
                entity.Id,
                mode,
                input.Reason.Trim(),
                "MANUAL",
                cancellationToken,
                tenantId);
            results.Add(result);
        }

        await _neutralProjection.ProjectAsync(entities, tenantId, cancellationToken);
        var modules = await _rebuildTrigger.EnqueueForTaskAsync(
            task,
            tenantId,
            input.FactoryId > 0 ? input.FactoryId : 1,
            "MANUAL",
            cancellationToken,
            _userManager.UserId);
        return new { taskCode = task.TaskCode, entityCount = results.Count, modules, results };
    }

    [DisplayName("新增同步任务")]
    [HttpPost("sync-tasks")]
    public async Task<object> Create([FromBody] MdpSyncTaskUpsertInput input)
    {
        ValidateUpsert(input);
        var tenantId = _userManager.TenantId;
        var exists = await _db.Queryable<MdpSyncTask>()
            .Where(u => u.TenantId == tenantId && u.TaskCode == input.TaskCode.Trim())
            .AnyAsync();
        if (exists)
            throw Oops.Oh("任务编码已存在");

        var entity = MapUpsert(input, tenantId);
        entity.ConfigVersion = 1;
        entity.CreateTime = DateTime.Now;
        entity.UpdateTime = DateTime.Now;
        var id = await _db.Insertable(entity).ExecuteReturnBigIdentityAsync();
        await EnsureDefaultScheduleAsync(tenantId, entity.TaskCode, entity.ScheduleJobId);
        return new { id };
    }

    [DisplayName("更新同步任务")]
    [HttpPut("sync-tasks/{id:long}")]
    public async Task<object> Update(long id, [FromBody] MdpSyncTaskUpsertInput input)
    {
        ValidateUpsert(input);
        var tenantId = _userManager.TenantId;
        var entity = await FindEditableTaskAsync(id, tenantId);
        entity.TaskName = input.TaskName.Trim();
        entity.TaskType = string.IsNullOrWhiteSpace(input.TaskType) ? "SERVICE_SYNC" : input.TaskType.Trim();
        entity.BusinessDomainCode = input.BusinessDomainCode?.Trim();
        entity.BusinessDomainName = input.BusinessDomainName?.Trim();
        entity.ConsumerModules = input.ConsumerModules?.Trim();
        entity.SourceSystemCode = input.SourceSystemCode?.Trim();
        entity.ServiceKey = input.ServiceKey?.Trim();
        entity.JobCode = string.IsNullOrWhiteSpace(input.JobCode) ? input.TaskCode.Trim() : input.JobCode.Trim();
        entity.ScheduleJobId = input.ScheduleJobId?.Trim();
        entity.Status = input.Status <= 0 ? 0 : 1;
        entity.OwnerRole = input.OwnerRole?.Trim();
        entity.Description = input.Description?.Trim();
        entity.ConfigVersion += 1;
        entity.UpdateTime = DateTime.Now;

        if (!ProtectedTaskCodes.Contains(entity.TaskCode))
            entity.TaskCode = input.TaskCode.Trim();

        await _db.Updateable(entity).ExecuteCommandAsync();
        await SyncScheduleJobIdAsync(entity.TenantId, entity.TaskCode, entity.ScheduleJobId);
        return new { id = entity.Id };
    }

    [DisplayName("删除同步任务")]
    [HttpDelete("sync-tasks/{id:long}")]
    public async Task<object> Delete(long id)
    {
        var tenantId = _userManager.TenantId;
        var entity = await FindEditableTaskAsync(id, tenantId);
        if (ProtectedTaskCodes.Contains(entity.TaskCode) && entity.TenantId == 0)
            throw Oops.Oh("内置 MDP 同步任务不允许删除");

        entity.Status = 0;
        entity.UpdateTime = DateTime.Now;
        await _db.Updateable(entity).UpdateColumns(u => new { u.Status, u.UpdateTime }).ExecuteCommandAsync();
        return new { id };
    }

    [DisplayName("同步任务步骤列表")]
    [HttpGet("sync-tasks/{taskCode}/steps")]
    public async Task<object> GetSteps(string taskCode)
    {
        var tenantId = _userManager.TenantId;
        await EnsureTaskExistsAsync(taskCode, tenantId);
        var steps = await _db.Queryable<MdpSyncTaskStep>()
            .Where(u => u.TaskCode == taskCode && (u.TenantId == tenantId || u.TenantId == 0))
            .OrderBy(u => u.SortOrder)
            .ToListAsync();

        return steps.Select(MapStepRow).ToList();
    }

    [DisplayName("保存同步任务步骤")]
    [HttpPut("sync-tasks/{taskCode}/steps")]
    public async Task<object> SaveSteps(string taskCode, [FromBody] List<MdpSyncTaskStepRow> input)
    {
        var tenantId = _userManager.TenantId;
        var task = await EnsureTaskExistsAsync(taskCode, tenantId);
        var rows = input ?? new List<MdpSyncTaskStepRow>();
        var now = DateTime.Now;

        foreach (var row in rows)
        {
            if (string.IsNullOrWhiteSpace(row.StepCode) || string.IsNullOrWhiteSpace(row.StepName))
                throw Oops.Oh("步骤编码和名称不能为空");
            var stage = string.IsNullOrWhiteSpace(row.StageType) ? row.StepCode.Trim() : row.StageType.Trim();
            if (row.Enabled && Admin.NET.Plugin.AiDOP.DataPlatform.FileImport.MdpExcelValidation.IsPullStage(stage, row.StepCode))
            {
                if (!string.IsNullOrWhiteSpace(task.SourceSystemCode))
                {
                    var src = await _db.Queryable<MdpSource>().FirstAsync(x => x.SourceCode == task.SourceSystemCode);
                    if (src != null && string.Equals(src.SourceType, "FILE_EXCEL", StringComparison.OrdinalIgnoreCase))
                        throw Oops.Oh("FILE_EXCEL 实体不得登记 Pull/Extract 步骤，请使用文件导入接口");
                }
            }

            var entity = await _db.Queryable<MdpSyncTaskStep>()
                .Where(u => u.TaskCode == taskCode && u.StepCode == row.StepCode && (u.TenantId == tenantId || u.TenantId == 0))
                .FirstAsync();

            if (entity == null)
            {
                entity = new MdpSyncTaskStep
                {
                    TenantId = task.TenantId == 0 ? 0 : tenantId,
                    TaskCode = taskCode,
                    StepCode = row.StepCode.Trim(),
                    StepName = row.StepName.Trim(),
                    StageType = string.IsNullOrWhiteSpace(row.StageType) ? row.StepCode.Trim() : row.StageType.Trim(),
                    ServiceMethodKey = row.ServiceMethodKey?.Trim(),
                    Enabled = row.Enabled ? 1 : 0,
                    SortOrder = row.SortOrder,
                    Description = row.Description?.Trim(),
                    CreateTime = now,
                    UpdateTime = now
                };
                await _db.Insertable(entity).ExecuteCommandAsync();
            }
            else
            {
                entity.StepName = row.StepName.Trim();
                entity.StageType = string.IsNullOrWhiteSpace(row.StageType) ? row.StepCode.Trim() : row.StageType.Trim();
                entity.ServiceMethodKey = row.ServiceMethodKey?.Trim();
                entity.Enabled = row.Enabled ? 1 : 0;
                entity.SortOrder = row.SortOrder;
                entity.Description = row.Description?.Trim();
                entity.UpdateTime = now;
                await _db.Updateable(entity).ExecuteCommandAsync();
            }
        }

        task.ConfigVersion += 1;
        task.UpdateTime = now;
        await _db.Updateable(task).UpdateColumns(u => new { u.ConfigVersion, u.UpdateTime }).ExecuteCommandAsync();
        return new { count = rows.Count };
    }

    [DisplayName("同步任务调度配置")]
    [HttpGet("sync-tasks/{taskCode}/schedule")]
    public async Task<object> GetSchedule(string taskCode)
    {
        var tenantId = _userManager.TenantId;
        await EnsureTaskExistsAsync(taskCode, tenantId);
        var schedule = await FindScheduleAsync(taskCode, tenantId);
        if (schedule == null)
            return new MdpSyncTaskScheduleRow { TaskCode = taskCode, ScheduleMode = "CRON" };
        return MapScheduleRow(schedule);
    }

    [DisplayName("保存同步任务调度配置")]
    [HttpPut("sync-tasks/{taskCode}/schedule")]
    public async Task<object> SaveSchedule(string taskCode, [FromBody] MdpSyncTaskScheduleRow input)
    {
        var tenantId = _userManager.TenantId;
        var task = await EnsureTaskExistsAsync(taskCode, tenantId);
        var schedule = await FindScheduleAsync(taskCode, tenantId);
        var now = DateTime.Now;

        if (schedule == null)
        {
            schedule = new MdpSyncTaskSchedule
            {
                TenantId = task.TenantId == 0 ? 0 : tenantId,
                TaskCode = taskCode,
                CreateTime = now,
                UpdateTime = now
            };
        }

        schedule.ScheduleJobId = input.ScheduleJobId?.Trim() ?? task.ScheduleJobId;
        schedule.ScheduleMode = string.IsNullOrWhiteSpace(input.ScheduleMode) ? "CRON" : input.ScheduleMode.Trim();
        schedule.CronExpr = input.CronExpr?.Trim();
        schedule.CronDesc = input.CronDesc?.Trim();
        schedule.Timezone = string.IsNullOrWhiteSpace(input.Timezone) ? "Asia/Shanghai" : input.Timezone.Trim();
        schedule.AutoEnabled = input.AutoEnabled ? 1 : 0;
        schedule.ManualEnabled = input.ManualEnabled ? 1 : 0;
        schedule.RetryEnabled = input.RetryEnabled ? 1 : 0;
        schedule.MaxRetryCount = input.MaxRetryCount <= 0 ? 3 : input.MaxRetryCount;
        schedule.RetryIntervalSeconds = input.RetryIntervalSeconds <= 0 ? 300 : input.RetryIntervalSeconds;
        schedule.TimeoutSeconds = input.TimeoutSeconds <= 0 ? 3600 : input.TimeoutSeconds;
        schedule.MisfirePolicy = input.MisfirePolicy?.Trim();
        schedule.SyncWindowType = string.IsNullOrWhiteSpace(input.SyncWindowType) ? "FULL" : input.SyncWindowType.Trim();
        schedule.SyncWindowValue = input.SyncWindowValue?.Trim();
        schedule.LastScheduleTime = input.LastScheduleTime;
        schedule.NextScheduleTime = input.NextScheduleTime;
        schedule.AdminJobConfigJson = input.AdminJobConfigJson;
        schedule.Description = input.Description?.Trim();
        schedule.UpdateTime = now;

        if (schedule.Id <= 0)
            await _db.Insertable(schedule).ExecuteCommandAsync();
        else
            await _db.Updateable(schedule).ExecuteCommandAsync();

        task.ScheduleJobId = schedule.ScheduleJobId;
        task.ConfigVersion += 1;
        task.UpdateTime = now;
        if (string.Equals(task.TaskType, "DB_SYNC", StringComparison.OrdinalIgnoreCase))
        {
            var jobId = await _scheduleBinder.BindAsync(task, schedule, tenantId);
            schedule.ScheduleJobId = jobId;
            task.ScheduleJobId = jobId;
            await _db.Updateable(schedule).UpdateColumns(u => new { u.ScheduleJobId, u.UpdateTime }).ExecuteCommandAsync();
        }
        await _db.Updateable(task).UpdateColumns(u => new { u.ScheduleJobId, u.ConfigVersion, u.UpdateTime }).ExecuteCommandAsync();
        return MapScheduleRow(schedule);
    }

    [DisplayName("同步 Admin.NET 调度快照")]
    [HttpPost("sync-tasks/{taskCode}/schedule/sync-admin-job")]
    public async Task<object> SyncAdminJob(string taskCode)
    {
        var tenantId = _userManager.TenantId;
        var task = await EnsureTaskExistsAsync(taskCode, tenantId);
        var schedule = await FindScheduleAsync(taskCode, tenantId) ?? new MdpSyncTaskSchedule
        {
            TenantId = task.TenantId == 0 ? 0 : tenantId,
            TaskCode = taskCode,
            ScheduleJobId = task.ScheduleJobId,
            ScheduleMode = "CRON",
            CreateTime = DateTime.Now,
            UpdateTime = DateTime.Now
        };

        if (string.Equals(task.TaskType, "DB_SYNC", StringComparison.OrdinalIgnoreCase))
        {
            var jobId = await _scheduleBinder.BindAsync(task, schedule, tenantId);
            schedule.ScheduleJobId = jobId;
            task.ScheduleJobId = jobId;
            await _db.Updateable(task).UpdateColumns(u => new { u.ScheduleJobId, u.UpdateTime }).ExecuteCommandAsync();
        }
        schedule.AdminJobConfigJson = System.Text.Json.JsonSerializer.Serialize(new
        {
            scheduleJobId = schedule.ScheduleJobId ?? task.ScheduleJobId,
            jobType = "Admin.NET.Plugin.AiDOP.Job.MdpConfiguredDbSyncJob",
            message = string.Equals(task.TaskType, "DB_SYNC", StringComparison.OrdinalIgnoreCase)
                ? "已同步到 Admin.NET 调度作业"
                : "非数据库同步任务只保存调度快照"
        });
        schedule.UpdateTime = DateTime.Now;

        if (schedule.Id <= 0)
            await _db.Insertable(schedule).ExecuteCommandAsync();
        else
            await _db.Updateable(schedule).UpdateColumns(u => new { u.AdminJobConfigJson, u.UpdateTime }).ExecuteCommandAsync();

        return new
        {
            taskCode,
            scheduleJobId = schedule.ScheduleJobId ?? task.ScheduleJobId,
            adminJobConfigJson = schedule.AdminJobConfigJson
        };
    }

    private async Task<MdpSyncTask> EnsureTaskExistsAsync(string taskCode, long tenantId)
    {
        if (string.IsNullOrWhiteSpace(taskCode))
            throw Oops.Oh("任务编码不能为空");

        var task = await _db.Queryable<MdpSyncTask>()
            .Where(u => u.TaskCode == taskCode && (u.TenantId == tenantId || u.TenantId == 0) && u.Status == 1)
            .OrderBy(u => u.TenantId, OrderByType.Desc)
            .FirstAsync();
        if (task == null)
            throw Oops.Oh("同步任务不存在");
        return task;
    }

    private async Task<MdpSyncTask> FindEditableTaskAsync(long id, long tenantId)
    {
        var entity = await _db.Queryable<MdpSyncTask>()
            .Where(u => u.Id == id && (u.TenantId == tenantId || u.TenantId == 0))
            .FirstAsync();
        if (entity == null)
            throw Oops.Oh("同步任务不存在");
        return entity;
    }

    private async Task<MdpSyncTaskSchedule?> FindScheduleAsync(string taskCode, long tenantId) =>
        await _db.Queryable<MdpSyncTaskSchedule>()
            .Where(u => u.TaskCode == taskCode && (u.TenantId == tenantId || u.TenantId == 0))
            .OrderBy(u => u.TenantId, OrderByType.Desc)
            .FirstAsync();

    private async Task EnsureDefaultScheduleAsync(long tenantId, string taskCode, string? scheduleJobId)
    {
        var exists = await _db.Queryable<MdpSyncTaskSchedule>()
            .Where(u => u.TaskCode == taskCode && (u.TenantId == tenantId || u.TenantId == 0))
            .AnyAsync();
        if (exists)
            return;

        await _db.Insertable(new MdpSyncTaskSchedule
        {
            TenantId = tenantId,
            TaskCode = taskCode,
            ScheduleJobId = scheduleJobId,
            ScheduleMode = "CRON",
            CronDesc = "按 Admin.NET 任务调度执行",
            AutoEnabled = 1,
            ManualEnabled = 1,
            RetryEnabled = 1,
            MaxRetryCount = 3,
            RetryIntervalSeconds = 300,
            TimeoutSeconds = 3600,
            SyncWindowType = "FULL",
            CreateTime = DateTime.Now,
            UpdateTime = DateTime.Now
        }).ExecuteCommandAsync();
    }

    private async Task SyncScheduleJobIdAsync(long tenantId, string taskCode, string? scheduleJobId)
    {
        var schedule = await FindScheduleAsync(taskCode, tenantId);
        if (schedule == null)
        {
            await EnsureDefaultScheduleAsync(tenantId, taskCode, scheduleJobId);
            return;
        }

        schedule.ScheduleJobId = scheduleJobId;
        schedule.UpdateTime = DateTime.Now;
        await _db.Updateable(schedule).UpdateColumns(u => new { u.ScheduleJobId, u.UpdateTime }).ExecuteCommandAsync();
    }

    private static void ValidateUpsert(MdpSyncTaskUpsertInput input)
    {
        if (string.IsNullOrWhiteSpace(input.TaskCode))
            throw Oops.Oh("任务编码不能为空");
        if (string.IsNullOrWhiteSpace(input.TaskName))
            throw Oops.Oh("任务名称不能为空");
    }

    private static MdpSyncTask MapUpsert(MdpSyncTaskUpsertInput input, long tenantId) =>
        new()
        {
            TenantId = tenantId,
            TaskCode = input.TaskCode.Trim(),
            TaskName = input.TaskName.Trim(),
            TaskType = string.IsNullOrWhiteSpace(input.TaskType) ? "SERVICE_SYNC" : input.TaskType.Trim(),
            BusinessDomainCode = input.BusinessDomainCode?.Trim(),
            BusinessDomainName = input.BusinessDomainName?.Trim(),
            ConsumerModules = input.ConsumerModules?.Trim(),
            SourceSystemCode = input.SourceSystemCode?.Trim(),
            ServiceKey = input.ServiceKey?.Trim(),
            JobCode = string.IsNullOrWhiteSpace(input.JobCode) ? input.TaskCode.Trim() : input.JobCode.Trim(),
            ScheduleJobId = input.ScheduleJobId?.Trim(),
            Status = input.Status <= 0 ? 0 : 1,
            OwnerRole = input.OwnerRole?.Trim(),
            Description = input.Description?.Trim()
        };

    private static MdpSyncTaskStepRow MapStepRow(MdpSyncTaskStep step) =>
        new()
        {
            Id = step.Id,
            StepCode = step.StepCode,
            StepName = step.StepName,
            StageType = step.StageType,
            ServiceMethodKey = step.ServiceMethodKey,
            Enabled = step.Enabled != 0,
            SortOrder = step.SortOrder,
            Description = step.Description
        };

    private static MdpSyncTaskScheduleRow MapScheduleRow(MdpSyncTaskSchedule schedule) =>
        new()
        {
            TaskCode = schedule.TaskCode,
            ScheduleJobId = schedule.ScheduleJobId,
            ScheduleMode = schedule.ScheduleMode,
            CronExpr = schedule.CronExpr,
            CronDesc = schedule.CronDesc,
            Timezone = schedule.Timezone,
            AutoEnabled = schedule.AutoEnabled != 0,
            ManualEnabled = schedule.ManualEnabled != 0,
            RetryEnabled = schedule.RetryEnabled != 0,
            MaxRetryCount = schedule.MaxRetryCount,
            RetryIntervalSeconds = schedule.RetryIntervalSeconds,
            TimeoutSeconds = schedule.TimeoutSeconds,
            MisfirePolicy = schedule.MisfirePolicy,
            SyncWindowType = schedule.SyncWindowType,
            SyncWindowValue = schedule.SyncWindowValue,
            LastScheduleTime = schedule.LastScheduleTime,
            NextScheduleTime = schedule.NextScheduleTime,
            AdminJobConfigJson = schedule.AdminJobConfigJson,
            Description = schedule.Description
        };

    [DisplayName("任务参数列表")]
    [HttpGet("sync-tasks/{taskCode}/params")]
    public async Task<object> GetParams(string taskCode)
    {
        var tenantId = _userManager.TenantId;
        var list = await _db.Queryable<MdpSyncTaskParam>()
            .Where(u => u.TaskCode == taskCode && (u.TenantId == tenantId || u.TenantId == 0))
            .OrderBy(u => u.SortOrder)
            .ToListAsync();
        return new
        {
            list = list.Select(p => new
            {
                p.Id,
                p.TaskCode,
                p.ScopeType,
                p.ScopeCode,
                p.ParamKey,
                p.ParamName,
                p.ParamType,
                p.ParamValue,
                p.DefaultValue,
                required = p.Required != 0,
                editable = p.Editable != 0,
                p.SortOrder,
                p.Description
            })
        };
    }

    [DisplayName("保存任务参数")]
    [HttpPut("sync-tasks/{taskCode}/params")]
    public async Task<object> SaveParams(string taskCode, [FromBody] List<MdpSyncTaskParamSaveItem> items)
    {
        var tenantId = _userManager.TenantId;
        items ??= [];
        await _db.Deleteable<MdpSyncTaskParam>()
            .Where(u => u.TaskCode == taskCode && u.TenantId == tenantId)
            .ExecuteCommandAsync();
        var now = DateTime.Now;
        var rows = items.Where(x => !string.IsNullOrWhiteSpace(x.ParamKey)).Select((x, i) => new MdpSyncTaskParam
        {
            TenantId = tenantId,
            TaskCode = taskCode,
            ScopeType = string.IsNullOrWhiteSpace(x.ScopeType) ? "TASK" : x.ScopeType.Trim(),
            ScopeCode = x.ScopeCode?.Trim() ?? "",
            ParamKey = x.ParamKey.Trim(),
            ParamName = string.IsNullOrWhiteSpace(x.ParamName) ? x.ParamKey.Trim() : x.ParamName.Trim(),
            ParamType = string.IsNullOrWhiteSpace(x.ParamType) ? "STRING" : x.ParamType.Trim(),
            ParamValue = x.ParamValue,
            DefaultValue = x.DefaultValue,
            Required = x.Required ? (byte)1 : (byte)0,
            Editable = x.Editable ? (byte)1 : (byte)0,
            SortOrder = x.SortOrder > 0 ? x.SortOrder : i + 1,
            Description = x.Description,
            CreateTime = now,
            UpdateTime = now
        }).ToList();
        if (rows.Count > 0)
            await _db.Insertable(rows).ExecuteCommandAsync();
        return new { ok = true, count = rows.Count };
    }

    [DisplayName("任务公式列表")]
    [HttpGet("sync-tasks/{taskCode}/formulas")]
    public async Task<object> GetFormulas(string taskCode)
    {
        var tenantId = _userManager.TenantId;
        var list = await _db.Queryable<MdpSyncTaskFormula>()
            .Where(u => u.TaskCode == taskCode && (u.TenantId == tenantId || u.TenantId == 0))
            .OrderBy(u => u.SortOrder)
            .ToListAsync();
        return new
        {
            list = list.Select(f => new
            {
                f.Id,
                f.TaskCode,
                f.StepCode,
                f.FormulaCode,
                f.FormulaName,
                f.MetricCode,
                f.FormulaExpr,
                f.FormulaPreview,
                f.Direction,
                f.YellowThreshold,
                f.RedThreshold,
                f.VersionNo,
                enabled = f.IsEnabled != 0,
                f.SortOrder,
                f.Description
            })
        };
    }

    [DisplayName("保存任务公式")]
    [HttpPut("sync-tasks/{taskCode}/formulas")]
    public async Task<object> SaveFormulas(string taskCode, [FromBody] List<MdpSyncTaskFormulaSaveItem> items)
    {
        var tenantId = _userManager.TenantId;
        items ??= [];
        await _db.Deleteable<MdpSyncTaskFormula>()
            .Where(u => u.TaskCode == taskCode && u.TenantId == tenantId)
            .ExecuteCommandAsync();
        var now = DateTime.Now;
        var rows = items.Where(x => !string.IsNullOrWhiteSpace(x.FormulaCode)).Select((x, i) => new MdpSyncTaskFormula
        {
            TenantId = tenantId,
            TaskCode = taskCode,
            StepCode = x.StepCode,
            FormulaCode = x.FormulaCode.Trim(),
            FormulaName = string.IsNullOrWhiteSpace(x.FormulaName) ? x.FormulaCode.Trim() : x.FormulaName.Trim(),
            MetricCode = x.MetricCode,
            FormulaExpr = x.FormulaExpr,
            FormulaPreview = x.FormulaPreview,
            Direction = string.IsNullOrWhiteSpace(x.Direction) ? "higher_is_better" : x.Direction.Trim(),
            YellowThreshold = x.YellowThreshold,
            RedThreshold = x.RedThreshold,
            VersionNo = x.VersionNo > 0 ? x.VersionNo : 1,
            IsEnabled = x.Enabled ? (byte)1 : (byte)0,
            SortOrder = x.SortOrder > 0 ? x.SortOrder : i + 1,
            Description = x.Description,
            CreateTime = now,
            UpdateTime = now
        }).ToList();
        if (rows.Count > 0)
            await _db.Insertable(rows).ExecuteCommandAsync();
        return new { ok = true, count = rows.Count };
    }
}

public class MdpSyncTaskParamSaveItem
{
    public string? ScopeType { get; set; }
    public string? ScopeCode { get; set; }
    public string ParamKey { get; set; } = string.Empty;
    public string? ParamName { get; set; }
    public string? ParamType { get; set; }
    public string? ParamValue { get; set; }
    public string? DefaultValue { get; set; }
    public bool Required { get; set; }
    public bool Editable { get; set; } = true;
    public int SortOrder { get; set; }
    public string? Description { get; set; }
}

public class MdpSyncTaskFormulaSaveItem
{
    public string? StepCode { get; set; }
    public string FormulaCode { get; set; } = string.Empty;
    public string? FormulaName { get; set; }
    public string? MetricCode { get; set; }
    public string? FormulaExpr { get; set; }
    public string? FormulaPreview { get; set; }
    public string? Direction { get; set; }
    public decimal? YellowThreshold { get; set; }
    public decimal? RedThreshold { get; set; }
    public int VersionNo { get; set; } = 1;
    public bool Enabled { get; set; } = true;
    public int SortOrder { get; set; }
    public string? Description { get; set; }
}