Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
adm_nationality_doc.php	1.52 KB	-rw-rw-r--
applicationfromreport.php	35.52 KB	-rwxr-xr-x
applicationfromreport_old.php	18.42 KB	-rwxr-xr-x
applicationreport.php	37.6 KB	-rwxr-xr-x
candidate_certificate.php	16.11 KB	-rwxr-xr-x
getnumword.php	7.15 KB	-rwxr-xr-x
pending_certificate.php	11.96 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
student.php	41.2 KB	-rwxr-xr-x
student_19082019.php	25.39 KB	-rwxr-xr-x
student_old.php	23.37 KB	-rwxr-xr-x

Code Editor : pending_certificate.php

<?php
	class pending_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->login_cnt=$_SESSION['login_cnt'];
			$this->f_user_name=$_SESSION['f_user_name'];
			$this->collcode=$_SESSION['f_college_code'];
			$query = 'Select * from control';
			$rst = 	$aobj_context->mobj_db->GetRow($query);	
			$this->appstatus = $rst['FAPPROVE'];
		}
		
		function GetPendingCertificates()
		{
			$from_app=trim($this->aobj_context->mobj_data["from_app"]);
			$to_app=trim($this->aobj_context->mobj_data["to_app"]);

$get_qry="SELECT s.FAPPNO,s.FNAME,s.FCOLLCODE,s.FDEGREE,s.FROLLNO
			FROM studadm s 
			WHERE IFNULL(s.FSTUDSTATUS,'New')='New'
			AND IFNULL(s.FAPPNO,'')!=''
			#and FPAYMENTSTATUS = 'success'
			and s.FAPPNO>='{$from_app}' and s.FAPPNO<='{$to_app}' and s.FCOLLCODE = '{$this->collcode}'
			GROUP BY s.FAPPNO ORDER BY s.FROLLNO,s.FAPPNO";
			//var_dump($get_qry);
			$this->aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=10000");
			$up_obj=$this->aobj_context->mobj_db->GetAll($get_qry);

$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>Pending Certificates
			</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>
			Candidate Name
			</th>
			<th>
			College
			</th>
			<th>
			Degree
			</th>
			<th>
			Reg. No.
			</th>';
			if($this->appstatus <> 'T')	
			{	
				$html.='<th class="text-left">
				Approve / Reject
				</th>';
			}	
			$html.='</tr></thead><tbody>';
			$sl=1;
			$col_span="9";
			foreach($up_obj as $ak=>$av)
			{
				/* $docs=$av['docs'];
				if(empty($docs))
					$doc_tr="<span style='color:red;'>No Documents found</span>";
				else
				{
					$doc_tr="";
					$exp_arr=explode(",",$docs);
					$s=1;
					foreach($exp_arr as $ek=>$ev)
					{
						$arr_exp=explode("->",$ev);
						$doc_tr.="&nbsp;&nbsp;&nbsp;&nbsp;<a style='color:blue;'target='_new' href={$arr_exp[1]}>{$s}.&nbsp;{$arr_exp[0]} </a><br>";
						$s++;
					}
				} */
				$html.="<tr ondblclick = \"javascript:CMS.viewCollCandidateDetails('{$av['FAPPNO']}','{$av['FCOLLCODE']}','pending')\" >";
				$html.="<td>{$sl}</td>";
				$html.="<td>{$av['FAPPNO']}</td>";
				$html.="<td>{$av['FNAME']}</td>";
				$html.="<td>{$av['FCOLLCODE']}</td>";
				$html.="<td>{$av['FDEGREE']}</td>";
				$html.="<td>{$av['FROLLNO']}</td>";
				//$html.="<td>{$av['FQAULEXAMREGNO']}</td>";
				if($this->appstatus <> 'T')	
				{	
					$html.="<td><a class='btn btn-xs green' href=\"javascript:CMS.ApproveRejectCertificate('{$av['FAPPNO']}','Approved')\">
					Approve <i class='fa fa-check-circle'></i>
					</a>&nbsp;&nbsp;
					<a class='btn btn-xs red'  href=\"javascript:CMS.ApproveRejectCertificate('{$av['FAPPNO']}','Rejected')\">
					Reject <i class='fa fa-ban'></i>
					</a></td>";
				}			
				/* $html.="<td><a class='btn btn-xs blue' href=\"javascript:CMS.ShowCertficateToggle('{$sl}')\">
				Documents <i class='fa fa-code-fork'></i>
				</a></td>";	 */		
				$html.="</tr>";
				$html.="<tr id='cert_tr_{$sl}' style='display:none;'> <td colspan={$col_span}> {$doc_tr} </td> </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 GetVerifiedCertificates()
		{
			$from_app=trim($this->aobj_context->mobj_data["from_app"]);
			$to_app=trim($this->aobj_context->mobj_data["to_app"]);

$get_qry="SELECT s.FAPPNO,s.FNAME,s.FCOLLCODE,s.FDEGREE,s.FROLLNO,s.FSTUDSTATUS
			FROM studadm s 
			WHERE IFNULL(s.FSTUDSTATUS,'New')!='New'
			AND IFNULL(s.FAPPNO,'')!=''
			and s.FAPPNO>='{$from_app}' and s.FAPPNO<='{$to_app}' and s.FCOLLCODE = '{$this->collcode}'
			GROUP BY s.FAPPNO ORDER BY s.FROLLNO,s.FAPPNO";
			//var_dump($get_qry);
			$this->aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=10000");
			$up_obj=$this->aobj_context->mobj_db->GetAll($get_qry);

$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>Verified Certificates
			</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>
			Candidate Name
			</th>
			<th>
			College
			</th>
			<th>
			Degree
			</th>
			<th>
			Reg No
			</th>';
			if($this->appstatus <> 'T')	
			{
				$html.='<th class="text-left">
				Status
				</th>';
			}	
			$html.='</tr></thead><tbody>';
			$sl=1;
			$col_span="9";
			foreach($up_obj as $ak=>$av)
			{
				$FAPPROVESTATUS=$av['FSTUDSTATUS'];
				$docs=$av['docs'];
				if(empty($docs))
					$doc_tr="<span style='color:red;'>No Documents found</span>";
				else
				{
					$doc_tr="";
					$exp_arr=explode(",",$docs);
					$s=1;
					foreach($exp_arr as $ek=>$ev)
					{
					$arr_exp=explode("->",$ev);
					$doc_tr.="&nbsp;&nbsp;&nbsp;&nbsp;<a style='color:blue;'target='_new' href={$arr_exp[1]}>{$s}.&nbsp;{$arr_exp[0]} </a><br>";
					$s++;
					}

}
				$html.="<tr ondblclick = \"javascript:CMS.viewCollCandidateDetails('{$av['FAPPNO']}','{$av['FCOLLCODE']}','verified')\">";
				$html.="<td>{$sl}</td>";
				$html.="<td>{$av['FAPPNO']}</td>";
				$html.="<td>{$av['FNAME']}</td>";
				$html.="<td>{$av['FCOLLCODE']}</td>";
				$html.="<td>{$av['FDEGREE']}</td>";
				$html.="<td>{$av['FROLLNO']}</td>";
				//$html.="<td>{$av['FQAULEXAMREGNO']}</td>";
				if($this->appstatus <> 'T')	
				{
					if($FAPPROVESTATUS=="Approved")
						$status_data="<span class='label label-sm label-success'>
					{$FAPPROVESTATUS}
					</span>";
					else if($FAPPROVESTATUS=="Rejected")
						$status_data="<span class='label label-sm label-danger'>
					{$FAPPROVESTATUS}
					</span>";
					else 
						$status_data="<span class='label label-sm label-warning'>
					{$FAPPROVESTATUS}
					</span>";
					$html.="<td>{$status_data}</td>";	
				}		
				/* $html.="<td><a class='btn btn-xs blue' href=\"javascript:CMS.ShowCertficateToggle('{$sl}')\">
				Documents <i class='fa fa-code-fork'></i>
				</a></td>";	 */		
				$html.="</tr>";
				$html.="<tr id='cert_tr_{$sl}' style='display:none;'> <td colspan={$col_span}> {$doc_tr} </td> </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 ApproveRejectCertificate()
		{
			$FAPPNO=trim($this->aobj_context->mobj_data["FAPPNO"]);
			$status=trim($this->aobj_context->mobj_data["status"]);
			$remarks=trim($this->aobj_context->mobj_data["remarks"]);
			$qry=" update studadm set 
			FSTUDSTATUS='{$status}',
			FAPPROVEDBY='{$this->f_user_name}',
			FAPPROVEDDATE=now(),FREMARKS = '{$remarks}'
			where FAPPNO='{$FAPPNO}' and FCOLLCODE='{$this->collcode}'";
			//var_dump($qry);
			$up_obj=$this->aobj_context->mobj_db->Execute($qry);
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		}
		
		
		function DisplayAllAckExamApplications()
		{
			 	$app_no_from = trim($this->aobj_context->mobj_data["app_from_app"]);
				//$app_no_to.= $app_no_from;
				$app_no_from = stripslashes($app_no_from);
				$app_no_from = substr($app_no_from, 0, -1);
				$fisrt = true;
			
					//$condition = "AND s.FAPPNO ='{$app_no_from}'";
					$condition = "AND s.FAPPNO in({$app_no_from})";
				
				$get_qry="SELECT s.FAPPNO,s.FNAME,s.FCOLLCODE,s.FDEGREE,s.FROLLNO,s.FSTUDSTATUS
							FROM studadm s 
							WHERE IFNULL(s.FSTUDSTATUS,'New')='New'
							AND IFNULL(s.FAPPNO,'')!=''
							{$condition} and s.FCOLLCODE = '{$this->collcode}'
							GROUP BY s.FAPPNO ORDER BY s.FAPPNO";		
				$lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_qry);
				
				//var_dump($get_qry);
				
				
				//var_dump($get_qry);
				if($fisrt)
				{	
					$html.="<div class='row'> <div class='col-md-10'> <div class='portlet box green'>
							<div class='portlet-title'>
							<div class='caption'>
							<i class='a fa-picture'></i>Verified Certificates
							</div>
							</div>
							<div class='portlet-body'>
							<div class='table-responsive'>";
					$html.="<table style='' class='table table-condensed table-hover' id='reval_table_data' width='780px;' border='0' cellspacing='0' cellpadding='0'>";
					$html.="<tr>";
					$html.="<td >Sl. No.</td>";
					$html.="<td >Application No</td>";
					$html.="<td >Student Name</td>";
					$html.="<td >Collge</td>";
					$html.="<td >Degree</td>";
					$html.="<td >Reg. No.</td>";
					$html.="<td >Select</td>";
					$html.="</tr>";
					$fisrt = false;
				} 
				
				$APPNO=$av['FAPPNO'];
				$FREGNO=$av['FREGNO'];
				$FCOLLCODE=$av['FCOLLCODE'];
				$FNAME=$av['FNAME'];
				$FDEGREE=$av['FDEGREE'];
				$FROLLNO=$av['FROLLNO'];
				$FACKDATE = $av['FACKDATE'];
	 
			$k=0;
			$sl_no=1;
			foreach($lobj_get_data as $ak=>$av)
			{
				$strPos = strpos($this->collcode,'P');
				if($this->user_type != 'SuperUser' && ($striPos != 0) && $this->user_type != 'Admin')
				{
					if($av['FPAYMENTYPE'] == 'POSTOFFICE' || $av['FPAYMENTYPE'] == 'DEBIT/CREDIT/NET BANKING')
					{
						$disabled = 'disabled';
					}
					else
					{
						$disabled= '';
					}
				}
				
				$APPNO=$av['FAPPNO'];
				$FREGNO=$av['FREGNO'];
				$FCOLLCODE=$av['FCOLLCODE'];
				$FNAME=$av['FNAME'];
				$FDEGREE=$av['FDEGREE'];
				$FROLLNO=$av['FROLLNO'];
				$FACKDATE = $av['FACKDATE'];

if($FACKDATE != '')
				{
					$disabled = 'disabled checked';
				}
				else
				{
					$disabled = 'checked';
				}
				if($k%2==0)
				$class='tbl_row1';
				else
				$class='tbl_row_alter1';

$html.="<tr ondblclick = \"javascript:CMS.viewCollCandidateDetails('{$av['FAPPNO']}','{$av['FCOLLCODE']}','verifiedbarcode')\">";
				$html.="<td>{$sl_no}</td>";
				$html.="<td>{$av['FAPPNO']}</td>";
				$html.="<td>{$av['FNAME']}</td>";
				$html.="<td>{$av['FCOLLCODE']}</td>";
				$html.="<td>{$av['FDEGREE']}</td>";
				$html.="<td>{$av['FROLLNO']}</td>";
				$html.="<td align='center'><input type='checkbox' {$disabled}  id='ack_check_box_{$APPNO}' /></td></tr>"; 
				$sl_no++;
				$k++;
			}
			$html.='</table>
					</div>
					</div>
					</div>
					</div></div>';			
			$arr['html']=$html;
			$arr['app_no']=$app_no_from;
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 	
			 
		}
		
		function AcknowledgeSelectedExamApplications()
		{
			$checked_app_nos = ($this->aobj_context->mobj_data["checked_app_nos"]);
			$exp_arr=explode(",",$checked_app_nos);
			foreach($exp_arr as $apk)
			{
				$update =" update studadm 
				set FAPPROVEDBY='{$this->f_user_name}',FAPPROVEDDATE=now(),FSTUDSTATUS = 'Approved'
				where FAPPNO='{$apk}'
				and FCOLLCODE='{$this->collcode}'";
				$lobj_get_data = $this->aobj_context->mobj_db->Execute($update);
			}
			$data="Application(s) acknowledged successfully.";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success");
				
		}
		
	}

${this.title}

Code Editor : pending_certificate.php