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

import java.time.Duration;
import java.util.List;
import java.util.stream.Collectors;

import org.apache.commons.beanutils.BeanUtils;
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.qianwen.core.excel.util.ExcelUtil;
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.excel.WorkstationExcel;
import com.qianwen.smartman.modules.smis.mapper.WorkstationMapper;
import com.qianwen.smartman.modules.workinghour.convert.PartWorkingProcessConvert;
import com.qianwen.smartman.modules.workinghour.entity.PartWorkingHour;
import com.qianwen.smartman.modules.workinghour.entity.PartWorkingProcess;
import com.qianwen.smartman.modules.workinghour.excel.PartWorkingProcessExcel;
import com.qianwen.smartman.modules.workinghour.mapper.PartWorkingHourMapper;
import com.qianwen.smartman.modules.workinghour.mapper.PartWorkingProcessMapper;
import com.qianwen.smartman.modules.workinghour.vo.PartWorkingProcessVO;

@Service
public class PartWorkingProcessService{

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


    @Transactional(readOnly=true)
	public List<PartWorkingProcessVO> listByWorkinghourId(Long workinghourId) {
    	QueryWrapper<PartWorkingProcess> wrapper = new QueryWrapper<>();
    	wrapper.lambda().eq(PartWorkingProcess::getWorkinghourId, workinghourId).orderByAsc(PartWorkingProcess::getStartTime);
    	
    	return PartWorkingProcessConvert.INSTANCE.convert(partWorkingProcessMapper.selectList(wrapper));
	}

    /**
     * 加工过程数据导出
     * @param id
     * @return
     */
    @Transactional(readOnly=true)
	public BladeFile export(long workinghourId) {
    	QueryWrapper<PartWorkingProcess> wrapper = new QueryWrapper<>();
    	wrapper.lambda().eq(PartWorkingProcess::getWorkinghourId, workinghourId).orderByAsc(PartWorkingProcess::getStartTime);
    	List<PartWorkingProcess> data = partWorkingProcessMapper.selectList(wrapper);
    	List<PartWorkingProcessExcel> exportList = data.stream().map(p -> {
    		PartWorkingProcessExcel e = new PartWorkingProcessExcel();
    		e.setProgName(p.getProgName());
    		e.setStartTime(p.getStartTime().toString());
    		e.setEndTime(p.getEndTime().toString());
    		
    		Duration duration = Duration.between(p.getStartTime(), p.getEndTime());
    		e.setDuration(DurationUtil.toChineseDuration(duration));
    		e.setDeviceStateName(DefaultWcsEnum.of(p.getDeviceStatus()).getName());
    		return e;
    	}).collect(Collectors.toList());
    	//xx工件在x机床
    	PartWorkingHour partWorkingHour = partWorkingHourMapper.selectById(workinghourId);
    	Workstation ws = workstationMapper.selectById(partWorkingHour.getWorkstationId());
    	String fileName = String.format("%s的加工记录-%s.xlsx", ws.getName(), DateUtil.time());
        MultipartFile multipartFile = ExcelUtil.exportToMultipartFile(fileName, "加工记录表", exportList, PartWorkingProcessExcel.class);
        BladeFile bladeFile = this.ossBuilder.tempTemplate().putFile(multipartFile.getOriginalFilename(), multipartFile);
        return bladeFile;
	}
    
    

}