Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
output	[ DIR ]	drwxr-xr-x
DownloadExamAppFormApplication...	8.42 KB	-rwxr-xr-x
DownloadExamAppFormApplication...	5.72 KB	-rwxr-xr-x
DownloadRvRtAckApplications.ph...	5.26 KB	-rwxr-xr-x
ExcelWriterXML.php	16.29 KB	-rwxr-xr-x
ExcelWriterXML_Sheet.php	15.83 KB	-rwxr-xr-x
ExcelWriterXML_Style.php	23.71 KB	-rwxr-xr-x
HT_017_BA160105.pdf	40.2 KB	-rwxr-xr-x
PrintApplicationFormAdmPOSTOFF...	12.64 KB	-rwxr-xr-x
PrintChallanEntryDetails.php	8.36 KB	-rwxr-xr-x
RvRtApplicationReport.php	8.76 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	11.63 KB	-rwxr-xr-x
admChallanEntryDetails.php	7.01 KB	-rwxr-xr-x
adm_comb_details.php	6.18 KB	-rwxr-xr-x
admregisterlist.php	15.56 KB	-rwxr-xr-x
admreportlist.php	14.87 KB	-rwxr-xr-x
answer_book_statistics.php	6.79 KB	-rwxr-xr-x
appear_list_center_qp_wise.php	7.33 KB	-rwxr-xr-x
appear_list_qp_wise.php	5.67 KB	-rwxr-xr-x
appfeedetails.php	8.73 KB	-rwxr-xr-x
appfeedetails25022017.php	6.46 KB	-rwxr-xr-x
appfeedetails_pdf.php	7.48 KB	-rwxr-xr-x
appfeedetailspdf.php	7.58 KB	-rwxr-xr-x
basic_data_coll.php	6.74 KB	-rwxr-xr-x
basic_data_sum.php	6.96 KB	-rwxr-xr-x
batch_wise_details.php	4.45 KB	-rwxr-xr-x
bundle_ despatch_ statement.ph...	5.78 KB	-rwxr-xr-x
bundleno_despatch_statement.ph...	11.47 KB	-rwxr-xr-x
cManualMailer.php	1.45 KB	-rwxr-xr-x
cappcontext.php	2.64 KB	-rwxr-xr-x
cconfig.php	1.14 KB	-rwxr-xr-x
cntDeclaration.php	13.81 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
college_degree_details.php	4.57 KB	-rwxr-xr-x
college_pending_markslist.php	6.74 KB	-rwxr-xr-x
fee_report_catwise.php	13.17 KB	-rwxr-xr-x
fee_summary.php	13.15 KB	-rwxr-xr-x
fee_summary_oldformat.php	7.47 KB	-rwxr-xr-x
fee_summary_report.php	34.29 KB	-rwxr-xr-x
fee_summary_report_old.php	33.75 KB	-rwxr-xr-x
generatePostAdmissionTicket.ph...	27.91 KB	-rwxr-xr-x
generatePostAdmissionTicket_17...	26.16 KB	-rwxr-xr-x
getnumword.php	7.43 KB	-rwxr-xr-x
hallticketcomm.php	29.47 KB	-rwxr-xr-x
htstatus.php	6.73 KB	-rwxr-xr-x
iaemptyformat.php	7.1 KB	-rwxr-xr-x
index.php	4.54 KB	-rwxr-xr-x
marklist_studentwise.html	4.29 KB	-rwxr-xr-x
marls_subjectwise.php	10.22 KB	-rwxr-xr-x
mregistry.php	73.95 KB	-rwxr-xr-x
photo_report.php	4.49 KB	-rwxr-xr-x
practical_marks_details.php	12.17 KB	-rwxr-xr-x
practical_marks_report.php	5.45 KB	-rwxr-xr-x
reconciliation.php	9.35 KB	-rwxr-xr-x
reg_stud_list.php	8.34 KB	-rwxr-xr-x
report_ack_registration.php	6.4 KB	-rwxr-xr-x
report_adm_combination.php	10.15 KB	-rwxr-xr-x
report_adm_summary.php	8.45 KB	-rwxr-xr-x
report_admission_details.php	26.8 KB	-rwxr-xr-x
report_admission_list.php	10.69 KB	-rwxr-xr-x
report_admission_list_wop.php	10.31 KB	-rwxr-xr-x
report_admission_listnehu.php	24.67 KB	-rwxr-xr-x
report_admission_ticket.php	28.05 KB	-rwxr-xr-x
report_admission_ticket0802201...	36.96 KB	-rwxr-xr-x
report_admission_ticket0811201...	47.36 KB	-rwxr-xr-x
report_admission_ticket1111201...	40.47 KB	-rwxr-xr-x
report_admission_ticket1711201...	42.51 KB	-rwxr-xr-x
report_admission_ticket_171220...	26.2 KB	-rwxr-xr-x
report_admission_ticket_201804...	27.76 KB	-rwxr-xr-x
report_admission_ticket_291120...	43.27 KB	-rwxr-xr-x
report_admission_ticket_before...	13.33 KB	-rwxr-xr-x
report_admission_ticket_kus (2...	36.42 KB	-rwxr-xr-x
report_admission_ticket_kus.ph...	16.15 KB	-rwxr-xr-x
report_admission_ticket_new.ph...	36.09 KB	-rwxr-xr-x
report_admission_ticket_nitte....	26.22 KB	-rwxr-xr-x
report_admission_ticket_old_04...	27.4 KB	-rwxr-xr-x
report_admission_ticketcopy.ph...	32.41 KB	-rwxr-xr-x
report_admission_ticketkswu.ph...	15.07 KB	-rwxr-xr-x
report_admission_ticketold.php	30.03 KB	-rwxr-xr-x
report_admission_ticketold0911...	34.52 KB	-rwxr-xr-x
report_admission_ticketoldform...	30.91 KB	-rwxr-xr-x
report_answer_book_issued.php	8.41 KB	-rwxr-xr-x
report_attendance_sheet.php	12.75 KB	-rwxr-xr-x
report_attendance_shortage.php	9.23 KB	-rwxr-xr-x
report_attendance_shortage_271...	8.99 KB	-rwxr-xr-x
report_attendance_summary.php	7.17 KB	-rwxr-xr-x
report_attendance_summary_back...	7.15 KB	-rwxr-xr-x
report_bacth_preparation_dairy...	7.05 KB	-rwxr-xr-x
report_batch_practical_dairy.p...	15.32 KB	-rwxr-xr-x
report_batch_wise_details.php	7.93 KB	-rwxr-xr-x
report_batch_worksheet_details...	11.18 KB	-rwxr-xr-x
report_bulk_applications.php	20.7 KB	-rwxr-xr-x
report_bundle_dispatch.php	9.77 KB	-rwxr-xr-x
report_bundle_dispatch_kusdde....	9.73 KB	-rwxr-xr-x
report_bundle_dispatch_wait.ph...	9.14 KB	-rwxr-xr-x
report_candidate_list.php	29.81 KB	-rwxr-xr-x
report_candidate_list28102017....	29.46 KB	-rwxr-xr-x
report_candidate_list_backup.p...	29.47 KB	-rwxr-xr-x
report_candidate_list_before_f...	25.19 KB	-rwxr-xr-x
report_candidate_list_before_s...	19.8 KB	-rwxr-xr-x
report_candidate_list_loc.php	25.06 KB	-rwxr-xr-x
report_candidate_list_old.php	25.9 KB	-rwxr-xr-x
report_daliy_report.php	10.88 KB	-rwxr-xr-x
report_daliy_report_qp - Copy....	14.31 KB	-rwxr-xr-x
report_daliy_report_qp.php	10.35 KB	-rwxr-xr-x
report_daliy_report_qp_2504201...	12.17 KB	-rwxr-xr-x
report_daliy_report_qp_new.php	9.93 KB	-rwxr-xr-x
report_daliy_report_qp_old_for...	10.13 KB	-rwxr-xr-x
report_daliy_report_qp_wait.ph...	9.9 KB	-rwxr-xr-x
report_data_sent.php	8.41 KB	-rwxr-xr-x
report_degree_list.php	4.71 KB	-rwxr-xr-x
report_deviation_report.php	7.67 KB	-rwxr-xr-x
report_evaluation_report.php	9.31 KB	-rwxr-xr-x
report_iamarks_pending.php	8.19 KB	-rwxr-xr-x
report_iamarks_pending_2112201...	6.58 KB	-rwxr-xr-x
report_marks_deviation_report....	5.38 KB	-rwxr-xr-x
report_marks_elementwise.php	4.35 KB	-rwxr-xr-x
report_marks_elementwisenew.ph...	4.67 KB	-rwxr-xr-x
report_marks_entry_student_lis...	5.6 KB	-rwxr-xr-x
report_marks_entry_subjectwise...	10.99 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	13.53 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.13 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	9.16 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.05 KB	-rwxr-xr-x
report_marks_pending.php	12.02 KB	-rwxr-xr-x
report_online_eam.php	11.63 KB	-rwxr-xr-x
report_pr_pending.php	7.48 KB	-rwxr-xr-x
report_practical_marks_details...	13.45 KB	-rwxr-xr-x
report_practical_marks_details...	14.73 KB	-rwxr-xr-x
report_practical_misc.php	8.24 KB	-rwxr-xr-x
report_qpcount_univ.php	5.93 KB	-rwxr-xr-x
report_ra_exl_report.php	5.61 KB	-rwxr-xr-x
report_ra_exl_report_wait.php	5.79 KB	-rwxr-xr-x
report_ra_invigilator_dairy.ph...	20.93 KB	-rwxr-xr-x
report_ra_invigilator_dairy_10...	16.74 KB	-rwxr-xr-x
report_ra_invigilator_dairy_21...	15.12 KB	-rwxr-xr-x
report_ra_invigilators_dairy.p...	14.9 KB	-rwxr-xr-x
report_ra_invigilators_dairy24...	8.83 KB	-rwxr-xr-x
report_ra_invigilators_dairy28...	11.95 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	7.91 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	10.44 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	7.57 KB	-rwxr-xr-x
report_revaluation.php	6.42 KB	-rwxr-xr-x
report_sectionwiselist.php	4.61 KB	-rwxr-xr-x
report_subject_admcl_list.php	3.48 KB	-rwxr-xr-x
report_subject_general_list.ph...	4.13 KB	-rwxr-xr-x
reportexamcntrdet.php	5.24 KB	-rwxr-xr-x
resport_attendance_studentwise...	5.96 KB	-rwxr-xr-x
results_pdf.php	19.31 KB	-rwxr-xr-x
resultsheet.php	9.13 KB	-rwxr-xr-x
revaluation.php	15.65 KB	-rwxr-xr-x
roomallotmantecelsheet.php	5.41 KB	-rwxr-xr-x
roomallotmantsummary.php	4.69 KB	-rwxr-xr-x
roomwise_register_nos_list.php	18.49 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
s	32.36 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
student.php	5.36 KB	-rwxr-xr-x
student_count.php	4.05 KB	-rwxr-xr-x
subiapending.php	8.14 KB	-rwxr-xr-x
subject_wise_student_list.php	6.22 KB	-rwxr-xr-x
subjectwise_invigilator_dairy....	10.29 KB	-rwxr-xr-x
tatkal.php	4.8 KB	-rwxr-xr-x
teacher_report.php	10.83 KB	-rwxr-xr-x
testbarcode.php	19.88 KB	-rwxr-xr-x
topsheet.php	8.41 KB	-rwxr-xr-x

Code Editor : revaluation.php

<?php
class results
	{ 
    public $drop_down_arr;
	function __construct($aobj_context)
	  {
		session_start();
		$this->aobj_context=$aobj_context;
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);	
	  }
	  function DisplayRevalutionDetails($aobj_context)
	  { 
	
		$revalution_regno=($this->aobj_context->mobj_data["r"]);
		$revalution_exam=trim($this->aobj_context->mobj_data['e']);
					$get_data="select   date_format(current_date(),'%d/%m/%Y') as curr_date, 
									rf.FDEGREE,concat(s.FSUBCODE,'',s.FSSUBCODE) as  FSUBCODE,
									concat(s.FSUBNAME ,' ',s.FSSUBNAME) as FSUBNAME,
								 st.FNAME ,
								 IFNULL(FRVFEE,0) as FRVFEE,
								 IFNULL(FRTFEE,0) as FRTFEE,
								 IFNULL(FXRFEE,0) as FXRFEE,	
								 IFNULL(FCVFEE,0) as FCVFEE,	
								 IF(CURRENT_DATE()<=IFNULL(FRVLASTDATE,'0000-00-00'),'1',0) AS is_rv,
								IF(IFNULL(CURRENT_DATE()<=FRTLASTDATE,'0000-00-00'),'1',0) AS is_rt,
								IF(IFNULL(CURRENT_DATE()<=FXEROXLASTDATE,'0000-00-00'),'1',0) AS is_xr,
								IF(IFNULL(CURRENT_DATE()<=FCVLASTDATE,'0000-00-00'),'1',0) AS is_cv 
							from resmarks rm
							inner join subject s on s.FDEGREE=rm.FDEGREE
							and s.FSUBCODE=rm.FSUBCODE 
							and s.FEXAMNO=rm.FEXAMNO 
							and  s.FDEGREE=rm.FDEGREE 
							inner join student st  on st.FREGNO=rm.FREGNO
							inner join res_fee rf 
							on rf.FDEGREE=s.FDEGREE
							and rf.FREGNO=rm.FREGNO
							and rf.FEXAMNO=rm.FEXAMNO 
							where  rm.FREGNO = '{$revalution_regno}' 
							and rm.fexamno = '{$revalution_exam}'
							and s.FTHEORY='T'
							and s.FINTASS <> 'T'
							group by FCSUBCODE";
				$lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data);
				 
				$is_rv =$lobj_get_data[0]['is_rv'];
				$is_rt =$lobj_get_data[0]['is_rt'];
				$is_xr =$lobj_get_data[0]['is_xr'];
				$is_cv =$lobj_get_data[0]['is_cv'];
				$FRVFEE =$lobj_get_data[0][FRVFEE];
				$FRTFEE =$lobj_get_data[0][FRTFEE];
				$FXRFEE =$lobj_get_data[0][FXRFEE];
				$FCVFEE =$lobj_get_data[0][FCVFEE];
				
				$reval_arr["rv"]['ele']=$is_rv;
				$reval_arr["rv"]['fee']=$FRVFEE;
				$reval_arr["rv"]['H']="RV";
				
				$reval_arr["rt"]['ele']=$is_rt;
				$reval_arr["rt"]['fee']=$FRTFEE;
				$reval_arr["rt"]['H']="RT";
				
				$reval_arr["xr"]['ele']=$is_xr;
				$reval_arr["xr"]['fee']=$FXRFEE;
				$reval_arr["xr"]['H']="PC";
				
				$reval_arr["cv"]['ele']=$is_cv;
				$reval_arr["cv"]['fee']=$FCVFEE;
				$reval_arr["cv"]['H']="Challnge Val";
			 
				//$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.="<th align='left' colspan='8'  style='font-size:12px;background:#F0CC04; padding-left:6px; height:24px;'>Revaluation</th>";
				$str_reval.="<tr class='tr_bg1'>";
				$str_reval.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;width:6%;'>Sl No</td>";
				$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;width:10%;'>Sub. Code</td>";
				$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>";
				$tot_col=0;
				foreach($reval_arr as $ak=>$av)
				{
					if($av['ele']=='1')
					{
					$name=$av['H'];
					$tot_col++;
					$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>{$name}</td>";
					}
				}
				$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> Total</td>";
				$str_reval.="</tr>";
				$sl_no=1;
				$total_val=0;
				//echo $get_data; 
				$name=$lobj_get_data[0][FNAME];
				$curr_date=$lobj_get_data[0][curr_date];
				$k=1;
				$internal_code=1;
					foreach($lobj_get_data as $k=>$val)	 
					{
					   //print_r($lobj_get_data); die();	
						if($k%2==0)
						$class='tbl_row1';
						else
						$class='tbl_row_alter1';
						$is_selected_checked='';
						$FSUBCODE =$val[FSUBCODE];
					 
						$FSUBNAME =$val[FSUBNAME];
					 
					 
						$str_reval.="<tr>";		
						$str_reval.="<td class='{$class}' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC;   font-size:12px;  ' id=fsl_{$internal_code}>{$sl_no}</td>";
						$str_reval.="<td class='{$class}' style='text-align:center;border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  font-size:12px;   ' id=fccode_{$internal_code}>{$FSUBCODE}</td>";
						$str_reval.="<td class='{$class}' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;   font-size:12px;  ' id=fsname_{$internal_code}>{$FSUBNAME}</td>";
						foreach($reval_arr as $ak=>$av)
						{
								if($av['ele']=='1')
								{
								$name=$av['H'];
								$fee=$av['fee'];
	 							$str_reval.="<td class='{$class}' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  font-size:12px;' >";
								$str_reval.="<input id='{$ak}_{$internal_code}' onclick='CalculateRevaluationTotFee();'   type='checkbox' style='width: 20px;'><span style='font-weight:bold;' id='fee_{$ak}_{$internal_code}'>({$fee})</span></td>";
								}
						}
					 
						$str_reval.="<td class='{$class}' align='right' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  font-size:12px;font-weight:bold;text-align:center;'  id=total_{$internal_code}>0</td>";
						$str_reval.="</tr>";
						$sl_no++;$internal_code++;
					 }
					 $tot_col_span=$tot_col+3;
					$str_reval.="<tr><td class='{$class}' style='border-left:1px solid #C5DBEC;color:#14466B;text-align:right;height:15px' colspan={$tot_col_span}>Grand Total</td><td class='{$class}'   style='text-align:center;border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC;  font-size:14px;font-weight:bold;color:green;' id=grand_total>0.00</td></tr>";	
					$str_reval.="</table>";
					$str_reval.='<div class="raval_submit">
								<span  onclick="SaveRevaluation();" style="float:left;margin-left:8px;cursor: pointer; line-height: 19px;font-size:14px;font-weight:bold;">Submit</span>
								</div>';
					$str_reval.='<div class="raval_submit" >
							<span  onclick="DisplayRevalutionDetails();" style="float:left;margin-left:8px;cursor: pointer; line-height: 19px;font-size:14px;font-weight:bold;">Cancel</span>
							</div>';
					$arr['reval_html']=$str_reval;

$str_reval1.="</table>";
		
			if(!empty($lobj_get_data))
			{
			$arr['reval_html']="<div id='reval_details'>{$str_reval}</div>";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 		
			}
			else
			{
			$data="You Cannot Enter the Revaluation Details";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"success"); 
			}			 	
		}
		function GetNextNumber()
		{
		
				$get_prefix_running_number = "select last_number from res_reval_code_generator
								where college_code = '{$this->college_code}' and type='Student' ";		
				$lobj_get_prefix_running_number = $this->aobj_context->mobj_db->GetRow($get_prefix_running_number); 
		
				if(!empty($lobj_get_prefix_running_number[last_number]))
				{			
				$next_number = $lobj_get_prefix_running_number[last_number]+1;
				$last_number = str_pad($next_number,4, "0", STR_PAD_LEFT);
					
					 
				}
				else
				{	
					$next_number=0001;			
					$insert_into="insert into 
								res_reval_code_generator(college_code,last_number,type)
								values
								(
								'{$this->college_code}',
								{$next_number},'Student'
								)";
					$lobj_insert_into = $this->aobj_context->mobj_db->Execute($insert_into);
				 
				$last_number = str_pad($next_number,4, "0", STR_PAD_LEFT);		
				}
				return $this->college_code.$last_number;	
		}
		function UpdateNextNumber()
		{
				 				
				 
		$update_code_generator = "update res_reval_code_generator set last_number = last_number+1
									where college_code = '{$this->college_code}' and type='Student' ";
		$lobj_update_code_generator = $this->aobj_context->mobj_db->Execute($update_code_generator);
		}	
		
		function SaveRevalution()
		{
		 	include_once($this->aobj_context->main_src."src/json.php"); 
			$json = new Services_JSON();
			session_start();
			$grand_total=($this->aobj_context->mobj_data["grand_total"]);			 
			$reg_no=($this->aobj_context->mobj_data["reg_no"]);			 
			$lstr_param_reval = stripslashes($this->aobj_context->mobj_data["myJSONText"]);
			$mobj_json_reval_data = $json->decode($lstr_param_reval);
			$reval_arr_data = get_object_vars($mobj_json_reval_data);
			$int_codes_arr=array();
			$get_college_code="select  FDEGREE,FEXAMNO,FREGNO,FCOLLCODE,
							date_format(current_date,'%d/%m/%Y') as curr_date
								from res_fee
						where FREGNO='{$reg_no}' ";
			$lobj_get_college_code = $this->aobj_context->mobj_db->GetRow($get_college_code);	
			$this->college_code=$lobj_get_college_code['FCOLLCODE'];	
			$FDEGREE=$lobj_get_college_code['FDEGREE'];	
			$FEXAMNO=$lobj_get_college_code['FEXAMNO'];	
			$curr_date=$lobj_get_college_code['curr_date'];	
			$app_number=$this->GetNextNumber($this->aobj_context);
			 //echo "<pre>";
			 //print_r($reval_arr_data);die();
			foreach($reval_arr_data as $ak=>$av)
			{						
				$FSUBCODE=$av->fccode;
				foreach($av  as $akk=>$avv)
				{
				 if($akk=="row_total" || $akk=='fccode') continue;
					$insert="INSERT INTO  res_stud 
								( 
								APPNO, 	FAPPDATE, FDEGREE, 	FEXAMNO, 
								FCOLLCODE, 	FREGNO, FSUBCODE, FCORRTYPE, 
								FAMOUNT, FTOTAL,
								FLOGDATE
								)values
								('{$app_number}',current_date(),'{$FDEGREE}','{$FEXAMNO}',
								'{$this->college_code}','{$reg_no}','{$FSUBCODE}','{$akk}',
								'{$avv}',{$grand_total},current_date()
								)";
				 $lobj_insert = $this->aobj_context->mobj_db->Execute($insert);
				// echo "<pre>".$insert;die();
		 
			  }
					
				}
				 
			if($lobj_insert) 
				{
						$this->UpdateNextNumber($this->aobj_context);
						$html="<table border=0 align='center' style='width:100%;font-weight:bold;font-size:16px;line-height:22px;padding:6px;'>";
						$html.="<tr><td align='center' style='color:green;'>Registered Successfully</td></tr>";
						$html.="<tr><td align='center' style='color:green;'>&nbsp;</td></tr>";
						$html.="<tr><td align='center'  style='font-weight:normal;'>Your Application No. : <span style='font-weight:bold'>{$app_number}</span></td></tr>";
						$html.="<tr><td align='center' style='font-weight:normal;' >Date : <span style='font-weight:bold'>{$curr_date}</span></td></tr>";
						$html.="<tr><td align='center' style='color:green;'>&nbsp;</td></tr>";
						$html.="<tr><td align='center'  >Please take a printout and submit to college with documents</td></tr>";
						$html.="<tr><td >&nbsp;</td></tr>";
						$html.="<tr><td align='center'  > <div class='raval_submit' style='width:241px;float:none;' >
							<span  onclick='PrintRevaluationApplicationForm(\"{$app_number}\");' style='float:left;margin-left:8px;cursor: pointer; line-height: 19px;font-size:14px;font-weight:bold;'>Click here to take a PrintOut</span>
							</div></td></tr>";
					    echo $this->aobj_context->mobj_output->ToJSONEnvelope($html,0,"success"); 
						 return;
				}	
				else
				{
						$arr='Updation Failed';
						echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
					   return;
				}
		}
	function DisplayRevalutionApplications()
	{
		$reg_no=($this->aobj_context->mobj_data["r"]);	
		$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; 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;'>Application No</td>";
		$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Amount</td>";
		$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Applied Date</td>";
		$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Status</td>";
		$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> Print</td>";
		$str_reval.="</tr>";
		$get_data="select distinct  APPNO,FTOTAL,DATE_FORMAT(FAPPDATE,'%d/%m/%Y') as FAPPDATE,
						if(fackdate is null,'1',if(funivrecdate is null,'2','3')) as app_status
						from res_stud
						where FREGNO='{$reg_no}' ";
			$lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data);	
			$k=0;
			$sl_no=1;
			foreach($lobj_get_data as $ak=>$av)
			{
				$APPNO=$av['APPNO'];
				$FTOTAL=$av['FTOTAL'];
				$FAPPDATE=$av['FAPPDATE'];
				$app_status=$av['app_status'];
				if($k%2==0)
				$class='tbl_row1';
				else
				$class='tbl_row_alter1';
				$str_reval.="<tr>";		
				$str_reval.="<td class='{$class}' 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='{$class}' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center; ' >&nbsp;{$APPNO}</td>";
				$str_reval.="<td class='{$class}' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center;  ' >{$FTOTAL}&nbsp;</td>";
				$str_reval.="<td class='{$class}' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;text-align:center;  ' >&nbsp;{$FAPPDATE}</td>";
				if($app_status=='1')
				$str_reval.="<td class='{$class}' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;color:red; ;text-align:center; ' >Not Submitted in College</td>";
				if($app_status=='2')
				$str_reval.="<td class='{$class}' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;color:orange; ;text-align:center; ' >Submitted in College. Not Received at University</td>";
				if($app_status=='3')
				$str_reval.="<td class='{$class}' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;color:green; ;text-align:center; ' >Received at University</td>";
				
				$str_reval.="<td class='{$class}' align='center' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;font-weight:bold;text-align:center;' ><div class='raval_submit' style='width:59px; margin: 0 auto;' >
							<span  onclick=\"PrintRevaluationApplicationForm('{$APPNO}');\" style='float:left;margin-left:8px;cursor: pointer; line-height: 19px;font-size:14px;font-weight:bold;'>Print</span>
							</div></td>";
				$str_reval.="</tr>";
				$sl_no++;
				$k++;
			}			
		$str_reval.="</table>";
		$arr['html']=$str_reval;
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 			
			
	}
	 
} 
function DisplayRevalutionDetails($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$class_obj=new results($aobj_context);
$class_obj->DisplayRevalutionDetails();	 
} 
function SaveRevalution($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$class_obj=new results($aobj_context);
$class_obj->SaveRevalution();	 
} 
function DisplayRevalutionApplications($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$class_obj=new results($aobj_context);
$class_obj->DisplayRevalutionApplications();	 
} 
?>

${this.title}

Code Editor : revaluation.php