Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Thumbs.db	19 KB	-rwxr-xr-x
applicationFormReport.php	8.81 KB	-rwxr-xr-x
cappcontext.php	2.64 KB	-rwxr-xr-x
cappdu.php	3.53 KB	-rwxr-xr-x
challan_preparation.php	10.28 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	516 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.34 KB	-rwxr-xr-x
download_upload.html	2.6 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
mregistry.php	1.08 KB	-rwxr-xr-x
results.php	31.03 KB	-rwxr-xr-x
results_15032014.php	27.11 KB	-rwxr-xr-x
results_17042018.php	28.35 KB	-rwxr-xr-x
results_26_12.php	23.87 KB	-rwxr-xr-x
results_old.php	25.54 KB	-rwxr-xr-x
revaluation.php	17.61 KB	-rwxr-xr-x
revaluation12072016.php	17.12 KB	-rwxr-xr-x
revaluation_12032014.php	15.77 KB	-rwxr-xr-x
revaluation_old.php	17.52 KB	-rwxr-xr-x
revaluationnew.php	17.37 KB	-rwxr-xr-x

Code Editor : revaluationnew.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);	
		$this->g_reg_no=$_SESSION['g_reg_no'];
		$this->g_FEXAMNO=$_SESSION['g_FEXAMNO'];
		$this->g_FCOLLCODE=$_SESSION['g_FCOLLCODE'];
		$this->g_FDEGREE=$_SESSION['g_FDEGREE'];
	  }
	  function DisplayRevalutionDetails($aobj_context)
	  { 
	
		$revalution_regno=($this->aobj_context->mobj_data["r"]);
		$revalution_exam=trim($this->aobj_context->mobj_data['e']); 
		
		$get_univcode="select funivcode from control ";
		$lobj_get_univcode = $this->aobj_context->mobj_db->GetRow($get_univcode);	
		  
		$this->univ_code=$lobj_get_univcode['funivcode'];
		
				if($this->univ_code=="023")
				{
					$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.FEXAMNO=rm.FEXAMNO and s.FSUBCODE=rm.FSUBCODE 
					inner join student st on st.FREGNO=rm.FREGNO
					inner join res_fee rf 
					on rf.FREGNO=rm.FREGNO and rf.FEXAMNO=rm.FEXAMNO 
					where  rm.FREGNO = '{$revalution_regno}' 
					and rm.fexamno = '{$revalution_exam}' and (ifnull(rm.fthpassmth,'') = 'Pass' 
					or ifnull(rm.fthpassmth,'') = 'Fail' or length(rm.fthpassmth) < 4)
					and s.FINTASS <> 'T' group by FCSUBCODE";
				}
				else
				{
					$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.FEXAMNO=rm.FEXAMNO and s.FSUBCODE=rm.FSUBCODE 
					inner join student st on st.FREGNO=rm.FREGNO
					inner join res_fee rf 
					on rf.FREGNO=rm.FREGNO and rf.FEXAMNO=rm.FEXAMNO 
					where  rm.FREGNO = '{$revalution_regno}' 
					and rm.fexamno = '{$revalution_exam}' and (ifnull(rm.fthpassmth,'') = 'Pass' 
					or ifnull(rm.fthpassmth,'') = 'Fail' or length(rm.fthpassmth) < 4)
					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']="Challenge 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('{$revalution_regno}','{$revalution_exam}');\" 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($collcode)
		{
		
				$get_prefix_running_number = "select last_number from res_reval_code_generator
								where college_code = '{$collcode}' 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];
				$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($collcode)
		{				 							
			$update_code_generator = "update res_reval_code_generator set last_number = last_number+1
			where college_code = '{$collcode}' 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=strtoupper($this->aobj_context->mobj_data["reg_no"]);
			$examno=strtoupper($this->aobj_context->mobj_data["examno"]);		
			//$exam=$this->g_FEXAMNO;
			$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	date_format(current_date,'%d/%m/%Y') as curr_date,fcollcode, fexamno,fdegree from res_fee 
			where fregno = '{$reg_no}' and fexamno = '{$examno}'";								
			$lobj_get_college_code = $this->aobj_context->mobj_db->GetRow($get_college_code);
			
			/* $this->college_code=$this->g_FCOLLCODE;	
			$FDEGREE=$this->g_FDEGREE;
			$FEXAMNO=$this->g_FEXAMNO; */
			$curr_date=$lobj_get_college_code['curr_date'];	
			$collcode=$lobj_get_college_code['fcollcode'];	
			$FEXAMNO = $lobj_get_college_code['fexamno'];	
			$FDEGREE = $lobj_get_college_code['fdegree'];	
			$app_number=$this->GetNextNumber($collcode);
			 //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}',
					'{$collcode}','{$reg_no}','{$FSUBCODE}','{$akk}',
					'{$avv}',{$grand_total},current_date())";
					$lobj_insert = $this->aobj_context->mobj_db->Execute($insert);				  		 
				}				
			}
				 
			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"]);	
		$exam_no=($this->aobj_context->mobj_data["e"]);	
		$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}' and FEXAMNO ='{$exam_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 : revaluationnew.php