Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.admin-src.php	3.61 KB	-rw-r--r--
AdmissionListReportExcel.php	13.85 KB	-rwxrwxrwx
ApplicationFeeSumExcel1.php	7.43 KB	-rwxrwxrwx
ApplicationFeeSummary.php	10.14 KB	-rwxrwxrwx
ApplicationFeeSummaryExcel.php	2.93 KB	-rwxrwxrwx
ApplicationReport.php	10.32 KB	-rwxrwxrwx
Applicationfeereport.php	8.72 KB	-rwxrwxrwx
Collegewise_SeatAllotedList.ph...	11.13 KB	-rwxrwxrwx
Degreewise_Adm_Fee_Collected.p...	7.66 KB	-rwxrwxrwx
Degreewise_SeatAllotedList.php	12.09 KB	-rwxrwxrwx
Degreewise_SeatAllotedList_all...	11.18 KB	-rwxrwxrwx
Degreewise_SeatAllotedList_cre...	19.46 KB	-rwxrwxrwx
Degreewise_SeatAllotedList_cre...	17.58 KB	-rwxrwxrwx
Degreewise_SeatAllotedList_cre...	17.83 KB	-rwxrwxrwx
Degreewise_SeatAllotedList_fin...	17.11 KB	-rwxrwxrwx
PrintDocumentVerification.php	28.13 KB	-rwxrwxrwx
SeatMatrixReport.php	24.02 KB	-rwxrwxrwx
admList.php	1.11 KB	-rwxrwxrwx
admconfirmation.php	4.43 KB	-rwxrwxrwx
admissionFeeSummaryReportExcel...	9.64 KB	-rwxrwxrwx
admissionfeedetails.php	1.61 KB	-rw-rw-r--
admissionfeereport.php	11.59 KB	-rw-rw-r--
admissionstatusreport.php	12.62 KB	-rwxrwxrwx
admorder_ru.php	4.4 KB	-rw-r--r--
applicationFormReportBank.php	11.91 KB	-rw-rw-r--
applicationview.php	4.11 KB	-rwxrwxrwx
changepasswordadmin.php	1.12 KB	-rwxrwxrwx
collegedegree.php	1.92 KB	-rwxrwxrwx
collegedetails.php	2.49 KB	-rwxrwxrwx
create-user.php	4.66 KB	-rwxrwxrwx
documentverification.php	15.69 KB	-rwxrwxrwx
dudseatallot.php	6.11 KB	-rw-rw-r--
getnumword.php	9.1 KB	-rw-rw-r--
loadadmhostelfeedetails.php	2.16 KB	-rw-r--r--
loadhostelfeedetails.php	4.6 KB	-rw-r--r--
presealallot.php	7.58 KB	-rw-rw-r--
provisionsellist.php	1.58 KB	-rw-rw-r--
provisionsellistReport.php	13.78 KB	-rw-rw-r--
provisionsellistReportDownload...	14.94 KB	-rw-rw-r--
report_merit_list.php	6.82 KB	-rwxrwxrwx
rostertable.php	490 B	-rwxrwxrwx
saveApplication.php	19.13 KB	-rwxrwxrwx
savevacantseats.php	2.57 KB	-rw-r--r--
seat_alloted_seatmatrix.php	11.34 KB	-rwxrwxrwx
seatmatrix.php	8.57 KB	-rwxrwxrwx
signin.php	846 B	-rwxrwxrwx
viewpresealallot2.php	8.17 KB	-rw-r--r--

Code Editor : applicationview.php

<?php
function loadRange($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
	
	
	
	
	$query1 = "select * from entdeg";
  $result1 = $aobj_context->mobj_db->GetAll($query1);
  // var_dump($result1);
	if($result1)
	{	
		echo $aobj_context->mobj_output->ToJSONEnvelope($result1,0,"success"); 
	}	
	else
	{	
		$arr = "Some Failure as occured";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"error"); 
	}
}

