So I'm currently struggling with my AlbumController's store function, where i need to store an album in my albums table, including the indexes of the pictures selected to be included in the album, in which the pictures included are then…
Laravel docs recommends using attempts to deal with Deadlocks (https://shorturl.at/bsKta) But, the handleTransactionException() method inside the transaction() method has a comment: On a deadlock, MySQL rolls back the entire transaction so we can't just retry the query. We have to…
When accessing model attrs inside relation logic in laravel the attrs are all null when eager loading, if lazy loading it works fine. Model relation : public function organization() { return $this->belongsTo(Organization::class, 'organization_id'); } public function currentOrder() { // Note…
I have an ApplicationCrudController that has a default view, and a custom view called "Simplified View" inside the list setup function. However, when I tried to apply my filters when I am in "Simplified View", I always get redirected back…
Anyone knows why this query is returning error? I'm using Laravel Sail with Mysql version: 8.0.32, it should work: Property::select(DB::raw(" properties.id, properties.company_id, properties.title, properties.slug, properties.neighborhood, properties.city, properties.address, properties.number, properties.property_purpose, properties.property_type, properties.total_area, properties.usefull_area, properties.bedrooms, properties.bathrooms, properties.garage, properties.sell, properties.rent, properties.administration_fee, properties.yearly_tax, property_highliteds.hightlight,…
I would like to cleanup the locally seeded storage images when running php artisan migrate:fresh --seed. I noticed that all the database tables get dropped before the seeders even start. So my method for cleaning up local storage images was…
I have a model with QR codes that has a field called type. This field can have two values: 1 (Plate) or 2 (Sticker). I could simply create an enumeration of these types as an array in the model and…
I have a fairly common setup - 2 main models and 1 pivot with additional information regarding their relationship. I'm using Laravel API Resources and they work great, but I can't figure out a way how to display the data…
I'm working on a project using Laravel v9.19 and PHP 8.0. Here is a part of that project's database which is relevant to the question: One user can have many orders, but each order has only one user (one-to-many relationship).…
I am developing a database for giveaways. I have two main tables: participants and giveaways with an N:N relationship since a participant can participate to one or more giveaways and a giveaway can have one or more participants. My (simplified)…