Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-sr-x
Dispatch_ans_script_setup.php	5.95 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.3 KB	-rwxr-xr-x
DownloadExamAppFormApplication...	5.28 KB	-rwxr-xr-x
ECHblk.php	11.31 KB	-rwxr-xr-x
FormulaEvaluate.php	14.48 KB	-rwxr-xr-x
MarkEntry-Setup.php	26.9 KB	-rwxr-xr-x
PrintApplicationFormPOSTOFFICE...	27.69 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.87 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.82 KB	-rwxr-xr-x
UpdateCollDet.php	1.71 KB	-rwxr-xr-x
XLSXReader.php	9.62 KB	-rwxr-xr-x
absent_entry_setup.php	8.33 KB	-rwxr-xr-x
absent_entry_setupQp.php	7.46 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.22 KB	-rwxr-xr-x
ack_adm_application.php	56.32 KB	-rwxr-xr-x
ack_admentry_application.php	49.35 KB	-rwxr-xr-x
ack_application.php	7.85 KB	-rwxr-xr-x
ack_exam_app_form.php	16.96 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.87 KB	-rwxr-xr-x
ack_registration.php	7.95 KB	-rwxr-xr-x
ack_report.php	2.34 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.7 KB	-rwxr-xr-x
actClass.php	6.38 KB	-rwxr-xr-x
adm_challan_entries.php	14.13 KB	-rwxr-xr-x
adm_delete_data.php	5.71 KB	-rwxr-xr-x
admapprove.php	9.55 KB	-rwxr-xr-x
admchallanpreparation.php	9.01 KB	-rwxr-xr-x
admission_entry_reg.php	40.87 KB	-rwxr-xr-x
admission_entry_status.php	2.79 KB	-rwxr-xr-x
admission_sms_push.php	2.33 KB	-rwxr-xr-x
admissionapplist.php	9.15 KB	-rwxr-xr-x
admregisterlist.php	14.82 KB	-rwxr-xr-x
admstuddate.php	6.27 KB	-rwxr-xr-x
admsumsendsms.php	6.28 KB	-rwxr-xr-x
admuploadexsheet.php	12.57 KB	-rwxr-xr-x
ansbookcancel.php	9.7 KB	-rwxr-xr-x
answer_book_issued.php	10.56 KB	-rwxr-xr-x
applicationFormReportPOSTOFFIC...	26.67 KB	-rwxr-xr-x
apprCandidReport.php	7.14 KB	-rwxr-xr-x
approve.php	38.33 KB	-rwxr-xr-x
attendance.php	10.44 KB	-rwxr-xr-x
attendance_freez.php	8.65 KB	-rwxr-xr-x
attendance_freez_mth.php	8.42 KB	-rwxr-xr-x
attshort.php	6.45 KB	-rwxr-xr-x
auto-complete.php	5.04 KB	-rwxr-xr-x
backup.php	2.95 KB	-rwxr-xr-x
backup_restore.php	8.36 KB	-rwxr-xr-x
backupandrestore.php	10.43 KB	-rwxr-xr-x
batch_close.php	4.43 KB	-rwxr-xr-x
board.php	2.71 KB	-rwxr-xr-x
boeselection.php	1.69 KB	-rwxr-xr-x
bundle_dispatch.php	3.21 KB	-rwxr-xr-x
bundle_rec_ack.php	4.13 KB	-rwxr-xr-x
bundledispatchdatewise.php	12.74 KB	-rwxr-xr-x
bundlereceive.php	1.12 KB	-rwxr-xr-x
bundlestatus.php	5.38 KB	-rwxr-xr-x
cManualMailer.php	2.63 KB	-rwxr-xr-x
caccesscontext.php	1.28 KB	-rwxr-xr-x
candidate-entry.php	44.67 KB	-rwxr-xr-x
cappcontext.php	2.7 KB	-rwxr-xr-x
challan_entries.php	15.65 KB	-rwxr-xr-x
challan_preparation.php	11.91 KB	-rwxr-xr-x
changeDegree.php	1.61 KB	-rwxr-xr-x
changeMobile.php	2.51 KB	-rwxr-xr-x
cmailer.php	6.96 KB	-rwxr-xr-x
cntDeclaration.php	4.23 KB	-rwxr-xr-x
code39.php	6.54 KB	-rwxr-xr-x
coll_exam_app_form.php	1014 B	-rwxr-xr-x
collbankdet.php	1.9 KB	-rwxr-xr-x
colldesp_ack.php	4.08 KB	-rwxr-xr-x
college.php	5.15 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.61 KB	-rwxr-xr-x
college_approve.php	5.71 KB	-rwxr-xr-x
college_degree_status.php	5.76 KB	-rwxr-xr-x
collegebank.php	1.89 KB	-rwxr-xr-x
collfundtransfer.php	2.32 KB	-rwxr-xr-x
connect.php	2.31 KB	-rwxr-xr-x
convdet.php	8.02 KB	-rwxr-xr-x
coutput.php	1.84 KB	-rwxr-xr-x
createAdmission.php	4.06 KB	-rwxr-xr-x
create_all_grid_files.php	8.8 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	10.18 KB	-rwxr-xr-x
create_all_popup_files.php	6.08 KB	-rwxr-xr-x
create_all_schema_files.php	4.42 KB	-rwxr-xr-x
create_all_views.php	16.87 KB	-rwxr-xr-x
create_html_files.php	52.9 KB	-rwxr-xr-x
create_html_files_without_tab....	45.23 KB	-rwxr-xr-x
create_module_meta_columns.php	5.26 KB	-rwxr-xr-x
crequestbroker.php	2.58 KB	-rwxr-xr-x
cronjob_sendsms.php	3.04 KB	-rwxr-xr-x
csessions.php	548 B	-rwxr-xr-x
cuser.php	3.53 KB	-rwxr-xr-x
custom_mregistry.php	124 B	-rwxr-xr-x
database.php	474 B	-rwxr-xr-x
datadictionary.php	4.06 KB	-rwxr-xr-x
daterange.php	8.08 KB	-rwxr-xr-x
degree.php	6.66 KB	-rwxr-xr-x
degreeGroup.php	4 B	-rwxr-xr-x
degstudymat.php	6.45 KB	-rwxr-xr-x
degstudymatdet.php	5.16 KB	-rwxr-xr-x
display_details_in_grid.php	109.22 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.72 KB	-rwxr-xr-x
display_details_in_grid_studta...	99.65 KB	-rwxr-xr-x
display_details_in_grid_withde...	100.58 KB	-rwxr-xr-x
doc_verify.php	7.31 KB	-rwxr-xr-x
downloadFeeStatement.php	5.47 KB	-rwxr-xr-x
download_misc_files.php	4.72 KB	-rwxr-xr-x
download_photo.php	4.17 KB	-rwxr-xr-x
download_upload.php	3.99 KB	-rwxr-xr-x
dynamicmastersdetails.php	120.21 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	122.19 KB	-rwxr-xr-x
entryexitevents.php	3.19 KB	-rwxr-xr-x
examAppChallan.php	7.92 KB	-rwxr-xr-x
execute_query.php	2.57 KB	-rwxr-xr-x
export_import_setup.php	7.8 KB	-rwxr-xr-x
export_import_utility.php	2.75 KB	-rwxr-xr-x
feepaidreports.php	994 B	-rwxr-xr-x
forgotpassword.php	3.22 KB	-rwxr-xr-x
format.php	7.76 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.79 KB	-rwxr-xr-x
freeze_module_at_admin_college...	10.3 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.93 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.99 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.61 KB	-rwxr-xr-x
freezeiaprici.php	10.14 KB	-rwxr-xr-x
general_report_format.php	11.33 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	3.05 KB	-rwxr-xr-x
getMessages.php	11.4 KB	-rwxr-xr-x
getdata.php	36.93 KB	-rwxr-xr-x
getfeeinformation.php	7.28 KB	-rwxr-xr-x
getfeeinformation_bulk.php	7.74 KB	-rwxr-xr-x
getmoduledetails.php	23.94 KB	-rwxr-xr-x
getnumword.php	7.8 KB	-rwxr-xr-x
getreportdetails.php	3.29 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.43 KB	-rwxr-xr-x
getsearchcondition.php	1.37 KB	-rwxr-xr-x
ggridmodel.php	9.59 KB	-rwxr-xr-x
golden_palm_payslip.php	12.86 KB	-rwxr-xr-x
helptext.php	5.54 KB	-rwxr-xr-x
identify_transactions.php	6.56 KB	-rwxr-xr-x
import_marks.php	4.27 KB	-rwxr-xr-x
index.php	5.17 KB	-rwxr-xr-x
json.php	34.52 KB	-rwxr-xr-x
login.php	18.88 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.33 KB	-rwxr-xr-x
login_old.php	3.23 KB	-rwxr-xr-x
login_wait.php	11.78 KB	-rwxr-xr-x
mascomb.php	10.27 KB	-rwxr-xr-x
mcverifydet.php	14.61 KB	-rwxr-xr-x
message_board.php	4.84 KB	-rwxr-xr-x
messagetext.php	1010 B	-rwxr-xr-x
module_setup.php	2.56 KB	-rwxr-xr-x
mregistry.php	92.4 KB	-rwxr-xr-x
mrn_approval.php	9.24 KB	-rwxr-xr-x
nobleRegn.php	4.08 KB	-rwxr-xr-x
payment_gateway.php	8.01 KB	-rwxr-xr-x
photoupload.php	9.52 KB	-rwxr-xr-x
post.php	5.21 KB	-rwxr-xr-x
printexamform.php	11.87 KB	-rwxr-xr-x
push_data_to_studentportal.php	1.86 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.72 KB	-rwxr-xr-x
remove_exam_ack.php	3.63 KB	-rwxr-xr-x
report_admission_ticket.php	48.07 KB	-rwxr-xr-x
report_hall_ticket.php	11.47 KB	-rwxr-xr-x
report_iamarks_pending.php	12.35 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	12.15 KB	-rwxr-xr-x
report_setup.php	25.56 KB	-rwxr-xr-x
report_tool.php	74.93 KB	-rwxr-xr-x
result.php	5.18 KB	-rwxr-xr-x
resultsheet.php	9.15 KB	-rwxr-xr-x
revaluation.php	17.01 KB	-rwxr-xr-x
revaluation_withdegree.php	17.13 KB	-rwxr-xr-x
room_allotment.php	8.13 KB	-rwxr-xr-x
room_allotment_datewise.php	15.75 KB	-rwxr-xr-x
roomdeclaration.php	1.87 KB	-rwxr-xr-x
rotation.php	634 B	-rwxr-xr-x
rvdates.php	6.58 KB	-rwxr-xr-x
sample.php	2.13 KB	-rwxr-xr-x
sectionwisepermission.php	5.66 KB	-rwxr-xr-x
sendGridMail.php	1.25 KB	-rwxr-xr-x
sendLoginPassword.php	3.2 KB	-rwxr-xr-x
sendnotification.php	6.17 KB	-rwxr-xr-x
sendsmsapi.php	788 B	-rwxr-xr-x
sendusrandpws.php	1.01 KB	-rwxr-xr-x
serchbygrid.php	868 B	-rwxr-xr-x
servfeehead.php	3.97 KB	-rwxr-xr-x
services.php	3.58 KB	-rwxr-xr-x
sfeehead.php	5.62 KB	-rwxr-xr-x
stringspliter.php	731 B	-rwxr-xr-x
stuIAMarksPending.php	6.09 KB	-rwxr-xr-x
student.php	57.31 KB	-rwxr-xr-x
student_entry.php	61.92 KB	-rwxr-xr-x
studentportal_remove.php	6.3 KB	-rwxr-xr-x
subjectList_display.php	11.23 KB	-rwxr-xr-x
subject_freshExam.php	28.5 KB	-rwxr-xr-x
subjectfreez.php	13.52 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	10.21 KB	-rwxr-xr-x
subshort.php	5.83 KB	-rwxr-xr-x
system_utility.php	1.89 KB	-rwxr-xr-x
systemsetup.php	81.71 KB	-rwxr-xr-x
teachOficerEntry.php	7.21 KB	-rwxr-xr-x
teachers.php	15.78 KB	-rwxr-xr-x
transaction-series.php	4.99 KB	-rwxr-xr-x
update.php	720 B	-rwxr-xr-x
updateSection.php	4.87 KB	-rwxr-xr-x
update_defined_flag.php	3.5 KB	-rwxr-xr-x
update_query.php	334 B	-rwxr-xr-x
updateexamcnt.php	3.01 KB	-rwxr-xr-x
upload_studentPhoto.php	10.94 KB	-rwxr-xr-x
uploadmoduledetails.php	40.61 KB	-rwxr-xr-x
uploadzip.php	9.42 KB	-rwxr-xr-x
usersetup.php	25.66 KB	-rwxr-xr-x
usersubj_identification.php	5.71 KB	-rwxr-xr-x

