Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15785 Rev 15786
Línea 124... Línea 124...
124 
            $select = $sql->select();
 124 
            $select = $sql->select();
125 
            $select->columns(['user_id', 'activity', 'details', 'added_on']);
 125 
            $select->columns(['user_id', 'activity', 'details', 'added_on']);
126 
            $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE], ['activity', 'details', 'added_on']);
 126 
            $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE], ['activity', 'details', 'added_on']);
127 
            $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
 127 
            $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
128 
            $select->join(['tb3' => CompanyMapper::_TABLE], 'tb1.company_id = tb3.id', ['name']);
 128 
            $select->join(['tb3' => CompanyMapper::_TABLE], 'tb1.company_id = tb3.id', ['name']);
129 
            $select->where(('added_on'  >= '2018-05-28') and ('added_on' <= '2018-06-05'));
 129 
            $select->where(('added_on'  >= '2023-03-01') and ('added_on' <= '2023-05-11'));
Línea 130... Línea 130...
130 
 
 130 
 
131 
 
 131 
 
132 
            if ($search) {
 132 
            if ($search) {