Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
CIEAttendanceNotEligible.php	3.28 KB	-rw-rw-r--
CIEpendingList.php	5.85 KB	-rw-rw-r--
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	-rw-rw-r--
ECHblk.php	14.61 KB	-rwxr-xr-x
ECHblk_15042021.php	11.68 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	30.6 KB	-rw-rw-r--
MarkEntry-Setup_bf_gcg.php	22.89 KB	-rwxr-xr-x
MarkEntry-Setupx.php	30.61 KB	-rwxr-xr-x
SelectSubjType.php	3.05 KB	-rw-rw-r--
SubjectType.php	3.62 KB	-rw-rw-r--
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
UpdateCollDet.php	2.03 KB	-rwxr-xr-x
absentAndMalReportPdf.php	8.25 KB	-rw-rw-r--
absentEntryYearModewise.php	991 B	-rw-rw-r--
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	11.36 KB	-rwxr-xr-x
ack_adm_application.php	103.36 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	20.27 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.71 KB	-rwxr-xr-x
ack_report.php	3.69 KB	-rwxr-xr-x
ack_rv_rt_application.php	9.34 KB	-rwxr-xr-x
actClass.php	6.21 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	4.43 KB	-rw-r--r--
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	-rwxrwxrwx
approve.php	41.53 KB	-rwxr-xr-x
approve_kus.php	24.12 KB	-rwxr-xr-x
assignUserMenu.php	13.66 KB	-rw-rw-r--
attCisshortList_sjbit.php	11.91 KB	-rw-r--r--
attEntTeachWise.php	2.07 KB	-rw-rw-r--
attEntryDaywise.php	26.9 KB	-rw-rw-r--
attTeachSum.php	3.63 KB	-rw-r--r--
attendEntry.php	5.32 KB	-rw-rw-r--
attendance.php	17.09 KB	-rwxr-xr-x
attendanceReportForm.php	6.36 KB	-rw-rw-r--
attendance_freez.php	8.51 KB	-rwxr-xr-x
attendance_freez_mth.php	8.24 KB	-rwxr-xr-x
attendanceentrydaywise.php	11.36 KB	-rw-r--r--
attendenceshort.php	7.58 KB	-rw-rw-r--
attshort.php	6.29 KB	-rwxr-xr-x
atttechblp.php	2.48 KB	-rw-r--r--
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.php	4.12 KB	-rwxr-xr-x
backup_1.php	7.85 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	-rw-rw-r--
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	-rw-rw-r--
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	-rw-rw-r--
colltransfer.php	6.83 KB	-rw-rw-r--
connect.php	2.58 KB	-rwxr-xr-x
convdet.php	8.02 KB	-rwxr-xr-x
convo.php	8.14 KB	-rw-rw-r--
copoMarksList.php	1.27 KB	-rw-rw-r--
copomarksentry.php	10.46 KB	-rw-r--r--
copomarksexternal.php	23.05 KB	-rw-r--r--
coporeport.php	4.56 KB	-rw-r--r--
courserep.php	1.68 KB	-rw-r--r--
coutput.php	1.84 KB	-rwxr-xr-x
createAdmission.php	14.91 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.99 KB	-rw-rw-r--
createclassattend.php	22.03 KB	-rw-r--r--
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
degree_SujectReport.php	893 B	-rw-rw-r--
degstudymat.php	6.51 KB	-rwxr-xr-x
degstudymatdet.php	6.27 KB	-rwxr-xr-x
degwiseIAreport.php	2.95 KB	-rw-rw-r--
display_details_in_grid.php	107.2 KB	-rw-rw-r--
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	-rw-rw-r--
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	7.01 KB	-rw-rw-r--
enableStudReg.php	7.65 KB	-rwxr-xr-x
entregupd.php	1.91 KB	-rw-rw-r--
entryexitevents.php	3.09 KB	-rwxr-xr-x
error_log.php	749 B	-rwxr-xr-x
examappfeereport.php	2.12 KB	-rw-rw-r--
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.77 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.32 KB	-rw-rw-r--
getMessages.php	11.39 KB	-rwxr-xr-x
getTestTotalMarksReport.php	11.96 KB	-rw-rw-r--
getdata.php	39.06 KB	-rwxrwxrwx
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
ia_room_allotment_datewise.php	12.13 KB	-rwxr-xr-x
iaabsententry.php	3.1 KB	-rw-r--r--
iamarks.php	7.68 KB	-rw-r--r--
iaroomdeclaration.php	2.6 KB	-rwxr-xr-x
iasectionwise.php	30.09 KB	-rw-r--r--
iasectionwisenew.php	35.77 KB	-rw-r--r--
iatimetable.php	7.61 KB	-rw-r--r--
identifyCoMarksNew.php	2.6 KB	-rw-rw-r--
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
invigilatorDairyRoomWise.php	6.07 KB	-rw-rw-r--
json.php	34.52 KB	-rwxr-xr-x
lateralentry.php	2.39 KB	-rwxr-xr-x
login.php	8.88 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
marksEntryExt.php	9.11 KB	-rwxr-xr-x
marksentryext.php	13.1 KB	-rw-rw-r--
marksentryquestionwise.php	41.93 KB	-rw-rw-r--
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	155.51 KB	-rwxr-xr-x
mregistry18.06.2021.php	99.46 KB	-rwxr-xr-x
mregistry_14092024.php	150.27 KB	-rw-rw-r--
mrn_approval.php	9 KB	-rwxr-xr-x
oldqnpaper.php	4.44 KB	-rw-rw-r--
pendingcie.php	4.21 KB	-rw-rw-r--
picharttesting.php	24.76 KB	-rw-r--r--
pmarks.php	5.97 KB	-rw-rw-r--
post.php	6 KB	-rwxr-xr-x
practicalMarks.php	8.67 KB	-rw-rw-r--
prbillreport.php	5.07 KB	-rw-r--r--
prientCodeStikers.php	6.35 KB	-rw-r--r--
principalFreeze.php	6.92 KB	-rw-rw-r--
principalfreezingsubject.php	1.9 KB	-rw-rw-r--
printAdmRegn.php	13.13 KB	-rwxr-xr-x
printApp_ru.php	1.12 KB	-rw-rw-r--
printMarkListDetailsWisenew_sj...	14.42 KB	-rw-r--r--
qnwiseMarksStats.php	6.14 KB	-rw-rw-r--
qnwisemarksentrynew.php	18.61 KB	-rw-rw-r--
qpSummaryReport.php	1.03 KB	-rw-rw-r--
receive_rv_rt_application.php	8.33 KB	-rwxr-xr-x
receive_teach_trans.php	2.49 KB	-rw-rw-r--
receive_teach_transfer.js	5.06 KB	-rw-rw-r--
remunerationEntry.php	7.14 KB	-rw-rw-r--
repeateriamarksentry.php	4.86 KB	-rw-rw-r--
report_bulk_applications.php	19.42 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 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	-rw-rw-r--
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
roomAllotment.php	37.45 KB	-rw-rw-r--
room_allotment.php	9.14 KB	-rwxr-xr-x
room_allotment_datewise.php	26.07 KB	-rwxr-xr-x
room_allotment_datewise_bf_rcu...	16.97 KB	-rwxr-xr-x
room_allotment_datewise_stph.p...	21.57 KB	-rwxr-xr-x
room_allotment_datewise_stph_n...	29.01 KB	-rwxr-xr-x
room_allotment_shifiting.php	3.34 KB	-rwxr-xr-x
roomallotmentExcel.php	8.23 KB	-rw-rw-r--
roomallotmentqpwise.php	10.22 KB	-rw-rw-r--
roomallotmentqpwisenew.php	13.92 KB	-rw-rw-r--
roomcreationnew.php	2.81 KB	-rw-rw-r--
roomdeclaration.php	2.2 KB	-rwxr-xr-x
roomdeclaration_stph.php	2.51 KB	-rwxr-xr-x
roomwiseinvigilatorsEntry.php	9.86 KB	-rw-rw-r--
rvdates.php	6.46 KB	-rw-rw-r--
rvrt_ack_exam_app.php	6 KB	-rw-rw-r--
rvrt_report.php	1.92 KB	-rw-rw-r--
savePassword.php	1.14 KB	-rw-rw-r--
saveclsdets.php	1.91 KB	-rw-rw-r--
savesspdetails.php	9.93 KB	-rw-rw-r--
sectionwisepermission.php	5.67 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	-rw-rw-r--
std_register_det.php	3.56 KB	-rw-rw-r--
stringspliter.php	693 B	-rwxr-xr-x
studSubIdent.php	11.23 KB	-rw-r--r--
stud_name_doc_upload.php	1.24 KB	-rw-rw-r--
stud_wise_report.php	3.02 KB	-rw-rw-r--
student.php	58.23 KB	-rwxr-xr-x
student_entry.php	61.39 KB	-rwxr-xr-x
student_entry_kswu.php	51.23 KB	-rwxr-xr-x
student_entry_nitte.php	88.09 KB	-rw-rw-r--
student_entry_rur.php	74.42 KB	-rw-rw-r--
student_entry_vku.php	66.58 KB	-rwxr-xr-x
student_rur.php	64.37 KB	-rw-rw-r--
student_vku.php	57.95 KB	-rwxr-xr-x
studentfeesandattiashortagedat...	11.38 KB	-rw-rw-r--
studentportal_remove.php	6.18 KB	-rwxr-xr-x
studentreport.php	15.37 KB	-rw-rw-r--
studnamecorr.php	6.69 KB	-rw-rw-r--
subIAMarksEntry.php	11.14 KB	-rw-rw-r--
subblock.php	6.12 KB	-rwxr-xr-x
subdet.php	9.61 KB	-rw-rw-r--
subjReg.php	12.04 KB	-rw-r--r--
subjectList_display.php	11.7 KB	-rwxr-xr-x
subject_freshExam.php	33.18 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.97 KB	-rw-rw-r--
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	80.41 KB	-rwxr-xr-x
teachFreeze.php	8.17 KB	-rw-r--r--
teachOficerEntry.php	11.46 KB	-rwxr-xr-x
teachers.php	19.76 KB	-rwxr-xr-x
theoryMarksEntry.php	4.89 KB	-rw-rw-r--
thvalmarks.php	2.72 KB	-rw-r--r--
time_table_degreewise.php	5 KB	-rwxrwxrwx
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	4.74 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
updatecopo.php	9.34 KB	-rw-r--r--
updatedegreegroup.php	3.21 KB	-rw-rw-r--
updateexamcnt.php	2.92 KB	-rwxr-xr-x
updatefreshexam.php	1.33 KB	-rw-rw-r--
updatestudentsem.php	2.03 KB	-rw-rw-r--
updatetimetable.php	9.14 KB	-rw-r--r--
updateuvcms.php	2.37 KB	-rw-rw-r--
updmarks.php	22.24 KB	-rw-r--r--
updnemp.php	1.78 KB	-rw-r--r--
upload_doc_demo.php	84 B	-rw-rw-r--
upload_studentPhoto.php	10.81 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadcopo.php	7.89 KB	-rw-r--r--
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
uploadteacherattendance.php	5.23 KB	-rw-r--r--
userpasswordreset.php	754 B	-rw-rw-r--
usersetup.php	24.46 KB	-rwxr-xr-x
usersetupNew.php	12.76 KB	-rw-r--r--
usersubj_identification.php	5.15 KB	-rwxr-xr-x
viewNotifications.php	1.21 KB	-rw-rw-r--
view_ledger.php	3.64 KB	-rwxrwxrwx
yearmode.php	1.83 KB	-rw-rw-r--

