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);
 ?>
  |