Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15786 Rev 15787
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'  >= '2023-03-01') and ('added_on' <= '2023-05-11'));
 129 
            $select->where(('added_on'  >= '09/01/2023') and ('added_on' <= '10/01/2023'));
Línea 130... Línea 130...
130 
 
 130 
 
131 
 
 131 
 
132 
            if ($search) {
 132 
            if ($search) {