public function poiAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(true); echo "<pre>"; $filename = "data/lonelyplanet-london-gapdaemon.xml"; $xml_parser = new Base_Xml_Parser(null, $filename); $destinationName = $xml_parser->Data['destination_name']; //----insert into continent $continent_id = 0; $continentM = new Application_Model_Continent(); $continent = $continentM->fetchRow("name='{$destinationName}'"); if (false !== $continent) { $continent_id = $continent->getId(); } //-------------------------- //----insert into country $country_id = 0; $countryM = new Application_Model_Country(); $country = $countryM->fetchRow("name='{$destinationName}'"); if (false !== $country) { $country_id = $country->getId(); } //------------------------------- ///------insert into city $city_id = 0; $cityM = new Application_Model_City(); $city = $cityM->fetchRow("name='{$destinationName}'"); if (false !== $city) { $city_id = $city->getId(); } //------------------------ if ($city_id > 0) { //it is city $locationType = "city"; $locationId = $city_id; } else { if ($country_id > 0) { //it is country $locationType = "country"; $locationId = $country_id; } else { if ($continent_id > 0) { //it is continent $locationType = "continent"; $locationId = $continent_id; } else { //create a place/city and get the reference id/location id ///------insert into city $city_id = 0; $cityM = new Application_Model_City(); $cityM->setName($destinationName); $cityM->setCountryId(0); $city_id = $cityM->save(); //------------------------ $locationType = "other"; $locationId = $city_id; } } } error_reporting(E_ALL & ~E_NOTICE); foreach ($xml_parser->Data['pois']['poi'] as $poi) { $poiM = new Application_Model_Poi(); $poiM->setLocationId($locationId)->setLocationType($locationType)->setName($poi['poi_name'])->setAddress(serialize($poi['address_parts']['address_part']))->setPostcode($poi['address_postcode'])->setTelfaxs(serialize($poi['telfaxs']['telfax']))->setEmail($poi['poi_email'])->setWeb($poi['poi_web'])->setTransportModes(serialize($poi['transport_modes']['transport_mode']))->setPriceRange($poi['price_range'])->setReviewFull($poi['review_full']['p'])->setReviewSummary($poi['review_summary']['p'])->setBookable($poi['bookable']['value'])->setXCoordinate($poi['feature_x_coord'])->setYCoordinate($poi['feature_y_coord'])->setFeatureId($poi['feature_id'])->setKeywords(serialize($poi['keywords']['keyword'])); $poiM->save(); } }
private function setModel($row) { //$parent=$row->findParentRow('Application_Model_DbTable_Destination','Continent'); $model = new Application_Model_Poi(); $model->setId($row->id)->setLocationId($row->location_id)->setLocationType($row->location_type)->setName($row->name)->setAddress($row->address)->setPostcode($row->postcode)->setTelfaxs($row->telfaxs)->setEmail($row->email)->setWeb($row->web)->setTransportModes($row->transport_modes)->setPriceRange($row->price_range)->setReviewFull($row->review_full)->setReviewSummary($row->review_summary)->setBookable($row->bookable)->setXCoordinate($row->x_coordinate)->setYCoordinate($row->y_coordinate)->setFeatureId($row->feature_id)->setKeywords($row->keywords)->setAddedon($row->addedon)->setUpdatedon($row->updatedon); return $model; }