workflow.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

include_once( "inc/auth.php" );
echo "<table border=\"0\" width=\"100%\" cellspacing=\"1\"  cellpadding=\"0\">\r\n   <tr class=\"tablehead1\">\r\n    <td ><img src=\"/images/notify_new.gif\"  align=\"absmiddle\">日程安排\r\n    </td>\r\n  </tr>\r\n <table>\r\n <br>\r\n\r\n<table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"250\">\r\n  <tr>\r\n    <td width=\"10\" ></td>\r\n    <td width=\"100%\" valign=\"bottom\">\r\n\t<table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpad";
echo "ding=\"0\"  height=\"230\">\r\n      <tr>\r\n        <td valign=\"top\">\r\n\t    <table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n          <tr>\r\n            <td colspan=\"2\" height=\"5\"></td>\r\n          </tr>\r\n\t\t<!-------------------- 待办事宜 ----------------------->\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";
$FLOW_COUNT = 0;
if ( find_id( $USER_FUNC_ID_STR, "7" ) )
{
	++$FLOW_COUNT;
	if ( $FLOW_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "<tr class=\"";
	echo $TableLine;
	echo "\" height=\"25\">\r\n            <td width=\"2%\">&nbsp;</td>\r\n            <td width=\"90%\">\r\n个人考勤：<a href=\"/general/attendance/personal\">上下班登记</a>\r\n</td>\r\n</tr>\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'];
		if ( $FLOW_COUNT % 2 != 1 )
		{
			$TableLine = "TableLine1";
		}
		else
		{
			$TableLine = "TableLine2";
		}
		echo "<tr class=\"";
		echo $TableLine;
		echo "\" height=\"25\">\r\n            <td width=\"2%\">&nbsp;</td>\r\n            <td width=\"90%\">\r\n工资上报：<a href=\"/general/salary/submit/sal_index.php?FLOW_ID=";
		echo $FLOW_ID;
		echo "\">";
		echo $CONTENT;
		echo "</a>\r\n</td>\r\n</tr>\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;
		if ( 9 <= $FLOW_COUNT )
		{
		}
		else
		{
			$USER_NAME = $ROW['USER_NAME'];
			if ( $FLOW_COUNT % 2 != 1 )
			{
				$TableLine = "TableLine1";
			}
			else
			{
				$TableLine = "TableLine2";
			}
			echo "<tr class=\"";
			echo $TableLine;
			echo "\" height=\"25\">\r\n            <td width=\"2%\">&nbsp;</td>\r\n            <td width=\"90%\">\r\n考勤管理：<a href=\"/general/attendance/manage\">批示";
			echo $USER_NAME;
			echo "的外出申请</a>\r\n</td>\r\n</tr>\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;
		if ( 9 <= $FLOW_COUNT )
		{
		}
		else
		{
			$USER_NAME = $ROW['USER_NAME'];
			$ALLOW = $ROW['ALLOW'];
			if ( $ALLOW == "0" )
			{
				$ALLOW = "批示".$USER_NAME."的请假申请";
			}
			else
			{
				$ALLOW = "批示".$USER_NAME."的销假申请";
			}
			if ( $FLOW_COUNT % 2 != 1 )
			{
				$TableLine = "TableLine1";
			}
			else
			{
				$TableLine = "TableLine2";
			}
			echo "<tr class=\"";
			echo $TableLine;
			echo "\" height=\"25\">\r\n            <td width=\"2%\">&nbsp;</td>\r\n            <td width=\"90%\">\r\n考勤管理：<a href=\"/general/attendance/manage\">";
			echo $ALLOW;
			echo "</a>\r\n</td>\r\n</tr>\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;
	if ( 10 <= $FLOW_COUNT )
	{
	}
	else
	{
		$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'];
		}
		if ( $FLOW_COUNT % 2 != 1 )
		{
			$TableLine = "TableLine1";
		}
		else
		{
			$TableLine = "TableLine2";
		}
		echo "<tr class=\"";
		echo $TableLine;
		echo "\" height=\"25\">\r\n            <td width=\"2%\">&nbsp;</td>\r\n            <td width=\"90%\">\r\n工作流：";
		echo $STATUS;
		echo " <a href=\"/general/workflow\">";
		echo $FLOW_NAME;
		echo " - ";
		echo $RUN_NAME;
		echo "</a>\r\n</td>\r\n</tr>\r\n";
	}
}
if ( $FLOW_COUNT == 0 )
{
	echo "无待办事宜";
}
echo "</td>\r\n          </tr>\r\n\t\t</table>\r\n\t\t</td>\r\n      </tr>\r\n    </table></td>\r\n    <td width=\"10\" class=\"newslineright\"></td>\r\n  </tr>\r\n  \r\n</table>\r\n";
?>