Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
applicationFormReportPOSTOFFIC...	19.27 KB	-rwxr-xr-x
applicationFormReportSBM.php	15.18 KB	-rwxr-xr-x
applicationFormReportSBM_old.p...	8.42 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
cappcontext.php	2.66 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
coutput.php	1.76 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.35 KB	-rwxr-xr-x
download_photo.php	4.4 KB	-rwxr-xr-x
dropdown.php	844 B	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
fpdf_protection.php	5.61 KB	-rwxr-xr-x
getdata.php	1.06 KB	-rwxr-xr-x
getnumword.php	7.15 KB	-rwxr-xr-x
hallticket.php	6.49 KB	-rwxr-xr-x
json.php	33.2 KB	-rwxr-xr-x
kusphdadm.php	12.6 KB	-rwxr-xr-x
kusphdadm_bkp.php	6.28 KB	-rwxr-xr-x
mregistry.php	3.43 KB	-rwxr-xr-x
re_rigistration.php	7.38 KB	-rwxr-xr-x
report_hall_ticket.php	11.53 KB	-rwxr-xr-x
reportapplicationform - Copy.p...	19.59 KB	-rwxr-xr-x
reportapplicationform.php	23.92 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
saveApplication.php	8.2 KB	-rwxr-xr-x
saveRerigistration.php	10.87 KB	-rwxr-xr-x
student.php	5.33 KB	-rwxr-xr-x
subfeedetl.php	3.04 KB	-rwxr-xr-x

Code Editor : kusphdadm.php

<?php

