Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 3639 Rev 3648
Línea 135... Línea 135...
135 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 135 
                $queryMapper = QueryMapper::getInstance($this->adapter);
Línea 136... Línea 136...
136
136
137 
                $select = $queryMapper->getSql()->select(UserMapper::_TABLE);
 137 
                $select = $queryMapper->getSql()->select(UserMapper::_TABLE);
138 
                $select->where->in('id', $user_ids);
138 
                $select->where->in('id', $user_ids);
- 
 
 139 
                $select->where->equalTo('status', User::STATUS_ACTIVE);
Línea 139... Línea 140...
139 
                $select->where->equalTo('status', User::STATUS_ACTIVE);
 140 
                $select->where->equalTo('network_id', $currentUser->network_id);
140
141
141 
                if($search) {
 142 
                if($search) {
142 
                    $select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
 143 
                    $select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
Línea 235... Línea 236...
235 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 236 
                $queryMapper = QueryMapper::getInstance($this->adapter);
Línea 236... Línea 237...
236
237
237 
                $select = $queryMapper->getSql()->select(UserMapper::_TABLE);
 238 
                $select = $queryMapper->getSql()->select(UserMapper::_TABLE);
238 
                $select->where->in('id', $user_ids);
 239 
                $select->where->in('id', $user_ids);
- 
 
 240 
                $select->where->equalTo('status', User::STATUS_ACTIVE);
Línea 239... Línea 241...
239 
                $select->where->equalTo('status', User::STATUS_ACTIVE);
 241 
                $select->where->equalTo('network_id', $currentUser->network_id);
240
242
241 
                if($search) {
 243 
                if($search) {
242 
                    $select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
 244 
                    $select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
Línea 317... Línea 319...
317
319
318 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 320 
                $queryMapper = QueryMapper::getInstance($this->adapter);
319 
                $select = $queryMapper->getSql()->select(UserMapper::_TABLE);
 321 
                $select = $queryMapper->getSql()->select(UserMapper::_TABLE);
320 
                $select->where->in('id', $user_ids);
 322 
                $select->where->in('id', $user_ids);
- 
 
 323 
                $select->where->equalTo('status', User::STATUS_ACTIVE);
Línea 321... Línea 324...
321 
                $select->where->equalTo('status', User::STATUS_ACTIVE);
 324 
                $select->where->equalTo('network_id', $currentUser->network_id);
322
325
323 
                if($search) {
 326 
                if($search) {
324 
                    $select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
 327 
                    $select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
Línea 375... Línea 378...
375
378
Línea 376... Línea 379...
376 
            $id = $this->params()->fromRoute('id');
 379 
            $id = $this->params()->fromRoute('id');
377
380
378 
            $id = $this->params()->fromRoute('id');
 381 
            $id = $this->params()->fromRoute('id');
Línea 379... Línea 382...
379 
            $userMapper = UserMapper::getInstance($this->adapter);
 382 
            $userMapper = UserMapper::getInstance($this->adapter);
380 
            $user = $userMapper->fetchOneByUuid($id);
 383 
            $user = $userMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
381
384
382 
            if(!$user) {
 385 
            if(!$user) {
Línea 441... Línea 444...
441 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
 444 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
442 
            $currentUser = $currentUserPlugin->getUser();
 445 
            $currentUser = $currentUserPlugin->getUser();
Línea 443... Línea 446...
443
446
444 
            $id = $this->params()->fromRoute('id');
 447 
            $id = $this->params()->fromRoute('id');
445 
            $userMapper = UserMapper::getInstance($this->adapter);
 448 
            $userMapper = UserMapper::getInstance($this->adapter);
Línea 446... Línea 449...
446 
            $user = $userMapper->fetchOneByUuid($id);
 449 
            $user = $userMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
Línea 447... Línea 450...
447
450
448 
            if($user) {
 451 
            if($user) {
Línea 548... Línea 551...
548 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
 551 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
549 
            $currentUser = $currentUserPlugin->getUser();
 552 
            $currentUser = $currentUserPlugin->getUser();
Línea 550... Línea 553...
550
553
551 
            $id = $this->params()->fromRoute('id');
 554 
            $id = $this->params()->fromRoute('id');
552 
            $userMapper = UserMapper::getInstance($this->adapter);
 555 
            $userMapper = UserMapper::getInstance($this->adapter);
Línea 553... Línea 556...
553 
            $user = $userMapper->fetchOneByUuid($id);
 556 
            $user = $userMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
Línea 554... Línea 557...
554
557
555 
            if($user) {
 558 
            if($user) {
Línea 611... Línea 614...
611 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
 614 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
612 
            $currentUser = $currentUserPlugin->getUser();
 615 
            $currentUser = $currentUserPlugin->getUser();
Línea 613... Línea 616...
613
616
Línea 614... Línea -...
614 
            $id = $this->params()->fromRoute('id');
 - 
 
- 
 
 617 
            $id = $this->params()->fromRoute('id');
615
618
616 
            $id = $this->params()->fromRoute('id');
 619
Línea 617... Línea 620...
617 
            $userMapper = UserMapper::getInstance($this->adapter);
 620 
            $userMapper = UserMapper::getInstance($this->adapter);
Línea 618... Línea 621...
618 
            $user = $userMapper->fetchOneByUuid($id);
 621 
            $user = $userMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
619
622
Línea 750... Línea 753...
750 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
 753 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
751 
            $currentUser = $currentUserPlugin->getUser();
 754 
            $currentUser = $currentUserPlugin->getUser();
Línea 752... Línea 755...
752
755
753 
            $id = $this->params()->fromRoute('id');
 756 
            $id = $this->params()->fromRoute('id');
754 
            $userMapper = UserMapper::getInstance($this->adapter);
 757 
            $userMapper = UserMapper::getInstance($this->adapter);
Línea 755... Línea 758...
755 
            $user = $userMapper->fetchOneByUuid($id);
 758 
            $user = $userMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
756
759
757 
            if(!$user) {
 760 
            if(!$user) {
758 
                return new JsonModel([
 761 
                return new JsonModel([
Línea 829... Línea 832...
829 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
 832 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
830 
            $currentUser = $currentUserPlugin->getUser();
 833 
            $currentUser = $currentUserPlugin->getUser();
Línea 831... Línea 834...
831
834
832 
            $id = $this->params()->fromRoute('id');
 835 
            $id = $this->params()->fromRoute('id');
833 
            $userMapper = UserMapper::getInstance($this->adapter);
 836 
            $userMapper = UserMapper::getInstance($this->adapter);
834 
            $user = $userMapper->fetchOneByUuid($id);
 837 
            $user = $userMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
835 
            if($user) {
 838 
            if($user) {
836 
                if($user->id == $currentUser->id || in_array($user->status, [User::STATUS_DELETED, User::STATUS_INACTIVE]) || $user->email_verified == User::EMAIL_VERIFIED_NO || $user->blocked == User::BLOCKED_YES) {
 839 
                if($user->id == $currentUser->id || in_array($user->status, [User::STATUS_DELETED, User::STATUS_INACTIVE]) || $user->email_verified == User::EMAIL_VERIFIED_NO || $user->blocked == User::BLOCKED_YES) {
837 
                    return new JsonModel([
 840 
                    return new JsonModel([
838 
                        'success' => true,
 841 
                        'success' => true,
Línea 886... Línea 889...
886 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
 889 
            $currentUserPlugin = $this->plugin('currentUserPlugin');
887 
            $currentUser = $currentUserPlugin->getUser();
 890 
            $currentUser = $currentUserPlugin->getUser();
Línea 888... Línea 891...
888
891
889 
            $id = $this->params()->fromRoute('id');
 892 
            $id = $this->params()->fromRoute('id');
890 
            $userMapper = UserMapper::getInstance($this->adapter);
 893 
            $userMapper = UserMapper::getInstance($this->adapter);
Línea 891... Línea 894...
891 
            $user = $userMapper->fetchOneByUuid($id);
 894 
            $user = $userMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
892
895
893 
            if($user) {
 896 
            if($user) {
894 
                if($user->id == $currentUser->id || in_array($user->status, [User::STATUS_DELETED, User::STATUS_INACTIVE]) || $user->email_verified == User::EMAIL_VERIFIED_NO || $user->blocked == User::BLOCKED_YES) {
 897 
                if($user->id == $currentUser->id || in_array($user->status, [User::STATUS_DELETED, User::STATUS_INACTIVE]) || $user->email_verified == User::EMAIL_VERIFIED_NO || $user->blocked == User::BLOCKED_YES) {
Línea 972... Línea 975...
972 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 975 
                $queryMapper = QueryMapper::getInstance($this->adapter);
Línea 973... Línea 976...
973
976
974 
                $select = $queryMapper->getSql()->select(UserMapper::_TABLE);
 977 
                $select = $queryMapper->getSql()->select(UserMapper::_TABLE);
975 
                $select->where->in('id', $user_ids);
 978 
                $select->where->in('id', $user_ids);
- 
 
 979 
                $select->where->equalTo('status', User::STATUS_ACTIVE);
Línea 976... Línea 980...
976 
                $select->where->equalTo('status', User::STATUS_ACTIVE);
 980 
                $select->where->equalTo('network_id', $currentUser->network_id);
977
981
978 
                if($search) {
 982 
                if($search) {
979 
                    $select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
 983 
                    $select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
Línea 1179... Línea 1183...
1179 
                $select->where->in('u.id', $other_users);
 1183 
                $select->where->in('u.id', $other_users);
1180 
                $select->where->notIn('u.id', $first_degree_connections_ids);
 1184 
                $select->where->notIn('u.id', $first_degree_connections_ids);
1181 
                $select->where->notEqualTo('u.id', $currentUser->id);
 1185 
                $select->where->notEqualTo('u.id', $currentUser->id);
1182 
                $select->where->equalTo('u.status', User::STATUS_ACTIVE);
 1186 
                $select->where->equalTo('u.status', User::STATUS_ACTIVE);
1183 
                $select->where->in('u.usertype_id', [UserType::ADMIN, UserType::USER]);
 1187 
                $select->where->in('u.usertype_id', [UserType::ADMIN, UserType::USER]);
- 
 
 1188 
                $select->where->equalTo('u.network_id', $currentUser->network_id);
Línea 1184... Línea 1189...
1184
1189
1185
1190