package org.jeecg.modules.eam.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.jeecg.common.constant.CommonConstant;
import org.jeecg.common.util.DateUtils;
import org.jeecg.modules.eam.entity.Equipment;
import org.jeecg.modules.eam.entity.EquipmentReportRepair;
import org.jeecg.modules.eam.entity.RepairOrder;
import org.jeecg.modules.eam.entity.RepairOrderDetail;
import org.jeecg.modules.eam.mapper.*;
import org.jeecg.modules.eam.service.IEamEquipmentService;
import org.jeecg.modules.eam.service.IEquipmentReportRepairService;
import org.jeecg.modules.eam.service.IRepairOrderDetailService;
import org.jeecg.modules.eam.service.IRepairOrderService;
import org.jeecg.modules.eam.vo.EquipmentAvailabilityVo;
import org.jeecg.modules.system.entity.SysUser;
import org.jeecg.modules.system.mapper.SysUserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.io.Serializable;
import java.math.BigDecimal;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.time.YearMonth;
import java.util.*;

/**
 * @Description: 维修工单
 * @Author: jeecg-boot
 * @Date:   2023-04-25
 * @Version: V1.0
 */
@Service
public class RepairOrderServiceImpl extends ServiceImpl<RepairOrderMapper, RepairOrder> implements IRepairOrderService {

	@Autowired
	private RepairOrderMapper repairOrderMapper;
	@Autowired
	private RepairOrderDetailMapper repairOrderDetailMapper;
	@Autowired
	private RepairOrderRiskPreventionMapper repairOrderRiskPreventionMapper;
	@Autowired
	private RepairOrderFaultAnalysisMapper repairOrderFaultAnalysisMapper;
	@Autowired
	private RepairOrderPlanMaterialMapper repairOrderPlanMaterialMapper;
	@Autowired
	private RepairOrderActualMaterialMapper repairOrderActualMaterialMapper;
	@Autowired
	private RepairOrderActualWorkHoursMapper repairOrderActualWorkHoursMapper;
	@Autowired
	private EquipmentDocumentMapper equipmentDocumentMapper;
	@Autowired
	private SysUserMapper sysUserMapper;
	@Autowired
	private IEamEquipmentService equipmentService;
	@Autowired
	private IEquipmentReportRepairService equipmentReportRepairService;



	@Override
	@Transactional(rollbackFor = Exception.class)
	public void delMain(String id) {
		repairOrderDetailMapper.deleteByMainId(id);
		repairOrderRiskPreventionMapper.deleteByMainId(id);
		repairOrderFaultAnalysisMapper.deleteByMainId(id);
		repairOrderPlanMaterialMapper.deleteByMainId(id);
		repairOrderActualMaterialMapper.deleteByMainId(id);
		repairOrderActualWorkHoursMapper.deleteByMainId(id);
		equipmentDocumentMapper.deleteByMainId(id);
		repairOrderMapper.deleteById(id);
	}

	@Override
	@Transactional(rollbackFor = Exception.class)
	public void delBatchMain(Collection<? extends Serializable> idList) {
		for(Serializable id:idList) {
			repairOrderDetailMapper.deleteByMainId(id.toString());
			repairOrderRiskPreventionMapper.deleteByMainId(id.toString());
			repairOrderFaultAnalysisMapper.deleteByMainId(id.toString());
			repairOrderPlanMaterialMapper.deleteByMainId(id.toString());
			repairOrderActualMaterialMapper.deleteByMainId(id.toString());
			repairOrderActualWorkHoursMapper.deleteByMainId(id.toString());
			equipmentDocumentMapper.deleteByMainId(id.toString());
			repairOrderMapper.deleteById(id);
		}
	}

