Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.admin-src.php	3.61 KB	-rw-r--r--
ApplicationFeeSummary.php	10.25 KB	-rwxrwxrwx
ApplicationReport.php	9.96 KB	-rwxrwxrwx
Applicationfeereport.php	9.13 KB	-rwxrwxrwx
Collegewise_SeatAllotedList.ph...	11.13 KB	-rwxrwxrwx
Degreewise_SeatAllotedList.php	11.28 KB	-rwxrwxrwx
PrintDocumentVerification.php	23.98 KB	-rwxrwxrwx
SeatMatrixReport.php	24.02 KB	-rwxrwxrwx
admconfirmation.php	4.43 KB	-rwxrwxrwx
admissionMeritListExcel.php	11.08 KB	-rwxrwxrwx
admissionstatusreport.php	12.62 KB	-rwxrwxrwx
admorder_ru.php	4.53 KB	-rw-rw-r--
applicationFormReportBank.php	11.82 KB	-rw-rw-r--
applicationview.php	4.39 KB	-rwxrwxrwx
bnuAdmissionMeritListExcel.php	12.07 KB	-rwxrwxrwx
bnuAdmissionMeritListExcel_161...	11.88 KB	-rwxrwxrwx
changepasswordadmin.php	1.12 KB	-rwxrwxrwx
collegedegree.php	1.92 KB	-rwxrwxrwx
collegedetails.php	2.49 KB	-rwxrwxrwx
create-user.php	4.96 KB	-rwxrwxrwx
documentverification.php	8.75 KB	-rwxrwxrwx
dudseatallot.php	14.5 KB	-rw-rw-r--
editapp.php	1.38 KB	-rw-rw-r--
getAdmOrderDet.php	1.53 KB	-rw-r--r--
getnumword.php	9.1 KB	-rw-rw-r--
meritlist.php	6.41 KB	-rwxrwxrwx
presealallot.php	7.58 KB	-rw-rw-r--
provisionsellist.php	692 B	-rw-rw-r--
provisionsellistReport.php	13.57 KB	-rw-rw-r--
provisionsellistReport1.php	11.76 KB	-rw-rw-r--
provisionsellistReport1Downloa...	12.84 KB	-rw-rw-r--
provisionsellistReportDownload...	15 KB	-rw-rw-r--
report_merit_list.php	6.82 KB	-rwxrwxrwx
rostertable.php	490 B	-rwxrwxrwx
saveApplication.php	20.67 KB	-rwxrwxrwx
savevacantseats.php	2.57 KB	-rw-rw-r--
seatmatrix.php	8.53 KB	-rwxrwxrwx
signin.php	848 B	-rwxrwxrwx
viewpresealallot2.php	8.05 KB	-rw-rw-r--

Code Editor : documentverification.php

