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	-rw-r--r--
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	20.34 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
SelectSubjType.php	2.13 KB	-rw-rw-r--
SubjectType.php	3.64 KB	-rw-rw-r--
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.53 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.03 KB	-rwxr-xr-x
ack_exam_app_form.php	14.56 KB	-rwxr-xr-x
ack_rv_rt_application.php	7.55 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admissionapplist.php	9.9 KB	-rwxr-xr-x
approve.php	19.63 KB	-rwxr-xr-x
attendance.php	6.13 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.php	2.6 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
bundle_dispatch.php	2.84 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate-entry.php	47.48 KB	-rwxr-xr-x
candidate-entry02092016.php	43.33 KB	-rwxr-xr-x
candidate-entry22.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	13.34 KB	-rwxr-xr-x
challan_preparation.php	11.57 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.59 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.8 KB	-rwxr-xr-x
degree.php	6.51 KB	-rwxr-xr-x
display_details_in_grid.php	102.06 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.68 KB	-rwxr-xr-x
display_details_in_grid_studta...	96.56 KB	-rwxr-xr-x
display_details_in_grid_withde...	97.45 KB	-rwxr-xr-x
doc_verify.php	6.99 KB	-rwxr-xr-x
downloadFeeStatement.php	5.33 KB	-rwxr-xr-x
downloadFeeStatement22.php	4.98 KB	-rwxr-xr-x
download_misc_files.php	3.65 KB	-rwxr-xr-x
download_photo.php	4.26 KB	-rwxr-xr-x
download_photo_23072020.php	8.57 KB	-rwxr-xr-x
download_photo_bf_bcu.php	4.38 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
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...	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	28.66 KB	-rwxr-xr-x
getfeeinformation.php	7.03 KB	-rwxr-xr-x
getmoduledetails.php	23.7 KB	-rwxr-xr-x
getnumword.php	7.43 KB	-rwxr-xr-x
getreportdetails.php	3.21 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.37 KB	-rwxr-xr-x
getsearchcondition.php	1.3 KB	-rwxr-xr-x
ggridmodel.php	9.27 KB	-rwxr-xr-x
golden_palm_payslip.php	12.48 KB	-rwxr-xr-x
helptext.php	5.38 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	13.98 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_commom.php	8.26 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	68.17 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mregistry_old.php	63.95 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
printexamform.php	11.54 KB	-rwxr-xr-x
printexamform_old.php	11.73 KB	-rwxr-xr-x
receive_rv_rt_application.php	7.65 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	11.84 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
revaluation.php	16.66 KB	-rwxr-xr-x
revaluation_oldtype.php	8.45 KB	-rwxr-xr-x
revaluation_withdegree.php	16.77 KB	-rwxr-xr-x
room_allotment.php	7.21 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
student_entry.php	73.31 KB	-rwxr-xr-x
student_entry1608.php	56.6 KB	-rwxr-xr-x
student_entry_25092019.php	57.13 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subjectList_display.php	11.01 KB	-rwxr-xr-x
subject_freshExam.php	18.94 KB	-rwxr-xr-x
subjectfreez.php	12.96 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	76.51 KB	-rwxr-xr-x
teachers.php	13.65 KB	-rwxr-xr-x
teachersOLD.php	10.33 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	3.82 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
upload_studentPhoto.php	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.14 KB	-rwxr-xr-x
usersubj_identification.php	4.54 KB	-rwxr-xr-x

Code Editor : student_entry.php

<?php
/* 
 *
 * FOR THE STUDENT ENTRY FORM
 * PROGRAMED BY NAVEEN
 * DATE: 12/03/09
 * TIME: 9:45 AM 
  *
 */
require_once("/var/www/html/aws/aws-autoloader.php");
use Aws\S3\S3Client;
use Aws\S3\Exception\S3Exception;

session_start();
function replaceChars($name)
{
	$spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ","");
	$link_name = strtolower(str_replace($spl_char,"_",$name));
	return str_ireplace("__","_",$link_name);
}

