package jnpf.limsController;

import cn.dev33.satoken.annotation.SaCheckLogin;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.tags.Tag;
import jnpf.base.DictionaryDataApi;
import jnpf.base.entity.DictionaryDataEntity;
import jnpf.base.vo.DownloadVO;
import jnpf.constant.FileTypeConstant;
import jnpf.exception.DataException;
import jnpf.file.FileUploadApi;
import jnpf.limsEntity.LimsWendingxingFenxiDataVo;
import jnpf.limsEntity.LimsWendingxingFenxiOptionsVo;
import jnpf.limsEntity.LimsWendingxingFenxiParam;
import jnpf.limsEntity.LimsWendingxingFenxiRowVo;
import jnpf.limsController.export.LimsWendingxingFenxiWorkbookBuilder;
import jnpf.limsService.LimsWendingxingFenxiService;
import jnpf.util.R;
import jnpf.util.ExcelUtil;
import jnpf.util.UploaderUtil;
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.ss.usermodel.Workbook;
import org.dromara.x.file.storage.core.FileInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

import java.text.SimpleDateFormat;
import java.util.Collections;
import java.util.Date;
import java.util.List;
import java.util.UUID;

@Slf4j
@Tag(name = "lims稳定性数据分析", description = "")
@RestController
@SaCheckLogin
@RequestMapping("/lims/biz/wendingxing/fenxi")
public class LimsWendingxingFenxiController {

    @Autowired
    private LimsWendingxingFenxiService fenxiService;

    @Autowired
    private FileUploadApi fileUploadApi;

    @Autowired
    private DictionaryDataApi dictionaryDataApi;

    private final LimsWendingxingFenxiWorkbookBuilder workbookBuilder =
            new LimsWendingxingFenxiWorkbookBuilder();

    @Operation(summary = "稳定性分析筛选选项")
    @PostMapping("/options")
    public R<LimsWendingxingFenxiOptionsVo> options(
            @RequestBody(required = false) LimsWendingxingFenxiParam param) {
        try {
            return R.success(fenxiService.listOptions(
                    param == null ? new LimsWendingxingFenxiParam() : param));
        } catch (DataException e) {
            return R.error(e.getMessage());
        }
    }

    @Operation(summary = "稳定性分析数据")
    @PostMapping("/data")
    public R<LimsWendingxingFenxiDataVo> data(@RequestBody LimsWendingxingFenxiParam param) {
        String error = validateRequired(param);
        if (error != null) {
            return R.error(error);
        }
        try {
            return R.success(fenxiService.listData(param));
        } catch (DataException e) {
            return R.error(e.getMessage());
        }
    }

    @Operation(summary = "导出稳定性数据分析表")
    @PostMapping("/export")
    public R<DownloadVO> export(@RequestBody LimsWendingxingFenxiParam param) {
        String error = validateRequired(param);
        if (error != null) {
            return R.error(error);
        }

        try {
            List<LimsWendingxingFenxiRowVo> rows = fenxiService.listData(param).getRows();
            if (rows.isEmpty()) {
                throw new DataException("当前筛选条件没有可导出的已审核数据");
            }
            String suffix = UUID.randomUUID().toString().replace("-", "").substring(0, 8);
            String fileName = "稳定性数据分析表_"
                    + new SimpleDateFormat("yyyyMMddHHmmss").format(new Date())
                    + "_" + suffix + ".xls";
            FileInfo fileInfo;
            try (Workbook workbook = workbookBuilder.build(rows, listPeriodUnits())) {
                MultipartFile multipartFile =
                        ExcelUtil.workbookToCommonsMultipartFile(workbook, fileName);
                fileInfo = fileUploadApi.uploadFile(
                        multipartFile, FileTypeConstant.TEMPORARY, fileName);
            }
            if (fileInfo == null || !StringUtils.hasText(fileInfo.getFilename())) {
                throw new DataException("稳定性数据分析表上传文件服务失败");
            }
            DownloadVO download = DownloadVO.builder()
                    .name(fileName)
                    .url(UploaderUtil.uploaderFile(
                            fileInfo.getFilename() + "#" + FileTypeConstant.TEMPORARY))
                    .build();
            return R.success(download);
        } catch (DataException e) {
            return R.error(e.getMessage());
        } catch (Exception e) {
            log.error("稳定性数据分析表导出失败", e);
            return R.error("稳定性数据分析表导出失败");
        }
    }

    private List<DictionaryDataEntity> listPeriodUnits() {
        try {
            List<DictionaryDataEntity> units = dictionaryDataApi.getListByCode("zhouqiDanwei");
            return units == null ? Collections.<DictionaryDataEntity>emptyList() : units;
        } catch (Exception e) {
            log.warn("读取周期单位字典 zhouqiDanwei 失败，导出保留原始编码", e);
            return Collections.emptyList();
        }
    }

    private String validateRequired(LimsWendingxingFenxiParam param) {
        if (param == null) {
            return "请求参数不能为空";
        }
        if (!StringUtils.hasText(param.getFenleiBianma())) {
            return "分类不能为空";
        }
        if (!StringUtils.hasText(param.getYangpinId())) {
            return "品名不能为空";
        }
        if (param.getXiangmuIds() == null || param.getXiangmuIds().isEmpty()) {
            return "检验项目不能为空";
        }
        return null;
    }

}