|
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/admin/res_good/ |
Upload File : |
<?
include "../include/top_proc.html"; //공통파일 인클루드
include "_common.php";
//테이블
$table = "TB_PRIVATE_DEPART";
if($SqlType=='ins_private'){
$file1 = "";
$file2 = "";
if(strpos($title, '[P]') !== false){
}else{
$title = "[P] ".$title;
}
if(isset($_FILES['file1']) || isset($_FILES['file2'])){
$folderName = time();
if(mkdir($_SERVER['DOCUMENT_ROOT'].'/FileData/tour_depart/'.$folderName)){
if(isset($_FILES['file1'])){
$file1 = $folderName.'/'.$_FILES['file1']['name'];
$file1Name = $_FILES['file1']['name'];
if(!move_uploaded_file($_FILES['file1']['tmp_name'],$_SERVER['DOCUMENT_ROOT']."/FileData/tour_depart/{$folderName}/".$file1Name)){
$file1 = "";
}
}
if(isset($_FILES['file2'])){
$file2 = $folderName.'/'.$_FILES['file2']['name'];
$file2Name = $_FILES['file2']['name'];
if(!move_uploaded_file($_FILES['file2']['tmp_name'],$_SERVER['DOCUMENT_ROOT']."/FileData/tour_depart/{$folderName}/".$file2Name)){
$file2 = "";
}
}
}
}
$sql = "INSERT INTO {$table} SET vehicleInfo = '{$vehicleInfo}',busResYN = '{$busResYN}', file1 = '{$file1Name}', file2 = '{$file2Name}',file1path = '{$file1}', file2path = '{$file2}', res_people = {$res_people}, max_people = {$max_people}, calendar_date = '{$calendar_date}', title = '{$title}', color = '{$color}', memo = '{$memo}',ins_id='{$TK_MEMBER[mb_id]}', ins_dt = now()";
$Result = db_query($sql);
if($Result){
error_msg("parent.document.location.reload();", "script");
}
}else if($SqlType=='edit_private'){
/*if(devCookie()){
p($busResYN);
exit;
}*/
if($seq){
$file1 = "";
$file2 = "";
$sqlFile1 = "";
$sqlFile2 = "";
/*if($busResYN == 'on'){
$busResYN = 'Y';
}else{
$busResYN = 'N';
}*/
if(strpos($title, '[P]') !== false){
}else{
$title = "[P] ".$title;
}
if(isset($_FILES['file1']) || isset($_FILES['file2'])){
$folderName = time();
if(mkdir($_SERVER['DOCUMENT_ROOT'].'/FileData/tour_depart/'.$folderName)){
if(isset($_FILES['file1'])){
$file1 = $folderName.'/'.$_FILES['file1']['name'];
$file1Name = $_FILES['file1']['name'];
if(!move_uploaded_file($_FILES['file1']['tmp_name'],$_SERVER['DOCUMENT_ROOT']."/FileData/tour_depart/{$folderName}/".$file1Name)){
$file1 = "";
}
}
if(isset($_FILES['file2'])){
$file2 = $folderName.'/'.$_FILES['file2']['name'];
$file2Name = $_FILES['file2']['name'];
if(!move_uploaded_file($_FILES['file2']['tmp_name'],$_SERVER['DOCUMENT_ROOT']."/FileData/tour_depart/{$folderName}/".$file2Name)){
$file2 = "";
}
}
}
}
if($file1){
$sqlFile1 = "file1 = '{$file1Name}', file1path = '{$file1}'";
$sql = "UPDATE {$table} SET {$sqlFile1} WHERE seq = {$seq}";
db_query($sql);
}
if($file2){
$sqlFile2 = "file2 = '{$file2Name}', file2path = '{$file2}'";
$sql = "UPDATE {$table} SET {$sqlFile2} WHERE seq = {$seq}";
db_query($sql);
}
$sql = "UPDATE {$table} SET vehicleInfo = '{$vehicleInfo}', busResYN = '{$busResYN}', res_people = {$res_people}, max_people = {$max_people}, calendar_date = '{$calendar_date}', title = '{$title}', color = '{$color}', memo = '{$memo}',ins_id='{$TK_MEMBER[mb_id]}', ins_dt = now() WHERE seq = {$seq}";
if(db_query($sql)){
error_msg("parent.document.location.reload();", "script");
}
}else{
error_msg("alert('error');parent.document.location.reload();", "script");
}
}else if($SqlType=='del_private'){
if($seq){
$sql = "UPDATE {$table} SET isShow = 'N' WHERE seq = {$seq}";
if(db_query($sql)){
error_msg("parent.document.location.reload();", "script");
}else{
error_msg("alert('삭제 실패');parent.document.location.reload();", "script");
}
}else{
error_msg("alert('삭제 실패');parent.document.location.reload();", "script");
}
}
?>