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…
In Laravel, I have a model called FeatureRequest that can be voted on, thus creating a FeatureVote in a separate database table. A single FeatureRequest can have many FeatureVotes. I want to execute a query that: Excludes users' own feature…
I need to update every row of my table associated with the model MyModel. Each update requires PHP code to be executed. In my case it is not a problem, but I wondered how to do this more efficiently? MyModel::chunk(1000,…
I have model with the following primary key use HasFactory, SoftDeletes; protected $table = 'requests'; protected $primaryKey = ['request_id', 'user_id']; public $incrementing = false; protected $keyType = 'string'; protected $fillable = [ 'request_id', 'user_id', ]; protected $hidden = [ 'created_at',…
Is it possible to make eloquent generate a query with a WHERE clause precisely like the example in the title? The closest I got was with Where() and orWhere(), but that outputs (column_1 IS NOT NULL OR column_2 IS NOT…
I'm working in a Laravel 10 project and need to just return tier's where each tier's options matches some criteria. Right now I need to do it based on a column called type. For reference, I only have 2 entries…