| 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(str_to_date(added_on, '%Y/%m/%d') > str_to_date('2023/01/09', '%d/%m/%Y'));
|
| - |
|
124 |
$select->and(str_to_date(added_on, '%Y/%m/%d') > str_to_date('2023/05/13', '%d/%m/%Y'));
|
| - |
|
125 |
|
| Línea 123... |
Línea 126... |
| 123 |
|
126 |
|
| 124 |
if ($search) {
|
127 |
if ($search) {
|
| 125 |
$select->where->nest()
|
128 |
$select->where->nest()
|
| 126 |
->like('first_name', '%' . $search . '%')
|
129 |
->like('first_name', '%' . $search . '%')
|