submit.php

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

<?php

include_once( "inc/auth.php" );
include_once( "inc/conn.php" );
include_once( "inc/utility.php" );
include_once( "inc/csv.php" );
$connection = openconnection( );
$SQL = "SELECT MAX(SEQNUMBER) SEQN FROM ADDRESS WHERE USER_ID = '' AND GROUP_ID = ".$_REQUEST['GROUP_ID']."";
$cursor = exequery( $connection, $SQL );
if ( $row = mysql_fetch_array( $cursor ) )
{
	$seqnumber = $row['SEQN'];
}
$ID_STR = "PSN_NAME,SEX,NICK_NAME,BIRTHDAY,MINISTRATION,MATE,CHILD,DEPT_NAME,ADD_DEPT,POST_NO_DEPT,TEL_NO_DEPT,FAX_NO_DEPT,ADD_HOME,POST_NO_HOME,TEL_NO_HOME,MOBIL_NO,BP_NO,EMAIL,OICQ_NO,ICQ_NO,NOTES";
$titlelist = explode( ",", $ID_STR );
$csvlist = explode( ",", $_REQUEST['nlist'] );
$csvfile = getenv( "DOCUMENT_ROOT" )."attachment/".$_REQUEST['csvfile'];
$csv = new csv( );
$csv->file = $csvfile;
$csv->spot = ",";
$csv->open( 0 );
$field = $csv->getfield( );
$seq = $seqnumber + 1;
$rows = 1;
while ( $record = $csv->getrecord( ) )
{
	$j = 0;
	for ( ;	$j < count( $titlelist );	++$j	)
	{
		$ADDRESS[$titlelist[$j]] = $record[$csvlist[$j]];
		if ( $ADDRESS['SEX'] == "女" )
		{
			$ADDRESS['SEX'] = 1;
		}
		else
		{
			$ADDRESS['SEX'] = 0;
		}
	}
	$query = "insert into ADDRESS (USER_ID,GROUP_ID,SEQNUMBER,".$ID_STR.") values ('',{$GROUP_ID},".$seq.",'".$ADDRESS['PSN_NAME']."','".$ADDRESS['SEX']."','".$ADDRESS['NICK_NAME']."','".$ADDRESS['BIRTHDAY']."','".$ADDRESS['MINISTRATION']."','".$ADDRESS['MATE']."','".$ADDRESS['CHILD']."','".$ADDRESS['DEPT_NAME']."','".$ADDRESS['ADD_DEPT']."','".$ADDRESS['POST_NO_DEPT']."','".$ADDRESS['TEL_NO_DEPT']."','".$ADDRESS['FAX_NO_DEPT']."','".$ADDRESS['ADD_HOME']."','".$ADDRESS['POST_NO_HOME']."','".$ADDRESS['TEL_NO_HOME']."','".$ADDRESS['MOBIL_NO']."','".$ADDRESS['BP_NO']."','".$ADDRESS['EMAIL']."','".$ADDRESS['OICQ_NO']."','".$ADDRESS['ICQ_NO']."','".$ADDRESS['NOTES']."');";
	exequery( $connection, $query );
	++$seq;
	++$rows;
}
$csv->close( );
unset( $csv );
unlink( $csvfile );
echo "<table border=\"0\" width=\"100%\" cellpadding=\"2\" cellspacing=\"1\" align=\"center\">\r\n<tr>\r\n    <td nowrap>\r\n\t <table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n  <tr class=\"tablehead1\">\r\n  <td><img src=\"/images/menu/address.gif\" align=\"absmiddle\">导入通讯录\r\n  </td>\r\n  </tr>\r\n  <tr class=\"tablehead2\"><td>\r\n   <a href=\"index.php\"><img src=\"/images/button/return.gif\" border=\"0\"></a>\r\n  </td>\r\n  </tr>\r\n  </";
echo "table>\r\n<hr width=\"95%\" height=\"1\" align=\"left\" color=\"#ffffff\">\r\n<div align=\"center\">\r\n";
$rows = $rows - 1;
message( "", "共".$rows."条数据导入!" );
echo "</div>\r\n";
?>