<?php
function loadRange($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
	$db = stripslashes($aobj_context->mobj_data["db"]);
	$cond = "";
	$all = "";
	if($_SESSION['fusertype'] == 'usr') {
		$deg_arr = explode( '*', $_SESSION['FDEGREE']);
		$degrees = implode("','", $deg_arr);
		$cond = "where fdegree in ('{$degrees}')";
	} else {
		$all = "select 'All' as fdegree, 'All' as fdescpn, '00' as forder 
  		union";
	}

if($db == 'bcupg')
		$query1 = "{$all} select fdegree, concat(fdegree,'-',fdescpn) as fdescpn, forder from entdeg_pg {$cond} order by forder";
	else
		$query1 = "{$all} select fdegree, concat(fdegree,'-',fdescpn) as fdescpn, forder from entdeg {$cond} order by forder";	
  	$result1 = $aobj_context->mobj_db->GetAll($query1);
  //var_dump($query1);
	if(count($result1) > 0)
	{	
		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 loadAppDetails($aobj_context){
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$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"]);

if($fdept != 'All'){
		$cond = "and c.fdegree = '{$fdept}'";
	}

$query1 = "SELECT b.fdescpn, a.fappno, a.fname, 
	DATE_FORMAT(a.fcreatedate, '%d/%m/%Y') AS fappdate, a.fgender, a.ftotfee, 
	fcategory, fhk,fappstatus,fqdegree,fqclass, 
	fhandicap,fsports,fncc,fdefence,fpdp,fgah,fcof,fincome,
	if(fapprstatus = '', 'pending', ifnull(fapprstatus,'pending')) as fapprstatus 
	FROM entstudadm a,entprevdeg b, entoptdeg c WHERE a.fqdegree=b.fdegree 
	and a.fappno = c.fappno
	AND a.fappno IN (SELECT DISTINCT fappno FROM entstuddoc) 
	AND ifnull(fname,'') <> '' AND fpaystatus = 'success'
	AND a.fappno between '{$afrom}' and '{$ato}' {$cond}
	group by a.fappno
	ORDER BY fname";

$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 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,ifnull(fpath,'') as fpath,fdeleted,
	ifnull(fstatus, '') as fstatus,
	ifnull(fremarks, '') as fremarks from entstuddoc 
	where fappno='{$fappno}' and ifnull(fpath,'') <> ''";
	// var_dump($query1);
	$result1 = $aobj_context->mobj_db->GetAll($query1);
	$i= 0 ;
	$docs = array('1_AADHAR' => "Aadhar Card",
	'2_SSLC' => "SSLC Marks Card",
	'3_UG' => "UG Marks Card",
	'4_CASTE' => "Caste certificate",
	'5_INCOME' => "Income certificate",
	'6_HK' => "HK certificate",
	'7_SQC' => "Special Quota Certificates");
	$result = array();
	foreach($result1 as $key=>$value)
	{
		// var_dump($result1[$i]);
		$result[$i] =  $value;
		$result[$i]['fdocname'] = $docs[$value['fdoctype']];
		$i++;
	}

// var_dump($result);

// var_dump($result1);
	$query2 = "select FAPPNO, ifnull(FAPPRSTATUS, '') as FAPPRSTATUS, 
	ifnull(FAPPRDATE, '') as FAPPRDATE ,  ifnull(FAPPRUSERID, '') as FAPPRUSERID, 
	ifnull(FAPPREMARKS, '') as FAPPREMARKS,fincome from entstudadm where fappno='{$fappno}'";
  	$result2 = $aobj_context->mobj_db->GetAll($query2);

$query3 = "SELECT * FROM entprevmarks WHERE fappno = '{$fappno}'";
  $resultmks = $aobj_context->mobj_db->GetAll($query3);
  // var_dump($result1);

$query ="SELECT CONCAT(cd.fsubcode,'-',cd.fsubname) AS subname,pm.* FROM entprevcomb cd
	LEFT JOIN entprevmarks pm
	ON cd.fdegree = pm.fdegree
	AND cd.fsubcode = pm.fsubcode
	AND IFNULL(pm.fcombcode,'') NOT IN ('lan', 'TOT')
	WHERE pm.fappno = '{$fappno}'
	GROUP BY cd.fdegree, cd.fsubcode";
	$result3 = $aobj_context->mobj_db->GetAll($query);

$query ="select concat(cd.fsubcode,'-',cd.fsubname) as subname,pm.* from entprevcomb cd
	left join entprevmarks pm
	on cd.fcombcode = pm.fcombcode
	and cd.fsubcode = pm.fsubcode
	and ifnull(pm.fcombcode,'') = 'lan'
	where pm.fappno = '{$fappno}'";
	$reslan = $aobj_context->mobj_db->GetAll($query);

$query ="select concat(cd.fsubcode,'-',cd.fsubname) as subname,pm.* from entprevcomb cd
	left join entprevmarks pm
	on cd.fdegree = pm.fdegree and cd.fcombcode = pm.fcombcode
	and cd.fsubcode = pm.fsubcode
	and ifnull(pm.fcombcode,'') = 'TOT'
	where pm.fappno = '{$fappno}'";
	$restotsem = $aobj_context->mobj_db->GetAll($query);

// var_dump($result1);
	// var_dump($result2);
	// var_dump($result3);
	// var_dump($reslan);
	// var_dump($restotsem);
	
	if($result1 && $result2 && $result3 && $reslan && $restotsem )
	{	
    $res['app'] = $result;
	$res['stuadm'] = $result2;
	$res['optsub'] = $result3;
	$res['reslan'] = $reslan;
	$res['restotsem'] = $restotsem;
	$res['resultmks'] = $resultmks;	
		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"]);
	$semtotmks = stripslashes($aobj_context->mobj_data["semtotmks"]);
	$optmks = stripslashes($aobj_context->mobj_data["optmks"]);
	$lanmks = stripslashes($aobj_context->mobj_data["lanmks"]);
	$fcategory = stripslashes($aobj_context->mobj_data["fcategory"]);
	$fincome = stripslashes($aobj_context->mobj_data["fincome"]);
	$fnccmarks = stripslashes($aobj_context->mobj_data["fnccmarks"]);
	$fnssmarks = stripslashes($aobj_context->mobj_data["fnssmarks"]);
	$frarmarks = stripslashes($aobj_context->mobj_data["frarmarks"]);

// var_dump($fnccmarks);
	// var_dump($fnssmarks);
	// var_dump($frarmarks);
	// die();

$statusandremarks = stripslashes($aobj_context->mobj_data["statusandremarks"]);
	$obj = json_decode($statusandremarks,true);

$radio_obj = stripslashes($aobj_context->mobj_data["radio_obj"]);
	$obj_radio = json_decode($radio_obj,true);
	// var_dump($obj_radio);
	$i= 0;
	for($i=0; $i<count($obj_radio); $i++)
	{
		$radio_obb[$obj_radio[$i]['id']] = $obj_radio[$i]['value'];

}
	// var_dump($radio_obb);

$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']);

$query_updatecat = "update entstudadm set fcategory_ver = '{$fcategory}',fincome_ver = '{$fincome}',fhk_ver = '{$radio_obb['fhkdoc']}',
	fhandicap_ver = '{$radio_obb['fhandicap']}',fsports_ver = '{$radio_obb['fsports']}',fncc_ver = '{$radio_obb['fncc']}',fdefence_ver = '{$radio_obb['fdefence']}',
	fpdp_ver = '{$radio_obb['fpdp']}',fgah_ver = '{$radio_obb['fgah']}',fcof_ver = '{$radio_obb['fcof']}',
	fnss_ver = '{$radio_obb['fnss']}',frar_ver = '{$radio_obb['frar']}',
	fnccmarks = '{$fnccmarks}',fnssmarks = '{$fnssmarks}',frarmarks = '{$frarmarks}'		
	where fappno = '{$fappno}'";
	// var_dump($query_updatecat);
	$rst_updatecat = $aobj_context->mobj_db->Execute($query_updatecat);
	
	$query3 = "UPDATE entprevmarks SET fstatus = '{$lanmks}'
    WHERE fcombcode = 'lan'
    AND fappno = '{$fappno}' ";
	
	$rst3 = $aobj_context->mobj_db->Execute($query3);

$query4 = "UPDATE entprevmarks SET fstatus = '{$semtotmks}'
    WHERE fcombcode = 'TOT'
    AND fappno = '{$fappno}' ";
	
	$rst4 = $aobj_context->mobj_db->Execute($query4);

$query5 = "UPDATE entprevmarks SET fstatus = '{$optmks}'
    WHERE fcombcode NOT IN('lan','TOT')
    AND fappno = '{$fappno}' ";
	
	$rst5 = $aobj_context->mobj_db->Execute($query5);

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 : documentverification.php