/***********************************************************************
 *            Project: baifenBinfa
 *        ProjectName: 百分兵法管理系统                               
 *                Web: http://chuanyin.com                     
 *             Author:                                        
 *              Email:                               
 *         CreateTime: 202403/02   
 *        Description: 暂无
 ***********************************************************************/

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.IO;
using System.Linq;
using System.Linq.Expressions;
using System.Threading.Tasks;
using CoreCms.Net.Caching.AutoMate.RedisCache;
using CoreCms.Net.Configuration;
using CoreCms.Net.Filter;
using CoreCms.Net.IServices;
using CoreCms.Net.Loging;
using CoreCms.Net.Model.Entities;
using CoreCms.Net.Model.Entities.Expression;
using CoreCms.Net.Model.FromBody;
using CoreCms.Net.Model.ViewModels.UI;
using CoreCms.Net.Utility.Extensions;
using CoreCms.Net.Utility.Helper;
using CoreCms.Net.Web.Admin.Infrastructure;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Mvc;
using NPOI.HSSF.UserModel;
using SqlSugar;
using Yitter.IdGenerator;

namespace CoreCms.Net.Web.Admin.Controllers
{
    /// <summary>
    ///     商品表
    /// </summary>
    [Description("商品表")]
    [Route("api/[controller]/[action]")]
    [ApiController]
    [RequiredErrorForAdmin]
    [Authorize(Permissions.Name)]
    public class CoreCmsGoodsController : ControllerBase
    {
        private readonly ICoreCmsBrandServices _brandServices;
        private readonly ICoreCmsGoodsCategoryExtendServices _categoryExtendServices;
        private readonly ICoreCmsGoodsCategoryServices _coreCmsGoodsCategoryServices;
        private readonly ICoreCmsGoodsServices _coreCmsGoodsServices;
        private readonly ICoreCmsGoodsGradeServices _goodsGradeServices;
        private readonly ICoreCmsGoodsParamsServices _goodsParamsServices;
        private readonly ICoreCmsGoodsTypeSpecServices _goodsTypeSpecServices;
        private readonly ICoreCmsLabelServices _labelServices;
        private readonly ICoreCmsProductsServices _productsServices;
        private readonly ICoreCmsSettingServices _settingServices;
        private readonly ICoreCmsGoodsTypeSpecValueServices _typeSpecValueServices;
        private readonly ICoreCmsUserGradeServices _userGradeServices;
        private readonly ICoreCmsProductsDistributionServices _productsDistributionServices;
        private readonly IWebHostEnvironment _webHostEnvironment;
        private readonly IRedisOperationRepository _redisOperationRepository;
        private readonly ICoreCmsGoodsCategoryExtendServices _goodsCategoryExtendServices;


        /// <summary>
        ///     构造函数
        /// </summary>
        public CoreCmsGoodsController(IWebHostEnvironment webHostEnvironment
            , ICoreCmsGoodsServices coreCmsGoodsServices
            , ICoreCmsSettingServices settingServices
            , ICoreCmsBrandServices brandServices
            , ICoreCmsGoodsCategoryServices coreCmsGoodsCategoryServices
            , ICoreCmsUserGradeServices userGradeServices
            , ICoreCmsGoodsParamsServices goodsParamsServices
            , ICoreCmsGoodsTypeSpecValueServices typeSpecValueServices
            , ICoreCmsGoodsGradeServices goodsGradeServices
            , ICoreCmsProductsServices productsServices
            , ICoreCmsGoodsCategoryExtendServices categoryExtendServices
            , ICoreCmsLabelServices labelServices
            , ICoreCmsProductsDistributionServices productsDistributionServices
            , ICoreCmsGoodsTypeSpecServices goodsTypeSpecServices, IRedisOperationRepository redisOperationRepository, ICoreCmsGoodsCategoryExtendServices goodsCategoryExtendServices)
        {
            _webHostEnvironment = webHostEnvironment;
            _coreCmsGoodsServices = coreCmsGoodsServices;
            _settingServices = settingServices;
            _brandServices = brandServices;
            _coreCmsGoodsCategoryServices = coreCmsGoodsCategoryServices;
            _userGradeServices = userGradeServices;
            _goodsParamsServices = goodsParamsServices;
            _typeSpecValueServices = typeSpecValueServices;
            _goodsGradeServices = goodsGradeServices;
            _productsServices = productsServices;
            _categoryExtendServices = categoryExtendServices;
            _labelServices = labelServices;
            _productsDistributionServices = productsDistributionServices;
            _goodsTypeSpecServices = goodsTypeSpecServices;
            _redisOperationRepository = redisOperationRepository;
            _goodsCategoryExtendServices = goodsCategoryExtendServices;
        }

        #region 获取列表============================================================

