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
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	24.41 KB	-rwxr-xr-x
MarkEntry-Setup22.php	21.76 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
TAGMAY2013.pdf	331.03 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.71 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	7.25 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.03 KB	-rwxr-xr-x
absententrysubjectwiseQP.js	16.34 KB	-rwxr-xr-x
ack_exam_app_form.php	15.86 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_rv_rt_application.php	8.52 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
admapprove.php	9.24 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admissionapplist.php	9.9 KB	-rwxr-xr-x
ansbookcancel.php	9.49 KB	-rwxr-xr-x
answer_book_issued.php	10.34 KB	-rwxr-xr-x
approve.php	23.86 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.74 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
boeselection.php	1.64 KB	-rwxr-xr-x
bundle_dispatch.php	2.93 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	45.51 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.64 KB	-rwxr-xr-x
cconfig_wait.php	1.12 KB	-rwxr-xr-x
challan_entries.php	15.41 KB	-rwxr-xr-x
challan_preparation.php	11.69 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
colldesp_ack.php	4 KB	-rwxr-xr-x
college.php	4.61 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxr-xr-x
college_approve.php	5.61 KB	-rwxr-xr-x
college_degree_status.php	5.65 KB	-rwxr-xr-x
connect.php	2.11 KB	-rwxr-xr-x
convdet.php	8.02 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
create_all_grid_files.php	8.57 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	9.94 KB	-rwxr-xr-x
create_all_grid_group_files_ol...	9.61 KB	-rwxr-xr-x
create_all_popup_files.php	5.93 KB	-rwxr-xr-x
create_all_schema_files.php	4.31 KB	-rwxr-xr-x
create_all_views.php	16.52 KB	-rwxr-xr-x
create_html_files.php	52.03 KB	-rwxr-xr-x
create_html_files_without_tab....	44.49 KB	-rwxr-xr-x
create_module_meta_columns.php	5.16 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	7.36 KB	-rwxr-xr-x
degree.php	6.49 KB	-rwxr-xr-x
display_details_in_grid.php	105.86 KB	-rwxr-xr-x
display_details_in_grid22.php	104.95 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.6 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	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.54 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
execute_query.php	2.5 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.63 KB	-rwxr-xr-x
freeze_module_at_admin_college...	9.74 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
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getdata.php	35.88 KB	-rwxr-xr-x
getdata22.php	32.91 KB	-rwxr-xr-x
getdataold.php	28.7 KB	-rwxr-xr-x
getfeeinformation.php	7.03 KB	-rwxr-xr-x
getmoduledetails.php	23.59 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
hidden.php	239.01 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.22 KB	-rwxr-xr-x
krvw.html	1.5 KB	-rwxr-xr-x
login.php	10.94 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 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	90.13 KB	-rwxr-xr-x
mregistry_09012020.php	73.81 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 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
printexamform.php	11.54 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.57 KB	-rwxr-xr-x
report_admission_ticket.php	46.77 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	15.43 KB	-rwxr-xr-x
room_allotment_datewise.php	15.59 KB	-rwxr-xr-x
room_allotment_datewise_090120...	15.37 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.77 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-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
student.php	43.89 KB	-rwxr-xr-x
student_entry.php	45.88 KB	-rwxr-xr-x
student_entry24.php	56.54 KB	-rwxr-xr-x
student_entry_24112017.php	42.7 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subjectList_display.php	11.05 KB	-rwxr-xr-x
subject_freshExam.php	18.98 KB	-rwxr-xr-x
subjectfreez.php	13.16 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	9.95 KB	-rwxr-xr-x
subshort.php	5.83 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	79.94 KB	-rwxr-xr-x
teachers.php	16.85 KB	-rwxr-xr-x
teachersOLD.php	10.33 KB	-rwxr-xr-x
teachersnew.php	16.83 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	4.79 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
updateexamcnt.php	2.92 KB	-rwxr-xr-x
upload_studentPhoto.php	10.06 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
uploadzip.php	8.46 KB	-rwxr-xr-x
usersetup.php	25.06 KB	-rwxr-xr-x
usersetupold.php	24.36 KB	-rwxr-xr-x
usersubj_identification.php	4.88 KB	-rwxr-xr-x

Code Editor : ack_exam_app_form.php

