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

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.apache.commons.lang.StringUtils;
import org.apache.shiro.SecurityUtils;
import org.jeecg.common.system.vo.LoginUser;
import org.jeecg.modules.mdc.entity.MdcPartProcessInfo;
import org.jeecg.modules.mdc.mapper.MdcPartProcessInfoMapper;
import org.jeecg.modules.mdc.service.IMdcEquipmentService;
import org.jeecg.modules.mdc.service.IMdcPartProcessInfoService;
import org.jeecg.modules.mdc.vo.MdcPartProcessInfoVo;
import org.jeecgframework.poi.excel.def.NormalExcelConstants;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.web.servlet.ModelAndView;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;

/**
 * @Description: 零件加工数据表
 * @Author: lius
 * @Date: 2024-12-11
 */
@Service
public class MdcPartProcessInfoServiceImpl extends ServiceImpl<MdcPartProcessInfoMapper, MdcPartProcessInfo> implements IMdcPartProcessInfoService {

    @Resource
    private IMdcEquipmentService mdcEquipmentService;

    /**
     * 分页查询
     *
     * @param userId
     * @param page
     * @param mdcPartProcessInfo
     * @param req
     * @return
     */
    @Override
    public IPage<MdcPartProcessInfo> pageList(String userId, Page<MdcPartProcessInfo> page, MdcPartProcessInfoVo mdcPartProcessInfo, HttpServletRequest req) {
        List<String> equipmentIds = new ArrayList<>();
        if (StringUtils.isNotEmpty(mdcPartProcessInfo.getParentId()) && StringUtils.isEmpty(mdcPartProcessInfo.getEquipmentId())) {
            if ("2".equals(mdcPartProcessInfo.getTypeTree())) {
                //部门层级
                equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, mdcPartProcessInfo.getParentId());
            } else {
                //产线层级
                equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, mdcPartProcessInfo.getParentId());
            }
        } else if (StringUtils.isNotEmpty(mdcPartProcessInfo.getEquipmentId())) {
            //单台设备信息
            mdcPartProcessInfo.setEquipmentIdList(Collections.singletonList(mdcPartProcessInfo.getEquipmentId()));
        } else {
            //查询用户拥有的所有设备信息
            if ("2".equals(mdcPartProcessInfo.getTypeTree())) {
                //部门层级
                equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, null);
            } else {
                //产线层级
                equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, null);
            }
        }

        if (mdcPartProcessInfo.getEquipmentIdList() == null || mdcPartProcessInfo.getEquipmentIdList().isEmpty()) {
            mdcPartProcessInfo.setEquipmentIdList(equipmentIds);
        }

        if (mdcPartProcessInfo.getEquipmentIdList() == null || mdcPartProcessInfo.getEquipmentIdList().isEmpty()) {
            return null;
        }
        return this.baseMapper.pageList(page, mdcPartProcessInfo);
    }

    @Override
    public boolean addPartProcess(MdcPartProcessInfoVo mdcPartProcessInfo) {
        String[] equipmentIdList = mdcPartProcessInfo.getEquipmentIds().split(",");
        List<MdcPartProcessInfo> partProcessInfoList = new ArrayList<>();
        for (String equipmentId : equipmentIdList) {
            MdcPartProcessInfo mppi = new MdcPartProcessInfo();
            BeanUtils.copyProperties(mdcPartProcessInfo, mppi);
            mppi.setEquipmentId(equipmentId);
            partProcessInfoList.add(mppi);
        }
        this.saveBatch(partProcessInfoList);
        return true;
    }

    @Override
    public ModelAndView exportXls(String userId, MdcPartProcessInfoVo mdcPartProcessInfo) {
        LambdaQueryWrapper<MdcPartProcessInfo> queryWrapper = new LambdaQueryWrapper<>();
        List<String> equipmentIds = new ArrayList<>();
        if (StringUtils.isNotEmpty(mdcPartProcessInfo.getParentId()) && StringUtils.isEmpty(mdcPartProcessInfo.getEquipmentId())) {
            if ("2".equals(mdcPartProcessInfo.getTypeTree())) {
                //部门层级
                equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, mdcPartProcessInfo.getParentId());
            } else {
                //产线层级
                equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, mdcPartProcessInfo.getParentId());
            }
        } else if (StringUtils.isNotEmpty(mdcPartProcessInfo.getEquipmentId())) {
            //单台设备信息
            mdcPartProcessInfo.setEquipmentIdList(Collections.singletonList(mdcPartProcessInfo.getEquipmentId()));
        } else {
            //查询用户拥有的所有设备信息
            if ("2".equals(mdcPartProcessInfo.getTypeTree())) {
                //部门层级
                equipmentIds = mdcEquipmentService.getEquipmentIdsByDepart(userId, null);
            } else {
                //产线层级
                equipmentIds = mdcEquipmentService.getEquipmentIdsProduction(userId, null);
            }
        }

        if (mdcPartProcessInfo.getEquipmentIdList() == null || mdcPartProcessInfo.getEquipmentIdList().isEmpty()) {
            mdcPartProcessInfo.setEquipmentIdList(equipmentIds);
        }

        if (mdcPartProcessInfo.getEquipmentIdList() == null || mdcPartProcessInfo.getEquipmentIdList().isEmpty()) {
            return null;
        } else {
            queryWrapper.in(MdcPartProcessInfo::getEquipmentId, mdcPartProcessInfo.getEquipmentIdList());
        }
        if (StringUtils.isNotEmpty(mdcPartProcessInfo.getEquipmentId())) {
            queryWrapper.eq(MdcPartProcessInfo::getEquipmentId, mdcPartProcessInfo.getEquipmentId());
        }
        if (StringUtils.isNotEmpty(mdcPartProcessInfo.getPartId())) {
            queryWrapper.eq(MdcPartProcessInfo::getPartId, mdcPartProcessInfo.getPartId());
        }
        if (StringUtils.isNotEmpty(mdcPartProcessInfo.getStartTime()) && StringUtils.isNotEmpty(mdcPartProcessInfo.getEndTime())) {
            queryWrapper.between(MdcPartProcessInfo::getTheDate, mdcPartProcessInfo.getStartTime(), mdcPartProcessInfo.getEndTime());
        }
        queryWrapper.orderByDesc(MdcPartProcessInfo::getTheDate).orderByDesc(MdcPartProcessInfo::getEquipmentId);
        ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
        List<MdcPartProcessInfo> mdcPartProcessInfos = this.baseMapper.selectList(queryWrapper);
        // 导出文件名称
        mv.addObject(NormalExcelConstants.FILE_NAME, "零件加工数据列表");
        mv.addObject(NormalExcelConstants.CLASS, MdcPartProcessInfo.class);
        LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
        mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("零件加工数据列表数据", "导出人:" + user.getRealname(), "零件加工数据"));
        //update-end---author:wangshuai ---date:20211227  for：[JTC-116]导出人写死了------------
        mv.addObject(NormalExcelConstants.DATA_LIST, mdcPartProcessInfos);
        return mv;
    }

    /**
     * 查询设备某天总加工时间
     *
     * @param equipmentId
     * @param validDate
     * @return
     */
    @Override
    public Integer selectTotalProcessLong(String equipmentId, String validDate) {
        Integer totalProcessLong = this.baseMapper.selectTotalProcessLong(equipmentId, validDate);
        if (totalProcessLong == null) {
            return 0;
        } else {
            return totalProcessLong;
        }
    }

    /**
     * 查询设备某天总加工数量
     *
     * @param equipmentId
     * @param validDate
     * @return
     */
    @Override
    public Integer selectTotalProcessCount(String equipmentId, String validDate) {
        Integer totalProcessCount = this.baseMapper.selectTotalProcessCount(equipmentId, validDate);
        if (totalProcessCount == null) {
            return 0;
        } else {
            return totalProcessCount;
        }
    }

    /**
     * 查询设备某天总加工合格数量
     *
     * @param equipmentId
     * @param validDate
     * @return
     */
    @Override
    public Integer selectTotalPassCount(String equipmentId, String validDate) {
        Integer totalPassCount = this.baseMapper.selectTotalPassCount(equipmentId, validDate);
        if (totalPassCount == null) {
            return 0;
        } else {
            return totalPassCount;
        }
    }
}