Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 5533 | Rev 5535 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 5533 Rev 5534
Línea 1093... Línea 1093...
1093
                        }
1093
                        }
1094
                    }
1094
                    }
1095
                }
1095
                }
Línea 1096... Línea 1096...
1096
 
1096
 
1097
 
1097
 
1098
                // $queryMapper = QueryMapper::getInstance($this->adapter);
1098
                $queryMapper = QueryMapper::getInstance($this->adapter);
1099
                // $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
1099
                $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
1100
                // $select->columns(['id']);
1100
                $select->columns(['id']);
1101
                // $select->where->equalTo('network_id', $currentUser->network_id);
1101
                $select->where->equalTo('network_id', $currentUser->network_id);
1102
                // $select->where->equalTo('status', Feed::STATUS_PUBLISHED)
1102
                $select->where->equalTo('status', Feed::STATUS_PUBLISHED)
1103
                //     ->AND->NEST
1103
                    ->AND->NEST
1104
                //     ->OR->NEST->equalTo('user_id', $id)->and->equalTo('type', Feed::TYPE_UPDATE)->UNNEST
1104
                    ->OR->NEST->equalTo('user_id', $id)->and->equalTo('type', Feed::TYPE_UPDATE)->UNNEST
1105
                //     ->OR->NEST->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_PUBLIC)->UNNEST
1105
                    ->OR->NEST->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_PUBLIC)->UNNEST
1106
                //     ->OR->NEST->in('user_id', $connectionIds)->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_CONNECTIONS)->UNNEST
1106
                    ->OR->NEST->in('user_id', $connectionIds)->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_CONNECTIONS)->UNNEST
1107
                //     ->OR->NEST->or->in('company_id', $companyIds)->and->equalTo('type', Feed::TYPE_COMPANY)->UNNEST
1107
                    //->OR->NEST->or->in('company_id', $companyIds)->and->equalTo('type', Feed::TYPE_COMPANY)->UNNEST
1108
                //     ->UNNEST;
1108
                    ->UNNEST;
1109
                // $select->order('added_on desc');
1109
                $select->order('added_on desc');
1110
            }
1110
            }
1111
            if ($type == 'company') {
1111
            if ($type == 'company') {