Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
Dispatch_ans_script_setup.php	5.84 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.18 KB	-rwxr-xr-x
DownloadExamAppFormApplication...	5.12 KB	-rwxr-xr-x
ECHblk.php	11.06 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	21.12 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
TAGMAY2013.pdf	331.03 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.71 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	6.89 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.03 KB	-rwxr-xr-x
ack_exam_app_form.php	15.88 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.55 KB	-rwxr-xr-x
ack_exam_app_form_old.php	12.52 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.28 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admissionapplist.php	9.9 KB	-rwxr-xr-x
approve.php	19.81 KB	-rwxr-xr-x
attendance.php	9.29 KB	-rwxr-xr-x
attendance_freez.php	8.46 KB	-rwxr-xr-x
attendance_freez_old.php	8.55 KB	-rwxr-xr-x
attshort.php	6.29 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.php	2.73 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
bundle_dispatch.php	2.84 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate-entry.php	42.85 KB	-rwxr-xr-x
candidate-entry_without_iapr_i...	34.88 KB	-rwxr-xr-x
candidate-entrybefore yearexam...	34.55 KB	-rwxr-xr-x
candidate-entrykus.php	33.23 KB	-rwxr-xr-x
candidate-entrynewformat.php	44.16 KB	-rwxr-xr-x
candidate-entryold.php	34.55 KB	-rwxr-xr-x
cappcontext.php	3.19 KB	-rwxr-xr-x
challan_entries.php	15.31 KB	-rwxr-xr-x
challan_preparation.php	11.58 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
college.php	4.61 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxr-xr-x
college_approve.php	5.61 KB	-rwxr-xr-x
college_degree_status.php	5.65 KB	-rwxr-xr-x
connect.php	2.11 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
create_all_grid_files.php	8.57 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	9.94 KB	-rwxr-xr-x
create_all_grid_group_files_ol...	9.61 KB	-rwxr-xr-x
create_all_popup_files.php	5.93 KB	-rwxr-xr-x
create_all_schema_files.php	4.31 KB	-rwxr-xr-x
create_all_views.php	16.52 KB	-rwxr-xr-x
create_html_files.php	52.03 KB	-rwxr-xr-x
create_html_files_without_tab....	44.49 KB	-rwxr-xr-x
create_module_meta_columns.php	5.16 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	4.86 KB	-rwxr-xr-x
degree.php	6.51 KB	-rwxr-xr-x
display_details_in_grid.php	104.96 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.59 KB	-rwxr-xr-x
display_details_in_grid_studta...	96.56 KB	-rwxr-xr-x
display_details_in_grid_withde...	97.45 KB	-rwxr-xr-x
display_details_in_gridold.php	102.19 KB	-rwxr-xr-x
doc_verify.php	6.99 KB	-rwxr-xr-x
downloadFeeStatement.php	4.71 KB	-rwxr-xr-x
download_misc_files.php	4.59 KB	-rwxr-xr-x
download_misc_files_old.php	4.3 KB	-rwxr-xr-x
download_photo.php	4.17 KB	-rwxr-xr-x
download_photo_sikkim.php	4.82 KB	-rwxr-xr-x
download_photoold.php	3.58 KB	-rwxr-xr-x
download_upload.php	3.86 KB	-rwxr-xr-x
dynamicmastersdetails.php	117.45 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
execute_query.php	2.5 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.64 KB	-rwxr-xr-x
freeze_module_at_admin_college...	8.36 KB	-rwxr-xr-x
freeze_module_at_admin_college...	6.92 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.81 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getdata.php	33.37 KB	-rwxr-xr-x
getdataold.php	28.7 KB	-rwxr-xr-x
getfeeinformation.php	6.95 KB	-rwxr-xr-x
getmoduledetails.php	24.56 KB	-rwxr-xr-x
getnumword.php	7.43 KB	-rwxr-xr-x
getreportdetails.php	3.21 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.37 KB	-rwxr-xr-x
getsearchcondition.php	1.3 KB	-rwxr-xr-x
ggridmodel.php	9.27 KB	-rwxr-xr-x
golden_palm_payslip.php	12.48 KB	-rwxr-xr-x
helptext.php	5.38 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	9.45 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
mascomb.php	10.02 KB	-rwxr-xr-x
message_board.php	4.67 KB	-rwxr-xr-x
messagetext.php	953 B	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	89.5 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
pclzip.lib.php	192.53 KB	-rwxr-xr-x
printexamform.php	11.54 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.08 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	11.84 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
revaluation.php	16.66 KB	-rwxr-xr-x
revaluation_oldtype.php	8.45 KB	-rwxr-xr-x
revaluation_withdegree.php	16.77 KB	-rwxr-xr-x
room_allotment.php	15.16 KB	-rwxr-xr-x
room_allotmentnew.php	9.24 KB	-rwxr-xr-x
room_allotmentold.php	15.27 KB	-rwxr-xr-x
roomdeclaration.php	1.8 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
servfeehead.php	3.84 KB	-rwxr-xr-x
services.php	3.47 KB	-rwxr-xr-x
sfeehead.php	5.45 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
student.php	43.89 KB	-rwxr-xr-x
student_entry.php	34.27 KB	-rwxr-xr-x
student_entry24.php	56.54 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subjectList_display.php	11.01 KB	-rwxr-xr-x
subject_freshExam.php	18.94 KB	-rwxr-xr-x
subjectfreez.php	12.98 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	9.95 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	76.53 KB	-rwxr-xr-x
teachers.php	13.78 KB	-rwxr-xr-x
teachersOLD.php	10.33 KB	-rwxr-xr-x
teachersnew.php	16.83 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	4.79 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
upload_studentPhoto.php	10.12 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
upload_studentPhoto_pending.ph...	8.29 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
uploadzip.php	8.46 KB	-rwxr-xr-x
usersetup.php	24.33 KB	-rwxr-xr-x
usersetupold.php	24.36 KB	-rwxr-xr-x
usersubj_identification.php	4.77 KB	-rwxr-xr-x

