Proyectos de Subversion LeadersLinked - Backend

Rev

Rev 279 | Rev 281 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 279 Rev 280
Línea 9... Línea 9...
9 
use Laminas\Mvc\Controller\AbstractActionController;
 9 
use Laminas\Mvc\Controller\AbstractActionController;
10 
use Laminas\Log\LoggerInterface;
 10 
use Laminas\Log\LoggerInterface;
11 
use Laminas\View\Model\ViewModel;
 11 
use Laminas\View\Model\ViewModel;
12 
use Laminas\View\Model\JsonModel;
 12 
use Laminas\View\Model\JsonModel;
13 
use LeadersLinked\Mapper\QueryMapper;
 13 
use LeadersLinked\Mapper\QueryMapper;
- 
 
 14 
use Laminas\Db\Sql\Select;
14 
use LeadersLinked\Library\Functions;
 15 
use LeadersLinked\Library\Functions;
15 
use LeadersLinked\Mapper\CompanySelfEvaluationFormMapper;
 16 
use LeadersLinked\Mapper\CompanySelfEvaluationFormMapper;
16 
use LeadersLinked\Mapper\CompanySelfEvaluationTestMapper;
 17 
use LeadersLinked\Mapper\CompanySelfEvaluationTestMapper;
17 
use LeadersLinked\Form\CompanySelfEvaluationFormForm;
 18 
use LeadersLinked\Form\CompanySelfEvaluationFormForm;
18 
use LeadersLinked\Model\CompanySelfEvaluationForm;
 19 
use LeadersLinked\Model\CompanySelfEvaluationForm;
Línea 95... Línea 96...
95 
 
 96 
 
96 
                $select = $queryMapper->getSql()->select();
 97 
                $select = $queryMapper->getSql()->select();
97 
                $select->columns(['uuid', 'content','status']);
 98 
                $select->columns(['uuid', 'content','status']);
98 
                $select->from(['test' => CompanySelfEvaluationTestMapper::_TABLE]);
 99 
                $select->from(['test' => CompanySelfEvaluationTestMapper::_TABLE]);
99 
                $select->join(['form' => CompanySelfEvaluationFormMapper::_TABLE], 'test.form_id = form.id', ['name','language']);
 - 
 
- 
 
 100 
                $select->join(['form' => CompanySelfEvaluationFormMapper::_TABLE], 'test.form_id = form.id', ['name','language']);
Línea 100... Línea 101...
100
101 
                $select->join(['user' => UserMapper::_TABLE], 'test.user_id = user.id', ['first_name','last_name'], Select::JOIN_LEFT_OUTER);
Línea 101... Línea 102...
101 
 
 102 
 
102 
                $select->where->equalTo('form.status', CompanySelfEvaluationForm::STATUS_ACTIVE);
 103 
                $select->where->equalTo('form.status', CompanySelfEvaluationForm::STATUS_ACTIVE);