address.inc

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

<?php

echo "<!---------------------------------分组------------------------------------------------->\r\n<table width=\"100%\" border=\"0\">\r\n<form name=\"form\">\r\n<tr><td align=\"right\">\r\n";
echo "<s";
echo "cript language=\"javascript\">\r\n<!--\r\nfunction handoption(){\r\nvar url=document.form.tite.options\r\n[document.form.tite.selectedIndex].value;\r\nwindow.location.href=\"../address?GROUP_ID=\"+url;\r\n\r\n//-->\r\n}\r\n</script>\r\n联系人分组：\r\n";
echo "<s";
echo "elect name=\"tite\" onchange=\"handoption()\">\r\n<option>选择分组</option>\r\n<option value=\"0\">默认</option>\r\n";
$query1 = "select * from ADDRESS_GROUP where USER_ID='{$LOGIN_USER_ID}' order by GROUP_NAME asc";
$cursor1 = exequery( $connection, $query1 );
$GROUP_COUNT = 1;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	++$GROUP_COUNT;
	$GROUP_ID1 = $ROW['GROUP_ID'];
	$GROUP_NAME1 = $ROW['GROUP_NAME'];
	echo "<option value=\"";
	echo $GROUP_ID1;
	echo "\">";
	echo $GROUP_NAME1;
	echo "</option>\r\n";
}
echo "</select>\r\n\r\n<!---------------------------------分组结束------------------------------------------------->\r\n\r\n<!--------------------------------- 索引 -------------------------------------------------->\r\n";
echo "<s";
echo "cript language=\"javascript\">\r\n<!--\r\nfunction handoption1(){\r\nvar url=document.form.tite1.options\r\n[document.form.tite1.selectedIndex].value;\r\n\r\nwindow.location.href=\"../address/idx_search.php?\"+url;\r\n\r\n//-->\r\n}\r\n</script>\r\n索引:";
echo "<s";
echo "elect name=\"tite1\" onchange=\"handoption1()\">\r\n<option>选择索引</option>\r\n";
include_once( "inc/mb.php" );
$i = ord( "A" );
for ( ;	$i <= ord( "Z" );	++$i	)
{
	$name[chr( $i )] = array( );
	$nidx[chr( $i )] = array( );
}
$name['other'] = array( );
$nidx['other'] = array( );
$sql = "select * from ADDRESS where USER_ID='{$LOGIN_USER_ID}' order by SEQNUMBER,PSN_NAME";
$result = mysql_query( $sql );
while ( $row = mysql_fetch_array( $result ) )
{
	$s = $row['PSN_NAME'];
	$idx = "other";
	if ( 128 <= ord( $s[0] ) )
	{
		$FirstName = substr( $s, 0, 2 );
		foreach ( $mb as $key => $s )
		{
			if ( strpos( $s, $FirstName ) )
			{
				$idx = strtoupper( $key );
				break;
			}
		}
	}
	else
	{
		$FirstName = strtoupper( $s[0] );
		if ( "A" <= $FirstName && $FirstName <= "Z" )
		{
			$idx = $FirstName;
		}
		else
		{
			$idx = "other";
		}
	}
	if ( !in_array( $FirstName, $nidx[$idx] ) )
	{
		array_push( $nidx[$idx], $FirstName );
	}
	array_push( $name[$idx], $row );
}
$INDEX = 0;
if ( mysql_num_rows( $result ) < 1 )
{
	echo "<option>无记录</option>\r\n";
}
else
{
	foreach ( $name as $key => $r )
	{
		if ( 0 < count( $name[$key] ) )
		{
			++$INDEX;
			if ( $key == "other" )
			{
				$TABLE_STR = "<b>其它</b>(".count( $name[$key] ).") - ".implode( ", ", $nidx[$key] );
			}
			else
			{
				$TABLE_STR = "<b>".$key."</b>(".count( $name[$key] ).") - ".implode( ", ", $nidx[$key] );
			}
			$ID_STR = "";
			foreach ( $r as $ROW )
			{
				$ADD_ID = $ROW['ADD_ID'];
				$ID_STR .= $ADD_ID.",";
			}
			echo "<option value=\"ID_STR=";
			echo $ID_STR;
			echo "&TABLE_STR=";
			echo $TABLE_STR;
			echo "\">";
			echo $TABLE_STR;
			echo "</option>\r\n\t";
		}
	}
}
echo "</select>\r\n";
echo "<s";
echo "cript language=\"JavaScript\">\r\nvar index_id=0;\r\n\r\nfunction setIndexPointer(theRow, thePointerColor,index_id_over)\r\n{\r\n  if(index_id!=index_id_over)\r\n     theRow.bgColor = thePointerColor;\r\n}\r\n\r\nfunction view_index(theRow,id_str,table_str,index_count)\r\n{  \r\n   window.location.href=\"address/idx_search.php?ID_STR=\"+id_str+\"&TABLE_STR=\"+table_str;\r\n   index_id=index_count;\r\n\r\n}\r\n</script>\r\n</td>\r\n</tr>\r\n</";
echo "form>\r\n</table>\r\n<!--------------------------------- 索引结束 -------------------------------------------------->\r\n";
?>