Rev 8101 | AutorÃa | Ultima modificación | Ver Log |
<?phpdeclare(strict_types=1);namespace LeadersLinked\Controller;use Laminas\Db\Adapter\AdapterInterface;use Laminas\Cache\Storage\Adapter\AbstractAdapter;use Laminas\Mvc\Controller\AbstractActionController;use Laminas\Log\LoggerInterface;use Laminas\View\Model\ViewModel;use Laminas\View\Model\JsonModel;use LeadersLinked\Library\Functions;use LeadersLinked\Mapper\QueryMapper;use LeadersLinked\Mapper\UserMapper;use Laminas\Hydrator\ArraySerializableHydrator;use Laminas\Db\ResultSet\HydratingResultSet;use Laminas\Paginator\Adapter\DbSelect;use Laminas\Paginator\Paginator;use LeadersLinked\Mapper\CompanyPerformanceEvaluationFormMapper;use LeadersLinked\Mapper\CompanyUserMapper;use LeadersLinked\Mapper\JobDescriptionMapper;use LeadersLinked\Mapper\CompetencyTypeMapper;use LeadersLinked\Model\JobDescription;use LeadersLinked\Mapper\CompetencyMapper;use LeadersLinked\Mapper\BehaviorCompetencyMapper;use LeadersLinked\Model\BehaviorCompetency;use LeadersLinked\Library\JobPdf;use LeadersLinked\Mapper\JobDescriptionCompetencyMapper;use LeadersLinked\Mapper\JobDescriptionSubordinateMapper;use LeadersLinked\Model\JobDescriptionCompetency;use LeadersLinked\Model\JobDescriptionBehaviorCompetency;use LeadersLinked\Mapper\JobDescriptionBehaviorCompetencyMapper;use LeadersLinked\Model\JobDescriptionSubordinate;use LeadersLinked\Mapper\BehaviorMapper;use LeadersLinked\Model\Behavior;use LeadersLinked\Form\PerformanceEvaluationEvaluationForm;use LeadersLinked\Form\PerformanceEvaluationEvaluationSelfForm;use LeadersLinked\Mapper\CompanyPerformanceEvaluationTestMapper;use LeadersLinked\Model\CompanyPerformanceEvaluationTest;use LeadersLinked\Model\CompanyPerformanceEvaluationForm;use LeadersLinked\Model\CompanyPerformanceEvaluationTestSelf;class PerformanceEvaluationEvaluationController extends AbstractActionController {/**** @var AdapterInterface*/private $adapter;/**** @var AbstractAdapter*/private $cache;/**** @var LoggerInterface*/private $logger;/**** @var array*/private $config;/**** @param AdapterInterface $adapter* @param AbstractAdapter $cache* @param LoggerInterface $logger* @param array $config*/public function __construct($adapter, $cache, $logger, $config) {$this->adapter = $adapter;$this->cache = $cache;$this->logger = $logger;$this->config = $config;}public function indexAction() {$currentUserPlugin = $this->plugin('currentUserPlugin');$currentUser = $currentUserPlugin->getUser();$currentCompany = $currentUserPlugin->getCompany();try{$request = $this->getRequest();if ($request->isGet()) {$headers = $request->getHeaders();$isJson = false;if ($headers->has('Accept')) {$accept = $headers->get('Accept');$prioritized = $accept->getPrioritized();foreach ($prioritized as $key => $value) {$raw = trim($value->getRaw());if (!$isJson) {$isJson = strpos($raw, 'json');}}}//$isJson = true;if ($isJson) {$data = ['items' => [],'total' => 0,];$search = $this->params()->fromQuery('search', []);$search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);$page = intval($this->params()->fromQuery('start', 1), 10);$records_x_page = intval($this->params()->fromQuery('length', 10), 10);$order = $this->params()->fromQuery('order', []);$order_field = empty($order[0]['column']) ? 99 : intval($order[0]['column'], 10);$order_direction = empty($order[0]['dir']) ? 'ASC' : strtoupper(filter_var($order[0]['dir'], FILTER_SANITIZE_STRING));$fields = ['max_date'];$order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'first_name';if (!in_array($order_direction, ['ASC', 'DESC'])) {$order_direction = 'ASC';}$acl = $this->getEvent()->getViewModel()->getVariable('acl');$allowDelete = $acl->isAllowed($currentUser->usertype_id, 'performance-evaluation/evaluations/delete');$queryMapper = QueryMapper::getInstance($this->adapter);$sql = $queryMapper->getSql();$select = $sql->select();$select->columns(['uuid', 'last_date', 'form_id']);$select->from(['tb1' => CompanyPerformanceEvaluationTestMapper::_TABLE]);$select->join(['tb2' => CompanyPerformanceEvaluationFormMapper::_TABLE], 'tb1.form_id = tb2.id ', ['form' =>'name']);$select->join(['tb3' => UserMapper::_TABLE], 'tb1.supervisor_id = tb3.id ', ['first_name', 'last_name', 'email']);$select->where->equalTo('tb1.company_id', $currentCompany->id);if ($search) {$select->where->nest()->like('tb1.last_date', '%' . $search . '%')->like('tb2.name', '%' . $search . '%')->like('tb3.first_name', '%' . $search . '%')->or->like('tb3.last_name', '%' . $search . '%')->or->like('tb3.email', '%' . $search . '%')->unnest();}$select->order($order_field . ' ' . $order_direction);$hydrator = new ArraySerializableHydrator();$resultset = new HydratingResultSet($hydrator);$adapter = new DbSelect($select, $sql, $resultset);$paginator = new Paginator($adapter);$paginator->setItemCountPerPage($records_x_page);$paginator->setCurrentPageNumber($page);$items = [];$records = $paginator->getCurrentItems();foreach ($records as $record){$testMapper = CompanyPerformanceEvaluationTestMapper::getInstance($this->adapter);$test = $testMapper->fetchOneByUuid($record['uuid']);$dt = \DateTime::createFromFormat('Y-m-d', $record['last_date']);$last_date = $dt->format('d/m/Y');$link_self =$link_superviser =$link_both =$link_delete = $this->url()->fromRoute('performance-evaluation/evaluations/delete', ['id' => $record['uuid'] ]);$item = ['last_date' => $last_date,'form' => $record['form'],'first_name' => $test->first_name,'last_name' => $test->last_name,'supervisor' => trim(trim($record['first_name']) . ' ' . trim($record['last_name'])) . ' (' . trim($record['email']) . ')','actions' => ['link_delete' => $allowDelete ? $link_delete : '','link_self' => $this->url()->fromRoute('performance-evaluation/evaluations/self', ['id' => $record['uuid'] ]),'link_superviser' => $this->url()->fromRoute('performance-evaluation/evaluations/superviser', ['id' => $record['uuid'] ]),'link_both' => $this->url()->fromRoute('performance-evaluation/evaluations/both', ['id' => $record['uuid'] ]),]];array_push($items, $item);}$data['items'] = $items;$data['total'] = $paginator->getTotalItemCount();return new JsonModel(['success' => true,'data' => $data]);} else {$form = new PerformanceEvaluationEvaluationForm($this->adapter, $currentCompany->id);$formSelf = new PerformanceEvaluationEvaluationSelfForm($this->adapter, $currentCompany->id);$this->layout()->setTemplate('layout/layout-backend');$viewModel = new ViewModel();$viewModel->setTemplate('leaders-linked/performance-evaluation-evaluations/index.phtml');$viewModel->setVariables(['form' => $form,'formSelf' => $formSelf,]);return $viewModel;}} else {return new JsonModel(['success' => false,'data' => 'ERROR_METHOD_NOT_ALLOWED']);}} catch (\Throwable $e) {$e->getMessage();return new JsonModel(['success' => false,'data' => $e]);}}public function emailAction() {$request = $this->getRequest();$currentUserPlugin = $this->plugin('currentUserPlugin');$currentCompany = $currentUserPlugin->getCompany();$currentUser = $currentUserPlugin->getUser();$email = $request->getQuery('email');if(!$email){$data = ['success' => false,'data' => 'ERROR_INVALID_PARAMETER'];return new JsonModel($data);}$userMapper = UserMapper::getInstance($this->adapter);$user = $userMapper->fetchOneByEmail($email);if (!$user) {return new JsonModel(['success' => false,'data' => 'ERROR_USER_NOT_FOUND',]);} else if($request->isGet()){$data = ['success' => true,'data' => ['user_id' => $user->id,'first_name' => $user->first_name,'last_name' => $user->last_name,]];return new JsonModel($data);}else {$data = ['success' => false,'data' => 'ERROR_METHOD_NOT_ALLOWED'];return new JsonModel($data);}}public function addAction() {$request = $this->getRequest();$currentUserPlugin = $this->plugin('currentUserPlugin');$currentUser = $currentUserPlugin->getUser();$currentCompany = $currentUserPlugin->getCompany();$request = $this->getRequest();if ($request->isPost()) {$dataPost = $request->getPost()->toArray();$form = new PerformanceEvaluationEvaluationForm($this->adapter, $currentCompany->id);$form->setData($dataPost);if($form->isValid()) {$dataPost = (array) $form->getData();$form_id = $dataPost['form_id'];$supervisor_id = $dataPost['supervisor_id'];$first_name= $dataPost['first_name'];$last_name= $dataPost['last_name'];$email= $dataPost['email'];$user_id= $dataPost['user_id'];$dt = \DateTime::createFromFormat('d/m/Y', $dataPost['last_date']);$last_date = $dt->format('Y-m-d');$formMapper = CompanyPerformanceEvaluationFormMapper::getInstance($this->adapter);$form = $formMapper->fetchOneByUuid($form_id);if (!$form) {return new JsonModel(['success' => true,'data' => 'ERROR_FORM_NOT_FOUND']);}if ($form->company_id != $currentCompany->id) {return new JsonModel(['success' => true,'data' => 'ERROR_UNAUTHORIZED']);}$userMapper = UserMapper::getInstance($this->adapter);$supervisor = $userMapper->fetchOneByUuid($supervisor_id);if (!$supervisor) {return new JsonModel(['success' => false,'data' => 'ERROR_USER_NOT_FOUND']);}$companyUserMapper = CompanyUserMapper::getInstance($this->adapter);$companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($form->company_id, $supervisor->id);if (!$companyUser) {return new JsonModel(['success' => false,'data' => 'ERROR_UNAUTHORIZED']);}$test = new CompanyPerformanceEvaluationTest();$test->company_id = $form->company_id;$test->form_id = $form->id;$test->supervisor_id = $supervisor->id;$test->last_date = $last_date;$test->first_name = $first_name;$test->last_name = $last_name;$test->email = $email;//$tst->user_id = $user_id;$testMapper = CompanyPerformanceEvaluationTestMapper::getInstance($this->adapter);$result = $testMapper->insert($test);if($result) {$this->logger->info('Se agrego el Test de Performance ' . $form->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);$data = ['success' => true,'data' => 'LABEL_RECORD_ADDED'];} else {$data = ['success' => false,'data' => $testMapper->getError()];}return new JsonModel($data);} else {$messages = [];$form_messages = (array) $form->getMessages();foreach($form_messages as $fieldname => $field_messages){$messages[$fieldname] = array_values($field_messages);}return new JsonModel(['success' => false,'data' => $messages]);}}return new JsonModel(['success' => false,'data' => 'ERROR_METHOD_NOT_ALLOWED']);}public function selfAction() {$currentUserPlugin = $this->plugin('currentUserPlugin');$currentUser = $currentUserPlugin->getUser();$currentCompany = $currentUserPlugin->getCompany();$request = $this->getRequest();$uuid = $this->params()->fromRoute('id');if ($request->isGet()) {$testMapper = CompanyPerformanceEvaluationTestMapper::getInstance($this->adapter);$test = $testMapper->fetchOneByUuid($uuid);$formMapper = CompanyPerformanceEvaluationFormMapper::getInstance($this->adapter);$form = $formMapper->fetchOne($test->form_id);$jobDescriptionMapper = JobDescriptionMapper::getInstance($this->adapter);$jobDescription = $jobDescriptionMapper->fetchOne($form->job_description_id);$jobDescriptionCompetencyMapper = JobDescriptionCompetencyMapper::getInstance($this->adapter);$jobDescriptionCompetencies = $jobDescriptionCompetencyMapper->fetchByJobDescriptionId($jobDescription->id);// return new JsonModel([// 'success' => false,// 'data' => $jobDescriptionCompetencies// ]);$competencyTypeMapper = CompetencyTypeMapper::getInstance($this->adapter);$competencyMapper = CompetencyMapper::getInstance($this->adapter);$behaviorCompetencyMapper = BehaviorCompetencyMapper::getInstance($this->adapter);$behaviorMapper = BehaviorMapper::getInstance($this->adapter);$data = ['job_description' => ['uuid' => $jobDescription->uuid,'name' => $jobDescription->name,'functions' => $jobDescription->functions,'objectives' => $jobDescription->objectives,'competencies' => []],'self' => ['points' => 0,'comment' => '',],'test' => $test,];foreach ($jobDescriptionCompetencies as $jobDescriptionCompetency) {$competency = $competencyMapper->fetchOne($jobDescriptionCompetency->competency_id);$competencyType = $competencyTypeMapper->fetchOne($competency->competency_type_id);$behaviorCompetencies = $behaviorCompetencyMapper->fetchByCompetencyId($competency->id);$behaviors = [];foreach ($behaviorCompetencies as $behaviorCompetency) {$behavior = $behaviorMapper->fetchOne($behaviorCompetency->behavior_id);$behaviors []= ['uuid' => $behavior->uuid,'description' => $behavior->description,'points' => 0,'comment' => '','competency_uuid' => $competency->uuid,];}array_push($data['job_description']['competencies'], ['competency_uuid' => $competency->uuid,'competency_name' => $competency->name,'competency_type_uuid' => $competencyType->uuid,'competency_type_name' => $competencyType->name,'behaviors' => $behaviors,]);}return new JsonModel(['success' => true,'data' => $data]);} else if($request->isPost()){$dataPost = $request->getPost()->toArray();$dataPost['test'] = $test;$testMapper = CompanyPerformanceEvaluationTestMapper::getInstance($this->adapter);$test = $testMapper->fetchOneByUuid($test);$formSelf = new PerformanceEvaluationEvaluationSelfForm($this->adapter, $currentCompany->id);$formSelf->setData($dataPost);if ($formSelf->isValid()) {$dataPost = (array) $formSelf->getData();$hydrator = new ObjectPropertyHydrator();$performanceEvaluationTestSelf = new CompanyPerformanceEvaluationTestSelf();$hydrator->hydrate($dataPost, $performanceEvaluationTestSelf);$performanceEvaluationTestSelf->company_id = $currentCompany->id;$performanceEvaluationTestSelf->test_id = $test->id;$performanceEvaluationTestSelfMapper = CompanyPerformanceEvaluationTestSelfMapper::getInstance($this->adapter);$result = $performanceEvaluationTestSelfMapper->insert($performanceEvaluationTestSelf);if ($result) {$this->logger->info('Se agrego la entrevista ' . $recruitmentSelectionInterview->id, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);// Get record by id$performanceEvaluationTestSelfMapper = CompanyPerformanceEvaluationTestSelfMapper::getInstance($this->adapter);$record = $performanceEvaluationTestSelfMapper->fetchOne($performanceEvaluationTestSelf->id);if ($record) {$data = ['success' => true,'id' => $record->id,'data' => 'LABEL_RECORD_ADDED'];} else {$data = ['success' => false,'data' => 'ERROR_RECORD_NOT_FOUND'];}} else {$data = ['success' => false,'data' => $performanceEvaluationTestSelfMapper->getError()];}return new JsonModel($data);} else {$messages = [];$form_messages = (array) $form->getMessages();foreach ($form_messages as $fieldname => $field_messages) {$messages[$fieldname] = array_values($field_messages);}return new JsonModel(['success' => false,'data' => $messages]);}} else {$data = ['success' => false,'data' => 'ERROR_METHOD_NOT_ALLOWED'];return new JsonModel($data);}return new JsonModel($data);}public function editAction() {$request = $this->getRequest();$currentUserPlugin = $this->plugin('currentUserPlugin');$currentUser = $currentUserPlugin->getUser();$currentCompany = $currentUserPlugin->getCompany();$request = $this->getRequest();$id = $this->params()->fromRoute('id');$formTestMapper = CompanyPerformanceEvaluationTestMapper::getInstance($this->adapter);$formTest = $formTestMapper->fetchOneByUuid($id);if (!$formTest) {return new JsonModel(['success' => true,'data' => 'ERROR_RECORD_NOT_FOUND']);}if ($formTest->company_id != $currentCompany->id) {return new JsonModel(['success' => true,'data' => 'ERROR_UNAUTHORIZED']);}$companyUserMapper = CompanyUserMapper::getInstance($this->adapter);$companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($formTest->company_id, $currentUser->id);if (!$companyUser) {return new JsonModel(['success' => false,'data' => 'ERROR_UNAUTHORIZED']);}if ($request->isGet()) {$dt = \DateTime::createFromFormat('Y-m-d', $formTest->last_date);$formMapper = CompanyPerformanceEvaluationFormMapper::getInstance($this->adapter);$form = $formMapper->fetchOne($formTest->form_id);$userMapper = UserMapper::getInstance($this->adapter);$user = $userMapper->fetchOne($formTest->supervisor_id);$data = ['success' => true,'data' => ['last_date' => $dt->format('d/m/Y'),'form' => $form->uuid,'supervisor' => $user->uuid,]];return new JsonModel($data);} else if ($request->isPost()) {$dataPost = $request->getPost()->toArray();$form = new PerformanceEvaluationEvaluationForm($this->adapter, $currentCompany->id);$form->setData($dataPost);if($form->isValid()) {$dataPost = (array) $form->getData();$form_id = $dataPost['form_id'];$user_id = $dataPost['supervisor_id'];$dt = \DateTime::createFromFormat('d/m/Y', $dataPost['last_date']);$last_date = $dt->format('Y-m-d');$formMapper = CompanyPerformanceEvaluationFormMapper::getInstance($this->adapter);$form = $formMapper->fetchOneByUuid($form_id);if (!$form) {return new JsonModel(['success' => true,'data' => 'ERROR_FORM_NOT_FOUND']);}if ($form->company_id != $currentCompany->id) {return new JsonModel(['success' => true,'data' => 'ERROR_UNAUTHORIZED']);}$userMapper = UserMapper::getInstance($this->adapter);$user = $userMapper->fetchOneByUuid($user_id);if (!$user) {return new JsonModel(['success' => false,'data' => 'ERROR_USER_NOT_FOUND']);}$companyUserMapper = CompanyUserMapper::getInstance($this->adapter);$companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($form->company_id, $user->id);if (!$companyUser) {return new JsonModel(['success' => false,'data' => 'ERROR_UNAUTHORIZED']);}$formTest->supervisor_id = $user->id;$formTest->last_date = $last_date;$testMapper = CompanyPerformanceEvaluationTestMapper::getInstance($this->adapter);$result = $testMapper->update($formTest);if($result) {$this->logger->info('Se actualizo el Test de Performance ' . $form->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);$data = ['success' => true,'data' => 'LABEL_RECORD_UPDATED'];} else {$data = ['success' => false,'data' => $testMapper->getError()];}return new JsonModel($data);} else {$messages = [];$form_messages = (array) $form->getMessages();foreach($form_messages as $fieldname => $field_messages){$messages[$fieldname] = array_values($field_messages);}return new JsonModel(['success' => false,'data' => $messages]);}}return new JsonModel(['success' => false,'data' => 'ERROR_METHOD_NOT_ALLOWED']);}public function deleteAction() {$request = $this->getRequest();$currentUserPlugin = $this->plugin('currentUserPlugin');$currentUser = $currentUserPlugin->getUser();$currentCompany = $currentUserPlugin->getCompany();$request = $this->getRequest();$id = $this->params()->fromRoute('id');$formTestMapper = CompanyPerformanceEvaluationTestMapper::getInstance($this->adapter);$formTest = $formTestMapper->fetchOneByUuid($id);if (!$formTest) {return new JsonModel(['success' => true,'data' => 'ERROR_RECORD_NOT_FOUND']);}if ($formTest->company_id != $currentCompany->id) {return new JsonModel(['success' => true,'data' => 'ERROR_UNAUTHORIZED']);}$companyUserMapper = CompanyUserMapper::getInstance($this->adapter);$companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($formTest->company_id, $currentUser->id);if (!$companyUser) {return new JsonModel(['success' => false,'data' => 'ERROR_UNAUTHORIZED']);}if ($request->isPost()) {$result = $formTestMapper->delete($formTest);if ($result) {return new JsonModel(['success' => true,'data' => 'LABEL_PERFORMANCE_TEST_DELETED',]);} else {return new JsonModel(['success' => false,'data' => $formTestMapper->getError()]);}}return new JsonModel(['success' => false,'data' => 'ERROR_METHOD_NOT_ALLOWED']);}}