Línea 110... |
Línea 110... |
110 |
|
110 |
|
Línea 111... |
Línea 111... |
111 |
$queryMapper = QueryMapper::getInstance($this->adapter);
|
111 |
$queryMapper = QueryMapper::getInstance($this->adapter);
|
112 |
|
112 |
|
113 |
$select = $queryMapper->getSql()->select();
|
113 |
$select = $queryMapper->getSql()->select();
|
114 |
$select->columns(['uuid', 'name', 'description', 'text', 'language']);
|
114 |
$select->columns(['uuid', 'name', 'description', 'text', 'language']);
|
115 |
$select->from(['f' => CompanySelfEvaluationFormMapper::_TABLE]);
|
115 |
$select->from(['f' => CompanySelfEvaluationFormMapper::_TABLE])->setIntegrityCheck(false);
|
116 |
$select->join(['fu' => CompanySelfEvaluationFormUserMapper::_TABLE], 'f.id = fu.form_id', []);
|
116 |
$select->join(['fu' => CompanySelfEvaluationFormUserMapper::_TABLE], 'f.id = fu.form_id', []);
|
117 |
$select->join(['t' => CompanySelfEvaluationTestMapper::_TABLE], 'fu.form_id = t.form_id AND fu.user_id = t.user_id', ['status','uuid'], Select::JOIN_LEFT_OUTER);
|
117 |
$select->join(['t' => CompanySelfEvaluationTestMapper::_TABLE], 'fu.form_id = t.form_id AND fu.user_id = t.user_id', ['status','uuid'], Select::JOIN_LEFT_OUTER);
|