Topics

Filament•4w ago

How to solve long string(numeric) issue in datagrid?

- What I am trying to do: I am trying to build simcard management dashboard. - What I did: so for this, I created table grid and displayed simcard data such as card number, phone number etc from external api. - My issue: For example, simcard number format is 9999999999999999999, but it's showing like 1.0E+20 I verified simcard number was loaded correctly from external api, but showing wrong on table grid, so I tried to use formatStateUsing function, but still showing wrong. I can't solve this problem. - Code:

return $table
    ->columns([
        // simoverview record id
        TextColumn::make('id')
            ->toggleable(isToggledHiddenByDefault: true),

        // client id
        TextColumn::make('portalClient')
            ->label('Client Id')
            ->toggleable(isToggledHiddenByDefault: true),

        // package
        TextColumn::make('PackageName')
            ->label('Pakke')
            ->alignLeft(),

        // imei
        TextColumn::make('IMEI')
            ->label('Simkort')
            ->copyable()
            ->copyMessage('Simkort copied')
            ->copyMessageDuration(1500)
            ->formatStateUsing(fn ($state) => (string) $state)
            ->weight('medium')
            ->alignLeft(),
    ]);

return $table
    ->columns([
        // simoverview record id
        TextColumn::make('id')
            ->toggleable(isToggledHiddenByDefault: true),

        // client id
        TextColumn::make('portalClient')
            ->label('Client Id')
            ->toggleable(isToggledHiddenByDefault: true),

        // package
        TextColumn::make('PackageName')
            ->label('Pakke')
            ->alignLeft(),

        // imei
        TextColumn::make('IMEI')
            ->label('Simkort')
            ->copyable()
            ->copyMessage('Simkort copied')
            ->copyMessageDuration(1500)
            ->formatStateUsing(fn ($state) => (string) $state)
            ->weight('medium')
            ->alignLeft(),
    ]);

50 Replies

Shang✨OP•4w ago

I hope someone help me please

No description

undercode•4w ago

https://www.php.net/manual/en/function.number-format.php

PHP: Hypertext Preprocessor

PHP is a popular general-purpose scripting language that powers everything from your blog to the most popular websites in the world.

Shang✨OP•4w ago

I know this function, but I don't want to add any decimals or commas because its simcard number Hi @undercode Do you know how?

undercode•4w ago

->formatStateUsing(fn ($state) => number_format(floatval($state), 0, '', ''))

->formatStateUsing(fn ($state) => number_format(floatval($state), 0, '', ''))

Shang✨OP•4w ago

Wow I see, I will try now. Okay I tried.

Shang✨OP•4w ago

The correct simcard number from external api is 89450136240822000001 Now, datagrid is showing like this.

No description

Shang✨OP•4w ago

Correct one

No description

Shang✨OP•4w ago

Well, filament table can't handle large int value? bigint value?

undercode•4w ago

Maybe you have to store it as string, not int

Shang✨OP•4w ago

Of course I am able to get simcard number as string from external api When I log simcard number, I can see 9999999999999999999 for example correctly. But the problem is only when displaying this on datagrid. I don't understand why filament can't handle this and why filament detects this kind of string as numeric. I think, this is a very critical problem and issue in filament library Do I need to report this issue to filament dev team?

undercode•4w ago

I'm going to replicate your issue...

Shang✨OP•4w ago

Sounds good thank you so much!

undercode•4w ago

Is your field defined like: $table->string('imei') ?

Shang✨OP•4w ago

Well, I don't use laravel database such as mysql etc.

undercode•4w ago

ok I see

Shang✨OP•4w ago

I load data from baserow api But hold on In baserow, yes IMEI filed is string field.

Shang✨OP•4w ago

No description

Shang✨OP•4w ago

Not numeric field As I mentioned above, the problem is filament detects long string(not text) as number, so it shows like 1.0E+20 etc I guess.

undercode•4w ago

