Laravel equivalent if statement

Question

I am beginner php developer. I make my project in Laravel 8.

I have this migrations:

Schema::create('clients', function (Blueprint $table) {
    $table->id();
    $table->string('email');
    $table->integer('type')->comment('1 - Client individual , 2 - Client Company');
    $table->string('crm_number')->unique();
    $table->string('password');
    $table->string('verify_token');
    $table->rememberToken();
    $table->timestamp('password_assigned_at')->nullable();
    $table->timestamp('email_verified_at')->nullable();
    $table->timestamps();
    $table->deactivation();
    $table->softDeletes();

    $table->unique(['email', 'deleted_at']);
});

Schema::create('client_infos', function (Blueprint $table) {
    $table->id();
    $table->foreignId('client_id')->constrained('clients')->onDelete('cascade');
    $table->string('first_name');
    $table->string('last_name');
    $table->string('phone_nr')->nullable();
    $table->timestamps();
});

Schema::create('client_company_infos', function (Blueprint $table) {
    $table->id();
    $table->foreignId('client_id')->constrained('clients')->onDelete('cascade');
    $table->string('name');
    $table->string('nip')->nullable();
    $table->string('phone_nr')->nullable();
    $table->string('contact_email')->nullable();
    $table->string('invoice_email')->nullable();
    $table->timestamps();
});

If client.type = 1 - Client individual , 2 - Client Company

I have this code:

Client::leftJoin('client_company_infos', 'client_company_infos.client_id', '=', 'clients.id')
    ->leftJoin('client_infos', 'client_infos.client_id', '=', 'clients.id')
    ->select('clients.*',
        'client_company_infos.name as name',
        'client_infos.first_name as first_name',
        'client_infos.last_name as last_name',
    );

In my situation I have name - for company name, first_name for first name and last_name as last_name.

I need always one value "name":

company = name
individual user = name as 'first name + last name'

How can I make it?

Please help me

you can use accessor and mutator

dılo sürücü
– dılo sürücü

2020-10-12 17:43:50 +00:00
Commented Oct 12, 2020 at 17:43 — dılo sürücü
– dılo sürücü, Commented Oct 12, 2020 at 17:43

dılo sürücü · Accepted Answer · 2020-10-12 17:45:22Z

1

you can use the accessor for that, for example


class YourModel extend Model
{
   //foo bla bla

  public function getFullNameAttribute()
  {
     return sprintf('%s %s',$this->name,$this->lastname;
  }
}

using


User::find(63);

echo $user->full_name;

relevent document

edited Oct 12, 2020 at 17:45

answered Oct 12, 2020 at 17:43

dılo sürücü

4,2692 gold badges31 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

trzew Over a year ago

Thank you, I know this solution. However, I need to do it in joiny or selectRaw

dılo sürücü Over a year ago

for join u can collection override with a map or walk methods,laravel return collection from db everytime ... or u can concat is sql raw

dılo sürücü Over a year ago

DB::raw('CONCAT(lname ", ", lastanme) AS full_name

trzew Over a year ago

This is not exactly a solution. I need to have "name" written depending on whether the user is a company: client_company_infos.name oub if it is individual: name = client_infos.last_name + last_name

dılo sürücü Over a year ago

then you don't use if statement in the query?

Collectives™ on Stack Overflow

Laravel equivalent if statement

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related