Questions[laravel-8]

I need to do a query using Eloquent on a couple of tables that are 1-to-many related and I'm not able to figure it out. Here is the code I am using:

$datos = Vigelectrodetenida::query()
    ->with('relUsr')
    ->where('cam1b', 'LIKE', '%' . $this->busquedas . '%')
    ->orWhere('cam1c','LIKE', '%' . $this->busquedas . '%')
    ->orderBy($this->campOrden, $this->direcOrden)
    ->paginate(20);

I use this code to generate a table that has a lookup input using livewire. For now, the queries I make on the cam1b or cam1c field work fine, but when I want to put another orWhere and have it act on the name field that is in the users table (relUsr) it stops working, it tells me that the name field. Next I put the code that I am using and the error that is being generated.

$datos = Vigelectrodetenida::query()
    ->with('relUsr')
    ->where('cam1b', 'LIKE', '%' . $this->busquedas . '%')
    ->orWhere('cam1c','LIKE', '%' . $this->busquedas . '%')
    ->orWhere('name','LIKE', '%' . $this->busquedas . '%')
    ->orderBy($this->campOrden, $this->direcOrden)
    ->paginate(20);

Well, I hope I have been able to convey my doubt correctly and that you can help me.

I want to thank @HeytalePazguato for his valuable help

I am doing a filter for the search engine in a section I have: table A and table B related by 1 to n. table A -> A_id(Primary)... table B->B_id(Primary),A_id(foreing),customerId(foreing)...

I access from table A to the data in table B via the model so I'm forced to use the model and I can't use a db::table because I have all the functionality implemented and would have to redo it.

The filter for the search engine is based on looking in table B for records that match the id that I pass and they would look in the clientId column so that it returns me the info from table A

Then I use that query to search table B and return the model related to table A in such a way that if the client is in two rows of table A, it returns those rows.

$consulta=A::where('A_id', function($consulta) use($request) {  $consulta->select('A_id')->from('B')->where('cliente_id', $request->cliente )->first();} )->paginate($this->numeroRegistrosPagina);

Currently this query fails if you remove first() it gives an error cardinality violation: 1242 Subquery returns more than 1 row because the subquery returns more than one row and it is normal since the clients can be in more than one row of the table A. So how can I fix this? Model B can be used since it also has the id of table A.

Thank you all

I have an application in Laravel 8 and I configured aws/aws-sdk-phpit to send email with SES and everything was working perfectly until I installed league/flysystem-aws-s3-v3.

The error is the following:

Error executing "SendRawEmail" on "https://email.sa-east-1.amazonaws.com";
AWS HTTP error: Client error: `POST https://email.sa-east-1.amazonaws.com` resulted in a `403 Forbidden` response: <ErrorResponse xmlns="http://ses.amazonaws.com/doc/2010-12-01/"> <Error> <Type>Sender</Type> <Code>AccessDenie (truncated...) AccessDenied (client): User `arn:aws:iam::684414359630:user/laravel_s3' is not authorized to perform `ses:SendRawEmail' on resource `arn:aws:ses:sa-east-1:684414359630:identity/[email protected]' - <ErrorResponse xmlns="http://ses.amazonaws.com/doc/2010-12-01/"> <Error> <Type>Sender</Type> <Code>AccessDenied</Code> <Message>User `arn:aws:iam::684414359630:user/laravel_s3' is not authorized to perform `ses:SendRawEmail' on resource `arn:aws:ses:sa-east-1:684414359630:identity/[email protected]'</Message> </Error> <RequestId>1721b50a-14b8-43ef-ae8b-173a2de0f295</RequestId> </ErrorResponse>

From what I can understand is that when sending an email it aws/aws-sdk-phpis taking the user created for league/flysystem-aws-s3-v3.

.envThe credentials for the two functionalities are saved in my file .

Foraws/aws-sdk-php

MAIL_MAILER=ses 
MAIL_HOST=email-smtp.us-east-1.amazonaws.com 
MAIL_PORT=587 MAIL_USERNAME=AKIAZ6WSGLB----UNOF 
MAIL_USERNAME=AKIAZ6WS-----UNOF (Usuario email_laravel en IAM)
MAIL_PASSWORD=BMdl/Up2WPWOFpfX+fsDn------9luDWSrYWVFtmtHTkR/ 
MAIL_ENCRYPTION=tls 
[email protected] 
MAIL_FROM_NAME="${APP_NAME}"

Forleague/flysystem-aws-s3-v3

AWS_ACCESS_KEY_ID=AKIAZ6WSG-----P4KH (Usuario Laravel_s3. en IAM)
AWS_SECRET_ACCESS_KEY=vv3NnsRc1------u8h1Ie6XyQoQC5nFRYwk6nPC
AWS_DEFAULT_REGION=sa-east-1
AWS_BUCKET=app-g12brasil-local
AWS_URL=https://app-g12brasil-local.s3.sa-east-1.amazonaws.com/

Could someone tell me why it aws/aws-sdk-phpis taking the one KEY_IDfrom league/flysystem-aws-s3-v3, since the error shows that the user "Laravel_S3" is not authorized and that user is not the one configured to send emails?

good night.

