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.82 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
MarkEntry-Setup_28102014.php	22.99 KB	-rwxr-xr-x
TAGMAY2013.pdf	331.03 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.71 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	7.3 KB	-rwxr-xr-x
absent_entry_setup_old.php	7.61 KB	-rwxr-xr-x
ack_exam_app_form.php	12.09 KB	-rwxr-xr-x
ack_exam_app_form_07032014.php	9 KB	-rwxr-xr-x
ack_exam_app_form_14032014.php	9.6 KB	-rwxr-xr-x
ack_rv_rt_application.php	7.57 KB	-rwxr-xr-x
ack_rv_rt_application_5days.ph...	7.41 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
attendance.php	6.07 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
bundle_dispatch.php	2.84 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate-entry-new.php	53.14 KB	-rw-rw-r--
candidate-entry.php	53.85 KB	-rwxr-xr-x
candidate-entry1.php	37 KB	-rwxr-xr-x
candidate-entry24082012.php	33.21 KB	-rwxr-xr-x
candidate-entry_02122017.php	42.72 KB	-rwxr-xr-x
candidate-entry_220413.php	33.21 KB	-rwxr-xr-x
candidate-entry_bf_aws.php	50.79 KB	-rwxr-xr-x
candidate-entry_new.php	43 KB	-rwxr-xr-x
candidate-entry_old_01122019.p...	43.31 KB	-rwxr-xr-x
candidate-entry_without_iapr_i...	34.88 KB	-rwxr-xr-x
candidate-entrybefore yearexam...	34.55 KB	-rwxr-xr-x
candidate-entrykus.php	33.23 KB	-rwxr-xr-x
candidate-entryold.php	34.55 KB	-rwxr-xr-x
cappcontext.php	3.19 KB	-rwxr-xr-x
challan_entries.php	13.34 KB	-rwxr-xr-x
challan_preparation.php	10.28 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
college.php	4.61 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxr-xr-x
college_degree_status.php	5.86 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
create_all_grid_files.php	8.57 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	9.94 KB	-rwxr-xr-x
create_all_grid_group_files_ol...	9.61 KB	-rwxr-xr-x
create_all_popup_files.php	5.93 KB	-rwxr-xr-x
create_all_schema_files.php	4.31 KB	-rwxr-xr-x
create_all_views.php	16.52 KB	-rwxr-xr-x
create_html_files.php	52.03 KB	-rwxr-xr-x
create_html_files_without_tab....	44.49 KB	-rwxr-xr-x
create_module_meta_columns.php	5.16 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	4.86 KB	-rwxr-xr-x
degree.php	6.51 KB	-rwxr-xr-x
degree1.php	6.78 KB	-rwxr-xr-x
display_details_in_grid.php	104.96 KB	-rwxr-xr-x
display_details_in_grid22.php	103.04 KB	-rwxr-xr-x
display_details_in_grid_240320...	98.86 KB	-rwxr-xr-x
display_details_in_grid_before...	98.71 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.68 KB	-rwxr-xr-x
display_details_in_grid_studta...	96.56 KB	-rwxr-xr-x
display_details_in_grid_withde...	97.45 KB	-rwxr-xr-x
download_misc_files.php	3.3 KB	-rwxr-xr-x
download_misc_files_19062014.p...	3.25 KB	-rwxr-xr-x
download_photo.php	6.98 KB	-rwxr-xr-x
download_photo_befor_newzip_fo...	6.97 KB	-rwxr-xr-x
download_photo_old.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_23.php	120 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
error_log.php	749 B	-rwxrwxrwx
execute_query.php	2.5 KB	-rwxr-xr-x
execute_query27062012.php	2.51 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
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.24 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.24 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getdata.php	33.59 KB	-rwxr-xr-x
getdata110911.php	16.03 KB	-rwxr-xr-x
getdata18112016.php	32.82 KB	-rwxr-xr-x
getdata27062012.php	16.8 KB	-rwxr-xr-x
getdata_24032015.php	20.96 KB	-rwxr-xr-x
getdataold.php	23.25 KB	-rwxr-xr-x
getfeeinformation.php	6.14 KB	-rwxr-xr-x
getmoduledetails.php	23.7 KB	-rwxr-xr-x
getnumword.php	7.42 KB	-rwxr-xr-x
getreportdetails.php	3.21 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.37 KB	-rwxr-xr-x
getsearchcondition.php	1.3 KB	-rwxr-xr-x
ggridmodel.php	9.27 KB	-rwxr-xr-x
golden_palm_payslip.php	12.48 KB	-rwxr-xr-x
helptext.php	5.38 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	12.28 KB	-rwxr-xr-x
login.php_1	3.25 KB	-rwxr-xr-x
login11052016.php	4.48 KB	-rwxr-xr-x
login27062012.php	2.85 KB	-rwxr-xr-x
login_03032015.php	3.6 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
markEntry-Setup2.php	21.93 KB	-rwxr-xr-x
message_board.php	4.67 KB	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	72.49 KB	-rwxr-xr-x
mregistry22.php	66.7 KB	-rwxr-xr-x
mregistry24042015.php	55.01 KB	-rwxr-xr-x
mregistry_13012017.php	63.53 KB	-rwxr-xr-x
mregistry_before_subupdtostud_...	52.68 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
printapp_sum.php	31.82 KB	-rwxr-xr-x
receive_rv_rt_application.php	7.65 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
revaluation.php	16.66 KB	-rwxr-xr-x
revaluation_oldtype.php	8.45 KB	-rwxr-xr-x
revaluation_withdegree.php	16.77 KB	-rwxr-xr-x
room_allotment.php	7.21 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
savesspdetails.php	9.8 KB	-rw-rw-r--
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
student_entry.php	36.46 KB	-rwxr-xr-x
student_entry1307.php	37.71 KB	-rwxr-xr-x
student_entry27062012.php	30.47 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subjectList_display.php	11.01 KB	-rwxr-xr-x
subject_freshExam.php	18.92 KB	-rwxr-xr-x
subjectfreez.html	2.8 KB	-rwxr-xr-x
subjectfreez.php	12.98 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	75.5 KB	-rwxr-xr-x
teachers.php	10.33 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	3.86 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
upload_studentPhoto.php	10.06 KB	-rwxr-xr-x
upload_studentPhoto02062015.ph...	11.58 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
usersetup.php	24.11 KB	-rwxr-xr-x
usersubj_identification.php	4.54 KB	-rwxr-xr-x

Code Editor : candidate-entry_02122017.php