Code Editor : candidate-entry.php

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

function ckeakexamdate($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	@session_start();

$degree = $aobj_context->mobj_data["degree"];

$collegeCode = $_SESSION['collcode'];

$query = "select * from collexam where fcollcode = '{$collegeCode}' 
					and fdegree = '{$degree}' and DATE_FORMAT(NOW(),'%Y-%m-%d') 
					BETWEEN DATE_FORMAT(FAPPFROM,'%Y-%m-%d') 
					AND DATE_FORMAT(FAPPTO,'%Y-%m-%d') ";

$result = $aobj_context->mobj_db->GetAll($query);
	if (strtoupper($_SESSION['usr']) == 'SUPER') {
		$arr = "";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 1, "success");
		return;
	} else if ($result ==  false) {
		$arr = "Last Date is Over";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "success");
		return;
	} else {
		$arr = "";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 1, "success");
		return;
	}
}

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'";
	$student_exam_details = $aobj_context->mobj_db->GetRow($qry); 
	if(empty($student_exam_details))
	{	
		$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,FCONSTYPE,
		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}' ";

$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' align='center' >";
	$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;'>";

$FCONSTYPE = $student_exam_details['FCONSTYPE'];
	//}
	//echo $qry;

// if ($li == $FCONSTYPE) {
	$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'];
	}
	// } else { }

