chargeing-parking/src/test/java/com/charging/chargingparking/ChargingParkingApplicationTests.java

package com.charging.chargingparking;

import cn.afterturn.easypoi.excel.ExcelImportUtil;
import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.excel.entity.ImportParams;
import cn.hutool.core.convert.Convert;
import cn.hutool.core.date.*;
import cn.hutool.core.io.resource.ClassPathResource;
import cn.hutool.core.lang.Assert;
import cn.hutool.core.util.NumberUtil;
import cn.hutool.core.util.StrUtil;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.charging.chargingparking.config.ParkingConfig;
import com.charging.chargingparking.constant.ParkingConstant;
import com.charging.chargingparking.dto.*;
import com.charging.chargingparking.entity.*;
import com.charging.chargingparking.mapper.ParkingPayMapper;
import com.charging.chargingparking.mapper.ParkingRecordMapper;
import com.charging.chargingparking.modules.backController.ParkingMemberInfoController;
import com.charging.chargingparking.modules.common.dto.Sort;
import com.charging.chargingparking.modules.vo.ParkingEnableVo;
import com.charging.chargingparking.modules.vo.ProfitVo;
import com.charging.chargingparking.modules.vo.TemporaryVo;
import com.charging.chargingparking.service.*;
import com.charging.chargingparking.sys.entity.User;
import com.charging.chargingparking.sys.service.UserService;
import com.charging.chargingparking.utils.BetweenTimeUtil;
import com.charging.chargingparking.utils.StringUtils;
import com.github.pagehelper.Page;
import com.sun.org.apache.xpath.internal.operations.Bool;
import lombok.Data;
import lombok.extern.slf4j.Slf4j;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.data.redis.core.ValueOperations;

import java.io.File;
import java.io.Serializable;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.concurrent.TimeUnit;
import java.util.function.Supplier;
import java.util.stream.Collectors;

import static cn.hutool.core.date.DateUnit.HOUR;

@SpringBootTest
@Slf4j
class ChargingParkingApplicationTests {

    @Autowired
    private ValueOperations<String, Object> valueOperations;

    @Autowired
    private StringUtils stringUtils;

    @Autowired
    private ParkingInfoService parkingInfoService;

    @Autowired
    private ParkingConfig parkingConfig;

    @Autowired
    private ParkingChannelService parkingChannelService;

    @Autowired
    private ParkingPayProfitService parkingPayProfitService;

    @Autowired
    private ParkingPayService parkingPayService;

    @Autowired
    private ParkingRecordService parkingRecordService;

    @Autowired
    private ParkingRecordMapper parkingRecordMapper;

    @Autowired
    private ParkingFeeService parkingFeeService;

    @Autowired
    private ParkingMemberService parkingMemberService;
    @Autowired
    private ParkingWhiteService parkingWhiteService;

    @Autowired
    private ParkingPayMapper parkingPayMapper;

