Laravel convert database integer to string

Question

I am using Laravel 5.5 & have Items table with more than 50 columns set as Tinynt to store values.

Item::where('id',$id)->first();

Now in my view I want to replace all integer values to corresponding String like

if($item->column1 == 1) { $value = 'String1'); }
if($item->column1 == 2) { $valuee = 'String2'); }

& so on. I know I can use Laravel Mutator but I have more than 50 columns & settings Mutator will not solve my issue. My problem is some related to this post but problem is number of columns.

Any solution please ?

Answer 1

I think 50 is the best way, but you can redefine __get() magic method:

//your Item model class

protected $castMutators = [
   //column1 => ['1' => 'string1', 2 => 'string2'],
   //column2 => ['1' => 'string1', 2 => 'string2'],
   //...
   //column50 => ['1' => 'string1', 2 => 'string2'],
];

public function __get($name)
{
   if (in_array($name, $this->castMutators)) {
         $this->{$name} = $this->castMutators[$name][$this->name]
   }

   parent::__get($name);
}

Answer 2

You can override the getAttributeValue() or setAttributeValue() function on the Eloquent model like below. Then you can use the same accessor or mutator for multiple attributes.

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

    //if the value has already been mutated, don't modify, else if
    //the key is in the array of specified attributes, mutate and return it
    if($value === $this->getAttributeFromArray($key) && in_array($key, $this->attributes_to_mutate) ) {
        $value = $this->myCustomMutator($value);
    }

    return $value;
}

Same goes for setAttributeValue($key, $value)

Answer 3

save array to config/your_config.php

<?php

return [

    'columns' => [
        1 => 'string_1',
        2 => 'string_2',
    ],

];

usage:

config('your_config.columns')[1] // string_1
config('your_config.columns')[2] // string_2