if (isset($_POST['updEmail']) and $_POST['updEmail'] == 'on') { print 'checked'; } ?> > Update Email</td> <?php } ?> </td> </tr> <tr> <td width="12%">Church</td> <td width="85%" colspan="5"> <?php if ($mode == 'view') { $ChurchName = ChurchName($row['ChurchID']); print $ChurchName; } else { ?> <select size="1" name="ChurchID"> <option value="0">Select Church</option> <?php $results = $db->query("select ChurchName,\n ChurchID\n from {$ChurchesTable}\n order by ChurchName\n ") or die("Not found:" . sqlError()); while ($row = $results->fetch(PDO::FETCH_ASSOC)) { $selected = $NewChurchID == $row['ChurchID'] ? "selected" : ""; print "<option value=\"" . $row['ChurchID'] . "\" " . $selected . ">" . $row['ChurchName'] . "</option>"; } ?> </select> <?php }
function PrintReport($ChurchID) { $ChurchName = ChurchName($ChurchID); $costDetail = ChurchExpenses($ChurchID); //----------------------------------------------------------------------- // Get the cost for various items //----------------------------------------------------------------------- $price = GetPrices(); $RegCost = $price["Registration"]; $ShirtCost = $price["Shirt"]; $AdultMealCost = $price["AdultMeal"]; $ChildMealCost = $price["ChildMeal"]; //----------------------------------------------------------------------- // Get the Counts for various items purchased //----------------------------------------------------------------------- $ParticipantCount = $costDetail["ParticipantCount"]; $ExtraAdultMealCount = $costDetail["ExtraAdultMealCount"]; $ExtraChildMealCount = $costDetail["ExtraChildMealCount"]; $ExtraShirtCount = $costDetail["ExtraShirtCount"]; //----------------------------------------------------------------------- // Get the cost for various items Purchased //----------------------------------------------------------------------- $costParticipant = $costDetail["Participant"]; $costExtraAdultMeals = $costDetail["ExtraAdultMeals"]; $costExtraChildMeals = $costDetail["ExtraChildMeals"]; $costExtraShirts = $costDetail["ExtraShirts"]; $costTotal = $costDetail["Total"]; $costBalance = $costDetail["Balance"]; $MoneyInOut = $costDetail["MoneyInOut"]; if ($costBalance > 0) { $balanceCarity = 'Due'; } else { if ($costBalance < 0) { $balanceCarity = 'Credit'; } else { $balanceCarity = ''; } } //----------------------------------------------------------------------- // Display to the user //----------------------------------------------------------------------- ?> <h1 align="center">Expense Report</h1> <h1 align="center">For: <?php print "{$ChurchName}"; ?> </h1> <table border="1" width="100%"> <tr> <td width="25%">Registered Participants</td> <td width="25%" align="center"><?php print $ParticipantCount; ?> </td> <td width="25%" align="center">x <?php print FormatMoney($RegCost); ?> </td> <td width="25%" align="right"><?php print FormatMoney($costParticipant); ?> </td> </tr> <tr> <td width="25%">Extra Adult Meal Tickets</td> <td width="25%" align="center"><?php print $ExtraAdultMealCount; ?> </td> <td width="25%" align="center">x <?php print FormatMoney($AdultMealCost); ?> </td> <td width="25%" align="right"><?php print FormatMoney($costExtraAdultMeals); ?> </td> </tr> <tr> <td width="25%">Extra Child Meal Tickets</td> <td width="25%" align="center"><?php print $ExtraChildMealCount; ?> </td> <td width="25%" align="center">x <?php print FormatMoney($ChildMealCost); ?> </td> <td width="25%" align="right"><?php print FormatMoney($costExtraChildMeals); ?> </td> </tr> <tr> <td width="25%">Extra T-Shirts</td> <td width="25%" align="center"><?php print $ExtraShirtCount; ?> </td> <td width="25%" align="center">x <?php print FormatMoney($ShirtCost); ?> </td> <td width="25%" align="right"><?php print FormatMoney($costExtraShirts); ?> </td> </tr> <tr> <td width="50%" colspan=2> </td> <td width="25%" align="right">Total:</td> <td width="25%" align="right"><?php print FormatMoney($costTotal); ?> </td> </tr> <tr> <td width="50%" colspan=2> </td> <td width="25%" align="right">Monies Received:</td> <td width="25%" align="right"><?php print FormatMoney($MoneyInOut); ?> </td> </tr> <tr> <td width="50%" colspan=2> </td> <td width="25%" align="right">Balance <?php print $balanceCarity; ?> :</td> <td width="25%" align="right"><?php print FormatMoney($costBalance); ?> </td> </tr> </table> <?php }
?> "><?php print $ChurchName; ?> </option> <?php } ?> </select> </p> <?php } else { //================================================================================== // Church was selected so give opportunity to add a transaction //================================================================================== $ChurchName = ChurchName($ChurchID); //================================================================================== // First show current transaction history //================================================================================== ?> <h2 align="center">for<br><?php print "{$ChurchName}</h2>"; ?> <input type=hidden name=ChurchID <?php print "value={$ChurchID}"; ?> > <table border=1 width=100%> <tr> <td colspan=4 bgcolor=#000000 align=center><font color=#FFFF00>History</font></td>
} ?> </table> <?php } else { ?> <p align="center"><i>No Judges Assigned</i></p> <?php } } if ($AdminReport) { $ChuchList = ChurchesRegistered(); if (count($ChuchList) > 0) { foreach ($ChuchList as $ChurchID => $ChurchName) { PrintRoster($ChurchID, $ChurchName); } } else { ?> <center> <h1>No churches with participating registrants have been defined</h1> <h2>Judges report is empty</h2> </center> <?php } } else { PrintRoster($ChurchID, ChurchName($ChurchID)); } ?> </body> </html>