I have Users. Some users (admins) manage accounts, defined via a account_user pivot table (account_id | admin_id). Some of these admins manage other "sub-users", defined via a user_management pivot table (account_admin_id | end_user_id). #1) I need to create an Eloquent…
I need a screen to be accessed both by those who have logged in and by visitors, however I wanted to use auth()->user() on this page to access the data, however if I use the auth middleware it does not…
I have a model with a connection parameter to a different database. class User extends Model { protected $connection = 'main_database'; } When I save the model the connection is returning to default application connection which is named "mysql". It…
I found a weird situation when nesting in a query a where with a orWhereNull. The result is returning rows with values that are neither null nor correct This is the code: $query = Document::where("active", true)->where("type_id", $document_type->id); if($selected) { $query->where(function($q)…
I want to create a nested JSON object, something like this: [ { "age": 8, "countAll": 3, "gender": [ { "genderName": "male", "countGender": 2 }, { "genderName": "female", "countGender": 1 }, ] }, { "age": 10, "countAll": 1, "gender": […
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' =>…