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.57 KB	-rwxr-xr-x
MarkEntry-Setup22.php	19.98 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.93 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_rv_rt_application.php	7.55 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
attendance.php	6.13 KB	-rwxr-xr-x
auto-complete.php	4.89 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	42.45 KB	-rwxr-xr-x
candidate-entry1.php	37 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
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	105.05 KB	-rwxr-xr-x
display_details_in_grid22.php	101.68 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_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_photo.php	3.68 KB	-rwxr-xr-x
download_photo_12092018.php	4.1 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...	6.53 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.32 KB	-rwxr-xr-x
getdata22.php	28.7 KB	-rwxr-xr-x
getfeeinformation.php	6.14 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
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	5.52 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
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	71.94 KB	-rwxr-xr-x
mregistry22.php	59.71 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_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
rvdates.php	6.46 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
student_entry.php	36.46 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.92 KB	-rwxr-xr-x
subjectfreez.php	6.31 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	75.5 KB	-rwxr-xr-x
teachers.php	10.33 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	3.86 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 : subjectList_display.php

<?php

function displaySubjectDetails($aobj_context)
{

session_start();
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    $college_code = $_SESSION['collcode']; 
	$degree_code = $aobj_context->mobj_data["degree_code"]; 	
	$exam_code_start = $aobj_context->mobj_data["exam_code_start"]; 
	$exam_code_end = $aobj_context->mobj_data["exam_code_end"]; 
	$subjType = $aobj_context->mobj_data["subjType"]; 
	$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
	$main_src=$main_src_obj[1];
	
	if($subjType == 'SUBJECT_GENERAL')
	{
		$get_subject_data= " select if(FMANDATORY='T',concat('* ',FCSUBCODE),concat('  ',FCSUBCODE)) as FCSUBCODE , FEXAMNO,
						 concat(FSUBNAME, concat(space(3),FSSUBNAME,'(',if(FTHEORY='T','TH','PA'),')')) as SSubName,LEFT(FCSUBCODE,LENGTH(FCSUBCODE)-1) as Fsubc, 						 
						 FSHORTNAME, FSMAXMARKS,FQPCODE,CONCAT(IF(FTHEORY='T','Theory','Practical'),CONCAT(SPACE(2),IF(FINTASS='T' ,'I A' ,''))) as Remarks 
						 from subject
						 where FDEGREE='{$degree_code}' and 
						 FEXAMNO>='{$exam_code_start}' and FEXAMNO<='{$exam_code_end}'  and
						  IFNULL(FDELETED,'F') ='F' 
						 group by FCSUBCODE;
					   "; 		  
	$lobj_get_subject_data = $aobj_context->mobj_db->GetAll($get_subject_data);
	if(!empty($lobj_get_subject_data))
	{
		$e_data.="<table  align = 'center' width='100%' cellspacing='0' cellpadding='1' border='0' >";
		$e_data.="<th align='left' colspan='6' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Subject List</th>";
		$e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
		$e_data.="<td align='center' style='width:30px; font-size:12px;  border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl.<br> No.</td>";
		$e_data.="<td align='center' style='width:65px; font-size:12px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;text-align:center;'>subject<br>Code</td>";
		$e_data.="<td align='center' style='width:65px; font-size:12px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>QP.<br> Code</td>";
		$e_data.="<td align='center' style='width:305px; font-size:12px; padding:5px 5px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;text-align:left;'>Description</td>";
		$e_data.="<td align='center' style='width:55px; font-size:12px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Max. <br> Marks</td>";
		$e_data.="<td align='center' style='width:105px; font-size:12px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Remarks</td>";
		$e_data.="</tr>";
		$counter_subj = 0;
		$k=0;
		foreach($lobj_get_subject_data as $key=>$value)
		{	
					
			$e_data.="<tr class='ui-widget-content jqgrow'>";	
			if($value['Fsubc'] != $prevSubCode)
			{
					$counter_subj++;
					$e_data.="<td class='tbl_row_new' rowspan='1' style='border-bottom:0px;border-top:1px solid #C5DBEC;border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center;' >{$counter_subj}</td>";
			}
			else
			{
				$e_data.="<td class='tbl_row_new' rowspan='1' style='border-bottom:0px;border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center;' ></td>";
					
			}		
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center;' >{$value[FCSUBCODE]}</td>";	
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center;' >{$value[FQPCODE]}</td>";	
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:left;' >{$value[SSubName]}</td>";	
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:right;' >{$value[FSMAXMARKS]}</td>";
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:left;' >{$value[Remarks]}</td>";	
			$e_data.="</tr>";
			 $k++;
			 $id++;
			 $m++;
			
			 $prevSubCode =$value['Fsubc'];
		}
				$e_data.="</table>";
			$arr['total_count']= $m;						
			$arr['html']=$e_data;
			$arr['error']=0;
	}
	}
	if($subjType == 'SUBJECT_ADCL')
	{
		$get_subject_data= "  select if(FMANDATORY='T',concat('* ',FSUBCODE),concat('  ',FSUBCODE)) as FSUBCODE, 
						FEXAMNO, FSUBNAME  , FSUBSHORT,FQPCODE
						 from subject where FDEGREE='{$degree_code}' and
						FEXAMNO>='{$exam_code_start}' and FEXAMNO<='{$exam_code_end}'
						 and ifnull(FDELETED,'F')='F' group by FSUBCODE	;
					   "; 						   
	$lobj_get_subject_data = $aobj_context->mobj_db->GetAll($get_subject_data);
	if(!empty($lobj_get_subject_data))
	{
		$e_data.="<table  align = 'center' width='100%' cellspacing='0' cellpadding='1' border='0' >";
		$e_data.="<th align='left' colspan='6' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Subject List</th>";
		$e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
		$e_data.="<td align='center' style='width:30px; font-size:12px;  border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl.<br> No.</td>";
		$e_data.="<td align='center' style='width:65px; font-size:12px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>subject <br> Code</td>";
		//$e_data.="<td align='center' style='width:65px; font-size:12px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>QP Code</td>";
		$e_data.="<td align='center' style='width:305px; font-size:12px; padding:5px 5px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;text-align:left;'>Description</td>";
		$e_data.="<td align='center' style='width:65px; font-size:12px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Short Name</td>";
		$e_data.="</tr>";
		$counter_subj = 1;
		$k=0;
		foreach($lobj_get_subject_data as $key=>$value)
		{	
					
			$e_data.="<tr class='ui-widget-content jqgrow'>";	
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center;' >{$counter_subj}</td>";	
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center;' >{$value[FSUBCODE]}</td>";	
			//$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center;' >{$value[FQPCODE]}</td>";	
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:left;' >{$value[FSUBNAME]}</td>";	
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:left;' >{$value[FSUBSHORT]}</td>";	
			$e_data.="</tr>";
					 $k++;
					 $id++;
					 $m++;
					 $counter_subj++;
		}
				$e_data.="</table>";
			$arr['total_count']= $m;						
			$arr['html']=$e_data;
			$arr['error']=0;
	}
	}
	
	if($subjType == 'SUBJECT_THEORY')
	{
		$get_subject_data= " select if(FMANDATORY='T',concat('* ',FCSUBCODE),concat('  ',FCSUBCODE)) as FCSUBCODE , FEXAMNO,
						 concat(FSUBNAME, concat(space(3),FSSUBNAME,'(',if(FTHEORY='T','TH',''),')')) as SSubName,LEFT(FCSUBCODE,LENGTH(FCSUBCODE)-1) as Fsubc, 						 
						 FSHORTNAME, FSMAXMARKS,FQPCODE,CONCAT(IF(FTHEORY='T','Theory','Practical'),CONCAT(SPACE(2),IF(FINTASS='T' ,'I A' ,''))) as Remarks 
						 from subject
						 where FDEGREE='{$degree_code}' and 
						 FEXAMNO>='{$exam_code_start}' and FEXAMNO<='{$exam_code_end}'  and
						  IFNULL(FDELETED,'F') ='F' and  IFNULL(FTHEORY,'F') = 'T' AND IFNULL(FINTASS,'F') <> 'T'
						 group by FCSUBCODE;
					   "; 		  
	$lobj_get_subject_data = $aobj_context->mobj_db->GetAll($get_subject_data);
	if(!empty($lobj_get_subject_data))
	{
		$e_data.="<table  align = 'center' width='100%' cellspacing='0' cellpadding='1' border='0' >";
		$e_data.="<th align='left' colspan='6' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Subject List</th>";
		$e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
		$e_data.="<td align='center' style='width:30px; font-size:12px;  border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl.<br> No.</td>";
		$e_data.="<td align='center' style='width:65px; font-size:12px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>subject <br>Code</td>";
		$e_data.="<td align='center' style='width:65px; font-size:12px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>QP.<br>Code</td>";
		$e_data.="<td align='center' style='width:305px; font-size:12px; padding:5px 5px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;text-align:left;'>Description</td>";
		$e_data.="<td align='center' style='width:55px; font-size:12px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Max.<br> Marks</td>";
		$e_data.="<td align='center' style='width:105px; font-size:12px;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Remarks</td>";
		$e_data.="</tr>";
		$counter_subj = 1;
		$k=0;
		foreach($lobj_get_subject_data as $key=>$value)
		{	
					
			$e_data.="<tr class='ui-widget-content jqgrow'>";	
			$e_data.="<td class='tbl_row_new'  style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center;' >{$counter_subj}</td>";	
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center;' >{$value[FCSUBCODE]}</td>";	
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center;' >{$value[FQPCODE]}</td>";	
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:left;' >{$value[SSubName]}</td>";	
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:right;' >{$value[FSMAXMARKS]}</td>";
			$e_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:left;' >{$value[Remarks]}</td>";	
			$e_data.="</tr>";
			$counter_subj++;
			 $k++;
			 $id++;
			 $m++;
			
			
		}
				$e_data.="</table>";
			$arr['total_count']= $m;						
			$arr['html']=$e_data;
			$arr['error']=0;
	}
	
	
	
	
	}
	if($arr['error']==0)	
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	else
	{
		$error_msg = "Invalid Subject Code..!";
		echo $aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"success"); 
	}	
	return;		
}	
?>

${this.title}

Code Editor : subjectList_display.php