        // POST: Api/CoreCmsGoods/GetPageList
        /// <summary>
        ///     获取列表
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [Description("获取列表")]
        public async Task<AdminUiCallBack> GetPageList()
        {
            var jm = new AdminUiCallBack();
            var pageCurrent = Request.Form["page"].FirstOrDefault().ObjectToInt(1);
            var pageSize = Request.Form["limit"].FirstOrDefault().ObjectToInt(30);
            var where = PredicateBuilder.True<CoreCmsGoods>();
            //获取排序字段
            var orderField = Request.Form["orderField"].FirstOrDefault();
            Expression<Func<CoreCmsGoods, object>> orderEx = orderField switch
            {
                "id" => p => p.id,
                "bn" => p => p.bn,
                "name" => p => p.name,
                "brief" => p => p.brief,
                "price" => p => p.price,
                "costprice" => p => p.costprice,
                "mktprice" => p => p.mktprice,
                "images" => p => p.images,
                "goodsCategoryId" => p => p.goodsCategoryId,
                "goodsTypeId" => p => p.goodsTypeId,
                "brandId" => p => p.brandId,
                "isNomalVirtual" => p => p.isNomalVirtual,
                "isMarketable" => p => p.isMarketable,
                "stock" => p => p.stock,
                "freezeStock" => p => p.freezeStock,
                "weight" => p => p.weight,
                "unit" => p => p.unit,
                "intro" => p => p.intro,
                "spesDesc" => p => p.spesDesc,
                "parameters" => p => p.parameters,
                "commentsCount" => p => p.commentsCount,
                "viewCount" => p => p.viewCount,
                "buyCount" => p => p.buyCount,
                "uptime" => p => p.uptime,
                "downtime" => p => p.downtime,
                "sort" => p => p.sort,
                "labelIds" => p => p.labelIds,
                "newSpec" => p => p.newSpec,
                "createTime" => p => p.createTime,
                "updateTime" => p => p.updateTime,
                "isRecommend" => p => p.isRecommend,
                "isHot" => p => p.isHot,
                "isDel" => p => p.isDel,
                _ => p => p.id
            };

            //设置排序方式
            var orderDirection = Request.Form["orderDirection"].FirstOrDefault();
            var orderBy = orderDirection switch
            {
                "asc" => OrderByType.Asc,
                "desc" => OrderByType.Desc,
                _ => OrderByType.Desc
            };
            //查询筛选

            //商品序列
            var id = Request.Form["id"].FirstOrDefault().ObjectToInt(0);
            if (id > 0) @where = @where.And(p => p.id == id);
            //商品编码 nvarchar
            var bn = Request.Form["bn"].FirstOrDefault();
            if (!string.IsNullOrEmpty(bn)) @where = @where.And(p => p.bn.Contains(bn));
            //商品名称 nvarchar
            var name = Request.Form["name"].FirstOrDefault();
            if (!string.IsNullOrEmpty(name)) @where = @where.And(p => p.name.Contains(name));
            //商品分类ID 关联category.id int
            var selectTreeSelectNodeId = Request.Form["selectTree_select_nodeId"].FirstOrDefault().ObjectToInt(0);
            if (selectTreeSelectNodeId > 0) @where = @where.And(p => p.goodsCategoryId == selectTreeSelectNodeId);
            //商品分类ID 关联category.id int

            var goodsCategoryId = Request.Form["goodsCategoryId"].FirstOrDefault().ObjectToInt(0);
            if (goodsCategoryId > 0)
            {
                //获取全部数据缓存
                var categories = await _coreCmsGoodsCategoryServices.QueryAsync(true, true);
                var ids = GoodsHelper.GetChildIds(categories, goodsCategoryId);

                //扩展分类
                var extends = await _goodsCategoryExtendServices.QueryListByClauseAsync(p => p.goodsCategroyId == goodsCategoryId);
                if (extends.Any())
                {
                    var extGoodIds = extends.Select(p => p.goodsId).ToList();
                    where = where.And(p => ids.Contains(p.goodsCategoryId) || extGoodIds.Contains(p.id));
                }
                else
                {
                    where = where.And(p => ids.Contains(p.goodsCategoryId));
                }
            }


            //商品类别ID 关联goods_type.id int
            var goodsTypeId = Request.Form["goodsTypeId"].FirstOrDefault().ObjectToInt(0);
            if (goodsTypeId > 0) @where = @where.And(p => p.goodsTypeId == goodsTypeId);
            //品牌ID 关联brand.id int
            var brandId = Request.Form["brandId"].FirstOrDefault().ObjectToInt(0);
            if (brandId > 0) @where = @where.And(p => p.brandId == brandId);
            //是否上架 bit
            var isMarketable = Request.Form["isMarketable"].FirstOrDefault();
            if (!string.IsNullOrEmpty(isMarketable) && isMarketable.ToLowerInvariant() == "true")
                @where = @where.And(p => p.isMarketable);
            else if (!string.IsNullOrEmpty(isMarketable) && isMarketable.ToLowerInvariant() == "false")
                @where = @where.And(p => p.isMarketable == false);
            //是否推荐 bit
            var isRecommend = Request.Form["isRecommend"].FirstOrDefault();
            if (!string.IsNullOrEmpty(isRecommend) && isRecommend.ToLowerInvariant() == "true")
                @where = @where.And(p => p.isRecommend);
            else if (!string.IsNullOrEmpty(isRecommend) && isRecommend.ToLowerInvariant() == "false")
                @where = @where.And(p => p.isRecommend == false);
            //是否热门 bit
            var isHot = Request.Form["isHot"].FirstOrDefault();
            if (!string.IsNullOrEmpty(isHot) && isHot.ToLowerInvariant() == "true")
                @where = @where.And(p => p.isHot);
            else if (!string.IsNullOrEmpty(isHot) && isHot.ToLowerInvariant() == "false")
                @where = @where.And(p => p.isHot == false);
            //是否报警
            var warn = Request.Form["warn"].FirstOrDefault();
            if (!string.IsNullOrEmpty(warn) && warn.ToLowerInvariant() == "true")
            {
                //获取库存
                var allConfigs = await _settingServices.GetConfigDictionaries();
                var kc = CommonHelper.GetConfigDictionary(allConfigs, SystemSettingConstVars.GoodsStocksWarn);
                if (kc != null)
                {
                    var kcNumer = kc.ObjectToInt();
                    where = where.And(p => p.stock <= kcNumer && p.isDel == false && p.isMarketable);
                }
                else
                {
                    where = where.And(p => p.stock <= 0 && p.isDel == false && p.isMarketable);
                }
            }

            where = where.And(p => p.isDel == false);

            //获取数据
            var list = await _coreCmsGoodsServices.QueryPageAsync(where, orderEx, orderBy, pageCurrent, pageSize);

            if (list != null && list.Any())
            {
                var labels = await _labelServices.QueryAsync(true, true);

                foreach (var item in list)
                    if (!string.IsNullOrEmpty(item.labelIds))
                    {
                        var ids = CommonHelper.StringToIntArray(item.labelIds);
                        item.labels = labels.Where(p => ids.Contains(p.id)).ToList();
                    }
            }

            //返回数据
            jm.data = list;
            jm.code = 0;
            jm.count = list.TotalCount;
            jm.msg = "数据调用成功!";
            return jm;
        }

