|
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/erp/ |
Upload File : |
<?
include "../include/top_proc.html";
include "_common.html";
$upload = $cf['path']."/FileData/good/";
$upload_thum = $cf['path']."/FileData/good_thum/";
if($SqlType == "res_update" ) { //voucher 생성
//voucher detail정보 저장
for($i=0,$j=1 ; $i<$code_count ; $i++,$j++){
//voucher or qrcode::guest_name::guest_person::guest_nationality 정보
if($code_type=="voucher") {
${"code".$j."_info"} = $code_item_arr[$i] . "::" . $guest_name_arr[$i] . "::" .$guest_person_arr[$i] . "::" . $guest_nationality_arr[$i] ;
} elseif($code_type=="qrcode") {
//qrcode image upload
// 업로드
if($_FILES['code_file_arr']['name'][$i]) {
//이미지 업로드
$code_file[$i] = FileUploadName( "", $upload, $_FILES['code_file_arr']['tmp_name'][$i], $_FILES['code_file_arr']['name'][$i] ,"");//파일 업로드
make_thum($upload.$code_file[$i],$upload_thum.$code_file[$i]);//이미지썸네일 생성
}
${"code".$j."_info"} = $code_file[$i] . "::" . $guest_name_arr[$i] . "::" . $guest_person_arr[$i] . "::" . $guest_nationality_arr[$i] ;
}
}
//사용방법
for($k=0;$k<count($use_arr);$k++) {
if(${"use_arr"}[$k]) {
$use_method .= ${"use_arr"}[$k] . "::";
}
}
//미팅장소 및 교환장소
//업로드
if($_FILES['meeting_place']['name']) {
//이미지 업로드
$up_place = FileUploadName( "", $upload, $_FILES['meeting_place']['tmp_name'], $_FILES['meeting_place']['name'] ,"");//파일 업로드
make_thum($upload.$up_place,$upload_thum.$up_place);//이미지썸네일 생성
}
//voucher 기본내용 저장
$sql = "insert into TB_ERP_VOUCHER set ";
$sql .= " a_idx='{$a_idx}', ";
$sql .= " code_type='{$code_type}', ";
if($code1_info) {
$sql .= " code1='{$code1_info}', ";
}
if($code2_info) {
$sql .= " code2='{$code2_info}', ";
}
if($code3_info) {
$sql .= " code3='{$code3_info}', ";
}
if($code4_info) {
$sql .= " code4='{$code4_info}', ";
}
if($code5_info) {
$sql .= " code5='{$code5_info}', ";
}
if($code6_info) {
$sql .= " code6='{$code6_info}', ";
}
if($code7_info) {
$sql .= " code7='{$code7_info}', ";
}
if($code8_info) {
$sql .= " code8='{$code8_info}', ";
}
if($code9_info) {
$sql .= " code9='{$code9_info}', ";
}
if($code10_info) {
$sql .= " code10='{$code10_info}', ";
}
if($code11_info) {
$sql .= " code11='{$code11_info}', ";
}
if($code12_info) {
$sql .= " code12='{$code12_info}', ";
}
if($code13_info) {
$sql .= " code13='{$code13_info}', ";
}
if($code14_info) {
$sql .= " code14='{$code14_info}', ";
}
if($code15_info) {
$sql .= " code15='{$code15_info}', ";
}
if($code16_info) {
$sql .= " code16='{$code16_info}', ";
}
if($code17_info) {
$sql .= " code17='{$code17_info}', ";
}
if($code18_info) {
$sql .= " code18='{$code18_info}', ";
}
if($code19_info) {
$sql .= " code19='{$code19_info}', ";
}
if($code20_info) {
$sql .= " code20='{$code20_info}', ";
}
if($code21_info) {
$sql .= " code21='{$code21_info}', ";
}
if($code22_info) {
$sql .= " code22='{$code22_info}', ";
}
if($code23_info) {
$sql .= " code23='{$code23_info}', ";
}
if($code24_info) {
$sql .= " code24='{$code24_info}', ";
}
if($code25_info) {
$sql .= " code25='{$code25_info}', ";
}
if($code26_info) {
$sql .= " code26='{$code26_info}', ";
}
if($code27_info) {
$sql .= " code27='{$code27_info}', ";
}
if($code28_info) {
$sql .= " code28='{$code28_info}', ";
}
if($code29_info) {
$sql .= " code29='{$code29_info}', ";
}
if($code30_info) {
$sql .= " code30='{$code30_info}', ";
}
if($code31_info) {
$sql .= " code31='{$code31_info}', ";
}
if($code32_info) {
$sql .= " code32='{$code32_info}', ";
}
if($code33_info) {
$sql .= " code33='{$code33_info}', ";
}
if($code34_info) {
$sql .= " code34='{$code34_info}', ";
}
if($code35_info) {
$sql .= " code35='{$code35_info}', ";
}
if($code36_info) {
$sql .= " code36='{$code36_info}', ";
}
if($code37_info) {
$sql .= " code37='{$code37_info}', ";
}
if($code38_info) {
$sql .= " code38='{$code38_info}', ";
}
if($code39_info) {
$sql .= " code39='{$code39_info}', ";
}
if($code40_info) {
$sql .= " code40='{$code40_info}', ";
}
if($code41_info) {
$sql .= " code41='{$code41_info}', ";
}
if($code42_info) {
$sql .= " code42='{$code42_info}', ";
}
if($code43_info) {
$sql .= " code43='{$code43_info}', ";
}
if($code44_info) {
$sql .= " code44='{$code44_info}', ";
}
if($code45_info) {
$sql .= " code45='{$code45_info}', ";
}
if($code46_info) {
$sql .= " code46='{$code46_info}', ";
}
if($code47_info) {
$sql .= " code47='{$code47_info}', ";
}
if($code48_info) {
$sql .= " code48='{$code48_info}', ";
}
if($code49_info) {
$sql .= " code49='{$code49_info}', ";
}
if($code50_info) {
$sql .= " code50='{$code50_info}', ";
}
$sql .= " use_method='{$use_method}', ";
$sql .= " meeting_place='$up_place', ";
$sql .= " contact_us='$contact_us', ";
$sql .= " pub_date = now(),";
$sql .= " regdate = now()";
db_query($sql);
//error_msg("location.href='edit_estimate.php?a_idx={$a_idx}&e_idx={$e_idx}&i_idx={$i_idx}'","script");
echo "<script>location.href='edit_estimate.php?".$_ehref."&rtab=3';</script>";
}
elseif($SqlType == "voucher_update" ) { //voucher 수정
//voucher detail정보 수정
for($i=0,$j=1 ; $i<$code_num ; $i++,$j++){
//voucher or qrcode::guest_name::guest_person::guest_nationality 정보
if($code_type=="voucher") {
${"code".$j."_info"} = $code_item_arr[$i] . "::" . $guest_name_arr[$i] . "::" .$guest_person_arr[$i] . "::" . $guest_nationality_arr[$i] ;
} elseif($code_type=="qrcode") {
//qrcode image upload
// 업로드
if($_FILES['code_file_arr']['name'][$i]) {
//이미지 업로드
$code_file[$i] = FileUploadName( "", $upload, $_FILES['code_file_arr']['tmp_name'][$i], $_FILES['code_file_arr']['name'][$i] ,"");//파일 업로드
make_thum($upload.$code_file[$i],$upload_thum.$code_file[$i]);//이미지썸네일 생성
} else {
$code_file[$i] = $qrcode[$i];
}
${"code".$j."_info"} = $code_file[$i] . "::" . $guest_name_arr[$i] . "::" . $guest_person_arr[$i] . "::" . $guest_nationality_arr[$i] ;
}
}
//사용방법
for($k=0;$k<count($use_arr);$k++) {
if(${"use_arr"}[$k]) {
$use_method .= ${"use_arr"}[$k] . "::";
}
}
//미팅장소 및 교환장소
//업로드
if($_FILES['meeting_place']['name']) {
//이미지 업로드
$up_place = FileUploadName( "", $upload, $_FILES['meeting_place']['tmp_name'], $_FILES['meeting_place']['name'] ,"");//파일 업로드
make_thum($upload.$up_place,$upload_thum.$up_place);//이미지썸네일 생성
$sql = "update TB_ERP_VOUCHER set meeting_place='{$up_place}' where v_idx='{$v_idx}'";
db_query($sql);
}
//voucher 기본내용 저장
$sql = "update TB_ERP_VOUCHER set ";
//$sql .= " a_idx='{$a_idx}', ";
$sql .= " code_type='{$code_type}', ";
if($code1_info) {
$sql .= " code1='{$code1_info}', ";
} else {
$sql .= " code1='', ";
}
if($code2_info) {
$sql .= " code2='{$code2_info}', ";
} else {
$sql .= " code2='', ";
}
if($code3_info) {
$sql .= " code3='{$code3_info}', ";
} else {
$sql .= " code3='', ";
}
if($code4_info) {
$sql .= " code4='{$code4_info}', ";
} else {
$sql .= " code4='', ";
}
if($code5_info) {
$sql .= " code5='{$code5_info}', ";
} else {
$sql .= " code5='', ";
}
if($code6_info) {
$sql .= " code6='{$code6_info}', ";
} else {
$sql .= " code6='', ";
}
if($code7_info) {
$sql .= " code7='{$code7_info}', ";
} else {
$sql .= " code7='', ";
}
if($code8_info) {
$sql .= " code8='{$code8_info}', ";
} else {
$sql .= " code8='', ";
}
if($code9_info) {
$sql .= " code9='{$code9_info}', ";
} else {
$sql .= " code9='', ";
}
if($code10_info) {
$sql .= " code10='{$code10_info}', ";
} else {
$sql .= " code10='', ";
}
if($code11_info) {
$sql .= " code11='{$code11_info}', ";
} else {
$sql .= " code11='', ";
}
if($code12_info) {
$sql .= " code12='{$code12_info}', ";
} else {
$sql .= " code12='', ";
}
if($code13_info) {
$sql .= " code13='{$code13_info}', ";
} else {
$sql .= " code13='', ";
}
if($code14_info) {
$sql .= " code14='{$code14_info}', ";
} else {
$sql .= " code14='', ";
}
if($code15_info) {
$sql .= " code15='{$code15_info}', ";
} else {
$sql .= " code15='', ";
}
if($code16_info) {
$sql .= " code16='{$code16_info}', ";
} else {
$sql .= " code16='', ";
}
if($code17_info) {
$sql .= " code17='{$code17_info}', ";
} else {
$sql .= " code17='', ";
}
if($code18_info) {
$sql .= " code18='{$code18_info}', ";
} else {
$sql .= " code18='', ";
}
if($code19_info) {
$sql .= " code19='{$code19_info}', ";
} else {
$sql .= " code19='', ";
}
if($code20_info) {
$sql .= " code20='{$code20_info}', ";
} else {
$sql .= " code20='', ";
}
if($code21_info) {
$sql .= " code21='{$code21_info}', ";
} else {
$sql .= " code21='', ";
}
if($code22_info) {
$sql .= " code22='{$code22_info}', ";
} else {
$sql .= " code22='', ";
}
if($code23_info) {
$sql .= " code23='{$code23_info}', ";
} else {
$sql .= " code23='', ";
}
if($code24_info) {
$sql .= " code24='{$code24_info}', ";
} else {
$sql .= " code24='', ";
}
if($code25_info) {
$sql .= " code25='{$code25_info}', ";
} else {
$sql .= " code25='', ";
}
if($code26_info) {
$sql .= " code26='{$code26_info}', ";
} else {
$sql .= " code26='', ";
}
if($code27_info) {
$sql .= " code27='{$code27_info}', ";
} else {
$sql .= " code27='', ";
}
if($code28_info) {
$sql .= " code28='{$code28_info}', ";
} else {
$sql .= " code28='', ";
}
if($code29_info) {
$sql .= " code29='{$code29_info}', ";
} else {
$sql .= " code29='', ";
}
if($code30_info) {
$sql .= " code30='{$code30_info}', ";
} else {
$sql .= " code30='', ";
}
if($code31_info) {
$sql .= " code31='{$code31_info}', ";
} else {
$sql .= " code31='', ";
}
if($code32_info) {
$sql .= " code32='{$code32_info}', ";
} else {
$sql .= " code32='', ";
}
if($code33_info) {
$sql .= " code33='{$code33_info}', ";
} else {
$sql .= " code33='', ";
}
if($code34_info) {
$sql .= " code34='{$code34_info}', ";
} else {
$sql .= " code34='', ";
}
if($code35_info) {
$sql .= " code35='{$code35_info}', ";
} else {
$sql .= " code35='', ";
}
if($code36_info) {
$sql .= " code36='{$code36_info}', ";
} else {
$sql .= " code36='', ";
}
if($code37_info) {
$sql .= " code37='{$code37_info}', ";
} else {
$sql .= " code37='', ";
}
if($code38_info) {
$sql .= " code38='{$code38_info}', ";
} else {
$sql .= " code38='', ";
}
if($code39_info) {
$sql .= " code39='{$code39_info}', ";
} else {
$sql .= " code39='', ";
}
if($code40_info) {
$sql .= " code40='{$code40_info}', ";
} else {
$sql .= " code40='', ";
}
if($code41_info) {
$sql .= " code41='{$code41_info}', ";
} else {
$sql .= " code41='', ";
}
if($code42_info) {
$sql .= " code42='{$code42_info}', ";
} else {
$sql .= " code42='', ";
}
if($code43_info) {
$sql .= " code43='{$code43_info}', ";
} else {
$sql .= " code43='', ";
}
if($code44_info) {
$sql .= " code44='{$code44_info}', ";
} else {
$sql .= " code44='', ";
}
if($code45_info) {
$sql .= " code45='{$code45_info}', ";
} else {
$sql .= " code45='', ";
}
if($code46_info) {
$sql .= " code46='{$code46_info}', ";
} else {
$sql .= " code46='', ";
}
if($code47_info) {
$sql .= " code47='{$code47_info}', ";
} else {
$sql .= " code47='', ";
}
if($code48_info) {
$sql .= " code48='{$code48_info}', ";
} else {
$sql .= " code48='', ";
}
if($code49_info) {
$sql .= " code49='{$code49_info}', ";
} else {
$sql .= " code49='', ";
}
if($code50_info) {
$sql .= " code50='{$code50_info}', ";
} else {
$sql .= " code50='', ";
}
$sql .= " use_method='{$use_method}', ";
$sql .= " contact_us='{$contact_us}' ";
//$sql .= " pub_date = now(),";
$sql .= " where v_idx = '{$v_idx}'";
db_query($sql);
//error_msg("location.href='edit_estimate.php?a_idx={$a_idx}&e_idx={$e_idx}&i_idx={$i_idx}'","script");
echo "<script>location.href='edit_estimate.php?".$_ehref."&rtab=3';</script>";
}
?>