Code Editor : createclassattend.php

<?php
function loaddayteachcode($aobj_context)
{

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $collcode = $_SESSION['collcode'];
    $funivcode = $_SESSION['FUNIVCODE'];
	$super_wiser = $_SESSION['super_wiser'];
	$usertype = $_SESSION['user_type'];
    $usr = $_SESSION['usr'];
	
	 
    $cnd = '';
    
    if(strtolower($usertype) == 'user' && $super_wiser != 'T')
    {
        $cnd = "and m.fteachcode = '{$usr}'";
    }

if($funivcode == "097"){
        $cnd1="order by fteachname";
    }else{
        $cnd1=""; 
    }
	
    $query = "select distinct ifnull(at.fteachcode,'') as fteachcode,ifnull(m.FTEACHNAME,'') as fteachname
    from attclass at
    inner join masteach m on at.fteachcode = m.fteachcode
    where at.fcollcode = '{$collcode}'
	{$cnd} {$cnd1}";
	// var_dump($query);die();
    $result = $aobj_context->mobj_db->GetAll($query);
	
	if($result)
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); 
	}
	else
	{
		$data['msg'] = 'Faile to load';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}
}

function loadteachname($aobj_context)
{

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $collcode = $_SESSION['collcode'];
    $classname = trim($aobj_context->mobj_data["classname"]);
	$super_wiser = $_SESSION['super_wiser'];
	$usertype = $_SESSION['user_type'];
	$funivcode = $_SESSION['FUNIVCODE'];
    $usr = $_SESSION['usr'];
	
    $cnd = '';
    
    if(strtolower($usertype) == 'user' && $super_wiser != 'T')
    {
        // $query = "select fteachcode from masteach where fcollcode = '{$collcode}'
        // and fteachcode = '{$usr}'";
        // $res = $aobj_context->mobj_db->GetRow($query);   
        // $teachcode = $res['fteachcode'];
        $cnd = "and m.fteachcode = '{$usr}'";   
    }
	
	if($funivcode == "097"){
        $cnd1="order by teachname";
    }else{
        $cnd1=""; 
    }
    $query = "select distinct ifnull(at.fteachcode,'') as teachcode,ifnull(m.FTEACHNAME,'') as teachname
    from attclass at
    inner join masteach m on at.fteachcode = m.fteachcode
    where at.fcollcode = '{$collcode}'
	{$cnd} {$cnd1}";
	
    $result = $aobj_context->mobj_db->GetAll($query);
	
	if($result)
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); 
	}
	else
	{
		$data['msg'] = 'Faile to load';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}
}

