| Línea 186... |
Línea 186... |
| 186 |
$select->join(['c' => SurveyCampaignMapper::_TABLE], 't.campaign_id = c.id', ['name', 'start_date', 'end_date']);
|
186 |
$select->join(['c' => SurveyCampaignMapper::_TABLE], 't.campaign_id = c.id', ['name', 'start_date', 'end_date']);
|
| 187 |
$select->where->equalTo('c.type', SurveyCampaign::TYPE_ORGANIZATIONAL_CLIMATE);
|
187 |
$select->where->equalTo('c.type', SurveyCampaign::TYPE_ORGANIZATIONAL_CLIMATE);
|
| 188 |
$select->where->equalTo('t.user_id', $user_id);
|
188 |
$select->where->equalTo('t.user_id', $user_id);
|
| Línea 189... |
Línea 189... |
| 189 |
|
189 |
|
| 190 |
if($search) {
|
190 |
if($search) {
|
| - |
|
191 |
//$select->where->like('c.name', '%' . $search . '%');
|
| - |
|
192 |
|
| - |
|
193 |
$select->where->nest()
|
| - |
|
194 |
->like('c.name', '%' . $search . '%')
|
| - |
|
195 |
->or->like('t.uuid', '%' . $search . '%')
|
| 191 |
$select->where->like('c.name', '%' . $search . '%');
|
196 |
->unnest();
|
| 192 |
}
|
197 |
}
|
| Línea 193... |
Línea 198... |
| 193 |
$select->order($order_field . ' ' . $order_direction);
|
198 |
$select->order($order_field . ' ' . $order_direction);
|
| Línea 222... |
Línea 227... |
| 222 |
$select->join(['c' => SurveyCampaignMapper::_TABLE], 't.campaign_id = c.id', ['name', 'start_date', 'end_date']);
|
227 |
$select->join(['c' => SurveyCampaignMapper::_TABLE], 't.campaign_id = c.id', ['name', 'start_date', 'end_date']);
|
| 223 |
$select->where->equalTo('c.type', SurveyCampaign::TYPE_NORMAL);
|
228 |
$select->where->equalTo('c.type', SurveyCampaign::TYPE_NORMAL);
|
| 224 |
$select->where->equalTo('t.user_id', $user_id);
|
229 |
$select->where->equalTo('t.user_id', $user_id);
|
| Línea 225... |
Línea 230... |
| 225 |
|
230 |
|
| 226 |
if($search) {
|
231 |
if($search) {
|
| - |
|
232 |
//$select->where->like('c.name', '%' . $search . '%');
|
| - |
|
233 |
|
| - |
|
234 |
if($search) {
|
| - |
|
235 |
//$select->where->like('c.name', '%' . $search . '%');
|
| - |
|
236 |
|
| - |
|
237 |
$select->where->nest()
|
| - |
|
238 |
->like('c.name', '%' . $search . '%')
|
| - |
|
239 |
->or->like('t.uuid', '%' . $search . '%')
|
| - |
|
240 |
->unnest();
|
| 227 |
$select->where->like('c.name', '%' . $search . '%');
|
241 |
}
|
| 228 |
}
|
242 |
}
|
| Línea 229... |
Línea 243... |
| 229 |
$select->order($order_field . ' ' . $order_direction);
|
243 |
$select->order($order_field . ' ' . $order_direction);
|