From 86c97c6581193886b3922f9e651170cebf1b4522 Mon Sep 17 00:00:00 2001 From: zhangzeli <123456> Date: 星期四, 06 一月 2022 09:59:55 +0800 Subject: [PATCH] 回复 --- xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/ICustomerServiceImpl.java | 23 ++++++++++++++++++++--- 1 files changed, 20 insertions(+), 3 deletions(-) diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/ICustomerServiceImpl.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/ICustomerServiceImpl.java index cd24a8e..125711e 100644 --- a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/ICustomerServiceImpl.java +++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/ICustomerServiceImpl.java @@ -1,16 +1,15 @@ package cn.exrick.xboot.your.serviceimpl; +import cn.exrick.xboot.your.vo.Month; import cn.exrick.xboot.your.mapper.CustomerMapper; import cn.exrick.xboot.your.entity.Customer; import cn.exrick.xboot.your.service.ICustomerService; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; - -import java.util.ArrayList; -import java.util.List; /** * 鍟嗘埛琛ㄦ帴鍙e疄鐜� @@ -23,4 +22,22 @@ @Autowired private CustomerMapper customerMapper; + + @Override + public int countOpenId() { + QueryWrapper<Customer> wrapper = new QueryWrapper<>(); + wrapper.isNotNull("open_id"); + int i = customerMapper.selectCount(wrapper); + int i2 = customerMapper.count(); + if(i2==0){ + return 0; + }else{ + return (i*100)/i2; + } + } + + @Override + public Month getCustomerCount(Integer year) { + return customerMapper.getCustomerCount(year); + } } \ No newline at end of file -- Gitblit v1.9.1