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
Ext-MarkEntry-Setup.php	21.23 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	21.15 KB	-rwxr-xr-x
MarkEntry-Setup06.06.2016.php	20.43 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
MarkEntry-Setup_28102014.php	22.99 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.3 KB	-rwxr-xr-x
absent_entry_setup_old.php	7.61 KB	-rwxr-xr-x
ack_exam_app_form.php	15.86 KB	-rwxr-xr-x
ack_exam_app_form11.php	13.87 KB	-rwxr-xr-x
ack_exam_app_form22.php	13.83 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_exam_app_form_bulk.php	12.76 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.5 KB	-rwxr-xr-x
ack_rv_rt_application01032017....	7.58 KB	-rwxr-xr-x
ack_rv_rt_application28072016....	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
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-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	2.64 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
collegewisedownload.php	5.7 KB	-rw-rw-r--
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
degree1.php	6.78 KB	-rwxr-xr-x
display_details_in_grid.php	105.31 KB	-rwxr-xr-x
display_details_in_grid0306201...	101.68 KB	-rwxr-xr-x
display_details_in_grid22.php	102.08 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_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	5.77 KB	-rw-rw-r--
download_photo_old.php	4.82 KB	-rwxr-xr-x
download_photo_sikkim_14082021...	5 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	-rwxrwxrwx
examAppchallan_entries.php	13.01 KB	-rwxr-xr-x
examAppchallan_preparation.php	9.87 KB	-rwxr-xr-x
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...	8.58 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.65 KB	-rwxr-xr-x
freeze_module_at_admin_college...	5.81 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.76 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.44 KB	-rwxr-xr-x
getdata110911.php	16.03 KB	-rwxr-xr-x
getdata22.php	28.7 KB	-rwxr-xr-x
getdata27062012.php	16.8 KB	-rwxr-xr-x
getdata_24032015.php	20.96 KB	-rwxr-xr-x
getfeeinformation.php	6.17 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	8.39 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_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
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	73.53 KB	-rwxr-xr-x
mregistry22.php	66.82 KB	-rwxr-xr-x
mregistry24042015.php	55.01 KB	-rwxr-xr-x
mregistry_16012017.php	65.48 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
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
student_entry.php	37.9 KB	-rwxr-xr-x
student_entry1307.php	37.71 KB	-rwxr-xr-x
student_entry17.06.2016.php	36.46 KB	-rwxr-xr-x
student_entry27062012.php	30.47 KB	-rwxr-xr-x
student_entry_09102019.php	33.1 KB	-rwxr-xr-x
student_entry_old_06102019.php	34.07 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	32.57 KB	-rw-rw-r--
subject_freshExam_15072022.php	28.44 KB	-rwxr-xr-x
subjectfreez.php	6.23 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
updatefreshexam.php	1.33 KB	-rw-rw-r--
upload_studentPhoto.php	10.29 KB	-rwxr-xr-x
upload_studentPhoto02062015.ph...	11.58 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.33 KB	-rwxr-xr-x
usersubj_identification.php	4.77 KB	-rwxr-xr-x

Code Editor : student_entry_old_06102019.php

<?php
/* 
 *
 * FOR THE STUDENT ENTRY FORM
 * PROGRAMED BY NAVEEN
 * DATE: 12/03/09
 * TIME: 9:45 AM 
  *
 */
session_start();
function replaceChars($name)
{
	$spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ","");
	$link_name = strtolower(str_replace($spl_char,"_",$name));
	return str_ireplace("__","_",$link_name);
}

$lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options);
				}
			}
			for($k=0;$k<count($sub_arr_data);$k++)
			{
					$insert_options="insert into options(FDEGREE,
					FEXAMNO,
					FCOLLCODE,
					FSLNO,
					FSUBCODE,
					FDELETED)
					values
					(
					'{$degree_code}',
					'{$degree_exam}',
					'{$college_code}',
					'{$degree_slno}',
					'{$sub_arr_data[$k]->sub_code}',
					'F'
					)
					";
					$lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options);
			}
					
			if($lobj_rs) 
			{
					$arr='Student Record inserted Successfully';
					 echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
					 return;
			}	
			else
			{
					$arr='Insertion Failed';
					echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
				   return;
			}
		}
		else if($add_edit=='Edit') // 
		{  
			$get_existing_data="select FPHOTOPATH from studadm where 
				FSLNO='{$degree_slno}' and 
				FDEGREE='{$degree_code}' and 
				FCOLLCODE='{$college_code}'
				and FEXAMNO='{$degree_exam}'";
			$lobj_get_existing_data = $aobj_context->mobj_db->GetRow($get_existing_data);
			$existing_photo_path= $lobj_get_existing_data[FPHOTOPATH] ;
			if(isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '')         
			{	
			 
				if(move_uploaded_file($_FILES['student_entry_upload']['tmp_name'],$full_file_path))
				{	
					$unlink_file=$aobj_context->main_src."/".$existing_photo_path;
					unlink($unlink_file);						 						 
					$existing_photo_path=$image_path;
				}
			}
					$update_qry="update studadm set
								FNAME='{$student_entry_name}',
								FFATNAME='{$degree_fname}',
								FMOTNAME='{$degree_mname}',
								FDOB='{$degree_dob}',
								FGENDER='{$degree_gender}',
								FCASTE='{$degree_category}',
								FNATIONAL='{$degree_nationality}',
								FENGLISH='{$degree_english}',
								FCURRADD1='{$degree_address_comm1}',
								FCURRADD2='{$degree_address_comm2}',
								FCURRADD3='{$degree_address_comm3}',
								FCURRADD4='{$degree_address_comm4}',
								FPERMADD1='{$degree_address_perm1}',
								FPERMADD2='{$degree_address_perm2}',
								FPERMADD3='{$degree_address_perm3}',
								FPERMADD4='{$degree_address_perm4}',
								FPHOTOPATH='{$existing_photo_path}',
								FSUBDEGREE='{$sub_degree}',
								REG_FEE='{$student_entry_reg_fee}',
								EXAM_FEE='{$student_entry_exam_fee}',
								GRADE_CARD_FEE='{$student_entry_grade_card_fee}',
								TOTAL_FEE='{$student_entry_total_fee}',
								FLATERAL_ENTRY='{$lateral_entry}',
								FREC_ORDER_NO='{$rec_order_no}',
								FREC_ORDER_DATE='{$rec_order_date}',
								FAFF_ORDER_NO='{$aff_order_no}',
								FAFF_ORDER_DATE='{$aff_order_date}',
								FRELIGION='{$religion}',
								FFAT_OCC='{$father_occ}',
								FMOT_OCC='{$mother_occ}',
								FEMAIL='{$email}',
								FCONTACT_NO='{$contact}',
								FBLOOD_GROUP='{$blood_group}',	
								FUSERID='{$u_id} ',
								FLOGNAME='{$log_name}',
								FSTUDSTATUS = '{$studentstatus}',
								FFEEDET = '{$Fee_Particular}',
								FLOGDATE=NOW() 
								where 
								FSLNO='{$degree_slno}' and 
								FDEGREE='{$degree_code}' and 
								FCOLLCODE='{$college_code}'
								and FEXAMNO='{$degree_exam}'";	//FUSERID,  FLOGNAME, FLOGDATE,

$lobj_rs = $aobj_context->mobj_db->Execute($update_qry); 		 
			$delete_from_options="delete from options 
							where FDEGREE='{$degree_code}'
							and FEXAMNO='{$degree_exam}' 
							and FCOLLCODE='{$_SESSION['collcode']}' 
							and FSLNO='{$degree_slno}'";
			$lobj_delete_from_options = $aobj_context->mobj_db->Execute($delete_from_options);
			for($k=0;$k<count($sub_arr_data);$k++)
			{
				$insert_options="insert into options(FDEGREE,
				FEXAMNO,
				FCOLLCODE,
				FSLNO,
				FSUBCODE,
				FDELETED)
				values
				(
				'{$degree_code}',
				'{$degree_exam}',
				'{$college_code}',
				'{$degree_slno}',
				'{$sub_arr_data[$k]->sub_code}',
				'F'
				)";
				$lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options);
			}	 
						
			if($lobj_rs) 
			{
				$arr='Student Record Updated Successfully';
				echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
				return;
			}	
			else
			{
				$arr='Updation Failed';
				echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
				return;
			}
		}
	 }
	 else
	 {
			$arr='Student Admission Freezed By Admin';
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
			return;		
	 }
}		
 
