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
DownloadExamAppFormApplication...	5.12 KB	-rwxr-xr-x
ECHblk.php	11.03 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MC_033_S1720418_A_2017_2.pdf	0 B	-rwxr-xr-x
MarkEntry-Setup.php	26.29 KB	-rwxr-xr-x
MarkEntry-Setup22.php	21.76 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
PrintApplicationFormPOSTOFFICE...	26.92 KB	-rwxr-xr-x
TAGMAY2013.pdf	331.03 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.71 KB	-rwxr-xr-x
UpdateCollDet.php	1.67 KB	-rwxr-xr-x
XLSXReader.php	9.31 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	7.28 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.03 KB	-rwxr-xr-x
ack_adm_application.php	55 KB	-rwxr-xr-x
ack_admentry_application.php	48.17 KB	-rwxr-xr-x
ack_application.php	7.71 KB	-rwxr-xr-x
ack_exam_app_form.php	16.56 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.58 KB	-rwxr-xr-x
ack_exam_app_form_oldformat.ph...	12.53 KB	-rwxr-xr-x
ack_registration.php	7.77 KB	-rwxr-xr-x
ack_report.php	2.27 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.55 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
adm_challan_entries.php	13.83 KB	-rwxr-xr-x
adm_delete_data.php	5.58 KB	-rwxr-xr-x
admapprove.php	9.37 KB	-rwxr-xr-x
admchallanpreparation.php	8.83 KB	-rwxr-xr-x
admission_entry_reg.php	39.89 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admission_sms_push.php	2.26 KB	-rwxr-xr-x
admissionapplist.php	9.15 KB	-rwxr-xr-x
admissionapplist_old_10092019....	0 B	-rwxr-xr-x
admregisterlist.php	14.43 KB	-rwxr-xr-x
admstuddate.php	6.1 KB	-rwxr-xr-x
admsumsendsms.php	6.12 KB	-rwxr-xr-x
admuploadexsheet.php	12.4 KB	-rwxr-xr-x
admuploadexsheet_07082019.php	8.79 KB	-rwxr-xr-x
ansbookcancel.php	9.49 KB	-rwxr-xr-x
answer_book_issued.php	10.34 KB	-rwxr-xr-x
applicationFormReportPOSTOFFIC...	25.94 KB	-rwxr-xr-x
apprCandidReport.php	6.95 KB	-rwxr-xr-x
approve.php	37.52 KB	-rwxr-xr-x
attendance.php	10.23 KB	-rwxr-xr-x
attendance_freez.php	8.45 KB	-rwxr-xr-x
attendance_freez_mth.php	8.24 KB	-rwxr-xr-x
attendance_freez_old.php	8.55 KB	-rwxr-xr-x
attshort.php	6.29 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.js	2.73 KB	-rwxr-xr-x
backup.php	2.87 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
basic_old.css	13.33 KB	-rwxr-xr-x
batch_close.php	4.31 KB	-rwxr-xr-x
board.php	2.71 KB	-rwxr-xr-x
boeselection.php	1.64 KB	-rwxr-xr-x
bundle_dispatch.php	3.09 KB	-rwxr-xr-x
bundle_rec_ack.php	4.06 KB	-rwxr-xr-x
bundledispatchdatewise.php	12.74 KB	-rwxr-xr-x
bundlereceive.php	1.08 KB	-rwxr-xr-x
bundlestatus.php	5.3 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate-entry.php	43.79 KB	-rwxr-xr-x
candidate-entry_new.php	42.85 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-entrynewformat.php	44.16 KB	-rwxr-xr-x
candidate-entryold.php	34.55 KB	-rwxr-xr-x
candidate_list.js	39.62 KB	-rwxr-xr-x
cappcontext.php	2.63 KB	-rwxr-xr-x
cconfig_wait.php	1.12 KB	-rwxr-xr-x
challan_entries.php	15.38 KB	-rwxr-xr-x
challan_preparation.php	11.69 KB	-rwxr-xr-x
changeDegree.php	1.56 KB	-rwxr-xr-x
changeMobile.php	2.43 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
cntDeclaration.php	4.12 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
coll_exam_app_form.php	981 B	-rwxr-xr-x
collbankdet.php	1.82 KB	-rwxr-xr-x
colldesp_ack.php	4 KB	-rwxr-xr-x
college.php	5.01 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxr-xr-x
college_approve.php	5.61 KB	-rwxr-xr-x
college_degree_status.php	5.65 KB	-rwxr-xr-x
collegebank.php	1.82 KB	-rwxr-xr-x
collfundtransfer.php	2.23 KB	-rwxr-xr-x
connect.php	2.24 KB	-rwxr-xr-x
coutput.php	1.76 KB	-rwxr-xr-x
createAdmission.php	3.94 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
cronjob_sendsms.php	2.94 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
database.php	472 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	7.9 KB	-rwxr-xr-x
degree.php	6.49 KB	-rwxr-xr-x
degreeGroup.php	2 B	-rwxr-xr-x
display_details_in_grid.php	105.4 KB	-rwxr-xr-x
display_details_in_grid22.php	104.95 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.61 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
display_details_in_gridold.php	102.19 KB	-rwxr-xr-x
doc_verify.php	7.31 KB	-rwxr-xr-x
doc_verify_12102019.php	6.99 KB	-rwxr-xr-x
downloadFeeStatement.php	5.32 KB	-rwxr-xr-x
download_misc_files.php	4.59 KB	-rwxr-xr-x
download_misc_files_old.php	4.3 KB	-rwxr-xr-x
download_photo.php	3.68 KB	-rwxr-xr-x
download_photo22.php	6.83 KB	-rwxr-xr-x
download_photo_new.php	4.82 KB	-rwxr-xr-x
download_photo_sikkim.php	5.07 KB	-rwxr-xr-x
download_photoold.php	3.58 KB	-rwxr-xr-x
download_upload.php	3.86 KB	-rwxr-xr-x
dynamicmastersdetails.php	117.45 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
examAppChallan.php	7.71 KB	-rwxr-xr-x
execute_query.php	2.5 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
forgotpassword.php	3.11 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.63 KB	-rwxr-xr-x
freeze_module_at_admin_college...	10.07 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.76 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.81 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
freezeiaprici.php	9.9 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getMessages.php	11.16 KB	-rwxr-xr-x
getdata.php	34.99 KB	-rwxr-xr-x
getdata22.php	32.91 KB	-rwxr-xr-x
getdataold.php	28.7 KB	-rwxr-xr-x
getfeeinformation.php	7.12 KB	-rwxr-xr-x
getfeeinformation_bulk.php	7.54 KB	-rwxr-xr-x
getmoduledetails.php	23.4 KB	-rwxr-xr-x
getnumword.php	7.43 KB	-rwxr-xr-x
getreportdetails.php	3.21 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.37 KB	-rwxr-xr-x
getsearchcondition.php	1.3 KB	-rwxr-xr-x
ggridmodel.php	9.27 KB	-rwxr-xr-x
golden_palm_payslip.php	12.48 KB	-rwxr-xr-x
helptext.php	5.38 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
index.php	5.06 KB	-rwxr-xr-x
json.php	33.72 KB	-rwxr-xr-x
krvw.html	1.5 KB	-rwxr-xr-x
login.php	18.39 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
login_wait.php	11.48 KB	-rwxr-xr-x
mascomb.php	10.02 KB	-rwxr-xr-x
mcverifydet.php	14.26 KB	-rwxr-xr-x
message_board.php	4.7 KB	-rwxr-xr-x
messagetext.php	980 B	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	89.11 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
nobleRegn.php	3.96 KB	-rwxr-xr-x
payment_gateway.php	7.78 KB	-rwxr-xr-x
pclzip.lib.php	192.53 KB	-rwxr-xr-x
photoupload.php	9.28 KB	-rwxr-xr-x
post.php	5.05 KB	-rwxr-xr-x
printexamform.php	11.54 KB	-rwxr-xr-x
push_data_to_studentportal.php	1.8 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.57 KB	-rwxr-xr-x
remove_exam_ack.php	3.53 KB	-rwxr-xr-x
report_admission_ticket.php	46.77 KB	-rwxr-xr-x
report_hall_ticket.php	11.18 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	11.84 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
result.php	5.06 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.91 KB	-rwxr-xr-x
room_allotment_datewise.php	15.59 KB	-rwxr-xr-x
room_allotment_datewise_new.ph...	15.3 KB	-rwxr-xr-x
room_allotment_old.php	16.44 KB	-rwxr-xr-x
room_allotmentnew.php	9.24 KB	-rwxr-xr-x
room_allotmentold.php	15.27 KB	-rwxr-xr-x
roomdeclaration.php	1.81 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
sample.php	2.04 KB	-rwxr-xr-x
sectionwisepermission.php	5.53 KB	-rwxr-xr-x
sendGridMail.php	1.2 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
sendsmsapi.php	760 B	-rwxr-xr-x
sendusrandpws.php	1002 B	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
servfeehead.php	3.84 KB	-rwxr-xr-x
services.php	3.47 KB	-rwxr-xr-x
sfeehead.php	5.45 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
stuIAMarksPending.php	5.92 KB	-rwxr-xr-x
student.php	55.86 KB	-rwxr-xr-x
student_14062018.php	43.9 KB	-rwxr-xr-x
student_entry.php	60.55 KB	-rwxr-xr-x
student_entry24.php	56.54 KB	-rwxr-xr-x
student_entry_14062018.php	48.28 KB	-rwxr-xr-x
student_entry_24112017.php	42.7 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
studentportal_remove.php	6.18 KB	-rwxr-xr-x
subjectList_display.php	11.05 KB	-rwxr-xr-x
subject_freshExam.php	19.73 KB	-rwxr-xr-x
subjectfreez.php	13.2 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	9.95 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	80.06 KB	-rwxr-xr-x
teachers.php	15.1 KB	-rwxr-xr-x
teachersOLD.php	10.33 KB	-rwxr-xr-x
teachersnew.php	16.95 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
update.php	720 B	-rwxr-xr-x
updateSection.php	4.79 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
update_query.php	334 B	-rwxr-xr-x
updateexamcnt.php	2.92 KB	-rwxr-xr-x
upload_studentPhoto.php	8.63 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
uploadzip.php	9.18 KB	-rwxr-xr-x
usersetup.php	25.11 KB	-rwxr-xr-x
usersetupold.php	24.36 KB	-rwxr-xr-x
usersubj_identification.php	5.58 KB	-rwxr-xr-x

