Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxrwxrwx
.src.php	3.61 KB	-rw-r--r--
Dispatch_ans_script_setup.php	5.84 KB	-rwxrwxrwx
Dispatch_ans_script_setup_qp.p...	5.18 KB	-rwxrwxrwx
ECHblk.php	11.06 KB	-rwxrwxrwx
FormulaEvaluate.php	14.15 KB	-rwxrwxrwx
MarkEntry-Setup.php	19.98 KB	-rwxrwxrwx
MarkEntry-SetupTEST.php	21.01 KB	-rwxrwxrwx
MarkEntry-Setup_28102014.php	22.99 KB	-rwxrwxrwx
TAGMAY2013.pdf	331.03 KB	-rwxrwxrwx
TarkaFormatStyles.php	15.37 KB	-rwxrwxrwx
TarkaFormatStyles_old.php	3.71 KB	-rwxrwxrwx
absent_entry_setup.php	8.13 KB	-rwxrwxrwx
absent_entry_setupQp.php	6.93 KB	-rwxrwxrwx
absent_entry_setup_old.php	7.61 KB	-rwxrwxrwx
ack_exam_app_form.php	12.09 KB	-rwxrwxrwx
ack_exam_app_form_07032014.php	9 KB	-rwxrwxrwx
ack_exam_app_form_14032014.php	9.6 KB	-rwxrwxrwx
ack_rv_rt_application.php	7.7 KB	-rwxrwxrwx
ack_rv_rt_application_5days.ph...	7.41 KB	-rwxrwxrwx
ack_rv_rt_application_before_l...	6.02 KB	-rwxrwxrwx
actClass.php	6.21 KB	-rwxrwxrwx
admission_entry_status.php	2.73 KB	-rwxrwxrwx
attendance.php	6.13 KB	-rwxrwxrwx
auto-complete.php	4.89 KB	-rwxrwxrwx
backup_restore.php	8.14 KB	-rwxrwxrwx
backupandrestore.php	10.18 KB	-rwxrwxrwx
bundle_dispatch.php	2.84 KB	-rwxrwxrwx
cManualMailer.php	2.54 KB	-rwxrwxrwx
caccesscontext.php	1.24 KB	-rwxrwxrwx
candidate-entry.php	42.45 KB	-rwxrwxrwx
candidate-entry1.php	37 KB	-rwxrwxrwx
candidate-entry24082012.php	33.21 KB	-rwxrwxrwx
candidate-entry_220413.php	33.21 KB	-rwxrwxrwx
candidate-entry_without_iapr_i...	34.88 KB	-rwxrwxrwx
candidate-entrybefore yearexam...	34.55 KB	-rwxrwxrwx
candidate-entrykus.php	33.23 KB	-rwxrwxrwx
candidate-entryold.php	34.55 KB	-rwxrwxrwx
cappcontext.php	3.19 KB	-rwxrwxrwx
challan_entries.php	13.34 KB	-rwxrwxrwx
challan_preparation.php	10.28 KB	-rwxrwxrwx
cmailer.php	6.83 KB	-rwxrwxrwx
college.php	4.61 KB	-rwxrwxrwx
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxrwxrwx
college_degree_status.php	5.86 KB	-rwxrwxrwx
coutput.php	1.75 KB	-rwxrwxrwx
create_all_grid_files.php	8.57 KB	-rwxrwxrwx
create_all_grid_group_files.ph...	9.94 KB	-rwxrwxrwx
create_all_grid_group_files_ol...	9.61 KB	-rwxrwxrwx
create_all_popup_files.php	5.93 KB	-rwxrwxrwx
create_all_schema_files.php	4.31 KB	-rwxrwxrwx
create_all_views.php	16.52 KB	-rwxrwxrwx
create_html_files.php	52.03 KB	-rwxrwxrwx
create_html_files_without_tab....	44.49 KB	-rwxrwxrwx
create_module_meta_columns.php	5.16 KB	-rwxrwxrwx
crequestbroker.php	2.49 KB	-rwxrwxrwx
csessions.php	514 B	-rwxrwxrwx
cuser.php	3.41 KB	-rwxrwxrwx
custom_mregistry.php	122 B	-rwxrwxrwx
datadictionary.php	3.96 KB	-rwxrwxrwx
daterange.php	4.86 KB	-rwxrwxrwx
degree.php	6.51 KB	-rwxrwxrwx
degree1.php	6.78 KB	-rwxrwxrwx
display_details_in_grid.php	101.68 KB	-rwxrwxrwx
display_details_in_grid_240320...	98.86 KB	-rwxrwxrwx
display_details_in_grid_before...	98.71 KB	-rwxrwxrwx
display_details_in_grid_custom...	2.68 KB	-rwxrwxrwx
display_details_in_grid_studta...	96.56 KB	-rwxrwxrwx
display_details_in_grid_withde...	97.45 KB	-rwxrwxrwx
doc_verify.php	7.02 KB	-rwxrwxrwx
download_misc_files.php	3.3 KB	-rwxrwxrwx
download_misc_files_19062014.p...	3.25 KB	-rwxrwxrwx
download_photo.php	3.68 KB	-rwxrwxrwx
download_photo_12092018.php	4.1 KB	-rwxrwxrwx
download_upload.php	3.86 KB	-rwxrwxrwx
dynamicmastersdetails.php	117.45 KB	-rwxrwxrwx
dynamicmastersdetails_23.php	120 KB	-rwxrwxrwx
dynamicmastersdetails_one.php	119.36 KB	-rwxrwxrwx
entryexitevents.php	3.09 KB	-rwxrwxrwx
execute_query.php	2.5 KB	-rwxrwxrwx
execute_query27062012.php	2.51 KB	-rwxrwxrwx
export_import_setup.php	7.62 KB	-rwxrwxrwx
export_import_utility.php	2.67 KB	-rwxrwxrwx
format.php	7.43 KB	-rwxrwxrwx
freeze_Ad_Cl_Me.php	6.64 KB	-rwxrwxrwx
freeze_module_at_admin_college...	6.53 KB	-rwxrwxrwx
freeze_module_at_university_co...	7.45 KB	-rwxrwxrwx
general_report_format.php	11 KB	-rwxrwxrwx
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxrwxrwx
getdata.php	33.04 KB	-rwxrwxrwx
getdata110911.php	16.03 KB	-rwxrwxrwx
getdata22.php	28.7 KB	-rwxrwxrwx
getdata27062012.php	16.8 KB	-rwxrwxrwx
getdata_24032015.php	20.96 KB	-rwxrwxrwx
getfeeinformation.php	6.95 KB	-rwxrwxrwx
getmoduledetails.php	23.7 KB	-rwxrwxrwx
getnumword.php	7.43 KB	-rwxrwxrwx
getreportdetails.php	3.21 KB	-rwxrwxrwx
getreportfilefordisplay.php	1.37 KB	-rwxrwxrwx
getsearchcondition.php	1.3 KB	-rwxrwxrwx
ggridmodel.php	9.27 KB	-rwxrwxrwx
golden_palm_payslip.php	12.48 KB	-rwxrwxrwx
helptext.php	5.38 KB	-rwxrwxrwx
identify_transactions.php	6.4 KB	-rwxrwxrwx
import_marks.php	4.11 KB	-rwxrwxrwx
json.php	33.22 KB	-rwxrwxrwx
login.php	6.11 KB	-rwxrwxrwx
login.php_1	3.25 KB	-rwxrwxrwx
login20012017.php	5.54 KB	-rwxrwxrwx
login27062012.php	2.85 KB	-rwxrwxrwx
login_03032015.php	3.6 KB	-rwxrwxrwx
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxrwxrwx
login_old.php	3.15 KB	-rwxrwxrwx
markEntry-Setup2.php	21.93 KB	-rwxrwxrwx
message_board.php	4.67 KB	-rwxrwxrwx
module_setup.php	2.48 KB	-rwxrwxrwx
mregistry.php	89.5 KB	-rwxrwxrwx
mregistry02012017.php	59.71 KB	-rwxrwxrwx
mregistry24042015.php	55.01 KB	-rwxrwxrwx
mregistry_before_subupdtostud_...	52.68 KB	-rwxrwxrwx
mregistry_beforedownload.php	53.04 KB	-rwxrwxrwx
mregistry_old.php	66.7 KB	-rwxrwxrwx
mrn_approval.php	9 KB	-rwxrwxrwx
receive_rv_rt_application.php	7.65 KB	-rwxrwxrwx
report_setup.php	25.12 KB	-rwxrwxrwx
report_tool.php	73.03 KB	-rwxrwxrwx
revaluation.php	16.66 KB	-rwxrwxrwx
revaluation_oldtype.php	8.45 KB	-rwxrwxrwx
revaluation_withdegree.php	16.77 KB	-rwxrwxrwx
room_allotment.php	7.21 KB	-rwxrwxrwx
sendLoginPassword.php	3.09 KB	-rwxrwxrwx
serchbygrid.php	822 B	-rwxrwxrwx
student_entry.php	47.97 KB	-rwxrwxrwx
student_entry1307.php	37.71 KB	-rwxrwxrwx
student_entry27062012.php	30.47 KB	-rwxrwxrwx
student_entryold.php	30.33 KB	-rwxrwxrwx
subjectList_display.php	11.01 KB	-rwxrwxrwx
subject_freshExam.php	18.92 KB	-rwxrwxrwx
subjectfreez.php	12.98 KB	-rwxrwxrwx
system_utility.php	1.84 KB	-rwxrwxrwx
systemsetup.php	75.5 KB	-rwxrwxrwx
teachers.php	10.33 KB	-rwxrwxrwx
transaction-series.php	4.86 KB	-rwxrwxrwx
updateSection.php	3.86 KB	-rwxrwxrwx
update_defined_flag.php	3.41 KB	-rwxrwxrwx
upload_studentPhoto.php	10.12 KB	-rwxrwxrwx
upload_studentPhoto02062015.ph...	11.58 KB	-rwxrwxrwx
upload_studentPhoto_before_dow...	8.02 KB	-rwxrwxrwx
uploadmoduledetails.php	39.65 KB	-rwxrwxrwx
usersetup.php	24.14 KB	-rwxrwxrwx
usersubj_identification.php	4.77 KB	-rwxrwxrwx
usersubj_identification_old.ph...	4.54 KB	-rwxrwxrwx

