|
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/LibClass/ |
Upload File : |
<?php
/******************************************************************************
*
* 관광지,추천,이벤트,갤러리 클래스
*
******************************************************************************/
class PlaceTour{
// Class 멤버변수
public $cf;
public $TO_CF;
public $TO_MB;
// 생성자
public function __construct() {
global $cf , $TO_CF;
global $TO_MB;
global $lang;
$this->cf = $cf;
$this->TO_CF = $TO_CF;
$this->TO_MB = $TO_MB;
$this->lang = $lang;
}
//
// 관광지정보
//
public function tourplace_fetch($sql_where="",$sql_order="",$olds=0,$line=0) {
$upload="/FileData/tourplace/";
$upload_thum="/FileData/tourplace_thum/";
$table="TB_PLACE";
if($this->lang=="cn") $table = "TB_PLACE_CN";//중국어
elseif($this->lang=="eng") $table = "TB_PLACE_ENG";//영어
if($this->lang=="cn" or $this->lang=="eng"){ // 중국어.영어
$sql = "select *,
(select place_nm from TB_PLACE where {$table}.seq=TB_PLACE.seq limit 1) as place_nm_kor
from {$table}
where 0 = 0 {$sql_where} limit 1";
}else{
$sql = "
select *,
IF(disp_yn='Y','N','Y') as disp_yn_opp,IF(disp_yn='Y','btn_check.gif','btn_stop.gif') as disp_yn2,
(select cd_nm from TB_CODEC where TB_CODEC.cd_b='TGUB' and {$table}.place_cd=TB_CODEC.code limit 1 ) as place_cd_nm,
date_format(ins_dt,'%Y.%m.%d') as ins_dt2,date_format(edit_dt,'%Y.%m.%d') as edit_dt2,
IF(map_x<>'',1,0) as map_cnt,
(select count(*) from {$table}_GALLERY where place_seq= {$table}.seq ) as gallery_cnt
from {$table}
where 0 = 0
";
if($sql_where) $sql .= " ".$sql_where;
if($sql_order) $sql .= " order by ".$sql_order;
else $sql .= " order by order_num , seq desc ";
if($olds>=0 and $line>0) $sql .= " limit $olds , $line";
}
$data = array();
$rs = db_query($sql);
$i=0;
while($rows = db_fetch_array($rs)){
$data[$i] = $rows;
//이미지
$data[$i]['img1_path'] = $upload.$rows['img1'];
$data[$i]['img1_thum'] = $upload_thum.$rows['img1'];
//지역
if($data[$i]['city_cd_nm']) $data[$i]['city_area'] = $data[$i]['city_cd_nm'];
if($data[$i]['area_cd_nm']) $data[$i]['city_area'] .= ">".$data[$i]['area_cd_nm'];
// 전체 지역명
$area_nm = "";
// 대륙명
if ($rows['areaa_cd']){
$arr_tmp = to_area_a($rows['areaa_cd'],"N");
$arr = $arr_tmp['0'];
$data[$i]['areaa_cd_nm'] = $arr['ContinentName'];
//$area_nm = $arr['ContinentName'];
}
// 국가명
if ($rows['areab_cd']){
$arr_tmp = to_area_b($rows['areaa_cd'],$rows['areab_cd']," and DelFlag='N' ");
$arr = $arr_tmp['0'];
$data[$i]['areab_cd_nm'] = $arr['NationName'];
$area_nm .= $arr['NationName'];
}
// 도시명
if ($rows['areac_cd']) {
$arr_tmp = to_area_c("",$rows['areab_cd'],$rows['areac_cd'],"N");
$arr = $arr_tmp['0'];
$data[$i]['areac_cd_nm'] = $arr['CityName'];
$area_nm .= ">".$arr['CityName'];
}
$data[$i]['area_nm'] = $area_nm;
$i++;
}
return $data;
}
//
// 관광지 갤러리
//
public function hotel_tourplace_gallery($place_seq="",$limit="") {
$table = "TB_PLACE_GALLERY";
$upload="/FileData/tourplace/";
$upload_thum="/FileData/tourplace_thum/";
if (!$place_seq) return false;
$sql = "select * from {$table} where place_seq='{$place_seq}' order by order_num , g_seq desc {$limit} ";
$rs = db_query($sql);
$data = array();
$i=0;
while ($rows = db_fetch_array($rs)) {
$data[$i] = $rows;
//이미지
$data[$i]['img_path'] = $upload.$rows['img'];
$data[$i]['img_thum'] = $upload_thum.$rows['img'];
//분류
$gallery_cd_arr = base_codec("HTL","TGUB",$row['gallery_cd']);
$data[$i]['gallery_type'] = $gallery_cd_arr[0]['cd_nm'];
$i++;
}
return $data;
}
//
// 호텔주변 주변 관광지정보
//
public function hotel_tourplace($hseq,$palce_seq="")
{
global $lang;
if (!$hseq) return false;
$upload="/FileData/tourplace/";
$upload_thum="/FileData/tourplace_thum/";
if ($palce_seq) $sql_where = " and b.seq='{$palce_seq}' ";
$sql = "select b.* from TB_HOTEL_PLACE a , TB_PLACE b where h_seq='{$hseq}' and a.p_seq=b.seq {$sql_where} order by seq desc ";
$data = array();
$rs = db_query($sql);
$i=0;
while ($rows = db_fetch_array($rs)) {
$data[$i] = $rows;
//이미지
$data[$i]['img1_path'] = $upload.$rows['img1'];
$data[$i]['img1_thum'] = $upload_thum.$rows['img1'];
// 다국어 정보로 대체
if ($lang=="eng" or $lang=="cn") {
$table_lang = "";
$data_lang = array();
if ($lang=="eng") $table_lang = "TB_PLACE_ENG"; // 영어
else if($lang=="cn") $table_lang = "TB_PLACE_CN"; // 중국어
$sql = "select * from {$table_lang} where seq='{$rows[seq]}' ";
$res = db_query($sql);
$data_lang = db_fetch_all($res);
if (count($data_lang) > 0) {
foreach($data_lang[0] as $key => $val){
$data[$i][$key] = $val;
}
}
}
$i++;
}
return $data;
}
//
// 관광지 목록
//
public function tourplace_list($sql_where="",$sql_order="",$olds=0,$line=0)
{
global $lang;
$upload="/FileData/tourplace/";
$upload_thum="/FileData/tourplace_thum/";
$table="TB_PLACE";
$sql = "select *,date_format(ins_dt,'%Y.%m.%d') as ins_dt2
from TB_PLACE
where 0 = 0 and disp_yn='Y' ";
if ($sql_where) $sql .= " ".$sql_where ;
if ($sql_order) $sql .= " order by ".$sql_order;
else $sql .= " order by order_num , seq desc ";
if ($olds>=0 and $line>0) $sql .= " limit $olds , $line";
$data = array();
$rs = db_query($sql);
$i=0;
while ($rows = db_fetch_array($rs)) {
$data[$i] = $rows;
// 이미지
$data[$i]['img1_path'] = $upload.$rows['img1'];
$data[$i]['img1_thum'] = $upload_thum.$rows['img1'];
// 지역
$arr_tmp = @base_codeb("ASA",$rows['city_cd']); // 도시
$data[$i]['city_cd_nm'] = $arr_tmp[0]['CdName'];
$arr_tmp = @base_codec("ASA",$rows['city_cd'],$rows['area_cd'],"N"); // 구,군
$data[$i]['area_cd_nm'] = $arr_tmp[0]['cd_nm'];
$arr_tmp = to_area_c("", $rows['areab_cd'], $rows['areac_cd'], "N");
$data[$i]['area_cd_nm2'] = $arr_tmp[0]['CityName'];
$city_area_str = "";
if ($data[$i]['city_cd_nm']) $city_area_str = $data[$i]['city_cd_nm'];
if ($data[$i]['area_cd_nm']) $city_area_str .= ">".$data[$i]['area_cd_nm'];
$data[$i]['city_area'] = $city_area_str;
// 관광지구분
$arr_tmp = @base_codec("HTL","TGUB",$rows['place_cd'],"N");
$data[$i]['area_cd_nm'] = $arr_tmp[0]['cd_nm'];
// 다국어 정보로 대체
if ($lang=="eng" or $lang=="cn") {
$table_lang = "";
$data_lang = array();
if ($lang=="eng") $table_lang = "TB_PLACE_ENG"; // 영어
else if($lang=="cn") $table_lang = "TB_PLACE_CN"; // 중국어
$sql = "select * from {$table_lang} where seq='{$rows[seq]}' ";
$res = db_query($sql);
$data_lang = db_fetch_all($res);
if (count($data_lang) > 0) {
foreach($data_lang[0] as $key => $val){
$data[$i][$key] = $val;
}
}
}
$i++;
}
return $data;
}
//
// 관광지 정보
//
public function tourplace_view($seq)
{
if (!$seq) return array();
$upload="/FileData/tourplace/";
$upload_thum="/FileData/tourplace_thum/";
$table="TB_PLACE";
$data = array();
$data_place = tourplace_list(" and seq = '{$seq}' ");
$row = $data_place[0];
// 지역 영문이름
$sql = "select place_nm from TB_PLACE_ENG where seq='{$row[seq]}' limit 1";
$data_eng = db_fetch($sql);
$row['place_nm_eng'] = $data_eng['place_nm'];
$data = $row;
return $data;
}
//
// 관광지 갤러리
//
public function place_gallery($seq="",$limit="")
{
$table = "TB_PLACE_GALLERY";
$upload="/FileData/tourplace/";
$upload_thum="/FileData/tourplace_thum/";
if(!$seq)return false;
$sql = "select * from {$table} where place_seq='{$seq}' order by order_num {$limit} ";
$rs = db_query($sql);
$data = array();
$i=0;
while ($rows = db_fetch_array($rs)) {
$data[$i] = $rows;
//이미지
$data[$i]['img_path'] = $upload.$rows['img'];
$data[$i]['img_thum'] = $upload_thum.$rows['img'];
//분류
$gallery_cd_arr = base_codec("HTL","SISL",$row['gallery_cd']);
$data[$i]['gallery_type'] = $gallery_cd_arr[0]['cd_nm'];
$i++;
}
// return
return $data;
}
}