Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
admin.php	6.64 KB	-rwxr-xr-x
admin_28042018.php	6.25 KB	-rwxr-xr-x
admin_bf_aws.php	6.3 KB	-rwxr-xr-x
cManualMailer.php	1.38 KB	-rwxr-xr-x
candidate_certificate.php	6.55 KB	-rwxr-xr-x
common_data.php	1.91 KB	-rwxr-xr-x
dash_board_client.php	4.4 KB	-rwxr-xr-x
dashboard_customer.php	13.56 KB	-rwxr-xr-x
display_custom_html.php	8.47 KB	-rwxr-xr-x
execute_query.php	754 B	-rwxr-xr-x
get_commmon_data.php	3.76 KB	-rwxr-xr-x
pending_certificate.php	8.15 KB	-rwxr-xr-x
phpinfo.php	19 B	-rwxr-xr-x
sendGridMail.php	1.29 KB	-rwxr-xr-x
sendsmsapi.php	1014 B	-rwxr-xr-x
student.php	34.91 KB	-rwxr-xr-x
student06092016.php	30.58 KB	-rwxr-xr-x
student13062016.php	29.43 KB	-rwxr-xr-x
student14112016.php	32.08 KB	-rwxr-xr-x
student_01022019.php	33.21 KB	-rwxr-xr-x
student_07032018.php	32.83 KB	-rwxr-xr-x
student_13032020.php	33.74 KB	-rwxr-xr-x
student_13072017.php	32.38 KB	-rwxr-xr-x
student_22012018.php	32.69 KB	-rwxr-xr-x
student_26042018.php	33.08 KB	-rwxr-xr-x
student_BF_privpaid.php	33.68 KB	-rwxr-xr-x
student_arun.php	32.09 KB	-rwxr-xr-x
test.php	3.38 KB	-rwxr-xr-x

Code Editor : student_13032020.php

