|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /home/pathumthani_integration/integration/application/industry/ |
Upload File : |
<?
session_start();
set_time_limit(0); # ไม่ให้ time out
require_once('../../config/config_epm.inc.php');
include_once("manage_user.inc.php");
require_once '../../common/classExcel/xls_reader/reader.php';
require_once 'function/function.inc.php';
$complete=0;
$noncom=0;
if ( $_GET['xlsfile'] ) {
$xls_file_name = $_GET['xlsfile'];
$file_target = "files_xls/";
//copy ($xlsfile, $file_target . $xls_file_name);
$furl = $file_target . $xls_file_name;
// ExcelFile($filename, $encoding);
$data = new Spreadsheet_Excel_Reader();
// Set output Encoding.
//$data->setOutputEncoding('CP1251');
$data->setOutputEncoding('TIS-620');
$data->read($file_target . $xls_file_name);
error_reporting(E_ALL ^ E_NOTICE);
// echo "<pre>";
// for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
// for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
// echo "\"".$data->sheets[0]['cells'][$i][$j]."\",";
// }
// echo "<br>";
// }
// echo "</pre>";
$sqlChk=" UPDATE industry_register SET chk_import='1' ";
$rsChk=mysql_db_query($dbname,$sqlChk);
$sqlCOLUMNS_1=" SELECT
`COLUMNS`.COLUMN_NAME,
`COLUMNS`.COLUMN_COMMENT
FROM COLUMNS
WHERE `COLUMNS`.TABLE_NAME = 'industry_register' AND `COLUMNS`.TABLE_SCHEMA = 'pathumthani_integration' ";
$rsCOLUMNS_1=mysql_db_query("information_schema",$sqlCOLUMNS_1);
$numC=0;
while($resCOLUMNS_1=mysql_fetch_assoc($rsCOLUMNS_1)){
if($resCOLUMNS_1['COLUMN_NAME']!='gpsx' && $resCOLUMNS_1['COLUMN_NAME']!='gpsy' && $resCOLUMNS_1['COLUMN_NAME']!='import_status' && $resCOLUMNS_1['COLUMN_NAME']!='update_time' && $resCOLUMNS_1['COLUMN_NAME']!='type_id' && $resCOLUMNS_1['COLUMN_NAME']!='chk_import'){
$numC++;
$colname[$numC]=$resCOLUMNS_1['COLUMN_NAME'];
}
}
$numA=count($colname);
for ( $intA = 1; $intA <= $data->sheets[0]['numRows']; $intA++ ) {
$strSQL = "REPLACE INTO industry_register SET ";
for($i=1;$i<=$numA;$i++){
$strSQL.=$colname[$i]."='".$data->sheets[0]['cells'][$intA][$i]."', ";
}
//$data->sheets[0]['cells'][$intA][8];
/*$sqlTemp=" SELECT COUNT(code) as NUMTEMP
FROM industry_register
WHERE industry_register.code = '".$data->sheets[0]['cells'][$intA][8]."' AND industry_register.import_status = '4'
";
$rsTemp=mysql_db_query($dbname,$sqlTemp);
$resTemp=mysql_fetch_assoc($rsTemp);*/
$strSQL.=" type_id='".substr($data->sheets[0]['cells'][$intA][1],0,3)."', ";
$strSQL.=" gpsx='".$data->sheets[0]['cells'][$intA][91]."', ";
$strSQL.=" gpsy='".$data->sheets[0]['cells'][$intA][90]."', ";
//if($resTemp['NUMTEMP']<1){
$strSQL.=" import_status='3', ";
//}
$strSQL.=" chk_import='2', ";
$strSQL.=" update_time=now()";
/*type_id='".$data->sheets[0]['cells'][$intA][2]."',
tcode='".$data->sheets[0]['cells'][$intA][3]."',
tsic='".$data->sheets[0]['cells'][$intA][4]."',
full_code='".$data->sheets[0]['cells'][$intA][5]."',
number='".$data->sheets[0]['cells'][$intA][6]."',
fyear='".$data->sheets[0]['cells'][$intA][7]."',
eyear='".$data->sheets[0]['cells'][$intA][8]."',
code='".$data->sheets[0]['cells'][$intA][9]."'
";*/
//echo $strSQL."<hr>";
$rs = @mysql_db_query($dbname,$strSQL);
if($rs){
$complete++;
}else{
$noncom++;
}
}
}
//exit();
$dateCease=date("d").'/'.date("m").'/'.(date("Y")+543);
$sqlChk1=" UPDATE industry_register SET import_status='4',cease='".$dateCease."' WHERE chk_import='1' AND import_status!='4' ";
$rsChk1=mysql_db_query($dbname,$sqlChk1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620" />
<title><?=$title_name?></title>
<?
include("header.php");
?>
<br />
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#B4B4B4">
<table width="100%" border="0" cellpadding="5" cellspacing="1">
<tr>
<td bgcolor="#FFFFFF" align="center">
<table width="50%" border="0" cellpadding="3" cellspacing="1" bgcolor="#0066CC">
<tr bgcolor="#FFFFFF">
<td width="200"><strong>ผู้นำเข้าข้อมูล</strong></td>
<td align="center"><?=$_SESSION[session_fullname]?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="200"><strong>วันเวลาการนำเข้าข้อมูล</strong></td>
<td align="center">
<?
echo dateFormat(date("Y-m-d"),'thaidot');
echo ' เวลา '.date("H:i:s");
/*$sqlTime=" SELECT update_time FROM industry ";
$rsTime=mysql_db_query($dbname,$sqlTime);
$resTime=mysql_fetch_assoc($rsTime);
echo $resTime['update_time'];*/
?></td>
</tr>
<tr bgcolor="#4774b5">
<td width="200"><strong></strong></td>
<td align="center"><strong>จำนวน(แถว)</strong></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="200"><strong>import ข้อมูลได้</strong></td>
<td align="center"><?=$complete?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><strong>ไม่สามารถ import ข้อมูลได้</strong></td>
<td align="center"><?=$noncom?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><strong>รวม</strong></td>
<td align="center"><?=($noncom+$complete)?></td>
</tr>
</table>
</td></tr></table></td></tr></table>