interface/modules/zend_modules/module/Application/src/Application/Model/SendtoTable.php

   1 <?php
   2 /* +-----------------------------------------------------------------------------+
   3 *    OpenEMR - Open Source Electronic Medical Record
   4 *    Copyright (C) 2014 Z&H Consultancy Services Private Limited <sam@zhservices.com>
   5 *
   6 *    This program is free software: you can redistribute it and/or modify
   7 *    it under the terms of the GNU Affero General Public License as
   8 *    published by the Free Software Foundation, either version 3 of the
   9 *    License, or (at your option) any later version.
  10 *
  11 *    This program is distributed in the hope that it will be useful,
  12 *    but WITHOUT ANY WARRANTY; without even the implied warranty of
  13 *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  14 *    GNU Affero General Public License for more details.
  15 *
  16 *    You should have received a copy of the GNU Affero General Public License
  17 *    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  18 *    @author  BASIL PT <basil@zhservices.com>
  19 * +------------------------------------------------------------------------------+
  20 */
  21
  22 namespace Application\Model;
  23
  24 use Zend\Db\TableGateway\AbstractTableGateway;
  25 use Application\Model\ApplicationTable;
  26 use Zend\Db\Adapter\Driver\Pdo\Result;
  27
  28 class SendtoTable extends AbstractTableGateway
  29 {
  30     /*
  31     * getFacility
  32     * @return array facility
  33     *
  34     **/
  35     public function getFacility()
  36     {
  37         $appTable   = new ApplicationTable();
  38         $sql        = "SELECT * FROM facility ORDER BY name";
  39         $result     = $appTable->zQuery($sql);
  40         return $result;
  41     }
  42
  43
  44     /*
  45     * getUsers
  46     * @param String $type
  47     * @return array
  48     *
  49     **/
  50     public function getUsers($type)
  51     {
  52         $appTable   = new ApplicationTable();
  53         $sql        = "SELECT * FROM users WHERE abook_type = ?";
  54         $result     = $appTable->zQuery($sql, array($type));
  55         return $result;
  56     }
  57
  58
  59     /*
  60     * getFaxRecievers
  61     * @return array fax reciever types
  62     *
  63     **/
  64     public function getFaxRecievers()
  65     {
  66         $appTable   = new ApplicationTable();
  67         $sql        = "SELECT option_id, title FROM list_options WHERE list_id = 'abook_type'";
  68         $result     = $appTable->zQuery($sql, array($formId));
  69         return $result;
  70     }
  71
  72     /*
  73     * CCDA component list
  74     *
  75     * @param    $type
  76     * @return   $components     Array of CCDA components
  77     **/
  78     public function getCCDAComponents($type)
  79     {
  80         $components = array();
  81         $query      = "select * from ccda_components where ccda_type = ?";
  82         $appTable   = new ApplicationTable();
  83         $result     = $appTable->zQuery($query, array($type));
  84
  85         foreach ($result as $row) {
  86             $components[$row['ccda_components_field']] = $row['ccda_components_name'];
  87         }
  88
  89         return $components;
  90     }
  91 }