|
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_iframe.html";
include "../reservation/_common.php";
// 상품구분
$tab_arr = TO_good_module("good");
//테이블명
$table = "good";
// 검색 설정
$sql_where = "";
if($tab_s) $sql_where .= " and tab = '{$tab_s}' ";// 상품구분
if($b_uid_s) $sql_where .= " and b_uid = '{$b_uid_s}' ";// 1차 카테고리id
if($m_uid_s) $sql_where .= " and m_uid = '{$m_uid_s}' "; // 2차 카테고리id
if($g_title_s) $sql_where .= " and g_title like '%{$g_title_s}%' ";// 여행상품
// 리스트 수 가져옴
$sql = "select count(*) as total from {$table} where 0=0 {$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="";
//배열에 저장
$data = array();
$data = good_list($sql_where,$sql_order,$olds,$line);
?>
<div class="iframe" style="padding-left:0px;margin-left:10px;">
<!-- 폼 -->
<form name="frm_search" id="frm_search" method="get">
<input type="hidden" name="tmp_layer_id" value="<?=$tmp_layer_id?>">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="setting_write">
<tbody>
<tr><th>
<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>
<span class="ml10">상품명</span> <input class="search_box" id="g_title_s" name="g_title_s" value="<?=$g_title_s?>" type="text" /><input type="image" src="../image/btn/btn_search.gif" align="top" alt="검색" class="input_img input_btn_search" />
</th></tr>
</tbody>
</table>
</form>
<!-- /폼 -->
<div class="hotel_wrap">
<ul class="product_res">
<li class="lo_left" style="width:40%">
<!-- 폼 -->
<h2 class="mt35">상품목록</h2>
<div style="overflow-y:auto;overflow-x:hidden;">
<table width="95%" border="0" cellspacing="0" cellpadding="0" class="t_list">
<colgroup>
<col width="10%" />
<col />
<col width="15%" />
</colgroup>
<thead>
<tr>
<td colspan="3" class="t_top_line"></td>
</tr>
<tr>
<th width="30">No.</th>
<th>상품명</th>
<th width="50">행사 달(月)</th>
</tr>
</thead>
<tbody>
<?
for($i=0 ; $i < count($data) ; $i++){
$arr = good_list_replace($data[$i]);
$num = $total - ($page - 1) * $line - $i;
?>
<tr id="good_num_<?=$arr['g_uid']?>" class="mouse_over" onclick="ajax_post('ajax_date_list','good_res_date_ajax.html?g_uid=<?=$arr['g_uid']?>&tab=<?=$tab_s?>&skin=resgood_contabedit');">
<td><?=$num?></td>
<td style="text-align:left;"><?=$arr['g_title']?></td><!-- 상품명 -->
<td style="text-align:left;"><?=$arr['after_month']?></td><!-- 행사가 있는 달 -->
<!-- <td><?=$arr['date_all_cnt']?></td> 행사개수 -->
</tr>
<?
}
?>
</tbody>
</table>
<?
echo adm_get_paging($total_page, $page, $list, "?$ehref&page=", "");
?>
</div>
</li>
<li class="lo_right" style="width:60%">
<div id="ajax_date_list">
<h2 class="mt35">행사목록</h2>
<table border="0" cellspacing="0" cellpadding="0" width="100%" class="t_list" >
<thead>
<tr>
<td colspan="10" class="t_top_line"></td>
</tr>
<tr>
<th width="35">No.</th>
<th>행사명</th>
<th width="80">출발일시</th>
<th width="80">도착일시</th>
<th width="80">성인요금</th>
<th width="30">정원</th>
<th width="30">예약</th>
</tr>
</thead>
</table>
</div>
</li>
</ul>
</div>
</div>
<?
include "../include/footer_iframe.html";
?>
<script type="text/javascript">
var good_list_num = '';
var res_good_num='';
window.onload=function()
{
$(".mouse_over").bind({
mouseover:function(e){ $(this).css({"background-color":"#D7D7D7","cursor":"pointer"}); },
mouseout:function(e){ $(this).css("background-color","#FFFFFF"); }
});
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');
}
function wirte_date_form(tab,g_uid,d_uid,d_title,d_start,d_starttime_1,d_starttime_2,d_plane1,period,periodStr,d_endtime_1,d_endtime_2,d_plane2,d_money1,d_money2,d_money3,d_money7,d_people2)
{
if (!confirm('행사연결을 계속진행하시겠습니까?')) return;
$("#g_uid",parent.document).val(g_uid);
$("#d_uid",parent.document).val(d_uid);
$("#d_title",parent.document).val(d_title);
$("#d_start",parent.document).val(d_start);
$("#d_starttime_1",parent.document).val(d_starttime_1);
$("#d_starttime_2",parent.document).val(d_starttime_2);
$("#d_plane1",parent.document).val(d_plane1);
$("#period",parent.document).val(period);
$("#periodStr",parent.document).val(periodStr);
$("#d_endtime_1",parent.document).val(d_endtime_1);
$("#d_endtime_2",parent.document).val(d_endtime_2);
$("#d_plane2",parent.document).val(d_plane2);
$("#d_money1",parent.document).val(d_money1);
$("#d_money2",parent.document).val(d_money2);
$("#d_money3",parent.document).val(d_money3);
$("#d_money7",parent.document).val(d_money7);
$(".btn_conn_ev",parent.document).hide();
to_dialog_close();
}
function to_dialog_close()
{
$("#SqlType",parent.document).val('conn_date');
parent.write_readony_date('d'); // 폼 수정금지
parent.to_dialog.close('<?=$tmp_layer_id?>'); // 창닫기
}
</script>