|
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/development/ |
Upload File : |
<?php
include "../include/top.html";
include "_common.php";
$tbName = "good";
$bUidList = array();
$sql = "SELECT b_uid, b_lang FROM bc WHERE DelFlag = 'N' AND b_lang IN ('ko','en','cn','hk')";
$res = db_query($sql);
while($dataRow = db_fetch_array($res)){
$bUidList[$dataRow['b_uid']] = $dataRow['b_lang'];
}
$sql = "SELECT g_title, b_uid, g_uid, seo_first_category_url, seo_second_category_url, seo_good_url, g_viewtype FROM {$tbName} WHERE g_ok ='Y' AND seo_first_category_url != '' AND seo_second_category_url != '' AND seo_good_url != '' ORDER BY g_uid DESC";
$row = db_query($sql);
$data = array();
while($item = db_fetch_array($row)){
array_push($data,$item);
}
$siteUrl = array(
'ko' => 'https://www.tourboss.co.kr/',
'hk' => 'https://www.tktravelkorea.com/',
'en' => 'https://en.tktravelkorea.com/',
'cn' => 'https://cn.tktravelkorea.com/',
);
$koList = array();
$hkList = array();
$enList = array();
$cnList = array();
//언어별로 구분
foreach($data as $item){
if($bUidList[$item['b_uid']] == 'ko'){
array_push($koList,$item);
}else if($bUidList[$item['b_uid']] == 'hk'){
array_push($hkList,$item);
}else if($bUidList[$item['b_uid']] == 'cn'){
array_push($cnList,$item);
}else if($bUidList[$item['b_uid']] == 'en'){
array_push($enList,$item);
}
}
?>
<style>
.sub_top_btn{display:none}
.contents_detail table{float:left;width:90%;background:#fff;margin-left:20px;margin-top:5px;color:#000}
.contents_detail table th,.contents_detail table td{background:#fff;text-align:center;padding:10px 0;color:#000;border:1px solid #ccc}
.contents_detail table th{background:#eee}
.contents_detail table td b{color:red}
.checkBtn{cursor:pointer}
</style>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title">Development
<span class="arrow">></span>
<strong>Contents Info URL List</strong>
<br>
<br>
<h3>컨텐츠 URL 완료 상품 수 : <?=number_format(count($data))?></h3>
</div>
<br>
<br>
<div class="contents_detail">
<table cellpadding="1" cellspacing="1">
<thead>
<tr>
<th style="width:50px">No</th>
<th style="">상품명</th>
<th style="width:50px">언어</th>
<th style="">URL</th>
</tr>
</thead>
<tbody>
<?php
foreach($koList as $value){
?>
<tr>
<td><?=$value['g_uid']?></td>
<td style="padding-left:10px;text-align:left"><?=$value['g_title']?></td>
<td><?=$bUidList[$value['b_uid']]?></td>
<td style="padding-left:10px;text-align:left">
<a href="<?=$siteUrl[$bUidList[$value['b_uid']]].$value['seo_first_category_url'].'/'.$value['seo_second_category_url'].'/'.$value['seo_good_url'].'/'?>" target="_blank"><?=$siteUrl[$bUidList[$value['b_uid']]].$value['seo_first_category_url'].'/'.$value['seo_second_category_url'].'/'.$value['seo_good_url'].'/'?></a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<table cellpadding="1" cellspacing="1">
<thead>
<tr>
<th style="width:50px">No</th>
<th style="width:400px">상품명</th>
<th style="width:50px">언어</th>
<th style="">URL</th>
</tr>
</thead>
<tbody>
<?php
foreach($hkList as $value){
?>
<tr>
<td><?=$value['g_uid']?></td>
<td style="padding-left:10px;text-align:left"><?=$value['g_title']?></td>
<td><?=$bUidList[$value['b_uid']]?></td>
<td style="padding-left:10px;text-align:left">
<a href="<?=$siteUrl[$bUidList[$value['b_uid']]].$value['seo_first_category_url'].'/'.$value['seo_second_category_url'].'/'.$value['seo_good_url'].'/'?>" target="_blank"><?=$siteUrl[$bUidList[$value['b_uid']]].$value['seo_first_category_url'].'/'.$value['seo_second_category_url'].'/'.$value['seo_good_url'].'/'?></a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<table cellpadding="1" cellspacing="1">
<thead>
<tr>
<th style="width:50px">No</th>
<th style="width:400px">상품명</th>
<th style="width:50px">언어</th>
<th style="">URL</th>
</tr>
</thead>
<tbody>
<?php
foreach($enList as $value){
?>
<tr>
<td><?=$value['g_uid']?></td>
<td style="padding-left:10px;text-align:left"><?=$value['g_title']?></td>
<td><?=$bUidList[$value['b_uid']]?></td>
<td style="padding-left:10px;text-align:left">
<a href="<?=$siteUrl[$bUidList[$value['b_uid']]].$value['seo_first_category_url'].'/'.$value['seo_second_category_url'].'/'.$value['seo_good_url'].'/'?>" target="_blank"><?=$siteUrl[$bUidList[$value['b_uid']]].$value['seo_first_category_url'].'/'.$value['seo_second_category_url'].'/'.$value['seo_good_url'].'/'?></a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<table cellpadding="1" cellspacing="1">
<thead>
<tr>
<th style="width:50px">No</th>
<th style="width:400px">상품명</th>
<th style="width:50px">언어</th>
<th style="">URL</th>
</tr>
</thead>
<tbody>
<?php
foreach($cnList as $value){
?>
<tr>
<td><?=$value['g_uid']?></td>
<td style="padding-left:10px;text-align:left"><?=$value['g_title']?></td>
<td><?=$bUidList[$value['b_uid']]?></td>
<td style="padding-left:10px;text-align:left">
<a href="<?=$siteUrl[$bUidList[$value['b_uid']]].$value['seo_first_category_url'].'/'.$value['seo_second_category_url'].'/'.$value['seo_good_url'].'/'?>" target="_blank"><?=$siteUrl[$bUidList[$value['b_uid']]].$value['seo_first_category_url'].'/'.$value['seo_second_category_url'].'/'.$value['seo_good_url'].'/'?></a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
<script>
$(window).load(function(){
$(document).on('click', '.checkBtn', function(){
ssid = $(this).attr('ssid');
thisValue = $(this).text();
console.log(ssid);
console.log(thisValue);
if(ssid){
checkYn(ssid, thisValue);
}
});
})
function checkYn(ssid, thisValue){
$.ajax({
type: "post",
url: "/toadmin/ajaxData/",
dataType: 'json',
data: {'mode': 'setCheckSmartStore',ssid, thisValue},
async: false,
success: function (data) {
console.log('data is ' + JSON.stringify(data));
if (data.result == true) {
iziToast.show({
timeout:1000,
color: 'green',
title: '완료',
message: "값이 변경되었습니다.",
});
$('#checkBtn-'+ssid).text(data.val);
} else {
iziToast.show({
timeout:1000,
color: 'red',
title: '실패',
message: "-----",
});
}
},
error: function (a, b, c) {
iziToast.show({
timeout:2000,
color: 'red',
title: '실패',
message: "값이 없습니다.",
});
}
});
}
</script>
<? include "../include/footer.html" ?>