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
ECHblk.php	10.99 KB	-rwxr-xr-x
Ext-MarkEntry-Setup.php	18.68 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	25.32 KB	-rwxr-xr-x
MarkEntry-Setup03062016.php	20.02 KB	-rwxr-xr-x
MarkEntry-Setup20092016.php	20.57 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
MarkEntry-Setup_28102014.php	22.99 KB	-rwxr-xr-x
PracticalIndent.php	5.8 KB	-rw-rw-r--
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	8.27 KB	-rwxr-xr-x
absent_entry_setup_old.php	7.61 KB	-rwxr-xr-x
ack_exam_app_form.php	12.09 KB	-rwxr-xr-x
ack_exam_app_form_07032014.php	9 KB	-rwxr-xr-x
ack_exam_app_form_14032014.php	9.6 KB	-rwxr-xr-x
ack_report.php	2.75 KB	-rw-rw-r--
ack_rv_rt_application.php	7.57 KB	-rwxr-xr-x
ack_rv_rt_application_5days.ph...	7.41 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
admorder_bnu.php	14.78 KB	-rw-rw-r--
ansbookentry.php	6.33 KB	-rw-r--r--
attendance.php	6.13 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.php	3.42 KB	-rwxr-xr-x
backup_1.php	1.86 KB	-rw-rw-r--
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	43.65 KB	-rwxr-xr-x
candidate-entry1.php	37 KB	-rwxr-xr-x
candidate-entry24082012.php	33.21 KB	-rwxr-xr-x
candidate-entry_220413.php	33.21 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-entryold.php	34.55 KB	-rwxr-xr-x
cappcontext.php	3.19 KB	-rwxr-xr-x
challan_entries.php	13.34 KB	-rwxr-xr-x
challan_preparation.php	10.28 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_degree_status.php	5.86 KB	-rwxr-xr-x
connect.php	1.63 KB	-rwxr-xr-x
copomarksentry.php	10.56 KB	-rw-r--r--
copomarksexternal.php	9.13 KB	-rw-r--r--
coporeport.php	4.46 KB	-rw-r--r--
coutput.php	1.76 KB	-rwxr-xr-x
coutput_11112019.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
createattclass.php	5.22 KB	-rw-rw-r--
createclassattend.php	14.7 KB	-rw-rw-r--
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
degree1.php	6.78 KB	-rwxr-xr-x
display_details_in_grid.php	105.37 KB	-rwxr-xr-x
display_details_in_grid_240320...	98.86 KB	-rwxr-xr-x
display_details_in_grid_before...	98.71 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.68 KB	-rwxr-xr-x
display_details_in_grid_old_26...	101.67 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
download_misc_files.php	3.3 KB	-rwxr-xr-x
download_misc_files_19062014.p...	3.25 KB	-rwxr-xr-x
download_photo.php	4.17 KB	-rwxr-xr-x
download_upload.php	3.86 KB	-rwxr-xr-x
dynamicmastersdetails.php	117.45 KB	-rwxr-xr-x
dynamicmastersdetails_23.php	120 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
error_log.php	749 B	-rw-rw-r--
execute_query.php	2.5 KB	-rwxr-xr-x
execute_query27062012.php	2.51 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
ext_freeze_module_at_admin_col...	7.9 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...	7.36 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.61 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	39.04 KB	-rwxr-xr-x
getdata110911.php	16.03 KB	-rwxr-xr-x
getdata27062012.php	16.8 KB	-rwxr-xr-x
getdata_22.php	32.9 KB	-rwxr-xr-x
getdata_24032015.php	20.96 KB	-rwxr-xr-x
getdata_bf_sub_corr.php	36.29 KB	-rwxr-xr-x
getdata_new.php	34 KB	-rwxr-xr-x
getdata_old.php	28.7 KB	-rwxr-xr-x
getdata_old_26062020.php	34 KB	-rwxr-xr-x
getfeeinformation.php	6.94 KB	-rwxr-xr-x
getmoduledetails.php	23.7 KB	-rwxr-xr-x
getnumword.php	7.42 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
ia_room_allotment_datewise.php	12.13 KB	-rwxr-xr-x
iaabsententry.php	3.1 KB	-rw-rw-r--
iaroomdeclaration.php	2.6 KB	-rwxr-xr-x
iatimetable.php	7.61 KB	-rw-r--r--
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	15.95 KB	-rwxr-xr-x
login.php_1	3.25 KB	-rwxr-xr-x
login27062012.php	2.85 KB	-rwxr-xr-x
login_03032015.php	3.6 KB	-rwxr-xr-x
login_18082017.php	5.56 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
markEntry-Setup2.php	21.93 KB	-rwxr-xr-x
message_board.php	4.67 KB	-rwxr-xr-x
messagetext.php	980 B	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	103.02 KB	-rwxr-xr-x
mregistry24042015.php	55.01 KB	-rwxr-xr-x
mregistry_19102019.php	71.68 KB	-rwxr-xr-x
mregistry_before_subupdtostud_...	52.68 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
practical_marks_details.php	13.18 KB	-rwxr-xr-x
printexamform.php	11.54 KB	-rwxr-xr-x
prpendsubcnt.php	4.13 KB	-rw-r--r--
prsubcnt.php	2.68 KB	-rw-r--r--
qppattern.php	11.54 KB	-rw-r--r--
qptable_not_upd.php	1.5 KB	-rwxr-xr-x
receive_rv_rt_application.php	7.65 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 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	7.91 KB	-rwxr-xr-x
room_allotment_19102019.php	7.21 KB	-rwxr-xr-x
room_allotment_datewise.php	17.08 KB	-rwxr-xr-x
room_allotment_datewise_bf_tt....	16.11 KB	-rwxr-xr-x
room_allotment_datewise_bkp.ph...	15.71 KB	-rwxr-xr-x
roomdeclaration.php	2.2 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
savesspdetails.php	9.8 KB	-rw-rw-r--
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
studSubIdent.php	10.47 KB	-rw-rw-r--
student_entry.php	36.46 KB	-rwxr-xr-x
student_entry1307.php	37.71 KB	-rwxr-xr-x
student_entry27062012.php	30.47 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subIAMarksEntry.php	9.81 KB	-rw-rw-r--
subjectList_display.php	11.01 KB	-rwxr-xr-x
subject_freshExam.php	32.37 KB	-rwxr-xr-x
subjectfreez.php	6.21 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	9.96 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	76.57 KB	-rwxr-xr-x
teachers.php	10.33 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	4.78 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
updatecopo.php	9.34 KB	-rw-r--r--
updateexamcnt.php	2.92 KB	-rwxr-xr-x
updateqpdet.php	5.33 KB	-rw-rw-r--
upload_studentPhoto.php	10.28 KB	-rwxr-xr-x
upload_studentPhoto02062015.ph...	11.58 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadcopo.php	7.94 KB	-rw-rw-r--
uploadcopofile.php	225 B	-rw-rw-r--
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
usersetup.php	24.14 KB	-rwxr-xr-x
usersubj_identification.php	4.74 KB	-rwxr-xr-x