function saveApplication($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$reg_no = $aobj_context->mobj_data["reg_no"];

include_once($aobj_context->main_src."/json.php"); 
	$json = new Services_JSON();
	//recieve decode json string of personal info
	$lstr_param = stripslashes($aobj_context->mobj_data["personal_info"]);
	$per_arr_data = json_decode($lstr_param, true);	
	// $fappno = stripslashes($aobj_context->mobj_data["fappno"]);
	$final_submit = stripslashes($aobj_context->mobj_data["ffinsub"]);
	$formtype = stripslashes($aobj_context->mobj_data["formtype"]);
	
	// Backend Validation
	if($final_submit == '' || $formtype == '' )
	{
		$arr['message'] = 'Error No. 1 in saving registration details.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
		return;
	}

//convert to Associative array
	$perdada = array();
	for($i=0; $i<count($per_arr_data); $i++)
	{
		$perdata[$per_arr_data[$i]['id']] = $per_arr_data[$i]['value'];
	}
	//For phd admissions assuming examno and college code

$query = "select sum(case when DATE_FORMAT(NOW(),'%Y-%m-%d') not between ifnull(fadmfrom,'1990-01-01') AND ifnull(fadmto,'1990-01-01') then 1 else 0 end) as flastdate,
	fsuspend from collexam where fcollcode = 'PHD' and fdegree = 'PHD' and fexamno = 'A'";
	//var_dump($query);
	$result = $aobj_context->mobj_db->GetRow($query);
/* */
	
	if($result['flastdate'] > 0)
	{
		$arr = "Last date is over for Ph.D application";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
		return;
	}

if($final_submit == '' || $formtype == '' || 
	$perdata['fmobileno'] == '' || $perdata['fname'] == '')
	{
		$arr['message'] = 'Error No. 1 in saving registration details. Enter Mobileno and Name';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
		return;
	}

$fappno = '';
	$query = "select fmobileno, fappno from phdstudadm 
	where fmobileno = '{$perdata['fmobileno']}' and fform = '{$formtype}'";
	$studresult =  $aobj_context->mobj_db->GetRow($query);

if(count($studresult) >0)
		$fappno = $studresult['fappno'];

if($perdata['fcollcode'] == '')
		$perdata['fcollcode'] = 'PHD';

if($fappno == '')
	{		
		$insert_qry="insert into phdstudadm 
		(FDEGREE,FCOLLCODE,FFORM, FNAME,FGENDER,FHANDICAP,FDOB, FHK,
		FFATNAME,FMOTNAME,FEMAIL,FCATEGORY, FCASTE,
		FMOBILENO,FNATIONAL,FCURRADD1,FCURRADD2,FCURRADD3,FCURRDIST,FCURRPIN,FCURRSTATE,
		FPERMADD1,FPERMADD2,FPERMADD3,FPERMDIST,FPERMPIN, FPERMSTATE,
		FAADHARNO,FAPPNO,FAREA, FQDEGREE, FQSUB, FQYEAR,FQPERCENTAGE,
		FQSPLN, FQUNIV, FFINSUB, FTOTFEE, FCREATEDATE, FCREATEUSER)
		values   
		('{$perdata['fdegree']}', '{$perdata['fcollcode']}', '$formtype', '{$perdata['fname']}',
		'{$perdata['gender']}', '{$perdata['handicap']}', date_format(STR_TO_DATE('{$perdata['fdob']}','%d/%m/%Y'),'%Y-%m-%d'),
		'{$perdata['HK']}','{$perdata['ffatname']}', '{$perdata['fmotname']}','{$perdata['femail']}',
		'{$perdata['fcategory']}', '{$perdata['fcaste']}', '{$perdata['fmobileno']}', '{$perdata['fnational']}',
		'{$perdata['fcurradd1']}','{$perdata['fcurradd2']}', '{$perdata['fcurradd3']}',
		'{$perdata['fcurrdist']}', '{$perdata['fcurrpin']}', '{$perdata['fcurrstate']}',
		'{$perdata['fpermadd1']}','{$perdata['fpermadd2']}', '{$perdata['fpermadd3']}', 
		'{$perdata['fpermdist']}','{$perdata['fpermpin']}', '{$perdata['fpermstate']}',
		'{$perdata['faadharno']}','{$perdata['fmobileno']}', '{$perdata['farea']}',
		'{$perdata['fqdegree']}', '{$perdata['fqsub']}','{$perdata['fqyear']}','{$perdata['fqpercentage']}',
		'{$perdata['fqspln']}', '{$perdata['fquniv']}', '{$final_submit}', '{$perdata['ftotfee']}', now(), 'STUDENT')";
		//var_dump($insert_qry);
		$results = $aobj_context->mobj_db->Execute($insert_qry);
		// return;
		if($results)
		{
			$query = "select internal_code, fdegree, fcollcode, control.funivcode from phdstudadm, control 
			where fmobileno = '{$perdata['fmobileno']}' 
			and fappno = '{$perdata['fmobileno']}'"; 
			$results2 = $aobj_context->mobj_db->GetRow($query);
			if(count($results2) > 0)
			{
				$internal_code = $results2['internal_code'];
				$degree = $results2['fdegree'];
				$college = $results2['fcollcode'];
				$funivcode = substr($results2['funivcode'],1,2);
				
				$fappno = '6'.$funivcode.$internal_code;
				
				$query = "update phdstudadm set fappno = '{$fappno}'
				where fmobileno = '{$perdata['fmobileno']}' 
				and fappno = '{$perdata['fmobileno']}'";

$results3 = $aobj_context->mobj_db->Execute($query);

// Generate Regno only on final submit
				if($final_submit == 'T')
				{
					$query = "select fdegree,concat(right(fdegree,3), fregprefix) as fregno, fregprefix 
					from degree where fdegree = '{$perdata['fdegree']}' and fdeggrp = 'PHD'";
					$resultsreg = $aobj_context->mobj_db->GetRow($query);
					
					$query = "update phdstudadm set fregno = '{$resultsreg['fregno']}'
					where fmobileno = '{$perdata['fmobileno']}' 
					and fappno = '{$fappno}'";
					$results3 = $aobj_context->mobj_db->Execute($query);

$query = "update degree set fregprefix = fregprefix+1
					where fdegree = '{$perdata['fdegree']}' and fdeggrp = 'PHD'";

$resultdeg = $aobj_context->mobj_db->Execute($query);
				}
			}
			else
			{
				$arr['message'] = 'Error No. 2 in saving registration details.';
				echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
				return;
			}

if($formtype == 'B')
			{
				$cert_path = $aobj_context->main_src."/certificates/".$fappno;
				//is successfully inserted
				if(!file_exists($cert_path))
				{
					mkdir($cert_path);
				}

// ------------- Document Strart -------------------//////

$insert = "INSERT INTO phdstuddoc
				( fappno, fdoctype,fdegree,fcollcode, ffilepath, fcreatedate)
				select '{$fappno}', ffilename, '{$degree}', '{$college}', null, now()
				from masdoc where fdegree = 'PHD'";	
				// var_dump($insert);
				$lobj_insert= $aobj_context->mobj_db->Execute($insert);

$doc_names = ['UGCJRF','UGCCSIR','UGCNET','SLET','GATE','YNGSCI','MPHIL','RESFELL','PROJASC','FIP','QIP','FORIGN'];

for($i=0;$i<count($doc_names);$i++)
				{
					$GCCERT = $perdata['h_'.$doc_names[$i]];
					if($GCCERT == '')
						continue;

$GCCERT_PATH = $aobj_context->main_src.'/upload/'.$GCCERT;
					$filename = explode(".", $GCCERT_PATH);
					$ext = strtolower($filename[1]);

$GCCERT_FILENAME = $doc_names[$i];
					
					$GCCERT_FILENAME = $GCCERT_FILENAME.".".$ext;

$GCCERT_FILENAME_FILENAME = $cert_path."/".$GCCERT_FILENAME;
					$GCCERT = "certificates/{$fappno}/".$GCCERT_FILENAME;
					if(copy($GCCERT_PATH,$GCCERT_FILENAME_FILENAME))
					{
						$update = "";
						$update = "update phdstuddoc set file_path = '{$GCCERT}' 
						where fappno = '{$fappno}' 
						and fdoctype = '{$doc_names[$i]}'";
						//var_dump($update);
						$lobj_insert= $aobj_context->mobj_db->Execute($update);
						unlink($GCCERT_PATH);
					}
				}
				// -------------Document end -------------------//////
			}
		}
	}
	else
	{
		$query = "update phdstudadm set 
		fdegree = '{$perdata['fdegree']}',
		FCOLLCODE = '{$perdata['fcollcode']}',
		FNAME = '{$perdata['fname']}',
		FGENDER = '{$perdata['gender']}',
		FDOB = DATE_FORMAT(STR_TO_DATE('{$perdata['fdob']}','%d/%m/%Y'),'%Y-%m-%d'),	
		FFATNAME = '{$perdata['ffatname']}',
		FMOTNAME = '{$perdata['fmotname']}',
		FEMAIL = '{$perdata['femail']}',
		FCASTE = '{$perdata['fcaste']}',
		FMOBILENO = '{$perdata['fmobileno']}',
		FNATIONAL = '{$perdata['fnational']}',
		FCURRADD1 = '{$perdata['fcurradd1']}',
		FCURRADD2 = '{$perdata['fcurradd2']}',
		FCURRADD3 = '{$perdata['fcurradd3']}',
		FCURRDIST = '{$perdata['fcurrdist']}',
		FCURRPIN = '{$perdata['fcurrpin']}',
		FCURRSTATE = '{$perdata['fcurrstate']}',
		FPERMADD1 = '{$perdata['fpermadd1']}',
		FPERMADD2 = '{$perdata['fpermadd2']}',
		FPERMADD3 = '{$perdata['fpermadd3']}',
		FPERMDIST = '{$perdata['fpermdist']}',
		FPERMPIN = '{$perdata['fpermpin']}',
		FPERMSTATE = '{$perdata['fpermstate']}',
		FCATEGORY = '{$perdata['fcategory']}',
		FAADHARNO = '{$perdata['faadharno']}',
		FQDEGREE = '{$perdata['fqdegree']}',
		FQSUB = '{$perdata['fqsub']}',
		FQYEAR = '{$perdata['fqyear']}',
		FQSPLN = '{$perdata['fqspln']}',
		FQUNIV = '{$perdata['fquniv']}',
		FTOTFEE = '{$perdata['ftotfee']}',
		FAREA = '{$perdata['farea']}',
		FQYEAR = '{$perdata['fqyear']}',
		FQPERCENTAGE = '{$perdata['fqpercentage']}',
		flogdate = now(),
		ffinsub = '{$final_submit}'
		where fappno = '{$fappno}'";
		
		$results = $aobj_context->mobj_db->Execute($query);

// var_dump($query);

if($results)
		{
			// ------------- Document Strart -------------------//////

// Generate Regno only on final submit
			if($final_submit == 'T')
			{
				$query = "select fdegree,concat(right(fdegree,3), fregprefix) as fregno, fregprefix 
				from degree where fdegree = '{$perdata['fdegree']}' and fdeggrp = 'PHD'";
				$resultsreg = $aobj_context->mobj_db->GetRow($query);
				
				$query = "update phdstudadm set fregno = '{$resultsreg['fregno']}'
				where fmobileno = '{$perdata['fmobileno']}' 
				and fappno = '{$fappno}'";
				$results3 = $aobj_context->mobj_db->Execute($query);

$query = "update degree set fregprefix = fregprefix+1
				where fdegree = '{$perdata['fdegree']}' and fdeggrp = 'PHD'";

$resultdeg = $aobj_context->mobj_db->Execute($query);
			}

$doc_names = ['UGCJRF','UGCCSIR','UGCNET','SLET','GATE','YNGSCI','MPHIL','RESFELL','PROJASC','FIP','QIP','FORIGN'];
			$cert_path = $aobj_context->main_src."/certificates/".$fappno;
			for($i=0;$i<count($doc_names);$i++)
			{
				$GCCERT = $perdata['h_'.$doc_names[$i]];
				if($GCCERT == '')
					continue;

$GCCERT_PATH = $aobj_context->main_src.'/upload/'.$GCCERT;
				$filename = explode(".", $GCCERT_PATH);
				$ext = strtolower($filename[1]);

$GCCERT_FILENAME = $doc_names[$i];
				
				$GCCERT_FILENAME = $GCCERT_FILENAME.".".$ext;

$GCCERT_FILENAME_FILENAME = $cert_path."/".$GCCERT_FILENAME;
				$GCCERT = "certificates/{$fappno}/".$GCCERT_FILENAME;
				// var_dump($GCCERT_PATH);
				// var_dump($GCCERT_FILENAME_FILENAME);
				if(copy($GCCERT_PATH,$GCCERT_FILENAME_FILENAME))
				{
					$update = "update phdstuddoc set ffilepath = '{$GCCERT}' 
					where fappno = '{$fappno}' 
					and fdoctype = '{$doc_names[$i]}'";	
					// var_dump($update);
					$lobj_insert= $aobj_context->mobj_db->Execute($update);

unlink($GCCERT_PATH);
				}
			}
			// -------------Document end -------------------//////
		}
	}
		
	if($results) 
	{
		//update photo path
		
		$folder_path=$aobj_context->main_src."/student_photos";
		
		
		$photo_filename = $perdata['photo_path'];

if($photo_filename != '')
		{
			$image_path = $aobj_context->main_src."/upload/{$photo_filename}";

// $filename = explode(".", $photo_filename);
			// $ext = strtolower($filename[1]);
			$ext = pathinfo($photo_filename, PATHINFO_EXTENSION);
			$photo_filename = $fappno;
			$photo_filename = $photo_filename.".".$ext;

$full_file_path = $folder_path.'/'.$photo_filename;

$photo = "student_photos/".$photo_filename;
			
			if(copy($image_path,$full_file_path))
			{
				$update="update phdstudadm set FPHOTOPATH='{$photo}' 
						where FAPPNO=  '{$fappno}'";
				$up_obj=$aobj_context->mobj_db->Execute($update); 
				unlink($image_path);
			}
		}

$data='Your Application is submitted successfully.';
		$arr['message']= $data;
		$arr['app_no'] = $fappno;
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;
	}	
	else
	{
		$arr['message'] = 'Error in submitting the application.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
		return;
	}

}

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

$query = "select ifnull(fappno,'') as fappno from studadm 
	where FCONTACT_NO = '{$_SESSION['MOBILE']}' and ffinsub = 'T'";

$obj =  $aobj_context->mobj_db->GetRow($query); 
	// var_dump($obj);
	$row['appno'] = $obj['fappno'];
	$row['error_code'] = '0';
	if($obj['fappno'] == '')
	{
		$row['error_code'] = '1';
	}
	echo json_encode($row);
}

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

$rappno = trim($aobj_context->mobj_data["rappno"]);
	$rdob  = trim($aobj_context->mobj_data["rdob"]);	
	
	
	$query   = "select fappno,fdob,ifnull(FPAYTYPE,'') as fpaymenttype,
	ifnull(FPAYSTATUS,'')  as fpaymentstatus,ifnull(ffinsub,'') as  ffinsub
	from phdstudadm 
	where fappno = '{$rappno}' 
	and fdob = date_format(str_to_date('{$rdob}','%d/%m/%Y'),'%Y-%m-%d')";
	
	$results = $aobj_context->mobj_db->getRow($query);

if($results)
	{	
		$arr['html'] = $results;			 
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;

}else
	{
		$arr = "";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
		return;
	}

}

${this.title}

Code Editor : kusphdadm.php