Proyectos de Subversion LeadersLinked - Backend

    // public function indexAction()

    // {

    //     $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) {

    //             $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 =  ['first_name', 'last_name', 'corporate_email', 'activity'];

    //             $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'first_name';

    //             if (!in_array($order_direction, ['ASC', 'DESC'])) {

    //                 $order_direction = 'ASC';

    //             }

    //             //Quede aqui en el mapper

    //             $discoveryContactLogMapper = DiscoveryContactLogMapper::getInstance($this->adapter);

    //             $contactLogMappers = $discoveryContactLogMapper->fetchAll();

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

    //             $sql = $queryMapper->getSql();

    //             $select = $sql->select();

    //             $select->columns(['user_id', 'activity', 'details', 'added_on']);

    //             $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE], ['activity', 'details', 'added_on']);

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

    //             $select->join(['tb3' => CompanyMapper::_TABLE], 'tb1.company_id = tb3.id', ['name']);

    //             if ($search) {

    //                 $select->where->nest()

    //                     ->like('first_name', '%' . $search . '%')

    //                     ->or->like('last_name', '%' . $search . '%')

    //                     ->or->like('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) {

    //                 $dt_added_on = \DateTime::createFromFormat('Y-m-d H:i:s', $record['added_on']);

    //                 $added_on = $dt_added_on->format('d/m/Y h:i a');

    //                 $item = [

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

    //                     'first_name' => ucwords(strtolower($record['first_name'])),

    //                     'last_name' => ucwords(strtolower($record['last_name'])),

    //                     'email' => strtolower($record['email']),

    //                     'company' => $record['name'],

    //                     'activity' => $record['activity'],

    //                     'details' => $record['details'],

    //                     'added_on' => $added_on,

    //                 ];

    //                 array_push($items, $item);

    //             }

    //             $data['items'] = $items;

    //             $data['total'] = $paginator->getTotalItemCount();

    //             return new JsonModel([

    //                 'success' => true,

    //                 'data' => $data

    //             ]);

    //         } else {

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

    //             $viewModel = new ViewModel();

    //             $viewModel->setTemplate('leaders-linked/discovery-contact-progress/index.phtml');

    //             return $viewModel;

    //             return new JsonModel([

    //                 'success' => true,

    //                 'message' => $currentCompany->id

    //             ]);