didotsonev · July 9, 2019 14:39 · Jul 9, 2019
diff --git a/Comapny.php b/Comapny.php
@@ -0,0 +1,19 @@
+    public function user()
+    {
+        return $this->belongsTo('App\Models\User');
+    }
+
+    public function projects()
+    {
+        return $this->hasMany('App\Models\Project');
+    }
+
+    public function pictures()
+    {
+        return $this->hasMany('App\Models\Picture');
+    }
+
+    public function noProjectPictures()
+    {
+        return $this->pictures()->whereNull('project_id');
+    }
diff --git a/Picture b/Picture
@@ -0,0 +1,14 @@
+    public function company()
+    {
+        return $this->belongsTo('App\Models\Company');
+    }
+
+    public function project()
+    {
+        return $this->belongsTo('App\Models\Project');
+    }
+
+    public function withoutProject($comapnyId)
+    {
+        return $this->where('comapny_id', $comapny_id)->whereNull('project_id')
+    }
diff --git a/Project.php b/Project.php
@@ -0,0 +1,9 @@
+    public function company()
+    {
+        return $this->belongsTo('App\Models\Company');
+    }
+
+    public function pictures()
+    {
+        return $this->hasMany('App\Models\Pictures');
+    }
diff --git a/User.php b/User.php
@@ -0,0 +1,4 @@
+    public function company()
+    {
+        return $this->hasOne('App\Models\Company');
+    }
diff --git a/index.blade.php b/index.blade.php
@@ -0,0 +1,6 @@
+Auth:user()->company->noProjectPictures();
+
+-----OR-----
+
+$pictures = new Picture();
+$pictures->withoutProject(Auth::user()->company->id);
No results found