Viewing file: TrainingDetail.php (9.66 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php include("../include/FunctionDB.php"); include("../include/Function.php");
ConnectDB(); $sql = "Select * From personal_tb as t,training_tb as r Where t.Teacher_code = r.Teacher_code and r.Training_code='$Training_code'"; $result = mysql_query($sql) or die(" Error").mysql_error(); $rs = mysql_fetch_array($result) ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Training Detail</title> <meta http-equiv="Content-Type" content="text/html; charset=tis-620"> <link href="./source/style.css" rel="stylesheet" type="text/css"> <table width="87%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <th width="868" scope="col"><form name="form1" method="post" action=""> <table width="85%" border="0" cellpadding="0" cellspacing="0" bgcolor="#F7F7F7" ; border:1px solid gray"size="12"> <!--DWLayoutTable--> <tr> <td height="35" colspan="3" bgcolor="#D2F49F"><div align="center"><font color="#000000" size="4" face="Tahoma"><strong>แสดงรายละเอียดการพัฒนาบุคลากร</strong></font></div></td> </tr> <tr> <td width="159" height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma">ปี พ.ศ</font></td> <td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td> <td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"> <?php echo"$rs[Year_std]"; ?> </font></td> </tr> <tr> <td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma">ชื่อ-นามสกุล</font></td> <td nowrap bordercolor="#DDF8D1" bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td> <td nowrap bordercolor="#DDF8D1" bgcolor="#F7F7F7"><font color="#003399" size="2" face="Tahoma"> <?php echo"$rs[First_name]"; ?> <?php echo"$rs[Teacher_name]"; ?> <?php echo"$rs[Teacher_lastname]"; ?> </font></td> </tr> <tr> <td height="32" bgcolor="#FFFFFF"><div align="center" class="style1"> <div align="left"><font size="2" face="Tahoma">ชื่อเรื่อง</font></div> </div></td> <td bgcolor="#FFFFFF"> </td> <td bgcolor="#FFFFFF"><div align="left"><font color="#006633" size="2" face="Tahoma"> </font> <p> <label><font color="#003366" size="2" face="Tahoma"> </font></label> <font color="#996600" size="2" face="Tahoma"> <?php //$Project_code = $rss["Project_code"]; $sql = "Select * From training_tb Where Training_code='$Training_code'"; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[Training_name] "; ?> </font></strong> <label> </label> </p> </div></td> <td width="10" nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td> </tr> <tr> <td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma">ประเภท</font></td> <td width="3" nowrap bordercolor="#DDF8D1" bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td> <td width="573" nowrap bordercolor="#DDF8D1" bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td> </tr> <tr> <td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma">สาขาวิชา</font></td> <td width="3" nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td> <td width="573" nowrap bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"> <? echo $rs[Major]?> </font></td> </tr> <tr> <td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma">วันทีเริ่ม-วันที่สิ้นสุด</font></td> <td width="3" nowrap bordercolor="#DDF8D1" bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td> <td width="573" nowrap bordercolor="#DDF8D1" bgcolor="#F7F7F7"><font color="#003399" size="2" face="Tahoma"> <?php $sday = $rs[Date_start]; $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 color="#000000"> ถึง</font> <?php $sday = $rs[Date_finish]; $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></td> </tr> <tr> <td height="20" nowrap bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma">CNEU </font></td> <td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td> <td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"><? echo $rs[CNEU] ?></font></td> </tr> <tr> <td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma"> จำนวชั่วโมง</font></td> <td nowrap bordercolor="#DDF8D1" bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td> <td nowrap bordercolor="#DDF8D1" bgcolor="#F7F7F7"><font color="#003399" size="2" face="Tahoma"><? echo $rs[Total_hour] ?> </font><font size="2" face="Tahoma">ชั่วโมง</font><font color="#003399" size="2" face="Tahoma"> </font></td> </tr> <tr> <td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma">จำนวนเงินที่ใช้</font> </td> <td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td> <td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"> <? echo number_format($rs['Fund'],2,'.',','); ?> </font><font size="2" face="Tahoma">บาท</font><font color="#003399" size="2" face="Tahoma"> </font></td> </tr> <tr> <td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma">แหล่งเงินสนับสนุน</font></td> <td nowrap bordercolor="#DDF8D1" bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td> <td nowrap bgcolor="#F7F7F7"><font color="#003399" size="2" face="Tahoma"><? echo $rs[Fund_resource] ?></font></td> </tr> <tr> <td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma">หน่วยงานที่จัด</font></td> <td nowrap bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td> <td nowrap bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"><? echo $rs[Organiz] ?></font></td> </tr> <tr> <td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma">สถานที่</font></td> <td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td> <td nowrap bgcolor="#F7F7F7"><font color="#003399" size="2" face="Tahoma"><? echo $rs[Place] ?> <? echo $rs[Place_des] ?></font></td> </tr> <tr> <td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"> วันที่ส่งรายงาน</font></td> <td nowrap bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td> <td nowrap bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"> <?php $sday = $rs[Date_send]; $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></td> </tr> <tr> <td height="20" nowrap bordercolor="#D8D2A9" background="#F7F7F7"><font color="#000000" size="2" face="Tahoma">เวลาที่เผยแพร่ในหน่วยงาน</font></td> <td nowrap background="#F7F7F7"><!--DWLayoutEmptyCell--> </td> <td nowrap background="#F7F7F7"><font color="#003399" size="2" face="Tahoma"> <?php switch ($rs[Period_prop]) { case 1 : echo"<font color=\"#003399\">น้อยกว่า 2 สัปดาห์ </font>";break; case 2 : echo"<font color=\"#006633\">2 สัปดาห์</font>";break; case 3 : echo"<font color=\"#333333\">มากกว่า 4 สัปดาห์</font>";break; } ?> </font></td> </tr> <tr> <td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma">การประยุกต์นำไปใช้งาน</font></td> <td nowrap bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td> <td nowrap bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"><? echo nl2br($rs[Apply]) ?></font></td> </tr> <tr> <td height="20" colspan="3" bgcolor="#D2F49F"><div align="center"><br> <input type="button" name="close2" value="ปิดหน้าต่าง" onClick="window.close()"> </p> </div> <p align="center"> </p></td> </tr> </table> </form> </th> </tr> </table> <p> </p> </body> </html>
|