|
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/engine/ |
Upload File : |
<?
include("../../../../../config/conndb_nonsession.inc.php");
set_time_limit(0);
$db_temp = "temp_pobec_import";
//$fixip = "192.168.2.104";
$fixip = "localhost";
function conn($host){
$username="sapphire";
$password="sprd!@#$%";
// global $username,$password ;
$myconnect =mysql_connect($host,$username,$password)or die (mysql_error()) ; //OR DIE("Unable to connect to database :: $host ");
$iresult = mysql_query("SET character_set_results=tis-620");
$iresult = mysql_query("SET NAMES TIS620");
}
/**
* ----------------------------------------------------------------
* XBase
* test.php
*
* Developer : Erwin Kooi
* released at : Nov 2005
* last modified by : Erwin Kooi
* date modified : Jan 2005
*
* Info? Mail to info@cyane.nl
*
* --------------------------------------------------------------
*
* Basic demonstration
* download the sample tables from:
* http://www.cyane.nl/phpxbase.zip
*
**/
/* load the required classes */
require_once "Column.class.php";
require_once "Record.class.php";
require_once "Table.class.php";
ini_set("memory_limit","64M") ;
function GetRandomString($length){
$template = "1234567890abcdefghijklmnopqrstuvwxyz";
settype($length, "integer");
settype($rndstring, "string");
settype($a, "integer");
settype($b, "integer");
for ($a = 0; $a <= $length; $a++) {
$b = mt_rand(0, strlen($template) - 1);
$rndstring .= $template[$b];
}
return $rndstring;
}
/* create a table object and open it */
if($process=="execute"){
//echo "=== 1".$name."<br>";
//echo "=== 2".$name_school;die;
$myfile = GetRandomString(7);
while(is_file($myfile.".DBF")){
$myfile = GetRandomString(7);
}
// เช็ค การ upload
if(!copy($name,"../tmp_dbf/".$myfile.".DBF")){
echo "
<script language=\"javascript\">
alert(\"ไม่สามารถ upload ไฟล์ ongdat ได้ \");
location.href='../browse.php?sentsecid=$sentsecid';
</script>
";
die;
}else{
//write log keyin
chmod("../tmp_dbf/".$myfile.".DBF", 0777);
}
// end upload
$sfiletxt = $myfile.".DBF";
// echo $sfiletxt."<br>";
// echo "====".$process;die;
$table = new XBaseTable("../tmp_dbf/$sfiletxt");
$table->open();
$xtable = new XBaseTable("../tmp_dbf/$sfiletxt");
$xtable->open();
/* print some header info */
// echo "version: ".$table->version."<br />";
// echo "foxpro: ".($table->foxpro?"yes":"no")."<br />";
// echo "modifyDate: ".date("r",$table->modifyDate)."<br />";
// echo "recordCount: ".$table->recordCount."<br />";
// echo "headerLength: ".$table->headerLength."<br />";
// echo "recordByteLength: ".$table->recordByteLength."<br />";
// echo "inTransaction: ".($table->inTransaction?"yes":"no")."<br />";
// echo "encrypted: ".($table->encrypted?"yes":"no")."<br />";
// echo "mdxFlag: ".ord($table->mdxFlag)."<br />";
// echo "languageCode: ".ord($table->languageCode)."<br />";
/* html output */
/* print column names */
$dbname_obec = "pobec_$getsiteid";
$sql_drop1 = "DROP TABLE $dbname_obec";
mysql_db_query($db_temp,$sql_drop1);
$sqlmaintb = "CREATE TABLE `pobec_".$getsiteid."` ( " ;
foreach ($table->getColumns() as $i=>$c) {
if($c->getType()=="C"){
$typef = "varchar";
}else if($c->getType()=="N"){
$typef = "integer";
}else if($c->getType()=="D"){
$typef = "DATETIME";
}else{
$typef = "varchar";
}
if(trim(strip_tags($sqltb)) > ""){ $sqltb .= ",";} // ใส่คอมมา
if($typef == "DATETIME"){
$sqltb .= " `".$c->getName()."` ".$typef." NOT NULL";
}else{
$sqltb .= " `".$c->getName()."` ".$typef."(".$c->getLength().") default NULL";
}
}
$sqlresulttb = $sqlmaintb.$sqltb." )ENGINE=MyISAM DEFAULT CHARSET=tis620;" ;
//echo "$sqlresulttb <hr>";
mysql_db_query($db_temp,$sqlresulttb)or die(mysql_error()."______line :".__LINE__."_____");// query ข้อมูล
/* print records */
while ($record=$table->nextRecord()) {
$sqlmain = $sql = $sqlresult = "";
$sqlmain = "INSERT INTO `pobec_".$getsiteid."` SET ";
foreach ($table->getColumns() as $i=>$c) {
if(trim(strip_tags($sql)) > ""){ $sql .= ",";} // ใส่คอมมา
$sql .= $c->getName()."='".addslashes($record->getString($c))."'";
}
$sqlresult .= $sqlmain.$sql.";";
//$sqlresult = addslashes($sqlresult);
//echo $sqlresult; echo "<hr>";
mysql_db_query($db_temp,$sqlresult)or die(mysql_error()."______line :".__LINE__."_____");
}
$table->close();
#########################3### เก็บข้อมูล ongdate ไว้ใน site ####################
$sql_area = "SELECT eduarea.secid,area_info.intra_ip FROM eduarea Inner Join area_info ON eduarea.area_id = area_info.area_id where eduarea.secid = '$getsiteid'";
$result_area = mysql_db_query($dbnamemaster,$sql_area);
$rs_area = mysql_fetch_assoc($result_area);
$xsqlresulttb = str_replace("pobec_$getsiteid","pobec_ongdat",$sqlresulttb); // sql สร้างตาราง ในเขตพื่นที่การศึกษา
conn($rs_area[intra_ip]); // connect เครือง ตาม site
$sql_drop1 = "DROP TABLE IF EXISTS pobec_ongdat";
mysql_db_query("cmss_$getsiteid",$sql_drop1);
$result_site1 = mysql_db_query("cmss_$getsiteid",$xsqlresulttb);
## insert pobec_ongdat ################
conn($fixip); // connect เครื่อง หลัก
$sql_select_in = "SELECT * FROM pobec_$getsiteid";
$result_select_in = mysql_db_query($db_temp,$sql_select_in);
//echo "$fixip == $sql_select_in == $db_temp";die;
while($rsi = mysql_fetch_assoc($result_select_in)){
conn($rs_area[intra_ip]);
$sql_in_data = "INSERT INTO pobec_ongdat(P_CODE,D_CODE,G_CODE,S_CODE,I_CODE,IDCODE,KBK,N_POSITION,SUR_CODE,NAME1,NAME2,NAME1ENG,NAME2ENG,POST_CODE,P10YY,N_PATH0,N_RATE0,N_PATH,N_RATE,N_PATH2,N_RATE2,K_PATH0,K_RATE0,K_PATH,K_RATE,K_PATH2,K_RATE2,PSR,SNA_CODE,I_CODE1,DATE_B,DATE_F,BLOOD,LVKSUNG,ORDERKS,LV,RS,LV0,RS0,YOOB,PER_CODE,SUNGKUD,PKS,DATE_PKS,VITAYA,VIT_BATH,DATE_VIT,VIT_KSUNG,VPAT_BATH,DATE_VPAT)VALUES('$rsi[P_CODE]','$rsi[D_CODE]','$rsi[G_CODE]','$rsi[S_CODE]','$rsi[I_CODE]','$rsi[IDCODE]','$rsi[KBK]','$rsi[N_POSITION]','$rsi[SUR_CODE]','$rsi[NAME1]','$rsi[NAME2]','$rsi[NAME1ENG]','$rsi[NAME2ENG]','$rsi[POST_CODE]','$rsi[P10YY]','$rsi[N_PATH0]','$rsi[N_RATE0]','$rsi[N_PATH]','$rsi[N_RATE]','$rsi[N_PATH2]','$rsi[N_RATE2]','$rsi[K_PATH0]','$rsi[K_RATE0]','$rsi[K_PATH]','$rsi[K_RATE]','$rsi[K_PATH2]','$rsi[K_RATE2]','$rsi[PSR]','$rsi[SNA_CODE]','$rsi[I_CODE1]','$rsi[DATE_B]','$rsi[DATE_F]','$rsi[BLOOD]','$rsi[LVKSUNG]','$rsi[ORDERKS]','$rsi[LV]','$rsi[RS]','$rsi[LV0]','$rsi[RS0]','$rsi[YOOB]','$rsi[PER_CODE]','$rsi[SUNGKUD]','$rsi[PKS]','$rsi[DATE_PKS]','$rsi[VITAYA]','$rsi[VIT_BATH]','$rsi[DATE_VIT]','$rsi[VIT_KSUNG]','$rsi[VPAT_BATH]','$rsi[DATE_VPAT]')";
$result_in_data = mysql_db_query("cmss_$getsiteid",$sql_in_data);
}
/* close the table */
#####impschool ########################################################################################################
conn($fixip); // connect เครื่อง หลัก
if($name_school != ""){
$myfile1 = GetRandomString(7);
while(is_file($myfile1.".DBF")){
$myfile1 = GetRandomString(7);
}
// เช็ค การ upload
$myfile1 = $myfile1."_school";
if(!copy($name_school,"../tmp_dbf/".$myfile1.".DBF")){
echo "
<script language=\"javascript\">
alert(\"ไม่สามารถ upload ไฟล์ school ได้ \");
location.href='../browse.php';
</script>
";
die;
}else{
//write log keyin
chmod("../tmp_dbf/".$myfile1.".DBF", 0777);
}
// end upload
$sfiletxt1 = $myfile1.".DBF";
$table1 = new XBaseTable("../tmp_dbf/$sfiletxt1");
$table1->open();
/* print some header info */
// echo "version: ".$table1->version."<br />";
// echo "foxpro: ".($table1->foxpro?"yes":"no")."<br />";
// echo "modifyDate: ".date("r",$table1->modifyDate)."<br />";
// echo "recordCount: ".$table1->recordCount."<br />";
// echo "headerLength: ".$table1->headerLength."<br />";
// echo "recordByteLength: ".$table1->recordByteLength."<br />";
// echo "inTransaction: ".($table1->inTransaction?"yes":"no")."<br />";
// echo "encrypted: ".($table1->encrypted?"yes":"no")."<br />";
// echo "mdxFlag: ".ord($table1->mdxFlag)."<br />";
// echo "languageCode: ".ord($table1->languageCode)."<br />";
/* html output */
/* print column names */
$dbname_school = "school_$getsiteid";
$sql_drop2 = "DROP TABLE $dbname_school";
mysql_db_query($db_temp,$sql_drop2);
$sqlmaintb1 = "CREATE TABLE `school_".$getsiteid."` ( " ;
foreach ($table1->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;" ;
// echo "$sqlresulttb <hr>";
mysql_db_query($db_temp,$sqlresulttb1)or die(mysql_error()."______line :".__LINE__."_____");// query ข้อมูล
/* print records */
while ($record1=$table1->nextRecord()) {
$sqlmain1 = $sql1 = $sqlresult1 = "";
$sqlmain1 = "INSERT INTO `school_".$getsiteid."` SET ";
foreach ($table1->getColumns() as $i1=>$c1) {
if(trim(strip_tags($sql1)) > ""){ $sql1 .= ",";} // ใส่คอมมา
$sql1 .= $c1->getName()." = '".$record1->getString($c1)."'";
}
$sqlresult1 .= $sqlmain1.$sql1.";";
$result_ex = mysql_db_query($db_temp,$sqlresult1)or die(mysql_error()."______line :".__LINE__."_____");
//echo $sqlresult; echo "<br>";
}
$table1->close();
### insert pobec_school ในแต่ละ site ###############
$sql_area1 = "SELECT eduarea.secid,area_info.intra_ip FROM eduarea Inner Join area_info ON eduarea.area_id = area_info.area_id where eduarea.secid = '$getsiteid'";
$result_area1 = mysql_db_query($dbnamemaster,$sql_area1);
$rs_area1 = mysql_fetch_assoc($result_area1);
$ip_site = $rs_area1[intra_ip];
$xsqlresulttb1 = str_replace("school_$getsiteid","pobec_school",$sqlresulttb1);
conn($ip_site);
$sql_drop_i = "DROP TABLE IF EXISTS pobec_school";
mysql_db_query("cmss_$getsiteid",$sql_drop_i);// ลบtable ก่อนสร้าง
mysql_db_query("cmss_$getsiteid",$xsqlresulttb1);
conn($fixip);
$sql_school_in = "SELECT * FROM school_$getsiteid";
$result_school_in = mysql_db_query($db_temp,$sql_school_in);
while($rsi1 = mysql_fetch_assoc($result_school_in)){
conn($ip_site);
$sql_data_in1 = "INSERT INTO pobec_school(P_CODE,D_CODE,G_CODE,SG_CODE,S_CODE,SS_CODE,I_CODE,I_CODE0,PER_CODE,SMISCODE,S_NAME,ABT_NAME,H_NAME,MOO,R_NAME,V_NAME,T_CODE,T_NAME,POSTCODE,TEL_CODE,TEL_NUM,TEACHER,STUDENT,ROOM,D_NO,ZONE,WAY)VALUES('$rsi1[P_CODE]','$rsi1[D_CODE]','$rsi1[G_CODE]','$rsi1[SG_CODE]','$rsi1[S_CODE]','$rsi1[SS_CODE]','$rsi1[I_CODE]','$rsi1[I_CODE0]','$rsi1[PER_CODE]','$rsi1[SMISCODE]','$rsi1[S_NAME]','$rsi1[ABT_NAME]','$rsi1[H_NAME]','$rsi1[MOO]','$rsi1[R_NAME]','$rsi1[V_NAME]','$rsi1[T_CODE]','$rsi1[T_NAME]','$rsi1[POSTCODE]','$rsi1[TEL_CODE]','$rsi1[TEL_NUM]','$rsi1[TEACHER]','$rsi1[STUDENT]','$rsi1[ROOM]','$rsi1[D_NO]','$rsi1[ZONE]','$rsi1[WAY]')";
mysql_db_query("cmss_$getsiteid",$sql_data_in1);
}
/* close the table */
if($result_ex){
echo "
<script language=\"javascript\">
alert(\"ระบบนำเข้าข้อมูลเรียบร้อยแล้ว\");
parent.swap(1);
parent.maindisplay.location=\"../index_report.php?sentsecid=$sentsecid\";
</script>
";
die;
}
}else{
echo "
<script language=\"javascript\">
alert(\"ระบบนำเข้าข้อมูล ongdat.dbf เรียบร้อยแล้ว แต่ยังไม่ได้นำเข้าข้อมูล school.dbf\");
parent.swap(1);
parent.maindisplay.location=\"../index_report.php?sentsecid=$sentsecid\";
</script>
";
die;
}// if($name_school != ""){
} // end if(process == execute){
?>