📄 diary.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_file.php" );
echo " \r\n<html>\r\n<head>\r\n<title>工作日志</title>\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/";
echo $LOGIN_THEME;
echo "/diary.css\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script src=\"/inc/js/attach.js\"></script>\r\n<style>\r\n.pagebar{\r\n text-align: center;\r\n font-size: 12px;\r\n word-wrap:break-word;\r\n word-brak:normal;\r\n}\t\r\n</style>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<div id=\"body_top\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" margin-top=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"> <img src=\"/images/share_diary.gif\" WIDTH=\"18\" HEIGHT=\"18\" align=\"absmiddle\"><span class=\"big3\">共享日志</span>\r\n </td>\r\n </tr>\r\n</table>\r\n</div>\r\n<div class=\"body_content\">\r\n";
$query = "SELECT DIA_ID from DIARY where USER_ID='".$USER_ID."' and find_in_set('{$LOGIN_USER_ID}',TO_ID)";
$cursor = exequery( $connection, $query );
$NUM_ROWS = mysql_num_rows( $cursor );
$NUM_P = 10;
if ( $PAGE == "" )
{
$PAGE = 1;
}
$START = ( $PAGE - 1 ) * $NUM_P;
$P = ceil( $NUM_ROWS / $NUM_P );
$PRE_I = $PAGE - 1;
if ( $PAGE != 1 )
{
$PBAR_STR .= "<a href=\"diary.php?PAGE=1&USER_ID=".$USER_ID."&WINDOW={$WINDOW}\">首页</a> ";
$PBAR_STR .= "<a href=\"diary.php?PAGE=".$PRE_I."&USER_ID={$USER_ID}&WINDOW={$WINDOW}\">上一页</a> ";
}
$SHOW_COUNT = 0;
$I = 1;
for ( ; $I <= $P; ++$I )
{
if ( $I == $PAGE )
{
++$SHOW_COUNT;
$PBAR_STR .= " ".$I." ";
}
else if ( $P - 10 < $PAGE && $P - 10 < $I )
{
++$SHOW_COUNT;
if ( 10 < $SHOW_COUNT )
{
break;
}
$PBAR_STR .= "<a href=\"diary.php?PAGE=".$I."&USER_ID={$USER_ID}&WINDOW={$WINDOW}\">".$I."</a> ";
}
else if ( $PAGE - 5 < $I )
{
++$SHOW_COUNT;
if ( 10 < $SHOW_COUNT )
{
break;
}
$PBAR_STR .= "<a href=\"diary.php?PAGE=".$I."&USER_ID={$USER_ID}&WINDOW={$WINDOW}\">".$I."</a> ";
}
}
$NEXT_I = $PAGE + 1;
if ( $PAGE < $P )
{
$PBAR_STR .= "<a href=\"diary.php?PAGE=".$NEXT_I."&USER_ID={$USER_ID}&WINDOW={$WINDOW}\">下一页</a> ";
$PBAR_STR .= "<a href=\"diary.php?PAGE=".$P."&USER_ID={$USER_ID}&WINDOW={$WINDOW}\">末页</a> ";
}
$query = "SELECT DIA_ID,DIA_DATE,DIA_TIME,DIA_TYPE,SUBJECT,CONTENT,ATTACHMENT_ID,ATTACHMENT_NAME,USER_ID from DIARY where USER_ID='".$USER_ID."' and find_in_set('{$LOGIN_USER_ID}',TO_ID) order by DIA_TIME desc limit {$START},{$NUM_P}";
$cursor = exequery( $connection, $query );
$COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$COUNT;
$DIA_ID = $ROW['DIA_ID'];
$DIA_DATE = $ROW['DIA_DATE'];
$DIA_DATE = strtok( $DIA_DATE, " " );
$DIA_TIME = $ROW['DIA_TIME'];
$DIA_TYPE = $ROW['DIA_TYPE'];
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$USER_ID = $ROW['USER_ID'];
$query1 = "SELECT USER_NAME from USER where USER_ID='".$USER_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME = $ROW1['USER_NAME'];
}
$DIA_TYPE_DESC = get_code_name( $DIA_TYPE, "DIARY_TYPE" );
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
echo " <DIV class=\"one_diary\">\r\n <DIV class=\"subject\"><A>";
echo $SUBJECT;
echo "</A></DIV>\r\n <DIV class=\"diary_type\">";
echo $DIA_TYPE_DESC;
echo " | 日志日期：";
echo $DIA_DATE;
echo " | 最后修改：";
echo $DIA_TIME;
echo " | 作者：";
echo $USER_NAME;
echo "</DIV>\r\n <DIV class=\"content\" style=\"overflow-y:auto;overflow-x:auto;width=100%;height=100%\">\r\n ";
echo $CONTENT;
echo " \r\n </DIV>\r\n <DIV class=\"content\">\r\n";
if ( $ATTACHMENT_ID != "" )
{
echo "<br><br>附件：<br>";
echo attach_link( $ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1 );
}
echo " </DIV> \r\n </div> \r\n";
}
if ( $COUNT == 0 )
{
message( "", "无共享日志" );
}
echo " \r\n</div>\r\n<br />\r\n<br />\r\n";
if ( 1 < $P )
{
echo "<div class=\"pagebar\">";
echo $PBAR_STR;
echo "</div>\r\n";
}
echo "<div class=\"pagebar\">\r\n";
if ( $WINDOW )
{
echo " <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"parent.window.close();\">\r\n";
}
else
{
echo " <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"history.back();\">\r\n";
}
echo "</div>\r\n<br />\r\n<br />\r\n</body>\r\n</html>\t";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -