Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 2029 | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 2029 Rev 2030
Línea 80... Línea 80...
80 
        $prototype = new HighPerformanceTeamsGroups();
 80 
        $prototype = new HighPerformanceTeamsGroups();
81 
        $select = $this->sql->select();
 81 
        $select = $this->sql->select();
82 
        $select->from(['g' => self::_TABLE]);
 82 
        $select->from(['g' => self::_TABLE]);
83 
        $select->join(['gm' => HighPerformanceTeamsGroupsMembersMapper::_TABLE], 'gm.group_id = g.id', []);
 83 
        $select->join(['gm' => HighPerformanceTeamsGroupsMembersMapper::_TABLE], 'gm.group_id = g.id', []);
84 
        $select->where->equalTo('gm.user_id', $user_id);
 84 
        $select->where->equalTo('gm.user_id', $user_id);
- 
 
 85 
        $select->where->notEqualTo('gm.status', HighPerformanceTeamsGroupsMembers::STATUS_CANCELLED);
- 
 
 86 
        $select->where->notEqualTo('gm.status', HighPerformanceTeamsGroupsMembers::STATUS_REJECTED);
- 
 
 87 
        $select->where->notEqualTo('gm.status', HighPerformanceTeamsGroupsMembers::STATUS_INVITED);
Línea 85... Línea 88...
85
88
86 
        if($search) {
 89 
        if($search) {
87 
            $select->where->like('title', '%' . $search . '%');
 90 
            $select->where->like('title', '%' . $search . '%');
88 
        }
 91 
        }