User table inheritance in OctoberCMS

Question

I have two users: teachers and students, each of them has different attributes. For example: student has one class, teacher has many classes, etc.
I would like to inherit OctoberCMS Users plugin, and add two controllers with these additional attributes (one for students and another for teachers). So, I've created two models extending user model. these 2 models use the same users table, and I added two tables for teachers and students, but I can't link them with the user table.
This is what I did:

class Teacher extends User 
{
  public $hasOne=[
    'mobile'=>'??',
  ]
}

So, I want to add a mobile field and other fields to every teacher in the teachers table, how can I do this?
Please note that I don't want to add fields to the users table. I want the shared columns in user table, teacher additional fields in teacher table, and student additional fields in students table.

Behiry Behiry · Accepted Answer · 2018-03-16T16:15:54

Well, This is the solution I get:
1- Add the additional fields of teachers and students to the users table.
2- Let the teacher and student models extend the user model
3- Add a function to each model to add user group (teacher or student) before saving.
4- Apply a filter on the controllers of teachers and students to list only them groups.

This is the full code:

class UserAddFields extends Migration
{
public function up()
{
    if (Schema::hasColumn('users', 'mobile')) {
        return;
    }

    Schema::table('users', function($table)
    {
        $table->string('mobile', 100)->nullable();
        $table->integer('class_id', 100);
    });
}

}


class Teacher extends User
{
public $belongsToMany = [
    'groups' => [UserGroup::class, 'table' => 'users_groups', 'key' => 'user_id', 'otherKey' => 'user_group_id']
];

public function beforeCreate()
    {
            $this->groups=UserGroup::where('code','teachers')->first();
    }           
}

class Teachers extends Controller
{
public function listExtendQuery($query)
    {
            $query->whereHas('groups', function ($q){
                $q->where('code', '=', "teachers");
            });
    }
}

and the same for students.

User table inheritance in OctoberCMS

3 Answers