Code Editor : ack_adm_application.php

<?php
class challan_entries
{
    
	function __construct($aobj_context)
	{
		session_start();
		$this->aobj_context=$aobj_context;
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		$this->user_id=$_SESSION['user_id']	;		  
		$this->collcode=$_SESSION['collcode'];	
		$this->college_code=$_SESSION['collcode'];	
		$this->log_name = $_SESSION['usr'];			
	}
		
	
	function DisplayAdmApplication()
	{
	 	$adm_degree = trim($this->aobj_context->mobj_data["degree"]);
	 	$appfrom = trim($this->aobj_context->mobj_data["app_from"]);
	 	$appto = trim($this->aobj_context->mobj_data["app_to"]);
	 	$status = trim($this->aobj_context->mobj_data["status"]);
	 	$cnd = '';
	 	
	 	if($status == 'verified')
	 		$cnd = "and ifnull(FAPPSTATUS,'Pending') = 'verified'";
	 	else if($status == 'pending')
	 		$cnd = "and ifnull(FAPPSTATUS,'Pending') <> 'verified'";
	 	else
	 		$cnd = '';

$query = "select fname, fappno, fdegree, fcombcode, fcaste, DATE_FORMAT(fadmdate, '%d/%m/%Y') as fadmdate, ifnull(FAPPSTATUS,'Pending') as appstatus,
		ifnull(FAPPRSTATUS,'Pending') as apprstatus,
		ifnull(FTOTFEE,0) as FTOTFEE
		from studadm where fcollcode = '{$this->collcode}' and ifnull(fdeleted,'') <> 'T'
		and fdegree = '{$adm_degree}' and fappno between '{$appfrom}' 
		and '{$appto}' and ifnull(ffinsub,'F') = 'T' {$cnd}";
		//var_dump($query);
		$lobj_get_data = $this->aobj_context->mobj_db->GetAll($query);
 
		$str_reval.="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>";
		$str_reval.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
		$str_reval.="<td align='center' style='padding:4px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl No</td>";
		$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>App. No.</td>";
		$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Adm. Date</td>";
		$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Student Name</td>";
		$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Degree</td>";
		$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Combination</td>";
		$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Category</td>";
		
		$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Amount</td>";
		$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Status</td>";
		$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Action</td>";
		$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Print</td>";
		$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Remove</td>";
		/*$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>  &nbsp;  &nbsp;  &nbsp;  &nbsp;</td>"; */
		$str_reval.="</tr>";
 
		$k=0;
		$sl_no=1;
		if($lobj_get_data)
		{
			foreach($lobj_get_data as $ak=>$av)
			{
				if($av['appstatus'] == 'verified')
				{

$edit="<center><span  class='raval_submit' style='margin-top: 2px;  width: 45px;float:left;margin-left:0px;color:#545345; line-height: 19px;font-size:13px;font-weight:bold;''><b>verified</b></span></center>";

$remove ="<center><span class='raval_submit' style='margin-top: 2px;  width: 60px;float:left;margin-left:0px;cursor: pointer;color:#545345; line-height: 19px;font-size:13px;font-weight:bold;'' onclick='RemoveApplication(\"{$av['fappno']}\", \"{$av['fdegree']}\")'><b>Remove</b></span></center>";

if($av['apprstatus'] == 'APPROVED')
					{
						$remove ="<center><span class='raval_submit' style='margin-top: 2px;  width: 60px;float:left;margin-left:0px;color:#545345; line-height: 19px;font-size:13px;font-weight:bold;''><b>{$av['apprstatus']}</b></span></center>";
					}else
					{
						$remove ="<center><span class='raval_submit' style='margin-top: 2px;  width: 60px;float:left;margin-left:0px;cursor: pointer;color:#545345; line-height: 19px;font-size:13px;font-weight:bold;'' onclick='RemoveApplication(\"{$av['fappno']}\", \"{$av['fdegree']}\")'><b>Remove</b></span></center>";
					}

}else
				{	
					$edit="<center><span  class='raval_submit' style='margin-top: 2px;  width: 45px;float:left;margin-left:0px;cursor: pointer;color:#545345; line-height: 19px;font-size:13px;font-weight:bold;'' onclick='EditStudentDetails(\"{$av['fappno']}\", \"{$av['fdegree']}\", \"ACK\")'><b>Edit</b></span></center>";
					
					$remove ="<center><span class='raval_submit' style='margin-top: 2px;  width: 60px;float:left;margin-left:0px;cursor: ;color:#545345; line-height: 19px;font-size:13px;font-weight:bold;'><b>Remove</b></span></center>";
						
				}	
				//Verified

$print ="<center><span class='raval_submit' style='margin-top: 2px;  width: 45px;float:left;margin-left:0px;cursor: pointer;color:#545345; line-height: 19px;font-size:13px;font-weight:bold;'' onclick='printapplication(\"{$av['fappno']}\", \"{$av['fdegree']}\")'><b>Print</b></span></center>";

/*$edit="<img  onclick='EditStudentDetails(\"{$av['fappno']}\", \"{$av['fdegree']}\")'  src='img/edit.png' title='Edit' style='width: 80px;height:25px' /> ";*/
				//var_dump($remove);
				$challprint = "";
				if($k%2==0)
					$class='tbl_row1';
				else
					$class='tbl_row_alter1';

$str_reval.="<tr>";		
				$str_reval.="<td class='{$class} tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >{$sl_no}</td>";
				$str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;  ;text-align:center;  ' >{$av['fappno']}&nbsp;</td>";
				$str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ;  ;text-align:center; ' >{$av['fadmdate']}</td>";
				$str_reval.="<td class='{$class} tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:11px;text-align:left; ' > {$av['fname']}</td>";
				$str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;  ;text-align:center;  ' > {$av['fdegree']}</td>";
				$str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ;  ;text-align:center; ' >{$av['fcombcode']}</td>";
				$str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ;  ;text-align:center; ' >{$av['fcaste']}</td>";
				$str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ;  ;text-align:center; ' >{$av['FTOTFEE']}</td>";
				$str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ;  ;text-align:center; ' >{$av['appstatus']}</td>";
		
				$str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  padding:2px;text-align:center;  ' >{$edit}</td>";
				$str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  padding:2px;text-align:center; cursor:pointer; ' >{$print}</td>";
				$str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  padding:2px;text-align:center; ' >{$remove}</td>";

$str_reval.="</tr>";
				
				$sl_no++;
				$k++;
			}
		}else
		{
			$str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-left:1px solid #C5DBEC;padding:2px;text-align:center; cursor:pointer; ' colspan = '10'><b>No deatils found for the given deatils.</b></td>";
				$str_reval.="</tr>";
		}				
		
		$str_reval.="</table>";
		$arr['html']=$str_reval;
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 	
		 
	}

}
	
