/** * Update the countries with new columns. */ protected function updateCountries($content) { JLoader::register("CrowdfundingTableCountry", JPATH_ADMINISTRATOR . "/components/com_crowdfunding/tables/country.php"); $db = $this->getDbo(); foreach ($content->country as $item) { $code = Joomla\String\String::trim($item->code); $keys = array("code" => $code); $table = new CrowdfundingTableCountry($db); $table->load($keys); if (!$table->id) { $table->name = Joomla\String\String::trim($item->name); $table->code = $code; } $table->code4 = Joomla\String\String::trim($item->code4); $table->latitude = Joomla\String\String::trim($item->latitude); $table->longitude = Joomla\String\String::trim($item->longitude); $table->currency = Joomla\String\String::trim($item->currency); $table->timezone = Joomla\String\String::trim($item->timezone); $table->store(); } }
/** * Update the countries with new columns. * * @param SimpleXMLElement $content */ protected function updateCountries($content) { JLoader::register('CrowdfundingTableCountry', JPATH_ADMINISTRATOR . '/components/com_crowdfunding/tables/country.php'); $db = $this->getDbo(); foreach ($content->country as $item) { $code = JString::trim($item->code); $keys = array('code' => $code); $table = new CrowdfundingTableCountry($db); $table->load($keys); if (!(int) $table->id) { $table->set('name', JString::trim($item->name)); $table->set('code', $code); } $table->set('locale', JString::trim($item->locale)); $table->set('latitude', JString::trim($item->latitude)); $table->set('longitude', JString::trim($item->longitude)); $table->set('currency', JString::trim($item->currency)); $table->set('timezone', JString::trim($item->timezone)); $table->store(); } }