$rsPropList = RunQuery($sSQL); $sSQL = "SELECT * FROM groupprop_" . $iGroupID . " WHERE per_ID = " . $per_ID; $rsPersonProps = RunQuery($sSQL); $aPersonProps = mysql_fetch_array($rsPersonProps, MYSQL_BOTH); while ($aProps = mysql_fetch_array($rsPropList)) { extract($aProps); $currentData = trim($aPersonProps[$prop_Field]); if (strlen($currentData) > 0) { // only create the properties table if it's actually going to be used if ($firstRow) { echo "<tr><td colspan=\"3\"><table width=\"100%\"><tr><td width=\"15%\"></td><td><table width=\"90%\" cellspacing=\"0\">"; echo "<tr class=\"TinyTableHeader\"><td>" . gettext("Property") . "</td><td>" . gettext("Value") . "</td></tr>"; $firstRow = false; } $sRowClass = AlternateRowStyle($sRowClass); if ($type_ID == 11) { $prop_Special = $sCountry; } echo "<tr class=\"{$sRowClass}\"><td>" . $prop_Name . "</td><td>" . displayCustomField($type_ID, $currentData, $prop_Special) . "</td></tr>"; } } if (!$firstRow) { echo "</table></td></tr></table></td></tr>"; } } } ?> </table> </body> </html>
} 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"; } } mysql_data_seek($rsProps, 0); } // Count the number of lines in the output string $numlines = 1; $offset = 0; while ($result = strpos($OutStr, "\n", $offset)) { $offset = $result + 1; $numlines++; } //if ($numlines > 1) //{ /* if (strtoupper($sLastLetter) != strtoupper(substr($pdf->sFamily,0,1))) {
</td> </tr> <?php } ?> <?php // Display the right-side custom fields while ($Row = mysql_fetch_array($rsRightFamCustomFields)) { extract($Row); if ($aSecurityType[$fam_custom_FieldSec] == 'bAll' or $_SESSION[$aSecurityType[$fam_custom_FieldSec]]) { $currentData = trim($aFamCustomData[$fam_custom_Field]); if ($type_ID == 11) { $fam_custom_Special = $sPhoneCountry; } echo "<tr><td class=\"TinyLabelColumn\">" . $fam_custom_Name . "</td>"; echo "<td class=\"TinyTextColumn\">" . displayCustomField($type_ID, $currentData, $fam_custom_Special) . "</td></tr>"; } } ?> </table> </td> </tr> </table> </div> <BR> <b><?php echo gettext("Assigned Properties:"); ?> </b> <?php $sAssignedProperties = ",";
function sGetCustomString($rsCustomFields, $aRow) { $numCustomFields = mysql_num_rows($rsCustomFields); if ($numCustomFields > 0) { extract($aRow); $sSQL = "SELECT * FROM person_custom WHERE per_ID = " . $per_ID; $rsCustomData = RunQuery($sSQL); $aCustomData = mysql_fetch_array($rsCustomData, MYSQL_BOTH); $numCustomData = mysql_num_rows($rsCustomData); mysql_data_seek($rsCustomFields, 0); $OutStr = ""; while ($rowCustomField = mysql_fetch_array($rsCustomFields, MYSQL_BOTH)) { extract($rowCustomField); $sCustom = "bCustom" . $custom_Order; if ($this->_Custom[$custom_Order]) { $currentFieldData = displayCustomField($type_ID, $aCustomData[$custom_Field], $custom_Special); // $currentFieldData = trim($aCustomData[$custom_Field]); if ($currentFieldData != "") { $OutStr .= " " . $custom_Name . ": " . ($currentFieldData .= "\n"); } } } return $OutStr; } else { return ""; } }
<span><?php echo $mailchimp->isEmailInMailChimp($fam_Email); ?> </span></a></li> <?php } } // Display the left-side custom fields while ($Row = mysql_fetch_array($rsFamCustomFields)) { extract($Row); if ($aSecurityType[$fam_custom_FieldSec] == 'bAll' or $_SESSION[$aSecurityType[$fam_custom_FieldSec]]) { $currentData = trim($aFamCustomData[$fam_custom_Field]); if ($type_ID == 11) { $fam_custom_Special = $sPhoneCountry; } echo "<li><i class=\"fa-li glyphicon glyphicon-tag\"></i>" . $fam_custom_Name . ": <span>" . displayCustomField($type_ID, $currentData, $fam_custom_Special) . "</span></li>"; } } ?> </ul> </div> </div> </div> <div class="col-lg-9 col-md-8 col-sm-8"> <div class="row"> <div class="col-lg-12 col-md-8 col-sm-8"> <div class="box box-solid"> <div class="box-body clearfix"> <table width="100%"> <tr> <td width="50%">
} } if ($bUsedCustomFields && $sFormat == "rollup") { $sSQLFamCustom = "SELECT * FROM family_custom WHERE fam_ID = " . $per_fam_ID; $rsFamCustomData = RunQuery($sSQLFamCustom); $aFamCustomData = mysql_fetch_array($rsFamCustomData); if (@mysql_num_rows($rsFamCustomData) > 0) { // Write custom field data mysql_data_seek($rsFamCustomFields, 0); while ($aFamCustomField = mysql_fetch_array($rsFamCustomFields)) { $fam_custom_Field = ""; $fam_custom_Special = ""; $type_ID = ""; extract($aFamCustomField); if (isset($_POST["{$fam_custom_Field}"])) { if ($type_ID == 11) { $fam_custom_Special = $sCountry; } $sString .= "\",\"" . displayCustomField($type_ID, trim($aFamCustomData[$fam_custom_Field]), $fam_custom_Special); } } } } $sString .= "\"\n"; echo $sString; } } } } // Turn OFF output buffering ob_end_flush();
// Get the special properties for this group $sSQL = "SELECT groupprop_master.* FROM groupprop_master WHERE grp_ID = " . $grp_ID . " AND prop_PersonDisplay = 'true' ORDER BY prop_ID"; $rsPropList = RunQuery($sSQL); $sSQL = "SELECT * FROM groupprop_" . $grp_ID . " WHERE per_ID = " . $iPersonID; $rsPersonProps = RunQuery($sSQL); $aPersonProps = mysql_fetch_array($rsPersonProps, MYSQL_BOTH); echo "<div class=\"box-body\">"; while ($aProps = mysql_fetch_array($rsPropList)) { extract($aProps); $currentData = trim($aPersonProps[$prop_Field]); if (strlen($currentData) > 0) { $sRowClass = AlternateRowStyle($sRowClass); if ($type_ID == 11) { $prop_Special = $sPhoneCountry; } echo "<strong>" . $prop_Name . "</strong>: " . displayCustomField($type_ID, $currentData, $prop_Special) . "<br/>"; } } echo "</div><!-- /.box-body -->"; } ?> <div class="box-footer"> <code> <?php if ($_SESSION['bManageGroups']) { ?> <a href="GroupView.php?GroupID=<?php echo $grp_ID; ?> " class="btn btn-default" role="button"><i class="glyphicon glyphicon-list"></i></a> <div class="btn-group">