function loadclassname($aobj_context)
{

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $collcode = $_SESSION['collcode'];
	$techcode = trim($aobj_context->mobj_data["techcode"]);
	
    $query = "select ifnull(fclassname,'') as fclassname,
    ifnull(fclassid,'') as fclassid  from
    attclass where fteachcode = '{$techcode}' and fcollcode = '{$collcode}' and ifnull(fdeleted,'') <> 'T'";

$result = $aobj_context->mobj_db->GetAll($query);
	
	if($result)
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); 
	}
	else
	{
		$data['msg'] = 'Faile to load';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}
}

function loadclassnameday($aobj_context)
{

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $collcode = $_SESSION['collcode'];
	$super_wiser = $_SESSION['super_wiser'];
	$usertype = $_SESSION['user_type'];
    $usr = $_SESSION['usr'];
	$teachcode = $aobj_context->mobj_data["teachcode"];
	
    $cnd = '';
    
    if(strtolower($usertype) == 'user' && $super_wiser != 'T')
    {
        // $query = "select fteachcode from masteach where fcollcode = '{$collcode}'
        // and fmobile = '{$usr}'";
        // $res = $aobj_context->mobj_db->GetRow($query);   
        
        // $teachcode = $res['fteachcode'];
        $cnd = "and fteachcode = '{$usr}'";   
    }

$query = "select ifnull(fclassname,'') as fclassname,
    ifnull(fclassid,'') as fclassid  from
    attclass where fteachcode = '{$teachcode}' and fcollcode = '{$collcode}' and ifnull(fdeleted,'') <> 'T'
	{$cnd}";

function loaddegreecreateclass($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$collcode = $_SESSION['collcode'];
	$usrtype = $_SESSION['usrtype'];
	$userId = $_SESSION['user_id'];

if($_SESSION['FUNIVCODE'] == '097')
	{
		if($usrtype == '17')
		{
			$query = "SELECT DISTINCT d.fdegree AS fdegree,
			CONCAT(d.fdegree,' - ',d.fdescpn) AS fdescpn 
			FROM degree d 
			inner join student r on d.fdegree = r.fdegree 
			inner join usersub u on u.fdegree = r.fdegree
			and u.FUSER = '{$userId}'
			where r.fcollcode = '{$collcode}'
			group by d.fdegree";
			//var_dump($query1);

}else
		{
			$query = "select ifnull(d.fdegree,'') as fdegree,ifnull(d.FDESCPN,'') as fdescpn
			from degree d 
			inner join student a on d.fdegree = a.fdegree and d.FEXAMNO = a.FEXAMNO
			where fcollcode = '{$collcode}'
			group by d.fdegree";
		}
	}else
	{
		$query = "select ifnull(d.fdegree,'') as fdegree,ifnull(d.FDESCPN,'') as fdescpn
		from degree d 
		inner join student a on d.fdegree = a.fdegree and d.FEXAMNO = a.FEXAMNO
		where fcollcode = '{$collcode}'
		group by d.fdegree";
	}
    $result = $aobj_context->mobj_db->GetAll($query);
	
	if($result)
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); 
	}
	else
	{
		$data['msg'] = 'Faile to load';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}
}

