luyadev/luya

<?php

namespace luya\traits;

use yii\db\ActiveQuery;

/**
 * Trait to us within ActiveRecords to get next and prev (previous) model records of the current
 * ActiveRecord object model.
 *
 * @author Basil Suter <basil@nadar.io>
 * @since 1.0.0
 */
trait NextPrevModel
{
    /**
     * Get the next actrive record of the current id
     *
     * @return ActiveQuery
     */
    public function getNext()
    {
        return self::find()->where(['>', 'id', $this->id])->limit(1)->one();
    }

    /**
     * Get the previous record of a current id
     *
     * @return ActiveQuery
     */
    public function getPrev()
    {
        return self::find()->where(['<', 'id', $this->id])->orderBy(['id' => SORT_DESC])->limit(1)->one();
    }
}