Home / Questions / 25646
Accepted
Cidius
Asked: 2020-10-01 06:39:12 +0800 CST 2020-10-01 06:39:12 +0800 CST

Date manipulation issues to do "next events" in Laravel 5.3

  • 772

I'm making a calendar of events and showing, with the help of Carbon , the dates from the most recent to occur with the diffForHumans()Carbon function .

I think I know exactly what the problem is but I would like some advice on the best way to handle the dates.

In the base I save it as String, since I Dateonly saved the day and I needed the combo.

But of course at the moment of bringing the events and ordering them by "date" it is aString

$eventos= Evento::orderBy('fecha','asc')->get();

It is clear that this will not order me correctly. Why order String. How do I fix this?

Scholarship Marathon / 09.10.2016 14:00
Carussi Marathon / 10.08.2016 15:00
Bovril Marathon / 10.08.2016 09:51
Health Marathon / 09.30.2016 16:00

Being today 09/30 at 12:00 it should show the Health Marathon first, but it shows it last. After if it seemed ordered.

It also happens to me that when I use the Carbon function it is adding 3 hours to me (I suppose it has something to do with the GTM) diffForHumans(). So if there are 4 hours left, it is telling me that there is 1 hour left. This is how I use it:

@foreach($eventos as $evento)
            @if($evento->fecha >= Carbon\Carbon::now())
            <h5>
                <a href="#">
                    {{$evento->nombre}} . {{$evento->distancia}}<br>
                    {{ Carbon\Carbon::createFromFormat('Y-m-d H:i:s',$evento->fecha)->diffForHumans() }}
                    {{Carbon\Carbon::now()}}
                </a>

            </h5>
            @endif
    @endforeach

You may also be having some conversion problem when creating the date with Carbon from the String.

php

1 Answers

  1. Best Answer

    Changing the time zone should fix the time skew problem, using the setTimezone('America/New York')eg method, considering that diffForHumans() takes this into account:

    public function diffForHumans(Carbon $other = null, $absolute = false, $short = false)
{
    $isNow = $other === null;
    if ($isNow) {
        $other = static::now($this->getTimezone());
    }
    $diffInterval = $this->diff($other);
    switch (true) {
        case ($diffInterval->y > 0):
            $unit = $short ? 'y' : 'year';
            $count = $diffInterval->y;
            break;
        case ($diffInterval->m > 0):
            $unit = $short ? 'm' : 'month';
            $count = $diffInterval->m;
            break;
        case ($diffInterval->d > 0):
            $unit = $short ? 'd' : 'day';
            $count = $diffInterval->d;
            if ($count >= static::DAYS_PER_WEEK) {
                $unit = $short ? 'w' : 'week';
                $count = (int) ($count / static::DAYS_PER_WEEK);
            }
            break;
        case ($diffInterval->h > 0):
            $unit = $short ? 'h' : 'hour';
            $count = $diffInterval->h;
            break;
        case ($diffInterval->i > 0):
            $unit = $short ? 'min' : 'minute';
            $count = $diffInterval->i;
            break;
        default:
            $count = $diffInterval->s;
            $unit = $short ? 's' : 'second';
            break;
    }
    if ($count === 0) {
        $count = 1;
    }
    $time = static::translator()->transChoice($unit, $count, array(':count' => $count));
    if ($absolute) {
        return $time;
    }
    $isFuture = $diffInterval->invert === 1;
    $transId = $isNow ? ($isFuture ? 'from_now' : 'ago') : ($isFuture ? 'after' : 'before');
    // Some langs have special pluralization for past and future tense.
    $tryKeyExists = $unit.'_'.$transId;
    if ($tryKeyExists !== static::translator()->transChoice($tryKeyExists, $count)) {
        $time = static::translator()->transChoice($tryKeyExists, $count, array(':count' => $count));
    }
    return static::translator()->trans($transId, array(':time' => $time));
}
    • 0