$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=100% border='0' cellspacing='0' cellpadding='2'>";
			$id .= "<th align='left' colspan='10' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:11px; 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 Month<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,
			ifnull(c.fthpr,'') as fthpr,
			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'];
				$FTHPR = $lobj_rs[$m]['fthpr'];
				$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);
				if ($FTHPR == 'T')
					$th_cnt = 0;
				if ($FTHPR == 'F')
					$pr_cnt = 0;

$FSUBSHORT = $lobj_rs[$m]['FSUBSHORT'];
				$FSUBNAME = $lobj_rs[$m]['FSUBNAME'];
				if ($FTHPR == 'T')
					$fsubchekbox = "(PR)";
				else if ($FTHPR == 'F')
					$fsubchekbox = "(TH)";
				else
					$fsubchekbox = "";
				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 = "{$fsubchekbox} <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}' /> ";
						//var_dump($FPASSMTH);	
						$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;text-align:center;{$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'  >{$fsubchekbox} <input type='checkbox'  onclick='UpdateExamFeeForEachSelectedSubject();' id='exam_{$char_name}_ce_pass_{$txt_id}' > {$pr_th_cnt} </td>";
					$id .= "</tr>";
					$k++;
					$txt_id++;
				}
			}
			// var_dump($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
			;

//$cnt = "if('{$pr_cnt}' > 0,FMAXFEE,FFEE)";
			//if('{$FFRESHEXAM}'='{$char_name}',if('{$pr_cnt}' > 0,FMAXFEE,FFEE),FMAXFEE) as FMAXFEE,
			//if('{$pr_cnt}' > 0,FMAXFEE,FFEE) as FMAXFEE,
			$get_fee_data = "SELECT FHEADCODE, FFEE,
				IF('{$FFRESHEXAM}'='{$char_name}',FFEE,FREPFEE) AS O_FFEE,
				IF('{$FFRESHEXAM}'='{$char_name}',FPRFEE,FREPPRFEE) AS FPRFEE ,
				if('{$FFRESHEXAM}'='{$char_name}',if('{$pr_cnt}' > 0,FMAXFEE,FFEE),if('{$pr_cnt}' > 0,FMAXFEE,frepmaxfee)) as FMAXFEE,
				ifnull(FMODIFY,'') as FMODIFY
				FROM admfeestr a
				WHERE FDEGREE='{$degree}'
				AND FEXAMNO='{$char_name}'
				AND FCOMBCODE='EXAM' 
				AND FCATCODE='{$category}'
				and FCONSTYPE='{$li}'
				order by FHEADCODE";

