Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
MarkEntry-Setup.php	22.99 KB	-rwxr-xr-x
ack_rv_rt_application.php	7.41 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
challan_entries.php	13.34 KB	-rwxr-xr-x
challan_preparation.php	10.28 KB	-rwxr-xr-x
mregistry.php	50.06 KB	-rwxr-xr-x
receive_rv_rt_application.php	7.65 KB	-rwxr-xr-x

Code Editor : MarkEntry-Setup.php

<?php
function saveMarkEntrySubjectwise($aobj_context)
{
    session_start();	
    include_once("/JSON.php"); 
	$json = new Services_JSON();
	
	$degree_code = ($aobj_context->mobj_data["Fdegree"]);
	$dsp_date = ($aobj_context->mobj_data["date"]);
	$Examno = ($aobj_context->mobj_data["FExamno"]);
	$Sub_code = ($aobj_context->mobj_data["Fsubcode"]);
	$College_Code = $_SESSION['collcode'];
	$User_code = $_SESSION['usr']; 
	$type =($aobj_context->mobj_data["type"]);  
	$g_m_1_2_type = trim($aobj_context->mobj_data["g_m_1_2_type"]);
	if(empty($g_m_1_2_type))
	$g_m_1_2_type="1";
	$fmarks_field="FMARKS";
	if($g_m_1_2_type=="2")
	$fmarks_field="FMARKS2";
	
	$lstr_param = stripslashes($aobj_context->mobj_data["output_details"]);
	$mobj_jsondata = $json->decode($lstr_param);
	$Markentry_details = get_object_vars($mobj_jsondata);	
	$total_marks_entry = count($Markentry_details);	
	
	$get_degree_exam_type="select FMEYEAR,FMEEXAMTYP
			from degree where FDEGREE='{$degree_code}'
				and FEXAMNO='{$Examno}'";
	$lobj_get_degree_exam_type = $aobj_context->mobj_db->getRow($get_degree_exam_type); 
	$FYEAR=$lobj_get_degree_exam_type[FMEYEAR];
	$FEXAMTYPE=$lobj_get_degree_exam_type[FMEEXAMTYP];
	//echo "<pre>"; print_r($Markentry_details); 
	
	//echo count($Markentry_details); die();
	$check_marksentry_freeze ="select FCMESTATUS, ifnull(FIASTOP,'') as FIASTOP from colldeg 
									where FCOLLCODE='{$College_Code}' 
									and FDEGREE='{$degree_code}' ";								
	$lobj_check_marksentry_freeze = $aobj_context->mobj_db->getRow($check_marksentry_freeze); 
	
	if($lobj_check_marksentry_freeze['FIASTOP']=='T')
	{
		$rdata='Last date is over for marks entry';
		echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
		return;	
	}
	
	if(is_null($lobj_check_marksentry_freeze['FCMESTATUS']))
	{
		for( $i = 0; $i<$total_marks_entry; $i++ )
		{
			if(!empty($Markentry_details[$i]->FRegno))
			//if(!empty($Markentry_details[$i]->FRegno) && $Markentry_details[$i]->Fmark != '-1')
			{
				/* $delete_record = " delete from marks 
									where FCOLLCODE = '{$College_Code}' and 
											FDEGREE = '{$degree_code}' and
											FEXAMNO = '{$Examno}' and
											FREGNO = '{$Markentry_details[$i]->FRegno}' and
											FSUBCODE = '{$Sub_code}' ";
				//echo $delete_record;							
				$obj_dele = $aobj_context->mobj_db->Execute($delete_record);	 */						
				
				$update_record = " update  marks 
									set 
									FPRESENT='{$Markentry_details[$i]->Fpersent}',
									{$fmarks_field}='{$Markentry_details[$i]->Fmark}',
									FLOGNAME='{$User_code}',
									FLOGDATE=NOW()								 
									where FCOLLCODE = '{$College_Code}' and 
									FDEGREE = '{$degree_code}' and
									FEXAMNO = '{$Examno}' and
									FREGNO = '{$Markentry_details[$i]->FRegno}' and
									FSUBCODE = '{$Sub_code}' ";
				//echo $delete_record;							
				$lobj_insert_qry = $aobj_context->mobj_db->Execute($update_record);							
				//echo $update_record;
				//echo mysql_error();
				//die();
				
				/* $insert_qry="insert into marks (
										FDEGREE,
										FEXAMNO,
										FCOLLCODE,
										FREGNO,
										FSUBCODE,
										FPRESENT,
										{$fmarks_field},
										FLOGNAME,
										FLOGDATE,FYEAR,FEXAMTYPE)
								values(
										'{$degree_code}',
										'{$Examno}',
										'{$College_Code}',
										'{$Markentry_details[$i]->FRegno}',
										'{$Sub_code}',
										'{$Markentry_details[$i]->Fpersent}',
										'{$Markentry_details[$i]->Fmark}',
										 '{$User_code}',
										 NOW(),'{$FYEAR}','{$FEXAMTYPE}'
									)";
				//echo $insert_qry; die();
				$lobj_insert_qry = $aobj_context->mobj_db->Execute($insert_qry); */
			}		
		}
		if($lobj_insert_qry)
		{
			$rdata = "Marks Updated Successfully";
			print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"));
			return $rdata;
		 }
		else
		{
			$rdata = "No Updation / Add..!";
			print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"));  
			return $rdata;			
		}			
	}
	else
	{
			$rdata='Mark Entry Subjectwise Freezed By Admin';
			echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return;	
	}	
}	
		
