Custom pivot model: order_column doesn't have a default value about eloquent-sortable

[bakerkretzmar]

Just wanted to share that I had the same question and I'm pretty sure I have it working. Laravel 5.8 added model events for pivot table models, so that event does fire now.

@esl51 it looks like you just didn't create the order_column column on your pivot table in the DB. This should work:

class CreateQuestionnaireAttributeTable extends Migration
{
    public function up()
    {
        Schema::create('questionnaire_attribute', function (Blueprint $table) {
            // ...
            $table->integer('order_column');
        });
    }
}

class Questionnaire extends Model
{
    public function attributes()
    {
        return $this->belongsToMany(Attribute::class, 'questionnaire_attribute')
                    ->using(QuestionnaireAttribute::class);
    }
}

class Attribute extends Model
{
    public function questionnaires()
    {
        return $this->belongsToMany(Questionnaire::class, 'questionnaire_attribute')
                    ->using(QuestionnaireAttribute::class);
    }
}

class QuestionnaireAttribute extends Pivot implements Sortable
{
    use SortableTrait;

    public $incrementing = true;
}

Now if you attach() any questionnaires and attributes to each other, the order column should be filled in correctly.

[esl51]

This event not firing on Pivot.

[freekmurze]

I believe we can't solve this error in this package.

If you do know a good solution, feel free to PR it.

[Sylk]

Now if you attach() any questionnaires and attributes to each other, the order column should be filled in correctly.

Hey @bakerkretzmar I'm just getting the following error following with what you've posted.

Call to undefined method App\Http\Controllers\BookController::fromRawAttributes()

[pokono]

On attach works fine, but it seems to loose references when calling moveOrderUp(), moveOrderUp(). etc.

SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'where clause' (SQL: update `course_module` set `order_index` = 2, `course_module`.`updated_at` = 2020-02-03 05:22:21 where `` = 56 and `` = 316)

The two where are missing foreignKey & relatedKey.

Any suggestions?