⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 getdata.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(
💻 PHP
字号:
🔍 
<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_file.php" );
include_once( "../prcs_role.php" );
include_once( "inc/department.php" );
ob_end_clean( );
while ( list( $k, $v ) = each( &$GLOBALS['_GET'] ) )
{
	$$k = iconv( "UTF-8", "GBK", $v );
}
while ( list( $k, $v ) = each( &$GLOBALS['_POST'] ) )
{
	$$k = iconv( "UTF-8", "GBK", $v );
}
if ( $act == "count" )
{
	$query = "SELECT count(*)";
}
else
{
	$query = "SELECT FLOW_RUN.RUN_ID,RUN_NAME,BEGIN_TIME,END_TIME,FLOW_TYPE.FLOW_ID,FLOW_NAME,FREE_OTHER,FLOW_TYPE,MANAGE_USER,QUERY_USER,ATTACHMENT_ID,ATTACHMENT_NAME,COMMENT_PRIV,FOCUS_USER,EDIT_PRIV";
}
$query .= " from FLOW_TYPE,FLOW_RUN,USER WHERE FLOW_RUN.BEGIN_USER=USER.USER_ID AND FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID and FLOW_RUN.DEL_FLAG=0";
if ( $FLOW_ID )
{
	$FLOW_ID_GLOBAL = $FLOW_ID;
	$query_add .= " and FLOW_TYPE.FLOW_ID='".$FLOW_ID."'";
}
if ( $RUN_ID != "" )
{
	$query_add .= " and FLOW_RUN.RUN_ID='".$RUN_ID."'";
}
if ( $RUN_NAME != "" )
{
	$query_add .= " and FLOW_RUN.RUN_NAME like '%".$RUN_NAME."%'";
}
$query .= $query_add;
if ( $PRCS_DATE1 != "" )
{
	$query .= " and BEGIN_TIME>='".$PRCS_DATE1." 00:00:00'";
}
if ( $PRCS_DATE2 != "" )
{
	$query .= " and BEGIN_TIME<='".$PRCS_DATE2." 23:59:59'";
}
if ( $FLOW_QUERY_TYPE == "ALL" && $LOGIN_USER_PRIV != 1 )
{
	$MY_RUN_ID = getmyrun( );
	$MY_DEPT_STR = getmydept( );
	$query .= " and (FLOW_RUN.RUN_ID in (".$MY_RUN_ID.") or FIND_IN_SET('{$LOGIN_USER_ID}',MANAGE_USER) or FIND_IN_SET('{$LOGIN_USER_ID}',QUERY_USER) or (USER.DEPT_ID IN ({$MY_DEPT_STR}) AND (FIND_IN_SET('{$LOGIN_USER_ID}',MANAGE_USER_DEPT) or FIND_IN_SET('{$LOGIN_USER_ID}',QUERY_USER_DEPT))) )";
}
else if ( $FLOW_QUERY_TYPE == "1" )
{
	$BEGIN_USER = $LOGIN_USER_ID;
}
else if ( $FLOW_QUERY_TYPE == "2" )
{
	$MY_RUN_ID = getmyrun( );
	$query .= " and FLOW_RUN.RUN_ID in (".$MY_RUN_ID.")";
}
else if ( $FLOW_QUERY_TYPE == "3" && $LOGIN_USER_PRIV != 1 )
{
	$MY_DEPT_STR = getmydept( );
	$query .= " and (FIND_IN_SET('".$LOGIN_USER_ID."',MANAGE_USER) or FIND_IN_SET('{$LOGIN_USER_ID}',QUERY_USER) or (USER.DEPT_ID IN ({$MY_DEPT_STR}) AND (FIND_IN_SET('{$LOGIN_USER_ID}',QUERY_USER_DEPT) or FIND_IN_SET('{$LOGIN_USER_ID}',MANAGE_USER_DEPT))) )";
}
else if ( $FLOW_QUERY_TYPE == "4" )
{
	$query .= " and find_in_set('".$LOGIN_USER_ID."',FOCUS_USER)";
}
else if ( $FLOW_QUERY_TYPE == "5" )
{
	if ( $LOGIN_USER_PRIV != 1 )
	{
		$MY_DEPT_STR = getmydept( );
		$query .= " and (FIND_IN_SET('".$LOGIN_USER_ID."',MANAGE_USER) or FIND_IN_SET('{$LOGIN_USER_ID}',QUERY_USER) or (USER.DEPT_ID IN ({$MY_DEPT_STR}) AND (FIND_IN_SET('{$LOGIN_USER_ID}',QUERY_USER_DEPT) or FIND_IN_SET('{$LOGIN_USER_ID}',MANAGE_USER_DEPT))) )";
	}
	$BEGIN_USER = $TO_ID;
}
else if ( $LOGIN_USER_PRIV != 1 )
{
	exit( );
}
if ( $FLOW_STATUS != "ALL" )
{
	if ( $FLOW_STATUS == "0" )
	{
		$query .= " and FLOW_RUN.END_TIME is null";
	}
	else
	{
		$query .= " and FLOW_RUN.END_TIME is not null";
	}
}
if ( $BEGIN_USER != "" )
{
	$query .= " and BEGIN_USER='".$BEGIN_USER."'";
}
if ( $act == "count" )
{
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$FLOW_COUNT = $ROW[0];
	}
	echo $FLOW_COUNT;
	exit( );
}
$query .= " order by FLOW_RUN.RUN_ID desc";
$limit = $endrecord - $startrecord + 1;
$start = $startrecord - 1;
$query .= " limit ".$start.",{$limit}";
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$RUN_ID = $ROW['RUN_ID'];
	$RUN_NAME = $ROW['RUN_NAME'];
	$BEGIN_TIME = $ROW['BEGIN_TIME'];
	$END_TIME = $ROW['END_TIME'];
	$FLOW_ID = $ROW['FLOW_ID'];
	$FLOW_NAME = $ROW['FLOW_NAME'];
	$FLOW_TYPE = $ROW['FLOW_TYPE'];
	$FREE_OTHER = $ROW['FREE_OTHER'];
	$MANAGE_USER = $ROW['MANAGE_USER'];
	$MANAGE_USER_DEPT = $ROW['MANAGE_USER_DEPT'];
	$QUERY_USER = $ROW['QUERY_USER'];
	$QUERY_USER_DEPT = $ROW['QUERY_USER_DEPT'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$COMMENT_PRIV = $ROW['COMMENT_PRIV'];
	$FOCUS_USER = $ROW['FOCUS_USER'];
	$EDIT_PRIV = $ROW['EDIT_PRIV'];
	if ( $FLOW_STATUS == "ALL" )
	{
		if ( $END_TIME == "" )
		{
			$STATUS = "<font color=red>执行中</font>";
		}
		else
		{
			$STATUS = "已结束";
		}
	}
	else if ( $FLOW_STATUS == "0" )
	{
		$STATUS = "<font color=red>执行中</font>";
	}
	else
	{
		$STATUS = "已结束";
	}
	if ( $STATUS == "已结束" )
	{
		$PRCS_OVER = 1;
	}
	else
	{
		$PRCS_OVER = 0;
	}
	$OP_FLAG = "";
	$query1 = "SELECT PRCS_ID,PRCS_FLAG,FLOW_PRCS,OP_FLAG from FLOW_RUN_PRCS WHERE RUN_ID='".$RUN_ID."' AND USER_ID='{$LOGIN_USER_ID}' and PRCS_FLAG<>'4' order by PRCS_FLAG limit 1";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$PRCS_ID = $ROW['PRCS_ID'];
		$PRCS_FLAG = $ROW['PRCS_FLAG'];
		$FLOW_PRCS = $ROW['FLOW_PRCS'];
		$OP_FLAG = $ROW['OP_FLAG'];
	}
	else
	{
		$PRCS_FLAG = "";
	}
	++$FLOW_COUNT;
	$RUN_ID_STR .= $RUN_ID.",";
	if ( $FLOW_COUNT == 1 )
	{
		echo "  <table id=\"flow_table\" width=\"100%\" class=\"TableList\" align=\"center\" style=\"border-bottom:0px;\">\r\n    <thead class=\"TableHeader\">\r\n";
		if ( $FLOW_ID_GLOBAL || $LOGIN_USER_PRIV == "1" )
		{
			echo "    \t<td nowrap align=\"center\">选择</td>\r\n";
		}
		echo "      <td nowrap align=\"center\"><a href=\"#\">流水号</a></td>\r\n      <td nowrap align=\"center\"><a href=\"#\">工作名称/文号</a></td>\r\n      <td nowrap align=\"center\"><a href=\"#\">开始时间</a></td>\r\n      <td nowrap align=\"center\"><a href=\"#\">公共附件</a></td>\r\n      <td nowrap align=\"center\"><a href=\"#\">状态</a></td>\r\n      <td nowrap align=\"center\">操作</td>\r\n    </thead>\r\n    <tbody>\r\n";
	}
	if ( $FLOW_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "    <tr id=\"";
	echo $RUN_ID;
	echo "\" class=\"";
	echo $TableLine;
	echo "\">\r\n";
	if ( $FLOW_ID_GLOBAL || $LOGIN_USER_PRIV == "1" )
	{
		echo "    \t<td nowrap align=\"center\">\r\n    \t\t<input type=\"checkbox\" name=\"run_select\" value=\"";
		echo $RUN_ID;
		echo "\" onClick=\"check_one(self);\">\r\n    \t</td>\r\n";
	}
	echo "      <td nowrap align=\"center\" class=\"TableContent\" width=\"50px\"><b>";
	echo $RUN_ID;
	echo "</b></td>\r\n      <td>\r\n        <a href=\"javascript:form_view(";
	echo $RUN_ID;
	echo ",";
	echo $FLOW_ID;
	echo ");\">";
	echo $RUN_NAME;
	echo "</a>\r\n      </td>\r\n      <td align=\"center\" width=\"120px\">";
	echo $BEGIN_TIME;
	echo "</td>\r\n      <td>\r\n";
	if ( $ATTACHMENT_ID == "" )
	{
		echo "无";
	}
	else
	{
		$DOWN_PRIV_OFFICE = "";
		if ( $FLOW_TYPE == 1 )
		{
			$query1 = "select 1 from FLOW_RUN_PRCS,FLOW_PROCESS WHERE FLOW_RUN_PRCS.RUN_ID='".$RUN_ID."' AND FLOW_PROCESS.FLOW_ID='{$FLOW_ID}' AND FLOW_RUN_PRCS.FLOW_PRCS=FLOW_PROCESS.PRCS_ID AND FLOW_RUN_PRCS.USER_ID='{$LOGIN_USER_ID}' AND ATTACH_PRIV<>'' AND NOT FIND_IN_SET('4',ATTACH_PRIV)";
			$cursor1 = exequery( $connection, $query1 );
			if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
			{
				$DOWN_PRIV_OFFICE .= "0";
			}
			else
			{
				$DOWN_PRIV_OFFICE .= "1";
			}
			$query1 = "select 1 from FLOW_RUN_PRCS,FLOW_PROCESS WHERE FLOW_RUN_PRCS.RUN_ID='".$RUN_ID."' AND FLOW_PROCESS.FLOW_ID='{$FLOW_ID}' AND FLOW_RUN_PRCS.FLOW_PRCS=FLOW_PROCESS.PRCS_ID AND FLOW_RUN_PRCS.USER_ID='{$LOGIN_USER_ID}' AND ATTACH_PRIV<>'' AND NOT FIND_IN_SET('5',ATTACH_PRIV)";
			$cursor1 = exequery( $connection, $query1 );
			if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
			{
				$DOWN_PRIV_OFFICE .= "0";
			}
			else
			{
				$DOWN_PRIV_OFFICE .= "1";
			}
		}
		else
		{
			$DOWN_PRIV_OFFICE = "11";
		}
		echo attach_link( $ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, $DOWN_PRIV_OFFICE, 0, 0, 1, 1, 0, "" );
	}
	echo "      </td>\r\n      <td align=\"center\" nowrap>";
	echo $STATUS;
	echo "</td>\r\n      <td nowrap>\r\n          <a class=\"op\" href=\"javascript:flow_view(";
	echo $RUN_ID;
	echo ",";
	echo $FLOW_ID;
	echo ")\">流程图&nbsp;</a>\r\n";
	if ( ( $COMMENT_PRIV = find_id( $MANAGE_USER, $LOGIN_USER_ID ) || find_id( $QUERY_USER, $LOGIN_USER_ID ) ) || ( $COMMENT_PRIV = find_id( $QUERY_USER, $LOGIN_USER_ID ) ) || ( $COMMENT_PRIV = find_id( $MANAGE_USER, $LOGIN_USER_ID ) ) )
	{
		echo "          <a class=\"op\" title=\"添加点评意见\" href=\"javascript:comment(";
		echo $RUN_ID;
		echo ",";
		echo $FLOW_ID;
		echo ")\">点评&nbsp;</a>\r\n";
	}
	if ( $PRCS_FLAG == "1" || $PRCS_FLAG == "2" )
	{
		echo "          <a class=\"op\" href=\"../list/input_form?MENU_FLAG=";
		echo $MENU_FLAG;
		echo "&RUN_ID=";
		echo $RUN_ID;
		echo "&FLOW_ID=";
		echo $FLOW_ID;
		echo "&PRCS_ID=";
		echo $PRCS_ID;
		echo "&FLOW_PRCS=";
		echo $FLOW_PRCS;
		echo "\">办理&nbsp;</a>\r\n";
		if ( !( $FREE_OTHER == 1 ) && $OP_FLAG || $FREE_OTHER == 2 || $FREE_OTHER == 3 )
		{
			echo "          <a class=\"op\" title=\"委托给其他人办理\" href=\"javascript:others('";
			echo $FLOW_ID;
			echo "','";
			echo $RUN_ID;
			echo "','";
			echo $PRCS_ID;
			echo "','";
			echo $FLOW_PRCS;
			echo "','";
			echo $FLOW_TYPE;
			echo "');\" >委托&nbsp;</a>\r\n";
		}
	}
	else if ( $PRCS_FLAG == "3" && $OP_FLAG == "1" )
	{
		echo "          <a class=\"op\" title=\"收回对方未接受的工作\" id=\"";
		echo $RUN_ID;
		echo "_back\" href=\"javascript:call_back('";
		echo $RUN_ID;
		echo "','";
		echo $PRCS_ID;
		echo "','";
		echo $FLOW_PRCS;
		echo "');\">收回&nbsp;</a>\r\n";
	}
	if ( $PRCS_OVER )
	{
		if ( $LOGIN_USER_PRIV == "1" )
		{
			echo "          <a class=\"op\" title=\"将已结束工作恢复到执行中\" id=\"";
			echo $RUN_ID;
			echo "_a3\" href=\"javascript:restore_run(";
			echo $RUN_ID;
			echo ");\">恢复执行&nbsp;</a>\r\n";
		}
		if ( $EDIT_PRIV )
		{
			$PRIV_ARRAY = explode( "|", $EDIT_PRIV );
			$PRIV_USER = $PRIV_ARRAY[0];
			$PRIV_DEPT = $PRIV_ARRAY[1];
			$PRIV_ROLE = $PRIV_ARRAY[2];
		}
		if ( $LOGIN_USER_PRIV == "1" || $PRIV_DEPT == "ALL_DEPT" || find_id( $PRIV_USER, $LOGIN_USER_ID ) || find_id( $PRIV_DEPT, $LOGIN_DEPT_ID ) || find_id( $PRIV_ROLE, $LOGIN_USER_PRIV ) )
		{
			echo "          <a class=\"op\" title=\"编辑已结束工作表单数据\" id=\"";
			echo $RUN_ID;
			echo "_a2\" href=\"javascript:edit_run(";
			echo $RUN_ID;
			echo ",";
			echo $FLOW_ID;
			echo ");\">编辑&nbsp;</a>\r\n";
		}
	}
	if ( !find_id( $FOCUS_USER, $LOGIN_USER_ID ) || $END_TIME == "" )
	{
		echo "          <a class=\"op\" id=\"";
		echo $RUN_ID;
		echo "_a1\" href=\"javascript:focus_run(";
		echo $RUN_ID;
		echo ",1)\">关注</a>&nbsp;\r\n";
	}
	else if ( find_id( $FOCUS_USER, $LOGIN_USER_ID ) )
	{
		echo "          <a class=\"op\" id=\"";
		echo $RUN_ID;
		echo "_a1\" href=\"javascript:focus_run(";
		echo $RUN_ID;
		echo ",0)\">取消关注</a>&nbsp;\r\n";
	}
	echo "      </td>\r\n    </tr>\r\n";
}
echo "</table>";
if ( 0 < $FLOW_COUNT && ( $FLOW_ID_GLOBAL || $LOGIN_USER_PRIV == "1" ) )
{
	echo "  <table class=\"TableList\" border=0 width=\"100%\" style=\"margin:0;\">\r\n  <tr class=\"TableControl\">\r\n  <td colspan=\"10\">\r\n  \t&nbsp;<input type=\"checkbox\" name=\"allbox\" id=\"allbox_for\" onClick=\"check_all();\">\r\n    <label for=\"allbox_for\" style=\"cursor:hand\"><u><b>全选</b></u></label> &nbsp;\r\n";
	if ( $FLOW_ID_GLOBAL )
	{
		echo "    <input type=\"button\"  value=\"导出Excel\" class=\"SmallButtonB\" onClick=\"export_run_sel();\" title=\"导出所选工作到Excel\"> &nbsp;\r\n";
	}
	if ( $LOGIN_USER_PRIV == "1" || $FLOW_ID_GLOBAL && find_id( $MANAGE_USER, $LOGIN_USER_ID ) )
	{
		echo "\r\n    <input type=\"button\"  value=\"导出ZIP\" class=\"SmallButtonB\" onClick=\"zip_run_sel();\" title=\"批量导出所选工作\"> &nbsp;\r\n    <input type=\"button\"  value=\"管理人员删除\" class=\"SmallButtonC\" onClick=\"delete_run_sel();\" title=\"删除所选工作\"> &nbsp;\r\n";
	}
	if ( $LOGIN_USER_PRIV == "1" )
	{
		echo "<input type=\"button\"  value=\"强制结束\" class=\"SmallButtonB\" onClick=\"end_run();\" title=\"强制结束\">";
	}
	echo "</td></tr></table>";
}
?>

⌨️ 快捷键说明

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