work_list.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  <tr class=\"tablehead2\">\r\n    <td ><a href=\"javascript:history.back()\"><img src=\"/images/button/return.gif\" border=\"0\"></a>\r\n    </td>\r\n  </tr>\r\n</table>\r\n<br>\r\n<div class=\"small\">\r\n<table width=\"100%\"  border=\"0\" cellspacing=\"0\" ";
echo "cellpadding=\"0\" class=\"darkbord\" id=\"contentid04\">\r\n<!-------------------- 待办事宜 ----------------------->\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, "17" ) )
{
	++$FLOW_COUNT;
	echo "<tr height=\"20\" class=\"TableLine2\">\r\n<td width=\"12\"></td>\r\n<td>\r\n个人考勤：<a href=\"/general/attendance/personal\" target=\"main\">上下班登记</a>\r\n</td>\r\n</tr>\r\n<tr><td  colspan=\"2\" bgcolor=\"";
	echo $tdbgcolor;
	echo "\" height=\"1\"></td></tr>\r\n";
}
if ( find_id( $USER_FUNC_ID_STR, "19" ) )
{
	$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 "\">\r\n<td width=\"12\"></td>\r\n<td>\r\n工资上报：<a href=\"/general/salary/submit/sal_index.php?FLOW_ID=";
		echo $FLOW_ID;
		echo "\" target=\"main\">";
		echo $CONTENT;
		echo "</a>\r\n</td>\r\n</tr>\r\n<tr><td colspan=\"2\" bgcolor=\"";
		echo $tdbgcolor;
		echo "\" height=\"1\"></td></tr>\r\n";
	}
}
if ( find_id( $USER_FUNC_ID_STR, "63" ) )
{
	$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'];
		if ( $FLOW_COUNT % 2 == 1 )
		{
			$TableLine = "TableLine1";
		}
		else
		{
			$TableLine = "TableLine2";
		}
		echo "<tr height=\"20\" class=\"";
		echo $TableLine;
		echo "\">\r\n<td width=\"12\"></td>\r\n<td>\r\n考勤管理：<a href=\"/general/attendance/manage\" target=\"main\">批示";
		echo $USER_NAME;
		echo "的外出申请</a>\r\n</td>\r\n</tr>\r\n<tr><td  bgcolor=\"";
		echo $tdbgcolor;
		echo "\" height=\"1\"></td></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;
		$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 "\">\r\n<td width=\"12\"></td>\r\n<td>\r\n考勤管理：<a href=\"/general/attendance/manage\" target=\"main\">";
		echo $ALLOW;
		echo "</a>\r\n</td>\r\n</tr>\r\n<tr height=\"20\"><td colspan=\"2\" bgcolor=\"";
		echo $tdbgcolor;
		echo "\" height=\"1\"></td></tr>\r\n";
	}
}
if ( find_id( $USER_FUNC_ID_STR, "3" ) )
{
	$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'];
		}
		if ( $FLOW_COUNT % 2 == 1 )
		{
			$TableLine = "TableLine1";
		}
		else
		{
			$TableLine = "TableLine2";
		}
		echo "<tr height=\"20\" class=\"";
		echo $TableLine;
		echo "\">\r\n<td width=\"12\"></td>\r\n<td>\r\n工作流：";
		echo $STATUS;
		echo " <a href=\"/general/workflow\" target=\"main\">";
		echo $FLOW_NAME;
		echo " - ";
		echo $RUN_NAME;
		echo "</a>\r\n</td>\r\n</tr>\r\n<tr><td colspan=\"2\" bgcolor=\"";
		echo $tdbgcolor;
		echo "\" height=\"1\"></td></tr>\r\n";
	}
}
if ( $FLOW_COUNT == 0 )
{
	echo "<tr>\r\n<td colspan=\"2\">\r\n无待办事宜\r\n</td>\r\n</tr>\r\n<tr><td  bgcolor=\"";
	echo $tdbgcolor;
	echo "\" height=\"1\"></td></tr> \r\n";
}
echo "</table>\r\n</div>\r\n<br>\r\n";
?>