}
}
while ($aRow = mysql_fetch_array($rsFamilies)) {
extract($aRow);
echo "<option value=\"" . $fam_ID . "\"";
if ($fam_ID == $iFamilyID) {
echo " selected";
}
echo ">" . $fam_Name;
if ($aHead[$fam_ID]) {
echo ", " . $aHead[$fam_ID];
}
if ($fam_ID == $iFamilyID) {
echo " -- " . gettext("CURRENT FAMILY WITH DONATIONS");
} else {
echo " " . FormatAddressLine($fam_Address1, $fam_City, $fam_State);
}
}
echo "</select><br><br>";
echo "<input type=submit name=CancelFamily value=\"Cancel and Return to Family View\"> ";
echo "<input type=submit name=MoveDonations value=\"Move Donations to Selected Family\">";
echo "</div></form>";
// Show payments connected with family
// -----------------------------------
echo "<br><br>";
//Get the pledges for this family
$sSQL = "SELECT plg_plgID, plg_FYID, plg_date, plg_amount, plg_schedule, plg_method, \n\t\t plg_comment, plg_DateLastEdited, plg_PledgeOrPayment, a.per_FirstName AS EnteredFirstName, a.Per_LastName AS EnteredLastName, b.fun_Name AS fundName\n\t\t\t\t FROM pledge_plg \n\t\t\t\t LEFT JOIN person_per a ON plg_EditedBy = a.per_ID\n\t\t\t\t LEFT JOIN donationfund_fun b ON plg_fundID = b.fun_ID\n\t\t\t\t WHERE plg_famID = " . $iFamilyID . " ORDER BY pledge_plg.plg_date";
$rsPledges = RunQuery($sSQL);
?>
<table cellpadding="5" cellspacing="0" width="100%">
<tr class="TableHeader">
switch ($per_Gender) {
case 1:
echo gettext("Male");
break;
case 2:
echo gettext("Female");
break;
default:
echo "";
}
}
echo " </td>";
echo "<td>";
if ($fam_Name != "") {
echo "<a href=\"FamilyView.php?FamilyID=" . $fam_ID . "\">" . $fam_Name;
echo FormatAddressLine($fam_Address1, $fam_City, $fam_State) . "</a>";
}
echo " </td>";
echo "<td>";
// Phone number or zip code
if ($sPersonColumn5 == "Home Phone") {
echo SelectWhichInfo(ExpandPhoneNumber($fam_HomePhone, $fam_Country, $dummy), ExpandPhoneNumber($per_HomePhone, $fam_Country, $dummy), True);
} elseif ($sPersonColumn5 == "Work Phone") {
echo SelectWhichInfo(ExpandPhoneNumber($per_WorkPhone, $fam_Country, $dummy), ExpandPhoneNumber($fam_WorkPhone, $fam_Country, $dummy), True);
} elseif ($sPersonColumn5 == "Mobile Phone") {
echo SelectWhichInfo(ExpandPhoneNumber($per_CellPhone, $fam_Country, $dummy), ExpandPhoneNumber($fam_CellPhone, $fam_Country, $dummy), True);
} else {
if (strlen($zip)) {
echo $zip;
} else {
echo gettext("unassigned");
function getFamilyList($sDirRoleHead, $sDirRoleSpouse, $classification = 0)
{
if ($classification) {
$sSQL = "SELECT fam_ID, fam_Name, fam_Address1, fam_City, fam_State FROM family_fam LEFT JOIN person_per ON fam_ID = per_fam_ID WHERE per_cls_ID='" . $classification . "' ORDER BY fam_Name";
} else {
$sSQL = "SELECT fam_ID, fam_Name, fam_Address1, fam_City, fam_State FROM family_fam ORDER BY fam_Name";
}
$rsFamilies = RunQuery($sSQL);
// 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;
}
}
$familyArray = array();
while ($aRow = mysql_fetch_array($rsFamilies)) {
extract($aRow);
$name = $fam_Name;
if ($aHead[$fam_ID]) {
$name .= ", " . $aHead[$fam_ID];
}
$name .= " " . FormatAddressLine($fam_Address1, $fam_City, $fam_State);
$familyArray[$fam_ID] = $name;
}
return $familyArray;
}
<td class="TextColumn">
<select name="Family" size="8">
<option value="0" selected><?php
echo gettext("Unassigned");
?>
</option>
<option value="0">-----------------------</option>
<?php
while ($aRow = mysql_fetch_array($rsFamilies)) {
extract($aRow);
echo "<option value=\"" . $fam_ID . "\"";
if ($iFamily == $fam_ID) {
echo " selected";
}
echo ">" . $fam_Name . " " . FormatAddressLine($fam_Address1, $fam_City, $fam_State);
}
?>
</select>
</td>
</tr>
<tr>
<td class="LabelColumn"><?php
echo gettext("Automatic payment type");
?>
</td>
<td class="TextColumn"><input type="radio" Name="EnableButton" value="1" <?php
if ($bEnableBankDraft) {
echo " checked";
<td class="TextColumn">
<select name="Family" size="8">
<option value="0" selected><?php
echo gettext("Belum Terisi");
?>
</option>
<option value="0">-----------------------</option>
<?php
while ($aRow = mysql_fetch_array($rsFamilies)) {
extract($aRow);
echo "<option value=\"" . $fam_ID . "\"";
if ($iFamily == $fam_ID) {
echo " selected";
}
echo ">" . $fam_Name . "- " . $fam_NoIndFam . "" . FormatAddressLine($fam_Address1, $fam_City, $fam_State);
}
?>
</select>
</td>
</tr>
<tr>
<td class="LabelColumn"><?php
echo gettext("Halaman Depan:");
?>
</td>
<td class="TextColumn">
<table>
<tr>
<td><?php
echo gettext("Pakai Halaman Depan");
} else {
$sPageTitle = gettext("Payment Editor - New Deposit Slip Will Be Created");
}
}
// end if $PledgeOrPayment
if ($dep_Closed && $sGroupKey && $PledgeOrPayment == 'Payment') {
$sPageTitle .= " <font color=red>Deposit closed</font>";
}
//$familySelectHtml = buildFamilySelect($iFamily, $sDirRoleHead, $sDirRoleSpouse);
$sFamilyName = "";
if ($iFamily) {
$sSQL = "SELECT fam_Name, fam_Address1, fam_City, fam_State FROM family_fam WHERE fam_ID =" . $iFamily;
$rsFindFam = RunQuery($sSQL);
while ($aRow = mysql_fetch_array($rsFindFam)) {
extract($aRow);
$sFamilyName = $fam_Name . " " . FormatAddressLine($fam_Address1, $fam_City, $fam_State);
}
}
require "Include/Header.php";
?>
<form method="post" action="PledgeEditor.php?<?php
echo "CurrentDeposit=" . $iCurrentDeposit . "&GroupKey=" . $sGroupKey . "&PledgeOrPayment=" . $PledgeOrPayment . "&linkBack=" . $linkBack;
?>
" name="PledgeEditor">
<input type="hidden" name="FamilyID" id="FamilyID" value="<?php
echo $iFamily;
?>
">
<input type="hidden" name="PledgeOrPayment" id="PledgeOrPayment" value="<?php
echo $PledgeOrPayment;
