Here is an example of Laravel command: class TestUserCommand extends Command { protected $signature = 'test:user'; protected $description = 'Command description'; public function handle(): void { auth('api')->loginUsingId(1); ... domain service call } } It gives me the following error: Method…
I'm trying to seed random belongsTo relationships for a Post, but they are all just being created with the same User and Community. Code: $users = AppModelsUser::factory(100) ->create(); $communities = AppModelsCommunity::factory(10) ->create(); AppModelsPost::factory() ->for($users->random()->first()) ->for($communities->random()->first()) ->create(); After seeding, when I…
I have a table in my db that looks like this: Col 1 Col 2 John 230601 Frank 230601 Tom 230604 Bill 230604 Tina 230604 Leroy 230602 Ernie 230601 Sue 230601 I want to get all rows with the max…
I have two models named: Subject and Group, Subject has a group_id column with a foreign key setup to point to the groups' table. When I call $subject->group it returns null; it should return the Group model that the Subject…
I have a string with the following format: $data = "sku=32300905,color=Dark Brown|sku=32300899,color=Blue|sku=32300900,color=Grey|sku=32300914,color=light Brown"; And I want to transform this string into an array of associative arrays as shown below: Array ( [0] => Array ( [sku] => 32300905 [color] =>…
I am currently using a laravel project with docker, I don't understand but when I start docker using docker-compose up -d All is working good and very weel my container started and I can use it with my postgres database.…
Drawing a blank here as I have been out of the game for some time and busy on a new application. Objective: Send a newly registered user a welcome message with a modal when he logs in for the first…
I have a controller in my API that contains methods that fetches various data from different tables like account statuses, account types, etc and returns it to the API consumer. use AppModelsAccountStatus; use AppModelsAccountType; use AppModelsAlertLevel; class ClientController extends Controller…
I have a Laravel application with a simple multi-tenancy set-up. Every User belongs to an Account, and the User has an AccountScope; e.g. whenever a User is queried (User::where('name', 'like', "%query%")->get()) they will always be filtered on the logged-in user's…
SELECT team_name, (CASE WHEN `assignment` = 'Appeal/Recon/Claim Review' THEN `done` ELSE 0 END) AS 'Appeal', (CASE WHEN `assignment` = 'IDR' THEN `done` ELSE 0 END) AS 'IDR' FROM operation_assignments WHERE serial = 6 GROUP BY team_name $collections = DB::table('operation_assignments') ->select(…