index.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 436 行

PHP
436
字号
<?
  if ((($_COOKIE['cal_info_view'] == 'day') OR ($_COOKIE['cal_info_view'] == 'month')))
  {
    header ((('location:'.$_COOKIE['cal_info_view']).'.php'));
  }
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $CUR_YEAR = date ('Y');
  $CUR_MON = date ('m');
  $CUR_DAY = date ('d');
  if (($BTN_OP != ''))
  {
    $DATE = strtotime ($BTN_OP, strtotime ((((($YEAR.'-').$MONTH).'-').$DAY)));
    $YEAR = date ('Y', $DATE);
    $MONTH = date ('m', $DATE);
    $DAY = date ('d', $DATE);
  }
  if (!$YEAR)
  {
    $YEAR = $CUR_YEAR;
  }
  if (!$MONTH)
  {
    $MONTH = $CUR_MON;
  }
  if (!$DAY)
  {
    $DAY = $CUR_DAY;
  }
  if (!$DEPT_ID)
  {
    $DEPT_ID = $LOGIN_DEPT_ID;
  }
  if (!checkdate ($MONTH, $DAY, $YEAR))
  {
    message ('错误', '日期不正确');
    exit ();
  }
  $DATE = strtotime ((((($YEAR.'-').$MONTH).'-').$DAY));
  $WEEK_BEGIN = strtotime ((('-'.date ('w', $DATE)).'days'), $DATE);
  $WEEK_END = strtotime ('+6 days', $WEEK_BEGIN);
  echo '<html>
<head>
<title>日程安排查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
';
  echo '<s';
  echo 'cript>
function My_Submit()
{
  document.form1.submit();
}
function set_year(op)
{
  document.form1.BTN_OP.value=op+" year";
  My_Submit();
}
function set_mon(op)
{
  document.form1.BTN_OP.value=op+" month";
  My_Submit();
}
function set_day(op)
{
  document.form1.BTN_OP.value=op+" day";
  My_Submit();
}
function set_view(view)
{
    var view=document.form1.VIEW.value;
';
  echo '
    if(!view) return;
    var exp = new Date();
    exp.setTime(exp.getTime() + 24*60*60*1000);
    document.cookie = "cal_info_view="+ escape (view) + ";expires=" + exp.toGMTString()+";path=/";
    location=view+\'.php?YEAR=';
  echo $YEAR;
  echo '&MONTH=';
  echo $MONTH;
  echo '&DAY=';
  echo $DAY;
  echo '&DEPT_ID=';
  echo $DEPT_ID;
  echo '\';
}
</script>
</head>
<body class="bodycolor" topmargin="5">
 <form name="form1" action="';
  echo $_SERVER['SCRIPT_NAME'];
  echo '">
  <table width="100%" border="0" cellspacing="0" class="big1" cellpadding="3" align="center">
    <tr>
      <td>
       <input type="button" value="今天" class="SmallButton" title="今天" onclick="location=\'';
  echo $_SERVER['SCRIPT_NAME'];
  echo '?YEAR=';
  echo $CUR_YEAR;
  echo '&MONTH=';
  echo $CUR_MON;
  echo '&DAY=';
  echo $CUR_DAY;
  echo '&DEPT_ID=';
  echo $DEPT_ID;
  echo '\'">
       <input type="hidden" value="" name="BTN_OP">
<!-------------- 年 ------------>
        <input type="button" value=" < " class="SmallButton" style="font-weight:bold" title="上一年" onclick="set_year(-1);">';
  echo '<s';
  echo 'elect name="YEAR" class="SmallSelect" style="font-weight:bold" onchange="My_Submit();">
';
  for ($I = 2000; ($I <= 2015); ++$I)
  {
    echo '          <option value="';
    echo $I;
    echo '" ';
    if (($I == $YEAR))
    {
      echo 'selected';
    }
    echo '>';
    echo $I;
    echo '年</option>
';
  }
  echo '        </select><input type="button" value=" > " class="SmallButton" style="font-weight:bold" title="下一年" onclick="set_year(1);">
<!-------------- 月 ------------>
        <input type="button" value=" < " class="SmallButton" style="font-weight:bold" title="上一月" onclick="set_mon(-1);">';
  echo '<s';
  echo 'elect name="MONTH" class="SmallSelect" style="font-weight:bold" onchange="My_Submit();">
';
  for ($I = 1; ($I <= 12); ++$I)
  {
    if (($I < 10))
    {
      $I = ('0'.$I);
    }
    echo '          <option value="';
    echo $I;
    echo '" ';
    if (($I == $MONTH))
    {
      echo 'selected';
    }
    echo '>';
    echo $I;
    echo '月</option>
';
  }
  echo '        </select><input type="button" value=" > " class="SmallButton" style="font-weight:bold" title="下一月" onclick="set_mon(1);">
<!-------------- 日 ------------>
        <input type="button" value=" < " class="SmallButton" style="font-weight:bold" title="上一天" onclick="set_day(-1);">';
  echo '<s';
  echo 'elect name="DAY" class="SmallSelect" style="font-weight:bold" onchange="My_Submit();">