Code Editor : attendance.php

<?php
function SaveAttendanceDetails($aobj_context)
{
    session_start();	
    include_once("/JSON.php"); 
	$json = new Services_JSON();
	
	$degree_code = ($aobj_context->mobj_data["Fdegree"]);
	$Examno = ($aobj_context->mobj_data["FExamno"]);
	$Sub_code = ($aobj_context->mobj_data["Fsubcode"]);
	$month_name = ($aobj_context->mobj_data["month_name"]);
	$College_Code = $_SESSION['collcode'];
	$funivcode = $_SESSION['FUNIVCODE'];
	$User_code = $_SESSION['usr']; 
	$conducted_field="  F{$month_name}C  ";
	$attended_field="  F{$month_name}A  ";
	
	$lstr_param = stripslashes($aobj_context->mobj_data["output_details"]);
	$mobj_jsondata = $json->decode($lstr_param);
	$att_details = get_object_vars($mobj_jsondata);	
	
	foreach($att_details as $ak=>$av)
	{
		$update="update attend set
		{$conducted_field}='{$av->c}',
		{$attended_field}='{$av->a}',
		FENTDATE=now()
		where fintcode={$ak}";
		$lobj_insert_qry = $aobj_context->mobj_db->Execute($update);
		
		$query1 = "update attend set ftotc =  IFNULL(FJANC,0)+IFNULL(FFEBC,0)+IFNULL(FMARC,0)+IFNULL(FAPRC,0)+IFNULL(FMAYC,0)+IFNULL(FJUNC,0)
			 +IFNULL(FJULC,0)+IFNULL(FAUGC,0)+IFNULL(FSEPC,0)+IFNULL(FOCTC,0)+IFNULL(FNOVC,0)+IFNULL(FDECC,0)
			   where  fintcode={$ak}";	
		$results1 = $aobj_context->mobj_db->Execute($query1);

$query2 = "update attend set FTOTA =  IFNULL(FJANA,0)+IFNULL(FFEBA,0)+IFNULL(FMARA,0)+IFNULL(FAPRA,0)+IFNULL(FMAYA,0)+IFNULL(FJUNA,0)
			+IFNULL(FJULA,0)+IFNULL(FAUGA,0)+IFNULL(FSEPA,0)+IFNULL(FOCTA,0)+IFNULL(FNOVA,0)+IFNULL(FDECA,0)
			where  fintcode={$ak}";		
		$results2 = $aobj_context->mobj_db->Execute($query2);

$query3 = "UPDATE attend set fper = IFNULL(ROUND((IFNULL(FTOTA,0)*100)/IFNULL(FTOTC,0),0),0) 
		where  fintcode={$ak}";		
		$results3 = $aobj_context->mobj_db->Execute($query3);
	}
		
	/* $query1 = "update attend set ftotc =  IFNULL(FJANC,0)+IFNULL(FFEBC,0)+IFNULL(FMARC,0)+IFNULL(FAPRC,0)+IFNULL(FMAYC,0)+IFNULL(FJUNC,0)
			 +IFNULL(FJULC,0)+IFNULL(FAUGC,0)+IFNULL(FSEPC,0)+IFNULL(FOCTC,0)+IFNULL(FNOVC,0)+IFNULL(FDECC,0)
			   where fdegree ={$degree_code} and fexamno = '{$Examno}' and fsubcode = '{$Sub_code}'";	
	$results1 = $aobj_context->mobj_db->Execute($query1);
	
	$query2 = "update attend set FTOTA =  IFNULL(FJANA,0)+IFNULL(FFEBA,0)+IFNULL(FMARA,0)+IFNULL(FAPRA,0)+IFNULL(FMAYA,0)+IFNULL(FJUNA,0)
			+IFNULL(FJULA,0)+IFNULL(FAUGA,0)+IFNULL(FSEPA,0)+IFNULL(FOCTA,0)+IFNULL(FNOVA,0)+IFNULL(FDECA,0)
			where fdegree ={$degree_code} and fexamno = '{$Examno}' and fsubcode = '{$Sub_code}'";		
	$results2 = $aobj_context->mobj_db->Execute($query2);
	
	$query3 = "UPDATE attend set fper = IFNULL(ROUND((IFNULL(FTOTA,0)*100)/IFNULL(FTOTC,0),0),0) 
	where fdegree ={$degree_code} and fexamno = '{$Examno}' and fsubcode = '{$Sub_code}'";		
	$results3 = $aobj_context->mobj_db->Execute($query3); */
	
	if($funivcode == '017')
	{
		$get_studentInfo = "SELECT DISTINCT fcollcode, fdegree,fregno FROM attend 
							WHERE fdegree = '{$degree_code}' AND fexamno = '{$Examno}' 
							and fsubcode = '{$Sub_code}' and ifnull(fper,0) < 75
							ORDER BY fcollcode,fdegree,fexamno";
		$lobj_get_studentInfo = $aobj_context->mobj_db->getAll($get_studentInfo);
		
		if($lobj_get_studentInfo > 0)
		{
			$query ="delete from attshort where fdegree = '{$degree_code}' AND fexamno = '{$Examno}'  and fsubcode = '{$Sub_code}'";
			$results = $aobj_context->mobj_db->Execute($query);
			//var_dump($query);
			$query = "insert into attshort
					(select fdegree,fexamno,fsubcode,fregno,'Shortage of Attendance. Not Eligilble' from attend 
					where fdegree = '{$degree_code}' AND fexamno = '{$Examno}'  and fsubcode = '{$Sub_code}' and ifnull(fper,0) < 75)";
			$results = $aobj_context->mobj_db->Execute($query);
			//var_dump($query);
		}
	}
	
	if($lobj_insert_qry)
	{
		$rdata = "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;			
	}			
	 	
}	
		
 
function GetAttendanceRegisterNumbers($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	session_start();	
	$College_Code = $_SESSION['collcode'];	
 
	$Subcode = $aobj_context->mobj_data["Subcode"];
	$Degcode = $aobj_context->mobj_data["Degcode"];
	$Examno = $aobj_context->mobj_data["Examno"];
	$Section = $aobj_context->mobj_data["Section"];
	$month_name = $aobj_context->mobj_data["month_name"];
	$conducted_field=" ifnull(F{$month_name}C,0) ";
	$attended_field=" ifnull(F{$month_name}A,0) ";
	$path = $aobj_context->main_src.'/imported_files/';
	$path_name = "imported_files/att_{$College_Code}_{$_SESSION['user_id']}.html";
	$filename = "{$path}att_{$College_Code}_{$_SESSION['user_id']}.html";
	
	if($Section =='All')
		$Section_query ='';
	else
		$Section_query ="and stu.FSECTION ='{$Section}'";
		
	unlink($filename);  
	$fp = fopen($filename, 'w+');		
		
	$e_data.="<table  width='75%' 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;'>Attendance Entry</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:20px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Classes Conducted</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>Classes Attended</center></td>";
	$e_data.="</tr>";
	$query = "select distinct FFREEZED from collatt where fdegree = '{$Degcode}' and fexamno = '{$Examno}' and fsubcode = '{$Subcode}' and FPERIOD = '{$month_name}'";
	$results = $aobj_context->mobj_db->GetRow($query);
	
	if($results['FFREEZED'] == 'T')
	{
		$e_data.="<tr style='height: 20'>";
		$e_data.="<td COLSPAN=4 align = 'center'>Attendance entry freezed for given details.</td>";
		$e_data.="</tr>";
	}else
	{
		$get_records = "SELECT mak.fintcode,stu.FREGNO, stu.FNAME ,
		{$conducted_field} as conducted, 	 
		{$attended_field} as attended  	 
		FROM student stu 
		INNER JOIN attend 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 != '' {$Section_query}
		group by stu.FREGNO  order by stu.FREGNO limit 0, 1000";					
		$lobj_get_records = $aobj_context->mobj_db->GetAll($get_records);
		//var_dump($get_records);
		$k=1;
		$border_bottom="";
		
		foreach($lobj_get_records as $key=>$value)
		{
			$fintcode=$value['fintcode'];
			$conducted=$value['conducted'];
			$attended=$value['attended'];
			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   onblur='AssignAttendanceNextTdConductedVal({$fintcode});' type=text style='width:30px;text-align:center;{$border}' id='conducted_{$fintcode}' class='ElementCount'  onkeypress='return acceptNumbersOnlyForModule(event);'     value='{$conducted}'  >  </td>";
			$e_data.="<td tabindex=2 align='center' style='{$border_bottom};border-right:1px solid #C5DBEC;  padding:2px;'>  <input   onblur='validateAttendedVal({$fintcode});'  type=text style='width:30px;text-align:center;{$border}' id='attended_{$fintcode}' class='ElementCount'  onkeypress='return acceptNumbersOnlyForModule(event);'     value='{$attended}'  > </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 : attendance.php