|
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/setting/ |
Upload File : |
<?
include "../include/top.html";
include "_common.php";
$table = "TB_TRANSLATE_B2B";
// 검색 설정
$sql_where = " ";
if ($search_key_s and $search_word_s) $sql_where .= " and {$search_key_s} like '%".$search_word_s."%' ";// 검색어(상품명,행사명,행사코드,담당자명)
$sql = "select * from {$table} where 1 {$sql_where} order by idx";
$result = db_query($sql);
$PNum = db_num($result);
?>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title">일반설정<span class="arrow">></span><strong>번역(B2B)</strong></div>
<div class="contents_detail">
<div class="setting_wrap">
<!-- 검색 -->
<form name="frm_search" id="frm_search" method="get">
<div class="c_top_bar_search">
<table width="100%" border="0" cellpadding="0" cellspacing="0" summary="번역문구 통합검색입니다." class="c_top_table">
<caption>번역문구 통합검색</caption>
<colgroup>
<col width="150px" />
<col />
</colgroup>
<tbody>
<tr>
<th>검색어</th>
<td><ul class="form_list">
<li class="mr5">
<select name="search_key_s" id="">
<option value="ko" <?=($search_key_s=="ko") ? "selected":""?>>한글</option>
<option value="en" <?=($search_key_s=="en") ? "selected":""?>>영어</option>
<option value="hk" <?=($search_key_s=="hk") ? "selected":""?>>번체</option>
</select>
</li>
<li>
<input type="text" id="" name="search_word_s" value="<?=$search_word_s?>" style="width:330px;" />
</li>
</ul></td>
</tr>
</tbody>
</table>
<div class="sch_btn_wrap"><a href="javascript:;" class="sch_btn" onclick="document.frm_search.submit();">검색</a></div>
</div>
</form>
<!--<div style="float:left;padding:30px 0">
<form name='form1' action='excel_result.php' ENCTYPE='multipart/form-data' method="post">
<input type="hidden" name="SqlType" value="excel_upload" />
파일첨부 <input type='file' name='datafile' size='50'>
<input type='submit' name='fb' class="Tbtn" style="height:30px" value='CSV 파일올리기'>
</form>
</div>-->
<div style="float:right;padding:30px 0">
<a href="javascript:;" class="Tbtn red" onclick="javascript:document.location.href='site_translate_write_b2b.html?SqlType=trans_ins_b2b';">문구등록</a>
<a href="/admin/setting/site_translate_b2b_list.html" class="Tbtn gray">목록보기</a>
</div>
<?if($search_key_s and $search_word_s) {?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="T_list" >
<thead>
<tr>
<th style=" width:18%" scope="col" >한글</th>
<th style=" width:18%" scope="col" >영어</th>
<!-- <th style=" width:18%" scope="col" >간체</th>-->
<th style=" width:18%" scope="col">번체</th>
<th style=" width:18%" scope="col">파일위치</th>
<th style=" width:18%" scope="col" class="c_red">관리</th>
</tr>
</thead>
<tbody>
<?php
$isResult = false;
for($i=0 ; $i < $PNum ; $i++){
$isResult = true;
$rows = db_fetch_array($result);
$ko = nl2br(stripslashes($rows[ko]));
$en = nl2br(stripslashes($rows[en]));
// $cn = nl2br(stripslashes($rows[cn]));
$hk = nl2br(stripslashes($rows[hk]));
$location = nl2br($rows[location]);
?>
<tr>
<td><?=$ko?></td>
<td><?=$en?></td>
<!-- <td>--><?php //=$cn?><!--</td>-->
<td><?=$hk?></td>
<td><?=$location?></td>
<td>
<img src="../image/btn/icon_write.gif" align="top" alt="수정" onClick="javascript:document.location.href='site_translate_write_b2b.html?idx=<?=$rows['idx']?>&SqlType=trans_edit_b2b';" style="cursor:pointer;" />
<img src="../image/btn/icon_del.gif" align="top" alt="삭제" onClick="if(!confirm('정말삭제하시겠습니까?'))return;document.location.href='site_setting_proc.php?SqlType=trans_delete_b2b&idx=<?=$rows['idx']?>';" style="cursor:pointer;" />
</td>
</tr>
<?php
}
if(!$isResult){
?>
<tr>
<td colspan="6">입력한 키워드 <b>"<?=$search_word_s?>"</b> 에 대한 등록된 번역문구가 없습니다.</td>
</tr>
<?php
}
?>
</tbody>
</table>
<? } ?>
<? include "../include/footer.html" ?>