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
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	20.36 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	7.25 KB	-rwxr-xr-x
absent_entry_setupQp_11082017....	6.93 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.03 KB	-rwxr-xr-x
ack_exam_app_form.php	12.08 KB	-rwxr-xr-x
ack_rv_rt_application.php	7.55 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
ansbookcancel.php	9.49 KB	-rwxr-xr-x
answer_book_issued.php	10.32 KB	-rwxr-xr-x
approve.php	19.63 KB	-rwxr-xr-x
attendance.php	6.13 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.php	2.73 KB	-rwxr-xr-x
backup02122016.php	2.6 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	43.26 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	11.57 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
colldesp_ack.php	4 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.59 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.06 KB	-rwxr-xr-x
degree.php	6.51 KB	-rwxr-xr-x
display_details_in_grid.php	102.06 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.68 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	6.99 KB	-rwxr-xr-x
download_misc_files.php	3.65 KB	-rwxr-xr-x
download_photo.php	3.51 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...	7.85 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	34 KB	-rwxr-xr-x
getdata_old.php	28.74 KB	-rwxr-xr-x
getfeeinformation.php	6.14 KB	-rwxr-xr-x
getmoduledetails.php	23.7 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	10.91 KB	-rwxr-xr-x
login_16082017.php	7.69 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 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	73.35 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 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_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	7.21 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
student_entry.php	38.29 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.96 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	76.51 KB	-rwxr-xr-x
teachers.php	13.65 KB	-rwxr-xr-x
teachersOLD.php	10.33 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	3.82 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
upload_studentPhoto.php	8.02 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
usersetup.php	24.14 KB	-rwxr-xr-x
usersubj_identification.php	4.54 KB	-rwxr-xr-x

Code Editor : getdata_old.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 getExamNo($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$exam_no=trim($aobj_context->mobj_data["ExamNo"]);
	$degree=trim($aobj_context->mobj_data["degree"]);
	$get_name_by_degree_code="select  distinct  fexamno,fexamname from degree 
					where fexamno='{$exam_no}' and FDEGREE='{$degree}'";
	$lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code);
	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");
    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 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,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')";
	
	$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";
	
	$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($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') not between '{$last_date}' and '{$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}'";
			
	$result = $aobj_context->mobj_db->GetRow($query);	
	
	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");
	}
	
}

${this.title}

Code Editor : getdata_old.php