树型结构脚本相关文档

来源：互联网发布：知乎一小时系列编辑：程序博客网时间：2024/05/21 13:28

树型结构脚本相关文档

其结构图如下所示：

对应的machmap.jsp页面如下所示：

<%@ page contentType="text/html; charset=gb2312" language="java"%>

<%@ page import = "java.sql.*"%>

<%@ page import ="pub.*" %>

<html>

<head>

<title>#.Admin</title>

</head>

<tr>

<DIV align="left"><FONT face="宋体" color="#ffffff">  当前位置：基础信息>>组织机构图 </FONT>

</DIV>

</FONT>

</td>

</tr>

</table>

<tr>

</tr>

</table>

<br>

//此函数是为了让鼠标移到所选的字上时变红,移走是恢复

function highLightText(overflag) {

if (overflag==0) {

event.srcElement.bgColor="#000080";

event.srcElement.style.color="#0A52CB";

}

else {

event.srcElement.bgColor="#D4D0C8";

event.srcElement.style.color="#FF0000";

}

<!--

d = new dTree('d');

d.config.folderLinks=true;

//id, pid, name, url, title, target, icon, iconOpen, open

d.add(0,-1,'PICC组织机构图','','easydone','_blank');

//d.add(2,5,'秘书2233','','easydone','_blank');

//d.add(2,2,'秘书','','easydone','_blank');

//d.add(2,5,'秘书','','easydone','_blank');

//d.add(98,5,'工程师','','easydone','_blank');

String Sql = "select * from sys04_Machine";

String SqlPosition = "select PositionID,MachID,DirectTOPPositionID, ";

SqlPosition+= " (select MachName from sys04_Machine d where d.MachID=a.MachID) as Depart ,";

SqlPosition+= " (select PositionName from sys08_Position b where b.PositionID=a.PositionID) as Position ,";

SqlPosition+= " (select PositionName from sys08_Position c where c.PositionID=a.DirectTOPPositionID) as DirectTOPPosition ,";

SqlPosition+= " (select Responsability from sys08_Position d where d.PositionID=a.PositionID) as Responsability ";

SqlPosition+= " from sys09_Positioninfo a ";

System.out.println("SqlPosition:"+SqlPosition);

String strID="";

String strPid="";

String strName="";

String strCropID="";

String strUrl="";

String strTarget="";

String strPositionID="";

String strMachID="";

String strPosition="";

String strResponsability="";

int NUMBER=200; //为了防止sys09_Positioninfo中取出的PositionID＆sys04_Machine中取出MachID的数据值相同

Conn conn=new Conn();

DataTable dt =new DataTable();

DataTable dtPosition =new DataTable();

int count2=dtPosition.getRowCount();

//int count1=dt.getRowCount();

//Connection conn = null;

try{

conn.execSql(Sql);

conn.execSql(SqlPosition);

conn.querySql(SqlPosition,dtPosition);

//将公司 and 部门添加到组织结构图当中

if(conn.querySql(Sql,dt)){

if(dt.getRowCount()>0){

for(int i=0;i<dt.getRowCount();i++){

strID = dt.getItemForName(i,"MachID");

strPid = dt.getItemForName(i,"ParentID");

strCropID = dt.getItemForName(i,"Cropid");

strName = dt.getItemForName(i,"MachName");

strUrl = dt.getItemForName(i,"url");

strTarget = dt.getItemForName(i,"target");

if(strCropID.equals("0")==false && strPid.equals("0")==true){

d.add(<%=strID%>,<%=strCropID%>,"<a style='cursor:hand; color:#0A52CB' onmouseout='highLightText(0);' onmouseover='highLightText(1);' ><%=strName %></a>" ,'<%=strUrl%>','<%=strName%>','<%=strTarget%>');

}

else{

d.add(<%=strID%>,<%=strPid%>,"<a style='cursor:hand; color:#0A52CB' onmouseout='highLightText(0);' onmouseover='highLightText(1);' ><%=strName %></a>" ,'<%=strUrl%>','<%=strName%>','<%=strTarget%>');

}

//将对应的岗位添加到组织结构图当中

if(conn.querySql(SqlPosition,dtPosition)){

if(dtPosition.getRowCount()>0){

for(int i=0;i<dtPosition.getRowCount();i++){

strPositionID = dtPosition.getItemForName(i,"PositionID")+NUMBER; //这里加一个NUMBER为了防止sys09_Positioninfo中取出的PositionID＆sys04_Machine中取出MachID的数据值相同

//System.out.println("strPositionID:"+strPositionID);

strMachID = dtPosition.getItemForName(i,"MachID");

//System.out.println("strMachID:"+strMachID);

strDirectTOPPositionID = dtPosition.getItemForName(i,"DirectTOPPositionID");

strPosition = dtPosition.getItemForName(i,"Position");

//System.out.println("strPosition:"+strPosition);

strDirectTOPPosition = dtPosition.getItemForName(i,"DirectTOPPosition");

strDepart = dtPosition.getItemForName(i,"Depart");

strResponsability= dtPosition.getItemForName(i,"Responsability");

d.add(<%=strPositionID%>,<%=strMachID%>,"<a style='cursor:hand; color:#0A52CB' onmouseout='highLightText(0);' onmouseover='highLightText(1);' title=<%=strResponsability %> ><%=strPosition %></a>",'','easydone','_blank','../images/organization/position.gif');

}

catch(Exception ex){

out.println(ex.toString());

}

document.write(d);

//-->

</script>

</body>

</html>

其对应的表结构如下：sys08_Position （岗位表）

sys09_Positioninfo （岗位信息表）

sys04_Machine（组织表）

其对应的javascript文件如下：

dtree.js：

/*--------------------------------------------------|

| dTree 2.05 | www.destroydrop.com/javascript/tree/ |

|---------------------------------------------------|

| |

| This script can be used freely as long as all |

| copyright messages are intact. |

| |

| Updated: 17.04.2003 |

|--------------------------------------------------*/

// Node object

function Node(id, pid, name, url, title, target, icon, iconOpen, open) {

this.id = id;

this.pid = pid;

this.name = name;

this.url = url;

this.title = title;

this.target = target;

this.icon = icon;

this.iconOpen = iconOpen;

this._io = open || false;

this._is = false;

this._ls = false;

this._hc = false;

this._ai = 0;

this._p;

};

// Tree object

function dTree(objName) {

this.config = {

target : null,

folderLinks : true,

useSelection : true,

useCookies : true,

useLines : true,

useIcons : true,

useStatusText : false,

closeSameLevel : false,

inOrder : false

}

this.icon = {

root : '../images/organization/base.gif',

folder : '../images/organization/folder.gif',

folderOpen : '../images/organization/folderopen.gif',

node : '../images/organization/page.gif',

//positionnode : '../images/organization/position.gif',

empty : '../images/organization/empty.gif',

line : '../images/organization/line.gif',

join : '../images/organization/join.gif',

joinBottom : '../images/organization/joinbottom.gif',

plus : '../images/organization/plus.gif',

plusBottom : '../images/organization/plusbottom.gif',

minus : '../images/organization/minus.gif',

minusBottom : '../images/organization/minusbottom.gif',

nlPlus : '../imges/organization/nolines_plus.gif',

nlMinus : '../imges/organization/nolines_minus.gif'

};

this.obj = objName;

this.aNodes = [];

this.aIndent = [];

this.root = new Node(-1);

this.selectedNode = null;

this.selectedFound = false;

this.completed = false;

};

// Adds a new node to the node array

dTree.prototype.add = function(id, pid, name, url, title, target, icon, iconOpen, open) {

this.aNodes[this.aNodes.length] = new Node(id, pid, name, url, title, target, icon, iconOpen, open);

};

// Open/close all nodes

dTree.prototype.openAll = function() {

this.oAll(true);

};

dTree.prototype.closeAll = function() {

this.oAll(false);

};

// Outputs the tree to the page

dTree.prototype.toString = function() {

var str = '<div class="dtree">/n';

if (document.getElementById) {

if (this.config.useCookies) this.selectedNode = this.getSelected();

str += this.addNode(this.root);

} else str += 'Browser not supported.';

str += '</div>';

if (!this.selectedFound) this.selectedNode = null;

this.completed = true;

return str;

};

// Creates the tree structure

dTree.prototype.addNode = function(pNode) {

var str = '';

var n=0;

if (this.config.inOrder) n = pNode._ai;

for (n; n<this.aNodes.length; n++) {

if (this.aNodes[n].pid == pNode.id) {

var cn = this.aNodes[n];

cn._p = pNode;

cn._ai = n;

this.setCS(cn);

if (!cn.target && this.config.target) cn.target = this.config.target;

if (cn._hc && !cn._io && this.config.useCookies) cn._io = this.isOpen(cn.id);

if (!this.config.folderLinks && cn._hc) cn.url = null;

if (this.config.useSelection && cn.id == this.selectedNode && !this.selectedFound) {

cn._is = true;

this.selectedNode = n;

this.selectedFound = true;

}

str += this.node(cn, n);

if (cn._ls) break;

}

return str;

};

// Creates the node icon, url and text

dTree.prototype.node = function(node, nodeId) {

var str = '<div class="dTreeNode">' + this.indent(node, nodeId);

if (this.config.useIcons) {

if (!node.icon) node.icon = (this.root.id == node.pid) ? this.icon.root : ((node._hc) ? this.icon.folder : (this.icon.node));

if (!node.iconOpen) node.iconOpen = (node._hc) ? this.icon.folderOpen : this.icon.node;

if (this.root.id == node.pid) {

node.icon = this.icon.root;

node.iconOpen = this.icon.root;

}

str += '<img id="i' + this.obj + nodeId + '" src="' + ((node._io) ? node.iconOpen : node.icon) + '" alt="" />';

}

if (node.url) {

str += '<a id="s' + this.obj + nodeId + '" class="' + ((this.config.useSelection) ? ((node._is ? 'nodeSel' : 'node')) : 'node') + '" href="' + node.url + '"';

if (node.title) str += ' title="' + node.title + '"';

if (node.target) str += ' target="' + node.target + '"';

if (this.config.useStatusText) str += ' onmouseover="window.status=/'' + node.name + '/';return true;" onmouseout="window.status=/'/';return true;" ';

if (this.config.useSelection && ((node._hc && this.config.folderLinks) || !node._hc))

str += ' onclick="javascript: ' + this.obj + '.s(' + nodeId + ');"';

str += '>';

}

else if ((!this.config.folderLinks || !node.url) && node._hc && node.pid != this.root.id)

str += '<a href="javascript: ' + this.obj + '.o(' + nodeId + ');" class="node">';

str += node.name;

if (node.url || ((!this.config.folderLinks || !node.url) && node._hc)) str += '</a>';

str += '</div>';

if (node._hc) {

str += '<div id="d' + this.obj + nodeId + '" class="clip" style="display:' + ((this.root.id == node.pid || node._io) ? 'block' : 'none') + ';">';

str += this.addNode(node);

str += '</div>';

}

this.aIndent.pop();

return str;

};

// Adds the empty and line icons

dTree.prototype.indent = function(node, nodeId) {

var str = '';

if (this.root.id != node.pid) {

for (var n=0; n<this.aIndent.length; n++)

str += '<img src="' + ( (this.aIndent[n] == 1 && this.config.useLines) ? this.icon.line : this.icon.empty ) + '" alt="" />';

(node._ls) ? this.aIndent.push(0) : this.aIndent.push(1);

if (node._hc) {

str += '<a href="javascript: ' + this.obj + '.o(' + nodeId + ');"><img id="j' + this.obj + nodeId + '" src="';

if (!this.config.useLines) str += (node._io) ? this.icon.nlMinus : this.icon.nlPlus;

else str += ( (node._io) ? ((node._ls && this.config.useLines) ? this.icon.minusBottom : this.icon.minus) : ((node._ls && this.config.useLines) ? this.icon.plusBottom : this.icon.plus ) );

str += '" alt="" /></a>';

} else str += '<img src="' + ( (this.config.useLines) ? ((node._ls) ? this.icon.joinBottom : this.icon.join ) : this.icon.empty) + '" alt="" />';

}

return str;

};

// Checks if a node has any children and if it is the last sibling

dTree.prototype.setCS = function(node) {

var lastId;

for (var n=0; n<this.aNodes.length; n++) {

if (this.aNodes[n].pid == node.id) node._hc = true;

if (this.aNodes[n].pid == node.pid) lastId = this.aNodes[n].id;

}

if (lastId==node.id) node._ls = true;

};

// Returns the selected node

dTree.prototype.getSelected = function() {

var sn = this.getCookie('cs' + this.obj);

return (sn) ? sn : null;

};

// Highlights the selected node

dTree.prototype.s = function(id) {

if (!this.config.useSelection) return;

var cn = this.aNodes[id];

if (cn._hc && !this.config.folderLinks) return;

if (this.selectedNode != id) {

if (this.selectedNode || this.selectedNode==0) {

eOld = document.getElementById("s" + this.obj + this.selectedNode);

eOld.className = "node";

}

eNew = document.getElementById("s" + this.obj + id);

eNew.className = "nodeSel";

this.selectedNode = id;

if (this.config.useCookies) this.setCookie('cs' + this.obj, cn.id);

}

};

// Toggle Open or close

dTree.prototype.o = function(id) {

var cn = this.aNodes[id];

this.nodeStatus(!cn._io, id, cn._ls);

cn._io = !cn._io;

if (this.config.closeSameLevel) this.closeLevel(cn);

if (this.config.useCookies) this.updateCookie();

};

// Open or close all nodes

dTree.prototype.oAll = function(status) {

for (var n=0; n<this.aNodes.length; n++) {

if (this.aNodes[n]._hc && this.aNodes[n].pid != this.root.id) {

this.nodeStatus(status, n, this.aNodes[n]._ls)

this.aNodes[n]._io = status;

}

if (this.config.useCookies) this.updateCookie();

};

// Opens the tree to a specific node

dTree.prototype.openTo = function(nId, bSelect, bFirst) {

if (!bFirst) {

for (var n=0; n<this.aNodes.length; n++) {

if (this.aNodes[n].id == nId) {

nId=n;

break;

}

var cn=this.aNodes[nId];

if (cn.pid==this.root.id || !cn._p) return;

cn._io = true;

cn._is = bSelect;

if (this.completed && cn._hc) this.nodeStatus(true, cn._ai, cn._ls);

if (this.completed && bSelect) this.s(cn._ai);

else if (bSelect) this._sn=cn._ai;

this.openTo(cn._p._ai, false, true);

};

// Closes all nodes on the same level as certain node

dTree.prototype.closeLevel = function(node) {

for (var n=0; n<this.aNodes.length; n++) {

if (this.aNodes[n].pid == node.pid && this.aNodes[n].id != node.id && this.aNodes[n]._hc) {

this.nodeStatus(false, n, this.aNodes[n]._ls);

this.aNodes[n]._io = false;

this.closeAllChildren(this.aNodes[n]);

}

// Closes all children of a node

dTree.prototype.closeAllChildren = function(node) {

for (var n=0; n<this.aNodes.length; n++) {

if (this.aNodes[n].pid == node.id && this.aNodes[n]._hc) {

if (this.aNodes[n]._io) this.nodeStatus(false, n, this.aNodes[n]._ls);

this.aNodes[n]._io = false;

this.closeAllChildren(this.aNodes[n]);

}

// Change the status of a node(open or closed)

dTree.prototype.nodeStatus = function(status, id, bottom) {

eDiv = document.getElementById('d' + this.obj + id);

eJoin = document.getElementById('j' + this.obj + id);

if (this.config.useIcons) {

eIcon = document.getElementById('i' + this.obj + id);

eIcon.src = (status) ? this.aNodes[id].iconOpen : this.aNodes[id].icon;

}

eJoin.src = (this.config.useLines)?

((status)?((bottom)?this.icon.minusBottom:this.icon.minus):((bottom)?this.icon.plusBottom:this.icon.plus)):

((status)?this.icon.nlMinus:this.icon.nlPlus);

eDiv.style.display = (status) ? 'block': 'none';

};

// [Cookie] Clears a cookie

dTree.prototype.clearCookie = function() {

var now = new Date();

var yesterday = new Date(now.getTime() - 1000 * 60 * 60 * 24);

this.setCookie('co'+this.obj, 'cookieValue', yesterday);

this.setCookie('cs'+this.obj, 'cookieValue', yesterday);

};

// [Cookie] Sets value in a cookie

dTree.prototype.setCookie = function(cookieName, cookieValue, expires, path, domain, secure) {

document.cookie =

escape(cookieName) + '=' + escape(cookieValue)

+ (expires ? '; expires=' + expires.toGMTString() : '')

+ (path ? '; path=' + path : '')

+ (domain ? '; domain=' + domain : '')

+ (secure ? '; secure' : '');

};

// [Cookie] Gets a value from a cookie

dTree.prototype.getCookie = function(cookieName) {

var cookieValue = '';

var posName = document.cookie.indexOf(escape(cookieName) + '=');

if (posName != -1) {

var posValue = posName + (escape(cookieName) + '=').length;

var endPos = document.cookie.indexOf(';', posValue);

if (endPos != -1) cookieValue = unescape(document.cookie.substring(posValue, endPos));

else cookieValue = unescape(document.cookie.substring(posValue));

}

return (cookieValue);

};

// [Cookie] Returns ids of open nodes as a string

dTree.prototype.updateCookie = function() {

var str = '';

for (var n=0; n<this.aNodes.length; n++) {

if (this.aNodes[n]._io && this.aNodes[n].pid != this.root.id) {

if (str) str += '.';

str += this.aNodes[n].id;

}

this.setCookie('co' + this.obj, str);

};

// [Cookie] Checks if a node id is in a cookie

dTree.prototype.isOpen = function(id) {

var aOpen = this.getCookie('co' + this.obj).split('.');

for (var n=0; n<aOpen.length; n++)

if (aOpen[n] == id) return true;

return false;

};

// If Push and pop is not implemented by the browser

if (!Array.prototype.push) {

Array.prototype.push = function array_push() {

for(var i=0;i<arguments.length;i++)

this[this.length]=arguments[i];

return this.length;

}

};

if (!Array.prototype.pop) {

Array.prototype.pop = function array_pop() {

lastElement = this[this.length-1];

this.length = Math.max(this.length-1,0);

return lastElement;

}

};

Op.js文件如下：

function showsubmenu(sid){

whichEl = eval("submenu" + sid);

if (whichEl.style.display == "none"){

eval("submenu" + sid + ".style.display=/"/";");

}else{

eval("submenu" + sid + ".style.display=/"none/";");

}

function cwin(){

if(parent.testframeset.cols!='200,*'){

parent.testframeset.cols='200,*';

}else{

parent.testframeset.cols='-10,*';

}

function closenavi() {

w-=10;

if (w>-10) {

window.parent.testframeset.cols = ''+w+',*';repeat=setTimeout("closenavi()",100);

}else {

clearTimeout(repeat);w=220;

}

Dtree.css文件:

/*--------------------------------------------------|

| dTree 2.05 | www.destroydrop.com/javascript/tree/ |

|---------------------------------------------------|

|--------------------------------------------------*/

.dtree {

font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size: 11px;

color: #666;

white-space: nowrap;

}

.dtree img {

border: 0px;

vertical-align: middle;

}

.dtree a {

color: #333;

text-decoration: none;

}

.dtree a.node, .dtree a.nodeSel {

white-space: nowrap;

padding: 1px 2px 1px 2px;

}

.dtree a.node:hover, .dtree a.nodeSel:hover {

color: #333;

text-decoration: underline;

}

.dtree a.nodeSel {

background-color: #c0d2ec;

}

.dtree .clip {

overflow: hidden;

}

2006-9-8