public function xmlAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); echo "<pre>"; $filename = "data/sample - Chiang Mai.xml"; $xml_parser = new Base_Xml_Parser(null, $filename); $continentName = $xml_parser->Data['identification']['geoTag1']; $countryName = $xml_parser->Data['identification']['geoTag2']; $cityName = $xml_parser->Data['identification']['geoTag3']; $regionName = $cityName; $stateName = $cityName; //----insert into continent $continent_id = 0; $continentM = new Application_Model_Continent(); $continent = $continentM->fetchRow("name='{$continentName}'"); if (false === $continent) { $continentM->setName($continentName); $continent_id = $continentM->save(); } else { $continent_id = $continent->getId(); } //-------------------------- //----insert into country $country_id = 0; $countryM = new Application_Model_Country(); $country = $countryM->fetchRow("name='{$countryName}' and continent_id='{$continent_id}'"); if (false === $country) { $countryM->setName($countryName); $countryM->setContinentId($continent_id); $country_id = $countryM->save(); } else { $country_id = $country->getId(); } //------------------------------- ///------insert into region $region_id = 0; $regionM = new Application_Model_Region(); $region = $regionM->fetchRow("name='{$regionName}' and country_id='{$country_id}'"); if (false === $region) { $regionM->setName($regionName); $regionM->setCountryId($country_id); $region_id = $regionM->save(); } else { $region_id = $region->getId(); } //------------------------ ///------insert into state $state_id = 0; $stateM = new Application_Model_State(); $state = $stateM->fetchRow("name='{$stateName}' and region_id='{$region_id}'"); if (false === $state) { $stateM->setName($stateName); $stateM->setRegionId($region_id); $state_id = $stateM->save(); } else { $state_id = $state->getId(); } //------------------------ ///------insert into city $city_id = 0; $cityM = new Application_Model_City(); $city = $cityM->fetchRow("name='{$cityName}' and country_id='{$state_id}'"); if (false === $city) { $cityM->setName($cityName); $cityM->setCountryId($country_id); $city_id = $cityM->save(); } else { $city_id = $city->getId(); } //------------------------ if ($continent_id > 0 && $country_id > 0 && $city_id > 0) { //it is city $locationType = "city"; $locationId = $city_id; } else { if ($continent_id > 0 && $country_id > 0) { //it is country $locationType = "country"; $locationId = $country_id; } else { if ($continent_id > 0) { //it is continent $locationType = "continent"; $locationId = $continent_id; } } } ///////////Remove///////// $destinationM = new Application_Model_Destination(); $destinationM->delete(); $experiencesM = new Application_Model_Experiences(); $experiencesM->delete(); $practicalitiesM = new Application_Model_Practicalities(); $practicalitiesM->delete(); //------------------------------ $title = $xml_parser->Data['content']['title']; $introduction = $xml_parser->Data['content']['introduction']; $destinationM = new Application_Model_Destination(); $destinationM->setTitle($title); $destinationM->setIntroduction($introduction); $destinationM->setLocationId($locationId); $destinationM->setLocationType($locationType); $destination_id = $destinationM->save(); foreach ($xml_parser->Data['content']['experiences'] as $experiences) { foreach ($experiences as $_item) { $experiencesM = new Application_Model_Experiences(); $experiencesM->setTitle($_item['title']); $experiencesM->setDestinationId($destination_id); $experiencesM->setCopy($_item['copy']); $experiencesM->save(); } } foreach ($xml_parser->Data['content']['practicalities'] as $practicalities) { foreach ($practicalities as $_item) { $practicalitiesM = new Application_Model_Practicalities(); $practicalitiesM->setTitle($_item['title']); $practicalitiesM->setDestinationId($destination_id); $practicalitiesM->setCopy($_item['copy']); $practicalitiesM->save(); } } //print_r($xml_parser->Data); }
/** * @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 }