PHP ExpandPhoneNumber函数代码示例

         $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>'; */
        ?>
&nbsp;</td>
         </tr>
<?php 
    }
} else {
    ?>
       <caption>

//.........这里部分代码省略.........
            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 . "&nbsp;" . $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);
            ?>
&nbsp;</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';