<?php include("includes/head.php"); ?>

<?php include("includes/header.php"); ?>


<?php

/*------------For Add-----------------*/

$paper_id = $_REQUEST['id'];

if(empty($_POST['submit'])){ $_POST['submit']=''; }

if($_POST['submit'] == 'Save'){

	/*----check username----*/
$add_year=date("Y");
$assign_year=$_POST['assign_year']."-06-16 00:05:12";	
 
		/*----check ----*/
 $chksql_initial = "select * from `exam_paper` where `assign_year`='".$assign_year."' AND `paper_name`='".$_POST['paper_name']."' AND subject_id='".$_POST['subject_id']."'";
	$chkqry_initial1 = mysql_query($chksql_initial);
	$getRowinitial1 = mysql_num_rows($chkqry_initial1);
	/*----*/
	if($getRowinitial1 > 0){
		$error = 'This paper already exists under this year.';
     }
	else{	
		$insSql = "update `exam_paper` set ";
		    $insSql .= "exam_board_id='".mysql_real_escape_string($_POST['exam_board_id'])."', ";
			$insSql .= "subject_id='".mysql_real_escape_string($_POST['subject_id'])."', ";
			$insSql .= "pass_marks='".mysql_real_escape_string($_POST['pass_marks'])."', ";
			$insSql .= "add_year='".mysql_real_escape_string($add_year)."', ";
			$insSql .= "paper_name='".mysql_real_escape_string($_POST['paper_name'])."', ";
			$insSql .= "assign_year='".$assign_year."' ";
			$insSql .= "where id = '".$paper_id."' ";
			//echo $insSql;exit;
			mysql_query($insSql);
			
		
         
         //------------------question--updation--------------------------------//		 
			
			$questin_year_update="UPDATE `exam_question_answers_reasons` SET `post_date` = '".$assign_year."' WHERE `paper_id` = '".$paper_id."'";
			
			mysql_query($questin_year_update);
			
					
		//-----------------------------------------------------------------------//	
			
			
			//include("mailuser.php");
			header('location:paper_year_set_list.php?success=2&page='.$_REQUEST['page'].'');
			exit();
	  }
		
		
			
		}

else{

	$_POST['name']='';

}
/*---End Add---*/

?>
<script>
function showsubject(str) {
	
	//alert(str);
    if (str == "") {
        document.getElementById("txtHint").innerHTML = "";
        return;
    } else {
        if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                document.getElementById("txtHint").innerHTML = xmlhttp.responseText;
            }
        }
        xmlhttp.open("GET","getsubject.php?q="+str,true);
        xmlhttp.send();
    }
}



function showtopic(str) {
	
	//alert(str);
    if (str == "") {
        document.getElementById("txtHint1").innerHTML = "";
        return;
    } else {
        if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                document.getElementById("txtHint1").innerHTML = xmlhttp.responseText;
            }
        }
        xmlhttp.open("GET","gettopic.php?q="+str,true);
        xmlhttp.send();
    }
}


function showsubtopic(str) {
	
	//alert(str);
    if (str == "") {
        document.getElementById("txtHint2").innerHTML = "";
        return;
    } else {
        if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                document.getElementById("txtHint2").innerHTML = xmlhttp.responseText;
            }
        }
        xmlhttp.open("GET","getsubtopic.php?q="+str,true);
        xmlhttp.send();
    }
}


</script>
<script>

function formSub(){

	//alert(11111111);

	document.formID.submit();

	return true;
}
jQuery.noConflict();

(function($) {jQuery(document).ready(function(){

	// binds form submission and fields to the validation engine

	jQuery("#formID").validationEngine('attach', {

			onValidationComplete: function(form, status){

			//alert("The form status is: " +status+", it will never submit");

			if(status == true){

				//$('input[type="submit"]').attr('disabled','disabled');

				return formSub();

			}

		}  

	});

});})(jQuery);



