待办事宜.php

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

		else
		{
			$ALLOW = "批示".$USER_NAME."的销假申请";
		}
		echo "\n<li>考勤管理：<a href=\"/general/attendance/manage\">";
		echo $ALLOW;
		echo "</a></li>\n\n";
	}
	$query = "SELECT * from ATTEND_LEAVE where USER_ID='{$LOGIN_USER_ID}' and status='1' and ALLOW='1' 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/leave/\">申请销假</a></li>\n\n";
	}
}
if ( find_id( $USER_FUNC_ID_STR, "88" ) )
{
	$query = "SELECT M_NAME from MEETING where M_STATUS='0' and  M_MANAGER='{$LOGIN_USER_ID}' order by M_START desc limit 0,{$MAX_COUNT}";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		if ( $MAX_COUNT < $FLOW_COUNT )
		{
		}
		$M_NAME = $ROW['M_NAME'];
		echo "<li>待批会议：<a href=\"/general/meeting/manage/\">".$M_NAME."</a></li>";
	}
}
if ( find_id( $USER_FUNC_ID_STR, "152" ) )
{
	$query = "SELECT VU_USER from VEHICLE_USAGE where DEPT_MANAGER='{$LOGIN_USER_ID}' and DMER_STATUS='0' order by VU_START desc limit 0,{$MAX_COUNT}";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		if ( $MAX_COUNT < $FLOW_COUNT )
		{
		}
		$VU_USER = $ROW['VU_USER'];
		echo "<li>待批车辆：<a href=\"/general/vehicle/dept_manage/\">".$VU_USER."用车</a></li>";
	}
}
if ( find_id( $USER_FUNC_ID_STR, "93" ) )
{
	$query = "SELECT VU_USER from VEHICLE_USAGE where VU_OPERATOR='{$LOGIN_USER_ID}' and VU_STATUS='0' and SHOW_FLAG='1' order by VU_START desc limit 0,{$MAX_COUNT}";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		if ( $MAX_COUNT < $FLOW_COUNT )
		{
		}
		$VU_USER = $ROW['VU_USER'];
		echo "<li>待批车辆：<a href=\"/general/vehicle/checkup/\">".$VU_USER."用车</a></li>";
	}
}
if ( find_id( $USER_FUNC_ID_STR, "28" ) )
{
	$query = "SELECT FLOW_ID,CONTENT from SAL_FLOW where to_days(BEGIN_DATE)<=to_days('{$CUR_DATE}') and to_days(END_DATE)>=to_days('{$CUR_DATE}') order by BEGIN_DATE desc limit 0,{$MAX_COUNT}";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		if ( $MAX_COUNT < $FLOW_COUNT )
		{
		}
		$FLOW_ID = $ROW['FLOW_ID'];
		$CONTENT = $ROW['CONTENT'];
		echo "\n<li>工资上报：<a href=\"/general/salary/submit/\">";
		echo $CONTENT;
		echo "</a></li>\n\n";
	}
}
if ( find_id( $USER_FUNC_ID_STR, "87" ) )
{
	$query = "SELECT MEETING.* from MEETING left join MEETING_ATTENDEE_NOT on MEETING_ATTENDEE_NOT.M_ID=MEETING.M_ID and MEETING_ATTENDEE_NOT.USER_ID='{$LOGIN_USER_ID}' where MEETING_ATTENDEE_NOT.M_ID is NULL and (M_STATUS='1' or M_STATUS='2') and find_in_set('{$LOGIN_USER_ID}',M_ATTENDEE) order by M_START limit 0,{$MAX_COUNT}";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		if ( $MAX_COUNT < $FLOW_COUNT )
		{
		}
		$M_ID = $ROW['M_ID'];
		$M_NAME = $ROW['M_NAME'];
		$M_START = $ROW['M_START'];
		$M_END = $ROW['M_END'];
		$TEM_M_START = substr( $M_START, 5, 11 );
		$TEM_M_END = substr( $M_END, 5, 11 );
		$M_NAME = htmlspecialchars( $M_NAME );
		echo "<li>会议：<a href=\"javascript:open_meeting('";
		echo $M_ID;
		echo "');\">";
		echo $M_NAME;
		echo "</a>&nbsp;(";
		echo $TEM_M_START;
		echo " - ";
		echo $TEM_M_END;
		echo ") <a href=\"/general/meeting/query/attendee.php?M_ID=";
		echo $M_ID;
		echo "&MA_FLAG=1&OP=1\">参加</a> <a href=\"/general/meeting/query/reason.php?M_ID=";
		echo $M_ID;
		echo "&MA_FLAG=2\">不参加</a></li>\n\t";
	}
}
if ( find_id( $USER_FUNC_ID_STR, "24" ) )
{
	$query = "select * from SYS_PARA where PARA_NAME='NOTIFY_MANAGER'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$NOTIFY_MANAGER = $ROW['PARA_VALUE'];
	}
	$query = "select * from SYS_PARA where PARA_NAME='NOTIFY_CONFIRM'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$NOTIFY_CONFIRM = $ROW['PARA_VALUE'];
	}
	if ( $NOTIFY_CONFIRM == 1 && find_id( $NOTIFY_MANAGER, $LOGIN_USER_ID ) )
	{
		$query = "SELECT NOTIFY_ID,SUBJECT,READERS,FORMAT,TOP,TYPE_ID,BEGIN_DATE from NOTIFY where PUBLISH='0' order by TOP desc,BEGIN_DATE desc,SEND_TIME desc limit 0,{$MAX_COUNT}";
		$cursor = exequery( $connection, $query );
		while ( $ROW = mysql_fetch_array( $cursor ) )
		{
			++$FLOW_COUNT;
			if ( $MAX_COUNT < $FLOW_COUNT )
			{
			}
			$NOTIFY_ID = $ROW['NOTIFY_ID'];
			$SUBJECT = $ROW['SUBJECT'];
			$READERS = $ROW['READERS'];
			$FORMAT = $ROW['FORMAT'];
			$TOP = $ROW['TOP'];
			$TYPE_ID = $ROW['TYPE_ID'];
			$SUBJECT = htmlspecialchars( $SUBJECT );
			$BEGIN_DATE = $ROW['BEGIN_DATE'];
			$BEGIN_DATE = strtok( $BEGIN_DATE, " " );
			$TYPE_NAME = get_code_name( $TYPE_ID, "NOTIFY" );
			if ( $TYPE_NAME != "" )
			{
				$SUBJECT = "【".$TYPE_NAME."】".$SUBJECT;
			}
			if ( $TOP == "1" )
			{
				$SUBJECT = "<font color=red><b>".$SUBJECT."</b></font>";
			}
			echo "<li>公告通知：<a href=\"/general/notify/manage/modify.php?NOTIFY_ID=";
			echo $NOTIFY_ID;
			echo "\">";
			echo $SUBJECT;
			echo "</a>&nbsp;(";
			echo $BEGIN_DATE;
			echo ")</li>\n\t\t";
		}
	}
}
if ( find_id( $USER_FUNC_ID_STR, "4" ) )
{
	$query = "SELECT count(NOTIFY_ID) from NOTIFY where (TO_ID='ALL_DEPT' or find_in_set('{$LOGIN_DEPT_ID}',TO_ID) or find_in_set('{$LOGIN_USER_PRIV}',PRIV_ID) or find_in_set('{$LOGIN_USER_ID}',USER_ID)) and begin_date<='{$CUR_DATE}' and (end_date>='{$CUR_DATE}' or end_date is null) and PUBLISH='1' and !find_in_set('{$LOGIN_USER_ID}',READERS)";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$NOTIFY_COUNT = $ROW[0];
		if ( 0 < $NOTIFY_COUNT )
		{
			echo "<li>公告提示：<a href=\"/general/notify/show\" title=点击查看公告>共有";
			echo $NOTIFY_COUNT;
			echo "条未读公告</a></li>\n\t\t";
		}
	}
}
if ( find_id( $USER_FUNC_ID_STR, "1" ) )
{
	$query = "SELECT count(EMAIL_ID) from EMAIL where TO_ID='{$LOGIN_USER_ID}' and READ_FLAG='0' and DELETE_FLAG='0'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$EMAIL_COUNT = $ROW[0];
		if ( 0 < $EMAIL_COUNT )
		{
			echo "<li>邮件提示：<a href=\"/general/email/inbox/?BOX_ID=0\" title=点击查看邮件>共有";
			echo $EMAIL_COUNT;
			echo "条未读邮件</a></li>\n\t\t";
		}
	}
}
$query = "SELECT FLOW_RUN_PRCS.PRCS_ID,FLOW_RUN.RUN_ID,FLOW_RUN.FLOW_ID,PRCS_FLAG,FLOW_PRCS,FLOW_NAME,RUN_NAME from FLOW_RUN_PRCS,FLOW_RUN,FLOW_TYPE WHERE FLOW_RUN_PRCS.RUN_ID=FLOW_RUN.RUN_ID and FLOW_RUN.FLOW_ID=FLOW_TYPE.FLOW_ID and USER_ID='{$LOGIN_USER_ID}' and prcs_flag<>'4' and DELETE_FLAG='0' order by FLOW_RUN_PRCS.PRCS_FLAG,PRCS_TIME desc limit 0,{$MAX_COUNT}";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$FLOW_COUNT;
	if ( $MAX_COUNT < $FLOW_COUNT )
	{
		break;
	}
	$PRCS_ID = $ROW['PRCS_ID'];
	$RUN_ID = $ROW['RUN_ID'];
	$FLOW_ID = $ROW['FLOW_ID'];
	$PRCS_FLAG = $ROW['PRCS_FLAG'];
	$FLOW_PRCS = $ROW['FLOW_PRCS'];
	$FLOW_NAME = $ROW['FLOW_NAME'];
	$RUN_NAME = $ROW['RUN_NAME'];
	if ( $PRCS_FLAG == "1" )
	{
		$STATUS = "<img src='/images/email_close.gif' alt='未接收' align='absmiddle'>";
	}
	else if ( $PRCS_FLAG == "2" )
	{
		$STATUS = "<img src='/images/email_open.gif' alt='已接收' align='absmiddle'>";
	}
	else
	{
		$STATUS = "<img src='/images/flow_next.gif' alt='已办结' align='absmiddle'>";
	}
	echo "<li>工作流：";
	echo $STATUS;
	if ( $PRCS_FLAG != "3" )
	{
		echo "     <a href=\"/general/workflow/list/input_form?RUN_ID=";
		echo $RUN_ID;
		echo "&FLOW_ID=";
		echo $FLOW_ID;
		echo "&PRCS_ID=";
		echo $PRCS_ID;
		echo "&FLOW_PRCS=";
		echo $FLOW_PRCS;
		echo "\">";
		echo $FLOW_NAME;
		echo " - ";
		echo $RUN_NAME;
		echo "</a></li>\n";
	}
	else
	{
		echo "     <a href=\"/general/workflow/list/\">";
		echo $FLOW_NAME;
		echo " - ";
		echo $RUN_NAME;
		echo "</a></li>\n";
	}
}
if ( $FLOW_COUNT == 0 )
{
	echo "<li>无待办事宜</li>";
}
if ( $MAX_COUNT < $FLOW_COUNT )
{
	$FLOW_COUNT = $MAX_COUNT;
}
echo "<ul>\n\t</div>\n  </div>\n</div>\n";
?>