| Línea 106... |
Línea 106... |
| 106 |
foreach ($records as $record) {
|
106 |
foreach ($records as $record) {
|
| 107 |
$queryMapper = QueryMapper::getInstance($this->adapter);
|
107 |
$queryMapper = QueryMapper::getInstance($this->adapter);
|
| 108 |
$sql = $queryMapper->getSql();
|
108 |
$sql = $queryMapper->getSql();
|
| 109 |
$select = $sql->select();
|
109 |
$select = $sql->select();
|
| 110 |
$select->columns(['user_id']);
|
110 |
$select->columns(['user_id']);
|
| 111 |
// $select->from(['tb1' => DiscoveryContactMapper::_TABLE]);
|
111 |
$select->from(['tb1' => DiscoveryContactLogMapper::_TABLE]);
|
| 112 |
// $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
|
112 |
// $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
|
| 113 |
// $select->where->equalTo('tb1.company_id', $record->company_id);
|
113 |
// $select->where->equalTo('tb1.company_id', $record->company_id);
|
| 114 |
// $select->where->equalTo('tb1.topic_id', $record->topic_id);
|
114 |
// $select->where->equalTo('tb1.topic_id', $record->topic_id);
|
| 115 |
// $select->where->equalTo('tb1.capsule_id', $record->id);
|
115 |
// $select->where->equalTo('tb1.capsule_id', $record->id);
|
| 116 |
// $select->where->equalTo('tb2.status', User::STATUS_ACTIVE);
|
116 |
// $select->where->equalTo('tb2.status', User::STATUS_ACTIVE);
|