Code Editor : getdata_bf_sub_corr.php

<?php
function getCollegeNames($aobj_context)
{
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    $coll_code = $aobj_context->mobj_data["coll_code"]; 	
    $qry="select FCOLLCODE,concat(FCOLLNAME,', ',FTOWN) as FCOLLNAME from college where FCOLLCODE='{$coll_code}'";
    $lobj_rs = $aobj_context->mobj_db->GetRow($qry);     
	
	if($lobj_rs)	
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"); 
    else
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure");
    return;
}

function getSubjectCode($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$subject_code=trim($aobj_context->mobj_data["subject_code"]);
	$get_subject_by_subject_code="select fsubcode,Fsubshort,fsubname 
								from subject where fsubcode='{$subject_code}'
								and  fexamno='A' 
								group by fsubcode ";	
								
								
   // echo $get_subject_by_subject_code;	
	$lobj_sub_name = $aobj_context->mobj_db->GetRow($get_subject_by_subject_code);
	if($lobj_sub_name!= 0)	
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_sub_name,0,"success"); 
    else
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_sub_name,-1,"Failure");
    return;

}

function getStudentRegisterNoName($aobj_context)
{
	session_start();
	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$Regno=trim($aobj_context->mobj_data["Regno"]);
	$CollegeCode = $_SESSION['collcode'];
	$module_name_for_save = $aobj_context->mobj_data["module_name_for_save"]; 
	if($module_name_for_save=="SaveAbsentEntrySubjectwiseQP")
	{
	$get_name_by_degree_code="select fregno,fname,fdegree from student where 
				  fregno='{$Regno}'";

}
	else {
	$get_name_by_degree_code="select s.fregno,s.fname,s.fdegree,d.FDESCPN from student s inner join degree d on d.FDEGREE=s.FDEGREE where 
	fcollcode= '{$CollegeCode}'and fregno='{$Regno}'";
	}
	// echo $get_name_by_degree_code; die();
	$lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code);
	if($lobj_get_name!= 0)	
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); 
    else
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure");
    return;
	 
}

