protected function addStatutColumnQuery(Doctrine_Query $query, $field, $value)
{
if ($value == 0) {
$query->andWhere($query->getRootAlias() . '.statut <> ?', $value);
}
if ($value != 0) {
$query->andWhere($query->getRootAlias() . '.statut = ?', $value);
}
}
public function addRangeQuery(Doctrine_Query $query, $field, $values)
{
$fieldName = $this->getFieldName($field);
if ($values['from']) {
$query->andWhere(sprintf('%s.%s >= ?', $query->getRootAlias(), $fieldName), $values['from']);
}
if ($values['to']) {
$query->andWhere(sprintf('%s.%s <= ?', $query->getRootAlias(), $fieldName), $values['to']);
}
}
public function retrieveFolderList(Doctrine_Query $q)
{
$alias = $q->getRootAlias();
$q->leftJoin($alias . '.Assets a');
$q->orderBy($alias . '.lft');
return $q;
}
public function listPeriodeFiliereRegion(Doctrine_Query $q)
{
$rootAlias = $q->getRootAlias();
$q->leftJoin($rootAlias . '.CopisimFiliere c');
$q->leftJoin($rootAlias . '.CopisimRegion d');
return $q;
}
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();
}
/**
* 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 addCallerIdColumnQuery(Doctrine_Query $query, $field, $values)
{
if ($values != "") {
$alias = $query->getRootAlias();
$query->andWhere($alias . '.id != ?', $values);
}
return $query;
}
public function addVisiteurIdColumnQuery(Doctrine_Query $query, $field, $value)
{
//Pour le xxxx tu peux utiliser $query->getRootAlias() pour récupérer l'alias racine de ta requete
if ($value['text']) {
$query->leftjoin($query->getRootAlias() . ".Visiteur v");
$query->andWhere('v.pseudo_son like ?', "%" . $value['text'] . "%");
}
}
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;
}
public function getAdminQuery(Doctrine_Query $q)
{
$ra = $q->getRootAlias($q);
if(vjComment::isGuardBindEnabled())
{
$q->leftJoin($ra . '.User u');
}
return $q;
}
public function addCoachesListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.ClassPerCoach ClassPerCoach')->andWhereIn('ClassPerCoach.coach_id', $values);
}
public function addChannelsListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.ChannelProgram ChannelProgram')->andWhereIn('ChannelProgram.channel_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() . '.sfGuardUserPermission sfGuardUserPermission')->andWhereIn('sfGuardUserPermission.permission_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 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 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 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 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 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 addOrganizationListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.OrganizationPrincipal OrganizationPrincipal')->andWhereIn('OrganizationPrincipal.organization_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 addBitstreamsListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.Bundle2bitstream Bundle2bitstream')->andWhereIn('Bundle2bitstream.bitstream_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 addMenuListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.Itemsemana Itemsemana')->andWhereIn('Itemsemana.menu_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 addGroupsListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.GroupPermission GroupPermission')->andWhereIn('GroupPermission.group_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 addUsersListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.SiteUser SiteUser')->andWhereIn('SiteUser.user_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 addSubTracksListColumnQuery(Doctrine_Query $query, $field, $values)
{
if (!is_array($values)) {
$values = array($values);
}
if (!count($values)) {
return;
}
$query->leftJoin($query->getRootAlias() . '.ChapterSubTrack ChapterSubTrack')->andWhereIn('ChapterSubTrack.sub_track_id', $values);
}
