package com.yc.app.v2.controller;
|
|
import com.yc.action.BaseAction;
|
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"
|
|
)
|
@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();
|
}
|
}
|
/**
|
* 取最近浏览记录
|
*/
|
@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条件不能为空");
|
}
|
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;
|
}
|
}
|
}
|