📄 dept_purview.php
字号:
<?php
header( "Expires: Mon, 26 Jul 1997 05:00:00 GMT" );
header( "Cache-Control: no-cache, must-revalidate" );
header( "Pragma: no-cache" );
include_once( "inc/auth.php" );
include_once( "inc/document_function.php" );
$SORT_ID = $_REQUEST['SORT_ID'];
$sql = "\r\n\t\tSELECT SORT_TYPE FROM file_sort WHERE SORT_ID = {$SORT_ID}\r\n\t\t";
$cursor1 = exequery( $connection, $sql );
$ROW1 = mysql_fetch_array( $cursor1 );
$SORT_TYPE = $ROW1['SORT_TYPE'];
$DEPT_COUNT = 0;
echo "<S";
echo "CRIPT language=javascript src=\"/inc/document_new.js\"></SCRIPT>\r\n<body class=\"bodycolor\" topmargin=\"2\" >\r\n <table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\" >\r\n\t <tr><td class=\"tablehead2\">\r\n\t <BUTTON id='savebutton'class=\"btn\" onClick=\"sendDataToSQL('DEPT','";
echo $SORT_ID;
echo "');\" title=\"保存设置\"><table><tr valign=\"top\" ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\" id='saveimg'></td> <td>";
echo "<s";
echo "pan id=\"showallid\">确定</span></td></tr></table></BUTTON>\r\n\t </td>\r\n\t </tr>\r\n </table>\r\n<table border=\"1px\" cellspacing=\"0\" width=\"100%\" class=\"small\" cellpadding=\"1\" bordercolor=\"#FFFFFF\">\r\n";
if ( $SORT_TYPE == 1 )
{
$query = "\r\n\t\tSELECT DEPT_ID,DEPT_NAME FROM department\r\n\t\t";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$DEPT_COUNT;
$DEPT_NAME = $ROW['DEPT_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
selectshow( $DEPT_ID, $DEPT_NAME, "DEPT", $SORT_ID );
}
}
else
{
$query = "\r\n\t\tSELECT DEPT_ID FROM file_purview WHERE SORT_ID = {$SORT_ID}\r\n\t\t";
$cursor = exequery( $connection, $query );
$ROW = mysql_fetch_array( $cursor );
$DEPT_DATA_ID = $ROW['DEPT_ID'];
$tokenarr = tokenizequoted( $DEPT_DATA_ID );
while ( list( , $DEPT_ID ) = each( $tokenarr ) )
{
++$DEPT_COUNT;
$query = "\r\n\t\t\tSELECT DEPT_NAME FROM department WHERE DEPT_ID = {$DEPT_ID}\r\n\t\t\t";
$cursor = exequery( $connection, $query );
$ROW = mysql_fetch_array( $cursor );
$DEPT_NAME = $ROW['DEPT_NAME'];
selectshow( $DEPT_ID, $DEPT_NAME, "DEPT", $SORT_ID );
}
}
if ( $DEPT_COUNT == 0 )
{
message( "", "没有选择部门" );
exit( );
}
else
{
echo "\t\t\t<thead class=\"TableHeader\">\r\n\t\t\t<td nowrap >部门</td>\r\n\t\t\t<td nowrap >\r\n\t\t\t";
selecttopshow( $SORT_ID, "DEPT" );
echo "\t\t\t</thead>\r\n\t\t\t</table>\r\n\t\t\t";
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -