Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 2021 Rev 2022
Línea 77... Línea 77...
77 
    }
 77 
    }
78 
    public function fetchAllDataTableInnerJoinMember($search, $page = 1, $records_per_page = 10, $order_field= 'title', $order_direction = 'ASC', $user_id)
 78 
    public function fetchAllDataTableInnerJoinMember($search, $page = 1, $records_per_page = 10, $order_field= 'title', $order_direction = 'ASC', $user_id)
79 
    {
 79 
    {
80 
        $prototype = new HighPerformanceTeamsGroups();
 80 
        $prototype = new HighPerformanceTeamsGroups();
81 
        $select = $this->sql->select();
 81 
        $select = $this->sql->select();
82 
        $select->from(['gm' => self::_TABLE]);
 82 
        $select->from(['g' => self::_TABLE]);
83 
        $select->join(['g' => 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_DELETE);
 85 
        $select->where->notEqualTo('gm.status', HighPerformanceTeamsGroupsMembers::STATUS_DELETE);
Línea 86... Línea 86...
86
86