services/ListService.php

   1 <?php
   2 /**
   3  * ListService
   4  *
   5  * @package   OpenEMR
   6  * @link      http://www.open-emr.org
   7  * @author    Matthew Vita <matthewvita48@gmail.com>
   8  * @author    Brady Miller <brady.g.miller@gmail.com>
   9  * @copyright Copyright (c) 2018 Matthew Vita <matthewvita48@gmail.com>
  10  * @copyright Copyright (c) 2018 Brady Miller <brady.g.miller@gmail.com>
  11  * @license   https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  12  */
  13
  14
  15 namespace OpenEMR\Services;
  16
  17 use Particle\Validator\Validator;
  18
  19 class ListService
  20 {
  21
  22   /**
  23    * Default constructor.
  24    */
  25     public function __construct()
  26     {
  27     }
  28
  29     public function validate($list)
  30     {
  31         $validator = new Validator();
  32
  33         $validator->required('title')->lengthBetween(2, 255);
  34         $validator->required('type')->lengthBetween(2, 255);
  35         $validator->required('pid')->numeric();
  36         $validator->optional('diagnosis')->lengthBetween(2, 255);
  37         $validator->required('begdate')->datetime('Y-m-d');
  38         $validator->optional('enddate')->datetime('Y-m-d');
  39
  40         return $validator->validate($list);
  41     }
  42
  43     public function getAll($pid, $list_type)
  44     {
  45         $sql = "SELECT * FROM lists WHERE pid=? AND type=? ORDER BY date DESC";
  46
  47         $statementResults = sqlStatement($sql, array($pid, $list_type));
  48
  49         $results = array();
  50         while ($row = sqlFetchArray($statementResults)) {
  51             array_push($results, $row);
  52         }
  53
  54         return $results;
  55     }
  56
  57     public function getOptionsByListName($list_name)
  58     {
  59         $sql = "SELECT * FROM list_options WHERE list_id = ?";
  60
  61         $statementResults = sqlStatement($sql, array($list_name));
  62
  63         $results = array();
  64         while ($row = sqlFetchArray($statementResults)) {
  65             array_push($results, $row);
  66         }
  67
  68         return $results;
  69     }
  70
  71     public function getOne($pid, $list_type, $list_id)
  72     {
  73         $sql = "SELECT * FROM lists WHERE pid=? AND type=? AND id=? ORDER BY date DESC";
  74
  75         return sqlQuery($sql, array($pid, $list_type, $list_id));
  76     }
  77
  78     public function insert($data)
  79     {
  80         $sql  = " INSERT INTO lists SET";
  81         $sql .= "     date=NOW(),";
  82         $sql .= "     activity=1,";
  83         $sql .= "     pid=?,";
  84         $sql .= "     type=?,";
  85         $sql .= "     title=?,";
  86         $sql .= "     begdate=?,";
  87         $sql .= "     enddate=?,";
  88         $sql .= "     diagnosis=?";
  89
  90         return sqlInsert(
  91             $sql,
  92             array(
  93                 $data['pid'],
  94                 $data['type'],
  95                 $data["title"],
  96                 $data["begdate"],
  97                 $data["enddate"],
  98                 $data["diagnosis"]
  99             )
 100         );
 101     }
 102
 103     public function update($data)
 104     {
 105         $sql  = " UPDATE lists SET";
 106         $sql .= "     title=?,";
 107         $sql .= "     begdate=?,";
 108         $sql .= "     enddate=?,";
 109         $sql .= "     diagnosis=?";
 110         $sql .= " WHERE id=?";
 111
 112         return sqlStatement(
 113             $sql,
 114             array(
 115                 $data["title"],
 116                 $data["begdate"],
 117                 $data["enddate"],
 118                 $data["diagnosis"],
 119                 $data["id"]
 120             )
 121         );
 122     }
 123
 124     public function delete($pid, $list_id, $list_type)
 125     {
 126         $sql  = "DELETE FROM lists WHERE pid=? AND id=? AND type=?";
 127
 128         return sqlStatement($sql, array($pid, $list_id, $list_type));
 129     }
 130 }