function DisplayAdmApplication($aobj_context)
{
    $class_obj=new challan_entries($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$class_obj->DisplayAdmApplication();
}

function getappnostudentdetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 	
	session_start();   //and FDELETED = 'F'
	$app_no = $aobj_context->mobj_data["app_no"];

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

$get_student_details_slno = "SELECT 
	fappno AS student_entry_admno,
	fexamno as student_entry_exam,
	fdegree as student_entry_degree_code,
	DATE_FORMAT(fadmdate,'%d/%m/%Y') AS student_entry_admdate,
	fdegree AS student_entry_degree_code,
	fcombcode  AS combination,
	fname AS student_entry_name,
	FFATNAME AS student_entry_fname,
	FMOTNAME AS student_entry_mname,
	DATE_FORMAT(fdob,'%d/%m/%Y') AS student_entry_dob,
	FPHOTOPATH AS student_entry_photo,
	FSIGNPATH AS student_signature_photo,
	FRELIGION AS student_entry_religion,
	FGENDER AS student_entry_gender,
	FBLOOD_GROUP AS student_entry_blood_grp,
	FNATIONAL AS student_entry_national,
	FCASTE AS degree_category,
	FCATBIRTH AS student_entry_caste,
	FAADHARNO AS seAadharNumber,
	FAREA AS farea,
	FEMAIL AS student_entry_email,
	FCONTACT_NO AS student_entry_mobile,
	FMOBILE_NO AS student_entry_phone,
	FINCOME AS student_entry_fincome,
	fincomecert AS fincomecert,
	fcastecert AS fcastecert,
	ifnull(FPERMADD1,'') AS student_entry_per_add1,
	IFNULL(FPERMADD2,'') AS student_entry_per_add2,
	IFNULL(FPERMADD3,'') AS student_entry_per_add3,
	IFNULL(FPERDIST,'') AS student_entry_per_dist,
	IFNULL(FPERSATE,'') AS  student_entry_per_state,
	IFNULL(FPERPINCODE,'') AS  student_entry_per_pin,
	IFNULL(FCURRADD1,'') AS student_entry_comm_addr1,
	IFNULL(FCURRADD2,'') AS student_entry_comm_addr2,
	IFNULL(FCURRADD3,'') AS student_entry_comm_addr3,
	IFNULL(FCOMDIST,'') AS student_entry_comm_dist,
	IFNULL(FCOMPINCODE,'') AS student_entry_comm_pin,
	IFNULL(FCOMSTATE,'') AS student_entry_comm_state,
	FTYPEQUALEXAM AS seTypeOfQualifyingExam,
	FQUALEXREGNO AS seExamRegNo,
	FUNIVNAME AS seUniversityName,
	FQMONTH AS fmonth,
	FQYEAR AS fyear,
	flateral_entry as LT,
	FQMAXMARKS AS maxmarks,
	FQSECMARKS AS secmarks,
	FQPERCENTAGE AS percentage,
	ifnull(FCONSTYPE,'') as constype,
	FQUOTA as fadmquota,
	FMEDIUM as fmedium,
	FSTUTYPE as fstudtype
	from studadm  
	where fappno='{$app_no}' and FDEGREE='{$degree}' 
	and ifnull(fdeleted,'') <> 'T'
	and FCOLLCODE='{$_SESSION['collcode']}'";	 
 	// var_dump($get_student_details_slno);
	$lobj_get_student_details = $aobj_context->mobj_db->getRow($get_student_details_slno);

$arr['perdetl'] = $lobj_get_student_details;

$combination =  $lobj_get_student_details['combination'];
	$fstudtype =  $lobj_get_student_details['fstudtype'];
	$student_entry_exam =  $lobj_get_student_details['student_entry_exam'];

$query3 = "SELECT FCATEGORY AS int_code,FDESCPN AS val FROM category 
	where ifnull(FDELETED,'') <> 'T' order by FCATEGORY asc ";
	$rst3 = $aobj_context->mobj_db->GetAll($query3);
	$arr['category'] = $rst3;

$deg = substr_replace($degree ,"", -1);
	$degree1 = $deg.'1';
	$degree2 = $deg.'2';

$query3 = "SELECT distinct fdegree AS int_code,concat(fdegree,' - ',FDESCPN) AS val FROM degree 
	where ifnull(fadmdeg,'') = 'T' and  fdegree in('{$degree1}','{$degree2}') 
	and ifnull(FDELETED,'') <> 'T' order by fdegree";
	$rst3 = $aobj_context->mobj_db->GetAll($query3);
	$arr['degree'] = $rst3;

$query3 = "SELECT distinct fcombcode AS int_code,fcombdesc AS val FROM mascomb 
	WHERE fdegree = '{$degree}' AND IFNULL(FDELETED,'') <> 'T' ORDER BY fcombcode ";
	$rst3   = $aobj_context->mobj_db->GetAll($query3);
	$arr['mascomb'] = $rst3;

$query4 = "select fboardcode as int_code, fboardname as val from masboard order by forder";
	$rst4   = $aobj_context->mobj_db->GetAll($query4);
	$arr['boards'] = $rst4;

$query = "SELECT DISTINCT m.internal_code AS int_code, 
	FCERTDESC AS doc_type ,
	IFNULL(FFILENAME,REPLACE(REPLACE(FCERTDESC,' ','_'),'+','_')) AS FFILENAME,
	ifnull(s.file_path,'') as file_path
	FROM masdoc m
	inner  JOIN studoc s 
	ON s.fdegree = m.fdegree AND login_cnt = '{$app_no}' AND s.fdoctype = m.FFILENAME 
	AND fcollcode = '{$_SESSION['collcode']}' where m.fdegree = '{$degree}' 
	and ifnull(s.fdeleted,'') <> 'T'
	ORDER BY forder";

$results = $aobj_context->mobj_db->GetAll($query);
	$arr['masdoc'] = $results;

$get_sub_total  = "select FTOTSUB,fdeggrp from degree where FDEGREE= '{$degree}' and FEXAMNO= '{$student_entry_exam}'";
	$lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total);
		
	$total_sub      = $lobj_sub_total['FTOTSUB'];
	$fdeggrp      = $lobj_sub_total['fdeggrp'];

$get_exsting_data = "select a.*,b.FSUBNAME,b.FSUBSHORT,FMANDATORY from 
	(select FDEGREE,FEXAMNO,FCOLLCODE,FSLNO,FSUBCODE from options
	where fappno = '{$app_no}' and FCOLLCODE='{$_SESSION['collcode']}' 
	and FDEGREE='{$degree}') a
	left join 
	(select s.FDEGREE,
	FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on 
	s.FDEGREE=d.FDEGREE  and  d.FEXAMNO=s.FEXAMNO
	where d.FDEGREE='{$degree}') b 
	on a.FSUBCODE=b.FSUBCODE
	and a.FDEGREE=b.FDEGREE
	group by FSUBCODE limit {$total_sub}";
	 
	$lobj_get_exsting_data = $aobj_context->mobj_db->getAll($get_exsting_data);

