public function queryMethods(QueryBuilder $builder)
{
$script = '';
$queryClassName = $builder->getStubQueryBuilder()->getClassname();
$createColumnConstant = $this->getColumnConstant('create_column', $builder);
if ($this->withUpdatedAt()) {
$updateColumnConstant = $this->getColumnConstant('update_column', $builder);
$script .= "\n/**\n * Filter by the latest updated\n *\n * @param int \$nbDays Maximum age of the latest update in days\n *\n * @return {$queryClassName} The current query, for fluid interface\n */\npublic function recentlyUpdated(\$nbDays = 7)\n{\n return \$this->addUsingAlias({$updateColumnConstant}, time() - \$nbDays * 24 * 60 * 60, Criteria::GREATER_EQUAL);\n}\n\n/**\n * Order by update date desc\n *\n * @return {$queryClassName} The current query, for fluid interface\n */\npublic function lastUpdatedFirst()\n{\n return \$this->addDescendingOrderByColumn({$updateColumnConstant});\n}\n\n/**\n * Order by update date asc\n *\n * @return {$queryClassName} The current query, for fluid interface\n */\npublic function firstUpdatedFirst()\n{\n return \$this->addAscendingOrderByColumn({$updateColumnConstant});\n}\n";
}
$script .= "\n/**\n * Filter by the latest created\n *\n * @param int \$nbDays Maximum age of in days\n *\n * @return {$queryClassName} The current query, for fluid interface\n */\npublic function recentlyCreated(\$nbDays = 7)\n{\n return \$this->addUsingAlias({$createColumnConstant}, time() - \$nbDays * 24 * 60 * 60, Criteria::GREATER_EQUAL);\n}\n\n/**\n * Order by create date desc\n *\n * @return {$queryClassName} The current query, for fluid interface\n */\npublic function lastCreatedFirst()\n{\n return \$this->addDescendingOrderByColumn({$createColumnConstant});\n}\n\n/**\n * Order by create date asc\n *\n * @return {$queryClassName} The current query, for fluid interface\n */\npublic function firstCreatedFirst()\n{\n return \$this->addAscendingOrderByColumn({$createColumnConstant});\n}";
return $script;
}
public function queryMethods(QueryBuilder $builder)
{
$foreignKey = $this->getI18nTable()->getBehavior('symfony_i18n_translation')->getForeignKey();
$join = in_array($this->getBuildProperty('propel.useLeftJoinsInDoJoinMethods'), array(true, null), true) ? 'LEFT' : 'INNER';
$localeColumn = $this->getI18nTable()->getBehavior('symfony_i18n_translation')->getCultureColumn()->getPhpName();
$queryClass = $builder->getStubQueryBuilder()->getClassname();
$i18nRelationName = $builder->getRefFKPhpNameAffix($foreignKey);
return <<<EOF
/**
* Adds a JOIN clause to the query using the i18n relation
*
* @param string \$culture Locale to use for the join condition, e.g. 'fr_FR'
* @param string \$relationAlias optional alias for the relation
* @param string \$joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.
*
* @return {$queryClass} The current query, for fluid interface
*/
public function joinI18n(\$culture = null, \$relationAlias = null, \$joinType = Criteria::{$join}_JOIN)
{
if (null === \$culture)
{
\$culture = sfPropel::getDefaultCulture();
}
\$relationName = \$relationAlias ? \$relationAlias : '{$i18nRelationName}';
return \$this
->join{$i18nRelationName}(\$relationAlias, \$joinType)
->addJoinCondition(\$relationName, \$relationName . '.{$localeColumn} = ?', \$culture);
}
/**
* Adds a JOIN clause to the query and hydrates the related I18n object.
* Shortcut for \$c->joinI18n(\$culture)->with()
*
* @param string \$culture Locale to use for the join condition, e.g. 'fr_FR'
* @param string \$joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.
*
* @return {$queryClass} The current query, for fluid interface
*/
public function joinWithI18n(\$culture = null, \$joinType = Criteria::{$join}_JOIN)
{
\$this
->joinI18n(\$culture, null, \$joinType)
->with('{$i18nRelationName}');
\$this->with['{$i18nRelationName}']->setIsWithOneToMany(false);
return \$this;
}
/**
* Use the I18n relation query object
*
* @see useQuery()
*
* @param string \$culture Locale to use for the join condition, e.g. 'fr_FR'
* @param string \$relationAlias optional alias for the relation
* @param string \$joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.
*
* @return {$i18nRelationName}Query A secondary query class using the current class as primary query
*/
public function useI18nQuery(\$culture = null, \$relationAlias = null, \$joinType = Criteria::{$join}_JOIN)
{
return \$this
->joinI18n(\$culture, \$relationAlias, \$joinType)
->useQuery(\$relationAlias ? \$relationAlias : '{$i18nRelationName}', '{$i18nRelationName}Query');
}
EOF;
}
