Viewing file: Historydetail.php (23.69 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 personal_den_tb Where Person_code='$Person_code'"; $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">
<style type="text/css"> <!-- .style1 {color: #000066} .style10 {font-size: xx-small} .style11 {font-size: small} .style13 {color: #000000} .style14 { font-size: 16px; font-weight: bold; } .style2 {color: #000066; font-weight: bold; } .style3 {color: #000066; font-size: 16px; } --> </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="AddPlanteach.php?Person_code=<? echo $rs[Person_code]?>">บันทึกรายการรักษา</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /><a href="AddTeachPlan.php?Person_code=<? echo $rs[Person_code]?>">บันทึกการรักษา</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /><a href="AddTeach.php?Person_code=<? echo $rs[Person_code]?>">บันทึกแผนการรักษา</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"> <table width="83%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" style="border:1px solid gray"> <tr bgcolor="#B6D0F1" background="../Image/centerpix.gif" > <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="22%" height="100%" nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#000066" size="2" face="Tahoma">เลขที่ HN</font></div></td> <td width="2%" bordercolor="#CCCCCC"> </td> <td width="41%" 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="35%" rowspan="11" valign="top" nowrap="nowrap" bordercolor="#CCCCCC"><?php echo"<center>"; echo"<img src=\"$rs[Img1]\" width=\"200\" height=\"150\" >"; echo"</center>"; ?></td> </tr> <tr bgcolor="#ECF5FF"> <td height="21" nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#000066" size="2" face="Tahoma">วันที่เข้าทำการรักษา</font></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"> </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="center"><font color="#000066" size="2" face="Tahoma">ชื่อ</font></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[First_name]"; ?> <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 nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#003366" size="2" face="Tahoma">วัน/เดือน/ปีเกิด</font></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"> <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="center"><font color="#003366" size="2" face="Tahoma">เพศ</font></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"><div align="center"><font color="#003366" size="2" face="Tahoma">เชื้อชาติ</font></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[Nationality]"; ?> </font></font><font color="#003366" size="2" face="Tahoma">สัญชาติ </font><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"> <?php echo"$rs[Nation]"; ?> </font></font><font color="#003366" size="2" face="Tahoma"> </font></td> </tr> <tr bgcolor="#ECF5FF"> <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#003366" size="2" face="Tahoma">ศาสนา</font></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[Religion]"; ?> </font></font><font size="2" face="Tahoma"> </font></td> </tr> <tr bgcolor="#ECF5FF"> <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#003366" size="2" face="Tahoma">อายุ</font></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[Age]"; ?> </font></font><font size="2" face="MS Sans Serif, Tahoma, sans-serif"> </font></td> </tr> <tr bgcolor="#ECF5FF"> <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#003366" size="2" face="Tahoma">เลขที่บัตรประจำตัวประชาชน</font></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[Citizen_id]"; ?> </font></font> </td> </tr> <tr bgcolor="#ECF5FF"> <td height="100%" nowrap="nowrap"><div align="center"><font color="#000066" size="2" face="Tahoma">สถานพยาบาลผู้ประกัน</font></div></td> <td> </td> <td nowrap="nowrap"><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"><div align="center"><font color="#000066" size="2" face="Tahoma">ภูมิลำเนา / ที่อยู่</font></div></td> <td bordercolor="#CCCCCC"><font size="1" face="Tahoma"> </font></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[Address]"; ?> </font></font><font size="1" face="Tahoma"> </font></td> </tr> <tr bgcolor="#CDDFF5"> <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#000066" size="2" face="Tahoma">จังหวัด</font></div></td> <td bordercolor="#CCCCCC"> </td> <td nowrap="nowrap" bordercolor="#CCCCCC"><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"> </td> </tr> <tr bgcolor="#CDDFF5"> <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#000066" size="2" face="Tahoma">รหัสไปรษณีย์</font></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[Zipcode]"; ?> </font></font></td> <td nowrap="nowrap" bordercolor="#CCCCCC"> </td> </tr> <tr bgcolor="#CDDFF5"> <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#000066" size="2" face="Tahoma">เบอร์โทรที่บ้าน</font></div></td> <td bordercolor="#CCCCCC"> </td> <td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#CDDFF5"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"> <?php echo"$rs[Phone]"; ?> </font></font><font color="#000066" size="2" face="Tahoma">มือถือ</font><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"> <?php echo"$rs[Mobile]"; ?> </font></font></td> <td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#CDDFF5"> </td> </tr> <tr bgcolor="#CDDFF5"> <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#000066" size="2" face="Tahoma">อาชีพ</font></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[Work]"; ?> </font></font><font size="2" face="MS Sans Serif, Tahoma, sans-serif"> </font></td> <td nowrap="nowrap" bordercolor="#CCCCCC"> </td> </tr> <tr bgcolor="#CDDFF5"> <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#000066" size="2" face="Tahoma">การศึกษา</font></div></td> <td bordercolor="#CCCCCC"> </td> <td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#CDDFF5"><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="#CDDFF5"> </td> </tr> <tr bgcolor="#CDDFF5"> <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center" class="style1"><font size="2" face="Tahoma">E-mail</font></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[Email_name]"; ?> </font></font></td> <td nowrap="nowrap" bordercolor="#CCCCCC"> </td> </tr> <tr bgcolor="#CDDFF5"> <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#993333" size="2" face="Tahoma"><strong>ในกรณีที่เป็นเด็ก</strong></font></div></td> <td bordercolor="#CCCCCC"> </td> <td nowrap="nowrap" bordercolor="#CCCCCC"> </td> <td nowrap="nowrap" bordercolor="#CCCCCC"> </td> </tr> <tr bgcolor="#ECF5FF" > <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font size="2" face="Tahoma">สถานภาพ บิดา</font></div></td> <td bordercolor="#CCCCCC"> </td> <td nowrap="nowrap" bordercolor="#CCCCCC"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="40%"><font size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"> <?php echo"$rs[Status2]"; ?> </font></font><font size="2" face="Tahoma"> </font></td> <td width="60%"><font color="#000000" size="2" face="Tahoma"> <font size="2" face="Tahoma">มารดา</font> <font color="#000000" size="2" face="Tahoma"> <?php echo"$rs[Status3]"; ?> </font></font> </td> </tr> </table></td> <td nowrap="nowrap" bordercolor="#CCCCCC"> </td> </tr> <tr bgcolor="#ECF5FF" > <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#000000" size="2" face="Tahoma">ชื่อ - นามสกุล บิดา</font></div></td> <td bordercolor="#CCCCCC"> </td> <td nowrap="nowrap" bordercolor="#CCCCCC"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="40%" height="22"><font color="#000000" size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"> <?php echo"$rs[Father_name]"; ?> </font></font><font size="2" face="Tahoma"> </font></td> <td width="60%"><font size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma"> มารดา <font color="#000000" size="2" face="Tahoma"> <?php echo"$rs[Mother_name]"; ?> </font> </font></td> </tr> </table></td> <td nowrap="nowrap" bordercolor="#CCCCCC"> </td> </tr> <tr bgcolor="#ECF5FF"> <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font color="#000000" size="2" face="Tahoma">เบอร์โทรผู้ปกครอง</font></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[Phone_1]"; ?> </font> มือถือ <font color="#000000" size="2" face="Tahoma"> <?php echo"$rs[Mobile_1]"; ?> </font></font></td> <td nowrap="nowrap" bordercolor="#CCCCCC"> </td> </tr> <tr bgcolor="#ECF5FF"> <td nowrap="nowrap" bordercolor="#CCCCCC"><div align="center"><font size="2" face="Tahoma">E-mail</font></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[Email_1]"; ?> </font></font></td> <td nowrap="nowrap" bordercolor="#CCCCCC"> </td> </tr> <tr bgcolor="#B6D0F1" > <td height="23" colspan="4" nowrap="nowrap" bordercolor="#CCCCCC" background="../Image/centerpix.gif"><div align="center"> </div> <div align="center"></div> <div align="center"><font color="#FFFFFF" size="2" face="Tahoma"><strong><font color="#003366"> </font></font> <font color="#003366"><font size="2" face="Tahoma">ประวัติทางการแพทย์</font></font></div></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="center"><font color="#000000" size="2" face="Tahoma">มี<font size="2" face="Tahoma">โรค</font></font></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><div align="center"><font size="2" face="Tahoma">โรคอื่นๆ </font></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"> <?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> </td> </tr> <tr> <td width="27%"><div align="center"><span class="style10"><span class="style11"><font size="2" face="Tahoma"><span class="style1"><font color="#FF0000" face="Tahoma">*</font> <span class="style13">ทันตแพทย์ผู้ทำการรักษา</span></span></font><font face="Tahoma"> </font></span></span></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"><font size="2" face="Tahoma"> 1.แพ้ยา</font>.</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="style1"><font size="2" face="Tahoma">2.แพ้ยา</font>.</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="style1"><font size="2" face="Tahoma">3.แพ้ยา</font>.</div></td> <td width="37%"><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="48"><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>
|