services/InsuranceCompanyService.php

   1 <?php
   2 /**
   3  * InsuranceCompanyService
   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 use OpenEMR\Services\AddressService;
  19
  20 class InsuranceCompanyService
  21 {
  22     private $addressService = null;
  23
  24     public function __construct()
  25     {
  26         $this->addressService = new AddressService();
  27     }
  28
  29     public function validate($insuranceCompany)
  30     {
  31         $validator = new Validator();
  32
  33         $validator->required('name')->lengthBetween(2, 255);
  34         $validator->optional('attn')->lengthBetween(2, 255);
  35         $validator->optional('cms_id')->lengthBetween(2, 15);
  36         $validator->optional('alt_cms_id')->lengthBetween(2, 15);
  37         $validator->optional('ins_type_code')->numeric();
  38         $validator->optional('x12_receiver_id')->lengthBetween(2, 25);
  39         $validator->optional('x12_default_partner_id')->numeric();
  40
  41         return $validator->validate($insuranceCompany);
  42     }
  43
  44     public function getAll()
  45     {
  46         $sql  = " SELECT i.id,";
  47         $sql .= "        i.name,";
  48         $sql .= "        i.attn,";
  49         $sql .= "        i.cms_id,";
  50         $sql .= "        i.ins_type_code,";
  51         $sql .= "        i.x12_receiver_id,";
  52         $sql .= "        i.x12_default_partner_id,";
  53         $sql .= "        i.alt_cms_id,";
  54         $sql .= "        i.inactive,";
  55         $sql .= "        a.line1,";
  56         $sql .= "        a.line2,";
  57         $sql .= "        a.city,";
  58         $sql .= "        a.state,";
  59         $sql .= "        a.zip,";
  60         $sql .= "        a.country";
  61         $sql .= " FROM insurance_companies i";
  62         $sql .= " JOIN addresses a ON i.id = a.foreign_id";
  63
  64         $statementResults = sqlStatement($sql);
  65
  66         $results = array();
  67         while ($row = sqlFetchArray($statementResults)) {
  68             array_push($results, $row);
  69         }
  70
  71         return $results;
  72     }
  73
  74     public function getInsuranceTypes()
  75     {
  76         return array(
  77             1 => xl('Other HCFA'),
  78             2 => xl('Medicare Part B'),
  79             3 => xl('Medicaid'),
  80             4 => xl('ChampUSVA'),
  81             5 => xl('ChampUS'),
  82             6 => xl('Blue Cross Blue Shield'),
  83             7 => xl('FECA'),
  84             8 => xl('Self Pay'),
  85             9 => xl('Central Certification'),
  86             10 => xl('Other Non-Federal Programs'),
  87             11 => xl('Preferred Provider Organization (PPO)'),
  88             12 => xl('Point of Service (POS)'),
  89             13 => xl('Exclusive Provider Organization (EPO)'),
  90             14 => xl('Indemnity Insurance'),
  91             15 => xl('Health Maintenance Organization (HMO) Medicare Risk'),
  92             16 => xl('Automobile Medical'),
  93             17 => xl('Commercial Insurance Co.'),
  94             18 => xl('Disability'),
  95             19 => xl('Health Maintenance Organization'),
  96             20 => xl('Liability'),
  97             21 => xl('Liability Medical'),
  98             22 => xl('Other Federal Program'),
  99             23 => xl('Title V'),
 100             24 => xl('Veterans Administration Plan'),
 101             25 => xl('Workers Compensation Health Plan'),
 102             26 => xl('Mutually Defined')
 103         );
 104     }
 105
 106     public function getFreshId()
 107     {
 108         $id = sqlQuery("SELECT MAX(id)+1 AS id FROM insurance_companies");
 109
 110         return $id['id'];
 111     }
 112
 113     public function insert($data)
 114     {
 115         $freshId = $this->getFreshId();
 116
 117         $sql  = " INSERT INTO insurance_companies SET";
 118         $sql .= "     id=?,";
 119         $sql .= "     name=?,";
 120         $sql .= "     attn=?,";
 121         $sql .= "     cms_id=?,";
 122         $sql .= "     ins_type_code=?,";
 123         $sql .= "     x12_receiver_id=?,";
 124         $sql .= "     x12_default_partner_id=?,";
 125         $sql .= "     alt_cms_id=?";
 126
 127         $insuranceResults = sqlInsert(
 128             $sql,
 129             array(
 130                 $freshId,
 131                 $data["name"],
 132                 $data["attn"],
 133                 $data["cms_id"],
 134                 $data["ins_type_code"],
 135                 $data["x12_receiver_id"],
 136                 $data["x12_default_partner_id"],
 137                 $data["alt_cms_id"]
 138             )
 139         );
 140
 141         if (!$insuranceResults) {
 142             return false;
 143         }
 144
 145         $addressesResults = $this->addressService->insert($data, $freshId);
 146
 147         if (!$addressesResults) {
 148             return false;
 149         }
 150
 151         return $freshId;
 152     }
 153
 154     public function update($data, $iid)
 155     {
 156         $sql  = " UPDATE insurance_companies SET";
 157         $sql .= "     name=?,";
 158         $sql .= "     attn=?,";
 159         $sql .= "     cms_id=?,";
 160         $sql .= "     ins_type_code=?,";
 161         $sql .= "     x12_receiver_id=?,";
 162         $sql .= "     x12_default_partner_id=?,";
 163         $sql .= "     alt_cms_id=?";
 164         $sql .= "     WHERE id = ?";
 165
 166         $insuranceResults = sqlStatement(
 167             $sql,
 168             array(
 169                 $data["name"],
 170                 $data["attn"],
 171                 $data["cms_id"],
 172                 $data["ins_type_code"],
 173                 $data["x12_receiver_id"],
 174                 $data["x12_default_partner_id"],
 175                 $data["alt_cms_id"],
 176                 $iid
 177             )
 178         );
 179
 180         if (!$insuranceResults) {
 181             return false;
 182         }
 183
 184         $addressesResults = $this->addressService->update($data, $iid);
 185
 186         if (!$addressesResults) {
 187             return false;
 188         }
 189
 190         return $iid;
 191     }
 192 }