Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15730 Rev 15731
Línea 109... Línea 109...
109 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 109 
                $queryMapper = QueryMapper::getInstance($this->adapter);
110 
                $sql = $queryMapper->getSql();
 110 
                $sql = $queryMapper->getSql();
111 
                $select = $sql->select();
 111 
                $select = $sql->select();
112 
                $select->columns(['user_id']);
 112 
                $select->columns(['user_id']);
113 
                $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE]);
 113 
                $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE]);
114 
                $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email', 'activity']);
 114 
                $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
115 
                $select->where->equalTo('tb1.company_id', $contactLogMapper->company_id);
 115 
                //$select->where->equalTo('tb1.company_id', $contactLogMapper->company_id);
Línea 116... Línea 116...
116 
 
 116 
 
117 
                if ($search) {
 117 
                if ($search) {
118 
                    $select->where->nest()
 118 
                    $select->where->nest()
119 
                        ->like('first_name', '%' . $search . '%')
 119 
                        ->like('first_name', '%' . $search . '%')