function getNextRegisterNoName($aobj_context)
{

session_start();
	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$Regno=trim($aobj_context->mobj_data["Regno"]);
	//echo $Regno; die();
	$CollegeCode = $_SESSION['collcode'];
	
	$get_name_by_degree_code="select fregno,fname from student where fcollcode= '{$CollegeCode}'and fregno>'{$Regno}' order by 1 limit 1";
	//echo $get_name_by_degree_code; die();
	$lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code);
	if($lobj_get_name!= 0)	
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); 
    else
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure");
    return;
}

function getCategoryNames($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$id=trim($aobj_context->mobj_data["id"]);
	 
	
	$get_category_names="select '{$id}' as id,FCATEGORY as internal_code,FCATEGORY as value from category ";
	 //echo $get_category_names; die();
	$lobj_get_category_names = $aobj_context->mobj_db->GetAll($get_category_names);
	if($lobj_get_category_names!= 0)	
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_category_names,0,"success"); 
    else
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_category_names,-1,"Failure");
    return;
}

function getCombinations($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$id=trim($aobj_context->mobj_data["id"]);
	 
	
	$get_category_names="select distinct '{$id}' as id,FCOMBCODE as internal_code,FCOMBDESC as value from mascomb where fdeleted <> 'T' ";
	 //echo $get_category_names; die();
	$lobj_get_category_names = $aobj_context->mobj_db->GetAll($get_category_names);
	if($lobj_get_category_names!= 0)	
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_category_names,0,"success"); 
    else
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_category_names,-1,"Failure");
    return;
}