<?php
	include("sendsmsapi.php");
	class applicationForm
	{
		function __construct($aobj_context)
		{
			session_start();
			$this->aobj_context=$aobj_context;
			$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);	
			$this->aobj_context=$aobj_context;
			$this->ip=$_SERVER["REMOTE_ADDR"];
			$this->login_cnt=$_SESSION['login_cnt'];
		}
		
		function assignParams()
		{
			$this->edit_app_code=trim($this->aobj_context->mobj_data["edit_app_code"]);
			$this->course=trim($this->aobj_context->mobj_data["course"]);
			$this->college=trim($this->aobj_context->mobj_data["college"]);
			$this->candidate_name=trim($this->aobj_context->mobj_data["candidate_name"]);
			$this->dob=trim($this->aobj_context->mobj_data["dob"]);
			$this->paddr1=trim($this->aobj_context->mobj_data["paddr1"]);
			$this->paddr2=trim($this->aobj_context->mobj_data["paddr2"]);
			//$this->paddr3=trim($this->aobj_context->mobj_data["paddr3"]);
			//$this->paddr4=trim($this->aobj_context->mobj_data["paddr4"]);
			$this->mobile_no=trim($this->aobj_context->mobj_data["mobile_no"]);
			$this->email_id=trim($this->aobj_context->mobj_data["email_id"]);
			$this->amount=trim($this->aobj_context->mobj_data["amount"]);
			$this->paytype=trim($this->aobj_context->mobj_data["paytype"]);
			$this->reg_no=strtoupper(trim($this->aobj_context->mobj_data["reg_no"]));	
			$this->catpath=trim($this->aobj_context->mobj_data["catpath"]);
			$this->scheme=trim($this->aobj_context->mobj_data["scheme"]);
			$this->freccer=trim($this->aobj_context->mobj_data["freccer"]);
			
			$this->city=trim($this->aobj_context->mobj_data["city"]);
			$this->state=trim($this->aobj_context->mobj_data["state"]);
			$this->pincode=trim($this->aobj_context->mobj_data["pincode"]);
			//$this->restype=trim($this->aobj_context->mobj_data["restype"]);

$this->paddr3 = '';
			$this->paddr4 = '';
		}
		 
		function SaveDetails()
		{
			$check_dup="select count(*) as dup_cnt from dctran
			where FREGNO='{$this->reg_no}'";
			$obj_check_dup=$this->aobj_context->mobj_db->GetRow($check_dup);				
			if($obj_check_dup[dup_cnt]>0)
			{
				$data="You have already applied for Convocation Certificate. Call Help Desk in case of any clarifications.";
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
				return;
			} 
			//var_dump($this->freccer);
			//die();
			$insert_qry=" insert into dctran(FREGNO,FNAME,FDOB,FPOSTADDR1,FPOSTADDR2,FPOSTADDR3,FPOSTADDR4,FMOBILE,FEMAIL,FAMOUNT,FPAYTYPE,FREGDATE,FREGIP,FCATPATH,FRECCER,FSCHEME,FCITY,FSTATE,FPINCODE)
			values('{$this->reg_no}','{$this->candidate_name}',date_format(str_to_date('{$this->dob}','%Y-%m-%d'),'%Y-%m-%d'),'{$this->paddr1}','{$this->paddr2}',
			'{$this->paddr3}','{$this->paddr4}','{$this->mobile_no}','{$this->email_id}',
			'{$this->amount}','{$this->paytype}',now(),'{$this->ip}','{$this->catpath}','{$this->freccer}','{$this->scheme}',
			'{$this->city}','{$this->state}','{$this->pincode}') ";
			$insert_obj=$this->aobj_context->mobj_db->Execute($insert_qry);

$error=mysql_error();
			$this->last_inserted_id = $this->aobj_context->mobj_db->Insert_ID();
			if($this->last_inserted_id)
			{
				$this->UpdateApplicationUniqueNo();
			}
			else
			{
				$data="Error While Inserting ".$error ;;
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
				return;
			}
		}
		
		function UpdateApplicationUniqueNo()
		{
			
			$query="SELECT fdcappno+1 as FLASTNO,FCVPREFIX FROM control";
			$objrst =  $this->aobj_context->mobj_db->GetRow($query); 
			
			$this->prefix=$objrst[FCVPREFIX];
			$this->app_no=$this->prefix.$objrst[FLASTNO];
			
			$update_last_no="update control set fdcappno=fdcappno+1";
			$this->aobj_context->mobj_db->Execute($update_last_no); 
			
			$update_app_no="update dctran set FAPPNO='{$this->app_no}'
					where FAUTONO={$this->last_inserted_id}";
			$this->aobj_context->mobj_db->Execute($update_app_no);
			
			$this->SendAppNoUser($this->mobile_no,$this->email_id,$this->app_no);	
			
			include_once($this->aobj_context->main_src."/JSON.php"); 
			$json = new Services_JSON();
			$college_path=$this->aobj_context->main_src."/student_photos/{$this->college}";
			$folder_path=$this->aobj_context->main_src."/student_photos";
			$file_name=basename($_FILES['student_entry_upload']['name']);
			$path_arr=pathinfo($_FILES['student_entry_upload']['name']);
			$file_ext=$path_arr['extension'];
			$full_file_path= $folder_path.'/'.$this->reg_no.".".$file_ext;;
			$image_path="student_photos/".$this->reg_no.".".$file_ext;;
	 		 
			if(isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '')         
			{ 
				if(move_uploaded_file($_FILES['student_entry_upload']['tmp_name'],$full_file_path))
				{
					$update="update dctran set FPHOTOPATH='{$image_path}' 
					where FAUTONO=  {$this->last_inserted_id} ";
					$up_obj=$this->aobj_context->mobj_db->Execute($update); 
					$arr['app_no']=$this->app_no;
					echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
					
				}
				else
				{
					$data="Error While Moving the Image";
					echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
					return;
				}
			}
		}	
		 
		function GetApplicationDetails()
		{
			$this->app_no=trim($this->aobj_context->mobj_data["app_no"]);
			$get_data=" select internal_code, app_no, pget_val, subject, candidate_name, 
			mother_name, father_name, spouse_name, 
			date_format(dob,'%d/%m/%Y') as dob, sex, 
			s.pob, pob_others, 
			nationality,
			s.college ,
			college_others, 
			s.univ ,univ_others, cncl_reg_no, 
			cncl_reg_name, date_format(rotary,'%d/%m/%Y') as rotary, marks, 
			u_pg, phq, religion, 
			s.category, category_others, 
			caste, sub_caste, dd_amt, dd_no, date_format(dd_date,'%d/%m/%Y') as dd_date,
			dd_bank, address, pin,IFNULL(debared,'No') as debared, email, phone, 
			mobile, in_service_status,  
			s.dept , '' as dept_others, plc_of_working, 
			date_format(date_of_entry,'%d/%m/%Y') as date_of_entry, prob_period, date_format(prob_date,'%d/%m/%Y') as  prob_date,
			doing_pg, pg_degree_course, 
			date_format(pg_degree_date,'%d/%m/%Y') as pg_degree_date, 
			pg_diploma_course, date_format(pg_diploma_date,'%d/%m/%Y') as pg_diploma_date, 
			speciality, enq_pending, suspension, absence, remarks, photo_path, 
			created_date, f_max_marksa, f_sec_marksa, 
			f_no_attaa, f_max_marksb, f_sec_marksb, 
			f_no_attbb, f_max_marksc, f_sec_marksc, 
			f_no_attcc, f_max_marksd, f_sec_marksd, 
			f_no_attdd, f_tot_max_marks, f_tot_sec_marks ,ip_address,created_date 
			from 
			dcstud s						 
			where app_no={$this->app_no}";
						//echo $get_data;die();
			$lobj_get_data=$this->aobj_context->mobj_db->GetRow($get_data); 
			$data="Error While Moving the Image";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($lobj_get_data,0,"Success"); 
			return;
		}
	 
	
	function GetCMSDropDownMenuValues()
	{
		$query="SELECT fcnvno AS int_code,fcnvname AS val FROM mascnvfee 
		where ifnull(fdeleted,'') <> 'T' order by fcnvno asc ";
		$rst=$this->aobj_context->mobj_db->GetAll($query);
		$arr['convtype'] = $rst;
		$query2="SELECT FCATEGORY AS int_code,FDESCPN AS val FROM category 
		where ifnull(fdeleted,'') <> 'T' order by FCATEGORY asc ";
		$rst2=$this->aobj_context->mobj_db->GetAll($query2);
		$arr['category'] = $rst2;
		$get_data="SELECT payment_type AS int_code,bank_name AS val FROM acc_mas 
		where ifnull(fsuspend,'') <> 'T'";
		$up_obj=$this->aobj_context->mobj_db->GetAll($get_data);
		$arr['acctype'] = $up_obj;
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;		
	}
	
	function GetCMSAmountValue()
	{
		$degree=trim($this->aobj_context->mobj_data["degree"]);
		$nationality=trim($this->aobj_context->mobj_data["nationality"]);
		$qry="SELECT FAMOUNT FROM masfee
		WHERE FDEGREE='{$degree}' AND FNATIONAL='{$nationality}'";
		$up_obj=$this->aobj_context->mobj_db->GetRow($qry);
	 
		$amt=$up_obj['FAMOUNT'];
		$amt=empty($amt)?0:$amt;
		$arr['amount']=$amt;
		
		$sub_arr=$this->GetSubjectDetails($degree);
		$doc_arr=$this->GetStudentDocumentsTable($degree,$nationality);
		$arr['subjects'] = $sub_arr;
		$arr['doc_arr'] = $doc_arr;
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	}
	
	function ValidatePaymentApplicationData()
	{
		$p_appno=trim($this->aobj_context->mobj_data["p_appno"]);
		$p_dob=trim($this->aobj_context->mobj_data["p_dob"]);
		$p_reg_no=trim($this->aobj_context->mobj_data["p_reg_no"]);
	 
		$qry="SELECT  FAPPNO,ifnull(FPAYSTATUS,'') PAYSTATUS from dctran
		WHERE FDOB='{$p_dob}' AND FAPPNO='{$p_appno}' AND FREGNO='{$p_reg_no}'
		AND FPAYTYPE='DEBIT/CREDIT/NET BANKING'";
		$up_obj=$this->aobj_context->mobj_db->GetRow($qry);
	 
		$FAPPNO = $up_obj['FAPPNO'];
		if(empty($FAPPNO))
		{	
			$error_msg = 'Invalid Inputs Entered';
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure");
			return;
		}	
		else if($up_obj['PAYSTATUS'] == 'success')
		{
			$error_msg = 'Payment already made for the given application no.';
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure");
			return;
		}	
		else
		{
			$arr['app_no'] = $FAPPNO;
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
			return;
		}	
	}	
	
	function ValidatePrintCertificateApplicationData()
	{
		$appno =trim($this->aobj_context->mobj_data["appno"]);
		$dob=trim($this->aobj_context->mobj_data["dob"]);
		$regno=trim($this->aobj_context->mobj_data["regno"]);
	 
		$qry="SELECT  FAPPNO, FPAYTYPE, FPAYSTATUS from dctran
		WHERE date_format(FDOB,'%d/%m/%Y')= date_format('{$dob}','%d/%m/%Y')  AND FREGNO='{$regno}' and FAPPNO ='{$appno}'";
		$up_obj=$this->aobj_context->mobj_db->GetRow($qry);

$FAPPNO=$up_obj['FAPPNO'];
		$FPAYTYPE = $up_obj['FPAYTYPE'];
		$FPAYSTATUS = $up_obj['FPAYSTATUS'];
		if(empty($FAPPNO))
		{	
			$error_msg = 'invalid credentials';
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure");
		}	
		else
		{
			$arr['app_no']=$FAPPNO;
			$arr['paytype']=$FPAYTYPE;
			$arr['paystatus']=$FPAYSTATUS;
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
		}
			
	}	
	
	function GetSubjectDetails($degree)
	{
		$get_sub="SELECT FQUALSUB FROM massub
					WHERE FDEGREE='{$degree}'";	
		 $up_get_sub=$this->aobj_context->mobj_db->GetAll($get_sub);			
		$i=0;
		$sl=1;
		$html="";
		foreach($up_get_sub	 as $ak=>$av)
		{
			$FQUALSUB=$av['FQUALSUB'];
			$html.="<tr>";
		 
			$html.="<td style='width:300px' id='sub_td_{$i}'>{$FQUALSUB}</td>";
			$html.="<td><input style='width:200px' type='text' id='sub_max_{$i}' placeholder='{$FQUALSUB} Marks' maxlength=10 class='form-control'></td>";
			$html.="<td><input style='width:200px' type='text' id='sub_sec_{$i}' placeholder='{$FQUALSUB} Secured' maxlength=10 class='form-control'></td>";
			$html.="</tr>";
			$i++;
			$sl++;
		}
		return $html;
	}
	
	function GetpaymentLinkForAppNo()
	{
		$app_no=trim($this->aobj_context->mobj_data["app_no"]);
		$get_details="SELECT dctran.FAPPNO as FAPPNO,dctran.FREGNO,college.FCOLLNAME,degree.FDESCPN,date_format(dctran.FDOB,'%d/%m/%Y') as FDOB,dctran.FAMOUNT,
		dctran.FNAME,dctran.FMOBILE,dctran.FEMAIL,dctran.FREGDATE,dctran.FPAYTYPE  
		FROM dctran,dcstud,degree,college
		WHERE dcstud.FREGNO = dctran.FREGNO and college.FCOLLCODE = dcstud.FCOLLCODE
		and degree.FDEGREE = dcstud.FDEGREE and FAPPNO='{$app_no}' ";
		$objget_details=$this->aobj_context->mobj_db->GetRow($get_details);
	
		$FDATE=$objget_details['FREGDATE'];	 
		$FREGNO=$objget_details['FREGNO'];	
		$FCOLLCODE=$objget_details['FCOLLNAME'];	 
		$FDEGREE=$objget_details['FDESCPN'];	
		$FNAME=$objget_details['FNAME'];	
		$FDOB=$objget_details['FDOB'];	 
		$FAMOUNT=$objget_details['FAMOUNT'];	 
		$FMOBILENO=$objget_details['FMOBILE'];	 
		$FEMAIL=$objget_details['FEMAIL'];
		$FPAYTYPE=$objget_details['FPAYTYPE'];	
		
		$html='	<h3 class="col-md-offset-1" style="color:green;"> Successfully Applied!!. <br>Your Application No. is : '.$app_no.' <br> Keep this number for future correspondance with University.</h3> <div class="row">
			<div class="col-md-6 col-sm-12">

<div class="portlet yellow box">
				<div class="portlet-title">
					<div class="caption">
						<i class="fa fa-cogs"></i>Application Details
					</div>
					 
				</div>
				<div class="portlet-body">
					<div class="row static-info">
						<div class="col-md-5 name">
							 Application no. :
						</div>
						<div class="col-md-7 value">
							 '.	$app_no.'
							 
						</div>
					</div>
					<div class="row static-info">
						<div class="col-md-5 name">
							 Application Date &amp; Time:
						</div>
						<div class="col-md-7 value">
							'.$FDATE.'
						</div>
					</div>
					<div class="row static-info">
						<div class="col-md-5 name">
							 Registration no. :
						</div>
						<div class="col-md-7 value">
							'.$FREGNO.'
						</div>
					</div>
					<div class="row static-info">
						<div class="col-md-5 name">
							 College:
						</div>
						<div class="col-md-7 value">
							'.$FCOLLCODE.'
						</div>
					</div>
					<div class="row static-info">
						<div class="col-md-5 name">
							Degree:
						</div>
						<div class="col-md-7 value">
							'.$FDEGREE.'
						</div>
					</div>
					<div class="row static-info">
						<div class="col-md-5 name">
							 Candidate Name:
						</div>
						<div class="col-md-7 value">
								'.$FNAME.'
						</div>
					</div>
					<div class="row static-info">
						<div class="col-md-5 name">
							Amount:
						</div>
						<div class="col-md-7 value">
								<i style="color:red;" class="fa fa-rupee"></i> '.$FAMOUNT.'
						</div>
					</div>
					<div class="row static-info">
						<div class="col-md-5 name">
							 Mobile:
						</div>
						<div class="col-md-7 value">
							'.$FMOBILENO.'
						</div>
					</div>
					<div class="row static-info">
						<div class="col-md-5 name">
							 Email id:
						</div>
						<div class="col-md-7 value">
							'.$FEMAIL.'
						</div>
					</div>
				</div>
			</div>
			</div></div>';
			if($FPAYTYPE == 'DEBIT/CREDIT/NET BANKING')	
			{	
				$html.='<div class="form-actions fluid">
				<div class="row">
				<div class="col-md-12">
				<div class="col-md-offset-3 col-md-4">
				<button class="btn green" onclick=\'CMS.MakeOnlinePayment("'.$app_no.'");\' type="button"><i class="fa fa-rupee"></i> Make Online Payment</button>
				<button class="btn red" onclick="home();" type="button"  ><i class="fa fa-times"></i> Pay Later</button>
				</div>
				</div>
				</div>
				</div>';
			}
			else
			{
				$html.='<div class="form-actions fluid">
				<div class="row">
				<div class="col-md-12">
				<div class="col-md-offset-3 col-md-4">
				<button class="btn green" onclick=\'CMS.PrintPOSTCertifcate("'.$app_no.'");\' type="button"><i class="fa fa-rupee"></i> Print Postoffice Challen</button>
				<button class="btn red" onclick="home();" type="button"  ><i class="fa fa-times"></i>Back</button>
				</div>
				</div>
				</div>
				</div>';
			}		
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($html,0,"success"); 
		return;
	}
	function recurseRmdir($dir) {
		  $files = array_diff(scandir($dir), array('.','..'));
		 
		  foreach ($files as $file) {
			(is_dir("$dir/$file")) ? recurseRmdir("$dir/$file") : unlink("$dir/$file");
		  }
		  return rmdir($dir);
		}

