public function editPageAction()
{
$id = $this->_getParam('id');
$this->view->user_id = $id;
$model1 = new Application_Model_Page();
$model = $model1->find($id);
if (false === $model) {
$this->_flashMessenger->addMessage(array('error' => 'Invalid request! Please try again.'));
$this->_helper->_redirector->gotoUrl($this->view->seoUrl('/hr/employees'));
}
$options = array('title' => $model->getTitle(), 'identifire' => $model->getIdentifire(), 'content' => $model->getContent(), 'metaTitle' => $model->getMetaTitle(), 'metaDescription' => $model->getMetaDescription(), 'metaKeyword' => $model->getMetaKeyword(), 'status' => $model->getStatus());
$request = $this->getRequest();
$form = new Application_Form_Page();
$form->populate($options);
$options = $request->getPost();
if ($request->isPost()) {
if ($form->isValid($options)) {
$sanitize = new Base_Sanitize();
if (trim($options['identifire']) == "") {
$options['identifire'] = $options['title'];
}
if (trim($options['identifire']) != "") {
$options['identifire'] = $sanitize->clearInputs($options['identifire']);
$options['identifire'] = $sanitize->sanitize($options['identifire']);
//update seo url table
$seo_url_title = $options['identifire'];
$actual_url = "/index/contact";
$seo_url = "/contact";
$actual_url = "/employee/page/identifire/{$model->getIdentifire()}";
$new_actual_url = "/employee/page/identifire/{$seo_url_title}";
$seo_url = "/{$seo_url_title}";
$seoUrlM = new Application_Model_SeoUrl();
$soeUrl = $seoUrlM->fetchRow("actual_url='{$actual_url}'");
if (false !== $soeUrl) {
if ($seo_url != "") {
$soeUrl->setActualUrl($new_actual_url);
$soeUrl->setSeoUrl($seo_url);
$soeUrl->save();
}
} else {
if ($seo_url != "") {
$seoUrl = new Application_Model_SeoUrl();
$seoUrl->setActualUrl($new_actual_url);
$seoUrl->setSeoUrl($seo_url);
$seoUrl->save();
}
}
}
$model->setOptions($options);
$model->save();
$this->_flashMessenger->addMessage(array('success' => 'Page has been updated successfully!'));
$this->_helper->_redirector->gotoUrl($this->view->seoUrl('/cms/edit-page/id/' . $id));
} else {
$this->_flashMessenger->addMessage(array('error' => 'Unable to save the data. Please provide valid inputs and try again.'));
$form->reset();
$form->populate($options);
}
}
$this->view->form = $form;
}
public function editAction()
{
$id = $this->_getParam('id');
$preview = false;
$preview = $this->_getParam('preview');
//echo "diana==>".base64_encode(85);
$this->view->id = $id;
$this->view->preview = $preview;
$page = new Application_Model_Advice();
$page = $page->find($id);
$options = array('categoryId' => $page->getCategoryId(), 'title' => $page->getTitle(), 'identifire' => $page->getIdentifire(), 'name' => $page->getName(), 'content' => $page->getContent(), 'synopsis' => $page->getSynopsis(), 'metaTitle' => $page->getMetaTitle(), 'metaDescription' => $page->getMetaDescription(), 'metaKeyword' => $page->getMetaKeyword(), 'status' => $page->getStatus(), 'name' => $page->getName(), 'userId' => $page->getUserId());
$request = $this->getRequest();
$form = new Admin_Form_Advice();
//clear form element decorators
$elements = $form->getElements();
$form->clearDecorators();
foreach ($elements as $element) {
$element->removeDecorator('label');
$element->removeDecorator('td');
$element->removeDecorator('tr');
$element->removeDecorator('row');
$element->removeDecorator('HtmlTag');
$element->removeDecorator('class');
$element->removeDecorator('placement');
$element->removeDecorator('data');
}
//$this->view->type = $page->getType();
$this->view->imgName = $page->getName();
$form->populate($options);
if ($request->isPost()) {
$options = $request->getPost();
if (trim($options['identifire']) == "") {
$sanitize = new Base_Sanitize();
$options['identifire'] = $options['title'];
}
if (trim($options['identifire']) != "") {
$sanitize = new Base_Sanitize();
$options['identifire'] = $sanitize->clearInputs($options['identifire']);
$options['identifire'] = $sanitize->sanitize($options['identifire']);
//update seo url table
$seo_url_title = $options['identifire'];
$adviceM = new Application_Model_Advice();
$advice = $adviceM->find($id);
$seo_url = "";
$actual_url = "/advice/detail/id/{$id}";
if (false !== $advice) {
$sanitizeM = new Base_Sanitize();
//$category_id = $advice->getCategoryId();
$category_id = $options['categoryId'];
$categoryM = new Application_Model_Category();
$category = $categoryM->find($category_id);
if (false !== $category) {
$seo_url = "/advice/" . $sanitizeM->sanitize($category->getName()) . "/" . $seo_url_title;
}
}
$seoUrlM = new Application_Model_SeoUrl();
$soeUrl = $seoUrlM->fetchRow("actual_url='{$actual_url}'");
if (false !== $soeUrl) {
if ($seo_url != "") {
$soeUrl->setSeoUrl($seo_url);
$soeUrl->save();
}
} else {
if ($seo_url != "") {
$seoUrl = new Application_Model_SeoUrl();
$seoUrl->setActualUrl($actual_url);
$seoUrl->setSeoUrl($seo_url);
$seoUrl->save();
}
}
}
//save data
if ($form->isValid($options)) {
//set previous image name if not uploaded new one
$options['name'] = $page->getName();
/*------------------------------ Image Upload START ---------------------------*/
$upload = new Zend_File_Transfer_Adapter_Http();
if ($upload->isValid()) {
$upload->setDestination("images/advice/");
try {
$upload->receive();
} catch (Zend_File_Transfer_Exception $e) {
$msg = $e->getMessage();
}
//unlink previous uploaded image files
unlink("images/advice/" . $page->getName());
unlink("images/advice/thumb_" . $page->getName());
$upload->setOptions(array('useByteString' => false));
$file_name = $upload->getFileName('name');
$cardImageTypeArr = explode(".", $file_name);
$ext = strtolower($cardImageTypeArr[count($cardImageTypeArr) - 1]);
$target_file_name = "advice_" . time() . ".{$ext}";
$targetPath = 'images/advice/' . $target_file_name;
$targetPathThumb = 'images/advice/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(128, 84);
$thumb->save($targetPathThumb);
// file name
$options['name'] = $target_file_name;
}
/*------------------------------ Image Upload END ---------------------------*/
$options['status'] = $page->getStatus();
if ($options["saveUnpublish"] == "Save and Unpublish") {
$options['status'] = 0;
}
if ($options["savePublish"] == "Save and Publish") {
$options['status'] = 1;
}
$page->setOptions($options);
$page->save();
//return $this->_helper->redirector('index','advice',"admin",Array('msg'=>base64_encode("'{$page->getTitle()}' has been updated successfully!")));
if ($options["savePublish"] == "Save and Publish") {
$_SESSION['errorMsg'] = "Article has been saved & published successfully.";
$this->_helper->redirector('index', 'advice', 'admin');
} else {
if ($options["saveUnpublish"] == "Save and Unpublish") {
$_SESSION['errorMsg'] = "Article has been saved successfully.";
$this->_helper->redirector('index', 'advice', 'admin');
} else {
$this->_helper->redirector('edit', 'advice', 'admin', array('id' => $id, 'preview' => 'true'));
}
}
} else {
$form->reset();
$form->populate($options);
}
}
$this->view->form = $form;
}
public function addAction()
{
$request = $this->getRequest();
$form = new Admin_Form_Page();
//clear form element decorators
$elements = $form->getElements();
$form->clearDecorators();
foreach ($elements as $element) {
$element->removeDecorator('label');
$element->removeDecorator('td');
$element->removeDecorator('tr');
$element->removeDecorator('row');
$element->removeDecorator('HtmlTag');
$element->removeDecorator('class');
$element->removeDecorator('placement');
$element->removeDecorator('data');
}
$model = new Application_Model_Page();
$page_id = $this->_getParam('id');
$this->view->msg = "";
if ($this->_getParam('m') == 's') {
$this->view->msg = "Page saved successfully";
} else {
if ($this->_getParam('m') == 'e') {
$this->view->msg = "Page identifire already exist";
}
}
//submit form
if ($this->getRequest()->isPost()) {
if ($form->isValid($request->getPost())) {
$params = $form->getValues();
$params['status'] = 1;
if ($options["savePublish"] != "Save and Publish") {
$params['status'] = 0;
}
$usersNs = new Zend_Session_Namespace("members");
$params['userId'] = $usersNs->userId;
//Set SEO page URL START, added by Mahipal on 23-Feb-2011
$sanitize = new Base_Sanitize();
if (trim($params['identifire']) == "") {
$params['identifire'] = $params['title'];
}
if (trim($params['identifire']) != "") {
$params['identifire'] = $sanitize->clearInputs($params['identifire']);
$params['identifire'] = $sanitize->sanitize($params['identifire']);
$seo_url_title = $params['identifire'];
$actual_url = "/index/page/identifire/{$seo_url_title}";
$seo_url = "/{$seo_url_title}";
if ($seo_url != "") {
$seoUrl = new Application_Model_SeoUrl();
$seoUrl->setActualUrl($actual_url);
$seoUrl->setSeoUrl($seo_url);
$seoUrl->save();
}
}
//Set SEO page URL END
$model = new Application_Model_Page($params);
try {
$page_id = $model->save();
//$this->_helper->redirector('add','page','admin',array('id'=>$page_id,'m'=>'s'));
if ($options["savePublish"] == "Save and Publish") {
$_SESSION['errorMsg'] = "Page has been saved & published successfully.";
$this->_helper->redirector('index', 'page', 'admin');
} else {
if ($options["saveUnpublish"] == "Save and Unpublish") {
$_SESSION['errorMsg'] = "Page has been saved successfully.";
$this->_helper->redirector('index', 'page', 'admin');
} else {
//$this->_helper->redirector('edit','page','admin',array('id'=>$page_id,'preview'=>'true'));
$identifire = $params['identifire'];
$this->_helper->redirector('edit', 'page', 'admin', array('id' => $page_id, 'identifire' => $identifire, 'preview' => 'true'));
}
}
} catch (Exception $e) {
$this->_helper->redirector('add', 'page', 'admin', array('id' => $page_id, 'm' => 'e'));
}
}
}
$this->view->form = $form;
}
public function addAction()
{
$request = $this->getRequest();
$form = new Admin_Form_Articles();
//clear form element decorators
$elements = $form->getElements();
$form->clearDecorators();
foreach ($elements as $element) {
$element->removeDecorator('label');
$element->removeDecorator('td');
$element->removeDecorator('tr');
$element->removeDecorator('row');
$element->removeDecorator('HtmlTag');
$element->removeDecorator('class');
$element->removeDecorator('placement');
$element->removeDecorator('data');
}
$model = new Application_Model_Articles();
$page_id = $this->_getParam('id');
$this->view->msg = "";
if ($this->_getParam('m') == 's') {
$this->view->msg = "Article has been saved successfully.";
}
//select logged in user as default seleted for Author
$usersNs = new Zend_Session_Namespace("members");
$author = array('userId' => $usersNs->userId);
$form->populate($author);
/*-----------------------------------------*/
if ($this->getRequest()->isPost()) {
$options = $request->getPost();
if (trim($options['identifire']) == "") {
$options['identifire'] = $options['title'];
}
if (trim($options['identifire']) != "") {
$sanitize = new Base_Sanitize();
$options['identifire'] = $sanitize->clearInputs($options['identifire']);
$options['identifire'] = $sanitize->sanitize($options['identifire']);
}
if ($form->isValid($options)) {
/*------------------------------Image Upload ---------------------------*/
$upload = new Zend_File_Transfer_Adapter_Http();
$target_file_name = "";
if ($upload->isValid()) {
$upload->setDestination("images/articles/");
try {
$upload->receive();
} catch (Zend_File_Transfer_Exception $e) {
$msg = $e->getMessage();
}
$upload->setOptions(array('useByteString' => false));
$file_name = $upload->getFileName('image');
$cardImageTypeArr = explode(".", $file_name);
$ext = strtolower($cardImageTypeArr[count($cardImageTypeArr) - 1]);
$target_file_name = "art_" . time() . ".{$ext}";
$targetPath = 'images/articles/' . $target_file_name;
$targetPathThumb = 'images/articles/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(100, 64);
$thumb->save($targetPathThumb);
}
//end if
/*------------------------------Image Upload ---------------------------*/
$params = $options;
$params['status'] = 1;
if ($options["savePublish"] != "Save and Publish") {
$params['status'] = 0;
}
//commented by mahipal on 29-dec-2010 and replaced with user dropdown list
//$usersNs = new Zend_Session_Namespace("members");
//$params['userId'] = $usersNs->userId;
$params['image'] = $target_file_name;
// file name
$model = new Application_Model_Articles($params);
$id = $page_id = $model->save();
$seo_url_title = $options['identifire'];
$articleM = new Application_Model_Articles();
$article = $articleM->find($id);
$seo_url = "";
$actual_url = "/work-study-volunteer/article-detail/id/{$id}";
if (false !== $article) {
$sanitizeM = new Base_Sanitize();
$category_id = $article->getCategoryId();
$categoryM = new Application_Model_Category();
$category = $categoryM->find($category_id);
if (false !== $category) {
//$seo_url="/work-study-volunteer/".$category->getType()."/".$sanitizeM->sanitize($category->getName())."/".$seo_url_title;
$seo_url = "/work-study-volunteer/" . $sanitizeM->sanitize($category->getName()) . "/" . $seo_url_title;
}
}
$seoUrlM = new Application_Model_SeoUrl();
$seoUrl = $seoUrlM->fetchRow("actual_url='{$actual_url}'");
if (false !== $seoUrl) {
if ($seo_url != "") {
$seoUrl->setSeoUrl($seo_url);
$seoUrl->save();
}
} else {
if ($seo_url != "") {
$seoUrl = new Application_Model_SeoUrl();
$seoUrl->setActualUrl($actual_url);
$seoUrl->setSeoUrl($seo_url);
$seoUrl->save();
}
}
//$this->_helper->redirector('add','articles','admin',array('id'=>$page_id,'m'=>'s'));
if ($options["savePublish"] == "Save and Publish") {
$_SESSION['errorMsg'] = "Article has been saved & published successfully.";
$this->_helper->redirector('index', 'articles', 'admin');
} else {
if ($options["saveUnpublish"] == "Save and Unpublish") {
$_SESSION['errorMsg'] = "Article has been saved successfully.";
$this->_helper->redirector('index', 'articles', 'admin');
} else {
$this->_helper->redirector('edit', 'articles', 'admin', array('id' => $page_id, 'preview' => 'true'));
}
}
}
//end if
}
//end if
$this->view->form = $form;
}
/**
* @Created By : Mahipal Singh Adhikari
* @Created On : 2-Dec-2010
* @Description : Used to parse Lonely Planet Country XML and save data to database table
*/
public function lonelyXmlAction()
{
//disable layout and view
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
//create Db and Sanitize class objects
$db = Zend_Registry::get("db");
$sanitizeM = new Base_Sanitize();
//Truncate or Empty table first
$db->query("TRUNCATE TABLE lonely_planet_country");
//$directory="data/1615/xml/20110119/";
$directory = "data/1615/xml/20110304/";
//$directory="data/1615/xml/test/";
if (!($dp = opendir($directory))) {
die("Cannot open {$directory}.");
}
$countFiles = 1;
while ($filename = readdir($dp)) {
$file_path = "";
if (is_dir($filename)) {
continue;
} else {
if ($filename != '.' && $filename != '..') {
$fileExtension = explode(".", $filename);
$fileExtension = strtolower($fileExtension[count($fileExtension) - 1]);
if ($fileExtension == "xml") {
$file_path = $directory . $filename;
//open and replace HTMl tags from XML file and rewrite
$fileContent = "";
$fh = "";
$fileContent = file_get_contents($file_path);
$fileContent = $this->replaceText($fileContent);
$fh = fopen($file_path, 'w+') or die("can't open file");
fwrite($fh, $fileContent);
fclose($fh);
//now load XML files and parse XMLs
$data = array();
echo "<br><br>Strart processing file==><b>" . $file_path . "</b> counter=>" . $countFiles;
$destination = simplexml_load_file($file_path);
$data["node_id"] = (string) $destination["node_id"];
$data["destination_name"] = (string) $sanitizeM->clearInputs($destination->destination_name);
$data["full_destination_name"] = (string) $destination->general->full_destination_name;
$data["intro_mini"] = (string) $this->replaceText($destination->general->intro_mini, true);
$data["intro_short"] = (string) $this->replaceText($destination->general->intro_short, true);
$data["warning_title"] = (string) $destination->general->warning_title;
$data["warning_text"] = (string) $this->replaceText($destination->general->warning_text, true);
$data["warning_position"] = (string) $destination->general->warning_position;
$data["warning_severity"] = (string) $destination->general->warning_severity;
//timezones
if ($destination->general->timezones) {
$tz = 0;
$arrayTimezone = array();
foreach ($destination->general->timezones->children() as $timezone) {
$arrayTimezone[$tz]['gmt_utc'] = (string) $timezone->gmt_utc;
$tz++;
}
$data["timezones"] = serialize($arrayTimezone);
}
$data["weights_measures_system"] = (string) $destination->general->weights_measures_system;
$data["capital_city"] = (string) $destination->general->capital_city;
//government leaders
if ($destination->government->leaders) {
$ld = 0;
$arrayLeaders = array();
foreach ($destination->government->leaders->children() as $leader) {
$arrayLeaders[$ld]['leader_name'] = (string) $leader->leader_name;
$arrayLeaders[$ld]['leader_type'] = (string) $leader->leader_type;
$arrayLeaders[$ld]['leader_title'] = (string) $leader->leader_title;
$ld++;
}
$data["leaders"] = serialize($arrayLeaders);
}
$data["government_type"] = (string) $destination->government->government_type;
$data["area_sqkm"] = (string) $destination->environment->area_sqkm;
$data["population"] = (string) $destination->environment->population;
//languages
$i = 0;
if ($destination->society->language_spokens) {
$arrayLanguage = array();
foreach ($destination->society->language_spokens->children() as $language_spoken) {
$arrayLanguage[$i]['language_spoken_type'] = (string) $language_spoken->language_spoken_type;
$arrayLanguage[$i]['language_spoken_name'] = (string) $language_spoken->language_spoken_name;
if ($language_spoken->language_spoken_description) {
$arrayLanguage[$i]['language_spoken_description'] = (string) $this->replaceText($language_spoken->language_spoken_description, true);
}
$i++;
}
$data["language_spokens"] = serialize($arrayLanguage);
}
$data["religion"] = (string) $this->replaceText($destination->society->religion, true);
$data["currency_code"] = (string) $destination->economy->currency_code;
$data["currency_name"] = (string) $destination->economy->currency_name;
$data["currency_symbol"] = (string) $destination->economy->currency_symbol;
$data["currency_unit"] = (string) $destination->economy->currency_unit;
//$data["relative_cost_rooms"]=serialize($destination->money->relative_cost_rooms);
//$data["relative_cost_meals"]=serialize($destination->money->relative_cost_meals);
$pre = 'pre-departure';
$when_to_go = $destination->{$pre}->when_to_go;
$data["when_to_go"] = (string) $this->replaceText($destination->{$pre}->when_to_go, true);
$data["visas_overview"] = (string) $this->replaceText($destination->{$pre}->visas_overview, true);
//electrical plugs
if ($destination->{$pre}->electrical_plugs) {
$ep = 0;
$arrayElectricalPlugs = array();
foreach ($destination->{$pre}->electrical_plugs->children() as $electrical_plugs) {
$arrayElectricalPlugs[$ep]['image_filename'] = (string) $electrical_plugs->image_filename;
$arrayElectricalPlugs[$ep]['electrical_plug_description'] = (string) $this->replaceText($electrical_plugs->electrical_plug_description, true);
$ep++;
}
$data["electrical_plugs"] = serialize($arrayElectricalPlugs);
}
$data["electricity_voltage"] = (string) $destination->{$pre}->electricity_voltage;
$data["electricity_hz"] = (string) $destination->{$pre}->electricity_hz;
$data["dangers_and_annoyances"] = (string) $this->replaceText($destination->health->dangers_and_annoyances, true);
//health conditions
if ($destination->health->health_conditions) {
$arrHealthCondition = array();
foreach ($destination->health->health_conditions->children() as $healthCondition) {
$type = "";
$type = (string) $healthCondition->health_condition_type;
$arrHealthCondition[$type] = (string) $this->replaceText($healthCondition->health_condition_description, true);
}
$data["health_conditions"] = serialize($arrHealthCondition);
}
$data["weather_overview"] = (string) $this->replaceText($destination->weather->weather_overview, true);
$data["country_dialling_code"] = (string) $destination->communication->country_dialling_code;
//transports
if ($destination->transport) {
$arrTransport = array();
foreach ($destination->transport->destination_transport_topics->children() as $transport) {
$transport_type = "";
$transport_type = (string) $transport->transport_type;
$arrTransport[$transport_type] = (string) $this->replaceText($transport->transport_description, true);
}
$data["transport"] = serialize($arrTransport);
}
$data["history_pre_20c"] = (string) $this->replaceText($destination->culture->history_pre_20c, true);
$data["history_modern"] = (string) $this->replaceText($destination->culture->history_modern, true);
$data["history_recent"] = (string) $this->replaceText($destination->culture->history_recent, true);
//$data["product_info"]=serialize($destination->product_info);
//get images
if ($destination->images) {
$img = 0;
$arrayImages = array();
foreach ($destination->images->children() as $image) {
$arrayImages[$img]['image_caption'] = (string) $image->image_caption;
$arrayImages[$img]['image_photographer'] = (string) $image->image_photographer;
$arrayImages[$img]['image_filename'] = (string) $image->image_filename;
$arrayImages[$img]['image_thumbnail_filename'] = (string) $image->image_thumbnail_filename;
$img++;
}
$data["images"] = serialize($arrayImages);
}
//get maps
if ($destination->map) {
$arrayMaps = array();
$arrayMaps['map_name'] = (string) $destination->map->map_name;
$arrayMaps['map_filename'] = (string) $destination->map->map_filename;
$arrayMaps['map_thumbnail_filename'] = (string) $destination->map->map_thumbnail_filename;
$data["map"] = serialize($arrayMaps);
}
$i = 0;
foreach ($destination->pois->children() as $poi) {
$arrayPoi[$i]['poi_name'] = (string) $poi->poi_name;
$address_parts = (array) $poi->address_parts;
$addressPart = array();
if (isset($address_parts['address_part']) && count($address_parts['address_part']) > 0) {
foreach ($address_parts['address_part'] as $address_part) {
$addressPart[] = (array) $address_part;
}
$arrayPoi[$i]['address_parts'] = $addressPart;
}
$arrayPoi[$i]['address_postcode'] = (string) $poi->address_postcode;
$arrayPoi[$i]['poi_web'] = (string) $poi->poi_web;
$arrayPoi[$i]['review_summary'] = (string) $this->replaceText($poi->review_summary, true);
$arrayPoi[$i]['review_full'] = (string) $this->replaceText($poi->review_full, true);
$arrayPoi[$i]['keywords'] = (array) $poi->keywords;
$i++;
}
$data["pois"] = serialize($arrayPoi);
//attrations
if ($destination->attractions) {
$attr = 0;
$arrayAttr = array();
foreach ($destination->attractions->children() as $attraction) {
$arrayAttr[$attr]['destination_name'] = (string) $attraction->destination_name;
$arrayAttr[$attr]['full_destination_name'] = (string) $attraction->general->full_destination_name;
$arrayAttr[$attr]['intro_short'] = (string) $this->replaceText($attraction->general->intro_short, true);
$arrayAttr[$attr]['intro_medium'] = (string) $this->replaceText($attraction->general->intro_medium, true);
$attr++;
}
$data["attractions"] = serialize($arrayAttr);
}
$data["copyright"] = (string) $destination->copyright;
$data["addedon"] = time();
/*----Country Info----*/
$countryM = new Application_Model_Country();
$countryName = $sanitizeM->clearInputs($data["destination_name"]);
if (!get_magic_quotes_gpc()) {
$countryName = addslashes($countryName);
}
//$countryName=@mb_convert_encoding($countryName, 'UTssssF8', 'auto');
$country = $countryM->fetchRow("name like '{$countryName}'");
if (false === $country) {
//get country continent
$continent_id = "";
$continent_id = $countryM->countryContinent($countryName);
$countryName = $sanitizeM->clearInputs($data["destination_name"]);
//if doesn't exists
if (!$this->duplicateCountries($countryName)) {
$countryM->setName($countryName);
$countryM->setContinentId($continent_id);
$country_id = $countryM->save();
}
} else {
$country_id = $country->getId();
}
$data['country_id'] = $country_id;
/*---------------*/
//check existing country record in lonely_planet_country table
$lonelyM = new Application_Model_LonelyPlanetCountry();
$lonelyM = $lonelyM->fetchRow("country_id={$country_id}");
if (false !== $lonelyM) {
$res = $db->update("lonely_planet_country", $data, "country_id={$country_id}");
} else {
$res = $db->insert("lonely_planet_country", $data);
}
echo "<br>END File==><b>" . $file_path . "</b> has been processed, counter=>" . $countFiles;
$countFiles++;
}
//end of if
}
}
//end of else if
}
//end of while
closedir($dp);
//rename countries name
$db->query("UPDATE country SET name='Bosnia and Herzogovina' WHERE name='Bosnia-Hercegovina'");
$db->query("UPDATE country SET name='Vatican City' WHERE name='Holy See'");
$db->query("UPDATE country SET name='Ivory Coast' WHERE name='Cote dIvoire'");
//delete countries for which no planet feeds data available
//$sSQlQuery = "DELETE FROM country WHERE id IN(select t.id FROM (SELECT id FROM `country` WHERE id NOT IN (SELECT country_id FROM lonely_planet_country WHERE country_id IS NOT NULL)) AS t)";
//$db->query($sSQlQuery);
}
