/** * @Created By : Mahipal Singh Adhikari * @Created On : 7-Mar-2011 * @Description : Manage destination City/Places: Edit city content */ public function editCityAction() { //get request variables and set to view $id = $this->_getParam("id"); $page = $this->_getParam("page"); $selTab = $this->_getParam("tab", "tabs-1"); $this->view->id = $id; $this->view->page = $page; $this->view->selTab = $selTab; //set error message $this->view->errorMsg = ""; if (isset($_SESSION['errorMsg'])) { $this->view->errorMsg = $_SESSION['errorMsg']; unset($_SESSION['errorMsg']); } //select Destinations details $destinationId = ""; $destinationM = new Application_Model_Destination(); $destinationM = $destinationM->fetchRow("location_id={$id} AND location_type='city'"); if (false !== $destinationM) { $this->view->destination = $destinationM; $destinationId = $destinationM->getId(); //select Experiences details $expriencesM = new Application_Model_Experiences(); $expriencesM = $expriencesM->fetchAll("destination_id={$destinationId}", "id ASC"); if (false !== $expriencesM) { $this->view->expriences = $expriencesM; } //select EAT, SLEEP, DRINK AND BE MERRY section details $eatsleepdrinkM = new Application_Model_EatSleepDrink(); $eatsleepdrinkM = $eatsleepdrinkM->fetchAll("destination_id={$destinationId}"); if (false !== $eatsleepdrinkM) { $this->view->eatsleepdrink = $eatsleepdrinkM; } //select Practicalities details $practicalitiesM = new Application_Model_Practicalities(); $practicalitiesM = $practicalitiesM->fetchAll("destination_id={$destinationId}", "id ASC"); if (false !== $practicalitiesM) { $this->view->practicalities = $practicalitiesM; } //select City/Places images $cityimagesM = new Application_Model_CityImages(); $cityimagesM = $cityimagesM->fetchAll("city_id={$id}", "weight ASC"); if (false !== $cityimagesM) { $this->view->cityimages = $cityimagesM; } //create image upload form $uploadForm = new Admin_Form_CityImages(); $elements = $uploadForm->getElements(); $uploadForm->clearDecorators(); foreach ($elements as $element) { $element->removeDecorator('label'); $element->removeDecorator('td'); $element->removeDecorator('tr'); $element->removeDecorator('row'); $element->removeDecorator('HtmlTag'); $element->removeDecorator('placement'); $element->removeDecorator('data'); } $this->view->uploadForm = $uploadForm; } else { //if not data found, then insert blank empty rows and redirect to this //echo "No data provided from XML Feeds.";exit; $destinationM = new Application_Model_Destination(); $destination_id = $destinationM->setDefaultRowData($id, "city"); $destinationM->setDefaultCityData($destination_id); $this->_helper->redirector("edit-city", "featured-city", "admin", array("id" => $id, "page" => $page, "tab" => "tabs-1")); } //submit form $request = $this->getRequest(); if ($request->isPost()) { $options = $request->getPost(); if ($options["update_action"] == "destination") { $response = ""; $destinationM = new Application_Model_Destination(); $destinationRes = $destinationM->find($options["destination_id"]); if (false !== $destinationRes) { $destinationRes->setTitle($options["title"]); $destinationRes->setIntroduction($options["introduction"]); $destinationRes->save(); //update block XML Feeds table $destM = new Application_Model_Destination(); $destM->updateXMLFeedsBlockStatus("city", $id, $options["block_ovewrite"]); //$arrayResult = Array("error"=>0, "response"=>"Introduction information has been updated successfully."); $response = "Introduction information has been updated successfully."; } else { //$arrayResult = Array("error"=>1, "response"=>"Error occured, no data found."); $response = "Error occured, no data found."; } $_SESSION['errorMsg'] = $response; $this->_helper->redirector("edit-city", "featured-city", "admin", array("id" => $id, "tab" => "tabs-1")); } else { if ($options["update_action"] == "eat") { for ($eat = 0; $eat < count($options["eatId"]); $eat++) { $eatsleepdrinkM = new Application_Model_EatSleepDrink(); $eatsleepdrinkRes = $eatsleepdrinkM->find($options["eatId"][$eat]); if (false !== $eatsleepdrinkRes) { $eatsleepdrinkRes->setTitle($options["eatTitle"][$eat]); $eatsleepdrinkRes->setBackPackerCopy($options["backPackerCopy"][$eat]); $eatsleepdrinkRes->setLocalCopy($options["localCopy"][$eat]); $eatsleepdrinkRes->save(); } else { $arrayResult = array("error" => 1, "response" => "Error occured, no data found."); } } $arrayResult = array("error" => 0, "response" => "Eat, Sleep, Drink and be Merry information has been updated successfully."); } else { if ($options["update_action"] == "exp") { //remove all existing records $expriencesM = new Application_Model_Experiences(); $delRes = $expriencesM->delete("destination_id = {$options['destinationId']}"); for ($exp = 0; $exp < count($options["expTitle"]); $exp++) { $dataParams["destinationId"] = $options["destinationId"]; $dataParams["title"] = $options["expTitle"][$exp]; $dataParams["copy"] = $options["expCopy"][$exp]; $expriencesM = new Application_Model_Experiences($dataParams); $expriencesM->save(); /* $expriencesM = new Application_Model_Experiences(); $expriencesRes = $expriencesM->find($options["expId"][$exp]); if(false!==$expriencesRes) { $expriencesRes->setTitle($options["expTitle"][$exp]); $expriencesRes->setCopy($options["expCopy"][$exp]); $expriencesRes->save(); } else { $arrayResult = Array("error"=>1, "response"=>"Error occured, no data found."); }*/ } $arrayResult = array("error" => 0, "response" => "Experiences information has been updated successfully."); } else { if ($options["update_action"] == "prac") { //remove all existing record $practicalitiesM = new Application_Model_Practicalities(); $delres = $practicalitiesM->delete("destination_id = {$options['destinationId']}"); for ($prac = 0; $prac < count($options["pracTitle"]); $prac++) { $dataParams["destinationId"] = $options["destinationId"]; $dataParams["title"] = $options["pracTitle"][$prac]; $dataParams["copy"] = $options["pracCopy"][$prac]; $practicalitiesM = new Application_Model_Practicalities($dataParams); $practicalitiesM->save(); /*$practicalitiesM = new Application_Model_Practicalities(); $practicalitiesRes = $practicalitiesM->find($options["pracId"][$prac]); if(false!==$practicalitiesRes) { $practicalitiesRes->setTitle($options["pracTitle"][$prac]); $practicalitiesRes->setCopy($options["pracCopy"][$prac]); $practicalitiesRes->save(); } else { $arrayResult = Array("error"=>1, "response"=>"Error occured, no data found."); }*/ } $arrayResult = array("error" => 0, "response" => "Practicalities information has been updated successfully."); } else { if ($options["update_action"] == "img") { //print_r($options);exit; if ($uploadForm->isValid($options)) { $city_id = $options["cityId"]; $target_file_name = ""; //Upload image strat here $upload = new Zend_File_Transfer_Adapter_Http(); if ($upload->isValid()) { $upload->setDestination("media/picture/city/"); try { $upload->receive(); } catch (Zend_File_Transfer_Exception $e) { $msg = $e->getMessage(); } $upload->setOptions(array('useByteString' => false)); $file_name = $upload->getFileName('cityImage'); $cardImageTypeArr = explode(".", $file_name); $ext = strtolower($cardImageTypeArr[count($cardImageTypeArr) - 1]); $target_file_name = "city{$city_id}_" . time() . ".{$ext}"; $targetPath = "media/picture/city/" . $target_file_name; //$targetPathThumb = "media/picture/home/thumb_".$target_file_name; $filterFileRename = new Zend_Filter_File_Rename(array('target' => $targetPath, 'overwrite' => true)); $filterFileRename->filter($file_name); //$thumb = Base_Image_PhpThumbFactory ::create($targetPath); //$thumb->resize(623, 347); //$thumb->save($targetPathThumb); } //upload image Ends here //set image $options['cityImage'] = $target_file_name; $options['status'] = 1; $model = new Application_Model_CityImages($options); $id = $model->save(); if ($id) { $_SESSION['errorMsg'] = "Images has been saved successfully."; } else { $_SESSION['errorMsg'] = "Error occured, please try again later."; } $this->_helper->redirector("edit-city", "featured-city", "admin", array("id" => $city_id, "tab" => "tabs-5")); } //end if $this->view->selTab = "tabs-5"; } } } } } //disable layout and display JSON response if action is not uploading image if ($options["update_action"] != "img") { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); echo Zend_Json::encode($arrayResult); exit; } } //end if }