';
  for ($I = 1; ($I <= date ('t', strtotime ((((($YEAR.'-').$MONTH).'-').$DAY)))); ++$I)
  {
    if (($I < 10))
    {
      $I = ('0'.$I);
    }
    echo '          <option value="';
    echo $I;
    echo '" ';
    if (($I == $DAY))
    {
      echo 'selected';
    }
    echo '>';
    echo $I;
    echo '日</option>
';
  }
  echo '        </select><input type="button" value=" > " class="SmallButton" style="font-weight:bold" title="下一天" onclick="set_day(1);">
      </td>
      <td align="right">
        ';
  echo '<s';
  echo 'elect name="DEPT_ID" class="BigSelect" onchange="My_Submit();">
';
  echo my_dept_tree (0, $DEPT_ID, 1);
  echo '        </select>
        ';
  echo '<s';
  echo 'elect name="VIEW" class="BigSelect" onchange="set_view();">
          <option value="day">&nbsp;日列表</option>
          <option value="index" selected>&nbsp;周列表</option>
          <option value="month">&nbsp;月列表</option>
        </select>
      </td>
    </tr>
  </table>
  <table width="100%" border="0" cellspacing="1" class="small" bgcolor="#000000" cellpadding="3" align="center">
    <t';
  echo 'r align="center" class="TableHeader">
      <td width="80" class="Small">姓名</td>
';
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  for ($WEEK_DATE = $WEEK_BEGIN; ($WEEK_DATE <= $WEEK_END); $WEEK_DATE = strtotime ('+1 day', $WEEK_DATE))
  {
    $WEEK = date ('w', $WEEK_DATE);
    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">
          <a href="day.php?YEAR=';
    echo date ('Y', $WEEK_DATE);
    echo '&MONTH=';
    echo date ('m', $WEEK_DATE);
    echo '&DAY=';
    echo date ('d', $WEEK_DATE);
    echo '&DEPT_ID=';
    echo $DEPT_ID;
    echo '">';
    echo date ('m/d', $WEEK_DATE);
    echo '(周';
    echo $WEEK_DESC;
    echo ')</a>
      </td>
';
  }
  echo '    </tr>
';
  $query = ((''.'SELECT PRIV_NO from USER_PRIV where USER_PRIV=').$LOGIN_USER_PRIV);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $PRIV_NO = $ROW['PRIV_NO'];
  }
  if (($LOGIN_USER_PRIV == '1'))
  {
    $query = (((''.'SELECT USER_ID,USER_NAME from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID=').$DEPT_ID).' and NOT_LOGIN!=\'1\' order by PRIV_NO,USER_NO,USER_NAME');
  }
  else
  {
    $query = (((((''.'SELECT USER_ID,USER_NAME from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID=').$DEPT_ID).' AND USER_PRIV.PRIV_NO>').$PRIV_NO).' and NOT_LOGIN!=\'1\' order by PRIV_NO,USER_NO,USER_NAME');
  }
  $cursor1 = exequery ($connection, $query);
  while ($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 ($WEEK_DATE = $WEEK_BEGIN; ($WEEK_DATE <= $WEEK_END); $WEEK_DATE = strtotime ('+1 day', $WEEK_DATE))
    {
      $WEEK_YEAR = date ('Y', $WEEK_DATE);
      $WEEK_MON = date ('m', $WEEK_DATE);
      $WEEK_DAY = date ('d', $WEEK_DATE);
      if (((($WEEK_DAY == $DAY) AND ($YEAR == $WEEK_YEAR)) AND ($MONTH == $WEEK_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(\'').$WEEK_YEAR).'-').$WEEK_MON).'-').$WEEK_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>');
          }
        }
        $CAL_TITLE = (('类型:'.get_code_name ($CAL_TYPE, 'CAL_TYPE')).'
');
        if (($OVER_STATUS == '0'))
        {
          if ((0 < compare_time ($CUR_TIME, $END_TIME)))
          {
            $STATUS_COLOR = '#FF0000';
            ($CAL_TITLE .= '状态:已过期');
          }
          else
          {
            if ((compare_time ($CUR_TIME, $CAL_TIME) < 0))
            {
              $STATUS_COLOR = '#0000FF';
              ($CAL_TITLE .= '状态:未至');
            }
            else
            {
              $STATUS_COLOR = '#0000FF';
              ($CAL_TITLE .= '状态:进行中');
            }
          }
        }
        else
        {
          $STATUS_COLOR = '#00AA00';
          ($CAL_TITLE .= '状态:已完成');
        }
        $CONTENT = htmlspecialchars ($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 '     <div title="';
        echo $CAL_TITLE;
        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\');" style="color:';
          echo $STATUS_COLOR;
          echo ';">';
          echo $CONTENT;
          echo '</a>
        <a href="delete.php?CAL_ID=';
          echo $CAL_ID;
          echo '&YEAR=';
          echo $YEAR;
          echo '&MONTH=';
          echo $MONTH;
          echo '&WEEK_BEGIN=';
          echo $WEEK_BEGIN;
          echo '&WEEK_END=';
          echo $WEEK_END;
          echo '&DEPT_ID=';
          echo $DEPT_ID;
          echo '">删除</a>
';
        }
        else
        {
          echo '     ';
          echo '<s';
          echo 'pan style="color:';
          echo $STATUS_COLOR;
          echo ';">';
          echo $CONTENT;
          echo '</span>
';
        }
        echo '     &nbsp;<br>';
        echo $MANAGER_NAME;
        echo '</div>
';
      }
      echo '      </td>
';
    }
    echo '    </tr>
';
  }
  echo '  </table>
</body>
</html>
';
?>

⌨️ 快捷键说明

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