while ($row = mysql_fetch_array($result)) { $total = $total + $row[5]; echo "<td><a href='irecord.php?record={$row['0']}' target='_blank'>{$row['0']}</a></td>"; echo "<td>{$row['6']}</td>"; echo "<td>{$row['2']}</td>"; echo "<td>{$row['1']}</td>"; echo "<td>{$row['4']}</td>"; echo "<td>\$" . number_format($row[5], 2) . "</td>"; echo "<td>{$row['7']}" . " y " . "{$row['8']}</td>"; echo "</tr>"; } echo "</table>"; mysql_close($conn); echo "<center><h2><blockquote>Ingresos Totales: \$<b>" . number_format($total, 2) . "</b></blockquote></h2></center>"; include 'getYearTotal.php'; echo "<p>Ofrendas hasta la fecha: <b>\$" . number_format(YTDIncomeTotal(), 2) . "</b></p>"; echo "<center>"; print "<p><a href='Ofrenda-Anual-Detallado.php'>Reporte Anual</a> | <a href='index.php'>Inicio</a></p>"; echo "</center>"; ?> </fieldset> </body> </html>
<tr> <td style="width: 514px"><fieldset><p><strong>Resumen Hasta La Fecha:</strong></p> <?php //Get Totals For Current Fiscal Year include 'getYearTotal.php'; $income = round(YTDIncomeTotal()); $expense = round(YTDExpenseTotal()); $mission = round(yearMissionTotal()); $do = $income + $expense + mission; $income = $income / $do * 100; $expense = $expense / $do * 100; $mission = $mission / $do * 100; echo "<img src='http://chart.apis.google.com/chart?chs=250x100&chd=t:{$income},{$expense},{$mission}&chco=00FF00|FF0000|0000F4&cht=p3&chl=Ingresos|Gastos|Misiones' >"; echo "<p>Ingresos : <span id='ingresos'><b>+\$" . number_format(YTDIncomeTotal(), 2) . "</b></span></p>"; echo "<p>Gastos : <span id='gastos'><b>-\$" . number_format(YTDExpenseTotal(), 2) . "</b></span></p>"; echo "<p>Balance : <span id='cambio'><b>\$" . number_format(YTDIncomeTotal() - YTDExpenseTotal(), 2) . "</b></span></p>"; echo "<br/>"; echo "<p>Total Misiones: \$" . number_format(yearMissionTotal(), 2) . "</p>"; ?> </fieldset></td> <td> <form accept-charset="utf-8" action="vreport.php" method="post" name="viewreport"> <fieldset><legend><b>Reportes</b></legend> <blockquote><p>Reportes : <select id="vreport" name="vreport"> <option value="query">Buscar Record</option> <option value="personreport">Reporte Personal</option> <option value="FechaOfrendaSemanal">Reporte Semanal Ofrendas</option> <option value="FechaOfrendaMensual">Reporte Mensual Ofrendas</option> <option value="OfrendaAnual">Reporte Anual Ofrendas</option>