/*
|
* 生成3类型窗体文件，生成路径已系统菜单为准，文件为formID_file.jsp为准。
|
* xiangluan
|
* 2010-04-16
|
*/
|
package com.yc.service.build.type.v2;
|
|
import com.yc.action.grid.GridUtils;
|
import com.yc.api.bean.T9685Entity;
|
import com.yc.api.service.ApiServiceIfc;
|
import com.yc.exception.ApplicationException;
|
import com.yc.factory.FactoryBean;
|
import com.yc.service.BaseService;
|
import com.yc.service.sqlformat.entity.SqlFormatEntity;
|
import com.yc.service.sqlformat.utils.SqlFormatUtils;
|
import com.yc.service.tree.TreeIfc;
|
import org.apache.commons.lang.StringUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
@Service("V3")
|
public class T_3_Impl extends BaseImpl implements T_3_Ifc {
|
|
|
@Autowired
|
private TreeIfc treeIfc;
|
@Autowired
|
private ApiServiceIfc apiServiceIfc;
|
|
@Override
|
public int build(BaseBean baseBean) throws Exception {
|
// 读取gform表的信息
|
Map<String, Object> gformInfo = this.init(baseBean);
|
Map<String, Object> treeSet = null;
|
List<Map<String, Object>> treeSetList = treeIfc.getTreeSet(baseBean.formID, baseBean.type);
|
if (treeSetList != null) {
|
if(treeSetList.size()==0)
|
throw new ApplicationException("请在【9824】对"+baseBean.formID+"树形相关参数进行配置");
|
treeSet = treeSetList.get(0);
|
}
|
String autoCodeColumn = treeIfc.getAutoCodeColumn(baseBean.formID);
|
String autoCodeConfig = treeIfc.getAutoCodeConfig(baseBean.formID);
|
if (treeSet.get("treewidth") != null && !StringUtils.isBlank(treeSet.get("treewidth").toString())) {// 判断属性边框宽度是否设置
|
int trwidth = 0;
|
if (treeSet.get("treewidth").toString().indexOf("%") != -1) {
|
trwidth = Integer.parseInt(treeSet.get("treewidth").toString().replace("%", "0"));
|
trwidth = trwidth + 60;
|
} else {
|
trwidth = Integer.parseInt(treeSet.get("treewidth").toString());
|
}
|
trwidth = trwidth > 0 ? trwidth : 300;
|
gformInfo.put("treewidth", trwidth + "px");
|
} else {
|
gformInfo.put("treewidth", "300px");// 没有设置的情况默认300px
|
}
|
//----查找树节点id,通过treefromid再查一次9824树本身的nodeid，detailNodeid是格线里的字段，在这里做一个转换
|
//把之前nodeid的值用树自身的nodeid代替。
|
BaseService baseService = (BaseService) FactoryBean.getBean("BaseService");
|
for (Map map : treeSetList) {//修改对应的值,nodeid是树节点字段,detailNodeid是格线字段
|
String nodeid = baseService.getJdbcTemplate().queryForObject(" select nodeid from _sysTreeSet where formid=? ", String.class, GridUtils.prossRowSetDataType_String(map, "treeformid"));
|
|
map.put("detailNodeid", GridUtils.prossRowSetDataType_String(map, "nodeid"));
|
map.put("nodeid", nodeid);
|
}
|
//----------
|
buildDataHead(gformInfo);
|
buildTop(gformInfo);
|
buildHelpPage(gformInfo);
|
buildJsCssHead(treeSetList, baseBean);
|
buildGrid(baseBean);
|
buildTreeData(treeSetList, gformInfo, autoCodeColumn, autoCodeConfig);
|
buildFoolter(baseBean);
|
buildIndex(gformInfo);
|
|
return 0;
|
}
|
|
/**
|
* 生成js css 导入的页面
|
*
|
* @throws Exception
|
*/
|
public void buildJsCssHead(List<Map<String, Object>> treeSetList, BaseBean baseBean) throws Exception {
|
String fileName = "jsCssHead.jsp";
|
String data = getPageCode(fileName, baseBean);
|
// ----------------
|
|
Map<String, Map> treeList = new HashMap<>();//保存多树的设置信息
|
for (Map treeSet : treeSetList) {
|
Map<String, String> tree = new HashMap<>();//保存树的设置信息
|
// Map treeSet=treeSetList.get(0);
|
////data = data.replace("[?autocode]", autoCodeColumn);
|
//data = data.replace("[?autocodeConfig]", autoCodeConfig);
|
tree.put("displayfield", trim(treeSet.get("displayfield")).toLowerCase());
|
tree.put("nodeid", trim(treeSet.get("nodeid")).toLowerCase());
|
tree.put("separatedst", trim(treeSet.get("separatedst")));
|
tree.put("detailNodeid", trim(treeSet.get("detailNodeid")));
|
//
|
String treeFormid = trim(treeSet.get("treeformid"));
|
String treeFormType = baseBean.type + "";
|
if (!treeFormid.equals(baseBean.formID + "")) {
|
List<Map<String, Object>> refTypes = treeIfc.getTreeSetByFormid("formtype", treeFormid);
|
if (refTypes.size() > 0) {
|
treeFormType = trim(refTypes.get(0).get("formtype"));
|
}
|
}
|
tree.put("treeFormId", treeFormid);
|
tree.put("treeFormType", treeFormType);
|
treeList.put(treeFormid, tree);
|
//
|
// String columns = gformIfc.getColumns(Integer.parseInt(formID), true);
|
//data = data.replace("[?columns]", "[" + columns + "]");
|
}
|
data = data.replace("[?trees]", GridUtils.toJson(treeList));
|
//增加树过滤条件，作为参数传到后台执行
|
BaseService baseService = (BaseService) FactoryBean.getBean("BaseService");
|
Map treefilterstr = baseService.getSimpleJdbcTemplate().queryForMap(" select top 1 formid,formtype,treeformid,treeName,SortID,keyfield,parentfield,nodeid,listfield,displayfield,separatedst,treefield,autocodefield,treefilterstr,authcheck,allowdrag,defNodeTypeFilter,startnodetypefilter,treewidth from _sysTreeSet where formid=? ", baseBean.getFormID());
|
final SqlFormatEntity sqlFormatByEntity = SqlFormatUtils.createSQLFormatByEntity(treefilterstr, 9824);
|
data = data.replace("[?treefilterstr]", sqlFormatByEntity==null?"null":GridUtils.toJson(sqlFormatByEntity));
|
buildPageCode(data, fileName, baseBean);
|
}
|
|
/**
|
* 生成TreeData页面
|
*
|
* @throws Exception
|
*/
|
public void buildTreeData(List<Map<String, Object>> treeSetList, Map<String, Object> gformInfo, String autoCodeColumn, String autoCodeConfig) throws Exception {
|
BaseBean baseBean = (BaseBean) gformInfo.get(BEAN_INFO);
|
String formID = baseBean.formID;
|
Map<String, Map> treeList = new HashMap<>();//保存多树的设置信息
|
String treeFormids = "";
|
for (Map treeSet : treeSetList) {
|
|
if (StringUtils.isBlank((String) treeSet.get("nodeid"))) {
|
throw new RuntimeException("3类型树功能号：" + formID + "生成有误。在树设置9824功能号中，[节点字段]字段不能为空，该字段用于配置显示节点信息，必需要配置该字段才能生成！");
|
}
|
if (treeSet.get("treeformid") == null) {
|
throw new RuntimeException("3类型树功能号：" + formID + "生成有误。在树设置9824功能号中，[树功能号]字段不能为空，该字段用于引用2类型树，必须需要配置该字段才能生成！");
|
}
|
if (StringUtils.isBlank((String) treeSet.get("displayfield"))) {
|
throw new RuntimeException("3类型树功能号：" + formID + "生成有误。在树设置9824功能号中，[显示字段列表]字段不能为空，必需要配置该字段才能生成！");
|
}
|
// 树功能号
|
String treeFormid = treeSet.get("treeformid").toString();
|
// 功能号主表名
|
String str_tableName = null;
|
if (!treeFormid.equals(formID)) {// 如果树功能号不等于当前功能号
|
List<Map<String, Object>> refTypes = treeIfc.getTreeSetByFormid("formtype", treeFormid);
|
if (refTypes.size() == 0 || refTypes.size() > 1) {
|
throw new RuntimeException("3类型树功能号：" + formID + "生成有误。在树设置9824功能号中所对应的功能号没有或有多个！");
|
}
|
int treeFormidType = 0;
|
if (refTypes.get(0).get("formtype") != null) {
|
treeFormidType = (Integer) refTypes.get(0).get("formtype");
|
}
|
Map<String, Object> tmp = gformIfc.getGformInfo(treeFormidType == 20 ? "dttable" : "hdtable", Integer.parseInt(treeFormid));
|
str_tableName = tmp.get(treeFormidType == 20 ? "dttable" : "hdtable").toString();
|
} else {
|
str_tableName = gformInfo.get("hdtable").toString();
|
}
|
|
if (StringUtils.isBlank(str_tableName)) {
|
throw new RuntimeException("3类型树功能号：" + formID + "生成有误。在树设置9824功能号中，[树功能号]字段所对应的功能号的主表字段为空！");
|
}
|
// 功能号过滤条件--树显示是用树设置的过滤条件
|
// String str_formdatafilters = gformInfo.get("formdatafilters")==null?"":gformInfo.get("formdatafilters").toString();
|
// 生成第一层节点查询sql
|
// 主键字段名
|
String primayKey = "";
|
String firstNodeSql = treeIfc.buildFirstLayerTreeSQL(treeSet, str_tableName, primayKey);// 树的查询sql
|
// if(!"".equals(trim(gformInfo.get("formdatafilters")))){
|
// firstNodeSql+=" and ("+gformInfo.get("formdatafilters")+")";
|
// }
|
|
|
String sql = trim(treeIfc.buildTreeSQLNotFilter(treeSet, str_tableName, primayKey));// 树节点信息查询sql
|
String querySql = trim(treeIfc.buildQueryTreeSQL(treeSet, str_tableName, primayKey));// 树的查询sql
|
//格线对应的字段，用作查询格线时的参数名称
|
String detailNodeid = treeSet.get("detailNodeid").toString().trim();
|
// 显示字段
|
String displayfield = treeSet.get("displayfield").toString().trim();
|
// 分割符
|
String separatedst = treeSet.get("separatedst") == null ? "" : treeSet.get("separatedst").toString();
|
String nodeid = GridUtils.prossRowSetDataType_String(treeSet, "nodeid");
|
//格线取第一个节点作为第一次加载时的条件 By dananus
|
String tempNode = this.getSimpleJdbcTemplate().queryForObject(" set nocount on ; declare @fieldid varchar(50);select top 1 @fieldid = fieldid from gfield where formid = ? and initvalue = ?;select @fieldid;", String.class, formID, nodeid);
|
if (tempNode == null) {
|
throw new ApplicationException("由于在9824设置了树功能号为【" + treeFormid + "】的节点字段【" + nodeid + "】,因此必须在9802中设置【" + formID + "】功能号与树关联字段的初始值设为【" + nodeid + "】");
|
}
|
//tempNode = nodeid;
|
StringBuffer treeNodeStr = new StringBuffer();
|
treeNodeStr.append(" cast(" + tempNode + " as varchar) in (select top 1 cast(").append(nodeid + " as varchar) from ")
|
.append(str_tableName)
|
.append(" as b where (b.parentrowid ='' or b.parentrowid is null or not exists (select 1 from ")
|
.append(str_tableName).append(" c where b.parentrowid = c.rowid ").append(") ) ");
|
// 树过滤条件
|
String treefilterstr = GridUtils.prossRowSetDataType_String(treeSet, "treefilterstr");
|
if (!"".equals(treefilterstr)) {
|
//firstNodeSql += " and (" + treefilterstr + ")";
|
querySql += " and (" + treefilterstr + ")";
|
treeNodeStr.append(" and (" + treefilterstr + ")");
|
}
|
|
// 树类型排序
|
if (treeSet.get("treeformid") != null) {
|
Map<String, Object> gformInfo1 = gformIfc.getGformInfo("index1", Integer.parseInt(treeSet.get("treeformid").toString()));
|
if (gformInfo1.get("index1") != null && !gformInfo1.get("index1").toString().equals("")) {
|
if(treeNodeStr.indexOf("order by") < 0) {
|
treeNodeStr.append(" order by " + gformInfo1.get("index1").toString().replace(";", ","));
|
}
|
if(firstNodeSql.indexOf("order by") < 0) {
|
firstNodeSql += " order by " + gformInfo1.get("index1").toString().replace(";", ",");
|
}
|
|
}
|
}
|
treeNodeStr.append(")");
|
|
|
// ----------------
|
// 替换
|
Map<String, String> tree = new HashMap();
|
String treeid = trim(treeSet.get("treeformid").toString());
|
tree.put("table", str_tableName);
|
tree.put("autocode", autoCodeColumn);
|
tree.put("autocodeConfig", autoCodeConfig);
|
tree.put("treeformid", treeid);
|
tree.put("firstNodeSql", firstNodeSql);
|
tree.put("sql", sql);
|
tree.put("querySql", querySql);
|
tree.put("displayfield", trim(displayfield).toLowerCase());
|
tree.put("nodeid", trim(nodeid));
|
tree.put("detailNodeid", trim(detailNodeid));
|
tree.put("separatedst", trim(separatedst));
|
tree.put("treeNodeStr", treeNodeStr.toString());
|
treeList.put(treeid, tree);
|
treeFormids += treeid + ";";
|
}
|
// 读文件
|
String fileName = "treeData.jsp";
|
String data = getPageCode(fileName, baseBean);
|
String temp = GridUtils.toJson(treeList).replaceAll("\"", "\\\\\\\\\"");
|
data = data.replaceAll("@_treeList_@", temp);
|
data = data.replaceAll("@_treeFormids_@", treeFormids);
|
buildPageCode(data, fileName, baseBean);
|
// 处理页面第一次加载时取树的第一个节点作为格线显示的查询条件
|
String fileName1 = "tree.jsp";
|
String opt = getPageCode(fileName1, baseBean);
|
opt = opt.replaceAll("@_treeList_@", temp);
|
opt = opt.replaceAll("@_treeFormids_@", treeFormids);
|
buildPageCode(opt, fileName1, baseBean);
|
}
|
|
|
/**
|
* 生成主页面
|
*
|
* @throws Exception
|
*/
|
@Override
|
public void buildIndex(Map<String, Object> gformInfo) throws Exception {
|
BaseBean baseBean = (BaseBean) gformInfo.get(BEAN_INFO);
|
String fileName = "index.jsp";
|
String data = getPageCode(fileName, baseBean);
|
//
|
|
// --------从gform表获取是否显示大标题字段值(isTitle)判断是否显示大标题，并替换标识符-2012-02-20-syz--------[begin]----------------------
|
if (true) {
|
//String menuname_str = "";
|
String sSQL = " set nocount on ; select * from gform where formid='" + baseBean.formID + "' and isTitle='1' ";// isTitle=1表示配置了显示大标题
|
List<Map<String, Object>> arrayList = new ArrayList<Map<String, Object>>();
|
arrayList = getArrayList(sSQL);
|
if (arrayList.size() > 0) {// 如果配置了显示大标题
|
|
String TopAndTitle_str = "<table id=\"top_table\" width=\"100%\" bgcolor=\"#DEEDF7\">\n" + "<tr>\n" + "<td>\n" + "<div id=\"title_top\">[?title]</div>\n" + "</td></tr>\n"
|
// + "<tr>\n" + "<td>\n" + "<hr style=\"position: absolute;left:0px;top:28px;height: 1px;color: #bdc7c6;width: 99%;\">\n" + "</td>\n"
|
// + "</tr>\n"
|
+ "<tr><td>\n" + "<div id=\"tplt-top\">\n" + "\t\t\t<%@ include file=\"top.jsp\" %>\n" + "\t\t</div>\n" + "</td></tr>\n" + "</table>";
|
data = data.replace("[?TopAndTitle]", TopAndTitle_str);// 替换功能号标识符
|
data = data.replace("[?NorthHeight]", "height:68px;");// 替换部分功能号index.jsp页面的top层的宽度
|
} else {// 如果没有配置显示大标题
|
|
String TopAndTitle_str = "<script type=\"text/javascript\">\n" + "var bh=30;\n" + "</script>\n" + "<div id=\"tplt-top\">\n" + "\t\t\t<%@ include file=\"top.jsp\" %>\n" + "</div>";
|
|
data = data.replace("[?TopAndTitle]", TopAndTitle_str);// 替换功能号标识符
|
data = data.replace("[?NorthHeight]", "");// 替换部分功能号index.jsp页面的top层的宽度
|
}
|
}
|
// --------从gform表获取是否显示大标题字段值(isTitle)判断是否显示大标题，并替换标识符-2012-02-20-syz-----[end]-------------------------//
|
|
//-------------文字颜色说明---------xin 2022-5-18 16:09:54-----------//
|
StringBuilder colorText =new StringBuilder();//文字颜色说明
|
if(StringUtils.isNotBlank(baseBean.formID)) {
|
List<T9685Entity> colorList = apiServiceIfc.get9685List(Integer.parseInt(baseBean.formID));
|
if (colorList != null && colorList.size() > 0) {
|
colorText.append("文字颜色说明");
|
for (T9685Entity t : colorList) {
|
colorText.append("<div><span title=\"" + t.getItemMemo() + "\" class=\"spanColor\" " +
|
"style=\"background-color: " + t.getHexColor() + "\"></span>" +
|
"<span style=\"color: " + t.getHexColor() + "\">" +
|
t.getColorName() + "</span></div>");
|
}
|
}
|
}
|
//文字颜色说明 xin 2022-5-18 15:53:13
|
data = data.replace("[?ColorDescription]",colorText);
|
// ----------------
|
data = data.replace("[?title]", gformInfo.get("formname") + "");
|
data = data.replace("[?treewidth]", gformInfo.get("treewidth") + "");
|
data = data.replaceAll("@gridJsp@", baseBean.formID + "_grid.jsp");
|
buildPageCode(data, fileName, baseBean);
|
}
|
|
}
|