Code Editor : ack_exam_app_form_07032014.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->collcode=$_SESSION['collcode'];	
		$this->log_name = $_SESSION['usr'];			
		}
		 
		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}'
								where APPNO='{$apk}'
								and FCOLLCODE='{$this->collcode}'
								";
					$lobj_get_data = $this->aobj_context->mobj_db->Execute($update);
					$this->UpdateCandSumCandDet($apk);					
				}
				$data="Application(s) acknowledged successfully.";
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 		
 		}	
		function UpdateCandSumCandDet($apk)
		{
			$update_cand_sum="UPDATE appcandsum a,candsum c
								SET 
								c.FEXAMFEEA=a.FEXAMFEEA,
								c.FEXAMFEEB=a.FEXAMFEEB,
								c.FEXAMFEEC=a.FEXAMFEEC,
								c.FEXAMFEED=a.FEXAMFEED,
								c.FEXAMFEEE=a.FEXAMFEEE,
								c.FEXAMFEEF=a.FEXAMFEEF,
								c.FEXAMFEEG=a.FEXAMFEEG,
								c.FEXAMFEEH=a.FEXAMFEEH,
								c.FEXAMFEEI=a.FEXAMFEEI,
								c.FEXAMFEEJ=a.FEXAMFEEJ,
								c.FTOTALFEE=a.FTOTALFEE,
								c.frecptdate = date(a.FACKDATE)
								WHERE a.fregno=c.FREGNO
								AND a.APPNO='{$apk}' and a.FCOLLCODE='{$this->collcode}'";
			$lobj_update_cand_sum = $this->aobj_context->mobj_db->Execute($update_cand_sum);
		 
			$get_app_cand_det="SELECT FDEGREE,FEXAMNO,FCOLLCODE,FREGNO,FSUBCODE,FINSERTED,FPRESENT,FYEAR,FEXAMTYPE
								FROM appcanddet
								WHERE APPNO='{$apk}'";	
			$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}'
								";
						$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 = ($this->aobj_context->mobj_data["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"]);
				  $get_data="   SELECT DISTINCT r.APPNO,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}' AND (FACKDATE IS NULL OR FACKDATE='')
						  AND LPAD(r.APPNO,10,'0')>='{$app_no_from}'   AND LPAD(r.APPNO,10,'0')<='{$app_no_to}' ";	
											
					$lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data);
 		$str_reval.="<br>";
		$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='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>";
	 
			$k=0;
			$sl_no=1;
			foreach($lobj_get_data as $ak=>$av)
			{
				$APPNO=$av['APPNO'];
				$FREGNO=$av['FREGNO'];
				$FAPPDATE=$av['FAPPDATE'];
				$FNAME=$av['FNAME'];
				$FDEGREE=$av['FDEGREE'];
				$FAMOUNT=$av['FTOTALFEE'];
				 
				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:center; ' >{$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;
		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_07032014.php