package com.boying.service.impl;
|
|
import cn.hutool.core.date.DateUtil;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.boying.entity.OutPark;
|
import com.boying.entity.Statistic;
|
import com.boying.mapper.OutParkMapper;
|
import com.boying.mapper.StatisticMapper;
|
import com.boying.service.OutParkService;
|
import com.boying.service.StatisticService;
|
import lombok.AllArgsConstructor;
|
import org.springframework.stereotype.Service;
|
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @author kdq
|
* @version 1.0.0
|
* @ClassName OutParkServiceImpl.java
|
* @Description TODO
|
* @createTime 2022年11月20日 10:20:00
|
*/
|
@Service
|
@AllArgsConstructor
|
public class OutParkServiceImpl extends ServiceImpl<OutParkMapper, OutPark> implements OutParkService {
|
private final OutParkMapper outParkMapper;
|
|
@Override
|
public int count1() {
|
QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.between(OutPark::getCreateTime, DateUtil.beginOfDay(new Date()),DateUtil.endOfDay(new Date()))
|
.eq(OutPark::getStatus,1);
|
return outParkMapper.selectCount(wrapper);
|
}
|
|
@Override
|
public int count2() {
|
QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.between(OutPark::getCreateTime, DateUtil.beginOfDay(new Date()),DateUtil.endOfDay(new Date()))
|
.ge(OutPark::getPrice,0);
|
return outParkMapper.selectCount(wrapper);
|
}
|
|
@Override
|
public int count5() {
|
QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.between(OutPark::getCreateTime, DateUtil.beginOfDay(new Date()),DateUtil.endOfDay(new Date()));
|
return outParkMapper.selectCount(wrapper);
|
}
|
|
@Override
|
public double sumByPrice() {
|
QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.between(OutPark::getCreateTime, DateUtil.beginOfDay(new Date()),DateUtil.endOfDay(new Date()))
|
.eq(OutPark::getStatus,1);
|
wrapper.select("IFNULL(ROUND(SUM(price)),0) as num");
|
Map<String, Object> map = getMap(wrapper);
|
String a = map.get("num").toString();
|
if(a!=null){
|
return Double.parseDouble(a);
|
}else{
|
return 0.0;
|
}
|
}
|
|
@Override
|
public int count3() {
|
QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.between(OutPark::getCreateTime, DateUtil.beginOfMonth(new Date()),DateUtil.endOfMonth(new Date()));
|
return outParkMapper.selectCount(wrapper);
|
}
|
|
@Override
|
public double sumByPrice2() {
|
QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.between(OutPark::getCreateTime, DateUtil.beginOfMonth(new Date()),DateUtil.endOfMonth(new Date()))
|
.eq(OutPark::getStatus,1);
|
wrapper.select("IFNULL(ROUND(SUM(price)),0) as num");
|
Map<String, Object> map = getMap(wrapper);
|
String a = map.get("num").toString();
|
if(a!=null){
|
return Double.parseDouble(a);
|
}else{
|
return 0.0;
|
}
|
}
|
|
@Override
|
public OutPark findByCarNo(String serialno) {
|
QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.eq(OutPark::getCarNo,serialno);
|
List<OutPark> outParks = outParkMapper.selectList(wrapper);
|
if(outParks.size()>0){
|
return outParks.get(0);
|
}else{
|
return null;
|
}
|
}
|
|
@Override
|
public OutPark count4(Integer bId) {
|
QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.eq(OutPark::getBarrierId,bId)
|
.eq(OutPark::getStatus,1)
|
.eq(OutPark::getStatus2,0)
|
.orderByDesc(OutPark::getCreateTime);
|
List<OutPark> outParks = outParkMapper.selectList(wrapper);
|
if(outParks.size()>0){
|
return outParks.get(0);
|
}else{
|
return null;
|
}
|
}
|
|
@Override
|
public OutPark findByCarNoAndBarrierId(String carNo, Integer id) {
|
QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.eq(OutPark::getBarrierId,id)
|
.eq(OutPark::getCarNo,carNo)
|
.orderByDesc(OutPark::getCreateTime);
|
List<OutPark> outParks = outParkMapper.selectList(wrapper);
|
if(outParks.size()>0){
|
return outParks.get(0);
|
}else{
|
return null;
|
}
|
}
|
|
@Override
|
public OutPark findByPayCode(String payCode) {
|
QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.eq(OutPark::getCode2,payCode)
|
.orderByDesc(OutPark::getCreateTime);
|
List<OutPark> outParks = outParkMapper.selectList(wrapper);
|
if(outParks.size()>0){
|
return outParks.get(0);
|
}else{
|
return null;
|
}
|
}
|
|
@Override
|
public OutPark findByOrderId(String txnOrderId) {
|
QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
|
wrapper.lambda()
|
.eq(OutPark::getTxnOrderId,txnOrderId)
|
.orderByDesc(OutPark::getCreateTime);
|
List<OutPark> outParks = outParkMapper.selectList(wrapper);
|
if(outParks.size()>0){
|
return outParks.get(0);
|
}else{
|
return null;
|
}
|
}
|
|
@Override
|
public List<OutPark> getList(long current, long size, String carNo, Long parkId, String payCode, String date) {
|
return outParkMapper.getList((current-1)*size,size,carNo,parkId,payCode,date);
|
}
|
|
@Override
|
public long getCount(String carNo, Long parkId, String payCode, String date) {
|
return outParkMapper.getCount(carNo,parkId,payCode,date);
|
}
|
}
|
