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
PrintApplicationFormPOSTOFFICE...	26.92 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
ack_exam_app_form.php	12.29 KB	-rwxr-xr-x
ack_exam_app_form_21042018.php	12.08 KB	-rwxr-xr-x
ack_registration.php	7.77 KB	-rwxr-xr-x
ack_rv_rt_application.php	7.58 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_reg.php	39.89 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
applicationFormReportPOSTOFFIC...	25.93 KB	-rwxr-xr-x
attendance.php	6.13 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.php	2.84 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	2.68 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
code39.php	6.38 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.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.65 KB	-rwxr-xr-x
degree.php	6.51 KB	-rwxr-xr-x
display_details_in_grid.php	102.22 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_misc_files23022017.ph...	3.3 KB	-rwxr-xr-x
download_photo.php	3.68 KB	-rwxr-xr-x
download_photo_05022019.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	29.59 KB	-rwxr-xr-x
getfeeinformation.php	6.95 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.72 KB	-rwxr-xr-x
login.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	83.69 KB	-rwxr-xr-x
mregistry_17052018.php	74.08 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
push_data_to_studentportal.php	1.8 KB	-rwxr-xr-x
receive_rv_rt_application.php	7.65 KB	-rwxr-xr-x
report_hall_ticket.php	11.18 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
rotation.php	596 B	-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	48.35 KB	-rwxr-xr-x
student_entry_12092018.php	48.35 KB	-rwxr-xr-x
student_entry_wait_25062018.ph...	48.3 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
studentportal_remove.php	6.18 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	75.52 KB	-rwxr-xr-x
teachers.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	10.12 KB	-rwxr-xr-x
upload_studentPhoto_13112017.p...	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 : student_entry_12092018.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);
}

/* $query = "select count(FSLNO) as slncnt from studadm
		where  studadm.FDEGREE='{$degree_code}' and studadm.FCOLLCODE='{$college_code}' and ifnull(studadm.FDELETED,'') <> 'T'";
		$rst = $aobj_context->mobj_db->getRow($query);
		
		$slnocnt = $rst['slncnt'];
		$get_generateAutoIncrementSlNo = "select if({$slnocnt} >= ifnull(FINTAKE,0),'9999',right(concat('0000',ifnull(max(FSLNO),0)+01),4))  as  FSLNO, 
		ifnull(colldeg.FINTAKE,0) as FINTAKE   from studadm,colldeg					
		where  studadm.FDEGREE = colldeg.FDEGREE and studadm.FCOLLCODE = colldeg.FCOLLCODE
		and studadm.FDEGREE='{$degree_code}' and studadm.FCOLLCODE='{$college_code}'";
		$lobj_get_generateAutoIncrementSlNo = $aobj_context->mobj_db->getRow($get_generateAutoIncrementSlNo);
		
		$degree_slno = $lobj_get_generateAutoIncrementSlNo[FSLNO];
		$degree_intake = $lobj_get_generateAutoIncrementSlNo[FINTAKE]; */

}
	$unlink_file=trim($aobj_context->mobj_data["unlink_file"]);
	//if($unlink_file!="images/default_photo.jpg")
	//unlink($aobj_context->main_src.'/'.$unlink_file);
	
	
	include_once("/JSON.php"); 
	$json = new Services_JSON();
	 
	$lstr_param = stripslashes($aobj_context->mobj_data["sub_arr"]);
	$mobj_jsondata = $json->decode($lstr_param);
	$sub_arr_data = get_object_vars($mobj_jsondata);
	$fee_com_param = stripslashes($aobj_context->mobj_data["fee_com"]);
	$mobj_fee_com_param = $json->decode($fee_com_param);
	$fee_arr_data = get_object_vars($mobj_fee_com_param);
	 
	
