如何区分配置文件？

Question

I have two types of user: client, manager. are stored in separated tables.

Each of then have unique nickname.

So, I need to open profile by nickname.

For Client is:

$client = Client::where("nickname", $nickname)

For Manager is:

$manager = Manager::where("nickname", $nickname)

So, I try to make universal function that dewtect where is client and manager and execute the appropriate query.

How can I improve this code and detect type of user only by nickename?

Answer 1

You should use one model for this, I guess it would be best way to handle clients and managers.

If for some reason you want to use two models, you can create method and put it in Client model since most of queries will be for clients:

public function getClientOrManagerByNickname($nickname) {
    $client = $this->where('nickname', $nickname)->first();

    return is_null($client) ? (new Manager)->where('nickname', $nickname)->first() : $client;
}

This code will create one query if client is found and will return this client. Or it will create two queires and will return manager. If there is no client and manager with this nickname, it will return null.