-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy patheditreportselect.php
76 lines (71 loc) · 3.25 KB
/
editreportselect.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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
<?php
# ThaiRIS (Thai Radiology Information System)
# Version: 1.8
# File last modified: 4-Oct 2020
# File name:
# http://www.thairis.net
# By ThaiRIS.Net
# Email : [email protected]
##############################################################################
# COPYRIGHT NOTICE
# Copyright 2009-2024 ThaiRIS All Rights Reserved.
#
# This script may be used and modified free of charge by anyone so long as
# this copyright notice and the comments above remain intact. By using this
# code you agree to indemnify ThaiRIS.net from any liability that might
# arise from it's use.
#
# Selling the code for this program without prior written consent is
# expressly forbidden. In other words, please ask first before you try and
# make money off this program.
#
# Obtain permission before redistributing this software over the Internet or
# in any other medium. In all cases copyright and header must remain intact.
# This Copyright is in full effect in any country that has International
##############################################################################
$MRN = $_GET['MRN'];
include ("session.php");
include ("connectdb.php");
include ("function.php");
echo "<div id=showsearch>";
echo "MRN = ".$MRN."<br />";
echo "Select Order to edit Report";
$sql = "SELECT xray_request_detail.ACCESSION,
xray_request_detail.XRAY_CODE,
xray_request_detail.STATUS,
xray_request_detail.ID AS ORDERID,
xray_request_detail.REQUEST_DATE AS REQ_DATE,
xray_request_detail.REPORT_STATUS,
xray_code.DESCRIPTION FROM xray_request_detail
LEFT JOIN xray_request ON (xray_request_detail.REQUEST_NO = xray_request.REQUEST_NO AND xray_request.MRN = '$MRN')
INNER JOIN xray_code ON (xray_request_detail.XRAY_CODE = xray_code.XRAY_CODE)
INNER JOIN xray_patient_info ON (xray_request.MRN = xray_patient_info.MRN)
where (xray_request_detail.STATUS = 'APPROVED')";
$result = mysqli_query($dbconnect, $sql);
$bg ="#FFCCCC";
echo "<center><table width=100%>";
while($row = mysqli_fetch_array($result))
{
if ($bg == "#FFFFFF")
{
$bg = "#FFCCCC";
}
else
{
$bg = "#FFFFFF";
}
if ($row[REPORT_STATUS]=='1')
{
$report_icon ="<a href=showreport.php?ACCESSION=".$row['ACCESSION']." target=_blank><img src=./image/report.gif border=0></a> <a href=showreportpdf.php?ACCESSION=".$row['ACCESSION']." target=_blank><img src=./image/pdf.gif border=0></a>";
}
else
{
$report_icon ="-";
}
$ORDERID = $row['ORDERID'];
echo "<tr bgcolor=".$bg."><td width=45>".$report_icon."</td><td>".EngEachDate($row['REQ_DATE'])."</td><td>".$row['ACCESSION']."</td><td>".$row['XRAY_CODE']."</td><td>".$row['DESCRIPTION']."</td><td>";
echo "<a href=dictate-edit.php?ORDERID=".$ORDERID."&RADID=".$RADID."><button type=button class=positive value=OpenImage><img src=icons/blog--pencil.png alt=\"\" />Edit Report</button></a>";
}
echo "</table></center>";
echo "</div>";
?>