library/freeb/Insured.class.php

   1 <?php
   2 require_once("DataObjectBase.class.php");
   3 require_once("xmlrpc.inc");
   4
   5 class Insured Extends DataObjectBase {
   6
   7         function Insured() {
   8                 $this->_addFunc("firstname",                    array(  "name"  =>      "FreeB.FBInsured.FirstName",
   9                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  10                                                                                                                         "doc"   =>      ""));
  11                 $this->_addFunc("middlename",                   array(  "name"  =>      "FreeB.FBInsured.MiddleName",
  12                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  13                                                                                                                         "doc"   =>      ""));
  14                 $this->_addFunc("lastname",                             array(  "name"  =>      "FreeB.FBInsured.LastName",
  15                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  16                                                                                                                         "doc"   =>      ""));
  17                 $this->_addFunc("id",                                   array(  "name"  =>      "FreeB.FBInsured.ID",
  18                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  19                                                                                                                         "doc"   =>      ""));
  20                 $this->_addFunc("dateofbirth",                  array(  "name"  =>      "FreeB.FBInsured.DateOfBirth",
  21                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  22                                                                                                                         "doc"   =>      ""));
  23                 $this->_addFunc("sex",                                  array(  "name"  =>      "FreeB.FBInsured.Sex",
  24                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  25                                                                                                                         "doc"   =>      ""));
  26                 $this->_addFunc("groupname",                    array(  "name"  =>      "FreeB.FBInsured.GroupName",
  27                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  28                                                                                                                         "doc"   =>      ""));
  29                 $this->_addFunc("groupnumber",                  array(  "name"  =>      "FreeB.FBInsured.GroupNumber",
  30                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  31                                                                                                                         "doc"   =>      ""));
  32                 $this->_addFunc("isemployed",                   array(  "name"  =>      "FreeB.FBInsured.isEmployed",
  33                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  34                                                                                                                         "doc"   =>      ""));
  35                 $this->_addFunc("employername",                 array(  "name"  =>      "FreeB.FBInsured.EmployerName",
  36                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  37                                                                                                                         "doc"   =>      ""));
  38                 $this->_addFunc("isstudent",                    array(  "name"  =>      "FreeB.FBInsured.isStudent",
  39                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  40                                                                                                                         "doc"   =>      ""));
  41                 $this->_addFunc("schoolname",                   array(  "name"  =>      "FreeB.FBInsured.SchoolName",
  42                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  43                                                                                                                         "doc"   =>      ""));
  44                 $this->_addFunc("isassigning",                  array(  "name"  =>      "FreeB.FBInsured.isAssigning",
  45                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  46                                                                                                                         "doc"   =>      ""));
  47                 $this->_addFunc("planname",                             array(  "name"  =>      "FreeB.FBInsured.PlanName",
  48                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  49                                                                                                                         "doc"   =>      ""));
  50                 $this->_addFunc("streetaddress",                array(  "name"  =>      "FreeB.FBInsured.StreetAddress",
  51                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  52                                                                                                                         "doc"   =>      ""));
  53                 $this->_addFunc("city",                                 array(  "name"  =>      "FreeB.FBInsured.City",
  54                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  55                                                                                                                         "doc"   =>      ""));
  56                 $this->_addFunc("state",                                array(  "name"  =>      "FreeB.FBInsured.State",
  57                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  58                                                                                                                         "doc"   =>      ""));
  59                 $this->_addFunc("zipcode",                              array(  "name"  =>      "FreeB.FBInsured.Zipcode",
  60                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  61                                                                                                                         "doc"   =>      ""));
  62                 $this->_addFunc("phonecountry",                 array(  "name"  =>      "FreeB.FBInsured.PhoneCountry",
  63                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  64                                                                                                                         "doc"   =>      ""));
  65                 $this->_addFunc("phoneextension",               array(  "name"  =>      "FreeB.FBInsured.PhoneExtension",
  66                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  67                                                                                                                         "doc"   =>      ""));
  68                 $this->_addFunc("phonearea",                    array(  "name"  =>      "FreeB.FBInsured.PhoneArea",
  69                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  70                                                                                                                         "doc"   =>      ""));
  71                 $this->_addFunc("phonenumber",                  array(  "name"  =>      "FreeB.FBInsured.PhoneNumber",
  72                                                                                                                         "sig"   =>      array(XMLRPCSTRING,XMLRPCINT),
  73                                                                                                                         "doc"   =>      ""));
  74         }
  75
  76         function firstname($m) {
  77
  78                 $err="";
  79
  80                 $retval = "";
  81                 $obj= $m->getparam(0);
  82                 $key = $obj->getval();
  83
  84                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
  85                 //echo $sql;
  86                 $db = $GLOBALS['adodb']['db'];
  87                 $results = $db->Execute($sql);
  88
  89                 if (!$results) {
  90                         $err = $db->ErrorMsg();
  91                 }
  92                 else {
  93                         if (!$results->EOF) {
  94                                 $retval  =      $results->fields['subscriber_fname'];
  95                         }
  96                 }
  97
  98                 // if we generated an error, create an error return response
  99                 if ($err) {
 100                         return $this->_handleError($err);
 101                 }
 102                 else {
 103                         // otherwise, we create the right response
 104                         // with the state name
 105                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 106                 }
 107         }
 108
 109         function middlename($m) {
 110
 111                 $err="";
 112
 113                 $retval = "";
 114                 $obj= $m->getparam(0);
 115                 $key = $obj->getval();
 116
 117                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 118                 //echo $sql;
 119                 $db = $GLOBALS['adodb']['db'];
 120                 $results = $db->Execute($sql);
 121
 122                 if (!$results) {
 123                         $err = $db->ErrorMsg();
 124                 }
 125                 else {
 126                         if (!$results->EOF) {
 127                                 $retval  =      $results->fields['subscriber_mname'];
 128                         }
 129                 }
 130
 131                 // if we generated an error, create an error return response
 132                 if ($err) {
 133                         return $this->_handleError($err);
 134                 }
 135                 else {
 136                         // otherwise, we create the right response
 137                         // with the state name
 138                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 139                 }
 140         }
 141
 142         function lastname($m) {
 143
 144                 $err="";
 145
 146                 $retval = "";
 147                 $obj= $m->getparam(0);
 148                 $key = $obj->getval();
 149
 150                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 151                 //echo $sql;
 152                 $db = $GLOBALS['adodb']['db'];
 153                 $results = $db->Execute($sql);
 154
 155                 if (!$results) {
 156                         $err = $db->ErrorMsg();
 157                 }
 158                 else {
 159                         if (!$results->EOF) {
 160                                 $retval  =      $results->fields['subscriber_lname'];
 161                         }
 162                 }
 163
 164                 // if we generated an error, create an error return response
 165                 if ($err) {
 166                         return $this->_handleError($err);
 167                 }
 168                 else {
 169                         // otherwise, we create the right response
 170                         // with the state name
 171                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 172                 }
 173         }
 174
 175         function id($m) {
 176
 177                 $err="";
 178
 179                 $retval = "";
 180                 $obj= $m->getparam(0);
 181                 $key = $obj->getval();
 182
 183                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 184                 //echo $sql;
 185                 $db = $GLOBALS['adodb']['db'];
 186                 $results = $db->Execute($sql);
 187
 188                 if (!$results) {
 189                         $err = $db->ErrorMsg();
 190                 }
 191                 else {
 192                         if (!$results->EOF) {
 193                                 $retval  =      $results->fields['policy_number'];
 194                         }
 195                 }
 196                 // if we generated an error, create an error return response
 197                 if ($err) {
 198                         return $this->_handleError($err);
 199                 }
 200                 else {
 201                         // otherwise, we create the right response
 202                         // with the state name
 203                         return new xmlrpcresp(new xmlrpcval($retval));
 204                 }
 205         }
 206
 207         function dateofbirth($m) {
 208
 209                 $err="";
 210
 211                 $retval = "";
 212                 $obj= $m->getparam(0);
 213                 $key = $obj->getval();
 214
 215                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 216                 //echo $sql;
 217                 $db = $GLOBALS['adodb']['db'];
 218                 $results = $db->Execute($sql);
 219
 220                 if (!$results) {
 221                         $err = $db->ErrorMsg();
 222                 }
 223                 else {
 224                         if (!$results->EOF) {
 225                                 $retval  =      $results->fields['subscriber_DOB'];
 226                         }
 227                 }
 228                 if (!empty($retval)) {
 229                         $retval = $this->_isodate($retval);
 230                 }
 231                 else {
 232                         $retval = "";
 233                 }
 234
 235                 // if we generated an error, create an error return response
 236                 if ($err) {
 237                         return $this->_handleError($err);
 238                 }
 239                 else {
 240                         // otherwise, we create the right response
 241                         // with the state name
 242                         return new xmlrpcresp(new xmlrpcval($retval,XMLRPCDATETIME));
 243                 }
 244         }
 245
 246         function sex($m) {
 247
 248                 $err="";
 249
 250                 $retval = "";
 251                 $obj= $m->getparam(0);
 252                 $key = $obj->getval();
 253
 254                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 255                 //echo $sql;
 256                 $db = $GLOBALS['adodb']['db'];
 257                 $results = $db->Execute($sql);
 258
 259                 if (!$results) {
 260                         $err = $db->ErrorMsg();
 261                 }
 262                 else {
 263                         if (!$results->EOF) {
 264                                 $retval  =      $results->fields['subscriber_sex'];
 265                         }
 266                 }
 267                 if (strtolower($retval) == "male") {
 268                         $retval = "M";
 269                 }
 270                 elseif (strtolower($retval) == "female") {
 271                         $retval = "F";
 272                 }
 273
 274                 // if we generated an error, create an error return response
 275                 if ($err) {
 276                         return $this->_handleError($err);
 277                 }
 278                 else {
 279                         // otherwise, we create the right response
 280                         // with the state name
 281                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 282                 }
 283         }
 284
 285
 286
 287         function groupname($m) {
 288
 289                 $err="";
 290
 291                 $retval = "";
 292                 $obj= $m->getparam(0);
 293                 $key = $obj->getval();
 294
 295                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 296                 //echo $sql;
 297                 $db = $GLOBALS['adodb']['db'];
 298                 $results = $db->Execute($sql);
 299
 300                 if (!$results) {
 301                         $err = $db->ErrorMsg();
 302                 }
 303                 else {
 304                         if (!$results->EOF) {
 305                                 $retval  =      $results->fields['subscriber_employer'];
 306                         }
 307                 }
 308
 309                 // if we generated an error, create an error return response
 310                 if ($err) {
 311                         return $this->_handleError($err);
 312                 }
 313                 else {
 314                         // otherwise, we create the right response
 315                         // with the state name
 316                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 317                 }
 318         }
 319
 320         function groupnumber($m) {
 321
 322                 $err="";
 323
 324                 $retval = "";
 325                 $obj= $m->getparam(0);
 326                 $key = $obj->getval();
 327
 328                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 329                 //echo $sql;
 330                 $db = $GLOBALS['adodb']['db'];
 331                 $results = $db->Execute($sql);
 332
 333                 if (!$results) {
 334                         $err = $db->ErrorMsg();
 335                 }
 336                 else {
 337                         if (!$results->EOF) {
 338                                 $retval  =      $results->fields['group_number'];
 339                         }
 340                 }
 341
 342                 // if we generated an error, create an error return response
 343                 if ($err) {
 344                         return $this->_handleError($err);
 345                 }
 346                 else {
 347                         // otherwise, we create the right response
 348                         // with the state name
 349                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 350                 }
 351         }
 352         function isemployed($m) {
 353
 354                 $err="";
 355
 356                 $retval = "";
 357                 $obj= $m->getparam(0);
 358                 $key = $obj->getval();
 359
 360                 //default to true
 361                 $pkey = true;
 362
 363                 // if we generated an error, create an error return response
 364                 if ($err) {
 365                         return $this->_handleError($err);
 366                 }
 367                 else {
 368                         // otherwise, we create the right response
 369                         // with the state name
 370                         return new xmlrpcresp(new xmlrpcval($pkey,"i4"));
 371                 }
 372         }
 373
 374         function employername($m) {
 375
 376                 $err="";
 377
 378                 $retval = "";
 379                 $obj= $m->getparam(0);
 380                 $key = $obj->getval();
 381
 382                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 383                 //echo $sql;
 384                 $db = $GLOBALS['adodb']['db'];
 385                 $results = $db->Execute($sql);
 386
 387                 if (!$results) {
 388                         $err = $db->ErrorMsg();
 389                 }
 390                 else {
 391                         if (!$results->EOF) {
 392                                 $retval  =      $results->fields['subscriber_employer'];
 393                         }
 394                 }
 395
 396
 397                 // if we generated an error, create an error return response
 398                 if ($err) {
 399                         return $this->_handleError($err);
 400                 }
 401                 else {
 402                         // otherwise, we create the right response
 403                         // with the state name
 404                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 405                 }
 406         }
 407
 408         function isstudent($m) {
 409
 410                 $err="";
 411                 //unimplemented by OpenEMR
 412                 $pkey = false;
 413
 414                 // if we generated an error, create an error return response
 415                 if ($err) {
 416                         return $this->_handleError($err);
 417                 }
 418                 else {
 419                         // otherwise, we create the right response
 420                         // with the state name
 421                         return new xmlrpcresp(new xmlrpcval($pkey,"i4"));
 422                 }
 423         }
 424
 425         function schoolname($m) {
 426
 427                 $err="";
 428
 429                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 430                 //echo $sql;
 431                 $db = $GLOBALS['adodb']['db'];
 432                 $results = $db->Execute($sql);
 433
 434                 if (!$results) {
 435                         $err = $db->ErrorMsg();
 436                 }
 437                 else {
 438                         if (!$results->EOF) {
 439                                 $retval  =      $results->fields['subscriber_employer'];
 440                         }
 441                 }
 442
 443                 // if we generated an error, create an error return response
 444                 if ($err) {
 445                         return $this->_handleError($err);
 446                 }
 447                 else {
 448                         // otherwise, we create the right response
 449                         // with the state name
 450                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 451                 }
 452         }
 453
 454         function isassigning($m) {
 455
 456                 $err="";
 457
 458                 //defaulted to true
 459                 $pkey = true;
 460
 461                 // if we generated an error, create an error return response
 462                 if ($err) {
 463                         return $this->_handleError($err);
 464                 }
 465                 else {
 466                         // otherwise, we create the right response
 467                         // with the state name
 468                         return new xmlrpcresp(new xmlrpcval($pkey,"i4"));
 469                 }
 470         }
 471
 472         function planname($m) {
 473
 474                 $err="";
 475
 476                 $retval = "";
 477                 $obj= $m->getparam(0);
 478                 $key = $obj->getval();
 479
 480                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 481                 //echo $sql;
 482                 $db = $GLOBALS['adodb']['db'];
 483                 $results = $db->Execute($sql);
 484
 485                 if (!$results) {
 486                         $err = $db->ErrorMsg();
 487                 }
 488                 else {
 489                         if (!$results->EOF) {
 490                                 $retval  =      $results->fields['plan_name'];
 491                         }
 492                 }
 493
 494                 // if we generated an error, create an error return response
 495                 if ($err) {
 496                         return $this->_handleError($err);
 497                 }
 498                 else {
 499                         // otherwise, we create the right response
 500                         // with the state name
 501                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 502                 }
 503         }
 504
 505         function streetaddress($m) {
 506
 507                 $err="";
 508
 509                 $retval = "";
 510                 $obj= $m->getparam(0);
 511                 $key = $obj->getval();
 512
 513                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 514                 //echo $sql;
 515                 $db = $GLOBALS['adodb']['db'];
 516                 $results = $db->Execute($sql);
 517
 518                 if (!$results) {
 519                         $err = $db->ErrorMsg();
 520                 }
 521                 else {
 522                         if (!$results->EOF) {
 523                                 $retval  =      $results->fields['subscriber_street'];
 524                         }
 525                 }
 526
 527                 // if we generated an error, create an error return response
 528                 if ($err) {
 529                         return $this->_handleError($err);
 530                 }
 531                 else {
 532                         // otherwise, we create the right response
 533                         // with the state name
 534                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 535                 }
 536         }
 537
 538
 539         function city($m) {
 540
 541                 $err="";
 542
 543                 $retval = "";
 544                 $obj= $m->getparam(0);
 545                 $key = $obj->getval();
 546
 547                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 548                 //echo $sql;
 549                 $db = $GLOBALS['adodb']['db'];
 550                 $results = $db->Execute($sql);
 551
 552                 if (!$results) {
 553                         $err = $db->ErrorMsg();
 554                 }
 555                 else {
 556                         if (!$results->EOF) {
 557                                 $retval  =      $results->fields['subscriber_city'];
 558                         }
 559                 }
 560
 561                 // if we generated an error, create an error return response
 562                 if ($err) {
 563                         return $this->_handleError($err);
 564                 }
 565                 else {
 566                         // otherwise, we create the right response
 567                         // with the state name
 568                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 569                 }
 570         }
 571         function state($m) {
 572
 573                 $err="";
 574
 575                 $retval = "";
 576                 $obj= $m->getparam(0);
 577                 $key = $obj->getval();
 578
 579                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 580                 //echo $sql;
 581                 $db = $GLOBALS['adodb']['db'];
 582                 $results = $db->Execute($sql);
 583
 584                 if (!$results) {
 585                         $err = $db->ErrorMsg();
 586                 }
 587                 else {
 588                         if (!$results->EOF) {
 589                                 $retval  =      $results->fields['subscriber_state'];
 590                         }
 591                 }
 592
 593                 // if we generated an error, create an error return response
 594                 if ($err) {
 595                         return $this->_handleError($err);
 596                 }
 597                 else {
 598                         // otherwise, we create the right response
 599                         // with the state name
 600                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 601                 }
 602         }
 603         function zipcode($m) {
 604
 605                 $err="";
 606
 607                 $retval = "";
 608                 $obj= $m->getparam(0);
 609                 $key = $obj->getval();
 610
 611                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 612                 //echo $sql;
 613                 $db = $GLOBALS['adodb']['db'];
 614                 $results = $db->Execute($sql);
 615
 616                 if (!$results) {
 617                         $err = $db->ErrorMsg();
 618                 }
 619                 else {
 620                         if (!$results->EOF) {
 621                                 $retval  =      $results->fields['subscriber_postal_code'];
 622                         }
 623                 }
 624                 // if we generated an error, create an error return response
 625                 if ($err) {
 626                         return $this->_handleError($err);
 627                 }
 628                 else {
 629                         // otherwise, we create the right response
 630                         // with the state name
 631                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 632                 }
 633         }
 634         function phonecountry($m) {
 635
 636                 $err="";
 637                 //Unimplemented by OpenEMR
 638                 $retval = "";
 639                 // if we generated an error, create an error return response
 640                 if ($err) {
 641                         return $this->_handleError($err);
 642                 }
 643                 else {
 644                         // otherwise, we create the right response
 645                         // with the state name
 646                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 647                 }
 648         }
 649
 650         function phoneextension($m) {
 651
 652                 $err="";
 653                 //unimplemented by OpenEMR
 654                 $pkey = "";
 655
 656                 // if we generated an error, create an error return response
 657                 if ($err) {
 658                         return $this->_handleError($err);
 659                 }
 660                 else {
 661                         // otherwise, we create the right response
 662                         // with the state name
 663                         return new xmlrpcresp(new xmlrpcval($pkey));
 664                 }
 665         }
 666
 667         function phonearea($m) {
 668
 669                 $err="";
 670
 671                 $retval = "";
 672                 $obj= $m->getparam(0);
 673                 $key = $obj->getval();
 674
 675                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 676                 //echo $sql;
 677                 $db = $GLOBALS['adodb']['db'];
 678                 $results = $db->Execute($sql);
 679
 680                 if (!$results) {
 681                         $err = $db->ErrorMsg();
 682                 }
 683                 else {
 684                         if (!$results->EOF) {
 685                                 $retval  =      $results->fields['subscriber_phone'];
 686                         }
 687                 }
 688                 $phone_parts = array();
 689                 preg_match("/^\((.*?)\)\s(.*?)\-(.*?)$/",$retval,$phone_parts);
 690                 $retval = $phone_parts[1];
 691
 692                 // if we generated an error, create an error return response
 693                 if ($err) {
 694                         return $this->_handleError($err);
 695                 }
 696                 else {
 697                         // otherwise, we create the right response
 698                         // with the state name
 699                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 700                 }
 701         }
 702         function phonenumber($m) {
 703
 704                 $err="";
 705
 706                 $retval = "";
 707                 $obj= $m->getparam(0);
 708                 $key = $obj->getval();
 709
 710                 $sql = "SELECT * FROM insurance_data where id = '" . $key . "'";
 711                 //echo $sql;
 712                 $db = $GLOBALS['adodb']['db'];
 713                 $results = $db->Execute($sql);
 714
 715                 if (!$results) {
 716                         $err = $db->ErrorMsg();
 717                 }
 718                 else {
 719                         if (!$results->EOF) {
 720                                 $retval  =      $results->fields['subscriber_phone'];
 721                         }
 722                 }
 723                 $phone_parts = array();
 724                 preg_match("/^\((.*?)\)\s(.*?)\-(.*?)$/",$retval,$phone_parts);
 725                 $retval = $phone_parts[2] . "-" . $phone_parts[3];
 726
 727                 // if we generated an error, create an error return response
 728                 if ($err) {
 729                         return $this->_handleError($err);
 730                 }
 731                 else {
 732                         // otherwise, we create the right response
 733                         // with the state name
 734                         return new xmlrpcresp(new xmlrpcval($retval,"string"));
 735                 }
 736         }
 737
 738 }
 739
 740 //'FreeB.FBInsured.FirstName'                   => \&FreeB_FBInsured_FirstName,
 741 //'FreeB.FBInsured.LastName'                    => \&FreeB_FBInsured_LastName,
 742 //'FreeB.FBInsured.MiddleName'                  => \&FreeB_FBInsured_MiddleName,
 743 //'FreeB.FBInsured.ID'                          => \&FreeB_FBInsured_ID,
 744
 745 //'FreeB.FBInsured.DateOfBirth'                         => \&FreeB_FBInsured_DateOfBirth,
 746 //'FreeB.FBInsured.Sex'                                 => \&FreeB_FBInsured_Sex,
 747 //'FreeB.FBInsured.GroupName'                   => \&FreeB_FBInsured_GroupName,
 748 //'FreeB.FBInsured.GroupNumber'                         => \&FreeB_FBInsured_GroupNumber,
 749 //'FreeB.FBInsured.isEmployed'                  => \&FreeB_FBInsured_isEmployed,
 750 //'FreeB.FBInsured.EmployerName'                        => \&FreeB_FBInsured_EmployerName,
 751 //'FreeB.FBInsured.isStudent'                   => \&FreeB_FBInsured_isStudent,
 752 //'FreeB.FBInsured.SchoolName'                  => \&FreeB_FBInsured_SchoolName,
 753 //'FreeB.FBInsured.isAssigning'                         => \&FreeB_FBInsured_isAssigning,
 754 //'FreeB.FBInsured.PlanName'                    => \&FreeB_FBInsured_PlanName,
 755
 756 //'FreeB.FBInsured.StreetAddress'               => \&FreeB_FBInsured_StreetAddress,
 757 //'FreeB.FBInsured.City'                                => \&FreeB_FBInsured_City,
 758 //'FreeB.FBInsured.State'                       => \&FreeB_FBInsured_State,
 759 //'FreeB.FBInsured.Zipcode'                     => \&FreeB_FBInsured_Zipcode,
 760 //'FreeB.FBInsured.PhoneCountry'                        => \&FreeB_FBInsured_PhoneCountry,
 761 //'FreeB.FBInsured.PhoneExtension'              => \&FreeB_FBInsured_PhoneExtension,
 762 //'FreeB.FBInsured.PhoneArea'                   => \&FreeB_FBInsured_PhoneArea,
 763 //'FreeB.FBInsured.PhoneNumber'                         => \&FreeB_FBInsured_PhoneNumber,
 764
 765
 766 ?>