package com.qianwen.smartman.modules.workinghour.service;

import java.time.Duration;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.Arrays;
import java.util.List;
import java.util.stream.Collectors;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.qianwen.core.excel.util.ExcelUtil;
import com.qianwen.core.mp.base.BaseServiceImpl;
import com.qianwen.core.oss.model.BladeFile;
import com.qianwen.core.tool.utils.DateUtil;
import com.qianwen.smartman.common.enums.DefaultWcsEnum;
import com.qianwen.smartman.common.utils.DurationUtil;
import com.qianwen.smartman.modules.resource.builder.oss.OssBuilder;
import com.qianwen.smartman.modules.smis.entity.Workstation;
import com.qianwen.smartman.modules.smis.mapper.WorkstationMapper;
import com.qianwen.smartman.modules.workinghour.entity.PartWorkingHour;
import com.qianwen.smartman.modules.workinghour.entity.PartWorkingProcess;
import com.qianwen.smartman.modules.workinghour.excel.PartWorkingHourExcel;
import com.qianwen.smartman.modules.workinghour.excel.PartWorkingProcessExcel;
import com.qianwen.smartman.modules.workinghour.mapper.PartWorkingHourMapper;
import com.qianwen.smartman.modules.workinghour.vo.PartWorkingHourVO;

import cn.hutool.core.date.LocalDateTimeUtil;

@Service
public class PartWorkingHourService extends BaseServiceImpl<PartWorkingHourMapper, PartWorkingHour>{

    @Autowired
    private PartWorkingHourMapper partWorkingHourMapper;
    @Autowired
    private WorkstationMapper workstationMapper;
    @Autowired
    private OssBuilder ossBuilder;

    @Transactional(readOnly=true)
    public IPage<PartWorkingHourVO> listPage(IPage<PartWorkingHourVO> workstationVOIPage, String partNo, String workstationName, LocalDate startDate, LocalDate endDate) {
        
        List<PartWorkingHourVO> workstationVOS = this.partWorkingHourMapper.listPage(workstationVOIPage, partNo, workstationName, startDate, endDate);
        
        return workstationVOIPage.setRecords(workstationVOS);
    }


    @Transactional(readOnly=true)
	public List<PartWorkingHourVO> listVOByIds(List<Long> ids) {
    	return partWorkingHourMapper.listVOByIds(ids);
	}

    /**
     * 导出一条数据
     * @param id
     * @return
     */
    @Transactional(readOnly=true)
   	public BladeFile export(long id) {
    	//QueryWrapper<PartWorkingProcess> wrapper = new QueryWrapper<>();
    	//wrapper.lambda().eq(PartWorkingProcess::getWorkinghourId, id);
    	
    	//xx工件在x机床
    	PartWorkingHour partWorkingHour = partWorkingHourMapper.selectById(id);
    	Workstation ws = workstationMapper.selectById(partWorkingHour.getWorkstationId());
    	String fileName = String.format("零件%s的工时数据-%s.xlsx", partWorkingHour.getPartNo(), DateUtil.time());
    	
    	PartWorkingHourExcel excelObj = new PartWorkingHourExcel();
    	excelObj.setPartNo(partWorkingHour.getPartNo());
    	excelObj.setAmount(partWorkingHour.getAmount());
    	
    	LocalDateTime start = LocalDateTime.now();
    	LocalDateTime end;
    	Duration duration;
    	if(partWorkingHour.getClampingSecs() !=null) {
	    	end = start.plusSeconds(partWorkingHour.getClampingSecs());
	    	duration = Duration.between(start, end);
	    	excelObj.setClampingSecs(DurationUtil.toChineseDuration(duration));
    	}
    	final String format =  "yyyy-MM-dd:hh:mm:ss";
    	if(partWorkingHour.getEndTime() !=null) {
    		excelObj.setEndTime(LocalDateTimeUtil.format(partWorkingHour.getEndTime(),format));
    	}
    	
    	if(partWorkingHour.getFirstMeasureSecs() !=null) {
	    	end = start.plusSeconds(partWorkingHour.getFirstMeasureSecs());
	    	duration = Duration.between(start, end);
	    	excelObj.setFirstMeasureSecs(DurationUtil.toChineseDuration(duration));
    	}
    	
    	if(partWorkingHour.getFirstWorkingSecs() !=null) {
	    	end = start.plusSeconds(partWorkingHour.getFirstWorkingSecs());
	    	duration = Duration.between(start, end);
	    	excelObj.setFirstWorkingSecs(DurationUtil.toChineseDuration(duration));
    	}
    	
    	if(partWorkingHour.getLastRemoveSecs() !=null) {
	    	end = start.plusSeconds(partWorkingHour.getLastRemoveSecs());
	    	duration = Duration.between(start, end);
	    	excelObj.setLastRemoveSecs(DurationUtil.toChineseDuration(duration));
    	}
    	
    	if(partWorkingHour.getOccupancySecs() !=null) {
	    	end = start.plusSeconds(partWorkingHour.getOccupancySecs());
	    	duration = Duration.between(start, end);
	    	excelObj.setOccupancySecs(DurationUtil.toChineseDuration(duration));
    	}
    	
    	excelObj.setPartNo(partWorkingHour.getPartNo());
    	
    	if(partWorkingHour.getPrepareSecs() !=null) {
	    	end = start.plusSeconds(partWorkingHour.getPrepareSecs());
	    	duration = Duration.between(start, end);
	    	excelObj.setPrepareSecs(DurationUtil.toChineseDuration(duration));
    	}
    	
    	if(partWorkingHour.getProcessingSecs() !=null) {
	    	end = start.plusSeconds(partWorkingHour.getProcessingSecs());
	    	duration = Duration.between(start, end);
	    	excelObj.setProcessingSecs(DurationUtil.toChineseDuration(duration));
    	}
    	
    	excelObj.setProcessNo(partWorkingHour.getProcessNo());
    	
    	if(partWorkingHour.getSingleProcessSecs() !=null) {
	    	end = start.plusSeconds(partWorkingHour.getSingleProcessSecs());
	    	duration = Duration.between(start, end);
	    	excelObj.setSingleProcessSecs(DurationUtil.toChineseDuration(duration));
    	}
    	
    	excelObj.setStartTime(LocalDateTimeUtil.format(partWorkingHour.getStartTime(),format));
    	
    	
    	excelObj.setWorkstationName(ws.getName());
    	
    	excelObj.setVersion(partWorkingHour.getVersion());
    	
        MultipartFile multipartFile = ExcelUtil.exportToMultipartFile(fileName, "零件工时", Arrays.asList(excelObj), PartWorkingHourExcel.class);
        BladeFile bladeFile = this.ossBuilder.tempTemplate().putFile(multipartFile.getOriginalFilename(), multipartFile);
        return bladeFile;
    }
}