ruudvangeelen

ruudvangeelen

Member Since 1 Year Ago

Experience Points
160
Total
Experience

4,840 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
0
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
160 XP
Feb
14
1 week ago
Activity icon

Replied to Change $table Var Before Executing Static Method

Thanks! No; im just starting.

The external app is using the 2019 and 2020 data for stats. Now we are building a "quick report" (preview) to view 2019, 2020 stats (using a html select).

Activity icon

Replied to Change $table Var Before Executing Static Method

Sure there is another way; but for now:

$orders = new \App\Orders;
$orders->setTable('orders_2019');
$orders2019 = $orders->where('User_id', 112)->get();
Activity icon

Replied to Change $table Var Before Executing Static Method

Thanks. It wont override the $table var. The table var is 2019 and if i leave it emtpy:

public $table = '';

It says:

SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '' (SQL: select * from ``)

Activity icon

Replied to Change $table Var Before Executing Static Method

Hi Sinnbeck. Now i got this; which is ofcourse logically:

Non-static method Illuminate\Database\Eloquent\Model::setTable() should not be called statically

Activity icon

Started a new Conversation Change $table Var Before Executing Static Method

Hi,

I have a "Orders" modal with a "orders_2019" table. Now in 2020 we have (ofcouse) the "orders_2020" table. The reason why is that we use external software; this software connects directly to MySQL to request all 2019 and/or 2020 records. Unfortunately the softwware is unable to filter on year.

In my Laravel app i also want to switch between 2019 and 2020. I've set the constructor of my Orders modal as follows:

public function __construct()
{
    $this->table = 'orders_2019'; // or 'orders_2020'
}

The moment i do "\App\Orders::all()" this will return 2019 or 2020 depending on the constructor.

BUT .. i have to set the constructor value manually. The question is; how can i automate this? I would be handy to pass a parameter to the constructor (?) or something like this:

\App\Orders::setTable('orders_2020');

$orders = \App\Orders::all();

and for 2019

\App\Orders::setTable('orders_2019'); \App\Orders::all();

Who can help me?