用户列表增加搜索条件

KKSU

2023-11-07 10ad2e710d2bd52aac31d5d63a7bb6beae76b6a8

 src/main/java/cc/mrbird/febs/mall/controller/ViewSystemController.java

@@ -1,19 +1,35 @@
package cc.mrbird.febs.mall.controller;

import cc.mrbird.febs.common.entity.FebsConstant;
import cc.mrbird.febs.common.enumerates.AgentLevelEnum;
import cc.mrbird.febs.common.enumerates.DataDictionaryEnum;
import cc.mrbird.febs.common.enumerates.OrderPayMethodEnum;
import cc.mrbird.febs.common.enumerates.PerkEnum;
import cc.mrbird.febs.common.service.ValidateCodeService;
import cc.mrbird.febs.common.utils.FebsUtil;
import cc.mrbird.febs.common.utils.RedisUtils;
import cc.mrbird.febs.mall.dto.CashOutSettingDto;
import cc.mrbird.febs.mall.dto.ScorePoorDto;
import cc.mrbird.febs.mall.dto.ScoreSettingDto;
import cc.mrbird.febs.mall.entity.DataDictionaryCustom;
import cc.mrbird.febs.mall.mapper.DataDictionaryCustomMapper;
import cc.mrbird.febs.mall.entity.MallMember;
import cc.mrbird.febs.mall.mapper.*;
import cc.mrbird.febs.mall.vo.AdminPerkSetVo;
import cc.mrbird.febs.mall.vo.AdminPoolSetVo;
import cc.mrbird.febs.monitor.service.ILoginLogService;
import cc.mrbird.febs.system.service.IUserService;
import cn.hutool.core.date.DateUtil;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import lombok.RequiredArgsConstructor;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;

import java.math.BigDecimal;
import java.util.*;


@Controller("mallSystemView")
@@ -22,6 +38,12 @@
public class ViewSystemController {

    private final DataDictionaryCustomMapper dataDictionaryCustomMapper;

    private final MallMemberMapper mallMemberMapper;
    private final MallOrderInfoMapper mallOrderInfoMapper;
    private final MallAchieveRecordMapper mallAchieveRecordMapper;
    private final MallMemberWalletMapper mallMemberWalletMapper;
    private final RedisUtils redisUtils;