function saveStudentEntry($aobj_context)
{
	session_start();
	include_once("/JSON.php"); 
	$json = new Services_JSON();
	$college_code = $_SESSION['collcode'];
	$u_id = $_SESSION['user_id'];
	$log_name = $_SESSION['usr'];
	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	if(trim($college_code) == true)
	{
	$add_edit=trim($aobj_context->mobj_data["add_edit"]);
	$degree_slno=trim($aobj_context->mobj_data["degree_slno"]);
	$degree_code=trim($aobj_context->mobj_data["degree_code"]);
	$degree_exam=trim($aobj_context->mobj_data["degree_exam"]);
	$student_entry_name=trim($aobj_context->mobj_data["student_entry_name"]);
	$degree_fname=trim($aobj_context->mobj_data["degree_fname"]);
	$degree_mname=trim($aobj_context->mobj_data["degree_mname"]);
	$degree_dob=trim($aobj_context->mobj_data["degree_dob"]);
	$degree_gender=trim($aobj_context->mobj_data["degree_gender"]);
	$degree_category=trim($aobj_context->mobj_data["degree_category"]);
	$degree_nationality=trim($aobj_context->mobj_data["degree_nationality"]);
	$degree_english=trim($aobj_context->mobj_data["degree_english"]);
	
	$degree_address_comm1=str_replace("'","''",trim($aobj_context->mobj_data["student_entry_comm_addr1"]));
	$degree_address_comm2=str_replace("'","''",trim($aobj_context->mobj_data["student_entry_comm_addr2"]));
	$degree_address_comm3=str_replace("'","''",trim($aobj_context->mobj_data["student_entry_comm_addr3"]));
	$degree_address_comm4=str_replace("'","''",trim($aobj_context->mobj_data["student_entry_comm_addr4"]));
	
	$degree_address_perm1=str_replace("'","''",trim($aobj_context->mobj_data["student_entry_per_add1"]));
	$degree_address_perm2=str_replace("'","''",trim($aobj_context->mobj_data["student_entry_per_add2"]));
	$degree_address_perm3=str_replace("'","''",trim($aobj_context->mobj_data["student_entry_per_add3"]));
	$degree_address_perm4=str_replace("'","''",trim($aobj_context->mobj_data["student_entry_per_add4"]));
	
	$sub_degree=trim($aobj_context->mobj_data["sub_degree"]);
	//$lateral_entry=trim($aobj_context->mobj_data["lateral_entry"]);
	$lateral_entry =0;
	
	$rec_order_no=trim($aobj_context->mobj_data["rec_order_no"]);
	$rec_order_date=trim($aobj_context->mobj_data["rec_order_date"]);
	$aff_order_no=trim($aobj_context->mobj_data["aff_order_no"]);
	$aff_order_date=trim($aobj_context->mobj_data["aff_order_date"]);
	$religion=trim($aobj_context->mobj_data["religion"]);
	
	$father_occ=trim($aobj_context->mobj_data["father_occ"]);
	$mother_occ=trim($aobj_context->mobj_data["mother_occ"]);
	$email=trim($aobj_context->mobj_data["email"]);
	$contact=trim($aobj_context->mobj_data["contact"]);
	$blood_group=trim($aobj_context->mobj_data["blood_group"]);
	$mobile=trim($aobj_context->mobj_data["mobile"]); 
	$collrsch=str_replace("'","''",trim($aobj_context->mobj_data["collrsch"]));
	$passyear=trim($aobj_context->mobj_data["passyear"]);
	$totalper=trim($aobj_context->mobj_data["totalper"]);
	$boardRuniv=trim($aobj_context->mobj_data["boardRuniv"]);
	$lstclass=trim($aobj_context->mobj_data["lstclass"]);
	$othboardRuniv=trim($aobj_context->mobj_data["othboardRuniv"]);
	$mgdocno=trim($aobj_context->mobj_data["mgdocno"]);
	$combination=trim($aobj_context->mobj_data["honours_combination"]);
	$honours=trim($aobj_context->mobj_data["degree_honours"]);
	$student_entry_reg_fee=trim($aobj_context->mobj_data["student_entry_reg_fee"]);
	$student_entry_exam_fee=trim($aobj_context->mobj_data["student_entry_exam_fee"]);
	$student_entry_grade_card_fee=trim($aobj_context->mobj_data["student_entry_grade_card_fee"]);
	$student_entry_total_fee=trim($aobj_context->mobj_data["student_entry_total_fee"]);
	$student_entry_reg_fee=empty($student_entry_reg_fee)?0:$student_entry_reg_fee;
	$student_entry_exam_fee=empty($student_entry_reg_fee)?0:$student_entry_exam_fee;
	$student_entry_grade_card_fee=empty($student_entry_reg_fee)?0:$student_entry_grade_card_fee;
	$student_entry_total_fee=empty($student_entry_reg_fee)?0:$student_entry_total_fee;

$lstr_param = stripslashes($aobj_context->mobj_data["sub_arr"]);
	$mobj_jsondata = $json->decode($lstr_param);
	$sub_arr_data = get_object_vars($mobj_jsondata);
	// var_dump($sub_arr_data);
	// die();
	$rec_no = trim($aobj_context->mobj_data["rec_no"]);
	$rec_date = trim($aobj_context->mobj_data["rec_date"]);
	//$sub_arr = trim($aobj_context->mobj_data["sub_arr"]);
	$fee_remarks = trim($aobj_context->mobj_data["fee_remarks"]);
	$fcombcode=trim($aobj_context->mobj_data["fcombcode"]);
	$fee_paid=trim($aobj_context->mobj_data["fee_paid"]);
	$migfilepath=trim($aobj_context->mobj_data["migfilepath"]);
	$total_comb_fee=trim($aobj_context->mobj_data["total_comb_fee"]);
	$stud_abcNo=trim($aobj_context->mobj_data["stud_abcNo"]);
	$study_State=trim($aobj_context->mobj_data["study_State"]);
	//$lstr_param = stripslashes($aobj_context->mobj_data["sub_arr"]);
	
	$total_comb_fee=(empty($total_comb_fee) || $total_comb_fee='null')?0:$total_comb_fee;
	
	$get_year="SELECT FADYEAR ,FMEYEAR, FMEEXAMTYP
				FROM degree
				WHERE FDEGREE='{$degree_code}'
				AND FEXAMNO='{$degree_exam}'";
	$lobj_get_year = $aobj_context->mobj_db->getRow($get_year);
	$f_year=$lobj_get_year['FADYEAR'];
	$fexam_year=$lobj_get_year['FMEYEAR']; 
	$fexm_type=$lobj_get_year['FMEEXAMTYP'];
	if($add_edit=='Add')
	{
	$get_generateAutoIncrementSlNo = "select right(concat('0000',ifnull(max(FSLNO),0)+01),4)  as  FSLNO 
					from studadm
					where  FDEGREE='{$degree_code}' and FCOLLCODE='{$college_code}'";

$lobj_get_generateAutoIncrementSlNo = $aobj_context->mobj_db->getRow($get_generateAutoIncrementSlNo);
	$degree_slno=$lobj_get_generateAutoIncrementSlNo['FSLNO'];
	 
	}
	$unlink_file=trim($aobj_context->mobj_data["unlink_file"]);

$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 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(count($student_exam_details) < 0)
	{
		$arr='Last date 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;
		
		$migfile_name=basename($_FILES['student_entry_migran']['name']);
		$mig_path_arr=pathinfo($_FILES['student_entry_migran']['name']);
		$mig_file_ext=$mig_path_arr['extension'];
		$mig_full_file_path= $folder_path.'/'.$f_year."_".$degree_slno."_".$migfile_name;;
		$mig_image_path="student_photos/{$college_code}/".replaceChars($degree_code).'/'.$f_year."_".$degree_slno."_mig_".$migfile_name;

$s3 = S3Client::factory(
			array(
				'credentials' => array(
					'key' => IAM_KEY,
					'secret' => IAM_SECRET
				),
				'version' => "latest",
				'region'  => 'ap-south-1'
			)
		);

$query = "select funivcode from control";
		$results = $aobj_context->mobj_db->GetRow($query);
		$funivcode = $results['funivcode'];

//student_entry_upload
	if(!file_exists($college_path))
	{
		mkdir($college_path);
	}
	if(!file_exists($folder_path))
	{
		mkdir($folder_path);
	}
	$cond1 = "";
	$cond ="";
	if(is_null($lobj_check_adminsion_freeze['FCADSTATUS']))
	{
			$get_comb_subj = "select FSUBCODE from mascomb where FCOMBCODE ='{$combination}' and FDEGREE='{$degree_code}'";
			$lobj_get_comb_subj = $aobj_context->mobj_db->getRow($get_comb_subj);

$lobj_combsubj=$lobj_get_comb_subj['FSUBCODE'];
			$subjArry=Array();
			$subjArry=explode('*',$lobj_combsubj);
			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'],$mig_))
							 {
							 $photo_path=$image_path;
							 } */
				if ($_FILES["student_entry_upload"]["error"] > 0) 
				{ 
					$error = $_FILES["student_entry_upload"]["error"]; 
				} 
				else if (($_FILES["student_entry_upload"]["type"] == "image/gif") 
				|| ($_FILES["student_entry_upload"]["type"] == "image/jpeg") || 
				($_FILES["student_entry_upload"]["type"] == "image/png") || 
				($_FILES["student_entry_upload"]["type"] == "image/pjpeg")) 
				{ 
					$url = $full_file_path; 
					$unlink_file = $aobj_context->main_src."/".$unlink_file;
					try {
					$res = $s3->putObject(['Bucket' => STUDENT_PHOTOS_BUCKET, 'Key' => $funivcode."/".$image_path, 'SourceFile' => $unlink_file]);
					$photo_path=$image_path; 
					unlink($full_file_path);
					}catch(S3Exception $e) {
						$arr['message'] = 'Unable to upload Photo';
						echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
						return;
					}
					
					// $filename = compress_image($_FILES["student_entry_upload"]["tmp_name"], $url, 80); 
					// $buffer = file_get_contents($url);
					// $photo_path=$image_path;
				}	
						 
			}
			// var_dump(isset($_FILES['student_entry_migran']['name']) && $_FILES['student_entry_migran']['name'] != '',$study_State !== 'Meghalaya');
			if(isset($_FILES['student_entry_migran']['name']) && $_FILES['student_entry_migran']['name'] != ''){
				if($study_State !== 'Meghalaya'){
					// if(isset($_FILES['student_entry_migran']['name']) && $_FILES['student_entry_migran']['name'] != '')         
					// { 
						if ($_FILES["student_entry_migran"]["error"] > 0) 
						{ 
							$error = $_FILES["student_entry_migran"]["error"]; 
						} 
						else if (($_FILES["student_entry_migran"]["type"] == "image/gif") 
						|| ($_FILES["student_entry_migran"]["type"] == "image/jpeg") || 
						($_FILES["student_entry_migran"]["type"] == "image/png") || 
						($_FILES["student_entry_migran"]["type"] == "image/pjpeg")) 
						{

if(move_uploaded_file($_FILES['student_entry_migran']['tmp_name'],$mig_image_path))
							 {
							 $migfilepath=$mig_image_path;
							 }

//$url = $mig_full_file_path; 
							//$unlink_file = $aobj_context->main_src."/".$unlink_file;
							try {
							$res = $s3->putObject(['Bucket' => STUDENT_PHOTOS_BUCKET, 'Key' => $funivcode."/".$mig_image_path, 'SourceFile' => $migfilepath]);
							$mig_photo_path=$mig_image_path; 
							unlink($mig_full_file_path);
							}catch(S3Exception $e) {
								$arr['message'] = 'Unable to Migration Certificate';
								echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
								return;
							}
						}	
								
					// }
					$cond = ",FMIGCERPATH";
					$cond1 = ",'{$mig_photo_path}'";
					// var_dump($cond,$cond1);
				}
			}
			$lstr_qry = "insert into studadm( FSLNO,FDEGREE,FEXAMNO,FCOLLCODE,FNAME,FFATNAME,
			FMOTNAME,FDOB,Fgender,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,
			FFEEPAID,FRECNO,FRECDATE,FREMARKS,
			FMOBILE_NO, FCOLLRSCH, FPASSYEAR, FTOTALPERCENT, FBOARD_UNIV,
			FLSTCLASS, FOTHBOARD,FMIGCERTNO,FABCNO,
			FCOMBCODE,FHONOURS,FSTUDYSTATE $cond) 
			values
			('{$degree_slno}','{$degree_code}',
			'{$degree_exam}', '{$college_code}', 
			'{$student_entry_name}','{$degree_fname}',
			'{$degree_mname}','{$degree_dob}',
			'{$degree_gender}', '{$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' ,
			'{$fee_paid}',
			'{$rec_no}',date_format('{$rec_date}','%Y-%m-%d'),'{$fee_remarks}',
			'{$mobile}','{$collrsch}','{$passyear}','{$totalper}','{$boardRuniv}',
			'{$lstclass}','{$othboardRuniv}','{$mgdocno}','{$stud_abcNo}','{$combination}','{$honours}',
			'{$study_State}' $cond1) ";     
			// var_dump($lstr_qry);die();
			$lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);
			$get_year="SELECT FADYEAR ,FMEYEAR, FMEEXAMTYP
				FROM degree
				WHERE FDEGREE='{$degree_code}'
				AND FEXAMNO='{$degree_exam}'";
				
	$result = $aobj_context->mobj_db->getRow($get_year);
	$f_year=$result['FADYEAR'];		
				
			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($subjArry);$k++)
			// {
			// 	$insert_options="insert into options(FDEGREE,
			// 	FEXAMNO,
			// 	FCOLLCODE,
			// 	FSLNO,
			// 	FSUBCODE,
			// 	FDELETED)
			// 	values
			// 	(
			// 	'{$degree_code}',
			// 	'{$degree_exam}',
			// 	'{$college_code}',
			// 	'{$degree_slno}',
			// 	'{$subjArry[$k]}',
			// 	'F'
			// 	)";
			// 	$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. Sl.No is '.$degree_slno;
					 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, ifnull(FAREGNO,'') as FAREGNO 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'] ;
			$stud_regno = $lobj_get_existing_data['FAREGNO'] ;
			
			 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);						 
							//rename($unlink_file,$unlink_file."_tmp");						 
							$existing_photo_path=$image_path;
						 } */
			if ($_FILES["student_entry_upload"]["error"] > 0) 
			{ 
				$error = $_FILES["student_entry_upload"]["error"]; 
			} 
			else if (($_FILES["student_entry_upload"]["type"] == "image/gif") 
			|| ($_FILES["student_entry_upload"]["type"] == "image/jpeg") || 
			($_FILES["student_entry_upload"]["type"] == "image/png") || 
			($_FILES["student_entry_upload"]["type"] == "image/pjpeg")) 
			{ 
				$query = "select funivcode from control";
				$results = $aobj_context->mobj_db->GetRow($query);
				$funivcode = $results['funivcode'];
				$s3 = S3Client::factory(
					array(
						'credentials' => array(
							'key' => IAM_KEY,
							'secret' => IAM_SECRET
						),
						'version' => "latest",
						'region'  => 'ap-south-1'
					)
				);

$unlink_file = $aobj_context->main_src."/".$unlink_file;
				
				try {
					$res = $s3->putObject(['Bucket' => STUDENT_PHOTOS_BUCKET, 'Key' => $funivcode."/".$image_path, 'SourceFile' => $unlink_file]);
					$photo_path=$image_path; 
					unlink($full_file_path);
					}catch(S3Exception $e) {
						$arr['message'] = 'Unable to upload Photo';
						echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
						return;
					}

$url = $full_file_path; 
				$filename = compress_image($_FILES["student_entry_upload"]["tmp_name"], $url, 80); 
				$buffer = file_get_contents($url);
				$unlink_file=$aobj_context->main_src."/".$existing_photo_path;
				unlink($unlink_file);	
				$existing_photo_path=$image_path;
			}	
		}
			if(isset($_FILES['student_entry_migran']['name']) && $_FILES['student_entry_migran']['name'] != ''){
				
				if($study_State !== 'Meghalaya'){
					// if(isset($_FILES['student_entry_migran']['name']) && $_FILES['student_entry_migran']['name'] != '')         
					// { 
						
						if ($_FILES["student_entry_migran"]["error"] > 0) 
						{ 
							$error = $_FILES["student_entry_migran"]["error"]; 
						}

else if (($_FILES["student_entry_migran"]["type"] == "image/gif") 
						|| ($_FILES["student_entry_migran"]["type"] == "image/jpeg") || 
						($_FILES["student_entry_migran"]["type"] == "image/png") || 
						($_FILES["student_entry_migran"]["type"] == "image/pjpeg")) 
						{

if(move_uploaded_file($_FILES['student_entry_migran']['tmp_name'],$mig_image_path))
							 {
							 $migfilepath=$mig_image_path;
							 }

//$url = $mig_full_file_path; 
							//$unlink_file = $aobj_context->main_src."/".$unlink_file;
							try {
							$res = $s3->putObject(['Bucket' => STUDENT_PHOTOS_BUCKET, 'Key' => $funivcode."/".$mig_image_path, 'SourceFile' => $migfilepath]);
							$mig_photo_path=$mig_image_path; 
							unlink($mig_full_file_path);
							}catch(S3Exception $e) {
								$arr['message'] = 'Unable to Migration Certificate';
								echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
								return;
							}
						}	
								
					// }
					$cond = ",FMIGCERPATH = '{$mig_photo_path}'";
					
					// var_dump($cond,$cond1);
				}
			}		 
			
			 
				$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}',
				FSTUDYSTATE = '{$study_State}',
				FLOGNAME='{$log_name}',
				FLOGDATE=NOW(),
				FFEEPAID='{$fee_paid}',
				FRECNO='{$rec_no}',
				FRECDATE='{$rec_date}',
				FREMARKS='{$fee_remarks}',
				FABCNO = '{$stud_abcNo}',
				FMOBILE_NO = '{$mobile}', FCOLLRSCH = '{$collrsch}', FPASSYEAR = '{$passyear}', 
				FTOTALPERCENT = '{$totalper}', FBOARD_UNIV = '{$boardRuniv}', FLSTCLASS = '{$lstclass}',FOTHBOARD='{$othboardRuniv}',
				FMIGCERTNO= '{$mgdocno}',FCOMBCODE = '{$combination}', FHONOURS = '{$honours}'$cond
				where 
				FSLNO='{$degree_slno}' and 
				FDEGREE='{$degree_code}' and 
				FCOLLCODE='{$college_code}'
				and FEXAMNO='{$degree_exam}'";	
				$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);
				}
			/* 				
			// insert combination subjects to canddet table. 23/09/2015
			if($stud_regno)
			{
				
				$delete_from_canddet="delete from canddet where FDEGREE='{$degree_code}'
					and FEXAMNO='{$degree_exam}' and FCOLLCODE='{$college_code}' 
					and FREGNO ='{$stud_regno}'";
				$lobj_delete_from_canddet = $aobj_context->mobj_db->Execute($delete_from_canddet);
				
				$get_comb_subj = "select FSUBCODE from mascomb where FCOMBCODE ='{$combination}' and FDEGREE='{$degree_code}'";
				$lobj_get_comb_subj = $aobj_context->mobj_db->getRow($get_comb_subj);
				
				$lobj_combsubj=$lobj_get_comb_subj[FSUBCODE];
				$subjArry=Array();
				$subjArry=explode('*',$lobj_combsubj);

for($j=0;$j<count($subjArry);$j++)
				{
					if($subjArry[$j] !='')
					{
						$insert_combSubj = "insert into canddet(FDEGREE,FEXAMNO,FCOLLCODE,FREGNO,FSUBCODE,FPRESENT,FYEAR,FEXAMTYPE, FDELETED)
						values('{$degree_code}','{$degree_exam}','{$_SESSION['collcode']}','{$stud_regno}','{$subjArry[$j]}',
						'P','{$fexam_year}','{$fexm_type}','M')";
						$lobj_insert_combSubj = $aobj_context->mobj_db->Execute($insert_combSubj);
					}							
				}
			}
			*/			
				//Secho $update_qry; die(); 		 
				$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);
				}

