function insertDataPool ( $datas, $resultSet ) { foreach ( $datas as $key => $facet ) { $applicationFacetId = insertFacet( $facet['facet'], $facet['identifier'] ); insertTranslation ( $applicationFacetId, '', $facet['reply'] ); foreach ($facet['translate'] as $clusterIdentifier => $translation) { insertTranslation ( $applicationFacetId, $clusterIdentifier, $translation ); } foreach ($facet['ids'] as $id) { insertRelation ( $applicationFacetId, $id, $resultSet[$id] ); } } }
// print_r($map[$i]['array'][$j]['key']); // echo " : "; // print_r($map[$i]['array'][$j]['value']); // echo "<br />"; $stmt = $db->prepare("SELECT id FROM Identifiers where identifier = ?"); //The list of identifiers contains doubles, so check for these if ($stmt->execute(array($map[$i]['array'][$j]['key']))) { $row = $stmt->fetch(); if (!$row) { echo "Identifier does not exist, insert into database"; echo "<br />"; $stmt = $db->prepare("INSERT INTO Identifiers (identifier) VALUES (?)"); $stmt->bindParam(1, $id); // insert row $id = $map[$i]['array'][$j]['key']; $value = 1; $stmt->execute(); insertTranslation($db, $db->lastInsertId(), $map[$i]['key'], $map[$i]['array'][$j]['value']); } else { echo "Already found this identfier, has id " . $row['id']; echo "<br />"; insertTranslation($db, $row['id'], $map[$i]['key'], $map[$i]['array'][$j]['value']); } } } } function insertTranslation($db, $identifierId, $lang, $translation) { $stmt = $db->prepare("INSERT INTO Translations (identifier, lang, contents) VALUES (:identifier, :lang, :contents)"); $stmt->execute(array(':identifier' => $identifierId, ':lang' => $lang, ':contents' => $translation)); }
/** * Configura a linguagem padr�o */ private function GetLanguage() { $mysql = new MysqlConsulta($this->cfg); $this->language['language_default'] = $mysql->getLanguagefromCOUNTRY($this->cfg['ID_COUNTRY']); //--> en,pt-br,ja,it $this->language['language'] = $mysql->ListLanguages($this->language['language_default']); if (isset($this->perfil->user_language)) { $this->language['language_default'] = $this->perfil->user_language; $this->language['language'] = $mysql->ListLanguages($this->perfil->user_language); } if (isset($_GET['q'])) { $query = getLanguageURL($_GET['q']); if ($query[1]) { $this->language['language_default'] = $query[1]; $this->language['language'] = $mysql->ListLanguages($query[1]); } $_GET['q'] = $query[0]; } if ($this->language['language']->language != language_default()->language) { $this->language['translate'] = $mysql->getTranslate($this->language['language']->language); if (!$this->language['translate']) { $po = loadPO($this->language['language']->language); if ($po == false) { //@todo mensagem de errooooo $message = _t("File not found a standard language for this request."); setMessage($message, 'error'); } insertTranslation($po); } else { $po = new PO(); $po->set_headers($this->language['translate']->headers); $po->merge_with($this->language['translate']); //@todo = verificar esta requisições de texto, se a função de tradução não irá cumprir o mesmo papel } $this->language['translate'] = $po; } }