$get_true_sub_names="select FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on 
	s.FDEGREE=d.FDEGREE  and  d.FEXAMNO=s.FEXAMNO
	where d.FDEGREE='{$degree}' and s.FEXAMNO='{$exam}' and FMANDATORY='T' group by  s.FSUBCODE
	union
	select s.FSUBCODE,s.FSUBNAME,s.FSUBSHORT ,'T' as FMANDATORY from degree d inner join subject s on 
	s.FDEGREE=d.FDEGREE  and  d.FEXAMNO=s.FEXAMNO
	left join mascomb m on m.FDEGREE=d.FDEGREE and m.fcombcode = '{$combination}'
	where d.FDEGREE='{$degree}'  and m.FSUBCODE = s.FSUBCODE  
	group by  s.FSUBCODE";	
	$lobj_get_true_sub_names = $aobj_context->mobj_db->getAll($get_true_sub_names);	
	 
	$e_data.="<table  width='94%' class='tr_ventor_row' cellspacing='0' cellpadding='0' border='0' >";
	$e_data.="<tr style='font-size:12px;' class='ui-state-default ui-jqgrid-hdiv'>";		
	$e_data.="<td  style='padding:2px; width:60px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sub Code</td>";
	$e_data.="<td  style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Short Name</td>";
	$e_data.="<td  style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>";
	$e_data.="</tr>";
	
	$k=0;
	$id=0;
	 
	if(empty($lobj_get_exsting_data))
	{
		$remaining_count=$total_sub-count($lobj_get_true_sub_names);
			
		foreach($lobj_get_true_sub_names as $key=>$value)
		{
		  
			$e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow'>";
			$e_data.="<td class='tbl_row_new subcode' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;'><input  tabindex=-1  {$inp_class} type=text style='width:60px;border:none;' readonly id='se_sub_code_{$id}' value='{$value['FSUBCODE']}' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'></td>";
			$e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:60px;' {$inp_class}  tabindex=-1  readonly id='se_short_name_{$id}' value='{$value['FSUBSHORT']}'></td>";
			$e_data.="<td  class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:290px;' {$inp_class} id='se_sub_name_{$id}'  tabindex=-1   readonly value='{$value['FSUBNAME']}'> </td>";
			$e_data.="</tr>";
			 $k++;
			 $id++;
		}

$name=''; 
		$pmode = 1;			
		if($pmode == 0)
		{
			$last_slno_execution ="  select s.FSUBCODE, s.FSUBSHORT, s.FSUBNAME 
			from subject s inner join options d on 									
			s.FDEGREE=d.FDEGREE  and  s.FEXAMNO=d.FEXAMNO and 
			d.fsubcode = s.fsubcode and d.FCOLLCODE='{$_SESSION['collcode']}' and
			s.fssubname != 'I.A.' and s.FMANDATORY = 'F' and
			s.FDEGREE='{$degree}' and 
			d.fslno = 
			( select MAX(s.fslno) from studadm s 
			where s.FDEGREE='{$degree}'
			AND FCOLLCODE='{$_SESSION['collcode']}' ) group by    s.FSUBCODE
			";
			$lobj_last_slno_execution = $aobj_context->mobj_db->getAll($last_slno_execution);	
		}	
			 
		
			for($j=0;$j<$remaining_count;$j++)
			{				 
				if($k%2==0)
				{
				$class='tbl_row';
				$inp_class='tbl_row_input';
				}
				else
				{
				$input_class='tbl_row1'; 
				$inp_class='tbl_row1_input';
				}  
				if($j==0)
				$name="name='focus'";
				else
				$name='';
				 
				 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >";
				 $e_data.="<td class='tbl_row_new subcode' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name}  onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>";
				 $e_data.="<td class='tbl_row_new' align='center'  style='border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'  tabindex=-1  readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}'  ></td>";
				 $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1  readonly  style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}'  ></td>";
				 $e_data.="</tr>";
				 $k++;
				 $id++;
			}  
		}
		else
		{
		$flag=0;
		$remaining_count=$total_sub-count($lobj_get_exsting_data);
			for($h=0;$h<count($lobj_get_exsting_data);$h++)
			{
				$read_only=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?"readOnly":''; 
				$read_only = "readOnly";
				$border=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?" border:none;":''; 
				$on_blur =($lobj_get_exsting_data[$h]['FMANDATORY']=='F')?" onblur='getSubDetails( this.id,{$id});' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' ":'';
				$focus_id =($lobj_get_exsting_data[$h]['FMANDATORY']=='F')?" onfocus=\$g_focus_element='se_sub_code_{$id}' ":'';
				   
				if($k%2==0)
				{
				$class='tbl_row';
				$inp_class='tbl_row_input';
				}
				else
				{
				$input_class='tbl_row1'; 
				$inp_class='tbl_row1_input';
				}
				if(($lobj_get_exsting_data[$h]['FMANDATORY']=='F') && $flag==0)
				{
				$name="name='focus'";
				$flag=1;
				}else
				$name='';
			 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >";
			 $e_data.="<td class='tbl_row_new subcode' align='center'style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; padding:1px;'><input type='text' {$input_class} 
			 	onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' 
			 	onblur='getSubDetails( this.id,{$id});'
			 	 {$name}  align='center' {$focus_id} value='{$lobj_get_exsting_data[$h]['FSUBCODE']}' style = 'width:60px;{$border}' id='se_sub_code_{$id}'>  </td>";
			 $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'   {$read_only} style = 'width:60px;border:none;'  {$inp_class} value='{$lobj_get_exsting_data[$h]['FSUBSHORT']}' id='se_short_name_{$id}'></td>";
			 $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text'   {$read_only} style = 'width:290px;border:none;' {$inp_class}  value='{$lobj_get_exsting_data[$h]['FSUBNAME']}' id='se_sub_name_{$id}'></td>";
			 $e_data.="</tr>";
			 $k++;
			 $id++;
			}
			$k=0;
			for($j=0;$j<$remaining_count;$j++)
			{				 
				if($k%2==0)
				{
				$class='tbl_row';
				$inp_class='tbl_row_input';
				}
				else
				{
				$input_class='tbl_row1'; 
				$inp_class='tbl_row1_input';
				}  
				if($j==0)
				$name="name='focus'";
				else
				$name='';
				 
				 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >";
				 $e_data.="<td class='tbl_row_new subcode' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name}  onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>";
				 $e_data.="<td class='tbl_row_new' align='center'  style='border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'  tabindex=-1  readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}'  ></td>";
				 $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1  readonly  style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}'  ></td>";
				 $e_data.="</tr>";
				 $k++;
				 $id++;
			}
		}		
		$e_data.="</table>";
		$arr['html']=$e_data;
		$arr['deggrp']=$fdeggrp;
		$arr['table_data']=$lobj_get_true_sub_names;
		$arr['remaining_count']=$remaining_count;
		$arr['total_count']=$id;

$query = "select * from admfeedetl where fcollcode = '{$_SESSION['collcode']}' 
	and fappno = '{$app_no}'";
	$results = $aobj_context->mobj_db->GetAll($query);

if($results)
	{	
		$get_details="SELECT distinct ma.FHEADCODE,IFNULL(ta.FAMOUNT ,ma.FFEE) as FFEE,
		ifnull(ma.FMODIFY,'F') as FMODIFY,
		ifnull(ta.FAMOUNT ,ma.FFEE) as fee_paid,
		FCOMBCODE,FCATCODE
		FROM admfeestr ma
		left join admfeedetl ta
	 	on ma.fdegree = ta.fdegree and ma.fexamno = ta.fexamno and ma.fheadcode = ta.fheadcode
	 	WHERE ma.FDEGREE='{$degree}'
		AND ma.FEXAMNO='A'
		AND ma.FCOMBCODE='ADM' 
		and ma.FCONSTYPE = '{$fstudtype}' 
		and ta.fcollcode = '{$_SESSION['collcode']}' 
		and ta.fappno = '{$app_no}'
		and 
		AND ma.FCATCODE='GM' order by ma.fheadcode ";
		//var_dump($get_details);
		$lobj_rs = $aobj_context->mobj_db->GetAll($get_details);
	}
	else
	{
		$get_details="SELECT ma.FHEADCODE,ma.FFEE,
		ifnull(ma.FMODIFY,'F') as FMODIFY,
		ifnull(ma.FFEE,'') as fee_paid,
		FCOMBCODE,FCATCODE
		FROM admfeestr ma
	 	WHERE ma.FDEGREE='{$degree}' and FCATCODE = 'GM'
		AND ma.FEXAMNO='A'
		AND ma.FCOMBCODE='ADM' 
		and ma.fconstype = '{$fstudtype}'
		order by ma.fheadcode";
		$lobj_rs = $aobj_context->mobj_db->GetAll($get_details);
	}

