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;

/**
 * 商户表接口实现
 * @author zhangzeli
 */
@Slf4j
@Service
@Transactional
public class ICustomerServiceImpl extends ServiceImpl<CustomerMapper, Customer> implements ICustomerService {

    @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);
    }

    @Override
    public int sumLogin() {
        return customerMapper.sumLogin();
    }
}