|
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 : /var/www/html/eoffice/application/document/ |
Upload File : |
<?
$code_get="";$i=0;
foreach($_GET as $act => $val){
if($i==0){$code_get.="?";}else{$code_get.="&";}
$code_get.="$act=$val";
$i++;
}
?>
<?
if ($_SERVER[REQUEST_METHOD] == "POST"){
$sql_drop_old="DELETE FROM $table_staffgroup";
$result_list = mysql_query($sql_drop_old)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
$sql_epm_group="SELECT gid , org_id , groupname , `comment`,owner_id,parent FROM $db_epm.epm_staffgroup";
$result_list0 = mysql_query($sql_epm_group)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
if($result_list0){
while($crs = mysql_fetch_assoc($result_list0)){
$sql_new_tran="
INSERT INTO $table_staffgroup
( `gid` , `org_id` , `groupname` , `comment` , `owner_id` , `parent` , `level` )
VALUES
('$crs[gid]', '$crs[org_id]', '$crs[groupname]', '$crs[comment]', '$crs[owner_id]', '$crs[parent]', NULL);
";
$result_list = mysql_query($sql_new_tran)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
}
}
/*
$sql_tran_defualt="
INSERT INTO $table_staffgroup
( `gid` , `org_id` , `groupname` , `comment` , `owner_id` , `parent` , `level` )
VALUES
(NULL, 2, 'สารบรรณ', 'สารบรรณกลางผู้ดูแลทะเบียนหนังสือ', NULL , '$crs[parent]', '1');
";
$result_list = mysql_query($sql_tran_defualt)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
*/
// END MODE group_tran
$sql_drop_old="DELETE FROM $dbname.epm_staff";
$result_list = mysql_query($sql_drop_old)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
$sql_epm_staff="select * FROM $db_epm.epm_staff";
$result_list1 = mysql_query($sql_epm_staff)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
if($result_list1){
while($crs = mysql_fetch_assoc($result_list1)){
$sql_new_tran="
INSERT INTO $dbname.epm_staff (`staffid`, `gid`, `prename`, `staffname`, `staffsurname`, `engprename`, `engname`, `engsurname`, `email`, `image`, `comment`, `sex`, `org_id`, `title`, `telno`, `address`, `std_cost`, `username`, `password`, `status`, `card_id`, `weight`) VALUES ('$crs[staffid]', '$crs[gid]', '$crs[prename]', '$crs[staffname]', '$crs[staffsurname]', '$crs[engprename]', '$crs[engname]', '$crs[engsurname]', '$crs[email]', '$crs[image]', '$crs[comment]', '$crs[sex]', '$crs[org_id]', '$crs[title]', '$crs[telno]', '$crs[address]', '$crs[std_cost]', '$crs[username]', '$crs[password]', '$crs[status]', '$crs[card_id]', '$crs[weight]');
";
$result_list = mysql_query($sql_new_tran)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
}
}
// END MODE staff_tran
$sql_drop_old="DELETE FROM $table_groupmember";
$result_list = mysql_query($sql_drop_old)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
$sql_epm_gm="select * FROM $db_epm.epm_groupmember";
$result_list2 = mysql_query($sql_epm_gm)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
if($result_list2){
while($crs = mysql_fetch_assoc($result_list2)){
$sql_new_tran="
INSERT INTO `profile_groupmember` ( `gid` , `staffid` )
VALUES (
'$crs[gid]', '$crs[staffid]'
)
";
$result_list = mysql_query($sql_new_tran)or die("Query line " . __LINE__ . " error<hr>".mysql_error());
}
} echo "<br><br><br>";
$msg.= "จัดการคัดลอกข้อมูลจาก EPM เสร็จเรียบร้อย";
echo $msg;
echo "<br><br><br>";
echo "<meta http-equiv='refresh' content='2;url=$PHP_SELF?type=system'>" ;
exit;
// END MODE staff_tran
addlog("Import EPM Database");
}
?>
<br><br>
<form id="post" name="post" method="post" action="<?=$PHP_SELF?><?=$code_get?>">
<input type="hidden" name="mode" value="tran"/>
<input type="submit" name="Submit" value="คัดลอกข้อมูลจาก ระบบ EPM" onClick="return confirm('การนำเข้า ชื่อผู้และกลุ่มผู้ใช้จากระบบ epm จะทำให้ชื่อผู้ใช้เดิมและกลุ่มข้อมูลผู้ใช้เดิมในระบบสารบรรณ ถูกแทนที่ทั้งหมดและไม่สามารถกู้คืนได้ หากต้องการดำเนินต่อกรุณา "ยืนยัน" ')" />
</form>
<br>