|
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/toadmin/good/ |
Upload File : |
<?php
include "../include/top_proc.html";
include "_common.php";
$table = "good";
$upload = $cf['path']."/FileData/good/";
$upload_thum = $cf['path']."/FileData/good_thum/";
// 에디터용
$g_heed = insert_smart($g_heed);
$g_heed_mo = insert_smart($g_heed_mo);
$g_special = insert_smart($g_special);
$g_special_mo = insert_smart($g_special_mo); //모바일용
$g_inclusion = insert_smart($g_inclusion);
$g_noinclusion = insert_smart($g_noinclusion);
$g_rule = insert_smart($g_rule);
$g_rule_mo = insert_smart($g_rule_mo); //모바일용
$g_cautions = insert_smart($g_cautions);
$g_cautions_mo = insert_smart($g_cautions_mo); //모바일용
$google_map = insert_smart($google_map); //구글맵
// 쌍따옴표,홑따옴표 불가 체크
if($SqlType == "good_ins" or $SqlType == "good_edit") {
if( isCheckQuot($g_title) == true OR
isCheckQuot($g_sch) == true )
error_msg("쌍따옴표,홑따옴표는 사용불가합니다.");
}
$seo_first_category_url = str_replace(" ","",$seo_first_category_url);
$seo_first_category_url = str_replace("+","-",$seo_first_category_url);
$seo_first_category_url = str_replace("--","-",$seo_first_category_url);
$seo_second_category_url = str_replace(" ","",$seo_second_category_url);
$seo_second_category_url = str_replace("+","-",$seo_second_category_url);
$seo_second_category_url = str_replace("--","-",$seo_second_category_url);
$seo_good_url = str_replace(" ","",$seo_good_url);
$seo_good_url = str_replace("--","-",$seo_good_url);
$seo_good_url = str_replace("+","-",$seo_good_url);
$seo_first_category_url = trim(strtolower($seo_first_category_url));
$seo_second_category_url = trim(strtolower($seo_second_category_url));
$seo_good_url = trim(strtolower($seo_good_url));
$good_hashtag_id_list = "";
foreach($good_hashtag_id as $item){
if($good_hashtag_id_list){
$good_hashtag_id_list .= ",".$item;
}else{
$good_hashtag_id_list = $item;
}
}
if($SqlType == "good_ins") {
if (!$g_title) exit;
// 업로드
if($_FILES['g_image1']['name']) {
//이미지 업로드
$up_img1 = FileUploadName( "", $upload, $_FILES['g_image1']['tmp_name'], $_FILES['g_image1']['name'] ,"");//파일 업로드
make_thum($upload.$up_img1,$upload_thum.$up_img1);//이미지썸네일 생성
}
if($_FILES['g_image3']['name']) {
//이미지 업로드
$up_img3 = @FileUploadName( "", $upload, $_FILES['g_image3']['tmp_name'], $_FILES['g_image3']['name'] ,"");//파일 업로드
make_thum($upload.$up_img3,$upload_thum.$up_img3);//이미지썸네일 생성
}
// 국가명
$country_arr = to_area_b("",$Bidx," and DelFlag='N' ");
$NationName = $country_arr[0]['NationName'];
// 도시명
$city_arr = to_area_c("",$Bidx,$Cidx,"N");
$CityName = $city_arr[0]['CityName'];
// 상품특징아이콘
$g_type_str = "";
for($i=0,$j=1 ; $i<count($g_type_arr) ; $i++,$j++){
$g_type_str .= $g_type_arr[$i];
if ($j < count($g_type_arr)) $g_type_str .= ",";
}
// 외부연동아이콘
$g_api_str = "";
for($i=0,$j=1 ; $i<count($g_api_arr) ; $i++,$j++){
$g_api_str .= $g_api_arr[$i];
if ($j < count($g_api_arr)) $g_api_str .= ",";
}
// 데이투어항목추가(20131029.허종)
$day_price_nor_adult = str_replace(",","",$day_price_nor_adult);
$day_price_nor_child = str_replace(",","",$day_price_nor_child);
$day_price_dc_adult = str_replace(",","",$day_price_dc_adult);
$day_price_dc_child = str_replace(",","",$day_price_dc_child);
// 담당자
if ($admin_id) {
$mem_data = get_member($admin_id);
$admin_nm = $mem_data['mb_nm'];
}
// 공급처
if ($producer_id) {
$mem_data = get_member($producer_id);
$producer_corp_nm = $mem_data['bz_corp_nm'];
}
if(!$gdt) $gdt="gr";
// 미팅장소,미팅시간
$g_meeting = "";
for($a=0 ; $a<count($meeting_place_arr) ; $a++) {
$meeting_place = $meeting_place_arr[$a];
$meeting_hh = $meeting_hh_arr[$a];
$meeting_mm = $meeting_mm_arr[$a];
if($meeting_place_arr[$a]) {
$g_meeting .= "||".$meeting_place."^".$meeting_hh."^".$meeting_mm;
}
}
//상품 상세페이지 설명 이미지
$uploadGoodDetailImg = "";
if($_FILES['good_detail_img']['name']) {
@unlink($cf['path']."/FileData/good_detail_img/".$row['good_detail_img']);
$execute = explode(".", $_FILES['good_detail_img']['name']);
$execute = $execute[count($execute) - 1];
//이미지 업로드
if(move_uploaded_file($_FILES['good_detail_img']['tmp_name'],$cf['path']."/FileData/good_detail_img/".$g_uid.".".$execute)){
$uploadGoodDetailImg = $g_uid.".".$execute;
}
}
$sql = "insert into ".$table." ( ";
$sql.=" tab";
$sql.=" , gdt ";
$sql.=" , b_uid ";
$sql.=" , m_uid ";
$sql.=" , s_uid ";
$sql.=" , pm_uid ";
$sql.=" , ps_uid ";
$sql.=" , Bidx ";
$sql.=" , Cidx ";
$sql.=" , Gidx ";
$sql.=" , NationName ";
$sql.=" , CityName ";
$sql.=" , InfoTitle ";
$sql.=" , g_no ";
$sql.=" , g_title ";
$sql.=" , g_code ";
$sql.=" , g_type ";
$sql.=" , g_api ";
$sql.=" , g_sch ";
#$sql.=" , g_vno ";
#$sql.=" , g_low ";
#$sql.=" , g_high ";
$sql.=" , g_image1 ";
$sql.=" , g_image3 ";
#$sql.=" , g_image2 ";
$sql.=" , g_brief ";
$sql.=" , g_short_brief ";
$sql.=" , g_explain ";
$sql.=" , g_inclusion ";
$sql.=" , g_noinclusion ";
$sql.=" , g_special ";
$sql.=" , g_rule ";
$sql.=" , g_heed ";
$sql.=" , g_ready ";
$sql.=" , g_regdate ";
$sql.= ", g_meeting ";
// $sql.= ", g_stock_type ";
$sql.=" , map_x ";
$sql.=" , map_y ";
$sql.=" , movie_i ";
$sql.=" , admin_id ";
$sql.=" , admin_nm ";
$sql.=" , exchange_fg ";
$sql.=" , exid ";
$sql.=" , g_cautions ";
$sql.=" , g_select_num ";
$sql.=" , producer_id ";
$sql.=" , producer_corp_nm ";
$sql.=" , ticket_code ";
$sql.=" , ticket_addr ";
$sql.=" , ticket_exchange ";
$sql.=" , ticket_expiry_date ";
$sql.=" , g_viewtype ";
$sql.=" , confirm_type ";
$sql.=" , today_reserve ";
$sql.=" , kind_code "; //
$sql.=" , tour_code "; //
$sql.=" , google_map "; //
$sql.=" , g_special_mo "; //
$sql.=" , g_cautions_mo "; //
$sql.=" , g_rule_mo "; //
$sql.=" , g_heed_mo "; //
$sql.=" , api_reserve_type ";
$sql.=" , api_coupang_product_id ";
$sql.=" , api_coupang_travel_id ";
$sql.=" , api_yanolja_product_id ";
$sql.=" , seo_keyword ";
$sql.=" , seo_desc ";
$sql.=" , seo_contents_text ";
$sql.=" , seo_first_category_url ";
$sql.=" , seo_second_category_url ";
$sql.=" , seo_good_url ";
$sql.=" , res_confirm_good_type ";
$sql .= ", product_info_label_1";
$sql .= ", product_info_label_2";
$sql .= ", product_info_label_3";
$sql .= ", product_info_label_4";
$sql .= ", product_info_label_5";
$sql .= ", product_info_label_6";
$sql .= ", good_detail_img";
$sql .=" , good_hashtag_id ";
$sql .= " ,mail_gubun";
$sql .= " ,voucher_type";
$sql .= " ,concert_title_en";
$sql .= " ,concert_place";
$sql .= " ,concert_time";
$sql .= " ,concert_note";
$sql .= " ,qr_code_used";
$sql.=" ) values ( ";
$sql.=" '".$tab."' ";
$sql.=" ,'".$gdt."' ";
$sql.=" ,'".$b_uid."' ";
$sql.=" , '".$m_uid."' ";
$sql.=" , '".$s_uid."' ";
$sql.=" , '".$pm_uid."' ";
$sql.=" , '".$ps_uid."' ";
$sql.=" , '".$Bidx."' ";
$sql.=" , '".$Cidx."' ";
$sql.=" , '".$Gidx."' ";
$sql.=" , '".$NationName."' ";
$sql.=" , '".$CityName."' ";
$sql.=" , '".$InfoTitle."' ";
$sql.=" , '".$g_no."' ";
$sql.=" , '".$g_title."' ";
$sql.=" , '".Fnc_GetRes()."' ";
$sql.=" , '".$g_type_str."' ";
$sql.=" , '".$g_api_str."' ";
$sql.=" , '".$g_sch."' ";
#$sql.=" , '".$g_vno."' ";
#$sql.=" , '".$g_low."' ";
#$sql.=" , '".$g_high."' ";
$sql.=" , '".$up_img1."' ";
$sql.=" , '".$up_img3."' ";
#$sql.=" , '".$ReturnFile2."' ";
$sql.=" , '".$g_brief."' ";
$sql.=" , '".$g_short_brief."' ";
$sql.=" , '".$g_explain."' ";
$sql.=" , '".$g_inclusion."' ";
$sql.=" , '".$g_noinclusion."' ";
$sql.=" , '".$g_special."' ";
$sql.=" , '".$g_rule."' ";
$sql.=" , '".$g_heed."' ";
$sql.=" , '".$g_ready."' ";
$sql.=" , now() ";
$sql.=" , '".$g_meeting."' ";
// $sql.=" , '".$g_stock_type."' ";
$sql.=" , '".$map_x."' ";
$sql.=" , '".$map_y."' ";
$sql.=" , '".$movie_i."' ";
$sql.=" , '".$admin_id."' ";
$sql.=" , '".$admin_nm."' ";
$sql.=" , '".$exchange_fg."' ";
$sql.=" , '".$exid."' ";
$sql.=" , '".$g_cautions."' ";
$sql.=" , '".$g_select_num."' ";
$sql.=" , '".$producer_id."' ";
$sql.=" , '".$producer_corp_nm."' ";
$sql.=" , '".$ticket_code."' ";
$sql.=" , '".$ticket_addr."' ";
$sql.=" , '".$ticket_exchange."' ";
$sql.=" , '".$ticket_expiry_date."' ";
$sql.=" , '".$g_viewtype."' ";
$sql.=" , '".$confirm_type."' "; // 확정방식
$sql.=" , '".$today_reserve."' "; // 당일예약가능여부
$sql.=" , '".$kind_code."' "; //투어종류
$sql.=" , '".$tour_code."' "; //투어코드
$sql.=" , '".$google_map."' "; //구글맵
$sql.=" , '".$g_special_mo."' "; //모바일용
$sql.=" , '".$g_cautions_mo."' "; //모바일용
$sql.=" , '".$g_rule_mo."' "; //모바일용
$sql.=" , '".$g_heed_mo."' "; //모바일용
$sql.=" , '".$api_reserve_type."' "; // API 예약 방식
$sql.=" , '".$api_coupang_product_id."' "; // 쿠팡 API 상품코드
$sql.=" , '".$api_coupang_travel_id."' "; // 쿠팡 API 상품코드
$sql.=" , '".$api_yanolja_product_id."' "; // 야놀자 API 상품코드
$sql.=" , '".$seo_keyword."' "; // SEO 키워드
$sql.=" , '".$seo_desc."' "; // SEO 설명
$sql.=" , '".$seo_contents_text."' "; // SEO 설명
$sql.=" , '".strtolower($seo_first_category_url)."' "; // SEO 설명
$sql.=" , '".strtolower($seo_second_category_url)."' "; // SEO 설명
$sql.=" , '".strtolower($seo_good_url)."' "; // SEO 설명
$sql.=" , '".$res_confirm_good_type."' "; // SEO 설명
$sql.=" , '".$product_info_value_1."' "; //
$sql.=" , '".$product_info_value_2."' "; //
$sql.=" , '".$product_info_value_3."' "; //
$sql.=" , '".$product_info_value_4."' "; //
$sql.=" , '".$product_info_value_5."' "; //
$sql.=" , '".$product_info_value_6."' "; //
$sql.=" , '".$uploadGoodDetailImg."' "; //
$sql.=" , '".$good_hashtag_id_list."' "; // SEO 설명
$sql .= " ,'".$mail_gubun."'"; // 결제 메일 분류
$sql .= " ,'".$voucher_type."'"; // 바우처 종류
$sql .= " ,'".$concert_title_en."'"; // 모바일 QR 코드 영문 상품명
$sql .= " ,'".$concert_place."'"; // 모바일 QR 코드 공연장소
$sql .= " ,'".$concert_time."'"; // 모바일 QR 코드 공연시간
$sql .= " ,'".$concert_note."'"; // 모바일 QR 코드 유의사항
$sql .= " ,'".$qr_code_used."'"; // 모바일 QR 코드 사용여부
$sql.=" ) ";
db_query($sql);
error_msg("document.location='index.html?{$_href}'","script");
// 상품노출 변경
}elseif($SqlType == "good_edit"){
// if(devCookie()){
// p($_POST);
// exit;
// }
if (!$g_uid) exit;
$soldOut = "N";
if($sold_out == 'on'){
$soldOut = "Y";
}
// 상품정보
$arr = good_list(" and g_uid='{$g_uid}' ");
$row = $arr[0];
//업로드 파일이 있으면 기존 파일 삭제
if($_FILES['g_image1']['name']) {
@unlink($upload.$row['g_image1']);
@unlink($upload_thum.$row['g_image1']);
//이미지 업로드
$up_img1 = @FileUploadName( "", $upload, $_FILES['g_image1']['tmp_name'], $_FILES['g_image1']['name'] ,"");//파일 업로드
make_thum($upload.$up_img1,$upload_thum.$up_img1);//이미지썸네일 생성
}
if($_FILES['g_image3']['name']) {
@unlink($upload.$row['g_image3']);
@unlink($upload_thum.$row['g_image3']);
//이미지 업로드
$up_img3 = @FileUploadName( "", $upload, $_FILES['g_image3']['tmp_name'], $_FILES['g_image3']['name'] ,"");//파일 업로드
make_thum($upload.$up_img3,$upload_thum.$up_img3);//이미지썸네일 생성
}
//상품 상세페이지 설명 이미지
$uploadGoodDetailImg = "";
if($_FILES['good_detail_img']['name']) {
@unlink($cf['path']."/FileData/good_detail_img/".$row['good_detail_img']);
$execute = explode(".", $_FILES['good_detail_img']['name']);
$execute = $execute[count($execute) - 1];
//이미지 업로드
if(move_uploaded_file($_FILES['good_detail_img']['tmp_name'],$cf['path']."/FileData/good_detail_img/".$g_uid.".".$execute)){
$uploadGoodDetailImg = $g_uid.".".$execute;
}
}
//b2b 파일
$uploadB2bPdf = $cf['path']."/FileData/b2b/good/";
if($_FILES['b2b_pdf_ko']['name']) {
@unlink($uploadB2bPdf.$row['b2b_pdf_ko']);
@unlink($uploadB2bPdf.$row['b2b_pdf_ko']);
//이미지 업로드
$b2b_pdf_ko = @FileUploadName( "", $uploadB2bPdf, $_FILES['b2b_pdf_ko']['tmp_name'], $_FILES['b2b_pdf_ko']['name'] ,"");//파일 업로드
}
if($_FILES['b2b_pdf_en']['name']) {
@unlink($uploadB2bPdf.$row['b2b_pdf_en']);
@unlink($uploadB2bPdf.$row['b2b_pdf_en']);
//이미지 업로드
$b2b_pdf_en = @FileUploadName( "", $uploadB2bPdf, $_FILES['b2b_pdf_en']['tmp_name'], $_FILES['b2b_pdf_en']['name'] ,"");//파일 업로드
}
if($_FILES['b2b_pdf_tw']['name']) {
@unlink($uploadB2bPdf.$row['b2b_pdf_tw']);
@unlink($uploadB2bPdf.$row['b2b_pdf_tw']);
//이미지 업로드
$b2b_pdf_tw = @FileUploadName( "", $uploadB2bPdf, $_FILES['b2b_pdf_tw']['tmp_name'], $_FILES['b2b_pdf_tw']['name'] ,"");//파일 업로드
}
if($_FILES['b2b_pdf_hk']['name']) {
@unlink($uploadB2bPdf.$row['b2b_pdf_hk']);
@unlink($uploadB2bPdf.$row['b2b_pdf_hk']);
//이미지 업로드
$b2b_pdf_hk = @FileUploadName( "", $uploadB2bPdf, $_FILES['b2b_pdf_hk']['tmp_name'], $_FILES['b2b_pdf_hk']['name'] ,"");//파일 업로드
}
if($_FILES['b2b_pdf_cn']['name']) {
@unlink($uploadB2bPdf.$row['b2b_pdf_cn']);
@unlink($uploadB2bPdf.$row['b2b_pdf_cn']);
//이미지 업로드
$b2b_pdf_cn = @FileUploadName( "", $uploadB2bPdf, $_FILES['b2b_pdf_cn']['tmp_name'], $_FILES['b2b_pdf_cn']['name'] ,"");//파일 업로드
}
// 상품특징아이콘
$g_type_str = "";
for($i=0,$j=1 ; $i<count($g_type_arr) ; $i++,$j++){
$g_type_str .= $g_type_arr[$i];
if ($j < count($g_type_arr)) $g_type_str .= ",";
}
// 외부연동아이콘
$g_api_str = "";
for($i=0,$j=1 ; $i<count($g_api_arr) ; $i++,$j++){
$g_api_str .= $g_api_arr[$i];
if ($j < count($g_api_arr)) $g_api_str .= ",";
}
// 데이투어항목추가(20131029.허종)
$day_price_nor_adult = str_replace(",","",$day_price_nor_adult);
$day_price_nor_child = str_replace(",","",$day_price_nor_child);
$day_price_dc_adult = str_replace(",","",$day_price_dc_adult);
$day_price_dc_child = str_replace(",","",$day_price_dc_child);
// 미팅장소,미팅시간
$g_meeting = "";
for($a=0 ; $a<count($meeting_place_arr) ; $a++) {
$meeting_place = $meeting_place_arr[$a];
$meeting_hh = $meeting_hh_arr[$a];
$meeting_mm = $meeting_mm_arr[$a];
if($meeting_place_arr[$a]) {
$g_meeting .= "||".$meeting_place."^".$meeting_hh."^".$meeting_mm;
}
}
// 담당자
if ($admin_id) {
$mem_data = get_member($admin_id);
$admin_nm = $mem_data['mb_nm'];
}
// 국가명
$country_arr = to_area_b("",$Bidx," and DelFlag='N' ");
$NationName = $country_arr[0]['NationName'];
// 도시명
$city_arr = to_area_c("",$Bidx,$Cidx,"N");
$CityName = $city_arr[0]['CityName'];
// 공급처
if ($producer_id) {
$mem_data = get_member($producer_id);
$producer_corp_nm = $mem_data['bz_corp_nm'];
}
//관련상품
for($i=1;$i<6;$i++) {
$idx = ${"idx".$i};
$b_uid_r = ${"b_uid".$i};
$data_bc_r = TO_get_bc($b_uid_r,"N","");
$tab_r = $data_bc_r[0]['tab']; //tab
$m_uid_r = ${"m_uid".$i};
$s_uid_r = ${"s_uid".$i};
$r_uid = ${"g_uid".$i};
$ordernum = ${"related_ordernum_arr".$i};
if($b_uid_r) {
if($idx) {
$sql= " UPDATE TB_GOOD_RELATED SET ";
$sql.=" tab='".$tab_r."' ";
$sql.=" ,b_uid='".$b_uid_r."' ";
$sql.=" ,m_uid='".$m_uid_r."' ";
$sql.=" ,s_uid='".$s_uid_r."' ";
$sql.=" ,r_uid='".$r_uid."' ";
$sql.=" ,ordernum='".$ordernum."' ";
$sql.=" WHERE idx='".$idx."' ";
} else {
$sql = "insert into TB_GOOD_RELATED ( ";
$sql.=" tab ";
$sql.=" , g_uid ";
$sql.=" , b_uid ";
$sql.=" , m_uid ";
$sql.=" , s_uid ";
$sql.=" , r_uid ";
$sql.=" , ordernum ";
$sql.=" ) values ( ";
$sql.=" '".$tab_r."' ";
$sql.=" ,'".$g_uid."' ";
$sql.=" ,'".$b_uid_r."' ";
$sql.=" , '".$m_uid_r."' ";
$sql.=" , '".$s_uid_r."' ";
$sql.=" , '".$r_uid."' ";
$sql.=" , '".$ordernum."' ";
$sql.=" ) ";
}
db_query($sql);
}
}
$sql= " UPDATE ".$table." SET ";
$sql.=" b_uid='".$b_uid."' ";
$sql.=" ,m_uid='".$m_uid."' ";
$sql.=" ,s_uid='".$s_uid."' ";
$sql.=" ,pm_uid='".$pm_uid."' ";
$sql.=" ,ps_uid='".$ps_uid."' ";
$sql.=" ,tab='".$tab."' ";
$sql.=" ,Bidx='".$Bidx."' ";
$sql.=" ,Cidx='".$Cidx."' ";
$sql.=" ,pseq='".$pseq."' ";
$sql.=" ,NationName='".$NationName."' ";
$sql.=" ,CityName='".$CityName."' ";
$sql.=" ,InfoTitle='".$InfoTitle."' ";
$sql.=" ,g_title='".$g_title."' ";
$sql.=" ,g_title_en='".$g_title_en."' ";
$sql.=" ,g_no='".$g_no."' ";
$sql.=" ,g_code='".$g_code."' ";
$sql.=" ,g_type='".$g_type_str."' ";
$sql.=" ,g_api='".$g_api_str."' ";
$sql.=" ,gdt='".$gdt."' ";
//$sql.=" ,g_vno='".$g_vno."' ";
$sql.=" ,g_sch='".$g_sch."' ";
//$sql.=" ,g_low='".$g_low."' ";
//$sql.=" ,g_high='".$g_high."' ";
if($up_img1) $sql.=" ,g_image1='".$up_img1."' ";
if($up_img3) $sql.=" ,g_image3='".$up_img3."' ";
if($b2b_pdf_ko) $sql .= " , b2b_pdf_ko = '".$b2b_pdf_ko."' ";
if($b2b_pdf_en) $sql .= " , b2b_pdf_en = '".$b2b_pdf_en."' ";
if($b2b_pdf_tw) $sql .= " , b2b_pdf_tw = '".$b2b_pdf_tw."' ";
if($b2b_pdf_hk) $sql .= " , b2b_pdf_hk = '".$b2b_pdf_hk."' ";
if($b2b_pdf_cn) $sql .= " , b2b_pdf_cn = '".$b2b_pdf_cn."' ";
$sql .= ", concert_title_en = '{$concert_title_en}'";
$sql .= ", concert_place = '{$concert_place}'";
$sql .= ", concert_time = '{$concert_time}'";
$sql .= ", concert_note = '{$concert_note}'";
$sql .= ", qr_code_used = '{$qr_code_used}'";
$sql .= ", sold_out = '{$soldOut}'";
//$sql.=" ,g_image2='".$ReturnFile2."' ";
$sql.=" ,g_brief='".$g_brief."' ";
$sql.=" ,g_short_brief='".$g_short_brief."' ";
$sql.=" ,g_explain='".$g_explain."' ";
$sql.=" ,g_inclusion='".$g_inclusion."' ";
$sql.=" ,g_noinclusion='".$g_noinclusion."' ";
$sql.=" ,g_special='".$g_special."' ";
$sql.=" ,g_rule='".$g_rule."' ";
$sql.=" ,g_heed='".$g_heed."' ";
$sql.=" ,g_ready='".$g_ready."' ";
$sql.=" ,g_meeting='".$g_meeting."' ";
// $sql.=" ,g_stock_type='".$g_stock_type."' ";
//$sql.=" ,map_x='".$map_x."' ";
//$sql.=" ,map_y='".$map_y."' ";
$sql.=" ,movie_i='".$movie_i."' ";
$sql.=" ,admin_id='".$admin_id."' ";
$sql.=" ,admin_nm='".$admin_nm."' ";
$sql.=" ,g_cautions='".$g_cautions."' ";
$sql.=" ,g_select_num='".$g_select_num."' ";
$sql.=" ,producer_id='".$producer_id."' ";
$sql.=" ,producer_corp_nm='".$producer_corp_nm."' ";
$sql.=" ,ticket_code='".$ticket_code."' ";
$sql.=" ,ticket_addr='".$ticket_addr."' ";
$sql.=" ,ticket_exchange='".$ticket_exchange."' ";
$sql.=" ,ticket_expiry_date='".$ticket_expiry_date."' ";
$sql.=" ,g_viewtype='".$g_viewtype."' ";
$sql.=" ,confirm_type='".$confirm_type."' "; //확정방식
$sql.=" ,today_reserve='".$today_reserve."' "; //당일예약가능여부
$today_reserve_time = (int) $today_reserve_time;
$sql.=" ,today_reserve_time='".$today_reserve_time."' "; //예약 불가 전 시간
$sql.=" ,g_moddate=now() ";
$sql.=" ,kind_code='".$kind_code."' "; //투어종류
$sql.=" ,tour_code='".$tour_code."' "; //투어코드
$sql.=" ,google_map='".$google_map."' "; //구글맵
$sql.=" ,g_special_mo='".$g_special_mo."' "; //모바일용
$sql.=" ,g_cautions_mo='".$g_cautions_mo."' "; //모바일용
$sql.=" ,g_rule_mo='".$g_rule_mo."' "; //모바일용
$sql.=" ,g_heed_mo='".$g_heed_mo."' "; //모바일용
$sql.=" ,purchase_cnt='".$purchase_cnt."' "; //구매건수
$sql.=" ,seo_keyword='".$seo_keyword."' "; //seo 키워드
$sql.=" ,seo_desc='".$seo_desc."' "; //seo 설명
$sql.=" ,seo_contents_text='".$seo_contents_text."' "; //seo 컨텐츠 텍스트
$sql.=" ,tour_division='".$tour_division."' "; //투어 분류
$sql.=" ,tour_exists_guide='".$tour_exists_guide."' "; //가이드 유무
$sql.=" ,seo_first_category_url='".strtolower($seo_first_category_url)."' "; //seo 1차 카테고리
$sql.=" ,seo_second_category_url='".strtolower($seo_second_category_url)."' "; //seo 1차 카테고리
$sql.=" ,seo_good_url='".strtolower($seo_good_url)."' "; //seo 상품명
$sql.=" ,good_hashtag_id='".$good_hashtag_id_list."' "; //해시태그 이미지
$sql.=" ,res_confirm_good_type='".$res_confirm_good_type."' "; //예약 확정인지 대기인지 유무
// if(devCookie()){
$sql.=" ,benepia_region_cd='".$benepia_region_cd."' "; // 상품 지역
$sql.=" ,benepiaTelNo='".$benepiaTelNo."' "; // 상품 연락처
$sql.=" ,benepiaZipCd='".$benepiaZipCd."' "; // 여행지 우편번호
$sql.=" ,benepiaAddress='".$benepiaAddress."' "; // 여행지 주소
$sql.=" ,benepiaDetailAddress='".$benepiaDetailAddress."' "; // 여행지 상세주소
$sql.=" ,benepiaGoodUrl='".$benepiaGoodUrl."' "; // 여행지 홈페이지
// }
$sql.=" , product_info_label_1 = '{$product_info_label_1}'";
$sql.=" , product_info_label_2 = '{$product_info_label_2}'";
$sql.=" , product_info_label_3 = '{$product_info_label_3}'";
$sql.=" , product_info_label_4 = '{$product_info_label_4}'";
$sql.=" , product_info_label_5 = '{$product_info_label_5}'";
$sql.=" , product_info_label_6 = '{$product_info_label_6}'";
$sql.=" , product_info_value_1 = '{$product_info_value_1}'";
$sql.=" , product_info_value_2 = '{$product_info_value_2}'";
$sql.=" , product_info_value_3 = '{$product_info_value_3}'";
$sql.=" , product_info_value_4 = '{$product_info_value_4}'";
$sql.=" , product_info_value_5 = '{$product_info_value_5}'";
$sql.=" , product_info_value_6 = '{$product_info_value_6}'";
$sql.=" ,api_reserve_type='".$api_reserve_type."' "; // API 예약방식
$sql.=" ,api_smart_store_reserve_type='".$api_smart_store_reserve_type."' "; // 네이버 스마트스토어 API 예약방식
$sql.=" ,api_coupang_product_id='".$api_coupang_product_id."' "; // 쿠팡 API 상품코드
$sql.=" ,api_coupang_travel_id='".$api_coupang_travel_id."' "; // 쿠팡 API 상품코드
$sql.=" ,api_yanolja_product_id='".$api_yanolja_product_id."' "; // 야놀자 API 상품코드
$creatrip_mail_good_name = trim($creatrip_mail_good_name);
$sql.=" ,creatrip_mail_good_name='".$creatrip_mail_good_name."' "; // 크리에이트립 메일 내용
$trazy_mail_good_name = trim($trazy_mail_good_name);
$sql.=" ,trazy_mail_good_name='".$trazy_mail_good_name."' "; // 트레이지 메일 내용
$klook_mail_good_name = trim($klook_mail_good_name);
$sql.=" ,klook_mail_good_name='".$klook_mail_good_name."' "; // klook 메일 내용
$kkday_mail_good_name = trim($kkday_mail_good_name);
$sql.=" ,kkday_mail_good_name='".$kkday_mail_good_name."' "; // kkday 메일 내용
if($uploadGoodDetailImg){
$sql.=" ,good_detail_img='".$uploadGoodDetailImg."' "; // kkday 메일 내용
}
if($schedule_tour_statics_view == 'on'){
$sql.=" ,schedule_tour_statics_view = 'Y' "; //일별출발인원 연동함.
}else{
$sql.=" ,schedule_tour_statics_view = 'N' "; //일별출발인원 연동안함.
}
$sql .= " ,mail_gubun='{$mail_gubun}'"; // 메일분류
$sql .= " ,voucher_type='{$voucher_type}'"; // 바우처 종류
$sql.=" WHERE g_uid='".$g_uid."' ";
// if(devCookie()){
// p($sql);
// exit;
// }
db_query($sql);
$cate3 ='';
$cate4 ='';
if($etbs_category == 'A06A09A05') {
$cate3 = '숙박';
} else if($etbs_category == 'A06A09A10') {
$cate3 = '제주여행';
} else if($etbs_category == 'A06A09A07') {
$cate3 = '테마여행';
} else if($etbs_category == 'A06A09A19') {
$cate3 = '레저티켓';
}
if($etbs_category2 == 'A06A09A05A01') {
$cate4 = '호텔';
} else if($etbs_category2 == 'A06A09A05A02') {
$cate4 = '리조트';
} else if($etbs_category2 == 'A06A09A05A03') {
$cate4 = '펜션';
} else if($etbs_category2 == 'A06A09A10A01') {
$cate4 = '숙박';
} else if($etbs_category2 == 'A06A09A10A02') {
$cate4 = '렌터카';
} else if($etbs_category2 == 'A06A09A10A03') {
$cate4 = '패키지';
} else if($etbs_category2 == 'A06A09A10A04') {
$cate4 = '관광지 입장권';
} else if($etbs_category2 == 'A06A09A07A09') {
$cate4 = '내륙여행';
}
//E-제너두 파일 저장
$etbs_sql = "INSERT INTO etbsData (g_uid, class, cate3, cate4, caid3, caid4, tourfr, tourto, regdate)";
$etbs_sql .= " VALUES ('$g_uid', '$etbs_type', '$cate3', '$cate4', '$etbs_category', '$etbs_category2', '$tourfr', '$tourto', NOW())";
$etbs_sql .= " ON DUPLICATE KEY UPDATE
class = VALUES(class),
cate3 = VALUES(cate3),
cate4 = VALUES(cate4),
caid3 = VALUES(caid3),
caid4 = VALUES(caid4),
tourfr = VALUES(tourfr),
tourto = VALUES(tourto),
regdate = VALUES(regdate)";
db_query($etbs_sql);
error_msg("document.location='good_edit.html?tab={$tab}&{$_href}&g_uid={$g_uid}'","script");
// 상품노출 변경
}elseif ($SqlType == "chgdisp") {
if(!$g_uid) exit;
$sql = "update {$table} set g_ok='{$g_ok}' where g_uid='{$g_uid}' ";
db_query($sql);
$data = good_list(" and g_uid='{$g_uid}' ");
$row = $data[0];
echo "<img src=\"{$row[use_img]}\" onClick=\"ajax_obj_loader('good_proc.php?SqlType=chgdisp&g_uid={$row[g_uid]}&g_ok={$row[g_ok_opp]}','disp_yn_{$row[g_uid]}');\" />";
exit;
//관광(지)정보 순서변경
}else if($SqlType=="change_ordernum"){
for($i=0 ; $i < count($g_uid_arr) ; $i++){
$sql = "update {$table} set g_no='{$g_no_arr[$i]}' where g_uid='$g_uid_arr[$i]'";
db_query($sql);
}
error_msg("document.location.reload()","script");
}else if($SqlType == "chgrecomm"){
if(!$g_uid)exit;
$data = good_list(" and g_uid='{$g_uid}' ");
$row = $data[0];
// 현상태에서 반대로 만들기
$gmain_opp = "";
if($row[$gmain] != "1") $gmain_opp = 1;
$sql = "update {$table} set {$gmain} = '{$gmain_opp}' where g_uid='{$g_uid}' ";
db_query($sql);
exit;
//호텔이미지 수정
}else if($SqlType=="gallery_edit"){
if(!is_array($chkall))exit;
for($i=0 ; $i<count($chkall) ; $i++){
$iDX = $chkall[$i];
$ImgMemo = ${"ImgMemo_".$chkall[$i]};
$ImgType = ${"ImgType_".$chkall[$i]};
$OrderNum = intval(${"ordernum_".$chkall[$i]});
$sql = "update TB_GoodImg set ImgType='{$ImgType}', ImgMemo='{$ImgMemo}',OrderNum='{$OrderNum}' where iDX='{$iDX}'";
db_query($sql);
}
error_msg("document.location.reload()","script");
// 갤러리 이미지 삭제
}elseif($SqlType=="gallery_delete"){
if(!is_array($chkall))exit;
$upload = "../../FileData/good_img/";
$upload_thum = "../../FileData/good_img_thum/";
for($i=0 ; $i<count($chkall) ; $i++){
$iDX = $chkall[$i];
$img = ${"img_".$chkall[$i]};
//해당이미지삭제
@unlink($upload.$img);
@unlink($upload_thum.$img);
$sql = "delete from TB_GoodImg where iDX='{$iDX}'";
db_query($sql);
}
error_msg("document.location.reload()","script");
// 상품 삭제
}elseif($SqlType=="delete_good"){
if(!$g_uid) exit;
$upload = "../../FileData/good_img/";
$upload_thum = "../../FileData/good_img_thum/";
// 출발일(date)
$sql = "delete from date where g_uid='{$g_uid}' ";
db_query($sql);
// 선택호텔(TB_SelHotel)
$sql = "delete from TB_SelHotel where g_uid='{$g_uid}' ";
db_query($sql);
// 기본 일정표(TB_Schedule)
$sql = "delete from TB_Schedule where g_uid='{$g_uid}' ";
db_query($sql);
// 선택여행정보(TB_SelInfo)
$sql = "delete from TB_SelInfo where g_uid='{$g_uid}' ";
db_query($sql);
// 갤러리(TB_GoodImg) and 이미지
$gallery_arr = TO_get_good_photo($g_uid);
for($i=0 ; $i<count($gallery_arr) ; $i++){
$arr = $gallery_arr[$i];
@unlink($upload.$arr['ImgTitle']); // 이미지 삭제
@unlink($upload_thum.$arr['ImgTitle']); // 썸네일이미지 삭제
}
$sql = "delete from TB_GoodImg where Gidx='{$g_uid}' ";
db_query($sql);
// 상품(good) and 이미지
$img_arr = db_fetch("select g_image1 from good where g_uid='{$g_uid}' ");
@unlink($upload.$img_arr['g_image1']); // 이미지 삭제
$sql = "delete from good where g_uid='{$g_uid}' ";
db_query($sql);
error_msg("document.location.reload()","script");
}
// 상품카피
elseif($SqlType=="good_copy") {
if(!$b_uid or !$g_uid) exit;
// 상품정보 복사
$arr = good_list(" and g_uid='{$g_uid}' ");
$row = $arr[0];
// 대표 이미지 복사(2016.07.19)
$new_fn = "";
if($row['g_image1']) {
// 이미지명 새로생성
$new_fn = getUniqueFileName($row['g_image1']);
// 이전이미지
$orig_path = $upload.$row['g_image1'];
$orig_path_thum = $upload_thum.$row['g_image1'];
// 새이미지
$new_path = $upload.$new_fn;
$new_path_thum = $upload_thum.$new_fn;
@exec("cp -p {$orig_path} {$new_path}");
@exec("cp -p {$orig_path_thum} {$new_path_thum}");
}
$gdt = ($row['gdt']) ? $row['gdt']:"gr";
$sql= " insert into ".$table." set ";
$sql.=" tab='".$tab."' ";
$sql.=" ,gdt='".$row['gdt']."' ";
$sql.=" ,b_uid='".$b_uid."' ";
$sql.=" ,m_uid='".$m_uid."' ";
$sql.=" ,s_uid='".$s_uid."' ";
$sql.=" ,Bidx='".$row['Bidx']."' ";
$sql.=" ,Cidx='".$row['Cidx']."' ";
$sql.=" ,pseq='".$row['pseq']."' ";
$sql.=" ,NationName='".$row['NationName']."' ";
$sql.=" ,CityName='".$row['CityName']."' ";
$sql.=" ,InfoTitle='".$row['InfoTitle']."' ";
$sql.=" ,g_no='".$row['g_no']."' ";
$sql.=" ,g_title='".$row['g_title']."' ";
$sql.=" ,g_code='".Fnc_GetRes()."' ";
//$sql.=" ,g_type='".$row['g_type']."' ";
$sql.=" ,g_sch='".$row['g_sch']."' ";
//$sql.=" ,g_image1='".$row['g_image1']."' ";
$sql.=" ,g_image1='{$new_fn}'"; // - 원본과 정보를 공유해서 복사하지 않기로 설정함.
$sql.=" ,g_brief='".str_replace("'","'",$row['g_brief'])."' ";
$sql.=" ,g_explain='".str_replace("'","'",$row['g_explain'])."' ";
$sql.=" ,g_inclusion='".str_replace("'","'",$row['g_inclusion'])."' ";
$sql.=" ,g_noinclusion='".str_replace("'","'",$row['g_noinclusion'])."' ";
$sql.=" ,g_special='".str_replace("'","'",$row['g_special'])."' ";
$sql.=" ,g_special_mo='".str_replace("'","'",$row['g_special_mo'])."' "; //모바일용
$sql.=" ,g_rule='".str_replace("'","'",$row['g_rule'])."' ";
$sql.=" ,g_rule_mo='".str_replace("'","'",$row['g_rule_mo'])."' "; //모바일용
$sql.=" ,g_heed='".str_replace("'","'",$row['g_heed'])."' ";
$sql.=" ,g_heed_mo='".str_replace("'","'",$row['g_heed_mo'])."' "; //모바일용
$sql.=" ,g_ready='".str_replace("'","'",$row['g_ready'])."' ";
$sql.=" ,map_x='".$row['map_x']."' ";
$sql.=" ,map_y='".$row['map_y']."' ";
$sql.=" ,admin_id='".$row['admin_id']."' ";
$sql.=" ,admin_nm='".$row['admin_nm']."' ";
//바텍 상품
if($b_uid == 158 || $b_uid == 159 || $b_uid == 160 || $b_uid == 161){
$sql.=" ,welfare='vatech' ";
}
$sql.=" ,exchange_fg='".$row['exchange_fg']."' ";
$sql.=" ,exid='".$row['exid']."' ";
$sql.=" ,g_cautions='".str_replace("'","'",$row['g_cautions'])."' ";
$sql.=" ,g_cautions_mo='".str_replace("'","'",$row['g_cautions_mo'])."' "; //모바일용
$sql.=" ,g_select_num='".$row['g_select_num']."' ";
$sql.=" ,g_regdate=now() ";
db_query($sql);
$gid = db_insert_id();
// 여행정보 복사
$arr = TO_get_info($g_uid);
for ($i=0 ; $i<count($arr) ; $i++) {
$row = $arr[$i];
$sql = "insert into TB_SelInfo set ";
$sql .= "g_uid='{$gid}' ";
$sql .= ",Bidx='".$row['Bidx']."'";
$sql .= ",Cidx='".$row['Cidx']."'";
$sql .= ",Gidx='".$row['Gidx']."'";
$sql .= ",pseq='".$row['pseq']."'";
$sql .= ",Tpe='".$row['Tpe']."'";
$sql .= ",InfoTitle='".$row['InfoTitle']."'";
$sql .= ",SortType='".$row['SortType']."'";
$sql .= ",RegDate=now()";
db_query($sql);
}
// 호텔정보 복사
$arr = TO_get_hotel($g_uid);
for ($i=0 ; $i<count($arr) ; $i++) {
$row = $arr[$i];
$sql = "insert into TB_SelHotel set ";
$sql .= "g_uid='{$gid}' ";
$sql .= ",Bidx='".$row['Bidx']."'";
$sql .= ",Cidx='".$row['Cidx']."'";
$sql .= ",hseq='".$row['hseq']."'";
$sql .= ",HGoods_Code='".$row['HGoods_Code']."'";
$sql .= ",RegDate=now()";
db_query($sql);
}
// 갤러리 카피
$data_gallery=TO_get_good_photo($g_uid);
if(is_array($data_gallery)){ foreach($data_gallery as $v) {
$img=$v['img'];
// 이미지명 새로생성
$new_fn = getUniqueFileName($img);
// 이전이미지
$orig_path = $upload.$img;
$orig_path_thum = $upload_thum.$img;
// 새이미지
$new_path = $upload.$new_fn;
$new_path_thum = $upload_thum.$new_fn;
@exec("cp -p {$orig_path} {$new_path}");
@exec("cp -p {$orig_path_thum} {$new_path_thum}");
$sql="insert into TB_GoodImg set Gidx='{$new_seq}',ImgType='{$v[ImgType]}',ImgTitle='{$new_fn}',ImgMemo='{$v[ImgMemo]}',RegDate=now()";
db_query($sql);
}}
error_msg("document.location.reload()","script");
}//구글맵수정
elseif($SqlType=="good_map_edit"){
if(!$g_uid) exit;
$sql = "update {$table} set map_x='{$map_x}' , map_y='{$map_y}' where g_uid='{$g_uid}' ";
db_query($sql);
error_msg("document.location.reload();","script");
}
// 사용수정
elseif($SqlType=="g_ok_updt"){
if(!$g_ok) exit;
for($i=0 ; $i<count($guid_arr) ; $i++){
$g_uid = $guid_arr[$i];
if($g_uid){
db_query("update {$table} set g_ok='{$g_ok}' where g_uid='{$g_uid}' ");
}
}
error_msg("document.location.reload();","script");
}
/**
* by taeyoung
* 2022.06.15
* SEO 키워드, 디스크립션, 이미지 수정
*/
else if($SqlType=="good_seo_edit"){
if(!$g_uid){
exit;
}
// p($_FILES);
// p($_POST);
// echo 'name is '.$_FILES['name'];
if($_FILES['sns_share_img']['name']) {
//이미지 업로드
$up_img1 = FileUploadName( "", $upload, $_FILES['sns_share_img']['tmp_name'], $_FILES['sns_share_img']['name'] ,"");//파일 업로드
make_thum($upload.$up_img1,$upload_thum.$up_img1);//이미지썸네일 생성
$sql = "UPDATE {$table} SET sns_share_img ='{$up_img1}' where g_uid='{$g_uid}'";
db_query($sql);
}
if($g_uid){
$sql = "UPDATE {$table} SET seo_keyword ='{$seo_keyword}', seo_desc = '{$seo_desc}', seo_contents_text = '{$seo_contents_text}' where g_uid='{$g_uid}'";
/*if(devCookie()){
p($sql);
exit;
}*/
if(db_query($sql)){
}else{
echo "failed";
exit;
}
}
// error_msg("document.location.reload();","script");
echo "<script>location.href='/toadmin/good/good_seo.html?{$params}'</script>";
}
?>