01.
<?php
02.
include
(
'_functions/phpFunction.php'
);
03.
require
(
'_connections/Connect.php'
);
04.
$ladmit_n
=
''
;
05.
$numc
=
''
;
06.
07.
if
(isset(
$_POST
[
'hn'
])) {
$hn
=
$_POST
[
'hn'
];}
else
{
$hn
=
'not data'
;}
08.
$hn
=string_Format(
$_POST
[
'hn'
],7);
09.
$charset
=
"set names tis620"
;
10.
11.
$query
=
"select I.ladmit_n,I.hn,I.admit_date,I.admit_time,I.sex,I.age,"
;
12.
$query
.=
"P.firstName + '' + P.lastName as fullname, W.ward_name,I.current_room "
;
13.
$query
.=
"from Ipd_h I ,PATIENT P ,Ward W "
;
14.
$query
.=
"where I.hn='$hn' and P.hn = I.hn "
;
15.
$query
.=
"and I.discharge_status='0' and W.ward_id = I.ward_id "
;
16.
$query
.=
" and I.discharge_status='0'"
;
17.
$rs
=mssql_query(
$query
,
$link
);
18.
$resid
=mssql_query(
$query
);
19.
$numc
=mssql_num_rows(
$resid
);
20.
$row
=mssql_fetch_array(
$rs
);
21.
22.
if
(
$numc
==0)
23.
{
echo
"HN นี้ไม่ได้เป็นผู้ป่วยใน!!!"
;
24.
exit
();
25.
}
26.
mssql_free_result(
$rs
);
27.
?>
28.
<HEAD>
29.
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=utf-8"
>
30.
<script language=
"javascript"
src=
"_functions/JavaFunction.js"
></script>
31.
<style type=
"text/css"
>
32.
</style></HEAD>
33.
<FORM NAME=
"form1"
method=
"post"
action=
"frm_pang_test.php"
>
34.
<table border=
"1"
width=
"677"
border=
"0"
>
35.
<tr>
36.
37.
<td>Hn</td>
38.
<td><?php
echo
$row
[
'hn'
]?></td>
39.
<td>An</td>
40.
<td><?php
echo
$row
[
'ladmit_n'
];?></td>
41.
</tr>
42.
<tr>
43.
<td>ชื่อ - สกุล</td>
44.
<td><?php
echo
$row
[
'fullname'
];?></td>
45.
<td>อายุ</td>
46.
<td><?php
echo
$row
[
'age'
]?> ปี</td>
47.
</tr>
48.
<tr>
49.
<td>หอผู้ป่วย</td>
50.
<td><?php
echo
$row
[
'ward_name'
]?></td>
51.
<td>ห้อง</td>
52.
<td><?php
echo
$row
[
'current_room'
]?></td>
53.
</tr>
54.
<tr>
55.
<td>วันที่เข้า Admit</td>
56.
<td><?php
echo
$row
[
'admit_date'
]?></td>
57.
<td>เวลา Admit</td>
58.
<td><?php
echo
$row
[
'admit_time'
]?></td>
59.
</tr>
60.
</table>
61.
<table width=
"582"
border=
"0"
>
62.
<tr>
63.
<td width=
"111"
><div align=
"center"
>row</div></td>
64.
<td width=
"194"
><input type=
"text"
name=
"row"
id=
"row"
onKeyPress=
"inputDate(self, this);"
maxlength=
"2"
style=
"width :50px"
value =
"1"
> (1-10)</td>
65.
<td width=
"95"
>column</td>
66.
<td width=
"137"
>
67.
<label></label><input type=
"text"
name=
"col"
id=
"col"
onKeyPress=
"inputDate(self, this);"
maxlength=
"2"
style=
"width :50px"
value =
"1"
> (1-3)</td>
68.
<td width=
"23"
> </td>
69.
</tr>
70.
</table>
71.
<table width=
"582"
border=
"0"
>
72.
<tr>
73.
<td width=
"228"
>จำนวนที่ต้องการพิมพ์</td>
74.
<td width=
"344"
><input type=
"text"
name=
"total"
id=
"total"
onKeyPress=
"inputDate(self, this);"
maxlength=
"2"
style=
"width :50px"
value=
"30"
></td>
75.
</tr>
76.
</table>
77.
<table width=
"583"
border=
"0"
>
78.
<tr>
79.
<td><div align=
"center"
>
80.
<input type=
"submit"
name=
"button"
id=
"button"
value=
"ตกลง"
>
81.
</div></td>
82.
</tr>
83.
</table>
84.
</form>