Viewing file: PlanteachDetail.php (32.04 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php session_start(); //$valid_user = $_session['valid_user']; //$password = $_session['password']; //$priority = $_session['priority']; if (session_is_registered("valid_user")&&session_is_registered("Priority")&&session_is_registered("password") ) { include("../include/FunctionDB.php"); include("../include/Function.php"); include("admin_menu.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); ?> <meta http-equiv="Content-Type" content="text/html; charset=TIS-620"> <style type="text/css"> <!-- .style11 {font-size: 14px} .style13 {font-size: 18px; text-decoration: none; } .style17 {font-weight: bold} .style3 {font-size: 18px} .style4 {font-size: 12px} .style6 {color: #003333} .style19 {color: #000000} --> </style> <table width="818" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="818"><br> <fieldset> <legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="menu_teacher.php " >หน้าหลัก</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle">ข้อมูลรายรับ</font></legend> <label><div align="center"> <form id="form1" name="form1" method="post" action=""> <table width="85%" border="0" align="center" cellpadding="0" cellspacing="0" style="border:1px solid gray"> <tr > <td height="48" colspan="5" nowrap="nowrap"><div align="center"> <font color="#003366" size="4" face="Tahoma"><strong>ศูนย์ทันตกรรมวิทยาลัยการสาธารณสุขสิรินธร จังหวัดชลบุรี</strong></font></div></td> </tr> <tr > <td height="28" colspan="5" nowrap="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="nowrap"> </td> <td height="100%" nowrap="nowrap"> </td> <td bordercolor="#CCCCCC"> </td> <td> </td> <td> </td> </tr> <tr> <td width="9%" nowrap="nowrap"> </td> <td width="49%" height="100%" nowrap="nowrap"><div align="left"><font color="#000066" size="2" face="Tahoma">เลขที่บัตร <font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"> <?php echo"$rs[HN_code]"; ?> </font></font></font></div></td> <td width="14%" bordercolor="#CCCCCC"><div align="left"></div></td> <td width="28%"><font color="#003366" 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"> <?php echo"$rs[No_code]"; ?> </font></font></font></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="nowrap"> </td> <td nowrap="nowrap"><font color="#003366" size="2" face="Tahoma">เลขที่บัตรประจำตัวประชาชน</font> <span class="style19"><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> </td> <td> </td> <td nowrap="nowrap"><font color="#000066" size="2" face="Tahoma">วันที่</font> <span class="style19"><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> </span></td> <td nowrap="nowrap"> </td> </tr> <tr> <td nowrap="nowrap"> </td> <td nowrap="nowrap"><div align="left"><font color="#003366" size="2" face="Tahoma">ชื่อ</font> <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><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 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></font></font></font></font> </span></font></font></font></font></font></font></div></td> <td><div align="left"></div></td> <td nowrap="nowrap"> </td> <td nowrap="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="nowrap"> </td> <td height="100%" nowrap="nowrap"><font color="#000066" size="2" face="Tahoma">ที่อยู่ </font><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"><font size="2" face="Tahoma"><span class="d style3"><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 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 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"><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 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></font></font></font></font></font></font></font></font></font></font> </font></font></font></font></font></span></font></font></font></font></font></font></td> <td> </td> <td nowrap="nowrap" bordercolor="#CCCCCC"> </td> <td nowrap="nowrap" bordercolor="#CCCCCC"> </td> </tr> <tr> <td nowrap="nowrap"> </td> <td height="100%" nowrap="nowrap"><div align="left"><font color="#003366" size="2" face="Tahoma">สถานพยาบาลผู้ประกันตน </font><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"><font color="#000000" size="2" face="Tahoma"><font color="#000000" size="2" face="Tahoma"><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></font></font></font></font></font></font></font></div></td> <td><div align="center"></div></td> <td nowrap="nowrap" bordercolor="#CCCCCC"> </td> <td nowrap="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="nowrap" bordercolor="#CCCCCC"> </td> <td height="100%" nowrap="nowrap" bordercolor="#CCCCCC"><div align="left"><font color="#003366" size="2" face="Tahoma">ทันตแพทย์ผู้รักษา</font> <font size="2" face="Tahoma"><span class="style4"><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 size="2" face="Tahoma"><span class="d style3"><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 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></font></font></font></font></span></font></font></font></font></font></font></span></font></div></td> <td bordercolor="#CCCCCC"><div align="center"><font color="#FF0000" size="3" face="Tahoma"> </font></div></td> <td nowrap="nowrap"> </td> <td nowrap="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="nowrap"> </td> <td nowrap="nowrap"><div align="center"></div></td> <td><div align="center"></div></td> <td nowrap="nowrap"> </td> <td nowrap="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="nowrap" background=""><div align="center"> <table width="100%" border="0" cellpadding="0" cellspacing="1" style="border:0px 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="26" 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="45" 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="48" align="center" style="border:1px solid gray"><font color="#003366" size="2" face="Tahoma">จำนวน</font> </td> <td width="64" align="center" style="border:1px solid gray"><font color="#003366" size="2" face="Tahoma">ค่ารักษา</font></td> <td width="64" align="center" style="border:1px solid gray"><font color="#003366" size="2" face="Tahoma">ส่วนลด % </font></td> <td width="77" 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="151" 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="208" 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> <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> <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> </tr> </table> <font color="#003333" size="2" face="Tahoma"> </font></div></td> </tr> </table> </form> <br> <br> </div></label> </fieldset><br> <font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ<br> </font></td> </tr> </table> <?php } else { echo"<meta http-equiv=\"refresh\" content=\"3;URL=../login.php\">\n"; echo"Please Login "; } ?>
|