I'd like to insert the user-id of the current user into a table in column "user_id". The field is a relation to the user table. Migration / database schema Schema::create('pdlocations', function (Blueprint $table) { $table->id(); $table->timestamps(); $table->decimal('lon', 10, 7); $table->decimal('lat',…
I have a model Product, and the same product can be sold by multiple supermarkets and outlets, so I define two BelongsToMany relationships for them: class Product extends Model { public function supermarkets(): BelongsToMany { return $this->belongsToMany( Supermarket::class, 'product_supermarket', 'product_id',…
I wanted to convert my Cakephp to Laravel 10. Here in Cakephp 2.x $sql = [ 'fields' => [ 'Student.name', 'Room.id' ], 'joins' => [ 'use index(course)', [ 'table' => 'rooms', 'alias' => 'Room use index(weekday, semester, year)', 'type' =>…
I have this Array of objects where I wanna sum up the quantity having the same 'barcode' field and if it has a different 'location' field it should be separated. here is my sample object [ { "id": 1, "barcode":…
I've got this function: public function getOverdue() { $jobs = Job::where('RequiredTime', '<', Carbon::now()->addDays(10)->endOfDay()) ->where('JobCancelled', '=', 0) ->where('JobCompleted', '=', 0) ->where('Ref9', '=', null) ->where('CreateDateTime', '>=', Carbon::now()->startOfMonth()) //->groupBy('RequiredTime') ->orderBy('RequiredTime', 'asc') ->get(); return view('pages.dispatch.overdue', [ 'title' => 'Overdue', 'page' => 'Overdue', 'js_action' =>…
I want to fetch data from the database using laravel by using multiple conditions. The query must look for the different conditions in same columns and grab the result. Table looks like this Item Position Gender A All All B…
On laravel 10 site I have 3 related tables : Schema::create('users', function (Blueprint $table) { $table->id(); $table->string('name'); ... $table->timestamp('created_at')->useCurrent(); }); Schema::create('tasks', function (Blueprint $table) { $table->id(); $table->foreignId('creator_id')->references('id')->on('users')->onUpdate('RESTRICT')->onDelete('CASCADE'); $table->boolean('completed')->default(false); ... $table->timestamp('created_at')->useCurrent(); $table->timestamp('updated_at')->nullable(); }); Schema::create('task_user', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('user_id')->unsigned()->index(); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');…
I have two tables that are connected with a pivot table. shows: +----+--------+ | id | show | +----+--------+ | 1 | show1 | | 2 | show2 | | 3 | show3 | +----+--------+ draft_types: +----+--------+ | id |…
I need help with my laravel 11 project. I have a table which acts as a morph table which would work with morphedByMany. But for this particular model I only need to retrieve one entry. My tables are: Site, Domain…
I'm encountering an issue with whereFullText in Laravel. Here's my code: $search_key = $args['q'] ?? $args['search_key'] ?? NULL; $builder->when($search_key, function (Builder $builder, $search_key) { $builder->whereFullText(self::fullTextColumns(), $search_key . self::WILDCARD, [ 'mode' => 'boolean', // [ natural, natural language, query expansion, boolean…