I am configuring a project with spatie/multitenancy and when configuring the User model to authenticate and login, I add the UsesTenantConnection trait to the User model, the authentication is successful for the tenants, but for the owner it does not recognize the connection. If I use the UsesLandlordConnection trait or neither of the two traits in the User model, when logging in, whether in the owner or in the tenants, it recognizes the connection of the owner, and in the owner it is accessed without problems, for the owner it is fine, but for the tenants it shows a message of incorrect credentials, because it is considering the connection of the owner.

Here is the error that I get when I use the UsesTenantConnection trait and login to the owner.

Illuminate\Database\QueryException
SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected (SQL: select * from `users` where `email` = [email protected] limit 1)

http://multitenancy_spatie.test:82/login

And here the relevant configuration files

in the kernel

protected $middlewareGroups = [
    'tenant' => [
        \Spatie\Multitenancy\Http\Middleware\NeedsTenant::class,
        \Spatie\Multitenancy\Http\Middleware\EnsureValidTenantSession::class,
    ]
];

config('database')

[
 "default" => "landlord",
 "connections" => [
   "tenant" => [
     "driver" => "mysql",
     "url" => null,
     "host" => "127.0.0.1",
     "port" => "3306",
     "database" => null,//Tenant Autr
     "username" => "root",
     "password" => "",
     "unix_socket" => "",
     "charset" => "utf8mb4",
     "collation" => "utf8mb4_unicode_ci",
     "prefix" => "",
     "prefix_indexes" => true,
     "strict" => true,
     "engine" => null,
     "options" => [],
   ],
   "landlord" => [
     "driver" => "mysql",
     "url" => null,
     "host" => "127.0.0.1",
     "port" => "3306",
     "database" => "multitenancy_spatie",
     "username" => "root",
     "password" => "",
     "unix_socket" => "",
     "charset" => "utf8mb4",
     "collation" => "utf8mb4_unicode_ci",
     "prefix" => "",
     "prefix_indexes" => true,
     "strict" => true,
     "engine" => null,
     "options" => [],
   ],
 ],
]

config('multitenancy')

[
 "tenant_finder" => "Spatie\Multitenancy\TenantFinder\DomainTenantFinder",
 "tenant_artisan_search_fields" => [
   "id",
 ],
 "switch_tenant_tasks" => [
   "Spatie\Multitenancy\Tasks\SwitchTenantDatabaseTask",
 ],
 "tenant_model" => "Spatie\Multitenancy\Models\Tenant",
 "queues_are_tenant_aware_by_default" => true,
 "landlord_database_connection_name" => "landlord",
 "current_tenant_container_key" => "currentTenant",
 "actions" => [
   "make_tenant_current_action" => "Spatie\Multitenancy\Actions\MakeTenantCurrentAction",
   "forget_current_tenant_action" => "Spatie\Multitenancy\Actions\ForgetCurrentTenantAction",
   "make_queue_tenant_aware_action" => "Spatie\Multitenancy\Actions\MakeQueueTenantAwareAction",
   "migrate_tenant" => "Spatie\Multitenancy\Actions\MigrateTenantAction",
 ],
 "queueable_to_job" => [
   "Illuminate\Mail\SendQueuedMailable" => "mailable",
   "Illuminate\Notifications\SendQueuedNotifications" => "notification",
   "Illuminate\Events\CallQueuedListener" => "class",
   "Illuminate\Broadcasting\BroadcastEvent" => "event",
 ],
]

.env file

APP_NAME=Laravel
APP_ENV=local
APP_KEY=base64:millave
APP_DEBUG=true
APP_URL=http://multitenancy_spatie.test:82

DB_CONNECTION=landlord
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=multitenancy_spatie
DB_USERNAME=root
DB_PASSWORD=

Routes file -> routes/web.php

Route::domain('{tenant}.multitenancy_spatie.test')->middleware('tenant')->group(function() {
    // routes
    Route::get('/', function () {
        return view('auth.login');
    });
    Route::middleware(['auth:sanctum', 'verified'])->get('/dashboard', function () {
        return view('dashboard_tenant');
    })->name('dashboard');
});

Route::domain('multitenancy_spatie.test')->group(function() {
    // routes
    Route::get('/', function () {
        return view('welcome');
    })->name('home');
    
    Route::middleware(['auth:sanctum', 'verified'])->get('/dashboard', function () {
        return view('dashboard');
    })->name('dashboard');
});

I have reviewed on github: https://github.com/spatie/laravel-multitenancy/issues/224 , in that issue they deal with the same error, but I have not been able to find the solution to start the session.

Thanks for your help.

I have an application in L8, I configured a disk to use it in the Storage;

'avatars' => [
        'driver' => 'local',
        'root' => storage_path('app/private/images/avatars'),
],

Then I created the corresponding link

'links' => [
    public_path('avatars') => storage_path('app/private/images/avatars'),
],

Then in my controller I save the file to Storage;

public function cambiarAvatar(Request $request)
{
    $path = Storage::disk('avatars')->put('imagen.jpg',$request->file('avatar'));

    return $path;
}

The drawback with this code is that it creates a directory called image.jpg, that is, app/private/images/avatars/something.jpg/... and the name of the file once uploaded is temporary;

Could you tell me what I may be doing wrong? I need to be able to save a file with the name that I indicate, in the directory established on the disk, that is, in app/private/images/avatars.

Many thanks in advance.