$str_reval="";
	$str_reval.="<table width='60%' style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>";
	$str_reval.="<th align='left' colspan='4' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Fee Details</th>";
	$str_reval.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
	$str_reval.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl.No</td>";
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Description</td>";
	/*$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Fee</td>";*/
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Fee Paid</td>";
 
	$str_reval.="</tr>";
	$sl_no=1;
	$total=0;
	$total_fee_paid=0;
	foreach($lobj_rs  as $ak=>$av)
	{
		$FHEADCODE=$av['FHEADCODE'];
		$FFEE=$av['FFEE'];
		$fee_paid=$av['fee_paid'];
		$FMODIFY = $av['FMODIFY']; 
		$cnd = "disabled = true";

if($FMODIFY == 'T')
		{
			$cnd = "";
		}

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

$query = "select * from qualsubdet where fappno = '{$app_no}' and fdegree = '{$degree}' 
		and fcollcode ='{$_SESSION['collcode']}'";
		$results = $aobj_context->mobj_db->getAll($query); 
	
		$arr['qualdet'] = $results;
		$arr['qualcount'] = count($results);

if(!empty($lobj_get_student_details))
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;
	}
	else
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-2,"Failure"); 
		return;
	}
}

function DisplayUserSelectedfile($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$date = date("dmYhis");
	$file_name   = $aobj_context->mobj_data["file_name"];
	$folder_path = $aobj_context->main_src."/upload/";
	
	$path_arr = pathinfo($_FILES[$file_name]['name']);
	$file_ext=$path_arr['extension'];
 
	
	$temp_path=$aobj_context->main_src."/upload";
	if(!file_exists($temp_path))
	{
		mkdir($temp_path);
	}

$file_path="/{$date}_".$path_arr['basename'];
	
	$temp_path.=$file_path;

if(isset($_FILES[$file_name]['name']) && $_FILES[$file_name]['name'] != '')         
	{ 
		$size=($_FILES[$file_name]['size']/1024);
		if($size>1024)
		{
			$data="Please Upload the Photo of size less than 1 MB";
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,-2,"success"); 
			return;
		}

if(move_uploaded_file($_FILES[$file_name]['tmp_name'],$temp_path))
		{
			$data['path'] ="upload/{$file_path}";
			$data['file_name'] =$file_name;
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
			return;
		}
	}
	echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	return;	
}

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

function savestudentapplication($aobj_context)
{

$lstr_param = stripslashes($aobj_context->mobj_data["personal_info"]);
	$per_arr_data = json_decode($lstr_param, true);	
	$fappno = stripslashes($aobj_context->mobj_data["fappno"]);
	$student_photo = stripslashes($aobj_context->mobj_data["student_photo"]);
	$student_sign = stripslashes($aobj_context->mobj_data["student_sign"]);
	$gender = stripslashes($aobj_context->mobj_data["gender"]);

$rgMultiMarks = stripslashes($aobj_context->mobj_data["rgMultiMarks"]);
	////recieve decode json string of subject info

$strSubject = stripslashes($aobj_context->mobj_data["pRgSubjects"]);
	$sub_arr_data = json_decode($strSubject, true);

$rgPerArray = array();
	for($i=0; $i<count($per_arr_data); $i++)
	{
		$rgPerArray[$per_arr_data[$i]['id']] = $per_arr_data[$i]['value'];
	}

$sub_data = array();
	for($i=0; $i<count($sub_arr_data); $i++)
	{
		$sub_data[$sub_arr_data[$i]['id']] = $sub_arr_data[$i]['value'];
	}
	
	$exam = 'A';
	if($rgPerArray['LT'] == 'T')
		$exam = 'C';
	$total = $rgPerArray['fee_paying_2']+$rgPerArray['fee_paying_1']+$rgPerArray['fee_paying_3']+$rgPerArray['fee_paying_4']+$rgPerArray['fee_paying_5']+$rgPerArray['fee_paying_6']+$rgPerArray['fee_paying_7'];
	$query = "update studadm set 
		FNAME = '{$rgPerArray['student_entry_name']}',
		fdegree = '{$rgPerArray['student_entry_degree_code']}',
		FDOB = DATE_FORMAT(STR_TO_DATE('{$rgPerArray['student_entry_dob']}','%d/%m/%Y'),'%Y-%m-%d'),	
		fadmdate = DATE_FORMAT(STR_TO_DATE('{$rgPerArray['student_entry_admdate']}','%d/%m/%Y'),'%Y-%m-%d'),
		FFATNAME = '{$rgPerArray['student_entry_fname']}',
		fgender = '{$gender}',
		FMOTNAME = '{$rgPerArray['student_entry_mname']}',
		FEMAIL = '{$rgPerArray['student_entry_email']}',
		FCASTE = '{$rgPerArray['degree_category']}',
		FCONTACT_NO = '{$rgPerArray['student_entry_mobile']}',
		FNATIONAL = '{$rgPerArray['student_entry_nationality']}',
		FCURRADD1 = '{$rgPerArray['student_entry_comm_addr1']}',
		FCURRADD2 = '{$rgPerArray['student_entry_comm_addr2']}',
		FCURRADD3 = '{$rgPerArray['student_entry_comm_addr3']}',
		FCOMDIST = '{$rgPerArray['student_entry_comm_dist']}',
		FCOMSTATE = '{$rgPerArray['student_entry_comm_state']}',
		FCOMPINCODE = '{$rgPerArray['student_entry_comm_pin']}',
		FPERMADD1 = '{$rgPerArray['student_entry_per_add1']}',
		FPERMADD2 = '{$rgPerArray['student_entry_per_add2']}',
		FPERMADD3 = '{$rgPerArray['student_entry_per_add3']}',
		FPERDIST = '{$rgPerArray['student_entry_per_dist']}',
		FPERSATE = '{$rgPerArray['student_entry_per_state']}',
		FPERPINCODE = '{$rgPerArray['student_entry_per_pin']}',
		FRELIGION = '{$rgPerArray['student_entry_religion']}',
		FMOBILE_NO = '{$rgPerArray['student_entry_phone']}',
		FCATBIRTH = '{$rgPerArray['student_entry_caste']}',
		FINCOME = '{$rgPerArray['student_entry_fincome']}',
		FAADHARNO = '{$rgPerArray['seAadharNumber']}',
		FUNIVNAME = '{$rgPerArray['seUniversityName']}',
		FQUALEXREGNO = '{$rgPerArray['seExamRegNo']}',
		FAREA = '{$rgPerArray['farea']}',
		FQMONTH = '{$rgPerArray['fmonth']}',
		FQYEAR = '{$rgPerArray['fyear']}',
		FQMAXMARKS = '{$rgPerArray['maxmarks']}',
		FQSECMARKS = '{$rgPerArray['secmarks']}',
		FQPERCENTAGE = '{$rgPerArray['percentage']}',
		FBLOOD_GROUP = '{$rgPerArray['student_entry_blood_grp']}',
		FTYPEQUALEXAM = '{$rgPerArray['seTypeOfQualifyingExam']}',
		fcombcode = '{$rgPerArray['combination']}',
		FADMFINE = '{$rgPerArray['fee_paying_2']}',
		FUNIVFEE = '{$rgPerArray['fee_paying_1']}',
		FTOTFEE = '{$total}',
		FCONSTYPE = '{$rgPerArray['constype']}', 
		FSTUTYPE = '{$rgPerArray['fstudtype']}', 
		FMEDIUM = '{$rgPerArray['fmedium']}',
		FQUOTA = '{$rgPerArray['fadmquota']}',
		flateral_entry = '{$rgPerArray['LT']}',
		FAPPSTATUS = 'verified',
		ffinsub = 'T',
		fexamno = '{$exam}',
		fcastecert = '{$rgPerArray['fcastecert']}',
		fincomecert = '{$rgPerArray['fincomecert']}',
		FACKDATE = now(),
		FACKUSER = '{$_SESSION['user_type']}'
		where fappno = '{$rgPerArray['student_entry_admno']}'";

$results = $aobj_context->mobj_db->Execute($query);

//var_dump($query);

$query = "select fslno from studadm where fappno = '{$rgPerArray['student_entry_admno']}'";
		$res =  $aobj_context->mobj_db->GetRow($query);

$sl_no = $res['fslno'];
		if(count($sub_arr_data) >0)
		{	
			$query = "delete from options where fappno = '{$rgPerArray['student_entry_admno']}'";
			$deloptresults = $aobj_context->mobj_db->Execute($query);
			//var_dump($query);
		}
		
		$query = "delete from admfeedetl where fappno = '{$rgPerArray['student_entry_admno']}'";
		$deladmresults = $aobj_context->mobj_db->Execute($query);

$query = "insert  into admfeedetl (`FYEAR`,`FDEGREE`,`FEXAMNO`,`FCOLLCODE`,`FSLNO`,`FHEADCODE`,`FAMOUNT`,FAPPNO) values 
		('2019','{$rgPerArray["student_entry_degree_code"]}','{$exam}','{$_SESSION['FCOLLCODE']}',
		'{$sl_no}','01 REGISTRATION FEE','{$rgPerArray['fee_paying_1']}','{$rgPerArray['student_entry_admno']}'),
		('2019','{$rgPerArray["student_entry_degree_code"]}','{$exam}','{$_SESSION['FCOLLCODE']}',
		'{$sl_no}','02 ADMISSION FEE','{$rgPerArray['fee_paying_2']}','{$rgPerArray['student_entry_admno']}'),
		('2019','{$rgPerArray["student_entry_degree_code"]}','{$exam}','{$_SESSION['FCOLLCODE']}',
		'{$sl_no}','03 SPORTS FEE','{$rgPerArray['fee_paying_3']}','{$rgPerArray['student_entry_admno']}'),
		('2019','{$rgPerArray["student_entry_degree_code"]}','{$exam}','{$_SESSION['FCOLLCODE']}',
		'{$sl_no}','04 PROSESSING FEE','{$rgPerArray['fee_paying_4']}','{$rgPerArray['student_entry_admno']}'),
		('2019','{$rgPerArray["student_entry_degree_code"]}','{$exam}','{$_SESSION['FCOLLCODE']}',
		'{$sl_no}','05 CULTURAL ACTIVITIES FEE','{$rgPerArray['fee_paying_5']}','{$rgPerArray['student_entry_admno']}'),
		('2019','{$rgPerArray["student_entry_degree_code"]}','{$exam}','{$_SESSION['FCOLLCODE']}',
		'{$sl_no}','06 ELIGIBILITY FEE','{$rgPerArray['fee_paying_6']}','{$rgPerArray['student_entry_admno']}'),
		('2019','{$rgPerArray["student_entry_degree_code"]}','{$exam}','{$_SESSION['FCOLLCODE']}',
		'{$sl_no}','07 FINE','{$rgPerArray['fee_paying_7']}','{$rgPerArray['student_entry_admno']}')";
		//var_dump($query);
		$results = $aobj_context->mobj_db->Execute($query);

for($k=0;$k<count($sub_data);$k++)
		{
			
			$subcode = "se_sub_code_".$k;
			$exam = substr($sub_data[$subcode], 0, 1);
			$query = "insert into options(FDEGREE,
			FEXAMNO,
			FCOLLCODE,
			FSLNO,
			FSUBCODE,
			FDELETED,fappno)
			values
			(
			'{$rgPerArray["student_entry_degree_code"]}',
			'{$exam}',
			'{$_SESSION['FCOLLCODE']}',
			'{$sl_no}',
			'{$sub_data[$subcode]}',
			'F','{$rgPerArray['student_entry_admno']}')";
			//var_dump($query);	
			$optresults = $aobj_context->mobj_db->Execute($query);
			//var_dump($optresults);
		}

