interface/modules/zend_modules/module/Documents/src/Documents/Model/DocumentsTable.php

   1 <?php
   2 /* +-----------------------------------------------------------------------------+
   3 *    OpenEMR - Open Source Electronic Medical Record
   4 *    Copyright (C) 2013 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 Documents\Model;
  23
  24 use Zend\Db\TableGateway\AbstractTableGateway;
  25 use Zend\Db\Adapter\Adapter;
  26 use \Application\Model\ApplicationTable;
  27
  28 class DocumentsTable extends AbstractTableGateway
  29 {
  30   /*
  31   * Save the category - document mapping
  32   * @param    $category_id    integer   Category ID
  33   * @param    $document_id    integer   Document ID
  34   */
  35     public function insertDocumentCategory($category_id, $document_id)
  36     {
  37         $obj  = new ApplicationTable();
  38         $sql = "INSERT INTO categories_to_documents (category_id, document_id) VALUES (?, ?)";
  39         $result = $obj->zQuery($sql, array($category_id, $document_id));
  40     }
  41
  42   /*
  43   * Move the document to a different category
  44   * @param    $category_id    integer   Category ID
  45   * @param    $document_id    integer   Document ID
  46   */
  47     public function updateDocumentCategory($category_id, $document_id)
  48     {
  49         $obj  = new ApplicationTable();
  50         $sql = "UPDATE categories_to_documents SET category_id = ? WHERE document_id = ?";
  51         $result = $obj->zQuery($sql, array($category_id, $document_id));
  52     }
  53
  54   /**
  55    * getCategories - Get Document Categories
  56    * @param Integer $categoryParentId
  57    * @return Array
  58    */
  59     public function getCategories($categoryParentId)
  60     {
  61         $obj      = new ApplicationTable();
  62         $sql      = "SELECT * FROM `categories` WHERE `parent` = ? ORDER BY `order`";
  63         $result   = $obj->zQuery($sql, array($categoryParentId));
  64         $category = array();
  65         foreach ($result as $row) {
  66             $category[$row['cat_id']]= array(
  67             'category_id'   => $row['id'],
  68             'category_name' => $row['name'],
  69             );
  70         }
  71
  72         return $category;
  73     }
  74
  75   /**
  76    * getDocument - get Document Data by Id
  77    * @param Integer $documentId Document Id
  78    * @return Array
  79    */
  80     public function getDocument($documentId)
  81     {
  82         $obj    = new ApplicationTable();
  83         $sql    = "SELECT * FROM documents AS doc
  84               JOIN categories_to_documents AS cat_doc ON cat_doc.document_id = doc.id
  85               WHERE doc.id = ?";
  86         $result = $obj->zQuery($sql, array($documentId));
  87         return $result->current();
  88     }
  89
  90   /**
  91    * getCategoryIDs - get Category Ids By Name
  92    * @param Array $categories - Category Lists
  93    * @return Array
  94    */
  95     public function getCategoryIDs($categories = array())
  96     {
  97         $obj              = new ApplicationTable();
  98         $categories_count = count($categories);
  99         $cat_name         = array();
 100         for ($i=0; $i<$categories_count; $i++) {
 101             $cat_name[$i]   = "?";
 102         }
 103
 104         $sql              = "SELECT `id`,`name` FROM `categories` ".
 105                         "WHERE `name` IN (". implode(",", $cat_name) .")";
 106         $result           = $obj->zQuery($sql, $categories);
 107         $category         = array();
 108         foreach ($result as $row) {
 109             $category[$row['name']] = $row['id'];
 110         }
 111
 112         return $category;
 113     }
 114
 115   /**
 116    * saveDocumentdetails - save document details
 117    * @param Array $current_document - document details
 118    */
 119     public function saveDocumentdetails($current_document)
 120     {
 121         $obj = new ApplicationTable();
 122         foreach ($current_document as $values) {
 123             $sql = "UPDATE
 124              `documents`
 125               SET
 126               `docdate` = ?,
 127               `pid` = ?,
 128               `notes` = ?,
 129               `issues` = ?,
 130               `name`  = ?
 131                WHERE `id` = ?";
 132             $result = $obj->zQuery($sql, array($values['doc_docdate'], $values['patientname'], $values['notes'], $values['issue'],$values['docname'],$values['doc_id']));
 133             $this->updateDocumentCategory($values['category'], $values['doc_id']);
 134         }
 135     }
 136
 137   /**
 138    * getCategory - get document categories
 139    * @return Array
 140    */
 141     public function getCategory()
 142     {
 143         $obj = new ApplicationTable();
 144         $sql = "SELECT * FROM `categories`";
 145         $result = $obj->zQuery($sql);
 146         foreach ($result as $values) {
 147             $category[] = $values;
 148         }
 149
 150         return $category;
 151     }
 152
 153    /**
 154    * deleteDocument - remove document from list
 155    * @param Int $docid
 156    */
 157     public function deleteDocument($docid)
 158     {
 159         $obj = new ApplicationTable();
 160         $sql = "UPDATE
 161            `documents`
 162            SET
 163           `activity` = ?
 164           WHERE `id` = ?";
 165         $obj->zQuery($sql, array(0,$docid));
 166     }
 167
 168   /**
 169    *Update document category using category name
 170    *@param $category_name - Name of the category to which the document has to be moved
 171    *@param $document_id - Documents whose category has to be updated with $category_name
 172    */
 173     public function updateDocumentCategoryUsingCatname($category_name, $document_id)
 174     {
 175         $obj  = new ApplicationTable();
 176         $sql = "UPDATE categories_to_documents
 177             JOIN categories ON `name` = ?
 178             SET category_id=id
 179             WHERE document_id = ?";
 180         $result = $obj->zQuery($sql, array($category_name, $document_id));
 181     }
 182 }