如何将 Laravel 输出的日期格式更改为 JSON?

2021-12-18 00:00:00 json php laravel laravel-5

我在 Laravel 中构建了一个应用程序，并以这种格式 eloquent 返回日期:2015-04-17 00:00:00.我正在向 JSON 发送一个特定查询，以便我可以使用 D3 制作图表，并且我想我想要 ISO8601 ('1995-12-17T03:24:00') 中的日期或一些与 javascript Date() 构造函数配合使用的其他格式.

I've built an application in Laravel and eloquent returns dates in this format: 2015-04-17 00:00:00. I'm sending one particular query to JSON so I can make a graph with D3, and I think I would like the dates in ISO8601 ('1995-12-17T03:24:00') or some other format that plays nice with the javascript Date() constructor.

有没有办法在 Laravel 端将输出的日期格式更改为 JSON?我不确定使用 mutator 是最好的方法，因为它会影响我应用程序其他部分的日期.

Is there a way to change the date format being output to JSON on the Laravel end? I'm not sure using a mutator is the best approach because it would affect the date in other parts of my application.

或者最好保留 JSON 输出，并在将日期格式传递给 Date() 构造函数之前使用一些 javascript 字符串方法来操作日期格式?哪种方法更有效?

Or would it be better to leave the JSON output as is, and use some javascript string methods to manipulate the date format before passing it to the Date() constructor? Which approach is more efficient?

这是我的模型:

class Issue extends Model {



protected $fillable = [
    'client_id',
    'do',
    'issue_advocate',
    'service_number',
    'issue_location',
    'issue_description',
    'level_of_service',
    'outcome',
    'referral_id',
    'file_stale_date',
    'date_closed',
    'issue_note',
    'staff_hours'
];

protected $dates = [
    'do',
    'date_closed',
    'file_stale_date'
];

public function setDoAttribute($value)
{
    $this->attributes['do'] = Carbon::createFromFormat('F j, Y', $value)->toDateString();
}
}

这是我的查询:

$issues = Issue::with('issuetypes')
->select(['do','level_of_service','outcome','id'])
->whereBetween('do',[$lastyear,$now])
->get()->toJson();

以及我返回的 JSON:

And the JSON I get back:

[{"do":"2014-12-23 00:00:00","level_of_service":1,"outcome":1,"id":18995,"issuetypes":[{"id":9,"issuetype":"Non Liberty","pivot":{"issue_id":18995,"issuetype_id":9}}]}]

推荐答案

我知道这是一个老问题，但仍然没有好的答案.更改protected $dateFormat 会影响数据库，而必须重写方法serializeDate()

I know it's an old question, but there is still no good answer to that. Changing protected $dateFormat will affect database, instead method serializeDate() must be overriden

class MyModel extends Eloquent {
    protected function serializeDate(DateTimeInterface $date) {
        return $date->getTimestamp();
    }
}

或者我自己我选择创造特质

Or myself I chose to create trait

trait UnixTimestampSerializable
{
    protected function serializeDate(DateTimeInterface $date)
    {
        return $date->getTimestamp();
    }
}

然后添加

class SomeClassWithDates extends Model {    
    use UnixTimestampSerializable;

    ...
}

相关文章