</div>
		<div class="portlet-body">
		<div class="scroller" data-height="380px">
		<table id="upload_table" class="table table-bordered table-hover" cellpadding="0" cellspacing="0">
		<thead>
		<tr>											
		<th>#</th>																		
		<th><i class="icon-briefcase"></i>&nbsp;Document Type</th>																		
		<th>File Type</th>											
		<th>Attachment</th>	</tr>
		</thead>
		<tbody>';
		$sl=1;
		foreach($lobj_get_document_data as $mk=>$mv)
		{
		    $int_code=$mv[int_code];
		    $doc_type=$mv[doc_type];
		    $attachment_path=$mv[attachment_path];
		    $FFILENAME=$mv[FFILENAME];
		    $file_name=$mv[file_name];
			$file_type_id="ed_{$int_code}";
			$doc_file_path=$attachment_path;
				if(!empty($attachment_path))
				$selected=" <span class='label label-success' id='uploded_{$int_code}'>Yes</span> ";
				else
				$selected=" <span class='label label-warning' id='uploded_{$int_code}'>No</span>";
				 
			 
			$this->html.='<tr>						
						<td style="width:30px">'.$sl.'</td>						
						<td id="doc_upload_'.$int_code.'" style="width:300px">'.$doc_type.'</td>						
						<td style="width:300px"><div style="float:left;"><input type="file" name='.$file_type_id.' id='.$file_type_id.' /></div><div style="float:left;"><a class="btn btn-sm blue" href="#" onclick=CMS.UploadEmployeeDocuments("'.$int_code.'","'.$FFILENAME.'")><i class="fa fa-upload"></i>&nbsp;Upload</a></div></td>';	
			if(!empty($attachment_path))
			{
				$this->html.='<td style="width:100px"><a style="color:#AB45F9; padding-right:5px;" href="'.$doc_file_path.'" target="_blank">'.$file_name.'</a><span style="cursor:pointer;" class="label label-danger" onclick=CMS.DeleteEmployeeDocuments("'.$int_code.'")>Delete</span></td>';
			}
			else
			{
				$this->html.='<td style="width:100px" id="attach_td_'.$int_code.'">&nbsp;</td>';
			}
		 
			
			$this->html.='</tr>';	$sl++;	
		}
		$this->html.='</tbody></table>
						</div>
					</div>
					</div>
					</div>
					</form>
					';
		return $this->html;							
	} 
	
	function UploadEmployeeDocuments()
	{

$temp_path = $this->aobj_context->main_src."/certificates/{$this->login_cnt}";
		
		if(!file_exists($temp_path))
		{
			mkdir($temp_path);
		}
		$file_name = replaceChars(basename($_FILES['categoryatt']['name']));
		$file_path = "/{$file_name}";
		$temp_path.=$file_path;
		
		if(isset($file_name) && $file_name != '')         
		{ 		
			$path_arr=pathinfo($_FILES['categoryatt']['name']);
			$file_ext=$path_arr['extension'];
			$root_file_name=$dir_path."/".$file_name;	
			$attachement_path="certificates/{$this->login_cnt}/{$file_name}";
			
			if(move_uploaded_file($_FILES['categoryatt']['tmp_name'],$temp_path))
			{
				$arr['path']=$attachement_path;								
				$arr['file_name']=$file_name;	
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");	
				return; 
			}
			else
			{
					$data="Moving {$file_name} to emp_doc_attchments failed";						
					echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");	
					return;
			}
		} 
		else
		{
			$data="File is empty, not moved";						
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");	
			return;
		}
	}
	//http://myvaluefirst.com/smpp/
	function SendAppNoUser($mobile_no,$s_email_id,$appno)
	{		
		require_once("cManualMailer.php");
		require_once("sendGridMail.php");
		$message="<html>";
		$message.="<body>";
		$message.="<style>";		
		$message.=".mail_tbl td{text-align:left; padding:2px; font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif;}";	
		$message.="</style>";
		$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Dear Candidate,</p></br>";
		$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Your Application no. : ".$appno."</p></br>";
		$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Your Registration is incomplete until the Payment is made.</p>";			
		$message.="</br>";			
		$message.="</body>";
		$message.="</html>";
		$subject="KUSUNI - Application no";	 
		$data='true';
		//$data= send_manual_mail($s_email_id,$subject,$message,$replay_to=null,$cc=null,$bcc=null);
		$data= sendGridMail($s_email_id,$subject,$message,$replay_to=null,$cc=null,$bcc=null);
		//SMS OTP
		$username = 'log01';
		$password = 'log01124';
		$from = 'KUVUNI';
		$to = $mobile_no;
		$text ="Application no. : ".$appno.". Registration is incomplete until payment is maid.";
		$category = '';
		$smsresp = sendsmaapi($username,$password,$from,$to,$text,$category);

}
	
	function SendMailOtPToUser()
	{
		$mobile_no=trim($this->aobj_context->mobj_data["s_mobile_no"]);
		$s_email_id=$this->aobj_context->mobj_data['s_email_id'];
		
		require_once("cManualMailer.php");
		require_once("sendGridMail.php");
		$otp = generateRandomString();
		$message="<html>";
		$message.="<body>";
		$message.="<style>";		
		$message.=".mail_tbl td{text-align:left; padding:2px; font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif;}";	
		$message.="</style>";
		$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Dear Candidate,</p></br>";
		$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>You recently registered for Convocation Certificate. To complete your registration, please confirm your account.</p></br>";
		$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>You may be asked to enter this confirmation code : {$otp}</p>";			
		$message.="</br>";			
		$message.="</body>";
		$message.="</html>";
		$subject="KUSUNI - Action required: Confirm your Registration";	 
		$data='true';
		$data= sendGridMail($s_email_id,$subject,$message,$replay_to=null,$cc=null,$bcc=null);
		//SMS OTP
		$username = 'log01';
		$password = 'log01124';
		$from = 'KUVUNI';
		$to = $mobile_no;
		$text ="Use ".$otp." to verify your Registration";
		$category = '';
		$smsresp = sendsmaapi($username,$password,$from,$to,$text,$category);
		/*if($data=='true')
		{
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($otp,0,"success"); 
		}
		else
		{
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"success"); 
		}*/

$results = json_decode($data,true);

if($results['message'] == 'success')
		{
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($otp,0,"success"); 
		}
		else
		{
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"success"); 
		}	
	}

