I have an inventory system with bins, lots, and transactions. Bin: has many lots Lot: belongs to a bin belongs to many transactions transaction_lot (pivot) - quantity Transaction: belongs to many lots Right now I have an attribute on Transaction…
I have the following test method in my model, it gets the length of a json column in a row: public function test(){ return $this->select(DB::raw('JSON_LENGTH((SELECT comments FROM lab_evals WHERE id='.$this->id.'))'))->get(); } In tinker it returns this: = IlluminateDatabaseEloquentCollection {#7430 all:…
As @JonasStaudenmeir answered on laravel eager loading with limit, which query looks like: User::select('id') ->with([ 'posts' => fn($query) => $query->select(['id', 'user_id'])->limit(4) ]) ->limit(2) ->get(); select `id` from `users` limit 2 select * from (select `id`, `user_id`, row_number() over (partition by…
Would reset hard uninstall a package? Say I have commits 789f658a6e55a65cc3f056asf – Commit before installing package 789fdfdsfse55a65cc3f056asf – Commit after installing package If I reset to “Commit before installing package” would that uninstall the package or just remove the line…
I have three models: Product Review Score They are linked like this: Product (hasMany) -> Review (hasOne) -> Score Review model: text product_id score_id Score model: value (number) My relation in Product model: public function reviews () { return $this->hasMany(Review::class,…
I noticed that in web.php I'm able to access find() of Listing model (that I created) Route::get('listings/{id}',function($id){ return view('listing',[ 'listing'=>Listing::find($id) ]); }); When I checked Listing model I found that it extends IlluminateDatabaseEloquentModelclass. But I couldn't locate find() there. On…
I am working in: Livewire 3, Laravel version is 10.10, PHP 8.2.4 I am trying to bind simple data with simple code but its not working, I am not sure why? Can you please help me? Livewire actions functions on…
I'm using Laravel 10 with Livewire 2. I was writing a simple test for a component, which is just an upload form. I ran into a cryptic message error: FAILED TestsFeatureLivewireUploadAssetTest > book can be saved correctly Type is not…
In my Laravel application, I set the login session settings and set 'expire_on_close' => true in config/session.php file so that if the user closes the browser, his session ends, and I also record when the user logged in for the…
I have a unique index on 3 fields: public function up(): void { Schema::create('items', function (Blueprint $table) { $table->id(); $table->foreignId('points_id'); $table->foreignId('user_id'); $table->unsignedTinyInteger('status'); $table->timestamp('created_at')->useCurrent(); $table->foreign('user_id')->references('id')->on('users'); $table->foreign('points_id')->references('id')->on('points'); $table->unique(['points_id', 'user_id', 'status']); }); } I need to make a factory to create a lot…