// for($k=0;$k<count($subjArry);$k++)
				// {
				// 	$insert_options="insert into options(FDEGREE,
				// 	FEXAMNO,
				// 	FCOLLCODE,
				// 	FSLNO,
				// 	FSUBCODE,
				// 	FDELETED)
				// 	values
				// 	(
				// 	'{$degree_code}',
				// 	'{$degree_exam}',
				// 	'{$college_code}',
				// 	'{$degree_slno}',
				// 	'{$subjArry[$k]}',
				// 	'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;		
		}
	}
	}
	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"]; 	
	session_start();
	$college_code = $_SESSION['collcode'];
	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 ;
    $check_adminsion_freeze ="  select FCADSTATUS, ifnull(fadmstop,'') as FADMSTOP from colldeg 
									where FCOLLCODE='{$college_code}' 
									and FDEGREE='{$delete_arr_data[$k]->degree_code}'";								
	$lobj_check_adminsion_freeze = $aobj_context->mobj_db->getRow($check_adminsion_freeze); 
	
	if($lobj_check_adminsion_freeze['FADMSTOP']=='T')
	{
			$arr='Last date is over';
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-9,"success"); 
			 return;
	
	}
	ELSE
	{
	   
			$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']}' and ifnull(FAREGNO,'') ='' ";

$lobj_rs = $aobj_context->mobj_db->Execute($disable_student_record);	
 	  
	}							
	}
	