<?php
function replaceChars($name)
{
	$spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ","");
	$link_name = strtolower(str_replace($spl_char,"_",$name));
	return str_ireplace("__","_",$link_name);
}
function displayCandidateEntryRegNoDetails($aobj_context)
{
	session_start();
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    $college_code = $_SESSION['collcode']; 	
    $Regno = $aobj_context->mobj_data["Regno"]; 	
    $degree = $aobj_context->mobj_data["degree"]; 	
    $li = $aobj_context->mobj_data["li"]; 	
    $category = $aobj_context->mobj_data["category"]; 	
	$exam_appear=array();
	//$qry=" select * from colldeg where fdegree = '{$degree}' and fcollcode = '{$college_code}' and ifnull(fexregstop,'') <> 'T'";
	$query = "select * from collexam where fcollcode = '{$college_code}' 
					and fdegree = '{$degree}' and DATE_FORMAT(NOW(),'%Y-%m-%d') 
					BETWEEN DATE_FORMAT(FAPPFROM,'%Y-%m-%d') 
					AND DATE_FORMAT(FAPPTO,'%Y-%m-%d') ";
	
	
	$student_exam_details = $aobj_context->mobj_db->GetRow($query); 
	if($student_exam_details ==  false)
	{	
		$e_data="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row'  width='100%' border='0' cellspacing='0' cellpadding='0'>";
		 $e_data.="<th align='left' colspan='10' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Last date is over for exam registration</th>";
		$e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
		$e_data.="<td align='center' style='  font-size:12px;   border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>A</td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>B </td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>C </td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>D </td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>E </td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>F</td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>G</td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>H</td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>I</td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>J</td>";
		$e_data.="</tr>";	
		$e_data.="<tr  style='   border-bottom:1px solid #C5DBEC;'>";

$qry=" ";
		$student_exam_details = $aobj_context->mobj_db->GetRow($qry); 
	}
	else
	{
/*		$qry=" select c.FDEGREE,c.FEXAMNO,c.FCOLLCODE,c.FREGNO,s.FCASTE AS FCATEGORY,
		s.Fgender as Fgender,c.FAPPEARA,c.FEXAMFEEA,
		c.FAPPEARB,c.FEXAMFEEB,c.FAPPEARC,c.FEXAMFEEC,c.FAPPEARD,c.FEXAMFEED,c.FAPPEARE,
		c.FEXAMFEEE,c.FAPPEARF,c.FEXAMFEEF,c.FAPPEARG,c.FEXAMFEEG,c.FAPPEARH,c.FEXAMFEEH,
		c.FAPPEARI,c.FEXAMFEEI,c.FAPPEARJ,c.FEXAMFEEJ,round(c.FTOTALFEE,2) as FTOTALFEE,
		c.FYEAR,c.FEXAMTYPE,c.FDELETED,FRECPTNO,DATE_FORMAT(FRECPTDATE,'%d/%m/%Y') as FRECPTDATE
		,FREMARKS,
		FRECPTNOA,DATE_FORMAT(FRECPTDATEA,'%d/%m/%Y') AS FRECPTDATEA,
		FRECPTNOB,DATE_FORMAT(FRECPTDATEB,'%d/%m/%Y') AS FRECPTDATEB,
		FRECPTNOC,DATE_FORMAT(FRECPTDATEC,'%d/%m/%Y') AS FRECPTDATEC ,
		FRECPTNOD,DATE_FORMAT(FRECPTDATED,'%d/%m/%Y') AS FRECPTDATED ,
		FRECPTNOE,DATE_FORMAT(FRECPTDATEE,'%d/%m/%Y') AS FRECPTDATEE ,
		FRECPTNOF,DATE_FORMAT(FRECPTDATEF,'%d/%m/%Y') AS FRECPTDATEF ,
		FRECPTNOG,DATE_FORMAT(FRECPTDATEG,'%d/%m/%Y') AS FRECPTDATEG ,
		FRECPTNOH,DATE_FORMAT(FRECPTDATEH,'%d/%m/%Y') AS FRECPTDATEH ,
		FRECPTNOI,DATE_FORMAT(FRECPTDATEI,'%d/%m/%Y') AS FRECPTDATEI ,
		FRECPTNOJ,DATE_FORMAT(FRECPTDATEJ,'%d/%m/%Y') AS FRECPTDATEJ ,FFRESHEXAM     
		from candsum c left join student s on s.FDEGREE=c.FDEGREE and s.FREGNO=c.FREGNO
		where c.FDEGREE='{$degree}' and c.FCOLLCODE='{$college_code}' and c.FREGNO='{$Regno}' ";*/

$qry=" select c.FDEGREE,c.FEXAMNO,c.FCOLLCODE,c.FREGNO,
		c.FAPPEARA,c.FEXAMFEEA,
		c.FAPPEARB,c.FEXAMFEEB,c.FAPPEARC,c.FEXAMFEEC,c.FAPPEARD,c.FEXAMFEED,c.FAPPEARE,
		c.FEXAMFEEE,c.FAPPEARF,c.FEXAMFEEF,c.FAPPEARG,c.FEXAMFEEG,c.FAPPEARH,c.FEXAMFEEH,
		c.FAPPEARI,c.FEXAMFEEI,c.FAPPEARJ,c.FEXAMFEEJ,round(c.FTOTALFEE,2) as FTOTALFEE,
		c.FYEAR,c.FEXAMTYPE,c.FDELETED,FRECPTNO,DATE_FORMAT(FRECPTDATE,'%d/%m/%Y') as FRECPTDATE
		,FREMARKS,
		FRECPTNOA,DATE_FORMAT(FRECPTDATEA,'%d/%m/%Y') AS FRECPTDATEA,
		FRECPTNOB,DATE_FORMAT(FRECPTDATEB,'%d/%m/%Y') AS FRECPTDATEB,
		FRECPTNOC,DATE_FORMAT(FRECPTDATEC,'%d/%m/%Y') AS FRECPTDATEC ,
		FRECPTNOD,DATE_FORMAT(FRECPTDATED,'%d/%m/%Y') AS FRECPTDATED ,
		FRECPTNOE,DATE_FORMAT(FRECPTDATEE,'%d/%m/%Y') AS FRECPTDATEE ,
		FRECPTNOF,DATE_FORMAT(FRECPTDATEF,'%d/%m/%Y') AS FRECPTDATEF ,
		FRECPTNOG,DATE_FORMAT(FRECPTDATEG,'%d/%m/%Y') AS FRECPTDATEG ,
		FRECPTNOH,DATE_FORMAT(FRECPTDATEH,'%d/%m/%Y') AS FRECPTDATEH ,
		FRECPTNOI,DATE_FORMAT(FRECPTDATEI,'%d/%m/%Y') AS FRECPTDATEI ,
		FRECPTNOJ,DATE_FORMAT(FRECPTDATEJ,'%d/%m/%Y') AS FRECPTDATEJ ,FFRESHEXAM     
		from candsum c where c.FDEGREE='{$degree}' and c.FCOLLCODE='{$college_code}' and c.FREGNO='{$Regno}' ";
		//var_dump($qry);
		$student_exam_details = $aobj_context->mobj_db->GetRow($qry); 
		$e_data="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row'  width='100%' border='0' cellspacing='0' cellpadding='0'>";
		 $e_data.="<th align='left' colspan='10' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Exam Details</th>";
		$e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
		$e_data.="<td align='center' style='  font-size:12px;   border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>A</td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>B </td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>C </td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>D </td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>E </td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>F</td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>G</td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>H</td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>I</td>";
		$e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>J</td>";
		$e_data.="</tr>";	
		$e_data.="<tr  style='   border-bottom:1px solid #C5DBEC;'>";

}
	//echo $qry;
		$get_existing_fee_details="SELECT FEXAMNO,FFEECODE,FAMOUNT
					FROM studfee
					WHERE FCOLLCODE='{$college_code}'
					AND FDEGREE='{$degree}'
					AND FREGNO='{$Regno}'
					 ";
		$obj_get_existing_fee_details = $aobj_context->mobj_db->GetAll($get_existing_fee_details); 
			$existing_fee_arr=array();
			foreach($obj_get_existing_fee_details as $ak=>$av)
			{
			$existing_fee_arr[$av['FEXAMNO']][$av['FFEECODE']]=$av['FAMOUNT'];
			}
			$FFRESHEXAM=$student_exam_details[FFRESHEXAM];
			/*if($category=="Select" || $category=="0")
			$FCATEGORY=$student_exam_details[FCATEGORY];
			else*/
			$FCATEGORY=$category;
			 $fee_td="";
		for($i=65;$i<75;$i++)
		{
			$html_id="candidate_list_exam_".chr($i)."_details";
			$exam_fee["{$html_id}"]=$student_exam_details['FEXAMFEE'.chr($i)];
			
			$exam_receipt_no["{$html_id}"]=$student_exam_details['FRECPTNO'.chr($i)];
			//is_null($student_exam_details['FRECPTDATE'])?date('d/m/Y'):$student_exam_details['FRECPTDATE'];
			$exam_receipt_no_date["{$html_id}"]=is_null($student_exam_details['FRECPTDATE'.chr($i)])?date('d/m/Y'):($student_exam_details['FRECPTDATE'.chr($i)]);
		 	$border_left=($i==65)?" border-left:1px solid #ccc;":" border-left:0px solid #ccc;";
			if($student_exam_details['FAPPEAR'.chr($i)]=='N')
			{		
				$td_data="NE";
				$id=" id ='cand_entry_".chr($i)."'";
			}	
			else if($student_exam_details['FAPPEAR'.chr($i)]=='P')
			{
				$td_data="Pass";
				$id=" id ='cand_entry_".chr($i)."'";
			}	
			else  if($student_exam_details['FAPPEAR'.chr($i)]=='A' || $student_exam_details['FAPPEAR'.chr($i)]=='E')
			{
			array_push($exam_appear,chr($i));
			$id=" id='cand_entry_".chr($i)."'";
			$td_data="<Input  onclick=showExamNosDiv('{$html_id}'); {$id}  name='radio_common' type='radio'>";
			$id='';
			}
			else  
			{
				$td_data="<font color=red>&nbsp;</font>";
				$id=" id ='cand_entry_".chr($i)."'";
			}
			 $e_data.="<td align=center style='padding:2px;  border-bottom:1px solid #ccc; {$border_left}border-right:1px solid #ccc;'  {$id} >{$td_data}</td>";
			  $fee_td.="<td align=center style='padding:2px;  border-bottom:1px solid #ccc; {$border_left}border-right:1px solid #ccc; color: #B52DA0;    font-weight: bold; ' id='ssub_fee_".chr($i)."' >&nbsp;</td>";
			  
		}
		 
		 
		$e_data.="</tr>";
			$e_data.="</tr>{$fee_td}</tr>";
		$e_data.="</table>";
		// get total Subs
		$get_total_sub_for_degree="select * from degree where FDEGREE='{$degree}'";
		$lobj_get_total_sub_for_degree = $aobj_context->mobj_db->GetAll($get_total_sub_for_degree); 
		 
		for($j=0;$j<count($lobj_get_total_sub_for_degree);$j++)
		{
				if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='A')
			{ $exam_A_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];$semister_names['A']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='B')
			{ $exam_B_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];$semister_names['B']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='C')
			{$exam_C_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];$semister_names['C']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='D')
			{$exam_D_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];$semister_names['D']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='E')
			{$exam_E_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];$semister_names['E']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='F')
			{$exam_F_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];$semister_names['F']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];}	
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='G')
			{$exam_G_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];$semister_names['G']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='H')
			{$exam_H_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];$semister_names['H']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='I')
			{$exam_I_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];$semister_names['I']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='J')
			{$exam_J_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];$semister_names['J']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];}
		}
	  // Exam A Div
	   
		for($i=65;$i<75;$i++)
		{ 
		 if(in_array(chr($i),$exam_appear))
		 {
			$id='';
			$remaining_count=0;
			$id="\$exam_".chr($i);
			$html_id="candidate_list_exam_".chr($i)."_details";
		 
			 $char_name=chr($i);
			 $max_limit="\$exam_".$char_name."_limit";
			 eval("\$max_limit = \"$max_limit\";");
		 
			 $FEXAMNO=chr($i);	
			 $id="<table  class='tr_ventor_row'  align='center' width=95% border='0' cellspacing='0' cellpadding='0'>";	
			 $id.="<th align='left' colspan='10' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:10px; padding-left:6px; height:20px;'>{$semister_names[$FEXAMNO]}</th>";
			// $id="<table   width='95%' align='center' cellspacing='0' cellpadding='0' border='0' >";
			 //$id.=" <tr><td class='act_txtclr' colspan='5' style='background-color:#3D83CC; color:#fff; font-weight:700; width:222px; padding-left:5px; letter-spacing:0.5pt;'>{$semister_names[$FEXAMNO]} </td> </tr>";
			$id.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
			$id.="<td align='center' style='  font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sub Code</td>";			
			$id.="<td align='center' style='  font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>QP Code</td>";			
			$id.="<td align='center' style='  font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Description</td>";			
			$id.="<td align='center' style='  font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Pass Mth<input type=checkbox id='{$html_id}^{$char_name}' onclick='checkAllCandidateSemisterSub(this.id);' ></td>";			
			/* $id.="<tr style='background-image:url(../jqGrid3/themes/tarka/images/grid-blue-hd.gif);border-bottom:1px solid #CBC7B8; color:#000; font-weight:700; padding:3px 6px; letter-spacing:0.5pt;'>";
			 $id.="<td  align=center style='padding:2px;  border-bottom:1px solid #ccc; border-left:1px solid #ccc; border-right:1px solid #ccc;width:23px;'>Code</td>";
			 $id.="<td align=center  style='padding:2px;   border-bottom:1px solid #ccc;border-left:0px solid #ccc; border-right:1px solid #ccc;width:90px'>Short Name</td>";
			 $id.="<td align=center  style='padding:2px;  width:160px; border-bottom:1px solid #ccc;border-left:0px solid #ccc; border-right:1px solid #ccc;'>Description</td>";
			 $id.="<td  align=center style='padding:2px;  border-bottom:1px solid #ccc; border-left:0px solid #ccc; border-right:1px solid #ccc;width:80px'>Pass M/Y<input type=checkbox id='{$html_id}^{$char_name}' onclick='checkAllCandidateSemisterSub(this.id);' ></td>";
			 */ $id.="</tr>";
			  
			$get_header_exam_details="select c.FSUBCODE,s.FSUBNAME,ifnull(c.FPASSMTH,'') as FPASSMTH,
			s.FQPCODE AS FSUBSHORT,c.FEXAMTYPE,
			ifnull(c.FPRESENT,'N') as FPRESENT,
			if(c.FINSERTED='','F',c.FINSERTED) as FINSERTED	from canddet c 
			inner join subject s on s.FDEGREE=c.FDEGREE
			and s.fexamno = c.fexamno and s.FSUBCODE=c.FSUBCODE 
			where c.FCOLLCODE='{$college_code}' and c.FDEGREE='{$degree}' and  
			c.FEXAMNO='{$FEXAMNO}' and
			c.FREGNO='{$Regno}' group by c.FSUBCODE limit $max_limit ";
		    $lobj_rs = $aobj_context->mobj_db->GetAll($get_header_exam_details); 
		 //echo $get_header_exam_details;
			  $remaining_count=$max_limit-count($lobj_rs);
			  $k=0;
			  $txt_id=0;
			
				for($m=0;$m<count($lobj_rs);$m++)
				{
					$code_pop_up_field="";
					$FSUBCODE=$lobj_rs[$m]['FSUBCODE']; 
					$get_theroy_cnt="SELECT COUNT(1) AS t_cnt FROM subject WHERE FDEGREE='{$degree}' AND fexamno='{$FEXAMNO}'
												AND FSUBCODE='{$FSUBCODE}'
												AND IFNULL(ftheory,'')  =  'T' AND IFNULL(fintass,'') <> 'T' AND IFNULL(fretain,'') <> 'T' 	 
												";
							$lobj_get_theroy_cnt = $aobj_context->mobj_db->GetRow($get_theroy_cnt); 	
							$th_cnt=$lobj_get_theroy_cnt['t_cnt'];
							
							$get_prc_cnt="SELECT COUNT(1) AS p_cnt FROM subject WHERE FDEGREE='{$degree}' AND fexamno='{$FEXAMNO}'
												AND FSUBCODE='{$FSUBCODE}'
												AND IFNULL(ftheory,'') <> 'T' AND IFNULL(fintass,'') <> 'T' AND IFNULL(fretain,'') <> 'T' 
												";
							$lobj_get_prc_cnt = $aobj_context->mobj_db->GetRow($get_prc_cnt); 	
							$pr_cnt=$lobj_get_prc_cnt['p_cnt'];
						 
							if($th_cnt>1) $th_cnt=max(2,$th_cnt);
							if($pr_cnt>1) $pr_cnt=max(2,$pr_cnt);
					$FSUBSHORT=$lobj_rs[$m]['FSUBSHORT']; 
					$FSUBNAME=$lobj_rs[$m]['FSUBNAME']; 
					 if($lobj_rs[$m]['FPASSMTH']=='' or is_null($lobj_rs[$m]['FPASSMTH']))// to display pass M/Y based on the  value
					 {
					 
					$checked=($lobj_rs[$m]['FPRESENT']=='P')?" checked ":"";	
					// Default Making as checked as Pondi Uni preffers all Subjects to Take
					//$checked= " checked " ;	//for default check status
					$FPASSMTH="<input type='checkbox' {$checked} onclick='UpdateExamFeeForEachSelectedSubject();' id='exam_{$char_name}_ce_pass_{$txt_id}'>";	
					$FPASSMTH.="<input type='hidden'   id='exam_{$char_name}_th_cnt_{$txt_id}' value='{$th_cnt}' /> ";	
					$FPASSMTH.="<input type='hidden'   id='exam_{$char_name}_pr_cnt_{$txt_id}' value='{$pr_cnt}' /> ";	
						
					$FPASSMTH_TD="";
					$code_pop_up_field="";					
					}
					else  
					{
					$FPASSMTH=$lobj_rs[$m]['FPASSMTH'];	
					$FPASSMTH_TD=" id='exam_{$char_name}_ce_pass_{$txt_id}' ";
					$code_pop_up_field='readonly=true;';					
					}
					 if($lobj_rs[$m]['FINSERTED']=='T')// to display text box for the value if FINSERTED=''T
					 {
					$sub_code_input_border=	"";
					$sub_code_input_popup=" onblur='getSubDetails(this.id,{$txt_id});'  onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'";
					$sub_code_input_name="di";
					$input_tab_indx=" tabindex={$txt_id}";
					$read_only=" ";
					}
					else  
					{
					$sub_code_input_border=	" border:none;";
					$sub_code_input_popup=	"";
					$sub_code_input_name="update";
					$input_tab_indx=" tabindex=-1";
					$read_only=" readonly";
					}
					if($k%2==0)
					{
					$class='tbl_row';
					$inp_class='tbl_row_input';
					}
					else
					{
					$input_class='tbl_row1'; 
					$inp_class='tbl_row1_input';
					}  
					  $id.="<tr>";
					 $id.="<td align='center' style='  font-size:12px;   border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><input {$code_pop_up_field} {$inp_class} type=text style='width:55px;{$sub_code_input_border}' {$read_only} {$sub_code_input_popup} name='{$sub_code_input_name}'   id='exam_{$char_name}_ce_sub_code_{$txt_id}' {$input_tab_indx} value='{$FSUBCODE}'></td>";
					 $id.="<td align='center'  style='  font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'id='exam_{$char_name}_ce_short_name_{$txt_id}' > {$FSUBSHORT}</td>";
					 $id.="<td align='left' id='exam_{$char_name}_ce_desc_{$txt_id}'  style='  font-size:12px;    border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>   {$FSUBNAME}</td>";
					 $id.="<td style='  font-size:12px;    border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;' align='center'  {$FPASSMTH_TD} >{$FPASSMTH} </td>";
					 $id.="</tr>";   
					 $k++;
					 $txt_id++;
				}
				// for non entered Subjects
				 
				 
				if($remaining_count>0)
				{$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';
						}  
						  $id.="<tr>";
						 $id.="<td align='center'   style=' font-size:12px;   border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><input  type='text' {$inp_class} name='new_insert'  onblur='getSubDetails(this.id,{$txt_id});'  onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' style='width:60px;' tabindex={$txt_id}   id='exam_{$char_name}_ce_sub_code_{$txt_id}'>&nbsp;</td>";
						 $id.="<td align='center'  style=' font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'id='exam_{$char_name}_ce_short_name_{$txt_id}'>&nbsp;</td>";
						 $id.="<td align='left'  id='exam_{$char_name}_ce_desc_{$txt_id}'   style=' font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>&nbsp;</td>";
						 $pr_th_cnt="<input type='hidden'   id='exam_{$char_name}_th_cnt_{$txt_id}' value='0' /> ";	
						 $pr_th_cnt.="<input type='hidden'   id='exam_{$char_name}_pr_cnt_{$txt_id}' value='0' /> ";	
								
						 $id.="<td  style='padding:2px;  font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;' align='center'  ><input type='checkbox'  onclick='UpdateExamFeeForEachSelectedSubject();' id='exam_{$char_name}_ce_pass_{$txt_id}' >  {$pr_th_cnt} </td>";
						 $id.="</tr>";											 
						 $k++;
						 $txt_id++;
					}		 
				}
				 
				$total_count_of_each_div[$html_id]=$txt_id;			
				 $exam_fee_val=$exam_fee[$html_id];
				// echo $exam_fee[$html_id];
				 $exam_receipt_no_val=$exam_receipt_no[$html_id];
				 $exam_receipt_no_date_val=$exam_receipt_no_date[$html_id];
				 
					//for Total Input Box
				/* 	 $id.="</tr><tr>";
					 $id.="<td align='right' style='padding:2px; font-size:12px;   border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><div style='border:1px solid #C5DBEC;'>Receipt No:</div></td>";
					 $id.="<td align='left'  style='font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><input type='text' style='width:85px;' id='exam_{$char_name}_receipt_no' value='{$exam_receipt_no_val}'> &nbsp;&nbsp;Date:</font></td>";
					 $id.="<td    style='font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'align=left><input style='width:75px;' value='{$exam_receipt_no_date_val}' id='exam_{$char_name}_date' type='text' />							
							<script>$('#exam_{$char_name}_date').datepicker({showOn: 'button',showButtonPanel: true, changeMonth: true, changeYear: true,dateFormat:'dd/mm/yy', buttonImage: 'images/cal.jpg', buttonImageOnly: true});</script>							
							 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td>";										 
					 $id.="<td style=' background-color:Coral;font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;' align='center'><input readonly type=text onblur=showExamNosDiv('{$html_id}');CheckCheckBoxIsChecked('{$html_id}') id='{$html_id}_total' style='width:76px;background-color:Coral;border:none;' value='{$exam_fee_val}' align='right' onkeypress='return acceptNumbersOnlyForModule(event);'>  </td>";
					 $id.="</tr>";
					$id.="</table>" */;
				$get_fee_data="SELECT FHEADCODE, FFEE,
				IF('{$FFRESHEXAM}'='{$char_name}',FFEE,FREPFEE) AS O_FFEE,
				IF('{$FFRESHEXAM}'='{$char_name}',FPRFEE,FREPPRFEE) AS FPRFEE ,FMAXFEE
				FROM admfeestr a
				WHERE FDEGREE='{$degree}'
				AND FEXAMNO='{$char_name}'
				AND FCOMBCODE='EXAM' 
				AND ifnull(FUSED,'') = 'T'
				AND FCATCODE='{$category}'
				and FCONSTYPE='{$li}'
				order by FHEADCODE";
				
				session_start();
				$FUNIVCODE=$_SESSION['FUNIVCODE'];
					 
				if($FUNIVCODE=="013" && $FFRESHEXAM != $char_name)//checking specific to univeristy
				{
					$get_cnt="select count(fsubcode) as rep_cnt from canddet
					WHERE FDEGREE='{$degree}'
					AND FEXAMNO='{$char_name}'
					AND FCOLLCODE='{$college_code}'
					AND FREGNO='{$Regno}'
					AND ifnull(FPASSMTH,'')=''
					";
					$lobj_get_cnt = $aobj_context->mobj_db->GetRow($get_cnt); 	
					 
					$rep_cnt=	$lobj_get_cnt['rep_cnt'];
					if($rep_cnt>3)// changing only qry
					{
						$get_fee_data="SELECT  FHEADCODE,FFEE,
						IF('{$FFRESHEXAM}'='{$char_name}',FFEE,FREPFEE) AS O_FFEE,
						IF('{$FFRESHEXAM}'='{$char_name}',FPRFEE,FREPPRFEE) AS FPRFEE ,FMAXFEE
						FROM admfeestr a
						WHERE FDEGREE='{$degree}'
						AND FEXAMNO='{$char_name}'
						AND FCOMBCODE='EXAM' 
						AND FCATCODE='GM'
						and FCONSTYPE='{$li}'
						order by FHEADCODE";
					}
				}
				//var_dump($get_fee_data);
				$lobj_get_fee_data = $aobj_context->mobj_db->GetAll($get_fee_data); 	
					 
				$fee_cnt=count($lobj_get_fee_data)+1;
							
				$id.="<tr>";
				$id.="<td colspan='4' style=' border-bottom:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-left:1px solid #C5DBEC;'>";
				$id.="";  
				$tr="<table id='fee_table_{$char_name}' style='margin:9px;width:60%;'  class='tr_ventor_row'   border='0' cellspacing='0' cellpadding='0' >	 <th align='left' colspan='2' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:17px;background:#C48F2D;'>Fee Details</th>";
				$tr.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
				$tr.="<td align='center' style=' font-weight:bold; font-size:12px; border-left:1px solid #C5DBEC; border-top:1px solid #C5DBEC ; border-right:1px solid #C5DBEC;  '>Fee Details</td>";			
				$tr.="<td align='center' style=' font-weight:bold; font-size:12px; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC ; border-bottom:1px solid #C5DBEC;'> Amount</td>";			
				$tr.="</tr>";