    @Autowired
    private ParkingChannelVoiceService parkingChannelVoiceService;
    @Autowired
    private UserService userService;
    @Autowired
    private ParkingShopService parkingShopService;
    @Autowired
    private ParkingBetweenMemberService parkingBetweenMemberService;
    @Autowired
    private ParkingTimeService parkingTimeService;
    @Autowired
    private TimeSetService timeSetService;
    @Autowired
    private EcCouponService ecCouponService;
    @Autowired
    private ParkingAreaService parkingAreaService;
    @Test
    void testService() throws Exception {
//        ParkingArea parkingArea = new ParkingArea();
//        parkingArea.setArea("1");
//        parkingArea.setAreaName("121");
//        parkingArea.setParkId("11111");
//        parkingArea.setSurplusParkingNumber(10);
//        parkingArea.setTotalParkingNumber(100);
//        parkingArea.setCreateBy("admin");
//        parkingArea.setCreateTime(new Date());
//        parkingArea.setUpdateBy("updater");
//        parkingArea.setUpdateTime(new Date());
       // parkingAreaService.save(parkingArea);

//        ParkingArea parkingAreaBG = parkingAreaService.getById(1931167050676056066l);
//        parkingAreaBG.setSurplusParkingNumber(9);
//        parkingAreaBG.setUpdateTime(new Date());
//        parkingAreaService.updateById(parkingAreaBG);

        QueryWrapper<ParkingArea> parkingAreaQueryWrapper = new QueryWrapper<>();
        parkingAreaQueryWrapper.eq("park_id", "1");
        parkingAreaQueryWrapper.eq("area_", "1");
        parkingAreaQueryWrapper.last("LIMIT 1");
        ParkingArea parkingArea =parkingAreaService.getOne(parkingAreaQueryWrapper);
        parkingArea.setSurplusParkingNumber(parkingArea.getSurplusParkingNumber()-1);
        if(parkingArea.getSurplusParkingNumber()<1){
            parkingArea.setSurplusParkingNumber(1);
        }
        parkingAreaService.updateById(parkingArea);

        //temporaryCarNumInPark
//        TemporaryVo temporaryVo = new TemporaryVo();
//        temporaryVo.setOpenId("oSruR6X9d6KRfkxT5HJH-lgl1ClY");
//        temporaryVo.setChannelId("1699950640833335297");
//        temporaryVo.setId("1865260254398353410");
//        log.warn(temporaryVo.getOpenId()+"---"+temporaryVo.getChannelId()+"----"+temporaryVo.getCompanyId()+"---"+temporaryVo.getId()+"---"+temporaryVo.getParkId());
////oSruR6X9d6KRfkxT5HJH-lgl1ClY---1699950640833335297----null---1865260254398353410---null
//        parkingRecordService.temporaryCarNumInPark(temporaryVo);


//        ParkingInfo parkingInfo =parkingInfoService.get("1");
//        ParkingChannel parkingChannel =parkingChannelService.getById(1699950640833335297l);
//        String license ="鄂DAC066";
//        String dataStr ="2024-10-09 09:35:07";
//        if("1".equals(parkingInfo.getId())&&parkingChannel.getChannelName().contains("公寓楼入口")){
//            QueryWrapper<ParkingRecord> parkingRecordQueryWrapper1Outer = new QueryWrapper<>();
//            parkingRecordQueryWrapper1Outer.eq("park_id", parkingChannel.getParkId());
//            parkingRecordQueryWrapper1Outer.eq("car_num", license);
//            parkingRecordQueryWrapper1Outer.gt("out_parking_time", DateUtil.offsetMinute(DateUtil.parse(dataStr), -2));
//            parkingRecordQueryWrapper1Outer.eq("release_status", "1");
//            parkingRecordQueryWrapper1Outer.last("LIMIT 1");
//            ParkingRecord parkingRecord1Outer =parkingRecordService.getOne(parkingRecordQueryWrapper1Outer);
//            if (parkingRecord1Outer != null) {
//                throw new Exception(StrUtil.format("进口道闸异常数据-出场后再在2分钟内进场，道闸：{}，车牌：{}，记录：{}", parkingChannel.getChannelName(), license, parkingRecord1Outer.getId()));
//            }
//        }

//        QueryWrapper<ParkingRecord> parkingRecordQueryWrapper01 = new QueryWrapper<>();
//        parkingRecordQueryWrapper01.eq("park_id", "1");
//        parkingRecordQueryWrapper01.eq("car_num", "鄂DAC066");
//        parkingRecordQueryWrapper01.ne("release_status", "-1");
//        parkingRecordQueryWrapper01.ne("release_status", "2");
//        parkingRecordQueryWrapper01.orderByDesc("create_time");
//        parkingRecordQueryWrapper01.last("LIMIT 1");
//        ParkingRecord parkingRecord01 = parkingRecordService.getOne(parkingRecordQueryWrapper01);
//
//        if (parkingRecord01 != null) {
//            Date time = null;
//            //出场后两分钟内不可再次进场
//            if (parkingRecord01.getOutParkingTime() != null) {
//                time = parkingRecord01.getOutParkingTime();
//            }
//            if (time != null) {
//                //设备传递的时间
//                Date recordTime = DateUtil.parse("2024-10-09 11:51:23");
//
//                int min = 10000;
//                if ("公寓出口".equals(parkingChannel.getChannelName())) {
//                    min = -2;
//                }
//
//                Date date = DateUtil.offsetMinute(recordTime, min);
//
//                if (time.compareTo(date) >= 0) {
//                    throw new Exception(StrUtil.format("2分钟内对同一车牌处理1次：{}", "鄂DAC066"));
//                }
//            }
//        }
//        QueryWrapper<ParkingRecord> parkingRecordQueryWrapper = new QueryWrapper<>();
//        parkingRecordQueryWrapper.lt("create_time",DateUtil.offsetDay(new Date(),-30));
//        parkingRecordQueryWrapper.eq("release_status","0");
//        List<ParkingRecord> parkingRecordList = parkingRecordService.list(parkingRecordQueryWrapper);
//        if (parkingRecordList.size()>0){
//            for (ParkingRecord parkingRecord : parkingRecordList){
//                System.out.println("---"+parkingRecord.getCreateTime());
//                parkingRecord.setReleaseStatus("1");
//                parkingRecord.setDelFlag(true);
//                parkingRecord.setUpdateBy("system");
//                parkingRecord.setUpdateTime(new Date());
//                parkingRecord.setRemark(parkingRecord.getRemark()+"系统清理离场");
//                parkingRecordService.updateById(parkingRecord);
//            }
//        }


//        EcCoupon ecCoupon = new EcCoupon();
//        ecCoupon.setCarNum("1");
//        ecCoupon.setParkId("2");
//
//        ecCouponService.save(ecCoupon);

//        ParkingChannel parkingChannel = new ParkingChannel();
//        parkingChannel.setDelFlag(false);
//        parkingChannel.setCreateBy("1");
//        parkingChannel.setCreateTime(new Date());
//        parkingChannel.setCarNumRemark("鄂DF59895");
//        boolean affect = parkingChannelService.save(parkingChannel);
//        parkingChannel.setCarNumRemark("鄂DF59895,鄂DF99999");
//        parkingChannelService.updateById(parkingChannel);




//        ParkingChannel parkingChannel = parkingChannelService.getById(1541608391538962434l);
//
//        String yqll="1541608391538962434";
//        if(yqll.equals(parkingChannel.getId())){
//            System.out.println("11111");
//        }else{
//            System.out.println("000000");
//
//        }
    }
//    @Test
//    void testService()  {
//        QueryWrapper<ParkingRecord> queryWrapper = new QueryWrapper<ParkingRecord>();
//        queryWrapper.select("sum(pay_amount) as sumAll");
//        queryWrapper.eq("car_num","鄂DD10888");
//        //queryWrapper.eq("TO_DAYS(create_time)","TO_DAYS(NOW())");
//        queryWrapper.apply("create_time>=DATE_FORMAT(LAST_DAY(NOW()), '%Y-%m-01')");
//        queryWrapper.apply("create_time<=LAST_DAY(NOW())");
//        ParkingRecord parkingRecord =parkingRecordService.getOne(queryWrapper);
//        if(parkingRecord==null){
//            parkingRecord.setSumAll(BigDecimal.ZERO);
//        }
//        System.out.println(parkingRecord.getSumAll());
//    }
    public static List<String> getDatesBetween(String startDateString, String endDateString) {
        List<DateTime> datesBetween = DateUtil.rangeToList(DateUtil.parseDate(startDateString), DateUtil.parseDate(endDateString), DateField.DAY_OF_MONTH);
        return datesBetween.stream()
                .map(p -> DateUtil.format(p, DatePattern.NORM_DATE_PATTERN))
                .collect(Collectors.toList());
    }
    public static List<String> Date67() {
        int year = DateUtil.year(new Date());
        List<String> dateList=new ArrayList<String>();
        SimpleDateFormat simdf = new SimpleDateFormat("yyyy-MM-dd");
        Calendar calendar = new GregorianCalendar(year, 0, 1);
        int i = 1;
        while (calendar.get(Calendar.YEAR) < year + 1) {
            calendar.set(Calendar.WEEK_OF_YEAR, i++);
            calendar.set(Calendar.DAY_OF_WEEK, Calendar.SUNDAY);
            if (calendar.get(Calendar.YEAR) == year) {
                System.out.println("周日："+simdf.format(calendar.getTime()));
                dateList.add(simdf.format(calendar.getTime()));
            }
            calendar.set(Calendar.DAY_OF_WEEK, Calendar.SATURDAY);
            if (calendar.get(Calendar.YEAR) == year) {
                System.out.println("周六："+simdf.format(calendar.getTime()));
                dateList.add(simdf.format(calendar.getTime()));
            }
        }
        return dateList;
    }
    @Test
    void testTimeParkService()  {
        String strEnterDate="2024-01-06";
        String parkId="836bb65f-868b-4042-acf7-dcb4c4de1f0f";
        Boolean ret = parkingTimeService.enterTimeStatus(strEnterDate,parkId);
        System.out.println(ret);
    }

