Viewing file: ManDetail.php (9.09 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="10" colspan="4" bgcolor="#FFFFFF" align="center"></td>
</tr>
<tr bgcolor="#6699CC">
<td height="26" colspan="4" bgcolor="#F8F8F8" align="center"><span class="style1"><font face="Tahoma">แสดงรายละเอียด</font></span></td>
</tr>
<tr bgcolor="#EEEEEE">
<td width="170" height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">วันที่แจ้งซ่อม</font></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><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></strong></td>
<td width="147" rowspan="16" valign="top" nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF" align="center"><br>
<?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"><font size="2" face="Tahoma">ชื่ออุปกรณ์/ยี่ห้อ</font></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><strong><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Acc_name]";
?></font></strong></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">ชนิดของอุปกรณ์</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Status] ?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">รายการ</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" ><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Acc_code])?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">สถานที่อุปกรณ์</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </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"><font size="2" face="Tahoma">ประวัติการซ่อม</font></td>
<td width="10" bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td width="397" bgcolor="#FFFFFF" ><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Fix_History])?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">สาเหตุอาการ</font></td>
<td width="10" bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td width="397" bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Contact]?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bgcolor="#FFFFFF" ><font size="2" face="Tahoma">วันที่ซ่อมเสร็จ</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><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></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">ราคา</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#993333" size="2" face="Tahoma"> <? echo number_format($rs['Price'],2,'.',','); ?></font><font color="#000000" size="2" face="Tahoma"> บาท</font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">งบประมาณการซ่อมแซม</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Fix_budget] ?> บาท</font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">สถานะการใช้งาน</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Status_1] ?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">สถิติการใช้งาน</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" ><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Statistic] ?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">บันทึกซ่วยจำ</font></td>
<td bgcolor="#FFFFFF" > </td>
<td bgcolor="#FFFFFF" ><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Description]) ?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">นักศึกษาผู้แจ้ง</font></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><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></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">อาจารย์ที่รับผิดชอบ</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><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></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="29" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">บันทึกซ่วยจำ</font></td>
<td bgcolor="#FFFFFF" > </td>
<td bgcolor="#FFFFFF" ><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Description]) ?></font></td>
</tr>
</table>
</fieldset>
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="10"></td>
</tr>
</table>
<input type="button" name="Close" value="ปิดหน้าต่าง" onClick="window.close()" onMouseOver="this.style.cursor='hand'" />
</div>
</form>
</tr>
</table>
</body>
</html>
|