📄 sort.php
字号:
<?
include_once 'inc/auth.php';
echo '
<html>
<head>
<title>表单设置</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_new.gif" align="absmiddle"><span class="big3"> 新建表单</span><br>
</td>
</tr>
</table>
<div align="center">
<input type="button" value="新建表单" class="BigButton" onClick="parent.list.location=\'edit.php\';" title="新建表单">
</div>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 管理表单</span><br>
</td>
</tr>
</table>
';
$COLOR1 = '#D9E8FF';
$COLOR2 = '#FFFFFF';
$COLOR3 = '#B3D1FF';
$FORM_COUNT = 0;
$query = 'SELECT * from FLOW_SORT order by SORT_NO';
$cursor0 = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor0))
{
$SORT_ID = $ROW['SORT_ID'];
$SORT_NO = $ROW['SORT_NO'];
$SORT_NAME = $ROW['SORT_NAME'];
$SORT_NAME = str_replace ('<', '<', $SORT_NAME);
$SORT_NAME = str_replace ('>', '>', $SORT_NAME);
$SORT_NAME = stripslashes ($SORT_NAME);
$query = 'SELECT * from FLOW_FORM_TYPE,FLOW_TYPE where FLOW_FORM_TYPE.FORM_ID=FLOW_TYPE.FORM_ID and FLOW_SORT=' . $SORT_ID . ' order by FLOW_NO';
$cursor = exequery ($connection, $query);
$FORM_COUNT1 = 0;
$FORM_ID_STR = '';
while ($ROW = mysql_fetch_array ($cursor))
{
$FORM_ID = $ROW['FORM_ID'];
$FORM_NAME = $ROW['FORM_NAME'];
if (!(find_id ($FORM_ID_STR, $FORM_ID)))
{
$FORM_ID_STR .= $FORM_ID . ',';
++$FORM_COUNT;
++$FORM_COUNT1;
$FORM_NAME = str_replace ('<', '<', $FORM_NAME);
$FORM_NAME = str_replace ('>', '>', $FORM_NAME);
$FORM_NAME = stripslashes ($FORM_NAME);
if ($FORM_COUNT1 == 1)
{
echo '<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3" align="center">
<tr class="TableHeader" onclick="clickMenu(\'';
echo $SORT_ID;
echo '\')" style="cursor:hand">
<td nowrap colspan="5" align="center" title=""><b>';
echo $SORT_NAME;
echo '</b></td>
</tr>
</table>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3" id="';
echo $SORT_ID;
echo '" style="display:none">
';
}
echo '<tr class="TableData" align="center">
<td nowrap width="100%" id="group_';
echo $FORM_COUNT;
echo '" onclick="view_group(this,';
echo $FORM_COUNT;
echo ',';
echo $FORM_ID;
echo ')" onmouseover="setGroupPointer(this, \'';
echo $COLOR3;
echo '\',';
echo $FORM_COUNT;
echo ')" onmouseout="setGroupPointer(this, \'';
echo $COLOR2;
echo '\',';
echo $FORM_COUNT;
echo ')" style="cursor:hand" BgColor="';
echo $COLOR2;
echo '">
';
echo $FORM_NAME;
echo '</td>
</tr>
';
continue;
}
}
if (0 < $FORM_COUNT1)
{
echo '</table>';
continue;
}
}
$query = 'SELECT * from FLOW_FORM_TYPE order by FORM_NAME';
$cursor = exequery ($connection, $query);
$FORM_COUNT1 = 0;
$SORT_ID = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
$FORM_ID = $ROW['FORM_ID'];
$FORM_NAME = $ROW['FORM_NAME'];
$query = 'SELECT * from FLOW_TYPE where FORM_ID=' . $FORM_ID;
$cursor1 = exequery ($connection, $query);
if (!($ROW = mysql_fetch_array ($cursor1)))
{
++$FORM_COUNT;
++$FORM_COUNT1;
$FORM_NAME = str_replace ('<', '<', $FORM_NAME);
$FORM_NAME = str_replace ('>', '>', $FORM_NAME);
$FORM_NAME = stripslashes ($FORM_NAME);
if ($FORM_COUNT1 == 1)
{
echo '<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3" align="center">
<tr class="TableHeader" onclick="clickMenu(\'';
echo $SORT_ID;
echo '\')" style="cursor:hand">
<td nowrap colspan="5" align="center" title=""><b>未分类表单</b></td>
</tr>
</table>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3" id="';
echo $SORT_ID;
echo '" style="display:none">
';
}
echo '<tr class="TableData" align="center">
<td nowrap width="100%" id="group_';
echo $FORM_COUNT;
echo '" onclick="view_group(this,';
echo $SORT_ID;
echo ',';
echo $FORM_ID;
echo ')" onmouseover="setGroupPointer(this, \'';
echo $COLOR3;
echo '\',1)" onmouseout="setGroupPointer(this, \'';
echo $COLOR2;
echo '\')" style="cursor:hand" BgColor="';
echo $COLOR2;
echo '">
';
echo $FORM_NAME;
echo '</td>
</tr>
';
continue;
}
}
if (0 < $FORM_COUNT1)
{
echo '</table>';
}
if ($FORM_COUNT == 0)
{
message ('', '尚未定义表单');
}
echo '
<script language="JavaScript">
var td_id=1;
function setGroupPointer(theRow, thePointerColor,td_id_over)
{
if(td_id!=td_id_over)
theRow.bgColor = thePointerColor;
}
function clickMenu(SORT_ID)
{
parent.list.location="list.php?SORT_ID="+SORT_ID;
targetelement=document.all(SORT_ID);
if (targetelement.style.display=="none")
targetelement.style.display=\'\';
else
targetelement.style.display="none";
}
function view_group(theRow,group_id,form_id)
{
parent.list.location="edit.php?SORT_ID="+group_id+"&FORM_ID="+form_id;
td_id=group_id;
';
for ($I = 1; $I <= $FORM_COUNT; ++$I)
{
echo ' group_' . $I . ('.bgColor=\'' . $COLOR2 . '\';
');
}
echo ' theRow.bgColor=\'';
echo $COLOR1;
echo '\';
}
</script>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -