| Línea 102... |
Línea 102... |
| 102 |
$records = $discoveryContactMapper->fetchAll();
|
102 |
$records = $discoveryContactMapper->fetchAll();
|
| 103 |
$items = [];
|
103 |
$items = [];
|
| 104 |
//$records = $paginator->getCurrentItems();
|
104 |
//$records = $paginator->getCurrentItems();
|
| Línea 105... |
Línea 105... |
| 105 |
|
105 |
|
| 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' => DiscoveryContactMapper::_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);
|
| 117 |
// $select->order('first_name ASC, last_name ASC');
|
117 |
// $select->order('first_name ASC, last_name ASC');
|
| 118 |
return new JsonModel([
|
118 |
return new JsonModel([
|
| 119 |
'success' => true,
|
119 |
'success' => true,
|
| 120 |
'message' => $record->company_id
|
120 |
'message' => $select
|
| 121 |
]);
|
121 |
]);
|
| 122 |
}
|
122 |
}
|
| 123 |
// } else {
|
123 |
// } else {
|
| 124 |
// }
|
124 |
// }
|