function loadsemcreateclass($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$degreecode = $aobj_context->mobj_data["degree"];
	$mode = $aobj_context->mobj_data["mode"];
	
	if($_SESSION['FUNIVCODE'] !== '021'){
		$cnd = "and d.FEXAMNO = a.FEXAMNO";
		if($mode == 'Improvement')
		{
			$cnd = "";
		}
	}else{
		$cnd = "";
	}

$query = "select ifnull(d.FEXAMNO,'') as fexamno,ifnull(d.FEXAMNAME,'') as fexamname 
    from degree d 
    inner join student a on d.fdegree = a.fdegree {$cnd}
    where d.fdegree = '{$degreecode}'
    group by d.FEXAMNO";

function loadssubcreateclass($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$degreecode = $aobj_context->mobj_data["degree"];
    $sem = $aobj_context->mobj_data["sem"];
	$collcode = $_SESSION['collcode'];
	$univcode = $_SESSION['FUNIVCODE'];
	
	$fild =	"concat(ifnull(s.FSUBNAME,''),' (',fsubshort, ')', ' - ', fssubname) as fsubname";
	
	if($univcode == '052')
		$fild =	"concat(ifnull(s.FSUBNAME,''),' - ',s.fsubshort) as fsubname";
	
	if($univcode == '052')
	{
		$query = "select ifnull(s.FCSUBCODE,'') as fsubcode,
		{$fild}
		from subject s
		inner join student a on s.FDEGREE = a.FDEGREE 
		inner join subdet su on s.fdegree = su.fdegree and 
		s.fexamno = su.fexamno and s.fsubcode = left(su.fcsubcode,4)
		where s.FDEGREE = '{$degreecode}' and s.FEXAMNO = '{$sem}'
		group by s.FSUBCODE";
		#and s.fretain = 'F'
		#and ifnull(s.fsuspend, '')<> 'T'
		#group by s.FSUBCODE
	}else if($univcode == '055')
	{
		$query = "select ifnull(s.FCSUBCODE,'') as fsubcode,
		concat(s.fsubshort,' - ',ifnull(s.FSUBNAME,''),' - ',fssubname) as fsubname
		from subject s
		inner join student a on s.FDEGREE = a.FDEGREE 
		where s.FDEGREE = '{$degreecode}' and s.FEXAMNO = '{$sem}'
		#and s.fretain = 'F'
		and ifnull(s.fsuspend, '')<> 'T'
		group by s.FSUBCODE";
		
	}
	else
	{
		$query = "select ifnull(s.FCSUBCODE,'') as fsubcode,
		{$fild}
		from subject s
		inner join student a on s.FDEGREE = a.FDEGREE 
		where s.FDEGREE = '{$degreecode}' and s.FEXAMNO = '{$sem}'
		#and s.fretain = 'F'
		and ifnull(s.fsuspend, '')<> 'T'
		group by s.FSUBCODE";
	}

//var_dump($query);die();

$result = $aobj_context->mobj_db->GetAll($query);

if($univcode == "052"){
		$cnd = "ifnull(fsectionnew,'') as fsection";
		$cnd1 = "";
	}else{
		$cnd = "ifnull(FSECTION,'') as fsection";
		$cnd1 = "and ifnull(FSECTION,'') <> ''";
	}

$query1 = "select distinct  {$cnd}
	from student 
	where fcollcode = '{$collcode}' and FDEGREE = '{$degreecode}' {$cnd1}";

$result1 = $aobj_context->mobj_db->GetAll($query1);
	
	if($result)
	{
		$arr['sub'] = $result;
		$arr['sec'] = $result1;
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	}
	else
	{
		$data['msg'] = 'Faile to load';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}
}

function loadteachercreateclass($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $collcode = $_SESSION['collcode'];	
    $query = "select ifnull(FTEACHCODE,'') as fteachcode,ifnull(FTEACHNAME,'') as fteachname
    from masteach
    where fcollcode = '{$collcode}'";

$result = $aobj_context->mobj_db->GetAll($query);

if($result)
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); 
	}
	else
	{
		$data['msg'] = 'Failed to load';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}
}

