package com.ruoyi.envaccess.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.exception.base.BaseException;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.envaccess.mapper.EnvInspectionMapper;
import com.ruoyi.envaccess.pojo.EnvInspection;
import com.ruoyi.envaccess.service.IEnvInspectionService;
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.servlet.http.HttpServletResponse;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.List;

@Service
@AllArgsConstructor
@Transactional(rollbackFor = Exception.class)
public class EnvInspectionServiceImpl extends ServiceImpl<EnvInspectionMapper, EnvInspection> implements IEnvInspectionService {

    private EnvInspectionMapper envInspectionMapper;

    @Override
    public IPage<EnvInspection> listPage(Page page, EnvInspection req) {
        return envInspectionMapper.listPage(page, req);
    }

    @Override
    public void export(HttpServletResponse response, EnvInspection req) {
        List<EnvInspection> list = envInspectionMapper.list(req);
        ExcelUtil<EnvInspection> util = new ExcelUtil<EnvInspection>(EnvInspection.class);
        util.exportExcel(response, list, "智能巡检台账");
    }

    /**
     * 根据巡检记录自动生成巡检报告（HTML），并写回 report_path
     */
    @Override
    public String generateReport(Long id) {
        EnvInspection it = getById(id);
        if (it == null) {
            throw new BaseException("巡检记录不存在");
        }
        String typeText = it.getInspectionType() == null ? "" :
                (it.getInspectionType() == 1 ? "定期巡检" : it.getInspectionType() == 2 ? "临时巡检" :
                        it.getInspectionType() == 3 ? "故障巡检" : "");
        String statusText = it.getStatus() == null ? "" :
                (it.getStatus() == 0 ? "待执行" : it.getStatus() == 1 ? "执行中" :
                        it.getStatus() == 2 ? "已完成" : it.getStatus() == 3 ? "已取消" : "");
        String now = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));

        StringBuilder sb = new StringBuilder();
        sb.append("<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:w='urn:schemas-microsoft-com:office:word'>")
          .append("<head><meta charset='utf-8'><title>智能巡检报告</title></head><body>");
        sb.append("<h2 style='text-align:center;'>智能巡检报告</h2>");
        sb.append("<p style='text-align:right;'>报告生成时间：").append(now).append("</p>");
        sb.append("<table border='1' cellspacing='0' cellpadding='6' style='border-collapse:collapse;width:100%;font-size:14px;'>");
        row(sb, "巡检名称", it.getInspectionName());
        row(sb, "巡检类型", typeText);
        row(sb, "巡检区域", it.getArea());
        row(sb, "巡检路径规划", it.getRoutePlan());
        row(sb, "计划时间", fmt(it.getPlanStartTime()) + " ~ " + fmt(it.getPlanEndTime()));
        row(sb, "实际时间", fmt(it.getActualStartTime()) + " ~ " + fmt(it.getActualEndTime()));
        row(sb, "巡检人员", it.getInspector());
        row(sb, "巡检状态", statusText);
        row(sb, "巡检结果/记录", it.getInspectionResult());
        row(sb, "AI视频分析结果", it.getAiAnalysis());
        row(sb, "无人机/机器人数据", it.getUavData());
        row(sb, "备注", it.getRemark());
        sb.append("</table>");
        sb.append("<p style='margin-top:30px;'>巡检人签字：________________&nbsp;&nbsp;&nbsp;&nbsp;审批人签字：________________</p>");
        sb.append("</body></html>");

        String content = sb.toString();
        EnvInspection upd = new EnvInspection();
        upd.setId(id);
        upd.setReportPath(content);
        updateById(upd);
        return content;
    }

    private static String fmt(java.util.Date d) {
        if (d == null) {
            return "";
        }
        return new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(d);
    }

    private static void row(StringBuilder sb, String label, Object value) {
        sb.append("<tr><td style='background:#f0f1f5;width:180px;'>").append(label)
          .append("</td><td>").append(value == null ? "" : String.valueOf(value).replace("\n", "<br/>"))
          .append("</td></tr>");
    }
}