note.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 84 行
PHP
84 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
';
$query = (((((''.'select * from CALENDAR where CAL_ID=\'').$CAL_ID).'\' and USER_ID=\'').$LOGIN_USER_ID).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$CAL_TIME = $ROW['CAL_TIME'];
$END_TIME = $ROW['END_TIME'];
$CONTENT = $ROW['CONTENT'];
$OVER_STATUS = $ROW['OVER_STATUS'];
$CONTENT = str_replace ('<', '<', $CONTENT);
$CONTENT = str_replace ('>', '>', $CONTENT);
$CONTENT = stripslashes ($CONTENT);
$MANAGER_ID = $ROW['MANAGER_ID'];
$MANAGER_NAME = '';
if (($MANAGER_ID != ''))
{
$query = (((''.'SELECT * from USER where USER_ID=\'').$MANAGER_ID).'\'');
$cursor1 = exequery ($connection, $query);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$MANAGER_NAME = ('<br>安排人:'.$ROW1['USER_NAME']);
}
}
if ((($OVER_STATUS == '') OR ($OVER_STATUS == '1')))
{
if (($MANAGER_NAME == ''))
{
$OVER_STATUS1 = '<br><font color=\'#00AA00\'><b>已完成</b></font>';
}
else
{
$OVER_STATUS1 = '<font color=\'#00AA00\'><b>已完成</b></font>';
}
}
else
{
if (($OVER_STATUS == '0'))
{
if (($MANAGER_NAME == ''))
{
$OVER_STATUS1 = '<br><font color=\'#FF0000\'><b>未完成</b></font>';
}
else
{
$OVER_STATUS1 = '<font color=\'#FF0000\'><b>未完成</b></font>';
}
}
}
$TITLE = csubstr ($CONTENT, 0, 10);
$CAL_TIME = substr ($CAL_TIME, 0, -3);
$END_TIME = substr ($END_TIME, 11, -3);
}
echo '
<head>
<title>';
echo $TITLE;
echo ' </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFCC" topmargin="5">
<div class="small">
';
echo $CAL_TIME;
echo ' - ';
echo $END_TIME;
echo ' ';
echo $OVER_STATUS1;
echo ' ';
echo $MANAGER_NAME;
echo '
<hr>
';
echo $CONTENT;
echo '</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?