namespace WCS.Application;

/// <summary>
/// 设备工位服务
/// </summary>
[ApiDescriptionSettings(ApplicationConst.GroupName, Order = 100)]
public class WcsPositionService : IDynamicApiController, ITransient
{
    private readonly SqlSugarRepository<WcsPosition> _WcsPositionRep;
    private readonly SqlSugarRepository<WcsPlc> _wcsPlcRep;
    public WcsPositionService(SqlSugarRepository<WcsPosition> WcsPositionRep, SqlSugarRepository<WcsPlc> wcsPlcRep)
    {
        _WcsPositionRep = WcsPositionRep;
        _wcsPlcRep = wcsPlcRep;
    }

    /// <summary>
    /// 分页查询设备工位
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpPost]
    [ApiDescriptionSettings(Name = "Page")]
    [DisplayName("分页查询设备工位")]
    public async Task<SqlSugarPagedList<WcsPositionOutput>> Page(PageWcsPositionInput input)
    {
        if (input.Field.IsNullOrEmpty())
        {
            input.Field = "u.Id";
            input.Order = "desc";
        }
        input.SearchKey = input.SearchKey?.Trim();
        var query = _WcsPositionRep.AsQueryable()
            .WhereIF(!string.IsNullOrEmpty(input.SearchKey), u =>
                u.Text.Contains(input.SearchKey)
                || u.StationNum.Contains(input.SearchKey)
            )
            .WhereIF(input.DeviceId > 0, u => u.DeviceId == input.DeviceId)
            .WhereIF(!string.IsNullOrWhiteSpace(input.Text), u => u.Text.Contains(input.Text.Trim()))
            //处理外键和TreeSelector相关字段的连接
            .LeftJoin<WcsDevice>((u, deviceid) => u.DeviceId == deviceid.Id)
            .Select((u, deviceid) => new WcsPositionOutput
            {
                Id = u.Id,
                DeviceId = u.DeviceId,
                DeviceIdText = deviceid.Text,
                StationNum = u.StationNum,
                PlcPos = u.PlcPos,
                PosType = u.PosType,
                StringLength = u.StringLength,
                LedIP = u.LedIP,
                Text = u.Text,
                CreateUserId = u.CreateUserId,
                CreateUserName = u.CreateUserName,
                CreateTime = u.CreateTime,
                UpdateUserId = u.UpdateUserId,
                UpdateUserName = u.UpdateUserName,
                UpdateTime = u.UpdateTime,
            });
        return await query.OrderBuilder(input).ToPagedListAsync(input.Page, input.PageSize);
    }

    /// <summary>
    /// 增加设备工位
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpPost]
    [ApiDescriptionSettings(Name = "Add")]
    [DisplayName("增加设备工位")]
    public async Task<long> Add(AddWcsPositionInput input)
    {
        var entity = input.Adapt<WcsPosition>();
        await _WcsPositionRep.InsertAsync(entity);
        return entity.Id;
    }

    /// <summary>
    /// 删除设备工位
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpPost]
    [ApiDescriptionSettings(Name = "Delete")]
    [DisplayName("删除设备工位")]
    public async Task Delete(DeleteWcsPositionInput input)
    {
        var entity = await _WcsPositionRep.GetFirstAsync(u => u.Id == input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002);
        await _WcsPositionRep.FakeDeleteAsync(entity);   //假删除
        //await _WcsPositionRep.DeleteAsync(entity);   //真删除
    }

    /// <summary>
    /// 更新设备工位
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpPost]
    [ApiDescriptionSettings(Name = "Update")]
    [DisplayName("更新设备工位")]
    public async Task Update(UpdateWcsPositionInput input)
    {
        var entity = input.Adapt<WcsPosition>();
        await _WcsPositionRep.AsUpdateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync();
    }

    /// <summary>
    /// 获取设备工位
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpGet]
    [ApiDescriptionSettings(Name = "Detail")]
    [DisplayName("获取设备工位")]
    public async Task<WcsPosition> Detail([FromQuery] QueryByIdWcsPositionInput input)
    {
        return await _WcsPositionRep.GetFirstAsync(u => u.Id == input.Id);
    }

    /// <summary>
    /// 获取设备工位列表
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpGet]
    [ApiDescriptionSettings(Name = "List")]
    [DisplayName("获取设备工位列表")]
    public async Task<List<WcsPositionOutput>> List([FromQuery] PageWcsPositionInput input)
    {
        return await _WcsPositionRep.AsQueryable().Select<WcsPositionOutput>().ToListAsync();
    }

    /// <summary>
    /// 获取设备ID列表
    /// </summary>
    /// <returns></returns>
    [ApiDescriptionSettings(Name = "WcsDeviceDeviceIdDropdown"), HttpGet]
    [DisplayName("获取设备ID列表")]
    public async Task<dynamic> WcsDeviceDeviceIdDropdown()
    {
        return await _WcsPositionRep.Context.Queryable<WcsDevice>()
                .Select(u => new
                {
                    Label = u.Text,
                    Value = u.Id
                }
                ).ToListAsync();
    }

    /// <summary>
    /// 获取设备ID列表
    /// </summary>
    /// <returns></returns>
    [ApiDescriptionSettings(Name = "WcsPlcIdDropdown"), HttpGet]
    [DisplayName("获取设备ID列表")]
    public async Task<dynamic> WcsPlcIdDropdown()
    {
        return await _wcsPlcRep.Context.Queryable<WcsPlc>()
                .Select(u => new
                {
                    Label = u.Text,
                    Value = u.Id
                }
                ).ToListAsync();
    }


}