repositories/ONoteRepository.php

   1 <?php
   2 /**
   3  * Office note repository.
   4  *
   5  * Copyright (C) 2017 Matthew Vita <matthewvita48@gmail.com>
   6  *
   7  * LICENSE: This program is free software; you can redistribute it and/or
   8  * modify it under the terms of the GNU General Public License
   9  * as published by the Free Software Foundation; either version 2
  10  * of the License, or (at your option) any later version.
  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 General Public License for more details.
  15  * You should have received a copy of the GNU General Public License
  16  * along with this program. If not, see <http://opensource.org/licenses/gpl-license.php>;.
  17  *
  18  * @package OpenEMR
  19  * @author  Matthew Vita <matthewvita48@gmail.com>
  20  * @link    http://www.open-emr.org
  21  */
  22
  23 namespace OpenEMR\Repositories;
  24
  25 use Doctrine\ORM\EntityRepository;
  26 use OpenEMR\Entities\ONote;
  27
  28 class ONoteRepository extends EntityRepository
  29 {
  30     /**
  31      * Add new office note.
  32      *
  33      * @param $note The new office note.
  34      * @return the new id.
  35      */
  36     public function save(ONote $note)
  37     {
  38         $this->_em->persist($note);
  39         $this->_em->flush();
  40         return $note->getId();
  41     }
  42
  43     /**
  44      * @param $id The office note id.
  45      * @return The single note.
  46      */
  47     public function findNoteById($id)
  48     {
  49         $result = $this->_em->getRepository($this->_entityName)->findOneBy(array("id" => $id));
  50         return $result;
  51     }
  52
  53     /**
  54      * Toggles a office note to be enabled.
  55      *
  56      * @param $id The office note id.
  57      * @return true/false if the update was successful.
  58      */
  59     public function enableNoteById($id)
  60     {
  61         $result = false;
  62
  63         try {
  64             $note = $this->findNoteById($id);
  65
  66             if ($note) {
  67                 $note->setActivity(1);
  68                 $this->_em->persist($note);
  69                 $this->_em->flush();
  70                 $result = true;
  71             }
  72         } catch (Exception $e) {
  73         }
  74
  75         return $result;
  76     }
  77
  78     /**
  79      * Toggles a office note to be enabled.
  80      *
  81      * @param $id The office note id.
  82      * @return true/false if the update was successful.
  83      */
  84     public function disableNoteById($id)
  85     {
  86         $result = false;
  87
  88         try {
  89             $note = $this->findNoteById($id);
  90
  91             if ($note) {
  92                 $note->setActivity(0);
  93                 $this->_em->persist($note);
  94                 $this->_em->flush();
  95                 $result = true;
  96             }
  97         } catch (Exception $e) {
  98         }
  99
 100         return $result;
 101     }
 102
 103     /**
 104      * Get office notes with filters, Sorted by DESC. Note
 105      * that -1 indicates that all activity types should be
 106      * returned.
 107      *
 108      * @param $activity -1/0/1 to indicate filtered notes.
 109      * @param $offset The start index for pagination.
 110      * @param $limit The limit for pagination.
 111      * @return list of office notes.
 112      */
 113     public function getNotes($activity, $offset, $limit)
 114     {
 115         if (!is_numeric($offset) || !is_numeric($limit)) {
 116             return null;
 117         }
 118
 119         $criteria = array();
 120
 121         if ($activity == 1) {
 122             $criteria["activity"] = 1;
 123         } else if ($activity == 0) {
 124             $criteria["activity"] = 0;
 125         }
 126
 127         $result = $this->_em->getRepository($this->_entityName)->findBy(
 128             $criteria,
 129             array("date" => "DESC"),
 130             $limit,
 131             $offset
 132         );
 133
 134         return $result;
 135     }
 136
 137     /**
 138      * An example of how to use HQL with JOINs. Only use
 139      * HQL when the methods that EntityRepository provides
 140      * cannot sufficiently meet the complexity of your query.
 141      */
 142     public function findAllHqlExample()
 143     {
 144         // $sql  = "SELECT o ";
 145         // $sql .= "FROM ONote o ";
 146         // $sql .= "JOIN User u ";
 147         // $sql .= "WITH o.user = u.username";
 148
 149         // return $this->_em->createQuery($sql)->getResult();
 150     }
 151 }