📄 user_list.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  echo '
<html>
<head>
<title>工作安排查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
  <table border="0" cellspacing="1" class="small" bgcolor="#000000" cellpadding="3" align="center">
    <tr align="center" class="TableHeader">
      <td width="80" class="Small">姓名</td>
';
  for ($DAY = $BEGIN_DAY; ($DAY <= $END_DAY); ++$DAY)
  {
    $WEEK = date ('w', mktime (0, 0, 0, $MONTH, $DAY, $YEAR));
    switch ($WEEK)
    {
      case 0:
      {
        $WEEK_DESC = '日';
        break;
      }
      case 1:
      {
        $WEEK_DESC = '一';
        break;
      }
      case 2:
      {
        $WEEK_DESC = '二';
        break;
      }
      case 3:
      {
        $WEEK_DESC = '三';
        break;
      }
      case 4:
      {
        $WEEK_DESC = '四';
        break;
      }
      case 5:
      {
        $WEEK_DESC = '五';
        break;
      }
      case 6:
      {
        $WEEK_DESC = '六';
        break;
      }
    }
    echo '
      <td ';
    if (($WEEK == 0))
    {
      echo 'bgcolor=#FFCCFF';
    }
    else
    {
      if (($WEEK == 6))
      {
        echo 'bgcolor=#CCFFCC';
      }
    }
    echo ' class="Small">
          ';
    echo $YEAR;
    echo '-';
    echo $MONTH;
    echo '-';
    echo $DAY;
    echo '<br>
          (周';
    echo $WEEK_DESC;
    echo ')
      </td>
';
  }
  echo '    </tr>
';
  $CUR_YEAR = date ('Y');
  $CUR_MON = date ('m');
  $CUR_DAY = date ('d');
  $query = (((''.'SELECT * from USER where USER_ID=\'').$USER_ID).'\' and NOT_LOGIN!=\'1\'');
  $cursor1 = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor1))
  {
    $USER_ID = $ROW['USER_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    echo '
<tr class="TableData">
<td width="80" align="center">';
    echo $USER_NAME;
    echo '</td>
';
    for ($DAY = $BEGIN_DAY; ($DAY <= $END_DAY); ++$DAY)
    {
      if (((($DAY == $CUR_DAY) AND ($YEAR == $CUR_YEAR)) AND ($MONTH == $CUR_MON)))
      {
        $DAY_COLOR = 'TableContent';
      }
      else
      {
        $DAY_COLOR = 'TableData';
      }
      echo '     <td class="';
      echo $DAY_COLOR;
      echo '">
';
      $query = (((((((((''.'SELECT * from CALENDAR where USER_ID=\'').$USER_ID).'\' and CAL_TYPE!=\'2\' and to_days(CAL_TIME)=to_days(\'').$YEAR).'-').$MONTH).'-').$DAY).'\') order by CAL_TIME');
      $cursor = exequery ($connection, $query);
      while ($ROW = mysql_fetch_array ($cursor))
      {
        $CAL_ID = $ROW['CAL_ID'];
        $CAL_TIME = $ROW['CAL_TIME'];
        $END_TIME = $ROW['END_TIME'];
        $CAL_TYPE = $ROW['CAL_TYPE'];
        $CONTENT = $ROW['CONTENT'];
        $MANAGER_ID = $ROW['MANAGER_ID'];
        $OVER_STATUS = $ROW['OVER_STATUS'];
        $MANAGER_NAME = '';
        if (($MANAGER_ID != ''))
        {
          $query = (((''.'SELECT * from USER where USER_ID=\'').$MANAGER_ID).'\'');
          $cursor2 = exequery ($connection, $query);
          if ($ROW1 = mysql_fetch_array ($cursor2))
          {
            $MANAGER_NAME = (('安排人：'.$ROW1['USER_NAME']).'<br>');
          }
        }
        if ((($OVER_STATUS == '') OR ($OVER_STATUS == '1')))
        {
          $OVER_STATUS1 = '<font color=\'#00AA00\'><b>已结束</b></font>';
        }
        else
        {
          if (($OVER_STATUS == '0'))
          {
            $OVER_STATUS1 = '';
          }
        }
        $CONTENT = str_replace ('<', '&lt', $CONTENT);
        $CONTENT = str_replace ('>', '&gt', $CONTENT);
        $CONTENT = stripslashes ($CONTENT);
        $CAL_DAY = strtok ($CAL_TIME, '-');
        $CAL_DAY = strtok ('-');
        $CAL_DAY = strtok (' ');
        if ((substr ($CAL_DAY, 0, 1) == '0'))
        {
          $CAL_DAY = substr ($CAL_DAY, -1);
        }
        $CAL_TIME = strtok ($CAL_TIME, ' ');
        $CAL_TIME = strtok (' ');
        $CAL_TIME = substr ($CAL_TIME, 0, 5);
        $END_TIME = strtok ($END_TIME, ' ');
        $END_TIME = strtok (' ');
        $END_TIME = substr ($END_TIME, 0, 5);
        echo '     ';
        echo $CAL_TIME;
        echo '-';
        echo $END_TIME;
        echo '<br>
';
        if (($MANAGER_ID == $LOGIN_USER_ID))
        {
          echo '     <a href="javascript:;" onclick="window.open(\'new.php?CAL_ID=';
          echo $CAL_ID;
          echo '\',\'oa_sub_window\',\'height=300,width=500,status=0,toolbar=no,menubar=no,location=no,left=300,top=200,scrollbars=yes,resizable=yes\');">';
          echo $CONTENT;
          echo '</a>  ';
          echo $OVER_STATUS1;
          echo '     <a href="delete.php?CAL_ID=';
          echo $CAL_ID;
          echo '&YEAR=';
          echo $YEAR;
          echo '&MONTH=';
          echo $MONTH;
          echo '&BEGIN_DAY=';
          echo $BEGIN_DAY;
          echo '&END_DAY=';
          echo $END_DAY;
          echo '&USER_ID=';
          echo $USER_ID;
          echo '">删除</a>
';
        }
        else
        {
          echo '     ';
          echo $CONTENT;
          echo ' ';
          echo $OVER_STATUS1;
        }
        echo '     &nbsp;<br>';
        echo $MANAGER_NAME;
      }
      echo '    </td>
';
    }
    echo '   </tr>
';
  }
  echo '</table>
</body>
</html>
';
?>
⌨️ 快捷键说明

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