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
15 namespace OpenEMR\Services
;
17 use Particle\Validator\Validator
;
23 * Default constructor.
25 public function __construct()
29 public function validate($list)
31 $validator = new Validator();
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');
40 return $validator->validate($list);
43 public function getAll($pid, $list_type)
45 $sql = "SELECT * FROM lists WHERE pid=? AND type=? ORDER BY date DESC";
47 $statementResults = sqlStatement($sql, array($pid, $list_type));
50 while ($row = sqlFetchArray($statementResults)) {
51 array_push($results, $row);
57 public function getOptionsByListName($list_name)
59 $sql = "SELECT * FROM list_options WHERE list_id = ?";
61 $statementResults = sqlStatement($sql, array($list_name));
64 while ($row = sqlFetchArray($statementResults)) {
65 array_push($results, $row);
71 public function getOne($pid, $list_type, $list_id)
73 $sql = "SELECT * FROM lists WHERE pid=? AND type=? AND id=? ORDER BY date DESC";
75 return sqlQuery($sql, array($pid, $list_type, $list_id));
78 public function insert($data)
80 $sql = " INSERT INTO lists SET";
81 $sql .= " date=NOW(),";
82 $sql .= " activity=1,";
86 $sql .= " begdate=?,";
87 $sql .= " enddate=?,";
88 $sql .= " diagnosis=?";
103 public function update($data)
105 $sql = " UPDATE lists SET";
107 $sql .= " begdate=?,";
108 $sql .= " enddate=?,";
109 $sql .= " diagnosis=?";
110 $sql .= " WHERE id=?";
124 public function delete($pid, $list_id, $list_type)
126 $sql = "DELETE FROM lists WHERE pid=? AND id=? AND type=?";
128 return sqlStatement($sql, array($pid, $list_id, $list_type));