$cert_path = $aobj_context->main_src."/certificates/".$rgPerArray['student_entry_admno'];
	//is successfully inserted
	if(!file_exists($cert_path))
	{
		mkdir($cert_path);
	}

$doc_names = ['ADHAAR', 'CASTE', 'INCOME', 'SSLCMC', 'TCCERT', 'PUMC', 'GCCERT', 'DEGMC'];

// ------------- Document Strart -------------------//////

for($i=0;$i<count($doc_names);$i++)
	{
		
		$GCCERT = $rgPerArray['h_'.$doc_names[$i]];
		if($GCCERT == '')
			continue;

$GCCERT_PATH = $aobj_context->main_src.$GCCERT;
		$filename = explode(".", $GCCERT_PATH);
		$ext = strtolower($filename[1]);

$GCCERT_FILENAME = $doc_names[$i];
		
		$GCCERT_FILENAME = $GCCERT_FILENAME.".".$ext;

$GCCERT_FILENAME_FILENAME = $cert_path."/".$GCCERT_FILENAME;
		$GCCERT = "certificates/{$rgPerArray['student_entry_admno']}/".$GCCERT_FILENAME;

if(copy($GCCERT_PATH,$GCCERT_FILENAME_FILENAME))
		{
			
			$query = "delete from studoc where login_cnt = '{$rgPerArray['student_entry_admno']}' 
			and app_no = '{$sl_no}'
			and fdoctype = '{$doc_names[$i]}'";
			$studocresults = $aobj_context->mobj_db->Execute($query);
			//var_dump($query);
			$insert = "INSERT INTO studoc
			( 
			app_no, 
			login_cnt, 
			file_path, 
			created_date,fdegree,fcollcode,fdoctype
			)
			values
			(
			'{$sl_no}',
			'{$rgPerArray['student_entry_admno']}',
			'{$GCCERT}',now(),'{$rgPerArray['student_entry_degree_code']}','{$_SESSION['FCOLLCODE']}',
			'{$doc_names[$i]}'
			)";	
			//var_dump($insert);
			$lobj_insert= $aobj_context->mobj_db->Execute($insert);
			unlink($GCCERT_PATH);
		}

}

$query = "update studoc set fdegree = '{$rgPerArray['student_entry_degree_code']}'
		where login_cnt = '{$rgPerArray['student_entry_admno']}'";
		$res = $aobj_context->mobj_db->Execute($query);

$college = $_SESSION['FCOLLCODE'];
		$degree  = $rgPerArray['student_entry_degree_code'];
		$fappno  = $rgPerArray['student_entry_admno'];
		$photo_filename = $student_photo;
		$sign_filename = $student_sign;

$college_path=$aobj_context->main_src."/student_photos/{$college}";
		$degree_path=$aobj_context->main_src."/student_photos/{$college}/".$degree;;
		$folder_path=$aobj_context->main_src."/student_photos/{$college}/".$degree;;
		$sign_folder_path = $aobj_context->main_src."/student_photos/{$college}/".$degree."/sign";
		
		
		if($photo_filename != '')
		{
			$image_path = $aobj_context->main_src.$photo_filename;

$filename = explode(".", $photo_filename);
			$ext = strtolower($filename[1]);
			$photo_filename = $college."_".$degree."_".$fappno;
			$photo_filename = $photo_filename.".".$ext;

$full_file_path = $folder_path.'/'.$photo_filename;

if(!file_exists($college_path))
			{
				mkdir($college_path);
			}

if(!file_exists($degree_path))
			{
				mkdir($degree_path);
			}
			if(!file_exists($sign_folder_path))
			{
				mkdir($sign_folder_path);
			}

$photo = "student_photos/{$college}/".$degree.'/'.$photo_filename;
			//var_dump($image_path);
			//var_dump($full_file_path);	
			if(copy($image_path,$full_file_path))
			{
				$update="update studadm set FPHOTOPATH='{$photo}' 
						where FAPPNO=  '{$fappno}'";

$up_obj=$aobj_context->mobj_db->Execute($update); 
				unlink($image_path);
			}
		}

//update signature path
		
		//$sign_filename = $rgPerArray['sign_path'];

if($sign_filename != '')
		{
			$sign_path = $aobj_context->main_src.$sign_filename;

$filename = explode(".", $sign_filename);
			$ext = strtolower($filename[1]);
			$sign_filename = $college."_".$degree."_".$fappno."_sign";
			$sign_filename = $sign_filename.".".$ext;

$full_file_path_sign = $folder_path."/sign/".$sign_filename;

$sign = "student_photos/{$college}/".$degree."/sign/".$sign_filename;
			//var_dump($sign_path);
			//var_dump($full_file_path_sign);

if(copy($sign_path,$full_file_path_sign))
			{
				$update="update studadm set FSIGNPATH='{$sign}' 
						where FAPPNO=  '{$fappno}' ";
				$up_obj=$aobj_context->mobj_db->Execute($update); 
				unlink($sign_path);
			}
		}

