Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
cielist.php	[ DIR ]	drwxr-xr-x
system	[ DIR ]	drwxr-xr-x
CIEAttendanceNotEligible.php	3.28 KB	-rwxr-xr-x
CIEpendingList.php	2.96 KB	-rwxr-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
DisplayPrintApplication_ru.php	65.63 KB	-rwxr-xr-x
ECHblk.php	14.02 KB	-rwxr-xr-x
ECHblk_15042021.php	11.68 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MainPage.html	11.66 KB	-rwxr-xr-x
MarkEntry-Setup.php	30.56 KB	-rwxr-xr-x
MarkEntry-Setup_bf_gcg.php	22.89 KB	-rwxr-xr-x
SelectSubjType.php	3.05 KB	-rwxr-xr-x
SubjectType.php	3.64 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
UpdateCollDet.php	2.04 KB	-rwxr-xr-x
absentAndMalReportPdf.php	8.25 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	10.93 KB	-rwxr-xr-x
ack_adm_application.php	66.01 KB	-rwxr-xr-x
ack_adm_application.php.orig	58.73 KB	-rwxr-xr-x
ack_admentry_application.php	59.63 KB	-rwxr-xr-x
ack_exam_app_form.php	17.74 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.71 KB	-rwxr-xr-x
ack_report.php	3.66 KB	-rwxr-xr-x
ack_rv_rt_application.php	9.34 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
adm.php	15.4 KB	-rwxr-xr-x
adm_delete_data.php	5.58 KB	-rwxr-xr-x
admapprove.php	10.33 KB	-rwxr-xr-x
admapprove_kus.php	9.28 KB	-rwxr-xr-x
admissionHallTicket.php	1.8 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admissionapplist.php	5.06 KB	-rwxr-xr-x
admlist.php	13.87 KB	-rwxr-xr-x
admstuddate.php	6.06 KB	-rwxr-xr-x
admuploadexsheet.php	20.48 KB	-rwxr-xr-x
affliation_fee.php	5.04 KB	-rwxr-xr-x
approve.php	41.53 KB	-rwxr-xr-x
approve_kus.php	24.12 KB	-rwxr-xr-x
attCisshortList_sjbit.php	11.91 KB	-rwxr-xr-x
attEntTeachWise.php	2.07 KB	-rwxr-xr-x
attTeachSum.php	3.63 KB	-rwxr-xr-x
attendEntry.php	3.89 KB	-rwxr-xr-x
attendance.php	16 KB	-rwxr-xr-x
attendanceReportForm.php	5.81 KB	-rwxr-xr-x
attendance_freez.php	8.51 KB	-rwxr-xr-x
attendance_freez_mth.php	8.24 KB	-rwxr-xr-x
attendanceentrydaywise.php	11.36 KB	-rwxr-xr-x
attendenceshort.php	7.5 KB	-rwxr-xr-x
attshort.php	6.29 KB	-rwxr-xr-x
atttechblp.php	2.48 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.php	4.12 KB	-rwxr-xr-x
backup_1.php	7.73 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
backupold.php	2.73 KB	-rwxr-xr-x
bill_details.php	14.21 KB	-rwxr-xr-x
board.php	4 KB	-rwxr-xr-x
bundle_dispatch.php	3.2 KB	-rwxr-xr-x
bundle_rec_ack.php	4.67 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.28 KB	-rwxr-xr-x
candidate-entry.php	50.68 KB	-rwxr-xr-x
cappcontext.php	2.71 KB	-rwxr-xr-x
challan_entries.php	15.05 KB	-rwxr-xr-x
challan_preparation.php	11.29 KB	-rwxr-xr-x
changeDegree.php	1.56 KB	-rwxr-xr-x
changeMobile.php	2.13 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
cntDeclaration.php	4.23 KB	-rwxr-xr-x
coll_exam_app_form.php	3.29 KB	-rwxr-xr-x
collbankdet.php	1.9 KB	-rwxr-xr-x
colldesp_ack.php	4.03 KB	-rwxr-xr-x
college.php	5.39 KB	-rwxr-xr-x
college_approve.php	5.59 KB	-rwxr-xr-x
college_degree_status.php	5.65 KB	-rwxr-xr-x
collegewisedownload.php	9.46 KB	-rwxr-xr-x
colltransfer.php	6.83 KB	-rwxr-xr-x
connect.php	2.58 KB	-rwxr-xr-x
convdet.php	8.02 KB	-rwxr-xr-x
convo.php	8.14 KB	-rwxr-xr-x
copomarksentry.php	10.46 KB	-rwxr-xr-x
copomarksexternal.php	22.46 KB	-rwxr-xr-x
coporeport.php	4.56 KB	-rwxr-xr-x
coutput.php	1.84 KB	-rwxr-xr-x
createAdmission.php	14.75 KB	-rwxr-xr-x
createUser.php	6.93 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_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
createattclass.php	6.87 KB	-rwxr-xr-x
createclassattend.php	19.79 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	548 B	-rwxr-xr-x
cuser.php	3.53 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	6.67 KB	-rwxr-xr-x
degree.php	8.28 KB	-rwxr-xr-x
degstudymat.php	6.51 KB	-rwxr-xr-x
degstudymatdet.php	6.27 KB	-rwxr-xr-x
delegate.php	3.29 KB	-rwxr-xr-x
display_details_in_grid.php	107.06 KB	-rwxr-xr-x
display_details_in_grid_bf_231...	111.76 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.72 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
doc_verify.php	7.52 KB	-rwxr-xr-x
download_misc_files.php	5.19 KB	-rwxr-xr-x
download_misc_files_bcu_comm.p...	4.19 KB	-rwxr-xr-x
download_photo.php	35.98 KB	-rwxr-xr-x
download_photo_pgadm_photos.ph...	4.73 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
editstddet.php	4.61 KB	-rwxr-xr-x
entregupd.php	1.91 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
error_log.php	749 B	-rwxr-xr-x
examappfeereport.php	2.12 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
feepaidreports.php	2.42 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...	10.48 KB	-rwxr-xr-x
freeze_module_at_admin_college...	9.35 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
freezeiaprici.php	10.87 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getDegreeAndSem.php	4.28 KB	-rwxr-xr-x
getMessages.php	11.39 KB	-rwxr-xr-x
getdata.php	38.11 KB	-rwxr-xr-x
getdataold.php	29.62 KB	-rwxr-xr-x
getfeeinformation.php	7.26 KB	-rwxr-xr-x
getmoduledetails.php	23.77 KB	-rwxr-xr-x
getnumword.php	7.45 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
htblk.php	6.13 KB	-rwxr-xr-x
iamarks.php	7.63 KB	-rwxr-xr-x
iasectionwise.php	30.09 KB	-rwxr-xr-x
iasectionwisenew.php	34.58 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
json.php	34.52 KB	-rwxr-xr-x
kusphdadm.php	7.25 KB	-rwxr-xr-x
lateralentry.php	2.39 KB	-rwxr-xr-x
login.php	8.81 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
marksEntryExt.php	13.1 KB	-rwxr-xr-x
marksentryquestionwise.php	41.93 KB	-rwxr-xr-x
message_board.php	4.67 KB	-rwxr-xr-x
messagetext.php	1.68 KB	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	139.86 KB	-rwxr-xr-x
mregistry18.06.2021.php	99.46 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
newuser.php	2.69 KB	-rwxr-xr-x
oldqnpaper.php	4.44 KB	-rwxr-xr-x
pendingcie.php	4.17 KB	-rwxr-xr-x
pmarks.php	5.67 KB	-rwxr-xr-x
post.php	6 KB	-rwxr-xr-x
practicalMarks.php	8.65 KB	-rwxr-xr-x
princiOTPsubjectfreeze.php	3.05 KB	-rwxr-xr-x
principalFreeze.php	6.92 KB	-rwxr-xr-x
principalfreezingsubject.php	1.81 KB	-rwxr-xr-x
printApp_ru.php	1.12 KB	-rwxr-xr-x
qnwiseMarksStats.php	5.95 KB	-rwxr-xr-x
qpSummaryReport.php	1.03 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.33 KB	-rwxr-xr-x
receive_teach_trans.php	2.49 KB	-rwxr-xr-x
receive_teach_transfer.js	5.06 KB	-rwxr-xr-x
report_bulk_applications.php	19.42 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_ra_invigilator_dairy.ph...	22.93 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	8.54 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
resetPasswordUser.php	2.69 KB	-rwxr-xr-x
result.php	5.06 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	8.75 KB	-rwxr-xr-x
room_allotment_datewise.php	25.85 KB	-rwxr-xr-x
room_allotment_datewise_bf_rcu...	16.97 KB	-rwxr-xr-x
room_allotment_datewise_stph.p...	21.49 KB	-rwxr-xr-x
room_allotment_shifiting.php	3.09 KB	-rwxr-xr-x
roomcreationnew.php	2.81 KB	-rwxr-xr-x
roomdeclaration.php	2.2 KB	-rwxr-xr-x
roomdeclaration_stph.php	2.51 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
rvrt_ack_exam_app.php	5.8 KB	-rwxr-xr-x
rvrt_report.php	1.92 KB	-rwxr-xr-x
saveclsdets.php	1.91 KB	-rwxr-xr-x
savesspdetails.php	9.93 KB	-rwxr-xr-x
sectionwisepermission.php	5.62 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
sendsmsapi.php	814 B	-rwxr-xr-x
sendusrandpws.php	1002 B	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
shortLists.php	1.65 KB	-rwxr-xr-x
std_register_det.php	3.56 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
studSubIdent.php	11.23 KB	-rwxr-xr-x
stud_name_doc_upload.php	1.24 KB	-rwxr-xr-x
stud_wise_report.php	3.02 KB	-rwxr-xr-x
student.php	58.35 KB	-rwxr-xr-x
student_entry.php	61.38 KB	-rwxr-xr-x
student_entry_kswu.php	51.23 KB	-rwxr-xr-x
student_entry_nitte.php	87.54 KB	-rwxr-xr-x
student_entry_rur.php	74.42 KB	-rwxr-xr-x
student_entry_vku.php	66.58 KB	-rwxr-xr-x
student_rur.php	64.37 KB	-rwxr-xr-x
student_vku.php	57.95 KB	-rwxr-xr-x
studentportal_remove.php	6.18 KB	-rwxr-xr-x
studentreport.php	14.53 KB	-rwxr-xr-x
studnamecorr.php	6.69 KB	-rwxr-xr-x
subIAMarksEntry.php	11.14 KB	-rwxr-xr-x
subblock.php	6.12 KB	-rwxr-xr-x
subdet.php	9.61 KB	-rwxr-xr-x
subjReg.php	8.75 KB	-rwxr-xr-x
subjectList_display.php	11.7 KB	-rwxr-xr-x
subject_freshExam.php	32.99 KB	-rwxr-xr-x
subject_freshExam_rcub.php	28.33 KB	-rwxr-xr-x
subjectfreez.php	13.02 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	12.43 KB	-rwxr-xr-x
subshort.php	8.57 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	80.41 KB	-rwxr-xr-x
teachFreeze.php	8.09 KB	-rwxr-xr-x
teachOficerEntry.php	11.46 KB	-rwxr-xr-x
teachers.php	19.86 KB	-rwxr-xr-x
time_table_degreewise.php	5 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	5.11 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
updatecopo.php	9.34 KB	-rwxr-xr-x
updatedegreegroup.php	3.21 KB	-rwxr-xr-x
updateexamcnt.php	2.92 KB	-rwxr-xr-x
updatefreshexam.php	1.33 KB	-rwxr-xr-x
updatestudentsem.php	1.65 KB	-rwxr-xr-x
updatetimetable.php	9.14 KB	-rwxr-xr-x
updateuvcms.php	2.37 KB	-rwxr-xr-x
updmarks.php	16.28 KB	-rwxr-xr-x
upload_doc_demo.php	84 B	-rwxr-xr-x
upload_studentPhoto.php	10.81 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadcopo.php	7.89 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
uploadteacherattendance.php	5.23 KB	-rwxr-xr-x
userpasswordreset.php	754 B	-rwxr-xr-x
usersetup.php	24.23 KB	-rwxr-xr-x
usersetupNew.php	8.77 KB	-rwxr-xr-x
usersubj_identification.php	5.08 KB	-rwxr-xr-x
viewNotifications.php	1.21 KB	-rwxr-xr-x
view_ledger.php	3.44 KB	-rwxr-xr-x