<div class='form-body' >
			<h3 class='form-section'>Payment Information</h3>
			<div class='form-group' >
			<label class='col-md-3 control-label'  style='text-align:left;font-size:18px;font-weight: bold;'>Application no.</label>
			<label class='col-md-5 control-label' style='text-align:left;font-size:18px;'>
			{$up_obj['FAPPNO']}									
			</label>
			</div>	
			<div class='form-group'>
			<label class='col-md-3 control-label'  style='text-align:left;font-weight: bold;'>Register no.</label>
			<label class='col-md-5 control-label' style='text-align:left;'>
			{$up_obj['FREGNO']}
			</label>
			</div>	
			<div class='form-group'>
			<label class='col-md-3 control-label'  style='text-align:left; font-weight: bold;'>College</label>
			<label class='col-md-5 control-label' style='text-align:left;'>
			{$up_obj['FCOLLNAME']}
			</label>
			</div>	
			<div class='form-group'>
			<label class='col-md-3 control-label'  style='text-align:left; font-weight: bold;'>Degree</label>
			<label class='col-md-5 control-label' style='text-align:left;'>
			{$up_obj['FDESCPN']}									
			</label>
			</div>	
			
			<div class='form-group'>
			<label class='col-md-3 control-label'  style='text-align:left; font-weight: bold;'>Candidate name</label>
			<label class='col-md-5 control-label' style='text-align:left;'>
			{$up_obj['FNAME']}	
			</label>
			</div>	
			<div class='form-group'>
			<label class='col-md-3 control-label'  style='text-align:left; font-weight: bold;'>DOB</label>
			<label class='col-md-5 control-label' style='text-align:left;'>
			{$up_obj['dob']}
			</label>						
			</div>

