public async Task <IActionResult> GetCouponListByUserIdAsync(string userId)
{
if (string.IsNullOrWhiteSpace(userId))
{
_result.status = (int)HttpStatusCode.BadRequest;
_result.msg = "userId is not null";
_result.resultData = null;
return(BadRequest(_result));
}
try
{
var query = new CouponQuery
{
UserId = new Guid(userId)
};
var res = await _couponService.GetCouponsAsync(query);
_result.status = (int)HttpStatusCode.OK;
_result.msg = "success";
_result.resultData = res?.ToList();
return(Ok(_result));
}
catch (Exception ex)
{
_log.Error("GetCouponListByUserIdAsync method error:" + ex);
_result.status = (int)HttpStatusCode.InternalServerError;
_result.msg = "fail";
_result.resultData = null;
return(StatusCode(_result.status, _result));
}
}
public async Task <IEnumerable <CouponDto> > GetAsync(CouponQuery query, CancellationToken token)
{
return(await _statelessSession.Query <Coupon>()
.Select(s => new CouponDto()
{
Value = s.Value,
AmountOfUsers = _statelessSession.Query <UserCoupon>().Count(w => w.Coupon.Id == s.Id),
Code = s.Code,
CouponType = s.CouponType,
TutorId = s.Tutor.Id,
Description = s.Description,
Owner = s.Owner
}).ToListAsync(token));
}
public QueryPageModel <CouponInfo> GetCouponList(CouponQuery query)
{
if (query.ShopId.HasValue)
{
if (query.ShopId <= 0)
{
throw new HimallException("ShopId不能识别");
}
}
int auditsuccess = (int)WXCardLogInfo.AuditStatusEnum.Audited;
var coupon = DbFactory.Default.Get <CouponInfo>();
if (query.ShopId.HasValue)
{
coupon = coupon.Where(d => d.ShopId == query.ShopId);
}
if (query.IsShowAll != true)
{
coupon = coupon.Where(d => d.WXAuditStatus == auditsuccess);
}
if (query.ShowPlatform.HasValue)
{
var sett = DbFactory.Default
.Get <CouponSettingInfo>()
.Where <CouponInfo>((csi, ci) => ci.Id == csi.CouponID && csi.PlatForm == query.ShowPlatform.Value);
coupon = coupon.Where(d => d.ExExists(sett));
}
if (query.IsOnlyShowNormal == true)
{
DateTime curMindate = DateTime.Now.Date;
DateTime curMaxdate = curMindate.AddDays(1).Date;
coupon = coupon.Where(d => d.EndTime >= curMaxdate && d.StartTime <= curMindate);
}
if (!string.IsNullOrWhiteSpace(query.CouponName))
{
coupon = coupon.Where(d => d.CouponName.Contains(query.CouponName));
}
var ret = coupon.OrderByDescending(o => o.EndTime).ToPagedList(query.PageNo, query.PageSize);
QueryPageModel <CouponInfo> pageModel = new QueryPageModel <CouponInfo>()
{
Models = ret, Total = ret.TotalRecordCount
};
return(pageModel);
}
public ObsoletePageModel <CouponInfo> GetCouponList(CouponQuery query)
{
if (query.ShopId.HasValue)
{
if (query.ShopId <= 0)
{
throw new HimallException("ShopId不能识别");
}
}
int total = 0;
int auditsuccess = (int)WXCardLogInfo.AuditStatusEnum.Audited;
IQueryable <CouponInfo> coupon = Context.CouponInfo.AsQueryable();
if (query.ShopId.HasValue)
{
coupon = coupon.Where(d => d.ShopId == query.ShopId);
}
if (query.IsShowAll != true)
{
coupon = coupon.Where(d => d.WXAuditStatus == auditsuccess);
}
if (query.ShowPlatform.HasValue)
{
coupon = coupon.Where(d => d.Himall_CouponSetting.Any(s => s.PlatForm == query.ShowPlatform.Value));
}
if (query.IsOnlyShowNormal == true)
{
DateTime curMindate = DateTime.Now.Date;
DateTime curMaxdate = curMindate.AddDays(1).Date;
coupon = coupon.Where(d => d.EndTime >= curMaxdate && d.StartTime <= curMindate);
}
if (!string.IsNullOrWhiteSpace(query.CouponName))
{
coupon = coupon.Where(d => d.CouponName.Contains(query.CouponName));
}
coupon = coupon.GetPage(out total, d => d.OrderByDescending(o => o.EndTime), query.PageNo, query.PageSize);
ObsoletePageModel <CouponInfo> pageModel = new ObsoletePageModel <CouponInfo>()
{
Models = coupon, Total = total
};
return(pageModel);
}
public JsonResult GetCouponList(int page, int rows, string couponName)
{
ICouponService couponService = ServiceHelper.Create <ICouponService>();
CouponQuery couponQuery = new CouponQuery()
{
CouponName = couponName,
ShopId = new long?(base.CurrentSellerManager.ShopId),
PageSize = rows,
PageNo = page
};
PageModel <CouponInfo> couponList = couponService.GetCouponList(couponQuery);
IQueryable <long> vShopCouponSetting =
from item in ServiceHelper.Create <IVShopService>().GetVShopCouponSetting(base.CurrentSellerManager.ShopId)
select item.CouponID;
var array =
from item in couponList.Models.ToArray()
select new { Id = item.Id, StartTime = item.StartTime.ToString("yyyy-MM-dd"), EndTime = item.EndTime.ToString("yyyy-MM-dd"), Price = Math.Round(item.Price, 2), CouponName = item.CouponName, PerMax = (item.PerMax == 0 ? "不限张" : string.Concat(item.PerMax.ToString(), "张/人")), OrderAmount = (item.OrderAmount == new decimal(0) ? "不限制" : string.Concat("满", item.OrderAmount)), IsSelect = vShopCouponSetting.Contains(item.Id) };
return(Json(new { rows = array, total = couponList.Total }));
}
public JsonResult GetItemList(int page, int rows, string couponName)
{
ICouponService couponService = ServiceHelper.Create <ICouponService>();
CouponQuery couponQuery = new CouponQuery()
{
CouponName = couponName,
ShopId = new long?(base.CurrentSellerManager.ShopId),
IsShowAll = new bool?(true),
PageSize = rows,
PageNo = page
};
PageModel <CouponInfo> couponList = couponService.GetCouponList(couponQuery);
var list =
from item in couponList.Models.ToList()
select new { Id = item.Id, StartTime = item.StartTime.ToString("yyyy/MM/dd"), EndTime = item.EndTime.ToString("yyyy/MM/dd"), Price = Math.Round(item.Price, 2), CouponName = item.CouponName, PerMax = (item.PerMax == 0 ? "不限张" : string.Concat(item.PerMax.ToString(), "张/人")), OrderAmount = (item.OrderAmount == new decimal(0) ? "不限制" : string.Concat("满", item.OrderAmount)), Num = item.Num, ReceviceNum = item.Himall_CouponRecord.Count(), RecevicePeople = (
from a in item.Himall_CouponRecord
group a by a.UserId).Count <IGrouping <long, CouponRecordInfo> >(), Used = item.Himall_CouponRecord.Count((CouponRecordInfo a) => a.CounponStatus == CouponRecordInfo.CounponStatuses.Used), IsSyncWeiXin = item.IsSyncWeiXin, WXAuditStatus = (item.IsSyncWeiXin != 1 ? 1 : item.WXAuditStatus) };
return(Json(new { rows = list, total = couponList.Total }));
}
/// <summary>
/// 根据查询条件获取设置信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public async Task <IEnumerable <Coupon> > GetCouponsAsync(CouponQuery query)
{
try
{
string sql = "SELECT * FROM Coupon WHERE 1=1";
if (query.UserId != null)
{
sql += " AND userId = @UserId";
}
var info = MapperManager.SetMapper <Coupon, CouponQuery>(query);
return(await _mysqlRespository.QueryListAsync(sql, info));
}
catch (Exception ex)
{
_log.Error("GetCouponsAsync method error:" + ex);
throw;
}
}
public PageModel <CouponInfo> GetCouponList(CouponQuery query)
{
long?shopId = query.ShopId;
if ((shopId.GetValueOrDefault() > 0 ? false : shopId.HasValue))
{
throw new HimallException("ShopId不能识别");
}
int num = 0;
int num1 = 1;
IQueryable <CouponInfo> wXAuditStatus = context.CouponInfo.FindBy((CouponInfo d) => d.ShopId == query.ShopId);
bool?isShowAll = query.IsShowAll;
if ((!isShowAll.GetValueOrDefault() ? true : !isShowAll.HasValue))
{
wXAuditStatus =
from d in wXAuditStatus
where d.WXAuditStatus == num1
select d;
}
if (!string.IsNullOrWhiteSpace(query.CouponName))
{
wXAuditStatus =
from d in wXAuditStatus
where d.CouponName.Contains(query.CouponName)
select d;
}
wXAuditStatus = wXAuditStatus.GetPage(out num, (IQueryable <CouponInfo> d) =>
from o in d
orderby o.EndTime descending
select o, query.PageNo, query.PageSize);
return(new PageModel <CouponInfo>()
{
Models = wXAuditStatus,
Total = num
});
}
/// <summary>
/// 获取商家添加的优惠券列表
/// </summary>
/// <returns></returns>
public static ObsoletePageModel <CouponInfo> GetCouponList(CouponQuery query)
{
return(_iCouponService.GetCouponList(query));
}
public async Task <IActionResult> Page(CouponQuery couponQuery)
{
return(Success(await _couponService.PageAsync(couponQuery)));
}
public async Task <IActionResult> Get(CouponQuery couponQuery)
{
return(Success(await _couponService.RetrieveAsync(couponQuery)));
}
public async Task AdminCouponQuery_Ok()
{
var query = new CouponQuery();
var _ = await _fixture.QueryBus.QueryAsync(query, default);
}
/// <summary>
/// 获取商家添加的优惠券列表
/// </summary>
/// <returns></returns>
public static QueryPageModel <CouponInfo> GetCouponList(CouponQuery query)
{
return(Service.GetCouponList(query));
}
public async Task <IEnumerable <CouponDto> > GetAsync(CancellationToken token)
{
var query = new CouponQuery();
return(await _queryBus.QueryAsync(query, token));
}
