package com.zbooksoft.gdmis.operate;

import com.ruili.wcp.common.SpringContextUtil;
import com.ruili.wcp.data.entity.config.View;
import com.ruili.wcp.service.config.ViewService;
import com.ruili.wcp.web.model.AjaxResponse;
import com.ruili.wcp.web.model.ErrorInfo;
import com.zbooksoft.gdmis.data.entity.CatAjjxx;
import com.zbooksoft.gdmis.service.CatSmxxService;
import com.zbooksoft.gdmis.service.CatYswjxxService;
import com.zbooksoft.gdmis.service.PackingManageService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

/**
 * @Description:原始文件信息操作方法
 * @Author: zhai
 * @Date: 2024/8/15
 **/
public class TransferOperate {
    private static final Logger logger = LoggerFactory.getLogger(TransferOperate.class);
    CatYswjxxService catYswjxxService = (CatYswjxxService) SpringContextUtil.getBean("catYswjxxServiceImpl");
    CatSmxxService catSmxxService = (CatSmxxService) SpringContextUtil.getBean("catSmxxServiceImpl");
    PackingManageService packingManageService = (PackingManageService) SpringContextUtil.getBean("packingManageServiceImpl");
    ViewService viewService = (ViewService) SpringContextUtil.getBean("viewServiceImpl");
    JdbcTemplate jdbcTemplate = (JdbcTemplate) SpringContextUtil.getBean("jdbcTemplate");

    /**
     * 提交验收
     *
     * @param viewId
     * @param idList
     * @return
     */
    public AjaxResponse submitCheck(Long viewId, ArrayList<Long> idList) {

        View view = viewService.getViewById(viewId);
        int state = 2;
        try {
            String strSql = "update " + view.getMainTableName() + " set yszt = " + state + " where id = " + idList.get(0);
            jdbcTemplate.execute(strSql);
            String selectCountSql = "select count(*) from CAT_ITEM_YSWJXX where YJ_ID = " + idList.get(0) + " and (WJLJ = '' or  WJLJ is null)";
            int count = jdbcTemplate.queryForObject(selectCountSql, Integer.class);
            if (count > 0) {
                return new AjaxResponse(new ErrorInfo("存在未关联文件，请先关联附件！"), false);
            }
            String updateSql = "update CAT_ITEM_YSWJXX set yszt = " + state + " where  YJ_ID =" + idList.get(0);
            jdbcTemplate.execute(updateSql);
            return new AjaxResponse(true);
        } catch (Exception e) {
            logger.error(e.getMessage(), e);
            return new AjaxResponse(new ErrorInfo(e.getMessage()), false);
        }
    }

    /**
     * 验收后中数据进行撤回
     *
     * @param viewId
     * @param idList
     * @return
     */
    public AjaxResponse revocationCheck(Long viewId, ArrayList<Long> idList) {

        View view = viewService.getViewById(viewId);
        int state = 0;
        try {
            String strSql = "update " + view.getMainTableName() + " set yszt = " + state + " where id = " + idList.get(0);
            jdbcTemplate.execute(strSql);
            String updateSql = "update CAT_ITEM_YSWJXX set yszt = " + state + " where  YJ_ID =" + idList.get(0);
            jdbcTemplate.execute(updateSql);
            return new AjaxResponse(true);
        } catch (Exception e) {
            logger.error(e.getMessage(), e);
            return new AjaxResponse(new ErrorInfo(e.getMessage()), false);
        }
    }

    /**
     * 接收到实体资料后确认验收合格
     *
     * @param viewId
     * @param idList
     * @return
     */
    public AjaxResponse qualified(Long viewId, ArrayList<Long> idList) {
        try {
            String updateSqlY = "update CAT_ITEM_YSWJXX set YSZT = '3' where YJ_ID = " + idList.get(0);
            jdbcTemplate.execute(updateSqlY);
            return new AjaxResponse(true);
        } catch (Exception e) {
            throw new RuntimeException(e);
        }
    }
}