<?php
 
include("../include/FunctionDB.php");
include("../include/Function.php");

ConnectDB();

$sql =  " SELECT * FROM  projectStdPlan_tb   WHERE   Budget_Year='$Budget_Year'  AND  Faculty_code='$Faculty_code'  AND  Project_code='$Project_code' ";
$result = mysql_query($sql);
$rs = mysql_fetch_array($result);

?>

<html>
<head>
<title>ข้อมูลแผนดำเนินการ</title>
<link href="../css/default.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
</head>

<body>
<table width="560" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="10"></td>
  </tr>
</table>
<table width="560" border="0" align="center">
  <tr>
    <td width="554"><fieldset>
    <table width="96%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#E0E0E0">
      <tr bgcolor="#ECD9C6">
        <td height="5" colspan="2" bgcolor="#FFFFFF"></td>
      </tr>
      <tr bgcolor="#ECD9C6">
        <td height="25" colspan="2" bgcolor="#F0F0F0" align="center"><span class="TEXT-HEADER11-BLUE"><strong>แสดงรายละเอียดของแผนดำเนินการ</strong></span></td>
      </tr>
      <tr bgcolor="#EEEEEE">
        <td width="25%" height="10" bgcolor="#FFFFFF"></td>
        <td height="10" bordercolor="#006699" bgcolor="#FFFFFF"></td>
      </tr>
      <tr bgcolor="#F9F9F9">
        <td bgcolor="#F9F9F9">รหัสหน่วยงาน</td>
        <td bordercolor="#006699" bgcolor="#F9F9F9" class="PADDING-LEFT-5"><font color="#0033CC" size="2" face="Tahoma">
        <?php
            $Faculty_code =  $rs["Faculty_code"];
            $sql = " SELECT * FROM faculty_tb  WHERE Faculty_code='$Faculty_code' ";
            $result1 = mysql_query($sql);
            $rs1 = mysql_fetch_array($result1);
                echo "$rs1[Faculty_code]  - $rs1[Faculty_name]";
        ?></font></td>
      </tr>
      <tr bgcolor="#EEEEEE">
        <td bgcolor="#FFFFFF">รหัสของแผน</td>
        <td bordercolor="#006699" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#0033CC" size="2" face="Tahoma"><?php echo htmlspecialchars_decode( $rs['Orderlist'] ); ?></font></td>
      </tr>
      <tr bgcolor="#F9F9F9">
        <td bgcolor="#F9F9F9">แผนงานโครงการ</td>
        <td bordercolor="#006699" class="PADDING-LEFT-5"><font color="#0033CC" size="2" face="Tahoma"><?php echo htmlspecialchars_decode( nl2br( $rs['Project_plan'] ) ); ?></font></td>
      </tr>
      <tr>
        <td valign="top">วัตถุประสงค์</td>
        <td width="75%" valign="top" bordercolor="#006699" class="PADDING-LEFT-5"><font color="#0033CC" size="2" face="Tahoma"><?php echo htmlspecialchars_decode( nl2br( $rs['Orderlist_2'] ) ); ?></font></td>
      </tr>
      <tr bgcolor="#F9F9F9">
        <td valign="top" bgcolor="#F9F9F9">ตัวชี้วัดความสำเร็จ</td>
        <td valign="top" bordercolor="#006699" class="PADDING-LEFT-5"><font color="#0033CC" size="2" face="Tahoma"><?php echo htmlspecialchars_decode( nl2br( $rs['Project_name'] ) ); ?></font></td>
      </tr>
      <tr>
        <td valign="top">วิธีการดำเนินงาน</td>
        <td valign="top" bordercolor="#006699" class="PADDING-LEFT-5"><font color="#0033CC" size="2" face="Tahoma"><?php echo htmlspecialchars_decode( nl2br( $rs['Project_rep'] ) ); ?></font></td>
      </tr>
      <tr bgcolor="#F9F9F9">
        <td bgcolor="#F9F9F9">กลุ่มเป้าหมาย</td>
        <td bordercolor="#006699" class="PADDING-LEFT-5"><font color="#0033CC" size="2" face="Tahoma"><?php echo htmlspecialchars_decode( nl2br( $rs['Period'] ) ); ?></font></td>
      </tr>
      <tr bgcolor="#EEEEEE">
        <td bgcolor="#FFFFFF">ผลที่คาดว่าจะได้รับ</td>
        <td bordercolor="#006699" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#0033CC" size="2" face="Tahoma"><?php echo htmlspecialchars_decode( nl2br( $rs['Period_1'] ) ); ?></font></td>
      </tr>
      <tr bgcolor="#F9F9F9">
        <td bgcolor="#F9F9F9">หมวดเงิน</td>
        <td bordercolor="#006699" class="PADDING-LEFT-5"><font color="#000000" size="2" face="Tahoma">
        <?php
            $MoneyS_C  = $rs['MoneyS_C'];
            $sql3 = " SELECT * FROM  money_source_tb  WHERE  MoneyS_C='$MoneyS_C' ";
            $result3 = mysql_query($sql3);
            $rs3 = mysql_fetch_array($result3);
                echo $rs3["MoneyS_M"];
        ?></font></td>
      </tr>
      <tr bgcolor="#EEEEEE">
        <td bgcolor="#FFFFFF">ปีงบประมาณ พ.ศ.</td>
        <td bordercolor="#006699" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#0033CC" size="2" face="Tahoma"><?php echo $rs['Budget_Year']; ?></font></td>
      </tr>
      <tr bgcolor="#ECD9C6">
        <td bordercolor="#006699" bgcolor="#FFFFFF">&nbsp;</td>
        <td bordercolor="#006699" bgcolor="#FFFFFF">&nbsp;</td>
      </tr>
    </table>
    </fieldset>
    <br />
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td align="center"><input type="button" name="close" value="ปิดหน้าต่าง" onClick="window.close()" class="CURSOR-HAND WIDTH80" /></td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>
<?php
    CloseDB();
?>