Member Since 2 Years Ago
2,940 experience to go until the next level!
In case you were wondering, you earn Laracasts experience when you:
Earned once you have completed your first Laracasts lesson.
Earned once you have earned your first 1000 experience points.
Earned when you have been with Laracasts for 1 year.
Earned when you have been with Laracasts for 2 years.
Earned when you have been with Laracasts for 3 years.
Earned when you have been with Laracasts for 4 years.
Earned when you have been with Laracasts for 5 years.
Earned when at least one Laracasts series has been fully completed.
Earned after your first post on the Laracasts forum.
Earned once 100 Laracasts lessons have been completed.
Earned once you receive your first "Best Reply" award on the Laracasts forum.
Earned if you are a paying Laracasts subscriber.
Earned if you have a lifetime subscription to Laracasts.
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.
Earned once you have achieved 500 forum replies.
Earned once your experience points passes 100,000.
Earned once your experience points hits 10,000.
Earned once 1000 Laracasts lessons have been completed.
Earned once your "Best Reply" award count is 100 or more.
Earned once your experience points passes 1 million.
Earned once your experience points ranks in the top 50 of all Laracasts users.
Replied to AddSelect Not Working As I Think It Should
Thank you so much. Overextended and sleep-deprived dad here.
It's working for a dump and die but it's maxing out memory and giving me a WSOD when trying to load the page. Should I look at pulling some of this out into scopes to clean this up?
Started a new Conversation AddSelect Not Working As I Think It Should
Let me preface this by saying SQL isn't my strong suit and I'm still trying to wrap my brain around the subquery capabilities in Laravel 6.
When I run the query below I end up with a 1054 error (SQLSTATE[42S22]: Column not found: 1054 Unknown column 'addresses.address' in 'field list')
$inspections = DB::table('inspections') ->join('clients', 'inspections.client_id', 'clients.id') ->join('contacts', 'inspections.client_id', 'contacts.id') ->join('jobs', 'inspections.job_id', 'jobs.id') ->join('staff', 'inspections.inspector_id', 'staff.id') ->addSelect(['phone' => Phone::select('phone_type', 'phone_number') ->whereColumn('phoneable_id', 'inspections.client_id') ->orderBy('phone_type', 'desc') ]) ->addSelect(['address' => Address::select('address', 'city', 'state', 'zip', 'country') ->whereColumn('addressable_id', 'inspections.client_id') ->where('address_type', 'Location') ]) ->select( 'inspections.id', 'inspections.client_id', 'clients.name', 'contacts.email', 'inspections.scope', 'inspections.gps', 'jobs.new', 'jobs.new_land', 'jobs.new_crop', 'jobs.priority', 'inspections.inspector_id', 'staff.first_name', 'staff.last_name', 'inspections.inspection_at', 'inspections.confirmed', 'addresses.address', 'addresses.city', 'addresses.state', 'addresses.zip', 'addresses.country', 'phones.phone_type', 'phones.phone_number' ) ->get();
Any idea what I'm doing wrong and ways I could make this query more efficient?