function disableRecord($aobj_context)
{
	session_start();
	 
	$college_code = $_SESSION['collcode'];
	$FUNIVCODE = $_SESSION['FUNIVCODE'];	
	$u_id = $_SESSION['user_id'];
	$log_name = $_SESSION['usr'];
	
	$sl_no = $aobj_context->mobj_data["sl_no"]; 
	$degree_code = $aobj_context->mobj_data["degree_code"]; 	
	$exam = $aobj_context->mobj_data["exam"]; 	
	
	include_once("/JSON.php"); 
	$json = new Services_JSON();
	
	$lstr_param = stripslashes($aobj_context->mobj_data["delete_arr"]);
	$mobj_jsondata = $json->decode($lstr_param);
	$delete_arr_data = get_object_vars($mobj_jsondata);
	
	for($k=0;$k<count($delete_arr_data);$k++)
	{	   
	    $disable_student_record = "UPDATE studadm SET FDELETED='T' 
								WHERE  FDEGREE='{$delete_arr_data[$k]->degree_code}' 
								and FEXAMNO='{$delete_arr_data[$k]->exam}'
								and FSLNO='{$delete_arr_data[$k]->sl_no}' 
								and FCOLLCODE ='{$_SESSION['collcode']}' ";	
		//var_dump($disable_student_record);
		$lobj_rs = $aobj_context->mobj_db->Execute($disable_student_record);
		if($lobj_rs)
		{
			$update = "UPDATE studadm SET FLOGNAME='{$log_name}',FLOGDATE=NOW()
								WHERE  FDEGREE='{$delete_arr_data[$k]->degree_code}' 
								and FEXAMNO='{$delete_arr_data[$k]->exam}'
								and FSLNO='{$delete_arr_data[$k]->sl_no}' 
								and FCOLLCODE ='{$_SESSION['collcode']}' ";	
		//var_dump($disable_student_record);
			$results = $aobj_context->mobj_db->Execute($update);
		}
	}
	if($lobj_rs) 
	{			
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"); 
		return;
	}	
	else
	{			
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure");
		return;
	}
	
}

function getsubjectAppearingTotal($aobj_context)
{
	 session_start();
	$degree_code = $aobj_context->mobj_data["degree_code"]; 	
	$exam = $aobj_context->mobj_data["exam"]; 	
	$sl_no = $aobj_context->mobj_data["sl_no"]; 
	$pmode = $aobj_context->mobj_data["pmode"]; 
	$sub_degree = trim($aobj_context->mobj_data["sub_degree"]); 
	$college_code=$_SESSION['collcode'];	
	$degree_code=(!empty($sub_degree))?$sub_degree:$degree_code;
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 	
	$get_sub_total=" select FTOTSUB from degree where FDEGREE= '{$degree_code}' and FEXAMNO='{$exam}'";
	$lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total);

