public function executeUpdate($request)
{
$source = $request->getParameter('transUnit');
$unitvars = $request->getParameter('unitvars');
foreach ($unitvars as $lang => $val) {
// 1. check that $lang catalogue exists
$catalogue = Doctrine::getTable('Catalogue')->findOneByTargetLangAndName($lang, 'messages.' . $lang);
if (!$catalogue) {
//1.1 if not then add it
$catalogue = new Catalogue();
$catalogue->fromArray(array('name' => 'messages.' . $lang, 'source_lang' => 'en', 'target_lang' => $lang));
$catalogue->save();
}
$transUnit = Doctrine::getTable('TransUnit')->findOneByLangAndCategory($source, $catalogue->cat_id);
if (!$transUnit) {
$transUnit = new TransUnit();
$transUnit->fromArray(array('source' => $source));
$transUnit->setCatalogue($catalogue);
}
$transUnit->setTarget($val);
$transUnit->translated = empty($val) ? 0 : 1;
$transUnit->save();
}
$this->clearCache();
$this->redirect('@admin_page?module=translation&action=edit&source=' . $source);
}
public static function createWildcard($wildcard, $catalogue)
{
// get all available languages
$langs = LanguageTable::getAllLanguages(false);
foreach ($langs as $l) {
$lQuery = Doctrine_Query::create()->from('Catalogue c')->select('c.cat_id')->where('c.name= ?', $catalogue . '.' . $l->getLang());
$catId = $lQuery->execute(array(), Doctrine_Core::HYDRATE_NONE);
$catId = HydrationUtils::flattenArray($catId);
if (!$catId) {
continue;
}
$t = new TransUnit();
$t->setCatId($catId[0]);
$t->setSource($wildcard);
$t->save();
}
}
