1. Backend
  2. Sorting Records

Introduction

Reorder Behavior is a controller modifier that provides features for sorting and reordering database records. The behavior provides a page called Reorder using the controller action reorder. This page displays a list of records with a drag handle allowing them to be sorted and in some cases restructured.

The behavior depends on a model class which must implement one of the following model traits:

  1. October\Rain\Database\Traits\Sortable
  2. October\Rain\Database\Traits\NestedTree

NOTE: If adding sorting to a previously unsorted model under the control of a third party is desired, you can use the October\Rain\Database\Behaviors\Sortable behavior, which can be dynamically implemented. However, you will need to ensure that the model table has a sort_order column present on it.

In order to use the reorder behavior you should add it to the $implement property of the controller class. Also, the $reorderConfig class property should be defined and its value should refer to the YAML file used for configuring the behavior options.

namespace Acme\Shop\Controllers;

class Categories extends Controller
{
    public $implement = [
        \Backend\Behaviors\ReorderController::class
    ];

    public $reorderConfig = 'config_reorder.yaml';

    // [...]
}

Configuring the behavior

The configuration file referred in the $reorderConfig property is defined in YAML format. The file should be placed into the controller's views directory. Below is an example of a configuration file:

# ===================================
#  Reorder Behavior Config
# ===================================

# Reorder Title
title: Reorder Categories

# Attribute name
nameFrom: title

# Model Class name
modelClass: Acme\Shop\Models\Category

# Toolbar widget configuration
toolbar:
    # Partial for toolbar buttons
    buttons: reorder_toolbar

The configuration options listed below can be used.

Option Description
title used for the page title.
nameFrom specifies which attribute should be used as a label for each record.
modelClass a model class name, the record data is loaded from this model.
toolbar reference to a Toolbar Widget configuration file, or an array with configuration.

Displaying the reorder page

You should provide a view file with the name reorder.htm. This view represents the Reorder page that allows users to reorder records. Since reordering includes the toolbar, the view file will consist solely of the single reorderRender method call.

<?= $this->reorderRender() ?>

Override Sortable Partials

If you need to override default view of your reorder page, you have to copy

  1. modules/backend/behaviors/reordercontroller/partials/_container.htm
  2. modules/backend/behaviors/reordercontroller/partials/_records.htm

in

  1. plugins/yournamespace/yourplugin/yoursortablecontroller/_reorder_container.htm
  2. plugins/yournamespace/yourplugin/yoursortablecontroller/_reorder_records.htm

Extending the model query

The lookup query for the list database model can be extended by overriding the reorderExtendQuery method inside the controller class. This example will ensure that soft deleted records are included in the list data, by applying the withTrashed scope to the query:

public function reorderExtendQuery($query)
{
    $query->withTrashed();
}

Next: Importing & Exporting

Previous: Relations