com.litongjava.table.services.DbTableService Maven / Gradle / Ivy
The newest version!
package com.litongjava.table.services;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;
import com.litongjava.db.activerecord.Db;
import com.litongjava.table.model.DbTableStruct;
public class DbTableService {
private DbService dbService = new DbService();
private PrimaryKeyService primaryKeyService = new PrimaryKeyService();
public List> columns(String f) {
List columns = dbService.getTableStruct(Db.use(), f);
List> tableItems = new ArrayList<>(columns.size());
for (DbTableStruct record : columns) {
String field = record.getField();
String fieldType = record.getType();
// {name: 'Name', key: 'name', type: 'el-input', placeholder: '请输入 Name'},
String name = getName(field);
String type = getType(fieldType);
if (type.equals("date")) {
type = "dateTime";
} else if (type.equals("text")) {
type = "textarea";
} else {
type = "text";
}
Map tableItem = new LinkedHashMap<>();
tableItem.put("title", name);
tableItem.put("dataIndex", field);
tableItem.put("valueType", type);
tableItems.add(tableItem);
}
return tableItems;
}
/**
* 获取表格配置信息
*
* @param tableName
* @param lang
* @return
*/
public Map getTableConfig(String f, String tableName, String lang) {
List columns = dbService.getTableStruct(Db.use(), tableName);
List> queryItems = new ArrayList<>(columns.size());
List> tableItems = new ArrayList<>(columns.size());
List> formItems = new ArrayList<>(columns.size());
Map operator = new LinkedHashMap<>();
for (DbTableStruct record : columns) {
String field = record.getField();
String fieldType = record.getType();
// {name: 'Name', key: 'name', type: 'el-input', placeholder: '请输入 Name'},
String name = getName(field);
String key = getKey(field, false);
String type = getType(fieldType);
Map queryItem = new LinkedHashMap<>();
queryItem.put("name", name);
queryItem.put("key", key);
queryItem.put("type", type);
queryItem.put("show", true);
Map tableItem = new LinkedHashMap<>();
tableItem.put("name", name);
tableItem.put("key", key);
tableItem.put("type", type);
tableItem.put("align", "center");
tableItem.put("show", true);
Map formItem = new LinkedHashMap<>();
formItem.put("name", name);
formItem.put("key", key);
formItem.put("type", type);
formItem.put("show", true);
if ("date".equals(type)) {
operator.put(key + "Op", "bt");
queryItem.put("prop", getQueryItemDateProp(lang));
formItem.put("prop", getFormItemDateProp(lang));
} else {
queryItem.put("placeholder", getPlaceholder(name, lang));
formItem.put("placeholder", getPlaceholder(name, lang));
if (fieldType.startsWith("varchar")) {
operator.put(key + "Op", "ew");
}
}
queryItems.add(queryItem);
tableItems.add(tableItem);
formItems.add(formItem);
}
String primaryKeyName = primaryKeyService.getPrimaryKeyName(tableName);
String primaryKeyColumnType = primaryKeyService.getPrimaryKeyColumnType(tableName);
LinkedHashMap query = new LinkedHashMap();
query.put("show", false);
query.put("items", queryItems);
query.put("operator", operator);
query.put("button", getButton(lang));
LinkedHashMap toolBar = new LinkedHashMap();
toolBar.put("show", true);
toolBar.put("addButtonShow", true);
toolBar.put("exportButtonShow", true);
toolBar.put("exportAllButtonShow", true);
toolBar.put("addButtonName", getAddButtonName(lang));
toolBar.put("exportButtonName", getExportButtonName(lang));
toolBar.put("exportAllButtonName", getExportAllButtonName(lang));
LinkedHashMap table = new LinkedHashMap();
table.put("selectionShow", true);
table.put("numberShow", true);
table.put("items", tableItems);
table.put("operation", getOperation(lang));
LinkedHashMap form = new LinkedHashMap();
form.put("width", "1000px");
form.put("labelWidth", "150px");
form.put("items", formItems);
form.put("button", getFormButton(lang));
Map config = new LinkedHashMap<>();
config.put("f", f);
config.put("idName", primaryKeyName);
config.put("idType", primaryKeyColumnType);
config.put("tableAlias", getName(tableName));
config.put("pageUri", "/api/table/" + f + "/page");
config.put("getUri", "/api/table/" + f + "/get");
config.put("createUri", "/api/table/" + f + "/create");
config.put("updateUri", "/api/table/" + f + "/update");
config.put("deleteUri", "/api/table/" + f + "/delete");
config.put("exportExcelUri", "/api/table/" + f + "/export-excel");
config.put("exportTableExcelUri", "/api/table/" + f + "/export-table-excel");
config.put("query", query);
config.put("toolBar", toolBar);
config.put("table", table);
config.put("form", form);
return config;
}
private Map getButton(String lang) {
HashMap hashMap = new LinkedHashMap();
if ("zh-CN".equals(lang)) {
hashMap.put("queryButtonName", "查询");
hashMap.put("resetButtonName", "重置");
} else {
hashMap.put("queryButtonName", "Query");
hashMap.put("resetButtonName", "Reset");
}
return hashMap;
}
private Object getFormButton(String lang) {
HashMap hashMap = new LinkedHashMap();
if ("zh-CN".equals(lang)) {
hashMap.put("confimButtonName", "确认");
hashMap.put("cancelButtonName", "取消");
} else {
hashMap.put("confimButtonName", "Comfirm");
hashMap.put("cancelButtonName", "Cancel");
}
return hashMap;
}
/**
* create_time 转为 Create Time
*
* @param field
* @return
*/
private String getName(String field) {
return Arrays.stream(field.split("_")).map(word -> word.substring(0, 1).toUpperCase() + word.substring(1)).collect(Collectors.joining(" "));
}
/**
* create_time 转为 createTime
*
* @param field
* @return
*/
private String getKey(String field, boolean toCamel) {
if (toCamel) {
String[] words = field.split("_");
StringBuilder key = new StringBuilder(words[0]);
for (int i = 1; i < words.length; i++) {
key.append(Character.toUpperCase(words[i].charAt(0))).append(words[i].substring(1));
}
return key.toString();
} else {
return field;
}
}
private String getPlaceholder(String name, String lang) {
if ("zh-CN".equals(lang)) {
return "请输入 " + name;
} else {
return "Please Input " + name;
}
}
private String getType(String type) {
if (type.startsWith("date") || type.startsWith("timestamp") || type.startsWith("datetime")) {
return "date";
} else if ("tinyint(1)".equals(type)) {
return "bool";
} else if ("int".equals(type) || "integer".equals(type)) {
return "int";
} else if ("smallint".equals(type)) {
return "short";
} else if ("bigint".equals(type)) {
return "long";
} else {
return "varchar";
}
}
private Map getQueryItemDateProp(String lang) {
Map hashMap = new LinkedHashMap();
hashMap.put("type", "daterange");
hashMap.put("valueFormat", "yyyy-MM-dd HH:mm:ss");
hashMap.put("rangeSeparator", "-");
if ("zh-CN".equals(lang)) {
hashMap.put("startPlaceholder", "开始日期");
hashMap.put("endPlaceholder", "结束日期");
} else {
hashMap.put("startPlaceholder", "Start Date");
hashMap.put("endPlaceholder", "End Date");
}
hashMap.put("defaultTime", new String[] { "00:00:00", "23:59:59" });
return hashMap;
}
private Map getFormItemDateProp(String lang) {
Map hashMap = new LinkedHashMap();
hashMap.put("type", "datetime");
//hashMap.put("valueFormat", "yyyy-MM-dd HH:mm:ss");
hashMap.put("valueFormat", "timestamp");
return hashMap;
}
private Map getOperation(String lang) {
HashMap hashMap = new LinkedHashMap<>();
hashMap.put("show", true);
hashMap.put("align", "right");
hashMap.put("updateButtonShow", true);
hashMap.put("deleteButtonShow", true);
if ("zh-CN".equals(lang)) {
hashMap.put("updateButtonName", "修改");
hashMap.put("deleteButtonName", "删除");
} else {
hashMap.put("updateButtonName", "Edit");
hashMap.put("deleteButtonName", "Delete");
}
return hashMap;
}
private String getAddButtonName(String lang) {
if ("zh-CN".equals(lang)) {
return "增加";
} else {
return "Add";
}
}
private String getExportButtonName(String lang) {
if ("zh-CN".equals(lang)) {
return "导出";
} else {
return "Export";
}
}
private Object getExportAllButtonName(String lang) {
if ("zh-CN".equals(lang)) {
return "全部导出";
} else {
return "Export All";
}
}
public String getFieldType(String f, String key) {
List columns = dbService.getTableStruct(Db.use(), f);
for (DbTableStruct record : columns) {
String field = record.getField();
String fieldType = record.getType();
if (key.equals(field)) {
return getType(fieldType);
}
}
return null;
}
}