|
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
include "../include/top_iframe.html";
include "_common.php";
$table = "TB_PRIVATE_DEPART";
if($seq){
$seq = (int) $seq;
if(!$seq){
echo "<script>alert('오류발생');</script>";
}else{
$sql = "SELECT * FROM TB_PRIVATE_DEPART WHERE seq = {$seq}";
$data = db_fetch($sql);
$matchPrivateBus = $data['match_private_bus'];
if($matchPrivateBus){
//버스견적예약 데이터
$sqlBusErp = "SELECT * FROM TB_ERP_BUS WHERE match_private_bus = '{$matchPrivateBus}'";
$dataBusErp = db_fetch($sqlBusErp);
}
$start_date = $dataBusErp['start_date'];
$end_date = $dataBusErp['end_date'];
$total_sell_price = $dataBusErp['total_sell_price'];
$total_buy_price = $dataBusErp['total_buy_price'];
$profit = $total_sell_price - $total_buy_price; // 회사수익
}
}
// 담당자
$admin_arr = member_fetch(" and mb_level <= 10 and del_flag='N' ");
$admin_arr = array_reverse($admin_arr);
$adminUser = array();
foreach ($admin_arr as $item){
$adminUser[$item['mb_id']] = $item;
}
// 버스 회사 목록사
$rs = db_query("select * from TB_ERP_BUS_CORP where 1=1");
for($i=0 ; $i < $row = db_fetch_array($rs) ; $i++){
$bus_corp_row[] = $row;
}
list($start_date, $start_time) = explode(" ", $start_date);
list($end_date, $end_time) = explode(" ", $end_date);
$alimtalkHistoryCnt = 0;
if($data['match_private_bus']){
$alimtalkHistory = to_send_history_list(array('res_no'=>$data['match_private_bus'],'type'=>'AT'));
if($alimtalkHistory){
$alimtalkHistoryCnt = count($alimtalkHistory);
}
}
?>
<style>
.colorChange{float:left;height:24px;width:24px;margin-right:5px;cursor:pointer}
.fileAttachArea{clear:both;float:left;width:434px;border:1px solid #cfcfd1;padding-left:10px;height:50px}
.fileAttachArea:nth-child(2){margin-top:-1px}
.fileAttachArea b{font-weight:normal;position: relative;top: 2px;width: 15px;display: inline-block;_background: blue}
.busResArea{float:left;width:49%;margin-left:10px;border-left:1px solid #ccc;padding-left:10px}
/*.busResArea, .busResTr{display:none}*/
.t_register th{padding:7px 10px !important;}
.t_register2 th{height:33px}
.t_register2 th{font-size:13px}
.t_register2 tr td:nth-child(1){width:188px}
#total_buy_price,.calc{text-align:right}
#tourTitle::placeholder{color:#aaa}
#sendAlimTalkThenSaveBtn{cursor:pointer;float:right;color:#000;font-weight:500;margin-left:12px;line-height:unset;text-align:center;width:117px;border:1px solid #eec20f;background:#fcdf7c;padding:8px 10px 8px !important;border-radius:3px;height:unset;font-size:12px}
</style>
<div class="iframe" style="margin:0;">
<!-- 본문 -->
<!-- 폼 -->
<form enctype="multipart/form-data" name="frm_private_frm" id="frm_private_frm" method="post">
<?php
if(isset($seq)){
?>
<input name="SqlType" type="hidden" value="edit_private" />
<input type="hidden" name="seq" value="<?=$data['seq']?>" />
<input type="hidden" name="b_idx" value="<?=$dataBusErp['b_idx']?>" />
<input type="hidden" name="match_private_bus" id="match_private_bus" value="<?=$data['match_private_bus']?>" />
<?php
}else{
?>
<input type="hidden" name="calendar_date" value="<?=$calendar_date?>" />
<input name="SqlType" type="hidden" value="ins_private">
<?php
}
?>
<table width="100%" style="float:left;width:49%" border="0" cellspacing="0" cellpadding="0" class="t_register" summary="프라이빗 행사">
<tbody>
<tr>
<th style="border-left:1px solid #e4e4e4;border-top:1px solid #e4e4e4;" scope="row">투어명</th>
<td colspan="3">
<input type="text" name="title" id="tourTitle" placeholder="[작성순서] 이름(인원)_행사명_예약경로_차량종류_국적" style="width:410px;border:1px solid #ccc" value='<?=(($data['title']) ? $data['title'] : '')?>' />
</td>
</tr>
<?php
if($seq){
?>
<tr>
<th style="border-left:1px solid #e4e4e4" scope="row">출발일</th>
<td colspan="3">
<input type="text" onclick="AjaxCal(this,event);" class="cal_input" name="calendar_date" placeholder="출발일" style="width:158px;border:1px solid #ccc" value="<?=$data['calendar_date']?>" />
</td>
</tr>
<?php
}
?>
<tr>
<th style="height:28px;border-left:1px solid #e4e4e4" scope="row">글씨배경색</th>
<td colspan="3">
<?php
/*
if($TK_MEMBER['mb_id'] == 'jamiesy'){
?>
<input type="color" id="color" name="color" style="height:24px;padding:0;margin-left:5px;" value="<?=(($data['color']) ? $data['color'] : '#7d4ee9')?>">
<?php
}else{
?>
<input type="color" id="color" name="color" style="height:24px;padding:0;margin-left:5px;" value="<?=(($data['color']) ? $data['color'] : '#0000ff')?>">
<?php
}
*/
?>
<input type="color" id="color" name="color" style="width:30px;height:24px;padding:0;margin-left:5px;" value="<?=(($data['color']) ? $data['color'] : '#333333')?>">
<!-- <span class="colorChange" style="background:#7d4ee9;" color="#7d4ee9"></span>-->
<!-- <span class="colorChange" style="background:#5ab2d9;" color="#5ab2d9"></span>-->
<!-- <span class="colorChange" style="background:#000000;" color="#000000"></span>-->
<!-- <span class="colorChange" style="background:#ff0000;" color="#ff0000"></span>-->
<?php
foreach($tourDepartCalendarColorList as $word => $colorValue){
?>
<span class="colorChange" style="background:<?=$colorValue?>;" color="<?=$colorValue?>"></span>
<?php
}
?>
<script>
$(function(){
$('.colorChange').click(function(){
$('#color').val($(this).attr('color'));
});
})
</script>
<div style="visibility: hidden;float:right">
<input type="checkbox" name="kakaoalitalk" id="kakaoalitalk" style="" />
</div>
</td>
</tr>
<tr>
<th style="border-left:1px solid #e4e4e4" scope="row">예약인원</th>
<td colspan="1">
<input type="text" required name="res_people" style="width:39px;text-align:right;border:1px solid #ccc" value="<?=(($data['res_people']) ? $data['res_people'] : 0)?>">
명
/
<input type="text" required name="max_people" style="width:39px;text-align:right;border:1px solid #ccc" value="<?=(($data['max_people']) ? $data['max_people'] : 0)?>">
명
</td>
<th scope="row">달력구분</th>
<td colspan="1">
<select name="site_type" hname="사이트 구분" required style="<?=((isset($seq)) ? 'width:136px !important;' : 'width:136px !important;float:left;')?>margin-left:0px;padding: 6px 10px 4px !important;">
<option value="">선택</option>
<option value="tk" <?=(($data['site_type'] == 'tk') ? 'selected' : '')?>>TK Travel</option>
<option value="tb" <?=(($data['site_type'] == 'tb') ? 'selected' : '')?>>여행대장</option>
</select>
</td>
</tr>
<tr>
<th style="height:28px;border-left:1px solid #e4e4e4" scope="row">버스예약</th>
<td colspan="1" style="width:170px">
<label for="busResN">
미완료
</label>
<input style="margin-left: 0px;margin-top: -3px;" type="radio" name="busResYN" id="busResN" value="N" <?=(($data['busResYN'] == 'N' || !isset($seq) ) ? 'checked' : '')?> />
<label for="busResY" style="margin-left:2px">
완료
</label>
<input style="margin-left: 0px;margin-top: -3px;" type="radio" name="busResYN" id="busResY" value="Y" <?=(($data['busResYN'] == 'Y') ? 'checked' : '')?> />
</td>
<th scope="row">작성자</th>
<td colspan="1">
<!-- <a class="Tbtn --><?//=(($data['busResYN'] == 'Y') ? 'gray' : 'red')?><!-- busStatus" style="padding:4px 15px" target="_blank">--><?//=(($data['busResYN'] == 'Y') ? '예약완료' : '미등록')?><!--</a>-->
<select style="padding: 6px 10px 4px !important;" name="ins_id">
<?php
if($data){
foreach($adminUser as $item){
?>
<option value="<?=$item['mb_id']?>" <?=(($data['ins_id'] == $item['mb_id']) ? 'selected' : '')?>><?=$item['mb_nm']?></option>
<?php
}
}else{
foreach($adminUser as $item){
?>
<option value="<?=$item['mb_id']?>" <?=(($TK_MEMBER['mb_id'] == $item['mb_id']) ? 'selected' : '')?>><?=$item['mb_nm']?></option>
<?php
}
}
?>
</select>
</td>
</tr>
<tr>
<th style="border-left:1px solid #e4e4e4" scope="row">세부예약내역</th>
<td colspan="3">
<textarea style="width:100%;height:<?=((isset($seq)) ? '193' : '236' )?>px" name="memo" placeholder=""><?=(($data['memo']) ? $data['memo'] : '')?></textarea>
</td>
</tr>
<tr>
<th style="border-left:1px solid #e4e4e4" scope="row">버스예약정보</th>
<td colspan="3">
<textarea style="width:100%;height:30px" name="vehicleInfo"><?=(($data['vehicleInfo']) ? $data['vehicleInfo'] : '')?></textarea>
</td>
</tr>
<tr>
<th style="border-left:1px solid #e4e4e4" scope="row">투어<br>
입금영수증</th>
<td colspan="3">
<div class="fileAttachArea">
<img class="fileIcon" src="../../image/board/bullet_disk.gif" alt="파일첨부">
<b>#1</b>
<input type="file" name="file1" />
<?php
if($data['file1']){
echo "<br>";
?>
<a style="" href="/FileData/tour_depart/<?=$data['file1path']?>" download>
<img style="position:relative;top:-1px;left:3px;" src="../../image/board/bullet_disk.gif">
<?=$data['file1']?>
</a>
<?php
}
?>
</div>
<div class="fileAttachArea">
<img class="fileIcon" src="../../image/board/bullet_disk.gif" alt="파일첨부">
<b>#2</b>
<input type="file" name="file2" />
<?php
if($data['file2']){
echo "<br>";
?>
<a style="" href="/FileData/tour_depart/<?=$data['file2path']?>" download>
<img style="position:relative;top:-1px;left:3px;" src="../../image/board/bullet_disk.gif">
<?=$data['file2']?>
</a>
<?php
}
?>
</div>
</td>
</tr>
</tbody>
</table>
<div class="busResArea">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_register" summary="버스을 수정합니다.">
<tr class="busResTr">
<th style="width:76px;border-top:1px solid #e4e4e4;border-left:1px solid #e4e4e4" scope="row">버스회사</th>
<td colspan="3">
<select name="bc_idx" id="bc_idx" style=" -webkit-appearance:auto !important; padding: 6px 10px 4px !important;background:#fffde1;width:200px;" hname="버스회사" >
<option value="0">미지정</option>
<? foreach($bus_corp_row as $k => $v) { ?>
<option value="<?=$v['bc_idx']?>" <?if($v['bc_idx'] == $dataBusErp['bc_idx']) echo "selected"?>><?=$v['corp_nm']?></option>
<?}?>
</select>
<b style="font-weight: normal;color: #eb3b5a;font-size: 11px;">※ 버스예약 신규등록과 연동됩니다.</b>
</td>
</tr>
<tr class="busResTr">
<th style="border-left:1px solid #e4e4e4" scope="row">운행일시</th>
<td colspan="3">
출발일
<input type="text" name="start_date" id="start_date" class="cal_input" autocomplete="off" style="width:90px;" value="<?=$start_date?>" onclick="AjaxCal(this,event);">
<input type="text" name="start_time" value="<?=$start_time?>" class="input_text" style="width:60px;">
도착일
<input type="text" name="end_date" id="end_date" class="cal_input" autocomplete="off" style="width:90px;" value="<?=$end_date?>" onclick="AjaxCal(this,event);">
<input type="text" name="end_time" value="<?=$end_time?>" class="input_text" style="width:60px;">
</td>
</tr>
<tr class="busResTr">
<th style="border-left:1px solid #e4e4e4" scope="row">고객명</th>
<td>
<input type="text" name="cus_name" value="<?=$dataBusErp['cus_name']?>" style="width:150px" class="input_text">
</td>
<th style="width:76px;" scope="row">국적</th>
<td>
<input type="text" name="cus_nation" value="<?=$dataBusErp['cus_nation']?>" style="width:150px" class="input_text">
</td>
</tr>
<tr class="busResTr">
<th style="border-left:1px solid #e4e4e4" scope="row">연락처</th>
<td>
<input type="text" name="cus_phone" value="<?=$dataBusErp['cus_phone']?>" style="width:150px" class="input_text">
</td>
<th scope="row">SNS</th>
<td>
<input type="text" name="cus_sns" value="<?=$dataBusErp['cus_sns']?>" style="width:150px" class="input_text">
</td>
</tr>
<tr class="busResTr">
<th style="border-left:1px solid #e4e4e4" scope="row">항공편명</th>
<td>
<input type="text" name="cus_flight" value="<?=$dataBusErp['cus_flight']?>" style="width:150px" class="input_text">
</td>
<th scope="row">미팅시간</th>
<td>
<input type="text" name="cus_meeting_time" value="<?=$dataBusErp['cus_meeting_time']?>" style="width:150px" class="input_text">
</td>
</tr>
<?php
$depDesWidth = 438;
if($dataBusErp){
$depDesWidth = 431;
}
?>
<tr class="busResTr">
<th style="border-left:1px solid #e4e4e4" scope="row">출발지</th>
<td colspan="3" style="padding-right:0">
<input type="text" name="cus_depature_place" value="<?=$dataBusErp['cus_depature_place']?>" style="width:<?=$depDesWidth?>px" class="input_text">
</td>
</tr>
<tr class="busResTr">
<th style="border-left:1px solid #e4e4e4" scope="row">도착지</th>
<td colspan="3" style="padding-right:0">
<input type="text" name="cus_destination" value="<?=$dataBusErp['cus_destination']?>" style="width:<?=$depDesWidth?>px" class="input_text">
</td>
</tr>
<tr class="busResTr">
<th style="border-left:1px solid #e4e4e4" scope="row">인원</th>
<td>
<input type="text" name="cus_people_cnt" value="<?=$dataBusErp['cus_people_cnt']?>" style="width:150px" class="input_text">
</td>
<th scope="row">짐가방</th>
<td>
<input type="text" name="cus_luggage_bag" value="<?=$dataBusErp['cus_luggage_bag']?>" style="width:150px" class="input_text">
</td>
</tr>
<tr class="busResTr">
<th style="border-left:1px solid #e4e4e4" scope="row">차량종류</th>
<td><input type="text" name="bus_model" value="<?=$dataBusErp['bus_model']?>" class="input_text" style="width:150px;" hname="차량종류" ></td>
<th scope="row">차량번호</th>
<td><input type="text" name="bus_number" value="<?=$dataBusErp['bus_number']?>" class="input_text" style="width:150px;"></td>
</tr>
<tr class="busResTr">
<th style="border-left:1px solid #e4e4e4" scope="row">기사명</th>
<td><input type="text" name="driver_name" value="<?=$dataBusErp['driver_name']?>" class="input_text" style="width:150px;"></td>
<th scope="row">기사연락처</th>
<td>
<?php
if(isset($seq)){
$driverPhone = "100";
}else{
$driverPhone = "150";
}
?>
<input type="text" name="driver_phone" value="<?=$dataBusErp['driver_phone']?>" class="input_text" style="width:<?=$driverPhone?>px;">
<?php
if(isset($seq)){
?>
<input type="button" style="톡border-radius:0;position: relative;left:4px" name="" value="알림톡발송내역" class="Table_btn yellow" onclick="to_dialog.iframe('../reservation/history_mailsms.html?res_no=<?=$data['match_private_bus']?>&type=at','알림톡발송내역','700','540',true,true,'yes');">
<?php
}
?>
</td>
</tr>
<tr class="busResTr">
<th style="border-left:1px solid #e4e4e4" scope="row">판매가</th>
<td>
<input name="total_sell_price" id="total_sell_price" value="<?=number_format($dataBusErp['total_sell_price'])?>" onblur="this.value=comma(this.value)" type="text" style="width:150px;text-align:right;background:#fffde1" class="input_text" hname="판매가격" />
</td>
<th scope="row">공급가</th>
<td><input name="bus_price" id="bus_price" value="<?=number_format($dataBusErp['bus_price'])?>" onblur="this.value=comma(this.value)" type="text" style="width:150px;;background:#fffde1" class="input_text calc"/></td>
</tr>
<tr class="busResTr">
<th style="border-left:1px solid #e4e4e4" scope="row">스케줄<br>(특이사항)</th>
<td colspan="3">
<textarea name="schedule" style="width:442px"><?=$dataBusErp['schedule']?></textarea>
</td>
</tr>
<tr class="busResTr">
<th style="border-left:1px solid #e4e4e4" scope="row">버스<br>
입금영수증<br>
정산영수증</th>
<td colspan="3">
<div class="fileAttachArea">
<img class="fileIcon" src="../../image/board/bullet_disk.gif" alt="파일첨부">
<b>#1</b>
<input type="file" name="MFILE1" />
<?php
if($dataBusErp['MFILE1_org']){
echo "<br>";
?>
<a style="" href="/FileData/erp/<?=$dataBusErp['MFILE1']?>" download>
<img style="position:relative;top:-1px;left:3px;" src="../../image/board/bullet_disk.gif">
<?=$dataBusErp['MFILE1_org']?>
</a>
<?php
}
?>
</div>
</td>
</tr>
</table>
</div>
<div style="clear:both; display:flex; justify-content:center; padding:0;position:relative;top:15px">
<?php
if(isset($seq)){
?>
<span class="Tbtn red" onclick="delete_private_depart(<?=$seq?>);" style="text-align:center;float:left;height:unset;padding:8px 22px">삭제하기</span>
<?php
}
?>
<?php
if(!$alimtalkHistoryCnt){
?>
<!-- <span id="sendAlimTalkThenSaveBtn">저장 후 알림톡 발송</span>-->
<?php
}else{
?>
<span id="sendAlimTalkThenSaveBtn" style="border:1px solid #ccc;background:#ddd">저장후 알림톡 재발송</span>
<?php
}
?>
<input style="margin:0;float:right;display:block;padding:8px 20px;height:unset" type="button" value="저장하기" class="Tbtn gray" onclick="update_frm();">
</div>
</div>
</form>
<!-- /폼 -->
<script type="text/javascript">
$(document).ready(function(){
$('#busResN').click(function(){
$('.busStatus').addClass('red')
$('.busStatus').removeClass('gray')
$('.busStatus').text('미등록');
})
$('#busResY').click(function(){
$('.busStatus').text('예약완료');
$('.busStatus').removeClass('red')
$('.busStatus').addClass('gray')
})
$('#sendAlimTalkThenSaveBtn').click(function(){
$('#kakaoalitalk').attr("checked",true);
setTimeout(function(){
update_frm();
},100)
})
$('#bc_idx').change(function(){
console.log($(this).val());
if($(this).val() != ''){
getPrivateResInfo();
}
})
});
function getPrivateResInfo(){
matchPrivateKey = $('#match_private_bus').val();
console.log('matchKey is ' + matchPrivateKey);
$.ajax({
type: "post",
url: "/admin/ajaxData/",
dataType: 'json',
data: {'mode': 'getPrivateResInfo',matchPrivateKey},
async: false,
success: function (data) {
console.log('data is ' + JSON.stringify(data));
if (data.result == true) {
if(data.data.res_cust_nm){
if(data.data.res_cust_nm == 'KO'){
data.data.res_cust_nm = '한국';
}
$('input[name=cus_name]').val(data.data.res_cust_nm);
}
if(data.data.res_cust_nat_cd){
$('input[name=cus_nation]').val(data.data.res_cust_nat_cd);
}
if(data.data.res_cust_hp){
$('input[name=cus_phone]').val(data.data.res_cust_hp);
}
if(data.data.b2b_sns_id){
$('input[name=cus_sns]').val(data.data.b2b_sns_id);
}
} else {
}
},
error: function (a, b, c) {
console.log('500 error');
}
});
}
function delete_private_depart(seq){
if(!seq){
alert('실패');
return false;
}
if(confirm('정말로 삭제하시겠습니까?')){
location.href='privateDateProc.php?SqlType=del_private&seq='+seq+'&match_private_bus=<?=$data['match_private_bus']?>';
}
}
function update_frm()
{
var f=document.frm_private_frm;
// 폼체크
var result = to_validation(f);
if (result == false) return false;
setTimeout(function(){
$('.ui-dialog-titlebar-close').click();
},2000);
ajax_post("","privateDateProc.php","frm_private_frm");
}
function busResAreaBtn(){
$('.busResTr').css('display','table-row');
$('.busResArea').show();
}
</script>
<iframe name="IMGIF" id="IMGIF" width="0" height="0" style="display:none;"></iframe>
<?
include "../include/footer_iframe.html";
?>