📄 import.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/conn.php" );
include_once( "inc/utility.php" );
include_once( "inc/utility_all.php" );
echo "<html>\r\n<head>\r\n<title>导入客户资料</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
if ( $FILE_NAME == "" )
{
echo "<script Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n if(document.form1.CSV_FILE.value==\"\")\r\n { alert(\"请选择要导入的文件！\");\r\n return (false);\r\n }\r\n\r\n if (document.form1.CSV_FILE.value!=\"\")\r\n {\r\n var file_temp=document.form1.CSV_FILE.value,file_name;\r\n var Pos;\r\n Pos=file_temp.lastIndexOf(\"\\\\\");\r\n file_name=file_temp.substring(Pos+1,file_temp.length);\r\n document.form1.FILE_NAME.value=file_name;\r\n }\r\n\r\n return (true);\r\n}\r\n</script>\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/sys_config.gif\" align=\"absmiddle\"><span class=\"big3\"> 导入客户资料</span><br>\r\n </td>\r\n </tr>\r\n </table>\r\n <br>\r\n <br>\r\n <div align=\"center\" class=\"Big1\">\r\n <b>请指定用于导入的CSV文件：</b>\r\n <form name=\"form1\" method=\"post\" action=\"import.php?FLOW_ID=";
echo $FLOW_ID;
echo "\" enctype=\"multipart/form-data\" onsubmit=\"return CheckForm();\">\r\n <input type=\"file\" name=\"CSV_FILE\" class=\"BigInput\" size=\"30\">\r\n <input type=\"hidden\" name=\"FILE_NAME\">\r\n <input type=\"hidden\" name=\"GROUP_ID\" value=\"";
echo $GROUP_ID;
echo "\">\r\n <input type=\"submit\" value=\"导入\" class=\"BigButton\">\r\n </form>\r\n <br>\r\n <input value=\"返回\" type=\"button\" class=\"BigButton\" title=\"返回\" name=\"button\" onclick=\"location='index.php'\"> \r\n </div>\r\n";
exit( );
}
if ( strtolower( substr( $FILE_NAME, -3 ) ) != "csv" )
{
message( "错误", "只能导入CSV文件!" );
button_back( );
exit( );
}
$ROW_COUNT = 0;
$handle = fopen( $CSV_FILE, "r" );
if ( !$handle )
{
message( "错误", "打开文件错误!" );
button_back( );
exit( );
}
$CUR_DATE = date( "Y-m-d", time( ) );
$count = 0;
$FIELDMSG = "CUSTOMER_NAME,CUSTOMER_CODE,CUSTOMER_SHORT,TEL_NO,FAX_NO,CUSTOMER_WWW,EMAIL,CUSTOMER_AREA,POSTALCODE,CUSTOMER_ADD,SOURCE,KIND,SELLMODE,ATTRIBUTE,ENTERTYPE,ENTERMEMO,MEMO,MEMO1";
$FIELDMSGNAME = "客户名称,客户编码,客户简称,电话,传真,网址,电子邮件,地区,邮政编码,详细地址,客户来源,客户类别,销售方式,行业属性,企业性质,企业描述,备注1,备注2";
$DATA_ID = explode( ",", $FIELDMSG );
$DATA_ITEM = explode( ",", $FIELDMSGNAME );
$ARRAY_COUNT = sizeof( $DATA_ID );
if ( $DATA_ID[$ARRAY_COUNT - 1] == "" )
{
--$ARRAY_COUNT;
}
$I = 0;
for ( ; $I < $ARRAY_COUNT; ++$I )
{
$DATA_INDEX[$I] = -1;
++$count;
}
$ISNOT_COUNT = 0;
while ( $DATA = fgetcsv( $handle, 10000, "," ) )
{
$DATA_NUM = count( $DATA );
if ( $ROW_COUNT == 0 )
{
$I = 0;
for ( ; do
{
$I < $DATA_NUM; ++$I )
{
$Temp = 0;
for ( ; $Temp < $count; ++$Temp )
{
if ( !( $DATA_ITEM[$Temp] == $DATA[$I] ) )
{
continue;
}
$UPDATA_ITEMID[$I] = $DATA_ID[$Temp];
$DATA_INDEX[$I] = $Temp;
break;
}
if ( $Temp == $count )
{
++$ISNOT_COUNT;
echo "<font color=#FF6633><b>".$DATA[$I]."尚未在OA系统中的客户基本信息中定义！！</b></font><br>";
$UPDATA_ITEMID[$I] = "-1";
}
break;
}
} while ( 1 );
}
else
{
$query = "insert into CUSTOMER (SELLER,CREATDATE,";
$I = 0;
for ( ; $I < $DATA_NUM; ++$I )
{
if ( !( $UPDATA_ITEMID[$I] == "-1" ) )
{
if ( $I != $DATA_NUM - $ISNOT_COUNT - 1 )
{
$query .= $UPDATA_ITEMID[$I].",";
}
else
{
$query .= $UPDATA_ITEMID[$I];
}
}
}
$query .= ") values ('".$LOGIN_USER_ID."','{$CUR_DATE}',";
$I = 0;
for ( ; $I < $DATA_NUM; ++$I )
{
if ( !( $UPDATA_ITEMID[$I] == "-1" ) )
{
if ( $UPDATA_ITEMID[$I] == "SOURCE" )
{
$query1 = "select CODE_NO from SYS_CODE where PARENT_NO='CRM_SOURCE' and CODE_NAME='".$DATA[$I]."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DATA[$I] = $ROW['CODE_NO'];
}
}
if ( $UPDATA_ITEMID[$I] == "KIND" )
{
$query1 = "select CODE_NO from SYS_CODE where PARENT_NO='CRM_KIND' and CODE_NAME='".$DATA[$I]."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DATA[$I] = $ROW['CODE_NO'];
}
}
if ( $UPDATA_ITEMID[$I] == "SELLMODE" )
{
$query1 = "select CODE_NO from SYS_CODE where PARENT_NO='SELL_MODE' and CODE_NAME='".$DATA[$I]."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DATA[$I] = $ROW['CODE_NO'];
}
}
if ( $UPDATA_ITEMID[$I] == "ATTRIBUTE" )
{
$query1 = "select CODE_NO from SYS_CODE where PARENT_NO='CRM_ATTRIBUTE' and CODE_NAME='".$DATA[$I]."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DATA[$I] = $ROW['CODE_NO'];
}
}
if ( $UPDATA_ITEMID[$I] == "ENTERTYPE" )
{
$query1 = "select CODE_NO from SYS_CODE where PARENT_NO='CRM_TYPE' and CODE_NAME='".$DATA[$I]."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DATA[$I] = $ROW['CODE_NO'];
}
}
if ( $UPDATA_ITEMID[$I] == "CUSTOMER_AREA" )
{
$query1 = "select CODE_NO from SYS_CODE where PARENT_NO='AREA' and CODE_NAME='".$DATA[$I]."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DATA[$I] = $ROW['CODE_NO'];
}
}
if ( $UPDATA_ITEMID[$I] == "SELLER" )
{
$DATA[$I] = $LOGIN_USER_ID;
}
$DATA[$I] = format_cvs( $DATA[$I] );
if ( $I != $DATA_NUM - $ISNOT_COUNT - 1 )
{
$query .= "'".$DATA[$I]."',";
}
else
{
$query .= "'".$DATA[$I]."'";
}
}
}
$query .= ")";
echo "客户".$DATA[0]."的资料导入完成！！<br>";
exequery( $connection, $query );
}
++$ROW_COUNT;
}
fclose( $handle );
if ( file_exists( $CSV_FILE ) )
{
unlink( $CSV_FILE );
}
message( "", ( "共".( $ROW_COUNT - 1 ) )."条数据导入!" );
echo "<div align=\"center\">\r\n<input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index.php';\" title=\"返回\">\r\n</div>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -