function dept_tree_list($DEPT_ID, $PRIV_OP)
{
global $DEEP_COUNT;
global $connection;
$query = "SELECT * from department where DEPT_PARENT='" . $DEPT_ID . "' order by DEPT_NO";
$cursor = exequery($connection, $query);
$OPTION_TEXT = "";
$DEEP_COUNT1 = $DEEP_COUNT;
$DEEP_COUNT .= " ";
while ($ROW = mysql_fetch_array($cursor)) {
++$COUNT;
$DEPT_ID = $ROW['DEPT_ID'];
$DEPT_NAME = $ROW['DEPT_NAME'];
$DEPT_PARENT = $ROW['DEPT_PARENT'];
$DEPT_NAME = str_replace("<", "<", $DEPT_NAME);
$DEPT_NAME = str_replace(">", ">", $DEPT_NAME);
$DEPT_NAME = stripslashes($DEPT_NAME);
$DEPT_PRIV = 1;
$OPTION_TEXT_CHILD = dept_tree_list($DEPT_ID, $PRIV_OP);
if ($DEPT_PRIV == 1) {
$OPTION_TEXT .= " <tr class=TableData> <td class='menulines' id='" . $DEPT_ID . "' title='" . $DEPT_NAME . "' onclick=javascript:click_dept('" . $DEPT_ID . "') style=cursor:pointer>" . $DEEP_COUNT1 . "├" . $DEPT_NAME . "</a></td> </tr>";
}
if ($OPTION_TEXT_CHILD != "") {
$OPTION_TEXT .= $OPTION_TEXT_CHILD;
}
}
$DEEP_COUNT = $DEEP_COUNT1;
return $OPTION_TEXT;
}
function dept_tree_list($DEPT_ID, $PRIV_OP)
{
global $DEEP_COUNT;
global $connection;
$query = "SELECT * from producttype where parentid='" . $DEPT_ID . "'";
if ($_GET['MODULE_ID'] != "") {
$query .= " and rowid<>'" . $_GET['MODULE_ID'] . "'";
}
//只能选择目录
if ($_GET['MANAGE_FLAG'] == "1") {
$query .= " and rowid not in (select distinct producttype from product)";
}
$query .= "order by rowid";
//print $query;exit;
$cursor = exequery($connection, $query);
$OPTION_TEXT = "";
$DEEP_COUNT1 = $DEEP_COUNT;
$DEEP_COUNT .= " ";
while ($ROW = mysql_fetch_array($cursor)) {
++$COUNT;
$DEPT_ID = $ROW['ROWID'];
$DEPT_NAME = $ROW['name'];
$DEPT_PARENT = $ROW['parentid'];
$DEPT_NAME = str_replace("<", "<", $DEPT_NAME);
$DEPT_NAME = str_replace(">", ">", $DEPT_NAME);
$DEPT_NAME = stripslashes($DEPT_NAME);
if ($PRIV_OP == 1) {
$DEPT_PRIV = is_dept_priv($DEPT_ID);
} else {
$DEPT_PRIV = 1;
}
$image = "<img src='../../../Framework/images/endnode.gif'>";
$onclick = "onclick=javascript:click_dept('" . $DEPT_ID . "') style=cursor:pointer";
//判断是否下面有产品
$query1 = "SELECT * from product where producttype='" . $DEPT_ID . "'";
$cursor1 = exequery($connection, $query1);
$ROW1 = mysql_fetch_array($cursor1);
if (sizeof($ROW1) > 1) {
$image = "<img width=16 height=16 src='../../../Framework/images/ts.gif'>";
} else {
$title = "title='此目录为空'";
}
//只能选择终端节点
if ($_GET['MANAGE_FLAG'] == "2") {
$query1 = "SELECT * from producttype where parentid='" . $DEPT_ID . "'";
$cursor1 = exequery($connection, $query1);
$ROW1 = mysql_fetch_array($cursor1);
if (sizeof($ROW1) > 1) {
$onclick = "";
$title = "";
}
}
$OPTION_TEXT_CHILD = dept_tree_list($DEPT_ID, $PRIV_OP);
if ($DEPT_PRIV == 1) {
$OPTION_TEXT .= " <tr class=TableData> <td class='menulines' id='" . $DEPT_ID . "' title='" . $DEPT_NAME . "' " . $onclick . " " . $title . ">" . $DEEP_COUNT1 . $image . " " . $DEPT_NAME . "</td> </tr>";
}
if ($OPTION_TEXT_CHILD != "") {
$OPTION_TEXT .= $OPTION_TEXT_CHILD;
}
}
$DEEP_COUNT = $DEEP_COUNT1;
return $OPTION_TEXT;
}