Code Editor : attendance.php

<?php
function SaveAttendanceDetails($aobj_context)
{
    session_start();	
    include_once("/JSON.php"); 
	$json = new Services_JSON();
	include("error_log.php");
	$type = $aobj_context->mobj_data["stype"];
	$teacher_id = $aobj_context->mobj_data["teacher_id"];
	$class_id = $aobj_context->mobj_data["class_id"];
	if($type == 'AttEntTeachWise'){
		$query="select distinct fdegree,fexamno from attendsum
					  where fteachcode='{$teacher_id}' and fclassid='{$class_id}'";
		$result = $aobj_context->mobj_db->GetRow($query);
		
		$degree_code = $result["fdegree"];
		$Examno = $result["fexamno"];

}else {
		$degree_code = ($aobj_context->mobj_data["Fdegree"]);
		$Examno = ($aobj_context->mobj_data["FExamno"]);
	}
	// $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)
	{
	
		if($funivcode != '051')
		{
			$query = "select {$conducted_field} as conduct, {$attended_field} as attend
			from attend where fregno= '{$av->r}' and fdegree = '{$degree_code}'  and fexamno = '{$Examno}' 
			and fsubcode = '{$Sub_code}'";
			$res = $aobj_context->mobj_db->getRow($query);
			$conduct = $res['conduct'];
			$attend = $res['attend'];
		}	
		if($funivcode == '051')
		{
			$update="update attend set
			{$conducted_field}='{$av->c}',
			{$attended_field}='{$av->a}',
			ftotc = '{$av->c}',
			FTOTA = '{$av->a}',
			fper = IFNULL(ROUND((('$av->a'/'{$av->c}')*100),2),0),
			FENTDATE=now()
			where fregno= '{$av->r}'  and fexamno = '{$Examno}' 
			and fsubcode = '{$Sub_code}'
			and fcollcode = '{$College_Code}'";
			$lobj_insert_qry = $aobj_context->mobj_db->Execute($update);
		}else
		{
			$update="update attend set
			{$conducted_field}='{$av->c}',
			{$attended_field}='{$av->a}',
			FENTDATE=now()
			where fregno= '{$av->r}'  and fexamno = '{$Examno}' 
			and fsubcode = '{$Sub_code}'
			and fcollcode = '{$College_Code}'";
			
			$lobj_insert_qry = $aobj_context->mobj_db->Execute($update);
		}
		// die();

if($funivcode != '051')
		{
			$oldmarks =  $res['fmarks'];
						$univcode = $_SESSION['FUNIVCODE'];
						$mob = $_SESSION['FMOBILE'];
						$usr = $_SESSION['usr'];
						$college_code = $_SESSION['collcode'];
						$remark = "ATT - Attendace Entry - $degree_code, $Examno, $Sub_code, $College_Code, $month_name, Conducted: ".$av->c.", Attended: ".$av->a." Old Conducted: $conduct, Attended: ".$attend;
						$enttype = "ATT";
				
			$res = error_logs($aobj_context,$univcode,$remark,$college_code,$enttype,$usr,$mob);

$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)+IFNULL(FOVERALL_SEMC,0)
				where  fregno= '{$av->r}' and fexamno = '{$Examno}' and fsubcode = '{$Sub_code}'";

//    var_dump($query1);
				//    die();
			$results1 = $aobj_context->mobj_db->Execute($query1);
			//var_dump($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)+IFNULL(FOVERALL_SEMA,0)
				where  fregno= '{$av->r}' and fexamno = '{$Examno}' and fsubcode = '{$Sub_code}'";		
			$results2 = $aobj_context->mobj_db->Execute($query2);
			//var_dump($query2);
			$query3 = "UPDATE attend set fper = IFNULL(ROUND((IFNULL(FTOTA,0)*100)/IFNULL(FTOTC,0),2),0) 
			where  fregno= '{$av->r}' and fexamno = '{$Examno}' and fsubcode = '{$Sub_code}'";
			//var_dump($query3);		
			$results3 = $aobj_context->mobj_db->Execute($query3);
		}
	}
		// die();
	/* $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 getmonthrange($aobj_context)
// {
// 	$Degcode = $aobj_context->mobj_data["degree"];
// 	$Examno = $aobj_context->mobj_data["examno"];

// 	$funivcode = $_SESSION['FUNIVCODE'];

// 	if($funivcode == '033'){
// 		$get_records = "select 'ALL' as fattfrommth,'ALL' as fatttomth from collexam
// 					where fdegree = '{$Degcode}' and fexamno = '{$Examno}'";
// 	}else{
// 		$get_records = "select fattfrommth, fatttomth  from collexam
// 					where fdegree = '{$Degcode}' and fexamno = '{$Examno}'";
// 	}

// 	$lobj_get_record = $aobj_context->mobj_db->GetRow($get_records);
	
// 	echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_record,0,"success");
// 	return;
// }	
		
 
function GetAttendanceRegisterNumbers($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	session_start();	
	$College_Code = $_SESSION['collcode'];
	$funivcode = $_SESSION['FUNIVCODE'];	
	
	$type = $aobj_context->mobj_data["stype"];
	$teacher_id = $aobj_context->mobj_data["teacher_id"];
	$class_id = $aobj_context->mobj_data["class_id"];
	$Subcode = $aobj_context->mobj_data["Subcode"];

if($type == 'AttEntTeachWise'){
		$query="select fdegree,fexamno from attendsum 
					  where fteachcode='{$teacher_id}' and fclassid='{$class_id}'
					  ";
		$result = $aobj_context->mobj_db->GetRow($query);
		
		$Degcode = $result["fdegree"];
		$Examno = $result["fexamno"];
	}else {
		$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.'/'.$aobj_context->mobj_data["db"].'/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='95%' 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:80px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>USN</center></td>";
	$e_data.="<td  style='padding:2px; width:180px; 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 * from collexam where fdegree = '{$Degcode}' and fexamno = '{$Examno}'
	and fcollcode = '{$College_Code}' 
	and DATE_FORMAT(NOW(),'%Y-%m-%d') between DATE_FORMAT(collexam.fattfrom,'%Y-%m-%d') 
	AND DATE_FORMAT(collexam.fattto,'%Y-%m-%d')";
	
	$result = $aobj_context->mobj_db->GetAll($query);
	if ($result ==  false)
	{	
		$e_data.="<tr style='height: 20'>";
		$e_data.="<td COLSPAN=4 align = 'center'>Dates Are not enabled</td>";
		$e_data.="</tr>";	
	}else
	{
		$query = "select distinct FFREEZED from collatt where fdegree = '{$Degcode}' and fexamno = '{$Examno}' and fsubcode = '{$Subcode}' and FPERIOD = '{$month_name}'";
		// var_dump($query,"else");
		$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{
			if($type == 'AttEntTeachWise'){
				$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.FREGNO=mak.FREGNO 
				INNER JOIN subject sub ON sub.FCSUBCODE = mak.FSUBCODE and mak.fdegree = sub.fdegree 
				and mak.fexamno = sub.fexamno
				INNER JOIN degree d ON d.FDEGREE =mak.FDEGREE AND d.Fexamno=mak.Fexamno 
				AND d.FMEYEAR=mak.FYEAR AND d.FMEEXAMTYP=mak.FEXAMTYPE 
				INNER JOIN attendsum a ON a.fdegree=mak.fdegree AND a.fexamno=mak.fexamno AND a.fcollcode=mak.fcollcode
				and a.fregno =  mak.fregno 
				and a.fsubcode = mak.fsubcode 
				WHERE stu.FREGNO != '' 
				AND fclassid='{$class_id}' AND a.fteachcode='{$teacher_id}'
				and a.fcollcode = '{$College_Code}'
				and a.fsubcode = '{$Subcode}'
				GROUP BY stu.FREGNO ORDER BY stu.FREGNO  LIMIT 0, 1000";
				// var_dump($get_records);
			}
			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.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";		
			}	
			// var_dump($get_records,"get record");
			// die();	
			$lobj_get_records = $aobj_context->mobj_db->GetAll($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:98%;border:none;text-align:center;' readonly id='reg_{$k}' 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({$k});' type=text style='width:30px;text-align:center;{$border}' id='conducted_{$k}' class='ElementCount'  onkeypress='return acceptNumbersOnlyForModule(event);'     value='{$conducted}' onfocusin='changeBackgroundcolortd(this.id)' >  </td>";
				$e_data.="<td tabindex=2  align='center' style='{$border_bottom};border-right:1px solid #C5DBEC;  padding:2px;'>  <input   onblur='validateAttendedVal({$k});'  type=text style='width:30px;text-align:center;{$border}' id='attended_{$k}' class='ElementCount'  onkeypress='return acceptNumbersOnlyForModule(event);'     value='{$attended}' onfocusin='changeBackgroundcolortd(this.id)' > 
				<input type = 'hidden' id='upd_{$k}' value = 'N'>
				</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);

if($funivcode == '051')
	{
		$get_app_cand_det="insert ignore into marks (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, fmarks, fyear, fexamtype,FMODIFYDATE1)
		select c.fdegree,c.fexamno,c.fcollcode,c.fregno,
		s.fcsubcode,'-1', c.fyear,c.fexamtype,now()
		from canddet c inner join 
		subject s on c.fdegree = s.fdegree and c.fexamno = s.fexamno 
		and c.fsubcode = s.FSUBCODE	
		inner join candsum cs on c.fregno =cs.fregno
		and c.fexamno = cs.ffreshexam
		where c.fexamno = '{$Examno}' 
		and c.fcollcode = '{$College_Code}' 
		and c.fdegree = '{$Degcode}'
		and ifnull(c.fpassmth,'') = ''
		and s.fintass = 'T' and ifnull(s.FCODENO,'F') = 'F'";
		$res1 = $aobj_context->mobj_db->Execute($get_app_cand_det);

$query1 = "insert ignore into collia(fdegree,fexamno,fcollcode,fsubcode,FCREATEUSER)
		select distinct fdegree,fexamno,fcollcode,fsubcode,'A' from marks";
		$res2 = $aobj_context->mobj_db->Execute($query1);

$query = "insert ignore into attend (fcollcode, fdegree, fexamno, fsubcode,fregno,fyear, fexamtype)
		select cd.fcollcode, cd.fdegree, cd.fexamno, s.fcsubcode,cd.fregno, cd.fyear, cd.fexamtype
		from canddet cd inner join subject s on cd.fdegree = s.fdegree and cd.fexamno = s.fexamno
		and cd.fsubcode = s.fsubcode
		inner join candsum cs on cd.fregno =cs.fregno
		and cd.fexamno = cs.ffreshexam
		where cd.fcollcode = '{$College_Code}'
		and cd.fdegree = '{$Degcode}'
		and cd.fexamno = '{$Examno}'
		and ifnull(s.fattent,'F') = 'T'
		group by cd.fcollcode, cd.fdegree, cd.fexamno,cd.fregno,s.fcsubcode";
		$res2 = $aobj_context->mobj_db->Execute($query);
	}
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return; 
	
}
?>

${this.title}

Code Editor : attendance.php