Viewing file: Planteachdetail1.php (22.06 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php session_start(); if (session_is_registered("valid_user")) { include("../include/FunctionDB.php"); include("../include/Function.php"); ConnectDB(); $sql ="select * From account Where No_code='$No_code' "; $result = mysql_query($sql); $rs = mysql_fetch_array($result); $sql1 ="select * From personal_den_tb Where Person_code='$Person_code' "; $result1 = mysql_query($sql1); $rs1 = mysql_fetch_array($result1); ?>
<html> <head> <title>บันทึกแผนการรักษา</title> <meta http-equiv="Content-Type" content="text/html; charset=windows-874"> <link href="../source/style.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- .style3 {font-size: 18px} .style4 {font-size: 12px} .style6 {color: #003333} .style11 {font-size: 14px} .style17 {font-weight: bold} .style18 {font-family: Tahoma} .style19 {font-family: Tahoma; font-size: 14px; } .style21 {font-size: 14} .style22 {color: #000000} .style23 {font-size: 16px} --> </style> <table width="61%" border="0" align="center" cellpadding="0" cellspacing="0" style="border:1px solid gray"> <form name="form1"method="post" action="InsertTeach.php" enctype="multipart/form-data" onKeyUp="highlight(event)" onClick="highlight(event)"> <tr > <td height="20" colspan="5" nowrap><div align="center" class="style3"> <font color="#003366" face="Tahoma"><strong>วิทยาลัยการสาธารณสุขสิรินธร จังหวัดชลบุรี</strong></font></div></td> </tr> <tr > <td height="16" colspan="5" nowrap><div align="center" class="d style11"><font color="#003366" face="Tahoma">29 ม.4 ต. บ้านสวน อ. เมือง จ. ชลบุรี 20000 โทร 038-275663-5 ต่อ 160 </font></div></td> </tr> <tr> <td nowrap> </td> <td height="100%" nowrap> </td> <td bordercolor="#CCCCCC"> </td> <td> </td> <td> </td> </tr> <tr> <td width="6%" nowrap class="style11"><span class="style11"></span></td> <td width="57%" height="100%" nowrap class="style11"><div align="left" class="style19"><font color="#000066">เลขที่บัตร HN <font color="#000000"><font color="#000000"> <?php echo"$rs[HN_code]"; ?> </font></font></font></div></td> <td width="5%" bordercolor="#CCCCCC" class="style11"><div align="left"><span class="style18"><span class="style11"><span class="style11"></span></span></span></div></td> <td width="32%" class="style19"><font color="#003366">เลขที่ NO </font><font color="#000000"><font color="#000000"> <?php echo"$rs[No_code]"; ?> </font></font></td> <td width="0%"><span class="style17"><font color="#000000" size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"> <font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"> </font></strong></font> <font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"> </font></strong></font> </font></strong></font></span></td> </tr> <tr> <td nowrap class="style11"><span class="style11"></span></td> <td nowrap class="style11"><font color="#003366">เลขที่บัตรประชาชน</font> <font color="#003366"> <?php $Person_code = $rs["Person_code"]; $sql = "Select * From personal_den_tb Where Person_code='$Person_code'"; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Citizen_id] "; ?> </td> <td class="style11"><span class="style11"></span></td> <td nowrap class="style11"><font color="#003366">วันที่ </font><font color="#003366"> <?php $sday = $rs[Date]; $yearthai = explode("-",$sday); $day = intval($yearthai[2]); $month = intval($yearthai[1]); $year = intval($yearthai[0]); ////////////////// // $yearthai = $day ; $m = getThaiSubMonth($month); echo"$day"." "."$m"." "."$year"; ?></td> <td nowrap> </td> </tr> <tr> <td nowrap class="style11"><span class="style11"></span></td> <td nowrap class="style11"><div align="left" class="style19"><font color="#003366">ชื่อ</font><font color="#000066">- สกุล <font color="#000000"><?php $Person_code = $rs["Person_code"]; $sql = "Select * From personal_den_tb Where Person_code='$Person_code'"; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[First_name] $rss[Name] $rss[Lastname]"; ?> </font></font></div></td> <td class="style11"><div align="left"></div></td> <td nowrap class="style11"> </td> <td nowrap> </td> </tr> <tr> <td nowrap class="style11"> </td> <td height="100%" nowrap class="style19"><font color="#000066">ที่อยู่ <font color="#000000"> <?php $Person_code = $rs["Person_code"]; $sql = "Select * From personal_den_tb Where Person_code='$Person_code'"; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Address] "; ?> <font color="#000000"> <?php $ProvinceId = $rss["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 class="style11"> </td> <td nowrap bordercolor="#CCCCCC" class="style11"> </td> <td nowrap bordercolor="#CCCCCC"> </td> </tr> <tr> <td nowrap class="style11"> </td> <td height="100%" nowrap class="style11"><div align="left" class="style19"><font color="#003366">สถานพยาบาลผู้ประกันตน </font><font color="#000000"><font color="#000000"> <?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></font><font color="#003366" face="Tahoma"> <label> </label> สถานะคนไข้ <label> <input name="Roug" type="radio" value="1" <?php if (!(strcmp("$rs[Roug]","1"))){echo "checked";} ?> /> </label> คนไข้นอก <input name="Roug" type="radio" value="2"<?php if (!(strcmp("$rs[Roug]","2"))){echo "checked";} ?> /> คนไข้ใน</font></div></td> <td class="style11"><div align="center"></div></td> <td nowrap bordercolor="#CCCCCC" class="style11"> </td> <td nowrap bordercolor="#CCCCCC"> </td> </tr> <tr> <td nowrap bordercolor="#CCCCCC" class="style11"> </td> <td height="100%" nowrap bordercolor="#CCCCCC" class="style11"><div align="left" class="style19"><font color="#003366">ทันตแพทย์ผู้รักษา</font> <font color="#000000"><span class="style6"><?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] เลขที่ใบประกอบโรคศิลป์ $rss[Gover_id]"; ?> </span> </font></div></td> <td bordercolor="#CCCCCC" class="style11"><div align="center"> </div></td> <td nowrap class="style11"> </td> <td nowrap> </td> </tr> <tr> <td nowrap> </td> <td nowrap><div align="center"></div></td> <td><div align="center"></div></td> <td nowrap> </td> <td nowrap> </td> </tr> <tr bgcolor="#B6D0F1"> <td height="19" colspan="5" nowrap background=""><div align="center"> <table width="100%" border="0" cellpadding="0" cellspacing="0" style="border:0px solid gray"> <tr bgcolor="#FFFFFF" > <td colspan="7" bgcolor="#999999"><div align="center"><font color="#003366" size="4" face="Tahoma"><strong> <?php $sql2= "Select * From account Where No_code='$No_code' Order By No_code ASC "; $result2 = mysql_query($sql2) or die(" Error").mysql_error(); $num = mysql_num_rows($result2); /////////////////////////////////////////////////////////////////////////////////// ?> </strong></font><font color="#003366" face="Tahoma"><span class="style23">รายละเอียด</span></font></div></td> </tr> <tr bgcolor="#EEEEEE"> <td width="28" align="center" style="border:0px solid gray"><div align="center"><font color="#003366" face="Tahoma" class="d style4"><span class="style21"> No</span><strong>.</strong></font></div></td> <td width="67" align="center" style="border:0px solid gray"><span class="style11"><font color="#003366" face="Tahoma">ซี่ฟัน</font></span></td> <td width="273" align="center" style="border:0px solid gray"><font color="#000000" face="Tahoma" class="style11">รายการรักษา</font></td> <td width="46" align="center" style="border:0px solid gray"><span class="style11"><font color="#003366" face="Tahoma">ด้าน</font></span></td> <td width="47" align="center" style="border:0px solid gray"><span class="style11"><font color="#003366" face="Tahoma">จำนวน</font></span> </td> <td width="63" align="center" style="border:0px solid gray"><span class="style11"><font color="#003366" face="Tahoma">ค่ารักษา</font></span></td> <td width="73" align="center" style="border:0px solid gray"><div align="right"><span class="style11"><font color="#003366" face="Tahoma">จำนวนเงิน</font></span></div></td> </tr> <? $i = 1; while($row = mysql_fetch_array($result2)) {
if($count==0) { ?> <tr bgcolor="#FFFFFF" onMouseOver="this.style.backgroundColor='#D8F8FA'" onMouseOut="this.style.backgroundColor='#FDFAEE'" > <td align="center" > <font color="#000000" size="2" face="Tahoma"> <? $no = ($Per_Page * ( $Page -1))+$i ; echo $no; ?> </font> </td> <td align="center" ><font size="2" face="Tahoma"><span class="d style3"> <font size="2" face="Tahoma"><font size="2" face="Tahoma"> <?php $Tooth_code = $row["Tooth_code"]; $sql= "Select * From tooth_tb Where Tooth_code='$Tooth_code'"; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss= mysql_fetch_array($result1); echo "$rss[Description_1] "; ?> </font></font> </span></font></td> <td align="center" bgcolor="#FFFFFF" ><div align="left"><font size="2" face="Tahoma"><span class="d style3"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"> <font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"> <?php $Teach_code = $row["Teach_code"]; $sql = "Select * From treatment_tb Where Teach_code ='$Teach_code' "; $result = mysql_query($sql) or die("Error".mysql_error()); $rss= mysql_fetch_array($result); echo "$rss[Description_2] "; ?> </font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font> </font></font></font></font></span><font size="2" face="Tahoma"><span class="d style3"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"> <?php $Teach_code = $row["Teach_code"]; $sql = "Select * From treatment_tb Where Teach_code ='$Teach_code' "; $result = mysql_query($sql) or die("Error".mysql_error()); $rss= mysql_fetch_array($result); echo "$rss[Description_1] "; ?> </font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></span></font></font></div> <div align="left"> </div></td> <td align="center" ><font size="2" face="Tahoma"><span class="d style3"><font color="#003333" size="2" face="Tahoma"> <?=$row["Percen"]?> </font></span></font></td> <td align="center" bgcolor="#FFFFFF" ><font size="2" face="Tahoma"><span class="d style3"><font color="#003333" size="2" face="Tahoma"> <?=$row["Mount"]?> </font></span></font></td> <td align="center" ><div align="right"><font size="2" face="Tahoma"><span class="d style3"><font color="#003333" size="2" face="Tahoma"> <?=$row["Price"]?> </font></span></font></div></td> <td align="center" bgcolor="#FFFFFF" ><div align="right"><font size="2" face="Tahoma"><span class="d style3"> <font color="#993333" size="2" face="Tahoma"><?echo number_format($row['Cost_total'],2,'.',','); ?></font> </span></font> </div></td> </tr> <? $count=1; } else { ?> <tr bgcolor="#FFFFFF" onMouseOver="this.style.backgroundColor='#D8F8FA'" onMouseOut="this.style.backgroundColor='#FFFEF4'"> <td align="center" > <font color="#000000" size="2" face="Tahoma"> <? $no = ($Per_Page * ( $Page -1))+$i ; echo $no; ?> </font> </td> <td align="center" ><font size="2" face="Tahoma"><span class="d style3"> <font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"> <?php $Tooth_code = $row["Tooth_code"]; $sql= "Select * From tooth_tb Where Tooth_code='$Tooth_code'"; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss= mysql_fetch_array($result1); echo "$rss[Description_1] "; ?> </font></font></font> </span></font></td> <td align="center" bgcolor="#FFFFFF" ><div align="left"><font size="2" face="Tahoma"><span class="d style3"><font size="2" face="Tahoma"><font size="2" face="Tahoma"> <font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"> <?php $Teach_code = $row["Teach_code"]; $sql = "Select * From treatment_tb Where Teach_code ='$Teach_code' "; $result = mysql_query($sql) or die("Error".mysql_error()); $rss= mysql_fetch_array($result); echo "$rss[Description_2] "; ?> </font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font> </font></font></span><font size="2" face="Tahoma"><span class="d style3"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><font size="2" face="Tahoma"> <?php $Teach_code = $row["Teach_code"]; $sql = "Select * From treatment_tb Where Teach_code ='$Teach_code' "; $result = mysql_query($sql) or die("Error".mysql_error()); $rss= mysql_fetch_array($result); echo "$rss[Description_1] "; ?> </font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></span></font></font></div> <div align="left"> </div></td> <td align="center" ><font size="2" face="Tahoma"><span class="d style3"><font color="#003333" size="2" face="Tahoma"> <?=$row["Percen"]?> </font></span></font></td> <td align="center" bgcolor="#FFFFFF" ><font size="2" face="Tahoma"><span class="d style3"><font color="#003333" size="2" face="Tahoma"> <?=$row["Mount"]?> </font></span></font></td> <td align="center" ><div align="right"><font size="2" face="Tahoma"><span class="d style3"><font color="#003333" size="2" face="Tahoma"> <?=$row["Price"]?> </font></span></font></div></td> <td align="center" bgcolor="#FFFFFF" ><div align="left" class="style6"> <div align="right"><font size="2" face="Tahoma"><font size="2" face="Tahoma"><span class="d style3"><font color="#993333" size="2" face="Tahoma"><?echo number_format($row['Cost_total'],2,'.',','); ?></font></span> </font></font> </div> </div></td> </tr> <? $count=0; } $i++; }
?> <tr bgcolor="#FFFFFF"> <td colspan="7" align="center"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="57%"><div align="right"><font color="#0033CC" size="2" face="Tahoma"><strong> </strong></font><font color="#0033CC" face="Tahoma"><span class="style11"> <font color="#993333"> ราคารวมทั้งหมด</font></span></font></div></td> <td width="12%"><div align="center"> </div></td> <td width="16%"><div align="center"> </div></td> <td><div align="right"><font color="#993333" size="2" face="Tahoma"><strong><font color="#993333" size="2" face="Tahoma"> <?php $sql3 = "Select Sum(Cost_total) as Sum From account Where No_code='$No_code' "; $result3 = mysql_query($sql3) or die("Error".mysql_error()); $rss3 = mysql_fetch_array($result3); echo number_format($rss3['Sum'],2,'.',','); CloseDB(); ?> </font></strong> </font></div> <div align="right"> </div></td> </tr> </table></td> <tr> <td colspan="7" align="center"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr bgcolor="#FFFFFF"> <td> </td> <td> </td> <td> </td> <td width="2%"> </td> </tr> <tr bgcolor="#FFFFFF"> <td width="57%" bgcolor="#FFFFFF"><div align="left"> <font color="#0033CC" size="2" face="Tahoma"><strong> </strong></font></div></td> <td width="8%"><div align="center"> </div></td> <td width="33%"><div align="center"><font color="#993333" face="Tahoma"><span class="style11">ลงชื่อผู้รับเงิน ...</span></font><font color="#993333" size="2" face="Tahoma">.................. </font></div></td> <td><div align="right"> </div> <div align="right"> </div></td> </tr> </table></td> <tr bgcolor="#AFCFEF"> <td colspan="7" align="center" bgcolor="#FFFFFF"><div align="center" class="style22"><span class="style11"><font face="Tahoma">ทั้งหมด <? echo $num ?> รายการ </font></span><font size="2" face="Tahoma"> </font> </div></td> </table> </div></td> </tr> </form> </table> </body> </html> <?php } else { echo"<body bgcolor=\"#CCCCCC\">"; echo"<meta http-equiv=\"refresh\" content=\"3;URL=../login.php\" target=\"mainFrame\">\n"; echo"<center>"; echo"<br><br><br><b><font face=\"Tahoma\" size=\"4\" color=\"#FF0000\">Please Login</font> </b><br>"; echo"<br><br><font face=\"Tahoma\" size=\"10\" color=\"#000000\"> ERROR 404 PERMISION DENY</font><br>"; echo"<br><font face=\"Tahoma\" size=\"4\" color=\"#000000\"> คุณไม่มสิทธ์ใช้งาน</font>"; echo"</center>"; echo"</body>"; } ?>
|