|
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/good_yeonsung/ |
Upload File : |
<?php
include "../include/top_yeonsung.html";
include "_common.php";
// 테이블명
$table = " good_yeonsung ";
// 검색 설정
$sql_where = " ";
if ($tab) $sql_where .= " and tab='{$tab}' "; // 상품구분
if ($search_key_s and $search_word_s) {
if($search_key_s=='srh_d_code') {
$sql_where .= " and (srh_d_code like '%".$search_word_s."%' OR tour_code like '%".$search_word_s."%') ";// 검색어(상품명,행사명,행사코드,담당자명)
} else {
$sql_where .= " and {$search_key_s} like '%".$search_word_s."%' ";// 검색어(상품명,행사명,행사코드,담당자명)
}
}
if ( $date_s1 and $date_s2) $sql_where .= " and (DATE_FORMAT({$date_key},'%Y-%m-%d') >= '{$date_s1}' and DATE_FORMAT({$date_key},'%Y-%m-%d') <= '{$date_s2}' )";// 기간검색(등록일,수정일)
if ($b_uid_s) $sql_where .= " and b_uid='{$b_uid_s}' "; // 1차 카테고리
if ($m_uid_s) $sql_where .= " and m_uid='{$m_uid_s}' "; // 2차 카테고리
if ($s_uid_s) $sql_where .= " and s_uid='{$s_uid_s}' "; // 3차 카테고리
if ($Bidx_s) $sql_where .= " and Bidx='{$Bidx_s}' "; // 국가
if ($Cidx_s) $sql_where .= " and Cidx='{$Cidx_s}' "; // 도시
if ($gmain_s) $sql_where .= " and {$gmain_s}='1' "; // 추천
if ($gdt_s) $sql_where .= " and gdt='{$gdt_s}' "; // 데이투어 구분
if ($b_uid_list) {
$sql_where .= " and b_uid in('".implode("','", $b_uid_list)."') ";
}
// 전체개수
//echo "select count(*) as gtot from {$table} where b_uid='{$b_uid_s}' and m_uid='{$m_uid_s}' ";
//exit;
$data = array();
$memberSeq = $_SESSION['seq'];
if($_SESSION['level'] == 'normal'){
$sql_where .= " AND MEMBER_SEQ = {$memberSeq}";
}
$data = good_list_yeonsung($sql_where,$sql_order,$olds,$line);
$tot_r = db_fetch("select count(*) as gtot from {$table}");
$res_gtot = $tot_r['gtot'];
$total = $tot_r['gtot'];
if($title == '') $title = "<i class='xi-document' style='font-size: 21px;position: relative;top: 2px;'></i><strong>상품등록 & 리스트</strong>";
$kind_code_arr = array(
'today' => '당일투어',
'stay' => '숙박패키지',
'guide' => '가이드투어',
'overseas' => '해외여행',
);
if(!$list_count_s) $list_count_s = 30;
// 페이지수 설정
if (!$page) $page = 1; // 페이지 번호
$line = $list_count_s; // 보여줄 갯수
$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);
function getMemberYeonsungID($memberSeq){
$sql = "SELECT * FROM TB_MEMBER_YEONSUNG WHERE seq = {$memberSeq} ";
$rs = db_fetch($sql);
return $rs['mb_id'];
}
?>
<style>
.T_list th{font-size:12px}
.t_hotel_name{text-align:center}
.T_list td{padding:13px 3px !important;}
</style>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title"><?=$title?></div>
<div class="contents_detail">
<!-- 본문 -->
<?
// 검색폼
require_once("good_list_search_yeonsung.php");
?>
<div id="Content_box">
<script>
$(function(){
$('.chgSiteCategory ').click(function(){
if($(this).attr('val') == 'en'){
$('select[name="lang"]').val();
}else{
$('select[name="lang"]').val($(this).attr('val'));
}
$('select[name="lang"]').val($(this).attr('val'));
document.frm_search.submit();
return false;
});
});
</script>
<!-- 폼 -->
<form name="frm_list" id="frm_list" method="post" style="margin-top:40px">
<input type="hidden" name="SqlType" value="g_ok_updt" />
<div class="c_top_sch_wrap">
<!-- 상품정렬 -->
<ul class="c_top_sch_r">
<li>
<a href="javascript:;" style="padding: 6px 25px 4px;font-weight: 600;" class="Tbtn red" onclick="javascript:document.location.href='good_write.html';">상품등록</a>
</li>
<li class="ml10">
<select name="order_by_s" id="order_by_s">
<option value="g_regdate desc" <?=($order_by_s=="g_regdate desc")?"selected":""?>>등록일 ↑</option>
<option value="g_regdate" <?=($order_by_s=="g_regdate")?"selected":""?>>등록일 ↓</option>
<option value="g_moddate desc" <?=($order_by_s=="g_moddate desc")?"selected":""?>>수정일 ↑</option>
<option value="g_moddate" <?=($order_by_s=="g_moddate")?"selected":""?>>수정일 ↓</option>
<option value="g_ok desc" <?=($order_by_s=="g_ok desc")?"selected":""?>>노출순서 ↑</option>
<option value="g_no" <?=($order_by_s=="g_no")?"selected":""?>>노출순서 ↓</option>
</select>
</li>
<li>
<select name="list_count_s" id="list_count_s" >
<option value="20" <?=($list_count_s==20)?"selected":""?>>20개 보기</option>
<option value="30" <?=($list_count_s==30)?"selected":""?>>30개 보기</option>
<option value="50" <?=($list_count_s==50)?"selected":""?>>50개 보기</option>
<option value="70" <?=($list_count_s==70)?"selected":""?>>70개 보기</option>
</select>
</li>
</ul><!-- 상품등록 -->
</div>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="T_list" >
<thead>
<tr>
<th width="20">
<label for="checkall" class="v_none2">선택 체크</label><input type="checkbox" name="checkall" id="checkall" /></th>
<th style="display:none" width="20">복사</th>
<th width="80">등록일/수정일</th>
<th width="80">투어코드</th>
<th width="80">상품종류</th>
<th width="400">상품명</th>
<th width="100">대표이미지</th>
<th width="100">서브이미지1</th>
<th width="100">서브이미지2</th>
<th width="100">서브이미지3</th>
<th width="80">PDF출력</th>
<th width="80">삭제/과제제출</th>
</tr>
</thead>
<tbody>
<?php
$noData = false;
for($i=0 ; $i < count($data) ; $i++){
$noData = true;
$memberID = getMemberYeonsungID($data[$i]['MEMBER_SEQ']);
/*if(devCookie()){
p($memberID);
}*/
$row = good_list_replace($data[$i]);
// p($row);
// exit;
$num = $total - ($page - 1) * $line - $i;
// 개수 초기화 & 이미지 필터
$filter = "style='filter:alpha(opacity=20);opacity:0.2;'";
$span_gray = "<span style='comment_gray'>(0)</span>";
// 출발일정 아이콘
if ( $row['date_cnt'] > 0 ) {
$date_cnt_arr['_cnt'] = str_replace("0",$row['date_cnt'],str_replace("_grap","",$span_gray));
$date_cnt_arr['_filter'] = "";
}else{
$date_cnt_arr['_cnt'] = $span_gray;
$date_cnt_arr['_filter'] = $filter;
}
// 옵션
if ( $row['option_cnt'] > 0 ) {
$option_cnt_arr['_cnt'] = str_replace("0",$row['option_cnt'],str_replace("_grap","",$span_gray));
$option_cnt_arr['_filter'] = "on";
}else{
$option_cnt_arr['_cnt'] = $span_gray;
$option_cnt_arr['_filter'] = $filter;
}
// 일정표 아이콘
if ( $row['schedule_cnt'] > 0 ) {
$schedule_cnt_arr['_cnt'] = str_replace("0",$row['schedule_cnt'],str_replace("_grap","",$span_gray));
$schedule_cnt_arr['_filter'] = "on";
}else{
$schedule_cnt_arr['_cnt'] = $span_gray;
$schedule_cnt_arr['_filter'] = "gray";
}
// 여행정보 아이콘
if ( $row['tourinfo_cnt'] > 0 ) {
$tourinfo_cnt_arr['_cnt'] = str_replace("0",$row['tourinfo_cnt'],str_replace("_grap","",$span_gray));
$tourinfo_cnt_arr['_filter'] = "on";
}else{
$tourinfo_cnt_arr['_cnt'] = $span_gray;
$tourinfo_cnt_arr['_filter'] = "gray";
}
// 호텔정보 아이콘
if ( $row['hotel_cnt'] > 0 ) {
$hotel_cnt_arr['_cnt'] = str_replace("0",$row['hotel_cnt'],str_replace("_grap","",$span_gray));
$hotel_cnt_arr['_filter'] = "on";
}else{
$hotel_cnt_arr['_cnt'] = $span_gray;
$hotel_cnt_arr['_filter'] = "gray";
}
// 갤러리정보 아이콘
if ( $row['gallery_cnt'] > 0 ) {
$gallery_cnt_arr['_cnt'] = str_replace("0",$row['gallery_cnt'],str_replace("_grap","",$span_gray));
$gallery_cnt_arr['_filter'] = "on";
}else{
$gallery_cnt_arr['_cnt'] = $span_gray;
$gallery_cnt_arr['_filter'] = "gray";
}
// 출발지
if ( $row['depot_cnt'] ) {
$depot_cnt_arr['_cnt'] = str_replace("0",$row['depot_cnt'],str_replace("_grap","",$span_gray));
$depot_cnt_arr['_filter'] = "on";
}else{
$depot_cnt_arr['_cnt'] = $span_gray;
$depot_cnt_arr['_filter'] = "gray";
}
// 지도
if ( $row['map_x'] > 0 ) {
$map_cnt_arr['_cnt'] = str_replace("0","1",str_replace("_grap","",$span_gray));
$map_cnt_arr['_filter'] = "on";
}else{
$map_cnt_arr['_cnt'] = $span_gray;
$map_cnt_arr['_filter'] = "gray";
}
?>
<tr>
<td><input type="checkbox" name="guid_arr[]" class="item_checkbox" value="<?=$row['g_uid']?>" /></td>
<td style="display: none">
<img src="../image/icon/btn_copy.gif" id="btn_menu_<?=$num?>" onclick="<?if(!$tab){?>alert('좌측카테고리를 먼저 선택하세요.');return;<?}?>choose_menu('<?=$num?>','<?=$row['g_uid']?>')" title="상품복사" style="cursor:pointer;"/>
</td>
<td><?=$row['g_regdate3']?><br><?=$row['g_moddate3']?></td><!-- 등록일/수정일 -->
<td>
<?=$row['tour_code']?>
<? if($row['api_icon']) { ?>
<br><br><?=$row['api_icon']?>
<? } ?>
</td>
<td><?=$kind_code_arr[$row['kind_code']]?></td>
<td class="t_hotel_name">
<a href="good_edit_yeonsung.html?g_uid=<?=$row['g_uid']?>"><?=$row['g_title']?></a><!-- 상품명 -->
</td>
<td>
<img src="<?=$row['img_src_thum']?>" onerror="this.src='http://www.tourboss.co.kr/image/product/noimage_tourboss.jpg'" alt="상품이미지" width="88" height="57" style="cursor:pointer;" onClick="to_dialog.image('<?=$row['img_src']?>')" />
</td><!-- 이미지 -->
<td>
<img src="<?=$row['img_srcs1_thum']?>" onerror="this.src='http://www.tourboss.co.kr/image/product/noimage_tourboss.jpg'" alt="상품이미지" width="88" height="57" style="cursor:pointer;" onClick="to_dialog.image('<?=$row['img_srcs1']?>')" />
</td><!-- 이미지 -->
<td>
<img src="<?=$row['img_srcs2_thum']?>" onerror="this.src='http://www.tourboss.co.kr/image/product/noimage_tourboss.jpg'" alt="상품이미지" width="88" height="57" style="cursor:pointer;" onClick="to_dialog.image('<?=$row['img_srcs2']?>')" />
</td><!-- 이미지 -->
<td>
<img src="<?=$row['img_srcs3_thum']?>" onerror="this.src='http://www.tourboss.co.kr/image/product/noimage_tourboss.jpg'" alt="상품이미지" width="88" height="57" style="cursor:pointer;" onClick="to_dialog.image('<?=$row['img_srcs3']?>')" />
</td><!-- 이미지 -->
<td>
<input class="Table_btn gray" style="display:none;padding:0 10px" onclick="if(!confirm('정말삭제하시겠습니까?'))return;ajax_loader('good_proc_yeonsung.php?SqlType=delete_good&g_uid=<?=$row['g_uid']?>');" type="button" value="PDF 다운"/>
<a href="../TCPDF/erp/pdf_good_yeonsung.php?g_uid=<?=$row['g_uid']?>&memberID=<?=$memberID?>" target="_blank">
<span style="padding:6px 11px 4px" class="Table_btn gray">PDF 다운</span>
</a>
</td>
<td>
<input class="Table_btn red" onclick="if(!confirm('정말삭제하시겠습니까?'))return;ajax_loader('good_proc_yeonsung.php?SqlType=delete_good&g_uid=<?=$row['g_uid']?>');" type="button" value="삭제"/>
<?php
if($row['send_status'] == 'N'){
?>
<input class="Table_btn blue" onclick="if(!confirm('정말제출하시겠습니까?'))return;ajax_loader('good_proc_yeonsung.php?SqlType=send_good&g_uid=<?=$row['g_uid']?>');" type="button" value="제출"/>
<?php
}else{
?>
<input class="Table_btn gray" type="button" value="완료"/>
<?php
}
?>
</td>
</tr>
<?}
if(!$noData){
?>
<tr>
<td colspan="11">데이터가 없습니다.</td>
</tr>
<?php
}
?>
</tbody>
</table>
</form>
<!-- /폼 -->
<!-- /본문 -->
</div>
<?php
// echo $total_page;
// echo '<br>';
// echo $page;
// echo '<br>';
// echo $list;
// echo '<br>';
?>
<?=adm_get_paging($total_page, $page, $list, "?$href&page=", "")?>
</div>
</div>
</div>
<div style="display:none;width:150px;z-index:9999;" id="menu_box" >
<?
// 1차 카테고리
$arr_1 = TO_get_bc("","N"," and DelFlag='N' and tab='{$tab}' ");
// 1차 카테고리
//if (count($arr_1)>0) echo "<ul>";
for($j=0 ; $j<count($arr_1) ; $j++)
{
$arr1 = $arr_1[$j];
?>
<li><a href="javascript:;" onclick="good_copy('<?=$arr1['b_uid']?>','','');"><?=$arr1['b_name']?>(<?=$arr1['b_uid']?>)</a>
<?
// 2차 카테고리
$arr_2 = TO_get_mc($arr1['b_uid'],"","N");
if (count($arr_2)>0) echo "<ul>";
for($k=0 ; $k<count($arr_2) ; $k++)
{
$arr2 = $arr_2[$k];
?>
<li><a href="javascript:;" onclick="good_copy('<?=$arr1['b_uid']?>','<?=$arr2['m_uid']?>','');"><?=$arr2['m_name']?>(<?=$arr2['m_uid']?>)</a>
<?
// 3차 카테고리
$arr_3 = TO_get_sc($arr1['b_uid'],$arr2['m_uid'],"","N");
if (count($arr_3)>0) echo "<ul>";
for($n=0 ; $n<count($arr_3) ; $n++)
{
$arr3 = $arr_3[$n];
?>
<li><a href="javascript:;" onclick="good_copy('<?=$arr1['b_uid']?>','<?=$arr2['m_uid']?>','<?=$arr3['s_uid']?>');"><?=$arr3['s_name']?>(<?=$arr3['s_uid']?>)</a></li>
<?
}
if (count($arr_3)>0) echo "</ul>";
?>
</li>
<?
}
if (count($arr_2)>0) echo "</ul>";
?>
</li>
<?
}
//if (count($arr_1)>0) echo "</ul>";
?>
</li>
</div>
<script Language="Javascript">
var g_uid;
// 상품카피
function good_copy(b_uid,m_uid,s_uid)
{
var params = "tab=<?=$tab?>&b_uid="+b_uid+"&m_uid="+m_uid+"&s_uid="+s_uid+"&g_uid="+g_uid;
if(!m_uid) return;
if (!confirm('해당카테고리에 여행상품을 복사 하시겠습니까?\n기본정보, 지도정보, 여행정보만 복사됩니다.')) return;
ajax_post("","good_proc_yeonsung.php?SqlType=good_copy&"+params);
}
// 상품카피 메뉴
function choose_menu(num,gid)
{
var obj = $("#menu_box");
var e = ($("#btn_menu_"+num).offset());
obj.css({"left":e.left-parseInt(10)+"px","top":e.top});
g_uid = gid;
$("#menu_box").fadeToggle("fast","linear");
}
//순서조정
function change_ordernum()
{
var f = document.frm_list;
if(!confirm('순서를 변경하시겠습니까?')) return;
f.SqlType.value='change_ordernum';
ajax_post('ajax_proc','good_proc_yeonsung.php','frm_list');
}
// 추천관리
function check_gmain(seq,g_main,yn_str)
{
var yn_str = "N";
if ( $("#gmain_"+seq).is(":checked") == true ) yn_str = "Y";
ajax_loader('sights_register_proc.php?SqlType=chuchun&seq='+seq+'&g_main='+g_main+'&yn_str='+yn_str);
}
$(document).ready(function(){
$("#menu_box").menu();
$("#order_by_s").on("change",function(){
var order_by_s = $("#order_by_s").val();
var list_count_s = $("#list_count_s").val();
window.document.location.href='<?=$PHP_SELF?>?<?=$href?>&order_by_s='+order_by_s+'&list_count_s='+list_count_s;
});
$("#list_count_s").on("change",function(){
var order_by_s = $("#order_by_s").val();
var list_count_s = $("#list_count_s").val();
window.document.location.href='<?=$PHP_SELF?>?<?=$href?>&order_by_s='+order_by_s+'&list_count_s='+list_count_s;
});
$("#menu_box").mouseleave(function(event){
$("#menu_box").hide();
g_uid='';
});
$("#checkall").on("click",function(){
$(".item_checkbox").prop("checked",$(this).prop("checked"));
});
$(".item_chg_order_state").on("click",function(){
if($(".item_checkbox:checked").length==0){
alert('적어도 한개 항목을 선택해 주세요.');
return;
}
if(!confirm('사용상태를 변경하시겠습니까?')) return;
ajax_post("ajax_proc","good_proc_yeonsung.php","frm_list");
});
ajax_loader('../good/good_edit_cityarea_ajax.html?mode=city_search&Bidx=<?=$Bidx_s?>&Cidx=<?=$Cidx_s?>','ajax_city');
});
</script>
<?
include "../include/footer_yeonsung.html";
?>
<style type="text/css">
#menu_box {position:absolute;padding:5px 5px 5px;border:1px solid #A398EB;background-color:#ffffff;}
#menu_box ul{width:150px;}
</style>