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