Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Excel_Writer	[ DIR ]	drwxr-xr-x
Excel_reader	[ DIR ]	drwxr-xr-x
JQGrid3.5	[ DIR ]	drwxr-xr-x
Report_details	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
custom_js	[ DIR ]	drwxr-xr-x
custom_src	[ DIR ]	drwxr-xr-x
easy_zip	[ DIR ]	drwxr-xr-x
grid_display_files	[ DIR ]	drwxr-xr-x
html_modules	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
maya-pdf	[ DIR ]	drwxr-xr-x
misc_files	[ DIR ]	drwxrwxrwx
popups	[ DIR ]	drwxr-xr-x
schema	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
student_photos	[ DIR ]	drwxrwxrwx
tarka_pdf	[ DIR ]	drwxr-xr-x
tarka_pdf_latest	[ DIR ]	drwxr-xr-x
teacher_photos	[ DIR ]	drwxrwxrwx
tmpphotos	[ DIR ]	drwxrwxrwx
tt24042015	[ DIR ]	drwxr-xr-x
user_images	[ DIR ]	drwxr-xr-x
validation_files	[ DIR ]	drwxr-xr-x
.htaccess	602 B	-rwxr-xr-x
Bundle_Pack_Info.xls	25 KB	-rwxr-xr-x
MainPage.html	12.39 KB	-rwxr-xr-x
MainPagepopup.html	7.05 KB	-rwxr-xr-x
RVRT.pdf	142.96 KB	-rwxr-xr-x
TAGMAY2013.pdf	331.03 KB	-rwxr-xr-x
app.php	416 B	-rwxr-xr-x
cconfig.php	891 B	-rwxr-xr-x
collegeInfoPopup.html	3.76 KB	-rwxr-xr-x
ddecenters.pdf	37.1 KB	-rwxr-xr-x
flysq.pdf	668.21 KB	-rwxr-xr-x
homepage.html	3.35 KB	-rwxr-xr-x
index.html	5.88 KB	-rwxr-xr-x
index1.html	5.8 KB	-rwxr-xr-x
indexlatest.html	5.16 KB	-rwxr-xr-x
indexlogin.html	5.81 KB	-rwxr-xr-x
indextest.html	9.98 KB	-rwxr-xr-x
logo.jpg	29.02 KB	-rwxr-xr-x
mainpage.htm	31.7 KB	-rwxr-xr-x
nehu.sql	686 B	-rwxr-xr-x
nittequery.txt	688 B	-rwxr-xr-x
nstt.html	4.55 KB	-rwxr-xr-x
oasis_manual.pdf	1.06 MB	-rwxr-xr-x
obsbed.pdf	656.73 KB	-rwxr-xr-x
obschm.pdf	483.94 KB	-rwxr-xr-x
obssmg.pdf	791.49 KB	-rwxr-xr-x
ord.pdf	1.19 MB	-rwxr-xr-x
pending ia.txt	1.03 KB	-rwxr-xr-x
qpseries.pdf	511.72 KB	-rwxr-xr-x
revaluation.php	16.77 KB	-rwxr-xr-x
studlist2013_2.htm	30.65 KB	-rwxr-xr-x
tt.htm	31.85 KB	-rwxr-xr-x
tt.html	4.67 KB	-rwxr-xr-x
tt_2013_2.xls	436 KB	-rwxr-xr-x
tt_2013_2_old.xls	359.5 KB	-rwxr-xr-x
tt_old.htm	31.83 KB	-rwxr-xr-x

Code Editor : revaluation.php

<?php
function GetNextNumber($aobj_context)
{
session_start();
$college_code = $_SESSION['collcode'];
		
			$get_prefix_running_number = "select last_number from reval_code_generator
							where college_code = '{$college_code}'  ";		
			$lobj_get_prefix_running_number = $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 
							reval_code_generator(college_code,last_number)
							values
							(
							'{$college_code}',
							{$next_number}
							)";
				$lobj_insert_into = $aobj_context->mobj_db->Execute($insert_into);
			$last_number = str_pad($next_number,4, "0", STR_PAD_LEFT);		
			}
			return $college_code.$last_number;	
}
function UpdateNextNumber($aobj_context)
{
			session_start();
			$college_code = $_SESSION['collcode'];					
		 
				$update_code_generator = "update reval_code_generator set last_number = last_number+1
											    where college_code = '{$college_code}' ";
				$lobj_update_code_generator = $aobj_context->mobj_db->Execute($update_code_generator);
}	
		