    @Test
    void testTimePark() throws Exception {
        String strEnterDate="2024-01-06";
        List<String> listAll =new ArrayList<>();
        ParkingInfo parkingInfo = parkingInfoService.getById("836bb65f-868b-4042-acf7-dcb4c4de1f0f");
        DateUtil.year(new Date());
        if(parkingInfo.getStarTimeFlag()!=null&&parkingInfo.getStarTimeFlag()&&parkingInfo.getStartYear()!=null&&parkingInfo.getEndYear()!=null){
            if(parkingInfo.getStartYear()<=DateUtil.year(new Date())){
                if(parkingInfo.getEndYear()>=DateUtil.year(new Date())){
                        //取固定节假日配置
                    List<ParkingTime> listParkingTime = parkingTimeService.list(new QueryWrapper<ParkingTime>().eq("park_id", parkingInfo.getId()).eq("is_custom",false).eq("del_flag",false));
                    for(ParkingTime parkingTime:listParkingTime){
                        TimeSet timeSet =timeSetService.getById(parkingTime.getSetId());
                        if(timeSet.getTsFlag()){
                            //是周6和周日
                            System.out.println("周6和周日");
                            List<String> list =Date67();
                            for(String ds:list){
                                System.out.println("周6和周日:"+ds);
                            }
                            listAll.addAll(list);
                        }else{
                            StringBuilder sbStartStr = new StringBuilder();
                            StringBuilder sbEndStr = new StringBuilder();
                            sbStartStr.append(Integer.toString(DateUtil.year(new Date()))).append("-")
                                    .append(DateUtil.format(timeSet.getStartTime(), "MM-dd"));
                            sbEndStr.append(Integer.toString(DateUtil.year(new Date()))).append("-")
                                    .append(DateUtil.format(timeSet.getEndTime(), "MM-dd"));
                            System.out.println("------:"+sbStartStr.toString());
                            System.out.println("------:"+sbEndStr.toString());
                            List<String> list =getDatesBetween(sbStartStr.toString(),sbEndStr.toString());
                            for(String ds:list){
                                System.out.println("节假日:"+ds);
                            }
                            if(list!=null&&list.size()>0){
                                listAll.addAll(list);
                            }

                        }
                    }
                        //取自定义时间配置
                    List<ParkingTime> listParkingTimeSingle = parkingTimeService.list(new QueryWrapper<ParkingTime>().eq("park_id", parkingInfo.getId()).eq("is_custom",true).eq("del_flag",false));
                    for(ParkingTime parkingTime:listParkingTimeSingle){

                        if(parkingTime.getStartTime()!=null&&parkingTime.getEndTime()!=null){
                            DateUtil.parse("1","yyyy-MM-dd");
                            String stratTime =DateUtil.format(parkingTime.getStartTime(), "yyyy-MM-dd");
                            System.out.println("kais时间:"+stratTime);
                            List<String> list =getDatesBetween(DateUtil.format(parkingTime.getStartTime(), "yyyy-MM-dd"),DateUtil.format(parkingTime.getEndTime(), "yyyy-MM-dd"));
                            for(String ds:list){
                                System.out.println("自定义时间:"+ds);
                            }
                            if(list!=null&&list.size()>0){
                                listAll.addAll(list);
                            }
                        }

                    }
                }
            }
        }
        for(String str:listAll){

            System.out.println("-----所有免费入场时间为:"+str);
        }
        if(listAll.contains(strEnterDate)){
            System.out.println("------免费入场");
        }else{
            System.out.println("------禁止入场");
        }

    }

    @Test
    void testTimeSet() throws Exception {
        ParkingInfo parkingInfo = parkingInfoService.getById("1");
        parkingInfo.setStarTimeFlag(true);
        parkingInfo.setStartYear(2023);
        parkingInfo.setEndYear(2024);
        parkingInfoService.update(parkingInfo);
//        List<TimeSet> list=timeSetService.list();
//
//        System.out.println(list.size());
//
//        ParkingTime parkingTime = new ParkingTime();
//        parkingTime.setParkId("1");
//        parkingTime.setStartTime(new Date());
//        parkingTime.setEndTime(new Date());
//        parkingTimeService.save(parkingTime);
    }

