I need to make an advanced query in Laravel hopefully using Eloquent to make that a collection but a query builder or raw normal SQL query is acceptable. I have users table with User model having relation: public function roles()…
I want to display the sum total of all credit activities in a user account as his main account balance. I have three different wallet, bonus, referral and deposit and will like to sum up all of them together. This…
I have made a category and a posts table. On post table I'm storing the category id's in the JSON format on posts table. Now, I would like to get total count of posts for each category where categories are…
I'm trying to implement an efficient search on street names. A street has multiple residences (houses). The search I'm trying to build is street names LIKE %example% within the given city_id. The result must include the LIKE list of matching…
I have the following query params in string format $query = '->whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request('startTime'), request('endTime')])'; How do i pass it to the eloquent? Am trying to achieve something like this InboundMessage::query()->{$query}; Am getting the error below Property [->whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request('startTime'),…
I have this query and works fine: SELECT id_categoria, categorias.descricao_categoria, MAX(CASE WHEN month(data_compra) = 1 THEN valor ELSE NULL END) as Jan, MAX(CASE WHEN month(data_compra) = 2 THEN valor ELSE NULL END) as Fev, MAX(CASE WHEN month(data_compra) = 3 THEN…
My system has 2 xampp's one with PHP 5.6 and the other with PHP 7.3. I have correctly included both the PHP versions in environment variables. I am trying to connect my laravel v5.8 application with mongodb v4.2. I have…
i have a problem, how to get there are multiple in database values. I used this method it didn't work : Route::get('/users/{id}', function ($id) { $user = User::where('id', [$id])->get(); return $user; }); I used this method successfully : Route::get('/users/{id}', function…
I am trying to select some data from two tables, here is sql code `SELECT users.name FROM users, friends WHERE super_admin= false and friends.friend_id=users.id and friends.user_id = 4 and friends.status= 1` I used sql to eloquent converter and it returns…
I am trying to use multiple Count and Sum commands in a single query. However what is happening is when i use the following: SUM(amount AND type = "dispute") as charge It actually counts the amount of records and does…