📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
<?
include_once("inc/auth.php");
?>

<html>
<head>
<title>日程安排</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<script>
	
function my_note(CAL_ID)
{
  window.open("note.php?CAL_ID="+CAL_ID,"note_win"+CAL_ID,"height=200,width=250,status=0,toolbar=no,menubar=no,location=no,scrollbars=auto,resizable=no");
}

function My_Submit()
{
  document.form1.submit();
}

function set_year(op)
{
  if(op==-1 && document.form1.YEAR.selectedIndex==0)
     return;
  if(op==1 && document.form1.YEAR.selectedIndex==(document.form1.YEAR.options.length-1))
     return;
  document.form1.YEAR.selectedIndex=document.form1.YEAR.selectedIndex+op;

  My_Submit();
}

function set_mon(op)
{
  if(op==-1 && document.form1.MONTH.selectedIndex==0)
     return;
  if(op==1 && document.form1.MONTH.selectedIndex==(document.form1.MONTH.options.length-1))
     return;
  document.form1.MONTH.selectedIndex=document.form1.MONTH.selectedIndex+op;

  My_Submit();
}

</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/calendar.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 日程安排</span>
    </td>
  </tr>
</table>

<?
$CUR_YEAR = date('Y');
$CUR_MON = date('m');
$CUR_DAY = date('d');

$DATE=1;
$DAY=1;

if(!$YEAR)
   $YEAR = $CUR_YEAR;
if(!$MONTH)
   $MONTH = $CUR_MON;

while (checkdate($MONTH,$DATE,$YEAR))
  $DATE++;

 //============================ 显示日程安排 =======================================
 $connection=OpenConnection();
 $query = "SELECT * from CALENDAR where USER_ID='$LOGIN_USER_ID' and year(CAL_TIME)=$YEAR and month(CAL_TIME)=$MONTH 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'";
       $cursor1= exequery($connection,$query);
       if($ROW1=mysql_fetch_array($cursor1))
          $MANAGER_NAME="<br>安排人：".$ROW1["USER_NAME"];
    }

    $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);

    if($OVER_STATUS=="" || $OVER_STATUS=="1")
       $OVER_STATUS1="<font color='#00AA00'><b>已完成</b></font>";
    elseif($OVER_STATUS=="0")
       $OVER_STATUS1="";
       
    switch($CAL_TYPE)
    {
     case "1":
         $CAL_TYPE="工作";
         break;
     case "2":
         $CAL_TYPE="个人";
         break;
    }

    $CAL_ARRAY[$CAL_DAY].="$CAL_TIME-$END_TIME<br><b>".$CAL_TYPE."</b>:<a href='#' onclick='javascript:my_note($CAL_ID);'>$CONTENT</a> ".$OVER_STATUS1.$MANAGER_NAME."<br>";
 }
?>

 <div align="center" class="Big1">
  <form action="index.php"  method="post" name="form1">

<!-------------- 年 ------------>
        <input type="button" value=" < " class="BigButton" style="font-weight:bold" title="上一年" onclick="set_year(-1);"><select name="YEAR" class="BigSelect" style="font-weight:bold" onchange="My_Submit();">
<?
        for($I=2000;$I<=2015;$I++)
        {
?>
          <option value="<?=$I?>" <? if($I==$YEAR) echo "selected";?>><?=$I?></option>
<?
        }
?>
        </select><input type="button" value=" > " class="BigButton" style="font-weight:bold" title="下一年" onclick="set_year(1);"> <b>年</b>

<!-------------- 月 ------------>
        <input type="button" value=" < " class="BigButton" style="font-weight:bold" title="上一月" onclick="set_mon(-1);"><select name="MONTH" class="BigSelect" style="font-weight:bold" onchange="My_Submit();">
<?
        for($I=1;$I<=12;$I++)
        {
          if($I<10)
             $I="0".$I;
?>
          <option value="<?=$I?>" <? if($I==$MONTH) echo "selected";?>><?=$I?></option>
<?
        }
?>
        </select><input type="button" value=" > " class="BigButton" style="font-weight:bold" title="下一月" onclick="set_mon(1);"> <b>月</b>
   &nbsp;&nbsp;<input type="button" value="本月" class="BigButton" title="本月" onclick="location='index.php?YEAR=<?=$CUR_YEAR?>&MONTH=<?=$CUR_MONTH?>'">
  </form>
 </div>

  <table width="100%" border="0" cellspacing="1" class="small" bgcolor="#000000" cellpadding="3" align="center">
    <tr align="center" class="TableHeader">
      <td bgcolor="#FFCCFF" width="10%"><b>日</b></td>
      <td width="15%"><b>一</b></td>
      <td width="15%"><b>二</b></td>
      <td width="15%"><b>三</b></td>
      <td width="15%"><b>四</b></td>
      <td width="15%"><b>五</b></td>
      <td bgcolor="#CCFFCC" width="10%"><b>六</b></td>
    </tr>
<?
while ($DAY<$DATE)
{
  if($DAY == $CUR_DAY && $YEAR == $CUR_YEAR && $MONTH == $CUR_MON)
     $DAY_COLOR = "TableContent";
  else
     $DAY_COLOR = "TableData";

  $WEEK=date("w",mktime(0,0,0,$MONTH,$DAY,$YEAR));

  if ($WEEK==0 || $DAY==1)
  {
?>
   <tr>
<?
  }

  if($DAY==1)
  {
    for($I=0;$I<$WEEK;$I++)
    {
?>
     <td class="TableData" valign="top">&nbsp</td>
<?
    }
  }
?>
     <td class="<?=$DAY_COLOR?>" valign="top">
       <div align=center style="font-size: 18pt;font-family:sans-serif"><b><a href="manage?YEAR=<?=$YEAR?>&MONTH=<?=$MONTH?>&DAY=<?=$DAY?>"><?=$DAY?></a></b></div>
       <?=$CAL_ARRAY[$DAY]?>
     </td>
<?
  if ($WEEK==6)
  {
?>
   </tr>
<?
  }

  $DAY++;
}//while

//------------- 补结尾空格 -------------
if($WEEK!=6)
{
  for($I=$WEEK;$I<6;$I++)
  {
?>
     <td class="TableData">&nbsp</td>
<?
  }
?>
   </tr>
<?
}


//-------------------------- 本月员工生日 -------------------------
 $CUR_MONTH=$MONTH;

 $query = "SELECT USER_NAME,BIRTHDAY from USER where NOT_LOGIN!='1' 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 || $BIRTHDAY=="1900-01-01 00:00:00" || $BIRTHDAY=="0000-00-00 00:00:00")
       continue;
    $PERSON_STR.=$USER_NAME."(".$DATA.")&nbsp&nbsp&nbsp&nbsp";
    $PERSON_COUNT++;
}
if($PERSON_COUNT>0)
{
?>

      <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>
      <?=$PERSON_STR?>
      </marquee>
      </td>
      </tr>
<?
}
?>
      </table>

</body>
</html>
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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