Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 300 Rev 301
Línea 100... Línea 100...
100 
                $select->from(['test' => CompanySelfEvaluationTestMapper::_TABLE]);
 100 
                $select->from(['test' => CompanySelfEvaluationTestMapper::_TABLE]);
101 
                $select->join(['form' => CompanySelfEvaluationFormMapper::_TABLE], 'test.form_id = form.id', ['name','language']);
 101 
                $select->join(['form' => CompanySelfEvaluationFormMapper::_TABLE], 'test.form_id = form.id', ['name','language']);
102 
                $select->join(['user' => UserMapper::_TABLE], 'test.user_id = user.id', ['first_name','last_name'], Select::JOIN_LEFT_OUTER);
 102 
                $select->join(['user' => UserMapper::_TABLE], 'test.user_id = user.id', ['first_name','last_name'], Select::JOIN_LEFT_OUTER);
Línea 103... Línea 103...
103 
 
 103 
 
104 
                $select->where->equalTo('form.status', CompanySelfEvaluationForm::STATUS_ACTIVE);
 104 
                $select->where->equalTo('form.status', CompanySelfEvaluationForm::STATUS_ACTIVE);
Línea 105... Línea 105...
105 
                $select->where->notEqualTo('test.status', CompanySelfEvaluationTest::STATUS_PENDING);
 105 
                $select->where->notEqualTo('test.status', CompanySelfEvaluationTest::STATUS_DRAFT);
106 
 
 106 
 
107 
                if ($search) {
 107 
                if ($search) {
108 
                    $select->where->NEST->like('name', '%' . $search . '%')
 108 
                    $select->where->NEST->like('name', '%' . $search . '%')