$total_sub=$lobj_sub_total['FTOTSUB'];
		
	$get_exsting_data="	select a.*,b.FSUBNAME,b.FSUBSHORT,FMANDATORY from 
	(select FDEGREE,FEXAMNO,FCOLLCODE,FSLNO,FSUBCODE from options
	where FSLNO='{$sl_no}' and FCOLLCODE='{$_SESSION['collcode']}' 
	and FEXAMNO='{$exam}' and FDEGREE='{$degree_code}') a
	left join 
	(select s.FDEGREE,
	FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on 
	s.FDEGREE=d.FDEGREE  and  d.FEXAMNO=s.FEXAMNO
	where d.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}') b on a.FSUBCODE=b.FSUBCODE
	and a.FDEGREE=b.FDEGREE
	group by FSUBCODE limit {$total_sub}";
	$lobj_get_exsting_data = $aobj_context->mobj_db->getAll($get_exsting_data);
		 
		 
	$get_true_sub_names="select FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on 
	s.FDEGREE=d.FDEGREE  and  d.FEXAMNO=s.FEXAMNO
	where d.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' and FMANDATORY='T' group by  FSUBCODE";	
	$lobj_get_true_sub_names = $aobj_context->mobj_db->getAll($get_true_sub_names);	
	 
	$e_data.="<table  width='94%' class='tr_ventor_row' cellspacing='0' cellpadding='0' border='0' >";
	$e_data.="<tr style='font-size:12px;' class='ui-state-default ui-jqgrid-hdiv'>";		
	$e_data.="<td  style='padding:2px; width:60px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sub Code</td>";
	$e_data.="<td  style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Short Name</td>";
	$e_data.="<td  style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>";
	$e_data.="</tr>";
	$k=0;
	$id=0;
		 
	 
		if(empty($lobj_get_exsting_data))
		{
			$remaining_count=$total_sub-count($lobj_get_true_sub_names);		
			foreach($lobj_get_true_sub_names as $key=>$value)
			{
				 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow'>";
				 $e_data.="<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;'><input  tabindex=-1  {$inp_class} type=text style='width:60px;border:none;' readonly id='se_sub_code_{$id}' value='{$value[FSUBCODE]}'></td>";
				 $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:60px;' {$inp_class}  tabindex=-1  readonly id='se_short_name_{$id}' value='{$value[FSUBSHORT]}'></td>";
				 $e_data.="<td  class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:290px;' {$inp_class} id='se_sub_name_{$id}'  tabindex=-1   readonly value='{$value[FSUBNAME]}'> </td>";
				 $e_data.="</tr>";
				 $k++;
				 $id++;
			}
			$name=''; 			
			if($pmode == 0)
			{
				$last_slno_execution ="  select s.FSUBCODE, s.FSUBSHORT, s.FSUBNAME 
											from subject s inner join options d on 									
											s.FDEGREE=d.FDEGREE  and  s.FEXAMNO=d.FEXAMNO and 
											d.fsubcode = s.fsubcode and d.FCOLLCODE='{$college_code}' and
											s.fssubname != 'I.A.' and s.FMANDATORY = 'F' and
											s.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' and 
											d.fslno = 
											( select MAX(s.fslno) from studadm s 
											where s.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' 
											AND FCOLLCODE='{$college_code}' ) group by    s.FSUBCODE
										";
				$lobj_last_slno_execution = $aobj_context->mobj_db->getAll($last_slno_execution);	
			}				
			for($j=0;$j<$remaining_count;$j++)
			{				 
				if($k%2==0)
				{
					$class='tbl_row';
					$inp_class='tbl_row_input';
				}
				else
				{
					$input_class='tbl_row1'; 
					$inp_class='tbl_row1_input';
				}  
				if($j==0)
					$name="name='focus'";
				else
					$name='';
				 
				 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >";
				 $e_data.="<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name}  onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>";
				 $e_data.="<td class='tbl_row_new' align='center'  style='border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'  tabindex=-1  readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}'  ></td>";
				 $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1  readonly  style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}'  ></td>";
				 $e_data.="</tr>";
				 $k++;
				 $id++;
			}  
		}
		else
		{
			$flag=0;
			$remaining_count=$total_sub-count($lobj_get_exsting_data);
			for($h=0;$h<count($lobj_get_exsting_data);$h++)
			{
				$read_only=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?"readOnly":''; 
				$border=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?" border:none;":''; 
				$on_blur =($lobj_get_exsting_data[$h]['FMANDATORY']=='F')?" onblur='getSubDetails( this.id,{$id});' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' ":'';
				$focus_id =($lobj_get_exsting_data[$h]['FMANDATORY']=='F')?" onfocus=\$g_focus_element='se_sub_code_{$id}' ":'';
				   
				if($k%2==0)
				{
					$class='tbl_row';
					$inp_class='tbl_row_input';
				}
				else
				{
					$input_class='tbl_row1'; 
					$inp_class='tbl_row1_input';
				}
				if(($lobj_get_exsting_data[$h]['FMANDATORY']=='F') && $flag==0)
				{
					$name="name='focus'";
					$flag=1;
				}else
					$name='';
			 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >";
			 $e_data.="<td class='tbl_row_new' align='center'style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; padding:1px;'><input type='text' {$input_class} {$on_blur } {$name} {$read_only} align='center' {$focus_id} value='{$lobj_get_exsting_data[$h]['FSUBCODE']}' style = 'width:60px;{$border}'id='se_sub_code_{$id}'>  </td>";
			 $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'   {$read_only} style = 'width:60px;border:none;'  {$inp_class} value='{$lobj_get_exsting_data[$h]['FSUBSHORT']}' id='se_short_name_{$id}'></td>";
			 $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text'   {$read_only} style = 'width:290px;border:none;' {$inp_class}  value='{$lobj_get_exsting_data[$h]['FSUBNAME']}' id='se_sub_name_{$id}'></td>";
			 $e_data.="</tr>";
			 $k++;
			 $id++;
			}
			$k=0;
			for($j=0;$j<$remaining_count;$j++)
			{				 
				if($k%2==0)
				{
					$class='tbl_row';
					$inp_class='tbl_row_input';
				}
				else
				{
					$input_class='tbl_row1'; 
					$inp_class='tbl_row1_input';
				}  
				if($j==0)
					$name="name='focus'";
				else
					$name='';
				 
				 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >";
				 $e_data.="<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name}  onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>";
				 $e_data.="<td class='tbl_row_new' align='center'  style='border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'  tabindex=-1  readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}'  ></td>";
				 $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1  readonly  style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}'  ></td>";
				 $e_data.="</tr>";
				 $k++;
				 $id++;
			}
		}		
	$e_data.="</table>";
	$arr['html']=$e_data;
	$arr['table_data']=$lobj_get_true_sub_names;
	$arr['remaining_count']=$remaining_count;
	$arr['total_count']=$id;
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;  			
}

