今日计划.php

极限网络智能办公系统 - Office Automation 2008 官方100％ 源码

<?php
 

echo "<!-------------------- 工作计划 ----------------------->\r\n<script>\r\nfunction plan_detail(PLAN_ID)\r\n{\r\n URL=\"/general/work_plan/show/plan_detail.php?PLAN_ID=\"+PLAN_ID;\r\n myleft=(screen.availWidth-500)/2;\r\n window.open(URL,\"read_work_plan\",\"height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=120,left=\"+myleft+\",resizable=yes\");\r\n}\r\n</script>\r\n<div id=\"module_";
echo $MODULE_ID;
echo "\" class=\"module listColor\">\r\n\t  <div class=\"head\">\r\n  <h4 id=\"module_";
echo $MODULE_ID;
echo "_head\" class=\"moduleHeader\">\r\n    <span id=\"module_";
echo $MODULE_ID;
echo "_title\" class=\"title\" style=\"cursor:move;\"> 今日计划</span>\r\n    <span id=\"module_";
echo $MODULE_ID;
echo "_op\" class=\"close\">\r\n      <a href=\"javascript:_show('";
echo $MODULE_ID;
echo "');\" alt=\"设置显示条数\"><img border=\"0\" src=\"/images/edit.gif\" alt=\"设置显示条数\"></a>&nbsp;\r\n    \t<a href=\"/general/work_plan/show\">全部</a>&nbsp;\r\n    \t<a href=\"javascript:_edit();\">设置</a>&nbsp;";
if ( $VIEW_TYPE != "2" )
{
	echo "<a href=\"javascript:_del(";
	echo $MODULE_ID;
	echo ");\"><img src=\"/images/close.png\" /></a>";
}
echo "</span>\r\n  </h4>\r\n  </div>\r\n  <div id=\"module_";
echo $MODULE_ID;
echo "_edit\" style=\"font-size: 9pt;display:none;\">\r\n      <div id=\"module_";
echo $MODULE_ID;
echo "_info\" style=\"float:left;\"></div>\r\n     <input type=\"checkbox\" id=\"MODULE_SCROLL_";
echo $MODULE_ID;
echo "\" ";
if ( $_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_scroll"] == "true" )
{
	echo " checked";
}
echo "><label for=\"MODULE_SCROLL_";
echo $MODULE_ID;
echo "\">上下滚动显示</label>&nbsp;\r\n     显示条数：<input type=\"input\" size=\"3\" class=\"SmallInput\" value=\"";
echo $_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_nums"];
echo "\" name=\"MODULE_NUM_";
echo $MODULE_ID;
echo "\">&nbsp;\r\n     <a href=\"javascript:SetNumsMo('";
echo $MODULE_ID;
echo "');\" title=\"保存设置\">设置</a>\r\n     <a href=\"javascript:_show('";
echo $MODULE_ID;
echo "');\" title=\"关闭\">关闭</a>\r\n  </div>\r\n  <div id=\"module_";
echo $MODULE_ID;
echo "_body\" class=\"module_body\">\r\n    <div id=\"module_";
echo $MODULE_ID;
echo "_ul\" class=\"module_div\" style=\"height:";
if ( !isset( $_COOKIE[my_nums_1] ) )
{
	echo "100";
}
else
{
	echo intval( $_COOKIE[my_nums_1] ) * 20;
}
echo "px;\">\r\n";
if ( $_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_scroll"] == "true" )
{
	echo "<marquee height=\"";
	if ( !isset( $_COOKIE[my_nums_1] ) )
	{
		echo "100";
	}
	else
	{
		echo intval( $_COOKIE[my_nums_1] ) * 20;
	}
	echo "px\" direction=\"up\" behavior=scroll scrollamount=2 scrolldelay=100 onmouseover='this.stop()' onmouseout='this.start()' border=0>\r\n";
}
echo "    <ul>\r\n";
$MAX_COUNT = intval( $_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_nums"] );
if ( $MAX_COUNT <= 0 || 1000 <= $MAX_COUNT )
{
	$MAX_COUNT = 10;
}
$RANGE_STR = "(TO_ID='ALL_DEPT' or find_in_set('".$LOGIN_DEPT_ID."',TO_ID) or find_in_set('{$LOGIN_USER_ID}',TO_PERSON_ID) or find_in_set('{$LOGIN_USER_ID}',MANAGER) or find_in_set('{$LOGIN_USER_ID}',PARTICIPATOR))";
$CUR_DATE = date( "Y-m-d", time( ) );
$DATE_STR = "BEGIN_DATE<='".$CUR_DATE."' and (END_DATE>='{$CUR_DATE}' or END_DATE='0000-00-00') ";
$query = "SELECT count(*) from WORK_PLAN where (".$RANGE_STR.") and ".$DATE_STR;
$cursor = exequery( $connection, $query );
$WORK_PLAN_COUNT = 0;
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$WORK_PLAN_COUNT = $ROW[0];
}
if ( $WORK_PLAN_COUNT == 0 )
{
	echo "<li>暂无工作计划</li>";
}
else
{
	$PLAN_COUNT = 0;
	$query = "SELECT * from WORK_PLAN where (".$RANGE_STR.") and ".$DATE_STR.( " order by TYPE desc LIMIT 0,".$MAX_COUNT );
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$PLAN_ID = $ROW['PLAN_ID'];
		$NAME = $ROW['NAME'];
		$BEGIN_DATE = $ROW['BEGIN_DATE'];
		$END_DATE = $ROW['END_DATE'];
		$TYPE = $ROW['TYPE'];
		$SUSPEND_FLAG = $ROW['SUSPEND_FLAG'];
		$CREATOR = $ROW['CREATOR'];
		$query = "SELECT * from USER left join DEPARTMENT on DEPARTMENT.DEPT_ID=USER.DEPT_ID where USER_ID='".$CREATOR."'";
		$cursor1 = exequery( $connection, $query );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$USER_NAME = $ROW1['USER_NAME'];
			$DEPT_NAME = $ROW1['DEPT_NAME'];
		}
		$query = "SELECT * from PLAN_TYPE where TYPE_ID='".$TYPE."'";
		$cursor1 = exequery( $connection, $query );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$TYPE_DESC = $ROW1['TYPE_NAME'];
		}
		else
		{
			$TYPE_DESC = "";
		}
		if ( $SUSPEND_FLAG == 1 )
		{
			++$PLAN_COUNT;
			if ( $END_DATE == "0000-00-00" )
			{
				$END_DATE = "";
			}
			echo "<li>";
			echo $TYPE_DESC;
			echo "：<a href=\"javascript:plan_detail('";
			echo $PLAN_ID;
			echo "');\">";
			echo $NAME;
			echo "</a> [";
			echo $USER_NAME;
			echo "(";
			echo $DEPT_NAME;
			echo ")](";
			echo $BEGIN_DATE;
			echo " - ";
			echo $END_DATE;
			echo ")</li>    \r\n";
		}
	}
}
if ( $PLAN_COUNT == 0 && $WORK_PLAN_COUNT != 0 )
{
	echo "<li>暂无工作计划</li>";
}
echo "    <ul>\r\n";
if ( $_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_scroll"] == "true" )
{
	echo "</marquee>\r\n";
}
echo "\t</div>\r\n    <div id=\"module_";
echo $MODULE_ID;
echo "_page\" class=\"module_page\">\r\n      <a href=\"javascript:NextPage('";
echo $MODULE_ID;
echo "',-1);\" id=\"module_";
echo $MODULE_ID;
echo "_link_pre\" class=\"PageLinkDisable\"><上一页</a>\r\n      <a href=\"javascript:NextPage('";
echo $MODULE_ID;
echo "',1);\"  id=\"module_";
echo $MODULE_ID;
echo "_link_next\">下一页></a>\r\n    </div>\r\n  </div>\r\n</div>\r\n";
?>