public function addAction() { $this->view->title = ucfirst("State - Add"); $this->view->headTitle($this->view->title); $form = new Admin_Form_State(); $this->view->form = $form; $this->view->successMsg = ""; if ($this->getRequest()->isPost()) { $formData = $this->getRequest()->getPost(); if ($form->isValid($formData)) { $usersNs = new Zend_Session_Namespace("members"); $formData['userId'] = $usersNs->userId; $formData['type'] = $this->_getParam('type'); $this->view->warningMsg = ''; $model = new Application_Model_State($formData); $id = $model->save($model); $form->reset(); $this->view->successMsg = "State added successfully. State Id : {$id}"; } else { $form->populate($formData); } } }
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); }