Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Report	[ DIR ]	drwxr-xr-x
base_file	[ DIR ]	drwxr-xr-x
events	[ DIR ]	drwxr-xr-x
popups	[ DIR ]	drwxr-xr-x
AbsentEntrySubjectWise.js	14.12 KB	-rwxr-xr-x
AbsentEntrySubjectWise_old.js	13.91 KB	-rwxr-xr-x
AllkeyEvent.js	33.05 KB	-rwxr-xr-x
Dispatch_answer_script.js	17.91 KB	-rwxr-xr-x
Dispatch_answer_script_qp.js	16.33 KB	-rwxr-xr-x
IdentifyTransactions.js	2.13 KB	-rwxr-xr-x
MainPage.js	13.73 KB	-rwxr-xr-x
MainPage1.js	13.52 KB	-rwxr-xr-x
Message_board.js	5.02 KB	-rwxr-xr-x
SubjectDetailsPopup.js	11.53 KB	-rwxr-xr-x
absententrysubjectwiseQP.js	16.33 KB	-rwxr-xr-x
ack_exam_app_form.js	2.52 KB	-rwxr-xr-x
ack_exam_app_form.php	12.07 KB	-rwxr-xr-x
ack_exam_app_form_bulk.js	2.06 KB	-rwxr-xr-x
ack_rv_rt_application.js	2.11 KB	-rwxr-xr-x
ack_rv_rt_application01032017....	1.89 KB	-rwxr-xr-x
admission_entry_status.js	1.06 KB	-rwxr-xr-x
attendance.js	4.52 KB	-rwxr-xr-x
backup_restore.js	1.36 KB	-rwxr-xr-x
bundle_dispatch.js	7.82 KB	-rwxr-xr-x
calendar-en.js	3.52 KB	-rwxr-xr-x
calendar-setup.js	8.65 KB	-rwxr-xr-x
calendar.js	48.08 KB	-rwxr-xr-x
calender.js	903 B	-rwxr-xr-x
candidate_list.js	25.96 KB	-rwxr-xr-x
candidate_list.js0104	19.41 KB	-rwxr-xr-x
candidate_list.jsMOHAN	19.42 KB	-rwxr-xr-x
candidate_list1.js	25.96 KB	-rwxr-xr-x
challan_entries.js	3.92 KB	-rwxr-xr-x
challan_preparation.js	2.77 KB	-rwxr-xr-x
checkbrowser.js	2.46 KB	-rwxr-xr-x
college.js	4.56 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.js	2.33 KB	-rwxr-xr-x
college_degree_status.js	3.29 KB	-rwxr-xr-x
collegewisedownload.js	1.26 KB	-rw-rw-r--
collinfo_popup.js	11.62 KB	-rwxr-xr-x
daterange.js	6.05 KB	-rwxr-xr-x
degree.js	2.86 KB	-rwxr-xr-x
degree1.js	2.86 KB	-rwxr-xr-x
downloadStudentPhotos.js	1.7 KB	-rwxr-xr-x
download_misc_files.js	817 B	-rwxr-xr-x
downloadmclist.js	1.09 KB	-rw-r--r--
entryexitevents.js	1.23 KB	-rwxr-xr-x
examAppchallan_entries.js	4.02 KB	-rwxr-xr-x
examAppchallan_entries.php	13.01 KB	-rwxr-xr-x
examAppchallan_preparation.js	2.86 KB	-rwxr-xr-x
examAppchallan_preparation.php	9.87 KB	-rwxr-xr-x
export_import.js	1.83 KB	-rwxr-xr-x
export_import_setup.js	5.47 KB	-rwxr-xr-x
ext_freeze_module_at_admin_col...	5.91 KB	-rwxr-xr-x
ext_markentry_subjectwise.js	15.43 KB	-rwxr-xr-x
feeupdation.js	5.26 KB	-rwxr-xr-x
footer.js	6.32 KB	-rwxr-xr-x
form_submit.js	1.3 KB	-rwxr-xr-x
formatdate.js	12.14 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.js	2.83 KB	-rwxr-xr-x
freeze_module_at_admin_college...	6.83 KB	-rwxr-xr-x
freeze_module_at_university_co...	4.55 KB	-rwxr-xr-x
grid_display.js	901 B	-rwxr-xr-x
import_marks.js	1.37 KB	-rwxr-xr-x
includeCSS.js	1.28 KB	-rwxr-xr-x
index.js	14.64 KB	-rwxr-xr-x
index1.js	14.55 KB	-rwxr-xr-x
index_BEFORE_LOGINPOPUP.js	4.88 KB	-rwxr-xr-x
jquery.color.js	3.57 KB	-rwxr-xr-x
jquery.js	29.15 KB	-rwxr-xr-x
load-report-js-files.js	8.68 KB	-rwxr-xr-x
load-report-js-files_16012017....	6.25 KB	-rwxr-xr-x
load_js_files.js	622 B	-rwxr-xr-x
load_mannual_js_files.js	25.19 KB	-rwxr-xr-x
load_mannual_js_files24042015....	12.28 KB	-rwxr-xr-x
load_mannual_js_files_before_u...	11.57 KB	-rwxr-xr-x
markentry_studentwise.js	9.32 KB	-rwxr-xr-x
markentry_subjectwise.js	14.56 KB	-rwxr-xr-x
markentry_subjectwise2.js	16.98 KB	-rwxr-xr-x
module_setup.js	4.44 KB	-rwxr-xr-x
month_cal.js	63.03 KB	-rwxr-xr-x
month_cal1.js	1.96 KB	-rwxr-xr-x
mregistry.php	57.29 KB	-rwxr-xr-x
openPopUp.js	4.94 KB	-rwxr-xr-x
popup.js	118.93 KB	-rwxr-xr-x
popupold.js	57.4 KB	-rwxr-xr-x
receive_rv_rt_application.js	1.92 KB	-rwxr-xr-x
report_SubjectListGeneral.js	3.26 KB	-rwxr-xr-x
report_setup.js	12.46 KB	-rwxr-xr-x
revaluation.js	7.56 KB	-rwxr-xr-x
revaluation_oldtype.js	4.65 KB	-rwxr-xr-x
revaluation_withdegree.js	7.5 KB	-rwxr-xr-x
room_allotment.js	2.94 KB	-rwxr-xr-x
rv_rt_guide_lines.js	428 B	-rwxr-xr-x
rvdates.js	8.08 KB	-rwxr-xr-x
student_entry.js	52.12 KB	-rwxr-xr-x
student_entry_09102019.js	51.4 KB	-rwxr-xr-x
student_entryold.js	33.98 KB	-rwxr-xr-x
studentphotolist.js	1.69 KB	-rw-rw-r--
subjectAppearing_PopUp.js	1.92 KB	-rwxr-xr-x
subject_freshExam.js	12.57 KB	-rwxr-xr-x
subjectfreez.js	3.79 KB	-rwxr-xr-x
system.js	12.41 KB	-rwxr-xr-x
system_utility.js	8.69 KB	-rwxr-xr-x
teachers.js	13.71 KB	-rwxr-xr-x
transaction-series.js	6.5 KB	-rwxr-xr-x
updateSection.js	2.39 KB	-rwxr-xr-x
updatefreshexam.js	1.52 KB	-rw-rw-r--
uploadStudentPhotos.js	3.84 KB	-rwxr-xr-x
uploadStudentPhotos02062015.js	4.4 KB	-rwxr-xr-x
uploadStudentPhotos_beforedown...	3.52 KB	-rwxr-xr-x
upload_details.js	4.03 KB	-rwxr-xr-x
usersetup.js	29.92 KB	-rwxr-xr-x
usersubj_identification.js	4.06 KB	-rwxr-xr-x
validate.js	9.1 KB	-rwxr-xr-x