    /**
     * 1.模板数据整理
     * 2.清除2个表的记录，执行导入程序
     * 3.2个表数据迁移到正式环境
     * @throws Exception
     */
    @Test
    void testCarImport() throws Exception {
        //设置导入参数
        ImportParams importParams = new ImportParams();
        importParams.setTitleRows(0); //标题占1行，默认0
        importParams.setHeadRows(1); //表头占1行，默认1
        File file = new File("F:\\文档\\51联盟停车系统\\1车牌号导入模版\\车牌.xlsx");
        List<CarDTO> List =  ExcelImportUtil.importExcel(file,CarDTO.class,importParams);

        for(CarDTO carDTO:List){
            ParkingMember parkingMember = new ParkingMember();
            parkingMember.setParkId("12d332ab-fc02-45f7-81f0-62997d462380");
            parkingMember.setMemberName(carDTO.getName());
            parkingMember.setMemberPhone(carDTO.getPhone());
            parkingMember.setMemberCarNum(carDTO.getNum());
            parkingMember.setMemberStartTime(new Date());
            parkingMember.setMemberEndTime(DateUtil.offsetDay(new Date(),365));
            parkingMember.setDelFlag(false);
            parkingMember.setCreateBy("b9bb22a1-8424-40d1-9cf5-52d08035ab84");
            parkingMember.setCreateTime(new Date());
            parkingMember.setCloudDelFlag(false);
            parkingMember.setMemberType(1);
            //parkingMemberService.save(parkingMember);


            AddParkingMember addParkingMember = new AddParkingMember();
            addParkingMember.setParkingUname(parkingMember.getParkId());
            addParkingMember.setMemberName(parkingMember.getMemberName());
            addParkingMember.setMemberPhone(parkingMember.getMemberPhone());
            addParkingMember.setCarNum(parkingMember.getMemberCarNum());
            addParkingMember.setMemberStartTime(parkingMember.getMemberStartTime());
            addParkingMember.setMemberEndTime(parkingMember.getMemberEndTime());
            addParkingMember.setMemberType(1);
            parkingMemberService.addParkingMember(addParkingMember, true, "72dc480e-6816-4be3-918d-da2436f39627");

        }


    }
    @Test
    void testCarImport2() throws Exception {
        //设置导入参数
        ImportParams importParams = new ImportParams();
        importParams.setTitleRows(0); //标题占1行，默认0
        importParams.setHeadRows(1); //表头占1行，默认1
        File file = new File("F:\\文档\\51联盟停车系统\\1车牌号导入模版\\车牌2.xlsx");
        List<CarDTO2> List =  ExcelImportUtil.importExcel(file,CarDTO2.class,importParams);

        for(CarDTO2 carDTO2:List){
            ParkingMember parkingMember = new ParkingMember();
            parkingMember.setParkId("727289c5-5d02-4f5c-b711-a8e3b6bc5dd0");
            parkingMember.setMemberName(carDTO2.getName());
            parkingMember.setMemberPhone(carDTO2.getPhone());
            parkingMember.setMemberCarNum(carDTO2.getNum());
            parkingMember.setMemberStartTime(DateUtil.parse(carDTO2.getStartTime(),"yyyy-MM-dd HH:mm:ss"));
            parkingMember.setMemberEndTime(DateUtil.parse(carDTO2.getEndTime(),"yyyy-MM-dd HH:mm:ss"));
            parkingMember.setDelFlag(false);
            parkingMember.setCreateBy("b9bb22a1-8424-40d1-9cf5-52d08035ab84");
            parkingMember.setCreateTime(new Date());
            parkingMember.setCloudDelFlag(false);
            parkingMember.setMemberType(1);
            //parkingMemberService.save(parkingMember);


            AddParkingMember addParkingMember = new AddParkingMember();
            addParkingMember.setParkingUname(parkingMember.getParkId());
            addParkingMember.setMemberName(parkingMember.getMemberName());
            addParkingMember.setMemberPhone(parkingMember.getMemberPhone());
            addParkingMember.setCarNum(parkingMember.getMemberCarNum());
            addParkingMember.setMemberStartTime(parkingMember.getMemberStartTime());
            addParkingMember.setMemberEndTime(parkingMember.getMemberEndTime());
            addParkingMember.setMemberType(1);
            parkingMemberService.addParkingMember(addParkingMember, true, "72dc480e-6816-4be3-918d-da2436f39627");

        }


    }
    @Test
    void test123() throws Exception {

        ParkingRecord parkingRecord = parkingRecordService.getById("1686769417542746114");
        if(parkingRecord.getInParkingTime().after(parkingRecord.getOutParkingTime())){
            throw new Exception("会员时间段设置不对");
        }
        QueryWrapper<ParkingBetweenMember> parkingMemberQueryWrapper = new QueryWrapper<>();
        parkingMemberQueryWrapper.eq("member_car_num", "鄂111DDT9443");
        parkingMemberQueryWrapper.eq("park_id", "5f8d343e-63d1-4ef0-9844-855ca020d92b");
        parkingMemberQueryWrapper.eq("cloud_del_flag", false);
        parkingMemberQueryWrapper.orderByDesc("create_time");
        parkingMemberQueryWrapper.last("LIMIT 1");
        ParkingBetweenMember parkingBetweenMember = parkingBetweenMemberService.getOne(parkingMemberQueryWrapper);
        if(parkingBetweenMember!=null){
            String temStartDate01=DateUtil.format(parkingRecord.getInParkingTime(), "yyyy-MM-dd HH:mm:ss");//停车进出场时间区间
            String temStartDate02=DateUtil.format(parkingRecord.getOutParkingTime(), "yyyy-MM-dd HH:mm:ss");

            String temStartDate1=DateUtil.format( parkingBetweenMember.getMemberStartTime(), "yyyy-MM-dd")+" 00:00:00";//会员开始结束时间区间
            String temStartDate2=DateUtil.format( parkingBetweenMember.getMemberEndTime(), "yyyy-MM-dd")+" 23:59:59";
            String startT=parkingBetweenMember.getBtStartTime();//免费开始时间点
            String endT=parkingBetweenMember.getBtEndTime();//免费结束时间点
            long decTimeMins= BetweenTimeUtil.getDecTimeMins(temStartDate01,temStartDate02,temStartDate1,temStartDate2,startT,endT);
            System.out.println("结果:"+decTimeMins);
            System.out.println("---parkingBetweenMember:---"+parkingBetweenMember);
        }
    }