$tot=0;
				foreach($lobj_get_fee_data as $ak=>$av)
				{
					$tr.=" <tr class=''>";
					$h_code=substr($av[FHEADCODE],0,2);	
					$tr.="<td align='left' style='border-top:1px solid #C5DBEC ;border-left:1px solid #C5DBEC; ' id='tfh_{$char_name}_{$h_code}'>{$av[FHEADCODE]}</td>";

$input_val=0;
					$exist_value=$existing_fee_arr[$char_name][$av[FHEADCODE]];
					if(!empty($exist_value))
					$input_val=$exist_value;
					$O_FFEE=$av['O_FFEE'];							 
					$tot+=$input_val;							 
					$tr.="<td   align='center'  style='border-right:1px solid #C5DBEC;border-left:1px solid #C5DBEC;  border-bottom:1px solid #C5DBEC;' > <input  type=hidden value='{$av['O_FFEE']}' id='o_fee_{$char_name}_{$h_code}' />  <input  type=hidden value='{$av['FPRFEE']}' id='prfee_{$char_name}_{$h_code}' />  <input  type=hidden value='{$av['FMAXFEE']}' id='minnfee_{$char_name}_{$h_code}' /> <input  onblur='CalculateNewwFeeTotals();' style='width:56px;border:none;text-align:center; '  type=text value='{$input_val}' id='nfee_{$char_name}_{$h_code}'></td>";
					$tr.=" </tr>";
				}
				$tr.=" <tr class='ui-state-default ui-jqgrid-hdiv'>";	
				$tr.="<td align='center' style='font-weight:bold;border-left:1px solid #C5DBEC ;background:#27E87A; border-top:1px solid #C5DBEC ;border-right:1px solid #C5DBEC;   border-bottom:1px solid #C5DBEC;'> Total </td>";
				$tr.="<td align='center' style=' border-right:1px solid #C5DBEC;border-right:1px solid #C5DBEC;background:#27E87A;   border-bottom:1px solid #C5DBEC;'><input style='text-align:center;border:none;font-weight:bold;background:#27E87A;' id='nfee_{$char_name}_total' value={$tot} /></td>";
								
				$tr.="</tr></table>";
	 
				$id.=$tr ;

