package cn.autoform.web.service.datamanagement;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.Objects;
|
import java.util.concurrent.TimeoutException;
|
import java.util.stream.Collectors;
|
|
import org.apache.ibatis.annotations.Param;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.ui.ModelMap;
|
import org.springframework.web.bind.annotation.RequestBody;
|
|
import com.alibaba.fastjson.TypeReference;
|
|
import cn.autoform.bean.BudgetData;
|
import cn.autoform.bean.BudgetTitle;
|
import cn.autoform.bean.FormSolidiFication;
|
|
import cn.autoform.bean.ProcessBudget;
|
import cn.autoform.bean.ReleData;
|
import cn.autoform.bean.TableName;
|
import cn.autoform.bean.form.AssociatedFormData;
|
import cn.autoform.bean.form.CpnType;
|
import cn.autoform.bean.form.JoinFormData;
|
import cn.autoform.bean.form.RequestFormBase;
|
import cn.autoform.bean.page.PageResult;
|
import cn.autoform.db.entity.FieldPropertyEntity;
|
import cn.autoform.db.entity.FormDataMangerEntity;
|
import cn.autoform.db.entity.FormFieldEntity;
|
import cn.autoform.db.exten.ServicesFormData;
|
import cn.autoform.db.exten.SelectForm;
|
import cn.autoform.db.exten.SubForm;
|
import cn.autoform.factory.FormFactory;
|
import cn.autoform.fw.exception.FormClientException;
|
import cn.autoform.fw.exception.RestResult;
|
import cn.autoform.fw.utility.ConstMap;
|
import cn.autoform.fw.utility.FormDataUtil;
|
import cn.autoform.util.tool.JSONTool;
|
import cn.autoform.util.tool.RequestContext;
|
import cn.autoform.web.client.FormClient;
|
import cn.autoform.web.client.util.auto.OnlyCharacters;
|
import cn.autoform.web.client.util.auto.ParamFactory;
|
import cn.autoform.web.mapper.datamanagement.DataManagementMapper;
|
import net.sf.json.JSONArray;
|
import net.sf.json.JSONObject;
|
|
@Service
|
public class DataManagementService {
|
|
private static final Map<String, String> DBTYPE = new HashMap<>();
|
|
static {
|
// 单行文本
|
DBTYPE.put("text", ConstMap.VARCHAR150);
|
// 单选按钮
|
DBTYPE.put("radio", ConstMap.VARCHAR50);
|
// 下拉列表框
|
DBTYPE.put("dropdownlist", ConstMap.LONGTEXT);
|
// 日期控件
|
DBTYPE.put("calendar", ConstMap.VARCHAR30);
|
// 复选框
|
DBTYPE.put("checkbox", ConstMap.LONGTEXT);
|
// 子表单
|
DBTYPE.put("subform", ConstMap.VARCHAR30);
|
// 数字
|
DBTYPE.put("number", ConstMap.VARCHAR30);
|
// 多行文本
|
DBTYPE.put("textarea", ConstMap.LONGTEXT);
|
// HTML
|
DBTYPE.put("htmlediter", ConstMap.LONGTEXT);
|
// 条码
|
DBTYPE.put("barcode", ConstMap.VARCHAR30);
|
// 二维码
|
DBTYPE.put("qrcode", ConstMap.VARCHAR200);
|
// 图片
|
DBTYPE.put("image", ConstMap.LONGTEXT);
|
// 文件上传
|
DBTYPE.put("fileupload", ConstMap.LONGTEXT);
|
// 数型控件
|
DBTYPE.put("tree", ConstMap.LONGTEXT);
|
// 金额组件
|
DBTYPE.put("amount", ConstMap.LONGTEXT);
|
}
|
|
@Autowired
|
private DataManagementMapper dataManagementMapper = null;
|
|
@Autowired
|
private FormClient formClient = null;
|
|
// @Autowired
|
// private FormFactory formFactory;
|
|
public List<FormFieldEntity> queryFormFields(String formID, String tenantID) {
|
return dataManagementMapper.queryFormFields(formID, tenantID);
|
}
|
|
public List<FormFieldEntity> getFormFieldMain(String formID, String tenantID) {
|
return dataManagementMapper.getFormFieldMain(formID, tenantID);
|
}
|
|
|
public Map<String, FieldPropertyEntity> queryFormFieldsAboutData(String formID, String tenantID,
|
Integer columnOrderNum) {
|
return dataManagementMapper.queryFormFieldsAboutData(formID, tenantID, columnOrderNum);
|
}
|
|
public Map<String, FormFieldEntity> queryFormFields2(String formID, String tenantID) {
|
Map<String, FormFieldEntity> info = dataManagementMapper.queryFormFields2(formID, tenantID);
|
// 过滤选项卡。
|
info.entrySet().stream().forEach(entry->{
|
if(Objects.equals(entry.getValue().getFieldtype(), CpnType.subform.toString())) {
|
entry.getValue().setParentsubFormNum(0);
|
}
|
});
|
return info;
|
}
|
|
public Map<Integer, FormDataMangerEntity> queryFormdataManagers2(String formID, String tenantID) {
|
return dataManagementMapper.queryFormdataManagers2(formID, tenantID);
|
}
|
|
public void excuteFormDataInsert(String excuteSql) {
|
dataManagementMapper.excuteFormDataInsert(excuteSql);
|
}
|
|
public FormDataMangerEntity queryFormdataManagersFor(String formID, String tenantID) {
|
return dataManagementMapper.queryFormdataManagersFor(formID, tenantID);
|
}
|
|
public void updateFormdataManagersFor(FormDataMangerEntity entity) {
|
dataManagementMapper.updateFormdataManagersFor(entity);
|
}
|
|
//根据formID查询基本表的表名
|
public String getBaseTableName(String formID, String tenantID){
|
return dataManagementMapper.getBaseTableName(formID, tenantID);
|
}
|
|
public List<String> queryCloudMainValue(String excuteSql){
|
return dataManagementMapper.queryCloudMainValue(excuteSql);
|
}
|
|
public List<String> queryServicesMainValue(String sql){
|
return null;
|
}
|
|
//查询控件属性
|
public List<FieldPropertyEntity> queryFormFieldProperty(String formID, String tenantID, Integer columnOrderNum){
|
return dataManagementMapper.queryFormFieldProperty(formID, tenantID, columnOrderNum);
|
}
|
|
public List<FieldPropertyEntity> queryFormFieldProperty(String formID, String tenantID, String field){
|
return dataManagementMapper.queryFormFieldPropertyByField(formID, tenantID, field);
|
}
|
|
//查询表中下拉框，等多选主数据相关控件
|
public List<FormFieldEntity> queryFormMainField(String formID, String tenantID){
|
return dataManagementMapper.queryFormMainField(formID, tenantID);
|
}
|
|
public List<FormFieldEntity> queryFormSubField(String formID, String tenantID){
|
return dataManagementMapper.queryFormSubField(formID, tenantID);
|
}
|
|
public List<FormFieldEntity> queryFormAllField(String formID, String tenantID){
|
return dataManagementMapper.queryFormAllField(formID, tenantID);
|
}
|
public SelectForm queryFormDataList(String formID, String tenantID) {
|
|
SelectForm mainForm = new SelectForm();
|
mainForm.setTenantID(tenantID);
|
|
// 取得表单数据管理
|
List<FormDataMangerEntity> formDataMangerList = dataManagementMapper.queryFormdataMangers(formID, tenantID);
|
if (formDataMangerList == null || formDataMangerList.isEmpty()) {
|
return null;
|
}
|
|
List<FormFieldEntity> formFieldsList = dataManagementMapper.queryFormFields3(formID, tenantID);
|
|
StringBuilder sqlSelectMain = new StringBuilder(
|
"/*!mycat:sql= select tenantid from FORMDATAMANAGER WHERE TENANTID = '%s' AND FROMID = '%s' */ SELECT %s FROM ");
|
for (FormDataMangerEntity formDataMangerEntity : formDataMangerList) {
|
if (formDataMangerEntity.getFormdataNum() == 0) {
|
sqlSelectMain.append(formDataMangerEntity.getFormdatatable());
|
mainForm.setFormName("_" + tenantID + "_" + formDataMangerEntity.getFormdatatable().substring(8));
|
}
|
}
|
|
StringBuilder sqlSelcetFields = new StringBuilder();
|
sqlSelcetFields.append(" DATAROWNUM,");
|
|
Map<String,Object> fields = new HashMap<>();
|
|
for (FormFieldEntity formFieldEntity : formFieldsList) {
|
if (formFieldEntity.getParentsubFormNum() == 0
|
&& DBTYPE.containsKey(formFieldEntity.getFieldtype())) {
|
if (!ConstMap.SUBFORM.equals(formFieldEntity.getFieldtype())) {
|
String fieldName = ConstMap.FIELD + formFieldEntity.getColumnOrderNum();
|
sqlSelcetFields.append(" IFNULL(");
|
sqlSelcetFields.append(fieldName);
|
sqlSelcetFields.append(" , '') AS '");
|
sqlSelcetFields.append(fieldName);
|
sqlSelcetFields.append("',");
|
fields.put(fieldName,fieldName);
|
} else {
|
sqlSelcetFields.append(formFieldEntity.getColumnOrderNum());
|
sqlSelcetFields.append(" AS");
|
sqlSelcetFields.append(" FIELD");
|
sqlSelcetFields.append(formFieldEntity.getColumnOrderNum());
|
sqlSelcetFields.append(",");
|
//fields.put(formFieldEntity.getColumnOrderNum().toString(), " FIELD" + formFieldEntity.getColumnOrderNum());
|
}
|
}
|
}
|
sqlSelcetFields.deleteCharAt(sqlSelcetFields.length() - 1);
|
|
StringBuilder whereSql = new StringBuilder(" WHERE ");
|
whereSql.append(" deleteFlg = '0'");
|
whereSql.append(" AND TENANTID = '");
|
whereSql.append(tenantID);
|
whereSql.append("'");
|
|
sqlSelectMain.append(whereSql);
|
|
mainForm.setFields(fields);
|
return mainForm;
|
//dataManagementMapper.queryFormdatas(executeSql);
|
}
|
|
public Map<String, Object> queryFormDataList(String formID, String tenantID, Integer datarowNum) {
|
SelectForm selectForm = new SelectForm();
|
selectForm.setDataRowNum(datarowNum);
|
selectForm.setTenantID(tenantID);
|
|
// 取得表单数据管理
|
List<FormDataMangerEntity> formDataMangerList = dataManagementMapper.queryFormdataMangers(formID, tenantID);
|
|
List<FormFieldEntity> formFieldsList = dataManagementMapper.queryFormFields3(formID, tenantID);
|
|
StringBuilder sqlSelectMain = new StringBuilder(
|
"/*!mycat:sql= select tenantid from FORMDATAMANAGER WHERE TENANTID = '%s' AND FROMID = '%s' */ SELECT %s FROM ");
|
for (FormDataMangerEntity formDataMangerEntity : formDataMangerList) {
|
if (formDataMangerEntity.getFormdataNum() == 0) {
|
sqlSelectMain.append(formDataMangerEntity.getFormdatatable());
|
selectForm.setFormName("_" + tenantID + "_" + formDataMangerEntity.getFormdatatable().substring(8));
|
}
|
}
|
|
Map<String,Object> selectMap = new HashMap<>();
|
|
StringBuilder sqlSelcetFields = new StringBuilder();
|
sqlSelcetFields.append(" DATAROWNUM,");
|
for (FormFieldEntity formFieldEntity : formFieldsList) {
|
if (formFieldEntity.getParentsubFormNum() == 0
|
&& DBTYPE.containsKey(formFieldEntity.getFieldtype())) {
|
if (!ConstMap.SUBFORM.equals(formFieldEntity.getFieldtype())) {
|
String fieldName = ConstMap.FIELD + formFieldEntity.getColumnOrderNum();
|
sqlSelcetFields.append(" IFNULL(");
|
sqlSelcetFields.append(fieldName);
|
sqlSelcetFields.append(" , '') AS ");
|
sqlSelcetFields.append(formFieldEntity.getFieldKey());
|
sqlSelcetFields.append(",");
|
selectMap.put(fieldName,formFieldEntity.getFieldKey());
|
} else {
|
sqlSelcetFields.append("'");
|
sqlSelcetFields.append(formFieldEntity.getFieldKey());
|
sqlSelcetFields.append("'");
|
sqlSelcetFields.append(" AS ");
|
sqlSelcetFields.append(ConstMap.FIELD + formFieldEntity.getColumnOrderNum());
|
sqlSelcetFields.append(",");
|
selectMap.put(String.format("'%s'", formFieldEntity.getFieldKey()), ConstMap.FIELD + formFieldEntity.getColumnOrderNum());
|
}
|
}
|
}
|
|
selectForm.setFields(selectMap);
|
// sqlSelcetFields.deleteCharAt(sqlSelcetFields.length() - 1);
|
//
|
// StringBuilder whereSql = new StringBuilder(" WHERE ");
|
// whereSql.append(" deleteFlg = '0'");
|
// whereSql.append(" AND TENANTID = '");
|
// whereSql.append(tenantID);
|
// whereSql.append("'");
|
//
|
// whereSql.append(" AND SUBDATAROWNUM = 0 AND ");
|
// whereSql.append(" DATAROWNUM = ");
|
// whereSql.append(datarowNum);
|
// sqlSelectMain.append(whereSql);
|
|
// String executeSql = String.format(sqlSelectMain.toString(), tenantID, formID, sqlSelcetFields.toString());
|
Map<String,Object> data = new HashMap<>();
|
// data.put("main", dataManagementMapper.queryFormdatas(executeSql).get(0));
|
data.put("selectForm", selectForm);
|
return data;
|
}
|
|
/**
|
* 删除表单数据
|
*
|
* @param formID 表单ID
|
* @param tenantID 租户ID
|
* @param datarowNum 数据行番
|
*/
|
public ServicesFormData removeFormData(String formID, String tenantID, JSONArray datarowNumArray) {
|
|
List<FormDataMangerEntity> formDataMangers = dataManagementMapper.queryFormdataMangers(formID, tenantID);
|
|
ServicesFormData formData = new ServicesFormData();
|
SubForm subForm = null;
|
|
List<SubForm> subFormList = new ArrayList<SubForm>();
|
for(int i= 0; i< formDataMangers.size(); i++) {
|
subForm = new SubForm();
|
if(i == 0) {
|
formData.setFormID("_" + tenantID + "_" + formDataMangers.get(i).getFormdatatable().substring(8));
|
}else{
|
subForm.setFormID("_" + tenantID + "_" + formDataMangers.get(i).getFormdatatable().substring(8));
|
subFormList.add(subForm);
|
}
|
formDataMangers.get(i).getFormdatatable();
|
}
|
formData.setSubFormList(subFormList);
|
|
StringBuilder updateSql = new StringBuilder();
|
|
updateSql.append(
|
"/*!mycat:sql= select tenantid from FORMDATAMANAGER WHERE TENANTID = '%s' AND FROMID = '%s' */ UPDATE ");
|
|
updateSql.append(" SET DELETEFLG = '1' WHERE ");
|
|
updateSql.append(" TENANTID = '%s' AND DATAROWNUM IN (");
|
|
for (Object dataRowNum : datarowNumArray) {
|
updateSql.append(dataRowNum);
|
updateSql.append(ConstMap.COMMA);
|
}
|
updateSql.deleteCharAt(updateSql.length() - 1);
|
|
updateSql.append(")");
|
|
|
return formData;
|
}
|
|
/**
|
* 删除表单数据
|
*
|
* @param sql
|
*/
|
public void removeFormData(String sql) {
|
dataManagementMapper.removeFormData(sql);
|
}
|
|
public void updateFormData(String updateSql) {
|
dataManagementMapper.updateFormData(updateSql);
|
}
|
|
public String getTitleProperty(String formID, String tenantID, Integer columnOrderNum){
|
List<FieldPropertyEntity> file = queryFormFieldProperty(formID, tenantID, columnOrderNum);
|
String field = null;
|
try{
|
field = file
|
.stream()
|
.filter(fieldP -> "title".equals(fieldP.getProperty()))
|
.collect(Collectors.toList())
|
.get(0)
|
.getValue();
|
|
|
}catch(Exception e){
|
return "";
|
}
|
return field;
|
}
|
|
public List<Map<String, Object>> querySubFormDataList(String formID, String tenantID, Integer formdataNum,
|
Integer datarowNum) {
|
|
SubForm subForm = new SubForm();
|
subForm.setDataRowNum(datarowNum);
|
subForm.setSubDataRowNum(datarowNum);
|
subForm.setFormDataNum(formdataNum);
|
|
// 取得表单数据管理
|
List<FormDataMangerEntity> formDataMangerList = dataManagementMapper.queryFormdataMangers1(formID, tenantID,
|
formdataNum);
|
|
if (formDataMangerList.isEmpty()) {
|
return null;
|
}
|
|
List<FormFieldEntity> formFieldsList = dataManagementMapper.queryFormFields3(formID, tenantID);
|
|
StringBuilder sqlSelectMain = new StringBuilder(
|
"/*!mycat:sql= select tenantid from FORMDATAMANAGER WHERE TENANTID = '%s' AND FROMID = '%s' */ SELECT %s FROM ");
|
for (FormDataMangerEntity formDataMangerEntity : formDataMangerList) {
|
if (formDataMangerEntity.getFormdataNum() == formdataNum) {
|
subForm.setFormName("formdata" + formDataMangerEntity.getFormdatatable().substring(8));
|
sqlSelectMain.append(formDataMangerEntity.getFormdatatable());
|
}
|
}
|
|
StringBuilder sqlSelcetFields = new StringBuilder();
|
sqlSelcetFields.append(" DATAROWNUM,");
|
|
Map<String,Object> fieldMap = new HashMap<>();
|
for (FormFieldEntity formFieldEntity : formFieldsList) {
|
if (formFieldEntity.getParentsubFormNum() == formdataNum
|
&& DBTYPE.containsKey(formFieldEntity.getFieldtype())) {
|
if (!ConstMap.SUBFORM.equals(formFieldEntity.getFieldtype())) {
|
String fieldName = ConstMap.FIELD + formFieldEntity.getColumnOrderNum();
|
sqlSelcetFields.append(" IFNULL(");
|
sqlSelcetFields.append(fieldName);
|
sqlSelcetFields.append(" , '') AS ");
|
sqlSelcetFields.append(formFieldEntity.getFieldKey());
|
sqlSelcetFields.append(",");
|
fieldMap.put(formFieldEntity.getFieldKey(), formFieldEntity.getFieldKey());
|
} else {
|
sqlSelcetFields.append(formFieldEntity.getColumnOrderNum());
|
sqlSelcetFields.append(" AS ");
|
sqlSelcetFields.append(formFieldEntity.getFieldKey());
|
sqlSelcetFields.append(",");
|
}
|
}
|
}
|
|
subForm.setFields(fieldMap);
|
|
sqlSelcetFields.deleteCharAt(sqlSelcetFields.length() - 1);
|
|
StringBuilder whereSql = new StringBuilder(" WHERE ");
|
|
whereSql.append(" deleteFlg = '0'");
|
whereSql.append(" AND DATAROWNUM = ");
|
whereSql.append(datarowNum);
|
whereSql.append(" AND TENANTID = '");
|
whereSql.append(tenantID);
|
whereSql.append("'");
|
|
// sqlSelectMain.append(sqlSelcetFields);
|
sqlSelectMain.append(whereSql);
|
|
List<Map<String, Object>> lis = new ArrayList<>();
|
lis.add(new ModelMap("subForm",subForm));
|
return lis;
|
}
|
|
public List<Map<String, Object>> queryCloudSubFormDataList(String formID, String tenantID, Integer formdataNum,
|
Integer datarowNum) {
|
|
// 取得表单数据管理
|
List<FormDataMangerEntity> formDataMangerList = dataManagementMapper.queryFormdataMangers1(formID, tenantID,
|
formdataNum);
|
|
if (formDataMangerList.isEmpty()) {
|
return null;
|
}
|
|
List<FormFieldEntity> formFieldsList = dataManagementMapper.queryFormFields3(formID, tenantID);
|
|
StringBuilder sqlSelectMain = new StringBuilder(
|
"/*!mycat:sql= select tenantid from FORMDATAMANAGER WHERE TENANTID = '%s' AND FROMID = '%s' */ SELECT %s FROM ");
|
for (FormDataMangerEntity formDataMangerEntity : formDataMangerList) {
|
if (formDataMangerEntity.getFormdataNum() == formdataNum) {
|
sqlSelectMain.append(formDataMangerEntity.getFormdatatable());
|
}
|
}
|
|
StringBuilder sqlSelcetFields = new StringBuilder();
|
sqlSelcetFields.append(" DATAROWNUM,");
|
for (FormFieldEntity formFieldEntity : formFieldsList) {
|
if (formFieldEntity.getParentsubFormNum() == formdataNum
|
&& DBTYPE.containsKey(formFieldEntity.getFieldtype())) {
|
if (!ConstMap.SUBFORM.equals(formFieldEntity.getFieldtype())) {
|
// String fieldName = ConstMap.FIELD + formFieldEntity.getColumnOrderNum();
|
sqlSelcetFields.append(" IFNULL(");
|
// sqlSelcetFields.append(fieldName);
|
sqlSelcetFields.append(formFieldEntity.getFieldKey());
|
sqlSelcetFields.append(" , '') AS '");
|
sqlSelcetFields.append(formFieldEntity.getFieldKey());
|
sqlSelcetFields.append("',");
|
} else {
|
sqlSelcetFields.append(formFieldEntity.getColumnOrderNum());
|
sqlSelcetFields.append(" AS '");
|
sqlSelcetFields.append(formFieldEntity.getFieldKey());
|
sqlSelcetFields.append("',");
|
}
|
}
|
}
|
sqlSelcetFields.deleteCharAt(sqlSelcetFields.length() - 1);
|
|
StringBuilder whereSql = new StringBuilder(" WHERE ");
|
|
whereSql.append(" deleteFlg = '0'");
|
whereSql.append(" AND PARENTDATAROWNUM = ");
|
whereSql.append(datarowNum);
|
whereSql.append(" AND TENANTID = '");
|
whereSql.append(tenantID);
|
whereSql.append("'");
|
|
sqlSelectMain.append(whereSql);
|
|
String executeSql = String.format(sqlSelectMain.toString(), tenantID, formID, sqlSelcetFields.toString());
|
|
return dataManagementMapper.queryFormdatas(executeSql);
|
}
|
|
public void updateFormFieldState(FormFieldEntity formFieldentity) {
|
dataManagementMapper.updateFormFieldState(formFieldentity);
|
}
|
|
public void updateMainFormFieldService(FormFieldEntity formFieldentity) {
|
dataManagementMapper.updateMainFormFieldService(formFieldentity);
|
}
|
|
public List<Map<String,Object>> queryCodeAutoAttr(String formID, String tenantID,String columnordernum){
|
return dataManagementMapper.queryCodeAutoAttr(formID, tenantID,columnordernum);
|
}
|
|
public List<Map<String,Object>> queryAutoAttr(String formID, String tenantID){
|
return dataManagementMapper.queryAutoAttr(formID, tenantID);
|
}
|
|
|
public Integer addFormStateData(Map<String,String> formState){
|
return dataManagementMapper.addFormStateData(formState);
|
}
|
|
/**
|
* 根据别名查询表单中对应控件属性
|
* @param formID
|
* @param tenantID
|
* @param fieldKey
|
* @return
|
*/
|
public FormFieldEntity queryFormFieldPropertyByFieldKey(String formID, String tenantID, String fieldKey){
|
return dataManagementMapper.queryFormFieldPropertyByFieldKey(formID, tenantID, fieldKey);
|
}
|
|
/**
|
* 得到自动生成number
|
* @param formID
|
* @param tenantID
|
* @param field
|
* @param dataRowNum
|
* @return
|
*/
|
public String getAutoNumber(String formID, String tenantID, String field ,Integer dataRowNum){
|
StringBuilder prfix = new StringBuilder();
|
Map<String ,String> param = new HashMap<>();
|
queryFormFieldProperty(formID, tenantID, field)
|
.stream().filter(formField -> "prefixs".equals(formField.getProperty())
|
|| "autoTypeNumber".equals(formField.getProperty())
|
||"autoTypePrefix".equals(formField.getProperty()))
|
.forEach(formField -> {
|
if("prefixs".equals(formField.getProperty())){
|
List<Map<String, Object>> prefixs = JSONTool.toObj(formField.getValue(),new TypeReference<List<Map<String, Object>>>(){});
|
prfix.append(prefixs.get(0).get("itemtext_1") + "$in{" + prefixs.get(0).get("itemtext_2") +"}");
|
}else{
|
param.put(formField.getProperty(), formField.getValue());
|
}
|
});
|
if(!param.isEmpty()){
|
prfix.append( param.get("autoTypePrefix")+ "$in{" + param.get("autoTypeNumber") +"}");
|
}
|
ParamFactory.setBegain(dataRowNum.toString());
|
return OnlyCharacters.getOnlyStr(prfix.toString());
|
}
|
|
/**
|
* 获得关联函数对应数据
|
* @param associatedFormData
|
* @return
|
* @throws TimeoutException
|
* @throws FormClientException
|
*/
|
public Map<String,Object> getAssociateData(BudgetData budgetData) throws TimeoutException, FormClientException{
|
// associatedFormData.setPageNum(RequestContext.getPageNum());
|
// associatedFormData.setPageSize(RequestContext.getPageSize());
|
return this.formClient.getAssociateData(budgetData);
|
}
|
/**
|
* 获得关联函数标题
|
* @param key
|
* @return
|
* @throws TimeoutException
|
* @throws FormClientException
|
*/
|
public List<BudgetTitle> getAssociateTitle(Map<String, Object> key) throws TimeoutException, FormClientException{
|
return this.formClient.getAssociateTitle(key);
|
}
|
|
/**
|
* 获得表单上下文
|
* @param formID
|
* @param tenantID
|
* @return
|
*/
|
public Map<String,Object> getFormContext(String formID, String tenantID){
|
return this.dataManagementMapper.getFormContext(formID, tenantID);
|
}
|
|
/**
|
* 获得表单数据上下文
|
* @param formID
|
* @param tenantID
|
* @return
|
*/
|
public Map<String,Object> getFormDataContext(RequestFormBase requestFormBase){
|
String formName = FormDataUtil.getFormTableName(requestFormBase.getTenantID(), requestFormBase.getFormID());
|
return this.dataManagementMapper.getFormDataContext(requestFormBase.getFormID(),requestFormBase.getTenantID()
|
,requestFormBase.getDatarowNum(), formName);
|
}
|
|
public Object getBudget(ProcessBudget processBudget) throws TimeoutException, FormClientException{
|
return this.formClient.getBudget(processBudget);
|
}
|
|
/**
|
* 查询控件别名
|
* @param formID
|
* @param tenantID
|
* @return
|
*/
|
public List<Map<String,Object>> queryFormFiled(String formID,String tenantID){
|
return dataManagementMapper.queryFormFiled(formID, tenantID);
|
}
|
|
/**
|
* 表单固化准备参数
|
* @throws TimeoutException
|
*/
|
public FormSolidiFication formSolidiFication(String formId,Integer dataRowNum,String tenantId) throws TimeoutException{
|
List<FormDataMangerEntity> formDataMangerList = dataManagementMapper.queryFormdataMangers(formId, tenantId);
|
FormSolidiFication fs = new FormSolidiFication();
|
fs.setFormId(formId);
|
fs.setTenantId(tenantId);
|
fs.setDataRowNum(dataRowNum);
|
for(FormDataMangerEntity f: formDataMangerList){
|
if(f.getFormdataNum()!=0){
|
fs.getTableList().add(new TableName(f.getFormdataNum(),f.getFormdatatable()));
|
}
|
|
}
|
return fs;
|
|
}
|
}
|
