content_8.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

$paraarray = getindexpara( $block_id );
$rownum = $paraarray['block_row'];
$common_id = $paraarray['common_id'];
$FILE_SORT = 1;
$SORT_ID = $common_id;
include_once( "inc/config_doc.inc.php" );
global $FILE_PATH_PURVIEW;
global $DOWN_PATH_PURVIEW;
global $ALLREADPUR;
$COUNT = 0;
$query = "SELECT a.SORT_ID,a.USER_ID,a.CONTENT_ID,a.SUBJECT,a.SEND_TIME,a.ATTACHMENT_ID,a.ATTACHMENT_NAME, ";
$query .= " a.ATTACHMENT_DESC,a.USER_ID,b.SORT_NAME from FILE_CONTENT a,FILE_SORT b,DOCUMENT_SHARE c";
$query .= "  WHERE (a.CONTENT_ID = c.DOCUMENT_ID and a.SORT_ID=b.SORT_ID) ";
if ( $SORT_ID == 0 && $FILE_SORT == 1 )
{
	$query .= " \r\n\t\t\t\tAND (a.SORT_ID IN ({$ALLREADPUR}) \r\n\t\t\t\t\tOR (c.FILE_TYPE=1\r\n\t\t\t\t\tand( \r\n\t\t\t\t\t   (INStr(c.DEPT_ID,',{$LOGIN_DEPT_ID},')>0 or INStr(c.DEPT_ID,'{$LOGIN_DEPT_ID},')=1) \r\n\t\t\t\t\t   or\r\n\t\t\t\t\t   (INStr(c.PRIV_ID,',{$LOGIN_USER_PRIV},')>0 or INStr(c.PRIV_ID,'{$LOGIN_USER_PRIV},')=1)\r\n\t\t\t\t\t   or \r\n\t\t\t\t\t   (INStr(c.USER_ID,',{$LOGIN_USER_ID},')>0 or INStr(c.USER_ID,'{$LOGIN_USER_ID},')=1)\r\n\t\t\t\t\t   )\r\n\t\t\t\t\t)\r\n\t\t\t\t)\r\n\t\t";
}
if ( $SORT_ID != 0 && $FILE_SORT == 1 )
{
	$query .= " \r\n\t\t\tAND ((a.SORT_ID IN ({$ALLREADPUR})and(a.SORT_ID IN ({$DOWN_PATH_PURVIEW}))) \r\n\t\t\t\tOR (c.FILE_TYPE=1\r\n\t\t\t\t\tand( \r\n\t\t\t\t\t   (INStr(c.DEPT_ID,',{$LOGIN_DEPT_ID},')>0 or INStr(c.DEPT_ID,'{$LOGIN_DEPT_ID},')=1) \r\n\t\t\t\t\t   or\r\n\t\t\t\t\t   (INStr(c.PRIV_ID,',{$LOGIN_USER_PRIV},')>0 or INStr(c.PRIV_ID,'{$LOGIN_USER_PRIV},')=1)\r\n\t\t\t\t\t   or \r\n\t\t\t\t\t   (INStr(c.USER_ID,',{$LOGIN_USER_ID},')>0 or INStr(c.USER_ID,'{$LOGIN_USER_ID},')=1)\r\n\t\t\t\t\t   )\r\n\t\t\t\tand (a.SORT_ID IN ({$DOWN_PATH_PURVIEW})))\r\n\t\t\t\t)";
}
$query .= "ORDER BY SEND_TIME DESC LIMIT 0,{$rownum}";
$rc = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $rc ) )
{
	$SUBJECT = $ROW['SUBJECT'];
	$SEND_TIME = $ROW['SEND_TIME'];
	$USER_ID = $ROW['USER_ID'];
	++$COUNT;
	$SORT_ID = $ROW['SORT_ID'];
	$CONTENT_ID = $ROW['CONTENT_ID'];
	$SUBJECT = $ROW['SUBJECT'];
	$SEND_TIME = $ROW['SEND_TIME'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
	$SUBJECT = str_replace( "<", "&lt", $SUBJECT );
	$SUBJECT = str_replace( ">", "&gt", $SUBJECT );
	$SUBJECT = stripslashes( $SUBJECT );
	$ATTACHMENT_NAME = str_replace( "<", "&lt", $ATTACHMENT_NAME );
	$ATTACHMENT_NAME = str_replace( ">", "&gt", $ATTACHMENT_NAME );
	$ATTACHMENT_NAME = stripslashes( $ATTACHMENT_NAME );
	$ATTACHMENT_DESC = str_replace( "<", "&lt", $ATTACHMENT_DESC );
	$ATTACHMENT_DESC = str_replace( ">", "&gt", $ATTACHMENT_DESC );
	$ATTACHMENT_DESC = stripslashes( $ATTACHMENT_DESC );
	echo "\t<div class = \"linkdiv\">\r\n\t<IMG SRC=\"/images/littlegif/news_bullet.gif\" WIDTH=\"15\" HEIGHT=\"10\" BORDER=\"0\" ALT=\"\">\r\n\t<a href =\"#\" onclick=\"openWindows('/general/file_folder/file_new/read.php?FILE_SORT=1&SORT_ID=";
	echo $SORT_ID;
	echo "&CONTENT_ID=";
	echo $CONTENT_ID;
	echo "&closetag=1')\" title=\"";
	echo $SUBJECT;
	echo "\">\r\n\t";
	$query_read = "\r\n\t\t\t\t\tSELECT COUNT(LOG_ID) as CNT2 FROM sys_op_log \r\n\t\t\t\t\t\tWHERE SEQ_ID = ".$CONTENT_ID."\r\n\t\t\t\t\t\t\tand\t USER_ID = '".$_SESSION['LOGIN_USER_ID']."'\r\n\t\t\t\t\t\t";
	$cursor_read = exequery( $connection, $query_read );
	$READ_ROW = mysql_fetch_array( $cursor_read );
	$query_new = "\r\n\t\t\t\t\tSELECT COUNT(LOG_ID) as CNT3 FROM sys_op_log \r\n\t\t\t\t\t\tWHERE SEQ_ID = ".$CONTENT_ID."\r\n\t\t\t\t\t\t\tand\t OPERATION_TYPE =1\t\t\t\t\t\t\r\n\t\t\t\t\t\t";
	$cursor_new = exequery( $connection, $query_new );
	$NEW_ROW = mysql_fetch_array( $cursor_new );
	if ( $READ_ROW['CNT2'] == 0 && $NEW_ROW['CNT3'] != 0 )
	{
		echo substrgb( $SUBJECT, $paraarray['subject_length'], "..." )."&nbsp;<IMG SRC=\"/images/newred.gif\" WIDTH=\"26\" HEIGHT=\"13\" BORDER=\"0\" ALT=\"\">";
	}
	else
	{
		echo substrgb( $SUBJECT, $paraarray['subject_length'], "..." );
	}
	echo "</a>\r\n\t";
	if ( $paraarray['is_show_date'] == 1 )
	{
		echo "<span class =\"linkgray10\">({$SEND_TIME})</span>";
	}
	if ( $paraarray['is_show_creator'] == 1 )
	{
		$user_name = getusername( $USER_ID );
	}
	echo "<span class =\"linkgray\">{$user_name}</span>";
	echo "\t</div>\r\n\t";
}
if ( $COUNT == 0 )
{
	echo $nothingdata;
}
echo " <div align=\"right\" style=\"padding:2px；font-size:12px;\"><a href=\"/general/file_folder/index1.php\">更多</a></div>";
?>