json

json

Member Since 4 Years Ago

Experience Points
125
Total
Experience

4,875 experience to go until the next level!

In case you were wondering, you earn Laracasts experience when you:

  • Complete a lesson — 100pts
  • Create a forum thread — 50pts
  • Reply to a thread — 10pts
  • Leave a reply that is liked — 50pts
  • Receive a "Best Reply" award — 500pts
Lessons Completed
1
Lessons
Completed
Best Reply Awards
0
Best Reply
Awards
  • start-engines Created with Sketch.

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • first-thousand Created with Sketch.

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • 1-year Created with Sketch.

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • 2-years Created with Sketch.

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • 3-years Created with Sketch.

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • 4-years Created with Sketch.

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • 5-years Created with Sketch.

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • school-session Created with Sketch.

    School In Session

    Earned when at least one Laracasts series has been fully completed.

  • welcome-newcomer Created with Sketch.

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • full-time-student Created with Sketch.

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • pay-it-forward Created with Sketch.

    Pay It Forward

    Earned once you receive your first "Best Reply" award on the Laracasts forum.

  • subscriber-token Created with Sketch.

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • lifer-token Created with Sketch.

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • lara-evanghelist Created with Sketch.

    Laracasts Evangelist

    Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.

  • chatty-cathy Created with Sketch.

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • lara-veteran Created with Sketch.

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • 10k-strong Created with Sketch.

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • lara-master Created with Sketch.

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • laracasts-tutor Created with Sketch.

    Laracasts Tutor

    Earned once your "Best Reply" award count is 100 or more.

  • laracasts-sensei Created with Sketch.

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • top-50 Created with Sketch.

    Top 50

    Earned once your experience points ranks in the top 50 of all Laracasts users.

Level 1
125 XP
28 Jul
4 years ago

json left a reply on Deeply Nested Relationships

@bobbybouwmann Yes that is one of solutions :) But Fluent only supports MySQL database as I understood, and that's why I was using Eloquent and hoping to resolve this problem in the same style.

27 Jul
4 years ago

json left a reply on Deeply Nested Relationships

@bobbybouwmann Thanks for replying.

My problem is that I cannot make those additional conditions like you wrote in the second part. $value should be kind of dynamic and it depends on parent relationship.

For example, I need (where) condition for table 'offers' which would filter by foreign key related to the 'team_user' id.


{
"ID": "123",
"name": "Test project",
"test": null,
    "teams": [
    {
    "ID": "12",
    "project_id": "123",
    "name": "Test team",
        "users": [
        {
        "ID": "1",
        "firstname": "John",
        "lastname": "Doe",
        "pivot": {
                "ID": "10",
                "team": "12",
                "user": "1",
                "team_role": "3",
                }
        },
        "offers": [
                    {
                    "ID": "111",
                    "team_user": "10"
                    },
                    {
                    "ID": "222",
                    "team_user": "20"
                    },
                ]
        }
    ]}
}

So basically I need to filter all offers that I'm getting and get (e.g.) the one with ID 111 which should be filtered by "team_user" as foreign key.

I hope my message is not too complicated :)

25 Jul
4 years ago

json started a new conversation Deeply Nested Relationships

Hello everyone,

Recently I faced problem accessing and filtering deeply nested relationship, so I decided to seek for a help.

So, I have this db structure: structure

And I need to get all teams within a project, and then for each team I need to get assigned users (of that team).

So far so good, my problem starts when I try to get the offer for each user. User can have only one offer for the assigned team which brings me to a problem.

Here is my code:

$project = Project::with("variants")
                    ->with(array(
                            "teams" => function($query) {
    
                                $query->with(array(

                                    "users" => function($query) {

                                        $query->with("offers");
                                    }
                                ));
                                
                            }
                        ))
                    ->find($projectID);

I have a hasManyThrough relationship "offers" in the "User" model which returns me all offers for user, but actually I just need (one) offer for related team_user table.

I tried filtering offers with scopes but it's a bad solution, because for each user I have additional query to db..

Is there some way to filter these offers dynamically? Thanks!