    @Test
    void testJTWYComputerTime() throws Exception {
        ParkingRecord parkingRecord = parkingRecordService.getById("1701489017382604801");
        Integer time =parkingRecordService.getParkingTime(parkingRecord);
        System.out.println("--time:--"+time);
    }
//    @Test
//    void shopDeal() throws Exception {
//        ParkingRecord parkingRecord = parkingRecordService.getById("1686769417542746114");
//        String temDate333 = DateUtil.format(parkingRecord.getOutParkingTime(), "HH:mm:ss");
//        System.out.println(temDate333);
//        System.out.println(parkingRecord);
//        long parkingTimeLong = DateUtil.between(parkingRecord.getInParkingTime(), parkingRecord.getOutParkingTime(), DateUnit.MINUTE);
//        ParkingMember parkingMember= parkingMemberService.getById("035e1761-034b-11ed-b47c-0242ac120004");
//
//        System.out.println(parkingMember);
//        System.out.println( new SimpleDateFormat("yyyyMMddHHmmss").format(new Date()));
//
//        long dayLong =DateUtil.betweenDay(parkingRecord.getInParkingTime(), parkingRecord.getOutParkingTime(),true);
//        dayLong =dayLong+1;
//        System.out.println("天数:"+dayLong);
//
//
//        if(parkingMember.getMemberType()==2){
////            String temDate1 = DateUtil.format(parkingMember.getMemberStartTime(), "yyyy-MM-dd");
////            String temStartDate1 = temDate1 + " "+ parkingMember.getBtStartTime();
////
////            String temDate2 = DateUtil.format(parkingMember.getMemberEndTime(), "yyyy-MM-dd");
////            String temStartDate2 = temDate2 + " "+parkingMember.getBtEndTime();
//            Date startTime= DateUtil.parse(temStartDate1);
//            Date endTime= DateUtil.parse(temStartDate2);
//            System.out.println(startTime);
//            System.out.println(endTime);
//            //要判断区间
//            if(parkingMember.getMemberStartTime().compareTo(parkingRecord.getInParkingTime())>=0){
//                //要减去区间的时间段
//                if(parkingMember.getMemberEndTime().compareTo(parkingRecord.getOutParkingTime())>=0){
//                    //要减去区间的时间段
//                    long hourLong =DateUtil.between(startTime, endTime,HOUR);
//                    System.out.println("小时:"+hourLong);
//                    System.out.println("111");
//                }
//
//            }
//            if(parkingMember.getMemberStartTime().compareTo(parkingRecord.getInParkingTime())<0){
//
//                long hourLong =DateUtil.between(startTime, endTime,HOUR);
//                System.out.println("小时:"+hourLong);
//                long minLong= dayLong*hourLong*60;
//                System.out.println("分钟:"+minLong);
//                System.out.println("111");
//            }
//        }
////        long start = System.currentTimeMillis();
////        log.warn("设备轮询开始时间:{}", DateUtil.format(new Date(),"yyyy-MM-dd hh:mm:ss"));
////        String carNumber="鄂AT27M1";
////        ParkingShop parkingShop = parkingShopService.getById("1590242398638243842");
////        System.out.println(parkingShop);
////        String inTime = parkingShopService.getInTime(carNumber, parkingShop);
////        System.out.println(inTime);
////
////        String memberTime = DateUtil.format(DateUtil.offsetDay(DateUtil.parse(inTime), 1), "yyyy-MM-dd") + " " + parkingShop.getMemberLeaveTime() + ":00";
////        String days = String.valueOf(DateUtil.betweenDay(DateUtil.parse(inTime, "yyyy-MM-dd"), DateUtil.parse(memberTime, "yyyy-MM-dd"), false));
////        System.out.println(memberTime); System.out.println(days);
////        long end = System.currentTimeMillis();
////        log.warn("设备轮询结束时间:{}", DateUtil.format(new Date(),"yyyy-MM-dd hh:mm:ss"));
////        log.warn("设备轮询耗时:{}", end-start);
//    }

    @Test
    void me2() throws Exception {
        String memberId="";
        String parkId="1";
        String license="鄂DD10888";
        parkingMemberService.cloudDeleteTemporary(memberId,parkId,license,"进场发现临时会员的结束时间比当前进场时间小删除");
        System.out.println("1111111");
//        String memberName="汉口银行";
//        Map<String, Object> searchParams = new HashMap<>();
//        if (StringUtils.isNotEmpty(memberName)) {
//            searchParams.put("memberName", "%" + memberName + "%");
//        }
//        List<Sort> sortList = new ArrayList<>();
//        sortList.add(new Sort("a.create_time", "desc"));
//        int pageIndex=1;
//        int pageSize=20;
//        Page<ParkingMember> page = parkingMemberService.pageSearch(searchParams, pageIndex, pageSize, sortList);
//
//
//
//        ParkingMember pm= parkingMemberService.getById("1684016687147438081");
//        pm.setUpdateTime(new Date());
//        pm.setDelFlag(true);
//        parkingMemberService.updateById(pm);



//        QueryWrapper queryWrapper1 = new QueryWrapper();
//        queryWrapper1.eq("car_num", "鄂DDT9329");
//        queryWrapper1.eq("park_id", "1");
//        queryWrapper1.eq("release_status", "0");//未出场
//        List<ParkingRecord> parkingRecordList =parkingRecordService.list(queryWrapper1);
//
//        //add hbjzws 2023-5-23删除进场前未出场的记录
//        if (parkingRecordList.size() > 0) {
//            for (ParkingRecord parkingRecord1 : parkingRecordList) {
//                parkingRecord1.setReleaseStatus("1");
//                parkingRecord1.setUpdateTime(new Date());
//                parkingRecord1.setDelFlag(true);
//                parkingRecordService.updateById(parkingRecord1);
//                parkingRecordMapper.updateDel(parkingRecord1.getId());
//
//
//            }
//        }


//
//        ParkingMember pm= parkingMemberService.getById("1684016687147438081");
//        int h= Convert.toInt(DateUtil.between(pm.getMemberStartTime(), pm.getMemberEndTime(), DateUnit.HOUR));
//        if(h>=48){
//            System.out.println("删除");
//        }
//        QueryWrapper<ParkingMember> parkingMemberQueryWrapper = new QueryWrapper<>();
//        parkingMemberQueryWrapper.eq("park_id","a3eebab8-85f1-475a-a30a-eb96b4c89f52");
//        List<ParkingMember> parkingMemberList = parkingMemberService.list(parkingMemberQueryWrapper);
//
//        for(ParkingMember pm:parkingMemberList){
//
//            parkingWhiteService.addWhiteList(pm.getParkId(), pm.getMemberCarNum(), pm.getMemberStartTime(), pm.getMemberEndTime());
//        }
//        System.out.println(parkingMemberList.size());
    }

