Viewing file: Planteachdetail.php (31.17 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 rel="stylesheet" href="../../css/style1.css"type="text/css">
<link href="../../css/style1.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style3 {font-size: 18px}
.style4 {font-size: 12px}
.style6 {color: #003333}
.style10 {font-weight: bold}
.style11 {font-size: 14px}
.style12 {
color: #000000;
font-weight: bold;
}
.style13 {font-size: 18px; text-decoration: none; }
.style15 {
font-weight: bold;
color: #000000;
}
.style17 {font-weight: bold}
-->
</style>
<table width="78%" 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="48" colspan="5" nowrap><div align="center"> <font color="#003366" size="4" face="Tahoma"><strong>ศูนย์ทันตกรรมวิทยาลัยการสาธารณสุขสิรินธร จังหวัดชลบุรี</strong></font></div></td>
</tr>
<tr >
<td height="28" 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="9%" nowrap> </td>
<td width="49%" height="100%" nowrap><div align="left"><font color="#000066" size="2" face="Tahoma"><strong>เลขที่บัตร</strong> <span class="style17"><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[HN_code]";
?>
</font></strong></font></span></font></div></td>
<td width="14%" bordercolor="#CCCCCC"><div align="left"></div></td>
<td width="28%"><font color="#003366" size="2" face="Tahoma"><strong>เลขที่ </strong> <span class="style17"><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">
<?php
echo"$rs[No_code]";
?>
</font></strong></font></font></strong></font></span></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> </td>
<td nowrap><strong><font color="#003366" size="2" face="Tahoma">เลขที่บัตรประจำตัวประชาชน</font><font size="2" face="Tahoma"> </font></strong><span class="style12"><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"><span class="style13"><font size="2" face="Tahoma">
<?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] ";
?>
</font></span></font></font></font></font></font></font></span><font size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><span class="d style3"><font size="2" face="Tahoma"> </font></span></font></strong></font></strong></font></strong></font></strong></font></strong></font></td>
<td> </td>
<td nowrap><strong><font color="#000066" size="2" face="Tahoma">วันที่</font></strong><span class="style12"><font size="2" face="Tahoma"> </font></span><span class="style15"><font size="2" face="Tahoma">
<?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";
?>
</font><font size="2" face="Tahoma"> </font></span></td>
<td nowrap> </td>
</tr>
<tr>
<td nowrap> </td>
<td nowrap><div align="left"><span class="style10"><font color="#003366" size="2" face="Tahoma">ชื่อ</font> </span><font size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"><span class="d style3"><font color="#000066" size="2" face="Tahoma"></font></span><strong><strong><strong><strong><strong><span class="d style3"><font color="#000066" size="2" face="Tahoma">- สกุล </font><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><font size="2" face="Tahoma">
<?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></strong></font></strong></font></strong></font></strong></font> </span></strong></strong></strong></strong></strong></font></font></font></font></font></font></div></td>
<td><div align="left"></div></td>
<td nowrap> </td>
<td nowrap><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"> <strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><span class="d style3"><font size="2" face="Tahoma"> </font></span></font></strong></font></strong></font></strong></font></strong> </font></strong></font></td>
</tr>
<tr>
<td nowrap> </td>
<td height="100%" nowrap><font color="#000066" size="2" face="Tahoma"><strong>ที่อย</strong>ู่ </font><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><span class="d style3"><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><font size="2" face="Tahoma">
<?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><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><font size="2" face="Tahoma">
<?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></font></strong></font></strong></font></strong></font></strong></font></font></strong></font></strong></font></strong></font></strong></font></strong></font><font size="2" face="Tahoma"> </font></font></strong></font></strong></font></strong></font></strong></font></span></font></strong></font></strong></font></strong></font></strong></font></strong></font></td>
<td> </td>
<td nowrap bordercolor="#CCCCCC"> </td>
<td nowrap bordercolor="#CCCCCC"> </td>
</tr>
<tr>
<td nowrap> </td>
<td height="100%" nowrap><div align="left"><strong><font color="#003366" size="2" face="Tahoma">สถานพยาบาลผู้ประกันตน </font></strong><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"><strong><strong><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"><strong><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><span class="d style3"><font size="2" face="Tahoma">
<?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[Hostpital] ";
?>
</font></span></font></strong></font></strong></font></strong></font></strong></strong></font></font></strong></strong></font></font></div></td>
<td><div align="center"></div></td>
<td nowrap bordercolor="#CCCCCC"> </td>
<td nowrap bordercolor="#CCCCCC"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"><strong><strong><font color="#000000" size="2" face="Tahoma"> <font color="#000000" size="2" face="Tahoma"><strong><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><span class="d style3"><font size="2" face="Tahoma">
</font></span></font></strong></font></strong></font></strong></font></strong></strong></font> </font></strong></strong></font></font></td>
</tr>
<tr>
<td nowrap bordercolor="#CCCCCC"> </td>
<td height="100%" nowrap bordercolor="#CCCCCC"><div align="left"><strong><font color="#003366" size="2" face="Tahoma">ทันตแพทย์ผู้รักษา</font></strong> <font size="2" face="Tahoma"><span class="style4"><font size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><span class="d style3"><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><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"><span class="style6"><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
$Teacher_code = $rss["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]";
?>
</font></font></font></font> </font></font></font></span></font></font></font></font></font> </font></font></strong></font></strong></font></strong></font></strong></font></span></font></strong></font></strong></font></strong></font></strong></font></strong></font></span></font></div></td>
<td bordercolor="#CCCCCC"><div align="center"><font color="#FF0000" size="3" face="Tahoma"> </font></div></td>
<td nowrap> </td>
<td nowrap><font color="#003366" size="2" face="Tahoma">
</font><font color="#000000" size="2" face="Tahoma, MS Sans Serif"> </font></td>
</tr>
<tr>
<td nowrap> </td>
<td nowrap><div align="center"></div></td>
<td><div align="center"></div></td>
<td nowrap> </td>
<td nowrap><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"> <strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><span class="d style3"><font size="2" face="Tahoma">
</font></span></font></strong></font></strong></font></strong><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"> </font></strong></font></strong></font></strong></font></td>
</tr>
<tr bgcolor="#B6D0F1">
<td height="19" colspan="5" nowrap background=""><div align="center">
<table width="100%" border="0" cellpadding="0" cellspacing="1" style="border:1px solid gray">
<tr bgcolor="#FFFFFF" >
<td colspan="8"><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></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td width="30" align="center" style="border:1px solid gray"><div align="center"><font color="#003366" face="Tahoma" class="d style4"><strong> No.</strong></font></div></td>
<td width="81" align="center" style="border:1px solid gray"><font color="#003366" size="2" face="Tahoma">ซี่ฟัน</font></td>
<td colspan="2" align="center" style="border:1px solid gray"><font color="#000000" size="2" face="Tahoma"><b>รายการรักษา</b></font></td>
<td width="42" align="center" style="border:1px solid gray"><font color="#003366" size="2" face="Tahoma">จำนวน</font> </td>
<td width="66" align="center" style="border:1px solid gray"><font color="#003366" size="2" face="Tahoma">ค่ารักษา</font></td>
<td width="62" align="center" style="border:1px solid gray"><font color="#003366" size="2" face="Tahoma">ส่วนลด % </font></td>
<td width="68" align="center" style="border:1px solid gray"><font color="#003366" size="2" face="Tahoma">จำนวนเงิน</font></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="#003366" size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma">
<?
$no = ($Per_Page * ( $Page -1))+$i ;
echo $no;
?>
</font><font color="#003366" size="2" face="Tahoma"> </font></td>
<td align="center" ><font size="2" face="Tahoma"><span class="d style3"><font color="#003333" size="2" face="Tahoma"> </font><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 color="#003333" size="2" face="Tahoma"> </font></span></font></td>
<td width="176" 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></div></td>
<td width="221" align="center" bgcolor="#FFFFFF" ><div align="left"><font color="#990099" size="2" face="Tahoma"> <a href="Historydetail.php?Person_code=<?=$row["Person_code"]?>" title="Click to see Detail"> </a></font><font color="#990099" size="2" face="Tahoma"><a href="Historydetail.php?Person_code=<?=$row["Person_code"]?>" title="Click to see Detail" class="d"> </a></font><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></font> </font> </font></span></font><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">
<?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></span></font><font color="#003366" size="2" face="Tahoma"> </font></div></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" ><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" ><div align="right"><font size="2" face="Tahoma"><span class="d style3"><font color="#003333" size="2" face="Tahoma"> </font><font color="#993333" size="2" face="Tahoma"><?echo number_format($row['Cost_total'],2,'.',','); ?></font><font color="#003333" size="2" face="Tahoma"> </font><font size="2" face="Tahoma"> </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="#003366" size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma">
<?
$no = ($Per_Page * ( $Page -1))+$i ;
echo $no;
?>
</font><font color="#003366" size="2" face="Tahoma"> </font></td>
<td align="center" ><font size="2" face="Tahoma"><span class="d style3"><font color="#003333" size="2" face="Tahoma"> </font><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><font color="#003333" size="2" face="Tahoma"> </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></div></td>
<td align="center" bgcolor="#FFFFFF" ><div align="left"><font color="#990099" size="2" face="Tahoma"><a href="Historydetail.php?Person_code=<?=$row["Person_code"]?>" title="Click to see Detail" class="d"> </a></font><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">
<?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></font></span></font></div></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" ><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" ><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="8" 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> <font color="#993333"> ราคารวมทั้งหมด</font></strong></font></div></td>
<td width="12%"><div align="center"><font color="#993333" size="2" face="Tahoma"> </font></div></td>
<td width="16%"><div align="center"><font color="#993333" size="2" face="Tahoma"> </font></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"><strong><font color="#993333" size="2" face="Tahoma"> </font><font color="#993333" size="2" face="Tahoma"> </font></strong></div></td>
</tr>
</table></td>
<tr>
<td colspan="8" 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 size="2" face="Tahoma"><span class="style4"><font size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><span class="d style3"><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font color="#000000" size="2" face="Tahoma"><strong><font size="2" face="Tahoma"><font size="2" face="Tahoma"> </font></font></strong></font></strong></font></strong></font></strong></font></span></font></strong></font></strong></font></strong></font></strong></font></strong></font></span></font><font color="#0033CC" size="2" face="Tahoma"><strong> </strong></font></div></td>
<td width="8%"><div align="center"><font color="#993333" size="2" face="Tahoma"> </font></div></td>
<td width="33%"><div align="center"><font color="#993333" size="2" face="Tahoma">ลงชื่อผู้รับเงิน ..................... </font></div></td>
<td><div align="right"><font color="#993333" size="2" face="Tahoma"><strong><font color="#993333" size="2" face="Tahoma"> </font></strong> </font></div>
<div align="right"><strong><font color="#993333" size="2" face="Tahoma"> </font><font color="#993333" size="2" face="Tahoma"> </font></strong></div></td>
</tr>
</table></td>
<tr bgcolor="#AFCFEF">
<td colspan="8" align="center"><div align="center"><font color="#003366" size="2" face="Tahoma">ทั้งหมด</font><font color="#FFFFFF" size="2" face="Tahoma"> <? echo $num ?> <font color="#003366">รายการ</font> </font> </div></td>
</table>
<font color="#003333" size="2" face="Tahoma"> </font></div></td>
</tr>
</form>
</table>
<p> </p>
<p> </p>
<p> </p>
</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>";
}
?>
|