AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Controllers/S0/Sales/AdoS0ContractReviewCyclesController.cs

using Admin.NET.Plugin.AiDOP.Dto.S0.Sales;
using Admin.NET.Plugin.AiDOP.Entity.S0.Sales;
using Admin.NET.Plugin.AiDOP.Infrastructure;

namespace Admin.NET.Plugin.AiDOP.Controllers.S0.Sales;

[ApiController]
[Route("api/s0/sales/contract-review-cycles")]
[NonUnify]
public class AdoS0ContractReviewCyclesController : ControllerBase
{
    private readonly SqlSugarRepository<AdoS0ContractReviewCycle> _rep;
    private readonly SqlSugarRepository<AdoS0ContractReviewCycleSyncFlag> _syncRep;
    private readonly SqlSugarRepository<AdoS0ContractReviewCycleBreakdown> _breakdownRep;

    public AdoS0ContractReviewCyclesController(
        SqlSugarRepository<AdoS0ContractReviewCycle> rep,
        SqlSugarRepository<AdoS0ContractReviewCycleSyncFlag> syncRep,
        SqlSugarRepository<AdoS0ContractReviewCycleBreakdown> breakdownRep)
    {
        _rep = rep;
        _syncRep = syncRep;
        _breakdownRep = breakdownRep;
    }

    [HttpGet]
    public async Task<IActionResult> GetPagedAsync([FromQuery] AdoS0ContractReviewCycleQueryDto q)
    {
        if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
        (q.Page, q.PageSize) = PagingGuard.Normalize(q.Page, q.PageSize);

        var query = _rep.AsQueryable()
            .Where(x => x.TenantId == tenantId)
            .WhereIF(q.CompanyRefId.HasValue, x => x.CompanyRefId == q.CompanyRefId!.Value)
            .WhereIF(q.FactoryRefId.HasValue, x => x.FactoryRefId == q.FactoryRefId!.Value)
            .WhereIF(!string.IsNullOrWhiteSpace(q.DomainCode), x => x.DomainCode == q.DomainCode)
            .WhereIF(q.IsActive.HasValue, x => x.IsActive == q.IsActive!.Value);

        var total = await query.CountAsync();
        var list = await query.OrderBy(x => x.OrderNo).Skip((q.Page - 1) * q.PageSize).Take(q.PageSize).ToListAsync();
        return Ok(new { total, page = q.Page, pageSize = q.PageSize, list });
    }

    [HttpGet("{id:long}")]
    public async Task<IActionResult> GetAsync(long id)
    {
        if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
        var item = await _rep.AsQueryable().Where(x => x.Id == id && x.TenantId == tenantId).FirstAsync();
        return item == null ? NotFound() : Ok(item);
    }

    [HttpPost]
    public async Task<IActionResult> CreateAsync([FromBody] AdoS0ContractReviewCycleUpsertDto dto)
    {
        if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
        if (await _rep.IsAnyAsync(x => x.TenantId == tenantId && x.FactoryRefId == dto.FactoryRefId && x.StageCode == dto.StageCode))
            return AdoS0ApiErrors.Conflict(AdoS0ErrorCodes.DuplicateCode, "该工厂下此阶段已存在");

        var entity = new AdoS0ContractReviewCycle
        {
            TenantId = tenantId,
            CompanyRefId = dto.CompanyRefId,
            FactoryRefId = dto.FactoryRefId,
            DomainCode = dto.DomainCode,
            StageCode = dto.StageCode,
            StageName = dto.StageName,
            StdHours = dto.StdHours,
            OrderNo = dto.OrderNo,
            IsActive = dto.IsActive,
            CreateUser = dto.CreateUser,
            CreateTime = DateTime.Now,
        };
        await _rep.AsInsertable(entity).ExecuteReturnEntityAsync();
        return Ok(entity);
    }

