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 repositories;
  24
  25 use Doctrine\ORM\EntityRepository;
  26
  27 class ONoteRepository extends EntityRepository {
  28     /**
  29      * Add new office note.
  30      *
  31      * @param $note The new office note.
  32      * @return the new id.
  33      */
  34     public function save(\entities\ONote $note) {
  35         $this->_em->persist($note);
  36         $this->_em->flush();
  37         return $note->getId();
  38     }
  39
  40     /**
  41      * @param $id The office note id.
  42      * @return The single note.
  43      */
  44     public function findNoteById($id) {
  45         $result = $this->_em->getRepository($this->_entityName)->findOneBy(array("id" => $id));
  46         return $result;
  47     }
  48
  49     /**
  50      * Toggles a office note to be enabled.
  51      *
  52      * @param $id The office note id.
  53      * @return true/false if the update was successful.
  54      */
  55     public function enableNoteById($id) {
  56         $result = false;
  57
  58         try {
  59             $note = $this->findNoteById($id);
  60
  61             if ($note) {
  62                 $note->setActivity(1);
  63                 $this->_em->persist($note);
  64                 $this->_em->flush();
  65                 $result = true;
  66             }
  67         } catch (Exception $e) {}
  68
  69         return $result;
  70     }
  71
  72     /**
  73      * Toggles a office note to be enabled.
  74      *
  75      * @param $id The office note id.
  76      * @return true/false if the update was successful.
  77      */
  78     public function disableNoteById($id) {
  79         $result = false;
  80
  81         try {
  82             $note = $this->findNoteById($id);
  83
  84             if ($note) {
  85                 $note->setActivity(0);
  86                 $this->_em->persist($note);
  87                 $this->_em->flush();
  88                 $result = true;
  89             }
  90         } catch (Exception $e) {}
  91
  92         return $result;
  93     }
  94
  95     /**
  96      * Get office notes with filters, Sorted by DESC. Note
  97      * that -1 indicates that all activity types should be
  98      * returned.
  99      *
 100      * @param $activity -1/0/1 to indicate filtered notes.
 101      * @param $offset The start index for pagination.
 102      * @param $limit The limit for pagination.
 103      * @return list of office notes.
 104      */
 105     public function getNotes($activity, $offset, $limit) {
 106         if (!is_numeric($offset) || !is_numeric($limit)) {
 107             return null;
 108         }
 109
 110         $criteria = array();
 111
 112         if ($activity == 1) {
 113             $criteria["activity"] = 1;
 114         } else if ($activity == 0) {
 115             $criteria["activity"] = 0;
 116         }
 117
 118         $result = $this->_em->getRepository($this->_entityName)->findBy(
 119             $criteria,
 120             array("date" => "DESC"),
 121             $limit,
 122             $offset
 123         );
 124
 125         return $result;
 126     }
 127
 128     /**
 129      * An example of how to use HQL with JOINs. Only use
 130      * HQL when the methods that EntityRepository provides
 131      * cannot sufficiently meet the complexity of your query.
 132      */
 133     public function findAllHqlExample() {
 134         // $sql  = "SELECT o ";
 135         // $sql .= "FROM entities\\ONote o ";
 136         // $sql .= "JOIN entities\\User u ";
 137         // $sql .= "WITH o.user = u.username";
 138
 139         // return $this->_em->createQuery($sql)->getResult();
 140     }
 141 }