| Línea 111... |
Línea 111... |
| 111 |
|
111 |
|
| 112 |
//Quede aqui en el mapper
|
112 |
//Quede aqui en el mapper
|
| 113 |
$discoveryContactLogMapper = DiscoveryContactLogMapper::getInstance($this->adapter);
|
113 |
$discoveryContactLogMapper = DiscoveryContactLogMapper::getInstance($this->adapter);
|
| Línea -... |
Línea 114... |
| - |
|
114 |
$contactLogMappers = $discoveryContactLogMapper->fetchAll();
|
| - |
|
115 |
|
| - |
|
116 |
$startDate = '2023-03-01';
|
| - |
|
117 |
$endDate = '2023-03-19';
|
| - |
|
118 |
|
| - |
|
119 |
$dtStartDate = \DateTime::createFromFormat('Y-n-d', $startDate);
|
| 114 |
$contactLogMappers = $discoveryContactLogMapper->fetchAll();
|
120 |
$dtEndDate = \DateTime::createFromFormat('Y-n-d', $endDate);
|
| 115 |
|
121 |
|
| 116 |
$queryMapper = QueryMapper::getInstance($this->adapter);
|
122 |
$queryMapper = QueryMapper::getInstance($this->adapter);
|
| 117 |
$sql = $queryMapper->getSql();
|
123 |
$sql = $queryMapper->getSql();
|
| 118 |
$select = $sql->select();
|
124 |
$select = $sql->select();
|
| 119 |
$select->columns(['user_id', 'activity', 'details', 'added_on']);
|
125 |
$select->columns(['user_id', 'activity', 'details', 'added_on']);
|
| 120 |
$select->from(['tb1' => DiscoveryContactLogMapper::_TABLE], ['activity', 'details', 'added_on']);
|
126 |
$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']);
|
127 |
$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']);
|
- |
|
| Línea 123... |
Línea 128... |
| 123 |
$select->where(date('added_on', '%Y/%m/%d') > date('2023/01/09', '%d/%m/%Y'));
|
128 |
$select->join(['tb3' => CompanyMapper::_TABLE], 'tb1.company_id = tb3.id', ['name']);
|
| 124 |
$select->and(date('added_on', '%Y/%m/%d') > date('2023/05/13', '%d/%m/%Y'));
|
129 |
$select->where(('added_on' >= '2018-05-28') and ('added_on' <= '2018-06-05'));
|
| 125 |
|
130 |
|