Decrypting data in Eloquent Query

@matttonks11 You could create a class that takes an Eloquent collection instance, spins through each model, and decrypts any encrypted values:

use Illuminate\Database\Eloquent\Collection;
use Illuminate\Database\Eloquent\Model;

class ModelDecrypter
{
    public function decryptModel(Model $model)
    {
        foreach ($model->getEncryptable() as $attribute) {
            $model->setAttribute($attribute, decrypt($model->getAttribute($attribute)));
        }

        return $model;
    }

    public function decryptCollection(Collection $collection)
    {
        return $collection->map(function (Model $model) {
            return $this->decryptModel($model);
        });
    }
}

$clientData = $client->with('groups:id,name')
            ->select('clients.id','clients.forename', 'clients.surname', 'clients.mobile', 'clients.email', 'clients.created_at')->latest();

$clientData = (new ModelDecrypter)->decryptCollection($clientData);

return datatables()->of($clientData)->toJson();

@martinbean Hi thank you for this, it looks great. However i'm getting an error on the ->getEncryptable() method, it's saying it doesn't exist.

Call to undefined method App\Client::getEncryptable()

Here's my model...

class Client extends Model
{
    use Encryptable;

    protected $encryptable = [
        'email',
        'mobile'
    ];
}

And here's the trait class...

namespace App\Traits;
use Crypt;

trait Encryptable
{
    public function getAttribute($key)
    {
        $value = parent::getAttributeValue($key);

        if (in_array($key, $this->encryptable)) {
            return $value = Crypt::decrypt($value);
        }
        return $value;
    }

    public function setAttribute($key, $value)
    {
        if (in_array($key, $this->encryptable)) {
            $value = Crypt::encrypt($value);
        }

        return parent::setAttribute($key, $value);
    }
}

Not sure what I'm doing wrong, any advice?

Do you need to add this to your trait

public function getEncryptable() {
  return $this->encryptable;
}

@D9705996 thank you, that's worked, now I'm getting an error that says the payload is invalid.

Any thoughts?

If you dd(parent::getAttributeValue($key)); do you see the encrypted data?

I just get the value 2 returned, I'm guessing this is the number of encrypted fields?

@D9705996 I think the error is something to do with this line maybe

//Model Decrypter.php

$model->setAttribute($attribute, decrypt($model->getAttribute($attribute)));

When I remove the decrypt helper function and run dd(parent::getAttributeValue($key)) i get the data back with encrypted values

In my Encryptable.php file I'm decrypting the data when the getAttribute method runs so I think its trying to decrypt the data twice maybe? Which is leading to the invalid payload error

//Encryptable.php

public function getAttribute($key)
    {
        $value = parent::getAttributeValue($key);

        //dd(parent::getAttributeValue($key));
        
        if (in_array($key, $this->encryptable)) {
            return $value = Crypt::decrypt($value);
        }
        return $value;
    }

@D9705996 Thanks that may be a better option, I'll check it out

The source code looks very similar to your approach.

@D9705996 Thanks for your help, it works well for what I need