📄 query.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_org.php" );
include_once( "inc/utility_html.php" );
$YEAR_DATE = date( "Y", time( ) )."-01-01";
$LAST_YEAR_DATE1 = date( "Y", strtotime( "last year" ) )."-01-01";
$LAST_YEAR_DATE2 = date( "Y", strtotime( "last year" ) )."-12-31";
$MONTH_DATE1 = date( "Y-m", time( ) )."-01";
$MONTH_DATE2 = date( "Y-m", time( ) )."-".date( "t" );
$LAST_MONTH_DATE1 = date( "Y-m", strtotime( "last month" ) )."-01";
$LAST_MONTH_DATE2 = date( "Y-m", strtotime( $LAST_MONTH_DATE1 ) )."-".date( "t", strtotime( "last month" ) );
$WEEK_DATE1 = date( "Y-m-d", strtotime( "-".date( "w", time( ) )."days" ) );
$WEEK_DATE2 = date( "Y-m-d", strtotime( "+6 days", strtotime( $WEEK_DATE1 ) ) );
$LAST_WEEK1 = date( "Y-m-d", strtotime( "-".date( "w", strtotime( "last week" ) )."days", strtotime( "last week" ) ) );
$LAST_WEEK2 = date( "Y-m-d", strtotime( "+6 days", strtotime( $LAST_WEEK1 ) ) );
$CUR_DATE = date( "Y-m-d", time( ) );
$YESTODAY = date( "Y-m-d", strtotime( "-1 day" ) );
$query = "SELECT * from FLOW_TYPE where FLOW_ID=".$FLOW_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$FLOW_ID = $ROW['FLOW_ID'];
	$FLOW_NAME = $ROW['FLOW_NAME'];
	$FORM_ID = $ROW['FORM_ID'];
	$QUERY_ITEM = $ROW['QUERY_ITEM'];
}
echo "\r\n<html>\r\n<head>\r\n<title>工作流高级查询</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"><script src=\"/inc/js/module.js\"></script>\r\n<script>\r\n\r\nfunction my_submit1()\r\n{\r\n   document.form1.action=\"search.php\";\r\n   document.form1.target=\"_self\";\r\n   document.form1.submit();\r\n}\r\nfunction date_change(opt)\r\n{\r\n\tvar prcs_date1=document.form1.PRCS_DATE1;\r\n\tvar prcs_date2=document.form1.PRCS_DATE2;\r\n\tswitch(opt)\r\n\t{\r\n\t\tcase '1':\r\n\t\t\tprcs_date1.value=\"";
echo $CUR_DATE;
echo "\";\r\n\t\t\tprcs_date2.value=\"";
echo $CUR_DATE;
echo "\";\r\n\t\t\tbreak;\r\n\t\tcase '2':\r\n\t\t\tprcs_date1.value=\"";
echo $YESTODAY;
echo "\";\r\n\t\t\tprcs_date2.value=\"";
echo $YESTODAY;
echo "\";\r\n\t\t\tbreak;\r\n\t\tcase '3':\r\n\t\t\tprcs_date1.value=\"";
echo $WEEK_DATE1;
echo "\";\r\n\t\t\tprcs_date2.value=\"";
echo $WEEK_DATE2;
echo "\";\r\n\t\t\tbreak;\r\n\t\tcase '4':\r\n\t\t\tprcs_date1.value=\"";
echo $LAST_WEEK1;
echo "\";\r\n\t\t\tprcs_date2.value=\"";
echo $LAST_WEEK2;
echo "\";\r\n\t\t\tbreak;\r\n\t\tcase '5':\r\n\t\t\tprcs_date1.value=\"";
echo $MONTH_DATE1;
echo "\";\r\n\t\t\tprcs_date2.value=\"";
echo $MONTH_DATE2;
echo "\";\r\n\t\t\tbreak;\r\n\t\tcase '6':\r\n\t\t\tprcs_date1.value=\"";
echo $LAST_MONTH_DATE1;
echo "\";\r\n\t\t\tprcs_date2.value=\"";
echo $LAST_MONTH_DATE2;
echo "\";\r\n\t\t\tbreak;\r\n\t}\r\n}\r\n\r\n\r\nfunction empty_date()\r\n{\r\n   document.form1.PRCS_DATE1.value=\"\";\r\n   document.form1.PRCS_DATE2.value=\"\";\r\n}\r\n\r\nfunction my_submit2(OP)\r\n{\r\n  document.form1.SUM_FLD.value=\"\";\r\n  document.form1.DISP_FLD.value=\"\";\r\n  for (i=0; i<document.form1.SUM_FLD_LIST.options.length; i++)\r\n  {\r\n    option_value=document.form1.SUM_FLD_LIST.options(i).value;\r\n    document.form1.DISP_FLD.value+=option_value+\",\";\r\n    if(document.form1.SUM_FLD_LIST.options(i).selected)\r\n    {\r\n      document.form1.SUM_FLD.value+=option_value+\",\";\r\n    }\r\n  }//for\r\n\r\n  document.form1.OP.value=OP;\r\n  document.form1.action=\"flow_report.php\";\r\n  if(OP==1)\r\n    document.form1.target=\"_blank\";\r\n  else\r\n  \tdocument.form1.target=\"_self\";\r\n  document.form1.submit();\r\n}\r\n\r\nfunction select_all1(flag)\r\n{\r\n  for (i=0; i<document.form1.SUM_FLD_LIST.options.length; i++)\r\n  {\r\n    document.form1.SUM_FLD_LIST.options(i).selected=flag;\r\n  }//for\r\n}\r\nfunction select_all2()\r\n{\r\n  for (i=0; i<document.form1.STANDBY_FLD_LIST.options.length; i++)\r\n  {\r\n    document.form1.STANDBY_FLD_LIST.options(i).selected=1;\r\n  }//for\r\n\r\n}\r\n\r\n";
if ( $QUERY_ITEM == "" )
{
	echo "data_hide=1;\r\n";
}
else
{
	echo "data_hide=0;\r\n";
}
echo "\r\nfunction data_show_hide()\r\n{\r\n\tdata_hide=1-data_hide;\r\n\tfor (step_i=0; step_i<document.all.length; step_i++)\r\n  {\r\n    if(document.all(step_i).className==\"TableLine1\"||document.all(step_i).className==\"TableLine2\")\r\n    {\r\n       if(data_hide)\r\n          document.all(step_i).style.display=\"none\";\r\n       else\r\n       \t  document.all(step_i).style.display=\"\";\r\n    }\r\n  }\r\n}\r\n\r\nfunction set_user()\r\n{\r\n\tif(document.form1.FLOW_QUERY_TYPE.value==\"1\")\r\n\t{\r\n\t   document.form1.TO_ID.value=\"";
echo $LOGIN_USER_ID;
echo "\";\r\n\t   document.form1.TO_NAME.value=\"";
echo $LOGIN_USER_NAME;
echo "\";\r\n\t}\r\n}\r\n\r\nfunction func_find(select_obj,option_text)\r\n{\r\n pos=option_text.indexOf(\"] \")+1;\r\n option_text=option_text.substr(0,pos);\r\n\r\n for (j=0; j<select_obj.options.length; j++)\r\n {\r\n   str=select_obj.options(j).text;\r\n   if(str.indexOf(option_text)>=0)\r\n      return j;\r\n }//for\r\n\r\n return j;\r\n}\r\n\r\nfunction func_insert()\r\n{\r\n for (i=document.form1.STANDBY_FLD_LIST.options.length-1; i>=0; i--)\r\n {\r\n   if(document.form1.STANDBY_FLD_LIST.options(i).selected)\r\n   {\r\n     option_text=document.form1.STANDBY_FLD_LIST.options(i).text;\r\n     option_value=document.form1.STANDBY_FLD_LIST.options(i).value;\r\n     option_style_color=document.form1.STANDBY_FLD_LIST.options(i).style.color;\r\n\r\n     var my_option = document.createElement(\"OPTION\");\r\n     my_option.text=option_text;\r\n     my_option.value=option_value;\r\n     my_option.style.color=option_style_color;\r\n\r\n     pos=func_find(document.form1.SUM_FLD_LIST,option_text);\r\n     document.form1.SUM_FLD_LIST.add(my_option,pos);\r\n     document.form1.STANDBY_FLD_LIST.remove(i);\r\n  }\r\n }//for\r\n}\r\n\r\nfunction func_delete()\r\n{\r\n for (i=document.form1.SUM_FLD_LIST.options.length-1; i>=0; i--)\r\n {\r\n   option_text=document.form1.SUM_FLD_LIST.options(i).text;\r\n   option_value=document.form1.SUM_FLD_LIST.options(i).value;\r\n   if(document.form1.SUM_FLD_LIST.options(i).selected)\r\n   {\r\n     if(document.form1.GROUP_FLD.value==option_value)\r\n     {\r\n       alert(\"分组字段必须统计！\");\r\n       return;\r\n     }\r\n     var my_option = document.createElement(\"OPTION\");\r\n     my_option.text=option_text;\r\n     my_option.value=option_value;\r\n\r\n     pos=func_find(document.form1.STANDBY_FLD_LIST,option_text);\r\n     document.form1.STANDBY_FLD_LIST.add(my_option,pos);\r\n     document.form1.SUM_FLD_LIST.remove(i);\r\n  }\r\n }//for\r\n}\r\n\r\nfunction hide_item(obj)\r\n{\r\n\tvar obj1=obj.parentNode.nextSibling.firstChild;\r\n\tif(obj1)\r\n\t{\r\n\t  if(obj.value==10)\r\n\t     obj1.style.display=\"none\";\r\n\t  else\r\n\t  \t obj1.style.display=\"\";\r\n\t}  \t \r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/green_arrow.gif\" align=\"absmiddle\"><span class=\"big3\"> 工作流高级查询 - 请指定查询条件</span><br>\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n<br>\r\n<table border=\"0\" width=\"90%\" align=\"center\" class=\"TableList\">\r\n  <form action=\"search.php\" method=\"post\" name=\"form1\">\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" height=25 colspan=\"3\"> <div style=\"float:left;font-weight:bold\"><img src=\"/images/green_arrow.gif\" align=\"absmiddle\"> 工作流程基本属性</div></td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableContent\"><b>流程名称：</b></td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        <select name=\"FLOW_ID\" class=\"SmallStatic\">\r\n          <option value=\"";
echo $FLOW_ID;
echo "\">";
echo $FLOW_NAME;
echo "</option>\r\n        </select>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableContent\"><b>工作流状态：</b></td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        <select name=\"FLOW_STATUS\" class=\"SmallSelect\">\r\n          <option value=\"ALL\">所有</option>\r\n          <option value=\"1\">已结束</option>\r\n          <option value=\"0\">执行中</option>\r\n        </select>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableContent\"><b>查询范围：</b></td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        <select name=\"FLOW_QUERY_TYPE\" class=\"SmallSelect\" onchange=\"set_user();\">\r\n          <option value=\"ALL\">所有</option>\r\n          <option value=\"1\">我发起的</option>\r\n          <option value=\"2\">我经办的</option>\r\n          <option value=\"3\" >我管理的</option>\r\n        </select>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableContent\"><b>流程发起人：</b></td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n         <input type=\"text\" name=\"BEGIN_NAME\" size=\"10\" class=\"SmallInput\" readonly>&nbsp;\r\n         <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectUserSingle('','BEGIN_USER', 'BEGIN_NAME')\" title=\"指定代办人\">选择</a>\r\n         <input type=\"hidden\" name=\"BEGIN_USER\" value=\"\">\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableContent\"><b>名称/文号：</b></td>\r\n      <td nowrap class=\"TableData\"  width=\"100px\">\r\n       <select name=\"RUN_NAME_RELATION\" class=\"SmallSelect\">\r\n        <option value=\"1\">等于</option>\r\n        <option value=\"2\">大于</option>\r\n        <option value=\"3\">小于</option>\r\n        <option value=\"4\">大于等于</option>\r\n        <option value=\"5\">小于等于</option>\r\n        <option value=\"6\">不等于</option>\r\n        <option value=\"7\">开始为</option>\r\n        <option value=\"8\" selected>包含</option>\r\n        <option value=\"9\">结束为</option>\r\n       </select>\r\n      </td>\r\n      <td class=\"TableData\">\r\n        <input type=\"text\" name=\"RUN_NAME\" size=\"30\" maxlength=\"100\" class=\"SmallInput\">\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableContent\"><b>流程开始日期范围：</b></td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        从 <input type=\"text\" name=\"PRCS_DATE1\" size=\"10\" class=\"SmallInput\" value=\"";
echo $YEAR_DATE;
echo "\"><img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" align=absmiddle border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.PRCS_DATE1');\">\r\n        至 <input type=\"text\" name=\"PRCS_DATE2\" size=\"10\" class=\"SmallInput\"><img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" align=absmiddle border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.PRCS_DATE2');\"><a href=\"javascript:empty_date();\" class=\"orgClear\" onclick=\"empty_date();\">清空</a>\r\n        &nbsp;<select name=\"DATE_RANGE\" class=\"SmallSelect\" onchange=\"date_change(this.value)\">\r\n        \t<option value=\"0\">快捷选择</option>\r\n        \t<option value=\"1\">今日</option>\r\n        \t<option value=\"2\">昨日</option>\r\n        \t<option value=\"3\">本周</option>\r\n        \t<option value=\"4\">上周</option>\r\n        \t<option value=\"5\">本月</option>\r\n        \t<option value=\"6\">上月</option>\r\n        </select>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableContent\"><b>公共附件名称：</b></td>\r\n      <td nowrap class=\"TableData\">包含</td>\r\n      <td class=\"TableData\">\r\n        <input type=\"text\" name=\"ATTACHMENT_NAME\" size=\"30\" class=\"SmallInput\">\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" height=25 colspan=\"3\">\r\n        <div style=\"float:left;font-weight:bold\"><img src=\"/images/green_arrow.gif\" align=\"absmiddle\"> 表单数据条件 <a href=\"javascript:data_show_hide()\">显示/隐藏条件</a></div>\r\n      </td>\r\n    </tr>\r\n";
$query = "SELECT * from FLOW_FORM_TYPE WHERE FORM_ID=".$FORM_ID;
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$PRINT_MODEL = $ROW['PRINT_MODEL'];
}
$ELEMENT_ARRAY = html_element( $PRINT_MODEL );
$ITEM_ID_MAX = sizeof( $ELEMENT_ARRAY );
$ITEM_ID = 0;
$I = 0;
for ( ;	$I < $ITEM_ID_MAX;	++$I	)
{
	$ELEMENT = $ELEMENT_ARRAY[$I];
	$ENAME = get_attr( $ELEMENT, "NAME" );
	$EVALUE = get_attr( $ELEMENT, "VALUE" );
	$ETITLE = get_attr( $ELEMENT, "TITLE" );
	$ETITLE = str_replace( "<", "&lt", $ETITLE );
	$ETITLE = str_replace( ">", "&gt", $ETITLE );
	$ETITLE = stripslashes( $ETITLE );
	$ECLASS = get_attr( $ELEMENT, "CLASS" );
	if ( !( $ECLASS == "DATE" ) )
	{
		if ( $ECLASS == "USER" )
		{
			break;
		}
	}
	else
	{
		continue;
	}
	++$ITEM_ID;
	if ( $ENAME == "INPUT" )
	{
		if ( strstr( $ELEMENT, "type=checkbox" ) )
		{
			$ELEMENT_OUT = "<SELECT class=SmallSelect><option value='SELECT_ALL_VALUE'>所有</option><option value='CHECKBOX_ON'>是</option><option value='CHECKBOX_OFF'>否</option></SELECT>";
			$ENAME = "SELECT";
		}
		else
		{
			$ELEMENT_OUT = "<INPUT type=text size=30 class=SmallInput>";
		}
	}
	else
	{
		if ( $ENAME == "SELECT" )
		{
			if ( $ECLASS != "AUTO" )
			{
				$ELEMENT_OUT = "<SELECT class=SmallSelect><option value='SELECT_ALL_VALUE'>所有</option>".$EVALUE."</SELECT>";
				$ELEMENT_OUT = str_replace( " selected", "", $ELEMENT_OUT );
			}
			else
			{
				$EDATAFLD = get_attr( $ELEMENT, "DATAFLD" );
				$ELEMENT_OUT = "<SELECT class=SmallSelect><option value='SELECT_ALL_VALUE'>所有</option>";
				switch ( $EDATAFLD )
				{
				case "SYS_LIST_DEPT" :
					$ELEMENT_OUT .= my_dept_tree( 0, $ITEM_VALUE, 0 );
					break;
				case "SYS_LIST_USER" :
				case "SYS_LIST_PRCSUSER1" :
				case "SYS_LIST_PRCSUSER2" :
					do
					{
						$query_auto = "SELECT * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV order by PRIV_NO,USER_NO,USER_NAME";
						$cursor_auto = exequery( $connection, $query_auto );
						if ( !( $ROW = mysql_fetch_array( $cursor_auto ) ) )
						{
							break;
						}
						$USER_ID = $ROW['USER_ID'];
						$USER_NAME = $ROW['USER_NAME'];
12 下一页
⌨️ 快捷键说明

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