fl0rian

fl0rian

Member Since 5 Years Ago

Experience Points 16,540
Experience Level 4

3,460 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 192
Lessons
Completed
Best Reply Awards 0
Best Reply
Awards
  • Start Your Engines Achievement

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • First Thousand Achievement

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • One Year Member Achievement

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • Two Year Member Achievement

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • Three Year Member Achievement

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • Four Year Member Achievement

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • Five Year Member Achievement

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • School In Session Achievement

    School In Session

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

  • Welcome To The Community Achievement

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • Full Time Learner Achievement

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • Pay It Forward Achievement

    Pay It Forward

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

  • Subscriber Achievement

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • Lifer Achievement

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • Laracasts Evangelist Achievement

    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 Achievement

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • Laracasts Veteran Achievement

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • Ten Thousand Strong Achievement

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • Laracasts Master Achievement

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • Laracasts Tutor Achievement

    Laracasts Tutor

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

  • Laracasts Sensei Achievement

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • Top 50 Achievement

    Top 50

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

16 Dec
3 months ago

fl0rian left a reply on How To Establish A Relationship?

Thanks for the Tip. i ve put this in my bookmarks

fl0rian left a reply on How To Establish A Relationship?

@robertmarriott My first thought was the same as yours :-)

fl0rian left a reply on How To Establish A Relationship?

@robertmarriott if i did that, i would have a relatively large amount of data, which is almost 1:1 identical. It probably only happens to 0.01% that a material designation applies to different stone types.

fl0rian left a reply on How To Establish A Relationship?

Danke euch allen für die ausführlichen Antworten! Ich werde es versuchen so umzusetzen

fl0rian started a new conversation How To Establish A Relationship?

Hello, everybody, I'd like to make a relationship, but I don't know how to handle it. There are suppliers, materials and types of stone. A material name can belong to one or more stone types because different suppliers may assign a material name to different stone types. Although this will not happen in 99.5% of all cases, it will happen in particularly rare cases.

Do you have an idea for a good database design?

04 Dec
3 months ago

fl0rian left a reply on Laravel Nova File Field

Ok, i think i have to extend the file class... I will try it

fl0rian started a new conversation Laravel Nova File Field

Hello everyone,

i would like to receive the following path structure in the filesystem:

/{someCategorySlug}/{someHash}/{clientOriginalName}

And in the database:

{someCategorySlug}/{someHash}/{clientOriginalName}

or

{someHash}/{clientOriginalName}

in the path column.

The category is stored in the database in the form of a category_id in the uploads table. Therefore, the slug is not mandatory here.

Is this somehow possible with the file field from Laravel Nova? I dont get it.

I tried it with customizing the storage process, but without success.

01 Mar
1 year ago

fl0rian left a reply on Accessing Global "isVerified"

Oh, yes. Thats what the scopes are for. Perfect would be Company::whereUserIsVerified(), right?

And in the company model the verified scope?

fl0rian left a reply on Accessing Global "isVerified"

Yes, of course :-)

public function getCompaniesByBranch($branchId) { // Helper method $query = $this->whereUserIsVerified();

    $query->whereHas('branches', function($query) use ($branchId) {
        $query->whereIn('id', [$branchId]);
    });

    $query->orderBy('companies.created_at', 'DESC');

    if ($this->paginateResults)
    {
        $results = $query->paginate(Config::get('HV.company.paginatePerPage'));
    }
    else
    {
        $results = $query->get();
    }

    return $results;
}

private function whereUserIsVerified() { $query = Company::with('user');

    return $query->whereHas('user', function($query) {
        $query->where('verified', true);
    });
}

There are other queries like for example "getPopularCities"

28 Feb
1 year ago

fl0rian left a reply on Accessing Global "isVerified"

@bobbybouwmann thanks for your tips. At the moment i simply have one "isVerified" helper class in my repository, which returns the whereHas query. Multiple where statements in one whereHas sounds good.

@shez1983 i already have multiple scopes. But it does not change the problem that i have to repeat the whereHas statement multiple times.

fl0rian left a reply on Accessing Global "isVerified"

I have multiple scopes. For example "by city", "by branch", etc.

With whereHas i mean:

$query->whereHas('user', function($query) { $query->where('verified', true); });

fl0rian started a new conversation Accessing Global "isVerified"

Hello guys, probably its a trivial problem. I have an user model and some dependant company models. How can i access all companies, where the user is verified? I dont think i have to write each query with "whereHas".

Kind regards, Florian