search_data.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

include_once( "inc/conn.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_html.php" );
$query = "SELECT * from FLOW_RUN fr,flow_type ft,flow_sort fs WHERE 1 ";
$query .= " AND fr.FLOW_ID=ft.FLOW_ID AND fs.ID=ft.FLOW_SORT ";
if ( $_REQUEST['FLOW_ID'] != "" )
{
	$query .= " AND  fr.FLOW_ID=".$_REQUEST['FLOW_ID'];
}
if ( $_REQUEST['FLOW_SORT'] != "" )
{
	$query .= " AND  fs.ID=".$_REQUEST['FLOW_SORT'];
}
if ( $RUN_NAME != "" )
{
	$WHERE_STR = " and fr.RUN_NAME ";
	$WHERE_STR .= " LIKE '%".$RUN_NAME."%'";
	$query .= $WHERE_STR;
}
if ( $RUN_SEQ != "" )
{
	$WHERE_STR = " and fr.RUN_SEQ ";
	$WHERE_STR .= " LIKE '%".$RUN_SEQ."%'";
	$query .= $WHERE_STR;
}
$query .= " order by fr.RUN_ID desc";
$cursor = exequery( $connection, $query );
$FLOW_COUNT = 0;
$flowct = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$RUN_ID = $ROW['RUN_ID'];
	$FLOW_ID = $ROW['FLOW_ID'];
	$RUN_NAME = $ROW['RUN_NAME'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	$PRCS_TIME = "";
	$query1 = "SELECT * from FLOW_RUN_PRCS WHERE RUN_ID={$RUN_ID} AND PRCS_ID=1";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$PRCS_TIME = $ROW['PRCS_TIME'];
		$USER_ID = $ROW['USER_ID'];
		$PRCS_DATE = strtok( $PRCS_TIME, " " );
		if ( $PRCS_DATE1 != "" && compare_date( $PRCS_DATE, $PRCS_DATE1 ) < 0 )
		{
		}
		else if ( $PRCS_DATE2 != "" && 0 < compare_date( $PRCS_DATE, $PRCS_DATE2 ) )
		{
		}
		else
		{
			if ( $CREATE_USER_ID != "" && $USER_ID != $CREATE_USER_ID )
			{
			}
			else
			{
				if ( $REPORT_TYPE == "year" && $TIME_YEAR != "" && $TIME_YEAR != date( "Y", strtotime( $PRCS_TIME ) ) )
				{
					continue;
				}
				if ( $REPORT_TYPE == "month" && $TIME_MONTH != "" )
				{
					if ( $TIME_YEAR != date( "Y", strtotime( $PRCS_TIME ) ) )
					{
					}
					else if ( $TIME_MONTH != date( "n", strtotime( $PRCS_TIME ) ) )
					{
						continue;
					}
				}
				if ( $REPORT_TYPE == "day" && $TIME_DAY != "" )
				{
					if ( $TIME_YEAR != date( "Y", strtotime( $PRCS_TIME ) ) )
					{
					}
					else if ( $TIME_MONTH != date( "n", strtotime( $PRCS_TIME ) ) )
					{
					}
					else if ( $TIME_DAY != date( "j", strtotime( $PRCS_TIME ) ) )
					{
						continue;
					}
				}
				if ( $REPORT_TYPE == "week" && $TIME_WEEK != "" && $TIME_WEEK != date( "W", strtotime( $PRCS_TIME ) ) )
				{
					continue;
				}
				if ( $PRCS_TIME == "0000-00-00 00:00:00" )
				{
					$PRCS_TIME = "";
				}
			}
		}
	}
	$query1 = "SELECT * from FLOW_RUN_PRCS WHERE RUN_ID={$RUN_ID} AND PRCS_FLAG<>'4'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$STATUS = "执行中";
		if ( $FLOW_STATUS == "1" )
		{
			continue;
		}
	}
	else
	{
		$STATUS = "已完成";
		if ( $FLOW_STATUS == "0" )
		{
		}
	}
	$NOT_FOUND = 0;
	$I = 1;
	for ( ;	$I <= $ITEM_ID_MAX;	++$I	)
	{
		$STR = "DATA_".$I;
		$FIELDVALUE = $$STR;
		if ( $FIELDVALUE != "" && $FIELDVALUE != "SELECT_ALL_VALUE" )
		{
			$STR = "RELATION_".$I;
			$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 ) ) )
			{
				$NOT_FOUND = 1;
				break;
			}
		}
	}
	if ( $NOT_FOUND == 1 )
	{
	}
	else
	{
		if ( $REPORT_TYPE == "year" )
		{
			$i = 1;
			for ( ;	$i <= 12;	++$i	)
			{
				if ( $i == date( "n", strtotime( $PRCS_TIME ) ) )
				{
					$arrayRunStr[$i] .= $RUN_ID.",";
				}
			}
		}
		if ( $REPORT_TYPE == "month" )
		{
			$mend = date( "t", strtotime( $TIME_YEAR."-".$TIME_MONTH."-01 00:00:00" ) );
			$i = 1;
			for ( ;	$i <= $mend;	++$i	)
			{
				if ( $i == date( "d", strtotime( $PRCS_TIME ) ) )
				{
					$arrayRunStr[$i] .= $RUN_ID.",";
				}
			}
		}
		if ( $REPORT_TYPE == "week" )
		{
			$i = 1;
			for ( ;	$i <= 7;	++$i	)
			{
				if ( $i == date( "w", strtotime( $PRCS_TIME ) + 1 ) )
				{
					$arrayRunStr[$i] .= $RUN_ID.",";
				}
			}
		}
		if ( $REPORT_TYPE == "day" )
		{
			$i = 1;
			for ( ;	$i <= 24;	++$i	)
			{
				if ( $i == date( "H", strtotime( $PRCS_TIME ) + 1 ) )
				{
					$arrayRunStr[$i] .= $RUN_ID.",";
				}
			}
		}
		++$FLOW_COUNT;
		++$flowct;
		$RUN_ID_STR .= $RUN_ID.",";
	}
}
$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID={$FLOW_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$FLOW_NAME = $ROW['FLOW_NAME'];
	$FORM_ID = $ROW['FORM_ID'];
}
$query = "SELECT * from FLOW_FORM_TYPE WHERE FORM_ID={$FORM_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	$FORM_NAME = $ROW['FORM_NAME'];
	$PRINT_MODEL = $ROW['PRINT_MODEL'];
}
$EXCEL_NAME = "流程：".$FLOW_NAME." - 数据报表";
$LETTER_STR = "\\,/,:,*,?,\",<,>,|";
$MY_ARRAY = explode( ",", $LETTER_STR );
$ARRAY_COUNT = sizeof( $MY_ARRAY );
if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
{
	--$ARRAY_COUNT;
}
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	$EXCEL_NAME = str_replace( $MY_ARRAY[$I], "", $EXCEL_NAME );
}
$ELEMENT_ARRAY = html_element( $PRINT_MODEL );
$ITEM_ID_MAX = sizeof( $ELEMENT_ARRAY );
$I = 0;
for ( ;	$I < $ITEM_ID_MAX;	++$I	)
{
	$ELEMENT = $ELEMENT_ARRAY[$I];
	$ETITLE = get_attr( $ELEMENT, "TITLE" );
	$ETITLE = str_replace( "<", "&lt", $ETITLE );
	$ETITLE = str_replace( ">", "&gt", $ETITLE );
	$ETITLE = stripslashes( $ETITLE );
	$arrayItemValTml[$I]['FIELD_NAME'] = $ETITLE;
}
$EXCEL_OUT .= "\n";
$M = 0;
for ( ;	$M < $ITEM_ID_MAX;	++$M	)
{
	$arrayData[$M]['FIELD_NAME'] = $arrayItemValTml[$M]['FIELD_NAME'];
	$arrayData[$M]['FIELD_VALUE'] = 0;
}
$MY_ARRAY = explode( ",", $RUN_ID_STR );
$ARRAY_COUNT = sizeof( $MY_ARRAY );
if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
{
	--$ARRAY_COUNT;
}
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	$query = "SELECT * from FLOW_RUN_DATA where RUN_ID={$MY_ARRAY[$I]} order by ITEM_ID";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$ITEM_ID = $ROW['ITEM_ID'];
		$ITEM_DATA = $ROW['ITEM_DATA'];
		$ITEM_DATA = str_replace( chr( 10 ), " ", $ITEM_DATA );
		$ITEM_DATA = str_replace( chr( 13 ), " ", $ITEM_DATA );
		$STR = "DATA_".$ITEM_ID;
		$$STR = $ITEM_DATA;
	}
	$ITEM_ID = 0;
	$J = 0;
	for ( ;	$J < $ITEM_ID_MAX;	++$J	)
	{
		$ELEMENT = $ELEMENT_ARRAY[$J];
		$ENAME = get_attr( $ELEMENT, "NAME" );
		$EVALUE = get_attr( $ELEMENT, "VALUE" );
		$ECLASS = get_attr( $ELEMENT, "CLASS" );
		if ( $ECLASS != "DATE" )
		{
			++$ITEM_ID;
		}
		$STR = "DATA_".$ITEM_ID;
		$ITEM_VALUE = $$STR;
		if ( is_numeric( $ITEM_VALUE ) == false )
		{
			$ITEM_VALUE = 0;
		}
		$arrayEtitle[$J] = $ITEM_VALUE + $arrayEtitle[$J];
		$arrayData[$J]['FIELD_NAME'] = $arrayItemValTml[$J]['FIELD_NAME'];
		$arrayData[$J]['FIELD_VALUE'] = $arrayEtitle[$J];
	}
}
unset( $arrayEtitle );
?>