collection($this->getRows())->toJson();
}
public function getRows() {
$rows = [];
foreach(Storefronts::all() as $storefront) {
if($storefront->client->monitored) {
$rows[] = [
mb_strtoupper($storefront->client->environment),
$storefront->client->client_display_name,
$storefront->country->name.' ('.mb_strtoupper($storefront->country->code).')',
$storefront->client->client_id,
$storefront->token ? 'OK' : 'KO',
$storefront->webshop ? 'OK' : 'KO',
$storefront->products ? 'OK' : 'KO',
$storefront->total_products,
Carbon::createFromFormat('Y-m-d H:i:s', Carbon::parse($storefront->last_checked))->format('d/m/Y H:i').'
('.Carbon::parse($storefront->last_checked)->diffForHumans().')',
Carbon::createFromFormat('Y-m-d H:i:s', $storefront->updated_at)->format('d/m/Y H:i').'
('.$storefront->updated_at->diffForHumans().')', $storefront->error,
is_null($storefront->error_date) ? null : Carbon::createFromFormat('Y-m-d H:i:s', Carbon::parse($storefront->error_date))->format('d/m/Y H:i').'
('.Carbon::parse($storefront->error_date)->diffForHumans().')',
];
}
}
return $rows;
}