function saveMarkEntryStudentwise($aobj_context)
{
    session_start();	
    include_once("/JSON.php"); 
	$json = new Services_JSON();
	
	$dsp_date = ($aobj_context->mobj_data["date"]);
	
	$degree_code = ($aobj_context->mobj_data["Fdegree"]);
	$Examno = ($aobj_context->mobj_data["FExamno"]);
	$Reg_no = ($aobj_context->mobj_data["FRegno"]);
	$College_Code = $_SESSION['collcode'];
	$User_code = $_SESSION['usr']; 
	$type =($aobj_context->mobj_data["type"]);    
	
	$all_sub_codes =stripslashes(trim(($aobj_context->mobj_data["all_sub_codes"])));  
	$all_sub_codes=substr($all_sub_codes,0,strlen($all_sub_codes)-1);
	$lstr_param = stripslashes($aobj_context->mobj_data["output_details"]);
	$mobj_jsondata = $json->decode($lstr_param);
	$Markentry_details = get_object_vars($mobj_jsondata);
	
	//echo "<pre>"; print_r($Markentry_details); die();
	
	$check_marksentry_freeze ="  select FCMESTATUS, ifnull(FIASTOP,'') as FIASTOP from colldeg 
									where FCOLLCODE='{$College_Code}' 
									and FDEGREE='{$degree_code}'";									
	$lobj_check_marksentry_freeze = $aobj_context->mobj_db->getRow($check_marksentry_freeze); 
//echo $check_adminsion_freeze; die();
	if($lobj_check_marksentry_freeze['FIASTOP']=='T')
	{
		$rdata='Last date is over for marks entry';
		echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
		return;	
	}

if(is_null($lobj_check_marksentry_freeze['FCMESTATUS']))
	{		
		for($i = 1; $i <=count($Markentry_details); $i++ )
		{			 
			$update_qry="update marks set 
					FMARKS='{$Markentry_details[$i]->Fsecmark}',
					FPRESENT='{$Markentry_details[$i]->Fpreabs}',
					FLOGDATE=NOW()
					where FDEGREE='{$degree_code}'
					and FCOLLCODE='{$College_Code}'
					and FREGNO='{$Reg_no }'
					and FSUBCODE='{$Markentry_details[$i]->Fsubcode}'
					and FEXAMNO='{$Examno}'";
				$lobj_update_qry = $aobj_context->mobj_db->Execute($update_qry);
				//echo $update_qry;	die();
				
		}
					
	
		
			if($lobj_update_qry)
				{
					$rdata = " Details Updated Successfully.";
					print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"));
					return $rdata;
				 }
				else
				{
					$rdata = "Updation Failed.";
					print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"));  
					return $rdata;			
				}    
		
	}
	else
	{
			$rdata='Mark Entry Subjectwise Freezed By Admin';
			echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return;	
	}	
}

