Proyectos de Subversion LeadersLinked - Backend

use LeadersLinked\Mapper\DeviceMapper;

use LeadersLinked\Model\Application;

    }

    public function indexAction() 

    {

        $this->layout()->setTemplate('layout/layout-backend.phtml');

        $viewModel = new ViewModel();

        $viewModel->setTemplate('leaders-linked/microlearning-reports/index.phtml');

        }

        return new JsonModel([

            'success' => false,

            'data' => 'ERROR_METHOD_NOT_ALLOWED'

        ]);

    }

    public function devicesAction()

    {

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

        $currentUser = $currentUserPlugin->getUser();

        $currentCompany = $currentUserPlugin->getCompany();

        $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');

                    }

                }

            }

            if($isJson) {

                $date = date('Y-m-d');

                $deviceMapper = DeviceMapper::getInstance($this->adapter);

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

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

                $selectCapsuleUser->columns(['user_id' => new Expression('DISTINCT(user_id)')  ]);

                $selectCapsuleUser->from(CompanyMicrolearningCapsuleUserMapper::_TABLE);

                $selectCapsuleUser->where->equalTo('company_id', $currentCompany->id);

                $selectCapsuleUser->where->nest->equalTo('access', CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()

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

                ->and->lessThanOrEqualTo(new Expression('DATE(paid_from)'), $date)

                ->and->greaterThanOrEqualTo(new Expression('DATE(paid_to)'), $date )->unnest()->unnest();

                //echo $select->getSqlString($this->adapter->platform); exit;

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

                $select->columns(['id' , 'uuid', 'first_name', 'last_name', 'email']);

                $select->from(UserMapper::_TABLE);

                $select->where->in('id', $selectCapsuleUser);

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

                $students = [];

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

                foreach($records as $record)

                {

                    $record_devices = $deviceMapper->fetchAllByUserId($record['id']);

                    $devices = [];

                    foreach($record_devices as $device)

                    {

                        /*if($device->application_id != Application::LEADERSLINKED) {

                            continue;

                        }*/

                        $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $device->updated_on);

                        array_push($devices, [

                            'brand' => $device->brand,

                            'manufacturer' => $device->manufacturer,

                            'model' => $device->model,

                            'platform' => $device->platform,

                            'version' => $device->version,

                            'token' => $device->token ? 'LABEL_YES' : 'LABEL_NO',

                            'updated_on' => $dt->format('d/m/Y h:i a')

                        ]);

                    }

                    $student = [

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

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

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

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

                        'devices' => $devices

                    ];

                    array_push($students, $student);

                }

                return new JsonModel([

                    'success' => true,

                    'data' => $students

                ]);

            } else {

                $form = new ExtendUserMicrolearningForm($this->adapter, $currentCompany->id);

                $this->layout()->setTemplate('layout/layout-backend.phtml');

                $viewModel = new ViewModel();

                $viewModel->setTemplate('leaders-linked/microlearning-reports/devices.phtml');

                $viewModel->setVariables([

                    'form' => $form

                ]);

                return $viewModel ;

            }