Proyectos de Subversion LeadersLinked - Antes de SPA

use LeadersLinked\Mapper\QueryMapper;

use LeadersLinked\Mapper\QueryMapper;

use LeadersLinked\Model\CompanyPerformanceEvaluationForm;

use LeadersLinked\Model\CompanyPerformanceEvaluationForm;

use LeadersLinked\Mapper\CompanyPerformanceEvaluationFormMapper;

use LeadersLinked\Mapper\CompanyPerformanceEvaluationFormMapper;

use LeadersLinked\Model\CompanyPerformanceEvaluationTest;

use LeadersLinked\Model\CompanyPerformanceEvaluationTest;

use Laminas\Db\Sql\Select;

use Laminas\Db\Sql\Select;

use LeadersLinked\Form\PerformanceEvaluation\PerformanceEvaluationTestForm;

use LeadersLinked\Form\PerformanceEvaluation\PerformanceEvaluationTestForm;

use LeadersLinked\Mapper\CompetencyMapper;

use LeadersLinked\Mapper\CompetencyMapper;

use LeadersLinked\Mapper\JobDescriptionMapper;

use LeadersLinked\Mapper\JobDescriptionMapper;

use LeadersLinked\Mapper\JobDescriptionCompetencyMapper;

use LeadersLinked\Mapper\JobDescriptionCompetencyMapper;

use LeadersLinked\Mapper\CompetencyTypeMapper;

use LeadersLinked\Mapper\CompetencyTypeMapper;

use LeadersLinked\Model\JobDescriptionSubordinate;

use LeadersLinked\Model\JobDescriptionSubordinate;

use LeadersLinked\Mapper\BehaviorCompetencyMapper;

use LeadersLinked\Mapper\BehaviorCompetencyMapper;

use LeadersLinked\Model\BehaviorCompetency;

use LeadersLinked\Model\BehaviorCompetency;

use LeadersLinked\Mapper\BehaviorMapper;

use LeadersLinked\Mapper\BehaviorMapper;

use LeadersLinked\Library\Functions;

use LeadersLinked\Library\Functions;

class PerformanceEvaluationController extends AbstractActionController {

class PerformanceEvaluationController extends AbstractActionController {

                $queryMapper = QueryMapper::getInstance($this->adapter);

                $queryMapper = QueryMapper::getInstance($this->adapter);

                $select = $queryMapper->getSql()->select();

                $select = $queryMapper->getSql()->select();

                $select->columns(['uuid', 'name', 'description', 'text', 'job_description_id']);

                $select->columns(['uuid', 'name', 'description', 'text', 'job_description_id']);

                $select->join(['fu' => CompanyPerformanceEvaluationFormUserMapper::_TABLE], 'f.id = fu.form_id', []);

                $select->join(['fu' => CompanyPerformanceEvaluationTestUser::_TABLE], 'f.id = fu.form_id', []);

                $select->join(['t' => CompanyPerformanceEvaluationTestMapper::_TABLE], 'fu.form_id = t.form_id AND fu.user_id = t.user_id', ['status'], Select::JOIN_LEFT_OUTER);

                $select->join(['t' => CompanyPerformanceEvaluationTestMapper::_TABLE], 'fu.form_id = t.form_id AND fu.user_id = t.user_id', ['status'], Select::JOIN_LEFT_OUTER);

                $select->where->equalTo('f.status', CompanyPerformanceEvaluationForm::STATUS_ACTIVE);

                $select->where->equalTo('f.status', CompanyPerformanceEvaluationForm::STATUS_ACTIVE);

            //Competencies

            //Competencies

            $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);

            $jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);

            $competencyMapper = CompetencyMapper::getInstance($this->adapter);

            $competencyMapper = CompetencyMapper::getInstance($this->adapter);

            $behaviorCompetencyMapper = BehaviorCompetencyMapper::getInstance($this->adapter);

            $competencyBehaviorMapper = CompetencyBehaviorMapper::getInstance($this->adapter);

            $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);

            $jobDescriptionBehaviorCompetencyMapper = JobDescriptionBehaviorCompetencyMapper::getInstance($this->adapter);

            $behaviorMapper = BehaviorMapper::getInstance($this->adapter);

            $behaviorMapper = BehaviorMapper::getInstance($this->adapter);

                $competency = $competencyMapper->fetchOne($record->competency_id);

                $competency = $competencyMapper->fetchOne($record->competency_id);

                $competenceType = $competenceTypeMapper->fetchOne($competency->competency_type_id);

                $competenceType = $competenceTypeMapper->fetchOne($competency->competency_type_id);

                    $behaviorCompetencies = $behaviorCompetencyMapper->fetchByCompetencyId($competency->id);

                    $behaviorCompetencies = $competencyBehaviorMapper->fetchAllByCompetencyId($competency->id);

                    $behaviors = [];

                    $behaviors = [];