    @Test
    void me() throws Exception {
        List<AddParkingMember> list = new ArrayList<>();


       for(int i=0;i<120;i++){
           AddParkingMember addParkingMember = new AddParkingMember();
           addParkingMember.setParkingUname("a3eebab8-85f1-475a-a30a-eb96b4c89f52");
           addParkingMember.setMemberName("居委会");
           addParkingMember.setMemberPhone("15672408899");
           addParkingMember.setCarNum("鄂D9T168"+i);
           addParkingMember.setMemberStartTime(DateUtil.parse("2023-07-14 00:00:00","yyyy-MM-dd HH:mm:ss"));
           addParkingMember.setMemberEndTime(DateUtil.parse("2024-07-14 00:00:00","yyyy-MM-dd HH:mm:ss"));
           addParkingMember.setMemberType(1);
           parkingMemberService.addParkingMember(addParkingMember, true, "72dc480e-6816-4be3-918d-da2436f39627");
       }

    }

    @Test
    void contextLoads51333() throws Exception {
        Map<String,Object> searchParms = new HashMap<>();
        List<Sort> sortList = new ArrayList<>();
        sortList.add(new Sort("a.create_time","asc"));
        Page<User> page = userService.pageSearch(searchParms,1,100,sortList);


        System.out.println(page);
        AddParkingMember addParkingMember = new AddParkingMember();
        addParkingMember.setCarNum("鄂DD91187");
        addParkingMember.setParkingUname("5f8d343e-63d1-4ef0-9844-855ca020d92b");
        addParkingMember.setMemberStartTime(DateUtil.parse("2023-07-01 18:43:10","yyyy-MM-dd HH:mm:ss"));
        addParkingMember.setMemberEndTime(DateUtil.parse("2023-07-01 19:54:10","yyyy-MM-dd HH:mm:ss"));
        addParkingMember.setMemberMin(71);
        addParkingMember.setMemberType(0);
        addParkingMember.setGunType(1);
        parkingMemberService.addParkingMember(addParkingMember,false,null);
    }


    @Test
    void contextLoads51222() throws Exception {
        AddParkingMember addParkingMember = new AddParkingMember();
        addParkingMember.setCarNum("鄂DD37357");
        addParkingMember.setParkingUname("1");
        addParkingMember.setMemberStartTime(DateUtil.parse("2023-07-01 23:06:46","yyyy-MM-dd HH:mm:ss"));
        addParkingMember.setMemberEndTime(null);
        addParkingMember.setMemberMin(53);
        addParkingMember.setMemberType(0);
        addParkingMember.setGunType(1);
        parkingMemberService.addParkingMember(addParkingMember,false,null);
    }


    @Test
    void contextLoads51() throws Exception {


        AddParkingMember addParkingMember = new AddParkingMember();
        addParkingMember.setCarNum("鄂DD37357");
        addParkingMember.setParkingUname("1");
        addParkingMember.setMemberStartTime(DateUtil.parse("2023-06-19 21:17:12","yyyy-MM-dd HH:mm:ss"));
        addParkingMember.setMemberEndTime(DateUtil.parse("2023-06-19 22:42:23","yyyy-MM-dd HH:mm:ss"));
        addParkingMember.setMemberMin(Convert.toInt(DateUtil.between(addParkingMember.getMemberEndTime(), addParkingMember.getMemberStartTime(), DateUnit.MINUTE)));
        addParkingMember.setGunType(1);
        parkingMemberService.addParkingMember(addParkingMember,false,null);
    }

    @Test
    void contextLoads51111() throws Exception {
        AddParkingMember addParkingMember = new AddParkingMember();
        addParkingMember.setCarNum("鄂DD70315");
        addParkingMember.setParkingUname("1");
        addParkingMember.setMemberStartTime(DateUtil.parse("2023-06-19 23:17:12","yyyy-MM-dd HH:mm:ss"));
        addParkingMember.setMemberEndTime(DateUtil.parse("2023-06-20 06:42:23","yyyy-MM-dd HH:mm:ss"));
        addParkingMember.setMemberMin(Convert.toInt(DateUtil.between(addParkingMember.getMemberEndTime(), addParkingMember.getMemberStartTime(), DateUnit.MINUTE)));
        addParkingMember.setGunType(2);
        parkingMemberService.addParkingMember(addParkingMember,false,null);
    }
    @Test
    void contextLoads512() throws Exception {
        AddParkingMember addParkingMember = new AddParkingMember();
        addParkingMember.setCarNum("鄂DD70315");
        addParkingMember.setParkingUname("1");
        addParkingMember.setMemberStartTime(DateUtil.parse("2023-06-19 23:05:11","yyyy-MM-dd HH:mm:ss"));
        addParkingMember.setMemberEndTime(DateUtil.parse("2023-06-20 03:38:31","yyyy-MM-dd HH:mm:ss"));
        addParkingMember.setMemberMin(Convert.toInt(DateUtil.between(addParkingMember.getMemberEndTime(), addParkingMember.getMemberStartTime(), DateUnit.MINUTE)));

        parkingMemberService.addParkingMember(addParkingMember,false,null);
    }

