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;
}
}