        #endregion

        #region 首页数据============================================================

        // POST: Api/CoreCmsGoods/GetIndex
        /// <summary>
        ///     首页数据
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [Description("首页数据")]
        public async Task<AdminUiCallBack> GetIndex()
        {
            //返回数据
            var jm = new AdminUiCallBack { code = 0 };

            var totalGoods = await _coreCmsGoodsServices.GetCountAsync(p => p.id > 0 && p.isDel == false);
            var totalMarketableUp = await _coreCmsGoodsServices.GetCountAsync(p => p.isMarketable && p.isDel == false);
            var totalMarketableDown = await _coreCmsGoodsServices.GetCountAsync(p => p.isMarketable == false && p.isDel == false);

            //获取库存
            var allConfigs = await _settingServices.GetConfigDictionaries();

            var kc = CommonHelper.GetConfigDictionary(allConfigs, SystemSettingConstVars.GoodsStocksWarn);
            var totalWarn = 0;
            if (kc != null)
            {
                var kcNumer = kc.ObjectToInt();
                totalWarn = await _coreCmsGoodsServices.GetCountAsync(p =>
                    p.stock <= kcNumer && p.isDel == false && p.isMarketable);
            }
            else
            {
                totalWarn = await _coreCmsGoodsServices.GetCountAsync(p =>
                    p.stock <= 0 && p.isDel == false && p.isMarketable);
            }

            //获取商品分类
            var categories = await _coreCmsGoodsCategoryServices.QueryListByClauseAsync(p => p.isShow, p => p.sort, OrderByType.Asc, true, true);
            //获取品牌
            var brands = await _brandServices.QueryAsync(true, true);

            //获取商品经销方式
            var productsDistributionType = EnumHelper.EnumToList<GlobalEnumVars.ProductsDistributionType>();

            jm.data = new
            {
                totalGoods,
                totalMarketableUp,
                totalMarketableDown,
                totalWarn,
                categories = GoodsHelper.GetTree(categories),
                categoriesAll = categories,
                brands,
                productsDistributionType
            };

            return jm;
        }

        #endregion

        #region 创建数据============================================================

        // POST: Api/CoreCmsGoods/GetCreate
        /// <summary>
        ///     创建数据
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [Description("创建数据")]
        public async Task<AdminUiCallBack> GetCreate()
        {
            //返回数据
            var jm = new AdminUiCallBack { code = 0 };

            //获取商品分类
            var categories = await _coreCmsGoodsCategoryServices.QueryListByClauseAsync(p => p.isShow, p => p.sort, OrderByType.Asc, true, true);
            //获取参数列表
            var paramsList = await _goodsParamsServices.QueryListByClauseAsync(p => p.id > 0, p => p.id, OrderByType.Desc, true, true);
            //获取SKU列表
            var skuList = await _goodsTypeSpecServices.QueryListByClauseAsync(p => p.id > 0, p => p.id, OrderByType.Desc, true, true);
            //获取品牌
            var brands = await _brandServices.QueryListByClauseAsync(p => p.id > 0 && p.isShow == true, p => p.id, OrderByType.Desc, true, true);
            //获取用户等级
            var userGrade = await _userGradeServices.QueryAsync();

            //获取商品经销enum
            var productsDistributionType = EnumHelper.EnumToList<GlobalEnumVars.ProductsDistributionType>();

            jm.data = new
            {
                categories = GoodsHelper.GetTree(categories, false),
                brands,
                userGrade,
                productsDistributionType,
                paramsList,
                skuList
            };

            return jm;
        }