session_start();
			$FUNIVCODE = $_SESSION['FUNIVCODE'];

//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; padding:5px;'>";
			$id .= "";
			$tr = "<table id='fee_table_{$char_name}' style='width:100%;'  class='tr_ventor_row;'   border='0' cellspacing='0' cellpadding='2'>";
			$tr .= "<th align='left' colspan='2' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:11px; padding-left:6px; height:20px;'>Fee Details</th>";
			$tr .= "<tr class='ui-state-default ui-jqgrid-hdiv' style='height:22px;font-weight:bold; font-size:12px; '>";
			$tr .= "<td align='center' style='border:0px solid #C5DBEC;border-top:1px solid #C5DBEC ;border-left:1px solid #C5DBEC;'> Fee Description</td>";
			$tr .= "<td align='center' style='border:0px solid #C5DBEC;border-top:1px solid #C5DBEC ;border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC;'>Amount</td>";
			$tr .= "</tr>";

$tot = 0;

foreach ($lobj_get_fee_data as $ak => $av) {

$disabled = "disabled = true";
				$FMODIFY = $av['FMODIFY'];
				//var_dump($FMODIFY);
				if ($FMODIFY == 'T')
					$disabled = "";
				$tr .= " <tr class='' style='height:22px;font-size:11px;'>";
				$h_code = substr($av['FHEADCODE'], 0, 2);
				$tr .= "<td align='left' style='width: 70%;border-top:1px solid #C5DBEC ;border-left:1px solid #C5DBEC;' id='tfh_{$char_name}_{$h_code}'>{$av['FHEADCODE']}</td>";

$input_val = 0;
				$exist_value = "";
				$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-top:1px solid #C5DBEC ;border-left:1px solid #C5DBEC;border-right: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; ' $disabled}type=text value='{$input_val}' id='nfee_{$char_name}_{$h_code}'></td>";
				$tr .= " </tr>";
			}
			$tr .= " <tr class='ui-state-default ui-jqgrid-hdiv' style='font-weight:bold;background:#27E87A; height:20px;font-size:12px;'>";
			$tr .= "<td align='center' style='border-left:1px solid #C5DBEC;border-top:1px solid #C5DBEC;border-bottom:1px solid #C5DBEC;'> Total </td>";
			$tr .= "<td align='center' style='border-left:1px solid #C5DBEC;border-top:1px solid #C5DBEC;border-right:1px solid #C5DBEC;border-bottom:1px solid #C5DBEC;'><input style='text-align:center;border:none;font-weight:bold;background:#27E87A;' id='nfee_{$char_name}_total' value={$tot} $disabled  /> <input type='hidden' id='fresh_exam_{$char_name}' value='{$FFRESHEXAM}' /></td>";

