Questions tagged [laravel-query-builder]

The database query builder provides a convenient, fluent interface to creating and running database queries in Laravel apps. It can be used to perform most database operations in your application, and works on all supported database systems.

1522 questions
-2
votes
2 answers

Does DB raw sum function help optimized data?

In the application, we have a feature where it will display all the years as tab. Each tab has amount(where the amount is the summarized) but at the same time it is have data. Scenario Just to give a background about the application, it is a car…
Angel
  • 966
  • 4
  • 25
  • 60
-2
votes
1 answer

Case statement with withCount in Laravel

How do I achieve this kind of query in Laravel? Model::query() ->select('id') ->withCount(['relation_1', 'relation_2', 'relation_3']) ->selectRaw( '(CASE WHEN relation_1_count < 0 THEN "relation 1 failed" WHEN…
Suresh Hemal
  • 40
  • 1
  • 5
-2
votes
2 answers

Query database table

I have a table where I save plays for players over a specific game on it. the game has different levels. the player can play the same level multiple times. I need to query that table to count the number of levels that a specific player played today…
Bebo
  • 5
  • 2
-2
votes
1 answer

How to retrieve records by as a range (As1-As10) in laravel?

is there any possibility to retrieve records as a range.For an example there is a table with column as ref_numbers.Sample values for the ref_numbers are A1,A2,A3,A4....AB1,AB2,AB3,AB4... I want to retrieve the records of specific range starting…
-2
votes
1 answer

how to convert SQL query in Laravel Query Builder

SQL Query is SELECT *, ( SELECT COUNT(*) FROM `users_data` WHERE `users_data`.`role` = `user_role`.`role_id` ) AS `total_users` FROM `user_role` WHERE `user_role`.`role_type` = 'USER' ORDER BY…
-2
votes
1 answer

How to do a JOIN ON CASE with laravel query builder?

Is there a way to translate the following syntax to laravel query builder? SELECT * FROM table_1 INNER JOIN table_2 ON table_1.id = table_2.id INNER JOIN table_3 ON (CASE WHEN {some condition} THEN table_1.id ELSE table_2.id END) =…
Mark Adel
  • 223
  • 1
  • 10
-2
votes
1 answer

Laravel: Query builder

Might be stupid question, how to correctly state the ID in select statement? public function generatefinalconfirmation($id) { $booking = Booking::findOrFail($id); $flightin = DB::select('SELECT b.bookingname, f.origin FROM Bookings B…
doom
  • 11
  • 1
  • 3
-2
votes
2 answers

Laravel: Array to String

It is my code in which I get the subcategories' names. But the problem is it shows data in an array form. $couponCategory = Coupon::select('categories')->where('expiry_date', '>', $dt)->where('status', 1)->first(); $couponsCat = explode(',',…
Muqadar Ali
  • 57
  • 2
  • 11
-2
votes
1 answer

How to get ordered this sql query

comments table comments table stars table stars table i write this query: (for ordering sites by most stars_sum) $comments->join('stars', 'comments.star_id', '=', 'stars.id'); $comments->selectRaw('comments.site_id as site_id, comments.id as…
-2
votes
1 answer

Laravel query builder search by status

In my project, the user can filter the data according to 3 criteria (declared, in progress, finished). I pass string, in the url parameters [-1,0,1], in order to obtain the active filters. the statuses are defined according to several data coming…
Larave
  • 13
  • 2
-2
votes
1 answer

Variable inside laravel query builder is always null

Im trying to find the users that has commented the product this way: public function getUserToRate(Product $product) { $userIds = DB::table('product_ratings')->where('product_id', $product->id)->pluck('user_id'); return $userIds; } But the…
Alberto
  • 61
  • 1
  • 9
-2
votes
2 answers

Convert raw SQL query to Laravel DB builder query

I need help converting the following raw query into a Laravel query using the DB query builder. The query must be built using the DB (facade) query builder and not Eloquent. SELECT distinct p.client_id FROM people p JOIN (SELECT client_id,…
Riz
  • 71
  • 2
  • 10
-2
votes
1 answer

How to Convert this Query to Eloquent or Query Builder?

I have a query like this. How should I convert it into a eloquent or query builder SELECT x.MATERIAL_ID, (SELECT TAPET_NAME FROM MA_TAPE_TYPE WHERE TAPET_CODE = x.MATERIAL_TYPE) as media_type, (SELECT TAPEF_NAME FROM MA_TAPE_FORMAT WHERE TAPEF_CODE…
elfishy97
  • 1
  • 1
-2
votes
1 answer

find nearest location using lat and long in laravel query bulider

$lat = isset($request->lat) ? $request->lat : ''; $lng = isset($request->lng) ? $request->lng : ''; $query = Vehicle::query(); $query->whereHas('vendor', function($q) use($lat, $lng){ $q->where('vendor_status', 1); if((isset($lat) && $lat…
divakar
  • 61
  • 2
  • 10
-2
votes
1 answer

How to make tree joins at the same time with Laravel Query Builder?

I tried to make tree joins with this code, but didn't work... $av = DB::table('rifcliente_filtro') ->join('clientes_incid', 'rifcliente_filtro.rif', '=', 'clientes_incid.rif', '=', 'incidencias.rif') ->where('clientes_incid.cat_cliente',…
1 2 3
99
100