</div>

</div>	
			<div class='col-md-4'>
			<div class='form-group'>
			<img id='student_entry_photo' style='width:148px;z-index:1;height:187px; width:148px'  src='{$up_obj[FPHOTOPATH]}' class='img-responsive' >
			</div>
			</div>		
			</form> 
			</div>
			<div class='form-body' style='clear:both;margin-left:20px;'>
			<h3 class='form-section'>Personnel Information</h3>

<div class='row'>
			<div class='col-md-4 '>
			<div class='form-group'>
			<label class='control-label' style='font-weight: bold;'>Postal Address : </label><br>
			{$up_obj['FPOSTADDR1']}<br>
			{$up_obj['FPOSTADDR2']}<br>
			{$up_obj['FPOSTADDR3']}<br>
			{$up_obj['FPOSTADDR4']}<br>
			</div>
			</div>

</div>

<div class='col-md-3'>
			<div class='form-group'>
			<label style='font-weight: bold;'>Mobile No. : </label><br>
			{$up_obj['FMOBILE']}
			</div>
			</div>
			<div class='col-md-3'>
			<div class='form-group'>
			<label style='font-weight: bold;'>Email Id. : </label><br>
			{$up_obj['FEMAIL']}												
			</div>
			</div>
			
			</div>
			</div>		
			<div class='form-body' style='clear:both;margin-left:20px;'>
			<h3 class='form-section'>Payment Information</h3>
			<div class='row'>
			<div class='col-md-3'>
			<div class='form-group'>
			<label style='font-weight: bold;'>Payment Type. : </label><br>
			{$up_obj['FPAYTYPE']}
			</div>
			</div>
			<div class='col-md-3'>
			<div class='form-group'>
			<label style='font-weight: bold;'>Payment Status. : </label><br>
			{$up_obj['FPAYSTATUS']}												
			</div>
			</div>
			</div>";