/* 	$check_adminsion_freeze ="  select FCADSTATUS, ifnull(fadmstop,'') as FADMSTOP from colldeg 
									where FCOLLCODE='{$college_code}' 
									and FDEGREE='{$degree_code}'";								
	$lobj_check_adminsion_freeze = $aobj_context->mobj_db->getRow($check_adminsion_freeze); */ 
	
	$qry = "select * from collexam where fdegree = '{$degree_code}' and fcollcode = '{$college_code}' and fexamno = 'A'
			and DATE_FORMAT(NOW(),'%Y-%m-%d') 
			BETWEEN DATE_FORMAT(fadmfrom,'%Y-%m-%d') 
			AND DATE_FORMAT(fadmto,'%Y-%m-%d')";
	$student_exam_details = $aobj_context->mobj_db->GetRow($qry);
	
	
	/* if($lobj_check_adminsion_freeze['FADMSTOP']=='T')
	{
		$arr='Last date for student admission is over';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
		return;		
	}
	
	if($degree_slno =='9999')
	{
		$arr='Reached maximum student admission intake';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
		return;		
	} */
	if(count($student_exam_details) <= 0) //if($lobj_check_adminsion_freeze['FADMSTOP']=='T')
	{
		$arr='Last date for student admission is over';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
		return;		
	}
	else
	{
		$college_path=$aobj_context->main_src."/student_photos/{$college_code}";
		$folder_path=$aobj_context->main_src."/student_photos/{$college_code}/".replaceChars($degree_code);
		 $file_name=basename($_FILES['student_entry_upload']['name']);
					$path_arr=pathinfo($_FILES['student_entry_upload']['name']);
					$file_ext=$path_arr['extension'];
		$full_file_path= $folder_path.'/'.$f_year.'_'.$degree_slno."_".$file_name;;
		$image_path="student_photos/{$college_code}/".replaceChars($degree_code).'/'.$f_year.'_'.$degree_slno."_".$file_name;;
		$curl_photo_path = "/student_photos/{$college_code}/".replaceChars($degree_code);
		$curl_rename = $f_year.'_'.$degree_slno."_".$file_name;
		//student_entry_upload
		if(!file_exists($college_path))
		{
		 mkdir($college_path);
		}if(!file_exists($folder_path))
		{
		 mkdir($folder_path);
		}
		//echo $check_adminsion_freeze; die();
	//	var_dump($lobj_check_adminsion_freeze); die();
		
		$query = "select FADMPREFIX from control";
		$results = $aobj_context->mobj_db->getRow($query);
	 	$FADMPREFIX = $results['FADMPREFIX'];

$query = "select FAUTOINCREMENT from studadm 
	 	order by FAUTOINCREMENT desc limit 1";
	 	$results = $aobj_context->mobj_db->getRow($query);
	 	$FAUTOINCREMENT = $results['FAUTOINCREMENT'];

if(is_null($lobj_check_adminsion_freeze['FCADSTATUS']))
		{
		
			if($add_edit=='Add')
			{
				$photo_path="";
				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))
				 	{
					 	$photo_path=$image_path;
				 	}
				}
				$appno = $FADMPREFIX.$FAUTOINCREMENT;
				$lstr_qry = "insert into studadm( FAYEAR, FSLNO,FDEGREE,FEXAMNO,FCOLLCODE,FNAME,FFATNAME,
												FMOTNAME,FDOB,FSEX,FCASTE,FNATIONAL,FENGLISH,
												FCURRADD1,FCURRADD2,FCURRADD3,FCURRADD4,
												FPERMADD1,FPERMADD2,FPERMADD3,FPERMADD4,
												FSUBDEGREE,FPHOTOPATH,FLATERAL_ENTRY,FREC_ORDER_NO,
												FREC_ORDER_DATE,FAFF_ORDER_NO,FAFF_ORDER_DATE,
												FRELIGION, REG_FEE,EXAM_FEE,GRADE_CARD_FEE,TOTAL_FEE,
												FFAT_OCC,FMOT_OCC,FEMAIL,FCONTACT_NO,FBLOOD_GROUP,
												FUSERID,  FLOGNAME, FLOGDATE, FDELETED,
												FCOMBCODE,FTOTFEE,FFEEPAID,FRECNO,FRECDATE,FREMARKS,
												FQUOTA, FQUALIFY, FPERCENT,FBOARDRUNIV, FADMDATE, FPH, FAADHARNO,FAPPNO
												) 
												values
												('{$f_year}','{$degree_slno}','{$degree_code}',
												 '{$degree_exam}', '{$college_code}', 
												 '{$student_entry_name}','{$degree_fname}',
												 '{$degree_mname}','{$degree_dob}',
												 '{$degree_sex}', '{$degree_category}', 
												'{$degree_nationality}', '{$degree_english}',
												'{$degree_address_comm1}','{$degree_address_comm2}',
												'{$degree_address_comm3}','{$degree_address_comm4}',
												'{$degree_address_perm1}', '{$degree_address_perm2}',
												'{$degree_address_perm3}','{$degree_address_perm4}',
												'{$sub_degree}','{$photo_path}','{$lateral_entry}',
												'{$rec_order_no}','{$rec_order_date}','{$aff_order_no}',
												'{$aff_order_date}','{$religion}', 
												'{$student_entry_reg_fee}',
												'{$student_entry_exam_fee}',
												'{$student_entry_grade_card_fee}',
												'{$student_entry_total_fee}',
												'{$father_occ}','{$mother_occ}','{$email}',
												'{$contact}','{$blood_group}',
												'{$u_id}','{$log_name} ',
												 NOW(),'F' ,
												 '{$fcombcode}','{$total_comb_fee}','{$fee_paid}',
												 '{$rec_no}','{$rec_date}','{$fee_remarks}',
												 '{$quota}', '{$qualify}', '{$percentage}',
												 '{$boardruniv}', '{$admdate}', '{$ph}', '{$aadharno}','{$appno}') ";
								
								$lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);
								//var_dump($lstr_qry);
					// echo mysql_error();