function CheckEnteredstudentSubjectCode($aobj_context)
{
	session_start();	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$college_code = $_SESSION['collcode'];
	$Degcode=trim($aobj_context->mobj_data["degcode"]);
	$examno=trim($aobj_context->mobj_data["exam_no"]);
	$category=trim($aobj_context->mobj_data["category"]);
	$Subcode=trim($aobj_context->mobj_data["subcode"]);
	$module=trim($aobj_context->mobj_data["module"]);
	$id=trim($aobj_context->mobj_data["id"]);
	$id_split=explode("_",$id);
	$id=$id_split[3];
	$cat_cond='';

$select_category_cond = "select Value from markentrycodition 
						  where FMODULE='{$module}' and Code='{$category}' and FDELETED='F'";
	$lobj_select_category_cond = $aobj_context->mobj_db->GetRow($select_category_cond);
	
	if($lobj_select_category_cond['Value']!='0' || $lobj_select_category_cond['Value']!=0) 
		$cat_cond=" and ".$lobj_select_category_cond['Value'];	
	
	$get_name_by_degree_code=" select '{$id}' as id, FCSUBCODE,FSUBNAME,FSSUBNAME,FSHORTNAME,fvalmax as fsmaxmarks from 
								subject s inner join colldeg c on
								s.FDEGREE = c.FDEGREE 
								and s.fdegree = '{$Degcode}' and s.fexamno='{$examno}' 								
								where s.FCSUBCODE='{$Subcode}' and
								c.FCOLLCODE='{$college_code}' {$cat_cond} ";								
	$lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code);
	
	if($lobj_get_name)	
	{
		$chk_fcsubcode =  "select count(*) as count from colldeg 
							where FMESTATUS{$examno} like '%{$Subcode}%' ";
		$lobj_chk_fcsubcode = $aobj_context->mobj_db->GetRow($chk_fcsubcode);					
		if($lobj_chk_fcsubcode['count']==0)
		{
			echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); 
		}
		else
		{
			$rs_data = "Subject Freezed By Admin";
			echo $aobj_context->mobj_output->ToJSONEnvelope($rs_data,-1,"Failure");
		}
    }
	else
     {
			$rs_data =$id;
			echo $aobj_context->mobj_output->ToJSONEnvelope($rs_data,-1,"Failure");
	 }	
    return;	 
}
function getSectionName($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
	session_start();
   
	$collcode=$_SESSION['collcode']	;
	$DegCode=trim($aobj_context->mobj_data["degCode"]);
	$examNo=trim($aobj_context->mobj_data["examNo"]);
	$section=trim($aobj_context->mobj_data["section"]);
    $qry="select distinct FSECTION  from student where FCOLLCODE='{$collcode}' and FDEGREE='{$DegCode}' and 
			FEXAMNO='{$examNo}' and FSECTION='{$section}'  UNION ALL Select 'All' as FSECTION";
									
    $lobj_qp_code = $aobj_context->mobj_db->GetRow($qry);     
	
	if($lobj_qp_code)	
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_qp_code,0,"success"); 
	}
	else
	{
		$err_data="Invalid Section Code"; 	 	
		echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure");
	}
	return ;
	 
}
function markslistsubjpopup($aobj_context)
{
	session_start();	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$college_code = $_SESSION['collcode'];
	$degree=trim($aobj_context->mobj_data["degree"]);
	$exam=trim($aobj_context->mobj_data["exam"]);
	
	/* $sql="select distinct FSUBCODE, FSUBNAME from subject 
	where  FDEGREE='{$degree}' and FEXAMNO ='{$exam}'";
	//echo $get_no;
	$lobj_get_name = $aobj_context->mobj_db->GetAll($sql);
	if($lobj_get_name)	
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); 
    else
	{
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure");
	} */
	include_once($aobj_context->main_src.'/src/display_details_in_grid_custom.php');
	$display_obj = new display_details_in_grid($aobj_context);
	$display_obj->table_cols = array('FSUBCODE','FSSUBNAME');
	$display_obj->display_qry = "select distinct FSUBCODE as id,FSUBCODE,FSUBNAME from subject
	where FDEGREE='{$degree}' and FEXAMNO ='{$exam}'"; 
	//echo $display_obj->display_qry; die();										
	$display_obj->DisplayDetailsInGrid(); 
}
function getmarkslistsubjNames($aobj_context)
{
	session_start();	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$college_code = $_SESSION['collcode'];
	$subject_code=trim($aobj_context->mobj_data["subject_code"]);

$sql="select distinct FSUBCODE, FSUBNAME from subject 
	where  FSUBCODE ='{$subject_code}' ";
	//echo $get_no;
	$lobj_get_name = $aobj_context->mobj_db->GetRow($sql);
	if($lobj_get_name)	
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); 
    else
	{
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure");
	}
}