function viewcreateclass($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $collcode = $_SESSION['collcode'];
    $degreecode = $aobj_context->mobj_data["degree"];
    $sem = $aobj_context->mobj_data["sem"];
    $sub = $aobj_context->mobj_data["sub"];	
    $classname = $aobj_context->mobj_data["fclassid"];
	$mode = $aobj_context->mobj_data["mode"];
    $teachcode = $aobj_context->mobj_data["teachcode"];
    $fclassid = $aobj_context->mobj_data["fclassid"];
	$section = $aobj_context->mobj_data["section"];
	$univcode = $_SESSION['FUNIVCODE'];

if($section == 'All'){
		$cnd = "";
	}else{
		if($univcode == '052'){
			$cnd = "and s.fsection = '{$section}'";
		}else{
			$cnd = "and s.fsection = '{$section}'";
		}
	}

$cnd1 = "";
	$cnd2 = "";
	$cnd3 = "and s.fexamno = '{$sem}'";

if($mode == 'Improvement')
	{
		$cnd1 = "inner join regfee r on s.fregno = r.fregno and r.FSUBCODE = '{$sub}'";
		$cnd3 = "";
	}

$orderby = "order by s.fregno";
	if($univcode == '049' || $univcode == '097')
		$orderby = "order by s.fname";

if($univcode != '021' && $mode != 'Improvement'  && $univcode != '098' && $univcode != 'P023' && $univcode != 'P005' )
	{
		$query = "select count(*) as cnt from regcanddet where fcollcode = '{$collcode}'
		and fdegree = '{$degreecode}' and fexamno = '{$sem}' and fsubcode = left('{$sub}',4)";
		
		$res1 = $aobj_context->mobj_db->GetRow($query);

if($res1['cnt'] > 0)
		{

}else
		{
			$data['msg'] = 'Subjects are not attached. kindly do subject registration';
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
			return;
		}
	}

if($univcode == '021'  || $univcode == '098' || $univcode == 'P023' || $univcode == 'P005')
	{
		$query = "select distinct ifnull(s.fregno,'') as fregno,ifnull(s.FNAME,'') as fname, 
		if(ifnull(a.fregno,'') <> '' ,'T','F') as fstatus 
		from student s 
		{$cnd1}
		left join attendsum a on s.fregno = a.fregno 
		and s.fdegree = a.fdegree 
		and s.fexamno = a.fexamno 
		and s.fcollcode = a.fcollcode 
		and a.fclassid = '{$classname}'
		where s.fdegree = '{$degreecode}' 
		and s.FCOLLCODE = '{$collcode}' 
		and ifnull(s.fdeleted,'') <> 'T'
		$cnd
		$cnd3
		{$orderby}";

}else if($mode == 'Improvement')
	{
		$query = "select distinct ifnull(s.fregno,'') as fregno,ifnull(s.FNAME,'') as fname, 
		if(ifnull(a.fregno,'') <> '' ,'T','F') as fstatus 
		from student s 
		{$cnd1}
		left join attendsum a on s.fregno = a.fregno and s.fdegree = a.fdegree 
		and s.fexamno = a.fexamno 
		and s.fcollcode = a.fcollcode 
		and a.fclassid = '{$classname}'
		where s.fdegree = '{$degreecode}' 
		and s.FCOLLCODE = '{$collcode}' 
		and ifnull(s.fdeleted,'') <> 'T'
		$cnd
		{$orderby}";
	}
	else
	{
		if($univcode == '097')
		{
			$query = "select distinct ifnull(s.fregno,'') as fregno,ifnull(s.FNAME,'') as fname, 
			if(ifnull(a.fregno,'') <> '' ,'T','F') as fstatus 
			from student s 
			inner join regcanddet cd on s.fregno = cd.fregno
			and cd.fdegree = s.fdegree and cd.fcollcode = s.fcollcode
			inner join regcandsum cs on cd.fregno = cs.fregno
			{$cnd1}
			left join attendsum a on s.fregno = a.fregno and s.fdegree = a.fdegree and s.fexamno = a.fexamno 
			and s.fcollcode = a.fcollcode 
			and a.fclassid = '{$classname}'
			where s.fdegree = '{$degreecode}' 
			and s.FCOLLCODE = '{$collcode}' 
			and left(cd.fsubcode,4) = left('{$sub}',4)
			and ifnull(s.fdeleted,'') <> 'T'
			and ifnull(cs.ffreez,'') = 'T'
			{$cnd3}
			$cnd
			{$orderby}";
		}else
		{
	
			$query = "select distinct ifnull(s.fregno,'') as fregno,ifnull(s.FNAME,'') as fname, 
			if(ifnull(a.fregno,'') <> '' ,'T','F') as fstatus 
			from student s 
			inner join regcanddet cd on s.fregno = cd.fregno
			and cd.fdegree = s.fdegree and cd.fcollcode = s.fcollcode
			{$cnd1}
			left join attendsum a on s.fregno = a.fregno and s.fdegree = a.fdegree and s.fexamno = a.fexamno 
			and s.fcollcode = a.fcollcode 
			and a.fclassid = '{$classname}'
			where s.fdegree = '{$degreecode}' 
			and s.FCOLLCODE = '{$collcode}' 
			and left(cd.fsubcode,4) = left('{$sub}',4)
			and ifnull(s.fdeleted,'') <> 'T'
			{$cnd3}
			$cnd
			{$orderby}";
		}

}

// var_dump($query);die();

$result = $aobj_context->mobj_db->GetAll($query);

if($result)
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); 
	}
	else
	{
		$data['msg'] = 'No Data Found';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}
}

