query.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

						$ELEMENT_OUT .= "<option value=\"".$USER_ID."\"";
						$ELEMENT_OUT .= ">".$USER_NAME."</option>\n";
					} while ( 1 );
				case "SYS_LIST_PRIV" :
					do
					{
						$query_auto = "SELECT * from USER_PRIV order by PRIV_NO";
						$cursor_auto = exequery( $connection, $query_auto );
						if ( !( $ROW = mysql_fetch_array( $cursor_auto ) ) )
						{
							break;
						}
						$USER_PRIV = $ROW['USER_PRIV'];
						$PRIV_NAME = $ROW['PRIV_NAME'];
						$ELEMENT_OUT .= "<option value=\"".$USER_PRIV."\"";
						$ELEMENT_OUT .= ">".$PRIV_NAME."</option>\n";
					} while ( 1 );
				case "SYS_LIST_SQL" :
					$EDATASRC = get_attr( $ELEMENT, "DATASRC" );
					$EDATASRC = str_replace( "`", "'", $EDATASRC );
					$EDATASRC = str_replace( "&#13;&#10;", " ", $EDATASRC );
					$EDATASRC = str_replace( "[SYS_USER_ID]", $LOGIN_USER_ID, $EDATASRC );
					$EDATASRC = str_replace( "[SYS_DEPT_ID]", $LOGIN_DEPT_ID, $EDATASRC );
					$EDATASRC = str_replace( "[SYS_PRIV_ID]", $LOGIN_USER_PRIV, $EDATASRC );
					$cursor_SYS_SQL = exequery( $connection, $EDATASRC );
					$AUTO_VALUE_SQL_COUNT = 0;
					while ( $ROW = mysql_fetch_array( $cursor_SYS_SQL ) )
					{
						$AUTO_VALUE_SQL = $ROW[0];
						$AUTO_VALUE_SQL = strip_tags( $AUTO_VALUE_SQL );
						++$AUTO_VALUE_SQL_COUNT;
						$ELEMENT_OUT .= "<option value=\"".$AUTO_VALUE_SQL."\"";
						$ELEMENT_OUT .= ">".$AUTO_VALUE_SQL."</option>\n";
					}
					if ( !( $AUTO_VALUE_SQL_COUNT == 0 ) || !( 50 < $AUTO_VALUE_SQL_COUNT ) )
					{
						break;
					}
					$ELEMENT_OUT = "<INPUT type=text size=30 class=SmallInput>";
				}
				if ( !( $EDATAFLD == "SYS_LIST_SQL" ) && !( $AUTO_VALUE_SQL_COUNT == 0 ) )
				{
					$ELEMENT_OUT .= "</SELECT>";
				}
			}
		}
		else if ( $ECLASS == "SIGN" )
		{
			$TITLE_ARRAY[$ITEM_ID + 4] = "";
		}
		else if ( $ENAME == "TEXTAREA" || $ECLASS == "LIST_VIEW" )
		{
			$ELEMENT_OUT = "<INPUT type=text size=30 class=SmallInput>";
			$ENAME = "INPUT";
			if ( $ECLASS == "LIST_VIEW" )
			{
				$LV_TITLE = get_attr( $ELEMENT, "LV_TITLE" );
				$LIST_VIEW .= $ETITLE."~".$ITEM_ID."~".$LV_TITLE."^";
			}
		}
	}
	if ( $EDATAFLD == "SYS_LIST_SQL" && $AUTO_VALUE_SQL_COUNT == 0 )
	{
		$ENAME = "INPUT";
	}
	$ELEMENT_OUT = str_replace( "<".$ENAME, "<".$ENAME." name='DATA_{$ITEM_ID}'", $ELEMENT_OUT );
	if ( $I % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	$TITLE_ARRAY[$ITEM_ID + 4] = $ETITLE;
	if ( !( $QUERY_ITEM == "" ) || !find_id( $QUERY_ITEM, $ETITLE ) )
	{
		echo "    <tr class=\"";
		echo $TableLine;
		echo "\" style=\"display:";
		if ( $QUERY_ITEM == "" )
		{
			echo "none";
		}
		echo "\">\r\n      <td>";
		echo $ETITLE;
		echo "：</td>\r\n      <td nowrap>\r\n       <select name=\"RELATION_";
		echo $ITEM_ID;
		echo "\" class=\"SmallSelect\" onchange=\"hide_item(this);\">\r\n        <option value=\"1\">等于</option>\r\n";
		if ( $ENAME != "SELECT" || $EDATAFLD == "SYS_LIST_SQL" && $AUTO_VALUE_SQL_COUNT == 0 )
		{
			echo "        <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        <option value=\"10\">为空</option>\r\n";
		}
		echo "       </select>\r\n      </td>\r\n      <td>\r\n        ";
		echo $ELEMENT_OUT;
		echo "      </td>\r\n    </tr>\r\n";
	}
}
echo "    <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=\"GROUP_FLD\" class=\"SmallSelect\">\r\n";
$TITLE_ARRAY[0] = "流水号";
$TITLE_ARRAY[1] = "名称/文号";
$TITLE_ARRAY[2] = "流程状态";
$TITLE_ARRAY[3] = "流程开始日期";
$TITLE_ARRAY[4] = "流程开始时间";
$ARRAY_COUNT = sizeof( $TITLE_ARRAY );
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	if ( $TITLE_ARRAY[$I] )
	{
		echo "   <option value=\"";
		echo $I;
		echo "\">";
		echo $TITLE_ARRAY[$I];
		echo "</option>\r\n";
	}
}
echo "        </select>&nbsp;\r\n        <select name=\"GROUP_SORT\" class=\"SmallSelect\">\r\n          <option value=\"ASC\">升序</option>\r\n          <option value=\"DESC\">降序</option>\r\n        </select>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableContent\" valign=\"top\"><br><b>统计字段：</b><br><br>如需进行合计<br>请在统计字段中选中<br>按住CTRL键可多选</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        <table width=\"250\" class=\"TableBlock\">\r\n          <tr class=\"TableData\">\r\n            <td align=\"center\"><b>显示以下字段作为表格列</b>\r\n            </td>\r\n            <td align=\"center\">&nbsp;</td>\r\n            <td align=\"center\" valign=\"top\"><b>不显示以下字段</b></td>\r\n          </tr>\r\n          <tr>\r\n            <td valign=\"top\" align=\"center\" bgcolor=\"#CCCCCC\">\r\n            <select  name=\"SUM_FLD_LIST\" ondblclick=\"func_delete();\" MULTIPLE style=\"width:150;height:150\">\r\n            ";
$I = 5;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	if ( $TITLE_ARRAY[$I] )
	{
		echo "               \t<option value=\"";
		echo $I;
		echo "\">";
		echo $TITLE_ARRAY[$I];
		echo "</option>\r\n            ";
	}
}
echo "            </select>\r\n            <input type=\"button\" value=\"全 选\" onclick=\"select_all1(1);\" class=\"SmallInput\">\r\n            <input type=\"button\" value=\"取消选择\" onclick=\"select_all1(0);\" class=\"SmallInput\">\r\n            </td>\r\n\r\n            <td align=\"center\" bgcolor=\"#999999\">\r\n              <input type=\"button\" class=\"SmallInput\" value=\" ← \" onclick=\"func_insert();\">\r\n              <br><br>\r\n              <input type=\"button\" class=\"SmallInput\" value=\" → \" onclick=\"func_delete();\">\r\n            </td>\r\n\r\n            <td align=\"center\" valign=\"top\" bgcolor=\"#CCCCCC\">\r\n            <select  name=\"STANDBY_FLD_LIST\" ondblclick=\"func_insert();\" MULTIPLE style=\"width:150;height:150\">\r\n            </select>\r\n            <input type=\"button\" value=\"全 选\" onclick=\"select_all2();\" class=\"SmallInput\">\r\n            </td>\r\n          </tr>\r\n        </table>\r\n      </td>\r\n    </tr>\r\n\r\n\r\n    <tr align=\"center\" class=\"TableFooter\">\r\n      <td colspan=\"3\" nowrap>\r\n        <input type=\"hidden\" name=\"OP\">\r\n        <input type=\"hidden\" value=\"";
echo $ITEM_ID_MAX;
echo "\" name=\"ITEM_ID_MAX\">\r\n        <input type=\"hidden\" value=\"";
echo $LIST_VIEW;
echo "\" name=\"LIST_VIEW\">\r\n        <input type=\"hidden\" value=\"";
echo $DISP_FLD;
echo "\" name=\"DISP_FLD\">\r\n        <input type=\"hidden\" value=\"";
echo $SUM_FLD;
echo "\" name=\"SUM_FLD\">\r\n        <input type=\"hidden\" value=\"";
echo $RUN_ID;
echo "\" name=\"RUN_ID\">\r\n        <input type=\"hidden\" value=\"";
echo $MENU_FLAG;
echo "\" name=\"MENU_FLAG\">\r\n        <input type=\"submit\" value=\"查询列表\" class=\"BigButton\" onclick=\"my_submit1()\">&nbsp;&nbsp;\r\n        <input type=\"button\" value=\"HTML统计报表\" class=\"BigButton\" onclick=\"my_submit2(1);\">&nbsp;&nbsp;\r\n        <input type=\"button\" value=\"EXCEL统计报表\" class=\"BigButton\" onclick=\"my_submit2(2);\">&nbsp;&nbsp;\r\n        <input type=\"button\" value=\"返 回\" class=\"BigButton\" name=\"back1\" onClick=\"location='flow_list.php'\">\r\n      </td>\r\n    </tr>\r\n  </form>\r\n</table>\r\n\r\n</body>\r\n</html>";
?>