    [HttpPut("{id:long}")]
    public async Task<IActionResult> UpdateAsync(long id, [FromBody] AdoS0ContractReviewCycleUpsertDto dto)
    {
        if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
        var entity = await _rep.AsQueryable().Where(x => x.Id == id && x.TenantId == tenantId).FirstAsync();
        if (entity == null) return NotFound();

        if (await _rep.IsAnyAsync(x => x.TenantId == tenantId && x.Id != id && x.FactoryRefId == dto.FactoryRefId && x.StageCode == dto.StageCode))
            return AdoS0ApiErrors.Conflict(AdoS0ErrorCodes.DuplicateCode, "该工厂下此阶段已存在");

        entity.CompanyRefId = dto.CompanyRefId;
        entity.FactoryRefId = dto.FactoryRefId;
        entity.DomainCode = dto.DomainCode;
        entity.StageCode = dto.StageCode;
        entity.StageName = dto.StageName;
        entity.StdHours = dto.StdHours;
        entity.OrderNo = dto.OrderNo;
        entity.IsActive = dto.IsActive;
        entity.UpdateUser = dto.UpdateUser;
        entity.UpdateTime = DateTime.Now;

        await _rep.AsUpdateable(entity).ExecuteCommandAsync();
        return Ok(entity);
    }

    [HttpPatch("{id:long}/toggle-enabled")]
    public async Task<IActionResult> ToggleActiveAsync(long id, [FromBody] AdoS0ContractReviewCycleToggleActiveDto dto)
    {
        if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
        var entity = await _rep.AsQueryable().Where(x => x.Id == id && x.TenantId == tenantId).FirstAsync();
        if (entity == null) return NotFound();
        entity.IsActive = dto.IsActive;
        entity.UpdateTime = DateTime.Now;
        await _rep.AsUpdateable(entity).ExecuteCommandAsync();
        return Ok(entity);
    }

    [HttpDelete("{id:long}")]
    public async Task<IActionResult> DeleteAsync(long id)
    {
        if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
        var item = await _rep.AsQueryable().Where(x => x.Id == id && x.TenantId == tenantId).FirstAsync();
        if (item == null) return NotFound();
        await _rep.DeleteAsync(item);
        return Ok(new { message = "删除成功" });
    }

    /// <summary>
    /// PI 只读配置：合并主阶段 + 意见反馈下钻，仅当工厂同步开关开启时返回数据。
    /// 为 S8 后续接入预留契约（S8-ORDER-REVIEW-PI-FROM-S0-1），本批不消费。
    /// </summary>
    [HttpGet("pi-config")]
    public async Task<IActionResult> GetPiConfigAsync([FromQuery] long factoryRefId)
    {
        if (!AdoS0TenantScope.TryResolveRequired(out var tenantId, out var tenantError)) return tenantError!;
        if (factoryRefId <= 0) return BadRequest(new { message = "factoryRefId 不能为空" });

        var syncFlag = await _syncRep.AsQueryable()
            .Where(x => x.TenantId == tenantId)
            .Where(x => x.FactoryRefId == factoryRefId)
            .FirstAsync();
        var syncEnabled = syncFlag?.IsSyncEnabled ?? false;

        var result = new AdoS0ContractReviewCyclePiConfigDto
        {
            FactoryRefId = factoryRefId,
            SyncEnabled = syncEnabled,
        };

        if (!syncEnabled) return Ok(result);

        var stages = await _rep.AsQueryable()
            .Where(x => x.TenantId == tenantId)
            .Where(x => x.FactoryRefId == factoryRefId && x.IsActive)
            .OrderBy(x => x.OrderNo)
            .ToListAsync();
        result.MainStages = stages.Select(x => new AdoS0ContractReviewCyclePiConfigStageDto
        {
            StageCode = x.StageCode,
            StageName = x.StageName,
            StdHours = x.StdHours,
            OrderNo = x.OrderNo,
        }).ToList();

        var breakdowns = await _breakdownRep.AsQueryable()
            .Where(x => x.TenantId == tenantId)
            .Where(x => x.FactoryRefId == factoryRefId && x.ParentStageCode == "feedback" && x.IsActive)
            .OrderBy(x => x.OrderNo)
            .ToListAsync();
        result.OpinionFeedbackBreakdown = breakdowns.Select(x => new AdoS0ContractReviewCyclePiConfigBreakdownDto
        {
            GroupCode = x.GroupCode,
            GroupName = x.GroupName,
            StdHours = x.StdHours,
            OrderNo = x.OrderNo,
        }).ToList();

        return Ok(result);
    }
}