📄 待办事宜.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?php
 

echo "<!-------------------- 待办事宜 ----------------------->\n";
$USER_FUNC_ID_STR = $LOGIN_FUNC_STR;
echo "<s";
echo "cript>\nfunction open_meeting(M_ID)\n{\n   URL=\"/general/meeting/query/meeting_detail.php?M_ID=\"+M_ID;\n   myleft=(screen.availWidth-600)/2;\n   mytop=100\n   mywidth=600;\n   myheight=500;\n   window.open(URL,\"read_meeting\",\"height=\"+myheight+\",width=\"+mywidth+\",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+mytop+\",left=\"+myleft+\",resizable=yes\");\n}\n\n</script>\n<div id=\"module_";
echo $MODULE_ID;
echo "\" class=\"module listColor\">\n  <div class=\"head\">\n  <h4 id=\"module_";
echo $MODULE_ID;
echo "_head\" class=\"moduleHeader\">\n    ";
echo "<s";
echo "pan id=\"module_";
echo $MODULE_ID;
echo "_title\" class=\"title\" style=\"cursor:move;\"> 待办事宜</span>\n    ";
echo "<s";
echo "pan id=\"module_";
echo $MODULE_ID;
echo "_op\" class=\"close\">&nbsp;&nbsp;&nbsp;<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>\n  </h4>\n  </div>\n  <div id=\"module_";
echo $MODULE_ID;
echo "_body\" class=\"module_body\">\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;\">\n    <ul>\n";
$FLOW_COUNT = 0;
$MAX_COUNT = intval( $_COOKIE[my_nums_1] );
if ( $MAX_COUNT <= 0 || 1000 <= $MAX_COUNT )
{
	$MAX_COUNT = 10;
}
$CUR_DATE = date( "Y-m-d", time( ) );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
if ( find_id( $USER_FUNC_ID_STR, "7" ) )
{
	if ( $MAX_COUNT < $FLOW_COUNT )
	{
		break;
	}
	$query1 = "select DUTY_TYPE from USER where USER_ID='{$LOGIN_USER_ID}'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$DUTY_TYPE = $ROW['DUTY_TYPE'];
	}
	$query = "SELECT * from ATTEND_CONFIG where DUTY_TYPE={$DUTY_TYPE}";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$DUTY_TIME1 = $ROW['DUTY_TIME1'];
		$DUTY_TIME2 = $ROW['DUTY_TIME2'];
		$DUTY_TIME3 = $ROW['DUTY_TIME3'];
		$DUTY_TIME4 = $ROW['DUTY_TIME4'];
		$DUTY_TIME5 = $ROW['DUTY_TIME5'];
		$DUTY_TIME6 = $ROW['DUTY_TIME6'];
		$DUTY_TYPE1 = $ROW['DUTY_TYPE1'];
		$DUTY_TYPE2 = $ROW['DUTY_TYPE2'];
		$DUTY_TYPE3 = $ROW['DUTY_TYPE3'];
		$DUTY_TYPE4 = $ROW['DUTY_TYPE4'];
		$DUTY_TYPE5 = $ROW['DUTY_TYPE5'];
		$DUTY_TYPE6 = $ROW['DUTY_TYPE6'];
	}
	$query = "SELECT * from SYS_PARA where PARA_NAME='DUTY_INTERVAL_BEFORE1'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$DUTY_INTERVAL_BEFORE1 = $ROW['PARA_VALUE'];
	}
	$query = "SELECT * from SYS_PARA where PARA_NAME='DUTY_INTERVAL_AFTER1'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$DUTY_INTERVAL_AFTER1 = $ROW['PARA_VALUE'];
	}
	$query = "SELECT * from SYS_PARA where PARA_NAME='DUTY_INTERVAL_BEFORE2'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$DUTY_INTERVAL_BEFORE2 = $ROW['PARA_VALUE'];
	}
	$query = "SELECT * from SYS_PARA where PARA_NAME='DUTY_INTERVAL_AFTER2'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$DUTY_INTERVAL_AFTER2 = $ROW['PARA_VALUE'];
	}
	$REGISTER_TIME1 = $CUR_DATE." ".$DUTY_TIME1;
	$REGISTER_TIME2 = $CUR_DATE." ".$DUTY_TIME2;
	$REGISTER_TIME3 = $CUR_DATE." ".$DUTY_TIME3;
	$REGISTER_TIME4 = $CUR_DATE." ".$DUTY_TIME4;
	$REGISTER_TIME5 = $CUR_DATE." ".$DUTY_TIME5;
	$REGISTER_TIME6 = $CUR_DATE." ".$DUTY_TIME6;
	$DUTY_INTERVAL_BEFORE11 = "DUTY_INTERVAL_BEFORE".$DUTY_TYPE1;
	$DUTY_INTERVAL_AFTER11 = "DUTY_INTERVAL_AFTER".$DUTY_TYPE1;
	$DUTY_INTERVAL_BEFORE22 = "DUTY_INTERVAL_BEFORE".$DUTY_TYPE2;
	$DUTY_INTERVAL_AFTER22 = "DUTY_INTERVAL_AFTER".$DUTY_TYPE2;
	$DUTY_INTERVAL_BEFORE33 = "DUTY_INTERVAL_BEFORE".$DUTY_TYPE3;
	$DUTY_INTERVAL_AFTER33 = "DUTY_INTERVAL_AFTER".$DUTY_TYPE3;
	$DUTY_INTERVAL_BEFORE44 = "DUTY_INTERVAL_BEFORE".$DUTY_TYPE4;
	$DUTY_INTERVAL_AFTER44 = "DUTY_INTERVAL_AFTER".$DUTY_TYPE4;
	$DUTY_INTERVAL_BEFORE55 = "DUTY_INTERVAL_BEFORE".$DUTY_TYPE5;
	$DUTY_INTERVAL_AFTER55 = "DUTY_INTERVAL_AFTER".$DUTY_TYPE5;
	$DUTY_INTERVAL_BEFORE66 = "DUTY_INTERVAL_BEFORE".$DUTY_TYPE6;
	$DUTY_INTERVAL_AFTER66 = "DUTY_INTERVAL_AFTER".$DUTY_TYPE6;
	$BEFORE_UNIX_TIME1 = strtotime( $REGISTER_TIME1 ) - $$DUTY_INTERVAL_BEFORE11 * 60;
	$AFTER_UNIX_TIME1 = strtotime( $REGISTER_TIME1 ) + $$DUTY_INTERVAL_AFTER11 * 60;
	$BEFORE_UNIX_TIME2 = strtotime( $REGISTER_TIME2 ) - $$DUTY_INTERVAL_BEFORE22 * 60;
	$AFTER_UNIX_TIME2 = strtotime( $REGISTER_TIME2 ) + $$DUTY_INTERVAL_AFTER22 * 60;
	$BEFORE_UNIX_TIME3 = strtotime( $REGISTER_TIME3 ) - $$DUTY_INTERVAL_BEFORE33 * 60;
	$AFTER_UNIX_TIME3 = strtotime( $REGISTER_TIME3 ) + $$DUTY_INTERVAL_AFTER33 * 60;
	$BEFORE_UNIX_TIME4 = strtotime( $REGISTER_TIME4 ) - $$DUTY_INTERVAL_BEFORE44 * 60;
	$AFTER_UNIX_TIME4 = strtotime( $REGISTER_TIME4 ) + $$DUTY_INTERVAL_AFTER44 * 60;
	$BEFORE_UNIX_TIME5 = strtotime( $REGISTER_TIME5 ) - $$DUTY_INTERVAL_BEFORE55 * 60;
	$AFTER_UNIX_TIME5 = strtotime( $REGISTER_TIME5 ) + $$DUTY_INTERVAL_AFTER55 * 60;
	$BEFORE_UNIX_TIME6 = strtotime( $REGISTER_TIME6 ) - $$DUTY_INTERVAL_BEFORE66 * 60;
	$AFTER_UNIX_TIME6 = strtotime( $REGISTER_TIME6 ) + $$DUTY_INTERVAL_AFTER66 * 60;
	$WHERE_STR = "";
	if ( $DUTY_TIME1 != "" && $BEFORE_UNIX_TIME1 < strtotime( $CUR_TIME ) && strtotime( $CUR_TIME ) < $AFTER_UNIX_TIME1 )
	{
		$WHERE_STR .= " and  (UNIX_TIMESTAMP(REGISTER_TIME) >{$BEFORE_UNIX_TIME1} and UNIX_TIMESTAMP(REGISTER_TIME) < {$AFTER_UNIX_TIME1})";
	}
	if ( $DUTY_TIME2 != "" && $BEFORE_UNIX_TIME2 < strtotime( $CUR_TIME ) && strtotime( $CUR_TIME ) < $AFTER_UNIX_TIME2 )
	{
		$WHERE_STR .= " and  (UNIX_TIMESTAMP(REGISTER_TIME) >{$BEFORE_UNIX_TIME2} and UNIX_TIMESTAMP(REGISTER_TIME) < {$AFTER_UNIX_TIME2})";
	}
	if ( $DUTY_TIME3 != "" && $BEFORE_UNIX_TIME3 < strtotime( $CUR_TIME ) && strtotime( $CUR_TIME ) < $AFTER_UNIX_TIME3 )
	{
		$WHERE_STR .= " and  (UNIX_TIMESTAMP(REGISTER_TIME) >{$BEFORE_UNIX_TIME3} and UNIX_TIMESTAMP(REGISTER_TIME) < {$AFTER_UNIX_TIME3})";
	}
	if ( $DUTY_TIME4 != "" && $BEFORE_UNIX_TIME4 < strtotime( $CUR_TIME ) && strtotime( $CUR_TIME ) < $AFTER_UNIX_TIME4 )
	{
		$WHERE_STR .= " and  (UNIX_TIMESTAMP(REGISTER_TIME) >{$BEFORE_UNIX_TIME4} and UNIX_TIMESTAMP(REGISTER_TIME) < {$AFTER_UNIX_TIME4})";
	}
	if ( $DUTY_TIME5 != "" && $BEFORE_UNIX_TIME5 < strtotime( $CUR_TIME ) && strtotime( $CUR_TIME ) < $AFTER_UNIX_TIME5 )
	{
		$WHERE_STR .= " and  (UNIX_TIMESTAMP(REGISTER_TIME) >{$BEFORE_UNIX_TIME5} and UNIX_TIMESTAMP(REGISTER_TIME) < {$AFTER_UNIX_TIME5})";
	}
	if ( $DUTY_TIME6 != "" && $BEFORE_UNIX_TIME6 < strtotime( $CUR_TIME ) && strtotime( $CUR_TIME ) < $AFTER_UNIX_TIME6 )
	{
		$WHERE_STR .= " and  (UNIX_TIMESTAMP(REGISTER_TIME) >{$BEFORE_UNIX_TIME6} and UNIX_TIMESTAMP(REGISTER_TIME) < {$AFTER_UNIX_TIME6}))";
	}
	$query = "SELECT PARA_VALUE from SYS_PARA where PARA_NAME='NO_DUTY_USER'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$PARA_VALUE = $ROW['PARA_VALUE'];
		if ( !find_id( $PARA_VALUE, $LOGIN_USER_ID ) && trim( $WHERE_STR ) != "" )
		{
			$query = "SELECT * from ATTEND_DUTY where USER_ID='{$LOGIN_USER_ID}'".$WHERE_STR;
			$cursor = exequery( $connection, $query );
			if ( !( $ROW = mysql_fetch_array( $cursor ) ) )
			{
				++$FLOW_COUNT;
				echo "<li>个人考勤：<a href=\"/general/attendance/personal\">上下班登记</a></li>\n";
			}
		}
	}
}
if ( find_id( $USER_FUNC_ID_STR, "7" ) )
{
	$query = "SELECT * from ATTEND_EVECTION where STATUS='1' and ALLOW='0' and LEADER_ID='{$LOGIN_USER_ID}' order by EVECTION_DATE1 limit 0,{$MAX_COUNT}";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		if ( $MAX_COUNT < $FLOW_COUNT )
		{
			break;
		}
		$EVECTION_ID = $ROW['EVECTION_ID'];
		$EVECTION_DATE1 = $ROW['EVECTION_DATE1'];
		$EVECTION_DATE2 = $ROW['EVECTION_DATE2'];
		$EVECTION_DEST = $ROW['EVECTION_DEST'];
		$EVECTION_DATE1 = strtok( $EVECTION_DATE1, " " );
		$EVECTION_DATE2 = strtok( $EVECTION_DATE2, " " );
		$EVECTION_DEST = htmlspecialchars( $EVECTION_DEST );
		echo "\n<li>出差审批：<a href=\"/general/attendance/manage/confirm/\">";
		echo $EVECTION_DEST;
		echo "</a> (";
		echo $EVECTION_DATE1;
		echo " 至 ";
		echo $EVECTION_DATE2;
		echo ")</li>\n\n";
	}
	$query = "SELECT * from ATTEND_EVECTION where STATUS='1' and ALLOW='1' and USER_ID='{$LOGIN_USER_ID}' order by EVECTION_DATE1 limit 0,{$MAX_COUNT}";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		if ( $MAX_COUNT < $FLOW_COUNT )
		{
		}
		echo "\n<li>个人考勤：<a href=\"/general/attendance/personal/evection/\">出差归来</a></li>\n\n";
	}
}
if ( find_id( $USER_FUNC_ID_STR, "7" ) )
{
	$query = "SELECT * from ATTEND_OUT where STATUS='0' and ALLOW='1' and USER_ID='{$LOGIN_USER_ID}' order by SUBMIT_TIME limit 0,{$MAX_COUNT}";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		if ( $MAX_COUNT < $FLOW_COUNT )
		{
		}
		$SUBMIT_TIME = $ROW['SUBMIT_TIME'];
		$OUT_TIME1 = $ROW['OUT_TIME1'];
		$OUT_TIME2 = $ROW['OUT_TIME2'];
		$OUT_TYPE = $ROW['OUT_TYPE'];
		$SUBMIT_TIME = strtok( $SUBMIT_TIME, " " );
		$OUT_TYPE = htmlspecialchars( $OUT_TYPE );
		echo "\n<li>个人考勤：<a href=\"/general/attendance/personal/out/\">外出归来</a></li>\n\n";
	}
}
if ( find_id( $USER_FUNC_ID_STR, "26" ) )
{
	$query = "SELECT USER_NAME from ATTEND_OUT,USER where ATTEND_OUT.USER_ID=USER.USER_ID and LEADER_ID='{$LOGIN_USER_ID}' and to_days(SUBMIT_TIME)=to_days('{$CUR_DATE}') and ALLOW='0' limit 0,{$MAX_COUNT}";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		if ( $MAX_COUNT < $FLOW_COUNT )
		{
			break;
		}
		$USER_NAME = $ROW['USER_NAME'];
		echo "\n<li>考勤管理：<a href=\"/general/attendance/manage\">批示";
		echo $USER_NAME;
		echo "的外出申请</a></li>\n\n";
	}
	$query = "SELECT USER_NAME,ALLOW from ATTEND_LEAVE,USER where ATTEND_LEAVE.USER_ID=USER.USER_ID and LEADER_ID='{$LOGIN_USER_ID}' and status='1' and allow in('0','3') limit 0,{$MAX_COUNT}";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		if ( $MAX_COUNT < $FLOW_COUNT )
		{
			break;
		}
		$USER_NAME = $ROW['USER_NAME'];
		$ALLOW = $ROW['ALLOW'];
		if ( $ALLOW == "0" )
		{
			$ALLOW = "批示".$USER_NAME."的请假申请";
		}
12 下一页
⌨️ 快捷键说明

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