/*
	Programer: 	Naveen 
	Date:		30/3/2010	
	
*/
function getDisplayMarksEntrySubjectRegNos($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	session_start();	
	$College_Code = $_SESSION['collcode'];	
	$range = $aobj_context->mobj_data["range"];
	$type = $aobj_context->mobj_data["type"];
	$limit = $aobj_context->mobj_data["limit"];
	$Subcode = $aobj_context->mobj_data["Subcode"];
	$Degcode = $aobj_context->mobj_data["Degcode"];
	$Examno = $aobj_context->mobj_data["Examno"];
	$SubCategory = $aobj_context->mobj_data["SubCategory"];
	$limit_start = $aobj_context->mobj_data["limit_start"];
	$condition_name = trim($aobj_context->mobj_data["condition_name"]);
	$g_m_1_2_type = trim($aobj_context->mobj_data["g_m_1_2_type"]);
	if(empty($g_m_1_2_type))
	$g_m_1_2_type="1";
	$fmarks_field="FMARKS";
	if($g_m_1_2_type=="2")
	$fmarks_field="FMARKS2";
	 
	
	$condition_val = stripcslashes($aobj_context->mobj_data["condition_val"]);
	
	//$mycondition = ($condition_name=='like')?$condition_name." '%{$condition_val}%' ":$condition_name.$condition_val;
	$mycondition = ($condition_name=='like')?$condition_name." '%{$condition_val}%' ":$condition_name.$condition_val;
	
	
	$path = $aobj_context->main_src.'/imported_files/';
	$path_name = "imported_files/mes_{$College_Code}_{$_SESSION['user_id']}.html";
	$filename = "{$path}mes_{$College_Code}_{$_SESSION['user_id']}.html";
	
	unlink($filename);  
	$fp = fopen($filename, 'w+');		
		
	$e_data.="<table  width='80%' cellspacing='0' class='tr_ventor_row' cellpadding='0' border='0' >";
	$e_data.="<th align='left' colspan='4' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Marks List</th>";			
	$e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>";	
	$e_data.="<td  style='padding:2px; width:60px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Reg No</center></td>";
	$e_data.="<td  style='padding:2px; width:140px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Student Name</center></td>";
	$e_data.="<td  style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Marks</center></td>";
	$e_data.="<td  style='padding:2px; width:20px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Ab/Pr</center></td>";
	$e_data.="</tr>";
	
	$get_records="select fiastop from colldeg where fcollcode = '{$College_Code}' and fdegree = '{$Degcode}' 
	and instr(fiastop,'{$Examno}') > 0";
	 
	$lobj_get_records = $aobj_context->mobj_db->GetAll($get_records);
	if (count($lobj_get_records) > 0)
	{	
		$e_data.="<tr style='height: 20'>";
		$e_data.="<td COLSPAN=4 align = 'center'>Last date is over for marks entry</td>";
		$e_data.="</tr>";
	}
	else
	{
		$get_records = "select stu.FREGNO, stu.FNAME, 
		IFNULL(mak.{$fmarks_field}, -1) as FMARKS,
		IFNULL(mak.FMARKS, -1) as check_m1,
		IFNULL(mak.FPRESENT, '') AS FPRESENT
		FROM student stu inner join marks mak ON stu.fdegree = mak.fdegree and stu.FREGNO=mak.FREGNO 
		and mak.Fdegree='{$Degcode}' and mak.Fexamno='{$Examno}' and mak.FCOLLCODE='{$College_Code}'
		inner join subject sub on sub.FCSUBCODE = mak.FSUBCODE 
		inner join degree d on d.FDEGREE =mak.FDEGREE 
		and  d.Fexamno=mak.Fexamno
		and d.FMEYEAR=mak.FYEAR and d.FMEEXAMTYP=mak.FEXAMTYPE
		and sub.FCSUBCODE='{$Subcode}' and sub.FDEGREE='{$Degcode}' and sub.FEXAMNO='{$Examno}'
		WHERE stu.FREGNO != ''  and stu.FREGNO {$mycondition} 
		group by stu.FREGNO  order by stu.FREGNO limit {$limit_start}, 1000";					
	
	 
		$lobj_get_records = $aobj_context->mobj_db->GetAll($get_records);
		$k=1;
		$border_bottom="";
		foreach($lobj_get_records as $key=>$value)
		{
			$fblur_user1="";
			$fblur_user="";
			$check_m1=$value['check_m1'];
			$reg_no=$value[FREGNO];
			if($g_m_1_2_type=="2" && $check_m1==-1)
			{
				$fblur_user1=" AlertMarks1NotEntered(\"{$reg_no}\");";
				
			}
			if($g_m_1_2_type=="2" )
			{
				$fblur_user="  ValidateMarks1WithMarks2(this,{$check_m1});";
				
			}
			if($k==count($lobj_get_records))
			$border_bottom="border-bottom:1px solid #C5DBEC;";	
			$on_blur=($type=='Edit')?" onblur=\"validateEditRegNoMarks(this.id);\" ":" ";				
			$on_focus=($type=='Edit')?" onfocus=\"if(\$g_mes_edit_valid_marks_flag==0) $('#mes_marks_{$value[FREGNO]}').focus();\" ":" ";				
			$e_data.="<tr class='ui-widget-content jqgrow'>";
			$e_data.="<td tabindex=-1   align='center' style='{$border_bottom}; border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; padding:2px;'><input tabindex=-1  {$inp_class} type=text name='Regno' style='width:80px;border:none;' readonly id='reg_{$value[FREGNO]}' value='{$value[FREGNO]}'> </td>";
			$e_data.="<td tabindex=-1  align='left' style='{$border_bottom};border-right:1px solid #C5DBEC; padding:2px;' id='mes_std_name_{$value[FREGNO]}' >  {$value[FNAME]} </td>";
			$e_data.="<td tabindex=-1  align='center' style='{$border_bottom};border-right:1px solid #C5DBEC;  padding:2px;'> <input   {$inp_class} name=marks type=text style='width:30px;{$border}' {$read_only} id='mes_marks_{$value[FREGNO]}' class='ElementCount'  onkeypress='return acceptNumbersOnlyForModule(event);'  onblur = '{$fblur_user1};{$fblur_user};validateMarks(this.id);'  value='{$value[FMARKS]}' onFocus=' marksFlagCheck(this.id);'  onkeydown=return > <input type=hidden style='width:10px;{$border}' id='hidden_{$value[FREGNO]}' value='0'> </td>";
			$e_data.="<td  align='center' style='{$border_bottom};border-right:1px solid #C5DBEC;  padding:2px;'> <input tabindex=-1  {$inp_class} type=text style='width:20px;border:none;' readonly id='mes_present_{$value[FREGNO]}' {$on_focus} value='{$value[FPRESENT]}'></td>";
			$e_data.="</tr>";
			$k++;
		}
		if(empty($lobj_get_records))
		{	
			$e_data.="<tr style='height: 20'>";
			$e_data.="<td COLSPAN=4 align = 'center'>No Records Found For this Search</td>";
			$e_data.="</tr>";
		}
	}
	$e_data.="</table><br>";		
	fwrite($fp, $e_data);
	
	$arr['filenme']=$path_name;
	//$arr['table_data']=$lobj_get_records;
	
	fclose($fp); 
	
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return; 
	
}

${this.title}

Code Editor : MarkEntry-Setup.php