com.opendynamic.ff.service.impl.oracle.FfNodeVarServiceImpl Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of freeflow Show documentation
Show all versions of freeflow Show documentation
a flexible workflow engine
package com.opendynamic.ff.service.impl.oracle;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.ObjectOutputStream;
import java.io.Serializable;
import java.sql.Types;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.jdbc.core.support.SqlLobValue;
import org.springframework.jdbc.support.lob.DefaultLobHandler;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import com.opendynamic.OdSqlCriteria;
import com.opendynamic.OdUtils;
import com.opendynamic.ff.service.FfNodeService;
import com.opendynamic.ff.service.FfNodeVarService;
import com.opendynamic.ff.service.FfOperationService;
import com.opendynamic.ff.service.FfService;
@Service
@Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class)
public class FfNodeVarServiceImpl implements FfNodeVarService {
@Autowired
private FfNodeService ffNodeService;
@Autowired
private FfOperationService ffOperationService;
@Autowired
private JdbcTemplate ffJdbcTemplate;
@Override
public Map loadNodeVar(String NODE_VAR_ID_) {
String sql = "select * from FFV_NODE_VAR where NODE_VAR_ID_ = ?";
List> result = ffJdbcTemplate.queryForList(sql, NODE_VAR_ID_);
if (result.size() == 1) {
return result.get(0);
}
else {
return null;
}
}
@Override
public List> selectNodeVar(String NODE_VAR_ID_, String NODE_ID_, List VAR_TYPE_LIST, String VAR_NAME_, Boolean recursive, Integer page, Integer limit) {
OdSqlCriteria odSqlCriteria = buildSqlCriteriaNodeVar(false, NODE_VAR_ID_, NODE_ID_, VAR_TYPE_LIST, VAR_NAME_, recursive);// 根据查询条件组装查询SQL语句
String sql = odSqlCriteria.getSql();
Map paramMap = odSqlCriteria.getParamMap();
if (page != null && limit != null && limit > 0) {// 分页
int start = (page - 1) * limit + 1;
int end = page * limit;
sql = "select * from (select FULLTABLE.*, ROWNUM RN from (" + sql + ") FULLTABLE where ROWNUM <= " + end + ") where RN >= " + start;
}
NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(ffJdbcTemplate);
return namedParameterJdbcTemplate.queryForList(sql, paramMap);
}
@Override
public int countNodeVar(String NODE_VAR_ID_, String NODE_ID_, List VAR_TYPE_LIST, String VAR_NAME_, Boolean recursive) {
OdSqlCriteria odSqlCriteria = buildSqlCriteriaNodeVar(true, NODE_VAR_ID_, NODE_ID_, VAR_TYPE_LIST, VAR_NAME_, recursive);// 根据查询条件组装总数查询SQL语句
String sql = odSqlCriteria.getSql();
Map paramMap = odSqlCriteria.getParamMap();
NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(ffJdbcTemplate);
return namedParameterJdbcTemplate.queryForObject(sql, paramMap, Integer.class);
}
private OdSqlCriteria buildSqlCriteriaNodeVar(boolean count, String NODE_VAR_ID_, String NODE_ID_, List VAR_TYPE_LIST, String VAR_NAME_, Boolean recursive) {// 组装查询SQL语句
String sql;
Map paramMap = new HashMap();
sql = "select * from FFV_PROC_VAR where SUB_PROC_ID_ in (:SUB_PROC_ID_LIST)";// 查询相关流程范围的流程变量，
if (count) {
sql = "select count(*) from FFV_NODE_VAR where 1 = 1";
}
else {
sql = "select * from FFV_NODE_VAR where 1 = 1";
}
if (StringUtils.isNotEmpty(NODE_VAR_ID_)) {
sql += " and NODE_VAR_ID_ = :NODE_VAR_ID_";
paramMap.put("NODE_VAR_ID_", NODE_VAR_ID_);
}
List NODE_ID_LIST = null;
if (StringUtils.isNotEmpty(NODE_ID_)) {
if (recursive != null && recursive.equals(true)) {
sql += " and NODE_ID_ in (:NODE_ID_LIST)";
List> nodeList = ffNodeService.selectParentNode(NODE_ID_, null, null, null, null, true, recursive);
NODE_ID_LIST = OdUtils.collect(nodeList, "NODE_ID_", String.class);
paramMap.put("NODE_ID_LIST", NODE_ID_LIST);
}
else {
sql += " and NODE_ID_ = :NODE_ID_";
paramMap.put("NODE_ID_", NODE_ID_);
}
}
if (VAR_TYPE_LIST != null && VAR_TYPE_LIST.size() > 0) {
sql += " and VAR_TYPE_ in (:VAR_TYPE_LIST)";
paramMap.put("VAR_TYPE_LIST", VAR_TYPE_LIST);
}
if (StringUtils.isNotEmpty(VAR_NAME_)) {
sql += " and VAR_NAME_ like '%' || :VAR_NAME_ || '%'";
paramMap.put("VAR_NAME_", VAR_NAME_);
}
if (recursive != null && recursive.equals(true)) {
sql += " order by DECODE(NODE_ID_,";// 按流程范围从小到大排序
for (int i = 0; i < NODE_ID_LIST.size(); i++) {
sql += " '" + NODE_ID_LIST.get(i) + "', " + i + ",";
}
sql += NODE_ID_LIST.size() + ")";
}
return new OdSqlCriteria(sql, paramMap);
}
@Override
public List> selectNodeVarByIdList(List NODE_VAR_ID_LIST) {
if (NODE_VAR_ID_LIST == null || NODE_VAR_ID_LIST.size() == 0) {
return new ArrayList<>();
}
StringBuilder sql = new StringBuilder(NODE_VAR_ID_LIST.size() * 50 + 200);
Map paramMap = new HashMap();
sql.append("select * from FFV_NODE_VAR where NODE_VAR_ID_ in (:NODE_VAR_ID_LIST)");
paramMap.put("NODE_VAR_ID_LIST", NODE_VAR_ID_LIST);
sql.append(" order by DECODE(NODE_VAR_ID_,");// 按主键列表顺序排序
for (int i = 0; i < NODE_VAR_ID_LIST.size(); i++) {
sql.append(" '").append(NODE_VAR_ID_LIST.get(i)).append("', ").append(i);
if (i < NODE_VAR_ID_LIST.size() - 1) {
sql.append(",");
}
else {
sql.append(")");
}
}
NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(ffJdbcTemplate);
return namedParameterJdbcTemplate.queryForList(sql.toString(), paramMap);
}
@Override
public int insertNodeVar(String NODE_VAR_ID_, String NODE_ID_, String VAR_TYPE_, String VAR_NAME_, String VALUE_, Serializable OBJ_, Date CREATION_DATE_) {
int count = 0;
if (!FfService.VAR_TYPE_OBJECT.equals(VAR_TYPE_)) {// String
String sql = "insert into FF_NODE_VAR (NODE_VAR_ID_, NODE_ID_, VAR_TYPE_, VAR_NAME_, VALUE_, CREATION_DATE_) values (?, ?, ?, ?, ?, ?)";
count = ffJdbcTemplate.update(sql, NODE_VAR_ID_, NODE_ID_, VAR_TYPE_, VAR_NAME_, VALUE_, CREATION_DATE_);
}
else {// object
ObjectOutputStream objectOutputStream = null;
try {
ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
objectOutputStream = new ObjectOutputStream(byteArrayOutputStream);
if (OBJ_ != null) {
objectOutputStream.writeObject(OBJ_);
}
ByteArrayInputStream inputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
String sql = "insert into FF_NODE_VAR (NODE_VAR_ID_, NODE_ID_, VAR_TYPE_, VAR_NAME_, OBJ_, CREATION_DATE_) values (?, ?, ?, ?, ?, ?)";
count = ffJdbcTemplate.update(sql, new Object[] { NODE_VAR_ID_, NODE_ID_, VAR_TYPE_, VAR_NAME_, new SqlLobValue(inputStream, byteArrayOutputStream.size(), new DefaultLobHandler()), CREATION_DATE_ }, new int[] { Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.BLOB, Types.TIMESTAMP });
}
catch (Exception e) {
throw new RuntimeException(e);
}
finally {
try {
objectOutputStream.close();
}
catch (Exception e) {
}
}
}
ffOperationService.insertNodeVarOp(OdUtils.getUuid(), NODE_VAR_ID_, FfOperationService.OPERATION_TYPE_INSERT);
return count;
}
@Override
public int updateNodeVar(String NODE_VAR_ID_, String VAR_TYPE_, String VAR_NAME_, String VALUE_, Serializable OBJ_) {
int count = 0;
ffOperationService.insertNodeVarOp(OdUtils.getUuid(), NODE_VAR_ID_, FfOperationService.OPERATION_TYPE_UPDATE);
if (!FfService.VAR_TYPE_OBJECT.equals(VAR_TYPE_)) {// String
String sql = "update FF_NODE_VAR set VAR_TYPE_ = ?, VAR_NAME_ = ?, VALUE_ = ?, OBJ_ = null where NODE_VAR_ID_ = ?";
count = ffJdbcTemplate.update(sql, VAR_TYPE_, VAR_NAME_, VALUE_, NODE_VAR_ID_);
}
else {// object
ObjectOutputStream objectOutputStream = null;
try {
ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
objectOutputStream = new ObjectOutputStream(byteArrayOutputStream);
if (OBJ_ != null) {
objectOutputStream.writeObject(OBJ_);
}
ByteArrayInputStream inputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
String sql = "update FF_NODE_VAR set VAR_TYPE_ = ?, VAR_NAME_ = ?, VALUE_ = null, OBJ_ = ? where NODE_VAR_ID_ = ?";
count = ffJdbcTemplate.update(sql, new Object[] { VAR_TYPE_, VAR_NAME_, new SqlLobValue(inputStream, byteArrayOutputStream.size(), new DefaultLobHandler()), NODE_VAR_ID_ }, new int[] { Types.VARCHAR, Types.VARCHAR, Types.BLOB, Types.VARCHAR });
}
catch (Exception e) {
throw new RuntimeException(e);
}
finally {
try {
objectOutputStream.close();
}
catch (Exception e) {
}
}
}
return count;
}
@Override
public List updateNodeVar(String NODE_ID_, Map nodeVarMap) {
List nodeVarIdList = new ArrayList<>();
if (nodeVarMap == null) {
return nodeVarIdList;
}
List> nodeVarList = selectNodeVar(null, NODE_ID_, null, null, false, 1, -1);
List nodeVarKeyList = OdUtils.collect(nodeVarList, "VAR_NAME_", String.class);
String NODE_VAR_ID_ = null;
String VAR_TYPE_ = null;
String VALUE_ = null;
Serializable OBJ_ = null;
int index;
for (String key : nodeVarMap.keySet()) {
if (nodeVarMap.get(key) instanceof String) {
VAR_TYPE_ = FfService.VAR_TYPE_STRING;
VALUE_ = (String) nodeVarMap.get(key);
OBJ_ = null;
}
else {
VAR_TYPE_ = FfService.VAR_TYPE_OBJECT;
VALUE_ = null;
OBJ_ = (Serializable) nodeVarMap.get(key);
}
index = nodeVarKeyList.indexOf(key);
if (index == -1) {// insert
NODE_VAR_ID_ = OdUtils.getUuid();
insertNodeVar(NODE_VAR_ID_, NODE_ID_, VAR_TYPE_, key, VALUE_, OBJ_, new Date());
}
else {// update
NODE_VAR_ID_ = (String) nodeVarList.get(index).get("NODE_VAR_ID_");
updateNodeVar(NODE_VAR_ID_, VAR_TYPE_, key, VALUE_, OBJ_);
}
nodeVarIdList.add(NODE_VAR_ID_);
}
return nodeVarIdList;
}
@Override
public int deleteNodeVar(String NODE_VAR_ID_) {
ffOperationService.insertNodeVarOp(OdUtils.getUuid(), NODE_VAR_ID_, FfOperationService.OPERATION_TYPE_DELETE);
String sql = "delete from FF_NODE_VAR where NODE_VAR_ID_ = ?";
return ffJdbcTemplate.update(sql, NODE_VAR_ID_);
}
@Override
public int deleteNodeVarByNodeId(String NODE_ID_) {
List> nodeVarList = selectNodeVar(null, NODE_ID_, null, null, false, 1, -1);
for (Map nodeVar : nodeVarList) {
deleteNodeVar((String) nodeVar.get("NODE_VAR_ID_"));
}
return nodeVarList.size();
}
}