$mobj_jsondata = json_decode($rgMultiMarks,true);
		//var_dump($this->mobj_jsondata);
		
		$sub_marks = array();
		for($i=0; $i<count($mobj_jsondata); $i++)
		{
			
			for($j=0;$j<count($mobj_jsondata[$i]);$j++)
			{
				$sub_marks[$i][$mobj_jsondata[$i][$j]['name']] = $mobj_jsondata[$i][$j]['value'];

}	
		}
		if(count($mobj_jsondata) > 0)
		{	
			$query = "delete from qualsubdet where fappno = '{$fappno}'";
			//var_dump($query);
			$resdelt = $aobj_context->mobj_db->Execute($query);
		}	
		//var_dump(count($sub_marks));
		$sql = array();
		$j=0;
		for($i=1; $i<=count($sub_marks);$i++)
		{
			$sql[] = "('{$fappno}'
			,'{$college}'
			,'{$degree}'
			,'S0{$i}'
			,'{$sub_marks[$j]["subsem1_$i"]}',
			'{$sub_marks[$j]["subsem1mo_$i"]}'
			,'{$sub_marks[$j]["subsem1mm_$i"]}'
			,'{$sub_marks[$j]["subsem2mo_$i"]}'
			,'{$sub_marks[$j]["subsem2mm_$i"]}'
			,'{$sub_marks[$j]["subsem3mo_$i"]}'
			,'{$sub_marks[$j]["subsem3mm_$i"]}'
			,'{$sub_marks[$j]["subsem4mo_$i"]}'
			,'{$sub_marks[$j]["subsem4mm_$i"]}'
			,'{$sub_marks[$j]["subsem5mo_$i"]}'
			,'{$sub_marks[$j]["subsem5mm_$i"]}'
			,'{$sub_marks[$j]["subsem6mo_$i"]}'
			,'{$sub_marks[$j]["subsem6mm_$i"]}'
			,'{$sub_marks[$j]["subtotalmo_$i"]}'
			,'{$sub_marks[$j]["subtotalmm_$i"]}'
			,'{$sub_marks[$j]["subpercentagemm_$i"]}')";
			
			$j++;
		}

$query = 'INSERT INTO qualsubdet(fappno,
		fcollcode, fdegree, fsubcode,
		fsubname, fsecmarksa , fmaxmarksa, 
		fsecmarksb, fmaxmarksb,
		fsecmarksc, fmaxmarksc,
		fsecmarksd, fmaxmarksd,
		fsecmarkse, fmaxmarkse,
		fsecmarksf, fmaxmarksf,
		ftotsecmarks, ftotmaxmarks,
		fsubpercent
		) VALUES '.implode(',', $sql);
		//var_dump($query);
		$resultqualdets = $aobj_context->mobj_db->Execute($query);
		//var_dump($resultqualdets);

if($results && $optresults)
	{
		$data = $fappno;
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
		return;
	}
	else
	{
		$data = '';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
		return;
	}
}

function DiaplayStudentSignature($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	session_start();
	$date = date("dmYhis");

$file_name=replaceChars(basename($_FILES['student_entry_signupload']['name']));
	$path_arr=pathinfo($_FILES['student_entry_signupload']['name']);
	$file_ext=$path_arr['extension'];

$temp_path = $aobj_context->main_src."/upload/";
	if(!file_exists($temp_path))
	{
		mkdir($temp_path);
	}

$file_path="/{$date}_{$file_name}";
	$temp_path.=$file_path;

if(isset($_FILES['student_entry_signupload']['name']) && $_FILES['student_entry_signupload']['name'] != '')         
	{ 
		$size=($_FILES['student_entry_signupload']['size']/1024);
		if($size>1024)
		{
			$data="Please Upload the Photo of size less than 1 MB";
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,-2,"success"); 
			return;
		}
		if(move_uploaded_file($_FILES['student_entry_signupload']['tmp_name'],$temp_path))
		 {
			$data="upload/{$file_path}";
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
			return;
		 }
	}
	echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	return;	
}

function DiaplayStudentPhoto($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	session_start();
	$date = date("dmYhis");

$file_name=replaceChars(basename($_FILES['student_entry_upload']['name']));
	$path_arr=pathinfo($_FILES['student_entry_upload']['name']);
	$file_ext=$path_arr['extension'];

$temp_path = $aobj_context->main_src."/upload/";
	if(!file_exists($temp_path))
	{
		mkdir($temp_path);
	}

$file_path="/{$date}_{$file_name}";
	$temp_path.=$file_path;

if(isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '')         
	{ 
		$size=($_FILES['student_entry_upload']['size']/1024);
		if($size>1024)
		{
			$data="Please Upload the Photo of size less than 1 MB";
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,-2,"success"); 
			return;
		}
		if(move_uploaded_file($_FILES['student_entry_upload']['tmp_name'],$temp_path))
		 {
			$data="upload/{$file_path}";
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
			return;
		 }
	}
	echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	return;	
}

