Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 2024 Rev 2025
Línea 78... Línea 78...
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' => HighPerformanceTeamsGroupsMembersMapper::_TABLE]);
 82 
        $select->from(['gm' => HighPerformanceTeamsGroupsMembersMapper::_TABLE]);
83 
        $select->join(['g' => self::_TABLE], ' g.id =gm.group_id', []);
 83 
        $select->join(['g' => self::_TABLE], ' g.id = gm.group_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 
 
87 
        if($search) {
 87 
        if($search) {