function DisplayRevalutionDetails($aobj_context)
{ 
session_start();
$college_code = $_SESSION['collcode'];
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$revalution_degree_code=($aobj_context->mobj_data["revalution_degree_code"]);
$revalution_regno=($aobj_context->mobj_data["revalution_regno"]);
$get_reg_no_exists="select count(*) as reg_cnt from mresult where
			FDEGREE='{$revalution_degree_code}' and  FREGNO='{$revalution_regno}'";
  $lobj_get_reg_no_exists = $aobj_context->mobj_db->GetRow($get_reg_no_exists);	
 //echo $get_reg_no_exists;
	if($lobj_get_reg_no_exists[reg_cnt]>0)
	{
	
		$get_already_applied="SELECT 
					APPNO,DATE_FORMAT(FAPPDATE,'%d/%m/%Y') AS app_date,
				
					FTOTAL,mr.FSUBCODE,FCORRTYPE,FAMOUNT,mr.internal_code FROM
				mresult_detail mr  LEFT JOIN  subject s ON mr.FSUBCODE=s.FCSUBCODE
				inner JOIN student st ON st.FREGNO=mr.FREGNO
				WHERE mr.FDEGREE='{$revalution_degree_code}' AND  mr.FREGNO='{$revalution_regno}' 
				AND mr.FCOLLCODE='{$college_code}'  AND  s.FDEGREE=mr.FDEGREE AND s.FEXAMNO=mr.FEXAMNO ";
		$lobj_get_already_applied= $aobj_context->mobj_db->GetAll($get_already_applied);
		//echo $get_already_applied;
		$allready_applied_arr=array();
		$allready_applied_html_arr=array();
		foreach($lobj_get_already_applied as $ak=>$av)
		{
				$allready_applied_arr[$av['FSUBCODE']][$av['FCORRTYPE']]=$av['FAMOUNT'];
				
				$allready_applied_html_arr[$av['APPNO']][$av['FSUBCODE']][$av['FCORRTYPE']]['type']=$av['FCORRTYPE'];
				$allready_applied_html_arr[$av['APPNO']][$av['FSUBCODE']][$av['FCORRTYPE']]['amt']=$av['FAMOUNT'];
				$allready_applied_html_arr[$av['APPNO']][$av['FSUBCODE']][$av['FCORRTYPE']]['app_date']=$av['app_date'];
				$allready_applied_html_arr[$av['APPNO']][$av['FSUBCODE']][$av['FCORRTYPE']]['FTOTAL']=$av['FTOTAL'];
				$allready_applied_html_arr[$av['APPNO']][$av['FSUBCODE']][$av['FCORRTYPE']]['internal_code']=$av['internal_code'];
		}
	 
		$get_data="select  mr.internal_code,date_format(current_date(),'%d/%m/%Y') as curr_date, 
						s.FDEGREE,FCSUBCODE ,concat(s.FSUBNAME ,' ',s.FSSUBNAME) as FSUBNAME,
					 mr.FPASS,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
			  mresult mr  left join  subject s on mr.FSUBCODE=s.FCSUBCODE
			  left join student st on st.FREGNO=mr.FREGNO
				where mr.FDEGREE='{$revalution_degree_code}' and mr.FREGNO='{$revalution_regno}' 
			 and mr.FCOLLCODE='{$college_code}'   and  s.FDEGREE=mr.FDEGREE and s.FEXAMNO=mr.FEXAMNO 
			 
				group by FCSUBCODE";
  $lobj_get_data = $aobj_context->mobj_db->GetAll($get_data);
 
	$str_reval="";
	$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' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Revaluation</th>";
	$str_reval.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
	$str_reval.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Code</td>";
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>";
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Result?</td>";
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>RV</td>";
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>RT</td>";
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Xerox</td>";
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Challenge Val.</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=0;
	$total_val=0;
	//echo $get_data; 
	$name=$lobj_get_data[0][FNAME];
	$curr_date=$lobj_get_data[0][curr_date];
	foreach($lobj_get_data as $k=>$val)	 
	{
       //print_r($lobj_get_data); die();

$is_selected_checked='';
		$FCSUBCODE =$val[FCSUBCODE];
		$is_rv =$val['is_rv'];
		$is_rt =$val['is_rt'];
		$is_xr =$val['is_xr'];
		$is_cv =$val['is_cv'];
		$applied_arr=$allready_applied_arr[$FCSUBCODE];	
		$FPASS =$val[FPASS];	
		$FFEE =$val[FFEE];	
		$internal_code =$val[internal_code];
		$FSUBNAME =$val[FSUBNAME];
		$FRVFEE =$val[FRVFEE];
		$FRTFEE =$val[FRTFEE];
		$FXRFEE =$val[FXRFEE];
		$FCVFEE =$val[FCVFEE];
		 
		$rv_disabled="";
		$rt_disabled="";
		$xr_disabled="";
		if($applied_arr["RV"]>0)
		$rv_disabled=" disabled=true; ";
		if($applied_arr["RT"]>0)
		$rt_disabled=" disabled=true; ";
		if($applied_arr["XR"]>0)
		$xr_disabled=" disabled=true; ";
		if($applied_arr["CV"]>0)
		$cv_disabled=" disabled=true; ";
		$str_reval.="<tr class='ui-widget-content jqgrow'>";		
		$str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;  ' id=fccode_{$internal_code}>{$FCSUBCODE}</td>";
		$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;   ' id=fsname_{$internal_code}>{$FSUBNAME}</td>";
		$str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;  ' id=fsname_{$internal_code}>{$FPASS}</td>";
 
		$str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' id=is_sele_{$internal_code}>";
		if($is_rv=="1")
		$str_reval.="<input id='rv_{$internal_code}'  {$rv_disabled} onclick='CalculateRevaluationTotFee();'   type='checkbox' style='width: 20px;'><span style='font-weight:bold;' id='fee_rv_{$internal_code}'>({$FRVFEE})</span></td>";
		else
		$str_reval.="NA / Last date over</td>";
		
		$str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' id=is_sele_{$internal_code}>";
		if($is_rt=="1")
		$str_reval.="<input id='rt_{$internal_code}'  {$rt_disabled} onclick='CalculateRevaluationTotFee();'   type='checkbox' style='width: 20px;'> <span style='font-weight:bold;' id='fee_rt_{$internal_code}'>({$FRTFEE})</span></</td>";
		else
		$str_reval.="NA / Last date over</td>";
		
		$str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' id=is_sele_{$internal_code}>";
		if($is_xr=="1")
		$str_reval.="<input id='xr_{$internal_code}'  {$xr_disabled} onclick='CalculateRevaluationTotFee();'   type='checkbox' style='width: 20px;'><span style='font-weight:bold;' id='fee_xr_{$internal_code}'>({$FXRFEE})</span></</td>";
		else
		$str_reval.="NA / Last date over</td>";	
		
		$str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' id=is_sele_{$internal_code}>";
		if($is_cv=="1")
		$str_reval.="<input id='cv_{$internal_code}'  {$cv_disabled} onclick='CalculateRevaluationTotFee();'   type='checkbox' style='width: 20px;'><span style='font-weight:bold;' id='fee_cv_{$internal_code}'>({$FCVFEE})</span></</td>";
		else
		$str_reval.="NA / Last date over</td>";	
		$str_reval.="<td class='tbl_row_new' align='right' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;font-weight:bold;  ' id=total_{$internal_code}></td>";
		$str_reval.="</tr>";
		$sl_no++;
	 }
		$str_reval.="</table>";
		$arr['reval_html']=$str_reval;
		$arr['total_val']=$total_val;
		$arr['name']=$name;
		$arr['curr_date']=$curr_date;
		
		$str_reval1="";
	 
		if(count($allready_applied_html_arr)>0)
		{
			$str_reval1.="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='80%' border='0' align='center' cellspacing='0' cellpadding='0'>";
			$str_reval1.="<th align='left' colspan='7' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Entered Revaluation Data</th>";
			$str_reval1.="<tr class='ui-state-default ui-jqgrid-hdiv' >";
			$str_reval1.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>App No</td>";
			$str_reval1.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject</td>";
			$str_reval1.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Type</td>";
			$str_reval1.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Amount</td>";
			$str_reval1.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Delete</td>";
			$str_reval1.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Grand Total</td>";
			$str_reval1.="</tr>";
			foreach($allready_applied_html_arr as $app=>$app_val)
			{
				 //echo "<pre>";print_r($app_val);die();
				 $cnt=0;
				 foreach($app_val as $aks=>$avv)
				 {
					$cnt+=count($avv);
				}	
			 
					$i=0;
					foreach($app_val as $aks=>$avv)
					{
						 foreach($avv as $ak=>$av)
						 {
						$internal_code=$av['internal_code'];
						$str_reval1.="<tr class='ui-widget-content jqgrow' >";		
						if($i==0)
						$str_reval1.="<td class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' rowspan={$cnt}>{$app}</td>";
						
						$str_reval1.="<td class='tbl_row_new' style='text-align:center;  border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' id='delete_td_1_{$internal_code}' >{$aks}</td>";
						$str_reval1.="<td class='tbl_row_new' style='text-align:center;  border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' id='delete_td_2_{$internal_code}' >{$av['type']}</td>";
						$str_reval1.="<td class='tbl_row_new' style='text-align:center;  border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' id='delete_td_3_{$internal_code}' >{$av['amt']}</td>";
						$str_reval1.="<td class='tbl_row_new' style='text-align:center;  border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' id='delete_td_4_{$internal_code}' ><img src='img/Remove-icon.png' alt='Delete' onclick='DeleteMresultDetail({$internal_code},\"{$app}\");'></img></td>";
						if($i==0)
						$str_reval1.="<td class='tbl_row_new' style='text-align:center;  border-right:1px solid #C5DBEC; padding:2px; font-size:12px;font-weight:bold;' rowspan={$cnt} >{$av['FTOTAL']}</td>";
						$str_reval1.="</tr>";
						$i++;
						}
					 
					}
					
			}
			$str_reval1.="</table>";
		}
		if(!empty($lobj_get_data))
		{
		$arr['reval_html']=$str_reval;
		$arr['total_val']=$total_val;
		$arr['allready_html']=$str_reval1;
		$arr['name']=$name;
		$arr['curr_date']=$curr_date;
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 		
		}
		else
		{
		$data="You Cannot Enter the Revaluation Details";
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"success"); 
		}
	}
	else
	{
	$data="Invalid Reg No";
	echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"success"); 
	}	
}

}
function DeleteMresultDetail($aobj_context)
{
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$int_code=($aobj_context->mobj_data["int_code"]);
	$app_no=($aobj_context->mobj_data["app_no"]);
	$delete_from="delete from mresult_detail where internal_code={$int_code}";
			$lobj_delete_from = $aobj_context->mobj_db->Execute($delete_from);
	$get_app_no="SELECT SUM(FAMOUNT) as tot_amt FROM mresult_detail
					WHERE APPNO='{$app_no}' "; 
	$lobj_get_app_no = $aobj_context->mobj_db->GetRow($get_app_no);
	$tot_amt=$lobj_get_app_no['tot_amt'];	
	$update="update mresult_detail set FTOTAL={$tot_amt}	
				WHERE APPNO='{$app_no}' "; 
		$lobj_get_app_no = $aobj_context->mobj_db->Execute($update);
		
	 echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_app_no,0,"success");

}

${this.title}

Code Editor : revaluation.php