$tr .= "</tr></table>";

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

$id .= "<tr>";
			$id .= "<td colspan='4' style='border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC;border-bottom:1px solid #C5DBEC; padding:4px;font-size:12px;'>";
			$id .= "<span style='float:left;'>Receipt No:<input type='text' style='width:100px;' maxlength='15' id='exam_{$char_name}_receipt_no' value='{$exam_receipt_no_val}'></span>";
			$id .= "<span style='float:right;'>Receipt Date:<input style='width:100px;text-align:center;' id='exam_{$char_name}_date' value='{$exam_receipt_no_date_val}' type='text' value='00/00/0000' />";
			$id .= "<script> $('#exam_{$char_name}_date').datepicker({ changeMonth: true,	changeYear: true,dateFormat:'dd/mm/yy'});</script></span>";
			$id .= "</td>";
			$id .= "</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;
	$arr['degree'] = $degree;
	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"]);
	$full_file_path = "";
	$parentMobile = $aobj_context->mobj_data["parent_mobile"];
	$stu_email = $aobj_context->mobj_data["stu_email"];
	$candidate_mobile = $aobj_context->mobj_data["candidate_mobile"];

$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);

$update_student_details = "update student set fstumobile ='{$candidate_mobile}',fstuemail = '{$stu_email}',ffatmobile = '{$parentMobile}'
		where FREGNO = '{$reg_no}'";
	$lobj_update_student_details = $aobj_context->mobj_db->Execute($update_student_details);

