package com.controller;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.*;
import javax.servlet.http.HttpServletRequest;
import com.alibaba.fastjson.JSON;
import com.utils.StringUtil;
import org.apache.commons.lang3.StringUtils;
import org.json.JSONObject;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.util.ResourceUtils;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.annotation.IgnoreAuth;
import com.baidu.aip.face.AipFace;
import com.baidu.aip.face.MatchRequest;
import com.baidu.aip.util.Base64Util;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.entity.ConfigEntity;
import com.service.CommonService;
import com.service.ConfigService;
import com.utils.BaiduUtil;
import com.utils.FileUtil;
import com.utils.R;
/**
* 通用接口
*/
@RestController
public class CommonController{
private static final Logger logger = LoggerFactory.getLogger(CommonController.class);
@Autowired
private CommonService commonService;
@Autowired
private ConfigService configService;
private static AipFace client = null;
private static String BAIDU_DITU_AK = null;
@RequestMapping("/location")
public R location(String lng,String lat) {
if(BAIDU_DITU_AK==null) {
BAIDU_DITU_AK = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "baidu_ditu_ak")).getValue();
if(BAIDU_DITU_AK==null) {
return R.error("请在配置管理中正确配置baidu_ditu_ak");
}
}
Map<String, String> map = BaiduUtil.getCityByLonLat(BAIDU_DITU_AK, lng, lat);
return R.ok().put("data", map);
}
/**
* 人脸比对
*
* @param face1 人脸1
* @param face2 人脸2
* @return
*/
@RequestMapping("/matchFace")
public R matchFace(String face1, String face2, HttpServletRequest request) {
if(client==null) {
/*String AppID = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "AppID")).getValue();*/
String APIKey = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "APIKey")).getValue();
String SecretKey = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "SecretKey")).getValue();
String token = BaiduUtil.getAuth(APIKey, SecretKey);
if(token==null) {
return R.error("请在配置管理中正确配置APIKey和SecretKey");
}
client = new AipFace(null, APIKey, SecretKey);
client.setConnectionTimeoutInMillis(2000);
client.setSocketTimeoutInMillis(60000);
}
JSONObject res = null;
try {
File file1 = new File(request.getSession().getServletContext().getRealPath("/upload")+"/"+face1);
File file2 = new File(request.getSession().getServletContext().getRealPath("/upload")+"/"+face2);
String img1 = Base64Util.encode(FileUtil.FileToByte(file1));
String img2 = Base64Util.encode(FileUtil.FileToByte(file2));
MatchRequest req1 = new MatchRequest(img1, "BASE64");
MatchRequest req2 = new MatchRequest(img2, "BASE64");
ArrayList<MatchRequest> requests = new ArrayList<MatchRequest>();
requests.add(req1);
requests.add(req2);
res = client.match(requests);
System.out.println(res.get("result"));
} catch (FileNotFoundException e) {
e.printStackTrace();
return R.error("文件不存在");
} catch (IOException e) {
e.printStackTrace();
}
return R.ok().put("data", com.alibaba.fastjson.JSONObject.parse(res.get("result").toString()));
}
/**
* 获取table表中的column列表(联动接口)
* @return
*/
@RequestMapping("/option/{tableName}/{columnName}")
@IgnoreAuth
public R getOption(@PathVariable("tableName") String tableName, @PathVariable("columnName") String columnName,String level,String parent) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("table", tableName);
params.put("column", columnName);
if(StringUtils.isNotBlank(level)) {
params.put("level", level);
}
if(StringUtils.isNotBlank(parent)) {
params.put("parent", parent);
}
List<String> data = commonService.getOption(params);
return R.ok().put("data", data);
}
/**
* 根据table中的column获取单条记录
* @return
*/
@RequestMapping("/follow/{tableName}/{columnName}")
@IgnoreAuth
public R getFollowByOption(@PathVariable("tableName") String tableName, @PathVariable("columnName") String columnName, @RequestParam String columnValue) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("table", tableName);
params.put("column", columnName);
params.put("columnValue", columnValue);
Map<String, Object> result = commonService.getFollowByOption(params);
return R.ok().put("data", result);
}
/**
* 修改table表的sfsh状态
* @param map
* @return
*/
@RequestMapping("/sh/{tableName}")
public R sh(@PathVariable("tableName") String tableName, @RequestBody Map<String, Object> map) {
map.put("table", tableName);
commonService.sh(map);
return R.ok();
}
/**
* 获取需要提醒的记录数
* @param tableName
* @param columnName
* @param type 1:数字 2:日期
* @param map
* @return
*/
@RequestMapping("/remind/{tableName}/{columnName}/{type}")
@IgnoreAuth
public R remindCount(@PathVariable("tableName") String tableName, @PathVariable("columnName") String columnName,
@PathVariable("type") String type,@RequestParam Map<String, Object> map) {
map.put("table", tableName);
map.put("column", columnName);
map.put("type", type);
if(type.equals("2")) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Calendar c = Calendar.getInstance();
Date remindStartDate = null;
Date remindEndDate = null;
if(map.get("remindstart")!=null) {
Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
c.setTime(new Date());
c.add(Calendar.DAY_OF_MONTH,remindStart);
remindStartDate = c.getTime();
map.put("remindstart", sdf.format(remindStartDate));
}
if(map.get("remindend")!=null) {
Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
c.setTime(new Date());
c.add(Calendar.DAY_OF_MONTH,remindEnd);
remindEndDate = c.getTime();
map.put("remindend", sdf.format(remindEndDate));
}
}
int count = commonService.remindCount(map);
return R.ok().put("count", count);
}
/**
* 圖表统计
*/
@IgnoreAuth
@RequestMapping("/group/{tableName}")
public R group1(@PathVariable("tableName") String tableName, @RequestParam Map<String,Object> params) {
params.put("table1", tableName);
List<Map<String, Object>> result = commonService.chartBoth(params);
return R.ok().put("data", result);
}
/**
* 单列求和
*/
@RequestMapping("/cal/{tableName}/{columnName}")
@IgnoreAuth
public R cal(@PathVariable("tableName") String tableName, @PathVariable("columnName") String columnName) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("table", tableName);
params.put("column", columnName);
Map<String, Object> result = commonService.selectCal(params);
return R.ok().put("data", result);
}
/**
* 分组统计
*/
@RequestMapping("/group/{tableName}/{columnName}")
@IgnoreAuth
public R group(@PathVariable("tableName") String tableName, @PathVariable("columnName") String columnName) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("table", tableN
科研工作量管理系统的设计与实现.zip （802个子文件） 
3-build.bat 16B 3-build.bat 16B 2-run.bat 14B 2-run.bat 14B 1-install.bat 12B 1-install.bat 12B CommonController.class 19KB JiaoshiController.class 14KB MishuController.class 13KB XiangmuController.class 11KB DictionaryController.class 11KB KeyanlunwenController.class 11KB KeyanhuojiangController.class 10KB GongzuoliangController.class 10KB MPUtil.class 7KB UsersController.class 6KB KeyanlunwenEntity.class 6KB DictionaryServiceImpl.class 6KB XiangmuEntity.class 6KB KeyanhuojiangEntity.class 6KB JiaoshiEntity.class 5KB MishuEntity.class 5KB FileController.class 5KB TokenServiceImpl.class 5KB DictionaryEntity.class 5KB GongzuoliangEntity.class 4KB BaiduUtil.class 4KB KeyanlunwenVO.class 4KB CommonServiceImpl.class 4KB XiangmuVO.class 4KB KeyanhuojiangVO.class 4KB AuthorizationInterceptor.class 4KB ConfigController.class 4KB GongzuoliangView.class 4KB PoiUtil.class 4KB JiaoshiVO.class 4KB DictionaryServletContextListener.class 4KB KeyanlunwenModel.class 3KB XiangmuModel.class 3KB KeyanhuojiangModel.class 3KB MishuVO.class 3KB XiangmuView.class 3KB JiaoshiModel.class 3KB Query.class 3KB KeyanhuojiangView.class 3KB KeyanlunwenView.class 3KB MishuModel.class 3KB DictionaryVO.class 3KB UsersServiceImpl.class 3KB PageUtils.class 3KB TokenEntity.class 3KB GongzuoliangVO.class 3KB DictionaryModel.class 2KB InterceptorConfig.class 2KB GongzuoliangModel.class 2KB KeyanhuojiangServiceImpl.class 2KB GongzuoliangServiceImpl.class 2KB KeyanlunwenServiceImpl.class 2KB XiangmuServiceImpl.class 2KB JiaoshiServiceImpl.class 2KB MishuServiceImpl.class 2KB R.class 2KB UsersEntity.class 2KB SpringContextUtils.class 2KB ValidatorUtils.class 2KB TypeEnum.class 2KB ConfigServiceImpl.class 2KB CommonDao.class 2KB HttpClientUtils.class 2KB CommonService.class 1KB keyangongzuoliangApplication.class 1KB EIException.class 1KB JQPageInfo.class 1KB JiaoshiView.class 1KB MishuView.class 1KB ConfigEntity.class 1KB SQLFilter.class 1KB TokenService.class 1KB DictionaryView.class 1KB CommonUtil.class 1KB TokenDao.class 969B UsersDao.class 969B FileUtil.class 964B UsersService.class 952B MyMetaObjectHandler.class 941B KeyanhuojiangDao.class 737B GongzuoliangDao.class 733B KeyanlunwenDao.class 729B DictionaryDao.class 725B JiaoshiDao.class 713B XiangmuDao.class 713B MishuDao.class 705B StringUtil.class 675B MybatisPlusConfig.class 669B MyThreadMethod.class 620B DictionaryService.class 600B KeyanhuojiangService.class 487B GongzuoliangService.class 484B KeyanlunwenService.class 481B JiaoshiService.class 469B共 802 条
- 1
- 2
- 3
- 4
- 5
- 6
- 9
资源评论
