Proyectos de Subversion LeadersLinked - Backend

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

                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('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'],

                        'added_on' => $added_on,

                    ];

                    array_push($items, $item);

                }

                $data['items'] = $items;

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

                    'data' => $data