PledgeEditor.php

<?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";
?>