$OutStr .= $sAddress2 . "\n";
}
if (strlen($sCity)) {
$OutStr .= $sCity . ", " . $sState . " " . $sZip . "\n";
}
}
if (isset($_POST['HomePhoneEnable']) && strlen($sHomePhone)) {
$TempStr = ExpandPhoneNumber($sHomePhone, $sDefaultCountry, $bWierd);
$OutStr .= " " . gettext("Phone") . ": " . $TempStr . "\n";
}
if (isset($_POST['WorkPhoneEnable']) && strlen($sWorkPhone)) {
$TempStr = ExpandPhoneNumber($sWorkPhone, $sDefaultCountry, $bWierd);
$OutStr .= " " . gettext("Work") . ": " . $TempStr . "\n";
}
if (isset($_POST['CellPhoneEnable']) && strlen($sCellPhone)) {
$TempStr = ExpandPhoneNumber($sCellPhone, $sDefaultCountry, $bWierd);
$OutStr .= " " . gettext("Cell") . ": " . $TempStr . "\n";
}
if (isset($_POST['EmailEnable']) && strlen($sEmail)) {
$OutStr .= " " . gettext("Email") . ": " . $sEmail . "\n";
}
if (isset($_POST['OtherEmailEnable']) && strlen($aRow['per_WorkEmail'])) {
$OutStr .= " " . gettext("Other Email") . ": " . ($aRow['per_WorkEmail'] .= "\n");
}
if ($bHasProps) {
while ($aPropRow = mysql_fetch_array($rsProps)) {
if (isset($_POST[$aPropRow['prop_Field'] . 'enable'])) {
$currentData = trim($aRow[$aPropRow['prop_Field']]);
$OutStr .= $aPropRow['prop_Name'] . ": " . displayCustomField($aPropRow['type_ID'], $currentData, $aPropRow['prop_Special']) . "\n";
}
}
//Display the row
?>
<tr class="<?php
echo $sRowClass;
?>
">
<td class="TextColumn"><?php
echo FormatFullName($aTitle[$row], $aFistName[$row], $aMiddleName[$row], $aLastName[$row], $aSuffix[$row], 3);
?>
</td>
<td class="TextColumn"><?php
echo $aEmail[$row] ? '<a href="mailto:' . $aEmail[$row] . '" title="Send Email">' . $aEmail[$row] . '</a>' : 'Not Available';
?>
</td>
<td class="TextColumn"><?php
echo $aHomePhone[$row] ? ExpandPhoneNumber($aHomePhone[$row], $aPhoneCountry[$row], $dummy) : 'Not Available';
?>
</td>
<?php
// AddToCart call to go here
?>
<td class="TextColumn"><?php
/* echo '<a onclick="return AddToCart('.$aPersonID[$row].');" href="blank.html">'.gettext("Add to Cart").'</a>'; */
?>
</td>
</tr>
<?php
}
} else {
?>
<caption>
function formCustomField($type, $fieldname, $data, $special, $bFirstPassFlag)
{
global $cnInfoCentral;
switch ($type) {
// Handler for boolean fields
case 1:
echo "<input type=\"radio\" Name=\"" . $fieldname . "\" value=\"true\"";
if ($data == 'true') {
echo " checked";
}
echo ">Yes";
echo "<input type=\"radio\" Name=\"" . $fieldname . "\" value=\"false\"";
if ($data == 'false') {
echo " checked";
}
echo ">No";
echo "<input type=\"radio\" Name=\"" . $fieldname . "\" value=\"\"";
if (strlen($data) == 0) {
echo " checked";
}
echo ">Unknown";
break;
// Handler for date fields
// Handler for date fields
case 2:
echo "<input type=\"text\" id=\"" . $fieldname . "\" Name=\"" . $fieldname . "\" maxlength=\"10\" size=\"15\" value=\"" . $data . "\"> <input type=\"image\" onclick=\"return showCalendar('{$fieldname}', 'y-mm-dd');\" src=\"Images/calendar.gif\"> " . gettext("[format: YYYY-MM-DD]");
break;
// Handler for 50 character max. text fields
// Handler for 50 character max. text fields
case 3:
echo "<input type=\"text\" Name=\"" . $fieldname . "\" maxlength=\"50\" size=\"50\" value=\"" . htmlentities(stripslashes($data), ENT_NOQUOTES, "UTF-8") . "\">";
break;
// Handler for 100 character max. text fields
// Handler for 100 character max. text fields
case 4:
echo "<textarea Name=\"" . $fieldname . "\" cols=\"40\" rows=\"2\" onKeyPress=\"LimitTextSize(this,100)\">" . htmlentities(stripslashes($data), ENT_NOQUOTES, "UTF-8") . "</textarea>";
break;
// Handler for extended text fields (MySQL type TEXT, Max length: 2^16-1)
// Handler for extended text fields (MySQL type TEXT, Max length: 2^16-1)
case 5:
echo "<textarea Name=\"" . $fieldname . "\" cols=\"60\" rows=\"4\" onKeyPress=\"LimitTextSize(this, 65535)\">" . htmlentities(stripslashes($data), ENT_NOQUOTES, "UTF-8") . "</textarea>";
break;
// Handler for 4-digit year
// Handler for 4-digit year
case 6:
echo "<input type=\"text\" Name=\"" . $fieldname . "\" maxlength=\"4\" size=\"6\" value=\"" . $data . "\">";
break;
// Handler for season (drop-down selection)
// Handler for season (drop-down selection)
case 7:
echo "<select name=\"{$fieldname}\">";
echo "\t<option value=\"none\">" . gettext("Select Season") . "</option>";
echo "\t<option value=\"winter\"";
if ($data == 'winter') {
echo " selected";
}
echo ">" . gettext("Winter") . "</option>";
echo "\t<option value=\"spring\"";
if ($data == 'spring') {
echo " selected";
}
echo ">" . gettext("Spring") . "</option>";
echo "\t<option value=\"summer\"";
if ($data == 'summer') {
echo "selected";
}
echo ">" . gettext("Summer") . "</option>";
echo "\t<option value=\"fall\"";
if ($data == 'fall') {
echo " selected";
}
echo ">" . gettext("Fall") . "</option>";
echo "</select>";
break;
// Handler for integer numbers
// Handler for integer numbers
case 8:
echo "<input type=\"text\" Name=\"" . $fieldname . "\" maxlength=\"11\" size=\"15\" value=\"" . $data . "\">";
break;
// Handler for "person from group"
// Handler for "person from group"
case 9:
// ... Get First/Last name of everyone in the group, plus their person ID ...
// In this case, prop_Special is used to store the Group ID for this selection box
// This allows the group special-property designer to allow selection from a specific group
$sSQL = "SELECT person_per.per_ID, person_per.per_FirstName, person_per.per_LastName\n\t\t\t\t\t\tFROM person2group2role_p2g2r\n\t\t\t\t\t\tLEFT JOIN person_per ON person2group2role_p2g2r.p2g2r_per_ID = person_per.per_ID\n\t\t\t\t\t\tWHERE p2g2r_grp_ID = " . $special . " ORDER BY per_FirstName";
$rsGroupPeople = RunQuery($sSQL);
echo "<select name=\"" . $fieldname . "\">";
echo "<option value=\"0\"";
if ($data <= 0) {
echo " selected";
}
echo ">" . gettext("Unassigned") . "</option>";
echo "<option value=\"0\">-----------------------</option>";
while ($aRow = mysql_fetch_array($rsGroupPeople)) {
extract($aRow);
echo "<option value=\"" . $per_ID . "\"";
if ($data == $per_ID) {
echo " selected";
}
echo ">" . $per_FirstName . " " . $per_LastName . "</option>";
}
echo "</select>";
break;
// Handler for money amounts
// Handler for money amounts
case 10:
echo "<input type=\"text\" Name=\"" . $fieldname . "\" maxlength=\"13\" size=\"16\" value=\"" . $data . "\">";
break;
// Handler for phone numbers
// Handler for phone numbers
case 11:
// This is silly. Perhaps ExpandPhoneNumber before this function is called!
if ($bFirstPassFlag) {
// in this case, $special is the phone country
$data = ExpandPhoneNumber($data, $special, $bNoFormat_Phone);
}
if (isset($_POST[$fieldname . "noformat"])) {
$bNoFormat_Phone = true;
}
echo "<input type=\"text\" Name=\"" . $fieldname . "\" maxlength=\"30\" size=\"30\" value=\"" . htmlentities(stripslashes($data), ENT_NOQUOTES, "UTF-8") . "\">";
echo "<br><input type=\"checkbox\" name=\"" . $fieldname . "noformat\" value=\"1\"";
if ($bNoFormat_Phone) {
echo " checked";
}
echo ">" . gettext("Do not auto-format");
break;
// Handler for custom lists
// Handler for custom lists
case 12:
$sSQL = "SELECT * FROM list_lst WHERE lst_ID = {$special} ORDER BY lst_OptionSequence";
$rsListOptions = RunQuery($sSQL);
echo "<select name=\"" . $fieldname . "\">";
echo "<option value=\"0\" selected>" . gettext("Unassigned") . "</option>";
echo "<option value=\"0\">-----------------------</option>";
while ($aRow = mysql_fetch_array($rsListOptions)) {
extract($aRow);
echo "<option value=\"" . $lst_OptionID . "\"";
if ($data == $lst_OptionID) {
echo " selected";
}
echo ">" . $lst_OptionName . "</option>";
}
echo "</select>";
break;
// Otherwise, display error for debugging.
// Otherwise, display error for debugging.
default:
echo "<b>" . gettext("Error: Invalid Editor ID!") . "</b>";
break;
}
}
<?php
$sSQL = 'SELECT person_id, per_LastName FROM event_attend JOIN person_per ON person_per.per_id = event_attend.person_id WHERE event_id = ' . $EventID . ' ORDER by per_LastName, per_FirstName';
$rsOpps = RunQuery($sSQL);
$numAttRows = mysql_num_rows($rsOpps);
if ($numAttRows != 0) {
$sRowClass = "RowColorA";
for ($na = 0; $na < $numAttRows; $na++) {
$attRow = mysql_fetch_array($rsOpps, MYSQL_BOTH);
extract($attRow);
$sSQL = 'SELECT per_Title, per_ID, per_FirstName, per_MiddleName, per_LastName, per_Suffix, per_Email, per_HomePhone, per_Country, fam_HomePhone, fam_Email, fam_Country FROM person_per LEFT JOIN family_fam ON per_fam_id=fam_id WHERE per_ID = ' . $person_id;
$perOpps = RunQuery($sSQL);
$perRow = mysql_fetch_array($perOpps, MYSQL_BOTH);
extract($perRow);
$sRowClass = AlternateRowStyle($sRowClass);
$sPhoneCountry = SelectWhichInfo($per_Country, $fam_Country, False);
$sHomePhone = SelectWhichInfo(ExpandPhoneNumber($per_HomePhone, $sPhoneCountry, $dummy), ExpandPhoneNumber($fam_HomePhone, $fam_Country, $dummy), True);
$sEmail = SelectWhichInfo($per_Email, $fam_Email, False);
?>
<tr class="<?php
echo $sRowClass;
?>
">
<td class="TextColumn"><?php
echo FormatFullName($per_Title, $per_FirstName, $per_MiddleName, $per_LastName, $per_Suffix, 3);
?>
</td>
<td class="TextColumn"><?php
echo $sEmail ? '<a href="mailto:' . $sEmail . '" title="Send Email">' . $sEmail . '</a>' : 'Not Available';
?>
</td>
<td class="TextColumn"><?php
$fam_Country = "";
$fam_HomePhone = "";
$fam_CellPhone = "";
$fam_Email = "";
extract($aRow);
//Alternate the row color
$sRowClass = AlternateRowStyle($sRowClass);
// Assign the values locally, after selecting whether to display the family or person information
SelectWhichAddress($sAddress1, $sAddress2, $per_Address1, $per_Address2, $fam_Address1, $fam_Address2, False);
$sCity = SelectWhichInfo($per_City, $fam_City, False);
$sState = SelectWhichInfo($per_State, $fam_State, False);
$sZip = SelectWhichInfo($per_Zip, $fam_Zip, False);
$sCountry = SelectWhichInfo($per_Country, $fam_Country, False);
$sHomePhone = SelectWhichInfo(ExpandPhoneNumber($per_HomePhone, $sCountry, $dummy), ExpandPhoneNumber($fam_HomePhone, $fam_Country, $dummy), False);
$sWorkPhone = SelectWhichInfo(ExpandPhoneNumber($per_WorkPhone, $sCountry, $dummy), ExpandPhoneNumber($fam_WorkPhone, $fam_Country, $dummy), False);
$sCellPhone = SelectWhichInfo(ExpandPhoneNumber($per_CellPhone, $sCountry, $dummy), ExpandPhoneNumber($fam_CellPhone, $fam_Country, $dummy), False);
$sUnformattedEmail = SelectWhichInfo($per_Email, $fam_Email, False);
//Display the row
?>
<tr class="<?php
echo $sRowClass;
?>
">
<td><?php
echo FormatFullName($per_Title, $per_FirstName, $per_MiddleName, $per_LastName, $per_Suffix, 0);
?>
</td>
<td><?php
echo $sAddress1;
?>
$sZip = $fam_Zip;
$sCountry = $fam_Country;
$sHomePhone = $fam_HomePhone;
$sWorkPhone = $fam_WorkPhone;
$sCellPhone = $fam_CellPhone;
$sEmail = $fam_Email;
$bSendNewsLetter = $fam_SendNewsLetter == 'TRUE';
$bOkToCanvass = $fam_OkToCanvass == 'TRUE';
$iCanvasser = $fam_Canvasser;
$dWeddingDate = $fam_WeddingDate;
$nLatitude = $fam_Latitude;
$nLongitude = $fam_Longitude;
// Expand the phone number
$sHomePhone = ExpandPhoneNumber($sHomePhone, $sCountry, $bNoFormat_HomePhone);
$sWorkPhone = ExpandPhoneNumber($sWorkPhone, $sCountry, $bNoFormat_WorkPhone);
$sCellPhone = ExpandPhoneNumber($sCellPhone, $sCountry, $bNoFormat_CellPhone);
$sSQL = "SELECT * FROM family_custom WHERE fam_ID = " . $iFamilyID;
$rsCustomData = RunQuery($sSQL);
$aCustomData = mysql_fetch_array($rsCustomData, MYSQL_BOTH);
$aCustomErrors = array();
if ($numCustomFields > 0) {
mysql_data_seek($rsCustomFields, 0);
while ($rowCustomField = mysql_fetch_array($rsCustomFields, MYSQL_BOTH)) {
$aCustomErrors[$rowCustomField['fam_custom_Field']] = false;
}
}
$sSQL = "SELECT * FROM person_per LEFT JOIN family_fam ON per_fam_ID = fam_ID WHERE per_fam_ID =" . $iFamilyID . " ORDER BY per_fmr_ID";
$rsMembers = RunQuery($sSQL);
$iCount = 0;
$iFamilyMemberRows = 0;
while ($aRow = mysql_fetch_array($rsMembers)) {
function sGetMemberString($aRow)
{
global $bDirPersonalPhone;
global $bDirPersonalWork;
global $bDirPersonalCell;
global $bDirPersonalEmail;
global $bDirPersonalWorkEmail;
global $bDirBirthday;
global $aChildren;
extract($aRow);
$sMemberStr = $per_FirstName;
// Check to see if family member has different last name
if (strlen($per_LastName) && $per_LastName != $this->sLastName) {
$sMemberStr .= " " . $per_LastName;
}
if ($bDirBirthday && $per_BirthMonth && $per_BirthDay) {
$sMemberStr .= sprintf(" (%d/%d", $per_BirthMonth, $per_BirthDay);
if ($per_BirthYear && in_array($per_fmr_ID, $aChildren)) {
$sMemberStr .= sprintf("/%d)\n", $per_BirthYear);
} else {
$sMemberStr .= ")\n";
}
} else {
$sMemberStr .= "\n";
}
$sCountry = SelectWhichInfo($per_Country, $fam_Country, false);
if ($bDirPersonalPhone && strlen($per_HomePhone)) {
$TempStr = ExpandPhoneNumber($per_HomePhone, $sCountry, $bWierd);
$sMemberStr .= " " . gettext("Phone") . ": " . ($TempStr .= "\n");
}
if ($bDirPersonalWork && strlen($per_WorkPhone)) {
$TempStr = ExpandPhoneNumber($per_WorkPhone, $sCountry, $bWierd);
$sMemberStr .= " " . gettext("Work") . ": " . ($TempStr .= "\n");
}
if ($bDirPersonalCell && strlen($per_CellPhone)) {
$TempStr = ExpandPhoneNumber($per_CellPhone, $sCountry, $bWierd);
$sMemberStr .= " " . gettext("Cell") . ": " . ($TempStr .= "\n");
}
if ($bDirPersonalEmail && strlen($per_Email)) {
$sMemberStr .= " " . gettext("Email") . ": " . ($per_Email .= "\n");
}
if ($bDirPersonalWorkEmail && strlen($per_WorkEmail)) {
$sMemberStr .= " " . gettext("Work/Other Email") . ": " . ($per_WorkEmail .= "\n");
}
return $sMemberStr;
}
//Get classifications
$sSQL = "SELECT * FROM list_lst WHERE lst_ID = 1 ORDER BY lst_OptionSequence";
$rsClassifications = RunQuery($sSQL);
// Get Field Security List Matrix
$sSQL = "SELECT * FROM list_lst WHERE lst_ID = 5 ORDER BY lst_OptionSequence";
$rsSecurityGrp = RunQuery($sSQL);
while ($aRow = mysql_fetch_array($rsSecurityGrp)) {
extract($aRow);
$aSecurityType[$lst_OptionID] = $lst_OptionName;
}
//Set the spacer cell width
$iTableSpacerWidth = 10;
// Format the phone numbers
$sHomePhone = ExpandPhoneNumber($fam_HomePhone, $fam_Country, $dummy);
$sWorkPhone = ExpandPhoneNumber($fam_WorkPhone, $fam_Country, $dummy);
$sCellPhone = ExpandPhoneNumber($fam_CellPhone, $fam_Country, $dummy);
require "Include/Header.php";
if ($previous_link_text) {
echo "{$previous_link_text} | ";
}
$bOkToEdit = $_SESSION['bEditRecords'] || $_SESSION['bEditSelf'] && $iFamilyID == $_SESSION['iFamID'];
if ($bOkToEdit) {
echo "<a class=\"SmallText\" href=\"FamilyEditor.php?FamilyID=" . $fam_ID . "\">" . gettext("Edit this Record") . "</a> | ";
}
if ($_SESSION['bDeleteRecords']) {
echo "<a class=\"SmallText\" href=\"SelectDelete.php?FamilyID=" . $fam_ID . "\">" . gettext("Delete this Record") . "</a>";
}
if ($next_link_text && ($bOkToEdit || $_SESSION['bDeleteRecords'])) {
echo " | {$next_link_text}";
} elseif ($next_link_text) {
echo "{$next_link_text}";
for ($row = 1; $row <= $numRows; $row++) {
$aRow = mysql_fetch_assoc($rsOpps);
extract($aRow);
if (array_key_exists('Action', $_GET) and $_GET['Action'] == "List") {
$aEventID[$row] = $event_id;
$aEventTitle[$row] = htmlentities(stripslashes($event_title), ENT_NOQUOTES, "UTF-8");
$aEventStartDateTime[$row] = $event_start;
} else {
$aPersonID[$row] = $per_ID;
$aTitle[$row] = $per_Title;
$aFistName[$row] = $per_FirstName;
$aMiddleName[$row] = $per_MiddleName;
$aLastName[$row] = $per_LastName;
$aSuffix[$row] = $per_Suffix;
$aEmail[$row] = $per_Email;
$aHomePhone[$row] = SelectWhichInfo(ExpandPhoneNumber($per_HomePhone, $per_Country, $dummy), ExpandPhoneNumber($fam_HomePhone, $fam_Country, $dummy), True);
}
}
// Construct the form
?>
<table cellpadding="4" align="center" cellspacing="0" width="60%">
<?php
if (array_key_exists('Action', $_GET) and $_GET['Action'] == "List" && $numRows > 0) {
?>
<caption>
<h3><?php
echo gettext("There " . ($numRows == 1 ? "is " . $numRows . " event" : "are " . $numRows . " events")) . " in this category";
?>
</h3>
</caption>
</tr>
<?php
$sSQL = "SELECT * FROM event_attend WHERE event_id={$EventID} ORDER BY person_id";
$rsOpps = RunQuery($sSQL);
$numAttRows = mysql_num_rows($rsOpps);
if ($numAttRows != 0) {
$sRowClass = "RowColorA";
for ($na = 0; $na < $numAttRows; $na++) {
$attRow = mysql_fetch_array($rsOpps, MYSQL_BOTH);
extract($attRow);
$sSQL = "SELECT * FROM person_per WHERE per_ID = {$person_id}";
$perOpps = RunQuery($sSQL);
$perRow = mysql_fetch_array($perOpps, MYSQL_BOTH);
extract($perRow);
$sRowClass = AlternateRowStyle($sRowClass);
$aHomePhone = ExpandPhoneNumber($per_HomePhone, $per_Country, $dummy);
?>
<tr class="<?php
echo $sRowClass;
?>
">
<td class="TextColumn"><?php
echo FormatFullName($per_Title, $per_FirstName, $per_MiddleName, $per_LastName, $per_Suffix, 3);
?>
</td>
<td class="TextColumn"><?php
echo $per_Email ? '<a href="mailto:' . $per_Email . '" title="Send Email">' . $per_Email . '</a>' : 'Not Available';
?>
</td>
<td class="TextColumn"><?php
echo $aHomePhone ? $aHomePhone : 'Not Available';
