<?php

/*******************************************************************************

*

* filename : PledgeEditor.php

* last change : 2004-6-12

* website : http://www.infocentral.org

* copyright : Copyright 2001, 2002, 2003 Deane Barker, Chris Gebhardt, Michael Wilt

*

* InfoCentral is free software; you can redistribute it and/or modify

* it under the terms of the GNU General Public License as published by

* the Free Software Foundation; either version 2 of the License, or

* (at your option) any later version.

*

******************************************************************************/

//Include the function library

require "Include/Config.php";

require "Include/Functions.php";

require "Include/MICRFunctions.php";

//Get the PersonID out of the querystring

$iPledgeID = FilterInput($_GET["PledgeID"],'int');

$linkBack = FilterInput($_GET["linkBack"]);

$FamIDIn = FilterInput($_GET["FamilyID"]);

$PledgeOrPayment = FilterInput($_GET["PledgeOrPayment"]);

$iCurrentDeposit = FilterInput($_GET["CurrentDeposit"]);

if ($iPledgeID > 0) {

$sSQL = "SELECT * FROM pledge_plg WHERE plg_plgID = '$iPledgeID'";

$rsPledge = RunQuery($sSQL);

$thePledge = mysql_fetch_array($rsPledge);

$iCurrentDeposit = $thePledge["plg_depID"];

$PledgeOrPayment = $thePledge["plg_PledgeOrPayment"];

}

if ($PledgeOrPayment == 'Pledge') // Don't assign the deposit slip if this is a pledge

$iCurrentDeposit = 0;

if ($iCurrentDeposit)

$_SESSION['iCurrentDeposit'] = $iCurrentDeposit;

else

$iCurrentDeposit = $_SESSION['iCurrentDeposit'];

// Get the current deposit slip data

if ($iCurrentDeposit) {

$sSQL = "SELECT * from deposit_dep WHERE dep_ID = " . $iCurrentDeposit;

$rsDeposit = RunQuery($sSQL);

extract(mysql_fetch_array($rsDeposit));

if ($dep_Closed) // If the current deposit slip is closed, force creation of a new one.

$iCurrentDeposit = 0;

}

// Get the list of funds

$sSQL = "SELECT fun_ID,fun_Name,fun_Description,fun_Active FROM donationfund_fun";

if ($editorMode == 0) $sSQL .= " WHERE fun_Active = 'true'"; // New donations should show only active funds.

$sSQL .= " ORDER BY fun_Name";

$rsFunds = RunQuery($sSQL);

//Set the page title

if ($PledgeOrPayment == 'Pledge') {

$sPageTitle = gettext("Pledge Editor");

} elseif ($iCurrentDeposit) {

$sPageTitle = gettext("Payment Editor: ") . $dep_Type . gettext(" Deposit Slip #") . $iCurrentDeposit . " ($dep_Date)";

// Important note: the number of checks that can fit on a deposit slip is fixed at 14, based on the paper

// form assumed by Reports/PrintDeposit.php. If we make this form configurable this number may change.

$checksFit = 14;

$sSQL = "SELECT plg_plgID from pledge_plg where plg_depID=" . $iCurrentDeposit . " AND plg_method='CHECK'";

$rsChecksThisDep = RunQuery ($sSQL);

$checkCount = mysql_num_rows ($rsChecksThisDep);

$roomForChecks = $checksFit - $checkCount;

if ($roomForChecks <= 0)

$sPageTitle .= "<font color=red>";

$sPageTitle .= " (" . $roomForChecks . gettext (" more checks will fit.") . ")";

if ($roomForChecks <= 0)

$sPageTitle .= "</font>";

} else {

if ($iPledgeID)

$sPageTitle = gettext("Payment Editor - Modify Existing Payment");

else

$sPageTitle = gettext("Payment Editor - New Deposit Slip Will Be Created");

}

if ($dep_Closed && $iPledgeID && $PledgeOrPayment == 'Payment')

