using CMS.Plugin.HIAWms.Domain;
using CMS.Plugin.HIAWms.Domain.WmsContainers;
using CMS.Plugin.HIAWms.Domain.Shared.WmsContainers;
using Microsoft.EntityFrameworkCore;
using Volo.Abp;
using Volo.Abp.EntityFrameworkCore.Modeling;

namespace CMS.Plugin.HIAWms.EntityFrameworkCore.Extensions;

/// <summary>
/// EfCore扩展
/// </summary>
public  static partial class CMSPluginEfCoreExtensions
{
    /// <summary>
    /// Includes the details.
    /// </summary>
    /// <param name="queryable">The queryable.</param>
    /// <param name="include">if set to <c>true</c> [include].</param>
    /// <returns></returns>
    public static IQueryable<WmsContainer> IncludeDetails(this IQueryable<WmsContainer> queryable, bool include = true)
    {
        if (!include)
        {
            return queryable;
        }

        return queryable;
    }

    /// <summary>
    /// Configures the wmscontainer.
    /// </summary>
    /// <param name="builder">The builder.</param>
    public static void ConfigureWmsContainer(this ModelBuilder builder)
    {
        Check.NotNull(builder, nameof(builder));

        builder.Entity<WmsContainer>(b =>
        {
            b.ToTable((CMSPluginDbProperties.DbTablePrefix + "_WmsContainers").ToLower(), CMSPluginDbProperties.DbSchema)
            .HasComment("托盘信息表");

            b.ConfigureByConvention();

            //Properties
            b.Property(x => x.ContainerNo)
                .HasMaxLength(50)
                .IsRequired()
                .HasComment("托盘编号");

            b.Property(x => x.ContainerType)
                .IsRequired()
                .HasComment("托盘类型");

            b.Property(x => x.ContainerStatus)
                .IsRequired()
                .HasComment("托盘状态");

            b.Property(x => x.SpecLength)
                .HasPrecision(18, 2)
                .HasComment("长度");

            b.Property(x => x.SpecWidth)
                .HasPrecision(18, 2)
                .HasComment("宽度");

            b.Property(x => x.SpecHeight)
                .HasPrecision(18, 2)
                .HasComment("高度");

            b.Property(x => x.LimitLength)
                .HasPrecision(18, 2)
                .HasComment("限长");

            b.Property(x => x.LimitWidth)
                .HasPrecision(18, 2)
                .HasComment("限宽");

            b.Property(x => x.LimitHeight)
                .HasPrecision(18, 2)
                .HasComment("限高");

            b.Property(x => x.MaxWeight)
                .HasPrecision(18, 2)
                .HasComment("载重上限");

            b.Property(x => x.ExceptionNumber)
                .HasComment("异常数量");

            b.Property(x => x.MaterialNumber)
                .HasComment("物料数量");

            b.Property(x => x.RedundantField1)
                .HasMaxLength(200)
                .HasComment("冗余字段1 - 预留扩展用途");

            b.Property(x => x.RedundantField2)
                .HasMaxLength(200)
                .HasComment("冗余字段2 - 预留扩展用途");

            b.Property(x => x.RedundantField3)
                .HasMaxLength(200)
                .HasComment("冗余字段3 - 预留扩展用途");

            b.Property(x => x.Sort).HasComment("排序");
            b.Property(x => x.IsDisabled).IsRequired(false).HasComment("是否禁用");
            b.Property(x => x.Remark).HasMaxLength(WmsContainerConsts.MaxRemarkLength).IsRequired(false).HasComment("备注");

            b.HasIndex(u => u.ContainerNo).IsUnique();
            b.HasIndex(u => u.ContainerType);
            b.HasIndex(u => u.ContainerStatus);

            b.ApplyObjectExtensionMappings();
        });
    }
}