Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15783 Rev 15784
Línea 118... Línea 118...
118 
            $select = $sql->select();
 118 
            $select = $sql->select();
119 
            $select->columns(['user_id', 'activity', 'details', 'added_on']);
 119 
            $select->columns(['user_id', 'activity', 'details', 'added_on']);
120 
            $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE], ['activity', 'details', 'added_on']);
 120 
            $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE], ['activity', 'details', 'added_on']);
121 
            $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
 121 
            $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
122 
            $select->join(['tb3' => CompanyMapper::_TABLE], 'tb1.company_id = tb3.id', ['name']);
 122 
            $select->join(['tb3' => CompanyMapper::_TABLE], 'tb1.company_id = tb3.id', ['name']);
123 
            $select->where(date(added_on, '%Y/%m/%d') > date('2023/01/09', '%d/%m/%Y'));
 123 
            $select->where(date('added_on', '%Y/%m/%d') > date('2023/01/09', '%d/%m/%Y'));
124 
            $select->and(date(added_on, '%Y/%m/%d') > date('2023/05/13', '%d/%m/%Y'));
 124 
            $select->and(date('added_on', '%Y/%m/%d') > date('2023/05/13', '%d/%m/%Y'));
Línea 125... Línea 125...
125 
 
 125 
 
126 
 
 126 
 
127 
            if ($search) {
 127 
            if ($search) {