Rev 8101 | AutorÃa | Ultima modificación | Ver Log |
<?php
declare(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'
]);
}
}