function recalculate($wallet_id) { $amount_in = 0; $amount_out = 0; foreach (wallet_operations($wallet_id) as $o) { if ($o['type'] == 'I') { $amount_in += $o['amount']; } else { $amount_out += $o['amount']; } } mysql_query("UPDATE wallets SET amount_in=" . $amount_in . ", amount_out=" . $amount_out . " WHERE id=" . $wallet_id); }
<section class="rounded-corners add-opacity bg-white"> <strong style="font-size:0.8em;">Historia wszystkich operacji w ramach portfela (<?php echo mb_convert_case(get_wallet_name_by_id($wallet_id), MB_CASE_UPPER, "UTF-8"); ?> )</strong><br /> <span style="font-size:0.8em;" class="gray">Tu możesz usunąć operację jeżeli dane zostały błędnie wprowadzone</span> <table class="operations"> <tr> <th style="width:150px;">Data</th> <th style="width:200px;">Kwota</th> <th style="width:520px;">Cel</th> <th style="width:50px;"></th> </tr> <?php foreach (wallet_operations($wallet_id) as $o) { ?> <tr> <td style="text-align:center;"><?php echo date("d-m-Y", strtotime($o['when_created'])); ?> </td> <td style="text-align:right; padding-right:20px;"> <?php if ($o['type'] == 'I') { echo '<span class="green">' . number_format($o["amount"], $decimals = 2, $dec_point = ".", $thousands_sep = "") . ' PLN</span>'; } else { echo '<span class="red">-' . number_format($o["amount"], $decimals = 2, $dec_point = ".", $thousands_sep = "") . ' PLN</span>'; } ?> </td>