package cn.autoform.excel.impl;
|
|
import cn.autoform.bean.CodeAndValueBean;
|
import cn.autoform.db.entity.FieldPropertyEntity;
|
import cn.autoform.db.entity.FormBaseEntity;
|
import cn.autoform.db.entity.FormFieldEntity;
|
import cn.autoform.db.exten.MasterValue;
|
import cn.autoform.excel.Excel;
|
import cn.autoform.factory.FormFactory;
|
import cn.autoform.factory.product.ProductMethod;
|
import cn.autoform.factory.product.ProductMethod.IOType;
|
import cn.autoform.fw.utility.ConstMap;
|
import cn.autoform.util.thread.ThreadData;
|
import cn.autoform.util.tool.JSONTool;
|
import cn.autoform.web.client.MasterClient;
|
import cn.autoform.web.controller.datamanagement.DataManagementController;
|
import cn.autoform.web.interceptor.spring.InitParamInterceptor;
|
import cn.autoform.web.mapper.datamanagement.DataManagementMapper;
|
import cn.autoform.web.mapper.formset.FormSetMapper;
|
import cn.autoform.web.service.datamanagement.DataManagementService;
|
import cn.autoform.web.service.formbase.FormBaseService;
|
import com.iemsoft.framework.cloud.core.tools.SpringUtil;
|
import jxl.CellView;
|
import jxl.Sheet;
|
import jxl.Workbook;
|
import jxl.write.*;
|
import lombok.Data;
|
import lombok.extern.slf4j.Slf4j;
|
import net.sf.json.JSONObject;
|
import org.apache.commons.lang3.StringUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.context.annotation.Scope;
|
import org.springframework.stereotype.Service;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.IOException;
|
import java.io.OutputStream;
|
import java.net.URLEncoder;
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.time.LocalDateTime;
|
import java.time.format.DateTimeFormatter;
|
import java.util.*;
|
import java.util.concurrent.ExecutorService;
|
import java.util.concurrent.Executors;
|
import java.util.regex.Matcher;
|
import java.util.regex.Pattern;
|
import java.util.stream.Collectors;
|
@Slf4j
|
@Service
|
@Scope("prototype")
|
public class ExcelImpl implements Excel {
|
|
private final String YEAR = "20";
|
|
private static final String TAGATTRIBUTE = "tag_Attribute";
|
|
private static final String FIELDSET = "fieldset";
|
|
@Resource
|
private FormSetMapper formSetMapper;
|
|
static final ExecutorService pool = Executors.newFixedThreadPool(10);
|
|
@Autowired
|
private DataManagementController dataManagementController = null;
|
|
@Autowired
|
private DataManagementService dataManagementService = null;
|
|
@Autowired
|
private FormFactory formFactory = null;
|
|
@Resource
|
DataManagementMapper dataManagementMapper;
|
|
@Autowired
|
private FormBaseService formBaseService = null;
|
|
private String DATAROWNUM = "DATAROWNUM";
|
|
/**
|
* 主数据缓存
|
*/
|
private Map<Integer,List<CodeAndValueBean>> masterCatch = new HashMap<Integer,List<CodeAndValueBean>>();
|
|
@Autowired
|
private MasterClient masterClient;
|
|
/**
|
* 导出模板
|
* @param formID
|
* @param tenantID
|
* @param request
|
* @param response
|
* @return
|
* @throws Exception
|
*/
|
@Override
|
public String expMod(String formID, String tenantID, HttpServletRequest request, HttpServletResponse response) throws Exception {
|
//导出模版
|
//取出当前表单名
|
String formName = formSetMapper.selectBuss(formID,tenantID)+new SimpleDateFormat("yyyyHHddhhmmss").format(new Date());
|
System.out.println("当前表单:"+formName);
|
OutputStream out = response.getOutputStream();// 取得输出流
|
response.reset();// 清空输出流
|
response.setHeader("Access-Control-Allow-Origin", "*"); //跨域
|
response.setHeader("content-disposition", "attachment;filename=" + URLEncoder.encode(formName+".xls", "UTF-8"));
|
response.setContentType("application/octet-stream");// 指明response的返回对象是文件流,通知浏览器下载文件而不是打开
|
WritableWorkbook workbook = Workbook.createWorkbook(out); //生成于response输出流
|
//创建sheet页(工作表)
|
WritableSheet sheet = workbook.createSheet("main", 0); //页名，页码
|
WritableFont wfont = new WritableFont(WritableFont.createFont("楷书"), 12);
|
//定义样式，在该实例中可以定义字体，背景颜色，位置等
|
WritableCellFormat format = new WritableCellFormat(wfont);
|
//查询表单字段
|
List<FormFieldEntity> rsList = dataManagementService.queryFormFields(formID, tenantID);
|
DataMain subForm = new DataMain();
|
rsList.stream().forEach(formField ->{
|
if(formField.getFieldtype().equals("subform")){
|
subForm.getSubList().put(Objects.toString(formField.getColumnOrderNum(),"-1")
|
,new ArrayList<>());
|
}
|
});
|
System.out.println(rsList);
|
System.out.println("表单数据:"+ JSONTool.toJson(rsList.get(0)));
|
getModelData(JSONTool.toObj(rsList.get(0).getFieldset(),Map.class) ,subForm);
|
//首先生成main页面（主表单）
|
Label label = null;
|
Integer i = 0;
|
for(String in :subForm.getMain()){
|
label = new Label(i, 0,in);
|
sheet.addCell(label);
|
i++;
|
};
|
//生成子表单
|
System.out.println("这是撒"+JSONTool.toJson(subForm));
|
subForm.getSubList().keySet().stream()
|
.forEach(o->{
|
Integer pa = 1;
|
WritableSheet subSheet = workbook.createSheet(o, pa); //页名，页码
|
WritableFont subWfont = new WritableFont(WritableFont.createFont("楷书"), 12);
|
//定义样式，在该实例中可以定义字体，背景颜色，位置等
|
WritableCellFormat subFormat = new WritableCellFormat(subWfont);
|
Label subLabel = null;
|
Integer s = 1;
|
try {
|
//单独添加一个行
|
subSheet.addCell(new Label(0, 0,"num"));
|
for(String in :subForm.getSubList().get(o)){
|
subLabel = new Label(s, 0,in);
|
subSheet.addCell(subLabel);
|
s++;
|
}
|
} catch (WriteException e) {
|
e.printStackTrace();
|
}finally {
|
pa++;
|
}
|
|
});
|
workbook.write();
|
workbook.close();
|
out.flush();
|
out.close();
|
return null;
|
}
|
|
@Override
|
@SuppressWarnings("unchecked")
|
public String expExcel(String formID, String tenantID, IOType flag, HttpServletRequest request, HttpServletResponse response) throws Exception {
|
//新开线程
|
// ImpExcelThread impExcelThread = new ImpExcelThread();
|
//导出为true
|
ImpExcelThread impExcelThread = SpringUtil.getBean(ImpExcelThread.class);
|
impExcelThread.setFormId(formID);
|
impExcelThread.setTenantID(tenantID);
|
impExcelThread.setRequest(request);
|
impExcelThread.setResponse(response);
|
impExcelThread.setCookie(copyCookie());
|
// pool.submit(new Thread(impExcelThread));
|
impExcelThread.run();
|
//导出表单
|
//查询表单信息，获取表单名
|
FormBaseEntity formBaseEntity = formBaseService.getFormBaseInfo(tenantID, formID,null);
|
String formName = formBaseEntity.getFormName();
|
OutputStream out = response.getOutputStream();// 取得输出流
|
response.reset();// 清空输出流
|
response.setHeader("Access-Control-Allow-Origin", "*"); //跨域
|
response.setHeader("content-disposition", "attachment;filename=" + URLEncoder.encode(formName + ".xls", "UTF-8"));
|
response.setContentType("application/octet-stream");// 指明response的返回对象是文件流,通知浏览器下载文件而不是打开
|
//创建一个工作簿
|
WritableWorkbook workbook = Workbook.createWorkbook(out);
|
//创建sheet页(工作表)
|
WritableSheet sheet = workbook.createSheet("sheet1", 0); //页名，页码
|
//定义样式，在该实例中可以定义字体，背景颜色，位置等
|
WritableCellFormat format = new WritableCellFormat();
|
CellView cellView = new CellView();
|
cellView.setAutosize(true); //设置自动大小
|
//查询表单字段
|
List<FormFieldEntity> rsList = dataManagementService.queryFormFields(formID, tenantID);
|
//获得子表单个数
|
List<Integer> subForm = new ArrayList<>();
|
rsList.stream().forEach(formField ->{
|
if(formField.getFieldtype().equals("subform")){
|
subForm.add(formField.getColumnOrderNum());
|
}
|
});
|
Map<Integer, Integer> subField = new HashMap<>();
|
if(subForm.size()> 0){
|
subForm.stream().forEach(columnOrderNum ->{
|
rsList.stream().filter(formField -> formField.getParentsubFormNum().equals(columnOrderNum) && !formField.getFieldKey().equals(getDATAROWNUM()))
|
.forEach(formField -> {
|
int i = 1;
|
subField.put(columnOrderNum,i);
|
i++;
|
}
|
);
|
});
|
}
|
//字段名(主+子)
|
List<Object> filedName = new ArrayList<>();
|
StringBuilder subname = new StringBuilder(); //装子表单序号
|
int mainfiled = 0; //主表单字段数
|
List<Integer> subfiled = new ArrayList<>(); //子表单字段统计
|
//统计主表单字段数
|
for (int i = 0; i < rsList.size(); i++) {
|
if (!"subform".equals(rsList.get(i).getFieldtype()) && rsList.get(i).getParentsubFormNum() ==0) {
|
mainfiled++;
|
}
|
}
|
//字段写入题头（第二行）
|
Label label = null;
|
int j = 0;
|
int subc = 0;
|
int begin = 0;
|
String wToS = "main";//以子表单开头还是主表单开头
|
List<Map<Integer, Integer>> why = new ArrayList<>();
|
for (int i = 0; i < rsList.size(); i++) {
|
if ("subform".equals(rsList.get(i).getFieldtype())) {
|
if(i ==0){
|
wToS = "subForm";
|
begin = j;
|
}
|
Map<Integer, Integer> where = new HashMap<>();
|
where.put(rsList.get(i).getColumnOrderNum(),j);
|
why.add(where);
|
label = new Label(j, 0, rsList.get(i).getFieldKey(), format);
|
sheet.setColumnView(j, cellView);//根据内容自动设置列宽
|
subname.append(rsList.get(i).getColumnOrderNum());
|
subname.append(",");
|
subfiled.add(subc);
|
subc = 0;
|
} else {
|
if(rsList.get(i).getParentsubFormNum() == 0){
|
sheet.mergeCells(j,0,j,1);
|
label = new Label(j, 0, rsList.get(i).getFieldKey(), format); //1.列 2.行 3.数据
|
}else{
|
label = new Label(j, 1, rsList.get(i).getFieldKey(), format);
|
if(!(getDATAROWNUM()).equals(rsList.get(i).getFieldKey()))
|
subc++ ;
|
|
}
|
j++;
|
filedName.add(rsList.get(i).getFieldKey());
|
}
|
sheet.addCell(label);
|
}
|
if(wToS.equals("main")){
|
sheet.mergeCells(begin, 0, j-1, 0);//
|
}else{
|
if(why.size()>0){
|
why.stream().forEach(wh ->{
|
Iterator<Integer> it = wh.keySet().iterator();
|
while(it.hasNext()){
|
int i = it.next();
|
try {
|
sheet.mergeCells(wh.get(i), 0,wh.get(i) + subField.get(i), 0);
|
} catch (WriteException e) {
|
e.printStackTrace();
|
}
|
}
|
});
|
}
|
}
|
subfiled.add(subc);
|
subfiled.remove(0); //去掉第一位
|
String[] subNameArr = subname.toString().split(","); //子表单序号数组
|
//查询主表单数据，统计数据条数
|
ProductMethod productMethod = this.formFactory.createFormMethod();
|
List<Map<String, Object>> rsMap =null;
|
//查询当前表单所有数据
|
rsMap = productMethod.queryFormDataList(formID, tenantID, null);
|
|
//取得数据行号datarowNum
|
List<Integer> datarowNum = new ArrayList<>();
|
for (int i = 0; i < rsMap.size(); i++) {
|
Map<String, Object> map = rsMap.get(i);
|
datarowNum.add(Integer.parseInt(map.get("DATAROWNUM").toString()));
|
}
|
//逐条查询表单数据
|
int count = rsMap.size(); //表单数据条数
|
int line = 2; //数据在表格中所在的行
|
//循环查询单条数据，datarowNum：数据行号，formdataNum：子表单序号
|
for (int i = 0; i < count; i++) {
|
boolean subWhere = true;//判断子表单是不是第一个控件,默认为第一个
|
Map<String, Object> single = productMethod.queryFormDataList(formID, tenantID, datarowNum.get(i), subname.toString());
|
//主表单
|
Iterator<String> whForm= single.keySet().iterator();
|
String toMerge = null;//判断是否合并 默认为合并
|
int filedNameNum = 0;
|
int maxL = 0;//最大长度
|
while(whForm.hasNext()){
|
String formW = whForm.next().toString();
|
if ("main".equals(formW)) {
|
String todo = null;
|
int realine = line;
|
if(toMerge != null){
|
realine = line-maxL;
|
todo = "do";
|
}
|
toMerge = "NO";
|
subWhere = false;
|
if(wToS.equals("main")){
|
// mainfiled = filedNameNum + mainfiled;
|
filedNameNum = 0;
|
}
|
Map<String, Object> mainData = (Map<String, Object>)single.get("main");
|
for (int x = filedNameNum; x < mainfiled; x ++) {
|
String value = mainData.get(filedName.get(x)).toString();
|
if (value.indexOf("★☆") != -1) { //复选数据替换为，间隔
|
label = new Label(x, realine, value.replaceAll("★☆", ","), format);
|
} else {
|
label = new Label(x, realine, value, format); //1.列 2.行 3.数据
|
}
|
sheet.addCell(label);
|
if("do".equals(todo)){
|
sheet.mergeCells(x, realine, x, realine + maxL -1);
|
}
|
}
|
}
|
//子表单
|
if ("subs".equals(formW)) {
|
//全部子表单
|
Map<Integer, List<Map<String, Object>>> subs = (Map<Integer, List<Map<String, Object>>>)single.get("subs");
|
int maxC = 0;
|
for (int k = 0; k < subNameArr.length; k++) { //统计数据最多条数
|
List<Map<String, Object>> subList = (List<Map<String, Object>>)subs.get(subNameArr[k]);
|
if (subList!=null &&subList.size() > maxC) {
|
maxC = subList.size();
|
}
|
}
|
maxL = maxC;
|
if(!subWhere){
|
//合并主表单元格
|
for(int cul=0; cul<mainfiled; cul++){
|
sheet.mergeCells(cul, line, cul, line+maxC -1);
|
}
|
}else{
|
filedNameNum = this.dataManagementMapper.getsubFormFieldCount(formID, tenantID);
|
}
|
for (int c = 0; c < maxC; c++) {
|
|
int n = (wToS.equals("subForm") ? 0 : mainfiled);
|
for (int k = 0; k < subNameArr.length; k++) {
|
//每个子表单
|
List<Map<String, Object>> subList = (List<Map<String, Object>>)subs.get(subNameArr[k]);
|
if(maxC>1){
|
toMerge = "YES";
|
}
|
for (int m = 0; m < subfiled.get(k); m++) {
|
if (subList.size() > c) {
|
Map<String, Object> subData = subList.get(c);
|
String value = subData.get(filedName.get(n+m)).toString();
|
if (value.indexOf("★☆") != -1) { //复选数据替换为，间隔
|
label = new Label(n+m, line, value.replaceAll("★☆", ","), format);
|
} else {
|
label = new Label(n+m, line, value, format); //1.列 2.行 3.数据
|
}
|
|
sheet.addCell(label);
|
}
|
}
|
n = n + subfiled.get(k);
|
}
|
line++;
|
}
|
}
|
}
|
// line++;
|
}
|
workbook.write();
|
workbook.close();
|
|
out.flush();
|
out.close();
|
|
return null;
|
}
|
|
@Override
|
public String impExcel(MultipartFile file, String formID, String tenantID, String userName, IOType flag, HttpServletRequest request , HttpServletResponse response) throws Exception {
|
//新开线程
|
ImpExcelThread impExcelThread = SpringUtil.getBean(ImpExcelThread.class);
|
impExcelThread.setFile(file);
|
//导入为true
|
impExcelThread.setFlag(true);
|
impExcelThread.setFormId(formID);
|
impExcelThread.setTenantID(tenantID);
|
impExcelThread.setUserName(userName);
|
impExcelThread.setRequest(request);
|
impExcelThread.setResponse(response);
|
impExcelThread.setCookie(copyCookie());
|
impExcelThread.run();
|
// pool.submit(impExcelThread);
|
|
|
return null;
|
}
|
|
// 验证数字格式
|
public boolean isNumeric(String str){
|
Pattern pattern = null;
|
if(str.indexOf(".")>0){
|
pattern = Pattern.compile("^-?([1-9]\\d*\\.\\d*|0\\.\\d*[1-9]\\d*|0?\\.0+|0)$");
|
}else{
|
pattern = Pattern.compile("^[0-9]*$");
|
}
|
// +表示1个或多个，*表示0个或多个，?表示0个或1个
|
// "[0-9]*" 正数
|
// "^-?[0-9]+" 负数
|
//"-?[0-9]+.?[0-9]+" 全部数字
|
Matcher isNum = pattern.matcher(str);
|
if( !isNum.matches() ){
|
System.out.println("数字格式错误:++++++++++++++"+str);
|
return false;
|
}
|
return true;
|
}
|
|
//验证日期格式
|
public boolean isValidDate(String str) {
|
boolean convertSuccess = true;
|
// 指定日期格式为四位年/两位月份/两位日期，注意yyyy/MM/dd区分大小写；
|
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
|
try {
|
// 设置lenient为false. 否则SimpleDateFormat会比较宽松地验证日期，比如2007/02/29会被接受，并转换成2007/03/01
|
format.setLenient(false);
|
format.parse(str);
|
} catch (ParseException e) {
|
// 如果throw java.text.ParseException或者NullPointerException，就说明格式不对
|
System.out.println("日期格式错误:++++++++++++"+str);
|
convertSuccess = false;
|
}
|
return convertSuccess;
|
}
|
|
|
/**
|
* 导入子表单
|
*/
|
@Override
|
public List<List<String>> imgSonExcel(Integer rowNum,String formID, String tenantID, String userName,
|
MultipartFile file, IOType flag,
|
HttpServletRequest request, HttpServletResponse response) throws Exception {
|
Workbook workbook = Workbook.getWorkbook(file.getInputStream());
|
//取得工作页
|
Sheet sheet = workbook.getSheet(0);
|
|
//查询表单字段
|
List<FormFieldEntity> formList = dataManagementService.queryFormFields(formID, tenantID);
|
//获得当前子表单
|
Map<Integer,String> types1 = new HashMap<>();
|
for(FormFieldEntity form: formList){
|
if(Objects.equals(form.getParentsubFormNum(), rowNum) && !form.getFieldKey().equals("DATAROWNUM")){
|
types1.put(Integer.parseInt(Objects.toString(form.getColumnOrderNum(),"0")),form.getFieldtype());
|
}
|
}
|
Set<Integer> types2 = types1.keySet();
|
List<Integer> types = new ArrayList<>();
|
types2.forEach(o -> types.add(o));
|
List<List<String>> lists = new ArrayList<>();
|
|
for(int c=0; c< sheet.getColumns(); c++){
|
String title = sheet.getCell(c, 0).getContents();
|
if("".equals(title)|| title == null){
|
continue;
|
}
|
Integer itemId = this.getItemId(JSONTool.toObj(JSONTool.toJson(formList.get(0)),Map.class).get(FIELDSET),title);
|
List<String> list = new ArrayList<>();
|
row:
|
{
|
for (int r = 1; r < sheet.getRows(); r++) {
|
if (c > types.size() - 1) {
|
continue;
|
}
|
//验证是否必填
|
if (this.isMustCheck(formID, tenantID, itemId)) {
|
String v = sheet.getCell(c, r).getContents();
|
if ("".equals(v) || v == null) {
|
break row;
|
}
|
}
|
if (types1.get(itemId).equals("number")) {
|
if (!this.isNumeric(sheet.getCell(c, r).getContents())) {
|
break row;
|
}
|
list.add(sheet.getCell(c, r).getContents());
|
} else if (types1.get(itemId).equals("calendar")) {
|
if (!this.isValidDate(sheet.getCell(c, r).getContents())) {
|
break row;
|
}
|
list.add(YEAR + sheet.getCell(c, r).getContents());
|
//获取excel的下拉列表和树型的值
|
} else if (types1.get(itemId).equals("dropdownlist") || types1.get(itemId).equals("tree")) {
|
String value = sheet.getCell(c, r).getContents();
|
//调用获取Code 的方法
|
list.add(getCode(formList, value, itemId, types1.get(itemId), tenantID));
|
} else {
|
|
list.add(sheet.getCell(c, r).getContents());
|
}
|
}
|
}
|
lists.add(list);
|
}
|
this.masterCatch.clear();
|
return lists;
|
}
|
|
//验证控件属性是否必填 返回是否必填
|
public boolean isMustCheck(String formID, String tenantID, Integer columnOrderNum){
|
List<FieldPropertyEntity> fieldPropertys= dataManagementMapper.queryFormFieldProperty(formID, tenantID, columnOrderNum)
|
.stream().
|
filter(formField ->"mustcheck".equals(formField.getProperty()))
|
.collect(Collectors.toList());
|
if(Objects.isNull(fieldPropertys)){
|
return true;
|
}else{
|
return "true".equals(fieldPropertys.get(0).getValue()) ? true : false;
|
}
|
}
|
|
private String getDATAROWNUM() {
|
return DATAROWNUM;
|
}
|
|
/**
|
* 主数据value转code
|
*/
|
@SuppressWarnings("unchecked")
|
public String getCode(List<FormFieldEntity> formList,String value,Integer number,String fieldType,String tenantId) throws Exception{
|
List<CodeAndValueBean> master = this.masterCatch.get(number);
|
|
if(master!= null){
|
return getValue(value,master);
|
}
|
//取出表单控件中的主数据
|
String d = formList.get(0).getFieldset();
|
Map<String,Object> map = JSONTool.toObj(d,Map.class);
|
Map<String,Object> map1 = JSONTool.toObj(JSONTool.toJson(map.get("itemId"+"_"+number)),Map.class);
|
|
Map<String,Object> map2 = JSONTool.toObj(JSONTool.toJson(map1.get(TAGATTRIBUTE)),Map.class);
|
String code = Objects.toString(map2.get("masterData"),null);
|
//查询费用云主数据
|
String datasourceType = Objects.toString(map2.get("datasourcetype"));
|
if(Objects.equals(datasourceType,"masterdata")){
|
System.out.println("进入主数据转换");
|
JSONObject jsonObj = JSONObject.fromObject(code);
|
String defindCode = null;
|
String eleCode = null;
|
if (jsonObj.has("defindCode")) {
|
defindCode = jsonObj.getString("defindCode");
|
}
|
if (jsonObj.has("eleCode")) {
|
eleCode = jsonObj.getString("eleCode");
|
}
|
|
if (defindCode != null && eleCode != null) {
|
String eleName = null;
|
if (jsonObj.has(ConstMap.ELENAME)) {
|
eleName = jsonObj.getString(ConstMap.ELENAME);
|
}
|
String parentCode = null;
|
|
if (jsonObj.has("parentCode")) {
|
parentCode = jsonObj.getString("parentCode");
|
}
|
|
//筛选主数据
|
MasterValue MasterValue = new MasterValue();
|
MasterValue.setTenantID(tenantId);
|
MasterValue.setDefineCode(defindCode);
|
MasterValue.setELE_CODE(eleCode);
|
MasterValue.setParentCode(parentCode);
|
MasterValue.setEleName(eleName);
|
System.out.println("主数据参数:" + JSONTool.toJson(MasterValue));
|
|
List<CodeAndValueBean> result1 = this.masterClient.queryClientMasterValues(MasterValue);
|
masterCatch.put(number, result1);
|
System.out.println("Value值" + ":" + value);
|
return getValue(value, result1);
|
}
|
}else if(Objects.equals(datasourceType,"custom")){
|
System.out.println("进入自定义转换");
|
List<Map> customMap = JSONTool.toList(JSONTool.toJson(map2.get("custom")),Map.class);
|
List<CodeAndValueBean> res = new ArrayList<>();
|
customMap.stream().forEach(o->res.add(new CodeAndValueBean(Objects.toString(o.get("code")),Objects.toString(o.get("itemtext")))));
|
masterCatch.put(number, res);
|
return getValue(value, res);
|
}
|
|
return null;
|
}
|
|
|
|
|
public String getValue(String name,List<CodeAndValueBean> result){
|
for(CodeAndValueBean con : result){
|
if(name.equals(con.getValue())){
|
System.out.println("转换后code:"+con.getCode());
|
return con.getCode();
|
}
|
}
|
return "";
|
}
|
/**
|
* 导入子表单模板
|
* @return
|
* @throws IOException
|
* @throws WriteException
|
*/
|
public String expSonExcel(String data,String formID, String tenantID,String number, HttpServletRequest request, HttpServletResponse response) throws IOException, WriteException{
|
//最终表头字段
|
Map<String,Object> map = new HashMap<>();
|
OutputStream out = response.getOutputStream();// 取得输出流
|
response.reset();// 清空输出流
|
response.setHeader("Access-Control-Allow-Origin", "*"); //跨域
|
response.setHeader("content-disposition", "attachment;filename=" + new SimpleDateFormat("yyyyHHddhhmmss").format(new Date()) + ".xls");
|
response.setContentType("application/octet-stream");// 指明response的返回对象是文件流,通知浏览器下载文件而不是打开
|
WritableWorkbook workbook = Workbook.createWorkbook(out); //生成于response输出流
|
//创建sheet页(工作表)
|
WritableSheet sheet = workbook.createSheet("sheet1", 0); //页名，页码
|
WritableFont wfont = new WritableFont(WritableFont.createFont("楷书"), 12);
|
//定义样式，在该实例中可以定义字体，背景颜色，位置等
|
WritableCellFormat format = new WritableCellFormat(wfont);
|
//查询表单字段
|
List<String> list = JSONTool.toList(data, String.class);
|
//单元格
|
Label label = null;
|
Integer i = 0;
|
for(String in :list){
|
label = new Label(i, 0,in);
|
sheet.addCell(label);
|
i++;
|
};
|
workbook.write();
|
workbook.close();
|
|
out.flush();
|
out.close();
|
|
return null;
|
}
|
|
@Override
|
public String newImpExcel(MultipartFile file, String formID, String tenantID, String userName, IOType flag, HttpServletRequest request, HttpServletResponse response) throws Exception {
|
return null;
|
}
|
|
/**
|
* 通过title获取相应得 item_id
|
*
|
*/
|
@SuppressWarnings("unchecked")
|
public Integer getItemId(Object fieldSet,String title){
|
Map<String,Object> map = JSONTool.toObj(fieldSet.toString(),Map.class);
|
for(String o :map.keySet()){
|
Map<String,Object> m = JSONTool.toObj(JSONTool.toJson(map.get(o)),Map.class);
|
Map<String,String> m1 = JSONTool.toObj(JSONTool.toJson(m.get(TAGATTRIBUTE)),Map.class);
|
if(title.equals(m1.get("title"))){
|
return Integer.parseInt(Objects.toString(m.get("columnOrderNum"),"0"));
|
}
|
};
|
return 0;
|
}
|
|
|
|
/**
|
* 自定义属性code转value
|
*/
|
public String getCoustCode(List<FormFieldEntity> formList,String value,Integer number,String fieldType,String tenantId) throws Exception{
|
List<CodeAndValueBean> master = this.masterCatch.get(number);
|
|
if(master!= null){
|
return getValue(value,master);
|
}
|
//取出表单控件中的主数据
|
String d = formList.get(0).getFieldset();
|
Map<String,Object> map = JSONTool.toObj(d,Map.class);
|
Map<String,Object> map1 = JSONTool.toObj(JSONTool.toJson(map.get("itemId"+"_"+number)),Map.class);
|
|
Map<String,Object> map2 = JSONTool.toObj(JSONTool.toJson(map1.get(TAGATTRIBUTE)),Map.class);
|
|
return null;
|
}
|
|
Map<String,List<String>> subList = new HashMap<>();
|
/**
|
* 取出需要导出模板得字段
|
* @return
|
*/
|
public void getModelData(Map<String,Object> map ,DataMain dataMain){
|
System.out.println("参数:"+ JSONTool.toJson(dataMain));
|
List<String> mainList = new ArrayList<>();
|
Map<String,String> subName = new HashMap<>();
|
map.keySet().stream().forEach(o->{
|
Map<String,Object> item = JSONTool.toObj(JSONTool.toJson(map.get(o)),Map.class);
|
String tagType = Objects.toString(item.get("tag_Type"));
|
Map<String,Object> attr = JSONTool.toObj(JSONTool.toJson(item.get(TAGATTRIBUTE)),Map.class);
|
String title = Objects.toString(attr.get("title"));
|
String parentsubFormNum = Objects.toString(item.get("parentsubFormNum"),"-1");
|
if(!Objects.equals(tagType,"mytext")) {
|
if (Objects.equals("0", parentsubFormNum)
|
&& !Objects.equals(tagType, "subform")) {
|
System.out.println("-------->主表控件:" + title);
|
mainList.add(title);
|
} else if (!Objects.equals("0", parentsubFormNum)) {
|
System.out.println("-------->子表控件:" + title);
|
List<String> li = dataMain.getSubList().get(parentsubFormNum);
|
li.add(title);
|
dataMain.getSubList().put(parentsubFormNum, li);
|
} else if (Objects.equals(tagType,"subform")) {
|
System.out.println("-------->子表单:" + title);
|
String column = Objects.toString(item.get("columnOrderNum"), "-1");
|
subName.put(column, title);
|
}
|
}
|
});
|
dataMain.setMain(mainList);
|
//转换子表单别名
|
System.out.println("最后数据:"+ JSONTool.toJson(dataMain));
|
Map<String,List<String>> subL = dataMain.getSubList();
|
Map<String,List<String>> newSub = new HashMap<>();
|
System.out.println("所有子表单:"+ JSONTool.toJson(subName));
|
subL.keySet().stream()
|
.forEach(o->
|
newSub.put(subName.get(o),dataMain.getSubList().get(o))
|
);
|
dataMain.setSubList(newSub);
|
}
|
|
//获取cookie
|
public Map<String,Object> copyCookie(){
|
Map<String, Object> cookie = new HashMap<>();
|
InitParamInterceptor.COOKIE_KEY.entrySet().stream()
|
.filter(cookieKey->{
|
return StringUtils.isNoneBlank(Objects.toString(ThreadData.get(cookieKey.getValue()), ""));
|
})
|
.forEach(cookieKey->{
|
log.debug("当前添加:{},{}", cookieKey.getKey(),ThreadData.get(cookieKey.getValue()));
|
cookie.put(cookieKey.getKey(), ThreadData.get(cookieKey.getValue()));
|
});
|
return cookie;
|
}
|
|
|
|
//导出模板字段
|
@Data
|
class DataMain{
|
//主表字段
|
private List<String> main = new ArrayList<>();
|
//字表字段
|
private Map<String,List<String>> subList = new HashMap<>();
|
}
|
}
|