function savecreateclass($aobj_context)
{

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $collcode = $_SESSION['collcode'];
	$univcode = $_SESSION['FUNIVCODE'];
	include("error_log.php");
	$usr = $_SESSION['usr'];
	$mob = $_SESSION['FMOBILE'];

$degreecode = $aobj_context->mobj_data["degree"];
    $sem = $aobj_context->mobj_data["sem"];
    $sub = $aobj_context->mobj_data["sub"];	
	$mode = $aobj_context->mobj_data["mode"];
    $classname = $aobj_context->mobj_data["classname"];
    $teachcode = $aobj_context->mobj_data["teachcode"];

$fclassid = $aobj_context->mobj_data["fclassid"];
	$section = $aobj_context->mobj_data["section"];

$_data = $aobj_context->mobj_data["data"];
    $data = json_decode($_data,true);

$secCond = "";
	if($univcode == "049"){
		if($section === "All" || $section === ""){
			$data['msg'] = 'select the section';
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
			return;
		}
		$secCond = "and fsection='{$section}'";
	}

$qry="select distinct ifnull(fclassid, '')as fclassid from attendsum where fsubcode='{$sub}' 
		  and fteachcode='{$teachcode}' and fdegree = '{$degreecode}'";
		
	$res = $aobj_context->mobj_db->GetRow($qry);
	// if(count($res)===1 && $res['fclassid'] != $fclassid){
	// 	$data['msg'] = 'Subject already added to the different classnames';
	// 	echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	// 	return;
	// }
// and fdegree = '{$degreecode}'
	$qry="select ifnull(fclassid, '')as fclassid from attendsum 
	where  fteachcode='{$teachcode}' and fsubcode='{$sub}' and fexamno='{$sem}' 
	{$secCond}";
	$res = $aobj_context->mobj_db->GetRow($qry);

// if(count($res)===1 && $res['fclassid'] !== $fclassid){
	// 	$data['msg'] = 'Students already added to the different classname';
	// 	echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	// 	return;
	// }

$qrtype = "select ifnull(fatyear,'') as fyear,ifnull(fatexamtype,'') as fexamtype,
	FMEYEAR, FMEEXAMTYP
	from degree
	where FDEGREE = '{$degreecode}' and FEXAMNO = '{$sem}'";

$resqrtype = $aobj_context->mobj_db->GetRow($qrtype);
  
	$fyear = $resqrtype['fyear'];
	$fexamtype = $resqrtype['fexamtype'];
	$FMEYEAR = $resqrtype['FMEYEAR'];
	$FMEEXAMTYP = $resqrtype['FMEEXAMTYP'];

if (!empty($_SERVER['HTTP_CLIENT_IP']))   
			{
				$ip_address = $_SERVER['HTTP_CLIENT_IP'];
			}
			else if (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))  
			{
				$ip_address = $_SERVER['HTTP_X_FORWARDED_FOR'];
			}
			else
			{
				$ip_address = $_SERVER['REMOTE_ADDR'];
			}

