| | |
| | | |
| | | //支付统计 |
| | | data.put("wechatPay",mallOrderInfoMapper.selectSumAmountByPayMethodAndStatue(OrderPayMethodEnum.WECHAT.getName(), OrderStatusEnum.FINISH.getValue())); |
| | | data.put("alipayPay",mallOrderInfoMapper.selectSumAmountByPayMethodAndStatue(OrderPayMethodEnum.ALIPAY.getName(), OrderStatusEnum.FINISH.getValue())); |
| | | data.put("scorePay",mallOrderInfoMapper.selectSumAmountByPayMethodAndStatue(OrderPayMethodEnum.SCORE.getName(), OrderStatusEnum.FINISH.getValue())); |
| | | // data.put("alipayPay",mallOrderInfoMapper.selectSumAmountByPayMethodAndStatue(OrderPayMethodEnum.ALIPAY.getName(), OrderStatusEnum.FINISH.getValue())); |
| | | // data.put("scorePay",mallOrderInfoMapper.selectSumAmountByPayMethodAndStatue(OrderPayMethodEnum.SCORE.getName(), OrderStatusEnum.FINISH.getValue())); |
| | | data.put("balancePay",mallOrderInfoMapper.selectSumAmountByPayMethodAndStatue(OrderPayMethodEnum.BALANCE.getName(), OrderStatusEnum.FINISH.getValue())); |
| | | |
| | | |
| | |
| | | |
| | | //会员数据 |
| | | data.put("totalMember",mallMemberMapper.selectCount(new QueryWrapper<>()) ); |
| | | QueryWrapper<MallMember> formalMember = new QueryWrapper<>(); |
| | | formalMember.ne("level", AgentLevelEnum.ZERO_LEVEL.name()); |
| | | data.put("formalMember",mallMemberMapper.selectCount(formalMember)); |
| | | // QueryWrapper<MallMember> formalMember = new QueryWrapper<>(); |
| | | // formalMember.ne("level", AgentLevelEnum.ZERO_LEVEL.name()); |
| | | // data.put("formalMember",mallMemberMapper.selectCount(formalMember)); |
| | | |
| | | QueryWrapper<MallMember> informalMember = new QueryWrapper<>(); |
| | | informalMember.eq("level", AgentLevelEnum.ZERO_LEVEL.name()); |
| | | data.put("informalMember",mallMemberMapper.selectCount(informalMember)); |
| | | // QueryWrapper<MallMember> informalMember = new QueryWrapper<>(); |
| | | // informalMember.eq("level", AgentLevelEnum.ZERO_LEVEL.name()); |
| | | // data.put("informalMember",mallMemberMapper.selectCount(informalMember)); |
| | | |
| | | QueryWrapper<MallMember> todayMember = new QueryWrapper<>(); |
| | | todayMember.like("CREATED_TIME", DateUtil.today()); |
| | | todayMember.ne("level", AgentLevelEnum.ZERO_LEVEL.name()); |
| | | // todayMember.ne("level", AgentLevelEnum.ZERO_LEVEL.name()); |
| | | data.put("todayMember",mallMemberMapper.selectCount(todayMember)); |
| | | |
| | | QueryWrapper<MallMember> thisMonthMember = new QueryWrapper<>(); |
| | | thisMonthMember.like("CREATED_TIME", DateUtil.format(DateUtil.date(),"yyyy-MM")); |
| | | thisMonthMember.ne("level", AgentLevelEnum.ZERO_LEVEL.name()); |
| | | // thisMonthMember.ne("level", AgentLevelEnum.ZERO_LEVEL.name()); |
| | | data.put("thisMonthMember",mallMemberMapper.selectCount(thisMonthMember)); |
| | | |
| | | QueryWrapper<MallMember> lastMonthMember = new QueryWrapper<>(); |
| | | lastMonthMember.like("CREATED_TIME", DateUtil.format(DateUtil.offsetMonth(new Date(), -1),"yyyy-MM")); |
| | | lastMonthMember.ne("level", AgentLevelEnum.ZERO_LEVEL.name()); |
| | | // lastMonthMember.ne("level", AgentLevelEnum.ZERO_LEVEL.name()); |
| | | data.put("lastMonthMember",mallMemberMapper.selectCount(lastMonthMember)); |
| | | |
| | | // 获取近期系统访问记录 |