|
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/good/ |
Upload File : |
<?
include "../include/top.html";
// 상품정보
$arr = good_list(" and g_uid='{$g_uid}' ");
$row = good_list_replace($arr[0]);
if(!$tab) {
$tab=$row['tab'];
}
include "_common.php";
// 1차카테고리
//$bc_arr = TO_get_bc("","N"," and tab='{$tab}' ");
if($b_uid_s) $bc_arr = TO_get_bc($b_uid_s,"N"," and tab='{$tab}' ");
else $bc_arr = TO_get_bc("","N"," and tab='{$tab}' ");
//언어
$lang = $bc_arr[0][b_lang];
// 국가 목록
$country_arr = to_area_b("",""," and DelFlag='N' ",$lang);
//$country_arr = to_area_b("",""," and DelFlag='N' ");
// 특징아이콘
if($lang=='ko' || $lang=='ag') $icon_code = "TSPE";
elseif($lang=='en') $icon_code = "TSIE";
elseif($lang=='cn') $icon_code = "TSIC";
elseif($lang=='hk') $icon_code = "TSIH";
$special_arr = base_codec("TGO",$icon_code,"","N");
// 관리자목록
$admin_arr = member_fetch(" and mb_level <= 10 and del_flag='N' ");
// 미팅장소
$meeting_place_arr = $row['g_meeting_all'];
//관련상품
//모든 1차카테고리
$data_bc1 = TO_get_bc($g_uid_s,"N"," and tab='{$tab}' ");
$lang = $data_bc1[0]['b_lang'];
//관련상품 출력
$regood_arr = array();
$regood = db_query("select * from TB_GOOD_RELATED where g_uid='$g_uid' order by ordernum");
while ($rowgood = db_fetch_array($regood)) {
$regood_arr[] = $rowgood;
}
$CommonTour = new CommonTour();
$sql_where = " WHERE `g_uid`='".$g_uid."'";
$correct_table = 'REVIEW';
$sql = "SELECT * FROM `REVIEW` ".$sql_where;
$rs = db_query($sql);
while ($v = db_fetch_array($rs)) {
$correct_table = 'REVIEW';
$url_domain = 'https://www.tourboss.co.kr/';
}
$sql = "SELECT * FROM `TWREV` ".$sql_where;
$rs = db_query($sql);
while ($v = db_fetch_array($rs)) {
$correct_table = 'TWREV';
$url_domain = 'https://www.tktravelkorea.com/';
}
$sql = "SELECT * FROM `CNREV` ".$sql_where;
$rs = db_query($sql);
while ($v = db_fetch_array($rs)) {
$correct_table = 'CNREV';
$url_domain = 'https://www.tktravelkorea.com/';
}
$sql = "SELECT * FROM `ENREV` ".$sql_where;
$rs = db_query($sql);
while ($v = db_fetch_array($rs)) {
$correct_table = 'ENREV';
$url_domain = 'https://www.tktravelkorea.com/';
}
$BD_CD = $correct_table;
if($BD_CD=='ENREV') {$lang='en';$bbs_review=$BD_CD;}
elseif($BD_CD=='CNREV') {$lang='cn';$bbs_review=$BD_CD;}
elseif($BD_CD=='TWREV') {$lang='hk';$bbs_review=$BD_CD;}
elseif($BD_CD=='REVIEW'){$lang='ko';$bbs_review=$BD_CD;}
else {$lang='ko';$bbs_review=$BD_CD;}
$BOARD_INFO = board_info_list('',$BD_CD);
$BOARD_INFO = $BOARD_INFO[0];
$sql = "SELECT * FROM `good` WHERE `g_uid` = '".$g_uid."'";
$rs = db_query($sql);
$title = db_fetch_array($rs);
//검색
if ($mode == "search" && $input_key) {
$sql_where .= " and ".$select_key." like '%".$input_key."%' ";
}
//if($b_uid_s) $sql_where .= " and b_uid= '{$b_uid_s}' ";
// 정렬 설정
$sql_order = "";
if ($BOARD_INFO[BD_OD] == "Y") $sql_order .= " OrderNum ASC, ";
$sql_order .= " FIXED_YN ASC, MREF DESC, MSTEP ASC, MSEQ DESC ";
$total = TBL_TOTAL($BD_CD,$sql_where);
/*if(devCookie()){
echo $total;
exit;
}*/
$total = TBL_TOTAL($BD_CD,$sql_where);
$notanswered_icon = '';
// 페이지수 설정
if (!$page) $page = 1; // 페이지 번호
$line = ($BOARD_INFO[BD_PS])?$BOARD_INFO[BD_PS]:20; // 보여줄 갯수
$list = ($BOARD_INFO[BD_PM])?$BOARD_INFO[BD_PM]: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 = "SELECT * FROM `".$correct_table."`".$sql_where." ORDER BY ".$sql_order." LIMIT ".$olds." , ".$line;
$rs = db_query($sql);
//print_r ($sql);
//리스트불러오기
//$CMM = board_list($correct_table,$sql_where,$sql_order,$olds,$line);
//print_r($CMM);
//파라메터
$href = "BD_CD=".str_replace( '`', '', $BD_CD);
$href.= "&b_uid_s=$b_uid_s";
$href.= "&m_uid_s=$m_uid_s";
$href.= "&s_uid_s=$s_uid_s";
$href.= "&g_uid=$g_uid";
$href.= "&mseq=$MSEQ";
$href.= "&mode=$mode";
$href.= "&select_key=$select_key";
$href.= "&input_key=$input_key";
$param = $href."&page=$page";
// 1차카테고리
//$data_bc = TO_get_bc("","N");
//$data_bc = TO_get_bc("","N"," and b_lang='{$lang}' ");
?>
<style>
.seoImg img{width:18px}
.seoImg span{margin-right:17px}
</style>
<script type="text/javascript">
$(document).ready(function(){
var tbl = $("#board_list_tbl");
// 테이블 헤더에 있는 checkbox 클릭시
$("#checkall", tbl).click(function(){
if( $(this).prop("checked")){
//$(":checkbox", tbl).attr("checked",true);
$(":checkbox", tbl).attr('checked','checked');
}else{
//$(":checkbox", tbl).attr('checked',false);
$(":checkbox", tbl).removeAttr('checked');
}
// 모든 체크박스에 change 이벤트 발생시키기
//$(":checkbox", tbl).trigger("change");
});
// 헤더에 있는 체크박스외 다른 체크박스 클릭시
$(":checkbox:not(:first)", tbl).click(function(){
var allCnt = $(":checkbox:not(:first)", tbl).length;
var checkedCnt = $(":checkbox:not(:first)", tbl).filter(":checked").length;
// 전체 체크박스 갯수와 현재 체크된 체크박스 갯수를 비교해서 헤더에 있는 체크박스 체크할지 말지 판단
if( allCnt==checkedCnt ){
$(":checkbox:first", tbl).attr("checked", true);
}else{
$(":checkbox:first", tbl).attr("checked", false);
}
});
});
function board_del(MSEQ){
if(!MSEQ) return;
if(MSEQ=='check'){
var checkedCnt = $(":checkbox:not(:first)").filter(":checked").length;
if(checkedCnt==0){
alert('삭제할 글을 체크해주세요');
return;
}
if(confirm('삭제후 글을 복원할 수 없습니다. 삭제하시겠습니까?')){
document.getElementById('SqlType').value = "delete";
ajax_post('','proc.php','board_List');
}
}else{
if(confirm('삭제후 글을 복원할 수 없습니다. 삭제하시겠습니까?')){
// alert('<?=$param?>&SqlType=delete&MSEQ[0]='+MSEQ);
//ajax_post('testdiv','proc.php','','<?=$param?>&SqlType=delete&MSEQ[0]='+MSEQ);
//alert("proc.php?<?=$param?>&SqlType=delete&MSEQ[0]="+MSEQ);
location.href = "proc.php?SqlType=delete&MSEQ[0]="+MSEQ+"&<?=$param?>";
}
}
}
</script>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title">게시판 관리<span class="arrow">></span><strong><?=str_replace( '`', '', $title['g_title']);?></strong></div>
<div class="contents_detail">
<form name="Search_List" method="GET" action="<?=$PHP_SELF?>">
<input type="hidden" name="mode" value="search" />
<input type="hidden" name="BD_CD" id="BD_CD" value="<?=$BD_CD?>" />
<!---<div class="c_top_bar">
<ul class="c_top_search">
<li>
<select name="select_key" id="select_key">
<option value="MTITLE" <?if($select_key=='MTITLE') echo "selected";?>>제목</option>
<option value="MEM_NM" <?if($select_key=='MEM_NM') echo "selected";?>>작성자</option>
<option value="MCONT" <?if($select_key=='MCONT') echo "selected";?>>내용</option>
</select>
</li>
<li>
<label for="input_key" class="v_none2">검색어 입력</label>
<input class="search_box" id="input_key" name="input_key" type="text" value="<?=$input_key?>" />
<input type="image" src="../image/btn/btn_search.gif" align="top" alt="검색" class="input_btn_search" />
<?=$not_answered_button?>
</li>
</ul>
</div>--->
</form>
<div id="Content_box">
<!-- 본문 -->
<? include "_menu.html"; ?>
<!-- 폼 -->
<div class="top_txt_s">
<div class="bar_wrap">
<p class="search_result_txt"><span>Total : <?=$total?></span> </p>
<ul class="search_rt_btn">
<?php if($BOARD_INFO['BD_CD']==$bbs_review) {?>
<li>
<select name="b_uid_s" id="b_uid_s" style="width:180px;height:32px">
<option value="">==1차카테고리==</option>
<?php foreach($data_bc as $v){?>
<option value="<?=$v['b_uid']?>" <?=($b_uid_s==$v['b_uid'])?"selected":""?>><?=$v['b_name']?></option>
<?php }?>
</select>
</li>
<?php }?>
<?if($BOARD_INFO['BD_CG']=="Y"){//코멘트?>
<li><a class="Tbtn" href="#" onclick="to_dialog.ajax('ComListAll.php?BD_CD=<?=$BD_CD?>','전체코멘트관리', 800, 600, false, false);return false;">전체코멘트관리</a></li>
<?}?>
<li><a class="Tbtn red" href="../board/write.html?BD_CD=<?=$BD_CD?>">등록</a></li>
<li><a class="Tbtn gray" href="#" onclick="board_del('check'); return false;">삭제</a></li>
</ul>
</div>
</div>
<form name="board_List" id="board_List" method="POST">
<input type="hidden" name="SqlType" id="SqlType" value="" />
<input type="hidden" name="BD_CD" id="BD_CD" value="<?=$BD_CD?>" />
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="board_list_tbl" class="t_list" summary="게시물을 확인하실 수 있습니다.">
<caption>게시물 확인</caption>
<colgroup>
<col style=" width:40px" />
<col style=" width:40px" />
<col />
<?if($BOARD_INFO['BD_CD']==$bbs_review){?><col style=" width:400px" /><?php }?>
<col style=" width:100px" />
<col style=" width:100px" />
<col style=" width:60px" />
<col style=" width:110px" />
<col style=" width:100px" />
<col style=" width:60px" />
<col style=" width:60px" />
</colgroup>
<thead>
<tr>
<th scope="col"><label for="checkall" class="v_none2">선택 체크</label><input type="checkbox" name="checkall" id="checkall" /></th>
<th scope="col"><?if($BOARD_INFO[BD_OD]=='Y'){?><img src="../image/btn/btn_num.gif" alt="순서" /><?}else{?>No<?}?></th>
<th scope="col">제목/내용</th>
<?if($BOARD_INFO['BD_CD']==$bbs_review){?><th scope="col">리뷰상품명</th><?php }?>
<th scope="col">고객ID</th>
<th scope="col">작성자</th>
<th scope="col">조회수</th>
<th scope="col">작성자IP주소</th>
<th scope="col">등록일</th>
<th scope="col">미리보기</th>
<th scope="col">수정</th>
<th scope="col">삭제</th>
</tr>
</thead>
<tbody>
<?
$num = 0;
$review_comt = $correct_table.'_COMT';
$review_total_sql = "SELECT COUNT(*) AS TOTAL FROM `".$review_comt."` WHERE `MSEQ`='".$row[MSEQ]."'";
$review_total_rs = db_query($review_total_sql);
$review_total_cm = db_fetch_array($review_total_rs);
$total += $review_total_cm['TOTAL'];
$i = 0;
while ($row = db_fetch_array($rs)) {
$review_comt_sql = "SELECT * FROM `".$review_comt."` WHERE `MSEQ`='".$row[MSEQ]."'";
$review_comt_rs = db_query($review_comt_sql);
if ($review_comt_cm = db_fetch_array($review_comt_rs)) {
$not_answered = 'no';
}
else
$not_answered = 'yes';
//$row = $CMM[$i];
// if ($BOARD_INFO[BD_OD] == "Y") $num = $row[OrderNum];
// else
$num = $total - ($page - 1) * $line - $i;
$i++;
$notanswer_explode = explode(" ", $notanswer);
$MFILE_IMG = "";
for($j=1;$j<=$BOARD_INFO['BD_FL'];$j++){
if($row["MFILE".$j]!=""){
$MFILE_IMG="<img src='../../image/board/bullet_disk.gif' align='absmiddle' alt='첨부파일' />";
}
}
$FontTitle = "";
if($row['MLEVEL']>0){
if($row['MLEVEL'] > 5){
$row['MLEVEL']=5;
}
for($j=1;$j<=$row['MLEVEL'];$j++){
$FontTitle .= " ";
}
}
//리플이미지
if($row['MSTEP']>0){
$REPLE_IMG = "<img src='../../image/board/re.gif' />";
}else{
$REPLE_IMG ="";
}
$FontTitle .= $REPLE_IMG;
//비밀글여부
if($row['SECRET']=="Y"){
$SECRET_IMG="<img src='../../image/board/secret.gif' align='top' alt='비밀글' /> ";
}else{
$SECRET_IMG="";
}
//글번호
if($row['FIXED_YN']=="Y"){
$NOTICE_IMG="<img src='../../image/board/notice.gif' align='top' alt='공지사항' />";
}else{
$NOTICE_IMG="";
}
//코멘트
if($BOARD_INFO['BD_CG']=="Y"){
if($row[COMT_CNT]>0){
$CTOTAL = "<a href=\"javascript:to_dialog.ajax('ComList.php?BD_CD=".str_replace( '`', '', $BD_CD)."&MSEQ=".$row[MSEQ]."','코멘트', 800, 600, false, false)\">";
$CTOTAL .= "<img src='../../image/board/btu_comment.gif' align='absmiddle' border='0' alt='코멘트관리' /><span class='comment c_red'>(".$row[COMT_CNT].")</span></a>";
}else{
$CTOTAL ="";
}
}
if(strpos($FontTitle,'script') !== false){
continue;
}
$num1 = $num-1;
?>
<tr>
<td><label for="MSEQ_<?=$i?>" class="v_none2">선택삭제 체크</label><input type="checkbox" name="MSEQ[]" id="MSEQ_<?=$i?>" value="<?=$row[MSEQ]?>" /></td>
<td><?=$num?></td>
<td class="t_title">
<?=$NOTICE_IMG?>
<?=$FontTitle?>
<?=$SECRET_IMG?>
<a href="../board/write.html?<?=$param?>&MSEQ=<?=$row[MSEQ]?>"><?=$row[MTITLE]?></a>
<?=$MFILE_IMG?>
<?=$CTOTAL?>
<? foreach($notanswer_explode as $notanswer_explode_item) {
if ($not_answered == 'yes')
{
echo "<span style='padding-left:2px;'></span><span style='color:#ffffff; background-color:#ff0000; padding:1px'><b>미답변</b></span>";
}
}?>
<?
$redirect = $url_domain.'../../good/info_main.html?b_uid_s='.$title['b_uid'].'&m_uid_s='.$title['m_uid'].'&s_uid_s='.$title['s_uid'].'&g_uid='.$title['g_uid'];
?>
<?if($BOARD_INFO['BD_CD']==$bbs_review){?><td><a href="<?=$redirect?>" target="_blank"><?=$title['g_title']?></a></td><?php }?>
<td><?=$row[MEM_ID]?></td>
<td><?=$row[MEM_NM]?></td>
<td><?=$row[READCNT]?></td>
<td><?=$row[INSIP]?></td>
<td><?=str_replace('-','.',$row[INSDT])?></td>
<td><img src="../image/board/btn_preview.gif" alt="등록확인하기" onclick="window.open('<?=$redirect?>')" style="cursor: pointer;"></td>
<td><a <a href="../board/write.html?<?=$param?>&MSEQ=<?=$row[MSEQ]?>" class="sch_btn" style="width: 40px;">수정</a></td>
<td><input type="image" src="../image/btn/btn_delete.gif" align="top" alt="삭제" /></a></td>
</tr>
<?
if ($review_comt_cm['CCONT'] != '') {
?>
<tr>
<td><label for="COMT_MSEQ_<?=$i?>" class="v_none2">선택삭제 체크</label><input type="checkbox" name="COMT_MSEQ[]" id="COMT_MSEQ_<?=$i?>" value="<?=$review_comt_cm[MSEQ]?>" /></td>
<td><br/></td>
<td style="text-align:left; padding-left:20px;" colspan="2"><img src="../../image/board/re.gif"><span style="font-weight: bold;">[RE]</span><?=$review_comt_cm['CCONT']?></td>
<td><?=$review_comt_cm['CMEM_ID']?></td>
<td><?=$review_comt_cm['CMEM_NM']?></td>
<td></td>
<td><?=$review_comt_cm['INSIP']?></td>
<td><?=str_replace('-','.',$review_comt_cm[INSDT])?></td>
<td></td>
</tr>
<?}?>
<?}?>
</tbody>
</table>
</form>
<?=adm_get_paging($total_page, $page, $list, "?$href&page=", "")?>
</div>
</div>
</div>
</div>
<script type="text/javascript">
function edit_frm()
{
var f=document.frm_seo_edt;
var result = to_validation(f);
if (result==false) return false;
if(!confirm('SEO 정보를 수정하시겠습니까?')) return false;
f.action = "good_proc.php";
f.submit();
}
</script>
<?
include "../include/footer.html";
?>