Proyectos de Subversion LeadersLinked - Backend

    public function usersAction()

    {

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

        $currentUser    = $currentUserPlugin->getUser();

        $currentCompany = $currentUserPlugin->getCompany();

        $request        = $this->getRequest();

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

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

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

        $capsuleMapper = MicrolearningCapsuleMapper::getInstance($this->adapter);

        $capsule = $capsuleMapper->fetchOneByUuid($capsule_uuid);

        if(!$capsule) {

            return new JsonModel([

                'success'   => false,

                'data'   => 'ERROR_CAPSULE_NOT_FOUND'

            ]);

        }

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

            return new JsonModel([

                'success'   => false,

                'data'   => 'ERROR_UNAUTHORIZED'

            ]);

        }

        if($request->isGet()) {

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

            $sql = $queryMapper->getSql();

            $select = $sql->select();

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

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

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

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

            $select->where->equalTo('tb1.capsule_id', $capsule->id);

            if($type == 'active') {

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

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

                ->equalTo('access', MicrolearningCapsuleUser::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 MicrolearningCapsuleUser::ACCESS_UNLIMITED :

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

                        break;

                    case MicrolearningCapsuleUser::ACCESS_REVOKE :

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

                        break;

                    case MicrolearningCapsuleUser::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 MicrolearningCapsuleUser::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 MicrolearningCapsuleUser::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,

                    'capsule' => $capsule->name,

                    'items' => $items, 

                ]    

            ]);

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

        return new JsonModel($data);

    }