Code Editor : examAppchallan_preparation.php

<?php
class ExamAppChallenPreparation
{
    
		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 GetNextNumber()
		{
		
				$get_prefix_running_number = "select last_number from res_reval_code_generator
								where college_code = '{$this->college_code}' and type='College' ";		
				$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,5, "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},'College'
								)";
					$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='College' ";
		$lobj_update_code_generator = $this->aobj_context->mobj_db->Execute($update_code_generator);
		}	
		
		function PrepareChallanDetailsForExApp()
		{
			  
			 	$checked_app_nos = ($this->aobj_context->mobj_data["checked_app_nos"]);
				$FDOCNO=$this->GetNextNumber($this->aobj_context);
				$exp_arr=explode(",",$checked_app_nos);
				$no_of_app=count($exp_arr);
				$total_amt=0;
				foreach($exp_arr as $apk)
				{
					$update=" update appcandsum 
								set FDOCNO='{$FDOCNO}',FDOCDATE=now()
								where APPNO='{$apk}'";
					$lobj_get_data = $this->aobj_context->mobj_db->Execute($update);
					$select="select FTOTALFEE as  FAMOUNT from appcandsum where APPNO='{$apk}' ";	
					$lobj_select = $this->aobj_context->mobj_db->GetRow($select);
					$total_amt+=$lobj_select['FAMOUNT'];
				}
			$this->UpdateNextNumber($this->aobj_context);
				$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>";		
				$str_reval.="<td class='tbl_row1' style='text-align:left; border-left:1px solid #C5DBEC;border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >Document No</td>";
				$str_reval.="<td class='tbl_row1' style='border-left:0px solid #C5DBEC; ;border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:11px;text-align:left; ' ><b>&nbsp;{$FDOCNO}</b></td>";
				$str_reval.="</tr>";
				$str_reval.="<tr>";		
				$str_reval.="<td class='tbl_row_alter' style='text-align:left; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >Total Amount</td>";
				$str_reval.="<td class='tbl_row_alter' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:11px;text-align:left; ' ><b>&nbsp;{$total_amt}</b></td>";
				$str_reval.="</tr>";	
				$str_reval.="<tr>";		
				$str_reval.="<td class='tbl_row1' style='text-align:left; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >No Of Applications</td>";
				$str_reval.="<td class='tbl_row1' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:11px;text-align:left; ' ><b>&nbsp;{$no_of_app}</b></td>";
				$str_reval.="</tr>";	
				$str_reval.="</table>";	
				$str_reval.="<span style='color:red;'>Note:   Report is valid only on updating the challan paid amount against document number.</span> ";	
				$str_reval.='<br><div style="width:42px; margin: 0 auto;  ;float: none;" class="raval_submit">
								<span style="margin-top: 2px;float:left;margin-left:8px;cursor: pointer; color:#545345;line-height: 19px;font-size:14px;font-weight:bold;" onclick="CloseChallanDialog();">Ok</span>
								</div><br> ';	
				$arr['html']=$str_reval;
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 		
 		}
		
		function DisplayExamAppChallanPreparationDetails()
		{
			  
			  
			 	$up_to = ($aobj_context->mobj_data["up_to"]);
				$cond="";
				if($up_to!="0000-00-00")
				$cond=" and r.FACKDATE>='{$up_to}'";
				$get_data="  SELECT  r.APPNO,DATE_FORMAT(r.FDATE,'%d/%m/%Y') AS FAPPDATE,r.FREGNO,
						s.FNAME,r.FDEGREE,FTOTALFEE as FAMOUNT,
						DATE_FORMAT(r.FACKDATE,'%d/%m/%Y') AS FACKDATE
						FROM appcandsum r INNER JOIN student s ON s.FREGNO=r.FREGNO 
						WHERE r.FCOLLCODE='{$this->collcode}' and  FACKDATE IS NOT NULL and FACKDATE!='' 
						{$cond} and ifnull(FDOCNO,'')=''
						group by r.APPNO
						  ";	
											
					$lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data);
 			
		$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-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;'>Applied Date </td>";
		$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Reg No</td>";
		$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Student Name</td>";
		$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Degree</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;'> Acknowledged Date</td>";
		$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;  cursor:pointer;' onclick='SelectAllExamAppChallanPreparationCheckBox();' > Select All</td>";
		//$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Delete</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'];
				$FACKDATE=$av['FACKDATE'];
				$FAMOUNT=$av['FAMOUNT'];
				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-right:1px solid #C5DBEC; padding:2px;' >{$sl_no}</td>";
				$str_reval.="<td class='{$class}' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:11px;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;  ;text-align:center;  ' >{$FAPPDATE}&nbsp;</td>";
				$str_reval.="<td class='{$class}' style='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='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='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='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}' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ;  ;text-align:center; ' >{$FACKDATE}</td>";
				$str_reval.="<td class='{$class}' align='center' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ;font-weight:bold;text-align:center;' ><input type='checkbox' id='ack_check_box_{$APPNO}' /></td>"; 
				//$str_reval.="<td class='{$class}' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;text-align:center; cursor:pointer; ' ><img onclick='DeleteAckowledgedApplications({$APPNO});' src='img/delete1.PNG' title='Delete Re-totaling College Acknowledged Application'  /></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 DisplayExamAppChallanPreparationDetails($aobj_context)
{
    $class_obj=new ExamAppChallenPreparation($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$class_obj->DisplayExamAppChallanPreparationDetails();
} function PrepareChallanDetailsForExApp($aobj_context)
{
    $class_obj=new ExamAppChallenPreparation($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$class_obj->PrepareChallanDetailsForExApp();
}  function DeleteAckowledgedApplications($aobj_context)
{
    $class_obj=new ExamAppChallenPreparation($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$class_obj->DeleteAckowledgedApplications();
}

${this.title}

Code Editor : examAppchallan_preparation.php