Viewing file: ManDetail.php (10.85 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("./include/FunctionDB.php");
include("./include/Function.php");
ConnectDB();
$sql = "Select * From manament_tb Where code='$code'";
$result = mysql_query($sql) or die(" Error").mysql_error();
$rs = mysql_fetch_array($result)
?>
<html>
<head>
<title>ข้อมูลแผนดำเนินการ</title>
<link href="./source/style.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<style type="text/css">
<!--
.style1 {
color: #000000;
font-weight: bold;
font-size: 14px;
}
.style2 {font-size: 14px}
.style2 {font-family: Tahoma}
-->
</style>
</head>
<table width="741" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="741" ><form id="form1" name="form1" method="post" action="">
<fieldset>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#eeeeee" style="border:0px solid gray"size="12">
<tr bgcolor="#6699CC">
<td height="26" colspan="4" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#6699CC">
<td height="26" colspan="4" bgcolor="#FFFFFF"><div align="center" class="style1"><font face="Tahoma">แสดงรายละเอียด</font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td width="186" height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">วันที่แจ้งซ่อม </font></div></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><div align="left"><strong><font color="#000000" size="2" face="Tahoma"> </font><font color="#003366" size="2" face="Tahoma">
<?php
$sday = $rs[Date_buy];
$yearthai = explode("-",$sday);
$day = intval($yearthai[2]);
$month = intval($yearthai[1]);
$year = intval($yearthai[0]);
//////////////////
// $yearthai = $day ;
// $month = TxtThaiMonth($month);
echo"$day"."/"."$month"."/"."$year";
?>
</font><font color="#000000" size="2" face="Tahoma"> </font></strong></div></td>
<td width="211" rowspan="16" valign="top" nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><strong><font color="#000000" size="2" face="Tahoma"> </font><font color="#003366" size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma"> </font></strong> <strong><font color="#000000" size="2" face="Tahoma"> </font></strong> <font color="#000000" size="2" face="Tahoma"> </font><font color="#003366" size="2" face="Tahoma"> </font><font color="#003366" size="2" face="Tahoma"> </font> <font color="#000000" size="2" face="Tahoma"> </font>
<?php
echo"<center>";
echo"<img src=\"$rs[Img1]\" width=\"200\" height=\"150\" >";
echo"</center>";
?></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">ชื่ออุปกรณ์/ยี่ห้อ</font></div></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><div align="left"><strong><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Acc_name]";
?>
</font></strong></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">ชนิดของอุปกรณ์</font></div></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><div align="left"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Status] ?></font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">รายการ</font></div></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td bgcolor="#FFFFFF" ><div align="left"><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Acc_code])?> </font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">สถานที่อุปกรณ์</font></div></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td bgcolor="#FFFFFF" ><font color="#000000" size="2" face="Tahoma"><? echo nl2br($rs[Store])?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">ประวัติการซ่อม</font></div></td>
<td width="2" bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td width="600" bgcolor="#FFFFFF" ><div align="left"><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Fix_History])?> </font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">สาเหตุอาการ</font></div></td>
<td width="2" bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td width="600" bordercolor="#DDF8D1" bgcolor="#FFFFFF"><div align="left"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Contact]?></font><font color="#003366" size="2" face="Tahoma"> </font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bgcolor="#FFFFFF" ><div align="center"><font size="2" face="Tahoma">วันที่ซ่อมเสร็จ</font></div></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><div align="left"><font color="#003366" size="2" face="Tahoma">
<?php
$sday = $rs[Date_year];
$yearthai = explode("-",$sday);
$day = intval($yearthai[2]);
$month = intval($yearthai[1]);
$year = intval($yearthai[0]);
//////////////////
// $yearthai = $day ;
// $month = TxtThaiMonth($month);
echo"$day"."/"."$month"."/"."$year";
?>
</font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">ราคา</font></div></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><div align="left"><font color="#993333" size="2" face="Tahoma"> <?echo number_format($rs['Price'],2,'.',','); ?></font><font color="#000000" size="2" face="Tahoma"> บาท </font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font color="#003366" size="2" face="Tahoma"> </font><font size="2" face="Tahoma">งบประมาณการซ่อมแซม</font></div></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><div align="left"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Fix_budget] ?> บาท </font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">สถานะการใช้งาน</font></div></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><div align="left"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Status_1] ?></font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">สถิติการใช้งาน</font> </div></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td bgcolor="#FFFFFF" ><div align="left"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Statistic] ?></font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">บันทึกซ่วยจำ</font></div></td>
<td bgcolor="#FFFFFF" ><!--DWLayoutEmptyCell--> </td>
<td bgcolor="#FFFFFF" ><div align="left"><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Description]) ?></font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">นักศึกษาผู้แจ้ง</font></div></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><div align="left"><font color="#000000" size="2" face="Tahoma">
<?php
$Student_id = $rs[Student_id];
$sql2= "Select * From student_tb Where Student_id='$Student_id' ";
$result2 = mysql_query($sql2) or die("Error Select".mysql_query());
$rs2 = mysql_fetch_array($result2);
echo"$rs2[Name] $rs2[Lastname]";
?>
</font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">อาจารย์ที่รับผิดชอบ</font></div></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><div align="left"><font color="#000000" 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[Teacher_name] $rss[Teacher_lastname]";
?>
</font><font color="#336600" size="2" face="Tahoma"> </font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="29" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma">บันทึกซ่วยจำ</font></div></td>
<td bgcolor="#FFFFFF" ><!--DWLayoutEmptyCell--> </td>
<td bgcolor="#FFFFFF" ><div align="left"><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Description]) ?></font></div></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="26" colspan="4" bgcolor="#FFFFFF"><div align="center">
<input type="button" name="close22" value="ปิดหน้าต่าง" onClick="window.close()">
</div></td>
</tr>
</table>
</fieldset> </p>
</form>
</tr>
</table>
</body>
</html>
|