$id.="</td></tr>";//close fee row

$id.="<tr>";
				$id.="<td  colspan='4' >";
				$id.=" <div style='border-left:1px solid #C5DBEC;  border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;   padding:4px; height:22px;'>";
				$id.="<div style='width:74px; float:left'>Receipt No:</div>";
				$id.="<div style='width:99px; float:left'><input type='text' style='width:85px;' id='exam_{$char_name}_receipt_no' value='{$exam_receipt_no_val}'></div>";
				$id.="<div style='float:left;'>Date:</div>";
				$id.="<div style='width:95px;  border:1px solid #ccc; float:left;'>
				<input  style='width:75px; border:0px;' id='exam_{$char_name}_date' value='{$exam_receipt_no_date_val}'   type='text' value='00/00/0000' />
				<script>$('#exam_{$char_name}_date').datepicker({showOn: 'button',showButtonPanel: true, changeMonth: true,	changeYear: true,dateFormat:'dd/mm/yy',buttonImage: 'images/date.gif', buttonImageOnly: true});</script></div>";				
				$id.="<div style='width:40px; float:left;'>&nbsp;</div>";
				
				$id.="</td></tr>";
				$id.="</table>";		 
				$arr[$html_id]=$id;  
			}		
		}	
	   
		
		$arr['table_data']=$student_exam_details;
		$arr['html_data']=$e_data;
		$arr['date']=is_null($student_exam_details['FRECPTDATE'])?date('d/m/Y'):$student_exam_details['FRECPTDATE'];
		 
		$arr['total_count_of_each_div']=$total_count_of_each_div;
		
		if($lobj_get_total_sub_for_degree)	
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		else
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
		return;
}
function saveCandidateEntryDetails($aobj_context)
{
	session_start();	
	 
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    $college_code = $_SESSION['collcode']; 	
    $FLOGNAME =  $_SESSION['usr']; 	
    $reg_no = $aobj_context->mobj_data["reg_no"]; 	
    $degree = $aobj_context->mobj_data["degree"];
    $total_fee = $aobj_context->mobj_data["total_fee"];
    $candidate_list_receipt_no = $aobj_context->mobj_data["candidate_list_receipt_no"];
    $candidate_list_remarks = trim($aobj_context->mobj_data["candidate_list_remarks"]);
    $candidate_list_date = trim($aobj_context->mobj_data["candidate_list_date"]);   
    $category = trim($aobj_context->mobj_data["category"]);   
    $li = trim($aobj_context->mobj_data["li"]);   
	include_once("/JSON.php"); 
	$json = new Services_JSON();
	
	$college_path=$aobj_context->main_src."/student_photos/{$college_code}";
	$folder_path=$aobj_context->main_src."/student_photos/{$college_code}/".replaceChars($degree);
	$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.'/'.$reg_no."_".$file_name;;
	$image_path="student_photos/{$college_code}/".replaceChars($degree).'/'.$reg_no."_".$file_name;;
	$photo_path="";
	if(!file_exists($college_path))
	{
	 mkdir($college_path);
	}if(!file_exists($folder_path))
	{
	 mkdir($folder_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;
			$update_student_table="update student set FPHOTOPATH='{$photo_path}' where 
			FREGNO='{$reg_no}' and FDEGREE='{$degree}' and FCOLLCODE='{$college_code}'";
			$lobj_update_student_table = $aobj_context->mobj_db->Execute($update_student_table); 	
			echo mysql_error();
		}
	}	
	$unlink_file=trim($aobj_context->mobj_data["unlink_file"]);
	//if($unlink_file!="images/default_photo.jpg")
	//unlink($aobj_context->main_src.'/'.$unlink_file);
	 
	$lstr_param = stripslashes($aobj_context->mobj_data["details"]);
	$mobj_jsondata = $json->decode($lstr_param);
	$sub_arr_data = get_object_vars($mobj_jsondata);
	
	$check_adminsion_freeze ="  select distinct c.FCCLSTATUS, d.fmeyear, d.fmeexamtyp from colldeg c, degree d 
	where c.fdegree = d.fdegree and c.FCOLLCODE='{$college_code}' 
	and c.FDEGREE='{$degree}'";								
	$lobj_check_adminsion_freeze = $aobj_context->mobj_db->getRow($check_adminsion_freeze); 
	//insertStudFeeDetails($aobj_context,$degree,$college_code,$reg_no,$FLOGNAME);
	//echo $check_adminsion_freeze; die();
	if(is_null($lobj_check_adminsion_freeze['FCCLSTATUS']))
	{
		$lstr_sub_fee = stripslashes($aobj_context->mobj_data["sub_fee"]);
		$mobj_lstr_sub_fee = $json->decode($lstr_sub_fee);
		$sub_fee_data = get_object_vars($mobj_lstr_sub_fee);
	
		//delete Newly inserted records
		for($i=65;$i<75;$i++)
		{
			$exam_data='';
			$char_id=chr($i);
			$exam_data=get_object_vars($sub_arr_data[$char_id]);
			if(!empty($exam_data))
			{
				
				for($k=0;$k<count($exam_data);$k++)
				{
					//if($exam_data[$k]->sub_code!='' && $exam_data[$k]->opr=='di' && $exam_data[$k]->smy!=-1)
					//{
					$FRESENT=($exam_data[$k]->smy=='1')?"P":"N";
					$delete_from_canddet_records="delete  from canddet where 
					FINSERTED='T' and  FEXAMNO='{$exam_data[$k]->ex}'
					and  FDEGREE='{$degree}' and  FCOLLCODE='{$college_code}' 
					and FREGNO='{$reg_no}'";
					$lobj_delete_from_canddet_records = $aobj_context->mobj_db->Execute($delete_from_canddet_records);
					//}
				}
			}
		}
		// do insert/update	
		for($i=65;$i<75;$i++)
		{
			$exam_data='';
			$char_id=chr($i);
			$exam_data=get_object_vars($sub_arr_data[$char_id]);
			if(!empty($exam_data))
			{		
				for($k=0;$k<count($exam_data);$k++)
				{
					// updates only the records
					if($exam_data[$k]->sub !='' && $exam_data[$k]->opr=='update' && $exam_data[$k]->smy!=-1)
					{
						$FRESENT=($exam_data[$k]->smy=='1')?"P":"N";
						$update_canddet_records="update canddet set FPRESENT='{$FRESENT}' 
						where 
						FDEGREE='{$degree}' and  FCOLLCODE='{$college_code}' 
						and FREGNO='{$reg_no}' and FSUBCODE='{$exam_data[$k]->sub}' ";
						$lobj_update_canddet_records = $aobj_context->mobj_db->Execute($update_canddet_records);
					}
					// Inserts New Records
					else if($exam_data[$k]->sub!='' && $exam_data[$k]->opr=='new_insert' && $exam_data[$k]->smy!=-1)
					{
						$FRESENT=($exam_data[$k]->smy=='1')?"P":"N";
						$insert_canddet_records="insert into canddet 
						(FDEGREE,
						FEXAMNO,
						FCOLLCODE,
						FREGNO,
						FSUBCODE,
						FINSERTED,
						FPRESENT, fyear, fexamtype) values
						(
						'{$degree}',
						'{$exam_data[$k]->ex}',
						'{$college_code}',
						'{$reg_no}',
						'{$exam_data[$k]->sub}',
						'T',
						'{$FRESENT}', '{$lobj_check_adminsion_freeze['fmeyear']}', '{$lobj_check_adminsion_freeze['fmeexamtyp']}'	
						)";
						$lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($insert_canddet_records);
					}
					
					else if($exam_data[$k]->sub!='' && $exam_data[$k]->opr=='di' && $exam_data[$k]->smy!=-1)
					{
						$FRESENT=($exam_data[$k]->smy=='1')?"P":"N";
						$insert_canddet_records="insert into canddet 
						(FDEGREE,
						FEXAMNO,
						FCOLLCODE,
						FREGNO,
						FSUBCODE,
						FINSERTED,
						FPRESENT, fyear, fexamtype) values
						(
						'{$degree}',
						'{$exam_data[$k]->ex}',
						'{$college_code}',
						'{$reg_no}',
						'{$exam_data[$k]->sub}',
						'T',
						'{$FRESENT}', '{$lobj_check_adminsion_freeze['fmeyear']}', '{$lobj_check_adminsion_freeze['fmeexamtyp']}'	
						)";
						$lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($insert_canddet_records);
					}
					$insert_canddet_records="insert into marks 
					(FDEGREE,
					FEXAMNO,
					FCOLLCODE,
					FREGNO,
					FSUBCODE,
					fmarks,
					fyear, fexamtype) select '{$degree}',
					'{$exam_data[$k]->ex}',
					'{$college_code}',
					'{$reg_no}',
					concat(s.fsubcode,s.fssubcode),
					-1, '{$lobj_check_adminsion_freeze['fmeyear']}', '{$lobj_check_adminsion_freeze['fmeexamtyp']}' from subject s	
					where s.fdegree = '{$degree}' and s.fexamno = '{$exam_data[$k]->ex}' and s.fsubcode = '{$exam_data[$k]->sub}' 
					and s.fintass = 'T' and s.fretain = 'T'";
					$lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($insert_canddet_records);
					
					$insert_canddet_records="insert into marks_pr 
					(FDEGREE,
					FEXAMNO,
					FCOLLCODE,
					FREGNO,
					FSUBCODE,
					fmarks11,
					fyear, fexamtype) select '{$degree}',
					'{$exam_data[$k]->ex}',
					'{$college_code}',
					'{$reg_no}',
					concat(s.fsubcode,s.fssubcode),
					'-1', '{$lobj_check_adminsion_freeze['fmeyear']}', '{$lobj_check_adminsion_freeze['fmeexamtyp']}' from subject s	
					where s.fdegree = '{$degree}' and s.fexamno = '{$exam_data[$k]->sub}'  and s.ftheory = 'F' and ifnull(s.fintass,'F') <> 'T'";
					$lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($insert_canddet_records);
					
				}
			} 
		} 
			 //var_dump($sub_fee_data['F']);
			// to update the exam a/b details
		 
		for($i=65;$i<75;$i++)
		{
			$char_id=chr($i);
			$sub_fee_datas=get_object_vars($sub_fee_data[$char_id]);
			if(!empty($sub_fee_datas))
			{
				$update_records="update candsum set  
				FEXAMFEE{$char_id}='{$sub_fee_datas[0]->total_fee}', 
				FRECPTNO{$char_id}='{$sub_fee_datas[0]->receipt_no}', 
				FRECPTDATE{$char_id}='{$sub_fee_datas[0]->date}' 
				where  FDEGREE='{$degree}' and  FCOLLCODE='{$college_code}' 
				and FREGNO='{$reg_no}' ";  
				$lobj_update_records = $aobj_context->mobj_db->Execute($update_records);
			} 
		}
		$update_total_fee="update candsum set FTOTALFEE={$total_fee},
		FLOGNAME='{$FLOGNAME}',
		FCATEGORY='{$category}',
		FFEETYPE='{$li}',
		FRECPTDATE='{$candidate_list_date}', 
		FREMARKS='{$candidate_list_remarks}',
		FRECPTNO='{$candidate_list_receipt_no}',
		FLOGDATE=now()
		where  FDEGREE='{$degree}' and  FCOLLCODE='{$college_code}' 
		and FREGNO='{$reg_no}'  ";
					 
		$lobj_update_total_fee = $aobj_context->mobj_db->Execute($update_total_fee);
		$update_student_category="update student set FCASTE='{$category}' where FREGNO='{$reg_no}'";
		$lobj_update_student_category = $aobj_context->mobj_db->Execute($update_student_category);
			// to insert STUDFEE	
		insertStudFeeDetails($aobj_context,$degree,$college_code,$reg_no,$FLOGNAME);
		if($lobj_update_total_fee) 
		{
			$arr='Details Updated Successfully';
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
			return;
		}
		else
		{
			$arr='Updation failed';
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success"); 
			return;
		}
	}
	else
	{
		$arr='Candidate List Freezed By Admin';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
		return;	
	}
} 
function insertStudFeeDetails($aobj_context,$degree,$college_code,$reg_no,$FLOGNAME)
{
 	
	include_once("/JSON.php"); 
	$json = new Services_JSON();
	$lstr_fee_details = stripslashes($aobj_context->mobj_data["new_fee_details"]);
	
	$mobj_lstr_fee_details = $json->decode($lstr_fee_details);
	$fee_details_data = get_object_vars($mobj_lstr_fee_details);
	  
	for($i=65;$i<75;$i++)
	{
		$char_id=chr($i);
		if(($fee_details_data[$char_id])!=0)
		{
			$delete_from_stud_fee="delete from studfee where 
			FDEGREE='{$degree}'
			and FEXAMNO='{$char_id}'
			and FCOLLCODE='{$college_code}'
			and FREGNO='{$reg_no}'";
			$lobj_delete_from_stud_fee = $aobj_context->mobj_db->Execute($delete_from_stud_fee);	
			$insert_arr=get_object_vars($fee_details_data[$char_id]);	
		
			if(count($insert_arr)>0)
			{
			 
				foreach( $insert_arr as $ak=>$av)
				{
					$FFEECODE=$ak;
					$FAMOUNT=$av;
					
					$insert_into_student_fee="insert into studfee
					(
					FDEGREE,FEXAMNO,FCOLLCODE,FREGNO,FFEECODE,FAMOUNT,FLOGNAME,FLOGDATE
					) VALUES
					(
					'{$degree}',
					'{$char_id}',
					'{$college_code}',
					'{$reg_no}',
					'{$FFEECODE}',
					'{$FAMOUNT}',
					'{$FLOGNAME}',
					NOW()
					)";
					$lobj_insert_into_student_fee = $aobj_context->mobj_db->Execute($insert_into_student_fee);	
							 
				}
			}
		 // 
			$lobj_update_records = $aobj_context->mobj_db->Execute($update_records);
		}
	}
}
function getExamfeeNames($aobj_context)
{
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    $college_code = $_SESSION['collcode']; 	
    $FLOGNAME =  $_SESSION['usr']; 	
    $reg_no = $aobj_context->mobj_data["reg_no"]; 
    $degree = $aobj_context->mobj_data["degree"]; 
    $exam_no = $aobj_context->mobj_data["exam_no"]; 
	
	$get_existing_data="select ifnull(GROUP_CONCAT(FFEECODE,'_',FLOOR(FAMOUNT) separator '~'),0) as stu_data from studfee 
	where FREGNO='{$reg_no}'
	and FDEGREE='{$degree}'
	and FCOLLCODE='{$college_code}'
	and FEXAMNO='{$exam_no}'";
	
	$aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=100000");
	$lobj_get_existing_data = $aobj_context->mobj_db->getRow($get_existing_data);
	$exsting_data=$lobj_get_existing_data[stu_data]; 	
	$select_data="select '{$exam_no}' as exam_no,'{$exsting_data}' as stu_data,FFEECODE,FSHORTNAME,FDESCPN from masfee order by FSEQUENCE";
	$lobj_select_data = $aobj_context->mobj_db->getAll($select_data);
	
	$fee_data.="<table align='center' cellspacing='0' cellpadding='0' border='0' width='98%'>";
	//$fee_data.="<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;'>User Rights</th>";
	$fee_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>";						
	$fee_data.="<td align='center' style='font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Particulars</td>";
	$fee_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Amount</td>";									
	$fee_data.="</tr>";
	$k=0;
	foreach($lobj_select_data as $key=>$val)
	{
		if($k%2==0)
			
			$fee_data.="<tr class='ui-widget-content jqgrow' >";
			$fee_data.="<td align='left' style='font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC; padding:2px;'>{$val[FDESCPN]}</td>";
			$fee_data.="<td style='padding:2px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC; font-size:12px; '><input style='width:90px; text-align:right; border:1px solid #C5DBEC;' type='text' value=0 id='fee_{$exam_no}_{$val[FFEECODE]}_amount'></td>";

$fee_data.="</tr>";
			$k++;
	}
	$fee_data.="</table>";		
	//$fee_data.=" <br><input type='button' value='OK' onclick=AssignMarkstoGlobalVariable('{$exam_no}');>&nbsp;<input type='button' value='Cancel' onlcick=removeFeePopUp('');>";		
	$fee_data.=" <br><input type='button'  class='ui-corner-all ui-widget-header' style='font-size:12px;' value='OK' onclick=AssignMarkstoGlobalVariable('{$exam_no}');>&nbsp;";
	$fee_data.=" <input type='button' class='ui-corner-all ui-widget-header' style='font-size:12px;' value='Cancel' onclick=removeFeePopUp();>";		
	$arr['fee_data']=$fee_data;
	$arr['table_data']=$lobj_select_data;
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Success");	
}
function GetCandidateListPhoto($aobj_context)
{
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    $college_code = $_SESSION['collcode']; 	
	$reg_no = $aobj_context->mobj_data["reg_no"]; 
    $degree = $aobj_context->mobj_data["degree"]; 
	$get_student_path="select ifnull(FPHOTOPATH,'') as FPHOTOPATH  from student
	where   FREGNO='{$reg_no}' and FDEGREE='{$degree}'
	and FCOLLCODE='{$college_code}'";
	$lobj_get_student_path = $aobj_context->mobj_db->getRow($get_student_path);	
	 
	if(!empty($lobj_get_student_path[FPHOTOPATH]))
	{
		$data=$lobj_get_student_path[FPHOTOPATH];
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"Success");	
	}
	else
	{
		$data=$lobj_get_student_path[FPHOTOPATH];
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"Failure");	
	}	
}
function PopulateExamTypeListCategory($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$degree = $aobj_context->mobj_data["degree"]; 
	$reg_no = $aobj_context->mobj_data["reg_no"]; 
	$get_category_names="select FCATEGORY as internal_code,FCATEGORY as value from category ";
	$get_student_cat="SELECT IFNULL(FCASTE,0) as FCATEGORY FROM student WHERE FREGNO='{$reg_no}' ";
	$get_fconst="SELECT DISTINCT FCONSTYPE as internal_code,FCONSTYPE as value FROM admfeestr where FDEGREE='{$degree}' ORDER BY 1 DESC ";
 
	$lobj_get_category_names = $aobj_context->mobj_db->GetAll($get_category_names);
	$lobj_get_fconst = $aobj_context->mobj_db->GetAll($get_fconst);
	$lobj_get_student_cat = $aobj_context->mobj_db->GetRow($get_student_cat);
	 //var_dump($get_fconst);
	$arr['category']=$lobj_get_category_names;
	$arr['FCONSTYPE']=$lobj_get_fconst;
	$arr['FCATEGORY']=$lobj_get_student_cat['FCATEGORY'];
	 
	if($lobj_get_category_names!= 0)	
    echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
}
 ?>

${this.title}

Code Editor : candidate-entry_02122017.php