|
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 : |
<?
include "../include/top.html";
include "../reservation/_common.php";
if(!$d_start_s1) $d_start_s1 = date("Y-m-d"); // 기간 검색
if(!$d_start_s2) $d_start_s2 = date("Y-m-d",strtotime(" +4 month")); // 기간 검색
// 상품구분
$tab_arr = TO_good_module("good");
//테이블명
$table = "date";
// 검색 설정
$sql_where = " ";
if ( $d_start_s1 and $d_start_s2 ) $sql_where .= " and d_start between '{$d_start_s1}' and '{$d_start_s2}' ";// 출발일
if ( $d_title_s ) $sql_where .= " and d_title like '%{$d_title_s}%' ";// 행사명
if ( $tab_s ) $sql_where .= " and tab = '{$tab_s}' ";
if ( $b_uid_s ) $sql_where .= " and b_uid='{$b_uid_s}' ";
if ( $m_uid_s ) $sql_where .= " and m_uid='{$m_uid_s}' ";
$sql = "
select count(*) as total from
date a
left join (SELECT 0 g_uid,'' b_uid , '' m_uid,'' s_uid,'' g_image1,'' admin_id , '' admin_nm,'' g_title, '' gdt, '' g_sch ) b
on a.g_uid=b.g_uid
where 1 {$sql_where}
";
$row = db_fetch($sql);
$total = $row[total];
// 페이지수 설정
if (!$page) $page = 1; // 페이지 번호
$line = 20; // 보여줄 갯수
$list = 10; // 블럭 갯수
$total_page = ceil($total / $line); // 총페이지
if ($total == 0) $total_page = 1; // 데이터가 하나도 없으면 총페이지 1
if ($page > $total_page) $page = $total_page; // 페이지가 전체 페이지보다 크면 페이지 번호를 바꿈
$total_list = intval($total_page / $list);
if ($total_page % $list == 0) $total_list--;
$curr_list = intval($page / $list);
if ($page % $list == 0) $curr_list--;
$start_page = $curr_list * $list + 1;
$prev_list = $start_page - $list;
$next_list = $start_page + $list;
$olds = $line * ($page - 1);
// 정렬 설정
$sql_order="";
// limit
$limit = " $olds , $line ";
//배열에 저장
$data = array();
$data = date_list("","none",$sql_where,$sql_order,$limit);
?>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title">행사목록</div>
<div class="contents_detail">
<!-- 폼 -->
<form name="frm_search" id="frm_search" method="get">
<div class="c_top_bar">
<div class="lo_left">
출발일
<input type="text" name="d_start_s1" class="cal_input" value="<?=$d_start_s1?>" size="15" onclick="AjaxCal(this,event);"> ~
<input type="text" name="d_start_s2" class="cal_input" value="<?=$d_start_s2?>" size="15" onclick="AjaxCal(this,event);">
<select name="tab_s" id="tab_s" onchange="ajax_loader('good_selbox_ajax.html?SqlType=mc','ajax_search_mc');ajax_loader('good_selbox_ajax.html?SqlType=bc&tour='+this.value,'ajax_search_bc',false);" class="lo_left top_input">
<option value="">==상품구분==</option>
<?
for($i=0 ; $i < count($tab_arr) ; $i++){
$arr = $tab_arr[$i];
?>
<option value="<?=$arr['code']?>" <?=($arr['code']==$tab_s)?"selected":""?>><?=$arr['code']?> | <?=$arr['name']?></option>
<?}?>
</select>
<span id="ajax_search_bc">
<select name="b_uid_s" id="b_uid_s" class="lo_left top_input">
<option value="">==1차분류==</option>
</select>
</span>
<span id="ajax_search_mc">
<select name="m_uid_s" id="m_uid_s" class="lo_left top_input">
<option value="">==2차분류==</option>
</select>
</span>
행사명 <input class="search_box" id="d_title_s" name="d_title_s" value="<?=$d_title_s?>" type="text" /><input type="image" src="../image/btn/btn_search.gif" align="top" alt="검색" class="input_img input_btn_search" />
</div>
</div>
</form>
<!-- /폼 -->
<div class="hotel_wrap">
<ul class="product_res">
<li class="lo_left" style="width:100%;">
<!-- 폼 -->
<h2 class="mt35">행사목록</h2>
<div style="height:250px;overflow-y:auto;overflow-x:hidden;">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_list">
<thead>
<tr>
<td colspan="33" class="t_top_line"></td>
</tr>
<tr>
<th width="30">No.</th>
<th>행사명</th>
<th>타입</th>
<th>출발일</th>
<th>출발편</th>
<th>도착일</th>
<th>도착편</th>
<th>성인요금</th>
<th>아동요금</th>
<th>유아요금</th>
<th width="40">정원</th>
<th width="60">예약</th>
</tr>
</thead>
<tbody>
<?
for($i=0 ; $i < count($data) ; $i++){
$row = $data[$i];
$num = $total - ($page - 1) * $line - $i;
?>
<tr id="d_title_<?=$row['d_uid']?>" class="mouse_over" onclick="ajax_post('ajax_res_list','good_res_ajax.html?g_uid=<?=$row['g_uid']?>&d_uid=<?=$row['d_uid']?>');">
<td><?=$num?></td>
<td style="text-align:left;"><?=$row['d_title']?></td><!-- 행사명 -->
<td><?=$row['tab']?></td>
<td><?=$row['d_start2']?>(<?=$row['d_start_yo']?>)</td>
<td><?=$row['d_plane1']?></td>
<td><?=$row['d_end2']?>(<?=$row['d_end_yo']?>)</td>
<td><?=$row['d_plane2']?></td>
<td style="text-align:right;padding-right:10px;"><?=number_format($row['d_money1'])?>원</td>
<td style="text-align:right;padding-right:10px;"><?=number_format($row['d_money2'])?>원</td>
<td style="text-align:right;padding-right:10px;"><?=number_format($row['d_money3'])?>원</td>
<td><span style="<?if($row['d_people1']>0)echo "font-weight:bold;color:#3333FF;";?>"><?=$row['d_people1']?></span>/<?=$row['d_people2']?></td><!-- 예약/정원 -->
<td>
<?if ( $row['reserv_yn'] == "Y" ) { ?>
<input type="button" value="<?=$row['d_ok_str3']?>" class="btn_C_left" onclick="reserv_good('<?=$row['g_uid']?>','<?=$row['d_uid']?>');"><span class="btn_C_right"></span></td><!-- 예약버튼 -->
<?}else{?>
<?=$row['d_ok_str3']?>
<?}?>
</td>
</tr>
<?
}
?>
</tbody>
</table>
<?
echo adm_get_paging($total_page, $page, $list, "?$nhref&page=", "");
?>
</div>
</li>
</ul>
<div class="mt30">
<!-- 폼 -->
<h2>예약목록</h2>
<div id="ajax_res_list" style="width:100%;overflow-x:auto;">
<table border="0" cellspacing="0" cellpadding="0" width="1490" class="t_list">
<thead>
<tr>
<td colspan="20" class="t_top_line"></td>
</tr>
<tr>
<th width="30">No.</th>
<th width="120">예약번호</th>
<th>행사명</th>
<th width="30">상태</th>
<th>고객명</th>
<th>핸드폰</th>
<th width="80">출발일</th>
<th width="80">도착일</th>
<th width="80">성인요금</th>
<th width="30">인원</th>
<th width="80">판매요금</th>
<th width="80">미납요금</th>
<th width="80">추가액</th>
<th width="80">할인액</th>
<th>담당자</th>
<th width="80">입력일</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
<br>
<br>
</div>
<!-- /폼 -->
</div>
</div>
</div>
</div>
</div>
<script type="text/javascript">
var res_good_num='';
function reserv_good(g_uid,d_uid)
{
if ( !confirm('예약을 진행하시겠습니까?') ) return;
to_dialog.iframe('good_res_reg.html?g_uid='+g_uid+'&d_uid='+d_uid,'여행상품예약','1200','700',true,true,'yes');
}
$(".mouse_over").bind({
mouseover:function(e){ $(this).css({"background-color":"#D7D7D7","cursor":"pointer"}); },
mouseout:function(e){ $(this).css("background-color","#FFFFFF"); }
});
window.onload=function()
{
ajax_loader('good_selbox_ajax.html?SqlType=bc&tour=<?=$tab_s?>&b_uid_s=<?=$b_uid_s?>','ajax_search_bc');
ajax_loader('good_selbox_ajax.html?SqlType=mc&b_uid_s=<?=$b_uid_s?>&m_uid_s=<?=$m_uid_s?>','ajax_search_mc');
}
</script>
<? include "../include/footer.html" ?>