$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';