        #endregion

        #region 创建提交============================================================

        // POST: Api/CoreCmsGoods/DoCreate
        /// <summary>
        ///     创建提交
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("创建提交")]
        public async Task<AdminUiCallBack> DoCreate([FromBody] FMGoodsInsertModel entity)
        {
            var jm = await _coreCmsGoodsServices.InsertAsync(entity);
            return jm;
        }

        #endregion

        #region 编辑数据============================================================

        // POST: Api/CoreCmsGoods/GetEdit
        /// <summary>
        ///     编辑数据
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [Description("编辑数据")]
        public async Task<AdminUiCallBack> GetEdit(int id)
        {
            var jm = new AdminUiCallBack();

            var model = await _coreCmsGoodsServices.QueryByIdAsync(id);
            if (model == null)
            {
                jm.msg = "不存在此信息";
                jm.data = id;
                return jm;
            }

            jm.code = 0;

            //获取商品分类
            var categories = await _coreCmsGoodsCategoryServices.QueryListByClauseAsync(p => p.isShow, p => p.sort, OrderByType.Asc, true, true);
            //获取用户等级
            var userGrade = await _userGradeServices.QueryAsync();
            //用户价格体系
            var goodsGrades = await _goodsGradeServices.QueryListByClauseAsync(p => p.goodsId == model.id);
            //货品信息
            var products = await _productsServices.QueryListByClauseAsync(p => p.goodsId == model.id && p.isDel == false);
            //扩展信息
            var categoryExtend = await _categoryExtendServices.QueryListByClauseAsync(p => p.goodsId == model.id);
            //获取商品经销enum
            var productsDistributionType = EnumHelper.EnumToList<GlobalEnumVars.ProductsDistributionType>();

            //获取参数列表
            var paramsList = await _goodsParamsServices.QueryListByClauseAsync(p => p.id > 0, p => p.id, OrderByType.Desc, true, true);
            //获取SKU列表
            var skuList = await _goodsTypeSpecServices.QueryListByClauseAsync(p => p.id > 0, p => p.id, OrderByType.Desc, true, true);
            //获取品牌
            var brands = await _brandServices.QueryListByClauseAsync(p => p.id > 0 && p.isShow == true, p => p.id, OrderByType.Desc, true, true);


            if (products != null && products.Any())
            {
                var pIds = products.Select(p => p.id).ToList();
                if (pIds.Any())
                {
                    // 获取商品经销明细
                    var pds = await _productsDistributionServices.QueryListByClauseAsync(p => pIds.Contains(p.productsId), p => p.id, OrderByType.Asc);
                    products.ForEach(p =>
                    {
                        foreach (var o in pds.Where(o => o.productsId == p.id))
                        {
                            p.levelOne = o.levelOne;
                            p.levelTwo = o.levelTwo;
                            p.levelThree = o.levelThree;
                        }
                    });
                    jm.otherData = pds;
                }

            }

            //获取参数信息
            var goodsTypeSpec = new List<CoreCmsGoodsTypeSpec>();
            var goodsParams = new List<CoreCmsGoodsParams>();

            //获取参数
            if (!string.IsNullOrEmpty(model.goodsParamsIds))
            {
                var paramsIds = Utility.Helper.CommonHelper.StringToIntArray(model.goodsParamsIds);
                goodsParams = await _goodsParamsServices.QueryListByClauseAsync(p => paramsIds.Contains(p.id));
            }

            //获取属性
            if (!string.IsNullOrEmpty(model.goodsSkuIds))
            {
                var specIds = Utility.Helper.CommonHelper.StringToIntArray(model.goodsSkuIds);
                var typeSpecs = skuList.Where(p => specIds.Contains(p.id)).ToList();
                var typeSpecValues = await _typeSpecValueServices.QueryListByClauseAsync(p => specIds.Contains(p.specId));
                typeSpecs.ForEach(p =>
                {
                    p.specValues = typeSpecValues.Where(o => o.specId == p.id).ToList();
                });
                goodsTypeSpec = typeSpecs;
            }

            jm.data = new
            {
                model,
                categories = GoodsHelper.GetTree(categories, false),
                brands,
                userGrade,
                goodsGrades,
                products,
                categoryExtend,
                goodsTypeSpec,
                goodsParams,
                productsDistributionType,
                paramsList,
                skuList
            };


            return jm;
        }

        #endregion

        #region 编辑提交============================================================