It seems more a php precision thing than a filament one, because number displayed is different when using ini_set('precision', 20)

undercode•4w ago

Maybe GNU Multiple Precision could help you. https://www.php.net/manual/en/book.gmp.php

PHP: Hypertext Preprocessor

PHP is a popular general-purpose scripting language that powers everything from your blog to the most popular websites in the world.

Shang✨OP•4w ago

Great! Thank you Did you replicate my issue?

undercode•4w ago

Yes, i did. And with ini_set('precision', 20) the IMEI

89450136240822000001

89450136240822000001

is displayed as

89450136240821993472

89450136240821993472

Shang✨OP•4w ago

Yeah, then, it shows wrong Then, not sure how to solve this. This is very big critical problem.

undercode•4w ago

Could you share how you load your json and how you parse it?

Shang✨OP•4w ago

Sure I will share php file, okay?

undercode•4w ago

ok

Shang✨OP•4w ago

app/Filament/Resources/SimcardResource.php

SimcardResource.php

Shang✨OP•4w ago

And json response format is...

{
    "id": 12952,
    "PackageName": "",
    "IMEI": "99999999999999999999",
    "Phone": "",
    "Activated": null,
    "API_Response": "",
    "portalClientEmail": "[email protected]",
    "portalClient": "999999"
}

{
    "id": 12952,
    "PackageName": "",
    "IMEI": "99999999999999999999",
    "Phone": "",
    "Activated": null,
    "API_Response": "",
    "portalClientEmail": "[email protected]",
    "portalClient": "999999"
}

But in table() function in SimcardResource.php file, IMEI value shows 1.0E+20 public static function table(Table $table) Simcard.php model works with baserow api. Not database.

undercode•4w ago

Ok, but you are using Sushi, with uses SQLite to store your data. Try to add this line to your Simcard model:

protected $casts = [ 'IMEI' => 'string'];

protected $casts = [ 'IMEI' => 'string'];

Shang✨OP•4w ago

Ok, let me try. 👍 Then, I don't need part? ->formatStateUsing(fn ($state) => number_format(floatval($state), 0, '', ''))

undercode•4w ago

No

Shang✨OP•4w ago

Ok, it's showing 89450136240821993472 But it should be like . 89450136240822000001 😖 . Not sure why.

Shang✨OP•4w ago

I added copyable to this field, so when I copied, it's like this. 8.9450136240822E+19

No description

undercode•4w ago

Ok, remove $casts and add this line:

protected $schema = [
    'IMEI' => 'string',
];

protected $schema = [
    'IMEI' => 'string',
];

Shang✨OP•4w ago

Ok thank you. Same issue. If you want , you can check directly in my computer via anydesk. Let me think how to solve this problem. I think, this is filament table library issue.

undercode•4w ago

No, it's not. It's Sushi's Do you have a sqlite database in your database folder?

Shang✨OP•4w ago

But as you can see json, I am able to load simcard data correctly.

undercode•4w ago

Try to remove it

Shang✨OP•4w ago

Let me check

Shang✨OP•4w ago

There is no sqlite file in database folder.

No description

undercode•4w ago

This is Sushi function to create the table and its fields:

public function createTable(string $tableName, $firstRow)
{
    $this->createTableSafely($tableName, function ($table) use ($firstRow) {
        // Add the "id" column if it doesn't already exist in the rows.
        if ($this->incrementing && ! array_key_exists($this->primaryKey, $firstRow)) {
            $table->increments($this->primaryKey);
        }

        foreach ($firstRow as $column => $value) {
            switch (true) {
                case is_int($value):
                    $type = 'integer';
                    break;
                case is_numeric($value):
                    $type = 'float';
                    break;
                case is_string($value):
                    $type = 'string';
                    break;
                case is_object($value) && $value instanceof \DateTime:
                    $type = 'dateTime';
                    break;
                default:
                    $type = 'string';
            }

            if ($column === $this->primaryKey && $type == 'integer') {
                $table->increments($this->primaryKey);
                continue;
            }

            $schema = $this->getSchema();

            $type = $schema[$column] ?? $type;

            $table->{$type}($column)->nullable();
        }

        if ($this->usesTimestamps() && (! in_array('updated_at', array_keys($firstRow)) || ! in_array('created_at', array_keys($firstRow)))) {
            $table->timestamps();
        }

        $this->afterMigrate($table);
    });
}