	@Override
	public Page<RepairOrder> getRepairOrderList(Page<RepairOrder> page, RepairOrder repairOrder) {
		if(StringUtils.isNotBlank(repairOrder.getUserId())){
			SysUser sysUser = sysUserMapper.selectById(repairOrder.getUserId());
			repairOrder.setTeamId(sysUser.getTeamId());
		}else{
			repairOrder.setTeamId("");
		}
		List<String> equipNums = new ArrayList<>();
        if(StringUtils.isNotBlank(repairOrder.getNums())){
        	equipNums = Arrays.asList(repairOrder.getNums().trim().split(","));
		}
		return page.setRecords(baseMapper.getRepairOrderList(page,repairOrder.getId(),repairOrder.getNum(),repairOrder.getEquipmentNum(),repairOrder.getEquipmentName(),repairOrder.getStatus(),repairOrder.getRepairOrderType(),repairOrder.getEquipmentCategoryId(),repairOrder.getFactoryModelId(),repairOrder.getSpecificEquipment(),repairOrder.getTeamId(),equipNums,repairOrder.getRepairOrderUda1()));
	}

	@Override
	public IPage<Map<String, Object>> getUserTeam(Integer pageNo, Integer pageSize, Map<String, Object> params) {
		IPage<Map> pageData = new Page<Map>(pageNo, pageSize);
		String realname = null;
		if (params.get("realname")!=null){
			 realname = String.valueOf(params.get("realname"));
		}
		return super.baseMapper.getUserTeam(pageData,realname);
	}

	@Override
	public IPage<Map<String, Object>> getMaterialSpareList(Integer pageNo, Integer pageSize, Map<String, Object> params) {
		IPage<Map> pageData = new Page<Map>(pageNo, pageSize);
		String num = null;
		String status = null;
		if (params.get("num")!=null){
			num = String.valueOf(params.get("num"));
		}
		if (params.get("status")!=null){
			status = String.valueOf(params.get("status"));
		}
		return super.baseMapper.getMaterialSpareList(pageData,num,status);
	}

