附錄附錄A通用接口代碼packagecom.controller;importjava.io.File;importjava.io.FileNotFoundException;importjava.io.IOException;importjava.text.SimpleDateFormat;importjava.util.ArrayList;importjava.util.Calendar;importjava.util.Date;importjava.util.HashMap;importjava.util.List;importjava.util.Map;importjavax.servlet.http.HttpServletRequest;importmons.lang3.StringUtils;importorg.json.JSONObject;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.util.ResourceUtils;importorg.springframework.web.bind.annotation.PathVariable;importorg.springframework.web.bind.annotation.RequestBody;importorg.springframework.web.bind.annotation.RequestMapping;importorg.springframework.web.bind.annotation.RequestParam;importorg.springframework.web.bind.annotation.RestController;importcom.annotation.IgnoreAuth;importcom.baidu.aip.face.AipFace;importcom.baidu.aip.face.MatchRequest;importcom.baidu.aip.util.Base64Util;importcom.baomidou.mybatisplus.mapper.EntityWrapper;importcom.entity.ConfigEntity;importcom.service.CommonService;importcom.service.ConfigService;importcom.utils.BaiduUtil;importcom.utils.FileUtil;importcom.utils.R;/***通用接口*/@RestControllerpublicclassCommonController{@AutowiredprivateCommonServicecommonService;privatestaticAipFaceclient=null;@AutowiredprivateConfigServiceconfigService;/***獲取table表中的column列表(聯(lián)動接口)*@paramtable*@paramcolumn*@return*/@IgnoreAuth@RequestMapping("/option/{tableName}/{columnName}")publicRgetOption(@PathVariable("tableName")StringtableName,@PathVariable("columnName")StringcolumnName,Stringlevel,Stringparent){Map<String,Object>params=newHashMap<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);returnR.ok().put("data",data);}/***根據(jù)table中的column獲取單條記錄*@paramtable*@paramcolumn*@return*/@IgnoreAuth@RequestMapping("/follow/{tableName}/{columnName}")publicRgetFollowByOption(@PathVariable("tableName")StringtableName,@PathVariable("columnName")StringcolumnName,@RequestParamStringcolumnValue){Map<String,Object>params=newHashMap<String,Object>();params.put("table",tableName);params.put("column",columnName);params.put("columnValue",columnValue);Map<String,Object>result=commonService.getFollowByOption(params);returnR.ok().put("data",result);}/***修改table表的sfsh狀態(tài)*@paramtable*@parammap*@return*/@RequestMapping("/sh/{tableName}")publicRsh(@PathVariable("tableName")StringtableName,@RequestBodyMap<String,Object>map){map.put("table",tableName);commonService.sh(map);returnR.ok();}/***獲取需要提醒的記錄數(shù)*@paramtableName*@paramcolumnName*@paramtype1:數(shù)字2:日期*@parammap*@return*/@IgnoreAuth@RequestMapping("/remind/{tableName}/{columnName}/{type}")publicRremindCount(@PathVariable("tableName")StringtableName,@PathVariable("columnName")StringcolumnName,@PathVariable("type")Stringtype,@RequestParamMap<String,Object>map){map.put("table",tableName);map.put("column",columnName);map.put("type",type);if(type.equals("2")){SimpleDateFormatsdf=newSimpleDateFormat("yyyy-MM-dd");Calendarc=Calendar.getInstance();DateremindStartDate=null;DateremindEndDate=null;if(map.get("remindstart")!=null){IntegerremindStart=Integer.parseInt(map.get("remindstart").toString());c.setTime(newDate());c.add(Calendar.DAY_OF_MONTH,remindStart);remindStartDate=c.getTime();map.put("remindstart",sdf.format(remindStartDate));}if(map.get("remindend")!=null){IntegerremindEnd=Integer.parseInt(map.get("remindend").toString());c.setTime(newDate());c.add(Calendar.DAY_OF_MONTH,remindEnd);remindEndDate=c.getTime();map.put("remindend",sdf.format(remindEndDate));}}intcount=commonService.remindCount(map);returnR.ok().put("count",count);}/***單列求和*/@IgnoreAuth@RequestMapping("/cal/{tableName}/{columnName}")publicRcal(@PathVariable("tableName")StringtableName,@PathVariable("columnName")StringcolumnName){Map<String,Object>params=newHashMap<String,Object>();params.put("table",tableName);params.put("column",columnName);Map<String,Object>result=commonService.selectCal(params);returnR.ok().put("data",result);}/***分組統(tǒng)計*/@IgnoreAuth@RequestMapping("/group/{tableName}/{columnName}")publicRgroup(@PathVariable("tableName")StringtableName,@PathVariable("columnName")StringcolumnName){Map<String,Object>params=newHashMap<String,Object>();params.put("table",tableName);params.put("column",columnName);List<Map<String,Object>>result=commonService.selectGroup(params);SimpleDateFormatsdf=newSimpleDateFormat("yyyy-MM-dd");for(Map<String,Object>m:result){for(Stringk:m.keySet()){if(m.get(k)instanceofDate){m.put(k,sdf.format((Date)m.get(k)));}}}returnR.ok().put("data",result);}/***（按值統(tǒng)計）*/@IgnoreAuth@RequestMapping("/value/{tableName}/{xColumnName}/{yColumnName}")publicRvalue(@PathVariable("tableName")StringtableName,@PathVariable("yColumnName")StringyColumnName,@PathVariable("xColumnName")StringxColumnName){Map<String,Object>params=newHashMap<String,Object>();params.put("table",tableName);params.put("xColumn",xColumnName);params.put("yColumn",yColumnName);List<Map<String,Object>>result=commonService.selectValue(params);SimpleDateFormatsdf=newSimpleDateFormat("yyyy-MM-dd");for(Map<String,Object>m:result){for(Stringk:m.keySet()){if(m.get(k)instanceofDate){m.put(k,sdf.format((Date)m.get(k)));}}}returnR.ok().put("data",result);}/***（按值統(tǒng)計）時間統(tǒng)計類型*/@IgnoreAuth@RequestMapping("/value/{tableName}/{xColumnName}/{yColumnName}/{timeStatType}")publicRvalueDay(@PathVariable("tableName")StringtableName,@PathVariable("yColumnName")StringyColumnName,@PathVariable("xColumnName")StringxColumnName,@PathVariable("timeStatType")StringtimeStatType){Map<String,Object>params=newHashMap<String,Object>();params.put("table",tableName);params.put("xColumn",xColumnName);params.put("yColumn",yColumnName);params.put("timeStatType",timeStatType);List<Map<String,Object>>result=commonService.selectTimeStatValue(params);SimpleDateFormatsdf=newSimpleDateFormat("yyyy-MM-dd");for(Map<String,Object>m:result){for(Stringk:m.keySet()){if(m.get(k)instanceofDate){m.put(k,sdf.format((Date)m.get(k)));}}}returnR.ok().put("data",result);}/***人臉比對**@paramface1人臉1*@paramface2人臉2*@return*/@RequestMapping("/matchFace")@IgnoreAuthpublicRmatchFace(Stringface1,Stringface2,HttpServletRequestrequest){if(client==null){/*StringAppID=configService.selectOne(newEntityWrapper<ConfigEntity>().eq("name","AppID")).getValue();*/StringAPIKey=configService.selectOne(newEntityWrapper<ConfigEntity>().eq("name","APIKey")).getValue();StringSecretKey=configService.selectOne(newEntityWrapper<ConfigEntity>().eq("name","SecretKey")).getValue();Stringtoken=BaiduUtil.getAuth(APIKey,SecretKey);if(token==null){returnR.error("請在配置管理中正確配置APIKey和SecretKey");}client=newAipFace(null,APIKey,SecretKey);client.setConnectionTimeoutInMillis(2000);client.setSocketTimeoutInMillis(60000);}JSONObjectres=null;try{Filepath=newFile(ResourceUtils.getURL("classpath:static").getPath());if(!path.exists()){path=newFile("");}Fileupload=newFile(path.getAb