share_folder.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 266 行
PHP
266 行
<?
function share_priv ($SORT_ID)
{
if (($SORT_ID == 0))
{
return '';
}
global $LOGIN_USER_ID;
global $connection;
$query = ((''.'SELECT SORT_PARENT,SHARE_USER,MANAGE_USER from FILE_SORT where SORT_ID=').$SORT_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$SORT_PARENT = $ROW['SORT_PARENT'];
$SHARE_USER = $ROW['SHARE_USER'];
$MANAGE_USER = $ROW['MANAGE_USER'];
}
if (find_id ($SHARE_USER, $LOGIN_USER_ID))
{
return (($SHARE_USER.'|').$MANAGE_USER);
}
else
{
return share_priv ($SORT_PARENT);
}
}
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
$ITEMS_IN_PAGE = 10;
if ((!isset ($start) OR ($start == '')))
{
$start = 0;
}
echo '
<html>
<head>
<title>文件柜</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
';
echo '<s';
echo 'cript Language="JavaScript">
function SaveFile(ATTACHMENT_ID,ATTACHMENT_NAME)
{
URL="/module/save_file?ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME+"&A=1";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.open(URL,null,"height=180,width=400,status=1,toolbar=no,menubar=no,location';
echo '=no,scrollbars=yes,top="+loc_y+",left="+loc_x+",resizable=yes");
}
function order_by(field,asc_desc)
{
window.location="share_folder.php?SORT_ID=';
echo $SORT_ID;
echo '&start=';
echo $start;
echo '&FIELD="+field+"&ASC_DESC="+asc_desc;
}
</script>
<body class="bodycolor" topmargin="0">
';
$SHARE_PRIV = share_priv ($SORT_ID);
$SHARE_USER = substr ($SHARE_PRIV, 0, strpos ($SHARE_PRIV, '|'));
$MANAGE_USER = substr ($SHARE_PRIV, (strpos ($SHARE_PRIV, '|') + 1));
if (!find_id ($SHARE_USER, $LOGIN_USER_ID))
{
exit ();
}
if (find_id ($MANAGE_USER, $LOGIN_USER_ID))
{
$MANAGE_PRIV = 1;
}
$query = ((''.'SELECT SORT_NAME,USER_ID from FILE_SORT where SORT_ID=').$SORT_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$SORT_NAME = $ROW['SORT_NAME'];
$USER_ID = $ROW['USER_ID'];
$SORT_NAME = htmlspecialchars ($SORT_NAME);
}
$query = ((''.'SELECT count(*) from FILE_CONTENT where SORT_ID=').$SORT_ID);
$cursor = exequery ($connection, $query);
$FILE_COUNT = 0;
if ($ROW = mysql_fetch_array ($cursor))
{
$FILE_COUNT = $ROW[0];
}
if (($FILE_COUNT == 0))
{
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><b>';
echo '<s';
echo 'pan class="Big1"> ';
echo $SORT_NAME;
echo ' (共享文件柜)</span></b><br>
</td>
</tr>
</table>
<br>
';
message ('', '该文件夹尚无文件');
exit ();
}
$query = (((''.'SELECT CONTENT_ID,SUBJECT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,CONTENT_NO from FILE_CONTENT where SORT_ID=\'').$SORT_ID).'\'');
if (($FIELD == ''))
{
($query .= ' order by CONTENT_NO,SEND_TIME desc');
}
else
{
($query .= (' order by '.$FIELD));
if (($ASC_DESC == '1'))
{
($query .= ' desc');
}
else
{
($query .= ' asc');
}
}
($query .= ((((''.' limit ').$start).',').$ITEMS_IN_PAGE));
if (($ASC_DESC == '1'))
{
$ORDER_IMG = '<img border=0 src="/images/arrow_down.gif" width="11" height="10">';
}
else
{
$ORDER_IMG = '<img border=0 src="/images/arrow_up.gif" width="11" height="10">';
}
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><b>';
echo '<s';
echo 'pan class="Big1"> ';
echo $SORT_NAME;
echo ' (共享文件柜)</span></b><br>
</td>
<td align="right" valign="bottom" class="small1">';
echo page_bar ($start, $FILE_COUNT, $ITEMS_IN_PAGE);
echo '</td>
</tr>
</table>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center" onclick="order_by(\'SUBJECT\',\'';
if (($FIELD == 'SUBJECT'))
{
echo (1 - $ASC_DESC);
}
else
{
echo '1';
}
echo '\');" style="cursor:hand;"><u>文件名称</u>';
if (($FIELD == 'SUBJECT'))
{
echo $ORDER_IMG;
}
echo '</td>
<td nowrap align="center">附件</td>
<td nowrap align="center" onclick="order_by(\'SEND_TIME\',\'';
if (($FIELD == 'SEND_TIME'))
{
echo (1 - $ASC_DESC);
}
else
{
echo '1';
}
echo '\');" style="cursor:hand;"><u>发布时间</u>';
if (($FIELD == 'SEND_TIME'))
{
echo $ORDER_IMG;
}
echo '</td>
<td nowrap align="center" onclick="order_by(\'CONTENT_NO\',\'';
if (($FIELD == 'CONTENT_NO'))
{
echo (1 - $ASC_DESC);
}
else
{
echo '1';
}
echo '\');" style="cursor:hand;"><u>排序号</u>';
if ((($FIELD == 'CONTENT_NO') OR ($FIELD == '')))
{
echo $ORDER_IMG;
}
echo '</td>
';
if (($MANAGE_PRIV == 1))
{
echo ' <td nowrap align="center">操作</td>
';
}
echo ' </tr>
';
$FILE_COUNT = 0;
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
++$FILE_COUNT;
$CONTENT_ID = $ROW['CONTENT_ID'];
$CONTENT_NO = $ROW['CONTENT_NO'];
$SUBJECT = $ROW['SUBJECT'];
$SEND_TIME = substr ($ROW['SEND_TIME'], 0, -3);
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
$SUBJECT = htmlspecialchars ($SUBJECT);
$ATTACHMENT_DESC = htmlspecialchars ($ATTACHMENT_DESC);
if ((($FILE_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td><a href="read.php?SORT_ID=';
echo $SORT_ID;
echo '&CONTENT_ID=';
echo $CONTENT_ID;
echo '&start=';
echo $start;
echo '">';
echo $SUBJECT;
echo '</a></td>
<td nowrap>';
echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1);
echo '</td>
<td align="center">';
echo $SEND_TIME;
echo '</td>
<td align="center">';
echo $CONTENT_NO;
echo '</td>
';
if (($MANAGE_PRIV == 1))
{
echo ' <td align="center" nowrap>
<a href="edit.php?FILE_SORT=';
echo $FILE_SORT;
echo '&SORT_ID=';
echo $SORT_ID;
echo '&CONTENT_ID=';
echo $CONTENT_ID;
echo '&start=';
echo $start;
echo '&SHARE=1">编辑</a>
</td>
';
}
echo ' </tr>
';
}
echo '</table>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?