Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
com.opendynamic.ff.service.impl.oracle.FfProcServiceImpl Maven / Gradle / Ivy
package com.opendynamic.ff.service.impl.oracle;
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.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.FfOperationService;
import com.opendynamic.ff.service.FfProcService;
import com.opendynamic.ff.service.FfService;
@Service
@Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class)
public class FfProcServiceImpl implements FfProcService {
@Autowired
private FfOperationService ffOperationService;
@Autowired
private JdbcTemplate ffJdbcTemplate;
@Override
public Map loadProc(String PROC_ID_) {
String sql = "select * from FFV_PROC where PROC_ID_ = ?";
List> result = ffJdbcTemplate.queryForList(sql, PROC_ID_);
if (result.size() == 1) {
return result.get(0);
}
else {
return null;
}
}
@Override
public List> selectProc(String PROC_ID_, List PROC_ID_LIST, String ADJUST_PROC_DEF_ID_, List ADJUST_PROC_DEF_ID_LIST, String ISOLATE_SUB_PROC_NODE_ID_, List ISOLATE_SUB_PROC_NODE_ID_LIST, String BIZ_ID_, List BIZ_ID_LIST, String BIZ_TYPE_, List BIZ_TYPE_LIST, String BIZ_CODE_, List BIZ_CODE_LIST, String BIZ_NAME_, List BIZ_NAME_LIST, String BIZ_DESC_, List BIZ_DESC_LIST, String PROC_START_USER_, List PROC_START_USER_LIST, String PROC_START_USER_NAME_, List PROC_START_USER_NAME_LIST, String PROC_END_USER_, List PROC_END_USER_LIST, String PROC_END_USER_NAME_, List PROC_END_USER_NAME_LIST, Date FROM_PROC_END_DATE_, Date TO_PROC_END_DATE_, String PROC_STATUS_,
List PROC_STATUS_LIST, Date FROM_CREATION_DATE_, Date TO_CREATION_DATE_, String PROC_DEF_ID_, List PROC_DEF_ID_LIST, String PROC_DEF_CODE_, List PROC_DEF_CODE_LIST, String PROC_DEF_NAME_, List PROC_DEF_NAME_LIST, String PROC_DEF_CAT_, List PROC_DEF_CAT_LIST, Integer VERSION_, List VERSION_LIST, String PROC_DEF_STATUS_, List PROC_DEF_STATUS_LIST, Integer page, Integer limit, String dataScope) {
OdSqlCriteria odSqlCriteria = buildSqlCriteriaProc(false, PROC_ID_, PROC_ID_LIST, ADJUST_PROC_DEF_ID_, ADJUST_PROC_DEF_ID_LIST, ISOLATE_SUB_PROC_NODE_ID_, ISOLATE_SUB_PROC_NODE_ID_LIST, BIZ_ID_, BIZ_ID_LIST, BIZ_TYPE_, BIZ_TYPE_LIST, BIZ_CODE_, BIZ_CODE_LIST, BIZ_NAME_, BIZ_NAME_LIST, BIZ_DESC_, BIZ_DESC_LIST, PROC_START_USER_, PROC_START_USER_LIST, PROC_START_USER_NAME_, PROC_START_USER_NAME_LIST, PROC_END_USER_, PROC_END_USER_LIST, PROC_END_USER_NAME_, PROC_END_USER_NAME_LIST, FROM_PROC_END_DATE_, TO_PROC_END_DATE_, PROC_STATUS_, PROC_STATUS_LIST, FROM_CREATION_DATE_, TO_CREATION_DATE_, PROC_DEF_ID_, PROC_DEF_ID_LIST, PROC_DEF_CODE_, PROC_DEF_CODE_LIST, PROC_DEF_NAME_, PROC_DEF_NAME_LIST, PROC_DEF_CAT_, PROC_DEF_CAT_LIST, VERSION_, VERSION_LIST, PROC_DEF_STATUS_,
PROC_DEF_STATUS_LIST, dataScope);// 根据查询条件组装查询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 countProc(String PROC_ID_, List PROC_ID_LIST, String ADJUST_PROC_DEF_ID_, List ADJUST_PROC_DEF_ID_LIST, String ISOLATE_SUB_PROC_NODE_ID_, List ISOLATE_SUB_PROC_NODE_ID_LIST, String BIZ_ID_, List BIZ_ID_LIST, String BIZ_TYPE_, List BIZ_TYPE_LIST, String BIZ_CODE_, List BIZ_CODE_LIST, String BIZ_NAME_, List BIZ_NAME_LIST, String BIZ_DESC_, List BIZ_DESC_LIST, String PROC_START_USER_, List PROC_START_USER_LIST, String PROC_START_USER_NAME_, List PROC_START_USER_NAME_LIST, String PROC_END_USER_, List PROC_END_USER_LIST, String PROC_END_USER_NAME_, List PROC_END_USER_NAME_LIST, Date FROM_PROC_END_DATE_, Date TO_PROC_END_DATE_, String PROC_STATUS_, List PROC_STATUS_LIST,
Date FROM_CREATION_DATE_, Date TO_CREATION_DATE_, String PROC_DEF_ID_, List PROC_DEF_ID_LIST, String PROC_DEF_CODE_, List PROC_DEF_CODE_LIST, String PROC_DEF_NAME_, List PROC_DEF_NAME_LIST, String PROC_DEF_CAT_, List PROC_DEF_CAT_LIST, Integer VERSION_, List VERSION_LIST, String PROC_DEF_STATUS_, List PROC_DEF_STATUS_LIST, String dataScope) {
OdSqlCriteria odSqlCriteria = buildSqlCriteriaProc(true, PROC_ID_, PROC_ID_LIST, ADJUST_PROC_DEF_ID_, ADJUST_PROC_DEF_ID_LIST, ISOLATE_SUB_PROC_NODE_ID_, ISOLATE_SUB_PROC_NODE_ID_LIST, BIZ_ID_, BIZ_ID_LIST, BIZ_TYPE_, BIZ_TYPE_LIST, BIZ_CODE_, BIZ_CODE_LIST, BIZ_NAME_, BIZ_NAME_LIST, BIZ_DESC_, BIZ_DESC_LIST, PROC_START_USER_, PROC_START_USER_LIST, PROC_START_USER_NAME_, PROC_START_USER_NAME_LIST, PROC_END_USER_, PROC_END_USER_LIST, PROC_END_USER_NAME_, PROC_END_USER_NAME_LIST, FROM_PROC_END_DATE_, TO_PROC_END_DATE_, PROC_STATUS_, PROC_STATUS_LIST, FROM_CREATION_DATE_, TO_CREATION_DATE_, PROC_DEF_ID_, PROC_DEF_ID_LIST, PROC_DEF_CODE_, PROC_DEF_CODE_LIST, PROC_DEF_NAME_, PROC_DEF_NAME_LIST, PROC_DEF_CAT_, PROC_DEF_CAT_LIST, VERSION_, VERSION_LIST, PROC_DEF_STATUS_,
PROC_DEF_STATUS_LIST, dataScope);// 根据查询条件组装总数查询SQL语句
String sql = odSqlCriteria.getSql();
Map paramMap = odSqlCriteria.getParamMap();
NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(ffJdbcTemplate);
return namedParameterJdbcTemplate.queryForObject(sql, paramMap, Integer.class);
}
private OdSqlCriteria buildSqlCriteriaProc(boolean count, String PROC_ID_, List PROC_ID_LIST, String ADJUST_PROC_DEF_ID_, List ADJUST_PROC_DEF_ID_LIST, String ISOLATE_SUB_PROC_NODE_ID_, List ISOLATE_SUB_PROC_NODE_ID_LIST, String BIZ_ID_, List BIZ_ID_LIST, String BIZ_TYPE_, List BIZ_TYPE_LIST, String BIZ_CODE_, List BIZ_CODE_LIST, String BIZ_NAME_, List BIZ_NAME_LIST, String BIZ_DESC_, List BIZ_DESC_LIST, String PROC_START_USER_, List PROC_START_USER_LIST, String PROC_START_USER_NAME_, List PROC_START_USER_NAME_LIST, String PROC_END_USER_, List PROC_END_USER_LIST, String PROC_END_USER_NAME_, List PROC_END_USER_NAME_LIST, Date FROM_PROC_END_DATE_, Date TO_PROC_END_DATE_, String PROC_STATUS_,
List PROC_STATUS_LIST, Date FROM_CREATION_DATE_, Date TO_CREATION_DATE_, String PROC_DEF_ID_, List PROC_DEF_ID_LIST, String PROC_DEF_CODE_, List PROC_DEF_CODE_LIST, String PROC_DEF_NAME_, List PROC_DEF_NAME_LIST, String PROC_DEF_CAT_, List PROC_DEF_CAT_LIST, Integer VERSION_, List VERSION_LIST, String PROC_DEF_STATUS_, List PROC_DEF_STATUS_LIST, String dataScope) {// 组装查询SQL语句
String sql;
Map paramMap = new HashMap();
String view = "FFV_PROC_PD";
if (FfService.DATA_SCOPE_PROC.equals(dataScope)) {
view = "FFV_PROC";
}
if (count) {
sql = "select count(*) from " + view + " where 1 = 1";
}
else {
sql = "select * from " + view + " where 1 = 1";
}
if (StringUtils.isNotEmpty(PROC_ID_)) {
sql += " and PROC_ID_ = :PROC_ID_";
paramMap.put("PROC_ID_", PROC_ID_);
}
if (PROC_ID_LIST != null && PROC_ID_LIST.size() > 0) {
sql += " and PROC_ID_ in (:PROC_ID_LIST)";
paramMap.put("PROC_ID_LIST", PROC_ID_LIST);
}
if (StringUtils.isNotEmpty(ADJUST_PROC_DEF_ID_)) {
sql += " and ADJUST_PROC_DEF_ID_ = :ADJUST_PROC_DEF_ID_";
paramMap.put("ADJUST_PROC_DEF_ID_", ADJUST_PROC_DEF_ID_);
}
if (ADJUST_PROC_DEF_ID_LIST != null && ADJUST_PROC_DEF_ID_LIST.size() > 0) {
sql += " and ADJUST_PROC_DEF_ID_ in (:ADJUST_PROC_DEF_ID_LIST)";
paramMap.put("ADJUST_PROC_DEF_ID_LIST", ADJUST_PROC_DEF_ID_LIST);
}
if (StringUtils.isNotEmpty(ISOLATE_SUB_PROC_NODE_ID_)) {
sql += " and ISOLATE_SUB_PROC_NODE_ID_ = :ISOLATE_SUB_PROC_NODE_ID_";
paramMap.put("ISOLATE_SUB_PROC_NODE_ID_", ISOLATE_SUB_PROC_NODE_ID_);
}
if (ISOLATE_SUB_PROC_NODE_ID_LIST != null && ISOLATE_SUB_PROC_NODE_ID_LIST.size() > 0) {
sql += " and ISOLATE_SUB_PROC_NODE_ID_ in (:ISOLATE_SUB_PROC_NODE_ID_LIST)";
paramMap.put("ISOLATE_SUB_PROC_NODE_ID_LIST", ISOLATE_SUB_PROC_NODE_ID_LIST);
}
if (StringUtils.isNotEmpty(BIZ_ID_)) {
sql += " and BIZ_ID_ = :BIZ_ID_";
paramMap.put("BIZ_ID_", BIZ_ID_);
}
if (BIZ_ID_LIST != null && BIZ_ID_LIST.size() > 0) {
sql += " and BIZ_ID_ in (:BIZ_ID_LIST)";
paramMap.put("BIZ_ID_LIST", BIZ_ID_LIST);
}
if (StringUtils.isNotEmpty(BIZ_TYPE_)) {
sql += " and BIZ_TYPE_ = :BIZ_TYPE_";
paramMap.put("BIZ_TYPE_", BIZ_TYPE_);
}
if (BIZ_TYPE_LIST != null && BIZ_TYPE_LIST.size() > 0) {
sql += " and BIZ_TYPE_ in (:BIZ_TYPE_LIST)";
paramMap.put("BIZ_TYPE_LIST", BIZ_TYPE_LIST);
}
if (StringUtils.isNotEmpty(BIZ_CODE_)) {
sql += " and BIZ_CODE_ = :BIZ_CODE_";
paramMap.put("BIZ_CODE_", BIZ_CODE_);
}
if (BIZ_CODE_LIST != null && BIZ_CODE_LIST.size() > 0) {
sql += " and BIZ_CODE_ in (:BIZ_CODE_LIST)";
paramMap.put("BIZ_CODE_LIST", BIZ_CODE_LIST);
}
if (StringUtils.isNotEmpty(BIZ_NAME_)) {
sql += " and BIZ_NAME_ like '%' || :BIZ_NAME_ || '%'";
paramMap.put("BIZ_NAME_", BIZ_NAME_);
}
if (BIZ_NAME_LIST != null && BIZ_NAME_LIST.size() > 0) {
sql += " and BIZ_NAME_ in (:BIZ_NAME_LIST)";
paramMap.put("BIZ_NAME_LIST", BIZ_NAME_LIST);
}
if (StringUtils.isNotEmpty(BIZ_DESC_)) {
sql += " and BIZ_DESC_ like '%' || :BIZ_DESC_ || '%'";
paramMap.put("BIZ_DESC_", BIZ_DESC_);
}
if (BIZ_DESC_LIST != null && BIZ_DESC_LIST.size() > 0) {
sql += " and BIZ_DESC_ in (:BIZ_DESC_LIST)";
paramMap.put("BIZ_DESC_LIST", BIZ_DESC_LIST);
}
if (StringUtils.isNotEmpty(PROC_START_USER_)) {
sql += " and PROC_START_USER_ = :PROC_START_USER_";
paramMap.put("PROC_START_USER_", PROC_START_USER_);
}
if (PROC_START_USER_LIST != null && PROC_START_USER_LIST.size() > 0) {
sql += " and PROC_START_USER_ in (:PROC_START_USER_LIST)";
paramMap.put("PROC_START_USER_LIST", PROC_START_USER_LIST);
}
if (StringUtils.isNotEmpty(PROC_START_USER_NAME_)) {
sql += " and PROC_START_USER_NAME_ like '%' || :PROC_START_USER_NAME_ || '%'";
paramMap.put("PROC_START_USER_NAME_", PROC_START_USER_NAME_);
}
if (PROC_START_USER_NAME_LIST != null && PROC_START_USER_NAME_LIST.size() > 0) {
sql += " and PROC_START_USER_NAME_ in (:PROC_START_USER_NAME_LIST)";
paramMap.put("PROC_START_USER_NAME_LIST", PROC_START_USER_NAME_LIST);
}
if (StringUtils.isNotEmpty(PROC_END_USER_)) {
sql += " and PROC_END_USER_ = :PROC_END_USER_";
paramMap.put("PROC_END_USER_", PROC_END_USER_);
}
if (PROC_END_USER_LIST != null && PROC_END_USER_LIST.size() > 0) {
sql += " and PROC_END_USER_ in (:PROC_END_USER_LIST)";
paramMap.put("PROC_END_USER_LIST", PROC_END_USER_LIST);
}
if (StringUtils.isNotEmpty(PROC_END_USER_NAME_)) {
sql += " and PROC_END_USER_NAME_ like '%' || :PROC_END_USER_NAME_ || '%'";
paramMap.put("PROC_END_USER_NAME_", PROC_END_USER_NAME_);
}
if (PROC_END_USER_NAME_LIST != null && PROC_END_USER_NAME_LIST.size() > 0) {
sql += " and PROC_END_USER_NAME_ in (:PROC_END_USER_NAME_LIST)";
paramMap.put("PROC_END_USER_NAME_LIST", PROC_END_USER_NAME_LIST);
}
if (FROM_PROC_END_DATE_ != null) {
sql += " and PROC_END_DATE_ >= :FROM_PROC_END_DATE_";
paramMap.put("FROM_PROC_END_DATE_", FROM_PROC_END_DATE_);
}
if (TO_PROC_END_DATE_ != null) {
sql += " and PROC_END_DATE_ <= :TO_PROC_END_DATE_";
paramMap.put("TO_PROC_END_DATE_", TO_PROC_END_DATE_);
}
if (StringUtils.isNotEmpty(PROC_STATUS_)) {
sql += " and PROC_STATUS_ = :PROC_STATUS_";
paramMap.put("PROC_STATUS_", PROC_STATUS_);
}
if (PROC_STATUS_LIST != null && PROC_STATUS_LIST.size() > 0) {
sql += " and PROC_STATUS_ in (:PROC_STATUS_LIST)";
paramMap.put("PROC_STATUS_LIST", PROC_STATUS_LIST);
}
if (FROM_CREATION_DATE_ != null) {
sql += " and CREATION_DATE_ >= :FROM_CREATION_DATE_";
paramMap.put("FROM_CREATION_DATE_", FROM_CREATION_DATE_);
}
if (TO_CREATION_DATE_ != null) {
sql += " and CREATION_DATE_ <= :TO_CREATION_DATE_";
paramMap.put("TO_CREATION_DATE_", TO_CREATION_DATE_);
}
if (StringUtils.isNotEmpty(PROC_DEF_ID_)) {
sql += " and PROC_DEF_ID_ = :PROC_DEF_ID_";
paramMap.put("PROC_DEF_ID_", PROC_DEF_ID_);
}
if (PROC_DEF_ID_LIST != null && PROC_DEF_ID_LIST.size() > 0) {
sql += " and PROC_DEF_ID_ in (:PROC_DEF_ID_LIST)";
paramMap.put("PROC_DEF_ID_LIST", PROC_DEF_ID_LIST);
}
if (StringUtils.isNotEmpty(PROC_DEF_CODE_)) {
sql += " and PROC_DEF_CODE_ = :PROC_DEF_CODE_";
paramMap.put("PROC_DEF_CODE_", PROC_DEF_CODE_);
}
if (PROC_DEF_CODE_LIST != null && PROC_DEF_CODE_LIST.size() > 0) {
sql += " and PROC_DEF_CODE_ in (:PROC_DEF_CODE_LIST)";
paramMap.put("PROC_DEF_CODE_LIST", PROC_DEF_CODE_LIST);
}
if (StringUtils.isNotEmpty(PROC_DEF_NAME_)) {
sql += " and PROC_DEF_NAME_ like '%' || :PROC_DEF_NAME_ || '%'";
paramMap.put("PROC_DEF_NAME_", PROC_DEF_NAME_);
}
if (PROC_DEF_NAME_LIST != null && PROC_DEF_NAME_LIST.size() > 0) {
sql += " and PROC_DEF_NAME_ in (:PROC_DEF_NAME_LIST)";
paramMap.put("PROC_DEF_NAME_LIST", PROC_DEF_NAME_LIST);
}
if (StringUtils.isNotEmpty(PROC_DEF_CAT_)) {
sql += " and PROC_DEF_CAT_ like :PROC_DEF_CAT_ || '%'";
paramMap.put("PROC_DEF_CAT_", PROC_DEF_CAT_);
}
if (PROC_DEF_CAT_LIST != null && PROC_DEF_CAT_LIST.size() > 0) {
sql += " and PROC_DEF_CAT_ in (:PROC_DEF_CAT_LIST)";
paramMap.put("PROC_DEF_CAT_LIST", PROC_DEF_CAT_LIST);
}
if (VERSION_ != null) {
sql += " and VERSION_ = :VERSION_";
paramMap.put("VERSION_", VERSION_);
}
if (VERSION_LIST != null && VERSION_LIST.size() > 0) {
sql += " and VERSION_ in (:VERSION_LIST)";
paramMap.put("VERSION_LIST", VERSION_LIST);
}
if (StringUtils.isNotEmpty(PROC_DEF_STATUS_)) {
sql += " and PROC_DEF_STATUS_ = :PROC_DEF_STATUS_";
paramMap.put("PROC_DEF_STATUS_", PROC_DEF_STATUS_);
}
if (PROC_DEF_STATUS_LIST != null && PROC_DEF_STATUS_LIST.size() > 0) {
sql += " and PROC_DEF_STATUS_ in (:PROC_DEF_STATUS_LIST)";
paramMap.put("PROC_DEF_STATUS_LIST", PROC_DEF_STATUS_LIST);
}
if (!count) {
sql += " order by CREATION_DATE_ desc";
}
return new OdSqlCriteria(sql, paramMap);
}
@Override
public List> selectInvolvedProc(String ASSIGNEE_, List ASSIGNEE_LIST, String PROC_ID_, List PROC_ID_LIST, String ADJUST_PROC_DEF_ID_, List ADJUST_PROC_DEF_ID_LIST, String ISOLATE_SUB_PROC_NODE_ID_, List ISOLATE_SUB_PROC_NODE_ID_LIST, String BIZ_ID_, List BIZ_ID_LIST, String BIZ_TYPE_, List BIZ_TYPE_LIST, String BIZ_CODE_, List BIZ_CODE_LIST, String BIZ_NAME_, List BIZ_NAME_LIST, String BIZ_DESC_, List BIZ_DESC_LIST, String PROC_START_USER_, List PROC_START_USER_LIST, String PROC_START_USER_NAME_, List PROC_START_USER_NAME_LIST, String PROC_END_USER_, List PROC_END_USER_LIST, String PROC_END_USER_NAME_, List PROC_END_USER_NAME_LIST, Date FROM_PROC_END_DATE_,
Date TO_PROC_END_DATE_, String PROC_STATUS_, List PROC_STATUS_LIST, Date FROM_CREATION_DATE_, Date TO_CREATION_DATE_, String PROC_DEF_ID_, List PROC_DEF_ID_LIST, String PROC_DEF_CODE_, List PROC_DEF_CODE_LIST, String PROC_DEF_NAME_, List PROC_DEF_NAME_LIST, String PROC_DEF_CAT_, List PROC_DEF_CAT_LIST, Integer VERSION_, List VERSION_LIST, String PROC_DEF_STATUS_, List PROC_DEF_STATUS_LIST, Integer page, Integer limit, String dataScope) {
OdSqlCriteria odSqlCriteria = buildSqlCriteriaInvolvedProc(false, ASSIGNEE_, ASSIGNEE_LIST, PROC_ID_, PROC_ID_LIST, ADJUST_PROC_DEF_ID_, ADJUST_PROC_DEF_ID_LIST, ISOLATE_SUB_PROC_NODE_ID_, ISOLATE_SUB_PROC_NODE_ID_LIST, BIZ_ID_, BIZ_ID_LIST, BIZ_TYPE_, BIZ_TYPE_LIST, BIZ_CODE_, BIZ_CODE_LIST, BIZ_NAME_, BIZ_NAME_LIST, BIZ_DESC_, BIZ_DESC_LIST, PROC_START_USER_, PROC_START_USER_LIST, PROC_START_USER_NAME_, PROC_START_USER_NAME_LIST, PROC_END_USER_, PROC_END_USER_LIST, PROC_END_USER_NAME_, PROC_END_USER_NAME_LIST, FROM_PROC_END_DATE_, TO_PROC_END_DATE_, PROC_STATUS_, PROC_STATUS_LIST, FROM_CREATION_DATE_, TO_CREATION_DATE_, PROC_DEF_ID_, PROC_DEF_ID_LIST, PROC_DEF_CODE_, PROC_DEF_CODE_LIST, PROC_DEF_NAME_, PROC_DEF_NAME_LIST, PROC_DEF_CAT_, PROC_DEF_CAT_LIST, VERSION_, VERSION_LIST,
PROC_DEF_STATUS_, PROC_DEF_STATUS_LIST, dataScope);// 根据查询条件组装查询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 countInvolvedProc(String ASSIGNEE_, List ASSIGNEE_LIST, String PROC_ID_, List PROC_ID_LIST, String ADJUST_PROC_DEF_ID_, List ADJUST_PROC_DEF_ID_LIST, String ISOLATE_SUB_PROC_NODE_ID_, List ISOLATE_SUB_PROC_NODE_ID_LIST, String BIZ_ID_, List BIZ_ID_LIST, String BIZ_TYPE_, List BIZ_TYPE_LIST, String BIZ_CODE_, List BIZ_CODE_LIST, String BIZ_NAME_, List BIZ_NAME_LIST, String BIZ_DESC_, List BIZ_DESC_LIST, String PROC_START_USER_, List PROC_START_USER_LIST, String PROC_START_USER_NAME_, List PROC_START_USER_NAME_LIST, String PROC_END_USER_, List PROC_END_USER_LIST, String PROC_END_USER_NAME_, List PROC_END_USER_NAME_LIST, Date FROM_PROC_END_DATE_, Date TO_PROC_END_DATE_,
String PROC_STATUS_, List PROC_STATUS_LIST, Date FROM_CREATION_DATE_, Date TO_CREATION_DATE_, String PROC_DEF_ID_, List PROC_DEF_ID_LIST, String PROC_DEF_CODE_, List PROC_DEF_CODE_LIST, String PROC_DEF_NAME_, List PROC_DEF_NAME_LIST, String PROC_DEF_CAT_, List PROC_DEF_CAT_LIST, Integer VERSION_, List VERSION_LIST, String PROC_DEF_STATUS_, List PROC_DEF_STATUS_LIST, String dataScope) {
OdSqlCriteria odSqlCriteria = buildSqlCriteriaInvolvedProc(true, ASSIGNEE_, ASSIGNEE_LIST, PROC_ID_, PROC_ID_LIST, ADJUST_PROC_DEF_ID_, ADJUST_PROC_DEF_ID_LIST, ISOLATE_SUB_PROC_NODE_ID_, ISOLATE_SUB_PROC_NODE_ID_LIST, BIZ_ID_, BIZ_ID_LIST, BIZ_TYPE_, BIZ_TYPE_LIST, BIZ_CODE_, BIZ_CODE_LIST, BIZ_NAME_, BIZ_NAME_LIST, BIZ_DESC_, BIZ_DESC_LIST, PROC_START_USER_, PROC_START_USER_LIST, PROC_START_USER_NAME_, PROC_START_USER_NAME_LIST, PROC_END_USER_, PROC_END_USER_LIST, PROC_END_USER_NAME_, PROC_END_USER_NAME_LIST, FROM_PROC_END_DATE_, TO_PROC_END_DATE_, PROC_STATUS_, PROC_STATUS_LIST, FROM_CREATION_DATE_, TO_CREATION_DATE_, PROC_DEF_ID_, PROC_DEF_ID_LIST, PROC_DEF_CODE_, PROC_DEF_CODE_LIST, PROC_DEF_NAME_, PROC_DEF_NAME_LIST, PROC_DEF_CAT_, PROC_DEF_CAT_LIST, VERSION_, VERSION_LIST,
PROC_DEF_STATUS_, PROC_DEF_STATUS_LIST, dataScope);// 根据查询条件组装总数查询SQL语句
String sql = odSqlCriteria.getSql();
Map paramMap = odSqlCriteria.getParamMap();
NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(ffJdbcTemplate);
return namedParameterJdbcTemplate.queryForObject(sql, paramMap, Integer.class);
}
private OdSqlCriteria buildSqlCriteriaInvolvedProc(boolean count, String ASSIGNEE_, List ASSIGNEE_LIST, String PROC_ID_, List PROC_ID_LIST, String ADJUST_PROC_DEF_ID_, List ADJUST_PROC_DEF_ID_LIST, String ISOLATE_SUB_PROC_NODE_ID_, List ISOLATE_SUB_PROC_NODE_ID_LIST, String BIZ_ID_, List BIZ_ID_LIST, String BIZ_TYPE_, List BIZ_TYPE_LIST, String BIZ_CODE_, List BIZ_CODE_LIST, String BIZ_NAME_, List BIZ_NAME_LIST, String BIZ_DESC_, List BIZ_DESC_LIST, String PROC_START_USER_, List PROC_START_USER_LIST, String PROC_START_USER_NAME_, List PROC_START_USER_NAME_LIST, String PROC_END_USER_, List PROC_END_USER_LIST, String PROC_END_USER_NAME_, List PROC_END_USER_NAME_LIST,
Date FROM_PROC_END_DATE_, Date TO_PROC_END_DATE_, String PROC_STATUS_, List PROC_STATUS_LIST, Date FROM_CREATION_DATE_, Date TO_CREATION_DATE_, String PROC_DEF_ID_, List PROC_DEF_ID_LIST, String PROC_DEF_CODE_, List PROC_DEF_CODE_LIST, String PROC_DEF_NAME_, List PROC_DEF_NAME_LIST, String PROC_DEF_CAT_, List PROC_DEF_CAT_LIST, Integer VERSION_, List VERSION_LIST, String PROC_DEF_STATUS_, List PROC_DEF_STATUS_LIST, String dataScope) {// 组装查询SQL语句
if (StringUtils.isEmpty(ASSIGNEE_) && (ASSIGNEE_LIST == null || ASSIGNEE_LIST.size() == 0)) {
throw new RuntimeException("errors.assigneeRequired");
}
String sql;
Map paramMap = new HashMap();
String view = "FFV_PROC_PD";
if (FfService.DATA_SCOPE_PROC.equals(dataScope)) {
view = "FFV_PROC";
}
if (count) {
sql = "select count(*) from " + view + " where PROC_ID_ in (select distinct PROC_ID_ from FFV_TASK where TASK_STATUS_ = '9'";
}
else {
sql = "select * from " + view + " where PROC_ID_ in (select distinct PROC_ID_ from FFV_TASK where TASK_STATUS_ = '9'";
}
if (StringUtils.isNotEmpty(ASSIGNEE_)) {
sql += " and ASSIGNEE_ = :ASSIGNEE_";
paramMap.put("ASSIGNEE_", ASSIGNEE_);
}
if (ASSIGNEE_LIST != null && ASSIGNEE_LIST.size() > 0) {
sql += " and ASSIGNEE_ in (:ASSIGNEE_LIST)";
paramMap.put("ASSIGNEE_LIST", ASSIGNEE_LIST);
}
sql += ")";
if (StringUtils.isNotEmpty(PROC_ID_)) {
sql += " and PROC_ID_ = :PROC_ID_";
paramMap.put("PROC_ID_", PROC_ID_);
}
if (PROC_ID_LIST != null && PROC_ID_LIST.size() > 0) {
sql += " and PROC_ID_ in (:PROC_ID_LIST)";
paramMap.put("PROC_ID_LIST", PROC_ID_LIST);
}
if (StringUtils.isNotEmpty(ADJUST_PROC_DEF_ID_)) {
sql += " and ADJUST_PROC_DEF_ID_ = :ADJUST_PROC_DEF_ID_";
paramMap.put("ADJUST_PROC_DEF_ID_", ADJUST_PROC_DEF_ID_);
}
if (ADJUST_PROC_DEF_ID_LIST != null && ADJUST_PROC_DEF_ID_LIST.size() > 0) {
sql += " and ADJUST_PROC_DEF_ID_ in (:ADJUST_PROC_DEF_ID_LIST)";
paramMap.put("ADJUST_PROC_DEF_ID_LIST", ADJUST_PROC_DEF_ID_LIST);
}
if (StringUtils.isNotEmpty(ISOLATE_SUB_PROC_NODE_ID_)) {
sql += " and ISOLATE_SUB_PROC_NODE_ID_ = :ISOLATE_SUB_PROC_NODE_ID_";
paramMap.put("ISOLATE_SUB_PROC_NODE_ID_", ISOLATE_SUB_PROC_NODE_ID_);
}
if (ISOLATE_SUB_PROC_NODE_ID_LIST != null && ISOLATE_SUB_PROC_NODE_ID_LIST.size() > 0) {
sql += " and ISOLATE_SUB_PROC_NODE_ID_ in (:ISOLATE_SUB_PROC_NODE_ID_LIST)";
paramMap.put("ISOLATE_SUB_PROC_NODE_ID_LIST", ISOLATE_SUB_PROC_NODE_ID_LIST);
}
if (StringUtils.isNotEmpty(BIZ_ID_)) {
sql += " and BIZ_ID_ = :BIZ_ID_";
paramMap.put("BIZ_ID_", BIZ_ID_);
}
if (BIZ_ID_LIST != null && BIZ_ID_LIST.size() > 0) {
sql += " and BIZ_ID_ in (:BIZ_ID_LIST)";
paramMap.put("BIZ_ID_LIST", BIZ_ID_LIST);
}
if (StringUtils.isNotEmpty(BIZ_TYPE_)) {
sql += " and BIZ_TYPE_ = :BIZ_TYPE_";
paramMap.put("BIZ_TYPE_", BIZ_TYPE_);
}
if (BIZ_TYPE_LIST != null && BIZ_TYPE_LIST.size() > 0) {
sql += " and BIZ_TYPE_ in (:BIZ_TYPE_LIST)";
paramMap.put("BIZ_TYPE_LIST", BIZ_TYPE_LIST);
}
if (StringUtils.isNotEmpty(BIZ_CODE_)) {
sql += " and BIZ_CODE_ = :BIZ_CODE_";
paramMap.put("BIZ_CODE_", BIZ_CODE_);
}
if (BIZ_CODE_LIST != null && BIZ_CODE_LIST.size() > 0) {
sql += " and BIZ_CODE_ in (:BIZ_CODE_LIST)";
paramMap.put("BIZ_CODE_LIST", BIZ_CODE_LIST);
}
if (StringUtils.isNotEmpty(BIZ_NAME_)) {
sql += " and BIZ_NAME_ like '%' || :BIZ_NAME_ || '%'";
paramMap.put("BIZ_NAME_", BIZ_NAME_);
}
if (BIZ_NAME_LIST != null && BIZ_NAME_LIST.size() > 0) {
sql += " and BIZ_NAME_ in (:BIZ_NAME_LIST)";
paramMap.put("BIZ_NAME_LIST", BIZ_NAME_LIST);
}
if (StringUtils.isNotEmpty(BIZ_DESC_)) {
sql += " and BIZ_DESC_ like '%' || :BIZ_DESC_ || '%'";
paramMap.put("BIZ_DESC_", BIZ_DESC_);
}
if (BIZ_DESC_LIST != null && BIZ_DESC_LIST.size() > 0) {
sql += " and BIZ_DESC_ in (:BIZ_DESC_LIST)";
paramMap.put("BIZ_DESC_LIST", BIZ_DESC_LIST);
}
if (StringUtils.isNotEmpty(PROC_START_USER_)) {
sql += " and PROC_START_USER_ = :PROC_START_USER_";
paramMap.put("PROC_START_USER_", PROC_START_USER_);
}
if (PROC_START_USER_LIST != null && PROC_START_USER_LIST.size() > 0) {
sql += " and PROC_START_USER_ in (:PROC_START_USER_LIST)";
paramMap.put("PROC_START_USER_LIST", PROC_START_USER_LIST);
}
if (StringUtils.isNotEmpty(PROC_START_USER_NAME_)) {
sql += " and PROC_START_USER_NAME_ like '%' || :PROC_START_USER_NAME_ || '%'";
paramMap.put("PROC_START_USER_NAME_", PROC_START_USER_NAME_);
}
if (PROC_START_USER_NAME_LIST != null && PROC_START_USER_NAME_LIST.size() > 0) {
sql += " and PROC_START_USER_NAME_ in (:PROC_START_USER_NAME_LIST)";
paramMap.put("PROC_START_USER_NAME_LIST", PROC_START_USER_NAME_LIST);
}
if (StringUtils.isNotEmpty(PROC_END_USER_)) {
sql += " and PROC_END_USER_ = :PROC_END_USER_";
paramMap.put("PROC_END_USER_", PROC_END_USER_);
}
if (PROC_END_USER_LIST != null && PROC_END_USER_LIST.size() > 0) {
sql += " and PROC_END_USER_ in (:PROC_END_USER_LIST)";
paramMap.put("PROC_END_USER_LIST", PROC_END_USER_LIST);
}
if (StringUtils.isNotEmpty(PROC_END_USER_NAME_)) {
sql += " and PROC_END_USER_NAME_ like '%' || :PROC_END_USER_NAME_ || '%'";
paramMap.put("PROC_END_USER_NAME_", PROC_END_USER_NAME_);
}
if (PROC_END_USER_NAME_LIST != null && PROC_END_USER_NAME_LIST.size() > 0) {
sql += " and PROC_END_USER_NAME_ in (:PROC_END_USER_NAME_LIST)";
paramMap.put("PROC_END_USER_NAME_LIST", PROC_END_USER_NAME_LIST);
}
if (FROM_PROC_END_DATE_ != null) {
sql += " and PROC_END_DATE_ >= :FROM_PROC_END_DATE_";
paramMap.put("FROM_PROC_END_DATE_", FROM_PROC_END_DATE_);
}
if (TO_PROC_END_DATE_ != null) {
sql += " and PROC_END_DATE_ <= :TO_PROC_END_DATE_";
paramMap.put("TO_PROC_END_DATE_", TO_PROC_END_DATE_);
}
if (StringUtils.isNotEmpty(PROC_STATUS_)) {
sql += " and PROC_STATUS_ = :PROC_STATUS_";
paramMap.put("PROC_STATUS_", PROC_STATUS_);
}
if (PROC_STATUS_LIST != null && PROC_STATUS_LIST.size() > 0) {
sql += " and PROC_STATUS_ in (:PROC_STATUS_LIST)";
paramMap.put("PROC_STATUS_LIST", PROC_STATUS_LIST);
}
if (FROM_CREATION_DATE_ != null) {
sql += " and CREATION_DATE_ >= :FROM_CREATION_DATE_";
paramMap.put("FROM_CREATION_DATE_", FROM_CREATION_DATE_);
}
if (TO_CREATION_DATE_ != null) {
sql += " and CREATION_DATE_ <= :TO_CREATION_DATE_";
paramMap.put("TO_CREATION_DATE_", TO_CREATION_DATE_);
}
if (StringUtils.isNotEmpty(PROC_DEF_ID_)) {
sql += " and PROC_DEF_ID_ = :PROC_DEF_ID_";
paramMap.put("PROC_DEF_ID_", PROC_DEF_ID_);
}
if (PROC_DEF_ID_LIST != null && PROC_DEF_ID_LIST.size() > 0) {
sql += " and PROC_DEF_ID_ in (:PROC_DEF_ID_LIST)";
paramMap.put("PROC_DEF_ID_LIST", PROC_DEF_ID_LIST);
}
if (StringUtils.isNotEmpty(PROC_DEF_CODE_)) {
sql += " and PROC_DEF_CODE_ = :PROC_DEF_CODE_";
paramMap.put("PROC_DEF_CODE_", PROC_DEF_CODE_);
}
if (PROC_DEF_CODE_LIST != null && PROC_DEF_CODE_LIST.size() > 0) {
sql += " and PROC_DEF_CODE_ in (:PROC_DEF_CODE_LIST)";
paramMap.put("PROC_DEF_CODE_LIST", PROC_DEF_CODE_LIST);
}
if (StringUtils.isNotEmpty(PROC_DEF_NAME_)) {
sql += " and PROC_DEF_NAME_ like '%' || :PROC_DEF_NAME_ || '%'";
paramMap.put("PROC_DEF_NAME_", PROC_DEF_NAME_);
}
if (PROC_DEF_NAME_LIST != null && PROC_DEF_NAME_LIST.size() > 0) {
sql += " and PROC_DEF_NAME_ in (:PROC_DEF_NAME_LIST)";
paramMap.put("PROC_DEF_NAME_LIST", PROC_DEF_NAME_LIST);
}
if (StringUtils.isNotEmpty(PROC_DEF_CAT_)) {
sql += " and PROC_DEF_CAT_ like :PROC_DEF_CAT_ || '%'";
paramMap.put("PROC_DEF_CAT_", PROC_DEF_CAT_);
}
if (PROC_DEF_CAT_LIST != null && PROC_DEF_CAT_LIST.size() > 0) {
sql += " and PROC_DEF_CAT_ in (:PROC_DEF_CAT_LIST)";
paramMap.put("PROC_DEF_CAT_LIST", PROC_DEF_CAT_LIST);
}
if (VERSION_ != null) {
sql += " and VERSION_ = :VERSION_";
paramMap.put("VERSION_", VERSION_);
}
if (VERSION_LIST != null && VERSION_LIST.size() > 0) {
sql += " and VERSION_ in (:VERSION_LIST)";
paramMap.put("VERSION_LIST", VERSION_LIST);
}
if (StringUtils.isNotEmpty(PROC_DEF_STATUS_)) {
sql += " and PROC_DEF_STATUS_ = :PROC_DEF_STATUS_";
paramMap.put("PROC_DEF_STATUS_", PROC_DEF_STATUS_);
}
if (PROC_DEF_STATUS_LIST != null && PROC_DEF_STATUS_LIST.size() > 0) {
sql += " and PROC_DEF_STATUS_ in (:PROC_DEF_STATUS_LIST)";
paramMap.put("PROC_DEF_STATUS_LIST", PROC_DEF_STATUS_LIST);
}
if (!count) {
sql += " order by CREATION_DATE_ desc";
}
return new OdSqlCriteria(sql, paramMap);
}
@Override
public List> selectProcByIdList(List PROC_ID_LIST) {
if (PROC_ID_LIST == null || PROC_ID_LIST.size() == 0) {
return new ArrayList<>();
}
StringBuilder sql = new StringBuilder(PROC_ID_LIST.size() * 50 + 200);
Map paramMap = new HashMap();
sql.append("select * from FFV_PROC where PROC_ID_ in (:PROC_ID_LIST)");
paramMap.put("PROC_ID_LIST", PROC_ID_LIST);
sql.append(" order by DECODE(PROC_ID_,");// 按主键列表顺序排序
for (int i = 0; i < PROC_ID_LIST.size(); i++) {
sql.append(" '").append(PROC_ID_LIST.get(i)).append("', ").append(i);
if (i < PROC_ID_LIST.size() - 1) {
sql.append(",");
}
else {
sql.append(")");
}
}
NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(ffJdbcTemplate);
return namedParameterJdbcTemplate.queryForList(sql.toString(), paramMap);
}
@Override
public int insertProc(String PROC_ID_, String PROC_DEF_ID_, String ADJUST_PROC_DEF_ID_, String ISOLATE_SUB_PROC_NODE_ID_, String BIZ_ID_, String BIZ_TYPE_, String BIZ_CODE_, String BIZ_NAME_, String BIZ_DESC_, String PROC_START_USER_, String PROC_START_USER_NAME_, String PROC_END_USER_, String PROC_END_USER_NAME_, Date PROC_END_DATE_, String PROC_STATUS_, Date CREATION_DATE_) {
String sql = "insert into FF_PROC (PROC_ID_, PROC_DEF_ID_, ADJUST_PROC_DEF_ID_, ISOLATE_SUB_PROC_NODE_ID_, BIZ_ID_, BIZ_TYPE_, BIZ_CODE_, BIZ_NAME_, BIZ_DESC_, PROC_START_USER_, PROC_START_USER_NAME_, PROC_END_USER_, PROC_END_USER_NAME_, PROC_END_DATE_, PROC_STATUS_, CREATION_DATE_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
int count = ffJdbcTemplate.update(sql, PROC_ID_, PROC_DEF_ID_, ADJUST_PROC_DEF_ID_, ISOLATE_SUB_PROC_NODE_ID_, BIZ_ID_, BIZ_TYPE_, BIZ_CODE_, BIZ_NAME_, BIZ_DESC_, PROC_START_USER_, PROC_START_USER_NAME_, PROC_END_USER_, PROC_END_USER_NAME_, PROC_END_DATE_, PROC_STATUS_, CREATION_DATE_);
ffOperationService.insertProcOp(OdUtils.getUuid(), PROC_ID_, FfOperationService.OPERATION_TYPE_INSERT);
return count;
}
@Override
public int updateProc(String PROC_ID_, String PROC_DEF_ID_, String ADJUST_PROC_DEF_ID_, String ISOLATE_SUB_PROC_NODE_ID_, String BIZ_ID_, String BIZ_TYPE_, String BIZ_CODE_, String BIZ_NAME_, String BIZ_DESC_, String PROC_START_USER_, String PROC_START_USER_NAME_, String PROC_END_USER_, String PROC_END_USER_NAME_, Date PROC_END_DATE_) {
ffOperationService.insertProcOp(OdUtils.getUuid(), PROC_ID_, FfOperationService.OPERATION_TYPE_UPDATE);
String sql = "update FF_PROC set PROC_DEF_ID_ = ?, ADJUST_PROC_DEF_ID_ = ?, ISOLATE_SUB_PROC_NODE_ID_ = ?, BIZ_ID_ = ?, BIZ_TYPE_ = ?, BIZ_CODE_ = ?, BIZ_NAME_ = ?, BIZ_DESC_ = ?, PROC_START_USER_ = ?, PROC_START_USER_NAME_ = ?, PROC_END_USER_ = ?, PROC_END_USER_NAME_ = ?, PROC_END_DATE_ = ? where PROC_ID_ = ?";
return ffJdbcTemplate.update(sql, PROC_DEF_ID_, ADJUST_PROC_DEF_ID_, ISOLATE_SUB_PROC_NODE_ID_, BIZ_ID_, BIZ_TYPE_, BIZ_CODE_, BIZ_NAME_, BIZ_DESC_, PROC_START_USER_, PROC_START_USER_NAME_, PROC_END_USER_, PROC_END_USER_NAME_, PROC_END_DATE_, PROC_ID_);
}
@Override
public int updateProcBizInfo(String PROC_ID_, String BIZ_ID_, String BIZ_TYPE_, String BIZ_CODE_, String BIZ_NAME_, String BIZ_DESC_) {
ffOperationService.insertProcOp(OdUtils.getUuid(), PROC_ID_, FfOperationService.OPERATION_TYPE_UPDATE);
String sql = "update FF_PROC set BIZ_ID_ = ?, BIZ_TYPE_ = ?, BIZ_CODE_ = ?, BIZ_NAME_ = ?, BIZ_DESC_ = ? where PROC_ID_ = ?";
return ffJdbcTemplate.update(sql, BIZ_ID_, BIZ_TYPE_, BIZ_CODE_, BIZ_NAME_, BIZ_DESC_, PROC_ID_);
}
@Override
public int updateProcStatus(String PROC_ID_, String PROC_STATUS_) {
ffOperationService.insertProcOp(OdUtils.getUuid(), PROC_ID_, FfOperationService.OPERATION_TYPE_UPDATE);
String sql = "update FF_PROC set PROC_STATUS_ = ? where PROC_ID_ = ?";
return ffJdbcTemplate.update(sql, PROC_STATUS_, PROC_ID_);
}
@Override
public int updateProcStatus(String PROC_ID_, String PROC_END_USER_, String PROC_END_USER_NAME_, Date PROC_END_DATE_, String PROC_STATUS_) {
ffOperationService.insertProcOp(OdUtils.getUuid(), PROC_ID_, FfOperationService.OPERATION_TYPE_UPDATE);
String sql = "update FF_PROC set PROC_END_USER_ = ?, PROC_END_USER_NAME_ = ?, PROC_END_DATE_ = ?, PROC_STATUS_ = ? where PROC_ID_ = ?";
return ffJdbcTemplate.update(sql, PROC_END_USER_, PROC_END_USER_NAME_, PROC_END_DATE_, PROC_STATUS_, PROC_ID_);
}
@Override
public int deleteProc(String PROC_ID_) {
ffOperationService.insertProcOp(OdUtils.getUuid(), PROC_ID_, FfOperationService.OPERATION_TYPE_DELETE);
String sql = "delete from FF_PROC where PROC_ID_ = ?";
return ffJdbcTemplate.update(sql, PROC_ID_);
}
}
