|
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/erp/ |
Upload File : |
<?php
include "../include/top_proc.html";
include "_common.html";
$upload = $cf['path']."/FileData/good/";
$upload_thum = $cf['path']."/FileData/good_thum/";
if(!$a_idx) exit;
// 기존 예약정보
if($a_idx){
$sql = "select * from TB_ERP_ALL where a_idx='{$a_idx}'";
$rs = db_query($sql);
$row = db_fetch_array($rs) ;
//견적서 정보
$sql2 = "select * from TB_ERP_ESTIMATE where a_idx='{$a_idx}'";
$rs2 = db_query($sql2);
$row2 = db_fetch_array($rs2) ;
$e_idx = $row2[e_idx];
//invoice 정보
$sql3 = "select * from TB_ERP_INVOICE where a_idx='{$a_idx}'";
$rs3 = db_query($sql3);
$row3 = db_fetch_array($rs3) ;
$i_idx = $row3[i_idx];
//voucher 정보
$sql4 = "select * from TB_ERP_VOUCHER where a_idx='{$a_idx}'";
$rs4 = db_query($sql4);
$row4 = db_fetch_array($rs4) ;
$v_idx = $row4[v_idx];
}
/**************************************************************************/
/************************1. TB_ERP_ALL 저장 ********************************/
/**************************************************************************/
$sql = "insert into TB_ERP_ALL set ";
$sql .= " attn='{$row[attn]}', ";
$sql .= " admin_nm='{$row[admin_nm]}', ";
$sql .= " charger='{$row[charger]}', ";
$sql .= " good_name='{$row[good_name]}', ";
$sql .= " start_date='{$row[start_date]}', ";
$sql .= " end_date='{$row[end_date]}', ";
$sql .= " periods='{$row[periods]}', ";
$sql .= " hotel_name='{$row[hotel_name]}', ";
$sql .= " car_info='{$row[car_info]}', ";
$sql .= " res_name='{$row[res_name]}', ";
$sql .= " res_nationality='{$row[res_nationality]}', ";
$sql .= " currency='{$row[currency]}', ";
$sql .= " deposit='{$row[deposit]}', ";
$sql .= " res_phone='{$row[res_phone]}', ";
$sql .= " res_email='{$row[res_email]}', ";
$sql .= " balance='{$row[balance]}', ";
$sql .= " total_price='{$row[total_price]}', ";
$sql .= " total_price_won='{$row[total_price_won]}', ";
$sql .= " hwan='{$row[hwan]}', ";
$sql .= " lang='{$row[lang]}', ";
$sql .= " num_adult='{$row[num_adult]}', ";
$sql .= " num_child='{$row[num_child]}', ";
$sql .= " num_foc='{$row[num_foc]}', ";
$sql .= " included='{$row[included]}', ";
$sql .= " non_included='{$row[non_included]}', ";
$sql .= " remarks='{$row[remarks]}', ";
$sql .= " date_payment='{$row[date_payment]}', ";
$sql .= " state='{$row[state]}', ";
$sql .= " pay_state='{$row[pay_state]}', ";
$sql .= " customer_guide='{$row[customer_guide]}', ";
$sql .= " customer_driver='{$row[customer_driver]}', ";
$sql .= " customer_carinfo='{$row[customer_carinfo]}', ";
$sql .= " regdate = now()";
$result = db_query($sql);
$a_idx = db_insert_id();
/**************************************************************************/
/********************2. TB_ERP_ESTIMATE 저장 *******************************/
/**************************************************************************/
if($e_idx) {
$sql = "insert into TB_ERP_ESTIMATE set ";
$sql .= " a_idx='{$a_idx}', ";
if($row2['day1_date']) {
$sql .= " day1_date='{$row2[day1_date]}', ";
$sql .= " day1_info='{$row2[day1_info]}', ";
$sql .= " day1_hotel_info='{$row2[day1_hotel_info]}', ";
}
if($row2['day2_date']) {
$sql .= " day2_date='{$row2[day2_date]}', ";
$sql .= " day2_info='{$row2[day2_info]}', ";
$sql .= " day2_hotel_info='{$row2[day2_hotel_info]}', ";
}
if($row2['day3_date']) {
$sql .= " day3_date='{$row2[day3_date]}', ";
$sql .= " day3_info='{$row2[day3_info]}', ";
$sql .= " day3_hotel_info='{$row2[day3_hotel_info]}', ";
}
if($row2['day4_date']) {
$sql .= " day4_date='{$row2[day4_date]}', ";
$sql .= " day4_info='{$row2[day4_info]}', ";
$sql .= " day4_hotel_info='{$row2[day3_hotel_info]}', ";
}
if($row2['day5_date']) {
$sql .= " day5_date='{$row2[day5_date]}', ";
$sql .= " day5_info='{$row2[day5_info]}', ";
$sql .= " day5_hotel_info='{$row2[day5_hotel_info]}', ";
}
if($row2['day6_date']) {
$sql .= " day6_date='{$row2[day6_date]}', ";
$sql .= " day6_info='{$row2[day6_info]}', ";
$sql .= " day6_hotel_info='{$row2[day6_hotel_info]}', ";
}
if($row2['day7_date']) {
$sql .= " day7_date='{$row2[day7_date]}', ";
$sql .= " day7_info='{$row2[day7_info]}', ";
$sql .= " day7_hotel_info='{$row2[day7_hotel_info]}', ";
}
if($row2['day8_date']) {
$sql .= " day8_date='{$row2[day8_date]}', ";
$sql .= " day8_info='{$row2[day8_info]}', ";
$sql .= " day8_hotel_info='{$row2[day8_hotel_info]}', ";
}
if($row2['day9_date']) {
$sql .= " day9_date='{$row2[day9_date]}', ";
$sql .= " day9_info='{$row2[day9_info]}', ";
$sql .= " day9_hotel_info='{$row2[day9_hotel_info]}', ";
}
if($row2['day10_date']) {
$sql .= " day10_date='{$row2[day10_date]}', ";
$sql .= " day10_info='{$row2[day10_info]}', ";
$sql .= " day10_hotel_info='{$row2[day10_hotel_info]}', ";
}
if($row2['day11_date']) {
$sql .= " day11_date='{$row2[day11_date]}', ";
$sql .= " day11_info='{$row2[day11_info]}', ";
$sql .= " day11_hotel_info='{$row2[day11_hotel_info]}', ";
}
if($row2['day12_date']) {
$sql .= " day12_date='{$row2[day12_date]}', ";
$sql .= " day12_info='{$row2[day12_info]}', ";
$sql .= " day12_hotel_info='{$row2[day12_hotel_info]}', ";
}
if($row2['day13_date']) {
$sql .= " day13_date='{$row2[day13_date]}', ";
$sql .= " day13_info='{$row2[day13_info]}', ";
$sql .= " day13_hotel_info='{$row2[day13_hotel_info]}', ";
}
if($row2['day14_date']) {
$sql .= " day14_date='{$row2[day14_date]}', ";
$sql .= " day14_info='{$row2[day14_info]}', ";
$sql .= " day14_hotel_info='{$row2[day14_hotel_info]}', ";
}
if($row2['day15_date']) {
$sql .= " day15_date='{$row2[day15_date]}', ";
$sql .= " day15_info='{$row2[day15_info]}', ";
$sql .= " day15_hotel_info='{$row2[day15_hotel_info]}', ";
}
$sql .= " currency='{$row2[currency]}', ";
$sql .= " remark='{$row2[remark]}', ";
$sql .= " total_buy_price='{$row2[total_buy_price]}', ";
$sql .= " total_sell_price='{$row2[total_sell_price]}', ";
$sql .= " hwan='{$row2[hwan]}', ";
$sql .= " lang='{$row2[lang]}', ";
$sql .= " pub_date=now(), ";
$sql .= " regdate = now()";
$result = db_query($sql);
}
/**************************************************************************/
/********************3. TB_ERP_INVOICE 저장 ********************************/
/**************************************************************************/
if($i_idx) {
$sql = "insert into TB_ERP_INVOICE set ";
$sql .= " a_idx='{$a_idx}', ";
$sql .= " invoice_no='{$row3[invoice_no]}', ";
$sql .= " pub_date=now(), ";
$sql .= " payment='{$row3[payment]}', ";
//$sql .= " account_state='{$account_state}', ";
if($row3['detail1']) {
$sql .= " detail1='{$row3[detail1]}', ";
}
if($row3['detail2']) {
$sql .= " detail2='{$row3[detail2]}', ";
}
if($row3['detail3']) {
$sql .= " detail3='{$row3[detail3]}', ";
}
if($row3['detail4']) {
$sql .= " detail4='{$row3[detail4]}', ";
}
if($row3['detail5']) {
$sql .= " detail5='{$row3[detail5]}', ";
}
if($row3['detail6']) {
$sql .= " detail6='{$row3[detail6]}', ";
}
if($row3['detail7']) {
$sql .= " detail7='{$row3[detail7]}', ";
}
if($row3['detail8']) {
$sql .= " detail8='{$row3[detail8]}', ";
}
if($row3['detail9']) {
$sql .= " detail9='{$row3[detail9]}', ";
}
$sql .= " total_detail_amount='$row3[total_detail_amount]', ";
$sql .= " currency='$row3[currency]', ";
$sql .= " lang='$row3[lang]', ";
$sql .= " bank_name='$row3[bank_name]', ";
$sql .= " account_name='$row3[account_name]', ";
$sql .= " account_no='$row3[account_no]', ";
$sql .= " swift_code='$row3[swift_code]', ";
$sql .= " bank_addr='$row3[bank_addr]', ";
$sql .= " bank_contact='$row3[bank_contact]', ";
$sql .= " rule_refund='$row3[rule_refund]', ";
$sql .= " remarks='$row3[remarks]', ";
$sql .= " regdate = now()";
$result = db_query($sql);
}
/**************************************************************************/
/********************4. TB_ERP_VOUCHER 저장 ********************************/
/**************************************************************************/
if($v_idx) {
// qrcode 이미지 복사
if($row4['code_type']=='qrcode') { //code type:qrcode
for($i=1;$i<=50;$i++) {
if($row4['code'.$i]) {
// 이미지명 새로생성
${'code'.$i} = explode("::",$row4['code'.$i]);
${'new_fn'.$i} = getUniqueFileName(${'code'.$i}[0]);
${'code'.$i.'_info'} = ${'new_fn'.$i} . "::" . ${'code'.$i}[1] . "::" . ${'code'.$i}[2] . "::" . ${'code'.$i}[3];
// 이전이미지
${'orig_path'.$i} = $upload.${'code'.$i}[0];
${'orig_path'.$i.'_thum'} = $upload_thum.${'code'.$i}[0];
// 새이미지
${'new_path'.$i} = $upload.${'new_fn'.$i};
${'new_path'.$i.'_thum'} = $upload_thum.${'new_fn'.$i};
@exec("cp -p ${'orig_path'.$i} ${'new_path'.$i}");
@exec("cp -p ${'orig_path'.$i.'_thum'} ${'new_path'.$i.'_thum'}");
} //end if
} //end for
} else { //code type:number
for($i=1;$i<=50;$i++) {
if($row4['code'.$i]) {
${'code'.$i.'_info'} = $row4['code'.$i];
}
}
}
//meeting place
$new_fn = "";
if($row4['meeting_place']) {
// 이미지명 새로생성
$new_fn = getUniqueFileName($row4['meeting_place']);
// 이전이미지
$orig_path = $upload.$row4['meeting_place'];
$orig_path_thum = $upload_thum.$row4['meeting_place'];
// 새이미지
$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_ERP_VOUCHER set ";
$sql .= " a_idx='{$a_idx}', ";
$sql .= " code_type='{$row4[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='{$row4[use_method]}', ";
$sql .= " meeting_place='$new_fn', ";
$sql .= " contact_us='$row4[contact_us]', ";
$sql .= " pub_date = now(),";
$sql .= " regdate = now()";
$result = db_query($sql);
}
echo "<script>location.href='erp_list.php?s=1".$_rhref."';</script>";
?>