"<div class='form-body' style='clear:both;'>
			<h3 class='form-section'>Convocation certificate Information</h3>			
			<div class='row'>
			<div class='col-md-3'>
			<div class='form-group'>
			<label style='font-weight: bold;'>Certificate no. : </label><br>
			{$up_obj['FCERTNO']}
			</div>
			</div>
			<div class='col-md-3'>
			<div class='form-group'>
			<label style='font-weight: bold;'>Certificate Print Date. : </label><br>
			{$up_obj['FCERTDATE']}														
			</div>
			</div>
			</div>	
			<span> <b>Note : </b>Certificate will be dispatched to College / Study Center within 30 days from the date of Printing.</span>
			<div class='col-md-12'>
			<div class='col-md-offset-3 col-md-4'>
			<br><br>
			<button class='btn red' onclick='home();' type='button'  ><i class='fa fa-times'></i>Back</button>
			</div>
			</div>
			
			</div></div>";	
			
		$arr['html']=$html;
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Success"); 
		return;
	}
	else
	{
		$error_msg = 'invalid credentials';
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure"); 
		return;
	}	
	}	
}

function GetpaymentLinkForAppNo($aobj_context)
{ 
	$obj=new applicationForm($aobj_context);
	$obj->GetpaymentLinkForAppNo();
}

