Laravel Eloquent: Set relationships only if related data exists

Question

I have some Eloquent models with relations to each other, but I want these relations to be set only if related data exists.

For example:

Department (Model) -> hasMany -> Worker (Model) (Relation should be set only if the department has related workers, otherwise not set)

Is it possible ? I tried this and failed horrably: (in Department Model)

public function worker() {

     $model = new Department();

     if(isset($model->relations)) {
         return $this->hasMany(Worker::class, 'wrk_department_id');
        }
    }

//EDIT:

When department has no workers my output is like:

{
"data": {
    "type": "department",
    "id": "8",
    "attributes": {
        "accessory": [],
        "department": "Marketing",
        "department_id": 8,
        "dept_floor_id": 2,
        "inventory": [],
        "software": [],
        "worker": []
    },
    "links": {
        "self": {
            "href": "http://127.0.0.1:8000/api/v2/department/8"
        }
    }
},
"links": {
    "self": {
        "href": "http://127.0.0.1:8000/api/v2/department/8"
    }
},
"jsonapi": {
    "version": "1.0"
}

}

When department has workers, everthing works as expected:

{
"data": {
"type": "department",
"id": "1",
"attributes": {
  "department": "Entwicklung",
  "department_id": 1,
  "dept_floor_id": 3
},
"links": {
  "self": {
    "href": "http://127.0.0.1:8000/api/v2/department/1"
  }
},
"relationships": {
  "worker": {
    "data": [
      {
        "type": "worker",
        "id": "5"
      },
      {
        "type": "worker",
        "id": "8"
      },
      {
        "type": "worker",
        "id": "11"
      },
      {
        "type": "worker",
        "id": "13"
      }, //and so on

i'm trying to get rid of the empty arrays (eg.: "worker":[]), which appear when their is no related data

What are you trying to achieve? Get only departments with workers in it or something else? — Alexey Mezenin, Jan 18 '17 at 12:29
Your output governs by the query you use. Not by what you define in your `model`. — Gayan, Jan 18 '17 at 12:53

score 1 · Answer 1 · answered Jan 18 '17 at 12:53

1

Just add the relationship and filter the collection down to only those containing workers, like this:

$departments = Department::with('workers')->filter(function($department) {
        return ! is_null($department->workers)
    });

This way you only have the departments that contain at least one worker.

answered Jan 18 '17 at 12:53

Matthias Weiß

508
7
17

Thanks! Works perfectly, just like the solution Gayan provided – Moritz Büttner Jan 18 '17 at 14:27

score 1 · Accepted Answer · answered Jan 18 '17 at 13:06

1

In Department model add the relationship.

public function worker() {
    return $this->hasMany(Worker::class, 'wrk_department_id');
}

And when you query inside you method in your-controller.

$builder = Department::with('other-relationships');
If('your-condition-check') {
     $builder-with('workers');
}
$model = $builder->get();

This is the concept. Use appropriate code for your scenario.

answered Jan 18 '17 at 13:06

Gayan

3,614
1
27
34

i marked it as accepted. but unfortunately i can't upvote due to lack of reputation points, sorry :( – Moritz Büttner Jan 18 '17 at 14:44

Laravel Eloquent: Set relationships only if related data exists

2 Answers2