services/AddressService.php

   1 <?php
   2 /**
   3  * AddressService
   4  *
   5  * @package   OpenEMR
   6  * @link      http://www.open-emr.org
   7  * @author    Matthew Vita <matthewvita48@gmail.com>
   8  * @author    Brady Miller <brady.g.miller@gmail.com>
   9  * @copyright Copyright (c) 2018 Matthew Vita <matthewvita48@gmail.com>
  10  * @copyright Copyright (c) 2018 Brady Miller <brady.g.miller@gmail.com>
  11  * @license   https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  12  */
  13
  14
  15 namespace OpenEMR\Services;
  16
  17 use Particle\Validator\Validator;
  18
  19 class AddressService
  20 {
  21     public function __construct()
  22     {
  23     }
  24
  25     public function validate($insuranceCompany)
  26     {
  27         $validator = new Validator();
  28
  29         $validator->optional('line1')->lengthBetween(2, 255);
  30         $validator->optional('line2')->lengthBetween(2, 255);
  31         $validator->optional('city')->lengthBetween(2, 255);
  32         $validator->optional('state')->lengthBetween(2, 35);
  33         $validator->optional('zip')->lengthBetween(2, 10);
  34         $validator->optional('country')->lengthBetween(2, 255);
  35
  36         return $validator->validate($insuranceCompany);
  37     }
  38
  39
  40     public function getFreshId()
  41     {
  42         $id = sqlQuery("SELECT MAX(id)+1 AS id FROM addresses");
  43
  44         return $id['id'];
  45     }
  46
  47     public function insert($data, $foreignId)
  48     {
  49         $freshId = $this->getFreshId();
  50
  51         $addressesSql  = " INSERT INTO addresses SET";
  52         $addressesSql .= "     id=?,";
  53         $addressesSql .= "     line1=?,";
  54         $addressesSql .= "     line2=?,";
  55         $addressesSql .= "     city=?,";
  56         $addressesSql .= "     state=?,";
  57         $addressesSql .= "     zip=?,";
  58         $addressesSql .= "     country=?,";
  59         $addressesSql .= "     foreign_id=?";
  60
  61         $addressesSqlResults = sqlInsert(
  62             $addressesSql,
  63             array(
  64                 $freshId,
  65                 $data["line1"],
  66                 $data["line2"],
  67                 $data["city"],
  68                 $data["state"],
  69                 $data["zip"],
  70                 $data["country"],
  71                 $foreignId
  72             )
  73         );
  74
  75         if (!$addressesSqlResults) {
  76             return false;
  77         }
  78
  79         return $freshId;
  80     }
  81
  82     public function update($data, $foreignId)
  83     {
  84         $addressesSql  = " UPDATE addresses SET";
  85         $addressesSql .= "     line1=?,";
  86         $addressesSql .= "     line2=?,";
  87         $addressesSql .= "     city=?,";
  88         $addressesSql .= "     state=?,";
  89         $addressesSql .= "     zip=?,";
  90         $addressesSql .= "     country=?";
  91         $addressesSql .= "     WHERE foreign_id=?";
  92
  93         $addressesSqlResults = sqlStatement(
  94             $addressesSql,
  95             array(
  96                 $data["line1"],
  97                 $data["line2"],
  98                 $data["city"],
  99                 $data["state"],
 100                 $data["zip"],
 101                 $data["country"],
 102                 $foreignId
 103             )
 104         );
 105
 106         if (!$addressesSqlResults) {
 107             return false;
 108         }
 109
 110         $addressIdSqlResults = sqlQuery("SELECT id FROM addresses WHERE foreign_id=?", $foreignId);
 111
 112         return $addressIdSqlResults["id"];
 113     }
 114 }