��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/rickpfrv/tie.cx/app/controllers/api/ApiLinks.php

��ѧ٧ѧ�
<?php namespace Altum\Controllers; use Altum\Response; use Altum\Traits\Apiable; class ApiLinks extends Controller { use Apiable; public function index() { $this->verify_request(); /* Decide what to continue with / switch($_SERVER['REQUEST_METHOD']) { case 'GET': / Detect if we only need an object, or the whole list / if(isset($this->params[0])) { $this->get(); } else { $this->get_all(); } break; } $this->return_404(); } private function get_all() { / Prepare the filtering system / $filters = (new \Altum\Filters([], [], [])); / Prepare the paginator / $total_rows = database()->query("SELECT COUNT() AS `total` FROM `links` WHERE `user_id` = {$this->api_user->user_id}")->fetch_object()->total ?? 0; $paginator = (new \Altum\Paginator($total_rows, $filters->get_results_per_page(), $_GET['page'] ?? 1, url('api/payments?' . $filters->get_get() . '&page=%d'))); /* Get the data / $data = []; $data_result = database()->query(" SELECT FROM `links` WHERE `user_id` = {$this->api_user->user_id} {$filters->get_sql_where()} {$filters->get_sql_order_by()} {$paginator->get_sql_limit()} "); while($row = $data_result->fetch_object()) { /* Prepare the data / $row = [ 'id' => (int) $row->link_id, 'project_id' => (int) $row->project_id, 'domain_id' => (int) $row->domain_id, 'biolink_id' => (int) $row->biolink_id, 'type' => $row->type, 'url' => $row->url, 'location_url' => $row->location_url, 'settings' => json_decode($row->settings), 'clicks' => $row->clicks, 'order' => (int) $row->order, 'start_date' => $row->start_date, 'end_date' => $row->end_date, 'datetime' => $row->date ]; $data[] = $row; } / Prepare the data / $meta = [ 'page' => $_GET['page'] ?? 1, 'total_pages' => $paginator->getNumPages(), 'results_per_page' => $filters->get_results_per_page(), 'total_results' => (int) $total_rows, ]; / Prepare the pagination links / $others = ['links' => [ 'first' => $paginator->getPageUrl(1), 'last' => $paginator->getNumPages() ? $paginator->getPageUrl($paginator->getNumPages()) : null, 'next' => $paginator->getNextUrl(), 'prev' => $paginator->getPrevUrl(), 'self' => $paginator->getPageUrl($_GET['page'] ?? 1) ]]; Response::jsonapi_success($data, $meta, 200, $others); } private function get() { $link_id = isset($this->params[0]) ? (int) $this->params[0] : null; / Try to get details about the resource id / $link = db()->where('link_id', $link_id)->where('user_id', $this->api_user->user_id)->getOne('links'); / We haven't found the resource / if(!$link) { Response::jsonapi_error([[ 'title' => language()->api->error_message->not_found, 'status' => '404' ]], null, 404); } / Prepare the data */ $data = [ 'id' => (int) $link->link_id, 'project_id' => (int) $link->project_id, 'domain_id' => (int) $link->domain_id, 'biolink_id' => (int) $link->biolink_id, 'type' => $link->type, 'url' => $link->url, 'location_url' => $link->location_url, 'settings' => json_decode($link->settings), 'clicks' => $link->clicks, 'order' => (int) $link->order, 'start_date' => $link->start_date, 'end_date' => $link->end_date, 'datetime' => $link->datetime ]; Response::jsonapi_success($data); } }

| ver. 1.4 | Github | . | PHP 7.4.33 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0.11 | proxy | phpinfo | ��ѧ��ۧܧ