/* $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); */			
				//var_dump($lstr_qry);
					// for($k=0;$k<count($fee_arr_data);$k++)
					// 	{
					// 		$insert_options="insert into admfeedetl 
					// 		(FYEAR,FDEGREE,
					// 		FEXAMNO,FCOLLCODE,
					// 		FSLNO,FHEADCODE,
					// 		FAMOUNT)
					// 		values
					// 		(
					// 		{$f_year},
					// 		'{$degree_code}',
					// 		'{$degree_exam}',
					// 		'{$college_code}',
					// 		'{$degree_slno}',
					// 		'{$fee_arr_data[$k]->head_id}',
					// 		'{$fee_arr_data[$k]->fee_paid}' 
					// 		)
					// 		";
							 
					// 		$lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options);
						// }
						for($k=0;$k<count($sub_arr_data);$k++)
						{
							$insert_options="insert into options(FYEAR, FDEGREE,
							FEXAMNO,
							FCOLLCODE,
							FSLNO,
							FSUBCODE,
							FDELETED)
							values
							(
							{$f_year},
							'{$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['message'] = 'Student Record Updated Successfully';
								$arr['app_no']  = $appno;
								 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);
					 	
					 	/*$uploadRequest = array(
					 	    'fileName' => basename($file_name),
					 	    'fileDir' => $curl_photo_path,
					 	    'fileRename' => $curl_rename,
					 	    'fileData' => base64_encode(file_get_contents($full_file_path))
					 	);
					 	// Execute remote upload
					 	$curl = curl_init();
					 	curl_setopt($curl, CURLOPT_URL, 'http://logisys.net.in/rcub/app.php?a=recieveCurlPhoto.demo');
					 	curl_setopt($curl, CURLOPT_TIMEOUT, 100);
					 	curl_setopt($curl, CURLOPT_POST, 1);
					 	curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
					 	curl_setopt($curl, CURLOPT_POSTFIELDS, $uploadRequest);
					 	$response = curl_exec($curl);
					 	curl_close($curl);
					 	echo $response;*/						  
						$existing_photo_path=$image_path;
					}
							}
						
						$update_qry="update studadm set
									FNAME='{$student_entry_name}',
									FFATNAME='{$degree_fname}',
									FMOTNAME='{$degree_mname}',
									FDOB='{$degree_dob}',
									FSEX='{$degree_sex}',
									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}',
									FTOTFEE='{$total_comb_fee}',
									FFEEPAID='{$fee_paid}',
									FRECNO='{$rec_no}',
									FRECDATE='{$rec_date}',
									FREMARKS='{$fee_remarks}',								
									FCOMBCODE='{$fcombcode}',
									FQUOTA='{$quota}',
									FQUALIFY='{$qualify}',
									FPERCENT='{$percentage}',
									FBOARDRUNIV='{$boardruniv}',
									FADMDATE='{$admdate}',
									FPH='{$ph}',
									FAADHARNO='{$aadharno}',
									FLOGDATE=NOW() 
									where FSLNO='{$degree_slno}' 
									and FDEGREE='{$degree_code}' 
									and FCOLLCODE='{$college_code}'
									and FEXAMNO='{$degree_exam}' 
									and fayear = '{$f_year}'";	
						$lobj_rs = $aobj_context->mobj_db->Execute($update_qry);
				/*$delete="delete from admfeedetl
							where
							FYEAR='{$f_year}'
							and FDEGREE='{$degree_code}'
							and FEXAMNO='{$degree_exam}'
							and FCOLLCODE='{$college_code}'
							and FSLNO='{$degree_slno}'";		
				$lobj_rsa = $aobj_context->mobj_db->Execute($delete);
			 
				for($k=0;$k<count($fee_arr_data);$k++)
						{
							$insert_options="insert into admfeedetl 
							(FYEAR,FDEGREE,
							FEXAMNO,FCOLLCODE,
							FSLNO,FHEADCODE,
							FAMOUNT)
							values
							(
							'{$f_year}',
							'{$degree_code}',
							'{$degree_exam}',
							'{$college_code}',
							'{$degree_slno}',
							'{$fee_arr_data[$k]->head_id}',
							'{$fee_arr_data[$k]->fee_paid}' 
							)
							";
							 
							$lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options);
						}
						*/
				$delete_from_options="delete from options where FDEGREE='{$degree_code}'
								and FEXAMNO='{$degree_exam}' and FCOLLCODE='{$_SESSION['collcode']}' 
								and FSLNO='{$degree_slno}' and fyear = '{$f_year}'";
				$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(FYEAR, FDEGREE,
							FEXAMNO,
							FCOLLCODE,
							FSLNO,
							FSUBCODE,
							FDELETED)
							values
							(
							'{$f_year}',
							'{$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);
						}	 
						$query = "select fappno from studadm where 
								FSLNO='{$degree_slno}' and 
								FDEGREE='{$degree_code}' and 
								FCOLLCODE='{$college_code}'
								and FEXAMNO='{$degree_exam}'";	
								$results = $aobj_context->mobj_db->getRow($query);		
					if($lobj_rs) 
					{

$arr['message'] = 'Student Record Updated Successfully';
							$arr['app_no']  = $results['fappno'];
								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;		
		 }
	}
	}
	else
	{
		$arr='Session Expired,please login';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-9,"Failure");
		return;	
	
	}
}		
// delete Record 
function disableRecord($aobj_context)
{
	$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++)
	{	   
 	    /* $lstr_qry = "delete  
			from student 
			 where FDEGREE='{$delete_arr_data[$k]->degree_code}'
			       AND 
			       FEXAMNO='{$delete_arr_data[$k]->exam}'
				   AND
				   FSLNO ='{$delete_arr_data[$k]->sl_no}'
				   ";  */
	//echo $lstr_qry ;
     
	   
	    $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']}' ";	
								
		  $lobj_rs = $aobj_context->mobj_db->Execute($disable_student_record);	
 	  
								
	}
	
	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 getSubjectNames($aobj_context) // purpose to put subject name to dynamic text boxes -- naveen
{
	$subject_code = $aobj_context->mobj_data["subject_code"]; 
	$degree_code = $aobj_context->mobj_data["degree_code"]; 	
	$exam = $aobj_context->mobj_data["exam"]; 	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 	
	$get_sub_names="select FSUBCODE as id,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='{$subject_code}'
						group by  FSUBCODE";
	$lobj_get_sub_names = $aobj_context->mobj_db->getRow($get_sub_names);	
	//var_dump($arr); die();
	echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_sub_names,0,"success"); 
	return;
	
}
//   $g_student_retain_per_mode=1; 
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,ifnull(PHOTO_REQUIRED,1) as PHOTO_REQUIRED 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'];
		$PHOTO_REQUIRED=$lobj_sub_total['PHOTO_REQUIRED'];
		//echo $total_sub; die();
	
		
		$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
		 
	  $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.="<th align='left' colspan='3' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Subjects Appearing</th>";		
		$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);
		//echo 'aa';			
			foreach($lobj_get_true_sub_names as $key=>$value)
			{
			  /* 
				if($k%2==0)
				{
				$class='tbl_row';
				$inp_class='tbl_row_input';
				}
				else
				{
				$input_class='tbl_row1'; 
				$inp_class='tbl_row1_input';
				} */  
				 $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);	
			}	
			 
		//	var_dump($lobj_last_slno_execution); die();  			
			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;
		$arr['PHOTO_REQUIRED']=$PHOTO_REQUIRED;
		// var_dump($arr['total_count']); die();
	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}') and ifnull(s.FSUSPEND,'F') <> 'T'
				 ";	
		$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 getSlNoStudentDetails($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 	
	session_start();   //and FDELETED = 'F'
	$sl_no = "0000".$aobj_context->mobj_data["sl_no"]; 
	$sl_no=substr($sl_no, -4);  
	$degree = $aobj_context->mobj_data["degree"]; 
	$get_student_details_slno = "select s.FSLNO,s.FDEGREE,d.FDESCPN,s.FEXAMNO,s.FCOLLCODE,s.FNAME, 
							s.FFATNAME,s.FMOTNAME,
							DATE_FORMAT(s.FDOB,'%Y') as FDOB_Year ,
							DATE_FORMAT(s.FDOB,'%b') as FDOB_month ,
							DATE_FORMAT(s.FDOB,'%d') as FDOB_date  ,
							s.FSEX,s.FCASTE,s.FNATIONAL,s.FENGLISH,s.FCURRADD1,
							 REG_FEE,EXAM_FEE,GRADE_CARD_FEE,TOTAL_FEE,
							s.FCURRADD2,s.FCURRADD3,s.FCURRADD4,s.FPERMADD1,s.FPERMADD2,s.FPERMADD3,s.FPERMADD4,
							s.FSUBDEGREE,s.FPHOTOPATH,s.FLATERAL_ENTRY,s.FBLOOD_GROUP,s.FCONTACT_NO,s.FEMAIL,s.FMOT_OCC,s.FFAT_OCC,
							s.FREC_ORDER_NO,
							DATE_FORMAT(s.FREC_ORDER_DATE,'%d/%m/%Y') as FREC_ORDER_DATE,
							s.FAFF_ORDER_NO,
							DATE_FORMAT(s.FAFF_ORDER_DATE,'%d/%m/%Y') as FAFF_ORDER_DATE,
							s.FRELIGION,
							ifnull(s.FDELETED,'F') as FDELETED,
							FTOTFEE,FFEEPAID,FRECNO,date_format(FRECDATE,'%d/%m/%Y') as FRECDATE,
							FREMARKS,FCOMBCODE, FQUOTA, FQUALIFY, FPH, FAADHARNO, FBOARDRUNIV, DATE_FORMAT(s.FADMDATE,'%d/%m/%Y') as FADMDATE, FPERCENT
							from studadm s 
							inner join  degree d on d.FDEGREE=s.FDEGREE
							where s.FSLNO='{$sl_no}' and s.FDEGREE='{$degree}' 
							and s.FCOLLCODE='{$_SESSION['collcode']}' and d.FEXAMNO='A';";	 
 
	$lobj_get_student_details = $aobj_context->mobj_db->getRow($get_student_details_slno);
	//var_dump($lobj_get_student_details); die();
	 //echo $get_student_details_slno; die();
	
	if(!empty($lobj_get_student_details) && $lobj_get_student_details[FDELETED] == 'F' )
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,0,"success"); 
		return;
	}
	else if(!empty($lobj_get_student_details) && $lobj_get_student_details[FDELETED] == 'T' )
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-1,"Disabled"); 
		return;		
	}
	else if(empty($lobj_get_student_details) )
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-2,"Failure"); 
		return;
	}
}
function generateAutoIncrementSlNo($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	session_start();
	$collcode = $_SESSION['collcode'];
	$degree = $aobj_context->mobj_data["degree"]; 
	/* 	$get_generateAutoIncrementSlNo = "select right(concat('0000',ifnull(max(FSLNO),0)+01),4)  as  FSLNO 
	from studadm
	where  FDEGREE='{$degree}' and FCOLLCODE='{$_SESSION['collcode']}'";
	//echo $get_generateAutoIncrementSlNo;
	$lobj_get_generateAutoIncrementSlNo = $aobj_context->mobj_db->getRow($get_generateAutoIncrementSlNo);
	*/	 
	
	$query = "select ifnull(colldeg.fintake,0) as fintake from colldeg where fcollcode = '{$collcode}' 
	and fdegree = '{$degree}'";
	$rst2 = $aobj_context->mobj_db->getRow($query);
	$intake = $rst2['fintake'];
	
	if($intake == 0)
	{
		//var_dump();
		$data = 'Intake is not defined';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"success"); 
		return;
	}	
	
	$query2 = "select count(FSLNO) as slncnt from studadm
	where  studadm.FDEGREE='{$degree}' and studadm.FCOLLCODE='{$collcode}' ";
	$rst2 = $aobj_context->mobj_db->getRow($query2);
	$slnocnt = $rst2['slncnt'];
	$query3 = "select count(FSLNO) as slncnt from studadm
	where  studadm.FDEGREE='{$degree}' and studadm.FCOLLCODE='{$collcode}' and ifnull(studadm.fdeleted,'') <> 'T'";
	$rst3 = $aobj_context->mobj_db->getRow($query3);
	$slnocnt3 = $rst3['slncnt'];
	
	if($slnocnt3 >= $intake)
	{
		$data = 'Reached maximum intake '.$intake;
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"success"); 
		return;
	}
	
	if($slnocnt == 0)
	{
		$data['SLNO'] = str_pad(0001,4, "0", STR_PAD_LEFT);
		$data['INTAKE'] = $intake;
		
	}else
	{
		
		$get_generateAutoIncrementSlNo = "select right(concat('0000',ifnull(max(FSLNO),0)+01),4)  as  FSLNO, 
		ifnull(colldeg.FINTAKE,0) as FINTAKE   from studadm,colldeg					
		where  studadm.FDEGREE = colldeg.FDEGREE and studadm.FCOLLCODE = colldeg.FCOLLCODE
		and studadm.FDEGREE='{$degree}' and studadm.FCOLLCODE='{$collcode}'";
		$rst = $aobj_context->mobj_db->getRow($get_generateAutoIncrementSlNo);
		
		$data[SLNO] = $rst[FSLNO];
		$data[INTAKE] = $rst[FINTAKE];
	
	}

echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
	return;
	
	
}
function DiaplayUserSelectedPhoto($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	session_start();
	$collcode = $_SESSION['collcode']; 
	$user_id = $_SESSION['user_id']; 
	 $college_path=$aobj_context->main_src."/student_photos/{$college_code}";
	$folder_path=$aobj_context->main_src."/student_photos/{$college_code}/".replaceChars($degree_code);
	 $file_name=replaceChars(basename($_FILES['student_entry_upload']['name']));
				$path_arr=pathinfo($_FILES['student_entry_upload']['name']);
				$file_ext=$path_arr['extension'];
	 
	$temp_path=$aobj_context->main_src."/student_photos/temp";
	if(!file_exists($temp_path))
	{
	 mkdir($temp_path);
	}
	$file_path="/{$collcode}_{$user_id}_{$file_name}";
 	$temp_path.=$file_path;
  
		if(isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '')         
			{ 
			$size=($_FILES['student_entry_upload']['size']/1024);
			if($size>1024)
			{
			$data="Please Upload the Photo of size less than 1 MB";
				echo $aobj_context->mobj_output->ToJSONEnvelope($data,-2,"success"); 
				return;
			}
			if(move_uploaded_file($_FILES['student_entry_upload']['tmp_name'],$temp_path))
			 {
				$data="student_photos/temp/{$file_path}";
				echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
				return;
			 }
			}
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,-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, concat(FDEGREE,' - ',FDESCPN) 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.")"; 
	//	echo $lstr_qry 
 $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);
}

