src/Services/PhoneNumberService.php

   1 <?php
   2
   3 /**
   4  * PhoneService
   5  *
   6  * @package   OpenEMR
   7  * @link      https://www.open-emr.org
   8  * @author    Stephen Waite <stephen.waite@cmsvt.com>
   9  * @author    Stephen Nielson <snielson@discoverandchange.com>
  10  * @copyright Copyright (c) 2023 Stephen Waite <stephen.waite@cmsvt.com>
  11  * @copyright Copyright (c) 2024 Care Management Solutions, Inc. <stephen.waite@cmsvt.com>
  12  * @license   https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  13  */
  14
  15 namespace OpenEMR\Services;
  16
  17 use OpenEMR\Common\Database\QueryUtils;
  18 use Particle\Validator\Validator;
  19
  20 class PhoneNumberService extends BaseService
  21 {
  22     public const COUNTRY_CODE = "+1";
  23     public string $area_code;
  24     public string $prefix;
  25     public string $number;
  26     public int    $type;
  27     private int   $foreignId;
  28
  29     public function __construct()
  30     {
  31         $this->area_code = $area_code ?? '';
  32         $this->prefix = $prefix ?? '';
  33         $this->number = $number ?? '';
  34         $this->type = $type ?? 2;
  35         $this->foreignId = $foreignId ?? 0;
  36     }
  37
  38     public function validate($phoneNumber)
  39     {
  40         $validator = new Validator();
  41
  42         $validator->optional('country_code')->lengthBetween(1, 5);
  43         $validator->optional('area_code')->lengthBetween(1, 3);
  44         $validator->optional('prefix')->lengthBetween(1, 3);
  45         $validator->optional('number')->lengthBetween(1, 4);
  46         $validator->optional('type')->lengthBetween(1, 11);
  47         $validator->optional('foreign_id')->lengthBetween(1, 11);
  48
  49         return $validator->validate($phoneNumber);
  50     }
  51
  52     public function insert($data, $foreignId)
  53     {
  54         $freshId = $this->getFreshId("id", "phone_numbers");
  55         $this->foreignId = $foreignId;
  56
  57         $this->getPhoneParts($data['phone']);
  58
  59         $phoneNumbersSql  = " INSERT INTO phone_numbers SET";
  60         $phoneNumbersSql .= "     id=?,";
  61         $phoneNumbersSql .= "     country_code=?,";
  62         $phoneNumbersSql .= "     area_code=?,";
  63         $phoneNumbersSql .= "     prefix=?,";
  64         $phoneNumbersSql .= "     number=?,";
  65         $phoneNumbersSql .= "     type=?,";
  66         $phoneNumbersSql .= "     foreign_id=?";
  67
  68         $phoneNumbersSqlResults = QueryUtils::sqlInsert(
  69             $phoneNumbersSql,
  70             array(
  71                 $freshId,
  72                 self::COUNTRY_CODE,
  73                 $this->area_code,
  74                 $this->prefix,
  75                 $this->number,
  76                 $this->type,
  77                 $this->foreignId
  78             )
  79         );
  80
  81         if (!$phoneNumbersSqlResults) {
  82             return false;
  83         }
  84
  85         return $freshId;
  86     }
  87
  88     public function update($data, $foreignId)
  89     {
  90         $this->foreignId = $foreignId;
  91         $this->getPhoneParts($data['phone']);
  92
  93         $phoneNumbersSql  = " UPDATE phone_numbers SET";
  94         $phoneNumbersSql .= "     country_code=?,";
  95         $phoneNumbersSql .= "     area_code=?,";
  96         $phoneNumbersSql .= "     prefix=?,";
  97         $phoneNumbersSql .= "     number=? ";
  98         $phoneNumbersSql .= "     WHERE foreign_id=? AND type=?";
  99
 100         $phoneNumbersSqlResults = sqlStatement(
 101             $phoneNumbersSql,
 102             array(
 103                 self::COUNTRY_CODE,
 104                 $this->area_code ,
 105                 $this->prefix,
 106                 $this->number,
 107                 $this->foreignId,
 108                 $this->type
 109             )
 110         );
 111
 112         if (!$phoneNumbersSqlResults) {
 113             return false;
 114         }
 115
 116         $phoneNumbersIdSqlResults = sqlQuery("SELECT id FROM phone_numbers WHERE foreign_id=?", $this->foreignId);
 117
 118         if (empty($phoneNumbersIdSqlResults)) {
 119             $this->insert($data, $foreignId);
 120         }
 121         return $phoneNumbersIdSqlResults["id"] ?? null;
 122     }
 123
 124     public function getPhoneParts(string $phone_number)
 125     {
 126         $phone_parts = array();
 127         preg_match(
 128             "/(\d\d\d)\D*(\d\d\d)\D*(\d\d\d\d)/",
 129             $phone_number,
 130             $phone_parts
 131         );
 132
 133         $this->area_code = $phone_parts[1] ?? '';
 134         $this->prefix = $phone_parts[2] ?? '';
 135         $this->number = $phone_parts[3] ?? '';
 136     }
 137
 138     public function getOneByForeignId($foreignId)
 139     {
 140         $sql = "SELECT * FROM phone_numbers WHERE foreign_id=?";
 141         return sqlQuery($sql, array($foreignId));
 142     }
 143 }