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.
group.rober.dataform.mapper.impl.DataFormMapperDBTableImpl Maven / Gradle / Ivy
package group.rober.dataform.mapper.impl;
import group.rober.dataform.DataFormConsts;
import group.rober.dataform.exception.DataFormException;
import group.rober.dataform.mapper.*;
import group.rober.dataform.mapper.impl.po.DataFormElementPO;
import group.rober.dataform.mapper.impl.po.DataFormFilterPO;
import group.rober.dataform.mapper.impl.po.DataFormPO;
import group.rober.dataform.mapper.impl.po.FormElementValidatorPO;
import group.rober.dataform.model.DataForm;
import group.rober.dataform.model.DataFormElement;
import group.rober.dataform.model.DataFormFilter;
import group.rober.dataform.util.DataFormUtils;
import group.rober.runtime.kit.BeanKit;
import group.rober.runtime.kit.ListKit;
import group.rober.runtime.kit.MapKit;
import group.rober.runtime.kit.StringKit;
import group.rober.sql.core.DataAccessor;
import group.rober.sql.core.DataQuery;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.cache.annotation.CacheEvict;
import org.springframework.cache.annotation.Cacheable;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.StringUtils;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
/**
* 使用XML文件存储DataForm实体
* Created by tisir [email protected] on 2017-05-22
*/
public class DataFormMapperDBTableImpl implements DataFormMapper {
public static final String ELEMENTS_SQL = "SELECT * FROM FOWK_DATAFORM_ELEMENT where DATAFORM_ID=:dataFormId ORDER BY GROUP_ ASC,SORT_CODE ASC";
public static final String DATAFORM_SQL = "SELECT * from FOWK_DATAFORM ";
public static final String FILTER_SQL = "SELECT * from FOWK_DATAFORM_FILTER where DATAFORM_ID=:dataFormId";
public static final String ELEMENT_DELETE_SQL = "DELETE FROM FOWK_DATAFORM_ELEMENT where DATAFORM_ID=:dataFormId";
public static final String FILTER_DELETE_SQL = "DELETE FROM FOWK_DATAFORM_FILTER where DATAFORM_ID=:dataFormId";
public static final String VALIDATOR_DELETE_SQL = "DELETE FROM FOWK_DATAFORM_VALIDATOR where DATAFORM_ID=:dataFormId";
public static final String VALIDATOR_SELECT_SQL = "SELECT * FROM FOWK_DATAFORM_VALIDATOR where DATAFORM_ID=:dataFormId and ELEMENT_CODE=:elementCode order by CODE ASC";
@Autowired
protected DataAccessor dataAccessor;
@Autowired
private DataFormDBRowMapper dataFormDBRowMapper;
@Autowired
private DataFormElementDBRowMapper dataFormElementDBRowMapper;
@Autowired
private DataFormFilterDBRowMapper dataFormFilterDBRowMapper;
@Autowired
private DataFormValidatorRowMapper dataFormValidatorRowMapper;
@Autowired
private DataFormMapperDBTableImpl _this;
/**
* 清空缓存
*/
@CacheEvict(value= DataFormConsts.CACHE_KEY,allEntries=true,beforeInvocation=true)
public void clearCacheAll(){
}
/**
* 清空缓存
*/
@CacheEvict(value=DataFormConsts.CACHE_KEY,key="#formId",beforeInvocation=true)
public void clearCacheItem(String formId){
}
@Override
public boolean exists(String id) {
return dataAccessor.selectExistsById(DataForm.class, id);
}
@Cacheable(value=DataFormConsts.CACHE_KEY,key="#id")
public DataForm getDataForm(String id) {
String dataFormSQL = DATAFORM_SQL + "where ID=:id";
//dataform自定义映射器
// dataAccessor.getDataQuery().setRowMapper(dataFormDBRowMapper);
// DataForm dataForm = dataAccessor
// .selectOne(DataForm.class, dataFormSQL,"id",id);
DataQuery dataQuery = dataAccessor.getDataQuery();
DataForm dataForm = dataQuery.exec(dataFormDBRowMapper,()->{
return dataQuery.selectOne(DataForm.class, dataFormSQL,"id",id);
});
if(dataForm==null)throw new DataFormException("DataForm={0} not exists",id);
fillDataFormFilters(dataForm);
fillDataFormElements(dataForm);
return dataForm;
}
private void fillDataFormElements(DataForm dataForm){
// dataAccessor.getDataQuery().setRowMapper(dataFormElementDBRowMapper);
// List elementPOList = dataAccessor
// .selectList(DataFormElement.class,ELEMENTS_SQL,"dataFormId", dataForm.getId());
DataQuery dataQuery = dataAccessor.getDataQuery();
List elementPOList = dataQuery.exec(dataFormElementDBRowMapper,()->{
return dataQuery.selectList(DataFormElement.class,ELEMENTS_SQL,"dataFormId", dataForm.getId());
});
for(DataFormElement element : elementPOList){
dataForm.addElement(element);
fillElementValidators(element);
}
}
private void fillDataFormFilters(DataForm dataForm){
//filter自定义映射器
// dataAccessor.getDataQuery().setRowMapper(dataFormFilterDBRowMapper);
// List filters = dataAccessor
// .selectList(DataFormFilter.class,FILTER_SQL,"dataFormId", dataForm.getId());
DataQuery dataQuery = dataAccessor.getDataQuery();
List filters = dataQuery.exec(dataFormFilterDBRowMapper,()->{
return dataQuery.selectList(DataFormFilter.class,FILTER_SQL,"dataFormId", dataForm.getId());
});
for(DataFormFilter filter : filters){
dataForm.addFilter(filter);
}
}
public void fillElementValidators(DataFormElement element){
Map param = MapKit.mapOf("dataFormId",element.getDataformId()
,"elementCode",element.getCode());
// dataAccessor.getDataQuery().setRowMapper(dataFormValidatorRowMapper);
// List validators = dataAccessor.selectList(DataFormElement.FormElementValidator.class,
// VALIDATOR_SELECT_SQL,param);
DataQuery dataQuery = dataAccessor.getDataQuery();
List validators = dataQuery.exec(dataFormValidatorRowMapper,()->{
return dataQuery.selectList(DataFormElement.FormElementValidator.class,VALIDATOR_SELECT_SQL,param);
});
element.setValidatorList(validators);
}
public DataForm getDataForm(String pack, String code) {
String dataFormId = StringKit.format("{0}-{1}", pack, code);
return _this.getDataForm(dataFormId);
}
public List getDataFormsByPack(String pack) {
StringBuilder dataFormSqlBuilder = new StringBuilder(DATAFORM_SQL);
// dataAccessor.getDataQuery().setRowMapper(dataFormDBRowMapper);
// List dataFormList = null;
// if (!StringUtils.isEmpty(pack)) {
// dataFormSqlBuilder.append("where PACK = :pack");
// dataFormList = dataAccessor.selectList(DataForm.class, dataFormSqlBuilder.toString(),
// MapKit.mapOf("pack", pack));
// } else {
// dataFormList = dataAccessor.selectList(DataForm.class, dataFormSqlBuilder.toString());
// }
DataQuery dataQuery = dataAccessor.getDataQuery();
List dataFormList = dataQuery.exec(dataFormDBRowMapper,()->{
if (!StringUtils.isEmpty(pack)) {
dataFormSqlBuilder.append("where PACK = :pack");
return dataQuery.selectList(DataForm.class, dataFormSqlBuilder.toString(),
MapKit.mapOf("pack", pack));
} else {
return dataQuery.selectList(DataForm.class, dataFormSqlBuilder.toString());
}
});
dataFormList.forEach(dataForm -> {
fillDataFormFilters(dataForm);
});
dataFormList.forEach(dataForm -> {
fillDataFormElements(dataForm);
});
return dataFormList;
}
public List getAllDataForms() {
return getDataFormsByPack(null);
}
@Transactional
public int save(DataForm dataForm) {
_this.clearCacheItem(dataForm.getId());
DataFormPO dataFormPO = new DataFormPO();
BeanKit.copyProperties(dataForm, dataFormPO);
BeanKit.copyProperties(dataForm.getFormUIHint(), dataFormPO);
if (dataForm.getQuery() != null) {
BeanKit.copyProperties(dataForm.getQuery(), dataFormPO);
}
String dataFormId = StringKit.format("{0}-{1}", dataForm.getPack(), dataForm.getCode());
dataFormPO.setId(dataFormId);
List elementPOList = ListKit.newArrayList();
List validatorPOList = new ArrayList();
for (DataFormElement element : dataForm.getElements()) {
DataFormElementPO elementPO = DataFormUtils.convertElementPO(element);
elementPO.setDataformId(dataFormPO.getId());
List validatorPOs = DataFormUtils.convertValidatorPO(
element,dataFormPO.getId());
validatorPOList.addAll(validatorPOs);
elementPOList.add(elementPO);
}
List dataFormFilterPOList = ListKit.newArrayList();
for (DataFormFilter filter : dataForm.getFilters()) {
DataFormFilterPO filterPO = new DataFormFilterPO();
BeanKit.copyProperties(filter, filterPO);
filterPO.setDataformId(dataFormPO.getId());
filterPO.setEnabled(filter.getEnabled() ? "Y" : "N");
filterPO.setQuick(filter.getQuick() ? "Y" : "N");
dataFormFilterPOList.add(filterPO);
}
dataAccessor.execute(FILTER_DELETE_SQL,MapKit.mapOf("dataFormId",dataFormId));
dataAccessor.execute(ELEMENT_DELETE_SQL,MapKit.mapOf("dataFormId",dataFormId));
dataAccessor.execute(VALIDATOR_DELETE_SQL,MapKit.mapOf("dataFormId",dataFormId));
int r = 0;
r += dataAccessor.save(dataFormPO);
r += dataAccessor.insert(dataFormFilterPOList);
r += dataAccessor.insert(elementPOList);
r += dataAccessor.insert(validatorPOList);
return r;
}
@Transactional
public int saveDataFormElement(DataFormElement element){
int r = 0;
String dataformId = element.getDataformId();
_this.clearCacheItem(dataformId);
DataFormElementPO elementPO = DataFormUtils.convertElementPO(element);
elementPO.setDataformId(dataformId);
r += dataAccessor.save(elementPO);
//先删除所有的校验规则
String deleteValidators = "DELETE FROM FOWK_DATAFORM_VALIDATOR where DATAFORM_ID=:dataFormId and ELEMENT_CODE=:elementCode";
dataAccessor.execute(deleteValidators,
MapKit.mapOf("dataFormId",dataformId
,"elementCode",element.getCode())
);
//再保存所有的校验规则
List validatorPOs = DataFormUtils
.convertValidatorPO(element,dataformId);
r += dataAccessor.save(validatorPOs);
return r;
}
public int delete(String id) {
_this.clearCacheItem(id);
String dataFormDelete = "DELETE FROM FOWK_DATAFORM where ID=:id";
int r = 0;
r += dataAccessor.execute(dataFormDelete,MapKit.mapOf("id",id));
r += dataAccessor.execute(ELEMENT_DELETE_SQL,MapKit.mapOf("dataFormId",id));
r += dataAccessor.execute(FILTER_DELETE_SQL,MapKit.mapOf("dataFormId",id));
r += dataAccessor.execute(VALIDATOR_DELETE_SQL,MapKit.mapOf("dataFormId",id));
return r;
}
@Override
public int deleteAll() {
_this.clearCacheAll();
String dataFormDelete = "DELETE FROM FOWK_DATAFORM";
String ELEMENT_DELETE_SQL = "DELETE FROM FOWK_DATAFORM_ELEMENT";
String FILTER_DELETE_SQL = "DELETE FROM FOWK_DATAFORM_FILTER";
String VALIDATOR_DELETE_SQL = "DELETE FROM FOWK_DATAFORM_VALIDATOR";
int r = dataAccessor.execute(dataFormDelete);
dataAccessor.execute(ELEMENT_DELETE_SQL);
dataAccessor.execute(FILTER_DELETE_SQL);
dataAccessor.execute(VALIDATOR_DELETE_SQL);
return r;
}
public int delete(String pack, String code) {
String dataFormId = StringKit.format("{0}-{1}", pack, code);
return delete(dataFormId);
}
}