function ValidatePaymentApplicationData($aobj_context)
{ 
	$obj=new applicationForm($aobj_context);
	$obj->ValidatePaymentApplicationData();
}

function ValidatePrintCertificateApplicationData($aobj_context)
{ 
$obj=new applicationForm($aobj_context);
$obj->ValidatePrintCertificateApplicationData();
}
function GetCMSDropDownMenuValues($aobj_context)
{ 
	$obj=new applicationForm($aobj_context);
	$obj->GetCMSDropDownMenuValues();
}

function UploadEmployeeDocuments($aobj_context)
{ 
	$obj=new applicationForm($aobj_context);
	$obj->UploadEmployeeDocuments();
}

function HandleUserInputFiles($aobj_context)
{ 
	$obj=new applicationForm($aobj_context);
	$obj->HandleUserInputFiles();
}

function GetCMSAmountValue($aobj_context)
{ 
	$obj=new applicationForm($aobj_context);
	$obj->GetCMSAmountValue();
}

function SendMailOtPToUser($aobj_context)
{ 
	$obj=new applicationForm($aobj_context);
	$obj->SendMailOtPToUser();
}

function Getapplicationstatusdetails($aobj_context)
{
	$obj=new applicationForm($aobj_context);
	$obj->Getapplicationstatusdetails();
}

function Getstudentdetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	session_start();
	$regno = $aobj_context->mobj_data["regno"];

$check_dup="select count(*) as dup_cnt from dcstud
	where FREGNO='{$regno}' and ifnull(ffresher,'') = 'T'";
	$obj_check_dup=$aobj_context->mobj_db->GetRow($check_dup);				
	if($obj_check_dup[dup_cnt]>0)
	{
		$data="Fresher Students Need Not Apply for Convocation, Certificate will be sent to College / Department/ Centre";
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
		return;
	}

$check_dup="select count(*) as dup_cnt from dctran
	where FREGNO='{$regno}'";
	$obj_check_dup=$aobj_context->mobj_db->GetRow($check_dup);				
	if($obj_check_dup[dup_cnt]>0)
	{
		$data="You have already applied for Convocation Certificate. Call Help Desk in case of any clarifications.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
		return;
	} 
	
	
	$query = "select distinct dcstud.FREGNO,ifnull(dcstud.FCERTNO,'') as FCERTNO, dcstud.FNAME,  concat(college.FCOLLNAME,', ',college.FTOWN) as FCOLLNAME, degree.FDESCPN,ifnull(dcstud.FCASTE,'') as FCASTE,
	mascnvfee.FCNVNAME,if(FCASTE ='SC' OR FCASTE ='ST',(mascnvfee.FSCSTFEE - ifnull(dcstud.fprevpaid,0)),(mascnvfee.FFEE - ifnull(dcstud.fprevpaid,0))) as Fee  from dcstud, college, degree, mascnvfee 
	where dcstud.FCOLLCODE = college.FCOLLCODE and dcstud.FDEGREE = degree.FDEGREE 
	and mascnvfee.FCNVNO =  dcstud.FCNVNO and dcstud.FREGNO='{$regno}'";
	$rst = $aobj_context->mobj_db->GetRow($query);
	if($rst)
	{
		if($rst[FCERTNO] !='')
		{
			$error_msg = "Convocation Certificate already printed";
			echo $aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure"); 
			return;
		}	
		else
		{	
			echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); 
			return;
		}	
			
	}		
	else
	{	
		$error_msg = 'Not a valid Register no, Please check once again or <br><b>Contact Help desk 8183098136 / 138</b>';
		echo $aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure");
		return;	
	}				
}

function replaceChars($name)
{
	$spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ","");
	$link_name = strtolower(str_replace($spl_char,"_",$name));
	return str_ireplace("__","_",$link_name);
}

function generateRandomString($length = 8)
{
    return substr(sha1(rand()), 0, $length);
}

function Getcnvcategoryfee($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	session_start();
	$regno = $aobj_context->mobj_data["regno"];
	$catcode = $aobj_context->mobj_data["catcode"];

$query = " select if('{$catcode}' ='SCST',(mascnvfee.FSCSTFEE - ifnull(dcstud.fprevpaid,0)),(mascnvfee.FFEE - ifnull(dcstud.fprevpaid,0))) as Fee
	from mascnvfee,dcstud 
	where mascnvfee.FCNVNO = dcstud.FCNVNO and dcstud.FREGNO = '{$regno}'";
	$rst = $aobj_context->mobj_db->GetRow($query);
	$arr['fee'] = $rst[Fee]; 
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;
}
?>

${this.title}

Code Editor : student_13032020.php