using CoreCms.Net.Configuration;
|
using CoreCms.Net.IRepository.UnitOfWork;
|
using CoreCms.Net.IServices;
|
using CoreCms.Net.IServices.baifenbingfa;
|
using CoreCms.Net.Model.Entities;
|
using CoreCms.Net.Utility.Helper;
|
using Nest;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace CoreCms.Net.Services.baifenbingfa
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public class BfbfComAPIService : IBfbfComAPIService
|
{
|
|
private readonly ICoreCmsUserServices _userServices;
|
private readonly IUnitOfWork _unitOfWork;
|
private readonly ICoreCmsSettingServices _coreCmsSettingServices;
|
public BfbfComAPIService(ICoreCmsUserServices userServices,IUnitOfWork unitOfWork, ICoreCmsSettingServices coreCmsSettingServices)
|
{
|
_userServices = userServices;
|
_unitOfWork = unitOfWork;
|
_coreCmsSettingServices = coreCmsSettingServices;
|
}
|
public async Task<List<SearchUserData>> SearchUserData(string s)
|
{
|
var ListData= await _unitOfWork.GetDbClient().Queryable<CoreCmsUser>().Where(x => x.isDelete == false).Select(x => new SearchUserData
|
{
|
Id = x.id,
|
name = x.mobile /*+ "|" + x.userName*/ + "|" + x.nickName,
|
|
}).WithCache(50).ToListAsync();
|
if (string.IsNullOrEmpty(s))
|
{
|
return ListData;
|
}
|
return ListData.Where(x => x.name.Contains(s)).ToList();
|
}
|
|
public async Task<bool> IsDictionary(int UserId)
|
{
|
if (UserId == 0)
|
return false;
|
var user=await _unitOfWork.GetDbClient().Queryable<CoreCmsUser>().Includes(x=>x.gradeInfo).Where(x=>x.id== UserId).WithCache(10).SingleAsync();
|
if (user == null)
|
return false;
|
if(user.gradeInfo==null)
|
return false;
|
var allConfigs = await _coreCmsSettingServices.GetConfigDictionaries();
|
var kc = CommonHelper.GetConfigDictionary(allConfigs, SystemSettingConstVars.DictionaryUserGroupKey);
|
if (user.gradeInfo.valueKey == kc)
|
return true;
|
return false;
|
|
}
|
|
public async Task<List<CoreCmsGoodsCategory>> GetGoodsCategory()
|
{
|
return await _unitOfWork.GetDbClient().Queryable<CoreCmsGoodsCategory>().Where(x=>x.isShow==true).WithCache(10).ToTreeAsync(x=>x.children, x=>x.parentId,0);
|
}
|
|
|
public decimal CommandCustomizable(int count)
|
{
|
if (count > 9999)
|
return 0;
|
return count * 1;
|
}
|
|
public List<DistributorSort> orderedDistributors(List<DistributorSort> DataList, string latitude, string longitude)
|
{
|
|
|
GeoCoordinate inputLocation = new GeoCoordinate(double.Parse(longitude), double.Parse(latitude)); // 输入的经纬度
|
|
var sortedDistributors = DataList.OrderBy(d => CalculateDistance(inputLocation, new GeoCoordinate(double.Parse(d.longitude), double.Parse(d.latitude))))
|
.ToList();
|
return sortedDistributors;
|
}
|
|
|
/// <summary>
|
/// 计算经纬达距离
|
/// </summary>
|
/// <param name="location1"></param>
|
/// <param name="location2"></param>
|
/// <returns></returns>
|
private static double CalculateDistance(GeoCoordinate location1, GeoCoordinate location2)
|
{
|
const double earthRadiusKm = 6371;
|
var dLat = ToRadians(location2.Latitude - location1.Latitude);
|
var dLon = ToRadians(location2.Longitude - location1.Longitude);
|
|
var a = Math.Sin(dLat / 2) * Math.Sin(dLat / 2) +
|
Math.Cos(ToRadians(location1.Latitude)) * Math.Cos(ToRadians(location2.Latitude)) *
|
Math.Sin(dLon / 2) * Math.Sin(dLon / 2);
|
var c = 2 * Math.Atan2(Math.Sqrt(a), Math.Sqrt(1 - a));
|
var distance = earthRadiusKm * c;
|
|
return distance;
|
}
|
|
private static double ToRadians(double degree)
|
{
|
return degree * Math.PI / 180;
|
}
|
|
/// <summary>
|
/// 获取有效校园代理
|
/// </summary>
|
/// <param name="PIds"></param>
|
/// <returns></returns>
|
public async Task< List<DistributorSort>> GetDistributorsList(List<int> PIds)
|
{
|
var blist= await _unitOfWork.GetDbClient().Queryable<CoreCmsDistribution>().Where(x=>x.profession=="校园代理"&&x.verifyStatus== (int)GlobalEnumVars.DistributionVerifyStatus.VerifyYes).ToListAsync();
|
List < DistributorSort > retlist=new List<DistributorSort>();
|
foreach (var item in blist)
|
{
|
if (string.IsNullOrEmpty(item.storeCoordinate) || item.storeCoordinate == ",")
|
//没有定位，不加入
|
continue;
|
var ldinate= item.storeCoordinate.Split(',');
|
retlist.Add( new DistributorSort()
|
{
|
id = item.id,
|
latitude = ldinate[0],
|
longitude = ldinate[1],
|
name = item.schoolName + ":" + item.name
|
|
|
|
});
|
}
|
return retlist;
|
}
|
|
|
|
public async Task< List< int>> GetOderProductsIDs(string[] OderIds)
|
{
|
var list= await _unitOfWork.GetDbClient().Queryable<CoreCmsOrder>().Where(x => OderIds.Contains(x.orderId))
|
.Select(x => new { items = SqlFunc.Subqueryable<CoreCmsOrderItem>().Where(it => it.orderId == x.orderId).ToList() }).ToListAsync();
|
var li=new List<int>();
|
foreach (var item in list)
|
{
|
li.AddRange(item.items.Select(x=>x.id).ToList());
|
|
|
}
|
return li;
|
}
|
}
|
}
|
