Pu Zhibing
1 天以前 6a8ff464c7979bc9412734de5642592b804a656c
ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/GovernmentCloudAccountController.java
@@ -5,10 +5,13 @@
import com.ruoyi.account.api.vo.GovernmentCloudAccountVO;
import com.ruoyi.account.service.*;
import com.ruoyi.common.core.domain.R;
import com.ruoyi.common.core.web.domain.BasePojo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.Date;
import java.util.List;
/**
@@ -43,25 +46,59 @@
    @Autowired
    private TInvoiceInformationService invoiceInformationService;
    /**
     * 政务云查询数据接口
     * @return
     */
    @PostMapping("/listAll")
    R<GovernmentCloudAccountVO> listAll() {
        LocalDateTime end = LocalDateTime.now();
        LocalDateTime start = LocalDateTime.now().minusDays(1);
        String start =  LocalDate.now().minusDays(1)+" 00:00:00";
        String end =  LocalDate.now().minusDays(1)+" 23:59:59";
        GovernmentCloudAccountVO governmentCloudAccountVO = new GovernmentCloudAccountVO();
        List<TAppCoupon> list1 = tAppCouponService.lambdaQuery().between(TAppCoupon::getCreateTime, start, end).list();
        List<TAppUser> list2 = appUserService.lambdaQuery().between(TAppUser::getCreateTime, start, end).list();
        List<TAppUserAddress> list3 = appUserAddressService.lambdaQuery().between(TAppUserAddress::getCreateTime, start, end).list();
        List<TAppUserCar> list4 = appUserCarService.lambdaQuery().between(TAppUserCar::getCreateTime, start, end).list();
        List<TAppUserIntegralChange> list5 = appUserIntegralChangeService.lambdaQuery().between(TAppUserIntegralChange::getCreateTime, start, end).list();
        List<TAppUserSign> list6 = appUserSignService.lambdaQuery().between(TAppUserSign::getCreateTime, start, end).list();
        List<TAppUserTag> list7 = appUserTagService.lambdaQuery().between(TAppUserTag::getCreateTime, start, end).list();
        List<TAppUserVipDetail> list8 = appUserVipDetailService.lambdaQuery().between(TAppUserVipDetail::getCreateTime, start, end).list();
        List<TInviteUser> list9 = inviteUserService.lambdaQuery().between(TInviteUser::getCreateTime, start, end).list();
        List<TInvoiceInformation> list10 = invoiceInformationService.lambdaQuery().between(TInvoiceInformation::getCreateTime, start, end).list();
        List<TAppCoupon> list1 = tAppCouponService.lambdaQuery()
                .ge(TAppCoupon::getCreateTime, start)
                .le(TAppCoupon::getCreateTime, end)
                .list();
        List<TAppUser> list2 = appUserService.lambdaQuery()
                .ge(TAppUser::getCreateTime, start)
                .le(TAppUser::getCreateTime, end)
                .list();
        List<TAppUserAddress> list3 = appUserAddressService.lambdaQuery()
                .ge(TAppUserAddress::getCreateTime, start)
                .le(TAppUserAddress::getCreateTime, end)
                .list();
        List<TAppUserCar> list4 = appUserCarService.lambdaQuery()
                .ge(TAppUserCar::getCreateTime, start)
                .le(TAppUserCar::getCreateTime, end)
                .list();
        List<TAppUserIntegralChange> list5 = appUserIntegralChangeService.lambdaQuery()
                .ge(TAppUserIntegralChange::getCreateTime, start)
                .le(TAppUserIntegralChange::getCreateTime, end)
                .list();
        List<TAppUserSign> list6 = appUserSignService.lambdaQuery()
                .ge(TAppUserSign::getCreateTime, start)
                .le(TAppUserSign::getCreateTime, end)
                .list();
        List<TAppUserTag> list7 = appUserTagService.lambdaQuery()
                .ge(TAppUserTag::getCreateTime, start)
                .le(TAppUserTag::getCreateTime, end)
                .list();
        List<TAppUserVipDetail> list8 = appUserVipDetailService.lambdaQuery()
                .ge(TAppUserVipDetail::getCreateTime, start)
                .le(TAppUserVipDetail::getCreateTime, end)
                .list();
        List<TInviteUser> list9 = inviteUserService.lambdaQuery()
                .ge(TInviteUser::getCreateTime, start)
                .le(TInviteUser::getCreateTime, end)
                .list();
        List<TInvoiceInformation> list10 = invoiceInformationService.lambdaQuery()
                .ge(TInvoiceInformation::getCreateTime, start)
                .le(TInvoiceInformation::getCreateTime, end)
                .list();
        for (TAppUserSign tAppUserSign : list6) {
            tAppUserSign.setSignDay(null);
        }
        governmentCloudAccountVO.setAppCoupons(list1);
        governmentCloudAccountVO.setAppUsers(list2);
        governmentCloudAccountVO.setAppUserAddresses(list3);