modCheck('admin/GoTool/cat.inc')); $display_block=''; function format_phone($telephone) { $phone = preg_replace("/[^0-9]/", "", $telephone); if(strlen($telephone) == 7) return preg_replace("/([0-9]{3})([0-9]{4})/", "$1-$2", $telephone); elseif(strlen($telephone) == 10) return preg_replace("/([0-9]{3})([0-9]{3})([0-9]{4})/", "($1) $2-$3", $telephone); else return $telephone; } $tok=$_GET['token']; if (isset($this->request->get['button'])) { $this->data['phone5a'] = $this->request->get['button']; } else { $this->data['phone5a'] = 'no entry'; } $phone5 =$this->data['phone5a']; $phone = ereg_replace("[^A-Za-z0-9]", "", $phone5 ); $phone = str_replace(' ', '', $phone); $phone2=substr($phone,0,-4); $blank=""; $sql33 ="SELECT * FROM $table_name36 WHERE telephone LIKE '$phone' or telephone LIKE '$phone2%' "; $result33 = @mysql_query($sql33,$connection) or die(mysql_error()); $num33 = mysql_num_rows($result33); if ($num33 >0 ) { $BHe="The Following Customers Were Located for $phone or $phone2:"; }Else{ $BHe="No Records Were Located. "; } $result33 = @mysql_query($sql33,$connection) or die(mysql_error()); $num33 = mysql_num_rows($result33); $result222 = @mysql_query($sql33,$connection) or die(mysql_error()); while ($row1 = mysql_fetch_array($result222)) { $first = stripslashes($row1['firstname']); $last =stripslashes($row1['lastname']); $id2= $row1['customer_id']; $login2 =$row1['store_id']; $address_id =$row1['address_id']; // $company= $row1['company']; $email= $row1['email']; $telephone= $row1['telephone']; $telephone= format_phone($telephone) ; $fax= $row1['fax']; $fax= format_phone($fax) ; $sql34 ="SELECT * FROM $table_name40 WHERE address_id = '$address_id' "; $result224 = @mysql_query($sql34,$connection) or die(mysql_error()); $row14 =mysql_fetch_array($result224,MYSQL_ASSOC); if ($address_id == $row14['address_id']) { $company= $row14['company']; $address_1 =$row14['address_1']; $address_2 =$row14['address_2']; $city =$row14['city']; $postcode =$row14['postcode']; $country_id =$row14['country_id']; $zone_id =$row14['zone_id']; } $sql35 ="SELECT * FROM $table_name45 WHERE country_id = '$country_id' "; $result225 = @mysql_query($sql35,$connection) or die(mysql_error()); $row15 =mysql_fetch_array($result225,MYSQL_ASSOC); if ($country_id == $row15['country_id']) { $country= $row15['name']; } $sql36 ="SELECT * FROM $table_name46 WHERE country_id = '$country_id' AND zone_id = '$zone_id' "; $result226 = @mysql_query($sql36,$connection) or die(mysql_error()); $row16 =mysql_fetch_array($result226,MYSQL_ASSOC); if (($zone_id == $row16['zone_id']) || ($country_id==$row16['country_id'])) { $zone= $row16['name']; } $display_block .= "
Customer Id First Name Last Name Telephone Fax Email Address View Orders View Folder
$id2 $first $last $telephone $fax $email $company
$address_1
$city, $zone, $country
$postcode
 


"; } $hi3="This can have buttons, sub menus, etc."; // $this->config->get('user_id'); //$this->customer->getCustomerGroupId(); // $text_account2 = sprintf($this->customer->getCustomerGroupId()); //$this->customer->getId(); //$text_account2 = sprintf($this->customer->getId()); $this->user->getId(); $hi2 = sprintf($this->user->getId()); $this->load->model('user/user'); $user_group_id = $this->model_user_user->getUser($this->user->getId()); $user_gid = $user_group_id['user_group_id']; $hi1=$user_gid; $hi="$hi3
User ID: $hi2
Group:$hi1
User Info: $phone5
Records: $BHe

$display_block

"; ?>


Note: This view can be customized.


[ ]