|
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() ;
include_once("../../config/config_epm.inc.php");
include_once("manage_user.inc.php");
require_once 'function/function.inc.php';
require_once "engine/Column.class.php";
require_once "engine/Record.class.php";
require_once "engine/Table.class.php";
$nonImport=0;
$Import=0;
$totalImport=0;
if ( $_GET['dbffile'] ) {
$xls_file_name = $_GET['dbffile'];
$file_target = "files_xls/";
//copy ($xlsfile, $file_target . $xls_file_name);
$filename2 = $file_target . $xls_file_name;
//$filename2='cease.DBF';
if(is_file($filename2)){ //โรงเรียน
$myfile2= $filename2 ;
$table_school = new XBaseTable($myfile2);
$table_school->open();
$tblname_school = "industry_cease";
$sql_drop2 = "DROP TABLE IF EXISTS $tblname_school"; //ลบตาราง school
mysql_db_query($dbname,$sql_drop2);
// สร้างตาราง school
$sqlmaintb1 = "CREATE TABLE `".$tblname_school."` ( " ;
foreach ($table_school->getColumns() as $i1=>$c1) {
if($c1->getType()=="C"){
$typef1 = "varchar";
}else if($c1->getType()=="N"){
$typef1 = "integer";
}else if($c1->getType()=="D"){
$typef1 = "DATETIME";
}else{
$typef1 = "varchar";
}
if(trim(strip_tags($sqltb1)) > ""){ $sqltb1 .= ",";} // ใส่คอมมา
if($typef1 == "DATETIME"){
$sqltb1 .= " `".$c1->getName()."` ".$typef1." NOT NULL";
}else{
$sqltb1 .= " `".$c1->getName()."` ".$typef1."(".$c1->getLength().") default NULL";
}
}
$sqlresulttb1 = $sqlmaintb1.$sqltb1." )ENGINE=MyISAM DEFAULT CHARSET=tis620;" ;
mysql_db_query($dbname,$sqlresulttb1)or die(mysql_error()."______line :".__LINE__."_____");// query ข้อมูล
// จบการ สร้างตาราง school
// เอาข้อมูล เข้า school
// echo $sqlresulttb1;
// echo $table_school->recordCount;
while ($record1=$table_school->nextRecord()) {
$sqlmain1 = $sql1 = $sqlresult1 = "";
$sqlmain1 = "INSERT INTO `".$tblname_school."` SET ";
foreach ($table_school->getColumns() as $i1=>$c1) {
if(trim(strip_tags($sql1)) > ""){ $sql1 .= ",";} // ใส่คอมมา
$sql1 .= $c1->getName()." = '".addslashes($record1->getString($c1))."'";
}
$sqlresult1 .= $sqlmain1.$sql1.";";
//echo $sqlresult1.'<hr>';
$result_ex = mysql_db_query($dbname,$sqlresult1)or die(mysql_error()."______line :".__LINE__."_____");
}
$table_school->close();
unset($table_school);
}
$sqlSchema=" SELECT `COLUMNS`.COLUMN_NAME
FROM `COLUMNS`
WHERE `COLUMNS`.TABLE_NAME = 'industry_cease' AND `COLUMNS`.TABLE_SCHEMA = 'pathumthani_integration' ";
$rsSchema=mysql_db_query('information_schema',$sqlSchema);
while($resSchema=mysql_fetch_assoc($rsSchema)){
$arrSchema[]=$resSchema['COLUMN_NAME'];
}
$numSchema=count($arrSchema);
#จัดการพวกรหัสซ้ำ และ รหัสเป็นช่องว่าง
$tblname_temp='industry_cease_temp';
$sql_trancate = "truncate table ".$tblname_temp.";";
mysql_db_query($dbname,$sql_trancate);
$sqlCease=" SELECT * FROM industry_cease ";
$rsCease=mysql_db_query($dbname,$sqlCease);
while($resCease=mysql_fetch_assoc($rsCease)){
if($resCease['CODE']==''){
$nonImport++;
$totalImport++;
}else{
$sqlCease_1=" SELECT COUNT(CODE) AS NUMBERCEASE FROM industry_cease_temp WHERE CODE='".$resCease['CODE']."' ";
//echo $sqlCease_1.'<hr>';
$rsCease_1=mysql_db_query($dbname,$sqlCease_1);
$resCease_1=mysql_fetch_assoc($rsCease_1);
if($resCease_1['NUMBERCEASE']<1){
$sqlmain1 = $sql1 = $sqlresult1 = "";
$sqlmain1 = "INSERT INTO `".$tblname_temp."` SET ";
for($i=0;$i<$numSchema;$i++){
$sql1 .= $arrSchema[$i]." = '".addslashes($resCease[$arrSchema[$i]])."',";
}
$sql1=substr($sql1,0,strlen($sql1)-1);
$sqlresult1 .= $sqlmain1.$sql1.";";
//echo $sqlresult1.'<hr>';
$result_ex = @mysql_db_query($dbname,$sqlresult1);
if($result_ex){
$Import++;
}else{
$nonImport++;
}
}else{
$nonImport++;
}
}
}
/*echo $totalImport;
echo '<br>';
echo $nonImport;
echo '<br>';
echo $Import;
exit();*/
#นำข้อมูลที่เลิกกิจการเข้าตาราง industry_register
$tblname_temp='industry_register';
$sqlCease=" SELECT * FROM industry_cease_temp ";
$rsCease=mysql_db_query($dbname,$sqlCease);
while($resCease=mysql_fetch_assoc($rsCease)){
$sqlCease_1=" SELECT COUNT(code) AS NUMBERCEASE FROM ".$tblname_temp." WHERE code='".$resCease['CODE']."' ";
//echo $sqlCease_1.'<hr>';
$rsCease_1=mysql_db_query($dbname,$sqlCease_1);
$resCease_1=mysql_fetch_assoc($rsCease_1);
if($resCease_1['NUMBERCEASE']<1){
$sqlmain1 = $sql1 = $sqlresult1 = "";
$sqlmain1 = "INSERT INTO `".$tblname_temp."` SET ";
$chkCeaseDate=0;
for($i=0;$i<$numSchema;$i++){
if($arrSchema[$i]!='FCODE' && $arrSchema[$i]!='MAHINE_CAP' && $arrSchema[$i]!='MACHINE' && $arrSchema[$i]!='RESUME' && $arrSchema[$i]!='REMARK2'){
if($arrSchema[$i]=='CEASE_DATE'){
if($resCease[$arrSchema[$i]]!=''){
$chkCeaseDate=1;
$sql1 .="cease = '".addslashes($resCease[$arrSchema[$i]])."',";
}
}else if($arrSchema[$i]=='CEASE_MARK'){
$sql1 .="remark2 = '".addslashes($resCease[$arrSchema[$i]])."',";
}else{
$sql1 .= strtolower($arrSchema[$i])." = '".addslashes($resCease[$arrSchema[$i]])."',";
}
}
}
$sql1 .="type_id = '".substr($resCease['TCODE'],0,3)."',";
$sql1 .="import_status = '4',";
$sql1 .="update_time =now() ,";
if($chkCeaseDate==0){
$sql1 .="cease = '1',";
}
$sql1=substr($sql1,0,strlen($sql1)-1);
$sqlresult1 .= $sqlmain1.$sql1.";";
//echo $sqlresult1.'<hr>';
$result_ex = mysql_db_query($dbname,$sqlresult1)or die(mysql_error()."______line :".__LINE__."_____");
}else{
$sqlmain1 = $sql1 = $sqlresult1 = "";
$sqlmain1 = "UPDATE `".$tblname_temp."` SET ";
$sql1 .="import_status = '4',";
$sql1 .="update_time =now() ,";
$sql1 .="remark2 = '".addslashes($resCease['CEASE_MARK'])."',";
if($resCease['CEASE_DATE']==''){
$sql1 .="cease = '1',";
}else{
$sql1 .="cease = '".addslashes($resCease['CEASE_DATE'])."',";
}
$sql1=substr($sql1,0,strlen($sql1)-1);
$sql1 .=" WHERE code = '".$resCease['CODE']."'";
$sqlresult1 .= $sqlmain1.$sql1.";";
//echo $sqlresult1.'<hr>';
$result_ex = mysql_db_query($dbname,$sqlresult1)or die(mysql_error()."______line :".__LINE__."_____");
}
}
}
?>
<!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"><?=$Import?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><strong>ไม่สามารถ import ข้อมูลได้</strong></td>
<td align="center"><?=$nonImport?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><strong>รวม</strong></td>
<td align="center"><?=($nonImport+$Import)?></td>
</tr>
</table>
</td></tr></table></td></tr></table>