Proyectos de Subversion LeadersLinked - Backend

    /**

     * 

     * Obtener los usuarios de un tópico

     * {@inheritDoc}

     * @see \Laminas\Mvc\Controller\AbstractActionController::usersAction()

     * @return JsonModel

     */

    public function usersAction()

    {

        try {

            $request = $this->getRequest();

            $currentUserPlugin = $this->plugin('currentUserPlugin');

            $currentUser    = $currentUserPlugin->getUser();

            $currentCompany = $currentUserPlugin->getCompany();

            if(!$currentCompany) {

                return $this->createErrorResponse('ERROR_COMPANY_NOT_FOUND');

            }

            if(!$currentUser) {

                return $this->createErrorResponse('ERROR_USER_NOT_FOUND');

            }

            if(!$request->isGet()) {

                return $this->createErrorResponse('ERROR_METHOD_NOT_ALLOWED');

            }

            $topic_uuid = $this->params()->fromRoute('topic_uuid');

            $type = $this->params()->fromRoute('type'); 

            $topicMapper = MicrolearningTopicMapper::getInstance($this->adapter);

            $topic = $topicMapper->fetchOneByUuid($topic_uuid);

            if(!$topic) {

                $this->logger->err('Error in usersAction: ' . $topic_uuid);

                return $this->createErrorResponse('ERROR_TOPIC_NOT_FOUND');

            }

            if($topic->company_id != $currentCompany->id) {

                $this->logger->err('Error in usersAction: ' . $topic_uuid);

                return $this->createErrorResponse('ERROR_UNAUTHORIZED');

            }

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

            $sql = $queryMapper->getSql();

            $select = $sql->select();

            $select->columns(['access', 'paid_from', 'paid_to', 'added_on']);

            $select->from(['tb1' => MicrolearningTopicUserMapper::_TABLE] );

            $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);

            $select->where->equalTo('tb1.company_id', $topic->company_id);

            $select->where->equalTo('tb1.topic_id', $topic->id);

            if($type == 'active') {

                $now = date('Y-m-d H:i:s');

                $select->where->nest->equalTo('access', MicrolearningTopicUser::ACCESS_UNLIMITED)->or->nest()

                ->equalTo('access', MicrolearningTopicUser::ACCESS_PAY_PERIOD)

                ->and->lessThanOrEqualTo('paid_from', $now)->and->greaterThanOrEqualTo('paid_to', $now )->unnest()->unnest();

            } 

            $select->order(['first_name', 'last_name', 'email']);

            $records  = $queryMapper->fetchAll($select);

            $items = [];

            foreach($records as $record)

            {          

                switch($record['access'])

                {

                    case MicrolearningTopicUser::ACCESS_UNLIMITED :

                        $details['access'] = 'LABEL_UNLIMIT';

                        break;

                    case MicrolearningTopicUser::ACCESS_REVOKE :

                        $details['access'] = 'LABEL_REVOKED';

                        break;

                    case MicrolearningTopicUser::ACCESS_PAY_PERIOD :

                        $dt_paid_from = \DateTime::createFromFormat('Y-m-d', $record['paid_from']);

                        $dt_paid_to = \DateTime::createFromFormat('Y-m-d', $record['paid_to']);

                        $details['access'] = 'LABEL_PAY_PERIOD';

                        $details['paid_from'] = $dt_paid_from->format('d/m/Y');

                        $details['paid_to'] = $dt_paid_to->format('d/m/Y');

                        break;

                    case MicrolearningTopicUser::ACCESS_SUPENDED :

                        $dt_paid_from = \DateTime::createFromFormat('Y-m-d', $record['paid_from']);

                        $dt_paid_to = \DateTime::createFromFormat('Y-m-d', $record['paid_to']);

                        $details['access'] = 'LABEL_SUSPENDED';

                        $details['paid_from'] = $dt_paid_from->format('d/m/Y');

                        $details['paid_to'] = $dt_paid_to->format('d/m/Y');

                        break;

                    case MicrolearningTopicUser::ACCESS_CANCELLED :

                        $dt_paid_from = \DateTime::createFromFormat('Y-m-d', $record['paid_from']);

                        $dt_paid_to = \DateTime::createFromFormat('Y-m-d', $record['paid_to']);

                        $details['access'] = 'LABEL_CANCELLED';

                        $details['paid_from'] = $dt_paid_from->format('d/m/Y');

                        $details['paid_to'] = $dt_paid_to->format('d/m/Y');

                        break;        

                }

                $item = [

                    'first_name' => $record['first_name'],

                    'last_name' => $record['last_name'],

                    'email' => $record['email'],

                    'details' => $details,

                ];    

                array_push($items, $item);

            }

            return new JsonModel([

                'success' => true,

                'data' => [

                    'topic' => $topic->name,

                    'items' => $items, 

                ]    

            ]);    

        } catch (\Exception $e) {

            $this->logger->err('Error in usersAction: ' . $e->getMessage());

            return $this->createErrorResponse('ERROR_INTERNAL_SERVER_ERROR');

        }

    }