/* 	
//FDELETED	
    $disable_student_record = 	"	UPDATE student SET FDELETED='T' 
								WHERE  FDEGREE='{$degree_code}' and FEXAMNO='{$exam}' 
								and FSLNO='{$sl_no}' and FCOLLCODE ='{$_SESSION['collcode']}' ";	
								
	$disable_options_record = 	"	UPDATE options SET FDELETED='T' 
								WHERE  FDEGREE='{$degree_code}' and FEXAMNO='{$exam}' 
								and FSLNO='{$sl_no}' and FCOLLCODE='{$_SESSION['collcode']}' ";								
	//echo $disable_student_record; die();	
	$lobj_disable_student_record = $aobj_context->mobj_db->Execute($disable_student_record);	
	$lobj_disable_options_record = $aobj_context->mobj_db->Execute($disable_options_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 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'];
		//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]}' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'></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;
		// var_dump($arr['total_count']); die();
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;  			
}

}

//$lobj_check_adminsion_freeze = $aobj_context->mobj_db->getRow($check_adminsion_freeze); 
	
	
	if(count($student_exam_details) <= 0)
	{
		$arr='Last date is over';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
		return;		
	}
	else
	{
		$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);
		 
		if($lobj_get_generateAutoIncrementSlNo)
		{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_generateAutoIncrementSlNo['FSLNO'],0,"success"); 
		return;
		}
		else
		{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-1,"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;
	$buffer ='';
		if(isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '')         
			{ 
			if ($_FILES["student_entry_upload"]["error"] > 0) 
			{ 
				$error = $_FILES["student_entry_upload"]["error"]; 
			} 
			else if (($_FILES["student_entry_upload"]["type"] == "image/gif") 
			|| ($_FILES["student_entry_upload"]["type"] == "image/jpeg") || 
			($_FILES["student_entry_upload"]["type"] == "image/png") || 
			($_FILES["student_entry_upload"]["type"] == "image/pjpeg")) 
			{ 
				$url = $temp_path; 
				$filename = compress_image($_FILES["student_entry_upload"]["tmp_name"], $url, 80); 
				$buffer = file_get_contents($url);
			}
			/* $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($filename,$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_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();
}

$query = "select fcombcode from studadm where fdegree = '{$fdegree}' and fcollcode = '{$collcode}' and fslno = '{$fsl_no}'";
	$res = $aobj_context->mobj_db->GetRow($query);
	$studcombcode =  $res['fcombcode'];

if($studcombcode == $fcombcode)
	{
		$get_details="select  a.FHEADCODE,(FFEE+(fprfee*{$pr_cnt})) as FFEE,ifnull(FAMOUNT ,'0') as fee_paid from
		(SELECT FHEADCODE,FFEE,fprfee,
			FCOMBCODE,FCATCODE
		FROM admfeestr
		WHERE FDEGREE='{$fdegree}'
		AND FEXAMNO='{$fexamno}'
		AND FCOMBCODE='{$fcombcode}'
		AND FCATCODE='{$fcatcode}')a
		left outer join 
		(
		SELECT FHEADCODE,FAMOUNT 
		FROM admfeedetl
		where FDEGREE='{$fdegree}'
		AND FEXAMNO='{$fexamno}'
		AND FCOLLCODE='{$collcode}'
		AND FSLNO='{$fsl_no}'					 
		) b
		on a.FHEADCODE=b.FHEADCODE order by FHEADCODE";
					//var_dump($get_details);
	}else
	{
		
		$get_details = "select  a.FHEADCODE,(FFEE+(fprfee*{$pr_cnt})) as FFEE,'0' as fee_paid from
		(SELECT FHEADCODE,FFEE,fprfee,
		FCOMBCODE,FCATCODE
		FROM admfeestr
		WHERE FDEGREE='{$fdegree}'
		AND FEXAMNO='{$fexamno}'
		AND FCOMBCODE='{$fcombcode}'
		AND FCATCODE='{$fcatcode}') a";

}

$lobj_rs = $aobj_context->mobj_db->GetAll($get_details);
				
	$str_reval="";
	$str_reval.="<table width='60%' style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>";
	$str_reval.="<th align='left' colspan='4' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Fee Details</th>";
	$str_reval.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
	$str_reval.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl.No</td>";
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Description</td>";
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Fee</td>";
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Fee Paid</td>";
 
	$str_reval.="</tr>";
	$sl_no=1;
	$total=0;
	$total_fee_paid=0;
	foreach($lobj_rs  as $ak=>$av)
	{
		$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;width:50px;'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;width:50px;'id='fee_paying_{$sl_no}' 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'>{$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;  
}

}

}

function loadNEPSubdet($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$fdegree = $aobj_context->mobj_data["degree_code"];
	$exam = $aobj_context->mobj_data["exam"];
	$appno = $aobj_context->mobj_data["appno"];
	$collcode = $_SESSION['collcode'];

$query = "select * from subtype where fdegree = '{$fdegree}' order by ftorder";
	$res = $aobj_context->mobj_db->GetAll($query);	
	if($appno == '' || $appno == undefined )
	{
		$query = "select group_concat(distinct concat(su.fsubcode,'-',FMANDATORY)) as subcode , 
		su.fsubtype,st.ftotsub 
		from subject su
		inner join subtype st on su.fdegree = st.fdegree 
		and su.fblockno = st.fsubtype
		where su.fdegree = '{$fdegree}' 
		and su.fexamno = '{$exam}' 
		and su.FMANDATORY = 'T'
		group by su.fblockno
		order by su.fblockno,su.fsubcode";
		
	}else
	{
		$query = "select group_concat(distinct concat(su.fsubcode,'-',FMANDATORY)) as subcode , 
		su.fblockno as fsubtype,
		st.ftotsub 
		from subject su 
		inner join subtype st on su.fdegree = st.fdegree 
		and su.fblockno = st.fsubtype
		inner join options o on su.fdegree = o.fdegree
		and o.fexamno = su.fexamno
		and o.fsubcode = su.fsubcode
		and o.fcollcode = '{$collcode}' and o.fdegree = '{$fdegree}'
		and o.fslno = '{$appno}'
		where su.fdegree = '{$fdegree}' 
		and su.fexamno = '{$exam}' 
		group by su.fblockno
		order by su.fblockno,su.fsubcode";
	}	
	//var_dump($query);die();
	$res2 = $aobj_context->mobj_db->GetAll($query);

$div = "";
	if($res)
	{
		foreach($res as $value)
		{
			$subtype = $value['fsubtype'];
			
			$options = "";
			$options = "<option value = ''>--Select---</option>";
			// if($subtype == '1' || $subtype == '2')
			// {
			// 	$query = "select fsubcode,fsubname from subject 
			// 	where fdegree = '{$fdegree}' 
			// 	and fexamno = '{$exam}' and fblockno in ('1','2')
			// 	group by fsubcode";
			// }else
			// {
				$query = "select fsubcode,fsubname from subject 
				where fdegree = '{$fdegree}' 
				and fexamno = '{$exam}' and fblockno = '{$subtype}'
				group by fsubcode";
			//}
			$res1 = $aobj_context->mobj_db->GetAll($query);

foreach($res1 as $optval)
			{
				$options .= "<option value = '".$optval['fsubcode']."'>".$optval['fsubname']."</option>";	
			}

$div .= "<span>".$value['fdescpn']."</span>";
			$div .="<table  style='display:'block'; overflow:auto' cellpadding='5' cellspacing='2'>
			<tbody>
				";
			$a = 0;	
			$brv = "";
			for($i=1;$i<=$value['ftotsub'];$i++)
			{
				
				
				if($a>3)
				{	
					$brv = "<br>";
					$a = 0;
				}
				//var_dump($value['fsubtype'].$a.$brv);
				$div  .="<tr><td>
				<select id = '".$value['fsubtype'].$i."'  style = 'width: 350px;' onchange = 'GetCombinationFeeListNew()'>".
				$options	
				."</select>
				$brv
				</td>
				</tr>";
				$a++;
			}
			$div .="</tbody>
			</table>";
						
			
		}
	}else
	{
		$div = "<h4>No Subject Details Found</h4>";
	}

$arr['html'] =	$div;
	$arr['madsub'] = $res2;
	$arr['totsub'] = $res;
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");	
	return;
}

function GetCombinationFeeListNew($aobj_context)
{

include_once("/JSON.php"); 
	$json = new Services_JSON();

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$fdegree = $aobj_context->mobj_data["fdegree"];	 
	$fexamno = $aobj_context->mobj_data["fexamno"];	 
	$appno = $aobj_context->mobj_data["appno"];

$lstr_param = stripslashes($aobj_context->mobj_data["sub_arr"]);
	$mobj_jsondata = $json->decode($lstr_param);
	$sub_arr_data = get_object_vars($mobj_jsondata);

session_start();
	$collcode = $_SESSION['collcode'];  
	$pr_cnt = 0;
	for($k=0;$k<count($sub_arr_data);$k++)
	{

$query = "select count(distinct s.fsubcode) as pr_cnt 
		from subject s 
		where s.fdegree = '{$fdegree}' and ifnull(ftheory,'') = 'F' 
		and ifnull(fintass,'') <> 'T'
		and fsubcode = '{$sub_arr_data[$k]->sub_code}'";
		$res = $aobj_context->mobj_db->GetRow($query);
		$pr_cnt1 = $res['pr_cnt'];
		$pr_cnt = $pr_cnt+$pr_cnt1;
			
		
	}

// $query = "select count(distinct s.fsubcode) as pr_cnt from subject s inner join mascomb m on  s.fdegree = m.fdegree
	// where m.fdegree = '{$fdegree}' and instr(m.fsubcode,s.fsubcode)
	// and m.fcombcode = '{$fcombcode}'
	// and ifnull(ftheory,'') = 'F' and ifnull(fintass,'') <> 'T'";
	// $res = $aobj_context->mobj_db->GetRow($query);
	// $pr_cnt = $res['pr_cnt'];

// $query = "select fcombcode from studadm where fdegree = '{$fdegree}' and fcollcode = '{$collcode}' and fslno = '{$fsl_no}'";
	// $res = $aobj_context->mobj_db->GetRow($query);
	// $studcombcode =  $res['fcombcode'];

if($appno != '')
	{
		$get_details="select  a.FHEADCODE,(FFEE+(fprfee*{$pr_cnt})) as FFEE,
		(FFEE+(fprfee*{$pr_cnt})) as fee_paid from
		(SELECT FHEADCODE,FFEE,fprfee,
			FCOMBCODE,FCATCODE
		FROM admfeestr
		WHERE FDEGREE='{$fdegree}'
		AND FEXAMNO='{$fexamno}'
		AND FCOMBCODE='{$fdegree}'
		AND FCATCODE='GM')a
		left outer join 
		(
		SELECT FHEADCODE,FAMOUNT 
		FROM admfeedetl
		where FDEGREE='{$fdegree}'
		AND FEXAMNO='{$fexamno}'
		AND FCOLLCODE='{$collcode}'
		AND FSLNO='{$appno}'					 
		) b
		on a.FHEADCODE=b.FHEADCODE order by FHEADCODE";
	//var_dump($get_details);
	}else
	{
		
		$get_details = "select  a.FHEADCODE, (FFEE+(fprfee*{$pr_cnt})) as FFEE, 
		(FFEE+(fprfee*{$pr_cnt})) as fee_paid from
		(SELECT FHEADCODE,FFEE,fprfee,
		FCOMBCODE,FCATCODE
		FROM admfeestr
		WHERE FDEGREE='{$fdegree}'
		AND FEXAMNO='{$fexamno}'
		AND FCOMBCODE='{$fdegree}'
		AND FCATCODE='GM') a";

}

$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.php