public function recalcStreams() { $bannerStreams = BannerStream::all(); echo '<table border="1"><tr><th>stream</th><th>banner</th><th>client</th><th>price</th><th>recalced price</th><th>difference</th></tr>'; foreach ($bannerStreams as $bs) { $amount = $bs->amount; $recalcedAmount = StreamTimelog::whereStreamId($bs->stream_id)->sum('amount'); if ($recalcedAmount > 0) { $diff = number_format(100 * $amount / $recalcedAmount, 2); } else { if ($amount > 0) { $diff = 'failed'; } } if ($diff == '100.00') { $diff = ''; echo '<tr>'; } else { $diff .= '%'; echo '<tr style="font-weight: bold">'; } echo '<tr>'; echo '<td>stream#' . $bs->stream_id . '</td>'; echo '<td>banner#' . $bs->banner_id . '</td>'; echo '<td>client#' . $bs->banner->client_id . '</td>'; echo '<td>' . $amount . '</td>'; echo '<td>' . $recalcedAmount . '</td>'; echo '<td>' . $diff . '</td>'; echo '<tr>'; } echo '</table>'; }