'init'

1821349743@qq.com

2023-02-20 93dd9bc3f16b0f626761ec624f2dc78037568897

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
package com.product.data.controller;
 
import com.product.common.lang.StringUtils;
import com.product.core.config.CoreConst;
import com.product.core.controller.support.AbstractBaseController;
import com.product.core.entity.FieldSetEntity;
import com.product.core.entity.RequestParameterEntity;
import com.product.core.exception.BaseException;
import com.product.data.config.CmnConst;
import com.product.data.config.ErrorCode;
import com.product.data.service.impl.ISyncDataProcessService;
import com.product.module.sys.version.ApiVersion;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
 
import javax.servlet.http.HttpServletRequest;
 
/**
 * @Author cheng
 * @Date 2022/3/1 14:55
 * @Desc 数据处理控制层
 */
@RestController
@RequestMapping("api/sync-data-process/")
public class SyncDataProcessController extends AbstractBaseController {
 
    @Autowired
    ISyncDataProcessService syncDataProcessService;
 
    /**
     * 查找数据同步处理配置
     *
     * @param request
     * @return
     */
    @PostMapping("find-config/{version}")
    @ApiVersion(1)
    public String findDataPorcessConfig(HttpServletRequest request) {
        try {
            //获取参数
            FieldSetEntity fse = null;
            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
            if (bean != null) {
                RequestParameterEntity reqp = (RequestParameterEntity) bean;
                fse = reqp.getFormData();
            }
            //判断参数是否为空
            if (bean == null || fse == null) {
                return this.error(ErrorCode.SYSTEM_FORM_NODATA);
            }
            //判断表名是否正常
            if (!CmnConst.TABLE_PROCESS_CONFIG.equals(fse.getTableName())) {
                return this.error(ErrorCode.SYSTEM_TABLE_NODATA);
            }
            return OK_List(syncDataProcessService.findDataProcessInfo(fse));
        } catch (BaseException e) {
            e.printStackTrace();
            return error(e);
        } catch (Exception e) {
            return error(ErrorCode.FIND_SYNC_PROCESS_DATA_CONFIG_FAIL);
        }
    }
 
    /**
     * 保存数据同步处理配置
     *
     * @param request
     * @return
     */
    @PostMapping("save-config/{version}")
    @ApiVersion(1)
    public String saveDataPorcessConfig(HttpServletRequest request) {
        try {
            //获取参数
            FieldSetEntity fse = null;
            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
            if (bean != null) {
                RequestParameterEntity reqp = (RequestParameterEntity) bean;
                fse = reqp.getFormData();
            }
            //判断参数是否为空
            if (bean == null || fse == null) {
                return this.error(ErrorCode.SYSTEM_FORM_NODATA);
            }
            //判断表名是否正常
            if (!CmnConst.TABLE_PROCESS_CONFIG.equals(fse.getTableName())) {
                return this.error(ErrorCode.SYSTEM_TABLE_NODATA);
            }
            ISyncDataProcessService syncDataProcessService = (ISyncDataProcessService) getProxyInstance(this.syncDataProcessService);
            syncDataProcessService.saveDataProcessInfo(fse);
            return OK();
        } catch (BaseException e) {
            e.printStackTrace();
            return error(e);
        } catch (Exception e) {
            return error(ErrorCode.SAVE_SYNC_PROCESS_DATA_CONFIG_FAIL);
        }
    }
 
    /**
     * 查找数据同步处理配置
     *
     * @param request
     * @return
     */
    @PostMapping("run-sql/{version}")
    @ApiVersion(1)
    public String efficacySql(HttpServletRequest request) {
        try {
            //获取参数
            FieldSetEntity fse = null;
            Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
            if (bean != null) {
                RequestParameterEntity reqp = (RequestParameterEntity) bean;
                fse = reqp.getFormData();
            }
            //判断参数是否为空
            if (bean == null || fse == null) {
                return this.error(ErrorCode.SYSTEM_FORM_NODATA);
            }
            //判断表名是否正常
            if (StringUtils.isEmpty(fse.getString("run_sql"))) {
                return this.error(ErrorCode.SYSTEM_FORM_COUNT);
            }
            return syncDataProcessService.efficacySql(fse.getString("run_sql"));
        } catch (BaseException e) {
            e.printStackTrace();
            return error(e);
        } catch (Exception e) {
            return error(ErrorCode.FIND_SYNC_PROCESS_DATA_CONFIG_FAIL);
        }
    }
 
 
}