    @Test
    void contextLoadsTime2() {
        //区间内
        String temDate0 =  "2023-06-28 23:05:00";
        String temStartDate0 =  "2023-06-28 23:00:00";
        String temEndDate1 =  "2023-06-29 07:00:00";
        String temDate1 =  "2023-06-29 06:00:00";
        System.out.println(DateUtil.parse(temDate0).compareTo(DateUtil.parse(temStartDate0))>0);
        System.out.println(DateUtil.parse(temDate1).compareTo(DateUtil.parse(temEndDate1))<=0);
    }
    @Test
    void contextLoadsTime4() {
        //半区间1(前处理)
        String temDate0 =  "2023-06-28 22:05:00";
        String temStartDate0 =  "2023-06-28 23:00:00";
        String temEndDate1 =  "2023-06-29 07:00:00";
        String temDate1 =  "2023-06-29 06:00:00";
        System.out.println(DateUtil.parse(temDate0).compareTo(DateUtil.parse(temStartDate0))<=0);
        System.out.println(DateUtil.parse(temDate1).compareTo(DateUtil.parse(temEndDate1))<=0);
    }
    @Test
    void contextLoadsTime3() {
        //半区间1(后处理)
        String temDate0 =  "2023-06-28 23:05:00";
        String temStartDate0 =  "2023-06-28 23:00:00";
        String temEndDate1 =  "2023-06-29 07:00:00";
        String temDate1 =  "2023-06-29 09:00:00";
        System.out.println(DateUtil.parse(temDate0).compareTo(DateUtil.parse(temStartDate0))>0);
        System.out.println(DateUtil.parse(temDate1).compareTo(DateUtil.parse(temEndDate1))>0);
    }

    @Test
    void contextLoadsTime1() {
        //区间外
        String temDate0 =  "2023-06-28 05:05:00";
        String temStartDate0 =  "2023-06-28 23:00:00";
        String temEndDate1 =  "2023-06-29 07:00:00";
        String temDate1 =  "2023-06-29 08:00:00";
        System.out.println(DateUtil.parse(temDate0).compareTo(DateUtil.parse(temStartDate0))<=0);
        System.out.println(DateUtil.parse(temDate1).compareTo(DateUtil.parse(temEndDate1))>0);
    }
    @Test
    void contextLoadsRecord() {
//        JSONObject jsonObject = new JSONObject();
//        jsonObject.put("info", ParkingConstant.OK);
//        jsonObject.put("info", "");
//        System.out.println(jsonObject.toJSONString());
        try {
//鄂A2F922 进出场1分钟内
            ParkingRecord parkingRecord = parkingRecordService.getById("1668844532803878914");

            Date inParkingTime =parkingRecord.getInParkingTime();
            Date outParkingTime =parkingRecord.getOutParkingTime();
            Date date = DateUtil.offsetMinute(outParkingTime, -1);
            if(date.compareTo(inParkingTime)<0){
                if("1".equals(parkingRecord.getReleaseStatus())){
                    parkingRecord.setOutParkingTime(null);
                    parkingRecord.setReleaseStatus("0");//------
                    parkingRecordService.updateById(parkingRecord);
                }
            }
            System.out.println(parkingRecord);
        } catch (Exception ex) {

        }


    }
    @Test
    void contextLoadsFee2() {

        try {
            ParkingRecord parkingRecord0 = parkingRecordService.getById("1657052359020298242");
            Date outParkingTime =parkingRecord0.getOutParkingTime();
            long parkingTimeLong = DateUtil.between(parkingRecord0.getInParkingTime(), outParkingTime, DateUnit.MINUTE);
            //add by hbjzws 2023-06-28 增加对出场跟入场匹配过长的问题
            int maxTTime =24*60*7;
            if(Convert.toInt(parkingTimeLong)>maxTTime){
                Date orgInTime =parkingRecord0.getInParkingTime();
                parkingRecord0.setInParkingTime(DateUtil.offsetMinute(outParkingTime,-maxTTime));
                log.warn(StrUtil.format("停车记录时间过长,存在进场与出场记录不匹配的问题,原先进场时间为:{},修改后的进场时间为{}",DateUtil.format(orgInTime,"yyyy-MM-dd HH:mm:ss"),DateUtil.format(parkingRecord0.getInParkingTime(),"yyyy-MM-dd HH:mm:ss")));
            }


            ParkingCostDTO parkingCostDTO  = null;
                    //parkingFeeService.parkingCost2(parkingRecord0);

            System.out.println(parkingCostDTO);
            BigDecimal parkingCost = parkingCostDTO.getNeedAmount();
            parkingRecord0.setTotalAmount(parkingCost);
            parkingRecordService.updateById(parkingRecord0);
          /*  QueryWrapper<ParkingMember> parkingMemberQueryWrapper = new QueryWrapper<>();
            parkingMemberQueryWrapper.eq("member_car_num", parkingRecord.getCarNum());
            parkingMemberQueryWrapper.eq("park_id", parkingRecord.getParkId());
            parkingMemberQueryWrapper.eq("cloud_del_flag", false);
            parkingMemberQueryWrapper.orderByDesc("create_time");
            parkingMemberQueryWrapper.last("LIMIT 1");
            ParkingMember parkingMember = parkingMemberService.getOne(parkingMemberQueryWrapper);
            System.out.println(parkingMember);*/
        } catch (Exception ex) {

        }


    }
    @Test
    void contextLoads1111111111111111111111111111() {
//111111111111111111111111
        try {
//
//            if (DateUtil.parse("2024-03-27 06:29:09").compareTo(DateUtil.offsetSecond(DateUtil.parse("2024-03-27 06:08:22"), -30)) < 0) {
//
//                System.out.println("1111111111111111");
//            }

            //1771830983861047298 鄂DD26100 荆州院子 136分钟   实际9元 应该收费3元 没有充电---------新能源车
            //1769951488673681409 鄂DD26H6 御河 442分钟-7小时22分钟  实际收费16元 ----------------- 汽油车
            //鄂DD77599 御河社区停车场  1769664940010999810
            //2024-03-18 22:41:36
            //4小时37分钟
            //2024-03-18 18:19:31
            //2024-03-18 22:41:38
            //4
            //1778256096084987905
            //1778720139514056706
            ParkingRecord parkingRecord = parkingRecordService.getById("9932953660705812481");

//            Integer times=parkingRecordService.getParkingTime2new(parkingRecord);
//            System.out.println("停车时长为:"+times);
            ParkingCostDTO parkingCostDTO  = parkingFeeService.parkingCost2(parkingRecord);
           // ParkingCostDTO parkingCostDTO  = parkingFeeService.parkingCost2new(parkingRecord);
            System.out.println(parkingCostDTO);

          /*  QueryWrapper<ParkingMember> parkingMemberQueryWrapper = new QueryWrapper<>();
            parkingMemberQueryWrapper.eq("member_car_num", parkingRecord.getCarNum());
            parkingMemberQueryWrapper.eq("park_id", parkingRecord.getParkId());
            parkingMemberQueryWrapper.eq("cloud_del_flag", false);
            parkingMemberQueryWrapper.orderByDesc("create_time");
            parkingMemberQueryWrapper.last("LIMIT 1");
            ParkingMember parkingMember = parkingMemberService.getOne(parkingMemberQueryWrapper);
            System.out.println(parkingMember);*/
        } catch (Exception ex) {

        }


    }

