2 require_once("{$GLOBALS['srcdir']}/sql.inc");
4 $patient_note_types = array(
15 function getPnoteById($id, $cols = "*")
17 return sqlQuery("SELECT $cols FROM pnotes WHERE id='$id' " .
18 "order by date DESC limit 0,1");
21 function getPnotesByDate($date, $activity = "1", $cols = "*", $pid = "%",
22 $limit = "all", $start = 0, $username = '')
24 $sql = "SELECT $cols FROM pnotes WHERE date LIKE '%$date%' " .
25 "AND pid LIKE '$pid' ";
26 if ($activity != "all")
27 $sql .= "AND activity = '$activity' ";
29 $sql .= "AND assigned_to = '$username' ";
30 $sql .= "ORDER BY date DESC";
32 $sql .= " LIMIT $start, $limit";
34 $res = sqlStatement($sql);
36 for ($iter = 0;$row = sqlFetchArray($res);$iter++)
41 function getPnotesByPid ($pid, $activity = "1", $cols = "*", $limit=10, $start=0)
43 $res = sqlStatement("SELECT $cols FROM pnotes WHERE pid LIKE '$pid' " .
44 "AND activity = '$activity' ORDER BY date DESC LIMIT $start,$limit");
45 for ($iter = 0; $row = sqlFetchArray($res); $iter++)
50 function addPnote($pid, $newtext, $authorized = '0', $activity = '1',
51 $title='Unassigned', $assigned_to = '')
53 $body = date('Y-m-d H:i') . ' (' . $_SESSION['authUser'];
54 if ($assigned_to) $body .= " to $assigned_to";
55 $body = addslashes($body . ') ' . $newtext);
57 return sqlInsert("INSERT INTO pnotes (date, body, pid, user, groupname, " .
58 "authorized, activity, title, assigned_to) VALUES (NOW(), '$body', '$pid', '" .
59 $_SESSION['authUser'] . "', '". $_SESSION['authProvider'] .
60 "', '$authorized', '$activity', '$title', '$assigned_to')");
63 function updatePnote($id, $newtext, $title, $assigned_to)
65 $row = getPnoteById($id);
66 if (! $row) die("updatePnote() did not find id '$id'");
67 $activity = $assigned_to ? '1' : '0';
69 $body = $row['body'] . "\n" . date('Y-m-d H:i') .
70 ' (' . $_SESSION['authUser'];
71 if ($assigned_to) $body .= " to $assigned_to";
72 $body = addslashes($body . ') ' . $newtext);
74 sqlStatement("UPDATE pnotes SET " .
75 "body = '$body', activity = '$activity', title='$title', " .
76 "assigned_to = '$assigned_to' WHERE id = '$id'");
79 function authorizePnote($id, $authorized = "1")
81 sqlQuery("UPDATE pnotes SET authorized = '$authorized' WHERE id = '$id'");
84 function disappearPnote($id)
86 sqlStatement("UPDATE pnotes SET activity = '0' WHERE id='$id'");
90 function reappearPnote ($id)
92 sqlStatement("UPDATE pnotes SET activity = '1' WHERE id='$id'");