public function listPeriodeFiliereRegion(Doctrine_Query $q)
{
$rootAlias = $q->getRootAlias();
$q->leftJoin($rootAlias . '.CopisimFiliere c');
$q->leftJoin($rootAlias . '.CopisimRegion d');
return $q;
}
public function addProductTranslationJoin(Doctrine_Query $q, $lang = false)
{
if (!$lang) {
return $q->leftJoin($q->getRootAlias() . '.Translation trans');
} else {
return $q->leftJoin($q->getRootAlias() . '.Translation trans WITH trans.lang = ?', $lang);
}
}
public function retrieveAdminChargeList(Doctrine_Query $q)
{
$rootAlias = $q->getRootAlias();
$q->leftJoin($rootAlias . '.Category ct');
$q->leftJoin($rootAlias . '.Vehicle v');
$q->andWhere('v.is_archived = ?', false);
return $q;
}
function buildQuery(Doctrine_Query $query)
{
$query->leftJoin('swBlogPost.Translation');
$query->leftJoin('swBlogPost.swBlogPostTags t');
$query->leftJoin('t.Translation tt');
if (strlen($this->getValue('tag')) > 0) {
$query->addWhere('tt.name = ? and tt.lang = ?', array($this->getValue('tag'), sfContext::getInstance()->getUser()->getCulture()));
}
if (!is_null($this->getValue('published'))) {
$query->addWhere('swBlogPost.published = ?', $this->getValue('published'));
}
$query->orderBy('created_at DESC');
return $query;
}
public function filterByEditable(Doctrine_Query $q, $user_id = null)
{
if (is_null($user_id)) {
$user_id = sfContext::getInstance()->getUser()->getGuardUser()->getId();
if (sfContext::getInstance()->getUser()->hasCredential('admin')) {
return;
}
}
$rootAlias = $q->getRootAlias();
$q->leftJoin($rootAlias . '.Categories c');
$q->leftJoin('c.Users u');
$q->leftJoin($rootAlias . '.Editors e');
$q->addWhere('author_id = ? OR u.id = ? OR e.id = ?', array($user_id, $user_id, $user_id));
}
/**
* Set Doctrine Query.
*
* Set the Doctrine Query Object and expand configuration with it's information.
*
* @param Doctrine_Query $query Doctrine Query Object.
* @param array $filter Filter object to be processed to enrich the Query.
*
* @return void
*/
public function setDoctrineQuery(Doctrine_Query $query, $filter)
{
$this->resetColumns();
$this->_doctrineQuery = $query;
$tables = $this->_getTableInformation();
$aliasMap = $this->_doctrineQuery->getTableAliasMap();
$tables = $this->_enrichTablesWithAlias($tables, $aliasMap);
// FIXME assumes any dynamic relation with first table found on FROM
$from = $this->_doctrineQuery->getDQLPart('from');
$main = explode(' ', $from[0]);
$main = $main[1];
// adds the external relation aliases
// depending on the filter object to process
$joins = array();
$this->_getFilterRelations($joins, $filter);
// stores the tables => dynaalias
$t = array();
$a = 'dynajoin1';
foreach ($joins as $join) {
$alias = substr($join, 0, strpos($join, ':'));
$t[$alias] = $a;
// add the dynamic left join
$this->_doctrineQuery->leftJoin("{$main}.{$alias} {$a}");
$a++;
}
$this->_setColumnsFromDoctrineTables($tables, $t);
}
public function retrieveAsso(Doctrine_Query $q)
{
$alias = $q->getRootAlias();
$q->select("{$alias}.name, {$alias}.login, {$alias}.description, {$alias}.logo, {$alias}.salle, {$alias}.phone, {$alias}.facebook, p.id, p.asso_id, p.couleur");
$q->leftJoin("{$alias}.Pole p");
return $q->fetchOne();
}
public function retrieveFolderList(Doctrine_Query $q)
{
$alias = $q->getRootAlias();
$q->leftJoin($alias . '.Assets a');
$q->orderBy($alias . '.lft');
return $q;
}
/**
* Query for uuser list
* @param Doctrine_Query $q
* @return Doctrine_Query
*/
public function retrieveBackendUuserList(Doctrine_Query $q)
{
$rootAlias = $q->getRootAlias();
$q->leftJoin($rootAlias . '.BalanceUser bu');
$q->andWhere($rootAlias . '.utype=?', 'uuser');
$q->andWhere($rootAlias . '.password IS NOT NULL');
return $q;
}
public function addCodeColumnQuery(Doctrine_Query $query, $field, $values)
{
if ($values != "") {
$alias = $query->getRootAlias();
$conn_MGR = Doctrine_Manager::connection();
$query->leftJoin($alias . '.SpecimensCodes cod')->andWhere("cod.referenced_relation = ?", array('specimens'))->andWhere("cod.record_id = {$alias}.id")->andWhere("cod.full_code_indexed = fullToIndex(" . $conn_MGR->quote($values, 'string') . ") ");
}
return $query;
}
public function addKernbegripListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin('r.expertKernbegrip expertKernbegrip')->andWhereIn('expertKernbegrip.kernbegrip_id', $values);
}
public function addAccepterListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.Friend Friend')->andWhereIn('Friend.accepter_id', $values);
}
public function addTrackListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.userPlaylist userPlaylist')->andWhereIn('userPlaylist.track_id', $values);
}
public function addVehiclesListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.ReportVehicle ReportVehicle')->andWhereIn('ReportVehicle.vehicle_id', $values);
}
public function addProceduresListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin('r.UserProcedure UserProcedure')->andWhereIn('UserProcedure.procedure_id', $values);
}
public function addSfGuardPermissionListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.NjPermissionMenuItemRouting NjPermissionMenuItemRouting')->andWhereIn('NjPermissionMenuItemRouting.sf_guard_permission_id', $values);
}
public function addTagsListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin('r.DmTestDomainDmTag DmTestDomainDmTag')->andWhereIn('DmTestDomainDmTag.dm_tag_id', $values);
}
public function addCategoriesListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin('r.DpCategory DpCategory')->andWhereIn('DpCategory.category_id', $values);
}
public function addUsersListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin('r.sfGuardUserPermission sfGuardUserPermission')->andWhereIn('sfGuardUserPermission.user_id', $values);
}
public function addApplicationsListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.sfOauthServerDeveloper sfOauthServerDeveloper')->andWhereIn('sfOauthServerDeveloper.consumer_id', $values);
}
public function addPreferredTransportersListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin('r.CustomerPreferredTransporter CustomerPreferredTransporter')->andWhereIn('CustomerPreferredTransporter.transporter_id', $values);
}
public function addSongsListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.ArtistSong ArtistSong')->andWhereIn('ArtistSong.song_id', $values);
}
public function addPermissionsListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.sfGuardGroupPermission sfGuardGroupPermission')->andWhereIn('sfGuardGroupPermission.permission_id', $values);
}
public function addAssetListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.CategoryAsset CategoryAsset')->andWhereIn('CategoryAsset.asset_id', $values);
}
public function addHintsListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.HintComment HintComment')->andWhereIn('HintComment.hint_id', $values);
}
public function addItemsListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.Communities2item Communities2item')->andWhereIn('Communities2item.item_id', $values);
}
public function addGroupsListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin('r.DmRecordPermissionGroup DmRecordPermissionGroup')->andWhereIn('DmRecordPermissionGroup.dm_group_id', $values);
}
public function addCategoriesListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.aMediaItemToCategory aMediaItemToCategory')->andWhereIn('aMediaItemToCategory.category_id', $values);
}
public function addCountriesListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.CurrencyCountry CurrencyCountry')->andWhereIn('CurrencyCountry.country_id', $values);
}
public function addPermissionsListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin('r.DmGroupPermission DmGroupPermission')->andWhereIn('DmGroupPermission.dm_permission_id', $values);
}
