Access Custom Field in Hook

[aaronmorley]

Hi all, I am hoping someone can help me

 

In my hook, I can do the following to get client details and display the name of the client.

 

$client = Menu::context('client'),

$Message = <p> Hello {$client->firstName} </p>;

 

However, I want to get one of the custom client fields I have made instead. (for example VAT Number). How can I do this?

 

Thanks in advance if anyone can answer this.

[twhiting9275]

Use Capsule to grab it. Something like this

       $fieldid = Capsule::table('tblcustomfields')->where('fieldname', '=', 'VAT')->where('type', '=', 'client') ->pluck('id');
       $vatnum = Capsule::table('tblcustomfieldsvalues')->where('fieldid', '=', "$fieldid")->where('relid', '=', "$clientid")      ->pluck('value');

[aaronmorley]

Hi Twhiting,

 

I tried the following:

$fieldid = Capsule::table('tblcustomfields')->where('fieldname', '=', 'Dashboard')->where('type', '=', 'client') ->pluck('id');

$dashboardText = Capsule::table('tblcustomfieldsvalues')->where('fieldid', '=', "$fieldid")->where('relid', '=', "$clientid") ->pluck('value');

 

I seem to get a 500 error with this code. Not sure why. I checked the DB and a field with that name does exist. Any ideas?

[aaronmorley]

Ah I forgot to add:

use Illuminate\Database\Capsule\Manager as Capsule;

It works now. Thank you very much for your help.

[twhiting9275]

So sorry that I missed this response. Glad to see you got it all sorted out though

 

that 'capsule' statement is kind of an important thing