</script>
<?php 

	$sql_data = mysql_fetch_array(mysql_query("SELECT * FROM  exam_paper WHERE id = '".$_GET['id']."'"));
?>
<div class="container_bottom_section tbl_cls_new">

<form name="formID" action="" method="post" id="formID" enctype="multipart/form-data">


<table width="100%" border="0" cellspacing="0" cellpadding="0">



	<?php if(empty($error)){$error='';}



	if($error!=''){


	?>

    <tr>

    <td colspan="5">

		<div class="error"><?php echo $error; ?></div>

    </td>

    </tr>

    <?php } ?>

  <tr>

    <td valign="top">
		<div class="tbl-out">
			<p class="client_table">
	    		<i class="fa fa-edit"></i>  Edit Paper Set
	    	</p>
 
    	<table width="100%" border="0" cellspacing="0" cellpadding="0" class="center-tbl  new-tbl" style="width:55%;">

           <tr>
				            <td align="right" valign="top">*Board</td>
				            <td><select name="exam_board_id" class="validate[required] selectfield require_select" onchange="showsubject(this.value)">
							<option value="">--Select Board --</option>
							<?php $board = mysql_query("select * from exam_board_master");
								
								while($bords_list=mysql_fetch_array($board))
								{
									?>
<option value="<?php echo $bords_list['id']?>" <?php if($bords_list['id']==$sql_data['exam_board_id']) { ?>selected="selected"<?php } ?>><?php echo $bords_list['name']?></option>
				              							 
				              
							  <?php } ?>
				            </select>
							</td>
				          </tr>
		 
		 <tr id="txtHint">
				            <td align="right" valign="top">*Subject</td>
				            <td><select name="subject_id" class="validate[required] selectfield require_select" onchange="showtopic(this.value)">
							<option value="subject_id">--Select subject --</option>
							<?php $subject = mysql_query("select * from exam_subject_master");
								
								while($subject_list = 	mysql_fetch_array($subject))
								{
									
									$time = strtotime($sql_data['assign_year']);
									?>

				              							 
				              <option value="<?php echo $subject_list['id']?>" <?php if($subject_list['id'] == $sql_data['subject_id']) { ?>selected="selected"<?php } ?>><?php echo $subject_list['subject']?></option>
							  <?php } ?>
				            </select>
							</td>
		</tr>
		
		
		
		
		
		
		
		
		
		
		
		<tr>
            <td align="right" valign="top" class="left_head_form">*Question Paper Name</td>
            <td><input name="paper_name" type="title" class="validate[required] textfield require_field" value="<?php echo $sql_data['paper_name']; ?>"/></td>
         </tr>
		 
		 
		 <tr>
            <td align="right" valign="top" class="left_head_form">*Year</td>
            <td><input name="assign_year" type="title" class="validate[required] textfield require_field" value="<?php echo date('Y', $time); ?>"/>[e.g 2012] </td>
         </tr>
		 
		 
		 
		
		<tr>
            <td align="right" valign="top" class="left_head_form">*Pass Marks</td>
            <td><input name="pass_marks" type="title" class="validate[required] textfield require_field" value="<?php echo $sql_data['pass_marks']; ?>"/></td>
         </tr>
		
		
		
		
		
		
        </table>

		</div>

    </td>

          </tr>
        </table>

</td>

    <td width="2%" valign="top">&nbsp;</td>

    <td width="34%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">

            <tr>
            
              <td colspan="5" align="center">
            
              <input name="submit" type="submit" value="Save" class="require float-none org" style=" margin-bottom:10px;" onclick="return Checkfiles();" />
            
              <input type="button" name="back" id="back" class="require float-none" value="Cancel" style=" margin-bottom:10px;" onclick="window.history.back();" />
            
              </td>
            
            </tr>
              
        </table>
</td>

  </tr>

</table>

</form>

<div class="clear"></div>

</div>

<?php include("includes/footer.php"); ?>