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

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

��ѧ٧ѧ�
<?php namespace Altum\Controllers; use Altum\Middlewares\Authentication; use Altum\Models\Domain; class Links extends Controller { public function index() { Authentication::guard(); /* Prepare the filtering system / $filters = (new \Altum\Filters(['is_enabled', 'type', 'project_id'], ['url'], ['datetime', 'clicks', 'url'])); / Prepare the paginator / $total_rows = database()->query("SELECT COUNT() AS `total` FROM `links` WHERE `user_id` = {$this->user->user_id} {$filters->get_sql_where()}")->fetch_object()->total ?? 0; $paginator = (new \Altum\Paginator($total_rows, $filters->get_results_per_page(), $_GET['page'] ?? 1, url('links?' . $filters->get_get() . '&page=%d'))); /* Get the links list for the project / $links_result = database()->query(" SELECT `links`., `domains`.`scheme`, `domains`.`host` FROM `links` LEFT JOIN `domains` ON `links`.`domain_id` = `domains`.`domain_id` WHERE `links`.`user_id` = {$this->user->user_id} {$filters->get_sql_where('links')} {$filters->get_sql_order_by('links')} {$paginator->get_sql_limit()} "); /* Iterate over the links / $links = []; while($row = $links_result->fetch_object()) { $row->full_url = $row->domain_id ? $row->scheme . $row->host . '/' . $row->url : url($row->url); $links[] = $row; } / Export handler / process_export_csv($links, 'include', ['link_id', 'user_id', 'project_id', 'pixels_ids', 'type', 'url', 'location_url', 'start_date', 'end_date', 'clicks', 'is_enabled', 'datetime'], sprintf(language()->links->title)); process_export_json($links, 'include', ['link_id', 'user_id', 'project_id', 'pixels_ids', 'type', 'url', 'location_url', 'settings', 'start_date', 'end_date', 'clicks', 'is_enabled', 'datetime'], sprintf(language()->links->title)); / Prepare the pagination view / $pagination = (new \Altum\Views\View('partials/pagination', (array) $this))->run(['paginator' => $paginator]); / Create Link Modal / $domains = (new Domain())->get_domains($this->user); $data = [ 'domains' => $domains ]; $view = new \Altum\Views\View('links/create_link_modals', (array) $this); \Altum\Event::add_content($view->run($data), 'modals'); / Delete Modal / $view = new \Altum\Views\View('links/link_delete_modal', (array) $this); \Altum\Event::add_content($view->run(), 'modals'); / Existing projects / $projects = (new \Altum\Models\Project())->get_projects($this->user->user_id); / Prepare the Links Content View / $data = [ 'links' => $links, 'pagination' => $pagination, 'filters' => $filters, 'projects' => $projects ]; $view = new \Altum\Views\View('links/links_content', (array) $this); $this->add_view_content('links_content', $view->run($data)); / Prepare the View */ $view = new \Altum\Views\View('links/index', (array) $this); $this->add_view_content('content', $view->run()); } }

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