public object GetShopBranchs(long shopId, bool getParent, string skuIds, string counts, int page, int rows, long shippingAddressId, long regionId)
{
string[] _skuIds = skuIds.Split(',');
int[] _counts = counts.Split(',').Select(p => Mall.Core.Helper.TypeHelper.ObjectToInt(p)).ToArray();
var shippingAddressInfo = ShippingAddressApplication.GetUserShippingAddress(shippingAddressId);
int streetId = 0, districtId = 0;//收货地址的街道、区域
var query = new ShopBranchQuery()
{
ShopId = shopId,
PageNo = page,
PageSize = rows,
Status = CommonModel.ShopBranchStatus.Normal,
ShopBranchProductStatus = ShopBranchSkuStatus.Normal
};
if (shippingAddressInfo != null)
{
query.FromLatLng = string.Format("{0},{1}", shippingAddressInfo.Latitude, shippingAddressInfo.Longitude);//需要收货地址的经纬度
streetId = shippingAddressInfo.RegionId;
var parentAreaInfo = RegionApplication.GetRegion(shippingAddressInfo.RegionId, Region.RegionLevel.Town);//判断当前区域是否为第四级
if (parentAreaInfo != null && parentAreaInfo.ParentId > 0) districtId = parentAreaInfo.ParentId;
else { districtId = streetId; streetId = 0; }
}
bool hasLatLng = false;
if (!string.IsNullOrWhiteSpace(query.FromLatLng)) hasLatLng = query.FromLatLng.Split(',').Length == 2;
var region = RegionApplication.GetRegion(regionId, getParent ? CommonModel.Region.RegionLevel.City : CommonModel.Region.RegionLevel.County);//同城内门店
if (region != null) query.AddressPath = region.GetIdPath();
#region 3.0版本排序规则
var skuInfos = ProductManagerApplication.GetSKUs(_skuIds);
query.ProductIds = skuInfos.Select(p => p.ProductId).ToArray();
var data = ShopBranchApplication.GetShopBranchsAll(query);
var shopBranchSkus = ShopBranchApplication.GetSkus(shopId, data.Models.Select(p => p.Id).ToList());//获取该商家下具有订单内所有商品的门店状态正常数据,不考虑库存
data.Models.ForEach(p =>
{
p.Enabled = skuInfos.All(skuInfo => shopBranchSkus.Any(sbSku => sbSku.ShopBranchId == p.Id && sbSku.Stock >= _counts[skuInfos.IndexOf(skuInfo)] && sbSku.SkuId == skuInfo.Id));
});
List<Mall.DTO.ShopBranch> newList = new List<Mall.DTO.ShopBranch>();
List<long> fillterIds = new List<long>();
var currentList = data.Models.Where(p => hasLatLng && p.Enabled && (p.Latitude > 0 && p.Longitude > 0)).OrderBy(p => p.Distance).ToList();
if (currentList != null && currentList.Count() > 0)
{
fillterIds.AddRange(currentList.Select(p => p.Id));
newList.AddRange(currentList);
}
var currentList2 = data.Models.Where(p => !fillterIds.Contains(p.Id) && p.Enabled && p.AddressPath.Contains(CommonConst.ADDRESS_PATH_SPLIT + streetId + CommonConst.ADDRESS_PATH_SPLIT)).ToList();
if (currentList2 != null && currentList2.Count() > 0)
{
fillterIds.AddRange(currentList2.Select(p => p.Id));
newList.AddRange(currentList2);
}
var currentList3 = data.Models.Where(p => !fillterIds.Contains(p.Id) && p.Enabled && p.AddressPath.Contains(CommonConst.ADDRESS_PATH_SPLIT + districtId + CommonConst.ADDRESS_PATH_SPLIT)).ToList();
if (currentList3 != null && currentList3.Count() > 0)
{
fillterIds.AddRange(currentList3.Select(p => p.Id));
newList.AddRange(currentList3);
}
var currentList4 = data.Models.Where(p => !fillterIds.Contains(p.Id) && p.Enabled).ToList();//非同街、非同区，但一定会同市
if (currentList4 != null && currentList4.Count() > 0)
{
fillterIds.AddRange(currentList4.Select(p => p.Id));
newList.AddRange(currentList4);
}
var currentList5 = data.Models.Where(p => !fillterIds.Contains(p.Id)).ToList();//库存不足的排最后
if (currentList5 != null && currentList5.Count() > 0)
{
newList.AddRange(currentList5);
}
if (newList.Count() != data.Models.Count())//如果新组合的数据与原数据数量不一致
{
return new
{
success = false
};
}
var needDistance = false;
if (shippingAddressInfo != null && shippingAddressInfo.Latitude!=0 && shippingAddressInfo.Longitude!=0)
{
needDistance = true;
}
var storeList = newList.Select(sb =>
{
return new
{
ContactUser = sb.ContactUser,
ContactPhone = sb.ContactPhone,
AddressDetail = sb.AddressDetail,
ShopBranchName = sb.ShopBranchName,
Id = sb.Id,
Enabled = sb.Enabled,
Distance = needDistance ? RegionApplication.GetDistance(sb.Latitude, sb.Longitude, shippingAddressInfo.Latitude, shippingAddressInfo.Longitude) : 0
};
});
#endregion
var result = new
{
success = true,
StoreList = storeList
};
return result;
}
public JsonResult GetShopBranchs(long shopId, long regionId, bool getParent, string[] skuIds, int[] counts, int page, int rows, long shippingAddressId)
{
var shippingAddressInfo = ShippingAddressApplication.GetUserShippingAddress(shippingAddressId);
int streetId = 0, districtId = 0;//收货地址的街道、区域
var query = new ShopBranchQuery()
{
ShopId = shopId,
PageNo = page,
PageSize = rows,
Status = ShopBranchStatus.Normal,
ShopBranchProductStatus = ShopBranchSkuStatus.Normal
};
if (shippingAddressInfo != null)
{
query.FromLatLng = string.Format("{0},{1}", shippingAddressInfo.Latitude, shippingAddressInfo.Longitude); //需要收货地址的经纬度
streetId = shippingAddressInfo.RegionId;
var parentAreaInfo = RegionApplication.GetRegion(shippingAddressInfo.RegionId, Region.RegionLevel.Town); //判断当前区域是否为第四级
if (parentAreaInfo != null && parentAreaInfo.ParentId > 0)
{
districtId = parentAreaInfo.ParentId;
}
else
{
districtId = streetId; streetId = 0;
}
}
bool hasLatLng = false;
if (!string.IsNullOrWhiteSpace(query.FromLatLng))
{
hasLatLng = query.FromLatLng.Split(',').Length == 2;
}
var region = RegionApplication.GetRegion(regionId, getParent ? Region.RegionLevel.City : Region.RegionLevel.County);
if (region != null)
{
query.AddressPath = region.GetIdPath();
}
#region 旧排序规则
//var skuInfos = ProductManagerApplication.GetSKUs(skuIds);
//query.ProductIds = skuInfos.Select(p => p.ProductId).ToArray();
//var data = ShopBranchApplication.GetShopBranchs(query);
//var shopBranchSkus = ShopBranchApplication.GetSkus(shopId, data.Models.Select(p => p.Id));
//var models = new
//{
// Rows = data.Models.Select(sb => new
// {
// sb.ContactUser,
// sb.ContactPhone,
// sb.AddressDetail,
// sb.ShopBranchName,
// sb.Id,
// Enabled = skuInfos.All(skuInfo => shopBranchSkus.Any(sbSku => sbSku.ShopBranchId == sb.Id && sbSku.Stock >= counts[skuInfos.IndexOf(skuInfo)] && sbSku.SkuId == skuInfo.Id))
// }).OrderByDescending(p => p.Enabled).ToArray(),
// data.Total
//};
#endregion
#region 3.0版本排序规则
var skuInfos = ProductManagerApplication.GetSKUs(skuIds);
query.ProductIds = skuInfos.Select(p => p.ProductId).ToArray();
var data = ShopBranchApplication.GetShopBranchsAll(query);
var shopBranchSkus = ShopBranchApplication.GetSkus(shopId, data.Models.Select(p => p.Id).ToList());//获取该商家下具有订单内所有商品的门店状态正常数据,不考虑库存
data.Models.ForEach(p =>
{
p.Enabled = skuInfos.All(skuInfo => shopBranchSkus.Any(sbSku => sbSku.ShopBranchId == p.Id && sbSku.Stock >= counts[skuInfos.IndexOf(skuInfo)] && sbSku.SkuId == skuInfo.Id));
});
List <ShopBranch> newList = new List <ShopBranch>();
List <long> fillterIds = new List <long>();
var currentList = data.Models.Where(p => hasLatLng && p.Enabled && (p.Latitude > 0 && p.Longitude > 0)).OrderBy(p => p.Distance).ToList();
if (currentList != null && currentList.Count() > 0)
{
fillterIds.AddRange(currentList.Select(p => p.Id));
newList.AddRange(currentList);
}
var currentList2 = data.Models.Where(p => !fillterIds.Contains(p.Id) && p.Enabled && p.AddressPath.Contains(CommonConst.ADDRESS_PATH_SPLIT + streetId + CommonConst.ADDRESS_PATH_SPLIT)).ToList();
if (currentList2 != null && currentList2.Count() > 0)
{
fillterIds.AddRange(currentList2.Select(p => p.Id));
newList.AddRange(currentList2);
}
var currentList3 = data.Models.Where(p => !fillterIds.Contains(p.Id) && p.Enabled && p.AddressPath.Contains(CommonConst.ADDRESS_PATH_SPLIT + districtId + CommonConst.ADDRESS_PATH_SPLIT)).ToList();
if (currentList3 != null && currentList3.Count() > 0)
{
fillterIds.AddRange(currentList3.Select(p => p.Id));
newList.AddRange(currentList3);
}
var currentList4 = data.Models.Where(p => !fillterIds.Contains(p.Id) && p.Enabled).ToList();//非同街、非同区，但一定会同市
if (currentList4 != null && currentList4.Count() > 0)
{
fillterIds.AddRange(currentList4.Select(p => p.Id));
newList.AddRange(currentList4);
}
var currentList5 = data.Models.Where(p => !fillterIds.Contains(p.Id)).ToList();//库存不足的排最后
if (currentList5 != null && currentList5.Count() > 0)
{
newList.AddRange(currentList5);
}
if (newList.Count() != data.Models.Count())//如果新组合的数据与原数据数量不一致，则异常
{
return(Json <dynamic>(true, data: new { Rows = "" }, camelCase: true));
}
var needDistance = false;
if (shippingAddressInfo != null && shippingAddressInfo.Latitude != 0 && shippingAddressInfo.Longitude != 0)
{
needDistance = true;
}
var models = new
{
Rows = newList.Select(sb => new
{
sb.ContactUser,
sb.ContactPhone,
sb.AddressDetail,
sb.ShopBranchName,
sb.Id,
Enabled = sb.Enabled,
Distance = needDistance ? RegionApplication.GetDistance(sb.Latitude, sb.Longitude, shippingAddressInfo.Latitude, shippingAddressInfo.Longitude) : 0
}).ToArray(),
Total = newList.Count
};
#endregion
return(SuccessResult <dynamic>(data: models, camelCase: true));
}