I have class People extends Model { public function invoices() { return $this->hasMany(Invoice::class)->orderBy('date', 'desc'); } } ... class Invoice extends Model { public function person() { return $this->belongsTo(People::class, 'people_id'); } public function latestInvoice(){ return $this->hasOne(Invoice::class)->latestOfMany(); } } ... class Clerk…
I have a post table that has a many to many relationship with a category table, and of course a pivot table between both. I'm trying to get all posts that match exactly with an array of categories, example: category_array…
We have three tables. Get the Last Attendance Date from the attendance table of every user using eloquent relation users and user_attandance table users id - integer name - string attendance id - integer date - date user_attandance id -…
I need to find all results that include this substring (note the leading zero): $code = '02549'; Nomenclature::where('code', 'like', '%' . $code . '%')->get(); With such a builder, I get the correct request: select * from `nomenclatures` where `code` like…
I want to search if a user submitted comment contains comma separated bad words in the database. Table bad_word: id words 1 foo bar, fooBar 2 aaa bbb, ccc ddd I'm using the following code but it only work for…
I have multiple many-to-many relationships and i want to filter through them. The models are: State District I attached an screenshot: (https://i.stack.imgur.com/TJPwp.png) States are Alabama and Arizona, Districts are Autaga, Baldwin and Apache When i check Alabama and Arizona the…
I want to remove old images in my public folder when he want to change him profile photo. ProfileController: if($request->hasFile('image')){ $request->validate([ 'image' => 'image|mimes:jpeg,png,jpg,svg|max:2048' ]); $imageName = $request->user()->id.'-'.time().'.'.$request->image->extension(); $request->image->move(public_path('users'), $imageName); $path = "users/".$imageName; $request->user()->image = $path; $request->user()->save(); } i tried…
I have like this migration file: Schema::create('posts', function($table) { $table->engine = 'InnoDB'; $table->increments('id')->unsigned(); $table->string('title'); $table->text('description')->nullable(); $table->integer('sort_order')->default(0); $table->boolean('status')->default(0); }); And I have also seeder: class SeedPostsTable extends Seeder { public function run() { $posts = $this->getPosts(); foreach ($posts as $title =>…
I'm developing an application where a User can be of type Admin, Client, Supplier or Manager. Each type (except Admin) has it's own model with respective data, and related with a user_id. For example: users - id - name -…
I have two mysql table with HasMany/belongsTo relation like this : public function Products() { return $this->hasMany(Prices::class, 'product_id'); } public function Prices() { return $this->belongsTo(Products::class); } If i do the following function, i can get the latest price for every…