$disabled = "disabled = true";
		$FMODIFY = $av['FMODIFY'];
		//var_dump($FMODIFY);
		if($FMODIFY == 'T')
			$disabled = "";

$FHEADCODE=$av['FHEADCODE'];
		$FFEE=$av['FFEE'];
		$fee_paid=$av['fee_paid'];
		$total+=$FFEE;
		$total_fee_paid+=$fee_paid;
		$str_reval.="<tr class='ui-widget-content jqgrow'>";		
		$str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;  ' >{$sl_no}</td>";
		$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='left' id='head_{$sl_no}'>{$FHEADCODE}</td>";
		//$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;'align='right' >{$FFEE}</td>";
		$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right'><input onblur=\"CalculateTotalFeePaid();\" onkeypress='return acceptNumbersOnlyForModule(event);'  type='text'  style='text-align:right;'id='fee_paying_{$sl_no}' {$disabled} value='{$fee_paid}'/></td>";
		$str_reval.="</tr>";
		$sl_no++;
	}
		$str_reval.="<tr class='ui-widget-content jqgrow' style='font-weight:bold;'>";		
		$str_reval.="<td colspan=2 class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;'  align='right'>Total </td>";
		//$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right' id='total_comb_fee'>{$total}</td>";
		$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right' id='total_fee_paid' {$disabled}>{$total_fee_paid}</td>";
	
		$str_reval.="</tr>";
		$str_reval.="</table>";
		$arr['html']=	$str_reval;
	   print_r($aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"));
		return $html;  
}

${this.title}

Code Editor : student_entry_12092018.php