public function actionRTFlight($countryCode = '', $cityCodeFrom = '', $cityCodeTo = '')
{
if (!($country = $this->testCountry($countryCode))) {
return false;
}
$this->morphy = Yii::app()->morphy;
$countryUp = mb_strtoupper($country->localRu, 'utf-8');
$countryMorph = array('caseAcc' => $this->getCase($countryUp, 'ВН'));
if (!$cityCodeFrom) {
$currentCity = City::getCityByCode('LED');
} else {
$currentCity = City::getCityByCode($cityCodeFrom);
}
$city = City::getCityByCode($cityCodeTo);
$citiesFrom = array();
$this->addCityFrom($citiesFrom, 4466);
// Moscow
$this->addCityFrom($citiesFrom, 5185);
// Spb
$this->addCityFrom($citiesFrom, $currentCity->id);
Yii::import('site.common.modules.hotel.models.*');
$hotelClient = new HotelBookClient();
/*$criteria = new CDbCriteria();
$criteria->addCondition('countAirports > 0');
$criteria->addCondition('countryId = '.$country->id);
$cities = City::model()->findAll($criteria);
$cityIds = array();
foreach($cities as $city){
$cityIds[$city->id] = $city->id;
}
if(isset($cityIds[$currentCity->id])){
unset($cityIds[$currentCity->id]);
}*/
$criteria = new CDbCriteria();
$criteria->addCondition('`to` = ' . $city->id);
$criteria->addCondition('`from` = ' . $currentCity->id);
//$criteria->group = 'dateBack';
//$criteria->addCondition('`from` = '.$currentCity->id);
$criteria->addCondition('`dateFrom` >= ' . date("'Y-m-d'"));
$criteria->addCondition('`dateFrom` <= ' . date("'Y-m-d'", time() + 3600 * 24 * 18));
$criteria->addCondition('`dateBack` >= ' . date("'Y-m-d'"));
$criteria->addCondition('`dateBack` <= ' . date("'Y-m-d'", time() + 3600 * 24 * 18));
//$criteria->addCondition("`dateBack` <> '0000-00-00'");
$criteria->order = 'priceBestPrice';
//$criteria->limit = 18;
$flightCache = FlightCache::model()->findAll($criteria);
/*$sortFc = array();
foreach($flightCache as $fc){
$k = strtotime($fc->dateFrom);
$sortFc[$k] = $fc;//array('price'=>$fc->priceBestPrice,'date'=>$fc->dateFrom,'dateBack'=>$fc->dateBack);
}
ksort($sortFc);*/
//$sortFc = array_slice($sortFc,0,18);
$minPrice = false;
$maxPrice = false;
$activeMin = null;
$activeMax = null;
foreach ($flightCache as $k => $fc) {
$k = strtotime($fc->dateFrom);
if (!$minPrice) {
$minPrice = $fc->priceBestPrice;
$maxPrice = $fc->priceBestPrice;
} else {
if ($fc->priceBestPrice < $minPrice) {
$minPrice = $fc->priceBestPrice;
$activeMin = $k;
}
if ($fc->priceBestPrice > $maxPrice) {
$maxPrice = $fc->priceBestPrice;
$activeMax = $k;
}
}
}
$sortFc = array();
foreach ($flightCache as $fc) {
//$k = strtotime($fc->dateFrom);
$sortFc[] = array('price' => $fc->priceBestPrice, 'date' => $fc->dateFrom, 'dateBack' => $fc->dateBack);
}
//print_r($flightCache);die();
$criteria = new CDbCriteria();
//$criteria->addInCondition('`cityId`',$cityIds);
$criteria->addCondition('cityId = ' . $city->id);
$criteria->limit = 15;
$hotelCache = HotelDb::model()->findAll($criteria);
$hotelsInfo = array();
foreach ($hotelCache as $hc) {
$hotelInfo = $hotelClient->hotelDetail($hc->id);
$hotelInfo->price = $hc->minPrice;
$hotelInfo->hotelName = $hc->name;
$hotelInfo->hotelId = $hc->id;
$hotelsInfo[] = $hotelInfo;
}
$criteria = new CDbCriteria();
//$criteria->addInCondition('`to`',$cityIds);
$criteria->addCondition('`from` = ' . $currentCity->id);
$criteria->addCondition('`dateFrom` > \'' . date('Y-m-d') . "'");
$criteria->order = 'priceBestPrice';
$criteria->limit = 14;
$criteria->group = '`to`';
$flightCacheFromCurrent = FlightCache::model()->findAll($criteria);
$this->layout = 'static';
//$this->render('landing');
$this->render('rtflight', array('city' => $city, 'citiesFrom' => $citiesFrom, 'hotelsInfo' => $hotelsInfo, 'currentCity' => $currentCity, 'flightCache' => $sortFc, 'maxPrice' => $maxPrice, 'minPrice' => $minPrice, 'activeMin' => $activeMin, 'flightCacheFromCurrent' => $flightCacheFromCurrent));
}