function getSubDetails($aobj_context)
{
	$degree_code = $aobj_context->mobj_data["degree_code"]; 	
	$exam = $aobj_context->mobj_data["exam"]; 	
	  	
	$field_id = $aobj_context->mobj_data["field_id"]; 	
	$icode = $aobj_context->mobj_data["icode"]; 	
	$value = $aobj_context->mobj_data["value"];

$get_true_sub_names="select'{$field_id}' as 'field_id',{$icode} as 'icode',
	FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on 
	s.FDEGREE=d.FDEGREE  and  d.FEXAMNO=s.FEXAMNO
	where d.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' and
	( FSUBCODE='{$value}' or FSUBSHORT='{$value}')";	
	$lobj_get_true_sub_names = $aobj_context->mobj_db->getRow($get_true_sub_names);	
	 
	if($lobj_get_true_sub_names) 
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_true_sub_names,0,"success"); 
		return;
	}	
	else
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($icode,-1,"Failure");
		return;
	}	 
}

/* function ViewStudentDetails($aobj_context)
{
	session_start();
	 
	$college_code = $_SESSION['collcode'];	
	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('grid_sl_no','grid_degree','grid_sub_degree','grid_exam','grid_name','created_by');
	$display_obj->display_qry="select concat(FDEGREE,FSLNO) as id, FSLNO as grid_sl_no, FDEGREE as grid_degree,FSUBDEGREE as grid_sub_degree,
						FEXAMNO as  grid_exam,
						FNAME as grid_name,
						concat(real_name,date_format(FLOGDATE,' %d-%b-%Y')) as created_by
						from studadm st left join s_sysdb s on s.internal_code=FUSERID
						where 1=1 and ifnull(st.FDELETED,'F')='F' 
						and (FREGNO='' or FREGNO is null) and FCOLLCODE='{$college_code}'";	
	$display_obj->DisplayDetailsInGrid();
} */

function ViewStudentDetails($aobj_context)
{
	session_start();
	 
	$college_code = $_SESSION['collcode'];	
	  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('grid_sl_no','grid_degree','grid_exam','grid_count');
		$display_obj->display_qry="select concat(FDEGREE,FEXAMNO) as id, FSLNO as grid_sl_no, FDEGREE as grid_degree,
						FEXAMNO as  grid_exam, count(*) as grid_count from studadm st left join s_sysdb s on s.internal_code=FUSERID
					where 1=1 and ifnull(st.FDELETED,'F')='F' 
					and (FREGNO='' or FREGNO is null) and FCOLLCODE='{$college_code}' group by FDEGREE,FEXAMNO";	
 			
		$display_obj->DisplayDetailsInGrid();
}

function ViewCourseWiseStudentDetails($aobj_context)
{
	session_start();
	 
	$college_code = $_SESSION['collcode'];	
	  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('grid_sl_no','grid_degree','grid_sub_degree','grid_exam','grid_name','created_by');
		$display_obj->display_qry="select concat(FDEGREE,FSLNO) as id, FSLNO as grid_sl_no, FDEGREE as grid_degree,FSUBDEGREE as grid_sub_degree,
						FEXAMNO as  grid_exam,
						FNAME as grid_name,
						concat(real_name,date_format(FLOGDATE,' %d-%b-%Y')) as created_by
						from 
					studadm st
					left join s_sysdb s on s.internal_code=FUSERID
					where 1=1 and ifnull(st.FDELETED,'F')='F' 
					and (FREGNO='' or FREGNO is null) and FCOLLCODE='{$college_code}'";	
 			
		$display_obj->DisplayDetailsInGrid();
}

function deleteStudentDetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$lstr_ids = $aobj_context->mobj_data["id"];	 
	
	$lstr_qry = "delete  
				from studadm 
				where internal_code in (".$lstr_ids.")"; 
	
	$lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);
}

${this.title}

Code Editor : student_entry_old_06102019.php