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 ('<', '&lt', $CONTENT);
    $CONTENT = str_replace ('>', '&gt', $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 + -
显示快捷键?