package com.yc.app.v2.controller;

import com.yc.action.BaseAction;
import com.yc.action.grid.RecentAccessEntity;
import com.yc.app.util.ResponseMessage;
import com.yc.app.v2.entity.FormVOEntity;
import com.yc.app.v2.entity.HistoryDataEntity;
import com.yc.app.v2.entity.RefreshDataEntity;
import com.yc.app.v2.service.*;
import com.yc.exception.ApplicationException;
import com.yc.exception.CallBackMessage;
import com.yc.factory.FactoryBean;
import com.yc.multiData.SpObserver;
import com.yc.service.BaseService;
import com.yc.service.sqlformat.entity.SqlFormatEntity;
import com.yc.utils.SessionKey;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.dao.EmptyResultDataAccessException;
import org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.context.request.async.WebAsyncTask;

import javax.servlet.http.HttpServletRequest;
import java.util.List;
import java.util.Map;
import java.util.concurrent.Callable;
import java.util.concurrent.TimeUnit;

@RestController
@Api(value = "获取功能号数据", tags = "APPV2模块")
@RequestMapping(value = "/app/v2")
public class APPController extends BaseAction {
    @Autowired
    T_497_Service t_497_service;
    @Autowired
    T_496_Service t_496_service;
    @Autowired
    T_16_Service t_16_service;
    @Autowired
    T_1_Service t_1_service;
    @Autowired
    T_17_Service t_17_service;
    @Autowired
    T_5_Service t_5_service;
    @Autowired
    T_9_Service t_9_service;
    @Autowired
    T_8_Service t_8_service;
    @Autowired
    T_15_Service t_15_service;
private     Form form;
    @Autowired
    ThreadPoolTaskExecutor threadPoolExecutor;
    @ApiOperation(value = "获取功能号数据", notes =
            "<b>通用获取数据接口</b>\n" +
             " 返回数据中info对应属性说明如下\n" +
                " 1，queryFieldList表示列表界面可查询字段 \n" +
                " 2，9771表示多表设置 \n" +
                " 3，9816表示自定义时间过滤设置 \n" +
                " 4，9842表示功能链接设置 \n" +
                " 5,select2表示当前功能号所有的下拉数据，0表示主表下拉数据，1表示从表下拉数据" +
             " <b>formVOEntity用法</b> \n" +
                    " version的值为空或不传或小于功能号9801的版本号，返回设置信息(9801,9802....),\n" +
                    "--------497调用形式-----------\n" +
                    "{\n" +
                    "    \"formId\":111630,\n" +
                    "    \"formType\":497,\n" +
                    "    \"version\":0,//当前功能号9801版本号，本地没有的情况下则传0\n" +
                    "    \"docCode\":\"710315\",\n" +
                    "   //列表第一次加载不需要附加formFilter，只有在界面加载显示后，通过界面选择过滤条件才需要传\n" +
                    "    \"formFilter\":{\n" +
                    "            \"field\":\"docdate\",\n" +
                    "            \"searchTxt\":\"151710\",\n" +
                    "            \"beginDay\":\"2020-1-1\",\n" +
                    "            \"endDay\":\"2020-7-1\",\n" +
                    "            \"queryFields\":\"formid\",\n" +
                    "            \"isLike\":1\n" +
                    "    }\n" +
                    "}\n" +
                    "--------496调用形式-----------\n" +
                    " 1，打开已有单据\n" +
                    "{\n" +
                    "    \"formId\":111630,\n" +
                    "    \"formType\":496,\n" +
                    "    \"version\":0,//当前功能号9801版本号，本地没有的情况下则传0\n" +
                    "    \"docCode\":\"710164\",\n" +
                    "    \"where\":\"doccode='710164'\"\n" +
                    "\n" +
                    "}\n" +
                    " 2，打开新单\n" +
                    "{\n" +
                    "    \"formId\":111630,\n" +
                    "    \"version\":0,//当前功能号9801版本号，本地没有的情况下则传0\n" +
                    "    \"formType\":496\n" +
                    "\n" +
                    "}\n"

    )
    public void execRecentAccessFormid(RecentAccessEntity entity){
        threadPoolExecutor.execute(new Runnable() {
            @Override
            public void run() {
                try {
                    SpObserver.setDBtoInstance("_" + entity.getDbid());
                    BaseService baseService = (BaseService) FactoryBean.getBean("BaseService");
                    baseService.getSimpleJdbcTemplate().update("set nocount  on \n" +
                                    " exec pUpdateRecentAccessFormId @usercode = ?,@username =?,@formid = ?,@formtype = ?,@query_string = ?,@formname = ?,@docCode = ?",
                            entity.getUserCode(),
                            entity.getUserName(),
                            entity.getFormid(),
                            entity.getFormtype(),
                            entity.getQuery_string(),
                            entity.getFormname(),
                            entity.getDocCode()
                    );
                } catch (Exception ex) {
                    ex.printStackTrace();
                } finally {
                    SpObserver.setDBtoInstance();
                }
            }
        });
    }
    @RequestMapping(value = "/formData.do", method = RequestMethod.POST)
    @CrossOrigin
    public WebAsyncTask formInfo(@RequestBody FormVOEntity formVOEntity,
                                 HttpServletRequest request) {
        //设置调用哪一个类型的功能号
        form=getFormService(formVOEntity);
        if(form==null){
            throw new ApplicationException(formVOEntity.getFormType()+"-无效的窗体类型");
        }
        //获取功能号权限集合
        formVOEntity.setPersion((Map) request.getSession().getAttribute(SessionKey.PERSSION));
        Object supper=request.getSession().getAttribute(SessionKey.SUPPER_USER);
        formVOEntity.setAdmin( Integer.parseInt(supper==null?"0":supper+"")==1?true:false);
        Map<String, String> env= this.initEnv(request,formVOEntity.getFormId(),formVOEntity.getDocCode(),false);
        env.put("doccode",formVOEntity.getDocCode());
        env.put("&doccode&",formVOEntity.getDocCode());
        Callable<Object> callable = new FormInfoCallable(formVOEntity, request.getSession().getAttribute(SessionKey.DATA_BASE_ID) + "", form,env);
        //定义超时45秒
        WebAsyncTask asyncTask = new WebAsyncTask(TimeUnit.SECONDS.toMillis(45), threadPoolExecutor, callable);

        asyncTask.onError(
                (Callable<Object>) () -> {
                    ResponseMessage callBackMessage = new ResponseMessage();
                    callBackMessage.sendErrorMessage("执行出错,请重新提交");
                    return callBackMessage;
                }
        );
        asyncTask.onTimeout(
                (Callable<Object>) () -> {
                    ResponseMessage callBackMessage = new ResponseMessage();
                    callBackMessage.sendErrorMessage("服务器繁忙，请不要重复提交",-1003);
                    return callBackMessage;
                }
        );
        return asyncTask;



    }
    /**
     * 更新APP默认页面设置
     */
    @RequestMapping(value = "/updatePageIndex.do", method = RequestMethod.GET)
    @CrossOrigin
    public Object updateSwitchToPage(String pageIndex,
                                       HttpServletRequest request) {
        if(StringUtils.isBlank(pageIndex)){
            throw new ApplicationException("参数不能为空");
        }

        CallBackMessage callBackMessage=new CallBackMessage();
        try {
            SpObserver.setDBtoInstance("_" + request.getSession().getAttribute(SessionKey.DATA_BASE_ID));
            String userCode= (String) request.getSession().getAttribute(SessionKey.USERCODE);
            BaseService baseService = (BaseService) FactoryBean.getBean("BaseService");
            baseService.getSimpleJdbcTemplate().update("set nocount  on \n" +
                    " declare @SwitchToPageWhenLogonApp varchar(50)=?,@userCode varchar(50)=?" +
                    " update _sysUserConfig set SwitchToPageWhenLogonApp=@SwitchToPageWhenLogonApp where UserCode=@userCode\n" +
                    " if @@rowcount=0 begin \n" +
                    "  insert into _sysUserConfig(SwitchToPageWhenLogonApp,UserCode) values (@SwitchToPageWhenLogonApp,@userCode) \n" +
                    " end \n",pageIndex,userCode);
            callBackMessage.sendSuccessMessage(ResponseMessage.SUCCESS);
            return callBackMessage.toJSONObject();
        } catch (EmptyResultDataAccessException ex){
            callBackMessage.sendSuccessMessage(ResponseMessage.SUCCESS);
            return callBackMessage.toJSONObject();
        }catch (Exception e) {
            e.printStackTrace();
            callBackMessage.sendErrorMessage(e.getCause()!=null?e.getCause().getMessage() :e.getMessage());
            return callBackMessage.toJSONObject();
        } finally {
            SpObserver.setDBtoInstance();
        }
    }
    /**
     * 获取审核单据的下一单
     * excludeSelectNextDocument  : 排除的单号
     *
     */
    @RequestMapping(value = "/nextDoc.do", method = RequestMethod.GET)
    @CrossOrigin
    public Object nextDoc(String excludeSelectNextDocument,
                                          HttpServletRequest request) {
        CallBackMessage callBackMessage=new CallBackMessage();
        try {
            SpObserver.setDBtoInstance("_" + request.getSession().getAttribute(SessionKey.DATA_BASE_ID));
            String userCode= (String) request.getSession().getAttribute(SessionKey.USERCODE);
            BaseService baseService = (BaseService) FactoryBean.getBean("BaseService");
           String result= baseService.getSimpleJdbcTemplate().queryForObject("set nocount  on \n" +
                    " declare @ExcludeDocCodeWhenSelectNextDocument varchar(2000)=?,@userCode varchar(50)=?,@Memo varchar(2000),@LinkDocInfo varchar(2000)\n" +
                    " exec p111630v15 @UserCode=@userCode,\n" +
                    " @ExcludeDocCodeWhenSelectNextDocument = @ExcludeDocCodeWhenSelectNextDocument,\n" +
                    " @Memo =@Memo output,\n" +
                    " @LinkDocInfo=@LinkDocInfo output \n" +
                    " select @LinkDocInfo",String.class,excludeSelectNextDocument,userCode);
           callBackMessage.setData(result);
            callBackMessage.sendSuccessMessage(ResponseMessage.SUCCESS);
            return callBackMessage.toJSONObject();
        } catch (EmptyResultDataAccessException ex){
            callBackMessage.sendSuccessMessage(ResponseMessage.SUCCESS);
            return callBackMessage.toJSONObject();
        }catch (Exception e) {
            e.printStackTrace();
            callBackMessage.sendErrorMessage(e.getCause()!=null?e.getCause().getMessage() :e.getMessage());
            return callBackMessage.toJSONObject();
        } finally {
            SpObserver.setDBtoInstance();
        }
    }
    /**
     * 更新单据审核跳转参数设置
     * SelectNextDocumentWhenApproved  : 0 表示不启用，1.表示按单据到达时间跳转 ， 2.按功能类型及到达时间跳转
     *
     */
    @RequestMapping(value = "/updateApprovedParameter.do", method = RequestMethod.GET)
    @CrossOrigin
    public Object updateApprovedParameter(Integer index,
                                     HttpServletRequest request) {
        if(index==null){
            throw new ApplicationException("参数不能为空");
        }

        CallBackMessage callBackMessage=new CallBackMessage();
        try {
            SpObserver.setDBtoInstance("_" + request.getSession().getAttribute(SessionKey.DATA_BASE_ID));
            String userCode= (String) request.getSession().getAttribute(SessionKey.USERCODE);
            BaseService baseService = (BaseService) FactoryBean.getBean("BaseService");
            baseService.getSimpleJdbcTemplate().update("set nocount  on \n" +
                    " declare @SelectNextDocumentWhenApproved int=?,@userCode varchar(50)=?" +
                    " update _sysUserConfig set SelectNextDocumentWhenApproved=@SelectNextDocumentWhenApproved where UserCode=@userCode\n" +
                    " if @@rowcount=0 begin \n" +
                    "  insert into _sysUserConfig(SelectNextDocumentWhenApproved,UserCode) values (@SelectNextDocumentWhenApproved,@userCode) \n" +
                    " end \n",index,userCode);
            callBackMessage.sendSuccessMessage(ResponseMessage.SUCCESS);
            return callBackMessage.toJSONObject();
        } catch (EmptyResultDataAccessException ex){
            callBackMessage.sendSuccessMessage(ResponseMessage.SUCCESS);
            return callBackMessage.toJSONObject();
        }catch (Exception e) {
            e.printStackTrace();
            callBackMessage.sendErrorMessage(e.getCause()!=null?e.getCause().getMessage() :e.getMessage());
            return callBackMessage.toJSONObject();
        } finally {
            SpObserver.setDBtoInstance();
        }
    }
    /**
     * 取最近浏览记录
     */
    @RequestMapping(value = "/getHistoryList.do", method = RequestMethod.POST)
    @CrossOrigin
    public WebAsyncTask getHistoryList(@RequestBody HistoryDataEntity entity,
                                    HttpServletRequest request) {
        if(entity==null||entity.getPage()==0){
            throw new ApplicationException("page参数值需要大于0");
        }
        String userCode= (String) request.getSession().getAttribute(SessionKey.USERCODE);
        Callable<Object> callable = new HistoryListCallable(entity, userCode,request.getSession().getAttribute(SessionKey.DATA_BASE_ID) + "");
        //定义超时45秒
        WebAsyncTask asyncTask = new WebAsyncTask(TimeUnit.SECONDS.toMillis(45), threadPoolExecutor, callable);

        asyncTask.onError(
                (Callable<Object>) () -> {
                    ResponseMessage callBackMessage = new ResponseMessage();
                    callBackMessage.sendErrorMessage("执行出错,请重新提交");
                    return callBackMessage;
                }
        );
        asyncTask.onTimeout(
                (Callable<Object>) () -> {
                    ResponseMessage callBackMessage = new ResponseMessage();
                    callBackMessage.sendErrorMessage("服务器繁忙，请不要重复提交",-1003);
                    return callBackMessage;
                }
        );
        return asyncTask;
    }
    /**
     * 保存后拉取最新数据
     */
    @RequestMapping(value = "/refreshData.do", method = RequestMethod.POST)
    @CrossOrigin
    public WebAsyncTask refreshData(@RequestBody RefreshDataEntity entity,
                                    HttpServletRequest request) {
        if(entity==null){
            throw new ApplicationException("参数不能为空");
        }
        if(entity.getFormid()==null){
            throw new ApplicationException("功能号不能为空");
        }
        if(entity.getWhere()==null){
            throw new ApplicationException("where条件不能为空");
        }
        env = this.initEnv(request, entity.getFormid(),null, false);
        entity.setEnv(env);
        Callable<Object> callable = new RefreashDataCallable(entity, request.getSession().getAttribute(SessionKey.DATA_BASE_ID) + "");
        //定义超时45秒
        WebAsyncTask asyncTask = new WebAsyncTask(TimeUnit.SECONDS.toMillis(45), threadPoolExecutor, callable);

        asyncTask.onError(
                (Callable<Object>) () -> {
                    ResponseMessage callBackMessage = new ResponseMessage();
                    callBackMessage.sendErrorMessage("执行出错,请重新提交");
                    return callBackMessage;
                }
        );
        asyncTask.onTimeout(
                (Callable<Object>) () -> {
                    ResponseMessage callBackMessage = new ResponseMessage();
                    callBackMessage.sendErrorMessage("服务器繁忙，请不要重复提交",-1003);
                    return callBackMessage;
                }
        );
        return asyncTask;
    }
    /**
     * 批量处理初始值，一次返回多个
     * @param list 需要处理的动态sql
     * @param request
     * @return  返回以fieldid为key,结果为value的map
     */
    @RequestMapping(value = "/forminitvalues.do", method = RequestMethod.POST)
    @CrossOrigin
    public WebAsyncTask getInitValues(@RequestBody List<SqlFormatEntity> list,
                                   HttpServletRequest request) {
        if(list==null||list.size()==0){
            throw new ApplicationException("参数不能为空");
        }
        Map<String, String> env= this.initEnv(request,0,null,false);
        Callable<Object> callable = new FormInitValuesCallable(list, request.getSession().getAttribute(SessionKey.DATA_BASE_ID) + "",env);
        //定义超时45秒
        WebAsyncTask asyncTask = new WebAsyncTask(TimeUnit.SECONDS.toMillis(45), threadPoolExecutor, callable);

        asyncTask.onError(
                (Callable<Object>) () -> {
                    ResponseMessage callBackMessage = new ResponseMessage();
                    callBackMessage.sendErrorMessage("执行出错,请重新提交");
                    return callBackMessage;
                }
        );
        asyncTask.onTimeout(
                (Callable<Object>) () -> {
                    ResponseMessage callBackMessage = new ResponseMessage();
                    callBackMessage.sendErrorMessage("服务器繁忙，请不要重复提交",-1003);
                    return callBackMessage;
                }
        );
        return asyncTask;
    }
    /**
     * 执行动态sql查询
     * @param sqlFormatEntity 需要处理的动态sql
     * @param request
     * @return  返回结果
     */
    @RequestMapping(value = "/dysql31.do", method = RequestMethod.POST)
    @CrossOrigin
    public WebAsyncTask getInitValues(@RequestBody SqlFormatEntity sqlFormatEntity,
                                      HttpServletRequest request) {
        if(sqlFormatEntity==null){
            throw new ApplicationException("参数不能为空");
        }
        Map<String, String> env= this.initEnv(request,0,null,false);
        Callable<Object> callable = new DySql31Callable(sqlFormatEntity, request.getSession().getAttribute(SessionKey.DATA_BASE_ID) + "",env);
        //定义超时45秒
        WebAsyncTask asyncTask = new WebAsyncTask(TimeUnit.SECONDS.toMillis(45), threadPoolExecutor, callable);

        asyncTask.onError(
                (Callable<Object>) () -> {
                    ResponseMessage callBackMessage = new ResponseMessage();
                    callBackMessage.sendErrorMessage("执行出错,请重新提交");
                    return callBackMessage;
                }
        );
        asyncTask.onTimeout(
                (Callable<Object>) () -> {
                    ResponseMessage callBackMessage = new ResponseMessage();
                    callBackMessage.sendErrorMessage("服务器繁忙，请不要重复提交",-1003);
                    return callBackMessage;
                }
        );
        return asyncTask;
    }
    private  Form getFormService(FormVOEntity formVOEntity){
        switch (formVOEntity.getFormType()){
            case 497:
                return t_497_service;
            case 496:
                return t_496_service;
            case 16:
                return t_16_service;
            case 1:
                return t_1_service;
            case 17:
                return t_17_service;
            case 5:
                return t_5_service;
            case 9:
                return t_9_service;
            case 8:
                return t_8_service;
            case 15:
                return t_15_service;
                default:
                    return null;
        }
    }
}