如何在PHP Laravel Twig中按类别过滤记录？

Question

我正在使用OctoberCMS制作一个简单的画廊，基于Laravel和Twig。

如何按类别筛选记录？

我现在是这样做的，但我认为这不是一个好的解决方案：

我过滤了html，但是类别之外的所有项目的完整记录仍然存在，导致额外的分页和空白页。

数据库

>

“images”表包含图像名称及其标记的类别。

图像列表

URL参数为/gallery/：category？/：页

访问像/gallery/nature/1这样的url将使用for循环按类别过滤图像。

<!-- Gallery Category Record Variable -->
{% set category = record.category %}

<!-- Image List -->
{% for record in records %}

    <!-- If Image Category Tag matches Gallery Category Name -->
    {% if record.category_tag == category %} 
        <img src="/{{ record.name }}.jpg">
    {% endif %}

{% endfor %}

记录

“记录”和“记录”的结果。

for循环正在显示“gallery”→类别“记录在”图像中→“标签”类记录。

分页显示所有图像→名称记录。

{% for record in records %} = (All in 'images')
{{ records }} = {<ul><li>...<a href="gallery/nature?page=2">2</a>} (All in 'images')
{{ record }} = {"category":"nature","id":7} (Current category in 'gallery')

解决方案

在生成html列表之前，有没有办法按类别过滤“记录”？

Answer 1

我会这样做：

• 在图像模型中创建按页面、类别等过滤的范围
• 在组件而不是视图中处理URL属性和逻辑

假设库组件：

网址：第页。com/：cat/：page？

    public function defineProperties()
    {
        return [
            // Page # for pagination..
            'pageNumber' => [
                'title'       => 'Page #',
                'description' => 'Gallery Page #',
                'type'        => 'string',
                'default'     => '{{ :page }}',
            ],
            // Category slug
            'category' => [
                'title'       => 'Category',
                'description' => 'Gallery Cat',
                'type'        => 'string',
                'default'     => '{{ :cat }}',
            ],
            // Images to show per page
            'perPage' => [
                'title'             => 'Images per page',
                'type'              => 'string',
                'validationPattern' => '^[0-9]+$', //  validation
                'validationMessage' =>  'VValidation Error',
                'default'           => '15', 
            ],
            // if you want to add sorting
            'sortOrder' => [
                'title'       => 'Sort Order',
                'description' => 'Images Sort Order',
                'type'        => 'dropdown',
                'default'     => 'updated_at desc' 
            ],
        ];
    }

public function getSortOrderOptions()
{
    return Image::$allowedSortingOptions;
}


public function init()
{
    $this->pageNumber   =  empty($this->property('pageNumber')) ? 1 :   $this->property('pageNumber');
    $this->perPage      =  $this->property('perPage');
    $this->sortOrder    =  $this->property('sortOrder');
    $this->category     =  $this->property('category');
}

public function onRun()
{

  // here you may want to do some checks 
 // and add logic before querying your DB

    return $this->listImages($this->pageNumber , $this->sortOrder,  $this->perPage, $this->category);

}

public function listImages($pageNumber, $sortOrder, $perPage, $category){

  // this is the scope you will define in your Images Model
 // to handle pagination, sorting, category filtering ect..

    $images = Images::listFrontEnd([
        'page'          => $pageNumber,
        'sort'          => $sortOrder,
        'perPage'       => $perPage,
        'category'      => $category,
    ]);



   // small helper if the pagination # is > than last page
  // redirect to last page..

    $lastPage = $images->lastPage();

    if ($this->pageNumber > $lastPage && $this->pageNumber > 1){
            return Redirect::to($this->currentPageUrl(["page" =>  $lastPage]));
        }


 $this->images  = $this->page['images'] = $images;

}

在您的图像模型中：

// list the allowed sorting options that will show up in your component

public static $allowedSortingOptions = array(
    'created_at asc'            => 'Images Created (ascending)',
    'created_at desc'           => 'Images Created (descending)',
    'updated_at asc'            => 'Images Updated (ascending)',

  //        ect....
);


// Scope for your component
public function scopelistImages($query, $options)
    {
        /*
         * Default options
         */
        extract(array_merge([
            'page'              => 1,
            'perPage'           => 15,
            'sort'              => 'updated_at',
            'category'          => null
        ], $options));



        // SORTING
        if (!is_array($sort)) {
            $sort = [$sort];
        }

        foreach ($sort as $_sort) {

            if (in_array($_sort, array_keys(self::$allowedSortingOptions))) {
                $parts = explode(' ', $_sort);
                if (count($parts) < 2) {
                    array_push($parts, 'desc');
                }
                list($sortField, $sortDirection) = $parts;
                if ($sortField == 'random') {
                    $sortField = Db::raw('RAND()');
                }
                $query->orderBy($sortField, $sortDirection);
            }
        }

        // Filter by category
         ........


        return $query->paginate($perPage, $page);
    }

答案来自RainLab博客插件