function lastdate_validate($aobj_context)
{
	session_start();	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$college_code = $_SESSION['collcode'];
	
	$screen_type = trim($aobj_context->mobj_data["screen_type"]);

$examno = trim($aobj_context->mobj_data["examno"]);
	$degree = trim($aobj_context->mobj_data["degree"]); 
	
	if($screen_type == 'IAM')
		$lstr = "ifnull(FIAFROM,'1990-01-01') AND ifnull(FIATO,'1990-01-01')";
	else if($screen_type == 'PR')
		$lstr = "ifnull(FPRFROM,'1990-01-01') AND ifnull(FPRTO,'1990-01-01')";
	else if($screen_type == 'ADM')
		$lstr = "ifnull(FADMFROM,'1990-01-01') AND ifnull(FADMTO,'1990-01-01')";
	else if($screen_type == 'EAF')
		$lstr = "ifnull(FAPPFROM,'1990-01-01') AND ifnull(FAPPTO,'1990-01-01')";
	else if($screen_type == 'HT')
		$lstr = "ifnull(FHTFROM,'1990-01-01') AND ifnull(FHTTO,'1990-01-01')";
	else if($screen_type == 'att')
		$lstr = "ifnull(fattfrom,'1990-01-01') AND ifnull(fattto,'1990-01-01')";
	$query = "select sum(case when DATE_FORMAT(NOW(),'%Y-%m-%d') not between {$lstr} then 1 else 0 end) as flastdate,
	fsuspend from collexam where fcollcode = '{$college_code}' and fdegree = '{$degree}' and fexamno = '{$examno}' group by fsuspend";
	//var_dump($query);
	$result = $aobj_context->mobj_db->GetRow($query);
/* */
	if($result['fsuspend'] == 'T')
	{	
		$arr = "This degree is suspended temporarily";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); 
	}
	else  if(strtoupper($_SESSION['user_type'])=='SUPERUSER')
	{
		$arr = '';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
	} 
	else if($result['flastdate'] > 0)
	{
		$arr = "Last date is over for the given details";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-2,"Failure");
	}
	
	else
	{
		$arr = '';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
	}
}

$query = "select sum(case when DATE_FORMAT(NOW(),'%Y-%m-%d') <> '{$last_date}' then 1 else 0 end) as flastdate 
			from practical_entry_freeze where fcollcode = '{$college_code}' and fdegree = '{$degree}' 
			and fexam = '{$examno}' and fbatch = '{$batch_no}' and fcsubcode = '{$subcode}'";
	//var_dump($query);		
	$result = $aobj_context->mobj_db->GetRow($query);	
	
	if(strtoupper($_SESSION['user_type'])=='ADMIN' || strtoupper($_SESSION['user_type'])=='SUPERUSER')
	{
		$arr = '';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
	}	
	else if($result['flastdate'] > 0)
	{
		$arr = "Practical dates are not matching.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-2,"Failure");
	}
	else
	{
		$arr = '';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
	}
	
}

function checkgeneratehtstaus($aobj_context)
{

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$regnofrom = str_pad(strtoupper(trim($aobj_context->mobj_data["regnofrom"])),8, "00000000", STR_PAD_LEFT);
	$regnoto   = str_pad(strtoupper(trim($aobj_context->mobj_data["regnoto"])),8,"ZZZZZZZZ",STR_PAD_LEFT);
	$rtype     = trim($aobj_context->mobj_data["rtype"]);
	$degcode   = trim($aobj_context->mobj_data["degcode"]);

$query = "select * From candsum where fdegree = '{$degcode}' 
		and fregno between '{$regnofrom}' and '{$regnoto}' 
		and ifnull(fhtupload,'') = 'T'";
		//var_dump($query);
	$result = $aobj_context->mobj_db->GetRow($query);
	
	if(count($result) >0)
	{
		$arr = '';	
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
	}else
	{
		$arr = 'Hall Ticket Not Uploaded. Please upload Hall Ticket';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
	}

}

function checkdateforra($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	@session_start();
	$fqpcode 	 = $aobj_context->mobj_data["fqpcode"];
	$collegeCode = $_SESSION['collcode'];

$query = "select distinct fdegree from subject where fqpcode = '{$fqpcode}'";
	$res = $aobj_context->mobj_db->GetRow($query);
	$degree = $res['fdegree'];

$query = "select * from collexam 
			where fcollcode = '{$collegeCode}' 
			and DATE_FORMAT(NOW(),'%Y-%m-%d') between DATE_FORMAT(collexam.frafrom,'%Y-%m-%d') 
			AND DATE_FORMAT(collexam.frato,'%Y-%m-%d')";
	$result = $aobj_context->mobj_db->GetAll($query);
	
	if(strtoupper($_SESSION['usr']) == 'SUPER')
	{
		$arr = "";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 1,"success");
	}
	else if ($result ==  false)
	{	
		$arr = "Exam Preparation is Not Available.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1,"success");	
	}
	else
	{
		$arr = "";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 1,"success");
	}
}

${this.title}

Code Editor : getdata_bf_sub_corr.php