package com.boying.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.boying.entity.OrderRecord;
|
import com.boying.mapper.OrderRecordMapper;
|
import com.boying.service.OrderRecordService;
|
import org.springframework.stereotype.Service;
|
|
import java.util.Date;
|
import java.util.Map;
|
|
/**
|
* @author kdq
|
* @version 1.0.0
|
* @ClassName OrderRecordServiceImpl.java
|
* @Description TODO
|
* @createTime 2022年11月21日 08:34:00
|
*/
|
@Service
|
public class OrderRecordServiceImpl extends ServiceImpl<OrderRecordMapper, OrderRecord> implements OrderRecordService {
|
@Override
|
public long countByYear(Date yearFirst, Date yearLast) {
|
QueryWrapper<OrderRecord> wrapper =new QueryWrapper<>();
|
wrapper.lambda()
|
.eq(OrderRecord::getType,0)
|
.between(OrderRecord::getCreateTime,yearFirst,yearLast);
|
return count(wrapper);
|
}
|
|
@Override
|
public Double sumByYear(Date yearFirst, Date yearLast) {
|
QueryWrapper<OrderRecord> wrapper =new QueryWrapper<>();
|
wrapper.select("IFNULL(SUM(money),0) as money");
|
wrapper.lambda()
|
.eq(OrderRecord::getType,0)
|
.eq(OrderRecord::getStatus,1)
|
.between(OrderRecord::getCreateTime,yearFirst,yearLast);
|
Map<String, Object> map = getMap(wrapper);
|
return Double.valueOf(map.get("money").toString());
|
}
|
}
|
