public async Task <ActionResult> List(long?typeId, string mobile, string code, DateTime?startTime, DateTime?endTime, int pageIndex = 1) { JournalSearchResult result = await journalService.GetIntegralModelListAsync(typeId, mobile, code, startTime, endTime, pageIndex, pageSize); ListViewModel model = new ListViewModel(); model.Journals = result.Journals; model.JournalTypes = await journalTypeService.GetModelListAsync(true); model.GivingIntegralCount = result.GivingIntegrals == null?0: result.GivingIntegrals; model.UseIntegralCount = result.UseIntegrals == null?0: result.UseIntegrals; model.PlatformIntegral = result.PlatformIntegral; Pagination pager = new Pagination(); pager.PageIndex = pageIndex; pager.PageSize = pageSize; pager.TotalCount = result.TotalCount; if (result.TotalCount <= pageSize) { model.PageHtml = "test"; } else { model.PageHtml = pager.GetPagerHtml(); } model.Pages = pager.Pages; model.PageCount = pager.PageCount; return(Json(new AjaxResult { Status = 1, Data = model })); }
public async Task <ActionResult> List(string mobile, DateTime?startTime, DateTime?endTime, int pageIndex = 1) { var user = await platformUserService.GetModelAsync("mobile", "PlatformUser201805051709360001"); //long? typeId = await journalTypeService.GetIdByDescAsync("赠送"); JournalSearchResult result = await journalService.GetModelListAsync("交易", mobile, null, startTime, endTime, pageIndex, pageSize); ListViewModel model = new ListViewModel(); model.Journals = result.Journals; model.GivingIntegralCount = result.GivingIntegralCount; model.UseIntegralCount = result.UseIntegralCount; Pagination pager = new Pagination(); pager.PageIndex = pageIndex; pager.PageSize = pageSize; pager.TotalCount = result.TotalCount; if (result.TotalCount <= pageSize) { model.PageHtml = "test"; } else { model.PageHtml = pager.GetPagerHtml(); } model.Pages = pager.Pages; model.PageCount = pager.PageCount; return(Json(new AjaxResult { Status = 1, Data = model })); //return View(model); }
public async Task <ActionResult> GetJournal(long id, int pageIndex = 1) { int pageSize = 8; string adminMobile = (await adminService.GetModelAsync(id)).Mobile; long userId = (await platformUserService.GetModelAsync("mobile", adminMobile)).Id; JournalSearchResult result = await journalService.GetAgencyModelListAsync(userId, null, null, null, null, pageIndex, pageSize); GetJournalViewModel model = new GetJournalViewModel(); model.Journals = result.Journals; model.GivingIntegralCount = result.GivingIntegralCount == null ? 0 : result.GivingIntegralCount; model.UseIntegralCount = result.UseIntegralCount == null ? 0 : result.UseIntegralCount; Pagination pager = new Pagination(); pager.PageIndex = pageIndex; pager.PageSize = pageSize; pager.TotalCount = result.TotalCount; pager.GetPagerHtml(); model.Pages = pager.Pages; model.PageCount = pager.PageCount; return(Json(new AjaxResult { Status = 1, Data = model })); }
public async Task <JournalSearchResult> GetBonusModelListAsync(long?userId, string keyword, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize) { using (MyDbContext dbc = new MyDbContext()) { JournalSearchResult result = new JournalSearchResult(); var entities = dbc.GetAll <JournalEntity>().AsNoTracking().Where(j => j.IsEnabled == true && j.JournalTypeId > (int)JournalTypeEnum.佣金提现); if (userId != null) { entities = entities.Where(a => a.UserId == userId); } if (!string.IsNullOrEmpty(keyword)) { entities = entities.Where(g => g.Remark.Contains(keyword) || g.User.Mobile.Contains(keyword) || g.User.NickName.Contains(keyword) || g.OrderCode.Contains(keyword)); } if (startTime != null) { entities = entities.Where(a => a.CreateTime >= startTime); } if (endTime != null) { entities = entities.Where(a => SqlFunctions.DateDiff("day", endTime, a.CreateTime) <= 0); } result.PageCount = (int)Math.Ceiling((await entities.LongCountAsync()) * 1.0f / pageSize); var journalResult = await entities.Include(j => j.User).OrderByDescending(a => a.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync(); result.List = journalResult.Select(a => ToDTO(a)).ToArray(); return(result); } }
public async Task <ActionResult> Incomes(int pageIndex = 1) { long userId = CookieHelper.GetLoginId(); long journalTypeId = await idNameService.GetIdByNameAsync("任务转发"); JournalSearchResult result = await journalService.GetModelListAsync(userId, journalTypeId, null, null, null, pageIndex, pageSize); return(Json(new AjaxResult { Status = 1, Data = result })); }
public async Task <ActionResult> List(string keyword, DateTime?startTime, DateTime?endTime, int pageIndex = 1) { //await orderService.AutoConfirmAsync(); long journalTypeId = await idNameService.GetIdByNameAsync("佣金收入"); JournalSearchResult result = await journalService.GetModelListAsync(null, journalTypeId, keyword, startTime, endTime, pageIndex, pageSize); ListViewModel model = new ListViewModel(); return(Json(new AjaxResult { Status = 1, Data = model })); }
public async Task <JournalSearchResult> GetModelListAsync(long?id, long?typeId, string mobile, string code, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize) { using (MyDbContext dbc = new MyDbContext()) { JournalSearchResult result = new JournalSearchResult(); long journalTypeId = dbc.GetAll <JournalTypeEntity>().SingleOrDefault(j => j.Description == "消费").Id; var journals = dbc.GetAll <JournalEntity>(); if (id != null) { if (typeId == journalTypeId) { journals = journals.Where(j => j.PlatformUserId != j.ToPlatformUserId && j.ToPlatformUserId == id); } } journals = journals.Where(j => j.JournalTypeId == journalTypeId && j.InIntegral == null); if (!string.IsNullOrEmpty(mobile)) { journals = journals.Where(j => j.PlatformUser.Mobile.Contains(mobile)); } if (!string.IsNullOrEmpty(code)) { journals = journals.Where(j => j.PlatformUser.Code.Contains(code)); } if (startTime != null) { journals = journals.Where(j => j.CreateTime >= startTime); } if (endTime != null) { journals = journals.Where(a => a.CreateTime.Year <= endTime.Value.Year && a.CreateTime.Month <= endTime.Value.Month && a.CreateTime.Day <= endTime.Value.Day); } long givingIntegralId = dbc.GetAll <IntegralTypeEntity>().SingleOrDefault(i => i.Name == "商家积分").Id; long useIntegralId = dbc.GetAll <IntegralTypeEntity>().SingleOrDefault(i => i.Name == "消费积分").Id; result.TotalCount = await journals.LongCountAsync(); var user = await dbc.GetAll <PlatformUserEntity>().SingleOrDefaultAsync(p => p.Mobile == "PlatformUser201805051709360001"); if (user != null) { long platformUserId = user.Id; result.GivingIntegrals = await journals.Where(j => j.ToIntegralTypeId == givingIntegralId && j.PlatformUserId == platformUserId).SumAsync(j => j.OutIntegral); result.UseIntegrals = await journals.Where(j => j.ToIntegralTypeId == useIntegralId && j.PlatformUserId == platformUserId).SumAsync(j => j.OutIntegral); } var journalResult = await journals.OrderByDescending(j => j.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync(); result.Journals = journalResult.Select(j => ToDTO(j)).ToArray(); return(result); } }
public async Task <JournalSearchResult> GetUserModelListAsync(long id, int pageIndex, int pageSize) { using (MyDbContext dbc = new MyDbContext()) { JournalSearchResult result = new JournalSearchResult(); var journals = dbc.GetAll <JournalEntity>(); long useId = dbc.GetAll <JournalTypeEntity>().SingleOrDefault(j => j.Description == "消费").Id; journals = journals.Where(j => (j.PlatformUserId == id && j.PlatformUserId == j.ToPlatformUserId) || (j.PlatformUserId == id && j.JournalTypeId == useId) || (j.ToPlatformUserId == id && j.ToPlatformUserId == j.FormPlatformUserId)); result.TotalCount = await journals.LongCountAsync(); var res = await journals.OrderByDescending(j => j.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync(); result.Journals = res.Select(j => ToDTO(j)).ToArray(); return(result); } }
public async Task <ActionResult> List(string keyword, DateTime?startTime, DateTime?endTime, int pageIndex = 1) { await orderService.AutoConfirmAsync(); long journalTypeId = await idNameService.GetIdByNameAsync("佣金收入"); JournalSearchResult result = await journalService.GetModelListAsync(null, journalTypeId, keyword, startTime, endTime, pageIndex, pageSize); CalcAmountResult res = await userService.CalcCount(); ListViewModel model = new ListViewModel(); model.Journals = result.Journals; model.PageCount = result.PageCount; model.TotalAmount = res.TotalAmount; model.TotalTakeCash = res.TotalTakeCash; model.TotalBuyAmount = res.TotalBuyAmount; return(Json(new AjaxResult { Status = 1, Data = model })); }
public async Task <ActionResult> GetJournal(long id, int pageIndex = 1) { JournalSearchResult result = await journalService.GetMerchantModelListAsync(id, null, null, null, null, null, pageIndex, pageSize); GetJournalViewModel model = new GetJournalViewModel(); model.Journals = result.Journals; Pagination pager = new Pagination(); pager.PageIndex = pageIndex; pager.PageSize = pageSize; pager.TotalCount = result.TotalCount; pager.GetPagerHtml(); model.Pages = pager.Pages; model.PageCount = pager.PageCount; return(Json(new AjaxResult { Status = 1, Data = model })); }
public async Task <JournalSearchResult> GetModelListAsync(string typeName, string mobile, string code, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize) { using (MyDbContext dbc = new MyDbContext()) { JournalSearchResult result = new JournalSearchResult(); var journals = dbc.GetAll <JournalEntity>(); long useId = dbc.GetAll <JournalTypeEntity>().SingleOrDefault(j => j.Description == "消费").Id; long givingId = dbc.GetAll <JournalTypeEntity>().SingleOrDefault(j => j.Description == "赠送").Id; if (typeName == "交易") { journals = journals.Where(j => j.PlatformUserId != j.ToPlatformUserId).Where(j => j.JournalTypeId == useId || j.JournalTypeId == givingId); } if (!string.IsNullOrEmpty(mobile)) { journals = journals.Where(j => j.ToPlatformUser.Mobile.Contains(mobile) || j.PlatformUser.Mobile.Contains(mobile)); } if (!string.IsNullOrEmpty(code)) { journals = journals.Where(j => j.ToPlatformUser.Code.Contains(code) || j.PlatformUser.Code.Contains(code)); } if (startTime != null) { journals = journals.Where(j => j.CreateTime >= startTime); } if (endTime != null) { journals = journals.Where(a => a.CreateTime.Year <= endTime.Value.Year && a.CreateTime.Month <= endTime.Value.Month && a.CreateTime.Day <= endTime.Value.Day); } result.TotalCount = await journals.LongCountAsync(); result.GivingIntegralCount = await journals.Where(j => j.JournalTypeId == givingId).SumAsync(j => j.OutIntegral); result.UseIntegralCount = await journals.Where(j => j.JournalTypeId == useId).SumAsync(j => j.OutIntegral); var journalResult = await journals.OrderByDescending(j => j.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync(); result.Journals = journalResult.Select(j => ToDTO(j)).ToArray(); return(result); } }
public async Task <JournalSearchResult> GetModelListAsync(long?userId, long?journalTypeId, string keyword, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize) { using (MyDbContext dbc = new MyDbContext()) { JournalSearchResult result = new JournalSearchResult(); var entities = dbc.GetAll <JournalEntity>().AsNoTracking().Where(j => j.Enabled == 1); if (userId != null) { entities = entities.Where(a => a.UserId == userId); } if (journalTypeId != null) { entities = entities.Where(a => a.JournalTypeId == journalTypeId); } if (!string.IsNullOrEmpty(keyword)) { entities = entities.Where(g => g.Remark.Contains(keyword) || g.User.Mobile.Contains(keyword) || g.User.NickName.Contains(keyword)); } if (startTime != null) { entities = entities.Where(a => a.CreateTime >= startTime); } if (endTime != null) { entities = entities.Where(a => a.CreateTime <= endTime); } result.PageCount = (int)Math.Ceiling((await entities.LongCountAsync()) * 1.0f / pageSize); decimal?totalInAmount = await entities.SumAsync(j => j.InAmount); decimal?totalOutAmount = await entities.SumAsync(j => j.OutAmount); result.TotalInAmount = totalInAmount == null ? 0 : totalInAmount; result.TotalOutAmount = totalOutAmount == null ? 0 : totalOutAmount; var res = await entities.Include(j => j.User).OrderByDescending(a => a.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync(); result.List = res.Select(a => ToDTO(a)).ToArray(); return(result); } }