pagetable.php

<?php

use Kirby\Query\Query;
use Kirby\Toolkit\Str;
use Kirby\Toolkit\A;
use Kirby\Toolkit\I18n;

$options = require kirby()->root('kirby') . '/config/sections/pages.php';

/* Replace existing properties
--------------------------------*/

$options = A::merge($options, [
    'props' => array(
        'columns' => function($columns = ['title' => array('label' => 'Title', 'text' => '{{ page.title }}')]) {
            return $columns;
        },
        'limit' => function($limit = 10) {
            return $limit;
        },
        'limitOptions' => function($limitOptions = [10, 25, 50]) {
            return $limitOptions;
        },
        'search' => function($search = true) {
            return $search;
        },
        'translations' => function($translations = []) {
            return $translations;
        },
        'showImage' => function($showImage = true) {
            return $showImage;
        },
        'showStatus' => function($showStatus = true) {
            return $showStatus;
        },
        'showActions' => function($showActions = true) {
            return $showActions;
        },
        'query' => function(string $query = '') {
            return $query;
        },
        'url' => function($url = 'panel') {
            return $url;
        }
    ),
    'computed' => array(
        'columns' => function () {
            return $this->columns;
        },
        'translations' => function() {
            $translations = $this->translations;
            $keys         = array_keys($translations);

            $rowsPerPage = in_array('rowsPerPage', $keys) ? I18n::translate($translations['rowsPerPage'], $translations['rowsPerPage']) : null;
            $filterPages = in_array('filterPages', $keys) ? I18n::translate($translations['filterPages'], $translations['filterPages']) : null;
            $of          = in_array('of', $keys)    ? I18n::translate($translations['of'], $translations['of']) : null;
            $all         = in_array('all', $keys)   ? I18n::translate($translations['all'], $translations['all']) : null;
            $reset       = in_array('reset', $keys) ? I18n::translate($translations['reset'], $translations['reset']) : null;
            $empty       = in_array('empty', $keys) ? I18n::translate($translations['empty'], $translations['empty']) : null;
            $loading     = in_array('loading', $keys) ? I18n::translate($translations['loading'], $translations['loading']) : null;

            return array(
                'perPage' => $rowsPerPage,
                'of'      => $of,
                'all'     => $all,
                'filter'  => $filterPages,
                'reset'   => $reset,
                'empty'   => $empty,
                'loading' => $loading,
            );
        },
        'pages' => function () {
            if (Str::length($this->query) == 0) {
                switch ($this->status) {
                    case 'draft':
                        $pages = $this->parent->drafts();
                        break;
                    case 'listed':
                        $pages = $this->parent->children()->listed();
                        break;
                    case 'published':
                        $pages = $this->parent->children();
                        break;
                    case 'unlisted':
                        $pages = $this->parent->children()->unlisted();
                        break;
                    default:
                        $pages = $this->parent->childrenAndDrafts();
                }
            } else {
                // added to support query
                $q = new Query($this->query);
                $pages = $q->resolve([
                    'site' => site(),
                    'page' => $this->model(),
                    'pages' => site()->pages(),
                    'kirby' => kirby()
                ]);
            }

            // loop for the best performance
            foreach ($pages->data as $id => $page) {
                // remove all protected pages
                if ($page->isReadable() === false) {
                    unset($pages->data[$id]);
                    continue;
                }
                // filter by all set templates
                if ($this->templates && in_array($page->intendedTemplate()->name(), $this->templates) === false) {
                    unset($pages->data[$id]);
                    continue;
                }
            }
            // sort
            if ($this->sortBy) {
                $pages = $pages->sortBy(...Str::split($this->sortBy, ' '));
            }
            return $pages;
        },
        'total' => function () {
            return $this->pages()->count();
        },
        'data' => function () {
            $data = array();
            $hasMobile = false;

            if($this->showImage) {
                $data['columns'][] = array(
                    'label' => '',
                    'field' => 'p-cover-image',
                    'sortable' => false,
                    'globalSearchDisabled' => true,
                    'thClass' => 'cover-image',
                    'tdClass' => 'cover-image',
                    'mobile'  => false,
                );
            }

            // calculate width ratio
            $calculateRatio = function (string $width) {
                list($first, $second) = Str::split($width, '/');

                if (empty($first) === true || empty($second) === true) {
                    return '100%';
                }

                $result = (100 / (int)$second) * (int)$first;
                $result = number_format($result, 2, '.', '');
                return $result . '%';
            };

            // loop through the user display choices
            foreach($this->columns() as $key => $column) {
                $sortable   = $column['sortable'] ?? true;
                $searchable = $column['searchable'] ?? true;
                $mobile     = $column['mobile'] ?? false;
                $type       = $column['type'] ?? 'text';
                $label      = $column['label'] ?? ucfirst($key);
                $label      = I18n::translate($label, $label);
                $thClass    = '';
                $tdClass    = '';
                $width      = null;

                $columnData = array(
                    'label'                => $label,
                    'field'                => $key,
                    'type'                 => $type,
                    'sortable'             => $sortable,
                    'globalSearchDisabled' => !$searchable,
                    'mobile'               => $mobile,
                    'width'                => $width
                );

                if($type == 'date') {
                    $dateInputFormat  = $column['dateInputFormat'] ?? 'YYYY-MM-DD';
                    $dateInputFormat  = str_replace('YYYY', 'yyyy', $dateInputFormat);
                    $dateInputFormat  = str_replace('DD', 'dd', $dateInputFormat);

                    $dateOutputFormat = $column['dateOutputFormat'] ?? 'YYYY-MM-DD';
                    $dateOutputFormat  = str_replace('YYYY', 'yyyy', $dateOutputFormat);
                    $dateOutputFormat  = str_replace('DD', 'dd', $dateOutputFormat);

                    $columnData['dateInputFormat'] = $dateInputFormat;
                    $columnData['dateOutputFormat'] = $dateOutputFormat;
                }
                if(array_key_exists('width', $column)) {
                    $width = $calculateRatio($column['width']);
                }
                if(array_key_exists('class', $column)) {
                    $thClass .= 'head-'. $column['class'];
                    $tdClass .= 'row-'. $column['class'];
                }
                if($mobile && !$hasMobile) {
                    $hasMobile = true;
                    $thClass .= ' mobile-column';
                    $tdClass .= ' mobile-column';
                }

                $columnData['thClass'] = $thClass ?: null;
                $columnData['tdClass'] = $tdClass ?: null;
                $columnData['width']   = $width;
                $data['columns'][]     = $columnData;
            }

            if(!$hasMobile) {
                $index = $this->showImage ? 1 : 0;
                $data['columns'][$index]['mobile'] = true;
                $data['columns'][$index]['thClass'] .= ' mobile-column';
                $data['columns'][$index]['tdClass'] .= ' mobile-column';
            }

            $optionsClass = 'pagetable-options-none';
            if ($this->showStatus && $this->showActions) {
                $optionsClass = 'pagetable-options-two';
            }
            elseif ($this->showStatus || $this->showActions) {
                $optionsClass = 'pagetable-options-one';
            }


            // last column is always the options
            $data['columns'][] = array(
                'label' => '',
                'field' => 'p-options',
                'sortable' => false,
                'thClass' => 'pagetable-options-container '. $optionsClass,
                'tdClass' => 'pagetable-options-container '. $optionsClass
            );

            $data['rows'] = array();

            foreach ($this->pages as $item) {
                $permissions = $item->permissions();
                $panel       = $item->panel();
                $image       = $panel->image($this->image ?? []);
                $url         = false;
                if($this->url == 'panel') {
                    $url = $panel->url(true);
                }
                if($this->url == 'preview') {
                    $url = $item->previewUrl();
                }

                $baseOptions = [
                    'id'          => $item->id(),
                    'dragText'    => $panel->dragText('auto', $this->dragTextType),
                    'text'        => $item->toString($this->text),
                    'info'        => $item->toString($this->info ?? false),
                    'parent'      => $item->parentId(),
                    'image'       => $image,
                    'link'        => $panel->url(true),
                    'rowLink'     => $url,
                    'status'      => $item->status(),
                    'template'    => $item->intendedTemplate()->name(),
                    'permissions' => [
                        'sort'         => $permissions->can('sort'),
                        'changeStatus' => $permissions->can('changeStatus'),
                    ],
                ];

                $userOptions = [];
                // loop through the user display choices
                foreach($this->columns() as $key => $column) {
                    $userOptions[$key] = $item->toString($column['text']);
                }

                $options = array_merge_recursive($baseOptions, $userOptions);

                $data['rows'][] = $options;
            }


            return $data;
        },
    ),
    'toArray' => function () {
        return [
            'data'    => $this->data,
            'errors'  => $this->errors,
            'options' => [
                'add'          => $this->add,
                'empty'        => $this->empty,
                'headline'     => $this->headline,
                'layout'       => $this->layout,
                'link'         => $this->link(),
                'size'         => $this->size,
                'sortable'     => $this->sortable,
                'limit'        => $this->limit,
                'limitOptions' => $this->limitOptions,
                'search'       => $this->search,
                'showImage'    => $this->showImage,
                'showStatus'   => $this->showStatus,
                'showActions'  => $this->showActions,
                'min'          => $this->min,
                'mobileColumn' => $this->mobileColumn
            ],
            'translations' => $this->translations,
            'pagination' => $this->pagination,
        ];
    }
]);


// return the updated options
return $options;