| | |
| | | public R save(@Valid @RequestBody Coinspect coinspect) throws Exception { |
| | | coinspectService.save(coinspect); |
| | | String url = ""; |
| | | String[] split = coinspect.getUrl().split(","); |
| | | for (int i = 0; i < split.length; i++) { |
| | | String s = split[i].substring(26, split[i].length()); |
| | | url += FtpConstant.ip + s + ","; |
| | | if (coinspect.getUrl()!=null && !"".equals(coinspect.getUrl())){ |
| | | String[] split = coinspect.getUrl().split(","); |
| | | for (int i = 0; i < split.length; i++) { |
| | | String s = split[i].substring(26, split[i].length()); |
| | | url += FtpConstant.ip + s + ","; |
| | | } |
| | | String substring = url.substring(0, url.length() - 1); |
| | | coinspect.setUrl(substring); |
| | | } |
| | | String substring = url.substring(0, url.length() - 1); |
| | | coinspect.setUrl(substring); |
| | | //数据同步 |
| | | String s1 = |
| | | "insert into sys_coinspect(id,name,sName,deptName,reviewTime,insid,results,url) " + |
| | | "insert into sys_coinspect(id,name,sName,deptName,reviewTime,insid,results,url,handler_result) " + |
| | | "values(" + "'" + coinspect.getId() + "'" + "," + |
| | | "'" + coinspect.getName() + "'" + "," + |
| | | "'" + coinspect.getSname() + "'" + "," + |
| | |
| | | "'" + new SimpleDateFormat("yyyy-MM-dd").format(coinspect.getReviewtime()) + "'" + "," + |
| | | "'" + coinspect.getInsid() + "'" + "," + |
| | | "'" + coinspect.getResults() + "'" + "," + |
| | | "'" + coinspect.getUrl() + "'" + ")"; |
| | | "'" + coinspect.getUrl() + "'" + "," + |
| | | "'" + coinspect.getHandlerResult() + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(s1); |
| | | return R.success("新增成功"); |
| | | } |