|
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 HotelCont{
// Class 멤버변수
public $cf;
public $TO_CF;
public $TO_MB;
// 생성자
public function __construct() {
global $cf , $TO_CF;
global $TO_MB;
$this->cf = $cf;
$this->TO_CF = $TO_CF;
$this->TO_MB = $TO_MB;
}
// 객실 설비 비품
//
public function hotel_equipment($hseq) {
if(!$hseq) return false;
$sql = "select * from TB_HOTEL where hseq='{$hseq}' and disp_yn='Y'";
$row = db_fetch($sql);
//객실설비비품
$room_equipment_arr = array();
$code_equipment = base_codec("HTL","EQUP","","N");//기초코드
for($j=0 ; $j<count($code_equipment) ; $j++){
if( $code_equipment[$j]['delflag']=="N" ){
$id = $code_equipment[$j]['code'];
$val = $code_equipment[$j]['cd_nm'];
$room_equipment_arr[$id] = $val;
}
}
$data = array();
$i=0;
$equipment_arr = explode(",",$row['equipment']);
foreach($room_equipment_arr as $key => $value){
for($k=0 ; $k < count($equipment_arr) ; $k++){
if( $equipment_arr[$k]==$key ) $checked_str = "checked";
}
$data[$i]= array($key=>$value,"name"=>$value,"check"=>$checked_str);
$checked_str = "";
$i++;
}
return $data;
}
// 호텔 지정 관광지 정보
//
public function hotelTourPlace($hseq="") {
if(!$hseq) return false;
$data=array();
// 관광지정보
$PlaceTour = new PlaceTour();
$sql ="
SELECT THP.seq as seq ,TP.seq as p_seq,TP.place_nm
FROM TB_HOTEL_PLACE THP
JOIN TB_PLACE TP ON THP.p_seq=TP.seq AND TP.disp_yn='Y'
WHERE THP.h_seq='{$hseq}'
ORDER BY TP.order_num
";
$rs = db_query($sql);
while($row=db_fetch_array($rs)){
$data_place = $PlaceTour->tourplace_fetch("and seq='{$row[p_seq]}' ");
$data[] = $data_place[0];
}
return $data;
}
}