        // POST: Admins/CoreCmsGoods/Edit
        /// <summary>
        ///     编辑提交
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("编辑提交")]
        public async Task<AdminUiCallBack> DoEdit([FromBody] FMGoodsInsertModel entity)
        {
            var jm = await _coreCmsGoodsServices.UpdateAsync(entity);
            return jm;
        }

        #endregion

        #region 删除数据============================================================

        // POST: Api/CoreCmsGoods/DoDelete/10
        /// <summary>
        ///     单选删除
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("单选删除")]
        public async Task<AdminUiCallBack> DoDelete([FromBody] FMIntId entity)
        {
            var jm = new AdminUiCallBack();

            var model = await _coreCmsGoodsServices.QueryByIdAsync(entity.id);
            if (model == null)
            {
                jm.msg = GlobalConstVars.DataisNo;
                return jm;
            }

            model.isDel = true;
            //假删除
            var bl = await _coreCmsGoodsServices.UpdateAsync(model);
            if (bl)
            {
                await _productsServices.UpdateAsync(p => new CoreCmsProducts() { isDel = true },
                    p => p.goodsId == model.id);
                await _redisOperationRepository.LikeRemoveAsync("SqlSugarDataCache.GoodListDTO." + "*");
            }
            jm.code = bl ? 0 : 1;
            jm.msg = bl ? GlobalConstVars.DeleteSuccess : GlobalConstVars.DeleteFailure;
            return jm;

        }

        #endregion

        #region 预览数据============================================================

        // POST: Api/CoreCmsGoods/GetDetails/10
        /// <summary>
        ///     预览数据
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("预览数据")]
        public async Task<AdminUiCallBack> GetDetails([FromBody] FMIntId entity)
        {
            var jm = new AdminUiCallBack();

            var model = await _coreCmsGoodsServices.QueryByIdAsync(entity.id);
            if (model == null)
            {
                jm.msg = "不存在此信息";
                jm.data = entity.id;
                return jm;
            }

            jm.code = 0;

            //获取商品分类
            var categories = await _coreCmsGoodsCategoryServices.QueryListByClauseAsync(p => p.isShow, p => p.sort, OrderByType.Asc, true, true);

            //获取用户等级
            var userGrade = await _userGradeServices.QueryAsync();
            //用户价格体系
            var goodsGrades = await _goodsGradeServices.QueryListByClauseAsync(p => p.goodsId == model.id);
            //货品信息
            var products =
                await _productsServices.QueryListByClauseAsync(p => p.goodsId == model.id && p.isDel == false);
            //扩展信息
            var categoryExtend = await _categoryExtendServices.QueryListByClauseAsync(p => p.goodsId == model.id);
            //获取商品经销enum
            var productsDistributionType = EnumHelper.EnumToList<GlobalEnumVars.ProductsDistributionType>();


            //获取参数列表
            var paramsList = await _goodsParamsServices.QueryListByClauseAsync(p => p.id > 0, p => p.id, OrderByType.Desc, true, true);
            //获取SKU列表
            var skuList = await _goodsTypeSpecServices.QueryListByClauseAsync(p => p.id > 0, p => p.id, OrderByType.Desc, true, true);

            //获取品牌
            var brands = await _brandServices.QueryListByClauseAsync(p => p.id > 0 && p.isShow == true, p => p.id, OrderByType.Desc, true, true);


            if (products != null && products.Any())
            {
                var pIds = products.Select(p => p.id).ToList();
                if (pIds.Any())
                {
                    // 获取商品经销明细
                    var pds = await _productsDistributionServices.QueryListByClauseAsync(p => pIds.Contains(p.productsId), p => p.id, OrderByType.Asc);
                    products.ForEach(p =>
                    {
                        foreach (var o in pds.Where(o => o.productsId == p.id))
                        {
                            p.levelOne = o.levelOne;
                            p.levelTwo = o.levelTwo;
                            p.levelThree = o.levelThree;
                        }
                    });
                    jm.otherData = pds;
                }

            }

            //获取参数信息
            var goodsTypeSpec = new List<CoreCmsGoodsTypeSpec>();
            var goodsParams = new List<CoreCmsGoodsParams>();

            //获取参数
            if (!string.IsNullOrEmpty(model.goodsParamsIds))
            {
                var paramsIds = Utility.Helper.CommonHelper.StringToIntArray(model.goodsParamsIds);
                goodsParams = await _goodsParamsServices.QueryListByClauseAsync(p => paramsIds.Contains(p.id));
            }

            //获取属性
            if (!string.IsNullOrEmpty(model.goodsSkuIds))
            {
                var specIds = Utility.Helper.CommonHelper.StringToIntArray(model.goodsSkuIds);
                var typeSpecs = await _goodsTypeSpecServices.QueryListByClauseAsync(p => specIds.Contains(p.id));
                var typeSpecValues = await _typeSpecValueServices.QueryListByClauseAsync(p => specIds.Contains(p.specId));
                typeSpecs.ForEach(p =>
                {
                    p.specValues = typeSpecValues.Where(o => o.specId == p.id).ToList();
                });
                goodsTypeSpec = typeSpecs;
            }

            jm.data = new
            {
                model,
                categories = GoodsHelper.GetTree(categories, false),
                brands,
                userGrade,
                goodsGrades,
                products,
                categoryExtend,
                goodsTypeSpec,
                goodsParams,
                productsDistributionType,
                paramsList,
                skuList
            };


            return jm;
        }

        #endregion

        #region 设置是否虚拟商品============================================================

        // POST: Api/CoreCmsGoods/DoSetisNomalVirtual/10
        /// <summary>
        ///     设置是否虚拟商品
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("设置是否虚拟商品")]
        public async Task<AdminUiCallBack> DoSetisNomalVirtual([FromBody] FMUpdateBoolDataByIntId entity)
        {
            var jm = new AdminUiCallBack();

            var oldModel = await _coreCmsGoodsServices.QueryByIdAsync(entity.id);
            if (oldModel == null)
            {
                jm.msg = "不存在此信息";
                return jm;
            }

            oldModel.isNomalVirtual = entity.data;

            var bl = await _coreCmsGoodsServices.UpdateAsync(oldModel);
            jm.code = bl ? 0 : 1;
            jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;

            return jm;
        }

        #endregion

        #region 设置是否上架============================================================

        // POST: Api/CoreCmsGoods/DoSetisMarketable/10
        /// <summary>
        ///     设置是否上架
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("设置是否上架")]
        public async Task<AdminUiCallBack> DoSetisMarketable([FromBody] FMUpdateBoolDataByIntId entity)
        {
            var jm = new AdminUiCallBack();

            var oldModel = await _coreCmsGoodsServices.QueryByIdAsync(entity.id);
            if (oldModel == null)
            {
                jm.msg = "不存在此信息";
                return jm;
            }

            oldModel.isMarketable = entity.data;

            var bl = await _coreCmsGoodsServices.UpdateAsync(oldModel);
            jm.code = bl ? 0 : 1;
            jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;

            return jm;
        }

        #endregion

        #region 设置是否推荐============================================================

        // POST: Api/CoreCmsGoods/DoSetisRecommend/10
        /// <summary>
        ///     设置是否推荐
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("设置是否推荐")]
        public async Task<AdminUiCallBack> DoSetisRecommend([FromBody] FMUpdateBoolDataByIntId entity)
        {
            var jm = new AdminUiCallBack();

            var oldModel = await _coreCmsGoodsServices.QueryByIdAsync(entity.id);
            if (oldModel == null)
            {
                jm.msg = "不存在此信息";
                return jm;
            }

            oldModel.isRecommend = entity.data;

            var bl = await _coreCmsGoodsServices.UpdateAsync(oldModel);
            jm.code = bl ? 0 : 1;
            jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;

            return jm;
        }

        #endregion

        #region 设置是否热门============================================================

        // POST: Api/CoreCmsGoods/DoSetisHot/10
        /// <summary>
        ///     设置是否热门
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("设置是否热门")]
        public async Task<AdminUiCallBack> DoSetisHot([FromBody] FMUpdateBoolDataByIntId entity)
        {
            var jm = new AdminUiCallBack();

            var oldModel = await _coreCmsGoodsServices.QueryByIdAsync(entity.id);
            if (oldModel == null)
            {
                jm.msg = "不存在此信息";
                return jm;
            }

            oldModel.isHot = entity.data;

            var bl = await _coreCmsGoodsServices.UpdateAsync(oldModel);
            jm.code = bl ? 0 : 1;
            jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;

            return jm;
        }

        #endregion

        #region 设置是否删除============================================================

        // POST: Api/CoreCmsGoods/DoSetisDel/10
        /// <summary>
        ///     设置是否删除
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("设置是否删除")]
        public async Task<AdminUiCallBack> DoSetisDel([FromBody] FMUpdateBoolDataByIntId entity)
        {
            var jm = new AdminUiCallBack();

            var oldModel = await _coreCmsGoodsServices.QueryByIdAsync(entity.id);
            if (oldModel == null)
            {
                jm.msg = "不存在此信息";
                return jm;
            }

            oldModel.isDel = entity.data;

            var bl = await _coreCmsGoodsServices.UpdateAsync(oldModel);
            jm.code = bl ? 0 : 1;
            jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;

            return jm;
        }

        #endregion

        #region 获取商品SKU明细============================================================

        // POST: Api/CoreCmsGoods/GetSkuDetail/10
        /// <summary>
        ///     获取商品SKU明细
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("获取商品SKU明细")]
        public async Task<AdminUiCallBack> GetSkuDetail([FromBody] FMArrayIntIds entity)
        {
            var jm = new AdminUiCallBack();

            if (entity.id.Length <= 0)
            {
                jm.msg = "请提交SKU模型";
                return jm;
            }

            var typeSpecs = await _goodsTypeSpecServices.QueryListByClauseAsync(p => entity.id.Contains(p.id));
            var typeSpecValues = await _typeSpecValueServices.QueryListByClauseAsync(p => entity.id.Contains(p.specId));
            typeSpecs.ForEach(p => { p.specValues = typeSpecValues.Where(o => o.specId == p.id).ToList(); });

            jm.data = new { goodsTypeSpec = typeSpecs };

            var bl = true;
            jm.code = bl ? 0 : 1;
            jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;

            return jm;
        }

        #endregion

        #region 根据属性值生成货品html===================================================

        // POST: Api/CoreCmsGoods/GetSpecHtml
        /// <summary>
        ///     根据属性值生成货品html
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("根据属性值生成货品html")]
        public AdminUiCallBack GetSpecHtml([FromBody] FmSerializeArray model)
        {
            var jm = new AdminUiCallBack();

            var list = model.entity;
            if (!list.Any())
            {
                jm.msg = "提交数据获取失败";
                return jm;
            }

            var newSpecs = list.Where(p => p.name.Contains("newSpec&&")).ToList();
            foreach (var t in newSpecs)
            {
                t.value = t.value.Trim();
                if (GoodsHelper.FilterChar(t.value) == false) continue;
                jm.msg = "自定义规格不符合支持规则格式";
                return jm;
            }

            var oldProducts = list.Where(p => p.name.Contains("product[spesDesc][]")).Select(p => p.value).ToList();

            //if (entity.value.GroupBy(n => n).Any(c => c.Count() > 1))
            //{
            //    jm.msg = "属性值不允许有相同"; return jm;
            //}

            jm.msg = "数据获取成功";

            //修改后的所有属性数据
            var newSpecStr = string.Empty;
            var newSpec = list.Where(p => p.name.Contains("newSpec")).ToList();
            if (newSpec.Any())
            {
                newSpec.ForEach(p =>
                {
                    p.name = p.name.Replace("newSpec&&", "");
                    newSpecStr += p.name + ":" + p.value + "|";
                });
                newSpecStr = newSpecStr.Remove(newSpecStr.Length - 1, 1);
            }

            //选择后已经修改的属性数据
            var selectSpecStr = string.Empty;
            var selectSpec = list.Where(p => p.name.Contains("selectSpec")).ToList();
            if (selectSpec.Any())
            {
                selectSpec.ForEach(p =>
                {
                    p.name = p.name.Replace("selectSpec&&", "");
                    selectSpecStr += p.name + ":" + p.value + "|";
                });
                selectSpecStr = selectSpecStr.Remove(selectSpecStr.Length - 1, 1);
            }

            if (selectSpec.Any())
            {
                var newSelectSpec = selectSpec;
                newSelectSpec.ForEach(p =>
                {
                    var id = p.name.Split("&&")[0];
                    var name = p.name.Split("&&")[1];
                    p.name = name;

                    var newValue = newSpec.Find(p => p.name == id);
                    p.value = newValue.value;
                });

                //生成商品规格sku
                var arrayList = newSelectSpec.Select((x, i) => new { Index = i, Value = x })
                    .GroupBy(x => x.Value.name)
                    .Select(x => x.Select(v => v.Value).ToList())
                    .ToList();
                var sku = new string[arrayList.Count][];
                var arrayListIndex = 0;
                arrayList.ForEach(p =>
                {
                    var arr = new string[p.Count];
                    for (var index = 0; index < p.Count; index++) arr[index] = p[index].name + ":" + p[index].value;
                    sku[arrayListIndex] = arr;
                    arrayListIndex++;
                });
                var skuArray = SkuHelper.process(sku);
                //生成货品列表
                var products = new List<CoreCmsProducts>();
                var count = 0;
                foreach (var array in skuArray)
                {
                    if (oldProducts.Any() && oldProducts.Contains(array))
                    {
                        continue;
                    }
                    var obj = new CoreCmsProducts();

                    if (count == 0) obj.isDefalut = true;
                    //var sn = list.Find(p => p.name == "goods[sn]");
                    obj.sn = "SN" + YitIdHelper.NextId();
                    var price = list.Find(p => p.name == "goods[price]");
                    obj.price = price != null && !string.IsNullOrEmpty(price.value)
                        ? Convert.ToDecimal(price.value)
                        : 0;
                    var costprice = list.Find(p => p.name == "goods[costprice]");
                    obj.costprice = costprice != null && !string.IsNullOrEmpty(costprice.value)
                        ? Convert.ToDecimal(costprice.value)
                        : 0;
                    var mktprice = list.Find(p => p.name == "goods[mktprice]");
                    obj.mktprice = mktprice != null && !string.IsNullOrEmpty(mktprice.value)
                        ? Convert.ToDecimal(mktprice.value)
                        : 0;
                    var stock = list.Find(p => p.name == "goods[stock]");
                    obj.stock = stock != null && !string.IsNullOrEmpty(stock.value)
                        ? Convert.ToInt16(stock.value)
                        : 9999;
                    obj.spesDesc = array;
                    products.Add(obj);

                    count++;
                }

                jm.data = new
                {
                    products,
                    arrayList,
                    skuArray,
                    sku,
                    newSpecStr,
                    selectSpecStr
                };
            }

            var bl = true;
            jm.code = bl ? 0 : 1;
            jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;


            return jm;
        }

        #endregion

        #region 批量删除============================================================

        // POST: Api/CoreCmsGoods/DoBatchDelete/10,11,20
        /// <summary>
        ///     批量删除
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("批量删除")]
        public async Task<AdminUiCallBack> DoBatchDelete([FromBody] FMArrayIntIds entity)
        {
            var jm = await _coreCmsGoodsServices.DeleteByIdsAsync(entity.id);
            return jm;
        }

        #endregion

        #region 批量上架============================================================

        // POST: Api/CoreCmsGoods/DoBatchMarketableUp/10,11,20
        /// <summary>
        ///     批量上架
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("批量上架")]
        public async Task<AdminUiCallBack> DoBatchMarketableUp([FromBody] FMArrayIntIds entity)
        {
            var jm = await _coreCmsGoodsServices.DoBatchMarketableUp(entity.id);
            return jm;
        }

        #endregion

        #region 批量下架============================================================

        // POST: Api/CoreCmsGoods/DoBatchMarketableDown/10,11,20
        /// <summary>
        ///     批量下架
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("批量下架")]
        public async Task<AdminUiCallBack> DoBatchMarketableDown([FromBody] FMArrayIntIds entity)
        {
            var jm = await _coreCmsGoodsServices.DoBatchMarketableDown(entity.id);
            return jm;
        }

        #endregion


        #region 批量修改价格===========================================================

        // POST: Api/CoreCmsGoods/GetBatchModifyPrice
        /// <summary>
        ///     批量修改价格
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("批量修改价格")]
        public AdminUiCallBack GetBatchModifyPrice([FromBody] FMArrayIntIds entity)
        {
            var jm = new AdminUiCallBack();

            var priceType = EnumHelper.EnumToList<GlobalEnumVars.PriceType>();
            var userGrade = _userGradeServices.Query();
            if (userGrade.Any())
                userGrade.ForEach(p =>
                {
                    priceType.Add(new EnumEntity
                    {
                        description = p.title,
                        title = "grade_price_" + p.id,
                        value = 10000 + p.id
                    });
                });
            jm.code = 0;
            jm.data = new
            {
                entity,
                priceType
            };

            return jm;
        }


        // POST: Api/CoreCmsGoods/DoBatchModifyPrice
        /// <summary>
        ///     批量修改价格提交
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("批量修改价格提交")]
        public async Task<AdminUiCallBack> DoBatchModifyPrice([FromBody] FmBatchModifyPrice entity)
        {
            var jm = await _coreCmsGoodsServices.DoBatchModifyPrice(entity);
            return jm;
        }

        #endregion


        #region 批量修改库存===========================================================

        // POST: Api/CoreCmsGoods/GetBatchModifyStock
        /// <summary>
        ///     批量修改库存
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("批量修改库存")]
        public AdminUiCallBack GetBatchModifyStock([FromBody] FMArrayIntIds entity)
        {
            var jm = new AdminUiCallBack();

            jm.code = 0;
            jm.data = new
            {
                entity
            };

            return jm;
        }


        // POST: Api/CoreCmsGoods/DoBatchModifyStock
        /// <summary>
        ///     批量修改库存提交
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("批量修改库存提交")]
        public async Task<AdminUiCallBack> DoBatchModifyStock([FromBody] FmBatchModifyStock entity)
        {
            var jm = await _coreCmsGoodsServices.DoBatchModifyStock(entity);
            return jm;
        }

        #endregion

        #region 设置标签============================================================

        // POST: Api/CoreCmsGoods/GetLabel
        /// <summary>
        ///     设置标签
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("设置标签")]
        public async Task<AdminUiCallBack> GetLabel([FromBody] FMArrayIntIds entity)
        {
            var jm = new AdminUiCallBack();
            var model = await _labelServices.QueryAsync();
            if (model == null)
            {
                jm.msg = "不存在此信息";
                return jm;
            }

            jm.code = 0;
            jm.data = new
            {
                labels = model,
                ids = entity
            };

            return jm;
        }

        // POST: Admins/CoreCmsGoods/DoSetLabel
        /// <summary>
        ///     设置标签提交
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("设置标签提交")]
        public async Task<AdminUiCallBack> DoSetLabel([FromBody] FmSetLabel entity)
        {
            var jm = await _coreCmsGoodsServices.DoSetLabel(entity);
            return jm;
        }

        #endregion


        #region 去除标签============================================================

        // POST: Api/CoreCmsGoods/GetDeleteLabel
        /// <summary>
        ///     去除标签
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("去除标签")]
        public async Task<AdminUiCallBack> GetDeleteLabel([FromBody] FMArrayIntIds entity)
        {
            var jm = new AdminUiCallBack();

            var model = await _coreCmsGoodsServices.QueryByIDsAsync(entity.id);
            if (model == null)
            {
                jm.msg = "不存在此信息";
                return jm;
            }

            var labelIds = model.Select(p => p.labelIds).ToList();
            var r = new List<int>();
            labelIds.ForEach(p =>
            {
                var arr = CommonHelper.StringToIntArray(p);
                r.AddRange(arr);
            });

            var labels =await _labelServices.QueryListByClauseAsync(p => r.Contains(p.id));

            jm.code = 0;
            jm.data = new
            {
                labels,
                ids = entity
            };


            return jm;
        }

        // POST: Admins/CoreCmsGoods/DoDeleteLabel
        /// <summary>
        ///     去除标签提交
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        [HttpPost]
        [Description("去除标签提交")]
        public async Task<AdminUiCallBack> DoDeleteLabel([FromBody] FmSetLabel entity)
        {
            var jm = await _coreCmsGoodsServices.DoDeleteLabel(entity);
            return jm;
        }

        #endregion
    }
}