services/ProviderService.php

   1 <?php
   2 /**
   3  * ProviderService
   4  *
   5  * @package   OpenEMR
   6  * @link      http://www.open-emr.org
   7  * @author    Matthew Vita <matthewvita48@gmail.com>
   8  * @copyright Copyright (c) 2018 Matthew Vita <matthewvita48@gmail.com>
   9  * @license   https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  10  */
  11
  12
  13 namespace OpenEMR\Services;
  14
  15 class ProviderService
  16 {
  17
  18   /**
  19    * Default constructor.
  20    */
  21     public function __construct()
  22     {
  23     }
  24
  25     public function getAll()
  26     {
  27         $sql = "SELECT id,
  28                        fname,
  29                        lname,
  30                        mname,
  31                        username
  32                 FROM  users
  33                 WHERE authorized = 1 AND active = 1";
  34
  35         $statementResults = sqlStatement($sql);
  36
  37         $results = array();
  38         while ($row = sqlFetchArray($statementResults)) {
  39             array_push($results, $row);
  40         }
  41
  42         return $results;
  43     }
  44
  45     public function getById($id)
  46     {
  47         $sql = "SELECT id,
  48                        fname,
  49                        lname,
  50                        mname,
  51                        username
  52                 FROM  users
  53                 WHERE authorized = 1 AND active = 1 AND id = ?";
  54
  55         return sqlQuery($sql, $id);
  56     }
  57 }