function getcombinationsubjectdet($aobj_context)
{

$degree = $aobj_context->mobj_data["degree_code"]; 
	$combination = $aobj_context->mobj_data["combination"];
	$fexamno = $aobj_context->mobj_data["fexamno"];
	$app_no = $aobj_context->mobj_data["app_no"]; 
	//var_dump($combination);

$get_sub_total  = "select FTOTSUB from degree where FDEGREE= '{$degree}' and FEXAMNO='{$fexamno}'";
	$lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total);
		
	$total_sub      = $lobj_sub_total['FTOTSUB'];
	//$exam = 'A';
	$get_exsting_data = "select a.*,b.FSUBNAME,b.FSUBSHORT,FMANDATORY from 
	(select FDEGREE,FEXAMNO,FCOLLCODE,FSLNO,FSUBCODE from options
	where fappno = '{$app_no}' and FCOLLCODE='{$_SESSION['collcode']}' 
	and FEXAMNO='{$fexamno}' and FDEGREE='{$degree}') a
	left join 
	(select s.FDEGREE,
	FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on 
	s.FDEGREE=d.FDEGREE  and  d.FEXAMNO=s.FEXAMNO
	where d.FDEGREE='{$degree}' and s.FEXAMNO='{$fexamno}') b 
	on a.FSUBCODE=b.FSUBCODE
	and a.FDEGREE=b.FDEGREE
	group by FSUBCODE limit {$total_sub}";
	 
	$lobj_get_exsting_data = $aobj_context->mobj_db->getAll($get_exsting_data);
	//var_dump($get_exsting_data);
	$get_true_sub_names="select FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on 
	s.FDEGREE=d.FDEGREE  and  d.FEXAMNO=s.FEXAMNO
	where d.FDEGREE='{$degree}' and s.FEXAMNO='{$fexamno}' and FMANDATORY='T' group by  s.FSUBCODE
	union
	select s.FSUBCODE,s.FSUBNAME,s.FSUBSHORT ,'T' as FMANDATORY from degree d inner join subject s on 
	s.FDEGREE=d.FDEGREE  and  d.FEXAMNO=s.FEXAMNO
	left join mascomb m on m.FDEGREE=d.FDEGREE and m.fcombcode = '{$combination}'
	where d.FDEGREE='{$degree}'  and m.FSUBCODE = s.FSUBCODE  
	group by  s.FSUBCODE";	
	$lobj_get_true_sub_names = $aobj_context->mobj_db->getAll($get_true_sub_names);	
	// var_dump($get_true_sub_names);
	$e_data.="<table  width='94%' class='tr_ventor_row' cellspacing='0' cellpadding='0' border='0' >";
	$e_data.="<tr style='font-size:12px;' class='ui-state-default ui-jqgrid-hdiv'>";		
	$e_data.="<td  style='padding:2px; width:60px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sub Code</td>";
	$e_data.="<td  style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Short Name</td>";
	$e_data.="<td  style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>";
	$e_data.="</tr>";
	
	$k=0;
	$id=0;
	 
	if(empty($lobj_get_exsting_data))
	{
		$remaining_count=$total_sub-count($lobj_get_true_sub_names);
		
		foreach($lobj_get_true_sub_names as $key=>$value)
		{
		  
			$e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow'>";
			$e_data.="<td class='tbl_row_new subcode' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;'><input  tabindex=-1  {$inp_class} type=text style='width:60px;border:none;' readonly id='se_sub_code_{$id}' value='{$value['FSUBCODE']}' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'></td>";
			$e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:60px;' {$inp_class}  tabindex=-1  readonly id='se_short_name_{$id}' value='{$value['FSUBSHORT']}'></td>";
			$e_data.="<td  class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:290px;' {$inp_class} id='se_sub_name_{$id}'  tabindex=-1   readonly value='{$value['FSUBNAME']}'> </td>";
			$e_data.="</tr>";
			 $k++;
			 $id++;
		}

$name=''; 
		
		$last_slno_execution ="  select s.FSUBCODE, s.FSUBSHORT, s.FSUBNAME 
			from subject s inner join options d on 									
			s.FDEGREE=d.FDEGREE  and  s.FEXAMNO=d.FEXAMNO and 
			d.fsubcode = s.fsubcode and d.FCOLLCODE='{$_SESSION['collcode']}' and
			s.fssubname != 'I.A.' and s.FMANDATORY = 'F' and
			s.FDEGREE='{$degree}' and 
			d.fslno = 
			( select MAX(s.fslno) from studadm s 
			where s.FDEGREE='{$degree}'
			AND FCOLLCODE='{$_SESSION['collcode']}' ) group by    s.FSUBCODE
			";
			$lobj_last_slno_execution = $aobj_context->mobj_db->getAll($last_slno_execution);
		
		for($j=0;$j<$remaining_count;$j++)
		{

if($k%2==0)
			{
			$class='tbl_row';
			$inp_class='tbl_row_input';
			}
			else
			{
			$input_class='tbl_row1'; 
			$inp_class='tbl_row1_input';
			}  
			if($j==0)
			$name="name='focus'";
			else
			$name='';
			 
			 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >";
			 $e_data.="<td class='tbl_row_new subcode' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name}  onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>";
			 $e_data.="<td class='tbl_row_new' align='center'  style='border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'  tabindex=-1  readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}'  ></td>";
			 $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1  readonly  style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}'  ></td>";
			 $e_data.="</tr>";
			 $k++;
			 $id++;
		}  
	}
	else
	{
	$flag=0;
	$remaining_count=$total_sub-count($lobj_get_exsting_data);
	for($h=0;$h<count($lobj_get_exsting_data);$h++)
	{
		$read_only=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?"readOnly":''; 
		$border=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?" border:none;":''; 
		$on_blur =($lobj_get_exsting_data[$h]['FMANDATORY']=='F')?" onblur='getSubDetails( this.id,{$id});' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' ":'';
		$focus_id =($lobj_get_exsting_data[$h]['FMANDATORY']=='F')?" onfocus=\$g_focus_element='se_sub_code_{$id}' ":'';
		   
		if($k%2==0)
		{
			$class='tbl_row';
			$inp_class='tbl_row_input';
		}
		else
		{
			$input_class='tbl_row1'; 
			$inp_class='tbl_row1_input';
		}
		if(($lobj_get_exsting_data[$h]['FMANDATORY']=='F') && $flag==0)
		{
			$name="name='focus'";
			$flag=1;
		}else
			$name='';
	 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >";
	 $e_data.="<td class='tbl_row_new subcode' align='center'style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; padding:1px;'><input type='text' {$input_class} {$on_blur } {$name} {$read_only} align='center' {$focus_id} value='{$lobj_get_exsting_data[$h]['FSUBCODE']}' style = 'width:60px;{$border}' id='se_sub_code_{$id}'>  </td>";
	 $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'   {$read_only} style = 'width:60px;border:none;'  {$inp_class} value='{$lobj_get_exsting_data[$h]['FSUBSHORT']}' id='se_short_name_{$id}'></td>";
	 $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text'   {$read_only} style = 'width:290px;border:none;' {$inp_class}  value='{$lobj_get_exsting_data[$h]['FSUBNAME']}' id='se_sub_name_{$id}'></td>";
	 $e_data.="</tr>";
	 $k++;
	 $id++;
	}
		$k=0;
		for($j=0;$j<$remaining_count;$j++)
		{				 
			if($k%2==0)
			{
			$class='tbl_row';
			$inp_class='tbl_row_input';
			}
			else
			{
			$input_class='tbl_row1'; 
			$inp_class='tbl_row1_input';
			}  
			if($j==0)
			$name="name='focus'";
			else
			$name='';
			 
			 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >";
			 $e_data.="<td class='tbl_row_new subcode' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name}  onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>";
			 $e_data.="<td class='tbl_row_new' align='center'  style='border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'  tabindex=-1  readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}'  ></td>";
			 $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1  readonly  style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}'  ></td>";
			 $e_data.="</tr>";
			 $k++;
			 $id++;
		}
	}		
	 
	$e_data.="</table>";
	$arr['html']=$e_data;
	$arr['table_data']=$lobj_get_true_sub_names;
	$arr['remaining_count']=$remaining_count;
	$arr['total_count']=$id;

if(!empty($lobj_get_true_sub_names))
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;
	}
	else
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-2,"Failure"); 
		return;
	}

}

function removedocument($aobj_context)
{

session_start();
	$degree = $aobj_context->mobj_data["degree_code"]; 
	$fappno = $aobj_context->mobj_data["fappno"];
	$filename = $aobj_context->mobj_data["filename"];
	$collcode = $_SESSION['collcode'];

$query = "update studoc set file_path = null
			where fcollcode = '{$collcode}' and fdoctype = '{$filename}' 
			and login_cnt = '{$fappno}' and fdegree = '{$degree}'";

//	var_dump($query);		
	$results = $aobj_context->mobj_db->Execute($query);

if($results)
	{	
		$arr['filename'] = $filename;
		$arr['fappno'] = $fappno;
		$arr['degree'] = $degree;
		$arr['msg'] = "Document Removed.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;

}else
	{
		$arr = "Document Removal Failure. Please Try Gain";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); 
		return;
	}		
}

function RemoveApplication($aobj_context)
{

session_start();
	$appno = $aobj_context->mobj_data["appno"]; 
	$degree = $aobj_context->mobj_data["degree"];
	$collcode = $_SESSION['collcode'];

$query = "update studadm set FAPPSTATUS = null,FACKDATE=null,FACKUSER = null,FCONSTYPE = null,
			funivfee = null,fadmfine = null,ftotfee = null
			where fcollcode = '{$collcode}' and fappno = '{$appno}' and fdegree = '{$degree}'";
	$results = $aobj_context->mobj_db->Execute($query);

if($results)
	{

$query = "delete from admfeedetl where fcollcode = '{$collcode}' and fappno = '{$appno}' 
		and fdegree = '{$degree}'";
		$results = $aobj_context->mobj_db->Execute($query);

}	
	if($results)
	{

$arr['msg'] = "Acknowledgement Removed.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;

}else
	{
		$arr = "Acknowledgement Removal Failure. Please Try Gain";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); 
		return;
	}
}

function DeleteApplication($aobj_context)
{

session_start();
	$appno = $aobj_context->mobj_data["appno"]; 
	$degree = $aobj_context->mobj_data["degree"];
	$collcode = $_SESSION['collcode'];

$query = "select FCONTACT_NO from studadm where fappno = '{$appno}'";
	$results1 = $aobj_context->mobj_db->GetRow($query);

$query = "update studadm set fdeleted = 'T'
			where fcollcode = '{$collcode}' and fappno = '{$appno}' and fdegree = '{$degree}'";
	$results = $aobj_context->mobj_db->Execute($query);

if($results)
	{
			$mob = $results1['FCONTACT_NO'];
			$query = "update options set fdeleted = 'T'
					where fcollcode = '{$collcode}' 
					and fappno = '{$appno}' and fdegree = '{$degree}'";
			$results = $aobj_context->mobj_db->Execute($query);
		
			$query = "update studoc set fdeleted = 'T'
					where fcollcode = '{$collcode}' 
					and login_cnt = '{$appno}' and fdegree = '{$degree}'";
			$results = $aobj_context->mobj_db->Execute($query);

$query = "delete from admfeedetl where fcollcode = '{$collcode}' and fappno = '{$appno}' 
			and fdegree = '{$degree}'";
			$results = $aobj_context->mobj_db->Execute($query);

$query = "update collstud set fdeleted = 'T' where fmobileno = '{$mob}'";
			$results = $aobj_context->mobj_db->Execute($query);

}

if($results)
	{

$arr['msg'] = "Deleted successfully.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;

}else
	{
		$arr = "Acknowledgement Removal Failure. Please Try Gain";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); 
		return;
	}
}

${this.title}

Code Editor : ack_adm_application.php