📄 search.php

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

include_once( "inc/auth.php" );
include_once( "inc/utility_file.php" );
include_once( "../prcs_role.php" );
echo "\r\n<html>\r\n<head>\r\n<title>工作流查询</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<style>\r\na.op, a.delete {\r\n\tborder-bottom: none;\r\n\tdisplay: inline;\r\n\tpadding: 2px;\r\n\ttext-align: center;\r\n}\r\na.op:hover{\r\n\tbackground: #06c;\r\n\tcolor: #fff;\r\n\ttext-decoration:none;\r\n}\r\na.delete:hover {\r\n\tbackground: #c00;\r\n\tcolor: #fff;\r\n\ttext-decoration:none;\r\n}\r\n.tip {position:absolute;display:none;text-align:center;font-size:9pt;font-weight:bold;z-index:65535;background-color:#DE7293;color:white;padding:10px}\r\n</style>\r\n<script src=\"/inc/sort_table.js\"></script>\r\n<script src=\"/inc/js/attach.js\"></script>\r\n<script language=\"javascript\" src=\"/inc/js/jquery/jquery.js\"></script>\r\n<script language=\"javascript\" src=\"/inc/js/jquery/utility.js\"></script>\r\n<script>\r\n\r\nfunction form_view(RUN_ID,FLOW_ID)\r\n{\r\n  window.open(\"../list/print?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID,\"\",\"status=0,toolbar=no,menubar=no,width=\"+(screen.availWidth-12)+\",height=\"+(screen.availHeight-38)+\",location=no,scrollbars=yes,resizable=yes,left=0,top=0\");\r\n}\r\n\r\nfunction comment(RUN_ID,FLOW_ID)\r\n{\r\n  myleft=(screen.availWidth-800)/2;\r\n  mytop=(screen.availWidth-600)/2;\r\n  window.open(\"../list/comment.php?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID,\"\",\"status=0,toolbar=no,menubar=no,width=550,height=180,location=no,scrollbars=yes,resizable=no,left=\"+myleft+\",top=\"+mytop);\r\n}\r\n\r\nfunction flow_view(RUN_ID,FLOW_ID)\r\n{\r\n  myleft=(screen.availWidth-800)/2;\r\n  window.open(\"../list/flow_view?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID,RUN_ID,\"status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,width=800,height=400,left=\"+myleft+\",top=100\");\r\n}\r\n\r\nfunction edit_run(RUN_ID,FLOW_ID)\r\n{\r\n  myleft=(screen.availWidth-800)/2;\r\n  window.open(\"../list/input_form?RUN_ID=\"+RUN_ID+\"&MENU_FLAG=";
echo $MENU_FLAG;
echo "&EDIT_MODE=1&FLOW_ID=\"+FLOW_ID,\"edit_run\",\"status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,width=800,height=600,left=\"+myleft+\",top=50\");\r\n}\r\n\r\nfunction check_one(el)\r\n{\r\n   if(!el.checked)\r\n      jQuery(\"#allbox_for\").attr(\"checked\", false); \r\n}\r\n\r\nfunction check_all()\r\n{\r\n  if(jQuery(\"#allbox_for\").attr(\"checked\")==true)\r\n  \tjQuery(\"input[@name='run_select']\").each(function(){jQuery(this).attr(\"checked\", true);});\r\n  else\r\n    jQuery(\"input[@name='run_select']\").each(function(){jQuery(this).attr(\"checked\", false);});\r\n}\r\n\r\nfunction get_run_str()\r\n{\r\n  var run_str=\"\";\r\n  jQuery(\"input[@name='run_select']\").each(function(){\r\n  \tif(jQuery(this).attr(\"checked\")==true)\r\n  \t   run_str+=jQuery(this).val()+\",\";\r\n  \t});\r\n  run_str=run_str.substr(0,run_str.length-1);\r\n  return run_str;\r\n}\r\nfunction delete_run_sel()\r\n{\r\n  msg=\"确认要删除所选工作么？\";\r\n  if(window.confirm(msg))\r\n  {\r\n  \t var run_str=get_run_str();\r\n  \t if(run_str==\"\")\r\n     {\r\n        alert(\"要删除工作，请至少选择其中一项。\");\r\n        return;\r\n     }\r\n     jQuery.get(\"../list/delete.php\",{\"RUN_ID_STR\":run_str},function(data)\r\n       {\r\n      \tif(data==run_str)\r\n      \t\t showTip('<div class=\"tip\" id=\"loading\">所选流程已全部删除</div>');\r\n        else\r\n           showTip('<div class=\"tip\" id=\"loading\">部分未删除</div>');\r\n        if(data!='')\r\n        {\r\n        \tvar tmp=data.split(\",\");\r\n          for(var i=0;i<tmp.length;i++)\r\n            jQuery(\"#\"+tmp[i]).remove();\r\n        }\r\n        if(jQuery(\"#flow_table tbody>tr\").length==0)\r\n           jQuery(\"#flow_table\").remove();\r\n      });\r\n  }\r\n}\r\nfunction restore_run(RUN_ID)\r\n{\r\n  msg=\"确认要将此工作恢复到执行中么？\";\r\n  if(window.confirm(msg))\r\n  {\r\n    var url=\"restore.php?RUN_ID=\"+RUN_ID;\r\n    jQuery.get(url,{},function(data){\r\n    \t   showTip('<div class=\"tip\" id=\"loading\">'+data+'</div>');\r\n    \t   jQuery(\"#\"+RUN_ID+\"_a2\").remove();\r\n    \t   jQuery(\"#\"+RUN_ID+\"_a3\").remove();\r\n    \t   jQuery(\"#\"+RUN_ID+\" :nth-child(6)\").html(\"<font color=red>执行中</font>\");\r\n    });\r\n  }\r\n}\r\nfunction focus_dom(RUN_ID,OP)\r\n{\r\n  var obj=document.getElementById(RUN_ID+\"_a1\");\r\n  if(OP)\r\n  {\r\n    obj.innerHTML=\"取消关注\";\r\n    obj.href=\"javascript:focus_run(\"+RUN_ID+\",0);\";\r\n  }\r\n  else\r\n  {\r\n    obj.innerHTML=\"关注\";\r\n    obj.href=\"javascript:focus_run(\"+RUN_ID+\",1);\";\r\n  }\r\n}\r\nfunction focus_run(RUN_ID,OP)\r\n{   \r\n\tvar OP_DESC=OP==1?\"关注\":\"取消关注\";\r\n  var msg=\"确认要\"+OP_DESC+\"此工作么？\";\r\n  if(window.confirm(msg))\r\n  {\r\n    jQuery.get(\"../list/focus.php\",{\"RUN_ID\":RUN_ID,\"OP\":OP},function(data)\r\n     {\r\n    \t showTip('<div class=\"tip\" id=\"loading\">'+data+'</div>');\r\n       focus_dom(RUN_ID,OP);\r\n     });\r\n  }\r\n}\r\n\r\nfunction end_run()\r\n{\r\n  msg=\"确认要强制结束所选工作么？\";\r\n  if(window.confirm(msg))\r\n  {\r\n\t   var run_str=get_run_str();\r\n\t   if(run_str==\"\")\r\n\t   {\r\n        alert(\"要结束工作，请至少选择其中一项。\");\r\n        return;\r\n     }\r\n     jQuery.get(\"end.php\",{\"RUN_ID_STR\":run_str},function(data)\r\n       {\r\n    \t  showTip('<div class=\"tip\" id=\"loading\">'+data+'</div>');\r\n    \t  var tmp=run_str.split(\",\");\r\n        for(var i=0;i<tmp.length;i++)\r\n        \tjQuery(\"#\"+tmp[i]+\" :nth-child(6)\").html(\"已结束\");\r\n           \r\n    \t });\r\n  }\r\n}\r\n\r\nfunction export_run_sel()\r\n{\r\n\tvar run_str=get_run_str();\r\n  if(run_str==\"\")\r\n  {\r\n     alert(\"要导出工作，请至少选择其中一项。\");\r\n     return;\r\n  }\r\n  document.form1.action=\"excel_data.php\";\r\n  document.form1.RUN_ID_STR.value=run_str;\r\n  document.form1.submit();\r\n}\r\nfunction zip_run_sel()\r\n{\r\n\tvar run_str=get_run_str();\r\n\tif(run_str==\"\")\r\n   {\r\n      alert(\"要导出工作，请至少选择其中一项。\");\r\n      return;\r\n   }\r\n   document.form1.action=\"export_zip.php\";\r\n   document.form1.RUN_ID_STR.value=run_str;\r\n   document.form1.submit();\r\n}\r\n\r\n\r\nfunction export_list_view()\r\n{\r\n\tvar run_str=get_run_str();\r\n\tif(run_str==\"\")\r\n  {\r\n     alert(\"要导出工作，请至少选择其中一项。\");\r\n     return;\r\n  }\r\n  document.form1.action=\"excel_list_view.php\";\r\n  document.form1.RUN_ID_STR.value=run_str;\r\n  document.form1.LIST_VIEW_STR.value=LIST_VIEW.value;\r\n  document.form1.submit();\r\n}\r\n\r\nfunction call_back(RUN_ID,PRCS_ID,FLOW_PRCS)\r\n{\r\n  msg=\"下一步骤尚未接收时可收回至本步骤重新办理，确认要收回么？\";\r\n  if(window.confirm(msg))\r\n  {\r\n    var url=\"../list/call_back.php?FLOW_ID=";
echo $FLOW_ID;
echo "&MENU_FLAG=";
echo $MENU_FLAG;
echo "&RUN_ID=\"+RUN_ID+\"&PRCS_ID=\"+PRCS_ID+\"&FLOW_PRCS=\"+FLOW_PRCS;\r\n    jQuery.get(url,{},function(data){\r\n    \tif(data==1)\r\n    \t   showTip('<div class=\"tip\" id=\"loading\">您没有权限！</div>');\r\n    \telse if(data==2)\r\n    \t\t showTip('<div class=\"tip\" id=\"loading\">对方已接收，不能收回</div>');\r\n      else\r\n      {\r\n    \t  showTip('<div class=\"tip\" id=\"loading\">工作已回收</div>');\r\n    \t  jQuery(\"#\"+RUN_ID).remove();\r\n       }\r\n    });\r\n  }\r\n}\r\n\r\nfunction restore_run(RUN_ID)\r\n{\r\n  msg=\"确认要将此工作恢复到执行中么？\";\r\n  if(window.confirm(msg))\r\n  {\r\n    var url=\"restore.php?RUN_ID=\"+RUN_ID;\r\n    jQuery.get(url,{},function(data){\r\n    \t   showTip('<div class=\"tip\" id=\"loading\">'+data+'</div>');\r\n    \t   jQuery(\"#\"+RUN_ID+\"_a2\").remove();\r\n    \t   jQuery(\"#\"+RUN_ID+\"_a3\").remove();\r\n    \t   jQuery(\"#\"+RUN_ID+\" :nth-child(6)\").html(\"<font color=red>执行中</font>\");\r\n    });\r\n  }\r\n}\r\n\r\nfunction others(FLOW_ID,RUN_ID,PRCS_ID,FLOW_PRCS,FLOW_TYPE)\r\n{\r\n\tvar page;\r\n\tif(FLOW_TYPE==1)\r\n\t   page=\"others\";\r\n\telse\r\n\t\t page=\"others_free\";\t\t \r\n  myleft=(screen.availWidth-700)/2;\r\n  mytop=(screen.availHeight-450)/2;\r\n  window.open(\"../list/others/\"+page+\".php?RUN_ID=\"+RUN_ID+\"&FLOW_ID=\"+FLOW_ID+\"&PRCS_ID=\"+PRCS_ID+\"&FLOW_PRCS=\"+FLOW_PRCS,\"others\",\"status=0,toolbar=no,menubar=no,width=700,height=450,location=no,scrollbars=yes,resizable=no,left=\"+myleft+\",top=\"+mytop);\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" style=\"position:realtive;\" topmargin=\"5\" leftmargin=0  onload=\"SortTable('flow_table')\">\r\n<img src=\"/images/menu/infofind.gif\" align=\"absmiddle\"><span class=\"big3\"> 工作查询结果 ";
echo $FLOW_NAME;
echo "</span>\r\n";
if ( $FLOW_ID != "" )
{
	$query = "SELECT FLOW_NAME from FLOW_TYPE WHERE FLOW_ID='".$FLOW_ID."'";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$FLOW_NAME = $ROW['FLOW_NAME'];
	}
	$FLOW_ID_GLOBAL = 1;
}
$query = "SELECT * from FLOW_TYPE,FLOW_RUN WHERE FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID and FLOW_RUN.DEL_FLAG=0";
if ( $FLOW_ID_GLOBAL )
{
	$query_add .= " and FLOW_TYPE.FLOW_ID='".$FLOW_ID."'";
}
if ( $RUN_ID != "" )
{
	$query_add .= " and FLOW_RUN.RUN_ID='".$RUN_ID."'";
}
if ( $RUN_NAME != "" )
{
	$FIELDVALUE = $RUN_NAME;
	$WHERE_STR = " and RUN_NAME";
	switch ( $RUN_NAME_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."'";
		break;
		$WHERE_STR .= " like '%".$FIELDVALUE."%'";
	}
	$query_add .= $WHERE_STR;
}
if ( $ATTACHMENT_NAME != "" )
{
	$query_add .= " and ATTACHMENT_NAME like '%".$ATTACHMENT_NAME."%'";
}
$query .= $query_add;
if ( !( $FLOW_QUERY_TYPE == "ALL" ) && $LOGIN_USER_PRIV != 1 || $FLOW_QUERY_TYPE == "2" )
{
	$query_my = "select FLOW_RUN.RUN_ID from FLOW_TYPE,FLOW_RUN,FLOW_RUN_PRCS where FLOW_RUN.FLOW_ID=FLOW_TYPE.FLOW_ID AND FLOW_RUN.RUN_ID=FLOW_RUN_PRCS.RUN_ID AND USER_ID='".$LOGIN_USER_ID."' and PRCS_FLAG<>5";
	$query_my .= $query_add." GROUP BY FLOW_RUN.RUN_ID";
	$cursor = exequery( $connection, $query_my );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$MY_RUN_ID .= $ROW['RUN_ID'].",";
	}
	if ( $MY_RUN_ID != "" )
	{
		$MY_RUN_ID = substr( $MY_RUN_ID, 0, -1 );
	}
	else
	{
		$MY_RUN_ID = "0";
	}
}
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 )
{
	$query .= " and (FLOW_RUN.RUN_ID in (".$MY_RUN_ID.") or MANAGE_USER like '%,{$LOGIN_USER_ID},%' or  MANAGE_USER like '{$LOGIN_USER_ID},%' or QUERY_USER like '%,{$LOGIN_USER_ID},%' or QUERY_USER like '{$LOGIN_USER_ID},%')";
}
else if ( $FLOW_QUERY_TYPE == "1" )
{
	$BEGIN_USER = $LOGIN_USER_ID;
}
else if ( $FLOW_QUERY_TYPE == "2" )
{
	$query .= " and FLOW_RUN.RUN_ID in (".$MY_RUN_ID.")";
}
else if ( $FLOW_QUERY_TYPE == "3" && $LOGIN_USER_PRIV != 1 )
{
	$query .= " and (MANAGE_USER like '%,".$LOGIN_USER_ID.",%' or  MANAGE_USER like '{$LOGIN_USER_ID},%' or QUERY_USER like '%,{$LOGIN_USER_ID},%' or QUERY_USER like '{$LOGIN_USER_ID},%')";
}
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 )
	{
		$query .= " and (MANAGE_USER like '%,".$LOGIN_USER_ID.",%' or  MANAGE_USER like '{$LOGIN_USER_ID},%' or QUERY_USER like '%,{$LOGIN_USER_ID},%' or QUERY_USER like '{$LOGIN_USER_ID},%')";
	}
	$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."'";
}
$query .= " order by FLOW_RUN.RUN_ID desc";
$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'];
	$FLOW_ID = $ROW['FLOW_ID'];
	$FLOW_NAME = $ROW['FLOW_NAME'];
	$FLOW_TYPE = $ROW['FLOW_TYPE'];
	$MANAGE_USER = $ROW['MANAGE_USER'];
	$QUERY_USER = $ROW['QUERY_USER'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$COMMENT_PRIV = $ROW['COMMENT_PRIV'];
	$FOCUS_USER = $ROW['FOCUS_USER'];
	$END_TIME = $ROW['END_TIME'];
	$EDIT_PRIV = $ROW['EDIT_PRIV'];
	$NOT_FOUND = 0;
	$I = 1;
	for ( ;	$I <= $ITEM_ID_MAX;	++$I	)
	{
		$STR = "DATA_".$I;
		$FIELDVALUE = $$STR;
		$STR = "RELATION_".$I;
		$RELATION = $$STR;
		if ( $FIELDVALUE != "" && !( $FIELDVALUE != "SELECT_ALL_VALUE" ) || !( $RELATION == 10 ) )
		{
			continue;
		}
		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 :
			if ( is_numeric( $FIELDVALUE ) )
			{
				$WHERE_STR .= ">".$FIELDVALUE."";
			}
			else
			{
				$WHERE_STR .= ">'".$FIELDVALUE."'";
			}
			break;
		case 3 :
			if ( is_numeric( $FIELDVALUE ) )
			{
				$WHERE_STR .= "<".$FIELDVALUE."";
			}
			else
			{
				$WHERE_STR .= "<'".$FIELDVALUE."'";
			}
			break;
		case 4 :
			if ( is_numeric( $FIELDVALUE ) )
			{
				$WHERE_STR .= ">=".$FIELDVALUE."";
			}
			else
			{
				$WHERE_STR .= ">='".$FIELDVALUE."'";
			}
			break;
		case 5 :
			if ( is_numeric( $FIELDVALUE ) )
			{
				$WHERE_STR .= "<=".$FIELDVALUE."";
			}
			else
			{
				$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."'";
			break;
		case 10 :
			$WHERE_STR .= "=''";
		}
		$query1 = "select 1 from FLOW_RUN_DATA".$WHERE_STR." limit 1";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			continue;
		}
12 下一页
💿 文件大小 17584 K
👤 上传用户 Rosa_
📂 所属分类 OA系统
🏷️ 相关标签

#2008 #Anywhere #20081216 #Office
⌨️ 快捷键说明

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