Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15737 Rev 15738
Línea 108... Línea 108...
108 
 
 108 
 
109 
            foreach ($contactLogMappers as $contactLogMapper) {
 109 
            foreach ($contactLogMappers as $contactLogMapper) {
110 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 110 
                $queryMapper = QueryMapper::getInstance($this->adapter);
111 
                $sql = $queryMapper->getSql();
 111 
                $sql = $queryMapper->getSql();
112 
                $select = $sql->select();
 112 
                $select = $sql->select();
113 
                $select->columns(['user_id']);
 113 
                $select->columns(['user_id', 'activity']);
114 
                $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE]);
 114 
                $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE]);
115 
                $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
 115 
                $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
116 
                $select->join(['tb3' => CompanyMapper::_TABLE], 'tb1.company_id = tb3.id', ['name']);
 116 
                $select->join(['tb3' => CompanyMapper::_TABLE], 'tb1.company_id = tb3.id', ['name']);