month.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 524 行 · 第 1/2 页

        else
        {
          $STATUS_COLOR = '#0000FF';
          ($CAL_TITLE .= '状态：进行中');
        }
      }
    }
    else
    {
      $STATUS_COLOR = '#00AA00';
      ($CAL_TITLE .= '状态：已完成');
    }
    if (($MANAGER_ID != ''))
    {
      $query = (((''.'SELECT USER_NAME from USER where USER_ID=\'').$MANAGER_ID).'\'');
      $cursor1 = exequery ($connection, $query);
      if ($ROW1 = mysql_fetch_array ($cursor1))
      {
        ($CAL_TITLE .= ('
安排人：'.$ROW1['USER_NAME']));
      }
    }
    $CONTENT = htmlspecialchars ($CONTENT);
    $CONTENT = (((((((((((('<div id="cal_'.$CAL_ID).'" title=\'').$CAL_TITLE).'\'>').substr ($CAL_TIME, 11, 5)).'-').substr ($END_TIME, 11, 5)).(((''.'<br><a href=\'javascript:my_note(').$CAL_ID).');\' style=\'color:')).$STATUS_COLOR).';\'>').$CONTENT).'</a>');
    ($CONTENT .= (('<br><span id="cal_'.$CAL_ID).'_op" style="display:none;">'));
    if (($OVER_STATUS == '0'))
    {
      ($CONTENT .= (((((((((''.'<a href="status.php?CAL_ID=').$CAL_ID).'&OVER_STATUS=1&YEAR=').$YEAR).'&MONTH=').$MONTH).'&DAY=').$DAY).'"> &nbsp;完成</a>'));
    }
    else
    {
      if ((($OVER_STATUS == '') OR ($OVER_STATUS == '1')))
      {
        ($CONTENT .= (((((((((''.'<a href="status.php?CAL_ID=').$CAL_ID).'&OVER_STATUS=0&YEAR=').$YEAR).'&MONTH=').$MONTH).'&DAY=').$DAY).'"> 未完成</a>'));
      }
    }
    if ((($MANAGER_ID == '') OR ($MANAGER_ID == $LOGIN_USER_ID)))
    {
      ($CONTENT .= (((((((((''.'<a href="modify.php?CAL_ID=').$CAL_ID).'&OVER_STATUS=1&YEAR=').$YEAR).'&MONTH=').$MONTH).'&DAY=').$DAY).'"> 修改</a>'));
      ($CONTENT .= (((((((((''.'<a href="delete.php?CAL_ID=').$CAL_ID).'&OVER_STATUS=1&YEAR=').$YEAR).'&MONTH=').$MONTH).'&DAY=').$DAY).'"> 删除</a>'));
    }
    ($CONTENT .= '</span></div>');
    ($CAL_ARRAY[date ('j', strtotime ($CAL_TIME))] .= $CONTENT);
  }
  for ($I = 1; ($I <= date ('t', $DATE)); ++$I)
  {
    $DAY_I = strtotime ((((($YEAR.'-').$MONTH).'-').$I));
    $query = (((((((((((''.'SELECT * from AFFAIR where USER_ID=\'').$LOGIN_USER_ID).'\' and BEGIN_TIME<=\'').date ('Y-m-d', $DAY_I)).' 23:59:59\' and (TYPE=\'2\' or TYPE=\'3\' and REMIND_DATE=\'').date ('w', $DAY_I)).'\' or TYPE=\'4\' and REMIND_DATE=\'').date ('j', $DAY_I)).'\' or TYPE=\'5\' and REMIND_DATE=\'').date ('n-j', $DAY_I)).'\') order by BEGIN_TIME desc');
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $AFF_ID = $ROW['AFF_ID'];
      $BEGIN_TIME = $ROW['BEGIN_TIME'];
      $REMIND_DATE = $ROW['REMIND_DATE'];
      $REMIND_TIME = $ROW['REMIND_TIME'];
      $CONTENT = $ROW['CONTENT'];
      $TYPE = $ROW['TYPE'];
      $LAST_REMIND = $ROW['LAST_REMIND'];
      $CONTENT = htmlspecialchars ($CONTENT);
      if (($LAST_REMIND == '0000-00-00'))
      {
        $LAST_REMIND = '';
      }
      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;
        }
      }
      $AFF_TITLE = (((((((('提醒时间：'.$TYPE_DESC).$REMIND_DATE).' ').substr ($REMIND_TIME, 0, -3)).'
上次提醒：').$LAST_REMIND).'
起始时间：').$BEGIN_TIME);
      $CONTENT = (((((substr ($REMIND_TIME, 0, -3).(((''.'<br><a href=\'javascript:my_affair(').$AFF_ID).');\' title=\'')).$AFF_TITLE).'\'>').$CONTENT).'</a><br>');
      if (($BEGIN_TIME <= ((date ('Y-m-d', $DAY_I).' ').$REMIND_TIME)))
      {
        ($CAL_ARRAY[$I] .= $CONTENT);
        continue;
      }
    }
  }
  echo '  <table width="100%" border="0" cellspacing="1" class="small" bgcolor="#000000" cellpadding="3" align="center">
    <tr align="center" class="TableHeader" height="20">
      <td width="14%"><b>周日</b></td>
      <td width="15%"><b>周一</b></td>
      <td width="15%"><b>周二</b></td>
      <td width="14%"><b>周三</b></td>
      <td width="14%"><b>周四</b></td>
      <td width="14%"><b>周五</b></td>
      <td width=';
  echo '"14%"><b>周六</b></td>
    </tr>
';
  for ($I = 1; ($I <= date ('t', $DATE)); ++$I)
  {
    $WEEK = date ('w', strtotime ((((($YEAR.'-').$MONTH).'-').$I)));
    if ((($WEEK == 0) OR ($I == 1)))
    {
      echo '<tr height="80" class="TableData">';
    }
    for ($J = 0; (($J < $WEEK) AND ($I == 1)); ++$J)
    {
      echo '     <td class="TableData" valign="top">&nbsp</td>
';
    }
    echo '     <td class="';
    if (($I == $DAY))
    {
      echo 'TableContent';
    }
    echo '" valign="top">
       <div align="right" class="TableContent" title="转到该日查看" style="cursor:hand;width: 100%;" onclick=\'location="day.php?YEAR=';
    echo $YEAR;
    echo '&MONTH=';
    echo $MONTH;
    echo '&DAY=';
    echo $I;
    echo '"\'>
         <font color="blue"><b>';
    echo $I;
    echo '</b></font>
       </div>
       <div>
         ';
    echo $CAL_ARRAY[$I];
    echo '       </div>
     </td>
';
    if (($WEEK == 6))
    {
      echo '</tr>';
      continue;
    }
  }
  if (($WEEK != 6))
  {
    for ($I = $WEEK; ($I < 6); ++$I)
    {
      echo '     <td class="TableData">&nbsp</td>
';
    }
    echo '   </tr>
';
  }
  $CUR_MONTH = $MONTH;
  $query = 'SELECT USER_NAME,BIRTHDAY from USER where NOT_LOGIN!=\'1\' and DEPT_ID!=0 order by SUBSTRING(BIRTHDAY,6,5),USER_NAME ASC';
  $cursor = exequery ($connection, $query);
  $PERSON_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_NAME = $ROW['USER_NAME'];
    $BIRTHDAY = $ROW['BIRTHDAY'];
    $MON = substr ($BIRTHDAY, 5, 2);
    $DATA = substr ($BIRTHDAY, 5, 5);
    if (((($MON != $CUR_MONTH) OR ($BIRTHDAY == '1900-01-01 00:00:00')) OR ($BIRTHDAY == '0000-00-00 00:00:00')))
    {
      continue;
    }
    else
    {
      ($PERSON_STR .= ((($USER_NAME.'(').$DATA).')&nbsp&nbsp&nbsp&nbsp'));
      ++$PERSON_COUNT;
      continue;
    }
  }
  if ((0 < $PERSON_COUNT))
  {
    echo '
      <tr class="TableData">
      <td style="color:#46A718" align="center"><b>本月生日：</b></td>
      <td colspan="20">
      <marquee style="color:#FF6600;" behavior=scroll scrollamount=3 scrolldelay=120 onmouseover=\'this.stop()\' onmouseout=\'this.start()\' border=0>
      ';
    echo $PERSON_STR;
    echo '      </marquee>
      </td>
      </tr>
';
  }
  echo '      </table>
</body>
</html>
';
?>