$sPageTitle .= " &nbsp; <font color=red>Deposit closed</font>";

// Security: User must have Finance permission to use this form.

// Clean error handling: (such as somebody typing an incorrect URL ?PersonID= manually)

if (! $_SESSION['bFinance'])

{

Redirect("Menu.php");

exit;

}

// Instantiate the MICR class

$micrObj = new MICRReader();

//Is this the second pass?

if (isset($_POST["PledgeSubmit"]) || isset($_POST["PledgeSubmitAndAdd"]) || isset($_POST["MatchFamily"]) ||

isset($_POST["MatchEnvelope"]) || isset($_POST["SetDefaultCheck"]))

{

$iFamily = 0;

$iCheckNo = 0;

// Take care of match-family first- select the family based on the scanned check

if (isset($_POST["MatchFamily"])) {

$tScanString = FilterInput($_POST["ScanInput"]);

$routeAndAccount = $micrObj->FindRouteAndAccount ($tScanString); // use routing and account number for matching

if ($routeAndAccount) {

$sSQL = "SELECT fam_ID FROM family_fam WHERE fam_scanCheck REGEXP \"" . $routeAndAccount . "\"";

$rsFam = RunQuery($sSQL);

extract(mysql_fetch_array($rsFam));

$iFamily = $fam_ID;

$iCheckNo = $micrObj->FindCheckNo ($tScanString);

} else {

$iFamily = FilterInput($_POST["Family"],'int');

$iCheckNo = FilterInput($_POST["CheckNo"], 'int');

}

} else if (isset($_POST["MatchEnvelope"])) {

// Match envelope is similar to match check- use the envelope number to choose a family

$iEnvelope = FilterInput($_POST["Envelope"], 'int');

$sSQL = "SELECT fam_ID FROM family_fam WHERE fam_Envelope=" . $iEnvelope;

$rsFam = RunQuery($sSQL);

extract(mysql_fetch_array($rsFam));

$iFamily = $fam_ID;

} else {

$iFamily = FilterInput($_POST["Family"],'int');

$iCheckNo = FilterInput($_POST["CheckNo"], 'int');

}

// Handle special buttons at the bottom of the form.

if (isset($_POST["SetDefaultCheck"])) {

$tScanString = FilterInput($_POST["ScanInput"]);

$iFamily = FilterInput($_POST["Family"],'int');

$sSQL = "UPDATE family_fam SET fam_scanCheck=\"" . $tScanString . "\" WHERE fam_ID = " . $iFamily;

RunQuery($sSQL);

}

//Get all the variables from the request object and assign them locally

$iFYID = FilterInput($_POST["FYID"], 'int');

$dDate = FilterInput($_POST["Date"]);

$nAmount = FilterInput($_POST["Amount"]);

$iSchedule = FilterInput($_POST["Schedule"]);

$iMethod = FilterInput($_POST["Method"]);

$sComment = FilterInput($_POST["Comment"]);

$iFundID = FilterInput($_POST["FundID"],'int');

$tScanString = FilterInput($_POST["ScanInput"]);

$iAutID = FilterInput($_POST["AutoPay"]);

$nNonDeductible = FilterInput($_POST["NonDeductible"]);

$iEnvelope = FilterInput($_POST["Envelope"], 'int');

if ($iAutID=="")

$iAutID=0;

if ($iSchedule=='')

$iSchedule='Once';

if ($nNonDeductible=='')

$nNonDeductible=0;

if (! $iCheckNo)

$iCheckNo = "NULL";

$_SESSION['idefaultFY'] = $iFYID; // Remember default fiscal year

$_SESSION['idefaultFundID'] = $iFundID; // Remember current fund id and method (not stored- just for this session)

$_SESSION['idefaultPaymentMethod'] = $iMethod;

//Initialize the error flag

$bErrorFlag = false;

//Validate the Amount

if (strlen($nAmount) < 1)

{

$sAmountError = gettext("You must enter an Amount.");

$bErrorFlag = true;

}

//Validate the NonDeductible Amount

if ($nNonDeductible > $nAmount)

{

$sNonDeductibleError = gettext("NonDeductible amount can't be greater than total amount.");

$bErrorFlag = true;

}

// Validate Date

if (strlen($dDate) > 0)

{

list($iYear, $iMonth, $iDay) = sscanf($dDate,"%04d-%02d-%02d");

if ( !checkdate($iMonth,$iDay,$iYear) )

{

$sDateError = "<span style=\"color: red; \">" . gettext("Not a valid Date") . "</span>";

$bErrorFlag = true;

}

}

//If no errors, then let's update...

if (!$bErrorFlag)

{

// New pledge or deposit

if (strlen($iPledgeID) < 1)

{

// Create new Deposit Slip

if ((!$iCurrentDeposit) && $PledgeOrPayment=='Payment') {

if ($iMethod == "CASH" || $iMethod == "CHECK")

$dep_Type = "Bank";

elseif ($iMethod == "CREDITCARD")

$dep_Type = "CreditCard";

elseif ($iMethod == "BANKDRAFT")

$dep_Type = "BankDraft";

$sSQL = "INSERT INTO deposit_dep (dep_Date, dep_Comment, dep_EnteredBy, dep_Type)

VALUES ('" . date("Y-m-d") . "','Automatically created because current slip was closed'," . $_SESSION['iUserID'] . ",'$dep_Type')";

RunQuery($sSQL);

$sSQL = "SELECT MAX(dep_ID) AS iDepositSlipID FROM deposit_dep";

$rsDepositSlipID = RunQuery($sSQL);

extract(mysql_fetch_array($rsDepositSlipID));

$_SESSION['iCurrentDeposit'] = $iDepositSlipID;

$iCurrentDeposit = $iDepositSlipID;

$dep_Date = date("Y-m-d");

}

// Only set PledgeOrPayment when the record is first created

$sSQL = "INSERT INTO pledge_plg (plg_FamID, plg_FYID, plg_date, plg_amount, plg_schedule, plg_method, plg_comment, plg_DateLastEdited, plg_EditedBy, plg_PledgeOrPayment, plg_fundID, plg_depID, plg_CheckNo, plg_scanString, plg_aut_ID, plg_NonDeductible)

VALUES ('" . $iFamily . "','" . $iFYID . "','" . $dDate . "','" . $nAmount . "','" . $iSchedule . "','" . $iMethod . "','" . $sComment . "'";

$sSQL .= ",'" . date("YmdHis") . "'," . $_SESSION['iUserID'] . ",'" . $PledgeOrPayment . "'," . $iFundID . "," . $iCurrentDeposit . "," . $iCheckNo . ",\"" . $tScanString . "\",\"" . $iAutID . "\",\"" . $nNonDeductible . "\")";

$bGetKeyBack = True;

// Existing record (update)

} else {

$sSQL = "UPDATE pledge_plg SET plg_FamID = '" . $iFamily . "',plg_FYID = '" . $iFYID . "',plg_date = '" . $dDate . "', plg_amount = '" . $nAmount . "', plg_schedule = '" . $iSchedule . "', plg_method = '" . $iMethod . "', plg_comment = '" . $sComment . "'";

$sSQL .= ", plg_DateLastEdited = '" . date("YmdHis") . "', plg_EditedBy = " . $_SESSION['iUserID'] . ", plg_fundID = " . $iFundID . ", plg_CheckNo = " . $iCheckNo . ", plg_scanString = \"" . $tScanString . "\", plg_aut_ID=\"" . $iAutID . "\", plg_NonDeductible=\"" . $nNonDeductible . "\" WHERE plg_plgID = " . $iPledgeID;

$bGetKeyBack = false;

}

//Execute the SQL

RunQuery($sSQL);

// If this is a new pledge or deposit, get the key back

if ($bGetKeyBack)

{

$sSQL = "SELECT MAX(plg_plgID) AS iPledgeID FROM pledge_plg";

$rsPledgeID = RunQuery($sSQL);

extract(mysql_fetch_array($rsPledgeID));

}

if (isset($_POST["PledgeSubmit"]))

{

// Check for redirection to another page after saving information: (ie. PledgeEditor.php?previousPage=prev.php?a=1;b=2;c=3)

if ($linkBack != "") {

Redirect($linkBack);

} else {

//Send to the view of this pledge

Redirect("PledgeEditor.php?PledgeOrPayment=" . $PledgeOrPayment . "&PledgeID=" . $iPledgeID . "&linkBack=", $linkBack);

}

}

else if (isset($_POST["PledgeSubmitAndAdd"]))

{

//Reload to editor to add another record

Redirect("PledgeEditor.php?CurrentDeposit=$iCurrentDeposit&PledgeOrPayment=" . $PledgeOrPayment . "&linkBack=", $linkBack);

}

}

} else {

//FirstPass

//Are we editing or adding?

if (strlen($iPledgeID) > 0)

{

//Editing....

//Get all the data on this record

$sSQL = "SELECT * FROM pledge_plg LEFT JOIN family_fam ON plg_famID = fam_ID WHERE plg_plgID = " . $iPledgeID;

$rsPledge = RunQuery($sSQL);

extract(mysql_fetch_array($rsPledge));

$iFYID = $plg_FYID;

$dDate = $plg_date;

$nAmount = $plg_amount;

$iCheckNo = $plg_CheckNo;

$iFundID = $plg_fundID;

$iSchedule = $plg_schedule;

$iMethod = $plg_method;

$sComment = $plg_comment;

$iFamily = $plg_FamID;

$tScanString = $plg_scanString;

$PledgeOrPayment = $plg_PledgeOrPayment;

$iAutID = $plg_aut_ID;

$nNonDeductible = $plg_NonDeductible;

}

else

{

//Adding....

//Set defaults

$iFamily = $FamIDIn; // Will be set only if they pressed the "add pledge" link in the family view

$iFYID = $_SESSION['idefaultFY'];

$dDate = date ("Y-m-d");

if (!$iFYID)

$iFYID = CurrentFY();

if ($dep_Type == "CreditCard")

$iMethod = "CREDITCARD";

else if ($dep_Type == "BankDraft")

$iMethod = "BANKDRAFT";

$iFundID = $_SESSION['idefaultFundID'];

$iMethod = $_SESSION['idefaultPaymentMethod'];

$iAutID = 0;

}

}

// Set Current Deposit setting for user

if ($iCurrentDeposit) {

$sSQL = "UPDATE user_usr SET usr_currentDeposit = '$iCurrentDeposit' WHERE usr_per_id = \"".$_SESSION['iUserID']."\"";

$rsUpdate = RunQuery($sSQL);

}

//Get Families for the drop-down

$sSQL = "SELECT fam_ID, fam_Name, fam_Address1, fam_City, fam_State FROM family_fam ORDER BY fam_Name";

$rsFamilies = RunQuery($sSQL);

require "Include/Header.php";

?>

<form method="post" action="PledgeEditor.php?<?php echo "CurrentDeposit=" . $iCurrentDeposit . "&PledgeID=" . $iPledgeID . "&PledgeOrPayment=" . $PledgeOrPayment. "&linkBack=" . $linkBack; ?>" name="PledgeEditor">

<table cellpadding="3" align="center">

<tr>

<td align="center">

<input type="submit" class="icButton" value="<?php echo gettext("Save"); ?>" name="PledgeSubmit">

<?php if ($_SESSION['bAddRecords']) { echo "<input type=\"submit\" class=\"icButton\" value=\"" . gettext("Save and Add") . "\" name=\"PledgeSubmitAndAdd\">"; } ?>

<input type="button" class="icButton" value="<?php echo gettext("Cancel"); ?>" name="PledgeCancel" onclick="javascript:document.location='<?php if (strlen($linkBack) > 0) { echo $linkBack; } else {echo "Menu.php"; } ?>';">

</td>

</tr>

<tr>

<td>

<table border="0" width="100%" cellspacing="0" cellpadding="4">

<td width="50%" valign="top" align="left">

<table cellpadding="3">

<tr>

<td <?php if ($PledgeOrPayment=='Pledge') echo "class=\"LabelColumn\">"; else echo "class=\"PaymentLabelColumn\">"; ?><?php addToolTip("Select the pledging family from the list."); ?><?php echo gettext("Family:"); ?></td>

<td class="TextColumn">

<select name="Family">

<option value="0" selected><?php echo gettext("Unassigned"); ?></option>

<?php

// Build Criteria for Head of Household

if (!$sDirRoleHead)

$sDirRoleHead = "1";

$head_criteria = " per_fmr_ID = " . $sDirRoleHead;

// If more than one role assigned to Head of Household, add OR

$head_criteria = str_replace(",", " OR per_fmr_ID = ", $head_criteria);

// Add Spouse to criteria

if (intval($sDirRoleSpouse) > 0)

$head_criteria .= " OR per_fmr_ID = $sDirRoleSpouse";

// Build array of Head of Households and Spouses with fam_ID as the key

$sSQL = "SELECT per_FirstName, per_fam_ID FROM person_per WHERE per_fam_ID > 0 AND (" . $head_criteria . ") ORDER BY per_fam_ID";

$rs_head = RunQuery($sSQL);

$aHead = "";

while (list ($head_firstname, $head_famid) = mysql_fetch_row($rs_head)){

if ($head_firstname && $aHead[$head_famid])

$aHead[$head_famid] .= " & " . $head_firstname;

elseif ($head_firstname)

$aHead[$head_famid] = $head_firstname;

}

while ($aRow = mysql_fetch_array($rsFamilies))

{

extract($aRow);

echo "<option value=\"" . $fam_ID . "\"";

if ($iFamily == $fam_ID) { echo " selected"; }

echo ">" . $fam_Name;

if ($aHead[$fam_ID])

echo ", " . $aHead[$fam_ID];

echo " " . FormatAddressLine($fam_Address1, $fam_City, $fam_State);

}

?>

</select>

</td>

</tr>

<tr>

<td <?php if ($PledgeOrPayment=='Pledge') echo "class=\"LabelColumn\">"; else echo "class=\"PaymentLabelColumn\">"; ?><?php echo gettext("Fiscal Year:"); ?></td>

<td class="TextColumnWithBottomBorder">

<?php PrintFYIDSelect ($iFYID, "FYID") ?>

</td>

</tr>

<tr>

<td <?php if ($PledgeOrPayment=='Pledge') echo "class=\"LabelColumn\""; else echo "class=\"PaymentLabelColumn\""; ?><?php addToolTip("Format: YYYY-MM-DD<br>or enter the date by clicking on the calendar icon to the right."); ?>><?php echo gettext("Date:"); ?></td>

<?php if (!$dDate) $dDate = $dep_Date ?>

<td class="TextColumn"><input type="text" name="Date" value="<?php echo $dDate; ?>" maxlength="10" id="sel1" size="11">&nbsp;<input type="image" onclick="return showCalendar('sel1', 'y-mm-dd');" src="Images/calendar.gif"> <span class="SmallText"><?php echo gettext("[format: YYYY-MM-DD]"); ?></span><font color="red"><?php echo $sDateError ?></font></td>

</tr>

<tr>

<td <?php if ($PledgeOrPayment=='Pledge') echo "class=\"LabelColumn\">"; else echo "class=\"PaymentLabelColumn\">"; ?><?php echo gettext("Fund:"); ?></td>

<td class="TextColumnWithBottomBorder">

<select name="FundID">

<option value="0"><?php echo gettext("None"); ?></option>

<?php

mysql_data_seek($rsFunds,0);

while ($row = mysql_fetch_array($rsFunds))

{

$fun_id = $row["fun_ID"];

$fun_name = $row["fun_Name"];

$fun_active = $row["fun_Active"];

echo "<option value=\"$fun_id\" " ;

if ($iFundID == $fun_id)

echo "selected" ;

echo ">$fun_name";

if ($fun_active != 'true') echo " (" . gettext("inactive") . ")";

echo "</option>" ;

}

?>

</select>

</td>

</tr>

<?php if ($dep_Type == 'Bank' && $PledgeOrPayment!='Pledge') {?>

<tr>

<td class="PaymentLabelColumn"><?php echo gettext("Check number:"); ?></td>

<td class="TextColumn"><input type="text" name="CheckNo" id="CheckNo" value="<?php echo $iCheckNo; ?>"></td>

</tr>

<?php } ?>

</table>

</td>

<td width="50%" valign="top" align="center">

<table cellpadding="3">

<tr>

<td <?php if ($PledgeOrPayment=='Pledge') echo "class=\"LabelColumn\">"; else echo "class=\"PaymentLabelColumn\">"; ?><?php echo gettext("Total Amount:"); ?></td>

<td class="TextColumn"><input type="text" name="Amount" id="Amount" value="<?php echo $nAmount; ?>"><br><font color="red"><?php echo $sAmountError ?></font></td>

</tr>

<tr>

<td <?php if ($PledgeOrPayment=='Pledge') echo "class=\"LabelColumn\">"; else echo "class=\"PaymentLabelColumn\">"; ?><?php echo gettext("Non Deductible Amount:<br>($0 if all is deductible)"); ?></td>

<td class="TextColumn"><input type="text" name="NonDeductible" id="Amount" value="<?php echo $nNonDeductible; ?>"><br><font color="red"><?php echo $sNonDeductibleError ?></font></td>

</tr>

<?php if ($PledgeOrPayment=='Pledge') {?>

<tr>

<td <?php if ($PledgeOrPayment=='Pledge') echo "class=\"LabelColumn\">"; else echo "class=\"PaymentLabelColumn\">"; ?><?php echo gettext("Payment Schedule:"); ?></td>

<td class="TextColumnWithBottomBorder">

<select name="Schedule">

<option value="0"><?php echo gettext("Select Schedule"); ?></option>

<option value="Monthly" <?php if ($iSchedule == "Monthly") { echo "selected"; } ?>><?php echo gettext("Monthly"); ?></option>

<option value="Quarterly" <?php if ($iSchedule == "Quarterly") { echo "selected"; } ?>><?php echo gettext("Quarterly"); ?></option>

<option value="Once" <?php if ($iSchedule == "Once") { echo "selected"; } ?>><?php echo gettext("Once"); ?></option>

<option value="Other" <?php if ($iSchedule == "Other") { echo "selected"; } ?>><?php echo gettext("Other"); ?></option>

</select>

</td>

</tr>

<?php } ?>

<tr>

<td <?php if ($PledgeOrPayment=='Pledge') echo "class=\"LabelColumn\">"; else echo "class=\"PaymentLabelColumn\">"; ?><?php echo gettext("Payment Method:"); ?></td>

<td class="TextColumnWithBottomBorder">

<select name="Method">

<?php if ($PledgeOrPayment=='Pledge' || $dep_Type == "Bank" || !$iCurrentDeposit) { ?>

<option value="CHECK" <?php if ($iMethod == "CHECK") { echo "selected"; } ?>><?php echo gettext("CHECK"); ?></option>

<option value="CASH" <?php if ($iMethod == "CASH") { echo "selected"; } ?>><?php echo gettext("CASH"); ?></option>

<?php } ?>

<?php if ($PledgeOrPayment=='Pledge' || $dep_Type == "CreditCard" || !$iCurrentDeposit) { ?>

<option value="CREDITCARD" <?php if ($iMethod == "CREDITCARD") { echo "selected"; } ?>><?php echo gettext("Credit Card"); ?></option>

<?php } ?>

<?php if ($PledgeOrPayment=='Pledge' || $dep_Type == "BankDraft" || !$iCurrentDeposit) { ?>

<option value="BANKDRAFT" <?php if ($iMethod == "BANKDRAFT") { echo "selected"; } ?>><?php echo gettext("Bank Draft"); ?></option>

<?php } ?>

</select>

</td>

</tr>

<tr>

<td <?php if ($PledgeOrPayment=='Pledge') echo "class=\"LabelColumn\">"; else echo "class=\"PaymentLabelColumn\">"; ?><?php echo gettext("Comment:"); ?></td>

<td class="TextColumn"><input type="text" name="Comment" id="Comment" value="<?php echo $sComment; ?>"></td>

</tr>

</td>

</table>

<tr>

<table cellpadding="3">

<td width="100%" valign="top" align="left">

<?php if ($dep_Type == 'Bank' || $PledgeOrPayment=='Pledge') {?>

<tr>

<td <?php if ($PledgeOrPayment=='Pledge') echo "class=\"LabelColumn\">"; else echo "class=\"PaymentLabelColumn\">";echo gettext("Scan check");?></td>

<td><textarea name="ScanInput" rows="2" cols="90"><?php echo $tScanString?></textarea></td>

</tr>

<?php if ($bUseDonationEnvelopes) {?>

<tr>

<td <?php if ($PledgeOrPayment=='Pledge') echo "class=\"LabelColumn\">"; else echo "class=\"PaymentLabelColumn\">";echo gettext("Envelope");?></td>

<td class="TextColumn"><input type="text" name="Envelope" id="Envelope" value="<?php echo $iEnvelope; ?>"></td>

</tr>

<?php } ?>

<?php } ?>

<?php

if (($dep_Type == 'CreditCard') || ($dep_Type == 'BankDraft')) {

?>

<tr>

<td <?php if ($PledgeOrPayment=='Pledge') echo "class=\"LabelColumn\">"; else echo "class=\"PaymentLabelColumn\">";echo gettext("Choose online payment method");?></td>

<td class="TextColumnWithBottomBorder">

<select name="AutoPay">

<?php

echo "<option value=0";

if ($iAutID == 0)

echo " selected";

echo ">" . gettext ("Select online payment record") . "</option>\n";

$sSQLTmp = "SELECT aut_ID, aut_CreditCard, aut_BankName, aut_Route, aut_Account FROM autopayment_aut WHERE aut_FamID=" . $iFamily;

$rsFindAut = RunQuery($sSQLTmp);

while ($aRow = mysql_fetch_array($rsFindAut))

{

extract($aRow);

if ($aut_CreditCard <> "") {

$showStr = gettext ("Credit card ...") . substr ($aut_CreditCard, strlen ($aut_CreditCard) - 4, 4);

} else {

$showStr = gettext ("Bank account ") . $aut_BankName . " " . $aut_Route . " " . $aut_Account;

}

echo "<option value=" . $aut_ID;

if ($iAutID == $aut_ID)

echo " selected";

echo ">" . $showStr . "</option>\n";

}

?>

</select>

</td>

</tr>

<?php

}

?>

</table>

</td>

</table>

</td>

<?php

if ($dep_Type == 'Bank') {

?>

<tr>

<td align="center">

<?php if ($bUseDonationEnvelopes) { ?>

<input type="submit" class="icButton" value="<?php echo gettext("Match family to envelope"); ?>" name="MatchEnvelope">

<?php } ?>

<input type="submit" class="icButton" value="<?php echo gettext("Match family to check"); ?>" name="MatchFamily">

<input type="submit" class="icButton" value="<?php echo gettext("Set default check for family"); ?>" name="SetDefaultCheck">

</td>

</tr>

<?php

}

?>

</form>

</table>

<?php

require "Include/Footer.php";

?>