package com.xjrsoft.module.student.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.github.yulichang.base.MPJBaseServiceImpl;
import com.github.yulichang.wrapper.MPJLambdaWrapper;
import com.xjrsoft.module.student.entity.PbCseFeeobjupdate;
import com.xjrsoft.module.student.entity.PbVXssfdetail;
import com.xjrsoft.module.student.mapper.PbCseFeeobjupdateMapper;
import com.xjrsoft.module.student.service.IPbCseFeeobjupdateService;
import com.xjrsoft.module.student.vo.EnrollmentStatisticsInfoVo;
import com.xjrsoft.module.student.vo.FeeobjupdateXssfdetail;
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;

import java.util.List;

/**
* @title: 
* @Author szs
* @Date: 2024-03-29
* @Version 1.0
*/
@Service
@AllArgsConstructor
public class PbCseFeeobjupdateServiceImpl extends MPJBaseServiceImpl<PbCseFeeobjupdateMapper, PbCseFeeobjupdate> implements IPbCseFeeobjupdateService {
    @Override
    public EnrollmentStatisticsInfoVo getEnrollmentStatisticsInfo() {
        EnrollmentStatisticsInfoVo result = new EnrollmentStatisticsInfoVo();
        //获取所有学生的信息
        LambdaQueryWrapper<PbCseFeeobjupdate> pbCseFeeobjupdateLambdaQueryWrapper = new LambdaQueryWrapper<>();
        pbCseFeeobjupdateLambdaQueryWrapper
                .eq(PbCseFeeobjupdate::getEnteryear, "2024");

        List<PbCseFeeobjupdate> pbCseFeeobjupdateList = this.list(pbCseFeeobjupdateLambdaQueryWrapper);

        //获取所有学生的收费明细
        MPJLambdaWrapper<PbCseFeeobjupdate> feeobjupdateXssfdetailMPJLambdaWrapper = new MPJLambdaWrapper<>();
        feeobjupdateXssfdetailMPJLambdaWrapper
                .selectAs(PbVXssfdetail::getMny, FeeobjupdateXssfdetail::getMny)
                .selectAs(PbCseFeeobjupdate::getPersonalid, FeeobjupdateXssfdetail::getPersonalid)
                .leftJoin(PbVXssfdetail.class, PbVXssfdetail::getPersonalid, PbCseFeeobjupdate::getPersonalid)
                .eq(PbCseFeeobjupdate::getEnteryear, "2024")
        ;
        List<FeeobjupdateXssfdetail> feeobjupdateXssfdetailList = this.selectJoinList(FeeobjupdateXssfdetail.class, feeobjupdateXssfdetailMPJLambdaWrapper);



        return result;
    }
}