index1.php

来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 337 行

PHP
337 行
字号 
<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
if ( !isset( $DEPT_ID ) )
{
	$query = "SELECT POST_PRIV,POST_DEPT,DEPT_ID from USER where USER_ID='".$LOGIN_USER_ID."'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$POST_PRIV = $ROW['POST_PRIV'];
		$POST_DEPT = $ROW['POST_DEPT'];
	}
	if ( $POST_PRIV == 0 )
	{
		$DEPT_ID = $LOGIN_DEPT_ID;
	}
	else if ( $POST_PRIV == 2 )
	{
		$query = "SELECT DEPT_ID from DEPARTMENT WHERE find_in_set(DEPT_ID,'".$POST_DEPT."') ORDER BY DEPT_NO";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$DEPT_ID = $ROW['DEPT_ID'];
		}
		else
		{
			$DEPT_ID = 0;
		}
	}
	else
	{
		$query = "SELECT DEPT_ID from DEPARTMENT ORDER BY DEPT_NO";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$DEPT_ID = $ROW['DEPT_ID'];
		}
		else
		{
			$DEPT_ID = 0;
		}
	}
}
echo "\r\n<html>\r\n<head>\r\n<title>日程安排</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script>\r\nfunction My_Submit()\r\n{\r\n  document.form1.submit();\r\n}\r\nfunction my_affair(AFF_ID)\r\n{\r\n  myleft=(screen.availWidth-250)/2;\r\n  mytop=(screen.availHeight-200)/2;\r\n  window.open(\"../affair/note.php?AFF_ID=\"+AFF_ID,\"note_win\"+AFF_ID,\"height=200,width=250,status=0,toolbar=no,menubar=no,location=no,scrollbars=auto,resizable=no,top=\"+mytop+\",left=\"+myleft);\r\n}\r\n\r\nfunction my_note(CAL_ID)\r\n{\r\n  myleft=(screen.availWidth-250)/2;\r\n  mytop=(screen.availHeight-200)/2;\r\n  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,top=\"+mytop+\",left=\"+myleft);\r\n}\r\n\r\nfunction My_Submit()\r\n{\r\n  document.form1.submit();\r\n}\r\n\r\nfunction set_year(op)\r\n{\r\n  document.form1.BTN_OP.value=op+\" year\";\r\n  My_Submit();\r\n}\r\n\r\nfunction set_mon(op)\r\n{\r\n  document.form1.BTN_OP.value=op+\" month\";\r\n  My_Submit();\r\n}\r\n\r\nfunction set_day(op)\r\n{\r\n  document.form1.BTN_OP.value=op+\" day\";\r\n  My_Submit();\r\n}\r\n\r\nfunction display_front()\r\n{\r\n   var front=document.getElementById(\"front\");\r\n   if(!front)\r\n      return;\r\n   if(front.style.display=='')\r\n      front.style.display='none';\r\n   else\r\n      front.style.display='';\r\n}\r\n\r\nfunction init()\r\n{\r\n   var elementI=document.getElementsByTagName(\"DIV\");\r\n\r\n   for(i=0;i<elementI.length;i++)\r\n   {\r\n      if(elementI[i].id.substr(0,4)!=\"cal_\")\r\n         continue;\r\n\r\n      elementI[i].onmouseover=function() {var op_i=document.getElementById(this.id+\"_op\");if(op_i) op_i.style.display=\"\";}\r\n      elementI[i].onmouseout =function() {var op_i=document.getElementById(this.id+\"_op\");if(op_i) op_i.style.display=\"none\";}\r\n   }\r\n}\r\n";
$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;
}
echo "function set_view()\r\n{\r\n    var view=document.form1.VIEW.value;\r\n    if(!view) return;\r\n    var exp = new Date();\r\n    exp.setTime(exp.getTime() + 24*60*60*1000);\r\n    document.cookie = \"cal_view=\"+ escape (view) + \";expires=\" + exp.toGMTString()+\";path=/\";\r\n    \r\n    location=view+'.php?YEAR=";
echo $YEAR;
echo "&MONTH=";
echo $MONTH;
echo "&DAY=";
echo $DAY;
echo "';\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"init();\">\r\n";
if ( !checkdate( $MONTH, $DAY, $YEAR ) )
{
	message( "错误", "日期不正确" );
	exit( );
}
$DATE = strtotime( $YEAR."-".$MONTH."-".$DAY );
echo " <form name=\"form1\" action=\"";
echo $_SERVER['SCRIPT_NAME'];
echo "\">\r\n  <table width=\"100%\" border=\"0\" cellspacing=\"0\" class=\"big1\" cellpadding=\"3\" align=\"center\">\r\n    <tr>\r\n      <td>\r\n       <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 "'\">\r\n       <input type=\"hidden\" value=\"\" name=\"BTN_OP\">\r\n<!-------------- 年 ------------>\r\n        <input type=\"button\" value=\" < \" class=\"SmallButton\" style=\"font-weight:bold\" title=\"上一年\" onclick=\"set_year(-1);\"><select name=\"YEAR\" class=\"SmallSelect\" style=\"font-weight:bold\" onchange=\"My_Submit();\">\r\n";
$I = 2000;
for ( ;	$I <= 2015;	++$I	)
{
	echo "          <option value=\"";
	echo $I;
	echo "\" ";
	if ( $I == $YEAR )
	{
		echo "selected";
	}
	echo ">";
	echo $I;
	echo "</option>\r\n";
}
echo "        </select><input type=\"button\" value=\" > \" class=\"SmallButton\" style=\"font-weight:bold\" title=\"下一年\" onclick=\"set_year(1);\"><b>年</b>\r\n\r\n<!-------------- 月 ------------>\r\n        <input type=\"button\" value=\" < \" class=\"SmallButton\" style=\"font-weight:bold\" title=\"上一月\" onclick=\"set_mon(-1);\"><select name=\"MONTH\" class=\"SmallSelect\" style=\"font-weight:bold\" onchange=\"My_Submit();\">\r\n";
$I = 1;
for ( ;	$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>\r\n";
}
echo "        </select><input type=\"button\" value=\" > \" class=\"SmallButton\" style=\"font-weight:bold\" title=\"下一月\" onclick=\"set_mon(1);\"><b>月</b>\r\n<!-------------- 日 ------------>\r\n        <input type=\"button\" value=\" < \" class=\"SmallButton\" style=\"font-weight:bold\" title=\"上一天\" onclick=\"set_day(-1);\"><select name=\"DAY\" class=\"SmallSelect\" style=\"font-weight:bold\" onchange=\"My_Submit();\">\r\n";
$I = 1;
for ( ;	$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>\r\n";
}
echo "        </select><input type=\"button\" value=\" > \" class=\"SmallButton\" style=\"font-weight:bold\" title=\"下一天\" onclick=\"set_day(1);\"><b>日</b>\r\n      </td>\r\n      <td align=\"right\">\r\n        <select name=\"DEPT_ID\" class=\"BigSelect\" onchange=\"My_Submit();\">\r\n";
echo my_dept_tree( 0, $DEPT_ID, 1 );
echo "        </select>&nbsp;\r\n        <select name=\"VIEW\" class=\"BigSelect\" onchange=\"set_view();\">\r\n          <option value=\"index\" selected>&nbsp;日列表</option>\r\n          <option value=\"week\">&nbsp;周列表</option>\r\n          <option value=\"month\">&nbsp;月列表</option>\r\n          <option value=\"year\">&nbsp;年列表</option>\r\n        </select>\r\n      </td>\r\n    </tr>\r\n  </table>\r\n\r\n  <table width=\"100%\" border=\"0\" cellspacing=\"1\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\">\r\n    <tr align=\"center\" class=\"TableHeader\">\r\n      <td width=\"80\" class=\"Small\">姓名</td>\r\n";
$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 = "六";
}
echo "\r\n      <td ";
if ( $WEEK == 0 )
{
	echo "bgcolor=#FFCCFF";
}
else if ( $WEEK == 6 )
{
	echo "bgcolor=#CCFFCC";
}
echo " class=\"Small\">\r\n          ";
echo $YEAR;
echo "-";
echo $MONTH;
echo "-";
echo $DAY;
echo " \r\n          (周";
echo $WEEK_DESC;
echo ")\r\n      </td>\r\n";
if ( $BEGIN_DAY == $END_DAY )
{
	echo "      <td width=\"80\">操作</td>\r\n";
}
echo "    </tr>\r\n\r\n";
$CUR_YEAR = date( "Y" );
$CUR_MON = date( "m" );
$CUR_DAY = date( "d" );
$query = "SELECT * from USER_PRIV where USER_PRIV=".$LOGIN_USER_PRIV;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PRIV_NO = $ROW['PRIV_NO'];
}
$query = "SELECT * from SYS_PARA where PARA_NAME='CALENDAR_MANAGER'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$CALENDAR_MANAGER = $ROW['PARA_VALUE'];
}
if ( $LOGIN_USER_PRIV == "1" || find_id( $CALENDAR_MANAGER, $LOGIN_USER_ID ) )
{
	$query = "SELECT * 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 * 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 "\r\n<tr class=\"TableData\">\r\n<td width=\"80\" align=\"center\">";
	echo $USER_NAME;
	echo "</td>\r\n\r\n";
	if ( $DAY == $CUR_DAY && $YEAR == $CUR_YEAR && $MONTH == $CUR_MON )
	{
		$DAY_COLOR = "TableContent";
	}
	else
	{
		$DAY_COLOR = "TableData";
	}
	echo "     <td class=\"";
	echo $DAY_COLOR;
	echo "\">\r\n";
	$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 == "" || $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;
		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 "&DEPT_ID=";
			echo $DEPT_ID;
			echo "\">删除</a>\r\n";
		}
		else
		{
			echo "     ";
			echo $CONTENT;
			echo " ";
			echo $OVER_STATUS1;
		}
		echo "     &nbsp;";
		echo $MANAGER_NAME;
	}
	echo "    </td>\r\n";
	if ( $BEGIN_DAY == $END_DAY )
	{
		echo "    <td width=\"80\" 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=350,width=500,status=0,toolbar=no,menubar=no,location=no,left=300,top=200,scrollbars=yes,resizable=yes');\">安排工作</a></td>\r\n";
	}
	echo "   </tr>\r\n";
}
echo "</table>\r\n\r\n</body>\r\n</html>\r\n";
?>

index1.php - 源码说明

本页面展示了「极限网络智能办公系统 - Office Automation 2008 官方100％ 源码」中的 index1.php 源码文件，采用 PHP 编程语言编写，共 337 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

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

⌨️ 快捷键说明

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