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 function getCatalogueID($lang)
{
$cat = Doctrine::getTable('Catalogue')->findOneByNameAndTargetLang($this->getCatalogueBaseName() . '.' . $lang, $lang);
if ($cat) {
return $cat['cat_id'];
} else {
$cat = new Catalogue();
$cat->fromArray(array('name' => $this->getCatalogueBaseName() . '.' . $lang, 'source_lang' => 'en', 'target_lang' => $lang));
$cat->save();
return $cat['cat_id'];
}
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aCatalogue !== null) {
if ($this->aCatalogue->isModified() || $this->aCatalogue->isNew()) {
$affectedRows += $this->aCatalogue->save($con);
}
$this->setCatalogue($this->aCatalogue);
}
if ($this->isNew()) {
$this->modifiedColumns[] = TransUnitPeer::MSG_ID;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = TransUnitPeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setMsgId($pk);
//[IMV] update autoincrement primary key
$this->setNew(false);
} else {
$affectedRows += TransUnitPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aCatalogue !== null) {
if ($this->aCatalogue->isModified() || $this->aCatalogue->isNew()) {
$affectedRows += $this->aCatalogue->save($con);
}
$this->setCatalogue($this->aCatalogue);
}
if ($this->aProvincia !== null) {
if ($this->aProvincia->isModified() || $this->aProvincia->isNew()) {
$affectedRows += $this->aProvincia->save($con);
}
$this->setProvincia($this->aProvincia);
}
if ($this->isNew()) {
$this->modifiedColumns[] = UsuarioPeer::ID_USUARIO;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = UsuarioPeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setIdUsuario($pk);
//[IMV] update autoincrement primary key
$this->setNew(false);
} else {
$affectedRows += UsuarioPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
if ($this->collUsuarioGrupos !== null) {
foreach ($this->collUsuarioGrupos as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collAlcances !== null) {
foreach ($this->collAlcances as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collSesions !== null) {
foreach ($this->collSesions as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collMensajes !== null) {
foreach ($this->collMensajes as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collMensajeDestinos !== null) {
foreach ($this->collMensajeDestinos as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collEmpresas !== null) {
foreach ($this->collEmpresas as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collTablas !== null) {
foreach ($this->collTablas as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collFormulariosRelatedByIdUsuario !== null) {
foreach ($this->collFormulariosRelatedByIdUsuario as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collFormulariosRelatedByIdUsuarioCreador !== null) {
foreach ($this->collFormulariosRelatedByIdUsuarioCreador as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collTareas !== null) {
foreach ($this->collTareas as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collHistoricoDocumentos !== null) {
foreach ($this->collHistoricoDocumentos as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
