Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
admin.php	3.34 KB	-rwxr-xr-x
cManualMailer.php	1.38 KB	-rwxr-xr-x
candidate_certificate.php	6.73 KB	-rwxr-xr-x
cnvdetails.php	3.61 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
sendGridMail.php	1.17 KB	-rwxr-xr-x
sendsmsapi.php	1014 B	-rwxr-xr-x
student.php	42.78 KB	-rwxr-xr-x
student03032017.php	33.84 KB	-rwxr-xr-x
student06092016.php	30.58 KB	-rwxr-xr-x
student10042017.php	35.89 KB	-rwxr-xr-x
student13062016.php	29.43 KB	-rwxr-xr-x
student14112016.php	32.08 KB	-rwxr-xr-x
student18042017.php	36.08 KB	-rwxr-xr-x
student22.php	34.45 KB	-rwxr-xr-x
student_08032018.php	42.05 KB	-rwxr-xr-x
student_23082017.php	36.13 KB	-rwxr-xr-x
student_cug.php	42.77 KB	-rwxr-xr-x
student_mohan.php	35 KB	-rwxr-xr-x
student_old.php	32.46 KB	-rwxr-xr-x
test.php	3.38 KB	-rwxr-xr-x

Code Editor : candidate_certificate.php

<?php

class candidate_certificate
{

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->collcode=$_SESSION['f_college_code'];
		$this->login_cnt=$_SESSION['login_cnt'];
		$this->f_user_name=$_SESSION['f_user_name'];
	}
	 function GetCandidateCertificates()
	 {
		 $from_app = trim($this->aobj_context->mobj_data["from_app"]);
		 $to_app   = trim($this->aobj_context->mobj_data["to_app"]);
		 $status   = trim($this->aobj_context->mobj_data["status"]);
		 
		if($status == 'Pending')
		{
			$cnd = "and ifnull(fpaystatus,'') <> 'success'";
			
		}else if($status == 'Paid')	
		{
			$cnd = "and fpaystatus = 'success'";

}else
		{
			$cnd = "and 1=1";
		}
		 
		 
		$lquery = "select dc.fappno,dc.fregno,dc.fname,dc.fmobile,dc.femail,dc.fhiname,sd.fdegree,dc.famount,ifnull(dc.fpaystatus,'Pending') as fpaystatus from dctran dc
				inner join dcstud sd on (dc.fregno = sd.FREGNO or dc.fregno = sd.FENROLL) where dc.fappno between '{$from_app}' and '{$to_app}' {$cnd}";
	//	var_dump($lquery);
		$lresult = $this->aobj_context->mobj_db->GetAll($lquery);	
		
		  $html=' <div class="row"> <div class="col-md-10"> <div class="portlet box green">
						<div class="portlet-title">
							<div class="caption">
								<i class="fa fa-picture"></i>Candidate List
							</div>
							 
						</div>
						<div class="portlet-body">
							<div class="table-responsive">
								<table class="table table-condensed table-hover">
								<thead>
								<tr>
									<th>
										Sl. No.
									</th>
									<th>
										APP No
									</th>
									<th>
										Roll. No.  
									</th>
									<th>
										Candidate Name
									</th>
									<th>
										Degree
									</th>
									<th>
										 Mobile No.
									</th>
								
									<th>
										 Email Id
									</th>
									<th>
										Hindi Name
									</th>
									<th>
										  Amount
									</th>
									<th>
										  Payment Status
									</th>
								</tr>
								</thead>
								<tbody>';
								$sl=1;
								$col_span="9";
							foreach($lresult as $ak=>$av)
							{
								 $html.="<tr ondblclick = \"javascript:cms.viewcandidatedetails('{$av['fappno']}','{$av['fregno']}')\">";
								 $html.="<td>{$sl}</td>";
								 $html.="<td>{$av['fappno']}</td>";
								 $html.="<td>{$av['fregno']}</td>";
								 $html.="<td>{$av['fname']}</td>";
								 $html.="<td>{$av['fdegree']}</td>";
								 $html.="<td>{$av['fmobile']}</td>";
								 $html.="<td>{$av['femail']}</td>";
								 $html.="<td>{$av['fhiname']}</td>";
								 $html.="<td>{$av['famount']}</td>";
								 $html.="<td>{$av['fpaystatus']}</td>";
								 $html.="</tr>";								 
								 $sl++;
							}		
							 
							 $html.='</tbody>
								</table>
							</div>
						</div>
						</div>
					</div></div>';
		  $arr['html']=$html;
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Success"); 
			return;
	}
	
	function GetCandidateDetails()
	{
		$collcode=trim($this->aobj_context->mobj_data["collcode"]);
		$appno=trim($this->aobj_context->mobj_data["appno"]);
		 
		$lquery = "select dc.*,sd.fdegree from dctran dc
				  inner join dcstud sd on (dc.fregno = sd.FREGNO or dc.fregno = sd.FENROLL) 
				  where fpaystatus = 'success' and dc.fappno = '{$appno}' and dc.fregno = '{$collcode}'";
		$lresult = $this->aobj_context->mobj_db->GetAll($lquery);
		
		
		foreach($lresult as $ak=>$av)
		{
			$html = "<div class='portlet-body form' style='margin-left:10px;'>
			<div class='row'><div class='col-md-10'> <div class='portlet box green'>
			<div class='portlet-title'>
			<div class='caption'>
			<i class='fa fa-picture'></i>Candidate Details
			</div>
			</div>	 
			</div>
			
			<form  class='form-horizontal' id='form_module_details_upload' enctype='multipart/form-data' method='POST'> 
			<div class='col-md-8'>

<div class='form-body' >
			<div class='form-group' >
			<label class='col-md-3 control-label'  style='text-align:left;font-size:18px;'>Application no.</label>
			<label class='col-md-5 control-label'  style='text-align:left;font-size:18px;'>
			{$av['fappno']}									
			</label>
			</div>	
			<div class='form-group'>
			<label class='col-md-3 control-label'  style='text-align:left;'>College</label>
			<label class='col-md-5 control-label' style='text-align:left;'>
			{$av['collname']}
			</label>
			</div>	
			<div class='form-group'>
			<label class='col-md-3 control-label'  style='text-align:left;'>Degree</label>
			<label class='col-md-5 control-label' style='text-align:left;'>
			{$av['FDESCPN']}									
			</label>
			</div>	
			
			<div class='form-group'>
			<label class='col-md-3 control-label'  style='text-align:left;'>Candidate name</label>
			<label class='col-md-5 control-label' style='text-align:left;'>
			{$av['FNAME']}	
			</label>
			</div>	
			<div class='form-group'>
			<label class='col-md-3 control-label'  style='text-align:left;'>DOB</label>
			<label class='col-md-5 control-label' style='text-align:left;'>
			{$av['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='{$av[FPHOTOPATH]}' class='img-responsive' >
			</div>

</div>		
			</form> 
			</div>
			<div class='form-body' style='clear:both;'>
			<h3 class='form-section'>Personnel Information</h3>

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

</div>

<div class='col-md-3'>
			<div class='form-group'>
			<label>Mobile No. : </label>
			{$av['FMOBILE']}
			</div>
			</div>
			<div class='col-md-3'>
			<div class='form-group'>
			<label>Email Id. : </label>
			{$av['FEMAIL']}												
			</div>
			</div>
			
			</div>
			</div>		
			<div class='row'>
			<div class='col-md-10'>
			<div  id='emp_docs_div'>

</div>
			</div>
			</div>	
			</div></div>";	
		}
		 $arr['html']=$html;
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Success"); 
		return;
	}
	
}

function GetCollwiseCandidateList($aobj_context)
	{ 
		$obj=new candidate_certificate($aobj_context);
		$obj->GetCandidateCertificates();
	}
	
	function GetCandidateDetails($aobj_context)
	{
		$obj=new candidate_certificate($aobj_context);
		$obj->GetCandidateDetails();
	}

${this.title}

Code Editor : candidate_certificate.php