protected function addSortCriteria($c) { if ($sort_column = $this->getUser()->getAttribute('sort', null, 'sf_admin/trans_unit/sort')) { $sort_column = TransUnitPeer::translateFieldName($sort_column, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_COLNAME); if ($this->getUser()->getAttribute('type', null, 'sf_admin/trans_unit/sort') == 'asc') { $c->addAscendingOrderByColumn($sort_column); } else { $c->addDescendingOrderByColumn($sort_column); } } }
/** * This is a method for emulating ON DELETE CASCADE for DBs that don't support this * feature (like MySQL or SQLite). * * This method is not very speedy because it must perform a query first to get * the implicated records and then perform the deletes by calling those Peer classes. * * This method should be used within a transaction if possible. * * @param Criteria $criteria * @param PropelPDO $con * @return int The number of affected rows (if supported by underlying database driver). */ protected static function doOnDeleteCascade(Criteria $criteria, PropelPDO $con) { // initialize var to track total num of affected rows $affectedRows = 0; // first find the objects that are implicated by the $criteria $objects = CataloguePeer::doSelect($criteria, $con); foreach ($objects as $obj) { // delete related TransUnit objects $c = new Criteria(TransUnitPeer::DATABASE_NAME); $c->add(TransUnitPeer::CAT_ID, $obj->getCatId()); $affectedRows += TransUnitPeer::doDelete($c, $con); } return $affectedRows; }
/** * Returns the number of related TransUnit objects. * * @param Criteria $criteria * @param boolean $distinct * @param PropelPDO $con * @return int Count of related TransUnit objects. * @throws PropelException */ public function countTransUnits(Criteria $criteria = null, $distinct = false, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(CataloguePeer::DATABASE_NAME); } else { $criteria = clone $criteria; } if ($distinct) { $criteria->setDistinct(); } $count = null; if ($this->collTransUnits === null) { if ($this->isNew()) { $count = 0; } else { $criteria->add(TransUnitPeer::CAT_ID, $this->cat_id); $count = TransUnitPeer::doCount($criteria, $con); } } else { // criteria has no effect for a new object if (!$this->isNew()) { // the following code is to determine if a new query is // called for. If the criteria is the same as the last // one, just return count of the collection. $criteria->add(TransUnitPeer::CAT_ID, $this->cat_id); if (!isset($this->lastTransUnitCriteria) || !$this->lastTransUnitCriteria->equals($criteria)) { $count = TransUnitPeer::doCount($criteria, $con); } else { $count = count($this->collTransUnits); } } else { $count = count($this->collTransUnits); } } return $count; }
/** * Retrieve multiple objects by pkey. * * @param array $pks List of primary keys * @param PropelPDO $con the connection to use * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function retrieveByPKs($pks, PropelPDO $con = null) { if ($con === null) { $con = Propel::getConnection(TransUnitPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(TransUnitPeer::DATABASE_NAME); $criteria->add(TransUnitPeer::MSG_ID, $pks, Criteria::IN); $objs = TransUnitPeer::doSelect($criteria, $con); } return $objs; }
protected function getTransUnitByMsgIdOrCreate($msg_id = NULL) { if (is_null($msg_id)) { $trans_unit = new TransUnit(); } else { $trans_unit = TransUnitPeer::retrieveByPk($msg_id); $this->forward404Unless($trans_unit); } return $trans_unit; }
/** * Populates the object using an array. * * This is particularly useful when populating an object from one of the * request arrays (e.g. $_POST). This method goes through the column * names, checking to see whether a matching key exists in populated * array. If so the setByName() method is called for that column. * * You can specify the key type of the array by additionally passing one * of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME, * BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM. * The default key type is the column's phpname (e.g. 'AuthorId') * * @param array $arr An array to populate the object from. * @param string $keyType The type of keys the array uses. * @return void */ public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) { $keys = TransUnitPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setMsgId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setCatId($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setId($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setSource($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setTarget($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setComments($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setDateAdded($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setDateModified($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setAuthor($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setTranslated($arr[$keys[9]]); } }
<?php $cat_array = TransUnitPeer::getTargetLangArray(); echo select_tag('filters[cat_id]', options_for_select($cat_array, isset($filters['cat_id']) ? $filters['cat_id'] : '', array('include_blank' => true)));
<?php $catalogues = CataloguePeer::getCatalogues(); echo input_hidden_tag("trans_unit[msg_id]", $trans_unit->getMsgId()); ?> <?php foreach ($catalogues as $catalogue) { $c = new Criteria(); $c->add(TransUnitPeer::CAT_ID, $catalogue->getCatId()); $c->add(TransUnitPeer::SOURCE, $trans_unit->getSource()); $trans_unit_string = 'trans_unit_' . $catalogue->getCatId(); $cat_id = $catalogue->getCatId(); ${$trans_unit_string} = TransUnitPeer::doSelectOne($c); if (${$trans_unit_string}) { $msg_id_string = 'msg_id_' . $catalogue->getCatId(); echo input_hidden_tag("{$trans_unit_string}[msg_id]", ${$trans_unit_string}->getMsgId()); } else { ${$trans_unit_string} = new TransUnit(); } echo '<h2><strong>' . $catalogue->getNvisible() . ' (' . $catalogue->getTargetLang() . ')</strong></h2>'; echo input_tag("{$trans_unit_string}[target]", ${$trans_unit_string}->getTarget(), array('style' => 'width: 480px')); echo checkbox_tag("{$trans_unit_string}[translated]", 1, ${$trans_unit_string}->getTranslated() == 1 ? 1 : 0); echo __("Translated"); echo '<br/>'; echo checkbox_tag("{$trans_unit_string}[default]", 1, ''); echo __("Set translation to source string"); /* Ana: 14-02-09 No se necesita. echo '<br/>'; echo '<br/>'; echo __("Comment");