Línea 14... |
Línea 14... |
14 |
use LeadersLinked\Library\Functions;
|
14 |
use LeadersLinked\Library\Functions;
|
15 |
use LeadersLinked\Mapper\CompanySelfEvaluationFormMapper;
|
15 |
use LeadersLinked\Mapper\CompanySelfEvaluationFormMapper;
|
16 |
use LeadersLinked\Mapper\CompanySelfEvaluationTestMapper;
|
16 |
use LeadersLinked\Mapper\CompanySelfEvaluationTestMapper;
|
17 |
use LeadersLinked\Form\CompanySelfEvaluationFormForm;
|
17 |
use LeadersLinked\Form\CompanySelfEvaluationFormForm;
|
18 |
use LeadersLinked\Model\CompanySelfEvaluationForm;
|
18 |
use LeadersLinked\Model\CompanySelfEvaluationForm;
|
- |
|
19 |
use LeadersLinked\Model\UserMapper;
|
19 |
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
|
20 |
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
|
20 |
use LeadersLinked\Mapper\CompanySelfEvaluationFormUserMapper;
|
21 |
use LeadersLinked\Mapper\CompanySelfEvaluationFormUserMapper;
|
Línea 21... |
Línea 22... |
21 |
|
22 |
|
Línea 93... |
Línea 94... |
93 |
$queryMapper = QueryMapper::getInstance($this->adapter);
|
94 |
$queryMapper = QueryMapper::getInstance($this->adapter);
|
Línea 94... |
Línea 95... |
94 |
|
95 |
|
95 |
$select = $queryMapper->getSql()->select();
|
96 |
$select = $queryMapper->getSql()->select();
|
96 |
$select->columns(['uuid', 'content','status','user_id','company_id']);
|
97 |
$select->columns(['uuid', 'content','status','user_id','company_id']);
|
97 |
$select->from(['test' => CompanySelfEvaluationTestMapper::_TABLE]);
|
98 |
$select->from(['test' => CompanySelfEvaluationTestMapper::_TABLE]);
|
- |
|
99 |
$select->join(['form' => CompanySelfEvaluationFormMapper::_TABLE], 'test.form_id = form.id', ['name','language']);
|
- |
|
100 |
$select->join(['user' => UserMapper::_TABLE], 'test.user_id = user.id', ['first_name','last_name']);
|
98 |
$select->join(['form' => CompanySelfEvaluationFormMapper::_TABLE], 'test.form_id = form.id', ['language']);
|
101 |
|
Línea 99... |
Línea 102... |
99 |
$select->where->equalTo('form.status', CompanySelfEvaluationForm::STATUS_ACTIVE);
|
102 |
$select->where->equalTo('form.status', CompanySelfEvaluationForm::STATUS_ACTIVE);
|
100 |
|
103 |
|
101 |
if ($search) {
|
104 |
if ($search) {
|