search.php

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

			case 9 :
				$WHERE_STR .= " like '%".$FIELDVALUE1."'";
			}
			$WHERE_STR1 .= $WHERE_STR;
		}
		$query1 = "select * from FLOW_RUN_DATA where RUN_ID='".$RUN_ID."' and ITEM_ID={$I} ".$WHERE_STR1;
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			continue;
		}
		$NOT_FOUND = 1;
		break;
	}
	if ( $NOT_FOUND == 1 )
	{
		continue;
	}
	$NOT_FOUND = 0;
	$I = 1;
	for ( ;	$I <= $ITEM_ID_MAX;	++$I	)
	{
		$STR = "DATA_".$I."_2";
		$FIELDVALUE = $$STR;
		if ( !( $FIELDVALUE != "" ) && !( $FIELDVALUE != "SELECT_ALL_VALUE" ) )
		{
			continue;
		}
		$STR = "RELATION_".$I."_2";
		$RELATION = $$STR;
		if ( $FIELDVALUE == "CHECKBOX_ON" )
		{
			$FIELDVALUE = "on";
		}
		else if ( $FIELDVALUE == "CHECKBOX_OFF" )
		{
			$FIELDVALUE = "";
		}
		$WHERE_STR = " where RUN_ID=".$RUN_ID." and ITEM_ID={$I} and ITEM_DATA";
		switch ( $RELATION )
		{
		case 1 :
			$WHERE_STR .= "='".$FIELDVALUE."'";
			break;
		case 2 :
			$WHERE_STR .= ">'".$FIELDVALUE."'";
			break;
		case 3 :
			$WHERE_STR .= "<'".$FIELDVALUE."'";
			break;
		case 4 :
			$WHERE_STR .= ">='".$FIELDVALUE."'";
			break;
		case 5 :
			$WHERE_STR .= "<='".$FIELDVALUE."'";
			break;
		case 6 :
			$WHERE_STR .= "!='".$FIELDVALUE."'";
			break;
		case 7 :
			$WHERE_STR .= " like '".$FIELDVALUE."%'";
			break;
		case 8 :
			$WHERE_STR .= " like '%".$FIELDVALUE."%'";
			break;
		case 9 :
			$WHERE_STR .= " like '%".$FIELDVALUE."'";
		}
		$query1 = "select * from FLOW_RUN_DATA".$WHERE_STR;
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			continue;
		}
		$NOT_FOUND = 1;
		break;
	}
	if ( $NOT_FOUND == 1 )
	{
		continue;
	}
	if ( $FLOW_STATUS == "ALL" )
	{
		if ( find_id( $STATUS_RUN, $RUN_ID ) )
		{
			$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;
	}
	$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 )
	{
		if ( $FLOW_ID_GLOBAL )
		{
			echo "   <input type=\"button\" class=\"SmallButton\" value=\"生成Excel报表\" onclick=\"excel_data()\">&nbsp;\r\n   <input type=\"button\" class=\"SmallButton\" value=\"返回\" onclick=\"history.back()\">\r\n";
		}
		echo "  <table id=\"flow_table\" border=\"1\" bordercolor=\"#000000\" style=\"border-collapse:collapse\" cellspacing=\"0\" width=\"100%\" class=\"small\" cellpadding=\"3\" align=\"center\">\r\n    <tr 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\">当前步骤</td>\r\n      <td nowrap align=\"center\">当前主办人</td>\r\n      <td nowrap align=\"center\"><a href=\"#\">状态</a></td>\r\n      <td nowrap align=\"center\">操作</td>\r\n    </tr>\r\n";
	}
	if ( $FLOW_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "    <tr 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\"><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\">";
	echo $PRCS_TIME;
	echo "</td>\r\n      <td>\r\n";
	if ( $ATTACHMENT_ID == "" )
	{
		echo "无";
	}
	else
	{
		echo attach_link( $ATTACHMENT_ID, $ATTACHMENT_NAME, 0, 1, 1, 0, 0, 1, 1, 0, "" );
	}
	echo "      </td>\r\n      <td>";
	echo $PRCS_NAME;
	echo "</td>\r\n      <td align=\"center\" nowrap>";
	echo $USER_NAME;
	echo "</td>\r\n      <td align=\"center\" nowrap>";
	echo $STATUS;
	echo "</td>\r\n      <td nowrap>\r\n          <a href=\"javascript:flow_view(";
	echo $RUN_ID;
	echo ",";
	echo $FLOW_ID;
	echo ")\">流程图</a>&nbsp;\r\n";
	if ( $PRCS_FLAG == "1" || $PRCS_FLAG == "2" )
	{
		echo "          <a 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 "\" ";
		if ( $MENU_FLAG != "1" )
		{
			echo "target=_parent";
		}
		echo ">办理</a>&nbsp;\r\n          <a href=\"../list/others/";
		if ( $FLOW_TYPE == "1" )
		{
			echo "others";
		}
		else
		{
			echo "others_free";
		}
		echo ".php?MENU_FLAG=";
		echo $MENU_FLAG;
		echo "&RUN_ID=";
		echo $RUN_ID;
		echo "&FLOW_ID=";
		echo $FLOW_ID;
		echo "&PRCS_ID=";
		echo $PRCS_ID;
		echo "&OP_FLAG=";
		echo $OP_FLAG;
		echo "\"  ";
		if ( $MENU_FLAG != "1" )
		{
			echo "target=_parent";
		}
		echo ">委托</a>&nbsp;\r\n";
	}
	else if ( $PRCS_FLAG == "3" && $OP_FLAG == "1" )
	{
		echo "          <a href=\"javascript:call_back(";
		echo $RUN_ID;
		echo ",";
		echo $PRCS_ID;
		echo ");\">收回</a>\r\n";
	}
	if ( $LOGIN_USER_PRIV == "1" && $PRCS_OVER )
	{
		echo "          <a href=\"javascript:restore_run(";
		echo $RUN_ID;
		echo ",";
		echo $FLOW_ID;
		echo ");\">恢复执行</a>&nbsp;\r\n          <a href=\"javascript:edit_run(";
		echo $RUN_ID;
		echo ",";
		echo $FLOW_ID;
		echo ");\">编辑</a>&nbsp;\r\n";
	}
	echo "\r\n      </td>\r\n    </tr>\r\n";
	if ( !( $QUERY_LIMIT != "" ) && !( $QUERY_LIMIT <= $FLOW_COUNT ) )
	{
		continue;
	}
	break;
}
if ( 0 < $FLOW_COUNT )
{
	echo "</table>";
	if ( $FLOW_ID_GLOBAL || $LOGIN_USER_PRIV == "1" )
	{
		echo "  <table border=\"0\" cellspacing=\"0\" width=\"100%\" class=\"small\" cellpadding=\"3\" align=\"center\">\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;color:blue\"><u><b>全选</b></u></label> &nbsp;\r\n";
		if ( $FLOW_ID_GLOBAL )
		{
			echo "    <input type=\"button\"  value=\"导出Excel\" class=\"SmallButton\" onClick=\"export_run_sel();\" title=\"导出所选工作到Excel\"> &nbsp;\r\n";
		}
		if ( $LOGIN_USER_PRIV == "1" )
		{
			echo "    <input type=\"button\"  value=\"管理员删除\" class=\"SmallButton\" onClick=\"delete_run_sel();\" title=\"删除所选工作\"> &nbsp;\r\n";
		}
		if ( $LIST_VIEW != "" && $FLOW_ID_GLOBAL )
		{
			echo "   <select name=\"LIST_VIEW\" class=\"SmallSelect\">\r\n";
			$MY_ARRAY = explode( "^", $LIST_VIEW );
			$ARRAY_COUNT = sizeof( $MY_ARRAY );
			if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
			{
				--$ARRAY_COUNT;
			}
			$I = 0;
			for ( ;	$I < $ARRAY_COUNT;	++$I	)
			{
				$ITEM_NAME = strtok( $MY_ARRAY[$I], "~" );
				echo "   \t   <option value=\"";
				echo urlencode( $MY_ARRAY[$I] );
				echo "\">";
				echo $ITEM_NAME;
				echo "</option>\r\n";
			}
			echo "  </select>\r\n  <input type=\"button\"  value=\"列表项导出\" class=\"SmallButton\" onClick=\"export_list_view();\" title=\"导出所选工作中的列表项到Excel\"> &nbsp;\r\n";
		}
		echo "  </td></tr>\r\n  </table>\r\n";
	}
	message( "", "共 ".$FLOW_COUNT." 条" );
	echo "<script>\r\nfunction excel_data()\r\n{\r\n \tdocument.form1.RUN_ID_STR.value=document.form1.RUN_ID_STR_ALL.value;\r\n \tdocument.form1.action=\"excel_data.php\";\r\n  document.form1.submit();\r\n}\r\n</script>\r\n\r\n";
}
else
{
	message( "", "无符合条件的工作" );
}
if ( !$QUERY_SMALL )
{
	button_back( );
}
else
{
	echo "    <div align=center><input type=\"button\"  value=\"返回\" class=\"BigButton\" onClick=\"location='blank.php';\"></div>\r\n";
}
echo "\r\n<form action=\"\" method=\"post\" name=\"form1\">\r\n  <input type=\"hidden\" value=\"";
echo $FLOW_ID;
echo "\" name=\"FLOW_ID\">\r\n  <input type=\"hidden\" value=\"\" name=\"RUN_ID_STR\">\r\n  <input type=\"hidden\" value=\"";
echo $RUN_ID_STR;
echo "\" name=\"RUN_ID_STR_ALL\">\r\n  <input type=\"hidden\" value=\"\" name=\"QUERY_FLAG\">\r\n  <input type=\"hidden\" value=\"\" name=\"LIST_VIEW_STR\">\r\n</form>\r\n\r\n</body>\r\n</html>";
?>