function loadAppDetailsView($aobj_context){
  
	$json = new Services_JSON();
	$fdept = stripslashes($aobj_context->mobj_data["fdept"]);
	$afrom = stripslashes($aobj_context->mobj_data["afrom"]);
	$ato = stripslashes($aobj_context->mobj_data["ato"]);
    //var_dump($_SESSION['fusertype']);
  	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	if($fdept != 'All'){
		$cond = "and d.fdegree = '{$fdept}'";
	}

$query1 = "select s.fappno, s.fname, date_format(s.fcreatedate, '%d/%m/%Y') as fappdate, s.fgender, s.ftotfee, 
	  s.fcategory, s.fhk,ifnull(s.fappstatus,'Pending') as fappstatus,
	  '{$_SESSION['fusertype']}' as usertype from entstudadm s 
      inner join entoptdeg d on s.fappno = d.fappno
      where s.fappno between '{$afrom}' and '{$ato}'
      {$cond}
      and ifnull(FPAYSTATUS,'') = 'success'
      group by s.fappno";
  	$result1 = $aobj_context->mobj_db->GetAll($query1);
  // var_dump($result1);
	if($result1)
	{	
		echo $aobj_context->mobj_output->ToJSONEnvelope($result1,0,"success"); 
	}	
	else
	{	
		$arr['msg'] = "Some Failure as occured";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"error"); 
	}

}

function loadstuddocDetails($aobj_context)
{

$json = new Services_JSON();
	$fappno = stripslashes($aobj_context->mobj_data["fappno"]);
	// var_dump($fappno);
	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$query1 = "select fappno,fdoctype,fpath,fdeleted,ifnull(fstatus, '') as fstatus,ifnull(fremarks, '') as fremarks from entstuddoc where fappno='{$fappno}'";
	// var_dump($query1);
  $result1 = $aobj_context->mobj_db->GetAll($query1);
  // var_dump($result1);
	$query2 = "select FAPPNO, ifnull(FAPPRSTATUS, '') as FAPPRSTATUS, ifnull(FAPPRDATE, '') as FAPPRDATE ,  ifnull(FAPPRUSERID, '') as FAPPRUSERID , ifnull(FAPPREMARKS, '') as FAPPREMARKS from entstudadm where fappno='{$fappno}'";
  $result2 = $aobj_context->mobj_db->GetAll($query2);
  // var_dump($result1);
	if($result1)
	{	
    $res['app'] = $result1;
    $res['stuadm'] = $result2;
		echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); 
	}	
	else
	{	
		$arr = "Some Failure as occured";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"error"); 
	}
}

function DocStatusAndRemarks($aobj_context){
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$fappno = stripslashes($aobj_context->mobj_data["fappno"]);
	$studstatus = stripslashes($aobj_context->mobj_data["studstatus"]);
	$textarea = stripslashes($aobj_context->mobj_data["textarea"]);
	$statusandremarks = stripslashes($aobj_context->mobj_data["statusandremarks"]);
	$obj = json_decode($statusandremarks,true);
  $val_str = array();
  $i= 0;
  foreach($obj as $key=>$value)
  {
      $val_str[$i] = "('".$value['fappno']."','".$value['fdoctype']."','".$value['fstatus']."','".$value['fremarks']."')";
      $i++;
  }
	$str =  implode(",",$val_str);
	trim($str, '"');

$query1 = "INSERT INTO `entstuddoc` (`fappno`,`fdoctype`, `fstatus`, `fremarks`)
  VALUES
    $str
    on duplicate key update 
		fappno = fappno,fdoctype = fdoctype, fstatus = VALUES(fstatus), fremarks = VALUES(fremarks)";
		
		$rst1 = $aobj_context->mobj_db->Execute($query1);

$query2 = "update entstudadm set fapprstatus = '{$studstatus}',fappremarks = '{$textarea}',
	FAPPRDATE = now(),
	FAPPRUSERID ='{$_SESSION['USERNAME']}'
	where fappno = '{$fappno}'";
	// var_dump($query2);
	$rst2 = $aobj_context->mobj_db->Execute($query2);
	// var_dump($_SESSION['USERNAME']);

if($rst1 && $rst2)
 {	
	 $success_msg= "Updated Successfully";
	 echo $aobj_context->mobj_output->ToJSONEnvelope($success_msg,0,"success"); 
 }	
 else
 {	
	 $error_msg = "Some Failure as occured";
	 echo $aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"error"); 
 }

}

${this.title}

Code Editor : applicationview.php