Viewing file: AddResearch.php (39.65 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( "../include/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";
$myTable2PK = "Research_code";
/** Table --> personal_tb */
$query0 = " SELECT * FROM $myTable1 WHERE Username='$Username' ";
$result0 = $dbObj->execQuery($query0);
$rss = $dbObj->fetchArray($result0);
$Teacher_code = $rss['Teacher_code'];
/** Paging */
$page = $_GET['page'];
if( $page == "" ) { $page = 1; }
/** จำนวนข้อมูล ต่อ 1 หน้า */
$perpage = $_REQUEST['perpage'];
if( $perpage == "" ) { $perpage = 10; }
} # 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>
<style type="text/css">
<!--
.style22 {font-size: 14px; font-weight: bold; }
-->
</style>
</head>
<script language="javascript">
function checkData() {
var formObj = document.form1;
if( (formObj.Research_name.value == "" ) && (formObj.mYear.value == "" ) && (formObj.mYear2.value == "" ) && (formObj.mYear3.value == "" ) && (formObj.Fund.value == "" ) ) { alert("กรุณากรอกข้อมูลให้ครบด้วยค่ะ" ); formObj.Research_name.style.backgroundColor='#F1F9FC'; formObj.Research_name.focus(); return false; }
else if(formObj.Research_name.value == "" ) { alert("กรุณากรอก ชื่อผลงานวิจัย"); formObj.Research_name.style.backgroundColor='#F1F9FC'; formObj.Research_name.focus(); return false;}
else if(formObj.mYear.value == "" ) { alert("กรุณากรอก ปีที่เริ่ม"); formObj.mYear.style.backgroundColor='#F1F9FC'; formObj.mYear.focus(); return false;}
else if(formObj.mYear2.value == "" ) { alert("กรุณากรอก ปีที่แล้วเสร็จ"); formObj.mYear2.style.backgroundColor='#F1F9FC'; formObj.mYear2.focus(); return false;}
//else if(formObj.Fund.value == "" ) { alert("กรุณากรอก จำนวนเงินทุน"); formObj.Fund.style.backgroundColor='#F1F9FC'; formObj.Fund.focus(); return false;}
//else if(formObj.mYear3.value == "" ) { alert("กรุณากรอก ปีที่เผยแพร่"); formObj.mYear3.style.backgroundColor='#F1F9FC'; formObj.mYear3.focus(); return false;}
else return true;
}
</script>
<script language="JavaScript" type="text/JavaScript">
function browse()
{
form1.Filetex.src = form1.Filetex.value;
}
</script>
<script language="javascript">
//-->
function enableDropdown(){
var form = document.form1;
if(form.Teachbox1.checked){
form1.Teacher_code1.disabled = false;
form1.R_position1.disabled = false;
}
else{
form1.Teacher_code1.disabled = true;
form1.R_position1.disabled = true;
}
if(form.Teachbox2.checked){
form1.Teacher_code2.disabled = false;
form1.R_position2.disabled = false;
}
else{
form1.Teacher_code2.disabled = true;
form1.R_position2.disabled = true;
}
if(form.Teachbox3.checked){
form1.Teacher_code3.disabled = false;
form1.R_position3.disabled = false;
}
else{
form1.Teacher_code3.disabled = true;
form1.R_position3.disabled =true;
}
if(form.Teachbox4.checked){
form1.Teacher_code4.disabled = false;
form1.R_position4.disabled = false;
}
else{
form1.Teacher_code4.disabled = true;
form1.R_position4.disabled = true;
}
if(form.Teachbox5.checked){
form1.Teacher_code5.disabled = false;
form1.R_position5.disabled = false;
}
else{
form1.Teacher_code5.disabled = true;
form1.R_position5.disabled = true;
}
if(form.Teachbox6.checked){
form1.Teacher_code6.disabled = false;
form1.R_position6.disabled = false;
}
else{
form1.Teacher_code6.disabled = true;
form1.R_position6.disabled = true;
}
if(form.Teachbox7.checked){
form1.Teacher_code7.disabled = false;
form1.R_position7.disabled = false;
}
else{
form1.Teacher_code7.disabled = true;
form1.R_position7.disabled = true;
}
}
</script>
<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
<?php
include("../templates/incHeader.php");
?>
<table width="1004" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="206" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include("./_incMainMenu.php");?></td>
<td width="798" height="440" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset>
<table width="772" border="0" cellspacing="0" cellpadding="0">
<form action="InsertResearch.php" method="post" enctype="multipart/form-data" name="form1" id="form1" onsubmit="return checkData();">
<tr>
<td width="772" height="5"></td>
</tr>
<tr>
<td height="30" background="../images/background/bg-head-topic-w780.gif" class="PADDING-LEFT-10"><strong><a href="index.php">หน้าหลัก</a></strong> <strong>» <a href="ResearchList.php?collegeCode=<?=$collegeCode;?>">ข้อมูลงานวิจัย</a> » <span class="NOTE">เพิ่มโครงการผลงานวิจัย</span></strong></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="center"><table width="766" border="0" cellpadding="1" cellspacing="1" bgcolor="#E5E5E5" class="BORDER-GREY-LIGHT">
<tr >
<td height="18" colspan="3" align="center"><strong>ตัวชี้วัดตามแผนกลยุทธ์ที่ </strong><strong>3.1</strong></td>
</tr>
<tr >
<td height="18" colspan="3" align="center">ร้อยละของหน่วยงานในสังกัดสถาบันพระบรมราชชนกที่มีผลงานวิชาการที่เน้นชุมชนได้รับการเผยแพร่ในระดับชาติหรืออาเซียน</td>
</tr>
<tr bordercolor="#CCCCCC" bgcolor="#ECF5FF">
<td height="100%" colspan="3" align="center" nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF" class="style14">รายละเอียด<strong>ผลงานวิชาการที่เน้นชุมชน</strong> ที่มีการดำเนินงานแล้วเสร็จ ตั้งแต่วันที่ 1 กันยายน 2552 - 31 สิงหาคม 2553 </td>
</tr>
<tr bordercolor="#CCCCCC" bgcolor="#ECF5FF">
<td height="100%" align="right" nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF" class="style14"> </td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF" class="style14"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF" class="style14"> </td>
</tr>
<tr bordercolor="#CCCCCC" bgcolor="#ECF5FF">
<td height="100%" align="right" nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF" class="style14"><font color="#000066" face="Tahoma">หน่วยงาน</font></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF" class="style14"> </td>
<td nowrap="nowrap" bordercolor="#CCCCCC" bgcolor="#FFFFFF" class="style14"><?php
$sql = "Select * From College Where collegeCode='$collegeCode' ";
$result2 = mysql_query($sql) or die("Error".mysql_error());
$rss4 = mysql_fetch_array($result2);
echo"<option value=\"$rss4[collegeCode]\" >$rss4[collegeName]</option>\n";
// echo "$rss4[collegeName] ";
?>
<input name="collegeCode" type="hidden" id="collegeCode" value="<? echo $rss4[collegeCode]?>" /></td>
</tr>
<tr>
<td width="21%" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">ชื่อโครงการงานวิจัย <span class="TEXT-RED10">*</span></td>
<td width="0%" bgcolor="#FFFFFF"> </td>
<td width="79%" align="left" bgcolor="#FFFFFF"><font color="#0000FF" size="2" face="Tahoma">
<input name="Research_name" type="text" id="Research_name" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<?=$_GET['Research_name'];?>" size="85" />
</font></td>
</tr>
<tr>
<td height="22" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><p>
<input name="Research_type" type="radio" value="1" />
เป็นผลงานที่อยู่ในแผนส่งเสริมการนำเสนอผลงานวิชาการของวิทยาลัย </p></td>
</tr>
<tr>
<td height="22" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><input name="Research_type" type="radio" value="2" />
ได้รับการสนับสนุนงบประมาณจากวิทยาลัยและ/หรือหน่วยงานอื่นๆ ในการไปนำเสนอผลงานวิชาการ</td>
</tr>
<tr>
<td height="22" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">กลุ่มสาขาวิชาการ</td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><font color="#0000FF" size="2" face="Tahoma">
<input name="Branch" type="text" id="Branch" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<?=$_GET['Branch'];?>" size="30" />
</font></td>
</tr>
<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" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><table width="89%" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
<?php
$query = " SELECT * FROM $myTable3 ";
$result2 = $dbObj->execQuery($query);
$numrows = $dbObj->_numrows;
$collegeCode = $rs->collegeCode;
?>
<?php
$sql = "Select * From $myTable3 Where ReTyId='1' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs1 = mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td width="5%" height="22" align="center" bgcolor="#FFFFFF"><input name="Research_char" type="radio" value="1" /></td>
<td width="95%" align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ด้านการเรียนการสอน</td>
</tr>
<?php
$sql = "Select * From $myTable3 Where ReTyId='2' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs2 = mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="Research_char" type="radio" value="2" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ด้านคลินิค</td>
</tr>
<?php
$sql = "Select * From $myTable3 Where ReTyId='3' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs3 = mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="Research_char" type="radio" value="3" checked="checked"/></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ด้านชุมชน</td>
</tr>
<?php
$sql = "Select * From $myTable3 Where ReTyId='4' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs4= mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="Research_char" type="radio" value="4" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ด้านการส่งเสริสุขภาพ</td>
</tr>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="Research_char" type="radio" value="5" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5">ด้านอื่นฯ ระบุ<font color="#0000FF" size="2" face="Tahoma"><font color="#0000FF" size="2" face="Tahoma">
<input name="Research_char_else" type="text" id="Research_char_else" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<?=$_GET['Research_char_else'];?>" size="35" />
</font></font></td>
</tr>
<?php
$sql = "Select * From $myTable3 Where ReTyId='5' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs5 = mysql_fetch_array($result1);
?>
<?php
$sql = "Select * From $myTable3 Where ReTyId='6' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs6 = mysql_fetch_array($result1);
?>
<?php
$sql = "Select * From $myTable3 Where ReTyId='7' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs7 = mysql_fetch_array($result1);
?>
<?php
$sql = "Select * From $myTable3 Where ReTyId='8' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs8 = mysql_fetch_array($result1);
?>
<?php
$sql = "Select * From $myTable3 Where ReTyId='9' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs9 = mysql_fetch_array($result1);
?>
</table>
<p> </p></td>
</tr>
<tr>
<td height="22" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">สถานะของงานวิจัย</td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><span class="style14">
<?php
$sql = "Select * From College Where collegeCode='$collegeCode' ";
$result2 = mysql_query($sql) or die("Error".mysql_error());
$rss4 = mysql_fetch_array($result2);
echo"<option value=\"$rss4[collegeCode]\" >$rss4[collegeName]</option>\n";
// echo "$rss4[collegeName] ";
?>
</span></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"><textarea name="importance" cols="50" rows="4" id="importance"><?=$_GET['importance'];?>
</textarea></td>
</tr>
<tr>
<td height="22" colspan="3" align="left" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> วัตถุประสงค์ของโครงการงานวิจัย</td>
</tr>
<tr>
<td height="22" align="left" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><textarea name="objective" cols="50" rows="4" id="objective"><?=$_GET['objective'];?>
</textarea></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"><textarea name="scope" cols="50" rows="4" id="scope"><?=$_GET['scope'];?>
</textarea></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"><textarea name="receive" cols="50" rows="4" id="receive"><?=$_GET['abbStract'];?>
</textarea></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"><textarea name="quality" cols="50" rows="4" id="quality"><?=$_GET['abbStract'];?>
</textarea></td>
</tr>
<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"> ประเภทผลงาน<span class="TEXT-RED10"> *</span></td>
</tr>
<tr>
<td align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><table width="89%" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
<?php
$query = " SELECT * FROM $myTable3 ";
$result2 = $dbObj->execQuery($query);
$numrows = $dbObj->_numrows;
$collegeCode = $rs->collegeCode;
?>
<?php
$sql = "Select * From $myTable3 Where ReTyId='1' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs1 = mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td width="5%" height="22" align="center" bgcolor="#FFFFFF"><input name="ReTyId1" type="checkbox" id="ReTyId1" title=" เลือกประเภทผลงาน <?php echo $rs1['ReTyId']; ?> " onclick="highlightRow(this);" value="1" /></td>
<td width="95%" align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs1[ReTyname] "; ?></td>
</tr>
<?php
$sql = "Select * From $myTable3 Where ReTyId='2' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs2 = mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="ReTyId2" type="checkbox" id="ReTyId2" title=" เลือกประเภทผลงาน <?php echo $rs2['ReTyId']; ?> " onclick="highlightRow(this);" value="2" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs2[ReTyname] "; ?></td>
</tr>
<?php
$sql = "Select * From $myTable3 Where ReTyId='3' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs3 = mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="ReTyId3" type="checkbox" id="ReTyId3" title=" เลือกประเภทผลงาน <?php echo $rs3['ReTyId']; ?> " onclick="highlightRow(this);" value="3" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs3[ReTyname] ";?></td>
</tr>
<?php
$sql = "Select * From $myTable3 Where ReTyId='4' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs4= mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="ReTyId4" type="checkbox" id="ReTyId4" title=" เลือกประเภทผลงาน <?php echo $rs4['ReTyId']; ?> " onclick="highlightRow(this);" value="4" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs4[ReTyname] "; ?></td>
</tr>
<?php
$sql = "Select * From $myTable3 Where ReTyId='5' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs5 = mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="ReTyId5" type="checkbox" id="ReTyId5" title=" เลือกประเภทผลงาน <?php echo $rs5['ReTyId']; ?> " onclick="highlightRow(this);" value="5" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs5[ReTyname] "; ?></td>
</tr>
<?php
$sql = "Select * From $myTable3 Where ReTyId='6' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs6 = mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="ReTyId6" type="checkbox" id="ReTyId6" title=" เลือกประเภทผลงาน <?php echo $rs6['ReTyId']; ?> " onclick="highlightRow(this);" value="6" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs6[ReTyname] "; ?></td>
</tr>
<?php
$sql = "Select * From $myTable3 Where ReTyId='7' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs7 = mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="ReTyId7" type="checkbox" id="ReTyId7" title=" เลือกประเภทผลงาน <?php echo $rs7['ReTyId']; ?> " onclick="highlightRow(this);" value="7" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs7[ReTyname] "; ?></td>
</tr>
<?php
$sql = "Select * From $myTable3 Where ReTyId='8' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs8 = mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="ReTyId8" type="checkbox" id1="ReTyId8" title=" เลือกประเภทผลงาน <?php echo $rs8['ReTyId']; ?> " onclick="highlightRow(this);" value="8" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs8[ReTyname] "; ?></td>
</tr>
<?php
$sql = "Select * From $myTable3 Where ReTyId='9' ";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rs9 = mysql_fetch_array($result1);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="ReTyId9" type="checkbox" id="ReTyId9" title=" เลือกประเภทผลงาน <?php echo $rs9['ReTyId']; ?> " onclick="highlightRow(this);" value="9" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs9[ReTyname] ";?></td>
</tr>
</table></td>
</tr>
<tr>
<td 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"><table width="89%" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" style="background-color:#eeeeee; border:0px solid gray">
<?php
$sql = "Select * From $myTable4 Where RePbId='1' ";
$result = mysql_query($sql) or die("Error".mysql_error());
$rs1= mysql_fetch_array($result);
?>
<tr bgcolor="<?=$bgColor;?>">
<td width="5%" height="22" align="center" bgcolor="#FFFFFF"><input name="RePbId1" type="checkbox" id2="RePbId1" title=" เลือกการเผยแพร่ <?php echo $rs1['RePbId']; ?> " value="1" onclick="checkAssign1(this,form1.AreaRePbId1)" /></td>
<td width="95%" align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs1[RePbname] ";?>
ระบุสถานที่
<input name="AreaRePbId1" type="text" id="AreaRePbId1" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" size="30" disabled="disabled" /></td>
</tr>
<?php
$sql = "Select * From $myTable4 Where RePbId='2' ";
$result = mysql_query($sql) or die("Error".mysql_error());
$rs2= mysql_fetch_array($result);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="RePbId2" type="checkbox" id2="RePbId2" title=" เลือกการเผยแพร่ <?php echo $rs2['RePbId']; ?> " value="2" onclick="checkAssign1(this,form1.AreaRePbId2)" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs2[RePbname] "; ?> ระบุสถานที่
<input name="AreaRePbId2" type="text" id="AreaRePbId2" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" size="30" disabled="disabled" /></td>
</tr>
<?php
$sql = "Select * From $myTable4 Where RePbId='3' ";
$result = mysql_query($sql) or die("Error".mysql_error());
$rs4= mysql_fetch_array($result);
?>
<?php
$sql = "Select * From $myTable4 Where RePbId='3' ";
$result = mysql_query($sql) or die("Error".mysql_error());
$rs3= mysql_fetch_array($result);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="RePbId3" type="checkbox" id2="RePbId3" title=" เลือกการเผยแพร่ <?php echo $rs3['RePbId']; ?> " value="3" onclick="checkAssign1(this,form1.AreaRePbId3)" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs3[RePbname] "; ?>
ระบุสถานที่
<input name="AreaRePbId3" type="text" id="AreaRePbId3" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" size="30" disabled="disabled" /></td>
</tr>
<?php
$sql = "Select * From $myTable4 Where RePbId='4' ";
$result = mysql_query($sql) or die("Error".mysql_error());
$rs4= mysql_fetch_array($result);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="RePbId4" type="checkbox" id2="RePbId4" title=" เลือกการเผยแพร่ <?php echo $rs4['RePbId']; ?> " value="4" onclick="checkAssign1(this,form1.AreaRePbId4)" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs4[RePbname] ";?> ระบุสถานที่
<input name="AreaRePbId4" type="text" id="AreaRePbId4" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" size="30" disabled="disabled" /></td>
</tr>
<?php
$sql = "Select * From $myTable4 Where RePbId='5' ";
$result = mysql_query($sql) or die("Error".mysql_error());
$rs5= mysql_fetch_array($result);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="RePbId5" type="checkbox" id2="RePbId5" title=" เลือกการเผยแพร่ <?php echo $rs5['RePbId']; ?> " value="5" onclick="checkAssign1(this,form1.AreaRePbId5)" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs2[RePbname] "; ?> ระบุสถานที่
<input name="AreaRePbId5" type="text" id="AreaRePbId5" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" size="30" disabled="disabled" /></td>
</tr>
<?php
$sql = "Select * From $myTable4 Where RePbId='6' ";
$result = mysql_query($sql) or die("Error".mysql_error());
$rs6= mysql_fetch_array($result);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="RePbId6" type="checkbox" id2="RePbId6" title=" เลือกการเผยแพร่ <?php echo $rs6['RePbId']; ?> " onclick="highlightRow(this);" value="6" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs6[RePbname] "; ?></td>
</tr>
<?php
$sql = "Select * From $myTable4 Where RePbId='7' ";
$result = mysql_query($sql) or die("Error".mysql_error());
$rs7= mysql_fetch_array($result);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="RePbId7" type="checkbox" id2="RePbId7" title=" เลือกการเผยแพร่ <?php echo $rs7['RePbId']; ?> " onclick="highlightRow(this);" value="7" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php echo "$rs7[RePbname] "; ?></td>
</tr>
<?php
$sql = "Select * From $myTable4 Where RePbId='8' ";
$result = mysql_query($sql) or die("Error".mysql_error());
$rs8= mysql_fetch_array($result);
?>
<tr bgcolor="<?=$bgColor;?>">
<td height="22" align="center" bgcolor="#FFFFFF"><input name="RePbId8" type="checkbox" id2="RePbId8" title=" เลือกการเผยแพร่ <?php echo $rs8['RePbId']; ?> " onclick="highlightRow(this);" value="8" /></td>
<td align="left" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><?php
// $sql = "Select * From $myTable4 Where RePbId='8' ";
// $result = mysql_query($sql) or die("Error".mysql_error());
// $rs2= mysql_fetch_array($result);
echo "$rs8[RePbname] ";
?></td>
</tr>
</table></td>
</tr>
<tr>
<td align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td colspan="3" align="left" valign="top" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> บทคัดย่อ</td>
</tr>
<tr>
<td align="right" valign="top" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><textarea name="abbStract" cols="50" rows="4" id="abbStract"><?=$_GET['abbStract'];?>
</textarea>
<script>QBPATH='../editor'; VISUAL=1; SECURE=0;</script>
<script src='../editor/quickB.js'></script>
<script src='../editor/tabedit.js'></script></td>
</tr>
<tr >
<td align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"> </td>
</tr>
<tr >
<td align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">อัพโหลดไฟล์เอกสาร</td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><input name="Filetex" type="file" id="Filetex" size="20" /></td>
</tr>
<tr>
<td height="18" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td align="right" valign="top" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">ปีงบประมาณ <span class="TEXT-RED10">*</span></td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><font color="#0000FF" size="2" face="Tahoma">
<select name="Year_prop" id="Year_prop">
<?php
$curr_year = date("Y")+543;
$prev_year = $curr_year-5;
$next_year = $curr_year+2;
for( $i=$prev_year; $i<=$next_year; $i++ ) {
?>
<option value="<?=$i;?>" <?php if( $i==$curr_year ) echo 'selected'; elseif( $i==$Budget_Year ) echo 'selected'; ?>>
<?=$i;?>
</option>
<?php
} # for
?>
</select>
</font></td>
</tr>
<tr>
<td height="24" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">วัน/เดือน/ปีที่เริ่ม <span class="TEXT-RED10">*</span></td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><select name="mDate" id="mDate" class="select" />
<?php getDay1to31(); ?>
</select>
เดือน
<select name="mMonth" id="mMonth" class="select" />
<?php getThaiMonth(); ?>
</select>
ปี <font color="#0000FF" size="2" face="Tahoma">
<select name="mYear" id="mYear">
<?php
$curr_year = date("Y")+543;
$prev_year = $curr_year-5;
$next_year = $curr_year+2;
for( $i=$prev_year; $i<=$next_year; $i++ ) {
?>
<option value="<?=$i;?>" <?php if( $i==$curr_year ) echo 'selected'; elseif( $i==$Budget_Year ) echo 'selected'; ?>>
<?=$i;?>
</option>
<?php
} # for
?>
</select>
</font></td>
</tr>
<tr>
<td height="24" align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10">วัน/เดือน/ปี ที่แล้วเสร็จ <span class="TEXT-RED10">*</span></td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"><select name="mDate2" id="mDate2" class="select" />
<?php getDay1to31(); ?>
</select>
เดือน
<select name="mMonth2" id="mMonth2" class="select" />
<?php getThaiMonth(); ?>
</select>
ปี <font color="#0000FF" size="2" face="Tahoma">
<select name="mYear2" id="mYear2">
<?php
$curr_year = date("Y")+543;
$prev_year = $curr_year-5;
$next_year = $curr_year+2;
for( $i=$prev_year; $i<=$next_year; $i++ ) {
?>
<option value="<?=$i;?>" <?php if( $i==$curr_year ) echo 'selected'; elseif( $i==$Budget_Year ) echo 'selected'; ?>>
<?=$i;?>
</option>
<?php
} # for
?>
</select>
</font></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="18%" align="left"><input name="Fund_resourceIn" type="checkbox" id="Fund_resourceIn" value="ภายใน" <?php if( $_GET['Fund_resourceIn'] == "ภายใน" ) echo 'checked'; ?> onclick="checkAssign1(this,form1.FundIn)" />
ภายใน</td>
<td width="82%" align="left">จำนวนเงิน
<input name="FundIn" type="text" class="input" id="FundIn" value="<?=$_GET['FundIn'];?>" size="10" style="text-align:right; padding-right:5px" onkeypress="checkNumeric()" disabled="disabled" />
บาท</td>
</tr>
<tr>
<td align="left"><input name="Fund_resourceOut" type="checkbox" id="Fund_resourceOut" value="ภายนอก" <?php if( $_GET['Fund_resourceOut'] == "ภายนอก" ) echo 'checked'; ?> onclick="checkAssign1(this,form1.FundOut ,form1.Resource_des )" />
ภายนอก</td>
<td align="left">จำนวนเงิน
<input name="FundOut" type="text" class="input" id="FundOut" size="10" value="<?=$_GET['FundOut'];?>" style="text-align:right; padding-right:5px" onkeypress="checkNumeric()" disabled="disabled" />
บาท ระบุ<font color="#0000FF" size="2" face="Tahoma">
<input name="Resource_des" type="text" id="Resource_des" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<?=$_GET['Resource_des'];?>" size="30" />
</font></td>
</tr>
<tr>
<td align="left"><span class="TEXT-DARK-BLUE10"><span class="TEXT-RED10">*</span> รวมจำนวนเงินทุน</span></td>
<td align="left"><input name="Fund" id="Fund" type="text" size="10" style="text-align:right; padding-right:5px" value="<?=$_GET['Fund'];?>" onkeypress="checkNumeric()" disabled= "disabled"/>
บาท</td>
</tr>
</table></td>
</tr>
<tr>
<td align="right" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"> </td>
<td bgcolor="#FFFFFF"> </td>
<td align="left" bgcolor="#FFFFFF"> </td>
</tr>
<tr >
<td height="25" bgcolor="#FFFFFF"> </td>
<td height="25" bgcolor="#FFFFFF"> </td>
<td height="25" align="center" bgcolor="#FFFFFF"><input type="hidden" name="Teacher_code" value="<?php echo $rss['Teacher_code']; ?>" />
<input type="hidden" name="r_type" value="1" id="r_type" />
<input name="action" type="submit" class="WIDTH60 CURSOR-HAND" id="action" onclick="return confirmSubmit(this.form);" value="บันทึก" />
<input name="Reset" type="reset" class="WIDTH60 CURSOR-HAND" id="Reset" value="รีเซ็ต" />
<input name="Button" type="button" id="Reset" value="ยกเลิก" class="CURSOR-HAND WIDTH60" onclick="location.href='ResearchByYear.php?Teacher_code<?=$Teacher_code;?>'" /></td>
</tr>
<tr >
<td height="18" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr></form>
</table>
</fieldset></td>
</tr>
</table>
<?php include("../templates/incFooter.php"); ?>
</body>
</html>
<?php
/** Free Resource */
$dbObj->freeresult($result0);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?>
|