    @Test
    void testMember() {

//        ParkingInfo parkingInfo = parkingInfoService.getById("1");
//        parkingInfo.setMaxInToOutTime(48);
//        parkingInfoService.updateById(parkingInfo);
//        System.out.println(parkingInfo);

       // ParkingChannel parkingChannel =parkingChannelService.getById(1597417780772667394l);
        ParkingChannel parkingChannel =parkingChannelService.getById(1768525109646168066l);
        try {
            ParkingEnableVo parkingEnableVo = parkingMemberService.parkingMemberStatus("鄂D9758J", parkingChannel);
            System.out.println("开启状态:"+parkingEnableVo.getOpen());
            System.out.println("content:"+parkingEnableVo.getContent());
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    @Test
    public void testVoice(){
        try{
           SerialData serialData =  parkingChannelVoiceService.broadcast("1");
            System.out.println(serialData.toString());

        }catch (Exception ex){

        }
    }

    @Test
    void testUtil() {

        try {
            DateTime d = DateUtil.beginOfDay(new Date());
            int daysInt = Convert.toInt(d);
            System.out.println(daysInt);
        } catch (Exception ex) {
           log.error(ex.getMessage(),ex);
        }


    }

    @Test
    void testProfitVo() {

        try {
            ParkingPay parkingPay = parkingPayService.getById("1537694217050058754");

            ProfitVo profitVo = parkingPayProfitService.getProfitVo(parkingPay,BigDecimal.ZERO);
            System.out.println(profitVo.toString());
        } catch (Exception ex) {
            log.error(ex.getMessage(),ex);
        }


    }

    @Test
    void testGetParkingCost() {
        try {
           ParkingRecord parkingRecord = parkingRecordService.getById("1541977896875294744");
//            ParkingCostDTO parkingCostDTO = parkingFeeService.parkingCost2(parkingRecord);
//            System.out.println(parkingCostDTO.toString());
        } catch (Exception ex) {
            log.error(ex.getMessage(),ex);
        }
    }

    @Test
    public void testGetParkingTime(){
        try{
            ParkingRecord parkingRecord = parkingRecordService.getById("1545572965602619394");
            int time =  parkingRecordService.getParkingTime(parkingRecord);
            //ParkingCostDTO parkingCostDTO = parkingFeeService.parkingCost2(parkingRecord);
            System.out.println("停车时间："+time);
            //System.out.println("费用："+parkingCostDTO.getNeedAmount());
        }catch (Exception ex){

        }
    }

    @Test
    void testChannelHandle(){
        try{
            ParkingChannel parkingChannel = parkingChannelService.getById("1541977896875294744");
            Map<String,Object> map = parkingChannelService.channelHandle(parkingChannel);
            log.warn(map.toString());
        }catch (Exception ex){
        }

    }


    @Test
    void testGetParkDetail(){
        try{
            ParkingDetailDTO parkingDetailDTO = parkingRecordService.getParkDetail("3");
            System.out.println(parkingDetailDTO.toString());
        }catch (Exception ex){
            log.error(ex.getMessage(),ex);
        }
    }

    @Test
    public void testPlateRecord(){
        try{
            AlarmInfoPlate alarmInfoPlate = new AlarmInfoPlate();
            alarmInfoPlate.setSerialno("89bc86da-a4357bee");

            Result result = new Result();
            PlateResult plateResult = new PlateResult();
            TimeStamp timeStamp = new TimeStamp();
            Timeval timeval = new Timeval();
            timeval.setDecyear(2022);
            timeval.setDecmon(11);
            timeval.setDecday(14);
            timeval.setDechour(14);
            timeval.setDecmin(30);
            timeval.setDecsec(00);
            timeStamp.setTimeval(timeval);
            plateResult.setTimeStamp(timeStamp);
            plateResult.setLicense("鄂DD12345");
            plateResult.setPlateid(1);
            plateResult.setType(10);
            plateResult.setTriggerType(10);
            result.setPlateResult(plateResult);
            alarmInfoPlate.setResult(result);

            parkingRecordService.plateRecord(alarmInfoPlate);
        }catch (Exception ex){
            log.error(ex.getMessage(),ex);
        }


    }

}