package com.terra.system.service.all;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
|
import com.baomidou.mybatisplus.core.metadata.OrderItem;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.terra.system.entity.all.MenusAuthEntity;
|
import com.terra.system.entity.all.PermsAuthEntity;
|
import com.terra.system.entity.all.ResAuthEntity;
|
import com.terra.system.entity.ctrl.CountEntity;
|
import com.terra.system.entity.data.MetaEntity;
|
import com.terra.system.entity.data.MetaFileEntity;
|
import com.terra.system.helper.*;
|
import com.terra.system.service.data.MetaService;
|
import com.terra.system.service.data.UploadService;
|
import com.terra.system.service.sys.ArgsService;
|
import com.terra.system.service.sys.BlacklistService;
|
import com.terra.system.service.sys.ReportService;
|
import org.apache.commons.logging.Log;
|
import org.apache.commons.logging.LogFactory;
|
import javax.annotation.Resource;
|
import org.springframework.core.env.Environment;
|
import org.springframework.stereotype.Service;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* 测试服务类
|
* @author WWW
|
*/
|
@Service
|
@SuppressWarnings("AlibabaRemoveCommentedCode")
|
public class TestService {
|
@Resource
|
PathHelper pathHelper;
|
|
@Resource
|
ArgsService argsService;
|
|
@Resource
|
PermsService permsService;
|
|
@Resource
|
BlacklistService blacklistService;
|
|
@Resource
|
BaseQueryService baseQueryService;
|
|
@Resource
|
Environment env;
|
|
@Resource
|
ReportService reportService;
|
|
@Resource
|
UploadService uploadService;
|
|
@Resource
|
MetaService metaService;
|
|
private final static Log log = LogFactory.getLog(TestService.class);
|
|
public void testGdal() {
|
GdalHelper.readTif("E:\\data\\7.Insar\\insartest.tif");
|
GdalHelper.readShp("E:\\data\\13.cppe\\shps\\addr.shp");
|
GdalHelper.readGdb("E:\\Test\\addr.gdb");
|
//GdalHelper.readShpFirstRecord("D:\\LF\\data\\shp\\extent.shp");
|
com.terra.system.helper.RsaHelper.generate();
|
//FloatServerController.test();
|
|
testReadExcel();
|
boolean f1 = ZipHelper.unzip("D:\\LF\\data\\resources.zip", "D:\\LF\\data\\unzip");
|
boolean f2 = ZipHelper.zip("D:\\LF\\data\\res.zip", "D:\\LF\\data\\unzip\\resources");
|
boolean f3 = Zip4jHelper.zip("D:\\LF\\data\\zip\\resources.zip", "D:\\LF\\data\\zip\\resources", "12345");
|
boolean f4 = Zip4jHelper.unzip("D:\\LF\\data\\zip\\resources.zip", "D:\\LF\\data\\zip\\res", "12345");
|
}
|
|
public void testMeta() {
|
List<MetaEntity> list = metaService.selectByIdsForTab("1501,1500,1491,1492");
|
String sql = metaService.getDelTabsSql(list);
|
}
|
|
public void testReadShp() {
|
MetaFileEntity mf = new MetaFileEntity();
|
//mf.setPath("D:\\model_data\\m_sitepoint.shp");
|
mf.setPath("D:\\shpto\\m_sitepoint.shp");
|
mf.setEntity("msitepoint");
|
mf.setGuid("msitepoint");
|
mf.setTab("bs.m_sitepoint");
|
mf.setExtName(".shp");
|
|
uploadService.loadSpatialData(mf);
|
}
|
|
public void testBatchUpdate() {
|
/*DlgagnpEntity d1 = new DlgagnpEntity();
|
d1.setGid(56);
|
d1.setGb("10");
|
d1.setName("a01");
|
DlgagnpEntity d2 = new DlgagnpEntity();
|
d2.setGid(57);
|
d2.setGb("20");
|
d2.setName("a02");
|
|
List<DlgagnpEntity> list = new ArrayList<>();
|
list.add(d1);
|
list.add(d2);
|
|
int rows = dlgagnpMapper.updateBatch(list);*/
|
}
|
|
public void testMybatisPlus() {
|
/*String tabName = BaseQueryService.getTabName(dlgagnpMapper);
|
List<String> list0 = dlgagnpMapper.selectFieldFuzzy(tabName, "name", "%县%");
|
|
DlgagnpEntity dlg = dlgagnpMapper.selectById(1);
|
String wkt = dlgagnpMapper.selectWktById(tabName, 2);
|
|
Map<String, Object> map = new HashMap<String, Object>(3);
|
map.put("gid", 2);
|
List<DlgagnpEntity> list1 = dlgagnpMapper.selectByMap(map);
|
|
QueryWrapper<DlgagnpEntity> w1 = new QueryWrapper<>();
|
w1.eq("name", "治多县");
|
List<DlgagnpEntity> list2 = dlgagnpMapper.selectList(w1);
|
|
UpdateWrapper<DlgagnpEntity> w2 = new UpdateWrapper<DlgagnpEntity>();
|
// 设置更新内容
|
w2.set("name", "newName").set("gb", "10013")
|
// 设置更新条件
|
.eq("gid", 0);
|
// dlgagnpMapper.update(null, w2)
|
|
List<Integer> ids = new ArrayList<Integer>();
|
ids.add(1);
|
ids.add(2);
|
// dlgagnpMapper.deleteBatchIds(ids)
|
List<DlgagnpEntity> list3 = dlgagnpMapper.selectBatchIds(ids);
|
|
// dlgagnpMapper.updateById(dlg)
|
// List<DlgAgnp> all = dlgagnpMapper.selectList(null)
|
|
// 页数 / 每页记录数
|
Page<DlgagnpEntity> page = new Page<>(1, 10);
|
// 升序排序
|
page.addOrder(OrderItem.desc("gid"));
|
// 分页：Wrapper查询条件
|
Page<DlgagnpEntity> userPage = dlgagnpMapper.selectPage(page, null);
|
// 总页数 / 总记录数：325 / 3247
|
String str = userPage.getPages() + " / " + userPage.getTotal();
|
List<DlgagnpEntity> list4 = userPage.getRecords();
|
|
QueryWrapper<DlgagnpEntity> w3 = new QueryWrapper<>();
|
w3.like("name", "多").ge("gid", 100);
|
List<DlgagnpEntity> list5 = dlgagnpMapper.selectList(w3);*/
|
}
|
|
public void testAes() {
|
try {
|
String content = "POLYGON ((115.94927385452 32.3754479115071 0,121.989371092554 32.2766788010181 0,121.850621222894 29.6874200067864 0,115.9727267226 29.7835368627922 0,115.94927385452 32.3754479115071 0))";
|
System.out.println("加密前：" + content);
|
String encrypt = AesHelper.encrypt(content);
|
|
System.out.println("加密后：" + encrypt);
|
String decrypt = AesHelper.decrypt(encrypt);
|
|
System.out.println("解密后：" + decrypt);
|
} catch (Exception ex) {
|
log.error(ex.getMessage(), ex);
|
}
|
}
|
|
public void testPerms() {
|
List<ResAuthEntity> raeList = permsService.selectRes("admin");
|
List<ResAuthEntity> raeList2 = permsService.selectRes("admin");
|
|
List<MenusAuthEntity> maeList = permsService.selectMenus("admin");
|
List<MenusAuthEntity> maeList2 = permsService.selectMenus("admin");
|
|
List<String> pList = permsService.selectPerms("admin");
|
List<String> pList2 = permsService.selectPerms("admin");
|
|
List<PermsAuthEntity> pauList = permsService.selectPermsEntity("admin");
|
List<PermsAuthEntity> pauList2 = permsService.selectPermsEntity("admin");
|
|
// permsService.clearResCache()
|
permsService.clearPermsCache();
|
|
raeList = permsService.selectRes("admin");
|
maeList = permsService.selectMenus("admin");
|
pList = permsService.selectPerms("admin");
|
pauList = permsService.selectPermsEntity("admin");
|
permsService.clearAllCache();
|
}
|
|
public void testBlacklist() {
|
List<String> list1 = blacklistService.selectIpList(1);
|
List<String> list2 = blacklistService.selectIpList(1);
|
List<String> list3 = blacklistService.selectIpList(2);
|
List<String> list4 = blacklistService.selectIpList(2);
|
blacklistService.clearCache();
|
List<String> list5 = blacklistService.selectIpList(1);
|
}
|
|
public void testReadExcel() {
|
List<?> listMdZxcg = ExcelHelper.readExcel(MetaEntity.class, "D:\\LF\\data\\xls\\测绘\\1-项目成果-西三中\\1-1中线成果表\\海原县中线成果表.xlsx");
|
int r1 = listMdZxcg.size();
|
|
//List<MdGdcgEntity> listGdcg = ExcelHelper.readExcel(MdGdcgEntity.class, "D:\\LF\\data\\xls\\测绘\\2-地下管线探测成果\\2-2 管线成果表.xlsx");
|
//int r2 = listGdcg.size();
|
|
String entityName = "Gxcg";
|
String xls = "D:\\LF\\data\\xls\\测绘\\2-地下管线探测成果\\2-2 管线成果表.xlsx";
|
|
String className = "com.terra.system.entity.bs." + entityName;
|
Object obj = ClassHelper.createInstance(className);
|
|
List<?> list = ExcelHelper.readExcel(obj.getClass(), xls);
|
int r3 = list.size();
|
}
|
|
public void testAccess() {
|
List<Map<String, Object>> list = AccessHelper.readMdb("D:\\LF\\data\\test.mdb", "", "");
|
int count = null == list || list.isEmpty() ? 0 : list.size();
|
}
|
|
public void testMd5() {
|
try {
|
String file = "E:\\data\\mpt\\A4mpt20131125.mpt";
|
|
long stime = System.currentTimeMillis();
|
// 2a0befb05146cd30213ee4b95038aca0
|
String md51 = FileHelper.getFileMd5(file);
|
long etime = System.currentTimeMillis();
|
String s1 = String.format("执行时长：%d 毫秒.", (etime - stime));
|
|
stime = System.currentTimeMillis();
|
// 2a0befb05146cd30213ee4b95038aca0
|
String md52 = FileHelper.getMd5ByJdk(file);
|
etime = System.currentTimeMillis();
|
String s2 = String.format("执行时长：%d 毫秒.", (etime - stime));
|
|
stime = System.currentTimeMillis();
|
// 9f1b7f050f41598710ffc08252484397
|
//String md53 = FileHelper.getFastMd5(file);
|
etime = System.currentTimeMillis();
|
String s3 = String.format("执行时长：%d 毫秒.", (etime - stime));
|
|
etime = System.currentTimeMillis();
|
} catch (Exception ex) {
|
//
|
}
|
}
|
|
public void testWord() {
|
String inputFile = "C:\\Users\\Administrator\\Desktop\\ts\\项目数据分类统计.docx";
|
String outPutFile = "C:\\Users\\Administrator\\Desktop\\ts\\NewWord.docx";
|
|
Map<String, String> textMap = new HashMap<>(1);
|
textMap.put("title", "深圳液化天然气应急调峰站外输管道工程（XQ03T04）");
|
|
List<String[]> tableList = new ArrayList<>();
|
tableList.add(new String[]{"" + 1, "数字线划图", "123.54平方米"});
|
tableList.add(new String[]{"" + 2, "地灾点", "120个"});
|
|
WordHelper.generateWord(inputFile, outPutFile, textMap, tableList);
|
}
|
|
public void testExcel() {
|
String source = "C:\\Users\\Administrator\\Desktop\\ts\\项目数据分类统计.xlsx";
|
String target = "C:\\Users\\Administrator\\Desktop\\ts\\NewWord.xlsx";
|
|
List<CountEntity> list = new ArrayList<>();
|
CountEntity c1 = new CountEntity();
|
c1.setNo(1);
|
c1.setM1("数字线划图");
|
c1.setM2("123.54平方米");
|
list.add(c1);
|
|
CountEntity c2 = new CountEntity();
|
c2.setNo(2);
|
c2.setM1("地灾点");
|
c2.setM2("120个");
|
list.add(c2);
|
|
Map<String, Object> map = new HashMap<>(1);
|
map.put("title", "深圳液化天然气应急调峰站外输管道工程（XQ03T04）");
|
|
Map<String, List<CountEntity>> listMap = new HashMap<>(1);
|
listMap.put("data", list);
|
|
ExcelHelper.writeToTemplate(source, target, map, listMap);
|
}
|
}
|
