Viewing file: Historydetail.php (24.08 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("../include/FunctionDB.php");
include("admin_menu.php");
include("../include/Function.php");
ConnectDB();
$sql = "Select * From user_tb Where Username='$Username'";
$result = mysql_query($sql) or die(" Error".mysql_error());
$rs1 = mysql_fetch_array($result);
$Username = $rs1[Username];
$sql1 = "Select * From personalMed Where personId='$personId'";
$result1 = mysql_query($sql1) or die(" Error".mysql_error());
$rs = mysql_fetch_array($result1);
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {color: #000066}
.style13 {color: #000000}
.style14 { font-size: 16px;
font-weight: bold;
}
.style2 {color: #000066; font-weight: bold; }
.style3 {
color: #000066;
font-size: 14px;
font-family: Tahoma;
}
.style15 {font-size: 14px}
.style16 {color: #000066; font-size: 14px; }
.style18 {font-family: Tahoma; font-size: 14px; }
.style19 {color: #000066; font-family: Tahoma; }
-->
</style>
<table width="815" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="815" ><br />
<fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="index.php">หน้าหลัก</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /><a href="AddTeacperson.php?personId=<? echo $rs[personId]?>">บันทึกรายการรักษา</a><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" />แสดงประวัติคนไข้</font></legend>
<label> </label>
<div align="center">
<form id="form1" name="form1" method="post" action="SearchList.php">
<p align="left"><font size="2" face="Tahoma"><img src="../picture/previous.gif" onclick="window.history.back()" width="85" height="22" border="0" /></font></p>
<table width="83%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" style="border:0px solid gray">
<tr bgcolor="#B6D0F1" >
<td height="28" colspan="4" nowrap="nowrap" bordercolor="#CCCCCC"><div align="center" class="style14"><font color="#003366" face="Tahoma">ประวัติส่วนตัว</font></div></td>
</tr>
<tr bgcolor="#ECF5FF">
<td width="24%" height="100%" nowrap="nowrap" bordercolor="#CCCCCC"><div align="right" class="style15">
<div align="center"><font color="#000066" face="Tahoma">เลขที่ HN</font></div>
</div></td>
<td width="1%" bordercolor="#CCCCCC"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[HN_code]";
?>
</font> </font></td>
<td width="32%" rowspan="12" valign="top" nowrap="nowrap" bordercolor="#CCCCCC"><table width="200" border="0" align="center" cellpadding="1" cellspacing="0">
<tr>
<td height="20"><div align="center">
<?php
echo"<center>";
echo"<img src=\"$rs[Img1]\" width=\"200\" height=\"150\" >";
echo"</center>";
?>
</div></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#ECF5FF">
<td height="21" nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="right" class="style15">
<div align="center"><font color="#000066" face="Tahoma">วันที่เข้าทำการรักษา</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"> </font><font color="#003366" size="2" face="Tahoma">
<?php
$sday = $rs[Datetype];
$yearthai = explode("-",$sday);
$day = intval($yearthai[2]);
$month = intval($yearthai[1]);
$year = intval($yearthai[0]);
//////////////////
// $yearthai = $day ;
$m = getThaiSubMonth($month);
echo"$day"." "."$m"." "."$year";
?>
</font></font> </td>
</tr>
<tr bgcolor="#ECF5FF">
<td nowrap="nowrap" bordercolor="#CCCCCC"><div align="right" class="style15">
<div align="center"><font color="#000066" face="Tahoma">ชื่อ</font></div>
</div></td>
<td bordercolor="#CCCCCC"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC"><font size="2" face="Tahoma"><font size="2" face="Tahoma">
<?php
$prefixId = $rs["prefixId"];
$sql = "Select * From Prefix Where prefixId ='$prefixId' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rss = mysql_fetch_array($result1);
echo "$rss[prefixName] ";
?>
</font></font><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Name]";
?>
<font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Lastname]";
?></font></font></font></td>
</tr>
<tr bgcolor="#ECF5FF">
<td height="25" nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="right" class="style15">
<div align="center"><font color="#003366" face="Tahoma">วัน/เดือน/ปีเกิด</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"> <font color="#003366" size="2" face="Tahoma">
<?php
$sday = $rs[DateBirth];
$yearthai = explode("-",$sday);
$day = intval($yearthai[2]);
$month = intval($yearthai[1]);
$year = intval($yearthai[0]);
//////////////////
// $yearthai = $day ;
$m = getThaiSubMonth($month);
echo"$day"." "."$m"." "."$year";
?>
</font> </font></font></td>
</tr>
<tr bgcolor="#ECF5FF">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"><div align="right" class="style15">
<div align="center"><font color="#003366" face="Tahoma">เพศ</font></div>
</div></td>
<td bordercolor="#CCCCCC"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Sex]";
?>
</font></font> <font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"> </font></font></td>
</tr>
<tr bgcolor="#ECF5FF">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="right" class="style15">
<div align="center"><font color="#003366" face="Tahoma">เชื้อชาติ</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Nationality]";
?>
</font></font><font color="#003366" size="2" face="Tahoma"> </font></td>
</tr>
<tr bgcolor="#ECF5FF">
<td nowrap="nowrap" bordercolor="#CCCCCC"><div align="right" class="style15">
<div align="center"><font color="#003366" face="Tahoma">สัญชาติ </font> </div>
</div></td>
<td bordercolor="#CCCCCC"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Nation]";
?>
</font></font></td>
</tr>
<tr bgcolor="#ECF5FF">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="right" class="style15">
<div align="center"><font color="#003366" face="Tahoma">ศาสนา</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Religion]";
?>
</font></font></td>
</tr>
<tr bgcolor="#ECF5FF">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"><div align="right" class="style15">
<div align="center"><font color="#003366" face="Tahoma">อายุ</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#ECF5FF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Age]";
?>
</font></font><font size="2" face="MS Sans Serif, Tahoma, sans-serif"> </font></td>
</tr>
<tr bgcolor="#ECF5FF">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="right" class="style15">
<div align="center"><font color="#003366" face="Tahoma">เลขที่บัตรประจำตัวประชาชน</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Citizen_id]";
?>
</font></font> </td>
</tr>
<tr bgcolor="#ECF5FF">
<td height="100%" nowrap="nowrap" bgcolor="#ECF5FF"><div align="right" class="style15">
<div align="center"><font color="#000066" face="Tahoma">สถานพยาบาลผู้ประกัน</font></div>
</div></td>
<td bgcolor="#ECF5FF"> </td>
<td nowrap="nowrap" bgcolor="#ECF5FF"><span class="style19"><font color="#000000" size="2" face="Tahoma"> <?php
$Hostpital = $rs["Hostpital"];
$sql = "Select * From hospital Where Hostpital='$Hostpital'";
$result2 = mysql_query($sql) or die("Error".mysql_error());
$rss2 = mysql_fetch_array($result2);
echo "$rss2[Hostpital_name] ";
?>
</font></span></td>
</tr>
<tr bgcolor="#ECF5FF">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="right" class="style15">
<div align="center"><font color="#000066" face="Tahoma">ภูมิลำเนา
/ ที่อยู่</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"><font size="1" face="Tahoma"> </font></td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><span class="style18">
<font color="#000000"><font color="#000000">
<?php
echo"$rs[Address]";
?>
</font></font></span></td>
</tr>
<tr bgcolor="#CDDFF5">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"><div align="right" class="style15">
<div align="center"><font color="#003366" face="Tahoma">ตำบล/แขวง</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#ECF5FF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"><font color="#000000" size="2" face="Tahoma">
<?php
$districtId = $rs["districtId"];
$sql = "Select * From District Where districtId='$districtId'";
$result2 = mysql_query($sql) or die("Error".mysql_error());
$rss2 = mysql_fetch_array($result2);
echo "$rss2[districtName] ";
?>
</font></td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"> </td>
</tr>
<tr bgcolor="#CDDFF5">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="center"><span class="style15"><font color="#003366" face="Tahoma">อำเภอ</font></span></div></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma">
<?php
$amphurId = $rs["amphurId"];
$sql = "Select * From Amphur Where amphurId='$amphurId'";
$result2 = mysql_query($sql) or die("Error".mysql_error());
$rss2 = mysql_fetch_array($result2);
echo "$rss2[amphurName] ";
?>
</font></td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#CDDFF5">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"><div align="right" class="style15">
<div align="center"><font color="#000066" face="Tahoma">จังหวัด</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#ECF5FF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"><font color="#000000" size="2" face="Tahoma">
<?php
$provinceId = $rs["provinceId"];
$sql = "Select * From Province Where provinceId='$provinceId'";
$result2 = mysql_query($sql) or die("Error".mysql_error());
$rss2 = mysql_fetch_array($result2);
echo "$rss2[provinceName] ";
?>
</font></td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"> </td>
</tr>
<tr bgcolor="#CDDFF5">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="right" class="style15">
<div align="center"><font color="#000066" face="Tahoma">รหัสไปรษณีย์</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Zipcode]";
?>
</font></font></td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#CDDFF5">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"><div align="right" class="style15">
<div align="center"><font color="#000066" face="Tahoma">เบอร์โทรที่บ้าน</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#ECF5FF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Phone]";
?>
</font></font></td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF">
<font color="#000000" face="Tahoma"><span class="style15"><font color="#000066" face="Tahoma">มือถือ</font></span></font><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Mobile]";
?>
</font></font></td>
</tr>
<tr bgcolor="#CDDFF5">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="right" class="style15">
<div align="center"><font color="#000066" face="Tahoma">อาชีพ</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Work]";
?>
</font></font><font size="2" face="MS Sans Serif, Tahoma, sans-serif"> </font></td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#CDDFF5">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"><div align="right" class="style15">
<div align="center"><font color="#000066" face="Tahoma">การศึกษา</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#ECF5FF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Education]";
?>
</font></strong></font><font size="2" face="MS Sans Serif, Tahoma, sans-serif"> </font></td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#ECF5FF"> </td>
</tr>
<tr bgcolor="#CDDFF5">
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="center" class="style16">
<div align="center"><font face="Tahoma">E-mail</font></div>
</div></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Email_name]";
?>
</font></font></td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#ECF5FF">
<td colspan="4" nowrap="nowrap" bordercolor="#CCCCCC"><table width="100%" border="0" cellpadding="0" cellspacing="1">
<tr>
<td><div align="right" class="style18">
<div align="center"><font color="#000000">มีโรค</font></div>
</div></td>
<td colspan="3"><font size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Degree_code]";
?>
</font></font></td>
<td> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="right" class="style18">
<div align="center">โรคอื่นๆ </div>
</div></td>
<td colspan="3" bgcolor="#FFFFFF"><font size="2" face="Tahoma"> ุ</font><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Club_nid]";
?>
</font></font><font color="#003366" size="2" face="Tahoma"> </font><font size="2" face="MS Sans Serif, Tahoma, sans-serif"> </font></td>
<td bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td width="25%"><div align="right" class="style18">
<div align="center"><span class="style1"><font color="#FF0000">*</font> <span class="style13">อยุรเวทผู้ตรวจ</span></span> </div>
</div></td>
<td colspan="3"><font size="2" face="Tahoma"> ุ
<?php
$Teacher_code = $rs["Teacher_code"];
$sql = "Select * From personal_tb Where Teacher_code='$Teacher_code'";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rss = mysql_fetch_array($result1);
echo "$rss[First_name] $rss[Teacher_name] $rss[Teacher_lastname] ";
?>
</font></span></td>
<td width="26%"><font size="2" face="Tahoma"><span class="style1"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Group_4]";
?>
</font></strong></font></strong></span></font></td>
</tr>
<tr>
<td height="22" colspan="5" background="../Image/centerpix.gif"><div align="center" class="style2"><font size="2" face="Tahoma">ประวัติการแพ้ยา </font></div></td>
</tr>
<tr>
<td><div align="center"></div></td>
<td><div align="right" class="style3">
<div align="center"> 1.แพ้ยา.</div>
</div></td>
<td><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Group_1]";
?>
</font></strong></font><font color="#000066" size="2" face="Tahoma"> </font></td>
<td> </td>
<td rowspan="4"> </td>
</tr>
<tr>
<td><div align="center"><font size="2" face="Tahoma"> </font></div></td>
<td><div align="center" class="style3">2.แพ้ยา.</div></td>
<td><font color="#000066" size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Group_2]";
?>
</font></strong></font><font size="2" face="Tahoma"> </font></td>
<td> </td>
</tr>
<tr>
<td><div align="center"><font size="2" face="Tahoma"> </font></div></td>
<td width="9%"><div align="center" class="style3">3.แพ้ยา.</div></td>
<td width="39%"><font color="#000066" size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Group_3]";
CloseDB();
?>
</font></strong></font><font size="2" face="Tahoma"> </font></td>
<td width="1%"> </td>
</tr>
<tr>
<td height="25"><div align="center"><font size="2" face="Tahoma"> </font></div></td>
<td><div align="center"></div></td>
<td><font color="#000066" size="2" face="Tahoma"> </font><font size="2" face="Tahoma"> </font></td>
<td> </td>
</tr>
</table></td>
</tr>
<tr bgcolor="#B6D0F1">
<td height="21" colspan="4" nowrap="nowrap" bordercolor="#CCCCCC" background="../Image/centerpix.gif"><div align="center"><font color="#003366" size="2" face="Tahoma"></font></div></td>
</tr>
</table>
</form>
</div>
</fieldset>
<br />
<font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ<br />
</font></td>
</tr>
</table>
|