$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);
			$x = 0;
			$y = 0;
			$psubcode = array();
			$nsubcode = array();
			$exam_data = get_object_vars($sub_arr_data[$char_id]);
			if (!empty($exam_data)) {

for ($k = 0; $k < count($exam_data); $k++) {
					$FRESENT = ($exam_data[$k]->smy == '1') ? "P" : "N";
					if ($FRESENT == 'P') {
						$psubcode[$x] = $exam_data[$k]->sub;
						$x++;
					}
					if ($FRESENT == 'N') {
						$nsubcode[$y] = $exam_data[$k]->sub;
						$y++;
					}
				}

$psubcode = implode("','", $psubcode);

$nsubcode = implode("','", $nsubcode);
				if ($psubcode != NULL) {
					$query = "update canddet set FPRESENT='P' 
						where 
						FDEGREE='{$degree}' and  FCOLLCODE='{$college_code}' 
						and FREGNO='{$reg_no}' and FSUBCODE in('{$psubcode}')";
					$lobj_update_canddet_records = $aobj_context->mobj_db->Execute($query);
				}

if ($nsubcode != NULL) {
					$query = "update canddet set FPRESENT='N' 
						where 
						FDEGREE='{$degree}' and  FCOLLCODE='{$college_code}' 
						and FREGNO='{$reg_no}' and FSUBCODE in('{$nsubcode}') and ifnull(fpassmth,'') = ''";
					$lobj_update_canddet_records = $aobj_context->mobj_db->Execute($query);
				}
				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);

//var_dump($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]->ex}'  and s.ftheory = 'F' and ifnull(s.fintass,'F') <> 'T'
					and s.fsubcode = '{$exam_data[$k]->sub}'";
					$lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($insert_canddet_records);

//var_dump($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 = "";
	$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)
{
	//session_start();
	$FUNIVCODE = $_SESSION['FUNIVCODE'];
	$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 FCATEGORY,FFEETYPE from candsum WHERE FREGNO='{$reg_no}'";

if ($FUNIVCODE == '30') {
		$get_fconst = "SELECT DISTINCT FCONSTYPE as internal_code,FCONSTYPE as value FROM admfeestr ORDER BY 1 DESC ";
	} else {
		$get_fconst = "SELECT DISTINCT FCONSTYPE as internal_code,FCONSTYPE as value FROM admfeestr where FDEGREE='{$degree}' and fcombcode = 'EXAM' 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'];
	$arr['FFEETYPE'] = $lobj_get_student_cat['FFEETYPE'];

if ($lobj_get_category_names != 0)
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success");
}

${this.title}

Code Editor : candidate-entry.php