package com.lf.server.service.show;
|
|
import com.lf.server.entity.bs.MpipelineEntity;
|
import com.lf.server.entity.show.OneMapEntity;
|
import com.lf.server.mapper.show.OneMapMapper;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
/**
|
* 管网一张图Service
|
*
|
* @author 邢锦双
|
*/
|
@Service
|
public class OneMapService implements OneMapMapper {
|
@Autowired
|
OneMapMapper aMapOfPipelineMapper;
|
|
/**
|
* 项目类别conut
|
*/
|
@Override
|
public List<String> projectCategoryCount() {
|
return aMapOfPipelineMapper.projectCategoryCount();
|
}
|
|
/**
|
* 项目位置conut
|
*
|
* @return {@link List}<{@link String}>
|
*/
|
@Override
|
public List<String> projectLocationCount() {
|
return aMapOfPipelineMapper.projectLocationCount();
|
}
|
|
/**
|
* 国家维度conut
|
*/
|
@Override
|
public List<String> countryDimensionCount() {
|
return aMapOfPipelineMapper.countryDimensionCount();
|
}
|
|
/**
|
* 省维conut
|
*
|
* @return {@link List}<{@link String}>
|
*/
|
@Override
|
public List<String> provinceDimensionCount() {
|
return aMapOfPipelineMapper.provinceDimensionCount();
|
}
|
|
/**
|
* 数据存储conut
|
*
|
* @return {@link List}<{@link String}>
|
*/
|
@Override
|
public List<String> dataStorageCount() {
|
return aMapOfPipelineMapper.dataStorageCount();
|
}
|
|
/**
|
* 文件格式conut
|
*
|
* @return {@link List}<{@link String}>
|
*/
|
@Override
|
public List<String> fileFormatCount() {
|
return aMapOfPipelineMapper.fileFormatCount();
|
}
|
|
/**
|
* 数据申请conut
|
*
|
* @return {@link List}<{@link String}>
|
*/
|
@Override
|
public List<String> dataApplyCount() {
|
return aMapOfPipelineMapper.dataApplyCount();
|
}
|
|
/**
|
* 数据访问数
|
*
|
* @return {@link List}<{@link String}>
|
*/
|
@Override
|
public List<String> dataVisitCount() {
|
return aMapOfPipelineMapper.dataVisitCount();
|
}
|
|
/**
|
* 下载数统计
|
*
|
* @return {@link List}<{@link String}>
|
*/
|
@Override
|
public List<String> countDownloads() {
|
return aMapOfPipelineMapper.countDownloads();
|
}
|
|
/**
|
* 统计项目显示
|
*
|
* @return {@link List}<{@link String}>
|
*/
|
@Override
|
public List<String> countProjectDisplay() {
|
return aMapOfPipelineMapper.countProjectDisplay();
|
}
|
|
/**
|
* 统计项目参观
|
*
|
* @return {@link List}<{@link String}>
|
*/
|
@Override
|
public List<String> countProjectTour(MpipelineEntity mpipelineEntity) {
|
return aMapOfPipelineMapper.countProjectTour(mpipelineEntity);
|
}
|
|
/**
|
* 选择项目参观列表
|
*
|
* @return {@link List}<{@link String}>
|
*/
|
@Override
|
public List<String> selectProjectTour() {
|
return aMapOfPipelineMapper.selectProjectTour();
|
}
|
|
/**
|
* 统计项目类型
|
*
|
* @return {@link List}<{@link String}>
|
*/
|
public List<OneMapEntity> selectProjectType1() {
|
|
|
List<OneMapEntity> resList = new ArrayList<>();
|
|
List<OneMapEntity> resInfo = aMapOfPipelineMapper.selectProjectType1();
|
for (OneMapEntity oneMapEntity : resInfo) {
|
if (oneMapEntity.getValue().equals("测量（ESV）")) {
|
String valueStr = oneMapEntity.getKey();
|
System.out.println("测量（ESV）== valueStr == " + valueStr);
|
String endSql = null;
|
String sqlQur = "";
|
if (valueStr.length() > 0) {
|
String[] arrStr = valueStr.split(",");
|
StringBuilder one = new StringBuilder();
|
if (arrStr.length > 0) {
|
System.out.println("arrStr = " + arrStr.length);
|
}
|
for (String s : arrStr) {
|
sqlQur = "\'" + s + "%\' " + "or dircode like";
|
one.append(sqlQur);
|
}
|
endSql = " where dircode like " + one.substring(0, one.toString().length() - 15);
|
System.out.println("endSql = " + endSql);
|
}
|
resList.addAll(aMapOfPipelineMapper.selectProjectTypeOne(endSql));
|
|
} else if (oneMapEntity.getValue().equals("勘察（EGE）")) {
|
String valueStr = oneMapEntity.getKey();
|
System.out.println("勘察（EGE）== valueStr == " + valueStr);
|
String endSql1 = null;
|
String sqlQur = "";
|
if (valueStr.length() > 0) {
|
String[] arrStr1 = valueStr.split(",");
|
StringBuilder one = new StringBuilder();
|
if (arrStr1.length > 0) {
|
System.out.println("arrStr = " + arrStr1.length);
|
}
|
for (String s : arrStr1) {
|
sqlQur = "\'" + s + "%\' " + "or dircode like";
|
one.append(sqlQur);
|
}
|
endSql1 = " where dircode like " + one.substring(0, one.toString().length() - 15);
|
System.out.println("endSql1 = " + endSql1);
|
}
|
resList.addAll(aMapOfPipelineMapper.selectProjectTypeOne(endSql1));
|
|
} else if (oneMapEntity.getValue().equals("地灾（EGD）")) {
|
String valueStr = oneMapEntity.getKey();
|
System.out.println("地灾（EGD）== valueStr == " + valueStr);
|
String endSql2 = null;
|
String sqlQur = "";
|
if (valueStr.length() > 0) {
|
String[] arrStr2 = valueStr.split(",");
|
StringBuilder one = new StringBuilder();
|
if (arrStr2.length > 0) {
|
System.out.println("arrStr = " + arrStr2.length);
|
}
|
for (int j = 0; j < arrStr2.length; j++) {
|
sqlQur = "\'" + arrStr2[j] + "%\' " + "or dircode like";
|
one.append(sqlQur);
|
}
|
endSql2 = " where dircode like " + one.substring(0, one.toString().length() - 15);
|
System.out.println("endSql2 = " + endSql2);
|
}
|
resList.addAll(aMapOfPipelineMapper.selectProjectTypeOne(endSql2));
|
|
} else if (oneMapEntity.getValue().equals("洞库（EGD）")) {
|
String valueStr = oneMapEntity.getKey();
|
System.out.println("洞库（EGD）== valueStr == " + valueStr);
|
String endSql3 = null;
|
String sqlQur = "";
|
if (valueStr.length() > 0) {
|
String[] arrStr3 = valueStr.split(",");
|
StringBuilder one = new StringBuilder();
|
if (arrStr3.length > 0) {
|
System.out.println("arrStr = " + arrStr3.length);
|
}
|
for (int j = 0; j < arrStr3.length; j++) {
|
sqlQur = "\'" + arrStr3[j] + "%\' " + "or dircode like";
|
one.append(sqlQur);
|
}
|
endSql3 = " where dircode like " + one.substring(0, one.toString().length() - 15);
|
System.out.println("endSql3 = " + endSql3);
|
}
|
resList.addAll(aMapOfPipelineMapper.selectProjectTypeOne(endSql3));
|
}
|
}
|
return resList;
|
}
|
|
@Override
|
public List<OneMapEntity> selectProjectTypeOne(String sqlQur) {
|
return null;
|
}
|
|
|
/**
|
* 查询表信息
|
*
|
* @return {@link List}<{@link String}>
|
*/
|
@Override
|
public List<String> queryTableInfo(String tableName) {
|
return aMapOfPipelineMapper.queryTableInfo(tableName);
|
}
|
}
|