$univcode = $_SESSION['FUNIVCODE'];
	$mob = $_SESSION['FMOBILE'];
	$usr = $_SESSION['usr'];
	$college_code = $_SESSION['collcode'];
	
    foreach($data as $key => $val){

$regno = $val['regno'];

if($val['classid'] == 'T'){  
			$str = "ADD STUDENTS TO CLASS: CLASSID : $fclassid, THEACHERCODE : $teachcode, REGNO: $regno,SUBJECT : $sub";
			$remark = $str;
			$enttype = "ATTA";
			$res = error_logs($aobj_context,$univcode,$remark,$college_code,$enttype,$usr,$mob);

$Insertquery = "insert ignore into attendsum (fclassid,fcreatedate,fteachcode,fcollcode,fdegree,fexamno,fsubcode,fclassname,fregno,fyear,fexamtype,fsection,fmode,fdeleted)
			values('{$fclassid}',now(),'{$teachcode}','{$collcode}','{$degreecode}','{$sem}','{$sub}','{$classname}','{$val['regno']}','{$fyear}','{$fexamtype}','{$section}','{$mode}','F')";
			$resupdquery = $aobj_context->mobj_db->Execute($Insertquery);

}else{

$str = "DELETE STUDENTS TO CLASS: CLASSID : $fclassid, THEACHERCODE : $teachcode, REGNO : $regno,SUBJECT : $sub";
			$remark = $str;
			$enttype = "ATTD";
			$res = error_logs($aobj_context,$univcode,$remark,$college_code,$enttype,$usr,$mob);
			
            $updquery = "DELETE FROM attendsum 
			WHERE fregno='{$val['regno']}'
			and fclassid = '{$fclassid}'
			and fteachcode = '{$teachcode}'
			and fcollcode = '{$collcode}'
			and fdegree = '{$degreecode}'
			and fexamno = '{$sem}'
			and fsubcode = '{$sub}'
			and fclassname = '{$classname}'
			and fsection = '{$section}'";

$resupdquery = $aobj_context->mobj_db->Execute($updquery);

// $Insertquery = "insert ignore into marksint(fcollcode,fexamno,fdegree,fregno,fsubcode,fyear,fexamtype)
			// select a.fcollcode,a.fexamno,a.fdegree,a.fregno,concat(s.fcsubcode,s.fsubcode),'{$FMEYEAR}','{$FMEEXAMTYP}' from attendsum a 
			// inner join degree d on a.fdegree = d.fdegree and a.fexamno = d.fexamno
			// inner join subdet s on a.fdegree = s.fdegree and s.fexamno = a.fexamno
			// and left(s.fcsubcode,4) = left(a.fsubcode,4)
			// where d.fexamno = '{$sem}'
			// and d.fdegree = '{$degreecode}'";

// $res = $aobj_context->mobj_db->Execute($Insertquery);

// $Insertquery = "INSERT IGNORE INTO attend(FDEGREE, FEXAMNO, FCOLLCODE, fregno, FSUBCODE, FYEAR, FEXAMTYPE,FCREATEDATE)
			// SELECT DISTINCT a.FDEGREE, a.FEXAMNO, a.FCOLLCODE,a.fregno, s.FcSUBCODE, '{$FMEYEAR}','{$FMEEXAMTYP}',now() 
			// FROM subject s 
			// INNER JOIN attendsum a ON  a.fdegree = s.fdegree
			// AND a.fsubcode = s.fcsubcode
			// WHERE a.fdegree LIKE '{$degreecode}'
			// AND a.fexamno = '{$sem}'
			// GROUP BY a.FDEGREE,a.fregno,s.FSUBCODE";
			// $res = $aobj_context->mobj_db->Execute($Insertquery);
			
        }
        
    }

