Formating the Phone Number Field

[dhavey]

Hello again everyone,

Is there a way to format all the telephone number fields (accounts and contacts) so that they all display the number the same way? i.e. by just typing or pasting 10 digits it will always show as xxx.xxx.xxxx this way we don't have (xxx) xxx-xxxx or xxx-xxx-xxxx or 1-xxx-xxx-xxxx.

Thanks for any help you can give.

[bickart68]

With a combination of logic hooks and utility functions this can be done.

The first file is custom/include/utils.php

<?php
/*
Copyright 2009 Jeff Bickart
jeff.bickart@gmail.com
*/
/**
* Take an existing phone number in any format and strip off any or all of the extra
* characters and then format for either lookup (type == 0) or outbound dial (type==1)
*
* @param String $phone
* @param int $type
* @return String phone number
*/
function getPhoneNumber($phone, $type = 0) {

//remove all of the extra characters from the phone number
//leave an x for the extension
# $phone = ereg_replace("[ ()-.a-wy-z]", "", $phone);
$phone = ereg_replace("[ !-/:-wy-~]", "", $phone);

//determine if they have an extension
$index = strpos($phone, 'x');

//if the phone number has an extesion
if ($index > 0) {
//strip off the extension
if ($type == 0) {
$phone = substr($phone, 0, $index);
} else {
//replace the extension with commas
$phone = ereg_replace("[x]", ",,", $phone);
}
}

$length = strlen($phone);
if ($type == 0) {
//strip off the leading one
if (($length > 10) && (substr($phone, 0, 1) == 1)) {
$phone = substr($phone, 1);
}
}

return $phone;
}


function getFormattedPhoneNumber(&$phone) {

if (! isset($phone))
return;

$ret = "";
$phone = getPhoneNumber($phone);
switch (strlen($phone)) {
case 7 :
$ret = substr($phone, 0, 3)."-".substr($phone, 3);
break;
case 8 :
$ret = substr($phone, 0, 4)."-".substr($phone, 4);
break;
case 10 :
$ret = "(".substr($phone, 0, 3).") ".substr($phone, 3, 3)."-".substr($phone, 6, 4);
break;
default :
$ret = $phone;
}

$phone = $ret;
return $ret;
}
?>


Then add a logic_hook for each of the modules Accounts, Contacts, Leads.
This is an example accounts logic_hook
logic_hook.php

<?php
// Do not store anything in this file that is not part of the array or the hook version. This file will
// be automatically rebuilt in the future.

// array(hook execute order, 'hook name', 'hook code location', 'hook code class name', 'hook code function to execute')

$hook_version = 1;
$hook_array = Array();
// position, file, function

$hook_array['before_save'] = array();
$hook_array['before_save'][] = array(1, 'phone number formatting', 'custom/modules/Accounts/AccountFormatter.php', 'AccountFormatter', 'setPhoneNumbers');
?>

AccountFormatter.php
<?php
/*
* Created on Jan 29, 2009
*
* Copyright 2009 - Jeff Bickart
* jeff.bickart@gmail.com
*/
class AccountFormatter {

function setPhoneNumbers(& $bean, $event, $arguments) {
require_once('custom/include/utils.php');

getFormattedPhoneNumber($bean->phone_fax);
getFormattedPhoneNumber($bean->phone_office);
getFormattedPhoneNumber($bean->phone_alternate);
}
}
?>

[ptemplin7]

I have a set of script that does this slightly different and can also work.

Interested in the files?

Paris