/** * @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; }