$Insertquery = "insert ignore into marksint(fcollcode,fexamno,fdegree,fregno,fsubcode,fyear,fexamtype)
	select a.fcollcode,a.fexamno,a.fdegree,a.fregno,concat(s.fcsubcode,s.fsubcode),'{$FMEYEAR}','{$FMEEXAMTYP}' from attendsum a 
	inner join degree d on a.fdegree = d.fdegree and a.fexamno = d.fexamno
	inner join subdet s on a.fdegree = s.fdegree and s.fexamno = a.fexamno
	and left(s.fcsubcode,4) = left(a.fsubcode,4)
	where d.fexamno = '{$sem}'
	and d.fdegree = '{$degreecode}'";
	// var_dump($Insertquery);die();
	$res = $aobj_context->mobj_db->Execute($Insertquery);

$Insertquery = "INSERT IGNORE INTO attend(FDEGREE, FEXAMNO, FCOLLCODE, fregno, FSUBCODE, FYEAR, FEXAMTYPE,FCREATEDATE)
	SELECT DISTINCT a.FDEGREE, a.FEXAMNO, a.FCOLLCODE,a.fregno, s.Fcsubcode, '{$FMEYEAR}','{$FMEEXAMTYP}',now() 
	FROM subject s 
	INNER JOIN attendsum a ON  a.fdegree = s.fdegree
	AND a.fsubcode = s.fcsubcode
	WHERE a.fdegree LIKE '{$degreecode}'
	AND a.fexamno = '{$sem}'
	GROUP BY a.FDEGREE,a.fregno,s.FSUBCODE";
	$res = $aobj_context->mobj_db->Execute($Insertquery);

if($resupdquery)
	{
        $data['msg'] = 'Save Successfully...!';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
	}
	else
	{
		$data['msg'] = 'Faile to Save';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}
}

function viewStuds($aobj_context)
{

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$collcode = $_SESSION['collcode'];

$usertype = $_SESSION['user_type'];
    $usr = $_SESSION['usr'];
	
    $cnd = '';

if(strtolower($usertype) == 'user' && strtolower($_SESSION['super_wiser']) !== 't')
    {
        $cnd = "and a.fteachcode = '{$usr}'";   
    }

$query = "select ifnull(a.fteachcode,'') as fteachcode,ifnull(m.fteachname,'') as fteachname,
	ifnull(a.fclassid,'') as fclassid,
	ifnull(ac.fclassname,'') as fclassname,
	count(a.fclassid) as count from attendsum a
	inner join masteach m on m.fteachcode = a.fteachcode
	and m.fcollcode = a.fcollcode
	left join attclass ac on a.fclassid = ac.fclassid
	where a.fcollcode = '{$collcode}' $cnd
	group by a.fclassid";

function viewAddClassstuds($aobj_context)
{

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$collcode = $_SESSION['collcode'];
    $teachcode = $aobj_context->mobj_data["teachcode"];
	$fclassid = $aobj_context->mobj_data["fclassid"];

$usertype = $_SESSION['user_type'];
    $usr = $_SESSION['usr'];
	
    $cnd = '';

if(strtolower($usertype) == 'user' && strtolower($_SESSION['super_wiser']) !== 't')
    {
        $cnd = "and a.fteachcode = '{$usr}'";   
    }

$query = "select ifnull(a.fclassid,'') as fclassid ,
	ifnull(a.fregno,'') as fregno,ifnull(s.FNAME,'') as fname,
	ifnull(a.fdeleted, '')as fdeleted
	from attendsum a
	inner join student s on a.fregno = s.fregno
	where a.fcollcode = '{$collcode}' and a.fclassid = '{$fclassid}'  $cnd";

${this.title}

Code Editor : createclassattend.php