public function createTable(string $tableName, $firstRow)
{
    $this->createTableSafely($tableName, function ($table) use ($firstRow) {
        // Add the "id" column if it doesn't already exist in the rows.
        if ($this->incrementing && ! array_key_exists($this->primaryKey, $firstRow)) {
            $table->increments($this->primaryKey);
        }

        foreach ($firstRow as $column => $value) {
            switch (true) {
                case is_int($value):
                    $type = 'integer';
                    break;
                case is_numeric($value):
                    $type = 'float';
                    break;
                case is_string($value):
                    $type = 'string';
                    break;
                case is_object($value) && $value instanceof \DateTime:
                    $type = 'dateTime';
                    break;
                default:
                    $type = 'string';
            }

            if ($column === $this->primaryKey && $type == 'integer') {
                $table->increments($this->primaryKey);
                continue;
            }

            $schema = $this->getSchema();

            $type = $schema[$column] ?? $type;

            $table->{$type}($column)->nullable();
        }

        if ($this->usesTimestamps() && (! in_array('updated_at', array_keys($firstRow)) || ! in_array('created_at', array_keys($firstRow)))) {
            $table->timestamps();
        }

        $this->afterMigrate($table);
    });
}

As you can see, the function creates field types based on the contents of the field.

Shang✨OP•4w ago

I installed Sushi package, but I didn't create any sqlite database file manually, or even I don't know where is sqlite database file. Yeah, I see So, when loading data, Sushi tries to insert data first before showing data to table, yes?

undercode•4w ago

Exactly. And creates a new table if not exsists.

Shang✨OP•4w ago

I checked createTable function of Sushi, so oh, there is is_int, is_numberic cases. So, Sushi detects simcard number as numeric Not as string. Hmmm

undercode•4w ago

Exactly! You can specify field types in your $schema variable: https://github.com/calebporzio/sushi?tab=readme-ov-file#custom-schema

GitHub

GitHub - calebporzio/sushi: Eloquent's missing "array" driver.

Eloquent's missing "array" driver. Contribute to calebporzio/sushi development by creating an account on GitHub.

Shang✨OP•4w ago

Awesome! I will try. Well, we tried this already, but didn't work. protected $schema = [ 'IMEI' => 'string', ]; But let me think again.

undercode•4w ago

Try php artisan cache:clear

Shang✨OP•4w ago

Ok Not working. Actually, I tried to clear cache already.

undercode•4w ago

I can't think of anything else, sorry. Try to make a repo in github and I'll try when I have time

Shang✨OP•4w ago

Yup, I understand. Thank you so much! for your help and ideas. Oh nice! After adding this part into model ,

protected $schema = [
        'IMEI' => 'string',
    ];

protected $schema = [
        'IMEI' => 'string',
    ];

And removed this part,

>formatStateUsing(fn ($state) => number_format(floatval($state), 0, '', ''))

>formatStateUsing(fn ($state) => number_format(floatval($state), 0, '', ''))

I can see correct simcard number. Of course, I ran

php artisan optimize:clear

php artisan optimize:clear

command, so I can see correctly. Thank you for your help! 👍👍👍 So my problem is solved. @undercode Can you please help me on this ? https://discord.com/channels/883083792112300104/1321818842401603636

Filament is a collection of beautiful full-stack components for Laravel.You can get help using it on our Discord.

18KMembers

View on Discord

Did you find this page helpful?