Converting Timezone Strings from database on Select form field the offsets

I have a field which is a timezone stored as Europe/Andorra for example,

            Select::make("timezone_id")
                ->nullable()
                ->preload()
                ->options(
                Timezone::all()->pluck("name","id")->toArray()
                )
                ->searchable(),

            Select::make("timezone_id")
                ->nullable()
                ->preload()
                ->options(
                Timezone::all()->pluck("name","id")->toArray()
                )
                ->searchable(),

            Select::make("timezone_id")
                ->nullable()
                ->preload()
                ->options(
                Timezone::all()->pluck("name","id")->toArray()
                )
                ->searchable(),

            Select::make("timezone_id")
                ->nullable()
                ->preload()
                ->options(
                Timezone::all()->pluck("name","id")->toArray()
                )
                ->searchable(),

Which displays the timezone correctly, but i want to show the offset for it eg Europe/Andorra (GMT+1)
I have this helper which works

<?php
namespace App\Helpers;

use Carbon\Carbon;
class TimezoneHelper
{
    public static function getGMTOffset($timezone)
    {
        $dateTime = Carbon::parse($timezone);
        $offset = $dateTime->offsetHours;
        $sign = ($offset < 0) ? '-' : '+';
        $absOffset = abs($offset);
        $gmtOffset = sprintf("GMT%s%02d", $sign, $absOffset);
        return $gmtOffset;
    }
}

<?php
namespace App\Helpers;

use Carbon\Carbon;
class TimezoneHelper
{
    public static function getGMTOffset($timezone)
    {
        $dateTime = Carbon::parse($timezone);
        $offset = $dateTime->offsetHours;
        $sign = ($offset < 0) ? '-' : '+';
        $absOffset = abs($offset);
        $gmtOffset = sprintf("GMT%s%02d", $sign, $absOffset);
        return $gmtOffset;
    }
}

<?php
namespace App\Helpers;

use Carbon\Carbon;
class TimezoneHelper
{
    public static function getGMTOffset($timezone)
    {
        $dateTime = Carbon::parse($timezone);
        $offset = $dateTime->offsetHours;
        $sign = ($offset < 0) ? '-' : '+';
        $absOffset = abs($offset);
        $gmtOffset = sprintf("GMT%s%02d", $sign, $absOffset);
        return $gmtOffset;
    }
}

<?php
namespace App\Helpers;

use Carbon\Carbon;
class TimezoneHelper
{
    public static function getGMTOffset($timezone)
    {
        $dateTime = Carbon::parse($timezone);
        $offset = $dateTime->offsetHours;
        $sign = ($offset < 0) ? '-' : '+';
        $absOffset = abs($offset);
        $gmtOffset = sprintf("GMT%s%02d", $sign, $absOffset);
        return $gmtOffset;
    }
}

but how do i modify the option labels in the field with that helper?
Thanks in advance

BBleak I have a field which is a timezone stored as Europe/Andorra for example, ``` ...

LeandroFerreira•4/26/23, 9:45 AM

->getOptionLabelUsing ?

LLeandroFerreira ->getOptionLabelUsing ?

BleakOP•4/26/23, 9:46 AM

HI I tried that, but couldnt get it working
I actually just got it working with

 Select::make("timezone_id")
                ->nullable()
                ->preload()
                ->options(
                    Timezone::all()->mapWithKeys(function ($timezone) {
                        $gmtOffset = TimezoneHelper::getGMTOffset($timezone->name);
                        return [$timezone->id => "$timezone->name (GMT$gmtOffset)"];
                    })->toArray()
                )
                ->searchable(),

 Select::make("timezone_id")
                ->nullable()
                ->preload()
                ->options(
                    Timezone::all()->mapWithKeys(function ($timezone) {
                        $gmtOffset = TimezoneHelper::getGMTOffset($timezone->name);
                        return [$timezone->id => "$timezone->name (GMT$gmtOffset)"];
                    })->toArray()
                )
                ->searchable(),

not sure if its the right way forward though!

BleakOP•4/26/23, 9:47 AM

@Dan Harrin any advice here?

Dan Harrin•4/26/23, 9:50 AM

yup that looks right

DDan Harrin yup that looks right

BleakOP•4/26/23, 9:51 AM

Thank you sire

DDan Harrin yup that looks right

BleakOP•4/26/23, 9:52 AM

Do we have a solved tag in discord?

Dan Harrin•4/26/23, 9:52 AM

yeah click the

DDan Harrin yeah click the ✅

BleakOP•4/26/23, 9:52 AM

Thx!

Select::make("timezone_id") ->nullable() ->preload() ->options( Timezone::all()->mapWithKeys(function ($timezone) { $gmtOffset = TimezoneHelper::getGMTOffset($timezone->name); return [$timezone->id => "$timezone->name (GMT$gmtOffset)"]; })->toArray() ) ->searchable(),

Converting Timezone Strings from database on Select form field the offsets

Similar Threads

Similar Threads

Similar Threads