<?php	
class ack_exam_app_form
{
    
		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->funivcode=$_SESSION['FUNIVCODE'];		
			$this->collcode=$_SESSION['collcode'];	
			$this->log_name = $_SESSION['usr'];	
			$this->user_type=$_SESSION['user_type'];
		}
		 
		function AcknowledgeSelectedExamApplications()
		{
			  
			 	$checked_app_nos = ($this->aobj_context->mobj_data["checked_app_nos"]);
				$exp_arr=explode(",",$checked_app_nos);
				foreach($exp_arr as $apk)
				{
					$update =" update appcandsum 
					set fackdate = now(), fackuser = '{$this->log_name}', fpaymentconfirm = 'success', fpaymentstatus = 'success', 
					fpaymentremarks = 'Manual Acknowledgement', frecptdate = now() 
					where appno = '{$apk}'";
				
					$lobj_get_data = $this->aobj_context->mobj_db->Execute($update);
					
					$lquery = "select fregno from appcandsum where appno = '{$apk}'";
					
					$lresult = $this->aobj_context->mobj_db->getRow($lquery);
					
					$fregno = $lresult['fregno'];
					
					$update_cand_sum = "UPDATE appcandsumview a, candsum c, appcandsum ac
					SET 
					c.FEXAMFEEA = if(ifnull(a.FEXAMFEEA,0) > 0,ifnull(a.FEXAMFEEA,0),ifnull(c.FEXAMFEEA,0)),
					c.FEXAMFEEB = if(ifnull(a.FEXAMFEEB,0) > 0,ifnull(a.FEXAMFEEB,0),ifnull(c.FEXAMFEEB,0)),
					c.FEXAMFEEC = if(ifnull(a.FEXAMFEEC,0) > 0,ifnull(a.FEXAMFEEC,0),ifnull(c.FEXAMFEEC,0)),
					c.FEXAMFEED = if(ifnull(a.FEXAMFEED,0) > 0,ifnull(a.FEXAMFEED,0),ifnull(c.FEXAMFEED,0)),
					c.FEXAMFEEE = if(ifnull(a.FEXAMFEEE,0) > 0,ifnull(a.FEXAMFEEE,0),ifnull(c.FEXAMFEEE,0)),
					c.FEXAMFEEF = if(ifnull(a.FEXAMFEEF,0) > 0,ifnull(a.FEXAMFEEF,0),ifnull(c.FEXAMFEEF,0)),
					c.FEXAMFEEG = if(ifnull(a.FEXAMFEEG,0) > 0,ifnull(a.FEXAMFEEG,0),ifnull(c.FEXAMFEEG,0)),
					c.FEXAMFEEH = if(ifnull(a.FEXAMFEEH,0) > 0,ifnull(a.FEXAMFEEH,0),ifnull(c.FEXAMFEEH,0)),
					c.FEXAMFEEI = if(ifnull(a.FEXAMFEEI,0) > 0,ifnull(a.FEXAMFEEI,0),ifnull(c.FEXAMFEEI,0)),
					c.FEXAMFEEJ = if(ifnull(a.FEXAMFEEJ,0) > 0,ifnull(a.FEXAMFEEJ,0),ifnull(c.FEXAMFEEJ,0)),
					c.FTOTALFEE = a.FTOTALFEE,
					c.frecptdate = date(ac.FACKDATE)
					WHERE a.fregno = c.FREGNO and ac.fregno = c.fregno and ac.fdegree = c.fdegree 
					and ac.APPNO='{$apk}'";
					
					$lobj_update_cand_sum = $this->aobj_context->mobj_db->Execute($update_cand_sum);
					
					$lquery = "update canddet cd, appcanddet ad set cd.fpresent = ad.fpresent, cd.finserted	= ad.finserted
					where cd.fcollcode = ad.fcollcode and cd.fdegree = ad.fdegree and cd.fexamno = ad.fexamno 
					and cd.fsubcode = ad.fsubcode and cd.fregno = ad.fregno
					and cd.fregno='{$fregno}'
					and ad.appno = '{$apk}' and ifnull(cd.fpresent,'') <> 'P'";
					
					$lobj_get_app_cand_det = $this->aobj_context->mobj_db->Execute($lquery);
			
					$lquery = "insert ignore into canddet(FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, FINSERTED, FPRESENT, FYEAR, FEXAMTYPE)  
					select FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, FINSERTED, FPRESENT, FYEAR, FEXAMTYPE from appcanddet 
					where fregno='{$fregno}' and appno = '{$apk}' and ifnull(fpresent,'') = 'P'";
					
					$lobj_get_app_cand_det = $this->aobj_context->mobj_db->Execute($lquery);
					
					
					$lquery = "drop table if exists tmpstudfeeupd";
					$lresult = $this->aobj_context->mobj_db->Execute($lquery);	
					
					$lquery = "create table tmpstudfeeupd
					select distinct f.fdegree, f.fexamno, f.fcollcode, f.fregno, f.ffeecode, sum(ifnull(f.famount,0)) as famount, 
					'F' as fdeleted from appstudfee f, appcandsum  s
					where f.appno = s.appno and f.fdegree = s.fdegree and f.fregno = s.fregno 
					and s.fregno = '{$fregno}' and ifnull(s.fackdate, '') <> '' 
					and s.fpaymentconfirm = 'success' and s.fpaymentstatus = 'success'
					group by f.fdegree, f.fexamno, f.fcollcode, f.fregno, f.ffeecode";
					
					$lobj_update = $this->aobj_context->mobj_db->Execute($lquery);
					
					$lquery = "CREATE INDEX tmpstudfeeupd_idx ON tmpstudfeeupd(fdegree, fexamno, fcollcode, fregno, ffeecode)";
					
					$lobj_update = $this->aobj_context->mobj_db->Execute($lquery);
					
					$update = "update studfee sd, tmpstudfeeupd asd set sd.famount = asd.famount,
					sd.flogname = '{$this->log_name}', sd.flogdate = now()
					where sd.fdegree = asd.fdegree and sd.fexamno = asd.fexamno 
					and sd.fregno = asd.fregno and sd.ffeecode = asd.ffeecode 
					and asd.fregno='{$fregno}'";
					
					$lobj_update = $this->aobj_context->mobj_db->Execute($update);	
					
					$insert_into_student_fee = "insert ignore into studfee
					(FDEGREE,FEXAMNO, FCOLLCODE, FREGNO, FFEECODE, FAMOUNT, FLOGNAME, FLOGDATE) 
					select fdegree, fexamno, fcollcode, fregno, ffeecode, famount, '{$this->log_name}', now() 
					from tmpstudfeeupd where fregno='{$fregno}'";
					
					$lobj_insert_into_student_fee = $this->aobj_context->mobj_db->Execute($insert_into_student_fee);
					
					//$this->UpdateCandSumCandDet($apk);					
					//$this->UpdateStudeFee($apk);					
				}
			$data="Application(s) acknowledged successfully.";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 		
 		}
		
		function UpdateStudeFee($apk)
		{
			$get_app_stud_fee="SELECT FDEGREE,FEXAMNO,FCOLLCODE,FREGNO,FFEECODE,FAMOUNT
										FROM appstudfee  WHERE   APPNO='{$apk}'
									and FCOLLCODE='{$this->collcode}' ";
			$lobj_get_app_stud_fee = $this->aobj_context->mobj_db->GetAll($get_app_stud_fee);	
		  
			foreach($lobj_get_app_stud_fee as $ak=>$av)
			{
					$FCOLLCODE=$av['FCOLLCODE'];
					$FDEGREE=$av['FDEGREE'];
					$FEXAMNO=$av['FEXAMNO'];
					$FREGNO=$av['FREGNO'];
					$FFEECODE=$av['FFEECODE'];
					$FAMOUNT=$av['FAMOUNT'];
					$get_dup_cnt="SELECT  count(1) as dup_cnt
												FROM studfee
												where FDEGREE='{$FDEGREE}'
												AND FEXAMNO='{$FEXAMNO}'
												AND FCOLLCODE='{$FCOLLCODE}'
												AND FREGNO='{$FREGNO}'
												AND FFEECODE='{$FFEECODE}' and FCOLLCODE='{$this->collcode}'";
					$lobj_get_dup_cnt = $this->aobj_context->mobj_db->GetRow($get_dup_cnt);	
					//echo "<br>".$get_dup_cnt;
					$dup_cnt=$lobj_get_dup_cnt['dup_cnt'];
					if($dup_cnt==0)
					{
						$insert_into_student_fee="insert into studfee
										(
										FDEGREE,FEXAMNO,FCOLLCODE,FREGNO,FFEECODE,FAMOUNT,FLOGNAME,FLOGDATE
										) VALUES
										(
										'{$FDEGREE}',
										'{$FEXAMNO}',
										'{$this->collcode}',
										'{$FREGNO}',
										'{$FFEECODE}',
										'{$FAMOUNT}',
										'{$this->log_name}',
										NOW()
										)";
										$lobj_insert_into_student_fee = $this->aobj_context->mobj_db->Execute($insert_into_student_fee);
							//echo $insert_into_student_fee."<br>";			 
						 				
					}
					else
					{
						$update="	update   studfee set FAMOUNT={$FAMOUNT},
									FLOGNAME='{$this->log_name}',FLOGDATE=now()
									where FDEGREE='{$FDEGREE}'
									AND FEXAMNO='{$FEXAMNO}'
									AND FCOLLCODE='{$FCOLLCODE}'
									AND FREGNO='{$FREGNO}'
									AND FFEECODE='{$FFEECODE}'
									and FCOLLCODE='{$this->collcode}'";
					 					
						$lobj_update = $this->aobj_context->mobj_db->Execute($update);							
					}
			}			
		}
		function UpdateCandSumCandDet($apk)
		{
			
			
			
			$get_app_cand_det = "SELECT FDEGREE,FEXAMNO,FCOLLCODE,FREGNO,FSUBCODE,FINSERTED,FPRESENT,FYEAR,FEXAMTYPE
								FROM appcanddet
								WHERE APPNO = {$apk} and ifnull(fpresent,'') = 'P'";
			$lobj_get_app_cand_det = $this->aobj_context->mobj_db->GetAll($get_app_cand_det);
			foreach($lobj_get_app_cand_det as $ak=>$av)
			{
					$FCOLLCODE=$av['FCOLLCODE'];
					$FDEGREE=$av['FDEGREE'];
					$FEXAMNO=$av['FEXAMNO'];
					$FREGNO=$av['FREGNO'];
					$FSUBCODE=$av['FSUBCODE'];
					$FINSERTED=$av['FINSERTED'];
					$FPRESENT=$av['FPRESENT'];
					$FYEAR=$av['FYEAR'];
					$FEXAMTYPE=$av['FEXAMTYPE'];
					$get_cand_det_cnt = "select count(1) as cnt from canddet
										where    FDEGREE='{$FDEGREE}'
										AND FEXAMNO='{$FEXAMNO}'
										AND FCOLLCODE='{$FCOLLCODE}'
										AND FREGNO='{$FREGNO}'
										AND FSUBCODE='{$FSUBCODE}'";
					$lobj_get_cand_det_cnt = $this->aobj_context->mobj_db->GetRow($get_cand_det_cnt);	
					$cnt=$lobj_get_cand_det_cnt['cnt'];
					if($cnt>0)
					{
						$update = " update canddet 
									set FINSERTED='{$FINSERTED}',
									FPRESENT='{$FPRESENT}'
									where    FDEGREE='{$FDEGREE}'
									AND FEXAMNO='{$FEXAMNO}'
									AND FCOLLCODE='{$FCOLLCODE}'
									AND FREGNO='{$FREGNO}'
									AND FSUBCODE='{$FSUBCODE}' AND FEXAMNO = '{$FEXAMNO}' and ifnull(fpresent,'') <> 'P'";
						$lobj_update = $this->aobj_context->mobj_db->Execute($update);		 
					}
					else
					{
						$insert="
							INSERT INTO canddet 
							(FDEGREE, 
							FEXAMNO, 
							FCOLLCODE, 
							FREGNO, 
							FSUBCODE, 
							FINSERTED, 
							FPRESENT, 
							FYEAR, 
							FEXAMTYPE
							)
							values
							(
							'{$FDEGREE}',
							'{$FEXAMNO}',
							'{$FCOLLCODE}',
							'{$FREGNO}',
							'{$FSUBCODE}',
							'{$FINSERTED}',
							'{$FPRESENT}',
							'{$FYEAR}',
							'{$FEXAMTYPE}' 
							)";
						 	
							$lobj_insert = $this->aobj_context->mobj_db->Execute($insert);		 	
					}	
			}			
		}
		
		function DisplayAllAckExamApplications()
		{
			 	$app_no_from = trim($this->aobj_context->mobj_data["app_no_from"]);
				//var_dump(stripslashes($app_no_from));
				//$app_no_from=str_pad($app_no_from, 10, "0", STR_PAD_LEFT);
				
				$app_no_to = ($this->aobj_context->mobj_data["app_no_to"]);
				$ack_type = ($this->aobj_context->mobj_data["ack_type"]);
				$app_no_to.= $app_no_from;
				$app_no_from = stripslashes($app_no_from);
				$app_no_from = substr($app_no_from, 0, -1);
				//die();
				$fisrt = true;
				
				if($ack_type == 'Pending')
				{
					$ref = "AND (FACKDATE IS NULL OR FACKDATE='')";
				}
				else if($ack_type == 'Acknowledged')
				{
					$ref = "AND ifnull(FACKDATE,'') <> ''";
				}
				else
				{
					$ref = "";
				}
				/* if($this->funivcode == '018')
					$condition = "AND (concat(r.APPNO,r.fregno) in({$app_no_from}) or concat(r.fregno) in ({$app_no_from}))";
				else */
					$condition = "AND r.APPNO in({$app_no_from})";
				
				$get_data =" SELECT DISTINCT r.APPNO,  r.FPAYMENTYPE,FACKDATE,
				DATE_FORMAT(r.FDATE,'%d/%m/%Y') AS FAPPDATE,r.FREGNO,s.FNAME,
				r.FDEGREE,r.FTOTALFEE 
				FROM appcandsum r INNER JOIN student s ON s.FREGNO=r.FREGNO 
				WHERE r.FCOLLCODE='{$this->collcode}'  {$ref}
				{$condition} 
				order by r.FREGNO,r.APPNO";		
				//var_dump($get_data);
				$lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data);
				/* if($fisrt)
				{	
					$str_reval.="<br>";
					$str_reval.="<table style='' class='tr_ventor_row' id='reval_table_data' width='780px;' border='0' cellspacing='0' cellpadding='0'>";
					$str_reval.="<tr class='tr_bg1'>";
					$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl. No.</td>";
					$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Application No</td>";
					$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Date</td>";
					$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Reg. No.</td>";
					$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Student Name</td>";
					$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Degree</td>";
					$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Amount</td>";
					$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Select</td>";
					$str_reval.="</tr>";
					$fisrt = false;
				} */
	 
			$k=0;
			$sl_no=1;
			foreach($lobj_get_data as $ak=>$av)
			{
				$strPos = strpos($this->collcode,'P');
				if($this->user_type != 'SuperUser' && ($striPos != 0) && $this->user_type != 'Admin')
				{
					if($av['FPAYMENTYPE'] == 'POSTOFFICE' || $av['FPAYMENTYPE'] == 'DEBIT/CREDIT/NET BANKING')
					{
						$disabled = 'disabled';
					}
					else
					{
						$disabled= '';
					}
				}
				
				$APPNO=$av['APPNO'];
				$FREGNO=$av['FREGNO'];
				$FAPPDATE=$av['FAPPDATE'];
				$FNAME=$av['FNAME'];
				$FDEGREE=$av['FDEGREE'];
				$FAMOUNT=$av['FTOTALFEE'];
				$FACKDATE = $av['FACKDATE'];

if($FACKDATE != '')
				{
					$disabled = 'disabled checked';
				}
				else
				{
					$disabled = 'checked';
				}
				if($k%2==0)
				$class='tbl_row1';
				else
				$class='tbl_row_alter1';
				$str_reval.="<tr>";		
				$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >{$sl_no}</td>";
				$str_reval.="<td class='{$class}' style=' font-size:12px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center; ' >&nbsp;<a href=# style='color:blue;' onclick='PrintOnlineExamApplicationForm(\"{$APPNO}\")'>{$APPNO}</a></td>";
				$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center;  ' >{$FAPPDATE}&nbsp;</td>";
				$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center;  ' >&nbsp;{$FREGNO}</td>";
				$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:left; ' >{$FNAME}</td>";
				$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center; ' >{$FDEGREE}</td>";
				$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center; ' >{$FAMOUNT}</td>";
				$str_reval.="<td class='{$class}' align='center' style=' font-size:12px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-weight:bold;text-align:center;' ><input type='checkbox' {$disabled}  id='ack_check_box_{$APPNO}' /></td>"; 
			//	$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; text-align:center; ' >{$disabled_txt}</td>";
				$str_reval.="</tr>";
				$sl_no++;
				$k++;
			}			
		/* $str_reval.="</table>";
		$str_reval.="<br>"; */
		$arr['html']=$str_reval;
		$arr['app_no']=$app_no_from;
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 	
			 
		}
		 
 }
	
function DisplayAllAckExamApplications($aobj_context)
{
    $class_obj=new ack_exam_app_form($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$class_obj->DisplayAllAckExamApplications();
} function AcknowledgeSelectedExamApplications($aobj_context)
{
    $class_obj=new ack_exam_app_form($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$class_obj->AcknowledgeSelectedExamApplications();
}

${this.title}

Code Editor : ack_exam_app_form.php