📄 index.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>日常事务</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function delete_affair(AFF_ID)
{
 msg=\'确认要删除该事务么？\';
 if(window.confirm(msg))
 {
  URL="delete.php?AFF_ID=" + AFF_ID;
  window.location=URL;
 }
}
function my_note(AFF_ID)
{
  my_left=document.body.scrollLeft+event.clientX-event.offsetX-50;
  my_top=document.body.scrollTop+event.clientY-event.offsetY+150;
  window.open("note.php?AFF_ID="+AFF_ID,"note_win"+AFF_ID,"h';
  echo 'eight=170,width=180,status=0,toolbar=no,menubar=no,location=no,scrollbars=auto,top="+ my_top +",left="+ my_left +",resizable=no");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/diary.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 新建日常事务</span><br>
    </td>
  </tr>
</table>
<div align="center">
<input type="button" value="新建日常事务" class="BigButton" onClick="location=\'new\';" title="新建日常事务">
</div>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
   <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>
<table border="0" width="100%" c';
  echo 'ellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/diary.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 日常事务管理</span>
    </td>
  </tr>
</table>
<br>
';
  $CUR_DATE = date ('Y-m-d', time ());
  $query = (((''.'SELECT * from AFFAIR where USER_ID=\'').$LOGIN_USER_ID).'\' order by BEGIN_TIME desc');
  $cursor = exequery ($connection, $query);
  $AFF_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$AFF_COUNT;
    $AFF_ID = $ROW['AFF_ID'];
    $USER_ID = $ROW['USER_ID'];
    $BEGIN_TIME = $ROW['BEGIN_TIME'];
    $TYPE = $ROW['TYPE'];
    $REMIND_DATE = $ROW['REMIND_DATE'];
    $REMIND_TIME = $ROW['REMIND_TIME'];
    $CONTENT = $ROW['CONTENT'];
    $CONTENT = str_replace ('<', '&lt', $CONTENT);
    $CONTENT = str_replace ('>', '&gt', $CONTENT);
    $CONTENT = stripslashes ($CONTENT);
    switch ($TYPE)
    {
      case '2':
      {
        $TYPE_DESC = '按日提醒';
        break;
      }
      case '3':
      {
        $TYPE_DESC = '按周提醒';
        if (($REMIND_DATE == '1'))
        {
          $REMIND_DATE = '周一';
          break;
        }
        else
        {
          if (($REMIND_DATE == '2'))
          {
            $REMIND_DATE = '周二';
            break;
          }
          else
          {
            if (($REMIND_DATE == '3'))
            {
              $REMIND_DATE = '周三';
              break;
            }
            else
            {
              if (($REMIND_DATE == '4'))
              {
                $REMIND_DATE = '周四';
                break;
              }
              else
              {
                if (($REMIND_DATE == '5'))
                {
                  $REMIND_DATE = '周五';
                  break;
                }
                else
                {
                  if (($REMIND_DATE == '6'))
                  {
                    $REMIND_DATE = '周六';
                    break;
                  }
                  else
                  {
                    if (($REMIND_DATE == '0'))
                    {
                      $REMIND_DATE = '周日';
                      break;
                    }
                    break;
                  }
                  break;
                }
                break;
              }
              break;
            }
            break;
          }
          break;
        }
        break;
      }
      case '4':
      {
        $TYPE_DESC = '按月提醒';
        ($REMIND_DATE .= '日');
        break;
      }
      case '5':
      {
        $TYPE_DESC = '按年提醒';
        $REMIND_DATE = (str_replace ('-', '月', $REMIND_DATE).'日');
        break;
      }
    }
    if (($AFF_COUNT == 1))
    {
      echo '
    <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
    }
    if ((($AFF_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td align="center">';
    echo $BEGIN_TIME;
    echo '</td>
      <td nowrap align="center">';
    echo $TYPE_DESC;
    echo '</td>
      <td nowrap align="center">';
    echo $REMIND_DATE;
    echo '</td>
      <td nowrap align="center">';
    echo $REMIND_TIME;
    echo '</td>
      <td><a href="#" onclick="my_note(';
    echo $AFF_ID;
    echo ');">';
    echo csubstr (strip_tags ($CONTENT), 0, 100);
    echo ' ';
    if ((20 < strlen ($CONTENT)))
    {
      echo '...';
    }
    echo '</a></td>
      <td nowrap align="center">
          <a href="modify.php?AFF_ID=';
    echo $AFF_ID;
    echo '"> 修改</a>&nbsp;
          <a href="javascript:delete_affair(';
    echo $AFF_ID;
    echo ');"> 删除</a>
      </td>
    </tr>
';
  }
  if (($AFF_COUNT == 0))
  {
    message ('', '无事务记录');
    exit ();
  }
  else
  {
    echo '   <thead class="TableHeader">
      <td nowrap align="center">起始时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
      <td nowrap align="center" width="70">提醒类型</td>
      <td nowrap align="center" width="70">提醒日期</td>
      <td nowrap align="center" width="70">提醒时间</td>
      <td nowrap align="center">事务内容</td>
      <td nowrap align="center" width="70">操
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -