day.php

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

PHP
401 行
字号 
<?
  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" selected>&nbsp;日列表</option>
          <option value="index">&nbsp;周列表</option>
          <option value="month">&nbsp;月列表</option>
        </select>
      </td>
    </tr>
  </table>
';
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  $WEEK = date ('w', $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 '  <table width="100%" border="0" cellspacing="1" class="small" bgcolor="#000000" cellpadding="3" align="center">
    <tr align="center" class="TableHeader">
      <td width="80">姓名</td>
      <td>';
  echo $YEAR;
  echo '-';
  echo $MONTH;
  echo '-';
  echo $DAY;
  echo ' (周';
  echo $WEEK_DESC;
  echo ')</td>
      <td width="60">操作</td>
    </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 align="center">';
    echo $USER_NAME;
    echo '</td>
      <td>
';
    $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 USER_NAME from USER where USER_ID=\'').$MANAGER_ID).'\'');
        $cursor2 = exequery ($connection, $query);
        if ($ROW1 = mysql_fetch_array ($cursor2))
        {
          $MANAGER_NAME = (('(安排人：'.$ROW1['USER_NAME']).')');
        }
      }
      $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 '&nbsp;
';
      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 '&BEGIN_DAY=';
        echo $BEGIN_DAY;
        echo '&END_DAY=';
        echo $END_DAY;
        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;';
      echo $MANAGER_NAME;
      echo '<br></div>
';
    }
    echo '      </td>
      <td align="center"><a href="javascript:;" onclick="window.open(\'new.php?YEAR=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&DAY=';
    echo $DAY;
    echo '&USER_ID=';
    echo $USER_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\');">安排工作</a></td>
    </tr>
';
  }
  echo '  </table>
</body>
</html>
';
?>

day.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 day.php 源码文件，采用 PHP 编程语言编写，共 401 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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