    @GetMapping("profitSetting")
    public String profitSetting() {
@@ -37,4 +59,152 @@
        }
        return FebsUtil.view("modules/system/cashOutSetting");
    }

    @GetMapping("scorePoorSetting")
    @RequiresPermissions("scorePoorSetting:update")
    public String scorePoor(Model model) {
        DataDictionaryCustom dic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(DataDictionaryEnum.SCORE_POOR_RADIO.getType(), DataDictionaryEnum.SCORE_POOR_RADIO.getCode());
        if (dic != null) {
            model.addAttribute("scorePoor", JSONObject.parseObject(dic.getValue(), ScorePoorDto.class));
        }
        return FebsUtil.view("modules/system/scorePoorSetting");
    }

    @GetMapping("indexData")
    @RequiresPermissions("indexData:view")
    public String indexData(Model model) {
        Map<String, Object> data = new HashMap<>(5);

        //积分池数据
        data.put("scorePool",redisUtils.get("scorePool"));
        //支付统计
        List<Long> states = new ArrayList();
        states.add(2L);
        states.add(3L);
        states.add(4L);
        data.put("wechatPay",mallOrderInfoMapper.selectSumAmountByPayMethodAndSomeStatue(OrderPayMethodEnum.WECHAT.getName(), states));
        data.put("alipayPay",mallOrderInfoMapper.selectSumAmountByPayMethodAndSomeStatue(OrderPayMethodEnum.ALIPAY.getName(), states));
        data.put("scorePay",mallOrderInfoMapper.selectSumAmountByPayMethodAndSomeStatue(OrderPayMethodEnum.BANK.getName(), states));
        data.put("balancePay",mallOrderInfoMapper.selectSumAmountByPayMethodAndSomeStatue(OrderPayMethodEnum.BALANCE.getName(), states));


        data.put("lastDay", mallAchieveRecordMapper.selectAchieveTotal("D", DateUtil.offsetDay(new Date(), -1)));
        data.put("today", mallAchieveRecordMapper.selectAchieveTotal("D", new Date()));
        data.put("lastMonth", mallAchieveRecordMapper.selectAchieveTotal("M", DateUtil.offsetMonth(new Date(), -1)));
        data.put("thisMonth", mallAchieveRecordMapper.selectAchieveTotal("M", new Date()));

        data.put("totalBalance",mallMemberWalletMapper.selectSumBalance().setScale(2, BigDecimal.ROUND_DOWN));
        data.put("totalScore",mallMemberWalletMapper.selectSumScore().setScale(2, BigDecimal.ROUND_DOWN));
        data.put("totalPrizeScore",mallMemberWalletMapper.selectSumPrizeScore().setScale(2, BigDecimal.ROUND_DOWN));
        data.put("totalCommission",mallMemberWalletMapper.selectSumCommission().setScale(2, BigDecimal.ROUND_DOWN));

        //会员数据
        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> 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());
        data.put("todayMember",mallMemberMapper.selectCount(todayMember));

        QueryWrapper<MallMember> thisMonthMember = new QueryWrapper<>();
        thisMonthMember.like("CREATED_TIME", DateUtil.format(DateUtil.date(),"yyyy-MM"));
        data.put("thisMonthMember",mallMemberMapper.selectCount(thisMonthMember));

        QueryWrapper<MallMember> lastMonthMember = new QueryWrapper<>();
        lastMonthMember.like("CREATED_TIME", DateUtil.format(DateUtil.offsetMonth(new Date(), -1),"yyyy-MM"));
        data.put("lastMonthMember",mallMemberMapper.selectCount(lastMonthMember));

        model.addAttribute("indexData", data);
        return FebsUtil.view("modules/system/indexData");
    }

    @GetMapping("perkSet")
    @RequiresPermissions("perkSet:view")
    public String perkSet(Model model) {
        AdminPerkSetVo adminPerkSetVo = new AdminPerkSetVo();
        DataDictionaryCustom buySetMealPerkPercentDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(
                PerkEnum.BUY_SET_MEAL_PERK_PERCENT.getType(),
                PerkEnum.BUY_SET_MEAL_PERK_PERCENT.getCode());
        if (buySetMealPerkPercentDic != null) {
            adminPerkSetVo.setBuySetMealPerkPercent(buySetMealPerkPercentDic.getValue());
        }
        DataDictionaryCustom directCashPerkPercentDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(
                PerkEnum.DIRECT_CASH_PERK_PERCENT.getType(),
                PerkEnum.DIRECT_CASH_PERK_PERCENT.getCode());
        if (directCashPerkPercentDic != null) {
            adminPerkSetVo.setDirectCashPerkPercent(directCashPerkPercentDic.getValue());
        }
        DataDictionaryCustom directScorePerkPercentDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(
                PerkEnum.DIRECT_SCORE_PERK_PERCENT.getType(),
                PerkEnum.DIRECT_SCORE_PERK_PERCENT.getCode());
        if (directScorePerkPercentDic != null) {
            adminPerkSetVo.setDirectScorePerkPercent(directScorePerkPercentDic.getValue());
        }
        DataDictionaryCustom directorCashPerkPercentDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(
                PerkEnum.DIRECTOR_CASH_PERK_PERCENT.getType(),
                PerkEnum.DIRECTOR_CASH_PERK_PERCENT.getCode());
        if (directorCashPerkPercentDic != null) {
            adminPerkSetVo.setDirectorCashPerkPercent(directorCashPerkPercentDic.getValue());
        }
        DataDictionaryCustom partnerCashPerkPercentDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(
                PerkEnum.PARTNER_CASH_PERK_PERCENT.getType(),
                PerkEnum.PARTNER_CASH_PERK_PERCENT.getCode());
        if (partnerCashPerkPercentDic != null) {
            adminPerkSetVo.setPartnerCashPerkPercent(partnerCashPerkPercentDic.getValue());
        }

        model.addAttribute("adminPerkSet", adminPerkSetVo);
        return FebsUtil.view("modules/system/perkSet");
    }

    @GetMapping("poolSet")
    @RequiresPermissions("poolSet:view")
    public String poolSet(Model model) {
        AdminPoolSetVo adminPoolSetVo = new AdminPoolSetVo();
        DataDictionaryCustom poolCashDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(
                PerkEnum.POOL_CASH.getType(),
                PerkEnum.POOL_CASH.getCode());
        if (poolCashDic != null) {
            adminPoolSetVo.setPoolCash(poolCashDic.getValue());
        }
        DataDictionaryCustom poolScoreDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(
                PerkEnum.POOL_SCORE.getType(),
                PerkEnum.POOL_SCORE.getCode());
        if (poolScoreDic != null) {
            adminPoolSetVo.setPoolScore(poolScoreDic.getValue());
        }
        DataDictionaryCustom poolScorePriceDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(
                PerkEnum.POOL_SCORE_PRICE.getType(),
                PerkEnum.POOL_SCORE_PRICE.getCode());
        if (poolScorePriceDic != null) {
            adminPoolSetVo.setPoolScorePrice(poolScorePriceDic.getValue());
        }
        DataDictionaryCustom poolCashPercentDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(
                PerkEnum.POOL_CASH_PERCENT.getType(),
                PerkEnum.POOL_CASH_PERCENT.getCode());
        if (poolCashPercentDic != null) {
            adminPoolSetVo.setPoolCashPercent(poolCashPercentDic.getValue());
        }
        DataDictionaryCustom poolScorePercentDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(
                PerkEnum.POOL_SCORE_PERCENT.getType(),
                PerkEnum.POOL_SCORE_PERCENT.getCode());
        if (poolScorePercentDic != null) {
            adminPoolSetVo.setPoolScorePercent(poolScorePercentDic.getValue());
        }
        DataDictionaryCustom withdrawScoreCashPercentDic = dataDictionaryCustomMapper.selectDicDataByTypeAndCode(
                PerkEnum.WITHDRAW_SCORE_CASH_PERCENT.getType(),
                PerkEnum.WITHDRAW_SCORE_CASH_PERCENT.getCode());
        if (withdrawScoreCashPercentDic != null) {
            adminPoolSetVo.setWithdrawScoreCashPercent(withdrawScoreCashPercentDic.getValue());
        }

        model.addAttribute("adminPoolSet", adminPoolSetVo);
        return FebsUtil.view("modules/system/poolSet");
    }
}