	@Override
	public List<EquipmentAvailabilityVo> equipmentAvailability(Map<String, String> query) throws ParseException {
		List<EquipmentAvailabilityVo> equipmentAvailabilityVoList = new ArrayList<>();
		String yearStr = query.get("year");
		String startTime1 = "";
		String endTime1 = "";
		String startTime2 = "";
		String endTime2 = "";
		String startTime3 = "";
		String endTime3 = "";
		String startTime4 = "";
		String endTime4 = "";
		String startTime5 = "";
		String endTime5 = "";
		String startTime6 = "";
		String endTime6 = "";
		String startTime7 = "";
		String endTime7 = "";
		String startTime8 = "";
		String endTime8 = "";
		String startTime9 = "";
		String endTime9 = "";
		String startTime10 = "";
		String endTime10 = "";
		String startTime11 = "";
		String endTime11 = "";
		String startTime12 = "";
		String endTime12 = "";
        YearMonth yearMonth = null;
        if(StringUtils.isBlank(yearStr)){
			return equipmentAvailabilityVoList;
		}else {
            //根据年份获取本年度2月份有多少天
            yearMonth = YearMonth.of(Integer.parseInt(yearStr),2);
			startTime1 = yearStr+"-01-01 00:00:00";
			endTime1 = yearStr+"-01-31 23:59:59";
			startTime2 = yearStr+"-02-01 00:00:00";
			endTime2 = yearStr+"-02-"+String.valueOf(yearMonth.lengthOfMonth())+" 23:59:59";
			startTime3 = yearStr+"-03-01 00:00:00";
			endTime3 = yearStr+"-03-31 23:59:59";
			startTime4 = yearStr+"-04-01 00:00:00";
			endTime4 = yearStr+"-04-30 23:59:59";
			startTime5 = yearStr+"-05-01 00:00:00";
			endTime5 = yearStr+"-05-31 23:59:59";
			startTime6 = yearStr+"-06-01 00:00:00";
			endTime6 = yearStr+"-06-30 23:59:59";
			startTime7 = yearStr+"-07-01 00:00:00";
			endTime7 = yearStr+"-07-31 23:59:59";
			startTime8 = yearStr+"-08-01 00:00:00";
			endTime8 = yearStr+"-08-31 23:59:59";
			startTime9 = yearStr+"-09-01 00:00:00";
			endTime9 = yearStr+"-09-30 23:59:59";
			startTime10 = yearStr+"-10-01 00:00:00";
			endTime10 = yearStr+"-10-31 23:59:59";
			startTime11 = yearStr+"-11-01 00:00:00";
			endTime11 = yearStr+"-11-30 23:59:59";
			startTime12 = yearStr+"-12-01 00:00:00";
			endTime12 = yearStr+"-12-31 23:59:59";
		}
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		Date startDate1 = sdf.parse(startTime1);
		Date endDate1 = sdf.parse(endTime1);
		Date startDate2 = sdf.parse(startTime2);
		Date endDate2 = sdf.parse(endTime2);
		Date startDate3 = sdf.parse(startTime3);
		Date endDate3 = sdf.parse(endTime3);
		Date startDate4 = sdf.parse(startTime4);
		Date endDate4 = sdf.parse(endTime4);
		Date startDate5 = sdf.parse(startTime5);
		Date endDate5 = sdf.parse(endTime5);
		Date startDate6 = sdf.parse(startTime6);
		Date endDate6 = sdf.parse(endTime6);
		Date startDate7 = sdf.parse(startTime7);
		Date endDate7 = sdf.parse(endTime7);
		Date startDate8 = sdf.parse(startTime8);
		Date endDate8 = sdf.parse(endTime8);
		Date startDate9 = sdf.parse(startTime9);
		Date endDate9 = sdf.parse(endTime9);
		Date startDate10 = sdf.parse(startTime10);
		Date endDate10 = sdf.parse(endTime10);
		Date startDate11 = sdf.parse(startTime11);
		Date endDate11 = sdf.parse(endTime11);
		Date startDate12 = sdf.parse(startTime12);
		Date endDate12 = sdf.parse(endTime12);
		EquipmentAvailabilityVo equipmentAvailabilityVo1 = this.getFaultTime(startDate1,endDate1,"1",31);
		EquipmentAvailabilityVo equipmentAvailabilityVo2 = this.getFaultTime(startDate2,endDate2,"2",yearMonth.lengthOfMonth());
		EquipmentAvailabilityVo equipmentAvailabilityVo3 = this.getFaultTime(startDate3,endDate3,"3",31);
		EquipmentAvailabilityVo equipmentAvailabilityVo4 = this.getFaultTime(startDate4,endDate4,"4",30);
		EquipmentAvailabilityVo equipmentAvailabilityVo5 = this.getFaultTime(startDate5,endDate5,"5",31);
		EquipmentAvailabilityVo equipmentAvailabilityVo6 = this.getFaultTime(startDate6,endDate6,"6",30);
		EquipmentAvailabilityVo equipmentAvailabilityVo7 = this.getFaultTime(startDate7,endDate7,"7",31);
		EquipmentAvailabilityVo equipmentAvailabilityVo8 = this.getFaultTime(startDate8,endDate8,"8",31);
		EquipmentAvailabilityVo equipmentAvailabilityVo9 = this.getFaultTime(startDate9,endDate9,"9",30);
		EquipmentAvailabilityVo equipmentAvailabilityVo10 = this.getFaultTime(startDate10,endDate10,"10",31);
		EquipmentAvailabilityVo equipmentAvailabilityVo11 = this.getFaultTime(startDate11,endDate11,"11",30);
		EquipmentAvailabilityVo equipmentAvailabilityVo12 = this.getFaultTime(startDate12,endDate12,"12",31);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo1);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo2);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo3);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo4);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo5);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo6);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo7);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo8);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo9);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo10);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo11);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo12);
		return equipmentAvailabilityVoList;
	}

	@Override
	public List<EquipmentAvailabilityVo> getStartRate(Map<String, String> query) throws ParseException {
		List<EquipmentAvailabilityVo> equipmentAvailabilityVoList = new ArrayList<>();
		String yearStr = query.get("year");
		String startTime1 = "";
		String endTime1 = "";
		String startTime2 = "";
		String endTime2 = "";
		String startTime3 = "";
		String endTime3 = "";
		String startTime4 = "";
		String endTime4 = "";
		String startTime5 = "";
		String endTime5 = "";
		String startTime6 = "";
		String endTime6 = "";
		String startTime7 = "";
		String endTime7 = "";
		String startTime8 = "";
		String endTime8 = "";
		String startTime9 = "";
		String endTime9 = "";
		String startTime10 = "";
		String endTime10 = "";
		String startTime11 = "";
		String endTime11 = "";
		String startTime12 = "";
		String endTime12 = "";
		YearMonth yearMonth = null;
		if(StringUtils.isBlank(yearStr)){
			return equipmentAvailabilityVoList;
		}else {
			//根据年份获取本年度2月份有多少天
			yearMonth = YearMonth.of(Integer.parseInt(yearStr),2);
			startTime1 = yearStr+"-01-01 00:00:00";
			endTime1 = yearStr+"-01-31 23:59:59";
			startTime2 = yearStr+"-02-01 00:00:00";
			endTime2 = yearStr+"-02-"+String.valueOf(yearMonth.lengthOfMonth())+" 23:59:59";
			startTime3 = yearStr+"-03-01 00:00:00";
			endTime3 = yearStr+"-03-31 23:59:59";
			startTime4 = yearStr+"-04-01 00:00:00";
			endTime4 = yearStr+"-04-30 23:59:59";
			startTime5 = yearStr+"-05-01 00:00:00";
			endTime5 = yearStr+"-05-31 23:59:59";
			startTime6 = yearStr+"-06-01 00:00:00";
			endTime6 = yearStr+"-06-30 23:59:59";
			startTime7 = yearStr+"-07-01 00:00:00";
			endTime7 = yearStr+"-07-31 23:59:59";
			startTime8 = yearStr+"-08-01 00:00:00";
			endTime8 = yearStr+"-08-31 23:59:59";
			startTime9 = yearStr+"-09-01 00:00:00";
			endTime9 = yearStr+"-09-30 23:59:59";
			startTime10 = yearStr+"-10-01 00:00:00";
			endTime10 = yearStr+"-10-31 23:59:59";
			startTime11 = yearStr+"-11-01 00:00:00";
			endTime11 = yearStr+"-11-30 23:59:59";
			startTime12 = yearStr+"-12-01 00:00:00";
			endTime12 = yearStr+"-12-31 23:59:59";
		}
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		Date startDate1 = sdf.parse(startTime1);
		Date endDate1 = sdf.parse(endTime1);
		Date startDate2 = sdf.parse(startTime2);
		Date endDate2 = sdf.parse(endTime2);
		Date startDate3 = sdf.parse(startTime3);
		Date endDate3 = sdf.parse(endTime3);
		Date startDate4 = sdf.parse(startTime4);
		Date endDate4 = sdf.parse(endTime4);
		Date startDate5 = sdf.parse(startTime5);
		Date endDate5 = sdf.parse(endTime5);
		Date startDate6 = sdf.parse(startTime6);
		Date endDate6 = sdf.parse(endTime6);
		Date startDate7 = sdf.parse(startTime7);
		Date endDate7 = sdf.parse(endTime7);
		Date startDate8 = sdf.parse(startTime8);
		Date endDate8 = sdf.parse(endTime8);
		Date startDate9 = sdf.parse(startTime9);
		Date endDate9 = sdf.parse(endTime9);
		Date startDate10 = sdf.parse(startTime10);
		Date endDate10 = sdf.parse(endTime10);
		Date startDate11 = sdf.parse(startTime11);
		Date endDate11 = sdf.parse(endTime11);
		Date startDate12 = sdf.parse(startTime12);
		Date endDate12 = sdf.parse(endTime12);
		EquipmentAvailabilityVo equipmentAvailabilityVo1 = this.getRepairTime(startDate1,endDate1,"1",31);
		EquipmentAvailabilityVo equipmentAvailabilityVo2 = this.getRepairTime(startDate2,endDate2,"2",yearMonth.lengthOfMonth());
		EquipmentAvailabilityVo equipmentAvailabilityVo3 = this.getRepairTime(startDate3,endDate3,"3",31);
		EquipmentAvailabilityVo equipmentAvailabilityVo4 = this.getRepairTime(startDate4,endDate4,"4",30);
		EquipmentAvailabilityVo equipmentAvailabilityVo5 = this.getRepairTime(startDate5,endDate5,"5",31);
		EquipmentAvailabilityVo equipmentAvailabilityVo6 = this.getRepairTime(startDate6,endDate6,"6",30);
		EquipmentAvailabilityVo equipmentAvailabilityVo7 = this.getRepairTime(startDate7,endDate7,"7",31);
		EquipmentAvailabilityVo equipmentAvailabilityVo8 = this.getRepairTime(startDate8,endDate8,"8",31);
		EquipmentAvailabilityVo equipmentAvailabilityVo9 = this.getRepairTime(startDate9,endDate9,"9",30);
		EquipmentAvailabilityVo equipmentAvailabilityVo10 = this.getRepairTime(startDate10,endDate10,"10",31);
		EquipmentAvailabilityVo equipmentAvailabilityVo11 = this.getRepairTime(startDate11,endDate11,"11",30);
		EquipmentAvailabilityVo equipmentAvailabilityVo12 = this.getRepairTime(startDate12,endDate12,"12",31);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo1);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo2);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo3);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo4);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo5);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo6);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo7);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo8);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo9);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo10);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo11);
		equipmentAvailabilityVoList.add(equipmentAvailabilityVo12);
		return equipmentAvailabilityVoList;
	}

	public EquipmentAvailabilityVo getFaultTime(Date startDate,Date endDate,String month,int days) throws ParseException {
		List<Equipment> equipmentList = equipmentService.lambdaQuery().eq(Equipment::getEquipmentImportanceId,"A").eq(Equipment::getDelFlag, CommonConstant.DEL_FLAG_0).lt(Equipment::getAcceptanceCheckDate,endDate).list();
        //A类设备台数
		int countA = equipmentList.size();
		EquipmentAvailabilityVo equipmentAvailabilityVo = new EquipmentAvailabilityVo();
		BigDecimal equipmentFaultTime = new BigDecimal("0");
		//故障台次
		int count = 0;
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		if(countA == 0){
			equipmentAvailabilityVo.setMonth(month);
			equipmentAvailabilityVo.setCountA(countA);
			equipmentAvailabilityVo.setFaultNumber("0");
			equipmentAvailabilityVo.setFaultDuration(new BigDecimal("0"));
			equipmentAvailabilityVo.setAvailability("0%");
		}
		//查询一月份故障时间
		for(Equipment equipment : equipmentList){
			//查询设备是否有报修单
			List<EquipmentReportRepair> equipmentReportRepairList = equipmentReportRepairService.lambdaQuery().eq(EquipmentReportRepair::getEquipmentId,equipment.getId())
					.eq(EquipmentReportRepair::getDelFlag,CommonConstant.DEL_FLAG_0).list();
			if(CollectionUtils.isNotEmpty(equipmentReportRepairList)){
				//当前设备的故障时间集合，用于判断多次故障是否发生在同一天
				List<String> faultTimeList = new ArrayList<>();
				//一、查询故障时间
				for(EquipmentReportRepair equipmentReportRepair : equipmentReportRepairList){
					//1、如果报修时间不为空，并且在查询时间段内
					if(equipmentReportRepair.getFaultTime() != null && equipmentReportRepair.getFaultTime().compareTo(endDate) < 0 &&  equipmentReportRepair.getFaultTime().compareTo(startDate) > 0){
						//2、验收时间在查询时间段内
						if(equipmentReportRepair.getAcceptTime() != null && equipmentReportRepair.getAcceptTime().compareTo(endDate) < 0){
							equipmentFaultTime = equipmentFaultTime.add(new BigDecimal(equipmentReportRepair.getFaultHour()));
							int flag = 0;
							if(CollectionUtils.isNotEmpty(faultTimeList)){
								for(String faultTime : faultTimeList){
									if(faultTime.equals(sdf.format(equipmentReportRepair.getFaultTime()))){
										flag = 1;
									}
								}
							}
							if(flag == 0){
								count++;
								faultTimeList.add(sdf.format(equipmentReportRepair.getFaultTime()));
							}
							//3、验收时间大于查询结束时间
						}else {
							long diff2 = endDate.getTime() - equipmentReportRepair.getFaultTime().getTime();
							BigDecimal faultTime1 = new BigDecimal(diff2)
									.divide(new BigDecimal(60 * 60 * 1000), 2, BigDecimal.ROUND_HALF_EVEN);
							equipmentFaultTime = equipmentFaultTime.add(faultTime1);
							int flag = 0;
							if(CollectionUtils.isNotEmpty(faultTimeList)){
								for(String faultTime : faultTimeList){
									if(faultTime.equals(sdf.format(equipmentReportRepair.getFaultTime()))){
										flag = 1;
									}
								}
							}
							if(flag == 0){
								count++;
								faultTimeList.add(sdf.format(equipmentReportRepair.getFaultTime()));
							}
						}
						//4、报修时间在查询开始时间之前
					}else if(equipmentReportRepair.getFaultTime().compareTo(startDate) < 0 ){
						//5、验收时间在查询时间段内
						if(equipmentReportRepair.getAcceptTime() != null && equipmentReportRepair.getAcceptTime().compareTo(endDate) < 0){
							long diff2 = equipmentReportRepair.getAcceptTime().getTime() - startDate.getTime();
							BigDecimal faultTime1 = new BigDecimal(diff2)
									.divide(new BigDecimal(60 * 60 * 1000), 2, BigDecimal.ROUND_HALF_EVEN);
							equipmentFaultTime = equipmentFaultTime.add(faultTime1);
							int flag = 0;
							if(CollectionUtils.isNotEmpty(faultTimeList)){
								for(String faultTime : faultTimeList){
									if(faultTime.equals(sdf.format(equipmentReportRepair.getFaultTime()))){
										flag = 1;
									}
								}
							}
							if(flag == 0){
								count++;
								faultTimeList.add(sdf.format(equipmentReportRepair.getFaultTime()));
							}
							//6、验收时间为空或验收时间在查询结束时间之后
						}else {
							long diff2 = endDate.getTime() - startDate.getTime();
							BigDecimal faultTime1 = new BigDecimal(diff2)
									.divide(new BigDecimal(60 * 60 * 1000), 2, BigDecimal.ROUND_HALF_EVEN);
							equipmentFaultTime = equipmentFaultTime.add(faultTime1);
							int flag = 0;
							if(CollectionUtils.isNotEmpty(faultTimeList)){
								for(String faultTime : faultTimeList){
									if(faultTime.equals(sdf.format(equipmentReportRepair.getFaultTime()))){
										flag = 1;
									}
								}
							}
							if(flag == 0){
								count++;
								faultTimeList.add(sdf.format(equipmentReportRepair.getFaultTime()));
							}
						}
					}
				}
				BigDecimal availability = new BigDecimal(countA).multiply(new BigDecimal(days)).subtract(new BigDecimal(count)).multiply(new BigDecimal(100)).divide(new BigDecimal(countA).multiply(new BigDecimal(days)),2,BigDecimal.ROUND_HALF_EVEN);
				equipmentAvailabilityVo.setMonth(month);
				equipmentAvailabilityVo.setCountA(countA);
				equipmentAvailabilityVo.setFaultNumber(String.valueOf(count));
				equipmentAvailabilityVo.setFaultDuration(equipmentFaultTime);
				equipmentAvailabilityVo.setAvailability(availability +"%");
			}else {
				equipmentAvailabilityVo.setMonth(month);
				equipmentAvailabilityVo.setCountA(countA);
				equipmentAvailabilityVo.setFaultNumber("0");
				equipmentAvailabilityVo.setFaultDuration(new BigDecimal("0"));
				equipmentAvailabilityVo.setAvailability("100%");
			}
		}
		return equipmentAvailabilityVo;
	}

	public EquipmentAvailabilityVo getRepairTime(Date startDate,Date endDate,String month,int days) throws ParseException {
		List<Equipment> equipmentList = equipmentService.lambdaQuery().eq(Equipment::getSpecificEquipment,"0").eq(Equipment::getDelFlag, CommonConstant.DEL_FLAG_0).lt(Equipment::getAcceptanceCheckDate,endDate).list();
		//关键设备台数
		int countA = equipmentList.size();
		EquipmentAvailabilityVo equipmentAvailabilityVo = new EquipmentAvailabilityVo();
		BigDecimal equipmentFaultTime = new BigDecimal("0");
		BigDecimal equipmentRepairTime = new BigDecimal("0");
		//维修台次
		int count = 0;
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		if(countA == 0){
			equipmentAvailabilityVo.setMonth(month);
			equipmentAvailabilityVo.setCountA(countA);
			equipmentAvailabilityVo.setFaultNumber("0");
			equipmentAvailabilityVo.setFaultDuration(new BigDecimal("0"));
			equipmentAvailabilityVo.setAvailability("0%");
		}
		//查询一月份故障时间
		for(Equipment equipment : equipmentList){
			//查询设备是否有报修单
			List<EquipmentReportRepair> equipmentReportRepairList = equipmentReportRepairService.lambdaQuery().eq(EquipmentReportRepair::getEquipmentId,equipment.getId())
					.eq(EquipmentReportRepair::getDelFlag,CommonConstant.DEL_FLAG_0).list();
			if(CollectionUtils.isNotEmpty(equipmentReportRepairList)){
				//当前设备的开工时间集合，用于判断是否在同一天维修了同一个设备
				List<String> startTimeList = new ArrayList<>();
				//一、查询故障时间
				for(EquipmentReportRepair equipmentReportRepair : equipmentReportRepairList){
					//1、如果报修时间不为空，并且在查询时间段内
					if(equipmentReportRepair.getFaultTime() != null && equipmentReportRepair.getFaultTime().compareTo(endDate) < 0 &&  equipmentReportRepair.getFaultTime().compareTo(startDate) > 0){
						//2、验收时间在查询时间段内
						if(equipmentReportRepair.getAcceptTime() != null && equipmentReportRepair.getAcceptTime().compareTo(endDate) < 0){
							equipmentFaultTime = equipmentFaultTime.add(new BigDecimal(equipmentReportRepair.getFaultHour()));
							//3、验收时间大于查询结束时间
						}else {
							long diff2 = endDate.getTime() - equipmentReportRepair.getFaultTime().getTime();
							BigDecimal faultTime1 = new BigDecimal(diff2)
									.divide(new BigDecimal(60 * 60 * 1000), 2, BigDecimal.ROUND_HALF_EVEN);
							equipmentFaultTime = equipmentFaultTime.add(faultTime1);
						}
						//4、报修时间在查询开始时间之前
					}else if(equipmentReportRepair.getFaultTime().compareTo(startDate) < 0 ){
						//5、验收时间在查询时间段内
						if(equipmentReportRepair.getAcceptTime() != null && equipmentReportRepair.getAcceptTime().compareTo(endDate) < 0){
							long diff2 = equipmentReportRepair.getAcceptTime().getTime() - startDate.getTime();
							BigDecimal faultTime1 = new BigDecimal(diff2)
									.divide(new BigDecimal(60 * 60 * 1000), 2, BigDecimal.ROUND_HALF_EVEN);
							equipmentFaultTime = equipmentFaultTime.add(faultTime1);
							//6、验收时间为空或验收时间在查询结束时间之后
						}else {
							long diff2 = endDate.getTime() - startDate.getTime();
							BigDecimal faultTime1 = new BigDecimal(diff2)
									.divide(new BigDecimal(60 * 60 * 1000), 2, BigDecimal.ROUND_HALF_EVEN);
							equipmentFaultTime = equipmentFaultTime.add(faultTime1);
						}
					}

					//二、查询修复时间
					//查询报修单是否已领取并开工
					List<RepairOrder> repairOrderList = this.lambdaQuery().eq(RepairOrder::getReportRepairId,equipmentReportRepair.getId())
							.eq(RepairOrder::getDelFlag,CommonConstant.DEL_FLAG_0).list();
					if(CollectionUtils.isNotEmpty(repairOrderList)){
						//1、开工时间在查询时间段内
						if(repairOrderList.get(0).getActualStartTime() != null && repairOrderList.get(0).getActualStartTime().compareTo(endDate) < 0 &&  repairOrderList.get(0).getActualStartTime().compareTo(startDate) > 0 ){
							//2、完工时间在查询时间段内
							if(repairOrderList.get(0).getActualEndTime() != null && repairOrderList.get(0).getActualEndTime().compareTo(endDate) < 0){
								equipmentRepairTime = equipmentRepairTime.add(repairOrderList.get(0).getActualHour());
								int flag = 0;
								if(CollectionUtils.isNotEmpty(startTimeList)){
									for(String faultTime : startTimeList){
										if(faultTime.equals(sdf.format(repairOrderList.get(0).getActualStartTime()))){
											flag = 1;
										}
									}
								}
								if(flag == 0){
									count++;
									startTimeList.add(sdf.format(repairOrderList.get(0).getActualStartTime()));
								}
								//3、完工时间大于查询结束时间
							}else {
								long diff1 = endDate.getTime() - repairOrderList.get(0).getActualStartTime().getTime();
								BigDecimal repairTime1 = new BigDecimal(diff1)
										.divide(new BigDecimal(60 * 60 * 1000), 2, BigDecimal.ROUND_HALF_EVEN);
								equipmentRepairTime = equipmentRepairTime.add(repairTime1);
								int flag = 0;
								if(CollectionUtils.isNotEmpty(startTimeList)){
									for(String faultTime : startTimeList){
										if(faultTime.equals(sdf.format(repairOrderList.get(0).getActualStartTime()))){
											flag = 1;
										}
									}
								}
								if(flag == 0){
									count++;
									startTimeList.add(sdf.format(repairOrderList.get(0).getActualStartTime()));
								}
							}
							//4、开工时间在查询开始时间之前
						}else if(repairOrderList.get(0).getActualStartTime() != null && repairOrderList.get(0).getActualStartTime().compareTo(startDate) < 0 ){
							//5、完工时间在查询时间段内
							if(repairOrderList.get(0).getActualEndTime() != null && repairOrderList.get(0).getActualEndTime().compareTo(endDate) < 0){
								long diff1 = repairOrderList.get(0).getActualEndTime().getTime() - startDate.getTime();
								BigDecimal repairTime1 = new BigDecimal(diff1)
										.divide(new BigDecimal(60 * 60 * 1000), 2, BigDecimal.ROUND_HALF_EVEN);
								equipmentRepairTime = equipmentRepairTime.add(repairTime1);
								int flag = 0;
								if(CollectionUtils.isNotEmpty(startTimeList)){
									for(String faultTime : startTimeList){
										if(faultTime.equals(sdf.format(repairOrderList.get(0).getActualStartTime()))){
											flag = 1;
										}
									}
								}
								if(flag == 0){
									count++;
									startTimeList.add(sdf.format(repairOrderList.get(0).getActualStartTime()));
								}
								//6、完工时间为空或完工时间在查询结束时间之后
							}else{
								long diff1 = endDate.getTime() - startDate.getTime();
								BigDecimal repairTime1 = new BigDecimal(diff1)
										.divide(new BigDecimal(60 * 60 * 1000), 2, BigDecimal.ROUND_HALF_EVEN);
								equipmentRepairTime = equipmentRepairTime.add(repairTime1);
								int flag = 0;
								if(CollectionUtils.isNotEmpty(startTimeList)){
									for(String faultTime : startTimeList){
										if(faultTime.equals(sdf.format(repairOrderList.get(0).getActualStartTime()))){
											flag = 1;
										}
									}
								}
								if(flag == 0){
									count++;
									startTimeList.add(sdf.format(repairOrderList.get(0).getActualStartTime()));
								}
							}
						}
					}
				}
				BigDecimal availability = new BigDecimal(countA).multiply(new BigDecimal(days)).subtract(new BigDecimal(count)).multiply(new BigDecimal(100)).divide(new BigDecimal(countA).multiply(new BigDecimal(days)),2,BigDecimal.ROUND_HALF_EVEN);
				equipmentAvailabilityVo.setMonth(month);
				equipmentAvailabilityVo.setCountA(countA);
				equipmentAvailabilityVo.setFaultNumber(String.valueOf(count));
				equipmentAvailabilityVo.setFaultDuration(equipmentFaultTime);
				equipmentAvailabilityVo.setAvailability(availability +"%");
			}else {
				equipmentAvailabilityVo.setMonth(month);
				equipmentAvailabilityVo.setCountA(countA);
				equipmentAvailabilityVo.setFaultNumber("0");
				equipmentAvailabilityVo.setFaultDuration(new BigDecimal("0"));
				equipmentAvailabilityVo.setAvailability("100%");
			}
		}
		return equipmentAvailabilityVo;
	}


}