All Downloads are FREE. Search and download functionalities are using the official Maven repository.
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.service.impl.DataFormAdminServiceDBImpl Maven / Gradle / Ivy
package group.rober.dataform.service.impl;
import group.rober.dataform.dto.CloneDataFormBean;
import group.rober.dataform.exception.DataFormException;
import group.rober.dataform.mapper.DataFormDBRowMapper;
import group.rober.dataform.mapper.DataFormElementDBRowMapper;
import group.rober.dataform.mapper.DataFormFilterDBRowMapper;
import group.rober.dataform.mapper.DataFormMapper;
import group.rober.dataform.mapper.DataFormValidatorRowMapper;
import group.rober.dataform.mapper.impl.DataFormMapperDBTableImpl;
import group.rober.dataform.model.DataForm;
import group.rober.dataform.model.DataFormElement;
import group.rober.dataform.model.DataFormFilter;
import group.rober.dataform.model.DataFormStamp;
import group.rober.dataform.service.DataFormAdminServiceAbstract;
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.runtime.lang.ValueObject;
import group.rober.sql.autoconfigure.SqlProperties;
import group.rober.sql.core.DataQuery;
import group.rober.sql.core.PaginationData;
import group.rober.sql.core.PaginationQuery;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.StringUtils;
import java.util.Arrays;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.function.BiConsumer;
/**
* Created by luyu on 2017/12/25.
*/
public class DataFormAdminServiceDBImpl extends DataFormAdminServiceAbstract {
@Autowired
private DataQuery dataQuery;
@Autowired
private DataFormDBRowMapper dataFormDBRowMapper;
@Autowired
private DataFormMapper dataFormMapper;
public List getDataForms() {
List dataForms = dataQuery.exec(dataFormDBRowMapper,()->{
return dataQuery
.selectList(DataForm.class, "select * from FOWK_DATAFORM ORDER BY SORT_CODE ASC,PACK ASC,CODE ASC");
});
return dataForms;
}
public DataForm getDataForm(String id) {
DataForm dataForm = dataFormMapper.getDataForm(id);
return dataForm;
}
@Transactional
public DataForm saveDataForm(DataForm dataForm, String oldDataFormId) {
String newDataFormId = StringKit.format("{0}-{1}", dataForm.getPack(), dataForm.getCode());
dataFormMapper.save(dataForm);
if (!StringUtils.isEmpty(oldDataFormId) && !newDataFormId.equals(oldDataFormId)) {
dataFormMapper.delete(oldDataFormId);
}
return dataForm;
}
@Transactional
public DataForm cloneDataForm(CloneDataFormBean cloneDataFormBean) {
String[] dataFormInfo = cloneDataFormBean.getNewDataFormId().split("-");
if (dataFormInfo.length != 2) {
throw new DataFormException("dataForm format error");
}
String dataFormSQL = DataFormMapperDBTableImpl.DATAFORM_SQL + "where ID=:id";
DataForm newDataForm = dataQuery.exec(dataFormDBRowMapper,()->{
return dataQuery.selectOne(DataForm.class, dataFormSQL, "id", cloneDataFormBean.getNewDataFormId());
});
if (newDataForm != null) {
throw new DataFormException("new dataFormId has existed");
}
DataForm oldDataForm = dataFormMapper.getDataForm(cloneDataFormBean.getOldDataFormId());
DataForm cloneDataForm = BeanKit.deepClone(oldDataForm);
cloneDataForm.setId(cloneDataFormBean.getNewDataFormId());
cloneDataForm.setName("copyof" + oldDataForm.getName());
dataFormMapper.save(cloneDataForm);
return cloneDataForm;
}
public DataFormElement getDataFormElementDetail(String dataformId, String code) {
DataForm dataForm = getDataForm(dataformId);
return dataForm.getElement(code);
}
@Transactional
public DataFormElement saveDataFormElement(DataFormElement element, String dataFormId) {
dataFormMapper.saveDataFormElement(element);
return element;
}
public PaginationData getPageDataForms(Integer size, Integer index,
Map filterMap, Map sortMap) {
StringBuffer sqlBuffer = new StringBuffer("select * from FOWK_DATAFORM");
Map queryParameters = MapKit.newHashMap();
String filterSql = this.parseFilterFillParam(queryParameters, filterMap);
sqlBuffer.append(filterSql);
String orderSql = this.parseOrderBySql(sortMap);
sqlBuffer.append(orderSql);
PaginationQuery query = new PaginationQuery();
query.setQuery(sqlBuffer.toString());
query.setIndex(index);
query.setSize(size);
query.getParameterMap().putAll(queryParameters);
return dataQuery.exec(dataFormDBRowMapper,()->{
return dataQuery.selectListPagination(DataForm.class, query);
});
}
private String parseOrderBySql(Map sortMap) {
StringBuffer sqlBuffer = new StringBuffer();
List orderBySqlList = ListKit.newArrayList();
if (sortMap != null && sortMap.size() > 0) {
sqlBuffer.append(" order by ");
Iterator iterator = sortMap.keySet().iterator();
while (iterator.hasNext()) {
String code = iterator.next();
ValueObject value = ValueObject.valueOf(sortMap.get(code));
String condItem = buildOrderBySQL(code, value);
orderBySqlList.add(condItem);
}
}
return sqlBuffer.append(orderBySqlList.stream().reduce((s1, s2) -> s1 + "," + s2).get()).toString();
}
private String buildOrderBySQL(String code, ValueObject value) {
StringBuffer filterBuffer = new StringBuffer();
filterBuffer.append(underLining(code)).append(" " + value.strValue());
return filterBuffer.toString();
}
private String parseFilterFillParam(Map param, Map filterParameters) {
StringBuffer filterBuffer = new StringBuffer();
filterParameters.remove("_");
if (filterParameters != null && filterParameters.size() > 0) {
filterBuffer.append(" Where ");
Iterator iterator = filterParameters.keySet().iterator();
List condItems = ListKit.newArrayList();
while (iterator.hasNext()) {
String code = iterator.next();
ValueObject value = ValueObject.valueOf(filterParameters.get(code));
String condItem = buildFilterSQL(code, value, param);
condItems.add(condItem);
}
String FilterSql = condItems.stream().reduce((s1, s2) -> s1 + " and " + s2).get();
filterBuffer.append(FilterSql);
}
return filterBuffer.toString();
}
private String buildFilterSQL(String code, ValueObject value, Map param) {
Map paramMap = (Map) param;
StringBuffer filterBuffer = new StringBuffer();
filterBuffer.append(underLining(code)).append(" LIKE ").append(":").append(code);
paramMap.put(code, "%" + value.strValue() + "%");
return filterBuffer.toString();
}
public void deleteDataForm(String dataFormId) {
dataFormMapper.delete(dataFormId);
}
public void deleteAll() {
dataFormMapper.deleteAll();
}
private String underLining(String str) {
if (StringUtils.isEmpty(str)) {
return "";
}
String returnValue = str.substring(0, 1).toLowerCase() + str.substring(1);
String[] ss = str.split("(? 1) {
List list = Arrays.asList(ss);
returnValue = list.stream()
.reduce((s1, s2) -> lowerCaseFirstLetter(s1) + "_" + lowerCaseFirstLetter(s2))
.get();
}
return returnValue;
}
public static String lowerCaseFirstLetter(String name) {
if (StringUtils.isEmpty(name)) {
return "";
}
return name.substring(0, 1).toLowerCase() + name.substring(1);
}
}
