forked from openemr/openemr
-
Notifications
You must be signed in to change notification settings - Fork 0
/
get_amendments.php
56 lines (52 loc) · 2.11 KB
/
get_amendments.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
<?php
/**
* Patient Portal Amendments
*
* Copyright (C) 2014 Ensoftek
* Copyright (C) 2016-2017 Jerry Padgett <[email protected]>
*
* LICENSE: This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation; either version 3
* of the License, or (at your option) any later version.
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http:https://opensource.org/licenses/gpl-license.php>;.
*
* @package OpenEMR
* @author Hema Bandaru <[email protected]>
* @author Jerry Padgett <[email protected]>
* @link http:https://www.open-emr.org
*/
require_once("verify_session.php");
$query = "SELECT a.*,lo.title AS AmendmentBy,lo1.title AS AmendmentStatus FROM amendments a
INNER JOIN list_options lo ON a.amendment_by = lo.option_id AND lo.list_id='amendment_from'
LEFT JOIN list_options lo1 ON a.amendment_status = lo1.option_id AND lo1.list_id='amendment_status'
WHERE a.pid = ? ORDER BY amendment_date DESC";
$res = sqlStatement($query, array($pid));
if (sqlNumRows($res) > 0) { ?>
<table class="table table-striped">
<tr class="header">
<th><?php echo xlt('Date'); ?></th>
<th><?php echo xlt('Requested By'); ?></th>
<th><?php echo xlt('Description'); ?></th>
<th><?php echo xlt('Status'); ?></th>
</tr>
<?php
$even = false;
while ($row = sqlFetchArray($res)) {
echo "<tr class='" . $class . "'>";
echo "<td>" . text($row['amendment_date']) . "</td>";
echo "<td>" . text($row['AmendmentBy']) . "</td>";
echo "<td>" . text($row['amendment_desc']) . "</td>";
echo "<td>" . text($row['AmendmentStatus']) . "</td>";
echo "</tr>";
}
echo "</table>";
} else {
echo xlt("No Results");
}
?>