Viewing file: ResearchDetail.php (31.92 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
session_start();
/** Define Validate Access */
define( '_VALID_ACCESS', 1 );
/** Check Session User Login */
if( !session_is_registered("valid_user") && !session_is_registered("Priority") ) {
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
echo "<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";
echo "<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";
exit();
}
else {
/** Configuration */
require_once( "../configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
require_once( "../includes/Function.php" );
/** Create Database Object */
$dbObj = new DBConn;
//=== SESSION
$Username = $valid_user;
/** Config Table for This Page */
$myTable1 = "personal_tb";
$myTable2 = "research_tb";
$myTable3 =" researchtype_tb";
$myTable4 ="researchpublic_tb";
$myTable5 = "research_char_tb";
$myTable6 ="research_file_tb";
$myTable7="research_public_tb";
$myTable8 ="research_success_tb";
$myTable9 ="researchtracking_tb";
$myTable2PK = "Research_code";
/** Table --> personal_tb */
$sql = " SELECT * FROM $myTable2 WHERE Research_code ='$Research_code' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rss1= mysql_fetch_array($result1);
$sql = " SELECT * FROM $myTable6 WHERE Research_code ='$Research_code' ";
$result2 = mysql_query($sql) or die("Error".mysql_error());
$rss2= mysql_fetch_array($result2);
$sql = " SELECT * FROM $myTable7 WHERE Research_code ='$Research_code' ";
$result3 = mysql_query($sql) or die("Error".mysql_error());
$rss3= mysql_fetch_array($result3);
$strSQL = "SELECT count_rv FROM research_tb WHERE Research_code = '".$_GET["Research_code"]."' ";
$objQuery = mysql_query($strSQL);
$result = mysql_fetch_array($objQuery);
$count = $result[0] +1;
$strSQL = "UPDATE research_tb SET count_rv= '$count' WHERE Research_code = '".$_GET["Research_code"]."' ";
$objQuery = mysql_query($strSQL);
/** โฟลเดอร์ไฟล์เอกสาร */
$doc_path = $_Config_live_site."/Research_pic";
} # else
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<link href="../css/default.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="../js/utilities.js"></script>
<title> ข้อมูลงานวิจัย - ผลงานการวิจัย</title>
</head>
<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="800" height="440" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset>
<table width="772" border="0" cellspacing="0" cellpadding="0">
<form action="#" method="post" enctype="multipart/form-data" name="form1" id="form1" onsubmit="return checkData();">
<tr>
<td width="772" height="5"></td>
</tr>
<tr>
<td align="center" valign="top"><table width="766" border="0" cellpadding="1" cellspacing="1" bgcolor="#E5E5E5" class="BORDER-GREY-LIGHT" style="vertical-align:top">
<tr bordercolor="#CCCCCC" bgcolor="#ECF5FF">
<td height="100%" colspan="3" align="left" nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">หน่วยงาน :
<?php
$sql = "Select * From college Where collegeStatus ='1' ";
$result2 = mysql_query($sql) or die("Error".mysql_error());
$rss4 = mysql_fetch_array($result2);
echo $rss4["collegeName"];
?></td>
</tr>
<tr>
<td colspan="3" align="left" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> ประเภทผลงาน :<span class="TEXT-RED10">
<?php
$sql = "Select * From $myTable3 Where ReTyId='$rss3[ReTyId]' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs1 = mysql_fetch_array($result1);
echo "$rs1[ReTyname] ";
?>
</span></span></td>
</tr>
<tr>
<td colspan="3" align="left" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">ชื่อผลงาน: </a><a><?php echo htmlspecialchars_decode( nl2br( $rss1['Research_name'] ) ); ?></a></td>
</tr>
<tr>
<td width="15%" height="22" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td colspan="2" bgcolor="#FFFFFF"><input name="Research_type" type="radio" <?php if (!(strcmp("$rss1[Research_type]","1"))) {echo "checked";} ?> value="1" />
เป็นผลงานที่อยู่ในแผนส่งเสริมการนำเสนอผลงานวิชาการของวิทยาลัย </td>
</tr>
<tr>
<td height="22" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td colspan="2" bgcolor="#FFFFFF"><input name="Research_type" type="radio" <?php if (!(strcmp("$rss1[Research_type]","2"))) {echo "checked";} ?> value="2" />
ได้รับการสนับสนุนงบประมาณจากวิทยาลัยและ/หรือหน่วยงานอื่นๆ ในการไปนำเสนอผลงานวิชาการ</td>
</tr>
<tr>
<td height="22" colspan="3" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"><table width="81%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
<tr bgcolor="<?=$bgColor;?>">
<td height="20" colspan="2" align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ชื่อผู้ทำวิจัย</td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">สถานะการทำวิจัย</td>
<td align="center" bgcolor="#FFFFFF" class="PADDING-LEFT-5">สัดส่วน</td>
</tr>
<?php
$query = " SELECT * FROM research_char_tb WHERE Research_code='$Research_code' ";
$result1 = $dbObj->execQuery($query);
$numrows = $dbObj->_numrows;
?>
<?php
$no = 1+($display-1)*$limit;
while( $rss = $dbObj->fetchArray($result1) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
<tr bgcolor="#FFFFFF">
<td width="3%" height="20" align="right"><img src="../images/icons/linesub.gif" width="16" height="16" border="0" align="absmiddle" /></td>
<td width="64%" align="left" class="PADDING-LEFT-5"><?php
$Teacher_code= $rss['Teacher_code'] ;
$sql11 = " Select *, prefixName as First_name FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId Where Teacher_code='$Teacher_code' ";
$result11 = mysql_query($sql11);
$rs11 = mysql_fetch_array($result11);
echo"$rs11[First_name] $rs11[Teacher_name] $rs11[Teacher_lastname]";
?></td>
<td width="25%" align="center" class="PADDING-LEFT-5"><? echo $rss['R_position'] ;?></td>
<td width="8%" align="center" class="PADDING-LEFT-5"><? echo $rss['persent'];?></td>
</tr>
<?php
//$no++;
} # while
?>
</table></td>
</tr>
<?php if ($rss1['Branch']) { ?>
<tr>
<td height="22" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">กลุ่มสาขาวิชาการ</td>
<td width="1%" bgcolor="#FFFFFF">:</td>
<td width="84%" align="left" bgcolor="#FFFFFF"><? echo $rss1['Branch'] ; ?></td>
</tr>
<?php } ?>
<!---------------------------------------------------------------------->
<?php if ($rss2['importance']) { ?>
<tr>
<td height="22" colspan="3" align="left" bgcolor="#FFFFFF" style="display:<?=($rss2["importance"]!==0)?"":"block";?> " class="TEXT-DARK-BLUE10"> ความสำคัญและที่มาของปัญหา : <br /> <?php echo htmlspecialchars_decode( nl2br( $rss2['importance'] ) ); ?></td>
</tr>
<?php }?>
<!---------------------------------------------------------------------->
<?php if ($rss2['objective']) { ?>
<tr>
<td height="22" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="22" colspan="3" align="left" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> วัตถุประสงค์ของโครงการ</td>
</tr>
<tr>
<td height="22" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><?php echo htmlspecialchars_decode( nl2br( $rss2['objective'] ) ); ?></td>
</tr>
<?php } ?>
<!--------------------------------------------------------------------------->
<?php if ($rss2['scope']) { ?>
<tr>
<td height="22" colspan="3" align="left" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> ขอบเขตของโครงการผลงาน</td>
</tr>
<tr>
<td height="22" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><?php echo htmlspecialchars_decode( nl2br( $rss2['scope'] ) ); ?></td>
</tr>
<?php } ?>
<!---------------------------------------------------------------->
<?php if ($rss2['receive']) { ?>
<tr>
<td height="22" colspan="3" align="left" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> ผลที่คาดว่าจะได้รับ</td>
</tr>
<tr>
<td height="22" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><?php echo htmlspecialchars_decode( nl2br( $rss2['receive'] ) ); ?></td>
</tr>
<?php }?>
<!----------------------------------------------------------------------------------->
<?php if ($rss2['quality']) { ?>
<tr>
<td height="22" colspan="3" align="left" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> นำไปใช้ในการพัฒนาคุณภาพการศึกษา</td>
</tr>
<tr>
<td height="22" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF">:</td>
<td align="left" bgcolor="#FFFFFF"><?php echo htmlspecialchars_decode( nl2br( $rss2['quality'] ) ); ?></td>
</tr>
<?php } ?>
<!----------------------------------------------------------------------------------->
<?php if ($rss2['abbStract']) { ?>
<tr>
<td height="22" colspan="3" align="left" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> บทคัดย่อ</td>
</tr>
<tr >
<td align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><?php echo htmlspecialchars_decode( nl2br( $rss2['abbStract'] ) ); ?></td>
</tr>
<?php } ?>
<!----------------------------------------------------------------------------------->
<?php if ($rss2['Filetex']) { ?>
<tr >
<td colspan="3" align="left" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"><font color="#003366" face="Tahoma">ดาว์โหลดไฟล์บทคัดย่อ</font> :
<?php if( $rss2['Filetex'] != "" ) { ?>
<a href="<?=$doc_path ;?>/<?=$rss2['Filetex'];?>" target="_parent"><img src="../images/icons/download.png" alt=" ดาวน์โหลดไฟล์ <?=$rss2['Filetex'];?> " width="16" height="16" border="0" /></a>
<?php } else { ?>
<img src="../images/icons/download_off.png" width="16" height="16" />
<?php } ?></td>
</tr>
<?php } ?>
<!----------------------------------------------------------------------------------->
<tr>
<td colspan="3" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
</tr>
<tr>
<td colspan="3" align="left" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"><table width="96%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
<?php
$query = " SELECT * FROM research_dissemination WHERE Research_code='$Research_code' and Feature='3' ";
$result1 = $dbObj->execQuery($query);
$numrows = $dbObj->_numrows;
?>
<?php
$no = 1+($display-1)*$limit;
while( $rss = $dbObj->fetchArray($result1) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="20" colspan="2" align="left" bgcolor="#3399FF"><span class="PADDING-LEFT-10"> ผลงานวิจัยนำเสนอในที่ประชุมวิชาการระดับชาติและนานาชาติ</span></td>
<td align="center" bgcolor="#3399FF" class="PADDING-CENTER">ปี พ.ศ</td>
<td align="center" bgcolor="#3399FF" class="PADDING-CENTER">คะแนน</td>
<td align="center" bgcolor="#3399FF" class="PADDING-LEFT-5">วันที่เผยแพร่</td>
<td align="center" bgcolor="#3399FF" class="PADDING-LEFT-5">โหลด</td>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="20" colspan="2" align="left"><img src="../images/icons/linesub.gif" width="16" height="16" border="0" align="absmiddle" /> <?php
$sql = "Select * From researchfeature Where FeId ='$rss[Quality]' ";
$result4 = mysql_query($sql) or die("Error".mysql_error());
$rss5 = mysql_fetch_array($result4);
echo $rss5["FeatureName"];
?></td>
<td align="center" class="PADDING-LEFT-5"><?=$rss['academic_year_finish']?></td>
<td align="center" class="PADDING-LEFT-5"> </td>
<td align="center" class="PADDING-LEFT-5"><?php
$sday = $rss['DatePublic'];
$yearthai = explode( "-", $sday );
$day = intval( $yearthai[2] );
$month = intval( $yearthai[1] );
$year = intval( $yearthai[0] );
$m = getThaiSubMonth( $month );
echo $day ." ". $m ." ". $year;
?>
-</td>
<td align="center" class="PADDING-LEFT-5"> </td>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="20" colspan="2" align="left"> ชื่อการประชุม :
<?=$rss['MeetingName'];?><br />
หน่วยงานที่จัด :
<?=$rss['Agencies'];?></td>
<td width="8%" align="center" class="PADDING-LEFT-5"> </td>
<td width="6%" align="center" class="PADDING-LEFT-5"><?=$rss['Results']?></td>
<td width="15%" align="center" class="PADDING-LEFT-5"><?php
$sday = $rss['DatePublic'];
$yearthai = explode( "-", $sday );
$day = intval( $yearthai[2] );
$month = intval( $yearthai[1] );
$year = intval( $yearthai[0] );
$m = getThaiSubMonth( $month );
echo $day ." ". $m ." ". $year;
?></td>
<td width="5%" align="center" class="PADDING-LEFT-5"><?php if( $rss['Filetex'] != "" ) { ?>
<a href="<?=$doc_path ;?>/<?=$rss['Filetex'];?>" target="_parent"><img src="../images/icons/download.png" alt=" ดาวน์โหลดไฟล์ <?=$rss['Filetex'];?> " width="16" height="16" border="0" /></a>
<?php } else { ?>
<img src="../images/icons/download_off.png" width="16" height="16" />
<?php } ?></td>
<?php
$no++;
} # while
?>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="20" colspan="6" align="left" bgcolor="#FFFFFF"class="PADDING-LEFT-10" > </td>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="20" colspan="2" align="left" bgcolor="#FFCC66"class="PADDING-LEFT-10" >ผลงานวิจัยที่ตีพิมพ์เผยแพร่ในวารสารระดับชาติและนานาชาติ</td>
<td align="center" bgcolor="#FFCC66" class="PADDING-CENTER">ปี พ.ศ</td>
<td align="center" bgcolor="#FFCC66" class="PADDING-CENTER">คะแนน</td>
<td align="center" bgcolor="#FFCC66" class="PADDING-LEFT-5">วันที่เผยแพร่</td>
<td align="center" bgcolor="#FFCC66" class="PADDING-LEFT-5">โหลด</td>
</tr>
<?php
$query = " SELECT * FROM research_dissemination WHERE Research_code='$Research_code' and Feature='1' ";
$result2 = $dbObj->execQuery($query);
$numrows = $dbObj->_numrows;
?>
<?php
$no = 1+($display-1)*$limit;
while( $rs2 = $dbObj->fetchArray($result2) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="20" colspan="2" align="left"><img src="../images/icons/linesub.gif" width="16" height="16" border="0" align="absmiddle" />
<?php
$sql = "Select * From researchfeature Where FeId ='$rs2[Warsan]' ";
$result4 = mysql_query($sql) or die("Error".mysql_error());
$rss5 = mysql_fetch_array($result4);
echo $rss5["FeatureName"];
?>
</td>
<td align="center" class="PADDING-LEFT-5"><?=$rs2['academic_year_finish']?></td>
<td align="center" class="PADDING-LEFT-5"> </td>
<td align="center" class="PADDING-LEFT-5"><?php
$sday = $rs2['DatePublic'];
$yearthai = explode( "-", $sday );
$day = intval( $yearthai[2] );
$month = intval( $yearthai[1] );
$year = intval( $yearthai[0] );
$m = getThaiSubMonth( $month );
echo $day ." ". $m ." ". $year;
?>
-</td>
<td align="center" class="PADDING-LEFT-5"> </td>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="20" colspan="2" align="left">
ชื่อฐานข้อมูล:
<?=$rs2['DatabaseName'];?><br />
ชื่อวารสาร:
<?=$rs2['JournalName'];?></td>
<td align="center" class="PADDING-LEFT-5"> </td>
<td align="center" class="PADDING-LEFT-5"><?=$rs2['Results']?></td>
<td align="center" class="PADDING-LEFT-5"><?php
$sday = $rs2['DatePublic'];
$yearthai = explode( "-", $sday );
$day = intval( $yearthai[2] );
$month = intval( $yearthai[1] );
$year = intval( $yearthai[0] );
$m = getThaiSubMonth( $month );
echo $day ." ". $m ." ". $year;
?></td>
<td align="center" class="PADDING-LEFT-5"><?php if( $rs2['Filetex'] != "" ) { ?>
<a href="<?=$doc_path ;?>/<?=$rs2['Filetex'];?>" target="_parent"><img src="../images/icons/download.png" alt=" ดาวน์โหลดไฟล์ <?=$rs2['Filetex'];?> " width="16" height="16" border="0" /></a>
<?php } else { ?>
<img src="../images/icons/download_off.png" width="16" height="16" />
<?php } ?></td>
<?php
$no++;
} # while
?>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="20" colspan="6" align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-10"> </td>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="20" colspan="2" align="left" bgcolor="#FFCC99" class="PADDING-LEFT-10"><font color="#000000"> <font color="#000000">การเผยแพร่บทความวิชาการ</font></font></td>
<td align="center" bgcolor="#FFCC99" class="PADDING-CENTER">ปี พ.ศ</td>
<td align="center" bgcolor="#FFCC99" class="PADDING-CENTER">คะแนน</td>
<td align="center" bgcolor="#FFCC99" class="PADDING-LEFT-5">วันที่เผยแพร่</td>
<td align="center" bgcolor="#FFCC99" class="PADDING-LEFT-5">โหลด</td>
</tr>
<?php
$query = " SELECT * FROM research_dissemination WHERE Research_code='$Research_code' and Feature='2' ";
$result4 = $dbObj->execQuery($query);
$numrows = $dbObj->_numrows;
?>
<?php
$no = 1+($display-1)*$limit;
while( $rs4 = $dbObj->fetchArray($result4) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="20" colspan="2" align="left"><img src="../images/icons/linesub.gif" width="16" height="16" border="0" align="absmiddle" /> <?php
$sql = "Select * From researchfeature Where FeId ='$rs4[Warsan]' ";
$result4 = mysql_query($sql) or die("Error".mysql_error());
$rss5 = mysql_fetch_array($result4);
echo $rss5["FeatureName"];
?> </td>
<td align="center" class="PADDING-LEFT-5"><?=$rs4['academic_year_finish']?></td>
<td align="center" class="PADDING-LEFT-5"> </td>
<td align="center" class="PADDING-LEFT-5"><?php
$sday = $rs4['DatePublic'];
$yearthai = explode( "-", $sday );
$day = intval( $yearthai[2] );
$month = intval( $yearthai[1] );
$year = intval( $yearthai[0] );
$m = getThaiSubMonth( $month );
echo $day ." ". $m ." ". $year;
?>
-</td>
<td align="center" class="PADDING-LEFT-5"> </td>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td width="3%" height="20" align="right"> </td>
<td width="63%" align="left" class="PADDING-LEFT-5"> ชื่อฐานข้อมูล:
<?=$rs4['DatabaseName'];?><br /> ชื่อวารสาร:
<?=$rs4['JournalName'];?></td>
<td align="center" class="PADDING-LEFT-5"> </td>
<td align="center" class="PADDING-LEFT-5"><?=$rs4['Results']?></td>
<td align="center" class="PADDING-LEFT-5"><?php
$sday = $rs4['DatePublic'];
$yearthai = explode( "-", $sday );
$day = intval( $yearthai[2] );
$month = intval( $yearthai[1] );
$year = intval( $yearthai[0] );
$m = getThaiSubMonth( $month );
echo $day ." ". $m ." ". $year;
?></td>
<td align="center" class="PADDING-LEFT-5"><?php if( $rs4['Filetex'] != "" ) { ?>
<a href="<?=$doc_path ;?>/<?=$rs4['Filetex'];?>" target="_parent"><img src="../images/icons/download.png" alt=" ดาวน์โหลดไฟล์ <?=$rs4['Filetex'];?> " width="16" height="16" border="0" /></a>
<?php } else { ?>
<img src="../images/icons/download_off.png" width="16" height="16" />
<?php } ?></td>
<?php
$no++;
} # while
?>
</tr>
</table></td>
</tr>
<tr>
<td colspan="3" align="left" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
</tr>
<tr>
<td colspan="3" align="center" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">
<label>
<input name="outreacId2" type="checkbox" id="outreacId2" <?php if (!strcmp("$rs4[outreacId]","Y") ) {echo "checked";} ?> value="Y" />
</label>
บูรณาการกับโครงการบริการวิชาการ
<input name="outreacId2" type="checkbox" id="outreacId2" <?php if (!strcmp("$rs4[outSouse]","Y") ) {echo "checked";} ?> value="Y" />
ความร่วมมืองานวิจัยกับบุคคลภายนอก </td>
</tr>
<tr>
<td align="right" valign="top" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">ปีปฏิทิน</a></td>
<td bgcolor="#FFFFFF">:</td>
<td align="left" bgcolor="#FFFFFF"><? echo $rss1['Year_prop']; ?></td>
</tr>
<tr>
<td align="right" valign="top" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">ปีการศึกษา</td>
<td bgcolor="#FFFFFF">:</td>
<td align="left" bgcolor="#FFFFFF"><? echo $rss1['academic_year_finish']; ?></td>
</tr>
<tr>
<td align="right" valign="top" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">ปีงบประมาณ</td>
<td bgcolor="#FFFFFF">:</td>
<td align="left" bgcolor="#FFFFFF"></a><? echo $rss1['fiscal_year_finish']; ?></td>
</tr>
<tr>
<td height="24" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">วันที่เริ่ม</td>
<td bgcolor="#FFFFFF">:</td>
<td align="left" bgcolor="#FFFFFF"><?php
$sday = $rss1['Year_start'];
$yearthai = explode( "-", $sday );
$day = intval( $yearthai[2] );
$month = intval( $yearthai[1] );
$year = intval( $yearthai[0] );
$m = getThaiSubMonth( $month );
echo $day ." ". $m ." ". $year;
?> </a> <span class="TEXT-DARK-BLUE10">วันที่แล้วเสร็จ : </span>
</a>
<?php
$sday = $rss1['Year_finish'];
$yearthai = explode( "-", $sday );
$day = intval( $yearthai[2] );
$month = intval( $yearthai[1] );
$year = intval( $yearthai[0] );
$m = getThaiSubMonth( $month );
echo $day ." ". $m ." ". $year;
?></td>
</tr>
<tr>
<td align="right" valign="top" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">แหล่งเงินทุน</td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><table width="98%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td width="19%" align="left"><input name="Fund_resourceIn" type="checkbox" id="Fund_resourceIn" <?php if (!strcmp("$rss1[Fund_resourceIn]","ภายใน") ) {echo "checked";} ?> value="ภายใน" <?php if( $_GET['Fund_resourceIn'] == "ภายใน" ) echo 'checked'; ?> onclick="checkAssign1(this,form1.FundIn)" />
ภายใน</td>
<td width="81%" align="left">จำนวนเงิน
<? echo number_format($rss1['FundIn'],2,'.',',');?> บาท</td>
</tr>
<tr>
<td align="left"><input name="Fund_resourceOut" type="checkbox" id="Fund_resourceOut" <?php if (!strcmp("$rss1[Fund_resourceOut]","ภายนอก") ) {echo "checked";} ?> value="ภายนอก" <?php if( $_GET['Fund_resourceOut'] == "ภายนอก" ) echo 'checked'; ?> onclick="checkAssign1(this,form1.FundOut ,form1.Resource_des )" />
ภายนอก</td>
<td align="left">จำนวนเงิน
<? echo number_format($rss1['FundOut'],2,'.',',');?> บาท </a></a> <? echo $rss1['Resource_des'];?></td>
</tr>
<tr>
<td align="right"><span class="TEXT-DARK-BLUE10"> รวมจำนวนเงินทุน</a></td>
<td align="left"><? echo number_format($rss1['FundUse'],2,'.',',');?>
บาท</td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="3" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> <table width="99%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
<tr bgcolor="<?=$bgColor;?>">
<td height="20" colspan="2" align="center" bgcolor="#3399FF"class="PADDING-LEFT-5"> ชื่อแฟ้มข้อมูล</font></td>
<td width="16%" align="center" bgcolor="#3399FF" class="PADDING-LEFT-5">ขนาดแฟ้มข้อมูล</td>
<td width="12%" align="center" bgcolor="#3399FF" class="PADDING-LEFT-5">จำนวนเข้าถึง </td>
<td width="23%" align="center" bgcolor="#3399FF" class="PADDING-LEFT-5">วัน-เวลาเข้าถึงล่าสุด</td>
<td width="10%" align="center" bgcolor="#3399FF" class="PADDING-LEFT-5">Download</td>
</tr>
<?php
$query = " SELECT * FROM research_filetex_tb WHERE Research_code='$Research_code' ";
$result = $dbObj->execQuery($query);
$numrows = $dbObj->_numrows;
?>
<?php
$no = 1+($display-1)*$limit;
while( $rs5 = $dbObj->fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
<tr bgcolor="<?=$bgColor;?>">
<td width="3%" height="20" align="right"><img src="../images/icons/linesub.gif" width="16" height="16" border="0" align="absmiddle" /></td>
<td width="36%" align="left" class="PADDING-LEFT-5"><?=$rs5["Filename"];?>
</a></td>
<td align="center" class="PADDING-LEFT-5"> </td>
<td align="center" class="PADDING-LEFT-5"> </td>
<td align="center" class="PADDING-LEFT-5"> </td>
<td align="center" class="PADDING-LEFT-5"><?php if( $rs5['Filetex'] != "" ) { ?>
<a href="<?=$doc_path ;?>/<?=$rs5['Filetex'];?>" target="_parent"><img src="../images/icons/download.png" alt=" ดาวน์โหลดไฟล์ <?=$rs5['Filetex'];?> " width="16" height="16" border="0" /></a>
<?php } else { ?>
<img src="../images/icons/download_off.png" width="16" height="16" />
<?php } ?></td>
</tr>
<?php
$no++;
} # while
?>
<tr>
<td height="22" colspan="6" align="center" bgcolor="#F8F8F8">ทั้งหมด <span class="NOTE"><?php echo $numrows; ?></span> รายการ</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr></form>
</table>
</fieldset></td>
</tr>
</table>
</body>
</html>
<?php
/** Free Resource */
$dbObj->freeresult($result0);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?>
|