Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
Dispatch_ans_script_setup.php	5.84 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.18 KB	-rwxr-xr-x
DownloadExamAppFormApplication...	5.12 KB	-rwxr-xr-x
ECHblk.php	11.06 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	20.57 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
TAGMAY2013.pdf	331.03 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.71 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	6.91 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	8.04 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admissionapplist.php	9.9 KB	-rwxr-xr-x
approve.php	19.63 KB	-rwxr-xr-x
attendance.php	10.23 KB	-rwxr-xr-x
attendance_31072017.php	6.59 KB	-rwxr-xr-x
attendance_freez.php	8.46 KB	-rwxr-xr-x
attendance_freez03012017.php	8.37 KB	-rwxr-xr-x
attendance_freez_mth.php	8.24 KB	-rwxr-xr-x
attendance_freez_old.php	8.21 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.php	2.6 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
batch_close.php	4.29 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	44.23 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	2.64 KB	-rwxr-xr-x
challan_entries.php	15.31 KB	-rwxr-xr-x
challan_preparation.php	11.58 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
college.php	4.61 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxr-xr-x
college_approve.php	5.61 KB	-rwxr-xr-x
college_degree_status.php	5.65 KB	-rwxr-xr-x
connect.php	2.1 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
create_all_grid_files.php	8.57 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	9.94 KB	-rwxr-xr-x
create_all_grid_group_files_ol...	9.61 KB	-rwxr-xr-x
create_all_popup_files.php	5.93 KB	-rwxr-xr-x
create_all_schema_files.php	4.31 KB	-rwxr-xr-x
create_all_views.php	16.52 KB	-rwxr-xr-x
create_html_files.php	52.03 KB	-rwxr-xr-x
create_html_files_without_tab....	44.49 KB	-rwxr-xr-x
create_module_meta_columns.php	5.16 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	4.86 KB	-rwxr-xr-x
degree.php	6.51 KB	-rwxr-xr-x
display_details_in_grid.php	105.15 KB	-rwxr-xr-x
display_details_in_grid0812201...	102.95 KB	-rwxr-xr-x
display_details_in_grid22.php	104.89 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.59 KB	-rwxr-xr-x
display_details_in_grid_studta...	96.56 KB	-rwxr-xr-x
display_details_in_grid_withde...	97.45 KB	-rwxr-xr-x
display_details_in_gridold.php	102.19 KB	-rwxr-xr-x
doc_verify.php	6.99 KB	-rwxr-xr-x
downloadFeeStatement.php	4.71 KB	-rwxr-xr-x
download_misc_files.php	3.65 KB	-rwxr-xr-x
download_photo.php	4.71 KB	-rwxr-xr-x
download_photo01202017.php	3.58 KB	-rwxr-xr-x
download_uploadsikkim.php	3.86 KB	-rwxr-xr-x
dynamicmastersdetails.php	117.45 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
execute_query.php	2.5 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.64 KB	-rwxr-xr-x
freeze_module_at_admin_college...	8.22 KB	-rwxr-xr-x
freeze_module_at_admin_college...	6.92 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.81 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getdata.php	33.4 KB	-rwxr-xr-x
getdata08052017.php	33.04 KB	-rwxr-xr-x
getdata08122016.php	32.65 KB	-rwxr-xr-x
getdata22.php	32.82 KB	-rwxr-xr-x
getdataold.php	28.7 KB	-rwxr-xr-x
getfeeinformation.php	7.12 KB	-rwxr-xr-x
getfeeinformation_24112018.php	6.95 KB	-rwxr-xr-x
getmoduledetails.php	24.56 KB	-rwxr-xr-x
getnumword.php	7.43 KB	-rwxr-xr-x
getreportdetails.php	3.21 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.37 KB	-rwxr-xr-x
getsearchcondition.php	1.3 KB	-rwxr-xr-x
ggridmodel.php	9.27 KB	-rwxr-xr-x
golden_palm_payslip.php	12.48 KB	-rwxr-xr-x
helptext.php	5.38 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	7.67 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
mascomb.php	10.02 KB	-rwxr-xr-x
message_board.php	4.67 KB	-rwxr-xr-x
messagetext.php	953 B	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	89.5 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
printexamform.php	11.54 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.08 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	11.84 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
revaluation.php	16.66 KB	-rwxr-xr-x
revaluation_oldtype.php	8.45 KB	-rwxr-xr-x
revaluation_withdegree.php	16.77 KB	-rwxr-xr-x
room_allotment.php	15.46 KB	-rwxr-xr-x
room_allotment22.php	14.04 KB	-rwxr-xr-x
room_allotment_.php	15.24 KB	-rwxr-xr-x
room_allotment_12092017.php	15.22 KB	-rwxr-xr-x
room_allotment_20112017.php	15.25 KB	-rwxr-xr-x
room_allotment_datewise.php	15.84 KB	-rwxr-xr-x
room_allotment_datewise_150220...	16.87 KB	-rwxr-xr-x
room_allotment_datewise_151129...	18.29 KB	-rwxr-xr-x
room_allotment_datewise_old.ph...	18.29 KB	-rwxr-xr-x
room_allotment_new16012017.php	14.02 KB	-rwxr-xr-x
room_allotment_newformat120920...	15.25 KB	-rwxr-xr-x
room_allotment_oldd.php	9.24 KB	-rwxr-xr-x
room_allotment_qpcodewise.php	9.56 KB	-rwxr-xr-x
roomdeclaration.php	1.81 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
servfeehead.php	3.84 KB	-rwxr-xr-x
services.php	3.47 KB	-rwxr-xr-x
sfeehead.php	5.45 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
student_entry.php	32.52 KB	-rwxr-xr-x
student_entry24.php	56.54 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subjectList_display.php	11.01 KB	-rwxr-xr-x
subject_freshExam.php	18.94 KB	-rwxr-xr-x
subjectfreez.php	12.98 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	76.51 KB	-rwxr-xr-x
teachers.php	14.63 KB	-rwxr-xr-x
teachersOLD.php	10.33 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	4.79 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
upload_studentPhoto.php	10.12 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
usersetup.php	24.35 KB	-rwxr-xr-x
usersetupold.php	24.36 KB	-rwxr-xr-x
usersubj_identification.php	4.77 KB	-rwxr-xr-x

Code Editor : getdata08052017.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 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')";
	
	$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') <> '{$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");
	}
	
}

${this.title}

Code Editor : getdata08052017.php