Ad

Call To Undefined Relationship [pointage] On Model [App\Salarie]?

- 1 answer

I want to display the POINTAGE, and SALARY table data from ControllerSalarie, but it gives me this error

Pointage Model

public function salarie()
{
    return $this->belongsTo('App\Salarie');
}

Salarie Model

public function pointages()
{
    return $this->hasMany('App\Pointage');
}

migration migration salarie_id

 /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('pointages', function (Blueprint $table) {
            $table->integer('salarie_id')->unsigned()->after('id');
            $table->foreign('salarie_id')->references('id')->on('salaries');  
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('pointages', function (Blueprint $table) {
             $table->dropForeign(['salarie_id']);
            $table->dropCulomn('salarie_id');
        });
    }

SalarieController

public function consulter()
{      
    $salaries=Salarie::with('pointage')->get();
    $pointages = DB::table('pointages')->pluck("pointage","id")->all();
    return view('salarie.consulter', compact('salaries', 'pointages'));
}
Ad

Answer

change:

$salaries=Salarie::with('pointage')->get();

to:

$salaries=Salarie::with('pointages')->get();
Ad
source: stackoverflow.com
Ad