/**
* Reads a Yaml file and process the keys and returns as a associative indexed array
*
* @param string $file
*
* @return array
*/
protected function getYamlAsArray($file)
{
if (file_exists($file)) {
return ArrayTools::YamlToKeyedArray(file_get_contents($file));
}
return array();
}
public function getTranslations($locale, $criteria, $hierarchicalArray = true)
{
$sql = vsprintf('SELECT `%s` AS `key`, `%s` AS `message` FROM `%s` WHERE `%s` = :locale AND `%s` = :domain', array($this->getColumnname('key'), $this->getColumnname('message'), $this->getTablename(), $this->getColumnname('locale'), strpos('Bundle', $criteria) !== false ? $this->getColumnname('domain') : $this->getColumnname('bundle')));
$stmt = $this->getConnection()->prepare($sql);
$stmt->bindParam('locale', $locale);
if (strpos('Bundle', $criteria) !== false) {
$stmt->bindParam('bundle', $criteria);
} else {
$stmt->bindParam('domain', $criteria);
}
if (false === $stmt->execute()) {
throw new \RuntimeException('Could not fetch translation data from database.');
}
$result = array();
while ($row = $stmt->fetch()) {
$result[$row['key']] = $row['message'];
}
if ($hierarchicalArray) {
return ArrayTools::keyedAssocToHierarchical($result);
}
return $result;
}
/**
* {@inheritdoc}
*/
protected function execute(InputInterface $input, OutputInterface $output)
{
$this->input = $input;
$this->output = $output;
$ymlOptions = array('regenerate' => false, 'backup' => false, 'blank' => false);
$yml = $this->input->getOption('yml');
if ($yml) {
$aux = explode(",", $yml);
if (count($aux)) {
foreach ($aux as $option) {
$ymlOptions[$option] = true;
}
}
}
if (count($ymlOptions) != 3) {
var_dump($ymlOptions);
die('Sorry, but you can use only regenerate,blank and backup with --yml option');
}
$this->init($input->getOption('address'), $input->getOption('port'));
$config = $this->getContainer()->getParameter('translations_api');
$managedLocales = $config['managed_locales'];
$this->output->writeln(PHP_EOL . '<info>*** Syncing translations ***</info>');
/**
* uploading local catalog keys (from local table) to remote server
*/
if ($input->getOption('upload-first') == 'yes') {
$catalogs = $this->translationsRepository->getCatalogs();
foreach ($catalogs as $catalog) {
// data para enviar al servidor
$data = array();
$this->output->writeln(PHP_EOL . sprintf('<info>Processing catalog %s ...</info>', $catalog));
/** @var Translation[] $messages */
$messages = $this->translationsRepository->findBy(array('domain' => $catalog));
foreach ($messages as $message) {
$key = $message->getKey();
$locale = $message->getLocale();
$bundle = $message->getBundle();
$fileName = $message->getFile();
$data[$key][$locale] = array('message' => $message->getMessage(), 'updatedAt' => $message->getUpdatedAt()->format('c'), 'fileName' => $message->getFile(), 'bundle' => $message->getBundle());
}
$this->output->writeln('uploadKeys("' . $catalog . '", $data)');
$result = $this->clientApiService->uploadKeys($catalog, $data);
}
}
/**
* download the remote catalogs and integrate into local table (previously truncate local table)
*/
// truncate local translations table
$this->translationsRepository->truncateTranslations();
$result = $this->clientApiService->getCatalogIndex();
if ($result['result']) {
$catalogs = $result['catalogs'];
} else {
die('error getting catalogs');
}
foreach ($catalogs as $catalog) {
$this->output->writeln(PHP_EOL . sprintf('<info>Processing catalog %s ...</info>', $catalog));
$result = $this->clientApiService->downloadKeys($catalog);
file_put_contents(sys_get_temp_dir() . DIRECTORY_SEPARATOR . $catalog . '.json', json_encode($result));
$bundles = $result['bundles'];
foreach ($result['data'] as $key => $data) {
foreach ($data as $locale => $messageData) {
echo '.';
$fileName = isset($messageData['fileName']) ? $messageData['fileName'] : '';
$trans = Translation::newFromArray($catalog, $key, $locale, $messageData, $bundles[$key], $fileName);
$this->em->persist($trans);
}
}
}
$this->output->writeln(PHP_EOL . '<info>Flushing to DB ...</info>');
$this->em->flush();
/**
* regeneration of local .yml files if user wants
*/
/** @var DialogHelper $dialog */
$dialog = $this->getHelper('dialog');
if ($ymlOptions['regenerate']) {
$bundles = $this->translationsRepository->getBundles();
foreach ($bundles as $bundle) {
if (!$bundle) {
continue;
}
$keys = array();
$filenames = array();
$scheme = "";
// in order to deduce filename from other keys
$translations = $this->translationsRepository->getKeysByBundle($bundle);
foreach ($translations as $translation) {
$locale = $translation->getLocale();
$file = $translation->getFile();
if ($file && $locale && !$scheme) {
$scheme = str_replace(".{$locale}.", ".%s.", $file);
break;
}
}
foreach ($translations as $translation) {
$locale = $translation->getLocale();
$file = $translation->getFile();
if ($locale && !$file && $scheme) {
$file = sprintf($scheme, $locale);
}
if ($file && $locale) {
if (!isset($filenames[$locale])) {
$filenames[$locale] = $file;
}
$keys[$locale][$translation->getKey()] = $translation->getMessage();
}
}
foreach ($filenames as $locale => $file) {
$this->output->writeln(sprintf('Generating <info>"%s"</info> ...', $file));
$subKeys = $keys[$locale];
$file = dirname($this->rootDir) . '/src/' . $file;
if ($ymlOptions['blank']) {
foreach ($subKeys as $key => $value) {
if (!$value) {
$subKeys[$key] = $key;
}
}
}
if ($ymlOptions['backup'] && file_exists($file)) {
copy($file, $file . '.' . date('U'));
}
@mkdir(dirname($file), 0777, true);
file_put_contents($file, ArrayTools::prettyYamlDump($subKeys));
}
}
}
/**
* erasing cached translations files
*/
$this->output->writeln(PHP_EOL . '<info>Clearing SF cache ...</info>');
$finder = new Finder();
$finder->files()->in($this->rootDir . "/cache")->name('*');
foreach ($finder as $file) {
$fileFull = $file->getRealpath();
//$relativePath = $file->getRelativePath();
$fileName = $file->getRelativePathname();
if (preg_match('!/translations/.+$!i', $fileName)) {
$this->output->writeln('removing ' . $fileName);
unlink($file);
}
}
$this->output->writeln('');
}