|
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 GoodReserv{
// 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 goodResDateMinMax($rdata=array()) {
if(!$rdata['mode']) $rdata['mode'] = "res";
$data = array();
if($rdata['mode']=="res") {
$sql = "
SELECT DATE_FORMAT(MIN(d1),'%Y') minyy,DATE_FORMAT(MAX(d2),'%Y') maxyy FROM (
( SELECT MIN(DATE_FORMAT(ins_dt,'%Y-%m-%d')) d1,MAX(DATE_FORMAT(ins_dt,'%Y-%m-%d')) d2 FROM TB_RES_GOOD WHERE DATE_FORMAT(ins_dt,'%Y-%m-%d') > DATE_FORMAT('1971-01-01','%Y-%m-%d') )
UNION ALL
( SELECT MIN(DATE_FORMAT(ev_start,'%Y-%m-%d')) d1,MAX(DATE_FORMAT(ev_start,'%Y-%m-%d')) d2 FROM TB_RES_GOOD WHERE DATE_FORMAT(ev_start,'%Y-%m-%d') > DATE_FORMAT('1971-01-01','%Y-%m-%d') )
UNION ALL
( SELECT MIN(DATE_FORMAT(ev_end,'%Y-%m-%d')) d1,MAX(DATE_FORMAT(ev_end,'%Y-%m-%d')) d2 FROM TB_RES_GOOD WHERE DATE_FORMAT(ev_end,'%Y-%m-%d') > DATE_FORMAT('1971-01-01','%Y-%m-%d') )
) a ";
$data= db_fetch($sql);
}
if(!$data['minyy']) $data['minyy']=date("Y");
if(!$data['maxyy']) $data['maxyy']=date("Y");
return $data;
}
}
?>