3.php

极限网络智能办公系统—MYOA26—100％—源程序。

<?php

echo "<!-------------------- 待办事宜 ----------------------->\r\n\r\n";
$query = "SELECT * from USER_PRIV where USER_PRIV='{$LOGIN_USER_PRIV}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_FUNC_ID_STR = $ROW['FUNC_ID_STR'];
}
echo "\r\n <tr class=\"TableData\">\r\n    <td colspan=2 height=\"50\">\r\n";
$FLOW_COUNT = 0;
if ( find_id( $USER_FUNC_ID_STR, "7" ) )
{
	++$FLOW_COUNT;
	echo "\r\n个人考勤：<a href=\"/general/attendance/personal\">上下班登记</a><br>\r\n\r\n";
}
if ( find_id( $USER_FUNC_ID_STR, "28" ) )
{
	$query = "SELECT * 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";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		$FLOW_ID = $ROW['FLOW_ID'];
		$CONTENT = $ROW['CONTENT'];
		echo "\r\n工资上报：<a href=\"/general/salary/submit/sal_index.php?FLOW_ID=";
		echo $FLOW_ID;
		echo "\">";
		echo $CONTENT;
		echo "</a><br>\r\n\r\n";
	}
}
if ( find_id( $USER_FUNC_ID_STR, "26" ) )
{
	$query = "SELECT * 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'";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		$USER_NAME = $ROW['USER_NAME'];
		echo "\r\n考勤管理：<a href=\"/general/attendance/manage\">批示";
		echo $USER_NAME;
		echo "的外出申请</a><br>\r\n\r\n";
	}
	$query = "SELECT * 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')";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		++$FLOW_COUNT;
		$USER_NAME = $ROW['USER_NAME'];
		$ALLOW = $ROW['ALLOW'];
		if ( $ALLOW == "0" )
		{
			$ALLOW = "批示".$USER_NAME."的请假申请";
		}
		else
		{
			$ALLOW = "批示".$USER_NAME."的销假申请";
		}
		echo "\r\n考勤管理：<a href=\"/general/attendance/manage\">";
		echo $ALLOW;
		echo "</a><br>\r\n\r\n";
	}
}
$query = "SELECT * from FLOW_RUN_PRCS WHERE USER_ID='{$LOGIN_USER_ID}' and prcs_flag<>'4'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$FLOW_COUNT;
	$RUN_ID = $ROW['RUN_ID'];
	$PRCS_FLAG = $ROW['PRCS_FLAG'];
	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'>";
	}
	$query = "SELECT * from FLOW_RUN WHERE RUN_ID={$RUN_ID}";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$FLOW_ID = $ROW['FLOW_ID'];
		$RUN_NAME = $ROW['RUN_NAME'];
	}
	$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID={$FLOW_ID}";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$FLOW_NAME = $ROW['FLOW_NAME'];
	}
	echo "\r\n工作流：";
	echo $STATUS;
	echo " <a href=\"/general/workflow\">";
	echo $FLOW_NAME;
	echo " - ";
	echo $RUN_NAME;
	echo "</a><br>\r\n\r\n";
}
if ( $FLOW_COUNT == 0 )
{
	echo "无待办事宜";
}
echo " <br>\r\n </td>\r\n</tr>\r\n<thead class=\"TableControl\">\r\n <td class=\"TableHeader\" width=\"70%\"><img src=\"/images/menu/erp.gif\" WIDTH=\"18\" HEIGHT=\"16\" align=\"absmiddle\"> 待办事宜</td>\r\n <td align=\"center\">共 ";
echo "<s";
echo "pan class=\"big4\" id=\"FLOW_COUNT\">";
echo $FLOW_COUNT;
echo "</span>&nbsp;项</td>\r\n</thead>\r\n";
?>