|
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 : |
<?php
/*
* [son]B2B 대리점 예약 관련
*/
include "../include/top_proc.html";
if(empty($mode)) exit;
$class_v = new CommonTour();
$class_AccountCustomer = new AccountCustomer();
$B2b = new B2b();
$langInfo = $B2b->langInfo();
//예약가능인원, 정상가, 대리점 할인가
if($mode=='goodPriceData') {
$res['msg'] = '';
$res['data'] = '';
$res['optionHtml'] = '';
if(empty($g_uid) || empty($dtid) || empty($date_s1)) return;
$data = $B2b->dateEventInfo($g_uid,$dtid,$date_s1);
if(empty($data['adultPriceAgency'])) {
$res['msg'] = _e2('대리점의 가격정보가 없습니다.');
echo json_encode($res);
exit;
}
$res['data'] = json_encode($data);
echo json_encode($res);
exit;
}
/*
* 예약등록
* 기존의 예약과 동일한 로직 유지
*/
else if($mode=='saveReservation') {
$res['msg'] = '';
$res['res'] = '';
$res['check'] = '';
$table = "TB_RES_GOOD";
/*
* gdt_pe_check : 단독투어 상품 여부 체크
* 데이투어(tab:D) > 단독투어(gdt:pe)
*/
if($gdt_pe_check=='y') {
$adultNum = $daesuAdultNum; //승객수
$childNum = $babyNum = $infantNum = 0;
}
$allNum = $adultNum+$childNum+$babyNum+$infantNum;
if($allNum==0) {
$res['msg'] = _e2('인원수를 확인해 주세요.');
echo json_encode($res);
exit;
}
if($TK_MEMBER['mb_level']!=$cf['agent_level']) {
$res['msg'] = _e2('대리점 회원만 이용가능합니다.');
echo json_encode($res);
exit;
}
$agent_id = $TK_MEMBER['mb_id'];
$memInfo = get_member($agent_id); // 대리점 상세 정보
$agent_corp_nm = $memInfo['bz_corp_nm'];
$cf['curunit'] = $curunit; //[필수]함수내 일부 값 외환 변경 //대리점이 아닐 경우 KRW로만 출력됨
// 상품정보
$data_good = good_list(" and g_uid='{$g_uid}' ");
$row_good = $data_good[0];
// 행사 정보
$data_date = date_list($g_uid , "none" , " and dtid='{$dtid}' and d_start='{$date_s1}' ");
$row_date = date_list_replace($data_date[0]);
// 출발장소(신규)
if($poid) {
$data_depot = good_depot($g_uid,"Y",$poid);
$depot_nm = $data_depot[0]['depot_nm'];
}
// 예약가능한지 체크
if ($row['reserv_yn']=="N") {
$res['msg'] = _e2("이미 마감된 행사입니다.");
echo json_encode($res);
exit;
}
// 환율정보(2016-12-28.허종) ////현재 모든 상품에 환율 적용되어 있지 않고 사용하지 않는게 원칙이니 실제론 필요없음
$ext_str = "";
if($row_good['exchange_fg']=="Y") {
//$class_v = new CommonTour();
$data_ex = $class_v->exchangeList(array("sql_where"=>" and exid='{$row_good[exid]}' "));
$row_ex = $data_ex[0];
// 화폐한글명||화폐영문||화폐기호||화폐교환 원(KRW)||1000원단위,100원단위||올림(A)반올림(R)버림(L)
$ext_str = sprintf("%s||%s||%s||%s||%s||%s",$row_ex['ext_nm'],$row_ex['ext_eng'],$row_ex['ext_mark'],$row_ex['ext_to_krw'],$row_ex['ext_unit'],$row_ex['ext_round']);
}
if($gdt_pe_check=='y') { //단독투어
$adult_price_normal = $adultPrice; //정상가
$adult_price = $adultPriceAgency; //대리점가
$adult_price_fr = $class_v->exchangeMoney_Reverse(array("ext_eng"=>$curunit,"money"=>$adult_price));
$tot_adult = (int)$adult_price * (int)$daesu;
$tot_adult_fr = (int)$adult_price_fr * (int)$daesu;
$sales_total = $tot_adult;
$sales_total_fr = $tot_adult_fr;
} else {
//금액계산 //res_GoodDateCalculate()함수와 동일하게 전체금액을 환율변환하지 않고 fr금액에 인원수를 곱함
$personArr = $B2b->personArr;
$sales_total = $sales_total_fr = 0;
foreach($personArr as $k=>$v) {
${$k.'_inwon'} = ${$k.'Num'}; //인원수
${$k.'_price_normal'} = ${$k.'Price'}; //정상가
${$k.'_price'} = ${$k.'PriceAgency'}; //대리점가
${$k.'_price_fr'} = $class_v->exchangeMoney_Reverse(array("ext_eng"=>$curunit,"money"=>${$k.'_price'}));
${'tot_'.$k} = (int)${$k.'_price'} * (int)${$k.'Num'};
${'tot_'.$k.'_fr'} = (int)${$k.'_price_fr'} * (int)${$k.'Num'};
$sales_total += ${'tot_'.$k};
$sales_total_fr += ${'tot_'.$k.'_fr'};
}
}
//2019-10-18 옵션상품 저장
$data_option = $row_date['good_option_all'];
if(!empty($data_option)) {
$option_price = $option_price_fr = 0; //옵션총금액
foreach($data_option as $k=>$v) {
$i = array_search($v['opid'], $opid_arr);
$opid = $opid_arr[$i];
$op_num = $op_num_arr[$i];
//$op_price_sell_fr = $class_v->exchangeMoney_Reverse(array("ext_eng"=>$curunit,"money"=>$v['op_price_sell']));
//$option_price_fr += (int)$op_price_sell_fr * (int)$op_num;
//위 $cf['curunit'] 값에 따라 옵션 환율 가격이 변하므로 굳이 변환할 필요는 없다.
$option_price_fr += (int)$v['op_price_sell_fr'] * (int)$op_num;
$option_price += (int)$v['op_price_sell'] * (int)$op_num;
$sql = "insert into {$table}_OPTION set ";
$sql .= " res_no='{$res_no}', ";
$sql .= " g_uid='{$g_uid}', ";
$sql .= " g_title='{$row_good['g_title']}', ";
$sql .= " opid='{$opid}', ";
$sql .= " op_nm='{$v['op_nm']}', ";
$sql .= " op_price_cost='{$v['op_price_cost']}', ";
$sql .= " op_price_sell='{$v['op_price_sell']}', ";
$sql .= " op_price_sell_fr='{$v['op_price_sell_fr']}', "; //
$sql .= " op_price_agent='{$v['op_price_sell']}', "; //옵션상품엔 별도의 대리점 금액이 없어서 대리점 예약일땐 기존 가격을 등록
$sql .= " op_num='{$op_num}', ";
$sql .= " ins_dt = now(), ";
$sql .= " lang = '{$lang}',"; //
$sql .= " curunit = '{$curunit}'"; //
$sql .= " , hwan = '{$ext_to_krw}'"; //
db_query($sql);
}
$sales_total += $option_price;
$sales_total_fr += $option_price_fr;
}
// 동행자 저장
$personNum = array($adultNum,$childNum,$babyNum,$infantNum);
$chk = 0;
foreach($personNum as $k=>$v) {
for($i=0;$i<$v;$i++) {
if($k==0) {
$generation = 'A';
} else if($k==1) {
$generation = 'C';
} else if($k==2) {
$generation = 'B';
} else if($k==3) {
$generation = 'I';
}
$sql = "insert into {$table}_PERSON set ";
$sql .= " res_no='{$res_no}', ";
$sql .= " tab='{$row_good['tab']}', ";
$sql .= " g_uid='{$g_uid}', ";
$sql .= " g_title='{$row_good['g_title']}', ";
$sql .= " ev_uid='{$row_date['d_uid']}', ";
$sql .= " ev_title='{$row_date['d_title']}', ";
$sql .= " ev_start='{$row_date['d_start']}', ";
$sql .= " ev_end='{$row_date['d_end']}', ";
$sql .= " generation='{$generation}', ";
if($chk==0) { //첫번째에 회원정보 추가
$sql .= " gend='{$gend}', ";
$sql .= " name_kor='{$name_kor}', ";
$sql .= " name_eng='{$name_eng1}||{$name_eng2}', ";
$sql .= " hp='{$hp}', ";
$sql .= " tel='{$tel}', ";
$sql .= " jumin='{$jumin}', ";
$sql .= " passenger_num='{$passenger_num}', ";
$sql .= " birth_dt='{$birth_dt}', ";
$sql .= " poid='{$poid}', "; //탑승 장소 및 시간
$sql .= " depot_nm='{$depot_nm}', ";
}
$sql .= " ins_dt=now() ";
db_query($sql);
$chk++;
}
}
// 진행전달 & 예약확정 & 예약취소 연동(2017-05-12.허종)
//예약과 동시에 확정으로 수정
$order_state = "B"; // 예약확정
$row_date['res_stat_cd']="C";
//2019-10-18 sales_total USD
$total_pay_usd = $class_v->exchangeMoney_Reverse(array("ext_eng"=>"USD","money"=>$sales_total));
//2019-11-26 실무용 바우처번호 생성
$rsv_no = auto_create_voucher($row_good[tab]);
// 2019-10-18 예약 마스터 저장
$sql = "insert into {$table} set ";
$sql .= "res_no='{$res_no}', ";
$sql .= "rsv_no='{$rsv_no}', ";
$sql .= "g_uid='{$g_uid}', ";
$sql .= "g_title='{$row_good['g_title']}', ";
$sql .= "tab='{$row_good['tab']}', ";
$sql .= "gdt='{$row_good['gdt']}', ";
if($gdt_pe_check=='y') $sql .= " gdt_pe_daesu='{$daesu}', "; //대수
$sql .= "ev_uid='{$row_date['d_uid']}', ";
$sql .= "ev_title='{$row_date['d_title']}', ";
$sql .= "ev_start='{$row_date['d_start']}', ";
$sql .= "ev_end='{$row_date['d_end']}', ";
$sql .= "adult_price='{$adult_price}', "; //
$sql .= "child_price='{$child_price}', "; //
$sql .= "baby_price='{$baby_price}', "; //
$sql .= "infant_price='{$infant_price}', "; //
$sql .= "adult_price_fr='{$adult_price_fr}', "; //
$sql .= "child_price_fr='{$child_price_fr}', "; //
$sql .= "baby_price_fr='{$baby_price_fr}', "; //
$sql .= "infant_price_fr='{$infant_price_fr}', "; //
$sql .= "sales_total='{$sales_total}', ";
$sql .= "sales_total_fr='{$sales_total_fr}', ";
if($cf[curunit]!='KRW') :
$sql .= "total_pay_usd='{$total_pay_usd}', ";
endif;
// 담당자(상품담당자)
$sql .= "admin_id='{$row_good['admin_id']}', ";
$sql .= "admin_nm='{$row_good['admin_nm']}', ";
// 예약내역 출력용
$sql .= "option_price='{$option_price}', "; //
$sql .= "option_price_fr='{$option_price_fr}', "; //
$sql .= "tax_adult='{$row_date['oil_money1']}', ";
$sql .= "tax_child='{$row_date['oil_money2']}', ";
$sql .= "tax_baby='{$row_date['oil_money3']}', ";
$sql .= "tax_infant='{$row_date['oil_money4']}', ";
$sql .= "tax_adult_fr='{$row_date['adult_tax_fr']}', ";
$sql .= "tax_child_fr='{$row_date['child_tax_fr']}', ";
$sql .= "tax_baby_fr='{$row_date['baby_tax_fr']}', ";
$sql .= "tax_infant_fr='{$row_date['infant_tax_fr']}', ";
$sql .= "tot_adult='{$tot_adult}', "; //
$sql .= "tot_child='{$tot_child}', "; //
$sql .= "tot_baby='{$tot_baby}', "; //
$sql .= "tot_infant='{$tot_infant}', "; //
$sql .= "tot_adult_fr='{$tot_adult_fr}', "; //
$sql .= "tot_child_fr='{$tot_child_fr}', "; //
$sql .= "tot_baby_fr='{$tot_baby_fr}', "; //
$sql .= "tot_infant_fr='{$tot_infant_fr}', "; //
$sql .= "order_state='{$order_state}', "; // 예약상태 (2017-05-12.허종)
// 패스티켓 > 연속사용교환여부, 주의사항, 환불안내 저장(2016-12-28.허종)
$sql .= "g_ready='".str_replace("'","'",$row_good['g_ready'])."', ";
$sql .= "g_special='".str_replace("'","'",$row_good['g_special'])."', ";
$sql .= "g_rule='".str_replace("'","'",$row_good['g_rule'])."', ";
$sql .= "google_map='".str_replace("'","'",$row_good['google_map'])."', "; //[son]
$sql .= "ins_ip='{$cf['user_ip']}', ";
$sql .= "ins_route='B2', "; //B2B예약
// 환율정보 저장
$sql .= "exchange_fg='{$row_good['exchange_fg']}',";// 환율사용유무
$sql .= "ext_str='{$ext_str}',"; // TB_EXCHANGE > 화폐한글명||화폐영문||화폐기호||화폐교환 원(KRW)||1000원단위,100원단위||올림(A)반올림(R)버림(L)
$sql .= "mb_id='{$TK_MEMBER['mb_id']}', ";
$sql .= "res_cust_nm='{$res_cust_nm}', ";
$sql .= "res_cust_hp='{$res_cust_hp}', ";
$sql .= "res_cust_tel='{$res_cust_tel}', ";
$sql .= "res_cust_email='{$res_cust_email}', ";
$sql .= "res_stat_cd='{$row_date['res_stat_cd']}', ";
$sql .= "res_cust_memo='{$res_cust_memo}', ";
//$sql .= "res_sns_id='{$res_sns_id}', ";
$sql .= "res_cust_nat_cd='{$res_cust_nat_cd}', "; //국적
$sql .= "g_memo='{$g_memo}', "; //add
// 대리점
$sql .= "agent_id='{$agent_id}', ";
$sql .= "agent_corp_nm='{$agent_corp_nm}', ";
// 공급처
$sql .= "producer_id='{$row_good['producer_id']}', ";
$sql .= "producer_corp_nm='{$row_good['producer_corp_nm']}', ";
//외국어종류
$sql .= "lang='{$lang}', ";
$sql .= "curunit='{$curunit}', ";
$sql .= "hwan='{$ext_to_krw}', ";
//B2B
$sql .= "b2b_paymethod='{$b2b_paymethod}', "; //지불방법
$sql .= "b2b_voucher='{$b2b_voucher}', ";
$sql .= "b2b_manager='{$b2b_manager}', ";
$sql .= "b2b_sns_type='{$b2b_sns_type}', ";
$sql .= "b2b_sns_id='{$b2b_sns_id}', ";
$sql .= "adult_price_normal='{$adult_price_normal}', ";
$sql .= "child_price_normal='{$child_price_normal}', ";
$sql .= "baby_price_normal='{$baby_price_normal}', ";
$sql .= "infant_price_normal='{$infant_price_normal}', ";
$sql .= "ins_dt=now() ";
db_query($sql,TRUE,$connect);
// logCheck($sql); ///////////////////////////////////////////////////////////////////////
// 행사저장
res_good_date_update($res_no,$row_date['d_uid']);
// 행사 인원 업데이트
//good_date_people_update($row_date['d_uid']);
// 입출금 - 고객 자동정산정보 계산
$class_AccountCustomer->account_customer_check($res_no,"good_res");
// 예약검색 정보 업데이트(2017-02-04.허종)
if($res_no) {
db_query("call SP_RES_GOOD_SEARCH('".$res_no."');"); // 관리자검색요소 업데이트
db_query("call SP_RES_ALL('".$res_no."');"); // 예약통합
db_query("call SP_RES_GOOD_BLOCK('".$row_date['d_uid']."');"); // 블록업데이트
}
// PC알리미
$pca_event = "travel_reservation_b2b";
include_once($_SERVER['DOCUMENT_ROOT'] . "/toas/include/travel.php");
$res['res'] = 'ok';
echo json_encode($res);
exit;
}
/*
* 예약수정
* 기존의 예약과 동일한 로직 유지
*/
else if($mode=='modiReservation') {
$res['msg'] = '';
$res['res'] = '';
$res['check'] = '';
$table = "TB_RES_GOOD";
/*
* gdt_pe_check : 단독투어 상품 여부 체크
* 데이투어(tab:D) > 단독투어(gdt:pe)
*/
if($gdt_pe_check=='y') {
$adultNum = $daesuAdultNum; //승객수
$childNum = $babyNum = $infantNum = 0;
}
$allNum = $adultNum+$childNum+$babyNum+$infantNum;
if($allNum==0) {
$res['msg'] = _e2('인원수를 확인해 주세요.');
echo json_encode($res);
exit;
}
// 예약정보
$data_res = res_good_master(" and res_no='{$res_no}' ");
$row_res = res_good_master_replace($data_res[0]);
// 출발장소(신규)
if($poid) {
$data_depot = good_depot($g_uid,"Y",$poid);
$depot_nm = $data_depot[0]['depot_nm'];
}
if($gdt_pe_check=='y') { //단독투어
$adult_price_normal = $adultPrice; //정상가
$adult_price = $adultPriceAgency; //대리점가
$adult_price_fr = $class_v->exchangeMoney_Reverse(array("ext_eng"=>$curunit,"money"=>$adult_price));
$tot_adult = (int)$adult_price * (int)$daesu;
$tot_adult_fr = (int)$adult_price_fr * (int)$daesu;
$sales_total = $tot_adult;
$sales_total_fr = $tot_adult_fr;
} else {
//금액계산 //res_GoodDateCalculate()함수와 동일하게 전체금액을 환율변환하지 않고 fr금액에 인원수를 곱함
$personArr = $B2b->personArr;
$sales_total = $sales_total_fr = 0;
foreach($personArr as $k=>$v) {
${$k.'_inwon'} = ${$k.'Num'}; //인원수
${$k.'_price_normal'} = ${$k.'Price'}; //정상가
${$k.'_price'} = ${$k.'PriceAgency'}; //대리점가
${$k.'_price_fr'} = $class_v->exchangeMoney_Reverse(array("ext_eng"=>$curunit,"money"=>${$k.'_price'}));
${'tot_'.$k} = (int)${$k.'_price'} * (int)${$k.'Num'};
${'tot_'.$k.'_fr'} = (int)${$k.'_price_fr'} * (int)${$k.'Num'};
$sales_total += ${'tot_'.$k};
$sales_total_fr += ${'tot_'.$k.'_fr'};
}
}
//옵션상품 저장
db_query("delete from {$table}_OPTION where res_no='{$res_no}' and opitp='P' ");
$data_option = $row_res['d_good_option_all'];
if(!empty($data_option)) {
$option_price = $option_price_fr = 0; //옵션총금액
foreach($data_option as $k=>$v) {
$i = array_search($v['opid'], $opid_arr);
$opid = $opid_arr[$i];
$op_num = $op_num_arr[$i];
//저장된 예약정보 d_good_option_all 환율 가격 포함
$option_price_fr += (int)$v['op_price_sell_fr'] * (int)$op_num;
$option_price += (int)$v['op_price_sell'] * (int)$op_num;
$sql = "insert into {$table}_OPTION set ";
$sql .= " res_no='{$res_no}', ";
$sql .= " g_uid='{$g_uid}', ";
$sql .= " g_title='{$row_res['g_title']}', "; //
$sql .= " opid='{$opid}', ";
$sql .= " op_nm='{$v['op_nm']}', ";
$sql .= " op_price_cost='{$v['op_price_cost']}', ";
$sql .= " op_price_sell='{$v['op_price_sell']}', ";
$sql .= " op_price_sell_fr='{$v['op_price_sell_fr']}', "; //
$sql .= " op_price_agent='{$v['op_price_sell']}', "; //옵션상품엔 별도의 대리점 금액이 없어서 대리점 예약일땐 기존 가격을 등록
$sql .= " op_num='{$op_num}', ";
$sql .= " ins_dt = now(), ";
$sql .= " lang = '{$lang}',"; //
$sql .= " curunit = '{$curunit}'"; //
$sql .= " , hwan = '{$ext_to_krw}'"; //
db_query($sql);
}
$sales_total += $option_price;
$sales_total_fr += $option_price_fr;
}
// 동행자 저장
db_query("delete from {$table}_PERSON where res_no='{$res_no}' ");
$personNum = array($adultNum,$childNum,$babyNum,$infantNum);
$chk = 0;
foreach($personNum as $k=>$v) {
for($i=0;$i<$v;$i++) {
if($k==0) {
$generation = 'A';
} else if($k==1) {
$generation = 'C';
} else if($k==2) {
$generation = 'B';
} else if($k==3) {
$generation = 'I';
}
$sql = "insert into {$table}_PERSON set ";
$sql .= " res_no='{$res_no}', ";
$sql .= " tab='{$row_res['tab']}', ";
$sql .= " g_uid='{$row_res['g_uid']}', ";
$sql .= " g_title='{$row_res['g_title']}', ";
$sql .= " ev_uid='{$row_res['ev_uid']}', ";
$sql .= " ev_title='{$row_res['ev_title']}', ";
$sql .= " ev_start='{$row_res['ev_start']}', ";
$sql .= " ev_end='{$row_res['ev_end']}', ";
$sql .= " generation='{$generation}', ";
if($chk==0) { //첫번째에 회원정보 추가
$sql .= " gend='{$gend}', ";
$sql .= " name_kor='{$name_kor}', ";
$sql .= " name_eng='{$name_eng1}||{$name_eng2}', ";
$sql .= " hp='{$hp}', ";
$sql .= " tel='{$tel}', ";
$sql .= " jumin='{$jumin}', ";
$sql .= " passenger_num='{$passenger_num}', ";
$sql .= " birth_dt='{$birth_dt}', ";
$sql .= " poid='{$poid}', "; //탑승 장소 및 시간
$sql .= " depot_nm='{$depot_nm}', ";
}
$sql .= " ins_dt=now() ";
db_query($sql);
$chk++;
}
}
//sales_total USD
$total_pay_usd = $class_v->exchangeMoney_Reverse(array("ext_eng"=>"USD","money"=>$sales_total));
// 예약마스터 저장
$sql = "update {$table} set ";
//$sql .= "rsv_no='{$rsv_no}', ";
$sql .= "mb_id='{$mb_id}', ";
$sql .= "res_cust_nm='{$res_cust_nm}', ";
$sql .= "res_cust_hp='{$res_cust_hp}', ";
$sql .= "res_cust_tel='{$res_cust_tel}', ";
$sql .= "res_cust_email='{$res_cust_email}', ";
$sql .= "res_cust_nat_cd='{$res_cust_nat_cd}', ";
if($gdt_pe_check=='y') $sql .= " gdt_pe_daesu='{$daesu}', "; //대수
//$sql .= "adult_buy='{$adult_buy}', ";
//$sql .= "child_buy='{$child_buy}', ";
//$sql .= "baby_buy='{$baby_buy}', ";
//$sql .= "infant_buy='{$infant_buy}', ";
$sql .= "adult_price='{$adult_price}', ";
$sql .= "child_price='{$child_price}', ";
$sql .= "baby_price='{$baby_price}', ";
$sql .= "infant_price='{$infant_price}', ";
//통화변환값
$sql .= "adult_price_fr='{$adult_price_fr}', ";
$sql .= "child_price_fr='{$child_price_fr}', ";
$sql .= "baby_price_fr='{$baby_price_fr}', ";
$sql .= "infant_price_fr='{$infant_price_fr}', ";
//$sql .= "agent_id='{$agent_id}', ";
//$sql .= "agent_corp_nm='{$agent_corp_nm}', ";
//$sql .= "buy_total='{$buy_total}', "; // 매입가 합계
$sql .= "sales_total='{$sales_total}', "; // 판매가 합계
$sql .= "sales_total_fr='{$sales_total_fr}', "; // 판매가 합계 외화
if($curunit != "KRW") :
$sql .= "total_pay_usd='{$total_pay_usd}', "; // 판매가 합계 외화
endif;
$sql .= "option_price='{$option_price}', "; // 옵션합계
$sql .= "option_price_fr='{$option_price_fr}', "; // 옵션합계 외화
$sql .= "tot_adult='{$tot_adult}', "; // 성인합계
$sql .= "tot_child='{$tot_child}', "; // 소인합계
$sql .= "tot_baby='{$tot_baby}', "; // 유아합계
$sql .= "tot_infant='{$tot_infant}', "; // 영아합계
//통화변환값
$sql .= "tot_adult_fr='{$tot_adult_fr}', "; // 성인합계
$sql .= "tot_child_fr='{$tot_child_fr}', "; // 소인합계
$sql .= "tot_baby_fr='{$tot_baby_fr}', "; // 유아합계
$sql .= "tot_infant_fr='{$tot_infant_fr}', "; // 영아합계
//$sql .= "addon_buy_price='{$addon_buy_price}', "; // 추가 매입금액 합계
//$sql .= "addon_sale_price='{$addon_sale_price}', "; // 추가 판매금액 합계
//$sql .= "addon_sale_price_fr='{$addon_sale_price_fr}', "; // 추가 판매금액 합계 외화
//$sql .= "discount_buy='{$discount_buy}', "; // 매입금액 할인(-)
//$sql .= "discount_sale='{$discount_sale}', "; // 판매금액 할인(-)
//$sql .= "discount_sale_fr='{$discount_sale_fr}', "; // 판매금액 할인(-)
//$sql .= "discount_cmt='{$discount_cmt}', "; // 할인내역
//$sql .= "adult_comt='{$adult_comt}', "; // 비고
//$sql .= "child_comt='{$child_comt}', "; // 비고
//$sql .= "baby_comt='{$baby_comt}', "; // 비고
//$sql .= "infant_comt='{$infant_comt}', "; // 비고
//$sql .= "admin_id='{$admin_id}', ";
//$sql .= "admin_nm='{$admin_nm}', ";
//$sql .= "proc_air='{$proc_air}',";
//$sql .= "proc_land='{$proc_land}',";
//$sql .= "proc_insu='{$proc_insu}',";
//$sql .= "proc_cont='{$proc_cont}',";
//$sql .= "proc_present='{$proc_present}',";
$sql .= "edit_id='{$TK_MEMBER[mb_id]}', ";
$sql .= "edit_nm='{$TK_MEMBER[mb_nm]}', ";
if(!empty($order_state)) $sql .= "order_state='{$order_state}', "; //관리자 주문상태 변경시
//$sql .= "admin_comt='{$admin_comt}', "; // 비고(관리자)
//B2B
$sql .= "g_memo='{$g_memo}', "; //add
$sql .= "b2b_paymethod='{$b2b_paymethod}', "; //지불방법
$sql .= "b2b_voucher='{$b2b_voucher}', ";
$sql .= "b2b_manager='{$b2b_manager}', ";
$sql .= "b2b_sns_type='{$b2b_sns_type}', ";
$sql .= "b2b_sns_id='{$b2b_sns_id}', ";
$sql .= "b2b_cancel_memo='{$b2b_cancel_memo}', "; //주문취소메모
$sql .= "edit_dt=now() ";
$sql .= " where res_no='{$res_no}' ";
db_query($sql);
// 입출금정보 갱신
$class_AccountCustomer->account_customer_check($res_no,"good_res");
// 예약검색 정보 업데이트(2017-02-04.허종)
if($res_no) {
db_query("call SP_RES_GOOD_SEARCH('".$res_no."');"); // 관리자검색요소 업데이트
db_query("call SP_RES_ALL('".$res_no."');"); // 예약통합
db_query("call SP_RES_GOOD_BLOCK('".$row_res['ev_uid']."');"); // 블록업데이트
}
$res['msg'] = _e2('수정완료');
$res['res'] = 'ok';
echo json_encode($res);
exit;
}
//진행전달 상태 변경
else if($mode=='changeOrderState') {
if(!is_array($res_no_arr) or !$order_state) exit;
foreach($res_no_arr as $res_no) {
$sql ="update TB_RES_GOOD set order_state='{$order_state}' where res_no='{$res_no}' ";
db_query($sql);
}
error_msg("document.location.reload();","script");
}
//메모 저장
else if($mode=='saveMemo') {
if(empty($res_no_arr2)) exit;
foreach($res_no_arr2 as $k=>$res_no) {
$g_memo = $g_memo_arr[$k];
$sql ="update TB_RES_GOOD set g_memo='{$g_memo}' where res_no='{$res_no}' ";
db_query($sql);
}
error_msg("document.location.reload();","script");
}
//메일 보내기
else if($mode=='mailSend') {
error_reporting(0);
require $_SERVER['DOCUMENT_ROOT']."/Lib/send_mail.php"; //
$res['msg'] = '';
$res['res'] = '';
if(empty($res_no)) return;
$data = $B2b->voucherHtml($res_no);
$row = $data['row'];
$title = '[B2B 예약정보] '.$row['g_title'];
$cont = $data['mail_body'];
$cust_email = $row['res_cust_email'];
//$cust_email = 'sjoonai@nate.com'; ////////////////////test
if(empty($cust_email)) {
$res['msg'] = _e2('메일 주소가 없습니다.');
echo json_encode($res);
exit;
}
$cust_nm = $row['res_cust_nm'];
//대리점 정보
$from_email = $TK_CF['shop_email_lang'];
$from_name = $TK_CF['shop_name'];
// $from_email = $TK_MEMBER['mb_email']; //대리점 개개의 메일 주소는 전송 안될수도 있어서 관리자 메일로 발송
// $from_name = $TK_MEMBER['mb_nm'];
$mail_data = array();
$mail_data['to_mail']=$cust_email;
$mail_data['to_name']=$cust_nm;
$mail_data['from_mail']=$from_email;
$mail_data['from_name']=$from_name;
$mail_data['from_passwd']=$TK_CF_SMTP['smtp_pwd'];
$mail_data['title']=$title;
$mail_data['host']=$TK_CF_SMTP['smtp_host'];
$mail_data['port']=$TK_CF_SMTP['smtp_port'];
$mail_data['auth']=true;
$mail_data['debug']=0;
$mail_data['secure']=$TK_CF_SMTP['smtp_type'];
$result = send_smtp($mail_data, stripslashes($cont));
// 히스토리 저장
// $rdata = array();
// $rdata['send_mail'] = $from_email;// 회사
// $rdata['recv_mail'] = $cust_email;// 고객
// $rdata['message'] = $title; // 메일제목
// $rdata['mail_cont'] = $cont; // 메일제목
// $rdata['type'] = "M"; // 타입
// $ret = to_send_history_ins($rdata); // 히스토리 저장
//$res['msg'] = '메일 전송 완료';
$res['res'] = 'ok';
echo json_encode($res);
exit;
}
?>