/**
* @Created By : Mahipal Singh Adhikari
* @Created On : 7-Dec-2010
* @Description: Travel guides home page content
*/
public function indexAction()
{
//get destination home page CMS text
$id = $this->_getParam('id', 1);
$modelRes = new Application_Model_TravelGuidesHome();
$modelRes = $modelRes->find($id);
if (false !== $modelRes) {
$this->view->title = $modelRes->getTitle();
$this->view->subTitle = $modelRes->getSubTitle();
$this->view->desription = $modelRes->getDescription();
}
//now retrieve travel guide slides
$homeSlidesArr = array();
$TravelGuidesSlidesM = new Application_Model_TravelGuidesSlides();
$whereCond = "status=1";
$orderBy = "weight DESC";
$slideLimit = 10;
$TravelGuidesSlidesRes = $TravelGuidesSlidesM->fetchAll($whereCond, $orderBy);
if (false !== $TravelGuidesSlidesRes) {
foreach ($TravelGuidesSlidesRes as $slides) {
$homeSlidesArr[] = array("title" => $slides->getSlideTitle(), "type" => $slides->getSlideType(), "image" => $slides->getSlideImage(), "text" => $slides->getSlideText(), "label" => $slides->getSlideLinkLabel(), "url" => $slides->getSlideLinkUrl(), "target" => $slides->getSlideLinkTarget());
}
$this->view->cityImagesArr = $homeSlidesArr;
}
//get top featured city to display in top
$cityM = new Application_Model_City();
$destinationM = new Application_Model_Destination();
//get other featured cities
$featuredOther = array();
$featuredOtherArr = array();
$cityArr = array();
$cityArr = $cityM->fetchAll("featured_top!=1 AND featured_other=1", "name ASC");
if (count($cityArr) > 0) {
foreach ($cityArr as $row) {
$featuredOther['city_id'] = $row->id;
$featuredOther['name'] = $row->name;
//get City/place image
$featuredOther['city_image'] = "no-image.jpg";
$cityImagesArr = $destinationM->destinationImages($row->id);
if (false !== $cityImagesArr) {
if (count($cityImagesArr) > 0) {
$featuredOther['city_image'] = $cityImagesArr[0]['city_image'];
}
}
//now get country in which this city exists
$countryM = new Application_Model_Country();
$country_id = $row->countryId;
$countryM = $countryM->find($country_id);
$featuredOther['country'] = "";
if (false !== $countryM) {
$featuredOther['country'] = $countryM->getName();
}
$destinationM = new Application_Model_Destination();
$destination = $destinationM->fetchRow("location_id='{$row->id}' AND location_type='city'");
$featuredOther['overview'] = "";
$featuredOther['nutshell'] = "";
if (false !== $destination) {
$featuredOther['overview'] = $destination->getTitle();
$featuredOther['nutshell'] = $destination->getIntroduction();
//$destination_id = $destination->getId();
}
$featuredOtherArr[] = $featuredOther;
}
//end of foreach
}
$this->view->featuredOtherArr = $featuredOtherArr;
//get featured countries
$featuredCountry = array();
$featuredCountryArr = array();
$countryM = new Application_Model_Country();
$countryArr = array();
$countryArr = $countryM->fetchAll("featured=1", "name ASC");
if (count($countryArr) > 0) {
foreach ($countryArr as $row) {
$featuredCountry['country_id'] = $row->id;
$featuredCountry['name'] = $row->name;
//get country image
$featuredCountry['country_image'] = "no-image.jpg";
$countryImagesArr = $destinationM->destinationImages($row->id, "country");
if (false !== $countryImagesArr) {
if (count($countryImagesArr) > 0) {
$featuredCountry['country_image'] = $countryImagesArr[0]['country_image'];
}
}
//get country information
$lonelyM = new Application_Model_LonelyPlanetCountry();
$lonelyM = $lonelyM->fetchRow("country_id='{$row->id}'");
$featuredCountry['overview'] = "";
$featuredCountry['nutshell'] = "";
if (false !== $lonelyM) {
$featuredCountry['overview'] = $lonelyM->getIntroMini();
$featuredCountry['nutshell'] = $lonelyM->getIntroShort();
}
$featuredCountryArr[] = $featuredCountry;
}
//end of foreach
}
$this->view->featuredCountryArr = $featuredCountryArr;
}
/**
* @Created By : Mahipal Singh Adhikari
* @Created On : 7-Feb-2011
* @Description : Travel Guides Home page: delete image slide
*/
public function deleteSlideAction()
{
$id = $this->_getParam('id');
$model = new Application_Model_TravelGuidesSlides();
$widgetRes = $model->find($id);
if ($widgetRes) {
$model->delete("id={$id}");
//unlink image if files exists
if (file_exists("media/picture/home/" . $widgetRes->getSlideImage())) {
unlink("media/picture/home/" . $widgetRes->getSlideImage());
unlink("media/picture/home/thumb_" . $widgetRes->getSlideImage());
}
$_SESSION['errorMsg'] = "Slide has been deleted!";
} else {
$_SESSION['errorMsg'] = "Invalid request, no slide found.";
}
return $this->_helper->redirector('travelguides-slides', 'featured-city', "admin");
}
private function setModel($row)
{
$model = new Application_Model_TravelGuidesSlides();
$model->setId($row->id)->setSlideTitle($row->slide_title)->setSlideType($row->slide_type)->setSlideImage($row->slide_image)->setSlideText($row->slide_text)->setSlideLinkLabel($row->slide_link_label)->setSlideLinkUrl($row->slide_link_url)->setSlideLinkTarget($row->slide_link_target)->setWeight($row->weight)->setStatus($row->status)->setUserId($row->user_id)->setAddedon($row->addedon)->setUpdatedon($row->updatedon);
return $model;
}
